tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 864482d1711636281-workday-and-networkday-cascading-dependencies-delivery-date-calculator
Sheet: Test

Network day with cascading dates
Task | Duration | Start date
Task A
Task B | 5
Task C | 5
Task D | 5
Task E | 1
Task F | 5
Task G | 1
Task H | 1
Delivery date | 1 | 2024-06-20 00:00:00 | Change this cell to the launch date
Networkday
Task | Duration | Start date
Task A
Task B |  | 2024-05-28 00:00:00
Task C |  | 2024-06-03 00:00:00
Task D |  | 2024-06-07 00:00:00
Task E |  | 2024-06-12 00:00:00
Task F |  | 2024-06-13 00:00:00
Task G |  | 2024-06-18 00:00:00
Task H |  | 2024-06-18 00:00:00
Delivery date | N/A | 2024-06-28 00:00:00
Workday
Task | Duration | Start date | End date
Task A | 3 | 2024-03-04 00:00:00
Task B | 5 | 2024-03-11 00:00:00
Task C | 5 | 2024-03-18 00:00:00
Task D | 5 | 2024-03-25 00:00:00
Task E | 5 | 2024-04-01 00:00:00
Task F | 5 | 2024-04-08 00:00:00
Task G | 5 | 2024-04-15 00:00:00
Task H | 5 | 2024-04-22 00:00:00
Delivery date | 1 | 2024-04-29 00:00:00
Spreadsheet: 854717d1704481744-lookup-and-find-the-in-between-days-and-return-number-of-days-20240105
Sheet: Sheet1

 |  | ID Number | Date From | Date To | Num Of Days | Days I Get | Actual Days Should Be |  | [NAME]
 |  | 26827 | 2020-06-01 00:00:00 |  |  |  | 302 | Cell D2 is without [NAME]
 |  | 26827
 |  | 26827
 |  | 26827
 |  | 26827
 |  | 26827
 |  | 26827
 |  | 30617 | 2021-10-03 00:00:00 |  |  |  | 195 | Cell D9 is without [NAME]
 |  | 30617
 |  | 30617
 |  | 30617
 |  | 30706 | 2021-09-27 00:00:00 |  |  |  | 253 | Cell D13 is without [NAME]
 |  | 30706
 |  | 30706
Spreadsheet: hunter_shively__12678__Nov_01 Volume Changes
Sheet: Nov 14

Pipeline | Producer | Deal | Zone | Current Volume | New Volume | Change | Index | GDA
ANR | Torch | 1060018 | Gath | 5 | 0 |  |  | -5
ANR | Torch | 1059865 | Gath | 6 | 3 |  | -3
ANR | Crosstex | 1131077 | Gath | 2720 | 0 |  |  | -2720
ANR | Riceland | 969604 | Gath | 4996 | 3008 |  | -1376 |  | -612
ANR | Linder | 1136014 | Tran | 4000 | 2000 |  | -400 | -1600
CGLF | Torch | 1059681 | Offshre | 838 | 400 |  | -438
CGLF | Torch | 1109813 | [NAME] | 7484 | 7000 |  |  |  | -484
CGLF | Forest | 1109818 | [NAME] | 576 | 0 |  | -576
NGPL | Juniper | 1131643 | Midcon | 2800 | 3031 |  |  | 231
SNAT | Qwest | 1139643 | [NAME] | 18500 | 20300 |  | 925 | 875
SNAT | Stone | 1054822 | Uncnstrnd WH | 4457 | 5432 |  | 975
Stry | Crosstex | 1131070 | Holly Beach | 6000 | 0 |  |  | -6000
STRY | MMS | 1103008 | Rcpts | 64892 | 64578 |  |  | -314
STRY | MMS | 1135987 | Rcpts | 6017 | 3984 |  |  | -2033
TENN | Panaco | 1135620 | Zone 500 | 950 | 800 |  |  | -150
TENN | Panaco | 1135603 | Zone 100 | 4800 | 4100 |  |  | -700
TENN | Cabot | 1138935 | Zone 500 | 10613 | 9800 |  | -813
TENN | Cabot | 1138914 | Zone 500 | 14800 | 13800 |  | -1000
TENN | Century | 1135962 | Zone 500 | 2225 | 1896 |  |  | -329
TENN | Pioneer | 1135749 | Zone 500 | 1223 | 1091 |  |  | -132
TENN | Westport | 1143232 | Zone 800 | 10000 | 10500 |  |  | 500
TENN | [NAME] | 1132292 | Zone 800 | 10000 | 2000 |  | -1200 | -6800
TGT | Unimark | 1146397 | Stx | 3140 | 1570 |  |  | -1570
TGT | [NAME] | 1143293 | WLA | 7400 | 5300 |  |  | -2100
TGT | St. Mary | 703610 | Zone Sl | 5166 | 2025 |  | -3141
TRCO | Linder | 1136009 | [NAME] | 500 | 400 |  |  | -100
TRNK | W&T | 1135937 | ELA | 6368 | 6391 |  | 23
TRNK | [NAME] | 1163926 | ELA | 2500 | 1 |  |  | -2499
TRNK | Nexen | 1131034 | ELA | 6056 | 4400 |  |  | -1656
 |  |  |  |  |  | Daily Chngs
 |  |  |  |  |  | MTD Total | -51262 | -33546
Spreadsheet: mary_fischer__25633__31P
Sheet: E1.XLS 

ENRON CORP AND CONSOLIDATED SUBSIDIARIES
COMPANY # 031P
COMPANY NAME    Limbach Holdings, Inc.
ANALYSIS OF A/R - OTHER
FOR THE 6 MONTHS ENDED 6-30-2001
PREPARED BY: Sonya City
EXTENSION:  3 9690 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E-1
 |  | 12-31-2000 Balance
 |  | BEGINNING |  | OTHER |  | 03-31-2001 |  | OTHER |  | 06-30-2001 |  | OTHER |  | 09-30-2001 |  | OTHER |  | 12-31-2001
[NAME] |  | BALANCE |  | CHANGES |  | BALANCE |  | CHANGES |  | BALANCE |  | CHANGES |  | BALANCE |  | CHANGES |  | BALANCE
 |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.)
(PROVIDE DETAIL OF INDIVDUAL ITEMS
IN EXCESS OF $200,000.)
Accts Receivables - Unconsolidated Assoc Companies:
Remap from intercompany (0051 to 0053) |  | 0 |  | 370683
Total (Hyperion line 0053)
Asset/Expense Accts:  DR/(CR)
Accts Receivables - Other:
 |  | 0
Total (Hyperion line 0060)
Asset/Expense Accts:  DR/(CR)
Asset/Expense Accts:  DR/(CR)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E-1
Spreadsheet: 83743d1283786799-24-hour-clock-calculating-total-hours-using-midnight-copy-of-noc-ot
Sheet: Sheet1

 |  |  |  |  |  |  | Name : | [NAME] |  |  | Emp No : |  | 729944455 |  |  | Period of Claim (Dates) | First Day OT Worked | Last Day OT Worked
Date | Day | Overtime Start Time | Overtime End Time |  |  |  | Monday 00:00 to  06:59 | Mon to Fri 07:00 to 23:59 | Tue to Fri 00:00 to 06:59 | Saturday 07:00 to 23:59 | Sunday 00:00 to 23:59 |  | Error Check | Gross  Value
X |  | Use 24hr clock + colons |  |  |  |  | x 2 | x 1 | x 1½ | x 1½ | x 2 |  |  | £ |  | Employee Data | Annual Salary | 18000
1st | Wed | 14:00:00 | 16:00:00 |  |  |  | 1 | 1 |  |  |  |  |  |  |  |  | Average Hrs | 42
2nd |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Average Per Hr
3rd
4th | Sat | 19:30:00 | 00:00:00 |  |  |  |  |  | 4.5 |  |  |  |  |  |  | Reason For Overtime
5th |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Reason | Hrs | Notes
6th |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Workload
7th |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sick Cover
8th |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Hol Cover | 1
9th |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Variation
10th |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Vacancy | 1
11th |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Training
12th |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Meeting
13th |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Other
14th |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total
15th
16th |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Payroll summary
17th |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x1
18th |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x1.5
19th |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x2
20th
21st |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Hours Claimed
22nd |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Gross Claim Value £
23rd
24th |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Confirmation & Authorisation (please sign)
25th
26th |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Employee sig' | …………………………….
27th |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Date | …………………………….
28th
29th |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Manager sig' | …………………………….
30th |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Manager [NAME] | …………………………….
31st |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Date | …………………………….
Spreadsheet: 217638d1362137923-list-all-items-depending-on-drop-list-value-schedule-2
Sheet: SCHEDULE

W.O.N. | Customer | Customer P/O | P/O Date | Drg No | Description | Quantity Req'd | due date | comments | Progress | Date Completed | engineer | material rqd | qty rqd | supplier | Insi PO number | Previous Material Costs | Material Cost | Turning (Hours) | Milling (Hours) | W/J (Hours) | Other (Hours) | Sub-Con (cost) | Total cost to customer | Cost per item | Unit Price on PO | Unit Cost on System | Profit/Loss (in £) per item | Action | Jobcard link | Drawing link |  | MATERIAL ORDERED | MATERIAL QUOTE REQUESTED | JOB IN PROGRESS | AT SUBCONTRACTOR
TEST | [NAME] | 23905 | 2013-02-28 00:00:00 | 5268004 | TEST TEST TEST | 3 |  | fghfgh | MATERIAL ORDERED |  | JASON | dfgdfgsd | 5 | aalco | 346346
TEST2 |  |  |  |  |  |  |  |  | MATERIAL QUOTE REQUESTED
TEST3 |  |  |  |  |  |  |  |  | MATERIAL QUOTE REQUESTED
TEST4 |  |  |  |  |  |  |  |  | AT SUBCONTRACTOR
TEST5 |  |  |  |  |  |  |  |  | MATERIAL ORDERED
TEST6 |  |  |  |  |  |  |  |  | JOB IN PROGRESS
TEST7
TEST8
TEST9
TEST10
TEST11
Spreadsheet: 758385d1638840833-return-latest-date-for-billing-robertokarto-billing-formule-
Sheet: Sheet1

INSPECTION DATE | INSPECTION VALID TILL | INSPECTION LOCATION | BUSINESS PARTNER NAME | EQUIPMENT MODEL | EQUIPMENT NUMBER | LICENSE NUMBER | STATUS | CAT | BILLING
2021-06-23 00:00:00 | 2021-07-20 00:00:00 | PITBOX | LALA | BUS | POO174 | 8566CB | PASSED | 3 | YES
2021-07-17 00:00:00 | 2021-08-14 00:00:00 | PITBOX | LALA | BUS | POO174 | 8566CB | FAILED | 3 | YES
2021-07-18 00:00:00 | 2021-08-15 00:00:00 | PITBOX | LALA | BUS | POO174 | 8566CB | PASSED | 3 | NO
2021-08-14 00:00:00 | 2021-09-11 00:00:00 | AA AUTO SERVICE | LALA | BUS | POO174 | 8566CB | PASSED | 3 | YES
2021-11-18 00:00:00 | 2022-02-10 00:00:00 | NV ATHENA | FERNANDES | D-MAX | POO1233 | 0179KV | PASSED | 2 | YES
2021-11-18 00:00:00 | 2022-02-10 00:00:00 | NV ATHENA | FERNANDES | AMAROK | POO1234 | 3071JV | PASSED | 2 | YES
2021-11-18 00:00:00 | 2022-02-10 00:00:00 | NV ATHENA | MAJOR DRILLING | D-MAX | POO1235 | 0771KV | PASSED | 2 | YES
2021-11-19 00:00:00 | 2022-02-11 00:00:00 | NV ATHENA | TRAVERCO | [NAME] | POO1236 | 2244HV | PASSED | 2 | YES
2021-11-19 00:00:00 | 2022-02-11 00:00:00 | NV ATHENA | VMS | CARAVAN | POO1237 | 8251CB | PASSED | 4 | YES
2021-11-22 00:00:00 | 2021-12-19 00:00:00 | NV ATHENA | ZAYED | ROSA | POO1238 | 7306CB | PASSED | 3 | YES
2021-11-22 00:00:00 | 2021-12-19 00:00:00 | NV ATHENA | ZAYED | ROSA | [NAME] | 8067CB | PASSED | 3 | YES
2021-11-24 00:00:00 | 2022-02-16 00:00:00 | NV ATHENA | MAJOR DRILLING | RANGER | POO1240 | 7789JV | PASSED | 2 | YES
Spreadsheet: 156277d1337250045-vlookup-with-2-criteria-if-experiment
Sheet: Sheet1

 |  |  |  |  | Customer Name | Particular | Type of Item
 |  |  |  |  | [NAME] | Dress |  |  |  |  |  |  |  |  |  | Dress | Clothings
 |  |  |  |  | Nike | Eraser |  |  |  |  |  |  |  |  |  | Tee | Clothings
 |  |  |  |  | [NAME] | Dress |  |  |  |  |  |  |  |  |  | Shoes | Clothings
 |  |  |  |  | [NAME] | Pencil |  |  |  |  |  |  |  |  |  | Pencil | Stationeries
 |  |  |  |  | [NAME] | Dress |  |  |  |  |  |  |  |  |  | Eraser | Stationeries
 |  |  |  |  | Hulk | Eraser |  |  |  |  |  |  |  |  |  | Acrylic | Stationeries
 |  |  |  |  | [NAME] | Tee
 |  |  |  |  | Greta | Acrylic
 |  |  |  |  | Sven | Dress
 |  |  |  |  | Using IF function labelled the type of item wrongly
Spreadsheet: 455275d1460216633-identical-text-strings-return-false-when-compared-matching-text
Sheet: Sheet1

 |  | [NAME] Anhima cornuta | Horned Screamer Anhima cornuta
 | 1
Spreadsheet: 194490d1353199114-removing-lowest-and-highest-values-and-supress-hide-or-remove-div-0-error-in-updated-score-board-4-final-1
Sheet: Sheet1

 | Round#1
 |  |  |  | White |  |  |  |  |  |  |  | Blue
 |  |  |  | [NAME] |  |  |  |  |  |  |  | [NAME]
 | Heat Total Points |  |  |  |  |  |  |  | Heat Total Points
 | Wave | Judge 1 | Judge 2 | Judge 3 | Judge 4 | Judge 5 | Average Points |  | Wave | Judge 1 | Judge 2 | Judge 3 | Judge 4 | Judge 5 | Average Points
 | 1 |  |  |  |  |  |  |  | 1
 | 2 |  |  |  |  |  |  |  | 2
 | 3 |  |  |  |  |  |  |  | 3
 | 4 |  |  |  |  |  |  |  | 4
 | 5 |  |  |  |  |  |  |  | 5
 | 6 |  |  |  |  |  |  |  | 6
 | 7 |  |  |  |  |  |  |  | 7
 | 8 |  |  |  |  |  |  |  | 8
 | 9 |  |  |  |  |  |  |  | 9
 | 10 |  |  |  |  |  |  |  | 10
 |  |  |  | Yellow |  |  |  |  |  |  |  | Green
 |  |  |  | [NAME] |  |  |  |  |  |  |  | [NAME]
 | Heat Total Points |  |  |  |  |  |  |  | Heat Total Points
 | Wave | Judge 1 | Judge 2 | Judge 3 | Judge 4 | Judge 5 | Average Points |  | Wave | Judge 1 | Judge 2 | Judge 3 | Judge 4 | Judge 5 | Average Points
 | 1 | 2 | 2 |  |  |  |  |  | 1
 | 2 |  |  |  |  |  |  |  | 2
 | 3 |  |  |  |  |  |  |  | 3
 | 4 |  |  |  |  |  |  |  | 4
 | 5 |  |  |  |  |  |  |  | 5
 | 6 |  |  |  |  |  |  |  | 6
 | 7 |  |  |  |  |  |  |  | 7
 | 8 |  |  |  |  |  |  |  | 8
 | 9 |  |  |  |  |  |  |  | 9
 | 10 |  |  |  |  |  |  |  | 10
Spreadsheet: 49965d1249389876-macro-to-print-a-pdf-file-using-pdf-writer-to-a-network-folder-book1
Sheet: Sheet1

 | d | d | d
 | d | d | d
 | d | d | d
 | d | d | d
 | d | d | d
 | d | d | d
 | Application.DisplayAlerts = False
 | Workbooks.Open Filename:= _
 | "\\gd1002ds0003\users$\CS64627\03 - Security inc UAP & ITAR\03 - ITAR & UAP\03 - ITAR & UAP Database\ITAR + UAP Register.xls"
Spreadsheet: phillip_allen__29521__jan_demand
Sheet: actual x gd

 |  |  |  |  | Fuel | 0.0485
 |  |  |  |  | usage
 |  |  |  |  | sj | 0.0166
 |  |  |  |  | permian | 0.0341
 |  |  |  |  | aca | 0.0022
 | Actual Flows |  |  |  | 9L7J-Block 1 (SJ-Socal) |  |  |  |  | 9L7H-Block 2 (Permian-Socal) |  |  |  |  | Gas Daily Prices
 | 9L7J | 9L7H | 9L7K |  | Market | Variable | Net | Dollars |  | Market | Variable | Net | Dollars
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | sj | perm | socal
1 | 231936 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  | 2.145 | 2.15 | 2.37
2 | 237169 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  | 2.145 | 2.15 | 2.37
3 | 175649 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  | 2.145 | 2.15 | 2.37
4 | 221689 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  | 2.185 | 2.165 | 2.375
5 | 236525 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  | 2.155 | 2.135 | 2.3
6 | 232131 | 40000 | 0 |  |  |  |  |  |  |  |  |  |  |  | 2.2 | 2.19 | 2.36
7 | 282227 | 45000 | 0 |  |  |  |  |  |  |  |  |  |  |  | 2.165 | 2.16 | 2.345
8 | 228960 | 163476 | 0 |  |  |  |  |  |  |  |  |  |  |  | 2.145 | 2.14 | 2.33
9 | 242102 | 134312 | 0 |  |  |  |  |  |  |  |  |  |  |  | 2.145 | 2.14 | 2.33
10 | 241606 | 144999 | 0 |  |  |  |  |  |  |  |  |  |  |  | 2.145 | 2.14 | 2.33
11 | 314418 | 122370 | 0 |  |  |  |  |  |  |  |  |  |  |  | 2.16 | 2.15 | 2.35
12 | 255598 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  | 2.155 | 2.155 | 2.38
13 | 210757 | 7298 | 0 |  |  |  |  |  |  |  |  |  |  |  | 2.125 | 2.135 | 2.39
14 | 240233 | 21273 | 0 |  |  |  |  |  |  |  |  |  |  |  | 2.125 | 2.145 | 2.385
15 | 230131 | 9705 | 0 |  |  |  |  |  |  |  |  |  |  |  | 2.13 | 2.15 | 2.375
16 | 224685 | 9705 | 0 |  |  |  |  |  |  |  |  |  |  |  | 2.13 | 2.15 | 2.375
17 | 210093 | 9705 | 0 |  |  |  |  |  |  |  |  |  |  |  | 2.13 | 2.15 | 2.375
18 | 218989 | 4948 | 0 |  |  |  |  |  |  |  |  |  |  |  | 2.13 | 2.15 | 2.375
19 | 259713 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  | 2.195 | 2.205 | 2.395
20 | 251679 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  | 2.24 | 2.26 | 2.405
21 | 274186 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  | 2.345 | 2.38 | 2.505
22 | 214124 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  | 2.37 | 2.39 | 2.515
23 | 213729 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  | 2.37 | 2.39 | 2.515
24 | 236684 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  | 2.37 | 2.39 | 2.515
25 | 264938 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  | 2.335 | 2.375 | 2.5
26 | 196100 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  | 2.42 | 2.45 | 2.545
27 | 182937 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  | 2.465 | 2.52 | 2.58
28 | 144157 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  | 2.415 | 2.47 | 2.51
29 | 95069 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  | 2.485 | 2.565 | 2.555
30 | 87050 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  | 2.485 | 2.565 | 2.555
31 | 102584 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  | 2.485 | 2.565 | 2.555
Spreadsheet: 806118d1669116232-suming-dynamic-array-off-column-numbers-based-of-criteria-sum-for-dynamic-number-of-columns
Sheet: Sheet1

 | 2022-04-01 00:00:00
Month Days
Stock | 2439 | 4698 | 5085 | 9629 | 9561 | 5983 | 1935 | 6451 | 2050 | 2693 | 9668 | 2349
Average Days Holding | 58 | 52 | 58 | 100 | 31 | 26 | 40 | 36 | 21 | 78 | 6 | 127
Average Stock value |  |  |  |  |  |  |  |  |  |  |  |  |  | Automate this row so consistent formula in all columns
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Logic:
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1) Sum stock columns that cover columns where the month days are equal to average holding days or 1 month greater if an array
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2) Multiply 1 * 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 3) Divide average days for that month by sum of month days for the columns that are equal to average days or closest number of months days greater than average holding days
Spreadsheet: 683638d1592858909-formula-that-returns-a-value-under-specific-conditions-region-issue
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
Spreadsheet: 678119d1589725854-and-or-functions-to-auto-fill-rates-depending-the-date-given-2020-05-17-oeldere-andalex-678115d1589723109-and-or-functions-to-auto-fill-rates-depending-t
Sheet: Rates

Check in | 2020-05-12 00:00:00 |  | Check Out | 2020-06-02 00:00:00 |  | Nights |  |  | HAPPY ROOM |  | CONTRACT RATE
 |  |  |  |  |  |  |  |  |  |  | ROOM TYPE | LOW SEASON |  | MIDDLE SEASON |  | HIGH SEASON |  | PEAK SEASON
 |  |  |  |  |  |  |  |  |  |  |  | 2020-05-11 00:00:00 | 2020-05-31 00:00:00 | 2020-06-01 00:00:00 | 2020-06-14 00:00:00 | 2020-06-15 00:00:00 | 2020-07-05 00:00:00 | 2020-07-06 00:00:00 | 2020-08-25 00:00:00
2020-05-12 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2020-09-28 00:00:00 | 2020-10-11 00:00:00 | 2020-09-14 00:00:00 | 2020-09-27 00:00:00 | 2020-08-26 00:00:00 | 2020-09-13 00:00:00 | 2020-07-06 00:00:00 | 2020-08-25 00:00:00
2020-05-13 00:00:00 |  |  |  |  |  |  |  |  |  |  | HAPPY ROOM | 95 |  | 130 |  | 165 |  | 240
2020-05-14 00:00:00 |  |  |  |  |  |  |  |  |  |  | STANDARD DBL | 105 |  | 145 |  | 185 |  | 285
2020-05-15 00:00:00 |  |  |  |  |  |  |  |  |  |  | SUPERIOR | 115 |  | 160 |  | 200 |  | 340
2020-05-16 00:00:00 |  |  |  |  |  |  |  |  |  |  | JUNIOR SUITE | 135 |  | 190 |  | 230 |  | 410
2020-05-17 00:00:00 |  |  |  |  |  |  |  |  |  |  | DELUXE | 150 |  | 220 |  | 260 |  | 475
2020-05-18 00:00:00 |  |  |  |  |  |  |  |  |  |  | FAMILY | 170 |  | 240 |  | 310 |  | 520
2020-05-19 00:00:00 |  |  |  |  |  |  |  |  |  |  | SUPERIOR SUITE | 250 |  | 340 |  | 410 |  | 690
2020-05-20 00:00:00 |  |  |  |  |  |  |  |  |  |  | MASTER SUITE | 280 |  | 410 |  | 500 |  | 790
2020-05-21 00:00:00
2020-05-22 00:00:00
2020-05-23 00:00:00
2020-05-24 00:00:00 |  |  |  |  |  |  |  |  |  |  | Room | 2020-05-11 00:00:00 | 2020-06-01 00:00:00 | 2020-06-15 00:00:00 | 2020-07-06 00:00:00 | 2020-08-26 00:00:00 | 2020-09-14 00:00:00 | 2020-09-28 00:00:00 | 2020-10-11 00:00:00
2020-05-25 00:00:00 |  |  |  |  |  |  |  |  |  |  | HAPPY ROOM | 95 | 130 | 165 | 240 | 165 | 130 | 95
2020-05-26 00:00:00 |  |  |  |  |  |  |  |  |  |  | STANDARD DBL | 105 | 145 | 185 | 285 | 185 | 145 | 105
2020-05-27 00:00:00 |  |  |  |  |  |  |  |  |  |  | SUPERIOR | 115 | 160 | 200 | 340 | 200 | 160 | 115
2020-05-28 00:00:00 |  |  |  |  |  |  |  |  |  |  | JUNIOR SUITE | 135 | 190 | 230 | 410 | 230 | 190 | 135
2020-05-29 00:00:00 |  |  |  |  |  |  |  |  |  |  | DELUXE | 150 | 220 | 260 | 475 | 260 | 220 | 150
2020-05-30 00:00:00 |  |  |  |  |  |  |  |  |  |  | FAMILY | 170 | 240 | 310 | 520 | 310 | 240 | 170
2020-05-31 00:00:00 |  |  |  |  |  |  |  |  |  |  | SUPERIOR SUITE | 250 | 340 | 410 | 690 | 410 | 340 | 250
2020-06-01 00:00:00 |  |  |  |  |  |  |  |  |  |  | MASTER SUITE | 280 | 410 | 500 | 790 | 500 | 410 | 280
2020-06-02 00:00:00
Spreadsheet: 397ddd1c-3c85-464f-bce6-6880a859b6a6
Sheet: Sheet1

10 | 20 | 30 | 40 | 50 | 60 | 70 | 80 | 90 | 100
R 0 | 0 | 9 | 0 | 0 | 18 | 6 | 14 | -19 | 50 | R GAIN | 14
G -34 | -42 | -27 | -34 | -31 | -20 | -20 | -21 | -32 | -31 | G GAIN | 0
B -50 | -43 | -43 | -45 | -42 | -31 | -32 | -35 | -39 | -50 | B GAIN | -11
CMS HUE | HUE NIGHT | CMS SAT | SAT NIGHT | CMS VAL | VAL NIGHT
R -3 | -3 | R 30 | 30 | R -30 | -30
Y 8 | 8 | Y -9 | -15 | Y 9 | 9
G 2 | 2 | G 18 | 18 | G 8 | 8
C -15 | -15 | C 0 | 0 | C 0 | 0
B 0 | 0 | B 0 | 0 | B 0 | 0
M 9 | 12 | M 30 | 6 | M -16 | -16
Spreadsheet: e1bd90a3-97bf-48c3-95d3-bf5cc2ab4ac7
Sheet: 18

Uke: | 18 |  |  |  |  | Navn:
 |  | Mandag |  | Tirsdag |  | Onsdag |  | Torsdag |  | Fredag |  | Lørdag |  | Søndag |  | Sum
Kvalitet | Form | Plan | ok | Plan | ok | Plan | ok | Plan | ok | Plan | ok | Plan | ok | Plan | ok | Plan | Trent | Diff. | Feedback
Aerob | Kontinuerlig
 | Intervall
Anaerob | Lokalt
 | Generell
Maks.styrke | Sub.maks.
 | Tungt
 | Eksplosivt
Uth.styrke | Sirkel
 | Tungt
Spenst
Hurtighet
Koordinasjon
Bevegelighet
[NAME]
 | Sum
AKKUMULERT
Kvalitet | Form | Plan |  | Trent
Aerob | Kontinuerlig
 | Intervall
Anaerob | Lokalt
 | Generell
Maks.styrke | Sub.maks.
 | Tungt
 | Eksplosivt
Uth.styrke | Sirkel
 | Tungt
Spenst
Hurtighet
Koordinasjon
Bevegelighet
[NAME]
 | Sum
Spreadsheet: 18016723-1ad0-47b0-b573-2b9dce0dbc53
Sheet: PVA Calculation

Present Value Calculation
Present Value For This Offer
All amounts shown as Rate per USF
 | Shell | Op Cost | Op Cost |  | Lessor | [NAME] | Overtime | Structured | Surface | Total | Annual | Free Rent | Annual Less | Commission
Year | Rental | (in Lease) | ([NAME]) | TI | TI OH | Amort Cap | Utilities | Parking | Parking | Rate psf | Rent | Value | Free Rent | Credit | Less Credit
1
Spreadsheet: 145878d1331794236-transfer-data-from-one-sheet-to-another-when-specific-value-entered-in-first-sheet-example_2012_file-1-
Sheet: Jan

Reporter | Date Rec. | Date Comp. | Witness | Description | Pages Rec | Pages Rtn | Job Type | Rate | Total | Tithe Amount | Tithed | Invoice # | Invoice Date | Date Paid | Monthly Tithe | Tithed MTD | Left to Tithe | Invoiced Total | Amount Received | Total By Reporter | Amount Due | Amount Received
[NAME] | 2012-01-11 00:00:00 | 2012-01-12 00:00:00 |  |  | 154 | 154 | Overnight | 1.75 |  |  | X | 007-14 | 2012-01-17 00:00:00 | 2012-02-06 00:00:00 |  |  |  |  |  | Jeanne
Jeanne | 2012-01-19 00:00:00 | 2012-01-23 00:00:00 |  |  | 39 | 39 | Regular | 1.3 |  |  | X | 001-13 | 2012-02-08 00:00:00 | 2012-02-26 00:00:00 |  |  |  |  |  | [NAME]
[NAME] | 2012-01-31 00:00:00 | 2012-02-01 00:00:00 |  |  | 58 | 58 | Regular | 0.85 |  |  |  | 007-15 | 2012-02-08 00:00:00 | 2012-03-04 00:00:00 |  |  |  |  |  | Karisa
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
Spreadsheet: 755337d1636797081-how-to-look-up-with-multiple-criteria-october-2021-stitching-bill
Sheet: BIRJU PAYMENT

 | TOTAL PCS |  | TOTAL AMOUNT
TYPE |  | PCS | PRICE | AMOUNT