{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["Index","Input|General","Input|Inflation","Input|Reported opex","Input|Rate of change","Input|Step changes","Calc|Opex forecast","Output|Models","Lookup|Tables","Check|List"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":9,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Index","index":0,"n_rows":17,"n_cols":4,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
[null,"AER opex model"]
[null,"Index"]
[]
[null,"Model index"]
[]
[null,null,"Sheet Name","Sheet Description"]
[null,null,"Input | General","Inputs NSP name, regulatory years for the prior and forecast regulatory control period etc."]
[null,null,"Input | Inflation","Inputs inflation data."]
[null,null,"Input | Reported opex","Inputs the reported operating expenditure (opex) from the prior regulatory control period."]
[null,null,"Input | Rate of change","Inputs the cost escalation weights, cost escalation forecast, and inflation actuals and forecast"]
[null,null,"Input | Step changes","Inputs the operating expenditure (opex) data, including historical opex by category, one-off costs, step changes, demand forecasts, carbon costs, self insurance, network growth, and partial factor productivity"]
[null,null,"Calc | Opex Forecast","Calculates the opex forecast from RY2014 to RY2020"]
[null,null,"Output | Models","Outputs the opex forecast needed as a post tax revenue model input (which excludes debt raising costs)."]
[null,null,"Lookup | Tables","Includes the lookup tables used within this opex model."]
[null,null,"Check | List","Shows checks on the calculations within the model"]
[]
[null,"End"]

{"sheet":"Input|General","index":1,"n_rows":14,"n_cols":22,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
[null,{"$f":"Index!$B$1","v":"AER opex model"},null,null,null,null,null,null,null,"Back to Index",null,"Key:","Input","External Link","Internal Link",null,null,"Worksheet check:",{"$f":"IF(COUNTA($S$5:$S$13)=COUNTIF($S5:$S14,\"OK\"),\"OK\",\"Check\")","v":"OK"},null,"Overall Check:",{"$f":"'Check|List'!$S$1","v":"Ok"}]
[null,{"$f":"Index!$C$7","v":"Input | General"}]
[]
[null,"Input | General inputs"]
[]
[null,null,"Inputs","Source",null,null,"Value"]
[null,null,"NSP name","NSP",null,null,"AusNet Services Tx",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTBLANK($G7),\"Check\",\"Ok\")","v":"Ok"}]
[null,null,"Prior regulatory control period, first year","NSP",null,null,"2014-15",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTBLANK($G8),\"Check\",\"Ok\")","v":"Ok"}]
[null,null,"Forecast base year","NSP",null,null,"2014-15",null,null,null,null,null,null,null,null,null,null,null,"Ok"]
[null,null,"Prior regulatory control period, last year","NSP",null,null,"2016-17",null,null,null,null,null,null,null,null,null,null,null,"Ok"]
[null,null,"Forecast regulatory control period, first year","NSP",null,null,"2017-18",null,null,null,null,null,null,null,null,null,null,null,"Ok"]
[null,null,"Forecast regulatory control period, last year","NSP",null,null,"2021-22",null,null,null,null,null,null,null,null,null,null,null,"Ok"]
[]
[null,"End"]

{"sheet":"Input|Inflation","index":2,"n_rows":52,"n_cols":22,"rows_kept":52,"cut":false,"hidden":false,"merged":[]}
[null,{"$f":"Index!$B$1","v":"AER opex model"},null,null,null,null,null,null,null,"Back to Index",null,"Key:","Input","External Link","Internal Link",null,null,"Worksheet check:",{"$f":"IF(COUNTA($S$5:$S$51)=COUNTIF($S5:$S52,\"OK\"),\"OK\",\"Check\")","v":"OK"},null,"Overall Check:",{"$f":"'Check|List'!$S$1","v":"Ok"}]
[null,{"$f":"Index!$C$7","v":"Input | General"}]
[]
[null,"Input | General inputs"]
[]
[null,null,null,"Index value, old base","Index value, new base"]
[null,null,"Source","ABS","ABS"]
[null,null,"Unit","index","index"]
[null,null,"2007-03-31",155.6,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTBLANK($D9),\"Check\",\"Ok\")","v":"Ok"}]
[null,null,"2007-06-30",157.5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ok"]
[null,null,"2007-09-30",158.6,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ok"]
[null,null,"2007-12-31",160.1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ok"]
[null,null,"2008-03-31",162.19999999999999,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ok"]
[null,null,"2008-06-30",164.6,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ok"]
[null,null,"2008-09-30",166.5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ok"]
[null,null,"2008-12-31",166,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ok"]
[null,null,"2009-03-31",166.2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ok"]
[null,null,"2009-06-30",167,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ok"]
[null,null,"2009-09-30",168.6,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ok"]
[null,null,"2009-12-31",169.5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ok"]
[null,null,"2010-03-31",171,95.2,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTBLANK($D21:$E21),\"Check\",\"Ok\")","v":"Ok"}]
[null,null,"2010-06-30",172.1,95.8,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ok"]
[null,null,"2010-09-30",173.3,96.5,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ok"]
[null,null,"2010-12-31",174,96.9,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ok"]
[null,null,"2011-03-31",176.7,98.3,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ok"]
[null,null,"2011-06-30",178.3,99.2,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ok"]
[null,null,"2011-09-30",179.4,99.8,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ok"]
[null,null,"2011-12-31",179.4,99.8,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ok"]
[null,null,"2012-03-31",179.5,99.9,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTBLANK($E29),\"Check\",\"Ok\")","v":"Ok"}]
[null,null,"2012-06-30",null,100.4,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTBLANK($E30),\"Check\",\"Ok\")","v":"Ok"}]
[null,null,"2012-09-30",null,101.8,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTBLANK($E31),\"Check\",\"Ok\")","v":"Ok"}]
[null,null,"2012-12-31",null,102,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTBLANK($E32),\"Check\",\"Ok\")","v":"Ok"}]
[null,null,"2013-03-31",null,102.4,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTBLANK($E33),\"Check\",\"Ok\")","v":"Ok"}]
[null,null,"2013-06-30",null,102.8,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ok"]
[null,null,"2013-09-30",null,104,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ok"]
[null,null,"2013-12-31",null,104.8,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ok"]
[null,null,"2014-03-31",null,105.4,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ok"]
[null,null,"2014-06-30",null,105.9,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ok"]
[null,null,"2014-09-30",null,106.4,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ok"]
[null,null,"2014-12-31",null,106.6,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ok"]
[null,null,"2015-03-31",null,106.8,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ok"]
[null,null,"2015-06-30",null,107.5,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ok"]
[null,null,"2015-09-30",null,108,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ok"]
[null,null,"2015-12-31",null,108.4,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ok"]
[null,null,"2016-03-31",null,108.2,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ok"]
[null,null,"2016-06-30",null,{"$f":"E42*1.01","v":108.575},null,"RBA forecast. May 2016 Statement on Monetary Policy. Update when available.",null,null,null,null,null,null,null,null,null,null,null,"Ok"]
[null,null,"2016-09-30",null,{"$f":"AVERAGE(E46,E48)","v":109.3005},null,"Interpolated",null,null,null,null,null,null,null,null,null,null,null,"Ok"]
[null,null,"2016-12-31",null,{"$f":"E44*1.015","v":110.026},null,"RBA forecast. May 2016 Statement on Monetary Policy. Update when available.",null,null,null,null,null,null,null,null,null,null,null,"Ok"]
[null,null,"2017-03-31",null,{"$f":"AVERAGE(E48,E50)","v":110.38625},null,"Interpolated",null,null,null,null,null,null,null,null,null,null,null,"Ok"]
[null,null,"2017-06-30",null,{"$f":"E46*1.02","v":110.74650000000001},null,"RBA forecast. May 2016 Statement on Monetary Policy. Update when available.",null,null,null,null,null,null,null,null,null,null,null,"Ok"]
[]
[null,"End"]

{"sheet":"Input|Reported opex","index":3,"n_rows":57,"n_cols":22,"rows_kept":57,"cut":false,"hidden":false,"merged":[]}
[null,null,{"$f":"Index!$B$1","v":"AER opex model"},null,null,null,null,null,null,"Back to Index",null,"Key:","Input","External Link","Internal Link",null,null,"Worksheet check:",{"$f":"IF(COUNTA($W$32:$W$250)=COUNTIF($W$32:$W$250,\"OK\"),\"OK\",\"Check\")","v":"OK"},null,"Overall Check:",{"$f":"'Check|List'!$S$1","v":"Ok"}]
[null,null,{"$f":"Index!$C$9","v":"Input | Reported opex"}]
[]
[null,null,null,"Source","Unit","Basis",null,null,null,{"$f":"'Input|General'!$G$8","v":"2014-15"},{"$f":"IF(OFFSET('Lookup|Tables'!$G$26:$G$43,MATCH('Input|General'!$G$8,'Lookup|Tables'!$G$26:$G$42,0),0,1,1)<='Input|General'!$G$12,OFFSET('Lookup|Tables'!$G$26:$G$43,MATCH('Input|General'!$G$8,'Lookup|Tables'!$G$26:$G$42,0),0,1,1),\"\")","v":"2015-16"},{"$f":"IF(OFFSET('Lookup|Tables'!$G$28:$G$43,MATCH('Input|General'!$G$8,'Lookup|Tables'!$G$28:$G$42,0)+1,0,1,1)<='Input|General'!$G$12,OFFSET('Lookup|Tables'!$G$28:$G$43,MATCH('Input|General'!$G$8,'Lookup|Tables'!$G$28:$G$42,0)+1,0,1,1),\"\")","v":"2016-17"},{"$f":"IF(OFFSET('Lookup|Tables'!$G$28:$G$43,MATCH('Input|General'!$G$8,'Lookup|Tables'!$G$28:$G$42,0)+2,0,1,1)<='Input|General'!$G$12,OFFSET('Lookup|Tables'!$G$28:$G$43,MATCH('Input|General'!$G$8,'Lookup|Tables'!$G$28:$G$42,0)+2,0,1,1),\"\")","v":"2017-18"},{"$f":"IF(OFFSET('Lookup|Tables'!$G$28:$G$43,MATCH('Input|General'!$G$8,'Lookup|Tables'!$G$28:$G$42,0)+3,0,1,1)<='Input|General'!$G$12,OFFSET('Lookup|Tables'!$G$28:$G$43,MATCH('Input|General'!$G$8,'Lookup|Tables'!$G$28:$G$42,0)+3,0,1,1),\"\")","v":"2018-19"},{"$f":"IF(OFFSET('Lookup|Tables'!$G$28:$G$43,MATCH('Input|General'!$G$8,'Lookup|Tables'!$G$28:$G$42,0)+4,0,1,1)<='Input|General'!$G$12,OFFSET('Lookup|Tables'!$G$28:$G$43,MATCH('Input|General'!$G$8,'Lookup|Tables'!$G$28:$G$42,0)+4,0,1,1),\"\")","v":"2019-20"},{"$f":"IF(OFFSET('Lookup|Tables'!$G$28:$G$43,MATCH('Input|General'!$G$8,'Lookup|Tables'!$G$28:$G$42,0)+5,0,1,1)<='Input|General'!$G$12,OFFSET('Lookup|Tables'!$G$28:$G$43,MATCH('Input|General'!$G$8,'Lookup|Tables'!$G$28:$G$42,0)+5,0,1,1),\"\")","v":"2020-21"},{"$f":"IF(OFFSET('Lookup|Tables'!$G$28:$G$43,MATCH('Input|General'!$G$8,'Lookup|Tables'!$G$28:$G$42,0)+6,0,1,1)<='Input|General'!$G$12,OFFSET('Lookup|Tables'!$G$28:$G$43,MATCH('Input|General'!$G$8,'Lookup|Tables'!$G$28:$G$42,0)+6,0,1,1),\"\")","v":"2021-22"},{"$f":"IF(OFFSET('Lookup|Tables'!$G$28:$G$43,MATCH('Input|General'!$G$8,'Lookup|Tables'!$G$28:$G$42,0)+7,0,1,1)<='Input|General'!$G$12,OFFSET('Lookup|Tables'!$G$28:$G$43,MATCH('Input|General'!$G$8,'Lookup|Tables'!$G$28:$G$42,0)+7,0,1,1),\"\")","v":""},{"$f":"IF(OFFSET('Lookup|Tables'!$G$28:$G$43,MATCH('Input|General'!$G$8,'Lookup|Tables'!$G$28:$G$42,0)+8,0,1,1)<='Input|General'!$G$12,OFFSET('Lookup|Tables'!$G$28:$G$43,MATCH('Input|General'!$G$8,'Lookup|Tables'!$G$28:$G$42,0)+8,0,1,1),\"\")","v":""}]
[]
[]
[]
[null,"Input | Opex allowances"]
[]
[null,null,"Cost category","Source","Unit","Basis",null,null,null,{"$f":"IF(RIGHT(J$4,2)<=RIGHT('Input|General'!$G$10,2),'Input|Reported opex'!J$4,\"\")","v":"2014-15"},{"$f":"IF(RIGHT(K$4,2)<=RIGHT('Input|General'!$G$10,2),'Input|Reported opex'!K$4,\"\")","v":"2015-16"},{"$f":"IF(RIGHT(L$4,2)<=RIGHT('Input|General'!$G$10,2),'Input|Reported opex'!L$4,\"\")","v":"2016-17"},{"$f":"IF(RIGHT(M$4,2)<=RIGHT('Input|General'!$G$10,2),'Input|Reported opex'!M$4,\"\")","v":""},{"$f":"IF(RIGHT(N$4,2)<=RIGHT('Input|General'!$G$10,2),'Input|Reported opex'!N$4,\"\")","v":""},{"$f":"IF(RIGHT(O$4,2)<=RIGHT('Input|General'!$G$10,2),'Input|Reported opex'!O$4,\"\")","v":""},{"$f":"IF(RIGHT(P$4,2)<=RIGHT('Input|General'!$G$10,2),'Input|Reported opex'!P$4,\"\")","v":""},{"$f":"IF(RIGHT(Q$4,2)<=RIGHT('Input|General'!$G$10,2),'Input|Reported opex'!Q$4,\"\")","v":""},{"$f":"IF(RIGHT(R$4,2)<=RIGHT('Input|General'!$G$10,2),'Input|Reported opex'!R$4,\"\")","v":""},{"$f":"IF(RIGHT(S$4,2)<=RIGHT('Input|General'!$G$10,2),'Input|Reported opex'!S$4,\"\")","v":""},"Notes"]
[]
[]
[null,null,"Total opex","AER",{"$f":"$E$24","v":"$millions"},{"$f":"$F$24","v":"2013-14"},null,null,null,185.13515541257806,189.80991219149408,188.00559467591285]
[null,null,"Remove debt raising costs","AER",{"$f":"$E$24","v":"$millions"},{"$f":"$F$24","v":"2013-14"},null,null,null,-1.5496105450072941,-1.5561098586057678,-1.5775852076399237]
[null,null,"Remove easement tax","AER","$millions","2013-14",null,null,null,-100.91902926829269,-103.44200499999999,-100.91902926829269]
[null,null,"Remove AIS rebates","AER","$millions","2013-14",null,null,null,-2.2812929999999998,-2.2812929999999998,-2.2812929999999998]
[null,null,null,"AER","$millions","2013-14"]
[null,null,null,"AER","$millions","2013-14"]
[null,null,null,"AER","$millions","2013-14"]
[null,null,null,"AER","$millions","2013-14"]
[null,null,null,"AER","$millions","2013-14"]
[null,null,null,"AER","$millions","2013-14"]
[]
[null,null,"Total opex","Calculated","$millions","2013-14",null,null,null,{"$f":"SUM(J13:J22)","v":80.38522259927808},82.530504332888313,83.227687199980238,0,0,0,0,0,0,0]
[]
[null,"Input | Reported opex"]
[]
[null,null,null,null,null,null,null,null,null,"Actual","Estimate","Estimate"]
[null,null,"Cost category","Source","Unit","Basis",null,null,null,{"$f":"IF(RIGHT(J4,2)<=RIGHT('Input|General'!$G$10,2),'Input|Reported opex'!J4,\"\")","v":"2014-15"},{"$f":"IF(RIGHT(K4,2)<=RIGHT('Input|General'!$G$10,2),'Input|Reported opex'!K4,\"\")","v":"2015-16"},{"$f":"IF(RIGHT(L4,2)<=RIGHT('Input|General'!$G$10,2),'Input|Reported opex'!L4,\"\")","v":"2016-17"},{"$f":"IF(RIGHT(M4,2)<=RIGHT('Input|General'!$G$10,2),'Input|Reported opex'!M4,\"\")","v":""},{"$f":"IF(RIGHT(N4,2)<=RIGHT('Input|General'!$G$10,2),'Input|Reported opex'!N4,\"\")","v":""},{"$f":"IF(RIGHT(O4,2)<=RIGHT('Input|General'!$G$10,2),'Input|Reported opex'!O4,\"\")","v":""},{"$f":"IF(RIGHT(P4,2)<=RIGHT('Input|General'!$G$10,2),'Input|Reported opex'!P4,\"\")","v":""},{"$f":"IF(RIGHT(Q4,2)<=RIGHT('Input|General'!$G$10,2),'Input|Reported opex'!Q4,\"\")","v":""},{"$f":"IF(RIGHT(R4,2)<=RIGHT('Input|General'!$G$10,2),'Input|Reported opex'!R4,\"\")","v":""},{"$f":"IF(RIGHT(S4,2)<=RIGHT('Input|General'!$G$10,2),'Input|Reported opex'!S4,\"\")","v":""},"Notes"]
[]
[]
[null,null,"Total opex","RIN",{"$f":"$E$45","v":"$millions"},{"$f":"$F$45","v":"nominal"},null,null,null,187.44972001966681]
[null,null,"Remove NCIPAP opex","RIN",{"$f":"$E$45","v":"$millions"},{"$f":"$F$45","v":"nominal"},null,null,null,-0.25119547000000003]
[null,null,null,"RIN",{"$f":"$E$45","v":"$millions"},{"$f":"$F$45","v":"nominal"}]
[null,null,null,"RIN",{"$f":"$E$45","v":"$millions"},{"$f":"$F$45","v":"nominal"}]
[null,null,"Remove movement in provisions","RIN",{"$f":"$E$45","v":"$millions"},{"$f":"$F$45","v":"nominal"},null,null,null,0.13078950975581119]
[]
[null,null,"Expenditure related to category specific forecasts"]
[]
[null,null,"Remove debt raising costs","RIN",{"$f":"$E$45","v":"$millions"},{"$f":"$F$45","v":"nominal"},null,null,null,0]
[null,null,"Remove easement tax","RIN",{"$f":"$E$45","v":"$millions"},{"$f":"$F$45","v":"nominal"},null,null,null,-103.44200500000001]
[null,null,"Remove AIS rebate","RIN",{"$f":"$E$45","v":"$millions"},{"$f":"$F$45","v":"nominal"},null,null,null,-2.4027953599999998]
[null,null,null,"RIN",{"$f":"$E$45","v":"$millions"},{"$f":"$F$45","v":"nominal"}]
[]
[null,null,"Total opex","Calculated","$millions","nominal",null,null,null,{"$f":"SUM(J32:J43)","v":81.484513699422607},0,0,0,0,0,0,0,0,0]
[]
[null,"Input | Adjustments"]
[]
[null,null,"Adjustment","Source","Unit","Basis",null,null,null,{"$f":"IF(RIGHT(J$4,2)=RIGHT('Input|General'!$G$10,2),J$4,\"\")","v":""},{"$f":"IF(RIGHT(K$4,2)=RIGHT('Input|General'!$G$10,2),K$4,\"\")","v":""},{"$f":"IF(RIGHT(L$4,2)=RIGHT('Input|General'!$G$10,2),L$4,\"\")","v":"2016-17"},{"$f":"IF(RIGHT(M4,2)=RIGHT('Input|General'!$G$10,2),'Input|Reported opex'!M4,\"\")","v":""},{"$f":"IF(RIGHT(N$4,2)=RIGHT('Input|General'!$G$10,2),N$4,\"\")","v":""}]
[null,null,"Adjustment 1","External",{"$f":"$E$45","v":"$millions"},"2016-17",null,null,null,null,null,0]
[null,null,"Adjustment 2","External",{"$f":"$E$45","v":"$millions"},"2016-17",null,null,null,null,null,0]
[null,null,"Adjustment 3","External",{"$f":"$E$45","v":"$millions"},"2016-17",null,null,null,null,null,0]
[null,null,"Adjustment 4","External","$millions","2016-17",null,null,null,null,null,0]
[null,null,"Adjustment 5","External","$millions","2016-17",null,null,null,null,null,0]
[null,null,"Efficiency adjustment","External","Per cent",null,null,null,null,null,null,0]
[]
[null,"End"]

{"sheet":"Input|Rate of change","index":4,"n_rows":91,"n_cols":23,"rows_kept":91,"cut":false,"hidden":false,"merged":[[2,10,2,12],[2,14,2,19]]}
[null,{"$f":"Index!$B$1","v":"AER opex model"},null,null,null,null,null,null,null,null,"Back to Index",null,"Key:","Input","External Link","Internal Link",null,null,"Worksheet check:",{"$f":"IF(COUNTIF(W5:W90,\"Check\")=0,\"Ok\",\"Check\")","v":"Ok"},null,"Overall Check:",{"$f":"'Check|List'!$S$1","v":"Ok"}]
[null,{"$f":"Index!$C$10","v":"Input | Rate of change"}]
[]
[null,null,null,"Source","Unit","Basis",null,null,null,{"$f":"IF(OFFSET('Lookup|Tables'!$G$26:$G$43,MATCH('Input|General'!$G$8,'Lookup|Tables'!$G$26:$G$42,0)-2,0,1,1)<='Input|General'!$G$12,OFFSET('Lookup|Tables'!$G$26:$G$43,MATCH('Input|General'!$G$8,'Lookup|Tables'!$G$26:$G$42,0)-2,0,1,1),\"\")","v":"2013-14"},{"$f":"'Input|General'!$G$8","v":"2014-15"},{"$f":"IF(OFFSET('Lookup|Tables'!$G$26:$G$43,MATCH('Input|General'!$G$8,'Lookup|Tables'!$G$26:$G$42,0),0,1,1)<='Input|General'!$G$12,OFFSET('Lookup|Tables'!$G$26:$G$43,MATCH('Input|General'!$G$8,'Lookup|Tables'!$G$26:$G$42,0),0,1,1),\"\")","v":"2015-16"},{"$f":"IF(OFFSET('Lookup|Tables'!$G$26:$G$43,MATCH('Input|General'!$G$8,'Lookup|Tables'!$G$26:$G$42,0)+1,0,1,1)<='Input|General'!$G$12,OFFSET('Lookup|Tables'!$G$26:$G$43,MATCH('Input|General'!$G$8,'Lookup|Tables'!$G$26:$G$42,0)+1,0,1,1),\"\")","v":"2016-17"},{"$f":"IF(OFFSET('Lookup|Tables'!$G$26:$G$43,MATCH('Input|General'!$G$8,'Lookup|Tables'!$G$26:$G$42,0)+2,0,1,1)<='Input|General'!$G$12,OFFSET('Lookup|Tables'!$G$26:$G$43,MATCH('Input|General'!$G$8,'Lookup|Tables'!$G$26:$G$42,0)+2,0,1,1),\"\")","v":"2017-18"},{"$f":"IF(OFFSET('Lookup|Tables'!$G$26:$G$43,MATCH('Input|General'!$G$8,'Lookup|Tables'!$G$26:$G$42,0)+3,0,1,1)<='Input|General'!$G$12,OFFSET('Lookup|Tables'!$G$26:$G$43,MATCH('Input|General'!$G$8,'Lookup|Tables'!$G$26:$G$42,0)+3,0,1,1),\"\")","v":"2018-19"},{"$f":"IF(OFFSET('Lookup|Tables'!$G$26:$G$43,MATCH('Input|General'!$G$8,'Lookup|Tables'!$G$26:$G$42,0)+4,0,1,1)<='Input|General'!$G$12,OFFSET('Lookup|Tables'!$G$26:$G$43,MATCH('Input|General'!$G$8,'Lookup|Tables'!$G$26:$G$42,0)+4,0,1,1),\"\")","v":"2019-20"},{"$f":"IF(OFFSET('Lookup|Tables'!$G$26:$G$43,MATCH('Input|General'!$G$8,'Lookup|Tables'!$G$26:$G$42,0)+5,0,1,1)<='Input|General'!$G$12,OFFSET('Lookup|Tables'!$G$26:$G$43,MATCH('Input|General'!$G$8,'Lookup|Tables'!$G$26:$G$42,0)+5,0,1,1),\"\")","v":"2020-21"},{"$f":"IF(OFFSET('Lookup|Tables'!$G$26:$G$43,MATCH('Input|General'!$G$8,'Lookup|Tables'!$G$26:$G$42,0)+6,0,1,1)<='Input|General'!$G$12,OFFSET('Lookup|Tables'!$G$26:$G$43,MATCH('Input|General'!$G$8,'Lookup|Tables'!$G$26:$G$42,0)+6,0,1,1),\"\")","v":"2021-22"},{"$f":"IF(OFFSET('Lookup|Tables'!$G$26:$G$43,MATCH('Input|General'!$G$8,'Lookup|Tables'!$G$26:$G$42,0)+7,0,1,1)<='Input|General'!$G$12,OFFSET('Lookup|Tables'!$G$26:$G$43,MATCH('Input|General'!$G$8,'Lookup|Tables'!$G$26:$G$42,0)+7,0,1,1),\"\")","v":""},{"$f":"IF(OFFSET('Lookup|Tables'!$G$28:$G$43,MATCH('Input|General'!$G$8,'Lookup|Tables'!$G$28:$G$42,0)+8,0,1,1)<='Input|General'!$G$12,OFFSET('Lookup|Tables'!$G$28:$G$43,MATCH('Input|General'!$G$8,'Lookup|Tables'!$G$28:$G$42,0)+8,0,1,1),\"\")","v":""}]
[]
[]
[]
[null,"Input | Inflation"]
[]
[null,null,"Inflation",null,null,null,null,null,null,{"$f":"J$4","v":"2013-14"},{"$f":"K$4","v":"2014-15"},{"$f":"L$4","v":"2015-16"},"2016-17","2017-18","2018-19","2019-20","2020-21","2021-22","",""]
[]
[null,null,"Inflation","calculated",{"$f":"percent","v":"Per cent"},null,null,null,null,{"$f":"'Input|Inflation'!E37/'Input|Inflation'!E33-1","v":2.9296875E-2},{"$f":"'Input|Inflation'!E41/'Input|Inflation'!E37-1","v":1.3282732447817747E-2},{"$f":"'Input|Inflation'!E45/'Input|Inflation'!E41-1","v":1.3108614232209881E-2},{"$f":"'Input|Inflation'!E49/'Input|Inflation'!E45-1","v":2.0205637707948254E-2}]
[]
[null,null,"CPI indexes (real to real)",null,null,null,null,null,null,{"$f":"J$4","v":"2013-14"},{"$f":"K$4","v":"2014-15"},{"$f":"L4","v":"2015-16"},{"$f":"M4","v":"2016-17"}]
[]
[null,null,{"$f":"+TRANSPOSE(J10:M10)","v":"2013-14"},"calculated","index",null,null,null,null,1,{"$f":"J16*(1+K$12)","v":1.0132827324478177},1.0265654648956357,1.0473078747628084]
[null,null,"2014-15","calculated","index",null,null,null,null,{"$f":"K17/(1+K$12)","v":0.98689138576779034},1,{"$f":"K17*(1+L$12)","v":1.0131086142322099},{"$f":"L17*(1+M$12)","v":1.0335791198501874}]
[null,null,"2015-16","calculated","index",null,null,null,null,{"$f":"K18/(1+K$12)","v":0.97412199630314222},{"$f":"L18/(1+L$12)","v":0.987060998151571},1,{"$f":"L18*(1+M$12)","v":1.0202056377079483}]
[null,null,"2016-17","calculated","index",null,null,null,null,{"$f":"K19/(1+K$12)","v":0.95482906612010088},0.96751180513877388,0.98019454415744711,1]
[]
[null,null,"CPI indexes (nominal to real)",null,null,null,null,null,null,{"$f":"J10","v":"2013-14"},{"$f":"K10","v":"2014-15"},{"$f":"L10","v":"2015-16"},{"$f":"M10","v":"2016-17"}]
[]
[null,null,{"$f":"+TRANSPOSE(J10:M10)","v":"2013-14"},"calculated","index",null,null,null,null,{"$f":"1/J16*(1+J$12)^0.5","v":1.0145426925467453},0.9934240714658521,0.98048590343691056,0.96442728912924158]
[null,null,"2014-15","calculated","index",null,null,null,null,1.0280185916887323,1.0066194576143548,0.9935094353611198,0.97723751877611942]
[null,null,"2015-16","calculated","index",null,null,null,null,1.0414944908307195,1.0198148437628578,1.0065329672853294,0.99004774842299748]
[null,null,"2016-17","calculated","index",null,null,null,null,1.0625385511872691,1.040420853025118,1.0268706077634029,1.0100522945412025]
[]
[null,"Input | Forecast price change"]
[]
[null,null,"Forecast price change","Source","Unit",null,null,null,null,null,{"$f":"IF(RIGHT(K$4,2)>=RIGHT('Input|General'!$G$11,2),IF(RIGHT(K$4,2)<=RIGHT('Input|General'!$G$12,2),K$4,\"\"),\"\")","v":""},{"$f":"IF(RIGHT(L$4,2)>=RIGHT('Input|General'!$G$11,2),IF(RIGHT(L$4,2)<=RIGHT('Input|General'!$G$12,2),L$4,\"\"),\"\")","v":""},{"$f":"IF(RIGHT(M$4,2)>=RIGHT('Input|General'!$G$11,2),IF(RIGHT(M$4,2)<=RIGHT('Input|General'!$G$12,2),M$4,\"\"),\"\")","v":""},{"$f":"IF(RIGHT(N$4,2)>=RIGHT('Input|General'!$G$11,2),IF(RIGHT(N$4,2)<=RIGHT('Input|General'!$G$12,2),N$4,\"\"),\"\")","v":"2017-18"},{"$f":"IF(RIGHT(O$4,2)>=RIGHT('Input|General'!$G$11,2),IF(RIGHT(O$4,2)<=RIGHT('Input|General'!$G$12,2),O$4,\"\"),\"\")","v":"2018-19"},{"$f":"IF(RIGHT(P$4,2)>=RIGHT('Input|General'!$G$11,2),IF(RIGHT(P$4,2)<=RIGHT('Input|General'!$G$12,2),P$4,\"\"),\"\")","v":"2019-20"},{"$f":"IF(RIGHT(Q$4,2)>=RIGHT('Input|General'!$G$11,2),IF(RIGHT(Q$4,2)<=RIGHT('Input|General'!$G$12,2),Q$4,\"\"),\"\")","v":"2020-21"},{"$f":"IF(RIGHT(R$4,2)>=RIGHT('Input|General'!$G$11,2),IF(RIGHT(R$4,2)<=RIGHT('Input|General'!$G$12,2),R$4,\"\"),\"\")","v":"2021-22"}]
[]
[null,null,"WPI","external",{"$f":"percent","v":"Per cent"},null,null,null,null,null,null,null,null,4.7496548661143242E-3,8.2809385028493523E-3,9.7284923085977359E-3,1.0207402844109488E-2,1.0250872658915977E-2]
[null,null,null,"external","Per cent"]
[null,null,null,"external","Per cent"]
[null,null,null,"external","Per cent"]
[null,null,null,"external","Per cent"]
[null,null,null,"external","Per cent"]
[null,null,null,"external","Per cent"]
[null,null,"CPI","external","Per cent",null,null,null,null,null,null,null,null,0,0,0,0,0]
[]
[null,null,"Weights","Source","Unit",null,null,null,null,null,{"$f":"IF(RIGHT(K$4,2)>=RIGHT('Input|General'!$G$11,2),IF(RIGHT(K$4,2)<=RIGHT('Input|General'!$G$12,2),K$4,\"\"),\"\")","v":""},{"$f":"IF(RIGHT(L$4,2)>=RIGHT('Input|General'!$G$11,2),IF(RIGHT(L$4,2)<=RIGHT('Input|General'!$G$12,2),L$4,\"\"),\"\")","v":""},{"$f":"IF(RIGHT(M$4,2)>=RIGHT('Input|General'!$G$11,2),IF(RIGHT(M$4,2)<=RIGHT('Input|General'!$G$12,2),M$4,\"\"),\"\")","v":""},{"$f":"IF(RIGHT(N$4,2)>=RIGHT('Input|General'!$G$11,2),IF(RIGHT(N$4,2)<=RIGHT('Input|General'!$G$12,2),N$4,\"\"),\"\")","v":"2017-18"},{"$f":"IF(RIGHT(O$4,2)>=RIGHT('Input|General'!$G$11,2),IF(RIGHT(O$4,2)<=RIGHT('Input|General'!$G$12,2),O$4,\"\"),\"\")","v":"2018-19"},{"$f":"IF(RIGHT(P$4,2)>=RIGHT('Input|General'!$G$11,2),IF(RIGHT(P$4,2)<=RIGHT('Input|General'!$G$12,2),P$4,\"\"),\"\")","v":"2019-20"},{"$f":"IF(RIGHT(Q$4,2)>=RIGHT('Input|General'!$G$11,2),IF(RIGHT(Q$4,2)<=RIGHT('Input|General'!$G$12,2),Q$4,\"\"),\"\")","v":"2020-21"},{"$f":"IF(RIGHT(R$4,2)>=RIGHT('Input|General'!$G$11,2),IF(RIGHT(R$4,2)<=RIGHT('Input|General'!$G$12,2),R$4,\"\"),\"\")","v":"2021-22"}]
[]
[null,null,{"$f":"C32","v":"WPI"},"external",{"$f":"percent","v":"Per cent"},null,null,null,null,null,null,null,null,0.62,0.62,0.62,0.62,0.62]
[null,null,{"$f":"C33","v":0},"external","Per cent"]
[null,null,0,"external","Per cent"]
[null,null,0,"external","Per cent"]
[null,null,0,"external","Per cent"]
[null,null,0,"external","Per cent"]
[null,null,0,"external","Per cent"]
[null,null,"CPI","external","Per cent",null,null,null,null,null,null,null,null,0.38,0.38,0.38,0.38,0.38]
[]
[null,null,"Check","calculated","Ok/Check","n/a",null,null,null,null,null,null,null,{"$f":"IF(SUM(N43:N50)=1,\"Ok\",\"Check\")","v":"Ok"},"Ok",{"$f":"IF(SUM(P43:P50)=1,\"Ok\",\"Check\")","v":"Ok"},{"$f":"IF(SUM(Q43:Q50)=1,\"Ok\",\"Check\")","v":"Ok"},"Ok",null,null,null,null,{"$f":"IF(COUNTIF(K52:T52,\"Check\")=0,\"Ok\",\"Check\")","v":"Ok"}]
[]
[null,"Input | Forecast output growth"]
[]
[null,null,"Output measure","Source","Unit","Basis",null,null,null,null,"","","2016-17","2017-18","2018-19","2019-20","2020-21","2021-22","",""]
[]
[null,null,null,"external","number","n/a"]
[null,null,null,"external","number","n/a"]
[null,null,null,"external","number","n/a"]
[null,null,null,"external","number","n/a"]
[null,null,null,"external","number","n/a"]
[null,null,null,"external","number","n/a"]
[]
[null,null,"Growth rate","Source","Unit","Basis",null,null,null,null,"","","","2017-18","2018-19","2019-20","2020-21","2021-22","","",""]
[]
[null,null,{"$f":"C58","v":0},"calculated","number","n/a",null,null,null,null,{"$f":"IF(ISBLANK(J58),\"\",LN(K58)-LN(J58))","v":""},"","","","","","",{"$f":"IF(ISBLANK(Q58),\"\",LN(R58)-LN(Q58))","v":""},{"$f":"IF(ISBLANK(S58),\"\",LN(S58)-LN(R58))","v":""},""]
[null,null,{"$f":"C59","v":0},"calculated","number","n/a",null,null,null,null,"","","","","","","",{"$f":"IF(ISBLANK(Q59),\"\",LN(R59)-LN(Q59))","v":""},"",""]
[null,null,0,"calculated","number","n/a",null,null,null,null,"","","","","","","","","",""]
[null,null,0,"calculated","number","n/a",null,null,null,null,"","","","","","","","","",""]
[null,null,0,"calculated","number","n/a",null,null,null,null,"","","","","","","","","",""]
[null,null,0,"calculated","number","n/a",null,null,null,null,"","","","","","","","","",""]
[]
[null,null,"Weights"]
[]
[null,null,{"$f":"C58","v":0},"external","number","n/a",null,null,null,null,null,null,1]
[null,null,{"$f":"C59","v":0},"external","number","n/a"]
[null,null,0,"external","number","n/a"]
[null,null,0,"external","number","n/a"]
[null,null,0,"external","number","n/a"]
[null,null,0,"external","number","n/a"]
[]
[null,null,"Check","calculated","Ok/Check","n/a",null,null,null,null,null,null,{"$f":"IF(SUM(M76:M81)=1,\"Ok\",\"Check\")","v":"Ok"},null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTIF(K83:T83,\"Check\")=0,\"Ok\",\"Check\")","v":"Ok"}]
[]
[null,"Input | Forecast productivity"]
[]
[null,null,"Partial factor productivity","Source","Unit","Basis",null,null,null,null,{"$f":"IF(RIGHT(K$4,2)>=RIGHT('Input|General'!$G$11,2),IF(RIGHT(K$4,2)<=RIGHT('Input|General'!$G$12,2),K$4,\"\"),\"\")","v":""},{"$f":"IF(RIGHT(L$4,2)>=RIGHT('Input|General'!$G$11,2),IF(RIGHT(L$4,2)<=RIGHT('Input|General'!$G$12,2),L$4,\"\"),\"\")","v":""},{"$f":"IF(RIGHT(M$4,2)>=RIGHT('Input|General'!$G$11,2),IF(RIGHT(M$4,2)<=RIGHT('Input|General'!$G$12,2),M$4,\"\"),\"\")","v":""},{"$f":"IF(RIGHT(N$4,2)>=RIGHT('Input|General'!$G$11,2),IF(RIGHT(N$4,2)<=RIGHT('Input|General'!$G$12,2),N$4,\"\"),\"\")","v":"2017-18"},{"$f":"IF(RIGHT(O$4,2)>=RIGHT('Input|General'!$G$11,2),IF(RIGHT(O$4,2)<=RIGHT('Input|General'!$G$12,2),O$4,\"\"),\"\")","v":"2018-19"},{"$f":"IF(RIGHT(P$4,2)>=RIGHT('Input|General'!$G$11,2),IF(RIGHT(P$4,2)<=RIGHT('Input|General'!$G$12,2),P$4,\"\"),\"\")","v":"2019-20"},{"$f":"IF(RIGHT(Q$4,2)>=RIGHT('Input|General'!$G$11,2),IF(RIGHT(Q$4,2)<=RIGHT('Input|General'!$G$12,2),Q$4,\"\"),\"\")","v":"2020-21"},{"$f":"IF(RIGHT(R$4,2)>=RIGHT('Input|General'!$G$11,2),IF(RIGHT(R$4,2)<=RIGHT('Input|General'!$G$12,2),R$4,\"\"),\"\")","v":"2021-22"},{"$f":"IF(RIGHT(S$4,2)>=RIGHT('Input|General'!$G$11,2),IF(RIGHT(S$4,2)<=RIGHT('Input|General'!$G$12,2),S$4,\"\"),\"\")","v":""},{"$f":"IF(RIGHT(T$4,2)>=RIGHT('Input|General'!$G$11,2),IF(RIGHT(T$4,2)<=RIGHT('Input|General'!$G$12,2),T$4,\"\"),\"\")","v":""}]
[]
[null,null,"Partial factor productivity","external",{"$f":"percent","v":"Per cent"},"n/a",null,null,null,null,null,null,null,2E-3,2E-3,2E-3,2E-3,2E-3]
[]
[null,"End"]

{"sheet":"Input|Step changes","index":5,"n_rows":39,"n_cols":22,"rows_kept":39,"cut":false,"hidden":false,"merged":[[2,9,2,11],[2,13,2,18]]}
[null,{"$f":"Index!$B$1","v":"AER opex model"},null,null,null,null,null,null,null,"Back to Index",null,"Key:","Input","External Link","Internal Link",null,null,"Worksheet check:",{"$f":"IF(COUNTA($W$8:$W$232)=COUNTIF($W$8:$W$232,\"OK\"),\"OK\",\"Check\")","v":"OK"},null,"Overall Check:",{"$f":"'Check|List'!$S$1","v":"Ok"}]
[null,{"$f":"Index!$C$11","v":"Input | Step changes"}]
[]
[null,null,null,"Source","Unit","Basis",null,null,null,{"$f":"'Input|General'!$G$8","v":"2014-15"},{"$f":"IF(OFFSET('Lookup|Tables'!$G$26:$G$43,MATCH('Input|General'!$G$8,'Lookup|Tables'!$G$26:$G$42,0),0,1,1)<='Input|General'!$G$12,OFFSET('Lookup|Tables'!$G$26:$G$43,MATCH('Input|General'!$G$8,'Lookup|Tables'!$G$26:$G$42,0),0,1,1),\"\")","v":"2015-16"},{"$f":"IF(OFFSET('Lookup|Tables'!$G$28:$G$43,MATCH('Input|General'!$G$8,'Lookup|Tables'!$G$28:$G$42,0)+1,0,1,1)<='Input|General'!$G$12,OFFSET('Lookup|Tables'!$G$28:$G$43,MATCH('Input|General'!$G$8,'Lookup|Tables'!$G$28:$G$42,0)+1,0,1,1),\"\")","v":"2016-17"},{"$f":"IF(OFFSET('Lookup|Tables'!$G$28:$G$43,MATCH('Input|General'!$G$8,'Lookup|Tables'!$G$28:$G$42,0)+2,0,1,1)<='Input|General'!$G$12,OFFSET('Lookup|Tables'!$G$28:$G$43,MATCH('Input|General'!$G$8,'Lookup|Tables'!$G$28:$G$42,0)+2,0,1,1),\"\")","v":"2017-18"},{"$f":"IF(OFFSET('Lookup|Tables'!$G$28:$G$43,MATCH('Input|General'!$G$8,'Lookup|Tables'!$G$28:$G$42,0)+3,0,1,1)<='Input|General'!$G$12,OFFSET('Lookup|Tables'!$G$28:$G$43,MATCH('Input|General'!$G$8,'Lookup|Tables'!$G$28:$G$42,0)+3,0,1,1),\"\")","v":"2018-19"},{"$f":"IF(OFFSET('Lookup|Tables'!$G$28:$G$43,MATCH('Input|General'!$G$8,'Lookup|Tables'!$G$28:$G$42,0)+4,0,1,1)<='Input|General'!$G$12,OFFSET('Lookup|Tables'!$G$28:$G$43,MATCH('Input|General'!$G$8,'Lookup|Tables'!$G$28:$G$42,0)+4,0,1,1),\"\")","v":"2019-20"},{"$f":"IF(OFFSET('Lookup|Tables'!$G$28:$G$43,MATCH('Input|General'!$G$8,'Lookup|Tables'!$G$28:$G$42,0)+5,0,1,1)<='Input|General'!$G$12,OFFSET('Lookup|Tables'!$G$28:$G$43,MATCH('Input|General'!$G$8,'Lookup|Tables'!$G$28:$G$42,0)+5,0,1,1),\"\")","v":"2020-21"},{"$f":"IF(OFFSET('Lookup|Tables'!$G$28:$G$43,MATCH('Input|General'!$G$8,'Lookup|Tables'!$G$28:$G$42,0)+6,0,1,1)<='Input|General'!$G$12,OFFSET('Lookup|Tables'!$G$28:$G$43,MATCH('Input|General'!$G$8,'Lookup|Tables'!$G$28:$G$42,0)+6,0,1,1),\"\")","v":"2021-22"},{"$f":"IF(OFFSET('Lookup|Tables'!$G$28:$G$43,MATCH('Input|General'!$G$8,'Lookup|Tables'!$G$28:$G$42,0)+7,0,1,1)<='Input|General'!$G$12,OFFSET('Lookup|Tables'!$G$28:$G$43,MATCH('Input|General'!$G$8,'Lookup|Tables'!$G$28:$G$42,0)+7,0,1,1),\"\")","v":""},{"$f":"IF(OFFSET('Lookup|Tables'!$G$28:$G$43,MATCH('Input|General'!$G$8,'Lookup|Tables'!$G$28:$G$42,0)+8,0,1,1)<='Input|General'!$G$12,OFFSET('Lookup|Tables'!$G$28:$G$43,MATCH('Input|General'!$G$8,'Lookup|Tables'!$G$28:$G$42,0)+8,0,1,1),\"\")","v":""}]
[]
[]
[]
[null,"Input |Step changes"]
[]
[null,null,"Step change","Source","Unit","Basis",null,null,null,{"$f":"IF(RIGHT(J$4,2)>=RIGHT('Input|General'!$G$11,2),IF(RIGHT(J$4,2)<=RIGHT('Input|General'!$G$12,2),J$4,\"\"),\"\")","v":""},{"$f":"IF(RIGHT(K$4,2)>=RIGHT('Input|General'!$G$11,2),IF(RIGHT(K$4,2)<=RIGHT('Input|General'!$G$12,2),K$4,\"\"),\"\")","v":""},{"$f":"IF(RIGHT(L$4,2)>=RIGHT('Input|General'!$G$11,2),IF(RIGHT(L$4,2)<=RIGHT('Input|General'!$G$12,2),L$4,\"\"),\"\")","v":""},{"$f":"IF(RIGHT(M$4,2)>=RIGHT('Input|General'!$G$11,2),IF(RIGHT(M$4,2)<=RIGHT('Input|General'!$G$12,2),M$4,\"\"),\"\")","v":"2017-18"},{"$f":"IF(RIGHT(N$4,2)>=RIGHT('Input|General'!$G$11,2),IF(RIGHT(N$4,2)<=RIGHT('Input|General'!$G$12,2),N$4,\"\"),\"\")","v":"2018-19"},{"$f":"IF(RIGHT(O$4,2)>=RIGHT('Input|General'!$G$11,2),IF(RIGHT(O$4,2)<=RIGHT('Input|General'!$G$12,2),O$4,\"\"),\"\")","v":"2019-20"},{"$f":"IF(RIGHT(P$4,2)>=RIGHT('Input|General'!$G$11,2),IF(RIGHT(P$4,2)<=RIGHT('Input|General'!$G$12,2),P$4,\"\"),\"\")","v":"2020-21"},{"$f":"IF(RIGHT(Q$4,2)>=RIGHT('Input|General'!$G$11,2),IF(RIGHT(Q$4,2)<=RIGHT('Input|General'!$G$12,2),Q$4,\"\"),\"\")","v":"2021-22"},{"$f":"IF(RIGHT(R$4,2)>=RIGHT('Input|General'!$G$11,2),IF(RIGHT(R$4,2)<=RIGHT('Input|General'!$G$12,2),R$4,\"\"),\"\")","v":""},{"$f":"IF(RIGHT(S$4,2)>=RIGHT('Input|General'!$G$11,2),IF(RIGHT(S$4,2)<=RIGHT('Input|General'!$G$12,2),S$4,\"\"),\"\")","v":""}]
[]
[null,null,"Synchronous condenser decommissioning","AER","$millions","2016-17",null,null,null,null,null,null,0,0,0,0,0]
[null,null,"SAIP roll out","AER","$millions","2016-17",null,null,null,null,null,null,0,0,0,0,0]
[null,null,"Establishment of IT security team","AER","$millions","2016-17",null,null,null,null,null,null,0,0,0,0,0]
[null,null,"New emergency response arrangements","AER","$millions","2016-17",null,null,null,null,null,null,0,0,0,0,0]
[null,null,"WMTS mobile switchboard","AER","$millions","2016-17",null,null,null,null,null,null,0,0,0,0,0]
[null,null,"MPS decommissioning","AER","$millions","2016-17",null,null,null,null,null,null,0,0,0,0,0]
[null,null,null,"AER","$millions","2016-17"]
[null,null,null,"AER","$millions","2016-17"]
[null,null,null,"AER","$millions","2016-17"]
[null,null,null,"AER","$millions","2016-17"]
[null,null,null,"AER","$millions","2016-17"]
[null,null,null,"AER","$millions","2016-17"]
[]
[null,"Input | Category specifc forecasts"]
[]
[null,null,"Category specific forecasts","Source","Unit","Basis",null,null,null,{"$f":"IF(RIGHT(J$4,2)>=RIGHT('Input|General'!$G$11,2),IF(RIGHT(J$4,2)<=RIGHT('Input|General'!$G$12,2),J$4,\"\"),\"\")","v":""},{"$f":"IF(RIGHT(K$4,2)>=RIGHT('Input|General'!$G$11,2),IF(RIGHT(K$4,2)<=RIGHT('Input|General'!$G$12,2),K$4,\"\"),\"\")","v":""},{"$f":"IF(RIGHT(L$4,2)>=RIGHT('Input|General'!$G$11,2),IF(RIGHT(L$4,2)<=RIGHT('Input|General'!$G$12,2),L$4,\"\"),\"\")","v":""},{"$f":"IF(RIGHT(M$4,2)>=RIGHT('Input|General'!$G$11,2),IF(RIGHT(M$4,2)<=RIGHT('Input|General'!$G$12,2),M$4,\"\"),\"\")","v":"2017-18"},{"$f":"IF(RIGHT(N$4,2)>=RIGHT('Input|General'!$G$11,2),IF(RIGHT(N$4,2)<=RIGHT('Input|General'!$G$12,2),N$4,\"\"),\"\")","v":"2018-19"},{"$f":"IF(RIGHT(O$4,2)>=RIGHT('Input|General'!$G$11,2),IF(RIGHT(O$4,2)<=RIGHT('Input|General'!$G$12,2),O$4,\"\"),\"\")","v":"2019-20"},{"$f":"IF(RIGHT(P$4,2)>=RIGHT('Input|General'!$G$11,2),IF(RIGHT(P$4,2)<=RIGHT('Input|General'!$G$12,2),P$4,\"\"),\"\")","v":"2020-21"},{"$f":"IF(RIGHT(Q$4,2)>=RIGHT('Input|General'!$G$11,2),IF(RIGHT(Q$4,2)<=RIGHT('Input|General'!$G$12,2),Q$4,\"\"),\"\")","v":"2021-22"},{"$f":"IF(RIGHT(R$4,2)>=RIGHT('Input|General'!$G$11,2),IF(RIGHT(R$4,2)<=RIGHT('Input|General'!$G$12,2),R$4,\"\"),\"\")","v":""},{"$f":"IF(RIGHT(S$4,2)>=RIGHT('Input|General'!$G$11,2),IF(RIGHT(S$4,2)<=RIGHT('Input|General'!$G$12,2),S$4,\"\"),\"\")","v":""}]
[]
[null,null,"Easement tax","AER","$millions","2016-17",null,null,null,null,null,null,114.31425505580884,114.31425505580884,114.31425505580884,114.31425505580884,114.31425505580884]
[null,null,"Group 3 roll in","AER","$millions","2016-17",null,null,null,null,null,null,2.0044134484216118,2.0044134484216118,2.0044134484216118,2.0044134484216118,2.0044134484216118]
[null,null,null,"AER","$millions","2016-17"]
[]
[null,"Input | Debt raising costs"]
[]
[null,null,"Debt Raising Costs","Source","Unit","Basis",null,null,null,{"$f":"IF(RIGHT(J$4,2)>=RIGHT('Input|General'!$G$11,2),IF(RIGHT(J$4,2)<=RIGHT('Input|General'!$G$12,2),J$4,\"\"),\"\")","v":""},{"$f":"IF(RIGHT(K$4,2)>=RIGHT('Input|General'!$G$11,2),IF(RIGHT(K$4,2)<=RIGHT('Input|General'!$G$12,2),K$4,\"\"),\"\")","v":""},{"$f":"IF(RIGHT(L$4,2)>=RIGHT('Input|General'!$G$11,2),IF(RIGHT(L$4,2)<=RIGHT('Input|General'!$G$12,2),L$4,\"\"),\"\")","v":""},{"$f":"IF(RIGHT(M$4,2)>=RIGHT('Input|General'!$G$11,2),IF(RIGHT(M$4,2)<=RIGHT('Input|General'!$G$12,2),M$4,\"\"),\"\")","v":"2017-18"},{"$f":"IF(RIGHT(N$4,2)>=RIGHT('Input|General'!$G$11,2),IF(RIGHT(N$4,2)<=RIGHT('Input|General'!$G$12,2),N$4,\"\"),\"\")","v":"2018-19"},{"$f":"IF(RIGHT(O$4,2)>=RIGHT('Input|General'!$G$11,2),IF(RIGHT(O$4,2)<=RIGHT('Input|General'!$G$12,2),O$4,\"\"),\"\")","v":"2019-20"},{"$f":"IF(RIGHT(P$4,2)>=RIGHT('Input|General'!$G$11,2),IF(RIGHT(P$4,2)<=RIGHT('Input|General'!$G$12,2),P$4,\"\"),\"\")","v":"2020-21"},{"$f":"IF(RIGHT(Q$4,2)>=RIGHT('Input|General'!$G$11,2),IF(RIGHT(Q$4,2)<=RIGHT('Input|General'!$G$12,2),Q$4,\"\"),\"\")","v":"2021-22"},{"$f":"IF(RIGHT(R$4,2)>=RIGHT('Input|General'!$G$11,2),IF(RIGHT(R$4,2)<=RIGHT('Input|General'!$G$12,2),R$4,\"\"),\"\")","v":""},{"$f":"IF(RIGHT(S$4,2)>=RIGHT('Input|General'!$G$11,2),IF(RIGHT(S$4,2)<=RIGHT('Input|General'!$G$12,2),S$4,\"\"),\"\")","v":""}]
[]
[null,null,"Debt raising costs","PTRM","$millions","2016-17",null,null,null,null,null,null,1.6120217035229163,1.6035753609391019,1.5785657492430665,1.5440134529743128,1.5065266567944509]
[]
[null,"End"]

{"sheet":"Calc|Opex forecast","index":6,"n_rows":89,"n_cols":22,"rows_kept":89,"cut":false,"hidden":false,"merged":[[2,9,2,11],[2,13,2,18]]}
[null,{"$f":"Index!$B$1","v":"AER opex model"},null,null,null,null,null,null,null,"Back to Index",null,"Key:","Input","External Link","Internal Link",null,null,"Worksheet check:","n/a",null,"Overall Check:",{"$f":"'Check|List'!$S$1","v":"Ok"}]
[null,{"$f":"Index!$C$12","v":"Calc | Opex Forecast"}]
[]
[null,null,null,"Source","Unit","Basis",null,null,null,{"$f":"'Input|General'!$G$8","v":"2014-15"},{"$f":"IF(OFFSET('Lookup|Tables'!$G$26:$G$43,MATCH('Input|General'!$G$8,'Lookup|Tables'!$G$26:$G$42,0),0,1,1)<='Input|General'!$G$12,OFFSET('Lookup|Tables'!$G$26:$G$43,MATCH('Input|General'!$G$8,'Lookup|Tables'!$G$26:$G$42,0),0,1,1),\"\")","v":"2015-16"},{"$f":"IF(OFFSET('Lookup|Tables'!$G$28:$G$43,MATCH('Input|General'!$G$8,'Lookup|Tables'!$G$28:$G$42,0)+1,0,1,1)<='Input|General'!$G$12,OFFSET('Lookup|Tables'!$G$28:$G$43,MATCH('Input|General'!$G$8,'Lookup|Tables'!$G$28:$G$42,0)+1,0,1,1),\"\")","v":"2016-17"},{"$f":"IF(OFFSET('Lookup|Tables'!$G$28:$G$43,MATCH('Input|General'!$G$8,'Lookup|Tables'!$G$28:$G$42,0)+2,0,1,1)<='Input|General'!$G$12,OFFSET('Lookup|Tables'!$G$28:$G$43,MATCH('Input|General'!$G$8,'Lookup|Tables'!$G$28:$G$42,0)+2,0,1,1),\"\")","v":"2017-18"},{"$f":"IF(OFFSET('Lookup|Tables'!$G$28:$G$43,MATCH('Input|General'!$G$8,'Lookup|Tables'!$G$28:$G$42,0)+3,0,1,1)<='Input|General'!$G$12,OFFSET('Lookup|Tables'!$G$28:$G$43,MATCH('Input|General'!$G$8,'Lookup|Tables'!$G$28:$G$42,0)+3,0,1,1),\"\")","v":"2018-19"},{"$f":"IF(OFFSET('Lookup|Tables'!$G$28:$G$43,MATCH('Input|General'!$G$8,'Lookup|Tables'!$G$28:$G$42,0)+4,0,1,1)<='Input|General'!$G$12,OFFSET('Lookup|Tables'!$G$28:$G$43,MATCH('Input|General'!$G$8,'Lookup|Tables'!$G$28:$G$42,0)+4,0,1,1),\"\")","v":"2019-20"},{"$f":"IF(OFFSET('Lookup|Tables'!$G$28:$G$43,MATCH('Input|General'!$G$8,'Lookup|Tables'!$G$28:$G$42,0)+5,0,1,1)<='Input|General'!$G$12,OFFSET('Lookup|Tables'!$G$28:$G$43,MATCH('Input|General'!$G$8,'Lookup|Tables'!$G$28:$G$42,0)+5,0,1,1),\"\")","v":"2020-21"},{"$f":"IF(OFFSET('Lookup|Tables'!$G$28:$G$43,MATCH('Input|General'!$G$8,'Lookup|Tables'!$G$28:$G$42,0)+6,0,1,1)<='Input|General'!$G$12,OFFSET('Lookup|Tables'!$G$28:$G$43,MATCH('Input|General'!$G$8,'Lookup|Tables'!$G$28:$G$42,0)+6,0,1,1),\"\")","v":"2021-22"},{"$f":"IF(OFFSET('Lookup|Tables'!$G$28:$G$43,MATCH('Input|General'!$G$8,'Lookup|Tables'!$G$28:$G$42,0)+7,0,1,1)<='Input|General'!$G$12,OFFSET('Lookup|Tables'!$G$28:$G$43,MATCH('Input|General'!$G$8,'Lookup|Tables'!$G$28:$G$42,0)+7,0,1,1),\"\")","v":""},{"$f":"IF(OFFSET('Lookup|Tables'!$G$28:$G$43,MATCH('Input|General'!$G$8,'Lookup|Tables'!$G$28:$G$42,0)+8,0,1,1)<='Input|General'!$G$12,OFFSET('Lookup|Tables'!$G$28:$G$43,MATCH('Input|General'!$G$8,'Lookup|Tables'!$G$28:$G$42,0)+8,0,1,1),\"\")","v":""}]
[]
[]
[]
[null,"Calc | Estimated final year expenditure",null,null,"$millions","2016-17"]
[]
[null,null,null,"Source","Unit","Basis",null,null,null,{"$f":"IF(RIGHT(J$4,2)>=RIGHT('Input|General'!$G$9,2),IF(RIGHT(J$4,2)<=RIGHT('Input|General'!$G$10,2),J$4,\"\"),\"\")","v":"2014-15"},{"$f":"IF(RIGHT(K$4,2)>=RIGHT('Input|General'!$G$9,2),IF(RIGHT(K$4,2)<=RIGHT('Input|General'!$G$10,2),K$4,\"\"),\"\")","v":"2015-16"},{"$f":"IF(RIGHT(L$4,2)>=RIGHT('Input|General'!$G$9,2),IF(RIGHT(L$4,2)<=RIGHT('Input|General'!$G$10,2),L$4,\"\"),\"\")","v":"2016-17"},{"$f":"IF(RIGHT(M$4,2)>=RIGHT('Input|General'!$G$9,2),IF(RIGHT(M$4,2)<=RIGHT('Input|General'!$G$10,2),M$4,\"\"),\"\")","v":""},{"$f":"IF(RIGHT(N$4,2)>=RIGHT('Input|General'!$G$9,2),IF(RIGHT(N$4,2)<=RIGHT('Input|General'!$G$10,2),N$4,\"\"),\"\")","v":""},{"$f":"IF(RIGHT(O$4,2)>=RIGHT('Input|General'!$G$9,2),IF(RIGHT(O$4,2)<=RIGHT('Input|General'!$G$10,2),O$4,\"\"),\"\")","v":""},{"$f":"IF(RIGHT(P$4,2)>=RIGHT('Input|General'!$G$9,2),IF(RIGHT(P$4,2)<=RIGHT('Input|General'!$G$10,2),P$4,\"\"),\"\")","v":""},{"$f":"IF(RIGHT(Q$4,2)>=RIGHT('Input|General'!$G$9,2),IF(RIGHT(Q$4,2)<=RIGHT('Input|General'!$G$10,2),Q$4,\"\"),\"\")","v":""},{"$f":"IF(RIGHT(R$4,2)>=RIGHT('Input|General'!$G$9,2),IF(RIGHT(R$4,2)<=RIGHT('Input|General'!$G$10,2),R$4,\"\"),\"\")","v":""},{"$f":"IF(RIGHT(S$4,2)>=RIGHT('Input|General'!$G$9,2),IF(RIGHT(S$4,2)<=RIGHT('Input|General'!$G$10,2),S$4,\"\"),\"\")","v":""}]
[]
[null,null,"Total reported opex","Inputs|Reported opex",{"$f":"'Input|Reported opex'!E45","v":"$millions"},{"$f":"'Input|Reported opex'!F45","v":"nominal"},null,null,null,{"$f":"IF(J$10='Input|General'!$G$9,'Input|Reported opex'!J45,0)","v":81.484513699422607},{"$f":"IF(K$10='Input|General'!$G$9,'Input|Reported opex'!K45,0)","v":0},{"$f":"IF(L$10='Input|General'!$G$9,'Input|Reported opex'!L45,0)","v":0},{"$f":"IF(M$10='Input|General'!$G$9,'Input|Reported opex'!M45,0)","v":0},{"$f":"IF(N$10='Input|General'!$G$9,'Input|Reported opex'!N45,0)","v":0},{"$f":"IF(O$10='Input|General'!$G$9,'Input|Reported opex'!O45,0)","v":0},{"$f":"IF(P$10='Input|General'!$G$9,'Input|Reported opex'!P45,0)","v":0},{"$f":"IF(Q$10='Input|General'!$G$9,'Input|Reported opex'!Q45,0)","v":0},{"$f":"IF(R$10='Input|General'!$G$9,'Input|Reported opex'!R45,0)","v":0},{"$f":"IF(S$10='Input|General'!$G$9,'Input|Reported opex'!S45,0)","v":0}]
[null,null,"Total reported opex","Calculated",{"$f":"$E$8","v":"$millions"},{"$f":"$F$8","v":"2016-17"},null,null,null,{"$f":"J12*IF($F12=\"nominal\",LOOKUP($F13,Nominal_to_Real,'Input|Rate of change'!K$23:K$26),INDEX('Input|Rate of change'!$C$14:$O$19,MATCH('Calc|Opex forecast'!$F12,'Input|Rate of change'!$C$14:$C$19,0),MATCH('Calc|Opex forecast'!$F13,'Input|Rate of change'!$C$14:$O$14,0)))*IF($E12=\"$millions\",1000000,IF($E12=\"$000\",1000,1))/IF($E13=\"$millions\",1000000,IF($E13=\"$000\",1000,1))","v":84.778187251490181},{"$f":"K12*IF($F12=\"nominal\",LOOKUP($F13,Nominal_to_Real,'Input|Rate of change'!L$23:L$26),INDEX('Input|Rate of change'!$C$14:$O$19,MATCH('Calc|Opex forecast'!$F12,'Input|Rate of change'!$C$14:$C$19,0),MATCH('Calc|Opex forecast'!$F13,'Input|Rate of change'!$C$14:$O$14,0)))*IF($E12=\"$millions\",1000000,IF($E12=\"$000\",1000,1))/IF($E13=\"$millions\",1000000,IF($E13=\"$000\",1000,1))","v":0},{"$f":"L12*IF($F12=\"nominal\",LOOKUP($F13,Nominal_to_Real,'Input|Rate of change'!M$23:M$26),INDEX('Input|Rate of change'!$C$14:$O$19,MATCH('Calc|Opex forecast'!$F12,'Input|Rate of change'!$C$14:$C$19,0),MATCH('Calc|Opex forecast'!$F13,'Input|Rate of change'!$C$14:$O$14,0)))*IF($E12=\"$millions\",1000000,IF($E12=\"$000\",1000,1))/IF($E13=\"$millions\",1000000,IF($E13=\"$000\",1000,1))","v":0},{"$f":"M12*IF($F12=\"nominal\",LOOKUP($F13,Nominal_to_Real,'Input|Rate of change'!N$23:N$26),INDEX('Input|Rate of change'!$C$14:$O$19,MATCH('Calc|Opex forecast'!$F12,'Input|Rate of change'!$C$14:$C$19,0),MATCH('Calc|Opex forecast'!$F13,'Input|Rate of change'!$C$14:$O$14,0)))*IF($E12=\"$millions\",1000000,IF($E12=\"$000\",1000,1))/IF($E13=\"$millions\",1000000,IF($E13=\"$000\",1000,1))","v":0},{"$f":"N12*IF($F12=\"nominal\",LOOKUP($F13,Nominal_to_Real,'Input|Rate of change'!O$23:O$26),INDEX('Input|Rate of change'!$C$14:$O$19,MATCH('Calc|Opex forecast'!$F12,'Input|Rate of change'!$C$14:$C$19,0),MATCH('Calc|Opex forecast'!$F13,'Input|Rate of change'!$C$14:$O$14,0)))*IF($E12=\"$millions\",1000000,IF($E12=\"$000\",1000,1))/IF($E13=\"$millions\",1000000,IF($E13=\"$000\",1000,1))","v":0},{"$f":"O12*IF($F12=\"nominal\",LOOKUP($F13,Nominal_to_Real,'Input|Rate of change'!P$23:P$26),INDEX('Input|Rate of change'!$C$14:$O$19,MATCH('Calc|Opex forecast'!$F12,'Input|Rate of change'!$C$14:$C$19,0),MATCH('Calc|Opex forecast'!$F13,'Input|Rate of change'!$C$14:$O$14,0)))*IF($E12=\"$millions\",1000000,IF($E12=\"$000\",1000,1))/IF($E13=\"$millions\",1000000,IF($E13=\"$000\",1000,1))","v":0},{"$f":"P12*IF($F12=\"nominal\",LOOKUP($F13,Nominal_to_Real,'Input|Rate of change'!Q$23:Q$26),INDEX('Input|Rate of change'!$C$14:$O$19,MATCH('Calc|Opex forecast'!$F12,'Input|Rate of change'!$C$14:$C$19,0),MATCH('Calc|Opex forecast'!$F13,'Input|Rate of change'!$C$14:$O$14,0)))*IF($E12=\"$millions\",1000000,IF($E12=\"$000\",1000,1))/IF($E13=\"$millions\",1000000,IF($E13=\"$000\",1000,1))","v":0},{"$f":"Q12*IF($F12=\"nominal\",LOOKUP($F13,Nominal_to_Real,'Input|Rate of change'!R$23:R$26),INDEX('Input|Rate of change'!$C$14:$O$19,MATCH('Calc|Opex forecast'!$F12,'Input|Rate of change'!$C$14:$C$19,0),MATCH('Calc|Opex forecast'!$F13,'Input|Rate of change'!$C$14:$O$14,0)))*IF($E12=\"$millions\",1000000,IF($E12=\"$000\",1000,1))/IF($E13=\"$millions\",1000000,IF($E13=\"$000\",1000,1))","v":0},{"$f":"R12*IF($F12=\"nominal\",LOOKUP($F13,Nominal_to_Real,'Input|Rate of change'!S$23:S$26),INDEX('Input|Rate of change'!$C$14:$O$19,MATCH('Calc|Opex forecast'!$F12,'Input|Rate of change'!$C$14:$C$19,0),MATCH('Calc|Opex forecast'!$F13,'Input|Rate of change'!$C$14:$O$14,0)))*IF($E12=\"$millions\",1000000,IF($E12=\"$000\",1000,1))/IF($E13=\"$millions\",1000000,IF($E13=\"$000\",1000,1))","v":0},{"$f":"S12*IF($F12=\"nominal\",LOOKUP($F13,Nominal_to_Real,'Input|Rate of change'!T$23:T$26),INDEX('Input|Rate of change'!$C$14:$O$19,MATCH('Calc|Opex forecast'!$F12,'Input|Rate of change'!$C$14:$C$19,0),MATCH('Calc|Opex forecast'!$F13,'Input|Rate of change'!$C$14:$O$14,0)))*IF($E12=\"$millions\",1000000,IF($E12=\"$000\",1000,1))/IF($E13=\"$millions\",1000000,IF($E13=\"$000\",1000,1))","v":0}]
[null,null,"Total base year opex allowance","Inputs|Reported opex",{"$f":"'Input|Reported opex'!E24","v":"$millions"},{"$f":"'Input|Reported opex'!F24","v":"2013-14"},null,null,null,{"$f":"IF(J$10='Input|General'!$G$9,'Input|Reported opex'!J24,0)","v":80.38522259927808},{"$f":"IF(K$10='Input|General'!$G$9,'Input|Reported opex'!K24,0)","v":0},{"$f":"IF(L$10='Input|General'!$G$9,'Input|Reported opex'!L24,0)","v":0},{"$f":"IF(M$10='Input|General'!$G$9,'Input|Reported opex'!M24,0)","v":0},{"$f":"IF(N$10='Input|General'!$G$9,'Input|Reported opex'!N24,0)","v":0},{"$f":"IF(O$10='Input|General'!$G$9,'Input|Reported opex'!O24,0)","v":0},{"$f":"IF(P$10='Input|General'!$G$9,'Input|Reported opex'!P24,0)","v":0},{"$f":"IF(Q$10='Input|General'!$G$9,'Input|Reported opex'!Q24,0)","v":0},{"$f":"IF(R$10='Input|General'!$G$9,'Input|Reported opex'!R24,0)","v":0},{"$f":"IF(S$10='Input|General'!$G$9,'Input|Reported opex'!S24,0)","v":0}]
[null,null,"Total base year opex allowance","Calculated",{"$f":"$E$8","v":"$millions"},{"$f":"$F$8","v":"2016-17"},null,null,null,{"$f":"J14*IF($F14=\"nominal\",LOOKUP($F15,Nominal_to_Real,'Input|Rate of change'!K$23:K$26),INDEX('Input|Rate of change'!$C$14:$O$19,MATCH('Calc|Opex forecast'!$F14,'Input|Rate of change'!$C$14:$C$19,0),MATCH('Calc|Opex forecast'!$F15,'Input|Rate of change'!$C$14:$O$14,0)))*IF($E14=\"$millions\",1000000,IF($E14=\"$000\",1000,1))/IF($E15=\"$millions\",1000000,IF($E15=\"$000\",1000,1))","v":84.188076642785205},{"$f":"K14*IF($F14=\"nominal\",LOOKUP($F15,Nominal_to_Real,'Input|Rate of change'!L$23:L$26),INDEX('Input|Rate of change'!$C$14:$O$19,MATCH('Calc|Opex forecast'!$F14,'Input|Rate of change'!$C$14:$C$19,0),MATCH('Calc|Opex forecast'!$F15,'Input|Rate of change'!$C$14:$O$14,0)))*IF($E14=\"$millions\",1000000,IF($E14=\"$000\",1000,1))/IF($E15=\"$millions\",1000000,IF($E15=\"$000\",1000,1))","v":0},{"$f":"L14*IF($F14=\"nominal\",LOOKUP($F15,Nominal_to_Real,'Input|Rate of change'!M$23:M$26),INDEX('Input|Rate of change'!$C$14:$O$19,MATCH('Calc|Opex forecast'!$F14,'Input|Rate of change'!$C$14:$C$19,0),MATCH('Calc|Opex forecast'!$F15,'Input|Rate of change'!$C$14:$O$14,0)))*IF($E14=\"$millions\",1000000,IF($E14=\"$000\",1000,1))/IF($E15=\"$millions\",1000000,IF($E15=\"$000\",1000,1))","v":0},{"$f":"M14*IF($F14=\"nominal\",LOOKUP($F15,Nominal_to_Real,'Input|Rate of change'!N$23:N$26),INDEX('Input|Rate of change'!$C$14:$O$19,MATCH('Calc|Opex forecast'!$F14,'Input|Rate of change'!$C$14:$C$19,0),MATCH('Calc|Opex forecast'!$F15,'Input|Rate of change'!$C$14:$O$14,0)))*IF($E14=\"$millions\",1000000,IF($E14=\"$000\",1000,1))/IF($E15=\"$millions\",1000000,IF($E15=\"$000\",1000,1))","v":0},{"$f":"N14*IF($F14=\"nominal\",LOOKUP($F15,Nominal_to_Real,'Input|Rate of change'!O$23:O$26),INDEX('Input|Rate of change'!$C$14:$O$19,MATCH('Calc|Opex forecast'!$F14,'Input|Rate of change'!$C$14:$C$19,0),MATCH('Calc|Opex forecast'!$F15,'Input|Rate of change'!$C$14:$O$14,0)))*IF($E14=\"$millions\",1000000,IF($E14=\"$000\",1000,1))/IF($E15=\"$millions\",1000000,IF($E15=\"$000\",1000,1))","v":0},{"$f":"O14*IF($F14=\"nominal\",LOOKUP($F15,Nominal_to_Real,'Input|Rate of change'!P$23:P$26),INDEX('Input|Rate of change'!$C$14:$O$19,MATCH('Calc|Opex forecast'!$F14,'Input|Rate of change'!$C$14:$C$19,0),MATCH('Calc|Opex forecast'!$F15,'Input|Rate of change'!$C$14:$O$14,0)))*IF($E14=\"$millions\",1000000,IF($E14=\"$000\",1000,1))/IF($E15=\"$millions\",1000000,IF($E15=\"$000\",1000,1))","v":0},{"$f":"P14*IF($F14=\"nominal\",LOOKUP($F15,Nominal_to_Real,'Input|Rate of change'!Q$23:Q$26),INDEX('Input|Rate of change'!$C$14:$O$19,MATCH('Calc|Opex forecast'!$F14,'Input|Rate of change'!$C$14:$C$19,0),MATCH('Calc|Opex forecast'!$F15,'Input|Rate of change'!$C$14:$O$14,0)))*IF($E14=\"$millions\",1000000,IF($E14=\"$000\",1000,1))/IF($E15=\"$millions\",1000000,IF($E15=\"$000\",1000,1))","v":0},{"$f":"Q14*IF($F14=\"nominal\",LOOKUP($F15,Nominal_to_Real,'Input|Rate of change'!R$23:R$26),INDEX('Input|Rate of change'!$C$14:$O$19,MATCH('Calc|Opex forecast'!$F14,'Input|Rate of change'!$C$14:$C$19,0),MATCH('Calc|Opex forecast'!$F15,'Input|Rate of change'!$C$14:$O$14,0)))*IF($E14=\"$millions\",1000000,IF($E14=\"$000\",1000,1))/IF($E15=\"$millions\",1000000,IF($E15=\"$000\",1000,1))","v":0},{"$f":"R14*IF($F14=\"nominal\",LOOKUP($F15,Nominal_to_Real,'Input|Rate of change'!S$23:S$26),INDEX('Input|Rate of change'!$C$14:$O$19,MATCH('Calc|Opex forecast'!$F14,'Input|Rate of change'!$C$14:$C$19,0),MATCH('Calc|Opex forecast'!$F15,'Input|Rate of change'!$C$14:$O$14,0)))*IF($E14=\"$millions\",1000000,IF($E14=\"$000\",1000,1))/IF($E15=\"$millions\",1000000,IF($E15=\"$000\",1000,1))","v":0},{"$f":"S14*IF($F14=\"nominal\",LOOKUP($F15,Nominal_to_Real,'Input|Rate of change'!T$23:T$26),INDEX('Input|Rate of change'!$C$14:$O$19,MATCH('Calc|Opex forecast'!$F14,'Input|Rate of change'!$C$14:$C$19,0),MATCH('Calc|Opex forecast'!$F15,'Input|Rate of change'!$C$14:$O$14,0)))*IF($E14=\"$millions\",1000000,IF($E14=\"$000\",1000,1))/IF($E15=\"$millions\",1000000,IF($E15=\"$000\",1000,1))","v":0}]
[null,null,"Total final year opex allowance","Inputs|Reported opex",{"$f":"'Input|Reported opex'!E24","v":"$millions"},{"$f":"'Input|Reported opex'!F24","v":"2013-14"},null,null,null,{"$f":"IF(J$10='Input|General'!$G$10,'Input|Reported opex'!J24,0)","v":0},{"$f":"IF(K$10='Input|General'!$G$10,'Input|Reported opex'!K24,0)","v":0},{"$f":"IF(L$10='Input|General'!$G$10,'Input|Reported opex'!L24,0)","v":83.227687199980238},{"$f":"IF(M$10='Input|General'!$G$10,'Input|Reported opex'!M24,0)","v":0},{"$f":"IF(N$10='Input|General'!$G$10,'Input|Reported opex'!N24,0)","v":0},{"$f":"IF(O$10='Input|General'!$G$10,'Input|Reported opex'!O24,0)","v":0},{"$f":"IF(P$10='Input|General'!$G$10,'Input|Reported opex'!P24,0)","v":0},{"$f":"IF(Q$10='Input|General'!$G$10,'Input|Reported opex'!Q24,0)","v":0},{"$f":"IF(R$10='Input|General'!$G$10,'Input|Reported opex'!R24,0)","v":0},{"$f":"IF(S$10='Input|General'!$G$10,'Input|Reported opex'!S24,0)","v":0}]
[null,null,"Total final year opex allowance","Calculated",{"$f":"$E$8","v":"$millions"},{"$f":"$F$8","v":"2016-17"},null,null,null,{"$f":"J16*IF($F16=\"nominal\",LOOKUP($F17,Nominal_to_Real,'Input|Rate of change'!K$23:K$26),INDEX('Input|Rate of change'!$C$14:$O$19,MATCH('Calc|Opex forecast'!$F16,'Input|Rate of change'!$C$14:$C$19,0),MATCH('Calc|Opex forecast'!$F17,'Input|Rate of change'!$C$14:$O$14,0)))*IF($E16=\"$millions\",1000000,IF($E16=\"$000\",1000,1))/IF($E17=\"$millions\",1000000,IF($E17=\"$000\",1000,1))","v":0},{"$f":"K16*IF($F16=\"nominal\",LOOKUP($F17,Nominal_to_Real,'Input|Rate of change'!L$23:L$26),INDEX('Input|Rate of change'!$C$14:$O$19,MATCH('Calc|Opex forecast'!$F16,'Input|Rate of change'!$C$14:$C$19,0),MATCH('Calc|Opex forecast'!$F17,'Input|Rate of change'!$C$14:$O$14,0)))*IF($E16=\"$millions\",1000000,IF($E16=\"$000\",1000,1))/IF($E17=\"$millions\",1000000,IF($E17=\"$000\",1000,1))","v":0},{"$f":"L16*IF($F16=\"nominal\",LOOKUP($F17,Nominal_to_Real,'Input|Rate of change'!M$23:M$26),INDEX('Input|Rate of change'!$C$14:$O$19,MATCH('Calc|Opex forecast'!$F16,'Input|Rate of change'!$C$14:$C$19,0),MATCH('Calc|Opex forecast'!$F17,'Input|Rate of change'!$C$14:$O$14,0)))*IF($E16=\"$millions\",1000000,IF($E16=\"$000\",1000,1))/IF($E17=\"$millions\",1000000,IF($E17=\"$000\",1000,1))","v":87.165012202835101},{"$f":"M16*IF($F16=\"nominal\",LOOKUP($F17,Nominal_to_Real,'Input|Rate of change'!N$23:N$26),INDEX('Input|Rate of change'!$C$14:$O$19,MATCH('Calc|Opex forecast'!$F16,'Input|Rate of change'!$C$14:$C$19,0),MATCH('Calc|Opex forecast'!$F17,'Input|Rate of change'!$C$14:$O$14,0)))*IF($E16=\"$millions\",1000000,IF($E16=\"$000\",1000,1))/IF($E17=\"$millions\",1000000,IF($E17=\"$000\",1000,1))","v":0},{"$f":"N16*IF($F16=\"nominal\",LOOKUP($F17,Nominal_to_Real,'Input|Rate of change'!O$23:O$26),INDEX('Input|Rate of change'!$C$14:$O$19,MATCH('Calc|Opex forecast'!$F16,'Input|Rate of change'!$C$14:$C$19,0),MATCH('Calc|Opex forecast'!$F17,'Input|Rate of change'!$C$14:$O$14,0)))*IF($E16=\"$millions\",1000000,IF($E16=\"$000\",1000,1))/IF($E17=\"$millions\",1000000,IF($E17=\"$000\",1000,1))","v":0},{"$f":"O16*IF($F16=\"nominal\",LOOKUP($F17,Nominal_to_Real,'Input|Rate of change'!P$23:P$26),INDEX('Input|Rate of change'!$C$14:$O$19,MATCH('Calc|Opex forecast'!$F16,'Input|Rate of change'!$C$14:$C$19,0),MATCH('Calc|Opex forecast'!$F17,'Input|Rate of change'!$C$14:$O$14,0)))*IF($E16=\"$millions\",1000000,IF($E16=\"$000\",1000,1))/IF($E17=\"$millions\",1000000,IF($E17=\"$000\",1000,1))","v":0},{"$f":"P16*IF($F16=\"nominal\",LOOKUP($F17,Nominal_to_Real,'Input|Rate of change'!Q$23:Q$26),INDEX('Input|Rate of change'!$C$14:$O$19,MATCH('Calc|Opex forecast'!$F16,'Input|Rate of change'!$C$14:$C$19,0),MATCH('Calc|Opex forecast'!$F17,'Input|Rate of change'!$C$14:$O$14,0)))*IF($E16=\"$millions\",1000000,IF($E16=\"$000\",1000,1))/IF($E17=\"$millions\",1000000,IF($E17=\"$000\",1000,1))","v":0},{"$f":"Q16*IF($F16=\"nominal\",LOOKUP($F17,Nominal_to_Real,'Input|Rate of change'!R$23:R$26),INDEX('Input|Rate of change'!$C$14:$O$19,MATCH('Calc|Opex forecast'!$F16,'Input|Rate of change'!$C$14:$C$19,0),MATCH('Calc|Opex forecast'!$F17,'Input|Rate of change'!$C$14:$O$14,0)))*IF($E16=\"$millions\",1000000,IF($E16=\"$000\",1000,1))/IF($E17=\"$millions\",1000000,IF($E17=\"$000\",1000,1))","v":0},{"$f":"R16*IF($F16=\"nominal\",LOOKUP($F17,Nominal_to_Real,'Input|Rate of change'!S$23:S$26),INDEX('Input|Rate of change'!$C$14:$O$19,MATCH('Calc|Opex forecast'!$F16,'Input|Rate of change'!$C$14:$C$19,0),MATCH('Calc|Opex forecast'!$F17,'Input|Rate of change'!$C$14:$O$14,0)))*IF($E16=\"$millions\",1000000,IF($E16=\"$000\",1000,1))/IF($E17=\"$millions\",1000000,IF($E17=\"$000\",1000,1))","v":0},{"$f":"S16*IF($F16=\"nominal\",LOOKUP($F17,Nominal_to_Real,'Input|Rate of change'!T$23:T$26),INDEX('Input|Rate of change'!$C$14:$O$19,MATCH('Calc|Opex forecast'!$F16,'Input|Rate of change'!$C$14:$C$19,0),MATCH('Calc|Opex forecast'!$F17,'Input|Rate of change'!$C$14:$O$14,0)))*IF($E16=\"$millions\",1000000,IF($E16=\"$000\",1000,1))/IF($E17=\"$millions\",1000000,IF($E17=\"$000\",1000,1))","v":0}]
[]
[null,null,"Estimated final year opex","Calculated",{"$f":"$E$8","v":"$millions"},{"$f":"$F$8","v":"2016-17"},null,null,null,{"$f":"IF(J$10='Input|General'!$G$10,SUM($J13:$S13)-SUM($J15:$S15)+SUM($J17:$S17),0)","v":0},{"$f":"IF(K$10='Input|General'!$G$10,SUM($J13:$S13)-SUM($J15:$S15)+SUM($J17:$S17),0)","v":0},{"$f":"IF(L$10='Input|General'!$G$10,SUM($J13:$S13)-SUM($J15:$S15)+SUM($J17:$S17),0)","v":87.755122811540076},{"$f":"IF(M$10='Input|General'!$G$10,SUM($J13:$S13)-SUM($J15:$S15)+SUM($J17:$S17),0)","v":0},{"$f":"IF(N$10='Input|General'!$G$10,SUM($J13:$S13)-SUM($J15:$S15)+SUM($J17:$S17),0)","v":0},{"$f":"IF(O$10='Input|General'!$G$10,SUM($J13:$S13)-SUM($J15:$S15)+SUM($J17:$S17),0)","v":0},{"$f":"IF(P$10='Input|General'!$G$10,SUM($J13:$S13)-SUM($J15:$S15)+SUM($J17:$S17),0)","v":0},{"$f":"IF(Q$10='Input|General'!$G$10,SUM($J13:$S13)-SUM($J15:$S15)+SUM($J17:$S17),0)","v":0},{"$f":"IF(R$10='Input|General'!$G$10,SUM($J13:$S13)-SUM($J15:$S15)+SUM($J17:$S17),0)","v":0},{"$f":"IF(S$10='Input|General'!$G$10,SUM($J13:$S13)-SUM($J15:$S15)+SUM($J17:$S17),0)","v":0}]
[]
[null,null,{"$f":"'Input|Reported opex'!$C$50","v":"Adjustment 1"},"Inputs|Reported opex",{"$f":"'Input|Reported opex'!E50","v":"$millions"},{"$f":"'Input|Reported opex'!F50","v":"2016-17"},null,null,{"$f":"IF(I$10='Input|General'!$G$10,'Input|Reported opex'!I50,0)","v":0},{"$f":"IF(J$10='Input|General'!$G$10,'Input|Reported opex'!J50,0)","v":0},{"$f":"IF(K$10='Input|General'!$G$10,'Input|Reported opex'!K50,0)","v":0},{"$f":"IF(L$10='Input|General'!$G$10,'Input|Reported opex'!L50,0)","v":0},{"$f":"IF(M$10='Input|General'!$G$10,'Input|Reported opex'!M50,0)","v":0},{"$f":"IF(N$10='Input|General'!$G$10,'Input|Reported opex'!N50,0)","v":0},{"$f":"IF(O$10='Input|General'!$G$10,'Input|Reported opex'!O50,0)","v":0},{"$f":"IF(P$10='Input|General'!$G$10,'Input|Reported opex'!P50,0)","v":0},{"$f":"IF(Q$10='Input|General'!$G$10,'Input|Reported opex'!Q50,0)","v":0},{"$f":"IF(R$10='Input|General'!$G$10,'Input|Reported opex'!R50,0)","v":0},{"$f":"IF(S$10='Input|General'!$G$10,'Input|Reported opex'!S50,0)","v":0}]
[null,null,{"$f":"C21","v":"Adjustment 1"},"Calculated",{"$f":"$E$8","v":"$millions"},{"$f":"$F$8","v":"2016-17"},null,null,null,{"$f":"J21*IF($F21=\"nominal\",LOOKUP($F22,Nominal_to_Real,'Input|Rate of change'!K$23:K$26),INDEX('Input|Rate of change'!$C$14:$O$19,MATCH('Calc|Opex forecast'!$F21,'Input|Rate of change'!$C$14:$C$19,0),MATCH('Calc|Opex forecast'!$F22,'Input|Rate of change'!$C$14:$O$14,0)))*IF($E21=\"$millions\",1000000,IF($E21=\"$000\",1000,1))/IF($E22=\"$millions\",1000000,IF($E22=\"$000\",1000,1))","v":0},{"$f":"K21*IF($F21=\"nominal\",LOOKUP($F22,Nominal_to_Real,'Input|Rate of change'!L$23:L$26),INDEX('Input|Rate of change'!$C$14:$O$19,MATCH('Calc|Opex forecast'!$F21,'Input|Rate of change'!$C$14:$C$19,0),MATCH('Calc|Opex forecast'!$F22,'Input|Rate of change'!$C$14:$O$14,0)))*IF($E21=\"$millions\",1000000,IF($E21=\"$000\",1000,1))/IF($E22=\"$millions\",1000000,IF($E22=\"$000\",1000,1))","v":0},{"$f":"L21*IF($F21=\"nominal\",LOOKUP($F22,Nominal_to_Real,'Input|Rate of change'!M$23:M$26),INDEX('Input|Rate of change'!$C$14:$O$19,MATCH('Calc|Opex forecast'!$F21,'Input|Rate of change'!$C$14:$C$19,0),MATCH('Calc|Opex forecast'!$F22,'Input|Rate of change'!$C$14:$O$14,0)))*IF($E21=\"$millions\",1000000,IF($E21=\"$000\",1000,1))/IF($E22=\"$millions\",1000000,IF($E22=\"$000\",1000,1))","v":0},{"$f":"M21*IF($F21=\"nominal\",LOOKUP($F22,Nominal_to_Real,'Input|Rate of change'!N$23:N$26),INDEX('Input|Rate of change'!$C$14:$O$19,MATCH('Calc|Opex forecast'!$F21,'Input|Rate of change'!$C$14:$C$19,0),MATCH('Calc|Opex forecast'!$F22,'Input|Rate of change'!$C$14:$O$14,0)))*IF($E21=\"$millions\",1000000,IF($E21=\"$000\",1000,1))/IF($E22=\"$millions\",1000000,IF($E22=\"$000\",1000,1))","v":0},{"$f":"N21*IF($F21=\"nominal\",LOOKUP($F22,Nominal_to_Real,'Input|Rate of change'!O$23:O$26),INDEX('Input|Rate of change'!$C$14:$O$19,MATCH('Calc|Opex forecast'!$F21,'Input|Rate of change'!$C$14:$C$19,0),MATCH('Calc|Opex forecast'!$F22,'Input|Rate of change'!$C$14:$O$14,0)))*IF($E21=\"$millions\",1000000,IF($E21=\"$000\",1000,1))/IF($E22=\"$millions\",1000000,IF($E22=\"$000\",1000,1))","v":0},{"$f":"O21*IF($F21=\"nominal\",LOOKUP($F22,Nominal_to_Real,'Input|Rate of change'!P$23:P$26),INDEX('Input|Rate of change'!$C$14:$O$19,MATCH('Calc|Opex forecast'!$F21,'Input|Rate of change'!$C$14:$C$19,0),MATCH('Calc|Opex forecast'!$F22,'Input|Rate of change'!$C$14:$O$14,0)))*IF($E21=\"$millions\",1000000,IF($E21=\"$000\",1000,1))/IF($E22=\"$millions\",1000000,IF($E22=\"$000\",1000,1))","v":0},{"$f":"P21*IF($F21=\"nominal\",LOOKUP($F22,Nominal_to_Real,'Input|Rate of change'!Q$23:Q$26),INDEX('Input|Rate of change'!$C$14:$O$19,MATCH('Calc|Opex forecast'!$F21,'Input|Rate of change'!$C$14:$C$19,0),MATCH('Calc|Opex forecast'!$F22,'Input|Rate of change'!$C$14:$O$14,0)))*IF($E21=\"$millions\",1000000,IF($E21=\"$000\",1000,1))/IF($E22=\"$millions\",1000000,IF($E22=\"$000\",1000,1))","v":0},{"$f":"Q21*IF($F21=\"nominal\",LOOKUP($F22,Nominal_to_Real,'Input|Rate of change'!R$23:R$26),INDEX('Input|Rate of change'!$C$14:$O$19,MATCH('Calc|Opex forecast'!$F21,'Input|Rate of change'!$C$14:$C$19,0),MATCH('Calc|Opex forecast'!$F22,'Input|Rate of change'!$C$14:$O$14,0)))*IF($E21=\"$millions\",1000000,IF($E21=\"$000\",1000,1))/IF($E22=\"$millions\",1000000,IF($E22=\"$000\",1000,1))","v":0},{"$f":"R21*IF($F21=\"nominal\",LOOKUP($F22,Nominal_to_Real,'Input|Rate of change'!S$23:S$26),INDEX('Input|Rate of change'!$C$14:$O$19,MATCH('Calc|Opex forecast'!$F21,'Input|Rate of change'!$C$14:$C$19,0),MATCH('Calc|Opex forecast'!$F22,'Input|Rate of change'!$C$14:$O$14,0)))*IF($E21=\"$millions\",1000000,IF($E21=\"$000\",1000,1))/IF($E22=\"$millions\",1000000,IF($E22=\"$000\",1000,1))","v":0},{"$f":"S21*IF($F21=\"nominal\",LOOKUP($F22,Nominal_to_Real,'Input|Rate of change'!T$23:T$26),INDEX('Input|Rate of change'!$C$14:$O$19,MATCH('Calc|Opex forecast'!$F21,'Input|Rate of change'!$C$14:$C$19,0),MATCH('Calc|Opex forecast'!$F22,'Input|Rate of change'!$C$14:$O$14,0)))*IF($E21=\"$millions\",1000000,IF($E21=\"$000\",1000,1))/IF($E22=\"$millions\",1000000,IF($E22=\"$000\",1000,1))","v":0}]
[]
[null,null,{"$f":"'Input|Reported opex'!$C$51","v":"Adjustment 2"},"Inputs|Reported opex",{"$f":"'Input|Reported opex'!E51","v":"$millions"},{"$f":"'Input|Reported opex'!F51","v":"2016-17"},null,null,null,{"$f":"IF(J$10='Input|General'!$G$10,'Input|Reported opex'!J51,0)","v":0},{"$f":"IF(K$10='Input|General'!$G$10,'Input|Reported opex'!K51,0)","v":0},{"$f":"IF(L$10='Input|General'!$G$10,'Input|Reported opex'!L51,0)","v":0},{"$f":"IF(M$10='Input|General'!$G$10,'Input|Reported opex'!M51,0)","v":0},{"$f":"IF(N$10='Input|General'!$G$10,'Input|Reported opex'!N51,0)","v":0},{"$f":"IF(O$10='Input|General'!$G$10,'Input|Reported opex'!O51,0)","v":0},{"$f":"IF(P$10='Input|General'!$G$10,'Input|Reported opex'!P51,0)","v":0},{"$f":"IF(Q$10='Input|General'!$G$10,'Input|Reported opex'!Q51,0)","v":0}]
[null,null,{"$f":"C24","v":"Adjustment 2"},"Calculated",{"$f":"$E$8","v":"$millions"},{"$f":"$F$8","v":"2016-17"},null,null,null,{"$f":"J24*IF($F24=\"nominal\",LOOKUP($F25,Nominal_to_Real,'Input|Rate of change'!K$23:K$26),INDEX('Input|Rate of change'!$C$14:$O$19,MATCH('Calc|Opex forecast'!$F24,'Input|Rate of change'!$C$14:$C$19,0),MATCH('Calc|Opex forecast'!$F25,'Input|Rate of change'!$C$14:$O$14,0)))*IF($E24=\"$millions\",1000000,IF($E24=\"$000\",1000,1))/IF($E25=\"$millions\",1000000,IF($E25=\"$000\",1000,1))","v":0},{"$f":"K24*IF($F24=\"nominal\",LOOKUP($F25,Nominal_to_Real,'Input|Rate of change'!L$23:L$26),INDEX('Input|Rate of change'!$C$14:$O$19,MATCH('Calc|Opex forecast'!$F24,'Input|Rate of change'!$C$14:$C$19,0),MATCH('Calc|Opex forecast'!$F25,'Input|Rate of change'!$C$14:$O$14,0)))*IF($E24=\"$millions\",1000000,IF($E24=\"$000\",1000,1))/IF($E25=\"$millions\",1000000,IF($E25=\"$000\",1000,1))","v":0},{"$f":"L24*IF($F24=\"nominal\",LOOKUP($F25,Nominal_to_Real,'Input|Rate of change'!M$23:M$26),INDEX('Input|Rate of change'!$C$14:$O$19,MATCH('Calc|Opex forecast'!$F24,'Input|Rate of change'!$C$14:$C$19,0),MATCH('Calc|Opex forecast'!$F25,'Input|Rate of change'!$C$14:$O$14,0)))*IF($E24=\"$millions\",1000000,IF($E24=\"$000\",1000,1))/IF($E25=\"$millions\",1000000,IF($E25=\"$000\",1000,1))","v":0},{"$f":"M24*IF($F24=\"nominal\",LOOKUP($F25,Nominal_to_Real,'Input|Rate of change'!N$23:N$26),INDEX('Input|Rate of change'!$C$14:$O$19,MATCH('Calc|Opex forecast'!$F24,'Input|Rate of change'!$C$14:$C$19,0),MATCH('Calc|Opex forecast'!$F25,'Input|Rate of change'!$C$14:$O$14,0)))*IF($E24=\"$millions\",1000000,IF($E24=\"$000\",1000,1))/IF($E25=\"$millions\",1000000,IF($E25=\"$000\",1000,1))","v":0},{"$f":"N24*IF($F24=\"nominal\",LOOKUP($F25,Nominal_to_Real,'Input|Rate of change'!O$23:O$26),INDEX('Input|Rate of change'!$C$14:$O$19,MATCH('Calc|Opex forecast'!$F24,'Input|Rate of change'!$C$14:$C$19,0),MATCH('Calc|Opex forecast'!$F25,'Input|Rate of change'!$C$14:$O$14,0)))*IF($E24=\"$millions\",1000000,IF($E24=\"$000\",1000,1))/IF($E25=\"$millions\",1000000,IF($E25=\"$000\",1000,1))","v":0},{"$f":"O24*IF($F24=\"nominal\",LOOKUP($F25,Nominal_to_Real,'Input|Rate of change'!P$23:P$26),INDEX('Input|Rate of change'!$C$14:$O$19,MATCH('Calc|Opex forecast'!$F24,'Input|Rate of change'!$C$14:$C$19,0),MATCH('Calc|Opex forecast'!$F25,'Input|Rate of change'!$C$14:$O$14,0)))*IF($E24=\"$millions\",1000000,IF($E24=\"$000\",1000,1))/IF($E25=\"$millions\",1000000,IF($E25=\"$000\",1000,1))","v":0},{"$f":"P24*IF($F24=\"nominal\",LOOKUP($F25,Nominal_to_Real,'Input|Rate of change'!Q$23:Q$26),INDEX('Input|Rate of change'!$C$14:$O$19,MATCH('Calc|Opex forecast'!$F24,'Input|Rate of change'!$C$14:$C$19,0),MATCH('Calc|Opex forecast'!$F25,'Input|Rate of change'!$C$14:$O$14,0)))*IF($E24=\"$millions\",1000000,IF($E24=\"$000\",1000,1))/IF($E25=\"$millions\",1000000,IF($E25=\"$000\",1000,1))","v":0},{"$f":"Q24*IF($F24=\"nominal\",LOOKUP($F25,Nominal_to_Real,'Input|Rate of change'!R$23:R$26),INDEX('Input|Rate of change'!$C$14:$O$19,MATCH('Calc|Opex forecast'!$F24,'Input|Rate of change'!$C$14:$C$19,0),MATCH('Calc|Opex forecast'!$F25,'Input|Rate of change'!$C$14:$O$14,0)))*IF($E24=\"$millions\",1000000,IF($E24=\"$000\",1000,1))/IF($E25=\"$millions\",1000000,IF($E25=\"$000\",1000,1))","v":0},{"$f":"R24*IF($F24=\"nominal\",LOOKUP($F25,Nominal_to_Real,'Input|Rate of change'!S$23:S$26),INDEX('Input|Rate of change'!$C$14:$O$19,MATCH('Calc|Opex forecast'!$F24,'Input|Rate of change'!$C$14:$C$19,0),MATCH('Calc|Opex forecast'!$F25,'Input|Rate of change'!$C$14:$O$14,0)))*IF($E24=\"$millions\",1000000,IF($E24=\"$000\",1000,1))/IF($E25=\"$millions\",1000000,IF($E25=\"$000\",1000,1))","v":0},{"$f":"S24*IF($F24=\"nominal\",LOOKUP($F25,Nominal_to_Real,'Input|Rate of change'!T$23:T$26),INDEX('Input|Rate of change'!$C$14:$O$19,MATCH('Calc|Opex forecast'!$F24,'Input|Rate of change'!$C$14:$C$19,0),MATCH('Calc|Opex forecast'!$F25,'Input|Rate of change'!$C$14:$O$14,0)))*IF($E24=\"$millions\",1000000,IF($E24=\"$000\",1000,1))/IF($E25=\"$millions\",1000000,IF($E25=\"$000\",1000,1))","v":0}]
[]
[null,null,{"$f":"'Input|Reported opex'!$C$52","v":"Adjustment 3"},"Inputs|Reported opex",{"$f":"'Input|Reported opex'!$E$52","v":"$millions"},{"$f":"'Input|Reported opex'!$F$52","v":"2016-17"},null,null,null,{"$f":"IF(J$10='Input|General'!$G$10,'Input|Reported opex'!J52,0)","v":0},{"$f":"IF(K$10='Input|General'!$G$10,'Input|Reported opex'!K52,0)","v":0},{"$f":"IF(L$10='Input|General'!$G$10,'Input|Reported opex'!L52,0)","v":0},{"$f":"IF(M$10='Input|General'!$G$10,'Input|Reported opex'!M52,0)","v":0},{"$f":"IF(N$10='Input|General'!$G$10,'Input|Reported opex'!N52,0)","v":0},{"$f":"IF(O$10='Input|General'!$G$10,'Input|Reported opex'!O52,0)","v":0},{"$f":"IF(P$10='Input|General'!$G$10,'Input|Reported opex'!P52,0)","v":0},{"$f":"IF(Q$10='Input|General'!$G$10,'Input|Reported opex'!Q52,0)","v":0}]
[null,null,{"$f":"C27","v":"Adjustment 3"},"Calculated",{"$f":"$E$8","v":"$millions"},{"$f":"$F$8","v":"2016-17"},null,null,null,{"$f":"J27*IF($F27=\"nominal\",LOOKUP($F28,Nominal_to_Real,'Input|Rate of change'!K$23:K$26),INDEX('Input|Rate of change'!$C$14:$O$19,MATCH('Calc|Opex forecast'!$F27,'Input|Rate of change'!$C$14:$C$19,0),MATCH('Calc|Opex forecast'!$F28,'Input|Rate of change'!$C$14:$O$14,0)))*IF($E27=\"$millions\",1000000,IF($E27=\"$000\",1000,1))/IF($E28=\"$millions\",1000000,IF($E28=\"$000\",1000,1))","v":0},{"$f":"K27*IF($F27=\"nominal\",LOOKUP($F28,Nominal_to_Real,'Input|Rate of change'!L$23:L$26),INDEX('Input|Rate of change'!$C$14:$O$19,MATCH('Calc|Opex forecast'!$F27,'Input|Rate of change'!$C$14:$C$19,0),MATCH('Calc|Opex forecast'!$F28,'Input|Rate of change'!$C$14:$O$14,0)))*IF($E27=\"$millions\",1000000,IF($E27=\"$000\",1000,1))/IF($E28=\"$millions\",1000000,IF($E28=\"$000\",1000,1))","v":0},{"$f":"L27*IF($F27=\"nominal\",LOOKUP($F28,Nominal_to_Real,'Input|Rate of change'!M$23:M$26),INDEX('Input|Rate of change'!$C$14:$O$19,MATCH('Calc|Opex forecast'!$F27,'Input|Rate of change'!$C$14:$C$19,0),MATCH('Calc|Opex forecast'!$F28,'Input|Rate of change'!$C$14:$O$14,0)))*IF($E27=\"$millions\",1000000,IF($E27=\"$000\",1000,1))/IF($E28=\"$millions\",1000000,IF($E28=\"$000\",1000,1))","v":0},{"$f":"M27*IF($F27=\"nominal\",LOOKUP($F28,Nominal_to_Real,'Input|Rate of change'!N$23:N$26),INDEX('Input|Rate of change'!$C$14:$O$19,MATCH('Calc|Opex forecast'!$F27,'Input|Rate of change'!$C$14:$C$19,0),MATCH('Calc|Opex forecast'!$F28,'Input|Rate of change'!$C$14:$O$14,0)))*IF($E27=\"$millions\",1000000,IF($E27=\"$000\",1000,1))/IF($E28=\"$millions\",1000000,IF($E28=\"$000\",1000,1))","v":0},{"$f":"N27*IF($F27=\"nominal\",LOOKUP($F28,Nominal_to_Real,'Input|Rate of change'!O$23:O$26),INDEX('Input|Rate of change'!$C$14:$O$19,MATCH('Calc|Opex forecast'!$F27,'Input|Rate of change'!$C$14:$C$19,0),MATCH('Calc|Opex forecast'!$F28,'Input|Rate of change'!$C$14:$O$14,0)))*IF($E27=\"$millions\",1000000,IF($E27=\"$000\",1000,1))/IF($E28=\"$millions\",1000000,IF($E28=\"$000\",1000,1))","v":0},{"$f":"O27*IF($F27=\"nominal\",LOOKUP($F28,Nominal_to_Real,'Input|Rate of change'!P$23:P$26),INDEX('Input|Rate of change'!$C$14:$O$19,MATCH('Calc|Opex forecast'!$F27,'Input|Rate of change'!$C$14:$C$19,0),MATCH('Calc|Opex forecast'!$F28,'Input|Rate of change'!$C$14:$O$14,0)))*IF($E27=\"$millions\",1000000,IF($E27=\"$000\",1000,1))/IF($E28=\"$millions\",1000000,IF($E28=\"$000\",1000,1))","v":0},{"$f":"P27*IF($F27=\"nominal\",LOOKUP($F28,Nominal_to_Real,'Input|Rate of change'!Q$23:Q$26),INDEX('Input|Rate of change'!$C$14:$O$19,MATCH('Calc|Opex forecast'!$F27,'Input|Rate of change'!$C$14:$C$19,0),MATCH('Calc|Opex forecast'!$F28,'Input|Rate of change'!$C$14:$O$14,0)))*IF($E27=\"$millions\",1000000,IF($E27=\"$000\",1000,1))/IF($E28=\"$millions\",1000000,IF($E28=\"$000\",1000,1))","v":0},{"$f":"Q27*IF($F27=\"nominal\",LOOKUP($F28,Nominal_to_Real,'Input|Rate of change'!R$23:R$26),INDEX('Input|Rate of change'!$C$14:$O$19,MATCH('Calc|Opex forecast'!$F27,'Input|Rate of change'!$C$14:$C$19,0),MATCH('Calc|Opex forecast'!$F28,'Input|Rate of change'!$C$14:$O$14,0)))*IF($E27=\"$millions\",1000000,IF($E27=\"$000\",1000,1))/IF($E28=\"$millions\",1000000,IF($E28=\"$000\",1000,1))","v":0}]
[]
[null,null,{"$f":"'Input|Reported opex'!$C$53","v":"Adjustment 4"},"Inputs|Reported opex",{"$f":"'Input|Reported opex'!$E$53","v":"$millions"},{"$f":"'Input|Reported opex'!$F$53","v":"2016-17"},null,null,null,{"$f":"IF(J$10='Input|General'!$G$10,'Input|Reported opex'!J53,0)","v":0},{"$f":"IF(K$10='Input|General'!$G$10,'Input|Reported opex'!K53,0)","v":0},{"$f":"IF(L$10='Input|General'!$G$10,'Input|Reported opex'!L53,0)","v":0},{"$f":"IF(M$10='Input|General'!$G$10,'Input|Reported opex'!M53,0)","v":0},{"$f":"IF(N$10='Input|General'!$G$10,'Input|Reported opex'!N53,0)","v":0},{"$f":"IF(O$10='Input|General'!$G$10,'Input|Reported opex'!O53,0)","v":0},{"$f":"IF(P$10='Input|General'!$G$10,'Input|Reported opex'!P53,0)","v":0},{"$f":"IF(Q$10='Input|General'!$G$10,'Input|Reported opex'!Q53,0)","v":0}]
[null,null,{"$f":"C30","v":"Adjustment 4"},"Calculated",{"$f":"$E$8","v":"$millions"},{"$f":"$F$8","v":"2016-17"},null,null,null,{"$f":"J30*IF($F30=\"nominal\",LOOKUP($F31,Nominal_to_Real,'Input|Rate of change'!K$23:K$26),INDEX('Input|Rate of change'!$C$14:$O$19,MATCH('Calc|Opex forecast'!$F30,'Input|Rate of change'!$C$14:$C$19,0),MATCH('Calc|Opex forecast'!$F31,'Input|Rate of change'!$C$14:$O$14,0)))*IF($E30=\"$millions\",1000000,IF($E30=\"$000\",1000,1))/IF($E31=\"$millions\",1000000,IF($E31=\"$000\",1000,1))","v":0},{"$f":"K30*IF($F30=\"nominal\",LOOKUP($F31,Nominal_to_Real,'Input|Rate of change'!L$23:L$26),INDEX('Input|Rate of change'!$C$14:$O$19,MATCH('Calc|Opex forecast'!$F30,'Input|Rate of change'!$C$14:$C$19,0),MATCH('Calc|Opex forecast'!$F31,'Input|Rate of change'!$C$14:$O$14,0)))*IF($E30=\"$millions\",1000000,IF($E30=\"$000\",1000,1))/IF($E31=\"$millions\",1000000,IF($E31=\"$000\",1000,1))","v":0},{"$f":"L30*IF($F30=\"nominal\",LOOKUP($F31,Nominal_to_Real,'Input|Rate of change'!M$23:M$26),INDEX('Input|Rate of change'!$C$14:$O$19,MATCH('Calc|Opex forecast'!$F30,'Input|Rate of change'!$C$14:$C$19,0),MATCH('Calc|Opex forecast'!$F31,'Input|Rate of change'!$C$14:$O$14,0)))*IF($E30=\"$millions\",1000000,IF($E30=\"$000\",1000,1))/IF($E31=\"$millions\",1000000,IF($E31=\"$000\",1000,1))","v":0},{"$f":"M30*IF($F30=\"nominal\",LOOKUP($F31,Nominal_to_Real,'Input|Rate of change'!N$23:N$26),INDEX('Input|Rate of change'!$C$14:$O$19,MATCH('Calc|Opex forecast'!$F30,'Input|Rate of change'!$C$14:$C$19,0),MATCH('Calc|Opex forecast'!$F31,'Input|Rate of change'!$C$14:$O$14,0)))*IF($E30=\"$millions\",1000000,IF($E30=\"$000\",1000,1))/IF($E31=\"$millions\",1000000,IF($E31=\"$000\",1000,1))","v":0},{"$f":"N30*IF($F30=\"nominal\",LOOKUP($F31,Nominal_to_Real,'Input|Rate of change'!O$23:O$26),INDEX('Input|Rate of change'!$C$14:$O$19,MATCH('Calc|Opex forecast'!$F30,'Input|Rate of change'!$C$14:$C$19,0),MATCH('Calc|Opex forecast'!$F31,'Input|Rate of change'!$C$14:$O$14,0)))*IF($E30=\"$millions\",1000000,IF($E30=\"$000\",1000,1))/IF($E31=\"$millions\",1000000,IF($E31=\"$000\",1000,1))","v":0},{"$f":"O30*IF($F30=\"nominal\",LOOKUP($F31,Nominal_to_Real,'Input|Rate of change'!P$23:P$26),INDEX('Input|Rate of change'!$C$14:$O$19,MATCH('Calc|Opex forecast'!$F30,'Input|Rate of change'!$C$14:$C$19,0),MATCH('Calc|Opex forecast'!$F31,'Input|Rate of change'!$C$14:$O$14,0)))*IF($E30=\"$millions\",1000000,IF($E30=\"$000\",1000,1))/IF($E31=\"$millions\",1000000,IF($E31=\"$000\",1000,1))","v":0},{"$f":"P30*IF($F30=\"nominal\",LOOKUP($F31,Nominal_to_Real,'Input|Rate of change'!Q$23:Q$26),INDEX('Input|Rate of change'!$C$14:$O$19,MATCH('Calc|Opex forecast'!$F30,'Input|Rate of change'!$C$14:$C$19,0),MATCH('Calc|Opex forecast'!$F31,'Input|Rate of change'!$C$14:$O$14,0)))*IF($E30=\"$millions\",1000000,IF($E30=\"$000\",1000,1))/IF($E31=\"$millions\",1000000,IF($E31=\"$000\",1000,1))","v":0},{"$f":"Q30*IF($F30=\"nominal\",LOOKUP($F31,Nominal_to_Real,'Input|Rate of change'!R$23:R$26),INDEX('Input|Rate of change'!$C$14:$O$19,MATCH('Calc|Opex forecast'!$F30,'Input|Rate of change'!$C$14:$C$19,0),MATCH('Calc|Opex forecast'!$F31,'Input|Rate of change'!$C$14:$O$14,0)))*IF($E30=\"$millions\",1000000,IF($E30=\"$000\",1000,1))/IF($E31=\"$millions\",1000000,IF($E31=\"$000\",1000,1))","v":0}]
[]
[null,null,{"$f":"'Input|Reported opex'!$C$54","v":"Adjustment 5"},"Inputs|Reported opex",{"$f":"'Input|Reported opex'!$E$54","v":"$millions"},{"$f":"'Input|Reported opex'!$F$54","v":"2016-17"},null,null,null,{"$f":"IF(J$10='Input|General'!$G$10,'Input|Reported opex'!J54,0)","v":0},{"$f":"IF(K$10='Input|General'!$G$10,'Input|Reported opex'!K54,0)","v":0},{"$f":"IF(L$10='Input|General'!$G$10,'Input|Reported opex'!L54,0)","v":0},{"$f":"IF(M$10='Input|General'!$G$10,'Input|Reported opex'!M54,0)","v":0},{"$f":"IF(N$10='Input|General'!$G$10,'Input|Reported opex'!N54,0)","v":0},{"$f":"IF(O$10='Input|General'!$G$10,'Input|Reported opex'!O54,0)","v":0},{"$f":"IF(P$10='Input|General'!$G$10,'Input|Reported opex'!P54,0)","v":0},{"$f":"IF(Q$10='Input|General'!$G$10,'Input|Reported opex'!Q54,0)","v":0}]
[null,null,{"$f":"C33","v":"Adjustment 5"},"Calculated",{"$f":"$E$8","v":"$millions"},{"$f":"$F$8","v":"2016-17"},null,null,null,{"$f":"J33*IF($F33=\"nominal\",LOOKUP($F34,Nominal_to_Real,'Input|Rate of change'!K$23:K$26),INDEX('Input|Rate of change'!$C$14:$O$19,MATCH('Calc|Opex forecast'!$F33,'Input|Rate of change'!$C$14:$C$19,0),MATCH('Calc|Opex forecast'!$F34,'Input|Rate of change'!$C$14:$O$14,0)))*IF($E33=\"$millions\",1000000,IF($E33=\"$000\",1000,1))/IF($E34=\"$millions\",1000000,IF($E34=\"$000\",1000,1))","v":0},{"$f":"K33*IF($F33=\"nominal\",LOOKUP($F34,Nominal_to_Real,'Input|Rate of change'!L$23:L$26),INDEX('Input|Rate of change'!$C$14:$O$19,MATCH('Calc|Opex forecast'!$F33,'Input|Rate of change'!$C$14:$C$19,0),MATCH('Calc|Opex forecast'!$F34,'Input|Rate of change'!$C$14:$O$14,0)))*IF($E33=\"$millions\",1000000,IF($E33=\"$000\",1000,1))/IF($E34=\"$millions\",1000000,IF($E34=\"$000\",1000,1))","v":0},{"$f":"L33*IF($F33=\"nominal\",LOOKUP($F34,Nominal_to_Real,'Input|Rate of change'!M$23:M$26),INDEX('Input|Rate of change'!$C$14:$O$19,MATCH('Calc|Opex forecast'!$F33,'Input|Rate of change'!$C$14:$C$19,0),MATCH('Calc|Opex forecast'!$F34,'Input|Rate of change'!$C$14:$O$14,0)))*IF($E33=\"$millions\",1000000,IF($E33=\"$000\",1000,1))/IF($E34=\"$millions\",1000000,IF($E34=\"$000\",1000,1))","v":0},{"$f":"M33*IF($F33=\"nominal\",LOOKUP($F34,Nominal_to_Real,'Input|Rate of change'!N$23:N$26),INDEX('Input|Rate of change'!$C$14:$O$19,MATCH('Calc|Opex forecast'!$F33,'Input|Rate of change'!$C$14:$C$19,0),MATCH('Calc|Opex forecast'!$F34,'Input|Rate of change'!$C$14:$O$14,0)))*IF($E33=\"$millions\",1000000,IF($E33=\"$000\",1000,1))/IF($E34=\"$millions\",1000000,IF($E34=\"$000\",1000,1))","v":0},{"$f":"N33*IF($F33=\"nominal\",LOOKUP($F34,Nominal_to_Real,'Input|Rate of change'!O$23:O$26),INDEX('Input|Rate of change'!$C$14:$O$19,MATCH('Calc|Opex forecast'!$F33,'Input|Rate of change'!$C$14:$C$19,0),MATCH('Calc|Opex forecast'!$F34,'Input|Rate of change'!$C$14:$O$14,0)))*IF($E33=\"$millions\",1000000,IF($E33=\"$000\",1000,1))/IF($E34=\"$millions\",1000000,IF($E34=\"$000\",1000,1))","v":0},{"$f":"O33*IF($F33=\"nominal\",LOOKUP($F34,Nominal_to_Real,'Input|Rate of change'!P$23:P$26),INDEX('Input|Rate of change'!$C$14:$O$19,MATCH('Calc|Opex forecast'!$F33,'Input|Rate of change'!$C$14:$C$19,0),MATCH('Calc|Opex forecast'!$F34,'Input|Rate of change'!$C$14:$O$14,0)))*IF($E33=\"$millions\",1000000,IF($E33=\"$000\",1000,1))/IF($E34=\"$millions\",1000000,IF($E34=\"$000\",1000,1))","v":0},{"$f":"P33*IF($F33=\"nominal\",LOOKUP($F34,Nominal_to_Real,'Input|Rate of change'!Q$23:Q$26),INDEX('Input|Rate of change'!$C$14:$O$19,MATCH('Calc|Opex forecast'!$F33,'Input|Rate of change'!$C$14:$C$19,0),MATCH('Calc|Opex forecast'!$F34,'Input|Rate of change'!$C$14:$O$14,0)))*IF($E33=\"$millions\",1000000,IF($E33=\"$000\",1000,1))/IF($E34=\"$millions\",1000000,IF($E34=\"$000\",1000,1))","v":0},{"$f":"Q33*IF($F33=\"nominal\",LOOKUP($F34,Nominal_to_Real,'Input|Rate of change'!R$23:R$26),INDEX('Input|Rate of change'!$C$14:$O$19,MATCH('Calc|Opex forecast'!$F33,'Input|Rate of change'!$C$14:$C$19,0),MATCH('Calc|Opex forecast'!$F34,'Input|Rate of change'!$C$14:$O$14,0)))*IF($E33=\"$millions\",1000000,IF($E33=\"$000\",1000,1))/IF($E34=\"$millions\",1000000,IF($E34=\"$000\",1000,1))","v":0}]
[]
[null,null,"Efficiency adjustment","calculated",{"$f":"$E$8","v":"$millions"},{"$f":"$F$8","v":"2016-17"},null,null,null,{"$f":"SUM(J19,J22,J25)*'Input|Reported opex'!$N$55","v":0},{"$f":"SUM(K19,K22,K25)*'Input|Reported opex'!$N$55","v":0},{"$f":"SUM(L19,L22,L25,L28,L31,L34)*'Input|Reported opex'!$N$55","v":0},{"$f":"SUM(M19,M22,M25)*'Input|Reported opex'!$N$55","v":0},{"$f":"SUM(N19,N22,N25)*'Input|Reported opex'!$N$55","v":0},{"$f":"SUM(O19,O22,O25)*'Input|Reported opex'!$N$55","v":0},{"$f":"SUM(P19,P22,P25)*'Input|Reported opex'!$N$55","v":0},{"$f":"SUM(Q19,Q22,Q25)*'Input|Reported opex'!$N$55","v":0},{"$f":"SUM(R19,R22,R25)*'Input|Reported opex'!$N$55","v":0},{"$f":"SUM(S19,S22,S25)*'Input|Reported opex'!$N$55","v":0}]
[]
[null,null,"Efficiency adjustment final year opex","calculated",{"$f":"$E$8","v":"$millions"},{"$f":"$F$8","v":"2016-17"},null,null,null,{"$f":"SUM(J19,J22,J25,J36)","v":0},0,{"$f":"SUM(L19,L22,L25,L28,L31,L34,L36)","v":87.755122811540076},0,{"$f":"SUM(N19,N22,N25,N36)","v":0},0,0,0,0,{"$f":"SUM(S19,S22,S25,S36)","v":0}]
[]
[null,"Calc | Rate of change"]
[]
[null,null,"Rate of change","Source","Unit","Basis",null,null,null,{"$f":"IF(RIGHT(J$4,2)>=RIGHT('Input|General'!$G$11,2),IF(RIGHT(J$4,2)<=RIGHT('Input|General'!$G$12,2),J$4,\"\"),\"\")","v":""},{"$f":"IF(RIGHT(K$4,2)>=RIGHT('Input|General'!$G$11,2),IF(RIGHT(K$4,2)<=RIGHT('Input|General'!$G$12,2),K$4,\"\"),\"\")","v":""},{"$f":"IF(RIGHT(L$4,2)>=RIGHT('Input|General'!$G$11,2),IF(RIGHT(L$4,2)<=RIGHT('Input|General'!$G$12,2),L$4,\"\"),\"\")","v":""},{"$f":"IF(RIGHT(M$4,2)>=RIGHT('Input|General'!$G$11,2),IF(RIGHT(M$4,2)<=RIGHT('Input|General'!$G$12,2),M$4,\"\"),\"\")","v":"2017-18"},{"$f":"IF(RIGHT(N$4,2)>=RIGHT('Input|General'!$G$11,2),IF(RIGHT(N$4,2)<=RIGHT('Input|General'!$G$12,2),N$4,\"\"),\"\")","v":"2018-19"},{"$f":"IF(RIGHT(O$4,2)>=RIGHT('Input|General'!$G$11,2),IF(RIGHT(O$4,2)<=RIGHT('Input|General'!$G$12,2),O$4,\"\"),\"\")","v":"2019-20"},{"$f":"IF(RIGHT(P$4,2)>=RIGHT('Input|General'!$G$11,2),IF(RIGHT(P$4,2)<=RIGHT('Input|General'!$G$12,2),P$4,\"\"),\"\")","v":"2020-21"},{"$f":"IF(RIGHT(Q$4,2)>=RIGHT('Input|General'!$G$11,2),IF(RIGHT(Q$4,2)<=RIGHT('Input|General'!$G$12,2),Q$4,\"\"),\"\")","v":"2021-22"},{"$f":"IF(RIGHT(R$4,2)>=RIGHT('Input|General'!$G$11,2),IF(RIGHT(R$4,2)<=RIGHT('Input|General'!$G$12,2),R$4,\"\"),\"\")","v":""},{"$f":"IF(RIGHT(S$4,2)>=RIGHT('Input|General'!$G$11,2),IF(RIGHT(S$4,2)<=RIGHT('Input|General'!$G$12,2),S$4,\"\"),\"\")","v":""}]
[]
[]
[null,null,"Forecast output change","Calculated","Per cent","n/a",null,null,null,{"$f":"SUMPRODUCT('Input|Rate of change'!K67:K72,'Input|Rate of change'!$M$76:$M$81)","v":0},{"$f":"SUMPRODUCT('Input|Rate of change'!L67:L72,'Input|Rate of change'!$M$76:$M$81)","v":0},{"$f":"SUMPRODUCT('Input|Rate of change'!M67:M72,'Input|Rate of change'!$M$76:$M$81)","v":0},{"$f":"SUMPRODUCT('Input|Rate of change'!N67:N72,'Input|Rate of change'!$M$76:$M$81)","v":0},{"$f":"SUMPRODUCT('Input|Rate of change'!O67:O72,'Input|Rate of change'!$M$76:$M$81)","v":0},{"$f":"SUMPRODUCT('Input|Rate of change'!P67:P72,'Input|Rate of change'!$M$76:$M$81)","v":0},{"$f":"SUMPRODUCT('Input|Rate of change'!Q67:Q72,'Input|Rate of change'!$M$76:$M$81)","v":0},{"$f":"SUMPRODUCT('Input|Rate of change'!R67:R72,'Input|Rate of change'!$M$76:$M$81)","v":0},{"$f":"SUMPRODUCT('Input|Rate of change'!S67:S72,'Input|Rate of change'!$M$76:$M$81)","v":0},{"$f":"SUMPRODUCT('Input|Rate of change'!T67:T72,'Input|Rate of change'!$M$76:$M$81)","v":0}]
[]
[null,null,"Forecast price change","Calculated","Per cent","n/a",null,null,null,{"$f":"SUMPRODUCT('Input|Rate of change'!K32:K39,'Input|Rate of change'!K43:K50)","v":0},{"$f":"SUMPRODUCT('Input|Rate of change'!L32:L39,'Input|Rate of change'!L43:L50)","v":0},{"$f":"SUMPRODUCT('Input|Rate of change'!M32:M39,'Input|Rate of change'!M43:M50)","v":0},{"$f":"SUMPRODUCT('Input|Rate of change'!N32:N39,'Input|Rate of change'!N43:N50)","v":2.9447860169908809E-3},{"$f":"SUMPRODUCT('Input|Rate of change'!O32:O39,'Input|Rate of change'!O43:O50)","v":5.134181871766598E-3},{"$f":"SUMPRODUCT('Input|Rate of change'!P32:P39,'Input|Rate of change'!P43:P50)","v":6.0316652313305965E-3},{"$f":"SUMPRODUCT('Input|Rate of change'!Q32:Q39,'Input|Rate of change'!Q43:Q50)","v":6.3285897633478822E-3},{"$f":"SUMPRODUCT('Input|Rate of change'!R32:R39,'Input|Rate of change'!R43:R50)","v":6.3555410485279058E-3},{"$f":"SUMPRODUCT('Input|Rate of change'!S32:S39,'Input|Rate of change'!S43:S50)","v":0},{"$f":"SUMPRODUCT('Input|Rate of change'!T32:T39,'Input|Rate of change'!T43:T50)","v":0}]
[]
[null,null,"Forecast productivity change","Calculated","Per cent","n/a",null,null,null,{"$f":"'Input|Rate of change'!K89","v":0},{"$f":"'Input|Rate of change'!L89","v":0},{"$f":"'Input|Rate of change'!M89","v":0},{"$f":"'Input|Rate of change'!N89","v":2E-3},{"$f":"'Input|Rate of change'!O89","v":2E-3},{"$f":"'Input|Rate of change'!P89","v":2E-3},{"$f":"'Input|Rate of change'!Q89","v":2E-3},{"$f":"'Input|Rate of change'!R89","v":2E-3},{"$f":"'Input|Rate of change'!S89","v":0},{"$f":"'Input|Rate of change'!T89","v":0}]
[]
[null,null,"Forecast rate of change","Calculated","Per cent","n/a",null,null,null,{"$f":"(1+J45)*(1+J47)*(1-J49)-1","v":0},{"$f":"(1+K45)*(1+K47)*(1-K49)-1","v":0},0,9.3889644495681601E-4,3.1239135080229907E-3,4.0196019008680306E-3,4.3159325838211249E-3,4.3428299664307612E-3,0,0]
[]
[null,"Calc | Step changes"]
[]
[null,null,"Step changes","Source","Unit","Basis",null,null,null,{"$f":"IF(RIGHT(J$4,2)>=RIGHT('Input|General'!$G$11,2),IF(RIGHT(J$4,2)<=RIGHT('Input|General'!$G$12,2),J$4,\"\"),\"\")","v":""},{"$f":"IF(RIGHT(K$4,2)>=RIGHT('Input|General'!$G$11,2),IF(RIGHT(K$4,2)<=RIGHT('Input|General'!$G$12,2),K$4,\"\"),\"\")","v":""},{"$f":"IF(RIGHT(L$4,2)>=RIGHT('Input|General'!$G$11,2),IF(RIGHT(L$4,2)<=RIGHT('Input|General'!$G$12,2),L$4,\"\"),\"\")","v":""},{"$f":"IF(RIGHT(M$4,2)>=RIGHT('Input|General'!$G$11,2),IF(RIGHT(M$4,2)<=RIGHT('Input|General'!$G$12,2),M$4,\"\"),\"\")","v":"2017-18"},{"$f":"IF(RIGHT(N$4,2)>=RIGHT('Input|General'!$G$11,2),IF(RIGHT(N$4,2)<=RIGHT('Input|General'!$G$12,2),N$4,\"\"),\"\")","v":"2018-19"},{"$f":"IF(RIGHT(O$4,2)>=RIGHT('Input|General'!$G$11,2),IF(RIGHT(O$4,2)<=RIGHT('Input|General'!$G$12,2),O$4,\"\"),\"\")","v":"2019-20"},{"$f":"IF(RIGHT(P$4,2)>=RIGHT('Input|General'!$G$11,2),IF(RIGHT(P$4,2)<=RIGHT('Input|General'!$G$12,2),P$4,\"\"),\"\")","v":"2020-21"},{"$f":"IF(RIGHT(Q$4,2)>=RIGHT('Input|General'!$G$11,2),IF(RIGHT(Q$4,2)<=RIGHT('Input|General'!$G$12,2),Q$4,\"\"),\"\")","v":"2021-22"},{"$f":"IF(RIGHT(R$4,2)>=RIGHT('Input|General'!$G$11,2),IF(RIGHT(R$4,2)<=RIGHT('Input|General'!$G$12,2),R$4,\"\"),\"\")","v":""},{"$f":"IF(RIGHT(S$4,2)>=RIGHT('Input|General'!$G$11,2),IF(RIGHT(S$4,2)<=RIGHT('Input|General'!$G$12,2),S$4,\"\"),\"\")","v":""}]
[]
[null,null,{"$f":"'Input|Step changes'!C12","v":"Synchronous condenser decommissioning"},"Calculated",{"$f":"$E$8","v":"$millions"},{"$f":"$F$8","v":"2016-17"},null,null,null,{"$f":"'Input|Step changes'!J12*IF('Input|Step changes'!$F12=\"nominal\",LOOKUP($F57,Nominal_to_Real,'Input|Rate of change'!N$23:N$26),INDEX('Input|Rate of change'!$C$14:$O$19,MATCH('Input|Step changes'!$F12,'Input|Rate of change'!$C$14:$C$19,0),MATCH('Calc|Opex forecast'!$F57,'Input|Rate of change'!$C$14:$O$14,0)))*IF('Input|Step changes'!$E12=\"$millions\",1000000,IF('Input|Step changes'!$E12=\"$000\",1000,1))/IF($E57=\"$millions\",1000000,IF($E57=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!K12*IF('Input|Step changes'!$F12=\"nominal\",LOOKUP($F57,Nominal_to_Real,'Input|Rate of change'!O$23:O$26),INDEX('Input|Rate of change'!$C$14:$O$19,MATCH('Input|Step changes'!$F12,'Input|Rate of change'!$C$14:$C$19,0),MATCH('Calc|Opex forecast'!$F57,'Input|Rate of change'!$C$14:$O$14,0)))*IF('Input|Step changes'!$E12=\"$millions\",1000000,IF('Input|Step changes'!$E12=\"$000\",1000,1))/IF($E57=\"$millions\",1000000,IF($E57=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!L12*IF('Input|Step changes'!$F12=\"nominal\",LOOKUP($F57,Nominal_to_Real,'Input|Rate of change'!P$23:P$26),INDEX('Input|Rate of change'!$C$14:$O$19,MATCH('Input|Step changes'!$F12,'Input|Rate of change'!$C$14:$C$19,0),MATCH('Calc|Opex forecast'!$F57,'Input|Rate of change'!$C$14:$O$14,0)))*IF('Input|Step changes'!$E12=\"$millions\",1000000,IF('Input|Step changes'!$E12=\"$000\",1000,1))/IF($E57=\"$millions\",1000000,IF($E57=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!M12*IF('Input|Step changes'!$F12=\"nominal\",LOOKUP($F57,Nominal_to_Real,'Input|Rate of change'!Q$23:Q$26),INDEX('Input|Rate of change'!$C$14:$O$19,MATCH('Input|Step changes'!$F12,'Input|Rate of change'!$C$14:$C$19,0),MATCH('Calc|Opex forecast'!$F57,'Input|Rate of change'!$C$14:$O$14,0)))*IF('Input|Step changes'!$E12=\"$millions\",1000000,IF('Input|Step changes'!$E12=\"$000\",1000,1))/IF($E57=\"$millions\",1000000,IF($E57=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!N12*IF('Input|Step changes'!$F12=\"nominal\",LOOKUP($F57,Nominal_to_Real,'Input|Rate of change'!R$23:R$26),INDEX('Input|Rate of change'!$C$14:$O$19,MATCH('Input|Step changes'!$F12,'Input|Rate of change'!$C$14:$C$19,0),MATCH('Calc|Opex forecast'!$F57,'Input|Rate of change'!$C$14:$O$14,0)))*IF('Input|Step changes'!$E12=\"$millions\",1000000,IF('Input|Step changes'!$E12=\"$000\",1000,1))/IF($E57=\"$millions\",1000000,IF($E57=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!O12*IF('Input|Step changes'!$F12=\"nominal\",LOOKUP($F57,Nominal_to_Real,'Input|Rate of change'!S$23:S$26),INDEX('Input|Rate of change'!$C$14:$O$19,MATCH('Input|Step changes'!$F12,'Input|Rate of change'!$C$14:$C$19,0),MATCH('Calc|Opex forecast'!$F57,'Input|Rate of change'!$C$14:$O$14,0)))*IF('Input|Step changes'!$E12=\"$millions\",1000000,IF('Input|Step changes'!$E12=\"$000\",1000,1))/IF($E57=\"$millions\",1000000,IF($E57=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!P12*IF('Input|Step changes'!$F12=\"nominal\",LOOKUP($F57,Nominal_to_Real,'Input|Rate of change'!T$23:T$26),INDEX('Input|Rate of change'!$C$14:$O$19,MATCH('Input|Step changes'!$F12,'Input|Rate of change'!$C$14:$C$19,0),MATCH('Calc|Opex forecast'!$F57,'Input|Rate of change'!$C$14:$O$14,0)))*IF('Input|Step changes'!$E12=\"$millions\",1000000,IF('Input|Step changes'!$E12=\"$000\",1000,1))/IF($E57=\"$millions\",1000000,IF($E57=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!Q12*IF('Input|Step changes'!$F12=\"nominal\",LOOKUP($F57,Nominal_to_Real,'Input|Rate of change'!U$23:U$26),INDEX('Input|Rate of change'!$C$14:$O$19,MATCH('Input|Step changes'!$F12,'Input|Rate of change'!$C$14:$C$19,0),MATCH('Calc|Opex forecast'!$F57,'Input|Rate of change'!$C$14:$O$14,0)))*IF('Input|Step changes'!$E12=\"$millions\",1000000,IF('Input|Step changes'!$E12=\"$000\",1000,1))/IF($E57=\"$millions\",1000000,IF($E57=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!R12*IF('Input|Step changes'!$F12=\"nominal\",LOOKUP($F57,Nominal_to_Real,'Input|Rate of change'!V$23:V$26),INDEX('Input|Rate of change'!$C$14:$O$19,MATCH('Input|Step changes'!$F12,'Input|Rate of change'!$C$14:$C$19,0),MATCH('Calc|Opex forecast'!$F57,'Input|Rate of change'!$C$14:$O$14,0)))*IF('Input|Step changes'!$E12=\"$millions\",1000000,IF('Input|Step changes'!$E12=\"$000\",1000,1))/IF($E57=\"$millions\",1000000,IF($E57=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!S12*IF('Input|Step changes'!$F12=\"nominal\",LOOKUP($F57,Nominal_to_Real,'Input|Rate of change'!W$23:W$26),INDEX('Input|Rate of change'!$C$14:$O$19,MATCH('Input|Step changes'!$F12,'Input|Rate of change'!$C$14:$C$19,0),MATCH('Calc|Opex forecast'!$F57,'Input|Rate of change'!$C$14:$O$14,0)))*IF('Input|Step changes'!$E12=\"$millions\",1000000,IF('Input|Step changes'!$E12=\"$000\",1000,1))/IF($E57=\"$millions\",1000000,IF($E57=\"$000\",1000,1))","v":0}]
[null,null,{"$f":"'Input|Step changes'!C13","v":"SAIP roll out"},"Calculated","$millions",{"$f":"$F$8","v":"2016-17"},null,null,null,{"$f":"'Input|Step changes'!J13*IF('Input|Step changes'!$F13=\"nominal\",LOOKUP($F58,Nominal_to_Real,'Input|Rate of change'!N$23:N$26),INDEX('Input|Rate of change'!$C$14:$O$19,MATCH('Input|Step changes'!$F13,'Input|Rate of change'!$C$14:$C$19,0),MATCH('Calc|Opex forecast'!$F58,'Input|Rate of change'!$C$14:$O$14,0)))*IF('Input|Step changes'!$E13=\"$millions\",1000000,IF('Input|Step changes'!$E13=\"$000\",1000,1))/IF($E58=\"$millions\",1000000,IF($E58=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!K13*IF('Input|Step changes'!$F13=\"nominal\",LOOKUP($F58,Nominal_to_Real,'Input|Rate of change'!O$23:O$26),INDEX('Input|Rate of change'!$C$14:$O$19,MATCH('Input|Step changes'!$F13,'Input|Rate of change'!$C$14:$C$19,0),MATCH('Calc|Opex forecast'!$F58,'Input|Rate of change'!$C$14:$O$14,0)))*IF('Input|Step changes'!$E13=\"$millions\",1000000,IF('Input|Step changes'!$E13=\"$000\",1000,1))/IF($E58=\"$millions\",1000000,IF($E58=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!L13*IF('Input|Step changes'!$F13=\"nominal\",LOOKUP($F58,Nominal_to_Real,'Input|Rate of change'!P$23:P$26),INDEX('Input|Rate of change'!$C$14:$O$19,MATCH('Input|Step changes'!$F13,'Input|Rate of change'!$C$14:$C$19,0),MATCH('Calc|Opex forecast'!$F58,'Input|Rate of change'!$C$14:$O$14,0)))*IF('Input|Step changes'!$E13=\"$millions\",1000000,IF('Input|Step changes'!$E13=\"$000\",1000,1))/IF($E58=\"$millions\",1000000,IF($E58=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!M13*IF('Input|Step changes'!$F13=\"nominal\",LOOKUP($F58,Nominal_to_Real,'Input|Rate of change'!Q$23:Q$26),INDEX('Input|Rate of change'!$C$14:$O$19,MATCH('Input|Step changes'!$F13,'Input|Rate of change'!$C$14:$C$19,0),MATCH('Calc|Opex forecast'!$F58,'Input|Rate of change'!$C$14:$O$14,0)))*IF('Input|Step changes'!$E13=\"$millions\",1000000,IF('Input|Step changes'!$E13=\"$000\",1000,1))/IF($E58=\"$millions\",1000000,IF($E58=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!N13*IF('Input|Step changes'!$F13=\"nominal\",LOOKUP($F58,Nominal_to_Real,'Input|Rate of change'!R$23:R$26),INDEX('Input|Rate of change'!$C$14:$O$19,MATCH('Input|Step changes'!$F13,'Input|Rate of change'!$C$14:$C$19,0),MATCH('Calc|Opex forecast'!$F58,'Input|Rate of change'!$C$14:$O$14,0)))*IF('Input|Step changes'!$E13=\"$millions\",1000000,IF('Input|Step changes'!$E13=\"$000\",1000,1))/IF($E58=\"$millions\",1000000,IF($E58=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!O13*IF('Input|Step changes'!$F13=\"nominal\",LOOKUP($F58,Nominal_to_Real,'Input|Rate of change'!S$23:S$26),INDEX('Input|Rate of change'!$C$14:$O$19,MATCH('Input|Step changes'!$F13,'Input|Rate of change'!$C$14:$C$19,0),MATCH('Calc|Opex forecast'!$F58,'Input|Rate of change'!$C$14:$O$14,0)))*IF('Input|Step changes'!$E13=\"$millions\",1000000,IF('Input|Step changes'!$E13=\"$000\",1000,1))/IF($E58=\"$millions\",1000000,IF($E58=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!P13*IF('Input|Step changes'!$F13=\"nominal\",LOOKUP($F58,Nominal_to_Real,'Input|Rate of change'!T$23:T$26),INDEX('Input|Rate of change'!$C$14:$O$19,MATCH('Input|Step changes'!$F13,'Input|Rate of change'!$C$14:$C$19,0),MATCH('Calc|Opex forecast'!$F58,'Input|Rate of change'!$C$14:$O$14,0)))*IF('Input|Step changes'!$E13=\"$millions\",1000000,IF('Input|Step changes'!$E13=\"$000\",1000,1))/IF($E58=\"$millions\",1000000,IF($E58=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!Q13*IF('Input|Step changes'!$F13=\"nominal\",LOOKUP($F58,Nominal_to_Real,'Input|Rate of change'!U$23:U$26),INDEX('Input|Rate of change'!$C$14:$O$19,MATCH('Input|Step changes'!$F13,'Input|Rate of change'!$C$14:$C$19,0),MATCH('Calc|Opex forecast'!$F58,'Input|Rate of change'!$C$14:$O$14,0)))*IF('Input|Step changes'!$E13=\"$millions\",1000000,IF('Input|Step changes'!$E13=\"$000\",1000,1))/IF($E58=\"$millions\",1000000,IF($E58=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!R13*IF('Input|Step changes'!$F13=\"nominal\",LOOKUP($F58,Nominal_to_Real,'Input|Rate of change'!V$23:V$26),INDEX('Input|Rate of change'!$C$14:$O$19,MATCH('Input|Step changes'!$F13,'Input|Rate of change'!$C$14:$C$19,0),MATCH('Calc|Opex forecast'!$F58,'Input|Rate of change'!$C$14:$O$14,0)))*IF('Input|Step changes'!$E13=\"$millions\",1000000,IF('Input|Step changes'!$E13=\"$000\",1000,1))/IF($E58=\"$millions\",1000000,IF($E58=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!S13*IF('Input|Step changes'!$F13=\"nominal\",LOOKUP($F58,Nominal_to_Real,'Input|Rate of change'!W$23:W$26),INDEX('Input|Rate of change'!$C$14:$O$19,MATCH('Input|Step changes'!$F13,'Input|Rate of change'!$C$14:$C$19,0),MATCH('Calc|Opex forecast'!$F58,'Input|Rate of change'!$C$14:$O$14,0)))*IF('Input|Step changes'!$E13=\"$millions\",1000000,IF('Input|Step changes'!$E13=\"$000\",1000,1))/IF($E58=\"$millions\",1000000,IF($E58=\"$000\",1000,1))","v":0}]
[null,null,{"$f":"'Input|Step changes'!C14","v":"Establishment of IT security team"},"Calculated","$millions","2016-17",null,null,null,{"$f":"'Input|Step changes'!J14*IF('Input|Step changes'!$F14=\"nominal\",LOOKUP($F59,Nominal_to_Real,'Input|Rate of change'!N$23:N$26),INDEX('Input|Rate of change'!$C$14:$O$19,MATCH('Input|Step changes'!$F14,'Input|Rate of change'!$C$14:$C$19,0),MATCH('Calc|Opex forecast'!$F59,'Input|Rate of change'!$C$14:$O$14,0)))*IF('Input|Step changes'!$E14=\"$millions\",1000000,IF('Input|Step changes'!$E14=\"$000\",1000,1))/IF($E59=\"$millions\",1000000,IF($E59=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!K14*IF('Input|Step changes'!$F14=\"nominal\",LOOKUP($F59,Nominal_to_Real,'Input|Rate of change'!O$23:O$26),INDEX('Input|Rate of change'!$C$14:$O$19,MATCH('Input|Step changes'!$F14,'Input|Rate of change'!$C$14:$C$19,0),MATCH('Calc|Opex forecast'!$F59,'Input|Rate of change'!$C$14:$O$14,0)))*IF('Input|Step changes'!$E14=\"$millions\",1000000,IF('Input|Step changes'!$E14=\"$000\",1000,1))/IF($E59=\"$millions\",1000000,IF($E59=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!L14*IF('Input|Step changes'!$F14=\"nominal\",LOOKUP($F59,Nominal_to_Real,'Input|Rate of change'!P$23:P$26),INDEX('Input|Rate of change'!$C$14:$O$19,MATCH('Input|Step changes'!$F14,'Input|Rate of change'!$C$14:$C$19,0),MATCH('Calc|Opex forecast'!$F59,'Input|Rate of change'!$C$14:$O$14,0)))*IF('Input|Step changes'!$E14=\"$millions\",1000000,IF('Input|Step changes'!$E14=\"$000\",1000,1))/IF($E59=\"$millions\",1000000,IF($E59=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!M14*IF('Input|Step changes'!$F14=\"nominal\",LOOKUP($F59,Nominal_to_Real,'Input|Rate of change'!Q$23:Q$26),INDEX('Input|Rate of change'!$C$14:$O$19,MATCH('Input|Step changes'!$F14,'Input|Rate of change'!$C$14:$C$19,0),MATCH('Calc|Opex forecast'!$F59,'Input|Rate of change'!$C$14:$O$14,0)))*IF('Input|Step changes'!$E14=\"$millions\",1000000,IF('Input|Step changes'!$E14=\"$000\",1000,1))/IF($E59=\"$millions\",1000000,IF($E59=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!N14*IF('Input|Step changes'!$F14=\"nominal\",LOOKUP($F59,Nominal_to_Real,'Input|Rate of change'!R$23:R$26),INDEX('Input|Rate of change'!$C$14:$O$19,MATCH('Input|Step changes'!$F14,'Input|Rate of change'!$C$14:$C$19,0),MATCH('Calc|Opex forecast'!$F59,'Input|Rate of change'!$C$14:$O$14,0)))*IF('Input|Step changes'!$E14=\"$millions\",1000000,IF('Input|Step changes'!$E14=\"$000\",1000,1))/IF($E59=\"$millions\",1000000,IF($E59=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!O14*IF('Input|Step changes'!$F14=\"nominal\",LOOKUP($F59,Nominal_to_Real,'Input|Rate of change'!S$23:S$26),INDEX('Input|Rate of change'!$C$14:$O$19,MATCH('Input|Step changes'!$F14,'Input|Rate of change'!$C$14:$C$19,0),MATCH('Calc|Opex forecast'!$F59,'Input|Rate of change'!$C$14:$O$14,0)))*IF('Input|Step changes'!$E14=\"$millions\",1000000,IF('Input|Step changes'!$E14=\"$000\",1000,1))/IF($E59=\"$millions\",1000000,IF($E59=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!P14*IF('Input|Step changes'!$F14=\"nominal\",LOOKUP($F59,Nominal_to_Real,'Input|Rate of change'!T$23:T$26),INDEX('Input|Rate of change'!$C$14:$O$19,MATCH('Input|Step changes'!$F14,'Input|Rate of change'!$C$14:$C$19,0),MATCH('Calc|Opex forecast'!$F59,'Input|Rate of change'!$C$14:$O$14,0)))*IF('Input|Step changes'!$E14=\"$millions\",1000000,IF('Input|Step changes'!$E14=\"$000\",1000,1))/IF($E59=\"$millions\",1000000,IF($E59=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!Q14*IF('Input|Step changes'!$F14=\"nominal\",LOOKUP($F59,Nominal_to_Real,'Input|Rate of change'!U$23:U$26),INDEX('Input|Rate of change'!$C$14:$O$19,MATCH('Input|Step changes'!$F14,'Input|Rate of change'!$C$14:$C$19,0),MATCH('Calc|Opex forecast'!$F59,'Input|Rate of change'!$C$14:$O$14,0)))*IF('Input|Step changes'!$E14=\"$millions\",1000000,IF('Input|Step changes'!$E14=\"$000\",1000,1))/IF($E59=\"$millions\",1000000,IF($E59=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!R14*IF('Input|Step changes'!$F14=\"nominal\",LOOKUP($F59,Nominal_to_Real,'Input|Rate of change'!V$23:V$26),INDEX('Input|Rate of change'!$C$14:$O$19,MATCH('Input|Step changes'!$F14,'Input|Rate of change'!$C$14:$C$19,0),MATCH('Calc|Opex forecast'!$F59,'Input|Rate of change'!$C$14:$O$14,0)))*IF('Input|Step changes'!$E14=\"$millions\",1000000,IF('Input|Step changes'!$E14=\"$000\",1000,1))/IF($E59=\"$millions\",1000000,IF($E59=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!S14*IF('Input|Step changes'!$F14=\"nominal\",LOOKUP($F59,Nominal_to_Real,'Input|Rate of change'!W$23:W$26),INDEX('Input|Rate of change'!$C$14:$O$19,MATCH('Input|Step changes'!$F14,'Input|Rate of change'!$C$14:$C$19,0),MATCH('Calc|Opex forecast'!$F59,'Input|Rate of change'!$C$14:$O$14,0)))*IF('Input|Step changes'!$E14=\"$millions\",1000000,IF('Input|Step changes'!$E14=\"$000\",1000,1))/IF($E59=\"$millions\",1000000,IF($E59=\"$000\",1000,1))","v":0}]
[null,null,{"$f":"'Input|Step changes'!C15","v":"New emergency response arrangements"},"Calculated","$millions","2016-17",null,null,null,{"$f":"'Input|Step changes'!J15*IF('Input|Step changes'!$F15=\"nominal\",LOOKUP($F60,Nominal_to_Real,'Input|Rate of change'!N$23:N$26),INDEX('Input|Rate of change'!$C$14:$O$19,MATCH('Input|Step changes'!$F15,'Input|Rate of change'!$C$14:$C$19,0),MATCH('Calc|Opex forecast'!$F60,'Input|Rate of change'!$C$14:$O$14,0)))*IF('Input|Step changes'!$E15=\"$millions\",1000000,IF('Input|Step changes'!$E15=\"$000\",1000,1))/IF($E60=\"$millions\",1000000,IF($E60=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!K15*IF('Input|Step changes'!$F15=\"nominal\",LOOKUP($F60,Nominal_to_Real,'Input|Rate of change'!O$23:O$26),INDEX('Input|Rate of change'!$C$14:$O$19,MATCH('Input|Step changes'!$F15,'Input|Rate of change'!$C$14:$C$19,0),MATCH('Calc|Opex forecast'!$F60,'Input|Rate of change'!$C$14:$O$14,0)))*IF('Input|Step changes'!$E15=\"$millions\",1000000,IF('Input|Step changes'!$E15=\"$000\",1000,1))/IF($E60=\"$millions\",1000000,IF($E60=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!L15*IF('Input|Step changes'!$F15=\"nominal\",LOOKUP($F60,Nominal_to_Real,'Input|Rate of change'!P$23:P$26),INDEX('Input|Rate of change'!$C$14:$O$19,MATCH('Input|Step changes'!$F15,'Input|Rate of change'!$C$14:$C$19,0),MATCH('Calc|Opex forecast'!$F60,'Input|Rate of change'!$C$14:$O$14,0)))*IF('Input|Step changes'!$E15=\"$millions\",1000000,IF('Input|Step changes'!$E15=\"$000\",1000,1))/IF($E60=\"$millions\",1000000,IF($E60=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!M15*IF('Input|Step changes'!$F15=\"nominal\",LOOKUP($F60,Nominal_to_Real,'Input|Rate of change'!Q$23:Q$26),INDEX('Input|Rate of change'!$C$14:$O$19,MATCH('Input|Step changes'!$F15,'Input|Rate of change'!$C$14:$C$19,0),MATCH('Calc|Opex forecast'!$F60,'Input|Rate of change'!$C$14:$O$14,0)))*IF('Input|Step changes'!$E15=\"$millions\",1000000,IF('Input|Step changes'!$E15=\"$000\",1000,1))/IF($E60=\"$millions\",1000000,IF($E60=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!N15*IF('Input|Step changes'!$F15=\"nominal\",LOOKUP($F60,Nominal_to_Real,'Input|Rate of change'!R$23:R$26),INDEX('Input|Rate of change'!$C$14:$O$19,MATCH('Input|Step changes'!$F15,'Input|Rate of change'!$C$14:$C$19,0),MATCH('Calc|Opex forecast'!$F60,'Input|Rate of change'!$C$14:$O$14,0)))*IF('Input|Step changes'!$E15=\"$millions\",1000000,IF('Input|Step changes'!$E15=\"$000\",1000,1))/IF($E60=\"$millions\",1000000,IF($E60=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!O15*IF('Input|Step changes'!$F15=\"nominal\",LOOKUP($F60,Nominal_to_Real,'Input|Rate of change'!S$23:S$26),INDEX('Input|Rate of change'!$C$14:$O$19,MATCH('Input|Step changes'!$F15,'Input|Rate of change'!$C$14:$C$19,0),MATCH('Calc|Opex forecast'!$F60,'Input|Rate of change'!$C$14:$O$14,0)))*IF('Input|Step changes'!$E15=\"$millions\",1000000,IF('Input|Step changes'!$E15=\"$000\",1000,1))/IF($E60=\"$millions\",1000000,IF($E60=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!P15*IF('Input|Step changes'!$F15=\"nominal\",LOOKUP($F60,Nominal_to_Real,'Input|Rate of change'!T$23:T$26),INDEX('Input|Rate of change'!$C$14:$O$19,MATCH('Input|Step changes'!$F15,'Input|Rate of change'!$C$14:$C$19,0),MATCH('Calc|Opex forecast'!$F60,'Input|Rate of change'!$C$14:$O$14,0)))*IF('Input|Step changes'!$E15=\"$millions\",1000000,IF('Input|Step changes'!$E15=\"$000\",1000,1))/IF($E60=\"$millions\",1000000,IF($E60=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!Q15*IF('Input|Step changes'!$F15=\"nominal\",LOOKUP($F60,Nominal_to_Real,'Input|Rate of change'!U$23:U$26),INDEX('Input|Rate of change'!$C$14:$O$19,MATCH('Input|Step changes'!$F15,'Input|Rate of change'!$C$14:$C$19,0),MATCH('Calc|Opex forecast'!$F60,'Input|Rate of change'!$C$14:$O$14,0)))*IF('Input|Step changes'!$E15=\"$millions\",1000000,IF('Input|Step changes'!$E15=\"$000\",1000,1))/IF($E60=\"$millions\",1000000,IF($E60=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!R15*IF('Input|Step changes'!$F15=\"nominal\",LOOKUP($F60,Nominal_to_Real,'Input|Rate of change'!V$23:V$26),INDEX('Input|Rate of change'!$C$14:$O$19,MATCH('Input|Step changes'!$F15,'Input|Rate of change'!$C$14:$C$19,0),MATCH('Calc|Opex forecast'!$F60,'Input|Rate of change'!$C$14:$O$14,0)))*IF('Input|Step changes'!$E15=\"$millions\",1000000,IF('Input|Step changes'!$E15=\"$000\",1000,1))/IF($E60=\"$millions\",1000000,IF($E60=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!S15*IF('Input|Step changes'!$F15=\"nominal\",LOOKUP($F60,Nominal_to_Real,'Input|Rate of change'!W$23:W$26),INDEX('Input|Rate of change'!$C$14:$O$19,MATCH('Input|Step changes'!$F15,'Input|Rate of change'!$C$14:$C$19,0),MATCH('Calc|Opex forecast'!$F60,'Input|Rate of change'!$C$14:$O$14,0)))*IF('Input|Step changes'!$E15=\"$millions\",1000000,IF('Input|Step changes'!$E15=\"$000\",1000,1))/IF($E60=\"$millions\",1000000,IF($E60=\"$000\",1000,1))","v":0}]
[null,null,{"$f":"'Input|Step changes'!C16","v":"WMTS mobile switchboard"},"Calculated","$millions","2016-17",null,null,null,{"$f":"'Input|Step changes'!J16*IF('Input|Step changes'!$F16=\"nominal\",LOOKUP($F61,Nominal_to_Real,'Input|Rate of change'!N$23:N$26),INDEX('Input|Rate of change'!$C$14:$O$19,MATCH('Input|Step changes'!$F16,'Input|Rate of change'!$C$14:$C$19,0),MATCH('Calc|Opex forecast'!$F61,'Input|Rate of change'!$C$14:$O$14,0)))*IF('Input|Step changes'!$E16=\"$millions\",1000000,IF('Input|Step changes'!$E16=\"$000\",1000,1))/IF($E61=\"$millions\",1000000,IF($E61=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!K16*IF('Input|Step changes'!$F16=\"nominal\",LOOKUP($F61,Nominal_to_Real,'Input|Rate of change'!O$23:O$26),INDEX('Input|Rate of change'!$C$14:$O$19,MATCH('Input|Step changes'!$F16,'Input|Rate of change'!$C$14:$C$19,0),MATCH('Calc|Opex forecast'!$F61,'Input|Rate of change'!$C$14:$O$14,0)))*IF('Input|Step changes'!$E16=\"$millions\",1000000,IF('Input|Step changes'!$E16=\"$000\",1000,1))/IF($E61=\"$millions\",1000000,IF($E61=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!L16*IF('Input|Step changes'!$F16=\"nominal\",LOOKUP($F61,Nominal_to_Real,'Input|Rate of change'!P$23:P$26),INDEX('Input|Rate of change'!$C$14:$O$19,MATCH('Input|Step changes'!$F16,'Input|Rate of change'!$C$14:$C$19,0),MATCH('Calc|Opex forecast'!$F61,'Input|Rate of change'!$C$14:$O$14,0)))*IF('Input|Step changes'!$E16=\"$millions\",1000000,IF('Input|Step changes'!$E16=\"$000\",1000,1))/IF($E61=\"$millions\",1000000,IF($E61=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!M16*IF('Input|Step changes'!$F16=\"nominal\",LOOKUP($F61,Nominal_to_Real,'Input|Rate of change'!Q$23:Q$26),INDEX('Input|Rate of change'!$C$14:$O$19,MATCH('Input|Step changes'!$F16,'Input|Rate of change'!$C$14:$C$19,0),MATCH('Calc|Opex forecast'!$F61,'Input|Rate of change'!$C$14:$O$14,0)))*IF('Input|Step changes'!$E16=\"$millions\",1000000,IF('Input|Step changes'!$E16=\"$000\",1000,1))/IF($E61=\"$millions\",1000000,IF($E61=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!N16*IF('Input|Step changes'!$F16=\"nominal\",LOOKUP($F61,Nominal_to_Real,'Input|Rate of change'!R$23:R$26),INDEX('Input|Rate of change'!$C$14:$O$19,MATCH('Input|Step changes'!$F16,'Input|Rate of change'!$C$14:$C$19,0),MATCH('Calc|Opex forecast'!$F61,'Input|Rate of change'!$C$14:$O$14,0)))*IF('Input|Step changes'!$E16=\"$millions\",1000000,IF('Input|Step changes'!$E16=\"$000\",1000,1))/IF($E61=\"$millions\",1000000,IF($E61=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!O16*IF('Input|Step changes'!$F16=\"nominal\",LOOKUP($F61,Nominal_to_Real,'Input|Rate of change'!S$23:S$26),INDEX('Input|Rate of change'!$C$14:$O$19,MATCH('Input|Step changes'!$F16,'Input|Rate of change'!$C$14:$C$19,0),MATCH('Calc|Opex forecast'!$F61,'Input|Rate of change'!$C$14:$O$14,0)))*IF('Input|Step changes'!$E16=\"$millions\",1000000,IF('Input|Step changes'!$E16=\"$000\",1000,1))/IF($E61=\"$millions\",1000000,IF($E61=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!P16*IF('Input|Step changes'!$F16=\"nominal\",LOOKUP($F61,Nominal_to_Real,'Input|Rate of change'!T$23:T$26),INDEX('Input|Rate of change'!$C$14:$O$19,MATCH('Input|Step changes'!$F16,'Input|Rate of change'!$C$14:$C$19,0),MATCH('Calc|Opex forecast'!$F61,'Input|Rate of change'!$C$14:$O$14,0)))*IF('Input|Step changes'!$E16=\"$millions\",1000000,IF('Input|Step changes'!$E16=\"$000\",1000,1))/IF($E61=\"$millions\",1000000,IF($E61=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!Q16*IF('Input|Step changes'!$F16=\"nominal\",LOOKUP($F61,Nominal_to_Real,'Input|Rate of change'!U$23:U$26),INDEX('Input|Rate of change'!$C$14:$O$19,MATCH('Input|Step changes'!$F16,'Input|Rate of change'!$C$14:$C$19,0),MATCH('Calc|Opex forecast'!$F61,'Input|Rate of change'!$C$14:$O$14,0)))*IF('Input|Step changes'!$E16=\"$millions\",1000000,IF('Input|Step changes'!$E16=\"$000\",1000,1))/IF($E61=\"$millions\",1000000,IF($E61=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!R16*IF('Input|Step changes'!$F16=\"nominal\",LOOKUP($F61,Nominal_to_Real,'Input|Rate of change'!V$23:V$26),INDEX('Input|Rate of change'!$C$14:$O$19,MATCH('Input|Step changes'!$F16,'Input|Rate of change'!$C$14:$C$19,0),MATCH('Calc|Opex forecast'!$F61,'Input|Rate of change'!$C$14:$O$14,0)))*IF('Input|Step changes'!$E16=\"$millions\",1000000,IF('Input|Step changes'!$E16=\"$000\",1000,1))/IF($E61=\"$millions\",1000000,IF($E61=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!S16*IF('Input|Step changes'!$F16=\"nominal\",LOOKUP($F61,Nominal_to_Real,'Input|Rate of change'!W$23:W$26),INDEX('Input|Rate of change'!$C$14:$O$19,MATCH('Input|Step changes'!$F16,'Input|Rate of change'!$C$14:$C$19,0),MATCH('Calc|Opex forecast'!$F61,'Input|Rate of change'!$C$14:$O$14,0)))*IF('Input|Step changes'!$E16=\"$millions\",1000000,IF('Input|Step changes'!$E16=\"$000\",1000,1))/IF($E61=\"$millions\",1000000,IF($E61=\"$000\",1000,1))","v":0}]
[null,null,{"$f":"'Input|Step changes'!C17","v":"MPS decommissioning"},"Calculated","$millions","2016-17",null,null,null,{"$f":"'Input|Step changes'!J17*IF('Input|Step changes'!$F17=\"nominal\",LOOKUP($F62,Nominal_to_Real,'Input|Rate of change'!N$23:N$26),INDEX('Input|Rate of change'!$C$14:$O$19,MATCH('Input|Step changes'!$F17,'Input|Rate of change'!$C$14:$C$19,0),MATCH('Calc|Opex forecast'!$F62,'Input|Rate of change'!$C$14:$O$14,0)))*IF('Input|Step changes'!$E17=\"$millions\",1000000,IF('Input|Step changes'!$E17=\"$000\",1000,1))/IF($E62=\"$millions\",1000000,IF($E62=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!K17*IF('Input|Step changes'!$F17=\"nominal\",LOOKUP($F62,Nominal_to_Real,'Input|Rate of change'!O$23:O$26),INDEX('Input|Rate of change'!$C$14:$O$19,MATCH('Input|Step changes'!$F17,'Input|Rate of change'!$C$14:$C$19,0),MATCH('Calc|Opex forecast'!$F62,'Input|Rate of change'!$C$14:$O$14,0)))*IF('Input|Step changes'!$E17=\"$millions\",1000000,IF('Input|Step changes'!$E17=\"$000\",1000,1))/IF($E62=\"$millions\",1000000,IF($E62=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!L17*IF('Input|Step changes'!$F17=\"nominal\",LOOKUP($F62,Nominal_to_Real,'Input|Rate of change'!P$23:P$26),INDEX('Input|Rate of change'!$C$14:$O$19,MATCH('Input|Step changes'!$F17,'Input|Rate of change'!$C$14:$C$19,0),MATCH('Calc|Opex forecast'!$F62,'Input|Rate of change'!$C$14:$O$14,0)))*IF('Input|Step changes'!$E17=\"$millions\",1000000,IF('Input|Step changes'!$E17=\"$000\",1000,1))/IF($E62=\"$millions\",1000000,IF($E62=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!M17*IF('Input|Step changes'!$F17=\"nominal\",LOOKUP($F62,Nominal_to_Real,'Input|Rate of change'!Q$23:Q$26),INDEX('Input|Rate of change'!$C$14:$O$19,MATCH('Input|Step changes'!$F17,'Input|Rate of change'!$C$14:$C$19,0),MATCH('Calc|Opex forecast'!$F62,'Input|Rate of change'!$C$14:$O$14,0)))*IF('Input|Step changes'!$E17=\"$millions\",1000000,IF('Input|Step changes'!$E17=\"$000\",1000,1))/IF($E62=\"$millions\",1000000,IF($E62=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!N17*IF('Input|Step changes'!$F17=\"nominal\",LOOKUP($F62,Nominal_to_Real,'Input|Rate of change'!R$23:R$26),INDEX('Input|Rate of change'!$C$14:$O$19,MATCH('Input|Step changes'!$F17,'Input|Rate of change'!$C$14:$C$19,0),MATCH('Calc|Opex forecast'!$F62,'Input|Rate of change'!$C$14:$O$14,0)))*IF('Input|Step changes'!$E17=\"$millions\",1000000,IF('Input|Step changes'!$E17=\"$000\",1000,1))/IF($E62=\"$millions\",1000000,IF($E62=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!O17*IF('Input|Step changes'!$F17=\"nominal\",LOOKUP($F62,Nominal_to_Real,'Input|Rate of change'!S$23:S$26),INDEX('Input|Rate of change'!$C$14:$O$19,MATCH('Input|Step changes'!$F17,'Input|Rate of change'!$C$14:$C$19,0),MATCH('Calc|Opex forecast'!$F62,'Input|Rate of change'!$C$14:$O$14,0)))*IF('Input|Step changes'!$E17=\"$millions\",1000000,IF('Input|Step changes'!$E17=\"$000\",1000,1))/IF($E62=\"$millions\",1000000,IF($E62=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!P17*IF('Input|Step changes'!$F17=\"nominal\",LOOKUP($F62,Nominal_to_Real,'Input|Rate of change'!T$23:T$26),INDEX('Input|Rate of change'!$C$14:$O$19,MATCH('Input|Step changes'!$F17,'Input|Rate of change'!$C$14:$C$19,0),MATCH('Calc|Opex forecast'!$F62,'Input|Rate of change'!$C$14:$O$14,0)))*IF('Input|Step changes'!$E17=\"$millions\",1000000,IF('Input|Step changes'!$E17=\"$000\",1000,1))/IF($E62=\"$millions\",1000000,IF($E62=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!Q17*IF('Input|Step changes'!$F17=\"nominal\",LOOKUP($F62,Nominal_to_Real,'Input|Rate of change'!U$23:U$26),INDEX('Input|Rate of change'!$C$14:$O$19,MATCH('Input|Step changes'!$F17,'Input|Rate of change'!$C$14:$C$19,0),MATCH('Calc|Opex forecast'!$F62,'Input|Rate of change'!$C$14:$O$14,0)))*IF('Input|Step changes'!$E17=\"$millions\",1000000,IF('Input|Step changes'!$E17=\"$000\",1000,1))/IF($E62=\"$millions\",1000000,IF($E62=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!R17*IF('Input|Step changes'!$F17=\"nominal\",LOOKUP($F62,Nominal_to_Real,'Input|Rate of change'!V$23:V$26),INDEX('Input|Rate of change'!$C$14:$O$19,MATCH('Input|Step changes'!$F17,'Input|Rate of change'!$C$14:$C$19,0),MATCH('Calc|Opex forecast'!$F62,'Input|Rate of change'!$C$14:$O$14,0)))*IF('Input|Step changes'!$E17=\"$millions\",1000000,IF('Input|Step changes'!$E17=\"$000\",1000,1))/IF($E62=\"$millions\",1000000,IF($E62=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!S17*IF('Input|Step changes'!$F17=\"nominal\",LOOKUP($F62,Nominal_to_Real,'Input|Rate of change'!W$23:W$26),INDEX('Input|Rate of change'!$C$14:$O$19,MATCH('Input|Step changes'!$F17,'Input|Rate of change'!$C$14:$C$19,0),MATCH('Calc|Opex forecast'!$F62,'Input|Rate of change'!$C$14:$O$14,0)))*IF('Input|Step changes'!$E17=\"$millions\",1000000,IF('Input|Step changes'!$E17=\"$000\",1000,1))/IF($E62=\"$millions\",1000000,IF($E62=\"$000\",1000,1))","v":0}]
[null,null,{"$f":"'Input|Step changes'!C18","v":0},"Calculated","$millions","2016-17",null,null,null,{"$f":"'Input|Step changes'!J18*IF('Input|Step changes'!$F18=\"nominal\",LOOKUP($F63,Nominal_to_Real,'Input|Rate of change'!N$23:N$26),INDEX('Input|Rate of change'!$C$14:$O$19,MATCH('Input|Step changes'!$F18,'Input|Rate of change'!$C$14:$C$19,0),MATCH('Calc|Opex forecast'!$F63,'Input|Rate of change'!$C$14:$O$14,0)))*IF('Input|Step changes'!$E18=\"$millions\",1000000,IF('Input|Step changes'!$E18=\"$000\",1000,1))/IF($E63=\"$millions\",1000000,IF($E63=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!K18*IF('Input|Step changes'!$F18=\"nominal\",LOOKUP($F63,Nominal_to_Real,'Input|Rate of change'!O$23:O$26),INDEX('Input|Rate of change'!$C$14:$O$19,MATCH('Input|Step changes'!$F18,'Input|Rate of change'!$C$14:$C$19,0),MATCH('Calc|Opex forecast'!$F63,'Input|Rate of change'!$C$14:$O$14,0)))*IF('Input|Step changes'!$E18=\"$millions\",1000000,IF('Input|Step changes'!$E18=\"$000\",1000,1))/IF($E63=\"$millions\",1000000,IF($E63=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!L18*IF('Input|Step changes'!$F18=\"nominal\",LOOKUP($F63,Nominal_to_Real,'Input|Rate of change'!P$23:P$26),INDEX('Input|Rate of change'!$C$14:$O$19,MATCH('Input|Step changes'!$F18,'Input|Rate of change'!$C$14:$C$19,0),MATCH('Calc|Opex forecast'!$F63,'Input|Rate of change'!$C$14:$O$14,0)))*IF('Input|Step changes'!$E18=\"$millions\",1000000,IF('Input|Step changes'!$E18=\"$000\",1000,1))/IF($E63=\"$millions\",1000000,IF($E63=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!M18*IF('Input|Step changes'!$F18=\"nominal\",LOOKUP($F63,Nominal_to_Real,'Input|Rate of change'!Q$23:Q$26),INDEX('Input|Rate of change'!$C$14:$O$19,MATCH('Input|Step changes'!$F18,'Input|Rate of change'!$C$14:$C$19,0),MATCH('Calc|Opex forecast'!$F63,'Input|Rate of change'!$C$14:$O$14,0)))*IF('Input|Step changes'!$E18=\"$millions\",1000000,IF('Input|Step changes'!$E18=\"$000\",1000,1))/IF($E63=\"$millions\",1000000,IF($E63=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!N18*IF('Input|Step changes'!$F18=\"nominal\",LOOKUP($F63,Nominal_to_Real,'Input|Rate of change'!R$23:R$26),INDEX('Input|Rate of change'!$C$14:$O$19,MATCH('Input|Step changes'!$F18,'Input|Rate of change'!$C$14:$C$19,0),MATCH('Calc|Opex forecast'!$F63,'Input|Rate of change'!$C$14:$O$14,0)))*IF('Input|Step changes'!$E18=\"$millions\",1000000,IF('Input|Step changes'!$E18=\"$000\",1000,1))/IF($E63=\"$millions\",1000000,IF($E63=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!O18*IF('Input|Step changes'!$F18=\"nominal\",LOOKUP($F63,Nominal_to_Real,'Input|Rate of change'!S$23:S$26),INDEX('Input|Rate of change'!$C$14:$O$19,MATCH('Input|Step changes'!$F18,'Input|Rate of change'!$C$14:$C$19,0),MATCH('Calc|Opex forecast'!$F63,'Input|Rate of change'!$C$14:$O$14,0)))*IF('Input|Step changes'!$E18=\"$millions\",1000000,IF('Input|Step changes'!$E18=\"$000\",1000,1))/IF($E63=\"$millions\",1000000,IF($E63=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!P18*IF('Input|Step changes'!$F18=\"nominal\",LOOKUP($F63,Nominal_to_Real,'Input|Rate of change'!T$23:T$26),INDEX('Input|Rate of change'!$C$14:$O$19,MATCH('Input|Step changes'!$F18,'Input|Rate of change'!$C$14:$C$19,0),MATCH('Calc|Opex forecast'!$F63,'Input|Rate of change'!$C$14:$O$14,0)))*IF('Input|Step changes'!$E18=\"$millions\",1000000,IF('Input|Step changes'!$E18=\"$000\",1000,1))/IF($E63=\"$millions\",1000000,IF($E63=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!Q18*IF('Input|Step changes'!$F18=\"nominal\",LOOKUP($F63,Nominal_to_Real,'Input|Rate of change'!U$23:U$26),INDEX('Input|Rate of change'!$C$14:$O$19,MATCH('Input|Step changes'!$F18,'Input|Rate of change'!$C$14:$C$19,0),MATCH('Calc|Opex forecast'!$F63,'Input|Rate of change'!$C$14:$O$14,0)))*IF('Input|Step changes'!$E18=\"$millions\",1000000,IF('Input|Step changes'!$E18=\"$000\",1000,1))/IF($E63=\"$millions\",1000000,IF($E63=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!R18*IF('Input|Step changes'!$F18=\"nominal\",LOOKUP($F63,Nominal_to_Real,'Input|Rate of change'!V$23:V$26),INDEX('Input|Rate of change'!$C$14:$O$19,MATCH('Input|Step changes'!$F18,'Input|Rate of change'!$C$14:$C$19,0),MATCH('Calc|Opex forecast'!$F63,'Input|Rate of change'!$C$14:$O$14,0)))*IF('Input|Step changes'!$E18=\"$millions\",1000000,IF('Input|Step changes'!$E18=\"$000\",1000,1))/IF($E63=\"$millions\",1000000,IF($E63=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!S18*IF('Input|Step changes'!$F18=\"nominal\",LOOKUP($F63,Nominal_to_Real,'Input|Rate of change'!W$23:W$26),INDEX('Input|Rate of change'!$C$14:$O$19,MATCH('Input|Step changes'!$F18,'Input|Rate of change'!$C$14:$C$19,0),MATCH('Calc|Opex forecast'!$F63,'Input|Rate of change'!$C$14:$O$14,0)))*IF('Input|Step changes'!$E18=\"$millions\",1000000,IF('Input|Step changes'!$E18=\"$000\",1000,1))/IF($E63=\"$millions\",1000000,IF($E63=\"$000\",1000,1))","v":0}]
[null,null,{"$f":"'Input|Step changes'!C19","v":0},"Calculated","$millions","2016-17",null,null,null,{"$f":"'Input|Step changes'!J19*IF('Input|Step changes'!$F19=\"nominal\",LOOKUP($F64,Nominal_to_Real,'Input|Rate of change'!N$23:N$26),INDEX('Input|Rate of change'!$C$14:$O$19,MATCH('Input|Step changes'!$F19,'Input|Rate of change'!$C$14:$C$19,0),MATCH('Calc|Opex forecast'!$F64,'Input|Rate of change'!$C$14:$O$14,0)))*IF('Input|Step changes'!$E19=\"$millions\",1000000,IF('Input|Step changes'!$E19=\"$000\",1000,1))/IF($E64=\"$millions\",1000000,IF($E64=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!K19*IF('Input|Step changes'!$F19=\"nominal\",LOOKUP($F64,Nominal_to_Real,'Input|Rate of change'!O$23:O$26),INDEX('Input|Rate of change'!$C$14:$O$19,MATCH('Input|Step changes'!$F19,'Input|Rate of change'!$C$14:$C$19,0),MATCH('Calc|Opex forecast'!$F64,'Input|Rate of change'!$C$14:$O$14,0)))*IF('Input|Step changes'!$E19=\"$millions\",1000000,IF('Input|Step changes'!$E19=\"$000\",1000,1))/IF($E64=\"$millions\",1000000,IF($E64=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!L19*IF('Input|Step changes'!$F19=\"nominal\",LOOKUP($F64,Nominal_to_Real,'Input|Rate of change'!P$23:P$26),INDEX('Input|Rate of change'!$C$14:$O$19,MATCH('Input|Step changes'!$F19,'Input|Rate of change'!$C$14:$C$19,0),MATCH('Calc|Opex forecast'!$F64,'Input|Rate of change'!$C$14:$O$14,0)))*IF('Input|Step changes'!$E19=\"$millions\",1000000,IF('Input|Step changes'!$E19=\"$000\",1000,1))/IF($E64=\"$millions\",1000000,IF($E64=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!M19*IF('Input|Step changes'!$F19=\"nominal\",LOOKUP($F64,Nominal_to_Real,'Input|Rate of change'!Q$23:Q$26),INDEX('Input|Rate of change'!$C$14:$O$19,MATCH('Input|Step changes'!$F19,'Input|Rate of change'!$C$14:$C$19,0),MATCH('Calc|Opex forecast'!$F64,'Input|Rate of change'!$C$14:$O$14,0)))*IF('Input|Step changes'!$E19=\"$millions\",1000000,IF('Input|Step changes'!$E19=\"$000\",1000,1))/IF($E64=\"$millions\",1000000,IF($E64=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!N19*IF('Input|Step changes'!$F19=\"nominal\",LOOKUP($F64,Nominal_to_Real,'Input|Rate of change'!R$23:R$26),INDEX('Input|Rate of change'!$C$14:$O$19,MATCH('Input|Step changes'!$F19,'Input|Rate of change'!$C$14:$C$19,0),MATCH('Calc|Opex forecast'!$F64,'Input|Rate of change'!$C$14:$O$14,0)))*IF('Input|Step changes'!$E19=\"$millions\",1000000,IF('Input|Step changes'!$E19=\"$000\",1000,1))/IF($E64=\"$millions\",1000000,IF($E64=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!O19*IF('Input|Step changes'!$F19=\"nominal\",LOOKUP($F64,Nominal_to_Real,'Input|Rate of change'!S$23:S$26),INDEX('Input|Rate of change'!$C$14:$O$19,MATCH('Input|Step changes'!$F19,'Input|Rate of change'!$C$14:$C$19,0),MATCH('Calc|Opex forecast'!$F64,'Input|Rate of change'!$C$14:$O$14,0)))*IF('Input|Step changes'!$E19=\"$millions\",1000000,IF('Input|Step changes'!$E19=\"$000\",1000,1))/IF($E64=\"$millions\",1000000,IF($E64=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!P19*IF('Input|Step changes'!$F19=\"nominal\",LOOKUP($F64,Nominal_to_Real,'Input|Rate of change'!T$23:T$26),INDEX('Input|Rate of change'!$C$14:$O$19,MATCH('Input|Step changes'!$F19,'Input|Rate of change'!$C$14:$C$19,0),MATCH('Calc|Opex forecast'!$F64,'Input|Rate of change'!$C$14:$O$14,0)))*IF('Input|Step changes'!$E19=\"$millions\",1000000,IF('Input|Step changes'!$E19=\"$000\",1000,1))/IF($E64=\"$millions\",1000000,IF($E64=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!Q19*IF('Input|Step changes'!$F19=\"nominal\",LOOKUP($F64,Nominal_to_Real,'Input|Rate of change'!U$23:U$26),INDEX('Input|Rate of change'!$C$14:$O$19,MATCH('Input|Step changes'!$F19,'Input|Rate of change'!$C$14:$C$19,0),MATCH('Calc|Opex forecast'!$F64,'Input|Rate of change'!$C$14:$O$14,0)))*IF('Input|Step changes'!$E19=\"$millions\",1000000,IF('Input|Step changes'!$E19=\"$000\",1000,1))/IF($E64=\"$millions\",1000000,IF($E64=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!R19*IF('Input|Step changes'!$F19=\"nominal\",LOOKUP($F64,Nominal_to_Real,'Input|Rate of change'!V$23:V$26),INDEX('Input|Rate of change'!$C$14:$O$19,MATCH('Input|Step changes'!$F19,'Input|Rate of change'!$C$14:$C$19,0),MATCH('Calc|Opex forecast'!$F64,'Input|Rate of change'!$C$14:$O$14,0)))*IF('Input|Step changes'!$E19=\"$millions\",1000000,IF('Input|Step changes'!$E19=\"$000\",1000,1))/IF($E64=\"$millions\",1000000,IF($E64=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!S19*IF('Input|Step changes'!$F19=\"nominal\",LOOKUP($F64,Nominal_to_Real,'Input|Rate of change'!W$23:W$26),INDEX('Input|Rate of change'!$C$14:$O$19,MATCH('Input|Step changes'!$F19,'Input|Rate of change'!$C$14:$C$19,0),MATCH('Calc|Opex forecast'!$F64,'Input|Rate of change'!$C$14:$O$14,0)))*IF('Input|Step changes'!$E19=\"$millions\",1000000,IF('Input|Step changes'!$E19=\"$000\",1000,1))/IF($E64=\"$millions\",1000000,IF($E64=\"$000\",1000,1))","v":0}]
[null,null,{"$f":"'Input|Step changes'!C20","v":0},"Calculated","$millions","2016-17",null,null,null,{"$f":"'Input|Step changes'!J20*IF('Input|Step changes'!$F20=\"nominal\",LOOKUP($F65,Nominal_to_Real,'Input|Rate of change'!N$23:N$26),INDEX('Input|Rate of change'!$C$14:$O$19,MATCH('Input|Step changes'!$F20,'Input|Rate of change'!$C$14:$C$19,0),MATCH('Calc|Opex forecast'!$F65,'Input|Rate of change'!$C$14:$O$14,0)))*IF('Input|Step changes'!$E20=\"$millions\",1000000,IF('Input|Step changes'!$E20=\"$000\",1000,1))/IF($E65=\"$millions\",1000000,IF($E65=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!K20*IF('Input|Step changes'!$F20=\"nominal\",LOOKUP($F65,Nominal_to_Real,'Input|Rate of change'!O$23:O$26),INDEX('Input|Rate of change'!$C$14:$O$19,MATCH('Input|Step changes'!$F20,'Input|Rate of change'!$C$14:$C$19,0),MATCH('Calc|Opex forecast'!$F65,'Input|Rate of change'!$C$14:$O$14,0)))*IF('Input|Step changes'!$E20=\"$millions\",1000000,IF('Input|Step changes'!$E20=\"$000\",1000,1))/IF($E65=\"$millions\",1000000,IF($E65=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!L20*IF('Input|Step changes'!$F20=\"nominal\",LOOKUP($F65,Nominal_to_Real,'Input|Rate of change'!P$23:P$26),INDEX('Input|Rate of change'!$C$14:$O$19,MATCH('Input|Step changes'!$F20,'Input|Rate of change'!$C$14:$C$19,0),MATCH('Calc|Opex forecast'!$F65,'Input|Rate of change'!$C$14:$O$14,0)))*IF('Input|Step changes'!$E20=\"$millions\",1000000,IF('Input|Step changes'!$E20=\"$000\",1000,1))/IF($E65=\"$millions\",1000000,IF($E65=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!M20*IF('Input|Step changes'!$F20=\"nominal\",LOOKUP($F65,Nominal_to_Real,'Input|Rate of change'!Q$23:Q$26),INDEX('Input|Rate of change'!$C$14:$O$19,MATCH('Input|Step changes'!$F20,'Input|Rate of change'!$C$14:$C$19,0),MATCH('Calc|Opex forecast'!$F65,'Input|Rate of change'!$C$14:$O$14,0)))*IF('Input|Step changes'!$E20=\"$millions\",1000000,IF('Input|Step changes'!$E20=\"$000\",1000,1))/IF($E65=\"$millions\",1000000,IF($E65=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!N20*IF('Input|Step changes'!$F20=\"nominal\",LOOKUP($F65,Nominal_to_Real,'Input|Rate of change'!R$23:R$26),INDEX('Input|Rate of change'!$C$14:$O$19,MATCH('Input|Step changes'!$F20,'Input|Rate of change'!$C$14:$C$19,0),MATCH('Calc|Opex forecast'!$F65,'Input|Rate of change'!$C$14:$O$14,0)))*IF('Input|Step changes'!$E20=\"$millions\",1000000,IF('Input|Step changes'!$E20=\"$000\",1000,1))/IF($E65=\"$millions\",1000000,IF($E65=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!O20*IF('Input|Step changes'!$F20=\"nominal\",LOOKUP($F65,Nominal_to_Real,'Input|Rate of change'!S$23:S$26),INDEX('Input|Rate of change'!$C$14:$O$19,MATCH('Input|Step changes'!$F20,'Input|Rate of change'!$C$14:$C$19,0),MATCH('Calc|Opex forecast'!$F65,'Input|Rate of change'!$C$14:$O$14,0)))*IF('Input|Step changes'!$E20=\"$millions\",1000000,IF('Input|Step changes'!$E20=\"$000\",1000,1))/IF($E65=\"$millions\",1000000,IF($E65=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!P20*IF('Input|Step changes'!$F20=\"nominal\",LOOKUP($F65,Nominal_to_Real,'Input|Rate of change'!T$23:T$26),INDEX('Input|Rate of change'!$C$14:$O$19,MATCH('Input|Step changes'!$F20,'Input|Rate of change'!$C$14:$C$19,0),MATCH('Calc|Opex forecast'!$F65,'Input|Rate of change'!$C$14:$O$14,0)))*IF('Input|Step changes'!$E20=\"$millions\",1000000,IF('Input|Step changes'!$E20=\"$000\",1000,1))/IF($E65=\"$millions\",1000000,IF($E65=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!Q20*IF('Input|Step changes'!$F20=\"nominal\",LOOKUP($F65,Nominal_to_Real,'Input|Rate of change'!U$23:U$26),INDEX('Input|Rate of change'!$C$14:$O$19,MATCH('Input|Step changes'!$F20,'Input|Rate of change'!$C$14:$C$19,0),MATCH('Calc|Opex forecast'!$F65,'Input|Rate of change'!$C$14:$O$14,0)))*IF('Input|Step changes'!$E20=\"$millions\",1000000,IF('Input|Step changes'!$E20=\"$000\",1000,1))/IF($E65=\"$millions\",1000000,IF($E65=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!R20*IF('Input|Step changes'!$F20=\"nominal\",LOOKUP($F65,Nominal_to_Real,'Input|Rate of change'!V$23:V$26),INDEX('Input|Rate of change'!$C$14:$O$19,MATCH('Input|Step changes'!$F20,'Input|Rate of change'!$C$14:$C$19,0),MATCH('Calc|Opex forecast'!$F65,'Input|Rate of change'!$C$14:$O$14,0)))*IF('Input|Step changes'!$E20=\"$millions\",1000000,IF('Input|Step changes'!$E20=\"$000\",1000,1))/IF($E65=\"$millions\",1000000,IF($E65=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!S20*IF('Input|Step changes'!$F20=\"nominal\",LOOKUP($F65,Nominal_to_Real,'Input|Rate of change'!W$23:W$26),INDEX('Input|Rate of change'!$C$14:$O$19,MATCH('Input|Step changes'!$F20,'Input|Rate of change'!$C$14:$C$19,0),MATCH('Calc|Opex forecast'!$F65,'Input|Rate of change'!$C$14:$O$14,0)))*IF('Input|Step changes'!$E20=\"$millions\",1000000,IF('Input|Step changes'!$E20=\"$000\",1000,1))/IF($E65=\"$millions\",1000000,IF($E65=\"$000\",1000,1))","v":0}]
[null,null,{"$f":"'Input|Step changes'!C21","v":0},"Calculated","$millions","2016-17",null,null,null,{"$f":"'Input|Step changes'!J21*IF('Input|Step changes'!$F21=\"nominal\",LOOKUP($F66,Nominal_to_Real,'Input|Rate of change'!N$23:N$26),INDEX('Input|Rate of change'!$C$14:$O$19,MATCH('Input|Step changes'!$F21,'Input|Rate of change'!$C$14:$C$19,0),MATCH('Calc|Opex forecast'!$F66,'Input|Rate of change'!$C$14:$O$14,0)))*IF('Input|Step changes'!$E21=\"$millions\",1000000,IF('Input|Step changes'!$E21=\"$000\",1000,1))/IF($E66=\"$millions\",1000000,IF($E66=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!K21*IF('Input|Step changes'!$F21=\"nominal\",LOOKUP($F66,Nominal_to_Real,'Input|Rate of change'!O$23:O$26),INDEX('Input|Rate of change'!$C$14:$O$19,MATCH('Input|Step changes'!$F21,'Input|Rate of change'!$C$14:$C$19,0),MATCH('Calc|Opex forecast'!$F66,'Input|Rate of change'!$C$14:$O$14,0)))*IF('Input|Step changes'!$E21=\"$millions\",1000000,IF('Input|Step changes'!$E21=\"$000\",1000,1))/IF($E66=\"$millions\",1000000,IF($E66=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!L21*IF('Input|Step changes'!$F21=\"nominal\",LOOKUP($F66,Nominal_to_Real,'Input|Rate of change'!P$23:P$26),INDEX('Input|Rate of change'!$C$14:$O$19,MATCH('Input|Step changes'!$F21,'Input|Rate of change'!$C$14:$C$19,0),MATCH('Calc|Opex forecast'!$F66,'Input|Rate of change'!$C$14:$O$14,0)))*IF('Input|Step changes'!$E21=\"$millions\",1000000,IF('Input|Step changes'!$E21=\"$000\",1000,1))/IF($E66=\"$millions\",1000000,IF($E66=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!M21*IF('Input|Step changes'!$F21=\"nominal\",LOOKUP($F66,Nominal_to_Real,'Input|Rate of change'!Q$23:Q$26),INDEX('Input|Rate of change'!$C$14:$O$19,MATCH('Input|Step changes'!$F21,'Input|Rate of change'!$C$14:$C$19,0),MATCH('Calc|Opex forecast'!$F66,'Input|Rate of change'!$C$14:$O$14,0)))*IF('Input|Step changes'!$E21=\"$millions\",1000000,IF('Input|Step changes'!$E21=\"$000\",1000,1))/IF($E66=\"$millions\",1000000,IF($E66=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!N21*IF('Input|Step changes'!$F21=\"nominal\",LOOKUP($F66,Nominal_to_Real,'Input|Rate of change'!R$23:R$26),INDEX('Input|Rate of change'!$C$14:$O$19,MATCH('Input|Step changes'!$F21,'Input|Rate of change'!$C$14:$C$19,0),MATCH('Calc|Opex forecast'!$F66,'Input|Rate of change'!$C$14:$O$14,0)))*IF('Input|Step changes'!$E21=\"$millions\",1000000,IF('Input|Step changes'!$E21=\"$000\",1000,1))/IF($E66=\"$millions\",1000000,IF($E66=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!O21*IF('Input|Step changes'!$F21=\"nominal\",LOOKUP($F66,Nominal_to_Real,'Input|Rate of change'!S$23:S$26),INDEX('Input|Rate of change'!$C$14:$O$19,MATCH('Input|Step changes'!$F21,'Input|Rate of change'!$C$14:$C$19,0),MATCH('Calc|Opex forecast'!$F66,'Input|Rate of change'!$C$14:$O$14,0)))*IF('Input|Step changes'!$E21=\"$millions\",1000000,IF('Input|Step changes'!$E21=\"$000\",1000,1))/IF($E66=\"$millions\",1000000,IF($E66=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!P21*IF('Input|Step changes'!$F21=\"nominal\",LOOKUP($F66,Nominal_to_Real,'Input|Rate of change'!T$23:T$26),INDEX('Input|Rate of change'!$C$14:$O$19,MATCH('Input|Step changes'!$F21,'Input|Rate of change'!$C$14:$C$19,0),MATCH('Calc|Opex forecast'!$F66,'Input|Rate of change'!$C$14:$O$14,0)))*IF('Input|Step changes'!$E21=\"$millions\",1000000,IF('Input|Step changes'!$E21=\"$000\",1000,1))/IF($E66=\"$millions\",1000000,IF($E66=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!Q21*IF('Input|Step changes'!$F21=\"nominal\",LOOKUP($F66,Nominal_to_Real,'Input|Rate of change'!U$23:U$26),INDEX('Input|Rate of change'!$C$14:$O$19,MATCH('Input|Step changes'!$F21,'Input|Rate of change'!$C$14:$C$19,0),MATCH('Calc|Opex forecast'!$F66,'Input|Rate of change'!$C$14:$O$14,0)))*IF('Input|Step changes'!$E21=\"$millions\",1000000,IF('Input|Step changes'!$E21=\"$000\",1000,1))/IF($E66=\"$millions\",1000000,IF($E66=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!R21*IF('Input|Step changes'!$F21=\"nominal\",LOOKUP($F66,Nominal_to_Real,'Input|Rate of change'!V$23:V$26),INDEX('Input|Rate of change'!$C$14:$O$19,MATCH('Input|Step changes'!$F21,'Input|Rate of change'!$C$14:$C$19,0),MATCH('Calc|Opex forecast'!$F66,'Input|Rate of change'!$C$14:$O$14,0)))*IF('Input|Step changes'!$E21=\"$millions\",1000000,IF('Input|Step changes'!$E21=\"$000\",1000,1))/IF($E66=\"$millions\",1000000,IF($E66=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!S21*IF('Input|Step changes'!$F21=\"nominal\",LOOKUP($F66,Nominal_to_Real,'Input|Rate of change'!W$23:W$26),INDEX('Input|Rate of change'!$C$14:$O$19,MATCH('Input|Step changes'!$F21,'Input|Rate of change'!$C$14:$C$19,0),MATCH('Calc|Opex forecast'!$F66,'Input|Rate of change'!$C$14:$O$14,0)))*IF('Input|Step changes'!$E21=\"$millions\",1000000,IF('Input|Step changes'!$E21=\"$000\",1000,1))/IF($E66=\"$millions\",1000000,IF($E66=\"$000\",1000,1))","v":0}]
[null,null,{"$f":"'Input|Step changes'!C22","v":0},"Calculated","$millions","2016-17",null,null,null,{"$f":"'Input|Step changes'!J22*IF('Input|Step changes'!$F22=\"nominal\",LOOKUP($F67,Nominal_to_Real,'Input|Rate of change'!N$23:N$26),INDEX('Input|Rate of change'!$C$14:$O$19,MATCH('Input|Step changes'!$F22,'Input|Rate of change'!$C$14:$C$19,0),MATCH('Calc|Opex forecast'!$F67,'Input|Rate of change'!$C$14:$O$14,0)))*IF('Input|Step changes'!$E22=\"$millions\",1000000,IF('Input|Step changes'!$E22=\"$000\",1000,1))/IF($E67=\"$millions\",1000000,IF($E67=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!K22*IF('Input|Step changes'!$F22=\"nominal\",LOOKUP($F67,Nominal_to_Real,'Input|Rate of change'!O$23:O$26),INDEX('Input|Rate of change'!$C$14:$O$19,MATCH('Input|Step changes'!$F22,'Input|Rate of change'!$C$14:$C$19,0),MATCH('Calc|Opex forecast'!$F67,'Input|Rate of change'!$C$14:$O$14,0)))*IF('Input|Step changes'!$E22=\"$millions\",1000000,IF('Input|Step changes'!$E22=\"$000\",1000,1))/IF($E67=\"$millions\",1000000,IF($E67=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!L22*IF('Input|Step changes'!$F22=\"nominal\",LOOKUP($F67,Nominal_to_Real,'Input|Rate of change'!P$23:P$26),INDEX('Input|Rate of change'!$C$14:$O$19,MATCH('Input|Step changes'!$F22,'Input|Rate of change'!$C$14:$C$19,0),MATCH('Calc|Opex forecast'!$F67,'Input|Rate of change'!$C$14:$O$14,0)))*IF('Input|Step changes'!$E22=\"$millions\",1000000,IF('Input|Step changes'!$E22=\"$000\",1000,1))/IF($E67=\"$millions\",1000000,IF($E67=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!M22*IF('Input|Step changes'!$F22=\"nominal\",LOOKUP($F67,Nominal_to_Real,'Input|Rate of change'!Q$23:Q$26),INDEX('Input|Rate of change'!$C$14:$O$19,MATCH('Input|Step changes'!$F22,'Input|Rate of change'!$C$14:$C$19,0),MATCH('Calc|Opex forecast'!$F67,'Input|Rate of change'!$C$14:$O$14,0)))*IF('Input|Step changes'!$E22=\"$millions\",1000000,IF('Input|Step changes'!$E22=\"$000\",1000,1))/IF($E67=\"$millions\",1000000,IF($E67=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!N22*IF('Input|Step changes'!$F22=\"nominal\",LOOKUP($F67,Nominal_to_Real,'Input|Rate of change'!R$23:R$26),INDEX('Input|Rate of change'!$C$14:$O$19,MATCH('Input|Step changes'!$F22,'Input|Rate of change'!$C$14:$C$19,0),MATCH('Calc|Opex forecast'!$F67,'Input|Rate of change'!$C$14:$O$14,0)))*IF('Input|Step changes'!$E22=\"$millions\",1000000,IF('Input|Step changes'!$E22=\"$000\",1000,1))/IF($E67=\"$millions\",1000000,IF($E67=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!O22*IF('Input|Step changes'!$F22=\"nominal\",LOOKUP($F67,Nominal_to_Real,'Input|Rate of change'!S$23:S$26),INDEX('Input|Rate of change'!$C$14:$O$19,MATCH('Input|Step changes'!$F22,'Input|Rate of change'!$C$14:$C$19,0),MATCH('Calc|Opex forecast'!$F67,'Input|Rate of change'!$C$14:$O$14,0)))*IF('Input|Step changes'!$E22=\"$millions\",1000000,IF('Input|Step changes'!$E22=\"$000\",1000,1))/IF($E67=\"$millions\",1000000,IF($E67=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!P22*IF('Input|Step changes'!$F22=\"nominal\",LOOKUP($F67,Nominal_to_Real,'Input|Rate of change'!T$23:T$26),INDEX('Input|Rate of change'!$C$14:$O$19,MATCH('Input|Step changes'!$F22,'Input|Rate of change'!$C$14:$C$19,0),MATCH('Calc|Opex forecast'!$F67,'Input|Rate of change'!$C$14:$O$14,0)))*IF('Input|Step changes'!$E22=\"$millions\",1000000,IF('Input|Step changes'!$E22=\"$000\",1000,1))/IF($E67=\"$millions\",1000000,IF($E67=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!Q22*IF('Input|Step changes'!$F22=\"nominal\",LOOKUP($F67,Nominal_to_Real,'Input|Rate of change'!U$23:U$26),INDEX('Input|Rate of change'!$C$14:$O$19,MATCH('Input|Step changes'!$F22,'Input|Rate of change'!$C$14:$C$19,0),MATCH('Calc|Opex forecast'!$F67,'Input|Rate of change'!$C$14:$O$14,0)))*IF('Input|Step changes'!$E22=\"$millions\",1000000,IF('Input|Step changes'!$E22=\"$000\",1000,1))/IF($E67=\"$millions\",1000000,IF($E67=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!R22*IF('Input|Step changes'!$F22=\"nominal\",LOOKUP($F67,Nominal_to_Real,'Input|Rate of change'!V$23:V$26),INDEX('Input|Rate of change'!$C$14:$O$19,MATCH('Input|Step changes'!$F22,'Input|Rate of change'!$C$14:$C$19,0),MATCH('Calc|Opex forecast'!$F67,'Input|Rate of change'!$C$14:$O$14,0)))*IF('Input|Step changes'!$E22=\"$millions\",1000000,IF('Input|Step changes'!$E22=\"$000\",1000,1))/IF($E67=\"$millions\",1000000,IF($E67=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!S22*IF('Input|Step changes'!$F22=\"nominal\",LOOKUP($F67,Nominal_to_Real,'Input|Rate of change'!W$23:W$26),INDEX('Input|Rate of change'!$C$14:$O$19,MATCH('Input|Step changes'!$F22,'Input|Rate of change'!$C$14:$C$19,0),MATCH('Calc|Opex forecast'!$F67,'Input|Rate of change'!$C$14:$O$14,0)))*IF('Input|Step changes'!$E22=\"$millions\",1000000,IF('Input|Step changes'!$E22=\"$000\",1000,1))/IF($E67=\"$millions\",1000000,IF($E67=\"$000\",1000,1))","v":0}]
[null,null,{"$f":"'Input|Step changes'!C23","v":0},"Calculated","$millions","2016-17",null,null,null,{"$f":"'Input|Step changes'!J23*IF('Input|Step changes'!$F23=\"nominal\",LOOKUP($F68,Nominal_to_Real,'Input|Rate of change'!N$23:N$26),INDEX('Input|Rate of change'!$C$14:$O$19,MATCH('Input|Step changes'!$F23,'Input|Rate of change'!$C$14:$C$19,0),MATCH('Calc|Opex forecast'!$F68,'Input|Rate of change'!$C$14:$O$14,0)))*IF('Input|Step changes'!$E23=\"$millions\",1000000,IF('Input|Step changes'!$E23=\"$000\",1000,1))/IF($E68=\"$millions\",1000000,IF($E68=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!K23*IF('Input|Step changes'!$F23=\"nominal\",LOOKUP($F68,Nominal_to_Real,'Input|Rate of change'!O$23:O$26),INDEX('Input|Rate of change'!$C$14:$O$19,MATCH('Input|Step changes'!$F23,'Input|Rate of change'!$C$14:$C$19,0),MATCH('Calc|Opex forecast'!$F68,'Input|Rate of change'!$C$14:$O$14,0)))*IF('Input|Step changes'!$E23=\"$millions\",1000000,IF('Input|Step changes'!$E23=\"$000\",1000,1))/IF($E68=\"$millions\",1000000,IF($E68=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!L23*IF('Input|Step changes'!$F23=\"nominal\",LOOKUP($F68,Nominal_to_Real,'Input|Rate of change'!P$23:P$26),INDEX('Input|Rate of change'!$C$14:$O$19,MATCH('Input|Step changes'!$F23,'Input|Rate of change'!$C$14:$C$19,0),MATCH('Calc|Opex forecast'!$F68,'Input|Rate of change'!$C$14:$O$14,0)))*IF('Input|Step changes'!$E23=\"$millions\",1000000,IF('Input|Step changes'!$E23=\"$000\",1000,1))/IF($E68=\"$millions\",1000000,IF($E68=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!M23*IF('Input|Step changes'!$F23=\"nominal\",LOOKUP($F68,Nominal_to_Real,'Input|Rate of change'!Q$23:Q$26),INDEX('Input|Rate of change'!$C$14:$O$19,MATCH('Input|Step changes'!$F23,'Input|Rate of change'!$C$14:$C$19,0),MATCH('Calc|Opex forecast'!$F68,'Input|Rate of change'!$C$14:$O$14,0)))*IF('Input|Step changes'!$E23=\"$millions\",1000000,IF('Input|Step changes'!$E23=\"$000\",1000,1))/IF($E68=\"$millions\",1000000,IF($E68=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!N23*IF('Input|Step changes'!$F23=\"nominal\",LOOKUP($F68,Nominal_to_Real,'Input|Rate of change'!R$23:R$26),INDEX('Input|Rate of change'!$C$14:$O$19,MATCH('Input|Step changes'!$F23,'Input|Rate of change'!$C$14:$C$19,0),MATCH('Calc|Opex forecast'!$F68,'Input|Rate of change'!$C$14:$O$14,0)))*IF('Input|Step changes'!$E23=\"$millions\",1000000,IF('Input|Step changes'!$E23=\"$000\",1000,1))/IF($E68=\"$millions\",1000000,IF($E68=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!O23*IF('Input|Step changes'!$F23=\"nominal\",LOOKUP($F68,Nominal_to_Real,'Input|Rate of change'!S$23:S$26),INDEX('Input|Rate of change'!$C$14:$O$19,MATCH('Input|Step changes'!$F23,'Input|Rate of change'!$C$14:$C$19,0),MATCH('Calc|Opex forecast'!$F68,'Input|Rate of change'!$C$14:$O$14,0)))*IF('Input|Step changes'!$E23=\"$millions\",1000000,IF('Input|Step changes'!$E23=\"$000\",1000,1))/IF($E68=\"$millions\",1000000,IF($E68=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!P23*IF('Input|Step changes'!$F23=\"nominal\",LOOKUP($F68,Nominal_to_Real,'Input|Rate of change'!T$23:T$26),INDEX('Input|Rate of change'!$C$14:$O$19,MATCH('Input|Step changes'!$F23,'Input|Rate of change'!$C$14:$C$19,0),MATCH('Calc|Opex forecast'!$F68,'Input|Rate of change'!$C$14:$O$14,0)))*IF('Input|Step changes'!$E23=\"$millions\",1000000,IF('Input|Step changes'!$E23=\"$000\",1000,1))/IF($E68=\"$millions\",1000000,IF($E68=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!Q23*IF('Input|Step changes'!$F23=\"nominal\",LOOKUP($F68,Nominal_to_Real,'Input|Rate of change'!U$23:U$26),INDEX('Input|Rate of change'!$C$14:$O$19,MATCH('Input|Step changes'!$F23,'Input|Rate of change'!$C$14:$C$19,0),MATCH('Calc|Opex forecast'!$F68,'Input|Rate of change'!$C$14:$O$14,0)))*IF('Input|Step changes'!$E23=\"$millions\",1000000,IF('Input|Step changes'!$E23=\"$000\",1000,1))/IF($E68=\"$millions\",1000000,IF($E68=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!R23*IF('Input|Step changes'!$F23=\"nominal\",LOOKUP($F68,Nominal_to_Real,'Input|Rate of change'!V$23:V$26),INDEX('Input|Rate of change'!$C$14:$O$19,MATCH('Input|Step changes'!$F23,'Input|Rate of change'!$C$14:$C$19,0),MATCH('Calc|Opex forecast'!$F68,'Input|Rate of change'!$C$14:$O$14,0)))*IF('Input|Step changes'!$E23=\"$millions\",1000000,IF('Input|Step changes'!$E23=\"$000\",1000,1))/IF($E68=\"$millions\",1000000,IF($E68=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!S23*IF('Input|Step changes'!$F23=\"nominal\",LOOKUP($F68,Nominal_to_Real,'Input|Rate of change'!W$23:W$26),INDEX('Input|Rate of change'!$C$14:$O$19,MATCH('Input|Step changes'!$F23,'Input|Rate of change'!$C$14:$C$19,0),MATCH('Calc|Opex forecast'!$F68,'Input|Rate of change'!$C$14:$O$14,0)))*IF('Input|Step changes'!$E23=\"$millions\",1000000,IF('Input|Step changes'!$E23=\"$000\",1000,1))/IF($E68=\"$millions\",1000000,IF($E68=\"$000\",1000,1))","v":0}]
[]
[null,null,"Total step changes","Calculated",{"$f":"$E$8","v":"$millions"},{"$f":"$F$8","v":"2016-17"},null,null,null,{"$f":"SUM(J57:J69)","v":0},{"$f":"SUM(K57:K69)","v":0},0,0,0,{"$f":"SUM(O57:O69)","v":0},0,0,0,0]
[]
[null,"Calc | Category specific forecasts"]
[]
[null,null,"Category specific forecasts","Source","Unit","Basis",null,null,null,{"$f":"IF(RIGHT(J$4,2)>=RIGHT('Input|General'!$G$11,2),IF(RIGHT(J$4,2)<=RIGHT('Input|General'!$G$12,2),J$4,\"\"),\"\")","v":""},{"$f":"IF(RIGHT(K$4,2)>=RIGHT('Input|General'!$G$11,2),IF(RIGHT(K$4,2)<=RIGHT('Input|General'!$G$12,2),K$4,\"\"),\"\")","v":""},{"$f":"IF(RIGHT(L$4,2)>=RIGHT('Input|General'!$G$11,2),IF(RIGHT(L$4,2)<=RIGHT('Input|General'!$G$12,2),L$4,\"\"),\"\")","v":""},{"$f":"IF(RIGHT(M$4,2)>=RIGHT('Input|General'!$G$11,2),IF(RIGHT(M$4,2)<=RIGHT('Input|General'!$G$12,2),M$4,\"\"),\"\")","v":"2017-18"},{"$f":"IF(RIGHT(N$4,2)>=RIGHT('Input|General'!$G$11,2),IF(RIGHT(N$4,2)<=RIGHT('Input|General'!$G$12,2),N$4,\"\"),\"\")","v":"2018-19"},{"$f":"IF(RIGHT(O$4,2)>=RIGHT('Input|General'!$G$11,2),IF(RIGHT(O$4,2)<=RIGHT('Input|General'!$G$12,2),O$4,\"\"),\"\")","v":"2019-20"},{"$f":"IF(RIGHT(P$4,2)>=RIGHT('Input|General'!$G$11,2),IF(RIGHT(P$4,2)<=RIGHT('Input|General'!$G$12,2),P$4,\"\"),\"\")","v":"2020-21"},{"$f":"IF(RIGHT(Q$4,2)>=RIGHT('Input|General'!$G$11,2),IF(RIGHT(Q$4,2)<=RIGHT('Input|General'!$G$12,2),Q$4,\"\"),\"\")","v":"2021-22"},{"$f":"IF(RIGHT(R$4,2)>=RIGHT('Input|General'!$G$11,2),IF(RIGHT(R$4,2)<=RIGHT('Input|General'!$G$12,2),R$4,\"\"),\"\")","v":""},{"$f":"IF(RIGHT(S$4,2)>=RIGHT('Input|General'!$G$11,2),IF(RIGHT(S$4,2)<=RIGHT('Input|General'!$G$12,2),S$4,\"\"),\"\")","v":""}]
[]
[null,null,{"$f":"'Input|Step changes'!C29","v":"Easement tax"},"Calculated",{"$f":"$E$8","v":"$millions"},{"$f":"$F$8","v":"2016-17"},null,null,null,{"$f":"'Input|Step changes'!J29*IF('Input|Step changes'!$F29=\"nominal\",LOOKUP($F76,Nominal_to_Real,'Input|Rate of change'!N$23:N$26),INDEX('Input|Rate of change'!$C$14:$O$19,MATCH('Input|Step changes'!$F29,'Input|Rate of change'!$C$14:$C$19,0),MATCH('Calc|Opex forecast'!$F76,'Input|Rate of change'!$C$14:$O$14,0)))*IF('Input|Step changes'!$E29=\"$millions\",1000000,IF('Input|Step changes'!$E29=\"$000\",1000,1))/IF($E76=\"$millions\",1000000,IF($E76=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!K29*IF('Input|Step changes'!$F29=\"nominal\",LOOKUP($F76,Nominal_to_Real,'Input|Rate of change'!O$23:O$26),INDEX('Input|Rate of change'!$C$14:$O$19,MATCH('Input|Step changes'!$F29,'Input|Rate of change'!$C$14:$C$19,0),MATCH('Calc|Opex forecast'!$F76,'Input|Rate of change'!$C$14:$O$14,0)))*IF('Input|Step changes'!$E29=\"$millions\",1000000,IF('Input|Step changes'!$E29=\"$000\",1000,1))/IF($E76=\"$millions\",1000000,IF($E76=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!L29*IF('Input|Step changes'!$F29=\"nominal\",LOOKUP($F76,Nominal_to_Real,'Input|Rate of change'!P$23:P$26),INDEX('Input|Rate of change'!$C$14:$O$19,MATCH('Input|Step changes'!$F29,'Input|Rate of change'!$C$14:$C$19,0),MATCH('Calc|Opex forecast'!$F76,'Input|Rate of change'!$C$14:$O$14,0)))*IF('Input|Step changes'!$E29=\"$millions\",1000000,IF('Input|Step changes'!$E29=\"$000\",1000,1))/IF($E76=\"$millions\",1000000,IF($E76=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!M29*IF('Input|Step changes'!$F29=\"nominal\",LOOKUP($F76,Nominal_to_Real,'Input|Rate of change'!Q$23:Q$26),INDEX('Input|Rate of change'!$C$14:$O$19,MATCH('Input|Step changes'!$F29,'Input|Rate of change'!$C$14:$C$19,0),MATCH('Calc|Opex forecast'!$F76,'Input|Rate of change'!$C$14:$O$14,0)))*IF('Input|Step changes'!$E29=\"$millions\",1000000,IF('Input|Step changes'!$E29=\"$000\",1000,1))/IF($E76=\"$millions\",1000000,IF($E76=\"$000\",1000,1))","v":114.31425505580884},{"$f":"'Input|Step changes'!N29*IF('Input|Step changes'!$F29=\"nominal\",LOOKUP($F76,Nominal_to_Real,'Input|Rate of change'!R$23:R$26),INDEX('Input|Rate of change'!$C$14:$O$19,MATCH('Input|Step changes'!$F29,'Input|Rate of change'!$C$14:$C$19,0),MATCH('Calc|Opex forecast'!$F76,'Input|Rate of change'!$C$14:$O$14,0)))*IF('Input|Step changes'!$E29=\"$millions\",1000000,IF('Input|Step changes'!$E29=\"$000\",1000,1))/IF($E76=\"$millions\",1000000,IF($E76=\"$000\",1000,1))","v":114.31425505580884},{"$f":"'Input|Step changes'!O29*IF('Input|Step changes'!$F29=\"nominal\",LOOKUP($F76,Nominal_to_Real,'Input|Rate of change'!S$23:S$26),INDEX('Input|Rate of change'!$C$14:$O$19,MATCH('Input|Step changes'!$F29,'Input|Rate of change'!$C$14:$C$19,0),MATCH('Calc|Opex forecast'!$F76,'Input|Rate of change'!$C$14:$O$14,0)))*IF('Input|Step changes'!$E29=\"$millions\",1000000,IF('Input|Step changes'!$E29=\"$000\",1000,1))/IF($E76=\"$millions\",1000000,IF($E76=\"$000\",1000,1))","v":114.31425505580884},{"$f":"'Input|Step changes'!P29*IF('Input|Step changes'!$F29=\"nominal\",LOOKUP($F76,Nominal_to_Real,'Input|Rate of change'!T$23:T$26),INDEX('Input|Rate of change'!$C$14:$O$19,MATCH('Input|Step changes'!$F29,'Input|Rate of change'!$C$14:$C$19,0),MATCH('Calc|Opex forecast'!$F76,'Input|Rate of change'!$C$14:$O$14,0)))*IF('Input|Step changes'!$E29=\"$millions\",1000000,IF('Input|Step changes'!$E29=\"$000\",1000,1))/IF($E76=\"$millions\",1000000,IF($E76=\"$000\",1000,1))","v":114.31425505580884},{"$f":"'Input|Step changes'!Q29*IF('Input|Step changes'!$F29=\"nominal\",LOOKUP($F76,Nominal_to_Real,'Input|Rate of change'!U$23:U$26),INDEX('Input|Rate of change'!$C$14:$O$19,MATCH('Input|Step changes'!$F29,'Input|Rate of change'!$C$14:$C$19,0),MATCH('Calc|Opex forecast'!$F76,'Input|Rate of change'!$C$14:$O$14,0)))*IF('Input|Step changes'!$E29=\"$millions\",1000000,IF('Input|Step changes'!$E29=\"$000\",1000,1))/IF($E76=\"$millions\",1000000,IF($E76=\"$000\",1000,1))","v":114.31425505580884},{"$f":"'Input|Step changes'!R29*IF('Input|Step changes'!$F29=\"nominal\",LOOKUP($F76,Nominal_to_Real,'Input|Rate of change'!V$23:V$26),INDEX('Input|Rate of change'!$C$14:$O$19,MATCH('Input|Step changes'!$F29,'Input|Rate of change'!$C$14:$C$19,0),MATCH('Calc|Opex forecast'!$F76,'Input|Rate of change'!$C$14:$O$14,0)))*IF('Input|Step changes'!$E29=\"$millions\",1000000,IF('Input|Step changes'!$E29=\"$000\",1000,1))/IF($E76=\"$millions\",1000000,IF($E76=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!S29*IF('Input|Step changes'!$F29=\"nominal\",LOOKUP($F76,Nominal_to_Real,'Input|Rate of change'!W$23:W$26),INDEX('Input|Rate of change'!$C$14:$O$19,MATCH('Input|Step changes'!$F29,'Input|Rate of change'!$C$14:$C$19,0),MATCH('Calc|Opex forecast'!$F76,'Input|Rate of change'!$C$14:$O$14,0)))*IF('Input|Step changes'!$E29=\"$millions\",1000000,IF('Input|Step changes'!$E29=\"$000\",1000,1))/IF($E76=\"$millions\",1000000,IF($E76=\"$000\",1000,1))","v":0}]
[null,null,{"$f":"'Input|Step changes'!C30","v":"Group 3 roll in"},"Calculated","$millions",{"$f":"$F$8","v":"2016-17"},null,null,null,{"$f":"'Input|Step changes'!J30*IF('Input|Step changes'!$F30=\"nominal\",LOOKUP($F77,Nominal_to_Real,'Input|Rate of change'!N$23:N$26),INDEX('Input|Rate of change'!$C$14:$O$19,MATCH('Input|Step changes'!$F30,'Input|Rate of change'!$C$14:$C$19,0),MATCH('Calc|Opex forecast'!$F77,'Input|Rate of change'!$C$14:$O$14,0)))*IF('Input|Step changes'!$E30=\"$millions\",1000000,IF('Input|Step changes'!$E30=\"$000\",1000,1))/IF($E77=\"$millions\",1000000,IF($E77=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!K30*IF('Input|Step changes'!$F30=\"nominal\",LOOKUP($F77,Nominal_to_Real,'Input|Rate of change'!O$23:O$26),INDEX('Input|Rate of change'!$C$14:$O$19,MATCH('Input|Step changes'!$F30,'Input|Rate of change'!$C$14:$C$19,0),MATCH('Calc|Opex forecast'!$F77,'Input|Rate of change'!$C$14:$O$14,0)))*IF('Input|Step changes'!$E30=\"$millions\",1000000,IF('Input|Step changes'!$E30=\"$000\",1000,1))/IF($E77=\"$millions\",1000000,IF($E77=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!L30*IF('Input|Step changes'!$F30=\"nominal\",LOOKUP($F77,Nominal_to_Real,'Input|Rate of change'!P$23:P$26),INDEX('Input|Rate of change'!$C$14:$O$19,MATCH('Input|Step changes'!$F30,'Input|Rate of change'!$C$14:$C$19,0),MATCH('Calc|Opex forecast'!$F77,'Input|Rate of change'!$C$14:$O$14,0)))*IF('Input|Step changes'!$E30=\"$millions\",1000000,IF('Input|Step changes'!$E30=\"$000\",1000,1))/IF($E77=\"$millions\",1000000,IF($E77=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!M30*IF('Input|Step changes'!$F30=\"nominal\",LOOKUP($F77,Nominal_to_Real,'Input|Rate of change'!Q$23:Q$26),INDEX('Input|Rate of change'!$C$14:$O$19,MATCH('Input|Step changes'!$F30,'Input|Rate of change'!$C$14:$C$19,0),MATCH('Calc|Opex forecast'!$F77,'Input|Rate of change'!$C$14:$O$14,0)))*IF('Input|Step changes'!$E30=\"$millions\",1000000,IF('Input|Step changes'!$E30=\"$000\",1000,1))/IF($E77=\"$millions\",1000000,IF($E77=\"$000\",1000,1))","v":2.0044134484216118},{"$f":"'Input|Step changes'!N30*IF('Input|Step changes'!$F30=\"nominal\",LOOKUP($F77,Nominal_to_Real,'Input|Rate of change'!R$23:R$26),INDEX('Input|Rate of change'!$C$14:$O$19,MATCH('Input|Step changes'!$F30,'Input|Rate of change'!$C$14:$C$19,0),MATCH('Calc|Opex forecast'!$F77,'Input|Rate of change'!$C$14:$O$14,0)))*IF('Input|Step changes'!$E30=\"$millions\",1000000,IF('Input|Step changes'!$E30=\"$000\",1000,1))/IF($E77=\"$millions\",1000000,IF($E77=\"$000\",1000,1))","v":2.0044134484216118},{"$f":"'Input|Step changes'!O30*IF('Input|Step changes'!$F30=\"nominal\",LOOKUP($F77,Nominal_to_Real,'Input|Rate of change'!S$23:S$26),INDEX('Input|Rate of change'!$C$14:$O$19,MATCH('Input|Step changes'!$F30,'Input|Rate of change'!$C$14:$C$19,0),MATCH('Calc|Opex forecast'!$F77,'Input|Rate of change'!$C$14:$O$14,0)))*IF('Input|Step changes'!$E30=\"$millions\",1000000,IF('Input|Step changes'!$E30=\"$000\",1000,1))/IF($E77=\"$millions\",1000000,IF($E77=\"$000\",1000,1))","v":2.0044134484216118},{"$f":"'Input|Step changes'!P30*IF('Input|Step changes'!$F30=\"nominal\",LOOKUP($F77,Nominal_to_Real,'Input|Rate of change'!T$23:T$26),INDEX('Input|Rate of change'!$C$14:$O$19,MATCH('Input|Step changes'!$F30,'Input|Rate of change'!$C$14:$C$19,0),MATCH('Calc|Opex forecast'!$F77,'Input|Rate of change'!$C$14:$O$14,0)))*IF('Input|Step changes'!$E30=\"$millions\",1000000,IF('Input|Step changes'!$E30=\"$000\",1000,1))/IF($E77=\"$millions\",1000000,IF($E77=\"$000\",1000,1))","v":2.0044134484216118},{"$f":"'Input|Step changes'!Q30*IF('Input|Step changes'!$F30=\"nominal\",LOOKUP($F77,Nominal_to_Real,'Input|Rate of change'!U$23:U$26),INDEX('Input|Rate of change'!$C$14:$O$19,MATCH('Input|Step changes'!$F30,'Input|Rate of change'!$C$14:$C$19,0),MATCH('Calc|Opex forecast'!$F77,'Input|Rate of change'!$C$14:$O$14,0)))*IF('Input|Step changes'!$E30=\"$millions\",1000000,IF('Input|Step changes'!$E30=\"$000\",1000,1))/IF($E77=\"$millions\",1000000,IF($E77=\"$000\",1000,1))","v":2.0044134484216118},{"$f":"'Input|Step changes'!R30*IF('Input|Step changes'!$F30=\"nominal\",LOOKUP($F77,Nominal_to_Real,'Input|Rate of change'!V$23:V$26),INDEX('Input|Rate of change'!$C$14:$O$19,MATCH('Input|Step changes'!$F30,'Input|Rate of change'!$C$14:$C$19,0),MATCH('Calc|Opex forecast'!$F77,'Input|Rate of change'!$C$14:$O$14,0)))*IF('Input|Step changes'!$E30=\"$millions\",1000000,IF('Input|Step changes'!$E30=\"$000\",1000,1))/IF($E77=\"$millions\",1000000,IF($E77=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!S30*IF('Input|Step changes'!$F30=\"nominal\",LOOKUP($F77,Nominal_to_Real,'Input|Rate of change'!W$23:W$26),INDEX('Input|Rate of change'!$C$14:$O$19,MATCH('Input|Step changes'!$F30,'Input|Rate of change'!$C$14:$C$19,0),MATCH('Calc|Opex forecast'!$F77,'Input|Rate of change'!$C$14:$O$14,0)))*IF('Input|Step changes'!$E30=\"$millions\",1000000,IF('Input|Step changes'!$E30=\"$000\",1000,1))/IF($E77=\"$millions\",1000000,IF($E77=\"$000\",1000,1))","v":0}]
[null,null,{"$f":"'Input|Step changes'!C31","v":0},"Calculated","$millions","2016-17",null,null,null,{"$f":"'Input|Step changes'!J31*IF('Input|Step changes'!$F31=\"nominal\",LOOKUP($F78,Nominal_to_Real,'Input|Rate of change'!N$23:N$26),INDEX('Input|Rate of change'!$C$14:$O$19,MATCH('Input|Step changes'!$F31,'Input|Rate of change'!$C$14:$C$19,0),MATCH('Calc|Opex forecast'!$F78,'Input|Rate of change'!$C$14:$O$14,0)))*IF('Input|Step changes'!$E31=\"$millions\",1000000,IF('Input|Step changes'!$E31=\"$000\",1000,1))/IF($E78=\"$millions\",1000000,IF($E78=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!K31*IF('Input|Step changes'!$F31=\"nominal\",LOOKUP($F78,Nominal_to_Real,'Input|Rate of change'!O$23:O$26),INDEX('Input|Rate of change'!$C$14:$O$19,MATCH('Input|Step changes'!$F31,'Input|Rate of change'!$C$14:$C$19,0),MATCH('Calc|Opex forecast'!$F78,'Input|Rate of change'!$C$14:$O$14,0)))*IF('Input|Step changes'!$E31=\"$millions\",1000000,IF('Input|Step changes'!$E31=\"$000\",1000,1))/IF($E78=\"$millions\",1000000,IF($E78=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!L31*IF('Input|Step changes'!$F31=\"nominal\",LOOKUP($F78,Nominal_to_Real,'Input|Rate of change'!P$23:P$26),INDEX('Input|Rate of change'!$C$14:$O$19,MATCH('Input|Step changes'!$F31,'Input|Rate of change'!$C$14:$C$19,0),MATCH('Calc|Opex forecast'!$F78,'Input|Rate of change'!$C$14:$O$14,0)))*IF('Input|Step changes'!$E31=\"$millions\",1000000,IF('Input|Step changes'!$E31=\"$000\",1000,1))/IF($E78=\"$millions\",1000000,IF($E78=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!M31*IF('Input|Step changes'!$F31=\"nominal\",LOOKUP($F78,Nominal_to_Real,'Input|Rate of change'!Q$23:Q$26),INDEX('Input|Rate of change'!$C$14:$O$19,MATCH('Input|Step changes'!$F31,'Input|Rate of change'!$C$14:$C$19,0),MATCH('Calc|Opex forecast'!$F78,'Input|Rate of change'!$C$14:$O$14,0)))*IF('Input|Step changes'!$E31=\"$millions\",1000000,IF('Input|Step changes'!$E31=\"$000\",1000,1))/IF($E78=\"$millions\",1000000,IF($E78=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!N31*IF('Input|Step changes'!$F31=\"nominal\",LOOKUP($F78,Nominal_to_Real,'Input|Rate of change'!R$23:R$26),INDEX('Input|Rate of change'!$C$14:$O$19,MATCH('Input|Step changes'!$F31,'Input|Rate of change'!$C$14:$C$19,0),MATCH('Calc|Opex forecast'!$F78,'Input|Rate of change'!$C$14:$O$14,0)))*IF('Input|Step changes'!$E31=\"$millions\",1000000,IF('Input|Step changes'!$E31=\"$000\",1000,1))/IF($E78=\"$millions\",1000000,IF($E78=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!O31*IF('Input|Step changes'!$F31=\"nominal\",LOOKUP($F78,Nominal_to_Real,'Input|Rate of change'!S$23:S$26),INDEX('Input|Rate of change'!$C$14:$O$19,MATCH('Input|Step changes'!$F31,'Input|Rate of change'!$C$14:$C$19,0),MATCH('Calc|Opex forecast'!$F78,'Input|Rate of change'!$C$14:$O$14,0)))*IF('Input|Step changes'!$E31=\"$millions\",1000000,IF('Input|Step changes'!$E31=\"$000\",1000,1))/IF($E78=\"$millions\",1000000,IF($E78=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!P31*IF('Input|Step changes'!$F31=\"nominal\",LOOKUP($F78,Nominal_to_Real,'Input|Rate of change'!T$23:T$26),INDEX('Input|Rate of change'!$C$14:$O$19,MATCH('Input|Step changes'!$F31,'Input|Rate of change'!$C$14:$C$19,0),MATCH('Calc|Opex forecast'!$F78,'Input|Rate of change'!$C$14:$O$14,0)))*IF('Input|Step changes'!$E31=\"$millions\",1000000,IF('Input|Step changes'!$E31=\"$000\",1000,1))/IF($E78=\"$millions\",1000000,IF($E78=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!Q31*IF('Input|Step changes'!$F31=\"nominal\",LOOKUP($F78,Nominal_to_Real,'Input|Rate of change'!U$23:U$26),INDEX('Input|Rate of change'!$C$14:$O$19,MATCH('Input|Step changes'!$F31,'Input|Rate of change'!$C$14:$C$19,0),MATCH('Calc|Opex forecast'!$F78,'Input|Rate of change'!$C$14:$O$14,0)))*IF('Input|Step changes'!$E31=\"$millions\",1000000,IF('Input|Step changes'!$E31=\"$000\",1000,1))/IF($E78=\"$millions\",1000000,IF($E78=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!R31*IF('Input|Step changes'!$F31=\"nominal\",LOOKUP($F78,Nominal_to_Real,'Input|Rate of change'!V$23:V$26),INDEX('Input|Rate of change'!$C$14:$O$19,MATCH('Input|Step changes'!$F31,'Input|Rate of change'!$C$14:$C$19,0),MATCH('Calc|Opex forecast'!$F78,'Input|Rate of change'!$C$14:$O$14,0)))*IF('Input|Step changes'!$E31=\"$millions\",1000000,IF('Input|Step changes'!$E31=\"$000\",1000,1))/IF($E78=\"$millions\",1000000,IF($E78=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!S31*IF('Input|Step changes'!$F31=\"nominal\",LOOKUP($F78,Nominal_to_Real,'Input|Rate of change'!W$23:W$26),INDEX('Input|Rate of change'!$C$14:$O$19,MATCH('Input|Step changes'!$F31,'Input|Rate of change'!$C$14:$C$19,0),MATCH('Calc|Opex forecast'!$F78,'Input|Rate of change'!$C$14:$O$14,0)))*IF('Input|Step changes'!$E31=\"$millions\",1000000,IF('Input|Step changes'!$E31=\"$000\",1000,1))/IF($E78=\"$millions\",1000000,IF($E78=\"$000\",1000,1))","v":0}]
[]
[null,null,"Total category specific forecasts","Calculated",{"$f":"$E$8","v":"$millions"},{"$f":"$F$8","v":"2016-17"},null,null,null,{"$f":"SUM(J76:J78)","v":0},0,0,116.31866850423046,116.31866850423046,116.31866850423046,116.31866850423046,116.31866850423046,0,0]
[]
[null,"Calc | Total forecast operating expenditure"]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(RIGHT(J$4,2)>=RIGHT('Input|General'!$G$9,2),IF(RIGHT(J$4,2)<=RIGHT('Input|General'!$G$12,2),J$4,\"\"),\"\")","v":"2014-15"},{"$f":"IF(RIGHT(K$4,2)>=RIGHT('Input|General'!$G$9,2),IF(RIGHT(K$4,2)<=RIGHT('Input|General'!$G$12,2),K$4,\"\"),\"\")","v":"2015-16"},{"$f":"IF(RIGHT(L$4,2)>=RIGHT('Input|General'!$G$9,2),IF(RIGHT(L$4,2)<=RIGHT('Input|General'!$G$12,2),L$4,\"\"),\"\")","v":"2016-17"},{"$f":"IF(RIGHT(M$4,2)>=RIGHT('Input|General'!$G$9,2),IF(RIGHT(M$4,2)<=RIGHT('Input|General'!$G$12,2),M$4,\"\"),\"\")","v":"2017-18"},{"$f":"IF(RIGHT(N$4,2)>=RIGHT('Input|General'!$G$9,2),IF(RIGHT(N$4,2)<=RIGHT('Input|General'!$G$12,2),N$4,\"\"),\"\")","v":"2018-19"},{"$f":"IF(RIGHT(O$4,2)>=RIGHT('Input|General'!$G$9,2),IF(RIGHT(O$4,2)<=RIGHT('Input|General'!$G$12,2),O$4,\"\"),\"\")","v":"2019-20"},{"$f":"IF(RIGHT(P$4,2)>=RIGHT('Input|General'!$G$9,2),IF(RIGHT(P$4,2)<=RIGHT('Input|General'!$G$12,2),P$4,\"\"),\"\")","v":"2020-21"},{"$f":"IF(RIGHT(Q$4,2)>=RIGHT('Input|General'!$G$9,2),IF(RIGHT(Q$4,2)<=RIGHT('Input|General'!$G$12,2),Q$4,\"\"),\"\")","v":"2021-22"},{"$f":"IF(RIGHT(R$4,2)>=RIGHT('Input|General'!$G$9,2),IF(RIGHT(R$4,2)<=RIGHT('Input|General'!$G$12,2),R$4,\"\"),\"\")","v":""},{"$f":"IF(RIGHT(S$4,2)>=RIGHT('Input|General'!$G$9,2),IF(RIGHT(S$4,2)<=RIGHT('Input|General'!$G$12,2),S$4,\"\"),\"\")","v":""}]
[]
[null,null,"Total forecast opex, excluding debt raising costs","Calculated",{"$f":"$E$8","v":"$millions"},{"$f":"$F$8","v":"2016-17"},null,null,null,{"$f":"J13","v":84.778187251490181},0,{"$f":"L19","v":87.755122811540076},{"$f":"IF(RIGHT(M$4,2)>=RIGHT('Input|General'!$G$11,2),IF(RIGHT(M$4,2)<=RIGHT('Input|General'!$G$12,2),IF(ISBLANK(M84),\"\",PRODUCT(1+$J51:M51)*SUM($J38:$Q38)+M70+M80),\"\"),\"\")","v":204.15618428860503},{"$f":"IF(RIGHT(N$4,2)>=RIGHT('Input|General'!$G$11,2),IF(RIGHT(N$4,2)<=RIGHT('Input|General'!$G$12,2),IF(ISBLANK(N84),\"\",PRODUCT(1+$J51:N51)*SUM($J38:$Q38)+N70+N80),\"\"),\"\")","v":204.43058109067502},{"$f":"IF(RIGHT(O$4,2)>=RIGHT('Input|General'!$G$11,2),IF(RIGHT(O$4,2)<=RIGHT('Input|General'!$G$12,2),IF(ISBLANK(O84),\"\",PRODUCT(1+$J51:O51)*SUM($J38:$Q38)+O70+O80),\"\"),\"\")","v":204.78475590199662},{"$f":"IF(RIGHT(P$4,2)>=RIGHT('Input|General'!$G$11,2),IF(RIGHT(P$4,2)<=RIGHT('Input|General'!$G$12,2),IF(ISBLANK(P84),\"\",PRODUCT(1+$J51:P51)*SUM($J38:$Q38)+P70+P80),\"\"),\"\")","v":205.16656957115981},{"$f":"IF(RIGHT(Q$4,2)>=RIGHT('Input|General'!$G$11,2),IF(RIGHT(Q$4,2)<=RIGHT('Input|General'!$G$12,2),IF(ISBLANK(Q84),\"\",PRODUCT(1+$J51:Q51)*SUM($J38:$Q38)+Q70+Q80),\"\"),\"\")","v":205.55242089836776}]
[null,null,"Total forecast opex, including debt raising costs","Calculated",{"$f":"$E$8","v":"$millions"},{"$f":"$F$8","v":"2016-17"},null,null,null,null,null,null,{"$f":"M86+'Input|Step changes'!M37","v":205.76820599212795},{"$f":"N86+'Input|Step changes'!N37","v":206.03415645161411},{"$f":"O86+'Input|Step changes'!O37","v":206.36332165123969},{"$f":"P86+'Input|Step changes'!P37","v":206.71058302413414},{"$f":"Q86+'Input|Step changes'!Q37","v":207.05894755516221}]
[]
[null,"End"]

{"sheet":"Output|Models","index":7,"n_rows":15,"n_cols":22,"rows_kept":15,"cut":false,"hidden":false,"merged":[[2,9,2,11],[2,13,2,18]]}
[null,{"$f":"Index!$B$1","v":"AER opex model"},null,null,null,null,null,null,null,"Back to Index",null,"Key:","Input","External Link","Internal Link",null,null,"Worksheet check:",{"$f":"IF(COUNTA($W$14:$W$471)=COUNTIF($W$14:$W$471,\"OK\"),\"OK\",\"Check\")","v":"OK"},null,"Overall Check:",{"$f":"'Check|List'!$S$1","v":"Ok"}]
[null,{"$f":"Index!$C$13","v":"Output | Models"}]
[]
[null,null,null,"Source","Unit","Basis",null,null,null,{"$f":"'Input|General'!$G$8","v":"2014-15"},{"$f":"IF(OFFSET('Lookup|Tables'!$G$28:$G$43,MATCH('Input|General'!$G$8,'Lookup|Tables'!$G$28:$G$42,0)+1,0,1,1)<='Input|General'!$G$12,OFFSET('Lookup|Tables'!$G$28:$G$43,MATCH('Input|General'!$G$8,'Lookup|Tables'!$G$28:$G$42,0),0,1,1),\"\")","v":"2015-16"},{"$f":"IF(OFFSET('Lookup|Tables'!$G$28:$G$43,MATCH('Input|General'!$G$8,'Lookup|Tables'!$G$28:$G$42,0)+1,0,1,1)<='Input|General'!$G$12,OFFSET('Lookup|Tables'!$G$28:$G$43,MATCH('Input|General'!$G$8,'Lookup|Tables'!$G$28:$G$42,0)+1,0,1,1),\"\")","v":"2016-17"},{"$f":"IF(OFFSET('Lookup|Tables'!$G$28:$G$43,MATCH('Input|General'!$G$8,'Lookup|Tables'!$G$28:$G$42,0)+2,0,1,1)<='Input|General'!$G$12,OFFSET('Lookup|Tables'!$G$28:$G$43,MATCH('Input|General'!$G$8,'Lookup|Tables'!$G$28:$G$42,0)+2,0,1,1),\"\")","v":"2017-18"},{"$f":"IF(OFFSET('Lookup|Tables'!$G$28:$G$43,MATCH('Input|General'!$G$8,'Lookup|Tables'!$G$28:$G$42,0)+3,0,1,1)<='Input|General'!$G$12,OFFSET('Lookup|Tables'!$G$28:$G$43,MATCH('Input|General'!$G$8,'Lookup|Tables'!$G$28:$G$42,0)+3,0,1,1),\"\")","v":"2018-19"},{"$f":"IF(OFFSET('Lookup|Tables'!$G$28:$G$43,MATCH('Input|General'!$G$8,'Lookup|Tables'!$G$28:$G$42,0)+4,0,1,1)<='Input|General'!$G$12,OFFSET('Lookup|Tables'!$G$28:$G$43,MATCH('Input|General'!$G$8,'Lookup|Tables'!$G$28:$G$42,0)+4,0,1,1),\"\")","v":"2019-20"},{"$f":"IF(OFFSET('Lookup|Tables'!$G$28:$G$43,MATCH('Input|General'!$G$8,'Lookup|Tables'!$G$28:$G$42,0)+5,0,1,1)<='Input|General'!$G$12,OFFSET('Lookup|Tables'!$G$28:$G$43,MATCH('Input|General'!$G$8,'Lookup|Tables'!$G$28:$G$42,0)+5,0,1,1),\"\")","v":"2020-21"},{"$f":"IF(OFFSET('Lookup|Tables'!$G$28:$G$43,MATCH('Input|General'!$G$8,'Lookup|Tables'!$G$28:$G$42,0)+6,0,1,1)<='Input|General'!$G$12,OFFSET('Lookup|Tables'!$G$28:$G$43,MATCH('Input|General'!$G$8,'Lookup|Tables'!$G$28:$G$42,0)+6,0,1,1),\"\")","v":"2021-22"},{"$f":"IF(OFFSET('Lookup|Tables'!$G$28:$G$43,MATCH('Input|General'!$G$8,'Lookup|Tables'!$G$28:$G$42,0)+7,0,1,1)<='Input|General'!$G$12,OFFSET('Lookup|Tables'!$G$28:$G$43,MATCH('Input|General'!$G$8,'Lookup|Tables'!$G$28:$G$42,0)+7,0,1,1),\"\")","v":""},{"$f":"IF(OFFSET('Lookup|Tables'!$G$28:$G$43,MATCH('Input|General'!$G$8,'Lookup|Tables'!$G$28:$G$42,0)+8,0,1,1)<='Input|General'!$G$12,OFFSET('Lookup|Tables'!$G$28:$G$43,MATCH('Input|General'!$G$8,'Lookup|Tables'!$G$28:$G$42,0)+8,0,1,1),\"\")","v":""}]
[]
[]
[]
[null,"Inputs for Post Tax Revenue Model",null,null,"$millions","2016-17",null,null,null,"Note. The dollar base should be consistent with the post tax revenue model"]
[]
[]
[null,null,"Operating expenditure","Source","Unit","Basis",null,null,null,{"$f":"IF(RIGHT(J$4,2)>=RIGHT('Input|General'!$G$11,2),IF(RIGHT(J$4,2)<=RIGHT('Input|General'!$G$12,2),J$4,\"\"),\"\")","v":""},{"$f":"IF(RIGHT(K$4,2)>=RIGHT('Input|General'!$G$11,2),IF(RIGHT(K$4,2)<=RIGHT('Input|General'!$G$12,2),K$4,\"\"),\"\")","v":""},{"$f":"IF(RIGHT(L$4,2)>=RIGHT('Input|General'!$G$11,2),IF(RIGHT(L$4,2)<=RIGHT('Input|General'!$G$12,2),L$4,\"\"),\"\")","v":""},{"$f":"IF(RIGHT(M$4,2)>=RIGHT('Input|General'!$G$11,2),IF(RIGHT(M$4,2)<=RIGHT('Input|General'!$G$12,2),M$4,\"\"),\"\")","v":"2017-18"},{"$f":"IF(RIGHT(N$4,2)>=RIGHT('Input|General'!$G$11,2),IF(RIGHT(N$4,2)<=RIGHT('Input|General'!$G$12,2),N$4,\"\"),\"\")","v":"2018-19"},{"$f":"IF(RIGHT(O$4,2)>=RIGHT('Input|General'!$G$11,2),IF(RIGHT(O$4,2)<=RIGHT('Input|General'!$G$12,2),O$4,\"\"),\"\")","v":"2019-20"},{"$f":"IF(RIGHT(P$4,2)>=RIGHT('Input|General'!$G$11,2),IF(RIGHT(P$4,2)<=RIGHT('Input|General'!$G$12,2),P$4,\"\"),\"\")","v":"2020-21"},{"$f":"IF(RIGHT(Q$4,2)>=RIGHT('Input|General'!$G$11,2),IF(RIGHT(Q$4,2)<=RIGHT('Input|General'!$G$12,2),Q$4,\"\"),\"\")","v":"2021-22"},null,null,null,"Notes"]
[null,null,"Forecast operating expenditure (excl. DRC)","Calc | Opex forecast",{"$f":"$E$8","v":"$millions"},{"$f":"$F$8","v":"2016-17"},null,null,null,{"$f":"IF(J11=\"\",0,'Calc|Opex forecast'!J86*IF('Calc|Opex forecast'!$F$86=\"nominal\",LOOKUP($F12,Nominal_to_Real,'Input|Rate of change'!P$23:P$26),INDEX('Input|Rate of change'!$C$14:$O$19,MATCH('Calc|Opex forecast'!$F$86,'Input|Rate of change'!$C$14:$C$19,0),MATCH('Output|Models'!$F12,'Input|Rate of change'!$C$14:$O$14,0)))*IF('Calc|Opex forecast'!$E$86=\"$millions\",1000000,IF('Output|Models'!B47=\"$000\",1000,1))/IF($E12=\"$millions\",1000000,IF($E12=\"$000\",1000,1)))","v":0},{"$f":"IF(K11=\"\",0,'Calc|Opex forecast'!K86*IF('Calc|Opex forecast'!$F$86=\"nominal\",LOOKUP($F12,Nominal_to_Real,'Input|Rate of change'!Q$23:Q$26),INDEX('Input|Rate of change'!$C$14:$O$19,MATCH('Calc|Opex forecast'!$F$86,'Input|Rate of change'!$C$14:$C$19,0),MATCH('Output|Models'!$F12,'Input|Rate of change'!$C$14:$O$14,0)))*IF('Calc|Opex forecast'!$E$86=\"$millions\",1000000,IF('Output|Models'!C47=\"$000\",1000,1))/IF($E12=\"$millions\",1000000,IF($E12=\"$000\",1000,1)))","v":0},{"$f":"IF(L11=\"\",0,'Calc|Opex forecast'!L86*IF('Calc|Opex forecast'!$F$86=\"nominal\",LOOKUP($F12,Nominal_to_Real,'Input|Rate of change'!R$23:R$26),INDEX('Input|Rate of change'!$C$14:$O$19,MATCH('Calc|Opex forecast'!$F$86,'Input|Rate of change'!$C$14:$C$19,0),MATCH('Output|Models'!$F12,'Input|Rate of change'!$C$14:$O$14,0)))*IF('Calc|Opex forecast'!$E$86=\"$millions\",1000000,IF('Output|Models'!D47=\"$000\",1000,1))/IF($E12=\"$millions\",1000000,IF($E12=\"$000\",1000,1)))","v":0},{"$f":"IF(M11=\"\",0,'Calc|Opex forecast'!M86*IF('Calc|Opex forecast'!$F$86=\"nominal\",LOOKUP($F12,Nominal_to_Real,'Input|Rate of change'!S$23:S$26),INDEX('Input|Rate of change'!$C$14:$O$19,MATCH('Calc|Opex forecast'!$F$86,'Input|Rate of change'!$C$14:$C$19,0),MATCH('Output|Models'!$F12,'Input|Rate of change'!$C$14:$O$14,0)))*IF('Calc|Opex forecast'!$E$86=\"$millions\",1000000,IF('Output|Models'!E47=\"$000\",1000,1))/IF($E12=\"$millions\",1000000,IF($E12=\"$000\",1000,1)))","v":204.15618428860503},{"$f":"IF(N11=\"\",0,'Calc|Opex forecast'!N86*IF('Calc|Opex forecast'!$F$86=\"nominal\",LOOKUP($F12,Nominal_to_Real,'Input|Rate of change'!T$23:T$26),INDEX('Input|Rate of change'!$C$14:$O$19,MATCH('Calc|Opex forecast'!$F$86,'Input|Rate of change'!$C$14:$C$19,0),MATCH('Output|Models'!$F12,'Input|Rate of change'!$C$14:$O$14,0)))*IF('Calc|Opex forecast'!$E$86=\"$millions\",1000000,IF('Output|Models'!F47=\"$000\",1000,1))/IF($E12=\"$millions\",1000000,IF($E12=\"$000\",1000,1)))","v":204.43058109067502},{"$f":"IF(O11=\"\",0,'Calc|Opex forecast'!O86*IF('Calc|Opex forecast'!$F$86=\"nominal\",LOOKUP($F12,Nominal_to_Real,'Input|Rate of change'!U$23:U$26),INDEX('Input|Rate of change'!$C$14:$O$19,MATCH('Calc|Opex forecast'!$F$86,'Input|Rate of change'!$C$14:$C$19,0),MATCH('Output|Models'!$F12,'Input|Rate of change'!$C$14:$O$14,0)))*IF('Calc|Opex forecast'!$E$86=\"$millions\",1000000,IF('Output|Models'!G47=\"$000\",1000,1))/IF($E12=\"$millions\",1000000,IF($E12=\"$000\",1000,1)))","v":204.78475590199662},{"$f":"IF(P11=\"\",0,'Calc|Opex forecast'!P86*IF('Calc|Opex forecast'!$F$86=\"nominal\",LOOKUP($F12,Nominal_to_Real,'Input|Rate of change'!V$23:V$26),INDEX('Input|Rate of change'!$C$14:$O$19,MATCH('Calc|Opex forecast'!$F$86,'Input|Rate of change'!$C$14:$C$19,0),MATCH('Output|Models'!$F12,'Input|Rate of change'!$C$14:$O$14,0)))*IF('Calc|Opex forecast'!$E$86=\"$millions\",1000000,IF('Output|Models'!H47=\"$000\",1000,1))/IF($E12=\"$millions\",1000000,IF($E12=\"$000\",1000,1)))","v":205.16656957115981},{"$f":"IF(Q11=\"\",0,'Calc|Opex forecast'!Q86*IF('Calc|Opex forecast'!$F$86=\"nominal\",LOOKUP($F12,Nominal_to_Real,'Input|Rate of change'!W$23:W$26),INDEX('Input|Rate of change'!$C$14:$O$19,MATCH('Calc|Opex forecast'!$F$86,'Input|Rate of change'!$C$14:$C$19,0),MATCH('Output|Models'!$F12,'Input|Rate of change'!$C$14:$O$14,0)))*IF('Calc|Opex forecast'!$E$86=\"$millions\",1000000,IF('Output|Models'!I47=\"$000\",1000,1))/IF($E12=\"$millions\",1000000,IF($E12=\"$000\",1000,1)))","v":205.55242089836776}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(M12:Q12)","v":1024.0905117508044}]
[]
[null,"End"]

{"sheet":"Lookup|Tables","index":8,"n_rows":44,"n_cols":22,"rows_kept":44,"cut":false,"hidden":false,"merged":[]}
[null,{"$f":"Index!$B$1","v":"AER opex model"},null,null,null,null,null,null,null,"Back to Index",null,"Key:","Input","External Link","Internal Link",null,null,null,null,null,"Overall Check:",{"$f":"'Check|List'!$S$1","v":"Ok"}]
[null,{"$f":"Index!$C$14","v":"Lookup | Tables"}]
[]
[]
[]
[]
[null,"Unit Denominations"]
[]
[null,null,{"$f":"B7","v":"Unit Denominations"},"Source",null,null,"Ref"]
[null,null,"Dollars","AER",null,null,"$dollars"]
[null,null,"Thousands","AER",null,null,"$000"]
[null,null,"Millions","AER",null,null,"$millions"]
[]
[null,null,"Percent","AER",null,null,"Per cent"]
[null,null,"Unit","AER",null,null,"unit"]
[null,null,"Number","AER",null,null,"number"]
[null,null,"Factor","AER",null,null,"factor"]
[]
[null,null,"Actual","AER",null,null,"Actual"]
[null,null,"Estimate","AER",null,null,"Estimate"]
[]
[null,"Years"]
[]
[null,null,{"$f":"B22","v":"Years"},"Source",null,null,"Ref"]
[null,null,"nominal","AER",null,null,"nominal"]
[null,null,"2007-08","AER",null,null,"2007-08"]
[null,null,"2008-09","AER",null,null,"2008-09"]
[null,null,"2009-10","AER",null,null,"2009-10"]
[null,null,"2010-11","AER",null,null,"2010-11"]
[null,null,"2011-12","AER",null,null,"2011-12"]
[null,null,"2012-13","AER",null,null,"2012-13"]
[null,null,"2013-14","AER",null,null,"2013-14"]
[null,null,"2014-15","AER",null,null,"2014-15"]
[null,null,"2015-16","AER",null,null,"2015-16"]
[null,null,"2016-17","AER",null,null,"2016-17"]
[null,null,"2017-18","AER",null,null,"2017-18"]
[null,null,"2018-19","AER",null,null,"2018-19"]
[null,null,"2019-20","AER",null,null,"2019-20"]
[null,null,"2020-21","AER",null,null,"2020-21"]
[null,null,"2021-22","AER",null,null,"2021-22"]
[null,null,"2022-23","AER",null,null,"2022-23"]
[null,null,"2023-24","AER",null,null,"2023-24"]
[]
[null,"End"]

{"sheet":"Check|List","index":9,"n_rows":17,"n_cols":19,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
[null,{"$f":"Index!$B$1","v":"AER opex model"},null,null,null,null,null,null,null,"Back to Index",null,"Key:","Input","External Link","Internal Link",null,null,"Overall Check:",{"$f":"IF(COUNTIF(G10:G15,\"Check\")=0,\"Ok\",\"Check\")","v":"Ok"}]
[null,{"$f":"Index!$C$15","v":"Check | List"}]
[]
[]
[]
[]
[null,"Check List"]
[]
[null,null,"Sheet","Source","Unit",null,"Status"]
[null,null,{"$f":"Index!C7","v":"Input | General"},{"$f":"C10","v":"Input | General"},"Ok/Check",null,{"$f":"'Input|General'!S1","v":"OK"}]
[null,null,{"$f":"Index!C9","v":"Input | Reported opex"},{"$f":"C11","v":"Input | Reported opex"},"Ok/Check",null,{"$f":"'Input|Reported opex'!S1","v":"OK"}]
[null,null,{"$f":"Index!C10","v":"Input | Rate of change"},"Input | Rate of change","Ok/Check",null,{"$f":"'Input|Rate of change'!T1","v":"Ok"}]
[null,null,{"$f":"Index!C11","v":"Input | Step changes"},"Input | Step changes","Ok/Check",null,{"$f":"'Input|Step changes'!S1","v":"OK"}]
[null,null,{"$f":"Index!C12","v":"Calc | Opex Forecast"},"Calc | Opex Forecast","Ok/Check",null,{"$f":"'Calc|Opex forecast'!S1","v":"n/a"}]
[null,null,{"$f":"Index!C13","v":"Output | Models"},"Output | Models","Ok/Check",null,{"$f":"'Output|Models'!S1","v":"OK"}]
[]
[null,"End"]