tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 684897d1593607839-time-calculation-gives-false-test-sheet
Sheet: Main Billing

CHARGE SHEET - 16-31 MAY 2020
 |  |  |  |  |  |  |  |  |  |  |  |  | ADDITIONAL CHARGE(S) OVER SLA AGREEMENT |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | STANDARD SLA AGREEMENT EQUIPMENT / PERSONNEL |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CALCULATION OF EXTRA CHARGES
1 | Date | Airline | Aircraft Type | Start Time | Finish Time | Time Spent | Balance of Time Remaining from SLA | Additional Turnaround Time | Total Hours Chargeable | VIP (1:30) VVIP (4:00) | Type | Total Time Handling | Steps | Tug Dollies | High Loader | Belt Loader | Maintanance Steps | Extra ManPower | Pushback / Headset | Towing | Air Starter | Ground Power Unit | Rubbish Per Bag | Portable Scale | [NAME] | [NAME] | Crew Transport | Cost £ | Fixed Turnaround Charge | Total Charges | COMMENTS | Steps | Tug Dollies | High Loader | Belt Loader | [NAME] | Extra ManPower | Pushback / Headset | Towing | Air Starter | Ground Power Unit | Rubbish Per Bag | Portable Scale | [NAME] | [NAME] | Crew Transport |  | Steps | Tug Dollies | High Loader | Belt Loader | [NAME] | Extra ManPower | Pushback / Headset | Towing | Air Starter | Ground Power Unit | Rubbish Per Bag | Portable Scale | [NAME] | [NAME] | Crew Transport
[NAME] | 2020-05-30 00:00:00 | yyy | 123 | 09:30:00 | 11:30:00 |  |  |  |  | 01:30:00 | 0
Extra Equipment Within SLA
Departure | 2020-05-30 00:00:00 | yyy | 321
Extra Equipment Within SLA
Maintenance
 |  |  |  |  |  |  |  |  |  |  |  |  | ADDITIONAL CHARGE(S) OVER SLA AGREEMENT |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | STANDARD SLA AGREEMENT EQUIPMENT / PERSONNEL |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CALCULATION OF EXTRA CHARGES
2 | Date | Airline | Aircraft Type | Start Time | Finish Time | Time Spent | Balance of Time Remaining from SLA | Additional Turnaround Time | Total Hours Chargeable | VIP (1:30) VVIP (4:00) | Type | Total Time Handling | Steps | Tug Dollies | High Loader | Belt Loader | Maintanance Steps | Extra ManPower | Pushback / Headset | Towing | Air Starter | Ground Power Unit | Rubbish Per Bag | Portable Scale | [NAME] | [NAME] | Crew Transport | Cost £ | Fixed Turnaround Charge | Total Charges | COMMENTS | Steps | Tug Dollies | High Loader | Belt Loader | [NAME] | Extra ManPower | Pushback / Headset | Towing | Air Starter | Ground Power Unit | Rubbish Per Bag | Portable Scale | [NAME] | [NAME] | Crew Transport |  | Steps | Tug Dollies | High Loader | Belt Loader | [NAME] | Extra ManPower | Pushback / Headset | Towing | Air Starter | Ground Power Unit | Rubbish Per Bag | Portable Scale | [NAME] | [NAME] | Crew Transport
[NAME] | 2020-05-31 00:00:00 | yyy | 123 | 10:00:00 | 11:30:00 |  |  |  |  | 01:30:00 | 0
Extra Equipment Within SLA
Departure | 2020-05-31 00:00:00 | yyy | 321 | 16:00:00 | 17:00:00
Extra Equipment Within SLA
Maintenance
Spreadsheet: 762496d1641577833-combine-columns-in-two-filter-functions-book2-1-
Sheet: Sheet1

Fruits | Price | Date | Pieces |  |  | Fruits | Date | Pieces
Apple | 5 | 2022-12-01 00:00:00 | 50 |  | From |  | 2022-12-01 00:00:00 | 50 |  |  |  | 2022-12-01 00:00:00 | 50 |  |  | 44896 | 50
Apple | 5 | 2022-12-02 00:00:00 | 50 |  |  | Apple | 2022-12-02 00:00:00 | 50 |  | to | Apple | 2022-12-02 00:00:00 | 50 |  | Apple | 44897 | 50
Lemon | 3 | 2022-12-01 00:00:00 | 50 |  |  |  |  |  |  |  |  | 2022-12-01 00:00:00 | 25
 |  |  |  |  |  |  |  |  |  |  | Tomato | 2022-12-08 00:00:00 | 20
 |  |  |  |  |  |  | 2022-12-01 00:00:00 | 25
 |  |  |  |  |  | Tomato | 2022-12-08 00:00:00 | 20 |  |  |  | 2022-12-01 00:00:00 | 50
 |  |  |  |  |  |  |  |  |  |  | Apple | 2022-12-02 00:00:00 | 50
 |  |  |  |  |  |  |  |  |  |  | Tomato | 2022-12-01 00:00:00 | 25
 |  |  |  |  |  | Vegs | Price | Date | Pieces |  | Tomato | 2022-12-08 00:00:00 | 20
 |  |  |  |  |  | Tomato | 5 | 2022-12-01 00:00:00 | 25
 |  |  |  |  |  | Lettuce | 5 | 2022-12-02 00:00:00 | 30
 |  |  |  |  |  | Tomato | 3 | 2022-12-08 00:00:00 | 20
Spreadsheet: 789319d1659036215-count-instances-of-x-in-multiple-cells-not-in-a-range-per-diem-tracker-example
Sheet: Sheet1

Driver Per-diem & Container - Week Ending 7-29-2022
Driver | Saturday |  |  | Sunday |  |  | Monday |  |  | Tuesday |  |  | Wednesday |  |  | Thursday |  |  | Friday |  |  | Total |  |  | Payout
 | PD | CD | CS | PD | CD | CS | PD | CD | CS | PD | CD | CS | PD | CD | CS | PD | CD | CS | PD | CD | CS | PD | CD | CS
Driver A |  |  |  |  |  |  | X |  |  | X |  |  | X |  |  | X |  |  | X
Driver B |  |  |  |  |  |  | X |  |  | X |  |  | X |  |  | X
Driver A |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | X
Driver B |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | X
Driver A |  |  |  |  |  |  |  |  |  |  |  |  | X |  |  |  |  |  | X
Driver B |  |  |  | X |  |  |  |  |  |  |  |  | X
Driver A |  |  |  |  |  |  | X |  |  | X |  |  | X |  |  | X
Driver B | X |  |  | X |  |  | X |  |  | X |  |  | X |  |  | X |  |  | X
Driver A |  |  |  |  |  |  |  |  |  |  |  |  | X |  |  | X
Driver B |  |  |  |  |  |  |  |  |  | X
Driver A
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTALS
Spreadsheet: 582403d1531859407-unwanted-printing-of-headings-account-balances
Sheet: Summary (2)

Due | Yokohama | Nokian | Michelin | Falken | [NAME] | Bridgestone | Totals
Dates |  |  |  |  | Tire
2018-07-20 00:00:00
2018-07-24 00:00:00 |  |  | 2861.3
2018-07-25 00:00:00 |  | 54007.72
2018-08-05 00:00:00
2018-08-10 00:00:00 |  |  |  | 826573.55
2018-08-15 00:00:00 |  | 34133.57 |  |  |  | 447971.12
2018-08-20 00:00:00
2018-08-25 00:00:00 |  | 20254.16
2018-09-01 00:00:00 |  | 33100.22
2018-09-05 00:00:00
2018-09-10 00:00:00 |  |  |  | 1018055.45 | 21347
2018-09-15 00:00:00 | 195182.48 |  |  |  |  | 53860.38
2018-09-20 00:00:00
2018-09-25 00:00:00
2018-10-05 00:00:00 |  | 67197.92
2018-10-10 00:00:00 |  |  |  | 929339.5
2018-10-15 00:00:00 | 1847.79
2018-10-25 00:00:00 |  | 78200.15
2018-11-01 00:00:00
2018-11-10 00:00:00 |  | 69598.24 |  | 88903.77
2018-11-20 00:00:00 |  | 70474.72
2018-12-01 00:00:00
2018-12-05 00:00:00
2018-12-15 00:00:00
2018-12-20 00:00:00 |  | 264.31
2018-12-25 00:00:00 |  | 87329.6
2019-01-01 00:00:00 |  | 76871.6
2019-01-05 00:00:00 |  | 50300.04
Totals
Spreadsheet: 26739d1219152769-only-print-select-certain-rows-book2
Sheet: Sheet1

A | B
2008-08-19 00:00:00 | 1
2008-08-20 00:00:00 | 2
2008-08-21 00:00:00 | 3
2008-08-22 00:00:00 | 4
2008-08-23 00:00:00 | 5
2008-08-24 00:00:00 | 6
2008-08-25 00:00:00 | 7
2008-08-26 00:00:00 | 8
2008-08-27 00:00:00 | 9
2008-08-28 00:00:00 | 10
2008-08-29 00:00:00 | 11
2008-08-30 00:00:00 | 12
2008-08-31 00:00:00 | 13
2008-09-01 00:00:00 | 14
2008-09-02 00:00:00 | 15
2008-09-03 00:00:00 | 16
2008-09-04 00:00:00 | 17
2008-09-05 00:00:00 | 18
2008-09-06 00:00:00 | 19
2008-09-07 00:00:00 | 20
2008-09-08 00:00:00 | 21
2008-09-09 00:00:00 | 22
2008-09-10 00:00:00 | 23
2008-09-11 00:00:00 | 24
2008-09-12 00:00:00 | 25
2008-09-13 00:00:00 | 26
2008-09-14 00:00:00 | 27
2008-09-15 00:00:00 | 28
2008-09-16 00:00:00 | 29
2008-09-17 00:00:00 | 30
2008-09-18 00:00:00 | 31
2008-09-19 00:00:00 | 32
2008-09-20 00:00:00 | 33
2008-09-21 00:00:00 | 34
2008-09-22 00:00:00 | 35
2008-09-23 00:00:00 | 36
2008-09-24 00:00:00 | 37
2008-09-25 00:00:00 | 38
2008-09-26 00:00:00 | 39
2008-09-27 00:00:00 | 40
2008-09-28 00:00:00 | 41
2008-09-29 00:00:00 | 42
2008-09-30 00:00:00 | 43
2008-10-01 00:00:00 | 44
2008-10-02 00:00:00 | 45
2008-10-03 00:00:00 | 46
2008-10-04 00:00:00 | 47
2008-10-05 00:00:00 | 48
2008-10-06 00:00:00 | 49
Spreadsheet: 829647d1684346851-creating-an-automatic-list-of-unique-values-in-a-range-create-a-list-of-unique-values
Sheet: Sheet1

 | DATA |  |  |  |  |  | EXPECTED RESULTS
 |  |  |  |  |  |  |  | M |  | E |  | N
 |  |  |  |  |  |  |  | M-01 |  | E-01 |  | N-01
 |  |  |  |  |  |  |  | M-02 |  | E-02 |  | N-02
 | M-01-141 | M-02-143 |  | M-03-145 | M-04-147 |  |  | M-03 |  | E-03 |  | N-03
 | M-01-152 | M-02-154 |  | M-03-156 | M-04-158 |  |  | M-04 |  | E-04 |  | N-04
 | M-01-185 | M-02-187 |  | M-03-189 | M-04-191 |  |  |  |  | E-05 |  | N-05
 | M-01-196 | M-02-198 |  | M-03-200 | M-04-202
 | M-01-229 | M-02-231 |  | M-03-233 | M-04-235
 | M-01-240 | M-02-242 |  | M-03-244 | M-04-246
 | E-01-275 | E-02-277 | E-03-279 | E-04-281 | E-05-283
 | E-01-286 | E-02-288 | E-03-290 | E-04-292 | E-05-294
 | E-01-325 | E-02-327 | E-03-329 | E-04-331 | E-05-333
 | E-01-336 | E-02-338 | E-03-340 | E-04-342 | E-05-344
 | E-01-375 | E-02-377 | E-03-379 | E-04-381 | E-05-383
 | E-01-386 | E-02-388 | E-03-390 | E-04-392 | E-05-394
 | E-01-425 | E-02-427 | E-03-429 | E-04-431 | E-05-433
 | N-01-436 | N-02-438 | N-03-440 | N-04-442 | N-05-444
 | N-01-469 | N-02-471 | N-03-473 | N-04-475 | N-05-477
 | N-01-470 | N-02-DTABA | N-03-472 | N-04-474 | N-05-ABA TR7
 | N-01-DTSLM |  | N-03-DTSLM | N-04-DTSLM
Spreadsheet: f5b2309a-50ab-485b-b1ca-eb802ba094ff
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
CINP | Test | CINP | Cortisol, Serum, LC-MS/MS | Cortisol, S, LC-MS/MS | Liquid Chromatography-Tandem Mass Spectrometry (LC-MS/MS) | Plain, Red-Top Tube: Red |  |  | 0.6 | mL | Container/Tube: Red top [NAME]: 0.6 mL Collection Instructions: Morning (8 a.m.) and afternoon (4 p.m.) specimens are preferred. Additional Information: 1. Include time of draw. 2. If multiple specimens are drawn, send separate order for each specimen. | 0.25 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm OK; Cold OK  Lipemia	Mild OK; Gross reject Icterus	Mild OK; [NAME] OK Other	Serum gel tube | 5-25 mcg/dL (a.m.) 2-14 mcg/dL (p.m.) Pediatric reference ranges are the same as adults, as confirmed by peer-reviewed literature.   Petersen KE: ACTH in normal children and children with pituitary and adrenal diseases. [NAME] in plasma by radioimmunoassay-basal values. Acta Paediatr Scand 1981;70:341-345 | Monday through Friday; 2 p.m. | 2 days | 5 days | 1 | 82533 |  |  |  |  | Rochester
CINP | [NAME] | SRED | Serum Red |  |  |  | Refrigerated | 7 days
CINP | Order Question | COLT2 | Collection Time in Military Time |  | Plain Text
CINP | Result | 84279 | Cortisol, S, LC-MS/MS | Cortisol, S, LC-MS/MS | Numeric |  |  |  |  | mcg/dL |  |  |  |  |  |  |  |  |  | 2143-6
CINP | Result | 23606 | AM Cortisol | AM Cortisol | Numeric |  |  |  |  | mcg/dL |  |  |  |  |  |  |  |  |  | 9813-7
CINP | Result | 23607 | PM Cortisol | PM Cortisol | Numeric |  |  |  |  | mcg/dL |  |  |  |  |  |  |  |  |  | 9812-9
Spreadsheet: 162437d1339873125-help-with-calculations-in-a-meal-plan-ukentlig-m-ltidskalender-ny-for-teste-utregning
Sheet: Ark1

Matvare | Protein | [NAME] | Karbohydrater | Kalorier
Egg | 24 | 15 | 0 | 80
Brokkoli | 0.1 | 92 | 55 | 888
Blomkål | 0.02 | 87 | 55 | 145
2 | Egg | 48 | 30 | 0 | 160
22 | Brokkoli | 2.2
100 | Blomkål | 2
 |  | 52.2
Spreadsheet: c8ea7a43-8474-4c89-8ced-bb19bbb79521
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
263473 | 60934 | [NAME] | [NAME] | USA |  | 00:12:37 | 00:01:18 | 00:33:26 | 00:01:29 | 00:22:45 | 2 | [NAME]
263473 | 53761 | [NAME] | Johnston | USA |  | 00:13:27 | [NAME] | 00:34:36 | 00:01:38 | 00:21:40 | 3 | 01:12:51
263473 | 74791 | [NAME] | Koehler | USA |  | 00:13:38 | 00:01:55 | 00:35:42 | 00:02:02 | 00:20:21 | 4 | 01:13:39
263473 | 74792 | [NAME] | Ortiz | USA |  | 00:14:43 | 00:02:06 | 00:35:23 | 00:02:01 | 00:19:41 | 5 | 01:13:56
263473 | 13652 | JP | Theberge | USA |  | 00:13:09 | 00:01:37 | 00:32:43 | 00:01:43 | 00:22:03 | 1 | 01:11:16
Spreadsheet: 125368d1318992314-reverse-data-in-cell-name_rearrange
Sheet: CIP

CIP  Period Name : 'SEP-12' , Period Year : '2012'  18-OCT-11  05.04.30 PM
Subjective Code and Name:785100 ~ NON PAY SAVINGS TARGET |  |  | 1000
Cost Centre Code | Subjective Code | Sub Analysis Code | Annual Budget SUM 1 3 | Current Month Budget SUM 1 3 | Ytd Budget SUM 1 3
871130 | 785100 | 0000 | 1000 | 1000 | 1000
871224 | 785100 |  | 1000 | 1000 | 1000
871234 | 785100 |  | 1000 | 1000 | 1000
871303 | 785100 |  | 1000 | 1000 | 1000
871316 | 785100 |  | 1000 | 1000 | 1000
871333 | 785100 |  | 1000 | 1000 | 1000
871339 | 785100 |  | 1000 | 1000 | 1000
872111 | 785100 |  | 1000 | 1000 | 1000
873112 | 785100 |  | 1000 | 1000 | 1000
873410 | 785100 |  | 1000 | 1000 | 1000
873602 | 785100 |  | 1000 | 1000 | 1000
873606 | 785100 |  | 1000 | 1000 | 1000
874100 | 785100 |  | 1000 | 1000 | 1000
874402 | 785100 |  | 1000 | 1000 | 1000
874403 | 785100 |  | 1000 | 1000 | 1000
874503 | 785100 |  | 1000 | 1000 | 1000
874602 | 785100 |  | 1000 | 1000 | 1000
875104 | 785100 |  | 1000 | 1000 | 1000
875405 | 785100 |  | 1000 | 1000 | 1000
875408 | 785100 |  | 1000 | 1000 | 1000
875502 | 785100 |  | 1000 | 1000 | 1000
875604 | 785100 |  | 1000 | 1000 | 1000
875610 | 785100 |  | 1000 | 1000 | 1000
876000 | 785100 |  | 1000 | 1000 | 1000
876200 | 785100 |  | 1000 | 1000 | 1000
876300 | 785100 |  | 1000 | 1000 | 1000
876334 | 785100 |  | 1000 | 1000 | 1000
876336 | 785100 |  | 1000 | 1000 | 1000
876337 | 785100 |  | 1000 | 1000 | 1000
876360 | 785100 |  | 1000 | 1000 | 1000
876363 | 785100 |  | 1000 | 1000 | 1000
876367 | 785100 |  | 1000 | 1000 | 1000
876368 | 785100 |  | 1000 | 1000 | 1000
876396 | 785100 |  | 1000 | 1000 | 1000
876399 | 785100 |  | 1000 | 1000 | 1000
876422 | 785100 |  | 1000 | 1000 | 1000
877001 | 785100 |  | 1000 | 1000 | 1000
877003 | 785100 |  | 1000 | 1000 | 1000
877031 | 785100 |  | 1000 | 1000 | 1000
877032 | 785100 |  | 1000 | 1000 | 1000
877042 | 785100 |  | 1000 | 1000 | 1000
877113 | 785100 |  | 1000 | 1000 | 1000
877220 | 785100 |  | 1000 | 1000 | 1000
 |  | Sum | 1000 | 1000 | 1000
Grand Total |  |  | 1000 | 1000 | 1000
Spreadsheet: 599823d1543324117-vlookup-isnt-quite-going-to-plan-50-product-sample-ans
Sheet: Sheet1

Price Export  (A) |  |  |  | Stock Level Export (B)
Product Number | Price | Stock Quantity |  | Product Number | Stock Quantity
1 | 10 |  |  | 1 | 45
2 |  |  |  | 2 | 14
3 | 8 |  |  | 3 | 30
4 |  |  |  | 4 | 49
5 | 6 |  |  | 5 | 27
6 | 5 |  |  | 6 | 2
7 | 8 |  |  | 7 | 3
8 | 6.5 |  |  | 8 | 3
9 | 6.5 |  |  | 9 | 10
10 | 6.5 |  |  | 10 | 1
11 |  |  |  | 11 | 1
12 | 78 |  |  | 14 | 1
13 | 80 |  |  | 15 | 2
14 | 5.5 |  |  | 100 | 560
15 | 8.7 |  |  | 100 | 3
16 | 6 |  |  | 501 | -2
100 | 6 |  |  | 502 | -1
200 | 6 |  |  | 503 | -1
201 |  |  |  | 506 | -1
202 |  |  |  | 508 | -10
500 |  |  |  | 509 | -6
501 |  |  |  | 510 | 11
502 |  |  |  | 511 | 4
503 |  |  |  | 512 | -6
504 |  |  |  | 513 | 10
505 |  |  |  | 514 | -28
506 |  |  |  | 515 | -3
507 |  |  |  | 516 | 5
508 |  |  |  | 517 | 1
509 |  |  |  | 518 | 4
510 | 7.5 |  |  | 519 | 5
511 |  |  |  | 520 | 7
512 | 7.2 |  |  | 521 | 3
513 | 7.2 |  |  | 550 | 8
514 | 7.2 |  |  | 551 | 7
515 | 7.8 |  |  | 552 | 8
516 |  |  |  | 553 | 3
517 |  |  |  | 554 | -1
518
519
520
521
550
551
552
553
554
555
556 | 10
Spreadsheet: 821485d1678741140-create-a-rolling-60-minute-window-to-assess-busiest-time-period-rolling60minsample
Sheet: Sheet1

Time Series | Time | Occurences | Rolling 60 minute total?
2019-06-15 00:00:00 | 0005 | 4
2019-06-15 00:00:00 | 0005 | 5
2019-06-15 00:00:00 | 0010 | 5
2019-06-15 00:00:00 | 0010 | 4
2019-06-15 00:00:00 | 0010 | 5
2019-06-15 00:00:00 | 0010 | 2
2019-06-15 00:00:00 | 0010 | 9
2019-06-15 00:00:00 | 0020 | 1
2019-06-16 00:00:00 | 0030 | 2
2019-06-16 00:00:00 | 0045 | 1
2019-06-16 00:00:00 | 0105 | 13
2019-06-16 00:00:00 | 0105 | 13
2019-06-16 00:00:00 | 0105 | 13
2019-06-16 00:00:00 | 0210 | 1
2019-06-16 00:00:00 | 0430 | 31
2019-06-16 00:00:00 | 0510 | 31
2019-06-17 00:00:00 | 0510 | 31
2019-06-18 00:00:00 | 0510 | 26
2019-06-19 00:00:00 | 0525 | 1
2019-06-20 00:00:00 | 0530 | 30
2019-06-20 00:00:00 | 0530 | 30
2019-06-20 00:00:00 | 0530 | 31
2019-06-20 00:00:00 | 0530 | 31
2019-06-20 00:00:00 | 0530 | 26
2019-06-20 00:00:00 | 0540 | 31
2019-06-20 00:00:00 | 0540 | 21
2019-06-21 00:00:00 | 0540 | 23
2019-06-21 00:00:00 | 0540 | 16
2019-06-21 00:00:00 | 0540 | 1
2019-06-21 00:00:00 | 0550 | 25
2019-06-21 00:00:00 | 0550 | 8
2019-06-21 00:00:00 | 0550 | 31
2019-06-21 00:00:00 | 0600 | 3
2019-06-21 00:00:00 | 0600 | 29
2019-06-21 00:00:00 | 0620 | 31
2019-06-21 00:00:00 | 0620 | 21
2019-06-21 00:00:00 | 0620 | 20
2019-06-21 00:00:00 | 0625 | 1
2019-06-21 00:00:00 | 0630 | 1
2019-06-22 00:00:00 | 0630 | 7
2019-06-23 00:00:00 | 0630 | 28
2019-06-23 00:00:00 | 0630 | 30
2019-06-23 00:00:00 | 0630 | 31
2019-06-23 00:00:00 | 0630 | 31
2019-06-23 00:00:00 | 0630 | 31
2019-06-23 00:00:00 | 0630 | 28
2019-06-23 00:00:00 | 0635 | 9
2019-06-23 00:00:00 | 0640 | 30
2019-06-23 00:00:00 | 0645 | 8
2019-06-23 00:00:00 | 0645 | 8
Spreadsheet: 68911d1269444053-request-create-suitable-table-and-formula-upon-some-data-stock-ability3
Sheet: Sheet1

 | Machine | Burner 1 | Burner 2 | Burner 3 | Burner 4
 | start time | 2010-10-04 01:00:00 | 2010-10-05 05:00:00 | 2010-10-06 03:00:00 | STOP | 1
 | 1st CD | 2010-10-04 11:00:00 | 2010-10-05 15:00:00 | 2010-10-06 13:00:00 | #N/A | 0
 | 2nd CD | waiting | waiting | waiting | waiting | -1
 | 3rd CD | waiting | waiting | waiting | waiting | -2
 | 4th CD | waiting | waiting | waiting | waiting | -3
 | 5th CD | waiting | waiting | waiting | waiting | -4
 | 6th CD | waiting | waiting | waiting | waiting | -5
 | 7th CD | waiting | waiting | waiting | waiting | -6
 | 8th CD | waiting | waiting | waiting | waiting | -7
 | 9th CD | waiting | waiting | waiting | waiting | -8
 | 10th CD | waiting | waiting | waiting | waiting | -9
 | 1 CD TIME (HOURS) |  | 10
TOTAL CD            : |  | 4 | 1 | -2 | -5 | -8 | -11 | -14 | -17 | -20 | -23 | -26 | -29 | -32 | -35 | -38 | -41 | -44 | -47 | -50 | -53 | -56 | -59 | -62 | -65 | -68 | -71 | -74 | -77 | -80 | -83 | -86 | -89 | -92 | -95 | -98 | -101 | -104 | -107 | -110 | -113 | -116 | -119 | -122 | -125 | -128 | -131 | -134 | -137 | -140 | -143 | -146 | -149 | -152 | -155 | -158 | -161 | -164 | -167 | -170 | -173 | -176 | -179 | -182 | -185 | -188 | -191 | -194 | -197 | -200 | -203 | -206 | -209 | -212 | -215 | -218 | -221 | -224 | -227 | -230 | -233 | -236 | -239 | -242 | -245 | -248 | -251 | -254 | -257 | -260 | -263 | -266 | -269 | -272 | -275 | -278 | -281 | -284 | -287 | -290 | -293 | -296 | -299 | -302 | -305 | -308 | -311 | -314 | -317 | -320 | -323 | -326 | -329 | -332 | -335 | -338 | -341 | -344 | -347 | -350 | -353 | -356 | -359 | -362 | -365 | -368 | -371 | -374 | -377 | -380 | -383 | -386 | -389 | -392 | -395 | -398 | -401 | -404 | -407 | -410 | -413 | -416 | -419
EACH BURNER CD QTTY : |  | 1
EACH PRODUCT ABILITY TIME BURNER: |  | 10
BALANCE AFTER DVIDE : |  | 1
TOTAL WIP |  | 4
TOTAL MACHINE |  | 3
Spreadsheet: 204566d1357577292-issue-with-vlookup-cannot-add-times-to-make-a-total-timesheet_aa
Sheet: Sheet18

[NAME] (0700-1500) |  | 1
Evening (1500-2300) |  | 2
Night (2300-0700) |  | 3
REB (0730-1600) |  | 4
--------------------- |  | 5
Day (0700-1900) |  | 6
Night (1900-0700) |  | 7
--------------------- |  | 8
[NAME] (1700-2100) |  | 9
Escort (0900-2100) |  | 10
--------------------- |  | 11
EXTRA |  | 12
SICK DAY
BOOKED OFF
Spreadsheet: 159272d1338565474-fill-cell-color-due-to-referenced-cell-value-sample
Sheet: capacity

BUYER |  |  |  |  |  |  | ITEM
STYLE |  |  |  |  |  |  | NO OF WORKERS
 |  |  |  |  |  |  | TARGET
 |  |  |  | S/N
 |  |  |  | O/L
 |  |  |  | 3T O/L
 |  |  |  | 4T O/L
 |  |  |  | 5T O/L
 |  |  |  | F/L
 |  |  |  | PICOT
 |  |  |  | HEL
 |  |  |  | D/N
NO | OPERATOR | OPERATION |  | M/C | S.M.V | REQ | CYCLE TIME |  |  |  |  | RATING | AVG | CAPA |  | REQ | ALLOW | REQ EFF | TIME | ACT EFF |  | OP | PRO
 |  |  |  |  |  |  | 1 | 2 | 3 | 4 | 5 |  | CYCLE |  |  | MIN | MIN |  |  |  |  | NO
1
2
3
4
5
6
7
8
9 |  |  |  |  |  |  | 15 | 15 | 16 |  | 18
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
 |  |  | TOTAL
Spreadsheet: 173122d1344440946-split-string-in-text-and-numbers-nbvc-made-it-today-on-this-forum-ef151_splt-text-an-numbers-out-of-a-string-oeldere-
Sheet: Blad1

7D
7.5D
8D
8.5D
9D
9.5D
10EW
10.5EW
11EW
11.5EW
12EW
13EW
Need it to read
"7" Next Column "D"
"7.5" Next Column "D"
"8" Next Column "D"
So on and so forth.
Gemaakt door NBVC op excelforum.com [NAME]. woensdag 08-08-2012
http://www.excelforum.com/excel-general/674193-split-cells-based-on-letters-vs-numbers.html
 |  | =SUBSTITUTE(A1,B1,"")
Spreadsheet: 213772d1360645905-show-data-based-from-selected-parameters-in-drop-down-dropdown
Sheet: Sheet1

MONTH |  | JANUARY 2013
BRANCH |  | Branch9 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | JANUARY 2013 |  |  | Branch1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FEBRUARY 2013 |  |  | Branch2
PRODUCTS | BRANCH |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MARCH 2013 |  |  | Branch3
Product1 |  |  |  |  |  |  | Fill the figures based from the selected parameters  All DATA from Source tab |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | APRIL 2013 |  |  | Branch4
Product2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MAY 2013 |  |  | Branch5
Product3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | JUNE 2013 |  |  | Branch6
Product4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | JULY 2013 |  |  | Branch7
Product5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AUGUST 2013 |  |  | Branch8
Product6 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SEPTEMBER 2013 |  |  | Branch9
Product7 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | OCTOBER 2013
Product8 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NOVEMBER2013
Product9
Product10
Product11
Product12
Product13
Spreadsheet: 836441d1689355147-combining-formulas-help
Sheet: Project Commitments

 |  |  |  | Commercial Customers
 |  |  |  | Wholesale Customers
 |  |  |  | Total Commercial Capex
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Year to Date
 |  |  | Project Number | Work Order Number | Project Site Name | Program | January | February | March | April | May | June | July | August | September | October | November | December |  | Approved | Status | Projects Completed | Projects Inflight | Approved  (Open Projects) | Committed  (Open Projects) | Total Committed |  | Invested | Budget | [NAME]
 |  |  | A-012345
 |  |  | A-012346
 |  |  | A-012347
 |  |  | [NAME]
 |  |  | A-012349
 |  |  | A-012350
 |  |  | A-012351
 |  |  | A-012352
 |  |  | A-012353
 |  |  | A-012354
 |  |  | A-012355
 |  |  | A-012356
 |  |  | A-012357
Spreadsheet: 755063d1636647907-formula-that-tells-me-if-the-temp-has-exceed-a-temp-of-2-degrees-for-more-than-an-hour-temp
Sheet: Sheet1

Date | counter1 | Above 2 | for more than 1hr |  |  | Results
14/07/2021 20:00 | 2.599999904632568
14/07/2021 21:30 | 2.400000095367432
14/07/2021 21:45 | 2.099999904632568
17/07/2021 18:45 | 2.099999904632568
17/07/2021 20:15 | 2.299999952316284
13/08/2021 19:45 | 2.099999904632568
13/08/2021 20:00 | 2.400000095367432
13/08/2021 20:15 | 2.400000095367432
13/08/2021 20:30 | 2.599999904632568
13/08/2021 20:45 | 2.599999904632568
13/08/2021 21:00 | 2.400000095367432
18/08/2021 07:45 | 2.200000047683716
23/08/2021 09:45 | 2.099999904632568