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

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

{"sheet":"Input|General","index":1,"n_rows":14,"n_cols":22,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
[null,{"$f":"Index!$B$1","v":"AER opex model"},null,null,null,null,null,null,null,"Back to Index",null,"Key:","Input","External Link","Internal Link",null,null,"Worksheet check:",{"$f":"IF(COUNTA($S$5:$S$13)=COUNTIF($S5:$S14,\"OK\"),\"OK\",\"Check\")","v":"OK"},null,"Overall Check:",{"$f":"'Check|List'!$S$1","v":"Ok"}]
[null,{"$f":"Index!$C$7","v":"Input | General"}]
[]
[null,"Input | General inputs"]
[]
[null,null,"Inputs","Source",null,null,"Value"]
[null,null,"NSP name","NSP",null,null,"TasNetworks",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,"2009-10",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,"2012-13",null,null,null,null,null,null,null,null,null,null,null,"Ok"]
[null,null,"Prior regulatory control period, last year","NSP",null,null,"2013-14",null,null,null,null,null,null,null,null,null,null,null,"Ok"]
[null,null,"Forecast regulatory control period, first year","NSP",null,null,"2014-15",null,null,null,null,null,null,null,null,null,null,null,"Ok"]
[null,null,"Forecast regulatory control period, last year","NSP",null,null,"2018-19",null,null,null,null,null,null,null,null,null,null,null,"Ok"]
[]
[null,"End"]

{"sheet":"Input|Inflation","index":2,"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$39)=COUNTIF($S5:$S40,\"OK\"),\"OK\",\"Check\")","v":"OK"},null,"Overall Check:",{"$f":"'Check|List'!$S$1","v":"Ok"}]
[null,{"$f":"Index!$C$7","v":"Input | General"}]
[]
[null,"Input | General inputs"]
[]
[null,null,null,"Index value, old base","Index value, new base","Index value, 15 month lag, old base","Index value, 15 month lag, new base"]
[null,null,"Source","ABS","ABS","Calculated","Calculated"]
[null,null,"Unit","index","index","index","index"]
[null,null,"2007-03-31",155.6,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTBLANK($D9),\"Check\",\"Ok\")","v":"Ok"}]
[null,null,"2007-06-30",157.5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ok"]
[null,null,"2007-09-30",158.6,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ok"]
[null,null,"2007-12-31",160.1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ok"]
[null,null,"2008-03-31",162.19999999999999,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ok"]
[null,null,"2008-06-30",164.6,null,{"$f":"D9","v":155.6},null,null,null,null,null,null,null,null,null,null,null,null,"Ok"]
[null,null,"2008-09-30",166.5,null,157.5,null,null,null,null,null,null,null,null,null,null,null,null,"Ok"]
[null,null,"2008-12-31",166,null,158.6,null,null,null,null,null,null,null,null,null,null,null,null,"Ok"]
[null,null,"2009-03-31",166.2,null,160.1,null,null,null,null,null,null,null,null,null,null,null,null,"Ok"]
[null,null,"2009-06-30",167,null,162.19999999999999,null,null,null,null,null,null,null,null,null,null,null,null,"Ok"]
[null,null,"2009-09-30",168.6,null,164.6,null,null,null,null,null,null,null,null,null,null,null,null,"Ok"]
[null,null,"2009-12-31",169.5,null,166.5,null,null,null,null,null,null,null,null,null,null,null,null,"Ok"]
[null,null,"2010-03-31",171,95.2,166,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTBLANK($D21:$E21),\"Check\",\"Ok\")","v":"Ok"}]
[null,null,"2010-06-30",172.1,95.8,166.2,null,null,null,null,null,null,null,null,null,null,null,null,"Ok"]
[null,null,"2010-09-30",173.3,96.5,167,null,null,null,null,null,null,null,null,null,null,null,null,"Ok"]
[null,null,"2010-12-31",174,96.9,168.6,null,null,null,null,null,null,null,null,null,null,null,null,"Ok"]
[null,null,"2011-03-31",176.7,98.3,169.5,null,null,null,null,null,null,null,null,null,null,null,null,"Ok"]
[null,null,"2011-06-30",178.3,99.2,171,95.2,null,null,null,null,null,null,null,null,null,null,null,"Ok"]
[null,null,"2011-09-30",179.4,99.8,172.1,95.8,null,null,null,null,null,null,null,null,null,null,null,"Ok"]
[null,null,"2011-12-31",179.4,99.8,173.3,96.5,null,null,null,null,null,null,null,null,null,null,null,"Ok"]
[null,null,"2012-03-31",179.5,99.9,174,96.9,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTBLANK($E29),\"Check\",\"Ok\")","v":"Ok"}]
[null,null,"2012-06-30",null,100.4,176.7,98.3,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTBLANK($E30),\"Check\",\"Ok\")","v":"Ok"}]
[null,null,"2012-09-30",null,101.8,178.3,99.2,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTBLANK($E31),\"Check\",\"Ok\")","v":"Ok"}]
[null,null,"2012-12-31",null,102,179.4,99.8,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTBLANK($E32),\"Check\",\"Ok\")","v":"Ok"}]
[null,null,"2013-03-31",null,102.4,179.4,99.8,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTBLANK($E33),\"Check\",\"Ok\")","v":"Ok"}]
[null,null,"2013-06-30",null,102.8,179.5,99.9,null,null,null,null,null,null,null,null,null,null,null,"Ok"]
[null,null,"2013-09-30",null,104,null,100.4,null,null,null,null,null,null,null,null,null,null,null,"Ok"]
[null,null,"2013-12-31",null,104.8,null,101.8,null,null,null,null,null,null,null,null,null,null,null,"Ok"]
[null,null,"2014-03-31",null,105.4,null,102,null,null,null,null,null,null,null,null,null,null,null,"Ok"]
[null,null,"2014-06-30",null,105.9,null,102.4,null,null,null,null,null,null,null,null,null,null,null,"Ok"]
[]
[null,"End"]

{"sheet":"Input|Reported opex","index":3,"n_rows":50,"n_cols":22,"rows_kept":50,"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$243)=COUNTIF($W$32:$W$243,\"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":"2009-10"},{"$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":"2010-11"},{"$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":"2011-12"},{"$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":"2012-13"},{"$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":"2013-14"},{"$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":"2014-15"},{"$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":"2015-16"},{"$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":"2016-17"},{"$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":"2017-18"},{"$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":"2018-19"}]
[]
[]
[]
[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":"2009-10"},{"$f":"IF(RIGHT(K$4,2)<=RIGHT('Input|General'!$G$10,2),'Input|Reported opex'!K$4,\"\")","v":"2010-11"},{"$f":"IF(RIGHT(L$4,2)<=RIGHT('Input|General'!$G$10,2),'Input|Reported opex'!L$4,\"\")","v":"2011-12"},{"$f":"IF(RIGHT(M$4,2)<=RIGHT('Input|General'!$G$10,2),'Input|Reported opex'!M$4,\"\")","v":"2012-13"},{"$f":"IF(RIGHT(N$4,2)<=RIGHT('Input|General'!$G$10,2),'Input|Reported opex'!N$4,\"\")","v":"2013-14"},{"$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":"2008-09"},null,null,null,49.65220216325293,50.34904599183222,49.970772560187733,52.330204816220522,52.014577162282215]
[null,null,"Remove network support costs","AER",{"$f":"$E$24","v":"$millions"},{"$f":"$F$24","v":"2008-09"},null,null,null,-3.9316328125000002,-2.6373046874999999,0,0,0]
[null,null,"Remove debt raising costs","AER","$millions","2008-09",null,null,null,-0.48465950565944449,-0.54375376786240825,-0.60011624162142274,-0.62433926198985168,-0.64865472536751445]
[null,null,null,"AER","$millions","2008-09"]
[null,null,null,"AER","$millions","2008-09"]
[null,null,null,"AER","$millions","2008-09"]
[null,null,null,"AER","$millions","2008-09"]
[null,null,null,"AER","$millions","2008-09"]
[null,null,null,"AER","$millions","2008-09"]
[null,null,null,"AER","$millions","2008-09"]
[]
[null,null,"Total opex","Calculated","$millions","2008-09",null,null,null,{"$f":"SUM(J13:J22)","v":45.235909845093488},47.167987536469816,49.370656318566311,51.70586555423067,51.365922436914701,0,0,0,0,0]
[]
[null,"Input | Reported opex"]
[]
[null,null,null,null,null,null,null,null,null,"Actual","Actual","Actual","Actual","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":"2009-10"},{"$f":"IF(RIGHT(K4,2)<=RIGHT('Input|General'!$G$10,2),'Input|Reported opex'!K4,\"\")","v":"2010-11"},{"$f":"IF(RIGHT(L4,2)<=RIGHT('Input|General'!$G$10,2),'Input|Reported opex'!L4,\"\")","v":"2011-12"},{"$f":"IF(RIGHT(M4,2)<=RIGHT('Input|General'!$G$10,2),'Input|Reported opex'!M4,\"\")","v":"2012-13"},{"$f":"IF(RIGHT(N4,2)<=RIGHT('Input|General'!$G$10,2),'Input|Reported opex'!N4,\"\")","v":"2013-14"},{"$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,47.779510000000002,46.557580000000002,46.923140000000004,44.976579999999998,45.682000000000002]
[null,null,"Remove network support costs","RIN",{"$f":"$E$43","v":"$millions"},{"$f":"$F$43","v":"nominal"},null,null,null,-3.75718,-2.4263599999999999,0,0,0]
[null,null,"Remove debt raising costs","RIN","$millions","nominal",null,null,null,0,0,0,0,0]
[null,null,"Remove movements in provisions","RIN","$millions","nominal",null,null,null,-0.99707100000000004,-0.29340199999999994,-1.296567,-0.16506800000000002,-0.62337399999999998]
[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":43.025259000000005},{"$f":"SUM(K32:K41)","v":43.837817999999999},45.626573,44.811512,45.058626000000004,0,0,0,0,0]
[]
[null,"Input | Efficiency adjustment"]
[]
[null,null,"Efficiency adjustment","Source","Unit"]
[null,null,"Efficiency adjustment","External","Per cent",null,null,null,null,0]
[]
[null,"End"]

{"sheet":"Input|Rate of change","index":4,"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":"2008-09"},{"$f":"'Input|General'!$G$8","v":"2009-10"},{"$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":"2010-11"},{"$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":"2011-12"},{"$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":"2012-13"},{"$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":"2013-14"},{"$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":"2014-15"},{"$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":"2015-16"},{"$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":"2016-17"},{"$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":"2017-18"},{"$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":"2018-19"}]
[]
[]
[]
[null,"Input | Inflation"]
[]
[null,null,"Inflation",null,null,null,null,null,null,{"$f":"J$4","v":"2008-09"},{"$f":"K$4","v":"2009-10"},{"$f":"L$4","v":"2010-11"},"2011-12","2012-13","2013-14","2014-15","2015-16","2016-17","2017-18","2018-19"]
[]
[null,null,"Inflation","calculated",{"$f":"percent","v":"Per cent"},null,null,null,null,{"$f":"'Input|Inflation'!F18/'Input|Inflation'!F14-1","v":4.2416452442159303E-2},{"$f":"'Input|Inflation'!F22/'Input|Inflation'!F18-1","v":2.4660912453760897E-2},{"$f":"'Input|Inflation'!F26/'Input|Inflation'!F22-1","v":2.8880866425992746E-2},{"$f":"'Input|Inflation'!F30/'Input|Inflation'!F26-1","v":3.3333333333333215E-2},{"$f":"'Input|Inflation'!F34/'Input|Inflation'!F30-1","v":1.5846066779853007E-2},{"$f":"'Input|Inflation'!G38/'Input|Inflation'!G34-1","v":2.5025025025025016E-2}]
[]
[null,null,"CPI indexes (real to real)",null,null,null,null,null,null,{"$f":"J$4","v":"2008-09"},{"$f":"K$4","v":"2009-10"},{"$f":"L4","v":"2010-11"},{"$f":"M4","v":"2011-12"},{"$f":"N4","v":"2012-13"},{"$f":"O4","v":"2013-14"}]
[]
[null,null,{"$f":"'Lookup|Tables'!C26","v":"2007-08"},"calculated","index",null,null,null,null,{"$f":"(1+J$12)","v":1.0424164524421593},{"$f":"J16*(1+K$12)","v":1.0681233933161953},1.0989717223650384,1.1356041131105394,1.1535989717223647,{"$f":"N16*(1+O$12)","v":1.1824678148585599}]
[null,null,{"$f":"'Lookup|Tables'!C27","v":"2008-09"},"calculated","index",null,null,null,null,1,{"$f":"J17*(1+K$12)","v":1.0246609124537609},1.0542540073982738,1.0893958076448829,1.1066584463625155,{"$f":"N17*(1+O$12)","v":1.1343526016768928}]
[null,null,{"$f":"'Lookup|Tables'!C28","v":"2009-10"},"calculated","index",null,null,null,null,{"$f":"K18/(1+K$12)","v":0.97593261131167253},1,{"$f":"K18*(1+L$12)","v":1.0288808664259927},{"$f":"L18*(1+M$12)","v":1.063176895306859},1.0800240673886883,1.1070516967027195]
[null,null,{"$f":"'Lookup|Tables'!C29","v":"2010-11"},"calculated","index",null,null,null,null,{"$f":"K19/(1+K$12)","v":0.94853801169590635},{"$f":"L19/(1+L$12)","v":0.97192982456140353},1,{"$f":"L19*(1+M$12)","v":1.0333333333333332},1.0497076023391814,1.0759765613566783]
[null,null,{"$f":"'Lookup|Tables'!C30","v":"2011-12"},"calculated","index",null,null,null,null,{"$f":"K20/(1+K$12)","v":0.91794001131861924},0.940577249575552,0.96774193548387111,1,{"$f":"M20*(1+N$12)","v":1.015846066779853},1.041267640022592]
[null,null,{"$f":"'Lookup|Tables'!C31","v":"2012-13"},"calculated","index",null,null,null,null,0.90362116991643437,0.92590529247910858,0.95264623955431749,0.98440111420612797,1,{"$f":"N21*(1+O$12)","v":1.025025025025025}]
[null,null,{"$f":"'Lookup|Tables'!C32","v":"2013-14"},"calculated","index",null,null,null,null,0.88156010619777148,0.90330018279944291,0.92938827472144847,0.96036788387882999,0.9755859375,1]
[]
[null,null,"CPI indexes (nominal to real)",null,null,null,null,null,null,{"$f":"J10","v":"2008-09"},"2009-10","2010-11","2011-12","2012-13","2013-14"]
[]
[null,null,{"$f":"C16","v":"2007-08"},"calculated","index",null,null,null,null,{"$f":"1/J16*(1+J$12)^0.5","v":0.97944346158994533},0.94769514987235492,0.92298794270968521,0.89514473726300969,0.87369347330660807,0.8562052875751498]
[null,null,"2008-09","calculated","index",null,null,null,null,1.0209879785982592,0.98789301612658054,0.96213781688631683,0.93311360143997502,0.91075245096614255,0.89252247843630605]
[null,null,"2009-10","calculated","index",null,null,null,null,1.0461664737548131,1.01225535931096,0.98586501335700294,0.95612503427449991,0.93321243742646676,0.91453289714003749]
[null,null,"2010-11","calculated","index",null,null,null,null,1.0763806679426777,1.0414901711322151,1.0143376491218261,0.98373875367592944,0.96016442117885559,0.94094539958451517]
[null,null,"2011-12","calculated","index",null,null,null,null,1.1122600235407667,1.0762065101699554,1.0481489040925536,1.0165300454651269,0.99216990188481735,0.9723102462373322]
[null,null,"2012-13","calculated","index",null,null,null,null,1.1298849701503548,1.0932601503990214,1.0647579416220339,1.0326380484492943,1.0078918924070444,0.98771753932994422]
[null,null,"2013-14","calculated","index",null,null,null,null,1.158160369803767,1.1206190130216194,1.0914035357567193,1.0584798414535308,1.0331144122370504,1.0124351954693322]
[]
[null,"Input | Forecast price change"]
[]
[null,null,"Forecast price change","Source","Unit",null,null,null,null,null,{"$f":"IF(RIGHT(K$4,2)>=RIGHT('Input|General'!$G$11,2),IF(RIGHT(K$4,2)<='Input|General'!$G$12,'Input|Reported opex'!J$4,\"\"),\"\")","v":""},{"$f":"IF(RIGHT(L$4,2)>=RIGHT('Input|General'!$G$11,2),IF(RIGHT(L$4,2)<='Input|General'!$G$12,'Input|Reported opex'!K$4,\"\"),\"\")","v":""},{"$f":"IF(RIGHT(M$4,2)>=RIGHT('Input|General'!$G$11,2),IF(RIGHT(M$4,2)<='Input|General'!$G$12,'Input|Reported opex'!L$4,\"\"),\"\")","v":""},{"$f":"IF(RIGHT(N$4,2)>=RIGHT('Input|General'!$G$11,2),IF(RIGHT(N$4,2)<='Input|General'!$G$12,'Input|Reported opex'!M$4,\"\"),\"\")","v":""},{"$f":"IF(RIGHT(O$4,2)>=RIGHT('Input|General'!$G$11,2),IF(RIGHT(O$4,2)<='Input|General'!$G$12,'Input|Reported opex'!N$4,\"\"),\"\")","v":""},{"$f":"IF(RIGHT(P$4,2)>=RIGHT('Input|General'!$G$11,2),IF(RIGHT(P$4,2)<='Input|General'!$G$12,'Input|Reported opex'!O$4,\"\"),\"\")","v":"2014-15"},{"$f":"IF(RIGHT(Q$4,2)>=RIGHT('Input|General'!$G$11,2),IF(RIGHT(Q$4,2)<='Input|General'!$G$12,'Input|Reported opex'!P$4,\"\"),\"\")","v":"2015-16"},{"$f":"IF(RIGHT(R$4,2)>=RIGHT('Input|General'!$G$11,2),IF(RIGHT(R$4,2)<='Input|General'!$G$12,'Input|Reported opex'!Q$4,\"\"),\"\")","v":"2016-17"},{"$f":"IF(RIGHT(S$4,2)>=RIGHT('Input|General'!$G$11,2),IF(RIGHT(S$4,2)<='Input|General'!$G$12,'Input|Reported opex'!R$4,\"\"),\"\")","v":"2017-18"},{"$f":"IF(RIGHT(T$4,2)>=RIGHT('Input|General'!$G$11,2),IF(RIGHT(T$4,2)<='Input|General'!$G$12,'Input|Reported opex'!S$4,\"\"),\"\")","v":"2018-19"}]
[]
[null,null,"WPI","external",{"$f":"percent","v":"Per cent"},null,null,null,null,null,null,null,null,null,null,8.5723317197846614E-3,9.2985951292731111E-3,1.2241700203787174E-2,1.4693943941458173E-2,1.416602249884252E-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,null,0,0,0,0,0]
[]
[null,null,"Weights","Source","Unit",null,null,null,null,null,{"$f":"IF(RIGHT(K$4,2)>=RIGHT('Input|General'!$G$11,2),IF(RIGHT(K$4,2)<='Input|General'!$G$12,'Input|Reported opex'!J$4,\"\"),\"\")","v":""},{"$f":"IF(RIGHT(L$4,2)>=RIGHT('Input|General'!$G$11,2),IF(RIGHT(L$4,2)<='Input|General'!$G$12,'Input|Reported opex'!K$4,\"\"),\"\")","v":""},{"$f":"IF(RIGHT(M$4,2)>=RIGHT('Input|General'!$G$11,2),IF(RIGHT(M$4,2)<='Input|General'!$G$12,'Input|Reported opex'!L$4,\"\"),\"\")","v":""},{"$f":"IF(RIGHT(N$4,2)>=RIGHT('Input|General'!$G$11,2),IF(RIGHT(N$4,2)<='Input|General'!$G$12,'Input|Reported opex'!M$4,\"\"),\"\")","v":""},{"$f":"IF(RIGHT(O$4,2)>=RIGHT('Input|General'!$G$11,2),IF(RIGHT(O$4,2)<='Input|General'!$G$12,'Input|Reported opex'!N$4,\"\"),\"\")","v":""},{"$f":"IF(RIGHT(P$4,2)>=RIGHT('Input|General'!$G$11,2),IF(RIGHT(P$4,2)<='Input|General'!$G$12,'Input|Reported opex'!O$4,\"\"),\"\")","v":"2014-15"},{"$f":"IF(RIGHT(Q$4,2)>=RIGHT('Input|General'!$G$11,2),IF(RIGHT(Q$4,2)<='Input|General'!$G$12,'Input|Reported opex'!P$4,\"\"),\"\")","v":"2015-16"},{"$f":"IF(RIGHT(R$4,2)>=RIGHT('Input|General'!$G$11,2),IF(RIGHT(R$4,2)<='Input|General'!$G$12,'Input|Reported opex'!Q$4,\"\"),\"\")","v":"2016-17"},{"$f":"IF(RIGHT(S$4,2)>=RIGHT('Input|General'!$G$11,2),IF(RIGHT(S$4,2)<='Input|General'!$G$12,'Input|Reported opex'!R$4,\"\"),\"\")","v":"2017-18"},{"$f":"IF(RIGHT(T$4,2)>=RIGHT('Input|General'!$G$11,2),IF(RIGHT(T$4,2)<='Input|General'!$G$12,'Input|Reported opex'!S$4,\"\"),\"\")","v":"2018-19"}]
[]
[null,null,{"$f":"C38","v":"WPI"},"external",{"$f":"percent","v":"Per cent"},null,null,null,null,null,null,null,null,null,null,0.62,0.62,0.62,0.62,0.62]
[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,null,0.38,0.38,0.38,0.38,0.38]
[]
[null,null,"Check","calculated","Ok/Check","n/a",null,null,null,null,null,null,null,null,null,{"$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$11,2),IF(RIGHT(K$4,2)<='Input|General'!$G$12,'Input|Reported opex'!J$4,\"\"),\"\")","v":""},{"$f":"IF(RIGHT(L$4,2)>=RIGHT('Input|General'!$G$11,2),IF(RIGHT(L$4,2)<='Input|General'!$G$12,'Input|Reported opex'!K$4,\"\"),\"\")","v":""},{"$f":"IF(RIGHT(M$4,2)>=RIGHT('Input|General'!$G$11,2),IF(RIGHT(M$4,2)<='Input|General'!$G$12,'Input|Reported opex'!L$4,\"\"),\"\")","v":""},{"$f":"IF(RIGHT(N$4,2)>=RIGHT('Input|General'!$G$11,2),IF(RIGHT(N$4,2)<='Input|General'!$G$12,'Input|Reported opex'!M$4,\"\"),\"\")","v":""},{"$f":"IF(RIGHT(O$4,2)>=RIGHT('Input|General'!$G$10,2),IF(RIGHT(O$4,2)<='Input|General'!$G$12,'Input|Reported opex'!N$4,\"\"),\"\")","v":"2013-14"},{"$f":"IF(RIGHT(P$4,2)>=RIGHT('Input|General'!$G$10,2),IF(RIGHT(P$4,2)<='Input|General'!$G$12,'Input|Reported opex'!O$4,\"\"),\"\")","v":"2014-15"},{"$f":"IF(RIGHT(Q$4,2)>=RIGHT('Input|General'!$G$10,2),IF(RIGHT(Q$4,2)<='Input|General'!$G$12,'Input|Reported opex'!P$4,\"\"),\"\")","v":"2015-16"},{"$f":"IF(RIGHT(R$4,2)>=RIGHT('Input|General'!$G$10,2),IF(RIGHT(R$4,2)<='Input|General'!$G$12,'Input|Reported opex'!Q$4,\"\"),\"\")","v":"2016-17"},{"$f":"IF(RIGHT(S$4,2)>=RIGHT('Input|General'!$G$10,2),IF(RIGHT(S$4,2)<='Input|General'!$G$12,'Input|Reported opex'!R$4,\"\"),\"\")","v":"2017-18"},{"$f":"IF(RIGHT(T$4,2)>=RIGHT('Input|General'!$G$10,2),IF(RIGHT(T$4,2)<='Input|General'!$G$12,'Input|Reported opex'!S$4,\"\"),\"\")","v":"2018-19"}]
[]
[null,null,"Energy","external","number","n/a",null,null,null,null,null,null,null,null,13096.594000000001,13327,13385,13539,14066,14106]
[null,null,"Ratcheted maximum demand","external","number","n/a",null,null,null,null,null,null,null,null,2690.61,2690.61,2690.61,2690.61,2690.61,2707]
[null,null,"Weighted entry and exit connections","external","number","n/a",null,null,null,null,null,null,null,null,6061.55,6064.3,6069.8,6080.8,6300.8,6300.8]
[null,null,"Circuit length","external","number","n/a",null,null,null,null,null,null,null,null,3503.1949999999997,3503.2,3503.2,3503.2,3503.2,3503.2]
[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)<='Input|General'!$G$12,'Input|Reported opex'!J$4,\"\"),\"\")","v":""},{"$f":"IF(RIGHT(L$4,2)>=RIGHT('Input|General'!$G$11,2),IF(RIGHT(L$4,2)<='Input|General'!$G$12,'Input|Reported opex'!K$4,\"\"),\"\")","v":""},{"$f":"IF(RIGHT(M$4,2)>=RIGHT('Input|General'!$G$11,2),IF(RIGHT(M$4,2)<='Input|General'!$G$12,'Input|Reported opex'!L$4,\"\"),\"\")","v":""},{"$f":"IF(RIGHT(N$4,2)>=RIGHT('Input|General'!$G$11,2),IF(RIGHT(N$4,2)<='Input|General'!$G$12,'Input|Reported opex'!M$4,\"\"),\"\")","v":""},{"$f":"IF(RIGHT(O$4,2)>=RIGHT('Input|General'!$G$11,2),IF(RIGHT(O$4,2)<='Input|General'!$G$12,'Input|Reported opex'!N$4,\"\"),\"\")","v":""},{"$f":"IF(RIGHT(P$4,2)>=RIGHT('Input|General'!$G$11,2),IF(RIGHT(P$4,2)<='Input|General'!$G$12,'Input|Reported opex'!O$4,\"\"),\"\")","v":"2014-15"},{"$f":"IF(RIGHT(Q$4,2)>=RIGHT('Input|General'!$G$11,2),IF(RIGHT(Q$4,2)<='Input|General'!$G$12,'Input|Reported opex'!P$4,\"\"),\"\")","v":"2015-16"},{"$f":"IF(RIGHT(R$4,2)>=RIGHT('Input|General'!$G$11,2),IF(RIGHT(R$4,2)<='Input|General'!$G$12,'Input|Reported opex'!Q$4,\"\"),\"\")","v":"2016-17"},{"$f":"IF(RIGHT(S$4,2)>=RIGHT('Input|General'!$G$11,2),IF(RIGHT(S$4,2)<='Input|General'!$G$12,'Input|Reported opex'!R$4,\"\"),\"\")","v":"2017-18"},{"$f":"IF(RIGHT(T$4,2)>=RIGHT('Input|General'!$G$11,2),IF(RIGHT(T$4,2)<='Input|General'!$G$12,'Input|Reported opex'!S$4,\"\"),\"\")","v":"2018-19"},{"$f":"IF(RIGHT(U$4,2)>=RIGHT('Input|General'!$G$11,2),IF(RIGHT(U$4,2)<='Input|General'!$G$12,'Input|Reported opex'!T$4,\"\"),\"\")","v":""}]
[]
[null,null,{"$f":"C64","v":"Energy"},"calculated","number","n/a",null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(P64),\"\",LN(P64)-LN(O64))","v":1.7439856196343584E-2},{"$f":"IF(ISBLANK(Q64),\"\",LN(Q64)-LN(P64))","v":4.3426243747273219E-3},{"$f":"IF(ISBLANK(R64),\"\",LN(R64)-LN(Q64))","v":1.1439732540656777E-2},3.818612837285329E-2,2.8397009001608353E-3]
[null,null,{"$f":"C65","v":"Ratcheted maximum demand"},"calculated","number","n/a",null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(P65),\"\",LN(P65)-LN(O65))","v":0},0,0,0,6.0730769266372775E-3]
[null,null,"Weighted entry and exit connections","calculated","number","n/a",null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(P66),\"\",LN(P66)-LN(O66))","v":4.5357645808685731E-4},9.0653618754821252E-4,1.8106106702742153E-3,3.5540343192975499E-2,0]
[null,null,"Circuit length","calculated","number","n/a",null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(P67),\"\",LN(P67)-LN(O67))","v":1.4272675183946149E-6},0,0,0,0]
[null,null,0,"calculated","number","n/a",null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(P68),\"\",LN(P68)-LN(O68))","v":""},"","","",""]
[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":"Energy"},"external","number","n/a",null,null,null,null,null,null,null,null,null,0.214]
[null,null,{"$f":"C65","v":"Ratcheted maximum demand"},"external","number","n/a",null,null,null,null,null,null,null,null,null,0.221]
[null,null,"Weighted entry and exit connections","external","number","n/a",null,null,null,null,null,null,null,null,null,0.27800000000000002]
[null,null,"Circuit length","external","number","n/a",null,null,null,null,null,null,null,null,null,0.28699999999999998]
[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,null,null,{"$f":"IF(SUM(P82:P87)=1,\"Ok\",\"Check\")","v":"Ok"},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)<='Input|General'!$G$12,'Input|Reported opex'!J$4,\"\"),\"\")","v":""},{"$f":"IF(RIGHT(L$4,2)>=RIGHT('Input|General'!$G$11,2),IF(RIGHT(L$4,2)<='Input|General'!$G$12,'Input|Reported opex'!K$4,\"\"),\"\")","v":""},{"$f":"IF(RIGHT(M$4,2)>=RIGHT('Input|General'!$G$11,2),IF(RIGHT(M$4,2)<='Input|General'!$G$12,'Input|Reported opex'!L$4,\"\"),\"\")","v":""},{"$f":"IF(RIGHT(N$4,2)>=RIGHT('Input|General'!$G$11,2),IF(RIGHT(N$4,2)<='Input|General'!$G$12,'Input|Reported opex'!M$4,\"\"),\"\")","v":""},{"$f":"IF(RIGHT(O$4,2)>=RIGHT('Input|General'!$G$11,2),IF(RIGHT(O$4,2)<='Input|General'!$G$12,'Input|Reported opex'!N$4,\"\"),\"\")","v":""},{"$f":"IF(RIGHT(P$4,2)>=RIGHT('Input|General'!$G$11,2),IF(RIGHT(P$4,2)<='Input|General'!$G$12,'Input|Reported opex'!O$4,\"\"),\"\")","v":"2014-15"},{"$f":"IF(RIGHT(Q$4,2)>=RIGHT('Input|General'!$G$11,2),IF(RIGHT(Q$4,2)<='Input|General'!$G$12,'Input|Reported opex'!P$4,\"\"),\"\")","v":"2015-16"},{"$f":"IF(RIGHT(R$4,2)>=RIGHT('Input|General'!$G$11,2),IF(RIGHT(R$4,2)<='Input|General'!$G$12,'Input|Reported opex'!Q$4,\"\"),\"\")","v":"2016-17"},{"$f":"IF(RIGHT(S$4,2)>=RIGHT('Input|General'!$G$11,2),IF(RIGHT(S$4,2)<='Input|General'!$G$12,'Input|Reported opex'!R$4,\"\"),\"\")","v":"2017-18"},{"$f":"IF(RIGHT(T$4,2)>=RIGHT('Input|General'!$G$11,2),IF(RIGHT(T$4,2)<='Input|General'!$G$12,'Input|Reported opex'!S$4,\"\"),\"\")","v":"2018-19"}]
[]
[null,null,"Partial factor productivity","external",{"$f":"percent","v":"Per cent"},"n/a",null,null,null,null,null,null,null,null,null,8.6E-3,8.6E-3,8.6E-3,8.6E-3,8.6E-3]
[]
[null,"End"]

{"sheet":"Input|Step changes","index":5,"n_rows":31,"n_cols":22,"rows_kept":31,"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$224)=COUNTIF($W$8:$W$224,\"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":"2009-10"},{"$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":"2010-11"},{"$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":"2011-12"},{"$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":"2012-13"},{"$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":"2013-14"},{"$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":"2014-15"},{"$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":"2015-16"},{"$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":"2016-17"},{"$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":"2017-18"},{"$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":"2018-19"}]
[]
[]
[]
[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)<='Input|General'!$G$12,'Input|Reported opex'!J$4,\"\"),\"\")","v":""},{"$f":"IF(RIGHT(K$4,2)>=RIGHT('Input|General'!$G$11,2),IF(RIGHT(K$4,2)<='Input|General'!$G$12,'Input|Reported opex'!K$4,\"\"),\"\")","v":""},{"$f":"IF(RIGHT(L$4,2)>=RIGHT('Input|General'!$G$11,2),IF(RIGHT(L$4,2)<='Input|General'!$G$12,'Input|Reported opex'!L$4,\"\"),\"\")","v":""},{"$f":"IF(RIGHT(M$4,2)>=RIGHT('Input|General'!$G$11,2),IF(RIGHT(M$4,2)<='Input|General'!$G$12,'Input|Reported opex'!M$4,\"\"),\"\")","v":""},{"$f":"IF(RIGHT(N$4,2)>=RIGHT('Input|General'!$G$11,2),IF(RIGHT(N$4,2)<='Input|General'!$G$12,'Input|Reported opex'!N$4,\"\"),\"\")","v":""},{"$f":"IF(RIGHT(O$4,2)>=RIGHT('Input|General'!$G$11,2),IF(RIGHT(O$4,2)<='Input|General'!$G$12,'Input|Reported opex'!O$4,\"\"),\"\")","v":"2014-15"},{"$f":"IF(RIGHT(P$4,2)>=RIGHT('Input|General'!$G$11,2),IF(RIGHT(P$4,2)<='Input|General'!$G$12,'Input|Reported opex'!P$4,\"\"),\"\")","v":"2015-16"},{"$f":"IF(RIGHT(Q$4,2)>=RIGHT('Input|General'!$G$11,2),IF(RIGHT(Q$4,2)<='Input|General'!$G$12,'Input|Reported opex'!Q$4,\"\"),\"\")","v":"2016-17"},{"$f":"IF(RIGHT(R$4,2)>=RIGHT('Input|General'!$G$11,2),IF(RIGHT(R$4,2)<='Input|General'!$G$12,'Input|Reported opex'!R$4,\"\"),\"\")","v":"2017-18"},{"$f":"IF(RIGHT(S$4,2)>=RIGHT('Input|General'!$G$11,2),IF(RIGHT(S$4,2)<='Input|General'!$G$12,'Input|Reported opex'!S$4,\"\"),\"\")","v":"2018-19"}]
[]
[null,null,"Transmission operations - AEMO operating agreement","AER","$000","2013-14"]
[null,null,"Asset management - Better Regulation program","AER","$000","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,null,"AER","$millions","2013-14"]
[null,null,null,"AER","$millions","2013-14"]
[null,null,null,"AER","$millions","2012-13"]
[null,null,"Network support costs","AER","$millions","2013-14",null,null,null,null,null,null,null,null,0,0,0,0,0]
[]
[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)<='Input|General'!$G$12,'Input|Reported opex'!J$4,\"\"),\"\")","v":""},{"$f":"IF(RIGHT(K$4,2)>=RIGHT('Input|General'!$G$11,2),IF(RIGHT(K$4,2)<='Input|General'!$G$12,'Input|Reported opex'!K$4,\"\"),\"\")","v":""},{"$f":"IF(RIGHT(L$4,2)>=RIGHT('Input|General'!$G$11,2),IF(RIGHT(L$4,2)<='Input|General'!$G$12,'Input|Reported opex'!L$4,\"\"),\"\")","v":""},{"$f":"IF(RIGHT(M$4,2)>=RIGHT('Input|General'!$G$11,2),IF(RIGHT(M$4,2)<='Input|General'!$G$12,'Input|Reported opex'!M$4,\"\"),\"\")","v":""},{"$f":"IF(RIGHT(N$4,2)>=RIGHT('Input|General'!$G$11,2),IF(RIGHT(N$4,2)<='Input|General'!$G$12,'Input|Reported opex'!N$4,\"\"),\"\")","v":""},{"$f":"IF(RIGHT(O$4,2)>=RIGHT('Input|General'!$G$11,2),IF(RIGHT(O$4,2)<='Input|General'!$G$12,'Input|Reported opex'!O$4,\"\"),\"\")","v":"2014-15"},{"$f":"IF(RIGHT(P$4,2)>=RIGHT('Input|General'!$G$11,2),IF(RIGHT(P$4,2)<='Input|General'!$G$12,'Input|Reported opex'!P$4,\"\"),\"\")","v":"2015-16"},{"$f":"IF(RIGHT(Q$4,2)>=RIGHT('Input|General'!$G$11,2),IF(RIGHT(Q$4,2)<='Input|General'!$G$12,'Input|Reported opex'!Q$4,\"\"),\"\")","v":"2016-17"},{"$f":"IF(RIGHT(R$4,2)>=RIGHT('Input|General'!$G$11,2),IF(RIGHT(R$4,2)<='Input|General'!$G$12,'Input|Reported opex'!R$4,\"\"),\"\")","v":"2017-18"},{"$f":"IF(RIGHT(S$4,2)>=RIGHT('Input|General'!$G$11,2),IF(RIGHT(S$4,2)<='Input|General'!$G$12,'Input|Reported opex'!S$4,\"\"),\"\")","v":"2018-19"}]
[]
[null,null,"Debt raising costs","PTRM","$millions","2013-14",null,null,null,null,null,null,null,null,0.73573855554591672,0.73562314954745545,0.74134631181643684,0.73944614718746204,0.73334217265146806]
[]
[null,"End"]

{"sheet":"Calc|Opex forecast","index":6,"n_rows":65,"n_cols":22,"rows_kept":65,"cut":false,"hidden":false,"merged":[[2,9,2,11],[2,13,2,18]]}
[null,{"$f":"Index!$B$1","v":"AER opex model"},null,null,null,null,null,null,null,"Back to Index",null,"Key:","Input","External Link","Internal Link",null,null,"Worksheet check:","n/a",null,"Overall Check:",{"$f":"'Check|List'!$S$1","v":"Ok"}]
[null,{"$f":"Index!$C$12","v":"Calc | Opex Forecast"}]
[]
[null,null,null,"Source","Unit","Basis",null,null,null,{"$f":"'Input|General'!$G$8","v":"2009-10"},{"$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":"2010-11"},{"$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":"2011-12"},{"$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":"2012-13"},{"$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":"2013-14"},{"$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":"2014-15"},{"$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":"2015-16"},{"$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":"2016-17"},{"$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":"2017-18"},{"$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":"2018-19"}]
[]
[]
[]
[null,"Calc | Estimated final year expenditure",null,null,"$millions","2013-14"]
[]
[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":"2012-13"},{"$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":"2013-14"},{"$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":44.811512},{"$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"},{"$f":"$F$8","v":"2013-14"},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":46.295418881333532},{"$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,"Total base year opex allowance","Inputs|Reported opex",{"$f":"'Input|Reported opex'!E24","v":"$millions"},{"$f":"'Input|Reported opex'!F24","v":"2008-09"},null,null,null,{"$f":"IF(J$10='Input|General'!$G$9,'Input|Reported opex'!J24,0)","v":0},{"$f":"IF(K$10='Input|General'!$G$9,'Input|Reported opex'!K24,0)","v":0},{"$f":"IF(L$10='Input|General'!$G$9,'Input|Reported opex'!L24,0)","v":0},{"$f":"IF(M$10='Input|General'!$G$9,'Input|Reported opex'!M24,0)","v":51.70586555423067},{"$f":"IF(N$10='Input|General'!$G$9,'Input|Reported opex'!N24,0)","v":0},{"$f":"IF(O$10='Input|General'!$G$9,'Input|Reported opex'!O24,0)","v":0},{"$f":"IF(P$10='Input|General'!$G$9,'Input|Reported opex'!P24,0)","v":0},{"$f":"IF(Q$10='Input|General'!$G$9,'Input|Reported opex'!Q24,0)","v":0},{"$f":"IF(R$10='Input|General'!$G$9,'Input|Reported opex'!R24,0)","v":0},{"$f":"IF(S$10='Input|General'!$G$9,'Input|Reported opex'!S24,0)","v":0}]
[null,null,"Total base year opex allowance","Calculated",{"$f":"$E$8","v":"$millions"},{"$f":"F8","v":"2013-14"},null,null,null,{"$f":"J14*IF($F14=\"nominal\",LOOKUP($F15,Nominal_to_Real,'Input|Rate of change'!K$26:K$32),INDEX('Input|Rate of change'!$C$14:$O$22,MATCH('Calc|Opex forecast'!$F14,'Input|Rate of change'!$C$14:$C$22,0),MATCH('Calc|Opex forecast'!$F15,'Input|Rate of change'!$C$14:$O$14,0)))*IF($E14=\"$millions\",1000000,IF($E14=\"$000\",1000,1))/IF($E15=\"$millions\",1000000,IF($E15=\"$000\",1000,1))","v":0},{"$f":"K14*IF($F14=\"nominal\",LOOKUP($F15,Nominal_to_Real,'Input|Rate of change'!L$26:L$32),INDEX('Input|Rate of change'!$C$14:$O$22,MATCH('Calc|Opex forecast'!$F14,'Input|Rate of change'!$C$14:$C$22,0),MATCH('Calc|Opex forecast'!$F15,'Input|Rate of change'!$C$14:$O$14,0)))*IF($E14=\"$millions\",1000000,IF($E14=\"$000\",1000,1))/IF($E15=\"$millions\",1000000,IF($E15=\"$000\",1000,1))","v":0},{"$f":"L14*IF($F14=\"nominal\",LOOKUP($F15,Nominal_to_Real,'Input|Rate of change'!M$26:M$32),INDEX('Input|Rate of change'!$C$14:$O$22,MATCH('Calc|Opex forecast'!$F14,'Input|Rate of change'!$C$14:$C$22,0),MATCH('Calc|Opex forecast'!$F15,'Input|Rate of change'!$C$14:$O$14,0)))*IF($E14=\"$millions\",1000000,IF($E14=\"$000\",1000,1))/IF($E15=\"$millions\",1000000,IF($E15=\"$000\",1000,1))","v":0},{"$f":"M14*IF($F14=\"nominal\",LOOKUP($F15,Nominal_to_Real,'Input|Rate of change'!N$26:N$32),INDEX('Input|Rate of change'!$C$14:$O$22,MATCH('Calc|Opex forecast'!$F14,'Input|Rate of change'!$C$14:$C$22,0),MATCH('Calc|Opex forecast'!$F15,'Input|Rate of change'!$C$14:$O$14,0)))*IF($E14=\"$millions\",1000000,IF($E14=\"$000\",1000,1))/IF($E15=\"$millions\",1000000,IF($E15=\"$000\",1000,1))","v":58.652683113397195},{"$f":"N14*IF($F14=\"nominal\",LOOKUP($F15,Nominal_to_Real,'Input|Rate of change'!O$26:O$32),INDEX('Input|Rate of change'!$C$14:$O$22,MATCH('Calc|Opex forecast'!$F14,'Input|Rate of change'!$C$14:$C$22,0),MATCH('Calc|Opex forecast'!$F15,'Input|Rate of change'!$C$14:$O$14,0)))*IF($E14=\"$millions\",1000000,IF($E14=\"$000\",1000,1))/IF($E15=\"$millions\",1000000,IF($E15=\"$000\",1000,1))","v":0},{"$f":"O14*IF($F14=\"nominal\",LOOKUP($F15,Nominal_to_Real,'Input|Rate of change'!P$26:P$32),INDEX('Input|Rate of change'!$C$14:$O$22,MATCH('Calc|Opex forecast'!$F14,'Input|Rate of change'!$C$14:$C$22,0),MATCH('Calc|Opex forecast'!$F15,'Input|Rate of change'!$C$14:$O$14,0)))*IF($E14=\"$millions\",1000000,IF($E14=\"$000\",1000,1))/IF($E15=\"$millions\",1000000,IF($E15=\"$000\",1000,1))","v":0},{"$f":"P14*IF($F14=\"nominal\",LOOKUP($F15,Nominal_to_Real,'Input|Rate of change'!Q$26:Q$32),INDEX('Input|Rate of change'!$C$14:$O$22,MATCH('Calc|Opex forecast'!$F14,'Input|Rate of change'!$C$14:$C$22,0),MATCH('Calc|Opex forecast'!$F15,'Input|Rate of change'!$C$14:$O$14,0)))*IF($E14=\"$millions\",1000000,IF($E14=\"$000\",1000,1))/IF($E15=\"$millions\",1000000,IF($E15=\"$000\",1000,1))","v":0},{"$f":"Q14*IF($F14=\"nominal\",LOOKUP($F15,Nominal_to_Real,'Input|Rate of change'!R$26:R$32),INDEX('Input|Rate of change'!$C$14:$O$22,MATCH('Calc|Opex forecast'!$F14,'Input|Rate of change'!$C$14:$C$22,0),MATCH('Calc|Opex forecast'!$F15,'Input|Rate of change'!$C$14:$O$14,0)))*IF($E14=\"$millions\",1000000,IF($E14=\"$000\",1000,1))/IF($E15=\"$millions\",1000000,IF($E15=\"$000\",1000,1))","v":0},{"$f":"R14*IF($F14=\"nominal\",LOOKUP($F15,Nominal_to_Real,'Input|Rate of change'!S$26:S$32),INDEX('Input|Rate of change'!$C$14:$O$22,MATCH('Calc|Opex forecast'!$F14,'Input|Rate of change'!$C$14:$C$22,0),MATCH('Calc|Opex forecast'!$F15,'Input|Rate of change'!$C$14:$O$14,0)))*IF($E14=\"$millions\",1000000,IF($E14=\"$000\",1000,1))/IF($E15=\"$millions\",1000000,IF($E15=\"$000\",1000,1))","v":0},{"$f":"S14*IF($F14=\"nominal\",LOOKUP($F15,Nominal_to_Real,'Input|Rate of change'!T$26:T$32),INDEX('Input|Rate of change'!$C$14:$O$22,MATCH('Calc|Opex forecast'!$F14,'Input|Rate of change'!$C$14:$C$22,0),MATCH('Calc|Opex forecast'!$F15,'Input|Rate of change'!$C$14:$O$14,0)))*IF($E14=\"$millions\",1000000,IF($E14=\"$000\",1000,1))/IF($E15=\"$millions\",1000000,IF($E15=\"$000\",1000,1))","v":0}]
[null,null,"Total final year opex allowance","Inputs|Reported opex",{"$f":"'Input|Reported opex'!E24","v":"$millions"},{"$f":"'Input|Reported opex'!F24","v":"2008-09"},null,null,null,{"$f":"IF(J$10='Input|General'!$G$10,'Input|Reported opex'!J24,0)","v":0},{"$f":"IF(K$10='Input|General'!$G$10,'Input|Reported opex'!K24,0)","v":0},{"$f":"IF(L$10='Input|General'!$G$10,'Input|Reported opex'!L24,0)","v":0},{"$f":"IF(M$10='Input|General'!$G$10,'Input|Reported opex'!M24,0)","v":0},{"$f":"IF(N$10='Input|General'!$G$10,'Input|Reported opex'!N24,0)","v":51.365922436914701},{"$f":"IF(O$10='Input|General'!$G$10,'Input|Reported opex'!O24,0)","v":0},{"$f":"IF(P$10='Input|General'!$G$10,'Input|Reported opex'!P24,0)","v":0},{"$f":"IF(Q$10='Input|General'!$G$10,'Input|Reported opex'!Q24,0)","v":0},{"$f":"IF(R$10='Input|General'!$G$10,'Input|Reported opex'!R24,0)","v":0},{"$f":"IF(S$10='Input|General'!$G$10,'Input|Reported opex'!S24,0)","v":0}]
[null,null,"Total final year opex allowance","Calculated",{"$f":"$E$8","v":"$millions"},{"$f":"F8","v":"2013-14"},null,null,null,{"$f":"J16*IF($F16=\"nominal\",LOOKUP($F17,Nominal_to_Real,'Input|Rate of change'!K$27:K$32),INDEX('Input|Rate of change'!$C$14:$O$22,MATCH('Calc|Opex forecast'!$F16,'Input|Rate of change'!$C$14:$C$22,0),MATCH('Calc|Opex forecast'!$F17,'Input|Rate of change'!$C$14:$O$14,0)))*IF($E16=\"$millions\",1000000,IF($E16=\"$000\",1000,1))/IF($E17=\"$millions\",1000000,IF($E17=\"$000\",1000,1))","v":0},{"$f":"K16*IF($F16=\"nominal\",LOOKUP($F17,Nominal_to_Real,'Input|Rate of change'!L$27:L$32),INDEX('Input|Rate of change'!$C$14:$O$22,MATCH('Calc|Opex forecast'!$F16,'Input|Rate of change'!$C$14:$C$22,0),MATCH('Calc|Opex forecast'!$F17,'Input|Rate of change'!$C$14:$O$14,0)))*IF($E16=\"$millions\",1000000,IF($E16=\"$000\",1000,1))/IF($E17=\"$millions\",1000000,IF($E17=\"$000\",1000,1))","v":0},{"$f":"L16*IF($F16=\"nominal\",LOOKUP($F17,Nominal_to_Real,'Input|Rate of change'!M$27:M$32),INDEX('Input|Rate of change'!$C$14:$O$22,MATCH('Calc|Opex forecast'!$F16,'Input|Rate of change'!$C$14:$C$22,0),MATCH('Calc|Opex forecast'!$F17,'Input|Rate of change'!$C$14:$O$14,0)))*IF($E16=\"$millions\",1000000,IF($E16=\"$000\",1000,1))/IF($E17=\"$millions\",1000000,IF($E17=\"$000\",1000,1))","v":0},{"$f":"M16*IF($F16=\"nominal\",LOOKUP($F17,Nominal_to_Real,'Input|Rate of change'!N$27:N$32),INDEX('Input|Rate of change'!$C$14:$O$22,MATCH('Calc|Opex forecast'!$F16,'Input|Rate of change'!$C$14:$C$22,0),MATCH('Calc|Opex forecast'!$F17,'Input|Rate of change'!$C$14:$O$14,0)))*IF($E16=\"$millions\",1000000,IF($E16=\"$000\",1000,1))/IF($E17=\"$millions\",1000000,IF($E17=\"$000\",1000,1))","v":0},{"$f":"N16*IF($F16=\"nominal\",LOOKUP($F17,Nominal_to_Real,'Input|Rate of change'!O$27:O$32),INDEX('Input|Rate of change'!$C$14:$O$22,MATCH('Calc|Opex forecast'!$F16,'Input|Rate of change'!$C$14:$C$22,0),MATCH('Calc|Opex forecast'!$F17,'Input|Rate of change'!$C$14:$O$14,0)))*IF($E16=\"$millions\",1000000,IF($E16=\"$000\",1000,1))/IF($E17=\"$millions\",1000000,IF($E17=\"$000\",1000,1))","v":58.26706775384767},{"$f":"O16*IF($F16=\"nominal\",LOOKUP($F17,Nominal_to_Real,'Input|Rate of change'!P$27:P$32),INDEX('Input|Rate of change'!$C$14:$O$22,MATCH('Calc|Opex forecast'!$F16,'Input|Rate of change'!$C$14:$C$22,0),MATCH('Calc|Opex forecast'!$F17,'Input|Rate of change'!$C$14:$O$14,0)))*IF($E16=\"$millions\",1000000,IF($E16=\"$000\",1000,1))/IF($E17=\"$millions\",1000000,IF($E17=\"$000\",1000,1))","v":0},{"$f":"P16*IF($F16=\"nominal\",LOOKUP($F17,Nominal_to_Real,'Input|Rate of change'!Q$27:Q$32),INDEX('Input|Rate of change'!$C$14:$O$22,MATCH('Calc|Opex forecast'!$F16,'Input|Rate of change'!$C$14:$C$22,0),MATCH('Calc|Opex forecast'!$F17,'Input|Rate of change'!$C$14:$O$14,0)))*IF($E16=\"$millions\",1000000,IF($E16=\"$000\",1000,1))/IF($E17=\"$millions\",1000000,IF($E17=\"$000\",1000,1))","v":0},{"$f":"Q16*IF($F16=\"nominal\",LOOKUP($F17,Nominal_to_Real,'Input|Rate of change'!R$27:R$32),INDEX('Input|Rate of change'!$C$14:$O$22,MATCH('Calc|Opex forecast'!$F16,'Input|Rate of change'!$C$14:$C$22,0),MATCH('Calc|Opex forecast'!$F17,'Input|Rate of change'!$C$14:$O$14,0)))*IF($E16=\"$millions\",1000000,IF($E16=\"$000\",1000,1))/IF($E17=\"$millions\",1000000,IF($E17=\"$000\",1000,1))","v":0},{"$f":"R16*IF($F16=\"nominal\",LOOKUP($F17,Nominal_to_Real,'Input|Rate of change'!S$27:S$32),INDEX('Input|Rate of change'!$C$14:$O$22,MATCH('Calc|Opex forecast'!$F16,'Input|Rate of change'!$C$14:$C$22,0),MATCH('Calc|Opex forecast'!$F17,'Input|Rate of change'!$C$14:$O$14,0)))*IF($E16=\"$millions\",1000000,IF($E16=\"$000\",1000,1))/IF($E17=\"$millions\",1000000,IF($E17=\"$000\",1000,1))","v":0},{"$f":"S16*IF($F16=\"nominal\",LOOKUP($F17,Nominal_to_Real,'Input|Rate of change'!T$27:T$32),INDEX('Input|Rate of change'!$C$14:$O$22,MATCH('Calc|Opex forecast'!$F16,'Input|Rate of change'!$C$14:$C$22,0),MATCH('Calc|Opex forecast'!$F17,'Input|Rate of change'!$C$14:$O$14,0)))*IF($E16=\"$millions\",1000000,IF($E16=\"$000\",1000,1))/IF($E17=\"$millions\",1000000,IF($E17=\"$000\",1000,1))","v":0}]
[]
[null,null,"Estimated final year opex","Calculated",{"$f":"$E$8","v":"$millions"},{"$f":"$F$8","v":"2013-14"},null,null,null,{"$f":"IF(J$10='Input|General'!$G$10,SUM($J13:$S13)-SUM($J15:$S15)+SUM($J17:$S17),0)","v":0},{"$f":"IF(K$10='Input|General'!$G$10,SUM($J13:$S13)-SUM($J15:$S15)+SUM($J17:$S17),0)","v":0},{"$f":"IF(L$10='Input|General'!$G$10,SUM($J13:$S13)-SUM($J15:$S15)+SUM($J17:$S17),0)","v":0},{"$f":"IF(M$10='Input|General'!$G$10,SUM($J13:$S13)-SUM($J15:$S15)+SUM($J17:$S17),0)","v":0},{"$f":"IF(N$10='Input|General'!$G$10,SUM($J13:$S13)-SUM($J15:$S15)+SUM($J17:$S17),0)","v":45.909803521784006},{"$f":"IF(O$10='Input|General'!$G$10,SUM($J13:$S13)-SUM($J15:$S15)+SUM($J17:$S17),0)","v":0},{"$f":"IF(P$10='Input|General'!$G$10,SUM($J13:$S13)-SUM($J15:$S15)+SUM($J17:$S17),0)","v":0},{"$f":"IF(Q$10='Input|General'!$G$10,SUM($J13:$S13)-SUM($J15:$S15)+SUM($J17:$S17),0)","v":0},{"$f":"IF(R$10='Input|General'!$G$10,SUM($J13:$S13)-SUM($J15:$S15)+SUM($J17:$S17),0)","v":0},{"$f":"IF(S$10='Input|General'!$G$10,SUM($J13:$S13)-SUM($J15:$S15)+SUM($J17:$S17),0)","v":0}]
[]
[null,null,"Efficiency adjustment","calculated",{"$f":"$E$8","v":"$millions"},{"$f":"$E$8","v":"$millions"},null,null,null,{"$f":"J19*'Input|Reported opex'!$J$48","v":0},{"$f":"K19*'Input|Reported opex'!$J$48","v":0},{"$f":"L19*'Input|Reported opex'!$J$48","v":0},{"$f":"M19*'Input|Reported opex'!$J$48","v":0},{"$f":"N19*'Input|Reported opex'!$J$48","v":0},{"$f":"O19*'Input|Reported opex'!$J$48","v":0},{"$f":"P19*'Input|Reported opex'!$J$48","v":0},{"$f":"Q19*'Input|Reported opex'!$J$48","v":0},{"$f":"R19*'Input|Reported opex'!$J$48","v":0},{"$f":"S19*'Input|Reported opex'!$J$48","v":0}]
[]
[null,null,"Efficiency adjustment final year opex","calculated",{"$f":"$E$8","v":"$millions"},{"$f":"$E$8","v":"$millions"},null,null,null,{"$f":"J19-J21","v":0},0,0,0,{"$f":"N19-N21","v":45.909803521784006},0,0,0,0,{"$f":"S19-S21","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)<='Input|General'!$G$12,'Input|Reported opex'!J$4,\"\"),\"\")","v":""},{"$f":"IF(RIGHT(K$4,2)>=RIGHT('Input|General'!$G$11,2),IF(RIGHT(K$4,2)<='Input|General'!$G$12,'Input|Reported opex'!K$4,\"\"),\"\")","v":""},{"$f":"IF(RIGHT(L$4,2)>=RIGHT('Input|General'!$G$11,2),IF(RIGHT(L$4,2)<='Input|General'!$G$12,'Input|Reported opex'!L$4,\"\"),\"\")","v":""},{"$f":"IF(RIGHT(M$4,2)>=RIGHT('Input|General'!$G$11,2),IF(RIGHT(M$4,2)<='Input|General'!$G$12,'Input|Reported opex'!M$4,\"\"),\"\")","v":""},{"$f":"IF(RIGHT(N$4,2)>=RIGHT('Input|General'!$G$11,2),IF(RIGHT(N$4,2)<='Input|General'!$G$12,'Input|Reported opex'!N$4,\"\"),\"\")","v":""},{"$f":"IF(RIGHT(O$4,2)>=RIGHT('Input|General'!$G$11,2),IF(RIGHT(O$4,2)<='Input|General'!$G$12,'Input|Reported opex'!O$4,\"\"),\"\")","v":"2014-15"},{"$f":"IF(RIGHT(P$4,2)>=RIGHT('Input|General'!$G$11,2),IF(RIGHT(P$4,2)<='Input|General'!$G$12,'Input|Reported opex'!P$4,\"\"),\"\")","v":"2015-16"},{"$f":"IF(RIGHT(Q$4,2)>=RIGHT('Input|General'!$G$11,2),IF(RIGHT(Q$4,2)<='Input|General'!$G$12,'Input|Reported opex'!Q$4,\"\"),\"\")","v":"2016-17"},{"$f":"IF(RIGHT(R$4,2)>=RIGHT('Input|General'!$G$11,2),IF(RIGHT(R$4,2)<='Input|General'!$G$12,'Input|Reported opex'!R$4,\"\"),\"\")","v":"2017-18"},{"$f":"IF(RIGHT(S$4,2)>=RIGHT('Input|General'!$G$11,2),IF(RIGHT(S$4,2)<='Input|General'!$G$12,'Input|Reported opex'!S$4,\"\"),\"\")","v":"2018-19"}]
[]
[]
[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'!$P$82:$P$87)","v":0},{"$f":"SUMPRODUCT('Input|Rate of change'!L73:L78,'Input|Rate of change'!$P$82:$P$87)","v":0},{"$f":"SUMPRODUCT('Input|Rate of change'!M73:M78,'Input|Rate of change'!$P$82:$P$87)","v":0},{"$f":"SUMPRODUCT('Input|Rate of change'!N73:N78,'Input|Rate of change'!$P$82:$P$87)","v":0},{"$f":"SUMPRODUCT('Input|Rate of change'!O73:O78,'Input|Rate of change'!$P$82:$P$87)","v":0},{"$f":"SUMPRODUCT('Input|Rate of change'!P73:P78,'Input|Rate of change'!$P$82:$P$87)","v":3.8586331071434527E-3},{"$f":"SUMPRODUCT('Input|Rate of change'!Q73:Q78,'Input|Rate of change'!$P$82:$P$87)","v":1.18133867633005E-3},{"$f":"SUMPRODUCT('Input|Rate of change'!R73:R78,'Input|Rate of change'!$P$82:$P$87)","v":2.9514525300367825E-3},{"$f":"SUMPRODUCT('Input|Rate of change'!S73:S78,'Input|Rate of change'!$P$82:$P$87)","v":1.8052046879437796E-2},{"$f":"SUMPRODUCT('Input|Rate of change'!T73:T78,'Input|Rate of change'!$P$82:$P$87)","v":1.9498459934212571E-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},{"$f":"SUMPRODUCT('Input|Rate of change'!O38:O45,'Input|Rate of change'!O49:O56)","v":0},{"$f":"SUMPRODUCT('Input|Rate of change'!P38:P45,'Input|Rate of change'!P49:P56)","v":5.3148456662664902E-3},{"$f":"SUMPRODUCT('Input|Rate of change'!Q38:Q45,'Input|Rate of change'!Q49:Q56)","v":5.7651289801493285E-3},{"$f":"SUMPRODUCT('Input|Rate of change'!R38:R45,'Input|Rate of change'!R49:R56)","v":7.5898541263480475E-3},{"$f":"SUMPRODUCT('Input|Rate of change'!S38:S45,'Input|Rate of change'!S49:S56)","v":9.1102452437040668E-3},{"$f":"SUMPRODUCT('Input|Rate of change'!T38:T45,'Input|Rate of change'!T49:T56)","v":8.7829339492823625E-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},{"$f":"'Input|Rate of change'!O95","v":0},{"$f":"'Input|Rate of change'!P95","v":8.6E-3},{"$f":"'Input|Rate of change'!Q95","v":8.6E-3},{"$f":"'Input|Rate of change'!R95","v":8.6E-3},{"$f":"'Input|Rate of change'!S95","v":8.6E-3},{"$f":"'Input|Rate of change'!T95","v":8.6E-3}]
[]
[null,null,"Forecast rate of change","Calculated","Per cent","n/a",null,null,null,{"$f":"(1+J30)*(1+J32)*(1-J34)-1","v":0},{"$f":"(1+K30)*(1+K32)*(1-K34)-1","v":0},0,0,0,5.1491852626650569E-4,-1.7065199664288988E-3,1.8728598638937388E-3,1.8491740641366938E-2,2.057456125598156E-3]
[]
[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)<='Input|General'!$G$12,'Input|Reported opex'!J$4,\"\"),\"\")","v":""},{"$f":"IF(RIGHT(K$4,2)>=RIGHT('Input|General'!$G$11,2),IF(RIGHT(K$4,2)<='Input|General'!$G$12,'Input|Reported opex'!K$4,\"\"),\"\")","v":""},{"$f":"IF(RIGHT(L$4,2)>=RIGHT('Input|General'!$G$11,2),IF(RIGHT(L$4,2)<='Input|General'!$G$12,'Input|Reported opex'!L$4,\"\"),\"\")","v":""},{"$f":"IF(RIGHT(M$4,2)>=RIGHT('Input|General'!$G$11,2),IF(RIGHT(M$4,2)<='Input|General'!$G$12,'Input|Reported opex'!M$4,\"\"),\"\")","v":""},{"$f":"IF(RIGHT(N$4,2)>=RIGHT('Input|General'!$G$11,2),IF(RIGHT(N$4,2)<='Input|General'!$G$12,'Input|Reported opex'!N$4,\"\"),\"\")","v":""},{"$f":"IF(RIGHT(O$4,2)>=RIGHT('Input|General'!$G$11,2),IF(RIGHT(O$4,2)<='Input|General'!$G$12,'Input|Reported opex'!O$4,\"\"),\"\")","v":"2014-15"},{"$f":"IF(RIGHT(P$4,2)>=RIGHT('Input|General'!$G$11,2),IF(RIGHT(P$4,2)<='Input|General'!$G$12,'Input|Reported opex'!P$4,\"\"),\"\")","v":"2015-16"},{"$f":"IF(RIGHT(Q$4,2)>=RIGHT('Input|General'!$G$11,2),IF(RIGHT(Q$4,2)<='Input|General'!$G$12,'Input|Reported opex'!Q$4,\"\"),\"\")","v":"2016-17"},{"$f":"IF(RIGHT(R$4,2)>=RIGHT('Input|General'!$G$11,2),IF(RIGHT(R$4,2)<='Input|General'!$G$12,'Input|Reported opex'!R$4,\"\"),\"\")","v":"2017-18"},{"$f":"IF(RIGHT(S$4,2)>=RIGHT('Input|General'!$G$11,2),IF(RIGHT(S$4,2)<='Input|General'!$G$12,'Input|Reported opex'!S$4,\"\"),\"\")","v":"2018-19"}]
[]
[null,null,{"$f":"'Input|Step changes'!C12","v":"Transmission operations - AEMO operating agreement"},"Calculated",{"$f":"$E$8","v":"$millions"},{"$f":"$F$8","v":"2013-14"},null,null,null,{"$f":"'Input|Step changes'!J12*IF('Input|Step changes'!$F12=\"nominal\",LOOKUP($F42,Nominal_to_Real,'Input|Rate of change'!N$27: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'!$F42,'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($E42=\"$millions\",1000000,IF($E42=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!K12*IF('Input|Step changes'!$F12=\"nominal\",LOOKUP($F42,Nominal_to_Real,'Input|Rate of change'!O$27: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'!$F42,'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($E42=\"$millions\",1000000,IF($E42=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!L12*IF('Input|Step changes'!$F12=\"nominal\",LOOKUP($F42,Nominal_to_Real,'Input|Rate of change'!P$27: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'!$F42,'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($E42=\"$millions\",1000000,IF($E42=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!M12*IF('Input|Step changes'!$F12=\"nominal\",LOOKUP($F42,Nominal_to_Real,'Input|Rate of change'!Q$27: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'!$F42,'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($E42=\"$millions\",1000000,IF($E42=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!N12*IF('Input|Step changes'!$F12=\"nominal\",LOOKUP($F42,Nominal_to_Real,'Input|Rate of change'!R$27: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'!$F42,'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($E42=\"$millions\",1000000,IF($E42=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!O12*IF('Input|Step changes'!$F12=\"nominal\",LOOKUP($F42,Nominal_to_Real,'Input|Rate of change'!S$27: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'!$F42,'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($E42=\"$millions\",1000000,IF($E42=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!P12*IF('Input|Step changes'!$F12=\"nominal\",LOOKUP($F42,Nominal_to_Real,'Input|Rate of change'!T$27: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'!$F42,'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($E42=\"$millions\",1000000,IF($E42=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!Q12*IF('Input|Step changes'!$F12=\"nominal\",LOOKUP($F42,Nominal_to_Real,'Input|Rate of change'!U$27:U$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'!$F42,'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($E42=\"$millions\",1000000,IF($E42=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!R12*IF('Input|Step changes'!$F12=\"nominal\",LOOKUP($F42,Nominal_to_Real,'Input|Rate of change'!V$27:V$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'!$F42,'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($E42=\"$millions\",1000000,IF($E42=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!S12*IF('Input|Step changes'!$F12=\"nominal\",LOOKUP($F42,Nominal_to_Real,'Input|Rate of change'!W$27:W$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'!$F42,'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($E42=\"$millions\",1000000,IF($E42=\"$000\",1000,1))","v":0}]
[null,null,{"$f":"'Input|Step changes'!C13","v":"Asset management - Better Regulation program"},"Calculated","$millions",{"$f":"$F$8","v":"2013-14"},null,null,null,{"$f":"'Input|Step changes'!J13*IF('Input|Step changes'!$F13=\"nominal\",LOOKUP($F43,Nominal_to_Real,'Input|Rate of change'!N$27: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'!$F43,'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($E43=\"$millions\",1000000,IF($E43=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!K13*IF('Input|Step changes'!$F13=\"nominal\",LOOKUP($F43,Nominal_to_Real,'Input|Rate of change'!O$27: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'!$F43,'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($E43=\"$millions\",1000000,IF($E43=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!L13*IF('Input|Step changes'!$F13=\"nominal\",LOOKUP($F43,Nominal_to_Real,'Input|Rate of change'!P$27: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'!$F43,'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($E43=\"$millions\",1000000,IF($E43=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!M13*IF('Input|Step changes'!$F13=\"nominal\",LOOKUP($F43,Nominal_to_Real,'Input|Rate of change'!Q$27: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'!$F43,'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($E43=\"$millions\",1000000,IF($E43=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!N13*IF('Input|Step changes'!$F13=\"nominal\",LOOKUP($F43,Nominal_to_Real,'Input|Rate of change'!R$27: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'!$F43,'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($E43=\"$millions\",1000000,IF($E43=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!O13*IF('Input|Step changes'!$F13=\"nominal\",LOOKUP($F43,Nominal_to_Real,'Input|Rate of change'!S$27: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'!$F43,'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($E43=\"$millions\",1000000,IF($E43=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!P13*IF('Input|Step changes'!$F13=\"nominal\",LOOKUP($F43,Nominal_to_Real,'Input|Rate of change'!T$27: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'!$F43,'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($E43=\"$millions\",1000000,IF($E43=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!Q13*IF('Input|Step changes'!$F13=\"nominal\",LOOKUP($F43,Nominal_to_Real,'Input|Rate of change'!U$27:U$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'!$F43,'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($E43=\"$millions\",1000000,IF($E43=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!R13*IF('Input|Step changes'!$F13=\"nominal\",LOOKUP($F43,Nominal_to_Real,'Input|Rate of change'!V$27:V$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'!$F43,'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($E43=\"$millions\",1000000,IF($E43=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!S13*IF('Input|Step changes'!$F13=\"nominal\",LOOKUP($F43,Nominal_to_Real,'Input|Rate of change'!W$27:W$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'!$F43,'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($E43=\"$millions\",1000000,IF($E43=\"$000\",1000,1))","v":0}]
[null,null,{"$f":"'Input|Step changes'!C14","v":0},"Calculated","$millions","2013-14",null,null,null,{"$f":"'Input|Step changes'!J14*IF('Input|Step changes'!$F14=\"nominal\",LOOKUP($F44,Nominal_to_Real,'Input|Rate of change'!N$27: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'!$F44,'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($E44=\"$millions\",1000000,IF($E44=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!K14*IF('Input|Step changes'!$F14=\"nominal\",LOOKUP($F44,Nominal_to_Real,'Input|Rate of change'!O$27: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'!$F44,'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($E44=\"$millions\",1000000,IF($E44=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!L14*IF('Input|Step changes'!$F14=\"nominal\",LOOKUP($F44,Nominal_to_Real,'Input|Rate of change'!P$27: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'!$F44,'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($E44=\"$millions\",1000000,IF($E44=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!M14*IF('Input|Step changes'!$F14=\"nominal\",LOOKUP($F44,Nominal_to_Real,'Input|Rate of change'!Q$27: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'!$F44,'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($E44=\"$millions\",1000000,IF($E44=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!N14*IF('Input|Step changes'!$F14=\"nominal\",LOOKUP($F44,Nominal_to_Real,'Input|Rate of change'!R$27: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'!$F44,'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($E44=\"$millions\",1000000,IF($E44=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!O14*IF('Input|Step changes'!$F14=\"nominal\",LOOKUP($F44,Nominal_to_Real,'Input|Rate of change'!S$27: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'!$F44,'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($E44=\"$millions\",1000000,IF($E44=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!P14*IF('Input|Step changes'!$F14=\"nominal\",LOOKUP($F44,Nominal_to_Real,'Input|Rate of change'!T$27: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'!$F44,'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($E44=\"$millions\",1000000,IF($E44=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!Q14*IF('Input|Step changes'!$F14=\"nominal\",LOOKUP($F44,Nominal_to_Real,'Input|Rate of change'!U$27:U$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'!$F44,'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($E44=\"$millions\",1000000,IF($E44=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!R14*IF('Input|Step changes'!$F14=\"nominal\",LOOKUP($F44,Nominal_to_Real,'Input|Rate of change'!V$27:V$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'!$F44,'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($E44=\"$millions\",1000000,IF($E44=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!S14*IF('Input|Step changes'!$F14=\"nominal\",LOOKUP($F44,Nominal_to_Real,'Input|Rate of change'!W$27:W$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'!$F44,'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($E44=\"$millions\",1000000,IF($E44=\"$000\",1000,1))","v":0}]
[null,null,{"$f":"'Input|Step changes'!C15","v":0},"Calculated","$millions","2013-14",null,null,null,{"$f":"'Input|Step changes'!J15*IF('Input|Step changes'!$F15=\"nominal\",LOOKUP($F45,Nominal_to_Real,'Input|Rate of change'!N$27: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'!$F45,'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($E45=\"$millions\",1000000,IF($E45=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!K15*IF('Input|Step changes'!$F15=\"nominal\",LOOKUP($F45,Nominal_to_Real,'Input|Rate of change'!O$27: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'!$F45,'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($E45=\"$millions\",1000000,IF($E45=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!L15*IF('Input|Step changes'!$F15=\"nominal\",LOOKUP($F45,Nominal_to_Real,'Input|Rate of change'!P$27: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'!$F45,'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($E45=\"$millions\",1000000,IF($E45=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!M15*IF('Input|Step changes'!$F15=\"nominal\",LOOKUP($F45,Nominal_to_Real,'Input|Rate of change'!Q$27: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'!$F45,'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($E45=\"$millions\",1000000,IF($E45=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!N15*IF('Input|Step changes'!$F15=\"nominal\",LOOKUP($F45,Nominal_to_Real,'Input|Rate of change'!R$27: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'!$F45,'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($E45=\"$millions\",1000000,IF($E45=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!O15*IF('Input|Step changes'!$F15=\"nominal\",LOOKUP($F45,Nominal_to_Real,'Input|Rate of change'!S$27: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'!$F45,'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($E45=\"$millions\",1000000,IF($E45=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!P15*IF('Input|Step changes'!$F15=\"nominal\",LOOKUP($F45,Nominal_to_Real,'Input|Rate of change'!T$27: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'!$F45,'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($E45=\"$millions\",1000000,IF($E45=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!Q15*IF('Input|Step changes'!$F15=\"nominal\",LOOKUP($F45,Nominal_to_Real,'Input|Rate of change'!U$27:U$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'!$F45,'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($E45=\"$millions\",1000000,IF($E45=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!R15*IF('Input|Step changes'!$F15=\"nominal\",LOOKUP($F45,Nominal_to_Real,'Input|Rate of change'!V$27:V$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'!$F45,'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($E45=\"$millions\",1000000,IF($E45=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!S15*IF('Input|Step changes'!$F15=\"nominal\",LOOKUP($F45,Nominal_to_Real,'Input|Rate of change'!W$27:W$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'!$F45,'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($E45=\"$millions\",1000000,IF($E45=\"$000\",1000,1))","v":0}]
[null,null,{"$f":"'Input|Step changes'!C16","v":0},"Calculated","$millions","2013-14",null,null,null,{"$f":"'Input|Step changes'!J16*IF('Input|Step changes'!$F16=\"nominal\",LOOKUP($F46,Nominal_to_Real,'Input|Rate of change'!N$27: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'!$F46,'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($E46=\"$millions\",1000000,IF($E46=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!K16*IF('Input|Step changes'!$F16=\"nominal\",LOOKUP($F46,Nominal_to_Real,'Input|Rate of change'!O$27: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'!$F46,'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($E46=\"$millions\",1000000,IF($E46=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!L16*IF('Input|Step changes'!$F16=\"nominal\",LOOKUP($F46,Nominal_to_Real,'Input|Rate of change'!P$27: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'!$F46,'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($E46=\"$millions\",1000000,IF($E46=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!M16*IF('Input|Step changes'!$F16=\"nominal\",LOOKUP($F46,Nominal_to_Real,'Input|Rate of change'!Q$27: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'!$F46,'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($E46=\"$millions\",1000000,IF($E46=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!N16*IF('Input|Step changes'!$F16=\"nominal\",LOOKUP($F46,Nominal_to_Real,'Input|Rate of change'!R$27: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'!$F46,'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($E46=\"$millions\",1000000,IF($E46=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!O16*IF('Input|Step changes'!$F16=\"nominal\",LOOKUP($F46,Nominal_to_Real,'Input|Rate of change'!S$27: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'!$F46,'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($E46=\"$millions\",1000000,IF($E46=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!P16*IF('Input|Step changes'!$F16=\"nominal\",LOOKUP($F46,Nominal_to_Real,'Input|Rate of change'!T$27: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'!$F46,'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($E46=\"$millions\",1000000,IF($E46=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!Q16*IF('Input|Step changes'!$F16=\"nominal\",LOOKUP($F46,Nominal_to_Real,'Input|Rate of change'!U$27:U$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'!$F46,'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($E46=\"$millions\",1000000,IF($E46=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!R16*IF('Input|Step changes'!$F16=\"nominal\",LOOKUP($F46,Nominal_to_Real,'Input|Rate of change'!V$27:V$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'!$F46,'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($E46=\"$millions\",1000000,IF($E46=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!S16*IF('Input|Step changes'!$F16=\"nominal\",LOOKUP($F46,Nominal_to_Real,'Input|Rate of change'!W$27:W$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'!$F46,'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($E46=\"$millions\",1000000,IF($E46=\"$000\",1000,1))","v":0}]
[null,null,{"$f":"'Input|Step changes'!C17","v":0},"Calculated","$millions","2013-14",null,null,null,{"$f":"'Input|Step changes'!J17*IF('Input|Step changes'!$F17=\"nominal\",LOOKUP($F47,Nominal_to_Real,'Input|Rate of change'!N$27: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'!$F47,'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($E47=\"$millions\",1000000,IF($E47=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!K17*IF('Input|Step changes'!$F17=\"nominal\",LOOKUP($F47,Nominal_to_Real,'Input|Rate of change'!O$27: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'!$F47,'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($E47=\"$millions\",1000000,IF($E47=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!L17*IF('Input|Step changes'!$F17=\"nominal\",LOOKUP($F47,Nominal_to_Real,'Input|Rate of change'!P$27: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'!$F47,'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($E47=\"$millions\",1000000,IF($E47=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!M17*IF('Input|Step changes'!$F17=\"nominal\",LOOKUP($F47,Nominal_to_Real,'Input|Rate of change'!Q$27: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'!$F47,'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($E47=\"$millions\",1000000,IF($E47=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!N17*IF('Input|Step changes'!$F17=\"nominal\",LOOKUP($F47,Nominal_to_Real,'Input|Rate of change'!R$27: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'!$F47,'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($E47=\"$millions\",1000000,IF($E47=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!O17*IF('Input|Step changes'!$F17=\"nominal\",LOOKUP($F47,Nominal_to_Real,'Input|Rate of change'!S$27: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'!$F47,'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($E47=\"$millions\",1000000,IF($E47=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!P17*IF('Input|Step changes'!$F17=\"nominal\",LOOKUP($F47,Nominal_to_Real,'Input|Rate of change'!T$27: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'!$F47,'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($E47=\"$millions\",1000000,IF($E47=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!Q17*IF('Input|Step changes'!$F17=\"nominal\",LOOKUP($F47,Nominal_to_Real,'Input|Rate of change'!U$27:U$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'!$F47,'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($E47=\"$millions\",1000000,IF($E47=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!R17*IF('Input|Step changes'!$F17=\"nominal\",LOOKUP($F47,Nominal_to_Real,'Input|Rate of change'!V$27:V$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'!$F47,'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($E47=\"$millions\",1000000,IF($E47=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!S17*IF('Input|Step changes'!$F17=\"nominal\",LOOKUP($F47,Nominal_to_Real,'Input|Rate of change'!W$27:W$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'!$F47,'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($E47=\"$millions\",1000000,IF($E47=\"$000\",1000,1))","v":0}]
[null,null,{"$f":"'Input|Step changes'!C18","v":0},"Calculated","$millions","2013-14",null,null,null,{"$f":"'Input|Step changes'!J18*IF('Input|Step changes'!$F18=\"nominal\",LOOKUP($F48,Nominal_to_Real,'Input|Rate of change'!N$27: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'!$F48,'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($E48=\"$millions\",1000000,IF($E48=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!K18*IF('Input|Step changes'!$F18=\"nominal\",LOOKUP($F48,Nominal_to_Real,'Input|Rate of change'!O$27: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'!$F48,'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($E48=\"$millions\",1000000,IF($E48=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!L18*IF('Input|Step changes'!$F18=\"nominal\",LOOKUP($F48,Nominal_to_Real,'Input|Rate of change'!P$27: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'!$F48,'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($E48=\"$millions\",1000000,IF($E48=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!M18*IF('Input|Step changes'!$F18=\"nominal\",LOOKUP($F48,Nominal_to_Real,'Input|Rate of change'!Q$27: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'!$F48,'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($E48=\"$millions\",1000000,IF($E48=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!N18*IF('Input|Step changes'!$F18=\"nominal\",LOOKUP($F48,Nominal_to_Real,'Input|Rate of change'!R$27: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'!$F48,'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($E48=\"$millions\",1000000,IF($E48=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!O18*IF('Input|Step changes'!$F18=\"nominal\",LOOKUP($F48,Nominal_to_Real,'Input|Rate of change'!S$27: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'!$F48,'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($E48=\"$millions\",1000000,IF($E48=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!P18*IF('Input|Step changes'!$F18=\"nominal\",LOOKUP($F48,Nominal_to_Real,'Input|Rate of change'!T$27: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'!$F48,'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($E48=\"$millions\",1000000,IF($E48=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!Q18*IF('Input|Step changes'!$F18=\"nominal\",LOOKUP($F48,Nominal_to_Real,'Input|Rate of change'!U$27:U$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'!$F48,'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($E48=\"$millions\",1000000,IF($E48=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!R18*IF('Input|Step changes'!$F18=\"nominal\",LOOKUP($F48,Nominal_to_Real,'Input|Rate of change'!V$27:V$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'!$F48,'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($E48=\"$millions\",1000000,IF($E48=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!S18*IF('Input|Step changes'!$F18=\"nominal\",LOOKUP($F48,Nominal_to_Real,'Input|Rate of change'!W$27:W$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'!$F48,'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($E48=\"$millions\",1000000,IF($E48=\"$000\",1000,1))","v":0}]
[null,null,{"$f":"'Input|Step changes'!C19","v":0},"Calculated","$millions","2013-14",null,null,null,{"$f":"'Input|Step changes'!J19*IF('Input|Step changes'!$F19=\"nominal\",LOOKUP($F49,Nominal_to_Real,'Input|Rate of change'!N$27: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'!$F49,'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($E49=\"$millions\",1000000,IF($E49=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!K19*IF('Input|Step changes'!$F19=\"nominal\",LOOKUP($F49,Nominal_to_Real,'Input|Rate of change'!O$27: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'!$F49,'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($E49=\"$millions\",1000000,IF($E49=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!L19*IF('Input|Step changes'!$F19=\"nominal\",LOOKUP($F49,Nominal_to_Real,'Input|Rate of change'!P$27: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'!$F49,'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($E49=\"$millions\",1000000,IF($E49=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!M19*IF('Input|Step changes'!$F19=\"nominal\",LOOKUP($F49,Nominal_to_Real,'Input|Rate of change'!Q$27: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'!$F49,'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($E49=\"$millions\",1000000,IF($E49=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!N19*IF('Input|Step changes'!$F19=\"nominal\",LOOKUP($F49,Nominal_to_Real,'Input|Rate of change'!R$27: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'!$F49,'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($E49=\"$millions\",1000000,IF($E49=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!O19*IF('Input|Step changes'!$F19=\"nominal\",LOOKUP($F49,Nominal_to_Real,'Input|Rate of change'!S$27: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'!$F49,'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($E49=\"$millions\",1000000,IF($E49=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!P19*IF('Input|Step changes'!$F19=\"nominal\",LOOKUP($F49,Nominal_to_Real,'Input|Rate of change'!T$27: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'!$F49,'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($E49=\"$millions\",1000000,IF($E49=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!Q19*IF('Input|Step changes'!$F19=\"nominal\",LOOKUP($F49,Nominal_to_Real,'Input|Rate of change'!U$27:U$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'!$F49,'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($E49=\"$millions\",1000000,IF($E49=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!R19*IF('Input|Step changes'!$F19=\"nominal\",LOOKUP($F49,Nominal_to_Real,'Input|Rate of change'!V$27:V$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'!$F49,'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($E49=\"$millions\",1000000,IF($E49=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!S19*IF('Input|Step changes'!$F19=\"nominal\",LOOKUP($F49,Nominal_to_Real,'Input|Rate of change'!W$27:W$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'!$F49,'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($E49=\"$millions\",1000000,IF($E49=\"$000\",1000,1))","v":0}]
[null,null,{"$f":"'Input|Step changes'!C20","v":0},"Calculated","$millions","2013-14",null,null,null,{"$f":"'Input|Step changes'!J20*IF('Input|Step changes'!$F20=\"nominal\",LOOKUP($F50,Nominal_to_Real,'Input|Rate of change'!N$27: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'!$F50,'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($E50=\"$millions\",1000000,IF($E50=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!K20*IF('Input|Step changes'!$F20=\"nominal\",LOOKUP($F50,Nominal_to_Real,'Input|Rate of change'!O$27: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'!$F50,'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($E50=\"$millions\",1000000,IF($E50=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!L20*IF('Input|Step changes'!$F20=\"nominal\",LOOKUP($F50,Nominal_to_Real,'Input|Rate of change'!P$27: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'!$F50,'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($E50=\"$millions\",1000000,IF($E50=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!M20*IF('Input|Step changes'!$F20=\"nominal\",LOOKUP($F50,Nominal_to_Real,'Input|Rate of change'!Q$27: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'!$F50,'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($E50=\"$millions\",1000000,IF($E50=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!N20*IF('Input|Step changes'!$F20=\"nominal\",LOOKUP($F50,Nominal_to_Real,'Input|Rate of change'!R$27: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'!$F50,'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($E50=\"$millions\",1000000,IF($E50=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!O20*IF('Input|Step changes'!$F20=\"nominal\",LOOKUP($F50,Nominal_to_Real,'Input|Rate of change'!S$27: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'!$F50,'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($E50=\"$millions\",1000000,IF($E50=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!P20*IF('Input|Step changes'!$F20=\"nominal\",LOOKUP($F50,Nominal_to_Real,'Input|Rate of change'!T$27: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'!$F50,'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($E50=\"$millions\",1000000,IF($E50=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!Q20*IF('Input|Step changes'!$F20=\"nominal\",LOOKUP($F50,Nominal_to_Real,'Input|Rate of change'!U$27:U$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'!$F50,'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($E50=\"$millions\",1000000,IF($E50=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!R20*IF('Input|Step changes'!$F20=\"nominal\",LOOKUP($F50,Nominal_to_Real,'Input|Rate of change'!V$27:V$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'!$F50,'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($E50=\"$millions\",1000000,IF($E50=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!S20*IF('Input|Step changes'!$F20=\"nominal\",LOOKUP($F50,Nominal_to_Real,'Input|Rate of change'!W$27:W$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'!$F50,'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($E50=\"$millions\",1000000,IF($E50=\"$000\",1000,1))","v":0}]
[null,null,{"$f":"'Input|Step changes'!C21","v":0},"Calculated","$millions","2013-14",null,null,null,{"$f":"'Input|Step changes'!J21*IF('Input|Step changes'!$F21=\"nominal\",LOOKUP($F51,Nominal_to_Real,'Input|Rate of change'!N$27: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'!$F51,'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($E51=\"$millions\",1000000,IF($E51=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!K21*IF('Input|Step changes'!$F21=\"nominal\",LOOKUP($F51,Nominal_to_Real,'Input|Rate of change'!O$27: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'!$F51,'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($E51=\"$millions\",1000000,IF($E51=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!L21*IF('Input|Step changes'!$F21=\"nominal\",LOOKUP($F51,Nominal_to_Real,'Input|Rate of change'!P$27: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'!$F51,'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($E51=\"$millions\",1000000,IF($E51=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!M21*IF('Input|Step changes'!$F21=\"nominal\",LOOKUP($F51,Nominal_to_Real,'Input|Rate of change'!Q$27: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'!$F51,'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($E51=\"$millions\",1000000,IF($E51=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!N21*IF('Input|Step changes'!$F21=\"nominal\",LOOKUP($F51,Nominal_to_Real,'Input|Rate of change'!R$27: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'!$F51,'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($E51=\"$millions\",1000000,IF($E51=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!O21*IF('Input|Step changes'!$F21=\"nominal\",LOOKUP($F51,Nominal_to_Real,'Input|Rate of change'!S$27: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'!$F51,'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($E51=\"$millions\",1000000,IF($E51=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!P21*IF('Input|Step changes'!$F21=\"nominal\",LOOKUP($F51,Nominal_to_Real,'Input|Rate of change'!T$27: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'!$F51,'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($E51=\"$millions\",1000000,IF($E51=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!Q21*IF('Input|Step changes'!$F21=\"nominal\",LOOKUP($F51,Nominal_to_Real,'Input|Rate of change'!U$27:U$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'!$F51,'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($E51=\"$millions\",1000000,IF($E51=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!R21*IF('Input|Step changes'!$F21=\"nominal\",LOOKUP($F51,Nominal_to_Real,'Input|Rate of change'!V$27:V$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'!$F51,'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($E51=\"$millions\",1000000,IF($E51=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!S21*IF('Input|Step changes'!$F21=\"nominal\",LOOKUP($F51,Nominal_to_Real,'Input|Rate of change'!W$27:W$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'!$F51,'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($E51=\"$millions\",1000000,IF($E51=\"$000\",1000,1))","v":0}]
[null,null,{"$f":"'Input|Step changes'!C22","v":0},"Calculated","$millions","2013-14",null,null,null,{"$f":"'Input|Step changes'!J22*IF('Input|Step changes'!$F22=\"nominal\",LOOKUP($F52,Nominal_to_Real,'Input|Rate of change'!N$27: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'!$F52,'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($E52=\"$millions\",1000000,IF($E52=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!K22*IF('Input|Step changes'!$F22=\"nominal\",LOOKUP($F52,Nominal_to_Real,'Input|Rate of change'!O$27: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'!$F52,'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($E52=\"$millions\",1000000,IF($E52=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!L22*IF('Input|Step changes'!$F22=\"nominal\",LOOKUP($F52,Nominal_to_Real,'Input|Rate of change'!P$27: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'!$F52,'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($E52=\"$millions\",1000000,IF($E52=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!M22*IF('Input|Step changes'!$F22=\"nominal\",LOOKUP($F52,Nominal_to_Real,'Input|Rate of change'!Q$27: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'!$F52,'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($E52=\"$millions\",1000000,IF($E52=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!N22*IF('Input|Step changes'!$F22=\"nominal\",LOOKUP($F52,Nominal_to_Real,'Input|Rate of change'!R$27: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'!$F52,'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($E52=\"$millions\",1000000,IF($E52=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!O22*IF('Input|Step changes'!$F22=\"nominal\",LOOKUP($F52,Nominal_to_Real,'Input|Rate of change'!S$27: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'!$F52,'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($E52=\"$millions\",1000000,IF($E52=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!P22*IF('Input|Step changes'!$F22=\"nominal\",LOOKUP($F52,Nominal_to_Real,'Input|Rate of change'!T$27: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'!$F52,'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($E52=\"$millions\",1000000,IF($E52=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!Q22*IF('Input|Step changes'!$F22=\"nominal\",LOOKUP($F52,Nominal_to_Real,'Input|Rate of change'!U$27:U$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'!$F52,'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($E52=\"$millions\",1000000,IF($E52=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!R22*IF('Input|Step changes'!$F22=\"nominal\",LOOKUP($F52,Nominal_to_Real,'Input|Rate of change'!V$27:V$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'!$F52,'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($E52=\"$millions\",1000000,IF($E52=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!S22*IF('Input|Step changes'!$F22=\"nominal\",LOOKUP($F52,Nominal_to_Real,'Input|Rate of change'!W$27:W$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'!$F52,'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($E52=\"$millions\",1000000,IF($E52=\"$000\",1000,1))","v":0}]
[null,null,{"$f":"'Input|Step changes'!C23","v":"Network support costs"},"Calculated","$millions","2013-14",null,null,null,{"$f":"'Input|Step changes'!J23*IF('Input|Step changes'!$F23=\"nominal\",LOOKUP($F53,Nominal_to_Real,'Input|Rate of change'!N$27: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'!$F53,'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($E53=\"$millions\",1000000,IF($E53=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!K23*IF('Input|Step changes'!$F23=\"nominal\",LOOKUP($F53,Nominal_to_Real,'Input|Rate of change'!O$27: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'!$F53,'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($E53=\"$millions\",1000000,IF($E53=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!L23*IF('Input|Step changes'!$F23=\"nominal\",LOOKUP($F53,Nominal_to_Real,'Input|Rate of change'!P$27: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'!$F53,'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($E53=\"$millions\",1000000,IF($E53=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!M23*IF('Input|Step changes'!$F23=\"nominal\",LOOKUP($F53,Nominal_to_Real,'Input|Rate of change'!Q$27: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'!$F53,'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($E53=\"$millions\",1000000,IF($E53=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!N23*IF('Input|Step changes'!$F23=\"nominal\",LOOKUP($F53,Nominal_to_Real,'Input|Rate of change'!R$27: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'!$F53,'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($E53=\"$millions\",1000000,IF($E53=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!O23*IF('Input|Step changes'!$F23=\"nominal\",LOOKUP($F53,Nominal_to_Real,'Input|Rate of change'!S$27: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'!$F53,'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($E53=\"$millions\",1000000,IF($E53=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!P23*IF('Input|Step changes'!$F23=\"nominal\",LOOKUP($F53,Nominal_to_Real,'Input|Rate of change'!T$27: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'!$F53,'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($E53=\"$millions\",1000000,IF($E53=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!Q23*IF('Input|Step changes'!$F23=\"nominal\",LOOKUP($F53,Nominal_to_Real,'Input|Rate of change'!U$27:U$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'!$F53,'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($E53=\"$millions\",1000000,IF($E53=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!R23*IF('Input|Step changes'!$F23=\"nominal\",LOOKUP($F53,Nominal_to_Real,'Input|Rate of change'!V$27:V$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'!$F53,'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($E53=\"$millions\",1000000,IF($E53=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!S23*IF('Input|Step changes'!$F23=\"nominal\",LOOKUP($F53,Nominal_to_Real,'Input|Rate of change'!W$27:W$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'!$F53,'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($E53=\"$millions\",1000000,IF($E53=\"$000\",1000,1))","v":0}]
[]
[null,null,"Total step changes","Calculated",{"$f":"$E$8","v":"$millions"},{"$f":"$F$8","v":"2013-14"},null,null,null,{"$f":"SUM(J42:J54)","v":0},{"$f":"SUM(K42:K54)","v":0},0,0,0,{"$f":"SUM(O42:O54)","v":0},0,0,0,0]
[]
[null,"Calc | Total forecast operating expenditure"]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(RIGHT(J$4,2)>=RIGHT('Input|General'!$G$9,2),IF(RIGHT(J$4,2)<=RIGHT('Input|General'!$G$12,2),J$4,\"\"),\"\")","v":""},{"$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":"2012-13"},{"$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":"2013-14"},{"$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":"2014-15"},{"$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":"2015-16"},{"$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":"2016-17"},{"$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":"2017-18"},{"$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":"2018-19"}]
[]
[null,null,"Total forecast opex, excluding debt raising and network support costs","Calculated",{"$f":"$E$8","v":"$millions"},{"$f":"$F$8","v":"2013-14"},null,null,null,{"$f":"J13","v":0},0,0,{"$f":"M13","v":46.295418881333532},{"$f":"N19","v":45.909803521784006},{"$f":"IF(RIGHT(O$4,2)>=RIGHT('Input|General'!$G$11,2),IF(RIGHT(O$4,2)<='Input|General'!$G$12,IF(ISBLANK(O59),\"\",PRODUCT(1+$J36:O36)*SUM($J23:$S23)+O55)-O53,\"\"),\"\")","v":45.933443330154631},{"$f":"IF(RIGHT(P$4,2)>=RIGHT('Input|General'!$G$11,2),IF(RIGHT(P$4,2)<='Input|General'!$G$12,IF(ISBLANK(P59),\"\",PRODUCT(1+$J36:P36)*SUM($J23:$S23)+P55),\"\"),\"\")","v":45.855056991984888},{"$f":"IF(RIGHT(Q$4,2)>=RIGHT('Input|General'!$G$11,2),IF(RIGHT(Q$4,2)<='Input|General'!$G$12,IF(ISBLANK(Q59),\"\",PRODUCT(1+$J36:Q36)*SUM($J23:$S23)+Q55),\"\"),\"\")","v":45.940937087781741},{"$f":"IF(RIGHT(R$4,2)>=RIGHT('Input|General'!$G$11,2),IF(RIGHT(R$4,2)<='Input|General'!$G$12,IF(ISBLANK(R59),\"\",PRODUCT(1+$J36:R36)*SUM($J23:$S23)+R55),\"\"),\"\")","v":46.790464981230357},{"$f":"IF(RIGHT(S$4,2)>=RIGHT('Input|General'!$G$11,2),IF(RIGHT(S$4,2)<='Input|General'!$G$12,IF(ISBLANK(S59),\"\",PRODUCT(1+$J36:S36)*SUM($J23:$S23)+S55),\"\"),\"\")","v":46.886734310025574}]
[]
[null,null,"Total forecast opex, including debt raising costs and network support costs","Calculated",{"$f":"$E$8","v":"$millions"},{"$f":"$F$8","v":"2013-14"},null,null,null,{"$f":"J61+J53+'Input|Step changes'!J29","v":0},{"$f":"K61+K53+'Input|Step changes'!K29","v":0},{"$f":"L61+L53+'Input|Step changes'!L29","v":0},{"$f":"M61+M53+'Input|Step changes'!M29","v":46.295418881333532},{"$f":"N61+N53+'Input|Step changes'!N29","v":45.909803521784006},{"$f":"O61+O53+'Input|Step changes'!O29","v":46.669181885700546},{"$f":"P61+P53+'Input|Step changes'!P29","v":46.590680141532346},{"$f":"Q61+Q53+'Input|Step changes'!Q29","v":46.682283399598177},{"$f":"R61+R53+'Input|Step changes'!R29","v":47.529911128417822},{"$f":"S61+S53+'Input|Step changes'!S29","v":47.620076482677042}]
[]
[null,"End"]

{"sheet":"Output|Models","index":7,"n_rows":23,"n_cols":22,"rows_kept":23,"cut":false,"hidden":false,"merged":[[2,9,2,11],[2,13,2,18]]}
[null,{"$f":"Index!$B$1","v":"AER opex model"},null,null,null,null,null,null,null,"Back to Index",null,"Key:","Input","External Link","Internal Link",null,null,"Worksheet check:",{"$f":"IF(COUNTA($W$14:$W$479)=COUNTIF($W$14:$W$479,\"OK\"),\"OK\",\"Check\")","v":"OK"},null,"Overall Check:",{"$f":"'Check|List'!$S$1","v":"Ok"}]
[null,{"$f":"Index!$C$13","v":"Output | Models"}]
[]
[null,null,null,"Source","Unit","Basis",null,null,null,{"$f":"'Input|General'!$G$8","v":"2009-10"},{"$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":"2010-11"},{"$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":"2011-12"},{"$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":"2012-13"},{"$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":"2013-14"},{"$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":"2014-15"},{"$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":"2015-16"},{"$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":"2016-17"},{"$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":"2017-18"},{"$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":"2018-19"}]
[]
[]
[]
[null,"Inputs for Post Tax Revenue Model",null,null,"$millions","2013-14",null,null,null,"Note. The dollar base should be consistent with the post tax revenue model"]
[]
[]
[null,null,"Operating expenditure","Source","Unit","Basis",null,null,null,{"$f":"IF(RIGHT(J$4,2)>=RIGHT('Input|General'!$G$11,2),IF(RIGHT(J$4,2)<=RIGHT('Input|General'!$G$12,2),J$4,\"\"),\"\")","v":""},{"$f":"IF(RIGHT(K$4,2)>=RIGHT('Input|General'!$G$11,2),IF(RIGHT(K$4,2)<=RIGHT('Input|General'!$G$12,2),K$4,\"\"),\"\")","v":""},{"$f":"IF(RIGHT(L$4,2)>=RIGHT('Input|General'!$G$11,2),IF(RIGHT(L$4,2)<=RIGHT('Input|General'!$G$12,2),L$4,\"\"),\"\")","v":""},{"$f":"IF(RIGHT(M$4,2)>=RIGHT('Input|General'!$G$11,2),IF(RIGHT(M$4,2)<=RIGHT('Input|General'!$G$12,2),M$4,\"\"),\"\")","v":""},{"$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":"2014-15"},{"$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":"2015-16"},{"$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":"2016-17"},{"$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":"2017-18"},{"$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":"2018-19"},null,"Notes"]
[null,null,"Forecast operating expenditure (excl. DRC)","Calc | Opex forecast",{"$f":"$E$8","v":"$millions"},{"$f":"$F$8","v":"2013-14"},null,null,null,{"$f":"IF(J11=\"\",0,'Calc|Opex forecast'!J61*IF('Calc|Opex forecast'!$F$61=\"nominal\",LOOKUP($F12,Nominal_to_Real,'Input|Rate of change'!P$27:P$32),INDEX('Input|Rate of change'!$C$14:$O$22,MATCH('Calc|Opex forecast'!$F$61,'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$61=\"$millions\",1000000,IF('Output|Models'!B55=\"$000\",1000,1))/IF($E12=\"$millions\",1000000,IF($E12=\"$000\",1000,1)))","v":0},{"$f":"IF(K11=\"\",0,'Calc|Opex forecast'!K61*IF('Calc|Opex forecast'!$F$61=\"nominal\",LOOKUP($F12,Nominal_to_Real,'Input|Rate of change'!Q$27:Q$32),INDEX('Input|Rate of change'!$C$14:$O$22,MATCH('Calc|Opex forecast'!$F$61,'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$61=\"$millions\",1000000,IF('Output|Models'!C55=\"$000\",1000,1))/IF($E12=\"$millions\",1000000,IF($E12=\"$000\",1000,1)))","v":0},{"$f":"IF(L11=\"\",0,'Calc|Opex forecast'!L61*IF('Calc|Opex forecast'!$F$61=\"nominal\",LOOKUP($F12,Nominal_to_Real,'Input|Rate of change'!R$27:R$32),INDEX('Input|Rate of change'!$C$14:$O$22,MATCH('Calc|Opex forecast'!$F$61,'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$61=\"$millions\",1000000,IF('Output|Models'!D55=\"$000\",1000,1))/IF($E12=\"$millions\",1000000,IF($E12=\"$000\",1000,1)))","v":0},{"$f":"IF(M11=\"\",0,'Calc|Opex forecast'!M61*IF('Calc|Opex forecast'!$F$61=\"nominal\",LOOKUP($F12,Nominal_to_Real,'Input|Rate of change'!S$27:S$32),INDEX('Input|Rate of change'!$C$14:$O$22,MATCH('Calc|Opex forecast'!$F$61,'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$61=\"$millions\",1000000,IF('Output|Models'!E55=\"$000\",1000,1))/IF($E12=\"$millions\",1000000,IF($E12=\"$000\",1000,1)))","v":0},{"$f":"IF(N11=\"\",0,'Calc|Opex forecast'!N61*IF('Calc|Opex forecast'!$F$61=\"nominal\",LOOKUP($F12,Nominal_to_Real,'Input|Rate of change'!T$27:T$32),INDEX('Input|Rate of change'!$C$14:$O$22,MATCH('Calc|Opex forecast'!$F$61,'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$61=\"$millions\",1000000,IF('Output|Models'!F55=\"$000\",1000,1))/IF($E12=\"$millions\",1000000,IF($E12=\"$000\",1000,1)))","v":0},{"$f":"IF(O11=\"\",0,'Calc|Opex forecast'!O61*IF('Calc|Opex forecast'!$F$61=\"nominal\",LOOKUP($F12,Nominal_to_Real,'Input|Rate of change'!U$27:U$32),INDEX('Input|Rate of change'!$C$14:$O$22,MATCH('Calc|Opex forecast'!$F$61,'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$61=\"$millions\",1000000,IF('Output|Models'!G55=\"$000\",1000,1))/IF($E12=\"$millions\",1000000,IF($E12=\"$000\",1000,1)))","v":45.933443330154624},{"$f":"IF(P11=\"\",0,'Calc|Opex forecast'!P61*IF('Calc|Opex forecast'!$F$61=\"nominal\",LOOKUP($F12,Nominal_to_Real,'Input|Rate of change'!V$27:V$32),INDEX('Input|Rate of change'!$C$14:$O$22,MATCH('Calc|Opex forecast'!$F$61,'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$61=\"$millions\",1000000,IF('Output|Models'!H55=\"$000\",1000,1))/IF($E12=\"$millions\",1000000,IF($E12=\"$000\",1000,1)))","v":45.855056991984888},{"$f":"IF(Q11=\"\",0,'Calc|Opex forecast'!Q61*IF('Calc|Opex forecast'!$F$61=\"nominal\",LOOKUP($F12,Nominal_to_Real,'Input|Rate of change'!W$27:W$32),INDEX('Input|Rate of change'!$C$14:$O$22,MATCH('Calc|Opex forecast'!$F$61,'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$61=\"$millions\",1000000,IF('Output|Models'!I55=\"$000\",1000,1))/IF($E12=\"$millions\",1000000,IF($E12=\"$000\",1000,1)))","v":45.940937087781741},{"$f":"IF(R11=\"\",0,'Calc|Opex forecast'!R61*IF('Calc|Opex forecast'!$F$61=\"nominal\",LOOKUP($F12,Nominal_to_Real,'Input|Rate of change'!X$27:X$32),INDEX('Input|Rate of change'!$C$14:$O$22,MATCH('Calc|Opex forecast'!$F$61,'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$61=\"$millions\",1000000,IF('Output|Models'!J55=\"$000\",1000,1))/IF($E12=\"$millions\",1000000,IF($E12=\"$000\",1000,1)))","v":46.790464981230357},{"$f":"IF(S11=\"\",0,'Calc|Opex forecast'!S61*IF('Calc|Opex forecast'!$F$61=\"nominal\",LOOKUP($F12,Nominal_to_Real,'Input|Rate of change'!Y$27:Y$32),INDEX('Input|Rate of change'!$C$14:$O$22,MATCH('Calc|Opex forecast'!$F$61,'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$61=\"$millions\",1000000,IF('Output|Models'!K55=\"$000\",1000,1))/IF($E12=\"$millions\",1000000,IF($E12=\"$000\",1000,1)))","v":46.886734310025574},null,"Excludes debt raising costs "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(O12:S12)","v":231.40663670117721}]
[]
[null,null,"Debt raising costs (included in opex)","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":"2014-15"},{"$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":"2015-16"},{"$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":"2016-17"},{"$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":"2017-18"},{"$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":"2018-19"},null,"Notes"]
[null,null,"Debt raising costs","Input | Step changes",{"$f":"$E$8","v":"$millions"},{"$f":"$F$8","v":"2013-14"},null,null,null,{"$f":"IF(J11=\"\",0,'Input|Step changes'!J29*IF('Input|Step changes'!$F$29=\"nominal\",LOOKUP($F16,Nominal_to_Real,'Input|Rate of change'!P$27:P$32),INDEX('Input|Rate of change'!$C$14:$O$22,MATCH('Input|Step changes'!$F$29,'Input|Rate of change'!$C$14:$C$22,0),MATCH('Output|Models'!$F16,'Input|Rate of change'!$C$14:$O$14,0)))*IF('Input|Step changes'!$E29=\"$millions\",1000000,IF('Input|Step changes'!$E29=\"$000\",1000,1))/IF($E16=\"$millions\",1000000,IF($E16=\"$000\",1000,1)))","v":0},{"$f":"IF(K11=\"\",0,'Input|Step changes'!K29*IF('Input|Step changes'!$F$29=\"nominal\",LOOKUP($F16,Nominal_to_Real,'Input|Rate of change'!Q$27:Q$32),INDEX('Input|Rate of change'!$C$14:$O$22,MATCH('Input|Step changes'!$F$29,'Input|Rate of change'!$C$14:$C$22,0),MATCH('Output|Models'!$F16,'Input|Rate of change'!$C$14:$O$14,0)))*IF('Input|Step changes'!$E29=\"$millions\",1000000,IF('Input|Step changes'!$E29=\"$000\",1000,1))/IF($E16=\"$millions\",1000000,IF($E16=\"$000\",1000,1)))","v":0},{"$f":"IF(L11=\"\",0,'Input|Step changes'!L29*IF('Input|Step changes'!$F$29=\"nominal\",LOOKUP($F16,Nominal_to_Real,'Input|Rate of change'!R$27:R$32),INDEX('Input|Rate of change'!$C$14:$O$22,MATCH('Input|Step changes'!$F$29,'Input|Rate of change'!$C$14:$C$22,0),MATCH('Output|Models'!$F16,'Input|Rate of change'!$C$14:$O$14,0)))*IF('Input|Step changes'!$E29=\"$millions\",1000000,IF('Input|Step changes'!$E29=\"$000\",1000,1))/IF($E16=\"$millions\",1000000,IF($E16=\"$000\",1000,1)))","v":0},{"$f":"IF(M11=\"\",0,'Input|Step changes'!M29*IF('Input|Step changes'!$F$29=\"nominal\",LOOKUP($F16,Nominal_to_Real,'Input|Rate of change'!S$27:S$32),INDEX('Input|Rate of change'!$C$14:$O$22,MATCH('Input|Step changes'!$F$29,'Input|Rate of change'!$C$14:$C$22,0),MATCH('Output|Models'!$F16,'Input|Rate of change'!$C$14:$O$14,0)))*IF('Input|Step changes'!$E29=\"$millions\",1000000,IF('Input|Step changes'!$E29=\"$000\",1000,1))/IF($E16=\"$millions\",1000000,IF($E16=\"$000\",1000,1)))","v":0},{"$f":"IF(N11=\"\",0,'Input|Step changes'!N29*IF('Input|Step changes'!$F$29=\"nominal\",LOOKUP($F16,Nominal_to_Real,'Input|Rate of change'!T$27:T$32),INDEX('Input|Rate of change'!$C$14:$O$22,MATCH('Input|Step changes'!$F$29,'Input|Rate of change'!$C$14:$C$22,0),MATCH('Output|Models'!$F16,'Input|Rate of change'!$C$14:$O$14,0)))*IF('Input|Step changes'!$E29=\"$millions\",1000000,IF('Input|Step changes'!$E29=\"$000\",1000,1))/IF($E16=\"$millions\",1000000,IF($E16=\"$000\",1000,1)))","v":0},{"$f":"IF(O11=\"\",0,'Input|Step changes'!O29*IF('Input|Step changes'!$F$29=\"nominal\",LOOKUP($F16,Nominal_to_Real,'Input|Rate of change'!U$27:U$32),INDEX('Input|Rate of change'!$C$14:$O$22,MATCH('Input|Step changes'!$F$29,'Input|Rate of change'!$C$14:$C$22,0),MATCH('Output|Models'!$F16,'Input|Rate of change'!$C$14:$O$14,0)))*IF('Input|Step changes'!$E29=\"$millions\",1000000,IF('Input|Step changes'!$E29=\"$000\",1000,1))/IF($E16=\"$millions\",1000000,IF($E16=\"$000\",1000,1)))","v":0.73573855554591672},{"$f":"IF(P11=\"\",0,'Input|Step changes'!P29*IF('Input|Step changes'!$F$29=\"nominal\",LOOKUP($F16,Nominal_to_Real,'Input|Rate of change'!V$27:V$32),INDEX('Input|Rate of change'!$C$14:$O$22,MATCH('Input|Step changes'!$F$29,'Input|Rate of change'!$C$14:$C$22,0),MATCH('Output|Models'!$F16,'Input|Rate of change'!$C$14:$O$14,0)))*IF('Input|Step changes'!$E29=\"$millions\",1000000,IF('Input|Step changes'!$E29=\"$000\",1000,1))/IF($E16=\"$millions\",1000000,IF($E16=\"$000\",1000,1)))","v":0.73562314954745545},{"$f":"IF(Q11=\"\",0,'Input|Step changes'!Q29*IF('Input|Step changes'!$F$29=\"nominal\",LOOKUP($F16,Nominal_to_Real,'Input|Rate of change'!W$27:W$32),INDEX('Input|Rate of change'!$C$14:$O$22,MATCH('Input|Step changes'!$F$29,'Input|Rate of change'!$C$14:$C$22,0),MATCH('Output|Models'!$F16,'Input|Rate of change'!$C$14:$O$14,0)))*IF('Input|Step changes'!$E29=\"$millions\",1000000,IF('Input|Step changes'!$E29=\"$000\",1000,1))/IF($E16=\"$millions\",1000000,IF($E16=\"$000\",1000,1)))","v":0.74134631181643684},{"$f":"IF(R11=\"\",0,'Input|Step changes'!R29*IF('Input|Step changes'!$F$29=\"nominal\",LOOKUP($F16,Nominal_to_Real,'Input|Rate of change'!X$27:X$32),INDEX('Input|Rate of change'!$C$14:$O$22,MATCH('Input|Step changes'!$F$29,'Input|Rate of change'!$C$14:$C$22,0),MATCH('Output|Models'!$F16,'Input|Rate of change'!$C$14:$O$14,0)))*IF('Input|Step changes'!$E29=\"$millions\",1000000,IF('Input|Step changes'!$E29=\"$000\",1000,1))/IF($E16=\"$millions\",1000000,IF($E16=\"$000\",1000,1)))","v":0.73944614718746204},{"$f":"IF(S11=\"\",0,'Input|Step changes'!S29*IF('Input|Step changes'!$F$29=\"nominal\",LOOKUP($F16,Nominal_to_Real,'Input|Rate of change'!Y$27:Y$32),INDEX('Input|Rate of change'!$C$14:$O$22,MATCH('Input|Step changes'!$F$29,'Input|Rate of change'!$C$14:$C$22,0),MATCH('Output|Models'!$F16,'Input|Rate of change'!$C$14:$O$14,0)))*IF('Input|Step changes'!$E29=\"$millions\",1000000,IF('Input|Step changes'!$E29=\"$000\",1000,1))/IF($E16=\"$millions\",1000000,IF($E16=\"$000\",1000,1)))","v":0.73334217265146806}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(O16:S16)","v":3.6854963367487392}]
[]
[null,null,"Operating expenditure allowances","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":"2014-15"},{"$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":"2015-16"},{"$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":"2016-17"},{"$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":"2017-18"},{"$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":"2018-19"},null,"Notes"]
[null,null,"Forecast operating expenditure (incl. DRC)","Calc|Opex Summary (view 1)",{"$f":"$E$8","v":"$millions"},{"$f":"$F$8","v":"2013-14"},null,null,null,{"$f":"J16+J12","v":0},{"$f":"K16+K12","v":0},0,0,0,46.669181885700539,46.590680141532346,46.682283399598177,47.529911128417822,47.620076482677042,null,"Includes debt raising costs"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(O20:S20)","v":235.09213303792595}]
[]
[null,"End"]

{"sheet":"Output|Decision tables","index":8,"n_rows":19,"n_cols":22,"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,"Worksheet check:",null,null,"Overall Check:",{"$f":"'Check|List'!$S$1","v":"Ok"}]
[null,{"$f":"Index!$C$14","v":"Output | Decision tables"}]
[]
[]
[]
[]
[null,"Table X.1","Our draft decision on total opex ($million 2013–14)",null,null,null,"Choose dollar basis",{"$f":"'Calc|Opex forecast'!F8","v":"2013-14"}]
[]
[null,null,"2014–15","2015–16","2016–17","2017–18","2018–19","Total"]
[null,"TasNetworks' proposal",43.056313060717393,42.455470219856934,42.680972114185515,42.905571770648322,42.421933633489509,{"$f":"SUM(C10:G10)","v":213.52026079889768},null,"Excludes debt raising costs"]
[null,"AER alternative forecast",{"$f":"'Calc|Opex forecast'!O61","v":45.933443330154631},{"$f":"'Calc|Opex forecast'!P61","v":45.855056991984888},{"$f":"'Calc|Opex forecast'!Q61","v":45.940937087781741},{"$f":"'Calc|Opex forecast'!R61","v":46.790464981230357},{"$f":"'Calc|Opex forecast'!S61","v":46.886734310025574},{"$f":"SUM(C11:G11)","v":231.40663670117721}]
[null,"Difference",{"$f":"C11-C10","v":2.877130269437238},{"$f":"D11-D10","v":3.3995867721279538},3.2599649735962259,3.8848932105820353,{"$f":"G11-G10","v":4.4648006765360648},{"$f":"SUM(C12:G12)","v":17.886375902279518}]
[]
[null,null,"2014–15","2015–16","2016–17","2017–18","2018–19","Total"]
[null,"TasNetworks' proposal",44.007198952090185,43.406553172998535,43.640687773711043,43.867839857018978,43.38250439141644,{"$f":"SUM(C15:G15)","v":218.30478414723518},null,"Includes debt raising costs"]
[null,"AER alternative forecast",{"$f":"'Calc|Opex forecast'!O63","v":46.669181885700546},{"$f":"'Calc|Opex forecast'!P63","v":46.590680141532346},{"$f":"'Calc|Opex forecast'!Q63","v":46.682283399598177},{"$f":"'Calc|Opex forecast'!R63","v":47.529911128417822},{"$f":"'Calc|Opex forecast'!S63","v":47.620076482677042},{"$f":"SUM(C16:G16)","v":235.09213303792595}]
[null,"Difference",{"$f":"C16-C15","v":2.6619829336103606},{"$f":"D16-D15","v":3.1841269685338105},3.0415956258871333,3.6620712713988439,{"$f":"G16-G15","v":4.2375720912606027},{"$f":"SUM(C17:G17)","v":16.787348890690751}]
[]
[null,"End"]

{"sheet":"Lookup|Tables","index":9,"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,"2007-08","AER",null,null,"2007-08"]
[null,null,"2008-09","AER",null,null,"2008-09"]
[null,null,"2009-10","AER",null,null,"2009-10"]
[null,null,"2010-11","AER",null,null,"2010-11"]
[null,null,"2011-12","AER",null,null,"2011-12"]
[null,null,"2012-13","AER",null,null,"2012-13"]
[null,null,"2013-14","AER",null,null,"2013-14"]
[null,null,"2014-15","AER",null,null,"2014-15"]
[null,null,"2015-16","AER",null,null,"2015-16"]
[null,null,"2016-17","AER",null,null,"2016-17"]
[null,null,"2017-18","AER",null,null,"2017-18"]
[null,null,"2018-19","AER",null,null,"2018-19"]
[null,null,"2019-20","AER",null,null,"2019-20"]
[null,null,"2020-21","AER",null,null,"2020-21"]
[null,null,"2021-22","AER",null,null,"2021-22"]
[null,null,"2022-23","AER",null,null,"2022-23"]
[null,null,"2023-24","AER",null,null,"2023-24"]
[]
[null,"End"]

{"sheet":"Check|List","index":10,"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!C9","v":"Input | Reported opex"},{"$f":"C11","v":"Input | Reported opex"},"Ok/Check",null,{"$f":"'Input|Reported opex'!S1","v":"OK"}]
[null,null,{"$f":"Index!C10","v":"Input | Rate of change"},"Input | Rate of change","Ok/Check",null,{"$f":"'Input|Rate of change'!T1","v":"Ok"}]
[null,null,{"$f":"Index!C11","v":"Input | Step changes"},"Input | Step changes","Ok/Check",null,{"$f":"'Input|Step changes'!S1","v":"OK"}]
[null,null,{"$f":"Index!C12","v":"Calc | Opex Forecast"},"Calc | Opex Forecast","Ok/Check",null,{"$f":"'Calc|Opex forecast'!S1","v":"n/a"}]
[null,null,{"$f":"Index!C13","v":"Output | Models"},"Output | Models","Ok/Check",null,{"$f":"'Output|Models'!S1","v":"OK"}]
[null,null,{"$f":"Index!C14","v":"Output | Decision tables"},"Output | Decision tables","Ok/Check",null,{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,{"$f":"Index!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},"Ok/Check",null,{"$f":"#REF!","v":{"$error":"#REF!"}}]
[]
[null,"End"]