tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 123063d1317311473-variable-payment-calculator-variableloanpmt
Sheet: Sheet1

 | Loan | 1000
 | Rate | 0.06
 | Term | 20
0 |  | Principal | Interest | Sched Payment | Actual Payment | Balance
1 | 2011-10-01 00:00:00 | 1000 | 3 | -87.1845569768514 | 100 | 903
2 | 2011-11-01 00:00:00 | 903 | 2.709 | -80.92763690658585 | 50 | 855.7090000000001
3 | 2011-12-01 00:00:00 | 855.7090000000001 | 2.567127 | -79.03032295995659 | 100 | 758.2761270000001
4 | 2012-01-01 00:00:00 | 758.2761270000001 | 2.274828381 | -72.37351649497285 | 50 | 710.5509553810001
5 | 2012-02-01 00:00:00 | 710.5509553810001 | 2.131652866143 | -70.31054016442276 | 100 | 612.6826082471431
6 | 2012-03-01 00:00:00 | 612.6826082471431 | 1.838047824741429 | -63.08349477247587 | 50 | 564.5206560718846
7 | 2012-04-01 00:00:00 | 564.5206560718846 | 1.693561968215654 | -60.73390341555493 | 75 | 491.2142180401002
8 | 2012-05-01 00:00:00 | 491.2142180401002 | 1.4736426541203 | -55.48760981432481 | 200 | 292.6878606942205
9 | 2012-06-01 00:00:00 | 292.6878606942205 | 0.8780635820826614 | -34.9109385593881 | 25 | 268.5659242763031
10 | 2012-07-01 00:00:00 | 268.5659242763031 | 0.8056977728289093 | -34.05226261187166 | 97 | 172.371622049132
11 | 2012-08-01 00:00:00 | 172.371622049132 | 0.5171148661473961 | -23.41978034295125 | 44 | 128.8887369152794
12 | 2012-09-01 00:00:00 | 128.8887369152794 | 0.3866662107458382 | -18.94951016800625 | 0 | 129.2754031260253
13 | 2012-10-01 00:00:00 | 129.2754031260253 | 0.3878262093780757 | -20.81798640361635 | 50 | 79.66322933540333
14 | 2012-11-01 00:00:00 | 79.66322933540333 | 0.23898968800621 | -14.27047402563659 | 30 | 49.90221902340954
15 | 2012-12-01 00:00:00 | 49.90221902340954 | 0.1497066570702286 | -10.14824642733049 | 25 | 25.05192568047977
16 | 2013-01-01 00:00:00 | 25.05192568047977 | 0.07515577704143932 | -5.947236980415571 | 25 | 0.1270814575212107
17 | 2013-02-01 00:00:00 | 0.1270814575212107 | 0.0003812443725636321 | -0.0366746274790169 | 0.13 | -0.002537298106225688
18 | 2013-03-01 00:00:00 | -0.002537298106225688 | -7.611894318677065e-06 | 0.000949228119513912 |  | -0.002544910000544365
19 | 2013-04-01 00:00:00 | -0.002544910000544365 | -7.634730001633095e-06 | 0.001388087804180411 |  | -0.002552544730545999
20 | 2013-05-01 00:00:00 | -0.002552544730545999 | -7.657634191637995e-06 | 0.002705697414378756 |  | -0.002560202364737636
Spreadsheet: 871194d1717592221-countif-with-a-range-an-criteria-declared-in-a-let-statement-countspill-aligw
Sheet: Sheet1

 |  |  | ItemList |  | Name | Item |  |  | Helper | result
 |  |  | A |  | [NAME] | A | [NAME]
 |  |  | B |  | [NAME] | B |  | #[NAME]! | C | 0
 |  |  | C |  | [NAME] | C |  | #[NAME]! | D | 1
 |  |  | D |  | [NAME] | D |  | #[NAME]! | E | 1
 |  |  | E |  | [NAME] | D |  | #[NAME]! | F | 1
 |  |  | F |  | [NAME] | D |  | #N/A |  | 1
 |  |  | G |  | [NAME] | A |  | #N/A |  | 0
 |  |  | H |  | [NAME] | E |  | #N/A |  | 0
 |  |  |  |  | [NAME] | E
 |  |  |  |  | [NAME] | A
 |  |  |  |  | [NAME] | F
 |  |  |  |  | [NAME] | D
 |  |  |  |  | [NAME] | F
Spreadsheet: 700159d1603020878-want-to-count-information-in-visable-rows-after-sorting-sample
Sheet: Sheet2

Date | Occurences
2020-01-02 00:00:00 | 3
2020-01-03 00:00:00 | 19
2020-01-06 00:00:00 | 22
2020-01-07 00:00:00 | 20
2020-01-08 00:00:00 | 26
2020-01-09 00:00:00 | 17
2020-01-10 00:00:00 | 4
2020-01-13 00:00:00 | 11
2020-01-14 00:00:00 | 10
2020-01-15 00:00:00 | 5
2020-01-16 00:00:00 | 6
2020-01-17 00:00:00 | 2
2020-01-21 00:00:00 | 2
2020-01-22 00:00:00 | 1
2020-01-23 00:00:00 | 10
2020-01-27 00:00:00 | 45
2020-01-28 00:00:00 | 27
2020-01-29 00:00:00 | 1
2020-01-30 00:00:00 | 20
2020-01-31 00:00:00 | 1
2020-02-03 00:00:00 | 22
2020-02-04 00:00:00 | 4
2020-02-05 00:00:00 | 6
2020-02-06 00:00:00 | 6
2020-02-10 00:00:00 | 7
2020-02-11 00:00:00 | 1
2020-02-12 00:00:00 | 5
2020-02-13 00:00:00 | 3
2020-02-14 00:00:00 | 2
2020-02-19 00:00:00 | 1
2020-02-20 00:00:00 | 8
2020-02-21 00:00:00 | 7
2020-02-24 00:00:00 | 21
2020-02-26 00:00:00 | 9
2020-02-27 00:00:00 | 2
2020-02-28 00:00:00 | 4
2020-03-02 00:00:00 | 10
2020-03-05 00:00:00 | 2
2020-03-06 00:00:00 | 1
2020-03-09 00:00:00 | 4
2020-03-10 00:00:00 | 1
2020-03-12 00:00:00 | 3
2020-03-16 00:00:00 | 2
2020-03-18 00:00:00 | 1
2020-03-19 00:00:00 | 2
2020-03-20 00:00:00 | 1
2020-03-24 00:00:00 | 1
2020-03-26 00:00:00 | 2
2020-04-16 00:00:00 | 3
2020-04-17 00:00:00 | 9
2020-04-20 00:00:00 | 6
2020-04-21 00:00:00 | 22
2020-04-22 00:00:00 | 2
2020-04-23 00:00:00 | 21
2020-04-24 00:00:00 | 15
2020-04-27 00:00:00 | 5
2020-04-28 00:00:00 | 2
2020-04-29 00:00:00 | 3
2020-04-30 00:00:00 | 10
2020-05-01 00:00:00 | 15
2020-05-04 00:00:00 | 79
2020-05-05 00:00:00 | 26
2020-05-07 00:00:00 | 41
2020-05-08 00:00:00 | 16
2020-05-11 00:00:00 | 18
2020-05-12 00:00:00 | 2
2020-05-13 00:00:00 | 1
2020-05-14 00:00:00 | 28
2020-05-15 00:00:00 | 7
2020-05-18 00:00:00 | 2
2020-05-20 00:00:00 | 1
2020-05-22 00:00:00 | 4
2020-05-27 00:00:00 | 4
2020-05-28 00:00:00 | 2
2020-05-29 00:00:00 | 1
2020-06-01 00:00:00 | 2
2020-06-02 00:00:00 | 1
2020-06-05 00:00:00 | 1
2020-06-08 00:00:00 | 1
2020-06-11 00:00:00 | 13
2020-06-12 00:00:00 | 22
2020-06-15 00:00:00 | 204
2020-06-16 00:00:00 | 7
2020-06-18 00:00:00 | 34
2020-06-19 00:00:00 | 1
2020-06-22 00:00:00 | 129
2020-06-23 00:00:00 | 10
2020-06-24 00:00:00 | 4
2020-06-25 00:00:00 | 52
2020-06-26 00:00:00 | 10
2020-06-29 00:00:00 | 63
2020-06-30 00:00:00 | 11
2020-07-01 00:00:00 | 1
2020-07-08 00:00:00 | 2
2020-07-10 00:00:00 | 1
2020-07-14 00:00:00 | 2
2020-07-16 00:00:00 | 1
2020-07-17 00:00:00 | 5
2020-07-20 00:00:00 | 1
2020-07-21 00:00:00 | 1
2020-07-24 00:00:00 | 11
2020-07-27 00:00:00 | 8
2020-07-28 00:00:00 | 4
2020-07-29 00:00:00 | 10
2020-07-30 00:00:00 | 16
2020-07-31 00:00:00 | 16
Spreadsheet: 786812d1657462963-formula-to-find-difference-of-values-within-a-range-with-respect-to-a-reference-value-value-find-file
Sheet: Sheet1

 |  |  |  |  |  | 4
 |  |  |  |  |  |  | Values to Compare | Expected Results 1 | Values to Compare | Expected Results 2
 |  |  |  |  |  | 10 | 10 | -4 | 10 | 4
 |  |  |  |  |  | 11 | 11 | -5 | 11 | 5
 |  |  |  |  |  | 9 | 5 | 7 | 5 | -7
 |  |  |  |  |  | 12
 |  |  |  |  |  | 11
 |  |  |  |  |  | 6
 |  |  |  |  |  | 8
 |  |  |  |  |  | 14
 |  |  |  |  |  | 9
 |  |  |  |  |  | 10
 |  |  |  |  |  | 11
Spreadsheet: 645680b6-5cdb-4a31-9fd4-d453c40b4aa9
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
FEU | Test | FEU | Iron, 24 Hour, [NAME] | Iron, 24 Hr, U | Inductively Coupled Plasma-Optical Emission Spectrometry (ICP-OES) | [NAME], 24-hour graduated: 24Urine |  |  | 10 | mL | Collection Container/Tube: Clean, plastic urine container with no metal cap or glued insert Submission Container/Tube: Plastic, 10-mL urine tube (Supply T068) or a clean, plastic aliquot container with no metal cap or glued insert [NAME]: 10 mL Collection Instructions: 1. Collect urine for 24 hours. 2. No preservative. 3. See Metals Analysis-Collection and Transport in Special Instructions for complete instructions. 4. Refrigerate specimen within 4 hours of completion of 24-hour collection. Additional Information: 1. 24-Hour volume is required. 2. See [NAME] in Special Instructions for multiple collections. 3. 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.   Urine Preservative Collection Options Ambient	No Refrigerated	Preferred Frozen	Yes 6N HCl	Yes 50% Acetic Acid	Yes Na2CO3	No Toluene	Yes 6N HNO3	Yes Boric Acid	No Thymol	No | 0.5 mL | Hemolysis	NA Thawing	Warm Reject ; Cold OK Lipemia	NA Icterus	NA Other	NA | 0-15 years: not established > or =16 years: 100-300 mcg/specimen | Wednesday, Friday; 5 p.m. | 1 day | 5 days | 1 | 83540 |  |  |  |  | Rochester
FEU | [NAME] | URINE | [NAME] |  |  |  | Refrigerated | 7 days
FEU | Order Question | TM22 | Collection Duration |  | Plain Text
FEU | Order Question | VL20 | [NAME] |  | Plain Text
FEU | Result | 8571 | Iron, 24 Hr, U | Iron, 24 Hr, U | Numeric |  |  |  |  | mcg/spec |  |  |  |  |  |  |  |  |  | 2499-2 | Iron:MRat:24H:[NAME]:Qn:
FEU | Result | TM22 | Collection Duration | Collection Duration | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 13362-9 | Collection duration:Time:*:Urine:Qn:
FEU | Result | VL20 | [NAME] | [NAME] | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 28009-9 | [NAME] volume:Vol:Pt:[NAME]:Qn:
FEU | Result | 854 | Fe Concentration | Fe Concentration | Numeric |  |  |  |  | mcg/L |  |  |  |  |  |  |  |  |  | 30030-1 | Iron:MCnc:24H:[NAME]:Qn:
Spreadsheet: 711855d1609946473-cumulative-average-for-current-year-formula-ups2021
Sheet: Feb2021

UPS Shipping
 | STANDARD |  | OVERNIGHT
Date: | # [NAME] | $Cost$ | # [NAME] | $Cost$
2021-02-01 00:00:00
2021-02-02 00:00:00
2021-02-03 00:00:00
2021-02-04 00:00:00
2021-02-05 00:00:00
2021-02-06 00:00:00
2021-02-07 00:00:00
2021-02-08 00:00:00
2021-02-09 00:00:00
2021-02-10 00:00:00
2021-02-11 00:00:00
2021-02-12 00:00:00
2021-02-13 00:00:00
2021-02-14 00:00:00
2021-02-15 00:00:00
2021-02-16 00:00:00
2021-02-17 00:00:00
2021-02-18 00:00:00
2021-02-19 00:00:00
2021-02-20 00:00:00
2021-02-21 00:00:00
2021-02-22 00:00:00
2021-02-23 00:00:00
2021-02-24 00:00:00
2021-02-25 00:00:00
2021-02-26 00:00:00
2021-02-27 00:00:00
2021-02-28 00:00:00
Totals:
Spreadsheet: 194549d1353235684-how-to-use-vlookup-with-pivot-table-as-one-of-the-data-sheet-book2
Sheet: MAIN

GL Type Summary | Amount | Type | Subtype | GL Type Summary
Excess Money Received from Customers | 15 | Profit & loss | Revenue account
Wellness Retail Revenue | 69 | Profit & loss | Revenue account
Day Care Revenue (Single) | 110 | Profit & loss | Revenue account
Spa Gift Voucher Revenue | 140 | Profit & loss | Revenue account
SGA Expenses | 157.32 | Profit & loss | Expense account | SGA Expenses
Squash Revenue | 220 | Profit & loss | Revenue account
Gym Daily Entry Revenue | 240 | Profit & loss | Revenue account
SGA Expenses | 300 | Profit & loss | Expense account | SGA Expenses
Transfer from Membership | 350 | Profit & loss | Revenue account
Staff Kids Day Care Revenue | 500 | Profit & loss | Revenue account
SGA Expenses | 500 | Profit & loss | Expense account | SGA Expenses
[NAME] Revenue | 560 | Profit & loss | Revenue account
Rotating Gallery | 1000 | Profit & loss | Revenue account
Tennis Revenue | 1365 | Profit & loss | Revenue account
Spreadsheet: 771104d1646413503-count-average-only-if-specific-cells-not-blank-excel_average_example
Sheet: Sheet1

M1 | M2 | M3 | M4 | M5 | M6 | M7 | M8 | M9
1 | 2 | 3 | 4 |  | 6 | 7 |  | 9
5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13
 | Result should be for: |  | row 2 | NA
 |  |  | row 3 | 7
Spreadsheet: 772910d1647523749-value-error-when-linked-source-is-closed-material-monitoring-trial
Sheet: Sheet1

SUMIFS USED FORMULA
 | 2022-01-01 00:00:00 | 2022-01-20 00:00:00
Item code | PC | KGS
BR-1
BR-10
BR-13
BR-14
BS-36
BS-67
SB-123/124
SB-126
SB-129
SB-130
[NAME]
SB-133/134
SB-141/142
SB-147
SB-150
SB-151/152
SB-155
TR-44
TR-46
Spreadsheet: 676669d1588925260-index-based-on-date-and-value-index-based-on-date-and-value-4-
Sheet: Sheet1

 | [NAME] | Mark |  |  |  |  |  |  | DATA
2019-09-02 00:00:00 |  |  | Index all values from the DATA |  |  |  |  | Date | Descritpion | Value
 |  |  |  |  |  |  |  | 2019-09-05 00:00:00 | Week1 | [NAME]
 |  |  |  |  |  |  |  | 2019-09-10 00:00:00 | Week2 | [NAME]
 |  |  |  |  |  |  |  | 2019-09-24 00:00:00 | Week4 | [NAME]
 |  |  |  |  |  |  |  | 2019-09-30 00:00:00 | Week5 | [NAME]
 |  |  |  |  |  |  |  | 2019-10-11 00:00:00 | Week6 | [NAME]
 |  |  |  |  |  |  |  | 2019-10-19 00:00:00 | Week7 | [NAME]
 |  |  |  |  |  |  |  | 2019-10-29 00:00:00 | Week9 | [NAME]
 |  |  |  |  |  |  |  | 2019-11-07 00:00:00 | Week10 | [NAME]
 |  |  |  |  |  |  |  | 2019-09-05 00:00:00 | Week2 | Mark
 |  |  |  |  |  |  |  | 2019-09-24 00:00:00 | Week5 | Mark
 |  |  |  |  |  |  |  | 2019-09-30 00:00:00 | Week6 | Mark
 |  |  |  |  |  |  |  | 2019-10-19 00:00:00 | Week8 | Mark
 |  |  |  |  |  |  |  | 2019-10-22 00:00:00 | Week9 | Mark
 |  |  |  |  |  |  |  | 2019-10-29 00:00:00 | Week10 | Mark
 |  |  |  |  |  |  |  | 2019-11-07 00:00:00 | Week11 | [NAME]
Spreadsheet: 814306d1674269311-look-up-same-requirements-output-different-results-automation-test-gk2
Sheet: Source

From | To |  |  |  |  | Leader | Activity | Unit | Booked | Product Code |  |  | The important details here are the dates, Leader, and Activity  Some of the sheets I would like to automate will have the same activities on the same dates, but different names need to populate based on the "Unit" number into different columns.
2022-06-13 00:00:00 | 2022-06-13 00:00:00 |  |  |  |  | [NAME] | Prep Trip | D22550 | 22 | ABC123
2022-06-13 00:00:00 | 2022-06-13 00:00:00 |  |  |  |  | [NAME] | Prep Trip | D22550 | 22 | ABC123
2022-06-14 00:00:00 | 2022-06-17 00:00:00 |  |  |  |  | [NAME] | Lead Trip | D22550 | 22 | ABC123
2022-06-14 00:00:00 | 2022-06-17 00:00:00 |  |  |  |  | [NAME] | Lead Trip | D22550 | 22 | ABC123
2022-06-14 00:00:00 | 2022-06-17 00:00:00 |  |  |  |  | [NAME] | Lead Trip | D22550 | 22 | ABC123
2022-06-27 00:00:00 | 2022-06-27 00:00:00 |  |  |  |  | [NAME] | Prep Trip | D22550 | 19 | ABC123
2022-06-27 00:00:00 | 2022-06-27 00:00:00 |  |  |  |  | [NAME] | Prep Trip | D22550 | 19 | ABC123
2022-06-28 00:00:00 | 2022-07-01 00:00:00 |  |  |  |  | [NAME] | Lead Trip | D22550 | 19 | ABC123
2022-06-28 00:00:00 | 2022-07-01 00:00:00 |  |  |  |  | [NAME] | Lead Trip | D22550 | 19 | ABC123
Spreadsheet: 707717d1607430250-find-dublicates-find-duplicates-formula
Sheet: Sheet1

Agreement | Part number | Duplicated lines
4356238256 | ABC12345
4356238257 | ABC12345
4356238258 | ABC12345
4356238259 | ABC12348
4356238260 | ABC12349
4356238261 | ABC12350
4356238262 | ABC12350
4356238263 | ABC12352
4356238264 | [NAME]
4356238265 | ABC12354
4356238260 | ABC12349
4356238267 | ABC12349
4356238268 | ABC12357
4356238269 | ABC12358
4356238270 | [NAME]
4356238271 | ABC12360
4356238272 | [NAME]
4356238273 | ABC12362
4356238274 | ABC12363
4356238275 | ABC12364
4356238270 | [NAME]
Spreadsheet: 220113d1363065886-find-row-where-time-value-falls-between-start-and-end-time-values-time-activity-problem-ans
Sheet: Activites

Name | Activity | Start Time | End Time | Billing code
[NAME] | Sales | 2013-03-05 13:46:03 | 2013-03-05 13:46:16
[NAME] | Paperwork | 2013-03-05 13:46:49 | 2013-03-05 13:47:20
[NAME] | kissing up to the boss | 2013-03-05 14:37:55 | 2013-03-05 14:38:15
[NAME] | Inventory | 2013-03-05 14:38:15 | 2013-03-05 14:52:58
[NAME] | Sales | 2013-03-05 15:01:15 | 2013-03-05 15:01:18
[NAME] | Paperwork | 2013-03-05 15:01:18 | 2013-03-05 15:41:07
[NAME] | kissing up to the boss | 2013-03-05 15:41:07 | 2013-03-05 15:54:59
[NAME] | Inventory | 2013-03-05 16:18:41 | 2013-03-05 16:18:47
[NAME] | Sales | 2013-03-05 16:18:53 | 2013-03-05 16:19:24
[NAME] | Paperwork | 2013-03-05 16:19:40 | 2013-03-05 16:21:58
[NAME] | kissing up to the boss | 2013-03-05 16:34:13 | 2013-03-05 16:34:14
[NAME] | Inventory | 2013-03-05 16:34:24 | 2013-03-05 16:34:31
[NAME] | Sales | 2013-03-05 16:34:33 | 2013-03-05 16:34:38
[NAME] | Paperwork | 2013-03-05 16:36:15 | 2013-03-05 16:36:32
[NAME] | kissing up to the boss | 2013-03-05 16:39:53 | 2013-03-05 16:40:10
[NAME] | Inventory | 2013-03-05 16:43:23 | 2013-03-05 16:43:30
[NAME] | Sales | 2013-03-05 16:43:41 | 2013-03-05 16:43:59
[NAME] | Paperwork | 2013-03-05 16:45:56 | 2013-03-05 16:46:16
[NAME] | kissing up to the boss | 2013-03-05 16:51:16 | 2013-03-05 16:51:34
[NAME] | Inventory | 2013-03-05 16:51:50 | 2013-03-05 16:52:05
[NAME] | Sales | 2013-03-05 16:52:12 | 2013-03-05 16:52:30
[NAME] | Paperwork | 2013-03-05 17:14:01 | 2013-03-05 17:15:08
[NAME] | kissing up to the boss | 2013-03-05 17:15:08 | 2013-03-05 17:15:46
[NAME] | Inventory | 2013-03-05 17:22:20 | 2013-03-05 17:24:04
[NAME] | Sales | 2013-03-05 17:24:04 | 2013-03-05 17:25:08
[NAME] | Paperwork | 2013-03-05 17:30:24 | 2013-03-05 17:30:34
[NAME] | kissing up to the boss | 2013-03-05 17:30:34 | 2013-03-05 17:30:46
[NAME] | Inventory | 2013-03-05 17:35:40 | 2013-03-05 17:37:30
[NAME] | Sales | 2013-03-05 17:37:30 | 2013-03-05 17:40:49
Spreadsheet: daren_farmer__6528__egmnom-Jan
Sheet: EGM 60

 | Nomination Change
 | ATTN: Transportation Specialist
HOUSTON PIPE LINE COMPANY
HPL Contract # |  | 012-207106-02-010
Shipper: | Entex Gas Marketing | Effective Dates:
Nominator: | Troy Benoit | Start:
Telephone: | (713)207-3376 | 2000-01-01 00:00:00
Fax: | (713)207-0054 | Stop:
 |  | 2000-01-31 00:00:00
RECEIPTS |  |  | JAN
METER # | [NAME] | SUPPLIER | 1
644 | LONE STAR KATY | DUKE | 10000
644 | LONE STAR KATY | RICHARDSON
4132 | EXXON KATY | ECT
4132 | EXXON KATY | COKINOS | 0
XXXX | IMBALANCE | ENTEX/HPL | 0
 |  | RECEIPT TOTAL
DELIVERIES
METER # | [NAME] | MARKET
1563 | COGEN | DYNEGY
1373 | [NAME] | CES
1485 | OXY BATTLEGROUND | OXY
1505 | DEER PARK | DUPONT
1506 | RHOM & HAAS DEER PARK | RHOM & HAAS | 5000
1394 | HILL PETRO | DYNEGY
8001 | AIR LIQUIDE | AIR LIQUIDE | 10000
XXXX | IMBALANCE | ENTEX/HPL | 0
 |  | DELIVERY TOTAL
Spreadsheet: 816182d1675419590-generate-next-ids-based-on-existing-list-id_generator
Sheet: Feuil1

 |  |  |  |  |  |  | expected_result
 |  | model |  |  | code |  | [NAME]
 |  | Ag-104 |  |  | An |  | 103
 |  | Ag-100 |  |  | Ag |  | 102 |  |  |  | 102
 |  | ZrO-100 |  |  | ZrO |  | 106 |  |  |  | 106
 |  | ZrO-101 |  |  | MWc |  | 100 |  |  |  | 100
 |  | ZrO-102
 |  | ZrO-103
 |  | ZrO-104
 |  | An-100
 |  | An-101
 |  | An-102
 |  | [NAME]
 |  | ZrO-110
 |  | ZrO-111
 |  | [NAME]
 |  | ZrO-110
 |  | ZrO-111
 |  | Ag-100
 |  | Ag-101
 |  | ZrO-120
Spreadsheet: 90736d1290500290-how-to-count-number-of-unique-occurrances-starting-with-a-text-string-office_rank
Sheet: Ranking

Rank | office number | # of agents |  |  |  | Rank
2 | 11004 | 7 |  |  |  | 1 | 5116 | 14
1 | 5116 | 14 |  |  |  | 2 | 11004 | 7
3 | 5141 | 6 |  |  |  | 3 | 5141 | 6
 |  |  |  |  |  | 4 | #N/A | #N/A
copy formula down | continue with full list of office numbers | copy formula down
Spreadsheet: 83145d1283195565-cell-referencing-book2-example
Sheet: Sheet1

Whereever | Whereever | [NAME] | Director | [NAME] | 1 Center Street | Wherever, SC 00000 | Phone:  [PHONE] | FAX:  [PHONE] | [EMAIL]
[NAME]
Director
[NAME]
1 Center Street
Wherever, SC 00000 | Whereever | Mr [NAME] | Asst Director | WhereverName2 | 11 [NAME] | Wherever2, SC 00000 | Phone:  [PHONE] | FAX:  [PHONE] | [EMAIL]
Mr [NAME]
Asst Director
WhereverName2
11 [NAME]
Wherever2, SC 00000 | Whereever | Mr. [NAME] | Secondary director | Wereever3 name | 2 Park Street | Whereever, sc 0000 | Phone:  [PHONE] | FAX:  [PHONE] | [EMAIL]
Mr. [NAME]
Secondary director
Wereever3 name
2 Park Street
Whereever, sc 0000
Phone:  [PHONE]
FAX:  [PHONE]
[EMAIL]
Phone:  [PHONE]
FAX:  [PHONE]
[EMAIL]
Phone:  [PHONE]
FAX:  [PHONE]
[EMAIL]
Spreadsheet: 0dece6ba-9cbb-4708-b791-ffc172b18493
Sheet: February

 | SUNDAY
 |  | 2014-01-27 00:00:00 | 2014-01-28 00:00:00 | 2014-01-29 00:00:00 | 2014-01-30 00:00:00 | 2014-01-31 00:00:00 | 2014-02-01 00:00:00
 |  | 2014-02-03 00:00:00 | 2014-02-04 00:00:00 | 2014-02-05 00:00:00 | 2014-02-06 00:00:00 | 2014-02-07 00:00:00 | 2014-02-08 00:00:00
 |  | 2014-02-10 00:00:00 | 2014-02-11 00:00:00 | 2014-02-12 00:00:00 | 2014-02-13 00:00:00 | 2014-02-14 00:00:00 | 2014-02-15 00:00:00
 |  | 2014-02-17 00:00:00 | 2014-02-18 00:00:00 | 2014-02-19 00:00:00 | 2014-02-20 00:00:00 | 2014-02-21 00:00:00 | 2014-02-22 00:00:00
 |  | Bank Holiday- President's Day
 |  | 2014-02-24 00:00:00 | 2014-02-25 00:00:00 | 2014-02-26 00:00:00 | 2014-02-27 00:00:00 | 2014-02-28 00:00:00 | 2014-03-01 00:00:00
 |  | Campus files to CO by noon | Delete Deadline 5pm | ACH File to Treasury |  | Pay Day
 |  | 2014-03-03 00:00:00 | NOTES
Spreadsheet: benjamin_rogers__1024__TLR Analysis
Sheet: Mar

 | TLR Max Level | Number of Incidents
 | 1 | 0
 | 2a | 0
 | 2b | 1
 | 2c | 1
 | 3 | 0
 | 4 | 0
 | 5 | 0
 | 6 | 0
 | Total
 | Curtailment | TLR level | MW Curtailed | Controller | Start Time | End Time | Total Time
1 | 1999-03-16 00:00:00 | 3 | 27 | MAIN | 05:15:00 | 09:45:00
Spreadsheet: andy_zipper__138__ICE - Mar09 Power & Gas VOL
Sheet: Financial Gas

 |  |  |  |  |  |  | FINANCIAL GAS VOLUME |  |  | TRANSACTIONS
'); } else { document.write(''); } } else { if (navigator.platform == "[NAME]") { document.write(''); } else { document.write(''); } }
Commodity Type:   Financial Gas Swaps/Forwards
Hub:  All
Trade Dates:  Mar-9-01 thru Mar-9-01
 | Description | Strip | Low Price | High Price | Weighted | Last Price | Last Price Date | Volume
 |  |  |  |  | Average Price
 | NG Fin BS, LD1 for GDM
 | NG Fin BS, LD1 for GDM - Mich - Apr01-Oct01 | Apr01-Oct01 | 0.23 | 0.23 | 0.23 | 0.23 | Mar-09-01 14:51 GMT | 1070000 | MMBtus
 | NG Fin BS, LD1 for IF
 | NG Fin BS, LD1 for IF - CG-ONSH - Apr01-Oct01 | Apr01-Oct01 | -0.018 | -0.018 | -0.018 | -0.018 | Mar-09-01 14:17 GMT | 1070000 | MMBtus
 | NG Fin BS, LD1 for NGI
 | NG Fin BS, LD1 for NGI - Chicago - Apr01-Oct01 | Apr01-Oct01 | 0.145 | 0.145 | 0.145 | 0.145 | Mar-09-01 18:38 GMT | 2140000 | MMBtus
 | NG Fin BS, LD1 for NGI - Socal - May01 | May01 | 3.3 | 3.3 | 3.3 | 3.3 | Mar-09-01 17:04 GMT | 155000 | MMBtus
 | NG Fin BS, LD1 for NGI - Socal - Apr01-Oct01 | Apr01-Oct01 | 3.7 | 3.8 | 3.75 | 3.8 | Mar-09-01 16:59 GMT | 2140000 | MMBtus
 | NG Fin BS, LD1 for NGI - Socal - Nov01-Mar02 | Nov01-Mar02 | 2.2 | 2.3 | 2.25 | 2.3 | Mar-09-01 16:37 GMT | 1510000 | MMBtus
 | NG Fin Sw Swap, FP for GDD
 | NG Fin Sw Swap, FP for GDD - Henry - Bal Month Gas | Bal Month Gas | 5.1 | 5.11 | 5.105 | 5.1 | Mar-09-01 15:55 GMT | 220000 | MMBtus
 | NG Fin, FP for LD1
 | NG Fin, FP for LD1 - Henry - Apr01 | Apr01 | 5.065 | 5.255 | 5.184 | 5.075 | Mar-09-01 20:03 GMT | 11250000 | MMBtus
 | NG Fin, FP for LD1 - Henry - May01 | May01 | 5.175 | 5.175 | 5.175 | 5.175 | Mar-09-01 19:15 GMT | 155000 | MMBtus
 | NG Fin, FP for LD1 - Henry - Apr01-Oct01 | Apr01-Oct01 | 5.19 | 5.34 | 5.255 | 5.19 | Mar-09-01 20:09 GMT | 26750000 | MMBtus
 | NG Fin, FP for LD1 - Henry - Nov01-Mar02 | Nov01-Mar02 | 5.365 | 5.425 | 5.39 | 5.365 | Mar-09-01 18:11 GMT | 2265000 | MMBtus
 | NG Fin, FP for LD1 - Henry - Apr02-Oct02 | Apr02-Oct02 | 4.665 | 4.665 | 4.665 | 4.665 | Mar-09-01 15:48 GMT | 1070000 | MMBtus