{"text_format":"1","workbook":"xlsx","n_sheets":12,"sheets":["Index","Input|General","Input|Inflation","Input|Reported opex","Input|Rate of change","Input|Step changes","Input|Dx Tx split","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":19,"n_cols":4,"rows_kept":19,"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,"Input | Dx TX split","Inputs the split of total opex bewteen distribution and transmission services."]
[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,"Ausgrid",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTBLANK($G7),\"Check\",\"Ok\")","v":"Ok"}]
[null,null,"Prior regulatory control period, first year","NSP",null,null,"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, sum of four quarters, 18 month lag, old base","Index value, sum of four quarters, 18 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,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ok"]
[null,null,"2008-09-30",166.5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ok"]
[null,null,"2008-12-31",166,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ok"]
[null,null,"2009-03-31",166.2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ok"]
[null,null,"2009-06-30",167,null,{"$f":"AVERAGE(D9:D12)","v":157.95000000000002},null,null,null,null,null,null,null,null,null,null,null,null,"Ok"]
[null,null,"2009-09-30",168.6,null,{"$f":"AVERAGE(D10:D13)","v":159.60000000000002},null,null,null,null,null,null,null,null,null,null,null,null,"Ok"]
[null,null,"2009-12-31",169.5,null,161.375,null,null,null,null,null,null,null,null,null,null,null,null,"Ok"]
[null,null,"2010-03-31",171,95.2,163.35,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,164.82499999999999,null,null,null,null,null,null,null,null,null,null,null,null,"Ok"]
[null,null,"2010-09-30",173.3,96.5,165.82499999999999,null,null,null,null,null,null,null,null,null,null,null,null,"Ok"]
[null,null,"2010-12-31",174,96.9,166.42500000000001,null,null,null,null,null,null,null,null,null,null,null,null,"Ok"]
[null,null,"2011-03-31",176.7,98.3,166.95,null,null,null,null,null,null,null,null,null,null,null,null,"Ok"]
[null,null,"2011-06-30",178.3,99.2,167.82499999999999,null,null,null,null,null,null,null,null,null,null,null,null,"Ok"]
[null,null,"2011-09-30",179.4,99.8,169.02500000000001,null,null,null,null,null,null,null,null,null,null,null,null,"Ok"]
[null,null,"2011-12-31",179.4,99.8,170.3,null,null,null,null,null,null,null,null,null,null,null,null,"Ok"]
[null,null,"2012-03-31",179.5,99.9,171.47500000000002,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTBLANK($E29),\"Check\",\"Ok\")","v":"Ok"}]
[null,null,"2012-06-30",null,100.4,172.60000000000002,{"$f":"AVERAGE(E21:E24)","v":96.1},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,174.02499999999998,{"$f":"AVERAGE(E22:E25)","v":96.875000000000014},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,175.57499999999999,97.724999999999994,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,177.1,98.55,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,178.45,99.275000000000006,null,null,null,null,null,null,null,null,null,null,null,"Ok"]
[null,null,"2013-09-30",null,104,null,99.675000000000011,null,null,null,null,null,null,null,null,null,null,null,"Ok"]
[null,null,"2013-12-31",null,104.8,null,99.974999999999994,null,null,null,null,null,null,null,null,null,null,null,"Ok"]
[null,null,"2014-03-31",null,105.4,null,100.47500000000001,null,null,null,null,null,null,null,null,null,null,null,"Ok"]
[null,null,"2014-06-30",null,105.9,null,101.02500000000001,null,null,null,null,null,null,null,null,null,null,null,"Ok"]
[]
[null,"End"]

{"sheet":"Input|Reported opex","index":3,"n_rows":60,"n_cols":22,"rows_kept":60,"cut":false,"hidden":false,"merged":[]}
[null,null,{"$f":"Index!$B$1","v":"AER opex model"},null,null,null,null,null,null,"Back to Index",null,"Key:","Input","External Link","Internal Link",null,null,"Worksheet check:",{"$f":"IF(COUNTA($W$32:$W$253)=COUNTIF($W$32:$W$253,\"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,507.33752893950412,517.87749633495775,528.83456123144299,538.56409571815948,539.96744020624601]
[null,null,"Remove debt raising costs","AER",{"$f":"$E$24","v":"$millions"},{"$f":"$F$24","v":"2008-09"},null,null,null,-3.8997943957646299,-4.4536284487435598,-4.9986396975862304,-5.6140574943827097,-6.2156162862668598]
[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,null,"AER","$millions","2008-09"]
[]
[null,null,"Total opex","Calculated","$millions","2008-09",null,null,null,{"$f":"SUM(J13:J22)","v":503.43773454373951},513.42386788621423,523.83592153385678,532.9500382237768,533.75182391997919,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,538.7831066872634,534.76227143769256,608.42463282057793,503.58229615051454]
[null,null,"Remove debt raising costs","RIN",{"$f":"$E$43","v":"$millions"},{"$f":"$F$43","v":"nominal"},null,null,null,-0.15371898702565001,-0.17955033459,-0.29948589623999999,-0.36057828649000001]
[null,null,null,"RIN","$millions","nominal"]
[null,null,null,"RIN","$millions","nominal"]
[null,null,null,"RIN","$millions","nominal"]
[null,null,null,"RIN","$millions","nominal"]
[null,null,null,"RIN","$millions","nominal"]
[null,null,null,"RIN","$millions","nominal"]
[null,null,null,"RIN","$millions","nominal"]
[null,null,null,"RIN","$millions","nominal"]
[]
[null,null,"Total opex","Calculated","$millions","nominal",null,null,null,{"$f":"SUM(J32:J41)","v":538.62938770023777},{"$f":"SUM(K32:K41)","v":534.58272110310259},608.12514692433797,503.22171786402453,0,0,0,0,0,0]
[]
[null,"Input | CAM adjustment"]
[]
[null,null,"Cost allocation method adjustment","Source","Unit","Basis",null,null,null,{"$f":"IF(RIGHT(J4,2)=RIGHT('Input|General'!$G$10,2),'Input|Reported opex'!J4,\"\")","v":""},{"$f":"IF(RIGHT(K4,2)=RIGHT('Input|General'!$G$10,2),'Input|Reported opex'!K4,\"\")","v":""},{"$f":"IF(RIGHT(L4,2)=RIGHT('Input|General'!$G$10,2),'Input|Reported opex'!L4,\"\")","v":""},{"$f":"IF(RIGHT(M4,2)=RIGHT('Input|General'!$G$10,2),'Input|Reported opex'!M4,\"\")","v":""},{"$f":"IF(RIGHT(N$4,2)=RIGHT('Input|General'!$G$10,2),N$4,\"\")","v":"2013-14"}]
[null,null,{"$f":"C47","v":"Cost allocation method adjustment"},"External",{"$f":"$E$43","v":"$millions"},{"$f":"$F$43","v":"nominal"},null,null,null,null,null,null,null,3.8042128679721166]
[]
[null,"Input | Service classification adjustment"]
[]
[null,null,"Service classification adjustment","Source","Unit","Basis",null,null,null,{"$f":"IF(RIGHT(J9,2)=RIGHT('Input|General'!$G$10,2),'Input|Reported opex'!J9,\"\")","v":""},{"$f":"IF(RIGHT(K9,2)=RIGHT('Input|General'!$G$10,2),'Input|Reported opex'!K9,\"\")","v":""},{"$f":"IF(RIGHT(L9,2)=RIGHT('Input|General'!$G$10,2),'Input|Reported opex'!L9,\"\")","v":""},{"$f":"IF(RIGHT(M9,2)=RIGHT('Input|General'!$G$10,2),'Input|Reported opex'!M9,\"\")","v":""},{"$f":"IF(RIGHT(N$4,2)=RIGHT('Input|General'!$G$10,2),N$4,\"\")","v":"2013-14"}]
[null,null,{"$f":"C52","v":"Service classification adjustment"},"External",{"$f":"$E$43","v":"$millions"},{"$f":"$F$43","v":"nominal"},null,null,null,null,null,null,null,-35.648836792211107]
[]
[null,"Input | Efficiency adjustment"]
[]
[null,null,"Efficiency adjustment","Source","Unit",null,null,null,null,{"$f":"IF(RIGHT(J14,2)=RIGHT('Input|General'!$G$10,2),'Input|Reported opex'!J14,\"\")","v":""},{"$f":"IF(RIGHT(K14,2)=RIGHT('Input|General'!$G$10,2),'Input|Reported opex'!K14,\"\")","v":""},{"$f":"IF(RIGHT(L14,2)=RIGHT('Input|General'!$G$10,2),'Input|Reported opex'!L14,\"\")","v":""},{"$f":"IF(RIGHT(M14,2)=RIGHT('Input|General'!$G$10,2),'Input|Reported opex'!M14,\"\")","v":""},{"$f":"IF(RIGHT(N$4,2)=RIGHT('Input|General'!$G$10,2),N$4,\"\")","v":"2013-14"}]
[null,null,"Efficiency adjustment","External","Per cent",null,null,null,null,null,null,null,null,-0.33302764408880514]
[]
[null,"End"]

{"sheet":"Input|Rate of change","index":4,"n_rows":95,"n_cols":23,"rows_kept":95,"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:W94,\"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,null,{"$f":"'Input|Inflation'!F22/'Input|Inflation'!F18-1","v":4.3526432415321059E-2},{"$f":"'Input|Inflation'!F26/'Input|Inflation'!F22-1","v":1.8201122402548231E-2},{"$f":"'Input|Inflation'!F30/'Input|Inflation'!F26-1","v":2.845225681513508E-2},{"$f":"'Input|Inflation'!F34/'Input|Inflation'!F30-1","v":3.3893395133255844E-2},{"$f":"'Input|Inflation'!G38/'Input|Inflation'!G34-1","v":1.76278015613196E-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'!C27","v":"2008-09"},"calculated","index",null,null,null,null,1,{"$f":"J16*(1+K$12)","v":1.0435264324153211},1.0625197847420067,1.0927508705286484,1.1297879075656851,{"$f":"N16*(1+O$12)","v":1.1497035846066315}]
[null,null,{"$f":"'Lookup|Tables'!C28","v":"2009-10"},"calculated","index",null,null,null,null,{"$f":"K17/(1+K$12)","v":0.95828909449416066},1,{"$f":"K17*(1+L$12)","v":1.0182011224025482},{"$f":"L17*(1+M$12)","v":1.0471712422266044},1.082663430911573,1.1017484070293797]
[null,null,{"$f":"'Lookup|Tables'!C29","v":"2010-11"},"calculated","index",null,null,null,null,{"$f":"K18/(1+K$12)","v":0.94115894532995692},{"$f":"L18/(1+L$12)","v":0.98212423655593617},1,{"$f":"L18*(1+M$12)","v":1.0284522568151351},1.0633099955310592,1.0820538131304482]
[null,null,{"$f":"'Lookup|Tables'!C30","v":"2011-12"},"calculated","index",null,null,null,null,{"$f":"K19/(1+K$12)","v":0.91512166859791411},0.95495365005793709,0.97233487833140186,1,{"$f":"M19*(1+N$12)","v":1.0338933951332558},1.052118662738224]
[null,null,{"$f":"'Lookup|Tables'!C31","v":"2012-13"},"calculated","index",null,null,null,null,0.88512188288035887,0.92364808069487248,0.94045951246847859,0.96721770804146845,1,{"$f":"N20*(1+O$12)","v":1.0176278015613196}]
[null,null,{"$f":"'Lookup|Tables'!C32","v":"2013-14"},"calculated","index",null,null,null,null,0.86978940779953084,0.9076482376736793,0.92416845434603512,0.95046313254953496,0.98267755506062848,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":"2008-09"},"calculated","index",null,null,null,null,{"$f":"1/J16*(1+J$12)^0.5","v":1},0.97892241495133847,0.94968539711597333,0.92804899895760007,0.89999678575759456,0.87742215514592137]
[null,null,"2009-10","calculated","index",null,null,null,null,1.0435264324153211,1.0215314152855608,0.99102181436935899,0.96844366098883428,0.93917043502687869,0.91561321128158546]
[null,null,"2010-11","calculated","index",null,null,null,null,1.0625197847420069,1.0401244336132216,1.0090595237162912,0.98607042260246403,0.95626439107165739,0.93227839941351198]
[null,null,"2011-12","calculated","index",null,null,null,null,1.0927508705286484,1.0697183211180821,1.0377695444268249,1.0141263515041581,0.98347227110959701,0.95880382385682816]
[null,null,"2012-13","calculated","index",null,null,null,null,1.1297879075656851,1.1059747068570203,1.0729430776533422,1.0484985366507356,1.0168054853969151,0.99130094071408426]
[null,null,"2013-14","calculated","index",null,null,null,null,1.1497035846066317,1.1254706095213343,1.091856705312807,1.0669812607921489,1.0347295307199531,1.0087753969845417]
[]
[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.8844743774724177E-3,8.6855257995636093E-3,1.3989376034402867E-2,1.6157480747877484E-2,1.4373497006676561E-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":"C36","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":"C37","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(P47:P54)=1,\"Ok\",\"Check\")","v":"Ok"},{"$f":"IF(SUM(Q47:Q54)=1,\"Ok\",\"Check\")","v":"Ok"},"Ok","Ok","Ok",null,null,{"$f":"IF(COUNTIF(K56:T56,\"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,"Customer numbers","external","number","n/a",null,null,null,null,null,null,null,null,1649557.8686763723,1664063.2373527444,1680866.6564167966,1699603.6728434868,1719521.5959816426,1739021.6525674947]
[null,null,"Circuit Length","external","number","n/a",null,null,null,null,null,null,null,null,41265.395499999999,41567.284999999996,41897.292000000001,42227.19,42560.087,42888.985000000001]
[null,null,"Ratcheted Maximum Demand","external","number","n/a",null,null,null,null,null,null,null,null,6555.2656999999999,6555.2656999999999,6555.2656999999999,6555.2656999999999,6555.2656999999999,6555.2656999999999]
[null,null,null,"external","number","n/a"]
[null,null,null,"external","number","n/a"]
[null,null,null,"external","number","n/a"]
[]
[null,null,"Growth rate","Source","Unit","Basis",null,null,null,null,{"$f":"IF(RIGHT(K$4,2)>=RIGHT('Input|General'!$G$11,2),IF(RIGHT(K$4,2)<='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":"C62","v":"Customer numbers"},"calculated","number","n/a",null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(P62),\"\",LN(P62)-LN(O62))","v":8.7550512664336111E-3},{"$f":"IF(ISBLANK(Q62),\"\",LN(Q62)-LN(P62))","v":1.0047182422628254E-2},{"$f":"IF(ISBLANK(R62),\"\",LN(R62)-LN(Q62))","v":1.108556294449059E-2},1.1651020004775248E-2,1.1276576189176879E-2]
[null,null,{"$f":"C63","v":"Circuit Length"},"calculated","number","n/a",null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(P63),\"\",LN(P63)-LN(O63))","v":7.2891722166499306E-3},7.9077551589588069E-3,7.84313158992056E-3,7.8525628464305441E-3,7.6981438545118408E-3]
[null,null,"Ratcheted Maximum Demand","calculated","number","n/a",null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(P64),\"\",LN(P64)-LN(O64))","v":0},0,0,0,0]
[null,null,0,"calculated","number","n/a",null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(P65),\"\",LN(P65)-LN(O65))","v":""},"","","",""]
[null,null,0,"calculated","number","n/a",null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(P66),\"\",LN(P66)-LN(O66))","v":""},"","","",""]
[null,null,0,"calculated","number","n/a",null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(P67),\"\",LN(P67)-LN(O67))","v":""},"","","",""]
[]
[null,null,"Weights"]
[]
[null,null,{"$f":"C62","v":"Customer numbers"},"external","number","n/a",null,null,null,null,null,null,null,null,null,0.67608294961721682]
[null,null,{"$f":"C63","v":"Circuit Length"},"external","number","n/a",null,null,null,null,null,null,null,null,null,0.10702733446151043]
[null,null,"Ratcheted Maximum Demand","external","number","n/a",null,null,null,null,null,null,null,null,null,0.21688971592127262]
[null,null,0,"external","number","n/a"]
[null,null,0,"external","number","n/a"]
[null,null,0,"external","number","n/a"]
[]
[null,null,"Check","calculated","Ok/Check","n/a",null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(P80:P85)=1,\"Ok\",\"Check\")","v":"Ok"},null,null,null,null,null,null,{"$f":"IF(COUNTIF(K87:T87,\"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,0,0,0,0,0]
[]
[null,"End"]

{"sheet":"Input|Step changes","index":5,"n_rows":32,"n_cols":22,"rows_kept":32,"cut":false,"hidden":false,"merged":[[2,9,2,11],[2,13,2,18]]}
[null,{"$f":"Index!$B$1","v":"AER opex model"},null,null,null,null,null,null,null,"Back to Index",null,"Key:","Input","External Link","Internal Link",null,null,"Worksheet check:",{"$f":"IF(COUNTA($W$8:$W$225)=COUNTIF($W$8:$W$225,\"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,"Leaseback of head office","AER","$millions","2013-14",null,null,null,null,null,null,null,null,7.0061744000000008,7.4270399999999999,9.2755869999999998,-3.7050851202653656,-3.7384636369962183]
[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","2013-14"]
[null,null,null,"AER","$millions","2012-13"]
[null,null,null,"AER","$millions","2013-14"]
[]
[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,"Distribution","PTRM","$millions","2013-14",null,null,null,null,null,null,null,null,6.232939635180645,6.2597178667318145,6.269829660110001,6.2484297050473643,6.2466080187245865]
[null,null,"Transmission","PTRM","$millions","2013-14",null,null,null,null,null,null,null,null,1.0356558480879487,1.0519121083041951,1.0635366130699624,1.0568219664054945,1.0538927455755185]
[]
[null,"End"]

{"sheet":"Input|Dx Tx split","index":6,"n_rows":17,"n_cols":22,"rows_kept":17,"cut":false,"hidden":false,"merged":[[2,9,2,11],[2,13,2,18]]}
[null,{"$f":"Index!$B$1","v":"AER opex model"},null,null,null,null,null,null,null,"Back to Index",null,"Key:","Input","External Link","Internal Link",null,null,"Worksheet check:",{"$f":"IF(COUNTA($W$8:$W$210)=COUNTIF($W$8:$W$210,\"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 | Dx/Tx split"]
[]
[null,null,"Dx/Tx split","Source","Unit",null,null,null,null,{"$f":"IF(RIGHT(J$4,2)>=RIGHT('Input|General'!$G$11,2),IF(RIGHT(J$4,2)<='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,"Distribution","AER",{"$f":"percent","v":"Per cent"},null,null,null,null,null,null,null,null,null,0.92814206180967485,0.92802566160607169,0.92768218235327649,0.92934724102868327,0.92943597326044347]
[null,null,"Transmission","AER","Per cent",null,null,null,null,null,null,null,null,null,7.185793819032564E-2,7.19743383939285E-2,7.2317817646723737E-2,7.0652758971316704E-2,7.0564026739556585E-2]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(O12:O13)=1,\"Ok\",\"Check\")","v":"Ok"},{"$f":"IF(SUM(P12:P13)=1,\"Ok\",\"Check\")","v":"Ok"},"Ok","Ok","Ok",null,null,{"$f":"IF(COUNTIF(J15:S15,\"Check\")=0,\"Ok\",\"Check\")","v":"Ok"}]
[]
[null,"End"]

{"sheet":"Calc|Opex forecast","index":7,"n_rows":77,"n_cols":22,"rows_kept":77,"cut":false,"hidden":false,"merged":[[2,9,2,11],[2,13,2,18]]}
[null,{"$f":"Index!$B$1","v":"AER opex model"},null,null,null,null,null,null,null,"Back to Index",null,"Key:","Input","External Link","Internal Link",null,null,"Worksheet check:","n/a",null,"Overall Check:",{"$f":"'Check|List'!$S$1","v":"Ok"}]
[null,{"$f":"Index!$C$13","v":"Calc | Opex Forecast"}]
[]
[null,null,null,"Source","Unit","Basis",null,null,null,{"$f":"'Input|General'!$G$8","v":"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":503.22171786402453},{"$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$25:K$30),INDEX('Input|Rate of change'!$C$14:$O$21,MATCH('Calc|Opex forecast'!$F12,'Input|Rate of change'!$C$14:$C$21,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$25:L$30),INDEX('Input|Rate of change'!$C$14:$O$21,MATCH('Calc|Opex forecast'!$F12,'Input|Rate of change'!$C$14:$C$21,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$25:M$30),INDEX('Input|Rate of change'!$C$14:$O$21,MATCH('Calc|Opex forecast'!$F12,'Input|Rate of change'!$C$14:$C$21,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$25:N$30),INDEX('Input|Rate of change'!$C$14:$O$21,MATCH('Calc|Opex forecast'!$F12,'Input|Rate of change'!$C$14:$C$21,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":520.6983719735307},{"$f":"N12*IF($F12=\"nominal\",LOOKUP($F13,Nominal_to_Real,'Input|Rate of change'!O$25:O$30),INDEX('Input|Rate of change'!$C$14:$O$21,MATCH('Calc|Opex forecast'!$F12,'Input|Rate of change'!$C$14:$C$21,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$25:P$30),INDEX('Input|Rate of change'!$C$14:$O$21,MATCH('Calc|Opex forecast'!$F12,'Input|Rate of change'!$C$14:$C$21,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$25:Q$30),INDEX('Input|Rate of change'!$C$14:$O$21,MATCH('Calc|Opex forecast'!$F12,'Input|Rate of change'!$C$14:$C$21,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$25:R$30),INDEX('Input|Rate of change'!$C$14:$O$21,MATCH('Calc|Opex forecast'!$F12,'Input|Rate of change'!$C$14:$C$21,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$25:S$30),INDEX('Input|Rate of change'!$C$14:$O$21,MATCH('Calc|Opex forecast'!$F12,'Input|Rate of change'!$C$14:$C$21,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$25:T$30),INDEX('Input|Rate of change'!$C$14:$O$21,MATCH('Calc|Opex forecast'!$F12,'Input|Rate of change'!$C$14:$C$21,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":532.9500382237768},{"$f":"IF(N$10='Input|General'!$G$9,'Input|Reported opex'!N24,0)","v":0},{"$f":"IF(O$10='Input|General'!$G$9,'Input|Reported opex'!O24,0)","v":0},{"$f":"IF(P$10='Input|General'!$G$9,'Input|Reported opex'!P24,0)","v":0},{"$f":"IF(Q$10='Input|General'!$G$9,'Input|Reported opex'!Q24,0)","v":0},{"$f":"IF(R$10='Input|General'!$G$9,'Input|Reported opex'!R24,0)","v":0},{"$f":"IF(S$10='Input|General'!$G$9,'Input|Reported opex'!S24,0)","v":0}]
[null,null,"Total base year opex allowance","Calculated",{"$f":"$E$8","v":"$millions"},{"$f":"$F$8","v":"2013-14"},null,null,null,{"$f":"J14*IF($F14=\"nominal\",LOOKUP($F15,Nominal_to_Real,'Input|Rate of change'!K$25:K$30),INDEX('Input|Rate of change'!$C$14:$O$21,MATCH('Calc|Opex forecast'!$F14,'Input|Rate of change'!$C$14:$C$21,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$25:L$30),INDEX('Input|Rate of change'!$C$14:$O$21,MATCH('Calc|Opex forecast'!$F14,'Input|Rate of change'!$C$14:$C$21,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$25:M$30),INDEX('Input|Rate of change'!$C$14:$O$21,MATCH('Calc|Opex forecast'!$F14,'Input|Rate of change'!$C$14:$C$21,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$25:N$30),INDEX('Input|Rate of change'!$C$14:$O$21,MATCH('Calc|Opex forecast'!$F14,'Input|Rate of change'!$C$14:$C$21,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":612.73456936211744},{"$f":"N14*IF($F14=\"nominal\",LOOKUP($F15,Nominal_to_Real,'Input|Rate of change'!O$25:O$30),INDEX('Input|Rate of change'!$C$14:$O$21,MATCH('Calc|Opex forecast'!$F14,'Input|Rate of change'!$C$14:$C$21,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$25:P$30),INDEX('Input|Rate of change'!$C$14:$O$21,MATCH('Calc|Opex forecast'!$F14,'Input|Rate of change'!$C$14:$C$21,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$25:Q$30),INDEX('Input|Rate of change'!$C$14:$O$21,MATCH('Calc|Opex forecast'!$F14,'Input|Rate of change'!$C$14:$C$21,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$25:R$30),INDEX('Input|Rate of change'!$C$14:$O$21,MATCH('Calc|Opex forecast'!$F14,'Input|Rate of change'!$C$14:$C$21,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$25:S$30),INDEX('Input|Rate of change'!$C$14:$O$21,MATCH('Calc|Opex forecast'!$F14,'Input|Rate of change'!$C$14:$C$21,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$25:T$30),INDEX('Input|Rate of change'!$C$14:$O$21,MATCH('Calc|Opex forecast'!$F14,'Input|Rate of change'!$C$14:$C$21,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":533.75182391997919},{"$f":"IF(O$10='Input|General'!$G$10,'Input|Reported opex'!O24,0)","v":0},{"$f":"IF(P$10='Input|General'!$G$10,'Input|Reported opex'!P24,0)","v":0},{"$f":"IF(Q$10='Input|General'!$G$10,'Input|Reported opex'!Q24,0)","v":0},{"$f":"IF(R$10='Input|General'!$G$10,'Input|Reported opex'!R24,0)","v":0},{"$f":"IF(S$10='Input|General'!$G$10,'Input|Reported opex'!S24,0)","v":0}]
[null,null,"Total final year opex allowance","Calculated",{"$f":"$E$8","v":"$millions"},{"$f":"$F$8","v":"2013-14"},null,null,null,{"$f":"J16*IF($F16=\"nominal\",LOOKUP($F17,Nominal_to_Real,'Input|Rate of change'!K$25:K$30),INDEX('Input|Rate of change'!$C$14:$O$21,MATCH('Calc|Opex forecast'!$F16,'Input|Rate of change'!$C$14:$C$21,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$25:L$30),INDEX('Input|Rate of change'!$C$14:$O$21,MATCH('Calc|Opex forecast'!$F16,'Input|Rate of change'!$C$14:$C$21,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$25:M$30),INDEX('Input|Rate of change'!$C$14:$O$21,MATCH('Calc|Opex forecast'!$F16,'Input|Rate of change'!$C$14:$C$21,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$25:N$30),INDEX('Input|Rate of change'!$C$14:$O$21,MATCH('Calc|Opex forecast'!$F16,'Input|Rate of change'!$C$14:$C$21,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$25:O$30),INDEX('Input|Rate of change'!$C$14:$O$21,MATCH('Calc|Opex forecast'!$F16,'Input|Rate of change'!$C$14:$C$21,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":613.65638525112763},{"$f":"O16*IF($F16=\"nominal\",LOOKUP($F17,Nominal_to_Real,'Input|Rate of change'!P$25:P$30),INDEX('Input|Rate of change'!$C$14:$O$21,MATCH('Calc|Opex forecast'!$F16,'Input|Rate of change'!$C$14:$C$21,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$25:Q$30),INDEX('Input|Rate of change'!$C$14:$O$21,MATCH('Calc|Opex forecast'!$F16,'Input|Rate of change'!$C$14:$C$21,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$25:R$30),INDEX('Input|Rate of change'!$C$14:$O$21,MATCH('Calc|Opex forecast'!$F16,'Input|Rate of change'!$C$14:$C$21,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$25:S$30),INDEX('Input|Rate of change'!$C$14:$O$21,MATCH('Calc|Opex forecast'!$F16,'Input|Rate of change'!$C$14:$C$21,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$25:T$30),INDEX('Input|Rate of change'!$C$14:$O$21,MATCH('Calc|Opex forecast'!$F16,'Input|Rate of change'!$C$14:$C$21,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":521.62018786254089},{"$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,"CAM adjustment","Inputs|Reported opex",{"$f":"'Input|Reported opex'!E48","v":"$millions"},{"$f":"'Input|Reported opex'!F48","v":"nominal"},null,null,{"$f":"IF(I$10='Input|General'!$G$10,'Input|Reported opex'!I48,0)","v":0},{"$f":"IF(J$10='Input|General'!$G$10,'Input|Reported opex'!J48,0)","v":0},{"$f":"IF(K$10='Input|General'!$G$10,'Input|Reported opex'!K48,0)","v":0},{"$f":"IF(L$10='Input|General'!$G$10,'Input|Reported opex'!L48,0)","v":0},{"$f":"IF(M$10='Input|General'!$G$10,'Input|Reported opex'!M48,0)","v":0},{"$f":"IF(N$10='Input|General'!$G$10,'Input|Reported opex'!N48,0)","v":3.8042128679721166},{"$f":"IF(O$10='Input|General'!$G$10,'Input|Reported opex'!O48,0)","v":0},{"$f":"IF(P$10='Input|General'!$G$10,'Input|Reported opex'!P48,0)","v":0},{"$f":"IF(Q$10='Input|General'!$G$10,'Input|Reported opex'!Q48,0)","v":0},{"$f":"IF(R$10='Input|General'!$G$10,'Input|Reported opex'!R48,0)","v":0},{"$f":"IF(S$10='Input|General'!$G$10,'Input|Reported opex'!S48,0)","v":0}]
[null,null,{"$f":"C21","v":"CAM adjustment"},"Calculated",{"$f":"$E$8","v":"$millions"},{"$f":"$F$8","v":"2013-14"},null,null,null,{"$f":"J21*IF($F21=\"nominal\",LOOKUP($F22,Nominal_to_Real,'Input|Rate of change'!K$25:K$30),INDEX('Input|Rate of change'!$C$14:$O$21,MATCH('Calc|Opex forecast'!$F21,'Input|Rate of change'!$C$14:$C$21,0),MATCH('Calc|Opex forecast'!$F22,'Input|Rate of change'!$C$14:$O$14,0)))*IF($E21=\"$millions\",1000000,IF($E21=\"$000\",1000,1))/IF($E22=\"$millions\",1000000,IF($E22=\"$000\",1000,1))","v":0},{"$f":"K21*IF($F21=\"nominal\",LOOKUP($F22,Nominal_to_Real,'Input|Rate of change'!L$25:L$30),INDEX('Input|Rate of change'!$C$14:$O$21,MATCH('Calc|Opex forecast'!$F21,'Input|Rate of change'!$C$14:$C$21,0),MATCH('Calc|Opex forecast'!$F22,'Input|Rate of change'!$C$14:$O$14,0)))*IF($E21=\"$millions\",1000000,IF($E21=\"$000\",1000,1))/IF($E22=\"$millions\",1000000,IF($E22=\"$000\",1000,1))","v":0},{"$f":"L21*IF($F21=\"nominal\",LOOKUP($F22,Nominal_to_Real,'Input|Rate of change'!M$25:M$30),INDEX('Input|Rate of change'!$C$14:$O$21,MATCH('Calc|Opex forecast'!$F21,'Input|Rate of change'!$C$14:$C$21,0),MATCH('Calc|Opex forecast'!$F22,'Input|Rate of change'!$C$14:$O$14,0)))*IF($E21=\"$millions\",1000000,IF($E21=\"$000\",1000,1))/IF($E22=\"$millions\",1000000,IF($E22=\"$000\",1000,1))","v":0},{"$f":"M21*IF($F21=\"nominal\",LOOKUP($F22,Nominal_to_Real,'Input|Rate of change'!N$25:N$30),INDEX('Input|Rate of change'!$C$14:$O$21,MATCH('Calc|Opex forecast'!$F21,'Input|Rate of change'!$C$14:$C$21,0),MATCH('Calc|Opex forecast'!$F22,'Input|Rate of change'!$C$14:$O$14,0)))*IF($E21=\"$millions\",1000000,IF($E21=\"$000\",1000,1))/IF($E22=\"$millions\",1000000,IF($E22=\"$000\",1000,1))","v":0},{"$f":"N21*IF($F21=\"nominal\",LOOKUP($F22,Nominal_to_Real,'Input|Rate of change'!O$25:O$30),INDEX('Input|Rate of change'!$C$14:$O$21,MATCH('Calc|Opex forecast'!$F21,'Input|Rate of change'!$C$14:$C$21,0),MATCH('Calc|Opex forecast'!$F22,'Input|Rate of change'!$C$14:$O$14,0)))*IF($E21=\"$millions\",1000000,IF($E21=\"$000\",1000,1))/IF($E22=\"$millions\",1000000,IF($E22=\"$000\",1000,1))","v":3.8375963461022735},{"$f":"O21*IF($F21=\"nominal\",LOOKUP($F22,Nominal_to_Real,'Input|Rate of change'!P$25:P$30),INDEX('Input|Rate of change'!$C$14:$O$21,MATCH('Calc|Opex forecast'!$F21,'Input|Rate of change'!$C$14:$C$21,0),MATCH('Calc|Opex forecast'!$F22,'Input|Rate of change'!$C$14:$O$14,0)))*IF($E21=\"$millions\",1000000,IF($E21=\"$000\",1000,1))/IF($E22=\"$millions\",1000000,IF($E22=\"$000\",1000,1))","v":0},{"$f":"P21*IF($F21=\"nominal\",LOOKUP($F22,Nominal_to_Real,'Input|Rate of change'!Q$25:Q$30),INDEX('Input|Rate of change'!$C$14:$O$21,MATCH('Calc|Opex forecast'!$F21,'Input|Rate of change'!$C$14:$C$21,0),MATCH('Calc|Opex forecast'!$F22,'Input|Rate of change'!$C$14:$O$14,0)))*IF($E21=\"$millions\",1000000,IF($E21=\"$000\",1000,1))/IF($E22=\"$millions\",1000000,IF($E22=\"$000\",1000,1))","v":0},{"$f":"Q21*IF($F21=\"nominal\",LOOKUP($F22,Nominal_to_Real,'Input|Rate of change'!R$25:R$30),INDEX('Input|Rate of change'!$C$14:$O$21,MATCH('Calc|Opex forecast'!$F21,'Input|Rate of change'!$C$14:$C$21,0),MATCH('Calc|Opex forecast'!$F22,'Input|Rate of change'!$C$14:$O$14,0)))*IF($E21=\"$millions\",1000000,IF($E21=\"$000\",1000,1))/IF($E22=\"$millions\",1000000,IF($E22=\"$000\",1000,1))","v":0},{"$f":"R21*IF($F21=\"nominal\",LOOKUP($F22,Nominal_to_Real,'Input|Rate of change'!S$25:S$30),INDEX('Input|Rate of change'!$C$14:$O$21,MATCH('Calc|Opex forecast'!$F21,'Input|Rate of change'!$C$14:$C$21,0),MATCH('Calc|Opex forecast'!$F22,'Input|Rate of change'!$C$14:$O$14,0)))*IF($E21=\"$millions\",1000000,IF($E21=\"$000\",1000,1))/IF($E22=\"$millions\",1000000,IF($E22=\"$000\",1000,1))","v":0},{"$f":"S21*IF($F21=\"nominal\",LOOKUP($F22,Nominal_to_Real,'Input|Rate of change'!T$25:T$30),INDEX('Input|Rate of change'!$C$14:$O$21,MATCH('Calc|Opex forecast'!$F21,'Input|Rate of change'!$C$14:$C$21,0),MATCH('Calc|Opex forecast'!$F22,'Input|Rate of change'!$C$14:$O$14,0)))*IF($E21=\"$millions\",1000000,IF($E21=\"$000\",1000,1))/IF($E22=\"$millions\",1000000,IF($E22=\"$000\",1000,1))","v":0}]
[]
[null,null,"Service classification adjustment","Inputs|Reported opex",{"$f":"'Input|Reported opex'!E53","v":"$millions"},{"$f":"'Input|Reported opex'!F53","v":"nominal"},null,null,null,null,null,null,null,{"$f":"'Input|Reported opex'!N53","v":-35.648836792211107}]
[null,null,{"$f":"C24","v":"Service classification adjustment"},"Calculated",{"$f":"$E$8","v":"$millions"},{"$f":"$F$8","v":"2013-14"},null,null,null,{"$f":"J24*IF($F24=\"nominal\",LOOKUP($F25,Nominal_to_Real,'Input|Rate of change'!K$25:K$30),INDEX('Input|Rate of change'!$C$14:$O$21,MATCH('Calc|Opex forecast'!$F24,'Input|Rate of change'!$C$14:$C$21,0),MATCH('Calc|Opex forecast'!$F25,'Input|Rate of change'!$C$14:$O$14,0)))*IF($E24=\"$millions\",1000000,IF($E24=\"$000\",1000,1))/IF($E25=\"$millions\",1000000,IF($E25=\"$000\",1000,1))","v":0},{"$f":"K24*IF($F24=\"nominal\",LOOKUP($F25,Nominal_to_Real,'Input|Rate of change'!L$25:L$30),INDEX('Input|Rate of change'!$C$14:$O$21,MATCH('Calc|Opex forecast'!$F24,'Input|Rate of change'!$C$14:$C$21,0),MATCH('Calc|Opex forecast'!$F25,'Input|Rate of change'!$C$14:$O$14,0)))*IF($E24=\"$millions\",1000000,IF($E24=\"$000\",1000,1))/IF($E25=\"$millions\",1000000,IF($E25=\"$000\",1000,1))","v":0},{"$f":"L24*IF($F24=\"nominal\",LOOKUP($F25,Nominal_to_Real,'Input|Rate of change'!M$25:M$30),INDEX('Input|Rate of change'!$C$14:$O$21,MATCH('Calc|Opex forecast'!$F24,'Input|Rate of change'!$C$14:$C$21,0),MATCH('Calc|Opex forecast'!$F25,'Input|Rate of change'!$C$14:$O$14,0)))*IF($E24=\"$millions\",1000000,IF($E24=\"$000\",1000,1))/IF($E25=\"$millions\",1000000,IF($E25=\"$000\",1000,1))","v":0},{"$f":"M24*IF($F24=\"nominal\",LOOKUP($F25,Nominal_to_Real,'Input|Rate of change'!N$25:N$30),INDEX('Input|Rate of change'!$C$14:$O$21,MATCH('Calc|Opex forecast'!$F24,'Input|Rate of change'!$C$14:$C$21,0),MATCH('Calc|Opex forecast'!$F25,'Input|Rate of change'!$C$14:$O$14,0)))*IF($E24=\"$millions\",1000000,IF($E24=\"$000\",1000,1))/IF($E25=\"$millions\",1000000,IF($E25=\"$000\",1000,1))","v":0},{"$f":"N24*IF($F24=\"nominal\",LOOKUP($F25,Nominal_to_Real,'Input|Rate of change'!O$25:O$30),INDEX('Input|Rate of change'!$C$14:$O$21,MATCH('Calc|Opex forecast'!$F24,'Input|Rate of change'!$C$14:$C$21,0),MATCH('Calc|Opex forecast'!$F25,'Input|Rate of change'!$C$14:$O$14,0)))*IF($E24=\"$millions\",1000000,IF($E24=\"$000\",1000,1))/IF($E25=\"$millions\",1000000,IF($E25=\"$000\",1000,1))","v":-35.96166948709989},{"$f":"O24*IF($F24=\"nominal\",LOOKUP($F25,Nominal_to_Real,'Input|Rate of change'!P$25:P$30),INDEX('Input|Rate of change'!$C$14:$O$21,MATCH('Calc|Opex forecast'!$F24,'Input|Rate of change'!$C$14:$C$21,0),MATCH('Calc|Opex forecast'!$F25,'Input|Rate of change'!$C$14:$O$14,0)))*IF($E24=\"$millions\",1000000,IF($E24=\"$000\",1000,1))/IF($E25=\"$millions\",1000000,IF($E25=\"$000\",1000,1))","v":0},{"$f":"P24*IF($F24=\"nominal\",LOOKUP($F25,Nominal_to_Real,'Input|Rate of change'!Q$25:Q$30),INDEX('Input|Rate of change'!$C$14:$O$21,MATCH('Calc|Opex forecast'!$F24,'Input|Rate of change'!$C$14:$C$21,0),MATCH('Calc|Opex forecast'!$F25,'Input|Rate of change'!$C$14:$O$14,0)))*IF($E24=\"$millions\",1000000,IF($E24=\"$000\",1000,1))/IF($E25=\"$millions\",1000000,IF($E25=\"$000\",1000,1))","v":0},{"$f":"Q24*IF($F24=\"nominal\",LOOKUP($F25,Nominal_to_Real,'Input|Rate of change'!R$25:R$30),INDEX('Input|Rate of change'!$C$14:$O$21,MATCH('Calc|Opex forecast'!$F24,'Input|Rate of change'!$C$14:$C$21,0),MATCH('Calc|Opex forecast'!$F25,'Input|Rate of change'!$C$14:$O$14,0)))*IF($E24=\"$millions\",1000000,IF($E24=\"$000\",1000,1))/IF($E25=\"$millions\",1000000,IF($E25=\"$000\",1000,1))","v":0},{"$f":"R24*IF($F24=\"nominal\",LOOKUP($F25,Nominal_to_Real,'Input|Rate of change'!S$25:S$30),INDEX('Input|Rate of change'!$C$14:$O$21,MATCH('Calc|Opex forecast'!$F24,'Input|Rate of change'!$C$14:$C$21,0),MATCH('Calc|Opex forecast'!$F25,'Input|Rate of change'!$C$14:$O$14,0)))*IF($E24=\"$millions\",1000000,IF($E24=\"$000\",1000,1))/IF($E25=\"$millions\",1000000,IF($E25=\"$000\",1000,1))","v":0},{"$f":"S24*IF($F24=\"nominal\",LOOKUP($F25,Nominal_to_Real,'Input|Rate of change'!T$25:T$30),INDEX('Input|Rate of change'!$C$14:$O$21,MATCH('Calc|Opex forecast'!$F24,'Input|Rate of change'!$C$14:$C$21,0),MATCH('Calc|Opex forecast'!$F25,'Input|Rate of change'!$C$14:$O$14,0)))*IF($E24=\"$millions\",1000000,IF($E24=\"$000\",1000,1))/IF($E25=\"$millions\",1000000,IF($E25=\"$000\",1000,1))","v":0}]
[]
[null,null,"Efficiency adjustment","calculated",{"$f":"$E$8","v":"$millions"},{"$f":"$F$8","v":"2013-14"},null,null,null,{"$f":"SUM(J19,J22,J25)*'Input|Reported opex'!$N$58","v":0},{"$f":"SUM(K19,K22,K25)*'Input|Reported opex'!$N$58","v":0},{"$f":"SUM(L19,L22,L25)*'Input|Reported opex'!$N$58","v":0},{"$f":"SUM(M19,M22,M25)*'Input|Reported opex'!$N$58","v":0},{"$f":"SUM(N19,N22,N25)*'Input|Reported opex'!$N$58","v":-163.01573787633905},{"$f":"SUM(O19,O22,O25)*'Input|Reported opex'!$N$58","v":0},{"$f":"SUM(P19,P22,P25)*'Input|Reported opex'!$N$58","v":0},{"$f":"SUM(Q19,Q22,Q25)*'Input|Reported opex'!$N$58","v":0},{"$f":"SUM(R19,R22,R25)*'Input|Reported opex'!$N$58","v":0},{"$f":"SUM(S19,S22,S25)*'Input|Reported opex'!$N$58","v":0}]
[]
[null,null,"Efficiency adjustment final year opex","calculated",{"$f":"$E$8","v":"$millions"},{"$f":"$F$8","v":"2013-14"},null,null,null,{"$f":"SUM(J19,J22,J25,J27)","v":0},0,0,0,{"$f":"SUM(N19,N22,N25,N27)","v":326.4803768452042},0,0,0,0,{"$f":"SUM(S19,S22,S25,S27)","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'!K71:K76,'Input|Rate of change'!$P$80:$P$85)","v":0},{"$f":"SUMPRODUCT('Input|Rate of change'!L71:L76,'Input|Rate of change'!$P$80:$P$85)","v":0},{"$f":"SUMPRODUCT('Input|Rate of change'!M71:M76,'Input|Rate of change'!$P$80:$P$85)","v":0},{"$f":"SUMPRODUCT('Input|Rate of change'!N71:N76,'Input|Rate of change'!$P$80:$P$85)","v":0},{"$f":"SUMPRODUCT('Input|Rate of change'!O71:O76,'Input|Rate of change'!$P$80:$P$85)","v":0},{"$f":"SUMPRODUCT('Input|Rate of change'!P71:P76,'Input|Rate of change'!$P$80:$P$85)","v":6.6992815570393266E-3},{"$f":"SUMPRODUCT('Input|Rate of change'!Q71:Q76,'Input|Rate of change'!$P$80:$P$85)","v":7.6390746838703831E-3},{"$f":"SUMPRODUCT('Input|Rate of change'!R71:R76,'Input|Rate of change'!$P$80:$P$85)","v":8.3341895615785828E-3},{"$f":"SUMPRODUCT('Input|Rate of change'!S71:S76,'Input|Rate of change'!$P$80:$P$85)","v":8.7174948410225998E-3},{"$f":"SUMPRODUCT('Input|Rate of change'!T71:T76,'Input|Rate of change'!$P$80:$P$85)","v":8.4478127086116388E-3}]
[]
[null,null,"Forecast price change","Calculated","Per cent","n/a",null,null,null,{"$f":"SUMPRODUCT('Input|Rate of change'!K36:K43,'Input|Rate of change'!K47:K54)","v":0},{"$f":"SUMPRODUCT('Input|Rate of change'!L36:L43,'Input|Rate of change'!L47:L54)","v":0},{"$f":"SUMPRODUCT('Input|Rate of change'!M36:M43,'Input|Rate of change'!M47:M54)","v":0},{"$f":"SUMPRODUCT('Input|Rate of change'!N36:N43,'Input|Rate of change'!N47:N54)","v":0},{"$f":"SUMPRODUCT('Input|Rate of change'!O36:O43,'Input|Rate of change'!O47:O54)","v":0},{"$f":"SUMPRODUCT('Input|Rate of change'!P36:P43,'Input|Rate of change'!P47:P54)","v":5.5083741140328994E-3},{"$f":"SUMPRODUCT('Input|Rate of change'!Q36:Q43,'Input|Rate of change'!Q47:Q54)","v":5.385025995729438E-3},{"$f":"SUMPRODUCT('Input|Rate of change'!R36:R43,'Input|Rate of change'!R47:R54)","v":8.6734131413297774E-3},{"$f":"SUMPRODUCT('Input|Rate of change'!S36:S43,'Input|Rate of change'!S47:S54)","v":1.001763806368404E-2},{"$f":"SUMPRODUCT('Input|Rate of change'!T36:T43,'Input|Rate of change'!T47:T54)","v":8.9115681441394676E-3}]
[]
[null,null,"Forecast productivity change","Calculated","Per cent","n/a",null,null,null,{"$f":"'Input|Rate of change'!K93","v":0},{"$f":"'Input|Rate of change'!L93","v":0},{"$f":"'Input|Rate of change'!M93","v":0},{"$f":"'Input|Rate of change'!N93","v":0},{"$f":"'Input|Rate of change'!O93","v":0},{"$f":"'Input|Rate of change'!P93","v":0},{"$f":"'Input|Rate of change'!Q93","v":0},{"$f":"'Input|Rate of change'!R93","v":0},{"$f":"'Input|Rate of change'!S93","v":0},{"$f":"'Input|Rate of change'!T93","v":0}]
[]
[null,null,"Forecast rate of change","Calculated","Per cent","n/a",null,null,null,{"$f":"(1+J36)*(1+J38)*(1-J40)-1","v":0},{"$f":"(1+K36)*(1+K38)*(1-K40)-1","v":0},0,0,0,1.2244557820183521E-2,1.3065237295355914E-2,1.7079888572173907E-2,1.8822461612846064E-2,1.7434664111372733E-2]
[]
[null,"Calc | Step changes"]
[]
[null,null,"Step changes","Source","Unit","Basis",null,null,null,{"$f":"IF(RIGHT(J$4,2)>=RIGHT('Input|General'!$G$11,2),IF(RIGHT(J$4,2)<='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":"Leaseback of head office"},"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($F48,Nominal_to_Real,'Input|Rate of change'!N$25:N$30),INDEX('Input|Rate of change'!$C$14:$O$21,MATCH('Input|Step changes'!$F12,'Input|Rate of change'!$C$14:$C$21,0),MATCH('Calc|Opex forecast'!$F48,'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($E48=\"$millions\",1000000,IF($E48=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!K12*IF('Input|Step changes'!$F12=\"nominal\",LOOKUP($F48,Nominal_to_Real,'Input|Rate of change'!O$25:O$30),INDEX('Input|Rate of change'!$C$14:$O$21,MATCH('Input|Step changes'!$F12,'Input|Rate of change'!$C$14:$C$21,0),MATCH('Calc|Opex forecast'!$F48,'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($E48=\"$millions\",1000000,IF($E48=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!L12*IF('Input|Step changes'!$F12=\"nominal\",LOOKUP($F48,Nominal_to_Real,'Input|Rate of change'!P$25:P$30),INDEX('Input|Rate of change'!$C$14:$O$21,MATCH('Input|Step changes'!$F12,'Input|Rate of change'!$C$14:$C$21,0),MATCH('Calc|Opex forecast'!$F48,'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($E48=\"$millions\",1000000,IF($E48=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!M12*IF('Input|Step changes'!$F12=\"nominal\",LOOKUP($F48,Nominal_to_Real,'Input|Rate of change'!Q$25:Q$30),INDEX('Input|Rate of change'!$C$14:$O$21,MATCH('Input|Step changes'!$F12,'Input|Rate of change'!$C$14:$C$21,0),MATCH('Calc|Opex forecast'!$F48,'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($E48=\"$millions\",1000000,IF($E48=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!N12*IF('Input|Step changes'!$F12=\"nominal\",LOOKUP($F48,Nominal_to_Real,'Input|Rate of change'!R$25:R$30),INDEX('Input|Rate of change'!$C$14:$O$21,MATCH('Input|Step changes'!$F12,'Input|Rate of change'!$C$14:$C$21,0),MATCH('Calc|Opex forecast'!$F48,'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($E48=\"$millions\",1000000,IF($E48=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!O12*IF('Input|Step changes'!$F12=\"nominal\",LOOKUP($F48,Nominal_to_Real,'Input|Rate of change'!S$25:S$30),INDEX('Input|Rate of change'!$C$14:$O$21,MATCH('Input|Step changes'!$F12,'Input|Rate of change'!$C$14:$C$21,0),MATCH('Calc|Opex forecast'!$F48,'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($E48=\"$millions\",1000000,IF($E48=\"$000\",1000,1))","v":7.0061744000000008},{"$f":"'Input|Step changes'!P12*IF('Input|Step changes'!$F12=\"nominal\",LOOKUP($F48,Nominal_to_Real,'Input|Rate of change'!T$25:T$30),INDEX('Input|Rate of change'!$C$14:$O$21,MATCH('Input|Step changes'!$F12,'Input|Rate of change'!$C$14:$C$21,0),MATCH('Calc|Opex forecast'!$F48,'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($E48=\"$millions\",1000000,IF($E48=\"$000\",1000,1))","v":7.4270399999999999},{"$f":"'Input|Step changes'!Q12*IF('Input|Step changes'!$F12=\"nominal\",LOOKUP($F48,Nominal_to_Real,'Input|Rate of change'!U$25:U$30),INDEX('Input|Rate of change'!$C$14:$O$21,MATCH('Input|Step changes'!$F12,'Input|Rate of change'!$C$14:$C$21,0),MATCH('Calc|Opex forecast'!$F48,'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($E48=\"$millions\",1000000,IF($E48=\"$000\",1000,1))","v":9.2755869999999998},{"$f":"'Input|Step changes'!R12*IF('Input|Step changes'!$F12=\"nominal\",LOOKUP($F48,Nominal_to_Real,'Input|Rate of change'!V$25:V$30),INDEX('Input|Rate of change'!$C$14:$O$21,MATCH('Input|Step changes'!$F12,'Input|Rate of change'!$C$14:$C$21,0),MATCH('Calc|Opex forecast'!$F48,'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($E48=\"$millions\",1000000,IF($E48=\"$000\",1000,1))","v":-3.7050851202653656},{"$f":"'Input|Step changes'!S12*IF('Input|Step changes'!$F12=\"nominal\",LOOKUP($F48,Nominal_to_Real,'Input|Rate of change'!W$25:W$30),INDEX('Input|Rate of change'!$C$14:$O$21,MATCH('Input|Step changes'!$F12,'Input|Rate of change'!$C$14:$C$21,0),MATCH('Calc|Opex forecast'!$F48,'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($E48=\"$millions\",1000000,IF($E48=\"$000\",1000,1))","v":-3.7384636369962183}]
[null,null,{"$f":"'Input|Step changes'!C13","v":0},"Calculated","$millions",{"$f":"$F$8","v":"2013-14"},null,null,null,{"$f":"'Input|Step changes'!J13*IF('Input|Step changes'!$F13=\"nominal\",LOOKUP($F49,Nominal_to_Real,'Input|Rate of change'!N$25:N$30),INDEX('Input|Rate of change'!$C$14:$O$21,MATCH('Input|Step changes'!$F13,'Input|Rate of change'!$C$14:$C$21,0),MATCH('Calc|Opex forecast'!$F49,'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($E49=\"$millions\",1000000,IF($E49=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!K13*IF('Input|Step changes'!$F13=\"nominal\",LOOKUP($F49,Nominal_to_Real,'Input|Rate of change'!O$25:O$30),INDEX('Input|Rate of change'!$C$14:$O$21,MATCH('Input|Step changes'!$F13,'Input|Rate of change'!$C$14:$C$21,0),MATCH('Calc|Opex forecast'!$F49,'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($E49=\"$millions\",1000000,IF($E49=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!L13*IF('Input|Step changes'!$F13=\"nominal\",LOOKUP($F49,Nominal_to_Real,'Input|Rate of change'!P$25:P$30),INDEX('Input|Rate of change'!$C$14:$O$21,MATCH('Input|Step changes'!$F13,'Input|Rate of change'!$C$14:$C$21,0),MATCH('Calc|Opex forecast'!$F49,'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($E49=\"$millions\",1000000,IF($E49=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!M13*IF('Input|Step changes'!$F13=\"nominal\",LOOKUP($F49,Nominal_to_Real,'Input|Rate of change'!Q$25:Q$30),INDEX('Input|Rate of change'!$C$14:$O$21,MATCH('Input|Step changes'!$F13,'Input|Rate of change'!$C$14:$C$21,0),MATCH('Calc|Opex forecast'!$F49,'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($E49=\"$millions\",1000000,IF($E49=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!N13*IF('Input|Step changes'!$F13=\"nominal\",LOOKUP($F49,Nominal_to_Real,'Input|Rate of change'!R$25:R$30),INDEX('Input|Rate of change'!$C$14:$O$21,MATCH('Input|Step changes'!$F13,'Input|Rate of change'!$C$14:$C$21,0),MATCH('Calc|Opex forecast'!$F49,'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($E49=\"$millions\",1000000,IF($E49=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!O13*IF('Input|Step changes'!$F13=\"nominal\",LOOKUP($F49,Nominal_to_Real,'Input|Rate of change'!S$25:S$30),INDEX('Input|Rate of change'!$C$14:$O$21,MATCH('Input|Step changes'!$F13,'Input|Rate of change'!$C$14:$C$21,0),MATCH('Calc|Opex forecast'!$F49,'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($E49=\"$millions\",1000000,IF($E49=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!P13*IF('Input|Step changes'!$F13=\"nominal\",LOOKUP($F49,Nominal_to_Real,'Input|Rate of change'!T$25:T$30),INDEX('Input|Rate of change'!$C$14:$O$21,MATCH('Input|Step changes'!$F13,'Input|Rate of change'!$C$14:$C$21,0),MATCH('Calc|Opex forecast'!$F49,'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($E49=\"$millions\",1000000,IF($E49=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!Q13*IF('Input|Step changes'!$F13=\"nominal\",LOOKUP($F49,Nominal_to_Real,'Input|Rate of change'!U$25:U$30),INDEX('Input|Rate of change'!$C$14:$O$21,MATCH('Input|Step changes'!$F13,'Input|Rate of change'!$C$14:$C$21,0),MATCH('Calc|Opex forecast'!$F49,'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($E49=\"$millions\",1000000,IF($E49=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!R13*IF('Input|Step changes'!$F13=\"nominal\",LOOKUP($F49,Nominal_to_Real,'Input|Rate of change'!V$25:V$30),INDEX('Input|Rate of change'!$C$14:$O$21,MATCH('Input|Step changes'!$F13,'Input|Rate of change'!$C$14:$C$21,0),MATCH('Calc|Opex forecast'!$F49,'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($E49=\"$millions\",1000000,IF($E49=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!S13*IF('Input|Step changes'!$F13=\"nominal\",LOOKUP($F49,Nominal_to_Real,'Input|Rate of change'!W$25:W$30),INDEX('Input|Rate of change'!$C$14:$O$21,MATCH('Input|Step changes'!$F13,'Input|Rate of change'!$C$14:$C$21,0),MATCH('Calc|Opex forecast'!$F49,'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($E49=\"$millions\",1000000,IF($E49=\"$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($F50,Nominal_to_Real,'Input|Rate of change'!N$25:N$30),INDEX('Input|Rate of change'!$C$14:$O$21,MATCH('Input|Step changes'!$F14,'Input|Rate of change'!$C$14:$C$21,0),MATCH('Calc|Opex forecast'!$F50,'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($E50=\"$millions\",1000000,IF($E50=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!K14*IF('Input|Step changes'!$F14=\"nominal\",LOOKUP($F50,Nominal_to_Real,'Input|Rate of change'!O$25:O$30),INDEX('Input|Rate of change'!$C$14:$O$21,MATCH('Input|Step changes'!$F14,'Input|Rate of change'!$C$14:$C$21,0),MATCH('Calc|Opex forecast'!$F50,'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($E50=\"$millions\",1000000,IF($E50=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!L14*IF('Input|Step changes'!$F14=\"nominal\",LOOKUP($F50,Nominal_to_Real,'Input|Rate of change'!P$25:P$30),INDEX('Input|Rate of change'!$C$14:$O$21,MATCH('Input|Step changes'!$F14,'Input|Rate of change'!$C$14:$C$21,0),MATCH('Calc|Opex forecast'!$F50,'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($E50=\"$millions\",1000000,IF($E50=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!M14*IF('Input|Step changes'!$F14=\"nominal\",LOOKUP($F50,Nominal_to_Real,'Input|Rate of change'!Q$25:Q$30),INDEX('Input|Rate of change'!$C$14:$O$21,MATCH('Input|Step changes'!$F14,'Input|Rate of change'!$C$14:$C$21,0),MATCH('Calc|Opex forecast'!$F50,'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($E50=\"$millions\",1000000,IF($E50=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!N14*IF('Input|Step changes'!$F14=\"nominal\",LOOKUP($F50,Nominal_to_Real,'Input|Rate of change'!R$25:R$30),INDEX('Input|Rate of change'!$C$14:$O$21,MATCH('Input|Step changes'!$F14,'Input|Rate of change'!$C$14:$C$21,0),MATCH('Calc|Opex forecast'!$F50,'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($E50=\"$millions\",1000000,IF($E50=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!O14*IF('Input|Step changes'!$F14=\"nominal\",LOOKUP($F50,Nominal_to_Real,'Input|Rate of change'!S$25:S$30),INDEX('Input|Rate of change'!$C$14:$O$21,MATCH('Input|Step changes'!$F14,'Input|Rate of change'!$C$14:$C$21,0),MATCH('Calc|Opex forecast'!$F50,'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($E50=\"$millions\",1000000,IF($E50=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!P14*IF('Input|Step changes'!$F14=\"nominal\",LOOKUP($F50,Nominal_to_Real,'Input|Rate of change'!T$25:T$30),INDEX('Input|Rate of change'!$C$14:$O$21,MATCH('Input|Step changes'!$F14,'Input|Rate of change'!$C$14:$C$21,0),MATCH('Calc|Opex forecast'!$F50,'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($E50=\"$millions\",1000000,IF($E50=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!Q14*IF('Input|Step changes'!$F14=\"nominal\",LOOKUP($F50,Nominal_to_Real,'Input|Rate of change'!U$25:U$30),INDEX('Input|Rate of change'!$C$14:$O$21,MATCH('Input|Step changes'!$F14,'Input|Rate of change'!$C$14:$C$21,0),MATCH('Calc|Opex forecast'!$F50,'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($E50=\"$millions\",1000000,IF($E50=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!R14*IF('Input|Step changes'!$F14=\"nominal\",LOOKUP($F50,Nominal_to_Real,'Input|Rate of change'!V$25:V$30),INDEX('Input|Rate of change'!$C$14:$O$21,MATCH('Input|Step changes'!$F14,'Input|Rate of change'!$C$14:$C$21,0),MATCH('Calc|Opex forecast'!$F50,'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($E50=\"$millions\",1000000,IF($E50=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!S14*IF('Input|Step changes'!$F14=\"nominal\",LOOKUP($F50,Nominal_to_Real,'Input|Rate of change'!W$25:W$30),INDEX('Input|Rate of change'!$C$14:$O$21,MATCH('Input|Step changes'!$F14,'Input|Rate of change'!$C$14:$C$21,0),MATCH('Calc|Opex forecast'!$F50,'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($E50=\"$millions\",1000000,IF($E50=\"$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($F51,Nominal_to_Real,'Input|Rate of change'!N$25:N$30),INDEX('Input|Rate of change'!$C$14:$O$21,MATCH('Input|Step changes'!$F15,'Input|Rate of change'!$C$14:$C$21,0),MATCH('Calc|Opex forecast'!$F51,'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($E51=\"$millions\",1000000,IF($E51=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!K15*IF('Input|Step changes'!$F15=\"nominal\",LOOKUP($F51,Nominal_to_Real,'Input|Rate of change'!O$25:O$30),INDEX('Input|Rate of change'!$C$14:$O$21,MATCH('Input|Step changes'!$F15,'Input|Rate of change'!$C$14:$C$21,0),MATCH('Calc|Opex forecast'!$F51,'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($E51=\"$millions\",1000000,IF($E51=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!L15*IF('Input|Step changes'!$F15=\"nominal\",LOOKUP($F51,Nominal_to_Real,'Input|Rate of change'!P$25:P$30),INDEX('Input|Rate of change'!$C$14:$O$21,MATCH('Input|Step changes'!$F15,'Input|Rate of change'!$C$14:$C$21,0),MATCH('Calc|Opex forecast'!$F51,'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($E51=\"$millions\",1000000,IF($E51=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!M15*IF('Input|Step changes'!$F15=\"nominal\",LOOKUP($F51,Nominal_to_Real,'Input|Rate of change'!Q$25:Q$30),INDEX('Input|Rate of change'!$C$14:$O$21,MATCH('Input|Step changes'!$F15,'Input|Rate of change'!$C$14:$C$21,0),MATCH('Calc|Opex forecast'!$F51,'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($E51=\"$millions\",1000000,IF($E51=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!N15*IF('Input|Step changes'!$F15=\"nominal\",LOOKUP($F51,Nominal_to_Real,'Input|Rate of change'!R$25:R$30),INDEX('Input|Rate of change'!$C$14:$O$21,MATCH('Input|Step changes'!$F15,'Input|Rate of change'!$C$14:$C$21,0),MATCH('Calc|Opex forecast'!$F51,'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($E51=\"$millions\",1000000,IF($E51=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!O15*IF('Input|Step changes'!$F15=\"nominal\",LOOKUP($F51,Nominal_to_Real,'Input|Rate of change'!S$25:S$30),INDEX('Input|Rate of change'!$C$14:$O$21,MATCH('Input|Step changes'!$F15,'Input|Rate of change'!$C$14:$C$21,0),MATCH('Calc|Opex forecast'!$F51,'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($E51=\"$millions\",1000000,IF($E51=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!P15*IF('Input|Step changes'!$F15=\"nominal\",LOOKUP($F51,Nominal_to_Real,'Input|Rate of change'!T$25:T$30),INDEX('Input|Rate of change'!$C$14:$O$21,MATCH('Input|Step changes'!$F15,'Input|Rate of change'!$C$14:$C$21,0),MATCH('Calc|Opex forecast'!$F51,'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($E51=\"$millions\",1000000,IF($E51=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!Q15*IF('Input|Step changes'!$F15=\"nominal\",LOOKUP($F51,Nominal_to_Real,'Input|Rate of change'!U$25:U$30),INDEX('Input|Rate of change'!$C$14:$O$21,MATCH('Input|Step changes'!$F15,'Input|Rate of change'!$C$14:$C$21,0),MATCH('Calc|Opex forecast'!$F51,'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($E51=\"$millions\",1000000,IF($E51=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!R15*IF('Input|Step changes'!$F15=\"nominal\",LOOKUP($F51,Nominal_to_Real,'Input|Rate of change'!V$25:V$30),INDEX('Input|Rate of change'!$C$14:$O$21,MATCH('Input|Step changes'!$F15,'Input|Rate of change'!$C$14:$C$21,0),MATCH('Calc|Opex forecast'!$F51,'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($E51=\"$millions\",1000000,IF($E51=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!S15*IF('Input|Step changes'!$F15=\"nominal\",LOOKUP($F51,Nominal_to_Real,'Input|Rate of change'!W$25:W$30),INDEX('Input|Rate of change'!$C$14:$O$21,MATCH('Input|Step changes'!$F15,'Input|Rate of change'!$C$14:$C$21,0),MATCH('Calc|Opex forecast'!$F51,'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($E51=\"$millions\",1000000,IF($E51=\"$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($F52,Nominal_to_Real,'Input|Rate of change'!N$25:N$30),INDEX('Input|Rate of change'!$C$14:$O$21,MATCH('Input|Step changes'!$F16,'Input|Rate of change'!$C$14:$C$21,0),MATCH('Calc|Opex forecast'!$F52,'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($E52=\"$millions\",1000000,IF($E52=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!K16*IF('Input|Step changes'!$F16=\"nominal\",LOOKUP($F52,Nominal_to_Real,'Input|Rate of change'!O$25:O$30),INDEX('Input|Rate of change'!$C$14:$O$21,MATCH('Input|Step changes'!$F16,'Input|Rate of change'!$C$14:$C$21,0),MATCH('Calc|Opex forecast'!$F52,'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($E52=\"$millions\",1000000,IF($E52=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!L16*IF('Input|Step changes'!$F16=\"nominal\",LOOKUP($F52,Nominal_to_Real,'Input|Rate of change'!P$25:P$30),INDEX('Input|Rate of change'!$C$14:$O$21,MATCH('Input|Step changes'!$F16,'Input|Rate of change'!$C$14:$C$21,0),MATCH('Calc|Opex forecast'!$F52,'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($E52=\"$millions\",1000000,IF($E52=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!M16*IF('Input|Step changes'!$F16=\"nominal\",LOOKUP($F52,Nominal_to_Real,'Input|Rate of change'!Q$25:Q$30),INDEX('Input|Rate of change'!$C$14:$O$21,MATCH('Input|Step changes'!$F16,'Input|Rate of change'!$C$14:$C$21,0),MATCH('Calc|Opex forecast'!$F52,'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($E52=\"$millions\",1000000,IF($E52=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!N16*IF('Input|Step changes'!$F16=\"nominal\",LOOKUP($F52,Nominal_to_Real,'Input|Rate of change'!R$25:R$30),INDEX('Input|Rate of change'!$C$14:$O$21,MATCH('Input|Step changes'!$F16,'Input|Rate of change'!$C$14:$C$21,0),MATCH('Calc|Opex forecast'!$F52,'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($E52=\"$millions\",1000000,IF($E52=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!O16*IF('Input|Step changes'!$F16=\"nominal\",LOOKUP($F52,Nominal_to_Real,'Input|Rate of change'!S$25:S$30),INDEX('Input|Rate of change'!$C$14:$O$21,MATCH('Input|Step changes'!$F16,'Input|Rate of change'!$C$14:$C$21,0),MATCH('Calc|Opex forecast'!$F52,'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($E52=\"$millions\",1000000,IF($E52=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!P16*IF('Input|Step changes'!$F16=\"nominal\",LOOKUP($F52,Nominal_to_Real,'Input|Rate of change'!T$25:T$30),INDEX('Input|Rate of change'!$C$14:$O$21,MATCH('Input|Step changes'!$F16,'Input|Rate of change'!$C$14:$C$21,0),MATCH('Calc|Opex forecast'!$F52,'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($E52=\"$millions\",1000000,IF($E52=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!Q16*IF('Input|Step changes'!$F16=\"nominal\",LOOKUP($F52,Nominal_to_Real,'Input|Rate of change'!U$25:U$30),INDEX('Input|Rate of change'!$C$14:$O$21,MATCH('Input|Step changes'!$F16,'Input|Rate of change'!$C$14:$C$21,0),MATCH('Calc|Opex forecast'!$F52,'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($E52=\"$millions\",1000000,IF($E52=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!R16*IF('Input|Step changes'!$F16=\"nominal\",LOOKUP($F52,Nominal_to_Real,'Input|Rate of change'!V$25:V$30),INDEX('Input|Rate of change'!$C$14:$O$21,MATCH('Input|Step changes'!$F16,'Input|Rate of change'!$C$14:$C$21,0),MATCH('Calc|Opex forecast'!$F52,'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($E52=\"$millions\",1000000,IF($E52=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!S16*IF('Input|Step changes'!$F16=\"nominal\",LOOKUP($F52,Nominal_to_Real,'Input|Rate of change'!W$25:W$30),INDEX('Input|Rate of change'!$C$14:$O$21,MATCH('Input|Step changes'!$F16,'Input|Rate of change'!$C$14:$C$21,0),MATCH('Calc|Opex forecast'!$F52,'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($E52=\"$millions\",1000000,IF($E52=\"$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($F53,Nominal_to_Real,'Input|Rate of change'!N$25:N$30),INDEX('Input|Rate of change'!$C$14:$O$21,MATCH('Input|Step changes'!$F17,'Input|Rate of change'!$C$14:$C$21,0),MATCH('Calc|Opex forecast'!$F53,'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($E53=\"$millions\",1000000,IF($E53=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!K17*IF('Input|Step changes'!$F17=\"nominal\",LOOKUP($F53,Nominal_to_Real,'Input|Rate of change'!O$25:O$30),INDEX('Input|Rate of change'!$C$14:$O$21,MATCH('Input|Step changes'!$F17,'Input|Rate of change'!$C$14:$C$21,0),MATCH('Calc|Opex forecast'!$F53,'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($E53=\"$millions\",1000000,IF($E53=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!L17*IF('Input|Step changes'!$F17=\"nominal\",LOOKUP($F53,Nominal_to_Real,'Input|Rate of change'!P$25:P$30),INDEX('Input|Rate of change'!$C$14:$O$21,MATCH('Input|Step changes'!$F17,'Input|Rate of change'!$C$14:$C$21,0),MATCH('Calc|Opex forecast'!$F53,'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($E53=\"$millions\",1000000,IF($E53=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!M17*IF('Input|Step changes'!$F17=\"nominal\",LOOKUP($F53,Nominal_to_Real,'Input|Rate of change'!Q$25:Q$30),INDEX('Input|Rate of change'!$C$14:$O$21,MATCH('Input|Step changes'!$F17,'Input|Rate of change'!$C$14:$C$21,0),MATCH('Calc|Opex forecast'!$F53,'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($E53=\"$millions\",1000000,IF($E53=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!N17*IF('Input|Step changes'!$F17=\"nominal\",LOOKUP($F53,Nominal_to_Real,'Input|Rate of change'!R$25:R$30),INDEX('Input|Rate of change'!$C$14:$O$21,MATCH('Input|Step changes'!$F17,'Input|Rate of change'!$C$14:$C$21,0),MATCH('Calc|Opex forecast'!$F53,'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($E53=\"$millions\",1000000,IF($E53=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!O17*IF('Input|Step changes'!$F17=\"nominal\",LOOKUP($F53,Nominal_to_Real,'Input|Rate of change'!S$25:S$30),INDEX('Input|Rate of change'!$C$14:$O$21,MATCH('Input|Step changes'!$F17,'Input|Rate of change'!$C$14:$C$21,0),MATCH('Calc|Opex forecast'!$F53,'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($E53=\"$millions\",1000000,IF($E53=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!P17*IF('Input|Step changes'!$F17=\"nominal\",LOOKUP($F53,Nominal_to_Real,'Input|Rate of change'!T$25:T$30),INDEX('Input|Rate of change'!$C$14:$O$21,MATCH('Input|Step changes'!$F17,'Input|Rate of change'!$C$14:$C$21,0),MATCH('Calc|Opex forecast'!$F53,'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($E53=\"$millions\",1000000,IF($E53=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!Q17*IF('Input|Step changes'!$F17=\"nominal\",LOOKUP($F53,Nominal_to_Real,'Input|Rate of change'!U$25:U$30),INDEX('Input|Rate of change'!$C$14:$O$21,MATCH('Input|Step changes'!$F17,'Input|Rate of change'!$C$14:$C$21,0),MATCH('Calc|Opex forecast'!$F53,'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($E53=\"$millions\",1000000,IF($E53=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!R17*IF('Input|Step changes'!$F17=\"nominal\",LOOKUP($F53,Nominal_to_Real,'Input|Rate of change'!V$25:V$30),INDEX('Input|Rate of change'!$C$14:$O$21,MATCH('Input|Step changes'!$F17,'Input|Rate of change'!$C$14:$C$21,0),MATCH('Calc|Opex forecast'!$F53,'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($E53=\"$millions\",1000000,IF($E53=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!S17*IF('Input|Step changes'!$F17=\"nominal\",LOOKUP($F53,Nominal_to_Real,'Input|Rate of change'!W$25:W$30),INDEX('Input|Rate of change'!$C$14:$O$21,MATCH('Input|Step changes'!$F17,'Input|Rate of change'!$C$14:$C$21,0),MATCH('Calc|Opex forecast'!$F53,'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($E53=\"$millions\",1000000,IF($E53=\"$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($F54,Nominal_to_Real,'Input|Rate of change'!N$25:N$30),INDEX('Input|Rate of change'!$C$14:$O$21,MATCH('Input|Step changes'!$F18,'Input|Rate of change'!$C$14:$C$21,0),MATCH('Calc|Opex forecast'!$F54,'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($E54=\"$millions\",1000000,IF($E54=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!K18*IF('Input|Step changes'!$F18=\"nominal\",LOOKUP($F54,Nominal_to_Real,'Input|Rate of change'!O$25:O$30),INDEX('Input|Rate of change'!$C$14:$O$21,MATCH('Input|Step changes'!$F18,'Input|Rate of change'!$C$14:$C$21,0),MATCH('Calc|Opex forecast'!$F54,'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($E54=\"$millions\",1000000,IF($E54=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!L18*IF('Input|Step changes'!$F18=\"nominal\",LOOKUP($F54,Nominal_to_Real,'Input|Rate of change'!P$25:P$30),INDEX('Input|Rate of change'!$C$14:$O$21,MATCH('Input|Step changes'!$F18,'Input|Rate of change'!$C$14:$C$21,0),MATCH('Calc|Opex forecast'!$F54,'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($E54=\"$millions\",1000000,IF($E54=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!M18*IF('Input|Step changes'!$F18=\"nominal\",LOOKUP($F54,Nominal_to_Real,'Input|Rate of change'!Q$25:Q$30),INDEX('Input|Rate of change'!$C$14:$O$21,MATCH('Input|Step changes'!$F18,'Input|Rate of change'!$C$14:$C$21,0),MATCH('Calc|Opex forecast'!$F54,'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($E54=\"$millions\",1000000,IF($E54=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!N18*IF('Input|Step changes'!$F18=\"nominal\",LOOKUP($F54,Nominal_to_Real,'Input|Rate of change'!R$25:R$30),INDEX('Input|Rate of change'!$C$14:$O$21,MATCH('Input|Step changes'!$F18,'Input|Rate of change'!$C$14:$C$21,0),MATCH('Calc|Opex forecast'!$F54,'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($E54=\"$millions\",1000000,IF($E54=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!O18*IF('Input|Step changes'!$F18=\"nominal\",LOOKUP($F54,Nominal_to_Real,'Input|Rate of change'!S$25:S$30),INDEX('Input|Rate of change'!$C$14:$O$21,MATCH('Input|Step changes'!$F18,'Input|Rate of change'!$C$14:$C$21,0),MATCH('Calc|Opex forecast'!$F54,'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($E54=\"$millions\",1000000,IF($E54=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!P18*IF('Input|Step changes'!$F18=\"nominal\",LOOKUP($F54,Nominal_to_Real,'Input|Rate of change'!T$25:T$30),INDEX('Input|Rate of change'!$C$14:$O$21,MATCH('Input|Step changes'!$F18,'Input|Rate of change'!$C$14:$C$21,0),MATCH('Calc|Opex forecast'!$F54,'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($E54=\"$millions\",1000000,IF($E54=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!Q18*IF('Input|Step changes'!$F18=\"nominal\",LOOKUP($F54,Nominal_to_Real,'Input|Rate of change'!U$25:U$30),INDEX('Input|Rate of change'!$C$14:$O$21,MATCH('Input|Step changes'!$F18,'Input|Rate of change'!$C$14:$C$21,0),MATCH('Calc|Opex forecast'!$F54,'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($E54=\"$millions\",1000000,IF($E54=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!R18*IF('Input|Step changes'!$F18=\"nominal\",LOOKUP($F54,Nominal_to_Real,'Input|Rate of change'!V$25:V$30),INDEX('Input|Rate of change'!$C$14:$O$21,MATCH('Input|Step changes'!$F18,'Input|Rate of change'!$C$14:$C$21,0),MATCH('Calc|Opex forecast'!$F54,'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($E54=\"$millions\",1000000,IF($E54=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!S18*IF('Input|Step changes'!$F18=\"nominal\",LOOKUP($F54,Nominal_to_Real,'Input|Rate of change'!W$25:W$30),INDEX('Input|Rate of change'!$C$14:$O$21,MATCH('Input|Step changes'!$F18,'Input|Rate of change'!$C$14:$C$21,0),MATCH('Calc|Opex forecast'!$F54,'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($E54=\"$millions\",1000000,IF($E54=\"$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($F55,Nominal_to_Real,'Input|Rate of change'!N$25:N$30),INDEX('Input|Rate of change'!$C$14:$O$21,MATCH('Input|Step changes'!$F19,'Input|Rate of change'!$C$14:$C$21,0),MATCH('Calc|Opex forecast'!$F55,'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($E55=\"$millions\",1000000,IF($E55=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!K19*IF('Input|Step changes'!$F19=\"nominal\",LOOKUP($F55,Nominal_to_Real,'Input|Rate of change'!O$25:O$30),INDEX('Input|Rate of change'!$C$14:$O$21,MATCH('Input|Step changes'!$F19,'Input|Rate of change'!$C$14:$C$21,0),MATCH('Calc|Opex forecast'!$F55,'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($E55=\"$millions\",1000000,IF($E55=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!L19*IF('Input|Step changes'!$F19=\"nominal\",LOOKUP($F55,Nominal_to_Real,'Input|Rate of change'!P$25:P$30),INDEX('Input|Rate of change'!$C$14:$O$21,MATCH('Input|Step changes'!$F19,'Input|Rate of change'!$C$14:$C$21,0),MATCH('Calc|Opex forecast'!$F55,'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($E55=\"$millions\",1000000,IF($E55=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!M19*IF('Input|Step changes'!$F19=\"nominal\",LOOKUP($F55,Nominal_to_Real,'Input|Rate of change'!Q$25:Q$30),INDEX('Input|Rate of change'!$C$14:$O$21,MATCH('Input|Step changes'!$F19,'Input|Rate of change'!$C$14:$C$21,0),MATCH('Calc|Opex forecast'!$F55,'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($E55=\"$millions\",1000000,IF($E55=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!N19*IF('Input|Step changes'!$F19=\"nominal\",LOOKUP($F55,Nominal_to_Real,'Input|Rate of change'!R$25:R$30),INDEX('Input|Rate of change'!$C$14:$O$21,MATCH('Input|Step changes'!$F19,'Input|Rate of change'!$C$14:$C$21,0),MATCH('Calc|Opex forecast'!$F55,'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($E55=\"$millions\",1000000,IF($E55=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!O19*IF('Input|Step changes'!$F19=\"nominal\",LOOKUP($F55,Nominal_to_Real,'Input|Rate of change'!S$25:S$30),INDEX('Input|Rate of change'!$C$14:$O$21,MATCH('Input|Step changes'!$F19,'Input|Rate of change'!$C$14:$C$21,0),MATCH('Calc|Opex forecast'!$F55,'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($E55=\"$millions\",1000000,IF($E55=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!P19*IF('Input|Step changes'!$F19=\"nominal\",LOOKUP($F55,Nominal_to_Real,'Input|Rate of change'!T$25:T$30),INDEX('Input|Rate of change'!$C$14:$O$21,MATCH('Input|Step changes'!$F19,'Input|Rate of change'!$C$14:$C$21,0),MATCH('Calc|Opex forecast'!$F55,'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($E55=\"$millions\",1000000,IF($E55=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!Q19*IF('Input|Step changes'!$F19=\"nominal\",LOOKUP($F55,Nominal_to_Real,'Input|Rate of change'!U$25:U$30),INDEX('Input|Rate of change'!$C$14:$O$21,MATCH('Input|Step changes'!$F19,'Input|Rate of change'!$C$14:$C$21,0),MATCH('Calc|Opex forecast'!$F55,'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($E55=\"$millions\",1000000,IF($E55=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!R19*IF('Input|Step changes'!$F19=\"nominal\",LOOKUP($F55,Nominal_to_Real,'Input|Rate of change'!V$25:V$30),INDEX('Input|Rate of change'!$C$14:$O$21,MATCH('Input|Step changes'!$F19,'Input|Rate of change'!$C$14:$C$21,0),MATCH('Calc|Opex forecast'!$F55,'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($E55=\"$millions\",1000000,IF($E55=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!S19*IF('Input|Step changes'!$F19=\"nominal\",LOOKUP($F55,Nominal_to_Real,'Input|Rate of change'!W$25:W$30),INDEX('Input|Rate of change'!$C$14:$O$21,MATCH('Input|Step changes'!$F19,'Input|Rate of change'!$C$14:$C$21,0),MATCH('Calc|Opex forecast'!$F55,'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($E55=\"$millions\",1000000,IF($E55=\"$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($F56,Nominal_to_Real,'Input|Rate of change'!N$25:N$30),INDEX('Input|Rate of change'!$C$14:$O$21,MATCH('Input|Step changes'!$F20,'Input|Rate of change'!$C$14:$C$21,0),MATCH('Calc|Opex forecast'!$F56,'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($E56=\"$millions\",1000000,IF($E56=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!K20*IF('Input|Step changes'!$F20=\"nominal\",LOOKUP($F56,Nominal_to_Real,'Input|Rate of change'!O$25:O$30),INDEX('Input|Rate of change'!$C$14:$O$21,MATCH('Input|Step changes'!$F20,'Input|Rate of change'!$C$14:$C$21,0),MATCH('Calc|Opex forecast'!$F56,'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($E56=\"$millions\",1000000,IF($E56=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!L20*IF('Input|Step changes'!$F20=\"nominal\",LOOKUP($F56,Nominal_to_Real,'Input|Rate of change'!P$25:P$30),INDEX('Input|Rate of change'!$C$14:$O$21,MATCH('Input|Step changes'!$F20,'Input|Rate of change'!$C$14:$C$21,0),MATCH('Calc|Opex forecast'!$F56,'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($E56=\"$millions\",1000000,IF($E56=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!M20*IF('Input|Step changes'!$F20=\"nominal\",LOOKUP($F56,Nominal_to_Real,'Input|Rate of change'!Q$25:Q$30),INDEX('Input|Rate of change'!$C$14:$O$21,MATCH('Input|Step changes'!$F20,'Input|Rate of change'!$C$14:$C$21,0),MATCH('Calc|Opex forecast'!$F56,'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($E56=\"$millions\",1000000,IF($E56=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!N20*IF('Input|Step changes'!$F20=\"nominal\",LOOKUP($F56,Nominal_to_Real,'Input|Rate of change'!R$25:R$30),INDEX('Input|Rate of change'!$C$14:$O$21,MATCH('Input|Step changes'!$F20,'Input|Rate of change'!$C$14:$C$21,0),MATCH('Calc|Opex forecast'!$F56,'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($E56=\"$millions\",1000000,IF($E56=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!O20*IF('Input|Step changes'!$F20=\"nominal\",LOOKUP($F56,Nominal_to_Real,'Input|Rate of change'!S$25:S$30),INDEX('Input|Rate of change'!$C$14:$O$21,MATCH('Input|Step changes'!$F20,'Input|Rate of change'!$C$14:$C$21,0),MATCH('Calc|Opex forecast'!$F56,'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($E56=\"$millions\",1000000,IF($E56=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!P20*IF('Input|Step changes'!$F20=\"nominal\",LOOKUP($F56,Nominal_to_Real,'Input|Rate of change'!T$25:T$30),INDEX('Input|Rate of change'!$C$14:$O$21,MATCH('Input|Step changes'!$F20,'Input|Rate of change'!$C$14:$C$21,0),MATCH('Calc|Opex forecast'!$F56,'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($E56=\"$millions\",1000000,IF($E56=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!Q20*IF('Input|Step changes'!$F20=\"nominal\",LOOKUP($F56,Nominal_to_Real,'Input|Rate of change'!U$25:U$30),INDEX('Input|Rate of change'!$C$14:$O$21,MATCH('Input|Step changes'!$F20,'Input|Rate of change'!$C$14:$C$21,0),MATCH('Calc|Opex forecast'!$F56,'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($E56=\"$millions\",1000000,IF($E56=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!R20*IF('Input|Step changes'!$F20=\"nominal\",LOOKUP($F56,Nominal_to_Real,'Input|Rate of change'!V$25:V$30),INDEX('Input|Rate of change'!$C$14:$O$21,MATCH('Input|Step changes'!$F20,'Input|Rate of change'!$C$14:$C$21,0),MATCH('Calc|Opex forecast'!$F56,'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($E56=\"$millions\",1000000,IF($E56=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!S20*IF('Input|Step changes'!$F20=\"nominal\",LOOKUP($F56,Nominal_to_Real,'Input|Rate of change'!W$25:W$30),INDEX('Input|Rate of change'!$C$14:$O$21,MATCH('Input|Step changes'!$F20,'Input|Rate of change'!$C$14:$C$21,0),MATCH('Calc|Opex forecast'!$F56,'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($E56=\"$millions\",1000000,IF($E56=\"$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($F57,Nominal_to_Real,'Input|Rate of change'!N$25:N$30),INDEX('Input|Rate of change'!$C$14:$O$21,MATCH('Input|Step changes'!$F21,'Input|Rate of change'!$C$14:$C$21,0),MATCH('Calc|Opex forecast'!$F57,'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($E57=\"$millions\",1000000,IF($E57=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!K21*IF('Input|Step changes'!$F21=\"nominal\",LOOKUP($F57,Nominal_to_Real,'Input|Rate of change'!O$25:O$30),INDEX('Input|Rate of change'!$C$14:$O$21,MATCH('Input|Step changes'!$F21,'Input|Rate of change'!$C$14:$C$21,0),MATCH('Calc|Opex forecast'!$F57,'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($E57=\"$millions\",1000000,IF($E57=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!L21*IF('Input|Step changes'!$F21=\"nominal\",LOOKUP($F57,Nominal_to_Real,'Input|Rate of change'!P$25:P$30),INDEX('Input|Rate of change'!$C$14:$O$21,MATCH('Input|Step changes'!$F21,'Input|Rate of change'!$C$14:$C$21,0),MATCH('Calc|Opex forecast'!$F57,'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($E57=\"$millions\",1000000,IF($E57=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!M21*IF('Input|Step changes'!$F21=\"nominal\",LOOKUP($F57,Nominal_to_Real,'Input|Rate of change'!Q$25:Q$30),INDEX('Input|Rate of change'!$C$14:$O$21,MATCH('Input|Step changes'!$F21,'Input|Rate of change'!$C$14:$C$21,0),MATCH('Calc|Opex forecast'!$F57,'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($E57=\"$millions\",1000000,IF($E57=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!N21*IF('Input|Step changes'!$F21=\"nominal\",LOOKUP($F57,Nominal_to_Real,'Input|Rate of change'!R$25:R$30),INDEX('Input|Rate of change'!$C$14:$O$21,MATCH('Input|Step changes'!$F21,'Input|Rate of change'!$C$14:$C$21,0),MATCH('Calc|Opex forecast'!$F57,'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($E57=\"$millions\",1000000,IF($E57=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!O21*IF('Input|Step changes'!$F21=\"nominal\",LOOKUP($F57,Nominal_to_Real,'Input|Rate of change'!S$25:S$30),INDEX('Input|Rate of change'!$C$14:$O$21,MATCH('Input|Step changes'!$F21,'Input|Rate of change'!$C$14:$C$21,0),MATCH('Calc|Opex forecast'!$F57,'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($E57=\"$millions\",1000000,IF($E57=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!P21*IF('Input|Step changes'!$F21=\"nominal\",LOOKUP($F57,Nominal_to_Real,'Input|Rate of change'!T$25:T$30),INDEX('Input|Rate of change'!$C$14:$O$21,MATCH('Input|Step changes'!$F21,'Input|Rate of change'!$C$14:$C$21,0),MATCH('Calc|Opex forecast'!$F57,'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($E57=\"$millions\",1000000,IF($E57=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!Q21*IF('Input|Step changes'!$F21=\"nominal\",LOOKUP($F57,Nominal_to_Real,'Input|Rate of change'!U$25:U$30),INDEX('Input|Rate of change'!$C$14:$O$21,MATCH('Input|Step changes'!$F21,'Input|Rate of change'!$C$14:$C$21,0),MATCH('Calc|Opex forecast'!$F57,'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($E57=\"$millions\",1000000,IF($E57=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!R21*IF('Input|Step changes'!$F21=\"nominal\",LOOKUP($F57,Nominal_to_Real,'Input|Rate of change'!V$25:V$30),INDEX('Input|Rate of change'!$C$14:$O$21,MATCH('Input|Step changes'!$F21,'Input|Rate of change'!$C$14:$C$21,0),MATCH('Calc|Opex forecast'!$F57,'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($E57=\"$millions\",1000000,IF($E57=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!S21*IF('Input|Step changes'!$F21=\"nominal\",LOOKUP($F57,Nominal_to_Real,'Input|Rate of change'!W$25:W$30),INDEX('Input|Rate of change'!$C$14:$O$21,MATCH('Input|Step changes'!$F21,'Input|Rate of change'!$C$14:$C$21,0),MATCH('Calc|Opex forecast'!$F57,'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($E57=\"$millions\",1000000,IF($E57=\"$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($F58,Nominal_to_Real,'Input|Rate of change'!N$25:N$30),INDEX('Input|Rate of change'!$C$14:$O$21,MATCH('Input|Step changes'!$F22,'Input|Rate of change'!$C$14:$C$21,0),MATCH('Calc|Opex forecast'!$F58,'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($E58=\"$millions\",1000000,IF($E58=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!K22*IF('Input|Step changes'!$F22=\"nominal\",LOOKUP($F58,Nominal_to_Real,'Input|Rate of change'!O$25:O$30),INDEX('Input|Rate of change'!$C$14:$O$21,MATCH('Input|Step changes'!$F22,'Input|Rate of change'!$C$14:$C$21,0),MATCH('Calc|Opex forecast'!$F58,'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($E58=\"$millions\",1000000,IF($E58=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!L22*IF('Input|Step changes'!$F22=\"nominal\",LOOKUP($F58,Nominal_to_Real,'Input|Rate of change'!P$25:P$30),INDEX('Input|Rate of change'!$C$14:$O$21,MATCH('Input|Step changes'!$F22,'Input|Rate of change'!$C$14:$C$21,0),MATCH('Calc|Opex forecast'!$F58,'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($E58=\"$millions\",1000000,IF($E58=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!M22*IF('Input|Step changes'!$F22=\"nominal\",LOOKUP($F58,Nominal_to_Real,'Input|Rate of change'!Q$25:Q$30),INDEX('Input|Rate of change'!$C$14:$O$21,MATCH('Input|Step changes'!$F22,'Input|Rate of change'!$C$14:$C$21,0),MATCH('Calc|Opex forecast'!$F58,'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($E58=\"$millions\",1000000,IF($E58=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!N22*IF('Input|Step changes'!$F22=\"nominal\",LOOKUP($F58,Nominal_to_Real,'Input|Rate of change'!R$25:R$30),INDEX('Input|Rate of change'!$C$14:$O$21,MATCH('Input|Step changes'!$F22,'Input|Rate of change'!$C$14:$C$21,0),MATCH('Calc|Opex forecast'!$F58,'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($E58=\"$millions\",1000000,IF($E58=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!O22*IF('Input|Step changes'!$F22=\"nominal\",LOOKUP($F58,Nominal_to_Real,'Input|Rate of change'!S$25:S$30),INDEX('Input|Rate of change'!$C$14:$O$21,MATCH('Input|Step changes'!$F22,'Input|Rate of change'!$C$14:$C$21,0),MATCH('Calc|Opex forecast'!$F58,'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($E58=\"$millions\",1000000,IF($E58=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!P22*IF('Input|Step changes'!$F22=\"nominal\",LOOKUP($F58,Nominal_to_Real,'Input|Rate of change'!T$25:T$30),INDEX('Input|Rate of change'!$C$14:$O$21,MATCH('Input|Step changes'!$F22,'Input|Rate of change'!$C$14:$C$21,0),MATCH('Calc|Opex forecast'!$F58,'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($E58=\"$millions\",1000000,IF($E58=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!Q22*IF('Input|Step changes'!$F22=\"nominal\",LOOKUP($F58,Nominal_to_Real,'Input|Rate of change'!U$25:U$30),INDEX('Input|Rate of change'!$C$14:$O$21,MATCH('Input|Step changes'!$F22,'Input|Rate of change'!$C$14:$C$21,0),MATCH('Calc|Opex forecast'!$F58,'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($E58=\"$millions\",1000000,IF($E58=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!R22*IF('Input|Step changes'!$F22=\"nominal\",LOOKUP($F58,Nominal_to_Real,'Input|Rate of change'!V$25:V$30),INDEX('Input|Rate of change'!$C$14:$O$21,MATCH('Input|Step changes'!$F22,'Input|Rate of change'!$C$14:$C$21,0),MATCH('Calc|Opex forecast'!$F58,'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($E58=\"$millions\",1000000,IF($E58=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!S22*IF('Input|Step changes'!$F22=\"nominal\",LOOKUP($F58,Nominal_to_Real,'Input|Rate of change'!W$25:W$30),INDEX('Input|Rate of change'!$C$14:$O$21,MATCH('Input|Step changes'!$F22,'Input|Rate of change'!$C$14:$C$21,0),MATCH('Calc|Opex forecast'!$F58,'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($E58=\"$millions\",1000000,IF($E58=\"$000\",1000,1))","v":0}]
[null,null,{"$f":"'Input|Step changes'!C23","v":0},"Calculated","$millions","2013-14",null,null,null,{"$f":"'Input|Step changes'!J23*IF('Input|Step changes'!$F23=\"nominal\",LOOKUP($F59,Nominal_to_Real,'Input|Rate of change'!N$25:N$30),INDEX('Input|Rate of change'!$C$14:$O$21,MATCH('Input|Step changes'!$F23,'Input|Rate of change'!$C$14:$C$21,0),MATCH('Calc|Opex forecast'!$F59,'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($E59=\"$millions\",1000000,IF($E59=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!K23*IF('Input|Step changes'!$F23=\"nominal\",LOOKUP($F59,Nominal_to_Real,'Input|Rate of change'!O$25:O$30),INDEX('Input|Rate of change'!$C$14:$O$21,MATCH('Input|Step changes'!$F23,'Input|Rate of change'!$C$14:$C$21,0),MATCH('Calc|Opex forecast'!$F59,'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($E59=\"$millions\",1000000,IF($E59=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!L23*IF('Input|Step changes'!$F23=\"nominal\",LOOKUP($F59,Nominal_to_Real,'Input|Rate of change'!P$25:P$30),INDEX('Input|Rate of change'!$C$14:$O$21,MATCH('Input|Step changes'!$F23,'Input|Rate of change'!$C$14:$C$21,0),MATCH('Calc|Opex forecast'!$F59,'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($E59=\"$millions\",1000000,IF($E59=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!M23*IF('Input|Step changes'!$F23=\"nominal\",LOOKUP($F59,Nominal_to_Real,'Input|Rate of change'!Q$25:Q$30),INDEX('Input|Rate of change'!$C$14:$O$21,MATCH('Input|Step changes'!$F23,'Input|Rate of change'!$C$14:$C$21,0),MATCH('Calc|Opex forecast'!$F59,'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($E59=\"$millions\",1000000,IF($E59=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!N23*IF('Input|Step changes'!$F23=\"nominal\",LOOKUP($F59,Nominal_to_Real,'Input|Rate of change'!R$25:R$30),INDEX('Input|Rate of change'!$C$14:$O$21,MATCH('Input|Step changes'!$F23,'Input|Rate of change'!$C$14:$C$21,0),MATCH('Calc|Opex forecast'!$F59,'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($E59=\"$millions\",1000000,IF($E59=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!O23*IF('Input|Step changes'!$F23=\"nominal\",LOOKUP($F59,Nominal_to_Real,'Input|Rate of change'!S$25:S$30),INDEX('Input|Rate of change'!$C$14:$O$21,MATCH('Input|Step changes'!$F23,'Input|Rate of change'!$C$14:$C$21,0),MATCH('Calc|Opex forecast'!$F59,'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($E59=\"$millions\",1000000,IF($E59=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!P23*IF('Input|Step changes'!$F23=\"nominal\",LOOKUP($F59,Nominal_to_Real,'Input|Rate of change'!T$25:T$30),INDEX('Input|Rate of change'!$C$14:$O$21,MATCH('Input|Step changes'!$F23,'Input|Rate of change'!$C$14:$C$21,0),MATCH('Calc|Opex forecast'!$F59,'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($E59=\"$millions\",1000000,IF($E59=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!Q23*IF('Input|Step changes'!$F23=\"nominal\",LOOKUP($F59,Nominal_to_Real,'Input|Rate of change'!U$25:U$30),INDEX('Input|Rate of change'!$C$14:$O$21,MATCH('Input|Step changes'!$F23,'Input|Rate of change'!$C$14:$C$21,0),MATCH('Calc|Opex forecast'!$F59,'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($E59=\"$millions\",1000000,IF($E59=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!R23*IF('Input|Step changes'!$F23=\"nominal\",LOOKUP($F59,Nominal_to_Real,'Input|Rate of change'!V$25:V$30),INDEX('Input|Rate of change'!$C$14:$O$21,MATCH('Input|Step changes'!$F23,'Input|Rate of change'!$C$14:$C$21,0),MATCH('Calc|Opex forecast'!$F59,'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($E59=\"$millions\",1000000,IF($E59=\"$000\",1000,1))","v":0},{"$f":"'Input|Step changes'!S23*IF('Input|Step changes'!$F23=\"nominal\",LOOKUP($F59,Nominal_to_Real,'Input|Rate of change'!W$25:W$30),INDEX('Input|Rate of change'!$C$14:$O$21,MATCH('Input|Step changes'!$F23,'Input|Rate of change'!$C$14:$C$21,0),MATCH('Calc|Opex forecast'!$F59,'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($E59=\"$millions\",1000000,IF($E59=\"$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(J48:J60)","v":0},{"$f":"SUM(K48:K60)","v":0},0,0,0,{"$f":"SUM(O48:O60)","v":7.0061744000000008},7.4270399999999999,9.2755869999999998,-3.7050851202653656,-3.7384636369962183]
[]
[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 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":520.6983719735307},{"$f":"N19","v":521.62018786254089},{"$f":"IF(RIGHT(O$4,2)>=RIGHT('Input|General'!$G$11,2),IF(RIGHT(O$4,2)<='Input|General'!$G$12,IF(ISBLANK(O65),\"\",PRODUCT(1+$J42:O42)*SUM($J29:$S29)+O61),\"\"),\"\")","v":337.48415909664061},{"$f":"IF(RIGHT(P$4,2)>=RIGHT('Input|General'!$G$11,2),IF(RIGHT(P$4,2)<='Input|General'!$G$12,IF(ISBLANK(P65),\"\",PRODUCT(1+$J42:P42)*SUM($J29:$S29)+P61),\"\"),\"\")","v":342.2227979875932},{"$f":"IF(RIGHT(Q$4,2)>=RIGHT('Input|General'!$G$11,2),IF(RIGHT(Q$4,2)<='Input|General'!$G$12,IF(ISBLANK(Q65),\"\",PRODUCT(1+$J42:Q42)*SUM($J29:$S29)+Q61),\"\"),\"\")","v":349.78961922845781},{"$f":"IF(RIGHT(R$4,2)>=RIGHT('Input|General'!$G$11,2),IF(RIGHT(R$4,2)<='Input|General'!$G$12,IF(ISBLANK(R65),\"\",PRODUCT(1+$J42:R42)*SUM($J29:$S29)+R61),\"\"),\"\")","v":343.21825940844803},{"$f":"IF(RIGHT(S$4,2)>=RIGHT('Input|General'!$G$11,2),IF(RIGHT(S$4,2)<='Input|General'!$G$12,IF(ISBLANK(S65),\"\",PRODUCT(1+$J42:S42)*SUM($J29:$S29)+S61),\"\"),\"\")","v":349.23337287596928}]
[]
[null,null,"Total forecast opex, ex DRC, distribution","Calculated",{"$f":"$E$8","v":"$millions"},{"$f":"$F$8","v":"2013-14"},null,null,null,null,null,null,null,null,{"$f":"O$67*'Input|Dx Tx split'!O12","v":313.23324325206033},{"$f":"P$67*'Input|Dx Tx split'!P12","v":317.59153851911719},{"$f":"Q$67*'Input|Dx Tx split'!Q12","v":324.49359733037733},{"$f":"R$67*'Input|Dx Tx split'!R12","v":318.96894245190811},{"$f":"S$67*'Input|Dx Tx split'!S12","v":324.59005981400389}]
[null,null,"Total forecast opex, ex, DRC, transmission","Calculated",{"$f":"$E$8","v":"$millions"},{"$f":"$F$8","v":"2013-14"},null,null,null,null,null,null,null,null,{"$f":"O$67*'Input|Dx Tx split'!O13","v":24.250915844580426},{"$f":"P$67*'Input|Dx Tx split'!P13","v":24.631259468476067},{"$f":"Q$67*'Input|Dx Tx split'!Q13","v":25.296021898080543},{"$f":"R$67*'Input|Dx Tx split'!R13","v":24.249316956539932},{"$f":"S$67*'Input|Dx Tx split'!S13","v":24.643313061965433}]
[]
[null,null,"Total forecast opex, including debt raising costs","Calculated",{"$f":"$E$8","v":"$millions"},{"$f":"$F$8","v":"2013-14"},null,null,null,null,null,null,null,null,{"$f":"O67+'Input|Step changes'!O29+'Input|Step changes'!O30","v":344.75275457990921},{"$f":"P67+'Input|Step changes'!P29+'Input|Step changes'!P30","v":349.5344279626292},{"$f":"Q67+'Input|Step changes'!Q29+'Input|Step changes'!Q30","v":357.1229855016378},{"$f":"R67+'Input|Step changes'!R29+'Input|Step changes'!R30","v":350.52351107990091},{"$f":"S67+'Input|Step changes'!S29+'Input|Step changes'!S30","v":356.53387364026941}]
[]
[null,null,"Total forecast opex, incl DRC, distribution","Calculated",{"$f":"$E$8","v":"$millions"},{"$f":"$F$8","v":"2013-14"},null,null,null,null,null,null,null,null,{"$f":"O69+'Input|Step changes'!O29","v":319.46618288724096},{"$f":"P69+'Input|Step changes'!P29","v":323.85125638584901},{"$f":"Q69+'Input|Step changes'!Q29","v":330.76342699048735},{"$f":"R69+'Input|Step changes'!R29","v":325.21737215695549},{"$f":"S69+'Input|Step changes'!S29","v":330.83666783272849}]
[null,null,"Total forecast opex, incl DRC, transmission","Calculated",{"$f":"$E$8","v":"$millions"},{"$f":"$F$8","v":"2013-14"},null,null,null,null,null,null,null,null,{"$f":"O70+'Input|Step changes'!O30","v":25.286571692668375},{"$f":"P70+'Input|Step changes'!P30","v":25.683171576780261},{"$f":"Q70+'Input|Step changes'!Q30","v":26.359558511150507},{"$f":"R70+'Input|Step changes'!R30","v":25.306138922945426},{"$f":"S70+'Input|Step changes'!S30","v":25.69720580754095}]
[]
[null,"End"]

{"sheet":"Output|Models","index":8,"n_rows":17,"n_cols":22,"rows_kept":17,"cut":false,"hidden":false,"merged":[[2,9,2,11],[2,13,2,18]]}
[null,{"$f":"Index!$B$1","v":"AER opex model"},null,null,null,null,null,null,null,"Back to Index",null,"Key:","Input","External Link","Internal Link",null,null,"Worksheet check:",{"$f":"IF(COUNTA($W$16:$W$473)=COUNTIF($W$16:$W$473,\"OK\"),\"OK\",\"Check\")","v":"OK"},null,"Overall Check:",{"$f":"'Check|List'!$S$1","v":"Ok"}]
[null,{"$f":"Index!$C$14","v":"Output | Models"}]
[]
[null,null,null,"Source","Unit","Basis",null,null,null,{"$f":"'Input|General'!$G$8","v":"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,"Forecast operating expenditure (excl. DRC)","Source","Unit","Basis",null,null,null,{"$f":"IF(RIGHT(J$4,2)>=RIGHT('Input|General'!$G$11,2),IF(RIGHT(J$4,2)<=RIGHT('Input|General'!$G$12,2),J$4,\"\"),\"\")","v":""},{"$f":"IF(RIGHT(K$4,2)>=RIGHT('Input|General'!$G$11,2),IF(RIGHT(K$4,2)<=RIGHT('Input|General'!$G$12,2),K$4,\"\"),\"\")","v":""},{"$f":"IF(RIGHT(L$4,2)>=RIGHT('Input|General'!$G$11,2),IF(RIGHT(L$4,2)<=RIGHT('Input|General'!$G$12,2),L$4,\"\"),\"\")","v":""},{"$f":"IF(RIGHT(M$4,2)>=RIGHT('Input|General'!$G$11,2),IF(RIGHT(M$4,2)<=RIGHT('Input|General'!$G$12,2),M$4,\"\"),\"\")","v":""},{"$f":"IF(RIGHT(N$4,2)>=RIGHT('Input|General'!$G$11,2),IF(RIGHT(N$4,2)<=RIGHT('Input|General'!$G$12,2),N$4,\"\"),\"\")","v":""},{"$f":"IF(RIGHT(O$4,2)>=RIGHT('Input|General'!$G$11,2),IF(RIGHT(O$4,2)<=RIGHT('Input|General'!$G$12,2),O$4,\"\"),\"\")","v":"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,"Distribution","Calc | Opex forecast",{"$f":"$E$8","v":"$millions"},{"$f":"$F$8","v":"2013-14"},null,null,null,{"$f":"IF(J11=\"\",0,'Calc|Opex forecast'!J69*IF('Calc|Opex forecast'!$F$69=\"nominal\",LOOKUP($F12,Nominal_to_Real,'Input|Rate of change'!P$25:P$30),INDEX('Input|Rate of change'!$C$14:$O$21,MATCH('Calc|Opex forecast'!$F$69,'Input|Rate of change'!$C$14:$C$21,0),MATCH('Output|Models'!$F12,'Input|Rate of change'!$C$14:$O$14,0)))*IF('Calc|Opex forecast'!$E$69=\"$millions\",1000000,IF('Output|Models'!B49=\"$000\",1000,1))/IF($E12=\"$millions\",1000000,IF($E12=\"$000\",1000,1)))","v":0},{"$f":"IF(K11=\"\",0,'Calc|Opex forecast'!K69*IF('Calc|Opex forecast'!$F$69=\"nominal\",LOOKUP($F12,Nominal_to_Real,'Input|Rate of change'!Q$25:Q$30),INDEX('Input|Rate of change'!$C$14:$O$21,MATCH('Calc|Opex forecast'!$F$69,'Input|Rate of change'!$C$14:$C$21,0),MATCH('Output|Models'!$F12,'Input|Rate of change'!$C$14:$O$14,0)))*IF('Calc|Opex forecast'!$E$69=\"$millions\",1000000,IF('Output|Models'!C49=\"$000\",1000,1))/IF($E12=\"$millions\",1000000,IF($E12=\"$000\",1000,1)))","v":0},{"$f":"IF(L11=\"\",0,'Calc|Opex forecast'!L69*IF('Calc|Opex forecast'!$F$69=\"nominal\",LOOKUP($F12,Nominal_to_Real,'Input|Rate of change'!R$25:R$30),INDEX('Input|Rate of change'!$C$14:$O$21,MATCH('Calc|Opex forecast'!$F$69,'Input|Rate of change'!$C$14:$C$21,0),MATCH('Output|Models'!$F12,'Input|Rate of change'!$C$14:$O$14,0)))*IF('Calc|Opex forecast'!$E$69=\"$millions\",1000000,IF('Output|Models'!D49=\"$000\",1000,1))/IF($E12=\"$millions\",1000000,IF($E12=\"$000\",1000,1)))","v":0},{"$f":"IF(M11=\"\",0,'Calc|Opex forecast'!M69*IF('Calc|Opex forecast'!$F$69=\"nominal\",LOOKUP($F12,Nominal_to_Real,'Input|Rate of change'!S$25:S$30),INDEX('Input|Rate of change'!$C$14:$O$21,MATCH('Calc|Opex forecast'!$F$69,'Input|Rate of change'!$C$14:$C$21,0),MATCH('Output|Models'!$F12,'Input|Rate of change'!$C$14:$O$14,0)))*IF('Calc|Opex forecast'!$E$69=\"$millions\",1000000,IF('Output|Models'!E49=\"$000\",1000,1))/IF($E12=\"$millions\",1000000,IF($E12=\"$000\",1000,1)))","v":0},{"$f":"IF(N11=\"\",0,'Calc|Opex forecast'!N69*IF('Calc|Opex forecast'!$F$69=\"nominal\",LOOKUP($F12,Nominal_to_Real,'Input|Rate of change'!T$25:T$30),INDEX('Input|Rate of change'!$C$14:$O$21,MATCH('Calc|Opex forecast'!$F$69,'Input|Rate of change'!$C$14:$C$21,0),MATCH('Output|Models'!$F12,'Input|Rate of change'!$C$14:$O$14,0)))*IF('Calc|Opex forecast'!$E$69=\"$millions\",1000000,IF('Output|Models'!F49=\"$000\",1000,1))/IF($E12=\"$millions\",1000000,IF($E12=\"$000\",1000,1)))","v":0},{"$f":"IF(O11=\"\",0,'Calc|Opex forecast'!O69*IF('Calc|Opex forecast'!$F$69=\"nominal\",LOOKUP($F12,Nominal_to_Real,'Input|Rate of change'!U$25:U$30),INDEX('Input|Rate of change'!$C$14:$O$21,MATCH('Calc|Opex forecast'!$F$69,'Input|Rate of change'!$C$14:$C$21,0),MATCH('Output|Models'!$F12,'Input|Rate of change'!$C$14:$O$14,0)))*IF('Calc|Opex forecast'!$E$69=\"$millions\",1000000,IF('Output|Models'!G49=\"$000\",1000,1))/IF($E12=\"$millions\",1000000,IF($E12=\"$000\",1000,1)))","v":313.23324325206033},{"$f":"IF(P11=\"\",0,'Calc|Opex forecast'!P69*IF('Calc|Opex forecast'!$F$69=\"nominal\",LOOKUP($F12,Nominal_to_Real,'Input|Rate of change'!V$25:V$30),INDEX('Input|Rate of change'!$C$14:$O$21,MATCH('Calc|Opex forecast'!$F$69,'Input|Rate of change'!$C$14:$C$21,0),MATCH('Output|Models'!$F12,'Input|Rate of change'!$C$14:$O$14,0)))*IF('Calc|Opex forecast'!$E$69=\"$millions\",1000000,IF('Output|Models'!H49=\"$000\",1000,1))/IF($E12=\"$millions\",1000000,IF($E12=\"$000\",1000,1)))","v":317.59153851911719},{"$f":"IF(Q11=\"\",0,'Calc|Opex forecast'!Q69*IF('Calc|Opex forecast'!$F$69=\"nominal\",LOOKUP($F12,Nominal_to_Real,'Input|Rate of change'!W$25:W$30),INDEX('Input|Rate of change'!$C$14:$O$21,MATCH('Calc|Opex forecast'!$F$69,'Input|Rate of change'!$C$14:$C$21,0),MATCH('Output|Models'!$F12,'Input|Rate of change'!$C$14:$O$14,0)))*IF('Calc|Opex forecast'!$E$69=\"$millions\",1000000,IF('Output|Models'!I49=\"$000\",1000,1))/IF($E12=\"$millions\",1000000,IF($E12=\"$000\",1000,1)))","v":324.49359733037733},{"$f":"IF(R11=\"\",0,'Calc|Opex forecast'!R69*IF('Calc|Opex forecast'!$F$69=\"nominal\",LOOKUP($F12,Nominal_to_Real,'Input|Rate of change'!X$25:X$30),INDEX('Input|Rate of change'!$C$14:$O$21,MATCH('Calc|Opex forecast'!$F$69,'Input|Rate of change'!$C$14:$C$21,0),MATCH('Output|Models'!$F12,'Input|Rate of change'!$C$14:$O$14,0)))*IF('Calc|Opex forecast'!$E$69=\"$millions\",1000000,IF('Output|Models'!J49=\"$000\",1000,1))/IF($E12=\"$millions\",1000000,IF($E12=\"$000\",1000,1)))","v":318.96894245190811},{"$f":"IF(S11=\"\",0,'Calc|Opex forecast'!S69*IF('Calc|Opex forecast'!$F$69=\"nominal\",LOOKUP($F12,Nominal_to_Real,'Input|Rate of change'!Y$25:Y$30),INDEX('Input|Rate of change'!$C$14:$O$21,MATCH('Calc|Opex forecast'!$F$69,'Input|Rate of change'!$C$14:$C$21,0),MATCH('Output|Models'!$F12,'Input|Rate of change'!$C$14:$O$14,0)))*IF('Calc|Opex forecast'!$E$69=\"$millions\",1000000,IF('Output|Models'!K49=\"$000\",1000,1))/IF($E12=\"$millions\",1000000,IF($E12=\"$000\",1000,1)))","v":324.59005981400389}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(O12:S12)","v":1598.877381367467}]
[null,null,"Transmission","Calc | Opex forecast",{"$f":"$E$8","v":"$millions"},{"$f":"$F$8","v":"2013-14"},null,null,null,{"$f":"IF(J11=\"\",0,'Calc|Opex forecast'!J70*IF('Calc|Opex forecast'!$F$70=\"nominal\",LOOKUP($F12,Nominal_to_Real,'Input|Rate of change'!P$25:P$30),INDEX('Input|Rate of change'!$C$14:$O$21,MATCH('Calc|Opex forecast'!$F$70,'Input|Rate of change'!$C$14:$C$21,0),MATCH('Output|Models'!$F12,'Input|Rate of change'!$C$14:$O$14,0)))*IF('Calc|Opex forecast'!$E$70=\"$millions\",1000000,IF('Output|Models'!B49=\"$000\",1000,1))/IF($E12=\"$millions\",1000000,IF($E12=\"$000\",1000,1)))","v":0},{"$f":"IF(K11=\"\",0,'Calc|Opex forecast'!K70*IF('Calc|Opex forecast'!$F$70=\"nominal\",LOOKUP($F12,Nominal_to_Real,'Input|Rate of change'!Q$25:Q$30),INDEX('Input|Rate of change'!$C$14:$O$21,MATCH('Calc|Opex forecast'!$F$70,'Input|Rate of change'!$C$14:$C$21,0),MATCH('Output|Models'!$F12,'Input|Rate of change'!$C$14:$O$14,0)))*IF('Calc|Opex forecast'!$E$70=\"$millions\",1000000,IF('Output|Models'!C49=\"$000\",1000,1))/IF($E12=\"$millions\",1000000,IF($E12=\"$000\",1000,1)))","v":0},{"$f":"IF(L11=\"\",0,'Calc|Opex forecast'!L70*IF('Calc|Opex forecast'!$F$70=\"nominal\",LOOKUP($F12,Nominal_to_Real,'Input|Rate of change'!R$25:R$30),INDEX('Input|Rate of change'!$C$14:$O$21,MATCH('Calc|Opex forecast'!$F$70,'Input|Rate of change'!$C$14:$C$21,0),MATCH('Output|Models'!$F12,'Input|Rate of change'!$C$14:$O$14,0)))*IF('Calc|Opex forecast'!$E$70=\"$millions\",1000000,IF('Output|Models'!D49=\"$000\",1000,1))/IF($E12=\"$millions\",1000000,IF($E12=\"$000\",1000,1)))","v":0},{"$f":"IF(M11=\"\",0,'Calc|Opex forecast'!M70*IF('Calc|Opex forecast'!$F$70=\"nominal\",LOOKUP($F12,Nominal_to_Real,'Input|Rate of change'!S$25:S$30),INDEX('Input|Rate of change'!$C$14:$O$21,MATCH('Calc|Opex forecast'!$F$70,'Input|Rate of change'!$C$14:$C$21,0),MATCH('Output|Models'!$F12,'Input|Rate of change'!$C$14:$O$14,0)))*IF('Calc|Opex forecast'!$E$70=\"$millions\",1000000,IF('Output|Models'!E49=\"$000\",1000,1))/IF($E12=\"$millions\",1000000,IF($E12=\"$000\",1000,1)))","v":0},{"$f":"IF(N11=\"\",0,'Calc|Opex forecast'!N70*IF('Calc|Opex forecast'!$F$70=\"nominal\",LOOKUP($F12,Nominal_to_Real,'Input|Rate of change'!T$25:T$30),INDEX('Input|Rate of change'!$C$14:$O$21,MATCH('Calc|Opex forecast'!$F$70,'Input|Rate of change'!$C$14:$C$21,0),MATCH('Output|Models'!$F12,'Input|Rate of change'!$C$14:$O$14,0)))*IF('Calc|Opex forecast'!$E$70=\"$millions\",1000000,IF('Output|Models'!F49=\"$000\",1000,1))/IF($E12=\"$millions\",1000000,IF($E12=\"$000\",1000,1)))","v":0},{"$f":"IF(O11=\"\",0,'Calc|Opex forecast'!O70*IF('Calc|Opex forecast'!$F$70=\"nominal\",LOOKUP($F12,Nominal_to_Real,'Input|Rate of change'!U$25:U$30),INDEX('Input|Rate of change'!$C$14:$O$21,MATCH('Calc|Opex forecast'!$F$70,'Input|Rate of change'!$C$14:$C$21,0),MATCH('Output|Models'!$F12,'Input|Rate of change'!$C$14:$O$14,0)))*IF('Calc|Opex forecast'!$E$70=\"$millions\",1000000,IF('Output|Models'!G49=\"$000\",1000,1))/IF($E12=\"$millions\",1000000,IF($E12=\"$000\",1000,1)))","v":24.250915844580426},{"$f":"IF(P11=\"\",0,'Calc|Opex forecast'!P70*IF('Calc|Opex forecast'!$F$70=\"nominal\",LOOKUP($F12,Nominal_to_Real,'Input|Rate of change'!V$25:V$30),INDEX('Input|Rate of change'!$C$14:$O$21,MATCH('Calc|Opex forecast'!$F$70,'Input|Rate of change'!$C$14:$C$21,0),MATCH('Output|Models'!$F12,'Input|Rate of change'!$C$14:$O$14,0)))*IF('Calc|Opex forecast'!$E$70=\"$millions\",1000000,IF('Output|Models'!H49=\"$000\",1000,1))/IF($E12=\"$millions\",1000000,IF($E12=\"$000\",1000,1)))","v":24.631259468476067},{"$f":"IF(Q11=\"\",0,'Calc|Opex forecast'!Q70*IF('Calc|Opex forecast'!$F$70=\"nominal\",LOOKUP($F12,Nominal_to_Real,'Input|Rate of change'!W$25:W$30),INDEX('Input|Rate of change'!$C$14:$O$21,MATCH('Calc|Opex forecast'!$F$70,'Input|Rate of change'!$C$14:$C$21,0),MATCH('Output|Models'!$F12,'Input|Rate of change'!$C$14:$O$14,0)))*IF('Calc|Opex forecast'!$E$70=\"$millions\",1000000,IF('Output|Models'!I49=\"$000\",1000,1))/IF($E12=\"$millions\",1000000,IF($E12=\"$000\",1000,1)))","v":25.296021898080543},{"$f":"IF(R11=\"\",0,'Calc|Opex forecast'!R70*IF('Calc|Opex forecast'!$F$70=\"nominal\",LOOKUP($F12,Nominal_to_Real,'Input|Rate of change'!X$25:X$30),INDEX('Input|Rate of change'!$C$14:$O$21,MATCH('Calc|Opex forecast'!$F$70,'Input|Rate of change'!$C$14:$C$21,0),MATCH('Output|Models'!$F12,'Input|Rate of change'!$C$14:$O$14,0)))*IF('Calc|Opex forecast'!$E$70=\"$millions\",1000000,IF('Output|Models'!J49=\"$000\",1000,1))/IF($E12=\"$millions\",1000000,IF($E12=\"$000\",1000,1)))","v":24.249316956539932},{"$f":"IF(S11=\"\",0,'Calc|Opex forecast'!S70*IF('Calc|Opex forecast'!$F$70=\"nominal\",LOOKUP($F12,Nominal_to_Real,'Input|Rate of change'!Y$25:Y$30),INDEX('Input|Rate of change'!$C$14:$O$21,MATCH('Calc|Opex forecast'!$F$70,'Input|Rate of change'!$C$14:$C$21,0),MATCH('Output|Models'!$F12,'Input|Rate of change'!$C$14:$O$14,0)))*IF('Calc|Opex forecast'!$E$70=\"$millions\",1000000,IF('Output|Models'!K49=\"$000\",1000,1))/IF($E12=\"$millions\",1000000,IF($E12=\"$000\",1000,1)))","v":24.643313061965433}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(O14:S14)","v":123.07082722964239}]
[]
[null,"End"]

{"sheet":"Output|Decision tables","index":9,"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:",{"$f":"IF(COUNTA($W$16:$W$328)=COUNTIF($W$16:$W$328,\"OK\"),\"OK\",\"Check\")","v":"OK"},null,"Overall Check:",{"$f":"'Check|List'!$S$1","v":"Ok"}]
[null,{"$f":"Index!$C$14","v":"Output | Models"}]
[]
[]
[]
[]
[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,"excludes debt raising costs"]
[null,"Ausgrid's proposal",565.058962688159,566.23214528142353,574.24202311823865,568.91940992728473,568.42780917161645,{"$f":"SUM(C10:G10)","v":2842.8803501867224}]
[null,"AER draft decision",{"$f":"'Calc|Opex forecast'!O67","v":337.48415909664061},{"$f":"'Calc|Opex forecast'!P67","v":342.2227979875932},{"$f":"'Calc|Opex forecast'!Q67","v":349.78961922845781},{"$f":"'Calc|Opex forecast'!R67","v":343.21825940844803},{"$f":"'Calc|Opex forecast'!S67","v":349.23337287596928},{"$f":"SUM(C11:G11)","v":1721.9482085971088}]
[null,"Difference",{"$f":"C11-C10","v":-227.57480359151839},{"$f":"D11-D10","v":-224.00934729383033},-224.45240388978084,-225.7011505188367,{"$f":"G11-G10","v":-219.19443629564717},-1120.9321415896134]
[]
[null,null,"2014–15","2015–16","2016–17","2017–18","2018–19","Total",null,"includes debt raising costs"]
[null,"Ausgrid's proposal",573.5951727834921,575.05265475483122,583.38744279305035,578.25427939415829,577.95141271349496,{"$f":"SUM(C15:G15)","v":2888.240962439027}]
[null,"AER draft decision",{"$f":"'Calc|Opex forecast'!O72","v":344.75275457990921},{"$f":"'Calc|Opex forecast'!P72","v":349.5344279626292},{"$f":"'Calc|Opex forecast'!Q72","v":357.1229855016378},{"$f":"'Calc|Opex forecast'!R72","v":350.52351107990091},{"$f":"'Calc|Opex forecast'!S72","v":356.53387364026941},{"$f":"SUM(C16:G16)","v":1758.4675527643465}]
[null,"Difference",{"$f":"C16-C15","v":-228.84241820358289},{"$f":"D16-D15","v":-225.51822679220203},-226.26445729141255,-227.73076831425738,{"$f":"G16-G15","v":-221.41753907322556},-1129.7734096746804]
[]
[null,"End"]

{"sheet":"Lookup|Tables","index":10,"n_rows":44,"n_cols":22,"rows_kept":44,"cut":false,"hidden":false,"merged":[]}
[null,{"$f":"Index!$B$1","v":"AER opex model"},null,null,null,null,null,null,null,"Back to Index",null,"Key:","Input","External Link","Internal Link",null,null,null,null,null,"Overall Check:",{"$f":"'Check|List'!$S$1","v":"Ok"}]
[null,{"$f":"Index!$C$16","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":11,"n_rows":18,"n_cols":19,"rows_kept":18,"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:G16,\"Check\")=0,\"Ok\",\"Check\")","v":"Ok"}]
[null,{"$f":"Index!$C$17","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!C13","v":"Calc | Opex Forecast"},"Calc | Opex Forecast","Ok/Check",null,{"$f":"'Calc|Opex forecast'!S1","v":"n/a"}]
[null,null,{"$f":"Index!C14","v":"Output | Models"},"Output | Models","Ok/Check",null,{"$f":"'Output|Models'!S1","v":"OK"}]
[null,null,{"$f":"Index!C15","v":"Output | Decision tables"},"Output | Decision tables","Ok/Check",null,{"$f":"'Output|Decision tables'!S1","v":"OK"}]
[]
[null,"End"]