{"text_format":"1","workbook":"xlsx","n_sheets":12,"sheets":["Cover","Index","Input|General","Input|Inflation","Input|Reported opex","Input|Rate of change","Input|Step changes","Input|Dx Tx split","Calc|Opex forecast","Output|Models","Lookup|Tables","Check|List"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":10,"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":"Cover","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Index","index":1,"n_rows":18,"n_cols":4,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
[null,"AER opex model",null,"31 January 2018"]
[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,"Input | Dx TX split","Inputs the split of total opex bewteen distribution and transmission services."]
[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":2,"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$14)=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,"Ausgrid",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,"2017-18",null,null,null,null,null,null,null,null,null,null,null,"Ok"]
[null,null,"Prior regulatory control period, last year","NSP",null,null,"2018-19",null,null,null,null,null,null,null,null,null,null,null,"Ok"]
[null,null,"Forecast regulatory control period, first year","NSP",null,null,"2019-20",null,null,null,null,null,null,null,null,null,null,null,"Ok"]
[null,null,"Forecast regulatory control period, last year","NSP",null,null,"2023-24",null,null,null,null,null,null,null,null,null,null,null,"Ok"]
[]
[null,"End"]

{"sheet":"Input|Inflation","index":3,"n_rows":40,"n_cols":22,"rows_kept":40,"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$40)=COUNTIF($S5:$S40,\"OK\"),\"OK\",\"Check\")","v":"OK"},null,"Overall Check:",{"$f":"'Check|List'!$S$1","v":"Ok"}]
[null,{"$f":"Index!$C$8","v":"Input | Inflation"}]
[]
[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,"2012-03-31",null,99.9,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTBLANK($E9),\"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,"Ok"]
[null,null,"2012-09-30",null,101.8,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ok"]
[null,null,"2012-12-31",null,102,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ok"]
[null,null,"2013-03-31",null,102.4,null,null,null,null,null,null,null,null,null,null,null,null,null,"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,108.6,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ok"]
[null,null,"2016-09-30",null,109.4,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ok"]
[null,null,"2016-12-31",null,110,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ok"]
[null,null,"2017-03-31",null,110.5,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ok"]
[null,null,"2017-06-30",null,110.7,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ok"]
[null,null,"2017-09-30",null,111.4,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ok"]
[null,null,"2017-12-31",null,112.1,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ok"]
[null,null,"2018-03-31",null,112.3250508504852,"BIS forecasts (see attachment RIN 1.9)",null,null,null,null,null,null,null,null,null,null,null,null,"Ok"]
[null,null,"2018-06-30",null,112.87201847381549,"BIS forecasts",null,null,null,null,null,null,null,null,null,null,null,null,"Ok"]
[null,null,"2018-09-30",null,113.49940688432672,"BIS forecasts",null,null,null,null,null,null,null,null,null,null,null,null,"Ok"]
[null,null,"2018-12-31",null,114.13028257381963,"BIS forecasts",null,null,null,null,null,null,null,null,null,null,null,null,"Ok"]
[null,null,"2019-03-31",null,114.76466492600373,"BIS forecasts",null,null,null,null,null,null,null,null,null,null,null,null,"Ok"]
[null,null,"2019-06-30",null,115.40257343233104,"BIS forecasts",null,null,null,null,null,null,null,null,null,null,null,null,"Ok"]
[]
[null,"End"]

{"sheet":"Input|Reported opex","index":4,"n_rows":60,"n_cols":22,"rows_kept":60,"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$60)=COUNTIF($W$32:$W$60,\"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$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":"2022-23"},{"$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":"2023-24"}]
[]
[]
[]
[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":"2017-18"},{"$f":"IF(RIGHT(N$4,2)<=RIGHT('Input|General'!$G$10,2),'Input|Reported opex'!N$4,\"\")","v":"2018-19"},{"$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,398.15890650121423,404.01482532588466,411.77696246714368,405.05796771236407,411.22645861797463,null,null,null,null,null,"AER Final Determination"]
[null,null,"Remove debt raising costs","AER",{"$f":"$E$24","v":"$millions"},{"$f":"$F$24","v":"2013-14"},null,null,null,-7.3287802632504215,-7.3913367751814105,-7.4658081184432108,-7.5327334344293888,-7.5846861055811017]
[null,null,"AER's approved cost pass through for Ausgrid's April 2015 storms","AER","$millions","2013-14",null,null,null,33.11,0.51]
[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,null,"AER","$millions","2013-14"]
[]
[null,null,"Total opex","Calculated","$millions","2013-14",null,null,null,{"$f":"SUM(J13:J22)","v":423.94012623796385},397.13348855070325,404.31115434870048,397.52523427793471,403.64177251239352,0,0,0,0,0]
[]
[null,"Input | Reported opex"]
[]
[null,null,null,null,null,null,null,null,null,"Actual","Actual","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":"2017-18"},{"$f":"IF(RIGHT(N4,2)<=RIGHT('Input|General'!$G$10,2),'Input|Reported opex'!N4,\"\")","v":"2018-19"},{"$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$43","v":"$millions"},{"$f":"$F$43","v":"nominal"},null,null,null,650.79086419491261,589.87944009914906,531.13722872250185,426.3881331369995]
[null,null,null,"RIN",{"$f":"$E$43","v":"$millions"},{"$f":"$F$43","v":"nominal"}]
[null,null,null,"RIN","$millions","nominal"]
[null,null,null,"RIN","$millions","nominal"]
[null,null,null,"RIN","$millions","nominal"]
[null,null,null,"RIN","$millions","nominal"]
[null,null,null,"RIN","$millions","nominal"]
[null,null,null,"RIN","$millions","nominal"]
[null,null,null,"RIN","$millions","nominal"]
[null,null,null,"RIN","$millions","nominal"]
[]
[null,null,"Total opex","Calculated","$millions","nominal",null,null,null,{"$f":"SUM(J32:J41)","v":650.79086419491261},{"$f":"SUM(K32:K41)","v":589.87944009914906},531.13722872250185,426.3881331369995,0,0,0,0,0,0]
[]
[null,"Input | CAM adjustment"]
[]
[null,null,"Cost allocation method adjustment","Source","Unit","Basis",null,null,null,{"$f":"IF(RIGHT(J$4,2)=RIGHT('Input|General'!$G$9,2),J$4,\"\")","v":""},{"$f":"IF(RIGHT(K$4,2)=RIGHT('Input|General'!$G$9,2),K$4,\"\")","v":""},{"$f":"IF(RIGHT(L$4,2)=RIGHT('Input|General'!$G$9,2),L$4,\"\")","v":""},{"$f":"IF(RIGHT(M$4,2)=RIGHT('Input|General'!$G$9,2),M$4,\"\")","v":"2017-18"},{"$f":"IF(RIGHT(N$4,2)=RIGHT('Input|General'!$G$9,2),N$4,\"\")","v":""}]
[null,null,{"$f":"C47","v":"Cost allocation method adjustment"},"External",{"$f":"$E$43","v":"$millions"},{"$f":"$F$43","v":"nominal"}]
[]
[null,"Input | Service classification adjustment"]
[]
[null,null,"Service classification adjustment","Source","Unit","Basis",null,null,null,{"$f":"IF(RIGHT(J$4,2)=RIGHT('Input|General'!$G$9,2),J$4,\"\")","v":""},{"$f":"IF(RIGHT(K$4,2)=RIGHT('Input|General'!$G$9,2),K$4,\"\")","v":""},{"$f":"IF(RIGHT(L$4,2)=RIGHT('Input|General'!$G$9,2),L$4,\"\")","v":""},{"$f":"IF(RIGHT(M$4,2)=RIGHT('Input|General'!$G$9,2),M$4,\"\")","v":"2017-18"},{"$f":"IF(RIGHT(N$4,2)=RIGHT('Input|General'!$G$9,2),N$4,\"\")","v":""}]
[null,null,{"$f":"C52","v":"Service classification adjustment"},"External",{"$f":"$E$43","v":"$millions"},{"$f":"$F$43","v":"nominal"},null,null,null,null,null,null,5.1948104900000009]
[]
[null,"Input | Efficiency adjustment"]
[]
[null,null,"Efficiency adjustment","Source","Unit",null,null,null,null,{"$f":"IF(RIGHT(J$4,2)=RIGHT('Input|General'!$G$9,2),J$4,\"\")","v":""},{"$f":"IF(RIGHT(K$4,2)=RIGHT('Input|General'!$G$9,2),K$4,\"\")","v":""},{"$f":"IF(RIGHT(L$4,2)=RIGHT('Input|General'!$G$9,2),L$4,\"\")","v":""},{"$f":"IF(RIGHT(M$4,2)=RIGHT('Input|General'!$G$9,2),M$4,\"\")","v":"2017-18"},{"$f":"IF(RIGHT(N$4,2)=RIGHT('Input|General'!$G$9,2),N$4,\"\")","v":""}]
[null,null,"Efficiency adjustment","External","Per cent",null,null,null,null,null,null,null,0]
[]
[null,"End"]

{"sheet":"Input|Rate of change","index":5,"n_rows":97,"n_cols":23,"rows_kept":97,"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:W96,\"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":"2022-23"},{"$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":"2023-24"}]
[]
[]
[]
[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","2022-23","2023-24"]
[]
[null,null,"Inflation","calculated",{"$f":"percent","v":"Per cent"},null,null,null,null,{"$f":"'Input|Inflation'!E18/'Input|Inflation'!E14-1","v":3.0155642023346418E-2},{"$f":"'Input|Inflation'!E22/'Input|Inflation'!E18-1","v":1.5108593012275628E-2},{"$f":"'Input|Inflation'!E26/'Input|Inflation'!E22-1","v":1.0232558139534831E-2},{"$f":"'Input|Inflation'!E30/'Input|Inflation'!E26-1","v":1.9337016574585641E-2},{"$f":"'Input|Inflation'!E34/'Input|Inflation'!E30-1","v":1.9620763087764059E-2},{"$f":"'Input|Inflation'!E38/'Input|Inflation'!E34-1","v":2.2419683750960928E-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"},{"$f":"N4","v":"2017-18"},{"$f":"O4","v":"2018-19"}]
[]
[null,null,{"$f":"'Lookup|Tables'!C26","v":"2012-13"},"calculated","index",null,null,null,null,{"$f":"(1+J$12)","v":1.0301556420233464},{"$f":"J16*(1+K$12)","v":1.0457198443579767},1.056420233463035,1.0768482490272373,1.0979768334028743,{"$f":"N16*(1+O$12)","v":1.1225931267736482},null,null,null,null,null,"Note: works row to column"]
[null,null,{"$f":"'Lookup|Tables'!C27","v":"2013-14"},"calculated","index",null,null,null,null,1,{"$f":"J17*(1+K$12)","v":1.0151085930122756},1.0254957507082152,1.0453257790368271,1.0658358684968412,{"$f":"N17*(1+O$12)","v":1.089731571598971},null,null,null,null,null,"Use the years in column C as the FY from which to convert"]
[null,null,{"$f":"'Lookup|Tables'!C28","v":"2014-15"},"calculated","index",null,null,null,null,{"$f":"K18/(1+K$12)","v":0.98511627906976751},1,{"$f":"K18*(1+L$12)","v":1.0102325581395348},{"$f":"L18*(1+M$12)","v":1.029767441860465},1.0499722648727021,1.0735123109984284,null,null,null,null,null,"e.g: To convert from FY2017-18 real to FY2018-19 real, use cell O21"]
[null,null,{"$f":"'Lookup|Tables'!C29","v":"2015-16"},"calculated","index",null,null,null,null,{"$f":"K19/(1+K$12)","v":0.97513812154696156},{"$f":"L19/(1+L$12)","v":0.98987108655616951},1,{"$f":"L19*(1+M$12)","v":1.0193370165745856},1.0393371866833838,1.0626387977194387]
[null,null,{"$f":"'Lookup|Tables'!C30","v":"2016-17"},"calculated","index",null,null,null,null,{"$f":"K20/(1+K$12)","v":0.95663956639566416},0.97109304426377607,0.98102981029810299,1,{"$f":"M20*(1+N$12)","v":1.0196207630877641},1.0424803381421053]
[null,null,{"$f":"'Lookup|Tables'!C31","v":"2017-18"},"calculated","index",null,null,null,null,0.93823076287562923,0.95240610962351402,0.96215166051268486,0.9807568031192837,1,{"$f":"N21*(1+O$12)","v":1.0224196837509609}]
[null,null,{"$f":"'Lookup|Tables'!C32","v":"2018-19"},"calculated","index",null,null,null,null,0.91765717912778544,0.93152168797202006,0.94105353780243139,0.95925070566048942,0.97807193649802437,1]
[]
[null,null,"CPI indexes (nominal to real)",null,null,null,null,null,null,{"$f":"J10","v":"2013-14"},"2014-15","2015-16","2016-17","2017-18","2018-19"]
[]
[null,null,{"$f":"C16","v":"2012-13"},"calculated","index",null,null,null,null,{"$f":"1/J16*(1+J$12)^0.5","v":0.98525484065733759},0.96347600342683604,0.95142370963176837,0.93757148761740927,0.91965758785968899,0.90072501076573441,null,null,null,null,null,"Note: works column to row"]
[null,null,"2013-14","calculated","index",null,null,null,null,1.0149658329339695,0.99253024088426012,0.98011450243194831,0.96584455776929623,0.94739045286323997,0.92788695175186064,null,null,null,null,null,"Use the years in row 24 as the FY from which to convert"]
[null,null,"2014-15","calculated","index",null,null,null,null,1.030300538625134,1.0075259763461564,0.99492265355462162,0.98043711010575396,0.96170418963926629,0.94190601806728058,null,null,null,null,null,"e.g: To convert from FY2017-18 real to FY2018-19 nominal, use cell N32"]
[null,null,"2015-16","calculated","index",null,null,null,null,1.0408431487878098,1.0178355444762099,1.0051032574514596,0.99046948983706851,0.97154488367278424,0.95154412615913186]
[null,null,"2016-17","calculated","index",null,null,null,null,1.0609699500074634,1.0375174472699489,1.0245389557999685,1.0096222147786693,0.99033166319131882,0.96994415069812046]
[null,null,"2017-18","calculated","index",null,null,null,null,1.0817869900397969,1.0578743313022543,1.0446411919259049,1.0294317730629852,1.009762726133107,0.98897519508733089]
[null,null,"2018-19","calculated","index",null,null,null,null,1.106040312242393,1.08159153925831,1.0680617170821105,1.0525113078582482,1.0324012871165194,1.0111477061987337]
[]
[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$10,2),IF(RIGHT(K$4,2)<=RIGHT('Input|General'!$G$12,2),'Input|Reported opex'!J$4,\"\"),\"\")","v":""},{"$f":"IF(RIGHT(L$4,2)>=RIGHT('Input|General'!$G$10,2),IF(RIGHT(L$4,2)<=RIGHT('Input|General'!$G$12,2),'Input|Reported opex'!K$4,\"\"),\"\")","v":""},{"$f":"IF(RIGHT(M$4,2)>=RIGHT('Input|General'!$G$10,2),IF(RIGHT(M$4,2)<=RIGHT('Input|General'!$G$12,2),'Input|Reported opex'!L$4,\"\"),\"\")","v":""},{"$f":"IF(RIGHT(N$4,2)>=RIGHT('Input|General'!$G$10,2),IF(RIGHT(N$4,2)<=RIGHT('Input|General'!$G$12,2),'Input|Reported opex'!M$4,\"\"),\"\")","v":""},{"$f":"IF(RIGHT(O$4,2)>=RIGHT('Input|General'!$G$10,2),IF(RIGHT(O$4,2)<=RIGHT('Input|General'!$G$12,2),'Input|Reported opex'!N$4,\"\"),\"\")","v":"2018-19"},{"$f":"IF(RIGHT(P$4,2)>=RIGHT('Input|General'!$G$10,2),IF(RIGHT(P$4,2)<=RIGHT('Input|General'!$G$12,2),'Input|Reported opex'!O$4,\"\"),\"\")","v":"2019-20"},{"$f":"IF(RIGHT(Q$4,2)>=RIGHT('Input|General'!$G$10,2),IF(RIGHT(Q$4,2)<=RIGHT('Input|General'!$G$12,2),'Input|Reported opex'!P$4,\"\"),\"\")","v":"2020-21"},{"$f":"IF(RIGHT(R$4,2)>=RIGHT('Input|General'!$G$10,2),IF(RIGHT(R$4,2)<=RIGHT('Input|General'!$G$12,2),'Input|Reported opex'!Q$4,\"\"),\"\")","v":"2021-22"},{"$f":"IF(RIGHT(S$4,2)>=RIGHT('Input|General'!$G$10,2),IF(RIGHT(S$4,2)<=RIGHT('Input|General'!$G$12,2),'Input|Reported opex'!R$4,\"\"),\"\")","v":"2022-23"},{"$f":"IF(RIGHT(T$4,2)>=RIGHT('Input|General'!$G$10,2),IF(RIGHT(T$4,2)<=RIGHT('Input|General'!$G$12,2),'Input|Reported opex'!S$4,\"\"),\"\")","v":"2023-24"}]
[]
[null,null,"WPI - BIS Oxford Economics","external",{"$f":"percent","v":"Per cent"},null,null,null,null,null,null,null,null,null,9.4637136564390545E-3,8.7907707248520376E-3,1.3681542469145236E-2,1.7372653697064661E-2,1.7287543395615133E-2,1.3333262554146708E-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,null,0,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$10,2),IF(RIGHT(K$4,2)<=RIGHT('Input|General'!$G$12,2),'Input|Reported opex'!J$4,\"\"),\"\")","v":""},{"$f":"IF(RIGHT(L$4,2)>=RIGHT('Input|General'!$G$10,2),IF(RIGHT(L$4,2)<=RIGHT('Input|General'!$G$12,2),'Input|Reported opex'!K$4,\"\"),\"\")","v":""},{"$f":"IF(RIGHT(M$4,2)>=RIGHT('Input|General'!$G$10,2),IF(RIGHT(M$4,2)<=RIGHT('Input|General'!$G$12,2),'Input|Reported opex'!L$4,\"\"),\"\")","v":""},{"$f":"IF(RIGHT(N$4,2)>=RIGHT('Input|General'!$G$10,2),IF(RIGHT(N$4,2)<=RIGHT('Input|General'!$G$12,2),'Input|Reported opex'!M$4,\"\"),\"\")","v":""},{"$f":"IF(RIGHT(O$4,2)>=RIGHT('Input|General'!$G$10,2),IF(RIGHT(O$4,2)<=RIGHT('Input|General'!$G$12,2),'Input|Reported opex'!N$4,\"\"),\"\")","v":"2018-19"},{"$f":"IF(RIGHT(P$4,2)>=RIGHT('Input|General'!$G$10,2),IF(RIGHT(P$4,2)<=RIGHT('Input|General'!$G$12,2),'Input|Reported opex'!O$4,\"\"),\"\")","v":"2019-20"},{"$f":"IF(RIGHT(Q$4,2)>=RIGHT('Input|General'!$G$10,2),IF(RIGHT(Q$4,2)<=RIGHT('Input|General'!$G$12,2),'Input|Reported opex'!P$4,\"\"),\"\")","v":"2020-21"},{"$f":"IF(RIGHT(R$4,2)>=RIGHT('Input|General'!$G$10,2),IF(RIGHT(R$4,2)<=RIGHT('Input|General'!$G$12,2),'Input|Reported opex'!Q$4,\"\"),\"\")","v":"2021-22"},{"$f":"IF(RIGHT(S$4,2)>=RIGHT('Input|General'!$G$10,2),IF(RIGHT(S$4,2)<=RIGHT('Input|General'!$G$12,2),'Input|Reported opex'!R$4,\"\"),\"\")","v":"2022-23"},{"$f":"IF(RIGHT(T$4,2)>=RIGHT('Input|General'!$G$10,2),IF(RIGHT(T$4,2)<=RIGHT('Input|General'!$G$12,2),'Input|Reported opex'!S$4,\"\"),\"\")","v":"2023-24"}]
[]
[null,null,"WPI  - Economic Insights 31 Oct 2017 page 2","external",{"$f":"percent","v":"Per cent"},null,null,null,null,null,null,null,null,null,0.59699999999999998,0.59699999999999998,0.59699999999999998,0.59699999999999998,0.59699999999999998,0.59699999999999998]
[null,null,{"$f":"C39","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,null,{"$f":"1-O49","v":0.40300000000000002},{"$f":"1-P49","v":0.40300000000000002},0.40300000000000002,0.40300000000000002,0.40300000000000002,0.40300000000000002]
[]
[null,null,"Check","calculated","Ok/Check","n/a",null,null,null,null,null,null,null,null,{"$f":"IF(SUM(O49:O56)=1,\"Ok\",\"Check\")","v":"Ok"},{"$f":"IF(SUM(P49:P56)=1,\"Ok\",\"Check\")","v":"Ok"},{"$f":"IF(SUM(Q49:Q56)=1,\"Ok\",\"Check\")","v":"Ok"},"Ok","Ok","Ok",null,null,{"$f":"IF(COUNTIF(K58:T58,\"Check\")=0,\"Ok\",\"Check\")","v":"Ok"}]
[]
[null,"Input | Forecast output growth"]
[]
[null,null,"Output measure","Source","Unit","Basis",null,null,null,null,{"$f":"IF(RIGHT(K$4,2)>=RIGHT('Input|General'!$G$10,2),IF(RIGHT(K$4,2)<=RIGHT('Input|General'!$G$12,2),'Input|Reported opex'!J$4,\"\"),\"\")","v":""},{"$f":"IF(RIGHT(L$4,2)>=RIGHT('Input|General'!$G$10,2),IF(RIGHT(L$4,2)<=RIGHT('Input|General'!$G$12,2),'Input|Reported opex'!K$4,\"\"),\"\")","v":""},{"$f":"IF(RIGHT(M$4,2)>=RIGHT('Input|General'!$G$10,2),IF(RIGHT(M$4,2)<=RIGHT('Input|General'!$G$12,2),'Input|Reported opex'!L$4,\"\"),\"\")","v":""},{"$f":"IF(RIGHT(N$4,2)>=RIGHT('Input|General'!$G$10,2),IF(RIGHT(N$4,2)<=RIGHT('Input|General'!$G$12,2),'Input|Reported opex'!M$4,\"\"),\"\")","v":""},{"$f":"IF(RIGHT(O$4,2)>=RIGHT('Input|General'!$G$10,2),IF(RIGHT(O$4,2)<=RIGHT('Input|General'!$G$12,2),'Input|Reported opex'!N$4,\"\"),\"\")","v":"2018-19"},{"$f":"IF(RIGHT(P$4,2)>=RIGHT('Input|General'!$G$10,2),IF(RIGHT(P$4,2)<=RIGHT('Input|General'!$G$12,2),'Input|Reported opex'!O$4,\"\"),\"\")","v":"2019-20"},{"$f":"IF(RIGHT(Q$4,2)>=RIGHT('Input|General'!$G$10,2),IF(RIGHT(Q$4,2)<=RIGHT('Input|General'!$G$12,2),'Input|Reported opex'!P$4,\"\"),\"\")","v":"2020-21"},{"$f":"IF(RIGHT(R$4,2)>=RIGHT('Input|General'!$G$10,2),IF(RIGHT(R$4,2)<=RIGHT('Input|General'!$G$12,2),'Input|Reported opex'!Q$4,\"\"),\"\")","v":"2021-22"},{"$f":"IF(RIGHT(S$4,2)>=RIGHT('Input|General'!$G$10,2),IF(RIGHT(S$4,2)<=RIGHT('Input|General'!$G$12,2),'Input|Reported opex'!R$4,\"\"),\"\")","v":"2022-23"},{"$f":"IF(RIGHT(T$4,2)>=RIGHT('Input|General'!$G$10,2),IF(RIGHT(T$4,2)<=RIGHT('Input|General'!$G$12,2),'Input|Reported opex'!S$4,\"\"),\"\")","v":"2023-24"}]
[]
[null,null,"Customer numbers","external","number","n/a",null,null,null,null,null,null,null,null,1737834.0875907089,1753781.8742805296,1772216.1449881168,1790645.3352987589,1809070.2908897584,1827490.3320692314]
[null,null,"Circuit Length","external","number","n/a",null,null,null,null,null,null,null,null,41982.679287267463,42160.838899527756,42344.294975753197,42584.728051978636,42834.024128204073,43056.11620442952]
[null,null,"Ratcheted Maximum Demand","external","number","n/a",null,null,null,null,null,null,null,null,6555,6555,6555,6555,6555,6580]
[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,{"$f":"IF(RIGHT(K$4,2)>=RIGHT('Input|General'!$G$11,2),IF(RIGHT(K$4,2)<=RIGHT('Input|General'!$G$12,2),'Input|Reported opex'!J$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),'Input|Reported opex'!K$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),'Input|Reported opex'!L$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),'Input|Reported opex'!M$4,\"\"),\"\")","v":""},{"$f":"IF(RIGHT(O$4,2)>=RIGHT('Input|General'!$G$11,2),IF(RIGHT(O$4,2)<=RIGHT('Input|General'!$G$12,2),'Input|Reported opex'!N$4,\"\"),\"\")","v":""},{"$f":"IF(RIGHT(P$4,2)>=RIGHT('Input|General'!$G$11,2),IF(RIGHT(P$4,2)<=RIGHT('Input|General'!$G$12,2),'Input|Reported opex'!O$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),'Input|Reported opex'!P$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),'Input|Reported opex'!Q$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),'Input|Reported opex'!R$4,\"\"),\"\")","v":"2022-23"},{"$f":"IF(RIGHT(T$4,2)>=RIGHT('Input|General'!$G$11,2),IF(RIGHT(T$4,2)<=RIGHT('Input|General'!$G$12,2),'Input|Reported opex'!S$4,\"\"),\"\")","v":"2023-24"}]
[]
[null,null,{"$f":"C64","v":"Customer numbers"},"calculated","number","n/a",null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(P64),\"\",LN(P64)-LN(O64))","v":9.1349665966795612E-3},{"$f":"IF(ISBLANK(Q64),\"\",LN(Q64)-LN(P64))","v":1.0456295530758553E-2},{"$f":"IF(ISBLANK(R64),\"\",LN(R64)-LN(Q64))","v":1.0345254664866133E-2},1.02369844782082E-2,1.0130560506889097E-2]
[null,null,{"$f":"C65","v":"Circuit Length"},"calculated","number","n/a",null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(P65),\"\",LN(P65)-LN(O65))","v":4.2346667297774587E-3},4.341898675811251E-3,5.6619918603466601E-3,5.8370504761366959E-3,5.1715498508091429E-3]
[null,null,"Ratcheted Maximum Demand","calculated","number","n/a",null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(P66),\"\",LN(P66)-LN(O66))","v":0},0,0,0,3.8066281215627384E-3]
[null,null,0,"calculated","number","n/a",null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(P67),\"\",LN(P67)-LN(O67))","v":""},"","","",""]
[null,null,0,"calculated","number","n/a"]
[null,null,0,"calculated","number","n/a",null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(P69),\"\",LN(P69)-LN(O69))","v":""},"","","",""]
[]
[null,null,"Weights"]
[]
[null,null,{"$f":"C64","v":"Customer numbers"},"external","number","n/a",null,null,null,null,null,null,null,0.77131394182547641]
[null,null,{"$f":"C65","v":"Circuit Length"},"external","number","n/a",null,null,null,null,null,null,null,9.7291875626880645E-2]
[null,null,"Ratcheted Maximum Demand","external","number","n/a",null,null,null,null,null,null,null,0.13139418254764293]
[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,null,{"$f":"IF(SUM(N82:N87)=1,\"Ok\",\"Check\")","v":"Ok"},null,null,null,null,null,null,null,null,{"$f":"IF(COUNTIF(K89:T89,\"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),'Input|Reported opex'!J$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),'Input|Reported opex'!K$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),'Input|Reported opex'!L$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),'Input|Reported opex'!M$4,\"\"),\"\")","v":""},{"$f":"IF(RIGHT(O$4,2)>=RIGHT('Input|General'!$G$11,2),IF(RIGHT(O$4,2)<=RIGHT('Input|General'!$G$12,2),'Input|Reported opex'!N$4,\"\"),\"\")","v":""},{"$f":"IF(RIGHT(P$4,2)>=RIGHT('Input|General'!$G$11,2),IF(RIGHT(P$4,2)<=RIGHT('Input|General'!$G$12,2),'Input|Reported opex'!O$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),'Input|Reported opex'!P$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),'Input|Reported opex'!Q$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),'Input|Reported opex'!R$4,\"\"),\"\")","v":"2022-23"},{"$f":"IF(RIGHT(T$4,2)>=RIGHT('Input|General'!$G$11,2),IF(RIGHT(T$4,2)<=RIGHT('Input|General'!$G$12,2),'Input|Reported opex'!S$4,\"\"),\"\")","v":"2023-24"}]
[]
[null,null,"Partial factor productivity","external",{"$f":"percent","v":"Per cent"},"n/a",null,null,null,null,null,null,null,null,null,0,0,0,0,0]
[]
[null,"End"]

{"sheet":"Input|Step changes","index":6,"n_rows":32,"n_cols":22,"rows_kept":32,"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$32)=COUNTIF($W$8:$W$32,\"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$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,1,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":"2022-23"},{"$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":"2023-24"}]
[]
[]
[]
[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),'Input|Reported opex'!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),'Input|Reported opex'!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),'Input|Reported opex'!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),'Input|Reported opex'!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),'Input|Reported opex'!N$4,\"\"),\"\")","v":""},{"$f":"IF(RIGHT(O$4,2)>=RIGHT('Input|General'!$G$11,2),IF(RIGHT(O$4,2)<=RIGHT('Input|General'!$G$12,2),'Input|Reported opex'!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),'Input|Reported opex'!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),'Input|Reported opex'!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),'Input|Reported opex'!R$4,\"\"),\"\")","v":"2022-23"},{"$f":"IF(RIGHT(S$4,2)>=RIGHT('Input|General'!$G$11,2),IF(RIGHT(S$4,2)<=RIGHT('Input|General'!$G$12,2),'Input|Reported opex'!S$4,\"\"),\"\")","v":"2023-24"}]
[]
[null,null,"Demand Management","external","$millions","2018-19",null,null,null,null,null,null,null,null,3.6799555936416319,3.6799555936416319,6.5155021133881581,6.5572013269138418,5.6919426462558942]
[null,null,"Accelerated tariff acceptance research project","external","$millions","2018-19",null,null,null,null,null,null,null,null,1.5,1.5]
[null,null,null,"AER","$millions","2018-19"]
[null,null,null,"AER","$millions","2018-19"]
[null,null,null,"AER","$millions","2018-19"]
[null,null,null,"AER","$millions","2018-19"]
[null,null,null,"AER","$millions","2018-19"]
[null,null,null,"AER","$millions","2018-19"]
[null,null,null,"AER","$millions","2018-19"]
[null,null,null,"AER","$millions","2018-19"]
[null,null,null,"AER","$millions","2018-19"]
[null,null,null,"AER","$millions","2018-19"]
[]
[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),'Input|Reported opex'!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),'Input|Reported opex'!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),'Input|Reported opex'!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),'Input|Reported opex'!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),'Input|Reported opex'!N$4,\"\"),\"\")","v":""},{"$f":"IF(RIGHT(O$4,2)>=RIGHT('Input|General'!$G$11,2),IF(RIGHT(O$4,2)<=RIGHT('Input|General'!$G$12,2),'Input|Reported opex'!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),'Input|Reported opex'!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),'Input|Reported opex'!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),'Input|Reported opex'!R$4,\"\"),\"\")","v":"2022-23"},{"$f":"IF(RIGHT(S$4,2)>=RIGHT('Input|General'!$G$11,2),IF(RIGHT(S$4,2)<=RIGHT('Input|General'!$G$12,2),'Input|Reported opex'!S$4,\"\"),\"\")","v":"2023-24"}]
[]
[null,null,"Distribution","PTRM","$millions",{"$f":"'Input|General'!G10","v":"2018-19"},null,null,null,null,null,null,null,null,6.9404426364307472,7.04245109026016,7.0916947269635457,7.1129936972100598,7.1119156440849585]
[null,null,"Transmission","PTRM","$millions",{"$f":"'Input|General'!G10","v":"2018-19"},null,null,null,null,null,null,null,null,0.96329627306870758,0.97559560459865924,0.97708363670142206,0.9856743670119037,1.0030548262496692]
[]
[null,"End"]

{"sheet":"Input|Dx Tx split","index":7,"n_rows":17,"n_cols":22,"rows_kept":17,"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($V$8:$V$17)=COUNTIF($V$8:$V$17,\"OK\"),\"OK\",\"Check\")","v":"OK"},null,"Overall Check:",{"$f":"'Check|List'!$S$1","v":"Ok"}]
[null,{"$f":"Index!$C$12","v":"Input | Dx TX split"}]
[]
[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,1,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":"2022-23"},{"$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":"2023-24"}]
[]
[]
[]
[null,"Input | Dx/Tx split"]
[]
[null,null,"Dx/Tx split","Source","Unit",null,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),'Input|Reported opex'!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),'Input|Reported opex'!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),'Input|Reported opex'!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),'Input|Reported opex'!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),'Input|Reported opex'!N$4,\"\"),\"\")","v":""},{"$f":"IF(RIGHT(O$4,2)>=RIGHT('Input|General'!$G$11,2),IF(RIGHT(O$4,2)<=RIGHT('Input|General'!$G$12,2),'Input|Reported opex'!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),'Input|Reported opex'!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),'Input|Reported opex'!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),'Input|Reported opex'!R$4,\"\"),\"\")","v":"2022-23"},{"$f":"IF(RIGHT(S$4,2)>=RIGHT('Input|General'!$G$11,2),IF(RIGHT(S$4,2)<=RIGHT('Input|General'!$G$12,2),'Input|Reported opex'!S$4,\"\"),\"\")","v":"2023-24"}]
[]
[null,null,"Distribution","External",{"$f":"percent","v":"Per cent"},null,null,null,null,null,null,null,null,null,0.92302757544235181,0.92302757544235181,0.92302757544235181,0.92302757544235181,0.92302757544235181]
[null,null,"Transmission","External","Per cent",null,null,null,null,null,null,null,null,null,7.6972424557648383E-2,7.6972424557648383E-2,7.6972424557648383E-2,7.6972424557648383E-2,7.6972424557648383E-2]
[]
[null,null,"Check","calculated","Ok/Check","n/a",null,null,null,null,null,null,null,null,{"$f":"IF(SUM(O12:O13)=1,\"Ok\",\"Check\")","v":"Ok"},{"$f":"IF(SUM(P12:P13)=1,\"Ok\",\"Check\")","v":"Ok"},"Ok","Ok","Ok",null,null,{"$f":"IF(COUNTIF(K15:T15,\"Check\")=0,\"Ok\",\"Check\")","v":"Ok"}]
[]
[null,"End"]

{"sheet":"Calc|Opex forecast","index":8,"n_rows":83,"n_cols":22,"rows_kept":83,"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$13","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$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":"2022-23"},{"$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":"2023-24"}]
[]
[]
[]
[null,"Calc | Estimated final year expenditure",null,null,"$millions",{"$f":"'Input|General'!G10","v":"2018-19"}]
[]
[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":""},{"$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":""},{"$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":""},{"$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":"2017-18"},{"$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":"2018-19"},{"$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'!E43","v":"$millions"},{"$f":"'Input|Reported opex'!F43","v":"nominal"},null,null,null,{"$f":"IF(J$10='Input|General'!$G$9,'Input|Reported opex'!J43,0)","v":0},{"$f":"IF(K$10='Input|General'!$G$9,'Input|Reported opex'!K43,0)","v":0},{"$f":"IF(L$10='Input|General'!$G$9,'Input|Reported opex'!L43,0)","v":0},{"$f":"IF(M$10='Input|General'!$G$9,'Input|Reported opex'!M43,0)","v":426.3881331369995},{"$f":"IF(N$10='Input|General'!$G$9,'Input|Reported opex'!N43,0)","v":0},{"$f":"IF(O$10='Input|General'!$G$9,'Input|Reported opex'!O43,0)","v":0},{"$f":"IF(P$10='Input|General'!$G$9,'Input|Reported opex'!P43,0)","v":0},{"$f":"IF(Q$10='Input|General'!$G$9,'Input|Reported opex'!Q43,0)","v":0},{"$f":"IF(R$10='Input|General'!$G$9,'Input|Reported opex'!R43,0)","v":0},{"$f":"IF(S$10='Input|General'!$G$9,'Input|Reported opex'!S43,0)","v":0}]
[null,null,"Total reported opex","Calculated",{"$f":"$E$8","v":"$millions"},"2018-19",null,null,null,{"$f":"J12*IF($F12=\"nominal\",LOOKUP($F13,Nominal_to_Real,'Input|Rate of change'!K$26:K$32),INDEX('Input|Rate of change'!$C$14:$O$22,MATCH('Calc|Opex forecast'!$F12,'Input|Rate of change'!$C$14:$C$22,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":"K12*IF($F12=\"nominal\",LOOKUP($F13,Nominal_to_Real,'Input|Rate of change'!L$26:L$32),INDEX('Input|Rate of change'!$C$14:$O$22,MATCH('Calc|Opex forecast'!$F12,'Input|Rate of change'!$C$14:$C$22,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$26:M$32),INDEX('Input|Rate of change'!$C$14:$O$22,MATCH('Calc|Opex forecast'!$F12,'Input|Rate of change'!$C$14:$C$22,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$26:N$32),INDEX('Input|Rate of change'!$C$14:$O$22,MATCH('Calc|Opex forecast'!$F12,'Input|Rate of change'!$C$14:$C$22,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":440.20365746184808},{"$f":"N12*IF($F12=\"nominal\",LOOKUP($F13,Nominal_to_Real,'Input|Rate of change'!O$26:O$32),INDEX('Input|Rate of change'!$C$14:$O$22,MATCH('Calc|Opex forecast'!$F12,'Input|Rate of change'!$C$14:$C$22,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$26:P$32),INDEX('Input|Rate of change'!$C$14:$O$22,MATCH('Calc|Opex forecast'!$F12,'Input|Rate of change'!$C$14:$C$22,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$26:Q$32),INDEX('Input|Rate of change'!$C$14:$O$22,MATCH('Calc|Opex forecast'!$F12,'Input|Rate of change'!$C$14:$C$22,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$26:R$32),INDEX('Input|Rate of change'!$C$14:$O$22,MATCH('Calc|Opex forecast'!$F12,'Input|Rate of change'!$C$14:$C$22,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$26:S$32),INDEX('Input|Rate of change'!$C$14:$O$22,MATCH('Calc|Opex forecast'!$F12,'Input|Rate of change'!$C$14:$C$22,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$26:T$32),INDEX('Input|Rate of change'!$C$14:$O$22,MATCH('Calc|Opex forecast'!$F12,'Input|Rate of change'!$C$14:$C$22,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,"Base year opex","Calculated",{"$f":"$E$8","v":"$millions"},{"$f":"$F$8","v":"2018-19"},null,null,null,{"$f":"IF(J$10='Input|General'!$G$9,J13,0)","v":0},{"$f":"IF(K$10='Input|General'!$G$9,K13,0)","v":0},{"$f":"IF(L$10='Input|General'!$G$9,L13,0)","v":0},{"$f":"IF(M$10='Input|General'!$G$9,M13,0)","v":440.20365746184808},{"$f":"IF(N$10='Input|General'!$G$9,N13,0)","v":0},{"$f":"IF(O$10='Input|General'!$G$9,O13,0)","v":0},{"$f":"IF(P$10='Input|General'!$G$9,P13,0)","v":0},{"$f":"IF(Q$10='Input|General'!$G$9,Q13,0)","v":0},{"$f":"IF(R$10='Input|General'!$G$9,R13,0)","v":0},{"$f":"IF(S$10='Input|General'!$G$9,S13,0)","v":0}]
[]
[null,null,"CAM adjustment","Inputs|Reported opex",{"$f":"'Input|Reported opex'!E48","v":"$millions"},{"$f":"'Input|Reported opex'!F48","v":"nominal"},null,null,null,{"$f":"IF(J$10='Input|General'!$G$9,'Input|Reported opex'!J48,0)","v":0},{"$f":"IF(K$10='Input|General'!$G$9,'Input|Reported opex'!K48,0)","v":0},{"$f":"IF(L$10='Input|General'!$G$9,'Input|Reported opex'!L48,0)","v":0},{"$f":"IF(M$10='Input|General'!$G$9,'Input|Reported opex'!M48,0)","v":0},{"$f":"IF(N$10='Input|General'!$G$9,'Input|Reported opex'!N48,0)","v":0},{"$f":"IF(O$10='Input|General'!$G$9,'Input|Reported opex'!O48,0)","v":0},{"$f":"IF(P$10='Input|General'!$G$9,'Input|Reported opex'!P48,0)","v":0},{"$f":"IF(Q$10='Input|General'!$G$9,'Input|Reported opex'!Q48,0)","v":0},{"$f":"IF(R$10='Input|General'!$G$9,'Input|Reported opex'!R48,0)","v":0},{"$f":"IF(S$10='Input|General'!$G$9,'Input|Reported opex'!S48,0)","v":0}]
[null,null,{"$f":"C17","v":"CAM adjustment"},"Calculated",{"$f":"$E$8","v":"$millions"},"2018-19",null,null,null,{"$f":"J17*IF($F17=\"nominal\",LOOKUP($F18,Nominal_to_Real,'Input|Rate of change'!K$26:K$32),INDEX('Input|Rate of change'!$C$14:$O$22,MATCH('Calc|Opex forecast'!$F17,'Input|Rate of change'!$C$14:$C$22,0),MATCH('Calc|Opex forecast'!$F18,'Input|Rate of change'!$C$14:$O$14,0)))*IF($E17=\"$millions\",1000000,IF($E17=\"$000\",1000,1))/IF($E18=\"$millions\",1000000,IF($E18=\"$000\",1000,1))","v":0},{"$f":"K17*IF($F17=\"nominal\",LOOKUP($F18,Nominal_to_Real,'Input|Rate of change'!L$26:L$32),INDEX('Input|Rate of change'!$C$14:$O$22,MATCH('Calc|Opex forecast'!$F17,'Input|Rate of change'!$C$14:$C$22,0),MATCH('Calc|Opex forecast'!$F18,'Input|Rate of change'!$C$14:$O$14,0)))*IF($E17=\"$millions\",1000000,IF($E17=\"$000\",1000,1))/IF($E18=\"$millions\",1000000,IF($E18=\"$000\",1000,1))","v":0},{"$f":"L17*IF($F17=\"nominal\",LOOKUP($F18,Nominal_to_Real,'Input|Rate of change'!M$26:M$32),INDEX('Input|Rate of change'!$C$14:$O$22,MATCH('Calc|Opex forecast'!$F17,'Input|Rate of change'!$C$14:$C$22,0),MATCH('Calc|Opex forecast'!$F18,'Input|Rate of change'!$C$14:$O$14,0)))*IF($E17=\"$millions\",1000000,IF($E17=\"$000\",1000,1))/IF($E18=\"$millions\",1000000,IF($E18=\"$000\",1000,1))","v":0},{"$f":"M17*IF($F17=\"nominal\",LOOKUP($F18,Nominal_to_Real,'Input|Rate of change'!N$26:N$32),INDEX('Input|Rate of change'!$C$14:$O$22,MATCH('Calc|Opex forecast'!$F17,'Input|Rate of change'!$C$14:$C$22,0),MATCH('Calc|Opex forecast'!$F18,'Input|Rate of change'!$C$14:$O$14,0)))*IF($E17=\"$millions\",1000000,IF($E17=\"$000\",1000,1))/IF($E18=\"$millions\",1000000,IF($E18=\"$000\",1000,1))","v":0},{"$f":"N17*IF($F17=\"nominal\",LOOKUP($F18,Nominal_to_Real,'Input|Rate of change'!O$26:O$32),INDEX('Input|Rate of change'!$C$14:$O$22,MATCH('Calc|Opex forecast'!$F17,'Input|Rate of change'!$C$14:$C$22,0),MATCH('Calc|Opex forecast'!$F18,'Input|Rate of change'!$C$14:$O$14,0)))*IF($E17=\"$millions\",1000000,IF($E17=\"$000\",1000,1))/IF($E18=\"$millions\",1000000,IF($E18=\"$000\",1000,1))","v":0},{"$f":"O17*IF($F17=\"nominal\",LOOKUP($F18,Nominal_to_Real,'Input|Rate of change'!P$26:P$32),INDEX('Input|Rate of change'!$C$14:$O$22,MATCH('Calc|Opex forecast'!$F17,'Input|Rate of change'!$C$14:$C$22,0),MATCH('Calc|Opex forecast'!$F18,'Input|Rate of change'!$C$14:$O$14,0)))*IF($E17=\"$millions\",1000000,IF($E17=\"$000\",1000,1))/IF($E18=\"$millions\",1000000,IF($E18=\"$000\",1000,1))","v":0},{"$f":"P17*IF($F17=\"nominal\",LOOKUP($F18,Nominal_to_Real,'Input|Rate of change'!Q$26:Q$32),INDEX('Input|Rate of change'!$C$14:$O$22,MATCH('Calc|Opex forecast'!$F17,'Input|Rate of change'!$C$14:$C$22,0),MATCH('Calc|Opex forecast'!$F18,'Input|Rate of change'!$C$14:$O$14,0)))*IF($E17=\"$millions\",1000000,IF($E17=\"$000\",1000,1))/IF($E18=\"$millions\",1000000,IF($E18=\"$000\",1000,1))","v":0},{"$f":"Q17*IF($F17=\"nominal\",LOOKUP($F18,Nominal_to_Real,'Input|Rate of change'!R$26:R$32),INDEX('Input|Rate of change'!$C$14:$O$22,MATCH('Calc|Opex forecast'!$F17,'Input|Rate of change'!$C$14:$C$22,0),MATCH('Calc|Opex forecast'!$F18,'Input|Rate of change'!$C$14:$O$14,0)))*IF($E17=\"$millions\",1000000,IF($E17=\"$000\",1000,1))/IF($E18=\"$millions\",1000000,IF($E18=\"$000\",1000,1))","v":0},{"$f":"R17*IF($F17=\"nominal\",LOOKUP($F18,Nominal_to_Real,'Input|Rate of change'!S$26:S$32),INDEX('Input|Rate of change'!$C$14:$O$22,MATCH('Calc|Opex forecast'!$F17,'Input|Rate of change'!$C$14:$C$22,0),MATCH('Calc|Opex forecast'!$F18,'Input|Rate of change'!$C$14:$O$14,0)))*IF($E17=\"$millions\",1000000,IF($E17=\"$000\",1000,1))/IF($E18=\"$millions\",1000000,IF($E18=\"$000\",1000,1))","v":0},{"$f":"S17*IF($F17=\"nominal\",LOOKUP($F18,Nominal_to_Real,'Input|Rate of change'!T$26:T$32),INDEX('Input|Rate of change'!$C$14:$O$22,MATCH('Calc|Opex forecast'!$F17,'Input|Rate of change'!$C$14:$C$22,0),MATCH('Calc|Opex forecast'!$F18,'Input|Rate of change'!$C$14:$O$14,0)))*IF($E17=\"$millions\",1000000,IF($E17=\"$000\",1000,1))/IF($E18=\"$millions\",1000000,IF($E18=\"$000\",1000,1))","v":0}]
[]
[null,null,"Service classification adjustment","Inputs|Reported opex",{"$f":"'Input|Reported opex'!E53","v":"$millions"},{"$f":"'Input|Reported opex'!F53","v":"nominal"},null,null,null,{"$f":"IF(J$10='Input|General'!$G$9,'Input|Reported opex'!J53,0)","v":0},{"$f":"IF(K$10='Input|General'!$G$9,'Input|Reported opex'!K53,0)","v":0},{"$f":"IF(L$10='Input|General'!$G$9,'Input|Reported opex'!L53,0)","v":0},{"$f":"IF(M$10='Input|General'!$G$9,'Input|Reported opex'!M53,0)","v":5.1948104900000009},{"$f":"IF(N$10='Input|General'!$G$9,'Input|Reported opex'!N53,0)","v":0},{"$f":"IF(O$10='Input|General'!$G$9,'Input|Reported opex'!O53,0)","v":0},{"$f":"IF(P$10='Input|General'!$G$9,'Input|Reported opex'!P53,0)","v":0},{"$f":"IF(Q$10='Input|General'!$G$9,'Input|Reported opex'!Q53,0)","v":0},{"$f":"IF(R$10='Input|General'!$G$9,'Input|Reported opex'!R53,0)","v":0},{"$f":"IF(S$10='Input|General'!$G$9,'Input|Reported opex'!S53,0)","v":0}]
[null,null,{"$f":"C20","v":"Service classification adjustment"},"Calculated",{"$f":"$E$8","v":"$millions"},"2018-19",null,null,null,{"$f":"J20*IF($F20=\"nominal\",LOOKUP($F21,Nominal_to_Real,'Input|Rate of change'!K$26:K$32),INDEX('Input|Rate of change'!$C$14:$O$22,MATCH('Calc|Opex forecast'!$F20,'Input|Rate of change'!$C$14:$C$22,0),MATCH('Calc|Opex forecast'!$F21,'Input|Rate of change'!$C$14:$O$14,0)))*IF($E20=\"$millions\",1000000,IF($E20=\"$000\",1000,1))/IF($E21=\"$millions\",1000000,IF($E21=\"$000\",1000,1))","v":0},{"$f":"K20*IF($F20=\"nominal\",LOOKUP($F21,Nominal_to_Real,'Input|Rate of change'!L$26:L$32),INDEX('Input|Rate of change'!$C$14:$O$22,MATCH('Calc|Opex forecast'!$F20,'Input|Rate of change'!$C$14:$C$22,0),MATCH('Calc|Opex forecast'!$F21,'Input|Rate of change'!$C$14:$O$14,0)))*IF($E20=\"$millions\",1000000,IF($E20=\"$000\",1000,1))/IF($E21=\"$millions\",1000000,IF($E21=\"$000\",1000,1))","v":0},{"$f":"L20*IF($F20=\"nominal\",LOOKUP($F21,Nominal_to_Real,'Input|Rate of change'!M$26:M$32),INDEX('Input|Rate of change'!$C$14:$O$22,MATCH('Calc|Opex forecast'!$F20,'Input|Rate of change'!$C$14:$C$22,0),MATCH('Calc|Opex forecast'!$F21,'Input|Rate of change'!$C$14:$O$14,0)))*IF($E20=\"$millions\",1000000,IF($E20=\"$000\",1000,1))/IF($E21=\"$millions\",1000000,IF($E21=\"$000\",1000,1))","v":0},{"$f":"M20*IF($F20=\"nominal\",LOOKUP($F21,Nominal_to_Real,'Input|Rate of change'!N$26:N$32),INDEX('Input|Rate of change'!$C$14:$O$22,MATCH('Calc|Opex forecast'!$F20,'Input|Rate of change'!$C$14:$C$22,0),MATCH('Calc|Opex forecast'!$F21,'Input|Rate of change'!$C$14:$O$14,0)))*IF($E20=\"$millions\",1000000,IF($E20=\"$000\",1000,1))/IF($E21=\"$millions\",1000000,IF($E21=\"$000\",1000,1))","v":5.3631290362023973},{"$f":"N20*IF($F20=\"nominal\",LOOKUP($F21,Nominal_to_Real,'Input|Rate of change'!O$26:O$32),INDEX('Input|Rate of change'!$C$14:$O$22,MATCH('Calc|Opex forecast'!$F20,'Input|Rate of change'!$C$14:$C$22,0),MATCH('Calc|Opex forecast'!$F21,'Input|Rate of change'!$C$14:$O$14,0)))*IF($E20=\"$millions\",1000000,IF($E20=\"$000\",1000,1))/IF($E21=\"$millions\",1000000,IF($E21=\"$000\",1000,1))","v":0},{"$f":"O20*IF($F20=\"nominal\",LOOKUP($F21,Nominal_to_Real,'Input|Rate of change'!P$26:P$32),INDEX('Input|Rate of change'!$C$14:$O$22,MATCH('Calc|Opex forecast'!$F20,'Input|Rate of change'!$C$14:$C$22,0),MATCH('Calc|Opex forecast'!$F21,'Input|Rate of change'!$C$14:$O$14,0)))*IF($E20=\"$millions\",1000000,IF($E20=\"$000\",1000,1))/IF($E21=\"$millions\",1000000,IF($E21=\"$000\",1000,1))","v":0},{"$f":"P20*IF($F20=\"nominal\",LOOKUP($F21,Nominal_to_Real,'Input|Rate of change'!Q$26:Q$32),INDEX('Input|Rate of change'!$C$14:$O$22,MATCH('Calc|Opex forecast'!$F20,'Input|Rate of change'!$C$14:$C$22,0),MATCH('Calc|Opex forecast'!$F21,'Input|Rate of change'!$C$14:$O$14,0)))*IF($E20=\"$millions\",1000000,IF($E20=\"$000\",1000,1))/IF($E21=\"$millions\",1000000,IF($E21=\"$000\",1000,1))","v":0},{"$f":"Q20*IF($F20=\"nominal\",LOOKUP($F21,Nominal_to_Real,'Input|Rate of change'!R$26:R$32),INDEX('Input|Rate of change'!$C$14:$O$22,MATCH('Calc|Opex forecast'!$F20,'Input|Rate of change'!$C$14:$C$22,0),MATCH('Calc|Opex forecast'!$F21,'Input|Rate of change'!$C$14:$O$14,0)))*IF($E20=\"$millions\",1000000,IF($E20=\"$000\",1000,1))/IF($E21=\"$millions\",1000000,IF($E21=\"$000\",1000,1))","v":0},{"$f":"R20*IF($F20=\"nominal\",LOOKUP($F21,Nominal_to_Real,'Input|Rate of change'!S$26:S$32),INDEX('Input|Rate of change'!$C$14:$O$22,MATCH('Calc|Opex forecast'!$F20,'Input|Rate of change'!$C$14:$C$22,0),MATCH('Calc|Opex forecast'!$F21,'Input|Rate of change'!$C$14:$O$14,0)))*IF($E20=\"$millions\",1000000,IF($E20=\"$000\",1000,1))/IF($E21=\"$millions\",1000000,IF($E21=\"$000\",1000,1))","v":0},{"$f":"S20*IF($F20=\"nominal\",LOOKUP($F21,Nominal_to_Real,'Input|Rate of change'!T$26:T$32),INDEX('Input|Rate of change'!$C$14:$O$22,MATCH('Calc|Opex forecast'!$F20,'Input|Rate of change'!$C$14:$C$22,0),MATCH('Calc|Opex forecast'!$F21,'Input|Rate of change'!$C$14:$O$14,0)))*IF($E20=\"$millions\",1000000,IF($E20=\"$000\",1000,1))/IF($E21=\"$millions\",1000000,IF($E21=\"$000\",1000,1))","v":0}]
[]
[null,null,"Total base year opex allowance","Inputs|Reported opex",{"$f":"'Input|Reported opex'!E24","v":"$millions"},"2013-14",null,null,null,null,null,null,{"$f":"'Input|Reported opex'!M24","v":397.52523427793471}]
[null,null,"Total base year opex allowance","Calculated",{"$f":"$E$8","v":"$millions"},"2018-19",null,null,null,null,null,null,{"$f":"M23*'Input|Rate of change'!O17","v":433.19579829994296}]
[]
[null,null,"Total final year opex allowance","Inputs|Reported opex",{"$f":"E23","v":"$millions"},"2013-14",null,null,null,null,null,null,null,{"$f":"'Input|Reported opex'!N24","v":403.64177251239352}]
[null,null,"Total final year opex allowance","Calculated",{"$f":"$E$8","v":"$millions"},"2018-19",null,null,null,null,null,null,null,{"$f":"N26*'Input|Rate of change'!O17","v":439.86118312292496}]
[]
[null,null,"Add estimated change in opex between the base year and the final year",null,null,null,null,null,null,null,null,null,null,{"$f":"N27-M24","v":6.6653848229819914}]
[]
[null,null,"Estimated final year opex",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(M15,M21,N29)","v":452.23217132103247}]
[]
[null,null,"Efficiency adjustment","calculated",{"$f":"$E$8","v":"$millions"},{"$f":"$F$8","v":"2018-19"},null,null,null,{"$f":"SUM(J15,J18,J21)*'Input|Reported opex'!J58","v":0},{"$f":"SUM(K15,K18,K21)*'Input|Reported opex'!K58","v":0},{"$f":"SUM(L15,L18,L21)*'Input|Reported opex'!L58","v":0},{"$f":"SUM(M15,M18,M21)*'Input|Reported opex'!M58","v":0},{"$f":"SUM(N15,N18,N21)*'Input|Reported opex'!N58","v":0},{"$f":"SUM(O15,O18,O21)*'Input|Reported opex'!O58","v":0},{"$f":"SUM(P15,P18,P21)*'Input|Reported opex'!P58","v":0},{"$f":"SUM(Q15,Q18,Q21)*'Input|Reported opex'!Q58","v":0},{"$f":"SUM(R15,R18,R21)*'Input|Reported opex'!R58","v":0},{"$f":"SUM(S15,S18,S21)*'Input|Reported opex'!S58","v":0}]
[]
[null,null,"Efficiency adjustment final year opex","calculated",{"$f":"$E$8","v":"$millions"},{"$f":"$F$8","v":"2018-19"},null,null,null,{"$f":"SUM(J15,J18,J21,J33)","v":0},{"$f":"SUM(K15,K18,K21,K33)","v":0},{"$f":"SUM(L15,L18,L21,L33)","v":0},null,{"$f":"SUM(N31,N33)","v":452.23217132103247},{"$f":"SUM(O15,O18,O21,O33)","v":0},{"$f":"SUM(P15,P18,P21,P33)","v":0},{"$f":"SUM(Q15,Q18,Q21,Q33)","v":0},{"$f":"SUM(R15,R18,R21,R33)","v":0},{"$f":"SUM(S15,S18,S21,S33)","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),'Input|Reported opex'!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),'Input|Reported opex'!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),'Input|Reported opex'!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),'Input|Reported opex'!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),'Input|Reported opex'!N$4,\"\"),\"\")","v":""},{"$f":"IF(RIGHT(O$4,2)>=RIGHT('Input|General'!$G$11,2),IF(RIGHT(O$4,2)<=RIGHT('Input|General'!$G$12,2),'Input|Reported opex'!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),'Input|Reported opex'!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),'Input|Reported opex'!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),'Input|Reported opex'!R$4,\"\"),\"\")","v":"2022-23"},{"$f":"IF(RIGHT(S$4,2)>=RIGHT('Input|General'!$G$11,2),IF(RIGHT(S$4,2)<=RIGHT('Input|General'!$G$12,2),'Input|Reported opex'!S$4,\"\"),\"\")","v":"2023-24"}]
[]
[]
[null,null,"Forecast output change","Calculated","Per cent","n/a",null,null,null,{"$f":"SUMPRODUCT('Input|Rate of change'!K73:K78,'Input|Rate of change'!$N$82:$N$87)","v":0},{"$f":"SUMPRODUCT('Input|Rate of change'!L73:L78,'Input|Rate of change'!$N$82:$N$87)","v":0},{"$f":"SUMPRODUCT('Input|Rate of change'!M73:M78,'Input|Rate of change'!$N$82:$N$87)","v":0},{"$f":"SUMPRODUCT('Input|Rate of change'!N73:N78,'Input|Rate of change'!$N$82:$N$87)","v":0},null,{"$f":"SUMPRODUCT('Input|Rate of change'!P73:P78,'Input|Rate of change'!$N$82:$N$87)","v":7.4579257629237665E-3},{"$f":"SUMPRODUCT('Input|Rate of change'!Q73:Q78,'Input|Rate of change'!$N$82:$N$87)","v":8.4875179886730375E-3},{"$f":"SUMPRODUCT('Input|Rate of change'!R73:R78,'Input|Rate of change'!$N$82:$N$87)","v":8.5303049626235528E-3},{"$f":"SUMPRODUCT('Input|Rate of change'!S73:S78,'Input|Rate of change'!$N$82:$N$87)","v":8.4638264392450993E-3},{"$f":"SUMPRODUCT('Input|Rate of change'!T73:T78,'Input|Rate of change'!$N$82:$N$87)","v":8.8171611326488663E-3}]
[]
[null,null,"Forecast price change","Calculated","Per cent","n/a",null,null,null,{"$f":"SUMPRODUCT('Input|Rate of change'!K38:K45,'Input|Rate of change'!K49:K56)","v":0},{"$f":"SUMPRODUCT('Input|Rate of change'!L38:L45,'Input|Rate of change'!L49:L56)","v":0},{"$f":"SUMPRODUCT('Input|Rate of change'!M38:M45,'Input|Rate of change'!M49:M56)","v":0},{"$f":"SUMPRODUCT('Input|Rate of change'!N38:N45,'Input|Rate of change'!N49:N56)","v":0},null,{"$f":"SUMPRODUCT('Input|Rate of change'!P38:P45,'Input|Rate of change'!P49:P56)","v":5.2480901227366658E-3},{"$f":"SUMPRODUCT('Input|Rate of change'!Q38:Q45,'Input|Rate of change'!Q49:Q56)","v":8.1678808540797052E-3},{"$f":"SUMPRODUCT('Input|Rate of change'!R38:R45,'Input|Rate of change'!R49:R56)","v":1.0371474257147602E-2},{"$f":"SUMPRODUCT('Input|Rate of change'!S38:S45,'Input|Rate of change'!S49:S56)","v":1.0320663407182235E-2},{"$f":"SUMPRODUCT('Input|Rate of change'!T38:T45,'Input|Rate of change'!T49:T56)","v":7.959957744825585E-3}]
[]
[null,null,"Forecast productivity change","Calculated","Per cent","n/a",null,null,null,{"$f":"'Input|Rate of change'!K95","v":0},{"$f":"'Input|Rate of change'!L95","v":0},{"$f":"'Input|Rate of change'!M95","v":0},{"$f":"'Input|Rate of change'!N95","v":0},null,{"$f":"'Input|Rate of change'!P95","v":0},{"$f":"'Input|Rate of change'!Q95","v":0},{"$f":"'Input|Rate of change'!R95","v":0},{"$f":"'Input|Rate of change'!S95","v":0},{"$f":"'Input|Rate of change'!T95","v":0}]
[]
[null,null,"Forecast rate of change","Calculated","Per cent","n/a",null,null,null,{"$f":"(1+J42)*(1+J44)*(1-J46)-1","v":0},{"$f":"(1+K42)*(1+K44)*(1-K46)-1","v":0},0,0,null,1.2745155752192927E-2,1.6724723878430936E-2,1.8990251058096597E-2,1.8871842150243623E-2,1.6847303107519584E-2]
[]
[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),'Input|Reported opex'!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),'Input|Reported opex'!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),'Input|Reported opex'!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),'Input|Reported opex'!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),'Input|Reported opex'!N$4,\"\"),\"\")","v":""},{"$f":"IF(RIGHT(O$4,2)>=RIGHT('Input|General'!$G$11,2),IF(RIGHT(O$4,2)<=RIGHT('Input|General'!$G$12,2),'Input|Reported opex'!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),'Input|Reported opex'!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),'Input|Reported opex'!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),'Input|Reported opex'!R$4,\"\"),\"\")","v":"2022-23"},{"$f":"IF(RIGHT(S$4,2)>=RIGHT('Input|General'!$G$11,2),IF(RIGHT(S$4,2)<=RIGHT('Input|General'!$G$12,2),'Input|Reported opex'!S$4,\"\"),\"\")","v":"2023-24"}]
[]
[null,null,{"$f":"'Input|Step changes'!C12","v":"Demand Management"},"Calculated",{"$f":"$E$8","v":"$millions"},{"$f":"$F$8","v":"2018-19"},null,null,null,{"$f":"'Input|Step changes'!J12*IF('Input|Step changes'!$F12=\"nominal\",LOOKUP($F54,Nominal_to_Real,'Input|Rate of change'!K$26:K$32),INDEX('Input|Rate of change'!$C$14:$O$22,MATCH('Input|Step changes'!$F12,'Input|Rate of change'!$C$14:$C$22,0),MATCH('Calc|Opex forecast'!$F54,'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($E54=\"$millions\",1000000,IF($E54=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!K12*IF('Input|Step changes'!$F12=\"nominal\",LOOKUP($F54,Nominal_to_Real,'Input|Rate of change'!L$26:L$32),INDEX('Input|Rate of change'!$C$14:$O$22,MATCH('Input|Step changes'!$F12,'Input|Rate of change'!$C$14:$C$22,0),MATCH('Calc|Opex forecast'!$F54,'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($E54=\"$millions\",1000000,IF($E54=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!L12*IF('Input|Step changes'!$F12=\"nominal\",LOOKUP($F54,Nominal_to_Real,'Input|Rate of change'!M$26:M$32),INDEX('Input|Rate of change'!$C$14:$O$22,MATCH('Input|Step changes'!$F12,'Input|Rate of change'!$C$14:$C$22,0),MATCH('Calc|Opex forecast'!$F54,'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($E54=\"$millions\",1000000,IF($E54=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!M12*IF('Input|Step changes'!$F12=\"nominal\",LOOKUP($F54,Nominal_to_Real,'Input|Rate of change'!N$26:N$32),INDEX('Input|Rate of change'!$C$14:$O$22,MATCH('Input|Step changes'!$F12,'Input|Rate of change'!$C$14:$C$22,0),MATCH('Calc|Opex forecast'!$F54,'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($E54=\"$millions\",1000000,IF($E54=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!N12*IF('Input|Step changes'!$F12=\"nominal\",LOOKUP($F54,Nominal_to_Real,'Input|Rate of change'!O$26:O$32),INDEX('Input|Rate of change'!$C$14:$O$22,MATCH('Input|Step changes'!$F12,'Input|Rate of change'!$C$14:$C$22,0),MATCH('Calc|Opex forecast'!$F54,'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($E54=\"$millions\",1000000,IF($E54=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!O12*IF('Input|Step changes'!$F12=\"nominal\",LOOKUP($F54,Nominal_to_Real,'Input|Rate of change'!P$26:P$32),INDEX('Input|Rate of change'!$C$14:$O$22,MATCH('Input|Step changes'!$F12,'Input|Rate of change'!$C$14:$C$22,0),MATCH('Calc|Opex forecast'!$F54,'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($E54=\"$millions\",1000000,IF($E54=\"$000\",1000,1))","v":3.6799555936416319},{"$f":"'Input|Step changes'!P12*IF('Input|Step changes'!$F12=\"nominal\",LOOKUP($F54,Nominal_to_Real,'Input|Rate of change'!Q$26:Q$32),INDEX('Input|Rate of change'!$C$14:$O$22,MATCH('Input|Step changes'!$F12,'Input|Rate of change'!$C$14:$C$22,0),MATCH('Calc|Opex forecast'!$F54,'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($E54=\"$millions\",1000000,IF($E54=\"$000\",1000,1))","v":3.6799555936416319},{"$f":"'Input|Step changes'!Q12*IF('Input|Step changes'!$F12=\"nominal\",LOOKUP($F54,Nominal_to_Real,'Input|Rate of change'!R$26:R$32),INDEX('Input|Rate of change'!$C$14:$O$22,MATCH('Input|Step changes'!$F12,'Input|Rate of change'!$C$14:$C$22,0),MATCH('Calc|Opex forecast'!$F54,'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($E54=\"$millions\",1000000,IF($E54=\"$000\",1000,1))","v":6.5155021133881581},{"$f":"'Input|Step changes'!R12*IF('Input|Step changes'!$F12=\"nominal\",LOOKUP($F54,Nominal_to_Real,'Input|Rate of change'!S$26:S$32),INDEX('Input|Rate of change'!$C$14:$O$22,MATCH('Input|Step changes'!$F12,'Input|Rate of change'!$C$14:$C$22,0),MATCH('Calc|Opex forecast'!$F54,'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($E54=\"$millions\",1000000,IF($E54=\"$000\",1000,1))","v":6.5572013269138418},{"$f":"'Input|Step changes'!S12*IF('Input|Step changes'!$F12=\"nominal\",LOOKUP($F54,Nominal_to_Real,'Input|Rate of change'!T$26:T$32),INDEX('Input|Rate of change'!$C$14:$O$22,MATCH('Input|Step changes'!$F12,'Input|Rate of change'!$C$14:$C$22,0),MATCH('Calc|Opex forecast'!$F54,'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($E54=\"$millions\",1000000,IF($E54=\"$000\",1000,1))","v":5.6919426462558942}]
[null,null,{"$f":"'Input|Step changes'!C13","v":"Accelerated tariff acceptance research project"},"Calculated","$millions",{"$f":"$F$8","v":"2018-19"},null,null,null,{"$f":"'Input|Step changes'!J13*IF('Input|Step changes'!$F13=\"nominal\",LOOKUP($F55,Nominal_to_Real,'Input|Rate of change'!K$26:K$32),INDEX('Input|Rate of change'!$C$14:$O$22,MATCH('Input|Step changes'!$F13,'Input|Rate of change'!$C$14:$C$22,0),MATCH('Calc|Opex forecast'!$F55,'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($E55=\"$millions\",1000000,IF($E55=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!K13*IF('Input|Step changes'!$F13=\"nominal\",LOOKUP($F55,Nominal_to_Real,'Input|Rate of change'!L$26:L$32),INDEX('Input|Rate of change'!$C$14:$O$22,MATCH('Input|Step changes'!$F13,'Input|Rate of change'!$C$14:$C$22,0),MATCH('Calc|Opex forecast'!$F55,'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($E55=\"$millions\",1000000,IF($E55=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!L13*IF('Input|Step changes'!$F13=\"nominal\",LOOKUP($F55,Nominal_to_Real,'Input|Rate of change'!M$26:M$32),INDEX('Input|Rate of change'!$C$14:$O$22,MATCH('Input|Step changes'!$F13,'Input|Rate of change'!$C$14:$C$22,0),MATCH('Calc|Opex forecast'!$F55,'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($E55=\"$millions\",1000000,IF($E55=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!M13*IF('Input|Step changes'!$F13=\"nominal\",LOOKUP($F55,Nominal_to_Real,'Input|Rate of change'!N$26:N$32),INDEX('Input|Rate of change'!$C$14:$O$22,MATCH('Input|Step changes'!$F13,'Input|Rate of change'!$C$14:$C$22,0),MATCH('Calc|Opex forecast'!$F55,'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($E55=\"$millions\",1000000,IF($E55=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!N13*IF('Input|Step changes'!$F13=\"nominal\",LOOKUP($F55,Nominal_to_Real,'Input|Rate of change'!O$26:O$32),INDEX('Input|Rate of change'!$C$14:$O$22,MATCH('Input|Step changes'!$F13,'Input|Rate of change'!$C$14:$C$22,0),MATCH('Calc|Opex forecast'!$F55,'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($E55=\"$millions\",1000000,IF($E55=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!O13*IF('Input|Step changes'!$F13=\"nominal\",LOOKUP($F55,Nominal_to_Real,'Input|Rate of change'!P$26:P$32),INDEX('Input|Rate of change'!$C$14:$O$22,MATCH('Input|Step changes'!$F13,'Input|Rate of change'!$C$14:$C$22,0),MATCH('Calc|Opex forecast'!$F55,'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($E55=\"$millions\",1000000,IF($E55=\"$000\",1000,1))","v":1.5},{"$f":"'Input|Step changes'!P13*IF('Input|Step changes'!$F13=\"nominal\",LOOKUP($F55,Nominal_to_Real,'Input|Rate of change'!Q$26:Q$32),INDEX('Input|Rate of change'!$C$14:$O$22,MATCH('Input|Step changes'!$F13,'Input|Rate of change'!$C$14:$C$22,0),MATCH('Calc|Opex forecast'!$F55,'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($E55=\"$millions\",1000000,IF($E55=\"$000\",1000,1))","v":1.5},{"$f":"'Input|Step changes'!Q13*IF('Input|Step changes'!$F13=\"nominal\",LOOKUP($F55,Nominal_to_Real,'Input|Rate of change'!R$26:R$32),INDEX('Input|Rate of change'!$C$14:$O$22,MATCH('Input|Step changes'!$F13,'Input|Rate of change'!$C$14:$C$22,0),MATCH('Calc|Opex forecast'!$F55,'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($E55=\"$millions\",1000000,IF($E55=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!R13*IF('Input|Step changes'!$F13=\"nominal\",LOOKUP($F55,Nominal_to_Real,'Input|Rate of change'!S$26:S$32),INDEX('Input|Rate of change'!$C$14:$O$22,MATCH('Input|Step changes'!$F13,'Input|Rate of change'!$C$14:$C$22,0),MATCH('Calc|Opex forecast'!$F55,'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($E55=\"$millions\",1000000,IF($E55=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!S13*IF('Input|Step changes'!$F13=\"nominal\",LOOKUP($F55,Nominal_to_Real,'Input|Rate of change'!T$26:T$32),INDEX('Input|Rate of change'!$C$14:$O$22,MATCH('Input|Step changes'!$F13,'Input|Rate of change'!$C$14:$C$22,0),MATCH('Calc|Opex forecast'!$F55,'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($E55=\"$millions\",1000000,IF($E55=\"$000\",1000,1))","v":0}]
[null,null,{"$f":"'Input|Step changes'!C14","v":0},"Calculated","$millions","2018-19",null,null,null,{"$f":"'Input|Step changes'!J14*IF('Input|Step changes'!$F14=\"nominal\",LOOKUP($F56,Nominal_to_Real,'Input|Rate of change'!K$26:K$32),INDEX('Input|Rate of change'!$C$14:$O$22,MATCH('Input|Step changes'!$F14,'Input|Rate of change'!$C$14:$C$22,0),MATCH('Calc|Opex forecast'!$F56,'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($E56=\"$millions\",1000000,IF($E56=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!K14*IF('Input|Step changes'!$F14=\"nominal\",LOOKUP($F56,Nominal_to_Real,'Input|Rate of change'!L$26:L$32),INDEX('Input|Rate of change'!$C$14:$O$22,MATCH('Input|Step changes'!$F14,'Input|Rate of change'!$C$14:$C$22,0),MATCH('Calc|Opex forecast'!$F56,'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($E56=\"$millions\",1000000,IF($E56=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!L14*IF('Input|Step changes'!$F14=\"nominal\",LOOKUP($F56,Nominal_to_Real,'Input|Rate of change'!M$26:M$32),INDEX('Input|Rate of change'!$C$14:$O$22,MATCH('Input|Step changes'!$F14,'Input|Rate of change'!$C$14:$C$22,0),MATCH('Calc|Opex forecast'!$F56,'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($E56=\"$millions\",1000000,IF($E56=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!M14*IF('Input|Step changes'!$F14=\"nominal\",LOOKUP($F56,Nominal_to_Real,'Input|Rate of change'!N$26:N$32),INDEX('Input|Rate of change'!$C$14:$O$22,MATCH('Input|Step changes'!$F14,'Input|Rate of change'!$C$14:$C$22,0),MATCH('Calc|Opex forecast'!$F56,'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($E56=\"$millions\",1000000,IF($E56=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!N14*IF('Input|Step changes'!$F14=\"nominal\",LOOKUP($F56,Nominal_to_Real,'Input|Rate of change'!O$26:O$32),INDEX('Input|Rate of change'!$C$14:$O$22,MATCH('Input|Step changes'!$F14,'Input|Rate of change'!$C$14:$C$22,0),MATCH('Calc|Opex forecast'!$F56,'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($E56=\"$millions\",1000000,IF($E56=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!O14*IF('Input|Step changes'!$F14=\"nominal\",LOOKUP($F56,Nominal_to_Real,'Input|Rate of change'!P$26:P$32),INDEX('Input|Rate of change'!$C$14:$O$22,MATCH('Input|Step changes'!$F14,'Input|Rate of change'!$C$14:$C$22,0),MATCH('Calc|Opex forecast'!$F56,'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($E56=\"$millions\",1000000,IF($E56=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!P14*IF('Input|Step changes'!$F14=\"nominal\",LOOKUP($F56,Nominal_to_Real,'Input|Rate of change'!Q$26:Q$32),INDEX('Input|Rate of change'!$C$14:$O$22,MATCH('Input|Step changes'!$F14,'Input|Rate of change'!$C$14:$C$22,0),MATCH('Calc|Opex forecast'!$F56,'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($E56=\"$millions\",1000000,IF($E56=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!Q14*IF('Input|Step changes'!$F14=\"nominal\",LOOKUP($F56,Nominal_to_Real,'Input|Rate of change'!R$26:R$32),INDEX('Input|Rate of change'!$C$14:$O$22,MATCH('Input|Step changes'!$F14,'Input|Rate of change'!$C$14:$C$22,0),MATCH('Calc|Opex forecast'!$F56,'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($E56=\"$millions\",1000000,IF($E56=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!R14*IF('Input|Step changes'!$F14=\"nominal\",LOOKUP($F56,Nominal_to_Real,'Input|Rate of change'!S$26:S$32),INDEX('Input|Rate of change'!$C$14:$O$22,MATCH('Input|Step changes'!$F14,'Input|Rate of change'!$C$14:$C$22,0),MATCH('Calc|Opex forecast'!$F56,'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($E56=\"$millions\",1000000,IF($E56=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!S14*IF('Input|Step changes'!$F14=\"nominal\",LOOKUP($F56,Nominal_to_Real,'Input|Rate of change'!T$26:T$32),INDEX('Input|Rate of change'!$C$14:$O$22,MATCH('Input|Step changes'!$F14,'Input|Rate of change'!$C$14:$C$22,0),MATCH('Calc|Opex forecast'!$F56,'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($E56=\"$millions\",1000000,IF($E56=\"$000\",1000,1))","v":0}]
[null,null,{"$f":"'Input|Step changes'!C15","v":0},"Calculated","$millions","2018-19",null,null,null,{"$f":"'Input|Step changes'!J15*IF('Input|Step changes'!$F15=\"nominal\",LOOKUP($F57,Nominal_to_Real,'Input|Rate of change'!K$26:K$32),INDEX('Input|Rate of change'!$C$14:$O$22,MATCH('Input|Step changes'!$F15,'Input|Rate of change'!$C$14:$C$22,0),MATCH('Calc|Opex forecast'!$F57,'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($E57=\"$millions\",1000000,IF($E57=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!K15*IF('Input|Step changes'!$F15=\"nominal\",LOOKUP($F57,Nominal_to_Real,'Input|Rate of change'!L$26:L$32),INDEX('Input|Rate of change'!$C$14:$O$22,MATCH('Input|Step changes'!$F15,'Input|Rate of change'!$C$14:$C$22,0),MATCH('Calc|Opex forecast'!$F57,'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($E57=\"$millions\",1000000,IF($E57=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!L15*IF('Input|Step changes'!$F15=\"nominal\",LOOKUP($F57,Nominal_to_Real,'Input|Rate of change'!M$26:M$32),INDEX('Input|Rate of change'!$C$14:$O$22,MATCH('Input|Step changes'!$F15,'Input|Rate of change'!$C$14:$C$22,0),MATCH('Calc|Opex forecast'!$F57,'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($E57=\"$millions\",1000000,IF($E57=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!M15*IF('Input|Step changes'!$F15=\"nominal\",LOOKUP($F57,Nominal_to_Real,'Input|Rate of change'!N$26:N$32),INDEX('Input|Rate of change'!$C$14:$O$22,MATCH('Input|Step changes'!$F15,'Input|Rate of change'!$C$14:$C$22,0),MATCH('Calc|Opex forecast'!$F57,'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($E57=\"$millions\",1000000,IF($E57=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!N15*IF('Input|Step changes'!$F15=\"nominal\",LOOKUP($F57,Nominal_to_Real,'Input|Rate of change'!O$26:O$32),INDEX('Input|Rate of change'!$C$14:$O$22,MATCH('Input|Step changes'!$F15,'Input|Rate of change'!$C$14:$C$22,0),MATCH('Calc|Opex forecast'!$F57,'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($E57=\"$millions\",1000000,IF($E57=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!O15*IF('Input|Step changes'!$F15=\"nominal\",LOOKUP($F57,Nominal_to_Real,'Input|Rate of change'!P$26:P$32),INDEX('Input|Rate of change'!$C$14:$O$22,MATCH('Input|Step changes'!$F15,'Input|Rate of change'!$C$14:$C$22,0),MATCH('Calc|Opex forecast'!$F57,'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($E57=\"$millions\",1000000,IF($E57=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!P15*IF('Input|Step changes'!$F15=\"nominal\",LOOKUP($F57,Nominal_to_Real,'Input|Rate of change'!Q$26:Q$32),INDEX('Input|Rate of change'!$C$14:$O$22,MATCH('Input|Step changes'!$F15,'Input|Rate of change'!$C$14:$C$22,0),MATCH('Calc|Opex forecast'!$F57,'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($E57=\"$millions\",1000000,IF($E57=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!Q15*IF('Input|Step changes'!$F15=\"nominal\",LOOKUP($F57,Nominal_to_Real,'Input|Rate of change'!R$26:R$32),INDEX('Input|Rate of change'!$C$14:$O$22,MATCH('Input|Step changes'!$F15,'Input|Rate of change'!$C$14:$C$22,0),MATCH('Calc|Opex forecast'!$F57,'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($E57=\"$millions\",1000000,IF($E57=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!R15*IF('Input|Step changes'!$F15=\"nominal\",LOOKUP($F57,Nominal_to_Real,'Input|Rate of change'!S$26:S$32),INDEX('Input|Rate of change'!$C$14:$O$22,MATCH('Input|Step changes'!$F15,'Input|Rate of change'!$C$14:$C$22,0),MATCH('Calc|Opex forecast'!$F57,'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($E57=\"$millions\",1000000,IF($E57=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!S15*IF('Input|Step changes'!$F15=\"nominal\",LOOKUP($F57,Nominal_to_Real,'Input|Rate of change'!T$26:T$32),INDEX('Input|Rate of change'!$C$14:$O$22,MATCH('Input|Step changes'!$F15,'Input|Rate of change'!$C$14:$C$22,0),MATCH('Calc|Opex forecast'!$F57,'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($E57=\"$millions\",1000000,IF($E57=\"$000\",1000,1))","v":0}]
[null,null,{"$f":"'Input|Step changes'!C16","v":0},"Calculated","$millions","2018-19",null,null,null,{"$f":"'Input|Step changes'!J16*IF('Input|Step changes'!$F16=\"nominal\",LOOKUP($F58,Nominal_to_Real,'Input|Rate of change'!K$26:K$32),INDEX('Input|Rate of change'!$C$14:$O$22,MATCH('Input|Step changes'!$F16,'Input|Rate of change'!$C$14:$C$22,0),MATCH('Calc|Opex forecast'!$F58,'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($E58=\"$millions\",1000000,IF($E58=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!K16*IF('Input|Step changes'!$F16=\"nominal\",LOOKUP($F58,Nominal_to_Real,'Input|Rate of change'!L$26:L$32),INDEX('Input|Rate of change'!$C$14:$O$22,MATCH('Input|Step changes'!$F16,'Input|Rate of change'!$C$14:$C$22,0),MATCH('Calc|Opex forecast'!$F58,'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($E58=\"$millions\",1000000,IF($E58=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!L16*IF('Input|Step changes'!$F16=\"nominal\",LOOKUP($F58,Nominal_to_Real,'Input|Rate of change'!M$26:M$32),INDEX('Input|Rate of change'!$C$14:$O$22,MATCH('Input|Step changes'!$F16,'Input|Rate of change'!$C$14:$C$22,0),MATCH('Calc|Opex forecast'!$F58,'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($E58=\"$millions\",1000000,IF($E58=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!M16*IF('Input|Step changes'!$F16=\"nominal\",LOOKUP($F58,Nominal_to_Real,'Input|Rate of change'!N$26:N$32),INDEX('Input|Rate of change'!$C$14:$O$22,MATCH('Input|Step changes'!$F16,'Input|Rate of change'!$C$14:$C$22,0),MATCH('Calc|Opex forecast'!$F58,'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($E58=\"$millions\",1000000,IF($E58=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!N16*IF('Input|Step changes'!$F16=\"nominal\",LOOKUP($F58,Nominal_to_Real,'Input|Rate of change'!O$26:O$32),INDEX('Input|Rate of change'!$C$14:$O$22,MATCH('Input|Step changes'!$F16,'Input|Rate of change'!$C$14:$C$22,0),MATCH('Calc|Opex forecast'!$F58,'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($E58=\"$millions\",1000000,IF($E58=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!O16*IF('Input|Step changes'!$F16=\"nominal\",LOOKUP($F58,Nominal_to_Real,'Input|Rate of change'!P$26:P$32),INDEX('Input|Rate of change'!$C$14:$O$22,MATCH('Input|Step changes'!$F16,'Input|Rate of change'!$C$14:$C$22,0),MATCH('Calc|Opex forecast'!$F58,'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($E58=\"$millions\",1000000,IF($E58=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!P16*IF('Input|Step changes'!$F16=\"nominal\",LOOKUP($F58,Nominal_to_Real,'Input|Rate of change'!Q$26:Q$32),INDEX('Input|Rate of change'!$C$14:$O$22,MATCH('Input|Step changes'!$F16,'Input|Rate of change'!$C$14:$C$22,0),MATCH('Calc|Opex forecast'!$F58,'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($E58=\"$millions\",1000000,IF($E58=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!Q16*IF('Input|Step changes'!$F16=\"nominal\",LOOKUP($F58,Nominal_to_Real,'Input|Rate of change'!R$26:R$32),INDEX('Input|Rate of change'!$C$14:$O$22,MATCH('Input|Step changes'!$F16,'Input|Rate of change'!$C$14:$C$22,0),MATCH('Calc|Opex forecast'!$F58,'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($E58=\"$millions\",1000000,IF($E58=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!R16*IF('Input|Step changes'!$F16=\"nominal\",LOOKUP($F58,Nominal_to_Real,'Input|Rate of change'!S$26:S$32),INDEX('Input|Rate of change'!$C$14:$O$22,MATCH('Input|Step changes'!$F16,'Input|Rate of change'!$C$14:$C$22,0),MATCH('Calc|Opex forecast'!$F58,'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($E58=\"$millions\",1000000,IF($E58=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!S16*IF('Input|Step changes'!$F16=\"nominal\",LOOKUP($F58,Nominal_to_Real,'Input|Rate of change'!T$26:T$32),INDEX('Input|Rate of change'!$C$14:$O$22,MATCH('Input|Step changes'!$F16,'Input|Rate of change'!$C$14:$C$22,0),MATCH('Calc|Opex forecast'!$F58,'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($E58=\"$millions\",1000000,IF($E58=\"$000\",1000,1))","v":0}]
[null,null,{"$f":"'Input|Step changes'!C17","v":0},"Calculated","$millions","2018-19",null,null,null,{"$f":"'Input|Step changes'!J17*IF('Input|Step changes'!$F17=\"nominal\",LOOKUP($F59,Nominal_to_Real,'Input|Rate of change'!K$26:K$32),INDEX('Input|Rate of change'!$C$14:$O$22,MATCH('Input|Step changes'!$F17,'Input|Rate of change'!$C$14:$C$22,0),MATCH('Calc|Opex forecast'!$F59,'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($E59=\"$millions\",1000000,IF($E59=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!K17*IF('Input|Step changes'!$F17=\"nominal\",LOOKUP($F59,Nominal_to_Real,'Input|Rate of change'!L$26:L$32),INDEX('Input|Rate of change'!$C$14:$O$22,MATCH('Input|Step changes'!$F17,'Input|Rate of change'!$C$14:$C$22,0),MATCH('Calc|Opex forecast'!$F59,'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($E59=\"$millions\",1000000,IF($E59=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!L17*IF('Input|Step changes'!$F17=\"nominal\",LOOKUP($F59,Nominal_to_Real,'Input|Rate of change'!M$26:M$32),INDEX('Input|Rate of change'!$C$14:$O$22,MATCH('Input|Step changes'!$F17,'Input|Rate of change'!$C$14:$C$22,0),MATCH('Calc|Opex forecast'!$F59,'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($E59=\"$millions\",1000000,IF($E59=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!M17*IF('Input|Step changes'!$F17=\"nominal\",LOOKUP($F59,Nominal_to_Real,'Input|Rate of change'!N$26:N$32),INDEX('Input|Rate of change'!$C$14:$O$22,MATCH('Input|Step changes'!$F17,'Input|Rate of change'!$C$14:$C$22,0),MATCH('Calc|Opex forecast'!$F59,'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($E59=\"$millions\",1000000,IF($E59=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!N17*IF('Input|Step changes'!$F17=\"nominal\",LOOKUP($F59,Nominal_to_Real,'Input|Rate of change'!O$26:O$32),INDEX('Input|Rate of change'!$C$14:$O$22,MATCH('Input|Step changes'!$F17,'Input|Rate of change'!$C$14:$C$22,0),MATCH('Calc|Opex forecast'!$F59,'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($E59=\"$millions\",1000000,IF($E59=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!O17*IF('Input|Step changes'!$F17=\"nominal\",LOOKUP($F59,Nominal_to_Real,'Input|Rate of change'!P$26:P$32),INDEX('Input|Rate of change'!$C$14:$O$22,MATCH('Input|Step changes'!$F17,'Input|Rate of change'!$C$14:$C$22,0),MATCH('Calc|Opex forecast'!$F59,'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($E59=\"$millions\",1000000,IF($E59=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!P17*IF('Input|Step changes'!$F17=\"nominal\",LOOKUP($F59,Nominal_to_Real,'Input|Rate of change'!Q$26:Q$32),INDEX('Input|Rate of change'!$C$14:$O$22,MATCH('Input|Step changes'!$F17,'Input|Rate of change'!$C$14:$C$22,0),MATCH('Calc|Opex forecast'!$F59,'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($E59=\"$millions\",1000000,IF($E59=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!Q17*IF('Input|Step changes'!$F17=\"nominal\",LOOKUP($F59,Nominal_to_Real,'Input|Rate of change'!R$26:R$32),INDEX('Input|Rate of change'!$C$14:$O$22,MATCH('Input|Step changes'!$F17,'Input|Rate of change'!$C$14:$C$22,0),MATCH('Calc|Opex forecast'!$F59,'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($E59=\"$millions\",1000000,IF($E59=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!R17*IF('Input|Step changes'!$F17=\"nominal\",LOOKUP($F59,Nominal_to_Real,'Input|Rate of change'!S$26:S$32),INDEX('Input|Rate of change'!$C$14:$O$22,MATCH('Input|Step changes'!$F17,'Input|Rate of change'!$C$14:$C$22,0),MATCH('Calc|Opex forecast'!$F59,'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($E59=\"$millions\",1000000,IF($E59=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!S17*IF('Input|Step changes'!$F17=\"nominal\",LOOKUP($F59,Nominal_to_Real,'Input|Rate of change'!T$26:T$32),INDEX('Input|Rate of change'!$C$14:$O$22,MATCH('Input|Step changes'!$F17,'Input|Rate of change'!$C$14:$C$22,0),MATCH('Calc|Opex forecast'!$F59,'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($E59=\"$millions\",1000000,IF($E59=\"$000\",1000,1))","v":0}]
[null,null,{"$f":"'Input|Step changes'!C18","v":0},"Calculated","$millions","2018-19",null,null,null,{"$f":"'Input|Step changes'!J18*IF('Input|Step changes'!$F18=\"nominal\",LOOKUP($F60,Nominal_to_Real,'Input|Rate of change'!K$26:K$32),INDEX('Input|Rate of change'!$C$14:$O$22,MATCH('Input|Step changes'!$F18,'Input|Rate of change'!$C$14:$C$22,0),MATCH('Calc|Opex forecast'!$F60,'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($E60=\"$millions\",1000000,IF($E60=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!K18*IF('Input|Step changes'!$F18=\"nominal\",LOOKUP($F60,Nominal_to_Real,'Input|Rate of change'!L$26:L$32),INDEX('Input|Rate of change'!$C$14:$O$22,MATCH('Input|Step changes'!$F18,'Input|Rate of change'!$C$14:$C$22,0),MATCH('Calc|Opex forecast'!$F60,'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($E60=\"$millions\",1000000,IF($E60=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!L18*IF('Input|Step changes'!$F18=\"nominal\",LOOKUP($F60,Nominal_to_Real,'Input|Rate of change'!M$26:M$32),INDEX('Input|Rate of change'!$C$14:$O$22,MATCH('Input|Step changes'!$F18,'Input|Rate of change'!$C$14:$C$22,0),MATCH('Calc|Opex forecast'!$F60,'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($E60=\"$millions\",1000000,IF($E60=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!M18*IF('Input|Step changes'!$F18=\"nominal\",LOOKUP($F60,Nominal_to_Real,'Input|Rate of change'!N$26:N$32),INDEX('Input|Rate of change'!$C$14:$O$22,MATCH('Input|Step changes'!$F18,'Input|Rate of change'!$C$14:$C$22,0),MATCH('Calc|Opex forecast'!$F60,'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($E60=\"$millions\",1000000,IF($E60=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!N18*IF('Input|Step changes'!$F18=\"nominal\",LOOKUP($F60,Nominal_to_Real,'Input|Rate of change'!O$26:O$32),INDEX('Input|Rate of change'!$C$14:$O$22,MATCH('Input|Step changes'!$F18,'Input|Rate of change'!$C$14:$C$22,0),MATCH('Calc|Opex forecast'!$F60,'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($E60=\"$millions\",1000000,IF($E60=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!O18*IF('Input|Step changes'!$F18=\"nominal\",LOOKUP($F60,Nominal_to_Real,'Input|Rate of change'!P$26:P$32),INDEX('Input|Rate of change'!$C$14:$O$22,MATCH('Input|Step changes'!$F18,'Input|Rate of change'!$C$14:$C$22,0),MATCH('Calc|Opex forecast'!$F60,'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($E60=\"$millions\",1000000,IF($E60=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!P18*IF('Input|Step changes'!$F18=\"nominal\",LOOKUP($F60,Nominal_to_Real,'Input|Rate of change'!Q$26:Q$32),INDEX('Input|Rate of change'!$C$14:$O$22,MATCH('Input|Step changes'!$F18,'Input|Rate of change'!$C$14:$C$22,0),MATCH('Calc|Opex forecast'!$F60,'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($E60=\"$millions\",1000000,IF($E60=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!Q18*IF('Input|Step changes'!$F18=\"nominal\",LOOKUP($F60,Nominal_to_Real,'Input|Rate of change'!R$26:R$32),INDEX('Input|Rate of change'!$C$14:$O$22,MATCH('Input|Step changes'!$F18,'Input|Rate of change'!$C$14:$C$22,0),MATCH('Calc|Opex forecast'!$F60,'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($E60=\"$millions\",1000000,IF($E60=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!R18*IF('Input|Step changes'!$F18=\"nominal\",LOOKUP($F60,Nominal_to_Real,'Input|Rate of change'!S$26:S$32),INDEX('Input|Rate of change'!$C$14:$O$22,MATCH('Input|Step changes'!$F18,'Input|Rate of change'!$C$14:$C$22,0),MATCH('Calc|Opex forecast'!$F60,'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($E60=\"$millions\",1000000,IF($E60=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!S18*IF('Input|Step changes'!$F18=\"nominal\",LOOKUP($F60,Nominal_to_Real,'Input|Rate of change'!T$26:T$32),INDEX('Input|Rate of change'!$C$14:$O$22,MATCH('Input|Step changes'!$F18,'Input|Rate of change'!$C$14:$C$22,0),MATCH('Calc|Opex forecast'!$F60,'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($E60=\"$millions\",1000000,IF($E60=\"$000\",1000,1))","v":0}]
[null,null,{"$f":"'Input|Step changes'!C19","v":0},"Calculated","$millions","2018-19",null,null,null,{"$f":"'Input|Step changes'!J19*IF('Input|Step changes'!$F19=\"nominal\",LOOKUP($F61,Nominal_to_Real,'Input|Rate of change'!K$26:K$32),INDEX('Input|Rate of change'!$C$14:$O$22,MATCH('Input|Step changes'!$F19,'Input|Rate of change'!$C$14:$C$22,0),MATCH('Calc|Opex forecast'!$F61,'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($E61=\"$millions\",1000000,IF($E61=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!K19*IF('Input|Step changes'!$F19=\"nominal\",LOOKUP($F61,Nominal_to_Real,'Input|Rate of change'!L$26:L$32),INDEX('Input|Rate of change'!$C$14:$O$22,MATCH('Input|Step changes'!$F19,'Input|Rate of change'!$C$14:$C$22,0),MATCH('Calc|Opex forecast'!$F61,'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($E61=\"$millions\",1000000,IF($E61=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!L19*IF('Input|Step changes'!$F19=\"nominal\",LOOKUP($F61,Nominal_to_Real,'Input|Rate of change'!M$26:M$32),INDEX('Input|Rate of change'!$C$14:$O$22,MATCH('Input|Step changes'!$F19,'Input|Rate of change'!$C$14:$C$22,0),MATCH('Calc|Opex forecast'!$F61,'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($E61=\"$millions\",1000000,IF($E61=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!M19*IF('Input|Step changes'!$F19=\"nominal\",LOOKUP($F61,Nominal_to_Real,'Input|Rate of change'!N$26:N$32),INDEX('Input|Rate of change'!$C$14:$O$22,MATCH('Input|Step changes'!$F19,'Input|Rate of change'!$C$14:$C$22,0),MATCH('Calc|Opex forecast'!$F61,'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($E61=\"$millions\",1000000,IF($E61=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!N19*IF('Input|Step changes'!$F19=\"nominal\",LOOKUP($F61,Nominal_to_Real,'Input|Rate of change'!O$26:O$32),INDEX('Input|Rate of change'!$C$14:$O$22,MATCH('Input|Step changes'!$F19,'Input|Rate of change'!$C$14:$C$22,0),MATCH('Calc|Opex forecast'!$F61,'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($E61=\"$millions\",1000000,IF($E61=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!O19*IF('Input|Step changes'!$F19=\"nominal\",LOOKUP($F61,Nominal_to_Real,'Input|Rate of change'!P$26:P$32),INDEX('Input|Rate of change'!$C$14:$O$22,MATCH('Input|Step changes'!$F19,'Input|Rate of change'!$C$14:$C$22,0),MATCH('Calc|Opex forecast'!$F61,'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($E61=\"$millions\",1000000,IF($E61=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!P19*IF('Input|Step changes'!$F19=\"nominal\",LOOKUP($F61,Nominal_to_Real,'Input|Rate of change'!Q$26:Q$32),INDEX('Input|Rate of change'!$C$14:$O$22,MATCH('Input|Step changes'!$F19,'Input|Rate of change'!$C$14:$C$22,0),MATCH('Calc|Opex forecast'!$F61,'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($E61=\"$millions\",1000000,IF($E61=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!Q19*IF('Input|Step changes'!$F19=\"nominal\",LOOKUP($F61,Nominal_to_Real,'Input|Rate of change'!R$26:R$32),INDEX('Input|Rate of change'!$C$14:$O$22,MATCH('Input|Step changes'!$F19,'Input|Rate of change'!$C$14:$C$22,0),MATCH('Calc|Opex forecast'!$F61,'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($E61=\"$millions\",1000000,IF($E61=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!R19*IF('Input|Step changes'!$F19=\"nominal\",LOOKUP($F61,Nominal_to_Real,'Input|Rate of change'!S$26:S$32),INDEX('Input|Rate of change'!$C$14:$O$22,MATCH('Input|Step changes'!$F19,'Input|Rate of change'!$C$14:$C$22,0),MATCH('Calc|Opex forecast'!$F61,'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($E61=\"$millions\",1000000,IF($E61=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!S19*IF('Input|Step changes'!$F19=\"nominal\",LOOKUP($F61,Nominal_to_Real,'Input|Rate of change'!T$26:T$32),INDEX('Input|Rate of change'!$C$14:$O$22,MATCH('Input|Step changes'!$F19,'Input|Rate of change'!$C$14:$C$22,0),MATCH('Calc|Opex forecast'!$F61,'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($E61=\"$millions\",1000000,IF($E61=\"$000\",1000,1))","v":0}]
[null,null,{"$f":"'Input|Step changes'!C20","v":0},"Calculated","$millions","2018-19",null,null,null,{"$f":"'Input|Step changes'!J20*IF('Input|Step changes'!$F20=\"nominal\",LOOKUP($F62,Nominal_to_Real,'Input|Rate of change'!K$26:K$32),INDEX('Input|Rate of change'!$C$14:$O$22,MATCH('Input|Step changes'!$F20,'Input|Rate of change'!$C$14:$C$22,0),MATCH('Calc|Opex forecast'!$F62,'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($E62=\"$millions\",1000000,IF($E62=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!K20*IF('Input|Step changes'!$F20=\"nominal\",LOOKUP($F62,Nominal_to_Real,'Input|Rate of change'!L$26:L$32),INDEX('Input|Rate of change'!$C$14:$O$22,MATCH('Input|Step changes'!$F20,'Input|Rate of change'!$C$14:$C$22,0),MATCH('Calc|Opex forecast'!$F62,'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($E62=\"$millions\",1000000,IF($E62=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!L20*IF('Input|Step changes'!$F20=\"nominal\",LOOKUP($F62,Nominal_to_Real,'Input|Rate of change'!M$26:M$32),INDEX('Input|Rate of change'!$C$14:$O$22,MATCH('Input|Step changes'!$F20,'Input|Rate of change'!$C$14:$C$22,0),MATCH('Calc|Opex forecast'!$F62,'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($E62=\"$millions\",1000000,IF($E62=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!M20*IF('Input|Step changes'!$F20=\"nominal\",LOOKUP($F62,Nominal_to_Real,'Input|Rate of change'!N$26:N$32),INDEX('Input|Rate of change'!$C$14:$O$22,MATCH('Input|Step changes'!$F20,'Input|Rate of change'!$C$14:$C$22,0),MATCH('Calc|Opex forecast'!$F62,'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($E62=\"$millions\",1000000,IF($E62=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!N20*IF('Input|Step changes'!$F20=\"nominal\",LOOKUP($F62,Nominal_to_Real,'Input|Rate of change'!O$26:O$32),INDEX('Input|Rate of change'!$C$14:$O$22,MATCH('Input|Step changes'!$F20,'Input|Rate of change'!$C$14:$C$22,0),MATCH('Calc|Opex forecast'!$F62,'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($E62=\"$millions\",1000000,IF($E62=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!O20*IF('Input|Step changes'!$F20=\"nominal\",LOOKUP($F62,Nominal_to_Real,'Input|Rate of change'!P$26:P$32),INDEX('Input|Rate of change'!$C$14:$O$22,MATCH('Input|Step changes'!$F20,'Input|Rate of change'!$C$14:$C$22,0),MATCH('Calc|Opex forecast'!$F62,'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($E62=\"$millions\",1000000,IF($E62=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!P20*IF('Input|Step changes'!$F20=\"nominal\",LOOKUP($F62,Nominal_to_Real,'Input|Rate of change'!Q$26:Q$32),INDEX('Input|Rate of change'!$C$14:$O$22,MATCH('Input|Step changes'!$F20,'Input|Rate of change'!$C$14:$C$22,0),MATCH('Calc|Opex forecast'!$F62,'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($E62=\"$millions\",1000000,IF($E62=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!Q20*IF('Input|Step changes'!$F20=\"nominal\",LOOKUP($F62,Nominal_to_Real,'Input|Rate of change'!R$26:R$32),INDEX('Input|Rate of change'!$C$14:$O$22,MATCH('Input|Step changes'!$F20,'Input|Rate of change'!$C$14:$C$22,0),MATCH('Calc|Opex forecast'!$F62,'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($E62=\"$millions\",1000000,IF($E62=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!R20*IF('Input|Step changes'!$F20=\"nominal\",LOOKUP($F62,Nominal_to_Real,'Input|Rate of change'!S$26:S$32),INDEX('Input|Rate of change'!$C$14:$O$22,MATCH('Input|Step changes'!$F20,'Input|Rate of change'!$C$14:$C$22,0),MATCH('Calc|Opex forecast'!$F62,'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($E62=\"$millions\",1000000,IF($E62=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!S20*IF('Input|Step changes'!$F20=\"nominal\",LOOKUP($F62,Nominal_to_Real,'Input|Rate of change'!T$26:T$32),INDEX('Input|Rate of change'!$C$14:$O$22,MATCH('Input|Step changes'!$F20,'Input|Rate of change'!$C$14:$C$22,0),MATCH('Calc|Opex forecast'!$F62,'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($E62=\"$millions\",1000000,IF($E62=\"$000\",1000,1))","v":0}]
[null,null,{"$f":"'Input|Step changes'!C21","v":0},"Calculated","$millions","2018-19",null,null,null,{"$f":"'Input|Step changes'!J21*IF('Input|Step changes'!$F21=\"nominal\",LOOKUP($F63,Nominal_to_Real,'Input|Rate of change'!K$26:K$32),INDEX('Input|Rate of change'!$C$14:$O$22,MATCH('Input|Step changes'!$F21,'Input|Rate of change'!$C$14:$C$22,0),MATCH('Calc|Opex forecast'!$F63,'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($E63=\"$millions\",1000000,IF($E63=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!K21*IF('Input|Step changes'!$F21=\"nominal\",LOOKUP($F63,Nominal_to_Real,'Input|Rate of change'!L$26:L$32),INDEX('Input|Rate of change'!$C$14:$O$22,MATCH('Input|Step changes'!$F21,'Input|Rate of change'!$C$14:$C$22,0),MATCH('Calc|Opex forecast'!$F63,'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($E63=\"$millions\",1000000,IF($E63=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!L21*IF('Input|Step changes'!$F21=\"nominal\",LOOKUP($F63,Nominal_to_Real,'Input|Rate of change'!M$26:M$32),INDEX('Input|Rate of change'!$C$14:$O$22,MATCH('Input|Step changes'!$F21,'Input|Rate of change'!$C$14:$C$22,0),MATCH('Calc|Opex forecast'!$F63,'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($E63=\"$millions\",1000000,IF($E63=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!M21*IF('Input|Step changes'!$F21=\"nominal\",LOOKUP($F63,Nominal_to_Real,'Input|Rate of change'!N$26:N$32),INDEX('Input|Rate of change'!$C$14:$O$22,MATCH('Input|Step changes'!$F21,'Input|Rate of change'!$C$14:$C$22,0),MATCH('Calc|Opex forecast'!$F63,'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($E63=\"$millions\",1000000,IF($E63=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!N21*IF('Input|Step changes'!$F21=\"nominal\",LOOKUP($F63,Nominal_to_Real,'Input|Rate of change'!O$26:O$32),INDEX('Input|Rate of change'!$C$14:$O$22,MATCH('Input|Step changes'!$F21,'Input|Rate of change'!$C$14:$C$22,0),MATCH('Calc|Opex forecast'!$F63,'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($E63=\"$millions\",1000000,IF($E63=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!O21*IF('Input|Step changes'!$F21=\"nominal\",LOOKUP($F63,Nominal_to_Real,'Input|Rate of change'!P$26:P$32),INDEX('Input|Rate of change'!$C$14:$O$22,MATCH('Input|Step changes'!$F21,'Input|Rate of change'!$C$14:$C$22,0),MATCH('Calc|Opex forecast'!$F63,'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($E63=\"$millions\",1000000,IF($E63=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!P21*IF('Input|Step changes'!$F21=\"nominal\",LOOKUP($F63,Nominal_to_Real,'Input|Rate of change'!Q$26:Q$32),INDEX('Input|Rate of change'!$C$14:$O$22,MATCH('Input|Step changes'!$F21,'Input|Rate of change'!$C$14:$C$22,0),MATCH('Calc|Opex forecast'!$F63,'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($E63=\"$millions\",1000000,IF($E63=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!Q21*IF('Input|Step changes'!$F21=\"nominal\",LOOKUP($F63,Nominal_to_Real,'Input|Rate of change'!R$26:R$32),INDEX('Input|Rate of change'!$C$14:$O$22,MATCH('Input|Step changes'!$F21,'Input|Rate of change'!$C$14:$C$22,0),MATCH('Calc|Opex forecast'!$F63,'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($E63=\"$millions\",1000000,IF($E63=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!R21*IF('Input|Step changes'!$F21=\"nominal\",LOOKUP($F63,Nominal_to_Real,'Input|Rate of change'!S$26:S$32),INDEX('Input|Rate of change'!$C$14:$O$22,MATCH('Input|Step changes'!$F21,'Input|Rate of change'!$C$14:$C$22,0),MATCH('Calc|Opex forecast'!$F63,'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($E63=\"$millions\",1000000,IF($E63=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!S21*IF('Input|Step changes'!$F21=\"nominal\",LOOKUP($F63,Nominal_to_Real,'Input|Rate of change'!T$26:T$32),INDEX('Input|Rate of change'!$C$14:$O$22,MATCH('Input|Step changes'!$F21,'Input|Rate of change'!$C$14:$C$22,0),MATCH('Calc|Opex forecast'!$F63,'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($E63=\"$millions\",1000000,IF($E63=\"$000\",1000,1))","v":0}]
[null,null,{"$f":"'Input|Step changes'!C22","v":0},"Calculated","$millions","2018-19",null,null,null,{"$f":"'Input|Step changes'!J22*IF('Input|Step changes'!$F22=\"nominal\",LOOKUP($F64,Nominal_to_Real,'Input|Rate of change'!K$26:K$32),INDEX('Input|Rate of change'!$C$14:$O$22,MATCH('Input|Step changes'!$F22,'Input|Rate of change'!$C$14:$C$22,0),MATCH('Calc|Opex forecast'!$F64,'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($E64=\"$millions\",1000000,IF($E64=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!K22*IF('Input|Step changes'!$F22=\"nominal\",LOOKUP($F64,Nominal_to_Real,'Input|Rate of change'!L$26:L$32),INDEX('Input|Rate of change'!$C$14:$O$22,MATCH('Input|Step changes'!$F22,'Input|Rate of change'!$C$14:$C$22,0),MATCH('Calc|Opex forecast'!$F64,'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($E64=\"$millions\",1000000,IF($E64=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!L22*IF('Input|Step changes'!$F22=\"nominal\",LOOKUP($F64,Nominal_to_Real,'Input|Rate of change'!M$26:M$32),INDEX('Input|Rate of change'!$C$14:$O$22,MATCH('Input|Step changes'!$F22,'Input|Rate of change'!$C$14:$C$22,0),MATCH('Calc|Opex forecast'!$F64,'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($E64=\"$millions\",1000000,IF($E64=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!M22*IF('Input|Step changes'!$F22=\"nominal\",LOOKUP($F64,Nominal_to_Real,'Input|Rate of change'!N$26:N$32),INDEX('Input|Rate of change'!$C$14:$O$22,MATCH('Input|Step changes'!$F22,'Input|Rate of change'!$C$14:$C$22,0),MATCH('Calc|Opex forecast'!$F64,'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($E64=\"$millions\",1000000,IF($E64=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!N22*IF('Input|Step changes'!$F22=\"nominal\",LOOKUP($F64,Nominal_to_Real,'Input|Rate of change'!O$26:O$32),INDEX('Input|Rate of change'!$C$14:$O$22,MATCH('Input|Step changes'!$F22,'Input|Rate of change'!$C$14:$C$22,0),MATCH('Calc|Opex forecast'!$F64,'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($E64=\"$millions\",1000000,IF($E64=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!O22*IF('Input|Step changes'!$F22=\"nominal\",LOOKUP($F64,Nominal_to_Real,'Input|Rate of change'!P$26:P$32),INDEX('Input|Rate of change'!$C$14:$O$22,MATCH('Input|Step changes'!$F22,'Input|Rate of change'!$C$14:$C$22,0),MATCH('Calc|Opex forecast'!$F64,'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($E64=\"$millions\",1000000,IF($E64=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!P22*IF('Input|Step changes'!$F22=\"nominal\",LOOKUP($F64,Nominal_to_Real,'Input|Rate of change'!Q$26:Q$32),INDEX('Input|Rate of change'!$C$14:$O$22,MATCH('Input|Step changes'!$F22,'Input|Rate of change'!$C$14:$C$22,0),MATCH('Calc|Opex forecast'!$F64,'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($E64=\"$millions\",1000000,IF($E64=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!Q22*IF('Input|Step changes'!$F22=\"nominal\",LOOKUP($F64,Nominal_to_Real,'Input|Rate of change'!R$26:R$32),INDEX('Input|Rate of change'!$C$14:$O$22,MATCH('Input|Step changes'!$F22,'Input|Rate of change'!$C$14:$C$22,0),MATCH('Calc|Opex forecast'!$F64,'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($E64=\"$millions\",1000000,IF($E64=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!R22*IF('Input|Step changes'!$F22=\"nominal\",LOOKUP($F64,Nominal_to_Real,'Input|Rate of change'!S$26:S$32),INDEX('Input|Rate of change'!$C$14:$O$22,MATCH('Input|Step changes'!$F22,'Input|Rate of change'!$C$14:$C$22,0),MATCH('Calc|Opex forecast'!$F64,'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($E64=\"$millions\",1000000,IF($E64=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!S22*IF('Input|Step changes'!$F22=\"nominal\",LOOKUP($F64,Nominal_to_Real,'Input|Rate of change'!T$26:T$32),INDEX('Input|Rate of change'!$C$14:$O$22,MATCH('Input|Step changes'!$F22,'Input|Rate of change'!$C$14:$C$22,0),MATCH('Calc|Opex forecast'!$F64,'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($E64=\"$millions\",1000000,IF($E64=\"$000\",1000,1))","v":0}]
[null,null,{"$f":"'Input|Step changes'!C23","v":0},"Calculated","$millions","2018-19",null,null,null,{"$f":"'Input|Step changes'!J23*IF('Input|Step changes'!$F23=\"nominal\",LOOKUP($F65,Nominal_to_Real,'Input|Rate of change'!K$26:K$32),INDEX('Input|Rate of change'!$C$14:$O$22,MATCH('Input|Step changes'!$F23,'Input|Rate of change'!$C$14:$C$22,0),MATCH('Calc|Opex forecast'!$F65,'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($E65=\"$millions\",1000000,IF($E65=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!K23*IF('Input|Step changes'!$F23=\"nominal\",LOOKUP($F65,Nominal_to_Real,'Input|Rate of change'!L$26:L$32),INDEX('Input|Rate of change'!$C$14:$O$22,MATCH('Input|Step changes'!$F23,'Input|Rate of change'!$C$14:$C$22,0),MATCH('Calc|Opex forecast'!$F65,'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($E65=\"$millions\",1000000,IF($E65=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!L23*IF('Input|Step changes'!$F23=\"nominal\",LOOKUP($F65,Nominal_to_Real,'Input|Rate of change'!M$26:M$32),INDEX('Input|Rate of change'!$C$14:$O$22,MATCH('Input|Step changes'!$F23,'Input|Rate of change'!$C$14:$C$22,0),MATCH('Calc|Opex forecast'!$F65,'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($E65=\"$millions\",1000000,IF($E65=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!M23*IF('Input|Step changes'!$F23=\"nominal\",LOOKUP($F65,Nominal_to_Real,'Input|Rate of change'!N$26:N$32),INDEX('Input|Rate of change'!$C$14:$O$22,MATCH('Input|Step changes'!$F23,'Input|Rate of change'!$C$14:$C$22,0),MATCH('Calc|Opex forecast'!$F65,'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($E65=\"$millions\",1000000,IF($E65=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!N23*IF('Input|Step changes'!$F23=\"nominal\",LOOKUP($F65,Nominal_to_Real,'Input|Rate of change'!O$26:O$32),INDEX('Input|Rate of change'!$C$14:$O$22,MATCH('Input|Step changes'!$F23,'Input|Rate of change'!$C$14:$C$22,0),MATCH('Calc|Opex forecast'!$F65,'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($E65=\"$millions\",1000000,IF($E65=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!O23*IF('Input|Step changes'!$F23=\"nominal\",LOOKUP($F65,Nominal_to_Real,'Input|Rate of change'!P$26:P$32),INDEX('Input|Rate of change'!$C$14:$O$22,MATCH('Input|Step changes'!$F23,'Input|Rate of change'!$C$14:$C$22,0),MATCH('Calc|Opex forecast'!$F65,'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($E65=\"$millions\",1000000,IF($E65=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!P23*IF('Input|Step changes'!$F23=\"nominal\",LOOKUP($F65,Nominal_to_Real,'Input|Rate of change'!Q$26:Q$32),INDEX('Input|Rate of change'!$C$14:$O$22,MATCH('Input|Step changes'!$F23,'Input|Rate of change'!$C$14:$C$22,0),MATCH('Calc|Opex forecast'!$F65,'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($E65=\"$millions\",1000000,IF($E65=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!Q23*IF('Input|Step changes'!$F23=\"nominal\",LOOKUP($F65,Nominal_to_Real,'Input|Rate of change'!R$26:R$32),INDEX('Input|Rate of change'!$C$14:$O$22,MATCH('Input|Step changes'!$F23,'Input|Rate of change'!$C$14:$C$22,0),MATCH('Calc|Opex forecast'!$F65,'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($E65=\"$millions\",1000000,IF($E65=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!R23*IF('Input|Step changes'!$F23=\"nominal\",LOOKUP($F65,Nominal_to_Real,'Input|Rate of change'!S$26:S$32),INDEX('Input|Rate of change'!$C$14:$O$22,MATCH('Input|Step changes'!$F23,'Input|Rate of change'!$C$14:$C$22,0),MATCH('Calc|Opex forecast'!$F65,'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($E65=\"$millions\",1000000,IF($E65=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!S23*IF('Input|Step changes'!$F23=\"nominal\",LOOKUP($F65,Nominal_to_Real,'Input|Rate of change'!T$26:T$32),INDEX('Input|Rate of change'!$C$14:$O$22,MATCH('Input|Step changes'!$F23,'Input|Rate of change'!$C$14:$C$22,0),MATCH('Calc|Opex forecast'!$F65,'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($E65=\"$millions\",1000000,IF($E65=\"$000\",1000,1))","v":0}]
[]
[null,null,"Total step changes","Calculated",{"$f":"$E$8","v":"$millions"},{"$f":"$F$8","v":"2018-19"},null,null,null,{"$f":"SUM(J54:J66)","v":0},{"$f":"SUM(K54:K66)","v":0},0,0,0,{"$f":"SUM(O54:O66)","v":5.1799555936416315},5.1799555936416315,6.5155021133881581,6.5572013269138418,5.6919426462558942]
[]
[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":""},{"$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":""},{"$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":""},{"$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":"2022-23"},{"$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":"2023-24"}]
[]
[null,null,"Total forecast opex, excluding debt raising costs","Calculated",{"$f":"$E$8","v":"$millions"},{"$f":"$F$8","v":"2018-19"},null,null,null,{"$f":"J13","v":0},0,0,{"$f":"M13","v":440.20365746184808},{"$f":"N35","v":452.23217132103247},{"$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(O71),\"\",PRODUCT(1+$J48:O48)*SUM($J35:$S35)+O67),\"\"),\"\")","v":463.17589637431308},{"$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(P71),\"\",PRODUCT(1+$J48:P48)*SUM($J35:$S35)+P67),\"\"),\"\")","v":470.83575202131203},{"$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(Q71),\"\",PRODUCT(1+$J48:Q48)*SUM($J35:$S35)+Q67),\"\"),\"\")","v":481.01421902187792},{"$f":"IF(RIGHT(R$4,2)>=RIGHT('Input|General'!$G$11,2),IF(RIGHT(R$4,2)<=RIGHT('Input|General'!$G$12,2),IF(ISBLANK(R71),\"\",PRODUCT(1+$J48:R48)*SUM($J35:$S35)+R67),\"\"),\"\")","v":490.01058312139384},{"$f":"IF(RIGHT(S$4,2)>=RIGHT('Input|General'!$G$11,2),IF(RIGHT(S$4,2)<=RIGHT('Input|General'!$G$12,2),IF(ISBLANK(S71),\"\",PRODUCT(1+$J48:S48)*SUM($J35:$S35)+S67),\"\"),\"\")","v":497.29021010218287}]
[]
[null,null,"Total forecast opex, ex DRC, distribution","Calculated",{"$f":"$E$8","v":"$millions"},{"$f":"$F$8","v":"2018-19"},null,null,null,null,null,null,null,null,{"$f":"O$73*'Input|Dx Tx split'!O12","v":427.52412463372019},{"$f":"P$73*'Input|Dx Tx split'!P12","v":434.59438261980802},{"$f":"Q$73*'Input|Dx Tx split'!Q12","v":443.98938833706035},{"$f":"R$73*'Input|Dx Tx split'!R12","v":452.29328047963315},{"$f":"S$73*'Input|Dx Tx split'!S12","v":459.0125769218356}]
[null,null,"Total forecast opex, ex, DRC, transmission","Calculated",{"$f":"$E$8","v":"$millions"},{"$f":"$F$8","v":"2018-19"},null,null,null,null,null,null,null,null,{"$f":"O$73*'Input|Dx Tx split'!O13","v":35.651771740592977},{"$f":"P$73*'Input|Dx Tx split'!P13","v":36.24136940150408},{"$f":"Q$73*'Input|Dx Tx split'!Q13","v":37.024830684817651},{"$f":"R$73*'Input|Dx Tx split'!R13","v":37.717302641760782},{"$f":"S$73*'Input|Dx Tx split'!S13","v":38.277633180347387}]
[]
[null,null,"Total forecast opex, including debt raising costs","Calculated",{"$f":"$E$8","v":"$millions"},{"$f":"$F$8","v":"2018-19"},null,null,null,null,null,null,null,null,{"$f":"O73+'Input|Step changes'!O29+'Input|Step changes'!O30","v":471.07963528381254},{"$f":"P73+'Input|Step changes'!P29+'Input|Step changes'!P30","v":478.85379871617084},{"$f":"Q73+'Input|Step changes'!Q29+'Input|Step changes'!Q30","v":489.08299738554291},{"$f":"R73+'Input|Step changes'!R29+'Input|Step changes'!R30","v":498.10925118561579},{"$f":"S73+'Input|Step changes'!S29+'Input|Step changes'!S30","v":505.40518057251751}]
[]
[null,null,"Total forecast opex, incl DRC, distribution","Calculated",{"$f":"$E$8","v":"$millions"},{"$f":"$F$8","v":"2018-19"},null,null,null,null,null,null,null,null,{"$f":"O75+'Input|Step changes'!O29","v":434.46456727015095},{"$f":"P75+'Input|Step changes'!P29","v":441.63683371006817},{"$f":"Q75+'Input|Step changes'!Q29","v":451.08108306402391},{"$f":"R75+'Input|Step changes'!R29","v":459.40627417684323},{"$f":"S75+'Input|Step changes'!S29","v":466.12449256592055}]
[null,null,"Total forecast opex, incl DRC, transmission","Calculated",{"$f":"$E$8","v":"$millions"},{"$f":"$F$8","v":"2018-19"},null,null,null,null,null,null,null,null,{"$f":"O76+'Input|Step changes'!O30","v":36.615068013661684},{"$f":"P76+'Input|Step changes'!P30","v":37.21696500610274},{"$f":"Q76+'Input|Step changes'!Q30","v":38.001914321519074},{"$f":"R76+'Input|Step changes'!R30","v":38.702977008772685},{"$f":"S76+'Input|Step changes'!S30","v":39.280688006597053}]
[]
[null,"End"]

{"sheet":"Output|Models","index":9,"n_rows":17,"n_cols":22,"rows_kept":17,"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$9:$XFD$17)=COUNTIF($W$9:$W$17,\"OK\"),\"OK\",\"Check\")","v":"OK"},null,"Overall Check:",{"$f":"'Check|List'!$S$1","v":"Ok"}]
[null,{"$f":"Index!$C$14","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,1,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":"2022-23"},{"$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":"2023-24"}]
[]
[]
[]
[null,"Inputs for Post Tax Revenue Model",null,null,"$millions","2018-19",null,null,null,"Note. The dollar base should be consistent with the post tax revenue model"]
[]
[]
[null,null,"Forecast operating expenditure (excl. DRC)","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":""},{"$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":""},{"$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":"2022-23"},{"$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":"2023-24"},null,"Notes"]
[null,null,"Distribution","Calc | Opex forecast",{"$f":"$E$8","v":"$millions"},{"$f":"$F$8","v":"2018-19"},null,null,null,{"$f":"IF(J11=\"\",0,'Calc|Opex forecast'!J75*IF('Calc|Opex forecast'!$F$75=\"nominal\",LOOKUP($F12,Nominal_to_Real,'Input|Rate of change'!K$26:K$32),INDEX('Input|Rate of change'!$C$14:$O$22,MATCH('Calc|Opex forecast'!$F$75,'Input|Rate of change'!$C$14:$C$22,0),MATCH('Output|Models'!$F12,'Input|Rate of change'!$C$14:$O$14,0)))*IF('Calc|Opex forecast'!$E$75=\"$millions\",1000000,IF($E$12=\"$000\",1000,1))/IF($E12=\"$millions\",1000000,IF($E12=\"$000\",1000,1)))","v":0},{"$f":"IF(K11=\"\",0,'Calc|Opex forecast'!K75*IF('Calc|Opex forecast'!$F$75=\"nominal\",LOOKUP($F12,Nominal_to_Real,'Input|Rate of change'!L$26:L$32),INDEX('Input|Rate of change'!$C$14:$O$22,MATCH('Calc|Opex forecast'!$F$75,'Input|Rate of change'!$C$14:$C$22,0),MATCH('Output|Models'!$F12,'Input|Rate of change'!$C$14:$O$14,0)))*IF('Calc|Opex forecast'!$E$75=\"$millions\",1000000,IF($E$12=\"$000\",1000,1))/IF($E12=\"$millions\",1000000,IF($E12=\"$000\",1000,1)))","v":0},{"$f":"IF(L11=\"\",0,'Calc|Opex forecast'!L75*IF('Calc|Opex forecast'!$F$75=\"nominal\",LOOKUP($F12,Nominal_to_Real,'Input|Rate of change'!M$26:M$32),INDEX('Input|Rate of change'!$C$14:$O$22,MATCH('Calc|Opex forecast'!$F$75,'Input|Rate of change'!$C$14:$C$22,0),MATCH('Output|Models'!$F12,'Input|Rate of change'!$C$14:$O$14,0)))*IF('Calc|Opex forecast'!$E$75=\"$millions\",1000000,IF($E$12=\"$000\",1000,1))/IF($E12=\"$millions\",1000000,IF($E12=\"$000\",1000,1)))","v":0},{"$f":"IF(M11=\"\",0,'Calc|Opex forecast'!M75*IF('Calc|Opex forecast'!$F$75=\"nominal\",LOOKUP($F12,Nominal_to_Real,'Input|Rate of change'!N$26:N$32),INDEX('Input|Rate of change'!$C$14:$O$22,MATCH('Calc|Opex forecast'!$F$75,'Input|Rate of change'!$C$14:$C$22,0),MATCH('Output|Models'!$F12,'Input|Rate of change'!$C$14:$O$14,0)))*IF('Calc|Opex forecast'!$E$75=\"$millions\",1000000,IF($E$12=\"$000\",1000,1))/IF($E12=\"$millions\",1000000,IF($E12=\"$000\",1000,1)))","v":0},{"$f":"IF(N11=\"\",0,'Calc|Opex forecast'!N75*IF('Calc|Opex forecast'!$F$75=\"nominal\",LOOKUP($F12,Nominal_to_Real,'Input|Rate of change'!O$26:O$32),INDEX('Input|Rate of change'!$C$14:$O$22,MATCH('Calc|Opex forecast'!$F$75,'Input|Rate of change'!$C$14:$C$22,0),MATCH('Output|Models'!$F12,'Input|Rate of change'!$C$14:$O$14,0)))*IF('Calc|Opex forecast'!$E$75=\"$millions\",1000000,IF($E$12=\"$000\",1000,1))/IF($E12=\"$millions\",1000000,IF($E12=\"$000\",1000,1)))","v":0},{"$f":"IF(O11=\"\",0,'Calc|Opex forecast'!O75*IF('Calc|Opex forecast'!$F$75=\"nominal\",LOOKUP($F12,Nominal_to_Real,'Input|Rate of change'!P$26:P$32),INDEX('Input|Rate of change'!$C$14:$O$22,MATCH('Calc|Opex forecast'!$F$75,'Input|Rate of change'!$C$14:$C$22,0),MATCH('Output|Models'!$F12,'Input|Rate of change'!$C$14:$O$14,0)))*IF('Calc|Opex forecast'!$E$75=\"$millions\",1000000,IF($E$12=\"$000\",1000,1))/IF($E12=\"$millions\",1000000,IF($E12=\"$000\",1000,1)))","v":427.52412463372019},{"$f":"IF(P11=\"\",0,'Calc|Opex forecast'!P75*IF('Calc|Opex forecast'!$F$75=\"nominal\",LOOKUP($F12,Nominal_to_Real,'Input|Rate of change'!Q$26:Q$32),INDEX('Input|Rate of change'!$C$14:$O$22,MATCH('Calc|Opex forecast'!$F$75,'Input|Rate of change'!$C$14:$C$22,0),MATCH('Output|Models'!$F12,'Input|Rate of change'!$C$14:$O$14,0)))*IF('Calc|Opex forecast'!$E$75=\"$millions\",1000000,IF($E$12=\"$000\",1000,1))/IF($E12=\"$millions\",1000000,IF($E12=\"$000\",1000,1)))","v":434.59438261980802},{"$f":"IF(Q11=\"\",0,'Calc|Opex forecast'!Q75*IF('Calc|Opex forecast'!$F$75=\"nominal\",LOOKUP($F12,Nominal_to_Real,'Input|Rate of change'!R$26:R$32),INDEX('Input|Rate of change'!$C$14:$O$22,MATCH('Calc|Opex forecast'!$F$75,'Input|Rate of change'!$C$14:$C$22,0),MATCH('Output|Models'!$F12,'Input|Rate of change'!$C$14:$O$14,0)))*IF('Calc|Opex forecast'!$E$75=\"$millions\",1000000,IF($E$12=\"$000\",1000,1))/IF($E12=\"$millions\",1000000,IF($E12=\"$000\",1000,1)))","v":443.98938833706035},{"$f":"IF(R11=\"\",0,'Calc|Opex forecast'!R75*IF('Calc|Opex forecast'!$F$75=\"nominal\",LOOKUP($F12,Nominal_to_Real,'Input|Rate of change'!S$26:S$32),INDEX('Input|Rate of change'!$C$14:$O$22,MATCH('Calc|Opex forecast'!$F$75,'Input|Rate of change'!$C$14:$C$22,0),MATCH('Output|Models'!$F12,'Input|Rate of change'!$C$14:$O$14,0)))*IF('Calc|Opex forecast'!$E$75=\"$millions\",1000000,IF($E$12=\"$000\",1000,1))/IF($E12=\"$millions\",1000000,IF($E12=\"$000\",1000,1)))","v":452.29328047963315},{"$f":"IF(S11=\"\",0,'Calc|Opex forecast'!S75*IF('Calc|Opex forecast'!$F$75=\"nominal\",LOOKUP($F12,Nominal_to_Real,'Input|Rate of change'!T$26:T$32),INDEX('Input|Rate of change'!$C$14:$O$22,MATCH('Calc|Opex forecast'!$F$75,'Input|Rate of change'!$C$14:$C$22,0),MATCH('Output|Models'!$F12,'Input|Rate of change'!$C$14:$O$14,0)))*IF('Calc|Opex forecast'!$E$75=\"$millions\",1000000,IF($E$12=\"$000\",1000,1))/IF($E12=\"$millions\",1000000,IF($E12=\"$000\",1000,1)))","v":459.0125769218356}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(O12:S12)","v":2217.4137529920572}]
[null,null,"Transmission","Calc | Opex forecast",{"$f":"$E$8","v":"$millions"},{"$f":"$F$8","v":"2018-19"},null,null,null,{"$f":"IF(J11=\"\",0,'Calc|Opex forecast'!J76*IF('Calc|Opex forecast'!$F$76=\"nominal\",LOOKUP($F12,Nominal_to_Real,'Input|Rate of change'!K$26:K$32),INDEX('Input|Rate of change'!$C$14:$O$22,MATCH('Calc|Opex forecast'!$F$76,'Input|Rate of change'!$C$14:$C$22,0),MATCH('Output|Models'!$F12,'Input|Rate of change'!$C$14:$O$14,0)))*IF('Calc|Opex forecast'!$E$76=\"$millions\",1000000,IF($E$14=\"$000\",1000,1))/IF($E12=\"$millions\",1000000,IF($E14=\"$000\",1000,1)))","v":0},{"$f":"IF(K11=\"\",0,'Calc|Opex forecast'!K76*IF('Calc|Opex forecast'!$F$76=\"nominal\",LOOKUP($F12,Nominal_to_Real,'Input|Rate of change'!L$26:L$32),INDEX('Input|Rate of change'!$C$14:$O$22,MATCH('Calc|Opex forecast'!$F$76,'Input|Rate of change'!$C$14:$C$22,0),MATCH('Output|Models'!$F12,'Input|Rate of change'!$C$14:$O$14,0)))*IF('Calc|Opex forecast'!$E$76=\"$millions\",1000000,IF($E$14=\"$000\",1000,1))/IF($E12=\"$millions\",1000000,IF($E14=\"$000\",1000,1)))","v":0},{"$f":"IF(L11=\"\",0,'Calc|Opex forecast'!L76*IF('Calc|Opex forecast'!$F$76=\"nominal\",LOOKUP($F12,Nominal_to_Real,'Input|Rate of change'!M$26:M$32),INDEX('Input|Rate of change'!$C$14:$O$22,MATCH('Calc|Opex forecast'!$F$76,'Input|Rate of change'!$C$14:$C$22,0),MATCH('Output|Models'!$F12,'Input|Rate of change'!$C$14:$O$14,0)))*IF('Calc|Opex forecast'!$E$76=\"$millions\",1000000,IF($E$14=\"$000\",1000,1))/IF($E12=\"$millions\",1000000,IF($E14=\"$000\",1000,1)))","v":0},{"$f":"IF(M11=\"\",0,'Calc|Opex forecast'!M76*IF('Calc|Opex forecast'!$F$76=\"nominal\",LOOKUP($F12,Nominal_to_Real,'Input|Rate of change'!N$26:N$32),INDEX('Input|Rate of change'!$C$14:$O$22,MATCH('Calc|Opex forecast'!$F$76,'Input|Rate of change'!$C$14:$C$22,0),MATCH('Output|Models'!$F12,'Input|Rate of change'!$C$14:$O$14,0)))*IF('Calc|Opex forecast'!$E$76=\"$millions\",1000000,IF($E$14=\"$000\",1000,1))/IF($E12=\"$millions\",1000000,IF($E14=\"$000\",1000,1)))","v":0},{"$f":"IF(N11=\"\",0,'Calc|Opex forecast'!N76*IF('Calc|Opex forecast'!$F$76=\"nominal\",LOOKUP($F12,Nominal_to_Real,'Input|Rate of change'!O$26:O$32),INDEX('Input|Rate of change'!$C$14:$O$22,MATCH('Calc|Opex forecast'!$F$76,'Input|Rate of change'!$C$14:$C$22,0),MATCH('Output|Models'!$F12,'Input|Rate of change'!$C$14:$O$14,0)))*IF('Calc|Opex forecast'!$E$76=\"$millions\",1000000,IF($E$14=\"$000\",1000,1))/IF($E12=\"$millions\",1000000,IF($E14=\"$000\",1000,1)))","v":0},{"$f":"IF(O11=\"\",0,'Calc|Opex forecast'!O76*IF('Calc|Opex forecast'!$F$76=\"nominal\",LOOKUP($F12,Nominal_to_Real,'Input|Rate of change'!P$26:P$32),INDEX('Input|Rate of change'!$C$14:$O$22,MATCH('Calc|Opex forecast'!$F$76,'Input|Rate of change'!$C$14:$C$22,0),MATCH('Output|Models'!$F12,'Input|Rate of change'!$C$14:$O$14,0)))*IF('Calc|Opex forecast'!$E$76=\"$millions\",1000000,IF($E$14=\"$000\",1000,1))/IF($E12=\"$millions\",1000000,IF($E14=\"$000\",1000,1)))","v":35.651771740592977},{"$f":"IF(P11=\"\",0,'Calc|Opex forecast'!P76*IF('Calc|Opex forecast'!$F$76=\"nominal\",LOOKUP($F12,Nominal_to_Real,'Input|Rate of change'!Q$26:Q$32),INDEX('Input|Rate of change'!$C$14:$O$22,MATCH('Calc|Opex forecast'!$F$76,'Input|Rate of change'!$C$14:$C$22,0),MATCH('Output|Models'!$F12,'Input|Rate of change'!$C$14:$O$14,0)))*IF('Calc|Opex forecast'!$E$76=\"$millions\",1000000,IF($E$14=\"$000\",1000,1))/IF($E12=\"$millions\",1000000,IF($E14=\"$000\",1000,1)))","v":36.24136940150408},{"$f":"IF(Q11=\"\",0,'Calc|Opex forecast'!Q76*IF('Calc|Opex forecast'!$F$76=\"nominal\",LOOKUP($F12,Nominal_to_Real,'Input|Rate of change'!R$26:R$32),INDEX('Input|Rate of change'!$C$14:$O$22,MATCH('Calc|Opex forecast'!$F$76,'Input|Rate of change'!$C$14:$C$22,0),MATCH('Output|Models'!$F12,'Input|Rate of change'!$C$14:$O$14,0)))*IF('Calc|Opex forecast'!$E$76=\"$millions\",1000000,IF($E$14=\"$000\",1000,1))/IF($E12=\"$millions\",1000000,IF($E14=\"$000\",1000,1)))","v":37.024830684817651},{"$f":"IF(R11=\"\",0,'Calc|Opex forecast'!R76*IF('Calc|Opex forecast'!$F$76=\"nominal\",LOOKUP($F12,Nominal_to_Real,'Input|Rate of change'!S$26:S$32),INDEX('Input|Rate of change'!$C$14:$O$22,MATCH('Calc|Opex forecast'!$F$76,'Input|Rate of change'!$C$14:$C$22,0),MATCH('Output|Models'!$F12,'Input|Rate of change'!$C$14:$O$14,0)))*IF('Calc|Opex forecast'!$E$76=\"$millions\",1000000,IF($E$14=\"$000\",1000,1))/IF($E12=\"$millions\",1000000,IF($E14=\"$000\",1000,1)))","v":37.717302641760782},{"$f":"IF(S11=\"\",0,'Calc|Opex forecast'!S76*IF('Calc|Opex forecast'!$F$76=\"nominal\",LOOKUP($F12,Nominal_to_Real,'Input|Rate of change'!T$26:T$32),INDEX('Input|Rate of change'!$C$14:$O$22,MATCH('Calc|Opex forecast'!$F$76,'Input|Rate of change'!$C$14:$C$22,0),MATCH('Output|Models'!$F12,'Input|Rate of change'!$C$14:$O$14,0)))*IF('Calc|Opex forecast'!$E$76=\"$millions\",1000000,IF($E$14=\"$000\",1000,1))/IF($E12=\"$millions\",1000000,IF($E14=\"$000\",1000,1)))","v":38.277633180347379}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(O14:S14)","v":184.91290764902288}]
[]
[null,"End"]

{"sheet":"Lookup|Tables","index":10,"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$15","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,"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,null,"2024-25","AER",null,null,"2024-25"]
[null,null,"2025-26","AER",null,null,"2025-26"]
[null,null,"2026-27","AER",null,null,"2026-27"]
[null,null,"2027-28","AER",null,null,"2027-28"]
[null,null,"2028-29","AER",null,null,"2028-29"]
[]
[null,"End"]

{"sheet":"Check|List","index":11,"n_rows":19,"n_cols":19,"rows_kept":19,"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:G17,\"Check\")=0,\"Ok\",\"Check\")","v":"Ok"}]
[null,{"$f":"Index!$C$16","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!C8","v":"Input | Inflation"},{"$f":"C11","v":"Input | Inflation"},"Ok/Check",null,{"$f":"'Input|Inflation'!S1","v":"OK"}]
[null,null,{"$f":"Index!C9","v":"Input | Reported opex"},{"$f":"C12","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":"Input | Dx TX split"},{"$f":"C15","v":"Input | Dx TX split"},"Ok/Check",null,{"$f":"'Input|Dx Tx split'!S1","v":"OK"}]
[null,null,{"$f":"Index!C13","v":"Calc | Opex Forecast"},"Calc | Opex Forecast","Ok/Check",null,{"$f":"'Calc|Opex forecast'!S1","v":"n/a"}]
[null,null,{"$f":"Index!C14","v":"Output | Models"},"Output | Models","Ok/Check",null,{"$f":"'Output|Models'!S1","v":"OK"}]
[]
[null,"End"]