tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 0b83b479-7c38-47fc-944d-0d64d2283fe5
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
PMS2K | Test | PMS2K | PMS2 Gene, Known Mutation | PMS2 Gene, Known Mutation | Polymerase chain reaction (PCR) followed by DNA sequencing or gene dosage analysis by [NAME] probe amplification (MLPA) of the PMS2 gene is utilized to test for the presence of mutations previously identified in an affected family member. (PCR is utilized pursuant to a license agreement with Roche Molecular Systems, Inc.) | Varies: Var |  |  |  | Varies | [NAME] must arrive within 96 hours of collection.  [NAME] blood Container/Tube: Preferred: Lavender top (EDTA) or yellow top (ACD) Acceptable: Any anticoagulant  [NAME]: 3 mL  Collection Instructions:	 1. Invert several times to mix blood. 2. Send specimen in original tube. Forms: 1. [NAME] (Supply T519) 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. | 1 mL | No specimen should be rejected. If specimen not received at appropriate temperature or in wrong anticoagulant, include note to laboratory. If questions, contact laboratory. | An interpretive report will be provided. | Friday; 10 am | 10 days | 16 days | 1 | 81318 |  |  |  |  | Rochester
PMS2K | [NAME] | VARIES | Varies |  |  |  | Ambient
PMS2K | Result | 33625 | Reason for Referral | Reason for Referral | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 42349-1 | Reason for referral:Find:Pt:^Patient:Nar:
PMS2K | Result | 33626 | Result | Result | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
PMS2K | Result | 33627 | Interpretation | Interpretation | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 69047-9 | Geneticist review:Imp:Pt:XXX:Nar:
PMS2K | Result | 33628 | Method | Method | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 49549-9 | Reference lab test method:Type:XXX:Reference lab test:Nar:
PMS2K | Result | 33629 | Amendment | Amendment | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
PMS2K | Result | 33630 | [NAME] | [NAME] | Alphanumeric
PMS2K | Result | 33631 | Source | Source | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 31208-2 | [NAME] source:Prid:Pt:[NAME]:Nom:
PMS2K | Result | 33632 | Reviewed By | Reviewed By | Alphanumeric
PMS2K | Result | 33633 | Release Date | Release Date | Alphanumeric
Spreadsheet: 860914d1708940778-xlookup-approximate-multiple-criteria-lookup-id-question
Sheet: Sheet1

Name | Date of Birth | Lookup ID |  | Name | DOB | ID
Doa, [NAME], MR | 1994-02-01 00:00:00 |  |  | Doa, [NAME] | 1994-02-01 00:00:00 | 12345
Jackson, Amelia, MRS | 1990-03-19 00:00:00 |  |  | Jackson, Amelia | 1990-03-19 00:00:00 | 98213
[NAME], [NAME], SIR | 1980-01-01 00:00:00 |  |  | [NAME] | 1980-01-01 00:00:00 | 80123
Spreadsheet: 865810d1712792222-averages-from-a-table-based-on-a-day-of-the-week-and-beginning-ending-time-average-days-times-sample-02
Sheet: Sheet2

Column1 | Amount | Column2 | Redemptio Date/Time | Column3 | Location
 | 0.05 |  | 2024-01-01 00:01:14 |  | Cashier 1
 | 0.02 |  | 2024-01-01 00:01:46 |  | Cashier 2
 | 0.08 |  | 2024-01-02 12:32:43 |  | Cashier 3
 | 0.99 |  | 2024-01-02 12:38:37 |  | Cashier 4
 | 0.14 |  | 2024-01-03 12:13:27 |  | Cashier 5
 | 0.2 |  | 2024-01-03 12:13:59 |  | Cashier 6
 | 0.19 |  | 2024-01-04 03:02:39 |  | Warehouse
 | 0.3 |  | 2024-01-04 03:02:41 |  | Cashier 8
 | 0.12 |  | 2024-01-05 04:04:58 |  | Cashier 9
 | 0.69 |  | 2024-01-05 04:09:37 |  | Warehouse
 | 0.02 |  | 2024-01-06 02:37:05 |  | Cashier 1
 | 0.06 |  | 2024-01-06 02:40:20 |  | Cashier 2
 | 0.02 |  | 2024-01-07 04:42:47 |  | Warehouse
 | 0.02 |  | 2024-01-07 04:42:53 |  | Cashier 4
 | 0.18 |  | 2024-01-08 04:43:46 |  | Cashier 5
 | 0.36 |  | 2024-01-08 04:43:52 |  | Warehouse
 | 0.07 |  | 2024-01-09 15:04:26 |  | Cashier 7
 | 0.51 |  | 2024-01-09 15:05:26 |  | Cashier 8
 | 0.05 |  | 2024-01-10 14:18:02 |  | Warehouse
 | 0.06 |  | 2024-01-10 14:18:19 |  | Cashier 10
 | 0.06 |  | 2024-01-11 09:35:44 |  | Warehouse
 | 0.04 |  | 2024-01-11 09:35:48 |  | Cashier 2
 | 0.35 |  | 2024-01-12 10:38:53 |  | Cashier 3
 | 0.08 |  | 2024-01-12 10:38:57 |  | Cashier 4
 | 0.5 |  | 2024-01-13 03:14:12 |  | Cashier 5
 | 0.47 |  | 2024-01-13 03:14:34 |  | Warehouse
 | 0.22 |  | 2024-01-14 05:22:19 |  | Warehouse
 | 0.26 |  | 2024-01-14 05:22:22 |  | Cashier 8
 | 0.25 |  | 2024-01-15 09:06:39 |  | Cashier 9
 | 0.04 |  | 2024-01-15 09:06:43 |  | Warehouse
 | 0.05 |  | 2024-01-16 13:23:04 |  | Cashier 1
 | 0.6 |  | 2024-01-16 13:23:05 |  | Cashier 2
 | 0.09 |  | 2024-01-17 13:31:46 |  | Warehouse
 | 0.02 |  | 2024-01-17 13:32:20 |  | Cashier 4
 | 0.87 |  | 2024-01-18 08:41:03 |  | Cashier 5
 | 0.08 |  | 2024-01-18 08:41:06 |  | Warehouse
 | 0.08 |  | 2024-01-19 08:38:27 |  | Cashier 7
 | 0.06 |  | 2024-01-19 08:46:15 |  | Cashier 8
 | 0.01 |  | 2024-01-20 10:45:38 |  | Cashier 9
 | 0.06 |  | 2024-01-20 10:45:41 |  | Cashier 10
 | 0.48 |  | 2024-01-21 04:58:31 |  | Cashier 1
 | 0.06 |  | 2024-01-21 04:58:37 |  | Warehouse
 | 0.13 |  | 2024-01-22 07:44:07 |  | Cashier 3
 | 0.12 |  | 2024-01-22 07:44:12 |  | Cashier 4
 | 0.05 |  | 2024-01-23 16:27:37 |  | Cashier 5
 | 0.02 |  | 2024-01-23 16:28:29 |  | Cashier 6
 | 0.98 |  | 2024-01-24 13:25:17 |  | Warehouse
 | 0.03 |  | 2024-01-24 13:25:45 |  | Cashier 8
 | 0.5 |  | 2024-01-25 08:36:16 |  | Cashier 9
 | 0.24 |  | 2024-01-25 08:37:17 |  | Cashier 10
 | 0.67 |  | 2024-01-26 12:43:45 |  | Warehouse
 | 0.3 |  | 2024-01-26 12:44:05 |  | Cashier 2
 | 0.44 |  | 2024-01-27 07:19:31 |  | Cashier 3
 | 0.59 |  | 2024-01-27 07:22:03 |  | Warehouse
 | 0.589 |  | 2024-01-28 04:20:11 |  | Cashier 5
 | 0.636 |  | 2024-01-28 04:20:14 |  | Cashier 6
 | 0.683 |  | 2024-01-29 14:32:50 |  | Warehouse
 | 0.73 |  | 2024-01-29 14:32:52 |  | Cashier 8
 | 0.777 |  | 2024-01-30 14:49:53 |  | Cashier 9
 | 0.824 |  | 2024-01-30 14:49:55 |  | Warehouse
 | 0.871 |  | 2024-01-31 10:21:00 |  | Cashier 1
 | 0.918 |  | 2024-01-31 10:21:02 |  | Cashier 2
Spreadsheet: 877073d1723741086-return-different-text-result-if-between-certain-numbers-but-nothing-if-no-text-book2
Sheet: Log

Level 1 | Level 2 | Score | Result
1 | 1
2 | 3
3 | 4
4 | 4
 |  |  |  | <-- does not work when all score results are entered into the formula
 |  |  |  | <-- works when only one score result is entered into the formula
Spreadsheet: 764388d1642705687-update-field-2-from-field-1-automatically-book4
Sheet: Sheet2

 |  |  |  | AS OF
YEAR END | YEAR END | TRANSFER | NEW BALANCE | 2022-01-19 00:00:00 | DIFFERENCE | % DIFFERENCE | MAX DATE | MAX YEAR  AMT | % DIFF
2021-12-31 00:00:00 | 42227.5 | -3808.09 |  | 37084.51 |  |  | 2022-01-03 00:00:00 | 35333.23
2021-12-31 00:00:00 | 35405.21 | 0 |  | 32839.41 |  |  | 2022-01-04 00:00:00 | 35411.98
2021-12-31 00:00:00 | 703809.3 | -7445.64 |  | 688156.34 |  |  | 2022-01-04 00:00:00 | 705699.86
2021-12-31 00:00:00 | 9967.49 | -2865.11 |  | 6778.27 |  |  | 2022-01-03 00:00:00 | 10057.57
2021-12-31 00:00:00 | 2805249.24 | 4631.08 |  | 2735471.24 |  |  | 2022-01-13 00:00:00 | 3040603.18
2021-12-31 00:00:00 | 129280.51 | -4631.08 |  | 121121.87 |  |  | 2022-01-04 00:00:00 | 129916.83
2021-12-31 00:00:00 | 863457.34 | 7445.64 |  | 780253.72 |  |  | 2022-01-13 00:00:00 | 941099.98
2021-12-31 00:00:00 | 148816.46 | 0 |  | 134234.07 |  |  | 2022-01-03 00:00:00 | 150883.78
2021-12-31 00:00:00 | 123394.99 | 3808.09 |  | 117961.87 |  |  | 2022-01-12 00:00:00 | 129979.17
2021-12-31 00:00:00 | 87988.41 | 2865.11 |  | 81931.07 |  |  | 2022-01-12 00:00:00 | 92839.39
2021-12-31 00:00:00 | 4949596.45 | 0 |  | 4735832.37 |  |  | 2022-01-12 00:00:00 | 5242690.13
Spreadsheet: 143651d1330510096-unlock-first-row-for-editing-tt-index-copy-v1
Sheet: List

Participant Name | Department | Group | Role | Course | [NAME] | Hours | Provider | Trainer | Type | Results | Outcome | Status
Employee 1 | Dept 1 | Depot 1 |  | Course 1 | 1825 | 1 | In House | Trainer 1 | Initial | Failed | Valid | Active
Employee 2 | Dept 2 | Depot 2 |  | Course 2 | 1095 | 1 | External | Trainer 2 | [NAME] | Not Assessed | Expired | Maternity leave
Employee 3 | Dept 3 | Depot 3 |  | Course 3 | 365 | 4 |  | Trainer 3 |  | Passed |  | [NAME]
Employee 4 | Dept 4 | Depot 4 |  | Course 4 | 1095 | 8 |  | Trainer 4 |  |  |  | Left Company
Employee 5 | Dept 5 | Depot 5 |  | Course 5 | 1095 | 8 |  | Trainer 5
Employee 6 | Dept 6 | Depot 6 |  | Course 6 | 730 | 1 |  | Trainer 6
Employee 7 | Dept 7 | Depot 7 |  | Course 7 | 1095 | 3 |  | Trainer 7
Employee 8 | Dept 8 | Depot 8 |  | Course 8 | 1825 | 8 |  | Trainer 8
Employee 9 | Dept 9 | Depot 9 |  | Course 9 | 730 | 8 |  | Trainer 9
Employee 10 | Dept 10 | Depot 10 |  |  |  |  |  | Trainer 10
Employee 11 |  | Depot 11
 |  | Depot 12
 |  | Depot 13
 |  | Depot 14
 |  | Depot 15
Spreadsheet: 01478576-7ad0-4da2-ad98-97b6485b412c
Sheet: Sheet1

Reporting Month | Enter month reporting | Unnamed: 2 | Unnamed: 3
Business Licensee  Name | Enter business licensee name
Business Licensee /Application Number | Enter business license/application number
INSTRUCTIONS: Provide the required information for patients that have designated you as their Primary Center.  Do NOT submit any additional patient information.  For patients that do not have a license number yet, put "Pending."  If a patient is authorized for more than 6 plants, maintain, but do not submit, supporting documentation for additional plants. The list is due by the fifth business day of the month and Licensees must report their patient list as of the last day of the prior month (the reporting month).  For example, by Sept 5, licensees are required to submit their patient list as of Aug 31. Licensees must submit the Patient Status Change Form (Form 1040), when required, within 72 hours to the MMED.
Patient ID Number | Patient Card Expiration Date | Primary Center Designation Date | Maximum Plants Per Patient  *
Enter patient ID number from registry card | Enter patient card expiration date | Enter effective date of primary center designation | Enter maximum number of plants authorized for patient
Total Patient Count |  | enter  total number of patients
Total Plant Count |  | enter  total of maximum number of plants      authorized for patients listed on this report
Spreadsheet: darrell_schoolcraft__7325__imball0202
Sheet: Amoco

 | Florida Plant
Day | Measured | Scheduled | Imbal
1 | 147304 | 158363
2 | 162193 | 159898
3 | 156474 | 159849
4 | 156008 | 154229
5 | 152552 | 152972
6 | 156411 | 154640
7 | 159223 | 157936
8 | 154279 | 153799
9 | 154445 | 152757
10 | 155369 | 152757
11 | 156066 | 154251
12 | 157916 | 154251
13 | 152043 | 149527
14 | 159460 | 159170
15 | 151954 | 156660
16 | 161371 | 161663
17 | 163543 | 162791
18 | 160795 | 162790
19 | 152695 | 152757
20 | 153119 | 152756
21 | 152740 | 157125
22 | 159107 | 157125
23 | 156236 | 157125
24
25
26
27
28
29
30
31
2002-01-31 00:00:00 |  |  | -5048
2002-02-23 00:00:00
CBS Dollars
 |  |  | 324667
Spreadsheet: 173080d1344436059-auto-populate-a-sheet-based-on-criteria-in-another-sheet-pt-2-example-1-
Sheet: Over80%

Employee Name | Total Meetings | Arrived at | Percentage | Address | Phone
[NAME] | 10 | 9 | 0.9 | 126 [NAME] | [PHONE]
Maria | 10 | 10 | 1 | 128 [NAME] | [PHONE]
[NAME] | 10 | 8 | 0.8 | 129 [NAME] | [PHONE]
[NAME] | 10 | 8 | 0.8 | 130 [NAME] | [PHONE]
Spreadsheet: 820122d1677867710-formula-to-tell-cell-which-cell-to-read-excel-workbook-rhinolite-calcs-etaf
Sheet: Sheet1

 |  | RHINOLITE calcs
 |  | 12 |  | [NAME] gets a value from another [NAME] of a value between 2 and 15. I need G10 to see what the value of C3 is, and then decide which cell to use that is similar or close to the values in the B Cells. However, it need to then add the values of either [NAME] or [NAME]. |  |  |  |  |  | TOTAL AREA |  | 300 | M2
 | 3MM THICKNESS |  |  |  | per BAG | [NAME] | ROUNDED | TOTAL PRICE
 | 3 | 25 |  |  | 20 | 27.2
 | 5-6MM THICKNESS |  |  |  |  |  | Tot lab
 | 5 | 11.5 |  | labour/m2 | 50
 |  |  |  |  | /m2 | m2/BAG
 | 12-15MM THICKNESS
 | 12 | 4.5 |  |  |  |  |  |  |  | 0.08 | wastage
 |  |  |  |  |  |  |  |  |  | sub total 01
 | 15-20MM THICKNESS |  |  |  |  |  |  |  | 0 | 0.04 | prelims
 | 15 | 3 |  |  |  |  |  |  |  | sub total 2
 |  | for your information, the 3,5,12,15 resembles the thickness you apply the plaster, and due to variuos thickness, the areas 25;11.5;4.5;3 shows the area you get per bag of Rhinolite when you apply various thickness. G10 Need to add the specific area to calculate the amount of bags to be used |  |  |  |  |  |  |  | 0.05 | profit
 |  |  |  |  |  |  |  |  |  | total price per m²
Spreadsheet: 781962d1653657603-first-occurrence-formula-example-workbook-2-
Sheet: Sheet1

Dilution |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12
40 | A | 1 | 1 | 0.78 | 1 | 1 | 0.99 | 1 | 1 | 0.96 | 1 | 0.95
80 | B | 1 | 1 | 0.66 | 1 | 0.99 | 1 | 0.99 | 1 | 0.83 | 1 | 0.94
160 | C | 0.99 | 1 | 0.61 | 0.98 | 0.99 | 0.95 | 0.99 | 1 | 0.81 | 1 | 0.86
320 | D | 1 | 0.99 | 0.49 | 0.96 | 0.95 | 0.94 | 0.98 | 0.99 | 0.42 | 0.98 | 0.66
640 | E | 0.98 | 0.99 | 0.55 | 0.79 | 0.96 | 0.92 | 0.96 | 0.98 | 0.33 | 0.93 | 0.61
1280 | F | 0.96 | 0.97 | 0.31 | 0.77 | 0.88 | 0.86 | 0.92 | 1 | 0.32 | 0.97 | 0.49
2560 | G | 0.91 | 0.94 | 0.25 | 0.63 | 0.8 | 0.82 | 0.82 | 0.95 | 0.22 | 0.85 | 0.62
5120 | H | 0.76 | 0.82 | 0.17 | 0.35 | 0.58 | 0.71 | 0.65 | 0.83 | 0.08 | 0.8 | 0.31
7680
 | Correct Readout: | 2560 | 7680 | 40 | 320
 | Previous formula
Spreadsheet: benjamin_rogers__1179__BasePowerModel3
Sheet: Depreciation

DEPRECIATION SCHEDULE
('000 $)
(Months) |  |  |  |  | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12
US FEDERAL TAX DEPRECIATION & AMORTIZATION
 | Years
Total Hard Costs, Capitalized Interests, and Contingency- MACRS |  |  |  | 0.05 | 0.095 | 0.0855 | 0.077 | 0.0693 | 0.0623 | 0.059 | 0.0591 | 0.059 | 0.0591 | 0.059 | 0.0591 | 0.059 | 0.0591 | 0.059 | 0.0295 | 0 | 0 | 0 | 0 | 0 | 0
Transaction Costs
Total Hard Costs and Capitalized Interests (Land not included)
Transaction Costs
Total Beginning Book Value
Ending Value of Assets
STATE TAX DEPRECIATION & AMORTIZATION
 | Years
Total Hard Costs, Capitalized Interests, and Contingency- MACRS
Transaction Costs
Total Hard Costs and Capitalized Interests (Land not included)
Transaction Costs
Total Beginning Book Value
Ending Value of Assets
BOOK DEPRECIATION & AMORTIZATION
 | Years | Residual
Total Hard Costs, Capitalized Interests, and [NAME]
Transaction Costs
Total Hard Costs, Capitalized Interests, and [NAME]
Transaction Costs
Total Beginning Book Value
Ending Book Value of Assets
Spreadsheet: 878312d1725382268-find-min-and-max-date-for-each-vehicle-inspection-when-there-are-several-dates-ef-inspection-pivot-demo
Sheet: Sheet1

Plate Number | Status | Status Date | Counter
15787987 | Inspection | 2022-09-01 00:00:00 | 1
15787987 | Inspection | 2022-09-02 00:00:00 |  |  |  |  | Plate Number | Counter | Min of Status Date | [NAME] of Status Date2
15787987 | Inspection | 2022-09-03 00:00:00 |  |  |  |  | 15787987 | 1 | 2022-09-01 00:00:00 | 2022-09-05 00:00:00
15787987 | Inspection | 2022-09-04 00:00:00 |  |  |  |  |  | 2 | 2023-10-01 00:00:00 | 2023-10-02 00:00:00
15787987 | Inspection | 2022-09-05 00:00:00 |  |  |  |  |  | 3 | 2019-10-10 00:00:00 | 2019-10-12 00:00:00
15787987 | Inspection | 2023-10-01 00:00:00 |  |  |  |  | 45484848 | 4 | 2018-09-04 00:00:00 | 2018-09-05 00:00:00
15787987 | Inspection | 2023-10-02 00:00:00 |  |  |  |  |  | 5 | 2017-10-01 00:00:00 | 2017-10-02 00:00:00
15787987 | Inspection | 2019-10-10 00:00:00 |  |  |  |  |  | 6 | 2016-06-13 00:00:00 | 2016-06-16 00:00:00
15787987 | Inspection | 2019-10-11 00:00:00
15787987 | Inspection | 2019-10-12 00:00:00
45484848 | Inspection | 2018-09-04 00:00:00
45484848 | Inspection | 2018-09-05 00:00:00
45484848 | Inspection | 2017-10-01 00:00:00
45484848 | Inspection | 2017-10-02 00:00:00
45484848 | Inspection | 2016-06-13 00:00:00
45484848 | Inspection | 2016-06-14 00:00:00
45484848 | Inspection | 2016-06-15 00:00:00
45484848 | Inspection | 2016-06-16 00:00:00
Spreadsheet: 708023d1607589493-how-to-report-the-top-20-and-bottom-20-of-a-data-table-report-with-2-conditions-dashboard
Sheet: CANADA

Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | Top 5  lowest price | AB | MedEL | Cochlear | OM | Custom label
Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | Top 5  highest price | AB | MedEL | Cochlear | OM | Custom label
Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | Antenna cable | AB | MedEL | Cochlear | OM | Custom label
Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | [NAME] | AB | MedEL | Cochlear | OM | Custom label
Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | Charger | AB | MedEL | Cochlear | OM | Custom label
Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | Recheargable battery | AB | MedEL | Cochlear | OM | Custom label
Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | Full swim kit | AB | MedEL | Cochlear | OM | Custom label
Spreadsheet: 865908d1712861540-what-can-i-use-as-an-alternative-to-get-workbook-tabrangeproblem
Sheet: Tab List

[NAME] |  |  |  |  |  | This cell has a formula in it! >>>
 |  |  |  | To work, this requires a named range to be created called TabListRange, using:
 |  |  |  | =GET.WORKBOOK(1,'Tab List'!$K$2)&T(NOW())
 |  |  |  | ..but you can't save this unless it's an .xlsm file.
 |  |  |  | Can you help me update the formula for the named range so it doesn't use a blocked function in the most recent version(s) of Excel?
Spreadsheet: 860093d1708324863-formula-to-check-overlapping-dates-by-another-column-formula-to-check-overlapping-dates-by-another-column-hd-2-
Sheet: Sheet1 (2)

ITEM | QUANTITY | INSTALL DATE | PICK UP DATE | PACKAGE | NO. WEEKS | Availaility |  |  | Workings: | First Occurance Dates |  | Availaility | Combined Formula
01_2.0 SEAT UPHOLSTERED SOFA | 1 | 2023-08-08 00:00:00 | 2023-10-03 00:00:00 | Essential | 8 |  | <-- the first occurance of this item, so should show "Available"
01_2.0 SEAT UPHOLSTERED SOFA | 1 | 2023-08-21 00:00:00 | 2023-10-16 00:00:00 | Essential | 8 |  | <-- correct as the item is not available until after 3/10 (line 2)
01_2.0 SEAT UPHOLSTERED SOFA | 1 | 2023-08-22 00:00:00 | 2023-10-03 00:00:00 | Essential | 6 |  | <-- correct as the item is not available until after 3/10 (line 2)
01_2.0 SEAT UPHOLSTERED SOFA | 1 | 2023-08-28 00:00:00 | 2023-10-09 00:00:00 | Essential | 6 |  | <-- correct as the item is not available until after 3/10 (line 2)
01_2.0 SEAT UPHOLSTERED SOFA | 1 | 2024-01-09 00:00:00 | 2024-02-13 00:00:00 | DESIGNER | 5 |  | <-- correct as the item is not available until after 3/10 (line 2)
01_2.5 SEAT UPHOLSTERED SOFA | 1 | 2023-07-17 00:00:00 | 2023-09-11 00:00:00 | Essential | 8 |  | <-- the first occurance of this item, so should show "Available"
01_2.5 SEAT UPHOLSTERED SOFA | 1 | 2023-07-18 00:00:00 | 2023-08-29 00:00:00 | Essential | 6 |  | <-- correct as the item is not available until after 11/9 (line 7)
01_2.5 SEAT UPHOLSTERED SOFA | 1 | 2023-07-18 00:00:00 | 2023-09-12 00:00:00 | Essential | 8 |  | <-- correct as the item is not available until after 11/9 (line 7)
01_2.5 SEAT UPHOLSTERED SOFA | 1 | 2023-08-11 00:00:00 | 2023-10-06 00:00:00 | Essential | 8 |  | <-- correct as the item is not available until after 11/9 (line 7)
01_2.5 SEAT UPHOLSTERED SOFA | 1 | 2023-09-11 00:00:00 | 2023-09-28 00:00:00 | Essential | 6 |  | <-- should show as "Available" because the date is after 11/9
01_2.5 SEAT UPHOLSTERED SOFA | 1 | 2023-09-01 00:00:00 | 2023-10-17 00:00:00 | Essential | 8 |  | <-- correct as the item is not available until after 11/9 (line 7)
01_2.5 SEAT UPHOLSTERED SOFA | 1 | 2023-08-29 00:00:00 | 2023-10-24 00:00:00 | Essential | 8
01_2.5 SEAT UPHOLSTERED SOFA | 1 | 2023-08-29 00:00:00 | 2023-10-24 00:00:00 | Essential | 8
01_2.5 SEAT UPHOLSTERED SOFA | 1 | 2023-09-30 00:00:00 | 2023-11-06 00:00:00 | Essential | 6
01_2.5 SEAT UPHOLSTERED SOFA | 1 | 2023-09-26 00:00:00 | 2023-11-12 00:00:00 | Essential | 6 |  | <-- what happens when the item is avail, so now it is taken (row above) and this row should be Check
[NAME] to check overlapping dates by another column
[NAME] to check overlapping dates by another column - Reply to Topic (excelforum.com)
Spreadsheet: 01a66242-e3f3-4471-a32c-b8bf49aa369a
Sheet: Form Page 2 (if needed)

 | University Expense Claim Form
 | CARS IV# |  |  |  | Check, U.S. Mail
 | Date Rec'd in A/P |  |  |  | Address
 |  |  |  |  | City, State & Zip Code
 | CARS ID# |  | Acct# |  | Check, specify      Campus Mail      Hold for pickup
BU Faculty/Staff | Payee Name
BU Student | SS# if no CARS ID# |  |  |  | Dept |  |  | Ext #
Other |  | A | B | C | D |  | E | F | G
Purpose, Destination, Explanation & Other Required Information | Date of Expense/Receipt (MM/DD/YYYY) | Personal Auto Mileage (32000) | Airfare, Taxis (32000) | [NAME] (35000) | Lodging (32000) |  | Meals (34100) | Conference Fee (54000 Fac) (54500) Staff | Other Expenses (Explain)
Claims for expenses should be submitted every | Total Miles
30 days according to BU policy.  The IRS requires reimbursement requests to be filed within 60 days of the expense.   The date the form is received in Accounts Payable is considered the date of consideration for the 60 days.   If reimbursement is approved on those expenses submitted past 60 days, reimbursement will be via payroll as "other income." | Calculation @ $0.50 per mile |  | Original receipts are required for all expenses in Columns B, C, D, E, F & G.  For meals, the detail menu receipt must be submitted as well.
 |  |  |  |  |  |  | Column Totals of A, B, C, D, E, F & G
Payee's Signature
 | Signature denotes expenses are in compliance with University policies and procedures |  |  |  |  |  | Less personal expenses
 |  |  |  |  |  |  | Less Cash Advance
Director of Student Activities |  |  |  |  |  |  | Total from Page 1
 |  |  |  |  |  |  | Due to payee/(Bellarmine)
SGA Vice President of Finance
Account # | Amount | Account # |  |  | Amount |  | Entered by A/P  (initials)
Account # | Amount | Account # |  |  | Amount |  | Approved by (initials)