{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Sheet1"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Sheet1","index":0,"n_rows":45,"n_cols":7,"rows_kept":45,"cut":false,"hidden":false,"merged":[[14,3,15,8],[41,3,42,8],[43,3,44,8],[17,5,17,6],[44,0,44,1],[35,0,35,1],[28,3,30,8],[37,0,37,1],[31,3,32,8],[33,3,33,8],[35,3,36,8],[38,3,40,8],[20,3,20,4],[19,5,19,6],[20,5,20,6],[16,7,16,8],[18,5,18,6],[0,0,0,7],[28,0,28,1],[14,0,14,1],[20,0,20,1],[1,0,1,1],[12,0,12,1],[19,7,19,8],[20,7,20,8],[16,3,16,4],[17,3,17,4],[18,3,18,4],[16,5,16,6],[1,3,12,8],[23,3,26,8],[17,7,17,8],[19,3,19,4]]}
["Vehicle Expense Calculator\nCompare the costs of a rental, personal and fleet vehicle"]
["Input Variables",null,null,"\nFleet Vehicle per mile Rates\n\nSubcompacts          .42/mile after 57 miles per day\nSedans                   .48/mile after 50 miles per day\nMini Vans               .63/mile after 38 miles per day\n\n                                                                                                  You will never be charged both a daily charge and mileage, it will be one or the other.                          \n                                                                                             Rate includes gas. Credit cards are supplied for gas, oil, minor emergency repairs & jump starts."]
["Total Miles to be Traveled"]
["Total Days in Trip"]
["Enterprise Car Daily Rate"]
["Cost of Fuel per Gallon"]
["Fleet Vehicle per mile Rate"]
["Daily Fleet Charge / Rates switch to mileage after minimum mileage is met",24,{"$f":"B8*B4","v":0}]
["Personal Vehicle Reimbursement Rate"]
["Vehicle Fuel Economy (MPG)"]
[]
[]
["Calculated Results"]
[null,null,null," "]
["Personal Vehicle Cost",null,null,"2016 Reduced Travel Rates for 3+ Days and 700+ miles - Fleet Vehicles Only"]
["Total Reimbursement for Personal Mileage",{"$f":"B3*B9","v":0}]
[null,null,null,"Miles","Miles","Mini-van Rate","Mini-van Rate"]
["Fleet Vehicle Cost",null,null,700,700,0.6,0.6]
["Total Cost for Using Fleet Vehicle",{"$f":"IF(C8>C19,C8,C19)","v":0},{"$f":"B3*B7","v":0},1500,1500,0.57999999999999996,0.57999999999999996]
[null,null,null,2500,2500,0.55000000000000004,0.55000000000000004]
["Enterprise Car Cost",null,null,"3,500 +","3,500 +",0.5,0.5]
["Rental",{"$f":"B5*B4","v":0}," "]
["Refueling",{"$f":"B3/B10*B6","v":{"$error":"#DIV/0!"}}]
["Total",{"$f":"SUM(B22:B23)","v":{"$error":"#DIV/0!"}},null,"Personal Vehicle Reimbursement Rates                                         Effective 01/01/2019                                                                                                                                                                                                                        $.58/mile when round trip travel is 100 miles or less.\n$.375/mile when mileage exceeds 100 miles round trip."]
[]
["Cost per Mile to Rent",{"$f":"B24/B3","v":{"$error":"#DIV/0!"}}]
[]
[]
["Enterprise/National Big 10 Contract Rates",null,null,"*   The reason for renting vehicles in this class (carrying equipment, extra passengers, etc.) must be explained on the TER."]
["Compact Car                  ",32]
["Standard Size Car          ",34]
["Full Size Car             ",34,null,"See Travel Policies at TravelWIse "]
["Minivan *                   ",54]
["SUV - 5 pass. *     ",54,null,"https://uw.foxworldtravel.com/"]
["15-Passenger Van (no contract-see policy)","Call for Quote"]
["Cargo Van/Truck (contact local agency for assistance)",null,null,"1204 Travel and Expense Policy - Use of Personal Vehicles, Rental Cars and Fleet for Business Transportation"]
[]
["Vehicle Fuel Economy"]
["Compact Car                  ","30-38 mpg ",null,"Enterprise/National Big 10 Contract Rates                             Weekly and Monthly discount rates are located at the link below"]
["Standard Size Car          ","30-38 mpg"]
["Full Size Car                   ","25-35 mpg"]
["Minivan *                       ","20-28 mpg",null,"Big 10 and State of WI rental contract and rate details:"]
["SUV - 5 pass. *                ","14-25 mpg"]
["15-Passenger Van (no contract-see policy)    ","8-18 mpg",null,"At TravelWIse under Policies and Procedures,  sign in under “Car Rentals” in the Procedures and Operational Standards section."]
["Cargo Van/Truck  (contact local agency for assistance)"]