tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 844537d1696325950-combine-week-sheets-into-week1-blank-workouttracker
Sheet: Progress

Progress Report |  |  |  | Set 1 |  |  | Set 2 |  |  | Set 3 |  |  | Set 4 |  |  | Set 5 |  |  | Total
Category: | Glutes |  |  | Rep | Weight | Total | Rep | Weight | Total | Rep | Weight | Total | Rep | Weight | Total | Rep | Weight | Total | Rep | Weight | Total
Exercise: | Glute crush |  | Week1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  | Week2
 | ↑ |  | Week3
 |  |  | Week4
 |  |  | Week5
 |  |  | Week6
 |  |  | Week7
 |  |  | Week8
 |  |  | Week9
 |  |  | Week10
 |  |  | Week11
 |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 676 | 75 | 3380
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | First Month Averages (A SET)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Rep |  | Weight |  | Total |  | Average Time of workout | ←←←←←←←← | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Second Month Average (A SET)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Rep |  | Weight |  | Total |  | Average Time of workout
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Third Month Average (A SET)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Rep |  | Weight |  | Total |  | Average Time of workout
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Three Month OverALL Average (A SET)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Rep |  | Weight |  | Total |  | Average Time of workout
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ↑
Spreadsheet: 871747d1718174161-prepare-an-outstanding-sheet-test
Sheet: Sheet2

Date | Party | Amount | no of Days
2023-01-01 00:00:00 | rent jan | Selfi | Rental Income | 16500 |  |  | rent jan | Selfi | Rental Income | 16500
2023-01-01 00:00:00 | rent jan | Major | Rental Income | 7800 |  | 2023-01-01 00:00:00 | rent jan | Major | Rental Income | 7800
2023-01-01 00:00:00 | rent jan | Tax | Major | 975 |  | 2023-01-01 00:00:00 | rent jan | Tax | Major | 975
2023-01-01 00:00:00 | rent jan | Global GF | Rental Income | 11000 |  | 2023-01-01 00:00:00 | rent jan | Global GF | Rental Income | 11000
2023-01-01 00:00:00 | rent jan | Global1 | Rental Income | 6534 |  | 2023-01-01 00:00:00 | rent jan | Global1 | Rental Income | 6534
2023-01-01 00:00:00 | rent jan | Global 2 | Rental Income | 5400 |  | 2023-01-01 00:00:00 | rent jan | Global 2 | Rental Income | 5400
2023-01-01 00:00:00 | rent jan | Global 3 | Rental Income | 6500 |  | 2023-01-01 00:00:00 | rent jan | Global 3 | Rental Income | 6500
2023-01-01 00:00:00 | rent jan | Capital Mall | Rental Income | 19409 |  | 2023-01-01 00:00:00 | rent jan | Capital Mall | Rental Income | 19409
2023-02-01 00:00:00 | feb rent | Selfi | Rental Income | 16500 |  | 2023-02-01 00:00:00 | feb rent | Selfi | Rental Income | 16500
2023-02-01 00:00:00 | feb rent | Major | Rental Income | 8124 |  | 2023-02-01 00:00:00 | feb rent | Major | Rental Income | 8124
2023-02-01 00:00:00 | feb rent | Tax | Major | 624 |  | 2023-02-01 00:00:00 | feb rent | Tax | Major | 624
2023-02-01 00:00:00 | feb rent | Global GF | Rental Income | 11000 |  | 2023-02-01 00:00:00 | feb rent | Global GF | Rental Income | 11000
2023-02-01 00:00:00 | feb rent | Global1 | Rental Income | 6534 |  | 2023-02-01 00:00:00 | feb rent | Global1 | Rental Income | 6534
2023-02-01 00:00:00 | feb rent | Global 2 | Rental Income | 5400 |  | 2023-02-01 00:00:00 | feb rent | Global 2 | Rental Income | 5400
2023-02-01 00:00:00 | feb rent | Global 3 | Rental Income | 6500 |  | 2023-02-01 00:00:00 | feb rent | Global 3 | Rental Income | 6500
2023-02-01 00:00:00 | feb rent | Capital Mall | Rental Income | 19415 |  | 2023-02-01 00:00:00 | feb rent | Capital Mall | Rental Income | 19415
Spreadsheet: 793249d1661363787-creating-a-results-list-of-multiple-races-finn-resultaten-2022-hd
Sheet: 14 aug

 |  | Place | 1e wedstrijd | 2e wedstrijd |  | place | sailnumber | points | points overall | count
 |  | 1 | 250 | 220 |  | 1 |  | 4 | 17
 |  | 2 | 147 | 147 |  | 2 | 250 | 4 | 16
 |  | 3 | 157 | 250 |  | 3 | 220 | 8 | 15
 |  | 4 | 140 | 960 |  | 4 | 145 | 11 | 14
 |  | 5 | 151 | 145 |  | 5 | 151 | 12 | 13
 |  | 6 | 145 | 108 |  | 6 | 960 | 12 | 12
 |  | 7 | 220 | 151 |  | 7 | 140 | 14 | 11
 |  | 8 | 960 | 113 |  | 8 | 157 | 14 | 10
 |  | 9 | 49 | 49 |  | 9 | 108 | 17 | 9
 |  | 10 | 47 | 140 |  | 10 | 49 | 18 | 8
 |  | 11 | 108 | 157 |  | 11 | 47 | 22 | 7
 |  | 12 | 2 | 47 |  | 12 | 113 | 23 | 6
 |  | 13 | 1018 | 1013 |  | 13 | 2 | 27 | 5
 |  | 14 | 150 | 150 |  | 14 | 150 | 28 | 4
 |  | 15 | 864 | 864 |  | 15 | 1013 | 28 | 3
 |  | 15 | 113 | 1018 |  | 16 | 1018 | 28 | 2
 |  | 15 | 1013 | 2 |  | 17 | 864 | 30 | 1
Spreadsheet: 106929d1304081209-concatenate-based-on-conditions-something-like-this-maybe-2
Sheet: Sheet1

id | info | count of id | unique list prepared using advanced filter/unique | concatenated list | formulas
Apple | R9 | Apple-1 | Apple | R9,R10 | R9 | R10
Mango | R9 | Mango-1 | Mango | R9,R10 | R9 | R10
Apple | R10 | Apple-2 | Apple | R9,R10 | R9 | R10
Orange | R8 | Orange-1 | Orange | R8,R9 | R8 | R9
Mango | R10 | Mango-2
Orange | R9 | Orange-2
Spreadsheet: 697982d1601652301-aging-formulas-example
Sheet: Example

 |  |  | Current | 31-60 Days | 61-90 Days | 91-120 Days | 121-150 Days | >151 Days |  | Current | 31-60 Days | 61-90 Days | 91-120 Days | 121-150 Days | >151 Days
 |  |  | 2020-09-01 00:00:00 | 2020-08-01 00:00:00 | 2020-07-01 00:00:00 | 2020-06-01 00:00:00 | 2020-05-01 00:00:00 | 2020-04-01 00:00:00 |  | 2020-09-01 00:00:00 | 2020-08-01 00:00:00 | 2020-07-01 00:00:00 | 2020-06-01 00:00:00 | 2020-05-01 00:00:00 | 2020-04-01 00:00:00
Order No | Accrual | Total Cost | Cost | Cost | Cost | Cost | Cost | Cost
PL765432 | 4991.33 | 5000.62 | 1250.155333333336 | 1250.155333333329 | 1250.155333333332 | 0 | 0 | 1250.155333333332 |  | 1250.155333333336 | 1250.155333333329 | 1250.155333333332 | 0 | 0 | 1240.86533333333
PL845762 | -2431.16 | -408011.81 | -285886.6300000001 | 13505.28999999999 | -18111.70999999999 | -41383.90999999999 | 11363.99999999987 | -87498.8499999999
PL846743 | 50000 | -10000 | -33195.39999999999 | 0 | 33195.39999999999 | 20000 | -30000 | 0
PL845744 | -5663.37 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 168722d1342550647-pivot-tables-for-surveys-workbook2
Sheet: Sheet1

 |  |  | These are formulas to get all answers in english from both survey languages
Language | Class # | Homeroom # | xx | xx | My professor explained the material in a way that was easy to understand. | xx | xx | My professor made me excited to learn. |  |  | response to q1 | response to q2 | response to q1 (spanish) | response to q2 (Spanish)
English | 1 | 100 |  |  |  |  |  |  |  |  | Agree | Strongly Agree
Spanish | 2 | 200 |  |  |  |  |  |  |  |  |  |  | [NAME] | De acuerdo
English | 3 | 300 |  |  |  |  |  |  |  |  | Neutral | Agree
English | 1 | 100 |  |  |  |  |  |  |  |  | Disagree | Strongly Disagree
Spanish | 1 | 100 |  |  |  |  |  |  |  |  |  |  | De acuerdo | Neutral
English | 1 | 200 |  |  |  |  |  |  |  |  | Agree | Disagree
English | 2 | 100 |  |  |  |  |  |  |  |  | Agree | Disagree
Spanish | 1 | 100 |  |  |  |  |  |  |  |  |  |  | Totalmente en desacuerdo | En desacuerdo
Language | (All)
Class # | (All)
Homeroom # | (All)
 | Values
Row Labels | Count of My professor explained the material in a way that was easy to understand. | Count of My professor made me excited to learn.
Agree | 4 | 4
Disagree | 2 | 2
Neutral | 1 | 1
Strongly Agree | 1 | 1
Disagree | 1 | 1
Strongly Disagree | 1 | 1
Neutral | 1 | 1
Agree | 1 | 1
Strongly Agree | 1 | 1
Agree | 1 | 1
Strongly Disagree | 1 | 1
Disagree | 1 | 1
Grand Total | 8 | 8
I want it to look like this
Language | (All) | When I change this option, I want the pivot table below to update as well
Class # | (All) | When I change this option, I want the pivot table below to update as well
Homeroom # | (All) | When I change this option, I want the pivot table below to update as well
Count of My professor explained the material in a way that was easy to understand.
Row Labels | Total
Agree | 4
Disagree | 1
Neutral | 1
Strongly Agree | 1
Strongly Disagree | 1
Grand Total | 8
Count of My professor made me excited to learn.
Row Labels | Total
Agree | 2
Disagree | 3
Neutral | 1
Strongly Agree | 1
Strongly Disagree | 1
Grand Total | 8
Spreadsheet: sally_beck__33888__Log as of 29 dec 00
Sheet: Sum Dec 27-Jan 2

 | Week summary (Dec 27- Jan 2)
Category | Description | Total |  | Breakdown of Cat 1
1 | Human Errors |  |  | Process in place but not followed
2 | IT Hardware problems |  |  | Officialized on time but needed recalc
3 | IT Software Problems |  |  | Book not officialized | 2
4 | Miscellaneous |  |  | No process in place
5 | Uncontrollable | 0 |  | Other | 1
 | Total |  |  | Total
 |  |  |  | Breakdown of Cat 2
 |  |  |  | Computer breakdown | 0
 |  |  |  | Other | 0
 |  |  |  | Total
 |  |  |  | Breakdown of Cat 3
 |  |  |  | Correct inputs, incorrect outputs
 |  |  |  | Slow feeds | 0
 |  |  |  | Feed problem
 |  |  |  | Books shown as officialized in ERMS, but not RiskTrac | 1
 |  |  |  | Application down alternate system used | 0
 |  |  |  | Other | 0
 |  |  |  | Total
 |  |  |  | Breakdown of Cat 4
 |  |  |  | Credit interface | 0
 |  |  |  | Other | 0
 |  |  |  | Total
Spreadsheet: 856856d1706030718-combining-data-from-multiple-sheets-into-one-ornateexpensesv2
Sheet: Inventory

S.N | Date | Product Name | Transaction Type | Quantity | Vendor/Customer | Note |  | Running Product Stock
1 |  | Apples | Purchase | 16940 | [NAME] |  |  | Apples
2 |  | Oranges | Purchase | 4720 | [NAME] |  |  | Oranges
3 |  | Grapes | Purchase | 18000 | [NAME] |  |  | Grapes
4 | 2023-12-23 00:00:00 | Apples | Sale | 150 | Yempi Farm
5 | 2023-12-23 00:00:00 | Oranges | Sale | 244 | Yempi Farm
6 | 2024-01-06 00:00:00 | Apples | Sale | 230 | Thamel Farm
7 | 2024-01-06 00:00:00 | Oranges | Sale | 439 | Thamel Farm
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
Spreadsheet: 5dc6a5a0-d583-40d2-b240-25609c6d6895
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
FFTGI | Test | FFTGI | [NAME] and IgM, CSF | [NAME] and IgM, CSF | Enzyme Linked Immunosorbent Assay (ELISA) | [NAME], sterile container: SrwStlCont |  |  | 1 | mL | 1.0 mL of spinal fluid sent refrigerated. | 0.5 mL | Specimens other than	CSF Anticoagulants other than	NA Hemolysis	NA Thawing	NA Lipemia	NA Icteric	NA | <0.90      INTERPRETIVE CRITERIA: 	<0.90         Antibody not detected 	0.9-1.09      Equivocal 	> or = 1.10   Antibody detected      Diagnosis of central nervous system infections can be accomplished by demonstrating the presence of intrathecally-produced specific antibody. Interpreting 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 | Tuesday, Friday | 1 day | 6 days |  | Profile |  |  |  |  | Focus Diagnositics, Inc.
FFTGI | [NAME] | CSF | CSF |  |  |  | Refrigerated
FFTGI | Result | Z0665 | [NAME] | [NAME] | Numeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
FFTGI | Result | Z0341 | T. Gondii IgM | T. Gondii IgM | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
FFTGI | Billing Component | FFTGI |  | T. Gondii IgM |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 86778
FFTGI | Billing Component | FFTGI |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 86777
Spreadsheet: 1720ad66-4992-4670-9100-d25c50125164
Sheet: Sheet1

Table 7--Peanuts:  U.S. supply and disappearance | 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
 | Area |  | Yield |  | Supply |  |  |  |  |  | Disappearance
Year begin. | Planted | Harvested |  | Beginning |  |  |  |  | Domestic |  | Seed & |  |  | Ending
Aug. 1 |  |  |  | stocks | Imports | Production | Total |  | food | Crush | residual | Exports | Total | stocks
 | ------1,000 acres-------- |  | Pounds/acre |  |  |  | Million pounds
2009/10 | 1116 | 1079 | 3421.362372567192 | 2130.1 | 71.9723171085282 | 3691.65 | 5893.722317108528 |  | 2674.875 | 434.61607 | 363.2314112794811 | 592.2518358290467 | 4064.974317108528 | 1828.748
2010/111 | 1288 | 1255 | 3312.223107569721 | 1828.748 | 64.5919124166918 | 4156.84 | 6050.179912416692 |  | 2839.7 | 586.553 | 502.4034567803826 | 605.5844556363093 | 4534.240912416692 | 1515.939
2011/122 | 1140.6 | 1097.6 | 3312.973760932945 | 1515.939 | 200 | 3636.32 | 5352.259 |  | 2990 | 575 | 377.259 | 525 | 4467.259 | 885
1 Estimated.  2 Forecast.
Sources: USDA, National Agricultural Statistics Service, Crop Production and Peanut Stocks and Processing,and U.S. Department of Commerce,
U.S. Census Bureau, Foreign Trade Statistics.
Last update: | 2012-04-12 14:11:44.590000
Spreadsheet: 761053d1640614000-income-by-location-sumproduct-pq_list_dates
Sheet: Sheet1

Check In Date | Check Out Date | Rate Per Day | Room
2021-01-01 00:00:00 | 2021-02-12 00:00:00 | 50 | Room A
2021-02-01 00:00:00 | 2021-02-18 00:00:00 | 75 | Room B
2021-04-01 00:00:00 | 2021-04-12 00:00:00 | 150 | Room C
2021-04-07 00:00:00 | 2021-04-19 00:00:00 | 50 | Room A
2021-06-11 00:00:00 | 2021-06-23 00:00:00 | 60 | Room D
Spreadsheet: 0631c420-49fc-4a05-ba9a-d9e70651e88d
Sheet: Sheet1

Table 6--Wholesale corn milling product and byproduct prices, 9/14/2012 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10
Mkt year and month 1/ | Corn meal, yellow,  Chicago, IL (dollars per cwt) |  | Corn meal, yellow,  New York, NY (dollars per cwt) |  | Corn starch,  Midwest 3/ (dollars per cwt) |  | Dextrose,  Midwest (cents per pound) |  | High-fructose corn syrup (42%),  Midwest (cents per pound)
 | 2010/11 | 2011/12 | 2010/11 | 2011/12 | 2010/11 | 2011/12 | 2010/11 | 2011/12 | 2010/11 | 2011/12
Sep | 20.339 | 27.9925 | 22.644 | 30.2975 | 15.43 | 23.25999999999999 | 31.2 | 30.85 | 17.375 | 21.375
Oct | 22.42 | 26.7825 | 24.725 | 29.0875 | 16.87 | 22.62999999999999 | 30.85 | 30.85 | 20.375 | 21.375
Nov | 22.435 | 26.8975 | 24.74 | 29.2025 | 18.28 | 20.04999999999999 | 30.85 | 30.85 | 21.375 | 21.375
Dec | 23.125 | 25.74 | 25.43 | 28.045 | 18.61 | 20.88999999999999 | 30.85 | 30.85 | 21.375 | 21.375
Jan | 24.0375 | 24.855 | 24.29 | 26.555 | 18.94 | 19.89999999999999 | 30.85 | 34.85 | 21.375 | 23.375
Feb | 26.94625 | 26.39833333333333 | 29.25125 | 30.37 | 20.23 | 21.39999999999999 | 30.85 | 33.85 | 21.375 | 23.375
Mar | 27.51 | 26.1675 | 29.815 | 27.92 | 21.48999999999999 | 21.78999999999999 | 30.85 | 35.85 | 21.375 | 23.375
Apr | 28.47125 | 25.5175 | 30.77625 | 27.545 | 21.31 | 22.08999999999999 | 30.85 | 34.85 | 21.375 | 23.375
May | 27.48833333333333 | 24.485 | 29.79333333333333 | 26.7675 | 22.72 | 21.33999999999999 | 30.85 | 34.85 | 21.375 | 23.375
Jun | 27.465 | 24.295 | 29.77 | 25.995 | 22.56999999999999 | 21.24999999999999 | 30.85 | 34.85 | 21.375 | 23.375
Jul | 28.24 | 28.345 | 30.545 | 30.045 | 23.31999999999999 | 20.64999999999999 | 30.85 | 35.35 | 21.375 | 23.375
Aug | 28.775 | 30.4625 | 31.08 | 32.1625 | 22.14999999999999 | 24.09999999999999 | 30.85 | 34.85 | 21.375 | 23.375
Mkt year 2/ | 25.60436111111111 | 26.49486111111111 | 27.73831944444444 | 28.66604166666667 | 20.16 | 21.61249999999999 | 30.87916666666667 | 33.55833333333334 | 20.95833333333333 | 22.70833333333333
1/ September-August. Latest month is preliminary. 2/ Simple average of monthly prices for the marketing year. 3/ Bulk-industrial, unmodified. Source: Milling and Baking News, except for corn starch which is from private industry.
Date run: 9/12/2012
Spreadsheet: darrell_schoolcraft__7824__imbalsumm0110
Sheet: PG&E

56698
Day | Measured | Scheduled
1 | -60142 | -59836
2 | -148602 | -148228
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
2001-09-30 00:00:00 |  |  | 73103
2001-10-02 00:00:00
CBS Dollars
 |  |  | -48870
Spreadsheet: 137817d1327399963-question-about-filling-a-column-if-cell-values-matches-a-specific-value-excelhelpsample1
Sheet: Sheet1

Pt Number | INJ_DATE | PROC_PR_LIST_AS_TEXT | Proc Location | procedures code
1 | 2001-01-01 00:00:00 | *Venous Catheterization, not [NAME], *Computerized Tomography, Head, *[NAME], Other Axial (Bone and Skeletal) | OR, OR, ER, | 11.11,  11.18, 11.13
2 | 2001-01-02 00:00:00 | *Venous Catheterization, not [NAME], *Venous Catheterization, not [NAME], | ER, | 11.11, 11.11
3 | 2001-01-03 00:00:00 | *Computerized Tomography, Thorax, *Computerized Tomography, Abdominal, *Computerized Tomography, Thorax | ER, ER, | 11.14, 11.15, 11.14
4 | 2001-01-04 00:00:00 | *Computerized Tomography, Other Axial (Bone and Skeletal), *Reduction, open, *Reduction, closed, | OR, OR, ER, ER, | 11.13, 11.16, 11.17
5 | 2001-01-05 00:00:00 | *Computerized tomography, [NAME], | OR, | 11.18
 |  | [NAME], NEC=11.11
 |  | CT Head=11.12
 |  | CT Other Axial=11.13
 |  | CT Thorax=11.14
 |  | CT Abdominal=11.15
 |  | Reduction Open=11.16
 |  | Reduction Closed=11.17
 |  | CT Head=11.18
Spreadsheet: 719521d1613702292-need-a-formula-to-divide-the-minutes-of-time-into-intervals-minute-splitter
Sheet: Sheet1

2021-02-19 14:39:51.249000
2021-02-19 00:55:42.628000
2021-02-19 02:26:04.552000
2021-02-19 01:00:19.716000
2021-02-19 10:00:13.200000
2021-02-19 12:10:36.970000
2021-02-19 12:45:41.727000
2021-02-19 09:00:04.284000
2021-02-19 12:33:56.434000
2021-02-19 11:58:30.905000
2021-02-18 19:07:31.736000
Spreadsheet: 91749d1291406072-tiered-payout-schedule-based-on-number-or-units-sold-example
Sheet: Sheet1

[NAME], [NAME] |  |  |  |  | Total Sales =
Month | New Memberships | [NAME] | Renewed Memberships | Monthly Totals | Year to Date | Amount Due | Paydate
January | 1
February
March | 1
April
May |  |  |  |  |  |  |  |  |  | 1-9 memberships sold pays $7.50
June | 0 | 1 |  |  |  |  |  |  |  | 10-19 Memberships sold pays $9.50
July | 1 |  |  |  |  |  |  |  |  | 20-29 Memberships sold pays $11.50
August | 4 | 1 |  |  |  |  |  |  |  | 30-39 Memberships sold pays $13.50
September | 2 |  |  |  |  |  |  |  |  | 40-49 Memberships sold pays $15.50
October |  |  |  |  |  |  |  |  |  | 50-infinity memberships sold pays $18.00
November
December
Date Sold | Sold                            By | Member                Name | Member Number | New Member | Upgrade Member | Renewel | Membership Amount | Date Received
2011-01-13 00:00:00 | [NAME], [NAME] |  |  | X
2011-02-12 00:00:00 | Jones, [NAME] |  |  |  | X
2011-03-01 00:00:00 | [NAME], [NAME] |  |  | X
2011-05-02 00:00:00 | Jones, [NAME] |  |  | X
2011-06-08 00:00:00 | [NAME], [NAME] |  |  |  | X
2011-07-12 00:00:00 | [NAME], [NAME] |  |  | X
2011-08-15 00:00:00 | [NAME], [NAME] |  |  | X
2011-08-18 00:00:00 | [NAME], [NAME] |  |  | X
2011-08-19 00:00:00 | [NAME], [NAME] |  |  | X
2011-08-21 00:00:00 | [NAME], [NAME] |  |  |  | X
2011-08-30 00:00:00 | [NAME], [NAME] |  |  | X
2011-09-02 00:00:00 | [NAME], [NAME] |  |  | X
2011-09-18 00:00:00 | [NAME], [NAME] |  |  | X
Spreadsheet: 149654d1334071541-selectable-list-box-form-control-not-activex-question-on-possible-use-list-box-example_2
Sheet: Sheet2

Name | Year | Helper Column |  |  |  |  |  | Lookup Table |  |  |  | Names
[NAME] | 2009 |  |  | < [NAME] (green cells) |  |  |  | Cell Link | Index | Year |  |  |  | < [NAME] (grey cells)
[NAME] | 2009 |  |  |  |  |  |  | 1 | 1 | 2009 |  |  |  | * Entered with CTRL+SHIFT+ENTER
[NAME] | 2009 |  |  |  |  |  |  |  | 2 | 2010 |  |  |  | * You need to allow enough formulas to cover your potential list of names.
[NAME] | 2010 |  |  |  |  |  |  |  |  |  |  |  |  | * This example returns up to 6 names.
[NAME] | 2010 |  |  |  |  |  |  |  |  |  |  |  |  | * No helper column needed.
[NAME] | 2010
 |  |  |  |  |  |  |  |  |  |  |  |  |  | < [NAME] alternative formulas (green cells).
 |  |  |  |  |  |  |  |  |  |  |  |  |  | * Needs helper column.
 |  |  |  | * 2 Named ranges created for List Boxes: Year and Names (dynamic).
Spreadsheet: 349484d1412346328-conditional-formatting-that-populates-text-as-well-as-colour-book3
Sheet: Sheet1

Impact & Complexity Matrix |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Optional | Low
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Risk Based | Med
 |  | Complexity |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Full | High
 |  | Low | Med | High
Impact | Major | Risk-based | Risk-based | Full
 | Significant | Risk-based | Risk-based | Full
 | Moderate | Optional | Optional | Risk-based
 | Minor | Optional | Optional | Risk-based
 | Non-significant | Optional | Optional | Risk-based
Determine requirement for NFT planning based on Impact and complexity of the change
Application Impact >>> |  | Moderate
Release Complexity >>> |  | Low