tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 878845d1726148274-nested-formula-to-handle-8-scenarios-integrations-hours
Sheet: Lookups

Integration Pattern | Integration Type | High Level Description | Developer lookup table | Complexity |  | Time to compile script(min) | Time to ST Test (min) | Total (min) |  | [NAME] up table | Complexity |  | Time for Data set up(min) | Time to Unit Test (min) | Total (min)
EXPORT-EXT1 | EXPORT EXTERNAL | ANON |  | 1 | Simple | 15 | 45 |  |  |  | 1 | Simple | 30 | 45
EXPORT-EXT2 | EXPORT EXTERNAL | ANON |  | 2 | Moderate | 30 | 60 |  |  |  | 2 | Moderate | 60 | 60
EXPORT-EXT3 | EXPORT EXTERNAL | ANON |  | 3 | Complex | 60 | 120 |  |  |  | 3 | Complex | 100 | 80
EXPORT-EXT4 | EXPORT EXTERNAL | ANON |  | 4 | Hard | 120 | 240 |  |  |  | 4 | Hard | 120 | 180
EXPORT-EXT5 | EXPORT EXTERNAL | ANON |  | 5 | E2E | 180 |  |  |  |  | 5 | E2E | 360 | 180
EXPORT-EXT6 | EXPORT EXTERNAL | ANON
EXPORT-INT1 | EXPORT INTERNAL | ANON
EXPORT-INT2 | EXPORT INTERNAL | ANON
EXPORT-INT3 | EXPORT INTERNAL | ANON
EXPORT-INT4 | EXPORT INTERNAL | ANON
EXPORT-INT5 | EXPORT INTERNAL | ANON
EXPORT-INT6 | EXPORT INTERNAL | ANON
IMPORT-EXT1 | IMPORT EXTERNAL | ANON
IMPORT-EXT2 | IMPORT EXTERNAL | ANON
IMPORT-EXT3 | IMPORT EXTERNAL | ANON
IMPORT-EXT4 | IMPORT EXTERNAL | ANON
IMPORT-EXT5 | IMPORT EXTERNAL | ANON
IMPORT-EXT6 | IMPORT EXTERNAL | ANON
IMPORT-INT1 | IMPORT INTERNAL | ANON
IMPORT-INT2 | IMPORT INTERNAL | ANON
IMPORT-INT3 | IMPORT INTERNAL | ANON
IMPORT-INT4 | IMPORT INTERNAL | ANON
WEB_SERVICE | WEB_SERVICE | ANON
SPLUNK | SPLUNK | ANON
REF_ONLY
Spreadsheet: 599050d1542832138-add-date-to-spreadsheet-from-multiple-workbooks-orders-sample
Sheet: Invoice Summary

 | Cost | Amt Paid | Amt Outstanding
Running Total
Name | Order Date | Del Date | Delivery address/Venue | [NAME] | Poducts | Cost | Amt Paid | Amt Outstanding | Payment Due | Inv #
 |  |  |  |  |  |  |  |  |  | HEP029
 |  |  |  |  |  |  |  |  |  | HEP030
 |  |  |  |  |  |  |  |  |  | HEP031
 |  |  |  |  |  |  |  |  |  | HEP032
 |  |  |  |  |  |  |  |  |  | HEP033
 |  |  |  |  |  |  |  |  |  | HEP034
 |  |  |  |  |  |  |  |  |  | HEP035
 |  |  |  |  |  |  |  |  |  | HEP036
 |  |  |  |  |  |  |  |  |  | HEP037
 |  |  |  |  |  |  |  |  |  | HEP038
 |  |  |  |  |  |  |  |  |  | HEP039
 |  |  |  |  |  |  |  |  |  | HEP040
 |  |  |  |  |  |  |  |  |  | HEP041
 |  |  |  |  |  |  |  |  |  | HEP042
 |  |  |  |  |  |  |  |  |  | HEP043
 |  |  |  |  |  |  |  |  |  | HEP044
 |  |  |  |  |  |  |  |  |  | HEP045
 |  |  |  |  |  |  |  |  |  | HEP046
 |  |  |  |  |  |  |  |  |  | HEP047
 |  |  |  |  |  |  |  |  |  | HEP048
Spreadsheet: 116532d1311884170-change-referenced-cell-value-without-changing-formula-test
Sheet: Sheet1

Label | Item
Insert [Part] | 1 |  |  |  | 1 | 2 | 3
Attach [Part] | 2 |  |  |  | Insert [Part] | Attach [Part] | Break [Part]
Break [Part] | 3
Break [Part] | 3
Attach [Part] | 2
Attach [Part] | 2
Insert [Part] | 1
Insert [Part] | 1
Spreadsheet: 715589d1611771435-bonus-structure-formula-bonus
Sheet: Bonus Structure

 | Bonus Structure |  |  | Month | Revenue | Bonus
 | £0 - £4,999 | 0.08 |  | January | 8000
 | £5,000 - £7,499 | 0.12 |  | February | 15000
 | £7,500 - £9,999 | 0.14 |  | March
 | £10,000 - £12,499 | 0.2 |  | April
 | £12,500 - £14,999 | 0.23 |  | May
 | £15,000 + | 0.25 |  | June
 |  |  |  | July
 |  |  |  | August
 |  |  |  | September
 |  |  |  | October
 |  |  |  | November
 |  |  |  | December
 |  |  |  | Total
 |  |  |  | Min | [NAME] | Rate | Difference
 |  |  |  | 0 | 4999.99 | 0.08
 |  |  |  | 5000 | 7499.99 | 0.12
 |  |  |  | 7500 | 9999.99 | 0.14
 |  |  |  | 10000 | 12499.99 | 0.2
 |  |  |  | 12500 | 14999.99 | 0.23
 |  |  |  | 15000 | 1000000 | 0.25
Spreadsheet: 120421d1315280573-modify-table-range-management-visit-tracker-rev-1
Sheet: DATA  & INSTRUCTIONS

 | Code | SHIPS |  | Code | Visit type |  | Instructions
 | AQEX | [NAME] |  | CIEN | Client |  | 1. Record each visit to ship
 | GACA | Go [NAME] |  | DMOB | Demob |  | 2. Ship is selected from dropdown list
 | GALT | Go [NAME] |  | EXTA | External Audit |  | 3. Visit type is recorded from dropdown list
 | GCOU | Go Cougar |  | EXTI | External Inspection |  | 4. Select Primary reason for visit if more than one
 | GEME | Go Emerald |  | GENM | General Management |  | 6. Ships can be added to list opposite
 | GEWV | Geowave Voyager |  | INDR | Industrial Relations |  | 7. names can be added as needed
 | GISH | GO INSHORE Fleet |  | INTA | Internal Audit |  | 8. rows can be added if needed
 | HAVH | [NAME] |  | INTI | Internal Inspection |  | 9. the table tabs can be used to sort by person/ship etc
 | NEPT | Neptune Trident |  | INVG | Investigation
 | REME | Rem Etive |  | MOBN | Mobilisation
 | SANC | [NAME] |  | OTHR | Other
 | TDAU | [NAME] |  | PROJ | Project Induction
 | TDEF | [NAME] |  | SAFE | Safety
 | TSOL | [NAME] |  | TECH | Technical
 | UDIS | UOS Discovery |  | TRAN | Training
 | GPOL | GO POLARIS |  | CC | Crew Change
 | GCAN | GO CANOPUS |  | DD | Dry Docking
 | GCAP | GO CAPELLA |  | ADD: | Survey
 | GDS1 | DEEP SEA 1 |  | ADD:
 | GSEA | SEALINK 161
 | GMAM | GS Mamta
 | GMAN | [NAME]
 | MEND | [NAME]
 | JSOF | Jul Sofus K
 | UCOL | UOS Columbia
 | CECK | Cecile K
 | GRIG | GO RIGEL
 | OOPA | OOC PANTHER
Spreadsheet: 103866d1301532219-due-date-multiple-return-values-date-1-
Sheet: Sheet1 

 | Name | Start | Finish | Level | Birthday | Age | Time remaining
 | Name | Start | Finish | Level | Birthday | Age | Time remaining
1 | [NAME] | 2010-09-13 00:00:00 | 2011-12-30 00:00:00 | 要支援　２
2 | [NAME] | 2011-01-01 00:00:00 | 2011-12-31 00:00:00 | 要介護　１
3 | [NAME] | 2010-11-29 00:00:00 | 2011-05-31 00:00:00 | 要支援　２
4 | [NAME] | 2010-10-01 00:00:00 | 2011-09-30 00:00:00 | 要介護　２
5 | [NAME] | 2010-08-01 00:00:00 | 2011-07-31 00:00:00 | 要介護　２
6 | [NAME] | 2011-02-01 00:00:00 | 2011-07-31 00:00:00 | 要介護　４
7 | [NAME] | 2010-03-01 00:00:00 | 2011-02-28 00:00:00 | 要支援　２
8 | [NAME] | 2010-11-01 00:00:00 | 2012-10-31 00:00:00 | 要介護　５
9 | [NAME] | 2011-02-01 00:00:00 | 2011-07-31 00:00:00 | 要支援　１
10 | [NAME] | 2010-08-01 00:00:00 | 2011-07-31 00:00:00 | 要介護　１
11 | [NAME] | 2009-08-01 00:00:00 | 2011-07-31 00:00:00 | 要介護　４
12 | [NAME] | 2011-01-01 00:00:00 | 2011-12-31 00:00:00 | 要介護　４
13 | [NAME] | 2009-06-01 00:00:00 | 2011-05-31 00:00:00 | 要介護　４
14 | [NAME] | 2011-01-01 00:00:00 | 2011-12-31 00:00:00 | 要介護　４
15 | [NAME] | 2011-02-04 00:00:00 | 2011-08-31 00:00:00 | 要介護　４
16 | [NAME] | 2010-12-03 00:00:00 | 2011-06-30 00:00:00 | 要介護　１
17 | [NAME] | 2010-10-01 00:00:00 | 2011-09-30 00:00:00 | 要介護　３
18 | [NAME] | 2010-07-01 00:00:00 | 2012-06-30 00:00:00 | 要介護　３
19
20
21
22
23
24
25
 | Name | Period |  | Level | Birthday | Age | Time remaining
 | [NAME] | 2010-11-01 00:00:00 | 2011-04-30 00:00:00 | 要介護　３
 | [NAME] | 2011-12-01 00:00:00 | 2011-11-30 00:00:00 | 要介護　２
 | [NAME] | 2010-09-01 00:00:00 | 2011-08-31 00:00:00 | 要介護　４
 | [NAME] | 2010-08-01 00:00:00 | 2011-07-31 00:00:00 | 要介護　２
 | [NAME] | 2010-07-01 00:00:00 | 2011-06-30 00:00:00 | 要介護　１
 | [NAME] | 2010-04-01 00:00:00 | 2011-03-25 00:00:00 | 要介護　３
 | [NAME] | 2010-07-01 00:00:00 | 2011-06-30 00:00:00 | 要介護　１
 | [NAME] | 2010-08-01 00:00:00 | 2011-07-31 00:00:00 | 要介護　３
 | [NAME] | 2010-02-01 00:00:00 | 2011-01-31 00:00:00 | 要介護　１
Spreadsheet: 686007d1594311275-help-writing-a-function-to-use-a-data-table-based-on-value-budget-style-proposal
Sheet: Sheet1

 | INPUT CELLS IN YELLOW ONLY
 |  |  |  |  |  |  |  |  | Up to
 | Annual Target ($) |  | 4980000 |  | Commission Tiers |  | % of target: |  | 0.5 | 0.75 | 1 | 1.25 | 1.5 | 1.75 | 2 | 2.25 | Over
 | Target Gross Proffit |  | 0.5 |  |  |  | Commission Rate: |  | 0.05 | 0.055 | 0.06 | 0.075 | 0.08 | 0.085 | 0.09 | 0.095 | 0.1
 |  |  |  |  |  |  |  |  | Min Rate |  |  | Target Rate |  |  |  |  | [NAME]
 |  |  |  | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Total | Check
 | Monthly Budget |  |  | 415000 | 415000 | 415000 | 415000 | 415000 | 415000 | 415000 | 415000 | 415000 | 415000 | 415000 | 415000
 | Actual Sales |  |  | 319881.64 | 151329.47 | 139143.8 | 173303.25 | 137659.99 | 175759.94
 | Cumulative for year
 | Target ($)
 | Actual ($) |  |  | 319881.64 | 151329.47 | 139143.8 | 173303.25 | 137659.99 | 175759.94
 | % of target
 |  |  | Up to
 | Commission Rate Calculation:
 |  |  | Actual
 | Actual Sales |  |  | 319881.64 | 151329.47 | 139143.8 | 173303.25 | 137659.99 | 175759.94
 | Commission Rate
 | Pre-Commission Payable
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | G.P. | Comm. Rate
 | Gross Profit |  |  | 0.55 | 0.52 | 0.45 | 0.5 | 0.51 | 0.4 |  |  |  |  |  |  |  |  | >20% | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20-29% | 0.55
 | Gross Profit Commission Rate |  |  | 1 | 1 | 0.85 | 1 | 1 | 0.7 |  |  |  |  |  |  |  |  | 30-39% | 0.7
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 40-49% | 0.85
 | Total Commision Payable |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 50-59% | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 60-69% | 1.15
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 70-79% | 1.3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 79%< | 1.5
Spreadsheet: 776835d1649938935-mortgage-payout-analysis-mortgage-payment-schedule
Sheet: Sheet1

financed | 300000 | APR = | 0.05
months | payment | balance
1
2
3
4 |  |  | if you want to change the payment from what is in B3 and repoint the amount, enter it in some cell in col B
5
6
7
8 |  |  |  | insert -1650 in B10 here to see how the payoff changes below.
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
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
Spreadsheet: 837581d1690271443-add-hours-that-cross-midnight-times-across-midnight-aligw
Sheet: Sheet1

 | Employee enters Start Time | Employee enters End Time |  | Adds B and C for duration |  | Employee makes a choice | Employee makes a choice | Subtracts F from G and H | <<< Subtracts G+H from E!!!
 | Travel Times |  | Reason for Stop | Travel Hours | Did you work? | Hours | Meal Period | Travel Comp Hours
 | Start | Stop |  |  |  | Worked
 | 04:35:00 | 22:17:00 | Awaiting Transportation |  | Yes | 08:00:00 | 00:30:00
 |  | 0:30:00 | Waiting Period
 |  | 2:43:00
 |  |  | Waiting Period
 |  |  | Waiting Period
Spreadsheet: john_forney__15531__s_9-18-01
Sheet: Sheet1

Flow Date |  | Available Off Peak Capacity |  |  |  |  |  |  | Available On Peak Capacity |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Available Off Peak Capacity
2001-09-18 00:00:00
Counterparty |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  | -50 | -50 | -50 | -50 | -50 | -50 | -50 | -50 | -50 | -50 | -50 | -50
Enron Call |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Mirant Call |  |  |  |  |  |  |  |  |  |  |  |  | -50 | -50 | -50 | -50 | -50 | -50 | -50 | -50 | -50 | -50 | -50 | -50
CP1 |  |  |  |  |  |  |  |  |  |  |  |  | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50
Total
[NAME]: |  | Deal Details
23.25
Deal_id |  | CP | Volume | Price | Start Hour |  | End Hour
 |  | Mirant Call | -50 |  | 12 |  | 23
777411.1 |  | [NAME] | -50 | 23.25 | 12 |  | 23
758660.11 |  | Enron Call | -100 |  | 7 |  | 22
777054.1 |  | Enron Call | 100 |  | 7 |  | 22
777300.1 |  | CP1 | 50 | 23.25 | 12 |  | 23
Spreadsheet: john_lavorato__16617__ENA Participation
Sheet: Interviewers

First Name | Last Name | Business Unit | Title | Extension | 2001-10-26 00:00:00 | 2001-11-03 00:00:00 | 2001-11-03 00:00:00 | 2001-11-16 00:00:00 | 2001-12-01 00:00:00
[NAME] | [NAME] | ENA | Mgr. | 57754 |  |  |  | x
Mark | Breese | ENA | Mgr. | 36751 |  |  |  | x
[NAME] | Concannon | ENA | Director | 31667
Santiago | [NAME] | ENA | Associate | 53561 |  |  |  | Reserve
[NAME] | Heintzelman | ENA | Mgr. | 57024 | x
[NAME] | Jafry | ENA | Director | 33206 | x
Fred | Lagrasta | ENA | VP | 36529 |  |  |  |  | x
[NAME] | Little | ENA | Associate | 53419 |  |  |  | Reserve
[NAME] | [NAME] | ENA | VP | 37657 | x |  |  |  | x
[NAME] | Meyn | ENA | Director | 53223 |  | x |  |  | x
[NAME] | [NAME] | ENA | Mgr. | 30589 |  |  |  | x
[NAME] | Quick | ENA | Sr. Director | 33152 | x
[NAME] | Tricoli | ENA | VP | 58958 | x
Lloyd | Will | ENA | Director | 33383 |  | x |  |  | x
Spreadsheet: 804315d1667998497-large-nested-if-statements-how-to-improve-revtest
Sheet: InvoiceExport

 |  |  |  |  | PROCESSNAME |  | Package | ProcessFee | BoxFee | HandlingCount | HandlingFee | ItemTotal | OrderType
 |  |  |  |  |  |  |  |  |  |  |  |  | B2C
Spreadsheet: 424863d1444854977-zigzag-indicator-calculation-zigzag
Sheet: Status 2 (ZigZag)

S&P 500
Date | Open | High | Low | Close | Point | % Diff | New Base
2015-08-25 00:00:00 | 1898.079956 | 1948.040039 | 1867.079956 | 1867.609985 |  |  | 1906.56
2015-08-26 00:00:00 | 1872.75 | 1943.089966 | 1872.75 | 1940.51001
2015-08-27 00:00:00 | 1942.77002 | 1989.599976 | 1942.77002 | 1987.660034
2015-08-28 00:00:00 | 1986.060059 | 1993.47998 | 1975.189941 | 1988.869995
2015-08-31 00:00:00 | 1986.72998 | 1986.72998 | 1965.97998 | 1972.180054
2015-09-01 00:00:00 | 1970.089966 | 1970.089966 | 1903.069946 | 1913.849976
2015-09-02 00:00:00 | 1916.52002 | 1948.910034 | 1916.52002 | 1948.859985
2015-09-03 00:00:00 | 1950.790039 | 1975.01001 | 1944.719971 | 1951.130005
2015-09-04 00:00:00 | 1947.76001 | 1947.76001 | 1911.209961 | 1921.219971
2015-09-08 00:00:00 | 1927.300049 | 1970.420044 | 1927.300049 | 1969.410034
2015-09-09 00:00:00 | 1971.449951 | 1988.630005 | 1937.880005 | 1942.040039
2015-09-10 00:00:00 | 1941.589966 | 1965.290039 | 1937.189941 | 1952.290039
2015-09-11 00:00:00 | 1951.449951 | 1961.050049 | 1939.189941 | 1961.050049
2015-09-14 00:00:00 | 1963.060059 | 1963.060059 | 1948.27002 | 1953.030029
2015-09-15 00:00:00 | 1955.099976 | 1983.189941 | 1954.300049 | 1978.089966
2015-09-16 00:00:00 | 1978.02002 | 1997.26001 | 1977.930054 | 1995.310059
2015-09-17 00:00:00 | 1995.329956 | 2020.859985 | 1986.72998 | 1990.199951
2015-09-18 00:00:00 | 1989.660034 | 1989.660034 | 1953.449951 | 1958.079956
2015-09-21 00:00:00 | 1960.839966 | 1979.640015 | 1955.800049 | 1966.969971
2015-09-22 00:00:00 | 1961.390015 | 1961.390015 | 1929.219971 | 1942.73999
2015-09-23 00:00:00 | 1943.23999 | 1949.52002 | 1932.569946 | 1938.76001
2015-09-24 00:00:00 | 1934.810059 | 1937.170044 | 1908.920044 | 1932.23999
2015-09-25 00:00:00 | 1935.930054 | 1952.890015 | 1921.5 | 1931.339966
2015-09-28 00:00:00 | 1929.180054 | 1929.180054 | 1879.209961 | 1881.77002
2015-09-29 00:00:00 | 1881.900024 | 1899.47998 | 1871.910034 | 1884.089966
2015-09-30 00:00:00 | 1887.140015 | 1920.530029 | 1887.140015 | 1920.030029
2015-10-01 00:00:00 | 1919.650024 | 1927.209961 | 1900.699951 | 1923.819946
2015-10-02 00:00:00 | 1921.77002 | 1951.359985 | 1893.699951 | 1951.359985
2015-10-05 00:00:00 | 1954.329956 | 1989.170044 | 1954.329956 | 1987.050049
2015-10-06 00:00:00 | 1986.630005 | 1991.619995 | 1971.98999 | 1979.920044
Spreadsheet: 853489d1703342883-disappearing-goal-line-on-chart-goal-line-issue
Sheet: Goal Line Issue

[NAME] | Emp 1 | Emp 2 | Emp 3 | Emp 4 | Emp 5
GOAL | 85 | 85 | 85 | 85 | 85
2023-01-01 00:00:00 | 130 | 50 | 12 | 40 | 58
2023-02-01 00:00:00 | 110 | 80 | 60 | 80 | 83
2023-03-01 00:00:00 | 115 | 85 | 50 | 40 | 73
2023-04-04 00:00:00 | 110 | 105 | 60 | 75 | 70
2023-05-01 00:00:00 | 120 | 105 | 45 | 30 | 75
2023-06-01 00:00:00 | 100 | 100 | 35 | 45 | 70
2023-07-01 00:00:00
Spreadsheet: 690347d1597062023-weekly-cash-flow-flipa-cashflow-v2
Sheet: Sheet1

 |  |  |  | Payment Days: | 8 | Payment Days: | 25
 |  | Invoiced |  | Payment terms from Invoice date |  | Payment days from Invoice month end
 |  | 2020-08-03 00:00:00 | 10000
 |  |  | 10000
 |  |  | 10000
 |  |  | 10000
 |  |  | 10000
 |  |  | 10000
 |  |  | 10000
Spreadsheet: 470954d1468794128-i-need-an-excel-formula-that-will-show-negative-in-the-variance-line-if-actual-is-zero-excel-formula
Sheet: Sheet1

 |  |  | 2016-10-01 00:00:00 | 2016-11-01 00:00:00 | 2016-12-01 00:00:00 | 2016-01-01 00:00:00 | 2016-02-01 00:00:00 | 2016-03-01 00:00:00 | 2016-04-01 00:00:00 | 2016-05-01 00:00:00 | 2016-06-01 00:00:00 | 2016-07-01 00:00:00 | 2016-08-01 00:00:00 | 2016-09-01 00:00:00
 |  | plan | 25 | 30 | 35 | 40 | 45 | 50 | 60 | 70 | 80 | 105 | 120 | 130
 |  | actual | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | variance
Spreadsheet: 814562d1674487645-waterfall-simplification-sample-43-ans
Sheet: New infra planner

New |  |  | 0.05 | 0.05 | 0.05 | 0.05 | 0.05 | 0.05 | 0.05 | 0.05 | 0.05 | 0.05 | 0.05
Month | Plan | APR | MAY | JUN | JUL | AUG | SEP | OCT | NOV | DEC | JAN | FEB | MAR | YTD |  |  |  |  |  | [NAME] for Cf C4="",  color ->>Fill-> >Grey
APR | 30
MAY | 30
JUN | 30
JUL | 30
AUG | 30
SEP | 30
OCT | 30
NOV | 30
DEC | 30
JAN | 30
FEB | 30
MAR | 30
TOTAL
Spreadsheet: 145687d1331710707-autofill-across-worksheets-sample-workbook
Sheet: Production Plan

 | PRODUCTION PLAN
 |  |  |  | Year 3 |  |  |  | Year 4 |  |  |  | Year 5
 |  |  | Qtr. 1 | Qtr. 2 | Qtr. 3 | Qtr. 4 | Qtr. 1 | Qtr. 2 | Qtr. 3 | Qtr. 4 | Qtr. 1 | Qtr. 2 | Qtr. 3 | Qtr. 4
1 | Market 1 | [NAME] | 63569 | 53999 | 69856 | 65288 | 55606 | 62513 | 74222 | 78365 | 86253 | 83647 | 123667 | 169099
2 |  | Desired End Inventory | 2000 | 1000 | 0 | 100 | 9000 | 0 | 7000 | 19000 | 34000 | 40000 | 39000 | 21000
3 |  | Beginning Inventory | 4672 | 7117 | 2980 | 0 | 392 | 27015 | 0 | 22928 | 57834 | 109256 | 132960 | 129322
 |  | Backorders | 0 | 0 | 6004 | 0 | 0 | 7856 | 0 | 0 | 0 | 0 | 0 | 0
4 |  | Production Required
5 | Market 2 | [NAME] | 63569 | 53999 | 69856 | 65288 | 55606 | 62513 | 74222 | 78365 | 86253 | 83647 | 123667 | 169099
6 |  | Desired End Inventory | 1500 | 0 | 0 | 0 | 7000 | 0 | 7000 | 18000 | 33000 | 34000 | 21000 | 1100
7 |  | Beginning Inventory | 7993 | 4688 | 0 | 0 | 0 | 23111 | 0 | 22542 | 55902 | 100928 | 110632 | 82439
 |  | Backorders | 0 | 8097 | 9910 | 2665 | 0 | 16547 | 0 | 0 | 0 | 0 | 0 | 0
8 |  | Production Required
9 | Market 3 | [NAME] | 63569 | 53999 | 69856 | 65288 | 55606 | 62513 | 74222 | 78365 | 86253 | 83647 | 123667 | 169099
10 |  | Desired End Inventory | 8000 | 0 | 0 | 0 | 9000 | 0 | 9000 | 23000 | 40000 | 53000 | 63000 | 51000
11 |  | Beginning Inventory | 30355 | 25913 | 0 | 0 | 0 | 29558 | 0 | 28970 | 74206 | 134247 | 171970 | 191833
 |  | Backorders | 0 | 2410 | 11618 | 1509 | 0 | 10777 | 0 | 0 | 0 | 0 | 0 | 0
12 |  | Production Required
13 | Total | Production Required
14 |  | Productivity | 0.065 | 0.063 | 0.065 | 0.072 | 0.084 | 0.097 | 0.112 | 0.13 | 0.15 | 0.174 | 0.19 | 0.19
15 |  | Hours Scheduled
16 |  | Production Force Required
17 |  | Production Force Change
18 | Market 1 Allocation (%)
19 | Market 2 Allocation (%)
20 | Market 3 Allocation (%)
Spreadsheet: 789616d1659242359-how-to-sum-multiple-rows-based-on-a-condition-sum-multiple-rows
Sheet: Sheet1

 |  |  |  |  | 2022 | 2023 | 2024 | 2025 | 2026 | 2027
 |  |  |  | E | 402106.6676415102 | 340066.1228313082 | 337734.4619490685 | 335261.1742278402 | 333150.1671436302 | 331128.9753225231
 |  |  |  | Y | 226434.9485849061 | 191301.9276987849 | 197290.6771694411 | 195806.7045367041 | 194540.1002861781 | 193327.3851935139
 |  |  |  | S | 312897.4022291697 | 265320.3236179281 | 279023.2237529548 | 281795.3732199063 | 284299.9642423125 | 286516.3163584081
 |  |  |  |  | What I want to achieve is this
 |  |  |  |  | For Year 2023
 |  |  |  |  | For Year 2024
Spreadsheet: 793701d1661658733-index-match-function-using-named-table-index-match-formula
Sheet: Metrics

Task | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26
Circuit
Circuitization
Data
DMR
Field sketch
ISO
Metallurgy
PM
Systemization
Spreadsheet: 147340d1332754190-dashboard-traffic-lights-using-camera-tool-background-only-prints-white-copy-of-traffic-lights-new
Sheet: TrafficLightsNEW

Cell1 | Actual recovered hrs | 1578
[NAME] | Actual recovered hrs | 1240
Cell3 (Quantum) | Actual recovered hrs | 306
Total | Actual recovered hrs | 3124
Total | Forecast hrs | 3100
 | % of Forecast hrs | 1.007741935483871
Cell 1 OEE % | Target 75% | 69
Cell 2 OEE % | Target 75% | 74
Cell 3  (Quantum) OEE % | Target 75% | 69
 | Target | 75
Labour effectivity. labour hour / machine hr |  | 2.541935483870968
Labour effectivity. [NAME] hr |  | 129.5685279187817
Absenteeism | Target 3% | 0.05
Operational scrap (excludes head waste) |  | 59
 | Target 6% | 0.05778648383937316
Total waste (including head waste) |  | 81
 | Target 8% | 0.07933398628795299
 | Trials scrap in tonnes | 18
 | Kgs of scrap consumed | 32
 | Kgs of opportunity to consume scrap | 42
Throughput TONNES vs Forecast
Cell1 | Actual recovered tonnes | 809
[NAME] | Actual recovered tonnes | 212
Total | Actual recovered tonnes | 1021
Total | Forecast recovered tonnes | 1000
Lost hours to planned change of SKU |  | 0
Number of changes of SKU |  | 221
Average (hours) time taken to changes of SKU. |  | 0
H&S | No of accidents | 3
 | No of incidents | 6
Environment | KGs of general waste | 10720
 | KGs recycled waste (exc raw mat) | 4556
 |  | x
 | Clocked Hours | 7880
 | Sickness Hours | 632
 |  | 100
 |  | 1
 |  | 300
 |  | 0.03
 |  | 0.06
 |  | 0.08