tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 690845d1597318568-no-body-can-fill-this-sheet-if-todays-date-over-password-protected-covid-checklist
Sheet: Sheet2 (2)

 | [NAME] For Daily Meeting
 | Activities | Ajay Pattewar |  |  |  |  |  |  | Sanjay katkade |  |  |  |  |  |  | Hariharan A |  |  |  |  |  |  | Ashok Dhongade |  |  |  |  |  |  | Harshad Kulkarni |  |  |  |  |  |  | Vasant Khairnar |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  | [NAME]
 |  | JULY |  |  |  |  |  |  | JULY |  |  |  |  |  |  | JULY |  |  |  |  |  |  | JULY |  |  |  |  |  |  | JULY |  |  |  |  |  |  | JULY |  |  |  |  |  |  | JULY |  |  |  |  |  |  | JULY |  |  |  |  |  |  | JULY
 |  | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 4 | 5 | 6 | 7 | 8 | 9 | 10
 | A-1
 | A-2
 | A-3
 | A-4
 | A-5
 | A-6
 | A-7
 | A-8
 | [NAME]
 | Note:      A-1: All Alone come to office by own vehicle,                               A-2: Thermal scanning done at gate and fill declaration form at gate,                          A-3: Wearing of masks provided by company during duty,                                                                                         A-4: Wearing mask properly in correct way informed,                                  A-5: Non declaration or late declaration of any covid symptoms, hospitalization etc, in self or family members to company officials,                                                                                                    A-6: Non declaration of self or family members residing in same household in self declaration form,                                                                                                     A-7: Non declaration if residence is undeer containment zone,                                                                                     A-8: Use of [NAME] and soap wash periodically,                                          A-9: Social distancing maintain in office area and during going to canteen.
 | Remarks:
Spreadsheet: 91f70420-61f7-483d-9c76-a94738cb668c
Sheet: Sheet1

Careers in the Pharmaceutical Industry | 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
Typical majors | Sales | Marketing | Finance & Accounting | Information Services | Research & Development | Engineering | Human Resources | Environmental, Health & Safety | Public Affairs | Quality Assurance | Validation | Administration | Logistics/ Operations | Facility Design | Manufacturing
Accounting | l | l | l |  |  |  | l |  |  |  |  | l
Architecture |  |  |  |  |  | l |  |  |  |  |  |  |  | l
Business | l | l | l | l | l |  | l |  |  |  |  | l | l | l
Communications | l | l |  |  |  |  | l |  | l |  |  |  | l
Computer Sciences | l | l | l | l |  | l |  |  |  |  | l | l | l
Economics | l | l | l
Engineering:
Chemical | l |  |  |  | l | l |  | l |  | l | l |  | l | l | l
Biosystems Engineering | l |  |  |  | l | l |  | l |  | l | l |  | l | l | l
Electrical | l | l |  | l |  | l |  |  |  |  |  |  | l | l | l
Environmental |  |  |  |  |  | l |  | l |  |  | l |  | l | l
Industrial |  |  |  | l |  | l |  | l |  |  |  |  | l | l | l
Material |  |  |  |  | l | l |  | l |  |  |  |  | l | l
Mechanical |  |  |  |  |  | l |  | l |  |  | l |  | l | l | l
Systems |  |  |  | l |  | l |  |  |  |  | l |  | l | l | l
Finance | l | l | l |  |  |  | l |  |  |  |  |  | l
Human Resources | l | l |  |  |  |  | l |  |  |  |  |  | l
Information Systems |  |  |  | l |  |  |  |  |  |  | l |  | l
Information technology |  |  |  | l |  |  |  |  |  |  | l |  | l
Logistics |  | l |  | l
Marketing | l | l |  |  |  |  | l |  |  |  |  | l | l
MBA | l | l | l | l |  |  |  |  |  |  |  | l |  |  | l
Public Relations |  | l |  |  |  |  | l |  | l |  |  | l
Sciences:
Biology | l |  |  |  | l |  |  | l |  | l | l |  |  |  | l
Epidemiology |  |  |  |  | l |  |  |  |  | l |  |  |  |  | l
Microbiology |  |  |  |  | l |  |  | l |  | l | l |  |  |  | l
Biotechnology |  |  |  |  | l |  |  | l |  | l | l |  |  |  | l
Material Science |  |  |  |  | l |  |  |  |  |  | l |  |  |  | l
Pharmacy | l |  |  |  | l |  |  |  |  | l | l
Pharmaceutical Sciences | l | l |  |  | l |  |  | l |  | l | l |  |  |  | l
Chemistry |  |  |  |  | l |  |  |  |  | l | l
Environmental |  |  |  |  | l | l |  | l |  | l | l
Other sciences |  |  |  |  | l
Statistics |  | l | l |  | l |  |  |  |  | l | l |  |  |  | l
Spreadsheet: 0cb972fe-fdd7-4374-a4fe-2a3b649a0a11
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
 | Time Series Workbook
 | 5671.0 Lending Finance, Australia
 | TABLE 32. LEASE FINANCE COMMITMENTS, By Purpose: State (VIC), Original (Number, $000)
Related Information: | Summary Publication | Explanatory Notes | Inquiries
 | Glossary
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
1 . . . [NAME] ; |  |  | Original | A2413959X | 1985-01-01 00:00:00 | 2010-10-01 00:00:00 | 310 | $'000 | FLOW | Month | 1
1.1 . . . . . New cars and station wagons ; |  |  | Original | A2413960J | 1985-01-01 00:00:00 | 2010-10-01 00:00:00 | 310 | $'000 | FLOW | Month | 1
. . . . . . . . [New cars and station wagons (no.)] ; |  |  | Original | [NAME] | 1985-01-01 00:00:00 | 2010-10-01 00:00:00 | 310 | Number | FLOW | Month | 1
1.2 . . . . . Used cars and station wagons ; |  |  | Original | A2413962L | 1985-01-01 00:00:00 | 2010-10-01 00:00:00 | 310 | $'000 | FLOW | Month | 1
. . . . . . . . [Used cars and station wagons (no.)] ; |  |  | Original | A2413963R | 1985-01-01 00:00:00 | 2010-10-01 00:00:00 | 310 | Number | FLOW | Month | 1
1.3 . . . . . Other motor vehicles  ; |  |  | Original | A2413964T | 1985-01-01 00:00:00 | 2010-10-01 00:00:00 | 310 | $'000 | FLOW | Month | 1
1.3.1a . . . . . . - new trucks ; |  |  | Original | A2413965V | 1985-01-01 00:00:00 | 2010-10-01 00:00:00 | 310 | $'000 | FLOW | Month | 1
. . . . . . . . . . . . [new trucks (no.)] ; |  |  | Original | A2413966W | 1985-01-01 00:00:00 | 2010-10-01 00:00:00 | 310 | Number | FLOW | Month | 1
1.3.3 a. . . . . . - used trucks ; |  |  | Original | A2413967X | 1985-01-01 00:00:00 | 2010-10-01 00:00:00 | 310 | $'000 | FLOW | Month | 1
. . . . . . . . . . . . [used trucks (no.)] ; |  |  | Original | A2413968A | 1985-01-01 00:00:00 | 2010-10-01 00:00:00 | 310 | Number | FLOW | Month | 1
1.3.5 . . . . . . . - trailers, buses, coaches, other MVs ; |  |  | Original | A2413969C | 1985-01-01 00:00:00 | 2010-10-01 00:00:00 | 310 | $'000 | FLOW | Month | 1
2 . . . Other Transport Equipment ; |  |  | Original | A2413970L | 1985-01-01 00:00:00 | 2010-10-01 00:00:00 | 310 | $'000 | FLOW | Month | 1
3 . . . Agricultural, Construction & Manufacturing Equipment ; |  |  | Original | A2413971R | 1985-01-01 00:00:00 | 2010-10-01 00:00:00 | 310 | $'000 | FLOW | Month | 1
4 . . . Office Equipment ; |  |  | Original | A2413972T | 1985-01-01 00:00:00 | 2010-10-01 00:00:00 | 310 | $'000 | FLOW | Month | 1
5 . . . Other ; |  |  | Original | A2413973V | 1985-01-01 00:00:00 | 2010-10-01 00:00:00 | 310 | $'000 | FLOW | Month | 1
TOTAL LEASE FINANCE ; |  |  | Original | A2413974W | 1985-01-01 00:00:00 | 2010-10-01 00:00:00 | 310 | $'000 | FLOW | Month | 1
© Commonwealth of Australia  2010
Spreadsheet: 47991d1247165824-calculating-work-days-days
Sheet: גיליון1

date | name |  |  | days |  | days
2009-07-01 00:00:00 | [NAME] |  | [NAME] | 1 |  | 3
2009-07-01 00:00:00 | [NAME] |  | [NAME] | 0.6000000000000001 |  | 2
2009-07-01 00:00:00 | asaf |  | asaf | 1 |  | 3
2009-07-01 00:00:00 | [NAME] |  | greg | 0.4 |  | 2
2009-07-01 00:00:00 | greg
2009-07-02 00:00:00 | [NAME]
2009-07-02 00:00:00 | [NAME]
2009-07-02 00:00:00 | [NAME]
2009-07-02 00:00:00 | asaf
2009-07-02 00:00:00 | asaf
2009-07-03 00:00:00 | [NAME]
2009-07-03 00:00:00 | [NAME]
2009-07-03 00:00:00 | asaf
2009-07-03 00:00:00 | asaf
2009-07-03 00:00:00 | greg
Spreadsheet: 470fe459-cf1f-471e-8305-787478b99c1c
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
VPA | Test | VPA | Valproic Acid, Total, Serum | Valproic Acid, Tot, S | Immunoassay | Plain, Red-Top Tube: Red |  |  | 1 | mL | Container/Tube: Red top [NAME]: 1 mL | 0.4 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm OK; Cold OK Lipemia	Mild OK; Gross reject Icterus	Mild OK; Gross reject Other	NA | Therapeutic concentration: 40 (trough)-100 (peak) mcg/mL Toxic concentration: > or =120 mcg/mL | Monday through Sunday; Varies | Same day/1 day | 1 day | 1 | 80164 |  |  |  |  | Rochester
VPA | [NAME] | SRED | Serum Red |  |  |  | Refrigerated | 14 days
VPA | Result | 8707 | Valproic Acid, Tot, S | Valproic Acid, Tot, S | Numeric |  |  |  |  | mcg/mL |  |  |  |  |  |  |  |  |  | 4086-5 | Valproate:MCnc:Pt:Ser/Plas:Qn:
Spreadsheet: 134238d1325122198-excel-2007-getaddress-for-multi-cells-problem-gymtest
Sheet: ogblist

 | Club Name | Venue Address | Club Disciplines | Telephone / Email
 | O.l.g.a. Poole | Olga Gymnastics Centre |  | 1202738585
 |  | [NAME]
 |  | Parkstone |  | [NAME]
 |  | Poole
 |  | BH12 4HR
 | Oadby & Leicester Gym Club | [NAME] |  | 1162810308
 |  | Oadby
 |  | Leicester |  | [NAME]
 |  | Leicestershire
 |  | LE2 5TP
 | Oldham Central Trampoline Club | Brierley Avenue |  | 1617855070
 |  | Failsworth
 |  | [NAME] |  | [NAME]
 |  | M35 9HA
 | Oldham Central Trampoline Club | Brierley Avenue |  | 1617855070
 |  | [NAME]
 |  | M35 9HA |  | [NAME]
 | Olympia Trampoline Club | [NAME] |  | 7729695192
 |  | Oadby
 |  | Leicester |  | [NAME]
 |  | Leicestershire
 |  | LE2 5TP
 | Olympiad Leisure Centre | Sadlers Mead |  | 01249444 144
 |  | Chippenham
 |  | Wiltshire |  | [NAME]
 |  | SN15 3PA
 | Olympiad Leisure Centre | Sadlers Mead |  | 01249444 144
 |  | Chippenham
 |  | Wiltshire |  | [NAME]
 |  | SN15 3PA
 | Oratory Gymnastics Club | Great Oaks |  | 1491875628
 |  | [NAME]
 |  | Reading |  | [NAME]
 |  | Berkshire
 |  | RG8 7SF
 | Orbit [NAME] | [NAME] |  | 1908313048
 |  | [NAME]
 |  | Leadenhall |  | [NAME]
 |  | [NAME]
 |  | Buckinghamshire
 |  | MK6 5EJ
 | Orbital Stars Trampoline Club | Depot Road |  | 1403734448
 |  | [NAME]
 |  | West Sussex |  | [NAME]
 |  | RH13 5HR
 | Orchard Gymnastics Ltd | Pen Mill Trading Estate |  | 1935425682
 |  | Yeovil
 |  | Somerset |  | [NAME]
 |  | BA21 5HR
 | Orpington Gymnastic Club | [NAME] |  | 1689830749
 |  | Orpington
 |  | Kent |  | [NAME]
 |  | BR6 0TJ
 | Otley Gym Club | Chapel Road |  | [NAME]
 |  | Otley
 |  | Ipswich
 |  | Suffolk
 |  | IP6 9NT
 | Otley Rhythmic Gym Club | [NAME] |  | 1132507524
 |  | Otley
 |  | West Yorkshire |  | [NAME]
 |  | LS21 2BB
 | Oval Gymnastic Club | Old Chester Road |  | 1516777686
 |  | Bebington
 |  | Wirral |  | [NAME]
 |  | Cheshire
 |  | CH63 7LF
 | [NAME] | Towersey Road |  | 1844278352
 |  | Thame
 |  | Oxfordshire |  | [NAME]
 |  | OX9 3NW
 | Oxford University Trampoline | Oxford University |  | [NAME]
 |  | Sports Complex
 |  | [NAME]
 |  | Oxford
 |  | Oxfordshire
 |  | OX4 1EQ
 |  |  |  | [EMAIL] |  | [EMAIL]
 |  |  |  | [EMAIL] |  | [EMAIL]
 |  |  |  | [NAME]
 |  |  |  | [NAME]
 |  |  |  | [EMAIL]
 |  |  |  | [NAME]
 |  |  |  | [NAME]
 |  |  |  | [NAME]
 |  |  |  | [NAME]
 |  |  |  | [NAME]
 |  |  |  | [NAME]
 |  |  |  | [NAME]
 |  |  |  | [NAME]
 |  |  |  | [NAME]
 |  |  |  | [NAME]
 |  |  |  | [NAME]
 |  |  |  | [NAME]
Spreadsheet: 727474d1617904383-creating-a-vlookup-formule-with-two-search-criteria-test_ex
Sheet: Feuil2

ISOCODE | DATE_OF_LAST_INDEX | NAME_COUNTRY | CPI_OF_LAST_INDEXATION
AR | 2020-02-02 00:00:00 | ARSENAL | 55
AS | 2019-10-02 00:00:00 | ASIA | 99
BE | 2020-06-02 00:00:00 | BELGIUM | 63
CN | 2019-11-02 00:00:00 | CHINA | 44
FR | 2020-05-02 00:00:00 | FRANCE | 63
IS | 2020-09-02 00:00:00 | ISLAND | 99
Spreadsheet: holden_salisbury__12306__July 2001 tranny
Sheet: Sheet1

 | Data
Act Date | Sum of Gross MW | Average of Price | Sum of Total Amt
2001-07-03 00:00:00 | -225 | 0 | -639
2001-07-05 00:00:00 | -225 | 0 | -639
2001-07-06 00:00:00 | -320 | 0 | -908.8
2001-07-07 00:00:00 | -320 | 0 | -908.8
2001-07-09 00:00:00 | -310 | 0 | -880.4
2001-07-26 00:00:00 | -320 | 0 | -864
2001-07-31 00:00:00 | -320 | 0 | -908.8
Grand Total | -2040 | 0 | -5748.8
Schedule 1    Scheduling, System Control, and Dispatch Services -  $0.047 per MWh
ST_SW 1950 MW x 0.047 = 91.65
ST_WROCKIES 90 MW x 0.047 = 4.23
Total: 2040 MW x 0.047 = $95.88
Schedule 2    Reactive Supply and Voltage Control - $0.066 per MWh
ST_SW 1950 MW x 0.066 = 128.70
ST_WROCKIES 90 MW x 0.066 = 5.94
2040 MW x 0.066 = $134.64
Schedule 9    Loss Compensation Service - $3.00 per MWh
ST_SW 1950 MW x $3.00 = 5850.00
ST_WROCKIES 90 MW x $3.00 = 270.00
2040 MW x $3.00 = $6120.00
New Mexico Gross Receipts Tax - 5.75% of gross charges for the month
ST_SW [2.84 x 1950 MW + (91.65 + 128.70 + 5850)] x 5.75% = 667.48
ST_WROCKIES [2.84 x 90 MW + (4.23 + 5.94 + 270.00)] x 5.75% = 30.81
($5748 energy charge + $6350.52 ancillary charge total) x 5.75% = $ 698.29
Total ST_SW Annuity #  735993.1 $ 6,737.83
Total ST_WROCKIES Annuity #  $ 310.98
Spreadsheet: 775729d1649274884-determine-quadrant-on-co-ordinate-plane-formula-help
Sheet: Dis, Bear, N&E

Point # | Easting | Northing | RD | [NAME] | Bearing ([NAME]) | Remarks |  | Key
1 | 928830.615 | 1950490.869 |  |  |  |  |  | 1st | N+, E+ | No Change
2 | 928580.671 | 1950458.194 |  |  |  |  |  | 2nd | N-, E+ | 180-RD
Diff |  |  |  |  |  |  |  | 3rd | N-, E- | RD+180
 |  |  |  |  |  |  |  | 4th | N+, E- | 360-RD
Dear Experts,  I need a formula; the sheet is attached. I need a formula in cell "E3";  the formula should show the result as:  Result: "1st"         Condition: If N is + & E is + Result: "2nd"        Condition: If N is - & E is + Result: "3rd"         Condition: If N is - & E is - Result: "4th"         Condition: If N is + & E is -  Next in cell "F3"; I need a formula based on cell "E3"; the formula should show the result as:  Result: "=D3"                Condition: If E3=1st Result: "=180-D3"         Condition: If E3=2nd Result: "=D3+180"         Condition: If E3=3rd Result: "=360-D3"         Condition: If [NAME]
Spreadsheet: 585581d1533835113-median-if-with-subtotals-medianifsubtotal
Sheet: Sheet1

 | Description | Classification | Season | Unit Sales |  | Classification | Median Unit Sales (Unfiltered) | Median Unit Sales (Season Filtered to 'Spring')
 | Necklace1 | Necklaces | Spring | 330 |  | Necklaces
 | Necklace2 | Necklaces | Spring | 264 |  | Bracelets
 | Necklace3 | Necklaces | Spring | 259 |  | Rings
 | Necklace4 | Necklaces | Summer | 293
 | Necklace5 | Necklaces | Summer | 354 |  | formula in H3: =MEDIAN(IF($C$3:$C$32=$G3,$E$3:$E$32))
 | Necklace6 | Necklaces | Summer | 344
 | Necklace7 | Necklaces | Fall | 357
 | Necklace8 | Necklaces | Fall | 295
 | Necklace9 | Necklaces | Holiday | 391
 | Necklace10 | Necklaces | Holiday | 263
 | Bracelet1 | Bracelets | Spring | 270
 | Bracelet2 | Bracelets | Spring | 397
 | Bracelet3 | Bracelets | Spring | 393
 | Bracelet4 | Bracelets | Summer | 364
 | Bracelet5 | Bracelets | Summer | 273
 | Bracelet6 | Bracelets | Summer | 211
 | Bracelet7 | Bracelets | Fall | 344
 | Bracelet8 | Bracelets | Fall | 319
 | Bracelet9 | Bracelets | Holiday | 396
 | Bracelet10 | Bracelets | Holiday | 211
 | Ring1 | Rings | Spring | 249
 | Ring2 | Rings | Spring | 351
 | Ring3 | Rings | Spring | 228
 | Ring4 | Rings | Summer | 284
 | Ring5 | Rings | Summer | 211
 | Ring6 | Rings | Summer | 278
 | Ring7 | Rings | Fall | 248
 | Ring8 | Rings | Fall | 352
 | Ring9 | Rings | Holiday | 252
 | Ring10 | Rings | Holiday | 264
Spreadsheet: 87968d1287848546-pulling-data-from-sheet1-to-a-list-in-sheet-2-based-upon-a-date-range-getcars
Sheet: Sheet1

Car: | Date Driven:
Taurus | 2010-01-03 00:00:00
Tempo | 2010-01-09 00:00:00
Falcon | 2010-01-15 00:00:00
Escort | 2010-01-22 00:00:00
RS400 | 2010-02-05 00:00:00
Mazda 3 | 2010-02-08 00:00:00
Stratos | 2010-02-16 00:00:00
Vega | 2010-02-22 00:00:00
Volvo | 2010-02-27 00:00:00
Spreadsheet: 0386ef1b-e253-44ea-8771-72ef57395fae
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
Cuadro 3.23-09-1
[NAME]
Ingresos municipales por fuente, según año, 1998-2007
(Valor en RD$)
[NAME] | Total de ingresos según fuente | Ingresos bienes municipales | Ingresos por [NAME] y permiso | Ingresos por servicios municipales productivos | Ingresos eventuales | Ingresos por subsidio del estado | Ingresos extraordinarios
1998 | 1197594636 | 10074147 | 62192137 | 59553252 | 33628911 | 970862893 | 61283296
1999 | 2017818069 | 15639300 | 226314972 | 117350337 | 48043908 | 1513989448 | 94557219
2000 | 1183057465 | 10607657 | 64159592 | 53604995 | 34233967 | 964947958 | 55503296
2001 | 1549199305 | 16394433 | 74320090 | 84628202 | 69123615 | 1216303469 | 88429496
2002 | 440990118 | 2968215 | 11861197 | 14034180 | 11453555 | 388301942 | 12371029
2003 | 1383094270 | 8172147 | 47437814 | 36487123 | 31797419 | 1218733480 | 40466287
2004 | 2912121710 | 23362282 | 106747146 | 97993999 | 65530778 | 2483705490 | 134782015
2005 | 4733463507 | 24079267 | 116064186 | 98176273 | 130790624 | 4214096410 | 150256747
2006 | 7325263046.56 | 75830536.42 | 333165723.31 | 706282813.88 | 116191678.36 | 4566206959.79 | 1527585334.8
2007P | 274657859434.51 | 438760792.66 | 3130156295.45 | 4104971777.23 | 9108515073.16 | 253371166011.22 | 4504289484.79
(P): [NAME] preliminares
Fuentes: [NAME] y la Liga Municipal Dominicana
Spreadsheet: 746084d1630497521-solver-excel-problem-how-to-create-the-optimal-boxes-mix-to-respect-the-constrains-solver
Sheet: Solver

 | I want to pay the cheaper amount possible to send all the itens listed above (total 64). I have the freight value in the table below and I have the constraint that all boxes need to be less than $50 to avoid the import tax fee.
 | TAX FEE
 | All the boxes need to be less than $50, otherwise I will 60% of tax fee.
 | Standard Freight
 | Pounds | Cost
 | 0 - 1 | 18.98
 |  | 28.98
 |  | 38.98
 |  | 48.98
 | The problem
 | Minimize the number of boxes to reduce freight costs and also avoid tax fee
 | Product | Quantity I have | Unit Pounds | Total Pounds | Unite price | Total Cost
 | ITEM #1 | 6 | 0.1433 |  | 4.99
 | ITEM #2 | 5 | 0.2033 |  | 10
 | ITEM #3 | 3 | 0.71 |  | 8.7
 | ITEM #4 | 3 | 0.1467 |  | 34
 | ITEM #5 | 5 | 0.356 |  | 29.5
 | ITEM #6 | 10 | 0.2033 |  | 7.2
 | ITEM #7 | 3 | 0.1633 |  | 30
 | ITEM #8 | 3 | 0.1133 |  | 7.9
 | ITEM #9 | 5 | 0.376 |  | 9.99
 | ITEM #10 | 5 | 0.278 |  | 7.7
 | ITEM #11 | 5 | 0.106 |  | 6.99
 | ITEM #12 | 3 | 0.2033 |  | 5.9
 | ITEM #13 | 5 | 0.166 |  | 9.99
 | ITEM #14 | 3 | 0.2033 |  | 9.8
 | TOTAL
Spreadsheet: 149f4cda-ba8b-4fe3-83bb-95279e34e514
Sheet: Sheet1

COUNTY SUMMARY/BALLOTS CAST | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
 | Republican |  |  | Democratic
 | Regular | Absentee | Total | Regular | Absentee | Total
Belknap County | 3299 | 112 | 3411 | 1702 | 57 | 1759
Carroll County | 3023 | 106 | 3129 | 1961 | 101 | 2062
Cheshire County | 3115 | 65 | 3180 | 3379 | 90 | 3469
Coos County | 1452 | 52 | 1504 | 1051 | 38 | 1089
Grafton County | 3138 | 124 | 3262 | 2906 | 140 | 3046
Hillsborough County | 11536 | 419 | 11955 | 11364 | 819 | 12183
Merrimack County | 6166 | 185 | 6351 | 5471 | 208 | 5679
Rockingham County | 12684 | 476 | 13160 | 9402 | 330 | 9732
Strafford County | 3388 | 86 | 3474 | 4944 | 166 | 5110
Sullivan County | 1566 | 32 | 1598 | 1536 | 51 | 1587
Totals | 49367 | 1657 | 51024 | 43716 | 2000 | 45716
Spreadsheet: 0f8fd283-bd55-4049-b6d3-4b71dfe28aee
Sheet: Table IV.6

Table IV.6 الجدول
Selected Indicators for Air Quality in Kuwait
مؤشرات مختارة لقياس نوعية الهواء في الكويت
 | 2007 | 2008 | 2009
Name of Site | [NAME] |  |  | [NAME]
Emissions of Nitrogen Oxide (NO) (ppb) | 24 | 21 | 19 | [NAME] النيتروجين
Annual Mean Concentrations of Nitrogen Dioxide (NO2) in Ambient Air in Urban City (ppb) | 24 | 28 | 31 | معدل التركز السنوي لثاني أكسيد النيتروجين (NO2) في الهواء المحيط في مدينة حضرية
Annual Mean Concentrations of Sulfur Dioxide (SO2) in Ambient Air in Urban City (ppb) | 8 | 5 | 4 | معدل التركز السنوي لثاني أكسيد الكبريت (SO2) في الهواء المحيط في مدينة حضرية
Emissions of Methane (CH4) (ppm) | 1.831 | 1.82 | 1.69 | [NAME] (CH4)
Emissions of Carbone Dioxide (CO2) in Ambient Air in Urban City (ppm) | … | 352.45 | 349.29 | انبعاثات ثاني [NAME] (CO2) في الهواء المحيط في مدينة حضرية
Emissions of Ozone (O3) (ppm) | 26 | 22 | 21 | [NAME] (O3)
Annual Mean Concentration of Carbon Monoxide (CO) in Ambient Air in Urban City (ppm) | 0.942 | 0.64 | 0.64 | معدل التركز السنوي لأكسيد الكربون (CO) في الهواء المحيط في مدينة حضرية
Annual Mean Concentrations of Suspended Particulate Matter (PM10) in Ambient Air in Urban City (µg/m3) | … | 168.79 | 218.6 | معدل التركز السنوي للجسيمات العالقة في الهواء المحيط في مدينة حضرية
Source: | Annual Statistical Abstract 2009, Edition 46, State of Kuwait, December 2010.
Spreadsheet: 843460d1695288118-help-with-populating-data-in-correct-debit-and-credit-fields-jounral-upload-sage-intacct
Sheet: Sheet2

DONOTIMPORT | JOURNAL | DATE | REVERSEDATE | [NAME] | REFERENCE_NO | LINE_NO | ACCT_NO | LOCATION_ID | DEPT_ID | DOCUMENT | MEMO | DEBIT | CREDIT | SOURCEENTITY | ALLOCATION_ID | BILLABLE | TAXIMPLICATIONS | TAXSOLUTIONID | TAX_VENDORID | TAX_CUSTOMERID | TAX_CONTACTID | TAX_DETAILID | TAX_AMOUNT | SAGE50_REFERENCE | SAGE50_JOURNAL | GLENTRY_VENDORID | GLENTRY_EMPLOYEEID | GLENTRY_CLASSID | TAX_LINE_NO
 | GJ | 2023-08-31 00:00:00 |  | Aug'23 | 1 | 1 | 400000 | ACC |  |  |  |  |  |  |  |  |  | United Kingdom - VAT |  |  |  |  |  |  |  |  |  |  | 1
 | GJ | 2023-08-31 00:00:00 |  | Aug'23 | 1 | 2 | 202090 | ACC |  |  |  |  |  |  |  |  |  | United Kingdom - VAT |  |  |  |  |  |  |  |  |  |  | 1
 | GJ | 2023-08-31 00:00:00 |  | Aug'23 | 1 | 1 | 400000 | AMH |  |  |  |  |  |  |  |  |  | United Kingdom - VAT
 | GJ | 2023-08-31 00:00:00 |  | Aug'23 | 1 | 2 | 202090 | AMH |  |  |  |  |  |  |  |  |  | United Kingdom - VAT
 | GJ | 2023-08-31 00:00:00 |  | Aug'23 | 1 | 1 | 400000 | BCH |  |  |  |  |  |  |  |  |  | United Kingdom - VAT
 | GJ | 2023-08-31 00:00:00 |  | Aug'23 | 1 | 2 | 202090 | BCH |  |  |  |  |  |  |  |  |  | United Kingdom - VAT
 |  |  |  | example RESULT |  |  | 400000 | ACC |  |  |  |  | 137476.44
 |  |  |  | example RESULT |  |  | 202090 | ACC |  |  |  | 137476.44
 |  |  |  | example RESULT |  |  | 400000 | BCH |  |  |  | 65697.14
 |  |  |  | example RESULT |  |  | 202090 | BCH |  |  |  |  | 65697.14
 |  |  | NOTES: | The numbers can be pulled from either sheet 'data' or 'Pivot'
 |  |  |  | 400000 | This should represent the total of Location ID from either of the sheets in Debit column M if the sum is in positive & in Credit column N if the sum is in negative.
 |  |  |  | 202090 | Row 3, 5, 7 should replicate the same number in the field above from 400000. If 400000 has a value in credit, the value below should appear in debit in row 3 column M and vice versa.
 |  |  |  | I have shown what the results should be manually in row 9 to 13.
Spreadsheet: 267208d1380012832-vlookup-function-0a215_a
Sheet: Schmitt, Justin

Schmitt, Justin
Umpire | Player | Team | Position | Votes | Team Margin | K | H | D | CP | UP | DE% | CLG | M | CM | M50 | HO | CLR | CC | ST | R50 | FF | FA | T | 0.01 | Bo | [NAME] | G | B | GA | G% | TG% | DT