{"text_format":"1","workbook":"xlsx","n_sheets":13,"sheets":["NOTICE","Purpose","Worksheet","VSM","Vehicle Cost","MAIN","Vehicle Data","Headcount","Lists","Photos","vData","vData (2)","Lists (Hide)"],"not_rendered":{"charts":0,"images":23,"macros":1,"external_links":2,"defined_names":123,"comments":1,"pivot_tables":1},"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":"NOTICE","index":0,"n_rows":11,"n_cols":2,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"NOTE: This file is designed to support the use of SCTE 225 2020. The SCTE does not provide any warranty of accuracy or support with the use of this tool."]

{"sheet":"Purpose","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Worksheet","index":2,"n_rows":15,"n_cols":1,"rows_kept":15,"cut":false,"hidden":false,"merged":[[0,0,1,0],[0,1,1,3],[0,4,1,4]]}
["Job Description"]
[]
["Location (City, State)"]
["Participants"]
["1. Max Load Required (lbs.) \n(Enter total weight of material, tools and equipment in vehicle.)"]
["2. Towing Required (Yes/No)"]
["3. Max # of Passengers seats"]
["4. Storage Space Required\n• Small – Trunk of Car\n• Medium – SUV Trunk\n• Large – Van or Truck Bed\n"]
["5. Ladder Rack Required (Yes/No)"]
["6. Up-Fit Type Required\n• Tech Van Up-fit – Vehicle may serve as Spare Tech Van\n• Utility – Any other Upfit needed\n• No Up-fit\n"]
["7. Average Miles Traveled per Day"]
["8. % Urban Driving Daily"]
["9. Total # of Employees in Job Type"]
["10. Alternative Fuel Preference \n(Yes/No, If Yes, select: CNG, LPG or Electric)"]
["Additional Comments\n(Include other pertinent criteria such \n as, 4WD, Towing Capacity, Extreme\n Vehicle Loads, etc.)\n"]

{"sheet":"VSM","index":3,"n_rows":8,"n_cols":10,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,0,2,0],[0,7,0,8],[0,0,0,6]]}
["Vehicle Selection Matrix",null,null,null,null,null,null,"Job Description:"]
["Vehicle List","Max Load (lbs.)"," Towing Required","Storage Space Required","Upfit Type Required","Max # of Passengers","Average Miles Traveled Per Day","Ladder Rack Required","% City Driving","Make & Model"]
[null,1000,"No","Large","Tech Van",1,1000,"Yes",10,{"$f":"IF(C3=\"Yes\",INDEX(Table14916[Make Model],MATCH(MIN(ABS(Table14916[Max Payload]-VSM!B3)),ABS(Table14916[Max Payload]-VSM!B3),0)),IF(E3=\"Tech Van\",INDEX(Table14914[Make Model],MATCH(MIN(ABS(Table14914[Max Payload]-VSM!B3)),ABS(Table14914[Max Payload]-VSM!B3),0)),IF(E3=\"Utility\",INDEX(Table14915[Make Model],MATCH(MIN(ABS(Table14915[Max Payload]-VSM!B3)),ABS(Table14915[Max Payload]-VSM!B3),0)),IF(D3=\"Large\",INDEX(Table14911[Make Model],MATCH(MIN(ABS(Table14911[Max Payload]-B3)),ABS(Table14911[Max Payload]-B3),0)),IF(D3=\"Medium\",INDEX(Table1493[Make Model],MATCH(MIN(ABS(Table1493[Max Payload]-B3)),ABS(Table1493[Max Payload]-B3),0)),IF(D3=\"Small\",INDEX(Table149[Make Model],MATCH(MIN(ABS(Table149[Max Payload]-VSM!B3)),ABS(Table149[Max Payload]-VSM!B3),0)),IF(F3>1,INDEX(Table14917[Make Model],MATCH(MIN(ABS(Table14917[Max Payload]-B3)),ABS(Table14917[Max Payload]-B3),0)))))))))","v":"GM Express 2500"}]
["Priory Weight:",1,2,3,4,6,8,5,7]
["Interim Calculation",{"$f":"INDEX(Table149[Make Model],MATCH(MIN(ABS(Table149[Max Payload]-VSM!B3)),ABS(Table149[Max Payload]-VSM!B3),0))","v":"Ford Edge SE"},{"$f":"IF(C3=\"Yes\",INDEX(Table14916[Make Model],MATCH(MIN(ABS(Table14916[Max Payload]-VSM!B3)),ABS(Table14916[Max Payload]-VSM!B3),0)),INDEX(Table149[Make Model],MATCH(MIN(ABS(Table149[Max Payload]-VSM!B3)),ABS(Table149[Max Payload]-VSM!B3),0)))","v":"Ford Edge SE"},{"$f":"IF(C3=\"Yes\",INDEX(Table14916[Make Model],MATCH(MIN(ABS(Table14916[Max Payload]-VSM!B3)),ABS(Table14916[Max Payload]-VSM!B3),0)),IF(D3=\"Large\",INDEX(Table14911[Make Model],MATCH(MIN(ABS(Table14911[Max Payload]-B3)),ABS(Table14911[Max Payload]-B3),0)),IF(D3=\"Medium\",INDEX(Table1493[Make Model],MATCH(MIN(ABS(Table1493[Max Payload]-B3)),ABS(Table1493[Max Payload]-B3),0)),IF(D3=\"Small\",INDEX(Table149[Make Model],MATCH(MIN(ABS(Table149[Max Payload]-VSM!B3)),ABS(Table149[Max Payload]-VSM!B3),0))))))","v":"GM Express 2500"},{"$f":"IF(C3=\"Yes\",INDEX(Table14916[Make Model],MATCH(MIN(ABS(Table14916[Max Payload]-VSM!B3)),ABS(Table14916[Max Payload]-VSM!B3),0)),IF(E3=\"Tech Van\",INDEX(Table14914[Make Model],MATCH(MIN(ABS(Table14914[Max Payload]-VSM!B3)),ABS(Table14914[Max Payload]-VSM!B3),0)),IF(E3=\"Utility\",INDEX(Table14915[Make Model],MATCH(MIN(ABS(Table14915[Max Payload]-VSM!B3)),ABS(Table14915[Max Payload]-VSM!B3),0)),IF(D3=\"Large\",INDEX(Table14911[Make Model],MATCH(MIN(ABS(Table14911[Max Payload]-B3)),ABS(Table14911[Max Payload]-B3),0)),IF(D3=\"Medium\",INDEX(Table1493[Make Model],MATCH(MIN(ABS(Table1493[Max Payload]-B3)),ABS(Table1493[Max Payload]-B3),0)),IF(D3=\"Small\",INDEX(Table149[Make Model],MATCH(MIN(ABS(Table149[Max Payload]-VSM!B3)),ABS(Table149[Max Payload]-VSM!B3),0))))))))","v":"GM Express 2500"},{"$f":"IF(F3>1,INDEX(Table14917[Make Model],MATCH(MIN(ABS(Table14917[Max Payload]-B3)),ABS(Table14917[Max Payload]-B3),0)),IF(C3=\"Yes\",INDEX(Table14916[Make Model],MATCH(MIN(ABS(Table14916[Max Payload]-VSM!B3)),ABS(Table14916[Max Payload]-VSM!B3),0)),IF(E3=\"Tech Van\",INDEX(Table14914[Make Model],MATCH(MIN(ABS(Table14914[Max Payload]-VSM!B3)),ABS(Table14914[Max Payload]-VSM!B3),0)),IF(E3=\"Utility\",INDEX(Table14915[Make Model],MATCH(MIN(ABS(Table14915[Max Payload]-VSM!B3)),ABS(Table14915[Max Payload]-VSM!B3),0)),IF(D3=\"Large\",INDEX(Table14911[Make Model],MATCH(MIN(ABS(Table14911[Max Payload]-B3)),ABS(Table14911[Max Payload]-B3),0)),IF(D3=\"Medium\",INDEX(Table1493[Make Model],MATCH(MIN(ABS(Table1493[Max Payload]-B3)),ABS(Table1493[Max Payload]-B3),0)),IF(D3=\"Small\",INDEX(Table149[Make Model],MATCH(MIN(ABS(Table149[Max Payload]-VSM!B3)),ABS(Table149[Max Payload]-VSM!B3),0)))))))))","v":"GM Express 2500"}]
[null,{"$f":"IF(B3>1183,\"SUV max haul weight passed\",\"\")","v":""},{"$f":"IF(C3=\"Yes\",\"Towing requires pickup\",\"\")","v":""},null,null,{"$f":"IF(F3>1,\"Passenger seats excceded for vans\",\"\")","v":""},null,null,{"$f":"IF(I3>=60,\"Smaller vehicle suggested if possible\",\"\")","v":""}]
[null,{"$f":"IF(B3>1710,\"Pickup max haul weight passed\",\"\")","v":""}]
["Default Values:",100,"No","Small","No Upfit",0,10,"No",10]

{"sheet":"Vehicle Cost","index":4,"n_rows":12,"n_cols":12,"rows_kept":12,"cut":false,"hidden":false,"merged":[[7,8,7,9],[11,6,11,7],[0,0,0,11]]}
["Vehicle Cost"]
["Job Description","Type","Model (2015 Year)","Base Cost","Van Upfit Cost","Non Van Upfit Cost","Alt Fuel","Alt Fuel Cost","Total Vehicle Cost","Number of Mgrs/Sups","Total Cost","Alt Fuel State Recommendation"]
["Supv, NetMaint","Van","Express 2500 (AFV Capable)",{"$f":"IFERROR(VLOOKUP(C3,Lists!$I$8:$J$29,2,FALSE),0)","v":31205},{"$f":"IF(B3=\"Van\",6800,0)","v":6800},{"$f":"IF(B3=\"Van\",0,2060)","v":0},"None",{"$f":"IFERROR(VLOOKUP(G3,Lists!$F$4:$G$9,2,FALSE),0)","v":0},{"$f":"IFERROR(IF(D3+E3+F3+H3>20000,D3+E3+F3+H3,0),0)","v":38005},null,{"$f":"IFERROR(I3*J3,\"\")","v":0},{"$f":"IF(G3=\"CNG Dedicated\", \"Only in CA and UT\", \"No Specific Recommendation\")","v":"No Specific Recommendation"}]
["Supv, NetMaint","Pickup","Silverado Crew Cab 4WD (AFV Capable)",{"$f":"IFERROR(VLOOKUP(C4,Lists!$I$8:$J$29,2,FALSE),0)","v":40460},{"$f":"IF(B4=\"Van\",6800,0)","v":0},500,"CNG Bi-Fuel",{"$f":"IFERROR(VLOOKUP(G4,Lists!$F$4:$G$9,2,FALSE),0)","v":10000},{"$f":"IFERROR(IF(D4+E4+F4+H4>20000,D4+E4+F4+H4,0),0)","v":50960},50,{"$f":"IFERROR(I4*J4,\"\")","v":2548000},{"$f":"IF(G4=\"CNG Dedicated\", \"Only in CA and UT\", \"No Specific Recommendation\")","v":"No Specific Recommendation"}]
["Mgr, NetMaint","Pickup","F-150 SuperCrew 4WD (AFV Capable)",{"$f":"IFERROR(VLOOKUP(C5,Lists!$I$8:$J$29,2,FALSE),0)","v":37585},{"$f":"IF(B5=\"Van\",6800,0)","v":0},0,"None",{"$f":"IFERROR(VLOOKUP(G5,Lists!$F$4:$G$9,2,FALSE),0)","v":0},{"$f":"IFERROR(IF(D5+E5+F5+H5>20000,D5+E5+F5+H5,0),0)","v":37585},null,{"$f":"IFERROR(I5*J5,\"\")","v":0},{"$f":"IF(G5=\"CNG Dedicated\", \"Only in CA and UT\", \"No Specific Recommendation\")","v":"No Specific Recommendation"}]
["Mgr, Inst","SUV","Edge SE AWD",{"$f":"IFERROR(VLOOKUP(C6,Lists!$I$8:$J$29,2,FALSE),0)","v":29595},{"$f":"IF(B6=\"Van\",6800,0)","v":0},0,"None",{"$f":"IFERROR(VLOOKUP(G6,Lists!$F$4:$G$9,2,FALSE),0)","v":0},{"$f":"IFERROR(IF(D6+E6+F6+H6>20000,D6+E6+F6+H6,0),0)","v":29595},null,{"$f":"IFERROR(I6*J6,\"\")","v":0},{"$f":"IF(G6=\"CNG Dedicated\", \"Only in CA and UT\", \"No Specific Recommendation\")","v":"No Specific Recommendation"}]
[]
[null,null,null,null,null,null,null,null,"Total Cost: ",null,{"$f":"SUM(K3:K6)","v":2548000}]
[]
[]
[]
[null,null,{"$f":"A3","v":"Supv, NetMaint"},{"$f":"A4","v":"Supv, NetMaint"},null,null,{"$f":"A5","v":"Mgr, NetMaint"},null,null,null,{"$f":"A6","v":"Mgr, Inst"}]

{"sheet":"MAIN","index":5,"n_rows":25,"n_cols":12,"rows_kept":25,"cut":false,"hidden":true,"merged":[[0,0,0,10],[7,0,7,10],[17,0,17,10]]}
["Tech Supervisors",null,null,null,null,null,null,null,null,null,null,1511]
["Make","Model","Drivetrain","Vehicle Type","Configuration","Engine","Vehicle Base Cost","Fuel Type","AFV Upfit Cost","Equipment Upfit Cost","Total Cost/Per Vehicle","Consolidated RJ/RV Total Cost"]
["GM","Express 2500",null,"Van",null,"4.8L",30210,"Hybrid Electric",8000,6800,{"$f":"G3+I3+J3","v":45010},{"$f":"K3*$L$1","v":68010110}]
["Ford","Transit T-250",null,"Van",null,"3.7L",30685,"Hybrid Electric",8000,6800,{"$f":"G4+I4+J4","v":45485},{"$f":"K4*$L$1","v":68727835}]
["Ford","Transit T-250",null,"Van",null,"3.7L",31000,"CNG",10000,6800,{"$f":"G5+I5+J5","v":47800},{"$f":"K5*$L$1","v":72225800}]
["GM","Express 2500",null,"Van","Bi-Fuel","6.0L",31205,"CNG",10000,6800,{"$f":"G6+I6+J6","v":48005},{"$f":"K6*$L$1","v":72535555}]
["GM","Express 2500",null,"Van","3-Tank Dedicated","6.0L",44995,"CNG",0,6800,{"$f":"G7+I7+J7","v":51795},{"$f":"K7*$L$1","v":78262245}]
["Line Supervisors",null,null,null,null,null,null,null,null,null,null,358]
["Make","Model","Drivetrain","Vehicle Type","Configuration","Engine","Vehicle Base Cost","Fuel Type","Fuel Type Upfit Cost","Equipment Upfit Cost","Total Cost/Per Vehicle","Consolidated RJ/RV Total Cost"]
["Ford","F-150 XL, SuperCab","4x2","Pickup",null,"2.7L",30655,"Hybrid Electric",8000,1500,{"$f":"G10+I10+J10","v":40155},{"$f":"K10*$L$8","v":14375490}]
["GM","Silverado 1500 WT Double Cab","4x2","Pickup",null,"4.3L",31390,"Hybrid Electric",8000,1500,40890,14638620]
["Ford","F-150 XL, SuperCab","4x2","Pickup",null,"5.0L ",31455,"CNG",10000,1500,42955,15377890]
["Ford","F-150 XL, SuperCab","4x4","Pickup",null,"2.7L",34080,"Hybrid Electric",8000,1500,43580,15601640]
["GM","Silverado 1500 WT Double Cab","4x2","Pickup",null,"5.3 DI",32585,"CNG",10000,1500,44085,15782430]
["GM","Silverado 1500 WT Double Cab","4x4","Pickup",null,"4.3L",35370,"Hybrid Electric",8000,1500,44870,16063460]
["Ford","F-150 XL, SuperCab","4x4","Pickup",null,"5.0L ",34880,"CNG",10000,1500,46380,16604040]
["GM","Silverado 1500 WT Double Cab","4x4","Pickup",null,"5.3 DI",36565,"CNG",10000,1500,48065,17207270]
["Managers",null,null,null,null,null,null,null,null,null,null,61]
["Make","Model","Drivetrain","Vehicle Type","Configuration","Engine","Vehicle Base Cost","Fuel Type","Fuel Type Upfit Cost","Equipment Upfit Cost","Total Cost/Per Vehicle","Consolidated RJ/RV Total Cost"]
["GM","Equinox L","FWD","SUV","31.5 Cu Ft, 182HP @ 6700 RPM, 22/32","2.4L",22120,"Gasoline",0,1500,{"$f":"G20+I20+J20","v":23620},{"$f":"K20*$L$18","v":1440820}]
["Subaru","XV Crosstrek 2.0i Premium","AWD","SUV","22.3 Cu Ft, 148HP @ 6200 RPM, 26/34","2.0L",23295,"Gasoline",0,1500,24795,1512495]
["Subaru","XV Crosstrek","AWD","SUV","21.5 Cu Ft, 160HP @ 6000 RPM, 30/34","2.0L",25995,"Hybrid",0,1500,27495,1677195]
["GM","Equinox LS","AWD","SUV","31.5 Cu Ft, 182HP @ 6700 RPM, 20/29","2.4L",26270,"Gasoline",0,1500,27770,1693970]
["Ford","Edge SE","FWD","SUV","39.2 Cu Ft, 245HP @ 5500 RPM, 20/30","2.0L",28100,"Gasoline",0,1500,29600,1805600]
["Ford","Edge SE","AWD","SUV","39.2 Cu Ft, 245HP @ 5500 RPM, 20/28","2.0L",29595,"Gasoline",0,1500,31095,1896795]

{"sheet":"Vehicle Data","index":6,"n_rows":41,"n_cols":11,"rows_kept":41,"cut":false,"hidden":true,"merged":[]}
["Make","Model","Drivetrain","Vehicle Type","Configuration","Engine","Vehicle Base Cost","Fuel Type","Fuel Type Upfit Cost","Equipment Upfit Cost","Total Cost/Per Vehicle"]
["Ford","Edge SE","FWD","SUV","39.2 Cu Ft, 245HP @ 5500 RPM, 20/30","2.0L",28100,"Gasoline",0,1500,{"$f":"G2+I2+Table1418[[#This Row],[Equipment Upfit Cost]]","v":29600}]
["Ford","Edge SE","AWD","SUV","39.2 Cu Ft, 245HP @ 5500 RPM, 20/28","2.0L",29595,"Gasoline",0,1500,{"$f":"G3+I3+Table1418[[#This Row],[Equipment Upfit Cost]]","v":31095}]
["GM","Equinox L","FWD","SUV","31.5 Cu Ft, 182HP @ 6700 RPM, 22/32","2.4L",22120,"Gasoline",0,1500,{"$f":"G4+I4+Table1418[[#This Row],[Equipment Upfit Cost]]","v":23620}]
["GM","Equinox LS","AWD","SUV","31.5 Cu Ft, 182HP @ 6700 RPM, 20/29","2.4L",26270,"Gasoline",0,1500,{"$f":"G5+I5+Table1418[[#This Row],[Equipment Upfit Cost]]","v":27770}]
["GM","Express 2500",null,"Van","Bi-Fuel","6.0L",31205,"CNG",10000,6800,{"$f":"G6+I6+Table1418[[#This Row],[Equipment Upfit Cost]]","v":48005}]
["GM","Express 2500",null,"Van","3-Tank Dedicated","6.0L",44995,"CNG",0,6800,{"$f":"G7+I7+Table1418[[#This Row],[Equipment Upfit Cost]]","v":51795}]
["GM","Express 2500",null,"Van","4-Tank Dedicated","6.0L",46260,"CNG",0,6800,{"$f":"G8+I8+Table1418[[#This Row],[Equipment Upfit Cost]]","v":53060}]
["GM","Express 2500",null,"Van",null,"4.8L",30210,"Hybrid Electric",8000,6800,{"$f":"G9+I9+Table1418[[#This Row],[Equipment Upfit Cost]]","v":45010}]
["GM","Express 2500",null,"Van",null,"6.0L",31205,"Hybrid Electric",8000,6800,{"$f":"G10+I10+Table1418[[#This Row],[Equipment Upfit Cost]]","v":46005}]
["Ford","F-150 XL, Regular Cab","4x2","Pickup",null,"3.5L",25800,"Hybrid Electric",8000,1500,{"$f":"G11+I11+Table1418[[#This Row],[Equipment Upfit Cost]]","v":35300}]
["Ford","F-150 XL, Regular Cab","4x4","Pickup",null,"3.5L",30445,"Hybrid Electric",8000,1500,{"$f":"G12+I12+Table1418[[#This Row],[Equipment Upfit Cost]]","v":39945}]
["Ford","F-150 XL, SuperCab","4x2","Pickup",null,"5.0L ",31455,"CNG",10000,1500,{"$f":"G13+I13+Table1418[[#This Row],[Equipment Upfit Cost]]","v":42955}]
["Ford","F-150 XL, SuperCab","4x4","Pickup",null,"5.0L ",34880,"CNG",10000,1500,{"$f":"G14+I14+Table1418[[#This Row],[Equipment Upfit Cost]]","v":46380}]
["Ford","F-150 XL, SuperCab","4x2","Pickup",null,"3.5L",29860,"Hybrid Electric",8000,1500,{"$f":"G15+I15+Table1418[[#This Row],[Equipment Upfit Cost]]","v":39360}]
["Ford","F-150 XL, SuperCab","4x2","Pickup",null,"2.7L",30655,"Hybrid Electric",8000,1500,{"$f":"G16+I16+Table1418[[#This Row],[Equipment Upfit Cost]]","v":40155}]
["Ford","F-150 XL, SuperCab","4x4","Pickup",null,"3.5L",33285,"Hybrid Electric",8000,1500,{"$f":"G17+I17+Table1418[[#This Row],[Equipment Upfit Cost]]","v":42785}]
["Ford","F-150 XL, SuperCab","4x4","Pickup",null,"2.7L",34080,"Hybrid Electric",8000,1500,{"$f":"G18+I18+Table1418[[#This Row],[Equipment Upfit Cost]]","v":43580}]
["Ford","F-150 XL, SuperCrew","4x2","Pickup",null,"5.0L ",34225,"CNG",10000,1500,{"$f":"G19+I19+Table1418[[#This Row],[Equipment Upfit Cost]]","v":45725}]
["Ford","F-150 XL, SuperCrew","4x4","Pickup",null,"5.0L ",37585,"CNG",10000,1500,{"$f":"G20+I20+Table1418[[#This Row],[Equipment Upfit Cost]]","v":49085}]
["Ford","F-150 XL, SuperCrew","4x2","Pickup",null,"2.7L",33425,"Hybrid Electric",8000,1500,{"$f":"G21+I21+Table1418[[#This Row],[Equipment Upfit Cost]]","v":42925}]
["Ford","F-150 XL, SuperCrew","4x2","Pickup",null,"5.0L ",34225,"Hybrid Electric",8000,1500,{"$f":"G22+I22+Table1418[[#This Row],[Equipment Upfit Cost]]","v":43725}]
["Ford","F-150 XL, SuperCrew","4x4","Pickup",null,"5.0L ",37585,"Hybrid Electric",8000,1500,{"$f":"G23+I23+Table1418[[#This Row],[Equipment Upfit Cost]]","v":47085}]
["GM","Silverado 1500 WT Crew Cab","4x2","Pickup",null,"5.3 DI",37310,"CNG",10000,1500,{"$f":"G24+I24+Table1418[[#This Row],[Equipment Upfit Cost]]","v":48810}]
["GM","Silverado 1500 WT Crew Cab","4x4","Pickup",null,"5.3 DI",40460,"CNG",10000,1500,{"$f":"G25+I25+Table1418[[#This Row],[Equipment Upfit Cost]]","v":51960}]
["GM","Silverado 1500 WT Crew Cab","4x2","Pickup",null,"4.3L",36115,"Hybrid Electric",8000,1500,{"$f":"G26+I26+Table1418[[#This Row],[Equipment Upfit Cost]]","v":45615}]
["GM","Silverado 1500 WT Crew Cab","4x2","Pickup",null,"5.3 DI",37310,"Hybrid Electric",8000,1500,{"$f":"G27+I27+Table1418[[#This Row],[Equipment Upfit Cost]]","v":46810}]
["GM","Silverado 1500 WT Crew Cab","4x4","Pickup",null,"4.3L",39265,"Hybrid Electric",8000,1500,{"$f":"G28+I28+Table1418[[#This Row],[Equipment Upfit Cost]]","v":48765}]
["GM","Silverado 1500 WT Crew Cab","4x4","Pickup",null,"5.3 DI",40460,"Hybrid Electric",8000,1500,{"$f":"G29+I29+Table1418[[#This Row],[Equipment Upfit Cost]]","v":49960}]
["GM","Silverado 1500 WT Double Cab","4x2","Pickup",null,"5.3 DI",32585,"CNG",10000,1500,{"$f":"G30+I30+Table1418[[#This Row],[Equipment Upfit Cost]]","v":44085}]
["GM","Silverado 1500 WT Double Cab","4x4","Pickup",null,"5.3 DI",36565,"CNG",10000,1500,{"$f":"G31+I31+Table1418[[#This Row],[Equipment Upfit Cost]]","v":48065}]
["GM","Silverado 1500 WT Double Cab","4x2","Pickup",null,"4.3L",31390,"Hybrid Electric",8000,1500,{"$f":"G32+I32+Table1418[[#This Row],[Equipment Upfit Cost]]","v":40890}]
["GM","Silverado 1500 WT Double Cab","4x2","Pickup",null,"5.3 DI",32585,"Hybrid Electric",8000,1500,{"$f":"G33+I33+Table1418[[#This Row],[Equipment Upfit Cost]]","v":42085}]
["GM","Silverado 1500 WT Double Cab","4x4","Pickup",null,"4.3L",35370,"Hybrid Electric",8000,1500,{"$f":"G34+I34+Table1418[[#This Row],[Equipment Upfit Cost]]","v":44870}]
["GM","Silverado 1500 WT Double Cab","4x4","Pickup",null,"5.3 DI",36565,"Hybrid Electric",8000,1500,{"$f":"G35+I35+Table1418[[#This Row],[Equipment Upfit Cost]]","v":46065}]
["Ford","Transit Connect XL LWB",null,"Van",null,"2.5L",23645,"CNG",10000,6800,{"$f":"G36+I36+Table1418[[#This Row],[Equipment Upfit Cost]]","v":40445}]
["Ford","Transit Connect XL LWB",null,"Van",null,"2.5L",23330,"Hybrid Electric",8000,6800,{"$f":"G37+I37+Table1418[[#This Row],[Equipment Upfit Cost]]","v":38130}]
["Ford","Transit T-250",null,"Van",null,"3.7L",31000,"CNG",10000,6800,{"$f":"G38+I38+Table1418[[#This Row],[Equipment Upfit Cost]]","v":47800}]
["Ford","Transit T-250",null,"Van",null,"3.7L",30685,"Hybrid Electric",8000,6800,{"$f":"G39+I39+Table1418[[#This Row],[Equipment Upfit Cost]]","v":45485}]
["Subaru","XV Crosstrek","AWD","SUV","21.5 Cu Ft, 30/34","2.0L",25995,"Hybrid",0,1500,{"$f":"G40+I40+Table1418[[#This Row],[Equipment Upfit Cost]]","v":27495}]
["Subaru","XV Crosstrek 2.0i Premium","AWD","SUV","22.3 Cu Ft, 26/34","2.0L",23295,"Gasoline",0,1500,{"$f":"G41+I41+Table1418[[#This Row],[Equipment Upfit Cost]]","v":24795}]

{"sheet":"Headcount","index":7,"n_rows":7,"n_cols":5,"rows_kept":7,"cut":false,"hidden":true,"merged":[]}
[null,"Manager, Installation ","Manager, Network Maintenance ","Supervisor, Installation","Supervisor, Network Maintenance"]
["MGR1INSTAL  "]
["MGR1NETMAINT"]
["MGR2NETMAINT"]
["SUPINSTAL   "]
["SUPNETMAINT "]
["Grand Total"]

{"sheet":"Lists","index":8,"n_rows":29,"n_cols":13,"rows_kept":29,"cut":false,"hidden":true,"merged":[]}
[]
[]
["Row Labels",null,"Supv, Inst",null,null,"Fuel Type",null,"Engine","Vehicle",null,"Make","Model","Drivetrain"]
["CNG",null,"Supv, NetMaint",null,null,"CNG Dedicated",13790,"2.0L","Pickup",null,"Ford","Equinox L","4x2"]
["Gasoline",null,"Mgr, Inst",null,null,"CNG Bi-Fuel",10000,"2.4L","SUV",null,"GM","Equinox LS","4x4"]
["Hybrid",null,"Mgr, NetMaint",null,null,"LPG Dedicated",null,"2.5L","Van",null,"Subaru","Edge SE","AWD"]
["Hybrid Electric",null,null,null,null,"LPG Bi-Fuel",6860,"2.7L",null,null,null,"Express 2500","FWD"]
["Grand Total",null,null,null,null,"None",0,"3.5L","F-150 SuperCrew 2WD (AFV Capable)",34225,"Ford Models","F-150 XL, SuperCab","(blank)"]
[null,null,null,null,null,"Hybrid Electric",8000,"3.7L","F-150 SuperCrew 4WD (AFV Capable)",37585,"Edge SE","F-150 XL, SuperCrew"]
[null,null,null,null,null,"None",0,"4.3L","F-150 SuperCrew 2WD",33425,"F-150 XL, SuperCab","Silverado 1500 WT Crew Cab"]
[null,null,null,null,null,"None",0,"4.8L","F-150 SuperCrew 4WD",37585,"F-150 XL, SuperCrew","Silverado 1500 WT Double Cab"]
[null,null,null,null,null,null,null,"5.0L ","Silverado Crew Cab 2WD (AFV Capable)",37310,"Transit Connect XL LWB","Silverado 1500 WT Regular Cab"]
[null,null,null,null,null,null,null,"5.3 DI","Silverado Crew Cab 4WD (AFV Capable)",40460,"Transit T-250","Transit Connect XL LWB"]
[null,null,null,null,null,null,null,"6.0L","Silverado Crew Cab 2WD",36115,null,"Transit T-250"]
[null,null,null,null,null,null,null,null,"Silverado Crew Cab 4WD",39265,"GM Models","XV Crosstrek"]
[null,null,null,null,null,null,null,null,null,null,"Equinox L","XV Crosstrek 2.0i Premium"]
[null,null,null,null,null,null,null,null,null,null,"Equinox LS"]
[null,null,null,null,null,null,null,null,null,null,"Express 2500"]
[null,null,null,null,null,null,null,null,"Edge SE AWD",29595,"Silverado 1500 WT Crew Cab"]
[null,null,null,null,null,null,null,null,"Edge SE FWD",28100,"Silverado 1500 WT Double Cab"]
[null,null,null,null,null,null,null,null,"Equinox LS AWD",26270,"Silverado 1500 WT Regular Cab"]
[null,null,null,null,null,null,null,null,"Equinox L FWD",22120]
[null,null,null,null,null,null,null,null,"XV Crosstrek 2.0i Premium AWD",23295,"Subaru Models"]
[null,null,null,null,null,null,null,null,"XV Crosstrek Hybrid AWD",25995,"XV Crosstrek"]
[null,null,null,null,null,null,null,null,null,null,"XV Crosstrek 2.0i Premium"]
[null,null,null,null,null,null,null,null,"Express 2500 (AFV Capable)",31205]
[null,null,null,null,null,null,null,null,"Express 2500",30210]
[null,null,null,null,null,null,null,null,"Transit T-250 (AFV Capable)",31000]
[null,null,null,null,null,null,null,null,"Transit T-250",30685]

{"sheet":"Photos","index":9,"n_rows":25,"n_cols":2,"rows_kept":25,"cut":false,"hidden":true,"merged":[]}
["Vehicle Name","Vehicle Photo"]
[]
["Express 2500 (AFV Capable)"]
["Express 2500"]
["Transit T-250 (AFV Capable)"]
["Transit T-250"]
["Transit Connect XL LWB"]
["F-150 XL, Regular Cab"]
["F-150 SuperCrew 2WD (AFV Capable)"]
["F-150 SuperCrew 4WD (AFV Capable)"]
["F-150 SuperCrew 2WD"]
["F-150 SuperCrew 4WD"]
["F-150 XL, SuperCab"]
["Silverado 1500 WT Regular Cab"]
["Silverado Crew Cab 2WD (AFV Capable)"]
["Silverado Crew Cab 4WD (AFV Capable)"]
["Silverado Crew Cab 2WD"]
["Silverado Crew Cab 4WD"]
["Silverado 1500 WT Crew Cab"]
["Edge SE AWD"]
["Edge SE FWD"]
["Equinox LS AWD"]
["Equinox L FWD"]
["XV Crosstrek 2.0i Premium AWD"]
["XV Crosstrek Hybrid AWD"]

{"sheet":"vData","index":10,"n_rows":72,"n_cols":11,"rows_kept":72,"cut":false,"hidden":true,"merged":[]}
["Make Model","Drivetrain","Ladder Rack","Storage","Pax","Upfit","Vehicle Type","Max Towing","Max Payload",null,"Only ones that can tow are pickups"]
["Ford Edge SE","2WD","No","Medium",3,"None","SUV",3500,909]
["Ford Edge SE","AWD","No","Medium",3,"None","SUV",3500,909]
["GM Equinox LS","AWD","No","Medium",3,"None","SUV",1500,1144]
["GM Equinox L","2WD","No","Medium",3,"None","SUV",1500,1183]
["Ford F-150 XL SuperCrew","2WD","Yes","Medium",3,"Utility","Pickup",7600,1600]
["Ford F-150 XL SuperCrew","4WD","Yes","Medium",3,"Utility","Pickup",7600,1600]
["Ford Transit Connect","2WD","Yes","Medium",1,"Tech","Van",2000,1620]
["GM Silverado 1500 WT Crew Cab","2WD","Yes","Medium",3,"Utility","Pickup",5500,1710]
["GM Silverado 1500 WT Crew Cab","4WD","Yes","Medium",3,"Utility","Pickup",7000,1710]
["GM Express 2500","2WD","Yes","Large",1,"Tech","Van",9900,3309]
["Ford Transit T-250","2WD","Yes","Large",1,"Tech","Van",5300,4080]
[]
["if ladder rack yes (and storage medium and large)"]
["Make Model","Drivetrain","Ladder Rack","Storage","Pax","Upfit","Vehicle Type","Max Towing","Max Payload"]
["Ford F-150 XL SuperCrew","2WD","Yes","Medium",3,"Utility","Pickup",7600,1600]
["Ford F-150 XL SuperCrew","4WD","Yes","Medium",3,"Utility","Pickup",7600,1600]
["GM Silverado 1500 WT Crew Cab","2WD","Yes","Medium",3,"Utility","Pickup",5500,1710]
["GM Silverado 1500 WT Crew Cab","4WD","Yes","Medium",3,"Utility","Pickup",7000,1710]
["GM Express 2500","2WD","Yes","Large",1,"Tech","Van",9900,3309]
["Ford Transit Connect","2WD","Yes","Medium",1,"Tech","Van",2000,1620]
["Ford Transit T-250","2WD","Yes","Large",1,"Tech","Van",5300,4080]
[]
["if Storage medium"]
["Make Model","Drivetrain","Ladder Rack","Storage","Pax","Upfit","Vehicle Type","Max Towing","Max Payload"]
["Ford F-150 XL SuperCrew","2WD","Yes","Medium",3,"Utility","Pickup",7600,1600]
["Ford F-150 XL SuperCrew","4WD","Yes","Medium",3,"Utility","Pickup",7600,1600]
["GM Silverado 1500 WT Crew Cab","2WD","Yes","Medium",3,"Utility","Pickup",5500,1710]
["GM Express 2500","2WD","Yes","Large",1,"Tech","Van",9900,3309]
["Ford Transit T-250","2WD","Yes","Large",1,"Tech","Van",5300,4080]
["GM Silverado 1500 WT Crew Cab","4WD","Yes","Medium",3,"Utility","Pickup",7000,1710]
["Ford Transit Connect","2WD","Yes","Medium",1,"Tech","Van",2000,1620]
[]
["if Storage Small"]
["Make Model","Drivetrain","Ladder Rack","Storage","Pax","Upfit","Vehicle Type","Max Towing","Max Payload"]
["GM Equinox L","2WD","No","Small",3,"None","SUV",1500,1183]
["GM Equinox LS","AWD","No","Small",3,"None","SUV",1500,1144]
["Ford Edge SE","2WD","No","Small",3,"None","SUV",3500,909]
["Ford Edge SE","AWD","No","Small",3,"None","SUV",3500,909]
[]
["if Storage Large"]
["Make Model","Drivetrain","Ladder Rack","Storage","Pax","Upfit","Vehicle Type","Max Towing","Max Payload"]
["Ford Transit T-250","2WD","Yes","Large",1,"Tech","Van",5300,4080]
["GM Express 2500","2WD","Yes","Large",1,"Tech","Van",9900,3309]
[]
["Make Model","Drivetrain","Ladder Rack","Storage","Pax","Upfit","Vehicle Type","Max Towing","Max Payload"]
["Ford Transit T-250","2WD","Yes","Large",1,"Tech","Van",5300,4080]
["GM Express 2500","2WD","Yes","Large",1,"Tech","Van",9900,3309]
[]
["Make Model","Drivetrain","Ladder Rack","Storage","Pax","Upfit","Vehicle Type","Max Towing","Max Payload"]
["GM Silverado 1500 WT Crew Cab","2WD","Yes","Medium",3,"Utility","Pickup",5500,1710]
["GM Silverado 1500 WT Crew Cab","4WD","Yes","Medium",3,"Utility","Pickup",7000,1710]
["Ford F-150 XL SuperCrew","2WD","Yes","Medium",3,"Utility","Pickup",7600,1600]
["Ford F-150 XL SuperCrew","4WD","Yes","Medium",3,"Utility","Pickup",7600,1600]
[]
["If yes for Tow"]
["Make Model","Drivetrain","Ladder Rack","Storage","Pax","Upfit","Vehicle Type","Max Towing","Max Payload"]
["GM Silverado 1500 WT Crew Cab","2WD","Yes","Medium",3,"Utility","Pickup",5500,1710]
["GM Silverado 1500 WT Crew Cab","4WD","Yes","Medium",3,"Utility","Pickup",7000,1710]
["Ford F-150 XL SuperCrew","2WD","Yes","Medium",3,"Utility","Pickup",7600,1600]
["Ford F-150 XL SuperCrew","4WD","Yes","Medium",3,"Utility","Pickup",7600,1600]
[]
["if more than 1 PAX"]
["Make Model","Drivetrain","Ladder Rack","Storage","Pax","Upfit","Vehicle Type","Max Towing","Max Payload"]
["GM Equinox L","2WD","No","Small",3,"None","SUV",1500,1183]
["GM Equinox LS","AWD","No","Small",3,"None","SUV",1500,1144]
["Ford Edge SE","2WD","No","Small",3,"None","SUV",3500,909]
["Ford Edge SE","AWD","No","Small",3,"None","SUV",3500,909]
["GM Silverado 1500 WT Crew Cab","2WD","Yes","Medium",3,"Utility","Pickup",5500,1710]
["GM Silverado 1500 WT Crew Cab","4WD","Yes","Medium",3,"Utility","Pickup",7000,1710]
["Ford F-150 XL SuperCrew","2WD","Yes","Medium",3,"Utility","Pickup",7600,1600]
["Ford F-150 XL SuperCrew","4WD","Yes","Medium",3,"Utility","Pickup",7600,1600]

{"sheet":"vData (2)","index":11,"n_rows":27,"n_cols":10,"rows_kept":27,"cut":false,"hidden":true,"merged":[]}
["Make","Model","Drivetrain","Ladder Rack","Storage","Pax","Upfit","Vehicle Type","Max Towing","Max Payload"]
["Ford","F-150 XL, SuperCrew","2WD","Yes","Medium",3,"Utility","Pickup",7600,1600]
["Ford","F-150 XL, SuperCrew","4WD","Yes","Medium",3,"Utility","Pickup",7600,1600]
["GM","Silverado 1500 WT Crew Cab","2WD","Yes","Medium",3,"Utility","Pickup",5500,1710]
["GM","Silverado 1500 WT Crew Cab","4WD","Yes","Medium",3,"Utility","Pickup",7000,1710]
["Ford","Edge SE","2WD","No","Small",3,"None","SUV",3500,909]
["Ford","Edge SE","AWD","No","Small",3,"None","SUV",3500,909]
["GM","Equinox L","2WD","No","Small",3,"None","SUV",1500,1183]
["GM","Equinox LS","AWD","No","Small",3,"None","SUV",1500,1144]
["GM","Express 2500","2WD","Yes","Large",1,"Tech","Van",9900,3309]
["Ford","Transit Connect","2WD","Yes","Medium",1,"Tech","Van",2000,1620]
["Ford","Transit T-250","2WD","Yes","Large",1,"Tech","Van",5300,4080]
[]
[]
["If ladder rack no"]
["Make","Model","Drivetrain","Ladder Rack","Storage","Pax","Upfit","Vehicle Type","Max Towing","Max Payload"]
["Ford","F-150 XL, SuperCrew","2WD","Yes","Medium",3,"Utility","Pickup",7600,1600]
["Ford","F-150 XL, SuperCrew","4WD","Yes","Medium",3,"Utility","Pickup",7600,1600]
["GM","Silverado 1500 WT Crew Cab","2WD","Yes","Medium",3,"Utility","Pickup",5500,1710]
["GM","Silverado 1500 WT Crew Cab","4WD","Yes","Medium",3,"Utility","Pickup",7000,1710]
["Ford","Edge SE","2WD","No","Small",3,"None","SUV",3500,909]
["Ford","Edge SE","AWD","No","Small",3,"None","SUV",3500,909]
["GM","Equinox L","2WD","No","Small",3,"None","SUV",1500,1183]
["GM","Equinox LS","AWD","No","Small",3,"None","SUV",1500,1144]
["GM","Express 2500","2WD","Yes","Large",1,"Tech","Van",9900,3309]
["Ford","Transit Connect","2WD","Yes","Medium",1,"Tech","Van",2000,1620]
["Ford","Transit T-250","2WD","Yes","Large",1,"Tech","Van",5300,4080]

{"sheet":"Lists (Hide)","index":12,"n_rows":35,"n_cols":9,"rows_kept":35,"cut":false,"hidden":true,"merged":[]}
["yesNO"]
["Yes",null,"Vehicle Type Recommendation","nWeight","xWeight","Haul/Tow","Pax","Ladder"]
["Pax",null,"Full Size SUV",0,700,1500,3,"Yes"]
[1,null,"Full Size Van",701,1500,2500,1,"Yes"]
[2,null,"Pickup Truck",1501,3000,3000,3,"Yes"]
[null,null,"Exceed Max Weight Limit",3001,6001,5000,1,"Yes"]
[]
[null,null,"Vehicle Type Recommendation","nWeight","xWeight","Haul/Tow","Pax","Ladder"]
[null,null,"Full Size SUV",0,700,1500,3,"Yes"]
[null,null,"Full Size Van",1201,1500,2500,1,"Yes"]
[null,null,"Pickup Truck",1501,3000,3000,3,"Yes"]
[null,null,"Exceed Max Weight Limit",3001,6001,5000,1,"Yes"]
[]
[null,null,"Vehicle Type Recommendation","nWeight","xWeight","Haul/Tow","Pax","Ladder"]
[null,null,"Full Size SUV",0,700,1500,3,"Yes"]
[null,null,"Pickup Truck",701,3000,3000,3,"Yes"]
[null,null,"Exceed Max Weight Limit",3001,6001,5000,3,"Yes"]
[]
[null,null,"Vehicle Type Recommendation","nWeight","xWeight","Haul/Tow","Pax","Ladder"]
[null,null,"Full Size SUV",0,700,1500,3,"Yes"]
[null,null,"Pickup Truck",701,3000,3000,3,"Yes"]
[null,null,"Exceed Max Weight Limit",3001,6001,5000,3,"Yes"]
[]
[null,null,"Alternative Fuels","Home Garaged","Avg Miles Per Day","% of City Miles","Invest in Private Infrastructure","Local Infrastructure Available","Emissions"]
[null,null,"Biodiesel (B20)"]
[null,null,"Ethanol (E85)"]
[null,null,"Hydrogen Fuel Cell"]
[null,null,"CNG - Dedicated"]
[null,null,"CNG - Bi-fuel"]
[null,null,"LPG - Dedicated"]
[null,null,"LPG - Bi-fuel"]
[null,null,"Electric"]
[null,null,"Plug-in Hybrid Electric"]
[null,null,"Hybrid Electric"]
[null,null,"Gasoline"]