tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 804590d1668175832-calculate-needed-numbers-to-meet-target-goal-samplewb
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  | I manually enter  number here until  both NPS and EXC are green or met goal
 |  |  |  |  |  |  |  |  |  |  |  |  | Total NPS + manually  entered | Total EXC + manually  entered
 | GOAL | NPS
 |  | EXC | 0.9
 | NPS |  |  |  |  | EXCELLENCE |  |  |  | PROMOTERS Needed
Name | Promoter | Neural | Detractor | Total  NPS Survey | NPS% | Excellent | Non Excellent | Total  EXC  Survey | EXC% |  | NPS | EXC | NPS TOTAL | EXC Total
Agent 1 | 5 | 1 | 2 |  |  | 7 | 1 |  |  |  |  |  |  |  |  | NPS=L8=(B8+K8-D8)/N8 ≥ $D$3 | EXC=M8=(G8+K8)/O8 [NAME] $D$4
Agent 2 | 8 | 1 | 0 |  |  | 7 | 2 |  |  |  |  |  |  |  |  | N8=E8+K8 | O8=I8+K8
Agent 3 | 1 | 1 | 0 |  |  | 1 | 1 |  |  |  |  |  |  |  |  | => L8=(B8+K8-D8)/(E8+K8) | => M8=(G8+K8)/(I8+K8)
Agent 4 | 5 | 0 | 0 |  |  | 5 | 0 |  |  |  |  |  |  |  |  | => L8*(E8+K8)=(B8+K8-D8) | => M8*(I8+K8)=(G8+K8)
Agent 5 | 8 | 4 | 3 |  |  | 10 | 5 |  |  |  |  |  |  |  |  | => L8*E8+L8*K8=B8+K8-D8 | => M8*I8+M8*K8=G8+K8
Agent 6 | 7 | 1 | 1 |  |  | 8 | 1 |  |  |  |  |  |  |  |  | => L8*K8=[NAME] | => M8*K8=G8+K8-M8*I8
Agent 7 | 5 | 1 | 0 |  |  | 6 | 0 |  |  |  |  |  |  |  |  | => L8*K8-K8=B8-D8-L8*E8 | =[NAME]=G8-M8*I8
Agent 8 | 7 | 0 | 1 |  |  | 7 | 1 |  |  |  |  |  |  |  |  | => (L8-1)*K8=B8-D8-L8*E8 | => (M8-1)*K8=G8-M8*I8
Agent 9 | 10 | 1 | 0 |  |  | 9 | 2 |  |  |  |  |  |  |  |  | => K8=(B8-D8-L8*E8)/(L8-1) | => K8=(G8-M8*I8)/(M8-1)
Agent 10 | 6 | 2 | 1 |  |  | 8 | 1 |  |  |  |  |  |  |  |  | => K8=(B8-D8-$D$3*E8)/($D$3-1) | => K8=(G8-$D$4*I8)/($D$4-1)
Grand Total |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | K8=ROUNDUP(MAX((B8-D8-$D$3*E8)/($D$3-1),(G8-$D$4*I8)/($D$4-1),0),0)
 |  |  |  |  |  |  |  |  |  | Both   [NAME] and M 13 should be green
 |  |  |  |  |  |  |  |  |  | Agent 10 needs 5 more promoters to hit the goal assuming, the card member who answered the survey gave  NPS and EXC both a good score.
Spreadsheet: 125640d1319135411-converge-on-solution-hook-distance-from-center-jdk
Sheet: Sheet2 (2)

 |  | DRUM | UPPER SHEAVE | UPPER SHEAVE | UPPER SHEAVE | EQUALIZER | EQUALIZER
 | X | 0 | 49 | -49
 | Y | 0
 | Pitch Diameter | 48.5 | 33 | 33
 | Quantity of Item | 1 | 2 | 2
 | Number of Ropes on Item | 2 | 2 | 2
 | Rope Comes off which side of [NAME] to Lower Block Right/Left (R/L) or [NAME] (I)? | R | I | I
 |  | LOWER BLOCK
 | Average Sheave Pitch Diameter | 33
 | Y | 60
 | Parts of Rope | 8
 | LOAD: | 10000
 | LB - X (Starting Assumption) | 24.5
 | x - drum to lb |  | 24.5
 | y - drum to lb |  | 60
 | Angle rope from drum |  | 0.3876695783739985 | 22.21183068644621
 | horz force/rope |  | 510.4166666666667
 | vert force |  | 1250
 |  |  | #N/A
 | x - us to lb on dr sd |  | #N/A
 | y - us to lb |  | #N/A
 | Angle rope from drum |  | #N/A
 | [NAME] |  | #N/A
 | vert force
 |  |  | #N/A
 | x - us to lb opp drum sd |  | #N/A
 | y - us to lb |  | #N/A
 | Angle rope from drum |  | #N/A
 | [NAME] |  | #N/A
 | vert force
 | x - eq to lb
 | y - eq to lb
 | Angle rope from drum
 | [NAME]
 | vert force
Spreadsheet: 205203d1357756200-excel-query-calculating-result-based-on-three-possible-factors-example
Sheet: Sheet1

New Dept ID | Old Dept ID | Old Manager | New Manager | Old Job Code | New Job Code | Old Status | New Status
RT465 | RT465 | [NAME] | FRED ADAMS | 4875 | 4890 | EMP | EMP
GY123 | [NAME] | [NAME] | ANDY BOND | 5362 | 7635 | EMP | EMP
[NAME] | [NAME] | ANDY MANTLE | ANDY MANTLE | 8908 | 8908 | CTR | EMP
PO908 | PO908 | MARY HALL | MARY HALL | 7564 | 1943 | EMP | EMP
FT7546 | FT7564 | SARAH HILL | TANYA SMALL | 6746 | 6746 | EMP | EMP
Spreadsheet: 192084d1352303402-is-there-such-a-thing-as-auto-filter-or-a-workaround-that-will-do-the-following-deal-log
Sheet: TEAM3

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | counts:
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL FRONT
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | total gross
## | SALESMAN | TEAM # | DATE | CUSTOMER | STOCK# | FRONT $$ | RESERVE | WARR | GAP | A/M | TOTAL $ | [N/U] | NEW UNITS | USED UNITS | NEW GROSS | USED GROSS | fe | reserve | WARR | gap | a/m | front | reserve | warr | gap | a/m
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
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
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
Spreadsheet: 217963d1362269555-sum-with-conditions-dados
Sheet: Folha1

E1 | E2 | R1
l | m | 1
l | n | 1
l | o | 1
l | p | 0
l | q | 1
l | r | 1
l | s | 1
l | m | 1
l | p | 1
l | t | 0
l | n | 1
l | o | 0
l | q | 1
l | r | 0
l | p | 0
l | o | 0
l | s | 1
l | r | 1
l | n | 0
l | m | 0
l | q | 1
l | t | 0
l | o | 1
l | n | 0
l | p | 0
l | m | 0
l | t | 1
l | r | 1
l | p | 0
l | r | 0
l | n | 0
l | o | 1
l | m | 1
l | t | 1
l | r | 0
l | u | 1
l | m | 1
l | s | 1
l | o | 1
l | p | 0
l | n | 0
l | u | 1
l | t | 1
l | r | 0
l | s | 0
l | n | 1
l | o | 0
l | p | 0
l | m | 1
l | t | 0
l | q | 1
l | p | 0
l | s | 1
l | r | 0
l | m | 1
l | o | 1
l | u | 1
l | n | 0
l | r | 0
l | s | 0
l | o | 0
l | n | 0
l | u | 1
l | t | 0
l | p | 1
l | q | 1
l | m | 1
l | o | 1
l | t | 1
l | n | 1
l | r | 0
Spreadsheet: 752013d1634522626-drop-down-list-with-hyperlinks-or-with-referral-jump-to-another-cell-test
Sheet: גיליון1

 |  |  | Link2
 |  |  | Link2
 |  |  | Link2
 |  |  | Link2
 |  |  | Link2
 |  |  | Link2
 |  |  | Link2
 |  |  | Link2
 |  |  | Link2 |  |  |  |  |  |  | Link1
 |  |  | Link2 |  |  |  |  |  |  | Link2
 |  |  | Link2 |  |  |  |  |  |  | Link3
 |  |  | Link2
 |  |  | Link2
 |  |  | Link2
 |  |  | Link2
 |  |  | Link2
 |  |  | Link2
 |  |  | Link2
 |  |  | Link2
 |  |  | Link2
 |  |  | Link2
 |  |  | Link2
 |  |  | Link2
 |  |  | Link2
 |  |  | Link2
 |  |  | Link2
 |  |  | Link2
 |  |  | Link2
 |  |  | Link2
 |  |  | Link2
 |  |  | Link2
 |  |  | Link2
 |  |  | Link2
 |  |  | Link2
 |  |  | Link2
 |  |  | Link2
 |  |  | Link1
 |  |  | Link2
 |  |  | Link2
 |  |  | Link2
 |  |  | Link2
 |  |  | Link2
 |  |  | Link2
 |  |  | Link2
 |  |  | Link2
 |  |  | Link2
 |  |  | Link2
 |  |  | Link2
 |  |  | Link2
 |  |  | Link2
 |  |  | Link2
 |  |  | Link2
 |  |  | Link2
 |  |  | Link2
 |  |  | Link2
Spreadsheet: 201982d1356264622-how-can-i-make-a-row-disappear-when-marked-if-the-column-is-selected-football-table-2
Sheet: Teams

 | Result | Player1 | Player2 | Player3 | Player4 | Player5 | Player6 | Player7
Chelsea |  | [NAME] | clive |  |  |  | george | [NAME]
Man U |  |  |  |  |  | [NAME]
Man C |  |  | [NAME] |  | Fred
[NAME] |  | [NAME] |  | [NAME]
Arsenal
Spreadsheet: chris_germany__2646__NIPSCO Choice Est Vol Reqs
Sheet: Monthly Volumes Needed

Estimated CES NIPSCO Choice Monthly and Peak-day Volume requirements.
All [NAME] are at the citygate.
 |  |  | B+C |  |  |  | FxG |  | D-H |  | Dth/Month
 | Flowing Gas Needed |  |  |  | Exh. 1 Volumes | Days | Exh. 1 Dths/Mo. |  | Volumes for Enron Quote |  | Pool A | Pool A | Pool B
 | [NAME] | Comm | Total |  |  |  |  |  |  |  | Residential | Commerical | Commercial
2000-04-01 00:00:00 |  |  |  |  | 462 | 30 |  |  |  | 2000-04-01 00:00:00 | 4077.592232129223 | 9647.772349485673 | 1903.679218385104
2000-05-01 00:00:00 |  |  |  |  | 372 | 31 |  |  |  | 2000-05-01 00:00:00 | 3263.865178766333 | 9384.91136800636 | 1851.812013227309
2000-06-01 00:00:00 |  |  |  |  | 13 | 30 |  |  |  | 2000-06-01 00:00:00 | 4717.679002849269 | 11061.78122385709 | 2182.688632293641
2000-07-01 00:00:00 |  |  |  |  | 10 | 31 |  |  |  | 2000-07-01 00:00:00 | 2117.17748557245 | 7219.283810798273 | 1424.494698299276
2000-08-01 00:00:00 |  |  |  |  | 10 | 31 |  |  |  | 2000-08-01 00:00:00 | 1091.6461824563 | 4882.084021334678 | 963.3230923323215
2000-09-01 00:00:00 |  |  |  |  | 13 | 30 |  |  |  | 2000-09-01 00:00:00 | 1277.106212964645 | 4426.114417945951 | 873.3520786368446
2000-10-01 00:00:00 |  |  |  |  | 0 | 31 |  |  |  | 2000-10-01 00:00:00
2000-11-01 00:00:00 |  |  |  |  | 0 | 30 |  |  |  | 2000-11-01 00:00:00
2000-12-01 00:00:00 |  |  |  |  | 0 | 31 |  |  |  | 2000-12-01 00:00:00
2001-01-01 00:00:00 |  |  |  |  | 0 | 31 |  |  |  | 2001-01-01 00:00:00
2001-02-01 00:00:00 |  |  |  |  | 0 | 28 |  |  |  | 2001-02-01 00:00:00
2001-03-01 00:00:00 |  |  |  |  | 0 | 31 |  |  |  | 2001-03-01 00:00:00
 |  |  |  |  |  |  |  |  | Estimated Peak-day Loads |  |  | Dth/day
 |  |  |  |  |  |  |  |  |  | Total | 425
 |  |  |  |  |  |  |  |  |  | Stg W/D | 228
 |  |  |  |  |  |  |  |  |  | Flowing
Spreadsheet: 743646d1628647438-conditional-formatting-cell-if-value-exists-on-another-table-with-the-same-column-header-conditional-formatting-help-example
Sheet: Input Values

Animal | Vegetable | Mineral | Soda
Dog | Lead | Gold | Dog
Cat | Gold | Silver | Pepsi
Potato | Silver | [NAME] | [NAME]
Coke | Celery | Coke | [NAME]
Spreadsheet: 86681d1286634694-shapes-and-cells-example
Sheet: Data 2

 |  |  | Category 1 | Category 2 | Category 3 | Category 4 | Category 5 | Category 6 | Category 7 | Category 8 | Category 9 | Category 10 | Category 11 | Category 12 | Category 13 | Category 14 | Category 15
Region 1 |  |  | 172 | 120 | 112.2 | 1365 | 11 | 1 | 15 | 4 | 72 | 60 | 6 | -5 | 0 | 1 | 118.5
Region 2 |  |  | 141 | 88 | 102.8 | 1328 | 9 | 4 | 24 | 4 | 64 | 72.7 | 4 | 7 | 0 | 2 | 101.7
Region 3 |  |  | 122 | 84 | 96.3 | 940 | 8 | 5 | 12 | 1 | 52 | 61.9 | 15 | 69 | 2 | 0 | 94.4
Region 4 |  |  | 96 | 59 | 108.8 | 799 | 6 | 0 | 12 | 5 | 32 | 54.2 | 26 | 187 | 1 | 2 | 92.5
Region 5 |  |  | 175 | 118 | 96.3 | 1419 | 6 | 3 | 22 | 5 | 67 | 56.8 | 10 | 29 | 0 | 0 | 90
Region 6 |  |  | 122 | 85 | 109 | 911 | 9 | 2 | 11 | 2 | 45 | 52.9 | 9 | 12 | 0 | 1 | 85.5
Region 7 |  |  | 160 | 118 | 102.4 | 1131 | 7 | 2 | 10 | 1 | 59 | 50 | 5 | -7 | 0 | 2 | 83.8
Region 8 |  |  | 103 | 60 | 105.3 | 711 | 8 | 0 | 9 | 2 | 38 | 63.3 | 8 | 6 | 0 | 1 | 79
Region 9 |  |  | 130 | 86 | 95.6 | 1037 | 7 | 4 | 15 | 1 | 56 | 65.1 | 7 | 0 | 0 | 0 | 75.5
Region 10 |  |  | 149 | 93 | 86.5 | 978 | 6 | 3 | 10 | 0 | 47 | 50.5 | 18 | 51 | 0 | 1 | 72.1
Region 11 |  |  | 102 | 68 | 102.2 | 912 | 6 | 3 | 12 | 2 | 37 | 54.4 | 13 | 62 | 0 | 4 | 68.4
Region 12 |  |  | 96 | 61 | 80.7 | 611 | 6 | 5 | 12 | 0 | 29 | 47.5 | 20 | 85 | 1 | 1 | 65
Region 13 |  |  | 158 | 94 | 82.7 | 1078 | 5 | 3 | 12 | 3 | 57 | 60.6 | 13 | 16 | 0 | 4 | 64.7
Region 14 |  |  | 161 | 97 | 70.2 | 991 | 5 | 7 | 10 | 1 | 47 | 48.5 | 12 | 69 | 0 | 3 | 62.8
Region 15 |  |  | 158 | 92 | 72.3 | 944 | 6 | 6 | 11 | 1 | 50 | 54.3 | 3 | 10 | 0 | 0 | 62.6
Region 16 |  |  | 131 | 84 | 86.2 | 964 | 5 | 4 | 8 | 2 | 48 | 57.1 | 5 | 0 | 0 | 0 | 60.5
Region 17 |  |  | 121 | 70 | 84.7 | 958 | 3 | 2 | 13 | 4 | 40 | 57.1 | 8 | 81 | 0 | 0 | 60.3
Region 18 |  |  | 126 | 77 | 70.7 | 814 | 4 | 6 | 8 | 2 | 37 | 48.1 | 9 | 33 | 2 | 1 | 57.8
Region 19 |  |  | 128 | 88 | 93.9 | 940 | 4 | 2 | 13 | 1 | 45 | 51.1 | 2 | -2 | 0 | 0 | 57.4
Region 20 |  |  | 145 | 83 | 70.5 | 920 | 5 | 6 | 10 | 1 | 49 | 59 | 13 | 8 | 0 | 2 | 53.8
Region 21 |  |  | 132 | 85 | 81.2 | 1005 | 5 | 6 | 16 | 2 | 39 | 45.9 | 9 | 4 | 0 | 5 | 50.9
Region 22 |  |  | 83 | 49 | 84.6 | 544 | 4 | 2 | 8 | 2 | 25 | 51 | 12 | 92 | 0 | 0 | 50.8
Region 23 |  |  | 151 | 93 | 66.1 | 920 | 3 | 7 | 7 | 2 | 41 | 44.1 | 5 | 29 | 0 | 2 | 45.6
Region 24 |  |  | 95 | 52 | 74.7 | 695 | 4 | 4 | 11 | 2 | 35 | 67.3 | 11 | 29 | 0 | 3 | 44.6
Region 25 |  |  | 55 | 32 | 88.1 | 375 | 4 | 2 | 5 | 0 | 18 | 56.2 | 10 | 92 | 0 | 0 | 44.1
Region 26 |  |  | 71 | 47 | 94.3 | 511 | 4 | 2 | 4 | 1 | 25 | 53.2 | 13 | 66 | 0 | 3 | 42.9
Region 27 |  |  | 77 | 42 | 75.4 | 494 | 4 | 3 | 6 | 1 | 25 | 59.5 | 8 | 16 | 0 | 0 | 39.3
Region 28 |  |  | 85 | 52 | 82.2 | 554 | 3 | 2 | 7 | 2 | 27 | 51.9 | 7 | 9 | 0 | 1 | 37.8
Spreadsheet: 58593d1258830599-date-formula-in-colour-on-2nd-worksheet-goss-training-matrix-test
Sheet: Installations

Todays date: | 2009-11-20 00:00:00 | Installations  - Training Matrix
 |  | FLT - Couterbalance | FLT - Reach | FLT - Narrow Aisle | PASMA Scaffolding Training | ISOH Managing Safely | [NAME] Training | Health and Safety Reps Course | Control of Contractors | DSE Assessor Training | NEBOSH General Certificate | 1st Aid Course | Safety in Machine Design | Management of Health and Safety | City and Guilds Machinery Safety | Overhead Pendant Crane Lifting/Slinging | [NAME] | CDM Awareness Course | Manual Handling Awareness Course | Risk Assessment Awareness Course | Accident Investigation Awareness Course | Introduction to Health and Safety at Work | NVQ2 in Plant Operations
 |  | 3 Yrly | 3 Yrly | 3 Yrly | 5 Yrly | 3 Yrly | Yrly | Yrly | Yrly | Yrly | . | 3 Yrly | . | Yrly | . | 3 Yrly | Yrly | . | Yrly | Yrly | Yrly | Yrly | .
Installations | 1 |  |  |  |  | 2003-07-03 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  | 2009-07-07 00:00:00 | 2009-07-07 00:00:00 | 2009-07-07 00:00:00 | 2009-07-07 00:00:00
 | 2 |  |  |  |  | 2006-11-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  | 2009-09-08 00:00:00 | 2009-09-08 00:00:00 | 2009-09-08 00:00:00 | 2009-09-08 00:00:00
 | 3 |  |  |  |  | 2006-02-02 00:00:00
 | 4 |  |  |  |  | 2003-06-06 00:00:00
 | 5 |  |  |  |  | 2006-07-04 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  | 2009-06-24 00:00:00 | 2009-06-24 00:00:00 | 2009-06-24 00:00:00 | 2009-06-24 00:00:00
Spreadsheet: 815064d1674725496-bring-which-was-the-best-day-of-the-week-based-on-the-highest-number-post_indicators
Sheet: Indicators

Mês | Best day to post | Best time to post
April
May
June
July
August
September
October
November
December
Spreadsheet: 677374d1589320160-formulas-not-automatically-updating-when-copying-across-sample
Sheet: Data Provided to me

 |  |  | Fake Data
 |  |  | Data | Group 1
 |  |  | Data
 |  |  | Data
 |  |  | Data
 |  |  | Data
 |  |  | Data | Group2
 |  |  | Data
 |  |  | Data
 |  |  | Data | Group 3
 |  |  | Data
 |  |  | Data
 |  |  | Data
 |  |  | Data | Group 4
 |  |  | Data
 |  |  | Data
 |  |  | Data | Group 5
 |  |  | Data
Spreadsheet: 109990d1306793493-how-to-keep-the-last-crieteria-from-changes-in-a-formula-general-liability-montly-audit-forum
Sheet: Form

Week | No. of Employee over 300 | AL Total | TX Total | LA Total
2010-04-01 00:00:00
2010-04-09 00:00:00
2010-04-16 00:00:00
2010-04-23 00:00:00
2010-04-30 00:00:00
2010-05-07 00:00:00
2010-05-14 00:00:00
2010-05-21 00:00:00
2010-05-28 00:00:00
2010-06-04 00:00:00
2010-06-11 00:00:00
2010-06-18 00:00:00
2010-06-25 00:00:00
2010-07-02 00:00:00
2010-07-09 00:00:00
2010-07-16 00:00:00
2010-07-23 00:00:00
2010-07-30 00:00:00
2010-08-06 00:00:00
2010-08-13 00:00:00
2010-08-19 00:00:00
2010-08-27 00:00:00
2010-09-03 00:00:00
2010-09-10 00:00:00
2010-09-17 00:00:00
2010-09-24 00:00:00
2010-10-01 00:00:00
2010-10-08 00:00:00
2010-10-15 00:00:00
2010-10-22 00:00:00
2010-10-29 00:00:00
2010-11-05 00:00:00
2010-11-12 00:00:00
2010-11-19 00:00:00
2010-11-24 00:00:00
2010-12-03 00:00:00
2010-12-10 00:00:00
2010-12-17 00:00:00
2010-12-22 00:00:00
2010-12-23 00:00:00
2010-12-30 00:00:00
2011-01-07 00:00:00
2011-01-14 00:00:00
2011-01-21 00:00:00
2011-01-28 00:00:00
2011-02-04 00:00:00
2011-02-11 00:00:00
2011-02-18 00:00:00
2011-02-25 00:00:00
2011-03-04 00:00:00
2011-03-11 00:00:00
2011-03-18 00:00:00
2011-03-25 00:00:00
Spreadsheet: 834122d1687460102-creating-rag-status-based-on-criteria-and-day-range-rag-status-example
Sheet: Sheet1

 | Status Criteria
 | Status | Low Day Value | High Day Value
 | A | 5 | 10
 | B | 5 | 10
 | C | 5 | 10
 | D | 5 | 10
 | E | 5 | 10
 | F | 5 | 10
 | G | 5 | 10
 | H | 30 | 45
 | I | 5 | 10
 |  |  |  |  | Example
 |  |  |  |  | Status | Date in Status | Days in Status | [NAME]
 |  |  |  |  | A | 2023-06-15 00:00:00 |  | Amber
 |  |  |  |  | A | 2023-06-08 00:00:00
 |  |  |  |  | B | 2023-06-21 00:00:00
 |  |  |  |  | E | 2023-06-05 00:00:00
 |  |  |  |  | D | 2023-06-15 00:00:00
 |  |  |  |  | H | 2023-05-25 00:00:00
 |  |  |  |  | F | 2023-06-18 00:00:00
Spreadsheet: 740762d1626551563-move-formula-down-a-row-depending-on-date-possible-example
Sheet: Test sheet

Operations EOMP No.71 - Vapour Recovery Unit Weekly Test
Before weekly test commences, check inboard and outboard oil levels on B1/B2 and
[NAME] bottle level and record any top-ups made. (pumps stood)
B1/2 should be ¾ up the bull’s eyes when the pumps are off
1. Go to VRU PLC
2. Read TAH 102 and TAH 202 |  |  |  |  |  |  | TAH 102 | TAH 202
3. [NAME] to 'Manual' and wait until the "Cycle time"countdown starts from 900 seconds
which indicates the start of a new regeneration.
4. Note time in hours and minutes. |  |  |  |  |  |  | Hrs. | Mins.
5. Go to VRU between adsorbers.
6. Read TI 102, TI 101, TI 202 and TI 201 |  |  |  |  | TI 102 | TI 101 | TI 202 | TI 201
7. Go to north side of skid.
8. Read LI 301, LI 401, LI 801 & LG 8026 |  |  |  |  | LG 8026 | LI 301 | LI 401 | LI 801
(LG 8026 is the glycol Klinger)
9. Read PI 301, PI 302, PI 601 and PI 701 |  |  |  |  | PI 302 | PI 301 | PI 601 | PI 701
10. Read TI 301, TI 501 and TI 701 |  |  |  |  |  | TI 301 | TI 501 | TI 701
11. Go to south side of skid.
12. Check that no dust or vapour shows in vent gas from stack |  |  |  |  |  |  | Yes | No
13. Read TI 401 and TI 502 |  |  |  |  |  |  | TI 401 | TI 502
14. Read PI 303 |  |  |  |  |  |  |  | PI 303
15. Return to [NAME] pumps |  |  |  |  | FISL 401 | FISL 403 | FISL 402 | FISL 404
Read relevant flow indicators
16. Check flow indicator on analyser and for unusual noise/vibration. |  |  |  |  |  |  |  | OK - Y/N
17. Return to VRU PLC
18. [NAME] from 'manual' to 'auto'
19. Wait until the "Cycle time" in section 4 reaches 180 seconds.
20. Read PT 101* or PT 201* and PT 503 |  |  |  |  |  | PT 101 | PT 201 | PT 503
*Only read pressure of regenerating bed
21. Read TAH 503 and TAH 504 |  |  |  |  |  |  | TAH 503 | TAH 504
22. Record which vacuum pumps were running. |  |  |  |  |  |  | B1 / C1 | B2 / C2
Spreadsheet: 41296d1239792899-vlookup-from-multiple-sheets-shift-schedule
Sheet: DETAILS

DETAILS
[NAME]. | SAP NO. | NAME | SECTION
 | 135 |  |  | A
 | 205 |  |  | c
 | 209 |  |  | A
 | 140 |  |  | c
Spreadsheet: 02465666-1275-4ab9-a4cf-6167dee3ddb0
Sheet: Facility codes

n/a | SFY 2014 STATE CODE SHEET
SFY 2014 STATE EDRS-UFARS codes crosswalk | n/a
n/a | n/a
EDRS Facility Identification Codes | n/a
Use with Service Code C- Contracted Pupil Placements | n/a
Facility Codes | [NAME]
A | Day Center for Disabled
B | *Private Minnesota School for Disabled
C | Health/Rehabilitation Center
D | * Other Private Minnesota Agency
E | All Out-of-State Agencies
F | Preschool/Nursery School
G | Care and Treatment
O | Out of State Tuition (ENTERED BY MDE)
* Private - school personnel not employed by a Minnesota school district | n/a
end of worksheet
Spreadsheet: 811701d1672755566-sumproduct-with-date-criteria-and-blanks-in-array-example-sheet1
Sheet: Sheet1

Month Number | Month | Year | formula | formula V2
7 | 2022-07-01 00:00:00 | 2022
8 | 2022-08-01 00:00:00 | 2022 |  |  |  | 16.71186440677966
9 | 2022-09-01 00:00:00 | 2022 |  |  |  | 14.38888888888889
10 | 2022-10-01 00:00:00 | 2022 |  |  |  | 11.5
11 | 2022-11-01 00:00:00 | 2022 |  |  |  | 6.695652173913044
12 | 2022-12-01 00:00:00 | 2022
1 | 2023-01-01 00:00:00 | 2023
Spreadsheet: lynn_blair__24422__duke_rev
Sheet: 27291

[NAME]
SCHEDULE OF RATE ADJUSTMENTS - DUKE CR #27291
FOR THE PERIOD OF AUGUST 2000 TO SEPTEMBER 2001
PROD |  |  |  |  |  |  |  | TOTAL |  | AVERAGE |  | BILLED |  | ADD'TNL
MONTH |  | VOLUME |  | RATE |  | AMOUNT |  | MDQ |  | RATE |  | RATE |  | REVENUE
2000-08-01 00:00:00 | A | 15976 |  | 0.08
 | P |  |  | 0.02
 |  | 620000 |  |  |  |  |  |  |  |  |  | 0.0215
2000-09-01 00:00:00 | A | 0 |  | 0.08
 | P |  |  | 0.02
 |  | 600000 |  |  |  |  |  |  |  |  |  | 0.02
2000-10-01 00:00:00 | A | 1000 |  | 0.08
 | P |  |  | 0.02
 |  | 620000 |  |  |  |  |  |  |  |  |  | 0.02
2000-11-01 00:00:00 | A | 0 |  | 0.08
 | P |  |  | 0.02
 |  | 600000 |  |  |  |  |  |  |  |  |  | 0.02
2000-12-01 00:00:00 | A | 24688 |  | 0.08
 | P |  |  | 0.02
 |  | 620000 |  |  |  |  |  |  |  |  |  | 0.0224
2001-01-01 00:00:00 | A | 3276 |  | 0.08
 | P |  |  | 0.02
 |  | 620000 |  |  |  |  |  |  |  |  |  | 0.0203
2001-02-01 00:00:00 | A | 0 |  | 0.08
 | P |  |  | 0.02
 |  | 560000 |  |  |  |  |  |  |  |  |  | 0.02
2001-03-01 00:00:00 | A | 34354 |  | 0.08
 | P |  |  | 0.02
 |  | 620000 |  |  |  |  |  |  |  |  |  | 0.0233
2001-04-01 00:00:00 | A | 0 |  | 0.08
 | P |  |  | 0.02
 |  | 600000 |  |  |  |  |  |  |  |  |  | 0.02
2001-05-01 00:00:00 | A | 120 |  | 0.08
 | P |  |  | 0.02
 |  | 620000 |  |  |  |  |  |  |  |  |  | 0.02
2001-06-01 00:00:00 | A | 52761 |  | 0.08
 | P |  |  | 0.02
 |  | 600000 |  |  |  |  |  |  |  |  |  | 0.02
2001-07-01 00:00:00 | A | 37992 |  | 0.08
 | P |  |  | 0.02
 |  | 620000 |  |  |  |  |  |  |  |  |  | 0.02
2001-08-01 00:00:00 | A | 32409 |  | 0.085 | *
 | P |  |  | 0.025
 |  | 620000 |  |  |  |  |  |  |  |  |  | 0.025
2001-09-01 00:00:00 | A | 0 |  | 0.085 | *
 | P |  |  | 0.025
 |  | 600000 |  |  |  |  |  |  |  |  |  | 0.025
 |  | Unbilled revenue
 | A | =Alternate deliveries to California border.
 | P | =Primary capacity to East of Thoreau.
 | * | Incremental six cents over two and one-half cents rate?