tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 827846d1683063389-need-help-adding-to-an-existing-formula-23-pallet-log-pallet-test
Sheet: Pallet Log

 | # |  | XXXXXXXXXXXX | xxxxxxxxxx | P |  |  | 1 | 5 |  |  |  |  |  | If Column I
 | # |  | XXXXXXXXXXXX | xxxxxxxxxx | P |  |  | 1 | 10 |  |  |  |  |  | is an odd value
 | # |  | XXXXXXXXXXXX | xxxxxxxxxx | P |  |  | 1 | 15 |  |  |  |  |  | add 1 only to "O"
 | # |  | XXXXXXXXXXXX | xxxxxxxxxx | P |  |  | 1 | 20 |  |  |  |  |  | when "K is  50
 | # |  | XXXXXXXXXXXX | xxxxxxxxxx | P |  |  | 1 | 25 |  |  |  |  |  | & under
 | # |  | XXXXXXXXXXXX | xxxxxxxxxx | P |  |  | 1 | 26
 | # |  | XXXXXXXXXXXX | xxxxxxxxxx | P |  |  | 1 | 27
 | # |  | XXXXXXXXXXXX | xxxxxxxxxx | P |  |  | 1 | 28
 | # |  | XXXXXXXXXXXX | xxxxxxxxxx | P |  |  | 2 | 5
 | # |  | XXXXXXXXXXXX | xxxxxxxxxx | P |  |  | 2 | 10
 | # |  | XXXXXXXXXXXX | xxxxxxxxxx | P |  |  | 2 | 15
 | # |  | XXXXXXXXXXXX | xxxxxxxxxx | P |  |  | 2 | 20
 | # |  | XXXXXXXXXXXX | xxxxxxxxxx | P |  |  | 2 | 25
 | # |  | XXXXXXXXXXXX | xxxxxxxxxx | P |  |  | 2 | 26 |  |  |  |  |  | If Column I
 | # |  | XXXXXXXXXXXX | xxxxxxxxxx | P |  |  | 2 | 27 |  |  |  |  |  | is an even value
 | # |  | XXXXXXXXXXXX | xxxxxxxxxx | P |  |  | 2 | 28 |  |  |  |  |  | add 1 only to "O"
 | # |  | XXXXXXXXXXXX | xxxxxxxxxx | P |  |  | 2 | 29 |  |  |  |  |  | when "K" is 51
 | # |  | XXXXXXXXXXXX | xxxxxxxxxx | P |  |  | 2 | 30 |  |  |  |  |  | or more
Spreadsheet: 778073d1650844807-return-sorted-unique-values-from-2-columns-using-functions-return-unique-value-from-two-columns
Sheet: Sheet1

TABLE 1 |  |  | TABLE 2
Product | Price |  | Product | Price |  |  | Desired Result - return sorted unique values from green columns of Tables 1 and 2 using functions. Note that Table 2 is not named table on purpose.
A | 15 |  | A |  |  |  | A
B | 11 |  | B |  |  |  | B
C | 10 |  | C |  |  |  | C
A | 15 |  | E |  |  |  | E
E | 5 |  | D | 3 |  |  | D
A | 15 |  | A
B | 11 |  | B
 |  |  | C
Spreadsheet: 148007d1333086131-problem-with-conditional-formatting-comparing-between-two-values-test
Sheet: data

for vlookup | value to compare against | vlookup result | trying to format this column
173 | 12 |  | 0.0694
173 | 12 |  | 0.0694
173 | 7 |  | 0.0405
161 | 6 |  | 0.0373
190 | 8 |  | 0.0421
188 | 7 |  | 0.0372
188 | 9 |  | 0.0479
185 | 4 |  | 0.0216
184 | 3 |  | 0.0163
135 | 7 |  | 0.0519
117 | 0 |  | 0
140 | 8 |  | 0.0571
121 | 3 |  | 0.0248
298 | 10 |  | 0.0336
173 | 3 |  | 0.0173
395 | 12 |  | 0.0304
135 | 5 |  | 0.037
246 | 15 |  | 0.061
144 | 5 |  | 0.0347
231 | 5 |  | 0.0216
300 | 10 |  | 0.0333
334 | 8 |  | 0.024
63 | 2 |  | 0.0317
109 | 5 |  | 0.0459
135 | 4 |  | 0.0296
194 | 11 |  | 0.0567
251 | 9 |  | 0.0359
246 | 16 |  | 0.065
153 | 6 |  | 0.0392
168 | 6 |  | 0.0357
327 | 12 |  | 0.0367
163 | 4 |  | 0.0245
449 | 18 |  | 0.0401
138 | 1 |  | 0.0072
265 | 13 |  | 0.0491
278 | 16 |  | 0.0576
301 | 18 |  | 0.0598
112 | 0 |  | 0
111 | 0 |  | 0
75 | 1 |  | 0.0133
300 | 5 |  | 0.0167
222 | 5 |  | 0.0225
220 | 11 |  | 0.05
212 | 4 |  | 0.0189
210 | 6 |  | 0.0286
Spreadsheet: 333b150e-e9bb-4de2-96db-ec99752c8847
Sheet: Sheet1

UTAH STATE OFFICE OF EDUCATION | Unnamed: 1 | At the bottom of your screen you will find the names of each section of this application.  To OPEN or PRINT, CLICK on each one.
STANDARD APPLICATION FOR FINANCIAL ASSISTANCE
Special Education Services
1.  AGENCY NAME and ADDRESS (zip code)
 | Department / Division
 | Area Code and Telephone Number
2.  DATE APPLICATION SUBMITTED
3.  EXPENDITURE PERIOD
Beginning Date of Project:
Ending Date of Project:
4.  PROJECT DIRECTOR
Name of Person Responsible for Supervising This Project:
E-Mail Address:
Phone Number:  (include area code)
Fax Number:       (include area code)
5.  IMMEDIATE SUPERVISOR
Name of Person To Whom The Project Director Reports
6. NAME OF PROGRAM: | Descriptive Title of Project
IDEA Part B
7.  AMOUNT REQUESTED FOR FUNDING   (for continued financial support for subsequent years, USOE reserves the right to renew pending successful performance and availability of funding)
The agency certifies to the best of its knowledge and belief, the data in this application is true and correct.  The agency will agree to meet all of the requirements, including the project's objectives outlined within the narrative section of this application.  The agency will also agree to comply with all other applicable State Finance Regulations as well as applicable Federal EDGAR Administrative Regulations.
______________________________________________________________
Signature of Superintendent or Financial Officer
Return Application To: | FOR USOE USE ONLY
[NAME], Director of Special Education | Date Application Received:
Special Education Services
Utah State Office of Education | Program Content Reviewed By/Date:
[NAME]144200
Salt Lake City, UT  84114-4200 | Budget Reviewed By/Date:
Phone:  (801) 538-7757       Fax:  (801) 538-7991
Select "tabs" below for the additional parts of the application.
Spreadsheet: 163083d1340188755-changing-a-formula-in-a-cell-by-entering-a-number-in-another-cell-is-it-possible-0rhrp-demo
Sheet: Monday

Department Daily Schedule
Mon | 0600 | 0615 | 0630 | 0645 | 0700 | 0715 | 0730 | 0745 | 0800 | 0815 | 0830 | 0845 | 0900 | 0915 | 0930 | 0945 | 1000 | 1015 | 1030 | 1045 | 1100 | 1115 | 1130 | 1145 | 1200 | 1215 | 1230 | 1245 | 1300 | 1315 | 1330 | 1345 | 1400 | 1415 | 1430 | 1445 | 1500 | 1515 | 1530 | 1545 | 1600 | 1615 | 1630 | 1645 | 1700 | 1715 | 1730 | 1745 | 1800 | 1815 | 1830 | 1845 | 1900 | 1915 | 1930 | 1945 | 2000 | 2015 | 2030 | 2045 | 2100 | 2115 | 2130 | 2145 | 2200 | 2215 | 2230 | 2245 | 2300 | 2315 | 2330 | 2345 | Total
Stuart | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 |  |  |  |  | 1 | 1 | 1 |  | 1 | 1 | 1 | 1
[NAME] |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
Nicola |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
[NAME] | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 |  |  |  |  | 1 | 1 | 1 |  | 1 | 1 | 1 | 1
Total
Allowed Hours |  |  |  |  |  |  |  |  | 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5
Variance +/-
Tills Open
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0800-1300 |  |  | 1300-1700 |  |  | 1700-2200 |  |  | 2200-0800
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Ideal
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Actual
Spreadsheet: 198721d1354878136-how-auto-filter-ef289_auto-filter
Sheet: Sheet1

 |  |  |  |  | lion
Name | Amount |  |  |  | Name | Amount
kam | 1
lion | 2
shel | 3
lion | 2
kam | 5
shel | 4
lion | 8
kam | 9
shel | 1
lion | 3
shel | 4
Spreadsheet: 267fb417-2968-43e7-9cf6-547d81ab4dfb
Sheet: Weekly

Weighted Calorie, Saturate Fat and Sodium Averages for the Week
 | Average Calories | Average Sat. Fat (g) | Average Sodium (mg)
Monday
Tuesday
Wednesday
Thursday
Friday
Weekly Total
Weighted Weekly Average
Percent of Calories from Saturated Fat
Spreadsheet: 4b18c614-9109-4b81-80c0-b1cc2ede1509
Sheet: Sheet1

38  国籍別　出国命令書を交付された人員 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
国　　籍 | 総数 | 出入国管理及び　　難民認定法　　　　24条４号ロ | ６号 | ６号の２ | ７号
総　　　　　数 | 11100 | 10332 | 287 | 1 | 480
[NAME] | 3 | 3 | 0 | 0 | 0
ミャンマー | 96 | 85 | 10 | 0 | 1
バングラデシュ | 154 | 116 | 3 | 0 | 35
カンボジア | 3 | 3 | 0 | 0 | 0
スリランカ | 349 | 323 | 12 | 0 | 14
中国（本土） | 3589 | 3473 | 84 | 1 | 31
インド | 130 | 118 | 10 | 0 | 2
インドネシア | 701 | 632 | 53 | 0 | 16
イラン | 60 | 57 | 2 | 0 | 1
韓国・朝鮮 | 1992 | 1949 | 5 | 0 | 38
[NAME] | 37 | 37 | 0 | 0 | 0
マレーシア | 214 | 213 | 0 | 0 | 1
モンゴル | 240 | 222 | 13 | 0 | 5
ネパール | 212 | 185 | 8 | 0 | 19
[NAME] | 73 | 67 | 5 | 0 | 1
フィリピン | 1582 | 1366 | 44 | 0 | 172
[NAME] | 2 | 1 | 0 | 0 | 1
タイ | 429 | 343 | 36 | 0 | 50
トルコ | 88 | 85 | 0 | 0 | 3
ベトナム | 343 | 331 | 1 | 0 | 11
フランス | 8 | 8 | 0 | 0 | 0
キルギス | 6 | 6 | 0 | 0 | 0
リトアニア | 4 | 4 | 0 | 0 | 0
オランダ | 2 | 2 | 0 | 0 | 0
[NAME] | 5 | 4 | 0 | 0 | 1
ポルトガル | 3 | 3 | 0 | 0 | 0
ルーマニア | 69 | 66 | 0 | 0 | 3
ロシア | 27 | 27 | 0 | 0 | 0
スペイン | 3 | 3 | 0 | 0 | 0
英国 | 7 | 7 | 0 | 0 | 0
ウクライナ | 9 | 8 | 0 | 0 | 1
ウズベキスタン | 22 | 22 | 0 | 0 | 0
カメルーン | 13 | 13 | 0 | 0 | 0
エチオピア | 6 | 6 | 0 | 0 | 0
ガーナ | 34 | 32 | 0 | 0 | 2
ギニア | 3 | 3 | 0 | 0 | 0
マリ | 2 | 2 | 0 | 0 | 0
ナイジェリア | 23 | 21 | 0 | 0 | 2
セネガル | 7 | 3 | 0 | 0 | 4
タンザニア | 11 | 10 | 1 | 0 | 0
ウガンダ | 16 | 16 | 0 | 0 | 0
[NAME] | 3 | 3 | 0 | 0 | 0
コスタリカ | 2 | 2 | 0 | 0 | 0
[NAME] | 2 | 2 | 0 | 0 | 0
メキシコ | 8 | 8 | 0 | 0 | 0
米国 | 22 | 19 | 0 | 0 | 3
アルゼンチン | 13 | 12 | 0 | 0 | 1
ボリビア | 39 | 37 | 0 | 0 | 2
ブラジル | 78 | 75 | 0 | 0 | 3
チリ | 2 | 2 | 0 | 0 | 0
コロンビア | 62 | 56 | 0 | 0 | 6
エクアドル | 2 | 2 | 0 | 0 | 0
パラグアイ | 4 | 4 | 0 | 0 | 0
ペルー | 250 | 200 | 0 | 0 | 50
[NAME] | 3 | 3 | 0 | 0 | 0
オーストラリア | 8 | 7 | 0 | 0 | 1
無    国    籍 | 6 | 6 | 0 | 0 | 0
その他 | 19 | 19 | 0 | 0 | 0
Spreadsheet: 700424d1603192593-dynamic-table_array-value-for-vlookup-function-funding-rate-data-exemple
Sheet: Sheet1

MONTH | DAY | time | BTCUSDT | LTCUSDT | ETHUSDT | ETCUSDT | XRPUSDT | EOSUSDT | BCHUSDT | BSVUSDT
 |  | 2020-10-18 18:00:00
 |  | 2020-10-18 10:00:00
 |  | 2020-10-18 02:00:00
 |  | 2020-10-17 18:00:00
 |  | 2020-10-17 10:00:00
 |  | 2020-10-17 02:00:00
 |  | 2020-10-16 18:00:00
 |  | 2020-10-16 10:00:00
 |  | 2020-10-16 02:00:00
 |  | 2020-10-15 18:00:00
 |  | 2020-10-15 10:00:00
 |  | 2020-10-15 02:00:00
 |  | 2020-10-14 18:00:00
 |  | 2020-10-14 10:00:00
 |  | 2020-10-14 02:00:00
 |  | 2020-10-13 18:00:00
 |  | 2020-10-13 10:00:00
 |  | 2020-10-13 02:00:00
 |  | 2020-10-12 18:00:00
 |  | 2020-10-12 10:00:00
 |  | 2020-10-12 02:00:00
 |  | 2020-10-11 18:00:00
 |  | 2020-10-11 10:00:00
 |  | 2020-10-11 02:00:00
 |  | 2020-10-10 18:00:00
 |  | 2020-10-10 10:00:00
 |  | 2020-10-10 02:00:00
 |  | 2020-10-09 18:00:00
 |  | 2020-10-09 10:00:00
 |  | 2020-10-09 02:00:00
 |  | 2020-10-08 18:00:00
 |  | 2020-10-08 10:00:00
 |  | 2020-10-08 02:00:00
 |  | 2020-10-07 18:00:00
 |  | 2020-10-07 10:00:00
 |  | 2020-10-07 02:00:00
 |  | 2020-10-06 18:00:00
 |  | 2020-10-06 10:00:00
 |  | 2020-10-06 02:00:00
 |  | 2020-10-05 18:00:00
 |  | 2020-10-05 10:00:00
 |  | 2020-10-05 02:00:00
 |  | 2020-10-04 18:00:00
Spreadsheet: 844841d1696501168-count-if-acrross-several-tabs-help-17-
Sheet: SUMMARY

 | SUMMARY
 | HEO Learning Needs Analysis
 |  |  |  |  |  | COUNT & % (count/heo)
 | Learning Area | Courses | Reference | Media | Access From | 1 |  | 2 |  | 3 |  | 4
 | Induction &  Onboarding | DWP Induction | N/A | Various | Intranet
 |  |  | N/A | E-LEARNING | Civil Service Learning
 |  |  | N/A | Open Learning | Intranet
Spreadsheet: 00f7b4bc-285a-4418-b6cf-587c5dca8b5e
Sheet: Sheet1

V5.01 23-Apr-2002 | Blend 1 | Unnamed: 2 | Unnamed: 3 | Blend 2 | Unnamed: 5 | Unnamed: 6 | Blend 3 | Unnamed: 8 | Unnamed: 9 | Blend 4 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15 | Unnamed: 16
Gyration Number | Specimen 1 | [NAME] | Specimen 3 | Specimen 1 | [NAME] | Specimen 3 | Specimen 1 | [NAME] | Specimen 3 | Specimen 1 | [NAME] | Specimen 3
0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
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
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
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
Spreadsheet: 721924d1614953968-countif-with-index-match-and-or-function-test-file
Sheet: Dagrollen

Shift | Week | Dag | # [NAME] nodig | [NAME] | [NAME] | [NAME] | Taak 3 | [NAME] | Taak 5
Vroeg | Innovax | Maandag | 8 | 1 | P1 - Schouw (BMI + Afvoer) | P1 - Embryo (Decapper)
Vroeg | Innovax | Maandag | 20 |  | P1 - Embryo (Decapper) | P4 - Embryo (Vissen)
Laat | Marek | Dinsdag | 10 | 25 | P1 - Stang (Bedienen)
Laat | Marek | Dinsdag | 10 | 26 | P2 - Afvul (onder A)
Spreadsheet: 190217d1351566997-reference-cell-date-in-worksheet-based-on-a-group-of-dates-in-another-worksheet-sample
Sheet: Tickets

Date | Issue | Ticket Number | Address | Mileage is 130
 |  |  |  | 54.6
2012-10-25 00:00:00 | Printer Problems [NAME] Garage | HD0000000248251 | [NAME] 5710-86 St
2012-10-25 00:00:00 | Virus/Malware: TROH_SPNR.OCHR12 | HD000000248785 | Ferrier Transit Garage - 8620-58 Ave | 20
2012-10-26 00:00:00 | Unable to boot machine, screen blank | HD0000000248926 | Fort Edmonton Park
2012-10-26 00:00:00 | PC Display No Signal - MJDL086 | HD0000000248896 | Centennial Garage 15520 Ellerslie Rd SW | 45
2012-10-29 00:00:00 | Computer issue here | HD0000546546 | Coronation MES - 14402-114 Ave
2012-10-29 00:00:00 | Another Computer Issue Here | HD100000654654 | [NAME]58 Ave | 65
2012-10-29 00:00:00 | Yet another issue here | HD00000654987 | Century Park - 2407-111 St. NW
2012-10-29 00:00:00 | Some Issue Here | HD579876546 | Mount Pleasant Cemetery - 5420-106 St
Spreadsheet: 376658d1423673437-indirect-function-on-this-formula-single-cell-array-formulas
Sheet: Sheet14

Summing every nth value
 | Data
 | 1 |  | 3 | =nth
 | 2 |  |  | = Result
 | 3
 | 4
 | 5
 | 6
 | 7
 | 8
 | 9
 | 10
 | 11
 | 12
 | 13
 | 14
 | 15
 | 16
 | 17
 | 18
 | 19
Spreadsheet: 65414d1266116441-filtering-replacing-problem-13-feb-2010
Sheet: Sheet1

2009-11-13 00:55:24 | METAR | METAR | KEND | 130055Z | AUTO | 17016KT | 10SM | CLR | 18/13 | A2979 | RMK | AO2
2009-11-13 01:55:24 | METAR | METAR | KEND | 131155Z | 16017G21KT | 10SM | CLR | 14/12 | A2966 | RMK | AO2A | SLP039
2009-11-13 02:55:24 | METAR | METAR | KEND | 130255Z | AUTO | 16016KT | 10SM | CLR | 16/13 | A2977 | RMK | AO2
2009-11-13 03:55:24 | METAR | METAR | KEND | 130355Z | AUTO | 16016KT | 10SM | CLR | 16/13 | A2977 | RMK | AO2
2009-11-13 04:55:24 | METAR | METAR | KEND | 130455Z | AUTO | 17019G25KT | 10SM | CLR | 16/13 | A2975 | RMK | AO2
2009-11-13 05:55:24 | METAR | METAR | KEND | 130555Z | AUTO | 17018KT | 10SM | CLR | 15/13 | A2973 | RMK | AO2
2009-11-13 06:55:24 | METAR | METAR | KEND | 130655Z | AUTO | 17019G25KT | 10SM | CLR | 15/13 | A2971 | RMK | AO2
2009-11-13 07:55:24 | METAR | METAR | KEND | 130755Z | AUTO | 17020G27KT | 10SM | CLR | 15/13 | A2970 | RMK | AO2
2009-11-13 08:55:24 | METAR | METAR | KEND | 130855Z | AUTO | 18019G25KT | 10SM | CLR | 15/13 | A2969 | RMK | AO2
2009-11-13 09:55:24 | METAR | METAR | KEND | 130955Z | AUTO | 17019G24KT | 10SM | CLR | 15/12 | A2968 | RMK | AO2
2009-11-13 10:55:24 | METAR | METAR | KEND | 131055Z | AUTO | 17019KT | 10SM | CLR | 14/12 | A2967 | RMK | AO2
2009-11-13 11:55:24 | METAR | METAR | KEND | 131155Z | 16017G21KT | 10SM | CLR | 14/12 | A2966 | RMK | AO2A | SLP039
2009-11-13 12:55:24 | METAR | METAR | KEND | 131255Z | 18017KT | 10SM | CLR | 13/12 | A2966 | RMK | AO2A | SLP038
2009-11-13 13:55:24 | METAR | METAR | KEND | 131355Z | 18017KT | 10SM | CLR | 14/12 | A2967 | RMK | AO2A | SLP043
2009-11-13 14:55:24 | METAR | METAR | KEND | 131455Z | 18016KT | 10SM | CLR | 16/12 | A2967 | RMK | AO2A | PK
Spreadsheet: 816676d1675776197-if-statement-with-2-blanks-forconditional-formatting-book1
Sheet: Sheet1

 |  |  |  |  | AP end | DM | Work coach/[NAME] | Decision | Cleared
 |  |  |  |  | 2023-01-04 00:00:00
 |  |  |  |  | 2023-01-19 00:00:00
 |  |  |  |  | 2023-01-22 00:00:00
 |  |  |  |  | 2023-01-23 00:00:00
 |  |  |  |  | 2023-01-23 00:00:00 |  |  |  | 2023-02-06 00:00:00
 |  |  |  |  | 2023-01-24 00:00:00 |  |  |  | 2023-02-06 00:00:00
 |  |  |  |  | 2023-01-25 00:00:00
 |  |  |  |  | 2023-01-30 00:00:00
 |  |  |  |  | 2023-02-02 00:00:00
 |  |  |  |  | 2023-02-03 00:00:00 |  |  |  | 2023-01-06 00:00:00
 |  |  |  |  | 2023-02-03 00:00:00 |  |  |  | 2023-02-06 00:00:00
Spreadsheet: 170368d1343244731-need-formula-to-pull-data-from-aanther-sheet-cells-not-exact-match-sample-chrystalblaker-oeldere-
Sheet: Sheet2

School Name | Sub title | Address | Phone | Principal 2012 | date of contact
Adams | Elementary | main st | 123-4567 | [NAME] | 2011-01-24 00:00:00
Byant |  | oak st | 123-4568 | Marks | 2011-01-25 00:00:00
[NAME] |  | elm st | 123-4569 | Murphey | 2011-01-26 00:00:00
Washington |  | birch st | 123-4570 | [NAME] | 2011-01-27 00:00:00
Spreadsheet: 808469d1670487548-combine-2-sheets-analysis3
Sheet: MALE 5 BEST AND WEAK STUDENT

G. FIVE BEST MALE STUDENTS
NO | NAME | SEX M=1 &F=2 | SCHOOL | WARD | SUBJECTS |  |  |  |  |  |  |  |  |  |  |  | TOTAL | AVERAGE | GRADE
 |  |  |  |  | KISW |  | ENGL |  | HIS |  | SAY |  | M/JAM |  | URA
 |  |  |  |  | A | D | A | D | A | D | A | D | A | D | A | D
1
2
3
4
5
H. FIVE WEAK MALE STUDENTS
NO | NAME | SEX M=1 &F=2 | SCHOOL | WARD | SUBJECTS |  |  |  |  |  |  |  |  |  |  |  | TOTAL | AVERAGE | GRADE
 |  |  |  |  | KISW |  | ENGL |  | HIS |  | SAY |  | M/JAM |  | URA
 |  |  |  |  | A | D | A | D | A | D | A | D | A | D | A | D
1
2
3
4
5
Spreadsheet: 0160301b-c502-49f1-9562-834ed0b33d01
Sheet: BLS Table Data

December 2009 Bureau of Labor Statistics Table Data
 |  |  |  |  |  | 0.4
 |  |  | US Bureau of Labor Statistics Wtd Ave | US Bureau of Labor Statistics Wtd Ave | US Bureau of Labor Statistics Wtd Ave | US Bureau of Labor Statistics Table 5 | US Bureau of Labor Statistics Table 8
 |  |  | Percent of Payroll | Cost per FTE | Cost per hour | Mgmt, professional & related | 500 workers or more
A. | PAYROLL
 |  | Total Compensation |  |  |  | 48.19 | 39.13
 |  | Payroll
B. | PAID LEAVE
 |  | Vacation |  |  |  | 2.09 | 1.78
 |  | Holidays |  |  |  | 1.26 | 1
 |  | Sick and Personal
 |  | TOTAL B
C. | SUPPLEMENTAL PAY
 |  | Overtime and premium |  |  |  | 0.19 | 0.39
 |  | Shift differentials |  |  |  | 0.13 | 0.2
 |  | Nonproduction bonuses |  |  |  | 1.32 | 0.81
 |  | TOTAL C
D. | INSURANCE
 |  | Life |  |  |  | 0.08 | 0.07
 |  | Health |  |  |  | 2.94 | 3.26
 |  | Short-Term Disability |  |  |  | 0.09 | 0.1
 |  | Long-Term Disability |  |  |  | 0.09 | 0.09
 |  | TOTAL D
E. | RETIREMENT AND SAVINGS
 |  | Defined Benefit Pension Plan |  |  |  | 0.6 | 0.84
 |  | Defined Contribution |  |  |  | 1.21 | 1.02
 |  | TOTAL E
F. | LEGALLY REQUIRED PAYMENTS:
 |  | Social Security and Medicare |  |  |  | 2.82 | 2.26
 |  | Federal and State Unemployment Payments
 |  | Workers' Compensation |  |  |  | 0.36 | 0.39
 |  | TOTAL F
G. | COST STUDY BENEFITS
 |  | Paid Leave
 |  | Insurance plus Retirement and Savings
 |  | Total G
H. | COST STUDY PAYROLL AND BENEFITS
 |  | Payroll
 |  | Benefits
 |  | Total H
Spreadsheet: 726464d1617258595-transpose-a-value-that-is-not-zero-to-a-new-column-in-another-row-example
Sheet: Sheet2

Acct$SV$Account | Acct$SV$Projects | Acct$SV$Award | Acct$SV$Intercompany | Acct$SV$Task | Acct$SV$Future_2 | GLLIN$VEHICLE_REG_NUM | DOC_SEQUENCE_VALUE | Acct$CV$Accounting_KFF | New Column
14712 | 00000000 | 000000 | 000 | 000000 | 00000 |  | 294852 | [PHONE].14712.00000000.000000.000.000000.00000 | 100232
50100 | 10003908 | 100232 | 000 | 000000 | 00000 |  | 294852 | [PHONE].50100.10003908.100232.000.000000.00000 | 100232
00039 | 00000000 | 000000 | 000 | 000000 | 00000 |  | 299617 | [PHONE].00039.00000000.000000.000.000000.00000 | 999878
45010 | 99999978 | 999878 | 000 | 000000 | 00000 |  | 299617 | [PHONE].45010.99999978.999878.000.000000.00000 | 999878
14712 | 00000000 | 000000 | 000 | 000000 | 00000 |  | 303375 | [PHONE].14712.00000000.000000.000.000000.00000 | 101276
59070 | 10003274 | 101276 | 000 | 000000 | 00000 |  | 303375 | [PHONE].59070.10003274.101276.000.000000.00000 | 101276
Spreadsheet: 738517d1625077311-checking-for-two-values-in-a-row-and-then-returning-a-third-value-from-a-cell-in-that-row-example
Sheet: Sheet1

BOS | Bergeron | C
BOS | Marchand | W |  | Team | Player | Position
BOS | Pastrnak | W |  | BOS |  | G
BOS | McAvoy | D
BOS | Rask | G
TOR | Matthews | C
TOR | Marner | W
TOR | Hyman | W
TOR | Reilly | D
TOR | Campbell | G
Spreadsheet: 888074d1738429306-filter-data-based-on-criteria-filtered-data-rajeshn_in-
Sheet: Sheet1

Company Name | Bank Name
MKL | AXIS
MKHL | HDFC |  |  | Company Name | Bank Name |  | Company Name | Bank Name
MKL | HDFC |  |  | MKL | AXIS |  | MKL | AXIS
MKHL | HDFC |  |  | MKL | HDFC |  | MKL | HDFC
MAPL | SBI |  |  | MKL | SBI |  | MKL | SBI
MKL | SBI |  |  | MKHL | HDFC |  | MKHL | HDFC
MAPL | HDFC |  |  | MKHL | SBI |  | MKHL | SBI
MKHL | SBI |  |  | MAPL | HDFC |  | MAPL | SBI
MKL | HDFC |  |  | MAPL | SBI |  | MAPL | HDFC
MKHL | SBI
MKL | AXIS
Company Name | Bank Name |  | FILTERED DATA
MKL | AXIS
MKL | HDFC
MKL | SBI
MKHL | HDFC
MKHL | SBI
MAPL | SBI
MAPL | HDFC
 | AXIS
MKL | HDFC
MKL | SBI
MKHL | HDFC
MKHL | SBI
MAPL | SBI
MAPL | HDFC
Spreadsheet: 30352e30-cfe9-4305-96eb-0debdf3f401a
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
7683 | 57722 | [NAME] | Coomber | RSA | 0 | 00:23:58 | 00:00:00 | 01:48:27 | 00:00:00 | 00:33:45 | 1 | [NAME]
Spreadsheet: 28567d1222882566-formula-that-recognizes-change-in-field-attchmt
Sheet: Sheet1

 | Return | Unit Value | Linked
ABC | -2.3057 | 0.976943 | 0.02406729721007062
 | -2.2573 | 0.977427
 | -2.0317 | 0.979683
 | 0 | 1
 | 0.2031 | 1.002031
 | 0.9176 | 1.009176
 | 1.6297 | 1.016297
 | 2.1357 | 1.021357
 | 4.2901 | 1.042901
DEF | -3.5369 | 0.964631 | -0.04317051066737732
 | -3.5368 | 0.964632
 | -2.3074 | 0.976926
 | -2.0655 | 0.979345
 | -1.8561 | 0.981439
 | -1.4508 | 0.985492
 | -1.3951 | 0.986049
 | -0.4806 | 0.995194
 | -0.4328 | 0.995672
 | -0.3801 | 0.996199
 | 0.071 | 1.00071
 | 0.146 | 1.00146
 | 0.4611 | 1.004611
 | 0.9663 | 1.009663
 | 1.2061 | 1.012061
 | 1.8874 | 1.018874
 | 2.4963 | 1.024963
 | 2.7543 | 1.027543
 | 3.4136 | 1.034136
GHI | -2.8672 | 0.971328 | 0.0220626022185022
 | -2.053 | 0.97947
 | -2.0298 | 0.979702
 | -1.9355 | 0.980645
 | -1.6164 | 0.983836
 | -1.2268 | 0.987732
 | -0.7618 | 0.992382
 | -0.4587 | 0.995413
 | -0.4569 | 0.995431
 | -0.2186 | 0.997814
 | 0.3699 | 1.003699
 | 0.4989 | 1.004989
 | 0.7839 | 1.007839
 | 1.3884 | 1.013884
 | 2.326 | 1.02326
 | 2.4618 | 1.024618
 | 2.4764 | 1.024764
 | 2.8277 | 1.028277
 | 2.9873 | 1.029873