{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Vehicle Fleet Inventory","Example","Sheet3"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"comments":0,"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":"Vehicle Fleet Inventory","index":0,"n_rows":108,"n_cols":12,"rows_kept":108,"cut":false,"hidden":false,"merged":[[0,0,0,1],[0,2,0,4],[5,9,5,11],[2,0,2,11],[3,0,3,11],[1,0,1,11]]}
["Agency Name:"]
[]
["Instructions:  Fill out the columns below for each vehicle in your agency's fleet. Please do not paste over cells that are colored orange, as these cells contain drop down menus that should be selected individually. Please include all owned and leased vehicles. If a vehicle is a backup or is not currently in active service, please mark \"Vehicle Service Hours Per Day\" as Zero in column 7. There is no need to include personal vehicles or 5310 awards that have not yet been delivered.  This completed sheet must be returned with your application in Excel format. Similar documents will not be accepted. See the second tab of this sheet, labeled \"Example,\" to view a sample completed Vehicle Fleet Inventory. All fields are required. If you have more than 100 vehicles in your fleet, please contact Samantha.M.Deal@tn.gov."]
["If you are applying for replacement vehicles, please complete the \"Replacement Vehicle Information\" portion. Use the drop-down box to identify vehicles for replacement, and the type of vehicle you have requested as the replacement in your application. Only select vehicles for replacement that you wish to replace in this application."]
[]
[null,1,2,4,5,6,7,8,9,"Replacement Vehicle Information (Fill out if applying for Replacement Vehicles)"]
[null,"List Complete VINs of Fleet Vehicles","Vehicle Make/Model","Vehicle Year","Current Mileage","Passenger Capacity (Ambulatory/Wheelchair)","Vehicle Service Hours Per Day ","Physical Location of Vehicle \n(Must be a complete street address)","How was this vehicle acquired? (Please use drop-down options)","Please identify the vehicle(s) for replacement in this application only","Requested Replacement Vehicle Type","Anticipated Physical Location of New Vehicle \n(Must be a complete street address)"]
[]
[1]
[2]
[3]
[4]
[5]
[6]
[7]
[8]
[9]
[10]
[11]
[12]
[13]
[14]
[15]
[16]
[17]
[18]
[19]
[20]
[21]
[22]
[23]
[24]
[25]
[26]
[27]
[28]
[29]
[30]
[31]
[32]
[33]
[34]
[35]
[36]
[37]
[38]
[39]
[40]
[41]
[42]
[43]
[44]
[45]
[46]
[47]
[48]
[49]
[50]
[51]
[52]
[53]
[54]
[55]
[56]
[57]
[58]
[59]
[60]
[61]
[62]
[63]
[64]
[65]
[66]
[67]
[68]
[69]
[70]
[71]
[72]
[73]
[74]
[75]
[76]
[77]
[78]
[79]
[80]
[81]
[82]
[83]
[84]
[85]
[86]
[87]
[88]
[89]
[90]
[91]
[92]
[93]
[94]
[95]
[96]
[97]
[98]
[99]
[100]

{"sheet":"Example","index":1,"n_rows":18,"n_cols":12,"rows_kept":18,"cut":false,"hidden":false,"merged":[[1,0,1,11],[2,0,2,11],[3,0,3,11],[5,9,5,11],[0,0,0,1],[0,2,0,4]]}
["Agency Name:",null,"Sample Agency"]
[]
["Instructions:  Fill out the columns below for each vehicle in your agency's fleet. Please do not paste over cells that are colored orange, as these cells contain drop down menus that should be selected individually. Please include all owned and leased vehicles. If a vehicle is a backup or is not currently in active service, please mark \"Vehicle Service Hours Per Day\" as Zero in column 7. There is no need to include personal vehicles or 5310 awards that have not yet been delivered.  This completed sheet must be returned with your application in Excel format. Similar documents will not be accepted. See the second tab of this sheet, labeled \"Example,\" to view a sample completed Vehicle Fleet Inventory. All fields are required. If you have more than 100 vehicles in your fleet, please contact Samantha.M.Deal@tn.gov."]
["If you are applying for replacement vehicles, please complete the \"Replacement Vehicle Information\" portion. Use the drop-down box to identify vehicles for replacement, and the type of vehicle you have requested as the replacement in your application. Only select vehicles for replacement that you wish to replace in this application."]
[]
[null,1,2,4,5,6,7,8,9,"Replacement Vehicle Information (Fill out if applying for Replacement Vehicles)"]
[null,"List Complete VINs of Fleet Vehicles","Vehicle Make/Model","Vehicle Year","Current Mileage","Passenger Capacity (Ambulatory/Wheelchair)","Vehicle Service Hours Per Day ","Physical Location of Vehicle \n(Must be a complete street address)","How was this vehicle acquired? (Please use drop-down options)","Please identify the vehicle(s) for replacement in this application only","Requested Replacement Vehicle Type","Anticipated Physical Location of New Vehicle \n(Must be a complete street address)"]
[]
[1,"ABCD12340000","Ford Focus",2011,129000,"3/0",6,"1 Sample Lane; Nashville 37201","Purchased with Agency Funds","Replacement","4+2","1 Sample Lane; Nashville 37201"]
[2,"ABCD12340012","Dodge Caravan",2015,65321,"6/1",6,"2 Example Street; Cookeville 38501","Purchased with Agency Funds"]
[3,"ABCD12340023","Dodge Caravan",2015,95000,"6/1",0,"1 Sample Lane; Nashville 37201","Purchased with Agency Funds"]
[4,"ABCD12340034","Ford Transit Van",2019,45716,"5/2",9,"2 Example Street; Cookeville 38501","5310 Award"]
[5,"ABCD12340045","Mazda Miata",1994,200000,"1/0",1,"1 Sample Lane; Nashville 37201","Donation","Replacement","8+2","2 Example Street; Cookeville 38501"]
[6]
[7]
[8]
[9]
[10]

{"sheet":"Sheet3","index":2,"n_rows":7,"n_cols":1,"rows_kept":7,"cut":false,"hidden":true,"merged":[]}
[]
["Purchased with Agency Funds"]
["Donation"]
["5310 Award"]
["Other Grant Award"]
["Leased Vehicle"]
["Other"]