tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 0b99a366-06c6-4fed-8afe-bd9646aab3aa
Sheet: Sheet1

AT | TURN | GO | [NAME] | Unnamed: 4 | [NAME] | TURN.1 | GO.1 | DESCRIPTION.1 | Unnamed: 9 | AT.2 | TURN.2 | GO.2 | DESCRIPTION.2
0 | R | 0.1 | [NAME] |  | 0 | R | 0.1 | [NAME] |  | 0 | R | 0.1 | [NAME]
0.1 | R | 1.9 | N GREENSBORO |  | 0.1 | R | 1.9 | N GREENSBORO |  | 0.1 | R | 1.9 | N GREENSBORO
2 | R | 0.8 | OLD 86 |  | 2 | R | 0.8 | OLD 86 |  | 2 | R | 0.8 | OLD 86
2.8 | L | 0.6000000000000001 | [NAME] |  | 2.8 | L | 0.6000000000000001 | [NAME] |  | 2.8 | L | 0.6000000000000001 | [NAME]
3.4 | R | 1.5 | UNION GROVE |  | 3.4 | R | 1.5 | UNION GROVE |  | 3.4 | R | 1.5 | UNION GROVE
4.9 | L | 0.5 | ALBERT |  | 4.9 | L | 0.5 | ALBERT |  | 4.9 | L | 0.5 | ALBERT
5.4 | R | 0.6000000000000001 | [NAME] |  | 5.4 | R | 0.6000000000000001 | [NAME] |  | 5.4 | R | 0.6000000000000001 | [NAME]
6 | R | 1 | ROCKY RIDGE |  | 6 | R | 1 | ROCKY RIDGE |  | 6 | R | 1 | ROCKY RIDGE
7 | R | 1.2 | ARTHUR MINNUS |  | 7 | R | 1.2 | ARTHUR MINNUS |  | 7 | R | 1.2 | ARTHUR MINNUS
8.2 | L | 2.7 | BORLAND |  | 8.2 | L | 2.7 | BORLAND |  | 8.2 | L | 2.7 | BORLAND
10.9 | R | 0.5 | DODSONS |  | 10.9 | R | 0.5 | DODSONS |  | 10.9 | R | 0.5 | DODSONS
11.4 | L | 3.2 | ORANGE GROVE |  | 11.4 | L | 3.2 | ORANGE GROVE |  | 11.4 | L | 3.2 | ORANGE GROVE
14.6 | L | 3.9 | [NAME] |  | 14.6 | L | 3.9 | [NAME] |  | 14.6 | L | 3.9 | [NAME]
18.5 | L | 0.5 | ALBERT |  | 18.5 | L | 0.5 | ALBERT |  | 18.5 | L | 0.5 | ALBERT
19 | R | 1.5 | UNION GROVE |  | 19 | R | 1.5 | UNION GROVE |  | 19 | R | 1.5 | UNION GROVE
20.5 | L | 0.6000000000000001 | [NAME] |  | 20.5 | L | 0.6000000000000001 | [NAME] |  | 20.5 | L | 0.6000000000000001 | [NAME]
21.1 | R | 0.7 | OLD 86 |  | 21.1 | R | 0.7 | OLD 86 |  | 21.1 | R | 0.7 | OLD 86
21.8 | L | 1.9 | HILLSBOROUGH |  | 21.8 | L | 1.9 | HILLSBOROUGH |  | 21.8 | L | 1.9 | HILLSBOROUGH
23.7 | L | 0.1 | [NAME] |  | 23.7 | L | 0.1 | [NAME] |  | 23.7 | L | 0.1 | [NAME]
23.8 | END | 0 | WILSON PARK |  | 23.8 | END | 0 | WILSON PARK |  | 23.8 | END | 0 | WILSON PARK
Spreadsheet: 69513d1270039415-drop-down-list-returns-variable-number-of-values-without-blanks-hallyworkbook2
Sheet: Sheet2

Departments | Cost Centre Codes
Engineering | Hally1 | Hally2 | Hally3 | Hally4 | Hally5 | Hally6 | Hally7 | Hally8 | Hally9 | Hally10 | Hally11 | Hally12 | Hally13 | Hally14 | Hally15 | Hally16 | Hally17 | Hally18 | Hally19
Architecture | Joe1 | [NAME] | Joe3 | Joe4 | Joe5 | Joe6 | Joe7 | Joe8 | Joe9 | Joe10 | Joe11 | Joe12 | Joe13 | Joe14 | Joe15 | Joe16 | Joe17
Pharmacy | Bloggs1 | Bloggs2 | Bloggs3 | Bloggs4 | Bloggs5 | Bloggs6 | Bloggs7 | Bloggs8 | Bloggs9 | Bloggs10 | Bloggs11 | Bloggs12 | Bloggs13 | Bloggs14 | Bloggs15 | Bloggs16 | Bloggs17 | Bloggs18 | Bloggs19 | Bloggs20
Maths | [NAME] | James2 | James3 | James4 | [NAME] | James6 | James7 | James8 | [NAME] | James10 | James11 | [NAME] | James13 | James14
Spreadsheet: 0d6485d4-65b6-4c01-9beb-07ae68033a3e
Sheet: Ranked List

Rank | Reference | Outcome
1 | BB/L017628/1 | Funded
2 | BB/L01811X/1 | Funded
3 | BB/L018152/1 | Funded
4 | BB/L018047/1 | Funded
5 | BB/L017687/1 | Funded
5 | BB/L017768/1 | Funded
6 | BB/L018160/1 | Funded
7 | BB/L017733/1 | Funded
8 | BB/L01758X/1 | Funded
9 | BB/L01808X/1 | Funded
10 | BB/L018039/1 | Funded
11 | BB/L01792X/1 | Funded
12 | BB/L017865/1 | Funded
13 | BB/L017601/1 | Funded
14 | BB/L018063/1 | Funded
15 | BB/L017911/1 | Fundable
16 | BB/L017660/1 | Fundable
17 | BB/[NAME] | Fundable
18 | BB/L018098/1 | Fundable
19 | BB/L017857/1 | Fundable
20 | BB/L018179/1 | Fundable
21 | BB/L018144/1 | Fundable
22 | BB/L017881/1 | Fundable
23 | BB/L017725/1 | Fundable
24 | BB/L017814/1 | Fundable
25 | BB/L018195/1 | Fundable
26 | BB/L017555/1 | Fundable
27 | BB/L017547/1 | Fundable
28 | BB/L01775X/1 | Fundable
29 | BB/L017989/1 | Fundable
30 | BB/L017636/1 | Fundable
31 | BB/L018071/1 | Fundable
32 | BB/L017512/1 | Fundable
33 | BB/L017482/1 | Fundable
34 | BB/L017938/1 | Fundable
35 | BB/L017849/1 | Fundable
36 | BB/L017717/1 | Fundable
37 | BB/L018020/1 | Fundable
38 | BB/L017784/1 | Fundable
39 | BB/L017520/1 | Fundable
40 | BB/L017997/1 | Fundable
41 | BB/L018101/1 | Fundable
42 | BB/L017598/1 | Fundable
43 | BB/L017644/1 | Fundable
44 | BB/L017695/1 | Not Fundable
45 | BB/L017741/1 | Not Fundable
46 | BB/L017792/1 | Not Fundable
47 | BB/L017806/1 | Not Fundable
48 | BB/L017830/1 | Not Fundable
49 | BB/L017873/1 | Not Fundable
50 | BB/L017903/1 | Not Fundable
51 | BB/L017946/1 | Not Fundable
52 | BB/L018012/1 | Not Fundable
53 | BB/L018128/1 | Not Fundable
54 | BB/L018187/1 | Not Fundable
55 | BB/L01789X/1 | Not Fundable
56 | BB/L018004/1 | Not Fundable
57 | BB/L01761X/1 | Not Fundable
58 | BB/L017776/1 | Not Fundable
Spreadsheet: 116663d1311972479-selective-columns-handicapscorecards-master2
Sheet: Transfer to Archive

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Index
Posn on day | Player | Course | Tee | Date | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | handicap | stableford | new handicap | par 3 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | etc …
Spreadsheet: 780796d1652786786-filter-to-match-up-range-and-spill-data-in-range-dummy-test_filter
Sheet: Result

 | [NAME] used
 | < data to pulled> |  | Lookup range |  | Expected Result |  | Lookup range
 |  | Denmark | D |  | RAM | Denmark | D
 | [NAME] | UK | G |  | [NAME] | UK | G
 | AB | Austria | B |  | AB | Austria | B
 | DK | Switzerland | M |  | DK | Switzerland | M
Spreadsheet: 741412d1627032419-sum-single-cell-from-multiple-sheets-if-criteria-met-in-summary-sheet-sum-criteria-multiple-sheets1
Sheet: Summary

Sheet Names | Y/N |  |  | Result
Sheet1 | Y |  | Untested |  |  | Answer in [NAME] should be sum of G8 from sheet 1 and sheet 3 = 78
Sheet2 | Y |  | Passed |  |  | If I select 'Y' against sheet 2 then this is added to the sum.
Sheet3 | Y |  | Failed
 | N |  | Skipped |  |  | The quantity of sheets will vary and could be 50+.
 | N |  | Observation
 | N |  | N/A |  |  | A formula that works is:
 | N |  |  |  |  | IF(B2="Y",INDIRECT("'"&A$2&"'!"&"G8"))+IF(B3="Y",INDIRECT("'"&A$3&"'!"&"G8"))+IF(B4="Y",INDIRECT("'"&A$4&"'!"&"G8"))
 | N
 | N
 | N
 | N
Spreadsheet: 301298d1393790000-find-duplicate-order-ids-then-add-shipping-together-several-columns-to-the-right-temp2
Sheet: Sheet1

Order ID | shipping-price | Totalled up' shipping price
[PHONE]-7031512 | 0 |  | <- should be 0 in this cell
[PHONE]-0133125 | 0.31
[PHONE]-0133125 | 0.39 |  | <- correct totalling of two postages attributed to one order
[PHONE]-4597174 | 0 |  | <- should be 0 in this cell
[PHONE]-0543548 | 0 |  | <- should be 0 in this cell
[PHONE]-3234700 | 3.3 |  | <- should be 3.3 in this cell
[PHONE]-0532351 | 0 |  | <- should be 0 in this cell
[PHONE]-3060345 | 0 |  | <- should be 0 in this cell
[PHONE]-3295561 | 0 |  | <- should be 0 in this cell
[PHONE]-4835518 | 0 |  | <- should be 0 in this cell
[PHONE]-8022718 | 3.3 |  | <- should be 3.3 in this cell
[PHONE]-1472369 | 0 |  | <- should be 0 in this cell
Spreadsheet: 677802d1589531463-trying-to-solve-2-problems-problem
Sheet: Sheet3

TITLE | Current Stock (Packets) | Re-Order Level | Customer # In Packet | Price to Customer | Supplier Packet Cost | Supplier # In Packet | Status | Type | Net Per Order | Ranking | Re-Order indicator
Flower 1 | 4 | 5 | 5 | 2.79 |  |  | Active | Flower
Flower 2 | 100 | 5 | 20 | 2.79 |  |  | Sold-Out | Flower
Flower 3 | 3 | 5 | 3 | 2.79 |  |  | Active | Flower
Flower 4 | 100 | 5 | 8 | 2.79 |  |  | Sold-Out | Flower
Flower 5 | 100 | 5 | 1 | 2.79 |  |  | Active | Flower
Flower 6 | 5 | 5 |  | 4.95 |  |  | Sold-Out | Flower
Flower 7 | 100 | 5 | 8 | 3.79 |  |  | Active | Flower
Flower 8 | 100 | 5 | 6 | 2.79 |  |  | Active | Flower
Spreadsheet: 791894d1660652921-calculating-hours-worked-on-work-days-per-month-workdaysexamplenew
Sheet: Sheet1

Working - Without Considering Weekdays |  |  |  |  | 2019-01-01 00:00:00
Date Started | Date Finished | Hours Worked | Days Worked | Sum | January | February | March | April | May | June | July | August | September | October | November | December
2019-01-02 00:00:00 | 2019-01-04 00:00:00 | 10
2019-02-04 00:00:00 | 2019-02-19 00:00:00 | 89
2019-03-01 00:00:00 | 2019-04-05 00:00:00 | 120
When trying to only consider Weekdays
 |  |  |  |  | 2019-01-01 00:00:00
Date Started | Date Finished | Hours Worked | Days Worked | Sum | January | February | March | April | May | June | July | August | September | October | November | December
2019-01-02 00:00:00 | 2019-01-04 00:00:00 | 10
2019-02-04 00:00:00 | 2019-02-19 00:00:00 | 89
2019-03-01 00:00:00 | 2019-04-05 00:00:00 | 120
Expected results (without formulas, just to show what is expected)
 |  |  |  |  | 2019-01-01 00:00:00
Date Started | Date Finished | Hours Worked | Days Worked | Sum | January | February | March | April | May | June | July | August | September | October | November | December
2019-01-02 00:00:00 | 2019-01-04 00:00:00 | 10 |  |  | 10 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2019-02-04 00:00:00 | 2019-02-19 00:00:00 | 89 |  |  | 0 | 89 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2019-03-01 00:00:00 | 2019-04-05 00:00:00 | 120 |  |  | 0 | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 80d25e26-2107-4f47-988e-9e7bfee162eb
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
TGAB | Test | TGAB | [NAME], Serum | [NAME], S | Electrochemiluminescence Immunoassay | Serum Gel Tube: SGT |  |  | 1 | mL | Container/Tube: Preferred: Red top Acceptable: Serum gel [NAME]: 1 mL Additional Information: If thyroglobulin tumor marker testing is desired, do not order this test. Instead, order HTG1/83069 [NAME], Tumor Marker, Serum, which includes both thyroglobulin and [NAME]. Forms: If not ordering electronically, submit a General Request Form (Supply T239) with the specimen. | 0.5 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm reject; Cold OK Lipemia	Mild OK; [NAME] OK Icterus	NA Other	NA | <116 IU/mL Reference values apply to all ages. | Monday through Friday 5 a.m. - 12 a.m., Saturday 6 a.m. - 6 p.m. | Same day/1 day | 3 days | 1 | 86800 |  |  |  |  | Rochester
TGAB | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 7 days
TGAB | Result | TGAB | [NAME], S | [NAME], S | Numeric |  |  |  |  | IU/mL |  |  |  |  |  |  |  |  |  | 8098-6 | [NAME]:ACnc:Pt:Ser/Plas:Qn:
Spreadsheet: 766755d1644041236-conditional-formatting-on-certain-cell-learn-to-build-logic-formula
Sheet: Sheet1

 | 2021-04-01 00:00:00 |  | 2021-05-01 00:00:00 |  | 2021-06-01 00:00:00 |  | 2021-07-01 00:00:00 |  | 2021-08-01 00:00:00 |  | 2021-09-01 00:00:00 |  | 2021-10-01 00:00:00 |  | 2021-11-01 00:00:00
NAMES | Monthly load | Date | Monthly load | Date | Monthly load | Date | Monthly load | Date | Monthly load | Date | Monthly load | Date | Monthly load | Date | Monthly load | Date | [NAME] | Respective date
Spreadsheet: 700310d1603123709-power-query-or-formulas-or-vba-sample
Sheet: Sheet2

Order | Items | Picker ID | Box Type | Packer ID | [NAME]
1001 | X123 | 11 | LRG | 9 | 2020-10-19 00:00:00
1001 | X123 | 12 | LRG | 9 | 2020-10-19 00:00:00
1001 | Z324 | 11 | LRG | 9 | 2020-10-19 00:00:00
1001 | T223 | 11 | LRG | 3 | 2020-10-19 00:00:00
1002 | X123 | 3 | MED | 12 | 2020-10-19 00:00:00
1002 | T223 | 4 | MED | 12 | 2020-10-19 00:00:00
1002 | X123 | 7 | MED | 12 | 2020-10-19 00:00:00
1002 | X123 | 11 | MED | 12 | 2020-10-19 00:00:00
1002 | X123 | 25 | MED | 12 | 2020-10-19 00:00:00
Spreadsheet: 37606d1235656994-pivot-table-copy-of-pivot-table
Sheet: Sheet4

REGION | Data | Total
NORTH | Sum of QTY | 3844.3
 | Sum of INV VALUE | 154108
 | Sum of TOTAL RMC | 237248.08
 | Sum of TOTAL VC | 29329.4
 | Sum of TOTAL IWC | 8303.6828
Total Sum of QTY |  | 3844.3
Total Sum of INV VALUE |  | 154108
Total Sum of TOTAL RMC |  | 237248.08
Total Sum of TOTAL VC |  | 29329.4
Total Sum of TOTAL IWC |  | 8303.6828
category | Data | Total
BLUE | Sum of QTY | 100
 | Sum of INV VALUE | 454
 | Sum of TOTAL RMC | 3690
 | Sum of TOTAL VC | 800
 | Sum of TOTAL IWC | 129.15
OC | Sum of QTY | 500
 | Sum of INV VALUE | 67500
 | Sum of TOTAL RMC | 6150
 | Sum of TOTAL VC | 4000
 | Sum of TOTAL IWC | 215.25
WHITE | Sum of QTY | 950
 | Sum of INV VALUE | 68731
 | Sum of TOTAL RMC | 41516
 | Sum of TOTAL VC | 6175
 | Sum of TOTAL IWC | 1453.06
YELLOW | Sum of QTY | 2294.3
 | Sum of INV VALUE | 17423
 | Sum of TOTAL RMC | 185892.08
 | Sum of TOTAL VC | 18354.4
 | Sum of TOTAL IWC | 6506.2228
Total Sum of QTY |  | 3844.3
Total Sum of INV VALUE |  | 154108
Total Sum of TOTAL RMC |  | 237248.08
Total Sum of TOTAL VC |  | 29329.4
Total Sum of TOTAL IWC |  | 8303.6828
Spreadsheet: 140319d1328705356-peak-days-for-leave-taken-4-leave
Sheet: Data Sheet

 | LEAVE |  |  |  |  |  |  | 2012-02-01 00:00:00
 |  |  |  | [NAME] | čet | pet | sub | ned | pon | uto | [NAME] | čet | pet | sub | ned | pon | uto | [NAME] | čet | pet | sub | ned | pon | uto | [NAME] | čet | pet | sub | ned | pon | uto | [NAME] | čet | pet
 | PAY NO | SURNAME & INITIALS | RANK | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 2 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 |  |  |  | 2 |  |  |  |  | Sick | Peak Day | Vacation | Peak Day | Study | Peak Day | Special | Peak Day | Family | Peak Day | IOD | Peak Day | Unknown | Peak Day | AWOL | Peak Day | Exam | Peak Day | Maternity | Peak Day | Paternity | Peak Day
1 |  |  | 0 | [NAME] | čets | petv | subv |  |  |  |  | čets | pets |  |  |  |  | [NAME] | čets | pets |  |  |  |  |  |  | pets |  |  |  |  |  |  | pets |  | 0 |  | SD | ED | TOTAL | 9 | pet | 2 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
2 |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | #N/A | #N/A | 0 | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
3 |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
4 |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
5 |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
6 |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
7 |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
8 |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Spreadsheet: 797482d1663918581-sum-of-product-sales-from-start-month-to-end-month-sum-of-product-sales-from-start-month-to-end-month
Sheet: Sheet1

 |  |  |  |  |  |  |  |  | 2022-01-01 00:00:00 | <- select start month
Product Sales | 2022-01-01 00:00:00 |  |  |  |  |  |  | Product Sales | 2022-04-01 00:00:00 | <- select end month
Product Sales 1 | 568 | 323 | 848 | 366 | 411 | 500 |  | Product Sales 1
Product Sales 2 | 887 | 992 | 422 | 391 | 667 | 757 |  | Product Sales 2
Product Sales 3 | 337 | 738 | 314 | 192 | 454 | 219 |  | Product Sales 3
Product Sales 4 | 960 | 150 | 190 | 872 | 206 | 670 |  | Product Sales 4
Product Sales 5 | 770 | 794 | 188 | 404 | 990 | 906 |  | Product Sales 5
Product Sales 6 | 923 | 209 | 686 | 559 | 906 | 709 |  | Product Sales 6
Product Sales 7 | 317 | 350 | 781 | 667 | 399 | 124 |  | Product Sales 7
Product Sales 8 | 980 | 715 | 590 | 717 | 544 | 107 |  | Product Sales 8
Product Sales 9 | 140 | 973 | 837 | 713 | 939 | 933 |  | Product Sales 9
Product Sales 10 | 181 | 204 | 850 | 746 | 296 | 224 |  | Product Sales 10
Product Sales 11 | 503 | 304 | 275 | 595 | 841 | 752 |  | Product Sales 11
Spreadsheet: 94325d1294171068-need-to-find-the-second-to-last-value-in-a-column-test
Sheet: plll

plll |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
 | l | m | n | o
2011-01-03 00:00:00
 | 2.93 | 13.96 | 368.04 | 178.29 |  |  |  |  | 9.76
 | 2.31 |  |  |  |  |  |  |  | 58.4
 | 4.5 |  |  |  |  |  |  |  | 440
 |  |  |  |  |  |  |  |  | 341
Spreadsheet: 153321d1335871719-populating-cells-in-another-sheet-gib-rota
Sheet: Period 10 - 2012 

 |  | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | Total A shift | Total B shift | Total C shift | Total D shift | Total agents
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Shift A = 12.00hrs - 21.00hrs
Sun | 2012-06-03 00:00:00 |  |  |  |  |  |  |  |  |  |  | WEEK 37 |  |  |  |  |  |  | Shift B = 13.00hrs - 22.00hrs
Mon | 2012-06-04 00:00:00 |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  | Shift C = 15.00hrs - 00.00hrs
[NAME] | 2012-06-05 00:00:00 |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  | Shift D = 09.00hrs - 18.00hrs
Weds | 2012-06-06 00:00:00 |  |  |  |  |  |  |  |  |  |  | [NAME]
Thurs | 2012-06-07 00:00:00 |  |  |  |  |  |  |  |  |  |  | oliver
Fri | 2012-06-08 00:00:00 |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  | DOR = Requested day off
Sat | 2012-06-09 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | H = Holiday
Sun | 2012-06-10 00:00:00 |  |  |  |  |  |  |  |  |  |  | WEEK 38 |  |  |  |  |  |  | S = Sick
Mon | 2012-06-11 00:00:00 |  |  |  |  |  |  |  |  |  |  | [NAME]
[NAME] | 2012-06-12 00:00:00 |  |  |  |  |  |  |  |  |  |  | [NAME]
Weds | 2012-06-13 00:00:00 |  |  |  |  |  |  |  |  |  |  | [NAME]
Thurs | 2012-06-14 00:00:00 |  |  |  |  |  |  |  |  |  |  | oliver
Fri | 2012-06-15 00:00:00 |  |  |  |  |  |  |  |  |  |  | [NAME]
Sat | 2012-06-16 00:00:00
Sun | 2012-06-17 00:00:00 |  |  |  |  |  |  |  |  |  |  | WEEK 39
Mon | 2012-06-18 00:00:00 |  |  |  |  |  |  |  |  |  |  | [NAME]
[NAME] | 2012-06-19 00:00:00 |  |  |  |  |  |  |  |  |  |  | [NAME]
Weds | 2012-06-20 00:00:00 |  |  |  |  |  |  |  |  |  |  | [NAME]
Thurs | 2012-06-21 00:00:00 |  |  |  |  |  |  |  |  |  |  | oliver
Fri | 2012-06-22 00:00:00 |  |  |  |  |  |  |  |  |  |  | [NAME]
Sat | 2012-06-23 00:00:00
Sun | 2012-06-24 00:00:00 |  |  |  |  |  |  |  |  |  |  | WEEK 40
Mon | 2012-06-25 00:00:00 |  |  |  |  |  |  |  |  |  |  | [NAME]
[NAME] | 2012-06-26 00:00:00 |  |  |  |  |  |  |  |  |  |  | [NAME]
Weds | 2012-06-27 00:00:00 |  |  |  |  |  |  |  |  |  |  | [NAME]
Thurs | 2012-06-28 00:00:00 |  |  |  |  |  |  |  |  |  |  | oliver
Fri | 2012-06-29 00:00:00 |  |  |  |  |  |  |  |  |  |  | [NAME]
Sat | 2012-06-30 00:00:00
Sun | 2012-07-01 00:00:00 |  |  |  |  |  |  |  |  |  |  | WEEK 36
Mon | 2012-07-02 00:00:00 |  |  |  |  |  |  |  |  |  |  | [NAME]
[NAME] | 2012-07-03 00:00:00 |  |  |  |  |  |  |  |  |  |  | [NAME]
Weds | 2012-07-04 00:00:00 |  |  |  |  |  |  |  |  |  |  | [NAME]
Thurs | 2012-07-05 00:00:00 |  |  |  |  |  |  |  |  |  |  | oliver
Fri | 2012-07-06 00:00:00 |  |  |  |  |  |  |  |  |  |  | [NAME]
Sat | 2012-07-07 00:00:00
Total | A
 | B
 | C
 | D
Spreadsheet: 681283d1591450203-formula-assigning-date-range-to-each-gl-code-sample-gl-code
Sheet: Formula

GL Codes | Month No | Date Ref
1001/BUL/CAST/REV | 1 | 2020-03-31 00:00:00
1002/BUL/METO/REV | 2 | 2020-04-30 00:00:00
1003/BUL/CPT/REV | 3 | 2020-05-31 00:00:00
1004/BUL/CPT/REV | 4 | 2020-06-30 00:00:00
 | 5 | 2020-07-31 00:00:00
 | 6 | 2020-08-31 00:00:00
 | 7 | 2020-09-30 00:00:00
 | 8 | 2020-10-31 00:00:00
 | 9 | 2020-11-30 00:00:00
 | 10 | 2020-12-31 00:00:00
 | 11 | 2021-01-31 00:00:00
 | 12 | 2021-02-28 00:00:00
Spreadsheet: 133319d1324331890-comparing-two-worksheets-tigeravatar-example-for-bertulfio
Sheet: Sheet1

Address | [NAME]
Address 02 | [NAME] 02
Address 05 | [NAME] 05
Address 06 | [NAME] 06
Address 08 | [NAME] 08
Address 09 | [NAME] 09
Address 10 | [NAME] 10
Address 11 | [NAME] 11
Address 12 | [NAME] 12
Address 14 | [NAME] 14
Address 15 | [NAME] 15
Address 16 | [NAME] 16
Address 17 | [NAME] 17
Address 18 | [NAME] 18
Address 19 | [NAME] 19
Address 20 | [NAME] 20
Spreadsheet: richard_ring__31574__Purchases Reconciliation
Sheet: EEMC

REPORTED ON MPR'S FOR EEMC
 | 2000-01-01 00:00:00 | 0
 | 2000-02-01 00:00:00 | 0
 | 2000-03-01 00:00:00 | 0
 | 2000-04-01 00:00:00 | 0
 | 2000-05-01 00:00:00 | 0
 | 2000-06-01 00:00:00 | 115
 | 2000-07-01 00:00:00 | 1776
 | 2000-08-01 00:00:00 | 2976
 | 2000-09-01 00:00:00 | 2880
 | 2000-10-01 00:00:00 | 0
 | 2000-11-01 00:00:00
 | 2000-12-01 00:00:00
Spreadsheet: michelle_lokay__26574__imbalsumm0012
Sheet: Amoco

 | Florida Plant
Day | Measured | Scheduled | Imbal
1 | 93344 | 93623
2 | 90757 | 82485
3 | 79881 | 83564
4 | 86932 | 85573
5 | 91421 | 89951
6 | 93012 | 90323
7 | 112781 | 112264
8 | 107002 | 105320
9 | 103512 | 98386
10 | 106623 | 104979
11 | 95291 | 93974
12 | 91874 | 89099
13 | 105714 | 103835
14 | 101750 | 100162
15 | 109775 | 109693
16 | 87524 | 86423
17 | 98132 | 96808
18 | 101493 | 99961
19 | 134960 | 143957
20 | 123614 | 121696
21 | 113423 | 111901
22 | 122997 | 120814
23 | 95797 | 94551
24 | 86651 | 84733
25 | 91545 | 90433
26 | 95250 | 93568
27 | 125632 | 124339
28 | 146702 | 145576
29 | 120329 | 119699
30 | 122510 | 120273
31 | 118842 | 117190
2000-11-30 00:00:00 |  |  | -15891
2000-12-31 00:00:00
Spreadsheet: 868447d1715180054-excel-pickup-wrong-data-formula-error
Sheet: MRP

Quantity in CTN |  |  |  |  |  |  |  |  |  |  | Actual | Actual | Actual | Actual | Actual | Actual | Actual | Actual | Actual | Actual | Actual | Actual | Actual | Actual | Actual
Retail SKU | IB SKU | Description | vendor | vendor_name | Brand | Classification | Category | Type | Ctn/ Pallet | Category | 2023-10-30 00:00:00 | 2023-11-30 00:00:00 | 2023-12-31 00:00:00 | 2024-01-31 00:00:00 | 2024-02-29 00:00:00 | 2024-03-31 00:00:00 | 2024-04-30 00:00:00 | 2024-05-31 00:00:00 | 2024-06-30 00:00:00 | 2024-07-31 00:00:00 | 2024-08-31 00:00:00 | 2024-09-30 00:00:00 | 2024-10-31 00:00:00 | 2024-11-30 00:00:00 | 2024-12-31 00:00:00
A1 | K2 | Apple | 33 | XX | kitty | test | apply | A | 24 | New
Spreadsheet: darrell_schoolcraft__7804__imbalsumm0108
Sheet: Calpine

 | Calpine So. Point Power Del
 | 78113
Day | Measured | Scheduled
1 | -77614 | -65229
2 | -71168 | -80300
3 | -41277 | -50000
4 | -41015 | -50000
5 | -41598 | -50000
6 | -67163 | -50000
7 | -78830 | -80300
8 | -82227 | -80300
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
2001-07-31 00:00:00 |  |  | 21736.76
2001-08-08 00:00:00
CBS Volume
Spreadsheet: joe_parks__14593__ECS LLC Nomination Model 2002 with Noms2
Sheet: Bisti Invoices

ECS LLC/Bisti Compressor Station
NTUA 2001 Summary
 | 2001
Actuals | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec |  | Totals | 2001 Average
MWh * Rate
Minimum System Charge | 66000
Loadside Generation | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 19333.09 | 0 | 0
ROW/CPI Charge | 0 | 0 | 0 | 0 | 0 | 0 | 7391.97 | 113563.66 | 0 | 0 | 0 | 0
Subtotal
 | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec |  | 2001 Average
Total MWh | 4807.614 | 4339.977 | 4308.029 | 4149.562 | 4109.881 | 4566.784 | 4999.314 | 4707.834 | 4093.785 | 4220.28 | 4289.1 | 4427.8
$/MWh | 26
Loadside Generation MWh |  |  |  |  |  |  |  |  |  | 509
Loadside $MWh
 |  |  |  |  |  |  |  | Bisti A/C  $168,122 monthly Jan - Oct
 |  |  |  |  |  |  |  | Bisti A/C $173,662 for Nov - Dec & to Oct. 02
 |  |  |  |  |  |  |  | Bisti Min gas 125,215 - 121,176/month
 |  |  |  |  |  |  |  | Bisti demand charge $66k
 |  |  |  |  |  |  |  | Bisti O&M .004703 x hp-hr or approx $29k/month
Spreadsheet: 107640d1304769312-predictive-stock-stock-management
Sheet: Report

 |  | 2011-01-02 00:00:00
Milkshake | Actual Sales
 | Average Sales
 | Stock
 | Prediction