{"text_format":"1","workbook":"xlsx","n_sheets":20,"sheets":["AER only","Contents","Instructions","Business & other details","2.1 Expenditure summary","2.2 Repex","2.6 Non-network","2.10 Overheads","2.14 Forecast price changes","2.16 Opex Summary","2.17 Step Changes","3.1 Revenue","3.2 Operating expenditure","3.3 Assets (RAB)","Unprotected 3.3 Assets (RAB)","7.5 EBSS","7.6 Indicative bill impact ","7.7 STPIS","2.10.2, 2.17.1, 7.7.1","Unprotected 2.2 Repex "],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":12,"defined_names":612,"comments":1,"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":12,"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":"2015"}]
[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":"2017"}]
[null,"CPI","CPI",null,"dms_RYE",{"$f":"CONCATENATE(LEFT(CRCP_y5, 2) &IF(CRCP_y5>\"2009-10\",,\"\") &RIGHT(CRCP_y5,2))","v":"2017"}]
[null,"EB","ECONOMIC BENCHMARKING",null,"dms_RYE",{"$f":"CONCATENATE(LEFT(CRY, 2) &IF(CRY>\"2009-10\",,\"\") &RIGHT(CRY,2))","v":"2015"}]
[null,"PTRM","POST TAX REVENUE MODEL",null,"FRCP",{"$f":"CONCATENATE(LEFT(FRCP_y5, 2) &IF(FRCP_y1>\"2009-10\",,\"\") &RIGHT(FRCP_y5,2))","v":"2022"}]
[null,"Reset","REGULATORY REPORTING STATEMENT",null,"FRCP",{"$f":"CONCATENATE(LEFT(FRCP_y5, 2) &IF(FRCP_y1>\"2009-10\",,\"\") &RIGHT(FRCP_y5,2))","v":"2022"}]
[null,"RFM","ROLL FORWARD MODEL",null,"CRCP",{"$f":"CONCATENATE(LEFT(CRCP_y5, 2) &IF(CRCP_y1>\"2009-10\",,\"\") &RIGHT(CRCP_y5,2))","v":"2017"}]
[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":"2017"}]
[]
[]
[null,"dms_TradingName_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",76670568688,"ACT","Electricity","Distribution","Revenue cap",5,6,"ACT",5,"2014-19 Distribution Determination"]
[null,"ActewAGL Distribution (Tx Assets)",76670568688,"ACT","Electricity","Distribution","Revenue cap",5,5,"ACT",5,"distribution determination"]
[null,"AGN",78551685,"SA","Gas","Distribution","Revenue cap",5,5,"SA",5,"distribution determination"]
[null,"Ausgrid",67505337385,"NSW","Electricity","Distribution","Revenue cap",5,5,"NSW",5,"2014-19 Distribution Determination"]
[null,"Ausgrid (Tx Assets)",67505337385,"NSW","Electricity","Distribution","Revenue cap",5,5,"NSW",5,"distribution determination"]
[null,"AusNet (D)",91064651118,"Vic","Electricity","Distribution","Revenue cap",5,5,"Vic",2,"2016-20 Distribution Determination"]
[null,"AusNet (T)",78079798173,"Vic","Electricity","Transmission","Revenue cap",5,5,"Vic",2,"distribution determination"]
[null,"Australian Distribution Co.",11222333444,"-","Electricity","Distribution","Revenue cap",5,5,"-",2,"distribution determination"]
[null,"Australian Transmission Co.",11222333444,"-","Electricity","Transmission","Revenue cap",5,5,"-",5,"distribution determination"]
[null,"CitiPower",76064651056,"Vic","Electricity","Distribution","Revenue cap",5,5,"Vic",2,"2016-20 Distribution Determination"]
[null,"Directlink",16779340889,"NSW","Electricity","Transmission","Revenue cap",10,5,"Qld",5,"distribution determination"]
[null,"ElectraNet",41094482416,"SA","Electricity","Transmission","Revenue cap",5,5,"SA",5,"distribution determination"]
[null,"Endeavour Energy",59253130878,"NSW","Electricity","Distribution","Revenue cap",5,5,"NSW",5,"2014-19 Distribution Determination"]
[null,"Energex",40078849055,"Qld","Electricity","Distribution","Revenue cap",5,5,"Qld",5,"2015-20 Distribution Determination"]
[null,"Ergon Energy",50087646062,"Qld","Electricity","Distribution","Revenue cap",5,5,"Qld",5,"2015-20 Distribution Determination"]
[null,"Essential Energy",37428185226,"NSW","Electricity","Distribution","Revenue cap",5,5,"NSW",5,"2014-19 Distribution Determination"]
[null,"Jemena Electricity",82064651083,"Vic","Electricity","Distribution","Revenue cap",5,5,"Vic",2,"2016-20 Distribution Determination"]
[null,"Murraylink",79181207909,"NSW","Electricity","Transmission","Revenue cap",5,5,"SA",5,"distribution determination"]
[null,"Powercor Australia",89064651109,"Vic","Electricity","Distribution","Revenue cap",5,5,"Vic",2,"2016-20 Distribution Determination"]
[null,"Powerlink",82078849233,"Qld","Electricity","Transmission","Revenue cap",5,5,"Qld",5,"distribution determination"]
[null,"Qld,SA &ACT Gas Reset",22222222222,"-","Gas","Distribution","?",5,5,"-","x","distribution determination"]
[null,"SA Power Networks",13332330749,"SA","Electricity","Distribution","Revenue cap",5,5,"SA",5,"2015-20 Distribution Determination"]
[null,"TasNetworks (D)",24167357299,"Tas","Electricity","Distribution","Revenue cap",5,5,"Tas",5,"distribution determination"]
[null,"TasNetworks (T)",24167357299,"Tas","Electricity","Transmission","Revenue cap",5,5,"Tas",5,"distribution determination"]
[null,"TransGrid",19622755774,"NSW","Electricity","Transmission","Revenue cap",5,5,"NSW",5,"distribution determination"]
[null,"United Energy",70064651029,"Vic","Electricity","Distribution","Revenue cap",5,5,"Vic",2,"2016-20 Distribution Determination"]
[null,"Victorian DNSP Backcasting",33333333666,"Vic","Electricity","Distribution","?",5,5,"Vic","x","distribution determination"]
[null,"Victorian DNSP Reset ",33333333333,"Vic","Electricity","Distribution","?",5,5,"Vic","x","distribution determination"]
[]
[]
[]
[]
[null,"dms_SourceList","dms_FormControl"]
[null,"After appeal","Revenue cap"]
[null,"Draft decision","Revenue yield"]
[null,"Final decision","Weighted average price cap"]
[null,"Pass through decision"]
[null,"PTRM annual update"]
[null,"PTRM interim update 1"]
[null,"PTRM interim update 2"]
[null,"PTRM interim update 3"]
[null,"PTRM interim update 4"]
[null,"Regulatory proposal"]
[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":"Contents","index":1,"n_rows":26,"n_cols":20,"rows_kept":26,"cut":false,"hidden":false,"merged":[[3,2,3,27]]}
[null,null,"REGULATORY REPORTING STATEMENT\n"]
[null,null,{"$f":"dms_TradingName","v":"AusNet (T)"}]
[null,null,{"$f":"CONCATENATE(FRCP_y1,\" to \",FRCP_y5)","v":"2017-18 to 2021-22"}]
[null,null,"Contents"]
[]
[]
[null,null,null,null,null,"1. Business details",null,null,null,null,null,null,"2. Expenditure",null,null,null,null,null,null,"3. Economic benchmarking"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"5. Network information",null,null,null,null,null,null,null,null,null,null,null,null,null,"7. Other templates"]

{"sheet":"Instructions","index":2,"n_rows":28,"n_cols":4,"rows_kept":28,"cut":false,"hidden":false,"merged":[[20,2,20,4],[27,2,27,4],[15,2,15,4],[7,1,7,5],[8,1,8,5],[10,2,10,4],[14,2,14,4],[17,2,17,3],[18,2,18,4]]}
[]
[]
[]
[]
[]
[]
[]
[null,{"$f":"CONCATENATE(dms_Segment,\" Network Service Provider\")","v":"Transmission Network Service Provider"}]
[null,"Regulatory Proposal RIN Template"]
[]
[null,null,{"$f":"CONCATENATE(dms_TradingName,\" must fill out and submit the regulatory templates in this workbook as part of its revenue proposal\")","v":"AusNet (T) must fill out and submit the regulatory templates in this workbook as part of its revenue proposal"}]
[]
[]
[null,null,"INSTRUCTIONS"]
[null,null,"Complete the Business & other details worksheet before entering data or values in any other worksheets. The Business & other details worksheet is linked to other cells within the workbook and automatically generates certain column headings.\n\nPlease identify whether this is a regulatory proposal or revised regulatory proposal on the Business & other details worksheet."]
[null,null,{"$f":"CONCATENATE(\"If \",dms_TradingName,\" needs to amend any data please resubmit this completed workbook in its entirety after making any necessary amendments and provide a brief description of those amendments and the reason for any amendments on the Business and other details worksheet.\")","v":"If AusNet (T) needs to amend any data please resubmit this completed workbook in its entirety after making any necessary amendments and provide a brief description of those amendments and the reason for any amendments on the Business and other details worksheet."}]
[]
[null,null,"Identifying CONFIDENTIAL INFORMATION:\n\nPlease use the macro at the top of each \nworksheet to identify confidential information. \n\n"]
[null,null,"-Do this by selecting the cell or cells that contain confidential information and then run the Mark selected cells as CONFIDENTIAL macro. This will format the cells a specific colour that is identified by the AER's database which in turn marks that information as confidential.\n\n-To reverse this, select the cell or cells and run the Return cells to NON-CONFIDENTIAL macro"]
[]
[null,null,"All amounts are to be reported on a one for one basis: that is 1000 is to be entered as '1000' not '1' as in previous templates.\n\nColour coding of input sheets:"]
[null,null,null,"Yellow = input cells"]
[null,null,null,"Orange = optional Input cells"]
[null,null,null,"Grey = Not applicable/No inputs required"]
[null,null,null,"Leave coloured cells blank if no information exists. \nPLEASE DO NOT ENTER TEXT unless specifically requested to do so."]
[]
[]
[null,null,"Returning completed responses\n\nPlease return two (2) files to the AER: \n1. A confidential (consolidated) version which must contain a complete set of all responses with confidential information marked using the Mark selected cells CONFIDENTIAL macro and which has been completed using the locked template file provided by the AER. \n\n2. A public version with confidential information either removed completely or aggregated in some form together with writtten consent to disclose the public version of the response.\n\nUse the drop down box on the Business & other details worksheet to identify the file as either confidential ('consolidated') or public\n\n"]

{"sheet":"Business & other details","index":3,"n_rows":66,"n_cols":8,"rows_kept":66,"cut":false,"hidden":false,"merged":[[23,5,23,8],[7,2,7,9],[11,2,11,9],[13,3,13,5],[14,3,14,5],[17,3,17,4],[17,5,17,8],[18,5,18,8],[19,3,19,4],[19,5,19,8],[22,3,22,4],[22,5,22,8],[24,3,24,4],[24,5,24,8],[28,3,28,4],[28,6,28,7],[29,3,29,4],[29,6,29,7],[51,3,51,4],[58,3,58,9],[59,0,65,0],[30,3,30,4],[30,6,30,7],[32,0,41,0],[32,2,32,9],[38,3,38,4],[43,0,46,0]]}
["HIDE THIS COLUMN",null,{"$f":"(LOOKUP(dms_Model,dms_Model_List,dms_Worksheet_List))","v":"REGULATORY REPORTING STATEMENT"}]
[null,null,{"$f":"dms_TradingName","v":"AusNet (T)"}]
[null,null,{"$f":"CONCATENATE(FRCP_y1,\" to \",FRCP_y5)","v":"2017-18 to 2021-22"}]
[null,null,"BUSINESS & OTHER DETAILS"]
[]
[]
[null,null,"Instructions"]
[null,null,"Complete the following business details regulatory template before entering data or values in any other regulatory template. This regulatory template is linked to other cells within the spreadsheet and automatically generates column headings."]
[]
[null,null,"SUBMISSION PARTICULARS INPUT SHEETS"]
[]
[null,null,"Entity details"]
[]
[null,null,"Trading name","AusNet (T)"]
[null,null,"ACN / ABN",{"$f":"INDEX(dms_ABN_List,MATCH(dms_TradingName,dms_TradingName_List))","v":78079798173}]
[]
[]
[null,null,"Business address","Address 1",null,"2 Southbank Boulevard"]
[null,null,null,null,"Address 2"]
[null,null,null,"Suburb",null,"Southbank"]
[null,null,null,null,"State",{"$f":"INDEX(dms_State_List,MATCH(dms_TradingName,dms_TradingName_List))","v":"Vic"},"p/code",3008]
[]
[null,null,"Postal address","Address 1",null,"2 Southbank Boulevard"]
[null,null,null,null,"Address 2"]
[null,null,null,"Suburb",null,"Southbank"]
[null,null,null,null,"State","Vic","p/code",3008]
[]
[]
[null,null,"Contact name/s","Anh Mai",null,null,"Charlotte Coster"]
[null,null,"Contact phone/s","03 96956627",null,null,"03 96956309"]
[null,null,"Contact email address/s","anh.mai@ausnetservices.com.au",null,null,"charlotte.coster@ausnetservices.com.au"]
[]
["KEEP VISIBLE FOR\n RESET, PTRM & RFMS",null,"Regulatory control period details"]
[]
[null,null,"Forthcoming regulatory control period",{"$f":"CONCATENATE(IF(dms_RPT=\"Calendar\",CRCP_y5+1,(LEFT(CRCP_y5,4)+1&\"-\"&IF(MID(CRCP_y5,6,2)<\"09\",\"0\"&RIGHT(CRCP_y5,1)+1,RIGHT(CRCP_y5,2)+1))))","v":"2017-18"},{"$f":"CONCATENATE(IF(dms_RPT=\"Calendar\",FRCP_y1+1,(LEFT(FRCP_y1,4)+1&\"-\"&IF(MID(FRCP_y1,6,2)<\"09\",\"0\"&RIGHT(FRCP_y1,1)+1,RIGHT(FRCP_y1,2)+1))))","v":"2018-19"},{"$f":"CONCATENATE(IF(dms_RPT=\"Calendar\",FRCP_y2+1,(LEFT(FRCP_y2,4)+1&\"-\"&IF(MID(FRCP_y2,6,2)<\"09\",\"0\"&RIGHT(FRCP_y2,1)+1,RIGHT(FRCP_y2,2)+1))))","v":"2019-20"},{"$f":"CONCATENATE(IF(dms_RPT=\"Calendar\",FRCP_y3+1,(LEFT(FRCP_y3,4)+1&\"-\"&IF(MID(FRCP_y3,6,2)<\"09\",\"0\"&RIGHT(FRCP_y3,1)+1,RIGHT(FRCP_y3,2)+1))))","v":"2020-21"},{"$f":"CONCATENATE(IF(dms_RPT=\"Calendar\",FRCP_y4+1,(LEFT(FRCP_y4,4)+1&\"-\"&IF(MID(FRCP_y4,6,2)<\"09\",\"0\"&RIGHT(FRCP_y4,1)+1,RIGHT(FRCP_y4,2)+1))))","v":"2021-22"}]
[]
[]
[null,null,"Current regulatory control period","2012-13",{"$f":"CONCATENATE(IF(dms_RPT=\"Calendar\",CRCP_y1+1,(LEFT(CRCP_y1,4)+1&\"-\"&IF(MID(CRCP_y1,6,2)<\"09\",\"0\"&RIGHT(CRCP_y1,1)+1,RIGHT(CRCP_y1,2)+1))))","v":"2013-14"},{"$f":"CONCATENATE(IF(dms_RPT=\"Calendar\",CRCP_y2+1,(LEFT(CRCP_y2,4)+1&\"-\"&IF(MID(CRCP_y2,6,2)<\"09\",\"0\"&RIGHT(CRCP_y2,1)+1,RIGHT(CRCP_y2,2)+1))))","v":"2014-15"},{"$f":"CONCATENATE(IF(dms_RPT=\"Calendar\",CRCP_y3+1,(LEFT(CRCP_y3,4)+1&\"-\"&IF(MID(CRCP_y3,6,2)<\"09\",\"0\"&RIGHT(CRCP_y3,1)+1,RIGHT(CRCP_y3,2)+1))))","v":"2015-16"},{"$f":"CONCATENATE(IF(dms_RPT=\"Calendar\",CRCP_y4+1,(LEFT(CRCP_y4,4)+1&\"-\"&IF(MID(CRCP_y4,6,2)<\"09\",\"0\"&RIGHT(CRCP_y4,1)+1,RIGHT(CRCP_y4,2)+1))))","v":"2016-17"}]
[]
[]
[null,null,"Previous regulatory control period",{"$f":"CONCATENATE(IF(dms_RPT=\"Calendar\",PRCP_y2-1,(LEFT(PRCP_y2,4)-1&\"-\"&IF(MID(PRCP_y2,3,1)=\"0\",\"0\"&RIGHT(PRCP_y2,2)-1,RIGHT(PRCP_y2,2)-1))))","v":"2007-08"},{"$f":"CONCATENATE(IF(dms_RPT=\"Calendar\",PRCP_y3-1,(LEFT(PRCP_y3,4)-1&\"-\"&IF(MID(PRCP_y3,3,1)=\"0\",\"0\"&RIGHT(PRCP_y3,2)-1,RIGHT(PRCP_y3,2)-1))))","v":"2008-09"},{"$f":"CONCATENATE(IF(dms_RPT=\"Calendar\",PRCP_y4-1,(LEFT(PRCP_y4,4)-1&\"-\"&IF(MID(PRCP_y4,3,1)=\"0\",\"0\"&RIGHT(PRCP_y4,2)-1,RIGHT(PRCP_y4,2)-1))))","v":"2009-10"},{"$f":"CONCATENATE(IF(dms_RPT=\"Calendar\",PRCP_y5-1,(LEFT(PRCP_y5,4)-1&\"-\"&IF(MID(PRCP_y5,3,1)=\"0\",\"0\"&RIGHT(PRCP_y5,2)-1,RIGHT(PRCP_y5,2)-1))))","v":"2010-11"},{"$f":"CONCATENATE(IF(dms_RPT=\"Calendar\",CRCP_y1-1,(LEFT(CRCP_y1,4)-1&\"-\"&IF(MID(CRCP_y1,3,1)=\"0\",\"0\"&RIGHT(CRCP_y1,2)-1,RIGHT(CRCP_y1,2)-1))))","v":"2011-12"}]
[]
[]
["KEEP VISIBLE FOR\nCA & EB ONLY"]
[null,null,"Current regulatory year","2014-15"]
[]
[]
[]
[]
["HIDE",null,"Sector",{"$f":"INDEX(dms_Sector_List,MATCH(dms_TradingName,dms_TradingName_List))","v":"Electricity"}]
[null,null,"Segment",{"$f":"INDEX(dms_Segment_List,MATCH(dms_TradingName,dms_TradingName_List))","v":"Transmission"}]
[null,null,"Source","Revised regulatory proposal"]
[null,null,"Regulatory Year Ending",{"$f":"(LOOKUP(dms_Model,dms_Model_List,dms_RYE_List2))","v":"2022"}]
[null,null,"Reporting Period Type",{"$f":"IF(LEN(CRCP_y1)>4,\"Financial\",\"Calendar\")","v":"Financial"}]
[null,null,"Model or RIN Type","Reset"]
[null,null,"Security Classification","Public"]
[null,null,"Data quality (Public, Consolidated (confidential))","Consolidated"]
[null,null,"EBSS - First application of scheme in forthcoming period?","No"]
[null,null,"Amended RIN submission - amendment reason"]
["HIDE THESE ROWS",null,"Template - version no.",1]
[null,null,"Dollar $ real  (the last month before the FRCP_y1)","March 2017"]
[null,null,"Form of control",{"$f":"INDEX(dms_FormControl_List,MATCH(dms_TradingName,dms_TradingName_List))","v":"Revenue cap"}]
[null,null,"Length of current reg control period",3]
[null,null,"Length of forthcoming reg control period",{"$f":"INDEX(dms_FRCPlength_List,MATCH(dms_TradingName,dms_TradingName_List))","v":5}]
[null,null,"RIN response - version no.",1]
[null,null,"Jurisdiction",{"$f":"INDEX(dms_JurisdictionList,MATCH(dms_TradingName,dms_TradingName_List))","v":"Vic"}]

{"sheet":"2.1 Expenditure summary","index":4,"n_rows":29,"n_cols":9,"rows_kept":29,"cut":false,"hidden":false,"merged":[[20,1,21,1],[8,1,9,1],[8,2,8,8],[20,2,20,3]]}
[null,{"$f":"(LOOKUP(dms_Model,dms_Model_List,dms_Worksheet_List))","v":"REGULATORY REPORTING STATEMENT"}]
[null,{"$f":"dms_TradingName","v":"AusNet (T)"}]
[null,{"$f":"CONCATENATE(FRCP_y1,\" to \",FRCP_y5)","v":"2017-18 to 2021-22"}]
[null,"2.1 Cost summary and reconciliation"]
[]
[]
[null,"Table 2.1.1 - Prescribed transmission services capex (as incurred)"]
[]
[null,null,{"$f":"CONCATENATE(\"Forecast \n($0's. real \",dms_DollarReal,\")\")","v":"Forecast \n($0's. real March 2017)"}]
[null,null,{"$f":"CRCP_y4","v":"2015-16"},{"$f":"CRCP_y5","v":"2016-17"},{"$f":"FRCP_y1","v":"2017-18"},{"$f":"FRCP_y2","v":"2018-19"},{"$f":"FRCP_y3","v":"2019-20"},{"$f":"FRCP_y4","v":"2020-21"},{"$f":"FRCP_y5","v":"2021-22"}]
[null,"Replacement expenditure",null,142038275.85062692,139988702.012045,122597583.13195191,124378803.32783905,111948459.64749987,93551168.295012608]
[null,"Connections"]
[null,"Augmentation Expenditure"]
[null,"Non-network",null,21964156.398800693,28781606.987789974,26578546.684071925,17977706.597446788,15681708.605079565,14933034.008019073]
[null,"capitalised network overheads",null,5703515.5419634404,5871784.9460047372,5943534.8012840915,5914687.1086949958,4663024.7404323621,3926875.2374626994]
[null,"capitalised corporate overheads",null,6178808.5037937285,6361100.3581718011,6438829.3680577669,6407577.7010862464,5051610.1354683936,4254114.840584591]
[null,"balancing item"]
[null,"TOTAL  CAPEX",{"$f":"SUM(C11:C17)","v":0},175884756.29518476,181003194.30401149,161558493.98536569,154678774.7350671,137344803.1284802,116665192.38107897]
[]
[null,"Table 2.1.2 - Prescribed transmission services opex "]
[null,null,{"$f":"CONCATENATE(\"Forecast \n($0's. real \",dms_DollarReal,\")\")","v":"Forecast \n($0's. real March 2017)"}]
[null,null,{"$f":"CRCP_y4","v":"2015-16"},{"$f":"CRCP_y5","v":"2016-17"}]
[null,"Vegetation management",null,6112577.4166777767]
[null,"Maintenance",null,20113449.080933567]
[null,"Non-network",null,22003436.01806049]
[null,"network overheads",null,26922009.541149016]
[null,"corporate overheads",null,134832781.87714234]
[null,"balancing item",null,0]
[null,"TOTAL OPEX",{"$f":"SUM(C23:C28)","v":0},{"$f":"SUM(D23:D28)","v":209984253.93396318}]

{"sheet":"2.2 Repex","index":5,"n_rows":198,"n_cols":24,"rows_kept":198,"cut":false,"hidden":false,"merged":[[7,3,7,9],[7,10,7,16],[7,17,7,23],[6,3,6,9],[6,10,6,16],[6,17,6,23]]}
[null,{"$f":"(LOOKUP(dms_Model,dms_Model_List,dms_Worksheet_List))","v":"REGULATORY REPORTING STATEMENT"}]
[null,{"$f":"dms_TradingName","v":"AusNet (T)"}]
[null,{"$f":"CONCATENATE(FRCP_y1,\" to \",FRCP_y5)","v":"2017-18 to 2021-22"}]
[null,"2.2 REPEX"]
[]
[null,"TABLE 2.2.1 - REPLACEMENT EXPENDITURE, VOLUMES AND ASSET FAILURES BY ASSET CATEGORY"]
[null,null,null,"EXPENDITURE",null,null,null,null,null,null,"ASSET REPLACEMENTS",null,null,null,null,null,null,"ASSET FAILURES"]
[null,null,null,{"$f":"CONCATENATE(\"Forecast \n($0's. real \",dms_DollarReal,\")\")","v":"Forecast \n($0's. real March 2017)"},null,null,null,null,null,null,{"$f":"CONCATENATE(\"Forecast \n($0's. real \",dms_DollarReal,\")\")","v":"Forecast \n($0's. real March 2017)"},null,null,null,null,null,null,{"$f":"CONCATENATE(\"Forecast \n($0's. real \",dms_DollarReal,\")\")","v":"Forecast \n($0's. real March 2017)"}]
[null,"ASSET GROUP","ASSET CATEGORY",{"$f":"CRCP_y4","v":"2015-16"},{"$f":"CRCP_y5","v":"2016-17"},{"$f":"FRCP_y1","v":"2017-18"},{"$f":"FRCP_y2","v":"2018-19"},{"$f":"FRCP_y3","v":"2019-20"},{"$f":"FRCP_y4","v":"2020-21"},{"$f":"FRCP_y5","v":"2021-22"},{"$f":"CRCP_y4","v":"2015-16"},{"$f":"CRCP_y5","v":"2016-17"},{"$f":"FRCP_y1","v":"2017-18"},{"$f":"FRCP_y2","v":"2018-19"},{"$f":"FRCP_y3","v":"2019-20"},{"$f":"FRCP_y4","v":"2020-21"},{"$f":"FRCP_y5","v":"2021-22"},{"$f":"CRCP_y4","v":"2015-16"},{"$f":"CRCP_y5","v":"2016-17"},{"$f":"FRCP_y1","v":"2017-18"},{"$f":"FRCP_y2","v":"2018-19"},{"$f":"FRCP_y3","v":"2019-20"},{"$f":"FRCP_y4","v":"2020-21"},{"$f":"FRCP_y5","v":"2021-22"}]
[null,"TRANSMISSION TOWERS\nHighest operating voltage; Circuit configuration","< = 33 kV; Single Circuit","Refer unprotected sheet"]
[null,null,"> 33 kV & < = 66 kV ; Single Circuit"]
[null,null,"> 66 kV & < = 132 kV ; Single Circuit"]
[null,null,"> 132 kV & < = 275 kV ; Single Circuit"]
[null,null,"> 275 kV & < = 330 kV ; Single Circuit"]
[null,null,"> 330 kV & < = 500 kV  ; Single Circuit"]
[null,null,"> 500 kV  ; Single Circuit"]
[null,null,"< = 33 kV; Multiple Circuit"]
[null,null,"> 33 kV & < = 66 kV ; Multiple Circuit"]
[null,null,"> 66 kV & < = 132 kV ; Multiple Circuit"]
[null,null,"> 132 kV & < = 275 kV ; Multiple Circuit"]
[null,null,"> 275 kV & < = 330 kV ; Multiple Circuit"]
[null,null,"> 330 kV & < = 500 kV  ; Multiple Circuit"]
[null,null,"> 500 kV  ; Multiple Circuit"]
[null,null,"Other"]
[null,"TRANSMISSION TOWER SUPPORT STRUCTURES BY:\nHighest operating voltage; Circuit configuration","< = 33 kV; Single Circuit"]
[null,null,"> 33 kV & < = 66 kV ; Single Circuit"]
[null,null,"> 66 kV & < = 132 kV ; Single Circuit"]
[null,null,"> 132 kV & < = 275 kV ; Single Circuit"]
[null,null,"> 275 kV & < = 330 kV ; Single Circuit"]
[null,null,"> 330 kV & < = 500 kV  ; Single Circuit"]
[null,null,"> 500 kV  ; Single Circuit"]
[null,null,"< = 33 kV; Multiple Circuit"]
[null,null,"> 33 kV & < = 66 kV ; Multiple Circuit"]
[null,null,"> 66 kV & < = 132 kV ; Multiple Circuit"]
[null,null,"> 132 kV & < = 275 kV ; Multiple Circuit"]
[null,null,"> 275 kV & < = 330 kV ; Multiple Circuit"]
[null,null,"> 330 kV & < = 500 kV  ; Multiple Circuit"]
[null,null,"> 500 kV  ; Multiple Circuit"]
[null,null,"Other"]
[null,"CONDUCTORS BY: \nVoltage; Maximum continuous rating","< = 33 kV ; < = 100 MVA"]
[null,null,"< = 33 kV ; > 100 MVA & < = 400 MVA"]
[null,null,"< = 33 kV ; > 400 MVA"]
[null,null,"> 33 kV & < = 66 kV  ; < = 100 MVA"]
[null,null,"> 33 kV & < = 66 kV  ; > 100 MVA & < = 400 MVA"]
[null,null,"> 33 kV & < = 66 kV  ; > 400 MVA"]
[null,null,"> 66 kV & < = 132 kV  ; < = 100 MVA"]
[null,null,"> 66 kV & < = 132 kV  ; > 100 MVA & < = 400 MVA"]
[null,null,"> 66 kV & < = 132 kV  ; > 400 MVA"]
[null,null,"> 132 kV & < = 275 kV  ; < = 200 MVA"]
[null,null,"> 132 kV & < = 275 kV  ; > 200 MVA & < = 600 MVA"]
[null,null,"> 132 kV & < = 275 kV  ; > 600 MVA"]
[null,null,"> 275 kV & < = 330 kV  ; < = 800 MVA"]
[null,null,"> 275 kV & < = 330 kV  ; > 800 MVA & < = 1200 MVA"]
[null,null,"> 275 kV & < = 330 kV  ; > 1200 MVA"]
[null,null,"> 330 kV & < = 500 kV   ; < = 1000 MVA"]
[null,null,"> 330 kV & < = 500 kV   ; > 1000 MVA & < = 1500 MVA"]
[null,null,"> 330 kV & < = 500 kV   ; > 1500 MVA"]
[null,null,"> 500 kV   ; < = 2000 MVA"]
[null,null,"> 500 kV   ; > 2000 MVA & < = 3000 MVA"]
[null,null,"> 500 kV   ; > 3000 MVA"]
[null,null,"Other"]
[null,"TRANSMISSION CABLES BY: \nHighest operating voltage; Insulation type","< = 33 kV; Oil Filled"]
[null,null,"> 33 kV & < = 66 kV ; Oil Filled"]
[null,null,"> 66 kV & < = 132 kV ; Oil Filled"]
[null,null,"> 132 kV & < = 275 kV ; Oil Filled"]
[null,null,"> 275 kV & < = 330 kV ; Oil Filled"]
[null,null,"> 330 kV & < = 500 kV  ; Oil Filled"]
[null,null,"> 500 kV  ; Oil Filled"]
[null,null,"< = 33 kV; XLPE Insulated"]
[null,null,"> 33 kV & < = 66 kV ; XLPE Insulated"]
[null,null,"> 66 kV & < = 132 kV ; XLPE Insulated"]
[null,null,"> 132 kV & < = 275 kV ; XLPE Insulated"]
[null,null,"> 275 kV & < = 330 kV ; XLPE Insulated"]
[null,null,"> 330 kV & < = 500 kV  ; XLPE Insulated"]
[null,null,"> 500 kV  ; XLPE Insulated"]
[null,null,"< = 33 kV; Other Insulated"]
[null,null,"> 33 kV & < = 66 kV ; Other Insulated"]
[null,null,"> 66 kV & < = 132 kV ; Other Insulated"]
[null,null,"> 132 kV & < = 275 kV ; Other Insulated"]
[null,null,"> 275 kV & < = 330 kV ; Other Insulated"]
[null,null,"> 330 kV & < = 500 kV  ; Other Insulated"]
[null,null,"> 500 kV  ; Other Insulated"]
[null,null,"Other"]
[null,"SUBSTATION SWITCHBAYS BY: \nHighest operating voltage; Switch type","< = 33 kV; Air Insulated circuit Breaker"]
[null,null,"> 33 kV & < = 66 kV ; Air Insulated circuit Breaker"]
[null,null,"> 66 kV & < = 132 kV ; Air Insulated circuit Breaker"]
[null,null,"> 132 kV & < = 275 kV ; Air Insulated circuit Breaker"]
[null,null,"> 275 kV & < = 330 kV ; Air Insulated circuit Breaker"]
[null,null,"> 330 kV & < = 500 kV  ; Air Insulated circuit Breaker"]
[null,null,"> 500 kV  ; Air Insulated circuit Breaker"]
[null,null,"< = 33 kV; Air Insulated Isolators / Earth Switch"]
[null,null,"> 33 kV & < = 66 kV ; Air Insulated Isolators / Earth Switch"]
[null,null,"> 66 kV & < = 132 kV ; Air Insulated Isolators / Earth Switch"]
[null,null,"> 132 kV & < = 275 kV ; Air Insulated Isolators / Earth Switch"]
[null,null,"> 275 kV & < = 330 kV ; Air Insulated Isolators / Earth Switch"]
[null,null,"> 330 kV & < = 500 kV  ; Air Insulated Isolators / Earth Switch"]
[null,null,"> 500 kV  ; Air Insulated Isolators / Earth Switch"]
[null,null,"< = 33 kV; VT"]
[null,null,"> 33 kV & < = 66 kV ; VT"]
[null,null,"> 66 kV & < = 132 kV ; VT"]
[null,null,"> 132 kV & < = 275 kV ; VT"]
[null,null,"> 275 kV & < = 330 kV ; VT"]
[null,null,"> 330 kV & < = 500 kV  ; VT"]
[null,null,"> 500 kV  ; VT"]
[null,null,"< = 33 kV; CT"]
[null,null,"> 33 kV & < = 66 kV ; CT"]
[null,null,"> 66 kV & < = 132 kV ; CT"]
[null,null,"> 132 kV & < = 275 kV ; CT"]
[null,null,"> 275 kV & < = 330 kV ; CT"]
[null,null,"> 330 kV & < = 500 kV  ; CT"]
[null,null,"> 500 kV  ; CT"]
[null,null,"< = 33 kV; GIS Module"]
[null,null,"> 33 kV & < = 66 kV ; GIS Module"]
[null,null,"> 66 kV & < = 132 kV ; GIS Module"]
[null,null,"> 132 kV & < = 275 kV ; GIS Module"]
[null,null,"> 275 kV & < = 330 kV ; GIS Module"]
[null,null,"> 330 kV & < = 500 kV  ; GIS Module"]
[null,null,"> 500 kV  ; GIS Module"]
[null,null,"Other"]
[null,"SUBSTATION POWER TRANSFORMERS BY: \nHighest operating voltage;  Ampere rating","< = 33 kV ; < = 10 MVA"]
[null,null,"< = 33 kV ; > 10 MVA & < =  30 MVA"]
[null,null,"< = 33 kV ; > 30 MVA"]
[null,null,"> 33 kV & < = 66 kV  ; < = 10 MVA"]
[null,null,"> 33 kV & < = 66 kV  ; > 10 MVA & < =  30 MVA"]
[null,null,"> 33 kV & < = 66 kV  ; > 30 MVA"]
[null,null,"> 66 kV & < = 132 kV  ; < = 30 MVA"]
[null,null,"> 66 kV & < = 132 kV  ; > 30 MVA & < =  60 MVA"]
[null,null,"> 66 kV & < = 132 kV  ; > 60 MVA"]
[null,null,"> 132 kV & < = 220 kV  ; < = 50 MVA"]
[null,null,"> 132 kV & < = 220 kV  ; > 50 MVA & < =  100 MVA"]
[null,null,"> 132 kV & < = 220 kV  ; > 100 MVA"]
[null,null,"> 220 kV & < = 275 kV  ; < = 50 MVA"]
[null,null,"> 220 kV & < = 275 kV  ; > 50 MVA & < =  100 MVA"]
[null,null,"> 220 kV & < = 275 kV  ; > 100 MVA"]
[null,null,"> 275 kV & < = 330 kV  ; < = 100 MVA"]
[null,null,"> 275 kV & < = 330 kV  ; > 100 MVA & < =  250 MVA"]
[null,null,"> 275 kV & < = 330 kV  ; > 250 MVA"]
[null,null,"> 330 kV & < = 500 kV   ; < = 150 MVA"]
[null,null,"> 330 kV & < = 500 kV   ; > 150 MVA & < =  300 MVA"]
[null,null,"> 330 kV & < = 500 kV   ; > 300 MVA"]
[null,null,"> 500 kV   ; < = 1000 MVA"]
[null,null,"> 500 kV   ; > 1000 MVA & < =  1500 MVA"]
[null,null,"> 500 kV   ; > 1500 MVA"]
[null,null,"Other"]
[null,"SUBSTATION REACTIVE PLANT BY: \nHighest operating voltage; Function","< = 33 kV;  SVCS"]
[null,null,"> 33 kV & < = 66 kV ;  SVCS"]
[null,null,"> 66 kV & < = 132 kV ;  SVCS"]
[null,null,"> 132 kV & < = 275 kV ;  SVCS"]
[null,null,"> 275 kV & < = 330 kV ;  SVCS"]
[null,null,"> 330 kV & < = 500 kV  ;  SVCS"]
[null,null,"> 500 kV  ;  SVCS"]
[null,null,"< = 33 kV;  Capacitors"]
[null,null,"> 33 kV & < = 66 kV ;  Capacitors"]
[null,null,"> 66 kV & < = 132 kV ;  Capacitors"]
[null,null,"> 132 kV & < = 275 kV ;  Capacitors"]
[null,null,"> 275 kV & < = 330 kV ;  Capacitors"]
[null,null,"> 330 kV & < = 500 kV  ;  Capacitors"]
[null,null,"> 500 kV  ;  Capacitors"]
[null,null,"< = 33 kV;  Oil Filled Reactors"]
[null,null,"> 33 kV & < = 66 kV ;  Oil Filled Reactors"]
[null,null,"> 66 kV & < = 132 kV ;  Oil Filled Reactors"]
[null,null,"> 132 kV & < = 275 kV ;  Oil Filled Reactors"]
[null,null,"> 275 kV & < = 330 kV ;  Oil Filled Reactors"]
[null,null,"> 330 kV & < = 500 kV  ;  Oil Filled Reactors"]
[null,null,"> 500 kV  ;  Oil Filled Reactors"]
[null,null,"Other"]
[null,"SCADA, NETWORK CONTROL AND PROTECTION SYSTEMS BY:\nFunction","Communications Network Assets"]
[null,null,"Control equipment / systems"]
[null,null,"Infrastructure: protection and control"]
[null,null,"Metering systems"]
[null,null,"Protection schemes / systems"]
[null,null,"Station SCADA and control systems"]
[null,"OTHER BY: \nNSP defined","Other - Secondary"]
[null,null,"Power transformers - Bushings replacement"]
[null,null,"Power transformers - life extension"]
[null,null,"Power transformers - improved safe access"]
[null,null,"On-line monitoring"]
[null,null,"Fire protection systems"]
[null,null,"Civil Infrastructure"]
[null,null,"Infrastructure security"]
[null,null,"Structure fall arrests (Stations)"]
[null,null,"Earth wires (incl. OPGW)"]
[null,null,"Insulators"]
[null,null,"Tower fall arrests"]
[null,null,"XC17 -FBTS Refurbishment - Other"]
[null,null,"XC28 - HWPS 220kV Switchyard Redevelopment Stage 4 - Other"]
[null,null,"XA09 - RTS Redevelopment - Other"]
[null,null,"XB59 - HTS Rebuild - Other"]
[null,null,"XC19 - SMTS H2 Transformer Replacement - Other"]
[null,null,"XC16 - TTS Bus Tie CB Replacement - Other"]
[null,null,"XC18 - YPS 220kV CB Replacement - Other"]
[null,null,"XC21 - RWTS B4 220/66kV Transformer and 66kV CB Replacement - Other"]
[null,null,"XC15 - TSTS B2 Transformer and 66kV CB Replacement - Other"]
[null,null,"XB61 - SVTS Redevelopment Stage 1 - Other"]
[null,null,"XA14 - WMTS Redevelopment - Other"]
[null,null,"284A - HYTS 500kV and 275kV CB Replacement - Other"]
[null,null,"285A - FBTS Transformer and Circuit Breaker Replacement - Other"]
[null,null,"Other Ongoing Projects / Works"]

{"sheet":"2.6 Non-network","index":6,"n_rows":52,"n_cols":23,"rows_kept":52,"cut":false,"hidden":false,"merged":[[22,16,22,22],[8,16,8,22],[8,4,8,10],[22,12,23,12],[22,13,23,14],[22,15,23,15],[8,12,9,12],[8,13,9,15]]}
[null,{"$f":"(LOOKUP(dms_Model,dms_Model_List,dms_Worksheet_List))","v":"REGULATORY REPORTING STATEMENT"}]
[null,{"$f":"dms_TradingName","v":"AusNet (T)"}]
[null,{"$f":"CONCATENATE(FRCP_y1,\" to \",FRCP_y5)","v":"2017-18 to 2021-22"}]
[null,"2.6 NON NETWORK EXPENDITURE"]
[]
[]
[]
[null,"2.6.1 NON-NETWORK EXPENDITURE",null,null,null,null,null,null,null,null,null,null,"TABLE 2.6.2 ANNUAL DESCRIPTOR METRICS - IT & COMMUNICATIONS EXPENDITURE"]
[null,null,null,null,{"$f":"CONCATENATE(\"EXPENDITURE\nForecast \n($0's. real \",dms_DollarReal,\")\")","v":"EXPENDITURE\nForecast \n($0's. real March 2017)"},null,null,null,null,null,null,null,"NON-NETWORK CATEGORY","DESCRIPTOR METRIC",null,null,"VOLUMES  (0's)"]
[null,"SERVICE SUBCATEGORY","ASSET CATEGORY","ASSET REPORTING CATEGORY",{"$f":"CRCP_y4","v":"2015-16"},{"$f":"CRCP_y5","v":"2016-17"},{"$f":"FRCP_y1","v":"2017-18"},{"$f":"FRCP_y2","v":"2018-19"},{"$f":"FRCP_y3","v":"2019-20"},{"$f":"FRCP_y4","v":"2020-21"},{"$f":"FRCP_y5","v":"2021-22"},null,null,null,null,null,{"$f":"CRCP_y4","v":"2015-16"},{"$f":"CRCP_y5","v":"2016-17"},{"$f":"FRCP_y1","v":"2017-18"},{"$f":"FRCP_y2","v":"2018-19"},{"$f":"FRCP_y3","v":"2019-20"},{"$f":"FRCP_y4","v":"2020-21"},{"$f":"FRCP_y5","v":"2021-22"}]
[null,"IT & COMMUNICATIONS","Client device expenditure","Opex ",null,0,0,0,0,0,0,null,"IT & COMMUNICATIONS","Employee numbers",null,null,null,452.65291198979452,452.65291198979452,452.65291198979452,452.65291198979452,452.65291198979452,452.65291198979452]
[null,null,null,"Capex ",null,0,950416.47055390722,560772.96586928144,0,0,91610.832638816442,null,null,"User numbers",null,null,null,745.74497601905875,745.74497601905875,745.74497601905875,745.74497601905875,745.74497601905875,745.74497601905875]
[null,null,"Recurrent expenditure","Opex ",null,11975959.934262713,12020990.734881211,12095454.15417615,12184681.896578724,12277752.945529804,12370668.860329315,null,null,"Number of devices",null,null,null,895.49296317148014,895.49296317148014,895.49296317148014,895.49296317148014,895.49296317148014,895.49296317148014]
[null,null,null,"Capex ",null,15619197.785771467,13543434.705393177,17448666.514932644,8489420.8557768892,4625215.0284553086,5954704.1215230692]
[null,null,"Non-recurrent expenditure","Opex ",null,1916983.0743591613,1924608.8330289621,1937218.8701029676,1952329.1772897705,1968090.3307380308,1983825.2129322814]
[null,null,null,"Capex ",null,2333903.1174141276,9266560.5879005957,3558751.5141704404,4373338.016612336,6131098.9912081985,3114768.309719759]
[null,"MOTOR VEHICLES","Car","Opex ",null,456048.75488886941,457862.91683581733,460862.83466692554,464457.56477732753,468207.13069777493,471950.44670770364]
[null,null,null,"Capex ",null,223364.64955168171,476616.60907225055,376273.54868254007,521985.42530428374,441185.18463169516,444105.01322199887]
[null,null,"Light commercial vehicle","Opex ",null,828029.12490478612,831323.02476365736,836769.85322190868,843296.65807703952,850104.5919976955,856901.17821071716]
[null,null,null,"Capex ",null,670093.94865504513,1429849.8272167516,1128820.6460476203,1565956.2759128511,1323555.5538950856,1332315.0396659966]
[null,null,"Elevated work platform (LCV)  ","Opex ",null,0,0,0,0,0,0,null,"TABLE 2.6.3 ANNUAL DESCRIPTOR METRICS - MOTOR VEHICLES"]
[null,null,null,"Capex ",null,0,0,0,0,0,0]
[null,null,"Elevated work platform (HCV)","Opex ",null,0,0,0,0,0,0,null,"NON-NETWORK CATEGORY","DESCRIPTOR METRIC",null,"Unit of Measure","VOLUMES  (0's or %)"]
[null,null,null,"Capex ",null,0,0,0,0,0,0,null,null,null,null,null,{"$f":"CRCP_y4","v":"2015-16"},{"$f":"CRCP_y5","v":"2016-17"},{"$f":"FRCP_y1","v":"2017-18"},{"$f":"FRCP_y2","v":"2018-19"},{"$f":"FRCP_y3","v":"2019-20"},{"$f":"FRCP_y4","v":"2020-21"},{"$f":"FRCP_y5","v":"2021-22"}]
[null,null,"Heavy commercial vehicle","Opex ",null,116260.46959603768,116722.95374409073,117487.72253702198,118404.12677281075,119360.00328824765,120314.28651453721,null,"MOTOR VEHICLES","CAR","Average kilometres travelled ","0's",null,19102.910121897832,19102.910121897832,19102.910121897832,19102.910121897832,19102.910121897832,19102.910121897832]
[null,null,null,"Capex ",null,0,0,0,0,0,0,null,null,null,"Number purchased","0's",null,6.6033466587991523,14.090254207021326,11.123804440292393,15.431496080705331,13.04279222650815,13.129111348198832]
[null,"BUILDINGS AND PROPERTY","Total buildings and property expenditure","Opex ",null,6710154.6600489244,6736847.655286599,6780987.481124036,6833879.1834768029,6889049.0901250113,6944127.037600561,null,null,null,"Number leased","0's",null,6.4738398578770422,6.4738398578770422,6.4738398578770422,6.4738398578770422,6.4738398578770422,6.4738398578770422]
[null,null,null,"Capex ",null,530035.46210632171,217398.94721276558,590336.44405877846,94772.96176027559,209512.3515544468,1024858.1064486158,null,null,null,"Number in fleet","0's",null,55.877652737745734,55.877652737745734,55.877652737745734,55.877652737745734,55.877652737745734,55.877652737745734]
[null,"OTHER","Other expenditure","Opex ",null,0,0,0,0,0,0,null,null,null,"Proportion of total fleet expenditure allocated as regulatory expenditure","%",null,0.92285946295334254,0.92285946295334254,0.92285946295334254,0.92285946295334254,0.92285946295334254,0.92285946295334254]
[null,null,null,"Capex ",null,970335.53823826928,362166.23005506536,364365.6312888274,366529.13276001858,368892.68691685377,371334.07310010213,null,null,"LIGHT COMMERCIAL VEHICLE","Average kilometres travelled ","0's",null,25144.463541297544,25144.463541297544,25144.463541297544,25144.463541297544,25144.463541297544,25144.463541297544]
[null,"OTHER - TNSP nominated","Tools & Equipment","Opex ",null,0,0,0,0,0,0,null,null,null,"Number purchased","0's",null,12.91930362739053,27.5672748522231,21.763480623018971,30.191385307003465,25.517938347018561,25.686819824789467]
[null,null,null,"Capex ",null,1617225.897063782,2535163.6103854566,2550559.4190217936,2565703.9293201314,2582248.808417975,2599338.5117007145,null,null,null,"Number leased","0's",null,25.509759818208124,25.509759818208124,25.509759818208124,25.509759818208124,25.509759818208124,25.509759818208124]
[null,null,null,"Opex ",null,null,null,null,null,null,null,null,null,null,"Number in fleet","0's",null,77.926204667048182,77.926204667048182,77.926204667048182,77.926204667048182,77.926204667048182,77.926204667048182]
[null,null,null,"Capex ",null,null,null,null,null,null,null,null,null,null,"Proportion of total fleet expenditure allocated as regulatory expenditure","%",null,0.92285946295334254,0.92285946295334254,0.92285946295334254,0.92285946295334254,0.92285946295334254,0.92285946295334254]
[null,null,null,"Opex ",null,null,null,null,null,null,null,null,null,"ELEVATED WORK PLATFORM (LCV) ","Average kilometres travelled ","0's"]
[null,null,null,"Capex ",null,null,null,null,null,null,null,null,null,null,"Number purchased","0's"]
[null,null,null,"Opex ",null,null,null,null,null,null,null,null,null,null,"Number leased","0's"]
[null,null,null,"Capex ",null,null,null,null,null,null,null,null,null,null,"Number in fleet","0's"]
[null,null,null,"Opex ",null,null,null,null,null,null,null,null,null,null,"Proportion of total fleet expenditure allocated as regulatory expenditure","%"]
[null,null,null,"Capex ",null,null,null,null,null,null,null,null,null,"ELEVATED WORK PLATFORM (HCV)","Average kilometres travelled ","0's"]
[null,null,null,"Opex ",null,null,null,null,null,null,null,null,null,null,"Number purchased","0's"]
[null,null,null,"Capex ",null,null,null,null,null,null,null,null,null,null,"Number leased","0's"]
[null,null,null,"Opex ",null,null,null,null,null,null,null,null,null,null,"Number in fleet","0's"]
[null,null,null,"Capex ",null,null,null,null,null,null,null,null,null,null,"Proportion of total fleet expenditure allocated as regulatory expenditure","%"]
[null,null,null,"Opex ",null,null,null,null,null,null,null,null,null,"HEAVY COMMERCIAL VEHICLE ","Average kilometres travelled ","0's",null,10364.208005373855,10364.208005373855,10364.208005373855,10364.208005373855,10364.208005373855,10364.208005373855]
[null,null,null,"Capex ",null,null,null,null,null,null,null,null,null,null,"Number purchased","0's"]
[null,null,null,"Opex ",null,null,null,null,null,null,null,null,null,null,"Number leased","0's",null,0.95285946295334245,0.95285946295334245,0.95285946295334245,0.95285946295334245,0.95285946295334245,0.95285946295334245]
[null,null,null,"Capex ",null,null,null,null,null,null,null,null,null,null,"Number in fleet","0's",null,8.2424018332467472,8.2424018332467472,8.2424018332467472,8.2424018332467472,8.2424018332467472,8.2424018332467472]
[null,null,null,"Opex ",null,null,null,null,null,null,null,null,null,null,"Proportion of total fleet expenditure allocated as regulatory expenditure","%",null,0.92285946295334254,0.92285946295334254,0.92285946295334254,0.92285946295334254,0.92285946295334254,0.92285946295334254]
[null,null,null,"Capex "]
[null,null,null,"Opex "]
[null,null,null,"Capex "]

{"sheet":"2.10 Overheads","index":7,"n_rows":121,"n_cols":11,"rows_kept":121,"cut":false,"hidden":false,"merged":[[8,4,8,10],[92,4,92,10],[94,2,118,2],[94,1,120,1],[10,1,36,1],[37,1,59,1],[60,1,87,1],[60,2,85,2],[37,2,57,2],[10,2,34,2],[198,60,198,61],[198,11,198,14],[198,15,198,16],[198,19,198,23],[198,24,198,25],[198,28,198,32],[198,33,198,34],[198,37,198,41],[198,42,198,43],[198,46,198,50],[198,51,198,52],[198,55,198,59],[195,11,195,17],[195,19,195,26],[195,28,195,35],[195,37,195,44],[195,46,195,53],[195,55,195,62],[167,64,167,68],[167,69,167,70],[167,71,167,72],[167,75,167,79],[167,80,167,81],[167,82,167,83],[167,42,167,46],[167,47,167,48],[167,49,167,50],[167,53,167,57],[167,58,167,59],[167,60,167,61],[167,38,167,39],[165,20,165,29],[165,31,165,40],[165,42,165,51],[165,53,165,62],[167,20,167,24],[167,25,167,26],[167,27,167,28],[167,31,167,35],[167,36,167,37],[165,64,165,73],[165,75,165,84],[6,20,6,29],[6,31,6,40],[6,42,6,51],[6,53,6,62],[6,64,6,73],[6,75,6,84]]}
[null,{"$f":"(LOOKUP(dms_Model,dms_Model_List,dms_Worksheet_List))","v":"REGULATORY REPORTING STATEMENT"}]
[null,{"$f":"dms_TradingName","v":"AusNet (T)"}]
[null,{"$f":"CONCATENATE(FRCP_y1,\" to \",FRCP_y5)","v":"2017-18 to 2021-22"}]
[null,"2.10 OVERHEADS"]
[]
[]
[]
[null,"TABLE 2.10.1 - NETWORK OVERHEADS EXPENDITURE"]
[null,null,null,null,{"$f":"CONCATENATE(\"EXPENDITURE\nForecast \n($0's. real \",dms_DollarReal,\")\")","v":"EXPENDITURE\nForecast \n($0's. real March 2017)"}]
[null,null,null,null,{"$f":"CRCP_y4","v":"2015-16"},{"$f":"CRCP_y5","v":"2016-17"},{"$f":"FRCP_y1","v":"2017-18"},{"$f":"FRCP_y2","v":"2018-19"},{"$f":"FRCP_y3","v":"2019-20"},{"$f":"FRCP_y4","v":"2020-21"},{"$f":"FRCP_y5","v":"2021-22"}]
[null,"MAINTENANCE SUPPORT","Total Overhead Expenditure - Prescribed Services","NSP to enter expenditure categories currently reported under annual Information Guidelines"]
[null,null,null,"MAINTENANCE",null,2958085.6453694738,3016293.1913964557,3046671.6009663739,3046444.5222254349,2656526.156557491,2431040.7901187232]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Total Overhead Expenditure - Negotiated Services","Total"]
[null,null,"Total Overhead Expenditure - Unregulated Services","Total"]
[null," NETWORK MONITORING & CONTROL","Total Overhead Expenditure - Prescribed Services","NSP to enter expenditure categories currently reported under annual Information Guidelines"]
[null,null,null,"OPERATIONS",null,7980726.9209693233,8040134.608311859,8099136.3751250114,8148020.2586835558,7966911.0151465926,7883654.6954165008]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Total Overhead Expenditure - Negotiated Services","Total"]
[null,null,"Total Overhead Expenditure - Unregulated Services","Total"]
[null,"ASSET MANAGEMENT SUPPORT","Total Overhead Expenditure - Prescribed Services","NSP to enter expenditure categories currently reported under annual Information Guidelines"]
[null,null,null,"    ASSET MANAGEMENT SUPPORT",null,15825469.98230524,15959175.980033519,16079913.570326878,16168786.165852416,15667802.720845858,15417179.636115082]
[null,null,null,"    ASSET WORKS PROGRAM",null,5861242.5344684217,5885286.4613666134,5924013.2478630524,5969844.5148761878,6011542.0114583289,6055737.1379110906]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Total Overhead Expenditure - Negotiated Services","Total"]
[null,null,"Total Overhead Expenditure - Unregulated Services","Total"]
[]
[]
[]
[null,"TABLE 2.10.2 - CORPORATE OVERHEADS EXPENDITURE"]
[null,null,null,null,{"$f":"CONCATENATE(\"EXPENDITURE\nForecast \n($0's. real \",dms_DollarReal,\")\")","v":"EXPENDITURE\nForecast \n($0's. real March 2017)"}]
[null,null,null,null,{"$f":"CRCP_y4","v":"2015-16"},{"$f":"CRCP_y5","v":"2016-17"},{"$f":"FRCP_y1","v":"2017-18"},{"$f":"FRCP_y2","v":"2018-19"},{"$f":"FRCP_y3","v":"2019-20"},{"$f":"FRCP_y4","v":"2020-21"},{"$f":"FRCP_y5","v":"2021-22"}]
[null,"CORPORATE OVERHEADS","Total Overhead Expenditure - Prescribed Services","<Enter description of expenditure category >",null,3894825.7998085637,3398320.327660732,3567431.4000875996,4152169.7452951842,4322466.5855824854,4459908.1295010773]
[null,null,null,null,null,3675136.9681985793,3206637.0379338996,3366209.3489826345,3917965.350316836,4078656.5456298674,4208345.6575399125]
[null,null,null,null,null,1829721.0984883108,2717257.6264139619,2718608.2387130167,2701479.8374731522,2694767.809748597,2684237.5817454439]
[null,null,null,null,null,930513.28549378703,937526.83098063082,944426.57946433953,950082.14152727148,928190.53990744811,918015.88199775387]
[null,null,null,null,null,5864808.9515870595,5896813.3520747218,5937432.0825761715,5979262.9533379357,5950110.2664383035,5951597.8375330493]
[null,null,null,null,null,4613938.0442692833,4644278.4439247856,4677447.6383951604,4707739.6652354226,4638760.3560825652,4612168.1433677627]
[null,null,null,null,null,1680635.9130318942,1730219.2974227301,1751361.5881117128,1742861.1346954592,1374037.9568474032,1157119.2366390089]
[null,null,null,null,null,4207755.2642497728,4315336.1458813483,4364375.6505845552,4351488.4478987092,3575785.1524689319,3121752.9940428021]
[null,null,null,null,null,0,0,0,0,0,0]
[null,null,null,null,null,114314255.05580883,114314255.05580884,114314255.05580884,114314255.05580884,114314255.05580884,114314255.05580884]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Total Overhead Expenditure - Negotiated Services","Total"]
[null,null,"Total Overhead Expenditure - Unregulated Services","Total"]

{"sheet":"2.14 Forecast price changes","index":8,"n_rows":61,"n_cols":12,"rows_kept":61,"cut":false,"hidden":false,"merged":[[6,1,6,11],[10,1,12,1],[10,2,10,6],[10,7,10,11],[11,2,11,4],[11,5,11,11]]}
[null,{"$f":"(LOOKUP(dms_Model,dms_Model_List,dms_Worksheet_List))","v":"REGULATORY REPORTING STATEMENT"}]
[null,{"$f":"dms_TradingName","v":"AusNet (T)"}]
[null,{"$f":"CONCATENATE(FRCP_y1,\" to \",FRCP_y5)","v":"2017-18 to 2021-22"}]
[null,"2.14 FORECAST PRICE CHANGES"]
[]
[null,"Instructions"]
[null,"The TNSP must provide all forecast price changes used to forecast opex and capex, including forecast changes in CPI. Forecast price changes must be expressed in real terms, except for CPI. If the same escalators are not used for capex and opex, report capex and opex escalators separately. If price changes for a given year were not used to forecast either opex or capex enter '0' for that year. "]
[]
[null,"Table 2.14.1 - Forecast labour and materials price changes"]
[]
[null,null,"Price changes\n(% YoY real)",null,null,null,null,"Price changes\n(%YoY real)"]
[null,null,"Actual",null,null,"Forecast "]
[null,null,{"$f":"CRCP_y1","v":"2012-13"},{"$f":"CRCP_y2","v":"2013-14"},{"$f":"CRCP_y3","v":"2014-15"},{"$f":"CRCP_y4","v":"2015-16"},{"$f":"CRCP_y5","v":"2016-17"},{"$f":"FRCP_y1","v":"2017-18"},{"$f":"FRCP_y2","v":"2018-19"},{"$f":"FRCP_y3","v":"2019-20"},{"$f":"FRCP_y4","v":"2020-21"},{"$f":"FRCP_y5","v":"2021-22"}]
[null,"Materials price changes"]
[null,"Aluminium",-0.1375882661848099,4.1350152537396934E-2,0.21243583535131583,0,0,0,0,0,0,0]
[null,"Copper",-0.16551921577917139,-1.5358971686970091E-2,9.0934706499892215E-2,0,0,0,0,0,0,0]
[null,"Steel",-0.61434452456855626,1.1729977543571866,-7.7420378194267392E-2,0,0,0,0,0,0,0]
[null,"Oil",-0.16698403248956162,2.3890731779737662E-2,-0.45490186264941646,0,0,0,0,0,0,0]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Labour and Other price changes"]
[null,"Internal labour",1.6214371219757995E-2,1.2965742384362544E-2,3.1301498127340954E-2,1.7500000000000002E-2,9.5999999999999992E-3,5.1000000000000004E-3,8.4000000000000012E-3,0.01,1.0350000000000002E-2,1.0249999999999999E-2]
[null,"External labour",5.3813195353402676E-3,1.2668966414786986E-2,1.334745053654518E-2,1.7500000000000002E-2,9.5999999999999992E-3,5.1000000000000004E-3,8.4000000000000012E-3,0.01,1.0350000000000002E-2,1.0249999999999999E-2]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"CPI",2.5025025025025016E-2,2.9296875E-2,1.3282732447817747E-2,1.3108614232209881E-2,2.0205637707948254E-2,1.6500000000000001E-2,1.6500000000000001E-2,1.6500000000000001E-2,1.6500000000000001E-2,1.6500000000000001E-2]

{"sheet":"2.16 Opex Summary","index":9,"n_rows":20,"n_cols":18,"rows_kept":20,"cut":false,"hidden":false,"merged":[[6,1,6,5],[9,1,10,1],[9,2,9,8],[9,10,10,10],[9,11,9,17]]}
[null,{"$f":"(LOOKUP(dms_Model,dms_Model_List,dms_Worksheet_List))","v":"REGULATORY REPORTING STATEMENT"}]
[null,{"$f":"dms_TradingName","v":"AusNet (T)"}]
[null,{"$f":"CONCATENATE(FRCP_y1,\" to \",FRCP_y5)","v":"2017-18 to 2021-22"}]
[null,"2.16 Opex Summary"]
[]
[null,"Instructions"]
[null,"Complete the tables below in accordance with the regulatory information notice.\nThe TNSP must input forecast opex by category in Table 2.16.2 and Table 2.16.4 if it did not forecast its total opex using a Base Year approach. Otherwise input '0'.\n\nThe TNSP's total forecast opex must reconcile to Table 2.16.1 (and if the TNSP owns any dual function assets Table 2.16.3). If the TNSP did not forecast its total opex using a Base Year approach, total forecast opex must, in addition, reconcile to Table 2.16.2 (and if the TNSP owns any dual function assets Table 2.16.4).\n\nIf the TNSP does not own any dual function assets,Table 2.16.3 and 2.16.4 may be left blank.\n\nThe total step changes in Table 2.16.1 and Table 2.16.3 must reconcile (in each year) to the total step changes for each year in Table 2.17.1 and Table 2.17.3 of worksheet 2.17 Step Changes, respectively."]
[]
[null,"Table 2.16.1 - Prescribed services - opex by driver",null,null,null,null,null,null,null,null,"Table 2.16.2 - Prescribed services - opex by category"]
[null,null,{"$f":"CONCATENATE(\"Forecast ($0's, real \", dms_DollarReal, \")\")","v":"Forecast ($0's, real March 2017)"},null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Forecast ($0's, real \", dms_DollarReal, \")\")","v":"Forecast ($0's, real March 2017)"}]
[null,null,{"$f":"CRCP_y4","v":"2015-16"},{"$f":"FRCP_y1","v":"2017-18"},{"$f":"FRCP_y1","v":"2017-18"},{"$f":"FRCP_y2","v":"2018-19"},{"$f":"FRCP_y3","v":"2019-20"},{"$f":"FRCP_y4","v":"2020-21"},{"$f":"FRCP_y5","v":"2021-22"},null,null,{"$f":"CRCP_y4","v":"2015-16"},{"$f":"FRCP_y1","v":"2017-18"},{"$f":"FRCP_y1","v":"2017-18"},{"$f":"FRCP_y2","v":"2018-19"},{"$f":"FRCP_y3","v":"2019-20"},{"$f":"FRCP_y4","v":"2020-21"},{"$f":"FRCP_y5","v":"2021-22"}]
[null,null,null,null,null,null,null,null,null,null,"Vegetation management",0,0,0,0,0,0,0]
[null,"Efficent historic opex",203392131.21118066,206908566.58177504,207691428.31570151,207700536.80882838,207680789.69582015,207665232.9742564,207636431.88233247,null,"Maintenance",0,0,0,0,0,0,0]
[null,"Real price changes",0,0,345975.30853429617,918083.82340052119,1603627.8351334252,2318700.2840837082,3032580.8247131035,null,"Emergency response",0,0,0,0,0,0,0]
[null,"Output growth",0,0,0,0,0,0,0,null,"Non-network",0,0,0,0,0,0,0]
[null,"Productivity growth",0,0,0,0,0,0,0,null,"Network overheads",0,0,0,0,0,0,0]
[null,"Step changes",2714725.5029024822,3075687.3521881527,7593564.3143098047,1033439.5557373129,722245.1154411739,1155065.844534908,508941.11976340064,null,"Corporate overheads",0,0,0,0,0,0,0]
[null,"Total opex",{"$f":"SUM(C13:C17)","v":206106856.71408314},209984253.93396318,215630967.93854561,209652060.18796623,210006662.64639476,211138999.10287499,211177953.82680899,null,"Total opex",{"$f":"SUM(L12:L17)","v":0},0,0,0,0,0,0]
[]
[null,"Note: The amount noted against step changes, include Other operating expenditure category in addition to the specifically identified step changes in the revenue proposal."]

{"sheet":"2.17 Step Changes","index":10,"n_rows":48,"n_cols":15,"rows_kept":48,"cut":false,"hidden":false,"merged":[[6,1,6,5],[9,8,9,14],[48,1,48,2],[26,1,26,2],[27,1,27,2],[9,1,9,2],[47,1,47,2],[30,1,30,2],[9,5,9,7],[30,5,30,7],[30,8,30,14]]}
[null,{"$f":"(LOOKUP(dms_Model,dms_Model_List,dms_Worksheet_List))","v":"REGULATORY REPORTING STATEMENT"}]
[null,{"$f":"dms_TradingName","v":"AusNet (T)"}]
[null,{"$f":"CONCATENATE(FRCP_y1,\" to \",FRCP_y5)","v":"2017-18 to 2021-22"}]
[null,"2.17 STEP CHANGES"]
[]
[null,"Instructions"]
[null,"Complete the Tables below in accordance with the regulatory information notice.\n\nThe total step changes in Table 2.17.1 must reconcile (in each year) to the total step changes for each year in Table 2.16.1 of worksheet 2.16 Opex Summary."]
[]
[null,"Table 2.17.1  Forecast opex step changes"]
[null,null,null,null,null,"Actual \n($0's, nominal)",null,null,{"$f":"CONCATENATE(\"Forecast ($0's, real \", dms_DollarReal, \")\")","v":"Forecast ($0's, real March 2017)"}]
[null,"Step change","Description",{"$f":"CRCP_y1","v":"2012-13"},{"$f":"CRCP_y2","v":"2013-14"},{"$f":"CRCP_y1","v":"2012-13"},{"$f":"CRCP_y2","v":"2013-14"},{"$f":"CRCP_y3","v":"2014-15"},{"$f":"CRCP_y4","v":"2015-16"},{"$f":"CRCP_y5","v":"2016-17"},{"$f":"FRCP_y1","v":"2017-18"},{"$f":"FRCP_y2","v":"2018-19"},{"$f":"FRCP_y3","v":"2019-20"},{"$f":"FRCP_y4","v":"2020-21"},{"$f":"FRCP_y5","v":"2021-22"}]
[null,"AEMO Power System Security Functions Agreement ","As per 2014-17 determination (referred to as \"AEMO operating agreement\" in AER final decision)",null,null,0,22240.19519618557,30294.437464352319,32092.455795677808,32092.455795677808]
[null,"Transitional arrangements for the Economic Regulation of NSP’s rule change","As per 2014-17 determination",null,null,324817.51125902601,328357.4862633642,531667.13662116125,1176723.379174853,855798.82121807477]
[null,"Fire services levy","As per 2014-17 determination",null,null,0,112885.44,109308.74,1005793.6108644403,1005793.6108644403]
[null,"Controller simulator training","As per 2014-17 determination",null,null,0,0,0,327984.89823182719,327984.89823182719]
[null,"Security of critical infrastructure","As per 2014-17 determination",null,null,0,0,40392.583285803092,42789.941060903744,42789.941060903744]
[null,"Establishment of IT security team","As per 2017-22 Revenue Proposal",null,null,0,0,0,0,656000,656000,656000,656000,656000,656000]
[null,"Roll out of SAIP","As per 2017-22 Revenue Proposal",null,null,0,0,125649.64,103454.81053233215,103454.81053233215,349157.2317249137,349157.2317249137,73168.305278504224,73168.305278504224,73168.305278504224]
[null,"Lease of WMTS 22kV mobile switchboard","As per 2017-22 Revenue Proposal",null,null,0,0,0,25886.407242448207,51772.814484896415,709287.55844308087,300282.32401239924,265076.81016266963,697897.53925640369,51772.814484896415]
[null,"Decommissioning of synchronous condensers","As per 2017-22 Revenue Proposal",null,null,0,0,0,0,0,3989340.8828636948,-270000,-270000,-270000,-270000]
[null,"Decommissioning of Morwell Power Station assets","As per 2017-22 Revenue Proposal",null,null,0,0,0,0,0,1889778.6412781153,-2000,-2000,-2000,-2000]
[]
[]
[]
[]
[]
[null,null,null,{"$f":"SUM(D19:D26)","v":0},0,0,{"$f":"SUM(G19:G26)","v":0},0,25886.407242448207,{"$f":"SUM(J19:J26)","v":51772.814484896415},6588407.0825848905,28282.324012399244,-6923.1898373303702,425897.53925640369,-220227.18551510357]
[null,"Check",null,null,null,null,null,null,null,null,{"$f":"IF(K$49-'2.16 Opex Summary'!C$17=0,\"OK\",\"Error\")","v":"Error"},{"$f":"IF(L$49-'2.16 Opex Summary'!F$17=0,\"OK\",\"Error\")","v":"Error"},{"$f":"IF(M$49-'2.16 Opex Summary'!G$17=0,\"OK\",\"Error\")","v":"Error"},{"$f":"IF(N$49-'2.16 Opex Summary'!H$17=0,\"OK\",\"Error\")","v":"Error"},{"$f":"IF(O$49-'2.16 Opex Summary'!I$17=0,\"OK\",\"Error\")","v":"Error"}]
[]
[null,"Table 2.17.2  Forecast capex step changes"]
[null,null,null,null,null,"Actual \n($0's, nominal)",null,null,{"$f":"CONCATENATE(\"Forecast ($0's, real \", dms_DollarReal, \")\")","v":"Forecast ($0's, real March 2017)"}]
[null,"Step change","Description",{"$f":"CRCP_y1","v":"2012-13"},{"$f":"CRCP_y2","v":"2013-14"},{"$f":"CRCP_y1","v":"2012-13"},{"$f":"CRCP_y2","v":"2013-14"},{"$f":"CRCP_y3","v":"2014-15"},{"$f":"CRCP_y4","v":"2015-16"},{"$f":"CRCP_y5","v":"2016-17"},{"$f":"FRCP_y1","v":"2017-18"},{"$f":"FRCP_y2","v":"2018-19"},{"$f":"FRCP_y3","v":"2019-20"},{"$f":"FRCP_y4","v":"2020-21"},{"$f":"FRCP_y5","v":"2021-22"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,{"$f":"SUM(D33:D47)","v":0},{"$f":"SUM(E33:E47)","v":0},0,{"$f":"SUM(G33:G47)","v":0},0,0,0,0,0,0,0,0]

{"sheet":"3.1 Revenue","index":11,"n_rows":37,"n_cols":9,"rows_kept":37,"cut":false,"hidden":false,"merged":[[7,2,7,8]]}
[null,{"$f":"(LOOKUP(dms_Model,dms_Model_List,dms_Worksheet_List))","v":"REGULATORY REPORTING STATEMENT"}]
[null,{"$f":"dms_TradingName","v":"AusNet (T)"}]
[null,{"$f":"CONCATENATE(FRCP_y1,\" to \",FRCP_y5)","v":"2017-18 to 2021-22"}]
[null,"3.1 REVENUE"]
[]
[]
[]
[null,null,{"$f":"CONCATENATE(\"Forecast ($0's, real \",dms_DollarReal,\")\")","v":"Forecast ($0's, real March 2017)"}]
[null,null,{"$f":"CRCP_y4","v":"2015-16"},{"$f":"CRCP_y5","v":"2016-17"},{"$f":"FRCP_y1","v":"2017-18"},{"$f":"FRCP_y2","v":"2018-19"},{"$f":"FRCP_y3","v":"2019-20"},{"$f":"FRCP_y4","v":"2020-21"},{"$f":"FRCP_y5","v":"2021-22"}]
[null,"Table 3.1.1 Revenue Grouping by chargeable quantity"]
["TREV0101","From Fixed Customer (Exit Point) Charges",null,58994884.252716176,64927636.826146282,63507126.073185988,62117693.777688719,60758659.99371513,59429359.65143355]
["TREV0102","From Variable Customer (Exit Point) Charges",null,0,0,0,0,0,0]
["TREV0103","From Fixed Generator (Entry Point) Charges",null,7822957.053403792,8609663.7175206505,8421298.3235535435,8237054.0570553532,8056840.7544813957,7880570.2249182351]
["TREV0104","From Variable Generator (Entry Point) Charges",null,0,0,0,0,0,0]
["TREV0105","From Fixed Energy Usage Charges (Charge per day basis)",null,0,0,0,0,0,0]
["TREV0106","From Variable Energy Usage charges (Charge per kWh basis)",null,0,0,0,0,0,0]
["TREV0107","From Energy based Common Service and General Charges",null,0,0,0,0,0,0]
["TREV0108","From Fixed Demand based Usage Charges",null,0,0,0,0,0,0]
["TREV0109","From Variable Demand based Usage Charges",null,0,0,0,0,0,0]
["TREV0110","Revenue from other Sources",null,469271285.62491983,517071934.563945,505759244.32898664,494694057.29773653,483870958.50394213,473284651.45197719]
["TREV01","Total revenue by chargeable quantity"]
[]
[]
[null,"Table 3.1.2 Revenue Grouping by type of connected equipment"]
["TREV0201","From Other connected transmission networks",null,0,0,0,0,0,0]
["TREV0202","From Distribution networks",null,58820181.592071265,64735365.393689118,63319061.225946508,61933743.482446156,60578734.230785385,59253370.370616361]
["TREV0203","From Directly connected end–users",null,174702.66064491484,192271.43245716713,188064.84723947599,183950.29524256842,179925.76292974196,175989.28081719176]
["TREV0204","From Generators",null,7822957.053403792,8609663.7175206505,8421298.3235535435,8237054.0570553532,8056840.7544813957,7880570.2249182351]
["TREV0205","Other revenue",null,469271285.62491983,517071934.563945,505759244.32898664,494694057.29773653,483870958.50394213,473284651.45197719]
["TREV02","Total revenue by type of connected equipment"]
[]
[]
["TREV0301","Table 3.1.3 Revenue (penalties) allowed (deducted) through incentive schemes"]
["TREV0302","EBSS",null,13005512.198543658,200264.77873035709,195883.31213875109,191597.70488704043,187405.85972927933,183305.72530384149]
["TREV0303","STPIS",null,8010697.2374037579,0,0,0,0,0]
["TREV03","Other",null,0,0,0,0,0,0]
[null,"Total revenue of incentive schemes"]

{"sheet":"3.2 Operating expenditure","index":12,"n_rows":45,"n_cols":9,"rows_kept":45,"cut":false,"hidden":false,"merged":[[8,2,8,8]]}
[null,{"$f":"(LOOKUP(dms_Model,dms_Model_List,dms_Worksheet_List))","v":"REGULATORY REPORTING STATEMENT"}]
[null,{"$f":"dms_TradingName","v":"AusNet (T)"}]
[null,{"$f":"CONCATENATE(FRCP_y1,\" to \",FRCP_y5)","v":"2017-18 to 2021-22"}]
[null,"3.2 OPERATING EXPENDITURE"]
[]
[]
[null,"Table 3.2.1 Opex categories"]
[null,"Table 3.2.1.1 Current opex categories  and cost allocations"]
[null,null,{"$f":"CONCATENATE(\"Forecast ($0's, real \",dms_DollarReal,\")\")","v":"Forecast ($0's, real March 2017)"}]
[null,null,{"$f":"CRCP_y4","v":"2015-16"},{"$f":"CRCP_y5","v":"2016-17"},{"$f":"FRCP_y1","v":"2017-18"},{"$f":"FRCP_y2","v":"2018-19"},{"$f":"FRCP_y3","v":"2019-20"},{"$f":"FRCP_y4","v":"2020-21"},{"$f":"FRCP_y5","v":"2021-22"}]
[null,"Network Operations",null,5570184.8587387213,4860107.5907451939,5101961.7797370367,5938225.285272846,6181775.3000914799,6378337.3149920283]
[null,"Network Maintenance",null,26774708.914615653,23361516.598819289,24524058.897550706,28543801.958951972,29714495.73632076,30659328.065247133]
[null,"Asset Works Program",null,4865837.679502584,11047674.169448238,4692081.3614800489,5088100.6631472511,5726887.4737391304,5246991.8826861903]
[null,"Asset Works Program - Asset Management Support",null,1680639.5728841124,1466394.626502641,1539367.0199142888,1791684.9548491298,1865169.0138635358,1924475.8248842568]
[null,"Availability Rebate",null,0,0,0,0,0,0]
[null,"Easement Tax",null,114314255.05580883,114314255.05580884,114314255.05580884,114314255.05580884,114314255.05580884,114314255.05580884]
[null,"Insurance",null,3675136.9681985793,3206637.0379338996,3366209.3489826345,3917965.350316836,4078656.5456298674,4208345.6575399125]
[null,"Taxes and Charges",null,3894825.7998085637,3398320.327660732,3567431.4000875996,4152169.7452951842,4322466.5855824854,4459908.1295010773]
[null,"Self Insurance Costs",null,1829721.0984883108,2717257.6264139619,2718608.2387130167,2701479.8374731522,2694767.809748597,2684237.5817454439]
[null,"OHS",null,646390.32661804964,563989.63636765117,592055.52864609519,689099.46061435062,717362.14446037565,740172.1208317948]
[null,"Finance",null,4462065.4235333549,3893249.2520951261,4086989.5392858037,4756888.7558549037,4951987.5052830037,5109445.9366475921]
[null,"HR",null,3347047.9612312284,2920372.2345853206,3065699.1116476515,3568198.4240114968,3714544.299638527,3832655.7282379284]
[null,"IT ",null,31846043.91180747,37706011.331757851,35600864.019251481,26999769.946257718,25002157.295931343,23515577.337143242]
[null,"Building Services",null,1657884.9158558911,1446540.6927190677,1518525.0921483047,1767426.8228213012,1839915.9602672209,1898419.7995110138]
[null,"Strategy and Business Development",null,1251061.6847291577,1091578.5642021645,1145898.9353949174,1333723.4433143977,1388424.6964293267,1432572.4602381783]
[null,"Other Corporate Services",null,4168449.7621426727,3637063.1934856377,3818054.8593178084,4443872.9424053906,4626133.6800805246,4773230.9317943584]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Total opex ",{"$f":"SUM(C11:C44)","v":0},{"$f":"SUM(D11:D44)","v":209984253.93396312},215630967.93854561,209652060.18796623,210006662.64639476,211138999.10287499,211177953.82680899]

{"sheet":"3.3 Assets (RAB)","index":13,"n_rows":94,"n_cols":9,"rows_kept":94,"cut":false,"hidden":false,"merged":[[6,2,6,8]]}
[null,{"$f":"(LOOKUP(dms_Model,dms_Model_List,dms_Worksheet_List))","v":"REGULATORY REPORTING STATEMENT"}]
[null,{"$f":"dms_TradingName","v":"AusNet (T)"}]
[null,{"$f":"CONCATENATE(FRCP_y1,\" to \",FRCP_y5)","v":"2017-18 to 2021-22"}]
[null,"3.3 ASSETS"]
[]
[]
[null,null,{"$f":"CONCATENATE(\"Forecast ($0's, real \",dms_DollarReal,\")\")","v":"Forecast ($0's, real March 2017)"}]
[null,null,{"$f":"CRCP_y4","v":"2015-16"},{"$f":"CRCP_y5","v":"2016-17"},{"$f":"FRCP_y1","v":"2017-18"},{"$f":"FRCP_y2","v":"2018-19"},{"$f":"FRCP_y3","v":"2019-20"},{"$f":"FRCP_y4","v":"2020-21"},{"$f":"FRCP_y5","v":"2021-22"}]
[]
[null,"TABLE 3.3.1 - REGULATORY ASSET BASE VALUES"]
[null,"For total asset base:"]
["TRAB0101","Opening value"]
["TRAB0102","Inflation addition"]
["TRAB0103","Straight line depreciation"]
["TRAB0104","Regulatory depreciation"]
["TRAB0105","Actual additions (recognised in RAB)"]
["TRAB0106","Disposals "]
["TRAB0107","Closing value "]
[]
[]
[null,"TABLE 3.3.2 - ASSET VALUE ROLL FORWARD"]
[null,"For overhead transmission assets:"]
["TRAB0201","Opening value"]
["TRAB0202","Inflation addition"]
["TRAB0203","Straight line depreciation"]
["TRAB0204","Regulatory depreciation"]
["TRAB0205","Actual additions (recognised in RAB)"]
["TRAB0206","Disposals "]
["TRAB0207","Closing value "]
[null,"For underground transmission assets:"]
["TRAB0301","Opening value"]
["TRAB0302","Inflation addition"]
["TRAB0303","Straight line depreciation"]
["TRAB0304","Regulatory depreciation"]
["TRAB0305","Actual additions (recognised in RAB)"]
["TRAB0306","Disposals "]
["TRAB0307","Closing value "]
[null,"For transmission switchyards, substations"]
["TRAB0401","Opening value"]
["TRAB0402","Inflation addition"]
["TRAB0403","Straight line depreciation"]
["TRAB0404","Regulatory depreciation"]
["TRAB0405","Actual additions (recognised in RAB)"]
["TRAB0406","Disposals "]
["TRAB0407","Closing value "]
[null,"For easements:"]
["TRAB0501","Opening value"]
["TRAB0502","Inflation addition"]
["TRAB0503","Straight line depreciation"]
["TRAB0504","Regulatory depreciation"]
["TRAB0505","Actual additions (recognised in RAB)"]
["TRAB0506","Disposals "]
["TRAB0507","Closing value "]
[null,"For “other” assets with long lives:"]
["TRAB0601","Opening value"]
["TRAB0602","Inflation addition"]
["TRAB0603","Straight line depreciation"]
["TRAB0604","Regulatory depreciation"]
["TRAB0605","Actual additions (recognised in RAB)"]
["TRAB0606","Disposals "]
["TRAB0607","Closing value "]
[null,"For “other” assets with short lives:"]
["TRAB0701","Opening value"]
["TRAB0702","Inflation addition"]
["TRAB0703","Straight line depreciation"]
["TRAB0704","Regulatory depreciation"]
["TRAB0705","Actual additions (recognised in RAB)"]
["TRAB0706","Disposals "]
["TRAB0707","Closing value "]
[]
[]
[null,"TABLE 3.3.3 - TOTAL DISAGGREGATED RAB ASSET VALUES"]
["TRAB0801","Overhead transmission assets (wires and towers/poles etc)"]
["TRAB0802","Underground transmission assets (cables, ducts etc)"]
["TRAB0803","Substations, switchyards, Transformers etc with transmission function"]
["TRAB0804","Easements"]
["TRAB0805","Other assets with long lives (please specify)"]
["TRAB0806","Other assets with short lives (please specify)"]
[]
[]
[null,"TABLE 3.3.4 - ASSET LIVES"]
[null,"3.3.4.1 Asset Lives – estimated service life of new assets"]
["TRAB0901","Overhead transmission assets "]
["TRAB0902","Underground transmission assets"]
["TRAB0903","Switchyard, substation and transformer assets"]
["TRAB0904","“Other” assets with long lives"]
["TRAB0905","“Other assets with short lives"]
[]
[null,"3.3.4.2 Asset Lives – estimated residual service life"]
["TRAB1001","Overhead transmission assets "]
["TRAB1002","Underground transmission assets"]
["TRAB1003","Switchyard, substation and transformer assets"]
["TRAB1004","Other assets with long lives"]
["TRAB1005","Other assets with short lives"]

{"sheet":"Unprotected 3.3 Assets (RAB)","index":14,"n_rows":100,"n_cols":9,"rows_kept":100,"cut":false,"hidden":false,"merged":[[5,2,5,8]]}
[null,"REGULATORY REPORTING STATEMENT"]
[null,"AusNet (T)"]
[null,"2017-18 to 2021-22"]
[null,"3.3 ASSETS"]
[]
[null,null,"Forecast ($0's, real March 2017)"]
[null,null,"2015-16","2016-17","2017-18","2018-19","2019-20","2020-21","2021-22"]
[]
[null,"3.3.1 - REGULATORY ASSET BASE VALUES"]
[null,"For total asset base:"]
["TRAB0201","Opening value",2796758861.4280915,2818856238.3741512,3029527148.4351325,3073847733.6272821,3105609200.5186615,3120790840.3697815,3085136065.5371552]
["TRAB0202","Inflation addition",42056524.232001066,46511127.933173485,0,0,0,0,0]
["TRAB0203","Straight line depreciation",-152480082.43031609,-161231040.23911136,-170431946.83797112,-170893861.8718192,-175824982.683413,-176599482.02660465,-158449621.59884173]
["TRAB0204","Regulatory depreciation",-110423558.19831504,-114719912.30593787,-170431946.83797112,-170893861.8718192,-175824982.683413,-176599482.02660465,-158449621.59884173]
["TRAB0205","Actual additions (recognised in RAB)",132632814.26437409,187824670.65799367,214970532.03012136,202826328.76319864,191245622.53453317,141147707.19397771,119272803.8184866]
["TRAB0206","Disposals ",-111879.12,0,-218000,-171000,-239000,-203000,-208000]
[null,"RFM True Up & Group 3 assets roll-in",0,137566151.70892602,0,0,0,0,0]
["TRAB0207","Closing value ",2818856238.3741512,3029527148.4351325,3073847733.6272821,3105609200.5186615,3120790840.3697815,3085136065.5371552,3045751247.7567997]
[]
[]
[null,"3.3.2 - ASSET VALUE ROLL FORWARD"]
[null,"For overhead transmission assets:"]
["TRAB0201","Opening value",1058221486.4324728,1047046692.3404192,1063456892.8786812,1030527191.0882862,1001470073.6875103,964901388.99831986,927895354.29623544]
["TRAB0202","Inflation addition",15913105.059134811,17276270.423616916,0,0,0,0,0]
["TRAB0203","Straight line depreciation",-46187088.100524075,-47194528.202218629,-47395887.099072486,-47650006.186505154,-47977319.878263794,-48178648.113858514,-48376403.067775302]
["TRAB0204","Regulatory depreciation",-30273983.041389264,-29918257.778601713,-47395887.099072486,-47650006.186505154,-47977319.878263794,-48178648.113858514,-48376403.067775302]
["TRAB0205","Actual additions (recognised in RAB)",19099188.949335556,11529418.178336857,14466185.308677472,18592888.785729248,11408635.189073486,11172613.411774073,10912076.639327442]
["TRAB0206","Disposals ",0,0,0,0,0,0,0]
[null,"RFM True Up & Group 3 assets roll-in",0,34799040.138526902,0,0,0,0,0]
["TRAB0207","Closing value ",1047046692.3404192,1063456892.8786812,1030527191.0882862,1001470073.6875103,964901388.99831986,927895354.29623544,890431027.8677876]
[null,"For underground transmission assets:"]
["TRAB0301","Opening value",35321171.334092364,34345333.410472408,33372177.494183213,31884854.437314413,30410547.379400317,28953672.533482708,27507982.003341932]
["TRAB0302","Inflation addition",531145.43359536992,566698.00127279479,0,0,0,0,0]
["TRAB0303","Straight line depreciation",-1506983.357215324,-1539853.917561989,-1487323.0568687995,-1474307.0579140955,-1456874.8459176067,-1445690.5301407774,-1434145.7997535502]
["TRAB0304","Regulatory depreciation",-975837.92361995403,-973155.91628919425,-1487323.0568687995,-1474307.0579140955,-1456874.8459176067,-1445690.5301407774,-1434145.7997535502]
["TRAB0305","Actual additions (recognised in RAB)",0,0,0,0,0,0,0]
["TRAB0306","Disposals ",0,0,0,0,0,0,0]
[null,"RFM True Up & Group 3 assets roll-in",0,0,0,0,0,0,0]
["TRAB0307","Closing value ",34345333.410472408,33372177.494183213,31884854.437314413,30410547.379400317,28953672.533482708,27507982.003341932,26073836.203588381]
[null,"For transmission switchyards, substations"]
["TRAB0401","Opening value",1236360693.054117,1250929139.0195072,1390977079.1775331,1447062501.0381317,1500130564.2107074,1553342897.7860019,1568578142.1894243]
["TRAB0402","Inflation addition",18591890.121114403,20640330.793821868,0,0,0,0,0]
["TRAB0403","Straight line depreciation",-62035872.17986466,-64280385.065028593,-67275411.086153865,-59700103.539351039,-62206586.48084107,-59949613.508804359,-47153820.997166291]
["TRAB0404","Regulatory depreciation",-43443982.058750257,-43640054.271206722,-67275411.086153865,-59700103.539351039,-62206586.48084107,-59949613.508804359,-47153820.997166291]
["TRAB0405","Actual additions (recognised in RAB)",58012428.024140388,112641655.90668103,123360832.94675243,112768166.71192679,115418920.05613561,75184857.912226737,59248541.617408358]
["TRAB0406","Disposals ",0,0,0,0,0,0,0]
[null,"RFM True Up & Group 3 assets roll-in",0,71046338.522551805,0,0,0,0,0]
["TRAB0407","Closing value ",1250929139.0195072,1390977079.1775331,1447062501.0381317,1500130564.2107074,1553342897.7860019,1568578142.1894243,1580672862.8096662]
[null,"For easements:"]
["TRAB0501","Opening value",131187407.51401946,133160150.48415507,135344233.83230227,135344233.83230227,135344233.83230227,135344233.83230227,135344233.83230227]
["TRAB0502","Inflation addition",1972742.9701356164,2197142.4829885587,0,0,0,0,0]
["TRAB0503","Straight line depreciation",0,0,0,0,0,0,0]
["TRAB0504","Regulatory depreciation",1972742.9701356164,2197142.4829885587,0,0,0,0,0]
["TRAB0505","Actual additions (recognised in RAB)",0,0,0,0,0,0,0]
["TRAB0506","Disposals ",0,0,0,0,0,0,0]
[null,"RFM True Up & Group 3 assets roll-in",0,-13059.134841357589,0,0,0,0,0]
["TRAB0507","Closing value ",133160150.48415507,135344233.83230227,135344233.83230227,135344233.83230227,135344233.83230227,135344233.83230227,135344233.83230227]
[null,"For “other” assets with long lives:"]
["TRAB0601","Opening value",277171944.16244793,270897904.60141164,317723104.40300125,332036192.60695618,340718432.49817657,349808648.75788844,351351907.65448141]
["TRAB0602","Inflation addition",4167999.1603375319,4469815.4259232925,0,0,0,0,0]
["TRAB0603","Straight line depreciation",-30970025.238278754,-31681644.325158309,-34896793.94153779,-37724963.854513392,-38810711.721261628,-39596109.792792462,-39998965.061373174]
["TRAB0604","Regulatory depreciation",-26802026.077941224,-27211828.899235018,-34896793.94153779,-37724963.854513392,-38810711.721261628,-39596109.792792462,-39998965.061373174]
["TRAB0605","Actual additions (recognised in RAB)",20527986.516904939,42769944.927288495,49209882.145492718,46407203.745733775,47900927.980973467,41139368.689385422,37217224.989586189]
["TRAB0606","Disposals ",0,0,0,0,0,0,0]
[null,"RFM True Up & Group 3 assets roll-in",0,31267083.773536172,0,0,0,0,0]
["TRAB0607","Closing value ",270897904.60141164,317723104.40300125,332036192.60695618,340718432.49817657,349808648.75788844,351351907.65448141,348570167.58269441]
[null,"For “other” assets with short lives:"]
["TRAB0701","Opening value",58496158.930941992,82477018.518185243,88653660.649431258,96992760.624291837,97535348.910565138,88439998.461786836,74458445.561369807]
["TRAB0702","Inflation addition",879641.48768333171,1360870.8055500565,0,0,0,0,0]
["TRAB0703","Straight line depreciation",-11780113.554433282,-16534628.729143865,-19376531.654338177,-24344481.233535524,-25373489.757128891,-27429420.081008524,-21486286.672773413]
["TRAB0704","Regulatory depreciation",-10900472.066749951,-15173757.923593808,-19376531.654338177,-24344481.233535524,-25373489.757128891,-27429420.081008524,-21486286.672773413]
["TRAB0705","Actual additions (recognised in RAB)",34993210.773993209,20883651.64568729,27933631.629198767,25058069.519808833,16517139.308350585,13650867.180591501,11894960.572164608]
["TRAB0706","Disposals ",-111879.12,0,-218000,-171000,-239000,-203000,-208000]
[null,"RFM True Up & Group 3 assets roll-in",0,466748.40915252111,0,0,0,0,0]
["TRAB0707","Closing value ",82477018.518185243,88653660.649431258,96992760.624291837,97535348.910565138,88439998.461786836,74458445.561369807,64659119.460761003]
[]
[]
[null,"3.3.3 - TOTAL DISAGGREGATED RAB ASSET VALUES"]
["TRAB0801","Overhead transmission assets (wires and towers/poles etc)",1052634089.386446,1055251792.6095502,1046992041.9834837,1015998632.3878982,983185731.34291506,946398371.64727759,909163191.08201146]
["TRAB0802","Underground transmission assets (cables, ducts etc)",34833252.372282386,33858755.45232781,32628515.965748813,31147700.908357367,29682109.956441514,28230827.268412322,26790909.103465155]
["TRAB0803","Substations, switchyards, Transformers etc with transmission function",1243644916.0368121,1320953109.0985203,1419019790.1078324,1473596532.6244197,1526736730.9983547,1560960519.9877131,1574625502.4995451]
["TRAB0804","Easements",132173778.99908727,134252192.15822867,135344233.83230227,135344233.83230227,135344233.83230227,135344233.83230227,135344233.83230227]
["TRAB0805","Other assets with long lives (please specify)",274034924.38192976,294310504.50220644,324879648.50497872,336377312.55256641,345263540.62803251,350580278.20618492,349961037.61858791]
["TRAB0806","Other assets with short lives (please specify)",70486588.724563614,85565339.583808243,92823210.636861548,97264054.767428488,92987673.686175987,81449222.011578321,69558782.511065409]
[]
[]
[null,"3.3.4 - ASSET LIVES"]
[null,"3.3.4.1 Asset Lives – estimated service life of new assets"]
["TRAB0901","Overhead transmission assets ",68.599999999999994,68.599999999999994,68.599999999999994,68.599999999999994,68.599999999999994,68.599999999999994,68.599999999999994]
["TRAB0902","Underground transmission assets",60,60,60,60,60,60,60]
["TRAB0903","Switchyard, substation and transformer assets",40.6,40.6,40.6,40.6,40.6,40.6,40.6]
["TRAB0904","“Other” assets with long lives",17.061790796661832,16.795591953066154,16.475535175770808,16.372807342338863,16.28511598118402,16.225873765196411,16.163300588262182]
["TRAB0905","“Other assets with short lives",5.1105420752296871,5.1062932370461578,5.1200160828274903,5.1241219793551718,5.1539962420658023,5.1929482341694095,5.2339259233150663]
[]
[null,"3.3.4.2 Asset Lives – estimated residual service life"]
["TRAB1001","Overhead transmission assets ",23.6,22.6,21.6,20.7,19.7,18.7,17.7]
["TRAB1002","Underground transmission assets",37.9,36.9,35.9,34.9,33.9,32.9,31.9]
["TRAB1003","Switchyard, substation and transformer assets",11.6,10.9,10.199999999999999,9.6,9,8.1999999999999993,7.6]
["TRAB1004","Other assets with long lives",12.775232994847341,12.08783919945188,11.644284781765274,11.346084652064851,11.08365777151322,10.744608493709046,10.362925627033697]
["TRAB1005","Other assets with short lives",3.3430741756986064,3.288210695479072,3.2329499439829394,3.1195341943078301,2.8256511781266846,2.6346716097330507,2.5372786969354366]

{"sheet":"7.5 EBSS","index":15,"n_rows":97,"n_cols":24,"rows_kept":97,"cut":false,"hidden":false,"merged":[[82,3,82,7],[48,3,48,6],[48,7,48,9],[48,11,48,14],[48,15,48,17],[65,11,65,17],[70,13,70,23],[72,11,72,12],[73,11,73,12],[74,11,74,12],[81,3,81,7],[69,18,69,22],[47,3,47,6],[47,7,47,9],[47,11,47,14],[47,15,47,17],[6,2,6,14],[16,3,16,12],[16,13,16,14],[29,3,29,6],[29,7,29,9],[29,11,29,14],[29,15,29,17],[30,3,30,6],[30,7,30,9],[30,11,30,14],[30,15,30,17]]}
[null,null,"REGULATORY REPORTING STATEMENT"]
[null,null,{"$f":"dms_TradingName","v":"AusNet (T)"}]
[null,null,{"$f":"FRCP_span","v":"2017-18 to 2021-22"}]
[null,null,"7.5 EBSS"]
[]
[]
[null,null,"Instructions\nThe NSP is required to populate all input cells (yellow) in table 7.5.1 presented below.\n\nEfficiency gains are calculated using the formulae below.  Adjusted target and actual amounts are used to calculate the carry-over amounts.\n\n We will calculate the efficiency gain in 2014–15 (year 7) as follows:\n E7 = (F7 – A7) – (F6 – A6) + (F4 – A4)\n where F7 is the forecast opex we approved for year 7, and A7 is the actual opex incurred for year 7, and so on. The formula references year 4 (2011-12) because it was the base year used to forecast opex."]
[null,null,"\n"]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Actual and estimated inflation"]
[null,null,null,"Actual",null,null,null,null,null,null,null,null,null,"Estimated"]
[null,null,null,"2005-06","2006-07",{"$f":"PRCP_y1","v":"2007-08"},{"$f":"PRCP_y2","v":"2008-09"},{"$f":"PRCP_y3","v":"2009-10"},{"$f":"PRCP_y4","v":"2010-11"},{"$f":"PRCP_y5","v":"2011-12"},{"$f":"CRCP_y1","v":"2012-13"},{"$f":"CRCP_y2","v":"2013-14"},{"$f":"CRCP_y3","v":"2014-15"},{"$f":"CRCP_y4","v":"2015-16"},{"$f":"CRCP_y5","v":"2016-17"}]
[null,null,"Actual CPI - Mar quarter (old base)",null,155.6,162.19999999999999,166.2,171,176.7,179.5]
[null,null,"Actual CPI - Mar quarter (rebased in Sep 2012)",null,null,null,null,null,null,99.9,102.4,105.4,106.8,108.2,110.38625]
[null,null,"Actual inflation rate (consistent with annual revenue adj)",null,null,{"$f":"F19/E19-1","v":4.2416452442159303E-2},2.4660912453760897E-2,2.8880866425992746E-2,3.3333333333333215E-2,{"$f":"J19/I19-1","v":1.5846066779853007E-2},{"$f":"K20/J20-1","v":2.5025025025025016E-2},{"$f":"L20/K20-1","v":2.9296875E-2},1.3282732447817747E-2,1.3108614232209881E-2,{"$f":"O20/N20-1","v":2.0205637707948254E-2}]
[null,null,"Actual inflation rate (lagged by one year)"]
[null,null,{"$f":"CONCATENATE(\"Reconstructed cumulative index (\",CRCP_y5,\"=1)\")","v":"Reconstructed cumulative index (2016-17=1)"},null,null,{"$f":"G23/(1+G21)","v":0.81778079130916925},{"$f":"H23/(1+H21)","v":0.83794801181001199},0.86214867641102311,0.8908869656247238,0.90500401997531377,0.92765176822294426,0.95482906612010088,0.96751180513877388,{"$f":"O23/(1+O21)","v":0.98019454415744711},1]
[]
[]
[]
[null,null,"TABLE 7.5.1 - The carryover amounts that arise from applying the EBSS during the current regulatory control period"]
[]
[null,null,"Table 7.5.1.1 - Opex allowance applicable to EBSS (EBSS target)"]
[null,null,null,"Previous period",null,null,null,"Current regulatory control period",null,null,null,"Previous period",null,null,null,"Current regulatory control period"]
[null,null,null,{"$f":"CONCATENATE(\"$m, real \", (PRCP_y1))","v":"$m, real 2007-08"},null,null,null,{"$f":"CONCATENATE(\"$m, real \", CRCP_y2)","v":"$m, real 2013-14"},null,null,null,"$m, real 2016-17",null,null,null,{"$f":"CONCATENATE(\"$m, real \", CRCP_y5)","v":"$m, real 2016-17"}]
[null,null,null,{"$f":"PRCP_y4","v":"2010-11"},{"$f":"PRCP_y5","v":"2011-12"},{"$f":"CRCP_y1","v":"2012-13"},{"$f":"CRCP_y2","v":"2013-14"},{"$f":"CRCP_y3","v":"2014-15"},{"$f":"CRCP_y4","v":"2015-16"},{"$f":"CRCP_y5","v":"2016-17"},null,{"$f":"PRCP_y4","v":"2010-11"},{"$f":"PRCP_y5","v":"2011-12"},{"$f":"CRCP_y1","v":"2012-13"},{"$f":"CRCP_y2","v":"2013-14"},{"$f":"CRCP_y3","v":"2014-15"},{"$f":"CRCP_y4","v":"2015-16"},{"$f":"CRCP_y5","v":"2016-17"}]
["ED_EBS7511_00001",null,"Total opex allowance",163.65673570397598,171.30742991475381,168.57937240425505,176.80874469975316,185.13515541257806,189.80991219149408,188.00559467591285,null,{"$f":"+D33/$F$23","v":200.12298826679594},{"$f":"+E33/$F$23","v":209.47842225605606},206.14249465847644,216.2055486980851,{"$f":"+H33/$L$23","v":193.89350615902939},{"$f":"+I33/$L$23","v":198.78941574618895},196.89973980354827]
[null,null,"Approved excludable costs - allowance "]
[null,null,"Equity raising costs",1.5702424331306541,1.5009218563876809,1.4341057691114003,1.3748031502351976,null,null,null,null,{"$f":"-D35/$F$23","v":-1.9201263343650856},-1.8353596371282879,-1.7536554836603198,-1.6811389614988415]
[null,null,"Opex glide path",5.0675210347880162,3.3783473565253446,1.6891736782626723,0,null,null,null,null,-6.1966740826420255,-4.1311160550946839,-2.065558027547342,0]
["ED_EBS7511_00002",null,"Easement land tax",82.325647093427861,90.972693731177486,88.678146685685377,97.990704488873462,100.91902926829269,103.44200499999999,100.91902926829269,null,-100.66957792152876,-111.243373160601,-108.43755151514658,-119.82514816959942,{"$f":"+-H37/$L$23","v":-105.69329406610129},{"$f":"+-I37/$L$23","v":-108.3356264177538},-105.69329406610129]
["ED_EBS7511_00003",null,"Self insurance",2.091917,2.091917,2.091917,2.091917,1.7,1.7,1.6,null,-2.5580412529023713,-2.5580412529023713,-2.5580412529023713,-2.5580412529023713,{"$f":"+-H38/$L$23","v":-1.7804233870967745},-1.7804233870967745,-1.6756925996204937]
["ED_EBS7511_00004",null,"Rebates made under the Availability Incentive Scheme ",2.7898513830388718,2.7898513830388718,2.7898513830388718,2.7898513830388718,2.2812929999999998,2.2812929999999998,2.2812929999999998,null,-3.411490478484648,-3.411490478484648,-3.411490478484648,-3.411490478484648,-2.3892161235412717,-2.3892161235412717,-2.3892161235412717]
["ED_EBS7511_00005",null,"Debt Raising costs",1.0997049234835832,1.1097041664419816,1.1215816581501457,1.1230621814268529,1.5496105450072941,1.5561098586057678,1.5775852076399237,null,-1.3447429129792681,-1.3569702030607467,-1.3714942562476033,-1.3733046720612803,-1.6229193266016266,-1.629726108913861,-1.6522174110706125]
["ED_EBS7511_00006",null,"Priority projects approved under STPIS network capability component",null,null,null,null,0,0,0,null,null,null,null,null,0,0,0]
[null,null,"Movements in provisions related to opex",2.1806546623794207,2.1806546623794207,2.1806546623794207,2.1806546623794207,0,0,0,null,-2.6665515814922154,-2.6665515814922154,-2.6665515814922154,-2.6665515814922154,0,0,0]
["ED_EBS7511_00008",null,"Capitalisation policy changes",null,null,null,null,0,0,0,null,{"$f":"D43/$F$23","v":0},{"$f":"E43/$F$23","v":0},0,0,{"$f":"+H43/$L$23","v":0},{"$f":"+I43/$L$23","v":0},0]
["ED_EBS7511_00010",null,"Other adjustments or exclusions required by the EBSS",null,null,null,null,0,0,0,null,{"$f":"D44/$F$23","v":0},0,0,0,{"$f":"+H44/$L$23","v":0},0,0]
[null,null,"Forecast opex for EBSS purposes",{"$f":"(D33-SUM(D35:D42)+SUM(D43:D44))","v":66.531197173727577},{"$f":"(E33-SUM(E35:E42)+SUM(E43:E44))","v":67.283339758803024},{"$f":"(F33-SUM(F35:F42)+SUM(F43:F44))","v":68.593941567627169},{"$f":"(G33-SUM(G35:G42)+SUM(G43:G44))","v":69.257751833799375},{"$f":"(H33-SUM(H35:H42)+SUM(H43:H44))","v":78.685222599278063},{"$f":"(I33-SUM(I35:I42)+SUM(I43:I44))","v":80.83050433288831},81.62768719998023,null,{"$f":"+SUM(L33:L44)","v":81.355783702401567},82.275519887292134,83.878152062995355,84.689873582046317,82.407653255688416,84.654423708883243,85.489319603214611]
[]
[null,null,"Table 7.5.1.2 - Actual and estimated opex applicable to EBSS"]
[null,null,null,"Previous period",null,null,null,"Current regulatory control period",null,null,null,"Previous period",null,null,null,"Current regulatory control period"]
[null,null,null,"$m, Actual",null,null,null,"$m, Actual",null,null,null,"$m, real 2016-17",null,null,null,{"$f":"CONCATENATE(\"$m, real \", CRCP_y5)","v":"$m, real 2016-17"}]
[null,null,null,{"$f":"PRCP_y4","v":"2010-11"},{"$f":"PRCP_y5","v":"2011-12"},{"$f":"CRCP_y1","v":"2012-13"},{"$f":"CRCP_y2","v":"2013-14"},{"$f":"CRCP_y3","v":"2014-15"},{"$f":"CRCP_y4","v":"2015-16"},{"$f":"CRCP_y5","v":"2016-17"},null,{"$f":"PRCP_y4","v":"2010-11"},{"$f":"PRCP_y5","v":"2011-12"},{"$f":"CRCP_y1","v":"2012-13"},{"$f":"CRCP_y2","v":"2013-14"},{"$f":"CRCP_y3","v":"2014-15"},{"$f":"CRCP_y4","v":"2015-16"},{"$f":"CRCP_y5","v":"2016-17"}]
["ED_EBS7512_0001",null,"Total opex ",{"$f":"172362.976328331/1000","v":172.362976328331},{"$f":"175683.335237523/1000","v":175.68333523752298},{"$f":"179435.10486911/1000","v":179.43510486910998},{"$f":"189339.332393219/1000","v":189.339332393219},{"$f":"191223.065007723/1000","v":191.22306500772299},201.53542861506301,null,null,{"$f":"+D51/I$23*(1+I$21)^0.5","v":196.67157666930001},{"$f":"+E51/J$23*(1+J$21)^0.5","v":195.65637865537684},195.83471049726631,201.18033992385574,{"$f":"+H51/M$23*(1+M$21)^0.5","v":198.95246441341271},{"$f":"+I51/N$23*(1+N$21)^0.5","v":206.95080806780766}]
[null,null,"Approved excludable costs"]
[null,null,"Equity raising costs",0,0,0,0,null,null,null,null,{"$f":"-D53/I$23*(1+I$21)^0.5","v":0},0,0,0]
[null,null,"Opex glide path (not incurred)",0,0,0,0,null,null,null,null,0,0,0,0]
["ED_EBS7512_0002",null,{"$f":"C37","v":"Easement land tax"},93.271000000000001,99.341999999999999,99.341999999999999,103.44200500000001,103.44200500000001,111.32294,null,null,{"$f":"-D55/I$23*(1+I$21)^0.5","v":-106.42514429885225},-110.63596864269375,-108.42143639847239,-109.91111812460628,{"$f":"-H55/M$23*(1+M$21)^0.5","v":-107.62321908072852},{"$f":"-I55/N$23*(1+N$21)^0.5","v":-114.31425505580883}]
["ED_EBS7512_0003",null,"Self insurance",2.2799999999999998,2.3410000000000002,2.4129999999999998,2.4639207159353349,1.7416499999999999,1.7818419230769231,null,null,{"$f":"-D56/I$23*(1+I$21)^0.5","v":-2.601551704188688},-2.6071430270434068,-2.6335379399399437,-2.6180107477502301,-1.8120489786711964,-1.8297210984883108]
["ED_EBS7512_0004",null,"Rebates made under the Availability Incentive Scheme ",2.61,2.1720000000000002,2.0110000000000001,3.10947598,2.4027953599999998,1.7666952200000001,null,null,-2.978092082426524,-2.4189297969834596,-2.1947968492412877,-3.3039381027408141,-2.4999183980959954,-1.8141673942940988]
["ED_EBS7512_0005",null,"Debt Raising costs",{"$f":"3994.19573344048/1000","v":3.9941957334404803},{"$f":"3599.20323376781/1000","v":3.5992032337678102},{"$f":"3963.0469008545/1000","v":3.9630469008545002},{"$f":"3163.05941340303/1000","v":3.1630594134030297},{"$f":"2884.88771805622/1000","v":2.8848877180562198},0,null,null,-4.5575029461382757,-4.0083885578085541,-4.3252525367433643,-3.3608725664365089,-3.001497340501738,0]
["ED_EBS7512_0006",null,"Priority projects approved under STPIS network capability component",null,null,null,null,0.25119547000000003,0.82261508999999999,null,null,0,0,0,0,-0.26134900517344545,-0.8447192574236464]
["ED_EBS7512_0008",null,"Movements in provisions related to opex",0.33600000000000002,0.62,1.262,1.3741403276641613,-0.13078950975576323,4.9209397487811337,null,null,-0.38338656693306988,-0.69048640613708323,-1.3773414339843386,-1.4600770728842773,0.13607613330682816,-5.0531683905979694]
["ED_EBS7512_0008",null,"Opex associated with approved cost pass through",null,null,null,0,0,null,null,null,0,0,0,0,0]
["ED_EBS7512_0009",null,{"$f":"C43","v":"Capitalisation policy changes"},null,null,null,0,0,null,null,null,{"$f":"D62/I$23*(1+I$21)^0.5","v":0},{"$f":"E62/J$23*(1+J$21)^0.5","v":0},0,0,0]
["ED_EBS7512_0011",null,"Other adjustments or exclusions required by the EBSS",null,null,null,0,0,null,null,null,{"$f":"D63/I$23*(1+I$21)^0.5","v":0},0,0,0,0]
[null,null,"Actual opex for EBSS purposes",{"$f":"(D51-SUM(D53:D61)+SUM(D62:D63))","v":69.871780594890524},{"$f":"(E51-SUM(E53:E61)+SUM(E62:E63))","v":67.609132003755178},{"$f":"(F51-SUM(F53:F61)+SUM(F62:F63))","v":70.444057968255493},{"$f":"(G51-SUM(G53:G61)+SUM(G62:G63))","v":75.786730956216459},{"$f":"(H51-SUM(H55:H61)+SUM(H62:H63))","v":80.631320969422518},{"$f":"(I51-SUM(I55:I61)+SUM(I62:I63))","v":80.920396633204945},{"$f":"(J51-SUM(J55:J61)+SUM(J62:J63))","v":0},null,{"$f":"L51+SUM(L53:L63)","v":79.725899070761201},{"$f":"M51+SUM(M53:M63)","v":75.295462224710576},76.882345338884988,80.526323309437629,{"$f":"P51+SUM(P55:P63)","v":83.890507743548639},{"$f":"Q51+SUM(Q55:Q63)","v":83.094776871194796},{"$f":"+R45-(P45-P64)","v":86.972174091074834}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Base year",null,null,"Base year"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Incremental gain ($m, \",CRCP_y5,\")\")","v":"Incremental gain ($m, 2016-17)"}]
["ED_EBS7512_0012",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(P45-P64)-(O45-O64)+(M45-M64)","v":1.3336529021126466},{"$f":"(Q45-Q64)-(P45-P64)","v":3.0425013255486704},{"$f":"(R45-R64)-(Q45-Q64)","v":-3.0425013255486704}]
[]
[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,"Current regulatory control period",null,null,"Forthcoming regulatory control period"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"$m, real \", CRCP_y5)","v":"$m, real 2016-17"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CRCP_y3","v":"2014-15"},{"$f":"CRCP_y4","v":"2015-16"},{"$f":"CRCP_y5","v":"2016-17"},{"$f":"FRCP","v":"2017-18"},"2018-19","2019-20","2020-21","2021-22","Total "]
["ED_EBS7512_0015",null,null,null,null,null,null,null,null,null,null,{"$f":"CRCP_y3","v":"2014-15"},null,null,null,null,{"$f":"$P$67","v":1.3336529021126466},{"$f":"$P$67","v":1.3336529021126466},{"$f":"$P$67","v":1.3336529021126466},{"$f":"$P$67","v":1.3336529021126466},{"$f":"$P$67","v":1.3336529021126466}]
["ED_EBS7512_0016",null,null,null,null,null,null,null,null,null,null,{"$f":"CRCP_y4","v":"2015-16"},null,null,null,null,null,{"$f":"$Q$67","v":3.0425013255486704},{"$f":"$Q$67","v":3.0425013255486704},{"$f":"$Q$67","v":3.0425013255486704},{"$f":"$Q$67","v":3.0425013255486704},{"$f":"$Q$67","v":3.0425013255486704}]
["ED_EBS7512_0017",null,null,null,null,null,null,null,null,null,null,{"$f":"CRCP_y5","v":"2016-17"},null,null,null,null,null,null,{"$f":"+$R$67","v":-3.0425013255486704},{"$f":"+$R$67","v":-3.0425013255486704},{"$f":"+$R$67","v":-3.0425013255486704},{"$f":"+$R$67","v":-3.0425013255486704},{"$f":"+$R$67","v":-3.0425013255486704}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Total Carryover Amount ($m, \",CRCP_y5,\")\")","v":"Total Carryover Amount ($m, 2016-17)"},null,null,null,null,null,null,{"$f":"+SUM(S73:S75)","v":1.3336529021126466},{"$f":"+SUM(T73:T75)","v":1.3336529021126466},{"$f":"+SUM(U73:U75)","v":1.3336529021126466},{"$f":"+SUM(V73:V75)","v":0},{"$f":"+SUM(W73:W75)","v":-3.0425013255486704},{"$f":"SUM(S76:W76)","v":0.95845738078926956}]
[]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"PTRM inputs ($m, \",CRCP_y5,\")\")","v":"PTRM inputs ($m, 2016-17)"},null,null,null,null,null,null,{"$f":"S76","v":1.3336529021126466},{"$f":"T76","v":1.3336529021126466},{"$f":"U76","v":1.3336529021126466},{"$f":"V76","v":0},{"$f":"W76","v":-3.0425013255486704},{"$f":"SUM(S78:W78)","v":0.95845738078926956}]
[]
[null,null,"TABLE 7.5.2 - Proposed forecast opex for the EBSS for the forthcoming regulatory control period"]
[]
[null,null,null,"Forthcoming regulatory control period"]
[null,null,null,{"$f":"CONCATENATE(\"$m, real \", CRCP_y5)","v":"$m, real 2016-17"}]
[null,null,null,{"$f":"FRCP","v":"2017-18"},"2018-19","2019-20","2020-21","2021-22"]
["ED_EBS752_00001",null,"Forecast opex",215.63096793854561,209.65206018796624,210.00666264639477,211.138999102875,211.17795382680899,{"$f":"+SUM(D85:H85)","v":1057.6066437025906}]
[null,null,"Less excluded costs"]
["ED_EBS752_00002",null,"Easement land tax",114.31425505580884,114.31425505580884,114.31425505580884,114.31425505580884,114.31425505580884,{"$f":"+SUM(D87:H87)","v":571.57127527904424}]
["ED_EBS752_00003",null,"Debt raising costs",1.6052428754449257,1.6130007562727651,1.6103820445044037,1.6015373506651964,1.5832664867444013,8.0134295136316922]
["ED_EBS752_00004",null,"Rebates under the AIS",0,0,0,0,0,0]
["ED_EBS752_00005",null,"Priority projects approved under the STPIS network capability component",0,0,0,0,0,0]
["ED_EBS752_00006",null,"Self-insurance",2.7172576264139621,2.7186082387130166,2.7014798374731521,2.6947678097485968,2.6842375817454438,13.516351094094171]
["ED_EBS752_00007",null,null,0,0,0,0,0,0]
["ED_EBS752_00008",null,null,0,0,0,0,0,0]
["ED_EBS752_00009",null,null,0,0,0,0,0,0]
["ED_EBS752_00010",null,null,0,0,0,0,0,0]
["ED_EBS752_00011",null,null,0,0,0,0,0,0]
[null,null,{"$f":"CONCATENATE(\"Adjusted forecast opex ($m, \",CRCP_y5,\")\")","v":"Adjusted forecast opex ($m, 2016-17)"},{"$f":"+D85-SUM(D87:D96)","v":96.994212380877869},91.006196137171614,91.380545708608366,92.528438886652367,92.596194702510289,464.5055878158206]

{"sheet":"7.6 Indicative bill impact ","index":16,"n_rows":69,"n_cols":11,"rows_kept":69,"cut":false,"hidden":false,"merged":[[20,2,20,3],[28,2,28,3],[7,1,7,3]]}
[null,{"$f":"(LOOKUP(dms_Model,dms_Model_List,dms_Worksheet_List))","v":"REGULATORY REPORTING STATEMENT"}]
[null,{"$f":"dms_TradingName","v":"AusNet (T)"}]
[null,{"$f":"CONCATENATE(FRCP_y1,\" to \",FRCP_y5)","v":"2017-18 to 2021-22"}]
[null,"7.6 INDICATIVE IMPACT ON TRANSMISSION CHARGES AND ELECTRICITY BILLS"]
[]
[]
[null,"Table 7.6.1 Indicative impact of the revenue proposal on the average residential electricity bills"]
[null,"Instructions\nThe TNSP is required to populate all input cells (yellow) in table 7.6.1 presented below.\nTransmission pricing impact should refer to AusNet related transmission costs only."]
[]
[null,"Transmission costs as a proportion of a typical residential customer's electricity bill (per cent)",0.05]
[null,"Transmission costs as a proportion of a typical business customer's electricity bill (per cent)",0.04]
[null,"Source data:","Based on customers located in AusNet Services' distribution network.   \nCustomer numbers and energy: AusNet Services' billing data, distribution Regulatory Accounts\nDUoS/ TUoS: AusNet Services (distribution) pricing data\nProportion of bill attributed to network costs: AusNet Services (distribution) assumption, as per annual pricing proposal \nProportion of TUoS attributable to AusNet Services (not AEMO): AEMO revenue data, AusNet Services' transmission pricing data\nExpected inflation: 2.35% (see transmission Revenue Proposal)"]
[]
[null,"Typical electricity bill - Residential customer"]
[null,"Tariff type","Description of tariff type",{"$f":"CONCATENATE(\"Annual bill amount \n($\", CRCP_y5,\")\")","v":"Annual bill amount \n($2016-17)"}]
[null,"Residential","Residential",1531]
[]
[]
[null,"<NSP to insert any additional items>"]
[null,"<NSP to insert any additional items>"]
[null,"Source data:","Victorian DNSPs reset RIN data.  Calculated as the average of reported typical residential customer electricity bills weighted by reported residential customer numbers for 2015.  This has been escalated into real $2016-17 using AusNet Services' expected inflation of 2.35%."]
[]
[null,"Typical electricity bill - Business customer"]
[null,"Tariff type","Description of tariff type",{"$f":"CONCATENATE(\"Annual bill amount \n($\", CRCP_y5,\")\")","v":"Annual bill amount \n($2016-17)"}]
[null,"Small I & C","Small I & C",6714]
[null,"Large I & C","Large I & C",33255]
[null,"<NSP to insert any additional items>"]
[null,"<NSP to insert any additional items>"]
[null,"Source data:","Based on small and large I&C customers located in AusNet Services' distribution network .   \nCustomer numbers and energy: AusNet Services' billing data, distribution Regulatory Accounts\nDUoS/ TUoS: AusNet Services (distribution) pricing data\nProportion of bill attributed to network costs: AusNet Services (distribution) assumption, as per annual pricing proposal \nProportion of TUoS attributable to AusNet Services (not AEMO): AEMO revenue data, AusNet Services' transmission pricing data\nExpected inflation: 2.35% (see transmission Revenue Proposal)\n"]
[]
[null,"Indicative annual average transmission price impact as shown in the proposed PTRM (per cent)"]
[null,null,{"$f":"CRCP_y5","v":"2016-17"},{"$f":"FRCP_y1","v":"2017-18"},{"$f":"FRCP_y2","v":"2018-19"},{"$f":"FRCP_y3","v":"2019-20"},{"$f":"FRCP_y4","v":"2020-21"},{"$f":"FRCP_y5","v":"2021-22"},"Average"]
[null,"Annual price path (per cent, nominal)",null,0.1293457742108659,-1.3151460868624398E-2,-1.428724513924684E-2,-1.158878627485127E-2,-5.0818621435445577E-3,{"$f":"+AVERAGE(D33:H33)","v":1.7047283956919769E-2}]
[null,"Annual price path (per cent, $2013-14)",null,0.1110140425094599,-2.9170153338538674E-2,-3.0287501366696223E-2,-2.7632844343188467E-2,-2.1231541705405199E-2,{"$f":"+AVERAGE(D34:H34)","v":5.3840035112626692E-4}]
[]
[]
[null,"Transmission bill component - Residential customer",{"$f":"CONCATENATE(\"Real \", CRCP_y5)","v":"Real 2016-17"}]
[null,"Tariff type",{"$f":"CRCP_y5","v":"2016-17"},{"$f":"FRCP_y1","v":"2017-18"},{"$f":"FRCP_y2","v":"2018-19"},{"$f":"FRCP_y3","v":"2019-20"},{"$f":"FRCP_y4","v":"2020-21"},{"$f":"FRCP_y5","v":"2021-22"},{"$f":"CONCATENATE(\"Total \",FRCP_y1,\" to \", FRCP_y5)","v":"Total 2017-18 to 2021-22"},"Annual average","Annual impact on customer bill (%)"]
[]
[null,{"$f":"+B16","v":"Residential"},{"$f":"+D16*$C$10","v":76.55},{"$f":"+C40*(1+IF($C$37=\"Nominal\",D$33,D$34))","v":85.048124954099151},{"$f":"+D40*(1+IF($C$37=\"Nominal\",E$33,E$34))","v":82.567258108032888},{"$f":"+E40*(1+IF($C$37=\"Nominal\",F$33,F$34))","v":80.066502165241488},{"$f":"+F40*(1+IF($C$37=\"Nominal\",G$33,G$34))","v":77.854036973805805},{"$f":"+G40*(1+IF($C$37=\"Nominal\",H$33,H$34))","v":76.201075740862294},{"$f":"+SUM(D40:H40)","v":401.73699794204163},{"$f":"+AVERAGE(D40:H40)","v":80.347399588408322}]
[null,"Annual change",null,{"$f":"+D40-C40","v":8.4981249540991541},{"$f":"+E40-D40","v":-2.4808668460662631},{"$f":"+F40-E40","v":-2.5007559427914003},{"$f":"+G40-F40","v":-2.2124651914356832},{"$f":"+H40-G40","v":-1.652961232943511},{"$f":"+SUM(D41:H41)","v":-0.34892425913770353},{"$f":"+AVERAGE(D41:H41)","v":-6.9784851827540711E-2},{"$f":"+J41/D16","v":-4.5581222617596804E-5}]
[]
[null,{"$f":"+B17","v":0},{"$f":"+D17*$C$10","v":0},{"$f":"+C43*(1+IF($C$37=\"Nominal\",D$33,D$34))","v":0},{"$f":"+D43*(1+IF($C$37=\"Nominal\",E$33,E$34))","v":0},{"$f":"+E43*(1+IF($C$37=\"Nominal\",F$33,F$34))","v":0},{"$f":"+F43*(1+IF($C$37=\"Nominal\",G$33,G$34))","v":0},{"$f":"+G43*(1+IF($C$37=\"Nominal\",H$33,H$34))","v":0},0,{"$f":"+AVERAGE(D43:H43)","v":0}]
[null,"Annual change",null,{"$f":"+D43-C43","v":0},{"$f":"+E43-D43","v":0},{"$f":"+F43-E43","v":0},{"$f":"+G43-F43","v":0},{"$f":"+H43-G43","v":0},0,0,{"$f":"+J44/D17","v":{"$error":"#DIV/0!"}}]
[]
[null,{"$f":"+B18","v":0},{"$f":"+D18*$C$10","v":0},{"$f":"+C46*(1+IF($C$37=\"Nominal\",D$33,D$34))","v":0},{"$f":"+D46*(1+IF($C$37=\"Nominal\",E$33,E$34))","v":0},{"$f":"+E46*(1+IF($C$37=\"Nominal\",F$33,F$34))","v":0},{"$f":"+F46*(1+IF($C$37=\"Nominal\",G$33,G$34))","v":0},{"$f":"+G46*(1+IF($C$37=\"Nominal\",H$33,H$34))","v":0},0,0]
[null,"Annual change",null,{"$f":"+D46-C46","v":0},{"$f":"+E46-D46","v":0},{"$f":"+F46-E46","v":0},{"$f":"+G46-F46","v":0},{"$f":"+H46-G46","v":0},0,0,{"$f":"+J47/D18","v":{"$error":"#DIV/0!"}}]
[]
[null,{"$f":"+B19","v":"<NSP to insert any additional items>"},{"$f":"+D19*$C$10","v":0},{"$f":"+C49*(1+IF($C$37=\"Nominal\",D$33,D$34))","v":0},{"$f":"+D49*(1+IF($C$37=\"Nominal\",E$33,E$34))","v":0},{"$f":"+E49*(1+IF($C$37=\"Nominal\",F$33,F$34))","v":0},{"$f":"+F49*(1+IF($C$37=\"Nominal\",G$33,G$34))","v":0},{"$f":"+G49*(1+IF($C$37=\"Nominal\",H$33,H$34))","v":0},0,0]
[null,"Annual change",null,{"$f":"+D49-C49","v":0},{"$f":"+E49-D49","v":0},{"$f":"+F49-E49","v":0},{"$f":"+G49-F49","v":0},{"$f":"+H49-G49","v":0},0,0,{"$f":"+J50/D19","v":{"$error":"#DIV/0!"}}]
[]
[null,{"$f":"+B20","v":"<NSP to insert any additional items>"},{"$f":"+D20*$C$10","v":0},{"$f":"+C52*(1+IF($C$37=\"Nominal\",D$33,D$34))","v":0},{"$f":"+D52*(1+IF($C$37=\"Nominal\",E$33,E$34))","v":0},{"$f":"+E52*(1+IF($C$37=\"Nominal\",F$33,F$34))","v":0},{"$f":"+F52*(1+IF($C$37=\"Nominal\",G$33,G$34))","v":0},{"$f":"+G52*(1+IF($C$37=\"Nominal\",H$33,H$34))","v":0},{"$f":"+SUM(D52:H52)","v":0},{"$f":"+AVERAGE(D52:H52)","v":0}]
[null,"Annual change",null,{"$f":"+D52-C52","v":0},{"$f":"+E52-D52","v":0},{"$f":"+F52-E52","v":0},{"$f":"+G52-F52","v":0},{"$f":"+H52-G52","v":0},{"$f":"+SUM(D53:H53)","v":0},{"$f":"+AVERAGE(D53:H53)","v":0},{"$f":"+J53/D20","v":{"$error":"#DIV/0!"}}]
[]
[]
[null,"Transmission bill component - Business customer",{"$f":"CONCATENATE(\"Real \", CRCP_y5)","v":"Real 2016-17"}]
[null,"Tariff type",{"$f":"CRCP_y5","v":"2016-17"},{"$f":"FRCP_y1","v":"2017-18"},{"$f":"FRCP_y2","v":"2018-19"},{"$f":"FRCP_y3","v":"2019-20"},{"$f":"FRCP_y4","v":"2020-21"},{"$f":"FRCP_y5","v":"2021-22"},{"$f":"CONCATENATE(\"Total \",FRCP_y1,\" to \", FRCP_y5)","v":"Total 2017-18 to 2021-22"},"Annual average","Annual impact on customer bill (%)"]
[]
[null,{"$f":"+B25","v":"Small I & C"},{"$f":"+D25*$C$11","v":268.56},{"$f":"+C59*(1+IF($C$56=\"Nominal\",D$33,D$34))","v":298.37393125634054},{"$f":"+D59*(1+IF(D56=\"Nominal\",E$33,E$34))","v":289.67031792937047},{"$f":"+E59*(1+IF(E56=\"Nominal\",F$33,F$34))","v":280.89692777919333},{"$f":"+F59*(1+IF(F56=\"Nominal\",G$33,G$34))","v":273.13494669739106},{"$f":"+G59*(1+IF(G56=\"Nominal\",H$33,H$34))","v":267.33587068538179},{"$f":"+SUM(D59:H59)","v":1409.4119943476771},{"$f":"+AVERAGE(D59:H59)","v":281.88239886953545}]
[null,"Annual change",null,{"$f":"+D59-C59","v":29.813931256340538},{"$f":"+E59-D59","v":-8.7036133269700713},{"$f":"+F59-E59","v":-8.7733901501771356},{"$f":"+G59-F59","v":-7.7619810818022756},{"$f":"+H59-G59","v":-5.7990760120092659},{"$f":"+SUM(D60:H60)","v":-1.2241293146182102},{"$f":"+AVERAGE(D60:H60)","v":-0.24482586292364203},{"$f":"+J60/D25","v":-3.6464978094078347E-5}]
[]
[null,{"$f":"+B26","v":"Large I & C"},{"$f":"+D26*$C$11","v":1330.2},{"$f":"+C62*(1+IF(C59=\"Nominal\",D$33,D$34))","v":1477.8708793460837},{"$f":"+D62*(1+IF(D59=\"Nominal\",E$33,E$34))","v":1434.7611591809975},{"$f":"+E62*(1+IF(E59=\"Nominal\",F$33,F$34))","v":1391.3058286114203},{"$f":"+F62*(1+IF(F59=\"Nominal\",G$33,G$34))","v":1352.8600912156301},{"$f":"+G62*(1+IF(G59=\"Nominal\",H$33,H$34))","v":1324.1367857674072},6980.9347441215377,1396.1869488243076]
[null,"Annual change",null,{"$f":"+D62-C62","v":147.67087934608367},{"$f":"+E62-D62","v":-43.109720165086173},{"$f":"+F62-E62","v":-43.4553305695772},{"$f":"+G62-F62","v":-38.445737395790275},{"$f":"+H62-G62","v":-28.723305448222845},-6.0632142325928271,-1.2126428465185655,{"$f":"+J63/D26","v":-3.6464978094078049E-5}]
[]
[null,{"$f":"+B27","v":"<NSP to insert any additional items>"},{"$f":"+D27*$C$11","v":0},{"$f":"+C65*(1+IF(C62=\"Nominal\",D$33,D$34))","v":0},{"$f":"+D65*(1+IF(D62=\"Nominal\",E$33,E$34))","v":0},{"$f":"+E65*(1+IF(E62=\"Nominal\",F$33,F$34))","v":0},{"$f":"+F65*(1+IF(F62=\"Nominal\",G$33,G$34))","v":0},{"$f":"+G65*(1+IF(G62=\"Nominal\",H$33,H$34))","v":0},0,0]
[null,"Annual change",null,{"$f":"+D65-C65","v":0},{"$f":"+E65-D65","v":0},{"$f":"+F65-E65","v":0},{"$f":"+G65-F65","v":0},{"$f":"+H65-G65","v":0},0,0,{"$f":"+J66/D27","v":{"$error":"#DIV/0!"}}]
[]
[null,{"$f":"+B28","v":"<NSP to insert any additional items>"},{"$f":"+D28*$C$11","v":0},{"$f":"+C68*(1+IF(C65=\"Nominal\",D$33,D$34))","v":0},{"$f":"+D68*(1+IF(D65=\"Nominal\",E$33,E$34))","v":0},{"$f":"+E68*(1+IF(E65=\"Nominal\",F$33,F$34))","v":0},{"$f":"+F68*(1+IF(F65=\"Nominal\",G$33,G$34))","v":0},{"$f":"+G68*(1+IF(G65=\"Nominal\",H$33,H$34))","v":0},{"$f":"+SUM(D68:H68)","v":0},{"$f":"+AVERAGE(D68:H68)","v":0}]
[null,"Annual change",null,{"$f":"+D68-C68","v":0},{"$f":"+E68-D68","v":0},{"$f":"+F68-E68","v":0},{"$f":"+G68-F68","v":0},{"$f":"+H68-G68","v":0},{"$f":"+SUM(D69:H69)","v":0},{"$f":"+AVERAGE(D69:H69)","v":0},{"$f":"+J69/D28","v":{"$error":"#DIV/0!"}}]

{"sheet":"7.7 STPIS","index":17,"n_rows":166,"n_cols":15,"rows_kept":166,"cut":false,"hidden":false,"merged":[[7,1,7,5],[71,1,71,4],[10,1,11,1],[10,2,10,6],[32,13,33,13],[54,1,54,4],[32,14,33,14],[10,11,11,11],[32,1,33,1],[32,2,33,2],[32,4,33,4],[32,5,32,12],[10,7,11,7],[10,8,11,8],[10,9,11,9],[10,10,11,10],[10,12,11,12],[32,3,33,3],[29,1,29,4]]}
[null,{"$f":"(LOOKUP(dms_Model,dms_Model_List,dms_Worksheet_List))","v":"REGULATORY REPORTING STATEMENT"}]
[null,{"$f":"dms_TradingName","v":"AusNet (T)"}]
[null,{"$f":"CONCATENATE(FRCP_y1,\" to \",FRCP_y5)","v":"2017-18 to 2021-22"}]
[null,"7.7 SERVICE TARGET PERFORMANCE INCENTIVE SCHEME (STPIS)"]
[]
[]
[null,"Instructions"]
[null,{"$f":"dms_TradingName&\" is required to provide the performance actuals for the most recent five years, and the proposed caps, collars and targets for the next regulatory control period for the parameters under the service component of the STPIS in table 7.7.1 below.\"","v":"AusNet (T) is required to provide the performance actuals for the most recent five years, and the proposed caps, collars and targets for the next regulatory control period for the parameters under the service component of the STPIS in table 7.7.1 below."}]
[]
[null,"Table 7.7.1 Historical performance and proposed caps, collars and targets for the service component of the STPIS"]
[null,"Parameter","Performance actuals",null,null,null,null,"Average of actual performance","Collar","Target","Cap","Weighting (% of MAR)"]
[null,null,{"$f":"LEFT(PRCP_y3,2)&RIGHT(PRCP_y3,2)","v":"2010"},{"$f":"(LEFT(PRCP_y4,2)&RIGHT(PRCP_y4,2))","v":"2011"},{"$f":"LEFT(PRCP_y5,2)&RIGHT(PRCP_y5,2)","v":"2012"},{"$f":"(LEFT(CRCP_y1,2)&RIGHT(CRCP_y1,2))","v":"2013"},{"$f":"(LEFT(CRCP_y2,2)&RIGHT(CRCP_y2,2))","v":"2014"}]
[null,"Unplanned circuit outage event rate (per cent):"]
[null,"Transmission line outage - fault","Refer to unlocked sheet.",null,null,null,null,{"$f":"+AVERAGE(C14:G14)","v":{"$error":"#DIV/0!"}},null,null,null,2E-3]
[null,"Transformer outage – fault ",null,null,null,null,null,{"$f":"+AVERAGE(C15:G15)","v":{"$error":"#DIV/0!"}},null,null,null,2E-3]
[null,"Reactive plant – fault ",null,null,null,null,null,{"$error":"#DIV/0!"},null,null,null,1E-3]
[null,"Transmission line outage – forced outage",null,null,null,null,null,{"$error":"#DIV/0!"},null,null,null,1E-3]
[null,"Transformer outage – forced outage",null,null,null,null,null,{"$error":"#DIV/0!"},null,null,null,1E-3]
[null,"Reactive plant – forced outage",null,null,null,null,null,{"$error":"#DIV/0!"},null,null,null,5.0000000000000001E-4]
[null,"Loss of supply event frequency (minutes):"]
[null,">  (x) system minutes",null,null,null,null,null,{"$error":"#DIV/0!"},null,null,null,1.5E-3]
[null,">  (y) system minutes",null,null,null,null,null,{"$error":"#DIV/0!"},null,null,null,1.5E-3]
[null,"Average outage duration (minutes): ",null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,"Proper operation of equipment (number of events):"]
[null,"Failure of protection system",null,null,null,null,null,{"$error":"#DIV/0!"},null,null,null,0]
[null,"Material failure of SCADA",null,null,null,null,null,{"$error":"#DIV/0!"},null,null,null,0]
[null,"Incorrect operational isolation of primary or secondary equipment",null,null,null,null,null,{"$error":"#DIV/0!"},null,null,null,0]
[]
[null,"Instructions"]
[null,{"$f":"dms_TradingName&\" is required to provide a list of proposed priority projects for the network capability incentive parameter including a brief description and the cost for each proposed project in table 7.7.2 below.\"","v":"AusNet (T) is required to provide a list of proposed priority projects for the network capability incentive parameter including a brief description and the cost for each proposed project in table 7.7.2 below."}]
[]
[null,"Table 7.7.2 - Proposed priority projects for the network capability incentive parameter"]
[null,"Project ranking","Project/ Injection Point","Description",{"$f":"CONCATENATE((\"If applicable, the present value of quantified benefits associated with the project\n ($million, \"),CRCP_y5)","v":"If applicable, the present value of quantified benefits associated with the project\n ($million, 2016-17"},{"$f":"CONCATENATE((\"Project cost ($million, \"),FRCP_y1)","v":"Project cost ($million, 2017-18"},null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Total proposed MAR for the \",FRCP_y1,\" to \",FRCP_y5,\" regulatory control period ($million, \",CRCP_y5)","v":"Total proposed MAR for the 2017-18 to 2021-22 regulatory control period ($million, 2016-17"},"Project cost as a proportion of the MAR"]
[null,null,null,null,null,{"$f":"FRCP_y1","v":"2017-18"},{"$f":"FRCP_y2","v":"2018-19"},{"$f":"FRCP_y3","v":"2019-20"},{"$f":"FRCP_y4","v":"2020-21"},{"$f":"FRCP_y5","v":"2021-22"},"Opex","Capex","Total cost"]
[null,1,"Hazelwood to Jeeralang 220 kV No. 4 line","Replace the existing interplant connections of the Hazelwood to Jeeralang 220 kV No.4 line at Hazelwood power station",1.9873540664130687,0.10707800000000001,0,0,0,0,0,0.10707800000000001,{"$f":"+SUM(K35:L35)","v":0.10707800000000001},2826.0568951244595,{"$f":"+M35/N35","v":3.7889541496751887E-5}]
[null,2,"South East to Heywood 275 kV No.1 and No. 2 lines ","Increase the operating temperature of the South East to Heywood 275 kV lines from 90°C to 100°C.",0.16847608222347643,1.8138000000000001E-2,0,0,0,0,0,1.8138000000000001E-2,{"$f":"+SUM(K36:L36)","v":1.8138000000000001E-2},{"$f":"+$N$35","v":2826.0568951244595},{"$f":"+M36/N36","v":6.4181298088130688E-6}]
[null,3,null,null,null,null,null,null,null,null,null,null,{"$f":"+SUM(K37:L37)","v":0},{"$f":"+$N$35","v":2826.0568951244595},0]
[null,4,null,null,null,null,null,null,null,null,null,null,0,2826.0568951244595,0]
[null,5,null,null,null,null,null,null,null,null,null,null,0,2826.0568951244595,0]
[null,6,null,null,null,null,null,null,null,null,null,null,0,2826.0568951244595,0]
[null,7,null,null,null,null,null,null,null,null,null,null,0,2826.0568951244595,0]
[null,8,null,null,null,null,null,null,null,null,null,null,0,2826.0568951244595,0]
[null,9,null,null,null,null,null,null,null,null,null,null,0,2826.0568951244595,0]
[null,10,null,null,null,null,null,null,null,null,null,null,0,2826.0568951244595,0]
[null,11,null,null,null,null,null,null,null,null,null,null,0,2826.0568951244595,0]
[null,12,null,null,null,null,null,null,null,null,null,null,0,2826.0568951244595,0]
[null,13,null,null,null,null,null,null,null,null,null,null,0,2826.0568951244595,0]
[null,14,null,null,null,null,null,null,null,null,null,null,0,2826.0568951244595,0]
[null,15,null,null,null,null,null,null,null,null,null,null,0,2826.0568951244595,0]
[null,16,null,null,null,null,null,null,null,null,null,null,0,2826.0568951244595,0]
[null,"<NSP to insert additional lines if required>",null,null,null,null,null,null,null,null,null,null,0,2826.0568951244595,0]
[]
[]
[null,"Instructions"]
[null,{"$f":"dms_TradingName&\" is required to provide the following information in table 7.7.3 below.\"","v":"AusNet (T) is required to provide the following information in table 7.7.3 below."}]
[]
[null,"Table 7.7.3 – Limits identified for proposed priority projects"]
[null,"Limit identification ","Define limit  ","Reason for the limit ","Is limit addressed by priority project"]
[null,"HWPS - JLTS No.4 220 kV line","23 MVA lower than line short term rating","Interplant connection at HWPS with lower rating than line short term rating","Yes"]
[null,"SESS - HYTS No.1 275 kV line","The short term (15 min) rating of this line is 58MVA lower than the short term rating of the Tailem Bend to South East 275 kV line at 35°C","The South East to Heywood lines will become the limiting elements constraining flows on the interconnector between Victoria and South Australia following the interconnector upgrade project and ElectraNet’s proposed NCIPAP project to uprate the 275 kV lines between South East and Tailem Bend to 120°C.  ","Yes"]
[null,"SESS - HYTS No.2 275 kV line","The short term (15 min) rating of this line is 58MVA lower than the short term rating of the Tailem Bend to South East 275 kV line at 35°C","The South East to Heywood lines will become the limiting elements constraining flows on the interconnector between Victoria and South Australia following the interconnector upgrade project and ElectraNet’s proposed NCIPAP project to uprate the 275 kV lines between South East and Tailem Bend to 120°C.  ","Yes"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Instructions"]
[null,{"$f":"dms_TradingName&\" is required to provide performance data in accordance with Appendix C of the STPIS for the preceding six calendar years in table 7.7.4 below.\n\n\"&dms_TradingName&\" is also required to provide relevant information in the MIC workbook attached to Appendix G of the Notice.\"","v":"AusNet (T) is required to provide performance data in accordance with Appendix C of the STPIS for the preceding six calendar years in table 7.7.4 below.\n\nAusNet (T) is also required to provide relevant information in the MIC workbook attached to Appendix G of the Notice."}]
[]
[null,"Table 7.7.4 - Market impact component"]
[null,"Year","Month","Market impact parameter count (DI) (without exclusions)","Market impact parameter count (DI) (with exclusions)","Market impact parameters (Hrs)"]
[null,{"$f":"LEFT(PRCP_y2,4)","v":"2008"},"January",null,null,{"$f":"+E76/12","v":0}]
[null,"2008","February",null,null,{"$f":"+E77/12","v":0}]
[null,"2008","March",null,null,0]
[null,"2008","April",null,null,0]
[null,"2008","May",null,null,0]
[null,"2008","June",null,null,0]
[null,"2008","July",null,null,0]
[null,"2008","August",null,null,0]
[null,"2008","September",null,null,0]
[null,"2008","October",null,null,0]
[null,"2008","November",null,null,0]
[null,"2008","December",null,null,0]
[null,{"$f":"CONCATENATE(\"Total \",LEFT(PRCP_y2,4))","v":"Total 2008"},null,{"$f":"+SUM(D76:D87)","v":0},{"$f":"+SUM(E76:E87)","v":0},{"$f":"+SUM(F76:F87)","v":0}]
[null,{"$f":"LEFT(PRCP_y3,4)","v":"2009"},"January","Refer to unlocked sheet",null,{"$f":"+E89/12","v":0}]
[null,"2009","February",null,null,{"$f":"+E90/12","v":0}]
[null,"2009","March",null,null,0]
[null,"2009","April",null,null,0]
[null,"2009","May",null,null,0]
[null,"2009","June",null,null,0]
[null,"2009","July",null,null,0]
[null,"2009","August",null,null,0]
[null,"2009","September",null,null,0]
[null,"2009","October",null,null,0]
[null,"2009","November",null,null,0]
[null,"2009","December",null,null,0]
[null,{"$f":"CONCATENATE(\"Total \", LEFT(PRCP_y3,4))","v":"Total 2009"},null,{"$f":"+SUM(D89:D100)","v":0},{"$f":"+SUM(E89:E100)","v":0},{"$f":"+SUM(F89:F100)","v":0}]
[null,{"$f":"LEFT(PRCP_y4,4)","v":"2010"},"January",null,null,{"$f":"+E102/12","v":0}]
[null,"2010","February",null,null,{"$f":"+E103/12","v":0}]
[null,"2010","March",null,null,0]
[null,"2010","April",null,null,0]
[null,"2010","May",null,null,0]
[null,"2010","June",null,null,0]
[null,"2010","July",null,null,0]
[null,"2010","August",null,null,0]
[null,"2010","September",null,null,0]
[null,"2010","October",null,null,0]
[null,"2010","November",null,null,0]
[null,"2010","December",null,null,0]
[null,{"$f":"CONCATENATE(\"Total \", LEFT(PRCP_y4,4))","v":"Total 2010"},null,{"$f":"+SUM(D102:D113)","v":0},{"$f":"+SUM(E102:E113)","v":0},{"$f":"+SUM(F102:F113)","v":0}]
[null,{"$f":"LEFT(PRCP_y5,4)","v":"2011"},"January",null,null,{"$f":"+E115/12","v":0}]
[null,"2011","February",null,null,{"$f":"+E116/12","v":0}]
[null,"2011","March",null,null,0]
[null,"2011","April",null,null,0]
[null,"2011","May",null,null,0]
[null,"2011","June",null,null,0]
[null,"2011","July",null,null,0]
[null,"2011","August",null,null,0]
[null,"2011","September",null,null,0]
[null,"2011","October",null,null,0]
[null,"2011","November",null,null,0]
[null,"2011","December",null,null,0]
[null,{"$f":"CONCATENATE(\"Total \", LEFT(PRCP_y5,4))","v":"Total 2011"},null,{"$f":"+SUM(D115:D126)","v":0},{"$f":"+SUM(E115:E126)","v":0},{"$f":"+SUM(F115:F126)","v":0}]
[null,{"$f":"LEFT(CRCP_y1,4)","v":"2012"},"January",null,null,{"$f":"+E128/12","v":0}]
[null,"2012","February",null,null,{"$f":"+E129/12","v":0}]
[null,"2012","March",null,null,0]
[null,"2012","April",null,null,0]
[null,"2012","May",null,null,0]
[null,"2012","June",null,null,0]
[null,"2012","July",null,null,0]
[null,"2012","August",null,null,0]
[null,"2012","September",null,null,0]
[null,"2012","October",null,null,0]
[null,"2012","November",null,null,0]
[null,"2012","December",null,null,0]
[null,{"$f":"CONCATENATE(\"Total \", LEFT(CRCP_y1,4))","v":"Total 2012"},null,{"$f":"+SUM(D128:D139)","v":0},{"$f":"+SUM(E128:E139)","v":0},{"$f":"+SUM(F128:F139)","v":0}]
[null,{"$f":"LEFT(CRCP_y2,4)","v":"2013"},"January",null,null,{"$f":"+E141/12","v":0}]
[null,"2013","February",null,null,{"$f":"+E142/12","v":0}]
[null,"2013","March",null,null,0]
[null,"2013","April",null,null,0]
[null,"2013","May",null,null,0]
[null,"2013","June",null,null,0]
[null,"2013","July",null,null,0]
[null,"2013","August",null,null,0]
[null,"2013","September",null,null,0]
[null,"2013","October",null,null,0]
[null,"2013","November",null,null,0]
[null,"2013","December",null,null,0]
[null,{"$f":"CONCATENATE(\"Total \", LEFT(CRCP_y2,4))","v":"Total 2013"},null,{"$f":"+SUM(D141:D152)","v":0},{"$f":"+SUM(E141:E152)","v":0},{"$f":"+SUM(F141:F152)","v":0}]
[null,{"$f":"LEFT(CRCP_y3,4)","v":"2014"},"January",null,null,{"$f":"+E154/12","v":0}]
[null,"2014","February",null,null,{"$f":"+E155/12","v":0}]
[null,"2014","March",null,null,0]
[null,"2014","April",null,null,0]
[null,"2014","May",null,null,0]
[null,"2014","June",null,null,0]
[null,"2014","July",null,null,0]
[null,"2014","August",null,null,0]
[null,"2014","September",null,null,0]
[null,"2014","October",null,null,0]
[null,"2014","November",null,null,0]
[null,"2014","December",null,null,0]
[null,{"$f":"CONCATENATE(\"Total \", LEFT(CRCP_y3,4))","v":"Total 2014"},null,{"$f":"+SUM(D154:D165)","v":0},{"$f":"+SUM(E154:E165)","v":0},{"$f":"+SUM(F154:F165)","v":0}]

{"sheet":"2.10.2, 2.17.1, 7.7.1","index":18,"n_rows":164,"n_cols":13,"rows_kept":164,"cut":false,"hidden":false,"merged":[[22,1,22,2],[22,3,22,5],[22,6,22,12],[35,1,35,2],[2,4,2,10],[4,1,16,1],[4,2,14,2],[39,10,40,10],[39,11,40,11],[39,1,40,1],[39,2,39,6],[39,7,40,7],[39,8,40,8],[39,9,40,9]]}
[]
[null,"TABLE 2.10.2 - CORPORATE OVERHEADS EXPENDITURE"]
[null,null,null,null,{"$f":"CONCATENATE(\"EXPENDITURE\nForecast \n($0's. real \",dms_DollarReal,\")\")","v":"EXPENDITURE\nForecast \n($0's. real March 2017)"}]
[null,null,null,null,{"$f":"CRCP_y4","v":"2015-16"},{"$f":"CRCP_y5","v":"2016-17"},{"$f":"FRCP_y1","v":"2017-18"},{"$f":"FRCP_y2","v":"2018-19"},{"$f":"FRCP_y3","v":"2019-20"},{"$f":"FRCP_y4","v":"2020-21"},{"$f":"FRCP_y5","v":"2021-22"}]
[null,"CORPORATE OVERHEADS","Total Overhead Expenditure - Prescribed Services","TAXES AND CHARGES",null,3894825.7998085637,3398320.327660732,3567431.4000875996,4152169.7452951842,4322466.5855824854,4459908.1295010773]
[null,null,null,"INSURANCE",null,3675136.9681985793,3206637.0379338996,3366209.3489826345,3917965.350316836,4078656.5456298674,4208345.6575399125]
[null,null,null,"SELF-INSURANCE",null,1829721.0984883108,2717257.6264139619,2718608.2387130167,2701479.8374731522,2694767.809748597,2684237.5817454439]
[null,null,null,"OH&S",null,930513.28549378703,937526.83098063082,944426.57946433953,950082.14152727148,928190.53990744811,918015.88199775387]
[null,null,null,"FINANCE",null,5864808.9515870595,5896813.3520747218,5937432.0825761715,5979262.9533379357,5950110.2664383035,5951597.8375330493]
[null,null,null,"HR",null,4613938.0442692833,4644278.4439247856,4677447.6383951604,4707739.6652354226,4638760.3560825652,4612168.1433677627]
[null,null,null,"IT SUPPORT",null,1680635.9130318942,1730219.2974227301,1751361.5881117128,1742861.1346954592,1374037.9568474032,1157119.2366390089]
[null,null,null,"OTHER ",null,4207755.2642497728,4315336.1458813483,4364375.6505845552,4351488.4478987092,3575785.1524689319,3121752.9940428021]
[null,null,null,"AVAILABILITY REBATE",null,0,0,0,0,0,0]
[null,null,null,"EASEMENT TAX",null,114314255.05580883,114314255.05580884,114314255.05580884,114314255.05580884,114314255.05580884,114314255.05580884]
[]
[null,null,"Total Overhead Expenditure - Negotiated Services","Total"]
[null,null,"Total Overhead Expenditure - Unregulated Services","Total"]
[]
[]
[]
[]
[null,"Table 2.17.1  Forecast opex step changes"]
[null,null,null,"Actual \n($0's, nominal)",null,null,{"$f":"CONCATENATE(\"Forecast ($0's, real \", dms_DollarReal, \")\")","v":"Forecast ($0's, real March 2017)"}]
[null,"Step change","Description",{"$f":"CRCP_y1","v":"2012-13"},{"$f":"CRCP_y2","v":"2013-14"},{"$f":"CRCP_y3","v":"2014-15"},{"$f":"CRCP_y4","v":"2015-16"},{"$f":"CRCP_y5","v":"2016-17"},{"$f":"FRCP_y1","v":"2017-18"},{"$f":"FRCP_y2","v":"2018-19"},{"$f":"FRCP_y3","v":"2019-20"},{"$f":"FRCP_y4","v":"2020-21"},{"$f":"FRCP_y5","v":"2021-22"}]
[null,"AEMO Power System Security Functions Agreement ","As per 2014-17 determination (referred to as \"AEMO operating agreement\" in AER final decision)",0,22240.19519618557,30294.437464352319,32092.455795677808,32092.455795677808]
[null,"Transitional arrangements for the Economic Regulation of NSP’s rule change","As per 2014-17 determination",324817.51125902601,328357.4862633642,531667.13662116125,1176723.379174853,855798.82121807477]
[null,"Fire services levy","As per 2014-17 determination",0,112885.44,109308.74,1005793.6108644403,1005793.6108644403]
[null,"Controller simulator training","As per 2014-17 determination",0,0,0,327984.89823182719,327984.89823182719]
[null,"Security of critical infrastructure","As per 2014-17 determination",0,0,40392.583285803092,42789.941060903744,42789.941060903744]
[null,"Establishment of IT security team","As per 2017-22 Revenue Proposal",0,0,0,0,656000,656000,656000,656000,656000,656000]
[null,"Roll out of SAIP","As per 2017-22 Revenue Proposal",0,0,125649.64,103454.81053233215,103454.81053233215,349157.2317249137,349157.2317249137,73168.305278504224,73168.305278504224,73168.305278504224]
[null,"Lease of WMTS 22kV mobile switchboard","As per 2017-22 Revenue Proposal",0,0,0,25886.407242448207,51772.814484896415,709287.55844308087,300282.32401239924,265076.81016266963,697897.53925640369,51772.814484896415]
[null,"Decommissioning of synchronous condensers","As per 2017-22 Revenue Proposal",0,0,0,0,0,3989340.8828636948,-270000,-270000,-270000,-270000]
[null,"Decommissioning of Morwell Power Station assets","As per 2017-22 Revenue Proposal",0,0,0,0,0,1889778.6412781153,-2000,-2000,-2000,-2000]
[null,"Decommissioning of Morwell Power Station assets","As per 2017-22 Revenue Proposal",0,0,0,0,0,1891778.6412781151,0,0,0,0]
[null,null,null,324817.51125902601,463483.12145954976,837312.53737131669,2714725.5029024822,3075687.3521881527,7593564.3143098047,1033439.5557373129,722245.1154411739,1155065.844534908,508941.11976340064]
[]
[]
[null,"Table 7.7.1 Historical performance and proposed caps, collars and targets for the service component of the STPIS"]
[null,"Parameter","Performance actuals",null,null,null,null,"Average of actual performance","Collar","Target","Cap","Weighting (% of MAR)"]
[null,null,2011,2012,2013,2014,2015]
[null,"Unplanned circuit outage event rate (per cent):"]
[null,"Transmission line outage - fault",0.2437,0.32500000000000001,0.20660999999999999,0.30578512396694213,0.19008264462809918,{"$f":"+AVERAGE(C43:G43)","v":0.25423555371900824},0.33810000000000001,0.25423555371900824,0.15970000000000001,2E-3]
[null,"Transformer outage – fault ",0.11904761904761904,0.2125984251968504,0.3125,0.2283464566929134,0.14285714285714285,{"$f":"+AVERAGE(C44:G44)","v":0.20306992875890514},0.31769999999999998,0.20306992875890514,9.1600000000000001E-2,2E-3]
[null,"Reactive plant – fault ",0.34286,0.45713999999999999,0.47143000000000002,0.25714285714285712,0.18571428571428572,0.34285742857142859,0.61170000000000002,0.34285742857142859,0.184,1E-3]
[null,"Transmission line outage – forced outage",0.16807,0.14166999999999999,0.12397,0.15702479338842976,0.15702479338842976,0.14955191735537193,0.17050000000000001,0.14955191735537193,0.12330000000000001,1E-3]
[null,"Transformer outage – forced outage",4.7619047619047616E-2,0.13385826771653545,0.109375,0.11811023622047244,0.1111111111111111,0.10401473253343334,0.14399999999999999,0.10401473253343334,6.0999999999999999E-2,1E-3]
[null,"Reactive plant – forced outage",0.22857,0.22857,0.35714000000000001,0.38571428571428573,0.34285714285714286,0.30857028571428574,0.40679999999999999,0.30857028571428574,0.19889999999999999,5.0000000000000001E-4]
[null,"Loss of supply event frequency (minutes):"]
[null,">  (x) system minutes",0,2,5,3,2,2.4,5,2,0,1.5E-3]
[null,">  (y) system minutes",0,1,1,0,1,0.6,2,1,0,1.5E-3]
[null,"Average outage duration (minutes): ",4,230,19.899999999999999,24,97.5,75.08,334.2004,75.08,3.3786]
[null,"Proper operation of equipment (number of events):"]
[null,"Failure of protection system",23,33,41,33,30,32,42,32,23,0]
[null,"Material failure of SCADA",0,1,6,2,0,1.8,4,1.8,0,0]
[null,"Incorrect operational isolation of primary or secondary equipment",5,8,4,6,5,5.6,10,5.6,2,0]
[]
[]
[null,"Table 7.7.4 - Market impact component"]
[null,"Year","Month","Market impact parameter count (DI) (without exclusions)","Market impact parameter count (DI) (with exclusions)","Market impact parameters (Hrs)"]
[null,{"$f":"LEFT(PRCP_y2,4)","v":"2008"},"January"]
[null,"2008","February"]
[null,"2008","March"]
[null,"2008","April"]
[null,"2008","May"]
[null,"2008","June"]
[null,"2008","July"]
[null,"2008","August"]
[null,"2008","September"]
[null,"2008","October"]
[null,"2008","November"]
[null,"2008","December"]
[null,{"$f":"CONCATENATE(\"Total \",LEFT(PRCP_y2,4))","v":"Total 2008"},null,{"$f":"+SUM(D61:D72)","v":0},{"$f":"+SUM(E61:E72)","v":0},{"$f":"+SUM(F61:F72)","v":0}]
[null,{"$f":"LEFT(PRCP_y3,4)","v":"2009"},"January",135,135,{"$f":"+E74/12","v":11.25}]
[null,"2009","February",358,82,{"$f":"+E75/12","v":6.833333333333333}]
[null,"2009","March",46,24,2]
[null,"2009","April",290,290,24.166666666666668]
[null,"2009","May",335,313,26.083333333333332]
[null,"2009","June",41,22,1.8333333333333333]
[null,"2009","July",25,25,2.0833333333333335]
[null,"2009","August",1,1,8.3333333333333329E-2]
[null,"2009","September",259,260,21.666666666666668]
[null,"2009","October",82,82,6.833333333333333]
[null,"2009","November",149,149,12.416666666666666]
[null,"2009","December",34,34,2.8333333333333335]
[null,{"$f":"CONCATENATE(\"Total \", LEFT(PRCP_y3,4))","v":"Total 2009"},null,{"$f":"+SUM(D74:D85)","v":1755},{"$f":"+SUM(E74:E85)","v":1417},{"$f":"+SUM(F74:F85)","v":118.08333333333331}]
[null,{"$f":"LEFT(PRCP_y4,4)","v":"2010"},"January",375,314,{"$f":"+E87/12","v":26.166666666666668}]
[null,"2010","February",264,264,{"$f":"+E88/12","v":22}]
[null,"2010","March",229,229,19.083333333333332]
[null,"2010","April",206,206,17.166666666666668]
[null,"2010","May",0,0,0]
[null,"2010","June",322,321,26.75]
[null,"2010","July",117,45,3.75]
[null,"2010","August",8,3,0.25]
[null,"2010","September",157,157,13.083333333333334]
[null,"2010","October",117,117,9.75]
[null,"2010","November",399,398,33.166666666666664]
[null,"2010","December",80,80,6.666666666666667]
[null,{"$f":"CONCATENATE(\"Total \", LEFT(PRCP_y4,4))","v":"Total 2010"},null,{"$f":"+SUM(D87:D98)","v":2274},{"$f":"+SUM(E87:E98)","v":2134},{"$f":"+SUM(F87:F98)","v":177.83333333333331}]
[null,{"$f":"LEFT(PRCP_y5,4)","v":"2011"},"January",27,24,{"$f":"+E100/12","v":2}]
[null,"2011","February",524,488,{"$f":"+E101/12","v":40.666666666666664}]
[null,"2011","March",355,41,3.4166666666666665]
[null,"2011","April",22,22,1.8333333333333333]
[null,"2011","May",583,426,35.5]
[null,"2011","June",253,42,3.5]
[null,"2011","July",74,20,1.6666666666666667]
[null,"2011","August",210,181,15.083333333333334]
[null,"2011","September",410,321,26.75]
[null,"2011","October",1081,897,74.75]
[null,"2011","November",109,90,7.5]
[null,"2011","December",135,135,11.25]
[null,{"$f":"CONCATENATE(\"Total \", LEFT(PRCP_y5,4))","v":"Total 2011"},null,{"$f":"+SUM(D100:D111)","v":3783},{"$f":"+SUM(E100:E111)","v":2687},{"$f":"+SUM(F100:F111)","v":223.91666666666666}]
[null,{"$f":"LEFT(CRCP_y1,4)","v":"2012"},"January",326,326,{"$f":"+E113/12","v":27.166666666666668}]
[null,"2012","February",130,130,{"$f":"+E114/12","v":10.833333333333334}]
[null,"2012","March",281,5,0.41666666666666669]
[null,"2012","April",412,57,4.75]
[null,"2012","May",170,124,10.333333333333334]
[null,"2012","June",273,48,4]
[null,"2012","July",80,6,0.5]
[null,"2012","August",239,18,1.5]
[null,"2012","September",64,8,0.66666666666666663]
[null,"2012","October",141,141,11.75]
[null,"2012","November",355,25,2.0833333333333335]
[null,"2012","December",104,21,1.75]
[null,{"$f":"CONCATENATE(\"Total \", LEFT(CRCP_y1,4))","v":"Total 2012"},null,{"$f":"+SUM(D113:D124)","v":2575},{"$f":"+SUM(E113:E124)","v":909},{"$f":"+SUM(F113:F124)","v":75.749999999999986}]
[null,{"$f":"LEFT(CRCP_y2,4)","v":"2013"},"January",70,56,{"$f":"+E126/12","v":4.666666666666667}]
[null,"2013","February",98,51,{"$f":"+E127/12","v":4.25}]
[null,"2013","March",967,98,8.1666666666666661]
[null,"2013","April",105,105,8.75]
[null,"2013","May",121,null,0]
[null,"2013","June",138,null,0]
[null,"2013","July",86,0,0]
[null,"2013","August",119,12,1]
[null,"2013","September",161,151,12.583333333333334]
[null,"2013","October",283,270,22.5]
[null,"2013","November",28,null,0]
[null,"2013","December",14,2,{"$f":"+E137/12","v":0.16666666666666666}]
[null,{"$f":"CONCATENATE(\"Total \", LEFT(CRCP_y2,4))","v":"Total 2013"},null,{"$f":"+SUM(D126:D137)","v":2190},{"$f":"+SUM(E126:E137)","v":745},{"$f":"+SUM(F126:F137)","v":62.083333333333336}]
[null,{"$f":"LEFT(CRCP_y3,4)","v":"2014"},"January",86,78,{"$f":"+E139/12","v":6.5}]
[null,"2014","February",0,0,{"$f":"+E140/12","v":0}]
[null,"2014","March",8,0,0]
[null,"2014","April",44,17,1.4166666666666667]
[null,"2014","May",124,111,9.25]
[null,"2014","June",111,96,8]
[null,"2014","July",67,50,4.166666666666667]
[null,"2014","August",37,37,3.0833333333333335]
[null,"2014","September",227,169,14.083333333333334]
[null,"2014","October",173.5,172.5,14.375]
[null,"2014","November",80,75,6.25]
[null,"2014","December",61,46,3.8333333333333335]
[null,{"$f":"CONCATENATE(\"Total \", LEFT(CRCP_y3,4))","v":"Total 2014"},null,{"$f":"+SUM(D139:D150)","v":1018.5},{"$f":"+SUM(E139:E150)","v":851.5},{"$f":"+SUM(F139:F150)","v":70.958333333333329}]
[null,{"$f":"LEFT(CRCP_y4,4)","v":"2015"},"January",220,0,{"$f":"+E152/12","v":0}]
[null,"2015","February",253,185,{"$f":"+E153/12","v":15.416666666666666}]
[null,"2015","March",95,18,1.5]
[null,"2015","April",594,103,8.5833333333333339]
[null,"2015","May",354,92.49,7.7074999999999996]
[null,"2015","June",24,0,0]
[null,"2015","July",1171,0,0]
[null,"2015","August",430,0,0]
[null,"2015","September",939,46,3.8333333333333335]
[null,"2015","October",722,253,21.083333333333332]
[null,"2015","November",427,119,9.9166666666666661]
[null,"2015","December",518,150,12.5]
[null,{"$f":"CONCATENATE(\"Total \", LEFT(CRCP_y4,4))","v":"Total 2015"},null,{"$f":"+SUM(D152:D163)","v":5747},{"$f":"+SUM(E152:E163)","v":966.49},{"$f":"+SUM(F152:F163)","v":80.540833333333339}]

{"sheet":"Unprotected 2.2 Repex ","index":19,"n_rows":199,"n_cols":24,"rows_kept":199,"cut":false,"hidden":false,"merged":[[6,3,6,9],[6,10,6,16],[6,17,6,23],[7,3,7,9],[7,10,7,16],[7,17,7,23]]}
[null,{"$f":"(LOOKUP(dms_Model,dms_Model_List,dms_Worksheet_List))","v":"REGULATORY REPORTING STATEMENT"}]
[null,{"$f":"dms_TradingName","v":"AusNet (T)"}]
[null,{"$f":"CONCATENATE(FRCP_y1,\" to \",FRCP_y5)","v":"2017-18 to 2021-22"}]
[null,"2.2 REPEX"]
[]
[null,"TABLE 2.2.1 - REPLACEMENT EXPENDITURE, VOLUMES AND ASSET FAILURES BY ASSET CATEGORY"]
[null,null,null,"EXPENDITURE",null,null,null,null,null,null,"ASSET REPLACEMENTS",null,null,null,null,null,null,"ASSET FAILURES"]
[null,null,null,{"$f":"CONCATENATE(\"Forecast \n($0's. real \",dms_DollarReal,\")\")","v":"Forecast \n($0's. real March 2017)"},null,null,null,null,null,null,{"$f":"CONCATENATE(\"Forecast \n($0's. real \",dms_DollarReal,\")\")","v":"Forecast \n($0's. real March 2017)"},null,null,null,null,null,null,{"$f":"CONCATENATE(\"Forecast \n($0's. real \",dms_DollarReal,\")\")","v":"Forecast \n($0's. real March 2017)"}]
[null,"ASSET GROUP","ASSET CATEGORY",{"$f":"CRCP_y4","v":"2015-16"},{"$f":"CRCP_y5","v":"2016-17"},{"$f":"FRCP_y1","v":"2017-18"},{"$f":"FRCP_y2","v":"2018-19"},{"$f":"FRCP_y3","v":"2019-20"},{"$f":"FRCP_y4","v":"2020-21"},{"$f":"FRCP_y5","v":"2021-22"},{"$f":"CRCP_y4","v":"2015-16"},{"$f":"CRCP_y5","v":"2016-17"},{"$f":"FRCP_y1","v":"2017-18"},{"$f":"FRCP_y2","v":"2018-19"},{"$f":"FRCP_y3","v":"2019-20"},{"$f":"FRCP_y4","v":"2020-21"},{"$f":"FRCP_y5","v":"2021-22"},{"$f":"CRCP_y4","v":"2015-16"},{"$f":"CRCP_y5","v":"2016-17"},{"$f":"FRCP_y1","v":"2017-18"},{"$f":"FRCP_y2","v":"2018-19"},{"$f":"FRCP_y3","v":"2019-20"},{"$f":"FRCP_y4","v":"2020-21"},{"$f":"FRCP_y5","v":"2021-22"}]
[null,"TRANSMISSION TOWERS\nHighest operating voltage; Circuit configuration","< = 33 kV; Single Circuit",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"> 33 kV & < = 66 kV ; Single Circuit",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"> 66 kV & < = 132 kV ; Single Circuit",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"> 132 kV & < = 275 kV ; Single Circuit",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"> 275 kV & < = 330 kV ; Single Circuit",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"> 330 kV & < = 500 kV  ; Single Circuit",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"> 500 kV  ; Single Circuit",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"< = 33 kV; Multiple Circuit",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"> 33 kV & < = 66 kV ; Multiple Circuit",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"> 66 kV & < = 132 kV ; Multiple Circuit",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"> 132 kV & < = 275 kV ; Multiple Circuit",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"> 275 kV & < = 330 kV ; Multiple Circuit",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"> 330 kV & < = 500 kV  ; Multiple Circuit",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"> 500 kV  ; Multiple Circuit",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Other",1981109.0823872183,0,23832.232006657636,3613371.4361187387,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"TRANSMISSION TOWER SUPPORT STRUCTURES BY:\nHighest operating voltage; Circuit configuration","< = 33 kV; Single Circuit",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"> 33 kV & < = 66 kV ; Single Circuit",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"> 66 kV & < = 132 kV ; Single Circuit",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"> 132 kV & < = 275 kV ; Single Circuit",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"> 275 kV & < = 330 kV ; Single Circuit",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"> 330 kV & < = 500 kV  ; Single Circuit",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"> 500 kV  ; Single Circuit",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"< = 33 kV; Multiple Circuit",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"> 33 kV & < = 66 kV ; Multiple Circuit",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"> 66 kV & < = 132 kV ; Multiple Circuit",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"> 132 kV & < = 275 kV ; Multiple Circuit",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"> 275 kV & < = 330 kV ; Multiple Circuit",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"> 330 kV & < = 500 kV  ; Multiple Circuit",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"> 500 kV  ; Multiple Circuit",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Other",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"CONDUCTORS BY: \nVoltage; Maximum continuous rating","< = 33 kV ; < = 100 MVA",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"< = 33 kV ; > 100 MVA & < = 400 MVA",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"< = 33 kV ; > 400 MVA",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"> 33 kV & < = 66 kV  ; < = 100 MVA",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,1,1,1]
[null,null,"> 33 kV & < = 66 kV  ; > 100 MVA & < = 400 MVA",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"> 33 kV & < = 66 kV  ; > 400 MVA",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"> 66 kV & < = 132 kV  ; < = 100 MVA",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"> 66 kV & < = 132 kV  ; > 100 MVA & < = 400 MVA",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"> 66 kV & < = 132 kV  ; > 400 MVA",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"> 132 kV & < = 275 kV  ; < = 200 MVA",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"> 132 kV & < = 275 kV  ; > 200 MVA & < = 600 MVA",0,0,0,0,0,0,0,0,0,0,0,0,0,0,4,5,5,8,9,11,14]
[null,null,"> 132 kV & < = 275 kV  ; > 600 MVA",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,1,1,1,1]
[null,null,"> 275 kV & < = 330 kV  ; < = 800 MVA",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"> 275 kV & < = 330 kV  ; > 800 MVA & < = 1200 MVA",0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,1,1,1,1,1,2]
[null,null,"> 275 kV & < = 330 kV  ; > 1200 MVA",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"> 330 kV & < = 500 kV   ; < = 1000 MVA",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"> 330 kV & < = 500 kV   ; > 1000 MVA & < = 1500 MVA",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"> 330 kV & < = 500 kV   ; > 1500 MVA",0,0,0,0,0,0,0,0,0,0,0,0,0,0,2,2,3,3,6,8,9]
[null,null,"> 500 kV   ; < = 2000 MVA",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"> 500 kV   ; > 2000 MVA & < = 3000 MVA",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"> 500 kV   ; > 3000 MVA",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Other",46669.253139097746,419505.23440265364,0,0,0,0,0,9,1,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"TRANSMISSION CABLES BY: \nHighest operating voltage; Insulation type","< = 33 kV; Oil Filled",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"> 33 kV & < = 66 kV ; Oil Filled",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"> 66 kV & < = 132 kV ; Oil Filled",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"> 132 kV & < = 275 kV ; Oil Filled",0,0,0,0,0,0,1700000,0,0,0,0,1,0,0,0,0,0,0,0,0,0]
[null,null,"> 275 kV & < = 330 kV ; Oil Filled",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"> 330 kV & < = 500 kV  ; Oil Filled",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"> 500 kV  ; Oil Filled",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"< = 33 kV; XLPE Insulated",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"> 33 kV & < = 66 kV ; XLPE Insulated",0,0,0,0,0,0,1500000,0,0,0,1,1,1,0,0,0,0,0,0,0,0]
[null,null,"> 66 kV & < = 132 kV ; XLPE Insulated",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"> 132 kV & < = 275 kV ; XLPE Insulated",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"> 275 kV & < = 330 kV ; XLPE Insulated",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"> 330 kV & < = 500 kV  ; XLPE Insulated",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"> 500 kV  ; XLPE Insulated",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"< = 33 kV; Other Insulated",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"> 33 kV & < = 66 kV ; Other Insulated",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"> 66 kV & < = 132 kV ; Other Insulated",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"> 132 kV & < = 275 kV ; Other Insulated",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"> 275 kV & < = 330 kV ; Other Insulated",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"> 330 kV & < = 500 kV  ; Other Insulated",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"> 500 kV  ; Other Insulated",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Other",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"SUBSTATION SWITCHBAYS BY: \nHighest operating voltage; Switch type","< = 33 kV; Air Insulated circuit Breaker",0,0,325349.17886033806,263348.5820655275,279344.19987629959,0,0,0,0,1,1,1,0,0,3,3,3,3,3,4,4]
[null,null,"> 33 kV & < = 66 kV ; Air Insulated circuit Breaker",2499831.9126315797,1025457.2396509311,9230840.9674637187,5196137.2385897469,3735441.9987629959,4300484.5380845973,19091299.241581559,14.421791321806001,12.324134216448201,25,31,27,24,18,11,11,12,13,14,15,16]
[null,null,"> 66 kV & < = 132 kV ; Air Insulated circuit Breaker",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"> 132 kV & < = 275 kV ; Air Insulated circuit Breaker",0,1030000,3685521.2385251583,5915146.634953199,2867847.5543985115,4045838.6355676418,4331056.9052388873,2,6,7,11,11,5,5,5,6,6,6,7,7,8]
[null,null,"> 275 kV & < = 330 kV ; Air Insulated circuit Breaker",0,0,0,1160000,0,0,0,0,1,1,0,0,0,0,0,0,1,1,1,1,1]
[null,null,"> 330 kV & < = 500 kV  ; Air Insulated circuit Breaker",0,0,0,2921787.8893101364,1206896.3693497267,2897655.6922538579,2306370.5128665669,0,1,1,1,1,3,2,2,2,2,2,2,2,2]
[null,null,"> 500 kV  ; Air Insulated circuit Breaker",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"< = 33 kV; Air Insulated Isolators / Earth Switch",0,0,121674.82408729052,472611.06813947571,334760.65805121581,403643.02612210071,550197.90097975277,0,0,3,6,6,6,7,16,16,17,19,20,21,22]
[null,null,"> 33 kV & < = 66 kV ; Air Insulated Isolators / Earth Switch",568000,0,6156485.6158738313,1964339.2947535871,1477048.7028412758,3083922.210114127,17254706.719914611,19,20,21,41,42,47,39,25,26,28,30,32,34,36]
[null,null,"> 66 kV & < = 132 kV ; Air Insulated Isolators / Earth Switch",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"> 132 kV & < = 275 kV ; Air Insulated Isolators / Earth Switch",0,2781000,5750713.85985847,7164502.518287803,1755203.346982321,8660037.7529685833,12782434.110962339,13,23,14,15,20,38,17,30,31,34,37,40,43,46]
[null,null,"> 275 kV & < = 330 kV ; Air Insulated Isolators / Earth Switch",0,0,252260.94978913578,1889917.7698592427,347019.36980592139,418424.16419798211,0,1,2,2,1,1,1,0,3,3,3,3,3,4,4]
[null,null,"> 330 kV & < = 500 kV  ; Air Insulated Isolators / Earth Switch",0,0,252377.92990500541,3416144.9577673697,694360.58384594088,418618.1986184956,489094.51305014442,0,1,5,3,2,1,1,6,7,7,8,8,9,9]
[null,null,"> 500 kV  ; Air Insulated Isolators / Earth Switch",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"< = 33 kV; VT",17034.705145918724,34429.450996909385,12306.032218425289,36941.663153292087,24908.558238853318,12424.933657276128,12507.163699872473,1.240903466136533,2.9814856271159438,1,3,2,1,1,3,3,4,4,5,5,5]
[null,null,"> 33 kV & < = 66 kV ; VT",105807.58215363826,74393.118942655943,575586.56175198185,254203.23625142878,47741.403291135524,47628.912352891821,944944.12751617783,3.3960163994035995,7.3541713305054373,7,5,5,7,7,4,4,5,5,6,7,7]
[null,null,"> 66 kV & < = 132 kV ; VT",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"> 132 kV & < = 275 kV ; VT",67216.606300057902,1560853.8837604038,667422.75506253354,194969.88886459716,98596.376362127732,0,285000,1.6204517330682666,6.4907428135579721,2,3,2,1,0,5,6,6,7,8,9,9]
[null,null,"> 275 kV & < = 330 kV ; VT",0,0,0,330000,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,1,1]
[null,null,"> 330 kV & < = 500 kV  ; VT",23624.010116147099,47747.330621642628,137417.35977241574,0,0,0,0,0.15511293326706663,0.37268570338949297,1,0,0,0,0,2,2,2,2,3,3,3]
[null,null,"> 500 kV  ; VT",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"< = 33 kV; CT",0,0,0,0,0,0,0,0,0,0,0,0,0,0,2,2,2,3,3,4,5]
[null,null,"> 33 kV & < = 66 kV ; CT",27864.066719182632,56317.060463624031,81014.712104633159,319066.4274752799,0,476000,238000,0.3102258665341332,0.74537140677898606,2,2,2,0,0,8,9,10,12,13,15,16]
[null,null,"> 66 kV & < = 132 kV ; CT",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"> 132 kV & < = 275 kV ; CT",256057.2313024668,1597526.4157504214,966120.6443685058,246277.75435528063,249085.58238853319,2172748.009718284,1455214.9109961742,3.8613551992047994,7.4722284406739163,3,6,8,6,4,6,7,8,9,10,11,12]
[null,null,"> 275 kV & < = 330 kV ; CT",0,0,0,840000,0,0,0,0,1,1,0,0,0,0,0,0,0,0,0,1,1]
[null,null,"> 330 kV & < = 500 kV  ; CT",885937.15358213731,1790599.2240144829,912697.38953320892,1983280.0057341657,1108430.8416289724,1105819.0954975754,1113137.5692886501,4.3431621314778655,11.435199694905805,6,5,6,6,6,3,4,4,4,5,5,6]
[null,null,"> 500 kV  ; CT",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"< = 33 kV; GIS Module",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"> 33 kV & < = 66 kV ; GIS Module",0,0,0,2000000,0,0,0,1,1,1,3,2,0,0,0,0,0,0,0,0,0]
[null,null,"> 66 kV & < = 132 kV ; GIS Module",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"> 132 kV & < = 275 kV ; GIS Module",0,0,0,10200000,0,0,0,1,1,1,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"> 275 kV & < = 330 kV ; GIS Module",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"> 330 kV & < = 500 kV  ; GIS Module",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"> 500 kV  ; GIS Module",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Other",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"SUBSTATION POWER TRANSFORMERS BY: \nHighest operating voltage;  Ampere rating","< = 33 kV ; < = 10 MVA",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"< = 33 kV ; > 10 MVA & < =  30 MVA",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"< = 33 kV ; > 30 MVA",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"> 33 kV & < = 66 kV  ; < = 10 MVA",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"> 33 kV & < = 66 kV  ; > 10 MVA & < =  30 MVA",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"> 33 kV & < = 66 kV  ; > 30 MVA",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"> 66 kV & < = 132 kV  ; < = 30 MVA",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"> 66 kV & < = 132 kV  ; > 30 MVA & < =  60 MVA",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"> 66 kV & < = 132 kV  ; > 60 MVA",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"> 132 kV & < = 220 kV  ; < = 50 MVA",0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,1,1,1,1,1,1]
[null,null,"> 132 kV & < = 220 kV  ; > 50 MVA & < =  100 MVA",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"> 132 kV & < = 220 kV  ; > 100 MVA",0,0,14552127,19402836,14552127,9701418,41196375,2,3,3,3,4,2,2,1,1,1,1,2,2,2]
[null,null,"> 220 kV & < = 275 kV  ; < = 50 MVA",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"> 220 kV & < = 275 kV  ; > 50 MVA & < =  100 MVA",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"> 220 kV & < = 275 kV  ; > 100 MVA",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"> 275 kV & < = 330 kV  ; < = 100 MVA",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"> 275 kV & < = 330 kV  ; > 100 MVA & < =  250 MVA",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"> 275 kV & < = 330 kV  ; > 250 MVA",0,0,0,12000000,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"> 330 kV & < = 500 kV   ; < = 150 MVA",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"> 330 kV & < = 500 kV   ; > 150 MVA & < =  300 MVA",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,1]
[null,null,"> 330 kV & < = 500 kV   ; > 300 MVA",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"> 500 kV   ; < = 1000 MVA",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"> 500 kV   ; > 1000 MVA & < =  1500 MVA",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"> 500 kV   ; > 1500 MVA",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Other",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"SUBSTATION REACTIVE PLANT BY: \nHighest operating voltage; Function","< = 33 kV;  SVCS",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"> 33 kV & < = 66 kV ;  SVCS",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"> 66 kV & < = 132 kV ;  SVCS",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"> 132 kV & < = 275 kV ;  SVCS",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"> 275 kV & < = 330 kV ;  SVCS",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"> 330 kV & < = 500 kV  ;  SVCS",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"> 500 kV  ;  SVCS",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"< = 33 kV;  Capacitors",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"> 33 kV & < = 66 kV ;  Capacitors",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"> 66 kV & < = 132 kV ;  Capacitors",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"> 132 kV & < = 275 kV ;  Capacitors",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"> 275 kV & < = 330 kV ;  Capacitors",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"> 330 kV & < = 500 kV  ;  Capacitors",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"> 500 kV  ;  Capacitors",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"< = 33 kV;  Oil Filled Reactors",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"> 33 kV & < = 66 kV ;  Oil Filled Reactors",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"> 66 kV & < = 132 kV ;  Oil Filled Reactors",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"> 132 kV & < = 275 kV ;  Oil Filled Reactors",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"> 275 kV & < = 330 kV ;  Oil Filled Reactors",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"> 330 kV & < = 500 kV  ;  Oil Filled Reactors",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"> 500 kV  ;  Oil Filled Reactors",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Other",887412.34714285715,9913896.8568201885,167386.98283048617,168403.5081329617,169403.4411845798,170495.83513585705,171624.2017068537,20.159046563674572,176.30569372669578,3,3,4,4,4,0,0,0,0,0,0,0]
[null,"SCADA, NETWORK CONTROL AND PROTECTION SYSTEMS BY:\nFunction","Communications Network Assets",4918290.1032330841,14074307.39082361,10233257.120487204,12346294.070362803,14539548.612891525,12750750.621851919,9223758.0623697322,121.31111143924849,239.10992688303028,122,206,162,195,251,0,0,0,0,0,0,0]
[null,null,"Control equipment / systems",5699932.7704180144,3951350.7372311098,7971294.7311347378,6602649.7396033155,5288692.7979576141,3129222.3399934741,2877844.8456941922,35.095425462565728,19.98707218383538,31,26,22,21,22,0,0,0,0,0,0,0]
[null,null,"Infrastructure: protection and control",3082022.4718269669,2136543.0535285468,1275815.4179152909,2156386.3846293879,3460375.1705386732,3118826.2524851901,3976658.3322319752,5.7533484364861849,3.2765692104648174,5,4,4,3,4,0,0,0,0,0,0,0]
[null,null,"Metering systems",321450.85482086666,222838.60588181153,0,0,206589.5624202193,519804.37541419838,732542.32435852184,172.60045309458553,98.297076313944501,151,128,109,103,109,0,0,0,0,0,0,0]
[null,null,"Protection schemes / systems",6597642.1110467594,4573667.6324973162,7529352.2703688825,7632580.9509286862,4942655.2809037464,5478738.1168656508,4360719.8080027997,88.026231078238624,50.131508920111699,77,65,55,53,56,0,0,0,0,0,0,0]
[null,null,"Station SCADA and control systems",2520679.1186715579,1747404.3458157287,4100981.0793469115,1771317.3873741401,1394479.5463364804,1871295.751491114,2302275.8765553539,28.479074760606611,16.219017591800846,25,21,18,17,18,0,0,0,0,0,0,0]
[null,"OTHER BY: \nNSP defined","Other - Secondary",630432.00753914251,437032.8700528153,357228.31701628148,0,206589.5624202193,727726.12557987776,1569733.5521968324,6.3286832801348032,3.6042261315112993,6,4,4,4,4,0,0,0,0,0,0,0]
[null,null,"Power transformers - Bushings replacement",-194138.53133458653,1793617.9355349015,694043.58734591829,698258.44835618266,702404.5122287455,706933.95056330983,711612.54366256401,5.8798446713442472,12.04698651730871,4,4,4,5,5,0,0,0,0,0,0,0]
[null,null,"Power transformers - life extension",0,0,1281939.3319212846,1289724.428140243,1297382.451998977,1305748.5910404662,1314390.2277061474,0,0,5,5,6,6,6,0,0,0,0,0,0,0]
[null,null,"Power transformers - improved safe access",10548.706804511277,1025457.2396509311,510326.1671661163,513425.32967366365,516473.90605054819,519804.37541419838,523244.51739894412,0,21.288853512915605,10,10,10,10,10,0,0,0,0,0,0,0]
[null,null,"On-line monitoring",0,0,173510.89683647957,205370.13186946543,103294.78121010964,103960.87508283967,104648.90347978883,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Fire protection systems",2691029.8851315794,2431265.8918269346,1791244.8467530685,1802122.9071545594,1812823.4102374241,1824513.3577038362,1836588.2560702937,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Civil Infrastructure",0,0,1806554.631768052,1817525.6670447693,1828317.6274189407,1840107.488966262,1852285.591592262,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Infrastructure security",1392665.822988722,1806232.563507193,2551630.8358305814,2567126.6483683186,2582369.5302527407,2599021.8770709923,2616222.5869947206,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Structure fall arrests (Stations)",1123739.7058834587,186446.77084562383,7878.3163654340751,350445.95477857237,546920.53862717771,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Earth wires (incl. OPGW)",5034630.7905639084,0,3880520.1751311487,3904086.2068385389,3927267.5816083685,3952592.4706495637,3978751.3103015707,2.0469032319503597,0,45,45,45,45,46,0,0,0,0,0,0,0]
[null,null,"Insulators",5719946.130281955,653123.03827222041,1157585.0928109139,1098636.7620916395,1105160.160697272,1112286.7589900594,928094.49784602923,2580.600076125967,264.56041275601149,408,408,408,408,408,0,0,0,0,0,0,0]
[null,null,"Tower fall arrests",6982469.1966541382,5223306.285240151,4403094.1703092512,4429833.744424371,4456136.8614041293,4484872.1510737045,4514553.6961180894,597.08387738526051,825.47365749722326,656,657,657,657,657,0,0,0,0,0,0,0]
[null,null,"XC17 -FBTS Refurbishment - Other",0,0,4492230.0303245708,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"XC28 - HWPS 220kV Switchyard Redevelopment Stage 4 - Other",0,0,0,12067607.746741015,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"XA09 - RTS Redevelopment - Other",0,0,0,130374888.78783277,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"XB59 - HTS Rebuild - Other",0,0,16908868.350069828,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"XC19 - SMTS H2 Transformer Replacement - Other",0,0,0,12846287.994185679,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"XC16 - TTS Bus Tie CB Replacement - Other",54272.2700599276,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"XC18 - YPS 220kV CB Replacement - Other",0,4946203.4803672675,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"XC21 - RWTS B4 220/66kV Transformer and 66kV CB Replacement - Other",0,0,0,4487634.8262936138,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"XC15 - TSTS B2 Transformer and 66kV CB Replacement - Other",0,0,0,0,0,0,654747.83690819144,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"XB61 - SVTS Redevelopment Stage 1 - Other",0,0,0,0,0,0,29709332.460182205,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"XA14 - WMTS Redevelopment - Other",0,0,0,0,0,0,77939504.407678053,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"284A - HYTS 500kV and 275kV CB Replacement - Other",0,0,0,1189078.6887564212,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"285A - FBTS Transformer and Circuit Breaker Replacement - Other",0,0,0,0,0,5419029.9748703018,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"ERTS B1, B3 & B4 Transformer replacements - Other",0,0,0,0,1003371.6245232932,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Other Ongoing Projects / Works",56484978.237216555,3136929.0646367259,937543.28449288092,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]