tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 757734d1638439168-using-hlookup-without-changing-the-value-on-already-typed-hlookup-sample-price-change
Sheet: Planilha1

New price table |  |  |  |  |  |  |  | Sell table
Date | Product | Price |  |  |  |  |  | Date | Product | Price
2021-01-01 00:00:00 | Product1 | 1 |  |  |  |  |  | 2021-01-01 00:00:00 | Product1
2021-01-01 00:00:00 | Product2 | 2 |  |  |  |  |  | 2021-01-02 00:00:00 | Product2
2021-01-01 00:00:00 | Product3 | 3 |  |  |  |  |  | 2021-01-03 00:00:00 | Product3
2021-01-01 00:00:00 | Product4 | 4 |  |  |  |  |  | 2021-01-04 00:00:00 | Product4
2021-01-01 00:00:00 | Product5 | 5 |  |  |  |  |  | 2021-01-05 00:00:00 | Product5
2021-11-01 00:00:00 | Product3 | 10 |  |  |  |  |  | 2021-01-06 00:00:00 | Product1
 |  |  |  |  |  |  |  | 2021-01-07 00:00:00 | Product2
 |  |  |  |  |  |  |  | 2021-01-08 00:00:00 | Product3
 |  |  |  |  |  |  |  | 2021-01-09 00:00:00 | Product4
 |  |  |  |  |  |  |  | 2021-01-10 00:00:00 | Product5
 |  |  |  |  |  |  |  | 2021-01-11 00:00:00 | Product1
 |  |  |  |  |  |  |  | 2021-01-12 00:00:00 | Product2
 |  |  |  |  |  |  |  | 2021-01-13 00:00:00 | Product3
 |  |  |  |  |  |  |  | 2021-01-14 00:00:00 | Product4
 |  |  |  |  |  |  |  | 2021-01-15 00:00:00 | Product5
 |  |  |  |  |  |  |  | 2021-01-16 00:00:00 | Product1
 |  |  |  |  |  |  |  | 2021-01-17 00:00:00 | Product2
 |  |  |  |  |  |  |  | 2021-11-02 00:00:00 | Product3
 |  |  |  |  |  |  |  | 2021-11-03 00:00:00 | Product4
 |  |  |  |  |  |  |  | 2021-11-04 00:00:00 | Product5
Spreadsheet: 863154d1710747314-how-to-contribute-amount-from-group-of-people-kharas-hesab-copy
Sheet: Sheet1

Date | Amount | Menu | Paid By | Total Amount | Contribute | Amount | HC
2024-03-11 00:00:00 | 2 | Samosa | Mazahir |  | Mazahir
2024-03-12 00:00:00 | 2.2 | Pattic | Mazahir |  | [NAME]
 | 1.5 | Samosa | [NAME] |  | [NAME]
 | 2 | Pattic | [NAME] |  | [NAME]
 | 1 | Pattic | [NAME]
 | 1.4 |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0 |  | 0 |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0 |  | 0 |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0 |  | 0 |  | 0 | 0 | 0
Spreadsheet: 184746d1349367146-if-and-forumla-is-giving-me-a-circular-ref-error-0a1_fot_router-sample-1
Sheet: Sheet1

[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
DOC   S308939-00             How to create orders (lean lines) | k | S308939-00 | S308939-00
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
DOC   90127664               Distal Outer Neck and Inspect | l | 90127664 | 90127664
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
DOC   90127501               Universal Cut to Length
DOC   90138776               Universal Cut To Length Inspect
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
DOC   90138780               Distal Outer Flare
 | 90240772 | 0
 | 90240766 | 0
 | 90240769 | 0
 | 90240768 | 0
 | 90240767 | 0
 | 90142719 | 0
 | 90240830 | 0
 | 90142720 | 0
 | 90222262 | 0
 | 90240763 | 0
 | 90455862 | 0
DOC   S308939-00             How to create orders (lean lines)
 | 90450588 | 0
DOC   90127501               Universal Cut to Length
DOC   90127501               Universal Cut to Length
 | 90450588 | 0
DOC   90127501               Universal Cut to Length
DOC   S308939-00             How to create orders (lean lines)
 | 90186149
 | 90172823
 | 90417552
 | 90185650
 | 90185544
 | 90179415
 | 90173527
 | 90179545
 | 90173058
 | 90179318
 | 90179546
 | 90179306
 | 90179309
 | 90173598
 | 90166506
 | 90180148
 | 90245956
Spreadsheet: 58525c7f-5fa6-4afe-8ad8-c352e016abe0
Sheet: Trials

Diameter Measurements using distance and azimuth of TP 360
TP 360 distance to front center of tree | TP 360 azimuth left side | TP 360 azimuth right side | computed angle in degrees | angle in radians | sine  of angle | Sine-based computed diameter | Actual diameter measured with calipers | sine-based difference abs(computed - calipers) | Diff as pct of actual
85.5 | 230.8 | 232.1
104 | 211.1 | 212.1
86.5 | 280.6 | 282.2
80 | 279.4 | 281.1
45 | 283 | 284.8
43 | 273.5 | 274.7
46 | 147.2 | 149.9
65 | 150.7 | 152.7
70.5 | 150 | 151.7
39 | 144.7 | 147.9
50 | 144.5 | 146.7
57 | 141.6 | 143.5
66 | 148.2 | 149.9
23 | 5.6 | 10.4
50 | 2.6 | 4.7
65 | 0.6 | 2.4
50 | 281.2 | 282.4
52.5 | 274.4 | 275.5
45 | 280.8 | 282.2
65 | 274 | 274.9
105 | 312.1 | 313.2
99 | 310.9 | 312.1
107 | 310.7 | 311.8
47 | 295.8 | 297.3
42 | 293.3 | 294.7
70 | 246.5 | 248.3
75 | 248.5 | 250.2
80 | 248.3 | 249.9
104 | 256.3 | 257.5 |  |  |  |  | 2.175
110 | 257.1 | 258.3 |  |  |  |  | 2.175
77 | 216.8 | 218.3
72 | 217.5 | 219.1
108 | 257 | 258.1 |  |  |  |  | 2.175
 |  |  |  |  |  |  | [NAME]=>
 |  |  |  |  |  |  | Avg In  =>
 | Notes: |  |  |  |  |  | Range-IN
 | 1. Measurements are in chronological order
 | 2. This method was developed because laser returns
 | from the edges of a trunk using the ML routine are
 | difficult to obtain because of visibility and the lack of a firm target.
 | 3. The calipers used to measure diameter are high precision.
 | 4. The diagram below illustrates the common measurement scenario.
 | The measurer can't see the exact edges of the widest part of the trunk, i.e.
 | the full diameter. Using the sine-based formula shown below,
 | the measurer still captures the full diameter. The assumption of circularity is important.
 |  | [NAME]
 | 5. For a flat surface, the formula for width is:
 | where a is the angle computed as is the difference in azimuths taken to the left and right edges of the surface,
 | and D is the TP 360 distance to the center of the surface.
 | In this case, the measurer must be postioned such that a plane perpendicular to the flat surface and
 | passing through its center will include the eye of the measurer.
Spreadsheet: 08b59068-996a-45ce-aaa9-ace23f2aa845
Sheet: Sheet1

Battle ID | Date & Time | Side | Victory | Score | Opp. Score | Opp. ID | Opp. Name | Scenario ID | Front | Start Date | End Date | Name EN | Name FR
44305349 | 2014-12-04 22:16:04 | ALLIES | 0 | 5 | 6 | 443634 | caty | 7669 | pacific | 1941-12-23 | 1941-12-23 | Wake Island | Ile de Wake
44305711 | 2014-12-04 22:50:01 | AXIS | 0 | 4 | 6 | 443634 | caty | 7669 | pacific | 1941-12-23 | 1941-12-23 | Wake Island | Ile de Wake
Spreadsheet: hunter_shively__12537__30c1 Availability
Sheet: Sheet1

DATES |  | TIME AVAILABLE |  | [NAME] |  | Presenter |  | Phone
2000-08-25 00:00:00 |  | 11AM -1PM
2000-08-31 00:00:00 |  | 4PM-5PM
2000-09-08 00:00:00 |  | 12PM -1PM |  | EB 30C1 |  | [NAME] |  | 853-0949
2000-09-12 00:00:00 |  | 4PM-5PM |  |  |  |  |  | 3-0950
2000-09-12 00:00:00 |  | 4PM-5PM |  | EB 30C1 |  | [NAME] |  | 345-8958
2000-09-19 00:00:00 |  | 4PM-5PM |  |  |  |  |  | 3-0952
2000-09-22 00:00:00 |  | 12PM -1PM |  | EB 30C1 |  | [NAME] |  | 853-1839
2000-09-26 00:00:00 |  | 4PM-5PM |  |  |  |  |  | 3-0954
2000-09-27 00:00:00 |  | 4PM-5PM |  |  |  | [NAME] |  | 853-6351
2000-10-04 00:00:00 |  | 4PM-5PM |  |  |  | [NAME] |  | 853-5926
2000-10-05 00:00:00 |  | 4PM-5PM |  |  |  |  |  | 853-5926
2000-10-10 00:00:00 |  | 4PM-5PM |  |  |  |  |  | 853-4772
2000-10-11 00:00:00 |  | 4PM-5PM |  |  |  | [NAME] |  | 853-4772
2000-10-12 00:00:00 |  | 4PM-5PM |  |  |  |  |  | 3-0960
2000-10-13 00:00:00 |  | 11AM -1PM |  |  |  |  |  | 853-1450
2000-10-17 00:00:00 |  | 4PM-5PM |  |  |  |  |  | 3-0962
2000-10-18 00:00:00 |  | 4PM-5PM |  |  |  | [NAME] |  | 853-1450
2000-10-19 00:00:00 |  | 11AM -1PM |  | EB 5C2 |  |  |  | 3-0964
2000-10-24 00:00:00 |  | 12PM -1PM |  | EB 30C1 |  | [NAME] |  | 853-6671
2000-10-25 00:00:00 |  | 4PM-5PM |  | EB 5C2 |  |  |  | 3-0966
2000-10-26 00:00:00 |  | 11AM -1PM |  | EB 5C2 |  |  |  | 3-0967
2000-10-27 00:00:00 |  | 11AM -1PM |  | EB 5C2 |  |  |  | 3-0968
2000-10-31 00:00:00 |  | 11AM -1PM |  | EB 5C2 |  |  |  | 3-0969
2000-11-01 00:00:00 |  | 4PM-5PM |  |  |  | [NAME] |  | 853-7445
2000-11-02 00:00:00 |  | 11AM -1PM |  | EB 5C2 |  |  |  | 3-0971
2000-11-03 00:00:00 |  | 12M -1PM |  | EB 30C1
2000-11-07 00:00:00 |  | 4PM-5PM |  | EB 5C2 |  |  |  | 3-0973
2000-11-08 00:00:00 |  | 4PM-5PM
2000-11-09 00:00:00 |  | 11AM -1PM |  | EB 5C2 |  |  |  | 3-0975
2000-11-14 00:00:00 |  | 4PM-5PM |  | EB 5C2 |  |  |  | 3-0976
2000-11-15 00:00:00 |  | 4PM-5PM
2000-11-17 00:00:00 |  | 11AM -1PM |  | [NAME] |  |  |  | 3-0978
2000-11-21 00:00:00 |  | 4PM-5PM |  | [NAME] |  |  |  | 3-0979
2000-11-22 00:00:00 |  | 4PM-5PM
2000-11-23 00:00:00 |  | 11AM -1PM |  | [NAME] |  |  |  | 3-0981
2000-11-24 00:00:00 |  | 11AM -1PM |  | [NAME] |  |  |  | 3-0982
2000-11-28 00:00:00 |  | 11AM -1PM |  | [NAME] |  |  |  | 3-0983
2000-11-29 00:00:00 |  | 4PM-5PM
2000-11-30 00:00:00 |  | 11AM -1PM |  | [NAME] |  |  |  | 3-0985
2000-12-05 00:00:00 |  | 4PM-5PM |  | [NAME] |  |  |  | 3-0986
2000-12-06 00:00:00 |  | 4PM-5PM
2000-12-12 00:00:00 |  | 4PM-5PM |  | [NAME] |  |  |  | 3-0988
2000-12-13 00:00:00 |  | 4PM-5PM
2000-12-14 00:00:00 |  | 11AM -1PM
2000-12-15 00:00:00 |  | 11AM -1PM
2000-12-19 00:00:00 |  | 4PM-5PM
2000-12-20 00:00:00 |  | 4PM-5PM
2000-12-22 00:00:00 |  | 11AM -1PM
2000-12-28 00:00:00 |  | 11AM -1PM
2000-12-29 00:00:00 |  | 11AM -1PM
Spreadsheet: 709824d1608570093-if-function-that-determines-a-output-acheivement-spreadsheet
Sheet: Sheet2

 | Jan | Feb | Mar | Apr | May | June | Jul | Aug | Sept | Oct | Nov | Dec
% YTD Quarterly
Rolling Quarter target
Target | 56 | 28 | 158 | 65 | 65 | 93 | 53 | 1 | 200 | 62 | 62 | 83
Results | 32 | 29 | 58 | 0 | 15 | 28 | 92 | 84 | 124 | 44 | 52 | 82
Achieved
 |  | Quarter 1 |  |  | Quarter 2 |  |  | Quarter  3 |  |  | Quarter 4
Month 1 Target Achieved | Yes/No | 0.0025 | Yes |  |  | yes |  |  | yes |  |  | yes
Month  2 Target achieved | Any overage counts to Month 2   0.25% | 0.0025 |  |  |  | yes |  |  | yes |  |  | yes
90% YTD at quarter End | lose all bonus
Monthly Target |  | 0.005
Spreadsheet: 736602d1623761479-sum-of-index-match-of-multiple-worksheets-example
Sheet: 3

 |  | CUSTOMER A FORECAST
 |  | SKU | Vendor SKU | Description | 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 | 2021-12-01 00:00:00 | 2022-01-01 00:00:00 | 2022-02-01 00:00:00 | 2022-03-01 00:00:00 | 2022-04-01 00:00:00 | 2022-05-01 00:00:00 | 2022-06-01 00:00:00 | 2022-07-01 00:00:00 | Total
 |  | Another Heading D
 |  | ITEM A | VendorA | Description | 100
 |  | ITEM B | VendorB | Description | 200
 |  | ITEM C | VendorC | Description | 300
 |  | ITEM D | [NAME] | Description | 400
 |  | Another Heading Z
 |  | ITEM E | VendorE | Description | 500
Spreadsheet: 888dd8fa-ef6c-4eef-a759-d62ff0b414f2
Sheet: Sheet1

Bevölkerung des Freistaates Sachsen nach ausgewählten Altersgruppen | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
Flöha, Stadt - Variante 2
Alter von ... bis                     unter ... Jahren | 2011 | 2015 | 2020 | 2025
1 000
unter 20 | 1557 | 1607 | 1539 | 1396
20 - 65 | 6828 | 6325 | 5491 | 4765
65 und mehr | 3116 | 3096 | 3306 | 3466
Insgesamt | 11501 | 11028 | 10336 | 9627
%
unter 20 | 13.537953221459 | 14.57199854914762 | 14.88970588235294 | 14.50088293341643
20 - 65 | 59.36875054343101 | 57.35400797968807 | 53.125 | 49.49620858003532
65 und mehr | 27.09329623510999 | 28.07399347116431 | 31.98529411764706 | 36.00290848654825
Insgesamt | 100 | 100 | 100 | 100
Abhängigkeitsquotient
Jugendquotient | 22.80316344463972 | 25.40711462450593 | 28.02768166089966 | 29.29695697796432
Altenquotient | 45.63561804335091 | 48.94861660079052 | 60.20761245674741 | 72.73871983210913
Gesamtquotient | 68.43878148799062 | 74.35573122529644 | 88.23529411764706 | 102.0356768100735
Gebietsstand: | 1. Januar 2012
Quelle: | 2011 Bevölkerungsfortschreibung auf Basis der [NAME] vom 03. Oktober 1990
 | 2012 - 2025 Bevölkerungsprognose
Bevölkerung jeweils am 31. Dezember
Prognoseergebnisse werden bei der Veröffentlichung immer auf volle [NAME] gerundet. [NAME] basieren [NAME] ungerundeten Werten. Beim [NAME] der [NAME] werden Ihnen die ungerundeten [NAME] zur Verfügung gestellt, damit [NAME] eigenen Berechnungen genauer durchführen können. Die Darstellung der Ergebnisse sollte dann aber wieder gerundet erfolgen.
Spreadsheet: 110184d1306931827-help-with-data-arrangement-timetablesummary
Sheet: Sheet1

 |  | CPT | LHR | MUC | FRA
 | SYD
 | HKG
 | LAX
 | MIA
 | CDG
 | ORY
Spreadsheet: 168734d1342552700-copy-across-multiple-rows-and-columns-the-data-to-one-column-removing-dupilicates-blank-15640
Sheet: Nov11-Nov17m

Main Arena
 | 2012-11-11 00:00:00 |  |  | Thru | 2012-11-17 00:00:00
 | SUN | MON | TUE | WED | THURS | FRI | SAT
 | 2012-11-11 00:00:00 | 2012-11-12 00:00:00 | 2012-11-13 00:00:00 | 2012-11-14 00:00:00 | 2012-11-15 00:00:00 | 2012-11-16 00:00:00 | 2012-11-17 00:00:00 |  |  |  | Blocks | Team | Hours
7:00AM |  |  |  |  |  |  |  | 7:00AM |  |  | 0 | 05 [NAME] | 0
 |  |  |  |  |  |  |  |  |  |  | 0 | 04 Flags | 0
[NAME] |  |  |  |  |  |  |  | [NAME] |  |  | 0 | 03 [NAME] | 0
 |  |  |  |  |  |  |  |  |  |  | 0 | 02 Flags | 0
[NAME] |  |  |  |  |  |  |  | [NAME] |  |  | 0 | 01 Flags | 0
 |  |  |  |  |  |  |  |  |  |  | 0 | 00 Flags | 0
10:00AM |  |  |  |  |  |  |  | 10:00AM |  |  | 0 | 99 Flags | 0
 |  |  |  |  |  |  |  |  |  |  | 0 | 98 Flags | 0
11:00AM |  |  |  |  |  |  |  | 11:00AM |  |  | 0 | Midget A | 0
 |  |  |  |  |  |  |  |  |  |  | 0 | Midget AA | 0
12:00PM |  |  |  |  |  |  |  | 12:00PM
1:00PM |  |  |  |  |  |  |  | 1:00PM
2:00PM |  |  |  |  |  |  |  | 2:00PM
3:00PM |  |  |  |  |  |  |  | 3:00PM
4:00PM |  |  |  |  |  |  |  | 4:00PM
5:00PM |  |  |  |  |  |  |  | 5:00PM
6:00PM |  |  |  |  |  |  |  | 6:00PM
7:00PM |  |  |  |  |  |  |  | 7:00PM
8:00PM |  |  |  |  |  |  |  | 8:00PM
9:00PM |  |  |  |  |  |  |  | 9:00PM
10:00PM |  |  |  |  |  |  |  | 10:00PM
11:00PM |  |  |  |  |  |  |  | 11:00PM
 | Cancellations or Corrections
 | Date | Time | Customer | Operations Personal | Comments
Spreadsheet: 543084d1508234377-pivot-not-showing-data-when-data-is-present-pivot-not-showing-data-when-data-is-present-pivot-example
Sheet: Sheet3

Year | Supplier | Store | Jan | Feb | Mar | Apr | May | Jun | Jul
2016 | [NAME] | a | 0 | 0 | 1188 | 0 | 893 | 0 | 0
2016 | [NAME] | a | 0 | 0 | 0 | 45 | 0 | 0 | 0
2016 | [NAME] | a | 7575 | 0 | 0 | 0 | 0 | 649.5 | 0
Spreadsheet: 756543d1637621366-retrieve-hours-worked-based-on-day-of-week-in-rota-rota
Sheet: May

 | SUN | MON | TUE | WED | THU | FRI | SAT | SUN | MON | TUE | WED | THU | FRI | SAT | SUN | MON | TUE | WED | THU | FRI | SAT | SUN | MON | TUE | WED | THU | FRI | SAT | SUN | MON | TUE
 | 2021-05-01 00:00:00 | 2021-05-02 00:00:00 | 2021-05-03 00:00:00 | 2021-05-04 00:00:00 | 2021-05-05 00:00:00 | 2021-05-06 00:00:00 | 2021-05-07 00:00:00 | 2021-05-08 00:00:00 | 2021-05-09 00:00:00 | 2021-05-10 00:00:00 | 2021-05-11 00:00:00 | 2021-05-12 00:00:00 | 2021-05-13 00:00:00 | 2021-05-14 00:00:00 | 2021-05-15 00:00:00 | 2021-05-16 00:00:00 | 2021-05-17 00:00:00 | 2021-05-18 00:00:00 | 2021-05-19 00:00:00 | 2021-05-20 00:00:00 | 2021-05-21 00:00:00 | 2021-05-22 00:00:00 | 2021-05-23 00:00:00 | 2021-05-24 00:00:00 | 2021-05-25 00:00:00 | 2021-05-26 00:00:00 | 2021-05-27 00:00:00 | 2021-05-28 00:00:00 | 2021-05-29 00:00:00 | 2021-05-30 00:00:00 | 2021-05-31 00:00:00 |  | Total Hours
[NAME]
Scott
Adam
 | SUN | MON | TUE | WED | THU | FRI | SAT | SUN | MON | TUE | WED | THU | FRI | SAT | SUN | MON | TUE | WED | THU | FRI | SAT | SUN | MON | TUE | WED | THU | FRI | SAT | SUN | MON | TUE
 | 2021-05-01 00:00:00 | 2021-05-02 00:00:00 | 2021-05-03 00:00:00 | 2021-05-04 00:00:00 | 2021-05-05 00:00:00 | 2021-05-06 00:00:00 | 2021-05-07 00:00:00 | 2021-05-08 00:00:00 | 2021-05-09 00:00:00 | 2021-05-10 00:00:00 | 2021-05-11 00:00:00 | 2021-05-12 00:00:00 | 2021-05-13 00:00:00 | 2021-05-14 00:00:00 | 2021-05-15 00:00:00 | 2021-05-16 00:00:00 | 2021-05-17 00:00:00 | 2021-05-18 00:00:00 | 2021-05-19 00:00:00 | 2021-05-20 00:00:00 | 2021-05-21 00:00:00 | 2021-05-22 00:00:00 | 2021-05-23 00:00:00 | 2021-05-24 00:00:00 | 2021-05-25 00:00:00 | 2021-05-26 00:00:00 | 2021-05-27 00:00:00 | 2021-05-28 00:00:00 | 2021-05-29 00:00:00 | 2021-05-30 00:00:00 | 2021-05-31 00:00:00
[NAME]
Scott
Adam
Spreadsheet: 2d531f29-fe25-41d0-aee4-cb0f5e569b41
Sheet: Sheet1

Battle ID | Date & Time | Side | Victory | Score | Opp. Score | Opp. ID | Opp. Name | Scenario ID | Front | Start Date | End Date | Name EN | Name FR
42477020 | 2014-07-27 18:22:55 | AXIS | 1 | 7 | 6 | 1022086 | Mishgan | 7594 | eastern | 1943-07-05 | 1943-07-09 | Ponyri | Ponyri
42477201 | 2014-07-27 18:35:59 | ALLIES | 1 | 7 | 4 | 1022086 | Mishgan | 7594 | eastern | 1943-07-05 | 1943-07-09 | Ponyri | Ponyri
Spreadsheet: kevin_presto__19834__10-16 0900 Report
Sheet: NPCC

NPCC | 2001-10-16 00:00:00
 |  | Full Plant Capacity | Current Plant Output
 |  |  |  |  | Fuel | [NAME] | Unit | On/Off | On/Off | On/Off | On/Off | On/Off | On/Off | On/Off | On/Off | On/Off | On/Off | Comments
OPERATOR | Plant |  |  | Unit # | Type | Heat Rate | Capacity | @ 0700 | @ 0800 | @ 0900 | @1000 | @ 1100 | @ 1200 | @ 1300 | @1400 | @ 1500 | @1600
PGET | Brayton Point |  |  | 1 | Coal | 9799 | 240 | On | On
PGET | Brayton Point |  |  | 2 | Coal | 9484 | 240 | On | On
PGET | Brayton Point |  |  | 3 | Coal | 8984 | 640 | On | On
PGET | Brayton Point |  |  | 4 | FO6 | 10655 | 475 | Off | Off
Wisvest | Bridgeport Harbor |  |  | 1 | FO6 | 10171 | 80 | Off | Off | Off
Wisvest | Bridgeport Harbor |  |  | 2 | FO6 | 9912 | 180 | Off | Off | Off
Wisvest | Bridgeport Harbor |  | 0 | 3 | Coal | 9640 | 400 | Off | Off | Off
Duke | Bridgeport Energy |  |  | 1 | Gas | 12392 | 170 | On | On | On
Duke | Bridgeport Energy |  | 340 | 2 | Gas | 12392 | 170 | On | On | On
Southern | Canal |  |  | 1 | FO6 | 8991 | 580 | Off | Off | Off
Southern | Canal |  | 580 | 2 | FO6 | 9662 | 580 | On | On | On
PGET | [NAME] |  |  | 9 | Gas | 7782 | 165 | On | On | On
PGET | [NAME] |  |  | 10 | Gas | 10540 | 165 | On | On | On
PGET | [NAME] |  | 330 | 11 | Gas | 10540 | 165 | Off | Off | Off
NU | Merrimack |  |  | 1 | Coal | 9721 | 115 |  |  | On
NU | Merrimack |  | 460 | 2 | Coal | 9628 | 345 |  |  | On
NRG | Middletown |  |  | 1 | FO6 | 10505 | 65 |  |  | Off
NRG | Middletown |  |  | 2 | FO6 | 9698 | 115 |  |  | On
NRG | Middletown |  |  | 3 | FO6 | 8995 | 235 |  |  | Off
NRG | Middletown |  | 115 | 4 | FO6 | 10831 | 400 |  |  | Off
Sithe | Mystic |  |  | 4 | FO6 | 9872 | 155 | Off | Off | Off
Sithe | Mystic |  |  | 5 | FO6 | 10777 | 155 | Off | Off | Off
Sithe | Mystic |  |  | 6 | FO6 | 9861 | 155 | Off | Off | Off
Sithe | Mystic |  | 0 | 7 | FO6 | 9597 | 615 | Off | Off | Off
Sithe | New Boston |  |  | 1 | Gas | 9737 | 360 | On | On | On
Sithe | New Boston |  | 720 | 2 | Gas | 9831 | 360 | On | On | On
Wisvest | New Haven Harbor | 465 | 465 | 1 | FO6 | 9373 | 465 | On | On | On
NU | Newington | 415 | 415 | 1 | FO6 | 10699 | 415 | On | On | On
NRG | Norwalk Harbor |  |  | 1 | FO6 | 9625 | 165 | On | On | On
NRG | Norwalk Harbor |  | 330 | 2 | FO6 | 9572 | 165 | On | On | On
PGET | Salem Harbor |  |  | 1 | Coal | 10405 | 80
PGET | Salem Harbor |  |  | 2 | Coal | 10600 | 80
PGET | Salem Harbor |  |  | 3 | Coal | 10312 | 165
PGET | Salem Harbor |  |  | 4 | FO6 | 10595 | 475
NU | [NAME] |  |  | CW1 | FO2 |  | 105 | On | On | On
NU | [NAME] |  |  | CT1 | FO2 | 11425 | 85 | Off | Off | Off
NU | [NAME] |  |  | CT2 | FO2 | 11425 | 85 | Off | Off | Off
NU | [NAME] |  |  | CT3 | FO2 |  | 85 | On | On | On
NU | [NAME] |  | 190 | 1 | FO2 |  | 85 | Off | Off | Off
FPL | Wyman |  |  | 3 | FO6 | 10702 | 115 | On | On | On
FPL | Wyman |  | 745 | 4 | FO6 | 10745 | 630 | On | On | On
Spreadsheet: 725417d1616671816-edit-formula-not-to-consider-blank-cells-with-formulas-problem
Sheet: Sheet2

Order no. | Product |  | Order no. | Product | Component | Notes | Quantiity | Cost |  | Product | Component | Country | Value | Item | Box | Label | Bag |  |  | Component | Component | Component | Box | Label | Bag
MO-1 | Beverage | - |  |  |  | - | - | - |  | Beverage | [Item] Tea | - | - | Beverage | Box A | [NAME] | Bag S |  | Beverage
MO-1 | Food | - |  |  |  | - | - | - |  | Beverage | [Item] Juice | - | - | Flower | [NAME] | [NAME] | Bag M |  | Flower
MO-2 | Flower | - |  |  |  | - | - | - |  | Flower | [Item] Tulip | - | - | Furniture | Box C | [NAME] | Bag L |  | Furniture
MO-3 | Furniture | - |  |  |  | - | - | - |  | Furniture | [Item] Table | - | - | Food | Box D | [NAME] | Bag XL |  | Food
MO-4 | Food | - |  |  |  | - | - | - |  | Furniture | [Item] Chair | - | - | Pets | Box A | [NAME] | Bag M |  | Pets
MO-5 | Food | - |  |  |  | - | - | - |  | Furniture | [Item] Couch | - | -
MO-6 | Flower | - |  |  |  | - | - | - |  | Food | [Item] Bacon | - | -
[NAME] | Flower | - |  |  |  | - | - | - |  | Food | [Item] Egg | - | -
[NAME] | Beverage | - |  |  |  | - | - | - |  | Pets | [Item] Cat | - | -
MO-8 | Furniture | - |  |  |  | - | - | -
MO-9 | Pets | - |  |  |  | - | - | -
 |  | - |  |  |  | - | - | -
 |  | - |  |  |  | - | - | -
 |  | - |  |  |  | - | - | -
 |  | - |  |  |  | - | - | -
 |  | - |  |  |  | - | - | -
 |  | - |  |  |  | - | - | -
 |  | - |  |  |  | - | - | -
 |  | - |  |  |  | - | - | -
 |  | - |  |  |  | - | - | -
 |  | - |  |  |  | - | - | -
 |  | - |  |  |  | - | - | -
 |  | - |  |  |  | - | - | -
 |  | - |  |  |  | - | - | -
 |  | - |  |  |  | - | - | -
 |  | - |  |  |  | - | - | -
 |  | - |  |  |  | - | - | -
 |  | - |  |  |  | - | - | -
 |  | - |  |  |  | - | - | -
 |  | - |  |  |  | - | - | -
 |  | - |  |  |  | - | - | -
 |  | - |  |  |  | - | - | -
 |  | - |  |  |  | - | - | -
 |  | - |  |  |  | - | - | -
 |  | - |  |  |  | - | - | -
 |  | - |  |  |  | - | - | -
 |  | - |  |  |  | - | - | -
 |  | - |  |  |  | - | - | -
 |  | - |  |  |  | - | - | -
 |  | - |  |  |  | - | - | -
 |  | - |  |  |  | - | - | -
 |  | - |  |  |  | - | - | -
 |  | - |  |  |  | - | - | -
 |  | - |  |  |  | - | - | -
 |  | - |  |  |  | - | - | -
 |  | - |  |  |  | - | - | -
 |  | - |  |  |  | - | - | -
 |  | - |  |  |  | - | - | -
 |  | - |  |  |  | - | - | -
 |  | - |  |  |  | - | - | -
 |  | - |  |  |  | - | - | -
 |  | - |  |  |  | - | - | -
 |  | - |  |  |  | - | - | -
 |  | - |  |  |  | - | - | -
 |  | - |  |  |  | - | - | -
 |  | - |  |  |  | - | - | -
Spreadsheet: 867052d1713957663-if-cell-then-return-a-list-book2
Sheet: Final, Summary sheet

IF responses sheet cell says 1A then list all pupils in 1A and the tasks they have completed
IF responses sheet cell says 1B then list all pupils in 1A and the tasks they have completed
Final result (hopefully)
Pupil name | Task completed
Lara Cross | Task 1 | Task 2 | Task 3
[NAME] | Task 1 | Task 2 | Task 3
[NAME] | Task 1 | Task 2 | Task 3
[NAME] | Task 1 | Task 2 | Task 3
[NAME] | Task 1 | Task 2 | Task 3
[NAME] | Task 2 | Task 4 | Task 6
[NAME] | Task 2 | Task 4 | Task 6
Dominik Rose | Task 2 | Task 4 | Task 6
[NAME] | Task 2 | Task 4 | Task 6
[NAME] | Task 2 | Task 4 | Task 6
[NAME] | Task 1 | Task 3 | Task 5
Kannon Lugo | Task 1 | Task 3 | Task 5
[NAME] | Task 1 | Task 3 | Task 5
[NAME] | Task 1 | Task 3 | Task 5
[NAME] | Task 1 | Task 3 | Task 5