tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 882237d1730508281-excel-date-range-adding-zero-value-in-missing-date-ef1657_excel-missing-date-with-value
Sheet: Sheet1

Actual |  |  |  |  |  |  | Expected
Date | Value |  |  |  |  |  | Date | Value
01/02/2024 | 750 |  |  |  |  |  | 2024-02-01 00:00:00 | 750
02/02/2024 | 38 |  |  |  |  |  | 2024-02-02 00:00:00 | 38+50
02/02/2024 | 50 |  |  |  |  |  | 2024-02-03 00:00:00 | 9275
03/02/2024 | 9275 |  |  |  |  |  | 2024-02-04 00:00:00 | 0
[NAME] | 8673 |  |  |  |  |  | 2024-02-05 00:00:00 | 8673
09/02/2024 | 300 |  |  |  |  |  | 2024-02-06 00:00:00 | 0
09/02/2024 | 15640 |  |  |  |  |  | 2024-02-07 00:00:00 | 0
12/02/2024 | 14 |  |  |  |  |  | 2024-02-08 00:00:00 | 0
12/02/2024 | 16 |  |  |  |  |  | 2024-02-09 00:00:00 | 300+15640
12/02/2024 | 17 |  |  |  |  |  | 2024-02-10 00:00:00 | 0
12/02/2024 | 5 |  |  |  |  |  | 2024-02-11 00:00:00 | 0
12/02/2024 | 5 |  |  |  |  |  | 2024-02-12 00:00:00 | 14+16+17+5+5
13/02/2024 | 7 |  |  |  |  |  | 2024-02-13 00:00:00 | 7
15/02/2024 | 8 |  |  |  |  |  | 2024-02-14 00:00:00 | 0
16/02/2024 | 9 |  |  |  |  |  | 2024-02-15 00:00:00 | 8
16/02/2024 | 0 |  |  |  |  |  | 2024-02-16 00:00:00 | 9+0
17/02/2024 | 1 |  |  |  |  |  | 2024-02-17 00:00:00 | 1+1
17/02/2024 | 1 |  |  |  |  |  | 2024-02-18 00:00:00 | 0
23/02/2024 | 1 |  |  |  |  |  | 2024-02-19 00:00:00 | 0
23/02/2024 | 1 |  |  |  |  |  | 2024-02-20 00:00:00 | 0
23/02/2024 | 1 |  |  |  |  |  | 2024-02-21 00:00:00 | 0
23/02/2024 | 1 |  |  |  |  |  | 2024-02-22 00:00:00 | 0
23/02/2024 | 1 |  |  |  |  |  | 2024-02-23 00:00:00 | 1+1+1+1
23/02/2024 | 1 |  |  |  |  |  | 2024-02-24 00:00:00 | 1
24/02/2024 | 1 |  |  |  |  |  | 2024-02-25 00:00:00 | 0
26/02/2024 | 1 |  |  |  |  |  | 2024-02-26 00:00:00 | 1+1
26/02/2024 | 1 |  |  |  |  |  | 2024-02-27 00:00:00 | 0
29/02/2024 | 1 |  |  |  |  |  | 2024-02-28 00:00:00 | 0
29/02/2024 | 1 |  |  |  |  |  | 2024-02-29 00:00:00 | 1
Spreadsheet: 128225d1320863481-summary-of-cells-copy-of-bok2-3
Sheet: Ark1

2012 | 2011 | 2010 | 2009 | 2007 | Name |  | Country | Birthdate | 500m | 1500m | 5000m | 10000m |  | Sammenlagt |  | If 1 or 2 values missing | 500m | 1500m | [NAME] | 5000m | 10000m | [NAME]
2087 |  |  |  |  | [NAME] (94) |  | KOR | 191094 | 41.34 | 1.56.16 | 7.10.35 |  | 12
2088 |  |  |  |  | JANG Ho-Kweon |  | KOR | 250595 | 38.21 | 1.55.49 | 6.54.74 |  | 12
2089 |  |  |  |  | MANTIA Joey |  | USA | 070286 |  | 1.52.55 | 6.34.37 |  | 12
2090 |  |  |  |  | LOSKUTOV Aleksandr |  | RUS | 270890 | 39.02 | 1.54.77 | 6.53.07 | 14.44.32 | 12
2091 |  |  |  |  | [NAME] |  | RUS | 291292 | 36.24 | 1.54.51 | 7.30.16 |  | 12
Spreadsheet: 584610d1533289729-if-less-than-x-then-equal-x-ef1136_elo_wld_streaks
Sheet: Match

Weight_class | Match_type | Player 1 | result | Player 2 | Outcome | Method | Player_1 Last_5 | Player_2 Last_5 | Helper | Old ELO for player 1 | Old ELO for player 2 | Odds of Winning for player 1 | Odds of Winning for player 2 | New ELO for player 1 | New ELO for player 2 |  | Track Player
 |  | Adam | draw | Amy-Alice | KO | Punches and Elbows |  |  |  |  |  |  |  |  |  |  | Adam
 |  | Amy-Alice | def. | Olivia | Subm | Rear Naked Choke |  |  |  |  |  |  |  |  |  |  | Alicia
 |  | Grace | def. | Adam |  |  |  |  |  |  |  |  |  |  |  |  | Amy-Alice
 |  | Tyron | def. | [NAME]
 |  | Braxton | def. | Erin
 |  | Ellie | def. | Alicia
 |  | Amy-Alice | def. | Grace
 |  | Olivia | def. | [NAME]
 |  | Braxton | def. | Jessica
 |  | [NAME] | draw | [NAME]
 |  | [NAME] | def. | Tyron
 |  | Adam | def. | Braxton
 |  | Jessica | def. | Ellie
 |  | [NAME] | draw | [NAME]
 |  | Amy-Alice | def. | Grace
Spreadsheet: 106272d1303432118-lookup-function-that-produces-a-image-hyperlinkvlookup
Sheet: Sheet2

Search | Result |  |  | Values that can be looked up
PE84-P |  |  |  | LOUR1-P
 |  |  |  | PE84-P
 |  |  |  | INC37-P
 |  |  |  | CK83-P
 |  |  |  | POLO233-P
 |  |  |  | POLO232-P
 |  |  |  | CLA40-P
 |  |  |  | POLO231-P
 |  |  |  | POLO234-P
 |  |  |  | TH54-P
 |  |  |  | TB19-P
 |  |  |  | TB22-P
 |  |  |  | KC36-P
 |  |  |  | KC37-P
 |  |  |  | ALF159-P
 |  |  |  | KC38-P
 |  |  |  | PE85-P
 |  |  |  | PE86-P
 |  |  |  | PE87-P
 |  |  |  | TB20-P
 |  |  |  | TB21-P
 |  |  |  | PE88-P
 |  |  |  | TH55-P
 |  |  |  | ALF160-P
 |  |  |  | ET4-P
 |  |  |  | CK84-P
 |  |  |  | CK82-P
 |  |  |  | ED188-P
 |  |  |  | [NAME]
Spreadsheet: larry_campbell__20972__PG&E Samples
Sheet: PG&E Page 4

CONFIDENTIAL
[NAME] and PG&E Samples and Analytical Results
Date | Sample ID |  | Volume Drained |  | Comments |  |  |  | PG&E PCB | TW PCB | Location of sample point
 |  |  |  |  |  |  |  |  |  |  | Filter Scrubbers Downstream of
1999-03-18 00:00:00 | SLX-TW | 3-18-99-L | 0 |  | No liquid for sample |  |  |  |  |  | Solexol Plant
 |  |  |  |  |  |  |  |  |  |  | TW's Filter Scrubber at TW/PG&E
1999-03-18 00:00:00 | PGE-TW2 | 3-18-99-L | 50 oz |  |  |  |  |  | 144 PPM | 129 PPM | Metering Station
 |  |  |  |  |  |  |  |  |  |  | PG&E's Seperator at PG&E's
1999-03-18 00:00:00 | PGE-Top3 | 3-18-99-L | 64 oz |  |  |  |  |  | 90 PPM | 82 PPM | Compressor Station
 |  |  |  |  |  |  |  |  |  |  | PG&E's Line A TCS
1999-03-18 00:00:00 | PGE-A6 | 3-18-99-L |  |  | No sample taken per PG&E |  |  |  |  |  | Downstream Scrubber
 |  |  |  |  |  |  |  |  |  |  | PG&E's Line B TCS
1999-03-18 00:00:00 | PGE-B6 | 3-18-99-L |  |  | No sample taken per PG&E |  |  |  |  |  | Downstream Scrubber
1999-03-18 00:00:00 | PGE 10.84A | 3-18-99-L | 2 oz |  |  |  |  |  | 2 PPM | 2 PPM | PG&E's 34" Line A
1999-03-18 00:00:00 | PGE 10.84B | 3-18-99-L | 2 oz |  |  |  |  |  | ND | ND | PG&E's 34" Line B
1999-03-18 00:00:00 | PGE 8.58A | 3-18-99-L |  |  | No sample taken per PG&E |  |  |  |  |  | PG&E's 34" Line B
1999-03-18 00:00:00 | PGE-TW4 | 3-18-99-L | 0 |  | No liquid for sample |  |  |  |  |  | TW 20" 1st Siphon
1999-03-18 00:00:00 | PGE-TW5 | 3-18-99-L | 0 |  | No liquid for sample |  |  |  |  |  | TW 20" 2nd siphon
1999-03-18 00:00:00 | PGE-TW6 | 3-18-99-L | 0 |  | No liquid for sample |  |  |  |  |  | TW 20" 3rd Siphon
 |  |  |  |  |  |  |  |  |  |  | Filter Scrubbers Downstream of
1999-03-25 00:00:00 | SLX-TW | 3-25-99-L | 1 oz |  |  |  |  |  |  | 58 PPM | Solexol Plant
 |  |  |  |  |  |  |  |  |  |  | TW's Filter Scrubber at TW/PG&E
1999-03-25 00:00:00 | PGE-TW2 | 3-25-99-L | 36 oz |  |  |  |  |  | 216 PPM | 185 PPM | Metering Station
 |  |  |  |  |  |  |  |  |  |  | PG&E's Seperator at PG&E's
1999-03-25 00:00:00 | PGE-Top3 | 3-25-99-L | 36 oz |  |  |  |  |  | 86 PPM | 91 PPM | Compressor Station
 |  |  |  |  |  |  |  |  |  |  | PG&E's Line A TCS
1999-03-25 00:00:00 | PGE-A6 | 3-25-99-L |  |  | No sample taken per PG&E |  |  |  |  |  | Downstream Scrubber
 |  |  |  |  |  |  |  |  |  |  | PG&E's Line B TCS
1999-03-25 00:00:00 | PGE-B6 | 3-25-99-L |  |  | No sample taken per PG&E |  |  |  |  |  | Downstream Scrubber
1999-03-25 00:00:00 | PGE 10.84A | 3-25-99-L | 4 oz |  |  |  |  |  | 2 PPM | 1 PPM | PG&Es 34" Line A
1999-03-25 00:00:00 | PGE 10.84B | 3-25-99-L | 2 oz |  |  |  |  |  | ND | ND | PG&E's 34" Line B
1999-03-25 00:00:00 | PGE 8.58A | 3-25-99-L |  |  | No sample taken per PG&E |  |  |  |  |  | PG&E's 34" Line B
1999-03-25 00:00:00 | PGE-TW4 | 3-25-99-L |  |  | No liquid for sample |  |  |  |  |  | TW 20" 1st Siphon
1999-03-25 00:00:00 | PGE-TW5 | 3-25-99-L |  |  | No liquid for sample |  |  |  |  |  | TW 20" 2nd siphon
1999-03-25 00:00:00 | PGE-TW6 | 3-25-99-L |  |  | No liquid for sample |  |  |  |  |  | TW 20" 3rd Siphon
Spreadsheet: 815410d1674930921-formula-to-define-exchanges-between-people-test-book
Sheet: Sheet1

 | Missing |  |  | Duplicate
User_1 | 12 |  |  | 3 | 5 | 6 | 8 | 9 | 10 | 11 | 15 | 17 | 20
User_2 | 1 | 5 | 6 | 2 | 11 | 14 | 17
User_3 |  |  |  | 1 | 2 | 5 | 7 | 11 | 12 | 15 | 17 | 18 | 19
User_4 | 6 |  |  | 3 | 4 | 5 | 7 | 8 | 10 | 11 | 12 | 14 | 15 | 17 | 18 | 19 | 20
User_5 | 1 | 5 | 6 | 2 | 11 | 14 | 17
[NAME] | 2 | 8 |  | 9 | 14 | 16
User_7 | 12 |  |  | 3 | 5 | 6 | 8 | 9 | 10 | 11 | 15 | 17 | 20
User_8 | 8 | 14 |  | 2 | 3 | 5 | 7 | 9 | 13 | 15 | 16 | 17
User_9 | 4 | 6 | 7 | 5 | 8 | 10 | 11 | 12 | 15 | 16 | 17 | 19 | 20
Spreadsheet: 146419d1332175450-sorting-issue-for-large-event-participant_registration_example
Sheet: Sheet1

LAST_NAME | FIRST_NAME | [NAME] | ADDRESS_2 | CITY | STATE | ZIP | t-shirt size
Aarons | [NAME] | 1 [NAME] |  | Bronxville | NY | 10555 | [NAME]
Abbysinian | Christy | 1 Ackerman Court |  | Blairstown | NJ | 6623 | [NAME]
abel | Talia | 40 [NAME] |  | Bedfort | NJ | 5445 | [NAME]
Abitante | [NAME] | 40 [NAME] |  | Bedfort | NJ | 5445 | [NAME]
Abrahamson | Sara | 40 [NAME] |  | Bedfort | NJ | 5445 | [NAME]
[NAME] | [NAME] | 1 Cavelo Rd |  | Hopewell Junction | NY | 3515 | [NAME]
[NAME] | Victoria | 1 Whitewall Court |  | Brooklyn | NY | 7733 | [NAME]
Abriss | [NAME] | 1 Tomkins drive apt 3c |  | Fishkill | NY | 1287 | [NAME]
Ackermann | Candice | 1 Precise Tpke |  | Middletown | NY | 1818 | [NAME]
Adams | [NAME] | 12 Harwood Pl |  | Danville | NJ | 9090 | [NAME]
Adams | [NAME] | 12 Harwood Pl |  | Danville | NJ | 9090 | Youth Large
Adams | Lauren | 17 HUDSON TER UNIT B | Unit B | Hartsdale | CT | 1100 | [NAME]
Adams | Monique | 17 HUDSON TER UNIT B | Unit B | Hartsdale | CT | 1100 | [NAME]
Addonisio | [NAME] | 1 Hudson Terrace | Unit B | Dobbs [NAME] | NY | 3311 | Youth Large
Adelfio | Athena | 45 Independence Court | Apt 216 | Eastchester | NJ | 7888 | [NAME]
Adin | [NAME] | 45 Independence Court | Apt 216 | Eastchester | NJ | 7888 | [NAME]
Adorno | Christine | 1 Hammerstein Place | Apt U7J | New York | NY | 9912 | [NAME]
Agate | KellieAnne | 1 Nortel Circle |  | West Orange | NJ | 6312 | [NAME]
Aggarwal | [NAME] | 1 Locust Lane | Apt B-1Q | [NAME] | NY | 8621 | [NAME]
Spreadsheet: 9668643c-fa39-4af1-a8e8-d07bd222f031
Sheet: Sheet1

Table S3: Ten most represented KEGG pathways (number of sequences) | Unnamed: 1
[NAME] | No sequences in Pathway
Metabolic pathways | 4,470
Biosynthesis of secondary metabolites | 2,103
Microbial metabolism in diverse environments | 1,250
Biosynthesis of plant hormones | 881
Biosynthesis of phenylpropanoids | 783
Starch and sucrose metabolism | 762
Biosynthesis of alkaloids derived from shikimate pathway | 556
Biosynthesis of terpenoids and steroids | 553
Biosynthesis of alkaloids derived from histidine and purine | 519
Biosynthesis of alkaloids derived from ornithine, lysine and nicotinic acid | 518
Biosynthesis of alkaloids derived from terpenoid and polyketide | 503
Oxidative phosphorylation | 502
Spreadsheet: 267085d1379944178-slightly-complex-delivery-sheet-for-bakery-bread
Sheet: Delivery

DELIVERY WEEK
A | B | C | D | E | F | G | H | I
Spreadsheet: 885078d1734504494-how-to-return-second-from-last-entry-in-a-column-forum
Sheet: CMC

 | [NAME] | Nil | Plant Warehouse | White
 | [NAME] | Sand | Plant Processing | [NAME]
 | Tinotenda | Plant Fibre | Raw Materials Bay
 | Patience | Paper | 74 Warehouse
 | Mitchelle | Metal | New Sample
 | Vincent | Plastic
 | Agritta | Other
 | Casandra |  |  |  | Certificate of Analysis
 | Day Shift Rep
 | Night Shift Rep |  |  |  | Sodium Carboxymethyl Cellulose
 |  |  |  |  | C8H15NaO8
 |  |  |  |  | Key
 |  |  |  |  | Not Acceptable |  |  |  | 1 | Within Spec |  |  |  | 6 | Caution
 |  |  |  |  | Analyst | Date |  | Time | Source | Supplier | Batch No. | Sample | Total | Ratio % | Impurities | Color | Density |  | pH
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2% Sol
 |  |  |  |  |  | Analysis | [NAME] |  |  |  |  | ([NAME]) | ([NAME]) |  |  |  | g/100ml | g/L | 6.5 - 8.5
 |  |  |  |  | Vincent | 1900-08-02 00:00:00 | 2//190 | 1413hrs | Plant Processing | - |  | 1 |  |  | Nil | White | 100.1 |  | 10.24 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10
 |  |  |  |  | Casandra | 2024-08-05 00:00:00 | - | 1430hrs | Raw Materials Bay | - | - | 1 |  |  | Nil | White | 103.078 |  | 9.74
Spreadsheet: 545771d1509646229-solved-creating-panel-data-help-needed-file
Sheet: Taul1

Company name | Operating revenue th EUR 2016 | Operating revenue th EUR 2015 | Operating revenue th EUR 2014 | Operating revenue th EUR 2013 | Operating revenue th EUR 2012 | Debtors th EUR 2016 | Debtors th EUR 2015 | Debtors th EUR 2014 | Debtors th EUR 2013 | Debtors th EUR 2012
A | 666600 | 650000 | 646700 | 672497 | 681693 | 83000 | 77000 | 86200 | 84544 | 89772
B | 71542 | 71391.2 | 72001.58 | 70321.729 | 71047.193 | 11139 | 9162.156 | 9463.991 | 9156.934 | 7169.617
C | 39592.63 | 45760.436 | 38310.388 | 39086.117 | 35036.697 | 8831.617 | 10389.959 | 9464.646 | 9098.393 | 8505.713
 |  |  | Company name | Year | Operating revenue | Debtors
 |  |  | A | 2016 | 666600 | 83000
 |  |  | A | 2015 | 650000 | 77000
 |  |  | A | 2014 | 646700 | 86200
 |  |  | A | 2013 | 672497 | 84544
 |  |  | A | 2012 | 681693 | 89772
 |  |  | B | 2016 | 71542 | 11139
 |  |  | B | 2015 | 71391.2 | 9162.156
 |  |  | B | 2014 | 72001.58 | 9463.991
 |  |  | B | 2013 | 70321.729 | 9156.934
 |  |  | B | 2012 | 71047.193 | 7169.617
 |  |  | C | 2016 | 39592.63 | 8831.617
 |  |  | C | 2015 | 45760.436 | 10389.959
 |  |  | C | 2014 | 38310.388 | 9464.646
 |  |  | C | 2013 | 39086.117 | 9098.393
 |  |  | C | 2012 | 35036.697 | 8505.713
Spreadsheet: 552730d1513739396-how-to-total-the-number-of-hours-worked-on-each-date-excel-2007-to-calculate-overtime-hours-11
Sheet: overtime

 |  | Enter data |  |  |  | Calculated
 |  | Actual Time |  |  |  |  |  |  |  |  |  |  | Total Pay | overtime?
 |  | Start | End |  |  | HH:[NAME] | Hours | Rate | = $ [NAME] | [NAME] | X $0.55
 | 2017-12-04 00:00:00 | 0854 | 1250 |  |  |  |  | 14.5 |  | 13
 | 2017-12-04 00:00:00 | 1338 | 1633 |  |  |  |  | 16 |  | 0 |  |  |  | 2
 | 2017-12-05 00:00:00 | 0954 | 1243 |  |  |  |  | 14.5 |  | 24
 | 2017-12-05 00:00:00 | 1253 | 1744 |  |  |  |  | 16 |  | 0 |  |  |  | 2
 | 2017-12-06 00:00:00 | 0957 | 1244 |  |  |  |  | 14.5 |  | 67
 | 2017-12-06 00:00:00 | 1319 | 1525 |  |  |  |  | 16 |  | 0
 | 2017-12-06 00:00:00 | 1526 | 1715 |  |  |  |  | 14.5 |  | 0 |  |  |  | 3
 | 2017-12-07 00:00:00 | 0952 | 1240 |  |  |  |  | 14.5 |  | 36
 | 2017-12-07 00:00:00 | 1305 | 1733 |  |  |  |  | 16 |  | 0 |  |  |  | 2
 | 2017-12-08 00:00:00 | 1003 | 1319 |  |  |  |  | 14.5 |  | 57
 | 2017-12-08 00:00:00 | 1352 | 1710 |  |  |  |  | 16 |  | 0
 | 2017-12-08 00:00:00 | 1711 | 1907 |  |  |  |  | 14.5 |  | 0 |  |  |  | 3
 | 2017-12-09 00:00:00 | 1000 | 1040 |  |  |  |  | 16 |  | 4 |  |  |  | 1
 | 2017-12-11 00:00:00 | 0858 | 1300 |  |  |  |  | 14.5 |  | 48
 | 2017-12-11 00:00:00 | 1406 | 1455 |  |  |  |  | 16 |  | 0
 | 2017-12-11 00:00:00 | 1456 | 1653 |  |  |  |  | 14.5 |  | 38 |  |  |  | 3
 | 2017-12-12 00:00:00 | 0659 | 1245 |  |  |  |  | 14.5 |  | 48
 | 2017-12-12 00:00:00 | 1425 | 1840 |  |  |  |  | 16 |  | 0 |  |  |  | 2
 | 2017-12-13 00:00:00 | 0856 | 1355 |  |  |  |  | 14.5 |  | 67
 | 2017-12-13 00:00:00 | 1420 | 1550 |  |  |  |  | 16 |  | 0
 | 2017-12-13 00:00:00 | 1551 | 1825 |  |  |  |  | 14.5 |  | 0 |  |  |  | 3
 | 2017-12-14 00:00:00 | 0955 | 1156 |  |  |  |  | 14.5 |  | 8
 | 2017-12-14 00:00:00 | 1220 | 2149 |  |  |  |  | 16 |  | 0 |  |  |  | 2
 | 2017-12-15 00:00:00 | 0805 | 2230 |  |  |  |  | 16 |  | 25 |  |  |  | 1
Spreadsheet: 64dafead-d0c1-45f2-a178-c0f2456ae254
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | BIKE | T2 | RUN.1 | POSITION | TOTAL TIME
262305 | 72093 | [NAME] | Jacobs | RSA |  | 00:19:21 | 00:00:00 | 00:30:08 | 00:00:00 | [NAME] | 1 | 01:07:07
Spreadsheet: 212485d1360149999-2-combo-boxes-to-select-row-and-column-5s-plant-entry
Sheet: Score Entry (2)

Deaprtmet
 |  |  | Week 17 |  |  |  |  | Week 18 |  |  |  |  | Week 19 |  |  |  |  | Week 20 |  |  |  |  |  |  |  |  |  | Stores 1
 |  |  | Mon | Tue | Wed | Thu | Fri | Mon | Tue | Wed | Thu | Fri | Mon | Tue | Wed | Thu | Fri | Mon | Tue | Wed | Thu | Fri |  |  |  |  |  | Stores 2
 | Stores 1 | 1s | 12 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Blending 1
 |  | 2s | 12 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Blending 2
 |  | 3s | 14 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 50pce/100pce
 |  | % |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20pce/Rework
 | Stores 2 | 1s | 11 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Dream
 |  | 2s | 11 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | WIP/Walkways
 |  | 3s | 11 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Manufacturing office
 |  | % |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Building 2
 | Blending 1 | 1s | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Engineering
 |  | 2s | 4
 |  | 3s | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Mon
 |  | % |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Tue
 | Blending 2 | 1s |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Wed
 |  | 2s |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Thu
 |  | 3s |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Fri
 |  | %
 | 50pce/100pce | 1s |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Week 17
 |  | 2s |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Week 18
 |  | 3s |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Week 19
 |  | % |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Week 20
 | 20pce/Rework | 1s
 |  | 2s
 |  | 3s
 |  | %
 | Dream | 1s
 |  | 2s
 |  | 3s
 |  | %
 | WIP/Walkways | 1s
 |  | 2s
 |  | 3s
 |  | %
 | Manufacturing office | 1s
 |  | 2s
 |  | 3s
 |  | %
 | Building 2 | 1s
 |  | 2s
 |  | 3s
 |  | %
 | Engineering | 1s
 |  | 2s
 |  | 3s
 |  | %
Stores 1
Stores 2
Blending 1 | 2 |  | 3 |  |  |  | 2
Blending 2
 | 1s
 | 2s
 | 3s
Spreadsheet: 32913d1229081816-convert-date-to-day-mcc-date-example
Sheet: Sheet 1

IN_DATE | What I want to see
2008-11-16 00:00:00 | Sun
2008-11-16 00:00:00 | Sun
2008-11-16 00:00:00 | Sun
2008-11-16 00:00:00 | Sun
2008-11-17 00:00:00 | Mon
2008-11-17 00:00:00 | Mon
2008-11-17 00:00:00 | Mon
2008-11-17 00:00:00 | Mon
2008-11-17 00:00:00 | Mon
2008-11-18 00:00:00 | Tue
2008-11-18 00:00:00 | Tue
2008-11-18 00:00:00 | Tue
2008-11-18 00:00:00 | Tue
2008-11-18 00:00:00 | Tue
2008-11-18 00:00:00 | Tue
Spreadsheet: 689817d1596671324-employee-attendance-tracker-rolling-90-days-attendance-tracker
Sheet: Template

Occurrence Type |  |  | 2020-05-01 00:00:00
Call out on the day of shift
Call out with proper notice
Tardy (Late 5+ Minutes)
Missed Paycom Punches
No Call/No Show
90 Day Rolling Points
Employee Name
Employee 1 |  |  | Call out with proper notice |  |  |  |  |  | No Call/No Show
Employee 2 |  |  |  |  | Tardy (Late 5+ Minutes) |  |  |  |  |  |  | Call out on the day of shift | Call out on the day of shift
Employee 3
Employee 4 |  |  |  |  |  | Missed Paycom Punches
Employee 5 |  |  | Tardy (Late 5+ Minutes) |  |  |  |  |  |  | Tardy (Late 5+ Minutes)
Employee 6
Employee 7 |  |  |  |  |  |  | Tardy (Late 5+ Minutes)
Employee 8 |  |  |  |  |  |  |  | Missed Paycom Punches |  |  | Tardy (Late 5+ Minutes)
Employee 9 |  |  | No Call/No Show
Spreadsheet: 855540d1705072564-dynamic-text-based-on-multiple-cell-inputs-field-instructions-aligw-mp
Sheet: Sheet1

Item # | Instructions |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DropDown
1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | X
 |  | 1 | 2 | 3 | 4 | 5
 | Instruction Index | X
2
 |  | 1 | 2 | 3 | 4 | 5
 | Instruction Index |  | X
3 | Motor, Heater or SSOL with engaved rating / or setting, [NAME]. Picture of disconnect, Fuse rating
 | Instruction Index | 1 |  |  |  |  | 2 |  |  |  |  | 3 |  |  |  |  | 4 |  |  |  |  | 5
 |  | X |  |  |  |  |  |  |  |  |  | X
 | Detail Index | 1 | 2 | 3 | 4 | 5 | 1 | 2 | 3 | 4 | 5 | 1 | 2 | 3 | 4 | 5 | 1 | 2 | 3 | 4 | 5 | 1 | 2 | 3 | 4 | 5
 |  |  | X |  | X |  |  |  |  |  |  |  | X
 | Instruction Index | Instructions |  | Detail Index | Detail Instructions
 | 1 | Motor |  | 1 | OCPD
 | 2 | Picture of switchgear. |  | 1 | Heater or SSOL with engraved rating and / or setting
 | 3 | Picture of disconnect. |  | 1 | Size of contactor
 | 4 | Picture of conductor. |  | 1 | Wire Size
 | 5 | Visual inspection. |  | 1 | Torque markings
 |  |  |  | 2
 |  |  |  | 2
 |  |  |  | 2
 |  |  |  | 2
 |  |  |  | 2
 |  |  |  | 3 | Nameplate
 |  |  |  | 3 | Fuse rating
 |  |  |  | 3 | Wire Size
 |  |  |  | 3 | NEMA rating
 |  |  |  | 3 | Conditon
 |  |  |  | 4
 |  |  |  | 4
 |  |  |  | 4
 |  |  |  | 4
 |  |  |  | 4
 |  |  |  | 5
 |  |  |  | 5
 |  |  |  | 5
 |  |  |  | 5
 |  |  |  | 5
Spreadsheet: 64972fef-7141-4416-abdd-217ea88c8ca8
Sheet: Sheet1

Battle ID | Date & Time | Side | Victory | Score | Opp. Score | Opp. ID | Opp. Name | Scenario ID | Front | Start Date | End Date | Name EN | Name FR
40853201 | 2014-04-05 15:19:17 | ALLIES | 1 | 7 | 1 | 580159 | Devious | 7597 | eastern | 1941-10-18 | 1941-10-18 | Gates of Moscow | Aux portes [NAME]
40853496 | 2014-04-05 15:41:50 | AXIS | 1 | 7 | 4 | 580159 | Devious | 7597 | eastern | 1941-10-18 | 1941-10-18 | Gates of Moscow | Aux portes [NAME]
Spreadsheet: 3e14e391-6c40-48d2-afe2-78e27fe4eaf9
Sheet: Sheet1

Real Time PCR Sequencing Primers | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
Forward Primer | Sequence | [NAME] | Sequence | amplicon length (nt)
APP 446-463 | 5'-ccttctcgtgcccgacaa-3' | APP 518-497 | 5'-ccactgaagatgggtctcacaa-3' | 73
APP 584-598 | 5'-gccctgcggcatcga-3' | APP 658-641 | 5'-tccacgctgtcgctttcc-3' | 75
APP 699-719 | 5'-ggtggagcggacacagactac-3' | APP 796-774 | 5'-tacgcttcctcttcctcaacatc-3' | 98
APP 774-797 | 5'-gatgttgaggaagaggaagctgat-3' | APP 871-852 | 5'-ctctcggtggcctcttcgta-3' | 98
APP 774-797 | 5'-gatgttgaggaagaggaagctgat-3' | APP 888-869 | 5'-tggcagtgctggttgttctc-3' | 115
APP 757-779 | 5'-aagaggaggaagtggctgatgtt-3' | APP 871-852 | 5'-ctctcggtggcctcttcgta-3' | 115
APP 757-779 | 5'-aagaggaggaagtggctgatgtt-3' | APP 888-869 | 5'-tggcagtgctggttgttctc-3' | 132
APP 774-797 | 5'-gatgttgaggaagaggaagctgat-3' | APP 915-896 | 5'-cggactcagtggtggttgtg-3' | 142
APP 757-779 | 5'-aagaggaggaagtggctgatgtt-3' | APP 915-896 | 5'-cggactcagtggtggttgtg-3' | 159
APP 2318-2347 | 5'-gcctgaacttgaattaatatacaaatcagt-3' | APP 2416-2392 | 5'-cagtacacaaaacccatgaatcatg-3' | 99
 | nucleotide references based on mouse
 | accession # X59379