{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Cover","Model","Information and Troubleshooting"],"not_rendered":{"charts":0,"images":5,"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":"Cover","index":0,"n_rows":34,"n_cols":4,"rows_kept":34,"cut":false,"hidden":false,"merged":[[2,2,3,11],[17,3,18,13],[20,3,22,13],[5,2,5,4],[11,3,13,13],[24,3,24,4],[25,3,26,13],[28,3,28,4],[29,3,32,13],[33,3,34,13]]}
[]
[]
[null,null,"Fleet Technology General TCO Model, Version 1.0"]
[]
[null,null,"Released October 3, 2012"]
[null,null,"RD.12/412001.1\n"]
[]
[]
[]
[null,null,null,"This model is available for the user’s individual preliminary analysis alone and may not be copied or "]
[null,null,null,"duplicated for any commercial purpose"]
[null,null,null,"Users of this spreadsheet model are responsible for ensuring validity of results and any appropriate quality checking. \nEnd users and purchasers should not rely solely on the data in this model for purchasing decisions. \nRicardo Inc. and its affiliates, officers, and employees will have no liability to any third party for an claims whatsoever arising or relating to the data or analysis\n"]
[]
[]
[null,null,null,"Ricardo provides no warranties nor guarantees on the accuracy of the data or analysis."]
[]
[null,null,null,"Model Description:"]
[null,null,null,"This model allows users to conduct a preliminary analysis of the total cost of ownership (TCO)  for  Diesel, Natural Gas, and Natural Gas Hybrid Commercial Vehicles. An approximate TCO can be calculated for a single vehicle within specified vehicle segment as well as for a fleet made up of multiple vehicles from one or more  segments. \n\n"]
[]
[null,null,null,"Fuel Economy Note:"]
[null,null,null,"The model has pre-set fuel economy values for each vehicle segment and technology. Actual fuel economy will vary significantly based on vehicle characteristics and duty cycle. Users should independently evaluate their assumptions on fuel economy and use measured values whenever possible. "]
[]
[]
[]
[null,null,null,"Fuel Price Note:"]
[null,null,null,"Fuel price values come from EIA and Clean Cities Alternative Fuel Price Reports. These prices reflect 2012 fuel prices and should be checked against current fuel pricing when the model is used. "]
[]
[]
[null,null,null,"Vehicle CAPEX Note:"]
[null,null,null,"The model includes a pre-set price estimating model for vehicle costs. For natural gas vehicles this model includes: up charges for CNG/LNG tanks, fuel system components, NG capable engines, and based on whether or not SI technology is used there are discount for the  removal of emission components. For Class 3 vehicles there is an additional discount because CNG vehicles in this class are typically based on lower cost gasoline platforms, reducing the premium for these vehicles versus an equivalent class 3 diesel. For hybrid vehicles, additional costs are included for power electronics, systems integration, and the battery pack. "]
[]
[]
[]
[null,null,null,"This Vehicle CAPEX is illustrative to enable comparative cost comparisons.  Actual vehicle prices and availability may vary significantly.  Users should validate prices with dealers"]

{"sheet":"Model","index":1,"n_rows":121,"n_cols":24,"rows_kept":121,"cut":false,"hidden":false,"merged":[[100,1,100,2],[101,1,101,2],[1,4,1,5],[2,4,2,5],[3,4,3,5],[4,21,5,23],[5,3,5,5],[6,3,6,5],[6,6,6,8],[6,9,6,11],[6,12,6,14],[6,15,6,17],[6,18,6,20],[6,21,6,23],[7,21,7,23],[14,3,14,5],[14,6,14,8],[14,9,14,11],[14,12,14,14],[14,15,14,17],[14,18,14,20],[14,21,14,23],[7,3,7,5],[7,6,7,8],[7,9,7,11],[7,12,7,14],[7,15,7,17],[7,18,7,20],[15,21,15,23],[16,3,16,5],[16,6,16,8],[16,9,16,11],[16,12,16,14],[16,15,16,17],[16,18,16,20],[16,21,16,23],[15,3,15,5],[15,6,15,8],[15,9,15,11],[15,12,15,14],[15,15,15,17],[15,18,15,20],[17,21,17,23],[18,3,18,5],[18,6,18,8],[18,9,18,11],[18,12,18,14],[18,15,18,17],[18,18,18,20],[18,21,18,23],[17,3,17,5],[17,6,17,8],[17,9,17,11],[17,12,17,14],[17,15,17,17],[17,18,17,20],[116,1,116,4],[19,21,19,23],[20,3,20,5],[20,6,20,8],[20,9,20,11],[20,12,20,14],[20,15,20,17],[20,18,20,20],[20,21,20,23],[19,3,19,5],[19,6,19,8],[19,9,19,11],[19,12,19,14],[19,15,19,17],[19,18,19,20],[99,1,99,2]]}
[null,null,null,"Legend"]
[null,null,null,"Input","Suggestion Input"]
[null,null,null,"Calculation","Suggestion Calculation"]
[null,null,null,"N/A","Optional Input"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(W78>120000,\"Natural gas consumption is high enough that in house infrastructure may offer fuel cost savings\", \"\")","v":""}]
[]
[null,"Vehicle Segment",null,"Class 3",null,null,"Class 4-6",null,null,"Class 7-8 ",null,null,"Class 6",null,null,"Class 8",null,null,"Custom",null,null,"Total Fleet"]
[null,null,null,"Delivery",null,null,"Delivery",null,null,"Delivery",null,null,"Work Truck",null,null,"Intercity",null,null,"Custom"]
[null,"Powertrain",null,"Diesel","Natural Gas","NG Hybrid","Diesel","Natural Gas","NG Hybrid","Diesel","Natural Gas","NG Hybrid","Diesel","Natural Gas","NG Hybrid","Diesel","Natural Gas","NG Hybrid","Diesel","Natural Gas","NG Hybrid","Diesel","Natural Gas","NG Hybrid"]
[null,"Single Vehicle Lifetime TCO","$/Vehicle Life",{"$f":"IF(D15=0,0,D39+D47/D15+D86)","v":61706.34656936035},{"$f":"IF(D15=0,0,E39+E47/D15+E86)","v":62613.981204112053},{"$f":"IF(D15=0,0,F39+F47/D15+F86)","v":70405.504271323443},{"$f":"IF(G15=0,0,G39+G47/G15+G86)","v":129421.44065324587},{"$f":"IF(G15=0,0,H39+H47/G15+H86)","v":140301.47278479728},{"$f":"IF(G15=0,0,I39+I47/G15+I86)","v":159461.32909616016},{"$f":"IF(J15=0,0,J39+J47/J15+J86)","v":191011.37631197789},{"$f":"IF(J15=0,0,K39+K47/J15+K86)","v":209127.82822859491},{"$f":"IF(J15=0,0,L39+L47/J15+L86)","v":227379.56966548524},{"$f":"IF(M15=0,0,M39+M47/M15+M86)","v":322365.14568735834},{"$f":"IF(M15=0,0,N39+N47/M15+N86)","v":345902.17312547064},null,{"$f":"IF(P15=0,0,P39+P47/P15+P86)","v":294776.71215465595},{"$f":"IF(P15=0,0,Q39+Q47/P15+Q86)","v":384278.07522802136},{"$f":"IF(P15=0,0,R39+R47/P15+R86)","v":370740.72284973331},{"$f":"IF(S15=0,0,S39+S47/S15+S86)","v":0},{"$f":"IF(S15=0,0,T39+T47/S15+T86)","v":0},{"$f":"IF(S15=0,0,U39+U47/S15+U86)","v":0}]
[null,"Segment TCO","$/Vehicle Life",{"$f":"D49+D87","v":617063.4656936035},626139.81204112049,704055.04271323443,129421.44065324587,140301.47278479728,159461.32909616016,191011.37631197789,209127.82822859491,227379.56966548524,322365.14568735834,345902.17312547064,null,{"$f":"P49+P87","v":294776.71215465595},384278.07522802136,370740.72284973331,0,0,0,{"$f":"D11+G11+J11+M11+P11+S11","v":1554638.1405008414},{"$f":"E11+H11+K11+N11+Q11+T11","v":1705749.361408005},1461636.6643246133]
[null,"Single Vehicle Δ with Diesel",null,{"$f":"D10-D10","v":0},{"$f":"E10-D10","v":907.63463475170283},{"$f":"F10-D10","v":8699.1577019630931},{"$f":"G10-G10","v":0},{"$f":"H10-G10","v":10880.032131551416},{"$f":"I10-G10","v":30039.888442914293},{"$f":"J10-J10","v":0},{"$f":"K10-J10","v":18116.451916617021},{"$f":"L10-J10","v":36368.193353507348},{"$f":"M10-M10","v":0},{"$f":"N10-M10","v":23537.027438112302},null,{"$f":"P10-P10","v":0},{"$f":"Q10-P10","v":89501.363073365414},{"$f":"R10-P10","v":75964.010695077362},{"$f":"S10-S10","v":0},{"$f":"T10-S10","v":0},{"$f":"U10-S10","v":0},{"$f":"D12+G12+J12+M12+P12+S12","v":0},{"$f":"E12+H12+K12+N12+Q12+T12","v":142942.50919439786},{"$f":"F12+I12+L12+O12+R12+U12","v":151071.2501934621}]
[null,"Segment Δ with Diesel",null,{"$f":"D11-D11","v":0},{"$f":"E11-D11","v":9076.3463475169847},{"$f":"F11-D11","v":86991.577019630931},{"$f":"G11-G11","v":0},{"$f":"H11-G11","v":10880.032131551416},{"$f":"I11-G11","v":30039.888442914293},{"$f":"J11-J11","v":0},{"$f":"K11-J11","v":18116.451916617021},{"$f":"L11-J11","v":36368.193353507348},{"$f":"M11-M11","v":0},{"$f":"N11-M11","v":23537.027438112302},null,{"$f":"P11-P11","v":0},{"$f":"Q11-P11","v":89501.363073365414},{"$f":"R11-P11","v":75964.010695077362},{"$f":"S11-S11","v":0},{"$f":"T11-S11","v":0},{"$f":"U11-S11","v":0},0,151111.22090716314,229363.66951112993]
[null,"Payback Period","years",0,{"$f":"IF(D15=0,0,(E49-D49)/(D83-E83))","v":58.183767185459665},{"$f":"IF(D15=0,0,(F49-D49)/(D83-F83))","v":9.8065977534816717},0,{"$f":"IF(G15=0,0,(H49-G49)/(G83-H83))","v":882.54155657795843},{"$f":"IF(G15=0,0,(I49-G49)/(G83-I83))","v":25.316727822037478},0,{"$f":"IF(J15=0,0,(K49-J49)/(J83-K83))","v":206.98116807495782},{"$f":"IF(J15=0,0,(L49-J49)/(J83-L83))","v":27.241237030292901},0,{"$f":"IF(M15=0,0,(N49-M49)/(M83-N83))","v":-47.78168228008915},null,0,{"$f":"IF(P15=0,0,(Q49-P49)/(P83-Q83))","v":-18.78152118461902},{"$f":"IF(P15=0,0,(R49-P49)/(P83-R83))","v":22.548997069799352},0,{"$f":"IF(S15=0,0,(T49-S49)/(S83-T83))","v":0},{"$f":"IF(S15=0,0,(U49-S49)/(S83-U83))","v":0}]
[null,"Vehicles in this Segment","vehicles",10,null,null,1,null,null,1,null,null,1,null,null,1,null,null,0,null,null,{"$f":"SUM(D15:U15)","v":14}]
[null,"Vehicle Life/TCO Period","years",6,null,null,12,null,null,12,null,null,15,null,null,5,null,null,1]
[null,"Miles/Day","miles/day",71,null,null,71,null,null,71,null,null,71,null,null,300,null,null,1,null,null,{"$f":"D$15*D17+G$15*G17+J$15*J17+M$15*M17+P$15*P17+S$15*S17","v":1223}]
[null,"Idle Time","hours/day",0.52,null,null,0.52,null,null,0.52,null,null,6.4,null,null,4.3,null,null,1,null,null,{"$f":"D15*D18+G15*G18+J15*J18+M15*M18+P15*P18+S15*S18","v":16.940000000000001}]
[null,"Days in Use","days/year",280,null,null,280,null,null,280,null,null,280,null,null,280,null,null,1]
[null,"Annual Mileage","miles/year",{"$f":"D17*D19","v":19880},null,null,{"$f":"G17*G19","v":19880},null,null,{"$f":"J17*J19","v":19880},null,null,{"$f":"M17*M19","v":19880},null,null,{"$f":"P17*P19","v":84000},null,null,{"$f":"S17*S19","v":1},null,null,{"$f":"D$15*D20+G$15*G20+J$15*J20+M$15*M20+P$15*P20+S$15*S20","v":342440}]
[null,"Annual Idle Time","hours/year",{"$f":"D18*D19","v":145.6},null,null,{"$f":"G18*G19","v":145.6},null,null,{"$f":"J18*J19","v":145.6},null,null,{"$f":"M18*M19","v":1792},null,null,{"$f":"P18*P19","v":1204},null,null,{"$f":"S18*S19","v":1},null,null,{"$f":"D$15*D21+G$15*G21+J$15*J21+M$15*M21+P$15*P21+S$15*S21","v":4743.2}]
[null,"Fuel Type",null,"Diesel","CNG","CNG","Diesel","CNG","CNG","Diesel","CNG","CNG","Diesel","CNG",null,"Diesel","LNG","LNG","Diesel","CNG","CNG"]
[null,"Engine Technology",null,null,"SI","SI",null,"SI","SI",null,"SI","SI",null,"SI",null,null,"CI","SI",null,"SI","SI"]
[null,"Discount Rate","%",0.06,0.06,0.06,0.06,0.06,0.06,0.06,0.06,0.06,0.06,0.06,null,0.06,0.06,0.06,0.06,0.06,0.06]
[null,"CAPEX - Vehicle"]
[null,"Vehicle Cost","$/vehicle",{"$f":"ROUND(D27,-3)","v":40000},{"$f":"ROUND(E27,-3)","v":41000},53000,65000,{"$f":"ROUND(H27,-3)","v":76000},{"$f":"ROUND(I27,-3)","v":108000},78000,{"$f":"ROUND(K27,-3)","v":97000},{"$f":"ROUND(L27,-3)","v":129000},140000,{"$f":"ROUND(N27,-3)","v":159000},null,{"$f":"ROUND(P27,-3)","v":130000},{"$f":"ROUND(Q27,-3)","v":202000},{"$f":"ROUND(R27,-3)","v":221000},0,{"$f":"ROUND(T27,-3)","v":10000},{"$f":"ROUND(U27,-3)","v":24000}]
[null,"Suggested Vehicle Cost","$/vehicle",40000,{"$f":"D27+IF(E22=\"CNG\",10000, IF(E22=\"LNG\", 20000, 10000))+E28*VLOOKUP(E30,$A$106:$E$109,5)+ 1800-12000","v":41174.621176470588},{"$f":"D27+IF(E22=\"CNG\",10000, IF(E22=\"LNG\", 20000, 10000))+F28*VLOOKUP(F30,$A$106:$E$109,5)+1800+(9000+1000*F31)+2000-12000","v":53449.161503920172},65000,{"$f":"G27+IF(H22=\"CNG\",10000, IF(H22=\"LNG\", 20000, 10000))+H28*VLOOKUP(H30,$A$106:$E$109,5)+ 1800-3000","v":75633.746149732615},{"$f":"G27+IF(H22=\"CNG\",10000, IF(H22=\"LNG\", 20000, 10000))+I28*VLOOKUP(I30,$A$106:$E$109,5)+1800+(25000+3000*I31)+2000-3000","v":107763.00813411079},78000,{"$f":"J27+IF(K22=\"CNG\",10000, IF(K22=\"LNG\", 20000, 10000))+K28*VLOOKUP(K30,$A$106:$E$109,5)+ 8400-3000","v":97025.472156862743},{"$f":"J27+IF(K22=\"CNG\",10000, IF(K22=\"LNG\", 20000, 10000))+L28*VLOOKUP(L30,$A$106:$E$109,5)+8400+(25000+3000*L31)+2000-3000","v":128975.06633663367},140000,{"$f":"M27+IF(N22=\"CNG\",10000, IF(N22=\"LNG\", 20000, 10000))+N28*VLOOKUP(N30,$A$106:$E$109,5)+ 8400-3000","v":158983.6388746803},null,130000,{"$f":"P27+IF(Q22=\"CNG\",10000,IF(Q22=\"LNG\",20000,10000))+Q28*VLOOKUP(Q30,$A$106:$E$109,5)+IF(Q23=\"SI\",8400,IF(Q23=\"CI\",20000,0))-IF(Q23=\"CI\",0,3000)","v":201510.70176056339},{"$f":"P27+IF(Q22=\"CNG\",10000, IF(Q22=\"LNG\", 20000, 10000))+R28*VLOOKUP(R30,$A$106:$E$108,5)+(25000+3000*R31)+2000+IF(Q23=\"SI\",8400,IF(Q23=\"CI\",20000,0))-IF(Q23=\"CI\",0,3000)","v":220670.66474530831},1,{"$f":"S27+10000+T28*VLOOKUP(T30,$A$106:$E$109,5)","v":10490.705882352941},{"$f":"S27+10000+U28*VLOOKUP(U30,$A$106:$E$109,5)+8000*U31+2000","v":24487.627906976744}]
[null,"Suggested Tank Size","DGE",null,{"$f":"E78/D19*(1+E29)","v":9.1641411764705882},{"$f":"F78/D19*(1+F29)","v":7.6610766928011405},null,{"$f":"H78/G19*(1+H29)","v":12.224974331550802},{"$f":"I78/G19*(1+I29)","v":10.420054227405249},null,{"$f":"K78/J19*(1+K29)","v":24.169814379084968},{"$f":"L78/J19*(1+L29)","v":21.167108910891088},null,{"$f":"N78/M19*(1+N29)","v":23.890925831202047},null,null,{"$f":"Q78/P19*(1+Q29)","v":70.023781690140851},{"$f":"R78/P19*(1+R29)","v":60.902215817694376},null,{"$f":"T78/S19*(1+T29)","v":3.2647058823529416},{"$f":"U78/S19*(1+U29)","v":3.2441860465116283}]
[null,"Suggested Spare Capacity","%",null,0.5,0.5,null,0.5,0.5,null,0.5,0.5,null,0.5,null,null,0.5,0.5,null,0.5,0.5]
[null,"Suggested Tank Type","1-4",null,1,1,null,1,1,null,1,1,null,1,null,null,4,4,null,1,1]
[null,"Suggested Battery Capacity","kWhr",null,null,1.5,null,null,1.8,null,null,1.8,null,null,null,null,null,1.8,null,null,1.5]
[null,"Financing Rate","%",0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0]
[null,"Financing Term","years",5,5,5,5,5,5,5,5,5,5,5,null,5,5,5]
[null,"Used Vehicle Sale Price","$ in year sold",15000,15000,15000,22000,22000,22000,40000,40000,40000,16000,16000,null,50000,50000,50000]
[null,"Incentives (-) or other costs (+)","$/vehicle",0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0]
[null,"PV of Training Related CAPEX","$/vehicle",0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0]
[null,"PV of Residual Value","$/vehicle",{"$f":"D34/(1+D24)^D16","v":10574.408106595145},{"$f":"E34/(1+E24)^D16","v":10574.408106595145},{"$f":"F34/(1+F24)^D16","v":10574.408106595145},{"$f":"G34/(1+G24)^G16","v":10933.32599869401},{"$f":"H34/(1+H24)^G16","v":10933.32599869401},{"$f":"I34/(1+I24)^G16","v":10933.32599869401},{"$f":"J34/(1+J24)^J16","v":19878.774543080021},{"$f":"K34/(1+K24)^J16","v":19878.774543080021},{"$f":"L34/(1+L24)^J16","v":19878.774543080021},{"$f":"M34/(1+M24)^M16","v":6676.240971768646},{"$f":"N34/(1+N24)^M16","v":6676.240971768646},null,{"$f":"P34/(1+P24)^P16","v":37362.908643302842},{"$f":"Q34/(1+Q24)^P16","v":37362.908643302842},{"$f":"R34/(1+R24)^P16","v":37362.908643302842},0,0,0,0,0,0]
[null,"PV of Financing Costs","$/vehicle",{"$f":"IF(D33=0,0,IF(D32=0,0,PV(D24,D33,-(D26*(1+D32)^D33-D26)/D33)))","v":0},0,0,0,0,0,0,0,0,0,0,null,{"$f":"IF(P33=0,0,IF(P32=0,0,PV(P24,P33,-(P26*(1+P32)^P33-P26)/P33)))","v":0},0,0,0,0,0,0,0,0]
[null,"Net Vehicle CAPEX","$/vehicle",{"$f":"D26+D35+D38-D37+D36","v":29425.591893404853},{"$f":"E26+E35+E38-E37+E36","v":30425.591893404853},42425.591893404853,54066.67400130599,{"$f":"H26+H35+H38-H37+H36","v":65066.67400130599},{"$f":"I26+I35+I38-I37+I36","v":97066.67400130599},58121.225456919979,{"$f":"K26+K35+K38-K37+K36","v":77121.225456919987},{"$f":"L26+L35+L38-L37+L36","v":109121.22545691999},133323.75902823135,{"$f":"N26+N35+N38-N37+N36","v":152323.75902823135},null,{"$f":"P26+P35+P38-P37+P36","v":92637.091356697158},{"$f":"Q26+Q35+Q38-Q37+Q36","v":164637.09135669714},{"$f":"R26+R35+R38-R37+R36","v":183637.09135669714},0,{"$f":"T26+T35+T38-T37+T36","v":10000},{"$f":"U26+U35+U38-U37+U36","v":24000}]
[null,"Net Segment CAPEX","$",{"$f":"D39*D15","v":294255.9189340485},{"$f":"E39*D15","v":304255.9189340485},{"$f":"F39*D15","v":424255.9189340485},{"$f":"G39*G15","v":54066.67400130599},{"$f":"H39*G15","v":65066.67400130599},{"$f":"I39*G15","v":97066.67400130599},{"$f":"J39*J15","v":58121.225456919979},{"$f":"K39*J15","v":77121.225456919987},{"$f":"L39*J15","v":109121.22545691999},{"$f":"M39*M15","v":133323.75902823135},{"$f":"N39*M15","v":152323.75902823135},null,{"$f":"P39*P15","v":92637.091356697158},{"$f":"Q39*P15","v":164637.09135669714},{"$f":"R39*P15","v":183637.09135669714},{"$f":"S39*S15","v":0},{"$f":"T39*S15","v":0},{"$f":"U39*S15","v":0},{"$f":"D40+G40+J40+M40+P40+S40","v":632404.66877720295},{"$f":"E40+H40+K40+N40+Q40+T40","v":763404.66877720295},814080.90974897158]
[null,"CAPEX - Infrastructure"]
[null,"Infrastructure Cost","$",0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,{"$f":"D42+G42+J42+M42+P42+S42","v":0},{"$f":"E42+H42+K42+N42+Q42+T42","v":0},0]
[null,"Infrastructure Financing Rate","%",0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0]
[null,"Infrastructure Financing Period","years",0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0]
[null,"Incentive (-) or other costs (+) ","$"]
[null,"PV of Financing Costs",null,{"$f":"IF(D43=0,0,IF(D44=0,0,PV(D24,D44,-(D42*(1+D43)^D44-D42)/D44)))","v":0},0,0,0,0,0,0,0,0,0,0,null,{"$f":"IF(P43=0,0,IF(P44=0,0,PV(P24,P44,-(P42*(1+P43)^P44-P42)/P44)))","v":0},0,0,0,0,0]
[null,"Net Infrastructure CAPEX",null,{"$f":"D42+D46","v":0},{"$f":"E42+E46","v":0},0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,{"$f":"D47+G47+J47+M47+P47+S47","v":0},{"$f":"E47+H47+K47+N47+Q47+T47","v":0},0]
[null,"CAPEX - Total Net"]
[null,"Total Net CAPEX",null,{"$f":"D40+D47","v":294255.9189340485},304255.9189340485,424255.9189340485,54066.67400130599,65066.67400130599,97066.67400130599,58121.225456919979,77121.225456919987,109121.22545691999,133323.75902823135,152323.75902823135,null,92637.091356697158,164637.09135669714,183637.09135669714,0,0,0,{"$f":"D49+G49+J49+M49+P49+S49","v":632404.66877720295},{"$f":"E49+H49+K49+N49+Q49+T49","v":763404.66877720295},814080.90974897158]
[null,"OPEX - Maintenance"]
[null,"Maintenance Cost","$/mile",7.5999999999999998E-2,8.8999999999999996E-2,5.8000000000000003E-2,9.5000000000000001E-2,0.11,6.7000000000000004E-2,0.11,0.13,0.11,0.28000000000000003,0.3,null,5.1999999999999998E-2,6.9000000000000006E-2,0.06,null,null,null,{"$f":"D51*$D$15+$G$15*G51+J51*$J$15+$M$15*M51+P51*$P$15+$S$15*S51","v":1.2970000000000002},1.4989999999999999,0.81699999999999995]
[null,"Annual Maintenance Training",null,0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0]
[null,"Suggested Maintenance Cost","$/Mile",{"$f":"SUM(D54:D57)","v":7.5999999999999998E-2},{"$f":"SUM(E54:E57)","v":8.900000000000001E-2},5.7999999999999996E-2,9.5000000000000001E-2,{"$f":"SUM(H54:H57)","v":0.11},{"$f":"SUM(I54:I57)","v":6.699999999999999E-2},0.11,{"$f":"SUM(K54:K57)","v":0.13},{"$f":"SUM(L54:L57)","v":0.11},9.2999999999999999E-2,{"$f":"SUM(N54:N57)","v":0.112},null,{"$f":"SUM(P54:P57)","v":5.1999999999999998E-2},{"$f":"SUM(Q54:Q57)","v":6.9000000000000006E-2},{"$f":"SUM(R54:R57)","v":0.06},{"$f":"SUM(S54:S57)","v":0},{"$f":"SUM(T54:T57)","v":0},{"$f":"SUM(U54:U57)","v":0}]
[null,"Suggested Brake Maintenance Cost","$/mile",4.1000000000000002E-2,4.1000000000000002E-2,8.0000000000000002E-3,6.3E-2,6.3E-2,1.2999999999999999E-2,7.4999999999999997E-2,7.4999999999999997E-2,1.4999999999999999E-2,6.3E-2,6.3E-2,null,3.5000000000000003E-2,3.5000000000000003E-2,7.0000000000000001E-3]
[null,"Suggested Oil Change Maintenance Cost","$/Mile",1.2E-2,1.2E-2,1.2E-2,1.2E-2,1.4999999999999999E-2,1.4999999999999999E-2,1.7000000000000001E-2,1.9E-2,1.9E-2,1.2E-2,1.6E-2,null,7.0000000000000001E-3,1.0999999999999999E-2,1.0999999999999999E-2]
[null,"Suggested Fuel Filter Maintenance Cost","$/mile",0.01,7.0000000000000001E-3,7.0000000000000001E-3,7.0000000000000001E-3,3.0000000000000001E-3,3.0000000000000001E-3,5.0000000000000001E-3,1E-3,1E-3,5.0000000000000001E-3,4.0000000000000001E-3,null,5.0000000000000001E-3,2E-3,2E-3]
[null,"Suggested Other Maintenance Costs","$/Mile",1.2999999999999999E-2,2.9000000000000001E-2,3.1E-2,1.2999999999999999E-2,2.9000000000000001E-2,3.5999999999999997E-2,1.2999999999999999E-2,3.5000000000000003E-2,7.4999999999999997E-2,1.2999999999999999E-2,2.9000000000000001E-2,null,5.0000000000000001E-3,2.1000000000000001E-2,0.04]
[null,"Battery Replacement Cost","$ at replacement",null,null,4500,null,null,5400,null,null,5400,null,null,null,null,null,5400,null,null,4500]
[null,"Suggested Battery Replacement Cost","$ at replacement",null,null,{"$f":"3000*F31","v":4500},null,null,{"$f":"3000*I31","v":5400},null,null,{"$f":"3000*L31","v":5400},null,null,null,null,null,{"$f":"3000*R31","v":5400},null,null,{"$f":"3000*U31","v":4500}]
[null,"Hybrid Battery Replacement Interval",null,null,null,8,null,null,8,null,null,8,null,null,null,null,null,8,null,null,8]
[null,"Is the battery replaced within the useful life?",null,null,null,{"$f":"IF(F60>D16,\"No\",\"Yes\")","v":"No"},null,null,{"$f":"IF(I60>G16,\"No\",\"Yes\")","v":"Yes"},null,null,{"$f":"IF(L60>J16,\"No\",\"Yes\")","v":"Yes"},null,null,null,null,null,{"$f":"IF(R60>P16,\"No\",\"Yes\")","v":"No"},null,null,{"$f":"IF(U60>S16,\"No\",\"Yes\")","v":"No"}]
[null,"Total Annual Maintenance","$/year",{"$f":"D51*D20+D52","v":1510.8799999999999},{"$f":"E51*D20+E52","v":1769.32},{"$f":"F51*D20+F52","v":1153.04},{"$f":"G51*G20+G52","v":1888.6},{"$f":"H51*G20+H52","v":2186.8000000000002},{"$f":"I51*G20+I52","v":1331.96},{"$f":"J51*J20+J52","v":2186.8000000000002},{"$f":"K51*J20+K52","v":2584.4},{"$f":"L51*J20+L52","v":2186.8000000000002},{"$f":"M51*M20+M52","v":5566.4000000000005},{"$f":"N51*M20+N52","v":5964},null,{"$f":"P51*P20+P52","v":4368},{"$f":"Q51*P20+Q52","v":5796.0000000000009},{"$f":"R51*P20+R52","v":5040},{"$f":"S51*S20+S52","v":0},{"$f":"T51*S20+T52","v":0},{"$f":"U51*S20+U52","v":0},29118.6,34224.400000000001,20089.16]
[null,"PV of Battery Replacement","$/Vehicle Life",null,null,{"$f":"F59/(1+F24)^(F60)","v":2823.355671038219},null,null,{"$f":"I59/(1+I24)^(I60)","v":3388.0268052458632},null,null,{"$f":"L59/(1+L24)^(L60)","v":3388.0268052458632},null,null,null,null,null,{"$f":"R59/(1+R24)^(R60)","v":3388.0268052458632},null,null,{"$f":"U59/(1+U24)^(U60)","v":2823.355671038219}]
[null,"OPEX - Fuel and DEF"]
[null,"Fuel Price","$/DGE",{"$f":"IF(D22=\"CNG\",$I102,IF(D22=\"LNG\",$J102,IF(D22=\"Diesel\",$E90,\"Check Fuel Type\")))","v":3},2.4669999999999996,2.4669999999999996,3,2.4669999999999996,2.4669999999999996,3,2.4669999999999996,2.4669999999999996,3,2.4669999999999996,null,{"$f":"IF(P22=\"CNG\",$I102,IF(P22=\"LNG\",$J102,IF(P22=\"Diesel\",$E90,\"Check Fuel Type\")))","v":3},3.05,3.05,3,2.4669999999999996,2.4669999999999996]
[null,"Driving Fuel Economy","mile/DGE",{"$f":"ROUND(D67,2)","v":15},{"$f":"ROUND(E67,2)","v":12.75},14.03,11,{"$f":"ROUND(H67,2)","v":9.35},{"$f":"ROUND(I67,2)","v":10.29},5.4,{"$f":"ROUND(K67,2)","v":4.59},{"$f":"ROUND(L67,2)","v":5.05},9.1999999999999993,{"$f":"ROUND(N67,2)","v":7.82},null,{"$f":"ROUND(P67,2)","v":7.1},{"$f":"ROUND(Q67,2)","v":7.1},{"$f":"ROUND(R67,2)","v":7.46},1,{"$f":"ROUND(T67,2)","v":0.85},{"$f":"ROUND(U67,2)","v":0.86}]
[null,"Suggested Driving Fuel Economy","mile/DGE",15,{"$f":"IF(E23=\"CI\",(1+$E114)*D67,IF(E23=\"SI\",(1+$E113)*D67,\"Check Engine Type\"))","v":12.75},{"$f":"IF(F23=\"CI\",(1+F114)*E67,IF(F23=\"SI\",(1+F113)*E67,\"Check Engine Type\"))*(1+F70)","v":14.025},11,{"$f":"IF(H23=\"CI\",(1+$E114)*G67,IF(H23=\"SI\",(1+$E113)*G67,\"Check Engine Type\"))","v":9.35},{"$f":"IF(I23=\"CI\",(1+I114)*H67,IF(I23=\"SI\",(1+I113)*H67,\"Check Engine Type\"))*(1+I70)","v":10.285},5.4,{"$f":"IF(K23=\"CI\",(1+$E114)*J67,IF(K23=\"SI\",(1+$E113)*J67,\"Check Engine Type\"))","v":4.59},{"$f":"IF(L23=\"CI\",(1+L114)*K67,IF(L23=\"SI\",(1+L113)*K67,\"Check Engine Type\"))*(1+L70)","v":5.0490000000000004},9.1999999999999993,{"$f":"IF(N23=\"CI\",(1+$E114)*M67,IF(N23=\"SI\",(1+$E113)*M67,\"Check Engine Type\"))","v":7.8199999999999994},null,7.1,{"$f":"IF(Q23=\"CI\",(1+$E114)*P67,IF(Q23=\"SI\",(1+$E113)*P67,\"Check Engine Type\"))","v":7.1},{"$f":"IF(R23=\"CI\",(1+R114)*Q67,IF(R23=\"SI\",(1+R113)*Q67,\"Check Engine Type\"))*(1+R70)","v":7.4550000000000001},1,{"$f":"IF(T23=\"CI\",(1+$E114)*S67,IF(T23=\"SI\",(1+$E113)*S67,\"Check Engine Type\"))","v":0.85},{"$f":"IF(U23=\"CI\",(1+U114)*T67,IF(U23=\"SI\",(1+U113)*T67,\"Check Engine Type\"))*(1+U70)","v":0.85849999999999993}]
[null,"Hybrid Vehicle Drive Cycle Selector","1-4",null,null,2,null,null,2,null,null,2,null,null,null,null,null,3,null,null,4]
[null,"Selected Drive cycle",null,null,null,{"$f":"VLOOKUP(F68,$A$118:$E$121, 2)","v":"Suburban Drive Cycle"},null,null,{"$f":"VLOOKUP(I68,$A$118:$E$121, 2)","v":"Suburban Drive Cycle"},null,null,{"$f":"VLOOKUP(L68,$A$118:$E$121, 2)","v":"Suburban Drive Cycle"},null,null,null,null,null,{"$f":"VLOOKUP(R68,$A$118:$E$121, 2)","v":"Rural Drive Cycle"},null,null,{"$f":"VLOOKUP(U68,$A$118:$E$121, 2)","v":"Intercity"}]
[null,"Hybrid Fuel Economy Improvement","mile/DGE",null,null,{"$f":"VLOOKUP(F68,$A$118:$E$121,5)","v":0.1},null,null,{"$f":"VLOOKUP(I68,$A$118:$E$121,5)","v":0.1},null,null,{"$f":"VLOOKUP(L68,$A$118:$E$121,5)","v":0.1},null,null,null,null,null,{"$f":"VLOOKUP(R68,$A$118:$E$121,5)","v":0.05},null,null,{"$f":"VLOOKUP(U68,$A$118:$E$121,5)","v":0.01}]
[null,"Idle Fuel Consumption","DGE/hour",0.79,1.04,0.09,0.81,1.07,0.09,0.94,1.24,0.1,0.81,1.07,null,1.03,1.03,0.09,1,1,1]
[null,"DEF Economy","mpg",330,0,0,350,0,0,350,0,0,350,0,null,350,700,700,0,0,0]
[null,"DEF Price","$/gallon",2.9,2.9,2.9,2.9,2.9,2.9,2.9,2.9,2.9,2.9,2.9,null,2.9,2.9,2.9,2.9,2.9,2.9]
[null,"Other Vehicle OPEX","$/year",null,null,null,null,null,null,null,null,null,null,null,null,null,2100,180,null,null,null,{"$f":"D74*$D$15+$G$15*G74+J74*$J$15+$M$15*M74+P74*$P$15+$S$15*S74","v":0},{"$f":"E74*$D$15+$G$15*H74+K74*$J$15+$M$15*N74+Q74*$P$15+$S$15*T74","v":2100},{"$f":"F74*$D$15+$G$15*I74+L74*$J$15+$M$15*O74+R74*$P$15+$S$15*U74","v":180}]
[null,"Infrastructure related OPEX","$/year",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"D75*$D32+$G32*G75+J75*$J32+$M32*M75+P75*$P32+$S32*S75","v":0},{"$f":"E75*$D32+$G32*H75+K75*$J32+$M32*N75+Q75*$P32+$S32*T75","v":0},{"$f":"F75*$D32+$G32*I75+L75*$J32+$M32*O75+R75*$P32+$S32*U75","v":0}]
[null,"Vehicle Driving Fuel Consumption","DGE/year",{"$f":"D20/D66","v":1325.3333333333333},{"$f":"D20/E66","v":1559.2156862745098},{"$f":"D20/F66","v":1416.9636493228795},{"$f":"G20/G66","v":1807.2727272727273},{"$f":"G20/H66","v":2126.20320855615},{"$f":"G20/I66","v":1931.9727891156465},{"$f":"J20/J66","v":3681.4814814814813},{"$f":"J20/K66","v":4331.1546840958608},{"$f":"J20/L66","v":3936.6336633663368},{"$f":"M20/M66","v":2160.8695652173915},{"$f":"M20/N66","v":2542.1994884910487},null,{"$f":"P20/P66","v":11830.985915492958},{"$f":"P20/Q66","v":11830.985915492958},{"$f":"P20/R66","v":11260.053619302949},{"$f":"S20/S66","v":1},{"$f":"S20/T66","v":1.1764705882352942},{"$f":"S20/U66","v":1.1627906976744187},{"$f":"D76*$D$15+$G$15*G76+J76*$J$15+$M$15*M76+P76*$P$15+$S$15*S76","v":32733.943022797892},36422.700159381115,31298.296565013727]
[null,"Vehicle Idle Fuel Consumption","DGE/year",{"$f":"D71*D21","v":115.024},{"$f":"E71*D21","v":151.42400000000001},{"$f":"F71*D21","v":13.103999999999999},{"$f":"G71*G21","v":117.93600000000001},{"$f":"H71*G21","v":155.792},{"$f":"I71*G21","v":13.103999999999999},{"$f":"J71*J21","v":136.86399999999998},{"$f":"K71*J21","v":180.54399999999998},{"$f":"L71*J21","v":14.56},{"$f":"M71*M21","v":1451.52},{"$f":"N71*M21","v":1917.44},null,{"$f":"P71*P21","v":1240.1200000000001},{"$f":"Q71*P21","v":1240.1200000000001},{"$f":"R71*P21","v":108.36},{"$f":"S71*S21","v":1},{"$f":"T71*S21","v":1},{"$f":"U71*S21","v":1},4096.68,5008.1360000000004,267.06400000000002]
[null,"Vehicle Total Fuel Consumption","DGE/year",{"$f":"D77+D76","v":1440.3573333333334},{"$f":"E77+E76","v":1710.6396862745098},1430.0676493228796,1925.2087272727272,2281.9952085561499,1945.0767891156465,3818.3454814814813,4511.6986840958607,3951.1936633663368,3612.3895652173915,4459.6394884910487,null,13071.105915492959,13071.105915492959,11368.41361930295,2,2.1764705882352944,2.1627906976744189,36830.623022797896,41430.836159381113,31565.360565013725]
[null,"Annual Vehicle Fuel Cost","$/year",{"$f":"D78*D65","v":4321.0720000000001},4220.1481060392152,3527.9768908795431,5775.6261818181811,5629.6821795080214,4798.5044387482994,11455.036444444444,11130.360653664487,9747.5947675247517,10837.168695652173,11001.930618107415,null,39213.317746478875,39866.873042253523,34673.661538873996,6,5.3693529411764702,5.3356046511627904,{"$f":"D79*$D$15+$G$15*G79+J79*$J$15+$M$15*M79+P79*$P$15+$S$15*S79","v":110491.86906839367},109830.3275539256,84499.529653942474]
[null,"Vehicle DEF Consumption","gallon/year",{"$f":"IF(D72=0,0,D20/D72)","v":60.242424242424242},{"$f":"IF(E72=0,0,D20/E72)","v":0},{"$f":"IF(F72=0,0,D20/F72)","v":0},{"$f":"IF(G72=0,0,G20/G72)","v":56.8},{"$f":"IF(H72=0,0,G20/H72)","v":0},{"$f":"IF(I72=0,0,G20/I72)","v":0},{"$f":"IF(J72=0,0,J20/J72)","v":56.8},{"$f":"IF(K72=0,0,J20/K72)","v":0},{"$f":"IF(L72=0,0,J20/L72)","v":0},{"$f":"IF(M72=0,0,M20/M72)","v":56.8},{"$f":"IF(N72=0,0,M20/N72)","v":0},null,{"$f":"IF(P72=0,0,P20/P72)","v":240},{"$f":"IF(Q72=0,0,P20/Q72)","v":120},{"$f":"IF(R72=0,0,P20/R72)","v":120},{"$f":"IF(S72=0,0,S20/S72)","v":0},{"$f":"IF(T72=0,0,S20/T72)","v":0},{"$f":"IF(U72=0,0,S20/U72)","v":0},1012.8242424242422,120,120]
[null,"Annual Vehicle DEF Cost","$/year",{"$f":"D73*D80","v":174.70303030303029},0,0,164.72,0,0,164.72,0,0,164.72,0,null,696,348,348,0,0,0,0,0,0]
[null,"Total Vehicle Annual OPEX","$/year",{"$f":"D62+D79+D81+D74+D75","v":6006.6550303030308},5989.4681060392149,4681.0168908795431,7828.9461818181817,7816.4821795080215,6130.4644387482995,13806.556444444444,13714.760653664487,11934.394767524751,16568.288695652176,16965.930618107413,null,44277.317746478875,48110.873042253523,40241.661538873996,6,5.3693529411764702,5.3356046511627904,139610.46906839366,146154.72755392559,104768.68965394248]
[null,"Total Segment Annual OPEX",null,{"$f":"D82*D15","v":60066.550303030308},{"$f":"E82*D15","v":59894.681060392148},{"$f":"F82*D15","v":46810.168908795429},{"$f":"G82*G15","v":7828.9461818181817},{"$f":"H82*G15","v":7816.4821795080215},{"$f":"I82*G15","v":6130.4644387482995},{"$f":"J82*J15","v":13806.556444444444},{"$f":"K82*J15","v":13714.760653664487},{"$f":"L82*J15","v":11934.394767524751},{"$f":"M82*M15","v":16568.288695652176},{"$f":"N82*M15","v":16965.930618107413},null,{"$f":"P82*P15","v":44277.317746478875},{"$f":"Q82*P15","v":48110.873042253523},{"$f":"R82*P15","v":40241.661538873996},{"$f":"S82*S15","v":0},{"$f":"T82*S15","v":0},{"$f":"U82*S15","v":0},{"$f":"V82*V15","v":1954546.5669575112},{"$f":"W82*V15","v":2046166.1857549583},{"$f":"X82*V15","v":1466761.6551551947}]
[null,"OPEX Inflation","%",0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,null,0.02,0.02,0.02]
[null,"OPEX - Fuel and DEF"]
[null,"Total Vehicle OPEX","$",{"$f":"D82+D82/(D24-D84)*(1-((1+D84)/(1+D24))^(D16-1))","v":32280.754675955501},{"$f":"E82+E82/(E24-E84)*(1-((1+E84)/(1+E24))^(D16-1))","v":32188.3893107072},{"$f":"F82+F82/(F24-F84)*(1-((1+F84)/(1+F24))^(D16-1))+F63","v":27979.912377918597},{"$f":"G82+G82/(G24-G84)*(1-((1+G84)/(1+G24))^(G16-1))","v":75354.766651939877},{"$f":"H82+H82/(H24-H84)*(1-((1+H84)/(1+H24))^(G16-1))","v":75234.798783491293},{"$f":"I82+I82/(I24-I84)*(1-((1+I84)/(1+I24))^(G16-1))+I63","v":62394.65509485417},{"$f":"J82+J82/(J24-J84)*(1-((1+J84)/(1+J24))^(J16-1))","v":132890.1508550579},{"$f":"K82+K82/(K24-K84)*(1-((1+K84)/(1+K24))^(J16-1))","v":132006.60277167492},{"$f":"L82+L82/(L24-L84)*(1-((1+L84)/(1+L24))^(J16-1))+L63","v":118258.34420856525},{"$f":"M82+M82/(M24-M84)*(1-((1+M84)/(1+M24))^(M16-1))","v":189041.38665912699},{"$f":"N82+N82/(N24-N84)*(1-((1+N84)/(1+N24))^(M16-1))","v":193578.41409723926},null,{"$f":"P82+P82/(P24-P84)*(1-((1+P84)/(1+P24))^(P16-1))","v":202139.62079795881},{"$f":"Q82+Q82/(Q24-Q84)*(1-((1+Q84)/(1+Q24))^(P16-1))","v":219640.98387132422},{"$f":"R82+R82/(R24-R84)*(1-((1+R84)/(1+R24))^(P16-1))+R63","v":187103.63149303614},{"$f":"S82+S82/(S24-S84)*(1-((1+S84)/(1+S24))^(S16-1))","v":6},{"$f":"T82+T82/(T24-T84)*(1-((1+T84)/(1+T24))^(S16-1))","v":5.3693529411764702},{"$f":"U82+U82/(U24-U84)*(1-((1+U84)/(1+U24))^(S16-1))+U63","v":2828.6912756893817}]
[null,"Total Segment OPEX",null,{"$f":"D86*D15","v":322807.546759555},{"$f":"E86*D15","v":321883.89310707198},{"$f":"F86*D15","v":279799.12377918599},{"$f":"G86*G15","v":75354.766651939877},{"$f":"H86*G15","v":75234.798783491293},{"$f":"I86*G15","v":62394.65509485417},{"$f":"J86*J15","v":132890.1508550579},{"$f":"K86*J15","v":132006.60277167492},{"$f":"L86*J15","v":118258.34420856525},{"$f":"M86*M15","v":189041.38665912699},{"$f":"N86*M15","v":193578.41409723926},null,{"$f":"P86*P15","v":202139.62079795881},{"$f":"Q86*P15","v":219640.98387132422},{"$f":"R86*P15","v":187103.63149303614},{"$f":"S86*S15","v":0},{"$f":"T86*S15","v":0},{"$f":"U86*S15","v":0},{"$f":"D87+G87+J87+M87+P87+S87","v":922233.47172363859},{"$f":"E87+H87+K87+N87+Q87+T87","v":942344.6926308017},647555.75457564159]
[]
[null,"Fuel Prices - Diesel"]
[null,"Diesel",null,"$/gallon",{"$f":"VLOOKUP(H90,B92:E95,4, FALSE)","v":3},null,3,{"$f":"VLOOKUP(G90,G91:H94,2)","v":"Low Estimate"}]
[null,"Tax (Rebate)",null,"$/gallon",0,null,1,"Nominal"]
[null,"Nominal",null,"$/gallon",3.9,null,2,"High Estimate"]
[null,"High Estimate",null,"$/gallon",4.4000000000000004,null,3,"Low Estimate"]
[null,"Low Estimate",null,"$/gallon",3,null,4,"Custom"]
[null,"Custom",null,"$/gallon"]
[null,"Fuel Prices - Natural Gas",null,null,"CNG","LNG",null,null,"CNG","LNG"]
[null,"Natural Gas",null,"$/DGE",{"$f":"I102","v":2.4669999999999996},{"$f":"J102","v":3.05},1,"Price at the Pump (Private)",{"$f":"E100+E$99+E$98","v":2.137},{"$f":"F100+F$99+F$98","v":2.7199999999999998}]
[null,"Henry Hub Price",null,"$/DGE",0.32,0.32,2,"Price at the Pump (Public)",{"$f":"E101+E$99+E$98","v":2.4669999999999996},3.05]
[null,"Taxes",null,"$/DGE",0.20699999999999999,0.42,3,"Custom",0.52700000000000002,0.74]
[null,"Delivery/Overhead/Compression (Private)",null,"$/DGE",1.61,1.98]
[null,"Delivery/Overhead/Compression (Public)",null,"$/DGE",1.94,2.31]
[null,"Delivery/Overhead/Compression (Custom)",null,"$/DGE",null,null,2,null,{"$f":"VLOOKUP(G102,G97:I102,3)","v":2.4669999999999996},{"$f":"VLOOKUP(G102,G97:J99,4)","v":3.05}]
[]
[]
[null,"Tank Cost Calculator"]
[1,"Type 1",null,"$/DGE",150]
[2,"Type 2",null,"$/DGE",200]
[3,"Type 3",null,"$/DGE",300]
[4,"Type 4",null,"$/DGE",450]
[]
[]
[null,"Fuel Penalty"]
[null,"SI",null,"%",-0.15]
[null,"CI",null,"%",0]
[]
[]
[null,"Hybrid Fuel Economy Improvement by Drive Cycle Type"]
[1,"Urban Drive Cycle",null,"%",0.2]
[2,"Suburban Drive Cycle",null,"%",0.1]
[3,"Rural Drive Cycle",null,"%",0.05]
[4,"Intercity",null,"%",0.01]

{"sheet":"Information and Troubleshooting","index":2,"n_rows":9,"n_cols":9,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
["If the pull down menus or hyperlinks do not work:"]
[null,null,null,null,null,null,null,null,"1. Click on the box labeled \"Options…\" beside the Security Warning"]
[null,null,null,null,null,null,null,null,"2. Scroll down in the box that pops up and click on the radio button beside \"Enable this content\" for the Active X Controls"]
[null,null,null,null,null,null,null,null,"3. In the same pop-up, click on the radio button beside \"Enable this content\" for the Data Connection"]
[null,null,null,null,null,null,null,null,"4.Select OK"]
[null,null,null,null,null,null,null,null,"The pull down menus will work, but if you open the file in Excel later, you will need to repeat this sequence"]