tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 731269d1620256275-data-trend-and-seasonality-identification-solar-readings
Sheet: Sheet1

Solar Panel Readings
[NAME] | Days | [NAME] | Generation | Gener
Dates | Interval | Readings kWh | kWh | p day
2019-11-12 00:00:00 |  | 22497
2019-12-16 00:00:00 |  | 22958
2020-04-24 00:00:00 |  | 23937
2020-07-26 00:00:00 |  | 25469
2020-10-25 00:00:00 |  | 26348
2021-01-21 00:00:00 |  | 26550
2021-04-29 00:00:00 |  | 27455
[NAME] | Gener
Dates | p day
2019-11-12 00:00:00
 | 13.55882352941176
2019-12-16 00:00:00
 | 7.530769230769231
2020-04-24 00:00:00
 | 16.47311827956989
2020-07-26 00:00:00
 | 9.659340659340659
2020-10-25 00:00:00
 | 2.295454545454545
2021-01-21 00:00:00
 | 9.23469387755102
2021-04-29 00:00:00
Spreadsheet: 753374e2-7405-4dfc-bb2b-a47c265b3ad7
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
CARNU | Test | CARNU | Carnitine, [NAME] | Carnitine, U | Flow Injection Analysis-Tandem Mass Spectrometry (FIA-MS/MS) | [NAME]: Urine |  |  | 1.5 | mL | Container/Tube: Plastic, 10-mL urine tube (Supply T068) [NAME]: 1.5 mL Collection Instructions: Collect a random urine specimen. Forms: If not ordering electronically, submit a Biochemical Genetics Request Form (Supply T439) with the specimen. | 1 mL | Hemolysis	NA Thawing	Warm reject; Cold OK <3 days Lipemia	NA Icterus	NA Other	NA | FREE 77-214 nmol/mg of creatinine  TOTAL 180-412 nmol/mg of creatinine  RATIO Acyl to free: 0.7-3.4 | Thursday; 8 a.m. | 2 days | 7 days | 1 | 82379 |  |  |  |  | Rochester
CARNU | [NAME] | URINE | [NAME] |  |  |  | Frozen | 7 days
CARNU | Result | 27121 | Total | Total | Numeric |  |  |  |  | [NAME]/mg Cr |  |  |  |  |  |  |  |  |  | 17866-5
CARNU | Result | 27122 | Free (FC) | Free (FC) | Numeric |  |  |  |  | [NAME]/mg Cr |  |  |  |  |  |  |  |  |  | 13718-2
CARNU | Result | 15789 | AC/FC Ratio | AC/FC Ratio | Numeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 43576-8
CARNU | Result | 21550 | Interpretation | Interpretation | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 59462-2
Spreadsheet: 0a67f774-7698-4734-833f-2791bba4432d
Sheet: Sheet1

EASEMENT DEDICATION APPLICATION | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10
CITY OF OCEANSIDE
ENGINEERING DIVISION
COMPLETE THE INFORMATION BELOW
Project Address: |  |  |  |  |  |  |  |  |  | APN#
Owner Name: |  |  |  |  |  |  |  |  |  | Phone:
Owner Signature: (Must be authorized to sign for owner) |  |  |  |  |  |  |  |  |  | Cell:
Mailing Address: |  |  |  |  |  |  |  |  |  | Fax:
City/State/Zip |  |  |  |  |  |  |  |  |  | E-Mail:
Detailed description of Dedication:
Is there any existing facility(ies) in the easement area?   Yes  □     No  □
Will you be relocating facility(ies) currently existing within the easement to be dedicated?   Yes  □     No  □
Is there any existing easement(s) overlapping the proposed easement area to be dedicated? Yes □ No  □
If the answer is yes to the above question, please provide copy of recorded document(s) and Subordination Letters or Joint Use Agreement from all easement holders.
Is there any existing encroachment(s) over the proposed easement area? Yes □   No  □
If the answer is yes to the above question, please provide encroachment agreement.
Is this dedication associated with a project?   Yes  □     No   □    List Project File No:                                Project Plan No:
Use back of the application or attach additional sheets if needed.
ENGINEER/SURVEYOR INFORMATION IS REQUIRED-PLEASE COMPLETE
Applicant(If different from owner) |  |  |  |  |  |  |  |  |  | Phone:
Applicant Signature: (Must be authorized to sign for owner) |  |  |  |  |  |  |  |  |  | Cell:
Mailing Address: |  |  |  |  |  |  |  |  |  | Fax:
City/State/Zip |  |  |  |  |  |  |  |  |  | E-Mail:
Surveyor/Engineer/Company: |  |  |  |  |  |  |  |  |  | Phone:
Contact(If diferent from above) |  |  |  |  |  |  |  |  |  | Cell:
Mailing Address: |  |  |  |  |  |  |  |  |  | Fax:
City/State/Zip |  |  |  |  |  |  |  |  |  | E-Mail:
Submittal Check List:
□ | Easement dedication application |  |  |  | □ | ٱ | Preliminary Title Report
□ | Assessor's [NAME] |  |  |  | □ |  | Supporting Deeds/Reference Maps
□ | Traverse closure |  |  |  | □ | ٱ | [NAME] with plat (Exhibit B) and legal(Exhibit A), 3 Copies
□ | Conditions of Approval |  |  |  | □ | ٱ | Signature Authority
□ | Joint use agreement (If applicable)
FEE $ |  | Received By: |  |  |  |  | Plan Checker: |  | Permit No.  EASD
Paid      □ Yes   □ No |  | Date Submitted:
NOTE: The legal owner(s) of the parcel involved will be responsible for the accuracy of all information submitted in connection with this application. By accepting the application, the City of Oceanside, its officers, boards, commissioners, employees, agents and representatives, make no warranties, expressed or implied, that the application for easement dedication will be approved. The review fees are non-refundable.
Incomplete submittal will not be reviewed and will be sent back to the applicant.
Spreadsheet: 759804d1639739725-retrieve-value-from-cell-above-test1
Sheet: Sheet1

Est. Start Date | WO No | Total Qty | TopQtyOS | TimeOS | Part No | Description | Description2 | Bom QtyReq | InStock | SubTotal
2022-01-04 14:24:00 | 1 | 426 | 426 | 5:22:46 | A | PartA
2022-01-04 14:24:00 |  |  |  |  |  | A1 | PartA1 | 426 | 0
2022-01-04 14:24:00 | 2 | 62 | 62 | 2:35:00 | B | PartB
2022-01-04 14:24:00 |  |  |  |  |  | B1 | PartB1 | 62 | 2610
2022-01-04 14:24:00 |  |  |  |  |  | B2 | PartB2 | 1.24 | 0
2022-01-06 00:00:00 | 3 | 20 | 20 | 0:04:20 | C | PartC
2022-01-06 00:00:00 |  |  |  |  |  | C1 | PartC1 | 20 | 11
Spreadsheet: 674547d1587906318-unique-value-count-based-of-multiple-criteria-kv
Sheet: BONOUS

CUSTOMER CODE --->> |  | 0026628X
 |  |  |  |  |  | 04 | 03
 |  |  | TOTAL COUNT | SUM | UNIQUE COUNT | UNIQUE SUM |  |  | unique count(unique DOB in NB sheet) in Col.F6 if C2 satisfies below mentioned contidions:-
20190401 | 20200331 |  |  |  |  |  |  |  | IF(NB!A:A,"NB"and NB!M:M,C2 and NB!F:F>=A6 and NB!F:F<=&B6, nb!L:L (UNIQUE DOB)
20180401 | 20190331
20170401 | 20180331 |  |  |  |  |  |  |  | EXPECTED ANSWER IN WRITTEN IN COL F6 AND F14
20160401 | 20170331
20150401 | 20160331
20140401 | 20150331
20130401 | 20140331
20120401 | 20130331
20110401 | 20120331
20100401 | 20110331
20090401 | 20100331
20080401 | 20090331
20070401 | 20080331
20060401 | 20070331
SUM(--(FREQUENCY(IF(NB!A:A,"NB")*(NB!M:M,C2)*(NB!F:F,">="&A6)*(NB!F:F,"<="&B6),NB!L:L),NB!L:[NAME]))))
Spreadsheet: 0c57dcb6-3db7-44ec-8a08-59ac40b2aab8
Sheet: Sheet1

Student Name | Vendor | Equipment | Eval Date | Quote rcd | LMN to MD | PPW | PPW | Approval | Ordered | Received
 |  |  |  |  |  | to CAP/CDSA | to vendor
 |  |  |  |  | sent:
 |  |  |  |  | rec'd:
 |  |  |  |  | sent:
 |  |  |  |  | rec'd:
 |  |  |  |  | sent:
 |  |  |  |  | rec'd:
 |  |  |  |  | sent:
 |  |  |  |  | rec'd:
 |  |  |  |  | sent:
 |  |  |  |  | rec'd:
 |  |  |  |  | sent:
 |  |  |  |  | rec'd:
 |  |  |  |  | sent:
 |  |  |  |  | rec'd:
Spreadsheet: 215498d1361392818-swapping-rows-swap-rows
Sheet: Sheet1

abc | def | abc | def | abc | def | abc | def | abc | def | abc | def
Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
Click on row header
Insert a row on the Home tab
click on the next row header
Move mouse to the border (black) of the selected row.and drag it to the blank inserted row.
If you want you can delete the row you just moved the data from.  Select the row header and click delete on the home tab.
Spreadsheet: 75258d1275843862-custom-text-in-the-cell-if-the-cell-is-blank-trouble-1-
Sheet: Sheet1

 | If product has "Y" in lookup table, then K column must be filled in. If user leaves it blank, I want a text "Please fill in" to appear in that cell. And the cell goes red, until user puts required information in it
 | Product
 | Product 16 |  |  |  |  |  |  |  |  | Please fill In
 | Product 04 |  |  |  |  |  |  |  |  | Please fill In
 | Product 24 |  |  |  |  |  |  |  |  | Please fill In
 | Product 03 |  |  |  |  |  |  |  |  | Please fill In
 | Product 09 |  |  |  |  |  |  |  |  | Please fill In
 | Product 10 |  |  |  |  |  |  |  |  | Please fill In
 | Product 12 |  |  |  |  |  |  |  |  | Please fill In
 | Product 02 |  |  |  |  |  |  |  |  | N
 | Product 13 |  |  |  |  |  |  |  |  | Please fill In
 | Product 01 |  |  |  |  |  |  |  |  | Please fill In
 | Product 17 |  |  |  |  |  |  |  |  | Please fill In
 | Product 11 |  |  |  |  |  |  |  |  | Please fill In
Spreadsheet: kate_symes__18760__NP 15 pages
Sheet: DJ NP15

 |  |  | Firm | Volume | Firm | Volume | Sunday & NERC | Volume
 | DATE |  | On [NAME] | [NAME] | [NAME] | [NAME] | 24 HOUR | [NAME]
 | 2001-03-01 00:00:00 |  | 282.13 | 32240 | 216.41 | 12640
 | 2001-02-28 00:00:00 |  | 210.95 | 35888 | 157.73 | 17224
 | 2001-02-27 00:00:00 |  | 212.87 | 43088 | 151.44 | 17224
 | 2001-02-26 00:00:00 |  | 213.28 | 12320 | 160.3 | 8024
 | 2001-02-25 00:00:00 |  |  |  |  |  | 160.3 | 24072
 | 2001-02-24 00:00:00 |  | 215.99 | 50624 | 158.85 | 20624
 | 2001-02-23 00:00:00 |  | 215.99 | 50624 | 158.85 | 20624
 | 2001-02-22 00:00:00 |  | 253.56 | 46656 | 179.33 | 2824
 | 2001-02-21 00:00:00 |  | 268.77 | 33504 | 198.68 | 16040
 | 2001-02-20 00:00:00 |  | 286.26 | 8880 | 216.91 | 3224
 | 2001-02-19 00:00:00 |  | 288.65 | 24912 | 233.15 | 15840
 | 2001-02-18 00:00:00 |  |  |  |  |  | 283.43 | 35232
 | 2001-02-17 00:00:00 |  | 326.1 | 15872 | 283.43 | 12024
 | 2001-02-16 00:00:00 |  | 437.9 | 29440 | 370.12 | 17208
 | 2001-02-15 00:00:00 |  | 437.9 | 29440 | 370.34 | 18008
 | 2001-02-14 00:00:00 |  | 319.81 | 40656 | 284.13 | 14112
 | 2001-02-13 00:00:00 |  | 284.75 | 33888 | 247.23 | 14448
 | 2001-02-12 00:00:00 |  | 252.44 | 33552 | 233.02 | 14640
 | 2001-02-11 00:00:00 |  |  |  |  |  | 233.02 | 43920
 | 2001-02-10 00:00:00 |  | 230.87 | 33120 | 229.16 | 17424
 | 2001-02-09 00:00:00 |  | 230.87 | 33120 | 229.16 | 17424
 | 2001-02-08 00:00:00 |  | 274.83 | 37456 | 223.07 | 17808
 | 2001-02-07 00:00:00 |  | 251 | 44352 | 218.57 | 14240
 | 2001-02-06 00:00:00 |  | 201.06 | 29952 | 192.99 | 12024
 | 2001-02-05 00:00:00 |  | 180.21 | 10352 | 164.84 | 1008
 | 2001-02-04 00:00:00 |  |  |  |  |  | 166.31 | 4200
 | 2001-02-03 00:00:00 |  | 211.99 | 15456 | 193.3 | 7832
 | 2001-02-02 00:00:00 |  | 215.28 | 26256 | 190.89 | 11032
 | 2001-02-01 00:00:00 |  | 280.34 | 28432 | 276.27 | 13400
 | 2001-01-31 00:00:00 |  | 333.27 | 24800 | 306.35 | 12400
 | 2001-01-30 00:00:00 |  | 314.59 | 22400 | 287.77 | 12784
Spreadsheet: 07296c68-386c-439e-ae6d-c17a93d8cce3
Sheet: 35

THE ALLSTATE CORPORATION
ASBESTOS AND ENVIRONMENTAL RESERVES
($ in millions)
 |  |  |  |  | Three months ended |  |  |  |  |  |  |  |  |  | Twelve months ended December 31,
 |  |  | Dec. 31, |  |  | Sept. 30, |  |  | June 30, |  |  | March 31,
 |  |  | 2012 |  |  | 2012 |  |  | 2012 |  |  | 2012 |  |  | 2012 |  |  | 2011 |  |  | 2010 |  |  | 2009 |  |  | 2008
(net of reinsurance)
Asbestos claims
 | Beginning reserves | $ | 1050 |  | $ | 1034 |  | $ | 1050 |  | $ | 1078 |  | $ | 1078 |  | $ | 1100 |  | $ | 1180 |  | $ | 1228 |  | $ | 1302
 | Incurred claims and claims expense |  | 0 |  |  | 26 |  |  | 0 |  |  | 0 |  |  | 26 |  |  | 26 |  |  | 5 |  |  | -8 |  |  | 8
 | Claims and claims expense paid |  | -24 |  |  | -10 |  |  | -16 |  |  | -28 |  |  | -78 |  |  | -48 |  |  | -85 |  |  | -40 |  |  | -82
 | Ending reserves | $ | 1026 |  | $ | 1050 |  | $ | 1034 |  | $ | 1050 |  | $ | 1026 |  | $ | 1078 |  | $ | 1100 |  | $ | 1180 |  | $ | 1228
 | Claims and claims expense paid
 | as a percent of ending reserves |  | 0.02339181286549707 |  |  | 0.009523809523809525 |  |  | 0.01547388781431335 |  |  | 0.02666666666666667 |  |  | 0.07602339181286549 |  |  | 0.04452690166975881 |  |  | 0.07727272727272727 |  |  | 0.03389830508474576 |  |  | 0.06677524429967427
Environmental claims
 | Beginning reserves | $ | 201 |  | $ | 181 |  | $ | 183 |  | $ | 185 |  | $ | 185 |  | $ | 201 |  | $ | 198 |  | $ | 195 |  | $ | 232
 | Incurred claims and claims expense |  | 0 |  |  | 22 |  |  | 0 |  |  | 0 |  |  | 22 |  |  | 0 |  |  | 18 |  |  | 13 |  |  | 0
 | Claims and claims expense paid |  | -8 |  |  | -2 |  |  | -2 |  |  | -2 |  |  | -14 |  |  | -16 |  |  | -15 |  |  | -10 |  |  | -37
 | Ending reserves | $ | 193 |  | $ | 201 |  | $ | 181 |  | $ | 183 |  | $ | 193 |  | $ | 185 |  | $ | 201 |  | $ | 198 |  | $ | 195
 | Claims and claims expense paid
 | as a percent of ending reserves |  | 0.04145077720207254 |  |  | 0.009950248756218905 |  |  | 0.01104972375690608 |  |  | 0.01092896174863388 |  |  | 0.07253886010362694 |  |  | 0.08648648648648649 |  |  | 0.07462686567164178 |  |  | 0.0505050505050505 |  |  | 0.1897435897435897
Spreadsheet: 814853d1674637000-formula-to-list-birthday-per-month-book1-36-ans
Sheet: Sheet1

Bitrh Date | Month | Day | Age | [NAME] |  |  | January
2022-01-03 00:00:00 |  |  |  | Name Surname 01 |  | Day | [NAME]
2004-05-30 00:00:00 |  |  |  | Name Surname 02
2007-02-13 00:00:00 |  |  |  | Name Surname 03
1981-07-07 00:00:00 |  |  |  | Name Surname 04
1976-06-24 00:00:00 |  |  |  | Name Surname 05
2004-06-08 00:00:00 |  |  |  | Name Surname 06
2015-08-21 00:00:00 |  |  |  | Name Surname 07
1987-01-12 00:00:00 |  |  |  | Name Surname 08
1985-06-11 00:00:00 |  |  |  | Name Surname 09
2020-11-19 00:00:00 |  |  |  | Name Surname 10
2012-10-28 00:00:00 |  |  |  | Name Surname 11
2002-06-20 00:00:00 |  |  |  | Name Surname 12
2017-04-08 00:00:00 |  |  |  | Name Surname 13
1987-02-05 00:00:00 |  |  |  | Name Surname 14
2015-07-13 00:00:00 |  |  |  | Name Surname 15
1959-03-02 00:00:00 |  |  |  | Name Surname 16
1964-11-13 00:00:00 |  |  |  | Name Surname 17
1985-10-22 00:00:00 |  |  |  | Name Surname 18
1998-01-16 00:00:00 |  |  |  | Name Surname 19
1963-06-29 00:00:00 |  |  |  | Name Surname 20
1971-05-15 00:00:00 |  |  |  | Name Surname 21
1939-12-19 00:00:00 |  |  |  | Name Surname 22
2013-02-13 00:00:00 |  |  |  | Name Surname 23
1996-04-25 00:00:00 |  |  |  | Name Surname 24
2019-08-30 00:00:00 |  |  |  | Name Surname 25
1960-12-27 00:00:00 |  |  |  | Name Surname 26
1962-07-18 00:00:00 |  |  |  | Name Surname 27
2021-05-27 00:00:00 |  |  |  | Name Surname 28
1988-10-26 00:00:00 |  |  |  | Name Surname 29
1981-06-12 00:00:00 |  |  |  | Name Surname 30
2001-04-18 00:00:00 |  |  |  | Name Surname 31
2005-10-24 00:00:00 |  |  |  | Name Surname 32
2021-04-21 00:00:00 |  |  |  | Name Surname 33
2018-02-26 00:00:00 |  |  |  | Name Surname 34
1973-01-14 00:00:00 |  |  |  | Name Surname 35
1992-07-28 00:00:00 |  |  |  | Name Surname 36
1968-06-13 00:00:00 |  |  |  | Name Surname 37
2016-06-01 00:00:00 |  |  |  | Name Surname 38
2015-03-03 00:00:00 |  |  |  | Name Surname 39
1993-05-07 00:00:00 |  |  |  | Name Surname 40
1994-05-20 00:00:00 |  |  |  | Name Surname 41
1977-07-08 00:00:00 |  |  |  | Name Surname 42
1982-07-22 00:00:00 |  |  |  | Name Surname 43
1987-04-13 00:00:00 |  |  |  | Name Surname 44
1990-09-04 00:00:00 |  |  |  | Name Surname 45
1995-12-06 00:00:00 |  |  |  | Name Surname 46
1998-01-21 00:00:00 |  |  |  | Name Surname 47
1973-03-10 00:00:00 |  |  |  | Name Surname 48
1978-05-26 00:00:00 |  |  |  | Name Surname 49
Spreadsheet: 60251d1260824054-multiple-columns-transfered-to-one-column-example-of-transfering-multiple-colums-into-rows
Sheet: Plan1

 |  |  |  | Sold Volume |  |  |  |  |  | Price
 | Region | Customer | Model | Jan | Feb | Mar | Apr | May | Jun | Jan | Feb | Mar | Apr | May | Jun
 | Europe | A | aa | 20 | 30 | 40 | 50 | 50 | 10 | 10 | 11 | 12 | 13 | 14 | 15
 | Europe | B | bb | 40 | 31 | 25 | 42 | 20 | 1 | 12 | 11 | 12 | 32 | 43 | 54
 | Europe | C | aa | 20 | 30 | 40 | 50 | 50 | 10 | 10 | 11 | 12 | 13 | 14 | 15
 | Asia | D | bb | 20 | 50 | 40 | 15 | 50 | 10 | 12 | 11 | 12 | 32 | 43 | 54
 | Asia | E | cc | 2050 | 301 | 900 | 349 | 3854 | 5439 | 10 | 11 | 12 | 13 | 14 | 15
 | North America | F | aa | 43 | 43 | 95 | 593 | 59 | 53 | 12 | 11 | 12 | 32 | 43 | 54
 | Need to transfer to the configuration bellow.
 | Region | Customer | Model | Period | Sold Volume | Price
 | Europe | A | aa | Jan | 20 | 10
 | Europe | B | bb | Jan | 40 | 12
 | Europe | C | aa | Jan | 20 | 10
 | Asia | D | bb | Jan | 20 | 12
 | Asia | E | cc | Jan | 2050 | 10
 | North America | F | aa | Jan | 43 | 12
 | Europe | A | aa | Feb | 30 | 11
 | Europe | B | bb | Feb | 31 | 11
 | Europe | C | aa | Feb | 30 | 11
 | Asia | D | bb | Feb | 50 | 11
 | Asia | E | cc | Feb | 301 | 11
 | North America | F | aa | Feb | 43 | 11
 | Europe | A | aa | Mar | 40 | 12
 | Europe | B | bb | Mar | 25 | 12
 | Europe | C | aa | Mar | 40 | 12
 | Asia | D | bb | Mar | 40 | 12
 | Asia | E | cc | Mar | 900 | 12
 | North America | F | aa | Mar | 95 | 12
 | Europe | A | aa | Apr | 50 | 13
 | Europe | B | bb | Apr | 42 | 32
 | Europe | C | aa | Apr | 50 | 13
 | Asia | D | bb | Apr | 15 | 32
 | Asia | E | cc | Apr | 349 | 13
 | North America | F | aa | Apr | 593 | 32
 | Europe | A | aa | May | 50 | 14
 | Europe | B | bb | May | 20 | 43
 | Europe | C | aa | May | 50 | 14
 | Asia | D | bb | May | 50 | 43
 | Asia | E | cc | May | 3854 | 14
 | North America | F | aa | May | 59 | 43
 | Europe | A | aa | Jun | 10 | 15
 | Europe | B | bb | Jun | 1 | 54
 | Europe | C | aa | Jun | 10 | 15
 | Asia | D | bb | Jun | 10 | 54
 | Asia | E | cc | Jun | 5439 | 15
 | North America | F | aa | Jun | 53 | 54
Spreadsheet: 795455d1662707501-return-to-specific-value-skip-blank-according-to-the-new-increment-in-specific-items-hd
Sheet: Sheet1

 | Return to specific value skip blank, according to the new increment in specific items
 |  |  |  |  |  |  |  | wrong formula |  |  | Correct Result |  | Correct Result
 | Date | Inv-numbers |  | oranges | tomatoes |  |  | oranges | << Drop list |  | if orranges |  | if tomatoes
 | 2015-05-01 00:00:00 | 1 |  | 1 | 1 |  |  |  |  |  | 1 |  | 1
 | 2015-05-02 00:00:00 | 2 |  | 1 | 1 |  |  |  |  |  | 5 |  | 3
 | 2015-05-03 00:00:00 | 3 |  | 1 | 2 |  |  |  |  |  |  |  | 9
 | 2015-05-04 00:00:00 | 4 |  | 1 | 2 |  |  |  |  |  |  |  | 10
 | 2015-05-05 00:00:00 | 5 |  | 2 | 2
 | 2015-05-06 00:00:00 | 6 |  | 2 | 2
 | 2015-05-07 00:00:00 | 7 |  | 2 | 2
 | 2015-05-08 00:00:00 | 8 |  | 2 | 2
 | 2015-05-09 00:00:00 | 9 |  | 2 | 3
 | 2015-05-10 00:00:00 | 10 |  | 2 | 4
 |  |  |  |  |  |  |  | =IFERROR(INDEX($C$4:$C$13,MATCH(ROWS($1:1),$E$4:$E$13,0)),"")
Spreadsheet: 219196d1362681060-match-multiple-criteria-then-select-the-smallest-value-the-lookup-value-multimatchlookupsampledata
Sheet: Sheet1

IsPro? | Price Schedule | Tier | Break Even Txns
Basic | ERP1 | 1000000 | 10000000
Basic | ERP1 | 750000 | 854062.5
Basic | ERP1 | 500000 | 588500
Basic | ERP1 | 300000 | 387538.4615384615
Basic | ERP1 | 144000 | 226343.75
Basic | ERP1 | 96000 | 116086.2068965517
Basic | ERP1 | 48000 | 63657.89473684211
Basic | ERP1 | 24000 | 35428.57142857143
Basic | ERP1 | 14400 | 19187.23404255319
Basic | ERP1 | 7200 | 12755.55555555555
Basic | ERP1 | 3300 | 5607.058823529412
Basic | ERP1 | 1440 | 2461.978021978022
Basic | ERP1 | 720 | 1056.842105263158
Pro | ERP1 | 1000000 | 10000000
Pro | ERP1 | 750000 | 835769.2307692308
Pro | ERP1 | 500000 | 570000
Pro | ERP1 | 300000 | 355434.7826086957
Pro | ERP1 | 144000 | 181364.8648648649
Pro | ERP1 | 96000 | 115860
Pro | ERP1 | 48000 | 67957.62711864407
Pro | ERP1 | 24000 | 33444.44444444445
Pro | ERP1 | 14400 | 19634.375
Pro | ERP1 | 7200 | 12101.96078431373
Pro | ERP1 | 3300 | 5540.853658536585
Pro | ERP1 | 1440 | 2463.529411764706
Pro | ERP1 | 720 | 1114.444444444444
Basic | ERP2 | 1000000 | X
Basic | ERP2 | 750000 | X
Basic | ERP2 | 500000 | X
Basic | ERP2 | 300000 | X
Basic | ERP2 | 144000 | X
Basic | ERP2 | 96000 | X
Basic | ERP2 | 48000 | X
Basic | ERP2 | 24000 | X
Basic | ERP2 | 14400 | X
Basic | ERP2 | 7200 | X
Basic | ERP2 | 3300 | X
Pro | ERP2 | 1000000 | 10000000
Pro | ERP2 | 750000 | 845000
Pro | ERP2 | 500000 | 569473.6842105263
Pro | ERP2 | 300000 | 353695.652173913
Pro | ERP2 | 144000 | 180283.7837837838
Pro | ERP2 | 96000 | 120260
Pro | ERP2 | 48000 | 72533.89830508475
Pro | ERP2 | 24000 | 34666.66666666666
Pro | ERP2 | 14400 | 20988.54166666667
Pro | ERP2 | 7200 | 13572.54901960784
Pro | ERP2 | 3300 | 5906.707317073171
Basic | SDK | 1500000 | 10000000
Basic | SDK | 1000000 | 1067000
Basic | SDK | 750000 | 866071.4285714285
Basic | SDK | 500000 | 616562.5
Basic | SDK | 300000 | 375611.1111111111
Basic | SDK | 144000 | 215000
Basic | SDK | 96000 | 120791.6666666667
Basic | SDK | 48000 | 60500
Basic | SDK | 24000 | 35785.71428571428
Basic | SDK | 14400 | 21573.91304347826
Basic | SDK | 7200 | 12894.44444444445
Basic | SDK | 3300 | 4519.512195121952
Basic | SDK | 1440 | 2440
Basic | SDK | 720 | 1740.689655172414
Basic | SDK | 360 | 559.047619047619
Basic | SDK | 180 | 270.1639344262295
Pro | SDK | 1500000 | 10000000
Pro | SDK | 1000000 | 1187142.857142857
Pro | SDK | 750000 | 843125
Pro | SDK | 500000 | 604772.7272727273
Pro | SDK | 300000 | 363392.8571428572
Pro | SDK | 144000 | 181000
Pro | SDK | 96000 | 111196.4285714286
Pro | SDK | 48000 | 65068.96551724138
Pro | SDK | 24000 | 33516.12903225806
Pro | SDK | 14400 | 22275
Pro | SDK | 7200 | 13137.5
Pro | SDK | 3300 | 5759.677419354839
Pro | SDK | 1440 | 2208.656716417911
Pro | SDK | 720 | 1382.337662337662
Pro | SDK | 360 | 724.516129032258
Pro | SDK | 180 | 380
Lookup Values:
Basic | SDK | 19304
It should return 14400
Spreadsheet: 690589d1597178875-quick-formula-bust-formula-bust
Sheet: 2 - Contract Details (2)

 |  |  | 2020-01-01 00:00:00 | 2020-02-01 00:00:00 | 2020-03-01 00:00:00 | 2020-04-01 00:00:00 | 2020-05-01 00:00:00 | 2020-06-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Contract Terms
 | Renewal Term/Current |  | (in USD) |  |  |  | 2020-05-01 00:00:00 |  |  |  |  |  |  |  | Initial Term
Min. Monthly Pmt | Start Date | End Date | 2020-01-31 00:00:00 | 2020-02-28 00:00:00 | 2020-03-31 00:00:00 | 2020-04-30 00:00:00 | 2020-05-31 00:00:00 | 2020-06-30 00:00:00 | [NAME] | Aug-20 | Sep-20 | Oct-20 | Nov-20 | Dec-20 | Start Date | End Date
3784 | 2019-05-03 00:00:00 | 2020-05-02 00:00:00 |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 2018-05-03 00:00:00 | 2019-05-02 00:00:00
Spreadsheet: 768641d1645057901-time-conversion-time-conversion-2
Sheet: Sheet1

Level | Bonus | Time | Zen |  | Excel Time | Decimal Hours
1 | 0.005 | 41m 3s | 72000
2 | 0.01 | 1h 26m | 97200
3 | 0.015 | 2h 52m | 162000
4 | 0.02 | 5h 45m | 194400
5 | 0.025 | 11h 30m | 259200
6 | 0.035 | 11h 30m | 324000
7 | 0.045 | 11h 30m | 388800
8 | 0.055 | 11h 30m | 453600
9 | 0.07 | 11h 30m | 518400
10 | 0.1 | 11h 30m | 583200
Total | 0.1 | 3d 7h 46m
 |  | All Forms
 |  | 2d
 |  | 2d 3h
 |  | 3h
 |  | 2d 3h 4m
 |  | 2d 4m
 |  | 3h 4m
 |  | 4m
 |  | 2d 3h 4m 5s
 |  | 2d 4m 5s
 |  | 2d 5s
 |  | 2d 3h 5s
 |  | 3h 5s
 |  | 4m 5s
 |  | 5s
Spreadsheet: 2d986247-6f9c-43e6-ba8d-40ee5321ff53
Sheet: Dates - FY14

 |  |  |  |  |  |  |  |  |  | Start Over
ACADEMIC & FISCAL PAYROLL DATES - FY 14
 |  |  |  |  |  |  |  |  |  | Back to Payroll Calendars
FISCAL YEAR
PAYROLL/CONTRACT DATES:  6/23/13 – 6/21/14 (2080 HOURS)
26 Pays/Factors
ACADEMIC YEAR-PAID OVER 12 MONTHS
CONTRACT DATES: 8/18/13 - 5/17/14 (1560 HOURS)
PAYROLL DATES: 6/23/13 – 6/21/14 (2080 HOURS)
26 Pays, 20 Factors
ACADEMIC YEAR - NO PAY SPREAD
PAYROLL/CONTRACT DATES:  8/18/13 - 5/17/14 (1560 HOURS)
19.5 Pays/Factors
[NAME]
FALL SEMESTER
PAYROLL/CONTRACT DATES: 8/18/13 - 12/21/13 (720 HOURS)
SPRING SEMESTER
PAYROLL/CONTRACT DATES: 1/12/14 - 5/17/14 (720 HOURS)
SUMMER SESSION - NO PAY SPREAD
PAYROLL/CONTRACT DATES:  5/18/14 - 8/16/14 (13 Weeks)