tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 74815d1275365333-formatting-a-timeline-sheet-timeline-test-24hr
Sheet: tIMELINE

 |  |  |  | 2010-06-02 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-06-03 00:00:00
 |  |  |  | 2010-06-02 14:00:00 | 2010-06-02 14:30:00 | 2010-06-02 15:00:00 | 2010-06-02 15:30:00 | 2010-06-02 16:00:00 | 2010-06-02 16:30:00 | 2010-06-02 17:00:00 | 2010-06-02 17:30:00 | 2010-06-02 18:00:00 | 2010-06-02 18:30:00 | 2010-06-02 19:00:00 | 2010-06-02 19:30:00 | 2010-06-02 20:00:00 | 2010-06-02 20:30:00 | 2010-06-02 21:00:00 | 2010-06-02 21:30:00 | 2010-06-02 22:00:00 | 2010-06-02 22:30:00 | 2010-06-02 23:00:00 | 2010-06-02 23:30:00 | 2010-06-03 00:00:00 | 2010-06-03 00:30:00 | 2010-06-03 01:00:00 | 2010-06-03 01:30:00 | 2010-06-03 02:00:00 | 2010-06-03 02:30:00 | 2010-06-03 03:00:00 | 2010-06-03 03:30:00 | 2010-06-03 04:00:00 | 2010-06-03 04:30:00 | 2010-06-03 05:00:00 | 2010-06-03 05:30:00 | 2010-06-03 06:00:00 | 2010-06-03 06:30:00 | 2010-06-03 07:00:00 | 2010-06-03 07:30:00 | 2010-06-03 08:00:00 | 2010-06-03 08:30:00 | 2010-06-03 09:00:00 | 2010-06-03 09:30:00 | 2010-06-03 10:00:00 | 2010-06-03 10:30:00 | 2010-06-03 11:00:00 | 2010-06-03 11:30:00 | 2010-06-03 12:00:00 | 2010-06-03 12:30:00 | 2010-06-03 13:00:00 | 2010-06-03 13:30:00 | 2010-06-03 14:00:00
 | Time On | Time Off
P1 | 14:00:00 | 2010-06-02 23:00:00
P2 | 2010-06-02 14:30:00 | 2010-06-02 18:00:00
P3 | 2010-06-02 22:00:00 | 2010-06-03 02:00:00
P4 | 2010-06-02 23:00:00 | 2010-06-03 04:00:00
P5 | 2010-06-03 01:00:00 | 2010-06-03 05:00:00
Spreadsheet: 716794d1612367422-conditional-formatting-multiple-ranges-tabs-capacity-plan-option-2-1-2-final
Sheet: Monthly View

 | Resource Working Days Overview |  |  |  |  |  |  |  |  |  |  |  |  |  | Month |  |  |  | 2 |  |  |  | Year |  |  | 2021
 | Resource Groups
 | MTCSS 1
 | MTCSS 2
 | CONTRACT 1
 | CONTRACT 2
 | CONTRACT 3
 | CONTRACT 4
 | SPRAY 1
 | SPRAY 2
Spreadsheet: 848674d1699356127-transpose-a-text-table-more-complicated-then-it-sounds-book2
Sheet: Sheet1

 |  |  | Source
 |  |  |  | Product 1 | Product 2 | Product 3 | Product 4 | Product 5 | Product 6 | Product 7 | Product 8
 |  |  | A |  | 1 |  |  | 1
 |  |  | B | 1
 |  |  | C |  |  | 1 |  |  | 1 |  | 1
 |  |  | D
 |  |  | Result view |  | <== how to I do it ?
 |  |  | A | Product 2
 |  |  |  | Product 5
 |  |  | B | Product 1
 |  |  | C | Product 3
 |  |  |  | Product 6
 |  |  |  | Product 8
 |  |  | D | N/A
Spreadsheet: 768942d1645209177-need-help-with-a-challenging-lookup-match-type-of-situation-example-file
Sheet: FILTERS

ALAAUTO | AL | ALAAUTO | AL
ALBUQUERQ | AZ | ALBUQUERQ | AZ
ALLIANCE | BC | ALLIANCE | BC
ALTUS | CA | ALTUS | CA
ATLANTA | CO | [NAME] | CO
AUSTELL | FL | ATLANTA | FL
AVONDALE | GA | BALTIMORE | GA
BARCUT | IL | BARCUT | IL
BARSTOW | KS | BARSTOW | KS
BEAUMONT | MA | BIGLIFT | MA
BIRMINGHA | MN | BIRMINGHA | MD
BLUISLAND | MO | BRAINTTER | MN
BLUSPRING | MS | CADIZ | MO
CHARLOTTE | NC | CHICAGO | MS
CHEYENNE | ND | CLEARING | MT
CHICAGO | NE | CLEBURNE | ND
CICERO | NJ | CMALOTONE | NE
CINCINNAT | NM | CORCHRIST | NJ
CLEARING | OH | CROXTON | NM
COLTON | OK | DAKCITY | NY
CORCHRIST | OR | DALLAS | OH
CROXTON | PA | DAYBLUFF | OK
DALLAS | TN | DENVER | ON
DENVER | TX | DILWORTH | OR
EAGPASS | WA | EAGPASS | PA
ELPASO | WY | EIGSTREET | TN
ESTJOHNS | ZZ | ELMIRAGE | TX
ESTLOUIS |  | ELPASO | WA
EVERETT |  | ESTJOHNS | ZZ
FAIRBURN |  | ETTER
FREMONT |  | FREMONT
GLOGATSO |  | FRYBURG
HOUSTON |  | GLOGATSO
KANCITY |  | HOUSTON
LAHARAPMT |  | [NAME]
LOGPARCHI |  | KANCITY
LOGPARKAN |  | KENT
[NAME] |  | KORF
LONBEACH |  | LAHARAPMT
LONBEAEPI |  | LAUBN
LONBEAITS |  | LAUREL
[NAME] |  | LOGPARCHI
LONBEALBC |  | LOGPARKAN
LONBEAPCT |  | [NAME]
LONBEATPI |  | LONBEACH
LONJCT |  | LONBEAEPI
LOSANGELE |  | LONBEAITS
LUBBOCK |  | [NAME]
MCCOOK |  | LONBEAPCT
MEMPHIS |  | LONBEATPI
MIDLOTHIA |  | LONJCT
MINOT |  | LOSANGELE
MISSINGAC |  | LUBBOCK
NATCITY |  | MCCOOK
NBAY |  | MEMPHIS
NEWWESTMI |  | MIDLOTHIA
NWOHIICTF |  | MINOT
OAKINTGAT |  | MISSINGAC
OMAHA |  | NATCITY
PASADENA |  | NBAY
PHOENIX |  | NBERGEN
PORTERSIX |  | NEWWESTMI
PORTLAND |  | NWOHIICTF
RICHMOND |  | OAKINTGAT
RIVGATE |  | OAKLAND
ROBSTOWN |  | OKLCITY
RUTHERFOR |  | OMAHA
SANANGJCT |  | ORILLIA
SANBERNAR |  | PEARLAND
SANDIEGO |  | PHOENIX
SANJOSE |  | PITTSBURG
SEAPIEFIV |  | PORTERSIX
SEAPIEONE |  | PORTLAND
SEATTLE |  | RICHMOND
SKEARNY |  | ROBSTOWN
SPOKANE |  | RUTHERFOR
SSEATTLE |  | SANBERNAR
STLOUIS |  | SANDIEGO
STOCKTON |  | SEAPIEFIV
STPAUL |  | SEAPIEONE
TACBLAIR |  | SEATTLE
TACEXP |  | SPOKANE
TACOMA |  | SSEATTLE
TACPCT |  | STJOHNS
THENARD |  | STLOUIS
TICSEASID |  | STOCKTON
TICTF |  | STPAUL
TRAPAC |  | SYRACUSE
TUPELO |  | TACBLAIR
UTTING |  | TACEXP
[NAME] |  | TACOMA
VELOX |  | TACPCT
WATSON |  | TICSEASID
WBASIN |  | TICTF
WILSPRING |  | TRAPAC
WINHAVEN |  | TUPELO
WORCESTER |  | UTTING
ZITA |  | [NAME]
 |  | VELOX
 |  | WBASIN
 |  | WILSPRING
 |  | WORCESTER
 |  | YUSTERMIN
 |  | ZITA
Spreadsheet: 124ffa81-1060-4d68-b9e0-ea211a2de04f
Sheet: Sheet1

SOFTBALL REPORTING FORM | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15 | Unnamed: 16 | Unnamed: 17 | Unnamed: 18 | Unnamed: 19 | Unnamed: 20
Date: |  |  |  | School:
Visitor:
Home:
 |  |  |  |  | Individual Batting Statistics
Player: |  |  |  | AB/H |  |  |  | 2B |  | 3B |  | HR |  | R |  | RBI |  | STL |  | BB
 |  |  |  |  | /
 |  |  |  |  | /
 |  |  |  |  | /
 |  |  |  |  | /
 |  |  |  |  | /
 |  |  |  |  | /
 |  |  |  |  | /
 |  |  |  |  | /
 |  |  |  |  | /
 |  |  |  |  | /
 |  |  |  |  | /
 |  |  |  |  | /
 |  |  |  |  | /
Player: |  |  |  |  |  | Individual Pitching statistics
 |  |  |  | Innings |  |  |  | ER |  | K |  | W/L
Record:
Spreadsheet: 61093d1261695274-excel-2007-upcharge-percentages-example1
Sheet: Sheet3

Product | Our Cost | Upcharge | Retail
5/32" Florex | 100 | 0.2
5/32" Hammered | 100 | 0.5
1/8" Patten 62 | 2.75 | 0.3
3/16" Aquatex | 10 | 0.1
3/16" Flutex | 5.05 | 0.32
3/16 Pattern 62 | 3.05
3/16" Rain | 3.1
3/16" Glue Chip | 8.45
1/8" Glue Chip | 5.25
1/8" Acid Etched | 3.45
3/16 Industrex | 3.95
1/8" Clear Satin | 4
1/8" Rain Water | 2
1/8" Water Glass | 11
1/8" Seedy | 2
1/8" Clear Satin | 2
1/8" Clear Plate | 0.54
3/16" Mirror | 100
1/8" Clear laminated | 1.65
Spreadsheet: 059ad0ff-b051-4d57-b070-824157fb81cd
Sheet: State_FT+PT

Public Report Summary
State Level
School Year: 2012 - 2013
Snapshot Date: Oct 22, 2012
Totals are provided for each category. The first column contains the category total, the second is the [NAME] (F) subtotal; the third is the Male (M) subtotal. | All Professional  Personnel |  |  | Administrators |  |  | Classroom  Teachers |  |  | Coordinators |  |  | Other
 | PP | PP-F | PP-M | Ad | Ad-F | Ad-M | CT | CT-F | CT-M | Co | Co-F | Co-M | Ot | Ot-F | Ot-M
 | 148518 | 107927 | 40602 | 7130 | 3497 | 3633 | 122165 | 89214 | 32959 | 15942 | 13234 | 2710 | 7870 | 5193 | 2679
May 30, 20132:55:59 PM | - 3 - |  |  |  |  |  |  |  |  |  |  | www.pimsreports.state.pa.us
Spreadsheet: 9da9c925-4804-489e-95f7-9e55ba351e4a
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
FDSAC | Test | FDSAC | Disaccharidase Analysis | Disaccharidase Analysis | Spectrophotometry |  |  |  |  |  | Send 5 mg from an intestinal biopsy in a clean, screw-topped plastic vial. Freeze immediately after collection and ship frozen.   Note: [NAME] should not be placed on gauze, filter paper, nor should any saline, support or embedding material be added. | 5 mg wet weight | Hemolysis	NA Thawing	Warm reject; Cold reject Lipemia	NA Icterus	NA Other	NA | Lactase:     Range  24.5 +/- 8.0                        Abnormal  <15.0  Units = uM/min/gram protein   Sucrase:      Range 54.4 +/- 25.4                        [NAME]  <25.0  Units = uM/min/gram protein    Maltase:      Range 160.8 +/- 62.8                        [NAME]  <100.0  Units = uM/min/gram protein   Palatinase:   Range 11.1 +/- 6.5                           Abnormal  <5.0   Units = uM/min/gram protein   Test Performed By:  Joli Diagnostic, Inc.                                2451 [NAME]                                Williamsville, NY 14221 | Tuesday through Friday | 1 day | 3 - 11 days | 1 | 82657 |  |  |  |  | Joli Diagnostics, Inc.
FDSAC | [NAME] | TISSUE | Tissue |  |  |  | Frozen
FDSAC | Result | [NAME] | Lactase: | Lactase: | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
FDSAC | Result | Z1849 | Sucrase | Sucrase | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
FDSAC | Result | Z1850 | Maltase | Maltase | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
FDSAC | Result | Z1851 | Palatinase | Palatinase | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
FDSAC | Result | Z1852 | Interpretation | Interpretation | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 116213d1311682293-selective-columns-shendish-manor
Sheet: Dj

Dooley. J |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | HANDICAPPING
hole | par | stroke index | adjusted par | pts calc | [NAME] | strokes | points | PAR 3 | INDEX 1 | INDEX 2 | INDEX 3 | adjusted par | pts calc | [NAME] | points | handicap | handicap |  | handicap | catergory | Buffer Zone | css | Nett Differential | adjustment
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Nett | Nett
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | points | points
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | par 3 |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | hole | par | stroke index | strokes | points | penalty
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | sss | css adj | "RO"
in
out
total
Spreadsheet: 810670d1671951986-want-to-get-data-from-multiple-matching-data
Sheet: Sheet1

Date | ID | Amount |  |  | ID | 2022-12-01 00:00:00 | 2022-12-05 00:00:00 | 2022-12-07 00:00:00 | 2022-12-14 00:00:00 | 2022-12-23 00:00:00
2022-12-12 00:00:00 | A035F |  |  |  | A035F | 3000 | 3000 | 3000 | 3000 | 2000
2022-12-10 00:00:00 | A035FZ |  |  |  | A035FZ
2022-12-04 00:00:00 | A032F |  |  |  | A032F | 1900 | 1900 | 1900 | 1900 | 1900
2022-12-10 00:00:00 | A032FC |  |  |  | A032FC | 1900 | 1900 | 1900 | 1900 | 1900
2022-12-11 00:00:00 | A037F |  |  |  | A037F | 3600 | 3600 | 3600 | 3600 | 3600
2022-12-10 00:00:00 | A235F |  |  |  | A135F | 2000 | 2000 | 2000 | 2000 | 2000
2022-12-03 00:00:00 | A035F |  |  |  | A135FL
2022-12-05 00:00:00 | A035FZ |  |  |  | A225F
2022-12-10 00:00:00 | A032F |  |  |  | A235F | 3600 | 4600 | 4600 | 4600
2022-12-08 00:00:00 | A032FC |  |  |  | A035F | 3000 | 3000 | 3000 | 3000 | 2000
2022-12-08 00:00:00 | A037F |  |  |  | A035FZ
2022-12-08 00:00:00 | A235F |  |  |  | A032F | 1900 | 1900 | 1900 | 1900 | 1900
2022-12-11 00:00:00 | A035F |  |  |  | A032FC | 1900 | 1900 | 1900 | 1900 | 1900
2022-12-08 00:00:00 | A035FZ |  |  |  | A037F | 3600 | 3600 | 3600 | 3600 | 3600
2022-12-08 00:00:00 | A032F |  |  |  | A135F | 2000 | 2000 | 2000 | 2000 | 2000
2022-12-06 00:00:00 | A032FC |  |  |  | A135FL
Spreadsheet: 60707d1261231323-excel-graphs-example
Sheet: Sheet1

Month | Keyword | Google.co.uk (the web) Search Engine Rank
January | keyword1 | 16
January | keyword2 | 8
January | keyword3 | 7
January | keyword4 | 37
January | keyword5 | 12
January | keyword6 | 26
January | keyword7 | 23
January | keyword8 | 9
January | keyword9 | 18
January | keyword10 | 40
January | keyword11 | 7
January | keyword12 | 21
January | keyword13 | 82
January | [NAME] | 23
January | [NAME] | 11
January | [NAME] | 79
January | keyword17 | 6
January | keyword18 | 10
January | [NAME] | 29
January | keyword20 | 31
January | keyword21 | Not in top 100
January | keyword22 | 14
January | keyword23 | Not in top 100
January | keyword24 | 17
January | keyword25 | 41
January | [NAME] | Not in top 100
January | [NAME] | 6
January | keyword28 | 21
January | keyword29 | Not in top 100
January | keyword30 | 8
January | [NAME] | 9
January | keyword32 | 20
January | keyword33 | 8
January | keyword34 | 60
Month | Keyword | Google.co.uk (the web) Search Engine Rank
February | keyword1 | 16
February | keyword2 | 8
February | keyword3 | 7
February | keyword4 | 37
February | keyword5 | 12
February | keyword6 | 26
February | keyword7 | 23
February | keyword8 | 9
February | keyword9 | 18
February | keyword10 | 40
February | keyword11 | 7
February | keyword12 | 21
February | keyword13 | 82
February | [NAME] | 23
February | [NAME] | 11
February | [NAME] | 79
February | keyword17 | 6
February | keyword18 | 10
February | [NAME] | 29
February | keyword20 | 31
February | keyword21 | Not in top 100
February | keyword22 | 14
February | keyword23 | Not in top 100
February | keyword24 | 17
February | keyword25 | 41
February | [NAME] | Not in top 100
February | [NAME] | 6
February | keyword28 | 21
February | keyword29 | Not in top 100
February | keyword30 | 8
February | [NAME] | 9
February | keyword32 | 20
February | keyword33 | 8
February | keyword34 | 60
Spreadsheet: 823698d1680099052-match-similar-names-and-get-required-values-match-state-names
Sheet: State Code

 | Default State Names | Location code | State Code |  |  | State Names as Received | Location code | State Code
 | Jammu and Kashmir | JK | 1 |  |  | West Bengal
 | Himachal Pradesh | HP | 2 |  |  | Abu Dhabi
 | Punjab | PB | 3 |  |  | Andaman and Nicobar
 | Chandigarh | CH | 4 |  |  | Andaman and Nicobar Islands
 | Uttarakhand | UL | 5 |  |  | [NAME]
 | [NAME] | HR | 6 |  |  | Arunachal Pradesh
 | Delhi | DL | 7 |  |  | Arunachal Pradesh (AR)
 | [NAME] | RJ | 8 |  |  | Assam
 | Uttar Pradesh | UP | 9 |  |  | Australia
 | Bihar | BH | 10 |  |  | Bihar
 | Sikkim | SK | 11 |  |  | Cancelled
 | Arunachal Pradesh | AR | 12 |  |  | Chandigarh
 | Nagaland | NL | 13 |  |  | Chhattisgarh
 | Manipur | MA | 14 |  |  | Dadra and [NAME]
 | Mizoram | MZ | 15 |  |  | Daman and Diu
 | Tripura | TR | 16 |  |  | Delhi (DL)
 | Meghalaya | ML | 17 |  |  | Dubai
 | Assam | AS | 18 |  |  | ETHIOPIA
 | West Bengal | WB | 19 |  |  | Goa
 | Jharkhand | JH | 20 |  |  | Gujarat
 | Odisha | OD | 21 |  |  | [NAME]
 | Chhattisgarh | CT | 22 |  |  | Himachal Pradesh
 | Madhya Pradesh | MP | 23 |  |  | HR
 | Gujarat | GJ | 24 |  |  | Jammu and Kashmir
 | Daman and Diu | DD | 25 |  |  | Jharkhand
 | Dadra and [NAME] and [NAME] and Diu | DH | 26 |  |  | Karnataka (KA)
 | Maharashtra | MH | 27 |  |  | Kerala
 | Karnataka | KA | 29 |  |  | [NAME] (KL)
 | Goa | GA | 30 |  |  | Kuwait
 | Kerala | KL | 32 |  |  | Lakshadweep
 | [NAME] | TN | 33 |  |  | London
 | [NAME] | PY | 34 |  |  | Madhya Pradesh
 | Andaman and Nicobar Islands | AN | 35 |  |  | Maharashtra (MH)
 | Telangana | TG | 36 |  |  | Manipur
 | [NAME] | AP | 37 |  |  | Meghalaya
 | Others | OT | 97 |  |  | Mizoram
 |  |  |  |  |  | MUSCAT
 |  |  |  |  |  | Nagaland
 |  |  |  |  |  | New Jersey
 |  |  |  |  |  | New Zealand
 |  |  |  |  |  | Odisha
 |  |  |  |  |  | other
 |  |  |  |  |  | [NAME]
 |  |  |  |  |  | Punjab
 |  |  |  |  |  | [NAME]
 |  |  |  |  |  | Rajasthan (RJ)
 |  |  |  |  |  | sharjah
 |  |  |  |  |  | Sikkim
 |  |  |  |  |  | Singapore
 |  |  |  |  |  | Sweden
 |  |  |  |  |  | [NAME] (TN)
 |  |  |  |  |  | Telangana
 |  |  |  |  |  | Telangana (TS)
 |  |  |  |  |  | Tripura
 |  |  |  |  |  | UAE
 |  |  |  |  |  | United States
 |  |  |  |  |  | Uttar Pradesh (UP)
 |  |  |  |  |  | Uttarakhand
 |  |  |  |  |  | West Bengal
 |  |  |  |  |  | [NAME] (WB)
Spreadsheet: 810931d1672180827-lookup-error-sos
Sheet: Troop Development

 | Training Needs |  |  |  |  |  | Full Training Sessions Needed |  |  |  |  |  | Partial Training Counts |  |  |  |  |  | Currently In Training
 | Level | Infantry | Riders | Hunters | Total |  | Level | Infantry | Riders | Hunters | Total |  | Level | Infantry | Riders | Hunters | Total |  | Level | Infantry | Riders | Hunters | Total
 |  | Barracks | Garage | Range |  |  |  | Barracks | Garage | Range |  |  |  | Barracks | Garage | Range |  |  |  | Barracks | Garage | Range
 | 1 |  |  |  |  |  | 1 |  |  |  |  |  | 1 |  |  |  |  |  | 1
 | 2 |  |  |  |  |  | 2 |  |  |  |  |  | 2 |  |  |  |  |  | 2
 | 3 |  |  |  |  |  | 3 |  |  |  |  |  | 3 |  |  |  |  |  | 3
 | 4 |  |  |  |  |  | 4 |  |  |  |  |  | 4 |  |  |  |  |  | 4
 | 5 |  |  |  |  |  | 5 |  |  |  |  |  | 5 |  |  |  |  |  | 5
 | 6 |  |  |  |  |  | 6 |  |  |  |  |  | 6 |  |  |  |  |  | 6
 | 7 |  |  |  |  |  | 7 |  |  |  |  |  | 7 |  |  |  |  |  | 7
 | 8 |  |  |  |  |  | 8 |  |  |  |  |  | 8 |  |  |  |  |  | 8
 | 9 |  |  |  |  |  | 9 |  |  |  |  |  | 9 |  |  |  |  |  | 9
 | 10 |  |  |  |  |  | 10 |  |  |  |  |  | 10 |  |  |  |  |  | 10
 | Overall Training Need |  |  |  |  |  | Overall Training Sessions Needed |  |  |  |  |  | Total |  |  |  |  |  | Currently Training
 | Total Upgradable |  |  |  |  |  | Full Upgrade Sessions Needed |  |  |  |  |  | Partial Training Counts |  |  |  |  |  | Currently Upgrading
 | Level | Infantry | Riders | Hunters | Total |  | Level | Infantry | Riders | Hunters | Total |  | Level | Infantry | Riders | Hunters | Total |  | Level | Infantry | Riders | Hunters | Total
 |  | Barracks | Garage | Range |  |  |  | Barracks | Garage | Range |  |  |  | Barracks | Garage | Range |  |  |  | Barracks | Garage | Range
 | 1 |  |  |  |  |  | 1 |  |  |  |  |  | 1 |  |  |  |  |  | 1
 | 2 |  |  |  |  |  | 2 |  |  |  |  |  | 2 |  |  |  |  |  | 2
 | 3 |  |  |  |  |  | 3 |  |  |  |  |  | 3 |  |  |  |  |  | 3
 | 4 |  |  |  |  |  | 4 |  |  |  |  |  | 4 |  |  |  |  |  | 4
 | 5 |  |  |  |  |  | 5 |  |  |  |  |  | 5 |  |  |  |  |  | 5
 | 6 |  |  |  |  |  | 6 |  |  |  |  |  | 6 |  |  |  |  |  | 6
 | 7 |  |  |  |  |  | 7 |  |  |  |  |  | 7 |  |  |  |  |  | 7
 | 8 |  |  |  |  |  | 8 |  |  |  |  |  | 8 |  |  |  |  |  | 8
 | 9 |  |  |  |  |  | 9 |  |  |  |  |  | 9 |  |  |  |  |  | 9
 | 10 |  |  |  |  |  | 10 |  |  |  |  |  | 10 |  |  |  |  |  | 10
 | Overall Upgradable |  |  |  |  |  | Overall Upgrading Sessions Needed |  |  |  |  |  | Total Partial counts |  |  |  |  |  | Currently Training
Spreadsheet: 708561d1607930034-waybill-puzzle-max-weight-total-lbs-to-max-150-carry-over-remainder-and-repeat-waybill-puzzle_solver-jimmy-ans
Sheet: Model

Item | Qty | Lbs | Total lbs | [NAME] lbs |  | What I want it to have my formulate produce as the end result
 |  |  |  | 150 |  | Waybill 1 | Waybill 2 | Waybill 3 | Total |  |  |  | Waybill 1 | Waybill 2 | Waybill 3 | Total
Clear ziplock baggies | 1 | 40 |  |  |  |  |  |  |  |  |  |  | 0 | 1 | 0
baggies tie close | 2 | 40 |  |  |  |  |  |  |  |  |  |  | 0 | 1 | 1
cans | 2 | 17 |  |  |  |  |  |  |  |  |  |  | 2 | 0 | 0
Sterile water | 8 | 15 |  |  |  |  |  |  |  |  |  |  | 7 | 1 | 0
Swabs | 2 | 6 |  |  |  |  |  |  |  |  |  |  | 0 | 1 | 1
Spoons | 8 | 6 |  |  |  |  |  |  |  |  |  |  | 0 | 8 | 0
Straps | 3 | 3 |  |  |  |  |  |  |  |  |  |  | 3 | 0 | 0
dowels | 1 | 2 |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 1
blister pacsk | 1 | 1 |  |  |  |  |  |  |  |  |  |  | 1 | 0 | 0
screens | 2 | 1 |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 0
Straws | 1 | 0.5 |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 1
 |  |  |  |  | Total lbs
 |  |  |  |  | Total lbs
 |  |  |  |  |  | =< | =< | =<
 |  |  |  |  |  | 150 | 150 | 150
 |  | Objective |  |  | Weight | 1000 | 100 | 10
Spreadsheet: 84485174-7c02-4286-861d-0b7df180a741
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
[NAME] | Twin | Sex | Date of Sample Collection | Age at Sample Collection (months)
018 | A | Female | 2008-08-20 00:00:00 | 7.956164383561644
018 | B | Female | 2008-08-20 00:00:00 | 7.956164383561644
027 | A | Female | 2008-08-25 00:00:00 | 8.252054794520546
027 | B | Female | 2008-08-25 00:00:00 | 8.252054794520546
057 | B | Female | 2008-09-02 00:00:00 | 20.58082191780822
057 | A | Female | 2008-09-02 00:00:00 | 20.58082191780822
060 | A | Female | 2008-09-02 00:00:00 | 21.7972602739726
060 | B | Female | 2008-09-02 00:00:00 | 21.7972602739726
107 | A | Female | 2008-09-23 00:00:00 | 16.33972602739726
107 | B | Female | 2008-09-23 00:00:00 | 16.33972602739726
146 | A | Female | 2008-11-14 00:00:00 | 17.81917808219178
146 | B | Female | 2008-11-14 00:00:00 | 17.81917808219178
147 | B | Female | 2008-11-14 00:00:00 | 23.53972602739726
147 | A | Female | 2008-11-14 00:00:00 | 23.53972602739726
187 | B | Female | 2008-12-15 00:00:00 | 6.082191780821918
187 | A | Female | 2008-12-15 00:00:00 | 6.082191780821918
188 | A | Female | 2008-12-15 00:00:00 | 0.6904109589041096
188 | B | Female | 2008-12-15 00:00:00 | 0.6904109589041096
193 | A | Female | 2008-12-16 00:00:00 | 5.457534246575342
193 | B | Female | 2008-12-16 00:00:00 | 5.457534246575342
208 | A | Female | 2008-12-30 00:00:00 | 0.3945205479452054
208 | B | Female | 2009-01-06 00:00:00 | 0.6246575342465753
236 | A | Female | 2009-01-26 00:00:00 | 1.545205479452055
236 | B | Female | 2009-01-26 00:00:00 | 1.545205479452055
273 | A | Female | 2009-03-09 00:00:00 | 8.383561643835616
273 | B | Female | 2009-03-09 00:00:00 | 8.383561643835616
005 | A | Male | 2008-08-18 00:00:00 | 9.008219178082193
005 | B | Male | 2008-08-18 00:00:00 | 9.008219178082193
026 | A | Male | 2008-08-25 00:00:00 | 14.3013698630137
026 | B | Male | 2008-08-25 00:00:00 | 14.3013698630137
080 | A | Male | 2008-09-12 00:00:00 | 14.26849315068493
080 | B | Male | 2008-09-12 00:00:00 | 14.26849315068493
121 | A | Male | 2008-10-14 00:00:00 | 5.194520547945205
121 | B | Male | 2008-10-14 00:00:00 | 5.194520547945205
165 | A | Male | 2008-12-02 00:00:00 | 5.326027397260274
165 | B | Male | 2008-12-02 00:00:00 | 5.326027397260274
186 | A | Male | 2008-12-12 00:00:00 | 24.23013698630137
186 | C | Male | 2008-12-12 00:00:00 | 24.23013698630137
228 | A | Male | 2009-01-23 00:00:00 | 2.038356164383562
228 | B | Male | 2009-01-23 00:00:00 | 2.038356164383562
235 | B | Male | 2009-01-23 00:00:00 | 7.989041095890411
235 | A | Male | 2009-01-23 00:00:00 | 7.989041095890411
257 | A | Male | 2009-02-20 00:00:00 | 2.334246575342466
257 | B | Male | 2009-02-20 00:00:00 | 2.334246575342466
279 | A | Male | 2009-03-13 00:00:00 | 8.416438356164385
279 | B | Male | 2009-03-13 00:00:00 | 8.416438356164385