tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 35063d1232548003-countind-dates-on-a-different-xls-file-book2
Sheet: date data

2008-10-17 00:00:00
2008-10-18 00:00:00
2008-10-18 00:00:00
2008-10-20 00:00:00
2008-10-20 00:00:00
2008-10-28 00:00:00
2008-10-28 00:00:00
2008-10-29 00:00:00
2008-11-04 00:00:00
2008-11-13 00:00:00
2008-11-18 00:00:00
2008-11-18 00:00:00
2008-11-18 00:00:00
2008-11-24 00:00:00
2008-11-25 00:00:00
2008-11-25 00:00:00
2008-11-25 00:00:00
2008-11-25 00:00:00
2008-11-25 00:00:00
2008-11-26 00:00:00
2008-11-28 00:00:00
2008-11-28 00:00:00
2008-12-02 00:00:00
2008-12-02 00:00:00
2008-12-03 00:00:00
2008-12-04 00:00:00
2008-12-04 00:00:00
2008-12-05 00:00:00
2008-12-08 00:00:00
2008-12-08 00:00:00
2008-12-18 00:00:00
2008-12-19 00:00:00
2008-12-22 00:00:00
2008-12-22 00:00:00
2008-12-23 00:00:00
2008-12-23 00:00:00
2008-12-24 00:00:00
2008-12-26 00:00:00
2008-12-26 00:00:00
2008-12-26 00:00:00
2008-12-29 00:00:00
2008-12-30 00:00:00
2008-12-30 00:00:00
2008-12-30 00:00:00
2009-01-02 00:00:00
2009-01-02 00:00:00
2009-01-05 00:00:00
2009-01-05 00:00:00
2009-01-06 00:00:00
2009-01-08 00:00:00
2009-01-12 00:00:00
2009-01-12 00:00:00
2009-01-12 00:00:00
2009-01-12 00:00:00
2009-01-13 00:00:00
2009-01-13 00:00:00
2009-01-13 00:00:00
2009-01-13 00:00:00
2009-01-14 00:00:00
2009-01-15 00:00:00
Spreadsheet: 67127d1267729635-displaying-differences-between-two-columns-book2
Sheet: Sheet1

Col A | Col B | Count | [NAME]
xxx | [NAME] | 1 | 4 |  | 0 | 1
bbb | bbb | 1 |  |  | 1 | 1
BBB | [NAME] | 2 |  |  | 0 | 2
Bvb | bbb | 3 |  |  | 0 | 3
FDFD | fdfd | 4 |  |  | 0 | 4
AAA | AAA | 4 |  |  | 1 | 4
Spreadsheet: 373521d1422469321-search-for-word-then-add-value-in-a-cell-nearby-chemical-adding
Sheet: Sheet1

Chemical Name (Trade name) | Volume (gal) | Specific Gravity | Hazardous Ingredients | %Weight | Total Amount (lb) |  | Density of Water | 8.344 | lb/gal
Lorsban | 1000 | 1.075 | Chlorpyrifos | 46.3
 |  |  | Heavy Aromatic Naphtha | 47.9
 |  |  | 1,2,4-Trimethylbenzene | 2.3
 |  |  | 1,3,5-Trimethylbenzene | 0.5
 |  |  | Naphthalene | 4.9
Spreadsheet: 58823d1259083472-excel-2007-how-to-add-items-to-a-dropdown-list-dynamically-by-typing-in-the-dropdown-list-cell-tanf_-_requirement_gathering_template_-final-
Sheet: CBIC

 |  | DATA Gathering Template
Program | Temporary Assistance - Family Assistance and Safety Net
Function Name | Client Services/Benefits Delivery
Activity Name | CBIC
Activity Description / Purpose | The process of issuing and/or replacing CBIC cards
 |  |  | Activity Predecessor | Activity [NAME] | Activity Input | Activity Output | Activity Successors
Steps | Tasks A task is any action that is being performed to complete a step | What unit does this? (SU) | Who does this? (W) | Applications used / System Interfaces / Tools Is there an automated system supporting the activity? | What happens before this? (P) | What causes the activity to happen (T) | Additional Information that is needed (I) | Is anything produced? (O) | What happens next ? (S) | V | Comments |  |  |  | Questions | Workarounds | Constraints/ Issues | Opportunities | Policy Considerations | Best Practices | Follow-Up | Comments
Research case information
Enter information in the CBIC on-line system
Activate new/replacement card
Mail new card/pin
Accounting | Case Closure
Add Program/Person | Case Management (Undercare)
AFIS | Caseload Management
Agency Conference | Client Services/Benefits Delivery
Application Registration | Eligibility Determination
Authorization | Fair-Hearings & Appeals
[NAME] | Intake
Budget | Referrals
Case Assignment | Screening
Case Closure | Verification
Case Review
[NAME]
CBIC
Change
Clearance
Data Entry
DV-D-A Screen
Emergency Benefits
Expedited
Hearings
Interview
Investigation
Managed Care
Mass Changes
Monitor Activities
Notice
[NAME]
Plan Review
Pre-Screening
Reactivation
Reception
Records Management
Recoupment-Supplemental
Re-Determination-Renewal-Recert
Referral
Sanctions
Service Plan
Verify
Vouchers
Withdraw Application
Other
Spreadsheet: 11875503-1fcf-44a6-93fb-b27c14bad96a
Sheet: Sheet1

Spend over £25,000 - Publication template | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
 |  | Payment
Department family | Entity | Date | Expense type | Expense area | Supplier | Transaction number | Amount
DCMS | NMSI | 2011-04-14 00:00:00 | Rates (CILOR) | Science Museum Estates | Swindon Borough Council | 137785 | 61053
DCMS | NMSI | 2011-04-14 00:00:00 | Maintenance | Science Museum Estates | Cofely Limited | 137865 | 27754.07
DCMS | NMSI | 2011-04-14 00:00:00 | Software Packages | National MPG | Code Computer Love Limited | 138792 | 29500
DCMS | NMSI | 2011-04-14 00:00:00 | Maintenance | Science Museum Estates | MB Construction Services Ltd | 138940 | 26992.8
DCMS | NMSI | 2011-04-14 00:00:00 | Computer Maintenance | ICT | Selection Services Plc | 139247 | 25623.75
Spreadsheet: 85194997-d10d-47da-be3c-5a488a265166
Sheet: Sheet1

PRESIDENT OF THE UNITED STATES | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8
Republican
1992-02-18 00:00:00
Carroll County | Bosa, r | Buchanan, r | [NAME], r | Lennane, r | [NAME], r | Paulsen, r | Stassen, r | [NAME], Jr., d
Albany | - | 27 | 51 | - | - | - | - | -
[NAME] | 3 | 256 | 286 | - | - | - | - | 2
[NAME] | 1 | 55 | 77 | - | - | 1 | - | 3
Chatham | - | 21 | 33 | - | - | 1 | - | -
Conway | 6 | 550 | 703 | 16 | - | 4 | 2 | 9
Eaton | - | 31 | 37 | 1 | - | 1 | - | -
[NAME] | - | 68 | 91 | 2 | - | - | - | -
Freedom | - | 101 | 162 | 1 | - | 4 | - | 1
Hale's Location | - | - | - | - | - | - | - | -
Hart's Location | - | 4 | 8 | - | - | - | - | -
[NAME] | - | 75 | 133 | 2 | - | - | 1 | 1
[NAME] | - | 156 | 221 | 7 | 1 | 3 | - | 2
Moultonborough | 2 | 358 | 621 | 8 | 2 | 7 | 2 | 5
Ossipee | - | 288 | 333 | - | 1 | 3 | 3 | 1
Sandwich | - | 119 | 191 | 3 | 3 | - | 3 | 9
Tamworth | 4 | 188 | 232 | 7 | 1 | 2 | 1 | 7
Tuftonboro | - | 215 | 380 | 4 | - | 3 | 2 | 5
Wakefield | 3 | 269 | 354 | 12 | 1 | 2 | - | -
Wolfeboro | 7 | 497 | 826 | 16 | 1 | 1 | 1 | 3
Totals | 26 | 3278 | 4739 | 79 | 10 | 32 | 15 | 48
 | [NAME], d | Harkin, d | Kerrey, d | Tsongas, d | Woods, d | [NAME], [NAME] | Cuomo | [NAME]
Albany | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 1
[NAME] | 0 | 2 | 3 | 8 | 0 | 0 | 4 | 4
[NAME] | 2 | 1 | 3 | 7 | 0 | 0 | 1 | 4
Chatham | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1
Conway | 10 | 0 | 17 | 18 | 1 | 0 | 0 | 11
Eaton | 1 | 0 | 0 | 4 | 0 | 0 | 2 | 3
[NAME] | 0 | 0 | 2 | 1 | 2 | 1 | 0 | 1
Freedom | 1 | 0 | 0 | 4 | 0 | 0 | 1 | 5
Hale's Location | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Hart's Location | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
[NAME] | 0 | 0 | 0 | 2 | 0 | 0 | 0 | 0
[NAME] | 2 | 0 | 0 | 7 | 3 | 0 | 3 | 1
Moultonborough | 5 | 2 | 1 | 25 | 2 | 2 | 2 | 7
Ossipee | 7 | 1 | 1 | 5 | 2 | 0 | 2 | 2
Sandwich | 5 | 1 | 0 | 18 | 2 | 0 | 5 | 8
Tamworth | 10 | 2 | 3 | 19 | 2 | 0 | 11 | 0
Tuftonboro | 5 | 2 | 0 | 8 | 2 | 0 | 2 | 5
Wakefield | 10 | 0 | 4 | 15 | 6 | 0 | 5 | 10
Wolfeboro | 5 | 2 | 0 | 44 | 0 | 0 | 7 | 18
Totals | 63 | 13 | 35 | 185 | 22 | 4 | 45 | 81
Bertasavage: 1-Wakefield. [NAME]: 1-Albany; 2-Conway; 1-Sandwich; 2-Wolfeboro. [NAME]: 1-Bartlett; 2-Conway; 1-Freedom
1-Moultonborough; 1-Tuftonboro. Daugherty: 1-Bartlett. Doerschuck: 1-Chatham; 1-Freedom; 2-Sandwich; 3-Wolfeboro. [NAME]:
1-Conway. Koczak: 1-Conway. [NAME]: 1-Ossipee; 6-Sandwich. Ryden: 1-Albany; 1-Tamworth. [NAME]: 1-Wolfeoboro.
Zimmermann: 1-Conway. [NAME]: 1-Tuftonboro. [NAME]: 1-Tamworth. [NAME]: 3-Tamworth.
Spreadsheet: 91240d1290999126-calculating-true-false-from-group-of-variables-pclc
Sheet: Sheet1

ID | pclc_1 | pclc_2 | pclc_3 | pclc_4 | pclc_5 | pclc_6 | pclc_7 | pclc_8 | pclc_9 | pclc_10 | pclc_11 | pclc_12 | pclc_13 | pclc_14 | pclc_15 | [NAME] | pclc_17 |  | 1 / 1 to 5 | 3 / 6 to 12 | 2 / 13 to 17
 | 3 | 2 | 2 | 2 | 2 | 1 | 2 | 1 | 1 | 2 | 1 | 1 | 1 | 1 | 2 | 1 | 2
 | 1 | 2 | 1 | 1 | 1 | 1 | 2 | 3 | 3 | 3 | 1 | 1 | 1 | 1 | 2 | 3 | 3
Spreadsheet: 860569d1708614224-filtered-formulas-investements-sample
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  | Gain
 |  |  |  |  |  |  |  |  |  |  | 3675
 |  |  |  |  |  |  |  |  |  | other bank | Total
 | Open | TFSA | RRSP |  | Subtotal | GIC | Secure | Growth | Subtotal | RRSP |  | Investements | Notes
2022-01-01 00:00:00 | 475 | 475 | 475 |  |  | 475 | 475 | 475 |  | 475
2022-01-07 00:00:00 | 450 | 450 | 450 |  |  | 450 | 450 | 450 |  | 450
2022-01-10 00:00:00 | 490 | 490 | 490 |  |  | 490 | 490 | 490 |  | 490
2023-04-23 00:00:00 | 500 | 500 | 500 |  |  | 500 | 500 | 500 |  | 500
2023-05-01 00:00:00 | 510 | 510 | 510 |  |  | 510 | 510 | 510 |  | 510
2023-05-01 00:00:00 | 520 | 520 | 520 |  |  | 520 | 520 | 520 |  | 520 |  | 150
2023-07-01 00:00:00 | 525 | 525 | 525 |  |  | 525 | 525 | 525 |  | 525 |  | 75
2024-08-14 00:00:00 | 485 | 485 | 485 |  |  | 485 | 485 | 485 |  | 485
2024-08-14 00:00:00 | 600 | 600 | 600 |  |  | 600 | 600 | 600 |  | 600 |  | 100
2024-08-30 00:00:00 | 550 | 550 | 550 |  |  | 550 | 550 | 550 |  | 550
Spreadsheet: 133849d1324695287-consolodating-multiple-ids-and-summing-their-values-multiple_id
Sheet: Sheet1

ID | Hours |  |  | Row Labels | Sum of Hours
3784 | 6 |  |  | 2213 | 8
3784 | 2 |  |  | 3784 | 8
2213 | 8 |  |  | 4320 | 7
6954 | 4 |  |  | 4322 | 8
6954 | 4 |  |  | 6954 | 10
6954 | 2 |  |  | Grand Total | 41
4320 | 7
4322 | 8
Spreadsheet: 72d74da5-ce1f-4336-ba40-416a3c9350cc
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
FPMET | Test | FPMET | Prometheus Thiopurine Metabolites | Prometheus Thiopurine Metabolites | High Performance Liquid Chromatography (HPLC) | EDTA (lavender-top) tube: EDTA |  |  | 5 | mL | Draw 5 mL EDTA whole blood. Submit EDTA whole blood promptly at refrigerated temperature. | Pediatric Minimum Volume:  3 mL | Specimens other than	Whole blood Anticoagulants other than	EDTA Hemolysis	NA Thawing	NA Lipemia	NA Icteric	NA | Units of Measure:  pmol/8 x 10(8) RBC   Metabolite                                                   Reference Range 6-TGN                                                                 230-400 6-MMPN                                                              <5700   Proprietary and patented technology by Prometheus Laboratories,  Inc.  The therapeutic range and toxic thresholds were established  in  an IBD patient population receiving azathioprine or  6-mercaptopurine.  [NAME] testing should not replace  laboratory monitoring for toxicity.  Graph available upon request.   Test Performed By:   Prometheus Laboratories, Inc.                                         Therapeutics and Diagnostics                                         9410 Carroll Park Drive                                         San Diego, CA  92121-4203 |  | 3 days | 5-7 days | 2 | 82491 |  |  |  |  | Prometheus Laboratories, Inc. Therapeutics and Diagnostics
FPMET | [NAME] | WBEDTA | [NAME] EDTA |  |  |  | Refrigerated | 8 days
FPMET | Result | Z1501 | 6-TGN Metabolite Result | 6-TGN Metabolite Result | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
FPMET | Result | Z1502 | 6-TGN Metabolite Result Assessment | 6-TGN Metabolite Result Assessment | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
FPMET | Result | Z1503 | 6-MMPN Metabolite Result | 6-MMPN Metabolite Result | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
FPMET | Result | [NAME] | 6-MMPN Metabolite Result Assessment | 6-MMPN Metabolite Result Assessment | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 791789d1660587371-calculating-hours-worked-on-work-days-per-month-workdaysexampleupdate
Sheet: Sheet1

 |  |  |  |  | 2019-01-01 00:00:00
Date Started | Date Finished | Hours Worked | Days Worked | Sum | January | February | March | April | May | June | July | August | September | October | November | December
2019-01-02 00:00:00 | 2019-01-04 00:00:00 | 10
2019-02-04 00:00:00 | 2019-02-19 00:00:00 | 89
2019-05-01 00:00:00 | 2019-05-31 00:00:00 | 120
Weekdays
 |  |  |  |  | 2019-01-01 00:00:00
Date Started | Date Finished | Hours Worked | Days Worked | Sum | January | February | March | April | May | June | July | August | September | October | November | December
2019-01-02 00:00:00 | 2019-01-04 00:00:00 | 10
2019-02-04 00:00:00 | 2019-02-19 00:00:00 | 89
2019-05-01 00:00:00 | 2019-05-31 00:00:00 | 120
 |  |  | amount wrong
Spreadsheet: 105364d1302728949-vlookup-formula-help-test-book-1
Sheet: Sheet1

Produce type |  | kgs | lbs | oz
Apples | 1/10 | 10 | 22 | 4004
 | 2/10 | 21 | 44 | 8004
 | 3/10 | 15 | 34 | 6004
Bananas | 1/10 | 10 | 22 | 4004
 | 2/10 | 21 | 44 | 8004
 | 3/10 | 15 | 34 | 6004
Spreadsheet: 726171d1617093910-match-values-from-trow-to-the-one-above-and-copy-exclusing-duplicates-skip-duplicates
Sheet: Sheet1

 |  |  |  |  |  |  |  | 5 | 7 | 8 | 9 | 2
 |  |  |  |  |  |  |  | 3 | 4 | 7 | 1 | 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Need help with a formula that will copy values from  I11:m12
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | and paste into I15 to q15 skipping duplicates
Spreadsheet: 153226d1335808828-making-a-schedule-with-auto-time-format-and-adding-total-hours-se-schedule
Sheet: jan 23

 | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday
 | 2012-01-23 00:00:00 | 2012-01-24 00:00:00 | 2012-01-25 00:00:00 | 2012-01-26 00:00:00 | 2012-01-27 00:00:00 | 2012-01-28 00:00:00
[NAME] | off | 8:30-5:30 | 8:00-5:00 | 9:00-5:00 | 8:30-5:30 | 9:15-5:15
 |  | 12:00-1:00 | 12:00-1:00 | 12:00-1:00 | 12:00-1:00 | 11:30-12:30 | 38
[NAME] | 8:30-5:30 | 9:30-5:30 | off | 9:30-5:30 | 8:30-5:30 | 9:15-5:15
 | 2:00-3:00 | 2:00-3:00 |  | 2:00-3:00 | 2:00-3:00 | n/l | 38
Ray | 8:00-5:00 | 8:00-5:00 | 8:00-4:00 | 7:00-4:00 | off | 9:00-5:00
 | 12:00-1:00 | 12:00-1:00 | 12:00-1:00 | 12:00-1:00 |  | 12:30-1:30 | 38
Mark | 8:30-5:30 | 8:00-4:00 | 8:30-5:30 | 8:30-5:30 | 8:00-4:00
 | 1:00-2:00 | 1:00-2:00 | 1:00-2:00 | 1:00-2:00 | 1:00-2:00 |  | 38
[NAME] | 9:30-5:30 | 8:00-5:00 | 8:30-5:30 | 7:00-4:00-HOMER | 9:30-5:30-counter
ctr 12-2 | 11:00-12:00 | 11:00-12:00 | 11:00-12:00 | 12:00-1:00 | 11:00-12:00 |  | 38
Kat |  |  | 8:00-5:00 |  |  | 9:15-5:15
 |  |  | 12:00-1:00 |  |  | 11:30-12:30
 |  |  | 12:00-1:00 |  |  | 12:00-1:00
 |  |  |  |  |  | total hours
Spreadsheet: john_lavorato__16484__Brazil Power Daily 01172001
Sheet: Page3

 |  |  | Southeast Submarket |  | Generation | Load | EAR | [NAME] (MW) |  |  |  |  |  |  |  | Northeast Submarket |  | Generation | Load | EAR | [NAME] (MW)
 |  |  | (% National System) |  | 0.667 | 0.63 | 0.681 | 160269 |  |  |  |  |  |  |  | (% National System) |  | 0.131 | 0.145 | 0.213 | 50192
 |  |  | South Submarket |  | Generation | Load | EAR | [NAME] (MW) |  |  |  |  |  |  |  | North Submarket |  | Generation | Load | EAR | [NAME] (MW)
 |  |  | (% National System) |  | 0.129 | 0.162 | 0.061 | 14319 |  |  |  |  |  |  |  | (% National System) |  | 0.073 | 0.063 | 0.045 | 10692
 | Legend
 |  | TMO ([NAME]) |  |  |  |  | ENA (Energia Natural Afluente as of % Média Longo Termo) |  |  |  |  |  |  | EAR ([NAME]) |  |  |  | Heavy load price |  | Medium load price |  | Light load price
DO NOT PRINT THIS CHECK LIST
 | Generation | Load | EAR | [NAME] (MW)
Check
Spreadsheet: 150096d1334278214-copying-data-to-another-worksheet-database
Sheet: Instructor Database

FIRST NAME | INITIAL | LAST NAME | DEPARTMENT | DATE
[NAME] |  | JONES |  | 2012-04-04 00:00:00
[NAME] |  | SMITH |  | 2012-03-18 00:00:00
[NAME] |  | SMITH |  | 2012-03-20 00:00:00
[NAME] |  | JONES |  | 2012-03-22 00:00:00
WILLIAM |  | [NAME] |  | 2012-03-23 00:00:00
WILLIAN |  | [NAME] |  | 2012-03-25 00:00:00
[NAME] |  | SMITH |  | 2012-03-26 00:00:00
JASON |  | WHITEHALL |  | 2012-03-27 00:00:00
Spreadsheet: phillip_m_love__30074__Fantasy Roster
Sheet: Sheet1

Tribe Called Plove
PLAYER | TM | POS | M | T | W | TH | F | Sa | Su | TOTAL
[NAME] | CAVS | C
Marcus Camby | NYK | C |  | 1 |  | 1 |  | 1
Raef LaFrentz | DEN | C | 1 |  | 1 |  | 1 |  | 1
[NAME] | MAVS | F |  | 1 |  | 1 |  | 1
[NAME] | POR | F |  | 1 | 1 |  | 1
[NAME] | CHA | F | 1 |  | 1 |  | 1 | 1
[NAME] | PHI | F |  |  | 1 |  | 1 | 1
[NAME] | SAC | F |  | 1 | 1 |  | 1 |  | 1
[NAME] | CHA | G | 1 |  | 1 |  | 1 | 1
[NAME] | MIL | G |  | 1 |  | 1 |  | 1 | 1
[NAME] | ORL | G |  | 1 | 1 |  | 1 |  | 1
[NAME] | LAL | G |  | 1 |  | 1 | 1 |  | 1
[NAME] | VAN | G |  | 1 | 1 |  | 1 | 1
Spreadsheet: a0135836-36ff-414e-8695-532490be9dff
Sheet: Sheet1

Category | Age | Sex | Sample Collection | Date Collected | Patient Code | Treatment | Days from last treatment
Acute | 43 | F | Venous blood | 2010-10-21 00:00:00 | BR10101 | doxycycline/rifampin 6wks | 972
Acute | 40 | M | Venous blood | 2010-10-28 00:00:00 | BR10258 | doxycycline/rifampin 6wks | 795
Acute | 19 | F | Leukapheresis | 2010-10-23 00:00:00 | BR10268 | doxycycline/rifampin 6wks | 1068
Acute | 38 | F | Venous blood | 2010-11-22 00:00:00 | BR10288 | tetradox/rifampin 6wks | 743
Acute | 40 | M | Venous blood | 2010-12-04 00:00:00 | BR20093 | unknown | 1023
Acute | 52 | M | Leukapheresis | 2010-10-30 00:00:00 | BR20113 | doxycycline/rifampin 6wks | 915
Acute | 50 | F | Venous blood | 2010-12-09 00:00:00 | BR20132 | doxycycline/rifampin 6wks | 879
Acute | 45 | F | Venous blood | 2010-11-29 00:00:00 | BR20227 | doxycycline/rifampin 6wks | 822
Acute | 23 | M | Leukapheresis | 2010-11-10 00:00:00 | BR20316 | doxycycline/rifampin 8wks | 646
Acute | 46 | F | Venous blood | 2010-09-23 00:00:00 | BR30033 | doxycycline 6wks, gentamicin 1wk | 1058
Acute | 41 | M | Venous blood | 2010-12-04 00:00:00 | BR30069 | doxycycline 6wks, gentamicin 1wk | 1057
Acute | 70 | M | Venous blood | 2010-11-22 00:00:00 | BR30078 | doxycycline 6wks, gentamicin 1wk | 1038
Acute | 48 | F | Venous blood | 2010-10-23 00:00:00 | BR30136 | doxycycline 6wks, rifampin/gentamicin 1wk | 991
Acute | 63 | F | Leukapheresis | 2010-11-20 00:00:00 | BR30563 | doxycycline/rifampin 48wks, gentamicin 1wk | 809
Acute | 50 | F | Leukapheresis | 2010-10-22 00:00:00 | BR30614 | doxycycline 6wks, gentamicin 1wk | 478
Acute | 49 | F | Venous blood | 2010-12-06 00:00:00 | BR90010 | doxycycline/rifampin 12wks | 991
Relapse | 53 | F | Leukapheresis | 2010-12-06 00:00:00 | BR10170 | doxycycline/rifampin 6wks | 728
Relapse | 18 | M | Leukapheresis | 2010-11-08 00:00:00 | BR30001 | doxycycline 6wks, gentamicin 1wk | 895
Relapse | 60 | F | Leukapheresis | 2010-10-28 00:00:00 | BR30003 | doxycycline/rifampin 6wks | 1007
Relapse | 32 | F | Venous blood | 2010-10-13 00:00:00 | BR30026 | trimethoprim 6wks, gentamicin 1wk | 965
Relapse | 35 | F | Venous blood | 2010-09-07 00:00:00 | BR30028 | doxycycline 6wks, gentamicin 1wk | 651
Relapse | 36 | F | Leukapheresis | 2010-10-06 00:00:00 | BR30647 | doxycycline 6wks, gentamicin 1wk | 541
Control | 29 | F | Venous blood | 2010-10-12 00:00:00 | BR70001 | - | -
Control | 30 | F | Venous blood | 2010-10-12 00:00:00 | BR70002 | - | -
Control | 37 | M | Venous blood | 2010-10-19 00:00:00 | BR70003 | - | -
Control | 20 | M | Venous blood | 2010-10-19 00:00:00 | BR70004 | - | -
Control | 35 | F | Venous blood | 2010-10-20 00:00:00 | BR70005 | - | -
Control | 46 | F | Venous blood | 2010-11-24 00:00:00 | BR70006 | - | -
Control | 36 | F | Venous blood | 2010-12-03 00:00:00 | BR70007 | - | -
Control | 29 | F | Venous blood | 2010-11-29 00:00:00 | BR70009 | - | -
Control | 27 | M | Venous blood | 2010-11-29 00:00:00 | BR70010 | - | -
Control | 23 | M | Venous blood | 2010-11-26 00:00:00 | BR70013 | - | -
Control | 27 | M | Venous blood | 2010-12-09 00:00:00 | BR70016 | - | -
Spreadsheet: 759329d1639495829-return-multiple-sheet-names-in-different-fields-multiple_sheets_array
Sheet: Sheet3

hostname | Type | Object ID | Make | Model
BEAM04 | Beamer | b001 | Dell | Fast
BEAM02 | Beamer | b002 | Hp | Cheap
BEAM06 | Beamer | b003 | Dell | Cheap
Deskt01 | Desktop | d001 | Hp | Fast
Deskt04 | Desktop | d002 | Dell | Fast
Deskt05 | Desktop | d003 | Hp | Fast
DoST04 | [NAME] | do001 | Dell | Fast
DoST05 | [NAME] | do002 | Hp | Fast
DoST06 | [NAME] | do003 | Dell | Fast
Spreadsheet: 56632d1256773822-uneditable-cells-and-dynamic-names-of-columns-fabric-production-quantities-october
Sheet: Quantities

Orders |  | [NAME] |  |  |  | SOFIA |  |  |  | AQUA AGENCY |  |  |  | AQUA LONDON |  |  |  | AQUA LEEDS |  |  |  | TOTALS
GARMENT | COLOUR | 8 | 10 | 12 | 14 | 8 | 10 | 12 | 14 | 8 | 10 | 12 | 14 | 8 | 10 | 12 | 14 | 8 | 10 | 12 | 14 | 8 | 10 | 12 | 14 | Grand Total
 | TOTALS
Spreadsheet: 227722d1365795131-multi-column-indexing-solved-trackertest02-modified-by-tigeravatar-
Sheet: Tracker

Store | [NAME] | <------Once I change these
[NAME] | 4 | <------
Current Month Purchases | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan
This Year (TY)
Last Year (LY) |  |  |  |  |  |  |  |  |  |  |  |  | <-------I want these to auto populate
TY Sales Class Avg (SC)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | This is for my list selection in Cells B1,B2 pay this no mind.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | Store1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8
Spreadsheet: 772955d1647532775-if-is-blank-vendor-credit-material-list-test
Sheet: Sheet1

Job # | Vendor | Invoice # | Inv  Date | Material | Inv  Amt Order'd | Inv  Amt Ship'd | Act  Amt Rev'd | Diff. | Quote Price | Actual Unit  Price | UM | Ttl  Chg'd | Ttl Chg S/B | Over  Chg'd
123456 | Safeway | 123456789 | 2022-03-07 00:00:00 | ground beef | 4 | 4 | 0 |  | 19.95 | 19.95 | EA
234567 | BBB | 234567890 | 2022-03-07 00:00:00 | bath towels | 10 | 7 | 4 |  | 39.95 | 39.95 | EA
345678 | [NAME] | 345678901 | 2022-03-04 00:00:00 | Big Mac | 10 | 10 | 10 |  | 4.95 | 5.95 | EA