tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 801099d1666084474-how-to-use-averageifs-and-offset-to-get-rolling-average-sampleaverage-hd
Sheet: Sheet1

1 | 0.25 | 2022-03-16 00:00:00 | 7 | 66 | 7 | 0.25
2 | 0.5 | 2022-03-17 00:00:00 | 14 | 100 | 14 | 0.5
3 | 0.5 | 2022-03-17 00:00:00 | 14 | 12 | 24 | 1
4 | 1 | 2022-03-19 00:00:00 | 24 | 21
5 | 1 | 2022-03-19 00:00:00 | 24 | 45
6 | 0.5 | 2022-03-19 00:00:00 | 14 | 22
7 | 0.5 | 2022-03-23 00:00:00 | 14 | 44
8 | 1 | 2022-03-23 00:00:00 | 24
9 | 0.5 | 2022-03-24 00:00:00 | 14 | 76
10 | 1 | 2022-03-24 00:00:00 | 24
11 | 0.5 | 2022-03-24 00:00:00 | 14 | 33
12 | 1 | 2022-03-24 00:00:00 | 24 | 60
13 | 0.5 | 2022-03-25 00:00:00 | 14 | 33
14 | 1 | 2022-03-25 00:00:00 | 24
15 | 1 | 2022-03-26 00:00:00 | 24
16 | 1 | 2022-03-28 00:00:00 | 24
Spreadsheet: 279294d1385059410-tweaking-a-excel-schedule-dockschedule_reply
Sheet: Name Lookup

This sheet populates the drop down list of names on the [NAME] sheet in cell H3.  Any changes made to this sheet could result in an error.
UNIQUE NAME | ROW NUMBER
Spreadsheet: 84208d1284207658-sumproduct-array-forumlas-overall-percentage-complete-percent_complete
Sheet: Sheet1

 |  |  |  |  | Reports |  |  |  |  | Costs
Periods | From | To |  |  | Activity | Period | % Complete
1 | 2010-01-01 00:00:00 | 2010-01-31 00:00:00 |  |  | Act01 | 1 | 0.1 |  |  | Activity | Date | Invoice
2 | 2010-01-31 00:00:00 | 2010-03-02 00:00:00 |  |  | Act01 | 2 | 0.15 |  |  | Act01 | 2010-02-01 00:00:00 | 123
3 | 2010-03-02 00:00:00 | 2010-04-01 00:00:00 |  |  | Act01 | 3 | 0.2 |  |  | Act01 | 2010-02-04 00:00:00 | 234
4 | 2010-04-01 00:00:00 | 2010-05-01 00:00:00 |  |  | Act02 | 1 | 0.08 |  |  | Act01 | 2010-03-05 00:00:00 | 345
5 | 2010-05-01 00:00:00 | 2010-05-31 00:00:00 |  |  | Act02 | 2 | 0.12 |  |  | Act02 | 2010-01-08 00:00:00 | 276
6 | 2010-05-31 00:00:00 | 2010-06-30 00:00:00 |  |  | Act02 | 3 | 0.13 |  |  | Act02 | 2010-01-14 00:00:00 | 398
7 | 2010-06-30 00:00:00 | 2010-07-30 00:00:00 |  |  | Act03 | 1 | 0.04 |  |  | Act02 | 2010-03-05 00:00:00 | 167
8 | 2010-07-30 00:00:00 | 2010-08-29 00:00:00 |  |  | Act03 | 2 | 0.2 |  |  | Act03 | 2010-01-08 00:00:00 | 173.88
9 | 2010-08-29 00:00:00 | 2010-09-28 00:00:00 |  |  | Act03 | 3 | 0.22 |  |  | Act03 | 2010-01-14 00:00:00 | 250.74
10 | 2010-09-28 00:00:00 | 2010-10-28 00:00:00 |  |  | Act04 | 1 | 0.05 |  |  | Act03 | 2010-03-05 00:00:00 | 105.21
 |  |  |  |  | Act04 | 2 | 0.17 |  |  | Act04 | 2010-01-25 00:00:00 | 109.5444
 |  |  |  |  | Act04 | 3 | 0.23 |  |  | Act04 | 2010-02-25 00:00:00 | 157.9662
 |  |  |  |  |  |  |  |  |  | Act04 | 2010-03-25 00:00:00 | 66.28229999999999
Activity | Budget
Act01 | 1000
Act02 | 1000
Act03 | 1000 |  |  | Overall
Act04 | 1000
 |  |  |  | Period | Total Invoices | % Complete
 |  |  |  | 1 | 1208.1644 | 0.0675
Total Budget | 4000 |  |  | 2 | 514.9662000000001 | 0.16
 |  |  |  | 3 | 683.4923 | 0.195
Spreadsheet: larry_campbell__21030__PlainviewPTE
Sheet: TANKs

NORTHERN NATURAL GAS COMPANY
PLAINVIEW COMPRESSOR STATION
TNRCC ACCOUNT NO. HA-0116-Q
TANK EMISSIONS
 |  |  | Annual | Maximum | Working | Standing | Annual | [NAME]
 |  | Capacity | Throughput | [NAME] | Losses | Losses | Emissions | Emissions
Tank ID | Contents | (gals) | (gal/yr) | (gals/hr) | (lb/yr) | (lb/yr) | (tpy) | (lb/hr)
TK-1 | Condensate | 8820 |  | 4200 | 496 | 583
TK-2 | [NAME] | 2558 |  | 4200 | 0 | 0
TK-3 | Engine Coolant | 1070 |  | 4200 | 0 | 0
TK-4 | [NAME] | 1500 |  | 4200 | 0 | 0 | 0 | 0
TOTAL
Note:
(1) Turnovers conservatively estimated at 1 per month.
(2) Emissions from tanks (except TK-1) are assumed to be insignificant due to the low vapor pressures of the contents and the low annual throughput.
Spreadsheet: 680726d1591165881-select-data-below-every-color-filled-cells-data
Sheet: Sheet1

XYZ  (PVT) LTD.
[NAME]
[EMAIL]
xxx-xxxxxxx
LAFARGE  CEMENT
MR. ZAFAR [NAME]
xxx-xxxxxxx
INSERT THIS ROW TO MAKE IT CONSISTENT DATA. FILL OR LEAVE IT BLANK
ABC (PVT) LTD
MR.ZAFAR [NAME] HASHMI
[EMAIL]
xxx-xxxxxxx
ABC (PVT) LTD
MR.ZAFAR [NAME] HASHMI
[EMAIL]
xxx-xxxxxxx
ABC (PVT) LTD
MR.ZAFAR [NAME] HASHMI
[EMAIL]
xxx-xxxxxxx
ABC (PVT) LTD
MR.ZAFAR [NAME] HASHMI
[EMAIL]
xxx-xxxxxxx
ABC (PVT) LTD
MR.ZAFAR [NAME] HASHMI
[EMAIL]
xxx-xxxxxxx
ABC (PVT) LTD
MR.ZAFAR [NAME] HASHMI
[EMAIL]
xxx-xxxxxxx
ABC (PVT) LTD
MR.ZAFAR [NAME] HASHMI
[EMAIL]
xxx-xxxxxxx
ABC (PVT) LTD
MR.ZAFAR [NAME] HASHMI
[EMAIL]
xxx-xxxxxxx
ABC (PVT) LTD
MR.ZAFAR [NAME] HASHMI
[EMAIL]
xxx-xxxxxxx
ABC (PVT) LTD
MR.ZAFAR [NAME] HASHMI
[EMAIL]
xxx-xxxxxxx
ABC (PVT) LTD
MR.ZAFAR [NAME] HASHMI
[EMAIL]
xxx-xxxxxxx
ABC (PVT) LTD
MR.ZAFAR [NAME] HASHMI
[EMAIL]
xxx-xxxxxxx
ABC (PVT) LTD
MR.ZAFAR [NAME] HASHMI
[EMAIL]
xxx-xxxxxxx
ABC (PVT) LTD
MR.ZAFAR [NAME] HASHMI
[EMAIL]
xxx-xxxxxxx
ABC (PVT) LTD
MR.ZAFAR [NAME] HASHMI
[EMAIL]
xxx-xxxxxxx
ABC (PVT) LTD
MR.ZAFAR [NAME] HASHMI
[EMAIL]
xxx-xxxxxxx
ABC (PVT) LTD
MR.ZAFAR [NAME] HASHMI
[EMAIL]
xxx-xxxxxxx
ABC (PVT) LTD
MR.ZAFAR [NAME] HASHMI
[EMAIL]
xxx-xxxxxxx
ABC (PVT) LTD
MR.ZAFAR [NAME] HASHMI
[EMAIL]
xxx-xxxxxxx
ABC (PVT) LTD
MR.ZAFAR [NAME] HASHMI
[EMAIL]
xxx-xxxxxxx
ABC (PVT) LTD
MR.ZAFAR [NAME] HASHMI
[EMAIL]
xxx-xxxxxxx
ABC (PVT) LTD
MR.ZAFAR [NAME] HASHMI
[EMAIL]
xxx-xxxxxxx
ABC (PVT) LTD
MR.ZAFAR [NAME] HASHMI
[EMAIL]
xxx-xxxxxxx
ABC (PVT) LTD
MR.ZAFAR [NAME] HASHMI
[EMAIL]
xxx-xxxxxxx
ABC (PVT) LTD
MR.ZAFAR [NAME] HASHMI
[EMAIL]
xxx-xxxxxxx
ABC (PVT) LTD
MR.ZAFAR [NAME] HASHMI
[EMAIL]
xxx-xxxxxxx
ABC (PVT) LTD
MR.ZAFAR [NAME] HASHMI
[EMAIL]
xxx-xxxxxxx
Spreadsheet: 09fd5591-44aa-4423-ba8c-92473af9bb2a
Sheet: Sheet1

Table S7  A total of 17 genic-SSRs showing polymorphic among 12 C.ensifolium accessions | Unnamed: 1
Genic-SSR | Sequence
Primer01 | AACGCCATGTCCAATACCC
 | GGAGGGCTTATTTGCAGCG
Primer03 | CTCGGTTCATTTGCAGCCC
 | GGGTGGGTATGGCGAAATC
Primer04 | AGAATCTGCCAACCCTTGATAC
 | GCAGATGCCAGTTAGAATGGG
Primer08 | TGCTGGAATACATGCGAGAC
 | GTTTGCCGAAGCCAGTGC
Primer11 | AACTGACAAGCATCTGCAAG
 | CTGCTGCATTGGCCTTACC
Primer14 | CACAGCAGCTCACAATCCTG
 | TACAGCCCTGTTTACCGCC
Primer15 | CCTTCTCTCCGCGTACCAG
 | CTTCGGTTGGCGTTTAGGG
Primer18 | TGAAACGGTTGGCTCTAGTTC
 | AGCAAGCACTGACCTGAAAC
Primer21 | TGGGCGACAGATCGAGTTC
 | ACATGGACCACAGCATTCC
Primer22 | TATGCGTCTCTCCCAACCG
 | AAGCTAGTGGCCTTTGGTG
Primer26 | GCTTTATGCGACATCTGCG
 | CGTCGGTTCCATGCACATC
Primer27 | CTGCCTTCACAGCTAATGCC
 | GCATGCTTGGACGCTGAAC
Primer36 | AGTATTGGACCCTCCAGGC
 | AGAGGATCATGGTGTTAGGC
Primer42 | GACGACATATCGCGTTCGG
 | CTCAGCCACACCCAAGAGG
Primer43 | GGAGCTGCATACGCAAGTG
 | AGCTTCTCACTGCCTCCAG
Primer45 | GCCTTACACATCCCTTCCAAC
 | TGCCTGCTGATAGTTTGCC
Primer49 | AGAGGGCCACCTGCTTTC
 | GCCAATTGCCAGATGGACG
Spreadsheet: d7a7d575-1729-4709-b884-cb3b8a04eb14
Sheet: Sheet1

Taxon | Cycad | [NAME] | Phoenix | Oryza | [NAME] | Arabidopsis | [NAME] | Boea
GI # | NC_010303 | JQ804980 | NC_016740 | NC_011033 | NC_007982 | NC_001284 | NC_006581 | NC_016741
[NAME] (bp) | 414903 | 228493 | 715001 | 490520 | 569630 | 430597 | 430597 | 366924
Citation | Chaw, 2008 | / | Fang, 2012 | Notsu, 2002 | Clifton, 2004 | Unseld, 1997 | Sugiyama, 2005 | Zhang, 2012
atp1 | + | + | + | + | + | + | + | +
atp4 | + | + | + | + | + | + | + | +
atp6 | + | + | + | + | + | + | + | +
atp8 | + | + | + | + | + | + | + | +
atp9 | + | + | + | + | + | + | + | +
ccmB | + | + | + | + | + | + | + | +
ccmC | + | + | + | + | + | + | + | +
ccmFC | + | + | + | + | + | + | + | +
ccmFN | + | + | + | + | + | + | + | +
cob | + | + | + | + | + | + | + | +
cox1 | + | + | + | + | + | + | + | +
cox2 | + | + | + | + | + | + | + | +
cox3 | + | + | + | + | + | + | + | +
matR | + | + | + | + | + | + | + | +
mttB | + | + | + | + | + | + | + | +
[NAME] | + | + | + | + | + | + | + | +
nad2 | + | + | + | + | + | + | + | +
nad3 | + | + | + | + | + | + | + | +
nad4 | + | + | + | + | + | + | + | +
[NAME] | + | + | + | + | + | + | + | +
nad5 | + | + | + | + | + | + | + | +
nad6 | + | + | + | + | + | + | + | +
nad7 | + | + | + | + | + | + | + | +
nad9 | + | + | + | + | + | + | + | +
rpl10 | + | + | + | Y | - | - | + | -
rpl16 | + | + | + | + | + | + | + | +
rpl2 | + | - | + | + | - | + | - | -
rpl5 | + | + | + | + | - | + | + | +
rps1 | + | + | + | + | + | - | + | -
rps10 | + | - | + | - | - | - | + | +
rps11 | + | - | + | - | - | - | - | -
rps12 | + | + | + | + | + | + | + | +
rps13 | + | + | + | + | + | - | + | +
rps14 | + | Y | + | Y | - | + | + | +
rps19 | + | Y | + | + | - | + | + | +
[NAME] | + | + | + | + | + | - | - | -
rps3 | + | + | + | + | + | + | + | +
rps4 | + | + | + | + | + | + | + | +
rps7 | + | + | + | + | + | + | - | -
sdh3 | + | - | - | - | - | - | + | +
sdh4 | + | + | + | - | - | + | + | +
tRNA-Arg | + | - | - | + | + | - | - | -
[NAME] | + | + | - | + | + | + | + | +
tRNA-Asp | + | + | + | + | + | + | + | +
tRNA-Cys | + | + | + | + | + | + | + | +
tRNA-Gln | + | + | + | + | + | + | + | +
tRNA-Glu | + | + | + | + | + | + | + | +
tRNA-Gly | + | + | - | - | - | + | + | +
tRNA-Lys | + | + | + | + | + | + | + | +
tRNA-His | + | + | - | + | + | + | + | -
tRNA-Ile | + | + | - | + | + | + | + | +
tRNA-Leu | + | - | - | - | + | - | - | -
tRNA-Met | + | + | + | + | + | + | + | +
tRNA-Phe | + | + | + | + | + | + | + | -
tRNA-Pro | + | + | + | + | + | + | + | +
tRNA-Ser | + | + | + | + | + | + | + | +
[NAME] | - | - | + | - | - | - | - | -
tRNA-Trp | + | + | - | + | - | + | + | +
tRNA-Tyr | + | + | + | + | + | + | + | +
tRNA-Val | + | - | - | + | + | - | - | -
Spreadsheet: 75499d1276074713-how-to-retrieve-information-from-multiple-sheets-sheet-relatives
Sheet: day 4

 | Product | Data 2 | Data 3 | Data 4 | Data 5 | Data 6 | Data 7
 | Product 1 |  |  |  | 5
 | Product 2 |  |  |  | 48
 | Product 3 |  |  |  | 64
 | Product 4 |  |  |  | 81
 | Product 5 |  |  |  | 94
 | Product 6 |  |  |  | 76
 | Product 7 |  |  |  | 53
 | Product 8 |  |  |  | 52
 | Product 9 |  |  |  | 15
 | Product 10 |  |  |  | 29
 | Product 11 |  |  |  | 27
 | Product 12 |  |  |  | 46
 | Product 13 |  |  |  | 95
 | Product 14 |  |  |  | 45
 | Product 15 |  |  |  | 61
Spreadsheet: 208863d1358951661-how-to-create-random-kilometer-figure-per-day-from-a-montly-change-of-days-and-km-driven-random-based-on-total-solution
Sheet: Sheet1

 |  |  | Day | [NAME] |  |  |  |  | TOTAL | 40000
 |  |  | 1 |  |  |  |  |  | # OF DAYS | 25
 |  |  | 2
 |  |  | 3
 |  |  | 4
 |  |  | 5
 |  |  | 6
 |  |  | 7
 |  |  | 8
 |  |  | 9
 |  |  | 10
 |  |  | 11
 |  |  | 12
 |  |  | 13
 |  |  | 14
 |  |  | 15
 |  |  | 16
 |  |  | 17
 |  |  | 18
 |  |  | 19
 |  |  | 20
 |  |  | 21
 |  |  | 22
 |  |  | 23
 |  |  | 24
 |  |  | 25
 |  |  | 26
 |  |  | 27
 |  |  | 28
 |  |  | 29
 |  |  | 30
Spreadsheet: john_arnold__15145__Enron INCONTROL Product Order Form 11-28-00
Sheet: CTM Licenses By Business

Enterprise Control Station and User-Based Tools
License Description | Tier | Qty. | List Price | Total Fee
Enterprise Control Station (Production) | N/A | 1 | 20055
Additional Users (One seat included with ECS) | N/A | 9 | 3500
Enterprise Control Station (Development) | N/A | 1 | 20055
Control-M/WebAccess (Server) | Department | 1 | 3460
Control-M/WebAccess (Seats) | N/A | 50 | 225
Control-M/Desktop (Seats) | N/A | 50 | 450
Control-M/Links for Distributed Systems | N/A | 1 | 15000
Enron North America Tier-Based Licenses
License Description | Tier | Qty. | List Price | Total Fee
Control-M/Server Unix | Workgroup | 2 | 4575
Control-M/Server (Develop) | Workgroup | 1 | 4575
Control-M/Agent Unix | Workgroup | 4 | 3615
Control-M/Agent Unix | Department | 1 | 18625
Control-M/Agent Unix | Enterprise 1 | 2 | 47170
Control-M/Agent NT/2K | Workgroup | 8 | 2385
Control-M/Patrol KM’s for above | Various | 18 | Various | 79650
Enron Transportation & Storage Tier-Based Licenses
License Description | Tier | Qty. | List Price | Total Fee
Control-M/Server Unix | Workgroup | 2 | 4575
Control-M/Server (Develop) | Workgroup | 1 | 4575
Control-M/Agent Unix | Workgroup | 4 | 3615
Control-M/Agent NT/2K | Workgroup | 5 | 2385
Control-M/Patrol KM’s for above | Various | 14 | Various | 18835
SAP/R3 Processing Management Licenses
ECS and User-Based Tools |  | Qty. | List Price | Total Fee
Additional ECS Users | N/A | 4 | 3500
Control-M/WebAccess (Seats) | N/A | 30 | 225
Control-M/Desktop (Seats) | N/A | 30 | 450
Control-M Tier-Based Licenses
License Description | Tier | Qty. | List Price | Total Fee
Control-M/Server Unix | Workgroup | 1 | 4575
Control-M/Server (Develop) | Workgroup | 1 | 4575
Control-M/Agent Unix | Workgroup | 2 | 3615
Control-M/Agent Unix | Department | 2 | 18625
Control-M/Agent Unix | Enterprise 1 | 2 | 47170
Control-M/Agent NT/2K | Workgroup | 8 | 2385
Control-M/Patrol KM’s for above | Various | 16 | Various | 83590
SAP/R3 Processing Option for Windows | N/A | 1 | 24965
SAP/R3 Processing Option for Unix | N/A | 2 | 37825
Control-M License Summary
Functional Area or Business Unit | List Price | Discount | _Net Fee_ | Maintenance
Enterprise Control Station & User-Based Tools
Enron North America
Enron Transportation & Storage
Enron SAP/R3 Processing Management
Total All Software Licenses
Professional Services Estimate
 | Estimated | Daily | Total
Consulting Services | Days | Rate | Services
Engagement Manager | 8 | 2500 | 20000
Consultant | 30 | 2000 | 60000
On-site Training Classes | 6 | 2500 | 15000
Spreadsheet: 140886d1328923648-large-database-yfeb-food-total-values
Sheet: 2-11-12

 | Breakfast | Quantity | Measure | Food Item | Cost | Daily Points
 | Daily Total
 | Lunch | Quantity | Measure | Food Item | Cost | Daily Points
 | Dinner | Quantity | Measure | Food Items | Cost | Daily Points
Spreadsheet: 136217d1326477926-how-to-apply-iserror-in-an-array-formula-iserror-in-an-array-formula
Sheet: Orders

 | Month | Amount |  |  |  |  |  | Month | Total
 | Feb | 300 |  |  |  | Jan |  | Jan
 | Jan | 8.5 |  |  |  |  |  | Feb
 | Jan | 17.5 |  |  |  |  |  | Mar
 | Feb | 50 |  |  |  |  |  | Apr
 | Feb | 96 |  |  |  |  |  | May
 | Jan | 90 |  |  |  |  |  | Jun
 | Feb | 225 |  |  |  |  |  | Jul
 | Feb | 0.5 |  |  |  |  |  | Aug
 | Jan | 1042.5 |  |  |  |  |  | Sep
 | Feb | 281.5 |  |  |  |  |  | Oct
 | Feb | 53.6 |  |  |  |  |  | Nov
 | Jan | 35 |  |  |  |  |  | Dec
 | Feb | 10
 | Feb | 10
 | Total:
Spreadsheet: 789930d1659447679-error-in-formula-for-fixing-4-characters-in-a-number-from-text-extract-formula_text_1
Sheet: Sheet1

BB-1425/ DD569/FR 52
BB-1425/ DD569/FR 53
BB-1425/ D1569/FR 54
BB-1425/ D1569/F155
BB-1425/ D1569/F155/FR 52
Spreadsheet: 683814d1592965099-formula-that-returns-a-value-under-specific-conditions-region-issuev4
Sheet: Sheet1

Entered Account # | Entered Date | Region (as returned from formula) |  |  |  |  | [NAME] that Returns a Value under Specific Conditions
ABC | 2018-02-01 00:00:00 |  |  |  |  |  | My problem is as below: I have some data that was dumped from a database and I need to return the "Region" from that data (for the "Entered Account #" and "Entered Date") under the following conditions: - IF "Void?" = "Y", THEN STOP, no need to look further.  But if record NOT voided, then: 1.  IF "Span Duration is = 365 or 366 and  2.  "Entered Date" is >= the "From Date" and  3.  "Entered Date" is <= the "To Date"THEN return "Region" from the "matched" row.  BUT only perform steps 1-3 when the "Entered Account #" is = the "Account #" from the Database Data.  Need to check all the date spans within that "Account #". That's Part 1. Part 2 is:  IF "Void?" is <> "Y" and "Span Duration" is < 365, THEN use the "Region" from the next row in the database data but ONLY if that next row is for the same "Account #"   I tried using all kinds of combinations of INDIRECT, ADDRESS, CELL, COLUMN, ROW, iNDEX and am not having any luck.   I can't use a macro for this and was wondering if it is able to be done with a formula. I'm probably/definitely biting off more than I can chew :) but any help you can provide will be hugely appreciated.  Thanks!
ABC | 2020-03-01 00:00:00
ABC | 2020-02-01 00:00:00 | Voided Record
DEF | 2018-06-30 00:00:00
ABC | 2019-02-01 00:00:00
DEF | 2019-02-01 00:00:00 | Voided Record
DEF | 2017-01-01 00:00:00
DEF | 2019-02-01 00:00:00
Database Data
Account # | Void? | Span Duration (Days) | From Date | To Date | Region
ABC | N |  | 2018-01-01 00:00:00 | 2018-12-31 00:00:00 | Boston
ABC | N |  | 2019-01-01 00:00:00 | 2019-12-31 00:00:00 | New York
ABC | N |  | 2020-01-01 00:00:00 | 2020-12-31 00:00:00 | Sacramento
ABC | Y |  | 2018-02-01 00:00:00 | 2018-01-01 00:00:00 | Tulsa
DEF | N |  | 2018-01-01 00:00:00 | 2018-12-31 00:00:00 | Wichita
DEF | N |  | 2019-01-01 00:00:00 | 2019-12-31 00:00:00 | Sarasota
DEF | Y |  | 2018-02-01 00:00:00 | 2018-01-01 00:00:00 | Reno
DEF | N |  | 2020-01-01 00:00:00 | 2020-12-31 00:00:00 | Denver
So sorry I was not clear….It means if there is a "Y" in the "Void?" column, that means the record is a voided record and no need to do steps 1, 2, and 3, i.e., you don't need to check the "Span Duration" or if the "Entered Date" falls between the "From Date" and "Date".  Basically, just return a value that says "Voided Record"
So to the differences between your results and mine, in rows 7 and 9:
For Row 7:  You are right….it should return Sarasota
For Row 9:  When you look at the Account # and Date in Row 9, the formula should look in the DEF records, and it finds that the "Entered Date" of 1-Feb-19 falls into the the range shown in row 18...so the value returned should also be "Region" Sarasota, the region on row 18
Spreadsheet: 0d578bfc-f92c-494a-bb6c-02fecd964935
Sheet: Sheet1

1987 - 31st Coupe Aéronautique [NAME] | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
Starting Point: | Seefeld, Tirolia, Austria |  |  |  |  | 1987-10-03 00:00:00
 |  | Pilots Name |  | Co-Pilots Name
Rank | Country | Last | First | Last | First | BalloonName | LandingPlace | Distance km | Time
1 | AUT | Starkbaum | [NAME] | Scholz | Gerd | HB-BBL Volksbank | Scoce/Titograd/ Yugoslavia | 852 | 1900-01-01 08:16:00
2 | SUI | Spenger | [NAME] | Messner | Martin | HB-BFC Jura | Arilje/Yugoslavia | 800 | 1900-01-01 18:04:00
3 | GER | Fink | [NAME] | Märkl | Erich | D-Augsburg | Travnik/Yugoslavia | 611 | 17:44:00
4 | GER | Kuinke | Volker | Vormbäumen | Gustav | D-Jan Wellem | Derventa/Yugoslavia | 581 | 19h
5 | POL | Makne | [NAME] | [NAME] | Grzegorz | SP-BZR Polonia | Skender-Vakuf/Yugoslavia | 576 | 19h
6 | SUI | Signer | Gerold | Osterwalder | Silvan | HB-BJB Solvay | Glamoc/Yugoslavia | 571 | 19h
7 | USA | Hyde | [NAME] | [NAME] |  | D-Beldrive | Markonjicgrad/ Yugoslavia | 552 | 18h
8 | GER | Sjuts | Helma | [NAME] | Dr. [NAME] | HB-BGU | Laktasi/Yugoslavia | 532 | 19h
9 | USA | Bradley | Troy | Reinhard | [NAME] |  | Saal/Germany | 176 | 18h
10 | USA | Soukup | [NAME] | [NAME] | Mark | D-Munte |  | no start
Spreadsheet: 876442d1723122953-multi-criteria-lookup-multi-condition-lookup
Sheet: Sheet1

Order | Period | Year | % split 1 | Cost Centre 1 | % split 2 | Cost Centre 2 |  | Order Split & CC Master Table
Ord1 | 12 | 2024 |  | A |  |  |  | Order | From Year | From Period | To Year | To Period | % split | Cost Centre
Ord1 | 4 | 2025 | 1 | C |  |  |  | Ord1 | 2024 | 1 | 2024 | 12 | 1 | A
Ord2 | 3 | 2025 | 0.5 | F | 0.5 | G |  | Ord1 | 2025 | 1 |  |  | 1 | C
Ord2 | 1 | 2025 | 0.5 | D | 0.5 | E |  | Ord2 | 2022 | 1 | 2025 | 1 | 0.5 | D
 |  |  |  |  |  |  |  | Ord2 | 2022 | 1 | 2025 | 1 | 0.5 | E
 |  |  |  |  |  |  |  | Ord2 | 2025 | 2 |  |  | 0.5 | F
 |  |  |  |  |  |  |  | Ord2 | 2025 | 2 |  |  | 0.5 | G
Spreadsheet: 05d0411f-c3b5-45ea-89ad-dfa27e093ed3
Sheet: Sheet1

Day of the Week_____________________                                  Menu Organization Worksheet                                                                          Menu _______ of ________ |  |  |  |  |  |  |  |  |  |  |  |  | Fruits & Vegetables ONLY |  | All Other Items
Menu | Components, Extras, & Condiments | Portion [NAME] | CN Label | Component Contribution |  |  |  |  |  |  | Recipe/ Brand | Total # of Planned Servings | Added Fat | Added Sugar | Nutritional Info.
 |  |  | Y/N | M/MA | TG | WGR | GBD | F | V | M |  |  | Y/N | Y/N | Calories | Sat. Fat
For Additional Resources, click on the following links: |  |  |  |  | Vegetable Subgroup Worksheet
• Using the Food Buying Guide (determine component contribution)
• Using the Grain Equivalency Chart |  |  |  |  |  |  |  |  |  |  |  |  | Daily Total |  | Added Sugar | Added  Fat
• Calculating the Calories in a Recipe (Using SuperTracker) |  |  |  |  | [NAME] |  |  | Cup |  | Cup |  | Cup |  | Cup | N/A
 |  |  |  |  | Red/Orange |  |  | Cup |  | Cup |  | Cup |  | Cup
 |  |  |  |  | Beans/Peas (Legumes) |  |  | Cup |  | Cup |  | Cup |  | Cup | N/A
 |  |  |  |  | Starchy |  |  | Cup |  | Cup |  | Cup |  | Cup | N/A
 |  |  |  |  | Other |  |  | Cup |  | Cup |  | Cup |  | Cup | N/A
Spreadsheet: 58511d1258741269-if-function-to-find-no-close-to-nox_engine_sim-1-
Sheet: Sheet5

Fuel | E | C | H | O
isooctane | 224.1 | 8 | 18 | 0 |  | x(O2+3.77N2) | >>>>>> | CO2 | H20 | N2
 |  |  |  |  |  | 12.5 |  | 8 | 9 | 47.125
 |  |  |  |  |  | Enthalpy release | 5100.1
 |  |  |  |  |  | port inj heat release | 84.12536082474229
 |  |  |  |  |  | DI heat release | 85.53626834381554
Enthalpy |  |  |  |  |  | air/fuel ratio | 15.0568251453183
C02 | 393.5 |  |  |  |  | fuel cal val | 44.64685902374116 | MJ
H20 | 241.8
molecular weight |  |  |  |  |  | Fuel | E | C | H | O
O | 16 |  |  |  | 0.5 | isooctane | 112.05 | 4 | 9 | 0
N2 | 28.01 |  |  |  | 0.5 | ethyl | 117.3 | 1 | 3 | 0.5
C | 12.011
H | 1.008 |  |  |  |  | x(O2+3.77N2) | >>>>>> | CO2 | H20 | N2
 |  |  |  |  |  | 7.75 |  | 5 | 6 | 29.2175
 | Enthalpy | C | H | O
isooctane | 224.1 | 8 | 18 | 0 |  | Enthalpy release | 3188.95
methyl | 201.2 | 1 | 4 | 1 |  | port inj heat release | 83.99157173898732
ethyl | 234.6 | 2 | 6 | 1 |  | DI heat release | 86.26360992763917
hydrogen | 0 | 0 | 2 | 0 |  | air/fuel ratio | 13.3046646330052
methane | 74.831 | 1 | 4 | 0 |  | fuel cal val | 39.78677745754888 | MJ
acetylene | 226.748 | 2 | 2 | 0
[NAME] | 52.283 | 2 | 4 | 0 |  | mol weight fuel | 80.151
ethane | 84.667 | 2 | 6 | 0 |  | mol weight CO2 | 220.055
propene | 20.414 | 3 | 6 | 0 |  | CO2 per kg fuel | 2.745505358635575
propane | 103.847 | 3 | 8 | 0
butene | 1172 | 4 | 8 | 0
butane | 124.733 | 4 | 10 | 0 |  | speed | 70 | mph | time | 31.74603174603175
pentene | 20.92 | 5 | 10 | 0 |  | rpm | 1470 |  | rpm per time | 777.7777777777777
pentane | 146.44 | 5 | 12 | 0 |  | [NAME] | 400 | cc | [NAME] | 388.8888888888889
benzene | 82.927 | 6 | 6 | 0 |  | no of cyl | 4
hexene | 41.673 | 6 | 12 | 0 |  | air density | 1.21
hexane | 167.193 | 6 | 14 | 0 |  | air mass | 0.001936 | [NAME]
heptene | 62.132 | 7 | 14 | 0 |  | fuel mass | 0.0001455128748752763 | [NAME]
heptane | 187.82 | 7 | 16 | 0 |  | fuel per km | 0.05658834022927411 | [NAME]
gasoline | 140.291 | 8.26 | 15.5 | 0 |  | ratio | 1416.387186393152
 |  |  |  |  |  | C02 g per km | 155.3635913357652
Spreadsheet: 471500d1469041022-can-i-use-vlookup-to-return-multiple-values-and-then-get-average-monthly-summary
Sheet: Sheet1

Month: | 2016-07-01 00:00:00
Week 1:
Name | Grade | Goal
[NAME] | 0.38 | 0
[NAME] | 0.34 | 0.09
[NAME] | 0.3 | 0.13
Week 2:
Name | Grade | Goal
[NAME] | 0.38 | 0
[NAME] | 0.34 | 0.09
[NAME] | 0.3 | 0.13
Week 3:
Name | Grade | Goal
[NAME] | 0.38 | 0
[NAME] | 0.34 | 0.09
[NAME] | 0.3 | 0.13
Week 4:
Name | Grade | Goal
[NAME] | 0.38 | 0
[NAME] | 0.34 | 0.09
[NAME] | 0.3 | 0.13
Monthly Total
Name | Grade | Goal
[NAME]
[NAME]
[NAME]