tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 809343d1671037806-converting-table-of-data-into-a-list-sample
Sheet: Sheet1

 |  |  | Dept |  |  |  |  |  | output |  |  |  | final
 |  |  | 100 | 200 | 300
 | Expense | 70350 | 157 | 927 | 37 |  |  | 100 | 70350 | 157 |  |  |  |  |  |  | 157
 |  | 70360 | 352 | 65 | 469 |  |  | 100 | 70360 | 352 |  |  |  |  |  | 100-70360 | 352
 |  | 70390 | 923 | 812 | 225 |  |  | 100 | 70390 | 923 |  |  |  |  |  | 100-70390 | 923
 |  |  |  |  |  |  |  | 200 | 70350 | 927 |  |  |  |  |  | 200-70350 | 927
 |  |  |  |  |  |  |  | 200 | 70360 | 65 |  |  |  |  |  | 200-70360 | 65
 |  |  |  |  |  |  |  | 200 | 70390 | 812 |  |  |  |  |  | 200-70390 | 812
 |  |  |  |  |  |  |  | 300 | 70350 | 37 |  |  |  |  |  | 300-70350 | 37
 |  |  |  |  |  |  |  | 300 | 70360 | 469 |  |  |  |  |  | 300-70360 | 469
 |  |  |  |  |  |  |  | 300 | 70390 | 225 |  |  |  |  |  | 300-70390 | 225
Spreadsheet: 116133d1311618121-help-for-countif-function-book1
Sheet: Sheet1

2011-07-25 00:00:00
Student | DOB | Age |  |  | Row Labels | Count of Age
a | 1984-11-25 00:00:00 | 26 |  |  | 10-19 | 8
b | 1987-04-04 00:00:00 | 24 |  |  | 20-29 | 7
c | 1987-11-17 00:00:00 | 23 |  |  | 30-39 | 3
d | 1985-05-30 00:00:00 | 26 |  |  | 40-49 | 5
e | 1958-10-08 00:00:00 | 52 |  |  | 50-60 | 6
f | 1957-02-12 00:00:00 | 54 |  |  | Grand Total | 29
g | 1967-08-16 00:00:00 | 43
h | 1967-12-24 00:00:00 | 43
i | 1993-05-01 00:00:00 | 18
j | 1967-01-05 00:00:00 | 44
k | 1962-12-31 00:00:00 | 48
l | 1989-04-12 00:00:00 | 22
m | 1992-10-25 00:00:00 | 18
n | 1955-08-11 00:00:00 | 55
o | 1976-05-07 00:00:00 | 35
p | 1976-07-22 00:00:00 | 35
q | 1998-05-19 00:00:00 | 13
r | 1952-08-14 00:00:00 | 58
s | 1998-04-10 00:00:00 | 13
t | 1992-01-30 00:00:00 | 19
u | 1970-11-24 00:00:00 | 40
v | 1999-02-08 00:00:00 | 12
w | 1995-04-26 00:00:00 | 16
x | 1951-01-10 00:00:00 | 60
y | 1985-01-30 00:00:00 | 26
z | 1985-07-23 00:00:00 | 26
aa | 1953-01-23 00:00:00 | 58
ab | 1978-06-04 00:00:00 | 33
ac | 1994-06-29 00:00:00 | 17
Spreadsheet: 795278d1662599306-need-help-to-find-a-formula-to-repeat-a-previous-value-until-there-there-is-new-value-help-in-formula-hd
Sheet: Sheet1

 | Year | Month | Name | Science Score | [NAME] to display
 | 2022 | Jan | [NAME] | 90
 | 2022 | Feb | [NAME]
 | 2022 | March | [NAME]
 | 2022 | March | Mark | 75
 | 2022 | April | Mark
 | 2022 | April | [NAME] | 50
 | 2022 | May | Mark
 | 2022 | May | [NAME]
 | 2022 | Jun | Mark | 60
 | 2022 | Jun | [NAME]
 | 2022 | July | Mark
 | 2022 | Aug | Mark
Spreadsheet: 180039d1347463466-leader-board-lookup-mick-score-sheet
Sheet: Special Tech

 | SPECIAL TECH
 | Teams | Special Tech 1 | Special Tech 2 | Special Tech 3 | Special Tech 4 | Special Tech 5 | Special Tech 6 |  | TOTAL
 | IRISH ITF | 10
 | GASSOR TKD WALES | 15
 | EAST COAST TKD
 | BANNER MARTIAL ARTS
Spreadsheet: 86825d1286803128-pivot-calculated-fields-book1
Sheet: Budgeted vs Projected

 | MOS2 | Amount | [NAME]
 | 01-Budget | 650 | 510
 | PROJECTED | 200 | 511
 | 01-Budget | 300 | 588
 | PROJECTED | 400 | 510 |  |  |  |  |  |  |  |  | Remaining (Lapse)
 | 01-Budget | 500 | 511 |  |  |  |  |  |  |  |  |  |  |  |  | -1011
 | PROJECTED | 50 | 588
 |  |  | MOS2
 | [NAME] | Data | 01-Budget | PROJECTED | Grand Total
 | 510 | Sum of Amount | 650 | 400 | 1050
 |  | Sum of Diff | #N/A | #N/A | #N/A
 | 511 | Sum of Amount | 500 | 200 | 700
 |  | Sum of Diff | #N/A | #N/A | #N/A
 | 588 | Sum of Amount | 300 | 50 | 350
 |  | Sum of Diff | #N/A | #N/A | #N/A
 | Total Sum of Amount |  | 1450 | 650 | 2100
 | Total Sum of Diff |  | #N/A | #N/A | #N/A
Spreadsheet: 699881d1602806796-need-help-with-adding-two-more-columns-assessment-tracker
Sheet: Cover Page

Teacher:
Course Title:
Course Code:
 |  | Assessments |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Summative |  |  | Current Grades |  | [NAME] |  | Course Median
Students
 | Expectations
Spreadsheet: 7703443b-eb06-4d34-a046-064e59b46de3
Sheet: Sheet1

[NAME] ([NAME] MIL-03) Utilice este formulario para todos los ingredientes y productos adquiridos fuera de la empresa que se usen en los productos que van a ser certificados.  Sírvase utilizar una hoja de cálculo para incluir TODOS los productos para los cuales se solicita la certificación.  Esta primera planilla se utiliza sólo [NAME] la lista de los ingredientes orgánicos.  [NAME] click en el tabulador que se encuentra en la parte inferior [NAME] [NAME] la lista de los ingredientes no orgánicos y [NAME] proceso.  El espacio donde aparece la fecha de expedición del certificado aparecerá en color rojo si la fecha de control del certificado no está vigente. | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10
Ingredientes Orgánicos
Fecha de Revisión
Nombre del Ingrediente Orgánico | Procedencia/Vendedor | Cumplimiento con la Normativa Internacional (Marque con una X) |  |  |  |  | Porcentaje del Contenido [NAME] Ingredientes | Agente Certificador del Ingrediente | Fecha del Control Anual del Certificado | [NAME] (Marque con una X)
 |  | UE | Canadá (COR) | [NAME] | NSF/ANSI 305 | Japón
Spreadsheet: e4c24b27-f608-477e-8914-bdfce8c5a731
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | BIKE | T2 | RUN.1 | POSITION | TOTAL TIME
259060 | 42150 | [NAME] | Nieuwoudt | RSA |  | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:20:20 | 1 | 02:16:14
259060 | 42157 | [NAME] | [NAME] | RSA |  | 00:37:11 | 00:00:00 | [NAME] | 00:00:00 | 00:19:06 | 2 | [NAME]
259060 | 51802 | Bronwyn | [NAME] | RSA |  | 00:42:07 | 00:00:00 | 01:23:37 | 00:00:00 | 00:23:37 | 3 | [NAME]
Spreadsheet: 752931d1635106598-lf-formula-to-display-a-price-dependent-of-the-date-updatedprice
Sheet: PRICES

PRODUCT ID | [NAME] | EFFECTIVE FROM DATE | Purchasing UoM | PARTNER / VENDOR | PURCHASE PRICE
BOX006 | Box 31 Blue(picnic Pack) | 2018-10-11 00:00:00 | EA | International Paper | 0.96941
BOX006 | Box 31 Blue(picnic Pack) | 2020-05-05 00:00:00 | EA | Neway Packaging Corp | 0.87
BOX006 | Box 31 Blue(picnic Pack) | 2020-12-22 00:00:00 | EA | Neway Packaging Corp | 0.95
BOX006 | Box 31 Blue(picnic Pack) | 2021-03-02 00:00:00 | EA | International Paper | 1.047
BOX006 | Box 31 Blue(picnic Pack) | 2021-05-06 00:00:00 | EA | Neway Packaging Corp | 1.047
BOX006 | Box 31 Blue(picnic Pack) | 2021-07-01 00:00:00 | EA | International Paper | 1.125
BOX006 | Box 31 Blue(picnic Pack) | 2021-09-08 00:00:00 | EA | Neway Packaging Corp | 1.27
BOX006 | Box 31 Blue(picnic Pack) | 2021-10-01 00:00:00 | EA | Neway Packaging Corp | 1.4
BOX006 | Box 31 Blue(picnic Pack) | 2021-11-10 00:00:00 | EA | Neway Packaging Corp | 1.48
BOX006 | Box 31 Blue(picnic Pack) | 2021-11-28 00:00:00 | EA | Neway Packaging Corp | 1.58
Spreadsheet: 764870d1643045921-index-match-with-3-criteria-returns-n-a-example
Sheet: ZSS_ANALYSIS_PATTERN

Supplier Demands
Material |  | Unit of measure | Calendar Year/Week | 04/2022 | 05/2022 | 06/2022 | 07/2022 | 08/2022 | 09/2022 | 10/2022 | 11/2022 | 12/2022 | 13/2022 | 14/2022 | 15/2022 | 16/2022 | 17/2022 | 18/2022 | 19/2022 | 20/2022 | 21/2022 | 22/2022 | 23/2022 | 24/2022 | 25/2022 | 26/2022 | 27/2022 | 28/2022 | 29/2022 | 30/2022 | 31/2022 | 32/2022 | 33/2022 | 34/2022 | 35/2022 | 37/2022 | 38/2022 | 39/2022 | 41/2022 | 43/2022 | 47/2022 | 01/2023 | 02/2023 | Overall Result
4450 | ARM - RSF, URETHANE, CHORD | Piece | On-Hand Stock | 157 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 157
4450 | ARM - RSF, URETHANE, CHORD | Piece | Actual Requirements | -13 | -31 | -13 | -21 | -4 | -1 |  | -8 |  | -32 | -22 | -6 |  |  | -26 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -177
4450 | ARM - RSF, URETHANE, CHORD | Piece | Open Orders |  | 80 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 80
Spreadsheet: 766427d1643893014-summing-data-based-on-one-criteria-that-could-be-found-in-multiple-columns-supplier-data-set
Sheet: Sheet1

 | Raw data from survey |  |  |  |  |  |  |  |  |  |  |  |  | My List |  | Goal
 | Team 1 - Supplier 1 | Team 1 - Supplier 2 | Team 1 - Supplier 3 | Team 1 - Supplier 4 | Team 1 - Supplier 5 | Question 1 Answer | Team 2 - Supplier 6 | Team 2 - Supplier 7 | Team 2 - Supplier 8 | Team 2 - Supplier 9 | Team 2 - Supplier 10 | Question 1 Answer |  | [NAME] |  | [NAME] | Average Score
 |  | Supplier 2 |  |  |  | 1 - Good |  |  |  |  |  |  |  | Supplier 1 |  | Supplier 1 | 1
 |  |  | Supplier 3 |  |  | 3 - Bad |  |  |  |  |  |  |  | Supplier 2 |  | Supplier 2 | 2
 |  | Supplier 2 |  |  |  | 3 - Bad |  |  |  |  |  |  |  | Supplier 3 |  | Supplier 3 | 2.5
 | Supplier 1 |  |  |  |  | 1 - Good |  |  |  |  |  |  |  | Supplier 4 |  | Supplier 4 | 2
 |  |  | Supplier 3 |  |  | 2 - Average |  |  |  |  |  |  |  | Supplier 5 |  | Supplier 5 | 1
 |  |  |  |  | Supplier 5 | 1 - Good |  |  |  |  |  |  |  | Supplier 6 |  | Supplier 6 | 2
 |  |  |  | Supplier 4 |  | 2 - Average |  |  |  |  |  |  |  | Supplier 7 |  | Supplier 7 | 3
 |  |  |  |  |  |  |  |  | Supplier 8 |  |  | 1 - Good |  | Supplier 8 |  | Supplier 8 | 1.5
 |  |  |  |  |  |  |  |  |  | Supplier 9 |  | 2 - Average |  | Supplier 9 |  | Supplier 9 | 2.33
 |  |  |  |  |  |  |  | Supplier 7 |  |  |  | 3 - Bad |  | Supplier 10 |  | Supplier 10 | 1
 |  |  |  |  |  |  | Supplier 6 |  |  |  |  | 1 - Good
 |  |  |  |  |  |  | Supplier 6 |  |  |  |  | 3 - Bad
 |  |  |  |  |  |  |  |  | Supplier 8 |  |  | 2 - Average
 |  |  |  |  |  |  |  |  |  | Supplier 9 |  | 2 - Average
 |  |  |  |  |  |  |  |  |  | Supplier 9 |  | 3 - Bad
 |  |  |  |  |  |  |  |  |  |  | Supplier 10 | 1 - Good
 | How do I achieve this? My goal is to set something up to be able to run every month? I have attempted vlookups, and index match functions, but no luck
Spreadsheet: 272327d1382359351-linear-interpolation-help-testforum
Sheet: MID-SWAP Curve

YEAR | MID-SWAP CURVE | Date
2022-03-24 00:00:00 |  |  | LAST_PRICE | DAYS_TO_MTY_TDY
1 | EUSA1 ICPL Curncy |  |  |  |  |  |  | I want to calculate the LAST_PRICE of A2
2 | [NAME] Curncy
3 | EUSA3 ICPL Curncy
4 | EUSA4 ICPL Curncy
5 | EUSA5 ICPL Curncy
6 | [NAME] Curncy
7 | [NAME] Curncy
8 | EUSA8 ICPL Curncy
9 | EUSA9 ICPL Curncy
10 | EUSA10 ICPL Curncy
11 | EUSA11 ICPL Curncy
12 | EUSA12 ICPL Curncy
13 | [NAME] Curncy
14 | EUSA14 ICPL Curncy
15 | EUSA15 ICPL Curncy
16 | EUSA16 ICPL Curncy
17 | EUSA17 ICPL Curncy
18 | EUSA18 ICPL Curncy
19 | EUSA19 ICPL Curncy
20 | EUSA20 ICPL Curncy
21 | EUSA21 ICPL Curncy
22 | EUSA22 ICPL Curncy
23 | EUSA23 ICPL Curncy
24 | EUSA24 ICPL Curncy
25 | EUSA25 ICPL Curncy
26 | EUSA26 ICPL Curncy
27 | EUSA27 ICPL Curncy
28 | EUSA28 ICPL Curncy
29 | EUSA29 ICPL Curncy
30 | EUSA30 ICPL Curncy
35 | EUSA35 ICPL Curncy
40 | EUSA40 ICPL Curncy
50 | EUSA50 ICPL Curncy
60 | EUSA60 ICPL Curncy
Spreadsheet: 792126d1660746121-check-tab-not-checking-out-help
Sheet: SOUTHERN

 | GULF |  |  | MIDSOUTH |  |  | SOUTH ATLANTIC |  |  | SOUTH FLORIDA/PR |  |  | SOUTHEAST |  |  | SOUTHWEST |  |  | TOTAL SOUTH |  |  |  | Check
EVENT NAME | Q3 | Q4 | 2H | Q3 | Q4 | 2H | Q3 | Q4 | 2H | Q3 | Q4 | 2H | Q3 | Q4 | 2H | Q3 | Q4 | 2H | Q3 | Q4 | 2H |  | Q3 | Q4 | 2H
CEILING FANS
SPRING GIFT CENTER
OUTDOOR CLEANING TRAIN
GRILL EVENT
Q2 SPECIAL BUYS
SUMMER PAINT EVENT
HURRICANE TRAIN
POWER TRAIN WAVE 3
TOOL DAYS
BACK TO CAMPUS
BRUSHFIRE AND BLACKOUT TRAIN
Q2 CLEANING TRAIN
POWER TRAIN WAVE 4
Q3 SPECIAL BUYS
SUMMER CLEANING TRAIN
SUMMER STORAGE
GARAGE STORAGE
BATTERY TRAIN
SUMMER BATH
HEATED GEAR AND WORKWEAR
LABOR DAY PAINT
HALLOWEEN
HALLOWEEN HOOKUP
FIRE & SAFETY
POWER TRAIN WAVE 5
FALL CLEANUP
HOLIDAY HOOKUP
DECO HOLIDAY
HOLIDAY SPECIAL BUYS
[NAME]
SMART HOME TRAIN
WINTER STORAGE
Q4 TOOL STORAGE
2023 Q1 EVENTS
TOTAL EVENTS
MAP
OFF-SHELF TOTAL
Spreadsheet: louise_kitchen__22585__Unpaid Accruals
Sheet: Sheet1

BRIDGELINE HOLDINGS
SUMMARY OF UNPAID ACCRUALS
AS OF SEPTEMBER 30, 2001
Description |  | Parent |  | Months |  | Amount
2000 Target Bonus |  | Enron
2000 Rent for 3AC 4400 |  | Enron |  | 4 |  | 31146.27
2000 Excess Liability Insurance |  | Enron |  | 10 |  | 15852
2001 Excess Liability Insurance |  | Enron |  | 9 |  | 14805
2000 Liability Insurance |  | Enron |  | 10 |  | 20420
2001 Liability Insurance |  | Enron |  | 9
2000 Property Insurance |  | Enron |  | 10 |  | 25500
2001 Property Insurance |  | Enron |  | 9 |  | 24093
Dow Lease |  | Enron |  | 6 |  | 306700.04
2001 Excess Liability Insurance |  | Texaco |  | 9 |  | 36149.45
2000 Ad Valorem Taxes |  | Texaco |  | 10 |  | 692245.6
2001 Ad Valorem Taxes |  | Texaco |  | 9 |  | 1568250.47
2001 Fuel Use Tax |  | Texaco |  | 9 |  | 115498.88
2001 Sales  Tax |  | Texaco |  | 9 |  | 4952289.16
Spreadsheet: 681281d1591449377-help-with-automatically-populating-cells-example
Sheet: Daily

 | Under 2
 | Monday |  | Tuesday |  | Wednesday |  | Thursday |  | Friday
 | AM | PM | AM | PM | AM | PM | AM | PM | AM | PM
 | 2 Year Old
 | Monday |  | Tuesday |  | Wednesday |  | Thursday |  | Friday
 | AM | PM | AM | PM | AM | PM | AM | PM | AM | PM
 | 3 Years +
 | Monday |  | Tuesday |  | Wednesday |  | Thursday |  | Friday
 | AM | PM | AM | PM | AM | PM | AM | PM | AM | PM
Spreadsheet: 180590d1347648091-macro-for-copy-and-pasting-duplicates-sample
Sheet: Len

Survey# | Question | Response
51 | [NAME] | Steen
52 | [NAME] | Steen
53 | [NAME] | Steen
54 | [NAME] | Steen
55 | [NAME] | Steen
56 | [NAME] | Steen
57 | [NAME] | Steen
58 | [NAME] | Steen
59 | [NAME] | Steen
60 | [NAME] | Steen
61 | [NAME] | Steen
62 | [NAME] | Steen
63 | [NAME] | Steen
64 | [NAME] | Steen
65 | [NAME] | Steen
 | expected outcome
Spreadsheet: 192084d1352303402-is-there-such-a-thing-as-auto-filter-or-a-workaround-that-will-do-the-following-deal-log
Sheet: DUKE

 | 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: 727744d1618068939-updating-index-function-mealplan-aligw
Sheet: Spinach Feta Pizza

 |  | Spinach Feta Pizza |  |  | Main Course | Recipe Index
 |  | Amount | Measurement | Ingredient | Directions | Preparation Time
 |  | 2 | Tablespoons | olive or canola oil | In bread machine, place the first five ingredients in order suggested by manufacturer.   Select dough setting.  Check dough after 5 minutes of mixing: add 1 to 2 tablespoons of water or flour if needed.   When cycle is complete, turn dough out onto a lightly floured surface. Knead for 1 minute.   Cover and let rest for 15 minutes.   Roll out and place on a 12-inch pizza tray. Cover and let rise in a warm place until puffed, about 20 minutes.   Sprinkle with garlic and garlic salt. Top with spinach, onion, mushrooms, cheeses and basil.   [NAME] at 200 degrees C for 35-40 minutes or until crust is golden and cheese is melted.   Let stand for 5 minutes before slicing. | 45 Minutes
 |  | 1/2 | Teaspoon | salt
 | Calories | 250 | g | bread flour
 | 287 | 2 | Teaspoons | active dry yeast |  | Cook Time
 |  | 3/4 | Cup | warm water |  | 15 Minutes
 | Recipe Tags | 1 | Clove | minced garlic
 | pizza, spinach, feta, cheese | 1/8 | Teaspoon | [NAME]
 |  | 250 | g | chopped fresh spinach |  | Yield (Servings)
 | Comments | 1 | Small | red onion |  | 6 Servings
 | Family enjoyed this recipe. Must make it again! | 1 | Cup | sliced fresh mushrooms
 |  | 1 | Cup | shredded mozzarella cheese
 |  | 1/4 | Cup | crumbled feta cheese
 |  | 1/2 | Teaspoon | dried basil
Spreadsheet: 686460d1594644823-identifying-top-vendors-who-contribute-to-refunds-and-top-70-items-for-refunds-power-pivot-sample-data
Sheet: Main Sheet 

itemid | [NAME] | TicketReason | Refunds
6825 | sirsara | Backorder | 210
2565 | silocha | Pre-Sell | 4500
2678 | vimosa | Order Issues | 3383
4748 | silocha | Buyer's Remorse | 2062
5336 | dconcr | Order Issues | 4625
3628 | silocha | Pre-Sell | 3392
4750 | vimosa | Order Issues | 5785
8004 | silocha | Pre-Sell | 3374
8570 | vimosa | Backorder | 2915
3856 | lilosale | Backorder | 6762
8094 | silocha | Pre-Sell | 5849
6566 | sirsara | Backorder | 5856
5635 | vimosa | Order Issues | 4758
1886 | circarch | Order Issues | 3251
3239 | nidos | Chargeback | 5427
7639 | sirsara | Backorder | 6067
3811 | sirsara | Backorder | 2091
3571 | sirsara | Backorder | 5001
8839 | vimosa | Backorder | 5456
2783 | Furinno | Order Issues | 2816
2478 | circarch | Backorder | 2718
8118 | silocha | Pre-Sell | 4442
1944 | vimosa | Buyer's Remorse | 1179
5882 | glytic | Buyer's Remorse | 5300
957 | vimosa | Buyer's Remorse | 1077
2369 | sirsara | Backorder | 5140
4771 | dinos | Order Issues | 4784
6549 | sirsara | Backorder | 6898
6191 | vimosa | Buyer's Remorse | 1047
4959 | vimosa | Pre-Sell | 2090
6587 | vimosa | Order Issues | 1527
6331 | vimosa | Order Issues | 4039
4014 | vimosa | Order Issues | 1340
6603 | Furinno | Order Issues | 2557
6675 | [NAME] | Pre-Sell | 1713
8913 | vimosa | Pre-Sell | 2515
1705 | vimosa | Pre-Sell | 3444
7213 | vimosa | Pre-Sell | 5536
6849 | vimosa | Pre-Sell | 6578
8047 | vimosa | Pre-Sell | 2549
5090 | simsa | Pre-Sell | 5765
1218 | vimosa | Pre-Sell | 5977
3507 | vimosa | Pre-Sell | 1517
2991 | vimosa | Pre-Sell | 5622
3190 | vimosa | Pre-Sell | 5237
2196 | vimosa | Pre-Sell | 5033
6900 | vimosa | Pre-Sell | 3266
3079 | vimosa | Pre-Sell | 4776
8361 | vimosa | Pre-Sell | 1000
7475 | vimosa | Pre-Sell | 6808
Spreadsheet: 858867d1707379371-iferror-if-and-lookup-automated-v9-copy-aligw
Sheet: Sheet1

Name & Surname:
 |  | Credits | Status | Remark |  |  | AliGW
CHEM181 | Chemistry for Engineers 1A | 8
ENCH1TC | Technical Communication for Engineers | 8
ENME1DR | Engineering Drawing | 8
MATH131 | Mathematics 1A (Eng) | 16 |  |  |  | Why is this returning [NAME]? Because the LOOKUPS separately are finding different rows, so it won't work.
MATH132 | Applied Mathematics 1A (Eng) | 16
PHYS151 | Engineering Physics 1A | 16 |  |  |  | Student failed, repeated and didn't pass yet. So this is fine
ENCV1WP | Engineering Workshop | DP |  |  |  | Student has not studied this module; So this is fine)
Spreadsheet: 813965d1674075565-selecting-the-nearest-static-location-weather-station-for-a-list-of-gps-tracker-points-gps_weather_sample_data
Sheet: Jerez Weather

Station name | Latitude | Longitude | dt_iso | Date_Time | T_Min (C) | [NAME] (C) | Pressure (hPa) | Humidity (%) | Wind_Speed (m/s) | Wind_Deg (˚) | [NAME]) | Clouds (%)
[NAME] | 36.685006 | -6.126074 | 2020-06-05 06:00:00 +0000 UTC |  | 19.2 | 21 | 1015 | 94 | 2.6 | 210 |  | 75
[NAME] | 36.685006 | -6.126074 | 2020-06-05 07:00:00 +0000 UTC |  | 19.44 | 21.67 | 941 | 88 | 4.1 | 220 |  | 75
[NAME] | 36.685006 | -6.126074 | 2020-06-05 08:00:00 +0000 UTC |  | 21.12 | 22.67 | 925 | 78 | 3.6 | 210 |  | 40
[NAME] | 36.685006 | -6.126074 | 2020-06-05 09:00:00 +0000 UTC |  | 21.51 | 24 | 942 | 69 | 4.6 | 210 |  | 75
[NAME] | 36.685006 | -6.126074 | 2020-06-05 10:00:00 +0000 UTC |  | 21.67 | 25.13 | 942 | 61 | 4.1 | 230 |  | 40
[NAME] | 36.685006 | -6.126074 | 2020-06-05 11:00:00 +0000 UTC |  | 21.67 | 26 | 942 | 57 | 5.1 | 220 |  | 75
[NAME] | 36.685006 | -6.126074 | 2020-06-05 12:00:00 +0000 UTC |  | 21.67 | 25.94 | 940 | 57 | 4.6 | 240 |  | 75
[NAME] | 36.685006 | -6.126074 | 2020-06-05 13:00:00 +0000 UTC |  | 21.67 | 26.09 | 942 | 57 | 5.7 | 230 |  | 40
[NAME] | 36.685006 | -6.126074 | 2020-06-05 14:00:00 +0000 UTC |  | 21.67 | 26.17 | 942 | 57 | 5.7 | 230 |  | 40
[NAME] | 36.685006 | -6.126074 | 2020-06-05 15:00:00 +0000 UTC |  | 21.67 | 26 | 942 | 57 | 5.7 | 230 |  | 40
Spreadsheet: 863096d1710665450-rearranging-data-based-on-dates-data-rearrange-version-2
Sheet: Sheet1

 | ID | Month | Plan | Actual |  | ID | Plan | Actual |  |  | Plan | Actual
 | A01 | 2024-01-01 00:00:00 | 8 | 5 |  | A01 | 2024-01-01 00:00:00 | 2024-01-01 00:00:00 |  | A01 | 2024-01-01 00:00:00 | 2024-01-01 00:00:00
 | A02 | 2024-02-01 00:00:00 | 4 | 7 |  | A01 | 2024-01-01 00:00:00 | No Actual |  | A01 | 2024-01-01 00:00:00 | 2024-01-01 00:00:00
 | A03 | 2024-03-01 00:00:00 | 0 | 2 |  | A02 | 2024-02-01 00:00:00 | 2024-02-01 00:00:00 |  | A01 | 2024-01-01 00:00:00 | 2024-01-01 00:00:00
 | A04 | 2024-04-01 00:00:00 | 1 | 3 |  | A02 | No Plan | 2024-02-01 00:00:00 |  | A01 | 2024-01-01 00:00:00 | 2024-01-01 00:00:00
 |  |  |  |  |  | A03 | 2024-03-01 00:00:00 | No Actual |  | A01 | 2024-01-01 00:00:00 | 2024-01-01 00:00:00
 |  |  |  |  |  | A04 | No Plan | 2024-04-01 00:00:00 |  | A01 | 2024-01-01 00:00:00 | No Actual
 |  |  |  |  |  |  |  |  |  | A01 | 2024-01-01 00:00:00 | No Actual
 |  |  |  |  |  |  |  |  |  | A01 | 2024-01-01 00:00:00 | No Actual
 |  |  |  |  |  |  |  |  |  | A02 | 2024-02-01 00:00:00 | 2024-02-01 00:00:00
 |  |  |  |  |  |  |  |  |  | A02 | 2024-02-01 00:00:00 | 2024-02-01 00:00:00
 |  |  |  |  |  |  |  |  |  | A02 | 2024-02-01 00:00:00 | 2024-02-01 00:00:00
 |  |  |  |  |  |  |  |  |  | A02 | 2024-02-01 00:00:00 | 2024-02-01 00:00:00
 |  |  |  |  |  |  |  |  |  | A02 | No Plan | 2024-02-01 00:00:00
 |  |  |  |  |  |  |  |  |  | A02 | No Plan | 2024-02-01 00:00:00
 |  |  |  |  |  |  |  |  |  | A02 | No Plan | 2024-02-01 00:00:00
 |  |  |  |  |  |  |  |  |  | A03 | No Plan | 2024-03-01 00:00:00
 |  |  |  |  |  |  |  |  |  | A03 | No Plan | 2024-03-01 00:00:00
 |  |  |  |  |  |  |  |  |  | A04 | 2024-04-01 00:00:00 | 2024-04-01 00:00:00
 |  |  |  |  |  |  |  |  |  | A04 | No Plan | 2024-04-01 00:00:00
 |  |  |  |  |  |  |  |  |  | A04 | No Plan | 2024-04-01 00:00:00
Spreadsheet: 151645d1335035851-pulling-data-from-one-sheet-to-another-that-meets-certain-criteria-camp-sign-up-spreadsheet-1-
Sheet: Extreme Week 1

 | Name
Spreadsheet: 832398d1686310129-formula-for-getting-all-names-just-once-wether-they-are-duplicate-of-unique-requied-formula
Sheet: Sheet2

Day | District | Facility Name
 |  |  |  |  | Sample  result