{"text_format":"1","workbook":"xlsx","n_sheets":29,"sheets":["AER only","Contents","Instructions","Business & other details","2.1 Expenditure summary","2.2 Repex","2.5 Connections","2.6 Non-network","2.10 Overheads","2.11 Labour","2.12 Input tables","2.14 Forecast price changes","2.15 Insurance & Self-insurance","2.16 Opex Summary","2.17 Step Changes","3.1 Revenue","3.2 Operating expenditure","3.3 Assets (RAB)","3.4 Operational data","3.5 Physical assets","3.7 Operating environment","7.1  Policies and Procedures","7.2 Contingent projects","7.3 Obligations","7.4 Shared Assets","7.5 EBSS","7.6 Indicative bill impact ","7.7 STPIS","2.10.2, 2.17.1 & 7.7.1"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":101,"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":[[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],[24,3,24,4],[24,5,24,8],[28,3,28,4],[28,6,28,7],[29,3,29,4],[29,6,29,7],[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]]}
["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","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",128078951.25408779,144627716.61576095,137274026.64394605,115865755.25906898,120906805.61840524,113989345.48104839,95256660.757225886]
[null,"Connections"]
[null,"Augmentation Expenditure"]
[null,"Non-network",13936474.099937411,22364575.804135107,29306312.50096184,27063089.120605942,18305450.693524133,15967595.316149265,15205271.943715803]
[null,"capitalised network overheads",3928710.8472836032,5807493.962994596,5929053.2301844442,5949381.2437051414,5958571.7877648883,5042553.4853691924,4220273.3183931932]
[null,"capitalised corporate overheads",4256103.4178905701,6291451.7932441467,6423140.9993664809,6445163.0140139023,6455119.4367452962,5462766.2758166259,4571962.7615926266]
[null,"balancing item"]
[null,"TOTAL  CAPEX",{"$f":"SUM(C11:C17)","v":150200239.6191994},179091238.17613482,178932533.37445882,155323388.63739398,151625947.53643954,140462260.55838346,119254168.78092751]
[]
[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",3712827.0800529392,3776627.1019784985]
[null,"Maintenance",14741587.806016894,14994902.491824459]
[null,"Non-network",18677860.079612669,19658771.382649019]
[null,"network overheads",23622081.342887819,24055928.656951625]
[null,"corporate overheads",146630476.08345157,147337381.90167898]
[null,"balancing item",0,0]
[null,"TOTAL OPEX",{"$f":"SUM(C23:C28)","v":207384832.39202189},{"$f":"SUM(D23:D28)","v":209823611.53508258}]

{"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",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,24266.707521884746,3679245.3087789267,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",8320536.5884185666,427153.05995280133,0,0,0,0,0,9,1,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,331280.48450030386,268149.58059748576,284436.80786757183,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",2442388.0447402056,1044151.9243290698,9296085.3295033425,5239346.2253773715,2844368.078675718,4333089.6562683638,19130226.994462237,14.421791321806001,12.324134216448201,24,30,26,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,3724544.1914614583,5957261.9579825774,1871352.589213677,4072652.8833403923,4363070.8487276323,2,6,7,10,10,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,2942530.42736906,1228898.7953815167,2950481.6486934843,2348416.9949838268,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,123893.02722792485,481227.04406966013,340863.54045618477,411001.67434662452,560228.33020846616,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",710000,0,6157405.9981511701,1976851.6611414843,636443.70592504635,3096135.28345615,17268975.920772996,19,20,19,39,40,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,5754154.223793732,7171184.073352417,528668.72738079843,8671450.7870140988,12795768.582199708,13,23,13,13,19,38,17,30,31,34,37,40,43,46]
[null,null,"> 275 kV & < = 330 kV ; Air Insulated Isolators / Earth Switch",0,0,256859.81430592539,1898849.2570745002,353345.73568923841,426052.28120660334,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,256978.9270376616,3425080.5867509437,707019.1830210241,426249.85298798175,498010.99181272334,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",14771.97015837523,35057.12000653844,12530.378376477467,37615.131258477937,25362.655810216635,12651.44745803552,12735.176602357389,1.240903466136533,2.9814856271159438,1,3,2,1,1,3,3,4,4,5,5,5]
[null,null,"> 33 kV & < = 66 kV ; VT",100918.39838247842,75749.34897066727,576016.55855491513,255063.77883027736,48611.756969581882,48497.215255802832,945818.17697570333,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",58288.164890814223,1563330.5794440443,669198.82881377998,198524.3038641891,100393.84591544086,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",20486.011907314325,48617.792358787592,139922.55853733173,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",24162.858032524127,57343.753383287367,82491.657645143336,320544.31581721548,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",222044.92224759463,1606961.2247126698,970607.56752954936,250767.54172318624,253626.55810216637,2179543.4237410654,1462055.2980707218,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",768257.33599778183,1823242.8941584127,929336.39625541214,1999929.6338901492,1128638.1835546403,1125978.8237651612,1133430.7176098076,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,0,9701418,41196375,2,3,2,2,3,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",3088346.8362044636,10094632.989448139,170438.54533572152,171473.60248844133,172491.76490387539,173604.07383519644,174753.011188114,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",7360936.1997383973,14330890.238514274,10419815.377331682,12571374.225501768,14804613.079912113,12983204.25625821,9391912.5615101736,121.31111143924849,239.10992688303028,122,206,162,195,251]
[null,null,"Control equipment / systems",7152369.7597791301,4023386.1700400007,8116616.0919023482,6723019.9024431575,5385108.7579746461,3186269.8917313493,2930309.6388250822,35.095425462565728,19.98707218383538,31,26,22,21,22]
[null,null,"Infrastructure: protection and control",3867372.6891761753,2175493.4818278099,1299074.2784734874,2195698.568449554,3523459.8318779422,3175684.2774731051,4049155.1372855678,5.7533484364861849,3.2765692104648174,5,4,4,3,4]
[null,null,"Metering systems",403361.84054804337,226901.08387698812,0,0,210355.81085838462,529280.7129121843,745896.99897365738,172.60045309458553,98.297076313944501,151,128,109,103,109]
[null,null,"Protection schemes / systems",8278830.2637182698,4657048.2659416245,7666616.7618391337,7771727.3615645412,5032762.7747868523,5578618.7140944218,4440218.2781760432,88.026231078238624,50.131508920111699,77,65,55,53,56]
[null,null,"Station SCADA and control systems",3162989.7805217416,1779260.5480902905,4175744.3607251779,1803609.5383692763,1419901.7232940961,1905410.5664838632,2344247.7110600658,28.479074760606611,16.219017591800846,25,21,18,17,18]
[null,"OTHER BY: \nNSP defined","Other - Secondary",791076.4929932903,445000.23464268399,363740.79797257646,0,210355.81085838462,740992.99807705788,1598350.7120864086,6.3286832801348032,3.6042261315112993,6,4,4,4,4,"                      ","                      "]
[null,null,"Power transformers - Bushings replacement",902444.31544669927,1826316.6385537547,706696.40748957719,710988.10787890316,715209.75691850774,719821.7695605706,724585.65614583867,5.8798446713442472,12.04698651730871,4,4,4,5,5]
[null,null,"Power transformers - life extension",0,0,1305309.8350101602,1313236.8580822095,1321034.4921906551,1329553.1508354067,1338352.3295870195,0,0,5,5,6,6,6]
[null,null,"Power transformers - improved safe access",0,1044151.9243290698,519629.71138939494,522785.37344037002,525889.52714596165,529280.7129121843,532783.57069546962,0,21.288853512915605,10,10,10,10,10]
[null,null,"On-line monitoring",0,0,176674.1018723943,209114.14937614795,105177.90542919229,105856.14258243685,106556.71413909391]
[null,null,"Fire protection systems",579464.24465524883,2475589.289682013,1823900.2869767766,1834976.6607756987,1845872.2402823248,1857775.302321767,1870070.3331410983]
[null,null,"Civil Infrastructure",0,0,1839489.1783184581,1850660.2219789098,1861648.9260967036,1873653.7237091325,1886053.8402619623]
[null,null,"Infrastructure security",835948.10187191935,1839161.2385650114,2598148.5569469747,2613926.8672018498,2629447.6357298074,2646403.5645609214,2663917.8534773481]
[null,null,"Structure fall arrests (Stations)",636460.7277360931,189845.80442346726,8021.9426762654693,356834.78930817673,556891.21962516196,0,0]
[null,null,"Earth wires (incl. OPGW)",170989.44924253246,0,3951264.3254049597,3975259.9796405733,3998863.9644178916,4024650.5409842487,4051286.2715683514,2.0469032319503597,0,45,45,45,45,46]
[null,null,"Insulators",6567406.4638108816,665029.85289540584,1178688.5454576381,1118665.5522244256,1125307.876198417,1132564.3965423245,945014.20284967532,2580.600076125967,264.56041275601149,408,408,408,408,408]
[null,null,"Tower fall arrests",3894759.6771910181,5318530.2109234342,4483365.1498677004,4510592.2020435119,4537374.8402153561,4566633.9910063259,4596856.647960512,597.08387738526051,825.47365749722326,656,657,657,657,657]
[null,null,"XC17 -FBTS Refurbishment - Other",0,0,5663376.4589289129,0,0,0,0]
[null,null,"XC28 - HWPS 220kV Switchyard Redevelopment Stage 4 - Other",0,0,0,10589901.579174463,0,0,0]
[null,null,"XA09 - RTS Redevelopment - Other",0,0,0,129299620.83641309,0,0,0]
[null,null,"XB59 - HTS Rebuild - Other",0,0,21459827.436557561,0,0,0,0]
[null,null,"XC19 - SMTS H2 Transformer Replacement - Other",0,0,0,13195996.508503783,0,0,0]
[null,null,"XC16 - TTS Bus Tie CB Replacement - Other",359351.22594146617,0,0,0,0,0,0]
[null,null,"XC18 - YPS 220kV CB Replacement - Other",0,3733685.2076264992,0,0,0,0,0]
[null,null,"XC21 - RWTS B4 220/66kV Transformer and 66kV CB Replacement - Other",0,0,0,4986517.2807821948,0,0,0]
[null,null,"XC15 - TSTS B2 Transformer and 66kV CB Replacement - Other",0,0,0,0,0,0,1087510.5610049032]
[null,null,"XB61 - SVTS Redevelopment Stage 1 - Other",0,0,0,0,0,0,30923399.170724005]
[null,null,"XA14 - WMTS Redevelopment - Other",0,0,0,0,0,0,80089165.280679271]
[null,null,"284A - HYTS 500kV and 275kV CB Replacement - Other",0,0,0,1431343.8778020181,0,0,0]
[null,null,"285A - FBTS Transformer and Circuit Breaker Replacement - Other",0,0,0,0,0,6019389.5140884332,0]
[null,null,"Other Ongoing Projects / Works",55886409.966347896,3194117.1144680725,897809.56053807342,0,0,0,0]

{"sheet":"2.5 Connections","index":6,"n_rows":60,"n_cols":16,"rows_kept":60,"cut":false,"hidden":false,"merged":[[8,3,8,9],[26,1,27,1],[28,1,29,1],[30,1,31,1],[20,1,21,1],[22,1,23,1],[24,1,25,1],[10,1,11,1],[12,1,13,1],[14,1,15,1],[16,1,17,1],[18,1,19,1],[32,1,33,1],[34,1,35,1],[36,1,37,1],[38,1,39,1],[40,1,41,1],[42,1,43,1],[44,1,45,1],[56,1,57,1],[58,1,59,1],[46,1,47,1],[48,1,49,1],[50,1,51,1],[52,1,53,1],[54,1,55,1]]}
[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.5 CONNECTIONS EXPENDITURE"]
[]
[]
[null,"TNSP CONNECTION CLASSIFICATIONS AND SPECIFICATIONS OF ANNUAL DIRECT AND INDIRECT COSTS",null,null,null,null,null,null,null,null,null,null,"ET_CON252_00001","ET_CON252_00002"]
[null,"TABLE 2.4.1 EXPENDITURE ON CONNECTION PROJECTS",null,null,null,null,null,null,null,null,null,"TABLE 2.4.2 DESCRIPTION OF CONNECTION PROJECTS"]
[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,null,"CONNECTION RATING \n(MVA)","CONNECTION \nVOLTAGE \n(KV)","UNDERGROUND / OVERHEAD\n(drop down)","YEAR CONNECTION PROJECT COMPLETED "]
[null,"CONNECTION PROJECT","EXPENDITURE 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,{"$f":"B11","v":"<Enter project description here…>"}]
[null,"<Enter project description here…>","Direct materials costs ",null,null,null,null,null,null,null,null,{"$f":"B13","v":0}]
[null,null,"Direct labour costs ",null,null,null,null,null,null,null,null,{"$f":"B15","v":0}]
[null,null,"Direct materials costs ",null,null,null,null,null,null,null,null,{"$f":"B17","v":0}]
[null,null,"Direct labour costs ",null,null,null,null,null,null,null,null,{"$f":"B19","v":0}]
[null,null,"Direct materials costs ",null,null,null,null,null,null,null,null,{"$f":"B21","v":0}]
[null,null,"Direct labour costs ",null,null,null,null,null,null,null,null,{"$f":"B23","v":0}]
[null,null,"Direct materials costs ",null,null,null,null,null,null,null,null,{"$f":"B25","v":0}]
[null,null,"Direct labour costs ",null,null,null,null,null,null,null,null,{"$f":"B27","v":0}]
[null,null,"Direct materials costs ",null,null,null,null,null,null,null,null,{"$f":"B29","v":0}]
[null,null,"Direct labour costs ",null,null,null,null,null,null,null,null,{"$f":"B31","v":0}]
[null,null,"Direct materials costs ",null,null,null,null,null,null,null,null,{"$f":"B33","v":0}]
[null,null,"Direct labour costs ",null,null,null,null,null,null,null,null,{"$f":"B35","v":0}]
[null,null,"Direct materials costs ",null,null,null,null,null,null,null,null,{"$f":"B37","v":0}]
[null,null,"Direct labour costs ",null,null,null,null,null,null,null,null,{"$f":"B39","v":0}]
[null,null,"Direct materials costs ",null,null,null,null,null,null,null,null,{"$f":"B41","v":0}]
[null,null,"Direct labour costs ",null,null,null,null,null,null,null,null,{"$f":"B43","v":0}]
[null,null,"Direct materials costs ",null,null,null,null,null,null,null,null,{"$f":"B45","v":0}]
[null,null,"Direct labour costs "]
[null,null,"Direct materials costs "]
[null,null,"Direct labour costs "]
[null,null,"Direct materials costs "]
[null,null,"Direct labour costs "]
[null,null,"Direct materials costs "]
[null,null,"Direct labour costs "]
[null,null,"Direct materials costs "]
[null,null,"Direct labour costs "]
[null,null,"Direct materials costs "]
[null,null,"Direct labour costs "]
[null,null,"Direct materials costs "]
[null,null,"Direct labour costs "]
[null,null,"Direct materials costs "]
[null,null,"Direct labour costs "]
[null,null,"Direct materials costs "]
[null,null,"Direct labour costs "]
[null,null,"Direct materials costs "]
[null,null,"Direct labour costs "]
[null,null,"Direct materials costs "]
[null,null,"Direct labour costs "]
[null,null,"Direct materials costs "]
[null,null,"Direct labour costs "]
[null,null,"Direct materials costs "]
[null,null,"Direct labour costs "]
[null,null,"Direct materials costs "]
[null,null,"Direct labour costs "]
[null,null,"Direct materials costs "]
[null,null,"Direct labour costs "]
[null,null,"Direct materials costs "]
[null,null,"Direct labour costs "]
[null,null,"Direct materials costs "]
[null,null,"Direct labour costs "]

{"sheet":"2.6 Non-network","index":7,"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 ",0,0,0,0,0,0,0,null,"IT & COMMUNICATIONS","Employee numbers",null,null,774.42122342112316,774.42122342112316,774.42122342112316,774.42122342112316,774.42122342112316,774.42122342112316,774.42122342112316]
[null,null,null,"Capex ",0,null,967743.11816328287,570996.18471019529,0,0,93280.951648232571,null,null,"User numbers",null,null,921.12226842001485,921.12226842001485,921.12226842001485,921.12226842001485,921.12226842001485,921.12226842001485,921.12226842001485]
[null,null,"Recurrent expenditure","Opex ",8904644.8649813272,9715545.8950685505,9916090.0103611685,10095450.088118613,10277873.874009904,10469430.498916185,10666297.341897985,null,null,"Number of devices",null,null,1304.6670616850045,1304.6670616850045,1304.6670616850045,1304.6670616850045,1304.6670616850045,1304.6670616850045,1304.6670616850045]
[null,null,null,"Capex ",5244307.9199228063,15903944.888078602,13790339.43382678,17766765.901174925,8644187.9585502706,4709535.4010483129,6063261.8571351171]
[null,null,"Non-recurrent expenditure","Opex ",686499.893490538,698441.92400032817,713902.78918653633,727730.47980687395,741794.36573196133,756562.34408365539,771739.71148999804]
[null,null,null,"Capex ",2356138.3408348844,2376451.5350002511,9435495.4020920079,3623629.6337377778,4453066.5241016541,6242872.5083663687,3171552.3560399078]
[null,"MOTOR VEHICLES","Car","Opex ",373667.0575945524,380167.19465882587,388582.65991494112,396109.17596603296,403764.25489875133,411802.5766372144,420063.73191857018]
[null,null,null,"Capex ",355878.32448533439,227436.71763034005,485305.60835417325,383133.23534069746,531501.52461620595,449228.24834263406,452201.30711426504]
[null,null,"Light commercial vehicle","Opex ",1217830.6965877588,1239015.5088103267,1266442.6306469142,1290972.5486557039,1315921.4702145911,1342119.4311083527,1369043.6361899511]
[null,null,null,"Capex ",1067634.9734560032,682310.15289102017,1455916.8250625199,1149399.7060220924,1594504.5738486175,1347684.7450279021,1356603.9213427948]
[null,null,"Elevated work platform (LCV)  ","Opex ",0,0,0,0,0,0,0,null,"TABLE 2.6.3 ANNUAL DESCRIPTOR METRICS - MOTOR VEHICLES"]
[null,null,null,"Capex ",0,0,0,0,0,0,0]
[null,null,"Elevated work platform (HCV)","Opex ",0,0,0,0,0,0,0,null,"NON-NETWORK CATEGORY","DESCRIPTOR METRIC",null,"Unit of Measure","VOLUMES  (0's or %)"]
[null,null,null,"Capex ",0,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 ",99902.406036330285,101640.26148568986,103890.19283477143,105902.45762315158,107949.0945643357,110098.19405235625,112306.86958977193,null,"MOTOR VEHICLES","CAR","Average kilometres travelled ","0's",19194.365182846745,19194.365182846745,19194.365182846745,19194.365182846745,19194.365182846745,19194.365182846745,19194.365182846745]
[null,null,null,"Capex ",0,0,0,0,0,0,0,null,null,null,"Number purchased","0's",10.520858827240419,6.7237295268831616,14.347127774489381,11.326597895145113,15.712821271250505,13.280569950014252,13.368462719731692]
[null,"BUILDINGS AND PROPERTY","Total buildings and property expenditure","Opex ",7395315.1609221613,7523960.5986252967,7690512.6575501459,7839471.3552204082,7990974.4651108561,8150062.4055985836,8313560.4867305644,null,null,null,"Number leased","0's",4.2107597868155633,4.2107597868155633,4.2107597868155633,4.2107597868155633,4.2107597868155633,4.2107597868155633,4.2107597868155633]
[null,null,null,"Capex ",2816402.0516391294,539698.31829297484,221362.2570518823,601098.62238173746,96500.728231283923,213331.88414638501,1043541.8685783881,null,null,null,"Number in fleet","0's",54.816479106618608,54.816479106618608,54.816479106618608,54.816479106618608,54.816479106618608,54.816479106618608,54.816479106618608]
[null,"OTHER","Other expenditure","Opex ",0,0,0,0,0,0,0,null,null,null,"Proportion of total fleet expenditure allocated as regulatory expenditure","%",0.92928919443001368,0.92928919443001368,0.92928919443001368,0.92928919443001368,0.92928919443001368,0.92928919443001368,0.92928919443001368]
[null,null,null,"Capex ",477913.64762863005,988025.32209072076,368768.73205139861,371008.22965481551,373211.17302201223,375617.81615220755,378103.71023213724,null,null,"LIGHT COMMERCIAL VEHICLE","Average kilometres travelled ","0's",26645.695311946318,26645.695311946318,26645.695311946318,26645.695311946318,26645.695311946318,26645.695311946318,26645.695311946318]
[null,"OTHER - TNSP nominated","Tools & Equipment","Opex ",0,0,0,0,0,0,0,null,null,null,"Number purchased","0's",20.58383068968681,13.154830081577362,28.069842381000139,22.160241591701212,30.741791902701941,25.983145273829162,26.155105559621337]
[null,null,null,"Capex ",1618198.8419706244,1646708.8701512013,2581381.1243597898,2597057.6075837081,2612478.2111540856,2629324.7130654533,2646725.9716249616,null,null,null,"Number leased","0's",22.264639727312186,22.264639727312186,22.264639727312186,22.264639727312186,22.264639727312186,22.264639727312186,22.264639727312186]
[null,null,null,"Opex ",null,null,null,null,null,null,null,null,null,null,"Number in fleet","0's",80.389307000572273,80.389307000572273,80.389307000572273,80.389307000572273,80.389307000572273,80.389307000572273,80.389307000572273]
[null,null,null,"Capex ",null,null,null,null,null,null,null,null,null,null,"Proportion of total fleet expenditure allocated as regulatory expenditure","%",0.92928919443001368,0.92928919443001368,0.92928919443001368,0.92928919443001368,0.92928919443001368,0.92928919443001368,0.92928919443001368]
[null,null,null,"Opex ",null,null,null,null,null,null,null,null,null,"ELEVATED WORK PLATFORM (LCV) ","Average kilometres travelled ","0's",0,0,0,0,0,0,0]
[null,null,null,"Capex ",null,null,null,null,null,null,null,null,null,null,"Number purchased","0's",0,0,0,0,0,0,0]
[null,null,null,"Opex ",null,null,null,null,null,null,null,null,null,null,"Number leased","0's",0,0,0,0,0,0,0]
[null,null,null,"Capex ",null,null,null,null,null,null,null,null,null,null,"Number in fleet","0's",0,0,0,0,0,0,0]
[null,null,null,"Opex ",null,null,null,null,null,null,null,null,null,null,"Proportion of total fleet expenditure allocated as regulatory expenditure","%",0,0,0,0,0,0,0]
[null,null,null,"Capex ",null,null,null,null,null,null,null,null,null,"ELEVATED WORK PLATFORM (HCV)","Average kilometres travelled ","0's",0,0,0,0,0,0,0]
[null,null,null,"Opex ",null,null,null,null,null,null,null,null,null,null,"Number purchased","0's",0,0,0,0,0,0,0]
[null,null,null,"Capex ",null,null,null,null,null,null,null,null,null,null,"Number leased","0's",0,0,0,0,0,0,0]
[null,null,null,"Opex ",null,null,null,null,null,null,null,null,null,null,"Number in fleet","0's",0,0,0,0,0,0,0]
[null,null,null,"Capex ",null,null,null,null,null,null,null,null,null,null,"Proportion of total fleet expenditure allocated as regulatory expenditure","%",0,0,0,0,0,0,0]
[null,null,null,"Opex ",null,null,null,null,null,null,null,null,null,"HEAVY COMMERCIAL VEHICLE ","Average kilometres travelled ","0's",9640.8120080607841,9640.8120080607841,9640.8120080607841,9640.8120080607841,9640.8120080607841,9640.8120080607841,9640.8120080607841]
[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",0.92928919443001368,0.92928919443001368,0.92928919443001368,0.92928919443001368,0.92928919443001368,0.92928919443001368,0.92928919443001368]
[null,null,null,"Capex ",null,null,null,null,null,null,null,null,null,null,"Number in fleet","0's",8.3636027498701218,8.3636027498701218,8.3636027498701218,8.3636027498701218,8.3636027498701218,8.3636027498701218,8.3636027498701218]
[null,null,null,"Opex ",null,null,null,null,null,null,null,null,null,null,"Proportion of total fleet expenditure allocated as regulatory expenditure","%",0.92928919443001368,0.92928919443001368,0.92928919443001368,0.92928919443001368,0.92928919443001368,0.92928919443001368,0.92928919443001368]
[null,null,null,"Capex "]
[null,null,null,"Opex "]
[null,null,null,"Capex "]

{"sheet":"2.10 Overheads","index":8,"n_rows":121,"n_cols":11,"rows_kept":121,"cut":false,"hidden":false,"merged":[[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],[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],[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],[195,55,195,62],[167,64,167,68],[167,69,167,70],[167,71,167,72],[167,75,167,79],[195,11,195,17],[195,19,195,26],[195,28,195,35],[195,37,195,44],[195,46,195,53],[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],[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]]}
[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",8437774.5115609616,9162084.7954089865,9362666.785316851,9513864.1331796702,9663980.5134273916,9526323.9008097071,9422854.1853906978]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[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",5055810.3565327395,5487378.2107565682,5725748.0572791668,5814754.1963497838,5902555.8055169452,5818157.2429340966,5753367.9793448988]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[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",9848744.0648749582,10899942.578122731,11137825.72307671,11307622.768919552,11474738.60995267,11200345.800342251,10976244.320487062]
[null,null,null,"    ASSET WORKS PROGRAM",4208463.2572027622,4314017.0356579367,11655752.525943544,5091936.1825896148,4861853.2011982733,5374540.717320527,4810446.2058978304]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[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,null,"Total Overhead Expenditure - Negotiated Services","Total"]
[null,null,"Total Overhead Expenditure - Unregulated Services","Total"]

{"sheet":"2.11 Labour","index":9,"n_rows":62,"n_cols":32,"rows_kept":62,"cut":false,"hidden":false,"merged":[[6,25,6,31],[6,4,6,10],[6,18,6,24],[6,11,6,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.11 LABOUR"]
[]
[null,"TABLE 2.11.1 - COST METRICS PER ANNUM"]
[null,null,null,null,"ASL (0'S)",null,null,null,null,null,null,{"$f":"CONCATENATE(\"TOTAL LABOUR EXPENDITURE\nForecast \n($0's. real \",dms_DollarReal,\")\")","v":"TOTAL LABOUR EXPENDITURE\nForecast \n($0's. real March 2017)"},null,null,null,null,null,null,"AVERAGE PRODUCTIVE WORK HOURS PER ASL \n(0'S)",null,null,null,null,null,null,"STAND-DOWN OCCURENCES PER ASL \n(0'S)"]
[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"},{"$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,"CORPORATE OVERHEADS \nINTERNAL LABOUR COSTS","LABOUR CLASSIFICATION LEVEL","Executive manager"]
[null,null,null,"Employee (optional)"]
[null,null,null,"Labour hire (optional)"]
[null,null,null,"Senior manager"]
[null,null,null,"Employee (optional)"]
[null,null,null,"Labour hire (optional)"]
[null,null,null,"Manager"]
[null,null,null,"Employee (optional)"]
[null,null,null,"Labour hire (optional)"]
[null,null,null,"Professional"]
[null,null,null,"Employee (optional)"]
[null,null,null,"Labour hire (optional)"]
[null,null,null,"Semi professional"]
[null,null,null,"Employee (optional)"]
[null,null,null,"Labour hire (optional)"]
[null,null,null,"Support staff"]
[null,null,null,"Employee (optional)"]
[null,null,null,"Labour hire (optional)"]
[null,null,null,"Intern, junior staff, apprentice"]
[null,null,null,"Employee (optional)"]
[null,null,null,"Labour hire (optional)"]
[null,"NETWORK OVERHEADS \nINTERNAL LABOUR COSTS","LABOUR CLASSIFICATION LEVEL","Executive manager"]
[null,null,null,"Employee (optional)"]
[null,null,null,"Labour hire (optional)"]
[null,null,null,"Senior manager"]
[null,null,null,"Employee (optional)"]
[null,null,null,"Labour hire (optional)"]
[null,null,null,"Manager"]
[null,null,null,"Employee (optional)"]
[null,null,null,"Labour hire (optional)"]
[null,null,null,"Professional"]
[null,null,null,"Employee (optional)"]
[null,null,null,"Labour hire (optional)"]
[null,null,null,"Semi professional"]
[null,null,null,"Employee (optional)"]
[null,null,null,"Labour hire (optional)"]
[null,null,null,"Support staff"]
[null,null,null,"Employee (optional)"]
[null,null,null,"Labour hire (optional)"]
[null,null,null,"Intern, junior staff, apprentice"]
[null,null,null,"Employee (optional)"]
[null,null,null,"Labour hire (optional)"]
[null,"TOTAL DIRECT NETWORK LABOUR \nINTERNAL LABOUR COSTS","LABOUR CLASSIFICATION LEVEL","Skilled electrical worker"]
[null,null,null,"Employee (optional)"]
[null,null,null,"Labour hire (optional)"]
[null,null,null,"Skilled non electical worker"]
[null,null,null,"Employee (optional)"]
[null,null,null,"Labour hire (optional)"]
[null,null,null,"Apprentice"]
[null,null,null,"Employee (optional)"]
[null,null,null,"Labour hire (optional)"]
[null,null,null,"Unskilled worker"]
[null,null,null,"Employee (optional)"]
[null,null,null,"Labour hire (optional)"]

{"sheet":"2.12 Input tables","index":10,"n_rows":82,"n_cols":45,"rows_kept":82,"cut":false,"hidden":false,"merged":[[6,38,6,44],[6,17,6,23],[6,24,6,30],[8,1,27,1],[28,1,45,1],[6,3,6,9],[6,10,6,16],[6,31,6,37]]}
[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.12 INPUT TABLES"]
[]
[]
[null,null,null,{"$f":"CONCATENATE(\"DIRECT MATERIAL EXPENDITURE\nForecast \n($0's. real \",dms_DollarReal,\")\")","v":"DIRECT MATERIAL EXPENDITURE\nForecast \n($0's. real March 2017)"},null,null,null,null,null,null,{"$f":"CONCATENATE(\"DIRECT LABOUR EXPENDITURE\nForecast \n($0's. real \",dms_DollarReal,\")\")","v":"DIRECT LABOUR EXPENDITURE\nForecast \n($0's. real March 2017)"},null,null,null,null,null,null,{"$f":"CONCATENATE(\"CONTRACT EXPENDITURE\nForecast \n($0's. real \",dms_DollarReal,\")\")","v":"CONTRACT EXPENDITURE\nForecast \n($0's. real March 2017)"},null,null,null,null,null,null,{"$f":"CONCATENATE(\"OTHER EXPENDITURE\nForecast \n($0's. real \",dms_DollarReal,\")\")","v":"OTHER EXPENDITURE\nForecast \n($0's. real March 2017)"},null,null,null,null,null,null,{"$f":"CONCATENATE(\"RELATED PARTY CONTRACT MARGIN EXPENDITURE\nForecast \n($0's. real \",dms_DollarReal,\")\")","v":"RELATED PARTY CONTRACT MARGIN EXPENDITURE\nForecast \n($0's. real March 2017)"},null,null,null,null,null,null,{"$f":"CONCATENATE(\"RELATED PARTY CONTRACT MARGIN \nForecast \n($0's. real \",dms_DollarReal,\")\")","v":"RELATED PARTY CONTRACT MARGIN \nForecast \n($0's. real March 2017)"}]
[null,null,null,{"$f":"CRCP_y5","v":"2016-17"},{"$f":"FRCP","v":"2017-18"},{"$f":"FRCP","v":"2017-18"},"2018-19","2019-20","2020-21","2021-22",{"$f":"CRCP_y5","v":"2016-17"},{"$f":"FRCP","v":"2017-18"},{"$f":"FRCP","v":"2017-18"},"2018-19","2019-20","2020-21","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"},{"$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,"VEGETATION MANAGEMENT","Zone - NSP to nominate"]
[null,null,"ZONE 1",67756.897161484405,68921.209808236847,75103.393854122245,76402.930468721635,77703.287206403736,79040.436198461583,80387.63319558058,666712.03034347249,678168.5946371539,738999.84060412867,751786.97713371809,764582.18348274287,777739.41701487952,790995.52056816325,2925745.9144593705,2976020.987730077,3242967.9772236678,3299082.0276028197,3355231.4909341447,3412969.6454900256,3471141.6733634234,52612.238088611972,53516.309803031356,58316.685153079561,59325.756297663167,60335.464255806663,61373.74086051053,62419.819593953151,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"ROUTINE MAINTENANCE","Transmission Lines Maintenance",153819.42049653176,156462.60376056773,170497.18927404881,173447.35342479643,176399.37939127945,179434.9298915579,182493.29103371047,1961944.4722878649,1995657.8927218998,2174667.0021057595,2212295.9193726247,2249948.5838300502,2288666.591641725,2327675.5458929958,1166674.9117410311,1186722.676784809,1293170.8662423403,1315546.9907205405,1337937.2365216645,1360960.9912632036,1384157.7579918464,4909.3645771961092,4993.7255131924094,5441.6591795207596,5535.8178451290514,5630.0359332224307,5726.9198250629479,5824.5317508333701,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Substations Equipment & Propoerty Maintenance",268381.39011557843,272993.16928131907,297480.46456331463,302627.85852235404,307778.50094438717,313074.87548799784,318411.04963399837,3423165.8336930512,3481988.4102729787,3794320.3217098387,3859974.5875497819,3925670.2870656126,3993224.7787251188,4061286.9085596749,2035593.6436068397,2070572.6276245366,2256301.5360398619,2295343.000202666,2334409.1029986432,2374580.5409306544,2415053.8471017713,8565.7720303385158,8712.9634916055838,9494.5101887697492,9658.7965544692688,9823.1865994642922,9992.2278914418002,10162.539444076438,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"SCADA & Network Control Maintenance",8296.4455922591897,8439.0090349614002,9195.9822100432175,9355.1030563310433,9514.3243220126078,9678.050589390421,9843.007177677142,105819.96419455335,107638.34029723953,117293.42371731685,119322.98710919823,121353.8313359301,123442.13620805427,125546.13364551631,62926.091503065421,64007.393144920519,69748.811292109676,70955.695954005758,72163.342267369182,73405.157689154657,74656.304731961587,264.79280688871415,269.34292099879258,293.5027915771513,298.58135866404609,303.66313077806228,308.88868639923498,314.15350945405993,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Protection Systems Maintenance",32939.894381488441,33505.922892499679,36511.380610450564,37143.148011601785,37775.314114122979,38425.366705311237,39080.304116190549,420143.59104261809,427363.20287544816,465697.38159874926,473755.48347209656,481818.67072378163,490109.99755274318,498463.62955071416,249839.37818923462,254132.5374079812,276928.04727606586,281719.81657671521,286514.60990959749,291445.06698064524,296412.5739675198,1051.3233643128094,1069.3889656047104,1165.3124036929553,1185.4761547344497,1205.6526308946343,1226.3999796636811,1247.3032343689208,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"NON-ROUTINE MAINTENANCE","Transmission Lines Maintenance",207073.07640419822,210631.35329938625,229524.83754833939,233496.37485241122,237470.41854943903,241556.90371915229,245674.09677849599,759267.79343666916,772314.8060834147,841590.90100186679,856153.20150841842,870724.69212061865,885708.46804938035,900804.8395507083,637985.65490456601,648948.59443648811,707158.82693657908,719395.00882905431,731638.91283963015,744229.24550155632,756914.18820848118,1205.5826980191807,1226.2990419016978,1336.2972034752224,1359.4195559387592,1382.5565006613895,1406.348081401233,1430.3184439560473,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Substations Equipment & Propoerty Maintenance",361297.42214261676,367505.84040647466,400470.8558154045,407400.32349329576,414334.16428105521,421464.19095125102,428647.79620131623,1324756.9469104565,1347521.1426127024,1468392.8413616398,1493800.8843812612,1519224.9621338269,1545368.3879766779,1571708.2685726976,1113146.0278836882,1132273.9698680793,1233838.1486102405,1255187.6212282551,1276550.5672606395,1298517.9558447197,1320650.4183532342,2103.4792573605669,2139.6247658493835,2331.5476024974791,2371.8910719818559,2412.2600017804621,2453.7711288630803,2495.5941912778849,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Scada & Network Control Maintenance",11168.749085541487,11360.669264201801,12379.71330697389,12593.923210082989,12808.268298675981,13028.678060750624,13250.744091811001,40952.071707642703,41655.778887242195,45392.272955935419,46177.70910867049,46963.640941413032,47771.809905762871,48586.051855166937,34410.565697566926,35001.865749694414,38141.508489803753,38801.482483986088,39461.872980405082,40140.94854564211,40825.127023686109,65.024632317547272,66.141994607283038,72.074885004330525,73.32201841934102,74.569938886358614,75.853167977488923,77.14603989262676,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Protection Systems Maintenance",44343.979739268179,45105.972371467869,49151.946369093639,50002.437281788356,50853.464929824957,51728.571528506422,52610.254115043252,162594.55953179582,165388.53195212121,180223.76694656868,183342.23299649195,186462.66707560455,189671.39062257973,192904.22612015376,136622.41101691691,138970.08642179405,151435.60543288742,154055.9412647982,156677.93076146612,159374.1067499916,162090.54315088649,258.17134541731741,262.60767847108866,286.16340253176736,291.11497396235677,296.06967027452339,301.16455461493587,306.29772445976295,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"OVERHEADS","Network Overheads",611857.06354555348,663216.721520575,841295.77452070569,704629.80696992599,708515.17302509141,708875.82588301657,687634.55900788226,16649184.626576155,18046727.417091437,22892419.668063182,19173614.964334868,19279339.292202279,19289152.982973296,18711158.881120197,9720364.6860175468,10536298.07211495,13365379.308950329,11194213.649665406,11255939.136294637,11261668.705360608,10924215.936207512,569385.81403216883,617180.40921925881,782898.34008205764,655718.86006842006,659334.52857327287,659670.14718965825,639903.31478489935,null,null,null,null,null,null,null,0,0,0,0,0,0,0]
[null,null,"Corporate Overheads",23605.187515633053,24034.194685581086,24413.172999010087,24515.503316241651,24608.493052637663,24550.120286557729,24509.259898711221,14117069.294653321,14373636.794574622,14600284.564616902,14661483.154051749,14717095.614301203,14682185.813939512,14657749.281662295,17487678.244492348,17805504.118472923,18086266.590810735,18162077.031258084,18230967.591396894,18187722.683862444,18157451.654872242,119258226.77468082,121425658.58718996,123340334.40222722,123857328.0575517,124327131.19143863,124032220.05929805,123825785.03747614,null,null,null,null,null,null,null,0,0,0,0,0,0,0]
[null,"AUGMENTATION","Subtransmission Substations, Switching Stations , Zone Substations"]
[null,null,"Subtransmission Lines"]
[null,null,"HV Feeders"]
[null,null,"Other Assets"]
[null,"CONNECTIONS","All New Customer Connections"]
[null,"REPLACEMENT","Transmission Towers",625580.1683368301,552704.53143157135,333846.29019808001,1532913.7648510707,91873.438903966933,108706.43478366894,89401.846833186704,157313.86295645224,139905.23789484662,85186.265124261772,394315.96563211113,23828.439926082145,28446.611006614068,23607.825049555744,785181.3087837639,698309.12546001258,426170.94600665651,1977238.6490236113,119697.4674946716,143172.11423443598,119059.83115667725,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Transmission Tower Support Structures",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Conductors",6565091.9269652264,986701.40022529475,789830.49673827796,527617.37791574677,531067.11563343753,547900.11151313956,453456.6403835559,1650915.4605090369,249762.18988497477,201537.98940959823,135720.58691595285,137738.40418465805,143376.06944530422,119741.65426032867,8240011.0048322296,1246638.2175243683,1008256.8531168755,680550.65812059259,691901.70270504232,721613.37560859963,603885.41124521045,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Transmission Cables",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Substation Switchbays",13823297.448828641,18751443.898526512,17892984.078954197,13504454.863521647,14671328.247610744,13599171.275149649,10671663.392430609,3476127.3303351267,4746523.8120994484,4565683.4608214935,3473791.0781055242,3805178.8194131665,3558670.0644387146,2818004.0041715349,17349966.210461043,23691328.088041373,22841260.111908246,17418807.69969083,19114565.177620865,17910826.596181307,14211859.001463458,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Substation Power Transformers",9519291.1360089593,10067494.609553266,8227097.2713448601,5670665.3666774491,6982132.5679884944,7103107.6975621376,5622150.2047328381,2393804.2428582534,2548369.2429777333,2099276.5531228418,1458682.113181513,1810896.9081494974,1858761.5536536004,1484608.4632156345,11947900.287083246,12719677.434453825,10502287.819156315,7314344.0849483293,9096683.3947934974,9355167.8768481519,7487230.7208814127,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Substation Reactive Plant",1232089.0994819016,4011268.6780801127,67321.391804006853,67321.391804006853,67321.391804006853,67321.391804006853,67321.391804006853,309831.90573533956,1015366.1979455387,17178.138859496634,17317.281784258557,17460.5822910233,17616.854502527956,17777.167878500968,1546425.830987222,5067998.1134224879,85939.014672218065,86834.928900175946,87709.79080884521,88665.827528661626,89654.451505606194,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Scada Network Control And Protection Systems",14623744.224218475,14730120.767892987,15904010.133694651,14327638.872911433,14586830.98492977,13513653.097572219,11765066.970087994,3677414.6803839393,3728612.5462263064,4058164.6810692921,3685541.1484605782,3783263.4761786917,3536291.4229500019,3106732.7193406704,18354626.96942221,18610626.775042493,20302238.613928087,18480596.872666139,19004477.773972932,17798194.641011383,15667986.027394993,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Other ",4707718.6549951909,8370471.3490845384,11006674.055493873,9858861.9302982539,10257869.649366263,9263718.9758104756,8027365.7708887989,1183844.125523322,2118804.3860477326,2808530.3978406363,2536024.3682441609,2660497.2408293216,2424156.4973029452,2119739.730673973,5908775.3768508388,10575590.021539364,14050552.102387032,12716516.278309431,13364483.071141258,12200807.00907783,10690347.539444042,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"NON-NETWORK EXPENDITURE","It And Communications",3237970.9413500903,7487461.5241828663,9784282.5917146634,8854376.6119634993,5348136.1725034388,4488068.1933272118,3838948.0837212522,3913914.0420700777,5260510.5366276205,5931174.5841259044,5774133.8176920377,4946570.5057007829,4800005.9176318608,4707181.5982597014,10031054.882568778,15937018.828746144,19098525.390041944,18146299.415973566,13812276.371605802,12880200.865355883,12209685.497564673,8651.1532406109891,9393.3525911014822,9588.1877472706037,9762.441919273544,9939.6725837646518,10125.776099564093,10317.038665613034,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Motor Vehicles",1369424.8818061349,1176963.1426854541,1600273.4258462326,1451335.9358195458,1695829.7884474217,1580137.6514417476,1597857.8644519411,142810.97989719544,91506.667154684212,195651.68461580932,154771.95559023137,215206.24160897799,182345.69073512606,184005.03652081575,1602677.596456649,1362100.0256360644,1904212.806351278,1719409.2321979017,2042604.888086102,1898449.8529915863,1928356.565182596,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Buildings And Property",1283982.7928197093,377633.46611476701,254223.24846350402,406012.38929796236,210966.82080014239,259481.31397915678,582311.18446225056,952132.52857965603,735516.08620216686,718621.16690165037,770502.99904898892,733283.14149683178,759567.17913176701,858879.01060314756,7693648.4196230583,6663651.1625717804,6645822.340486885,6965167.2375282831,6838561.6781891575,7033616.8637199281,7598949.7064365484,281953.47153886792,286858.20202955784,293208.15874998941,298887.35172691214,304663.55285600905,310728.93291411741,316962.45380700618,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Other",836239.41438426322,1046955.0256511604,1165277.4551248569,1165277.4551248569,1165277.4551248569,1165277.4551248569,1165277.4551248569,210288.0802359427,265014.09631931956,297339.33594617475,299747.78456733882,302228.19748463359,304933.13985212101,307708.03142477537,1049584.9949790481,1322765.0702714417,1487533.0653401567,1503040.5975463279,1518183.7315666073,1534731.934240683,1551844.1953074667,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]

{"sheet":"2.14 Forecast price changes","index":11,"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.14606414467166939,5.0800334844735895E-2,0.20255194374361318,0,0,0,0,0,0,0]
[null,"Copper",-0.17372058578533456,-6.4234208521518621E-3,8.2041303586738001E-2,0,0,0,0,0,0,0]
[null,"Steel",-0.61813478949582989,1.1927175622259196,-8.4941334533174206E-2,0,0,0,0,0,0,0]
[null,"Oil",-0.17517100611409409,3.318247102281191E-2,-0.45934555422305978,0,0,0,0,0,0,0]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Labour and Other price changes"]
[null,"Internal labour",6.1999999999999998E-3,2.2158338086486262E-2,2.2894230769230806E-2,5.875E-3,6.6E-3,8.0499999999999999E-3,8.0999999999999996E-3,8.2750000000000011E-3,8.9499999999999996E-3,9.1000000000000004E-3]
[null,"External labour",-4.4996799492587058E-3,2.1858868895029193E-2,5.0865462725739885E-3,4.1000000000000003E-3,6.6249999999999998E-3,1.0375000000000001E-2,1.0425E-2,1.0075000000000001E-2,1.09E-2,1.115E-2]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"CPI",3.5199076745527913E-2,2.0040080160320661E-2,2.16110019646365E-2,2.3076923076923217E-2,2.35E-2,2.35E-2,2.35E-2,2.35E-2,2.35E-2,2.35E-2]

{"sheet":"2.15 Insurance & Self-insurance","index":12,"n_rows":30,"n_cols":14,"rows_kept":30,"cut":false,"hidden":false,"merged":[[24,2,24,3],[25,2,25,3],[26,2,26,3],[27,2,27,3],[28,2,28,3],[19,2,19,3],[20,2,20,3],[21,2,21,3],[22,2,22,3],[23,2,23,3],[14,2,14,3],[15,2,15,3],[16,2,16,3],[17,2,17,3],[18,2,18,3],[7,1,7,3],[12,7,13,7],[12,8,12,13],[12,2,13,3],[12,1,13,1],[12,4,13,4],[12,5,13,5],[12,6,13,6]]}
[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.15 Commercial insurance and self-insurance"]
[]
[]
[null,"Instruction"]
[null,"The TNSP is required to provide a list of forecast commercial insurance premiums by risk category in table 2.15.4 below.  Previous tables 2.15.1, 2.15.2 & 2.15.3 have been deleted from this template."]
[]
[]
[null,"Table 2.15.4 -Proposed self-insurance allowance by risk category"]
[]
[null,"Risk class\n(drop down)","Risk category",null,"Commercially insured \n(Yes/No)","Commercial insurance deductable \n($0's)","Commercial insurance limit \n($0's)","Self insurance limit\n($0's)","Proposed self insurance allowance ($0's)"]
[null,null,null,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"},"Total"]
[null,"Property","Tower failure",null,"No","N/A","N/A","N/A",1086309.9786936864,1096135.1157865983,1092669.8050275622,1097083.028943151,1098015.3060898308,{"$f":"+SUM(I15:M15)","v":5470213.2345408285}]
[null,"Property","Machinery breakdown",null,"Yes",500000,null,"N/A",737386.02739353059,730112.90531688835,724672.20229807228,715408.76509234053,706188.67922430474,{"$f":"+SUM(I16:M16)","v":3613768.5793251367}]
[null,"Property","Property damage",null,"Yes",500000,null,"N/A",400323.51353134029,398857.97605274455,398192.27782524284,397346.87854999839,395429.63033095631,1990150.2762902824]
[null,"Liability","Fire liability",null,"Yes",10000000,null,"N/A",63260.999669150071,63740.015543537869,58502.182998021461,59002.784749883751,60350.308045954611,304856.29100654775]
[null,"Other insurance","Risk margin",null,"No","N/A","N/A","N/A",429977.10712625441,429762.2260132478,427443.36932425358,425926.35241322336,424253.65805439733,2137362.7129313764]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+SUM(I24:M24)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Total",null,null,null,null,null,null,{"$f":"+SUM(I15:I29)","v":2717257.6264139619},2718608.2387130167,2701479.8374731522,2694767.8097485974,2684237.5817454439,13516351.094094172]

{"sheet":"2.16 Opex Summary","index":13,"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",202782938.95335346,202705216.76180908,209239339.47378743,209385950.66250721,209478867.73362181,209584927.83026168,209689982.77806696,null,"Maintenance",0,0,0,0,0,0,0]
[null,"Real price changes",331587.08764025738,763410.88967129681,1358882.5562703174,1961857.6686468848,2565427.2281610589,3222922.8800732624,3898527.530082081,null,"Emergency response",0,0,0,0,0,0,0]
[null,"Output growth",1254975.0293199318,2528764.3240741855,4062643.904517462,5378525.0546756554,6714133.5592916617,8069765.1658301027,9445720.0555261523,null,"Non-network",0,0,0,0,0,0,0]
[null,"Productivity growth",-231320.80440357301,-463280.82311195054,-695881.82248126948,-929125.57374871743,-1163013.8530459653,-1397548.4414127192,-1632731.1248102523,null,"Network overheads",0,0,0,0,0,0,0]
[null,"Step changes",3246652.1261118171,4289500.3826399362,8150857.0170270829,1506732.2584545901,1195537.818158451,1628358.5472521852,982233.82248067798,null,"Corporate overheads",0,0,0,0,0,0,0]
[null,"Total opex",{"$f":"SUM(C13:C17)","v":207384832.39202189},209823611.53508255,222115841.12912104,217303940.07053563,218790952.48618701,221108425.98200449,222383733.06134561,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":14,"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,"Refer to unlocked sheet"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,{"$f":"SUM(D19:D26)","v":0},0,0,{"$f":"SUM(G19:G26)","v":0},0,0,{"$f":"SUM(J19:J26)","v":0},0,0,0,0,0]
[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":15,"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",62576229.820511751,58994884.252716176,63954607.128896095,65011408.415567882,65417301.637770638,65825729.019928485,66236706.383854471]
["TREV0102","From Variable Customer (Exit Point) Charges",0,0,0,0,0,0,0]
["TREV0103","From Fixed Generator (Entry Point) Charges",8297857.7659850335,7822957.053403792,8480636.0970804188,8620772.164543502,8674595.2254034542,8728754.3259852622,8783251.5643244665]
["TREV0104","From Variable Generator (Entry Point) Charges",0,0,0,0,0,0,0]
["TREV0105","From Fixed Energy Usage Charges (Charge per day basis)",0,0,0,0,0,0,0]
["TREV0106","From Variable Energy Usage charges (Charge per kWh basis)",0,0,0,0,0,0,0]
["TREV0107","From Energy based Common Service and General Charges",0,0,0,0,0,0,0]
["TREV0108","From Fixed Demand based Usage Charges",0,0,0,0,0,0,0]
["TREV0109","From Variable Demand based Usage Charges",0,0,0,0,0,0,0]
["TREV0110","Revenue from other Sources",492588834.49415225,469271285.62491983,509322902.37149781,511758122.72651249,514953241.22162515,518168308.1684466,521403448.11344564]
["TREV01","Total revenue by chargeable quantity"]
[]
[]
[null,"Table 3.1.2 Revenue Grouping by type of connected equipment"]
["TREV0201","From Other connected transmission networks",0,0,0,0,0,0,0]
["TREV0202","From Distribution networks",62390921.653858848,59359885.818809524,63765217.147587597,64163329.880156808,64563928.195853025,64967027.61320401,65372643.747626126]
["TREV0203","From Directly connected end–users",185308.16665290322,176305.64386972677,189389.98130848893,190572.42161611683,191762.24438965679,192959.49572090947,194164.22198944585]
["TREV0204","From Generators",8297857.7659850335,7894736.5493699005,8480636.0970804188,8533584.2302722055,8586862.9406490512,8640474.2921416145,8694420.3615665268]
["TREV0205","Other revenue",492588834.49415225,468658198.91899067,509322902.37149781,512502816.77457869,515702584.70390743,518922330.11329371,522162177.7304424]
["TREV02","Total revenue by type of connected equipment"]
[]
[]
["TREV0301","Table 3.1.3 Revenue (penalties) allowed (deducted) through incentive schemes"]
["TREV0302","EBSS",13427518.289454015,13005512.198543658,1103851.7874306247,1110743.5925730469,1117678.4261171636,1124656.5567071566,1131678.2546644651]
["TREV0303","STPIS",15280100.680500001,8010697.2374037579,0,0,0,0,0]
["TREV03","Other",0,0,0,0,0,0,0]
[null,"Total revenue of incentive schemes"]

{"sheet":"3.2 Operating expenditure","index":16,"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",4309355.2955488544,4383954.3577875951,4599227.9435441224,4684371.7600458069,4770427.1658416167,4860072.0807139501,4951516.0488501918]
[null,"Network Maintenance",32701285.182684582,33267375.709299926,34900966.452535853,35547075.216842122,36200101.522040747,36880366.602398738,37574283.690959126]
[null,"Asset Works Program",4188819.7029663441,4284979.5658429638,11626107.259792622,5062189.2763710888,4832060.342259449,5349327.9498936813,4789344.8393058646]
[null,"Asset Works Program - Asset Management Support",1375031.3183859226,1398834.4257803021,1467524.0329570905,1494691.7660000466,1522150.3694268444,1550754.3152678427,1579932.3039555454]
[null,"Availability Rebate",0,0,0,0,0,0,0]
[null,"Easement Tax",115270038.41066509,115270038.41066509,115270038.41066509,115270038.41066509,115270038.41066509,115270038.41066509,115270038.41066509]
[null,"Insurance",4872827.5441775303,5156067.2019188488,5536558.2106536217,5681818.7870743601,5791864.2594288131,5904636.3837932609,6020221.5596016767]
[null,"Taxes and Charges",5392801.0858275779,5486155.6310558012,5755552.6863918798,5862103.1178580578,5969794.3277929453,6081977.5109159024,6196412.0601318534]
[null,"Self Insurance Costs",1845019.4264974522,1845019.4264974522,2717257.6264139619,2718608.2387130167,2701479.8374731522,2694767.809748597,2684237.5817454439]
[null,"OHS",975299.62864481355,988698.4289015769,1027363.8985408321,1042656.6509718691,1058113.1347220626,1074214.3332138739,1090638.66117422]
[null,"Finance",10584247.83447032,10767733.947350504,11211270.615020264,11421586.956880508,11634553.820104051,11856935.269325834,12084290.882877592]
[null,"HR",4128260.1377119264,4199724.2695436599,4405951.2575339349,4487517.0137851369,4569956.0509535065,4655833.752659441,4743434.9047113433]
[null,"IT ",9591144.7584718652,10413987.819068879,10629992.799547706,10823180.567925487,11019668.239741866,11225992.84299984,11438037.053387983]
[null,"Building Services",5523621.1359059708,5619240.3013357241,5895172.464440316,6004307.6255411375,6114611.2384281224,6229515.7920226632,6346726.3259673063]
[null,"Strategy and Business Development",4115669.5501049594,4186915.7268218095,4392513.7527620699,4473830.7454263,4556018.355629052,4641634.1429471467,4728968.1243405668]
[null,"Other Corporate Services",2511411.3799586901,2554886.3132124259,2680343.7183216973,2729963.9364356021,2780115.4116796576,2832358.7854386861,2885650.6136718201]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Total opex ",{"$f":"SUM(C11:C44)","v":207384832.39202192},{"$f":"SUM(D11:D44)","v":209823611.53508255},222115841.12912112,217303940.07053563,218790952.48618698,221108425.98200455,222383733.06134558]

{"sheet":"3.3 Assets (RAB)","index":17,"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",2843080901.9030499,2948310173.0017223,3138660649.2973204,3247983757.2980847,3297916190.1573553,3336987433.850852,3385321123.6750555]
["TRAB0102","Inflation addition",67151383.917641282,69228510.496938378,72064997.809953123,72920460.037099272,72392645.050602928,71627571.350659609,71092733.816832826]
["TRAB0103","Straight line depreciation",-156195699.88082922,-165193904.91912988,-175262698.08520457,-185994485.00478902,-194869265.76500046,-194589576.07919928,-177272243.16696265]
["TRAB0104","Regulatory depreciation",-89044315.963187933,-95965394.422191501,-103197700.27525142,-113074024.96768975,-122476620.71439753,-122962004.72853968,-106179509.35012987]
["TRAB0105","Actual additions (recognised in RAB)",194273587.06186038,185839087.71375939,212520808.27601579,163006457.82696009,161547864.40789449,171295694.55274332,121994382.08685613]
["TRAB0106","Disposals ",0,0,0,0,0,0,0]
["TRAB0107","Closing value ",2948310173.0017223,3038183866.2932906,3247983757.2980847,3297916190.1573553,3336987433.850852,3385321123.6750555,3401135996.4117818]
[]
[]
[null,"TABLE 3.3.2 - ASSET VALUE ROLL FORWARD"]
[null,"For overhead transmission assets:"]
["TRAB0201","Opening value",1080937029.0388298,1084127653.106926,1082901452.4721084,1074322052.2160997,1065574772.0394648,1051112557.8386478,1035996580.5224115]
["TRAB0202","Inflation addition",25530901.135874979,25475278.282657012,24863882.885290224,24096028.435884167,23341919.950783838,22473885.192701299,21610744.694635522]
["TRAB0203","Straight line depreciation",-47271277.45004303,-47708330.508861899,-48036322.595352776,-48540725.91697441,-49054220.373563603,-49401652.223523736,-49757288.57778836]
["TRAB0204","Regulatory depreciation",-21740376.314168051,-22233052.226204887,-23172439.710062552,-24444697.481090244,-25712300.422779765,-26927767.030822437,-28146543.883152839]
["TRAB0205","Actual additions (recognised in RAB)",24931000.382264171,11540011.540375484,14593039.454053897,15697417.304455329,11250086.221962793,11811789.714586031,11167446.939913422]
["TRAB0206","Disposals ",0,0,0,0,0,0,0]
["TRAB0207","Closing value ",1084127653.106926,1073434612.4210966,1074322052.2160997,1065574772.0394648,1051112557.8386478,1035996580.5224115,1019017483.579172]
[null,"For underground transmission assets:"]
["TRAB0301","Opening value",35268442.509224705,34559104.970064871,33866304.526688591,33129061.698388811,32374988.738429066,31593020.952308632,30782413.144055482]
["TRAB0302","Inflation addition",833013.48249673168,812521.70412529923,777584.91096940089,742786.10615626362,708429.57860595267,674245.0004562604,640213.23670991627]
["TRAB0303","Straight line depreciation",-1542351.0216565665,-1520814.6358754416,-1514827.7392691795,-1496859.0661160096,-1490397.3647263872,-1484852.808709411,-1478430.955010609]
["TRAB0304","Regulatory depreciation",-709337.53915983485,-708292.93175014236,-737242.82829977863,-754072.95995974599,-781967.78612043452,-810607.80825315055,-838217.71830069274]
["TRAB0305","Actual additions (recognised in RAB)",0,0,0,0,0,0,0]
["TRAB0306","Disposals ",0,0,0,0,0,0,0]
["TRAB0307","Closing value ",34559104.970064871,33850812.03831473,33129061.698388811,32374988.738429066,31593020.952308632,30782413.144055482,29944195.425754789]
[null,"For transmission switchyards, substations"]
["TRAB0401","Opening value",1246581073.9461718,1300735704.5240121,1440647819.0938616,1524896756.0282655,1573493392.3940382,1630093357.8672135,1700124778.7388926]
["TRAB0402","Inflation addition",29443286.058090337,30538068.836737718,33077893.257162426,34252802.418291084,34582143.012102328,35087681.681213431,35890004.955249526]
["TRAB0403","Straight line depreciation",-63488102.119309351,-65457414.079652026,-68355894.53926459,-63059840.934289895,-66264870.853653446,-64956132.13946227,-54296484.914547846]
["TRAB0404","Regulatory depreciation",-34044816.061219014,-34919345.242914304,-35278001.282102168,-28807038.515998811,-31682727.841551118,-29868450.458248839,-18406479.95929832]
["TRAB0405","Actual additions (recognised in RAB)",88199446.63905926,109619765.53146684,119526938.21650612,77403674.881771624,88282693.314726382,99899871.329927847,60633802.541836135]
["TRAB0406","Disposals ",0,0,0,0,0,0,0]
["TRAB0407","Closing value ",1300735704.5240121,1375436124.8125648,1524896756.0282655,1573493392.3940382,1630093357.8672135,1700124778.7388926,1742352101.3214302]
[null,"For easements:"]
["TRAB0501","Opening value",130999434.95203204,134093540.83680294,137172027.55817571,140321556.28081092,143471085.00344613,146620613.72608134,149770142.44871655]
["TRAB0502","Inflation addition",3094105.8847708991,3149528.7226352016,3149528.7226352016,3149528.7226352016,3149528.7226352012,3149528.7226352007,3149528.7226352007]
["TRAB0503","Straight line depreciation",0,0,0,0,0,0,0]
["TRAB0504","Regulatory depreciation",3094105.8847708991,3149528.7226352016,3149528.7226352016,3149528.7226352016,3149528.7226352012,3149528.7226352007,3149528.7226352007]
["TRAB0505","Actual additions (recognised in RAB)",0,0,0,0,0,0,0]
["TRAB0506","Disposals ",0,0,0,0,0,0,0]
["TRAB0507","Closing value ",134093540.83680294,137243069.55943814,140321556.28081092,143471085.00344613,146620613.72608134,149770142.44871655,152919671.17135176]
[null,"For “other” assets with long lives:"]
["TRAB0601","Opening value",284825555.59645349,304475268.24140012,346812770.74473405,365473658.32589674,372451461.09217578,377271613.04568601,380688492.1599049]
["TRAB0602","Inflation addition",6727360.526607045,7144566.406205222,7962970.310211285,8208599.089759266,8180339.477056006,8103188.1269794777,7995588.4574143849]
["TRAB0603","Straight line depreciation",-31801710.367739957,-33765540.263275579,-39376815.256932743,-45701175.4360957,-48577450.495495655,-50370011.985048294,-51762475.669560447]
["TRAB0604","Regulatory depreciation",-25074349.841132913,-26620973.857070357,-31413844.946721457,-37492576.346336432,-40397111.018439651,-42266823.858068816,-43766887.212146059]
["TRAB0605","Actual additions (recognised in RAB)",44724062.486079544,43346049.710747838,50074732.527884148,44470379.112615474,45217262.971949875,45683702.972287737,38069376.778052874]
["TRAB0606","Disposals ",0,0,0,0,0,0,0]
["TRAB0607","Closing value ",304475268.24140012,321200344.09507763,365473658.32589674,372451461.09217578,377271613.04568601,380688492.1599049,374990981.72581172]
[null,"For “other” assets with short lives:"]
["TRAB0701","Opening value",64469365.86033792,90318901.322516322,97260274.901752234,109840672.74862319,110550490.88980114,100296270.42091483,87958716.661074877]
["TRAB0702","Inflation addition",1522716.8298012984,2108546.5445779241,2233137.7236845898,2470715.2643732852,2430284.3094196059,2139042.6266739396,1806653.7501882764]
["TRAB0703","Straight line depreciation",-12092258.92208031,-16741805.431464946,-17978837.954385269,-27195883.651312999,-29482326.67756138,-28376926.922455575,-19977563.050055422]
["TRAB0704","Regulatory depreciation",-10569542.092279011,-14633258.886887021,-15745700.230700679,-24725168.386939716,-27052042.368141774,-26237884.295781635,-18170909.299867146]
["TRAB0705","Actual additions (recognised in RAB)",36419077.554457411,21333260.931169249,28326098.077571638,25434986.528117668,16797821.899255462,13900330.535941688,12123755.827053702]
["TRAB0706","Disposals ",0,0,0,0,0,0,0]
["TRAB0707","Closing value ",90318901.322516322,97018903.36679855,109840672.74862319,110550490.88980114,100296270.42091483,87958716.661074877,81911563.18826142]
[]
[]
[null,"TABLE 3.3.3 - TOTAL DISAGGREGATED RAB ASSET VALUES"]
["TRAB0801","Overhead transmission assets (wires and towers/poles etc)",1082532341.0728779,1078781132.7640114,1078611752.3441041,1069948412.1277823,1058343664.9390564,1043554569.1805296,1027507032.0507917]
["TRAB0802","Underground transmission assets (cables, ducts etc)",34913773.739644788,34204958.504189804,33497683.112538703,32752025.218408938,31984004.845368847,31187717.048182055,30363304.284905136]
["TRAB0803","Substations, switchyards, Transformers etc with transmission function",1273658389.2350919,1338085914.6682885,1482772287.5610635,1549195074.2111518,1601793375.1306257,1665109068.3030529,1721238440.0301614]
["TRAB0804","Easements",132546487.89441749,135668305.19812053,138746791.91949332,141896320.64212853,145045849.36476374,148195378.08739895,151344906.81003416]
["TRAB0805","Other assets with long lives (please specify)",294650411.91892684,312837806.16823888,356143214.53531539,368962559.70903623,374861537.06893086,378980052.60279548,377839736.94285834]
["TRAB0806","Other assets with short lives (please specify)",77394133.591427118,93668902.344657436,103550473.82518771,110195581.81921217,105423380.65535799,94127493.540994853,84935139.924668148]
[]
[]
[null,"TABLE 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",16.715188687596651,16.587593168141588,16.32893665054241,16.275968574211216,16.244882162408953,16.217346798184458,16.202530022962662]
["TRAB0905","“Other assets with short lives",5.1409681794016384,5.1328483173600814,5.1410876375122951,5.1467532668938585,5.1858039041118813,5.2295695658127181,5.2662169927605449]
[]
[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.5,8.8000000000000007,8.1999999999999993,7.4]
["TRAB1004","Other assets with long lives",12.534019616750546,12.135912073330125,11.653040947943612,11.320029961800808,11.052328485135877,10.82757851359032,10.518706299950408]
["TRAB1005","Other assets with short lives",3.520107771723235,3.2491863469359035,3.205936005793713,3.0960378416055754,2.8487918559863274,2.7058315355018312,2.6122574859728487]

{"sheet":"3.4 Operational data","index":18,"n_rows":88,"n_cols":10,"rows_kept":88,"cut":false,"hidden":false,"merged":[[6,3,6,9]]}
[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.4 OPERATIONAL DATA"]
[]
[]
[null,null,null,"Forecast (0's)"]
[null,null,"Units",{"$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,"TABLE 3.4.1 - ENERGY DELIVERY"]
[null,"Energy Grouping by Downstream Connection type"]
["TOPED0101","To Other connected transmission networks","GWh"]
["TOPED0102","To Distribution networks","GWh"]
["TOPED0103","To Directly connected end–users (330 kV)","GWh"]
["TOPED0104","To Directly connected end–users (275 kV)","GWh"]
["TOPED0105","To Directly connected end–users (220 kV)","GWh"]
["TOPED0106","To Directly connected end–users (132 kV)","GWh"]
["TOPED0107","To Directly connected end–users (110 kV)","GWh"]
["TOPED0108","To Directly connected end–users (44 kV) ","GWh"]
["TOPED0109","To Directly connected end–users (33 kV)","GWh"]
["TOPED0110","To Directly connected end–users (22 kV)","GWh"]
["TOPED0111","To Directly connected end–users (11 kV)","GWh"]
["TOPED0112","To Directly connected end–users (6.6 kV)","GWh"]
["TOPED0113","Pumping and Power Station Auxillaries","GWh"]
["TOPED01","Total energy transported","GWh",{"$f":"SUM(D12:D24)","v":0},{"$f":"SUM(E12:E24)","v":0},{"$f":"SUM(F12:F24)","v":0},0,0,0,0]
[]
[]
[null,"TABLE 3.4.2 -  CONNECTION POINTS"]
[null,"Number of entry points at each transmission voltage level"]
["TOPCP0101","500kV","number"]
["TOPCP0102","330kV","number"]
["TOPCP0103","275kV","number"]
["TOPCP0104","220kV","number"]
["TOPCP0105","132 kV","number"]
["TOPCP0106","110kV","number"]
["TOPCP0107","66 kV","number"]
["TOPCP0108","33 kV","number"]
["TOPCP0109","22 kV","number"]
["TOPCP0110","11 kV","number"]
["TOPCP0111","6.6 kV","number"]
[]
[null,"Number of exit points at each transmission voltage level "]
["TOPCP0201","500kV","number"]
["TOPCP0202","330kV","number"]
["TOPCP0203","275kV","number"]
["TOPCP0204","220kV","number"]
["TOPCP0205","132 kV","number"]
["TOPCP0206","110kV","number"]
["TOPCP0207","66 kV","number"]
["TOPCP0208","44 kV","number"]
["TOPCP0209","33kV","number"]
["TOPCP0210","22kV","number"]
["TOPCP0211","11kV","number"]
["TOPCP0212","6.6kV","number"]
[]
[]
[null,"TABLE 3.4.3 - SYSTEM DEMAND"]
[null,"Table 3.4.3.1 Annual system maximum demand characteristics – MW measure"]
["TOPSD0101","Transmission System coincident maximum demand","MW"]
["TOPSD0102","Transmission System coincident weather adjusted maximum demand 10% POE","MW"]
["TOPSD0103","Transmission System coincident weather adjusted maximum demand 50% POE","MW"]
["TOPSD0104","Transmission System non-coincident summated maximum demand","MW"]
["TOPSD0105","Transmission System non-coincident weather adjusted summated maximum demand 10% POE","MW"]
["TOPSD0106","Transmission System non-coincident weather adjusted summated maximum demand 50% POE","MW"]
[]
[null,"Table 3.4.3.2 Annual system maximum demand characteristics – MVA measure"]
["TOPSD0201","Transmission System coincident maximum demand","MVA"]
["TOPSD0202","Transmission System coincident weather adjusted maximum demand 10% POE","MVA"]
["TOPSD0203","Transmission System coincident weather adjusted maximum demand 50% POE","MVA"]
["TOPSD0204","Transmission System non-coincident summated maximum demand","MVA"]
["TOPSD0205","Transmission System non-coincident weather adjusted summated maximum demand 10% POE","MVA"]
["TOPSD0206","Transmission System non-coincident weather adjusted summated maximum demand 50% POE","MVA"]
[]
[null,"Table 3.4.3.3 Power factor"]
[null,"Power factor conversion between MVA and MW"]
["TOPSD0301","Average overall network power factor conversion between MVA and MW","Factor"]
["TOPSD0302","Average power factor conversion for 500 kV lines","Factor"]
["TOPSD0303","Average power factor conversion for 330 kV lines","Factor"]
["TOPSD0304","Average power factor conversion for  275 kV lines","Factor"]
["TOPSD0305","Average power factor conversion for  220 kV lines","Factor"]
["TOPSD0306","Average power factor conversion for  132 kV lines","Factor"]
["TOPSD0307","Average power factor conversion for  110 kV lines","Factor"]
["TOPSD0308","Average power factor conversion for  88 kV lines","Factor"]
["TOPSD0309","Average power factor conversion for  66 kV lines","Factor"]
["TOPSD0310","Average power factor conversion for  33 kV lines","Factor"]
["TOPSD0311","Average power factor conversion for  22 kV lines","Factor"]
["TOPSD0311","Average power factor conversion for  11 kV lines","Factor"]
["TOPSD0312","Average power factor conversion for  6.6 kV lines","Factor"]

{"sheet":"3.5 Physical assets","index":19,"n_rows":74,"n_cols":10,"rows_kept":74,"cut":false,"hidden":false,"merged":[[6,3,6,9]]}
[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.5 PHYSICAL ASSETS"]
[]
[]
[null,null,null,"Forecast (0's)"]
[null,null,"Units",{"$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,"TABLE 3.5.1 - TRANSMISSION SYSTEM CAPACITIES "]
[null,"Table 3.5.1.1 Overhead network length of circuit at each voltage"]
["TPA0101","500 kV","km"]
["TPA0102","330 kV","km"]
["TPA0103","275 kV","km"]
["TPA0104","220 kV","km"]
["TPA0105","132 kV","km"]
["TPA0106","110 kV","km"]
["TPA0107","88 kV","km"]
["TPA0108","66 kV","km"]
["TPA0109","33 kV","km"]
["TPA0109","22 kV","km"]
["TPA0109","11 kV","km"]
["TPA01","Total overhead circuit kilometres","km",{"$f":"SUM(D12:D22)","v":0},{"$f":"SUM(E12:E22)","v":0},{"$f":"SUM(F12:F22)","v":0},0,0,0,0]
[]
[null,"Table 3.5.1.2 Underground cable circuit length at each voltage"]
["TPA0201","500 kV","km"]
["TPA0202","330 kV","km"]
["TPA0203","275 kV","km"]
["TPA0204","220 kV","km"]
["TPA0205","132 kV","km"]
["TPA0206","110 kV","km"]
["TPA0207","88 kV","km"]
["TPA0208","66 kV","km"]
["TPA0209","33 kV","km"]
["TPA0210","22 kV","km"]
["TPA0211","11 kV","km"]
["TPA02","Total underground circuit kilometres","km",{"$f":"SUM(D26:D36)","v":0},{"$f":"SUM(E26:E36)","v":0},{"$f":"SUM(F26:F36)","v":0},0,0,0,0]
[]
["TPA0301","Table 3.5.1.3 Estimated overhead network weighted average MVA capacity by voltage class"]
["TPA0302","500 kV","MVA"]
["TPA0303","330 kV","MVA"]
["TPA0304","275 kV","MVA"]
["TPA0305","220 kV","MVA"]
["TPA0306","132 kV","MVA"]
["TPA0307","110 kV","MVA"]
["TPA0308","88 kV","MVA"]
["TPA0309","66 kV","MVA"]
["TPA0310","33 kV","MVA"]
["TPA0311","22 kV","MVA"]
["TPA0312","11 kV","MVA"]
[]
[null,"Table 3.5.1.4 Estimated underground network weighted average MVA capacity by voltage class"]
["TPA0401","500 kV","MVA"]
["TPA0402","330 kV","MVA"]
["TPA0403","275 kV","MVA"]
["TPA0404","220 kV","MVA"]
["TPA0405","132 kV","MVA"]
["TPA0406","110 kV","MVA"]
["TPA0407","88 kV","MVA"]
["TPA0408","66 kV","MVA"]
["TPA0409","33 kV","MVA"]
["TPA0410","22 kV","MVA"]
["TPA0411","11 kV","MVA"]
[]
[null,"Table 3.5.1.5 Installed transmission system transformer capacity"]
["TPA0501","Transmission substations (eg 500 kV to 330 kV)","MVA"]
["TPA0502","Terminal points to DNSP systems","MVA"]
["TPA0503","Transformer capacity for directly connected end–users owned by the TNSP","MVA"]
["TPA0504","Transformer capacity for directly connected end–users owned by the end–user","MVA"]
["TPA0505","Interconnector capacity","MVA"]
["TPA0506","Other","MVA"]
[]
[null,"Table 3.5.1.6 Cold spare capacity"]
["TPA06","Cold spare capacity included in Table 3.5.1.5","MVA"]

{"sheet":"3.7 Operating environment","index":20,"n_rows":23,"n_cols":10,"rows_kept":23,"cut":false,"hidden":false,"merged":[[6,3,6,9]]}
[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.7 OPERATING ENVIRONMENT FACTORS"]
[]
[]
[null,null,null,"Forecast (0's)"]
[null,null,"Units",{"$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"}]
["TEF01","TABLE 3.7.1 - TERRAIN FACTORS"]
["TEF0101","Total number of vegetation maintenance spans","Number of spans",2101]
["TEF0102","Average vegetation maintenance span cycle","Years",0.33300000000000002]
["TEF0103","Average number of trees per vegetation maintenance span","Trees",30]
["TEF0104","Average number of defects per vegetation maintenance span","Defects",0.30399999999999999]
["TEF0105","Tropical proportion","Number of spans",0]
["TEF0106","Standard vehicle access","km",4446.2777999999998]
["TEF0107","Altitude","km",212.45]
["TEF0108","Bushfire risk","Number of spans",1683]
[]
["TEF02","TABLE 3.7.2 - NETWORK CHARACTERISTICS"]
["TEF0201","Route line length","km",5002,5002,5002,5002,5002,5002,5002]
["TEF0202","Variability of dispatch","%"]
["TEF0203","Concentrated load distance","km"]
["TEF0204","Total number of spans","number",12874,12874,12874,12874,12874,12874,12874]

{"sheet":"7.1  Policies and Procedures","index":21,"n_rows":219,"n_cols":5,"rows_kept":219,"cut":false,"hidden":false,"merged":[[13,1,14,1],[6,1,8,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.1  PLANS, POLICIES, PROCEDURES AND STRATEGIES"]
[]
[null,"Instructions"]
[null,"The TNSP must list and provide a brief description of key internal plans, policies, procedures or strategies that are used by it to plan and conduct its day to day operations and that have been relied upon in the development of its regulatory proposal. The TNSP must identify any internal plans, policies, procedures and strategies that have changed in the current regulatory control period or that are expected to change before the next regulatory control period where the change has been identified as a step change."]
[]
[]
[]
[]
[null,"TABLE 7.1.1 - PLANS, POLICIES, PROCEDURES AND STRATEGIES"]
[]
[null,null,"Brief description","Relevance to regulatory proposal","Expenditure impact"]
[null,null,"Description of the plan, policy, procedure or strategy.","Identify the element of the proposal/supporting documents that the policy, plan, procedure or strategy is relevant to e.g. replacement capex, capacity utilisation thresholds, opex ","Is this policy, plan or procedure identified in the response to section 4 'Step Changes' of the notice (yes or no)?"]
[null,"Corporate"]
[null,"<insert relevant policy, plan, strategy etc>"]
[]
[]
[null,"Governance framework"]
[null,"AMS 01-03 Asset Management Committee Charter","The objective of this charter is to establish and maintain an Asset Management System to optimise asset performance and life-cycle costs and so achieve AusNet Services' strategic plan, to the benefit of the community, customers and security holders.","Forms part of the governance systems for capital expenditure forecasting, planning and execution.","No"]
[null,"AMS 01-04 ISO 55001 Accreditation","Certificate demonstrates AusNet Services' achievement of the standard necessary to demonstrate compliance with the requirements of Asset Management systems.","Demonstrates that AM system has appropriate governance and controls.","No"]
[null,"QMS 10-01-1 Health, Safety, Enviornment and Quality Policy","High level document that shows AusNet Services commitment to providing a safe and healthy work enviornment","Demonstrates that AM system has appropriate governance and controls.","No"]
[null,"PTP 10-01 Procurement Principles","This document defines the priciples to ensure an integrated, consistent and compliant approach to procuremnt is undertaken across the organisation","Demonstrates that cost forecasts based on unit rates are subject to formal competitive procedures.","No"]
[null,"ESMS 10-01 Electricity Safety Management Scheme","This document (ESMS 10-01 Overview) contains a summary of the structure of the ESMS for AusNet Services' electricity distribution supply network.  It also outlines the period of application, the location of ESMS records, exemptions and lists officers responsible for the operation of this ESMS.","Forecast includes safety related expenditure  required to meet the ESMS obligations which are outlined in this document.","No"]
[null,"ESMS 10-03 Electricity Safety Management System","This document describe the assets forming AusNet Services' electricity distribution supply network, their location and the associated planning, design, construction, commissioning, operation, augmentation, inspection, testing, maintenance, refurbishment, replacement and decommissioning processes necessary to ensure the safety of consumers, the general public, AusNet Services' staff and contractors.","Forecast includes safety related expenditure  required to meet the ESMS obligations. Details of the expenditure programs are incorporated in this document.","No"]
[null,"AMS 01-01 Asset Management System","The document provides an overview of the systems, policies, strategies, plans, standards, processes and procedures which have been integrated in AusNet Services ISO 55001 certified asset management system to enable performance management of the  gas and electricity networks and the assets forming those networks. ","Provides an overview of the asset management system and interdependencies.","No"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Accounting policies, procedures and methodologies (including a capitalisation policy, depreciation policy and an approved expenditure allocation methodology)"]
[null,"Capitalisation Policy","Document prescribes the accounting treatment for property, plant and equipment.  ","Demonstrates consistency in capitalisation of assets.","No"]
[]
[]
[null,"Asset management plan or equivalent documentation"]
[null,"Asset Management Policies"]
[null,"Asset Management Policy","High level document that directs the content and implementation of asset management strategies, objectives and plans for the network and guides asset management decisions.","Underpins all asset related expenditure.","No"]
[]
[null,"Asset Management Strategies"]
[null,"<insert relevant policy, plan, strategy etc>"]
[]
[]
[]
[null,"Asset Management Plans"]
[null,"AMS 10-01 Asset Management Strategy","Document sets the framework for AusNet Services’ holistic approach to management of the network assets, and in so doing establishes the linkages with and between the underpinning detailed strategies, processes and plans. The document provides context for management strategies, by taking into account the demand for network services, the condition of network assets, and expected trends into the future.  It therefore also has regard to the network augmentation planning process.\n","This strategy provides a high level overview of AusNet Services approach to  managing the transmission network, meeting regulatory obligations and informing stakeholders by:\n• presenting a transmission network overview including network summary, planning and regulatory framework;\n• presenting an overview of the asset management system in regard to the transmission network;\n• describing asset management drivers,\n• Summating the process and systems and plant asset management strategies\n","No"]
[null,"AMS 10-52 Auxilliary power supplies","The purpose of this AMS document is to present a current assessment of AusNet Services’ transmission station DC power supply population and condition. \nThis document also specifies the key issues in the population presents key risks associated with failure of DC supply systems"," This strategy is intended to assist in managing the assets, meeting regulatory obligations and informing stakeholders by:\n• presenting an overview of the asset population;\n• describing the condition and life cycle phase of the current fleet;\n• understanding asset behaviour through a risk assessment;\n• exploring key issues \n• outlining strategies to manage  the emerging performance risks through inspection, maintenance, refurbishment and replacement activities\n","No"]
[null,"AMS 10-53 Capacitor banks","The purpose of this AMS document is to present a current assessment of AusNet Services’ transmission capacitor bank population and condition. \nThis document also specifies the key issues in the population presents key risks associated with asset failure."," This strategy is intended to assist in managing the assets, meeting regulatory obligations and informing stakeholders by:\n• presenting an overview of the asset population;\n• describing the condition and life cycle phase of the current fleet;\n• understanding asset behaviour through a risk assessment;\n• exploring key issues \n• outlining strategies to manage  the emerging performance risks through inspection, maintenance, refurbishment and replacement activities\n","No"]
[null,"AMS 10-54 Circuit breakers","The purpose of this AMS document is to present a current assessment of AusNet Services’ transmission circuit breaker population and condition. \nThis document also specifies the key issues in the population presents key risks associated with asset failure."," This strategy is intended to assist in managing the assets, meeting regulatory obligations and informing stakeholders by:\n• presenting an overview of the asset population;\n• describing the condition and life cycle phase of the current fleet;\n• understanding asset behaviour through a riisk assessment;\n• exploring key issues \n• outlining strategies to manage  the emerging performance risks through inspection, maintenance, refurbishment and replacement activities\n","No"]
[null,"AMS 10-55 Civil infrastructure","The purpose of this AMS document is to present a current assessment of the civil infrastructure associated to AusNet Services’ transmission network. This document also specifies the key issues in the population presents key risks associated with asset failure."," This strategy is intended to assist in managing the assets, meeting regulatory obligations and informing stakeholders by:\n• presenting an overview of the asset population;\n• describing the condition and life cycle phase of the current fleet;\n• understanding asset behaviour through a riisk assessment;\n• exploring key issues \n• outlining strategies to manage  the emerging performance risks through inspection, maintenance, refurbishment and replacement activities\n","No"]
[null,"AMS 10-56 Communications systems","The purpose of this AMS document is to present a current assessment of the communication systems associated to AusNet Services’ transmission network. This document also specifies the key issues in the population presents key risks associated with asset failure."," This strategy is intended to assist in managing the assets, meeting regulatory obligations and informing stakeholders by:\n• presenting an overview of the asset population;\n• describing the condition and life cycle phase of the current fleet;\n• understanding asset behaviour through a risk assessment;\n• exploring key issues \n• outlining strategies to manage  the emerging performance risks through inspection, maintenance, refurbishment and replacement activities\n","No"]
[null,"AMS 10-58 Diesel generators","The purpose of this AMS document is to present a current assessment of AusNet Services’ transmission diesel generator population and condition. \nThis document also specifies the key issues in the population presents key risks associated with asset failure."," This strategy is intended to assist in managing the assets, meeting regulatory obligations and informing stakeholders by:\n• presenting an overview of the asset population;\n• describing the condition and life cycle phase of the current fleet;\n• understanding asset behaviour through a risk assessment;\n• exploring key issues \n• outlining strategies to manage  the emerging performance risks through inspection, maintenance, refurbishment and replacement activities\n","No"]
[null,"AMS 10-59 Disconnectors & earth switches","The purpose of this AMS document is to present a current assessment of AusNet Services’ transmission disconnector and eath switch population and condition. \nThis document also specifies the key issues in the population presents key risks associated with asset failure."," This strategy is intended to assist in managing the assets, meeting regulatory obligations and informing stakeholders by:\n• presenting an overview of the asset population;\n• describing the condition and life cycle phase of the current fleet;\n• understanding asset behaviour through a risk assessment;\n• exploring key issues \n• outlining strategies to manage  the emerging performance risks through inspection, maintenance, refurbishment and replacement activities\n","No"]
[null,"AMS 10-60 Earth grids","The purpose of this AMS document is to present a current assessment of the earth grids associated to AusNet Services’ transmission network. This document also specifies the key issues in the population presents key risks associated with asset failure."," This strategy is intended to assist in managing the assets, meeting regulatory obligations and informing stakeholders by:\n• presenting an overview of the asset population;\n• describing the condition and life cycle phase of the current fleet;\n• understanding asset behaviour through a risk assessment;\n• exploring key issues \n• outlining strategies to manage  the emerging performance risks through inspection, maintenance, refurbishment and replacement activities\n","No"]
[null,"AMS 10-61 Fire detection and suppression","The purpose of this AMS document is to present a current assessment of the fire detection and suppression associated to AusNet Services’ transmission network. This document also specifies the key issues in the population presents key risks associated with asset failure."," This strategy is intended to assist in managing the assets, meeting regulatory obligations and informing stakeholders by:\n• presenting an overview of the asset population;\n• describing the condition and life cycle phase of the current fleet;\n• understanding asset behaviour through a risk assessment;\n• exploring key issues \n• outlining strategies to manage  the emerging performance risks through inspection, maintenance, refurbishment and replacement activities\n","No"]
[null,"AMS 10-62 Gas insulated switchgear","The purpose of this AMS document is to present a current assessment of AusNet Services’ transmission gas insulated switchgear population and condition. \nThis document also specifies the key issues in the population presents key risks associated with asset failure."," This strategy is intended to assist in managing the assets, meeting regulatory obligations and informing stakeholders by:\n• presenting an overview of the asset population;\n• describing the condition and life cycle phase of the current fleet;\n• understanding asset behaviour through a risk assessment;\n• exploring key issues \n• outlining strategies to manage  the emerging performance risks through inspection, maintenance, refurbishment and replacement activities\n","No"]
[null,"AMS 10-63 Infrastructure security","This document includes Strategies for the management of infrastructure physical security associated with the AusNet Services electricity transmission network in Victoria.  This document does not include information technology security strategies: please refer to the Information and Communication Technology Strategy  for information on this topic.\n","Identifies expenditure required to ensure network and site security including upgrades, maintenance and replacements.","No"]
[null,"AMS 10-64 Instrument transformers","The purpose of this AMS document is to present a current assessment of AusNet Services’ transmission intrument transformer population and condition. \nThis document also specifies the key issues in the population presents key risks associated with asset failure."," This strategy is intended to assist in managing the assets, meeting regulatory obligations and informing stakeholders by:\n• presenting an overview of the asset population;\n• describing the condition and life cycle phase of the current fleet;\n• understanding asset behaviour through a risk assessment;\n• exploring key issues \n• outlining strategies to manage  the emerging performance risks through inspection, maintenance, refurbishment and replacement activities\n","No"]
[null,"AMS 10-65 Line easements","The purpose of this AMS document is to present a current assessment of the line easements associated to AusNet Services’ transmission network. This document also specifies the key issues in the population presents key risks associated with asset failure."," This strategy is intended to assist in managing the assets, meeting regulatory obligations and informing stakeholders by:\n• presenting an overview of the asset population;\n• describing the condition and life cycle phase of the current fleet;\n• understanding asset behaviour through a risk assessment;\n• exploring key issues \n• outlining strategies to manage  the emerging performance risks through inspection, maintenance, refurbishment and replacement activities\n","No"]
[null,"AMS 10-66 Power cables","The purpose of this AMS document is to present a current assessment of AusNet Services’ transmission power cable population and condition. \nThis document also specifies the key issues in the population presents key risks associated with asset failure."," This strategy is intended to assist in managing the assets, meeting regulatory obligations and informing stakeholders by:\n• presenting an overview of the asset population;\n• describing the condition and life cycle phase of the current fleet;\n• exploring key issues \n• outlining strategies to manage  the emerging performance risks through inspection, maintenance, refurbishment and replacement activities\n","No"]
[null,"AMS 10-67 Power transformers and oil filled reactors","The purpose of this AMS document is to present a current assessment of AusNet Services’ transmission power transformer and oil filled reactor population and condition. \nThis document also specifies the key issues in the population presents key risks associated with asset failure."," This strategy is intended to assist in managing the assets, meeting regulatory obligations and informing stakeholders by:\n• presenting an overview of the asset population;\n• describing the condition and life cycle phase of the current fleet;\n• understanding asset behaviour through a risk assessment;\n• exploring key issues \n• outlining strategies to manage  the emerging performance risks through inspection, maintenance, refurbishment and replacement activities\n","No"]
[null,"AMS 10-68 Protection systems (Secondary Systems)","The purpose of this AMS document is to present a current assessment of the secondary systems associated to AusNet Services’ transmission network. This document also specifies the key issues in the population presents key risks associated with asset failure."," This strategy is intended to assist in managing the assets, meeting regulatory obligations and informing stakeholders by:\n• presenting an overview of the asset population;\n• describing the condition and life cycle phase of the current fleet;\n• exploring key issues \n• outlining strategies to manage  the emerging performance risks through inspection, maintenance, refurbishment and replacement activities\n","No"]
[null,"AMS 10-71 Static VAR compensators","The purpose of this AMS document is to present a current assessment of AusNet Services’ transmission static var compensator population and condition. \nThis document also specifies the key issues in the population presents key risks associated with asset failure."," This strategy is intended to assist in managing the assets, meeting regulatory obligations and informing stakeholders by:\n• presenting an overview of the asset population;\n• describing the condition and life cycle phase of the current fleet;\n• understanding asset behaviour through a risk assessment;\n• exploring key issues \n• outlining strategies to manage  the emerging performance risks through inspection, maintenance, refurbishment and replacement activities\n","No"]
[null,"AMS 10-73 Surge arresters","The purpose of this AMS document is to present a current assessment of AusNet Services’ transmission surge arrester population and condition. \nThis document also specifies the key issues in the population presents key risks associated with asset failure."," This strategy is intended to assist in managing the assets, meeting regulatory obligations and informing stakeholders by:\n• presenting an overview of the asset population;\n• describing the condition and life cycle phase of the current fleet;\n• understanding asset behaviour through a risk assessment;\n• exploring key issues \n• outlining strategies to manage  the emerging performance risks through inspection, maintenance, refurbishment and replacement activities\n","No"]
[null,"AMS 10-75 Transmission lines Insulators","The purpose of this AMS document is to present a current assessment of AusNet Services’ transmission line insulator population and condition. \nThis document also specifies the key issues in the population presents key risks associated with asset failure."," This strategy is intended to assist in managing the assets, meeting regulatory obligations and informing stakeholders by:\n• presenting an overview of the asset population;\n• describing the condition and life cycle phase of the current fleet;\n• exploring key issues \n• outlining strategies to manage  the emerging performance risks through inspection, maintenance, refurbishment and replacement activities\n","No"]
[null,"AMS 10-77 Transmission line structures","The purpose of this AMS document is to present a current assessment of AusNet Services’ transmission line structure population and condition. \nThis document also specifies the key issues in the population presents key risks associated with asset failure."," This strategy is intended to assist in managing the assets, meeting regulatory obligations and informing stakeholders by:\n• presenting an overview of the asset population;\n• describing the condition and life cycle phase of the current fleet;\n• understanding asset behaviour through a risk assessment;\n• exploring key issues \n• outlining strategies to manage  the emerging performance risks through inspection, maintenance, refurbishment and replacement activities\n","No"]
[null,"AMS 10-78 Transmission line structures foundations","The purpose of this AMS document is to present a current assessment of AusNet Services’ transmission line structure foundation population and condition. \nThis document also specifies the key issues in the population presents key risks associated with asset failure."," This strategy is intended to assist in managing the assets, meeting regulatory obligations and informing stakeholders by:\n• presenting an overview of the asset population;\n• describing the condition and life cycle phase of the current fleet;\n• understanding asset behaviour through a risk assessment;\n• exploring key issues \n• outlining strategies to manage  the emerging performance risks through inspection, maintenance, refurbishment and replacement activities\n","No"]
[null,"AMS 10-79 Transmission Line Conductors and Ground Wires","The purpose of this document is to define the asset management strategies for AusNet Services’ population of transmission line conductors and ground wires. \nThis document also specifies the key issues in the population presents key risks associated with asset failure."," This strategy is intended to assist in managing the assets, meeting regulatory obligations and informing stakeholders by:\n• presenting an overview of the asset population;\n• describing the condition and life cycle phase of the current fleet;\n• understanding asset behaviour through a risk assessment;\n• exploring key issues \n• outlining strategies to manage  the emerging performance risks through inspection, maintenance, and replacement activities\n","Yes."]
[null,"Capital expenditure policies and procedures (including capex approval policies and procedures and replacement policy) "]
[null,"<insert relevant policy, plan, strategy etc>"]
[null,"Internal standards for network planning, design, maintenance and operation"]
[null,"AMS 10-11 Asset Replacement and Refurbishment","This document outlines the objectives of asset replacement and refurbishment to achieve sustainable outcomes in:\n• Safety of customers, the community and workers\n• Quality, reliability and security of supply of electricity transmission services\n• Compliance with codes, licences, contracts, industry standards and obligations\n• Quality, reliability and security of supply performance risks\n• Minimising total asset life cycle costs through the consideration of capital costs, operation and maintenance costs and operational risk costs\n• Minimising the volatility of renewal works and associated material, skill and revenue requirements. \n• Minimising project delivery risks and the potential impact of renewal works on network availability, market participants and connected parties\n ","This document outlines the asset replacement and refurbishment strategies that underpin the management of assets in the Victorian electricity transmission network. In the context of this document the term 'renewal' is used to mean refurbishment or replacement.","No"]
[null,"AMS 10-13 Condition Monitoring","This document defines the scope of condition monitoring strategies for assets forming the Victorian electricity transmission network for the period until 2022.  Its purpose is to use condition monitoring to guide the establishment of economic asset maintenance, refurbishment and replacement programs while focussed on sustainable management of worker and public safety, network reliability, and security risks.  This strategy also focuses the development of condition monitoring techniques, processes and systems on the objective measurement of the condition of key network assets. ","This document describes the condition monitoring activities used to determine the the lifecycle phase of an asset. The methods described underpin inspection, maintenance and replacement activities. These include the deployment of Smart Aerial Image Processing technology, which has been successfully trialed in recent years, and for which an opex step change is being sought for a network-wide roll out.","Yes."]
[null,"AMS 10-14 Environmental Management","This documents sets out the environmental objective to protect the environment by responsibly managing the effects of our activities, while taking into account community concerns and threats to the functionality of the transmission network.","This document describes that on environmental matters, AusNet Services will:\n• Conduct all operations in accordance with legislation.\n• Responsibly minimise adverse environmental effects and maximise favourable effects where possible.\n• Inform and consult with the community on significant environmental matters and respond effectively to environmental concerns raised by the community.","No"]
[null,"AMS10-17 Network Performance Monitoring ","This document outlines how AusNet Services’ asset management practices is measured directly by the performance of extra high voltage network elements and their impact on the availability and reliability of the Victorian electricity transmission network in which they operate. ","This document summarises the assessment of electricity transmission network business performance providing the measure and strategies to be implemented to address regulatory and performance targets  ","No"]
[null,"AMS10-22 Risk Assessment","This document discusses the identification, analysis and quantification of risks that are associated with assets forming the Victorian electricity transmission network.\nThe main component of this document is the assessment of asset failure risks by individual asset or asset class using reliability centred maintenance (RCM) techniques including Availability Work Bench (AWB) software models such as RCMCost and AVSim. ","This document summarises the assessment of electricity transmission network business risks using the AusNet Services Risk Management Framework.  It also references the assessment of network safety risks undertaken using the AusNet Services Risk Management Framework as part of the establishment and maintenance of an accepted Electricity Safety Management Scheme (ESMS).","No"]
[null,"AMS 10-24 Asset Renewal Planning Guide","This document covers AusNet Services’ regulated electricity transmission assets operating across Victoria, including:\n• Transmission lines, power cables and associated easements and access tracks;\n• Terminal stations, switching stations, communication stations and depots including associated electrical plant, buildings and civil infrastructure;\n• Protection, control, metering and communications equipment;\n• Related functions and facilities such as spares, maintenance and test equipment; and Asset management processes and systems such as System Control and Data Acquisition (SCADA) and asset management information systems (including SAP).","This document provides a framework for AusNet Services’ asset renewal planning for the Victorian electricity transmission network. ","No"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Procurement and contracting out policies"]
[null,"<insert relevant policy, plan, strategy etc>"]
[null,"Information technology policies or strategies"]
[null,"<insert relevant policy, plan, strategy etc>"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Demand management policies or strategies"]
[null,"<insert relevant policy, plan, strategy etc>"]
[]
[]
[null,"Self insurance guidelines or policy"]
[null,"<insert relevant policy, plan, strategy etc>"]
[null,"Land and easement acquisition polices"]
[null,"<insert relevant policy, plan, strategy etc>"]
[]
[]
[null,"Asset security plans and policies"]
[null,"<insert relevant policy, plan, strategy etc>"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Disaster recovery policy"]
[null,"<insert relevant policy, plan, strategy etc>"]

{"sheet":"7.2 Contingent projects","index":22,"n_rows":31,"n_cols":6,"rows_kept":31,"cut":false,"hidden":false,"merged":[[3,1,3,5],[7,1,7,5],[8,1,8,5]]}
[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.2 CONTINGENT PROJECTS"]
[]
[]
[null,"TABLE 7.2.1 - PROPOSED CONTINGENT PROJECTS FOR THE FORTHCOMING REGULATORY CONTROL PERIOD"]
[null,"Instructions"]
[null,"The TNSP is required to populate all input cells (yellow) in table 7.2.1 presented below. Additional rows may be added by the TNSP if required.\n\n\n\n"]
[]
[null,"Proposed contingent project name","Proposed contingent capital expenditure  ($0's, nominal)","Proposed trigger events",{"$f":"CONCATENATE(\"Proposed MAR for \", FRCP_y1,\" ($0's, nominal)\")","v":"Proposed MAR for 2017-18 ($0's, nominal)"},{"$f":"CONCATENATE(\"5 per cent of the \", FRCP_y1,\" ($0's, nominal) MAR\")","v":"5 per cent of the 2017-18 ($0's, nominal) MAR"}]
[null,"Replace one or both of the Brooklyn and Templestowe synchronous condensers with reactive plant providing a similar, or reduced, level of service.  Note that the replacement assets may not be located at these sites.","$70m (direct cost plus overheads) ","Formal confirmation from AEMO that the magnitude of the expected benefits provided by the synchronous condensers justify the replacement of the Brooklyn and/or Templestowe Terminal Station synchronous condensers with reactive plant providing a similar, or reduced, level of service.",595.42946199999994,{"$f":"+E12*0.05","v":29.771473099999998}]
[null,null,null,"",{"$f":"+$E$12","v":595.42946199999994},{"$f":"+E13*0.05","v":29.771473099999998}]
[null,null,null,null,{"$f":"+$E$12","v":595.42946199999994},29.771473099999998]
[null,null,null,null,595.42946199999994,29.771473099999998]
[null,null,null,null,595.42946199999994,29.771473099999998]
[null,null,null,null,595.42946199999994,29.771473099999998]
[null,null,null,null,595.42946199999994,29.771473099999998]
[null,null,null,null,595.42946199999994,29.771473099999998]
[null,null,null,null,595.42946199999994,29.771473099999998]
[null,null,null,null,595.42946199999994,29.771473099999998]
[null,null,null,null,595.42946199999994,29.771473099999998]
[null,null,null,null,595.42946199999994,29.771473099999998]
[null,null,null,null,595.42946199999994,29.771473099999998]
[null,null,null,null,595.42946199999994,29.771473099999998]
[null,null,null,null,595.42946199999994,29.771473099999998]
[null,null,null,null,595.42946199999994,29.771473099999998]
[null,null,null,null,595.42946199999994,29.771473099999998]
[null,null,null,null,595.42946199999994,29.771473099999998]
[null,null,null,null,595.42946199999994,29.771473099999998]
[null,null,null,null,595.42946199999994,29.771473099999998]

{"sheet":"7.3 Obligations","index":23,"n_rows":295,"n_cols":5,"rows_kept":295,"cut":false,"hidden":false,"merged":[[3,1,3,4],[11,1,12,1]]}
[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.3  OBLIGATIONS, REQUIREMENTS & STANDARDS"]
[]
[]
[null,"Instructions"]
[null,"Outline those obligations and requirements that the TNSP identifies as having a material impact on expenditure requirements. "]
[]
[]
[null,"TABLE 7.3.1 - OBLIGATIONS OR REQUIREMENTS"]
[null,null,"Brief description","Relevance to regulatory proposal","Expenditure impact"]
[null,null,"Description of relevant obligations or requirements within the instrument (e.g. safety obligations, reliability targets) ","Identify what element of the proposal/supporting documents the obligation or requirement is relevant to e.g. replacement capex, capacity utilisation thresholds, opex ","Is the obligation or requirement identified in the response to section 4 'Step Changes' of the notice (yes or no)?"]
[null,"Legislation"]
[null,"National Electricity Law (NEL)","Impose obligations including registration, distribution losses, network connections, economic regulation and metering.","Submission document","No"]
[null,"Electricity Industry Act 2000","Sets out key obligations relating to distribution of electricity in Victoria including matters such as licences and compliance with industry codes, standards, rules and guidelines.","Chapter 4 Capex, Chapter 5 Opex","No"]
[null,"Electricity Safety Act 1998","Establishes safety framework for distribution of electricity in Victoria.","Chapter 4 Capex, Chapter 5 Opex, Chapter 12 Cost pass through","No"]
[null,"Electricity Safety (Bushfire Mitigation) Regulations 2013","Requires the preparation of bushfire mitigation plans and specifies inspection of assets.","Chapter 4 Capex, Chapter 5 Opex, Chapter 12 Cost pass through","No"]
[null,"Electricity Safety (Electric Line Clearance) Regulations 2010","Prescribes line clearance requirements including vegetation clearing","Chapter 4 Capex, Chapter 5 Opex","No"]
[null,"Electricity Safety (Management) Regulations 2009","Sets out requirements for Electricity Safety Management Schemes.","Chapter 4 Capex, Chapter 5 Opex","No"]
[null,"Electricity System Code","Requires particular power quality and connection characteristics.","Chapter 4 Capex, Chapter 5 Opex","No"]
[null,"Electricity Transmission Licence","Sets out obligations of AusNet Services in relation to transmission of electricity in Victoria including requirements to connect customers, offer services, undertake network augmentation and comply with orders, codes and guidelines.","Chapter 4 Capex, Chapter 5 Opex","No"]
[null,"Emergency Management Act 2013","Establishes arrangments for management of emergencies in Victoria ","Chapter 4 Capex, Chapter 5 Opex","Yes"]
[null,"Terrorism (Community Protection) Act 2003","Obliges providers of essential services including electricity to plan for the protection of services from the effects of terrorist acts.","Chapter 4 Capex, Chapter 5 Opex","No"]
[null,"Energy and Water Ombudsman Charter 2006","Describes how electricity licence holders must participate in a customer dispute resolution scheme and how this scheme operates in Victoria.","Chapter 4 Capex, Chapter 5 Opex","No"]
[null,"Occupational Health and Safety Act 2004","Sets out duties of employers and persons who manage or control workplaces to provide for the health, safety and welfare of employees and other persons including the public. Describes the principle of eliminating or reducing risks so far as is practicable.","Chapter 4 Capex, Chapter 5 Opex","No"]
[null,"Occupational Health and Safety Regulations 2007","Detail many aspects of OH&S including manual handling, exposure to noise, prevention of falls, work in confined spaces, operating plant, and asbestos control & handling. ","Chapter 4 Capex, Chapter 5 Opex","No"]
[null,"National Greenhouse and Energy Reporting Act 2007","Provides for reporting and dissemination of information related to greenhouse emissions including annual reporting.","Chapter 4 Capex, Chapter 5 Opex","No"]
[null,"National Greenhouse and Energy Reporting Regulations 2008","Sets out requirements for reporting greenhouse emissions.","Chapter 4 Capex, Chapter 5 Opex","No"]
[null,"Environment Protection Act 1970","Legislative framework for the protection of the environment in Victoria.","Chapter 4 Capex, Chapter 5 Opex","No"]
[null,"Environmental Protection (Residential Noise) Regulations 2008","Prescribes items and times during which noise resulting from their use is deemed to be unreasonable on residential properties.","Chapter 4 Capex, Chapter 5 Opex","No"]
[null,"Aboriginal Heritage Act 2006","Promotes the recognition, protection and conservation of Aboriginal culture in Victoria; recognition of Aboriginal people as the primary guardians of their cultural heritage; and management of Aboriginal cultural heritage as an integral part of land management.","Chapter 4 Capex, Chapter 5 Opex","No"]
[null,"Land Act 1958","Defines Crown Land and conditions relating to Crown Land which prohibit a number of activities including refuelling of vehicles, removal of vegetation and disposal of waste.","Chapter 4 Capex, Chapter 5 Opex","No"]
[null,"National Measurement Act 1960 and Regulations","The National Measurement Act establishes a national system of units and standards of measuremnet of physical quantities and provides for a national system of trade measurements. The National Trade Measurement Regulations were amended in remove the exemption for electricity meters.  Electricity meters installed prior to 1 January 2013 are exempt, whilst electricity meters installed after 1 January 2013 must comply with the National Measurement Act and Regulations.","Chapter 4 Capex, Chapter 5 Opex","No"]
[null,"Privacy Act 1988 (cth)","Obligations to protect the privacy of individuals and the responsible and transparent handling of personal information in accordance with the Australian Privacy Principles (APPs).","Submission document","No"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Licences"]
[]
[]
[]
[]
[null,"Rules"]
[]
[]
[]
[]
[null,"Orders"]
[]
[null,"Codes"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Guidelines"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Default agreements "]
[]
[null,"Other"]

{"sheet":"7.4 Shared Assets","index":24,"n_rows":28,"n_cols":20,"rows_kept":28,"cut":false,"hidden":false,"merged":[[38,2,38,8],[39,2,39,8],[40,2,40,8],[41,2,41,8],[42,2,42,8],[33,2,33,8],[34,2,34,8],[35,2,35,8],[36,2,36,8],[37,2,37,8],[28,2,28,8],[29,2,29,8],[30,2,30,8],[31,2,31,8],[32,2,32,8],[7,1,8,1],[7,2,8,2],[7,3,7,11],[7,12,7,19],[27,2,27,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,"7.4 SHARED ASSETS"]
[]
[null,"TABLE 7.4.1 - TOTAL UNREGULATED REVENUE EARNED WITH SHARED ASSETS "]
[]
[null,"Name of shared asset unregulated service","Description of shared assets used to provide the service","Shared asset unregulated revenue  ($0's, nominal)",null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Shared asset unregulated revenue  ($0's, real \", dms_DollarReal,\")\")","v":"Shared asset unregulated revenue  ($0's, real March 2017)"}]
[null,null,null,{"$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"},{"$f":"CONCATENATE(\"Total \n\", PRCP_y1, \"-\", CRCP_y5)","v":"Total \n2007-08-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 \n\",FRCP_y1, \"-\", FRCP_y5)","v":"Total \n2017-18-2021-22"}]
[null,"HV CT & VT Testing","Yarraville Laboratory, Mobile and fixed Test Equip",219464.32375780903,230427.47039387372,333547.60213941074,468049.73071913596,148503.0539239608,735984.02124970488,660086.53075039294,759006.79022576218,965541.99514588574,1033129.9348060978,{"$f":"SUM(D10:M10)","v":5553741.4531120341},1092684.5427567908,1142327.7584267375,1194226.38155018,1248482.8805654056,1305204.3792916306,{"$f":"SUM(O10:S10)","v":5982925.9425907442}]
[null,"Transformer Testing (incl Condition Monitoring)","Yarraville Laboratory, Mobile and fixed Test Equip ",536573.5,650349.76,714074.20000000007,1468296.15,1719075.7599999998,1210117.75,1213850.75,1037626.73,1320000,1412400,{"$f":"SUM(D11:M11)","v":11282364.6},1493817.5694999543,1561685.197230045,1632636.2100988256,1706810.6935082981,1784355.0972680794,{"$f":"SUM(O11:S11)","v":8179304.7676052023}]
[null,"Chemical Testing & Analysis","Yarraville Laboratory, laboratory Test Equip",529867.85,513485.5,636463.19999999984,1294737.0200000003,1613616.2900000003,1739416.1999999997,1906633.7000000002,2102734.0299999998,1759999.9999999998,1883199.9999999998,13980153.790000001,1991756.7593332722,2082246.9296400591,2176848.280131767,2275747.5913443975,2379140.1296907724,10905739.690140268]
[null,"Calibration & Electrical Testing (incl NATA accredited) ","Yarraville Laboratory, laboratory Test Equip ",178400.57624219099,187312.41960612629,271137.84786058922,380473.41928086407,120735.11607603916,602448.62875029503,539002.13924960722,620174.74977423786,788759.90363822365,843973.09689289948,4532417.8973710733,892623.78952414356,933177.77703061409,911751.61409928091,953174.62343549647,931289.32431411475,4622017.1284036497]
[null,"Fibre Optic Cable Leasing","~1000 km of fibre optic network at all stages in its lifecycle (0-20 years old). Total SPAN fibre optic network length ~2500 km",78020.56,79340.290000000008,98091.4,326954.60000000003,639474.57999999996,607687.63,1112326.98,1168154.6800000002,1594386.9579,1705994.044953,7410431.7228530003,1804335.7956762149,1886310.9930371761,1972010.5154370086,2061603.5676771852,2155267.041929251,9879527.9137568362]
[null,"Leasing Access to third parties – Wireless Base Stations on EHV Towers","175 x EHV towers",3573328.9,3602424.84,3944284,3895014.66,4955602.8900000006,4729969.26,4645563.3099999996,1870548.08,4969158.0611000005,5316999.1253770012,41502893.126476996,5623496.6797678098,5878985.2929668352,6146081.3517093435,6425312.2094079116,6717229.1783746621,30791104.712226562]
[null,"Leasing Access to third parties – Various communication equipment on communication towers","20 x communication towers",1632446.0299999998,1646048.97,1163911.78,1499266.04,1294997.4099999999,1495079.87,1667284.2700000003,1079411.28,1603011.8940000003,1715222.7265800005,14796680.270580001,1814096.4631625749,1896515.1104874988,1982678.2298208338,2072755.9412880235,2166926.0939698927,9932971.8387288228]
[null,"Property Leasing to third parties","Various network properties / sites",792723.30999999994,559177.99000000011,577568.54,653626.00000000012,704631,875460.7100000002,596416.19000000006,309456.95999999996,290977.12403756019,170040.4,5530078.2240375616,147820.72259144075,124032.1598099197,75855.630954413456,40486.80741522873,39622.877649958864,427818.1984209615]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D21:M21)","v":0},null,null,null,null,null,{"$f":"SUM(O21:S21)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D22:M22)","v":0},null,null,null,null,null,{"$f":"SUM(O22:S22)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D23:M23)","v":0},null,null,null,null,null,{"$f":"SUM(O23:S23)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D24:M24)","v":0},null,null,null,null,null,{"$f":"SUM(O24:S24)","v":0}]
[]
[null,"TABLE 7.4.2 - SHARED ASSET UNREGULATED SERVICES - APPORTIONMENT METHODOLOGY"]
[]
[null,"Name of shared asset unregulated service for which revenues were apportioned","Apportionment methodology"]

{"sheet":"7.5 EBSS","index":25,"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 DNSP 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) + (F3 – A3)\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 3 because it is the base year used to forecast opex."]
[null,null,"\n"]
[]
[null,null,"CPI "]
[]
[null,null,"ABS CPI index (old base)"]
[null,null,"ABS CPI index (rebased index)"]
[]
[]
[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 - Dec quarter (old base)",null,155.5,160.1,166,169.5,174,179.4]
[null,null,"Actual CPI - Dec quarter (rebased in Sep 2012)",null,null,null,null,null,null,99.8,102,104.8,106.6,{"$f":"+M20*(1+2.5%)","v":109.26499999999999},{"$f":"+N20*(1+2.5%)","v":111.99662499999998}]
[null,null,"Actual inflation rate (consistent with annual revenue adj)",null,null,{"$f":"F19/E19-1","v":2.9581993569131715E-2},3.6851967520299844E-2,2.108433734939763E-2,2.6548672566371723E-2,3.1034482758620641E-2,{"$f":"K20/J20-1","v":2.2044088176352838E-2},{"$f":"L20/K20-1","v":2.7450980392156765E-2},1.7175572519083859E-2,2.4999999999999911E-2,2.4999999999999911E-2]
[null,null,"Actual inflation rate (lagged by one year)",null,null,null,{"$f":"+F21","v":2.9581993569131715E-2},3.6851967520299844E-2,2.108433734939763E-2,2.6548672566371723E-2,3.1034482758620641E-2,2.2044088176352838E-2,2.7450980392156765E-2,1.7175572519083859E-2,{"$f":"+N21","v":2.4999999999999911E-2}]
[null,null,{"$f":"CONCATENATE(\"Reconstructed cumulative index (\",CRCP_y5,\"=1)\")","v":"Reconstructed cumulative index (2016-17=1)"},null,null,{"$f":"G23/(1+G22)","v":0.79169413177876857},0.81511402249376741,0.8451525779760487,0.86297206004180882,0.88588282269778607,0.91337573788495874,0.93351027318903612,0.95913604539422526,{"$f":"O23/(1+O22)","v":0.97560975609756106},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.65673570397595,171.30742991475381,168.57937240425505,176.80874469975316,185.13515541257806,189.80991219149408,188.00559467591285,null,{"$f":"+D33/$F$23","v":206.71712614096813},{"$f":"+E33/$F$23","v":216.38082567299369},212.93497783732843,223.32961380236767,{"$f":"+H33/$L$23","v":198.32149760936602},{"$f":"+I33/$L$23","v":203.32921623140777},201.3963853163099]
[null,null,"Approved excludable costs - allowance "]
[null,null,"Equity raising costs",1.5702424331306499,1.5009218563876801,1.4341057691114001,1.3748031502352001,null,null,null,null,{"$f":"-D1/$F$23","v":0},{"$f":"-E35/$F$23","v":-1.8958355204874733},-1.8114391802921022,-1.7365332077759745]
[null,null,"Opex glide path",5.0675210347880197,3.3783473565253401,1.6891736782626701,0,null,null,null,null,0,-4.2672380922350799,-2.1336190461175399,0]
["ED_EBS7511_00002",null,"Easement land tax",82.325647093427904,90.9726937311775,88.678146685685405,97.990704488873504,100.91902926829269,103.44200499999999,100.91902926829269,null,{"$f":"-D3/$F$23","v":0},-114.90888978396389,-112.01061511779106,-123.77343794213708,{"$f":"+-H37/$L$23","v":-108.10703659803919},{"$f":"+-I37/$L$23","v":-110.80971251299016},-108.10703659803919]
["ED_EBS7511_00003",null,"Self insurance",2.091917,2.091917,2.091917,2.091917,1.7,1.7,1.6,null,{"$f":"-D38/$F$23","v":-2.6423298039356524},-2.6423298039356524,-2.6423298039356524,-2.6423298039356524,{"$f":"+-H38/$L$23","v":-1.8210833333333327},-1.8210833333333327,-1.713960784313725]
["ED_EBS7511_00004",null,"Rebates made under the Availability Incentive Scheme ",2.78985138303887,2.78985138303887,2.78985138303887,2.78985138303887,2.2812929999999998,2.2812929999999998,2.2812929999999998,null,-3.5239005457456991,-3.5239005457456991,-3.5239005457456991,-3.5239005457456991,-2.4437792122058815,-2.4437792122058815,-2.4437792122058815]
["ED_EBS7511_00005",null,"Debt Raising costs",1.0997049234835801,1.10970416644198,1.1215816581501501,1.12306218142685,1.5496105450072941,1.5561098586057678,1.5775852076399237,null,-1.3890527658867151,-1.4016829503948836,-1.4166855773329965,-1.4185556471203946,-1.6599823156884503,-1.6669445460839134,-1.6899494873801588]
["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.7544155941638127,-2.7544155941638127,-2.7544155941638127,-2.7544155941638127,0,0,0]
["ED_EBS7511_00008",null,"Capitalisation policy changes",0,0,0,0,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",0,0,0,0,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.531197173727506},{"$f":"(E33-SUM(E35:E42)+SUM(E43:E44))","v":67.283339758803024},{"$f":"(F33-SUM(F35:F42)+SUM(F43:F44))","v":68.593941567627141},{"$f":"(G33-SUM(G35:G42)+SUM(G43:G44))","v":69.257751833799333},{"$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":196.40742743123624},84.986533382067179,86.641972971949571,87.480441061489046,84.289616150099164,86.587696626794482,87.441659234370945]
[]
[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 ",168.36878059489067,172.08413200375523,175.4720579682558,186.17627297981602,188.33817728966682,null,null,null,{"$f":"+D51/I$23*(1+I$22)^0.5","v":197.14948128868625},{"$f":"+E51/J$23*(1+J$22)^0.5","v":196.81324307310652},195.07207049896829,{"$f":"+G51/L$23*(1+L$22)^0.5","v":201.62298752913324},199.03924055545039]
[null,null,"Approved excludable costs"]
[null,null,"Equity raising costs",0,0,0,0,null,null,null,null,{"$f":"-D53/I$23*(1+I$22)^0.5","v":0},0,0,0]
[null,null,"Opex glide path",0,0,0,0,null,null,null,null,0,0,0,0]
["ED_EBS7512_0002",null,{"$f":"C37","v":"Easement land tax"},93.271160000000009,99.342244999999991,99.342244999999991,103.44200500000001,103.44200500000001,null,null,null,{"$f":"-D55/I$23*(1+I$22)^0.5","v":-109.21478880005667},-113.61808427627969,-110.43865128470522,-112.02440434697411,-109.3194083803142]
["ED_EBS7512_0003",null,"Self insurance",2.2802567942122187,2.3407945852090033,2.4134399344051447,2.4639207159353349,1.7416499999999999,null,null,null,{"$f":"-D56/I$23*(1+I$22)^0.5","v":-2.6700403875086547},-2.6771752184152442,-2.6830181994815159,-2.6683478395534377,-1.8406076680897108]
["ED_EBS7512_0004",null,"Rebates made under the Availability Incentive Scheme ",2.6097339300000004,2.1723960299999998,2.0113954500000002,3.10947598,2.4027953599999998,null,null,null,-3.0558378387198344,{"$f":"-E57/J$23*(1+J$22)^0.5","v":-2.4845771828288701},-2.2360658418600541,-3.367463676779308,-2.5393182123080855]
["ED_EBS7512_0005",null,"Debt Raising costs",0,0,0,0,0,null,null,null,0,0,0,0,0]
["ED_EBS7512_0006",null,"Priority projects approved under STPIS network capability component",null,null,null,null,0.25119547000000003,null,null,null,0,0,0,0,-0.26546798051927711]
["ED_EBS7512_0008",null,"Movements in provisions related to opex",0.33599599999999985,0.61985899999999972,1.2615299999999996,1.3741403276641613,-0.13078950975576323,null,null,null,-0.39343064005705325,-0.70893497626725088,-1.4024413456248559,-1.4881503089168997,0.13822075305724563]
["ED_EBS7512_0008",null,"Opex associated with approved cost pass through",0,0,0,0,0,null,null,null,0,0,0,0,0]
["ED_EBS7512_0009",null,{"$f":"C43","v":"Capitalisation policy changes"},0,0,0,0,0,null,null,null,{"$f":"D62/I$23*(1+I$22)^0.5","v":0},{"$f":"E62/J$23*(1+J$22)^0.5","v":0},0,0,0]
["ED_EBS7512_0011",null,"Other adjustments or exclusions required by the EBSS",0,0,0,0,0,null,null,null,{"$f":"D63/I$23*(1+I$22)^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.871633870678437},{"$f":"(E51-SUM(E53:E61)+SUM(E62:E63))","v":67.608837388546235},{"$f":"(F51-SUM(F53:F61)+SUM(F62:F63))","v":70.44344758385067},{"$f":"(G51-SUM(G53:G61)+SUM(G62:G63))","v":75.786730956216516},{"$f":"(H51-SUM(H55:H61)+SUM(H62:H63))","v":80.631320969422561},{"$f":"(I51-SUM(I55:I61)+SUM(I62:I63))","v":0},{"$f":"(J51-SUM(J55:J61)+SUM(J62:J63))","v":0},null,{"$f":"L51+SUM(L53:L63)","v":81.815383622344044},{"$f":"M51+SUM(M53:M63)","v":77.324471419315472},78.311893827296657,82.074621356909489,{"$f":"P51+SUM(P55:P63)","v":85.212659067276348},{"$f":"+Q45-(P45-P64)","v":87.510739543971667},{"$f":"+R45-(P45-P64)","v":88.36470215154813}]
[]
[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)+(L45-L64)","v":108.26318118713546},{"$f":"(Q45-Q64)-(P45-P64)","v":0},{"$f":"(R45-R64)-(Q45-Q64)","v":0}]
[]
[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":108.26318118713546},{"$f":"$P$67","v":108.26318118713546},{"$f":"$P$67","v":108.26318118713546},{"$f":"$P$67","v":108.26318118713546},{"$f":"$P$67","v":108.26318118713546}]
["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":0},{"$f":"$Q$67","v":0},{"$f":"$Q$67","v":0},{"$f":"$Q$67","v":0},{"$f":"$Q$67","v":0}]
["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":0},{"$f":"+$R$67","v":0},{"$f":"+$R$67","v":0},{"$f":"+$R$67","v":0},{"$f":"+$R$67","v":0}]
[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":108.26318118713546},{"$f":"+SUM(T73:T75)","v":108.26318118713546},{"$f":"+SUM(U73:U75)","v":108.26318118713546},{"$f":"+SUM(V73:V75)","v":0},{"$f":"+SUM(W73:W75)","v":0},{"$f":"SUM(S76:W76)","v":324.78954356140639}]
[]
[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":108.26318118713546},{"$f":"T76","v":108.26318118713546},{"$f":"U76","v":108.26318118713546},{"$f":"V76","v":0},{"$f":"W76","v":0},{"$f":"SUM(S78:W78)","v":324.78954356140639}]
[]
[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",222.11584112912101,217.30394007053565,218.790952486187,221.10842598200452,222.38373306134562,{"$f":"+SUM(D85:H85)","v":1101.7028927291938}]
[null,null,"Less excluded costs"]
["ED_EBS752_00002",null,"Easement land tax",115.27003841066509,115.27003841066509,115.27003841066509,115.27003841066509,115.27003841066509,{"$f":"+SUM(D87:H87)","v":576.35019205332549}]
["ED_EBS752_00003",null,"Self insurance",2.7172576264139621,2.7186082387130166,2.7014798374731521,2.6947678097485968,2.6842375817454438,13.516351094094171]
["ED_EBS752_00004",null,"Priority projects approved under STPIS network capability component",0,0,0,0,0,0]
["ED_EBS752_00005",null,null,0,0,0,0,0,0]
["ED_EBS752_00006",null,null,0,0,0,0,0,0]
["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":104.12854509204195},99.315293421157534,100.81943423804874,103.14361976159083,104.42945706893508,511.83634958177413]

{"sheet":"7.6 Indicative bill impact ","index":26,"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",1541]
[]
[]
[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",6760]
[null,"Large I & C","Large I & C",33484]
[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.1193,2.24E-2,2.1299999999999999E-2,2.3099999999999999E-2,2.8899999999999999E-2,{"$f":"+AVERAGE(D33:H33)","v":4.2999999999999997E-2}]
[null,"Annual price path (per cent, $2013-14)",null,9.3600000000000003E-2,-1E-3,-2.0999999999999999E-3,-4.0000000000000002E-4,5.3E-3,{"$f":"+AVERAGE(D34:H34)","v":1.908E-2}]
[]
[]
[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":77.050000000000011},{"$f":"+C40*(1+IF($C$37=\"Nominal\",D$33,D$34))","v":84.261880000000005},{"$f":"+D40*(1+IF($C$37=\"Nominal\",E$33,E$34))","v":84.177618120000005},{"$f":"+E40*(1+IF($C$37=\"Nominal\",F$33,F$34))","v":84.000845121948004},{"$f":"+F40*(1+IF($C$37=\"Nominal\",G$33,G$34))","v":83.967244783899233},{"$f":"+G40*(1+IF($C$37=\"Nominal\",H$33,H$34))","v":84.412271181253899},{"$f":"+SUM(D40:H40)","v":420.81985920710116},{"$f":"+AVERAGE(D40:H40)","v":84.163971841420235}]
[null,"Annual change",null,{"$f":"+D40-C40","v":7.2118799999999936},{"$f":"+E40-D40","v":-8.4261879999999678E-2},{"$f":"+F40-E40","v":-0.17677299805200164},{"$f":"+G40-F40","v":-3.360033804877105E-2},{"$f":"+H40-G40","v":0.44502639735466687},{"$f":"+SUM(D41:H41)","v":7.3622711812538881},{"$f":"+AVERAGE(D41:H41)","v":1.4724542362507775},{"$f":"+J41/D16","v":9.5551864779414508E-4}]
[]
[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":270.39999999999998},{"$f":"+C59*(1+IF($C$56=\"Nominal\",D$33,D$34))","v":295.70943999999997},{"$f":"+D59*(1+IF(D56=\"Nominal\",E$33,E$34))","v":295.41373055999998},{"$f":"+E59*(1+IF(E56=\"Nominal\",F$33,F$34))","v":294.79336172582396},{"$f":"+F59*(1+IF(F56=\"Nominal\",G$33,G$34))","v":294.67544438113362},{"$f":"+G59*(1+IF(G56=\"Nominal\",H$33,H$34))","v":296.23722423635365},{"$f":"+SUM(D59:H59)","v":1476.8292009033112},{"$f":"+AVERAGE(D59:H59)","v":295.36584018066225}]
[null,"Annual change",null,{"$f":"+D59-C59","v":25.309439999999995},{"$f":"+E59-D59","v":-0.29570943999999599},{"$f":"+F59-E59","v":-0.62036883417601985},{"$f":"+G59-F59","v":-0.11791734469034054},{"$f":"+H59-G59","v":1.5617798552200384},{"$f":"+SUM(D60:H60)","v":25.837224236353677},{"$f":"+AVERAGE(D60:H60)","v":5.1674448472707351},{"$f":"+J60/D25","v":7.6441491823531584E-4}]
[]
[null,{"$f":"+B26","v":"Large I & C"},{"$f":"+D26*$C$11","v":1339.3600000000001},{"$f":"+C62*(1+IF(C59=\"Nominal\",D$33,D$34))","v":1464.7240959999999},{"$f":"+D62*(1+IF(D59=\"Nominal\",E$33,E$34))","v":1463.2593719039999},{"$f":"+E62*(1+IF(E59=\"Nominal\",F$33,F$34))","v":1460.1865272230016},{"$f":"+F62*(1+IF(F59=\"Nominal\",G$33,G$34))","v":1459.6024526121125},{"$f":"+G62*(1+IF(G59=\"Nominal\",H$33,H$34))","v":1467.3383456109568},7315.1107933500707,1463.0221586700141]
[null,"Annual change",null,{"$f":"+D62-C62","v":125.36409599999979},{"$f":"+E62-D62","v":-1.4647240960000545},{"$f":"+F62-E62","v":-3.072844680998287},{"$f":"+G62-F62","v":-0.58407461088904711},{"$f":"+H62-G62","v":7.7358929988442924},127.97834561095669,25.595669122191339,{"$f":"+J63/D26","v":7.6441491823531649E-4}]
[]
[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":27,"n_rows":166,"n_cols":15,"rows_kept":166,"cut":false,"hidden":false,"merged":[[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],[7,1,7,5],[71,1,71,4],[10,1,11,1],[10,2,10,6],[32,13,33,13],[54,1,54,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},2945.3397845648824,{"$f":"+M35/N35","v":3.6355058442202358E-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":2945.3397845648824},{"$f":"+M36/N36","v":6.1582028990517793E-6}]
[null,3,null,null,null,null,null,null,null,null,null,null,{"$f":"+SUM(K37:L37)","v":0},{"$f":"+$N$35","v":2945.3397845648824},0]
[null,4,null,null,null,null,null,null,null,null,null,null,0,2945.3397845648824,0]
[null,5,null,null,null,null,null,null,null,null,null,null,0,2945.3397845648824,0]
[null,6,null,null,null,null,null,null,null,null,null,null,0,2945.3397845648824,0]
[null,7,null,null,null,null,null,null,null,null,null,null,0,2945.3397845648824,0]
[null,8,null,null,null,null,null,null,null,null,null,null,0,2945.3397845648824,0]
[null,9,null,null,null,null,null,null,null,null,null,null,0,2945.3397845648824,0]
[null,10,null,null,null,null,null,null,null,null,null,null,0,2945.3397845648824,0]
[null,11,null,null,null,null,null,null,null,null,null,null,0,2945.3397845648824,0]
[null,12,null,null,null,null,null,null,null,null,null,null,0,2945.3397845648824,0]
[null,13,null,null,null,null,null,null,null,null,null,null,0,2945.3397845648824,0]
[null,14,null,null,null,null,null,null,null,null,null,null,0,2945.3397845648824,0]
[null,15,null,null,null,null,null,null,null,null,null,null,0,2945.3397845648824,0]
[null,16,null,null,null,null,null,null,null,null,null,null,0,2945.3397845648824,0]
[null,"<NSP to insert additional lines if required>",null,null,null,null,null,null,null,null,null,null,0,2945.3397845648824,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",135,135,{"$f":"+E89/12","v":11.25}]
[null,"2009","February",358,82,{"$f":"+E90/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(D89:D100)","v":1755},{"$f":"+SUM(E89:E100)","v":1417},{"$f":"+SUM(F89:F100)","v":118.08333333333331}]
[null,{"$f":"LEFT(PRCP_y4,4)","v":"2010"},"January",375,314,{"$f":"+E102/12","v":26.166666666666668}]
[null,"2010","February",264,264,{"$f":"+E103/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(D102:D113)","v":2274},{"$f":"+SUM(E102:E113)","v":2134},{"$f":"+SUM(F102:F113)","v":177.83333333333331}]
[null,{"$f":"LEFT(PRCP_y5,4)","v":"2011"},"January",27,24,{"$f":"+E115/12","v":2}]
[null,"2011","February",524,488,{"$f":"+E116/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(D115:D126)","v":3783},{"$f":"+SUM(E115:E126)","v":2687},{"$f":"+SUM(F115:F126)","v":223.91666666666666}]
[null,{"$f":"LEFT(CRCP_y1,4)","v":"2012"},"January",326,326,{"$f":"+E128/12","v":27.166666666666668}]
[null,"2012","February",130,130,{"$f":"+E129/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(D128:D139)","v":2575},{"$f":"+SUM(E128:E139)","v":909},{"$f":"+SUM(F128:F139)","v":75.749999999999986}]
[null,{"$f":"LEFT(CRCP_y2,4)","v":"2013"},"January",70,56,{"$f":"+E141/12","v":4.666666666666667}]
[null,"2013","February",98,51,{"$f":"+E142/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,0.16666666666666666]
[null,{"$f":"CONCATENATE(\"Total \", LEFT(CRCP_y2,4))","v":"Total 2013"},null,{"$f":"+SUM(D141:D152)","v":2190},{"$f":"+SUM(E141:E152)","v":745},{"$f":"+SUM(F141:F152)","v":62.083333333333336}]
[null,{"$f":"LEFT(CRCP_y3,4)","v":"2014"},"January",86,78,{"$f":"+E154/12","v":6.5}]
[null,"2014","February",0,0,{"$f":"+E155/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(D154:D165)","v":1018.5},{"$f":"+SUM(E154:E165)","v":851.5},{"$f":"+SUM(F154:F165)","v":70.958333333333329}]

{"sheet":"2.10.2, 2.17.1 & 7.7.1","index":28,"n_rows":56,"n_cols":13,"rows_kept":56,"cut":false,"hidden":false,"merged":[[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],[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]]}
[]
[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",5392801.0858275779,5486155.6310558012,5755552.6863918798,5862103.1178580578,5969794.3277929453,6081977.5109159024,6196412.0601318534]
[null,null,null,"INSURANCE",4872827.5441775303,5156067.2019188488,5536558.2106536217,5681818.7870743601,5791864.2594288131,5904636.3837932609,6020221.5596016767]
[null,null,null,"SELF-INSURANCE",1845019.4264974522,1845019.4264974522,2717257.6264139619,2718608.2387130167,2701479.8374731522,2694767.809748597,2684237.5817454439]
[null,null,null,"OH&S",1064677.8004205155,1120818.9165597041,1162249.8595275283,1178005.0742661611,1193670.6428937139,1188932.4250060231,1186649.8791676653]
[null,null,null,"FINANCE",10818333.522454303,11113763.795978932,11564543.36998542,11776070.922651272,11989585.389125044,12157387.414495748,12335748.834765187]
[null,null,null,"HR",4451723.9974716101,4677874.6058302149,4894109.9734857874,4977349.4028501939,5060545.1281461492,5071003.9896215042,5090904.0745923826]
[null,null,null,"IT SUPPORT",1157660.319728076,1711275.0811304757,1747094.5494761891,1753084.5412885714,1755792.6921651862,1485872.6364811962,1243574.0848142186]
[null,null,null,"OTHER ",6013497.3940999955,7247820.6252865903,7403894.0440544114,7488325.2508110814,7567032.2024992723,7072062.0966592487,6637708.7484258749]
[null,null,null,"AVAILABILITY REBATE",0,0,0,0,0,0,0]
[null,null,null,"EASEMENT TAX",115270038.41066509,115270038.41066509,115270038.41066509,115270038.41066509,115270038.41066509,115270038.41066509,115270038.41066509]
[]
[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,"New emergency response arrangements","As per 2017-22 Revenue Proposal",0,0,0,201292.70271727725,201292.70271727725,201292.70271727725,201292.70271727725,201292.70271727725,201292.70271727725,201292.70271727725]
[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,4343340.8828636957,0,0,0,0]
[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,2916018.2056197594,3276980.0549054299,8150857.0170270829,1506732.2584545901,1195537.818158451,1628358.5472521852,982233.82248067786]
[]
[]
[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",0.16807,0.2437,0.32500000000000001,0.20660999999999999,0.30578512396694213,{"$f":"+AVERAGE(C43:G43)","v":0.24983302479338843},0.35713,0.24983302479338843,0.15919,2E-3]
[null,"Transformer outage – fault ",7.2580645161290328E-2,0.11904761904761904,0.2125984251968504,0.3125,0.2283464566929134,{"$f":"+AVERAGE(C44:G44)","v":0.18901462921973464},0.35844999999999999,0.18901462921973464,4.6899999999999997E-2,2E-3]
[null,"Reactive plant – fault ",0.27143,0.34286,0.45713999999999999,0.47143000000000002,0.25714285714285712,0.36000057142857139,0.55698000000000003,0.36000057142857139,0.21726999999999999,1E-3]
[null,"Transmission line outage – forced outage",0.14285999999999999,0.16807,0.14166999999999999,0.12397,0.15702479338842976,0.14671895867768597,0.17294999999999999,0.14671895867768597,0.12317,1E-3]
[null,"Transformer outage – forced outage",0.13709677419354838,4.7619047619047616E-2,0.13385826771653545,0.109375,0.11811023622047244,0.10921186514992079,0.15368000000000001,0.10921186514992079,6.198E-2,1E-3]
[null,"Reactive plant – forced outage",0.14285999999999999,0.22857,0.22857,0.35714000000000001,0.38571428571428573,0.26857085714285717,0.44140000000000001,0.26857085714285717,0.1336,5.0000000000000001E-4]
[null,"Loss of supply event frequency (minutes):"]
[null,">  (x) system minutes",1,0,2,5,3,2.2000000000000002,5,3,0,1.5E-3]
[null,">  (y) system minutes",0,0,1,1,0,0.4,2,1,0,1.5E-3]
[null,"Average outage duration (minutes): ",92.5,4,230,19.899999999999999,24,74.08,253.82,74.08,1.72]
[null,"Proper operation of equipment (number of events):"]
[null,"Failure of protection system",14,23,33,41,33,28.8,38,28.8,20,0]
[null,"Material failure of SCADA",0,0,1,6,2,1.8,6,1.8,0,0]
[null,"Incorrect operational isolation of primary or secondary equipment",7,5,8,4,6,6,10,6,2,0]