{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["AER only","EBSS ","7.5 EBSS AER","7.5 EBSS PQ","7.5 EBSS PQ Version 2"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":4,"defined_names":572,"comments":3,"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":"AER only","index":0,"n_rows":74,"n_cols":13,"rows_kept":74,"cut":false,"hidden":true,"merged":[[0,1,0,9]]}
[null,"Data in these columns used for data validation and database purposes."]
[null,"Date last modified:"]
[null,"14 April 2015","merged cell C46/47"]
[null,"17 April 2015","adjusted dms_RYE to automate based on dms_Model (NB: EB & CA refer to CRCP_y5)"]
[null,"14 May 2015","adapted this cover for use in CA & EB RINs"]
[]
[]
[]
[null,"dms_Model_List ","dms_Worksheet_List ",null,"dms_RYE_List1","dms_RYE_List2"]
[null,"CA","CATEGORY ANALYSIS",null,"dms_RYE",{"$f":"CONCATENATE(LEFT(CRY, 2) &IF(CRY>\"2009-10\",,\"\") &RIGHT(CRY,2))","v":{"$error":"#REF!"}}]
[null,"CAM/Service change Backcast","REGULATORY REPORTING STATEMENT",null,"dms_RYE",{"$f":"CONCATENATE(LEFT(CRCP_y5, 2) &IF(CRCP_y5>\"2009-10\",,\"\") &RIGHT(CRCP_y5,2))","v":{"$error":"#REF!"}}]
[null,"CPI","CPI",null,"dms_RYE",{"$f":"CONCATENATE(LEFT(CRCP_y5, 2) &IF(CRCP_y5>\"2009-10\",,\"\") &RIGHT(CRCP_y5,2))","v":{"$error":"#REF!"}}]
[null,"EB","ECONOMIC BENCHMARKING",null,"dms_RYE",{"$f":"CONCATENATE(LEFT(CRY, 2) &IF(CRY>\"2009-10\",,\"\") &RIGHT(CRY,2))","v":{"$error":"#REF!"}}]
[null,"PTRM","POST TAX REVENUE MODEL",null,"FRCP",{"$f":"CONCATENATE(LEFT(FRCP_y5, 2) &IF(FRCP_y1>\"2009-10\",,\"\") &RIGHT(FRCP_y5,2))","v":{"$error":"#REF!"}}]
[null,"Reset","REGULATORY REPORTING STATEMENT",null,"FRCP",{"$f":"CONCATENATE(LEFT(FRCP_y5, 2) &IF(FRCP_y1>\"2009-10\",,\"\") &RIGHT(FRCP_y5,2))","v":{"$error":"#REF!"}}]
[null,"RFM","ROLL FORWARD MODEL",null,"CRCP",{"$f":"CONCATENATE(LEFT(CRCP_y5, 2) &IF(CRCP_y1>\"2009-10\",,\"\") &RIGHT(CRCP_y5,2))","v":{"$error":"#REF!"}}]
[null,"WACC","WEIGHTED AVERAGE COST OF CAPITAL",null,"dms_RYE",{"$f":"CONCATENATE(LEFT(CRCP_y5, 2) &IF(CRCP_y5>\"2009-10\",,\"\") &RIGHT(CRCP_y5,2))","v":{"$error":"#REF!"}}]
[]
[]
[null,"dms_TradingName_List","dms_TradingNameFull_List","dms_ABN_List","dms_State_List","dms_Sector_List","dms_Segment_List","dms_FormControl","dms_CRCPlength_List","dms_FRCPlength_List","dms_JurisdictionList","dms_663_List","dms_DeterminationRef_List"]
[null,"ActewAGL Distribution","ActewAGL Distribution",76670568688,"ACT","Electricity","Distribution","Revenue cap",5,6,"ACT",5,"2014-19 Distribution Determination"]
[null,"ActewAGL Distribution (Tx Assets)","ActewAGL Distribution (Tx Assets)",76670568688,"ACT","Electricity","Distribution","Revenue cap",5,5,"ACT",5,"distribution determination"]
[null,"AGN","AGN",78551685,"SA","Gas","Distribution","Revenue cap",5,5,"SA",5,"distribution determination"]
[null,"Ausgrid","Ausgrid",67505337385,"NSW","Electricity","Distribution","Revenue cap",5,5,"NSW",5,"2014-19 Distribution Determination"]
[null,"Ausgrid (Tx Assets)","Ausgrid (Tx Assets)",67505337385,"NSW","Electricity","Distribution","Revenue cap",5,5,"NSW",5,"distribution determination"]
[null,"AusNet (D)","AusNet Services (D)",91064651118,"Vic","Electricity","Distribution","Revenue cap",5,5,"Vic",2,"2016-20 Distribution Determination"]
[null,"AusNet (T)","AusNet (T)",78079798173,"Vic","Electricity","Transmission","Revenue cap",5,5,"Vic",2,"distribution determination"]
[null,"Australian Distribution Co.","Australian Distribution Co.",11222333444,"-","Electricity","Distribution","Revenue cap",5,5,"-",2,"distribution determination"]
[null,"Australian Transmission Co.","Australian Transmission Co.",11222333444,"-","Electricity","Transmission","Revenue cap",5,5,"-",5,"distribution determination"]
[null,"CitiPower","CitiPower",76064651056,"Vic","Electricity","Distribution","Revenue cap",5,5,"Vic",2,"2016-20 Distribution Determination"]
[null,"Directlink","Directlink",16779340889,"NSW","Electricity","Transmission","Revenue cap",10,5,"Qld",5,"distribution determination"]
[null,"ElectraNet","ElectraNet",41094482416,"SA","Electricity","Transmission","Revenue cap",5,5,"SA",5,"distribution determination"]
[null,"Endeavour Energy","Endeavour Energy",59253130878,"NSW","Electricity","Distribution","Revenue cap",5,5,"NSW",5,"2014-19 Distribution Determination"]
[null,"Energex","Energex",40078849055,"Qld","Electricity","Distribution","Revenue cap",5,5,"Qld",5,"2015-20 Distribution Determination"]
[null,"Ergon Energy","Ergon Energy",50087646062,"Qld","Electricity","Distribution","Revenue cap",5,5,"Qld",5,"2015-20 Distribution Determination"]
[null,"Essential Energy","Essential Energy",37428185226,"NSW","Electricity","Distribution","Revenue cap",5,5,"NSW",5,"2014-19 Distribution Determination"]
[null,"Jemena Electricity","Jemena Electricity",82064651083,"Vic","Electricity","Distribution","Revenue cap",5,5,"Vic",2,"2016-20 Distribution Determination"]
[null,"Murraylink","Murraylink",79181207909,"NSW","Electricity","Transmission","Revenue cap",5,5,"SA",5,"distribution determination"]
[null,"Powercor Australia","Powercor Australia",89064651109,"Vic","Electricity","Distribution","Revenue cap",5,5,"Vic",2,"2016-20 Distribution Determination"]
[null,"Powerlink","Queensland Electricity Transmission Corporation Limited trading as Powerlink Queensland",82078849233,"Qld","Electricity","Transmission","Revenue cap",5,5,"Qld",5,"distribution determination"]
[null,"Qld,SA &ACT Gas Reset","Qld,SA &ACT Gas Reset",22222222222,"-","Gas","Distribution","?",5,5,"-","x","distribution determination"]
[null,"SA Power Networks","SA Power Networks",13332330749,"SA","Electricity","Distribution","Revenue cap",5,5,"SA",5,"2015-20 Distribution Determination"]
[null,"TasNetworks (D)","TasNetworks (D)",24167357299,"Tas","Electricity","Distribution","Revenue cap",5,5,"Tas",5,"distribution determination"]
[null,"TasNetworks (T)","TasNetworks (T)",24167357299,"Tas","Electricity","Transmission","Revenue cap",5,5,"Tas",5,"distribution determination"]
[null,"TransGrid","TransGrid",19622755774,"NSW","Electricity","Transmission","Revenue cap",5,5,"NSW",5,"distribution determination"]
[null,"United Energy","United Energy",70064651029,"Vic","Electricity","Distribution","Revenue cap",5,5,"Vic",2,"2016-20 Distribution Determination"]
[null,"Victorian DNSP Backcasting","Victorian DNSP Backcasting",33333333666,"Vic","Electricity","Distribution","?",5,5,"Vic","x","distribution determination"]
[null,"Victorian DNSP Reset ","Victorian DNSP Reset ",33333333333,"Vic","Electricity","Distribution","?",5,5,"Vic","x","distribution determination"]
[]
[]
[]
[]
[null,"dms_SourceList","dms_FormControl_Choices",null,"dms_FRCPlength_Num_List","dms_FinalYear_List"]
[null,"After appeal","Revenue cap",null,1,"FRCP_y1"]
[null,"Draft decision","Revenue yield",null,2,"FRCP_y2"]
[null,"Final decision","Weighted average price cap",null,3,"FRCP_y3"]
[null,"Pass through decision",null,null,4,"FRCP_y4"]
[null,"PTRM annual update",null,null,5,"FRCP_y5"]
[null,"PTRM interim update 1",null,null,6,"FRCP_y6"]
[null,"PTRM interim update 2",null,null,7,"FRCP_y7"]
[null,"PTRM interim update 3",null,null,8,"FRCP_y8"]
[null,"PTRM interim update 4",null,null,9,"FRCP_y9"]
[null,"Regulatory proposal",null,null,10,"FRCP_y10"]
[null,"Reporting"]
[null,"Revised regulatory proposal"]
[null,"RFM annual update"]
[null,"WACC annual update"]
[]
[]
[]
[null,"Notes"]
[null,"RFM - Base year is usually CRCP_y1","EG. Victorian 2016-20 - base year = 2011"]
[null,"RFM - Form of Control Field is not relevant"]
[null,"PTRM - capture base year input by NSP","='[Published version - PTRM - TNSP - version 3 - January 2015 - Appendix A.xlsm]PTRM input'!Q7"]

{"sheet":"EBSS ","index":1,"n_rows":84,"n_cols":27,"rows_kept":84,"cut":false,"hidden":false,"merged":[[15,2,15,5],[15,6,15,10],[15,12,15,20],[51,12,51,20],[55,16,55,20],[16,2,16,5],[16,6,16,10],[16,12,16,15],[16,16,16,20],[33,2,33,10],[33,12,33,20],[34,2,34,5],[34,6,34,10],[34,12,34,15],[34,16,34,20],[62,12,62,15],[68,2,68,6],[69,2,69,6],[55,21,55,25],[56,16,56,26],[58,12,58,15],[60,12,60,15],[61,12,61,15],[59,12,59,15]]}
[]
[]
[]
[null,"CPI "]
[null,null,"2006-07","2007-08","2008-09","2009-10","2010-11","2011-12","2012-13","2013-14","2014-15","2015-16","2016-17"]
[null,"ABS CPI index Jun qtr (old base)",157.5,164.6,167,172.1,178.3]
[null,"ABS CPI index Jun qtr (rebased index)",null,null,null,95.8,99.2,100.4,102.8,105.9,107.5,110,112.7]
[null,"Inflation rate (per cent) ",null,4.5079365079365052E-2,1.4580801944106936E-2,3.0538922155688653E-2,3.6025566531086683E-2,1.2096774193548487E-2,2.3904382470119501E-2,3.0155642023346418E-2,1.5108593012275628E-2,2.3255813953488413E-2,2.4545454545454648E-2]
[null,"Reconstructed cumulative index (2016-17=1)",0.77752967118716076,0.8125802150946454,0.82442828627464027,0.84960543753212936,0.88021295474711614,0.89086069210292806,0.91215616681455181,0.93966282165039927,0.95385980479148169,0.97604259094942314,1]
[]
[]
[]
[null,"The carryover amounts that arise from applying the EBSS during the current regulatory control period"]
[]
[null,"Opex allowance applicable to EBSS (EBSS target)"]
[null,null,"$m, Jun 2007",null,null,null,"$m,  Jun 2012",null,null,null,null,null,"$m, Jun 2017"]
[null,null,"Previous period",null,null,null,"Current regulatory control period",null,null,null,null,null,"Previous period",null,null,null,"Current regulatory control period"]
[null,null,"2008-09","2009-10","2010-11","2011-12","2012-13","2013-14","2014-15","2015-16","2016-17",null,"2008-09","2009-10","2010-11","2011-12","2012-13","2013-14","2014-15","2015-16","2016-17"]
[null,"Total opex allowance",null,154.227,147.589,151.91399999999999,177.93600000000001,184.71199999999999,189.464,196.54900000000001,202.292,null,null,198.35513127688179,189.81783650089611,195.38032518817209,199.73493227091635,207.34105976095617,212.67522709163347,220.62821015936257,227.0747848605578]
[null,"Approved excludable costs - allowance ",null,0,0,0,0,0,0,0,0]
[null,"Equity raising costs",null,0,0,0,0,0,0,0,0,null,null,0,0,0]
[null,"Debt raising costs",null,-2.26823,-2.3885000000000001,-2.5251999999999999,-3.4963563727433424,-3.7608800458814287,-3.9487082582602127,-4.0483570933985531,-4.1832705947625319,null,null,-2.9172262925179222,-3.0719084923835136,-3.2477217186379939,-3.9246948526710628,-4.2216253104665045,-4.4324643496606173,-4.544321159621683,-4.6957629086627231]
[null,"Network support costs",null,-22.15,-8.2200000000000006,-8.3000000000000007,0,0,0,0,0,null,null,-28.487658826164882,-10.571943817204305,-10.674833781362011,0,0,0,0,0]
[null,"Insurance & Self Insurance",null,-5.9503000000000004,-6.1618199999999996,-6.3483499999999999,-8.6550563450977105,-9.1838293614270032,-9.9164781194194322,-10.446406428629475,-11.180242574694173,null,null,-7.6528269215949853,-7.9248679868279588,-8.1647687995071703,-9.7153869531126702,-10.30893993060581,-11.131345458750697,-11.726195264009382,-12.549933647091965]
[null,"Capex Efficiencies",null,-3.1947800000000002,-3.1947800000000002,-3.1947800000000002,0,0,0,0,0]
[null,"Network growth adjustment",null,0,0,0,-0.69511177643113342,-1.7388043988991058,-2.7482088891924832,-3.6453323742874493,-4.4394407513314036,null,null,0,0,0,-0.78026989246801537,-1.9518252565331597,-3.0848918507170606,-4.0919218982290397,-4.983316460906865]
[null,"Capitalisation policy changes",null,0,0,0,0,0,0,0,0,null,null,0,0,0,0,0,0,0,0]
[null,"Movements in provisions related to opex",null,-2.2746206128133704,-2.3396345403899721,-2.4497247910863513,-0.71449944004141452,-0.75129960995155431,-0.81990940853815475,-0.82279012746166069,-0.8542102504808583,null,null,-2.9254454165593402,-3.0090614250356933,-3.1506511993889852,-0.80203273797477515,-0.84334129523446388,-0.92035647751245064,-0.92359011319650564,-0.95885951423498739]
[null,"Opex associated with pass throughs",null,0,0,0,0,0,0,0,0,null,null,0,0,0,0,0,0,0,0]
[null,"Other adjustments or exclusions required by the EBSS ",null,0,0,0,0,0,0,0,0,null,null,0,0,0,0,0,0,0,0]
[null,"Forecast opex for EBSS purposes",null,118.38906938718664,125.28426545961003,129.09594520891363,164.37497606568641,169.27718658384089,172.03069532458974,177.58611397622286,181.63483582873104,null,null,156.37197382004467,165.24005477944465,170.14234968927596,184.51254783468983,190.01532796811622,193.10616895499263,199.34218172430596,203.88691232966124]
[]
[null,"Actual and estimated opex applicable to EBSS"]
[null,null,"$m, Actual",null,null,null,null,null,null,null,null,null,"$m, Jun 2017"]
[null,null,"Previous period",null,null,null,"Current regulatory control period",null,null,null,null,null,"Previous period",null,null,null,"Current regulatory control period"]
[null,null,"2008-09","2009-10","2010-11","2011-12","2012-13","2013-14","2014-15","2015-16","2016-17",null,"2008-09","2009-10","2010-11","2011-12","2012-13","2013-14","2014-15","2015-16","2016-17"]
[null,"Total opex ",null,151.88399999999999,150.88,160.38399999999999,167.37759669000005,181.01599999999999,211.26,216.54054402600002,null,null,null,181.47923608140582,174.47337242848232,181.11827123419346,185.67688005182436,195.52232032729091,223.14593475234969,224.42052028842065]
[null,"Approved excludable costs",null,0,0,0,0,0,0,0]
[null,"Equity raising costs",null,0,0,0,0,0,0,0,null,null,null,0,0,0]
[null,"Debt raising costs",null,-0.32,-0.249,-0.26500000000000001,-0.501,-0.5,-0.5,-1,null,null,null,-0.38235334561935341,-0.28793657035188297,-0.2992589153348294,-0.55577400288674195,-0.54006916606070987,-0.52813105829865969,-1.0363903041708185]
[null,"Network support costs",null,-12.718,0,0,0,0,-2.6440000000000001,-3.54,null,null,null,-15.196155779959176,0,0,0,0,-2.7927570362833127,-3.6688216767646975]
[null,"Insurance & Self Insurance",null,-6.7130000000000001,-7.3440000000000003,-7.5960000000000001,-7.8440000000000003,-8.1530000000000005,-8.3729999999999993,-8.5978370000000002,null,null,null,-8.0210562785709989,-8.4923942677278248,-8.5780027203145792,-8.7015793984902263,-8.8063678217859369,-8.8440827022693558,-8.910714903641118]
[null,"AEMC Levy",null,0,0,0,0,0,-3.79,-4.0999999999999996,null,null,null,0,0,0,0,0,-4.0032334219038406,-4.2492002471003554]
[null,"500Kv Write Off",null,0,0,0,0,0,-12.054,0,null,null,null,0,0,0,0,0,-12.73218355346409,0]
[null,"Redundancy related costs",null,0,0,0,0,0,0,-9.7564556160000002,null,null,null,0,0,0,0,0,0,-10.111496003495329]
[null,"Network growth adjustment",null,0,0,0,0,0,0,0,null,null,null,0,0,0,0,0,0,0]
[null,"Capitalisation policy changes",null,0,0,0,0,0,0,0,null,null,null,0,0,0,0,0,0,0]
[null,"Movements in provisions related to opex",null,0.46679354620000085,-1.0548444295000001,-1.9412489616000008,-1.3588734600000265E-2,-0.45092892627999914,0.25983895485586767,1.490399254799998,null,null,null,0.55775023157216419,-1.2197923184137294,-2.1922115420501131,-1.5074382081452528E-2,-0.48706561833738099,0.2744580444304941,1.5446353370181312]
[null,"Other adjustments or exclusions required by the EBSS ",null,0,0,0,0,0,0,0,null,null,null,0,0,0,0,0,0,0]
[null,"Actual opex for EBSS purposes",null,132.59979354619998,142.2321555705,150.5817510384,159.01900795540004,171.91207107372,184.15883895485587,191.03665066480002,null,null,null,158.43742090882844,164.47324927198889,170.04879805649392,176.40445226836593,185.68881772110689,194.52000502456093,197.98853249026646]
[null,null,null,null,null,null,null,null,null,"estimates",null,null,null,"base year"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Incremental gain ($m, 2021-22)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5.9490968447580883,-3.7815853193145585,-5.7403463165776429,2.7674853036077991]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Carryover"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Current regulatory control period",null,null,null,null,"Forthcoming regulatory control period"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"$m, real June 2017"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2012-13","2013-14","2014-15","2015-16","2016-17","2017-18","2018-19","2019-20","2020-21","2021-22","Total "]
[null,null,null,null,null,null,null,null,null,null,null,null,"2012-13",null,null,null,null,5.9490968447580883,5.9490968447580883,5.9490968447580883,5.9490968447580883,5.9490968447580883]
[null,null,null,null,null,null,null,null,null,null,null,null,"2013-14",null,null,null,null,null,-3.7815853193145585,-3.7815853193145585,-3.7815853193145585,-3.7815853193145585,-3.7815853193145585]
[null,null,null,null,null,null,null,null,null,null,null,null,"2014-15",null,null,null,null,null,null,-5.7403463165776429,-5.7403463165776429,-5.7403463165776429,-5.7403463165776429,-5.7403463165776429]
[null,null,null,null,null,null,null,null,null,null,null,null,"2015-16",null,null,null,null,null,null,null,2.7674853036077991,2.7674853036077991,2.7674853036077991,2.7674853036077991,2.7674853036077991]
[null,null,null,null,null,null,null,null,null,null,null,null,"2016-17",null,null,null,null,null,null,null,null,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"Total Carryover Amount",null,null,null,null,null,null,null,null,-0.80534948752631408,-6.7544463322844024,-2.9728610129698438,2.7674853036077991,0,-7.7651715291727612]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"PTRM inputs",null,null,null,null,null,null,null,null,-0.80534948752631408,-6.7544463322844024,-2.9728610129698438,2.7674853036077991,0,-7.7651715291727612]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+Z66*1000000","v":0}]
[null,"Proposed forecast opex for the EBSS for the forthcoming regulatory control period"]
[null,null,"Forthcoming regulatory control period"]
[null,null,"$m, real June 2017"]
[null,null,"2017-18","2018-19","2019-20","2020-21","2021-22"]
[null,"Forecast opex",196.89449932492701,196.03672139940113,195.11353824357761,194.39700578522832,194.27251432500898]
[null,"Less excluded costs"]
[null,"Insurance Premiums",7.6069970628740577,7.786258477911697,7.9426167637325236,8.0947811329273449,8.2864556435248531]
[null,"Self-Insurance",1.4856849163200536,1.4847439125145832,1.4778701104236474,1.4704054143914982,1.4689486613565468]
[null,"AEMC Levy",4.2,4.2,4.2,4.2,4.2]
[null,"Debt Raising ",3.6001069590761241,3.5685976033943958,3.5292962065765954,3.4822005545318926,3.4324239586567611]
[null,"Redundancy related costs"]
[]
[]
[]
[]
[]
[null,"Adjusted forecast opex",180.00171038665678,178.99712140558046,177.96375516284485,177.14961868337758,176.88468606147086]

{"sheet":"7.5 EBSS AER","index":2,"n_rows":94,"n_cols":27,"rows_kept":94,"cut":false,"hidden":true,"merged":[[65,21,65,25],[66,16,66,26],[8,1,8,12],[45,2,45,10],[45,12,45,20],[65,16,65,20],[46,2,46,5],[46,6,46,10],[46,12,46,15],[46,16,46,20],[11,1,11,2],[28,16,28,20],[27,2,27,5],[27,6,27,10],[27,12,27,20],[28,2,28,5],[28,6,28,10],[28,12,28,15],[79,2,79,6],[61,12,61,20],[78,2,78,6],[68,12,68,15],[69,12,69,15],[70,12,70,15],[71,12,71,15],[72,12,72,15]]}
[null,"REGULATORY REPORTING STATEMENT"]
[null,{"$f":"INDEX(dms_TradingNameFull_List,MATCH(dms_TradingName,dms_TradingName_List))","v":{"$error":"#REF!"}}]
[null,{"$f":"CONCATENATE(FRCP_y1,\" to \",dms_FRCP_FinalYear_Num)","v":{"$error":"#REF!"}}]
[null,"7.5 EBSS"]
[]
[]
[null,"Instructions "]
[null,"Powerlink is required to populate all input cells (yellow) in tableS 7.5.1 and 7.5.2 presented below."]
[null,"\nEfficiency gains are calculated using the formulae below.  Adjusted target and actual amounts are used to calculate the carry-over amounts.\n\nWe will calculate the efficiency gain in 2012–13 (year 6) as follows:\nE6 = (F6 – A6) – (F5 – A5) + (F3 – A3)\nwhere F6 is the forecast opex we approved for year 6 (2012-13), and A6 is the actual opex incurred for year 6, and so on. The formula references year 3 (2009-10) because it is the base year used to forecast opex."]
[]
[]
[null,"SELECT BASE YEAR USED TO FORECAST OPEX FOR 2017-22",null,"2014-15"]
[]
[]
[]
[null,"CPI "]
[null,null,"2006-07","2007-08","2008-09","2009-10","2010-11","2011-12","2012-13","2013-14","2014-15","2015-16","2016-17"]
[null,"ABS CPI index Jun qtr (old base)",157.5,164.6,167,172.1,178.3]
[null,"ABS CPI index Jun qtr (rebased index)",null,null,null,95.8,99.2,100.4,102.8,105.9,107.5,109.65,112.39125]
[null,"Inflation rate (per cent) ",null,{"$f":"D18/C18-1","v":4.5079365079365052E-2},1.4580801944106936E-2,3.0538922155688653E-2,{"$f":"G18/F18-1","v":3.6025566531086683E-2},{"$f":"H19/G19-1","v":1.2096774193548487E-2},2.3904382470119501E-2,{"$f":"J19/I19-1","v":3.0155642023346418E-2},{"$f":"K19/J19-1","v":1.5108593012275628E-2},2.35E-2,2.4500000000000001E-2]
[null,"Reconstructed cumulative index (2016-17=1)",{"$f":"D21/(1+D20)","v":0.77737865745051582},0.81242239375463432,0.82426816377292789,0.84944042506180173,0.88004199760906021,0.89068766693497636,0.91197900558680844,0.93948031801209164,0.95367454377997962,0.9760858955588092,1]
[]
[]
[]
[null,"7.5.1 - The carryover amounts that arise from applying the EBSS during the current regulatory control period"]
[]
[null,"7.5.1.1 - Opex allowance applicable to EBSS (EBSS target)"]
[null,null,"$m, Jun 2007",null,null,null,"$m,  Jun 2012",null,null,null,null,null,"$m, Jun 2017"]
[null,null,"Previous period",null,null,null,"Current regulatory control period",null,null,null,null,null,"Previous period",null,null,null,"Current regulatory control period"]
[null,null,{"$f":"PRCP_y2","v":{"$error":"#REF!"}},{"$f":"PRCP_y3","v":{"$error":"#REF!"}},{"$f":"PRCP_y4","v":{"$error":"#REF!"}},{"$f":"PRCP_y5","v":{"$error":"#REF!"}},{"$f":"CRCP_y1","v":{"$error":"#REF!"}},{"$f":"CRCP_y2","v":{"$error":"#REF!"}},{"$f":"CRCP_y3","v":{"$error":"#REF!"}},{"$f":"CRCP_y4","v":{"$error":"#REF!"}},{"$f":"CRCP_y5","v":{"$error":"#REF!"}},null,{"$f":"PRCP_y2","v":{"$error":"#REF!"}},{"$f":"PRCP_y3","v":{"$error":"#REF!"}},{"$f":"PRCP_y4","v":{"$error":"#REF!"}},{"$f":"PRCP_y5","v":{"$error":"#REF!"}},{"$f":"CRCP_y1","v":{"$error":"#REF!"}},{"$f":"CRCP_y2","v":{"$error":"#REF!"}},{"$f":"CRCP_y3","v":{"$error":"#REF!"}},{"$f":"CRCP_y4","v":{"$error":"#REF!"}},{"$f":"CRCP_y5","v":{"$error":"#REF!"}}]
[null,"Total opex allowance",null,154227,147589,151914,177936,184712,189464,196549,202292,null,null,{"$f":"+D31/$C$21","v":198393.66378516424},189854.71055255309,195418.27981001668,{"$f":"+G31/$H$21","v":199773.73281962151},{"$f":"+H31/$H$21","v":207381.33787753983},212716.5414246514,220671.06944049426,227118.89645460658]
[null,"Approved excludable costs - allowance "]
[null,"Equity raising costs",null,null,null,null,null,null,null,null,null,null,null,{"$f":"+D33/$C$21","v":0},{"$f":"+E33/$C$21","v":0},{"$f":"+F33/$C$21","v":0}]
[null,"Debt raising costs",null,-2268.23,-2388.5,-2525.1999999999998,-3496.3563727433425,-3760.8800458814285,-3948.7082582602125,-4048.3570933985529,-4183.2705947625318,null,null,{"$f":"+D34/$C$21","v":-2917.7929934928584},{"$f":"+E34/$C$21","v":-3072.5052419541635},{"$f":"+F34/$C$21","v":-3248.3526217218559},{"$f":"+G34/$H$21","v":-3925.4572646941006},{"$f":"+H34/$H$21","v":-4222.4454042608713},{"$f":"+I34/$H$21","v":-4433.3254010897663},{"$f":"+J34/$H$21","v":-4545.2039403775625},{"$f":"+K34/$H$21","v":-4696.6751085236783}]
[null,"Network support costs",null,-22150,-8220,-8300,null,null,null,null,null,null,null,-28493.19284458226,-10573.997525167773,-10676.907476750914,0,0,0,0,0]
[null,"Insurance & Self Insurance",null,-5950.3,-6161.82,-6348.35,-8655.0563450977097,-9183.8293614270024,-9916.4781194194329,-10446.406428629474,-11180.242574694174,null,null,-7654.3135613145741,-7926.407473300399,-8166.3548891604423,-9717.2742661649118,-10310.942547380593,-11133.507836191218,-11728.473197094467,-12552.371599763461]
[null,"Capex Efficiencies",null,-3194.78,-3194.78,-3194.78]
[null,"Network growth adjustment",null,null,null,null,-695.11177643113342,-1738.8043988991058,-2748.2088891924832,-3674.2468935935622,-4352.8297852762134,null,null,0,0,0,-780.42146785656485,-1952.2044185058253,-3085.4911224375505,-4125.1799367979756,-4887.043962621733]
[null,"Capitalisation policy changes",null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0]
[null,"Movements in provisions related to opex",null,-2274.6206128133704,-2339.6345403899722,-2449.7247910863512,-714.49944004141457,-751.29960995155432,-819.90940853815471,-822.79012746166075,-854.21025048085835,null,null,-2926.0137141829905,-3009.6459659222146,-3151.2632455339681,-802.18854101813429,-843.50512288658661,-920.53526614959992,-923.76953000038293,-959.04578247990833]
[null,"Opex associated with pass throughs",null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0]
[null,"Other adjustments or exclusions required by the EBSS ",null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0]
[null,"Forecast opex for EBSS purposes",null,{"$f":"(D31+SUM(D33:D42))","v":118389.06938718664},125284.26545961003,129095.94520891365,164374.97606568641,169277.1865838409,172030.69532458973,177557.19945691674,181721.44679478623,null,null,{"$f":"+SUM(N31:N42)","v":156402.35067159159},165272.15434620852,170175.40157684952,184548.39127988779,190052.24038450592,193143.68179878325,199348.4428362239,204023.7600012178]
[]
[null,"7.5.1.2 - Actual and estimated opex applicable to EBSS"]
[null,null,"$m, Actual",null,null,null,null,null,null,null,null,null,"$m, Jun 2017"]
[null,null,"Previous period",null,null,null,"Current regulatory control period",null,null,null,null,null,"Previous period",null,null,null,"Current regulatory control period"]
[null,null,{"$f":"PRCP_y2","v":{"$error":"#REF!"}},{"$f":"PRCP_y3","v":{"$error":"#REF!"}},{"$f":"PRCP_y4","v":{"$error":"#REF!"}},{"$f":"PRCP_y5","v":{"$error":"#REF!"}},{"$f":"CRCP_y1","v":{"$error":"#REF!"}},{"$f":"CRCP_y2","v":{"$error":"#REF!"}},{"$f":"CRCP_y3","v":{"$error":"#REF!"}},{"$f":"CRCP_y4","v":{"$error":"#REF!"}},{"$f":"CRCP_y5","v":{"$error":"#REF!"}},null,{"$f":"PRCP_y2","v":{"$error":"#REF!"}},{"$f":"PRCP_y3","v":{"$error":"#REF!"}},{"$f":"PRCP_y4","v":{"$error":"#REF!"}},{"$f":"PRCP_y5","v":{"$error":"#REF!"}},{"$f":"CRCP_y1","v":{"$error":"#REF!"}},{"$f":"CRCP_y2","v":{"$error":"#REF!"}},{"$f":"CRCP_y3","v":{"$error":"#REF!"}},{"$f":"CRCP_y4","v":{"$error":"#REF!"}},{"$f":"CRCP_y5","v":{"$error":"#REF!"}}]
[null,"Total opex ",null,151884,150880,160384,167377.59669000003,181016,211260,214028.24761600001,null,null,null,{"$f":"+D49/F$21*(1+F$20)^0.5","v":181514.49027484359},174507.26566141707,181153.45530652633,{"$f":"+G49/I$21*(1+I$20)^0.5","v":185712.94968043643},195560.3025331402,223189.28312717465,221833.42364299425]
[null,"Approved excludable costs"]
[null,{"$f":"B33","v":"Equity raising costs"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"+D51/F$21*(1+F$20)^0.5","v":0},{"$f":"+E51/G$21*(1+G$20)^0.5","v":0},{"$f":"+F51/H$21*(1+H$20)^0.5","v":0}]
[null,{"$f":"B34","v":"Debt raising costs"},null,-320,-249,-265,-501,-500,-500,-1000,null,null,null,{"$f":"+D52/F$21*(1+F$20)^0.5","v":-382.42762165830464},{"$f":"+E52/G$21*(1+G$20)^0.5","v":-287.99250496880205},{"$f":"+F52/H$21*(1+H$20)^0.5","v":-299.31704943279556},{"$f":"+G52/I$21*(1+I$20)^0.5","v":-555.8819676579659},{"$f":"+H52/J$21*(1+J$20)^0.5","v":-540.17408000712703},{"$f":"+I52/K$21*(1+K$20)^0.5","v":-528.23365314582657},{"$f":"+J52/L$21*(1+L$20)^0.5","v":-1036.4679714660747}]
[null,{"$f":"B35","v":"Network support costs"},null,-12718,null,null,null,null,-2644,-3540,null,null,null,-15199.107788282245,0,0,0,0,-2793.2995578351311,-3669.0966189899045]
[null,{"$f":"B36","v":"Insurance & Self Insurance"},null,-6713,-7344,-7596,-7844,-8153,-8373,-9544,null,null,null,-8022.6144506006221,-8494.0440019714151,-8579.6690848736398,-8703.2697690800087,-8808.0785485962133,-8845.8007555800123,-9892.0503196722166]
[null,{"$f":"B37","v":"Capex Efficiencies"},null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0]
[null,{"$f":"B38","v":"Network growth adjustment"},null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0]
[null,"Capitalisation policy changes",null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0]
[null,"Movements in provisions related to opex",null,540.91587743732589,-1086.1660167130919,-1913,-14,-454,260,1490,null,null,null,646.44116414241114,-1256.2557107035705,-2160.7302474148596,-15.533627838745552,-490.47806464647135,274.68149963582988,1544.3372774844513]
[null,{"$f":"B42","v":"Other adjustments or exclusions required by the EBSS "},null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0]
[null,"Actual opex for EBSS purposes",null,{"$f":"D49+SUM(D51:D59)","v":132673.91587743734},142200.8339832869,150610,159018.59669000003,171909,200003,201434.24761600001,null,null,null,{"$f":"N49+SUM(N51:N59)","v":158556.78157844482},{"$f":"O49+SUM(O51:O59)","v":164468.97344377328},{"$f":"P49+SUM(P51:P59)","v":170113.73892480505},{"$f":"Q49+SUM(Q51:Q59)","v":176438.26431585971},{"$f":"R49+SUM(R51:R59)","v":185721.57183989038},211296.6306602495,208780.14601035052]
[null,null,null,null,null,null,null,null,null,"estimates",null,null,null,"base year",null,null,null,null,"base year"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Incremental gain ($m, \",dms_FRCP_FinalYear_Num,\")\")","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(Q43-Q60)-(P43-P60)+(N43-N60)","v":5894.0334051303798},{"$f":"(R43-R60)-(Q43-Q60)","v":-3779.4584194125491},{"$f":"(S43-S60)-(R43-R60)","v":-22483.617406081787},8721.2456873396295]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Carryover"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Current regulatory control period",null,null,null,null,"Forthcoming regulatory control period"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"$m, real \",dms_DollarReal)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CRCP_y1","v":{"$error":"#REF!"}},{"$f":"CRCP_y2","v":{"$error":"#REF!"}},{"$f":"CRCP_y3","v":{"$error":"#REF!"}},{"$f":"CRCP_y4","v":{"$error":"#REF!"}},{"$f":"CRCP_y5","v":{"$error":"#REF!"}},{"$f":"FRCP_y1","v":{"$error":"#REF!"}},{"$f":"FRCP_y2","v":{"$error":"#REF!"}},{"$f":"FRCP_y3","v":{"$error":"#REF!"}},{"$f":"FRCP_y4","v":{"$error":"#REF!"}},{"$f":"FRCP_y5","v":{"$error":"#REF!"}},"Total "]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CRCP_y1","v":{"$error":"#REF!"}},null,null,null,null,{"$f":"$Q$63","v":5894.0334051303798},{"$f":"$Q$63","v":5894.0334051303798},5894.0334051303798,5894.0334051303798,{"$f":"$Q$63","v":5894.0334051303798}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CRCP_y2","v":{"$error":"#REF!"}},null,null,null,null,null,{"$f":"$R$63","v":-3779.4584194125491},{"$f":"$R$63","v":-3779.4584194125491},-3779.4584194125491,-3779.4584194125491,{"$f":"$R$63","v":-3779.4584194125491}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CRCP_y3","v":{"$error":"#REF!"}},null,null,null,null,null,null,{"$f":"$S$63","v":-22483.617406081787},{"$f":"$S$63","v":-22483.617406081787},{"$f":"$S$63","v":-22483.617406081787},-22483.617406081787,{"$f":"$S$63","v":-22483.617406081787}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CRCP_y4","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,{"$f":"$T$63","v":8721.2456873396295},{"$f":"$T$63","v":8721.2456873396295},8721.2456873396295,8721.2456873396295,{"$f":"$T$63","v":8721.2456873396295}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CRCP_y5","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,{"$f":"$U$63","v":0},{"$f":"$U$63","v":0},0,0,{"$f":"$U$63","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Total Carryover Amount\")","v":"Total Carryover Amount"},null,null,null,null,null,null,null,null,{"$f":"+SUM(V69:V73)","v":-11647.796733024326},{"$f":"+SUM(W70:W73)","v":-17541.830138154706},{"$f":"+SUM(X71:X73)","v":-13762.371718742157},{"$f":"+SUM(Y72:Y73)","v":8721.2456873396295},{"$f":"+SUM(Z73)","v":0},{"$f":"SUM(V74:Z74)","v":-34230.75290258156}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"PTRM inputs\")","v":"PTRM inputs"},null,null,null,null,null,null,null,null,{"$f":"V74","v":-11647.796733024326},{"$f":"W74","v":-17541.830138154706},{"$f":"X74","v":-13762.371718742157},{"$f":"Y74","v":8721.2456873396295},{"$f":"Z74","v":0},{"$f":"SUM(V76:Z76)","v":-34230.75290258156}]
[]
[null,"7.5.2 - Proposed forecast opex for the EBSS for the forthcoming regulatory control period"]
[null,null,"Forthcoming regulatory control period"]
[null,null,{"$f":"CONCATENATE(\"$m, real \",dms_DollarReal)","v":{"$error":"#REF!"}}]
[null,null,{"$f":"FRCP_y1","v":{"$error":"#REF!"}},{"$f":"FRCP_y2","v":{"$error":"#REF!"}},{"$f":"FRCP_y3","v":{"$error":"#REF!"}},{"$f":"FRCP_y4","v":{"$error":"#REF!"}},{"$f":"FRCP_y5","v":{"$error":"#REF!"}}]
[null,"Forecast opex"]
[null,"Less excluded costs"]
[null,"< Enter category proposed for exclusion >  eg. Debt raising costs",0,0,0,0,0]
[null,null,0,0,0,0,0]
[null,null,0,0,0,0,0]
[null,null,0,0,0,0,0]
[null,null,0,0,0,0,0]
[null,null,0,0,0,0,0]
[null,null,0,0,0,0,0]
[null,null,0,0,0,0,0]
[null,null,0,0,0,0,0]
[null,null,0,0,0,0,0]
[null,"Adjusted forecast opex",{"$f":"+C82-SUM(C84:C93)","v":0},0,0,0,0]

{"sheet":"7.5 EBSS PQ","index":3,"n_rows":96,"n_cols":27,"rows_kept":96,"cut":false,"hidden":true,"merged":[[74,12,74,15],[80,2,80,6],[81,2,81,6],[67,21,67,25],[68,16,68,26],[70,12,70,15],[72,12,72,15],[73,12,73,15],[71,12,71,15],[63,12,63,20],[67,16,67,20],[30,2,30,5],[30,6,30,10],[30,12,30,15],[30,16,30,20],[47,2,47,10],[47,12,47,20],[48,2,48,5],[48,6,48,10],[48,12,48,15],[48,16,48,20],[8,1,8,12],[11,1,11,2],[29,2,29,5],[29,6,29,10],[29,12,29,20]]}
[null,"REGULATORY REPORTING STATEMENT"]
[null,{"$f":"INDEX(dms_TradingNameFull_List,MATCH(dms_TradingName,dms_TradingName_List))","v":{"$error":"#REF!"}}]
[null,{"$f":"CONCATENATE(FRCP_y1,\" to \",dms_FRCP_FinalYear_Num)","v":{"$error":"#REF!"}}]
[null,"7.5 EBSS"]
[]
[]
[null,"Instructions "]
[null,"Powerlink is required to populate all input cells (yellow) in tableS 7.5.1 and 7.5.2 presented below."]
[null,"\nEfficiency gains are calculated using the formulae below.  Adjusted target and actual amounts are used to calculate the carry-over amounts.\n\nWe will calculate the efficiency gain in 2012–13 (year 6) as follows:\nE6 = (F6 – A6) – (F5 – A5) + (F3 – A3)\nwhere F6 is the forecast opex we approved for year 6 (2012-13), and A6 is the actual opex incurred for year 6, and so on. The formula references year 3 (2009-10) because it is the base year used to forecast opex."]
[]
[]
[null,"SELECT BASE YEAR USED TO FORECAST OPEX FOR 2017-22",null,"2014-15"]
[]
[]
[]
[null,"CPI "]
[null,null,"2006-07","2007-08","2008-09","2009-10","2010-11","2011-12","2012-13","2013-14","2014-15","2015-16","2016-17"]
[null,"ABS CPI index Mar qtr (old base)",{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+#REF!","v":{"$error":"#REF!"}}]
[null,"ABS CPI index Mar qtr (rebased index)",{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+#REF!","v":{"$error":"#REF!"}}]
[null,"ABS CPI index Sept qtr (Old base)",{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+#REF!","v":{"$error":"#REF!"}}]
[null,"ABS CPI index Sept qtr (rebased index)",{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+#REF!","v":{"$error":"#REF!"}}]
[null,"Inflation rate (per cent) ",null,{"$f":"D18/C18-1","v":{"$error":"#REF!"}},{"$f":"E18/D18-1","v":{"$error":"#REF!"}},{"$f":"F18/E18-1","v":{"$error":"#REF!"}},{"$f":"G18/F18-1","v":{"$error":"#REF!"}},{"$f":"H19/G19-1","v":{"$error":"#REF!"}},{"$f":"I19/H19-1","v":{"$error":"#REF!"}},{"$f":"J19/I19-1","v":{"$error":"#REF!"}},{"$f":"K19/J19-1","v":{"$error":"#REF!"}},2.35E-2,2.4500000000000001E-2]
[null,"Reconstructed cumulative index (2016-17=1)",{"$f":"D23/(1+D22)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},0.95367454377997962,0.9760858955588092,1]
[]
[]
[]
[null,"7.5.1 - The carryover amounts that arise from applying the EBSS during the current regulatory control period"]
[]
[null,"7.5.1.1 - Opex allowance applicable to EBSS (EBSS target)"]
[null,null,"$m, Jun 2007",null,null,null,"$m,  Jun 2012",null,null,null,null,null,"$m, Jun 2017"]
[null,null,"Previous period",null,null,null,"Current regulatory control period",null,null,null,null,null,"Previous period",null,null,null,"Current regulatory control period"]
[null,null,{"$f":"PRCP_y2","v":{"$error":"#REF!"}},{"$f":"PRCP_y3","v":{"$error":"#REF!"}},{"$f":"PRCP_y4","v":{"$error":"#REF!"}},{"$f":"PRCP_y5","v":{"$error":"#REF!"}},{"$f":"CRCP_y1","v":{"$error":"#REF!"}},{"$f":"CRCP_y2","v":{"$error":"#REF!"}},{"$f":"CRCP_y3","v":{"$error":"#REF!"}},{"$f":"CRCP_y4","v":{"$error":"#REF!"}},{"$f":"CRCP_y5","v":{"$error":"#REF!"}},null,{"$f":"PRCP_y2","v":{"$error":"#REF!"}},{"$f":"PRCP_y3","v":{"$error":"#REF!"}},{"$f":"PRCP_y4","v":{"$error":"#REF!"}},{"$f":"PRCP_y5","v":{"$error":"#REF!"}},{"$f":"CRCP_y1","v":{"$error":"#REF!"}},{"$f":"CRCP_y2","v":{"$error":"#REF!"}},{"$f":"CRCP_y3","v":{"$error":"#REF!"}},{"$f":"CRCP_y4","v":{"$error":"#REF!"}},{"$f":"CRCP_y5","v":{"$error":"#REF!"}}]
[null,"Total opex allowance",null,154227,147589,151914,177936,184712,189464,196549,202292,null,null,{"$f":"+D33/$C$19*$M$19","v":{"$error":"#REF!"}},{"$f":"+E33/$C$19*$M$19","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"+G33/$H$23","v":{"$error":"#REF!"}},{"$f":"+H33/$H$23","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,"Approved excludable costs - allowance "]
[null,"Equity raising costs"]
[null,"Debt raising costs",null,-2268.23,-2388.5,-2525.1999999999998,-3496.3563727433425,-3760.8800458814285,-3948.7082582602125,-4048.3570933985529,-4183.2705947625318,null,null,{"$f":"+D36/$C$19*$M$19","v":{"$error":"#REF!"}},{"$f":"+E36/$C$19*$M$19","v":{"$error":"#REF!"}},{"$f":"+F36/$C$19*$M$19","v":{"$error":"#REF!"}},{"$f":"+G36/$H$23","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,"Network support costs",null,-22150,-8220,-8300,null,null,null,null,null,null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,"Insurance & Self Insurance",null,-5950.3,-6161.82,-6348.35,-8655.0563450977097,-9183.8293614270024,-9916.4781194194329,-10446.406428629474,-11180.242574694174,null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,"Capex Efficiencies",null,-3194.78,-3194.78,-3194.78,null,null,null,null,null,null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,"Network growth adjustment",null,null,null,null,-695.11177643113342,-1738.8043988991058,-2748.2088891924832,-3674.2468935935622,-4352.8297852762134,null,null,null,null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,"Capitalisation policy changes"]
[null,"Movements in provisions related to opex",null,-2274.6206128133704,-2339.6345403899722,-2449.7247910863512,-714.49944004141457,-751.29960995155432,-819.90940853815471,-822.79012746166075,-854.21025048085835,null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,"Opex associated with pass throughs"]
[null,"Other adjustments or exclusions required by the EBSS "]
[null,"Forecast opex for EBSS purposes",null,{"$f":"(D33+SUM(D35:D44))","v":118389.06938718664},125284.26545961003,129095.94520891365,164374.97606568641,169277.1865838409,172030.69532458973,177557.19945691674,181721.44679478623,null,null,{"$f":"+SUM(N33:N44)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,null,null,-1]
[null,"7.5.1.2 - Actual and estimated opex applicable to EBSS"]
[null,null,"$m, Actual",null,null,null,null,null,null,null,null,null,"$m, Jun 2017"]
[null,null,"Previous period",null,null,null,"Current regulatory control period",null,null,null,null,null,"Previous period",null,null,null,"Current regulatory control period"]
[null,null,{"$f":"PRCP_y2","v":{"$error":"#REF!"}},{"$f":"PRCP_y3","v":{"$error":"#REF!"}},{"$f":"PRCP_y4","v":{"$error":"#REF!"}},{"$f":"PRCP_y5","v":{"$error":"#REF!"}},{"$f":"CRCP_y1","v":{"$error":"#REF!"}},{"$f":"CRCP_y2","v":{"$error":"#REF!"}},{"$f":"CRCP_y3","v":{"$error":"#REF!"}},{"$f":"CRCP_y4","v":{"$error":"#REF!"}},{"$f":"CRCP_y5","v":{"$error":"#REF!"}},null,{"$f":"PRCP_y2","v":{"$error":"#REF!"}},{"$f":"PRCP_y3","v":{"$error":"#REF!"}},{"$f":"PRCP_y4","v":{"$error":"#REF!"}},{"$f":"PRCP_y5","v":{"$error":"#REF!"}},{"$f":"CRCP_y1","v":{"$error":"#REF!"}},{"$f":"CRCP_y2","v":{"$error":"#REF!"}},{"$f":"CRCP_y3","v":{"$error":"#REF!"}},{"$f":"CRCP_y4","v":{"$error":"#REF!"}},{"$f":"CRCP_y5","v":{"$error":"#REF!"}}]
[null,"Total opex ",null,151884,150880,160384,167377.59669000003,181016,211260,214028.24761600001,null,null,null,{"$f":"+D51/F$21*$M$19","v":{"$error":"#REF!"}},{"$f":"+E51/G$21*$M$19","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"+G51/I$21*$M$19","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,"Approved excludable costs"]
[null,{"$f":"B35","v":"Equity raising costs"}]
[null,{"$f":"B36","v":"Debt raising costs"},null,-320,-249,-265,-501,-500,-500,-1000,null,null,null,{"$f":"+D54/F$21*$M$19","v":{"$error":"#REF!"}},{"$f":"+E54/G$21*$M$19","v":{"$error":"#REF!"}},{"$f":"+F54/H$21*$M$19","v":{"$error":"#REF!"}},{"$f":"+G54/I$21*$M$19","v":{"$error":"#REF!"}},{"$f":"+H54/J$21*$M$19","v":{"$error":"#REF!"}},{"$f":"+I54/K$21*$M$19","v":{"$error":"#REF!"}},{"$f":"+J54/L$21*$M$19","v":{"$error":"#REF!"}}]
[null,{"$f":"B37","v":"Network support costs"},null,-12718,null,null,null,null,-2644,-3540,null,null,null,{"$error":"#REF!"},null,null,null,null,{"$error":"#REF!"},{"$error":"#REF!"}]
[null,{"$f":"B38","v":"Insurance & Self Insurance"},null,-6713,-7344,-7596,-7844,-8153,-8373,-9544,null,null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,{"$f":"+B39","v":"Capex Efficiencies"}]
[null,{"$f":"B40","v":"Network growth adjustment"}]
[null,"Capitalisation policy changes"]
[null,"Movements in provisions related to opex",null,540.91587743732589,-1086.1660167130919,-1913,-14,-454,260,1490,null,null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,{"$f":"B44","v":"Other adjustments or exclusions required by the EBSS "},null,null,null,null,null,null,null,null,null,null,null,{"$f":"+D61/D$21*$M$19","v":{"$error":"#REF!"}}]
[null,"Actual opex for EBSS purposes",null,{"$f":"D51+SUM(D53:D61)","v":132673.91587743734},142200.8339832869,150610,159018.59669000003,171909,200003,201434.24761600001,null,null,null,{"$f":"N51+SUM(N53:N61)","v":{"$error":"#REF!"}},{"$f":"O51+SUM(O53:O61)","v":{"$error":"#REF!"}},{"$f":"P51+SUM(P53:P61)","v":{"$error":"#REF!"}},{"$f":"Q51+SUM(Q53:Q61)","v":{"$error":"#REF!"}},{"$f":"R51+SUM(R53:R61)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,null,null,null,null,null,null,null,"estimates",null,null,null,"base year",null,null,null,null,"base year"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Incremental gain ($m, \",dms_FRCP_FinalYear_Num,\")\")","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+(Q45-Q62)-(P45-P62)+(O45-O62)","v":{"$error":"#REF!"}},{"$f":"(R45-R62)-(Q45-Q62)","v":{"$error":"#REF!"}},{"$f":"(S45-S62)-(R45-R62)","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Carryover"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Current regulatory control period",null,null,null,null,"Forthcoming regulatory control period"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"$m, real \",dms_DollarReal)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CRCP_y1","v":{"$error":"#REF!"}},{"$f":"CRCP_y2","v":{"$error":"#REF!"}},{"$f":"CRCP_y3","v":{"$error":"#REF!"}},{"$f":"CRCP_y4","v":{"$error":"#REF!"}},{"$f":"CRCP_y5","v":{"$error":"#REF!"}},{"$f":"FRCP_y1","v":{"$error":"#REF!"}},{"$f":"FRCP_y2","v":{"$error":"#REF!"}},{"$f":"FRCP_y3","v":{"$error":"#REF!"}},{"$f":"FRCP_y4","v":{"$error":"#REF!"}},{"$f":"FRCP_y5","v":{"$error":"#REF!"}},"Total "]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CRCP_y1","v":{"$error":"#REF!"}},null,null,null,null,{"$f":"$Q$65","v":{"$error":"#REF!"}},{"$f":"$Q$65","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"$Q$65","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CRCP_y2","v":{"$error":"#REF!"}},null,null,null,null,null,{"$f":"$R$65","v":{"$error":"#REF!"}},{"$f":"$R$65","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"$R$65","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CRCP_y3","v":{"$error":"#REF!"}},null,null,null,null,null,null,{"$f":"$S$65","v":{"$error":"#REF!"}},{"$f":"$S$65","v":{"$error":"#REF!"}},{"$f":"$S$65","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"$S$65","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CRCP_y4","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,{"$f":"$T$65","v":{"$error":"#REF!"}},{"$f":"$T$65","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"$T$65","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CRCP_y5","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,{"$f":"$U$65","v":0},{"$f":"$U$65","v":0},0,0,{"$f":"$U$65","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Total Carryover Amount\")","v":"Total Carryover Amount"},null,null,null,null,null,null,null,null,{"$f":"+SUM(V71:V75)","v":{"$error":"#REF!"}},{"$f":"+SUM(W72:W75)","v":{"$error":"#REF!"}},{"$f":"+SUM(X73:X75)","v":{"$error":"#REF!"}},{"$f":"+SUM(Y74:Y75)","v":{"$error":"#REF!"}},{"$f":"+SUM(Z75)","v":0},{"$f":"SUM(V76:Z76)","v":{"$error":"#REF!"}}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"PTRM inputs\")","v":"PTRM inputs"},null,null,null,null,null,null,null,null,{"$f":"V76","v":{"$error":"#REF!"}},{"$f":"W76","v":{"$error":"#REF!"}},{"$f":"X76","v":{"$error":"#REF!"}},{"$f":"Y76","v":{"$error":"#REF!"}},{"$f":"Z76","v":0},{"$f":"SUM(V78:Z78)","v":{"$error":"#REF!"}}]
[]
[null,"7.5.2 - Proposed forecast opex for the EBSS for the forthcoming regulatory control period"]
[null,null,"Forthcoming regulatory control period"]
[null,null,{"$f":"CONCATENATE(\"$m, real \",dms_DollarReal)","v":{"$error":"#REF!"}}]
[null,null,{"$f":"FRCP_y1","v":{"$error":"#REF!"}},{"$f":"FRCP_y2","v":{"$error":"#REF!"}},{"$f":"FRCP_y3","v":{"$error":"#REF!"}},{"$f":"FRCP_y4","v":{"$error":"#REF!"}},{"$f":"FRCP_y5","v":{"$error":"#REF!"}}]
[null,"Forecast opex"]
[null,"Less excluded costs"]
[null,"< Enter category proposed for exclusion >  eg. Debt raising costs",0,0,0,0,0]
[null,null,0,0,0,0,0]
[null,null,0,0,0,0,0]
[null,null,0,0,0,0,0]
[null,null,0,0,0,0,0]
[null,null,0,0,0,0,0]
[null,null,0,0,0,0,0]
[null,null,0,0,0,0,0]
[null,null,0,0,0,0,0]
[null,null,0,0,0,0,0]
[null,"Adjusted forecast opex",{"$f":"+C84-SUM(C86:C95)","v":0},0,0,0,0]

{"sheet":"7.5 EBSS PQ Version 2","index":4,"n_rows":101,"n_cols":27,"rows_kept":101,"cut":false,"hidden":true,"merged":[[8,1,8,12],[11,1,11,2],[29,2,29,5],[29,6,29,10],[29,12,29,20],[68,12,68,20],[72,16,72,20],[30,2,30,5],[30,6,30,10],[30,12,30,15],[30,16,30,20],[47,2,47,10],[47,12,47,20],[48,2,48,5],[48,6,48,10],[48,12,48,15],[48,16,48,20],[79,12,79,15],[85,2,85,6],[86,2,86,6],[72,21,72,25],[73,16,73,26],[75,12,75,15],[77,12,77,15],[78,12,78,15],[76,12,76,15]]}
[null,"REGULATORY REPORTING STATEMENT"]
[null,{"$f":"INDEX(dms_TradingNameFull_List,MATCH(dms_TradingName,dms_TradingName_List))","v":{"$error":"#REF!"}}]
[null,{"$f":"CONCATENATE(FRCP_y1,\" to \",dms_FRCP_FinalYear_Num)","v":{"$error":"#REF!"}}]
[null,"7.5 EBSS"]
[]
[]
[null,"Instructions "]
[null,"Powerlink is required to populate all input cells (yellow) in tableS 7.5.1 and 7.5.2 presented below."]
[null,"\nEfficiency gains are calculated using the formulae below.  Adjusted target and actual amounts are used to calculate the carry-over amounts.\n\nWe will calculate the efficiency gain in 2012–13 (year 6) as follows:\nE6 = (F6 – A6) – (F5 – A5) + (F3 – A3)\nwhere F6 is the forecast opex we approved for year 6 (2012-13), and A6 is the actual opex incurred for year 6, and so on. The formula references year 3 (2009-10) because it is the base year used to forecast opex."]
[]
[]
[null,"SELECT BASE YEAR USED TO FORECAST OPEX FOR 2017-22",null,"2014-15"]
[]
[]
[]
[null,"CPI "]
[null,null,"2006-07","2007-08","2008-09","2009-10","2010-11","2011-12","2012-13","2013-14","2014-15","2015-16","2016-17"]
[null,"ABS CPI index Mar qtr (old base)",{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+#REF!","v":{"$error":"#REF!"}}]
[null,"ABS CPI index Mar qtr (rebased index)",{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+#REF!","v":{"$error":"#REF!"}}]
[null,"ABS CPI index Sept qtr (Old base)",{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+#REF!","v":{"$error":"#REF!"}}]
[null,"ABS CPI index Sept qtr (rebased index)",{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+#REF!","v":{"$error":"#REF!"}}]
[null,"Inflation rate (per cent) ",null,{"$f":"D18/C18-1","v":{"$error":"#REF!"}},{"$f":"E18/D18-1","v":{"$error":"#REF!"}},{"$f":"F18/E18-1","v":{"$error":"#REF!"}},{"$f":"G18/F18-1","v":{"$error":"#REF!"}},{"$f":"H19/G19-1","v":{"$error":"#REF!"}},{"$f":"I19/H19-1","v":{"$error":"#REF!"}},{"$f":"J19/I19-1","v":{"$error":"#REF!"}},{"$f":"K19/J19-1","v":{"$error":"#REF!"}},2.35E-2,2.4500000000000001E-2]
[null,"Reconstructed cumulative index (2016-17=1)",{"$f":"D23/(1+D22)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},0.95367454377997962,0.9760858955588092,1]
[]
[]
[]
[null,"7.5.1 - The carryover amounts that arise from applying the EBSS during the current regulatory control period"]
[]
[null,"7.5.1.1 - Opex allowance applicable to EBSS (EBSS target)"]
[null,null,"$m, Jun 2007",null,null,null,"$m,  Jun 2012",null,null,null,null,null,"$m, Jun 2017"]
[null,null,"Previous period",null,null,null,"Current regulatory control period",null,null,null,null,null,"Previous period",null,null,null,"Current regulatory control period"]
[null,null,{"$f":"PRCP_y2","v":{"$error":"#REF!"}},{"$f":"PRCP_y3","v":{"$error":"#REF!"}},{"$f":"PRCP_y4","v":{"$error":"#REF!"}},{"$f":"PRCP_y5","v":{"$error":"#REF!"}},{"$f":"CRCP_y1","v":{"$error":"#REF!"}},{"$f":"CRCP_y2","v":{"$error":"#REF!"}},{"$f":"CRCP_y3","v":{"$error":"#REF!"}},{"$f":"CRCP_y4","v":{"$error":"#REF!"}},{"$f":"CRCP_y5","v":{"$error":"#REF!"}},null,{"$f":"PRCP_y2","v":{"$error":"#REF!"}},{"$f":"PRCP_y3","v":{"$error":"#REF!"}},{"$f":"PRCP_y4","v":{"$error":"#REF!"}},{"$f":"PRCP_y5","v":{"$error":"#REF!"}},{"$f":"CRCP_y1","v":{"$error":"#REF!"}},{"$f":"CRCP_y2","v":{"$error":"#REF!"}},{"$f":"CRCP_y3","v":{"$error":"#REF!"}},{"$f":"CRCP_y4","v":{"$error":"#REF!"}},{"$f":"CRCP_y5","v":{"$error":"#REF!"}}]
[null,"Total opex allowance",null,154227,147589,151914,177936,184712,189464,196549,202292,null,null,{"$f":"+D33/$C$19*$M$19","v":{"$error":"#REF!"}},{"$f":"+E33/$C$19*$M$19","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"+G33/$H$23","v":{"$error":"#REF!"}},{"$f":"+H33/$H$23","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,"Approved excludable costs - allowance "]
[null,"Equity raising costs",null,null,null,null,null,null,null,null,null,null,null,{"$f":"+D35/$C$19*$M$19","v":{"$error":"#REF!"}},{"$f":"+E35/$C$19*$M$19","v":{"$error":"#REF!"}},{"$f":"+F35/$C$19*$M$19","v":{"$error":"#REF!"}}]
[null,"Debt raising costs",null,-2268.23,-2388.5,-2525.1999999999998,-3496.3563727433425,-3760.8800458814285,-3948.7082582602125,-4048.3570933985529,-4183.2705947625318,null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"+G36/$H$23","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,"Network support costs",null,-22150,-8220,-8300,null,null,null,null,null,null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,"Insurance & Self Insurance",null,-5950.3,-6161.82,-6348.35,-8655.0563450977097,-9183.8293614270024,-9916.4781194194329,-10446.406428629474,-11180.242574694174,null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,"Capex Efficiencies",null,-3194.78,-3194.78,-3194.78,null,null,null,null,null,null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,"Network growth adjustment",null,null,null,null,-695.11177643113342,-1738.8043988991058,-2748.2088891924832,-3674.2468935935622,-4352.8297852762134,null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,"Capitalisation policy changes",null,null,null,null,null,null,null,null,null,null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,"Movements in provisions related to opex",null,-2274.6206128133704,-2339.6345403899722,-2449.7247910863512,-714.49944004141457,-751.29960995155432,-819.90940853815471,-822.79012746166075,-854.21025048085835,null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,"Opex associated with pass throughs",null,null,null,null,null,null,null,null,null,null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,"Other adjustments or exclusions required by the EBSS ",null,null,null,null,null,null,null,null,null,null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,"Forecast opex for EBSS purposes",null,{"$f":"(D33+SUM(D35:D44))","v":118389.06938718664},125284.26545961003,129095.94520891365,164374.97606568641,169277.1865838409,172030.69532458973,177557.19945691674,181721.44679478623,null,null,{"$f":"+SUM(N33:N44)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[]
[null,"7.5.1.2 - Actual and estimated opex applicable to EBSS"]
[null,null,"$m, Actual",null,null,null,null,null,null,null,null,null,"$m, Jun 2017"]
[null,null,"Previous period",null,null,null,"Current regulatory control period",null,null,null,null,null,"Previous period",null,null,null,"Current regulatory control period"]
[null,null,{"$f":"PRCP_y2","v":{"$error":"#REF!"}},{"$f":"PRCP_y3","v":{"$error":"#REF!"}},{"$f":"PRCP_y4","v":{"$error":"#REF!"}},{"$f":"PRCP_y5","v":{"$error":"#REF!"}},{"$f":"CRCP_y1","v":{"$error":"#REF!"}},{"$f":"CRCP_y2","v":{"$error":"#REF!"}},{"$f":"CRCP_y3","v":{"$error":"#REF!"}},{"$f":"CRCP_y4","v":{"$error":"#REF!"}},{"$f":"CRCP_y5","v":{"$error":"#REF!"}},null,{"$f":"PRCP_y2","v":{"$error":"#REF!"}},{"$f":"PRCP_y3","v":{"$error":"#REF!"}},{"$f":"PRCP_y4","v":{"$error":"#REF!"}},{"$f":"PRCP_y5","v":{"$error":"#REF!"}},{"$f":"CRCP_y1","v":{"$error":"#REF!"}},{"$f":"CRCP_y2","v":{"$error":"#REF!"}},{"$f":"CRCP_y3","v":{"$error":"#REF!"}},{"$f":"CRCP_y4","v":{"$error":"#REF!"}},{"$f":"CRCP_y5","v":{"$error":"#REF!"}}]
[null,"Total opex ",null,151884,150880,160384,167377.59669000003,181016,211260,214028.24761600001,null,null,null,{"$f":"+D51/F$21*$M$19","v":{"$error":"#REF!"}},{"$f":"+E51/G$21*$M$19","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,"Approved excludable costs"]
[null,{"$f":"B35","v":"Equity raising costs"}]
[null,{"$f":"B36","v":"Debt raising costs"},null,-320,-249,-265,-501,-500,-500,-1000,null,null,null,{"$f":"+D54/F$21*$M$19","v":{"$error":"#REF!"}},{"$f":"+E54/G$21*$M$19","v":{"$error":"#REF!"}},{"$f":"+F54/H$21*$M$19","v":{"$error":"#REF!"}},{"$f":"+G54/I$21*$M$19","v":{"$error":"#REF!"}},{"$f":"+H54/J$21*$M$19","v":{"$error":"#REF!"}},{"$f":"+I54/K$21*$M$19","v":{"$error":"#REF!"}},{"$f":"+J54/L$21*$M$19","v":{"$error":"#REF!"}}]
[null,{"$f":"B37","v":"Network support costs"},null,-12718,null,null,null,null,-2644,-3540,null,null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,{"$f":"B38","v":"Insurance & Self Insurance"},null,-6713,-7344,-7596,-7844,-8153,-8373,-9544,null,null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,{"$f":"+B39","v":"Capex Efficiencies"},null,null,null,null,null,null,null,null,null,null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,"AEMC Levy",null,null,null,null,null,null,-3790,-4100,null,null,null,{"$f":"+D58/F$21*$M$19","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,"500Kv Write Off",null,null,null,null,null,null,-12054,null,null,null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,"Remove non reg element of CMG",null,null,null,null,null,null,null,-404,null,null,null,null,null,null,null,null,null,{"$error":"#REF!"}]
[null,"Redundancy Work Load Driven",null,null,null,null,null,null,null,-8398,null,null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,"Redundancy Entitlement costs",null,null,null,null,null,null,null,-1358,null,null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,{"$f":"B40","v":"Network growth adjustment"},null,null,null,null,null,null,null,null,null,null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,{"$f":"B41","v":"Capitalisation policy changes"},null,null,null,null,null,null,null,null,null,null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,{"$f":"B42","v":"Movements in provisions related to opex"},null,540.91587743732589,-1086.1660167130919,-1913,-14,-454,260,1490,null,null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,{"$f":"B44","v":"Other adjustments or exclusions required by the EBSS "},null,null,null,null,null,null,null,null,null,null,null,{"$f":"+D66/D$21*$M$19","v":{"$error":"#REF!"}}]
[null,"Actual opex for EBSS purposes",null,{"$f":"D51+SUM(D53:D66)","v":132673.91587743734},142200.8339832869,150610,159018.59669000003,171909,184159,187174.24761600001,null,null,null,{"$f":"N51+SUM(N53:N66)","v":{"$error":"#REF!"}},{"$f":"O51+SUM(O53:O66)","v":{"$error":"#REF!"}},{"$f":"P51+SUM(P53:P66)","v":{"$error":"#REF!"}},{"$f":"Q51+SUM(Q53:Q66)","v":{"$error":"#REF!"}},{"$f":"R51+SUM(R53:R66)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,null,null,null,null,null,null,null,"estimates",null,null,null,"base year",null,null,null,null,"base year"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Incremental gain ($m, \",dms_FRCP_FinalYear_Num,\")\")","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+(Q45-Q67)-(P45-P67)+(O45-O67)","v":{"$error":"#REF!"}},{"$f":"(R45-R67)-(Q45-Q67)","v":{"$error":"#REF!"}},{"$f":"(S45-S67)-(R45-R67)","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Carryover"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Current regulatory control period",null,null,null,null,"Forthcoming regulatory control period"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"$m, real \",dms_DollarReal)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CRCP_y1","v":{"$error":"#REF!"}},{"$f":"CRCP_y2","v":{"$error":"#REF!"}},{"$f":"CRCP_y3","v":{"$error":"#REF!"}},{"$f":"CRCP_y4","v":{"$error":"#REF!"}},{"$f":"CRCP_y5","v":{"$error":"#REF!"}},{"$f":"FRCP_y1","v":{"$error":"#REF!"}},{"$f":"FRCP_y2","v":{"$error":"#REF!"}},{"$f":"FRCP_y3","v":{"$error":"#REF!"}},{"$f":"FRCP_y4","v":{"$error":"#REF!"}},{"$f":"FRCP_y5","v":{"$error":"#REF!"}},"Total "]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CRCP_y1","v":{"$error":"#REF!"}},null,null,null,null,{"$f":"$Q$70","v":{"$error":"#REF!"}},{"$f":"$Q$70","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"$Q$70","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CRCP_y2","v":{"$error":"#REF!"}},null,null,null,null,null,{"$f":"$R$70","v":{"$error":"#REF!"}},{"$f":"$R$70","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"$R$70","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CRCP_y3","v":{"$error":"#REF!"}},null,null,null,null,null,null,{"$f":"$S$70","v":{"$error":"#REF!"}},{"$f":"$S$70","v":{"$error":"#REF!"}},{"$f":"$S$70","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"$S$70","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CRCP_y4","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,{"$f":"$T$70","v":{"$error":"#REF!"}},{"$f":"$T$70","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"$T$70","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CRCP_y5","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,{"$f":"$U$70","v":0},{"$f":"$U$70","v":0},0,0,{"$f":"$U$70","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Total Carryover Amount\")","v":"Total Carryover Amount"},null,null,null,null,null,null,null,null,{"$f":"+SUM(V76:V80)","v":{"$error":"#REF!"}},{"$f":"+SUM(W77:W80)","v":{"$error":"#REF!"}},{"$f":"+SUM(X78:X80)","v":{"$error":"#REF!"}},{"$f":"+SUM(Y79:Y80)","v":{"$error":"#REF!"}},{"$f":"+SUM(Z80)","v":0},{"$f":"SUM(V81:Z81)","v":{"$error":"#REF!"}}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"PTRM inputs\")","v":"PTRM inputs"},null,null,null,null,null,null,null,null,{"$f":"V81","v":{"$error":"#REF!"}},{"$f":"W81","v":{"$error":"#REF!"}},{"$f":"X81","v":{"$error":"#REF!"}},{"$f":"Y81","v":{"$error":"#REF!"}},{"$f":"Z81","v":0},{"$f":"SUM(V83:Z83)","v":{"$error":"#REF!"}}]
[]
[null,"7.5.2 - Proposed forecast opex for the EBSS for the forthcoming regulatory control period"]
[null,null,"Forthcoming regulatory control period"]
[null,null,{"$f":"CONCATENATE(\"$m, real \",dms_DollarReal)","v":{"$error":"#REF!"}}]
[null,null,{"$f":"FRCP_y1","v":{"$error":"#REF!"}},{"$f":"FRCP_y2","v":{"$error":"#REF!"}},{"$f":"FRCP_y3","v":{"$error":"#REF!"}},{"$f":"FRCP_y4","v":{"$error":"#REF!"}},{"$f":"FRCP_y5","v":{"$error":"#REF!"}}]
[null,"Forecast opex"]
[null,"Less excluded costs"]
[null,"< Enter category proposed for exclusion >  eg. Debt raising costs",0,0,0,0,0]
[null,null,0,0,0,0,0]
[null,null,0,0,0,0,0]
[null,null,0,0,0,0,0]
[null,null,0,0,0,0,0]
[null,null,0,0,0,0,0]
[null,null,0,0,0,0,0]
[null,null,0,0,0,0,0]
[null,null,0,0,0,0,0]
[null,null,0,0,0,0,0]
[null,"Adjusted forecast opex",{"$f":"+C89-SUM(C91:C100)","v":0},0,0,0,0]