tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 708573d1607935931-waybill-puzzle-max-weight-total-lbs-to-max-150-carry-over-remainder-and-repeat-waybill-puzzle_solver-jimmy-ans-2
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
 |  |  |  |  | G total
 |  |  |  |  | Total lbs
 |  |  |  |  |  | =< | =< | =<
 |  |  |  |  |  | 150 | 150 | 150
 |  | Objective |  |  | Weight | 1000 | 100 | 10
Spreadsheet: 453564d1459359992-cant-copy-formula-down-16-03-08-formulaire-des-prix
Sheet: Alegria

 | Alegria
 | Produit | Status | Code | Prix | Qté | /Kg | Marque | Provenance | Note
 | Spaghetti d'épeautre |  |  | 32 | 5 |  | Alegria | Québec
 | Spaghetti de Khorasan |  | pspakam5 | 28 | 5 |  | Alegria | Québec
Spreadsheet: 4dd49713-f15d-4e2e-87aa-7ce8107168a8
Sheet: Sheet1

Milwaukee Season Schedule | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
Date | Game Number | Visiting Team | Visiting Score | Home Team | Home Score | Game Time/Status | Venue
2013-04-26 | 1 | Texas | 3 | Milwaukee | 2 | Final OT | [NAME] Center Milwaukee, WI
2013-04-27 | 2 | Texas | 0 | Milwaukee | 2 | Final | [NAME] Center Milwaukee, WI
2013-05-01 | 3 | Milwaukee | 0 | Texas | 2 | Final | Cedar Park Center Cedar Park, TX
2013-05-03 | 4 | Milwaukee | 1 | Texas | 2 | Final | Cedar Park Center Cedar Park, TX
Spreadsheet: 739131d1625544373-if-function-stacked-up-to-be-simplified-if-function-stacked-up-to-be-simplified
Sheet: Sheet1

Date | Reading | Usage
2020-01-19 00:00:00 | 27611
2020-01-20 00:00:00 | 27907
2020-01-21 00:00:00 | 28203
2020-01-22 00:00:00
2020-01-23 00:00:00 | 28800
2020-01-24 00:00:00
2020-01-25 00:00:00
2020-01-26 00:00:00 | 29693
2020-01-27 00:00:00
2020-01-28 00:00:00 | 30268
2020-01-29 00:00:00
2020-01-30 00:00:00
2020-01-31 00:00:00
2020-02-01 00:00:00
2020-02-02 00:00:00
2020-02-03 00:00:00 | 32104
2020-02-04 00:00:00
2020-02-05 00:00:00
2020-02-06 00:00:00
Spreadsheet: 876630d1723360629-how-to-link-or-import-data-between-two-excel-workbooks-with-very-different-formats-daily-sheets
Sheet: 06.23.24

 | AM SHIFT REPORT
 |  |  |  | 2024-06-23 00:00:00
 | UNIT | Bed Capacity | [NAME] | Census | Census Pending | RN's | RN PD | Travel | RN OT | RN Sick | Tech | N.A. | Comments
 | 3RD FL | 13 | 7 | 3 | 0 | 2 | 0 | 1 | 0 | 1 | 0 | 0
 | 4TH FL | 38 | 22 | 14 | 0 | 3 | 0 | 1 | 0 | 0 | 2 | 0
 | 5TH FL | 34 | 20 | 13 | 0 | 3 | 0 | 1 | 0 | 0 | 1 | 0
 | ABC | 27 | 18 | 23 | 0 | 6 | 0 | 1 | 0 | 0 | 2 | 0
 | MNO | 12 | 6 | 6 | 0 | 3 | 0 | 0 | 0 | 0 | 1 | 0
 | Total MED
 | JKL | 26 | 4 | 5 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0
 | DEF | 10 | 4 | 3 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0
 | GHI | N/A | N/A | 2 | 0 | 3 | 1 | 0 | 0 | 0 | 1 | 0
 | Total MAT
 | Total Holds AM | N/A | N/A | 0 | 0 | 4 | 2 | 0 | 0 | 1 | 2 | 0
 | Total Holds MID |  |  | 0 | 0 | 4 | 1 | 0 | 0 | 0 | 1 | 0
 | Total House Census
 | PM SHIFT REPORT
 |  |  |  | 2024-06-23 00:00:00
 | UNIT | Bed Capacity | [NAME] | Census | Census Pending | RN's | RN PD | Travel | RN OT | RN Sick | Tech | N.A. | Comments
 | 3RD FL | 13 | 7 | 3 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0
 | 4TH FL | 38 | 22 | 17 | 0 | 3 | 0 | 0 | 0 | 0 | 2 | 0
 | 5TH FL | 34 | 20 | 16 | 0 | 3 | 1 | 1 | 0 | 0 | 2 | 0
 | ABC | 27 | 18 | 19 | 0 | 5 | 0 | 3 | 0 | 0 | 2 | 0
 | MNO | 12 | 6 | 4 | 0 | 3 | 0 | 0 | 0 | 0 | 0 | 0
 | Total MED
 | JKL | 26 | 4 | 4 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0
 | DEF | 10 | 4 | 2 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0
 | GHI | N/A | N/A | 2 | 0 | 3 | 1 | 0 | 0 | 0 | 1 | 0
 | Total MAT
 | Total Holds PM | N/A | N/A | 0 | 0 | 4 | 1 | 0 | 0 | 0 | 2 | 0
 | Total House Census
Spreadsheet: 740499d1626358742-excel-formula-to-fill-column-b-with-unique-values-from-column-a-question-v1
Sheet: Sheet1

TITLE A | TITLE B | TITLE C | TITLE D
a |  |  | y
d
led
d |  | x
f |  |  | y
gh |  |  | x
led
f
p |  |  | y
k |  | x
Spreadsheet: 70cd2f13-4e25-43c9-86e7-2179fd10c5dd
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
[NAME] | Test | [NAME] | Hemophilia B, Factor IX Gene Mutation Screening | Factor IX Gene Mutation Screening | Polymerase Chain Reaction (PCR)/Fluorescent DNA Sequencing (PCR is utilized pursuant to a license agreement with Roche Molecular Systems, Inc.) | Yellow-Top (ACD) Tube: ACD |  |  | 6 | mL | Container/Tube:  Preferred: Yellow top (ACD solution B) Acceptable: EDTA or sodium citrate [NAME]: 6 mL Collection Instructions:  1. Invert several times to mix blood.  2. Send specimen in original tube. Forms:  1. Hemophilia B Patient Information Sheet (Supply T518) in Special Instructions 2. New York Clients-Informed consent is required. Please document on the request form or electronic order that a copy is on file. An Informed Consent for Genetic Testing (Supply T576) is available in Special Instructions. | 3 mL | Hemolysis	Mild OK; Gross OK Thawing	Warm OK; Cold OK - phone lab Lipemia	Mild OK; [NAME] OK Icterus	NA Other	Green-top (heparin) tube or cord blood | No mutations found  An interpretive report will be issued which will include specimen information, assay information, background information, and conclusions based on the test results (ie, information about the mutation and carrier status). | Monday through Friday | 21 days | 28 days | 1 | 81405 |  |  |  |  | Rochester
[NAME] | [NAME] | BLOOD | Whole blood |  |  |  | Ambient
[NAME] | Result | 23776 | FIX Mut Screen Reason for Referral | FIX Mut Screen Reason for Referral | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 42349-1 | Reason for referral:Find:Pt:^Patient:Nar:
[NAME] | Result | 23777 | Factor IX Mutation Screen Method | Factor IX Mutation Screen Method | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
[NAME] | Result | 23778 | Factor IX Mutation Screen Result | Factor IX Mutation Screen Result | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 38896-7 | F9 gene mutation analysis:Prid:Pt:Bld/Tiss:Nom:Molgen
[NAME] | Result | 23779 | Factor IX Mutation Screen Interp | Factor IX Mutation Screen Interp | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 69049-5
[NAME] | Result | 23781 | Factor [NAME] Screen Reviewed By | Factor [NAME] Screen Reviewed By | Numeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: b114b9f3-ada3-4f2a-b2d5-ef1c59be906c
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | BIKE | T2 | SKI | POSITION | TOTAL TIME
3541 | 21549 | [NAME] | Leithner | AUT | 82 | 00:18:14 | 00:00:49 | [NAME] | 00:01:10 | 00:21:07 | 1 | 01:02:14
3541 | 10491 | Co | Looijesteijn | NED | 0 | 00:19:59 | 00:01:06 | 00:22:03 | 00:01:35 | 00:25:58 | 2 | 01:10:44
3541 | 10329 | Curt | Maier | AUT | 83 | 00:21:17 | 00:00:46 | 00:23:47 | 00:01:23 | 00:23:32 | 3 | 01:10:46
3541 | 10231 | Jan | Holiga (1947) | SVK | 0 | 00:20:30 | 00:01:25 | 00:24:56 | [NAME] | 00:26:13 | 4 | 01:14:48
3541 | 21443 | [NAME] | [NAME] | AUT | 81 | 00:21:53 | 00:01:06 | 00:24:19 | 00:01:15 | [NAME] | 5 | 01:16:55
3541 | 21547 | Erich | Schochl | AUT | 84 | 00:20:31 | 00:00:56 | 00:24:43 | 00:01:46 | 00:29:51 | 6 | 01:17:49
Spreadsheet: 725826d1616913917-search-multiple-text-in-cell-and-return-found-text-via-formula-in-another-suffix
Sheet: Sheet1

 |  | Wanted Result | My Formula
 | [NAME]
 | [NAME]
 | aa I
 | aa II
 | aa III
 | aa IV
 | aa V
 | aa VI
 | aa VII
 | aa VIII
 | aa IX
 | [NAME]
 | [NAME]
Spreadsheet: 47371d1246401044-fill-cell-w-value-present-in-another-row-if-columns-match-third-smplith_formulasfail
Sheet: Sheet1

The Specials | The Specials | Blank Expression | The Specials
 | The Specials | Blank Expression | The Specials
 | The Specials | Blank Expression | The Specials
 | The Specials | Blank Expression | The Specials
 | The Specials | Blank Expression | The Specials
Anxiety Always | Adult. | [NAME] | Anxiety Always
Here Come The Warm Jets | [NAME] | [NAME] | Here Come The Warm Jets
 | [NAME] | [NAME] | Here Come The Warm Jets
 | [NAME] | [NAME] | Here Come The Warm Jets
 | [NAME] | [NAME] | Here Come The Warm Jets
 | [NAME] | [NAME] | Here Come The Warm Jets
Adore | [NAME] | Blank Page | Adore
 | [NAME] | Blank Page | Adore
[NAME] | Shuttle 358 | Blast | [NAME]
 | Shuttle 358 | Blast | [NAME]
Siamese Dream | [NAME] | Today | Adore
 | [NAME] | Today | Adore
Another Green World | [NAME] | Becalmed | Here Come The Warm Jets
 | [NAME] | Becalmed | Here Come The Warm Jets
 |  |  | #N/A
 |  |  | #N/A
 |  |  | #N/A
 |  |  | #N/A
 |  |  | #N/A
 |  |  | #N/A
 |  |  | #N/A
 |  |  | #N/A
 |  |  | #N/A
 |  |  | #N/A
 |  |  | #N/A
 |  |  | #N/A
 |  |  | #N/A
 |  |  | #N/A
 |  |  | #N/A
 |  |  | #N/A
 |  |  | #N/A
 |  |  | #N/A
 |  |  | #N/A
 |  |  | #N/A
 |  |  | #N/A
 |  |  | #N/A
 |  |  | #N/A
 |  |  | #N/A
 |  |  | #N/A
 |  |  | #N/A
 |  |  | #N/A
Spreadsheet: 94415d1294242360-sumproduct-error-book2
Sheet: data_Hosting

 | Program Year | Program Host1 | Program Host2 | Program [NAME]
 | 2008 | Smith, [NAME]
 | 2008 | Doe, [NAME] | Smith, [NAME]
 | 2009 | [NAME], [NAME] | Doe, [NAME] | Smith, [NAME]
 | 2010 | Doe, [NAME] | Doe, [NAME]
 | Smith, [NAME] | 1
 | Smith, [NAME] | #N/A
Spreadsheet: darrell_schoolcraft__7319__imball0202
Sheet: Oasis

POI  8516
 | Measured | Scheduled | Imbal
1 | -13510 | -13500
2 | -19133 | -19000
3 | -17376 | -17500
4 | -2958 | -2500
5 | -6727 | -5000
6
7 | -6319 | -5000
8 | -352 | -6899
9
10 | -6424
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
2002-01-31 00:00:00 |  |  | 20075.23
2002-02-10 00:00:00
CBS Volume
 |  |  | 7554
Spreadsheet: 273294d1382657862-excel-ranking-with-multiple-conditions-rank_function_master_file
Sheet: Sheet2

 |  | Event | Time | Details | lay | RANK (Automation) | RANK (Manual)
 |  | [NAME] 20th Oct | 13:40:00 | 5f Nov Stks | 3.3 |  | 1
 |  | [NAME] 20th Oct | 13:40:00 | 5f Nov Stks | 3.4
 |  | [NAME] 20th Oct | 13:40:00 | 5f Nov Stks | 8.4
 |  | [NAME] 20th Oct | 13:40:00 | 5f Nov Stks | 7.2
 |  | [NAME] 20th Oct | 13:40:00 | 5f Nov Stks | 7.2
 |  | Chelt 20th Oct | 14:00:00 | 3m1f Nov Hrd | 4.2
 |  | Chelt 20th Oct | 14:00:00 | 3m1f Nov Hrd | 3.7
 |  | Chelt 20th Oct | 14:00:00 | 3m1f Nov Hrd | 7.8
 |  | Chelt 20th Oct | 14:00:00 | 3m1f Nov Hrd | 3.65 |  | 1
 |  | Chelt 20th Oct | 14:00:00 | 3m1f Nov Hrd | 20
 |  | Chelt 20th Oct | 14:00:00 | 3m1f Nov Hrd | 44
 |  | Chelt 20th Oct | 14:00:00 | 3m1f Nov Hrd | 160
 |  | Chelt 20th Oct | 14:00:00 | 3m1f Nov Hrd | 340
 |  | Kelso 20th Oct | 14:05:00 | 2m [NAME] | 4.5
 |  | Kelso 20th Oct | 14:05:00 | 2m [NAME] | 6.6
 |  | Kelso 20th Oct | 14:05:00 | 2m [NAME] | 3.7 |  | 1
 |  | Kelso 20th Oct | 14:05:00 | 2m [NAME] | 9.4
 |  | Kelso 20th Oct | 14:05:00 | 2m [NAME] | 7.6
 |  | Kelso 20th Oct | 14:05:00 | 2m [NAME] | 11
 |  | Kelso 20th Oct | 14:05:00 | 2m [NAME] | 110
 |  | Kelso 20th Oct | 14:05:00 | 2m [NAME] | 520
Spreadsheet: 772287d1647178190-calculating-cost-of-cargo-from-pricing-criteria-shipping-cost
Sheet: shipping cost

 |  |  |  |  |  |  |  | Q1 | Q2
Cargo Class | Delivery Method | Total Weight (Tonnes) | Tonnes | Total Cube | WM>20 | Height | H>2 | Cost | Cost
AUTO | DIRECT | 1.85 |  | 18.2 |  | 1.8 |  |  |  |  |  |  |  |  |  | Q1 | Q2
AUTO | DIRECT | 1.85 |  | 18.2 |  | 1.8 |  |  |  |  |  | Cargo Type | Delivery Method | WM>20 | H>2 | Price (USD) | Price (USD)
AUTO | TRANSHIP | 1.85 |  | 18.2 |  | 2.5 |  |  |  |  |  | AUTO | DIRECT | Y | Y | 100 | 115
CRATE | DIRECT | 20.28 |  | 18.3 |  | 1.8 |  |  |  |  |  | AUTO | DIRECT | N | Y | 100 | 115
CRATE | DIRECT | 20.28 |  | 18.3 |  | 1.8 |  |  |  |  |  | AUTO | DIRECT | Y | N | 100 | 115
CRATE | TRANSHIP | 20.28 |  | 18.3 |  | 1.8 |  |  |  |  |  | AUTO | DIRECT | N | N | 50 | 65
RORO | DIRECT | 50 |  | 18.3 |  | 1.8 |  |  |  |  |  | RORO | DIRECT | N | N | 150 | 165
RORO | TRANSHIP | 15 |  | 18.3 |  | 1.8 |  |  |  |  |  | CRATE | DIRECT | Y | N | 40 | 60
RORO | DIRECT | 50 |  | 18.3 |  | 1.8 |  |  |  |  |  | AUTO | TRANSHIP | Y | Y | 150 | 175
RORO | TRANSHIP | 15 |  | 18.3 |  | 1.8 |  |  |  |  |  | AUTO | TRANSHIP | N | Y | 150 | 175
AUTO | DIRECT | 2.36 |  | 30 |  | 3.4 |  |  |  |  |  | AUTO | TRANSHIP | Y | N | 150 | 175
AUTO | DIRECT | 2.3 |  | 30 |  | 3.4 |  |  |  |  |  | AUTO | TRANSHIP | N | N | 100 | 150
AUTO | DIRECT | 2.3 |  | 30 |  | 3.4 |  |  |  |  |  | RORO | TRANSHIP | N | N | 200 | 225
AUTO | DIRECT | 2.36 |  | 30 |  | 3.4 |  |  |  |  |  | CRATE | TRANSHIP | Y | N | 90 | 115
AUTO | TRANSHIP | 2.36 |  | 30 |  | 3.4
AUTO | TRANSHIP | 2.36 |  | 30 |  | 3.4
AUTO | TRANSHIP | 2.3 |  | 30 |  | 3.4
AUTO | TRANSHIP | 2.36 |  | 30 |  | 3.4
AUTO | DIRECT | 2.36 |  | 30 |  | 3.4
AUTO | DIRECT | 2.36 |  | 30 |  | 3.4
CRATE | TRANSHIP | 32 |  | 30 |  | 1.6
CRATE | TRANSHIP | 32 |  | 30 |  | 1.6
CRATE | DIRECT | 33 |  | 25 |  | 1.6
CRATE | DIRECT | 33 |  | 25 |  | 1.6
Spreadsheet: 292953d1390843553-comparing-most-recent-data-data-example
Sheet: Sheet1

 | 2 | yes
 | 3 | no
 | 2 | yes
 | 3 | no
 | 4 | yes
 | 5 | no
 | 2 | yes
 | 3 | no
 | 6 | yes
 | 5 | no
 | 4 | yes
 | 2 | no
 | 8 | yes
 | 6 | no
 | 2 | yes
 | 3 | no
 | 2 | yes
 | 5 | yes
 | 4 | no
 | 2 | yes
 | 3 | no
 | 6 | yes
 | 5 | no
 | 4 | yes
 | 2 | no
 | 3 | yes
 | 2 | no
 | 4 | yes
 | 2 | no
 | 3 | yes
 | 5 | no
 | 4 | yes
 | 2 | no
 | 3 | yes
 | 6 | yes
 | 2 | no
 | 3 | yes
 | 5 | no
 | 8 | yes
 | 7 | no
 | 2 | yes
 | 3 | no
 | 9 | yes
 | 3 | no
 | 4 | yes
 | 2 | no
 | 5 | yes
 | 4 | no
 | 2 | yes
 | 3 | no
 | 5 | yes
 | 7 | yes
 | 6 | no
 | 2 | yes
 | 3 | no
 | 4 | yes
 | 2 | no
 | 5 | yes
 | 4 | no
 | 5 | yes
 | 6 | no
 | 9 | yes
 | 5 | no
 | 4 | yes
 | 2 | no
 | 3 | yes
 | 2 | no
 | 3 | yes
 | 5 | yes
 | 4 | no
 | 2 | yes
 | 3 | no
 | 5 | yes
 | 4 | no
 | 2 | yes
 | 3 | no
 | 5 | yes
 | 4 | no
 | 2 | yes
 | 3 | no
Spreadsheet: 1c94e375-1c87-403e-9335-126c40b8f088
Sheet: Invoice Line Items

Invoice / Remittance Advice
BL_INVOICE_<customer id>_<settlement date>_<version>.CSV
<[NAME]
Date: <mm/dd/yyyy> and Version: <mm/dd/yyyy hh:[NAME]:ss> GMT
Line Items
Line | Description | [NAME] From | [NAME] | Document Ref | Quantity | Unit of Measure | Net Amount
Number | String | Timestamp | Timestamp | String | Number | String | $
Spreadsheet: 847190d1698236781-sum-of-specific-numbers-excelhelpupdated
Sheet: Sheet1

Starting point |  |  |  |  |  | Needed end result
name | level | number | date |  |  | level 1 to 2 | level 1 to 3 | level 2 to 2 (stays the same level)
A | 1 | 55 | 2000-01-31 00:00:00 |  |  |  |  |  |  | I need sum of all the numbers that meet each above criteria
B | 1 | 150 | 2000-01-31 00:00:00
C | 2 | 70 | 2000-01-31 00:00:00
D | 1 | 200 | 2000-01-31 00:00:00
E | 1 | 500 | 2000-01-31 00:00:00
A | 2 | 50 | 2000-02-28 00:00:00
B | 3 | 140 | 2000-02-28 00:00:00
C | 2 | 60 | 2000-02-28 00:00:00
D | 2 | 190 | 2000-02-28 00:00:00
E | 3 | 350 | 2000-02-28 00:00:00
Spreadsheet: 837419d1690168854-index-match-on-multiple-columns-book1
Sheet: Sheet1

MEN |  |  | WOMEN |  |  | CHILDREN
Name | Age |  | Name | Age |  | Name | Age
[NAME] | 45 |  | [NAME] | 33 |  | [NAME] | 8
[NAME] | 24 |  | Kathy | 67 |  | [NAME] | 3
Adam | 21 |  | Tiffany | 23 |  | Kayden | 10
[NAME] | 84 |  | Rose | 19 |  | Jasmine | 16
Wayne | 90 |  | Caroline | 55 |  | [NAME] | 18
Spreadsheet: 732738d1621191670-one-incorrect-formula-in-one-column-used-for-sorting-don-kitchen-new-2-
Sheet: Data

 | Names | Week One | Week Two | Week Three | Week Four | Week Five | Week Six | Week Seven | Week Eight |  | Total Scores for 8 weeks |  | Best 6 Scores from 8 weeks |  | Top 15 0verall Players Score |  |  |  | Players Score                  Highest top 6 scores from 8 weeks |  |  |  |  |  |  |  |  | Rank Helper
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Top 8 Players
 | D Frith | 15 | 14 | 13 | 7 | 15 | 12 | 14 | 14
 | P Carter | 15 | 12 | 15 | 17 | 0 | 9 | 8 | 16 |  |  |  |  |  |  |  |  |  | 87
 | T Seymore | 15 | 15 | 14 | 17 | 0 | 9 | 14 | 7 |  |  |  |  |  |  |  |  |  | 86
 | A Terry | 14 | 15 | 9 | 17 | 9 | 9 | 16 | 16 |  |  |  |  |  |  |  |  |  | 85
 | J Vince | 14 | 10 | 9 | 13 | 13 | 12 | 6 | 6 |  |  |  |  |  |  |  |  |  | 84
 | M Frith | 14 | 8 | 7 | 10 | 0 | 10 | 11 | 11 |  |  |  |  |  |  |  |  |  | 84
 | [NAME] | 12 | 8 | 0 | 0 | 13 | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  | 81
 | M Micklefield | 12 | 10 | 7 | 15 | 7 | 0 | 16 | 0 |  |  |  |  |  |  |  |  |  | 79
 | K Ellis | 12 | 15 | 7 | 0 | 0 | 0 | 0 | 17 |  |  |  |  |  |  |  |  |  | 78
 | K Lester | 12 | 11 | 15 | 15 | 17 | 13 | 16 | 6 |  |  |  |  |  |  |  |  |  | 77
 | C Medlin | 12 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  | 75
 | K De Veen | 12 | 12 | 15 | 7 | 3 | 13 | 6 | 11 |  |  |  |  |  |  |  |  |  | 72
 | J Thompson | 12 | 12 | 7 | 13 | 15 | 10 | 8 | 0
 | K  Thompson | 12 | 14 | 9 | 7 | 5 | 12 | 0 | 17
 | G Godhard | 12 | 7 | 14 | 12 | 0 | 0 | 0 | 0
 | L Lester | 12 | 11 | 8 | 10 | 19 | 13 | 14 | 17
 | L Harvey | 10 | 0 | 7 | 0 | 5 | 0 | 0 | 0
 | S Kinson | 10 | 15 | 15 | 5 | 0 | 13 | 14 | 11
 | C Micklefield | 10 | 15 | 15 | 15 | 9 | 13 | 6 | 11
 | D Bridges | 10 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | H De Veen | 10 | 15 | 13 | 5 | 19 | 12 | 8 | 12
 | L Bray | 10 | 7 | 8 | 7 | 7 | 9 | 0 | 12
 | W Seymore | 10 | 11 | 15 | 12 | 0 | 9 | 6 | 14
 | M Bray | 10 | 7 | 14 | 7 | 9 | 9 | 8 | 11
 | G Atkinson | 10 | 11 | 7 | 15 | 13 | 12 | 11 | 0
 | [NAME] | 10 | 8 | 8 | 11 | 17 | 0 | 11 | 0
 | D Ebdon | 8 | 15 | 15 | 15 | 3 | 10 | 11 | 11
 | J Sunderland | 8 | 11 | 15 | 0 | 3 | 10 | 6 | 10
 | A Levelle | 8 | 7 | 7 | 15 | 0 | 13 | 16 | 16
 | B Green | 7 | 11 | 13 | 11 | 0 | 12 | 11 | 7
 | C Laverty | 7 | 0 | 7 | 7 | 0 | 10 | 11 | 0
 | D Colquhoun | 7 | 8 | 7 | 0 | 19 | 0 | 0 | 0
 | M Holmes |  | 15 | 0 | 0 | 0 | 0 | 0 | 0
 | K Burnam | 0 | 7 | 0 | 0 | 0 | 0 | 0 | 0
 | [NAME] | 0 | 8 | 15 | 5 | 0 | 0 | 0 | 0
 | ? | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | ? | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | ? | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | ? | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | ? | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 293695d1391066156-dependant-drop-down-lists-po-template
Sheet: Pricing

Heatsafe7 | 200
Heatsafe219 | 240
Steelguard74RW | 310
[NAME] | 290
Steelguard813 | 450
Steelguard873BY | 410
Steelguard873OW | 430
Zincguard100 | 238
Zincguard120 | 219
Heatsafe431 | 672
Heatsafe643 | 584
Spreadsheet: 03f95848-b46b-4ff1-aa92-32dd4a26ed2d
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3
January 2011 |  |  | July 2011
January 6, 2011 |  |  | July 14, 2011
January 13, 2011 |  |  | July 28, 2011
January 20, 2011
January 27, 2011
February 2011 |  |  | August 2011
February 3, 2011 |  |  | August 11, 2011
February 10, 2011 |  |  | August 25,  2011
February 17, 2011
February 24 2011
March 2011 |  |  | September 2011
March 3, 2011 |  |  | September 8, 2011
March 10, 2011 |  |  | September 22, 2011
March 17, 2011
March 24, 2011
March 31, 2011
April 2011 |  |  | October 2011
April 7, 2011 |  |  | October 13, 2011
April 14, 2011 |  |  | October 27, 2011
April 21, 2011
April 28 2011
May 2011 |  |  | November 2011
May 12, 2011 |  |  | November 10, 2011
May 26, 2011
June 2011 |  |  | December 2011
June 9, 2011 |  |  | December 8, 2011
June 16, 2011 |  |  | Decmeber 22, 2011
Spreadsheet: 831063d1685380589-struggling-with-some-if-functions-or-alternative-solutions-payment-profile-withe-exmple-of-what-the-result-should-be
Sheet: Sheet1

 |  |  |  |  |  | 2023-07-31 00:00:00
 | Machine 1 |  | 5500000 | 2023-08-31 00:00:00
 | Machine 2 |  |  | 2023-10-31 00:00:00
 | Machine 3
 | Machine 4
 | Machine 5
 | Machine 6
 | Machine 7
 | Machine 8
 | Machine 9
 | Machine 10
 | Machine 11
 | Machine 12
 | Machine 13
 | Machine 14
 | Machine 15
 | Machine 16
 | Machine 17
 | Machine 18
 | Machine 19
 | Machine 20
 | Payment Profile
 | 0.4 | in month 0
 | 0.4 | in month 1 |  |  |  | proposed to use a whatif that says
 | 0.2 | in month 2 |  |  |  | 1. if the dates of the cells in row one and column e(5 to 10) are the same then use cost price in row D multiplied by 40%, 2.  then next part the previous 2 cells are equal to 40% of cost price in row d then multiply cost price by 40%, 3.  then next if function if the previous 2 cells are 0.8% of cost price then cost price multiply by 20% and 4.  finally if no assumptions hold true then zero
 | Machine 1 |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0
 | Machine 2 |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0
 | Machine 3 |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 | Machine 4
 | Machine 5
 | Machine 6
 | Machine 7
 | Machine 8
 | Machine 9
 | Machine 10
 | Machine 11
 | Machine 12
 | Machine 13
 | Machine 14
 | Machine 15
 | Machine 16
 | Machine 17
 | Machine 18
 | Machine 19
 | Machine 20
Spreadsheet: 158099d1337975624-is-there-a-way-to-filter-columns-horizontal-filtering
Sheet: Sheet1

 | student 1 | student 2 | student 3 | student 4 | student 5
test 1 | 10 | 57 | 4 | 25
test 2 | 4 | 6 | 536 | 42 | 45
test 3 | 6 | 57 | 25 | 52 | 2
test 4 | 6 | 57 | 58 | 58 | 74
test 5 | 2 | 3 | 78 | 95 | 4
test 6 | 12 | 32 | 54 | 98 | 85
test 7 | 85 | 85 | 2 | 48 | 4
test 8 | 5 | 21 |  | 79 | 36
test 9 | 5 | 25 | 6 | 56 | 32
test 10 | 6 | 2 |  | 44 | 47
Spreadsheet: daren_farmer__6586__egmnom-Feb
Sheet: DELV SUMMARY

 |  | ECT DELIVERED
 |  | FEBRUARY 2000
 | #1338 | #5045 | #1195
 |  |  | TIER 1
 | UNIT | LYONDELL | HUNTSMAN
DAYS | Aristech | CHANNELVIEW | EAST PLANT | TOTAL
1 | 0 | 0 | 4000
 | 0 | 0 | 4000
 | 0 | 0 | 4000
 | 0 | 0 | 4000
 | 0 | 0 | 4000
 | 0 | 0 | 4000
 | 0 | 0 | 4000
 | 0 | 0 | 4000
 | 0 | 0 | 4000
 | 0 | 0 | 4000
 | 0 | 0 | 4000
 | 0 | 0 | 4000
 | 0 | 0 | 4000
 | 0 | 0 | 4000
 | 0 | 0 | 4000
 | 0 | 0 | 4000
 | 0 | 0 | 4000
 | 0 | 0 | 4000
 | 0 | 0 | 4000
 | 0 | 0 | 4000
 | 0 | 0 | 4000
 | 0 | 0 | 4000
 | 0 | 0 | 4000
 | 0 | 0 | 4000
 | 0 | 0 | 4000
 | 0 | 0 | 4000
 | 0 | 0 | 4000
 | 0 | 0 | 4000
 | 0 | 0 | 4000
 | 0 | 0 | 0
TOTAL
Spreadsheet: 71768d1272489371-excel-2007-extracting-data-dummy-sheet
Sheet: Sheet3

Header | Data Series 1
 | Header | Data Series 2
Header1 |  | Header2 | Header3 |  | Header4 | Header5 | Header6 |  | Header7 | Header8 | Header9
Data Series 3 (1) |  | Data Series 4 (1) | Data Series 5 (1) |  | Data Series 6 (1) | Data Series 7 (1) | Data Series 8 (1) |  | Data Series 9 (1) | Data Series 10 (1) | Data Series 11 (1)
Data Series 3 (2) |  | Data Series 4 (2) | Data Series 5 (2) |  | Data Series 6 (2) | Data Series 7 (2) | Data Series 8 (2) |  | Data Series 9 (2) | Data Series 10 (2) | Data Series 11 (2)
Data Series 3 (3) |  | Data Series 4 (3) | Data Series 5 (3) |  | Data Series 6 (3) | Data Series 7 (3) | Data Series 8 (3) |  | Data Series 9 (3) | Data Series 10 (3) | Data Series 11 (3)
Data Series 3 (4) |  | Data Series 4 (4) | Data Series 5 (4) |  | Data Series 6 (4) | Data Series 7 (4) | Data Series 8 (4) |  | Data Series 9 (4) | Data Series 10 (4) | Data Series 11 (4)