{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Vehicle Log","Monthly Rept","Mileage Chargeback"],"not_rendered":{"images":1,"defined_names":1,"comments":1},"read":"whole","date_system":"1900"}

{"sheet":"Vehicle Log","index":0,"n_rows":5,"n_cols":8,"rows_kept":5,"merged":[[0,18,0,19],[1,18,1,19]]}
["Division of Agriculture",{"$nulls":5},"Vehicle Make/Model"]
["Travel Log",{"$nulls":5},"VIN"]
[{"$nulls":6},"Month"]
[]
["Date","Name","Beginning Odometer","Ending Odometer","Miles Driven","Gas or repair expense?  If so, provide receipt to Accounting.","Destination and Purpose","For Mileage Usage Fees - BASIS Cost Center (AES/AFLS) or BANNER Fund/Org (CES) "]

{"sheet":"Monthly Rept","index":1,"n_rows":29,"n_cols":25,"rows_kept":29,"merged":[[0,7,0,11],[1,1,1,3],[1,15,1,17],[2,3,2,7],[2,15,2,17],[3,3,3,7],[3,15,3,17],[4,4,4,7],[4,13,4,14],[4,15,4,16],[6,6,6,7],[6,8,6,9],[6,10,6,11],[6,12,6,13],[6,14,6,15],[6,16,6,17],[7,0,7,5],[7,6,7,7],[7,8,7,9],[7,10,7,11],[7,12,7,13],[7,14,7,15],[7,16,7,17],[8,0,8,5],[8,6,8,7],[8,8,8,9],[8,10,8,11],[8,12,8,13],[8,14,8,15],[8,16,8,17],[9,0,9,5],[9,6,9,7],[9,8,9,9],[9,10,9,11],[9,12,9,13],[9,14,9,15],[9,16,9,17],[10,0,10,5],[10,6,10,7],[10,8,10,9],[10,10,10,11],[10,12,10,13],[10,14,10,15],[10,16,10,17],[11,0,11,5],[11,6,11,7],[11,8,11,9],[11,10,11,11],[11,12,11,13],[11,14,11,15],[11,16,11,17],[12,0,12,5],[12,6,12,7],[12,8,12,9],[12,10,12,11],[12,12,12,13],[12,14,12,15],[12,16,12,17],[13,0,13,5],[13,6,13,7],[13,8,13,9],[13,10,13,11],[13,12,13,13],[13,14,13,15],[13,16,13,17],[14,0,14,5],[14,6,14,7],[14,8,14,9],[14,10,14,11],[14,12,14,13],[14,14,14,15],[14,16,14,17],[15,0,15,5],[15,6,15,7],[15,8,15,9],[15,10,15,11],[15,12,15,13],[15,14,15,15],[15,16,15,17],[16,0,16,5],[16,6,16,7],[16,8,16,9],[16,10,16,11],[16,12,16,13],[16,14,16,15],[16,16,16,17],[18,6,18,7],[18,8,18,9],[18,10,18,11],[18,12,18,13],[18,14,18,15],[18,16,18,17],[19,0,19,5],[19,6,19,7],[19,8,19,9],[19,10,19,11],[19,12,19,13],[19,14,19,15],[19,16,19,17],[20,0,20,5],[20,6,20,7],[20,8,20,9],[20,10,20,11],[20,12,20,13],[20,14,20,15],[20,16,20,17],[21,0,21,5],[21,6,21,7],[21,8,21,9],[21,10,21,11],[21,12,21,13],[21,14,21,15],[21,16,21,17],[22,0,22,5],[22,6,22,7],[22,8,22,9],[22,10,22,11],[22,12,22,13],[22,14,22,15],[22,16,22,17],[23,0,23,5],[23,6,23,7],[23,8,23,9],[23,10,23,11],[23,12,23,13],[23,14,23,15],[23,16,23,17],[24,0,24,5],[24,6,24,7],[24,8,24,9],[24,10,24,11],[24,12,24,13],[24,14,24,15],[24,16,24,17],[25,0,25,5],[25,6,25,7],[25,8,25,9],[25,10,25,11],[25,12,25,13],[25,14,25,15],[25,16,25,17],[26,0,26,5],[26,6,26,7],[26,8,26,9],[26,10,26,11],[26,12,26,13],[26,14,26,15],[26,16,26,17],[27,0,27,5],[27,6,27,7],[27,8,27,9],[27,10,27,11],[27,12,27,13],[27,14,27,15],[27,16,27,17],[28,0,28,5],[28,6,28,7],[28,8,28,9],[28,10,28,11],[28,12,28,13],[28,14,28,15],[28,16,28,17]]}
["FOR THE PERIOD STARTING APRIL",{"$nulls":6},"INDIVIDUAL STATE VEHICLE REPORT",{"$nulls":9}," "]
["YR/MAKE:",{"$nulls":3},"LIC #:",{"$nulls":4},"ADDED TO FLEET",{"$nulls":3},"AGENCY NAME:"]
["MODEL/BODY STYLE:",{"$nulls":8},"CHECK ONE",{"$nulls":3},"AGENCY CODE:"]
["MFG. SERIAL # (VIN):",{"$nulls":8},"NEW","USED","USED",null,"PREPARED BY:"]
["LOCATION (DEPARTMENT):",{"$nulls":8},"DATE ADDED:",{"$nulls":3},"DATE DISPOSED OF:"]
[]
[{"$nulls":6},"APRIL",null,"MAY",null,"JUNE",null,"JULY",null,"AUGUST",null,"SEPTEMBER"]
["A.  NATURE OF USE",{"$nulls":7}," ",null," ",null," ",null," "]
["B.  MAINTENANCE AND REPAIR COST"]
["C.  INSURANCE COST"]
["D.  TOTAL FUEL COST"]
["E.  TOTAL COST (B+C+D)",{"$nulls":5},{"$f":"G9+G10+G11","v":0},null,{"$f":"I9+I10+I11","v":0},null,{"$f":"K9+K10+K11","v":0},null,{"$f":"M9+M10+M11","v":0},null,{"$f":"O9+O10+O11","v":0},null,{"$f":"Q9+Q10+Q11","v":0}]
["F.  ENDING MILEAGE"]
["G.  BEGINNING MILEAGE"]
["H.  TOTAL MILEAGE FOR MONTH (F-G)",{"$nulls":5},{"$f":"G13-G14","v":0},null,{"$f":"I13-I14","v":0},null,{"$f":"K13-K14","v":0},null,{"$f":"M13-M14","v":0},null,{"$f":"O13-O14","v":0},null,{"$f":"Q13-Q14","v":0}]
["I.  GALLONS OF FUEL"]
["J.  MILES PER GALLON (H/I) (OPTIONAL)",{"$nulls":5},{"$f":"G15/G16","v":{"$error":"#DIV/0!"}},null,{"$f":"I15/I16","v":{"$error":"#DIV/0!"}},null,{"$f":"K15/K16","v":{"$error":"#DIV/0!"}},null,{"$f":"M15/M16","v":{"$error":"#DIV/0!"}},null,{"$f":"O15/O16","v":{"$error":"#DIV/0!"}},null,{"$f":"Q15/Q16","v":{"$error":"#DIV/0!"}}]
[]
[{"$nulls":6},"OCTOBER",null,"NOVEMBER",null,"DECEMBER",null,"JANUARY",null,"FEBRUARY",null,"MARCH"]
["A.  NATURE OF USE"]
["B.  MAINTENANCE AND REPAIR COST"]
["C.  INSURANCE COST"]
["D.  TOTAL FUEL COST"]
["E.  TOTAL COST (B+C+D)",{"$nulls":5},{"$f":"G21+G22+G23","v":0},null,{"$f":"I21+I22+I23","v":0},null,{"$f":"K21+K22+K23","v":0},null,{"$f":"M21+M22+M23","v":0},null,{"$f":"O21+O22+O23","v":0},null,{"$f":"Q21+Q22+Q23","v":0}]
["F.  ENDING MILEAGE"]
["G.  BEGINNING MILEAGE",{"$nulls":23},"  "]
["H.  TOTAL MILEAGE FOR MONTH (F-G)",{"$nulls":5},{"$f":"G25-G26","v":0},null,{"$f":"I25-I26","v":0},null,{"$f":"K25-K26","v":0},null,{"$f":"M25-M26","v":0},null,{"$f":"O25-O26","v":0},null,{"$f":"Q25-Q26","v":0}]
["I.  GALLONS OF FUEL"]
["J.  MILES PER GALLON (H/I) (OPTIONAL)",{"$nulls":5},{"$f":"G27/G28","v":{"$error":"#DIV/0!"}},null,{"$f":"I27/I28","v":{"$error":"#DIV/0!"}},null,{"$f":"K27/K28","v":{"$error":"#DIV/0!"}},null,{"$f":"M27/M28","v":{"$error":"#DIV/0!"}},null,{"$f":"O27/O28","v":{"$error":"#DIV/0!"}},null,{"$f":"Q27/Q28","v":{"$error":"#DIV/0!"}}]

{"sheet":"Mileage Chargeback","index":2,"n_rows":45,"n_cols":12,"rows_kept":45,"merged":[[12,0,12,9],[14,0,14,9],[15,0,15,4],[16,0,16,4],[17,0,17,4],[18,0,18,4],[19,0,19,4],[20,0,20,4],[21,0,21,8],[25,0,25,9],[26,0,26,4],[27,0,27,4],[28,0,28,4],[29,0,29,4],[30,0,30,4],[31,0,31,4],[32,0,32,6],[35,0,38,7]]}
[]
[{"$nulls":7},"      Mileage Chargeback Worksheet"]
[]
[]
[]
[]
["Last 4 digits of Vin #",null,"_________________",{"$nulls":4},"Month, Year","_______________________"]
["License Plate #",null,"_________________",{"$nulls":4},"Prepared by:","_______________________"]
["Department",null,"_________________",{"$nulls":4},"Date:","_______________________"]
["Vehicle Description",null,"_________________"]
[]
[]
["Distribution of Charges"]
[]
["Distribution by Number of Miles"]
["Fund Name",{"$nulls":4},"Fund #","Org #","# of Miles","Rate","Total"]
[{"$nulls":9},{"$f":"H17*I17","v":0}]
[{"$nulls":9},{"$f":"H18*I18","v":0}]
[{"$nulls":9},0]
[{"$nulls":9},0]
[{"$nulls":9},{"$f":"H21*I21","v":0}]
["Total",{"$nulls":8},{"$f":"SUM(J17:J21)","v":0}]
[]
[{"$nulls":5},"OR"]
[]
["Distribution by Percentage of Mileage"]
["Fund Name",{"$nulls":4},"Fund #","Org #","% of Miles","Rate","Total"]
[{"$nulls":9},{"$f":"$J$33*H28*I28","v":0}]
[{"$nulls":9},{"$f":"$J$33*H29*I29","v":0}]
[{"$nulls":9},{"$f":"$J$33*H30*I30","v":0}]
[{"$nulls":9},0]
[{"$nulls":9},{"$f":"$J$33*H32*I32","v":0}]
["Total % Should equal 100",{"$nulls":6},{"$f":"SUM(H28:H32)","v":{"v":0,"d":"0%"}},{"$nulls":3},"Enter Total Mileage"]
[]
[]
["Instructions:  Complete this form monthly.  Attach to Vehicle Travel Log and e-mail to the Accounts Receivable department by the 5th working day of each month.  Please see mileage rates below."]
[]
[]
[]
[]
[]
["Mileage Rates by Vehicle Type:"]
["Cars & 1/2 Ton Pickups = .42"]
["3/4 Ton Pickups & Minivans = .46"]
["1 Ton Pickups & 12 Passenger Vans= .49"]