{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["UserManual","Model1Inputs","Model2Inputs","Results","Results_2","PriceVolatility","PriceVolatility_2","GraphPrep","GraphPrep_2","Lists"],"not_rendered":{"charts":4,"images":0,"macros":1,"external_links":0,"defined_names":54,"comments":0,"pivot_tables":2},"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":"UserManual","index":0,"n_rows":19,"n_cols":19,"rows_kept":19,"cut":false,"hidden":false,"merged":[[4,2,4,5],[17,4,17,14],[18,4,18,14],[6,2,7,14],[10,4,10,14],[11,4,11,14],[14,4,14,14],[15,4,15,14],[16,4,16,14],[13,4,13,14],[12,4,12,14]]}
[]
[]
[]
[]
[null,null,"User Manual"]
[]
[null,null,"This tool has been designed to quantify the cost-benefits of installing a shoreside connection point for you vessel(s). It works on basic assumptions which are the default international standards (EMEP/EEA Guidebook, 2016). Before this tool can be used there are a number of user inputs that need to be defined which are essential to the calculations. These are defined below;"]
[]
[]
[]
[null,null,null,"Fuel type consumed:","The fuel which your vessel burns whilst idling at its jetty. Choices are restricted to marine diesel oil, marine gas oil, and low-sulphur heavy fuel oil. These restrictions are in place because the default international standards do not allow for more specific calculations.",null,null,null,null,null,null,null,null,null,null,"<please select>"]
[null,null,null,"Time spent idling at jetty:","The amount of time per day that each vessel is idling at the jetty where the shoreside power connection(s) are to be installed that could practically be replaced by power consumption from the electricity grid instead. Note, this should not include time spent idling which is necessary for the practical operation of your vessel(s). We assume that vessels are not operating for three weeks of the year.",null,null,null,null,null,null,null,null,null,null,null,"hrs",null,"mins"]
[null,null,null,"Days of the week operational","The amount of days each week in which the vessel(s) operate. For example, if your vessels only operate Monday - Friday, then this is five days."]
[null,null,null,"Number of vessels","The number of vessels you would connect to the shoreside power connection at any one time. This can be an average so does not need to be a whole number. If for example, you have 3 vessels, and some of the time 2 are plugged, whilst at other points, only 1 is plugged in, then you can put 1.5."]
[null,null,null,"Maximum engine power (kW):","The maximum continuous power rating of your vessel engine(s) that would typically be operational whilst at berth. If you have more than one engine which are switched on during idling then this is the sum of all of them, not the average. This is per vessel",null,null,null,null,null,null,null,null,null,null,null,"kW"]
[null,null,null,"Engine type:","The type of engine(s) which is most relevant to the engine(s) used whilst at berth. As with fuel type, this is restricted to those in the drop-down list due to limitations on the data availability.",null,null,null,null,null,null,null,null,null,null,"<please select>"]
[null,null,null,"Loading factor:","The proportion of your maximum continuous power rating that is accessed whilst at berth. If known, enter a value between 0-100%. Otherwise a default value of 20% is used.",null,null,null,null,null,null,null,null,null,null,"Use model defaults",null,0.8]
[null,null,null,"Specific Fuel Consumption Rate:","The amount of fuel consumed per unit energy of the engine output (not the fuel) in g/kWh. As with loading factor, the user can manually enter this if known, otherwise default values coded into the model are used which are dependent upon the fuel type and engine type selected.",null,null,null,null,null,null,null,null,null,null,"Use model defaults",null,275]
[null,null,null,"Fuel price:","This is simply the amount that you pay for your fuel at the moment. The model can interpret prices in £ per litre, tonne, or kg. Coded within the model is a projection of how fuel price is expected to vary over the coming years, scaled from BEIS UEP projections (BEIS, 2018). As a result, payback period is calculated under various scenarios (with planned actions, low fuel-cost futures, or high fuel-cost futures).",null,null,null,null,null,null,null,null,null,null,null,"per","tonne"]

{"sheet":"Model1Inputs","index":1,"n_rows":2,"n_cols":3,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
["Installation Cost (total) - £","Maintenance costs annually - £","Electricity cost - £/kWh"]
[125000,10000,0.08]

{"sheet":"Model2Inputs","index":2,"n_rows":2,"n_cols":3,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
["Payback period (yrs)","Electricity costs ","Maintenance%"]
[4,0.1,0.02]

{"sheet":"Results","index":3,"n_rows":48,"n_cols":14,"rows_kept":48,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[]
[null,null,"Fuel consumed idling per year:",null,null,{"$f":"(n_HrsPerDay + n_Minsperday/60)*n_Enginepower*n_VesselNumbers*\n               IF(n_LoadChoice=\"Enter manually\",n_LoadManual,0.2)\n              *IF(n_SFCChoice=\"Enter manually\",n_SFCManual,INDEX(a_SFC,MATCH(n_Enginetype,a_EngineType,0),MATCH(n_Fuel,Lists!$G$3:$J$3,0)))\n              *(365.25*(n_DaysperWeek/7)-20)*10^-6","v":{"$error":"#N/A"}},"tonnes per year",null,null,null,{"$f":"INDEX(PriceVolatility!$B$31:$AK$31, MATCH(TRUE, PriceVolatility!$B$65:$AK$65, 0))","v":{"$error":"#N/A"}},{"$f":"INDEX(PriceVolatility!$B$31:$AK$31, MATCH(TRUE, PriceVolatility!$B$66:$AK$66, 0))","v":{"$error":"#N/A"}}]
[null,null,"Cost of fuel (this year):",null,"£",{"$f":"$F$5*n_FuelPrice*INDEX(Lists!$L$4:$L$6, MATCH(n_FuelUnit, a_FuelUnits, 0))","v":{"$error":"#N/A"}},"per year",null,null,"PAYBACK PERIOD:",{"$f":"IFERROR(IF(K5=L5, K5-n_Timestamp&\" years\", MIN($K$5:$L$5)-n_Timestamp&\"-\"&MAX($K$5:$L$5)-n_Timestamp&\" years\"), \"beyond 2035\")","v":"beyond 2035"}]
[]
[null,null,"Emissions mitigated:",null,null,null,null,null,null,"Fuel price scenario:","Existing policies"]
[null,null,"NOx",{"$f":"VLOOKUP(n_Enginetype&\"_\"&n_Fuel, a_EF, 4, FALSE)*n_AnnualFC*10^-3","v":{"$error":"#N/A"}},"tonnes/yr",null,null,null,null,"Electricity price scenario:","Existing policies"]
[null,null,"PM10",{"$f":"VLOOKUP(n_Enginetype&\"_\"&n_Fuel, a_EF, 5, FALSE)*n_AnnualFC","v":{"$error":"#N/A"}},"kg/yr"]
[null,null,"PM2.5",{"$f":"VLOOKUP(n_Enginetype&\"_\"&n_Fuel, a_EF, 6, FALSE)*n_AnnualFC","v":{"$error":"#N/A"}},"kg/yr"]
[null,null,"SO2",{"$f":"INDEX(a_SO2EF, MATCH(n_Fuel, a_FuelType, 0))*n_AnnualFC","v":{"$error":"#N/A"}},"tonnes/yr"]
[]
[null,null,null,{"$f":"n_Timestamp","v":2019},{"$f":"D14+1","v":2020},{"$f":"E14+1","v":2021},2022,2023,2024,2025,2026,2027,2028,2029]
[null,null,"CO2e savings (tonnes/yr)",{"$f":"INDEX(r_CO2_savings, MATCH(D$14, PriceVolatility!$B$80:$AK$80, 0))","v":"n/a"},{"$f":"INDEX(r_CO2_savings, MATCH(E$14, PriceVolatility!$B$80:$AK$80, 0))","v":"n/a"},{"$f":"INDEX(r_CO2_savings, MATCH(F$14, PriceVolatility!$B$80:$AK$80, 0))","v":"n/a"},{"$f":"INDEX(r_CO2_savings, MATCH(G$14, PriceVolatility!$B$80:$AK$80, 0))","v":"n/a"},{"$f":"INDEX(r_CO2_savings, MATCH(H$14, PriceVolatility!$B$80:$AK$80, 0))","v":"n/a"},{"$f":"INDEX(r_CO2_savings, MATCH(I$14, PriceVolatility!$B$80:$AK$80, 0))","v":"n/a"},{"$f":"INDEX(r_CO2_savings, MATCH(J$14, PriceVolatility!$B$80:$AK$80, 0))","v":"n/a"},{"$f":"INDEX(r_CO2_savings, MATCH(K$14, PriceVolatility!$B$80:$AK$80, 0))","v":"n/a"},{"$f":"INDEX(r_CO2_savings, MATCH(L$14, PriceVolatility!$B$80:$AK$80, 0))","v":"n/a"},{"$f":"INDEX(r_CO2_savings, MATCH(M$14, PriceVolatility!$B$80:$AK$80, 0))","v":"n/a"},{"$f":"INDEX(r_CO2_savings, MATCH(N$14, PriceVolatility!$B$80:$AK$80, 0))","v":"n/a"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,{"$f":"n_Timestamp","v":2019},{"$f":"D46+1","v":2020},{"$f":"E46+1","v":2021},2022,2023,2024,2025,2026,2027,2028,2029]
[null,null,"Shoreside costs:",{"$f":"INDEX(PriceVolatility!$R$55:$AK$55, MATCH(Results!D$46, PriceVolatility!$R$54:$AK$54, 0))","v":135000},{"$f":"INDEX(PriceVolatility!$R$55:$AK$55, MATCH(Results!E$46, PriceVolatility!$R$54:$AK$54, 0))","v":145000},{"$f":"INDEX(PriceVolatility!$R$55:$AK$55, MATCH(Results!F$46, PriceVolatility!$R$54:$AK$54, 0))","v":155000},{"$f":"INDEX(PriceVolatility!$R$55:$AK$55, MATCH(Results!G$46, PriceVolatility!$R$54:$AK$54, 0))","v":165000},{"$f":"INDEX(PriceVolatility!$R$55:$AK$55, MATCH(Results!H$46, PriceVolatility!$R$54:$AK$54, 0))","v":175000},{"$f":"INDEX(PriceVolatility!$R$55:$AK$55, MATCH(Results!I$46, PriceVolatility!$R$54:$AK$54, 0))","v":185000},{"$f":"INDEX(PriceVolatility!$R$55:$AK$55, MATCH(Results!J$46, PriceVolatility!$R$54:$AK$54, 0))","v":195000},{"$f":"INDEX(PriceVolatility!$R$55:$AK$55, MATCH(Results!K$46, PriceVolatility!$R$54:$AK$54, 0))","v":205000},{"$f":"INDEX(PriceVolatility!$R$55:$AK$55, MATCH(Results!L$46, PriceVolatility!$R$54:$AK$54, 0))","v":215000},{"$f":"INDEX(PriceVolatility!$R$55:$AK$55, MATCH(Results!M$46, PriceVolatility!$R$54:$AK$54, 0))","v":225000},{"$f":"INDEX(PriceVolatility!$R$55:$AK$55, MATCH(Results!N$46, PriceVolatility!$R$54:$AK$54, 0))","v":235000}]
[null,null,"Fuel costs:",{"$f":"INDEX(PriceVolatility!$R$24:$AK$24, MATCH(Results!D$46, PriceVolatility!$R$54:$AK$54, 0))","v":{"$error":"#N/A"}},{"$f":"INDEX(PriceVolatility!$R$24:$AK$24, MATCH(Results!E$46, PriceVolatility!$R$54:$AK$54, 0))","v":{"$error":"#N/A"}},{"$f":"INDEX(PriceVolatility!$R$24:$AK$24, MATCH(Results!F$46, PriceVolatility!$R$54:$AK$54, 0))","v":{"$error":"#N/A"}},{"$f":"INDEX(PriceVolatility!$R$24:$AK$24, MATCH(Results!G$46, PriceVolatility!$R$54:$AK$54, 0))","v":{"$error":"#N/A"}},{"$f":"INDEX(PriceVolatility!$R$24:$AK$24, MATCH(Results!H$46, PriceVolatility!$R$54:$AK$54, 0))","v":{"$error":"#N/A"}},{"$f":"INDEX(PriceVolatility!$R$24:$AK$24, MATCH(Results!I$46, PriceVolatility!$R$54:$AK$54, 0))","v":{"$error":"#N/A"}},{"$f":"INDEX(PriceVolatility!$R$24:$AK$24, MATCH(Results!J$46, PriceVolatility!$R$54:$AK$54, 0))","v":{"$error":"#N/A"}},{"$f":"INDEX(PriceVolatility!$R$24:$AK$24, MATCH(Results!K$46, PriceVolatility!$R$54:$AK$54, 0))","v":{"$error":"#N/A"}},{"$f":"INDEX(PriceVolatility!$R$24:$AK$24, MATCH(Results!L$46, PriceVolatility!$R$54:$AK$54, 0))","v":{"$error":"#N/A"}},{"$f":"INDEX(PriceVolatility!$R$24:$AK$24, MATCH(Results!M$46, PriceVolatility!$R$54:$AK$54, 0))","v":{"$error":"#N/A"}},{"$f":"INDEX(PriceVolatility!$R$24:$AK$24, MATCH(Results!N$46, PriceVolatility!$R$54:$AK$54, 0))","v":{"$error":"#N/A"}}]

{"sheet":"Results_2","index":4,"n_rows":48,"n_cols":15,"rows_kept":48,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[]
[null,null,"Fuel consumed idling per year:",null,null,{"$f":"(n_HrsPerDay + n_Minsperday/60)*n_Enginepower*n_VesselNumbers*\n               IF(n_LoadChoice=\"Enter manually\",n_LoadManual,0.2)\n              *IF(n_SFCChoice=\"Enter manually\",n_SFCManual,INDEX(a_SFC,MATCH(n_Enginetype,a_EngineType,0),MATCH(n_Fuel,Lists!$G$3:$J$3,0)))\n              *(365.25*(n_DaysperWeek/7)-20)*10^-6","v":{"$error":"#N/A"}},"tonnes per year",null,null,null,{"$f":"INDEX(PriceVolatility!$B$31:$AK$31, MATCH(TRUE, PriceVolatility!$B$65:$AK$65, 0))","v":{"$error":"#N/A"}},{"$f":"INDEX(PriceVolatility!$B$31:$AK$31, MATCH(TRUE, PriceVolatility!$B$66:$AK$66, 0))","v":{"$error":"#N/A"}}]
[null,null,"Cost of fuel (this year):",null,"£",{"$f":"$F$5*n_FuelPrice*INDEX(Lists!$L$4:$L$6, MATCH(n_FuelUnit, a_FuelUnits, 0))","v":{"$error":"#N/A"}},"per year",null,null,"PAYBACK PERIOD:",{"$f":"Results_2!n_PaybackPeriod&\" years\"","v":"4 years"}]
[]
[null,null,"Emissions mitigated:",null,null,null,null,null,null,"Fuel price scenario:","Existing policies"]
[null,null,"NOx",{"$f":"VLOOKUP(n_Enginetype&\"_\"&n_Fuel, a_EF, 4, FALSE)*n_AnnualFC*10^-3","v":{"$error":"#N/A"}},"tonnes/yr",null,null,null,null,"Electricity price scenario:","Existing policies"]
[null,null,"PM10",{"$f":"VLOOKUP(n_Enginetype&\"_\"&n_Fuel, a_EF, 5, FALSE)*n_AnnualFC","v":{"$error":"#N/A"}},"kg/yr"]
[null,null,"PM2.5",{"$f":"VLOOKUP(n_Enginetype&\"_\"&n_Fuel, a_EF, 6, FALSE)*n_AnnualFC","v":{"$error":"#N/A"}},"kg/yr"]
[null,null,"SO2",{"$f":"INDEX(a_SO2EF, MATCH(n_Fuel, a_FuelType, 0))*n_AnnualFC","v":{"$error":"#N/A"}},"tonnes/yr"]
[]
[null,null,null,{"$f":"n_Timestamp","v":2019},{"$f":"D14+1","v":2020},{"$f":"E14+1","v":2021},2022,2023,2024,2025,2026,2027,2028,2029,2030]
[null,null,"CO2e savings (tonnes/yr)",{"$f":"INDEX(PriceVolatility_2!r_CO2_savings_2, MATCH(D$14, PriceVolatility!$B$80:$AK$80, 0))","v":"n/a"},{"$f":"INDEX(PriceVolatility_2!r_CO2_savings_2, MATCH(E$14, PriceVolatility!$B$80:$AK$80, 0))","v":"n/a"},{"$f":"INDEX(PriceVolatility_2!r_CO2_savings_2, MATCH(F$14, PriceVolatility!$B$80:$AK$80, 0))","v":"n/a"},{"$f":"INDEX(PriceVolatility_2!r_CO2_savings_2, MATCH(G$14, PriceVolatility!$B$80:$AK$80, 0))","v":"n/a"},{"$f":"INDEX(PriceVolatility_2!r_CO2_savings_2, MATCH(H$14, PriceVolatility!$B$80:$AK$80, 0))","v":"n/a"},{"$f":"INDEX(PriceVolatility_2!r_CO2_savings_2, MATCH(I$14, PriceVolatility!$B$80:$AK$80, 0))","v":"n/a"},{"$f":"INDEX(PriceVolatility_2!r_CO2_savings_2, MATCH(J$14, PriceVolatility!$B$80:$AK$80, 0))","v":"n/a"},{"$f":"INDEX(PriceVolatility_2!r_CO2_savings_2, MATCH(K$14, PriceVolatility!$B$80:$AK$80, 0))","v":"n/a"},{"$f":"INDEX(PriceVolatility_2!r_CO2_savings_2, MATCH(L$14, PriceVolatility!$B$80:$AK$80, 0))","v":"n/a"},{"$f":"INDEX(PriceVolatility_2!r_CO2_savings_2, MATCH(M$14, PriceVolatility!$B$80:$AK$80, 0))","v":"n/a"},{"$f":"INDEX(PriceVolatility_2!r_CO2_savings_2, MATCH(N$14, PriceVolatility!$B$80:$AK$80, 0))","v":"n/a"},{"$f":"INDEX(PriceVolatility_2!r_CO2_savings_2, MATCH(O$14, PriceVolatility!$B$80:$AK$80, 0))","v":"n/a"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,{"$f":"n_Timestamp","v":2019},{"$f":"D46+1","v":2020},{"$f":"E46+1","v":2021},2022,2023,2024,2025,2026,2027,2028,2029]
[null,null,"Shoreside costs:",{"$f":"INDEX(PriceVolatility_2!$R$59:$AK$59, MATCH(Results_2!D$46, PriceVolatility_2!$R$49:$AK$49, 0))","v":{"$error":"#N/A"}},{"$f":"INDEX(PriceVolatility_2!$R$59:$AK$59, MATCH(Results_2!E$46, PriceVolatility_2!$R$49:$AK$49, 0))","v":{"$error":"#N/A"}},{"$f":"INDEX(PriceVolatility_2!$R$59:$AK$59, MATCH(Results_2!F$46, PriceVolatility_2!$R$49:$AK$49, 0))","v":{"$error":"#N/A"}},{"$f":"INDEX(PriceVolatility_2!$R$59:$AK$59, MATCH(Results_2!G$46, PriceVolatility_2!$R$49:$AK$49, 0))","v":{"$error":"#N/A"}},{"$f":"INDEX(PriceVolatility_2!$R$59:$AK$59, MATCH(Results_2!H$46, PriceVolatility_2!$R$49:$AK$49, 0))","v":{"$error":"#N/A"}},{"$f":"INDEX(PriceVolatility_2!$R$59:$AK$59, MATCH(Results_2!I$46, PriceVolatility_2!$R$49:$AK$49, 0))","v":{"$error":"#N/A"}},{"$f":"INDEX(PriceVolatility_2!$R$59:$AK$59, MATCH(Results_2!J$46, PriceVolatility_2!$R$49:$AK$49, 0))","v":{"$error":"#N/A"}},{"$f":"INDEX(PriceVolatility_2!$R$59:$AK$59, MATCH(Results_2!K$46, PriceVolatility_2!$R$49:$AK$49, 0))","v":{"$error":"#N/A"}},{"$f":"INDEX(PriceVolatility_2!$R$59:$AK$59, MATCH(Results_2!L$46, PriceVolatility_2!$R$49:$AK$49, 0))","v":{"$error":"#N/A"}},{"$f":"INDEX(PriceVolatility_2!$R$59:$AK$59, MATCH(Results_2!M$46, PriceVolatility_2!$R$49:$AK$49, 0))","v":{"$error":"#N/A"}},{"$f":"INDEX(PriceVolatility_2!$R$59:$AK$59, MATCH(Results_2!N$46, PriceVolatility_2!$R$49:$AK$49, 0))","v":{"$error":"#N/A"}}]
[null,null,"Fuel costs:",{"$f":"INDEX(PriceVolatility_2!$R$24:$AK$24, MATCH(Results_2!D$46, PriceVolatility_2!$R$23:$AK$23, 0))","v":{"$error":"#N/A"}},{"$f":"INDEX(PriceVolatility_2!$R$24:$AK$24, MATCH(Results_2!E$46, PriceVolatility_2!$R$23:$AK$23, 0))","v":{"$error":"#N/A"}},{"$f":"INDEX(PriceVolatility_2!$R$24:$AK$24, MATCH(Results_2!F$46, PriceVolatility_2!$R$23:$AK$23, 0))","v":{"$error":"#N/A"}},{"$f":"INDEX(PriceVolatility_2!$R$24:$AK$24, MATCH(Results_2!G$46, PriceVolatility_2!$R$23:$AK$23, 0))","v":{"$error":"#N/A"}},{"$f":"INDEX(PriceVolatility_2!$R$24:$AK$24, MATCH(Results_2!H$46, PriceVolatility_2!$R$23:$AK$23, 0))","v":{"$error":"#N/A"}},{"$f":"INDEX(PriceVolatility_2!$R$24:$AK$24, MATCH(Results_2!I$46, PriceVolatility_2!$R$23:$AK$23, 0))","v":{"$error":"#N/A"}},{"$f":"INDEX(PriceVolatility_2!$R$24:$AK$24, MATCH(Results_2!J$46, PriceVolatility_2!$R$23:$AK$23, 0))","v":{"$error":"#N/A"}},{"$f":"INDEX(PriceVolatility_2!$R$24:$AK$24, MATCH(Results_2!K$46, PriceVolatility_2!$R$23:$AK$23, 0))","v":{"$error":"#N/A"}},{"$f":"INDEX(PriceVolatility_2!$R$24:$AK$24, MATCH(Results_2!L$46, PriceVolatility_2!$R$23:$AK$23, 0))","v":{"$error":"#N/A"}},{"$f":"INDEX(PriceVolatility_2!$R$24:$AK$24, MATCH(Results_2!M$46, PriceVolatility_2!$R$23:$AK$23, 0))","v":{"$error":"#N/A"}},{"$f":"INDEX(PriceVolatility_2!$R$24:$AK$24, MATCH(Results_2!N$46, PriceVolatility_2!$R$23:$AK$23, 0))","v":{"$error":"#N/A"}}]

{"sheet":"PriceVolatility","index":5,"n_rows":82,"n_cols":41,"rows_kept":82,"cut":false,"hidden":true,"merged":[]}
["Processing explanations in this column"]
["|"]
["|","Timestamp",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"YEAR(NOW())","v":2019},null,"Fuel price",{"$f":"n_FuelPrice*INDEX(Lists!$L$4:$L$6, MATCH(n_FuelUnit, a_FuelUnits, 0))","v":0},"per tonne","Elec. Price",{"$f":"IF(AND(ISNUMBER(n_ElecPrice),n_ElecPrice>0),n_ElecPrice,INDEX($R$36:$AK$36,MATCH(n_Timestamp,$R$31:$AK$31,0))/100)","v":0.08},"per kWh"]
["V",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Source: BEIS UEP projections"]
[null,null,2001,{"$f":"C5+1","v":2002},{"$f":"D5+1","v":2003},2004,2005,2006,2007,2008,2009,2010,2011,2012,2013,2014,2015,2016,2017,2018,2019,2020,2021,2022,2023,2024,2025,2026,2027,2028,2029,2030,2031,2032,2033,2034,2035]
["1. BEIS UEP projected cost of fuels (£ per tonne)","Existing policies",2.1650474404056763,2.030180523604129,2.2674454588215358,2.4950661801430387,3.1204382652527527,3.6819015254359897,3.6611155812797045,5.28103022379526,4.2597306518592619,5.1248857187622434,6.248298950219989,6.4043864271092232,6.1649604988213156,5.5067308096614438,4.1363817037841066,2.9254771399813042,3.2395508898992995,3.3815296193809097,3.4875449872281727,3.6375539165004005,3.7849926563084035,3.8845664571813194,4.0280431144321946,4.170863713410121,4.3137360894267944,4.4115760119059733,4.5545530072961879,4.6975828498863335,4.7955813164228633,4.9387179407271322,4.9466547499107785,4.9546458676616663,4.9626916655926676,4.9707925178594596,4.9789488011779337]
[null,"Low price scenario",2.1650474404056763,2.030180523604129,2.2674454588215358,2.4950661801430387,3.1204382652527527,3.6819015254359897,3.6611155812797045,5.28103022379526,4.2597306518592619,5.1248857187622434,6.248298950219989,6.4043864271092232,6.1649604988213156,5.5067308096614438,4.1363817037841066,2.5648004610466129,2.2476900228288996,2.3445841674436734,2.4956841201577737,2.6006084645631642,2.7480472043711668,2.8476210052440845,2.9910976624949601,3.0888336766060474,3.231706052622723,3.3295459751019005,3.4725229704921161,3.5704682282154248,3.7135512796187937,3.811603319056224,3.8195401282398711,3.827531245990758,3.8355770439217585,3.8436778961885523,3.851834179507025]
[null,"High price scenario",2.1650474404056763,2.030180523604129,2.2674454588215358,2.4950661801430387,3.1204382652527527,3.6819015254359897,3.6611155812797045,5.28103022379526,4.2597306518592619,5.1248857187622434,6.248298950219989,6.4043864271092232,6.1649604988213156,5.5067308096614438,4.1363817037841066,3.5566613281170119,4.0059888326355173,4.2381367318507994,4.4343212694317353,4.6294147835708008,4.8670226931124745,5.056765663719065,5.2904114907036126,5.4783166745483731,5.7113582202987212,5.899367312511572,6.1325134776354595,6.320627905092441,6.5538801262294815,6.7421013354005845,6.7500381445842317,6.7580292623351195,6.766075060266119,6.7741759125329146,6.782332195851386]
[]
["2. Scaled time-series to account for which year we are in. So if timestamp year is 2019, cost projections are scaled to that year. Trends are used in the UEP in effect (£/t)","Existing policies",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"R6","v":2.9254771399813042},{"$f":"S6","v":3.2395508898992995},3.3815296193809097,3.4875449872281727,3.6375539165004005,3.7849926563084035,3.8845664571813194,4.0280431144321946,4.170863713410121,4.3137360894267944,4.4115760119059733,4.5545530072961879,4.6975828498863335,4.7955813164228633,4.9387179407271322,4.9466547499107785,4.9546458676616663,4.9626916655926676,4.9707925178594596,4.9789488011779337]
[null,"Low price scenario",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(R$5=n_Timestamp,R$10,R7/INDEX($R7:$AK7,MATCH(n_Timestamp,$R$5:$AK$5,0))*INDEX($R$10:$AK$10,MATCH(n_Timestamp,$R$5:$AK$5,0)))","v":3.5841302666934225},3.1409904837893268,3.2763933120613808,3.4875449872281727,3.6341694612205337,3.8402048459823406,3.9793523075095014,4.1798509574539953,4.31643023979652,4.5160844487429781,4.6528089358032538,4.8526093430481296,4.9894810287861873,5.1894296419334252,5.3264505476904764,5.3375416865327052,5.348708717820581,5.3599521608572482,5.3712725384992508,5.382670377180836]
[null,"High price scenario",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(R$5=n_Timestamp,R$10,R8/INDEX($R8:$AK8,MATCH(n_Timestamp,$R$5:$AK$5,0))*INDEX($R$10:$AK$10,MATCH(n_Timestamp,$R$5:$AK$5,0)))","v":2.7972750805519269},3.150666229003396,3.3332480026301776,3.4875449872281727,3.6409838938691483,3.8278599056638511,3.9770906685683172,4.1608505459375911,4.3086359097337432,4.4919205265476458,4.6397876131343319,4.8231545119367469,4.971104443536305,5.1545547542285144,5.3025886684737102,5.3088308817463092,5.3151158081107059,5.3214437398363446,5.3278149711925602,5.3342297984622578]
[]
["3. Scaled against listed fuel price provided by the operators on the UserManual page (£/t)","Existing policies",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(n_Timestamp=R$5,1,R10/INDEX($R10:$AK10,MATCH(n_Timestamp,$R$5:$AK$5,0)))*$U$3","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Low price scenario",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(n_Timestamp=R$5,1,R11/INDEX($R11:$AK11,MATCH(n_Timestamp,$R$5:$AK$5,0)))*$U$3","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"High price scenario",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(n_Timestamp=R$5,1,R12/INDEX($R12:$AK12,MATCH(n_Timestamp,$R$5:$AK$5,0)))*$U$3","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"Annual costs",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"R5","v":2016},{"$f":"R18+1","v":2017},2018,2019,2020,2021,2022,2023,2024,2025,2026,2027,2028,2029,2030,2031,2032,2033,2034,2035]
["4. Using the calculated value of fuel consumption, overall fuel cost per annum are computed. The value of fuel consumption assumes that there are 20 days per year where a vessel isn't operational, and is only operational for the hours listed in the UserManual by the operator","Existing policies",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"n_AnnualFC*R14","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"n_AnnualFC*U14","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,"Low price scenario",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"n_AnnualFC*R15","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,"High price scenario",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"n_AnnualFC*R16","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[]
[null,"Cumulative costs",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2016,2017,2018,2019,2020,2021,2022,2023,2024,2025,2026,2027,2028,2029,2030,2031,2032,2033,2034,2035]
["5. Cumulative costs, starting from the base year (current year)","Existing policies",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(R$18<n_Timestamp,\"n/a\",SUM(R19, Q24))","v":"n/a"},"n/a","n/a",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,"Low price scenario",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(R$18<n_Timestamp,\"n/a\",SUM(R20, Q25))","v":"n/a"},"n/a","n/a",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,"High price scenario",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(R$18<n_Timestamp,\"n/a\",SUM(R21, Q26))","v":"n/a"},"n/a","n/a",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[]
["6. Insert costs of installation from UserManual","Installation costs:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"n_InstallationCost","v":125000}]
["7. Insert maintenance costs from UserManual (or 2.5% of installation costs)","Maintenance costs per year:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(ISNUMBER(n_MaintenanceCosts), n_MaintenanceCosts>0), n_MaintenanceCosts, $R$28*0.025)","v":10000}]
[]
[null,"Electricity costs:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2016,2017,2018,2019,2020,2021,2022,2023,2024,2025,2026,2027,2028,2029,2030,2031,2032,2033,2034,2035]
["8. BEIS UEP electricity cost projections","Existing policies",2.1650474404056763,2.030180523604129,2.2674454588215358,2.4950661801430387,3.1204382652527527,3.6819015254359897,3.6611155812797045,5.28103022379526,4.2597306518592619,5.1248857187622434,6.248298950219989,6.4043864271092232,6.1649604988213156,5.5067308096614438,4.1363817037841066,9.8314440809789598,10.231773630916422,10.678393610690929,11.366064066967883,11.718759508779044,12.009520199455691,11.958331532446099,12.117267653445348,12.428488392457485,13.121588652953738,13.339966843569039,13.026594073110507,13.652947860120287,14.132058565700046,14.2549336558883,14.495003843718086,14.746265458454852,15.238986380150072,15.465339253502989,15.830555621977528]
[null,"Low price scenario",2.1650474404056763,2.030180523604129,2.2674454588215358,2.4950661801430387,3.1204382652527527,3.6819015254359897,3.6611155812797045,5.28103022379526,4.2597306518592619,5.1248857187622434,6.248298950219989,6.4043864271092232,6.1649604988213156,5.5067308096614438,4.1363817037841066,9.8314440809789598,9.5426287144443069,10.00839967179316,10.716743557384083,11.054832730546511,11.200021147466019,11.111023125064857,11.077053262095619,11.321609729189543,11.896569321202032,11.955448443905347,11.396458036926308,11.435279675489864,11.414419226427295,11.541479013903423,11.696191529940215,11.462973469986046,11.502968503175076,11.487217250991893,10.672159904892634]
[null,"High price scenario",2.1650474404056763,2.030180523604129,2.2674454588215358,2.4950661801430387,3.1204382652527527,3.6819015254359897,3.6611155812797045,5.28103022379526,4.2597306518592619,5.1248857187622434,6.248298950219989,6.4043864271092232,6.1649604988213156,5.5067308096614438,4.1363817037841066,9.8314440809789598,10.813738512402093,11.620563285405131,12.52488088579466,13.016223920214831,13.162628217631934,13.096662051592997,13.210218412565734,13.33651097755639,14.014790878742847,14.051784420313677,13.621022835144586,13.274466551768219,13.311684051824964,13.792584517463435,13.856300378218126,13.124270001557246,12.955627849538368,12.91681108885245,12.0630506380481]
[]
["9. Scaling of electricity prices to current year","Existing policies",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"R32","v":9.8314440809789598},{"$f":"S32","v":10.231773630916422},10.678393610690929,11.366064066967883,11.718759508779044,12.009520199455691,11.958331532446099,12.117267653445348,12.428488392457485,13.121588652953738,13.339966843569039,13.026594073110507,13.652947860120287,14.132058565700046,14.2549336558883,14.495003843718086,14.746265458454852,15.238986380150072,15.465339253502989,15.830555621977528]
[null,"Low price scenario",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(R$5=n_Timestamp,R$36,R33/INDEX($R33:$AK33,MATCH(n_Timestamp,$R$5:$AK$5,0))*INDEX($R$36:$AK$36,MATCH(n_Timestamp,$R$5:$AK$5,0)))","v":10.427124872109522},10.120810370695905,10.614802086874686,11.366064066967883,11.724637842848209,11.878623131350492,11.784232776759236,11.748204701925957,12.007578686018878,12.617374705093058,12.679821275477924,12.086962003953555,12.128135820303207,12.106011450223686,12.240769707436431,12.404856154016032,12.157507563763854,12.199925869954805,12.183220259664667,11.318779120020722]
[null,"High price scenario",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(R$5=n_Timestamp,R$36,R34/INDEX($R34:$AK34,MATCH(n_Timestamp,$R$5:$AK$5,0))*INDEX($R$36:$AK$36,MATCH(n_Timestamp,$R$5:$AK$5,0)))","v":8.9218272264733969},9.8132386132949616,10.545415002387026,11.366064066967883,11.811947461708348,11.944806260071012,11.884943361869629,11.987993353785457,12.102601181033823,12.718125822147627,12.751696677422984,12.360789664472986,12.046297179028789,12.0800712718856,12.516478256680232,12.574299050508396,11.909996991593738,11.756957811284099,11.721732423286301,10.946962900911723]
[]
["10. Scaled against listed electricity price provided by the operators on the UserManual page (£/kWh)","Existing policies",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(n_Timestamp=R$5,1,R36/INDEX($R36:$AK36,MATCH(n_Timestamp,$R$5:$AK$5,0)))*$X$3","v":6.9198582890632507E-2},7.2016300950842313E-2,7.5159834030670544E-2,0.08,8.2482445565909959E-2,8.4528963614469321E-2,8.4168672370584049E-2,8.5287343671838822E-2,8.7477869695119712E-2,9.2356253321413298E-2,9.3893307410347779E-2,9.1687634321671402E-2,9.6096223140593115E-2,9.9468442074126334E-2,0.1003332979430659,0.10202303107436141,0.10379153502265066,0.10725954941209734,0.10885273327605775,0.11142330733809164]
[null,"Low price scenario",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(n_Timestamp=R$5,1,R37/INDEX($R37:$AK37,MATCH(n_Timestamp,$R$5:$AK$5,0)))*$X$3","v":7.3391279941227058E-2},7.1235286453181682E-2,7.4712245324912302E-2,0.08,8.2523820198567521E-2,8.3607645083558599E-2,8.2943278921023419E-2,8.2689695449235781E-2,8.4515298279307566E-2,8.8807345309704799E-2,8.924687526496064E-2,8.5074037469704211E-2,8.5363839224169513E-2,8.5208116926993163E-2,8.6156612423191406E-2,8.7311534272041219E-2,8.5570572132149553E-2,8.5869133223771252E-2,8.5751550847379843E-2,7.9667185075371294E-2]
[null,"High price scenario",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(n_Timestamp=R$5,1,R38/INDEX($R38:$AK38,MATCH(n_Timestamp,$R$5:$AK$5,0)))*$X$3","v":6.2796248016247308E-2},6.9070443773508183E-2,7.4223864586751134E-2,0.08,8.3138348628783762E-2,8.4073474790873806E-2,8.3652130002748903E-2,8.437744699064316E-2,8.5184113759882579E-2,8.9516481675369838E-2,8.9752770016365016E-2,8.7001372447976802E-2,8.4787818249505056E-2,8.5025537077467433E-2,8.8097186029810898E-2,8.8504157473839273E-2,8.3828469883126117E-2,8.2751304177158272E-2,8.250337041370065E-2,7.7050157988997059E-2]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"R31","v":2016},{"$f":"R44+1","v":2017},2018,2019,2020,2021,2022,2023,2024,2025,2026,2027,2028,2029,2030,2031,2032,2033,2034,2035]
["11. Annual costs of electricity - as with fuel pricing, assumes that they are closed 20 days a year.","Existing policies",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(n_HrsPerDay + n_Minsperday/60)*n_Enginepower*IF(n_LoadChoice=\"Enter manually\", n_LoadManual, 0.2)*(365.25*(n_DaysperWeek/7)-20)*R40","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Low price scenario",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(n_HrsPerDay + n_Minsperday/60)*n_Enginepower*IF(n_LoadChoice=\"Enter manually\", n_LoadManual, 0.2)*(365.25*(n_DaysperWeek/7)-20)*R41","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"High price scenario",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(n_HrsPerDay + n_Minsperday/60)*n_Enginepower*IF(n_LoadChoice=\"Enter manually\", n_LoadManual, 0.2)*(365.25*(n_DaysperWeek/7)-20)*R42","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
["12. Cumulative costs, starting from the base year (current year)","Cumulative costs",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2016,2017,2018,2019,2020,2021,2022,2023,2024,2025,2026,2027,2028,2029,2030,2031,2032,2033,2034,2035]
[null,"Existing policies",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(R$18<n_Timestamp,\"n/a\",SUM(R45, Q50))","v":"n/a"},{"$f":"IF(S$18<n_Timestamp,\"n/a\",SUM(S45, R50))","v":"n/a"},"n/a",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Low price scenario",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(R$18<n_Timestamp,\"n/a\",SUM(R46, Q51))","v":"n/a"},"n/a","n/a",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"High price scenario",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(R$18<n_Timestamp,\"n/a\",SUM(R47, Q52))","v":"n/a"},"n/a","n/a",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"Total costs NEW",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2016,2017,2018,2019,2020,2021,2022,2023,2024,2025,2026,2027,2028,2029,2030,2031,2032,2033,2034,2035]
["13. Costs of installed shore-power","Existing policies",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(R50, IF(n_Timestamp<=R$54, $R$28, 0), IF(n_Timestamp<=R$54, $R$29*(R$54-n_Timestamp+1)))","v":0},0,0,135000,145000,155000,165000,175000,185000,195000,205000,215000,225000,235000,245000,255000,265000,275000,285000,295000]
[null,"Low price scenario",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(R51, IF(n_Timestamp<=R$54, $R$28, 0), IF(n_Timestamp<=R$54, $R$29*(R$54-n_Timestamp+1)))","v":0},0,0,135000,145000,155000,165000,175000,185000,195000,205000,215000,225000,235000,245000,255000,265000,275000,285000,295000]
[null,"High price scenario",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(R52, IF(n_Timestamp<=R$54, $R$28, 0), IF(n_Timestamp<=R$54, $R$29*(R$54-n_Timestamp+1)))","v":0},0,0,135000,145000,155000,165000,175000,185000,195000,205000,215000,225000,235000,245000,255000,265000,275000,285000,295000]
[]
[null,"Payback",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2016,2017,2018,2019,2020,2021,2022,2023,2024,2025,2026,2027,2028,2029,2030,2031,2032,2033,2034,2035]
["14. Calculation of payback period","Existing policies",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(R$59<n_Timestamp, 0, SUM(R55,-R24))","v":0},0,0,{"$f":"IF(U$59<n_Timestamp, 0, SUM(U55,-U24))","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,"Extreme payback1 (high fuel, low electricity)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(R$59<n_Timestamp, 0, SUM(R56,-R26))","v":0},0,0,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,"Extreme payback2 (high electricity price, low fuel price)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(R$59<n_Timestamp, 0, SUM(R57,-R25))","v":0},0,{"$f":"IF(T$59<n_Timestamp, 0, SUM(T57,-T25))","v":0},{"$error":"#N/A"},{"$f":"IF(V$59<n_Timestamp, 0, SUM(V57,-V25))","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[]
[null,"Payback year1",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AND(Q60>=0, R60<0)","v":false},{"$f":"AND(R60>=0, S60<0)","v":false},false,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,"Extreme payback1 (high fuel, low electricity)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AND(Q61>=0, R61<0)","v":false},false,false,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,"Payback year3",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AND(Q62>=0, R62<0)","v":false},false,false,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[]
[null,"Carbon emissions from electricity production"]
[null,"(£/t CO2)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"<- carbon price from ETS - not price of electricity but will be related"]
[null,"Existing policies",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,22.2,22,21.7,21.5,21.9,22.1,22.4,22.6,22.8,23.1,23.6,32.200000000000003,38.1,42.4,49,59.4,69.900000000000006,80.3,90.7,101.1]
[null,"Low price scenario",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,22.2,22,21.7,21.5,21.9,22.1,22.4,22.6,22.8,23.1,23.6,32.200000000000003,38.1,42.4,49,59.4,69.900000000000006,80.3,90.7,101.1]
[null,"High price scenario",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,22.2,22,21.7,21.5,21.9,22.1,22.4,22.6,22.8,23.1,23.6,32.200000000000003,38.1,42.4,49,59.4,69.900000000000006,80.3,90.7,101.1]
[]
[null,"£/t CO2e",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"R70/$V$70 * $V$74","v":407.02877644167762},{"$f":"S70/$V$70 * $V$74","v":403.3618505277887},397.86146165695516,{"$f":"U70/$V$70 * $V$74","v":394.19453574306618},{"$f":"AM78","v":401.52838757084413},{"$f":"W70/$V$70 * $V$74","v":405.19531348473316},410.6957023555666,414.36262826945563,418.02955418334466,423.52994305417815,432.69725783890061,590.37507213612707,698.54938659585218,777.38829374446539,898.39684890280205,1089.0769964250294,1281.5906069042012,1472.2707544264285,1662.9509019486561,1853.6310494708832,null,{"$f":"0.28307","v":0.28306999999999999},"kg CO2e/kWh","<- Defra conversion factors"]
[null,"CO2 emissions from electricity",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"U32","v":11.366064066967883},"p/kWh"]
[null,"Existing policies",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(R45/R$74, \"n/a\")","v":0},0,0,{"$f":"IFERROR(U45/U$74, \"n/a\")","v":0},{"$f":"IFERROR(V45/V$74, \"n/a\")","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"AM75/AM74","v":40.15283875708441},"p/kg CO2e"]
[null,"Low price scenario",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(R46/R$74, \"n/a\")","v":0},0,0,{"$f":"IFERROR(U46/U$74, \"n/a\")","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"AM76*10^3","v":40152.838757084413},"p/t CO2e"]
[null,"High price scenario",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(R47/R$74, \"n/a\")","v":0},0,0,{"$f":"IFERROR(U47/U$74, \"n/a\")","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"AM77/100","v":401.52838757084413},"£/t CO2e"]
[]
[null,"CO2 emissions from fuel",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2016,2017,2018,2019,2020,2021,2022,2023,2024,2025,2026,2027,2028,2029,2030,2031,2032,2033,2034,2035]
[null,"Fuel",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(R$80<n_Timestamp, \"n/a\", n_AnnualFC*INDEX(a_CEF, MATCH(n_Fuel, a_FuelType, 0))*10^-3)","v":"n/a"},"n/a","n/a",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,"SAVINGS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(SUM(R81, -R76), \"n/a\")","v":0},{"$f":"IFERROR(SUM(S81, -S76), \"n/a\")","v":0},0,{"$f":"IFERROR(SUM(U81, -U76), \"n/a\")","v":"n/a"},"n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a"]

{"sheet":"PriceVolatility_2","index":6,"n_rows":75,"n_cols":41,"rows_kept":75,"cut":false,"hidden":true,"merged":[]}
["Processing explanations in this column"]
["|"]
["|","Timestamp",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"YEAR(NOW())","v":2019},null,"Fuel price",{"$f":"n_FuelPrice*INDEX(Lists!$L$4:$L$6, MATCH(n_FuelUnit, a_FuelUnits, 0))","v":0},"per tonne","Elec. Price",{"$f":"IF(AND(ISNUMBER(n_ElecPrice),n_ElecPrice>0),n_ElecPrice,INDEX(#REF!,MATCH(n_Timestamp,#REF!,0))/100)","v":0.08},"per kWh"]
["V",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Source: BEIS UEP projections"]
[null,null,2001,{"$f":"C5+1","v":2002},{"$f":"D5+1","v":2003},2004,2005,2006,2007,2008,2009,2010,2011,2012,2013,2014,2015,2016,2017,2018,2019,2020,2021,2022,2023,2024,2025,2026,2027,2028,2029,2030,2031,2032,2033,2034,2035]
["1. BEIS UEP projected cost of fuels (£ per tonne)","Existing policies",2.1650474404056763,2.030180523604129,2.2674454588215358,2.4950661801430387,3.1204382652527527,3.6819015254359897,3.6611155812797045,5.28103022379526,4.2597306518592619,5.1248857187622434,6.248298950219989,6.4043864271092232,6.1649604988213156,5.5067308096614438,4.1363817037841066,2.9254771399813042,3.2395508898992995,3.3815296193809097,3.4875449872281727,3.6375539165004005,3.7849926563084035,3.8845664571813194,4.0280431144321946,4.170863713410121,4.3137360894267944,4.4115760119059733,4.5545530072961879,4.6975828498863335,4.7955813164228633,4.9387179407271322,4.9466547499107785,4.9546458676616663,4.9626916655926676,4.9707925178594596,4.9789488011779337]
[null,"Low price scenario",2.1650474404056763,2.030180523604129,2.2674454588215358,2.4950661801430387,3.1204382652527527,3.6819015254359897,3.6611155812797045,5.28103022379526,4.2597306518592619,5.1248857187622434,6.248298950219989,6.4043864271092232,6.1649604988213156,5.5067308096614438,4.1363817037841066,2.5648004610466129,2.2476900228288996,2.3445841674436734,2.4956841201577737,2.6006084645631642,2.7480472043711668,2.8476210052440845,2.9910976624949601,3.0888336766060474,3.231706052622723,3.3295459751019005,3.4725229704921161,3.5704682282154248,3.7135512796187937,3.811603319056224,3.8195401282398711,3.827531245990758,3.8355770439217585,3.8436778961885523,3.851834179507025]
[null,"High price scenario",2.1650474404056763,2.030180523604129,2.2674454588215358,2.4950661801430387,3.1204382652527527,3.6819015254359897,3.6611155812797045,5.28103022379526,4.2597306518592619,5.1248857187622434,6.248298950219989,6.4043864271092232,6.1649604988213156,5.5067308096614438,4.1363817037841066,3.5566613281170119,4.0059888326355173,4.2381367318507994,4.4343212694317353,4.6294147835708008,4.8670226931124745,5.056765663719065,5.2904114907036126,5.4783166745483731,5.7113582202987212,5.899367312511572,6.1325134776354595,6.320627905092441,6.5538801262294815,6.7421013354005845,6.7500381445842317,6.7580292623351195,6.766075060266119,6.7741759125329146,6.782332195851386]
[]
["2. Scaled time-series to account for which year we are in. So if timestamp year is 2019, cost projections are scaled to that year. Trends are used in the UEP in effect (£/t)","Existing policies",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"R6","v":2.9254771399813042},{"$f":"S6","v":3.2395508898992995},3.3815296193809097,3.4875449872281727,3.6375539165004005,3.7849926563084035,3.8845664571813194,4.0280431144321946,4.170863713410121,4.3137360894267944,4.4115760119059733,4.5545530072961879,4.6975828498863335,4.7955813164228633,4.9387179407271322,4.9466547499107785,4.9546458676616663,4.9626916655926676,4.9707925178594596,4.9789488011779337]
[null,"Low price scenario",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(R$5=n_Timestamp,R$10,R7/INDEX($R7:$AK7,MATCH(n_Timestamp,$R$5:$AK$5,0))*INDEX($R$10:$AK$10,MATCH(n_Timestamp,$R$5:$AK$5,0)))","v":3.5841302666934225},3.1409904837893268,3.2763933120613808,3.4875449872281727,3.6341694612205337,3.8402048459823406,3.9793523075095014,4.1798509574539953,4.31643023979652,4.5160844487429781,4.6528089358032538,4.8526093430481296,4.9894810287861873,5.1894296419334252,5.3264505476904764,5.3375416865327052,5.348708717820581,5.3599521608572482,5.3712725384992508,5.382670377180836]
[null,"High price scenario",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(R$5=n_Timestamp,R$10,R8/INDEX($R8:$AK8,MATCH(n_Timestamp,$R$5:$AK$5,0))*INDEX($R$10:$AK$10,MATCH(n_Timestamp,$R$5:$AK$5,0)))","v":2.7972750805519269},3.150666229003396,3.3332480026301776,3.4875449872281727,3.6409838938691483,3.8278599056638511,3.9770906685683172,4.1608505459375911,4.3086359097337432,4.4919205265476458,4.6397876131343319,4.8231545119367469,4.971104443536305,5.1545547542285144,5.3025886684737102,5.3088308817463092,5.3151158081107059,5.3214437398363446,5.3278149711925602,5.3342297984622578]
[]
["3. Scaled against listed fuel price provided by the operators on the UserManual page (£/t)","Existing policies",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(n_Timestamp=R$5,1,R10/INDEX($R10:$AK10,MATCH(n_Timestamp,$R$5:$AK$5,0)))*$U$3","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Low price scenario",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(n_Timestamp=R$5,1,R11/INDEX($R11:$AK11,MATCH(n_Timestamp,$R$5:$AK$5,0)))*$U$3","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"High price scenario",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(n_Timestamp=R$5,1,R12/INDEX($R12:$AK12,MATCH(n_Timestamp,$R$5:$AK$5,0)))*$U$3","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"R5","v":2016},{"$f":"R18+1","v":2017},2018,2019,2020,2021,2022,2023,2024,2025,2026,2027,2028,2029,2030,2031,2032,2033,2034,2035]
["4. Using the calculated value of fuel consumption, overall fuel cost per annum are computed. The value of fuel consumption assumes that there are 20 days per year where a vessel isn't operational, and is only operational for the hours listed in the UserManual by the operator","Existing policies",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"n_AnnualFC*R14","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,"Low price scenario",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,"High price scenario",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2016,2017,2018,2019,2020,2021,2022,2023,2024,2025,2026,2027,2028,2029,2030,2031,2032,2033,2034,2035]
["5. Cumulative costs, starting from the base year (current year)","Existing policies",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(R$18<n_Timestamp,\"n/a\",SUM(R19, Q24))","v":"n/a"},"n/a","n/a",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,"Low price scenario",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(R$18<n_Timestamp,\"n/a\",SUM(R20, Q25))","v":"n/a"},"n/a","n/a",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,"High price scenario",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(R$18<n_Timestamp,\"n/a\",SUM(R21, Q26))","v":"n/a"},"n/a","n/a",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[]
["6. Insert defined payback period","Payback period:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"n_PaybackPeriod","v":4},"yrs"]
["7. Insert assumed maintenance costs as a % of install","Maintenance %",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"n_Maintenance2","v":0.02}]
[]
[null,"Electricity costs",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2016,2017,2018,2019,2020,2021,2022,2023,2024,2025,2026,2027,2028,2029,2030,2031,2032,2033,2034,2035]
["8. BEIS UEP electricity cost projections","Existing policies",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9.8314440809789598,10.231773630916422,10.678393610690929,11.366064066967883,11.718759508779044,12.009520199455691,11.958331532446099,12.117267653445348,12.428488392457485,13.121588652953738,13.339966843569039,13.026594073110507,13.652947860120287,14.132058565700046,14.2549336558883,14.495003843718086,14.746265458454852,15.238986380150072,15.465339253502989,15.830555621977528]
[null,"Low price scenario",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9.8314440809789598,9.5426287144443069,10.00839967179316,10.716743557384083,11.054832730546511,11.200021147466019,11.111023125064857,11.077053262095619,11.321609729189543,11.896569321202032,11.955448443905347,11.396458036926308,11.435279675489864,11.414419226427295,11.541479013903423,11.696191529940215,11.462973469986046,11.502968503175076,11.487217250991893,10.672159904892634]
[null,"High price scenario",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9.8314440809789598,10.813738512402093,11.620563285405131,12.52488088579466,13.016223920214831,13.162628217631934,13.096662051592997,13.210218412565734,13.33651097755639,14.014790878742847,14.051784420313677,13.621022835144586,13.274466551768219,13.311684051824964,13.792584517463435,13.856300378218126,13.124270001557246,12.955627849538368,12.91681108885245,12.0630506380481]
[]
["9. Scaling of electricity prices to current year","Existing policies",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"R32","v":9.8314440809789598},{"$f":"S32","v":10.231773630916422},10.678393610690929,11.366064066967883,11.718759508779044,12.009520199455691,11.958331532446099,12.117267653445348,12.428488392457485,13.121588652953738,13.339966843569039,13.026594073110507,13.652947860120287,14.132058565700046,14.2549336558883,14.495003843718086,14.746265458454852,15.238986380150072,15.465339253502989,15.830555621977528]
[null,"Low price scenario",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(R$5=n_Timestamp,R$32,R33/INDEX($R33:$AK33,MATCH(n_Timestamp,$R$5:$AK$5,0))*INDEX($R$32:$AK$32,MATCH(n_Timestamp,$R$5:$AK$5,0)))","v":10.427124872109522},10.120810370695905,10.614802086874686,11.366064066967883,11.724637842848209,11.878623131350492,11.784232776759236,11.748204701925957,12.007578686018878,12.617374705093058,12.679821275477924,12.086962003953555,12.128135820303207,12.106011450223686,12.240769707436431,12.404856154016032,12.157507563763854,12.199925869954805,12.183220259664667,11.318779120020722]
[null,"High price scenario",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(R$5=n_Timestamp,R$32,R34/INDEX($R34:$AK34,MATCH(n_Timestamp,$R$5:$AK$5,0))*INDEX($R$32:$AK$32,MATCH(n_Timestamp,$R$5:$AK$5,0)))","v":8.9218272264733969},9.8132386132949616,10.545415002387026,11.366064066967883,11.811947461708348,11.944806260071012,11.884943361869629,11.987993353785457,12.102601181033823,12.718125822147627,12.751696677422984,12.360789664472986,12.046297179028789,12.0800712718856,12.516478256680232,12.574299050508396,11.909996991593738,11.756957811284099,11.721732423286301,10.946962900911723]
[]
["10. Scaled against listed electricity price provided by the operators on the UserManual page (£/kWh)","Existing policies",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(n_Timestamp=R$5,1,R36/INDEX($R36:$AK36,MATCH(n_Timestamp,$R$5:$AK$5,0)))*$X$3","v":6.9198582890632507E-2},7.2016300950842313E-2,7.5159834030670544E-2,0.08,8.2482445565909959E-2,8.4528963614469321E-2,8.4168672370584049E-2,8.5287343671838822E-2,8.7477869695119712E-2,9.2356253321413298E-2,9.3893307410347779E-2,9.1687634321671402E-2,9.6096223140593115E-2,9.9468442074126334E-2,0.1003332979430659,0.10202303107436141,0.10379153502265066,0.10725954941209734,0.10885273327605775,0.11142330733809164]
[null,"Low price scenario",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(n_Timestamp=R$5,1,R37/INDEX($R37:$AK37,MATCH(n_Timestamp,$R$5:$AK$5,0)))*$X$3","v":7.3391279941227058E-2},7.1235286453181682E-2,7.4712245324912302E-2,0.08,8.2523820198567521E-2,8.3607645083558599E-2,8.2943278921023419E-2,8.2689695449235781E-2,8.4515298279307566E-2,8.8807345309704799E-2,8.924687526496064E-2,8.5074037469704211E-2,8.5363839224169513E-2,8.5208116926993163E-2,8.6156612423191406E-2,8.7311534272041219E-2,8.5570572132149553E-2,8.5869133223771252E-2,8.5751550847379843E-2,7.9667185075371294E-2]
[null,"High price scenario",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(n_Timestamp=R$5,1,R38/INDEX($R38:$AK38,MATCH(n_Timestamp,$R$5:$AK$5,0)))*$X$3","v":6.2796248016247308E-2},{"$f":"IF(n_Timestamp=S$5,1,S38/INDEX($R38:$AK38,MATCH(n_Timestamp,$R$5:$AK$5,0)))*$X$3","v":6.9070443773508183E-2},7.4223864586751134E-2,0.08,8.3138348628783762E-2,8.4073474790873806E-2,8.3652130002748903E-2,8.437744699064316E-2,8.5184113759882579E-2,8.9516481675369838E-2,8.9752770016365016E-2,8.7001372447976802E-2,8.4787818249505056E-2,8.5025537077467433E-2,8.8097186029810898E-2,8.8504157473839273E-2,8.3828469883126117E-2,8.2751304177158272E-2,8.250337041370065E-2,7.7050157988997059E-2]
[]
[null,"Annual costs",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"R31","v":2016},{"$f":"R44+1","v":2017},{"$f":"S44+1","v":2018},{"$f":"T44+1","v":2019},{"$f":"U44+1","v":2020},{"$f":"V44+1","v":2021},{"$f":"W44+1","v":2022},{"$f":"X44+1","v":2023},{"$f":"Y44+1","v":2024},{"$f":"Z44+1","v":2025},{"$f":"AA44+1","v":2026},{"$f":"AB44+1","v":2027},{"$f":"AC44+1","v":2028},{"$f":"AD44+1","v":2029},{"$f":"AE44+1","v":2030},{"$f":"AF44+1","v":2031},{"$f":"AG44+1","v":2032},{"$f":"AH44+1","v":2033},{"$f":"AI44+1","v":2034},{"$f":"AJ44+1","v":2035}]
["11. Annual costs of electricity - as with fuel pricing, assumes that they are closed 20 days a year.","Existing policies",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(n_HrsPerDay + n_Minsperday/60)*n_Enginepower*IF(n_LoadChoice=\"Enter manually\", n_LoadManual, 0.2)*(365.25*n_DaysperWeek/7-20)*R40","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Low price scenario",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(n_HrsPerDay + n_Minsperday/60)*n_Enginepower*IF(n_LoadChoice=\"Enter manually\", n_LoadManual, 0.2)*(365.25*n_DaysperWeek/7-20)*R41","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"High price scenario",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(n_HrsPerDay + n_Minsperday/60)*n_Enginepower*IF(n_LoadChoice=\"Enter manually\", n_LoadManual, 0.2)*(365.25*n_DaysperWeek/7-20)*R42","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
["12. Cumulative costs, starting from the base year (current year)","Cumulate electricty costs",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2016,2017,2018,2019,2020,2021,2022,2023,2024,2025,2026,2027,2028,2029,2030,2031,2032,2033,2034,2035]
[null,"Existing policies",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(R$18<n_Timestamp,\"n/a\",SUM(R45, Q50))","v":"n/a"},{"$f":"IF(S$18<n_Timestamp,\"n/a\",SUM(S45, R50))","v":"n/a"},{"$f":"IF(T$18<n_Timestamp,\"n/a\",SUM(T45, S50))","v":"n/a"},{"$f":"IF(U$18<n_Timestamp,\"n/a\",SUM(U45, T50))","v":0},{"$f":"IF(V$18<n_Timestamp,\"n/a\",SUM(V45, U50))","v":0},{"$f":"IF(W$18<n_Timestamp,\"n/a\",SUM(W45, V50))","v":0},{"$f":"IF(X$18<n_Timestamp,\"n/a\",SUM(X45, W50))","v":0},{"$f":"IF(Y$18<n_Timestamp,\"n/a\",SUM(Y45, X50))","v":0},{"$f":"IF(Z$18<n_Timestamp,\"n/a\",SUM(Z45, Y50))","v":0},{"$f":"IF(AA$18<n_Timestamp,\"n/a\",SUM(AA45, Z50))","v":0},{"$f":"IF(AB$18<n_Timestamp,\"n/a\",SUM(AB45, AA50))","v":0},{"$f":"IF(AC$18<n_Timestamp,\"n/a\",SUM(AC45, AB50))","v":0},{"$f":"IF(AD$18<n_Timestamp,\"n/a\",SUM(AD45, AC50))","v":0},{"$f":"IF(AE$18<n_Timestamp,\"n/a\",SUM(AE45, AD50))","v":0},{"$f":"IF(AF$18<n_Timestamp,\"n/a\",SUM(AF45, AE50))","v":0},{"$f":"IF(AG$18<n_Timestamp,\"n/a\",SUM(AG45, AF50))","v":0},{"$f":"IF(AH$18<n_Timestamp,\"n/a\",SUM(AH45, AG50))","v":0},{"$f":"IF(AI$18<n_Timestamp,\"n/a\",SUM(AI45, AH50))","v":0},{"$f":"IF(AJ$18<n_Timestamp,\"n/a\",SUM(AJ45, AI50))","v":0},{"$f":"IF(AK$18<n_Timestamp,\"n/a\",SUM(AK45, AJ50))","v":0}]
[null,"Low price scenario",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"n/a","n/a","n/a",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"High price scenario",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"n/a","n/a","n/a",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"Payback time",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"PriceVolatility_2!n_Timestamp+n_PaybackPeriod","v":2023},null,null,null,"Costs to offset difference","Correction for maintenance"]
[null,"Existing policies",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDEX($R50:$AK50, MATCH(R$54, $R$49:$AK$49, 0))","v":0},"<- elec cost",{"$f":"INDEX($R24:$AK24, MATCH(R$54, $R$49:$AK$49, 0))","v":{"$error":"#N/A"}},"<- fuel costs",{"$f":"T55-R55","v":{"$error":"#N/A"}},{"$f":"V55/(1+$R$29*n_PaybackPeriod)","v":{"$error":"#N/A"}},null,null,{"$f":"ROUND(MIN($W$55:$W$57),-3)","v":{"$error":"#N/A"}},{"$f":"\"£\"&Z55/1000&\"k\"","v":{"$error":"#N/A"}}]
[null,"Low price scenario",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDEX($R51:$AK51, MATCH(R$54, $R$49:$AK$49, 0))","v":0},null,{"$f":"INDEX($R25:$AK25, MATCH(R$54, $R$49:$AK$49, 0))","v":{"$error":"#N/A"}},null,{"$f":"T56-R56","v":{"$error":"#N/A"}},{"$f":"V56/(1+$R$29*n_PaybackPeriod)","v":{"$error":"#N/A"}},null,null,{"$f":"ROUND(MAX($W$55:$W$57),-3)","v":{"$error":"#N/A"}},{"$f":"\"£\"&Z56/1000&\"k\"","v":{"$error":"#N/A"}}]
[null,"High price scenario",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDEX($R52:$AK52, MATCH(R$54, $R$49:$AK$49, 0))","v":0},null,{"$f":"INDEX($R26:$AK26, MATCH(R$54, $R$49:$AK$49, 0))","v":{"$error":"#N/A"}},null,{"$error":"#N/A"},{"$f":"V57/(1+$R$29*n_PaybackPeriod)","v":{"$error":"#N/A"}}]
[]
[null,"Existing policies",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(R50, IF(R49<PriceVolatility_2!n_Timestamp, 0, $Z$55))","v":0},{"$f":"SUM(S50, IF(S49<PriceVolatility_2!n_Timestamp, 0, $Z$55))","v":0},{"$f":"SUM(T50, IF(T49<PriceVolatility_2!n_Timestamp, 0, $Z$55))","v":0},{"$f":"SUM(U50, IF(U49<PriceVolatility_2!n_Timestamp, 0, $Z$55))","v":{"$error":"#N/A"}},{"$f":"SUM(V50, IF(V49<PriceVolatility_2!n_Timestamp, 0, $Z$55))","v":{"$error":"#N/A"}},{"$f":"SUM(W50, IF(W49<PriceVolatility_2!n_Timestamp, 0, $Z$55))","v":{"$error":"#N/A"}},{"$f":"SUM(X50, IF(X49<PriceVolatility_2!n_Timestamp, 0, $Z$55))","v":{"$error":"#N/A"}},{"$f":"SUM(Y50, IF(Y49<PriceVolatility_2!n_Timestamp, 0, $Z$55))","v":{"$error":"#N/A"}},{"$f":"SUM(Z50, IF(Z49<PriceVolatility_2!n_Timestamp, 0, $Z$55))","v":{"$error":"#N/A"}},{"$f":"SUM(AA50, IF(AA49<PriceVolatility_2!n_Timestamp, 0, $Z$55))","v":{"$error":"#N/A"}},{"$f":"SUM(AB50, IF(AB49<PriceVolatility_2!n_Timestamp, 0, $Z$55))","v":{"$error":"#N/A"}},{"$f":"SUM(AC50, IF(AC49<PriceVolatility_2!n_Timestamp, 0, $Z$55))","v":{"$error":"#N/A"}},{"$f":"SUM(AD50, IF(AD49<PriceVolatility_2!n_Timestamp, 0, $Z$55))","v":{"$error":"#N/A"}},{"$f":"SUM(AE50, IF(AE49<PriceVolatility_2!n_Timestamp, 0, $Z$55))","v":{"$error":"#N/A"}},{"$f":"SUM(AF50, IF(AF49<PriceVolatility_2!n_Timestamp, 0, $Z$55))","v":{"$error":"#N/A"}},{"$f":"SUM(AG50, IF(AG49<PriceVolatility_2!n_Timestamp, 0, $Z$55))","v":{"$error":"#N/A"}},{"$f":"SUM(AH50, IF(AH49<PriceVolatility_2!n_Timestamp, 0, $Z$55))","v":{"$error":"#N/A"}},{"$f":"SUM(AI50, IF(AI49<PriceVolatility_2!n_Timestamp, 0, $Z$55))","v":{"$error":"#N/A"}},{"$f":"SUM(AJ50, IF(AJ49<PriceVolatility_2!n_Timestamp, 0, $Z$55))","v":{"$error":"#N/A"}},{"$f":"SUM(AK50, IF(AK49<PriceVolatility_2!n_Timestamp, 0, $Z$55))","v":{"$error":"#N/A"}}]
[]
[null,"Carbon emissions from electricity production"]
[null,"(£/t CO2)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"<- carbon price from ETS - not price of electricity but will be related"]
[null,"Existing policies",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,22.2,22,21.7,21.5,21.9,22.1,22.4,22.6,22.8,23.1,23.6,32.200000000000003,38.1,42.4,49,59.4,69.900000000000006,80.3,90.7,101.1]
[null,"Low price scenario",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,22.2,22,21.7,21.5,21.9,22.1,22.4,22.6,22.8,23.1,23.6,32.200000000000003,38.1,42.4,49,59.4,69.900000000000006,80.3,90.7,101.1]
[null,"High price scenario",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,22.2,22,21.7,21.5,21.9,22.1,22.4,22.6,22.8,23.1,23.6,32.200000000000003,38.1,42.4,49,59.4,69.900000000000006,80.3,90.7,101.1]
[]
[null,"£/t CO2e",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"R63/$V$63 * $V$67","v":407.02877644167762},403.3618505277887,397.86146165695516,{"$f":"U63/$V$63 * $V$67","v":394.19453574306618},{"$f":"AM71","v":401.52838757084413},{"$f":"W63/$V$63 * $V$67","v":405.19531348473316},410.6957023555666,414.36262826945563,418.02955418334466,423.52994305417815,432.69725783890061,590.37507213612707,698.54938659585218,777.38829374446539,898.39684890280205,1089.0769964250294,1281.5906069042012,1472.2707544264285,1662.9509019486561,1853.6310494708832,null,{"$f":"0.28307","v":0.28306999999999999},"kg CO2e/kWh","<- Defra conversion factors"]
[null,"CO2 emissions from electricity",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"PriceVolatility!AM75","v":11.366064066967883},"p/kWh"]
[null,"Existing policies",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(R45/R$67, \"n/a\")","v":0},{"$f":"IFERROR(S45/S$67, \"n/a\")","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"AM68/AM67","v":40.15283875708441},"p/kg CO2e"]
[null,"Low price scenario",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(R46/R$67, \"n/a\")","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"AM69*10^3","v":40152.838757084413},"p/t CO2e"]
[null,"High price scenario",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(R47/R$67, \"n/a\")","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"AM70/100","v":401.52838757084413},"£/t CO2e"]
[]
[null,"CO2 emissions from fuel",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2016,2017,2018,2019,2020,2021,2022,2023,2024,2025,2026,2027,2028,2029,2030,2031,2032,2033,2034,2035]
[null,"Fuel",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(R$73<n_Timestamp, \"n/a\", n_AnnualFC*INDEX(a_CEF, MATCH(n_Fuel, a_FuelType, 0))*10^-3)","v":"n/a"},"n/a","n/a",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,"SAVINGS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(SUM(R74, -R69), \"n/a\")","v":0},{"$f":"IFERROR(SUM(S74, -S69), \"n/a\")","v":0},0,"n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a"]

{"sheet":"GraphPrep","index":7,"n_rows":122,"n_cols":16,"rows_kept":122,"cut":false,"hidden":true,"merged":[]}
[null,{"$f":"Results!$K$8","v":"Existing policies"},{"$f":"Results!$K$9","v":"Existing policies"}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Electricity price scenario","(All)"]
[null,"Fuel price","Electricity price scenario","Year","Fuel costs","Shore-side costs","Colouring1","Colouring2","Colouring3","COLOURINGACTUAL","COLOURINGACTUAL"]
[null,"Existing policies",{"$f":"$C$1","v":"Existing policies"},{"$f":"n_Timestamp","v":2019},{"$f":"VLOOKUP(GraphPrep!$B4, PriceVolatility!$B$23:$AK$26, MATCH(GraphPrep!$D4, PriceVolatility!$B$23:$AK$23, 0), 0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($C4, PriceVolatility!$B$54:$AK$57, MATCH(GraphPrep!$D4, PriceVolatility!$B$54:$AK$54, 0), 0)","v":135000},{"$f":"MIN(E4,F4)","v":{"$error":"#N/A"}},{"$f":"IF(E4>F4, E4, 0)","v":{"$error":"#N/A"}},{"$f":"IF(H4=0, F4, 0)","v":{"$error":"#N/A"}},{"$f":"IF(AND(H4=0, H5>0), I4, H4)","v":{"$error":"#N/A"}},{"$f":"IF(AND(I4=0, I3>0), H4, I4)","v":{"$error":"#N/A"}},null,"Row Labels","Sum of Fuel costs","Sum of Shore-side costs","Sum of Colouring1"]
[null,"Existing policies","Existing policies",{"$f":"D4+1","v":2020},{"$f":"VLOOKUP(GraphPrep!$B5, PriceVolatility!$B$23:$AK$26, MATCH(GraphPrep!$D5, PriceVolatility!$B$23:$AK$23, 0), 0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($C5, PriceVolatility!$B$54:$AK$57, MATCH(GraphPrep!$D5, PriceVolatility!$B$54:$AK$54, 0), 0)","v":145000},{"$f":"MIN(E5,F5)","v":{"$error":"#N/A"}},{"$f":"IF(E5>F5, E5, 0)","v":{"$error":"#N/A"}},{"$f":"IF(H5=0, F5, 0)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$f":"IF(AND(I5=0, I4>0), H5, I5)","v":{"$error":"#N/A"}},null,2019,8577.8343750000004,139103,8577.8343750000004]
[null,"Existing policies","Existing policies",{"$f":"D5+1","v":2021},{"$f":"VLOOKUP(GraphPrep!$B6, PriceVolatility!$B$23:$AK$26, MATCH(GraphPrep!$D6, PriceVolatility!$B$23:$AK$23, 0), 0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($C6, PriceVolatility!$B$54:$AK$57, MATCH(GraphPrep!$D6, PriceVolatility!$B$54:$AK$54, 0), 0)","v":155000},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,2020,17524.625065912915,153333.3184269616,17524.625065912915]
[null,"Existing policies","Existing policies",2022,{"$f":"VLOOKUP(GraphPrep!$B7, PriceVolatility!$B$23:$AK$26, MATCH(GraphPrep!$D7, PriceVolatility!$B$23:$AK$23, 0), 0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($C7, PriceVolatility!$B$54:$AK$57, MATCH(GraphPrep!$D7, PriceVolatility!$B$54:$AK$54, 0), 0)","v":165000},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,2021,26834.050531477704,167668.59764833871,26834.050531477704]
[null,"Existing policies","Existing policies",2023,{"$f":"VLOOKUP(GraphPrep!$B8, PriceVolatility!$B$23:$AK$26, MATCH(GraphPrep!$D8, PriceVolatility!$B$23:$AK$23, 0), 0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($C8, PriceVolatility!$B$54:$AK$57, MATCH(GraphPrep!$D8, PriceVolatility!$B$54:$AK$54, 0), 0)","v":175000},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,2022,36388.383969586226,181985.39843254504,36388.383969586226]
[null,"Existing policies","Existing policies",2024,{"$f":"VLOOKUP(GraphPrep!$B9, PriceVolatility!$B$23:$AK$26, MATCH(GraphPrep!$D9, PriceVolatility!$B$23:$AK$23, 0), 0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($C9, PriceVolatility!$B$54:$AK$57, MATCH(GraphPrep!$D9, PriceVolatility!$B$54:$AK$54, 0), 0)","v":185000},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(AND(H9=0, H10>0), I9, H9)","v":{"$error":"#N/A"}},{"$error":"#N/A"},null,2023,46295.60719322689,196359.57307111446,46295.60719322689]
[null,"Existing policies","Existing policies",2025,{"$f":"VLOOKUP(GraphPrep!$B10, PriceVolatility!$B$23:$AK$26, MATCH(GraphPrep!$D10, PriceVolatility!$B$23:$AK$23, 0), 0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($C10, PriceVolatility!$B$54:$AK$57, MATCH(GraphPrep!$D10, PriceVolatility!$B$54:$AK$54, 0), 0)","v":195000},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(AND(H10=0, H11>0), I10, H10)","v":{"$error":"#N/A"}},{"$error":"#N/A"},null,2024,56554.10658616641,210846.09431310292,56554.10658616641]
[null,"Existing policies","Existing policies",2026,{"$f":"VLOOKUP(GraphPrep!$B11, PriceVolatility!$B$23:$AK$26, MATCH(GraphPrep!$D11, PriceVolatility!$B$23:$AK$23, 0), 0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($C11, PriceVolatility!$B$54:$AK$57, MATCH(GraphPrep!$D11, PriceVolatility!$B$54:$AK$54, 0), 0)","v":205000},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,2025,67164.00949726034,225582.8156553249,67164.00949726034]
[null,"Existing policies","Existing policies",2027,{"$f":"VLOOKUP(GraphPrep!$B12, PriceVolatility!$B$23:$AK$26, MATCH(GraphPrep!$D12, PriceVolatility!$B$23:$AK$23, 0), 0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($C12, PriceVolatility!$B$54:$AK$57, MATCH(GraphPrep!$D12, PriceVolatility!$B$54:$AK$54, 0), 0)","v":215000},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,2026,78014.555798866131,240398.36865913312,78014.555798866131]
[null,"Existing policies","Existing policies",2028,{"$f":"VLOOKUP(GraphPrep!$B13, PriceVolatility!$B$23:$AK$26, MATCH(GraphPrep!$D13, PriceVolatility!$B$23:$AK$23, 0), 0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($C13, PriceVolatility!$B$54:$AK$57, MATCH(GraphPrep!$D13, PriceVolatility!$B$54:$AK$54, 0), 0)","v":225000},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,2027,89216.762936499494,255100.79820440584,89216.762936499494]
[null,"Existing policies","Existing policies",2029,{"$f":"VLOOKUP(GraphPrep!$B14, PriceVolatility!$B$23:$AK$26, MATCH(GraphPrep!$D14, PriceVolatility!$B$23:$AK$23, 0), 0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($C14, PriceVolatility!$B$54:$AK$57, MATCH(GraphPrep!$D14, PriceVolatility!$B$54:$AK$54, 0), 0)","v":235000},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,2028,100770.76089114413,270029.333248729,100770.76089114413]
[null,"Existing policies","Existing policies",2030,{"$f":"VLOOKUP(GraphPrep!$B15, PriceVolatility!$B$23:$AK$26, MATCH(GraphPrep!$D15, PriceVolatility!$B$23:$AK$23, 0), 0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($C15, PriceVolatility!$B$54:$AK$57, MATCH(GraphPrep!$D15, PriceVolatility!$B$54:$AK$54, 0), 0)","v":245000},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,2029,112565.79218529629,285130.82097160578,112565.79218529629]
[null,"Existing policies","Existing policies",2031,{"$f":"VLOOKUP(GraphPrep!$B16, PriceVolatility!$B$23:$AK$26, MATCH(GraphPrep!$D16, PriceVolatility!$B$23:$AK$23, 0), 0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($C16, PriceVolatility!$B$54:$AK$57, MATCH(GraphPrep!$D16, PriceVolatility!$B$54:$AK$54, 0), 0)","v":255000},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,2030,124712.87693274439,300276.66498986073,124712.87693274439]
[null,"Existing policies","Existing policies",2032,{"$f":"VLOOKUP(GraphPrep!$B17, PriceVolatility!$B$23:$AK$26, MATCH(GraphPrep!$D17, PriceVolatility!$B$23:$AK$23, 0), 0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($C17, PriceVolatility!$B$54:$AK$57, MATCH(GraphPrep!$D17, PriceVolatility!$B$54:$AK$54, 0), 0)","v":265000},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,2031,136879.4827573091,315509.17119608703,136879.4827573091]
[null,"Existing policies","Existing policies",2033,{"$f":"VLOOKUP(GraphPrep!$B18, PriceVolatility!$B$23:$AK$26, MATCH(GraphPrep!$D18, PriceVolatility!$B$23:$AK$23, 0), 0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($C18, PriceVolatility!$B$54:$AK$57, MATCH(GraphPrep!$D18, PriceVolatility!$B$54:$AK$54, 0), 0)","v":275000},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,2032,149065.74323429813,330832.37954856129,149065.74323429813]
[null,"Existing policies","Existing policies",2034,{"$f":"VLOOKUP(GraphPrep!$B19, PriceVolatility!$B$23:$AK$26, MATCH(GraphPrep!$D19, PriceVolatility!$B$23:$AK$23, 0), 0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($C19, PriceVolatility!$B$54:$AK$57, MATCH(GraphPrep!$D19, PriceVolatility!$B$54:$AK$54, 0), 0)","v":285000},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,2033,161271.79285302429,346333.45368903421,161271.79285302429]
[null,"Existing policies","Existing policies",2035,{"$f":"VLOOKUP(GraphPrep!$B20, PriceVolatility!$B$23:$AK$26, MATCH(GraphPrep!$D20, PriceVolatility!$B$23:$AK$23, 0), 0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($C20, PriceVolatility!$B$54:$AK$57, MATCH(GraphPrep!$D20, PriceVolatility!$B$54:$AK$54, 0), 0)","v":295000},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,2034,173497.76702305957,361916.23824693001,173497.76702305957]
[null,null,null,null,null,null,null,null,null,null,null,null,2035,185743.80208053219,377630.86112203239,185743.80208053219]
[null,null,null,null,null,null,null,null,null,null,null,null,"Grand Total",1571077.9539114041,4358036.8874237668,1571077.9539114041]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"High price scenario",{"$f":"$C$1","v":"Existing policies"},{"$f":"D113+1","v":1},{"$f":"VLOOKUP(GraphPrep!$B122, PriceVolatility!$B$23:$AK$26, MATCH(GraphPrep!$D122, PriceVolatility!$B$23:$AK$23, 0), 0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($C122, PriceVolatility!$B$54:$AK$57, MATCH(GraphPrep!$D122, PriceVolatility!$B$54:$AK$54, 0), 0)","v":{"$error":"#N/A"}},{"$f":"MIN(E122,F122)","v":{"$error":"#N/A"}},{"$f":"IF(E122>F122, E122, 0)","v":{"$error":"#N/A"}},{"$f":"IF(H122=0, F122, 0)","v":{"$error":"#N/A"}}]

{"sheet":"GraphPrep_2","index":8,"n_rows":22,"n_cols":16,"rows_kept":22,"cut":false,"hidden":true,"merged":[]}
[null,{"$f":"Results_2!$K$8","v":"Existing policies"},{"$f":"Results_2!$K$9","v":"Existing policies"},null,null,null,null,null,null,null,null,null,"Fuel price","(All)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Electricity price scenario","(All)"]
[null,"Fuel price","Electricity price scenario","Year","Fuel costs","Shore-side costs","Colouring1","Colouring2","Colouring3","COLOURINGACTUAL","COLOURINGACTUAL"]
[null,"Existing policies",{"$f":"$C$1","v":"Existing policies"},{"$f":"n_Timestamp","v":2019},{"$f":"VLOOKUP(GraphPrep_2!$B4, PriceVolatility_2!$B$23:$AK$26, MATCH(GraphPrep_2!$D4, PriceVolatility_2!$B$23:$AK$23, 0), 0)","v":{"$error":"#N/A"}},{"$f":"INDEX(PriceVolatility_2!$W$55:$W$57,MATCH(GraphPrep_2!C4,PriceVolatility_2!$B$55:$B$57,0))*(1+PriceVolatility_2!$R$29 * [0]!n_PaybackPeriod)+VLOOKUP(GraphPrep_2!$C4, PriceVolatility_2!$B$49:$AK$52, MATCH(GraphPrep_2!$D4, PriceVolatility_2!$B$44:$AK$44, 0), FALSE)","v":{"$error":"#N/A"}},{"$f":"MIN(E4,F4)","v":{"$error":"#N/A"}},{"$f":"IF(H5>0, G4, IF(E4>F4, E4, 0))","v":{"$error":"#N/A"}},{"$f":"IF(H4=0, F4, 0)","v":{"$error":"#N/A"}},{"$f":"IF(AND(H4=0, H5>0), I4, H4)","v":{"$error":"#N/A"}},{"$f":"IF(AND(I4=0, I3>0), H4, I4)","v":{"$error":"#N/A"}},null,"Row Labels","Sum of Fuel costs","Sum of Shore-side costs","Sum of Colouring1"]
[null,"Existing policies","Existing policies",{"$f":"D4+1","v":2020},{"$f":"VLOOKUP(GraphPrep_2!$B5, PriceVolatility_2!$B$23:$AK$26, MATCH(GraphPrep_2!$D5, PriceVolatility_2!$B$23:$AK$23, 0), 0)","v":{"$error":"#N/A"}},{"$f":"INDEX(PriceVolatility_2!$W$55:$W$57,MATCH(GraphPrep_2!C5,PriceVolatility_2!$B$55:$B$57,0))*(1+PriceVolatility_2!$R$29 * [0]!n_PaybackPeriod)+VLOOKUP(GraphPrep_2!$C5, PriceVolatility_2!$B$49:$AK$52, MATCH(GraphPrep_2!$D5, PriceVolatility_2!$B$44:$AK$44, 0), FALSE)","v":{"$error":"#N/A"}},{"$f":"MIN(E5,F5)","v":{"$error":"#N/A"}},{"$f":"IF(H6>0, G5, IF(E5>F5, E5, 0))","v":{"$error":"#N/A"}},{"$f":"IF(H5=0, F5, 0)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$f":"IF(AND(I5=0, I4>0), H5, I5)","v":{"$error":"#N/A"}},null,2019,60294.867187499993,312245.1292593893,60294.867187499993]
[null,"Existing policies","Existing policies",{"$f":"D5+1","v":2021},{"$f":"VLOOKUP(GraphPrep_2!$B6, PriceVolatility_2!$B$23:$AK$26, MATCH(GraphPrep_2!$D6, PriceVolatility_2!$B$23:$AK$23, 0), 0)","v":{"$error":"#N/A"}},{"$f":"INDEX(PriceVolatility_2!$W$55:$W$57,MATCH(GraphPrep_2!C6,PriceVolatility_2!$B$55:$B$57,0))*(1+PriceVolatility_2!$R$29 * [0]!n_PaybackPeriod)+VLOOKUP(GraphPrep_2!$C6, PriceVolatility_2!$B$49:$AK$52, MATCH(GraphPrep_2!$D6, PriceVolatility_2!$B$44:$AK$44, 0), FALSE)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$f":"IF(H7>0, G6, IF(E6>F6, E6, 0))","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,2020,123183.18291846856,315474.52412997157,123183.18291846856]
[null,"Existing policies","Existing policies",2022,{"$f":"VLOOKUP(GraphPrep_2!$B7, PriceVolatility_2!$B$23:$AK$26, MATCH(GraphPrep_2!$D7, PriceVolatility_2!$B$23:$AK$23, 0), 0)","v":{"$error":"#N/A"}},{"$f":"INDEX(PriceVolatility_2!$W$55:$W$57,MATCH(GraphPrep_2!C7,PriceVolatility_2!$B$55:$B$57,0))*(1+PriceVolatility_2!$R$29 * [0]!n_PaybackPeriod)+VLOOKUP(GraphPrep_2!$C7, PriceVolatility_2!$B$49:$AK$52, MATCH(GraphPrep_2!$D7, PriceVolatility_2!$B$44:$AK$44, 0), FALSE)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$f":"IF(H8>0, G7, IF(E7>F7, E7, 0))","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,2021,188620.51214390717,318784.04532129073,188620.51214390717]
[null,"Existing policies","Existing policies",2023,{"$f":"VLOOKUP(GraphPrep_2!$B8, PriceVolatility_2!$B$23:$AK$26, MATCH(GraphPrep_2!$D8, PriceVolatility_2!$B$23:$AK$23, 0), 0)","v":{"$error":"#N/A"}},{"$f":"INDEX(PriceVolatility_2!$W$55:$W$57,MATCH(GraphPrep_2!C8,PriceVolatility_2!$B$55:$B$57,0))*(1+PriceVolatility_2!$R$29 * [0]!n_PaybackPeriod)+VLOOKUP(GraphPrep_2!$C8, PriceVolatility_2!$B$49:$AK$52, MATCH(GraphPrep_2!$D8, PriceVolatility_2!$B$44:$AK$44, 0), FALSE)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$f":"IF(H9>0, G8, IF(E8>F8, E8, 0))","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,2022,255779.33575034261,322079.46020566253,255779.33575034261]
[null,"Existing policies","Existing policies",2024,{"$f":"VLOOKUP(GraphPrep_2!$B9, PriceVolatility_2!$B$23:$AK$26, MATCH(GraphPrep_2!$D9, PriceVolatility_2!$B$23:$AK$23, 0), 0)","v":{"$error":"#N/A"}},{"$f":"INDEX(PriceVolatility_2!$W$55:$W$57,MATCH(GraphPrep_2!C9,PriceVolatility_2!$B$55:$B$57,0))*(1+PriceVolatility_2!$R$29 * [0]!n_PaybackPeriod)+VLOOKUP(GraphPrep_2!$C9, PriceVolatility_2!$B$49:$AK$52, MATCH(GraphPrep_2!$D9, PriceVolatility_2!$B$44:$AK$44, 0), FALSE)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$f":"IF(E9>F9, E9, 0)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$f":"IF(AND(H9=0, H10>0), I9, H9)","v":{"$error":"#N/A"}},{"$error":"#N/A"},null,2023,325418.67388064187,325418.67388064187,325418.67388064187]
[null,"Existing policies","Existing policies",2025,{"$f":"VLOOKUP(GraphPrep_2!$B10, PriceVolatility_2!$B$23:$AK$26, MATCH(GraphPrep_2!$D10, PriceVolatility_2!$B$23:$AK$23, 0), 0)","v":{"$error":"#N/A"}},{"$f":"INDEX(PriceVolatility_2!$W$55:$W$57,MATCH(GraphPrep_2!C10,PriceVolatility_2!$B$55:$B$57,0))*(1+PriceVolatility_2!$R$29 * [0]!n_PaybackPeriod)+VLOOKUP(GraphPrep_2!$C10, PriceVolatility_2!$B$49:$AK$52, MATCH(GraphPrep_2!$D10, PriceVolatility_2!$B$44:$AK$44, 0), FALSE)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$f":"IF(E10>F10, E10, 0)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$f":"IF(AND(H10=0, H11>0), I10, H10)","v":{"$error":"#N/A"}},{"$error":"#N/A"},null,2024,397527.18418751494,328843.65215019556,328843.65215019556]
[null,"Existing policies","Existing policies",2026,{"$f":"VLOOKUP(GraphPrep_2!$B11, PriceVolatility_2!$B$23:$AK$26, MATCH(GraphPrep_2!$D11, PriceVolatility_2!$B$23:$AK$23, 0), 0)","v":{"$error":"#N/A"}},{"$f":"INDEX(PriceVolatility_2!$W$55:$W$57,MATCH(GraphPrep_2!C11,PriceVolatility_2!$B$55:$B$57,0))*(1+PriceVolatility_2!$R$29 * [0]!n_PaybackPeriod)+VLOOKUP(GraphPrep_2!$C11, PriceVolatility_2!$B$49:$AK$52, MATCH(GraphPrep_2!$D11, PriceVolatility_2!$B$44:$AK$44, 0), FALSE)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,2025,472105.76182491286,332459.63138912391,332459.63138912391]
[null,"Existing policies","Existing policies",2027,{"$f":"VLOOKUP(GraphPrep_2!$B12, PriceVolatility_2!$B$23:$AK$26, MATCH(GraphPrep_2!$D12, PriceVolatility_2!$B$23:$AK$23, 0), 0)","v":{"$error":"#N/A"}},{"$f":"INDEX(PriceVolatility_2!$W$55:$W$57,MATCH(GraphPrep_2!C12,PriceVolatility_2!$B$55:$B$57,0))*(1+PriceVolatility_2!$R$29 * [0]!n_PaybackPeriod)+VLOOKUP(GraphPrep_2!$C12, PriceVolatility_2!$B$49:$AK$52, MATCH(GraphPrep_2!$D12, PriceVolatility_2!$B$44:$AK$44, 0), FALSE)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,2026,548375.85746512399,336135.79015542392,336135.79015542392]
[null,"Existing policies","Existing policies",2028,{"$f":"VLOOKUP(GraphPrep_2!$B13, PriceVolatility_2!$B$23:$AK$26, MATCH(GraphPrep_2!$D13, PriceVolatility_2!$B$23:$AK$23, 0), 0)","v":{"$error":"#N/A"}},{"$f":"INDEX(PriceVolatility_2!$W$55:$W$57,MATCH(GraphPrep_2!C13,PriceVolatility_2!$B$55:$B$57,0))*(1+PriceVolatility_2!$R$29 * [0]!n_PaybackPeriod)+VLOOKUP(GraphPrep_2!$C13, PriceVolatility_2!$B$49:$AK$52, MATCH(GraphPrep_2!$D13, PriceVolatility_2!$B$44:$AK$44, 0), FALSE)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,2027,627117.82916126878,339725.59128150268,339725.59128150268]
[null,"Existing policies","Existing policies",2029,{"$f":"VLOOKUP(GraphPrep_2!$B14, PriceVolatility_2!$B$23:$AK$26, MATCH(GraphPrep_2!$D14, PriceVolatility_2!$B$23:$AK$23, 0), 0)","v":{"$error":"#N/A"}},{"$f":"INDEX(PriceVolatility_2!$W$55:$W$57,MATCH(GraphPrep_2!C14,PriceVolatility_2!$B$55:$B$57,0))*(1+PriceVolatility_2!$R$29 * [0]!n_PaybackPeriod)+VLOOKUP(GraphPrep_2!$C14, PriceVolatility_2!$B$49:$AK$52, MATCH(GraphPrep_2!$D14, PriceVolatility_2!$B$44:$AK$44, 0), FALSE)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,2028,708332.59056891664,343487.99973051721,343487.99973051721]
[null,"Existing policies","Existing policies",2030,{"$f":"VLOOKUP(GraphPrep_2!$B15, PriceVolatility_2!$B$23:$AK$26, MATCH(GraphPrep_2!$D15, PriceVolatility_2!$B$23:$AK$23, 0), 0)","v":{"$error":"#N/A"}},{"$f":"INDEX(PriceVolatility_2!$W$55:$W$57,MATCH(GraphPrep_2!C15,PriceVolatility_2!$B$55:$B$57,0))*(1+PriceVolatility_2!$R$29 * [0]!n_PaybackPeriod)+VLOOKUP(GraphPrep_2!$C15, PriceVolatility_2!$B$49:$AK$52, MATCH(GraphPrep_2!$D15, PriceVolatility_2!$B$44:$AK$44, 0), FALSE)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,2029,791241.61098857364,347382.43901896331,347382.43901896331]
[null,"Existing policies","Existing policies",2031,{"$f":"VLOOKUP(GraphPrep_2!$B16, PriceVolatility_2!$B$23:$AK$26, MATCH(GraphPrep_2!$D16, PriceVolatility_2!$B$23:$AK$23, 0), 0)","v":{"$error":"#N/A"}},{"$f":"INDEX(PriceVolatility_2!$W$55:$W$57,MATCH(GraphPrep_2!C16,PriceVolatility_2!$B$55:$B$57,0))*(1+PriceVolatility_2!$R$29 * [0]!n_PaybackPeriod)+VLOOKUP(GraphPrep_2!$C16, PriceVolatility_2!$B$49:$AK$52, MATCH(GraphPrep_2!$D16, PriceVolatility_2!$B$44:$AK$44, 0), FALSE)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,2030,876625.267229044,351310.73958647047,351310.73958647047]
[null,"Existing policies","Existing policies",2032,{"$f":"VLOOKUP(GraphPrep_2!$B17, PriceVolatility_2!$B$23:$AK$26, MATCH(GraphPrep_2!$D17, PriceVolatility_2!$B$23:$AK$23, 0), 0)","v":{"$error":"#N/A"}},{"$f":"INDEX(PriceVolatility_2!$W$55:$W$57,MATCH(GraphPrep_2!C17,PriceVolatility_2!$B$55:$B$57,0))*(1+PriceVolatility_2!$R$29 * [0]!n_PaybackPeriod)+VLOOKUP(GraphPrep_2!$C17, PriceVolatility_2!$B$49:$AK$52, MATCH(GraphPrep_2!$D17, PriceVolatility_2!$B$44:$AK$44, 0), FALSE)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,2031,962146.14000933617,355305.19744925934,355305.19744925934]
[null,"Existing policies","Existing policies",2033,{"$f":"VLOOKUP(GraphPrep_2!$B18, PriceVolatility_2!$B$23:$AK$26, MATCH(GraphPrep_2!$D18, PriceVolatility_2!$B$23:$AK$23, 0), 0)","v":{"$error":"#N/A"}},{"$f":"INDEX(PriceVolatility_2!$W$55:$W$57,MATCH(GraphPrep_2!C18,PriceVolatility_2!$B$55:$B$57,0))*(1+PriceVolatility_2!$R$29 * [0]!n_PaybackPeriod)+VLOOKUP(GraphPrep_2!$C18, PriceVolatility_2!$B$49:$AK$52, MATCH(GraphPrep_2!$D18, PriceVolatility_2!$B$44:$AK$44, 0), FALSE)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,2032,1047805.1682500552,359368.89668262133,359368.89668262133]
[null,"Existing policies","Existing policies",2034,{"$f":"VLOOKUP(GraphPrep_2!$B19, PriceVolatility_2!$B$23:$AK$26, MATCH(GraphPrep_2!$D19, PriceVolatility_2!$B$23:$AK$23, 0), 0)","v":{"$error":"#N/A"}},{"$f":"INDEX(PriceVolatility_2!$W$55:$W$57,MATCH(GraphPrep_2!C19,PriceVolatility_2!$B$55:$B$57,0))*(1+PriceVolatility_2!$R$29 * [0]!n_PaybackPeriod)+VLOOKUP(GraphPrep_2!$C19, PriceVolatility_2!$B$49:$AK$52, MATCH(GraphPrep_2!$D19, PriceVolatility_2!$B$44:$AK$44, 0), FALSE)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,2033,1133603.2972964824,363568.37738807162,363568.37738807162]
[null,"Existing policies","Existing policies",2035,{"$f":"VLOOKUP(GraphPrep_2!$B20, PriceVolatility_2!$B$23:$AK$26, MATCH(GraphPrep_2!$D20, PriceVolatility_2!$B$23:$AK$23, 0), 0)","v":{"$error":"#N/A"}},{"$f":"INDEX(PriceVolatility_2!$W$55:$W$57,MATCH(GraphPrep_2!C20,PriceVolatility_2!$B$55:$B$57,0))*(1+PriceVolatility_2!$R$29 * [0]!n_PaybackPeriod)+VLOOKUP(GraphPrep_2!$C20, PriceVolatility_2!$B$49:$AK$52, MATCH(GraphPrep_2!$D20, PriceVolatility_2!$B$44:$AK$44, 0), FALSE)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,2034,1219541.4789625376,367830.23524253676,367830.23524253676]
[null,null,null,null,null,null,null,null,null,null,null,null,2035,1305620.6715750413,372192.73752665508,372192.73752665508]
[null,null,null,null,null,null,null,null,null,null,null,null,"Grand Total",11043339.429399667,5791613.120398296,5150907.8594822008]

{"sheet":"Lists","index":9,"n_rows":29,"n_cols":13,"rows_kept":29,"cut":false,"hidden":true,"merged":[]}
[]
[null,null,null,null,null,null,null,null,"a_SFC"]
[null,"a_FuelType","a_FuelDensity","a_CEF","a_SO2EF","a_Choice","a_EngineType","Marine diesel","Marine gas oil","Low-sulphur heavy fuel oil","a_FuelUnits","a_Multiplier","a_PriceScenario"]
[null,"<please select>",null,null,null,"<please select>","<please select>",null,null,null,"kg",1000,"<please select>"]
[null,"Marine diesel",1171,{"$f":"864*44/12","v":3168},1.4999999999999999E-2,"Use model defaults","Gas Turbine",319,319,336,"tonne",1,"Existing policies"]
[null,"Marine gas oil",1171,{"$f":"864*44/12","v":3168},1.6E-2,"Enter manually","High-speed",223,223,234,"litre",{"$f":"INDEX(a_FuelDensity, MATCH(n_Fuel, a_FuelType, 0))","v":0},"Low price scenario"]
[null,"Low-sulphur heavy fuel oil",1012,{"$f":"849*44/12","v":3113},27,null,"Medium-speed",223,223,234,null,null,"High price scenario"]
[null,null,null,null,null,null,"Slow-speed",204,204,215]
[null,null,null,null,null,null,"Steam turbine",319,319,336]
[]
[]
[]
[null,"EmissionFactors"]
[null,"Lookup",null,null,"NOx (kg/tonne)","PM10 (kg/tonne)","PM2.5 (kg/tonne)"]
[null,{"$f":"C15&\"_\"&D15","v":"Gas Turbine_Marine diesel"},{"$f":"G5","v":"Gas Turbine"},"Marine diesel",18.3,0,0]
[null,{"$f":"C16&\"_\"&D16","v":"Gas Turbine_Marine gas oil"},{"$f":"C15","v":"Gas Turbine"},"Marine gas oil",{"$f":"E15","v":18.3},0,0]
[null,"Gas Turbine_Low-sulphur heavy fuel oil",{"$f":"C16","v":"Gas Turbine"},"Low-sulphur heavy fuel oil",18.600000000000001,0.3,0.3]
[null,"High-speed_Marine diesel",{"$f":"G6","v":"High-speed"},"Marine diesel",55.1,1.5,1.3]
[null,"High-speed_Marine gas oil",{"$f":"C18","v":"High-speed"},"Marine gas oil",55.1,1.5,1.3]
[null,"High-speed_Low-sulphur heavy fuel oil",{"$f":"C19","v":"High-speed"},"Low-sulphur heavy fuel oil",55.6,3.8,3.4]
[null,"Medium-speed_Marine diesel",{"$f":"G7","v":"Medium-speed"},"Marine diesel",60.6,1.5,1.3]
[null,"Medium-speed_Marine gas oil",{"$f":"C21","v":"Medium-speed"},"Marine gas oil",60.6,1.5,1.3]
[null,"Medium-speed_Low-sulphur heavy fuel oil",{"$f":"C22","v":"Medium-speed"},"Low-sulphur heavy fuel oil",61.3,3.8,3.4]
[null,"Slow-speed_Marine diesel",{"$f":"G8","v":"Slow-speed"},"Marine diesel",86.5,1.6,1.5]
[null,"Slow-speed_Marine gas oil",{"$f":"C24","v":"Slow-speed"},"Marine gas oil",86.5,1.6,1.5]
[null,"Slow-speed_Low-sulphur heavy fuel oil",{"$f":"C25","v":"Slow-speed"},"Low-sulphur heavy fuel oil",86.5,8.6999999999999993,7.8]
[null,"Steam turbine_Marine diesel",{"$f":"G9","v":"Steam turbine"},"Marine diesel",6.4,1,0.9]
[null,"Steam turbine_Marine gas oil",{"$f":"C27","v":"Steam turbine"},"Marine gas oil",6.4,1,0.9]
[null,"Steam turbine_Low-sulphur heavy fuel oil",{"$f":"C28","v":"Steam turbine"},"Low-sulphur heavy fuel oil",6.4,2.6,2.4]