tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 219f0c1c-50ff-4f1c-a1a7-f0488198642b
Sheet: Sheet1

Permit No.: | Unnamed: 1 | WQ0021863 | Unnamed: 3 | Facility Name: | Unnamed: 5 | Town of Apex Reclaimed Water System | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | County: | Wake | Unnamed: 13 | Month: | Unnamed: 15 | Unnamed: 16 | Year: | Unnamed: 18
PPI: |  | 001 | Flow Measuring Point: |  |  |  |  |  |  | Parameter Monitoring Point:
Parameter Code |  |  | 50050
Day | ORC Arrival Time | ORC Time On Site | Flow
 | 24-hr | hrs | GPD
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
Average:
Daily Maximum:
Daily Minimum:
Sampling Type: |  |  | Estimate
Monthly Limit: |  |  | 100000
Daily Limit:
Sample Frequency: |  |  | [NAME]
 |  | Average
 |  | Geomean
 |  | MAX/MIN
Spreadsheet: 162512d1339942278-excel-2007-userforms-poi
Sheet: Sheet1

 |  |  | Date | Item | Unit Price | Qty | Total
 |  |  | 16/6/12 | abc | 23 | 43
 |  |  | 16/6/12 | aoc | 45 | 33
 |  |  | 16/6/12 | abci | 22 | 43
 |  |  | 16/6/12 | abcd | 11 | 23
 |  |  |  |  |  | Total
 |  |  | Signature: _______________________
Spreadsheet: 149437d1333968821-make-chart-go-as-far-as-cell-tells-it-chart-example
Sheet: Sheet1

Year To
25
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
36 | 41 | 40 | 38 | 35 | 34 | 36 | 38 | 36 | 36 | 36 | 48 | 34 | 35 | 27 | 34 | 37 | 27 | 29 | 44 | 40 | 41 | 25 | 50 | 41 | 32 | 44 | 37 | 34 | 49 | 28 | 29 | 38 | 31 | 43 | 29 | 46 | 31 | 39 | 42 | 48 | 31 | 34 | 32 | 37 | 50 | 39 | 46 | 27 | 33
Spreadsheet: 129541d1321659075-excel-2007-if-statement-sales_use_tax_8_2011
Sheet: Sheet1

 |  |  | [NAME]
 |  |  | Monthly Sales Tax |  |  | Month | Aug 2011
Hotel |  | Gross with 12.5% tax |  | Tax rate |  | 6841 | Total sales
 |  |  |  | 0.125 |  | 6080.888888888889 | Sales w/o tax
 |  |  |  |  |  | 760.1111111111113
Florida sales tax |  | 0.06
Florida surtax |  | 0.015
[NAME] tax |  | 0.05
 |  |  |  | 0.075 |  | 456.0666666666667 | State Tax
 |  |  |  | 0.05 |  | 304.0444444444444 | County Tax
 |  |  |  |  |  | 760.1111111111111 | Total Tax
[NAME] |  | Gross with 12.5% tax |  |  |  | 11985 | Total sales
 |  |  |  | 0.125 |  | 10653.33333333333 | Sales w/o tax
 |  |  |  |  |  | 1331.666666666666
 |  |  |  | 0.075 |  | 799 | State Tax
 |  |  |  | 0.05 |  | 532.6666666666667 | County Tax
 |  |  |  |  |  | 1331.666666666667 | Total Tax
 | State Tax |  |  | County Tax |  |  | Sales w/o Tax
Hotel | 456.0666666666667 |  |  | 304.0444444444444 |  |  | 6080.888888888889
[NAME] | 799 |  |  | 532.6666666666667 |  |  | 10653.33333333333
Totals | 1255.066666666667 |  |  | 836.7111111111112 |  |  | 16734.22222222222
Collection Allowance if paid before 20th of month |  |  |  |  | 0.025
 |  |  |  |  |  |  | Tax Due
State | 31.37666666666667 |  |  |  |  | State | 1223.69
County | 20.91777777777778 |  |  |  |  | County | 815.7933333333334
Spreadsheet: 192084d1352303402-is-there-such-a-thing-as-auto-filter-or-a-workaround-that-will-do-the-following-deal-log
Sheet: CHRIS

 | TEAM1
 | SALESMEN |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL FRONT
 | DUKE |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL BACK
 | RON |  |  |  |  |  |  |  |  |  |  |  |  |  |  | counts:
 | CLEMONS |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PENETRATION
 | CHRIS |  |  |  |  |  |  |  |  |  |  |  |  |  | total gross |  | new gross breakdown |  |  |  |  | used gross breakdown
## | 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: 456115d1460650330-how-to-use-vslookup-for-3-products-book2
Sheet: Sheet1

ice cream |  |  |  |  |  |  | ice cream | [NAME] | [NAME] | bammer
w0942 |  |  |  |  |  |  | w0942 | 84 | 80 | 70
w1242 |  |  |  |  |  |  | w1242 | 92 | 86 | 80
w1542 |  |  |  |  |  |  | w1542 | 102 | 94 | 90
w1842 |  |  |  |  |  |  | w1842 | 108 | 102 | 98
w2142 |  |  |  |  |  |  | w2142 | 116 | 110 | 80
w2442 |  |  |  |  |  |  | w2442 | 142 | 134 | 120
w2742 |  |  |  |  |  |  | w2742 | 150 | 142 | 130
w3042 |  |  |  |  |  |  | w3042 | 160 | 150 | 140
w3342 |  |  |  |  |  |  | w3342 | 168 | 156 | 140
w3642 |  |  |  |  |  |  | w3642 | 176 | 164 | 150
w3024 |  |  |  |  |  |  | w3024 | 110 | 104 | 99
w3324 |  |  |  |  |  |  | w3324 | 116 | 110 | 98
w3624 |  |  |  |  |  |  | w3624 | 120 | 112 | 110
wdc2442 |  |  |  |  |  |  | wdc2442 | 168 | 152 | 140
wea1242 |  |  |  |  |  |  | wea1242 | 88 | 82 | 80
Spreadsheet: 820256d1677956944-sort-mixed-data-from-1-sheet-to-other-tabs-bol-a
Sheet: Master

Helper | Name | month | date | del/pic | AM/PM | BOL | on/off
 | atwell |  | 2023-01-12 00:00:00 | del | am | 40 | on
 | begli |  | 2023-01-13 00:00:00 | del | am | 41 | on
 | atwell |  | 2023-01-15 00:00:00 | pic | pm | 42 | on
 | maggie |  | 2023-01-15 00:00:00 | del | pm | 43 | off
 | meggan |  | 2023-01-16 00:00:00 | del | pm | 44 | off
 | [NAME] |  | 2023-01-17 00:00:00 | del | am | 45 | off
 | meggan |  | 2023-01-18 00:00:00 | del | pm | 46 | off
 | begli |  | 2023-01-20 00:00:00 | pic | am | 47 | on
 | karen |  | 2023-02-01 00:00:00 | del | am | 49 | off
 | atwood |  | 2023-01-29 00:00:00 | del | am | 48 | on
 | maggie |  | 2023-02-03 00:00:00 | pic | am | 50 | off
 | peggy |  | 2023-02-05 00:00:00 | del | pm | 51 | off
 | [NAME] |  | 2023-02-06 00:00:00 | pic | am | 52 | off
 | meggan |  | 2023-02-07 00:00:00 | pic | pm | 53 | off
 | atwood |  | 2023-02-10 00:00:00 | pic | pm | 54 | on
 | karen |  | 2023-02-15 00:00:00 | pic | pm | 55 | off
 | [NAME] |  | 2023-03-09 00:00:00 | del | am | 57 | on
 | peggy |  | 2023-02-28 00:00:00 | pic | am | 56 | off
 | peggy |  | 2023-03-09 00:00:00 | pic | am | 58 | off
 | peggy |  | 2023-03-12 00:00:00 | pic | am | 59 | off
 | [NAME] |  | 2023-03-13 00:00:00 | del | pm | 60 | on
Spreadsheet: 731247d1620244791-help-with-formula-average-with-large-with-sumifs-sample
Sheet: Rate Data

ClientName | ProjName | ProductLine | FeeRev | [NAME] | [NAME] |  |  | Client | Product Line | [NAME]
Client 1 | Project 1 | ABC | 0 | 0 |  |  |  | Client 1 | ABC
Client 2 | Project 2 | DEF | 4471.53 | 3.75 |  |  |  | Client 1 | DEF
Client 2 | Project 3 | DEF | 27.5 | 0.5 |  |  |  | Client 2 | DEF
Client 1 | Project 4 | ABC | 5331.33 | 288 |  |  |  | Client 3 | X
Client 5 | Project 5 | DEF | 9746.44 | 200.25 |  |  |  | Client 5 | DEF
Client 1 | Project 6 | DEF | -2008.78 | 0 |  |  |  | Client 5 | ABC
Client 1 | Project 7 | ABC | -165.03 | 0
Client 1 | Project 8 | DEF | 7486.57 | 10
Client 1 | Project 9 | ABC | 0 | 0
Client 1 | Project 10 | DEF | 111 | 61.25
Client 5 | Project 11 | DEF | 3413.22 | 46.5
Client 5 | Project 12 | DEF | 1754.68 | 91.25
Client 1 | Project 13 | X | 1267.42 | 2
Client 3 | Project 14 | X | 943.25 | 10.5
Client 3 | Project 15 | X | 38485.29 | 309.5
Client 3 | Project 16 | X | 3279.15 | 0
Client 5 | Project 17 | ABC | 322.46 | 0
Client 5 | Project 18 | ABC | 91944.72 | 901.25
Spreadsheet: 739009d1625431292-need-help-with-a-formula-to-deduct-a-conditionally-if-specific-cell-is-not-blank-excel-formula-help
Sheet: Sheet1

 |  | January | February | March | April | May | June
 | Number of Sales | 2000 | 1000 | 3000 | 6000 | 9000 | 5000
 | [NAME] | 15.21 | 15.92 | 19.97 | 21.04 | 20.52 | 21.25
 | Revenue
 |  |  |  | Manual Adjustments in %
 |  | January | February | March | April | May | June
 | Revenue |  | 0.05 |  | 0.1
Spreadsheet: 837660d1690334629-formula-to-calculate-betting-odds-for-horse-races-dd-matrix
Sheet: Sheet1

 |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12
DBL --> | 1 | 351 | 2892 | 234 | 184 | 243 | 2137 | 247 | 83
First | 2 | 1536 | 4836 | 1010 | 928 | 1183 | 1183 | 1657 | 588
Leg | 3 | 58 | 942 | 31 | 29 | 29 | 29 | 50 | 11
 | 4
 | 5 | 155 | 2201 | 121 | 109 | 108 | 1335 | 165 | 45
 | 6 | 84 | 2189 | 132 | 105 | 100 | 1623 | 81 | 30
 | 7 | 360 | 3615 | 210 | 183 | 194 | 1471 | 258 | 75
 | 8 | 566 | 4275 | 256 | 241 | 273 | 2201 | 347 | 102
 | 9 | 123 | 1573 | 78 | 54 | 59 | 1137 | 85 | 17
 | 10 | 1766 | 10926 | 2021 | 1251 | 2027 | 1753 | 1746 | 830
 | 11
 | 12
Win Takeout
0.17 |  | Second Leg Final Win Pool Odds Estimate
 |  | 8-1 | 99-1 | 5-1 | 9-2 | 5-1 | 75-1 | 7-1 | 1-1
 |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12
 | 1
 | 2
 | 3
 | 4
 | 5
 | 6
 | 7
 | 8
 | 9
 | 10
 | 11
 | 12
Spreadsheet: 734191d1622032744-lookup-function-to-pull-data-into-a-master-list-example-1-
Sheet: Pivot

Row Labels | Sum of No. of Contacts
rfc_corporate_charity
rfc_corporate_companyinformation | 1
rfc_corporate_jobs
rfc_corporate_marketinginformation
rfc_feedback_customerservicenotstorebased_complaint
rfc_feedback_customerservicenotstorebased_positive | 1
rfc_feedback_online/website_complaint | 1
rfc_feedback_online/website_positive
rfc_feedback_storefeedback_complaint | 1
rfc_feedback_storefeedback_positive | 1
rfc_junk_bounceback | 15
rfc_junk_duplicate | 3
rfc_junk_spam | 42
rfc_orderissue_cancel/amend_iwanttoamendmyorder_amendaddress
rfc_orderissue_cancel/amend_iwanttoamendmyorder_amendemail | 1
rfc_orderissue_cancel/amend_iwanttoamendmyorder_amendproduct
rfc_orderissue_cancel/amend_iwanttoamendmyorder_deliveryservice
rfc_orderissue_cancel/amend_iwanttocancelmyorder | 10
rfc_orderissue_cancel/amend_whyhasmyorderbeencancelled_fraud | 9
rfc_orderissue_cancel/amend_whyhasmyorderbeencancelled_stock | 141
rfc_orderissue_delivery_chasinglit_chasingreplacement
rfc_orderissue_delivery_chasinglit_requestingupdate | 19
rfc_orderissue_delivery_chasingmpd_chasingreplacement
rfc_orderissue_delivery_chasingmpd_requestingupdate | 21
rfc_orderissue_delivery_wismo_chasingorderbeforeitsdue_international | 159
[NAME] | 7
rfc_orderissue_delivery_wismo_dts_ismyorderinthestore__cannotlocate | 31
rfc_orderissue_delivery_wismo_dts_ismyorderinthestore_carrierissue | 1
rfc_orderissue_delivery_wismo_dts_ismyorderinthestore_dcdelay
rfc_orderissue_delivery_wismo_dts_ismyorderinthestore_storedelay | 17
rfc_orderissue_delivery_wismo_dts_orderlit_cannotlocate | 4
rfc_orderissue_delivery_wismo_dts_orderlit_carrierissue
rfc_orderissue_delivery_wismo_dts_orderlit_dcdelay | 2
rfc_orderissue_delivery_wismo_dts_storecannotfindmyorder_cannotlocate | 16
rfc_orderissue_delivery_wismo_dts_storecannotfindmyorder_dcdelay | 10
rfc_orderissue_delivery_wismo_homedelivery_icannottrackmyorder_carrierissue_cannotlocate | 5
rfc_orderissue_delivery_wismo_homedelivery_icannottrackmyorder_dcdelay | 13
rfc_orderissue_delivery_wismo_homedelivery_myorderislate_cannotlocate | 21
rfc_orderissue_delivery_wismo_homedelivery_myorderislate_carrierissue | 7
rfc_orderissue_delivery_wismo_homedelivery_myorderislate_dcdelay | 37
Grand Total | 596
Spreadsheet: 834051d1687419843-need-help-to-find-out-code-wise-rate-calculation-code-wise-rate-calculation-revised-single-code-ans
Sheet: BB

Code | [NAME] | Sr.No | From Date | To Date | From Load | To Load | Phase | [NAME] | Contract Demand | Rate/Month
AG |  | 34 | 2022-01-01 00:00:00 | 2022-01-31 00:00:00 | 1 | -- | -- | -- | -- | 20
AG |  | 35 | 2022-02-01 00:00:00 | 2022-03-31 00:00:00 | 1 | -- | -- | -- | -- | 20
AG |  | 36 | 2022-04-01 00:00:00 | 2022-06-30 00:00:00 | 1 | -- | -- | -- | -- | 20
AG |  | 37 | 2022-07-01 00:00:00 | 2022-09-28 00:00:00 | 1 | 7.5 | -- | -- | -- | 20
AG |  | 38 | 2022-07-01 00:00:00 | 2022-09-28 00:00:00 | 7.51 | 999 | -- | -- | -- | 20
AG |  | 39 | 2022-09-29 00:00:00 | 2022-12-31 00:00:00 | 7.51 | 999 | -- | -- | -- | 5 | x
AG |  | 40 | 2022-09-29 00:00:00 | 2022-12-31 00:00:00 | 1 | 7.5 | -- | -- | -- | 10
AG |  | 41 | 2023-01-01 00:00:00 | 2023-03-31 00:00:00 | 7.51 | 999 | -- | -- | -- | 5 | x
AG |  | 42 | 2023-01-01 00:00:00 | 2023-03-31 00:00:00 | 1 | 7.5 | -- | -- | -- | 10
AG |  | 43 | 2023-04-01 00:00:00 | -- | 7.51 | 999 | -- | -- | -- | 5
AG |  | 44 | 2023-04-01 00:00:00 | -- | 1 | 7.5 | -- | -- | -- | 10
Spreadsheet: 134772d1325626617-sumproduct-with-array-test
Sheet: Schedules

 |  | Monday |  | Tuesday |  | Wednesday |  | Thursday |  | Friday |  | Saturday |  | Sunday
 |  | 2012-01-02 00:00:00 |  | 2012-01-03 00:00:00 |  | 2012-01-04 00:00:00 |  | 2012-01-05 00:00:00 |  | 2012-01-06 00:00:00 |  | 2012-01-07 00:00:00 |  | 2012-01-08 00:00:00
 |  | 0 | 0 | 5 | 0 | 5.5 | 1 | 10.5 | 2 | 5.5 | 1 | 11 | 2 | 5 | 1
Name | ID | Start | End | Start | End | Start | End | Start | End | Start | End | Start | End | Start | End
Employee A | 5630 |  |  |  |  | 17.5 | 23 | 17.5 | 23 | 17.5 | 23 | 12 | 18
Employee A- Actual Hours Worked |  |  |  |  |  | 17.5 | 23 | 17.5 | 23 | 17.5 | 23 | 12 | 18
Employee B | 5610 |  |  | 17.5 | 22.5 |  |  | 17.5 | 22.5 |  |  | 11 | 16 | 12 | 17
Employee B- Actual Hours Worked |  |  |  | 0 | 0 |  |  | 17.5 | 22.5 |  |  | 11 | 16 | 12 | 17
Spreadsheet: richard_ring__31564__Enron_MayJune_1999
Sheet: Enron_MayJune1999

 | AMOUNTS DEDICATED TO ENRON SALE (50 MW flat): May and June 1999
 | Summary of Resources Dedicated (Prepared by [NAME], 9/26/01):
 |  | Hours | Sales Commitment @ 50 MW |  | Black Canyon | Hills Creek | Big Cliff | Cougar | [NAME] | [NAME] | Monthly Subtotal
 |  |  |  |  | (MWh) | (MWh) | (MWh) | (MWh) | (MWh) | (MWh) | (MWh)
 | Generation
 | 1999-05-01 00:00:00
 | 1999-06-01 00:00:00
 | Subtotals, 2 mo.:
 | LESS: Amounts Dedicated to other sales or commitments
 | 1999-05-01 00:00:00 |  |  |  | 0 | 0 | 0 | 0 | 0 | 0
 | 1999-06-01 00:00:00 |  |  |  | 0 | 0 | 0 | 0 | 0 | 0
 | Subtotals, 2 mo.:
 | Available Generation (Net of other sales or commitments)
 | 1999-05-01 00:00:00
 | 1999-06-01 00:00:00
 | Subtotals, 2 mo.:
 | Dedicated Amounts (to Enron)
 | 1999-05-01 00:00:00 |  |  |  | 1887 | 8323 | 6206 | 9635 | 4870 | 6279
 | 1999-06-01 00:00:00 |  |  |  | 1043 | 10478 | 5988 | 9021 | 4680 | 4790
 | Subtotals, 2 mo.:
 | Generation available for other sales (net of Enron sale)
 | 1999-05-01 00:00:00
 | 1999-06-01 00:00:00
 | Subtotals, 2 mo.:
Spreadsheet: 265988d1379456793-time-and-date-forumla-issues-copy-of-maintenance-example-forum
Sheet: Allocation & Codes

 |  |  | Codes | Allocation times |  |  |  |  |  |  |  |  |  | 23:19:30
Paris | Business cards | [EMAIL] | a | 14 days
 | Catering | [EMAIL] | b | 4 hours
 | Cleaning | [EMAIL] | c | 90 minutes
 | Computer Errors | [EMAIL] | d | 7 days
 | HSE Objects | [EMAIL] | e | 1 day
 | [NAME] | [EMAIL] | f | 5 hours
[NAME] | Business cards | [EMAIL] | a | 14 days
 | Catering | [EMAIL] | b | 4 hours
 | Cleaning | [EMAIL] | c | 90 minutes
 | Computer Errors | [EMAIL] | d | 7 days
 | HSE Objects | [EMAIL] | e | 1 day
 | [NAME] | [EMAIL] | f | 5 hours
London | Business cards | [EMAIL] | a | 14 days
 | Catering | [EMAIL] | b | 4 hours
 | Cleaning | [EMAIL] | c | 90 minutes
 | Computer Errors | [EMAIL] | d | 7 days
 | HSE Objects | [EMAIL] | e | 1 day
 | [NAME] | [EMAIL] | f | 5 hours
[NAME] | Business cards | [EMAIL] | a | 14 days
 | Catering | [EMAIL] | b | 4 hours
 | Cleaning | [EMAIL] | c | 90 minutes
 | Computer Errors | [EMAIL] | d | 7 days
 | HSE Objects | [EMAIL] | e | 1 day
 | [NAME] | [EMAIL] | f | 5 hours
Spreadsheet: 267866d1380255240-use-selections-from-two-data-validation-lists-to-lookup-and-return-a-mailing-address-state-county-fips-codes
Sheet: KENTUCKY-16

 | COUNTY | CODE
 | Adair | 1
 | [NAME] | 3
 | [NAME] | 5
 | Ballard | 7
 | Barren | 9
 | Bath | 11
 | Bell | 13
 | Boone | 15
 | Bourbon | 17
 | [NAME] | 19
 | Boyle | 21
 | [NAME] | 23
 | Breathitt | 25
 | Breckinridge | 27
 | [NAME] | 29
 | Butler | 31
 | Caldwell | 33
 | Calloway | 35
 | Campbell | 37
 | Carlisle | 39
 | Carroll | 41
 | [NAME] | 43
 | [NAME] | 45
 | Christian | 47
 | [NAME] | 49
 | Clay | 51
 | [NAME] | 53
 | [NAME] | 55
 | Cumberland | 57
 | Daviess | 59
 | [NAME] | 61
 | [NAME] | 63
 | Estill | 65
 | Fayette | 67
 | Fleming | 69
 | [NAME] | 71
 | Franklin | 73
 | Fulton | 75
 | [NAME] | 77
 | Garrard | 79
 | Grant | 81
 | Graves | 83
 | [NAME] | 85
 | Green | 87
 | [NAME] | 89
 | Hancock | 91
 | Hardin | 93
 | Harlan | 95
 | [NAME] | 97
 | Hart | 99
 | Henderson | 101
 | [NAME] | 103
 | [NAME] | 105
 | Hopkins | 107
 | [NAME] | 109
 | [NAME] | 111
 | Jessamine | 113
 | [NAME] | 115
 | Kenton | 117
 | [NAME] | 119
 | Knox | 121
 | Larue | 123
 | Laurel | 125
 | [NAME] | 127
 | [NAME] | 129
 | [NAME] | 131
 | Letcher | 133
 | Lewis | 135
 | Lincoln | 137
 | [NAME] | 139
 | Logan | 141
 | Lyon | 143
 | McCracken | 145
 | McCreary | 147
 | McLean | 149
 | [NAME] | 151
 | Magoffin | 153
 | Marion | 155
 | [NAME] | 157
 | Martin | 159
 | Mason | 161
 | Meade | 163
 | Menifee | 165
 | Mercer | 167
 | Metcalfe | 169
 | Monroe | 171
 | Montgomery | 173
 | Morgan | 175
 | [NAME] | 177
 | [NAME] | 179
 | [NAME] | 181
 | Ohio | 183
 | Oldham | 185
 | [NAME] | 187
 | Owsley | 189
 | Pendleton | 191
 | [NAME] | 193
 | Pike | 195
 | [NAME] | 197
 | Pulaski | 199
 | [NAME] | 201
 | Rockcastle | 203
 | [NAME] | 205
 | [NAME] | 207
 | Scott | 209
 | Shelby | 211
 | Simpson | 213
 | [NAME] | 215
 | [NAME] | 217
 | Todd | 219
 | [NAME] | 221
 | Trimble | 223
 | Union | 225
 | [NAME] | 227
 | Washington | 229
 | Wayne | 231
 | [NAME] | 233
 | [NAME] | 235
 | Wolfe | 237
 | Woodford | 239
Spreadsheet: 135702d1326194489-running-totals-and-looking-up-text-dummy-parts
Sheet: PARTS INCOME

DATE | INVOICE NO. | CUSTOMER | ORIGINAL PART INVOICE | ORIGINAL PART NO. | PART DESCRIPTION | QTY. | OUR PRICE | RETAIL | VAT AMOUNT | VAT | TOTAL | TOTAL VAT AMOUNT | TOTAL VAT | RUNNING TOTAL | RUNNING VAT AMOUNT | RUNNING TOTAL VAT
2012-01-05 00:00:00 | 22303 | MRS BLOTT | 648294-6 | 6493RQ | UNICORN | 1 |  | 40
2012-01-04 00:00:00 | 22304 | MR GUY | 4393763 | TRG 7649 | RUBBER BALL | 1 |  | 3
2012-01-06 00:00:00 | 22305 | MRS WENDY |  |  | BEACH BALL | 1 |  | 7
2012-01-06 00:00:00 | 22306 | MRS DAY |  |  | MONOPOLY | 2 |  | 25
2012-01-06 00:00:00 | 22307 | MRS [NAME] | 039848 | T T983. 876. 985 | CLUEDO | 1 |  | 30
2012-01-06 00:00:00 | 22308 | MR FRANK |  |  | BATTLESHIPS | 2 |  | 70.99
2012-01-06 00:00:00 | 22309 | MR DUDE |  |  | ROCKING HORSE | 1 |  | 75
Spreadsheet: 878287d1725362674-date-validation-issue-exampleworkbook_dependentdv
Sheet: Sheet2

Category | Item | Qty | Price | Amount |  | Select the entire range B2:B7 (or further as desired), then use the following formula as the Data Validation list source:
[NAME] | 4mm Clear Tough | 1 |  |  |  | =TAKE(DROP(matMaterials,XMATCH(A2,matCategory)-1),COUNTIF(matCategory,A2))
Bulkheads | Colour | 3
Bulkheads | Compact | 1 |  |  |  | **Be sure to uncheck the [NAME] blank checkbox in Data Validation with this method.
Other | CFC | 2
 |  |  |  |  |  | Alternatively, the OFFSET function can be used instead of TAKE/DROP:
 |  |  |  |  |  | =OFFSET(matMaterials,MATCH(A2,matCategory,0)-1,0,COUNTIF(matCategory,A2))
 |  |  |  |  |  | Conditional Formatting Rules can also be set to help identify invalid Items after a Category has been changed:
 |  |  |  |  |  | =AND(COUNTIFS(matCategory,A2,matMaterials,B2)=0,B2<>"")
Spreadsheet: 863901d1711299968-not-sure-whether-to-use-vlookup-or-if-and-then-or-combo-rental-payments-sample
Sheet: Results

WHAT I WANT
Month | Rent | Water | Sewer | Late Fee | Total
2019-11-01 00:00:00 | 334 | 10.3 | 8.92
2019-12-01 00:00:00 | 334 | 8.49 | 6.45
Month | Rent | Water | Sewer | Late Fee | Total
2019-11-01 00:00:00
2019-12-01 00:00:00
Spreadsheet: 862393d1710150221-how-do-i-create-polynomial-coefficients-for-a-table-with-2-variable-inputs-polynomial-generation-aligw
Sheet: Sheet1

 |  |  | Fan Speed
 |  |  | 1 | 0.8 | 0.6 | 0.4 | 0.2
 | Density Ratio | 0.2 | 0.5602681786444155 | 0.5242592146626477 | 0.4862250698137789 | 0.4459899534174349 | 0.4033571231574961
 |  | 0.4 | 0.7690471505528507 | 0.7462019507305976 | 0.7220719135659387 | 0.6965455120173826 | 0.6694979266780862
 |  | 0.6 | 0.8813066990653233 | 0.8688018306703822 | 0.8555936757206858 | 0.8416211872134858 | 0.8268160422508499
 |  | 0.8 | 0.9516895842186365 | 0.9464433274230571 | 0.9409020157935861 | 0.9350400378449242 | 0.9288287295834818
 |  | 1 | 1 | 1 | 1 | 1 | 1
 |  | 1.2 | 1.035229615944395 | 1.039166939513177 | 1.043325702175934 | 1.047725125390672 | 1.052386721527437
 |  | 1.4 | 1.062063465303166 | 1.069054263945055 | 1.076438232233882 | 1.084249498262037 | 1.092526257683161
 |  | 1.6 | 1.083185696627049 | 1.092609524244377 | 1.102563357540156 | 1.113093202310873 | 1.124250547560015
 |  |  |  | Fan Speed = | 0.6
 |  |  |  | Density Ratio = | 0.8
 |  |  |  | Result = | 0.9409
Spreadsheet: 49884d1249315471-allocating-info-example
Sheet: Sheet1

 | Worksheet 1 |  |  |  |  |  | Worksheet 2
Name | Skill 1 | Skill 2 | Skill 3 |  |  | Name | aa | bb | cc
[NAME] | aa | bb | cc |  |  | [NAME]
Sue | aa | cc |  |  |  | Sue
[NAME] | bb | cc |  |  |  | [NAME]
[NAME] | aa | cc |  |  |  | [NAME]
[NAME] | aa | bb |  |  |  | [NAME]
[NAME] | aa | bb | cc |  |  | [NAME]
Spreadsheet: 721190d1614578928-conditional-formatting-highlights-none-duplicate-based-on-rows-and-columns-highlight_not_duplicate
Sheet: Sheet1

No. | 1 | 2 | 3 | 4 | 5 | 6 | RESHUFFLE  (Y/N) | R1 | R2 | R3 | R4 | R5 | R6
1 | 3 | 3 | 3 | 3 | 3 | 3 |  | 3 | 3 | 3 | 3 | 3 | 3
2 | 3 | 4 | 2 | 3 | 3 | 3 |  | 3 | 3 | 3 | 3 | 3 | 3
3 | 3 | 4 | 2 | 3 | 3 | 3 |  | 3 | 3 | 3 | 3 | 3 | 3
4 | 4 | 4 | 2 | 3 | 3 | 3 |  | 3 | 3 | 3 | 3 | 3 | 3
5 | 1 | 3 | 3 | 3 | 3 | 3 |  | 3 | 3 | 3 | 3 | 3 | 3
6 | 3 | 4 | 2 | 3 | 3 | 3 |  | 3 | 3 | 3 | 3 | 3 | 3
7 | 1 | 4 | 2 | 3 | 3 | 3 |  | 3 | 3 | 3 | 3 | 3 | 3
8 | 1 | 3 | 2 | 3 | 3 | 3 |  | 3 | 3 | 3 | 3 | 3 | 3
9 | 1 | 4 | 2 | 3 | 3 | 3 |  | 3 | 3 | 3 | 3 | 3 | 3
10 | 1 | 3 | 2 | 3 | 3 | 3 |  | 4 | 3 | 4 | 3 | 3 | 3