tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 50174d1249562217-getting-a-formula-to-show-zero-until-it-is-used-sample-timesheet
Sheet: October

 | YOUTH ASSOCIATION SOUTH YORKSHIRE - STAFF TIMESHEET
 | Name
 | Date | Start AM | Finish | Start PM | Finish | Holiday | Sick | Total | Project/Location/Outputs
Monday | 2009-10-05 00:00:00 |  |  |  |  |  |  | 0
Tuesday | 2009-10-06 00:00:00 |  |  |  |  |  |  | 0
Wednesday | 2009-10-07 00:00:00 |  |  |  |  |  |  | 0
Thursday | 2009-10-08 00:00:00 |  |  |  |  |  |  | 0
Friday | 2009-10-09 00:00:00 |  |  |  |  |  |  | 0
Saturday | Weekend |  |  |  |  |  |  | 0
Sunday | Total |  |  |  |  | 0 | 0 | 0
Monday | 2009-10-12 00:00:00 |  |  |  |  |  |  | 0
Tuesday | 2009-10-13 00:00:00 |  |  |  |  |  |  | 0
Wednesday | 2009-10-14 00:00:00 |  |  |  |  |  |  | 0
Thursday | 2009-10-15 00:00:00 |  |  |  |  |  |  | 0
Friday | 2009-10-16 00:00:00 |  |  |  |  |  |  | 0
Saturday | Weekend |  |  |  |  |  |  | 0
Sunday | Total |  |  |  |  | 0 | 0 | 0
Monday | 2009-10-19 00:00:00 |  |  |  |  |  |  | 0
Tuesday | 2009-10-20 00:00:00 |  |  |  |  |  |  | 0
Wednesday | 2009-10-21 00:00:00 |  |  |  |  |  |  | 0
Thursday | 2009-10-22 00:00:00 |  |  |  |  |  |  | 0
Friday | 2009-10-23 00:00:00 |  |  |  |  |  |  | 0
Saturday | Weekend |  |  |  |  |  |  | 0
Sunday | Total |  |  |  |  | 0 | 0 | 0
Monday | 2009-10-26 00:00:00 |  |  |  |  |  |  | 0
Tuesday | 2009-10-27 00:00:00 |  |  |  |  |  |  | 0
Wednesday | 2009-10-28 00:00:00 |  |  |  |  |  |  | 0
Thursday | 2009-10-29 00:00:00 |  |  |  |  |  |  | 0
Friday | 2009-10-30 00:00:00 |  |  |  |  |  |  | 0
Saturday | Weekend |  |  |  |  |  |  | 0
Sunday | Total |  |  |  |  | 0 | 0 | 0
 |  |  |  |  | Total | 0 | 0 | 0
 |  |  |  |  | Please print off, sign and
 |  |  |  |  | submit this timesheet by Friday 6th November
 | Signed | ………………………………………
 | Date | ………………………………………
 | Notes/Comments
Spreadsheet: 35251d1232803113-time-formula-to-calculate-compliance-tat_daddy
Sheet: Sheet1

PA_number | Date_PA_recieved | Time (second status), if pended | Time (final status) |  |  |  | Holidays
176 | 2009-01-08 10:41:00 | 2009-01-09 14:48:43 | 2009-01-09 16:33:00 | OK |  |  | 2009-01-13 00:00:00
177 | 2009-01-08 10:41:00 |  | 2009-01-19 16:33:00 | More than 5 days
178 | 2009-01-08 10:41:00 | 2009-01-09 14:48:43 | 2009-01-14 16:33:00 | OK
179 | 2009-01-08 10:41:00 | 2009-01-09 14:48:43 | 2009-01-15 16:33:00 | More than 24 hours
Spreadsheet: 868959d1715669827-hyper-link-formula-sample
Sheet: Sheet1

Document Type | Document Number | Hyperlink | Status
DPR | DPR-002 |  | Under Review
PDRO | PDRO-002 |  | Under Review
MPR | MPR-002 |  | Under Review
WPR | WPR-002 |  | Under Review
DPR | DPR-001 |  | Approved
PDRO | PDRO-001 |  | Approved
MPR | MPR-001 |  | Approved
WPR | [NAME] |  | Approved
Spreadsheet: eric_saibi__9806__092001
Sheet: Nine Mile Point 01

Owner Name |  | Niagara Mohawk Power Corp.
Station Name |  | Nine Mile Point Nuclear Power Station
Unit Name |  | Nine Mile Point 01
NERC Region |  | NPCC
State |  | NY
Fuel Type |  | Nuclear
Capacity |  | 642 MW
Start Date |  | 2001-09-19 00:00:00
End Date |  | 2001-09-23 00:00:00
Comments |  | Unit will maintain at reduced power ( 48%) for waterbox cleaning. Plan to be back at full power by Sunday.
SIC |  | 4911
Plant ID |  | 1514373
Unit ID |  | 1005757
Outage ID
Spreadsheet: eb76c2e2-fb3b-4720-9d72-c03a95ca4507
Sheet: 12a

Product |  | Cleared** | Uncleared | TOTAL
Swap* | Basis
 | FRA
 | Exotic
 | Inflation
 | IRS- [NAME]
 | OIS
 | VNS
 | Zero Coupon
With Optionality | Callable Swap
 | Cap/Floor
 | Debt Option
 | Exotic Option
 | Swaption
Cross-Currency | Exotic
 | Swap
TOTAL |  | N/A*** | N/A | N/A
Estimated swap dollar volumes, week ending February 15, by product type and cleared status (value of all trades in millions of USD), all participant types and currencies. Data are adjusted for double-counting of cleared trades to show a single exposure for each trade.
Total(s) may be less than total shown for this asset class in the All Swaps reports and/or other CFTC Swaps Report tables if products were excluded from this table that (a) presented disclosure risk or (b) did not belong in the categories shown. See Explanatory Notes for more detail.
*See Data Dictionary for product descriptions and Explanatory Notes for data sources.
**See Explanatory Notes for cleared and uncleared descriptions.
***N/A indicates that data are not currently available.
The Commission requests feedback on the format and content of this CFTC Swaps Report table. Submit comments to [EMAIL].
Spreadsheet: 551459d1512965150-cell-colour-formatting-with-multiple-arguments-copy-of-colour
Sheet: Sheet2

 |  | Milestone | Task | True
 |  | Patch Cable | Buy cables | True
 |  |  | Install cables | True
 |  |  | Label cables | True
 |  | Install Equipment | Buy devices | False
 |  |  | Asset register | True
 |  |  | Install devices | True
 |  | Delivery | Trial run with client | False
 |  |  | Training | False
 |  |  | [NAME] | False
 |  | xxx
Spreadsheet: 177862d1346479932-extract-the-top-item-excel-question-1-
Sheet: Sheet1

City | cost | count | vendor |  | I need a way to extract the top (?)items in the cost column |  |  |  |  |  |  |  | [NAME]
Portland | 82.23 | 1 | 8383 |  | (?) is the variable in count column |  |  |  |  |  |  |  | LA
[NAME] | 83.66 | 1 | 883 |  |  |  |  |  |  |  |  |  | NY
Seattle | 88.95333333333333 | 5 | 379 |  | In this example the top 5 items in City Seattle, 9 items in city LA |  |  |  |  |  |  |  | Portland
Seattle | 89.31199999999998 |  | 1781 |  | and 4 items in city of NY are highlighted |  |  |  |  |  |  |  | Seattle
Seattle | 89.37333333333333 |  | 6842
Seattle | 87.64 |  | 6837
Seattle | 89.44333333333333 |  | 6483 |  | LA
Seattle | 89.55333333333333 |  | 450
Seattle | 87.64 |  | 446 |  | City | cost | count | vendor
Seattle | 87.71333333333332 |  | 7483
Seattle | 87.846 |  | 198
Seattle | 88.075 |  | 6881
LA | 90.04499999999999 | 9 | 5926
LA | 90.4125 |  | 1109
LA | 90.46666666666665 |  | 285
LA | 88.7825 |  | 124
LA | 88.95333333333333 |  | 1863
LA | 89.31199999999998 |  | 6648
LA | 89.3733333333333 |  | 1592
LA | 89.39666666666666 |  | 1471
LA | 89.44333333333333 |  | 6377
LA | 89.55333333333333 |  | 1209
LA | 89.875 |  | 858
LA | 89.89750000000001 |  | 397
NY | 89.9375 | 4 | 7399
NY | 90.04499999999999 |  | 266
NY | 90.4125 |  | 639
NY | 89.39666666666666 |  | 1780
NY | 89.44333333333333 |  | 591
NY | 91.13 |  | 999
Spreadsheet: 294723d1391492297-populating-worksheet-from-a-main-sheet-staff-notes
Sheet: Print out

Rec # | 1
Date | First Name | Surname | Staff Number | CSS/APM | Discussion | Follow up Notes | Date
2014-01-01 00:00:00 | [NAME] | foolish | 234567 | [NAME] | dopey as | 0 | 1900-01-01 00:00:00
This sheet will automatically populate - don't modify any contents To print 1 record, simply enter the Record # in cell B2 and press CTRL + P
 |  | Staff Discussion Note
Date | 2014-01-01 00:00:00 |  |  | Staff Member | [NAME]
 |  |  |  |  | foolish
Conducted By | [NAME]
 |  |  |  | Staff Number | 234567
 | Discussion points
 | dopey as
 | Follow up Information
Follow up | 0
Date
1900-01-01 00:00:00
Signature:
 | [NAME] |  |  | [NAME]
 |  |  |  | foolish
Spreadsheet: c54628ba-a09b-4792-9095-749d2b9bdb88
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
SSP | Test | SSP | Sporothrix Antibody, Serum | [NAME], S | Latex Agglutination | Serum Gel Tube: SGT |  |  | 1 | mL | Container/Tube: Preferred: Red top Acceptable: Serum gel [NAME]: 1 mL Forms: If not ordering electronically, submit a General Request Form (Supply T239) with the specimen. | 0.15 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm reject; Cold OK Lipemia	Mild OK; Gross reject Icterus	NA Other	NA | Negative | Monday, Wednesday, Friday; 9 a.m. | Same day/1 day | 4 days | 1 | 86671 |  |  |  |  | Rochester
SSP | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
SSP | Result | 9673 | [NAME], S | [NAME], S | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 13273-8 | Sporothrix schenckii [NAME]:ACnc:Pt:Ser:Ord:
Spreadsheet: 543684d1508509247-using-groups-to-count-time-book1
Sheet: Sheet1

[NAME] | 00:22:00 |  | Worker | 00:15:00 | 00:30:00
[NAME] | 00:23:00 |  | [NAME]
[NAME] | 00:25:00 |  | [NAME]
[NAME] | 00:25:00
[NAME] | 00:25:00
[NAME] | 00:27:00
[NAME] | 00:27:00
[NAME] | 00:27:00
[NAME] | 00:30:00
[NAME] | 00:30:00
[NAME] | 00:30:00
[NAME] | 00:30:00
[NAME] | 00:31:00
[NAME] | 00:37:00
[NAME] | 00:38:00
[NAME] | 06:54:00
[NAME] | 06:55:00
[NAME] | 00:04:00
[NAME] | 00:12:00
[NAME] | 00:14:00
[NAME] | 00:17:00
[NAME] | 00:20:00
[NAME] | 00:20:00
[NAME] | 00:20:00
[NAME] | 00:20:00
[NAME] | 00:20:00
[NAME] | 00:21:00
[NAME] | 00:25:00
[NAME] | 00:25:00
[NAME] | 00:27:00
[NAME] | 00:30:00
[NAME] | 00:32:00
[NAME] | 00:39:00
[NAME] | 00:45:00
[NAME] | 00:45:00
[NAME] | 00:47:00
Spreadsheet: 104770d1302224896-question-about-linking-formulas-from-one-page-to-another-new-accts-payable-2011
Sheet: Mar

march expenses
total
advertising
date | po# | suppplier.description | amount
subtotal
x
educational
date | po# | suppplier.description | amount
subtotal
x
supplies. blanks
date | po# | suppplier.description | amount
subtotal
x
supplies. designs
date | po# | suppplier.description | amount
subtotal
s
supplies. notions
date | po# | suppplier.description | amount
subtotal
supplies. machinery
date | po# | suppplier.description | amount
subtotal
supplies. office
date | po# | suppplier.description | amount
subtotal
etsy maintenance
date | po# | suppplier.description | amount
subtotal
website maintenance
date | po# | suppplier.description | amount
subtotal
shipping
date | po# | suppplier.description | amount
subtotal
utilities
date | po# | suppplier.description | amount
subtotal
Spreadsheet: 850615d1701012957-vlookup-formulas-with-3-criterias-kev56-example
Sheet: Sheet1

doc # | Country ID | Product Name | quantity sold |  |  |  | doc # | Country ID | Product Name | quantity sold
IN000496 | BE | Flowers |  |  |  |  | IN000496 | BE | Flowers | 16
IN000496 | HR | Flowers |  |  |  |  | IN000496 | PT | Flowers | 9
IN000496 | CZ | Flowers |  |  |  |  | IN000496 | CZ | Flowers | 6
IN000496 | PT | Flowers |  |  |  |  | IN000496 | ES | [NAME] | 5
IN000496 | IE | Flowers |  |  |  |  | IN000496 | IE | Flowers | 10
IN000496 | ES | [NAME] |  |  |  |  | IN000496 | HR | Flowers | 24
Spreadsheet: 701879d1603978509-filter-the-data-by-the-given-date-from-a-table-ef1411_filter-tasks
Sheet: Result

 |  |  | name | time | Course | Exam room | class |  |  | name | time | Course | Exam room | class |  | name | time | Course | Exam room | class
21 Ekim 2020 Çarşamba | CHOOSE A DATE | 21 Ekim 2020 Çarşamba |  |  |  |  |  |  |  | Name1 | 13:30:00 | Course-1 | 9A | 9A |  | Name4 | 13:30:00 | Course-4 | 9A | 9A
22 Ekim 2020 Perşembe |  |  |  |  |  |  |  |  |  | Name7 | 12:00:00 | Course-1 | 10A | 10A |  | Name4 | 12:00:00 | Course-3 | 10A | 10A
23 Ekim 2020 Cuma |  |  |  |  |  |  |  |  |  | Name7 | 13:30:00 | Course-1 | 10A | 9A |  | Name7 | 12:00:00 | Course-3 | 11A | 10A
26 [NAME] 2020 Pazartesi |  |  |  |  |  |  |  |  |  | Name14 | 12:00:00 | Course-1 | 11A | 10A |  | Name7 | 13:30:00 | Course-4 | 10A | 9A
27 Ekim 2020 Salı
28 Ekim 2020 Çarşamba
30 Ekim 2020 Cuma
2 Kasım 2020 Pazartesi
3 Kasım 2020 Salı
4 Kasım 2020 Çarşamba
5 Kasım 2020 Perşembe
6 Kasım 2020 Cuma
9 Kasım 2020 Pazartesi
Spreadsheet: 483378d1475624787-pulling-keywords-out-of-a-cell-excel-help-doc
Sheet: Sheet2

 |  | Text | Key 1 | Key 2 | Key 3 | Keywords
 |  | The Giants had no chance against the [NAME]! | Giants | Seahawks | - | Seahawks
 |  | The Cowboys are finally looking like a strong team! | Cowboys | - | - | Eagles
 |  | I'm not sure if the Redskins are even playing this year. | Redskins | - | - | Cowboys
 |  | The Giants, [NAME], Ravens, and [NAME] are my favorite! | Giants | [NAME] | Ravens | Falcons
 |  | I hate watching the Falcons play! | Falcons | - | - | [NAME]
 |  | The Falcons could never beat the [NAME]! | Falcons | Seahawks | - | Giants
 |  | Can you tell I'm a [NAME] fan?! | Seahawks | - | -
 |  | I'm running out of ways to tell you how great the [NAME] are. | Seahawks | - | -
Spreadsheet: 268719d1380752289-pilot-logbook-index-and-match-flightnduty
Sheet: SUMMARY

SUMMARY SHEET
 | Duty | Flight |  |  | In the last 30 days |  |  |  | IF
Pilot | 30 Days | 7 Days | 28 Days | 90 Days | NDB | VOR | LOC | GPS | 30 Days
Spreadsheet: 15cb473c-2938-4394-b90f-388df51e30cb
Sheet: approved special ed licensure

Minnesota Approved Special Education Teacher Licensure Programs
Key:   B = offered at both undergrad and graduate levels   G = offered at graduate level only   U = offered at undergraduate level only   D = discontinued program | University of MN System | University of MN - Duluth | University of MN - Twin Cities | State University System | Bemidji State University | MN State University, Mankato | MN State University, Moorhead | St. Cloud State University | Southwest MN State University | Winona State University | Private Institutions | Augsburg College | Bethel University | Capella University | Concordia University - St. Paul | Hamline University | Saint Mary's University | University of St. Thomas | Walden University
Teacher Licensure Program Name
Autism Spectrum Disorders  Birth-12 |  |  | G |  |  | G | G | G |  |  |  |  |  |  | G | G | G | G
Blind or Visually Impaired  Birth-12 |  | D |  |  | D |  | D | D |  |  |  |  | D
Deaf or Hard of Hearing  Birth-12 |  |  | G
Developmental Adapted Physical Education  PreK-12 |  |  | G |  | D | D | U | D | D | D |  |  | U
Developmental Disabilities  K-12 |  |  | D |  |  | G | B | G | D | B |  |  |  |  |  |  |  | G
Early Childhood Special Education  Birth-Age 6 |  | D | G |  |  | G | G | D | D | D |  |  |  |  |  |  |  | G
Emotional or Behavioral [NAME] |  | D | D |  | G | G | B | G | D |  |  | D | D |  | G | D | G | G | D
Learning Disabilities  K-12 |  | D | D |  | G | G | B | G | D | B |  | D | D | D | G | D | G | G | D
Physical and Health Disabilities  Birth-12 |  |  |  |  |  |  | G | D
Academic and Behavioral Strategist (ABS)  K-12 * |  | B | G |  |  | U | U | B | U |  |  | B | G |  |  |  |  | G | G
* Autism Spectrum Disorders - WHEN ADDING TO ABS ONLY |  |  |  |  |  | G | G |  |  |  |  |  |  |  |  |  |  | G
* Developmental Disabilities - WHEN ADDING TO ABS ONLY |  |  |  |  |  | G | G |  |  |  |  |  |  |  |  |  |  | G
* Emotional or Behavioral Disorders - WHEN ADDING TO ABS ONLY |  |  |  |  |  | G | G |  |  |  |  |  |  |  |  |  |  | G
* Learning Disabilities - WHEN ADDING TO ABS ONLY |  |  |  |  |  | G | G |  |  |  |  |  |  |  |  |  |  | G
Revised May 23, 2013
Periodically check Minnesota Department of Education's Special Education Licensure webpage for current program status as it can change.
Spreadsheet: chris_stokley__3922__0301 PGES Final
Sheet: ECT

 | EPMI Charges To ECT
 | Trans Type | (CAISO 0601 M)
 | ID | (All)
 |  |  |  |  |  |  |  |  | MrktDt | (All)
 |  | Data |  |  |  |  |  |  | SchedType | (All)
 | Customer | Exp | Rev | Charge | Volume |  |  |  | ID | (All)
 | Grand Total
 |  |  |  |  |  |  |  |  |  |  |  | Data
 |  |  |  |  |  |  |  |  | Customer | Location | TO | Charge | Rate | Volume | FTR %
 |  |  |  |  |  |  |  |  | PGES | All | SP15 | -1724121.6798 | 0 | 22558.06399999999 | 0
 |  |  |  |  |  |  |  |  |  |  | NP15 | 16249.95840000001 | 0 | -9568.2841 | 0
 |  |  |  |  |  |  |  |  |  |  | HUMB | 13.3541 | 0 | -1.6207 | 0
 |  |  |  |  |  |  |  |  |  |  | SF | -582.0793 | 0 | -27.6693 | 0
 |  |  |  |  |  |  |  |  |  |  | ZP26 | 191.6792 | 0 | -3.953900000000002 | 0
 |  |  |  |  |  |  |  |  |  |  | All | -40914802.60789999 | 0 | 1352865.743257811 | 0
 |  |  |  |  |  |  |  |  |  | None | All | -148712.5745 | 0.7309038461538461 | 201434.0782457061 | 0
 |  |  |  |  |  |  |  |  |  | PGE1 | PGE1 | 96.81629999999997 | 107.3575768727941 | -0.8002954757360276 | 0
 |  |  |  |  |  |  |  |  |  | PGE2 | PGE2 | 356.7889 | 107.3065815389448 | -1.9000738343534 | 0
 |  |  |  |  |  |  |  |  |  | PGE3 | PGE3 | 879530.5542000001 | 114.6674290036097 | -7381.680239142217 | 0
 |  |  |  |  |  |  |  |  |  | PGE4 | PGE4 | 4155.677499999999 | 106.0267358305399 | -33.62945285613016 | 0
 |  |  |  |  |  |  |  |  |  | SCE1 | SCE1 | -29791878.2237 | 114.4831189963377 | 258901.5044564605 | 0
 |  |  |  |  |  |  |  |  |  | SDG1 | SDG1 | 398049.3020999999 | 106.0584831867832 | -3435.17550802894 | 0
 |  |  |  |  |  |  |  |  | PGES Total |  |  | -71281453.03449996 | 13.32928622956453 | 1815304.67639064 | 0
 |  |  |  |  |  |  |  |  | Grand Total |  |  | -71281453.03449996 | 13.32928622956453 | 1815304.67639064 | 0
Spreadsheet: 36258d1234124920-index-match-excel-index-match-problem
Sheet: Sheet1

cat number | number of labels
9898989 | 2 | 1
10265 | 1 | 3
199966 | 2 | 4
199980 | 4 | 6
200013 | 3 | 10
1190524 | 1 | 13
1610011 | 1 | 14
1160004 | 1 | 15
961314 | 4 | 16
961321 | 2 | 20
970147 | 6 | 22
980474 | 2 | 28
1630022 | 1 | 30
2408497 | 1 | 31
1160516 | 1 | 32
1190445 | 1 | 33
2779982 | 4 | 34
2830010 | 2 | 38
1610028 | 2 | 40
1621749 | 2 | 42
1621756 | 2 | 44
1630015 | 1 | 46
200020 | 1 | 47
1057722 | 1 | 48
2408507 | 1 | 49
2410193 | 10 | 50
2410382 | 2 | 60
981459 | 1 | 62
1160509 | 1 | 63
Spreadsheet: 852961d1702929048-need-help-with-if-function-and-function-and-mod-function-sales-discount-amount_more-than-multiplier
Sheet: Sheet_001

Sales amount
Segment |  | Segment's Range ( minimum) |  | Discount Rate |  | Discount Amount
1st Segment |  | 1000 and multipier 1000 |  | 0.005
2ed Segment |  | 100000 , multipier 1000 |  | 0.03
3rd Segment |  | 250000 , multipier 10000 |  | 0.02
4th Segment |  | 1000000 , multipier 100000 |  | 0.01
5th Segment |  | 3000000 , multipier 100000 |  | 0.015
Spreadsheet: 607e60b9-cf6a-4148-9802-575555231ac7
Sheet: Sheet1

To determine the amount for private vehicle mileage reimbursement, please fill in the yellow highlighted fields.  Personal reimbursement will be at the Hertz Full Size rate or the Employee Car/Minivan rate, whichever is less.  If no FHSU Motor Pool vehicle or Hertz vehicle is available, $0.56 per mile will be the reimbursement rate.  The traveler is not required to use Hertz as the rental company. | 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
[NAME]'s Name:
PR #:
PO #:
Check Applicable:
 | Pretrip Estimate
 | Complete prior to submitting a PR. Form to be retained by department.
 | Actual Expense
 | Complete after traveler returns. Form to be sent to Accounts Payable along with travel receipts.
Number of Days Vehicle is Required:
Total Miles Driven:
KDOT mileage chart: |  |  |  |  |  | http://kdotapp2.ksdot.org/mileagebetweencities/
Return Travel Date: |  |  |  |  |  |  |  |  | Travel Date must be 07/01/14 or later
Reimbursement Calculation
Employee Car/Minivan when [NAME] is available ($0.22 plus estimated fuel per mile) |  |  |  |  | Employee Car/Minivan when [NAME] and [NAME] NOT available ($0.56 per mile) |  |  |  | Hertz Full Size  rate including the Cost of Fuel |  |  |  |  |  | Department may reduce the rate or limit the amount to be reimbursed.
 |  |  |  |  | 0
Vehicle Data
Current Cost of Fuel per Gallon |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | per gallon
Estimated Miles per Gallon for Rental Full Size |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 25 | miles/gallon
Employee Car/Minivan Rate when Motor [NAME] is available |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | per mile
Employee Car/Minivan Rate when [NAME] and Hertz Vehicle NOT available |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.56 | per mile
Hertz Full Size Rate (Unlimited Miles) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 33.5 | per day
Gas price updated as of |  |  |  |  |  | 2014-11-19 00:00:00
Hertz Contract 37354  Awarded 11-01-12
Comments:
Spreadsheet: 98120d1297172695-macro-creates-new-sheet-with-data-from-other-sheets-customer-order
Sheet: expired-Pears

 | Pears
Variety | Quantity | [NAME] | List Price 2010 | List Price 2011 | Customer Discount | Comments
Bosc | 5 | 2011-01-31 00:00:00 | 0.2 | 0.21 | 0.8 | France
d'Anjou | 4 | 2011-01-31 00:00:00 | 0.41 | 0.45 | 0.7 | France
[NAME] | 19 | 2011-01-31 00:00:00 | 0.45 | 0.5 | 0.5 | European
[NAME] | 20 | 2011-01-31 00:00:00 | 0.6 | 0.7 | 0.55 | Classic
European | 35 | 2011-01-31 00:00:00 | 0.45 | 0.5 | 0.95 | France
Spreadsheet: 736448d1623655610-formula-indirect-and-array-suddenly-stopped-working-book3
Sheet: Consolidated

 | Workbook Array | Worksheet Array
 | Book3 | Sheet1
 |  | Sheet2
 |  | Sheet3
 |  | 2021 | 2022 | 2023 | 2024 | 2025 | 2026 | 2027 | 2028 | 2029 | 2030
Hardcoded = | Sheet1
this works | Sheet2
 | Sheet3
Array = | Sheet1
does not work | Sheet2 |  |  |  |  |  |  |  |  |  |  |  | <= This is what I need, given a large number of
 | Sheet3 |  |  |  |  |  |  |  |  |  |  |  | worksheets
Spreadsheet: 91568035-e14d-4418-b5ea-6bf1d7fae1ce
Sheet: Sheet1

Event | Nature | Rate
liveri → liveri + 1 | division | lL liveri
liveri → liveri – 1 | death | mL liveri
spleeni → spleeni + 1 | division | [NAME] spleeni
spleeni → spleeni – 1 | death | mS spleeni
bloodi → bloodi – 1, liveri → liveri + 1 | transfer | qL bloodi
bloodi → bloodi – 1, spleeni → spleeni + 1 | transfer | qS bloodi
bloodi → bloodi + 1, liveri → liveri – 1 | transfer | qB liveri
bloodi → bloodi + 1, spleeni → spleeni – 1 | transfer | qB spleeni