{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Warning","LCC","Diagram","Fuel Prices","Calculations","Bugs"],"not_rendered":{"charts":2,"images":3,"macros":1,"external_links":0,"defined_names":7,"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":"Warning","index":0,"n_rows":33,"n_cols":8,"rows_kept":33,"cut":false,"hidden":false,"merged":[[32,6,33,12],[16,3,16,15],[19,5,27,13]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"Life Cycle Cost Calculator"]
[]
[]
[]
[]
[null,null,null,"You must enable Macros to use this worksheet"]
[]
[]
[null,null,null,null,null,"Please click on the 'Options…' button above and select 'Enable this content'"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"The contents of this spreadsheet are the sole responsibility of the Clean Fleets project and can in no way be taken to reflect the views of the European Union"]

{"sheet":"LCC","index":1,"n_rows":99,"n_cols":13,"rows_kept":99,"cut":false,"hidden":true,"merged":[[60,2,60,3],[61,2,61,3],[60,27,60,28],[54,27,54,28],[55,27,55,28],[56,27,56,28],[59,27,59,28]]}
[]
[null,null,null,"VEHICLES - LIFE CYCLE COST (LCC) CALCULATOR"]
[null,null,null,"Please fill in the white cells only - use European number formats (commas for decimals, dots for thousands)"]
[]
[null,"GENERAL CONDITIONS"]
[null,null,"Contract length/period of vehicle ownership","Year",10,null,{"$f":"E6","v":10},null,{"$f":"E6","v":10},null,{"$f":"E6","v":10},null,{"$f":"E6","v":10}]
[null,null,"Discount rate ","%",2,null,{"$f":"E7","v":2},null,{"$f":"E7","v":2},null,{"$f":"E7","v":2},null,{"$f":"E7","v":2}]
[null,null,"Number of bids/offers",null,3]
[]
[null,"ACQUISITION COSTS"]
[null,null,"Name of bidder",null,"Product A",null,"Product B",null,"Product C",null,"Product 4",null,"Product 5"]
[]
[null,null,"Number of vehicles",null,10,null,10,null,10,null,50,null,50]
[null,null,"Purchase price","€/unit",10000,"€/unit",10000,"€/unit",null,"€/unit",null,"€/unit",30000]
[null,null,"(or) Lease price","€/unit/year",null,"€/unit/year",null,"€/unit/year",1000,"€/unit/year",6800,"€/unit/year"]
[null,null,"COSTS OF ACQUISITION / UNIT",null,{"$f":"-PV(E7*0.01,E6,E15)+E14","v":10000},null,{"$f":"-PV(G7*0.01,G6,G15)+G14","v":10000},null,{"$f":"-PV(I7*0.01,I6,I15)+I14","v":8982.5850062422342},null,{"$f":"-PV(K7*0.01,K6,K15)+K14","v":61081.578042447196},null,{"$f":"-PV(M7*0.01,M6,M15)+M14","v":30000}]
[]
[null,"OPERATING COSTS"]
[null,null,"Type of Fuel",null,"Diesel",null,"Electricity",null,"LPG"]
[null,null,"Fuel consumption per vehicle ",{"$f":"INDEX(Calculations!$E$20:$E$30,Calculations!D$4)","v":"l/100km"},7.5,{"$f":"INDEX(Calculations!$E$20:$E$30,Calculations!E$4)","v":"kWh/100km"},2.5,{"$f":"INDEX(Calculations!$E$20:$E$30,Calculations!F$4)","v":"l/100km"},8.6999999999999993,{"$f":"INDEX(Calculations!$E$20:$E$30,Calculations!G$4)","v":{"$error":"#N/A"}},10,{"$f":"INDEX(Calculations!$E$20:$E$30,Calculations!H$4)","v":{"$error":"#N/A"}},11]
[null,null,"Annual use of vehicle","km",15000,"km",15000,"km",15000,"km",20000,"km",20000]
[null,null,"Fuel price",{"$f":"INDEX(Calculations!$F$20:$F$30,Calculations!D4)","v":"€/l"},1.4,{"$f":"INDEX(Calculations!$F$20:$F$30,Calculations!E4)","v":"€/kWh"},0.13,{"$f":"INDEX(Calculations!$F$20:$F$30,Calculations!F4)","v":"€/l"},1.1000000000000001,{"$f":"INDEX(Calculations!$F$20:$F$30,Calculations!G4)","v":{"$error":"#N/A"}},0.85,{"$f":"INDEX(Calculations!$F$20:$F$30,Calculations!H4)","v":{"$error":"#N/A"}},0.15]
[null,null,"Replacement battery price","€/unit",null,"€/unit",3000,"€/unit",null,"€/unit",null,"€/unit"]
[null,null,"Lifetime of battery","Years",null,"Years",5,"Years",null,"Years",null,"Years"]
[null,null,"(or) Battery lease price","€/unit/year",null,"€/unit/year",null,"€/unit/year",null,"€/unit/year",222,"€/unit/year",250]
[null,null,"OPERATING  COSTS / UNIT ",null,{"$f":"IF(C74=\"Use default OECD-FAO values\",-PV(E7*0.01,E6,Calculations!D6+Calculations!D7+LCC!E25),-PV(E7*0.01,E6,E20*(E21/100)*Calculations!D8+Calculations!D7+LCC!E25))","v":14010.116996641969},null,{"$f":"IF(C74=\"Use default OECD-FAO values\",-PV(E7*0.01,E6,Calculations!E6+Calculations!E7+LCC!G25),-PV(E7*0.01,E6,G20*(G21/100)*Calculations!E8+Calculations!E7+LCC!G25))","v":3129.5039435060362},null,{"$f":"IF(C74=\"Use default OECD-FAO values\",-PV(E7*0.01,E6,Calculations!F6+Calculations!F7+I25),-PV(E7*0.01,E6,I20*(I21/100)*Calculations!F8+Calculations!F7+I25))","v":13170.531744811196},null,{"$f":"IF(C74=\"Use default OECD-FAO values\",-PV(E7*0.01,E6,Calculations!G6+Calculations!G7+K25),-PV(E7*0.01,E6,K20*(K21/100)*Calculations!G8++Calculations!G7+K25))","v":{"$error":"#N/A"}},null,{"$f":"IF(C74=\"Use default OECD-FAO values\",-PV(E7*0.01,E6,Calculations!H6+Calculations!H7+M25),-PV(E7*0.01,E6,M20*(M21/100)*Calculations!H8++Calculations!H7+M25))","v":{"$error":"#N/A"}}]
[]
[null,"MAINTENANCE COSTS"]
[null,null,"Estimated annual service costs (incl. spare parts)","€/unit/year",null,"€/unit/year",200,"€/unit/year",250,"€/unit/year",400,"€/unit/year"]
[null,null,"(or) Annual service agreement","€/unit/year",300,"€/unit/year",null,"€/unit/year",null,"€/unit/year",null,"€/unit/year",50]
[null,null," MAINTENANCE COSTS / UNIT",null,{"$f":"-PV(E7*0.01,E6,(E30+E29))","v":2694.7755018726702},null,{"$f":"-PV(G7*0.01,G6,(G30+G29))","v":1796.5170012484468},null,{"$f":"-PV(I7*0.01,I6,(I30+I29))","v":2245.6462515605585},null,{"$f":"-PV(K7*0.01,K6,(K30+K29))","v":3593.0340024968937},null,{"$f":"-PV(M7*0.01,M6,(M30+M29))","v":449.12925031211171}]
[]
[null,"TAXES AND OTHER COSTS"]
[null,null,"Vehicle tax","€/unit/year",150,"€/unit/year",0,"€/unit/year",150,"€/unit/year",100,"€/unit/year",0]
[null,null,"Insurance costs","€/unit/year",350,"€/unit/year",350,"€/unit/year",350,"€/unit/year",1000,"€/unit/year",1100]
[null,null,"Infrastructure - one off investment costs","€",null,"€",1000,"€",1500,"€",null,"€"]
[null,null,"(or) Infrastructure - annual costs","€/year",null,"€/year",null,"€/year",null,"€/year",null,"€/year"]
[null,null,"Other costs (click on expand button on the left)"]
[null,null,"(Annual cost 1)","€/year",null,"€/year",null,"€/year",null,"€/year",null,"€/year"]
[null,null,"(Annual cost 2)","€/year",null,"€/year",null,"€/year",null,"€/year",null,"€/year"]
[null,null,"(One off initial cost 1)","€",null,"€",null,"€",null,"€",null,"€"]
[null,null,"(One off initial cost 2)","€",null,"€",null,"€",null,"€",null,"€"]
[null,null,"TOTAL OTHER COSTS / UNIT",null,{"$f":"(-PV(E7*0.01,E6,(E34+E35+E37+E39+E40)))+E36+E41+E42","v":4491.2925031211171},null,{"$f":"(-PV($E$7*0.01,$E$6,(G34+G35+G37+G39+G40)))+G36+G41+G42","v":4143.9047521847824},null,{"$f":"(-PV($E$7*0.01,$E$6,(I34+I35+I37+I39+I40)))+I36+I41+I42","v":5991.2925031211171},null,{"$f":"(-PV($E$7*0.01,$E$6,(K34+K35+K37+K39+K40)))+K36+K41+K42","v":9880.8435068664585},null,{"$f":"(-PV($E$7*0.01,$E$6,(M34+M35+M37+M39+M40)))+M36+M41+M42","v":9880.8435068664585}]
[]
[null,"EMISSIONS (OPERATIONAL LIFETIME COST- OLC)"]
[null,null,"CO2 Emissions","g/km",972.08,"g/km",0,"g/km",763.28,"g/km",113,"g/km",114]
[null,null,"Lifetime cost of CO2 emissions / unit",null,{"$f":"$D$70*E46*E21*$E$6","v":4374.3600000000006},null,{"$f":"$D$70*G46*G21*$E$6","v":0},null,{"$f":"$D$70*I46*I21*$E$6","v":3434.76},null,{"$f":"$D$70*K46*K21*$E$6","v":678.00000000000011},null,{"$f":"$D$70*M46*M21*$E$6","v":684}]
[null,null,"NOx (Nitrous oxides)","g/km",0.24099999999999999,"g/km",null,"g/km",0.24099999999999999,"g/km",9,"g/km",9]
[null,null,"PM (Particular Matter)","g/km",2.8999999999999998E-3,"g/km",0,"g/km",2.8999999999999998E-3,"g/km",1,"g/km",1]
[null,null,"NMHC (Non-methane hydrocarbons)","g/km",7.0000000000000001E-3,"g/km",0,"g/km",7.0000000000000001E-3,"g/km",11,"g/km",11]
[null,null,"Lifetime cost of pollutant emissions / unit",null,{"$f":"((E48*$D$67)+(E49*$D$68)+(E50*$D$69))*E21*E6","v":197.95500000000001},null,{"$f":"((G48*$D$67)+(G49*$D$68)+(G50*$D$69))*G21*G6","v":0},null,{"$f":"((I48*$D$67)+(I49*$D$68)+(I50*$D$69))*I21*I6","v":197.95500000000001},null,{"$f":"((K48*$D$67)+(K49*$D$68)+(K50*$D$69))*K21*K6","v":27520},null,{"$f":"((M48*$D$67)+(M49*$D$68)+(M50*$D$69))*M21*M6","v":27520}]
[null,null,"Reference Fuel \n(Cheapest of petrol or diesel before tax)",null,"Diesel",null,"Diesel",null,"Diesel",null,"Diesel",null,"Diesel"]
[null,null,"Cost of Reference Fuel (before tax)","€/l",0.8,"€/l",0.8,"€/l",0.8,"€/l",1.2,"€/l",1.2]
[null,null,"Lifetime cost of energy consumption / unit",null,{"$f":"Calculations!D16","v":9000},null,{"$f":"Calculations!E16","v":300.00000000000006},null,{"$f":"Calculations!F16","v":6960.0000000000009},null,{"$f":"Calculations!G16","v":{"$error":"#N/A"}},null,{"$f":"Calculations!H16","v":{"$error":"#N/A"}}]
[null,null,"OPERATION LIFETIME COST  (OLC) / UNIT",null,{"$f":"SUM(E47,E51,E54)","v":13572.315000000001},null,{"$f":"SUM(G47,G51,G54)","v":300.00000000000006},null,{"$f":"SUM(I47,I51,I54)","v":10592.715},null,{"$f":"SUM(K47,K51,K54)","v":{"$error":"#N/A"}},null,{"$f":"SUM(M47,M51,M54)","v":{"$error":"#N/A"}}]
[]
[null,"END OF LIFE"]
[null,null,"Remnant value (at end of contract period)","€/unit",null,null,1000,null,null,null,100,null,100]
[null,null,null,null,{"$f":"SUM(E58)","v":0},null,{"$f":"SUM(G58)","v":1000},null,{"$f":"SUM(I58)","v":0},null,{"$f":"SUM(K58)","v":100},null,{"$f":"SUM(M58)","v":100}]
[]
[null,null,"TOTAL LCC PER UNIT",null,{"$f":"E16+E26+E31+E43+E55+E59","v":44768.500001635759},null,{"$f":"G16+G26+G31+G43+G55+G59","v":20369.925696939266},null,{"$f":"I16+I26+I31+I43+I55+I59","v":40982.770505735105},null,{"$f":"K16+K26+K31+K43+K55+K59","v":{"$error":"#N/A"}},null,{"$f":"M16+M26+M31+M43+M55+M59","v":{"$error":"#N/A"}}]
[null,null,"TOTAL LCC",null,{"$f":"E61*E13","v":447685.00001635758},null,{"$f":"G61*G13","v":203699.25696939265},null,{"$f":"I61*I13","v":409827.70505735104},null,{"$f":"K61*K13","v":{"$error":"#N/A"}},null,{"$f":"M61*M13","v":{"$error":"#N/A"}}]
[]
[]
[null,"COST OF EMISSIONS",null,null,null,">","CLICK HERE FOR DIAGRAMS"]
[null,null,"Emission","Cost per unit €/g"]
[null,null,"NOx  (Range 0,0044-0,0088)",4.4000000000000003E-3]
[null,null,"PM  (Range 0,087-0,174)",8.6999999999999994E-2]
[null,null,"NMHC  (Range 0,001-0,002)",1E-3]
[null,null,"CO2  (Range 0.00003 - 0.00008)",3.0000000000000001E-5]
[]
[null,"FUEL PRICE INCREASES"]
[null,null,"Select option in box below"]
[null,null,"Use default OECD-FAO values"]
[]
[null,null,"Annual fuel price increase %"]
[null,null,"Diesel",0.02]
[null,null,"Petrol",0.02]
[null,null,"Natural Gas/Biogas",0]
[null,null,"Electricity",0.01]
[null,null,"Biodiesel",0.02]
[null,null,"LPG",0.05]
[null,null,"Ethanol",0.02]
[null,null,"Hydrogen (gas)",0.01]
[null,null,"Hydrogen (liquid - l/100km)",0.02]
[null,null,"Hydrogen (liquid - kg/100km)",0.02]
[null,null,"Emulsion Fuel",0.03]
[null,null,"Average fuel price per litre for:"]
[null,null,"Diesel",{"$f":"'Fuel Prices'!AB4/LCC!E6/(LCC!$E$21*(LCC!$E$20/100))","v":1.3863979379760054}]
[null,null,"Petrol",{"$f":"'Fuel Prices'!AB11/LCC!E6/(LCC!$E$21*(LCC!$E$20/100))","v":1.2946168215269973}]
[null,null,"Natural Gas/Biogas",{"$f":"'Fuel Prices'!AB46/LCC!E7/(LCC!$E$21*(LCC!$E$20/100))","v":7.3824694467314096}]
[null,null,"Electricity",{"$f":"'Fuel Prices'!AB32/LCC!E6/(LCC!$E$21*(LCC!$E$20/100))","v":1.3898570494334268}]
[null,null,"Biodiesel",{"$f":"'Fuel Prices'!AB39/LCC!E7/(LCC!$E$21*(LCC!$E$20/100))","v":7.224135017245902}]
[null,null,"LPG",{"$f":"'Fuel Prices'!AB18/LCC!E6/(LCC!$E$21*(LCC!$E$20/100))","v":1.4299696252216385}]
[null,null,"Ethanol",{"$f":"'Fuel Prices'!AB25/LCC!E6/(LCC!$E$21*(LCC!$E$20/100))","v":1.4288317391773433}]
[null,null,"Hydrogen (gas)","No figures available"]
[null,null,"Hydrogen (liquid - l/100km)","No figures available"]
[null,null,"Hydrogen (liquid - kg/100km)","No figures available"]
[null,null,"Emulsion Fuel","No figures available"]

{"sheet":"Diagram","index":2,"n_rows":27,"n_cols":23,"rows_kept":27,"cut":false,"hidden":true,"merged":[[2,1,2,17],[26,3,26,5],[27,3,27,6]]}
[]
[]
[null,"LCC RESULTS DIAGRAM"]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Operational lifetime costs"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fuel costs"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total other costs"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Maintainance costs"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Acquisition costs*"]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"*If remnant value exists it will  be subtracted from the acquisition cost in the diagram"]
[]
[]
[]
[null,null,">","BACK TO LCC-CALCULATION"]

{"sheet":"Fuel Prices","index":3,"n_rows":57,"n_cols":28,"rows_kept":57,"cut":false,"hidden":true,"merged":[[39,1,40,1],[27,1,28,1],[29,1,30,1],[31,1,32,1],[33,1,34,1],[35,1,36,1],[37,1,38,1]]}
[]
[null,null,null,null,null,null,null,null,"5 YEARS",null,null,null,null,"10 YEARS"]
[null,null,null,2014,2015,2016,2017,2018,2019,2020,2021,2022,2023,2024,null,"DIESEL",2014,2015,2016,2017,2018,2019,2020,2021,2022,2023,2024,"Total fuel price for period"]
["Diesel ","$/gallon","Forecasted price",3.6833300000000002,3.5441319999999998,3.4952230000000002,3.4971399999999999,3.533868,3.6106159999999998,3.671875,3.7407020000000002,3.815766,3.868004,3.9180830000000002,null,"Product 1",{"$f":"((LCC!$E$21*(LCC!$E$20/100))*LCC!$E$22)","v":1575},{"$f":"((LCC!$E$21*(LCC!$E$20/100))*(LCC!$E$22*(1+$E$6)))","v":1515.4786293924244},{"$f":"((LCC!$E$21*(LCC!$E$20/100))*(LCC!$E$22*(1+$F$6)))","v":1493.7436389913901},{"$f":"((LCC!$E$21*(LCC!$E$20/100))*(LCC!$E$22*(1+$G$6)))","v":1494.607467994575},{"$f":"((LCC!$E$21*(LCC!$E$20/100))*(LCC!$E$22*(1+$H$6)))","v":1511.1485844497358},{"$f":"((LCC!$E$21*(LCC!$E$20/100))*(LCC!$E$22*(1+$I$6)))","v":1545.3541914503367},{"$f":"((LCC!$E$21*(LCC!$E$20/100))*(LCC!$E$22*(1+$J$6)))","v":1572.0762037053091},{"$f":"((LCC!$E$21*(LCC!$E$20/100))*(LCC!$E$22*(1+$K$6)))","v":1601.5985934925434},{"$f":"((LCC!$E$21*(LCC!$E$20/100))*(LCC!$E$22*(1+$L$6)))","v":1633.2038376419032},{"$f":"((LCC!$E$21*(LCC!$E$20/100))*(LCC!$E$22*(1+$M$6)))","v":1654.7656551118423},{"$f":"((LCC!$E$21*(LCC!$E$20/100))*(LCC!$E$22*(1+$N$6)))","v":1675.1571606532023},{"$f":"SUM(Q4:INDEX(Q4:AA4,LCC!$E$6))","v":15596.97680223006}]
[null,null,"% against previous yr",null,{"$f":"(E4-D4)/D4","v":-3.779134641750817E-2},{"$f":"(F4-E4)/E4","v":-1.3799993905418773E-2},5.4846285916513031E-4,1.0502296162006696E-2,2.1717845714667276E-2,1.6966356987284215E-2,1.8744374468085159E-2,2.0066821682133404E-2,1.3690042838056634E-2,1.2946987645307556E-2,null,"Product 2",{"$f":"((LCC!$G$21*(LCC!$G$20/100))*LCC!$G$22)","v":48.75},{"$f":"((LCC!$G$21*(LCC!$G$20/100))*(LCC!$G$22*(1+$E$6)))","v":46.907671862146479},{"$f":"((LCC!$G$21*(LCC!$G$20/100))*(LCC!$G$22*(1+$F$6)))","v":46.234922159257316},{"$f":"((LCC!$G$21*(LCC!$G$20/100))*(LCC!$G$22*(1+$G$6)))","v":46.261659723641614},{"$f":"((LCC!$G$21*(LCC!$G$20/100))*(LCC!$G$22*(1+$H$6)))","v":46.773646661539445},{"$f":"((LCC!$G$21*(LCC!$G$20/100))*(LCC!$G$22*(1+$I$6)))","v":47.832391640129472},{"$f":"((LCC!$G$21*(LCC!$G$20/100))*(LCC!$G$22*(1+$J$6)))","v":48.65950154325958},{"$f":"((LCC!$G$21*(LCC!$G$20/100))*(LCC!$G$22*(1+$K$6)))","v":49.57328979857872},{"$f":"((LCC!$G$21*(LCC!$G$20/100))*(LCC!$G$22*(1+$L$6)))","v":50.551547355582727},{"$f":"((LCC!$G$21*(LCC!$G$20/100))*(LCC!$G$22*(1+$M$6)))","v":51.218936943937983},{"$f":"((LCC!$G$21*(LCC!$G$20/100))*(LCC!$G$22*(1+$N$6)))","v":51.850102591646731},{"$f":"SUM(Q5:INDEX(Q5:AA5,LCC!$G$6))","v":482.76356768807335}]
[null,null,"% cumulative",null,{"$f":"E5","v":-3.779134641750817E-2},{"$f":"F5+E6","v":-5.1591340322926942E-2},{"$f":"G5+F6","v":-5.1042877463761814E-2},-4.054058130175512E-2,-1.8822735587087844E-2,-1.8563785998036292E-3,1.6887995868281529E-2,3.6954817550414937E-2,5.0644860388471574E-2,6.3591848033779125E-2,null,"Product 3",{"$f":"((LCC!$I$21*(LCC!$I$20/100))*LCC!$I$22)","v":1435.5000000000002},{"$f":"((LCC!$I$21*(LCC!$I$20/100))*(LCC!$I$22*(1+$E$6)))","v":1381.2505222176671},{"$f":"((LCC!$I$21*(LCC!$I$20/100))*(LCC!$I$22*(1+$F$6)))","v":1361.4406309664384},{"$f":"((LCC!$I$21*(LCC!$I$20/100))*(LCC!$I$22*(1+$G$6)))","v":1362.2279494007701},{"$f":"((LCC!$I$21*(LCC!$I$20/100))*(LCC!$I$22*(1+$H$6)))","v":1377.3039955413308},{"$f":"((LCC!$I$21*(LCC!$I$20/100))*(LCC!$I$22*(1+$I$6)))","v":1408.4799630647356},{"$f":"((LCC!$I$21*(LCC!$I$20/100))*(LCC!$I$22*(1+$J$6)))","v":1432.8351685199823},{"$f":"((LCC!$I$21*(LCC!$I$20/100))*(LCC!$I$22*(1+$K$6)))","v":1459.7427180689183},{"$f":"((LCC!$I$21*(LCC!$I$20/100))*(LCC!$I$22*(1+$L$6)))","v":1488.5486405936206},{"$f":"((LCC!$I$21*(LCC!$I$20/100))*(LCC!$I$22*(1+$M$6)))","v":1508.200697087651},{"$f":"((LCC!$I$21*(LCC!$I$20/100))*(LCC!$I$22*(1+$N$6)))","v":1526.7860978524902},{"$f":"SUM(Q6:INDEX(Q6:AA6,LCC!$I$6))","v":14215.530285461115}]
["Petrol","$/gallon","Forecasted price",3.3808379999999998,3.1774,3.0719460000000001,3.0273970000000001,3.0207419999999998,3.0347240000000002,3.077188,3.1208870000000002,3.1696469999999999,3.220602,3.261647,null,"Product 4",{"$f":"((LCC!$K$21*(LCC!$K$20/100))*LCC!$K$22)","v":1700},{"$f":"((LCC!$K$21*(LCC!$K$20/100))*(LCC!$K$22*(1+$E$6)))","v":1635.7547110902362},{"$f":"((LCC!$K$21*(LCC!$K$20/100))*(LCC!$K$22*(1+$F$6)))","v":1612.2947214510241},{"$f":"((LCC!$K$21*(LCC!$K$20/100))*(LCC!$K$22*(1+$G$6)))","v":1613.227108311605},{"$f":"((LCC!$K$21*(LCC!$K$20/100))*(LCC!$K$22*(1+$H$6)))","v":1631.0810117870162},{"$f":"((LCC!$K$21*(LCC!$K$20/100))*(LCC!$K$22*(1+$I$6)))","v":1668.0013495019507},{"$f":"((LCC!$K$21*(LCC!$K$20/100))*(LCC!$K$22*(1+$J$6)))","v":1696.8441563803337},{"$f":"((LCC!$K$21*(LCC!$K$20/100))*(LCC!$K$22*(1+$K$6)))","v":1728.7095929760785},{"$f":"((LCC!$K$21*(LCC!$K$20/100))*(LCC!$K$22*(1+$L$6)))","v":1762.8231898357051},{"$f":"((LCC!$K$21*(LCC!$K$20/100))*(LCC!$K$22*(1+$M$6)))","v":1786.0962626604016},{"$f":"((LCC!$K$21*(LCC!$K$20/100))*(LCC!$K$22*(1+$N$6)))","v":1808.1061416574244},{"$f":"SUM(Q7:INDEX(Q7:AA7,LCC!$K$6))","v":16834.832103994351}]
[null,null,"%against previous yr",null,{"$f":"(E7-D7)/D7","v":-6.0173838557186062E-2},{"$f":"(F7-E7)/E7","v":-3.3188770693019433E-2},-1.4501882520070323E-2,-2.1982581075426512E-3,4.62866408319558E-3,1.3992705761710071E-2,1.4200952298007191E-2,1.5623763372400118E-2,1.6075922650061691E-2,1.2744511740351648E-2," ","Product 5",{"$f":"((LCC!$M$21*(LCC!$M$20/100))*LCC!$M$22)","v":330},{"$f":"((LCC!$M$21*(LCC!$M$20/100))*(LCC!$M$22*(1+$E$6)))","v":317.52885568222229},{"$f":"((LCC!$M$21*(LCC!$M$20/100))*(LCC!$M$22*(1+$F$6)))","v":312.9748576934341},{"$f":"((LCC!$M$21*(LCC!$M$20/100))*(LCC!$M$22*(1+$G$6)))","v":313.15585043695859},{"$f":"((LCC!$M$21*(LCC!$M$20/100))*(LCC!$M$22*(1+$H$6)))","v":316.62160817042081},{"$f":"((LCC!$M$21*(LCC!$M$20/100))*(LCC!$M$22*(1+$I$6)))","v":323.78849725626105},{"$f":"((LCC!$M$21*(LCC!$M$20/100))*(LCC!$M$22*(1+$J$6)))","v":329.3873950620648},{"$f":"((LCC!$M$21*(LCC!$M$20/100))*(LCC!$M$22*(1+$K$6)))","v":335.57303863653283},{"$f":"((LCC!$M$21*(LCC!$M$20/100))*(LCC!$M$22*(1+$L$6)))","v":342.19508979163692},{"$f":"((LCC!$M$21*(LCC!$M$20/100))*(LCC!$M$22*(1+$M$6)))","v":346.71280392819557},{"$f":"((LCC!$M$21*(LCC!$M$20/100))*(LCC!$M$22*(1+$N$6)))","v":350.98530985114712},{"$f":"SUM(Q8:INDEX(Q8:AA8,LCC!$M$6))","v":3267.9379966577267}]
[null,null,"%cumulative",null,{"$f":"E8","v":-6.0173838557186062E-2},{"$f":"F8+E9","v":-9.3362609250205494E-2},{"$f":"G8+F9","v":-0.10786449177027582},-0.11006274987781847,-0.10543408579462289,-9.1441380032912828E-2,-7.7240427734905637E-2,-6.161666436250552E-2,-4.5540741712443829E-2,-3.2796229972092181E-2]
["LPG","$/gallon","Forecasted price",2.1892990000000001,2.1427740000000002,2.1454360000000001,2.1942110000000001,2.2315330000000002,2.2541479999999998,2.2695509999999999,2.294362,2.3139639999999999,2.328557,2.3463189999999998,null,"PETROL",2014,2015,2016,2017,2018,2019,2020,2021,2022,2023,2024,"Total fuel price for period"]
[null,null,"% against previous yr",null,{"$f":"(E10-D10)/D10","v":-2.1251094528431214E-2},{"$f":"(F10-E10)/E10","v":1.2423148684835368E-3},2.2734306686379838E-2,1.7009303116245465E-2,1.0134288849862227E-2,6.8331804300339003E-3,1.0932118291239166E-2,8.5435515406896978E-3,6.3064939644696628E-3,7.6279000256381244E-3,null,"Product 1",{"$f":"((LCC!$E$21*(LCC!$E$20/100))*LCC!$E$22)","v":1575},{"$f":"((LCC!$E$21*(LCC!$E$20/100))*(LCC!$E$22*(1+$E$9)))","v":1480.2262042724317},{"$f":"((LCC!$E$21*(LCC!$E$20/100))*(LCC!$E$22*(1+$F$9)))","v":1427.9538904309265},{"$f":"((LCC!$E$21*(LCC!$E$20/100))*(LCC!$E$22*(1+$G$9)))","v":1405.1134254618155},{"$f":"((LCC!$E$21*(LCC!$E$20/100))*(LCC!$E$22*(1+$H$9)))","v":1401.6511689424358},{"$f":"((LCC!$E$21*(LCC!$E$20/100))*(LCC!$E$22*(1+$I$9)))","v":1408.9413148734691},{"$f":"((LCC!$E$21*(LCC!$E$20/100))*(LCC!$E$22*(1+$J$9)))","v":1430.9798264481622},{"$f":"((LCC!$E$21*(LCC!$E$20/100))*(LCC!$E$22*(1+$K$9)))","v":1453.3463263175233},{"$f":"((LCC!$E$21*(LCC!$E$20/100))*(LCC!$E$22*(1+$L$9)))","v":1477.9537536290536},{"$f":"((LCC!$E$21*(LCC!$E$20/100))*(LCC!$E$22*(1+$M$9)))","v":1503.2733318029009},{"$f":"((LCC!$E$21*(LCC!$E$20/100))*(LCC!$E$22*(1+$N$9)))","v":1523.3459377939548},{"$f":"SUM(Q11:INDEX(Q11:AA11,LCC!$E$6))","v":14564.439242178718}]
[null,null,"% cumulative",null,{"$f":"E11","v":-2.1251094528431214E-2},{"$f":"F11+E12","v":-2.0008779659947677E-2},{"$f":"G11+F12","v":2.7255270264321604E-3},1.9734830142677625E-2,2.9869118992539852E-2,3.6702299422573754E-2,4.7634417713812924E-2,5.6177969254502622E-2,6.2484463218972282E-2,7.0112363244610412E-2,null,"Product 2",{"$f":"((LCC!$G$21*(LCC!$G$20/100))*LCC!$G$22)","v":48.75},{"$f":"((LCC!$G$21*(LCC!$G$20/100))*(LCC!$G$22*(1+$E$9)))","v":45.816525370337182},{"$f":"((LCC!$G$21*(LCC!$G$20/100))*(LCC!$G$22*(1+$F$9)))","v":44.198572799052485},{"$f":"((LCC!$G$21*(LCC!$G$20/100))*(LCC!$G$22*(1+$G$9)))","v":43.491606026199058},{"$f":"((LCC!$G$21*(LCC!$G$20/100))*(LCC!$G$22*(1+$H$9)))","v":43.384440943456354},{"$f":"((LCC!$G$21*(LCC!$G$20/100))*(LCC!$G$22*(1+$I$9)))","v":43.610088317512137},{"$f":"((LCC!$G$21*(LCC!$G$20/100))*(LCC!$G$22*(1+$J$9)))","v":44.2922327233955},{"$f":"((LCC!$G$21*(LCC!$G$20/100))*(LCC!$G$22*(1+$K$9)))","v":44.984529147923347},{"$f":"((LCC!$G$21*(LCC!$G$20/100))*(LCC!$G$22*(1+$L$9)))","v":45.746187612327859},{"$f":"((LCC!$G$21*(LCC!$G$20/100))*(LCC!$G$22*(1+$M$9)))","v":46.529888841518364},{"$f":"((LCC!$G$21*(LCC!$G$20/100))*(LCC!$G$22*(1+$N$9)))","v":47.151183788860514},{"$f":"SUM(Q12:INDEX(Q12:AA12,LCC!$G$6))","v":450.80407178172226}]
["Ethanol","$/gallon","Forecasted price",2.5707420000000001,2.5745960000000001,2.5772849999999998,2.5795370000000002,2.5812029999999999,2.5974710000000001,2.6644839999999999,2.691967,2.7039330000000001,2.7027369999999999,2.602026,null,"Product 3",{"$f":"((LCC!$I$21*(LCC!$I$20/100))*LCC!$I$22)","v":1435.5000000000002},{"$f":"((LCC!$I$21*(LCC!$I$20/100))*(LCC!$I$22*(1+$E$9)))","v":1349.1204547511595},{"$f":"((LCC!$I$21*(LCC!$I$20/100))*(LCC!$I$22*(1+$F$9)))","v":1301.4779744213301},{"$f":"((LCC!$I$21*(LCC!$I$20/100))*(LCC!$I$22*(1+$G$9)))","v":1280.6605220637693},{"$f":"((LCC!$I$21*(LCC!$I$20/100))*(LCC!$I$22*(1+$H$9)))","v":1277.5049225503917},{"$f":"((LCC!$I$21*(LCC!$I$20/100))*(LCC!$I$22*(1+$I$9)))","v":1284.149369841819},{"$f":"((LCC!$I$21*(LCC!$I$20/100))*(LCC!$I$22*(1+$J$9)))","v":1304.2358989627537},{"$f":"((LCC!$I$21*(LCC!$I$20/100))*(LCC!$I$22*(1+$K$9)))","v":1324.621365986543},{"$f":"((LCC!$I$21*(LCC!$I$20/100))*(LCC!$I$22*(1+$L$9)))","v":1347.0492783076234},{"$f":"((LCC!$I$21*(LCC!$I$20/100))*(LCC!$I$22*(1+$M$9)))","v":1370.1262652717869},{"$f":"((LCC!$I$21*(LCC!$I$20/100))*(LCC!$I$22*(1+$N$9)))","v":1388.4210118750616},{"$f":"SUM(Q13:INDEX(Q13:AA13,LCC!$I$6))","v":13274.446052157176}]
[null,null,"% against previous yr",null,{"$f":"(E13-D13)/D13","v":1.4991780583193583E-3},{"$f":"(F13-E13)/E13","v":1.0444357095248029E-3},8.7378772623142764E-4,6.4585233706658334E-4,6.3024876385159058E-3,2.5799325574760897E-2,1.0314567473477096E-2,4.4450767784301008E-3,-4.4231865212643838E-4,-3.7262597137642323E-2,null,"Product 4",{"$f":"((LCC!$K$21*(LCC!$K$20/100))*LCC!$K$22)","v":1700},{"$f":"((LCC!$K$21*(LCC!$K$20/100))*(LCC!$K$22*(1+$E$9)))","v":1597.7044744527836},{"$f":"((LCC!$K$21*(LCC!$K$20/100))*(LCC!$K$22*(1+$F$9)))","v":1541.2835642746506},{"$f":"((LCC!$K$21*(LCC!$K$20/100))*(LCC!$K$22*(1+$G$9)))","v":1516.6303639905311},{"$f":"((LCC!$K$21*(LCC!$K$20/100))*(LCC!$K$22*(1+$H$9)))","v":1512.8933252077086},{"$f":"((LCC!$K$21*(LCC!$K$20/100))*(LCC!$K$22*(1+$I$9)))","v":1520.762054149141},{"$f":"((LCC!$K$21*(LCC!$K$20/100))*(LCC!$K$22*(1+$J$9)))","v":1544.5496539440483},{"$f":"((LCC!$K$21*(LCC!$K$20/100))*(LCC!$K$22*(1+$K$9)))","v":1568.6912728506604},{"$f":"((LCC!$K$21*(LCC!$K$20/100))*(LCC!$K$22*(1+$L$9)))","v":1595.2516705837404},{"$f":"((LCC!$K$21*(LCC!$K$20/100))*(LCC!$K$22*(1+$M$9)))","v":1622.5807390888453},{"$f":"((LCC!$K$21*(LCC!$K$20/100))*(LCC!$K$22*(1+$N$9)))","v":1644.2464090474432},{"$f":"SUM(Q14:INDEX(Q14:AA14,LCC!$K$6))","v":15720.347118542109}]
[null,null,"% cumulative",null,{"$f":"E14","v":1.4991780583193583E-3},{"$f":"F14+E15","v":2.5436137678441612E-3},{"$f":"G14+F15","v":3.4174014940755891E-3},4.0632538311421726E-3,1.0365741469658078E-2,3.6165067044418978E-2,4.6479634517896072E-2,5.0924711296326169E-2,5.0482392644199729E-2,1.3219795506557407E-2,null,"Product 5",{"$f":"((LCC!$M$21*(LCC!$M$20/100))*LCC!$M$22)","v":330},{"$f":"((LCC!$M$21*(LCC!$M$20/100))*(LCC!$M$22*(1+$E$9)))","v":310.14263327612855},{"$f":"((LCC!$M$21*(LCC!$M$20/100))*(LCC!$M$22*(1+$F$9)))","v":299.19033894743217},{"$f":"((LCC!$M$21*(LCC!$M$20/100))*(LCC!$M$22*(1+$G$9)))","v":294.404717715809},{"$f":"((LCC!$M$21*(LCC!$M$20/100))*(LCC!$M$22*(1+$H$9)))","v":293.67929254031986},{"$f":"((LCC!$M$21*(LCC!$M$20/100))*(LCC!$M$22*(1+$I$9)))","v":295.20675168777444},{"$f":"((LCC!$M$21*(LCC!$M$20/100))*(LCC!$M$22*(1+$J$9)))","v":299.82434458913878},{"$f":"((LCC!$M$21*(LCC!$M$20/100))*(LCC!$M$22*(1+$K$9)))","v":304.51065884748112},{"$f":"((LCC!$M$21*(LCC!$M$20/100))*(LCC!$M$22*(1+$L$9)))","v":309.66650076037314},{"$f":"((LCC!$M$21*(LCC!$M$20/100))*(LCC!$M$22*(1+$M$9)))","v":314.97155523489351},{"$f":"((LCC!$M$21*(LCC!$M$20/100))*(LCC!$M$22*(1+$N$9)))","v":319.17724410920954},{"$f":"SUM(Q15:INDEX(Q15:AA15,LCC!$M$6))","v":3051.5967935993508}]
["Electricity","$cents/kwathour","Forecasted price",10.217000000000001,10.143057000000001,10.121601999999999,10.095456,10.162350999999999,10.245552999999999,10.188694999999999,10.146483,10.065858,10.040848,10.164512]
[null,null,"% against previous yr",null,{"$f":"(E16-D16)/D16","v":-7.2372516394244753E-3},{"$f":"(F16-E16)/E16","v":-2.1152400109751262E-3},-2.5831879182760687E-3,6.6262484824854678E-3,8.1872787113926697E-3,-5.5495296349548024E-3,-4.1430232232880912E-3,-7.946103097989668E-3,-2.4846366797544707E-3,1.231609123054146E-2,null,"LPG",2014,2015,2016,2017,2018,2019,2020,2021,2022,2023,2024,"Total fuel price for period"]
[null,null,"% cumulative",null,{"$f":"E17","v":-7.2372516394244753E-3},{"$f":"F17+E18","v":-9.3524916503996015E-3},{"$f":"G17+F18","v":-1.193567956867567E-2},-5.3094310861902024E-3,2.8778476252024673E-3,-2.6716820097523351E-3,-6.8147052330404263E-3,-1.4760808331030094E-2,-1.7245445010784566E-2,-4.9293537802431054E-3,null,"Product 1",{"$f":"((LCC!$E$21*(LCC!$E$20/100))*LCC!$E$22)","v":1575},{"$f":"((LCC!$E$21*(LCC!$E$20/100))*(LCC!$E$22*(1+$E$12)))","v":1541.5295261177207},{"$f":"((LCC!$E$21*(LCC!$E$20/100))*(LCC!$E$22*(1+$F$12)))","v":1543.4861720355823},{"$f":"((LCC!$E$21*(LCC!$E$20/100))*(LCC!$E$22*(1+$G$12)))","v":1579.2927050666306},{"$f":"((LCC!$E$21*(LCC!$E$20/100))*(LCC!$E$22*(1+$H$12)))","v":1606.0823574747171},{"$f":"((LCC!$E$21*(LCC!$E$20/100))*(LCC!$E$22*(1+$I$12)))","v":1622.0438624132501},{"$f":"((LCC!$E$21*(LCC!$E$20/100))*(LCC!$E$22*(1+$J$12)))","v":1632.8061215905539},{"$f":"((LCC!$E$21*(LCC!$E$20/100))*(LCC!$E$22*(1+$K$12)))","v":1650.0242078992551},{"$f":"((LCC!$E$21*(LCC!$E$20/100))*(LCC!$E$22*(1+$L$12)))","v":1663.4803015758416},{"$f":"((LCC!$E$21*(LCC!$E$20/100))*(LCC!$E$22*(1+$M$12)))","v":1673.4130295698812},{"$f":"((LCC!$E$21*(LCC!$E$20/100))*(LCC!$E$22*(1+$N$12)))","v":1685.4269721102612},{"$f":"SUM(Q18:INDEX(Q18:AA18,LCC!$E$6))","v":16087.158283743433}]
["Biodiesel","$/100 liters","Forecasted price",156.19999999999999,153.5,148.80000000000001,154.69999999999999,159.80000000000001,159.80000000000001,164.3,167,173,175,177.6,null,"Product 2",{"$f":"((LCC!$G$21*(LCC!$G$20/100))*LCC!$G$22)","v":48.75},{"$f":"((LCC!$G$21*(LCC!$G$20/100))*(LCC!$G$22*(1+$E$12)))","v":47.714009141738984},{"$f":"((LCC!$G$21*(LCC!$G$20/100))*(LCC!$G$22*(1+$F$12)))","v":47.774571991577552},{"$f":"((LCC!$G$21*(LCC!$G$20/100))*(LCC!$G$22*(1+$G$12)))","v":48.882869442538571},{"$f":"((LCC!$G$21*(LCC!$G$20/100))*(LCC!$G$22*(1+$H$12)))","v":49.712072969455534},{"$f":"((LCC!$G$21*(LCC!$G$20/100))*(LCC!$G$22*(1+$I$12)))","v":50.206119550886307},{"$f":"((LCC!$G$21*(LCC!$G$20/100))*(LCC!$G$22*(1+$J$12)))","v":50.539237096850478},{"$f":"((LCC!$G$21*(LCC!$G$20/100))*(LCC!$G$22*(1+$K$12)))","v":51.072177863548383},{"$f":"((LCC!$G$21*(LCC!$G$20/100))*(LCC!$G$22*(1+$L$12)))","v":51.488676001156996},{"$f":"((LCC!$G$21*(LCC!$G$20/100))*(LCC!$G$22*(1+$M$12)))","v":51.796117581924896},{"$f":"((LCC!$G$21*(LCC!$G$20/100))*(LCC!$G$22*(1+$N$12)))","v":52.16797770817476},{"$f":"SUM(Q19:INDEX(Q19:AA19,LCC!$G$6))","v":497.93585163967765}]
[null,null,"% against previous yr",null,{"$f":"(E19-D19)/D19","v":-1.728553137003834E-2},{"$f":"(F19-E19)/E19","v":-3.0618892508143248E-2},3.9650537634408449E-2,3.2967032967033114E-2,0,2.8160200250312888E-2,1.6433353621424153E-2,3.5928143712574849E-2,1.1560693641618497E-2,1.4857142857142824E-2,null,"Product 3",{"$f":"((LCC!$I$21*(LCC!$I$20/100))*LCC!$I$22)","v":1435.5000000000002},{"$f":"((LCC!$I$21*(LCC!$I$20/100))*(LCC!$I$22*(1+$E$12)))","v":1404.994053804437},{"$f":"((LCC!$I$21*(LCC!$I$20/100))*(LCC!$I$22*(1+$F$12)))","v":1406.7773967981454},{"$f":"((LCC!$I$21*(LCC!$I$20/100))*(LCC!$I$22*(1+$G$12)))","v":1439.4124940464435},{"$f":"((LCC!$I$21*(LCC!$I$20/100))*(LCC!$I$22*(1+$H$12)))","v":1463.8293486698137},{"$f":"((LCC!$I$21*(LCC!$I$20/100))*(LCC!$I$22*(1+$I$12)))","v":1478.377120313791},{"$f":"((LCC!$I$21*(LCC!$I$20/100))*(LCC!$I$22*(1+$J$12)))","v":1488.1861508211048},{"$f":"((LCC!$I$21*(LCC!$I$20/100))*(LCC!$I$22*(1+$K$12)))","v":1503.8792066281785},{"$f":"((LCC!$I$21*(LCC!$I$20/100))*(LCC!$I$22*(1+$L$12)))","v":1516.1434748648387},{"$f":"((LCC!$I$21*(LCC!$I$20/100))*(LCC!$I$22*(1+$M$12)))","v":1525.1964469508348},{"$f":"((LCC!$I$21*(LCC!$I$20/100))*(LCC!$I$22*(1+$N$12)))","v":1536.1462974376382},{"$f":"SUM(Q20:INDEX(Q20:AA20,LCC!$I$6))","v":14662.295692897587}]
[null,null,"% cumulative",null,{"$f":"E20","v":-1.728553137003834E-2},{"$f":"F20+E21","v":-4.7904423878181585E-2},{"$f":"G20+F21","v":-8.2538862437731356E-3},2.4713146723259978E-2,2.4713146723259978E-2,5.2873346973572863E-2,6.9306700594997023E-2,0.10523484430757188,0.11679553794919037,0.13165268080633319,null,"Product 4",{"$f":"((LCC!$K$21*(LCC!$K$20/100))*LCC!$K$22)","v":1700},{"$f":"((LCC!$K$21*(LCC!$K$20/100))*(LCC!$K$22*(1+$E$12)))","v":1663.8731393016667},{"$f":"((LCC!$K$21*(LCC!$K$20/100))*(LCC!$K$22*(1+$F$12)))","v":1665.9850745780891},{"$f":"((LCC!$K$21*(LCC!$K$20/100))*(LCC!$K$22*(1+$G$12)))","v":1704.6333959449346},{"$f":"((LCC!$K$21*(LCC!$K$20/100))*(LCC!$K$22*(1+$H$12)))","v":1733.5492112425518},{"$f":"((LCC!$K$21*(LCC!$K$20/100))*(LCC!$K$22*(1+$I$12)))","v":1750.7775022873175},{"$f":"((LCC!$K$21*(LCC!$K$20/100))*(LCC!$K$22*(1+$J$12)))","v":1762.3939090183756},{"$f":"((LCC!$K$21*(LCC!$K$20/100))*(LCC!$K$22*(1+$K$12)))","v":1780.9785101134819},{"$f":"((LCC!$K$21*(LCC!$K$20/100))*(LCC!$K$22*(1+$L$9)))","v":1595.2516705837404},{"$f":"((LCC!$K$21*(LCC!$K$20/100))*(LCC!$K$22*(1+$M$9)))","v":1622.5807390888453},{"$f":"((LCC!$K$21*(LCC!$K$20/100))*(LCC!$K$22*(1+$N$12)))","v":1819.1910175158375},{"$f":"SUM(Q21:INDEX(Q21:AA21,LCC!$K$6))","v":16980.023152159003}]
["Natural Gas","$/million Btu","Forecasted price",16.09,16.100000000000001,16.52,16.73,17.02,17.170000000000002,17.260000000000002,17.41,17.7,17.96,18.170000000000002,null,"Product 5",{"$f":"((LCC!$M$21*(LCC!$M$20/100))*LCC!$M$22)","v":330},{"$f":"((LCC!$M$21*(LCC!$M$20/100))*(LCC!$M$22*(1+$E$12)))","v":322.98713880561769},{"$f":"((LCC!$M$21*(LCC!$M$20/100))*(LCC!$M$22*(1+$F$12)))","v":323.3971027122173},{"$f":"((LCC!$M$21*(LCC!$M$20/100))*(LCC!$M$22*(1+$G$12)))","v":330.89942391872262},{"$f":"((LCC!$M$21*(LCC!$M$20/100))*(LCC!$M$22*(1+$H$12)))","v":336.51249394708361},{"$f":"((LCC!$M$21*(LCC!$M$20/100))*(LCC!$M$22*(1+$I$12)))","v":339.8568092675381},{"$f":"((LCC!$M$21*(LCC!$M$20/100))*(LCC!$M$22*(1+$J$12)))","v":342.11175880944938},{"$f":"((LCC!$M$21*(LCC!$M$20/100))*(LCC!$M$22*(1+$K$12)))","v":345.71935784555825},{"$f":"((LCC!$M$21*(LCC!$M$20/100))*(LCC!$M$22*(1+$L$12)))","v":348.53872985398584},{"$f":"((LCC!$M$21*(LCC!$M$20/100))*(LCC!$M$22*(1+$M$12)))","v":350.61987286226088},{"$f":"((LCC!$M$21*(LCC!$M$20/100))*(LCC!$M$22*(1+$N$12)))","v":353.13707987072138},{"$f":"SUM(Q22:INDEX(Q22:AA22,LCC!$M$6))","v":3370.642688022433}]
[null,null,"% against previous yr",null,{"$f":"(E22-D22)/D22","v":6.2150403977635576E-4},{"$f":"(F22-E22)/E22","v":2.6086956521739015E-2},1.2711864406779712E-2,1.7334130304841551E-2,8.8131609870741555E-3,5.2417006406522918E-3,8.6906141367322463E-3,1.6657093624353771E-2,1.4689265536723253E-2,1.1692650334075771E-2]
[null,null,"% cumulative",null,{"$f":"E23","v":6.2150403977635576E-4},{"$f":"F23+E24","v":2.6708460561515369E-2},{"$f":"G23+F24","v":3.9420324968295083E-2},5.6754455273136634E-2,6.5567616260210793E-2,7.080931690086309E-2,7.9499931037595339E-2,9.6157024661949114E-2,0.11084629019867237,0.12253894053274814,null,"ETHANOL",2014,2015,2016,2017,2018,2019,2020,2021,2022,2023,2024,"Total fuel price for period"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Product 1",{"$f":"((LCC!$E$21*(LCC!$E$20/100))*LCC!$E$22)","v":1575},{"$f":"((LCC!$E$21*(LCC!$E$20/100))*(LCC!$E$22*(1+$E$15)))","v":1577.3612054418529},{"$f":"((LCC!$E$21*(LCC!$E$20/100))*(LCC!$E$22*(1+$F$15)))","v":1579.0061916843545},{"$f":"((LCC!$E$21*(LCC!$E$20/100))*(LCC!$E$22*(1+$G$15)))","v":1580.3824073531689},{"$f":"((LCC!$E$21*(LCC!$E$20/100))*(LCC!$E$22*(1+$H$15)))","v":1581.3996247840491},{"$f":"((LCC!$E$21*(LCC!$E$20/100))*(LCC!$E$22*(1+$I$15)))","v":1591.3260428147112},{"$f":"((LCC!$E$21*(LCC!$E$20/100))*(LCC!$E$22*(1+$J$15)))","v":1631.9599805949597},{"$f":"((LCC!$E$21*(LCC!$E$20/100))*(LCC!$E$22*(1+$K$15)))","v":1648.2054243656864},{"$f":"((LCC!$E$21*(LCC!$E$20/100))*(LCC!$E$22*(1+$L$15)))","v":1655.2064202917138},{"$f":"((LCC!$E$21*(LCC!$E$20/100))*(LCC!$E$22*(1+$M$15)))","v":1654.5097684146147},{"$f":"((LCC!$E$21*(LCC!$E$20/100))*(LCC!$E$22*(1+$N$15)))","v":1595.8211779228277},{"$f":"SUM(Q25:INDEX(Q25:AA25,LCC!$E$6))","v":16074.357065745111}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Product 2",{"$f":"((LCC!$G$21*(LCC!$G$20/100))*LCC!$G$22)","v":48.75},{"$f":"((LCC!$G$21*(LCC!$G$20/100))*(LCC!$G$22*(1+$E$15)))","v":48.823084930343065},{"$f":"((LCC!$G$21*(LCC!$G$20/100))*(LCC!$G$22*(1+$F$15)))","v":48.874001171182393},{"$f":"((LCC!$G$21*(LCC!$G$20/100))*(LCC!$G$22*(1+$G$15)))","v":48.916598322836187},{"$f":"((LCC!$G$21*(LCC!$G$20/100))*(LCC!$G$22*(1+$H$15)))","v":48.948083624268186},{"$f":"((LCC!$G$21*(LCC!$G$20/100))*(LCC!$G$22*(1+$I$15)))","v":49.255329896645833},{"$f":"((LCC!$G$21*(LCC!$G$20/100))*(LCC!$G$22*(1+$J$15)))","v":50.513047018415421},{"$f":"((LCC!$G$21*(LCC!$G$20/100))*(LCC!$G$22*(1+$K$15)))","v":51.015882182747447},{"$f":"((LCC!$G$21*(LCC!$G$20/100))*(LCC!$G$22*(1+$L$15)))","v":51.232579675695902},{"$f":"((LCC!$G$21*(LCC!$G$20/100))*(LCC!$G$22*(1+$M$15)))","v":51.21101664140474},{"$f":"((LCC!$G$21*(LCC!$G$20/100))*(LCC!$G$22*(1+$N$15)))","v":49.394465030944673},{"$f":"SUM(Q26:INDEX(Q26:AA26,LCC!$G$6))","v":497.53962346353921}]
[null,null,null,2014,"2017 (3 yrs)","2019 (5yrs)","2024 (10yrs)","Product 1","Product 2","Product 3","Product 4","Product 5",null,null,null,"Product 3",{"$f":"((LCC!$I$21*(LCC!$I$20/100))*LCC!$I$22)","v":1435.5000000000002},{"$f":"((LCC!$I$21*(LCC!$I$20/100))*(LCC!$I$22*(1+$E$15)))","v":1437.6520701027175},{"$f":"((LCC!$I$21*(LCC!$I$20/100))*(LCC!$I$22*(1+$F$15)))","v":1439.1513575637402},{"$f":"((LCC!$I$21*(LCC!$I$20/100))*(LCC!$I$22*(1+$G$15)))","v":1440.4056798447455},{"$f":"((LCC!$I$21*(LCC!$I$20/100))*(LCC!$I$22*(1+$H$15)))","v":1441.3328008746048},{"$f":"((LCC!$I$21*(LCC!$I$20/100))*(LCC!$I$22*(1+$I$15)))","v":1450.3800218796941},{"$f":"((LCC!$I$21*(LCC!$I$20/100))*(LCC!$I$22*(1+$J$15)))","v":1487.4149537422634},{"$f":"((LCC!$I$21*(LCC!$I$20/100))*(LCC!$I$22*(1+$K$15)))","v":1502.2215153504399},{"$f":"((LCC!$I$21*(LCC!$I$20/100))*(LCC!$I$22*(1+$L$15)))","v":1508.6024230658766},{"$f":"((LCC!$I$21*(LCC!$I$20/100))*(LCC!$I$22*(1+$M$15)))","v":1507.9674746407488},{"$f":"((LCC!$I$21*(LCC!$I$20/100))*(LCC!$I$22*(1+$N$15)))","v":1454.4770164496633},{"$f":"SUM(Q27:INDEX(Q27:AA27,LCC!$I$6))","v":14650.628297064832}]
[null,"Diesel ","Forecasted price ($/gallon)",3.68,3.5,3.61,3.92,{"$f":"AB4","v":15596.97680223006},{"$f":"AB5","v":482.76356768807335},{"$f":"AB6","v":14215.530285461115},{"$f":"AB7","v":16834.832103994351},{"$f":"AB8","v":3267.9379966577267},null,null,null,"Product 4",{"$f":"((LCC!$K$21*(LCC!$K$20/100))*LCC!$K$22)","v":1700},{"$f":"((LCC!$K$21*(LCC!$K$20/100))*(LCC!$K$22*(1+$E$15)))","v":1702.5486026991427},{"$f":"((LCC!$K$21*(LCC!$K$20/100))*(LCC!$K$22*(1+$F$15)))","v":1704.3241434053348},{"$f":"((LCC!$K$21*(LCC!$K$20/100))*(LCC!$K$22*(1+$G$15)))","v":1705.8095825399284},{"$f":"((LCC!$K$21*(LCC!$K$20/100))*(LCC!$K$22*(1+$H$15)))","v":1706.9075315129419},{"$f":"((LCC!$K$21*(LCC!$K$20/100))*(LCC!$K$22*(1+$I$15)))","v":1717.6217604984188},{"$f":"((LCC!$K$21*(LCC!$K$20/100))*(LCC!$K$22*(1+$J$15)))","v":1761.4806139755121},{"$f":"((LCC!$K$21*(LCC!$K$20/100))*(LCC!$K$22*(1+$K$15)))","v":1779.0153786804235},{"$f":"((LCC!$K$21*(LCC!$K$20/100))*(LCC!$K$22*(1+$L$9)))","v":1595.2516705837404},{"$f":"((LCC!$K$21*(LCC!$K$20/100))*(LCC!$K$22*(1+$M$9)))","v":1622.5807390888453},{"$f":"((LCC!$K$21*(LCC!$K$20/100))*(LCC!$K$22*(1+$N$15)))","v":1722.4736523611475},{"$f":"SUM(Q28:INDEX(Q28:AA28,LCC!$K$6))","v":16995.540022984289}]
[null,null,"% increase/decrease",null,-5.0999999999999997E-2,-1.8800000000000001E-2,6.3600000000000004E-2,null,null,null,null,null,null,null,null,"Product 5",{"$f":"((LCC!$M$21*(LCC!$M$20/100))*LCC!$M$22)","v":330},{"$f":"((LCC!$M$21*(LCC!$M$20/100))*(LCC!$M$22*(1+$E$15)))","v":330.49472875924539},{"$f":"((LCC!$M$21*(LCC!$M$20/100))*(LCC!$M$22*(1+$F$15)))","v":330.8393925433885},{"$f":"((LCC!$M$21*(LCC!$M$20/100))*(LCC!$M$22*(1+$G$15)))","v":331.12774249304493},{"$f":"((LCC!$M$21*(LCC!$M$20/100))*(LCC!$M$22*(1+$H$15)))","v":331.34087376427692},{"$f":"((LCC!$M$21*(LCC!$M$20/100))*(LCC!$M$22*(1+$I$15)))","v":333.42069468498715},{"$f":"((LCC!$M$21*(LCC!$M$20/100))*(LCC!$M$22*(1+$J$15)))","v":341.93447212465821},{"$f":"((LCC!$M$21*(LCC!$M$20/100))*(LCC!$M$22*(1+$K$15)))","v":345.33827939090571},{"$f":"((LCC!$M$21*(LCC!$M$20/100))*(LCC!$M$22*(1+$L$15)))","v":346.80515472778762},{"$f":"((LCC!$M$21*(LCC!$M$20/100))*(LCC!$M$22*(1+$M$15)))","v":346.65918957258589},{"$f":"((LCC!$M$21*(LCC!$M$20/100))*(LCC!$M$22*(1+$N$15)))","v":334.36253251716391},{"$f":"SUM(Q29:INDEX(Q29:AA29,LCC!$M$6))","v":3367.9605280608807}]
[null,"Petrol ","Forecasted price ($/gallon)",3.3809999999999998,3.02,3.03,3.26,{"$f":"AB11","v":14564.439242178718},{"$f":"AB12","v":450.80407178172226},{"$f":"AB13","v":13274.446052157176},{"$f":"AB14","v":15720.347118542109},{"$f":"AB15","v":3051.5967935993508}]
[null,null,"% increase/decrease",null,-0.1079,-0.10539999999999999,-3.2800000000000003E-2,null,null,null,null,null,null,null,null,"ELECTRICITY",2014,2015,2016,2017,2018,2019,2020,2021,2022,2023,2024,"Total fuel price for period"]
[null,"LPG ","Forecasted price ($/gallon)",2.1800000000000002,2.19,2.25,2.34,{"$f":"AB18","v":16087.158283743433},{"$f":"AB19","v":497.93585163967765},{"$f":"AB20","v":14662.295692897587},{"$f":"AB21","v":16980.023152159003},{"$f":"AB22","v":3370.642688022433},null,null,null,"Product 1",{"$f":"((LCC!$E$21*(LCC!$E$20/100))*LCC!$E$22)","v":1575},{"$f":"((LCC!$E$21*(LCC!$E$20/100))*(LCC!$E$22*(1+$E$18)))","v":1563.6013286679063},{"$f":"((LCC!$E$21*(LCC!$E$20/100))*(LCC!$E$22*(1+$F$18)))","v":1560.2698256506203},{"$f":"((LCC!$E$21*(LCC!$E$20/100))*(LCC!$E$22*(1+$G$18)))","v":1556.2013046793356},{"$f":"((LCC!$E$21*(LCC!$E$20/100))*(LCC!$E$22*(1+$H$18)))","v":1566.6376460392503},{"$f":"((LCC!$E$21*(LCC!$E$20/100))*(LCC!$E$22*(1+$I$18)))","v":1579.5326100096938},{"$f":"((LCC!$E$21*(LCC!$E$20/100))*(LCC!$E$22*(1+$J$18)))","v":1570.79210083464},{"$f":"((LCC!$E$21*(LCC!$E$20/100))*(LCC!$E$22*(1+$K$18)))","v":1564.2668392579612},{"$f":"((LCC!$E$21*(LCC!$E$20/100))*(LCC!$E$22*(1+$L$18)))","v":1551.7517268786276},{"$f":"((LCC!$E$21*(LCC!$E$20/100))*(LCC!$E$22*(1+$M$18)))","v":1547.8384241080141},{"$f":"((LCC!$E$21*(LCC!$E$20/100))*(LCC!$E$22*(1+$N$18)))","v":1567.2362677961171},{"$f":"SUM(Q32:INDEX(Q32:AA32,LCC!$E$6))","v":15635.89180612605}]
[null,null,"% increase/decrease",null,2.7000000000000001E-3,2.9899999999999999E-2,7.0099999999999996E-2,null,null,null,null,null,null,null,null,"Product 2",{"$f":"((LCC!$G$21*(LCC!$G$20/100))*LCC!$G$22)","v":48.75},{"$f":"((LCC!$G$21*(LCC!$G$20/100))*(LCC!$G$22*(1+$E$18)))","v":48.397183982578063},{"$f":"((LCC!$G$21*(LCC!$G$20/100))*(LCC!$G$22*(1+$F$18)))","v":48.294066032043013},{"$f":"((LCC!$G$21*(LCC!$G$20/100))*(LCC!$G$22*(1+$G$18)))","v":48.168135621027055},{"$f":"((LCC!$G$21*(LCC!$G$20/100))*(LCC!$G$22*(1+$H$18)))","v":48.491165234548234},{"$f":"((LCC!$G$21*(LCC!$G$20/100))*(LCC!$G$22*(1+$I$18)))","v":48.89029507172863},{"$f":"((LCC!$G$21*(LCC!$G$20/100))*(LCC!$G$22*(1+$J$18)))","v":48.619755502024574},{"$f":"((LCC!$G$21*(LCC!$G$20/100))*(LCC!$G$22*(1+$K$18)))","v":48.417783119889279},{"$f":"((LCC!$G$21*(LCC!$G$20/100))*(LCC!$G$22*(1+$L$18)))","v":48.030410593862285},{"$f":"((LCC!$G$21*(LCC!$G$20/100))*(LCC!$G$22*(1+$M$18)))","v":47.909284555724255},{"$f":"((LCC!$G$21*(LCC!$G$20/100))*(LCC!$G$22*(1+$N$18)))","v":48.509694003213156},{"$f":"SUM(Q33:INDEX(Q33:AA33,LCC!$G$6))","v":483.96807971342542}]
[null,"Ethanol","Forecasted price ($/gallon)",2.57,2.58,2.59,2.6,{"$f":"AB25","v":16074.357065745111},{"$f":"AB26","v":497.53962346353921},{"$f":"AB27","v":14650.628297064832},{"$f":"AB28","v":16995.540022984289},{"$f":"AB29","v":3367.9605280608807},null,null,null,"Product 3",{"$f":"((LCC!$I$21*(LCC!$I$20/100))*LCC!$I$22)","v":1435.5000000000002},{"$f":"((LCC!$I$21*(LCC!$I$20/100))*(LCC!$I$22*(1+$E$18)))","v":1425.1109252716064},{"$f":"((LCC!$I$21*(LCC!$I$20/100))*(LCC!$I$22*(1+$F$18)))","v":1422.0744982358515},{"$f":"((LCC!$I$21*(LCC!$I$20/100))*(LCC!$I$22*(1+$G$18)))","v":1418.366331979166},{"$f":"((LCC!$I$21*(LCC!$I$20/100))*(LCC!$I$22*(1+$H$18)))","v":1427.8783116757741},{"$f":"((LCC!$I$21*(LCC!$I$20/100))*(LCC!$I$22*(1+$I$18)))","v":1439.6311502659782},{"$f":"((LCC!$I$21*(LCC!$I$20/100))*(LCC!$I$22*(1+$J$18)))","v":1431.6648004750007},{"$f":"((LCC!$I$21*(LCC!$I$20/100))*(LCC!$I$22*(1+$K$18)))","v":1425.7174906379705},{"$f":"((LCC!$I$21*(LCC!$I$20/100))*(LCC!$I$22*(1+$L$18)))","v":1414.3108596408065},{"$f":"((LCC!$I$21*(LCC!$I$20/100))*(LCC!$I$22*(1+$M$18)))","v":1410.7441636870187},{"$f":"((LCC!$I$21*(LCC!$I$20/100))*(LCC!$I$22*(1+$N$18)))","v":1428.4239126484613},{"$f":"SUM(Q34:INDEX(Q34:AA34,LCC!$I$6))","v":14250.998531869174}]
[null,null,"% increase/decrease",null,3.3999999999999998E-3,1.04E-2,1.32E-2,null,null,null,null,null,null,null,null,"Product 4",{"$f":"((LCC!$K$21*(LCC!$K$20/100))*LCC!$K$22)","v":1700},{"$f":"((LCC!$K$21*(LCC!$K$20/100))*(LCC!$K$22*(1+$E$18)))","v":1687.6966722129785},{"$f":"((LCC!$K$21*(LCC!$K$20/100))*(LCC!$K$22*(1+$F$18)))","v":1684.1007641943206},{"$f":"((LCC!$K$21*(LCC!$K$20/100))*(LCC!$K$22*(1+$G$18)))","v":1679.7093447332511},{"$f":"((LCC!$K$21*(LCC!$K$20/100))*(LCC!$K$22*(1+$H$18)))","v":1690.9739671534767},{"$f":"((LCC!$K$21*(LCC!$K$20/100))*(LCC!$K$22*(1+$I$18)))","v":1704.8923409628442},{"$f":"((LCC!$K$21*(LCC!$K$20/100))*(LCC!$K$22*(1+$J$18)))","v":1695.458140583421},{"$f":"((LCC!$K$21*(LCC!$K$20/100))*(LCC!$K$22*(1+$K$18)))","v":1688.4150011038312},{"$f":"((LCC!$K$21*(LCC!$K$20/100))*(LCC!$K$22*(1+$L$9)))","v":1595.2516705837404},{"$f":"((LCC!$K$21*(LCC!$K$20/100))*(LCC!$K$22*(1+$M$9)))","v":1622.5807390888453},{"$f":"((LCC!$K$21*(LCC!$K$20/100))*(LCC!$K$22*(1+$N$18)))","v":1691.6200985735868},{"$f":"SUM(Q35:INDEX(Q35:AA35,LCC!$K$6))","v":16749.07864061671}]
[null,"Electricity ","Forecasted price ($cents/Kwathour)",10.210000000000001,10.1,10.199999999999999,10.16,{"$f":"AB32","v":15635.89180612605},{"$f":"AB33","v":483.96807971342542},{"$f":"AB34","v":14250.998531869174},{"$f":"AB35","v":16749.07864061671},{"$f":"AB36","v":3276.0916165216486},null,null,null,"Product 5",{"$f":"((LCC!$M$21*(LCC!$M$20/100))*LCC!$M$22)","v":330},{"$f":"((LCC!$M$21*(LCC!$M$20/100))*(LCC!$M$22*(1+$E$18)))","v":327.61170695898994},{"$f":"((LCC!$M$21*(LCC!$M$20/100))*(LCC!$M$22*(1+$F$18)))","v":326.9136777553681},{"$f":"((LCC!$M$21*(LCC!$M$20/100))*(LCC!$M$22*(1+$G$18)))","v":326.061225742337},{"$f":"((LCC!$M$21*(LCC!$M$20/100))*(LCC!$M$22*(1+$H$18)))","v":328.24788774155718},{"$f":"((LCC!$M$21*(LCC!$M$20/100))*(LCC!$M$22*(1+$I$18)))","v":330.94968971631681},{"$f":"((LCC!$M$21*(LCC!$M$20/100))*(LCC!$M$22*(1+$J$18)))","v":329.11834493678168},{"$f":"((LCC!$M$21*(LCC!$M$20/100))*(LCC!$M$22*(1+$K$18)))","v":327.75114727309665},{"$f":"((LCC!$M$21*(LCC!$M$20/100))*(LCC!$M$22*(1+$L$18)))","v":325.1289332507601},{"$f":"((LCC!$M$21*(LCC!$M$20/100))*(LCC!$M$22*(1+$M$18)))","v":324.30900314644106},{"$f":"((LCC!$M$21*(LCC!$M$20/100))*(LCC!$M$22*(1+$N$18)))","v":328.37331325251978},{"$f":"SUM(Q36:INDEX(Q36:AA36,LCC!$M$6))","v":3276.0916165216486}]
[null,null,"% increase/decrease",null,-1.1900000000000001E-2,2.8999999999999998E-3,-0.49]
[null,"Biodiesel ","Forecasted price ($/100 liters)",156.19999999999999,154.69999999999999,159.80000000000001,177.6,{"$f":"AB39","v":16254.30378880328},{"$f":"AB40","v":503.10940298676815},{"$f":"AB41","v":14814.636881794988},{"$f":"AB42","v":16984.708658861851},{"$f":"AB43","v":3405.6636509873538},null,null,null,"BIODIESEL",2014,2015,2016,2017,2018,2019,2020,2021,2022,2023,2024,"Total fuel price for period"]
[null,null,"% increase/decrease",null,-8.3000000000000001E-3,2.47E-2,0.13170000000000001,null,null,null,null,null,null,null,null,"Product 1",{"$f":"((LCC!$E$21*(LCC!$E$20/100))*LCC!$E$22)","v":1575},{"$f":"((LCC!$E$21*(LCC!$E$20/100))*(LCC!$E$22*(1+$E$21)))","v":1547.7752880921896},{"$f":"((LCC!$E$21*(LCC!$E$20/100))*(LCC!$E$22*(1+$F$21)))","v":1499.5505323918637},{"$f":"((LCC!$E$21*(LCC!$E$20/100))*(LCC!$E$22*(1+$G$21)))","v":1562.0001291660574},{"$f":"((LCC!$E$21*(LCC!$E$20/100))*(LCC!$E$22*(1+$H$21)))","v":1613.9232060891343},{"$f":"((LCC!$E$21*(LCC!$E$20/100))*(LCC!$E$22*(1+$I$21)))","v":1613.9232060891343},{"$f":"((LCC!$E$21*(LCC!$E$20/100))*(LCC!$E$22*(1+$J$21)))","v":1658.2755214833774},{"$f":"((LCC!$E$21*(LCC!$E$20/100))*(LCC!$E$22*(1+$K$21)))","v":1684.1580534371203},{"$f":"((LCC!$E$21*(LCC!$E$20/100))*(LCC!$E$22*(1+$L$21)))","v":1740.7448797844256},{"$f":"((LCC!$E$21*(LCC!$E$20/100))*(LCC!$E$22*(1+$M$21)))","v":1758.9529722699747},{"$f":"((LCC!$E$21*(LCC!$E$20/100))*(LCC!$E$22*(1+$N$21)))","v":1782.3529722699748},{"$f":"SUM(Q39:INDEX(Q39:AA39,LCC!$E$6))","v":16254.30378880328}]
[null,"Natural Gas ","Forecasted price ($/millionBtu)",16.09,16.73,17.170000000000002,18.170000000000002,{"$f":"AB46","v":16610.556255145671},{"$f":"AB47","v":514.13626504022318},{"$f":"AB48","v":15139.335558261344},{"$f":"AB49","v":17394.781145042951},{"$f":"AB50","v":3480.3070248876643},null,null,null,"Product 2",{"$f":"((LCC!$G$21*(LCC!$G$20/100))*LCC!$G$22)","v":48.75},{"$f":"((LCC!$G$21*(LCC!$G$20/100))*(LCC!$G$22*(1+$E$21)))","v":47.907330345710633},{"$f":"((LCC!$G$21*(LCC!$G$20/100))*(LCC!$G$22*(1+$F$21)))","v":46.414659335938651},{"$f":"((LCC!$G$21*(LCC!$G$20/100))*(LCC!$G$22*(1+$G$21)))","v":48.347623045616061},{"$f":"((LCC!$G$21*(LCC!$G$20/100))*(LCC!$G$22*(1+$H$21)))","v":49.954765902758922},{"$f":"((LCC!$G$21*(LCC!$G$20/100))*(LCC!$G$22*(1+$I$21)))","v":49.954765902758922},{"$f":"((LCC!$G$21*(LCC!$G$20/100))*(LCC!$G$22*(1+$J$21)))","v":51.327575664961685},{"$f":"((LCC!$G$21*(LCC!$G$20/100))*(LCC!$G$22*(1+$K$21)))","v":52.1287016540061},{"$f":"((LCC!$G$21*(LCC!$G$20/100))*(LCC!$G$22*(1+$L$21)))","v":53.880198659994136},{"$f":"((LCC!$G$21*(LCC!$G$20/100))*(LCC!$G$22*(1+$M$21)))","v":54.443782475023021},{"$f":"((LCC!$G$21*(LCC!$G$20/100))*(LCC!$G$22*(1+$N$21)))","v":55.168068189308741},{"$f":"SUM(Q40:INDEX(Q40:AA40,LCC!$G$6))","v":503.10940298676815}]
[null,null,"% increase/decrease",null,3.9399999999999998E-2,6.5600000000000006E-2,0.1225,null,null,null,null,null,null,null,null,"Product 3",{"$f":"((LCC!$I$21*(LCC!$I$20/100))*LCC!$I$22)","v":1435.5000000000002},{"$f":"((LCC!$I$21*(LCC!$I$20/100))*(LCC!$I$22*(1+$E$21)))","v":1410.6866197183101},{"$f":"((LCC!$I$21*(LCC!$I$20/100))*(LCC!$I$22*(1+$F$21)))","v":1366.7331995228703},{"$f":"((LCC!$I$21*(LCC!$I$20/100))*(LCC!$I$22*(1+$G$21)))","v":1423.6515462970638},{"$f":"((LCC!$I$21*(LCC!$I$20/100))*(LCC!$I$22*(1+$H$21)))","v":1470.9757221212399},{"$f":"((LCC!$I$21*(LCC!$I$20/100))*(LCC!$I$22*(1+$I$21)))","v":1470.9757221212399},{"$f":"((LCC!$I$21*(LCC!$I$20/100))*(LCC!$I$22*(1+$J$21)))","v":1511.399689580564},{"$f":"((LCC!$I$21*(LCC!$I$20/100))*(LCC!$I$22*(1+$K$21)))","v":1534.9897687041184},{"$f":"((LCC!$I$21*(LCC!$I$20/100))*(LCC!$I$22*(1+$L$21)))","v":1586.5646190035195},{"$f":"((LCC!$I$21*(LCC!$I$20/100))*(LCC!$I$22*(1+$M$21)))","v":1603.1599947260627},{"$f":"((LCC!$I$21*(LCC!$I$20/100))*(LCC!$I$22*(1+$N$21)))","v":1624.4874232974914},{"$f":"SUM(Q41:INDEX(Q41:AA41,LCC!$I$6))","v":14814.636881794988}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Product 4",{"$f":"((LCC!$K$21*(LCC!$K$20/100))*LCC!$K$22)","v":1700},{"$f":"((LCC!$K$21*(LCC!$K$20/100))*(LCC!$K$22*(1+$E$21)))","v":1670.6145966709348},{"$f":"((LCC!$K$21*(LCC!$K$20/100))*(LCC!$K$22*(1+$F$21)))","v":1618.5624794070911},{"$f":"((LCC!$K$21*(LCC!$K$20/100))*(LCC!$K$22*(1+$G$21)))","v":1685.9683933855858},{"$f":"((LCC!$K$21*(LCC!$K$20/100))*(LCC!$K$22*(1+$H$21)))","v":1742.0123494295419},{"$f":"((LCC!$K$21*(LCC!$K$20/100))*(LCC!$K$22*(1+$I$21)))","v":1742.0123494295419},{"$f":"((LCC!$K$21*(LCC!$K$20/100))*(LCC!$K$22*(1+$J$21)))","v":1789.8846898550739},{"$f":"((LCC!$K$21*(LCC!$K$20/100))*(LCC!$K$22*(1+$K$21)))","v":1817.8213910114948},{"$f":"((LCC!$K$21*(LCC!$K$20/100))*(LCC!$K$22*(1+$L$9)))","v":1595.2516705837404},{"$f":"((LCC!$K$21*(LCC!$K$20/100))*(LCC!$K$22*(1+$M$9)))","v":1622.5807390888453},{"$f":"((LCC!$K$21*(LCC!$K$20/100))*(LCC!$K$22*(1+$N$21)))","v":1923.8095573707662},{"$f":"SUM(Q42:INDEX(Q42:AA42,LCC!$K$6))","v":16984.708658861851}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Product 5",{"$f":"((LCC!$M$21*(LCC!$M$20/100))*LCC!$M$22)","v":330},{"$f":"((LCC!$M$21*(LCC!$M$20/100))*(LCC!$M$22*(1+$E$21)))","v":324.2957746478873},{"$f":"((LCC!$M$21*(LCC!$M$20/100))*(LCC!$M$22*(1+$F$21)))","v":314.1915401202001},{"$f":"((LCC!$M$21*(LCC!$M$20/100))*(LCC!$M$22*(1+$G$21)))","v":327.27621753955486},{"$f":"((LCC!$M$21*(LCC!$M$20/100))*(LCC!$M$22*(1+$H$21)))","v":338.15533841867574},{"$f":"((LCC!$M$21*(LCC!$M$20/100))*(LCC!$M$22*(1+$I$21)))","v":338.15533841867574},{"$f":"((LCC!$M$21*(LCC!$M$20/100))*(LCC!$M$22*(1+$J$21)))","v":347.44820450127906},{"$f":"((LCC!$M$21*(LCC!$M$20/100))*(LCC!$M$22*(1+$K$21)))","v":352.87121119634895},{"$f":"((LCC!$M$21*(LCC!$M$20/100))*(LCC!$M$22*(1+$L$21)))","v":364.72749862149874},{"$f":"((LCC!$M$21*(LCC!$M$20/100))*(LCC!$M$22*(1+$M$21)))","v":368.54252752323276},{"$f":"((LCC!$M$21*(LCC!$M$20/100))*(LCC!$M$22*(1+$N$21)))","v":373.44538466608998},{"$f":"SUM(Q43:INDEX(Q43:AA43,LCC!$M$6))","v":3405.6636509873538}]
["Sources: ","OECD-FAO Agricultural outlook"]
[null,"US-Energy Administration",null,null,null,null,null,null,null,null,null,null,null,null,null,"NATURAL GAS",2014,2015,2016,2017,2018,2019,2020,2021,2022,2023,2024,"Total fuel price for period"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Product 1",{"$f":"((LCC!$E$21*(LCC!$E$20/100))*LCC!$E$22)","v":1575},{"$f":"((LCC!$E$21*(LCC!$E$20/100))*(LCC!$E$22*(1+$E$24)))","v":1575.9788688626475},{"$f":"((LCC!$E$21*(LCC!$E$20/100))*(LCC!$E$22*(1+$F$24)))","v":1617.0658253843865},{"$f":"((LCC!$E$21*(LCC!$E$20/100))*(LCC!$E$22*(1+$G$24)))","v":1637.0870118250648},{"$f":"((LCC!$E$21*(LCC!$E$20/100))*(LCC!$E$22*(1+$H$24)))","v":1664.3882670551902},{"$f":"((LCC!$E$21*(LCC!$E$20/100))*(LCC!$E$22*(1+$I$24)))","v":1678.268995609832},{"$f":"((LCC!$E$21*(LCC!$E$20/100))*(LCC!$E$22*(1+$J$24)))","v":1686.5246741188591},{"$f":"((LCC!$E$21*(LCC!$E$20/100))*(LCC!$E$22*(1+$K$24)))","v":1700.2123913842124},{"$f":"((LCC!$E$21*(LCC!$E$20/100))*(LCC!$E$22*(1+$L$24)))","v":1726.4473138425699},{"$f":"((LCC!$E$21*(LCC!$E$20/100))*(LCC!$E$22*(1+$M$24)))","v":1749.5829070629088},{"$f":"((LCC!$E$21*(LCC!$E$20/100))*(LCC!$E$22*(1+$N$24)))","v":1767.9988313390782},{"$f":"SUM(Q46:INDEX(Q46:AA46,LCC!$E$6))","v":16610.556255145671}]
["*** All price forecasts were taken for the transportation sector",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Product 2",{"$f":"((LCC!$G$21*(LCC!$G$20/100))*LCC!$G$22)","v":48.75},{"$f":"((LCC!$G$21*(LCC!$G$20/100))*(LCC!$G$22*(1+$E$24)))","v":48.7802983219391},{"$f":"((LCC!$G$21*(LCC!$G$20/100))*(LCC!$G$22*(1+$F$24)))","v":50.052037452373874},{"$f":"((LCC!$G$21*(LCC!$G$20/100))*(LCC!$G$22*(1+$G$24)))","v":50.671740842204393},{"$f":"((LCC!$G$21*(LCC!$G$20/100))*(LCC!$G$22*(1+$H$24)))","v":51.516779694565422},{"$f":"((LCC!$G$21*(LCC!$G$20/100))*(LCC!$G$22*(1+$I$24)))","v":51.946421292685272},{"$f":"((LCC!$G$21*(LCC!$G$20/100))*(LCC!$G$22*(1+$J$24)))","v":52.201954198917072},{"$f":"((LCC!$G$21*(LCC!$G$20/100))*(LCC!$G$22*(1+$K$24)))","v":52.625621638082769},{"$f":"((LCC!$G$21*(LCC!$G$20/100))*(LCC!$G$22*(1+$L$24)))","v":53.437654952270023},{"$f":"((LCC!$G$21*(LCC!$G$20/100))*(LCC!$G$22*(1+$M$24)))","v":54.153756647185283},{"$f":"((LCC!$G$21*(LCC!$G$20/100))*(LCC!$G$22*(1+$N$24)))","v":54.72377335097147},{"$f":"SUM(Q47:INDEX(Q47:AA47,LCC!$G$6))","v":514.13626504022318}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Product 3",{"$f":"((LCC!$I$21*(LCC!$I$20/100))*LCC!$I$22)","v":1435.5000000000002},{"$f":"((LCC!$I$21*(LCC!$I$20/100))*(LCC!$I$22*(1+$E$24)))","v":1436.3921690490993},{"$f":"((LCC!$I$21*(LCC!$I$20/100))*(LCC!$I$22*(1+$F$24)))","v":1473.8399951360554},{"$f":"((LCC!$I$21*(LCC!$I$20/100))*(LCC!$I$22*(1+$G$24)))","v":1492.0878764919878},{"$f":"((LCC!$I$21*(LCC!$I$20/100))*(LCC!$I$22*(1+$H$24)))","v":1516.9710205445876},{"$f":"((LCC!$I$21*(LCC!$I$20/100))*(LCC!$I$22*(1+$I$24)))","v":1529.6223131415327},{"$f":"((LCC!$I$21*(LCC!$I$20/100))*(LCC!$I$22*(1+$J$24)))","v":1537.146774411189},{"$f":"((LCC!$I$21*(LCC!$I$20/100))*(LCC!$I$22*(1+$K$24)))","v":1549.6221510044679},{"$f":"((LCC!$I$21*(LCC!$I$20/100))*(LCC!$I$22*(1+$L$24)))","v":1573.5334089022283},{"$f":"((LCC!$I$21*(LCC!$I$20/100))*(LCC!$I$22*(1+$M$24)))","v":1594.6198495801943},{"$f":"((LCC!$I$21*(LCC!$I$20/100))*(LCC!$I$22*(1+$N$24)))","v":1611.4046491347601},{"$f":"SUM(Q48:INDEX(Q48:AA48,LCC!$I$6))","v":15139.335558261344}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Product 4",{"$f":"((LCC!$K$21*(LCC!$K$20/100))*LCC!$K$22)","v":1700},{"$f":"((LCC!$K$21*(LCC!$K$20/100))*(LCC!$K$22*(1+$E$24)))","v":1701.0565568676197},{"$f":"((LCC!$K$21*(LCC!$K$20/100))*(LCC!$K$22*(1+$F$24)))","v":1745.404382954576},{"$f":"((LCC!$K$21*(LCC!$K$20/100))*(LCC!$K$22*(1+$G$24)))","v":1767.0145524461018},{"$f":"((LCC!$K$21*(LCC!$K$20/100))*(LCC!$K$22*(1+$H$24)))","v":1796.4825739643325},{"$f":"((LCC!$K$21*(LCC!$K$20/100))*(LCC!$K$22*(1+$I$24)))","v":1811.4649476423583},{"$f":"((LCC!$K$21*(LCC!$K$20/100))*(LCC!$K$22*(1+$J$24)))","v":1820.375838731467},{"$f":"((LCC!$K$21*(LCC!$K$20/100))*(LCC!$K$22*(1+$K$24)))","v":1835.1498827639118},{"$f":"((LCC!$K$21*(LCC!$K$20/100))*(LCC!$K$22*(1+$L$9)))","v":1595.2516705837404},{"$f":"((LCC!$K$21*(LCC!$K$20/100))*(LCC!$K$22*(1+$M$9)))","v":1622.5807390888453},{"$f":"((LCC!$K$21*(LCC!$K$20/100))*(LCC!$K$22*(1+$N$24)))","v":1908.3161989056719},{"$f":"SUM(Q49:INDEX(Q49:AA49,LCC!$K$6))","v":17394.781145042951}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Product 5",{"$f":"((LCC!$M$21*(LCC!$M$20/100))*LCC!$M$22)","v":330},{"$f":"((LCC!$M$21*(LCC!$M$20/100))*(LCC!$M$22*(1+$E$24)))","v":330.20509633312616},{"$f":"((LCC!$M$21*(LCC!$M$20/100))*(LCC!$M$22*(1+$F$24)))","v":338.81379198530004},{"$f":"((LCC!$M$21*(LCC!$M$20/100))*(LCC!$M$22*(1+$G$24)))","v":343.00870723953744},{"$f":"((LCC!$M$21*(LCC!$M$20/100))*(LCC!$M$22*(1+$H$24)))","v":348.72897024013514},{"$f":"((LCC!$M$21*(LCC!$M$20/100))*(LCC!$M$22*(1+$I$24)))","v":351.63731336586955},{"$f":"((LCC!$M$21*(LCC!$M$20/100))*(LCC!$M$22*(1+$J$24)))","v":353.36707457728477},{"$f":"((LCC!$M$21*(LCC!$M$20/100))*(LCC!$M$22*(1+$K$24)))","v":356.23497724240644},{"$f":"((LCC!$M$21*(LCC!$M$20/100))*(LCC!$M$22*(1+$L$24)))","v":361.7318181384432},{"$f":"((LCC!$M$21*(LCC!$M$20/100))*(LCC!$M$22*(1+$M$24)))","v":366.57927576556193},{"$f":"((LCC!$M$21*(LCC!$M$20/100))*(LCC!$M$22*(1+$N$24)))","v":370.43785037580687},{"$f":"SUM(Q50:INDEX(Q50:AA50,LCC!$M$6))","v":3480.3070248876643}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BATTERY",2014,2015,2016,2017,2018,2019,2020,2021,2022,2023,2024,"Cost of replacements for period"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Product 1",0,{"$f":"IF(LCC!$E$24=1,LCC!$E$23,0)","v":0},{"$f":"IF(OR(LCC!$E$24=1,$E$24=2),LCC!$E$23,0)","v":0},{"$f":"IF(OR(LCC!$E$24=1,LCC!$E$24=3),LCC!$E$23,0)","v":0},{"$f":"IF(OR(LCC!$E$24=1,LCC!$E$24=2,LCC!$E$24=4),LCC!$E$23,0)","v":0},{"$f":"IF(OR(LCC!$E$24=1,LCC!$E$24=5),LCC!$E$23,0)","v":0},{"$f":"IF(OR(LCC!$E$24=1,LCC!$E$24=2,LCC!$E$24=3,LCC!$E$24=6),LCC!$E$23,0)","v":0},{"$f":"IF(OR(LCC!$E$24=1,LCC!$E$24=7),LCC!$E$23,0)","v":0},{"$f":"IF(OR(LCC!$E$24=1,LCC!$E$24=2,LCC!$E$24=4,LCC!$E$24=8),LCC!$E$23,0)","v":0},{"$f":"IF(OR(LCC!$E$24=1,LCC!$E$24=3,LCC!$E$24=9),LCC!$E$23,0)","v":0},{"$f":"IF(OR(LCC!$E$24=1,LCC!$E$24=2,LCC!$E$24=5,LCC!$E$24=10),LCC!$E$23,0)","v":0},{"$f":"SUM(Q53:INDEX(Q53:AA53,LCC!$E$6))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Product 2",0,{"$f":"IF(LCC!$G$24=1,LCC!$G$23,0)","v":0},{"$f":"IF(OR(LCC!$G$24=1,$G$24=2),LCC!$G$23,0)","v":0},{"$f":"IF(OR(LCC!$G$24=1,LCC!$G$24=3),LCC!$G$23,0)","v":0},{"$f":"IF(OR(LCC!$G$24=1,LCC!$G$24=2,LCC!$G$24=4),LCC!$G$23,0)","v":0},{"$f":"IF(OR(LCC!$G$24=1,LCC!$G$24=5),LCC!$G$23,0)","v":3000},{"$f":"IF(OR(LCC!$G$24=1,LCC!$G$24=2,LCC!$G$24=3,LCC!$G$24=6),LCC!$G$23,0)","v":0},{"$f":"IF(OR(LCC!$G$24=1,LCC!$G$24=7),LCC!$G$23,0)","v":0},{"$f":"IF(OR(LCC!$G$24=1,LCC!$G$24=2,LCC!$G$24=4,LCC!$G$24=8),LCC!$G$23,0)","v":0},{"$f":"IF(OR(LCC!$G$24=1,LCC!$G$24=3,LCC!$G$24=9),LCC!$G$23,0)","v":0},{"$f":"IF(OR(LCC!$G$24=1,LCC!$G$24=2,LCC!$G$24=5,LCC!$G$24=10),LCC!$G$23,0)","v":3000},{"$f":"SUM(Q54:INDEX(Q54:AA54,LCC!$E$6))","v":3000}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Product 3",0,{"$f":"IF(LCC!$I$24=1,LCC!$I$23,0)","v":0},{"$f":"IF(OR(LCC!$I$24=1,$I$24=2),LCC!$I$23,0)","v":0},{"$f":"IF(OR(LCC!$I$24=1,LCC!$I$24=3),LCC!$I$23,0)","v":0},{"$f":"IF(OR(LCC!$I$24=1,LCC!$I$24=2,LCC!$I$24=4),LCC!$I$23,0)","v":0},{"$f":"IF(OR(LCC!$I$24=1,LCC!$I$24=5),LCC!$I$23,0)","v":0},{"$f":"IF(OR(LCC!$I$24=1,LCC!$I$24=2,LCC!$I$24=3,LCC!$I$24=6),LCC!$I$23,0)","v":0},{"$f":"IF(OR(LCC!$I$24=1,LCC!$I$24=7),LCC!$I$23,0)","v":0},{"$f":"IF(OR(LCC!$I$24=1,LCC!$I$24=2,LCC!$I$24=4,LCC!$I$24=8),LCC!$I$23,0)","v":0},{"$f":"IF(OR(LCC!$I$24=1,LCC!$I$24=3,LCC!$I$24=9),LCC!$I$23,0)","v":0},{"$f":"IF(OR(LCC!$I$24=1,LCC!$I$24=2,LCC!$I$24=5,LCC!$I$24=10),LCC!$I$23,0)","v":0},{"$f":"SUM(Q55:INDEX(Q55:AA55,LCC!$E$6))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Product 4",0,{"$f":"IF(LCC!$K$24=1,LCC!$K$23,0)","v":0},{"$f":"IF(OR(LCC!$K$24=1,$K$24=2),LCC!$K$23,0)","v":0},{"$f":"IF(OR(LCC!$K$24=1,LCC!$K$24=3),LCC!$K$23,0)","v":0},{"$f":"IF(OR(LCC!$K$24=1,LCC!$K$24=2,LCC!$K$24=4),LCC!$K$23,0)","v":0},{"$f":"IF(OR(LCC!$K$24=1,LCC!$K$24=5),LCC!$K$23,0)","v":0},{"$f":"IF(OR(LCC!$K$24=1,LCC!$K$24=2,LCC!$K$24=3,LCC!$K$24=6),LCC!$K$23,0)","v":0},{"$f":"IF(OR(LCC!$K$24=1,LCC!$K$24=7),LCC!$K$23,0)","v":0},{"$f":"IF(OR(LCC!$K$24=1,LCC!$K$24=2,LCC!$K$24=4,LCC!$K$24=8),LCC!$K$23,0)","v":0},{"$f":"IF(OR(LCC!$K$24=1,LCC!$K$24=3,LCC!$K$24=9),LCC!$K$23,0)","v":0},{"$f":"IF(OR(LCC!$K$24=1,LCC!$K$24=2,LCC!$K$24=5,LCC!$K$24=10),LCC!$K$23,0)","v":0},{"$f":"SUM(Q56:INDEX(Q56:AA56,LCC!$E$6))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Product 5",0,{"$f":"IF(LCC!$M$24=1,LCC!$M$23,0)","v":0},{"$f":"IF(OR(LCC!$M$24=1,$M$24=2),LCC!$M$23,0)","v":0},{"$f":"IF(OR(LCC!$M$24=1,LCC!$M$24=3),LCC!$M$23,0)","v":0},{"$f":"IF(OR(LCC!$M$24=1,LCC!$M$24=2,LCC!$M$24=4),LCC!$M$23,0)","v":0},{"$f":"IF(OR(LCC!$M$24=1,LCC!$M$24=5),LCC!$M$23,0)","v":0},{"$f":"IF(OR(LCC!$M$24=1,LCC!$M$24=2,LCC!$M$24=3,LCC!$M$24=6),LCC!$M$23,0)","v":0},{"$f":"IF(OR(LCC!$M$24=1,LCC!$M$24=7),LCC!$M$23,0)","v":0},{"$f":"IF(OR(LCC!$M$24=1,LCC!$M$24=2,LCC!$M$24=4,LCC!$M$24=8),LCC!$M$23,0)","v":0},{"$f":"IF(OR(LCC!$M$24=1,LCC!$M$24=3,LCC!$M$24=9),LCC!$M$23,0)","v":0},{"$f":"IF(OR(LCC!$M$24=1,LCC!$M$24=2,LCC!$M$24=5,LCC!$M$24=10),LCC!$M$23,0)","v":0},{"$f":"SUM(Q57:INDEX(Q57:AA57,LCC!$E$6))","v":0}]

{"sheet":"Calculations","index":4,"n_rows":35,"n_cols":11,"rows_kept":35,"cut":false,"hidden":true,"merged":[]}
["FOR CALCULATIONS ONLY - DO NOT AMEND!"]
[]
[null,null,null,"Product 1","Product 2","Product 3","Product 4","Product 5"]
[null,null,"Type of Fuel",{"$f":"MATCH(LCC!E19,$B$20:$B$30,0)","v":1},{"$f":"MATCH(LCC!G19,$B$20:$B$30,0)","v":4},{"$f":"MATCH(LCC!I19,$B$20:$B$30,0)","v":6},{"$f":"MATCH(LCC!K19,$B$20:$B$30,0)","v":{"$error":"#N/A"}},{"$f":"MATCH(LCC!M19,$B$20:$B$30,0)","v":{"$error":"#N/A"}}]
[null,null,"Reference Fuel (1 = diesel, 2 = petrol)",1]
[null,null,"Fuel payment per period",{"$f":"(INDEX(G20:G30,D4))/LCC!E6","v":1559.697680223006},{"$f":"(INDEX(H20:H30,E4))/LCC!G6","v":48.39680797134254},{"$f":"(INDEX(I20:I30,F4))/LCC!I6","v":1466.2295692897587},{"$f":"(INDEX(J20:J30,G4))/LCC!K6","v":{"$error":"#N/A"}},{"$f":"(INDEX(K20:K30,H4))/LCC!M6","v":{"$error":"#N/A"}}]
[null,null,"Average annual battery price",{"$f":"'Fuel Prices'!AB53/LCC!E6","v":0},{"$f":"'Fuel Prices'!AB54/LCC!E6","v":300},{"$f":"'Fuel Prices'!AB55/LCC!E6","v":0},{"$f":"'Fuel Prices'!AB56/LCC!E6","v":0},{"$f":"'Fuel Prices'!AB57/LCC!E6","v":0}]
[null,null,"Fuel price per litre using own values",{"$f":"IF(INDEX(LCC!$C$77:$D$87,Calculations!D4,2)>0,LCC!E22-CUMIPMT(INDEX(LCC!$C$77:$D$87,Calculations!D4,2),LCC!$E$6,LCC!E22,1,LCC!$E$6,1),LCC!E22*(1+(INDEX(LCC!$C$77:$D$87,Calculations!E4,2))^LCC!$E$6))","v":1.528011166778853},{"$f":"IF(INDEX(LCC!$C$77:$D$87,Calculations!E4,2)>0,LCC!G22-CUMIPMT(INDEX(LCC!$C$77:$D$87,Calculations!E4,2),LCC!$E$6,LCC!G22,1,LCC!$E$6,1),LCC!G22*(1+(INDEX(LCC!$C$77:$D$87,Calculations!E4,2))^LCC!$E$6))","v":0.1358977222935869},{"$f":"IF(INDEX(LCC!$C$77:$D$87,Calculations!F4,2)>0,LCC!I22-CUMIPMT(INDEX(LCC!$C$77:$D$87,Calculations!F4,2),LCC!$E$6,LCC!I22,1,LCC!$E$6,1),LCC!I22*(1+(INDEX(LCC!$C$77:$D$87,Calculations!F4,2))^LCC!$E$6))","v":1.3567145948762132},{"$f":"IF(INDEX(LCC!$C$77:$D$87,Calculations!G4,2)>0,LCC!K22-CUMIPMT(INDEX(LCC!$C$77:$D$87,Calculations!G4,2),LCC!$E$6,LCC!K22,1,LCC!$E$6,1),LCC!K22*(1+(INDEX(LCC!$C$77:$D$87,Calculations!G4,2))^LCC!$E$6))","v":{"$error":"#N/A"}},{"$f":"IF(INDEX(LCC!$C$77:$D$87,Calculations!H4,2)>0,LCC!M22-CUMIPMT(INDEX(LCC!$C$77:$D$87,Calculations!H4,2),LCC!$E$6,LCC!M22,1,LCC!$E$6,1),LCC!M22*(1+(INDEX(LCC!$C$77:$D$87,Calculations!H4,2))^LCC!$E$6))","v":{"$error":"#N/A"}}]
[null,null,"Fuel consumption per vehicle",{"$f":"LCC!E$20","v":7.5},{"$f":"LCC!G$20","v":2.5},{"$f":"LCC!I$20","v":8.6999999999999993},{"$f":"LCC!K$20","v":10},{"$f":"LCC!M$20","v":11}]
[null,null,"Energy Content",{"$f":"INDEX($C$20:$C$30,D$4)","v":36},{"$f":"INDEX($C$20:$C$30,E$4)","v":3.6},{"$f":"INDEX($C$20:$C$30,F$4)","v":24},{"$f":"INDEX($C$20:$C$30,G$4)","v":{"$error":"#N/A"}},{"$f":"INDEX($C$20:$C$30,H$4)","v":{"$error":"#N/A"}}]
[null,null,"Energy Consumption (MJ/km)",{"$f":"(D9/100)*D10","v":2.6999999999999997},{"$f":"(E9/100)*E10","v":9.0000000000000011E-2},{"$f":"(F9/100)*F10","v":2.0880000000000001},{"$f":"(G9/100)*G10","v":{"$error":"#N/A"}},{"$f":"(H9/100)*H10","v":{"$error":"#N/A"}}]
[null,null,"Cost for reference fuel per litre (€/l)",{"$f":"LCC!E$53","v":0.8},{"$f":"LCC!G$53","v":0.8},{"$f":"LCC!I$53","v":0.8},{"$f":"LCC!K$53","v":1.2},{"$f":"LCC!M$53","v":1.2}]
[null,null,"Energy content of reference fuel",{"$f":"IF($D$5=1,$C$20, IF($D$5=2,$C$21, \"INCORRECT\"))","v":36},{"$f":"IF($D$5=1,$C$20, IF($D$5=2,$C$21, \"INCORRECT\"))","v":36},{"$f":"IF($D$5=1,$C$20, IF($D$5=2,$C$21, \"INCORRECT\"))","v":36},{"$f":"IF($D$5=1,$C$20, IF($D$5=2,$C$21, \"INCORRECT\"))","v":36},{"$f":"IF($D$5=1,$C$20, IF($D$5=2,$C$21, \"INCORRECT\"))","v":36}]
[null,null,"Cost per unit of energy (€/MJ)",{"$f":"D12/D13","v":2.2222222222222223E-2},{"$f":"E12/E13","v":2.2222222222222223E-2},{"$f":"F12/F13","v":2.2222222222222223E-2},{"$f":"G12/G13","v":3.3333333333333333E-2},{"$f":"H12/H13","v":3.3333333333333333E-2}]
[null,null,"Lifetime mileage (km)",{"$f":"LCC!E21*LCC!E$6","v":150000},{"$f":"LCC!G21*LCC!$E$6","v":150000},{"$f":"LCC!I21*LCC!$E$6","v":150000},{"$f":"LCC!K21*LCC!$E$6","v":200000},{"$f":"LCC!M21*LCC!$E$6","v":200000}]
[null,null,"Lifetime cost of energy consumption (€)",{"$f":"D11*D14*D15","v":9000},{"$f":"E11*E14*E15","v":300.00000000000006},{"$f":"F11*F14*F15","v":6960.0000000000009},{"$f":"G11*G14*G15","v":{"$error":"#N/A"}},{"$f":"H11*H14*H15","v":{"$error":"#N/A"}}]
[]
[null,null,null,null,null,null,"Total Fuel costs for specified period"]
[null,"Fuel Type","Energy Content","Unit Energy Content","Unit fuel consumption","Unit fuel Cost","Product 1","Product 2","Product 3","Product 4","Product 5"]
[null,"Diesel",36,"MJ/l","l/100km","€/l",{"$f":"'Fuel Prices'!$H$28","v":15596.97680223006},{"$f":"'Fuel Prices'!$I$28","v":482.76356768807335},{"$f":"'Fuel Prices'!$J$28","v":14215.530285461115},{"$f":"'Fuel Prices'!$K$28","v":16834.832103994351},{"$f":"'Fuel Prices'!$L$28","v":3267.9379966577267}]
[null,"Petrol",32,"MJ/l","l/100km","€/l",{"$f":"'Fuel Prices'!$H$30","v":14564.439242178718},{"$f":"'Fuel Prices'!$I$30","v":450.80407178172226},{"$f":"'Fuel Prices'!$J$30","v":13274.446052157176},{"$f":"'Fuel Prices'!$K$30","v":15720.347118542109},{"$f":"'Fuel Prices'!$L$30","v":3051.5967935993508}]
[null,"Natural Gas/Biogas",35,"MJ/Nm3","Nm3/100km","€/Nm3",{"$f":"'Fuel Prices'!$H$40","v":16610.556255145671},{"$f":"'Fuel Prices'!$I$40","v":514.13626504022318},{"$f":"'Fuel Prices'!$J$40","v":15139.335558261344},{"$f":"'Fuel Prices'!$K$40","v":17394.781145042951},{"$f":"'Fuel Prices'!$L$40","v":3480.3070248876643}]
[null,"Electricity",3.6,"MJ/kWh","kWh/100km","€/kWh",{"$f":"'Fuel Prices'!$H$36","v":15635.89180612605},{"$f":"'Fuel Prices'!$I$36","v":483.96807971342542},{"$f":"'Fuel Prices'!$J$36","v":14250.998531869174},{"$f":"'Fuel Prices'!$K$36","v":16749.07864061671},{"$f":"'Fuel Prices'!$L$36","v":3276.0916165216486}]
[null,"Biodiesel",33,"MJ/l","l/100km","€/l",{"$f":"'Fuel Prices'!$H$38","v":16254.30378880328},{"$f":"'Fuel Prices'!$I$38","v":503.10940298676815},{"$f":"'Fuel Prices'!$J$38","v":14814.636881794988},{"$f":"'Fuel Prices'!$K$38","v":16984.708658861851},{"$f":"'Fuel Prices'!$L$38","v":3405.6636509873538}]
[null,"LPG",24,"MJ/l","l/100km","€/l",{"$f":"'Fuel Prices'!$H$32","v":16087.158283743433},{"$f":"'Fuel Prices'!$I$32","v":497.93585163967765},{"$f":"'Fuel Prices'!$J$32","v":14662.295692897587},{"$f":"'Fuel Prices'!$K$32","v":16980.023152159003},{"$f":"'Fuel Prices'!$L$32","v":3370.642688022433}]
[null,"Ethanol",21,"MJ/l","l/100km","€/l",{"$f":"'Fuel Prices'!$H$34","v":16074.357065745111},{"$f":"'Fuel Prices'!$I$34","v":497.53962346353921},{"$f":"'Fuel Prices'!$J$34","v":14650.628297064832},{"$f":"'Fuel Prices'!$K$34","v":16995.540022984289},{"$f":"'Fuel Prices'!$L$34","v":3367.9605280608807}]
[null,"Hydrogen (gas)",11,"MJ/Nm3","Nm3/100km","€/Nm3"]
[null,"Hydrogen (liquid - l/100km)",8.6,"MJ/l","l/100km","€/l"]
[null,"Hydrogen (liquid - kg/100km)",120,"MJ/kg","kg/100km","€/kg"]
[null,"Emulsion Fuel",32,"MJ/l","l/100km","€/l"]
[]
[null,"Drop down lists"]
[null,"Contract type","Reference fuel","Fuel price increases"]
[null,"Purchase","Diesel","Choose own values"]
[null,"Lease","Petrol","Use default OECD-FAO values"]

{"sheet":"Bugs","index":5,"n_rows":2,"n_cols":2,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Please list any bugs you find below"]