tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 593756d1539320785-return-text-or-data-validation-list-copy-of-pseudoex-entregan-
Sheet: Sheet1

List_1 | List_2 |  | Type Range |  | ResName1 | ResName2 | ResName3 | ResName4 | [NAME] form row | Option.A |  | Option.B |  | Option.C |  |  | Option.AA |  | Option.BB |  | Option.CC
Type1 | TypeA |  | Type_1 |  | Option.N | Option.R | Option.D | OptSelect | 1 | A.Select1 |  |  | 1 | C.Select1
Type2 | TypeB |  | Type_2 |  | Option.K | Option.D | Option.T |  |  |  | 1 | B.Select1
[NAME] | TypeC |  | Type_3 |  | Option.W | Option.A | Option.J |  | 2 | A.Select2 |  |  | 2 | [NAME]
 |  |  | Type_A |  | Option.A | Option.B | Option.C | Option.A | 3 | A.Select3 |  |  | 2 | C.Select4
 |  |  | Type_B |  | Option.L | Option.R | Option.D |  |  |  | 2 | B.Select2
 |  |  | Type_C |  | Option.B | Option.K | Option.Z
 |  |  |  |  |  |  |  |  | OptSelect
ResList1 | ResList2 | ResList3 | Reslist4 |  |  |  |  |  | Option.A
Option.P | Option.B | Option.N | Option.G |  |  |  |  |  | Option.B
 |  |  |  |  |  |  |  |  | Option.Y
 |  |  |  |  |  |  |  |  | Option.Z
DropDown1 | Type1, Type2, Type3 and so on.
[NAME] | If(b13=Type1,or(typeB,TypeL),"") and so on.
ResName1 | ResName2 | ResName3 | ResName4
A.Select1 | B.Select1 | C.Select1 | A.Select1
A.Select2 | B.Select2 | [NAME] | A.Select2
A.Select3 |  | C.Select4 | A.Select3
Spreadsheet: 3a88b350-2980-4485-a24c-163133e0d6e1
Sheet: year period scenario matrix

Year | Period | Scenario
FY12 | YearTotal | Actual
FY13 | YearTotal | Actual
FY14 | YearTotal | Actual
FY14 | YearTotal | Forecast
FY15 | YearInput | Current Services
FY15 | YearInput | Reallocation-Initial
FY15 | YearInput | One-Time
FY15 | YearInput | Ongoing
FY15 | YearInput | New Requests
FY15 | YearInput | Reallocation-Final
FY15 | YearInput | Total Budget
Spreadsheet: 3095108b-1517-471e-85ab-e13a45ed0f9e
Sheet: Sheet1

Unnamed: 0 | AEFLA Program Annual Professional Development Summary - FY13 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
 |  | To be completed by the adult education/family literacy program director.
Program Name:  _________________________________ |  |  |  | Date:  ____________________
Completed by:  ________________________________
1.  [NAME] all Teacher's Annual Professional Development Activity Records completed by members of your staff in FY13.
2.  Sort the Records based on teachers' weekly hours related to instruction (see column #1 of table below).
3.  Total the PD Hours earned by teachers within the same range of instruction for each of the PD strands shown
in columns 4-7 below).
4.  Submit completed summary to CDE/AEFL along with your Annual Performance Report (APR).
(1) | (2) | (3) | (4) | (5) | (6) | (7) | (8)
Teachers' weekly hours           related to instruction * | Total AEFL teachers on staff at this level in FY13 | Number of teachers included in this summary | PD Hours earned:           Self-Study | PD Hours earned: Collaboration w/ Colleagues | PD Hours earned: Workshops/ Trainings | PD Hours earned: Courses for Credit | Total PD Hours Earned
2-8 hours per week |  |  |  |  |  |  | 0
9-19 hours per week |  |  |  |  |  |  | 0
20+ hours per week |  |  |  |  |  |  | 0
TOTALS: | 0 | 0 | 0 | 0 | 0 | 0 | 0
Percentage of teachers reporting
*classroom teaching, learner instruction/tutoring,
paid prep time, assessmnt
Spreadsheet: 181424d1348040882-compare-tables-in-excel-0a1_f_discounts-3-
Sheet: Real Discounts

Phone Number | Discount ID
[PHONE] | 53457
[PHONE] | 55402
[PHONE] | 55467
[PHONE] | 56013
[PHONE] | 56026
[PHONE] | 8728
[PHONE] | 8729
[PHONE] | 91193 |  | [PHONE] | 56027
[PHONE] | 53457 |  | [PHONE] | 53457
[PHONE] | 56006 |  | [PHONE] | 56014
[PHONE] | 56013 |  | [PHONE] | 3686
[PHONE] | 56026 |  | [PHONE] | 56003
[PHONE] | 8728 |  | [PHONE] | 56009
[PHONE] | 8729
[PHONE] | 53457
[PHONE] | 56007
[PHONE] | 56013
[PHONE] | 56026
[PHONE] | 56202
[PHONE] | 8728
[PHONE] | 8729
[PHONE] | 53457
[PHONE] | 56006
[PHONE] | 56013
[PHONE] | 56026
[PHONE] | 8728
[PHONE] | 8729
[PHONE] | 53457
[PHONE] | 56007
[PHONE] | 56013
[PHONE] | 56026
[PHONE] | 8728
[PHONE] | 8729
[PHONE] | 53457
[PHONE] | 56004
[PHONE] | 56013
[PHONE] | 56026
[PHONE] | 8728
[PHONE] | 8729
[PHONE] | 53457
[PHONE] | 56004
[PHONE] | 56013
[PHONE] | 56026
[PHONE] | 8728
[PHONE] | 8729
[PHONE] | 51770
[PHONE] | 53457
[PHONE] | 56006
[PHONE] | 56013
[PHONE] | 56026
[PHONE] | 8728
[PHONE] | 8729
[PHONE] | 53457
[PHONE] | 56007
[PHONE] | 56013
[PHONE] | 56026
[PHONE] | 8728
[PHONE] | 8729
[PHONE] | 56006
[PHONE] | 56013
[PHONE] | 56026
[PHONE] | 8728
[PHONE] | 8729
[PHONE] | 53457
[PHONE] | 56007
[PHONE] | 56013
[PHONE] | 56026
[PHONE] | 8728
[PHONE] | 8729
[PHONE] | 56007
[PHONE] | 56013
[PHONE] | 56026
[PHONE] | 8728
[PHONE] | 8729
[PHONE] | 53457
[PHONE] | 56006
[PHONE] | 56013
[PHONE] | 56026
[PHONE] | 8728
[PHONE] | 8729
[PHONE] | 53457
[PHONE] | 56007
[PHONE] | 56013
[PHONE] | 56026
[PHONE] | 8728
[PHONE] | 8729
[PHONE] | 56007
[PHONE] | 56013
[PHONE] | 56026
[PHONE] | 56202
[PHONE] | 8728
[PHONE] | 8729
[PHONE] | 31244
[PHONE] | 31245
[PHONE] | 53457
[PHONE] | 54918
[PHONE] | 56007
[PHONE] | 56013
[PHONE] | 56026
[PHONE] | 56202
[PHONE] | 8728
[PHONE] | 8729
[PHONE] | 53457
[PHONE] | 56004
[PHONE] | 56013
[PHONE] | 56026
[PHONE] | 8728
[PHONE] | 8729
Spreadsheet: 541375d1507246839-make-a-list-from-a-data-base-example
Sheet: data base

Product | Retailer | Brand | Price | date
ketchup | walmart | Heinz | 3 | 2017-07-07 00:00:00
mayonnaise | Carrefour | Hellmann's | 4.67 | 2017-12-12 00:00:00
ketchup | Costco | French's | 4 | 2017-10-02 00:00:00
ketchup | Carrefour | Del Monte | 3.39 | 2017-06-12 00:00:00
mayonnaise | Costco | Kraft | 5.38 | 2017-01-11 00:00:00
ketchup | walmart | Del Monte | 4.12 | 2017-02-04 00:00:00
mayonnaise | Costco | Kraft | 5.59 | 2017-11-05 00:00:00
ketchup | walmart | Heinz | 2.56 | 2017-05-01 00:00:00
Spreadsheet: 31908cb8-bc8c-47d1-b83c-6b035ad31cfd
Sheet: Sheet1

LABEL | UPC | ARTIST | TITLE | RELEASEDATE | PRODUCTTYPE | GENRE | PRICE | [NAME] | STATUS
Third Party Entity Merch | 679143054111 | Son Of God | Son Of God Cross Journal | 2014-01-28 | Misc | Na | 19.99 | Y | Available
Third Party Entity Merch | 679143054128 | Son Of God | Son Of God Notecard Set | 2014-01-28 | Misc | Na | 12.99 | N | Available
Fervent For-Sale Merch | 679143059055 | For King & Country | Black Respect & Honor Bracelet For Retail | 2014-07-06 | Misc | Na | 4.99 | N | Available
Fervent For-Sale Merch | 679143059048 | For King & Country | Australian Coin And Crest Necklace For Retail | 2014-07-06 | Misc | Na | 9.99 | N | Available
Fervent For-Sale Merch | 679143059024 | For King & Country | [NAME]. Live Free. Love Strong. Drumsticks | 2014-07-06 | Misc | Na | 14.99 | N | Available
Fervent For-Sale Merch | 80688751043 | Group 1 Crew | Group 1 Crew Pewter "G1C" Logo Belt Buckle | 2008-01-11 | Misc | Na | 15 | N | Available
Spreadsheet: 725813d1616883771-help-on-adjusting-excel-formula-to-calculate-more-date-sales-ledger-7
Sheet: Customers statement

Current solution calculate 100 record on the sheets. I want it to calculate at least 5000 record on the sheets.
I have tried to adjust the formula but I have failed. Please help me.
 | ST 001
Date | Receipt Number | Invoice Number | Debit | Credit | Cumulative Balance |  |  | Sheet | Row
Desired Outcome
 | ST 001
Date | Receipt Number | Invoice Number | Debit | Credit | Cumulative Balance
2020-01-01 00:00:00 |  | C001 | 400
2020-01-10 00:00:00 |  | 1 | 2000
2020-01-12 00:00:00 | R010 | C001 |  | 300
2020-01-14 00:00:00 | R012 | 3 |  | 1000
2020-05-12 00:00:00 |  | 5 | 2300
2020-09-09 00:00:00 |  | 9 | 2500
Spreadsheet: 213582d1360585052-return-a-1st-2nd-or-3rd-from-row-of-numbers-society-scoring-system-template
Sheet: events list

[NAME] | 2013 order of merit
Newbury & Crookham |  |  |  |  | Am | points | name
Tadmartin |  |  |  |  | 1st
North Oxford |  |  |  |  | 2nd
Southfield(Oxford) |  |  |  |  | 3rd
Northampton |  |  |  |  | PM
Wellingborough |  |  |  |  | 1st
Chipping Norton |  |  |  |  | 2nd
 |  |  |  |  | 3rd
 |  |  |  |  | Am
 |  |  |  |  | 1st
 |  |  |  |  | 2nd
 |  |  |  |  | 3rd
 |  |  |  |  | PM
 |  |  |  |  | 1st
 |  |  |  |  | 2nd
 |  |  |  |  | 3rd
 |  |  |  |  | Am
 |  |  |  |  | 1st
 |  |  |  |  | 2nd
 |  |  |  |  | 3rd
 |  |  |  |  | PM
 |  |  |  |  | 1st
 |  |  |  |  | 2nd
 |  |  |  |  | 3rd
 |  |  |  |  | Am
 |  |  |  |  | 1st
 |  |  |  |  | 2nd
 |  |  |  |  | 3rd
 |  |  |  |  | PM
 |  |  |  |  | 1st
 |  |  |  |  | 2nd
 |  |  |  |  | 3rd
 |  |  |  |  | Am
 |  |  |  |  | 1st
 |  |  |  |  | 2nd
 |  |  |  |  | 3rd
 |  |  |  |  | PM
 |  |  |  |  | 1st
 |  |  |  |  | 2nd
 |  |  |  |  | 3rd
 |  |  |  |  | Am
 |  |  |  |  | 1st
 |  |  |  |  | 2nd
 |  |  |  |  | 3rd
 |  |  |  |  | PM
 |  |  |  |  | 1st
 |  |  |  |  | 2nd
 |  |  |  |  | 3rd
 |  |  |  |  | Am
 |  |  |  |  | 1st
 |  |  |  |  | 2nd
 |  |  |  |  | 3rd
 |  |  |  |  | PM
 |  |  |  |  | 1st
 |  |  |  |  | 2nd
 |  |  |  |  | 3rd
 |  |  |  |  | Am
 |  |  |  |  | 1st
 |  |  |  |  | 2nd
 |  |  |  |  | 3rd
 |  |  |  |  | PM
 |  |  |  |  | 1st
 |  |  |  |  | 2nd
 |  |  |  |  | 3rd
Spreadsheet: 684798d1593539340-auto-fill-function-that-references-another-sheet-autofill-from-list-example
Sheet: Dataset

Ever Growing List | Data1 | Data2 | Data3 | Data4 | Data5
Tesla | Test1 | Test2 | Test3 | Test4 | Test5
Lexus | Test2 | Test3 | Test4 | Test5 | Test6
BMW | Test3 | Test4 | Test5 | Test6 | [NAME]
Nissan | Test4 | Test5 | Test6 | [NAME] | Test8
Audi | Test5 | Test6 | [NAME] | Test8 | Test9
Volvo | Test6 | [NAME] | Test8 | Test9 | Test10
Toyota | [NAME] | Test8 | Test9 | Test10 | Test11
Honda | Test8 | Test9 | Test10 | Test11 | Test12
Bugatti | Test9 | Test10 | Test11 | Test12 | Test13
Ford | Test10 | Test11 | Test12 | Test13 | Test14
Rivian | Test11 | Test12 | Test13 | Test14 | Test15
Citroën | Test12 | Test13 | Test14 | Test15 | Test16
Spreadsheet: 735727d1623153427-countifs-not-working-tried-dfifferent-things-kpi-test2
Sheet: UK Request Type KPIs

 |  |  | NOTE: Enter PRM Ticket no. or if no ticket raised, write: "Query" | NOTE: Select Michaela's name |  | NOTE: Select an option from drop-down menu, and in column R specify what you selected For example, in Column G: If you Selected Market Scope (Amend Existing or Create New) and in Column R: Specify whether you chose Amend Existing or Create New |  |  |  |  | Central Team Use |  | !
 | ID | Date | [NAME] | Owner | Request Type | Request Name | View (Agent / Customer) | Improvement Type | Country | Criteria | KPI | Target |  | KPI - Request Type (Fields) | KPI - Request Type Local Sign Off | Comments | Copy/type in selection manually (click this to refer to list) | Internal Metrics | Ticket closed on | Tester name |  | Customer | Agent | Total | Total tasks
 | 1 |  |  |  | Attribution​ |  | Customer |  |  |  | % completed | 1 |  |  |  |  |  | Change accepted |  |  | No Changes needed
 |  |  |  |  | Client Deliverables​ |  | Customer |  |  |  |  |  |  |  |  |  |  | Change accepted |  |  | Change requested
 |  |  |  |  | Attribution​ |  | Customer |  |  |  |  |  |  |  |  |  |  | No changes needed |  |  | Change accepted
 |  |  |  |  | Client Deliverables​ |  | Customer |  |  |  |  |  |  |  |  |  |  | Change WIP |  |  | Change rejected
 |  |  |  |  | Attribution​ |  | Customer |  |  |  |  |  |  |  |  |  |  | Change WIP |  |  | Change WIP
 |  |  |  |  | Advanced Analytics​ |  | Customer |  |  |  |  |  |  |  |  |  |  | No changes needed |  |  | Total
 |  |  |  |  | Advanced Analytics​ |  | Agent |  |  |  |  |  |  |  |  |  |  | Change requested
Spreadsheet: 709114d1608167437-countif-two-cells-with-same-content-does-not-work-in-this-case-questions-to-ask
Sheet: Sales

 | Store |  | Fruit
 | Selling Date (dd/mm/yyyy) | Batch No. | Fruit | [NAME] | [NAME] on selling date
1 | 2020-12-17 00:00:00
2 | 2020-12-18 00:00:00
3 | 2020-12-19 00:00:00
4 | 2020-12-20 00:00:00
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
401
Spreadsheet: 132693d1323883071-picking-values-from-a-grid-based-on-positions-from-another-grid-example
Sheet: Sheet1

S | P | G | K | H |  |  |  |  |  |  | 3 |  |  |  | 1 | X
F | T | C | B | L |  |  |  |  | 5 |  |  |  |  |  | 2 | P
P | R | G | H | X |  |  |  | 2 |  |  |  | 1 |  |  | 3 | K
E | K | B | N | Z |  |  |  |  |  |  | 4 |  |  |  | 4 | N
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 | T
Spreadsheet: daren_farmer__6365__CES INFO
Sheet: CSGT

Purchase
 | From Spinnaker
 | At Brazos 368 (B368)
 | For IF-.08 for base vols & GDA-.08 for swing vols
 |  | Plus $.18 Transport
Sale
 | To Dow
 | At Cowtrap Facility (864101)
 |  | Operated By Coastal States Gas
 |  | [NAME] States Gas [PHONE]
 | For IF-.07 for base vols & GDA-.07 for swing vols
Term
 | Will be extended per [NAME]
Other
 | CSGT does not require nominations
 | Whatever is produced is allocated to Dow
 | Jan vols are approximately 1233 [NAME]
Deal Numbers
 |  | Jan & Feb | Mar
 | Swing | P - 144271 | 144271
 |  | S - 144273 | 202422
 | Tsp | T - 148795 | 148795
 | Base | P - 144264 | 144264
 |  | S - 144265 | 144265
Spreadsheet: 17b61207-b9ef-4d6a-b100-3c12df70d5dd
Sheet: Total

Export Sales | Unshipped Balance |  | Accumulated Exports |  | Total Commitments
US Total | this year | last year | this year | last year | this year | last year | Next Marketing Year
Spreadsheet: 770646d1646211355-top-5-based-on-two-data-fields-made-up-league
Sheet: Sheet1

 | League |  |  |  |  |  |  | Male | Summary 1 |  |  | Male | Summary 2
 | Name | Gender | Team | Goals |  |  |  |  | Top 3 Males Based on Goals |  |  | Rangers | Top 3 Males who play for Rangers Based on Goals
 | [NAME] | Male | Rangers | 8 |  |  |  |  | 1 |  |  |  | 1
 | [NAME] | Male | United | 9 |  |  |  |  | 2 |  |  |  | 2
 | Clare | Female | Footsville | 10 |  |  |  |  | 3 |  |  |  | 3
 | [NAME] | Male | Rangers | 6
 | [NAME] | Male | Rangers | 4
 | [NAME] | Female | United | 7
 |  |  |  |  |  |  |  |  |  | [NAME] |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  | [NAME] |  |  |  | [NAME]
Spreadsheet: 678748d1590049026-formula-not-calculating-charts
Sheet: WIP Feb 20

 | Daily |  |  | Last day of month |  | Fresh WIP | Aged WIP Level | WIP Level
 |  |  |  | Jan | 350 |  | 111.2 | 400
1 | 716 | 280 |  | Feb | 350 |  | 122.2 | 501
2 | 750 | 280 |  | Mar | 350 |  | 153.5 | 477
3 | 778 | 280 |  | Apr | 350 |  | 83.1 | 249
4 | 721 | 280 |  | May | 350 |  | 67 | 213
5 | 753 | 280 |  | Jun | 350 |  | 66.6 | 275
6 | 768 | 280 |  | Jul | 350 |  | 64.4 | 270
7 | 770 | 280 |  | Aug | 350 |  | 60.496 | 258
8 | 751 | 280 |  | Sept | 350 |  | 49.8 | 330.6
9 | 720 | 280 |  | Oct | 350 |  | 50.3 | 243
10 | 717 | 280 |  | Nov | 350 |  | 60.7 | 332
11 | 723 | 280 |  | Dec | 350 | 179 | 139
12 | 725 | 280 |  | Jan | 350 | 291 | 143 | 434
13 | 666 | 280 |  | Feb | 350 |  | 161 | 446
14 | 676 | 280 |  | Mar | 350 |  | 156 | 483
15 | 681 | 280 |  | Apr | 350 |  | 171 | 414
16 | 671 | 280 |  | May | 350 |  | 162 | 433
17 | 720 | 280 |  | Jun | 350 |  | 174 | 587
18 | 749 | 280 |  | Jul | 350 |  | 147 | 584
19 | 702 | 280 |  | Aug | 350 |  | 130 | 631
20 | 711 | 280 |  | Sep | 350 |  | 197 | 574
21 | 701 | 280 |  | Oct | 350 |  | 185 | 654
22 | 713 | 280 |  | Nov | 350 |  | 257 | 959
23 | 745 | 280 |  | Dec | 350 | 732
24 | 708 | 280 |  | Jan | 280 | 364 | 426 | 791
25 | 642 | 280 |  | Feb | 280 | 161 | 426 | 587
26 | 714 | 280 |  | Mar | 280
27 | 662 | 280 |  | Apr | 280
28 | 619 | 280 |  | May | 280
29 | 587 | 280 |  | June | 280
30 |  | 280 |  | July
31 |  | 280
Total
Spreadsheet: drew_fossum__8677__Fixed3
Sheet: RMTC_2

[NAME]
FUEL HEDGING BOOK
Risk Management & Trading Corp._2
Prod. | Contract | Contract | Fixed |  | Fuel | Settled | Futures | (Gains) and Losses
Date | Number | Name | Price |  | Dth | Price | Price | Total | Realized | Unrealized
 |  |  |  |  |  | El Paso Prmn |  | (4) | (4) | (4)
2000-01-01 00:00:00 |  | RMTC | 2.365 |  |  | 2.19
2000-02-01 00:00:00 |  | RMTC | 2.365 |  |  | 2.41
2000-03-01 00:00:00 |  | RMTC | 2.365 |  |  | 2.41
2000-04-01 00:00:00 |  | RMTC | 2.365 |  |  | 2.79
2000-05-01 00:00:00 |  | RMTC | 2.365 |  |  | 2.87
2000-06-01 00:00:00 |  | RMTC | 2.365 |  |  | 4.1
2000-07-01 00:00:00 |  | RMTC | 2.365 |  |  | 4.35
2000-08-01 00:00:00 |  | RMTC | 2.365 |  |  |  | 3.77
2000-09-01 00:00:00 |  | RMTC | 2.365
2000-10-01 00:00:00 |  | RMTC | 2.365
2000-11-01 00:00:00 |  | RMTC | 2.365
2000-12-01 00:00:00 |  | RMTC | 2.365
 |  |  |  |  |  | TW Index
2000-01-01 00:00:00 |  | Over-retention | 2.365 |  |  | 2.26
2000-02-01 00:00:00 |  | Over-retention | 2.365 |  |  | 2.43
2000-03-01 00:00:00 |  | Over-retention | 2.365 |  |  | 2.64
2000-04-01 00:00:00 |  | Over-retention | 2.365 |  |  | 2.79
2000-05-01 00:00:00 |  | Over-retention | 2.365 |  |  | 3.31
2000-06-01 00:00:00 |  | Over-retention | 2.365 |  |  | 4.09
2000-07-01 00:00:00 |  | Over-retention | 2.365 |  |  | 3.85
2000-08-01 00:00:00 |  | Over-retention | 2.365 |  |  |  | 3.98
2000-09-01 00:00:00 |  | Over-retention | 2.365
2000-10-01 00:00:00 |  | Over-retention | 2.365
2000-11-01 00:00:00 |  | Over-retention | 2.365
2000-12-01 00:00:00 |  | Over-retention | 2.365
(4)Gain and [NAME] are a measurement of the effectiveness of meeting the stated hedge objective.
Spreadsheet: 705734d1606287932-average-last-n-rows-based-on-conditions-example1960
Sheet: Sheet1

Desc | Total | Workings | Divisor | Result
 | 61
 | 31
 | 6
NB | 74
 | 2 | 2+74+6+31+61 | Divide by 4
 | 5 | 5+2+74+6+31 | Divide by 4
NB | 45 | 45+5+2+74+6 | Divide by 3
 | 87 | 87+45+5+2+74 | Divide by 3
 | 6 | 6+87+45+5+2 | Divide by 4
 | 44 | 44+6+87+45+5 | Divide by 4
 | 9 | 9+44+6+87+45 | Divide by 4
DNQ | 0 | 9+44+6+87+45 | Divide by 5
 | 17 | 17+9+44+6+87 | Divide by 5
 | 3 | 3+17+9+44+6 | Divide by 5
DNQ | 0 | 3+17+9+44+6 | Divide by 5
DNQ | 0 | 3+17+9+44+6 | Divide by 5
NB | 1 | 1+3+17+9+44 | Divide by 4
 | 2 | 2+1+3+17+9 | Divide by 4
Spreadsheet: 116674d1311975639-selective-columns-priors-hall
Sheet: Al

Adams. L |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | HANDICAPPING
hole | par | stroke index | adjusted par | pts calc | [NAME] | strokes | points | PAR 3 | INDEX 1 | INDEX 2 | INDEX 3 | adjusted par | pts calc | [NAME] | points | handicap | handicap |  | handicap | catergory | Buffer Zone | css | Nett Differential | adjustment
 |  | 14
 |  | 6 |  |  |  |  |  |  |  |  |  |  |  |  |  | Nett | Nett
 | 4 | 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | points | points
 |  | 18
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | par 3 |  |  | [NAME]
 |  | 10
 |  | 16 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | hole | par | stroke index | strokes | points | penalty
 |  | 11 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | sss | css adj | "RO"
 |  | 15
 |  | 7
 |  | 17
 |  | 13
 |  | 9
in
out
total
Spreadsheet: 770995d1646381512-transposing-multiple-rows-in-columns-for-each-unique-name-in-column-a-excel-transpose-sample
Sheet: Sheet1

STARTING FILE
P/N | Height | REF
000 | 0 | C390 | C401 |  |  |  |  | 0
A003 | 0.6 | R7 | R107 | R145 | R160
A006 | 0.45 | R75 | R149
A010 | 0.7 | R150
A011 | 0.6 | R19 | R25 | R163
A013 | 0.6 | R153 | R154
A015 | 1.2 | R18
A018 | 0.6 | R22
CONVERT TO
P/N | Height | REF |  | P/N | Height | REF
000 | 0 | C390
000 | 0 | C401
A003 | 0.6 | R7
A003 | 0.6 | R107
A003 | 0.6 | R145
A003 | 0.6 | R160
A006 | 0.45 | R75
A006 | 0.45 | R149
A010 | 0.7 | R150
A011 | 0.6 | R19
A011 | 0.6 | R25
A011 | 0.6 | R163
A013 | 0.6 | R153
A013 | 0.6 | R154
A015 | 1.2 | R18
A018 | 0.6 | R22
Spreadsheet: 192334d1352384434-duplicating-values-in-a-column-copy-multiples
Sheet: Sheet1

Original |  | New | Helper
432740093 |  |  | 2
412620001 |  |  | 2
412620002 |  |  | 2
Next 1 |  |  | 2
Next 2 |  |  | 2
Next 3 |  |  | 2
Next 4
Next 5
Next 6
Next 7
Next 8
Spreadsheet: 788107d1658279093-extracting-names-into-respective-columns-name_extraction_sample
Sheet: Sheet1

No. | Example | Prefix | First Name(s) | Nickname | Middle Name(s)/Initial(s) | Surname | Suffix(es)
1 | [NAME] |  | [NAME] |  |  | [NAME]
2 | [NAME] the Magnificent |  | [NAME] |  |  | the Magnificent
3 | [NAME] Stratvert |  | [NAME] |  | [NAME] | [NAME]
4 | [NAME] |  | [NAME] |  |  | [NAME]
5 | [NAME] Stratvert |  | [NAME] |  | [NAME] | [NAME]
6 | [NAME] "Kevkorr" Armstrong Stratvert |  | [NAME] | [NAME] | [NAME] | [NAME]
7 | [NAME] |  | [NAME] |  | [NAME] | [NAME]
8 | [NAME], Jr. |  | [NAME] |  | [NAME] | [NAME] | Jr.
9 | [NAME] |  | [NAME] |  | [NAME] | [NAME]
10 | [NAME], Jr. |  | [NAME] |  | [NAME] | [NAME] | Jr.
11 | [NAME], Jr. |  | [NAME] |  | [NAME] | [NAME] | Jr.
12 | Mr. [NAME] Armstrong Stratvert | Mr. | [NAME] |  | [NAME] | [NAME]
13 | Mr. [NAME] | Mr. | [NAME] |  | A. | [NAME]
14 | Sir [NAME] | Sir | [NAME] |  | A. | [NAME]
15 | The Rt. Hon. [NAME], MP | The Rt. Hon. | [NAME] |  | [NAME] | [NAME] | MP
16 | [NAME]. [NAME], Esq. | [NAME]. | [NAME] |  | [NAME] | [NAME] | Esq.
17 | The Rt. Hon. [NAME], MP [NAME] | The Rt. Hon. | [NAME] |  | [NAME] | [NAME] | MP QC
Spreadsheet: 485854d1477106362-a-challenge-for-all-the-experts-match-formula-1-
Sheet: Match

Item Name
A Little Tail
After Hours
After Party
Beach and Bae
[NAME]
[NAME]
Beside the Point
Bohemian Beach
Bombshell Gold
Bombshell Multi
[NAME]
Catch and Release
Caught Up
Dilly Dallying
Dive In
[NAME]
Get Inky
Get Inky Blue
Get On Board Pink
Gone Coconuts
Goombay Smashed
[NAME]
Hey Bay Bay
I'm So Jelly
Island Seacret
It's Eelectric
Just Swimmingly
Kelp Yourself
Krillin It
Leapin Lizards
Mariposa
Off the Grid
One Too Many
[NAME]
Rock the Dock
Royal Lime
Sand Bar
Sandy Rays
Sea Salt and Sun
Seacret
Shells and Tings Indigo
Shore Thing
Sip Sip
So Snappy
Sparkling Sands
Starstruck
Straw Market
Sun Splashed
Swish Fish
Tippy Top
Spreadsheet: 125447d1319035375-summary-formula-needed-excelexample
Sheet: Sheet1

MRP element | Rec./Reqd Qty
Stock | 1995
Deliv. | -54
Deliv. | -54
Deliv. | -54
Deliv. | -54
Deliv. | -54
Deliv. | -162
Deliv. | -108
Deliv. | -54
Deliv. | -54
Deliv. | -54
Deliv. | -54
[NAME] | 1242
Spreadsheet: 806242d1669187835-finding-out-if-order-time-is-beyond-or-within-the-shift-using-excel-formula-sample
Sheet: sample

 | Date Ordered | Start Shift | End Shift | Time Ordered | Remarks
 | 2022-11-03 00:00:00 | 05:48:07 | 16:07:38 | 06:26:00
 | 2022-11-03 00:00:00 | 05:48:07 | 16:07:38 | 12:08:00
 | 2022-11-04 00:00:00 | 05:40:35 | 16:02:02 | 09:56:00
 | 2022-11-04 00:00:00 | 05:40:35 | 16:02:02 | 14:10:00
 | 2022-11-11 00:00:00 | 20:00:39 | 6:37:15 am | 1:10:00 am
 | 2022-11-11 00:00:00 | 20:00:39 | 6:37:15 am | 03:31:00
 | 2022-11-12 00:00:00 | 20:01:16 | 06:33:10 | 23:07:00
 | 2022-11-13 00:00:00 | 19:55:40 | 06:21:48 | 23:19:00
 | 2022-11-13 00:00:00 | 19:55:40 | 06:21:48 | 03:30:00
 | 2022-11-14 00:00:00 | 13:46:31 | 22:11:19 | 17:28:00
Spreadsheet: 798066d1664289104-date-comparison-with-blank-cells-help-3-
Sheet: Sheet1

[NAME] | Plan sch ship dt | OTD | Expected Answers
 | 2022-09-22 00:00:00 |  | Late
2022-09-22 00:00:00 | 2022-09-29 00:00:00 |  | On Time
 | 2022-09-30 00:00:00 |  | On Time
 | 2022-09-22 00:00:00 |  | Late
2022-09-06 00:00:00 | 2022-09-06 00:00:00 |  | On Time