tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: louise_kitchen__24091__NEWCO HEADCOUNT NAMES
Sheet: Portland Trading & Origination

 | West Power Trading - Portland & Orig |  |  | ok
 | Salisbury | Holden | Analyst
 | Slinger | [NAME] | Analyst
 | [NAME] | Geir | Analyst
 | Driscoll | [NAME] | Analyst
 | Mallory | [NAME] | Analyst | 5
 | Stokley | [NAME] | Associate | 1
 | Shields | [NAME] | Director
 | Etringer | [NAME] | Director
 | Choi | [NAME] | Director
 | Rosman | [NAME] | Director
 | Malowney | [NAME] | Director
 | [NAME] | [NAME] | Director
 | Badeer | [NAME] | Director
 | Motley | [NAME] | Director
 | Crandall | Sean | Director
 | Scholtes | [NAME] | Director
 | Fischer | Mark | Director
 | [NAME] | [NAME] | Director
40 | Richter | [NAME] | Director | 13
 | Calger | [NAME] | Director, Managing
 | Belden | [NAME] | Director, Managing | 2
 | Buerkle | [NAME] | Manager
 | Lackey | [NAME] | Manager
 | Woodland | [NAME] | Manager
 | Wente | [NAME] | Manager
 | Thome | [NAME] | Manager | 5
 | [NAME] | [NAME] | Spec
 | [NAME] | [NAME] | Spec
 | Guzman | Mark | Spec
 | Meyers | [NAME] | Spec
 | Mier | [NAME] | Spec | 5
 | Rawson | Les | Sr. Spec | 1
 | [NAME] | Jake | Vice Pres
 | McDonald | [NAME] | Vice Pres
 | [NAME] | [NAME] | Vice Pres
 | Swerzbin | [NAME] | Vice Pres | 4
 |  |  | TOTAL
Spreadsheet: 011bde9b-ea3a-4bd0-9e94-2d590e0d1a03
Sheet: June

Year End: | June
Year:
Monthly CACFP Reimbursement:
Monthly Food Program Expenses:
Amount Needed from Other Funding Source:
Date | Check Number | Name (Payee on Check) | Total Amount of Check | Administrative Salaries and Benefits | Travel Expenses (include monitoring staff) | Printing, Office Supplies, Communications | Staff Training | Food Service Salaries and Benefits | Food (include delivery charges) | Purchased Vended Meals | Food Service Equipment | Allowable Nonfood Supplies | Occupancy/ Utilities | [NAME]. | Specify Misc.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL
Monthly CACFP Expenses:
End of worksheet
Spreadsheet: 124187d1318230191-excel-2007-finding-information-on-a-table-indexmatch-simple
Sheet: Codes

One-Dimensional database |  |  |  |  |  | Two-Dimensional database
Codes | Issue | [NAME] | Size | Priority |  |  | Cat | Dog | Bird | Lizard
132 | Scanner usb cable disconneted | Loc4 | SM | 1 |  | Red | 22 | 11 | 12 | 111
139 | Scanner Power cable out | Loc3 | LRG | 2 |  | Blue | 33 | 66 | 14 | 222
149 | Printer paper [NAME] | Loc2 | MED | 3 |  | Yellow | 44 | 77 | 16 | 333
211 | CRT cable disconnected | [NAME] | SM | 4 |  | Green | 55 | 99 | 19 | 444
Spreadsheet: darrell_schoolcraft__7310__imball0201
Sheet: Citizens

Citizens Communications
 | Measured | Scheduled | Imbalance
56659 | -47 | -3150
500046 | -16889 |  |  |  |  |  |  |  |  | 2000-01-06 00:00:00 | paper | 0.5
500086 |  |  |  |  |  |  |  |  |  |  | lunch | 7.6
500134 | -23976 | -43375
500528
500529
500619
INDEX
2001-12-31 00:00:00 |  |  | -537692.79
2002-01-26 00:00:00
CBS Volume
 |  |  | -36823
Spreadsheet: 758835d1639095421-sum-down-a-column-return-date-on-matching-row-running-total
Sheet: Sheet1

SO No | Location Code | Prod_ Order No_ | Ship-to Code | Ship-to Name | Load Date | Build Number | Item No_ | Description | LL Code From Item | POL Quantity | Quantity (Base) | Pull Quantity
SO-043891 | MAIN | PRD-100438 | VFC013 | Fac 1 | 2021-12-07 00:00:00 | BL1573 | BD036 | Hoagie Roll (1/48) | 1 | 160 | 0.66656 | 3.3328
SO-043944 | MAIN | PRD-100552 | VFC020 | Fac 2 | 2021-12-10 00:00:00 | BL1565 | BD036 | Hoagie Roll (1/48) | 1 | 2144 | 0.66656 | 44.65952
SO-043945 | MAIN | PRD-100554 | VFC020 | Fac 2 | 2021-12-13 00:00:00 | BL1553 | BD036 | Hoagie Roll (1/48) | 1 | 2144 | 0.66656 | 44.65952
SO-043975 | MAIN | PRD-100640 | VFC002 | Fac 3 | 2021-12-14 00:00:00 | BL1558 | BD036 | Hoagie Roll (1/48) | 1 | 1920 | 0.66656 | 39.9936
SO-044011 | MAIN | PRD-100702 | VFC020 | Fac 2 | 2021-12-16 00:00:00 | BL1558 | BD036 | Hoagie Roll (1/48) | 1 | 2144 | 0.66656 | 44.65952
SO-044011 | MAIN | PRD-100703 | VFC020 | Fac 2 | 2021-12-17 00:00:00 | BL1565 | BD036 | Hoagie Roll (1/48) | 1 | 2144 | 0.66656 | 44.65952
SO-044073 | MAIN | PRD-100848 | VFC020 | Fac 2 | 2021-12-25 00:00:00 | BL1565 | BD036 | Hoagie Roll (1/48) | 1 | 2144 | 0.66656 | 44.65952
SO-044074 | MAIN | PRD-100849 | VFC020 | Fac 2 | 2021-12-29 00:00:00 | BL1553 | BD036 | Hoagie Roll (1/48) | 1 | 2144 | 0.66656 | 44.65952
 |  |  |  |  |  |  |  | Start Date | End Date | Inventory Qty | Resulting Date
 |  |  |  |  |  |  |  | 2021-12-10 00:00:00 | 2021-12-25 00:00:00 | 4500
Spreadsheet: 586971d1534774164-how-to-remove-cell-if-it-contains-certain-text-book6-3-1-
Sheet: Sheet1

Today | I | Is
Null | need | this
is | Null | what
Null | more | Null
Null | Null | you
Monday | coffee | want?
Today | Null | is | Null | Null | Monday
I | need | Null | more | Null | coffee
Is | this | what | Null | you | want?
Spreadsheet: 008208e3-25bc-4d7b-ae93-08c22dfbbb07
Sheet: Sheet1

Season Schedule | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
Date | Game Number | Visiting Team | Visiting Score | Home Team | Home Score | Game Time/Status | Venue
2013-01-28 | 2013 | Western Conference | 7 | Eastern Conference | 6 | Final * | Dunkin' Donuts Center Providence, RI
Spreadsheet: 722484d1615294422-find-value-depending-on-changing-text-in-table-index-match-lookup-all-fail-test-file-2
Sheet: Sheet1

 | Table |  |  | Table 1 |  |  |  | Table 1 |  |  | Table 2 |  |  | Table 3 |  |  | Pick One | 0
 |  |  |  |  |  |  |  | Bananas | 0.52 |  | Bananas | 0.52 |  | Pears and Apples | 2.4 |  | Table 1 | 1
 |  |  |  |  |  |  |  | Apples | 1.49 |  | Pears and Apples | 2.4 |  | Pears | <0.5 |  | Table 2 | 2
 |  |  |  |  |  |  |  | Pears and Apples | 2.4 |  | Round Pears | 0.32 |  | Apples | 1.49 |  | Table 3 | 3
 |  |  |  |  |  |  |  | Pears | 0.4 |  | Apples | 1.49 |  | Bananas | 0.52
 | Question:
 | 1) Find me the Yellow value depending on which table is selected using what you see in the blue box. Its always pears by themselves, but the description of the pear will change and the value may not always be numerical
 | *Select the table by using the dropdown in the red box. You can not use this box to help you in the final equation
Spreadsheet: 763781d1642387655-filter-formula-to-extract-values-less-than-zero-and-ageing-120-days-filter-lto-extract-values-less-than-zero-and-ageing-greater-than-120
Sheet: Sheet1

Code | Name | Transaction Category Type | Period Month | Period Year | Reference | Sub-Reference | Date Processed | Total Invoice Value | Total VAT Value | Outstanding | Ageing |  |  |  | Outstanding | Ageing
KL9050 | Comm | Credit Note | 2 | 2022 | LP-1050 | XMTKGMA008805 | 2021-11-01 00:00:00 | -4050.35 | 0 | -3760.6 |  |  |  |  | <0 | >120
KL9050 | Comm | Invoice | 2 | 2022 | LP-1051 | XMJWJMC364805 | 2021-09-15 00:00:00 | 5544.4 | 0 | -9544.4
KL9050 | Comm | Invoice | 2 | 2022 | LP-1052 | XMTKGMA001805 | 2021-12-01 00:00:00 | 6560.6 | 0 | -3760.6
KL9050 | Comm | Credit Note | 2 | 2022 | LP-1053 | XMJ2GMK416805 | 2021-08-01 00:00:00 | -2575.72 | 0 | -3522.72 |  |  |  |  | Code | Reference | Sub-Reference | Date Processed | Total Invoice Value | Total VAT Value | Outstanding | Ageing
KL9051 | Comm | Credit Note | 2 | 2022 | LP-1054 | XMJ2GMK416806 | 2021-08-01 00:00:00 | -2575.72 | 0 | -3522.72
KL9052 | Comm | Credit Note | 2 | 2022 | LP-1055 | XMJ2GMK416807 | 2021-08-02 00:00:00 | -2575.72 | 0 | -3050.72
Spreadsheet: ca637848-c82f-40bb-b25c-727942475c14
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
FSOTA | Test | FSOTA | Sotalol (Betapace) | Sotalol (Betapace) | High Performance Liquid Chromatography with Fluorescence Detection (HPLC-FL) | Green-Top Tube (Sodium Heparin): GrnNaHp |  |  | 1 | mL | Submit only 1 of the following specimens:   Plasma Draw blood in a (green-top) sodium heparin tube(s). ([NAME] tube  is not acceptable.) Spin down and send 2 mL sodium heparin  plasma refrigerated. Note:		1. Indicate plasma on request form.    		2.  [NAME] specimen appropriately (plasma).  		3. Trough levels are most reproducible   Serum Draw blood in a plain, red-top tube(s). (Serum gel tube is not  acceptable.) Spin down and send 2 mL of serum refrigerated. Note:		1. Indicate serum on request form. 		2. Label specimen appropriately (serum). 	3. Trough levels are most reproducible | 0.3 mL NOTE: Submission of the m | Specimens other than	Plasma, serum Anticoagulants other than	Sodium heparin, EDTA. plain red-top Hemolysis	NA Thawing	NA Lipemia	NA Icteric	NA | Reference Range:  500 - 4000 ng/mL   Serum Sotalol concentrations producing beta-blockade: 500 - 4000 ng/mL      Toxic range has not been established.   Test Performed By Medtox Laboratories, Inc. 402 W County Road D St. Paul, MN 5512 | Monday through Sunday | 5 days | 7-9 days | 1 | 82491 |  |  |  |  | Medtox Laboratories, Inc
FSOTA | [NAME] | VARIES | Varies |  |  |  | Refrigerated
FSOTA | Result | Z1192 | Sotalol | Sotalol | Alphanumeric |  |  |  |  | ng/mL |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 830389d1684872937-sum-and-count-values-with-criteria-sum-and-count-values-with-criteria
Sheet: Sheet1

Salespeople |  | Salesperson | Sales | Month |  | Problem #1
[NAME] |  | Regan | 49 | May |  |  | [NAME] | $ Total Sales
[NAME] |  | [NAME] | 25 | February
Mark |  | Molly | 83 | March
Regan |  | [NAME] | 39 | May
[NAME] |  | [NAME] | 74 | April
Shaun |  | [NAME] | 78 | June
Molly |  | [NAME] | 80 | July
[NAME] |  | Heather | 23 | August |  | Problem #2
Heather |  | [NAME] | 43 | September |  |  | [NAME] | $ Sales in MAY
[NAME] |  | [NAME] | 64 | October
[NAME] |  | Mark | 91 | November
Lauren |  | Lauren | 86 | December
[NAME] |  | [NAME] | 90 | January
 |  | [NAME] | 2 | May
 |  | [NAME] | 36 | March
 |  | Shaun | 69 | April |  | Problem #3
 |  | [NAME] | 84 | May |  |  | [NAME] | Number of Sales in MAY
 |  | [NAME] | 47 | May
Spreadsheet: 682709d1592286550-formula-for-countif-with-more-than-one-vlookup-condition-criteria-sample-data-for-countifs
Sheet: Experts

Table 1: Experts Already Available in Country |  |  |  |  |  |  | Table 2: Additional Experts Requested for by Country
Country | Expert Presence | Expertise | Expert ID No |  |  |  | Country | Request # | Expertise Requested For | Number of Experts with Expertise in Country | Comment
United Kingdom | Yes | Analysis | 276 |  |  |  | United Kingdom | 1 | Education | 0 | Should return 0 (no expert with specific expertise)
United Kingdom | Yes | Analysis | 277 |  |  |  | United Kingdom | 2 | Analysis | 3 | Should return 3
United Kingdom | Yes | Analysis | 278 |  |  |  | India | 3 | Nutrition | 0 | Should return 0 (no expert with specific expertise)
Australia | Yes | Engineering | 296 |  |  |  | Australia | 4 | Assessment | 0 | Should return 0 (no expert with specific expertise)
Australia | Yes | Health | 304 |  |  |  | Australia | 5 | Engineering | 1 | Should return 1
Australia | Yes | Health | 448 |  |  |  | Australia | 6 | Health | 2 | Should return 2
Australia | Yes | Media and Communication | 600 |  |  |  | Australia | 7 | Health | 2 | Should return 2
Australia | Yes | Media and Communication | 1068 |  |  |  | Australia | 8 | Health | 2 | Should return 2
Australia | Yes | Media and Communication | 1180
Australia | Yes | Shelter | 1188
Hi, I'm trying to generate a formula that will count the number of experts with specific expertise in each country and generate the result in Column K (red text).  Table 1 shows experts already available in each country, and their areas of expertise. Table 2 shows expertise that each country is requesting for.  The aim is to assist decision making by reviewing whether the experts requested for (Table 2) for each country already exist in the same country (Table 1), and if yes, how many? If no, also important to know.  I tried but got stuck with combining COUNTIF with two VLOOKUP conditions. My challenge is to have two conditions that must be fulfilled in the formula: (a) COUNT IF the Country (Column H) in Table 2 is an exact match for the Country (Column A) in Table 1.  AND (b) COUNT IF the "Expertise" (Column C) is an exact match for "Expertise Requested For" (Column J)   These are two huge tables in actuality, and will refer to the actual table references in the formula e.g. Experts_Table[Expertise] and Requests_Table[Expertise Requested For]  Thank you for the support!
Spreadsheet: c992bebb-73be-4025-9390-e0fd92245355
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
TICRU | Test | TICRU | Titanium/Creatinine Ratio, Random, [NAME] | Titanium/Creat Ratio, Random, U | TICR/89530: Inductively Coupled Plasma-Optical Emission Spectrometry (ICP-OES) CDCR/7243: Enzymatic Colorimetric Assay |  |  |  | 3 | mL | Collection Container/Tube: Clean, plastic urine collection container  Submission Container/Tube: Plastic, 6-mL tube (Supply T465) or clean, plastic aliquot container with no metal cap or glued insert   [NAME] Volume: 3 mL Collection Instructions:  1. Collect a random urine specimen. 2. See Metals Analysis-Collection and Transport in Special Instructions for complete instructions. Additional Information: High concentrations of gadolinium and iodine are known to interfere with most metals tests. If either gadolinium- or iodine-containing contrast media has been administered, a specimen should not be collected for 96 hours. | 1 mL | Hemolysis	NA Thawing	Warm OK; Cold OK Lipemia	NA Icterus	NA Other	NA | 0-1 mcg/g Creatinine | Thursday; 5 p.m. | Same day/1 day | 7 days |  | Profile |  |  |  |  | Rochester
TICRU | [NAME] | URINE | [NAME] |  |  |  | Refrigerated | 28 days
TICRU | Component | TICR | Titanium/Creatinine Ratio, [NAME] | Titanium/Creat Ratio, U | Only orderable as part of a profile. For further information see TICRU/89530 Titanium/Creatinine Ratio, Random, [NAME]. |  |  |  |  |  | Only orderable as part of a profile. For further information see TICRU/89530 Titanium/Creatinine Ratio, Random, [NAME]. |  |  | Only orderable as part of a profile. For further information see TICRU/89530 Titanium/Creatinine Ratio, Random, [NAME]. |  |  |  | 1 | 83789 |  |  | Yes | No
TICR | [NAME] | URINE | [NAME] |  |  |  | Refrigerated | 28 days
TICR | Result | 33303 | Titanium/Creat Ratio, U | Titanium/Creat Ratio, U | Numeric |  |  |  |  | mcg/g |  |  |  |  |  |  |  |  |  | In Process
TICR | Result | 33304 | Ti Concentration | Ti Concentration | Numeric |  |  |  |  | mcg/L |  |  |  |  |  |  |  |  |  | In Process
TICRU | Component | CDCR | [NAME] | [NAME] | For further information see #8513 "Creatinine, U." |  |  |  | 5 | mL | Only orderable as part of a profile. For further information  see #8513 "Creatinine, [NAME]." |  |  |  |  |  |  |  |  |  |  | Yes | No
CDCR | [NAME] | URINE | [NAME] |  |  |  | Refrigerated | 30 days
CDCR | Result | CDCR | [NAME] | [NAME] | Numeric |  |  |  |  | mg/dL |  |  |  |  |  |  |  |  |  | 35674-1
Spreadsheet: 86525d1286482763-vlookup-multiple-entries-book1
Sheet: Data

Unique ID | SKPBN | WHSBN | [NAME] | WHLBN | WHBBN | S76BN | Exp Date
 | 228020165 | 6 | 115 | 10 | 08 | Y
 | 228020165 | 6 | 116 | 30 | 13 | N
 | 228020165 | 6 | 116 | 20 | 27 | N
 | 228020200 | 6 | 115 | 10 | 12 | Y
 | 228020200 | 6 | 115 | 20 | 12 | N
 | 228020291 | 6 | 115 | 10 | 13 | Y
 | 228020291 | 6 | 115 | 20 | 19 | N
 | 228020291 | 6 | 115 | 20 | 25 | N
 | 228021666 | 6 | 115 | 30 | 07 | N
 | 228021666 | 6 | 115 | 30 | 08 | N
 | 228021666 | 6 | 115 | 10 | 09 | Y
 | 228021666 | 6 | 115 | 30 | 17 | N
 | 228021666 | 6 | 115 | 30 | 19 | N
 | 228021666 | 6 | 116 | 30 | 26 | N
 | 228021666 | 6 | 116 | 30 | 36 | N
 | 228021669 | 6 | 114 | 10 | 30 | Y
 | 228021669 | 6 | 116 | 50 | 01 | N
 | 228021675 | 6 | 115 | 10 | 10 | Y
 | 228021675 | 6 | 115 | 50 | 36 | N
 | 228021677 | 6 | 115 | 10 | 07 | Y
 | 228021677 | 6 | 115 | 40 | 25 | N
 | 228021677 | 6 | 119 | 30 | 22 | N
 | 228021681 | 6 | 114 | 20 | 33 | N
 | 228021681 | 6 | 115 | 10 | 11 | Y
 | 228021681 | 6 | 116 | 20 | 13 | N
 | 228021681 | 6 | 118 | 30 | 02 | N
 | 236300150 | 6 | 114 | 50 | 03 | N
 | 236300150 | 6 | 114 | 10 | 32 | Y
 | 236300154 | 6 | 114 | 20 | 23 | N
 | 236300154 | 6 | 114 | 10 | 34 | Y
 | 236300156 | 6 | 114 | 50 | 33 | N
 | 236300156 | 6 | 114 | 10 | 35 | Y
 | 236300157 | 6 | 113 | 50 | 09 | N | 2001-10-01 00:00:00
 | 236300157 | 6 | 114 | 10 | 36 | Y | 2001-11-01 00:00:00
 | 236306554 | 6 | 114 | 50 | 29 | N
 | 236306554 | 6 | 114 | 10 | 31 | Y
 | 236306556 | 6 | 114 | 50 | 01 | N
 | 236306556 | 6 | 114 | 10 | 33 | Y
 | 527465720 | 6 | 114 | 30 | 16 | N
 | 527465720 | 6 | 114 | 10 | 23 | Y
 | 527470480 | 6 | 114 | 40 | 23 | N
 | 527470480 | 6 | 114 | 40 | 24 | N
 | 527470480 | 6 | 114 | 40 | 25 | N
 | 527470480 | 6 | 114 | 10 | 26 | Y
 | 527470480 | 6 | 118 | 40 | 34 | N
 | 527470480 | 6 | 118 | 40 | 39 | N
 | 527470550 | 6 | 114 | 40 | 19 | N
 | 527470550 | 6 | 114 | 30 | 20 | N
 | 527470550 | 6 | 114 | 40 | 21 | N
 | 527470550 | 6 | 114 | 20 | 25 | N
 | 527470550 | 6 | 114 | 30 | 25 | N
 | 527470550 | 6 | 114 | 10 | 29 | Y
 | 527470560 | 6 | 114 | 50 | 13 | N
 | 527470560 | 6 | 114 | 40 | 20 | N
 | 527470560 | 6 | 114 | 10 | 24 | Y
 | 527470560 | 6 | 114 | 20 | 27 | N
 | 527470560 | 6 | 114 | 30 | 29 | N
 | 527470560 | 6 | 114 | 20 | 32 | N
 | 527470570 | 6 | 114 | 40 | 13 | N
 | 527470570 | 6 | 114 | 10 | 28 | Y
 | 527470570 | 6 | 115 | 20 | 07 | N
 | 527470570 | 6 | 115 | 20 | 08 | N
 | 527470570 | 6 | 117 | 40 | 05 | N
 | 527470570 | 6 | 119 | 30 | 42 | N
 | 763408825 | 6 | 115 | 10 | 02 | Y
 | 763408825 | 6 | 117 | 50 | 39 | N
Spreadsheet: 388434d4-573d-4e3e-ad89-43b4ff3460c3
Sheet: Sheet1

2013 SEREC  Regional Speech Entries:  May 23, 2013,  1:00 p.m. -7:00 p.m.  Animal Science Building, Lincoln | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12
 | Entries due to [EMAIL] by May 9
Note:  Each county may enter three (3) presenters in PSA and speech categories for each age division.
First Name | Last Name | County | Title of Speech/PSA | PSA or Speech | Division | Address | Town | Zip Code | [NAME] | Phone | Time Requests | Payment
Spreadsheet: jeff_dasovich__14084__Undercollection recovery rate analysis
Sheet: E20T

PG&E E-20T Customer
 |  | E-20T
 |  | Summer | Winter
Customer Charge ($/month) | $/Mo | 715 | 715
Facilities Charge ($/kW-mo) | $/kW-mo | 0.35 | 0.35
Demand Charge
Peak | $/kW-mo | 7.5 | 0
Part-Peak | $/kW-mo | 0.6 | 0.75
Off-Peak | $/kW-mo | 0 | 0
Energy Charge
Peak | $/kWh | 0.0575
Part-Peak | $/kWh | 0.04361 | 0.05369
Off-Peak | $/kWh | 0.04097 | 0.0442
Months in Season |  | 6 | 6 |  |  | Annual Load (MWh)
Load Factors |  |  |  |  |  | Summer | Winter | Total
Peak |  | 0.8 | 0.8
Part-Peak |  | 0.7 | 0.7
Off-Peak |  | 0.7 | 0.7
 |  |  |  |  | Total
Demand | MW | 1.5 | 1.5
 |  |  |  |  | Class [NAME] |  | MWh
Hours/period
Peak |  |  | 0
Part-Peak
Off-Peak
Total
Average Charges
Customer Charge ($/month) | $/mo
Facilities Charge ($/kW-mo) | $/mo
Demand Charge
Peak | $/mo
Part-Peak | $/mo
Off-Peak | $/mo
Energy Charge
Peak | $/mo
Part-Peak | $/mo
Off-Peak | $/mo
Total | $/mo
Average Rate | $/MWh
Average annual rate | $/MWh
Rate Multipliers/adders | $/MWh | 10 | 10
Current Rate | $/MWh
Average Annual Rate | $/MWh
Total Rate
Non-Gen Rate
[NAME]
Spreadsheet: 455368d1460290703-determine-frequency-over-time-determine-frequency-over-time
Sheet: Sheet1

student | 2016-04-01 00:00:00 | 2016-04-02 00:00:00 | 2016-04-03 00:00:00 | 2016-04-04 00:00:00 | 2016-04-05 00:00:00 | 2016-04-06 00:00:00 | 2016-04-07 00:00:00 | 2016-04-08 00:00:00 | 2016-04-09 00:00:00 | 2016-04-10 00:00:00 | 2016-04-11 00:00:00 | 2016-04-12 00:00:00 | 2016-04-13 00:00:00 | 2016-04-14 00:00:00 | 2016-04-15 00:00:00 | 2016-04-16 00:00:00 | 2016-04-17 00:00:00 | 2016-04-18 00:00:00 | 2016-04-19 00:00:00 | SparkLine | Trend | Slope | Average
a | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
b | 0 | 1 | 0 | 1 | 0 | 1 | 0 | 1 | 0 | 1 | 0 | 1 | 0 | 1 | 0 | 1 | 0 | 1 | 0
c | 1 | 0 | 1 | 0 | 1 | 0 | 1 | 0 | 1 | 0 | 1 | 0 | 1 | 0 | 1 | 0 | 1 | 0 | 1
d | 1 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
e | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 789618d1659244530-adding-black-space-in-a-cell-before-text-or-data-example
Sheet: Sheet1

Blank cells before text | 2 | 3 | 4 | 5 | 6 | 2 | 3 | 4
Data/TEXT | 02052022 | CO20 | HKD | USD | 3000 | 22052022 | JournalEntry | YES
Expected Results | '02052022 | CO20 | HKD | USD | 3000 | 22052022 | JournalEntry | YES
Spreadsheet: 128488d1321006395-listing-items-without-empty-cells-auction
Sheet: Seller

Seller # : | 12
Item | Price | Quantity | Total | Grand Total=
 |  |  |  | -0.15
 |  |  |  | Payout=
Spreadsheet: 836149d1689128562-simple-formula-to-describe-to-user-what-is-missing-test-sheet-1-
Sheet: Sheet1

 | A | B | C | Needed
1 | apple
2 |  | banana | orange | apple is needed
3 | apple | banana |  | orange is needed
4 |  |  | orange | apple is needed and banana is needed
5 | apple |  | orange | banana is needed
6 |  |  |  | apple is needed and banana is needed and orange is needed
7 |  | banana |  | apple is needed and orange is needed
 | A | B | C | Needed
1 | 2023-12-01 00:00:00
2 |  | 2023-03-05 00:00:00 | 2023-06-07 00:00:00 | apple is needed
3 | 2022-01-02 00:00:00 | 2021-04-07 00:00:00 |  | orange is needed
4 |  |  | 2023-04-08 00:00:00 | apple is needed and banana is needed
5 | 2022-08-09 00:00:00 |  | 2023-09-01 00:00:00 | banana is needed
6 |  |  |  | apple is needed and banana is needed and orange is needed
7 |  | 2022-08-30 00:00:00 |  | apple is needed and orange is needed
Spreadsheet: 787450d1657804955-return-date-column-header-when-value-is-expected-to-hit-target-number-planning-sheet-copy
Sheet: Sheet1

ItemNumber | Min | Date to min | NewPartsOnHand | SubOH | 2022-07-17 00:00:00 | 2022-07-24 00:00:00 | 2022-07-31 00:00:00 | 2022-08-07 00:00:00 | 2022-08-14 00:00:00 | 2022-08-21 00:00:00 | 2022-08-28 00:00:00 | 2022-09-04 00:00:00 | 2022-09-11 00:00:00 | 2022-09-18 00:00:00 | 2022-09-25 00:00:00 | 2022-10-02 00:00:00 | 2022-10-09 00:00:00 | 2022-10-16 00:00:00 | 2022-10-23 00:00:00 | 2022-10-30 00:00:00 | 2022-11-06 00:00:00 | 2022-11-13 00:00:00 | 2022-11-20 00:00:00 | 2022-11-27 00:00:00 | 2022-12-04 00:00:00 | 2022-12-11 00:00:00 | 2022-12-18 00:00:00
abcd | 25 | 2022-09-04 00:00:00 | 100 | 20 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 0
1234 | 100 | 2022-10-16 00:00:00 | 1000 |  | 50 | 50 | 50 | 75 | 75 | 50 | 150 | 50 | 50 | 75 | 100 | 50 | 50 | 50 | 75 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20