tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 04262713-3284-49a3-8ea8-ec8007046175
Sheet: Sheet1

Directions: | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
1. Enter monthly oil/gas costs for your building in the yellow column.
2. Enter your thermostat data in the yellow boxes on the left (experiment if you wish to see changes).
3. If you do not have monthly oil costs, and you only have irregular oil charges, enter the yearly oil costs in cell J-10.
4. If you do not have monthly oil costs, also add your estimated summer monthly oil costs (for domestic hot water) in cell J-11.
5. Mouse-click on the yellow box with NY counties and pick your county to use the correct weather zone.
Old Daytime Winter T-Stat Setpoint | 74 | deg. F |  |  |  |  | For Irregular Fuel-Oil Shipments:
Old Night Winter T-Stat Setpoint | 65 | deg. F |  |  |  |  | Annual Fuel-Oil Cost |  | 62307
Space Balance Temp | 65 | deg. F |  |  |  |  | Estimated Summer Monthly Cost |  | 125
New Daytime T-Stat Setpoint | 70 | deg. F
New Night Winter T-Stat Setpoint | 60 | deg. F |  |  |  |  |  | Delta-T total | 284.9
[NAME] T-Stat Change | 4 | deg. F
Night T-Stat Change | 5 | deg. F
Hours/weekday at Daytime Setpoint | 12 | hours/day |  |  |  |  | Annual Less Summer: |  | 61807
Lowest Monthly Fuel Cost | 125 | per mo.
Select County and [NAME] | ALBANY, HUDSON VALLEY Weather Zone
Zone #: | 5
Month | Average Daily Temp. (1971-2000) | Delta-T | Daytime Delta-T | Night Delta-T | Daytime Space Heating Savings | Night Space Heating Savings | Total Monthly Fuel Costs | Space Heating Only Costs | T-Stat Change Savings
January | 23.1 | 50.9 | 40.9 | 60.9 | 0.097799511002445 | 0.08210180623973727 | 11042.38785538785 | 10917.38785538785 | 957.5436663949179
February | 25.8 | 48.2 | 38.2 | 58.2 | 0.1047120418848167 | 0.0859106529209622 | 10456.64233064233 | 10331.64233064233 | 956.9728619762741
March | 35.4 | 38.6 | 28.6 | 48.6 | 0.1398601398601398 | 0.102880658436214 | 8373.991575991577 | 8248.991575991577 | 957.6057671836894
April | 46.6 | 27.4 | 17.4 | 37.4 | 0.2298850574712644 | 0.1336898395721925 | 5944.232362232363 | 5819.232362232363 | 977.8944999009673
May1 | 57.9 | 16.1 | 6.100000000000001 | 26.1 |  | 0.1915708812260536 | 3492.778869778871 | 3367.778869778871 | 414.7510923372994
June | 66.2 |  |  |  |  |  | 125
July | 71.1 |  |  |  |  |  | 125
August | 69.1 |  |  |  |  |  | 125
September | 61 |  |  |  |  |  | 125
October | 49.7 | 24.3 | 14.3 | 34.3 | 0.2797202797202798 | 0.1457725947521866 | 5271.709722709723 | 5146.709722709723 | 996.4598923441831
November | 39.8 | 34.2 | 24.2 | 44.2 | 0.1652892561983471 | 0.1131221719457013 | 7419.443313443315 | 7294.443313443315 | 961.0667846474153
December | 28.8 | 45.2 | 55.2 | 35.2 | 0.07246376811594203 | 0.1420454545454545 | 9805.813969813971 | 9680.813969813971 | 1134.54156284434
Yearly Total |  |  |  |  |  |  | 62307.00000000001 | 60807.00000000001 | 7356.836127629087
 |  |  |  |  |  |  | Percent Savings: |  | 0.1209866648186736
1. No daytime savings are shown for May because average daytime temperatures are high enough that heat would normally not be operating.
Spreadsheet: 115840d1311331962-entering-values-based-on-3-conditions-example
Sheet: Sheet1

X
X | Y | Z
X | Y | Z |  | Formula 1 | 48 | Array formula - should be confirmed though Ctrl+Shift+Enter
X | Y | Z |  | Formula 2 | 48
X | Y | Z
X | Y | Z |  |  | 48
X | Y | Z
X | Y | Z
X | Y | Z | 3
 | Y | Z | 3
 | Y | Z | 3
 | Y | Z | 3
 | Y | Z | 3
 | Y | Z | 3
 |  | Z | 3
 |  | Z | 3
 |  | Z | 3
 |  | Z | 3
 |  | Z | 3
 |  | Z | 3
 |  | Z | 3
 |  | Z | 3
 |  | Z | 3
 |  | Z | 3
Spreadsheet: 4d89b23b-f7e2-4cc0-9ea1-397c5d966038
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
42777363 | 2014-08-18 16:50:04 | ALLIES | 1 | 6 | 1 | 206845 | [NAME] | 12493 | western | 1944-12-30 | 1944-12-30 | [NAME] | [NAME]
42777520 | 2014-08-18 17:10:11 | AXIS | 0 | 5 | 6 | 206845 | [NAME] | 12493 | western | 1944-12-30 | 1944-12-30 | [NAME] | [NAME]
42800383 | 2014-08-20 05:43:12 | AXIS | 1 | 5 | 3 | 1537209 | bynumbill | 6160 | western | 1944-06-06 | 1944-06-06 | Sword Beach | Sword Beach
42814207 | 2014-08-21 05:53:35 | ALLIES | 0 | 2 | 6 | 1623012 | player1623012 | 12505 | western | 1945-02-17 | 1945-02-20 | Moyland Wood | [NAME]
42814299 | 2014-08-21 06:06:00 | AXIS | 0 | 5 | 6 | 1623012 | player1623012 | 12505 | western | 1945-02-17 | 1945-02-20 | Moyland Wood | [NAME]
42827728 | 2014-08-22 06:15:19 | ALLIES | 1 | 7 | 4 | 1503014 | Agent Avacado | 7661 | eastern | 1944-02-16 | 1944-02-17 | Breakout to Lisyanka | [NAME]
42827983 | 2014-08-22 06:41:38 | AXIS | 0 | 5 | 7 | 1503014 | Agent Avacado | 7661 | eastern | 1944-02-16 | 1944-02-17 | Breakout to Lisyanka | [NAME]
42840564 | 2014-08-23 04:43:16 | AXIS | 0 | 4 | 7 | 1503014 | Agent Avacado | 7661 | eastern | 1944-02-16 | 1944-02-17 | Breakout to Lisyanka | [NAME]
42840861 | 2014-08-23 05:01:40 | ALLIES | 1 | 7 | 2 | 1503014 | Agent Avacado | 7661 | eastern | 1944-02-16 | 1944-02-17 | Breakout to Lisyanka | [NAME]
42870866 | 2014-08-25 05:12:49 | AXIS | 1 | 7 | 2 | 1503014 | Agent Avacado | 7668 | pacific | 1945-02-26 | 1945-03-06 | The Meat Grinder | Le Hachoir à viande
42871027 | 2014-08-25 05:37:18 | ALLIES | 0 | 3 | 7 | 1503014 | Agent Avacado | 7668 | pacific | 1945-02-26 | 1945-03-06 | The Meat Grinder | Le Hachoir à viande
42889697 | 2014-08-26 15:19:45 | AXIS | 0 | 5 | 6 | 1624680 | [NAME] | 7664 | pacific | 1944-07-25 | 1944-07-25 | Japanese Counterattack | Contre-attaque japonaise
42919394 | 2014-08-28 18:51:24 | AXIS | 0 | 5 | 6 | 412088 | [NAME] | 7595 | eastern | 1939-12-16 | 1939-12-16 | Suomussalmi | Suomussalmi
42931660 | 2014-08-29 16:45:28 | AXIS | 0 | 2 | 6 | 1627288 | player1627288 | 12505 | western | 1945-02-17 | 1945-02-20 | Moyland Wood | [NAME]
42931748 | 2014-08-29 17:01:58 | ALLIES | 1 | 6 | 4 | 1627288 | player1627288 | 12505 | western | 1945-02-17 | 1945-02-20 | Moyland Wood | [NAME]
42949511 | 2014-08-30 21:43:59 | AXIS | 0 | 3 | 6 | 1485314 | [NAME] 62 | 6749 | western | 1944-06-06 | 1944-06-06 | [NAME] | [NAME]
42971118 | 2014-09-01 07:18:42 | ALLIES | 0 | 4 | 5 | 1007284 | Temple58 | 6148 | western | 1944-07-25 | 1944-07-26 | Operation Cobra | Opération Cobra
42978962 | 2014-09-01 21:11:26 | AXIS | 1 | 6 | 3 | 1102713 | [NAME] | 12504 | mediterranean | 1943-11-05 | 1943-11-13 | [NAME] | [NAME]
42979341 | 2014-09-01 21:39:05 | ALLIES | 1 | 6 | 4 | 1102713 | [NAME] | 12504 | mediterranean | 1943-11-05 | 1943-11-13 | [NAME] | [NAME]
Spreadsheet: 869723d1716302645-pull-data-through-from-a-worksheet-which-worksheet-is-defined-by-the-value-in-a-cell-template-
Sheet: 010624

Date | Customer | Site | Product | Del. Site | [NAME] | Quantity | Count | Pack Weight (g) | Total No. Packs | Weight (kg) | Total No. Pallets
 | Tesco | A | Peas | A2B | [NAME] | 1 | 12 | 225 | 0 | 0
 | Sainsburys | B | Carrots | B2C | [NAME] | 2 | 12 | 225 | 0 | 0
 | Morrisons | C | Broccoli | C2D | [NAME] | 3 | 12 | 225 | 0 | 0
 | Asda | D | Cauliflower | D2E | [NAME] | 4 | 12 | 225 | 0 | 0
 | Lidl | E | Cabbage | E2F | [NAME] | 5 | 12 | 225 | 0 | 0
 | Aldi | F | Lettuce | F2G | [NAME] | 6 | 12 | 225 | 0 | 0
Spreadsheet: 749139d1632519976-formula-that-displays-the-power-number-of-a-scientific-notation-scientific
Sheet: Blad1

 |  | MrShorty
Spreadsheet: 681674d1591698147-proportion-values-by-dates-sample-mb-v2
Sheet: 10 rows

 |  |  |  | Waste Stripping
 | Totals ---> |  | Period --->
 |  |  | Period Starting ---> | 2020-06-01 00:00:00
 |  |  | Day of week
 |  |  | No. days ---> | 1 | 1 | 1 | 1 | 1 | 1 | Check
Grand Total | Grand Total | Grand Total
Start Date | End Date | Total Stripping |  | Ensure leave column M blank for formula to calculate correctly
2020-06-01 00:00:00 | 2020-06-02 23:28:30.053000 | 6811.622574388399
2020-06-02 23:28:30.053000 | 2020-06-04 22:19:51.674000 | 6628.269106194901
2020-06-04 22:19:51.674000 | 2020-06-06 00:00:00 | 3682.935136949893
2020-06-01 01:15:50.746000 | 2020-06-01 17:41:02.394000 | 2985.999166666666
2020-06-01 17:41:02.394000 | 2020-06-02 06:59:29.270000 | 6653.732781574193
2020-06-01 05:04:34.821000 | 2020-06-01 11:27:10.653000 | 3188.31
2020-06-03 01:00:06.762000 | 2020-06-03 02:35:58.481000 | 798.849861111111
2020-06-03 02:35:58.481000 | 2020-06-03 06:03:49.572000 | 1732.095972222222
2020-06-03 06:03:49.572000 | 2020-06-03 06:09:51.022000 | 50.20138888888889
2020-06-03 06:09:51.022000 | 2020-06-03 12:57:32.241000 | 3397.391527777777
2020-06-02 10:50:48.649000 | 2020-06-02 11:01:09.141000 | 75.410874557
2020-06-02 15:21:16.011000 | 2020-06-02 16:21:02.672000 | 435.901009
2020-06-02 16:21:02.672000 | 2020-06-02 16:22:11.470000 | 8.361264819
2020-06-02 11:01:09.141000 | 2020-06-02 11:39:53.567000 | 282.4965880315925
2020-06-02 11:39:53.567000 | 2020-06-02 18:49:37.359000 | 2689.343166074618
2020-06-02 18:49:37.359000 | 2020-06-02 18:59:33.475000 | 72.448165566
2020-06-02 18:59:33.475000 | 2020-06-02 22:28:33.650000 | 1524.056698834163
2020-06-02 22:28:33.650000 | 2020-06-03 00:04:07.502000 | 696.8575428769096
Spreadsheet: 773502d1647884446-nested-formulas-in-excel-sheet-sample-2-
Sheet: DB

Product | Price
Jik | 60
Sunlight Liq | 70
[NAME] | 70
Vanish | 80
Domestos | 80
Savlon | 80
[NAME] | 80
Cleen Green | 80
[NAME] | 80
[NAME] | 80
Omo Liq | 90
[NAME] | 90
Omo Poeier | 70
[NAME] | 70
Spreadsheet: 672421d1586867491-finding-penultimate-entry-in-a-row-where-the-row-has-blank-cells-demonstration
Sheet: Sheet1

 |  | Date
 |  | D0 | D0 | D1 | D2 | D3 | D4 | D5 | D6 | D7 | D8 | D9 | D10 |  | Penultimate | Last
Mode |  |  |  |  | NIV/CPAP | PRVC | PRVC | It's displaying this one | APRV | Should be this one? | PS/CPAP
FiO2 |  |  |  |  | 0.4 | 0.55 | 0.33 | And this one | 0.5 | Should be this one? | 0.35
Value |  |  |  |  | And this one?! |  |  | 5231 |  | Should be this one? | 6579
Spreadsheet: 704639d1605658925-cashflow-modelling-with-seasonal-quarterly-variance-cashflow-model-sharing-v1
Sheet: Cashflow

 | Cash Flow Forecast |  |  |  | 2021-06-30 00:00:00
 |  | Month | 0 |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 32 | 33 | 34 | 35 | 36
Checks | Expenditure | Start Month | End Month | Total Months
 | Unit A | 1 | 12
 | Unit B | 2 | 13
 | Unit C | 3 | 14
 | Unit D | 4 | 15
 | Unit E | 5 | 16
 | Total |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | bp
 | Income |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  | 6
 |  | 9
 |  | 12
 |  | 12
 |  | 12
 | Total
 | Unlevered Cash Flow
 | [NAME] |  |  |  |  |  |  |  | Budget
 | Unit Type | Days Per Sale | # of Units | Start Date | End Date | Days | Daily Amt |  |  | Costs Per Unit | Total Costs | Sale Price Per Unit | Total Revenue
 |  | 30 | 5 |  |  |  |  |  |  | 10000
 |  | 30 | 5 |  |  |  |  |  |  | 10000
 |  | 45 | 10 |  |  |  |  |  |  | 12000
 |  | 60 | 10 |  |  |  |  |  |  | 15000
 |  | 30 | 20 |  |  |  |  |  |  | 10000
 |  |  |  |  |  |  |  |  | Total
 | Seasonality Index
 | Quarter | % Change
 | Q 1 | -0.5
 | Q 2 | 0
 | Q 3 | 0.5
 | Q 4 | 0
Spreadsheet: 33975d1230939888-how-to-do-a-progressive-add-with-an-if-clause-that-is-interrupted-scratch
Sheet: MainBoard

Period   5       Week   4 | Monday |  | Tuesday |  | Wednesday |  | Thursday |  | Friday |  | Saturday |  | Sunday |  | Total
L.Y.'s Sales/Last Weeks Sls |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
Planned Sales / Accum | 200 | 200 | 200 | 400 | 200 | 600 | 200 | 800 | 200 | 1000 | 200 | 1200 | 200 | 1400 | 1400
Actual Sales/Accum | 250 | 250 | 250 | 500 | 250 | 750 | holiday | 750 | 250 | 1000 | 150 | 1150 | 150 | 1300 | #N/A
Daily Sales Var/Accum Sales Var | 50 | 50 | 50 | 100 | 50 | 150 | -200 | -50 | 50 | 0 | -50 | -50 | -50 | -100 | -100
Admininistration Hours |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
FE Hours |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
Merchandising Hours |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
Major [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
Memberservice Hours |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
Marketing Hours |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
Receiving Hours |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
Tire Center Hours |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
Total Hours (Plan/Actual) | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Daily Hours Var./Acc. [NAME]. |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Planned Payroll $'s/ Act. Payroll $ | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Planned Payroll %/Act. Payroll % | 0 | 0 | 0 | 0 | 0 | 0 | 0 | #N/A | 0 | 0 | 0 | 0 | 0 | 0 | 0 | #N/A
Planned Prod./Act. Prod.  (Total) | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | -
Planned Prod./Act. Prod. (Merch)
Projected Week average salary |  |  |  |  |  |  |  |  |  | Holiday(s) & Inventories |  | Plan  Hrs | Act Hrs | Plan $'s | Act $'s
 | . |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  | Holiday average wage
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Plan $'s with Hol | Act $'s with Hol | Prod with Hol
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | -
Spreadsheet: lynn_blair__24459__Process Resp102901
Sheet: Oct 30 through Nov 5

Week Of: |  |  | Through
DATE | DAY | TEAM | [NAME] | GAS CONTROL | CYCLE | Gas Day
2001-10-30 00:00:00 | Tuesday | South Central | [NAME] | [NAME] | 07:00:00
 |  |  | [NAME] | [NAME] | 08:00:00
 |  |  | [NAME] | [NAME] | 10:00:00
 |  |  | [NAME] | [NAME] | 11:30:00
 |  |  | Scott | [NAME] | 05:00:00
 |  |  | [NAME] | [NAME] | 06:00:00
 | Wednesday |  | [NAME] | [NAME] | 07:00:00
 |  |  |  | [NAME] | 08:00:00
 |  |  | [NAME] | [NAME] | 10:00:00
 |  |  | [NAME] | [NAME] | 11:30:00
 |  |  |  | [NAME] | 05:00:00
 |  |  |  | [NAME] | 06:00:00
 | Thursday |  | [NAME] | [NAME] | 07:00:00
 |  |  |  | [NAME] | 08:00:00
 |  |  | [NAME] | [NAME] | 10:00:00
 |  |  | [NAME] | [NAME] | 11:30:00
 |  |  |  | [NAME] | 05:00:00
 |  |  |  | [NAME] | 06:00:00
 | Friday |  | [NAME] | [NAME] | 07:00:00
 |  |  |  | [NAME] | 08:00:00
 |  |  | [NAME] | [NAME] | 10:00:00
 |  |  | [NAME] | [NAME] | 11:30:00
 |  |  |  | [NAME] | 05:00:00
 |  |  |  | [NAME] | 06:00:00
 | Saturday |  | [NAME] | [NAME] | 07:00:00
 |  | On-Call for Wkd |  | [NAME] | 08:00:00
 |  | [NAME] | [NAME] | [NAME] | 10:00:00
 |  |  | [NAME] | [NAME] | 11:30:00
 |  |  |  | [NAME] | 05:00:00
 |  |  | [NAME] | [NAME] | 06:00:00
 | Sunday |  | [NAME] | [NAME] | 07:00:00
 |  | On-Call for Wkd |  | [NAME] | 08:00:00
 |  | [NAME] | [NAME] | [NAME] | 10:00:00
 |  |  | [NAME] | [NAME] | 11:30:00
 |  |  |  | [NAME] | 05:00:00
 |  |  |  | [NAME] | 06:00:00
 | Monday | North | [NAME] | [NAME] | 07:00:00
 |  |  | [NAME] | [NAME] | 08:00:00
 |  |  | [NAME] | [NAME] | 10:00:00
 |  |  | [NAME] | [NAME] | 11:30:00
 |  |  | [NAME] | [NAME] | 05:00:00
 |  |  | [NAME] | [NAME] | 06:00:00
Weekend Coverage: |  | Saturday | Sunday | SC OnCall | North OnCall
 | [NAME] | 6:30-3:30 | 6:30-3:30
 | [NAME] | 6:30-3:30 | 6:30-3:30 | [NAME] | [NAME]
 | [NAME] | 1:00-10:00 | 1:00-10:00
 | Scott | 1:00-10:00 | 1:00-10:00
Spreadsheet: 847225d1698250686-dropdown-list-with-filtered-values-dropdown-list
Sheet: Sheet3

 | TABLE |  |  | Unique Table with Choice |  |  |  |  |  | DATA |  |  |  | FORMULA
 | Code | Sub Code |  |  |  |  |  |  |  | Title | Code | Sub Code |  | Rows | Choice
 | 001 | A |  |  |  | B |  |  |  | Title A | 002
 | 002 | A |  | 002 |  | B | C |  |  | Title B | 001
 | 002 | B |  | 003 |  |  |  |  |  | Title C | 003
 | 002 | C |  | 004 |  |  |  |  |  | Title D | 002
 | 003 | E
 | 001 | B
 | 004 | C
Spreadsheet: 217736d1362163068-lists-data-validation-afhankelijke-keuzelijst-pcb-5a
Sheet: Blad1

Project | Component | Element | seq |  |  |  |  |  |  |  |  |  |  |  |  | HighRecKolA: | 26
Project1 | Component1 | Element1 | 1 |  |  | Project | Component | Element |  |  |  |  |  |  |  |  | Dokters
Project1 | Component3 | Element1 | 2 |  | ok | Project2 | Component2 | Element2 | ok |  |  |  |  |  |  |  | Project1
Project1 | Component5 | Element1 | 3 |  | ok | Project3 | Component2 | Element3 | ok |  |  |  |  |  |  |  | Project2
Project1 | Component2 | Element1 | 4 |  | ok | Project1 | Component2 | Element1 | ok |  |  |  |  |  |  |  | Project3
Project1 | Component3 | Element2 | 5 |  | Input ! |  |  |  | ok
Project1 | Component1 | Element4 | 6 |  | Input ! |  |  |  | ok
Project1 | Component5 | Element1 | 7
Project1 | Component2 | Element1 | 8
Project1 | Component5 | Element3 | 9
Project1 | Component3 | Element3 | 10
Project1 | Component3 | Element1 | 11
Project1 | Component3 | Element2 | 12
Project1 | Component1 | Element3 | 13
Project1 | Component4 | Element1 | 14
Project2 | Component2 | Element2 | 15
Project2 | Component3 | Element2 | 16
Project2 | Component1 | Element1 | 17
Project2 | Component1 | Element2 | 18
Project2 | Component4 | Element1 | 19
Project2 | Component5 | Element4 | 20
Project3 | Component2 | Element3 | 21
Project3 | Component1 | Element2 | 22
Project3 | Component2 | Element3 | 23
Project3 | Component5 | Element1 | 24
Project3 | Component4 | Element1 | 25
Spreadsheet: 835490d1688630200-finding-6-months-or-more-apart-date-6-months-apart-dates-1-
Sheet: Export

Assessment |  |  |  |  |  |  |  |  |  |  | Audiometry surveillance | Colour Vision Critical | Confined Spaces | FLT assessment | Food Handling | HAVS surveillance | Ionising Radiation | Manual Handling | Nightworker | Respiratory surveillance | Skin surveillance | [NAME] | Work at Heights
Unique ID | Surname | Forename | Job Title | Date of Birth | [NAME] | Division | Location | Department | Line Manager | Line Manager [NAME] | Latest Recall Date | Latest Recall Date | Latest Recall Date | Latest Recall Date | Latest Recall Date | Latest Recall Date | Latest Recall Date | Latest Recall Date | Latest Recall Date | Latest Recall Date | Latest Recall Date | Latest Recall Date | Latest Recall Date | 6 Months Apart | 6 Months Plus
10000042 | [NAME] | [NAME] | FLT | 1988-11-27 00:00:00 | [EMAIL] | Ireland | Ireland | Ireland | Test Test | [EMAIL] | 2023-06-28 00:00:00 |  | 2023-06-28 00:00:00 |  | 2023-06-28 00:00:00 |  |  |  |  | 2023-06-29 00:00:00
10000051 | [NAME] | Anna | Quality Assurance Technician | 1977-02-26 00:00:00 | [EMAIL] | Ireland | Ireland | Ireland | Test Test | [EMAIL] | 2023-09-12 00:00:00 |  |  |  |  |  |  |  | 2023-06-29 00:00:00 | 2023-06-29 00:00:00
10000052 | Barclay | [NAME] | Capri | 1971-04-20 00:00:00 | [EMAIL] | Ireland | Ireland | Ireland | Test Test | [EMAIL] | 2024-05-25 00:00:00 |  |  |  | 2025-05-25 00:00:00 |  |  |  |  | 2023-06-29 00:00:00 | 2023-06-29 00:00:00 |  |  |  | Food Handling, Audiometry surveillance
10000055 | Bekey-Mills | [NAME] |  | 1963-07-03 00:00:00 | [EMAIL] | Ireland | Ireland | Ireland | Test Test | [EMAIL] | 2023-01-27 00:00:00 |  | 2023-01-27 00:00:00 |  | 2023-01-27 00:00:00 |  |  |  | 2023-06-27 00:00:00 | 2023-06-27 00:00:00 |  |  |  | Nightworker,Respiratory surveillance
10000056 | [NAME] | [NAME] |  | 1979-05-10 00:00:00 | [EMAIL] | Ireland | Ireland | Ireland | Test Test | [EMAIL] | 2024-01-19 00:00:00 |  |  |  |  |  |  |  | 2023-06-29 00:00:00 | 2023-06-29 00:00:00 | 2023-06-29 00:00:00 |  | 2023-06-29 00:00:00 |  | Audiometry surveillance
10000058 | [NAME] | [NAME] '[NAME]' | Tech Op | 2001-10-18 00:00:00 | [EMAIL] | Ireland | Ireland | Ireland | Test Test | [EMAIL] | 2023-06-28 00:00:00 |  |  |  | 2023-06-28 00:00:00 |  |  |  | 2023-06-29 00:00:00 | 2023-06-29 00:00:00
10000059 | Briody | Jordan | Engineer | 1997-02-12 00:00:00 | [EMAIL] | Ireland | Ireland | Ireland | Test Test | [EMAIL] | 2023-05-18 00:00:00 |  |  |  | 2023-05-18 00:00:00 |  |  | 2023-05-18 00:00:00 |  | 2023-11-29 00:00:00 |  |  |  |  | Respiratory surveillance
10000060 | Briody | Mark | STORES | 1977-04-15 00:00:00 | [EMAIL] | Ireland | Ireland | Ireland | Test Test | [EMAIL] | 2024-05-26 00:00:00 |  | 2028-05-26 00:00:00 |  |  |  |  |  |  | 2023-06-29 00:00:00
Spreadsheet: 80910d1281054120-trouble-with-scaling-and-rounding-sample
Sheet: Sheet1

 | Multiplier: | 1
Base | 1
1000
Spreadsheet: 330402d1404739728-add-criteria-to-existing-formula-and-skip-blanks-if-criteria-not-met-and-move-to-next-cell-formula
Sheet: Sheet2

Name | Outcome | Date | Helper |  |  | Criterion | Array formula result
Mr [NAME] | Open | 2014-02-01 00:00:00 |  |  |  | Mr SmithOpen
Mr [NAME] | Disqualified | 2014-02-02 00:00:00
Mr [NAME] | Qualified | 2014-02-03 00:00:00
Mr Barnes | Qualified | 2014-02-04 00:00:00
Mr [NAME] | Qualified | 2014-02-05 00:00:00
Mr [NAME] | Open | 2014-02-06 00:00:00
Mr [NAME] | Qualified | 2014-02-07 00:00:00
Mr [NAME] | Qualified | 2014-02-08 00:00:00
Mr [NAME] | Disqualified | 2014-02-09 00:00:00
Mr [NAME] | Open | 2014-02-10 00:00:00
Mr [NAME] | Open | 2014-02-11 00:00:00
Mr Barnes | Qualified | 2014-02-12 00:00:00
Spreadsheet: 023d2960-d613-437c-bfcd-2f8a30cfa5ae
Sheet: Sheet1

Unnamed: 0 | [NAME] | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13
 | APENs: Kiln System |  |  |  |  |  |  |  |  |  | Projected Annual Emissions at Permitted Production
 | year | NOx [tpy] | SO2 [tpy] | PM/PM10 [tpy] | Clinker (C) Production [tpy] |  | NOx [lb/tons C] | SO2 [lb/tons C] | PM/PM10 [lb/tons C] |  | NOx [tpy] | SO2 [tpy] | PM/PM10 [tpy]
 | 2004 | 2741.3 | 780.6 |  | 1641423 |  | 3.340150588848822 | 0.951125943769522 |  |  | 3129.550754071315 | 891.1565018889098 | 0
 | 2005 | 2572.3 | 371.5 | 59.7 | 1642740 |  | 3.131718957351742 | 0.4522931200311675 | 0.07268344351510282 |  | 2934.260945371757 | 423.7755865200823 | 68.10067971803207
 | 2006 | 3098 | 366.4 |  | 1686451 |  | 3.673987563231899 | 0.4345219635791375 |  |  | 3442.338973382565 | 407.1249192535092 | 0
 | 2007 | 2439.7 | 188.9 | 68.62 | 1361523 |  | 3.583780810166262 | 0.2774833770711181 | 0.1007988847782961 |  | 3357.819846304469 | 259.9877726634071 | 94.44341429413973
 | 2008 | 2287 | 305.8 | 47.23 | 1332888 |  | 3.43164616982072 | 0.4588532569878339 | 0.07086867013582536 |  | 3215.277447167354 | 429.922100281494 | 66.40032961509144
 | Average Rates: | 2627.66 | 402.64 | 58.51666666666666 |  |  | 3.43 | 0.51 | 0.08 |  | 3215.849593259492 | 482.3933761214805 | 45.78888472545265
 |  |  | Maximum Level
 | Permitted Production:
 | Clinker: | 1873898
Spreadsheet: 0be74c79-6b40-408e-bd9c-5139430afc9d
Sheet: Capacity Zone

Projected Share - Installed Capacity Requirement Report
SP_PROJECTEDSHAREICR_<customer id>_<commitment period begin>_<version>.CSV
<[NAME]
Date: <mm/dd/yyyy> and Version: <mm/dd/yyyy hh:[NAME]:ss> GMT
Capacity Zone Information
Capacity Zone ID | Capacity Zone Name | Capacity Zone Projected ICR | Customer Share of Capacity Zone Projected ICR | Capacity Zone Peak Contributions
Number | String | MW | MW | MW
Foot Note:
The Capacity Zone Projected ICR values are for determining the total quantity of capacity that a load serving entity may designate for self-supply only
and calculated pursuant to ISO-NE Market Rules and Manuals.  The Capacity Zone Projected ICR values shown in this report are based on preliminary ICR
values for the subject Capacity Commitment Period and will not necessarily be the same as those used when determining a Market Participant’s actual
capacity requirements during the Capacity Commitment Period.
Spreadsheet: 376253d1423533425-find-value-that-doesnt-match-and-bring-back-column-heading-find-value-that-doesnt-match-and-index-column-heading-1-ndmv2
Sheet: Year 1

PersID | PosCode | Org1 | Org2 | Org3
1001 | 21 | 8 | A1 | SS1
1002 | 21 | 9 | A2 | DW2
1003 | 22 | 11 | B1 | D34
1004 | 23 | 12 | B2 | AQ1
1005 | 23 | 21 | C1 | SS2