tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 63299013-adaa-4bbb-ad25-cbb37e18b6a6
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
PSAFT | Test | PSAFT | Prostate-Specific Antigen (PSA), Total and Free, Serum | PSA Total and Free, S | Electrochemiluminescent Immunoassay (ECLIA) | Serum Gel Tube: SGT |  |  | 1 | mL | Collection Container/Tube:  Preferred: Red top Acceptable: Serum gel Submission Container/Tube: Plastic vial [NAME]: 1 mL Collection Instructions: Spin down within 3 hours of draw and separate serum from cells. Additional Information: 1. Free PSA can only be added on within 12 hours of performing total PSA. [NAME] must have been shipped frozen. 2. Include patient's age. | 0.5 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm reject; Cold <2 hours OK  Lipemia	Mild OK; [NAME] OK Icterus	NA Other	NA | TOTAL PSA Males: Age (Years)	PSA Upper Limit (ng/mL) <40	< or =2.0 40-49	< or =2.5 50-59	< or =3.5 60-69	< or =4.5 70-79	< or =6.5 > or =80	< or =7.2  Females: not applicable   FREE PSA Males: When total PSA is in the range of 4.0-10.0 ng/mL, a free:total PSA ratio < or =0.10 indicates 49% to 65% risk of prostate cancer depending on age; a free:total PSA ratio >0.25 indicates a 9% to 16% risk of prostate cancer, depending on age. Females: not applicable | Monday through Friday; 5 a.m.-12 a.m., Saturday; 6 a.m.-6 p.m. | 1 day | 3 days |  | Profile |  |  |  |  | Rochester
PSAFT | [NAME] | SERUM | Serum |  |  |  | Frozen | 90 days
PSAFT | Result | TPSA | Total PSA | Total PSA | Numeric |  |  |  |  | ng/mL |  |  |  |  |  |  |  |  |  | 2857-1
PSAFT | Result | FPSA | Free PSA | Free PSA | Numeric |  |  |  |  | ng/mL |  |  |  |  |  |  |  |  |  | 10886-0
PSAFT | Result | PSA_R | Free PSA/PSA Ratio | Free PSA/PSA Ratio | Numeric |  |  |  |  | ratio |  |  |  |  |  |  |  |  |  | 12841-3
PSAFT | Billing Component | PSAFT |  | PSA, Free |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 84154
PSAFT | Billing Component | PSAFT |  | PSA, Total |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 84153
Spreadsheet: 34425d1231709401-return-a-value-if-2-other-criteria-match-lookhere
Sheet: Starts Jan

 | [NAME] |  |  |  |  |  |  |  |  |  | EXIT NOTIFICATIONS SENT |  | JOB OUTCOMES
 | Customer Name | NiNo. | Referral Source | Int. | Provider / Venue | Input on Adept | Start Date | Status | Caseworker | Errors | Customer Name | Caseworker | Customer Name | Exit Form Sent | Active | Last Date On Provision | Caseworker
 | [NAME] | JJ123456K | Yonder | 6 | Learners Direct | y | 2009-01-25 00:00:00 | 2009-01-26 00:00:00 | Fred
Spreadsheet: 268536d1380672579-if-a2-blank-then-copy-information-to-another-sheet-alex-headcount-example
Sheet: Gasifier Absent

EMPLOYEE NAME | CRAFT | TIMESHEET | DATE: | ABSENT/LATE/EARLY | TIME: | REASON:
Spreadsheet: 788087d1658259110-implementing-a-few-restrictions-on-a-calendar-excel-shared-prototype-1
Sheet: May

 | Absence Type Key | V | Vacation |  |  | P | Personal |  |  | S | Sick |  |  | Custom 1 |  |  |  | Custom 2
 | May | Dates of Absence
 | Employee Name | 1 | 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 | 31 | Total Days
 | Employee 1
 | Employee 2
 | Employee 3
 | Employee 4
 | Employee 5
Spreadsheet: 821064d1678424609-need-a-formula-to-count-down-hours-worked-vs-next-pay-increase-on-excel-timesheet-beamer2
Sheet: Mar 1-15

[NAME]
 |  | 330 | STS-Thomas |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Pay Period 6
 |  |  |  |  |  |  |  |  |  |  |  |  | Next Step | Next Step | Next Step | Next Step | Next Step | Next Step | Next Step | Next Step | Running Total | March 1 - 15
 |  |  |  |  |  |  |  |  |  |  |  | Next Step | 100 | 200 | 300 | 400 | 500 | 600 | 700 | 800 |  | 2023
 |  |  |  |  |  |  |  |  |  |  |  | Hours Remaining
 |  |  |  | REG | COMP USED | SICK | VAC | HOL USED | WORK HOL | WORK HOL OT | OT | Built in OT |  | EARN COMP | OTHER |  | OT Premium | COACH | TRAINER | COACH OT | TRAINER OT
 | JAB | Thur | 1 | 12
 | sns | Fri | 2 | 10 |  |  |  |  |  |  |  | 2
 | JAB | Sat | 3 | Off
 | JAB | Sat | 3 | Off
 | JAB | Sun | 4 | Off
 | JAB | Mon | 5 | Holiday |  |  |  |  |  | 6
 | JAB | Tue | 6 | Off |  |  |  |  |  |  | 14
 | JAB | Wed | 7 | 12
 | JAB | Thur | 8 | 12
 | JAB | Fri | 9 | 12
 | JAB | Sat | 10 | 4 |  |  |  |  |  |  |  | 2
 | JAB | Sat | 10 | 6
 | DLE | Sun | 11 | Off
 | DLE | Mon | 12 | Off |  |  |  |  |  |  | 12
 | DLE | Tue | 13 | Off |  |  |  |  |  |  | 12
 |  | Tue
 |  | TOTALS
 |  |  |  | REG | COMP USED | SICK | VAC | HOL USED | WORK HOL | WORK HOL OT | OT | Built in OT |  | EARN COMP | OTHER | DAILY TOTAL | OT Premium | COACH | TRAINER | COACH OT | TRAINER OT
 |  |  | reg hours forward |  |  |  |  |  |  |  |  |  |  |  |  |  | 50% | 3% | 9%
 |  |  | available leave
 |  |  | I certify that the foregoing payroll is just, true and correct; that the person whose name appears [NAME]
 |  |  | actually worked or was on authorized leave as shown; and that the salaries are due and unpaid.
 |  | EMPLOYEE SIGNATURE |  |  |  |  |  |  |  |  | DATE |  |  |  |  | AUTHORIZING SIGNATURE |  |  |  |  |  | DATE
Spreadsheet: craig_dean__4368__1-23act
Sheet: Economics

 | Commodity Revenue (Cost) | Demand Charge | Total | Total Volume | $/Mwhr Commodity Cost | $/Mwhr Total Cost
Purchases
[NAME]. Cost Est. |  |  |  |  | 20 | 0
Incremental Purchases
[NAME]
4C Balancing
4C Realtime
[NAME]
PV Balancing
PV Realtime
SPS Pre
Artesia Balancing
Artesia Realtime
Sales
Incremental Sales
[NAME]
4C Balancing
4C Realtime
[NAME]
PV Balancing
PV Realtime
[NAME]
Artesia Balancing
Artesia Realtime
 |  |  |  |  |  |  | Heat | Fuel
Generation |  |  |  |  |  |  | Rate | Cost
4 Corners Unit 4 |  |  |  |  |  |  | 10.0576 | 1.3
4 Corners Unit 5 |  |  |  |  |  |  | 10.0576 | 1.3
PV Unit 1 |  |  |  |  |  |  | 10.16 | 0.6
PV Unit 2 |  |  |  |  |  |  | 10.16 | 0.6
PV Unit 3 |  |  |  |  |  |  | 10.16 | 0.6
Newman 1
Newman 2 |  |  |  |  |  |  |  | 1.96
Newman 3
GT 1
GT 2
GT1+ST1
GT2+ST1
Newman 4 |  |  |  |  |  |  |  | 1.96
Copper
Rio Grande 6
Rio Grande 7
Rio Grande 8
Total
Spreadsheet: 677997d1589648005-have-a-list-generate-a-list-generate-a-list-from-a-list-tora-v1-
Sheet: Blad1

Car Brands: |  | Models:
Volvo |  | XC60 |  |  |  |  |  |  |  |  |  | Volvo | Saab | Jeep | VW
 |  |  |  |  |  |  |  |  |  |  |  | C30 | Saab 900 | [NAME] | Golf
 |  |  |  |  |  |  |  |  |  |  |  | V70 | Saab 9-3 | Grand Cherokee | Tiguan
 |  |  |  |  |  |  |  |  |  |  |  | XC60 | Saab 600 | Commander | Polo
Spreadsheet: 859615d1707937386-printing-out-choosen-rows-book1
Sheet: Sheet1

Road | Town | Select
BROTTON ROAD | CARLIN HOW
BROTTON ROAD FROM RAILWAY BRIDGE TO SKELTON BYPASS | NORTH SKELTON | 2
BROUGH HOUSE FARM ACCESS ROAD | SALTBURN BY THE SEA
BROUGHTON GREEN | REDCAR
BROXA CLOSE | REDCAR
BRUNEL ROAD | SOUTH BANK
BRUNSWICK AVENUE | TEESVILLE
BRYONY COURT | GUISBOROUGH
BUCCLEUCH CLOSE | GUISBOROUGH
BUCKFAST ROAD | SKELTON-IN-CLEVELAND | 3
BUCKINGHAM DRIVE | NORMANBY
BUCKINGHAM ROAD | REDCAR
BULMER COURT | NORMANBY
BULMERS BUILDINGS BACK STREET | GUISBOROUGH
[NAME] | SKELTON-IN-CLEVELAND | 1
BURNHAM GARDENS | NORMANBY
Spreadsheet: 735022d1622647234-merging-multiple-sheets-with-same-header-format-into-single-sheet-aggrigated-code-sheet
Sheet: BERG

Discipline | BERG
Disciplinecode | Discipline - Region - gemeente - gebruiker
421101 | BERG - Groningen - Dorkwerd - Platvoet
421102 | BERG - Groningen - Gemeente - Groningen
421103 | BERG - Groningen - Gemeente - Hurigariep
421104 | BERG - Groningen - Garnwerd - Rietdiep
621101 | BERG - Drenthe - Dorkwerd - Platvoet
621102 | BERG - Drenthe - Gemeente - Drenthe
621103 | BERG - Drenthe - Gemeente - Hurigariep
621106 | BERG - Drenthe - Garnwerd - Rietdiep
1121101 | BERG - Noord-Holland - Dorkwerd - Platvoet
1121102 | BERG - Noord-Holland - Gemeente - Noord-Holland
1121103 | BERG - Noord-Holland - Gemeente - Hurigariep
1121101 | BERG - Noord-Holland - Dorkwerd - Platvoet
1321101 | BERG - Amsterdam - Dorkwerd - Platvoet
1321102 | BERG - Amsterdam - Gemeente - Amsterdam
1321103 | BERG - Amsterdam - Gemeente - Hurigariep
1321113 | BERG - Amsterdam - Dorkwerd - Platvoet
Spreadsheet: 753619d1635572497-text-into-columns-by-formual-deal-sheet-template-form
Sheet: Sheet1

1.  (10737845) Mushroom can ([PHONE]) | 10737845 | Mushroom can | 6007483000408
2. (10242357) [NAME] str Off  ([PHONE])
3. (10242359) Sweet & sour ([PHONE])
4. (10242361) chicken [NAME] ([PHONE])
5. (10242364) cream mushroom ([PHONE])
6.  (10242362) country cast ([PHONE])
7.  (10242353) sweet & spicy  ([PHONE])
8. (10470582) honey mustered ( [PHONE])
9. (10242374) Rogan Josh ([PHONE])
10. (10483841) Tikka ([PHONE])
11. (10247546) Green Thai ([PHONE])
12. (10242378) Butter chicken ([PHONE])
13. (10242379) [NAME] ([PHONE])
14. (10242379) [NAME] ([PHONE])
15. (10186117) M/Rm garly & herb  ([PHONE])
16. (10247544) Bologanise ([PHONE])
17. (10455221) Mac & Cheese ([PHONE])
18. (10186116) tomato & basil ([PHONE])
19. (10647012) [NAME] ([PHONE])
Spreadsheet: 92097d1291757360-activity-vs-time-graph-activity-and-time-data
Sheet: Sheet1

 | Week 1 |  |  | Week 2 |  |  |  | Week 3
 | Minutes Before Class | Number of Activities |  | Minutes Before Class | Number of Activities |  |  | Minutes Before Class | Number of Activities
Monday | 30 | 2 |  | 45 | 3 |  |  | 45 | 3
Tuesday | 10 | 1 |  | 45 | 3 |  |  | 60 | 4
Wednesday | 20 | 1 |  | 60 | 4 |  |  | 60 | 4
Thursday | 60 | 4 |  | 60 | 4 |  |  | 60 | 4
Friday | 30 | 2 |  | 30 | 2 |  |  | 30 | 2
 | Week 4 |  |  | Week 5 |  |  |  | Week 6
 | Minutes Before Class | Number of Activities |  | Minutes Before Class | Number of Activities |  |  | Minutes Before Class | Number of Activities
Monday | 45 | 3 |  | 90 | 4 |  |  | 90 | 4
Tuesday | 60 | 4 |  | 60 | 4 |  |  | 60 | 4
Wednesday | 60 | 4 |  | 60 | 4 |  |  | 60 | 4
Thursday | 60 | 4 |  | 60 | 4 |  |  | 60 | 4
Friday | 60 | 4 |  | 45 | 2 |  |  | 45 | 2
Spreadsheet: 85976d1285953186-creating-a-formula-that-uses-text-in-another-cell-cash-deposits-and-orders-sample-2-
Sheet: Chart

 | $100's | $20's |  |  | $100's | $20's
10-01-10
09-30-10
09-29-10
09-28-10
09-27-10
09-26-10
09-25-10
09-24-10
09-23-10
09-22-10
09-21-10
09-20-10
09-19-10
09-18-10
09-17-10
09-16-10
09-15-10
09-14-10
09-13-10
09-12-10
Spreadsheet: 328553d1403944579-matching-the-values-between-two-columns-match_values-2
Sheet: Sheet1

Column 1 | Column 2 | All Matching values | Non Matching values From A & B Columns |  | All Matching values | Non Matching values From A & B Columns
1112333 | 1111111 |  |  |  | 1112333 | 1111111 | <--- EXAMPLES OF WHAT THE RESULT SHOULD BE
1121233 | 1111333 |  |  |  | 1123333 | 1111333
1121333 | 1112333 |  |  |  | 1133333 | 1113333
1122333 | 1113333 |  |  |  | 1233333 | 1121233
1123333 | 1122311 |  |  |  | 1333211 | 1121333
1133333 | 1123333 |  |  |  | 1333311 | 1122311
1232333 | 1133333 |  |  |  | 1333331 | 1122333
1233333 | 1232121 |  |  |  | 1333332 | 1232121
1333111 | 1232311 |  |  |  | 1333333 | 1232311
1333211 | 1233321 |  |  |  |  | 1232333
1333311 | 1233333 |  |  |  |  | 1233321
1333331 | 1333211 |  |  |  |  | 1333111
1333332 | 1333311 |  |  |  |  | 1333321
1333333 | 1333321
2111333 | 1333331 |  |  |  | Non matching list from A and then from B
2112333 | 1333332
2113333 | 1333333
2122333 | 2111211
2123333 | 2111223
2212121 | 2111333
2212123 | 2112311
2212221 | 2112322
2212233 | 2112333
2212333 | 2113333
2213333 | 2121323
2222121 | 2122311
2222123 | 2122333
2222133 | 2123311
2222221 | 2123333
2222223 | 2212111
2222233 | 2212123
2222333 | 2212133
2223332 | 2212211
2223333 | 2212221
2232111 | 2212223
2232211 | 2212233
2232333 | 2212321
2233331 | 2212333
2233333 | 2213333
2323111 | 2222111
2323331 | 2222211
2323333 | 2222221
2332111 | 2222311
2332211 | 2222321
2333211 | 2223311
2333221 | 2223331
2333231 | 2223333
2333233 | 2232111
2333311 | 2232121
2333321 | 2232123
2333331 | 2233311
2333332 | 2233321
2333333 | 2233333
3111211 | 2322121
3111233 | 2322221
3111311 | 2323133
3111323 | 2323231
3111333 | 2323233
3113333 | 2323321
3212121 | 2323333
3212123 | 2332111
3212133 | 2332121
3212211 | 2332221
3212221 | 2333111
3212223 | 2333121
3212233 | 2333211
3212311 | 2333221
3212321 | 2333231
3212333 | 2333232
3213333 | 2333233
3222233 | 2333311
3223333 | 2333321
3312111 | 2333331
3312233 | 2333332
3313331 | 2333333
3313333 | 3111333
3322121 | 3112333
3322221 | 3113333
3322233 | 3211233
3323111 | 3212121
3323121 | 3212123
3323133 | 3212133
3323221 | 3212223
3323231 | 3212233
3323233 | 3212321
3323321 | 3212322
3323331 | 3212333
3323332 | 3213321
3323333 | 3213333
3332121 | 3222133
3332133 | 3222221
3332221 | 3222233
3333111 | 3223333
3333121 | 3312111
3333132 | 3312121
3333133 | 3312221
3333211 | 3312233
3333221 | 3313321
3333231 | 3313331
3333233 | 3313333
3333311 | 3322111
3333321 | 3322121
3333331 | 3322122
3333332 | 3322133
3333333 | 3322211
 | 3322233
 | 3323133
 | 3323211
 | 3323221
 | 3323231
 | 3323233
 | 3323311
 | 3323321
 | 3323331
 | 3323332
 | 3323333
 | 3332211
 | 3332221
 | 3332233
 | 3333111
 | 3333121
 | 3333211
 | 3333221
 | 3333231
 | 3333232
 | 3333233
 | 3333311
 | 3333321
 | 3333331
 | 3333332
 | 3333333
Spreadsheet: 85e8690f-ed1e-4007-9fff-f1cbd3c9b681
Sheet: Sheet1

Table S3. Amino-acid changes observed in the structural genes among [NAME], [NAME] and Indian Ocean outbreak strains. | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15 | Unnamed: 16 | Unnamed: 17 | Unnamed: 18 | Unnamed: 19 | Unnamed: 20 | Unnamed: 21 | Unnamed: 22 | Unnamed: 23 | Unnamed: 24 | Unnamed: 25
Protein | C | E3 | E2 | E2 | E2 | E2 | E2 | E2 | E2 | E2 | E2 | E2 | E2 | E2 | E2 | E2 | E2 | E2 | E2 | 6K | 6K | E1 | E1 | E1 | E1
Cleaved protein AA position | 63 | 23 | 57 | 74 | 79 | 146 | 160 | 164 | 181 | 194 | 195 | 211 | 251 | 267 | 299 | 312 | 344 | 375 | 386 | 8 | 54 | 226 | 269 | 284 | 322
Polyprotein AA position | 63 | 284 | 382 | 399 | 404 | 471 | 485 | 489 | 506 | 519 | 520 | 536 | 576 | 592 | 624 | 637 | 669 | 700 | 711 | 756 | 802 | 1035 | 1078 | 1093 | 1131
Genome nt position (a) | 7754 | 8417 | 8710 | 8763 | 8777 | 8978 | 9020 | 9031 | 9082 | 9121 | 9125 | 9173 | 9293 | 9341 | 9437 | 9476 | 9571 | 9664 | 9698 | 9832 | 9970 | 10670 | 10798 | 10845 | 10958
[NAME] | K | I | G | I | G | Q | N | A | L | S | Q | I | R | M | S | T | A | S | V | V | I | A | M | D | V
Ross | R | I | G | I | G | Q | N | A | L | G | R | I | P | R | S | T | A | S | V | V | I | A | M | D | V
05.115 | R | T | K | M | E | Q | T | T | M | G | Q | T | R | R | N | M | T | T | A | I | V | A | V | E | A
05.61 | R | T | K | M | E | Q | T | T | M | G | Q | T | R | R | N | M | T | T | A | I | V | A | V | E | A
06.21 | R | T | K | M | E | Q | T | T | M | G | Q | T | R | R | N | M | T | T | A | I | V | V | V | E | A
06.27 | R | T | K | M | E | Q | T | T | M | G | Q | T | R | R | N | M | T | T | A | I | V | V | V | E | A
06.49 | R | T | K | M | E | Q | T | T | M | G | Q | T | R | R | N | M | T | T | A | I | V | V | V | E | A
05.209 | R | T | K | M | E | R | T | T | M | G | Q | T | R | R | N | M | T | T | A | I | V | A | V | E | A
(a): When two nt positions were variable in the same codon, only the position of the upstream nt is given
Grayed cells correspond to amino acid changes among Indian Ocean outbreak isolates.
Spreadsheet: 798670d1664627231-assigning-round-robin-based-on-criteria-assigning
Sheet: Sheet1

Date | Case Number | Patient Name |  | Case Worker Pool
2022-09-28 00:00:00 | LA1457 | [NAME] |  | [NAME]
2022-09-28 00:00:00 | LA1458 | [NAME] |  | [NAME]
2022-09-29 00:00:00 | LA1459 | [NAME] |  | [NAME]
2022-09-30 00:00:00 | LA1460 | Hailey Amber |  | Reena
2022-09-30 00:00:00 | LA1461 | Hailey Amber |  | [NAME]
2022-10-02 00:00:00 | LA1462 | [NAME]
2022-09-29 00:00:00 | LA1463 | [NAME] Hool
2022-09-30 00:00:00 | LA1464 | Oolea Romeo
2022-09-29 00:00:00 | LA1465 | Ashely Huth
2022-09-30 00:00:00 | LA1466 | Boneer Vice
Spreadsheet: 835015d1688228597-need-help-with-excel-file-and-slicer-calculation-issue-dvg_inventory_tracker_reports
Sheet: Help

Product Name | Current Inventory | Pending Purchases | Re-Order Point | Re-order - Curr Inv | Amount | Quantity | Rank |  |  |  | RANK | PRODUCT NAME | AMOUNT | QUANTITY
Spreadsheet: 33859d1230707723-conditional-copy-of-row-from-one-sheet-to-another-sheet-project1
Sheet: Bank

Bank | Book
 |  | Amount
Date | particular | Opening | Debit | Credit | Closing
 |  | 10000 | 0 | 5500 | 4500
 |  |  | 0 | 0 | 10000
2008-04-10 00:00:00 | Pen |  | 0 | 3000 | 7000
 |  |  | 0 | 0 | 7000
2008-04-10 00:00:00 | Pen |  | 0 | 2500 | 4500
 |  |  | 0 | 0 | 4500
 |  |  | 0 | 0 | 4500
 |  |  | 0 | 0 | 4500
 |  |  | 0 | 0 | 4500
 |  |  | 0 | 0 | 4500
 |  |  | 0 | 0 | 4500
 |  |  | 0 | 0 | 4500
 |  |  | 0 | 0 | 4500
 |  |  | 0 | 0 | 4500
 |  |  | 0 | 0 | 4500
 |  |  | 0 | 0 | 4500
 |  |  | 0 | 0 | 4500
 |  |  |  |  | 4500
 |  |  |  |  | 4500
 |  |  |  |  | 4500
 |  |  |  |  | 4500
 |  |  |  |  | 4500
 |  |  |  |  | 4500
 |  |  |  |  | 4500
 |  |  |  |  | 4500
 |  |  |  |  | 4500
 |  |  |  |  | 4500
 |  |  |  |  | 4500
 |  |  |  |  | 4500
 |  |  |  |  | 4500
 |  |  |  |  | 4500
 |  |  |  |  | 4500
 |  |  |  |  | 4500
 |  |  |  |  | 4500
 |  |  |  |  | 4500
 |  |  |  |  | 4500
 |  |  |  |  | 4500
 |  |  |  |  | 4500
 |  |  |  |  | 4500
 |  |  |  |  | 4500
 |  |  |  |  | 4500
 |  |  |  |  | 4500
 |  |  |  |  | 4500
 |  |  |  |  | 4500
 |  |  |  |  | 4500
 |  |  |  |  | 4500
 |  |  |  |  | 4500
 |  |  |  |  | 4500
 |  |  |  |  | 4500
 |  |  |  |  | 4500
 |  |  |  |  | 4500
 |  |  |  |  | 4500
 |  |  |  |  | 4500
 |  |  |  |  | 4500
 |  |  |  |  | 4500
 |  |  |  |  | 4500
 |  |  |  |  | 4500
 |  |  |  |  | 4500
 |  |  |  |  | 4500
 |  |  |  |  | 4500
 |  |  |  |  | 4500
 |  |  |  |  | 4500
 |  |  |  |  | 4500
 |  |  |  |  | 4500
 |  |  |  |  | 4500
 |  |  |  |  | 4500
 |  |  |  |  | 4500
 |  |  |  |  | 4500
 |  |  |  |  | 4500
 |  |  |  |  | 4500
 |  |  |  |  | 4500
 |  |  |  |  | 4500
 |  |  |  |  | 4500
 |  |  |  |  | 4500
 |  |  |  |  | 4500
 |  |  |  |  | 4500
 |  |  |  |  | 4500
 |  |  |  |  | 4500
 |  |  |  |  | 4500
 |  |  |  |  | 4500
 |  |  |  |  | 4500
 |  |  |  |  | 4500
 |  |  |  |  | 4500
 |  |  |  |  | 4500
 |  |  |  |  | 4500
 |  |  |  |  | 4500
 |  |  |  |  | 4500
 |  |  |  |  | 4500
 |  |  |  |  | 4500
 |  |  |  |  | 4500
 |  |  |  |  | 4500
 |  |  |  |  | 4500
 |  |  |  |  | 4500
 |  |  |  |  | 4500
 |  |  |  |  | 4500
 |  |  |  |  | 4500
 |  |  |  |  | 4500
Spreadsheet: 807086d1669734094-looking-for-a-better-option-than-sumproduct-due-to-near-15-000-formulas-of-it-sample-sheet
Sheet: Output

 | Type 1 | Test 1 | Test 2 | Test 3 | Test 4 | Test 5 | Test 6 | Test 7 | Test 8 | Test 9 | Test 10 | Test 11 | Test 12 | Test 13 | Test 14 | Test 15 | Test 16 | Test 17 | Test 18 | Test 19 | Test 20 | Test 21 | Test 22 | Test 23 | Test 24 | Test 25 | Test 26 | Test 27 | Test 28 | Test 29 | Test 30 | Test 31 | Test 32 | Test 33 | Test 34 | Test 35 | Test 36 | Test 37 | Test 38 | Test 39 | Test 40 | Test 41 | Test 42 | Test 43 | Test 44 | Test 45 | Test 46 | Test 47 | Test 48 | Test 49 | Test 50 | Test 51 | Test 52 | Test 53 | Test 54 | Test 55 | Test 56 | Test 57 | Test 58 | Test 59 | Test 60 | Test 61 | Test 62 | Test 63 | Test 64 | Test 65 | Test 66 | Test 67 | Test 68 | Test 69 | Test 70 | Test 71 | Test 72 | Test 73 | Test 74 | Test 75 | Test 76 | Test 77 | Test 78 | Test 79 | Test 80 | Test 81 | Test 82 | Test 83 | Test 84 | Test 85 | Test 86 | Test 87 | Test 88 | Test 89 | Test 90 | Test 91 | Test 92 | Test 93 | Test 94 | Test 95 | Test 96 | Test 97 | Test 98 | Test 99 | Test 100 | Test 101 | Test 102 | Test 103 | Test 104 | Test 105 | Test 106 | Test 107 | Test 108 | Test 109 | Test 110 | Test 111 | Test 112 | Test 113 | Test 114 | Test 115 | Test 116 | Test 117 | Test 118 | Test 119 | Test 120 | Test 121 | Test 122 | Test 123 | Test 124 | Test 125 | Test 126 | Test 127 | Test 128 | Test 129 | Test 130
 | Name 1
 | Name 2
 | Name 3
 | Name 4
 | Name 5
 | Name 6
 | Name 7
 | Name 8
 | Name 9
 | Name 10
 | Name 11
 | Name 12
 | Name 13
 | Name 14
 | Name 15
 | Name 16
 | Name 17
 | Name 18
 | Name 19
 | Name 20
 | Name 21
 | Name 22
 | Name 23
 | Name 24
 | Name 25
 | Name 26
 | Name 27
 | Name 28
 | Name 29
 | Name 30
 | Name 31
 | Name 32
 | Name 33
 | Name 34
 | Name 35
 | Name 36
 | Name 37
 | Name 38
 | Name 39
 | Name 40
 | Name 41
 | Name 42
 | Name 43
 | Name 44
 | Name 45
 | Name 46
 | Name 47
 | Name 48
 | Name 49
 | Name 50
 | Name 51
 | Name 52
 | Name 53
 | Name 54
 | Name 55
 | Name 56
 | Name 57
 | Name 58
 | Name 59
 | Name 60
 | Name 61
 | Name 62
 | Name 63
 | Name 64
 | Name 65
 | Name 66
 | Name 67
 | Name 68
 | Name 69
 | Name 70
 | Name 71
 | Name 72
 | Name 73
 | Name 74
 | Name 75
 | Name 76
 | Name 77
 | Name 78
 | Name 79
 | Name 80
 | Name 81
 | Name 82
 | Name 83
 | Name 84
 | Name 85
 | Name 86
 | Name 87
 | Name 88
 | Name 89
 | Name 90
 | Name 91
 | Name 92
 | Name 93
 | Name 94
 | Name 95
 | Name 96
 | Name 97
 | Name 98
 | Name 99
 | Name 100
Spreadsheet: 709626d1608457220-next-due-date-of-my-air-ticket-after-my-leave-days-next-due-days-with-formula
Sheet: Sheet1

 | AIR TICKET |  |  |  |  |  |  |  | Start of leave | Days off
 | LEAVE DAYS FROM LAST DUE DATE
 | LEAVE FROM | LEAVE TO | DAYS
 | 2019-08-03 00:00:00 | 2019-08-03 00:00:00
 | 2019-09-01 00:00:00 | 2019-09-15 00:00:00
 | 2019-12-20 00:00:00 | 2019-12-30 00:00:00
 | 2020-03-18 00:00:00 | 2020-03-19 00:00:00
 | 2020-03-30 00:00:00 | 2020-03-30 00:00:00
 | 2020-09-01 00:00:00 | 2020-09-18 00:00:00
 | 2020-12-01 00:00:00 | 2020-12-03 00:00:00
 | LAST DUE DATE | 2019-02-28 00:00:00
 | DUE DURATION | AFTER LEAVE DAYS 365 WORKED DAYS
 | NEXT DUE DATE | ANSWER ??? | <======= | FORMULA NEED
 |  |  | LEAVE DAYS | DUE DURATION | TOTAL DAYS FOR DUE
 | CORRECT ANSWER |  | 29 | 365
Spreadsheet: john_griffith__15630__Book1
Sheet: Sheet1

 |  |  | Natural Gas Straddles
 | Month | Strike | Bid | Offer | Mid-Pt. Vol | Net Change
 | M | 4.25 | 0.37 | 0.39 | 0.4927999999999995 | 0.03734999999999589
 | N | 4.3 | 0.62 | 0.65 | 0.4982000000000009 | 0.02369999999999739
 | Q | 4.4 | 0.83 | 0.86 | 0.5175999999999998 | 0.02729999999999699
 | U | 4.45 | 1 | 1.03 | 0.5215000000000002 | 0.01229999999999865
 | V | 4.5 | 1.14 | 1.18 | 0.5312999999999997 | 0.01529999999999831
 | X | 4.7 | 1.325 | 1.355 | 0.5349000000000006 | 0.01079999999999881
 | Z | 4.9 | 1.52 | 1.56 | 0.5464999999999994 | 0.01259999999999861
 | F | 4.9 | 1.65 | 1.7 | 0.5554999999999995 | 0.01499999999999835
 | G | 4.8 | 1.68 | 1.74 | 0.5483000000000007 | 0.006599999999999273
 | H | 4.65 | 1.56 | 1.66 | 0.5071999999999989 | 0.0131999999999986
 | J | 4.35 | 1.2 | 1.24 | 0.3922999999999993 | 0.008699999999999042
 | K | 4.35 | 1.1 | 1.2 | 0.3593000000000008 | 0.006299999999999306
 |  |  | 2001-05-07 12:28:24.610000