tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 02de3ba3-cb61-42aa-9c30-852529b4a740
Sheet: Availability

 |  |  |  |  | How to read our availability:
 |  |  |  |  | The amount listed for each week reflects the total # of flats available to ship on that week.
 |  |  |  |  | Each week's availability reflects inventory rolled forward from the preceding week plus
 |  |  |  |  | any new production.
Perennial Hardy Hibiscus Liner Availability |  |  |  |  | Weekly quantities CANNOT be combined for greater availability.
2012-06-25 00:00:00 |  |  |  |  | If the quantity is blank there is no availability for that week.
Updated: | 2012-06-22 00:00:00 |  |  |  | For further instructions, click on the Instructions tab.
# Trays Available
Genus | Series | Variety | SIZE | BRAND | 2012-06-25 00:00:00 | Item #
HIBISCUS | Cordials | [NAME] | 72 | BB | 1 | 520033
HIBISCUS | Cordials | [NAME] | 72 | BB | 2 | 520032
HIBISCUS | Cordials | [NAME] | 72 | BB | 1 | 520031
HIBISCUS | [NAME] | Pinot Grigio | 72 |  | 7 | 520048
# Units Available
Genus | Series | Variety | SIZE |  | 2012-06-25 00:00:00 | Item #
HIBISCUS | Cordials | [NAME] | 72 |  |  | 520033
HIBISCUS | Cordials | [NAME] | 72 |  |  | 520032
HIBISCUS | Cordials | [NAME] | 72 |  |  | 520031
HIBISCUS | [NAME] | Pinot Grigio | 72 |  |  | 520048
Spreadsheet: craig_dean__4358__12-14act
Sheet: EPEData

 | 37335.53819444445
 | NEWMAN 1 ,UNAV, -0  , 75  , 39  , 83  ,  0  ,1
 | NEWMAN 2 ,ECON, 78  , 77  , 34  , 83  ,  0  ,1
 | NEWMAN 3 ,ECON, 99  ,100  , 35  ,103  ,  0  ,1
 | NEWMN/GT1,MANL, 33  , 60  , 18  , 60  ,  0  ,1
 | NEWMN/GT2,MANL, 33  , 60  , 18  , 60  ,  0  ,1
 | NM/GT1+ST,UNAV,  0  ,100  , 61  ,107  ,  0  ,1
 | NM/GT2+ST,UNAV,  0  ,100  , 66  ,107  ,  0  ,1
 | NEWMAN 4 ,UNAV,  0  ,215  , 86  ,214  ,  0  ,1
 | NEWMAN   ,, 243 ,  297,  105, 306 ,   0 ,
 | COPPER   ,[NAME], -0  , 69  , 15  , 69  ,  0  ,1
 | RIOGRAN 6,MANL, 25  , 47  , 29  , 48  ,  0  ,1
 | RIOGRAN 7,AVAL,  0  , 38  , 32  , 49  ,  0  ,1
 | RIOGRAN 8,UNAV,  0  ,121  , 36  ,151  ,  0  ,1
 | RIOGRANDE,,  25 ,   47,   29,  48 ,   0 ,
 | PALOVERDE,MANL,604  ,341  ,341  ,600  ,  0  ,1
 | FOURCRNRS,MANL, 42  , 42  , 42  ,104  ,  0  ,1
 | LAMBDA, 50.83,  747,  753,   79,    4,    0,15709,0
 | APS     ,STRT    ,FC,  ,   1,   1
 | IID     ,EXCS    ,FC,  ,  50,  50
 | IID     ,FIRM    ,PV,  , 100, 100
 | LDWP    ,ECON    ,PV,  ,  80,  80
 | PGT     ,LOSS    ,PV,  ,  -1,  -1
 | PNM     ,CNTG    ,LC,  ,  11,  11
 | PNM     ,LOSS    ,LC,  ,   2,   2
 | SPS     ,FIRM    ,WM,  ,-103,-103
 | SRP     ,FIRM    ,ED,  ,  25,  25
 | SRP     ,LOSS    ,PV,  ,   1,   1
 | TNP     ,FIRM    ,PV,  ,  25,  25
 | TNP     ,LOSS    ,PV,  ,  -5,  -5
 | WAPA    ,PASS    ,WM,HO,  -1,  -1
Spreadsheet: 725640d1616777290-using-and-if-statement-to-search-for-key-words-book5
Sheet: Sheet1

 |  |  |  |  | [NAME] |  | Failure
 |  |  |  |  | PHIL YELSTP |  | Failure
 |  |  |  |  | [NAME] |  | NO Failure
 |  |  |  |  | [NAME] |  | NO Failure
 |  |  |  |  | [NAME] |  | NO Failure
 |  |  |  |  | [NAME] |  | NO Failure
 |  |  |  |  | PHIL BLC |  | Failure
 |  |  |  |  | [NAME] |  | Failure
 |  |  |  |  | [NAME] |  | Failure
 |  |  |  |  | [NAME] |  | Failure
Spreadsheet: 158460d1338260023-flattening-export-file-import-data
Sheet: Sheet1

Customer Name | Category | OEM | Item No. | Description | INV / RO # | Invoice Date | Qty | Ext. Amount
Smith | STIHL-BRYA00 | STIHL-BRYA | [PHONE] | HEX HEAD SCREW M5X12 | INV # 23973 | 2012-05-01 10:11:41 | 1 | 0.49
Smith | STIHL-BRYA00 | STIHL-BRYA | [PHONE] | SPIKED BUMPER | INV # 23973 | 2012-05-01 10:11:41 | 1 | 15.99
Smith | STIHL-BRYA00 | STIHL-BRYA | [PHONE] | LOCK NUT M5 | INV # 23973 | 2012-05-01 10:11:41 | 1 | 0.99
Smith | STIHL-BRYA00 | STIHL-BRYA | [PHONE] | 20IN RM 3/8P .050G SUPR | INV # 23973 | 2012-05-01 10:11:41 | 3 | 152.85
[NAME] | EVINRUDE | EVINRUDE | 0432941 | IMPELLER | INV # 23999 | 2012-05-02 12:10:18 | 1 | 40.77
[NAME] | EVINRUDE01 | EVINRUDE | 0438556 | PUMP AY,FUEL | RO # 3139 | 2012-05-02 10:48:42 | 1 | 87.52
[NAME] | EVINRUDE01 | EVINRUDE | 0303615 | GASKET 5 PK | RO # 3139 | 2012-05-02 10:48:42 | 1 | 1.99
[NAME] | EVINRUDE01 | EVINRUDE | 0432572 | KIT,ROLLER&WASHER | RO # 3224 | 2012-05-25 12:18:01 | 1 | 16.63
[NAME] | EVINRUDE02 | EVINRUDE | 0397499 | ROLLER & SLEEVE AY | RO # 3224 | 2012-05-25 12:18:01 | 1 | 14.13
[NAME] | [NAME] | LANDSEA | 24-QL87YC | 934M SPARK PLUG 4/PA | RO # 3224 | 2012-05-25 12:18:01 | 2 | 15.38
[NAME] | LABOR | PLB | Pl001 | Labor | RO # 3224 | 2012-05-25 12:18:01 | 0.75 | 45
[NAME] | FEES | EVINRUDE | 01prop | Prop rebuild, weld, grind, balance, paint | INV # 24299 | 2012-05-15 16:37:08 | 1 | 80
Spreadsheet: 702520d1604399931-formulas-with-live-time-book1
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  | This cell contains the live time using =now()
 |  |  |  | These are the delivery times, might need to change for after the live time |  |  |  |  |  | 2020-11-03 12:00:00 | ebay
 |  |  |  |  |  |  |  |  |  | 2020-11-03 12:20:00 | amazon
 |  |  |  |  |  |  |  |  |  | 2020-11-03 12:40:00 | pc world
 |  |  |  |  |  |  |  |  |  | 2020-11-03 13:00:00
 |  |  |  |  |  |  |  |  |  | 2020-11-03 13:20:00 |  |  | l
 |  |  |  |  |  |  |  |  |  | 2020-11-03 13:40:00
 |  |  |  |  |  |  |  |  |  | 2020-11-03 14:00:00 |  |  | Would like these to tell me if they are outstanding or delivered based on the live time
 |  |  |  |  |  |  |  |  |  | 2020-11-03 14:20:00
 |  |  |  |  |  |  |  |  |  | 2020-11-03 14:40:00
Spreadsheet: 689082d1596112988-create-a-multi-year-calendar-calendar
Sheet: Sheet1

Year | 2021
Day Year | Week | Day of week | Date
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
Spreadsheet: c8e8b2f0-037a-4e17-bc70-0977abe70772
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
FACX | Test | FACX | Coxsackie A Antibodies (CSF) | Coxsackie A Antibodies, CSF | Complement Fixation (CF) | [NAME], leak proof vial: ScwLkPf |  |  | 2 | mL | Submit 2 mL spinal fluid. Ship refrigerate. | 0.5 mL | Specimens other than	CSF Anticoagulants other than	NA Hemolysis	NA Thawing	NA Lipemia	NA Icteric	NA | REFERENCE RANGE:  < 1:1             INTERPRETIVE CRITERIA:  < 1:1 Antibody Not Detected  > or = 1:1 Antibody Detected          Diagnosis of infections of the central nervous system is accomplished by demonstrating the presence of intrathecally-produced specific antibody. Interpretation of results may be complicated by low antibody levels found in CSF, passive transfer of antibody from blood, and contamination via bloody taps. The interpretation of CSF results must consider CSF-serum antibody ratios to the infectious agent.   Test Performed by: Focus Diagnostics, Inc.                                       5785 Corporate Avenue                                       Cypress, CA 90630-4750 | Sunday through Thursday | 2 - 5 days | 4 - 11 days | 6 | 86658 |  |  |  |  | Focus Diagnositics, Inc.
FACX | [NAME] | CSF | CSF |  |  |  | Refrigerated | 14 days
FACX | Result | Z0380 | [NAME] | [NAME] | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
FACX | Result | Z0381 | [NAME] | [NAME] | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
FACX | Result | Z0382 | [NAME] | [NAME] | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
FACX | Result | Z0383 | [NAME] | [NAME] | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
FACX | Result | Z0384 | [NAME] | [NAME] | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
FACX | Result | Z0385 | [NAME] Ab | [NAME] Ab | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 805316d1668619662-sumif-wildcards-not-working-sumif-wildcard
Sheet: Sheet1

 |  |  | Task Number | Hours | Resource Name
 |  |  | 1.3 | 4 | [NAME] |  |  |  | Name | Hours
 |  |  | 1.3 | 4 | [NAME] |  |  |  | [NAME]
 |  |  | 1.3 | 4 | [NAME] |  |  |  | [NAME]
 |  |  | 1.3 | 4 | [NAME] |  |  |  | [NAME]
 |  |  | 1.3 | 4 | [NAME]
 |  |  | 1.3 | 4 | [NAME]
 |  |  | 1.3 | 4 | [NAME]
 |  |  | 1.3 | 4 | [NAME]
 |  |  | 1.3 | 4 | [NAME]
 |  |  | 1.3 | 4 | [NAME]
 |  |  | 1.3 | 4 | [NAME]
 |  |  | 1.3 | 4 | [NAME] |  |  | I know wildcards don't work on numbers but this
 |  |  | 1.3 | 4 | [NAME] |  |  | still doesn’t work when I convert the column type to Text
 |  |  | 1.3 | 4 | [NAME]
 |  |  | 1.3 | 4 | [NAME]
 |  |  | 1.3 | 4 | [NAME]
 |  |  | 1.3 | 4 | [NAME]
 |  |  | 1.3 | 4 | [NAME]
 |  |  | 1.3 | 6 | [NAME]
 |  |  | 1.3 | 4 | [NAME]
 |  |  | 1.3 | 4 | [NAME]
 |  |  | 1.3.2 | 0.5 | [NAME]
 |  |  | 1.3.2 | 2 | [NAME]
 |  |  | 1.3.2 | 3 | [NAME]
 |  |  | 1.3.2 | 4 | [NAME]
 |  |  | 1.3.2 | 4 | [NAME]
 |  |  | 1.3.2 | 4 | [NAME]
 |  |  | 1.3.2 | 4 | [NAME]
 |  |  | 1.3.2 | 2 | [NAME]
 |  |  | 1.3.2 | 3 | [NAME]
 |  |  | 1.3.2 | 0 | [NAME]
 |  |  | 1.3.2 | 0 | [NAME]
 |  |  | 1.3.2 | 4 | [NAME]
 |  |  | 1.3.2 | 4 | [NAME]
 |  |  | 1.3.2 | 4 | [NAME]
 |  |  | 1.3.2 | 4 | [NAME]
 |  |  | 1.3.2 | 4 | [NAME]
 |  |  | 1.3.2 | 4 | [NAME]
 |  |  | 1.3.2 | 4 | [NAME]
 |  |  | 1.3.2 | 4 | [NAME]
 |  |  | 1.3.2 | 2 | [NAME]
 |  |  | 1.3.2 | 4 | [NAME]
 |  |  | 1.3.2 | 4 | [NAME]
 |  |  | 1.3.2 | 4 | [NAME]
 |  |  | 1.3.2 | 4 | [NAME]
Spreadsheet: 165173d1341071087-same-value-but-shows-false-copy-of-same-but-false
Sheet: Sheet1

Original Formats | LEN |  | CODE | [NAME] |  | SUBSTITUTE | LEN |  | SUBSTITUTE | LEN |  | LEFT | LEN
20101120 | 8 |  |  |  |  | 20101120 | 8 |  | 20101120 | 8 |  | 20101120 | 8
20101120‎ | 9 |  | 63 | ? |  | 20101120‎ | 9 |  | 20101120‎ | 9 |  | 20101120 | 8
 |  |  |  | ?
0 |  |  |  |  |  | 0 |  |  | 0 |  |  | 1
How This ? |  |  |  | LEN | The Symbol | REPLACE | LEN |  | SUBSTITUTE | LEN |  | SUBSTITUTE | LEN
TEST‎‎ | 6 |  |  | 1 | ‎ | 20101120 | 8 |  | 20101120 | 8 |  | 20101120 | 8
TEST | 4 |  |  | 1 | ‎ | 20101120 | 8 |  | 20101120 | 8 |  | 20101120 | 8
 |  |  |  |  | 1 | 1 |  |  | 1 |  |  | 1
Symbols (not Excel) | LEN | CODE 1 | CODE 2 | CODE 3 | CODE 4 | CODE 5
[NAME] | 5 | 63 | 63 | 63 | 63 | 63
↱ | 1 | 63
Spreadsheet: 719443d1613664236-assigning-cycle-number-to-each-repeating-cycle-based-on-flow-condtion-excel-example
Sheet: Sheet1

Minutes | Flow rate | State
1 | 0
2 | 0
3 | 12 | filling 1
4 | 11.5 | filling 1
5 | 12.1 | filling 1
6 | 12 | filling 1
7 | 0
8 | 0
9 | 0
10 | 0
11 | 12 | filling 2
12 | 11.5 | filling 2
13 | 12.1 | filling 2
14 | 12 | filling 2
15 | 0
16 | 0
17 | 0
18 | 12 | filling 3
19 | 12 | filling 3
20 | 12 | filling 3
21 | 0
22 | 0
23 | 0
Spreadsheet: c292c94c-cb2c-46aa-b534-44af0eacd57e
Sheet: Sheet1

analytica 2012 - List of exhibitors | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
 | Search by product and service index (3 Entries):
 | 2 Analysis 2.10 Optical analysis equipment 2.10.7 Video cameras
No. | Company | Country | City | [NAME] | Hall/Booth
1 | Hamamatsu Photonics Deutschland GmbH | Germany | Herrsching | 82211 | A2.415/514
2 | [NAME] Laborgeräte | Germany | Wiesloch | 69168 | A3.231
3 | IMAGO Technologies GmbH | Germany | Friedberg | 61169 | B2.510
Spreadsheet: chris_germany__1726__BBC Jan2000 NYSEG
Sheet: Sheet1

Belden & Blake Corporation
January 2000 NYSEG Production Gas
Purchase Calculation
 | Allocated |  | PURCHASE PRICES
 | [NAME] |  | 2.8 | 2.91
AZON CORP | 11312
[NAME] | 704
[NAME] | 786
HADCO | 12429
INDUSTRIAL PAINT | 1119
JOHNSTON MEMORIAL UM HOMES | 676
LOCKHEED | 802 |  | 802
SCHAPIRO | 1015
BATES TROY | 2176 |  | 2176
CANDOR ELEMENTARY | 0
CANDOR HIGH SCHOOL | 0
NORBORD | 13287
SHELTERED | 1107
SPENCER VAN ETTEN | 0
SWAP w/NYSEG | 3450 |  |  |  | 3450
Allocated Volumes
Price Tiers
Invoice Amount
Spreadsheet: 122537d1316926631-how-to-automate-color-survey-selection-health-scorecard-rules-and-weights_test
Sheet: Sheet1

[NAME] | Scoring | Rules | Color?
1A Overall score from Annual Survey | B= 4 Truly Loyal | *No score automatic yellow
 | G= 3 Accessible
 | Y= 2 Vulnerable
 | R= 1 At Risk
[NAME] how do you rate the health of the relationship with Oursourced comoany (Overall score from quarterly Survey)? | B= 4 Excellent | * No score automatic yellow
 | G= 3 Good | **Qtrly Score but no annual score this weights 50%
 | Y= 2 Fair | ***No score on either automatic red
 | R= 1 Poor
[NAME]
 |  |  | Stoplight | Rating Scale
 |  |  |  | Exceeds Expectations
 |  |  |  | Meets Expectations
 |  |  |  | Partially Meets Expectations
 |  |  |  | Needs Improvement
Spreadsheet: 687952d1595504354-look-for-current-active-part-and-previous-part-current-active-part-previous-part
Sheet: Sheet1

Change Reason | Part number | Effective Date | End date | Price |  | Active part | 001E99002 | 1.03
Initial price | 001E99000 | 2020-07-10 00:00:00 | 2020-07-13 00:00:00 | 1 |  | Previous part | 001E99001 | 1.02 | (Date is nearest)
Part rolloed up | 001E99001 | 2020-07-14 00:00:00 | 2020-07-16 00:00:00 | 1.01
Price change | 001E99001 | 2020-07-17 00:00:00 | 2020-07-19 00:00:00 | 1.02
Part rolloed up | 001E99002 | 2020-07-21 00:00:00 |  | 1.03
i have a list of part number. The part may have price change or part number roll up.
The roll up part number change must be the last digit change.
i want a formula to look for (1) current active part number (latest update), (2)  previous part number (2nd latest update)
Spreadsheet: 45189d1243958704-importing-values-from-sheets-to-create-unique-list-flags-2-
Sheet: LAMCAR

Latin America & The Caribbean
28 | Country | Sent? | Date Sent | Date Received | Location | Contact | Notes
0 | Argentina
0 | Belize
0 | Bolivia
0 | Brazil
0 | Chili
0 | Colombia
29 | Costa Rica | Yes | June 1, 2009 |  | Georgia | [NAME] (478)-278-4089
0 | Cuba
30 | Dominican Republic | Yes | June 1, 2009 |  | Georgia | [NAME] (478)-278-4089
31 | Ecuador | Yes | June 1, 2009 |  | Georgia | [NAME] (478)-278-4090
32 | El Salvador | Yes | June 1, 2009 |  | Georgia | [NAME] (478)-278-4091
33 | Guatemala | Yes | June 1, 2009 |  | Georgia | [NAME] (478)-278-4092
34 | Guyana | Yes | June 1, 2009 |  | Georgia | [NAME] (478)-278-4093
35 | Haiti | Yes | June 1, 2009 |  | Georgia | [NAME] (478)-278-4094
36 | Honduras | Yes | June 1, 2009 |  | Georgia | [NAME] (478)-278-4095
0 | Jamaca
37 | Mexico | Yes | June 1, 2009 |  | Georgia | [NAME] (478)-278-4089
38 | Nicaragua | Yes | June 1, 2009 |  | Georgia | [NAME] (478)-278-4090
39 | Panama | Yes | June 1, 2009 |  | Georgia | [NAME] (478)-278-4091
0 | Paraguay
0 | Peru
0 | Puerto Rico
0 | Trinidad
0 | Uruguay
0 | Venezuela
 | Total Countries: | 25
Spreadsheet: 54616d1254666491-opening-up-profiles-upon-clicking-on-the-personnels-name-team-attendance
Sheet: Nov09

 | 2009-11-02 00:00:00 |  |  | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | CL | Total MC | Total Leave
 | NAME | Gr | P No | 2009-09-01 00:00:00 | 2009-09-02 00:00:00 | 2009-09-03 00:00:00 | 2009-09-04 00:00:00 | 2009-09-05 00:00:00 | 2009-09-06 00:00:00 | 2009-09-07 00:00:00 | 2009-09-08 00:00:00 | 2009-09-09 00:00:00 | 2009-09-10 00:00:00 | 2009-09-11 00:00:00 | 2009-09-12 00:00:00 | 2009-09-13 00:00:00 | 2009-09-14 00:00:00 | 2009-09-15 00:00:00 | 2009-09-16 00:00:00 | 2009-09-17 00:00:00 | 2009-09-18 00:00:00 | 2009-09-19 00:00:00 | 2009-09-20 00:00:00 | 2009-09-21 00:00:00 | 2009-09-22 00:00:00 | 2009-09-23 00:00:00 | 2009-09-24 00:00:00 | 2009-09-25 00:00:00 | 2009-09-26 00:00:00 | 2009-09-27 00:00:00 | 2009-09-28 00:00:00 | 2009-09-29 00:00:00 | 2009-09-30 00:00:00
1 | [NAME] Theng | STL | 118137 |  |  |  | OFF |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | OFF |  |  |  |  |  | N/A | 0 | 0
2 | [NAME] | L9 | 114220 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | N/A | 0 | 0
3 | [NAME] | L8 | 115602 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | N/A | 0 | 0
4 | [NAME] | L6 | 126111 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | N/A | 0 | 0
5 | Khameed [NAME] | L7 | 127292 |  |  |  |  |  |  |  |  |  | AL |  |  |  |  |  | AL |  |  |  |  |  |  |  |  |  |  |  |  |  |  | N/A | 0 | 2
6 | [NAME] | L7 | 114200 |  |  |  | AL |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MC | MC | MC | AL |  |  |  |  |  | N/A | 3 | 2
7 | Mukri Moharam | L8 | 154606 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MC | MC |  |  |  |  |  | AL |  |  |  |  |  |  |  |  | N/A | 2 | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PH
 | SHIFT | Gr | P No | N | N | W | R | O | O | M | M | N | N | W | R | O | O | M | M | N | N | W | R | O | O | M | M | N | N | W | R | O | O | CL | Total MC | Total Leave
 | Sufian | L9 | 114220 |  | CL |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CL | CL | CL | CL |  |  |  |  | 5
 | [NAME] | L6 | 126111 |  |  |  |  |  |  |  | AL |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | N/A
1 = Child care  Leave (CL)
2 = National Service (NS)
3 = Medical Leave (MC)
4= Half day leave(HL)
5 = Annual Leave (AL)
L = Late coming
M = Meeting
T = Training
Y= Yokogawa
Spreadsheet: 377033d1423773430-several-issues-at-once-helpmeexcel
Sheet: Vendor 4

Item Number | Distributor | Description | UM | Size | Case Qty | Cost/ea | Cost/UM | Cost/Case | Type | Use | Frequency | Not Applicable
5432-1 | v4 | Cleaner 8 oz Can | can | 8 | 12 |  |  | 200.18 | [NAME] | Expendable | 2
5432-2 | v4 | Nitrile Glove | box | 100 | 10 |  |  | 59.12 | Glove | Expendable | 1
5432-3 | v4 | Paper 800ft | roll | 800 | 6 |  |  | 40.59 | Towel | Expendable | 3
5432-4 | v4 | 55 gallon thick | roll | 25 | 10 |  |  | 23.56 | [NAME] | Expendable | 1
5432-5 | v4 | Lobby broom plastic | ea | 1 | 1 |  |  | 4.34 | Broom | Non-Expendable | 0
Spreadsheet: 04e9dae3-fafb-41f6-8e5c-55e184cc6561
Sheet: Sheet1

Table 6--U.S. rice imports  1/ | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
Country | 2012/13 | 2011/12 | 2011/12 | 2010/11 | 2009/10 | 2008/09
or | through | through | market | market | market | market
region | December | December | year | year | year | year
 |  |  | 1,000 metric tons
ASIA | 281.395 | 229.931 | 541.563 | 529.833 | 563.943544 | 536.401387
China | 1.194 | 1.835 | 3.571 | 3.1 | 3.786815 | 3.951477
India | 58.086 | 41.721 | 110.58 | 96.454 | 94.809691 | 74.049801
Pakistan | 5.317 | 5.372 | 15.258 | 17.297 | 19.386689 | 16.851572
Thailand | 169.177 | 171.267 | 387.642 | 393.464 | 400.976938 | 422.132044
Vietnam | 46.248 | 8.539 | 21.664 | 15.601 | 41.55395 | 17.477892
Other | 1.372999999999955 | 1.19699999999999 | 2.84800000000007 | 3.916999999999916 | 3.429461 | 1.938601
EUROPE & FSU | 4.988 | 6.257 | 14.244 | 12.51 | 9.410672 | 7.566448
Italy | 3.356 | 3.226 | 8.201 | 7.53 | 6.220285 | 5.73241
Spain | 0.726 | 2.234 | 4.671 | 3.753 | 1.55218 | 0.419219
Russia | 0.02 | 0.013 | 0.024 | 0.034 | 0.032442 | 0.064456
United Kingdom | 0.112 | 0.037 | 0.039 | 0.009 | 0.126368 | 0.429608
Other | 0.7740000000000006 | 0.7469999999999997 | 1.309000000000001 | 1.183999999999997 | 1.479397 | 0.920755
WESTERN HEMISPHERE | 13.912 | 38.597 | 64.526 | 42.735403 | 42.735 | 31.065164
Argentina | 1.946 | 1.338 | 3.366 | 2.677 | 2.466583 | 1.121503
Brazil | 2.907 | 22.905 | 30.499 | 6.331 | 3.51007 | 3.902248
Canada | 3.972 | 6.416 | 16.323 | 17.067 | 15.357974 | 18.035834
Mexico | 0.461 | 0.587 | 1.085 | 1.264 | 6.120591 | 6.094151
Uruguay | 4.611 | 7.34 | 13.211 | 15.35 | 2.871551 | 1.710958
Other | 0.01500000000000146 | 0.01099999999999923 | 0.04199999999998738 | 0.045744 | 0.030665 | 0.20047
OTHER | 0.5800000000000178 | 0.4690000000000083 | 3.958000000000069 | 3.532636 | 5.470538 | 39.298261
Egypt | 0.1 | 0 | 0 | 0 | 0.644508 | 36.591199
United Arab Emirates | 0.144 | 0.283 | 0.522 | 3.03 | 4.441327 | 2.224564
Other | 0.3360000000000178 | 0.1860000000000083 | 4.2 | 0.5 | 0.384703 | 0.482498
TOTAL | 300.875 | 275.254 | 624.291 | 588.611 | 609.182188 | 614.33126
1/ Columns labeled "market year" are total August-July imports reported by the U.S. Census Bureau.
All data is reported on a product-weight basis.  Categories may not sum to total due to rounding.
Source: U.S. Census Bureau, Department of Commerce.
Last updated February 8, 2013.
Spreadsheet: 583311d1532368627-macro-or-table-to-cut-paste-dates-vertically-example
Sheet: Output

person number | Startdato1 | Slutdato1 | Startdato2 | Slutdato2 | Startdato3 | Slutdato3 | Startdato4 | Slutdato5
1231 | 2018-07-01 00:00:00 | 2018-04-17 00:00:00
1232 | 2017-10-24 00:00:00 | 2018-03-26 00:00:00 | 2016-06-03 00:00:00 | 2016-09-09 00:00:00
1233 | 29-02-2018 | 2018-05-30 00:00:00 | 2017-09-22 00:00:00 | 2017-11-11 00:00:00 | 2017-07-05 00:00:00 | 2017-09-03 00:00:00 | 2016-12-28 00:00:00 | 2017-03-29 00:00:00
1234 | 2017-07-13 00:00:00 | 2018-05-23 00:00:00 | 2016-10-09 00:00:00 | 2016-11-12 00:00:00
1235 | 2018-03-19 00:00:00 | 2999-12-31 00:00:00 | 2017-01-04 00:00:00 | 2017-07-12 00:00:00
1236 | 2017-07-06 00:00:00 | 2999-12-31 00:00:00
1237 | 2016-11-12 00:00:00 | 2017-04-14 00:00:00 | 2015-12-04 00:00:00 | 2016-07-25 00:00:00
1238 | 2017-09-06 00:00:00 | 2999-12-31 00:00:00 | 2017-06-17 00:00:00 | 2017-08-29 00:00:00 | 2016-10-01 00:00:00 | 2017-04-03 00:00:00
1239 | 2018-02-12 00:00:00 | 2018-07-14 00:00:00 | 2017-11-25 00:00:00 | 2018-01-02 00:00:00
Spreadsheet: 102922d1300812793-match-cell-from-array-and-copy-entire-row-example
Sheet: Place Matches On This Sheet

 | Here's How I Would Want the Results to Look:
 | [NAME] | [NAME] | Manuf | New Meter
Spreadsheet: 130089d1322062871-if-function-greater-than-115-less-than-195-if-function
Sheet: Sheet1

 |  | 2010 | YTD | YTD | YTD | TOTAL DAYS
 |  | Bal. FW | EARNED | TAKEN | BALANCE | STILL TO USE
 |  | 27.94 | 120 | 73.07 | 74.87 | 22.92125
 |  | 6.93 | 16 | 22.93 | 0
 |  | 19.17 | 96 | 7 | 108.17
 |  | 8 | 10 | 16 | 2
 |  | 5.5 | 0 | 5.5 | 0
 |  | 0 | 40 | 8 | 32
10.75 |  | 0 | 189.5 | 0 | 189.5
Spreadsheet: 386449d1427799469-dynamic-if-function-query
Sheet: Sheet1

Name | Age | Class1 | Amount | Name | Age | Class2 | Name | Age | Class3 |  | Class1 | Class2 | Class3
AA | 21 | Business | 1000 | QQ | 34 | 5000 | UU | 43 | 2100
SS | 22 | [NAME] | 2500 | WW | 32 | 3200 | HH | 4 | 2700
DD | 23 | Super | 6000 | EE | 31 | 2300 | GG | 2 | 2800
FF | 24 | Business | 4000 | CC | 35 | 4300 | KK | 41 | 3000
GG | 20 | Super | 1500 | RR | 38 | 4500 | LL | 45 | 3200