tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 1cc4c8ff-a70d-43fe-81b1-c175c76c800f
Sheet: Sheet1

CSEA 2011 rates - effective 10/1/11*
Employee Health Insurance Deduction Per Paycheck
*RATE CHANGES TO AFFECT 09/28/2011 PAY CHECK
 |  |  | A - Grade 9 or Lower |  | B - Grade 10 or Above
Note: To enroll in an HMO, you must live or work in the HMO's service area
Code |  | Plan and Service Area | Ind. | Fam. | Ind. | Fam.
1 |  | The Empire Plan | 32.09 | 128.08 | 42.79 | 153
 |  | Available to enrollees and their eligible dependents worldwide
66 |  | Blue Choice | 25.54 | 104.92 | 34.05 | 125.19
 |  | Serving Livingston, Monroe, Ontario, [NAME], [NAME], and Yates counties
67 |  | Community Blue | 30.43 | 182.1 | 40.57 | 208.01
 |  | Serving Allegany, Cattaraugus, [NAME], Erie, Genesee, Niagara, Orleans, and Wyoming counties
59 |  | Independent Health | 29.44 | 126.53 | 39.25 | 150.72
 |  | Serving Allegany, Cattaraugus, [NAME], Erie, Genesee, Niagara, Orleans, and Wyoming counties
58 |  | MVP of Rochester (formerly Preferred Care) | 25.29 | 107.95 | 33.72 | 128.62
 |  | Serving Genesee, [NAME], Monroe, Ontario, Orleans, [NAME], Steuben, Wayne, Wyoming, and Yates counties
Spreadsheet: 116586d1311937606-function-that-copy-certain-numbers-to-another-sheet-exam
Sheet: Sheet2

0
 |  | Note:
 |  | Copy paste formula in Cell C1 on the required range.
 |  | [NAME] is linked with column B or sheet1 and [NAME] in sheet2. Enter any number in Cell A1 i.e. 0 or 1 or 2
 |  | Array formula is used and should be confirmed though Ctrl+Enter+Delete
Spreadsheet: 103236d1301000295-subtotaling-by-half-change-in-category-dataexample
Sheet: Sheet3

user id | month | plan | min | overage
19164958b | 15522 | 1 | 26 | 0
19164958b | 15553 | 1 | 30 | 0
19164958b | 15584 | 1 | 0 | 0
19164958b | 15614 | 1 | 83 | 0
19164958b | 15645 | 1 | 174 | 0
19164958b | 15675 | 1 | 148 | 0
19164958b | 15706 | 1 | 276 | 30.4
19164958b | 15737 | 1 | 124 | 0
19164958b | 15765 | 1 | 101 | 0
19164958b | 15796 | 1 | 116 | 0
19164958b Average
Grand Average
Spreadsheet: 013b6081-6d33-444f-913f-e1c989b88ce1
Sheet: Vendors

 |  |  | Version: | 1.8
 | Vendors
 | Reporting Information
 | Award Number*
 | B-09-MY-00-0000
No. | Subaward Number(*) | Vendor [NAME] Number(*) | [NAME](*) | Vendor HQ ZIP Code+4(*) | Product and Service Description | Payment Amount
1 | 2010-B | 999999999 | ABC Construction | 123456789 | Construction Materials | 100000
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: 696748d1600960099-excel-formula-for-same-any-one-of-value-by-wastage-type-stone-sales-sample
Sheet: Sheet1

 |  | STONE SALES CALCULATION TYPE-1 |  | STONE SALES CALCULATION TYPE-2
 |  | ITEM NAME | BLUE SAPHIRE | ITEM NAME | BLUE SAPHIRE
 |  | WEIGHT KG | 10 | WEIGHT KG | 10
 |  | WASTAGE |  | WASTAGE
 |  | % WASTSGE |  | % WASTSGE | 10
 |  | RATE | 100000 | RATE | 100000
 |  | FREIGHT | 1000 | FREIGHT | 1000
 |  |  |  |  |  | Here I want same value but I don’t know suitable formula please help.
 |  |  |  | This is Wastage type | 1101000 | Both are same value
 |  |  |  | This is % Wastage type | 1101000
 |  | Sample | 1101000 | Here I want any one of value by calculate two types of Wasthge with suitable formula please help.
Spreadsheet: 600719d1543928626-indirect-need-cell-range-to-change-to-the-indirect-method-indirect
Sheet: Age

Current Method |  |  |  | Desired Method |  |  |  |  |  |  |  |  |  | RowStart | RowEnd | Start Date | End Date
Age - From | Age - To | Count |  | Age - From | Age - To | Count |  |  |  |  |  |  |  | A2 | A11 | 2017-01-01 00:00:00 | 2018-03-31 00:00:00
18 | 25 |  |  | 18 | 25 | =[NAME])) |  |  |  |  |  |  |  | 2 | 11
26 | 35 |  |  | 26 | 35
36 | 45 |  |  | 36 | 45
46 | 55 |  |  | 46 | 55
56 | 70 |  |  | 56 | 70
Unknown |  |  |  | Unknown
Total: |  |  |  | Total:
Spreadsheet: 821922d1678989681-solved-help-with-dropdowns-and-fetching-info-via-indirect-new-pricing-matrix-v10-for-help
Sheet: list_data

Package Catagories | Session Types |  |  |  |  |  |  |  | Unique Print Product Catagories |  |  | ARRAYS for selection drop down on packages sheet
 | Babies | Cakesmash | Dance | Family | Headshots | Kids, Teens, & Grad | Maternity | Newborn | Category | Item Type | Item Name
Cakesmash
Dance | The Baby (2023) | The Cake (2023) | The [NAME] (2023) | Mommy & Me (2023) | [NAME] (2023) | The Silver Basic (2022) | The Bello Solo Bronze (2023) | The Wrapped (2023)
Family | The Baby Silver (2022) | The Party (2022) | Dancer's Portfolio (2022) | [NAME] (2023) | The Portfolio Package (2022) | The [NAME] (2023) | The Belly Silver (2022) | The Basic Bronze (2022)
Headshots |  | The Party (2023) | Dancer's Portfolio (2023) | The Family Silver (2022) | [NAME] (2023) | The Silver (2023) | The Belly Silver (2023) | The [NAME] (2023)
Kids |  | The Celebration (2022) | Advanced Creative (2022) | The Family Gold (2022) |  | The Gold (2022) | The Belly Gold (2023) | The Silver Collection (2022)
Maternity |  | The Celebration (2023) | Group Creative Session (2022) | The Family Silver (2023) |  | The Platinum (2022) | The Belly Gold (2022) | The Silver Collections (2023)
Newborn |  |  |  | The Platinum Group (2022) |  |  | The Belly Platinum (2023) | The Gold Collection (2022)
0 |  |  |  | The Family Gold (2023) |  |  |  | The Gold Collection (2023)
 |  |  |  | The Platinum Group - Extended Family (2023) |  |  |  | The Platinum Collection (2022)
 |  |  |  |  |  |  |  | The Platinum Collection (2023)
Spreadsheet: 861476d1709312444-how-to-fill-in-the-corresponding-table-with-the-names-of-each-unit-according-to-their-job-0301
Sheet: Sheet1

Table1 |  |  |  |  |  |  | Table2
Serial Number | unit | Name | position | employee attributes |  |  | unit | staff |  |  |  |  | outsource |  |  |  |  | Self employment
1 | Terminal group | T2 | maintenance | outsource |  |  |  | Number of people | maintenance | assemble | Receiving orders | handle | Number of people | maintenance | assemble | Receiving orders | handle | Number of people | maintenance | assemble | Receiving orders | handle
2 | Terminal group | W1 | maintenance | outsource |  |  | Terminal group |  |  |  |  |  |  | T2, W1 | [NAME]
3 | Terminal group | [NAME] | assemble | outsource |  |  | Complaint team | 1 |  |  | T1 |  | 1 |  |  |  | T4 | 0
4 | Complaint team | T1 | Receiving orders | staff |  |  | Transport Group | 0 |  |  |  |  | 2 |  |  | W5 | W4 | 0
5 | Complaint team | T4 | handle | outsource |  |  | Support group | 1 |  | T3 |  |  | 0 |  |  |  |  | 1 |  | W3
6 | Transport Group | W5 | Receiving orders | outsource
7 | Transport Group | W4 | handle | outsource
8 | Support group | T3 | assemble | staff
9 | Support group | W3 | assemble | Self employment
 |  | 3/4” |  |  | 7/8”
Spreadsheet: 1c769e00-464b-4f9d-9dea-08fde79d8aa9
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
261356 | 72818 | [NAME] | [NAME] | CAN | 28 | 00:09:44 | 00:01:35 | 00:36:29 | 00:00:45 | 00:16:22 | 1 | 01:04:54
261356 | 69962 | [NAME] | Hammer | USA | 26 | [NAME] | 00:02:07 | 00:36:20 | 00:00:38 | 00:15:20 | 2 | 01:05:43
261356 | 32641 | Joel | Rosinbum | USA | 27 | 00:12:07 | 00:01:46 | [NAME] | 00:00:49 | 00:21:11 | 3 | 01:13:27
261356 | 51378 | [NAME] | Ramos | USA | 29 | 00:13:03 | 00:02:20 | 00:40:01 | [NAME] | 00:19:20 | 4 | 01:15:32
261356 | 72513 | [NAME] | Flamand | CAN | 30 | 00:14:46 | 00:02:12 | 00:40:52 | 00:00:45 | 00:22:09 | 5 | [NAME]
Spreadsheet: lindy_donoho__21982__TWTop25_Dec_01
Sheet: Sheet1

Socal | 53341529
Texaco | 16539329
PG&E | 16001629
Sempra | 14294836
BP Energy | 10990113
Duke Energy | 7621234
El Paso Energy | 7198942
Burlington | 5170685
Agave | 4741447
USGT | 4672449
Richardson Products | 4175691
ENA | 4044320
Conoco | 3187073
El Paso Merchant | 2654860
OneOK Energy | 2616038
Enervest | 2518590
Reliant | 2226991
[NAME] | 2190051
Southern Energy | 1870625
Pan-Alberta | 1855800
Red Cedar | 1827814
Arizona Public | 1631342
TXU | 1624938
Astra | 1486260
PNM Gas Services | 1449146
Others | 3515512
TOTAL
Spreadsheet: 883018d1731497277-adjust-requirement-so-that-total-order-volume-isnt-exceeded-fruit3
Sheet: Used

 | Split | Order Quantity | Sent | In | In2 | Stock incoming | Oustanding | Outstanding New | Rounding correction
Fruit |  | 36 | 25 | 1 | 2 | 0 | 8 | 8
Apple | 0.22 | 8 | 11
Pear | 0.44 | 16 | 11
Orange | 0.12 | 4 | 1 |  | 2
[NAME] | 0.22 | 8 | 2 | 1
Spreadsheet: 161225d1339448014-how-to-combine-if-statement-in-offset-function-please-help-timesheet-upload-3
Sheet: Task

Name: | Short List: | Full List: |  |  |  | Finance | Marketing | Human Resource | Accounting
A.K | Process Month End | Emails (Inquiries/Questions) | Human Resource |  | Finance | Task for A.K 10 | Task for A.K 15 | Task for A.K 18 | Task for A.K 16
A.K | Monitor Bank Accounts | Monitor Bank Accounts | Finance |  | Marketing | Task for A.K 20 | Task for M.C 21 | Task for A.K 28 | Task for A.K 26
A.K | Process Recovery | Process Month End | Marketing |  | Human Resource | Task for A.K 30 | Task for A.K 35 | Task for A.K 38 | Task for A.K 36
A.K | Emails (Inquiries/Questions) | Process Recovery | Human Resource |  | Accounting
A.K | Complete OOS | Complete OOS | Accounting
A.K | Full List | Reconcilliation | Human Resource
A.K |  | Revenue | Finance
A.K |  | Task for A.K 08 | Marketing
A.K |  | Task for A.K 09 | Human Resource
A.K |  | Task for A.K 10 | Accounting
A.K |  | Task for A.K 11 | Human Resource
A.K |  | Task for A.K 12 | Finance
A.K |  | Task for A.K 13 | Marketing
A.K |  | Task for A.K 14 | Human Resource
A.K |  | Task for A.K 15 | Accounting
A.K |  | Task for A.K 16 | Human Resource
A.K |  | Task for A.K 17 | Finance
A.K |  | Task for A.K 18 | Marketing
A.K |  | Task for A.K 19 | Human Resource
A.K |  | Task for A.K 20 | Accounting
A.K |  | Task for A.K 21 | Human Resource
M.C | Task for M.C 01 | Task for M.C 01 | Finance
M.C | Task for M.C 08 | Task for M.C 02 | Marketing
M.C | Task for M.C 12 | Task for M.C 03 | Human Resource
M.C | Task for M.C 14 | Task for M.C 04 | Accounting
M.C | Task for M.C 16 | Task for M.C 05 | Human Resource
M.C | Full List | Task for M.C 06 | Finance
M.C |  | Task for M.C 07 | Marketing
M.C |  | Task for M.C 08 | Human Resource
M.C |  | Task for M.C 09 | Accounting
M.C |  | Task for M.C 10 | Human Resource
M.C |  | Task for M.C 11 | Finance
M.C |  | Task for M.C 12 | Marketing
M.C |  | Task for M.C 13 | Human Resource
M.C |  | Task for M.C 14 | Accounting
M.C |  | Task for M.C 15 | Human Resource
M.C |  | Task for M.C 16 | Finance
M.C |  | Task for M.C 17 | Marketing
M.C |  | Task for M.C 18 | Human Resource
M.C |  | Task for M.C 19 | Accounting
M.C |  | Task for M.C 20 | Human Resource
M.C |  | Task for M.C 21 | Finance
T.G | Task for T.G 4 | Task for T.G 01 | Marketing
T.G | Task for T.G 6 | Task for T.G 02 | Human Resource
T.G | Task for T.G 12 | Task for T.G 03 | Accounting
T.G | Task for T.G 15 | Task for T.G 04 | Human Resource
T.G | Task for T.G 19 | Task for T.G 05 | Finance
T.G | Full List | Task for T.G 06 | Marketing
T.G |  | Task for T.G 07 | Human Resource
T.G |  | Task for T.G 08 | Accounting
T.G |  | Task for T.G 09 | Human Resource
T.G |  | Task for T.G 10 | Finance
T.G |  | Task for T.G 11 | Marketing
T.G |  | Task for T.G 12 | Human Resource
T.G |  | Task for T.G 13 | Accounting
T.G |  | Task for T.G 14 | Human Resource
T.G |  | Task for T.G 15 | Finance
T.G |  | Task for T.G 16 | Marketing
T.G |  | Task for T.G 17 | Human Resource
T.G |  | Task for T.G 18 | Accounting
T.G |  | Task for T.G 19 | Human Resource
T.G |  | Task for T.G 20 | Finance
Spreadsheet: bd953185-fc45-46a9-85a0-0c46b57be3b6
Sheet: Sheet1

ISOLINE  ECO | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15 | Unnamed: 16
 | Odběratel: |  |  |  |  |  |  |  | List č. ..... [NAME] |  |  |  | m²:
 |  |  |  |  |  |  |  |  | (příklad: List č. 1   z.  5)
 |  |  |  |  |  |  |  |  | Dat. objednání:
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Zbrojovka obj. 13
 |  |  |  |  |  |  |  |  | Dat. rozvozu: |  |  |  |  |  | 755 01  Vsetín
 |  |  |  |  |  |  |  |  |  |  |  |  | ks: |  | fax: 571 432 723
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | tel.: 571 405 580
 |  |  |  |  |  |  |  |  | Číslo zakázky: |  |  |  |  |  | e-mail: [EMAIL]
 | Pozice |  | [NAME] | Profil |  | [NAME] ([NAME]) |  |  |  | ks | Barva |  | Rám okna | Dist. podl. (počet) |  | Poznámka
 |  |  |  |  |  | Šířka | Výška |  |  |  | Lamely | [NAME]
 | [NAME] ovládání: |  |  | Profil: |  |  |  | Barva lamely: |  |  | Barva profilu: |  | Rám okna: |  |  | Poznámka:
 |  |  |  |  |  |  |  | dle vzorníku |  |  | B – bílý (Fe, Al) |  | PVC – plast |  |  | v poznámce [NAME] nestandardní
 | P – pravé |  |  | Al – hliníkový |  |  |  |  |  |  | H – hnědý (Fe, Al) |  | D – dřevo |  |  | požadavky a úpravy.
 | L – levé |  |  | Fe - pozink |  |  |  |  |  |  | S – stříbrný (Fe)
 | N – šnek + plastové táhlo |  |  |  |  |  |  |  |  |  | RAL 8003 (Fe, Al) |  | Dist. podložky:
 | B – bovden + tyčka |  |  |  |  |  |  |  |  |  | RAL 8023 (Al) |  | píšeme počet podložek
 |  |  |  |  |  |  |  |  |  |  | RAL 8004 (Fe)
Spreadsheet: 773752d1648035581-auto-fill-blank-cells-in-column-excel-example
Sheet: Sheet1

Jonny B | 1
 | 2
 | 1
 | 3
 | 4
 | 1
Trevor C | 1
 | 2
 | 1
 | 1
 | 1
 | 1
 | 1
[NAME] | 2
 | 3
 | 2
 | 1
 | 1
 | 1
Jan T | 4
 | 3
 | 2
[NAME] | 1
 | 1
 | 2
 | 5
[NAME] R | 2
 | 1
 | 1
Tracy P | 1
 | 3
 | 4
 | 4
Spreadsheet: 210762d1359560001-i-chose-a-vehicle-from-a-list-and-want-the-price-of-that-vehicle-to-populate-ncd-test-help
Sheet: Sheet2

ACCORD 2DR L4 EX 6MT | 26290 | 1640
ACCORD 2DR L4 EX CVT | 27490 | 1640
ACCORD 2DR L4 EXL-NAVI 6MT | 29990 | 1640
ACCORD 2DR L4 EXL-NAVI CVT | 31190 | 1640
ACCORD 2DR V6 EXL-NAVI 6AT | 35390 | 1640
ACCORD 2DR V6 EXL-NAVI 6MT | 35390 | 1640
ACCORD 4DR L4 EXL CVT | 29090 | 1640
ACCORD 4DR L4 LX 6MT | 23990 | 1640
ACCORD 4DR [NAME] | 25190 | 1640
ACCORD 4DR L4 SPORT 6MT | 25490 | 1640
ACCORD 4DR [NAME] CVT | 26690 | 1640
ACCORD 4DR L4 TOURING 6MT | 30390 | 1640
ACCORD 4DR [NAME] | 31590 | 1640
ACCORD 4DR V6 EXL 6AT | 32790 | 1640
ACCORD 4DR V6 TOURING 6AT | 35290 | 1640
CIVIC 2DR EX 5AT | 21790 | 1495
CIVIC 2DR EX 5MT | 20590 | 1495
CIVIC 2DR EXL - NAVI 5AT | 25240 | 1495
CIVIC 2DR LX 5AT | 19790 | 1495
CIVIC 2DR LX 5MT | 18590 | 1495
CIVIC 2DR SI 6MT | 26190 | 1495
CIVIC 4DR DX 5MT | 15440 | 1495
CIVIC 4DR EX 5AT | 21390 | 1495
CIVIC 4DR EX 5MT | 20190 | 1495
CIVIC 4DR EXL - TOURING 5AT | 24840 | 1495
CIVIC 4DR LX 5AT | 19390 | 1495
CIVIC 4DR LX 5MT | 18190 | 1495
CIVIC 4DR SI 6MT | 26190 | 1495
CROSSTOUR L4 EX 2WD | 28990 | 1640
CROSSTOUR L4 EXL 2WD | 32590 | 1640
CROSSTOUR V6 EXL 4WD | 37290 | 1640
CROSSTOUR V6 EXL NAVI 4WD | 39290 | 1640
CRV EX 2WD | 28940 | 1640
CRV EX AWD | 31040 | 1640
CRV EX-L AWD | 33240 | 1640
CRV LX 2WD | 25990 | 1640
CRV LX AWD | 28140 | 1640
CRV TOURING AWD | 35140 | 1640
FIT DX 5MT | 14580 | 1495
FIT DX-A 5AT | 17080 | 1495
FIT DX-A 5MT | 15880 | 1495
FIT LX 5AT | 18180 | 1495
FIT LX 5MT | 16980 | 1495
FIT SPORT 5AT | 20080 | 1495
FIT SPORT 5MT | 18880 | 1495
ODYSSEY EX 5AT | 34090 | 1640
ODYSSEY EX RES 5AT | 35690 | 1640
ODYSSEY EX-L RES 5AT | 41490 | 1640
ODYSSEY LX 5AT | 29990 | 1640
ODYSSEY TOURING 6AT | 47190 | 1640
PILOT EX | 40890 | 1640
PILOT EX-L | 43190 | 1640
PILOT EX-L RES | 44790 | 1640
PILOT LX 2WD | 34990 | 1640
PILOT LX 4WD | 37990 | 1640
PILOT TOURING | 48590 | 1640
RIDGELINE DX | 34990 | 1640
RIDGELINE SPORT | 37890 | 1640
RIDGELINE TOURING | 42190 | 1640
RIDGELINE VP | 36890 | 1640
Spreadsheet: 289b27f3-ee27-41ed-9e56-88012f6c3301
Sheet: monographs productivity stats

Monographs Productivity Statistics FY11 and FY12
COLLECTION METRICS
 | FY11 | FY12 | % change
Monograph volumes withdrawn | 317 | 5383
Monograph volumes added (total) | 10670 | 9022
Firm orders | 3901 | 3430
Standing orders | 151 | 182
Approval plan | 3715 | 2371
Gifts | 2903 | 3039
E-Books added* | N/A | 164008 | N/A
Media added | 289 | 122
PRODUCTIVITY METRICS
 | FY11 | FY12 | % change
ACQUISITIONS
Requests searched | 4737 | 4786
Duplicates returned | 322 | 300
Titles ordered | 3746 | 3677
Approvals returned | 12 | 27
Invoices processed | 684 | 642
Order records created | 7529 | 6102
COPY CATALOGING
LC Copy | 6562 | 5326
Edited Copy | 3743 | 1499
Original | 352 | 189
Sent to Cataloging | 338 | 85
Items deleted from HELIN | 314 | 496
INVENTORY
Items searched | 26470 | 74221
HELIN corrections | 669 | 908
Items recovered | 98 | 319
No barcodes | 21 | 77
No item record | 273 | 665
Search cards sent to Circ | 148 | 837
Other (new labels) | 198 | 602
Spreadsheet: 62930d1263914797-match-numbers-to-names-and-extract-totals-phonebill
Sheet: Sheet1

Date | Time | Call Duration |  |  | Cost | Number | Network | Misc
2007-01-01 00:00:00 | 19:04:29 | 1900-01-01 00:00:00 |  | 0 | 0.035 | 7726929111 | SMS - Outgoing, Mobile service | N/A | Contacts table
2007-01-02 00:00:00 | 18:51:10 | 00:01:05 |  | 0 | 0.114 | 7970936333 | Orange | N/A | 7726929111 | Fred | <total cost>
2007-01-03 00:00:00 | 09:28:31 | 00:00:02 |  | 0 | 0.01 | 7985710777 | T-Mobile | N/A | 7970936333 | [NAME] | <total cost>
2007-01-03 00:00:00 | 13:15:48 | 1900-01-01 00:00:00 |  | 0 | 0.035 | 7985710777 | SMS - Outgoing, Mobile service | N/A | 1159171321 | [NAME] | <total cost>
2007-01-03 00:00:00 | 18:18:14 | 00:00:26 |  | 0 | 0.013 | 1159171321 | [NAME] | N/A | 7985710777 | [NAME] | <total cost>
2007-01-04 00:00:00 | 09:42:49 | 1900-01-01 00:00:00 |  | 0 | 0.035 | 7985710777 | SMS - Outgoing, Mobile service | N/A
Spreadsheet: 75906e09-54fd-46e8-9e0c-5f584ef552b4
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
 |  | To determine Plus or Minus Power for Swimming Goggles from RX
 |  |  | OD | OS
 |  |  | Right | Left
 |  | Sphere | 0 | 0
 |  | Cylinder | 0 | 0
 |  | Optic | 0 | 0
 |  | Axis has no bearing on this.
Spreadsheet: 871268d1717657846-would-like-to-add-automatic-date-and-day-yearly-xda-sickness-file-aligw
Sheet: APRIL 

 | DATE | DAY | STAFF NAME | HOURS | CODE |  | STAFF NAME | HOURS | CODE |  | STAFF NAME | HOURS | CODE |  | STAFF NAME | HOURS | CODE |  | STAFF NAME | HOURS | CODE |  | STAFF NAME | HOURS | CODE |  | STAFF NAME | HOURS | CODE |  | STAFF NAME | HOURS | CODE |  | STAFF NAME | HOURS | CODE
 |  |  | Total Hours |  |  |  | Total Hours |  |  |  | Total Hours |  |  |  | Total Hours |  |  |  | Total Hours |  |  |  | Total Hours |  |  |  | Total Hours |  |  |  | Total Hours |  |  |  | Total Hours
 | DATE | DAY | STAFF NAME | PAY | TOIL
 |  |  | TOTALS
Spreadsheet: 779507d1651826319-how-to-transform-data-array-from-vertical-to-horizontal-layout-5f-06-aligw
Sheet: Sheet1

A | 1 |  |  | A | 1 | 6 |  |  |  |  | 6
A | 6 |  |  | B | 2 | 4 | 5 |  | B |  | 4 | 5
B | 2 |  |  | C | 8 | 5 |  |  | C |  | 5
B | 4 |  |  | D | 11 | 33 |  |  | D |  | 33
B | 5 |  |  | F | 22 |  |  |  | F
C | 8
C | 5
D | 11
F | 22
D | 33
Spreadsheet: 788125d1658294230-extracting-names-into-respective-columns-name_extraction_sample-with-rules-
Sheet: Sheet1

No. | Example | Prefix | First Name | Second Name | Nickname | Middle Name(s)/Initial(s) | Surname | Suffix(es) | Rule
1 | [NAME] |  | Ellen |  |  |  | Page |  | When it has first and last name
2 | [NAME] |  | [NAME] |  | the Bruce |  |  |  | When it has a first name and a nickname that starts with the articles "la", "el", "the", etc.
3 | [NAME] |  | Savannah | Rose |  |  | Soutas |  | When it has a first name, second name, and surname
4 | [NAME] |  | [NAME] |  |  | Emilian | Verstappen |  | When it has a first name, middle name(s), and surname
4 | [NAME] |  | [NAME] | [NAME] |  | Hervé Perceval | Leclerc |  | When it has a first name, second name, middle name(s) or initials, and surname(s)
5 | Lord Stanley of Preston | Lord |  |  |  |  | Stanley | of Preston | When it has an honoric prefix, last name, and suffix that starts with "of"
6 | Associate Justice [NAME] [NAME] | Associate Justice | [NAME] | Vivian |  |  | [NAME] |  | When it has a complete prefix, first name, second name, and surname(s)
7 | [NAME], 3rd Baron Killanin |  | [NAME] |  |  |  | Morris | 3rd Baron Killanin | When it has a first and last name, with a suffix of a title
8 | Ms. [NAME] Easterling | Ms. | Addison |  |  | Rae | Easterling |  | When it has a common prefix (Mr., Ms., Mrs.), first name, middle name(s), and surname
9 | Sec. [NAME] | Sec. | [NAME] | [NAME] |  | Montgomery | Buttigieg |  | Same as Rule No. 4, but with an abbreviated prefix
10 | Ms. [NAME] "Ivana" Sameer [NAME] | Ms. | [NAME] | Sayed | Ivana | [NAME] | [NAME] |  | Same as Rule No. 8, but with a nickname and two or more middle name(s)
11 | [NAME] |  | [NAME] |  | Cookie Monster |  | [NAME] |  | Same as Rule No. 1, but with a nickname that is two words or more
12 | Ma. [NAME] [NAME] | Ma. | Deanna | Izabella |  | Alvizo | [NAME] |  | Same as Rule No. 4, but with [NAME]. as its prefix
13 | [NAME] "the Great" Romanov I |  | [NAME] |  | the Great |  | [NAME] | I | Same as Rule No. 2, but with a surname and a suffix
14 | [NAME], Jr. |  | Alton |  |  | Crawford | [NAME] | Jr. | Same as Rule No. 3, but with a suffix separated by a comma and a space
15 | The Rt. Hon. Theresa [NAME], MP | The Rt. Hon. | Theresa | [NAME] |  |  | May | MP | Same as Rule No. 6, but with a suffix separated by a space
16 | Saint Jean-Baptiste de La Salle | Saint | Jean-Baptiste |  |  |  | [NAME] |  | Same as Rule No. 1, but with a prefix and a surname that is two words or more
Spreadsheet: d59d96ab-abea-4ffe-8c4f-e2b93a181e8c
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | BIKE | T2 | RUN.1 | POSITION | TOTAL TIME
2970 | 16450 | [NAME] | Herberger | GER | 0 | 00:46:22 | 00:01:33 | [NAME] | 00:01:12 | 00:25:49 | 1 | 02:32:53
2970 | 13772 | Les | Bailey | GBR | 0 | 00:46:02 | 00:01:09 | [NAME] | 00:01:13 | 00:26:02 | 2 | 02:36:21
2970 | 8033 | Arnott | [NAME] | GBR | 0 | 00:50:23 | [NAME] | [NAME] | 00:01:10 | [NAME] | 3 | 02:49:06
2970 | 12396 | [NAME] | [NAME] | GBR | 0 | 00:45:21 | 00:01:31 | 01:34:14 | 00:02:29 | 00:29:14 | 4 | 02:52:54
2970 | 13354 | [NAME] | [NAME] | GBR | 0 | 00:52:48 | 00:00:54 | 00:00:00 | 00:00:00 | 00:00:00 | DNF | 00:00:00
2970 | 12442 | [NAME] | Peck | GBR | 0 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | DNS | 00:00:00