tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 116247d1311697612-problem-with-matching-recognizing-specific-data-rows-columns-among-sheets-date-list
Sheet: WEEK

 |  |  | PAYMENTS
TAXI ID | TAXI DETAILS | MONDAY | TUESDAY | WEDNESDAY | THURSDAY | FRIDAY | SATURDAY | SUNDAY | SUM
1 |  | 50 + 40 + 24=?
2 |  | 65 + 40 + 35=?
3 |  | 24 + 35 + 50=?
4 |  | 65 + 40=?
5 |  |  | 40 + 28 + 40=?
6 |  |  | 55 + 30=?
7 |  |  | 40 + 28=?
8 |  |  | 34 + 30=?
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
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
Spreadsheet: 675414d1588273472-if-formula-to-gather-data-from-different-sheets-in-a-worksheet-lizsantiago07_demo
Sheet: 0 students

Isantiago | Dfster | APersaud
Spreadsheet: 391fb8b8-5b67-4034-ac23-20d8977092a1
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12
One (1) Owner per form
Owner/Lessee |  |  |  |  |  | SAN DIEGO |  | Trainer
 |  |  |  |  |  | COUNTRY ESTATES
Printed name of legal owner/Lessee |  |  |  |  |  |  |  | Printed name of Trainer
Signature of Owner/Lessee or Agent |  |  |  |  |  | COMBINED TRAINING |  | Trainer's Signature (if no trainer-Owner must sign)
 |  |  |  |  |  | AND DRESSAGE
Street, P.O. Box of Owner |  |  |  |  |  | SCHOOLING SHOW |  | Street or [NAME] of Trainer
 |  |  |  |  |  | Sunday
City of Owner |  | State | Zip |  |  | November 10th, 2013 |  | City of Trainer |  | State | Zip
 |  |  |  |  |  | SHOW TIME - 9:00 AM                                                                                                                                                                              GATES OPEN AT 8:00 AM
Phone Number of Owner |  |  |  |  |  |  |  | Phone Number of Trainer
[NAME] |  |  |  |  |  | International Equestrian Center
 |  |  |  |  |  | Ramona, California |  |  | JR./Adult/O | O
[NAME] |  | Name of Horse |  |  | Class #'s | Class description | Test # |  |  | RIDER/HANDLER |  | JR/A/O
 | OFFICE USE ONLY |  |  |  |  | Late entries will not be counted into the show |  |  | Dressage (per) Class |  | 20
 |  |  |  |  |  | All Entries are due in the office by Nov. 6th |  |  | Class #1 & #1a. |  | 10
Deposit Received $ |  |  |  |  | Ride times will be emailed by Nov. 8th |  |  |  | Combined Training |  | 35
 |  |  |  |  |  | Make all checks payable to: |  |  | Drug fee per horse |  | 5
Open Check # |  |  |  |  |  | SDCEA |  |  | (if you are staying overnight)
 |  |  |  |  |  | Mail Entries to : |  |  | Stall Fee $15 per horse
Open Check to cover #'s |  |  |  |  |  | SDCEA |  |  | SDCEA Owner [NAME] fee @ $8 per horse |  | 9.00 per horse
 |  |  |  |  |  | 16911 Gunn Stage Road |  |  | Jumping round                            $15.00
Balance Due |  |  |  |  |  | Ramona CA 92065 |  |  | Total Fees>>>>>>>>>>>>>>$
 |  |  |  |  |  | [PHONE]
 |  |  |  |  | JUDGE: | [NAME]
Spreadsheet: 708751d1608008915-need-help-in-getting-sum-total-of-all-highlighted-rows-book-1
Sheet: Book 1

Date 1 | Date 2 | Provider |  |  |  | Total
2020-01-12 00:00:00 | 2020-01-12 00:00:00 | PRELEVEMENT AUTOMATIQUE |  |  |  | 1 282.91 |  | Date | 2018-08-02 00:00:00
2020-01-14 00:00:00 | 2020-01-14 00:00:00 | CHATFUEL |  | 30.00 Dollar américain |  | 25.59 |  | Total Normal | 750.58
2020-01-20 00:00:00 | 2020-01-20 00:00:00 | CHANGE.ORG |  |  |  | 10 |  | Total Effective
2020-01-21 00:00:00 | 2020-01-21 00:00:00 | AIRBNB |  | 271.27 Dollar américain |  | 228.25 |  | Total to Refund | ? | How do I calculate the sum of the highlighted rows (conditional formatting) in column G using SUMIFs? Or is that the right formula to use?
2020-01-25 00:00:00 | 2020-01-25 00:00:00 | CHATFUEL |  | 30.00 Dollar américain |  | 25.05
2020-01-28 00:00:00 | 2020-01-28 00:00:00 | AUDIBLE GMBH |  |  |  | 9.95
2020-02-01 00:00:00 | 2020-02-01 00:00:00 | HIVEAGE.COM |  | 19.00 Dollar américain |  | 15.71
2020-02-01 00:00:00 | 2020-02-04 00:00:00 | CARDWISECOM |  |  |  | 5
2020-02-05 00:00:00 | 2020-02-06 00:00:00 | ITUNES.COM/BILL |  |  |  | 2.99
2020-01-11 00:00:00 | 2020-01-12 00:00:00 | SPEEDY JARRY | BAIE MAHAULT | 239,04 |  | 239.04
2020-01-11 00:00:00 | 2020-01-12 00:00:00 | CARREFOUR PLIANE | LE GOSIER | 62,26 |  | 62.26
2020-01-12 00:00:00 | 2020-01-13 00:00:00 | CRYOCENTRE CARAIBES | LE MOULE | 65,00 |  | 65
2020-01-17 00:00:00 | 2020-01-17 00:00:00 | HOTEL TOUBANA | STE ANNE | 36,50 |  | 36.5
2020-01-20 00:00:00 | 2020-01-20 00:00:00 | CHATFUEL |  | 25,24 |  | 25.24
Spreadsheet: geir_solberg__11264__8-12
Sheet: Sheet1

DATE | HR BEGIN | HR END | TOTAL HOURS | DELIVERY POINT | SUPPLY | MW PER HOUR | TOTAL MW | BOUGHT/ SOLD | EES PRICE
2001-08-11 00:00:00 | 2 | 2 | 1 | SP15 | EES | 6 | 6 | SOLD | 20
2001-08-11 00:00:00 | 3 | 3 | 1 | SP15 | EES | 20 | 20 | SOLD | 20
2001-08-11 00:00:00 | 4 | 4 | 1 | SP15 | EES | 28 | 28 | SOLD | 20
2001-08-11 00:00:00 | 5 | 5 | 1 | SP15 | EES | 22 | 22 | SOLD | 20
2001-08-11 00:00:00 | 6 | 6 | 1 | SP15 | EES | 1 | 1 | SOLD | 20
2001-08-11 00:00:00 | 7 | 8 | 2 | SP15 | EES | 100 | 200 | SOLD | 22
2001-08-11 00:00:00 | 7 | 10 | 4 | SP15 | EES | 49 | 196 | SOLD | 20
2001-08-11 00:00:00 | 7 | 7 | 1 | SP15 | EES | 22 | 22 | SOLD | 20
2001-08-11 00:00:00 | 8 | 8 | 1 | SP15 | EES | 9 | 9 | SOLD | 20
2001-08-11 00:00:00 | 9 | 9 | 1 | SP15 | EES | 77 | 77 | SOLD | 20
2001-08-11 00:00:00 | 10 | 10 | 1 | SP15 | EES | 47 | 47 | SOLD | 20
2001-08-11 00:00:00 | 11 | 11 | 1 | SP15 | EES | 50 | 50 | SOLD | 24
2001-08-11 00:00:00 | 12 | 12 | 1 | SP15 | EES | 32 | 32 | SOLD | 24
2001-08-11 00:00:00 | 13 | 13 | 1 | SP15 | EES | 17 | 17 | SOLD | 24
2001-08-11 00:00:00 | 14 | 14 | 1 | SP15 | EES | 14 | 14 | SOLD | 24
2001-08-11 00:00:00 | 15 | 15 | 1 | SP15 | EES | 6 | 6 | SOLD | 27
2001-08-11 00:00:00 | 16 | 16 | 1 | SP15 | EES | 14 | 14 | SOLD | 27
2001-08-11 00:00:00 | 17 | 17 | 1 | SP15 | EES | 19 | 19 | SOLD | 32
2001-08-11 00:00:00 | 18 | 18 | 1 | SP15 | EES | 46 | 46 | SOLD | 29
2001-08-11 00:00:00 | 19 | 19 | 1 | SP15 | EES | 42 | 42 | SOLD | 29
2001-08-11 00:00:00 | 20 | 20 | 1 | SP15 | EES | 44 | 44 | SOLD | 29
2001-08-11 00:00:00 | 21 | 21 | 1 | SP15 | EES | 46 | 46 | SOLD | 29
2001-08-11 00:00:00 | 21 | 21 | 1 | SP15 | EES | 9 | 9 | SOLD | 30
2001-08-11 00:00:00 | 22 | 22 | 1 | SP15 | EES | 46 | 46 | SOLD | 29
2001-08-11 00:00:00 | 22 | 22 | 1 | SP15 | EES | 29 | 29 | SOLD | 30
2001-08-11 00:00:00 | 2 | 6 | 5 | SP15 | EES | 2 | 10 | SOLD | 25
2001-08-11 00:00:00 | 7 | 10 | 4 | SP15 | EES | 15 | 60 | SOLD | 27
2001-08-11 00:00:00 | 11 | 14 | 4 | SP15 | EES | 25 | 100 | SOLD | 24
2001-08-11 00:00:00 | 15 | 16 | 2 | SP15 | EES | 25 | 50 | SOLD | 27
2001-08-11 00:00:00 | 17 | 17 | 1 | SP15 | EES | 25 | 25 | SOLD | 29
2001-08-11 00:00:00 | 18 | 22 | 5 | SP15 | EES | 25 | 125 | SOLD | 30
2001-08-11 00:00:00 | 11 | 14 | 4 | SP15 | EES | 25 | 100 | SOLD | 24
2001-08-11 00:00:00 | 15 | 16 | 2 | SP15 | EES | 25 | 50 | SOLD | 27
2001-08-11 00:00:00 | 17 | 17 | 1 | SP15 | EES | 25 | 25 | SOLD | 29
2001-08-11 00:00:00 | 18 | 18 | 1 | SP15 | EES | 9 | 9 | SOLD | 30
2001-08-11 00:00:00 | 19 | 22 | 4 | SP15 | EES | 25 | 100 | SOLD | 30
2001-08-11 00:00:00 | 23 | 24 | 2 | SP15 | EES | 5 | 10 | BOUGHT | 35
2001-08-11 00:00:00 | 23 | 23 | 1 | SP15 | EES | 33 | 33 | BOUGHT | 35
2001-08-11 00:00:00 | 24 | 24 | 1 | SP15 | EES | 15 | 15 | BOUGHT | 35
2001-08-11 00:00:00 | 1 | 1 | 1 | SP15 | EES | 5 | 5 | BOUGHT | 30
2001-08-11 00:00:00 | 1 | 1 | 1 | SP15 | EES | 6 | 6 | BOUGHT | 37
Spreadsheet: 180046d1347465224-saperate-values-from-column-exlove-forum-seperate-data
Sheet: Sheet1

 |  |  |  |  |  |  |  | OUTPUT |  | HELPER |  |  |  | OUTPUT
Input |  | Output |  |  |  |  |  | first output | second output | [NAME] | first mark | second mark (optional) | third mark (optional) | first number | second number (optional) | third number (optional)
Ch no: 144534 paid for site SEL - Gurgaon vide p.o.no: DIDL105086 (Billl no: 26341/26342/26343) |  | 144534 | DIDL105086 | 26341 | 26342 | 26343
chq no: 138995 paid for site Soutehrn Park office vide p.o.no: DIDL107553 ([NAME] no: 3554) |  | 138995 | DIDL107553 | 3554
ch no: 088846 paid for site Four season vide p.o.no: DIDL107907 ([NAME]) |  | 88846 | DIDL107907 | 3557 | 3558
chq no:152615 paid for site Emerson Innovation 4th floor vide p.o.no:DTOS107658 (Bill no:3559) |  | 152615 | DTOS107658 | 3559
Spreadsheet: 490876d1480112035-transport-elements-according-the-surname-my-book
Sheet: Φύλλο1

 | FIRSTNAME | LASTNAME | AGE | GENGER | PHONE |  | Here i enter some names, they change rarely.
 | NICK | B. | 30 | M | 22222 |  | Very often i go to sheet 2 and there i make changes many times in a month, i must change the names in the positions.
 | GEORGE | F. | 25 | M | 55555
 | [NAME] | T. | 38 | M | 11111
 | MAIRY | P. | 36 | F | 99999
Spreadsheet: darrell_schoolcraft__7399__NNG LAMAR NOMNATION
Sheet: 01-(28)

 |  |  |  | Time/Date
 |  |  |  | Beginning Gas Day: | 2002-01-28 00:00:00 | Monday
 |  |  |  | Ending Gas Day: | 2002-01-28 00:00:00
 |  | [NAME] |  |  | 45000
 |  | Hour
 |  | Ending | [NAME] | Accumulated | Remaining | Daily Burn
 |  | CST |  |  |  | Rate
 |  | 10 | 3500
 |  |  | 3500
 |  |  | 3500
 |  |  | 3500
 |  |  | 3500
 |  |  | 3500
 |  |  | 3500
 |  |  | 3500
 |  |  | 3500
 |  |  | 3500
 |  |  | 3500
 |  |  | 3500
 |  |  | 3000
 |  |  | 0
 |  |  | 0
 |  | 1 | 0
 |  | 2 | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
Spreadsheet: 673569d1587449905-counting-runs-of-two-consecutive-days-2020-04-21-oeldere-673532d1587427575-counting-runs-of-two-consecutive-days-sample
Sheet: sample

Year | Month | Day | SnowD | Quality | B | Runs (d) |  | F column
1904 | 12 | 26 | 0.01 | G | 1
1904 | 12 | 27 | 0.01 | G | 1 | 1
1904 | 12 | 28 | 0.01 | G | 1 | 0
1904 | 12 | 29 | 0.12 | G | 1 | 1
1904 | 12 | 30 | 0.12 | G | 1 | 0
1904 | 12 | 31 | 0.15 | G | 1 | 1
1906 | 12 | 17 | 0.07 | G | 1 | 0
1906 | 12 | 18 | 0.05 | G | 1 | 1
1906 | 12 | 19 | 0.05 | G | 1 | 0
1906 | 12 | 20 | 0.04 | G | 1 | 1
1906 | 12 | 25 | 0.07 | G | 1 | 0
1906 | 12 | 26 | 0.08 | G | 1 | 1
1906 | 12 | 27 | 0.08 | G | 1 | 0
1906 | 12 | 28 | 0.08 | G | 1 | 1
1906 | 12 | 29 | 0.06 | G | 1 | 0
1906 | 12 | 30 | 0.06 | G | 1 | 1
1906 | 12 | 31 | 0.07 | G | 1 | 0
1907 | 12 | 17 | 0.03 | G | 1 | 1
1907 | 12 | 18 | 0.10 | G | 1 | 0
1907 | 12 | 19 | 0.17 | G | 1 | 1
1907 | 12 | 20 | 0.17 | G | 1 | 0
The runs are depending on whether there's a significant snow depth or not. A significant snow depth is at least 0.01. If SnowD >= 0.01, then B = 1; 0 otherwise.
=OM(OCH(F2=1;F3=1;G2<>1);1;0)
So this is how far I've come:
But I also want it to start over when reaching a new year (I'm only interested in the period 17 Dec - 31 Dec for each given year), and the same with gaps, or missing data really.
But this will only result in Excel counting them as pairs.
P.S. Sorry, note that the code is in Swedish so OM = IF and OCH = AND. Also, hope you don't mind the picture, I thought it was easier that way.
Spreadsheet: 485159d1476736862-sumproduct-with-other-sheets-and-criteria-sumproduct-with-criteria-bvj-v4
Sheet: Sheet4

 |  |  | Status
 |  |  | 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
 |  |  | 2016-10-01 00:00:00
 |  |  | 2016-11-01 00:00:00
 |  |  | 2016-12-01 00:00:00
 |  |  | 2017-01-01 00:00:00
 |  |  | 2017-02-01 00:00:00
 |  |  | 2017-03-01 00:00:00
 |  |  | 2017-04-01 00:00:00
 |  |  | 2017-05-01 00:00:00
 |  |  | 2017-06-01 00:00:00
 |  |  | 2017-07-01 00:00:00
 |  |  | 2017-08-01 00:00:00
 |  |  | 2017-09-01 00:00:00
 |  |  | 2017-10-01 00:00:00
 |  |  | 2017-11-01 00:00:00
 |  |  | 2017-12-01 00:00:00
 |  |  | 2018-01-01 00:00:00
 |  |  | 2018-02-01 00:00:00
 |  |  | 2018-03-01 00:00:00
 |  |  | 2018-04-01 00:00:00
 |  |  | 2018-05-01 00:00:00
 |  |  | 2018-06-01 00:00:00
 |  |  | 2018-07-01 00:00:00
 |  |  | 2018-08-01 00:00:00
 |  |  | 2018-09-01 00:00:00
 |  |  | 2018-10-01 00:00:00
 |  |  | 2018-11-01 00:00:00
 |  |  | 2018-12-01 00:00:00
Spreadsheet: 269787d1381280117-rating-total-ratings
Sheet: Sheet2

 | Player Name | Team | Rating Total
1 | Player1 | Team1
2 | Player2 | Team1
3 | Player3 | Team1
4 | Player4 | Team1
5 | Player5 | Team1
6 | Player6 | Team1
7 | Player7 | Team1
8 | Player8 | Team1
9 | Player9 | Team1
10 | Player10 | Team1
11 | Player11 | Team1
12 | Player12 | Team2
13 | Player13 | Team2
14 | Player14 | Team2
15 | Player15 | Team2
16 | Player16 | Team2
17 | Player17 | Team2
18 | Player18 | Team2
19 | Player19 | Team2
20 | Player20 | Team2
21 | Player21 | Team2
22 | Player22 | Team2
23 | Player23 | Team3
24 | Player24 | Team3
25 | Player25 | Team3
26 | Player26 | Team3
27 | Player27 | Team3
28 | Player28 | Team3
29 | Player29 | Team3
Spreadsheet: 121460d1316077965-graph-labels-how-do-i-label-something-other-than-the-percentages-i-want-to-show-graphs-of-high-intensity
Sheet: Sheet1

 |  | Graph 1 - shows the percentages of the amount of times the team applied high pressure following the loss of possession
 |  |  | 0 |  |  | 0 |  |  | 0 |  |  |  | 100
 |  |  | 50 |  |  | 67 |  |  | 56 |  |  |  | 56
 |  |  | 68 |  |  | 30 |  |  | 57 |  |  |  | 50
 |  |  | 50 |  |  | 39 |  |  | 73 |  |  |  | 70
 | [NAME] | same as graph one, but with the number of times high pressure was applied after possession was lost in that area
 |  |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  |  | 1 | 1
 |  |  | 0.5 | 2 |  | 0.67 | 4 |  | 0.56 | 5 |  |  | 0.56 | 5
 |  |  | 0.68 | 17 |  | 0.3 | 11 |  | 0.57 | 17 |  |  | 0.5 | 8
 |  |  | 0.5 | 6 |  | 0.39 | 7 |  | 0.73 | 11 |  |  | 0.7 | 7
Spreadsheet: 35483d1233087113-input-automatic-calculation-book1
Sheet: Sheet1

Equation |  | X | Y |  |  | A | B | C | D | E
B |  | 1 | 1 |  |  | 1 | 1 | 1 | 1 | 1
 |  | 2 | 4 |  |  | 2 | 4 | 8 | 16 | 32
 |  | 3 | 9 |  |  | 3 | 9 | 27 | 81 | 243
 |  | 4 | 16 |  |  | 4 | 16 | 64 | 256 | 1024
 |  | 5 | 25 |  |  | 5 | 25 | 125 | 625 | 3125
Spreadsheet: 77341d1277837358-using-today-in-calculations-service-dispatch-w-tabs
Sheet: LABOR

 | ASSIGNED | COMPLETED | TOTAL INCOMPLETE
LAST UPDATED: |  |  |  |  | TOTAL HOURS WORK ASSIGNED TO TECH
2010-06-29 13:43:37 |  |  |  |  |  | TOTAL HOURS OF WAITERS ASSIGNED TO TECH
(BF) FISHER, BRENT | 15.85 | 8 | 7.85 |  | 15.85 | 0
(BS) SCHINDEL, ROBERT | 23.2 | 16 | 7.199999999999999 |  | 23.2 | 0 |  |  |  |  |  |  | NOTE TO PROGRAMMERS: TEXT HIDDEN (FONT COLOR SET TO WHITE OR GRAY) AT F4:G14, [NAME]:K20, AND [NAME]:Q36. THE PURPOSE OF THESE FIELDS ARE TO PROVIDE CALCULATIONS TO BE DISPLAYED IN B4:B31 AND H18:I30.
(DA) BRATKOWSKI, DAN | 0 |  | 0 |  | 0 | 0
(DB) BILANSKY, DAN | 1 |  | 1 |  | 1 | 0
(DH) HAGEMANN, DEAN | 3.8 | 3.7 | 0.09999999999999964 |  | 3.8 | 0
(JZ) MATYSZCZYK, JASON | 4.9 | 1 | 3.9 |  | 4.9 | 0
(RA) ACHTERHOF, RYAN | 7.5 |  | 7.5 |  | 6 | 1.5
(RG) GOTTFRIED, RICH | 3 | 3 | 0 |  | 3 | 0
(TF) FRITZ, TOM | 9 | 4 | 5 |  | 9 | 0
(TP) POLIZZI, [NAME] | 11.4 | 6 | 5.4 |  | 11.4 | 0
(HB) HAROUT | 0 |  | 0 |  | 0 | 0
TOTAL: | 79.65 | 41.7 | 37.95
 |  |  |  |  |  |  |  |  |  |  |  |  | calculations
(MH) HOLLAND, [NAME] | 0 |  | 0 |  | FUTURE | WORK | HOURS | # of JOBS |  |  |  | total hours | [NAME] | WASHED |  | TODAY
(MK) KIOSKI, [NAME] | 0 |  | 0 |  | MON: | 2010-06-28 00:00:00 | 2.8 | 2 |  |  |  | 2.8 | 0 | 0 |  | 2010-06-29 00:00:00
(RS) SLOWINSKI, RANDAL | 0 |  | 0 |  | TUE: | 2010-06-29 00:00:00 | 22.7 | 14 |  |  |  | 23.2 | 0.5 | 0
(AC) CLAFLIN, ANDY | 0 |  | 0 |  | WED: | 2010-06-30 00:00:00 | 38 | 6 |  |  |  | 38 | 0 | 0
TOTAL: | 0 | 0 | 0 |  | THU: | 2010-07-01 00:00:00 | 26.2 | 5 |  |  |  | 26.2 | 0 | 0
 |  |  |  |  | FRI: | 2010-07-02 00:00:00 | 2.8 | 1 |  |  |  | 2.8 | 0 | 0
TOTALS: | 79.65 | 41.7 | 37.95 |  | SAT: | 2010-07-03 00:00:00 | 0 | 0 |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
UNASSIGNED WORK: | 3 hrs | 2 jobs | 0 waiters |  | MON: | 2010-07-05 00:00:00 | 1 | 2 |  |  |  | 1 | 0 | 0
 |  | 2 | 0 |  | TUE: | 2010-07-06 00:00:00 | 0 | 1 |  |  |  | 0 | 0 | 0
AVAILABLE HOURS: | 23.05 | 0 |  |  | WED: | 2010-07-07 00:00:00 | 0 | 0 |  |  |  | 0 | 0 | 0
 |  |  |  |  | THU: | 2010-07-08 00:00:00 | 0 | 0 |  |  |  | 0 | 0 | 0
[NAME] AVAILABLE: | 8 |  |  |  | FRI: | 2010-07-09 00:00:00 | 21.2 | 1 |  |  |  | 21.2 | 0 | 0
 |  |  |  |  | SAT: | 2010-07-10 00:00:00 | 0 | 0 |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  | THIS ADDS THE TOTAL HOURS OF JOBS UNASSIGNED FOR THE CURRENT DAY
 |  |  |  |  |  |  |  |  |  |  |  | 3
 |  |  |  |  |  |  |  |  |  |  |  | THIS ADDS THE TOTAL HOURS OF WAITERS LEFT UNASSIGNED
 |  |  |  |  |  |  |  |  |  |  |  | 0
Spreadsheet: 864d2f59-54dd-47ee-9e76-5e0128ffccee
Sheet: Sheet1

Depression Among High School Students,  by County and Public Health District, Maine, 2011 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
 |  | High School
 |  | weighted number |  | % | 95% CI
Total |  | 13048 |  | 22.7 | 21.7 - 23.6 |  | Depression Among High School Students,  by Year, Maine, 2001-2011
County
 | Androscoggin | 1068 |  | 23.3 | 19.5 - 27.1
 | Aroostook | 710 |  | 22.6 | 19.2 - 26.0 |  | Year | High School
 | Cumberland | 2607 |  | 20.8 | 18.6 - 23.0 |  |  | % | 95% CI
 | Franklin | 243 |  | 19.7 | 17.4 - 22.0 |  | 2001* | 26.7 | 24.3 – 29.2
 | Hancock | 458 |  | 22.3 | 20.1 - 24.6 |  | 2003* | 24.7 | 23.1 – 26.4
 | Kennebec | 1071 |  | 21.3 | 19.6 - 23.0 |  | 2005* | 20.6 | 17.3 – 24.3
 | Knox | 318 |  | 24.3 | 17.7 - 31.0 |  | 2007* | 22.2 | 19.0 – 25.7
 | Lincoln | ^ |  | ^ | ^ |  | 2009 | 22.7 | 21.7 – 23.6
 | Oxford | 756 |  | 25.2 | 23.0 - 27.4 |  | 2011 | 22.7 | 21.7 - 23.6
 | [NAME] | 1554 |  | 22.5 | 19.8 - 25.2 |  | US 2009* | 26.1 | 24.8 – 27.5
 | Piscataquis | 181 |  | 21.8 | 16.9 - 26.8
 | Sagadahoc | 439 |  | 26.9 | 21.9 - 31.9 |  | *There are slight differences between methodologies between the Maine Integrated Youth Health Survey and the Maine Youth Risk Behavior Survey, and therefore the data from these difference sources may not be directly comparable.
 | Somerset | 631 |  | 24.3 | 22.3 - 26.2
 | [NAME] | 288 |  | 23 | 18.2 - 27.8
 | Washington | 329 |  | 23.3 | 22.2 - 24.5
 | York | 2063 |  | 24.1 | 20.5 - 27.8
Public Health District
 | Aroostook | 710 |  | 22.6 | 19.2 - 26.0
 | Central | 1,713 |  | 22.4 | 21.1 - 23.7
 | Cumberland | 2,607 |  | 20.8 | 18.6 - 23.0
 | Downeast | 790 |  | 22.8 | 21.3 - 24.4
 | [NAME] | 1,407 |  | 24.8 | 21.6 - 27.9
 | Penquis | 1,731 |  | 22.4 | 20.0 - 24.8
 | Western | 2,079 |  | 23.6 | 21.3 - 25.9
 | York | 2,063 |  | 24.1 | 20.5 - 27.8
Data Source:  Maine Integrated Youth Health Survey (2009-2011), Maine Youth Risk Behavior Survey (2001-2007), US. Youth Risk Behavior Risk Survey (US 2009) Based on students who reported that they felt sad or hopeless almost every day for 2 or more weeks and stopped doing some usual activities. All percentages are weighted to be more representative of the population of Maine students and to adjust for non-response.  95% CI = 95% Confidence Interval. Data is not available for Middle School students because the survey design does not allow geographic stratification. ^ Results are not reported because weighted data are not available due to low response rates.
Spreadsheet: 715698d1611838896-minimum-dates-excel-sheet
Sheet: Results

Duty | Title | No of PBS | Workstream Earliest Start Date | Workstream Latest End Date | KOM Date
204 | This data does not matter I believe |  | This is where I would like the results | This is where I would like the results
222
252 |  |  | The results would be the earliest date in column E:J on the data spreadhseet and all rows based on a value in columns K:AL on the data spreadsheet | The results would be the latest date in column E:J on the data spreadhseet and all rows based on a value in columns K:AL on the data spreadsheet
254
265
275
283
285
296
302
303
320
322
600
628
640
653
665
685
712
720
734
768
833
902
903
905
906
Spreadsheet: 827836d1683053240-help-with-formula-to-find-if-nth-day-of-month-falls-between-2-dates-example-sheet
Sheet: Sheet1

Start Date | End Date | Includes the 12th? | Formula1 | Formula2 | Formula3
2022-12-19 00:00:00 | 2023-01-01 00:00:00 | NO
2023-01-01 00:00:00 | 2023-01-01 00:00:00 | NO
2023-01-02 00:00:00 | 2023-01-15 00:00:00 | YES
2023-01-16 00:00:00 | 2023-01-29 00:00:00 | NO
2023-01-30 00:00:00 | 2023-02-12 00:00:00 | YES
2023-02-13 00:00:00 | 2023-02-26 00:00:00 | NO
2023-02-27 00:00:00 | 2023-03-12 00:00:00 | YES
2023-03-13 00:00:00 | 2023-03-26 00:00:00 | NO
2023-03-27 00:00:00 | 2023-04-09 00:00:00 | NO
2023-04-10 00:00:00 | 2023-04-23 00:00:00 | YES
Spreadsheet: 135522d1326111549-lookup-help-staff-planner-test
Sheet: Sheet1

1 | 2 | 3 | 4 | 5 | 6 |  |  | 9 | 10 | 11 | 12
2013-02-01 00:00:00 | 2013-02-02 00:00:00 | 2013-02-03 00:00:00 | 2013-02-04 00:00:00 | 2013-02-05 00:00:00 | 2013-02-06 00:00:00 | 2013-02-07 00:00:00 | 2013-02-08 00:00:00 | 2013-02-09 00:00:00 | 2013-02-10 00:00:00 | 2013-02-11 00:00:00 | 2013-02-12 00:00:00 | 2013-02-13 00:00:00 | 2013-02-14 00:00:00 | 2013-02-15 00:00:00
01-02-2013 | 02-02-2013 | 03-02-2013 | 04-02-2013 | 05-02-2013 | 06-02-2013 | 07-02-2013 | 08-02-2013 | 09-02-2013 | 10-02-2013 | 11-02-2013 | 12-02-2013 | 13-02-2013 | 14-02-2013 | 15-02-2013
01-02-2013 | 02-02-2013 | 03-02-2013 | 04-02-2013 | 05-02-2013 | 06-02-2013 | 09-02-2013 | 10-02-2013 | 11-02-2013 | 12-02-2013
01-02-2013/02-02-2013/03-02-2013/04-02-2013/ 05-02-2013/06-02-2013/09-02-2013/10-02-2013/ 11-02-2013/12-02-2013/
Spreadsheet: 689523d1596477599-offset-troubles-cash-forecast-sample
Sheet: Cons Weekly F'Cast

 | Week begins | 2020-08-03 00:00:00
 | year.month
 | year.week
 | AR
 | [NAME]
 | APT
 | APNT Vendor
 | APNT Expenses
 | [NAME]
 | [NAME]
 | [NAME]
 | IP Net Pay
 | IP Tax
 | IP Social
 | IP Other
 | Tax VAT
 | Tax CT
 | Tax Other
 | CoSec/Legal
 | [NAME]
 | Other