tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: sally_beck__35451__EBS-Developed-Software
Sheet: Summary Revised

 | EBS IT Production [NAME]
 | Summary Headcount 2002 - Estimated
 |  |  | MAINTENANCE
 | S Y S T E M | Primary Function | ONLY
 | Trading / Front Office
 | EnFiber - Core System | Trading / Risk Management / Scheduling | 3
 | EnFiber - FACT | Deal Confirmation
 | EnFiber - Real Estate | Trading
 | Settlements & Tactical Systems
 | Saber | Trading Settlements | 0
 | Tactical Settlements (including Minutes) | Tactical Settlements | 1
 | Minutes Trading
 | Voice Minutes |  | 3
 | Network Operations
 | PPCS / TRP | Pooling Point Control System | 3
 | ECOMS | Circuit Provisioning | 1
 | NETS | Asset Tracking | 3
 | Remedy | Change Management & Network Problem Tracking | 1
 | Livelink | Document Management | 1
 | Global Data
 | Global Counterparty + Common Codes | Common Data | 1
 | EBS Facility | Common Data | 0
 | EBS Contract | Common Data | 0
 | Data Architecture
 | Database Management |  | 2
Spreadsheet: 886376d1736417140-sum-based-on-variable-end-text-test4
Sheet: Sheet1

 | P1 | P2 | P3 | P4 | P5 | P6 | P7 | P8 | P9 | P10 | P11 | P12 |  | Financial Year | Quarter | Period | Start Date | End Date
Value | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 |  |  | FY25 | Q1 | P1 | 2024-02-26 00:00:00 | 2024-03-31 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | FY25 | Q1 | P2 | 2024-04-01 00:00:00 | 2024-04-28 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | FY25 | Q1 | P3 | 2024-04-29 00:00:00 | 2024-05-26 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | FY25 | Q2 | P4 | 2024-05-27 00:00:00 | 2024-06-30 00:00:00
 | Required Total |  |  |  |  |  |  |  |  |  |  |  |  | FY25 | Q2 | P5 | 2024-07-01 00:00:00 | 2024-07-28 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | FY25 | Q2 | P6 | 2024-07-29 00:00:00 | 2024-08-25 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | FY25 | Q3 | P7 | 2024-08-26 00:00:00 | 2024-09-29 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | FY25 | Q3 | P8 | 2024-09-30 00:00:00 | 2024-10-27 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | FY25 | Q3 | P9 | 2024-10-28 00:00:00 | 2024-11-24 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | FY25 | Q4 | P10 | 2024-11-25 00:00:00 | 2024-12-29 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | FY25 | Q4 | P11 | 2024-12-30 00:00:00 | 2025-01-26 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | FY25 | Q4 | P12 | 2025-01-27 00:00:00 | 2025-02-23 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | FY26 | Q1 | P1 | 2025-02-24 00:00:00 | 2025-03-30 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | FY26 | Q1 | P2 | 2025-03-31 00:00:00 | 2025-04-27 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | FY26 | Q1 | P3 | 2025-04-28 00:00:00 | 2025-05-25 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | FY26 | Q2 | P4 | 2025-05-26 00:00:00 | 2025-06-29 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | FY26 | Q2 | P5 | 2025-06-30 00:00:00 | 2025-07-27 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | FY26 | Q2 | P6 | 2025-07-28 00:00:00 | 2025-08-24 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | FY26 | Q3 | P7 | 2025-08-25 00:00:00 | 2025-09-28 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | FY26 | Q3 | P8 | 2025-09-29 00:00:00 | 2025-10-26 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | FY26 | Q3 | P9 | 2025-10-27 00:00:00 | 2025-11-23 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | FY26 | Q4 | P10 | 2025-11-24 00:00:00 | 2025-12-28 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | FY26 | Q4 | P11 | 2025-12-29 00:00:00 | 2026-01-25 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | FY26 | Q4 | P12 | 2026-01-26 00:00:00 | 2026-02-22 00:00:00
Spreadsheet: 14871b98-4780-4610-a535-1d7b68614b44
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
ALAV | Test | ALAV | Aldosterone, Left Adrenal Vein, Serum | Aldosterone, LAV | Liquid Chromatography-Tandem Mass Spectrometry (LC-MS/MS) | Plain, Red-Top Tube: Red |  |  | 1.8 | mL | Collection Container/Tube:  Preferred: Red top  Acceptable: Serum gel  Submission Container/Tube: Plastic vial [NAME]: 1.8 mL Additional Information: See Renin Aldosterone Studies in Special Instructions for more details. | 1 mL | Hemolysis	Mild OK; Gross OK Thawing	Warm OK; Cold OK Lipemia	Mild OK; [NAME] OK Icterus	Mild OK; [NAME] OK Other	NA | No established reference values | Monday through Friday; 10 a.m. | 2 days | 5 days | 1 | 82088 |  |  |  |  | Rochester
ALAV | [NAME] | SERUM | Serum |  |  |  | Frozen | 14 days
ALAV | Result | 6349 | Aldosterone, LAV | Aldosterone, LAV | Numeric |  |  |  |  | ng/dL |  |  |  |  |  |  |  |  |  | 1762-4
Spreadsheet: 862553d1710251313-progress-bar-based-upon-hours-calculate-partial-and-full-day-hours-hwc-contractor-attendance-record
Sheet: 2023 Federal Holidays

 | 2023 Federal Holidays
 | Federal Holidays | Description
 | 2023-01-02 00:00:00 | New Year's Day
 | 2023-01-16 00:00:00 | [NAME]
 | 2023-02-20 00:00:00 | Washington's Birthday
 | 2023-05-29 00:00:00 | Memorial Day
 | 2023-06-19 00:00:00 | Juneteenth National Independence Day
 | 2023-07-04 00:00:00 | Independence Day
 | 2023-09-04 00:00:00 | Labor Day
 | 2023-10-09 00:00:00 | Columbus Day
 | 2023-11-10 00:00:00 | Veterans Day
 | 2023-11-23 00:00:00 | Thanksgiving Day
 | 2023-12-25 00:00:00 | Christmas Day
Spreadsheet: 905de235-1da7-4be8-872c-7a55c25cda99
Sheet: Sheet1

Adresseliste fra www.proff.no | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
[NAME]:Oppføringer fra [NAME]
FIRMANAVN | ADRESSE | POSTNR. | POSTSTED | TELEFON | TELEFAKS
[NAME] Avdeling av Utenlandsk Foretak | Ryensvingen 3B | 0680 | Oslo | 22 67 17 80 | 22 67 17 89
Net Supporting [NAME] | Sigrid Undsetsvei 5 Leilighet 602 | 0669 | Oslo | 22 76 09 79
[NAME] | C/O Teki Gruppen AS Tvetenveien 6 | 0661 | Oslo | 23 24 59 20
[NAME] | [NAME] 6 | 0658 | Oslo | 21 39 00 41 | 22 17 26 71
Olaisen Data | Ullern Alle 103 | 0381 | Oslo |  | 983 70 510
Himaki AS | [NAME] 21 | 0789 | Oslo
Dipper AS | [NAME] 21 | 0153 | Oslo | 06020 | 21 08 07 02
Future Electronics AS | [NAME] 23 | 1081 | Oslo | 22 90 58 00 | 22 90 57 90
Nortronicom AS | [NAME] Vei 8 | 1061 | Oslo | 23 24 29 70 | 23 24 29 79
Tele Communications Samia N Bashir | [NAME] | 0574 | Oslo | 22 15 71 88 | 22 15 71 88
Mariestads Bygg & Fastighetsservice AB | C/O Garanti Dataregnskap AS Stanseveien 6B | 0975 | Oslo | 23 33 80 70 | 23 33 80 71
Totalcom AS | Alf Bjerckes Vei 22A | 0582 | Oslo | 800 65 065 | 800 65 066
Norwegian Fundraising AS | [NAME] 80 Byggning Nr 5 | 0582 | Oslo
Dataspesialisten AS | Bentsebrug 11 | 0476 | Oslo | 22 22 76 50 | 22 22 76 49
[NAME] | Sandakerveien 140 | 0484 | Oslo | 22 88 82 00 | 23 88 80 12
Telleverket Aronsen | Plogv 42B | 0681 | Oslo | 22 26 77 77 | 22 26 43 60
Arte Com ANS | Svingen 5 | 0196 | Oslo
[NAME] Senter [NAME] Moallin Abdulle | Rostedsg 12 | 0178 | Oslo | 22 20 13 40 | 67 56 76 62
[NAME] og Service [NAME] | Høgdav 2B | 0680 | Oslo | 22 28 68 07
[NAME] AS | Enebakkveien 287 | 1187 | Oslo | 23 30 21 00 | 23 30 21 01
Premiere Global Services Norway AS | Sandakerveien 118 | 0484 | Oslo | 21 02 03 04 | 21 50 23 17
Quadriga Norge AS | Østensjøv 39 /41 | 0667 | Oslo | 23 25 95 00 | 23 25 95 01
Inter Com Mohammed Sadiq Alwakil | Sverigesg 11B | 0658 | Oslo | 22 67 53 81
Lbw Nordic AB | C/O Bdo Binder AS Rådhusg 17 | 0158 | Oslo | 22 20 44 00 | 22 41 99 87
Transport Kommunikasjon AS | [NAME] | 1055 | Oslo | 22 30 13 28 | 22 32 10 02
Trenger du oppdaterte adresselister til DM /TM? [NAME] (www.forvalt.no) tilbyr ett segmenterings- og uttekksverktøy hvor du [NAME] frem til din målgruppe og eksportere lister til Excel. Du kan gjøre oppslag så ofte du vil, med en begrensning på 3500 selskap per søk. Våre telefonnummere er hentet fra Telefonkatalogen og [NAME].  Med segmenteringsverktøy kan du: - Hente ut adresseliste før en DM utsendelse - Lage ringelister - Hente ut bransjestatistikker - Oppdatere din kundedatabase  Se http://forvalt.no/segmenteringsverktoy/
Spreadsheet: 788588d1658563688-bifurcate-the-amount-as-per-date-day-difference-duty-exemption-1-
Sheet: Sheet1

 | Duty Amount | Debit | Credit | Duty Date
 | 2028.59 |  |  | 2019-04-18 00:00:00
 | 7514.71 |  |  | 2019-05-18 00:00:00
 | 8983.9 |  |  | 2019-06-20 00:00:00
 | 13777.19 |  |  | 2019-07-20 00:00:00
 | 10017.56 |  |  | 2019-08-14 00:00:00
 | 12514.5 |  |  | 2019-09-13 00:00:00
 | 16125.19 |  |  | 2019-10-18 00:00:00
 | 12128.63 |  |  | 2019-11-15 00:00:00
 | 11580.19 |  |  | 2019-12-13 00:00:00
 | 15710.72 |  |  | 2020-01-20 00:00:00
 | 9687.69 |  |  | 2020-02-13 00:00:00
 | 13626.72 |  |  | 2020-03-17 00:00:00
 | 17517.93 |  |  | 2020-05-22 00:00:00
 | 12616.13 |  |  | 2020-07-11 00:00:00
 | 10595 |  |  | 2020-08-13 00:00:00
 | 12114.33 |  |  | 2020-09-19 00:00:00
 | 8298.93 |  |  | 2020-10-15 00:00:00
 | 100 |  |  | 2020-11-03 00:00:00
 | 150 |  |  | 2020-11-06 00:00:00
 | 200 |  |  | 2020-12-04 00:00:00
Extra Duty Collection Date From | 2019-04-01 00:00:00 | To | 2019-08-08 00:00:00
Duty Relief Date From | 2019-12-01 00:00:00 | To | 2020-10-01 00:00:00
Spreadsheet: 690930d1597377416-lookup-trying-to-deglitch-repeats-in-data-smalladviced
Sheet: Sheet1

 | 2020-01-01 00:00:00 | 2020-04-07 00:00:00 | 2020-04-13 00:00:00 | 2020-05-01 00:00:00 | 2020-05-08 00:00:00 | Age at reading: | 7 | 8 | 9 | 10 | 11 | 12 | 13 | Weeks
Week in year read: |  | 13.85714285714286 | 14.71428571428571 | 17.28571428571428 | 18.28571428571428 |  | . | . | . | . | . | . | . | .
 | DOB
Mouse A | 2020-02-07 00:00:00 |  |  | 40 | 50
[NAME] | 2020-02-07 00:00:00 |  | 30 | 40 | 50
C | 2020-02-07 00:00:00 | 20 | 30 | 640 | 50
D | 2020-02-07 00:00:00 | 20 | 30 | 1 | 50
E | 2020-02-07 00:00:00 | 20 | 30 | 0 | 50
F | 2020-02-07 00:00:00 | 20 | 30 |  | 50
G | 2020-02-07 00:00:00 | 20 |  | 40 | 50
H | 2020-02-07 00:00:00 | 20 | 30
I | 2020-02-10 00:00:00 | 20 | 30 | 40 | 50
 |  |  |  |  |  |  |  |  |  |  |  | 40 | 50
 |  |  |  |  |  |  |  |  | 30 | (empty) | (empty) | 40 | 50
 |  |  |  |  |  |  |  |  | 20, 30 | (empty) | (empty) | 640 | 50
 |  |  |  |  |  |  |  |  | 20, 30 | (empty) | (empty) | 1 | 50
 |  |  |  |  |  |  |  |  | 20, 30 | (empty) | (empty) | 0 | 50
 |  |  |  |  |  |  |  |  | 20, 30 | (empty) | (empty) |  | 50
 |  |  |  |  |  |  |  |  | 20 |  |  | 40 | 50
 |  |  |  |  |  |  |  |  | 20, 30 | (empty) | (empty)
 |  |  |  |  |  |  |  | 20 | 30 | (empty) | (empty) | 40 | 50
Spreadsheet: 784858d1655979971-format-of-a-cell-dependant-on-other-cells-being-populated-cf-all-3-done-with-dv-aligw
Sheet: Sheet1

Name | Theory Test | Practical Test | Oral Test | Issue Certificate
[NAME] | 2020-02-03 00:00:00 |  | 2019-03-02 00:00:00
[NAME] |  | 2020-03-03 00:00:00
[NAME] | 2019-03-01 00:00:00 | 2019-07-05 00:00:00
[NAME] | 2020-03-19 00:00:00 | 2019-02-20 00:00:00 | 2020-07-20 00:00:00 | 2022-03-22 00:00:00
[NAME] | 2019-11-11 00:00:00 |  | 2019-08-03 00:00:00
 |  |  |  |  |  |  |  |  | This cell to turn red to indicate all 3 tests have been completed and certificate needs to be issued.
 |  |  |  |  |  |  |  |  | Once certificate issue date has been entered, the red highlight should disappear.
 |  |  |  |  |  |  |  |  | You shouldn't be able to enter date in this cell until all 3 tests have been completed.
Spreadsheet: 28342d1222428463-make-link-between-two-sheets-book1
Sheet: Sheet1

 | file one |  |  |  |  |  | file two
Veh # | DATE | Driver |  |  |  | Veh # | Authorized trip date | Driver
11654 | 2008-08-01 00:00:00 | [NAME] |  |  |  | 11656 | 2008-08-01 00:00:00 | [NAME] smith
11655 | 2008-08-17 00:00:00 | [NAME] |  |  |  | 11333 | 2008-08-01 00:00:00 | [NAME]
11656 | 2008-08-05 00:00:00 | [NAME] smith |  |  |  | 11356 | 2008-08-01 00:00:00 | [NAME]
11287 | 2008-08-23 00:00:00 | [NAME] |  |  |  | 11293 | 2008-08-01 00:00:00 | [NAME]
11487 | 2008-08-02 00:00:00 | Singh Kumar |  |  |  | 11345 | 2008-08-01 00:00:00 | [NAME]
11211 | 2008-08-01 00:00:00 | [NAME] |  |  |  | 11655 | 2008-08-01 00:00:00 | [NAME]
11314 | 2008-08-29 00:00:00 | [NAME] |  |  |  | 11287 | 2008-08-01 00:00:00 | [NAME]
 |  |  |  |  |  | 11266 | 2008-08-01 00:00:00 | [NAME]
 |  |  |  |  |  | 11211 | 2008-08-01 00:00:00 | [NAME]
 |  |  |  |  |  | 11654 | 2008-08-01 00:00:00 | [NAME]
 |  |  |  |  |  | 11314 | 2008-08-01 00:00:00 | [NAME]
 |  |  |  |  |  | 11487 | 2008-08-01 00:00:00 | Singh Kumar
 |  |  |  |  |  | 11287 | 2008-08-01 00:00:00 | [NAME]
 |  |  |  |  |  | 11333 | 2008-08-01 00:00:00 | Sandra
Spreadsheet: 8e98426b-aa93-4fde-890e-021e90879c4e
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] | Silicon, Serum/Plasma | Silicon | Inductively Coupled Plasma/ Optical Emission Spectrometry (ICP/OES) | Plain, Red-Top Tube: Red |  |  | 2 | mL | Submit only 1 of the following specimens:   [NAME]: Draw blood in a trace metal free, royal blue top, no additive tube(s). (Serum gel tube is not acceptable.) Promptly centrifuge and separate 2 mL into an acid washed plastic screw capped vial (MML supply number T619). Ship refrigerate.   [NAME] blood in a royal blue top, trace metal free; EDTA tube(s). ([NAME] tube is not acceptable.) Promptly centrifuge and separate 2 mL into an acid washed plastic screw capped vial (MML supply number T619). Ship refrigerate. | 0.7 mL | Hemolysis	NA Thawing	Warm OK; Cold OK Lipemia	NA Icterus	NA Other	NA | Reporting limit determined each analysis.   Generally: Less than 0.05 mg/dL Silicon concentrations are influenced by diet, especially vegetable intake.   Test Performed By: NMS Labs                              3701 Welsh Road                              PO Box 433A                              [NAME], PA 19090-0437 | Monday | 1 day | 3 - 9 days | 1 | 84285 |  |  |  |  | NMS Labs
[NAME] | [NAME] | VARIES | Varies |  |  |  | Refrigerated | 14 days
[NAME] | Result | Z1431 | Silicon | Silicon | Alphanumeric |  |  |  |  | mg/dL |  |  |  |  |  |  |  |  |  | 10829-0
[NAME] | Result | [NAME] | Reporting Limit | Reporting Limit | Alphanumeric |  |  |  |  | mg/dL |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 87640d1287518889-alternative-to-a-nested-vlookup-formula-dyn_v_lookup_ron
Sheet: Sheet1

 | Oct | Nov
[NAME] | 4 | 3
[NAME] | 5 | 4
[NAME] | 3 | 6
[NAME] | 6 | 7
Month | Names | Result
Nov | [NAME]
Spreadsheet: 726576d1617300521-need-help-with-countif-formula-sample_time_ledger
Sheet: April

 | Time Ledger |  |  |  |  |  | 2021
 | Totals | Days Worked This Month | Total Month Entries | Total After-Hours Entries | Filtered Timeframe Total | Daily Average This Month | Total Time Logged This Month
 |  | 2021-04-01 00:00:00 |  |  |  |  | 0.75
 |  | 2021-04-01 00:00:00 |  |  |  |  | 0.75
 |  | 2021-04-01 00:00:00 |  |  |  |  | 4
 |  | 2021-04-01 00:00:00
 |  | 2021-04-01 00:00:00 |  |  |  |  | 1
 |  | 2021-04-01 00:00:00
 |  | 2021-04-01 00:00:00
 |  | 2021-04-01 00:00:00
 |  | 2021-04-01 00:00:00
 | TOTALS
Spreadsheet: 1e2afcb8-18d3-4abb-9a68-6ff143127ce0
Sheet: Sheet1

Spring 2012 Data
 | ENG1 | ENG 2 | ENG 3 | ENG 4 | ENG 5 | ENG 6 | ENG 7 | ENG 8 | ENG TEACH 1 | ENG TEACH 2 | ENG TBW
Goal 1 | 4 | 4 | 3 | 4 | 2 | 4 | 4 | 4 | 4 | 4 | 4
Goal 1 | 4 | 3 | 4 | 4 | 3 | 4 | 3 | 3 | 3 | 4 | 5
Goal 1 | 4 | 4 | 4 | 3 | 2 | 2 | 3 | 3 | 3 | 4 | 4
AVG
Goal 2 | 4 | 4 | 3 | 3 | 2 | 4 | 4 | 4 | 4 | 4 | 4
Goal 2 | 4 | 3 | 3 | 3 | 2 | 3 | 3 | 3 | 2 | 3 | 5
Goal 2 | 4 | 4 | 3 | 2 | 2 | 3 | 2 | 3 | 3 | 4 | 3
AVG
Goal 3 | 4 | 4 | 3 | 4 | 3 | 4 | 4 | 4 | 4 | 3 | 4
Goal 3 | 4 | 3 | 4 | 3 | 4 | 4 | 2 | 3 | 2 | 4 | 5
Goal 3 | 3 | 4 | 4 | 3 | 2 | 4 | 3 | 3 | 3 | 3 | 4
AVG
Spreadsheet: darrell_schoolcraft__7346__imball0201
Sheet: Devon

 | Devon SFS Operating
 | POI 36289 - Bilbrey 28 Fed 1 C/P
Day | Measured | Scheduled
1 | 108 | 441
2 | 136 | 441
3 | 78 | 441
4 | 84 | 441
5 | 81 | 441
6 | 78 | 441
7 | 49 | 441
8 | 35 | 441
9 | 35 | 441
10 | 1124 | 441
11 | 1826 | 88
12 | 309 | 88
13 | 726 | 88
14 | 1551 | 88
15 | 1261 | 88
16 | 386 | 88
17 | 34 | 88
18
19
20
21
22
23
24
25
26
27
28
29
30
31
2001-12-31 00:00:00 |  |  | 161292.49
2002-01-17 00:00:00
CBS Volume
 |  |  | 33971
Spreadsheet: 788599d1658568715-formula-not-loading-correct-data-sample-quarter-expenses
Sheet: Sample Quarter Expenses

 | Date | Item | Category | A$  (GST Included) |  | Expected Value
 | 2022-07-06 00:00:00 | Tolls [Aggregated] | Tolls |  |  | 7.6
 | 2022-07-07 00:00:00 | Tolls [Aggregated] | Tolls |  |  | 3
 | 2022-07-13 00:00:00 | Tolls [Aggregated] | Tolls |  | Error | 0
 | 2022-07-14 00:00:00 | Tolls [Aggregated] | Tolls |  |  | 8.72
 | 2022-07-20 00:00:00 | Tolls [Aggregated] | Tolls |  | Error | 0
 | 2022-07-21 00:00:00 | Tolls [Aggregated] | Tolls |  | Error | 0
 |  |  |  | IF(VLOOKUP($B12,'Sample Quarter Tolls.xlsx'!$B$5:$l$22,8)<=0,0,VLOOKUP($B12,'Sample Quarter Tolls.xlsx'!$B$5:$l$22,8))
 |  |  |  | Why is incorrect value being drawn in from the source workbook on the dates highlighted?
Spreadsheet: 649061d1573457921-run-time-error-in-macro-time-series-upper-aquifer-qw-spreadsheet
Sheet: Well 10

Well | Date | pH | EC | Ca | [NAME] | Na | Alk as CaCO3 | HCO3  as  CaCO3 | CO3  as  CaCO3 | SO4 | Cl | TDS | SAR | SARadj | B | NO3-N | Cu | Fe | Mn | Zn | L.I. |  | Sum cat | [NAME] | % dif
 | Sampled | unit | dS/m | meq/L | meq/L | meq/L | meq/L | meq/L | meq/L | meq/L | meq/L | mg/L |  |  | mg/L | mg/L | mg/L | mg/L | mg/L | mg/L | Calc
10 | 2007-02-20 00:00:00 | 7.5 | 0.93 | 5 | 2.1 | 3.6 | 6 |  |  |  | 3 |  | 2.702111850146886 | 2.5 | 0.1 | 8 |  |  |  |  | 0.6
MTTR Well 10A #10  1200gpm | 2012-03-29 00:00:00 | 7.9 | 0.79 | 3.62 | 1.31 | 3.2 | 5.3 |  |  | 0.5 | 2.1 |  | 2 | 4.6 | 0.03 | 1.1 |  | <0.01 | <0.01 |  | 0.8
Well #10 | 2013-10-11 00:00:00 | 7.6 | 0.93 | 4.27 | 1.48 | 2.9 | 6.2 |  |  | 0.6 | 3 |  | 1.7 | 4.2 | 0.04 | 1.1 |  | <0.10 | <0.02 |  | 0.6
Well - 10 | 2014-01-27 00:00:00 | 8.1 | 0.94 | 5.11 | 1.89 | 3.5 | 5.9 |  |  | 0.6 | 3.3 |  | 1.9 | 4.6 | 0.02 | 1.6 |  | <0.10 | <0.02 |  | 1.2
Well 10 | 2015-04-02 00:00:00 | 7.7 | 0.86 | 4.23 | 1.52 | 2.8 | 5.4 |  |  | 0.5 | 2.6 |  | 1.6 | 3.9 | <0.05 | 1.2 |  | <0.10 | <0.02 |  | 0.7
Well 10 | 2016-04-01 00:00:00 | 7.84 | 0.905 | 4.850000000000001 | 1.75 | 2.92 | 5.465190632243626 | 5.465190632243626 | 0 | 0.976 | 3.2942 | 582.4 | 1.61 | 3.62 | 0.014 | 1.7088 | 0.008 | 0 | 0.001 | 0.023
Well 10 | 2017-05-03 00:00:00 | 8.25 | 1.246 | 2.65 | 1.05 | 2.18 | 7.97897849892095 | 7.97897849892095 | 0 | 0.346 | 2.2964 | 797 | 1.6 | 3.51 | 0.023 | 38.724 | 0.006 | 0.218 | 0 | 0.182
W10 | 2018-05-29 00:00:00 | 7.76 | 0.536 | 3.14 | 1.12 | 2.82 |  | 4.198305491167773 | 0 | 0.567 | 0.749 | 343.04 |  |  | 0.046 | 0 | 0.016 | 0.057 | 0.013 | 0.005
Spreadsheet: 59757d1260318114-league-spreadsheet-vs2_league_spreadsheet_test
Sheet: Preview

Week | 2 |  | preview |  |  |  |  | data entry | enter week number in B1
[NAME] | 3 |  |  |  |  |  |  |  | set up pairing blocks for each pairing and enter the pairing number in the pink cell
number of pairings |  | 5 |  |  |  |  |  |  | all else is calculated.
team # | team name | rank in team | team members | Avg score | [NAME] | Handicap | VS | team # | team name | rank in team | team members | Avg score | [NAME] | Handicap
Pairing # | 1
9 | amber | 1 | monkey | 278 | 25 | 0 |  | 10 | mauve | 1 | sheep | 289 | 45 | 8.8
 |  | 2 | sloth | 247 | 25 | 0 |  |  |  | 2 | goat | 254 | 36 | 5.600000000000001
 |  | 3 | dog | 245 | 22 | 6.4 |  |  |  | 3 | cow | 237 | 33 | 0
Pairing # | 2
8 | chartreuse | 1 | snake | 300 | 52 | 17.6 |  | 9 | amber | 1 | monkey | 278 | 25 | 0
 |  | 2 | lizzard | 284 | 36 | 29.6 |  |  |  | 2 | sloth | 247 | 25 | 0
 |  | 3 | gecko | 255 | 30 | 8 |  |  |  | 3 | dog | 245 | 22 | 0
Pairing # | 3
7 | pink | 1 | fawn | 289 | 44 | 0 |  | 8 | chartreuse | 1 | snake | 300 | 52 | 8.8
 |  | 2 | rabbit | 271 | 39 | 0 |  |  |  | 2 | lizzard | 284 | 36 | 10.4
 |  | 3 | deer | 260 | 35 | 4 |  |  |  | 3 | gecko | 255 | 30 | 0
Pairing # | 4
6 | orange | 1 | oliver | 300 | 55 | 8.8 |  | 7 | pink | 1 | fawn | 289 | 44 | 0
 |  | 2 | [NAME] | 234 | 15 | 0 |  |  |  | 2 | rabbit | 271 | 39 | 29.6
 |  | 3 | #N/A | #N/A | #N/A | #N/A |  |  |  | 3 | deer | 260 | 35 | #N/A
Pairing # | 5
5 | purple | 1 | [NAME] | 282 | 34.5 | 0 |  | 6 | orange | 1 | oliver | 300 | 55 | 14.4
 |  | 2 | pete | 269.5 | 32.5 | 28.4 |  |  |  | 2 | [NAME] | 234 | 15 | 0
 |  | 3 | [NAME] | 253.5 | 31.5 | #N/A |  |  |  | 3 | #N/A | #N/A | #N/A | #N/A
Standings
Blue | 3 |  | This sheet gives an overview of who plays vs who and what the handicaps are.
red | 0 |  | The Standings overview show the points collected per team up to the week selected above
yellow | 2
green | 1
purple | 4 |  | player's rank within the team is recaclulated every week
orange | 2 |  | players are sorted by rank here to match up teamA #1 vs teamB #1
pink | 0 |  | ranking changes can be studied on the Teams sheet as the weeks progess
chartreuse | 3 |  | compare the blue team pecking order between week 2 and week 3 preview
amber | 2 |  | note that teams end up in different spots each week, because of the pairings ….
mauve | 0
copy the other team
names into this list
and copy the formula in
B30 down
Spreadsheet: 766323d1643838549-golf-skins-spreadsheet-minimum-value-skins
Sheet: Sheet3

Hole | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | Out | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | In | Total
Par | 4 | 4 | 4 | 4 | 3 | 5 | 3 | 4 | 5 |  | 4 | 5 | 4 | 3 | 4 | 5 | 4 | 4 | 3
John1 | 4 | 4
[NAME] | 5 | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] score for [NAME] | Par
John3 | 3 | 3
John4 | 4 | 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Skins buy-in | 20
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Skins pot
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Skins value
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Skins
Skin?
Spreadsheet: 812435d1673148259-dynamic-reference-to-worksheet-with-index-and-aggregate-functions-dynamic-worksheet-reference-question
Sheet: REPORT BY POTTER

 |  |  | Enter Month below | Enter Potter's Name Below
 |  |  | ? | [NAME] |  |  | IFERROR(INDEX(JANUARY!B$1:B$186,AGGREGATE(15,6,ROW($D$1:$D$194)/(JANUARY!$B$1:$B$186='REPORT BY [NAME]))),"")
 |  |  |  |  |  | Sales this month
 |  |  | Potter | [NAME] | Date Sold |  |  | This formula entered in the green cells works perfectly to draw info from the "January" tab based on input in the blue cell.  How do I modify it so that the output changes according to the month entered in the yellow cell D2?    THANK YOU!!