{"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":36,"n_cols":4,"rows_kept":36,"cut":false,"hidden":false,"merged":[[0,0,0,7],[28,0,28,1],[14,0,14,1],[20,0,20,1],[1,0,1,1],[12,0,12,1],[1,3,12,8],[15,3,18,8],[35,0,35,1],[20,3,22,8],[23,3,24,8],[25,3,25,8],[27,3,28,8],[30,3,32,8],[33,3,34,8],[35,3,36,8]]}
["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"]
["Total Reimbursement for Personal Mileage",{"$f":"B3*B9","v":0},null,"Personal Vehicle Reimbursement Rates                                         Effective 01/01/2024                                                                                                                                                                                                                        $.67/mile when round trip travel is 100 miles or less.\n$.435/mile when mileage exceeds 100 miles round trip."]
[]
["Fleet Vehicle Cost"]
["Total Cost for Using Fleet Vehicle",{"$f":"IF(C8>C19,C8,C19)","v":0},{"$f":"B3*B7","v":0}]
[]
["Enterprise Car Cost",null,null,"*   The reason for renting vehicles in this class (carrying equipment, extra passengers, etc.) must be explained on the TER."]
["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,"See Travel Policies at TravelWIse "]
[]
["Cost per Mile to Rent",{"$f":"B24/B3","v":{"$error":"#DIV/0!"}},null,"https://www.wisconsin.edu/uw-policies/uw-system-administrative-policies/travel-and-expense-general-travel-expense-policy/"]
[]
[null,null,null,"1204 Travel and Expense Policy - Use of Personal Vehicles, Rental Cars and Fleet for Business Transportation"]
["Enterprise/National Big 10 Contract Rates"]
["Compact Car                  ",38]
["Standard Size Car          ",41.75,null,"Enterprise/National Big 10 Contract Rates                             Weekly and Monthly discount rates are located at the link below"]
["Full Size Car             ",42.25]
["Minivan *                   ",68]
["Standard SUV - 5 pass. *     ",67,null,"Big 10 and State of WI rental contract and rate details:"]
["15-Passenger Van (no contract-see policy)","Call for Quote"]
["Cargo Van/Truck (contact local agency for assistance)",null,null,"At TravelWIse under Policies and Procedures,  sign in under “Car Rentals” in the Procedures and Operational Standards section."]