{"text_format":"1","workbook":"xlsx","n_sheets":29,"sheets":["Instructions","CONTENTS","Business & other details","2.1 Expenditure summary","2.2 Repex","2.3 Augex (b)","2.5 Connections","2.14 Forecast price changes","2.6 Non-network","2.16 Opex Summary","2.10 Overheads","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 Large Projects","7.9 STPIS","8.2 Capex","AER CF","AER NRs","AER lookups","AER ETL"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":8,"defined_names":523,"comments":4,"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":"Instructions","index":0,"n_rows":19,"n_cols":3,"rows_kept":19,"cut":false,"hidden":false,"merged":[[18,2,18,4],[10,2,10,4],[12,1,14,1],[12,2,12,4],[14,2,14,4],[16,2,16,4],[13,2,13,4],[8,2,8,4],[1,1,1,4],[2,1,2,4],[3,1,3,4],[4,1,4,4],[5,2,5,4]]}
[]
[null,{"$f":"CONCATENATE(dms_Sector,\" \",dms_Segment,\" \", \"Network Service Provider\")","v":"Electricity Transmission Network Service Provider"}]
[null,{"$f":"IF(dms_Model=\"Reset\",\"Regulatory Proposal RIN Template\",\"Annual Reporting RIN\")","v":"Regulatory Proposal RIN Template"}]
[null,{"$f":"CONCATENATE(\"This template is to be used by \",dms_TradingNameFull,\" to fulfil its reporting obligations to the AER.\")","v":"This template is to be used by AusNet Transmission Group Pty Limited to fulfil its reporting obligations to the AER."}]
[null,"INSTRUCTIONS"]
[null,"GENERAL","Complete the Business & other details worksheet before entering data or values in any other worksheets. The Business & other details worksheet is linked to other worksheets within the workbook and automatically generates certain column headings and conditional formatting."]
[]
[]
[null,"CONFIDENTIAL INFORMATION","Please identify all confidential data by shading the input cell as per the colour code on each worksheet."]
[]
[null,"RESPONSES","\nPlease return two (2) files to the AER: \n\n1. A confidential version which must contain a complete set of all responses with confidential information marked using the Mark selection 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 and other details worksheet to identify the file as either confidential ('consolidated') or public. "]
[]
[null,"AMENDMENTS","\nIf an NSP wishes to correct data previously submitted to the AER it should resubmit that data using the original completed submission as the starting point. Please make any necessary changes to the data. Data that is not being amended should be left unchanged. \n\nNSPs must identify the reason for the amendments in the Amendment Reason box on the  Business and other details worksheet. NSPs may provide further details regarding any amendments in the Amendments worksheet. \n\n."]
[null,null,"Please identify all amended data by shading the input cell as per the colour code on each worksheet."]
[null,null,"Please resubmit two (2) files - a confidential version and a public version of the amended submission to the AER"]
[]
[null,"UNITS OF MEASURE","\nAll amounts are to be unrounded and reported on a one for one basis: that is 1000 is to be entered as '1000'. Applicable units of measure may be identified in the table column headings or row descriptors.\n\n"]
[]
[null,"NAVIGATION","\nMany tables in the worksheets have been \"grouped\" to allow for easy navigation. To ungroup or group data use the outline symbols in the left margin (for Row groupings) or above the columns (for column groupings). \n\n\n\n"]

{"sheet":"CONTENTS","index":1,"n_rows":36,"n_cols":4,"rows_kept":36,"cut":false,"hidden":false,"merged":[[5,2,5,3]]}
[null,null,{"$f":"INDEX(dms_Worksheet_List,MATCH(dms_Model,dms_Model_List))","v":"REGULATORY REPORTING STATEMENT"}]
[null,null,{"$f":"INDEX(dms_TradingNameFull_List,MATCH(dms_TradingName,dms_TradingName_List))","v":"AusNet Transmission Group Pty Limited"}]
[null,null,{"$f":"CONCATENATE(\"REGULATORY PERIOD FROM \", FRCP_y1,\" TO \",dms_MultiYear_FinalYear_Result)","v":"REGULATORY PERIOD FROM 2027-28 TO 2031-32"}]
[]
[]
[null,null,"CONTENTS"]
[]
[null,null,"TEMPLATE","FINAL RIN JULY 2025"]
[]
[null,null,"SUBMISSION","Business & other details"]
[]
[null,null,"EXPENDITURE","2.1 Expenditure summary"]
[null,null,null,"2.2 Repex"]
[null,null,null,"2.3 Augex (b)"]
[null,null,null,"2.5 Connections"]
[null,null,null,"2.6 Non-network"]
[null,null,null,"2.10 Overheads"]
[null,null,null,"2.14 Forecast price changes"]
[null,null,null,"2.16 Opex Summary"]
[null,null,null,"2.17 Step Changes"]
[]
[null,null,"ECONOMIC BENCHMARKING","3.1 Revenue"]
[null,null,null,"3.2 Operating expenditure"]
[null,null,null,"3.3 Assets (RAB)"]
[null,null,null,"3.4 Operational data"]
[null,null,null,"3.5 Physical assets"]
[null,null,null,"3.7 Operating environment"]
[]
[null,null,"OTHER","7.1  Policies and Procedures"]
[null,null,null,"7.2 Contingent projects"]
[null,null,null,"7.3 Obligations"]
[null,null,null,"7.4 Shared Assets"]
[null,null,null,"7.5 Large Projects"]
[null,null,null,"7.9 STPIS"]
[]
[null,null,"CAPEX","8.2 Capex"]

{"sheet":"Business & other details","index":2,"n_rows":74,"n_cols":79,"rows_kept":74,"cut":false,"hidden":false,"merged":[[0,7,2,15],[3,21,3,57],[6,21,6,75],[8,16,8,93],[15,21,15,35],[15,37,15,58],[16,21,16,35],[16,37,16,48],[22,21,22,35],[22,37,22,58],[22,60,22,66],[22,68,22,89],[23,21,23,35],[23,37,23,58],[23,60,23,66],[23,68,23,89],[24,21,24,35],[24,37,24,51],[24,60,24,66],[24,68,24,82],[25,21,25,35],[25,37,25,40],[25,49,25,51],[25,60,25,66],[25,68,25,71],[25,80,25,82],[31,21,31,35],[31,37,31,58],[31,60,31,66],[31,68,31,89],[32,21,32,35],[32,37,32,58],[32,60,32,66],[32,68,32,89],[33,21,33,35],[33,37,33,58],[33,60,33,66],[33,68,33,89],[41,25,41,34],[41,37,41,44],[41,46,41,53],[41,55,41,62],[41,64,41,71],[41,73,41,80],[42,37,42,44],[42,46,42,53],[42,55,42,62],[42,64,42,71],[42,73,42,80],[43,37,43,44],[43,46,43,53],[43,55,43,62],[43,64,43,71],[43,73,43,80],[45,25,45,34],[45,37,45,44],[45,46,45,53],[45,55,45,62],[45,64,45,71],[45,73,45,80],[46,37,46,44],[46,46,46,53],[46,55,46,62],[46,64,46,71],[46,73,46,80],[47,37,47,44],[47,46,47,53],[47,55,47,62],[47,64,47,71],[47,73,47,80],[49,25,49,34],[49,37,49,44],[49,46,49,53],[49,55,49,62],[49,64,49,71],[49,73,49,80],[50,37,50,44],[50,46,50,53],[50,55,50,62],[50,64,50,71],[50,73,50,80],[51,37,51,44],[51,46,51,53],[51,55,51,62],[51,64,51,71],[51,73,51,80],[53,25,53,34],[53,37,53,44],[55,25,55,34],[55,37,55,44],[61,25,61,34],[61,37,61,52],[69,25,71,34],[69,37,71,81],[73,25,73,34],[73,37,73,52],[63,25,63,34],[63,37,63,52],[65,25,65,34],[65,37,65,52],[67,25,67,34],[67,37,67,52]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDEX(dms_Worksheet_List,MATCH(dms_Model,dms_Model_List))","v":"REGULATORY REPORTING STATEMENT"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDEX(dms_TradingNameFull_List,MATCH(dms_TradingName,dms_TradingName_List))","v":"AusNet Transmission Group Pty Limited"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"REGULATORY PERIOD FROM \", FRCP_y1,\" TO \",dms_MultiYear_FinalYear_Result)","v":"REGULATORY PERIOD FROM 2027-28 TO 2031-32"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BUSINESS & OTHER DETAILS"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"INSTRUCTIONS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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 and conditional formatting to distinguish business specific input and non-input cells. "]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SUBMISSION PARTICULARS INPUT SHEET"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ENTITY DETAILS"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Business Name"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Short name",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AusNet (T)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ACN/ABN",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDEX(dms_ABN_List,MATCH(dms_TradingName,dms_TradingName_List))","v":78079798173}]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Business Address",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Postal Address"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Address 1",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Address 1"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Address 2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Address 2"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Suburb",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Suburb"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"State",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VIC",null,null,null,null,null,null,null,null,null,"Post code",null,null,null,null,null,null,null,null,null,null,null,null,"State",null,null,null,null,null,null,null,"VIC",null,null,null,null,null,null,null,null,null,"Post code"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"`"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Contact Names"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Name",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Name"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Phone",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Phone"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Email",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Email"]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"REGULATORY CONTROL PERIODS"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Forthcoming period",null,null,null,null,null,null,null,null,null,null,null,"2027-28",null,null,null,null,null,null,null,null,{"$f":"FRCP_y2","v":"2028-29"},null,null,null,null,null,null,null,null,{"$f":"FRCP_y3","v":"2029-30"},null,null,null,null,null,null,null,null,{"$f":"FRCP_y4","v":"2030-31"},null,null,null,null,null,null,null,null,{"$f":"FRCP_y5","v":"2031-32"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"FRCP_y6","v":"2032-33"},null,null,null,null,null,null,null,null,{"$f":"FRCP_y7","v":"2033-34"},null,null,null,null,null,null,null,null,{"$f":"FRCP_y8","v":"2034-35"},null,null,null,null,null,null,null,null,{"$f":"FRCP_y9","v":"2035-36"},null,null,null,null,null,null,null,null,{"$f":"FRCP_y10","v":"2036-37"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"FRCP_y11","v":"2037-38"},null,null,null,null,null,null,null,null,{"$f":"FRCP_y12","v":"2038-39"},null,null,null,null,null,null,null,null,{"$f":"FRCP_y13","v":"2039-40"},null,null,null,null,null,null,null,null,{"$f":"FRCP_y14","v":"2040-41"},null,null,null,null,null,null,null,null,{"$f":"FRCP_y15","v":"2041-42"}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RESETS",null,"Current period",null,null,null,null,null,null,null,null,null,null,null,{"$f":"CRCP_y1","v":"2022-23"},null,null,null,null,null,null,null,null,{"$f":"CRCP_y2","v":"2023-24"},null,null,null,null,null,null,null,null,{"$f":"CRCP_y3","v":"2024-25"},null,null,null,null,null,null,null,null,{"$f":"CRCP_y4","v":"2025-26"},null,null,null,null,null,null,null,null,{"$f":"CRCP_y5","v":"2026-27"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CRCP_y6","v":"2027-28"},null,null,null,null,null,null,null,null,{"$f":"CRCP_y7","v":"2028-29"},null,null,null,null,null,null,null,null,{"$f":"CRCP_y8","v":"2029-30"},null,null,null,null,null,null,null,null,{"$f":"CRCP_y9","v":"2030-31"},null,null,null,null,null,null,null,null,{"$f":"CRCP_y10","v":"2031-32"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CRCP_y11","v":"2032-33"},null,null,null,null,null,null,null,null,{"$f":"CRCP_y12","v":"2033-34"},null,null,null,null,null,null,null,null,{"$f":"CRCP_y13","v":"2034-35"},null,null,null,null,null,null,null,null,{"$f":"CRCP_y14","v":"2035-36"},null,null,null,null,null,null,null,null,{"$f":"CRCP_y15","v":"2036-37"}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Previous period",null,null,null,null,null,null,null,null,null,null,null,{"$f":"PRCP_y1","v":"2017-18"},null,null,null,null,null,null,null,null,{"$f":"PRCP_y2","v":"2018-19"},null,null,null,null,null,null,null,null,{"$f":"PRCP_y3","v":"2019-20"},null,null,null,null,null,null,null,null,{"$f":"PRCP_y4","v":"2020-21"},null,null,null,null,null,null,null,null,{"$f":"PRCP_y5","v":"2021-22"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"PRCP_y6","v":"2022-23"},null,null,null,null,null,null,null,null,{"$f":"PRCP_y7","v":"2023-24"},null,null,null,null,null,null,null,null,{"$f":"PRCP_y8","v":"2024-25"},null,null,null,null,null,null,null,null,{"$f":"PRCP_y9","v":"2025-26"},null,null,null,null,null,null,null,null,{"$f":"PRCP_y10","v":"2026-27"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"PRCP_y11","v":"2027-28"},null,null,null,null,null,null,null,null,{"$f":"PRCP_y12","v":"2028-29"},null,null,null,null,null,null,null,null,{"$f":"PRCP_y13","v":"2029-30"},null,null,null,null,null,null,null,null,{"$f":"PRCP_y14","v":"2030-31"},null,null,null,null,null,null,null,null,{"$f":"PRCP_y15","v":"2031-32"}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Commencing year",null,null,null,null,null,null,null,null,null,null,null,"2022-23"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ANNUAL RINS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Final year",null,null,null,null,null,null,null,null,null,null,null,"2022-23"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SUBMISSION DETAILS"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RIN type",null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDIRECT(dms_Model)","v":"Regulatory Reporting (Reset)"}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Source",null,null,null,null,null,null,null,null,null,null,null,"Regulatory proposal"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"THIS FILE",null,"Data Quality",null,null,null,null,null,null,null,null,null,null,null,"Consolidated"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Confidentiality Status",null,null,null,null,null,null,null,null,null,null,null,"Public"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Amended RIN \nAmendment Reason",null,null,null,null,null,null,null,null,null,null,null,"."]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Submission Date",null,null,null,null,null,null,null,null,null,null,null,"dd/mm/yy",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Please enter date this file submitted to AER"]

{"sheet":"2.1 Expenditure summary","index":3,"n_rows":44,"n_cols":9,"rows_kept":44,"cut":false,"hidden":false,"merged":[]}
[null,{"$f":"(LOOKUP(dms_Model,dms_Model_List,dms_Worksheet_List))","v":"REGULATORY REPORTING STATEMENT"},null,null,null,"#25C6FF",null,"Protected (SOCI)"]
[null,{"$f":"INDEX(dms_TradingNameFull_List,MATCH(dms_TradingName,dms_TradingName_List))","v":"AusNet Transmission Group Pty Limited"},null,null,null,"#FFCCCC",null,"Confidential"]
[null,{"$f":"CONCATENATE(\"REGULATORY PERIOD FROM \", FRCP_y1,\" TO \",dms_MultiYear_FinalYear_Result)","v":"REGULATORY PERIOD FROM 2027-28 TO 2031-32"},null,null,null,"12.5% Grey",null,"Amended"]
[null,"2.1 - EXPENDITURE SUMMARY AND RECONCILIATION",null,null,null,"#FFCCCC & \n12.5% Grey",null,"Amended Confidential"]
[]
[null,"There are three tables on this worksheet. Each has been grouped for ease of navigation. See the Instructions sheet on how to group or ungroup tables. "]
[]
[null,"2.1.1 - PRESCRIBED TRANSMISSION SERVICES CAPEX (as incurred)"]
[null,null,"EXPENDITURE"]
[null,null,{"$f":"CONCATENATE(\"Forecast  ($0's. real \",dms_DollarReal,\")\")","v":"Forecast  ($0's. real March 2027)"}]
[null,null,{"$f":"dms_y4","v":"2025-26"},{"$f":"dms_y5","v":"2026-27"},{"$f":"dms_y6","v":"2027-28"},{"$f":"dms_y7","v":"2028-29"},{"$f":"dms_y8","v":"2029-30"},{"$f":"dms_y9","v":"2030-31"},{"$f":"dms_y10","v":"2031-32"}]
[null,"Replacement expenditure",{"$f":"SUM('2.2 Repex'!D58:D66)","v":209249232.49999997},{"$f":"SUM('2.2 Repex'!E58:E66)","v":290413843.84999996},{"$f":"SUM('2.2 Repex'!F58:F66)","v":524025442.87434101},{"$f":"SUM('2.2 Repex'!G58:G66)","v":533549316.07757974},{"$f":"SUM('2.2 Repex'!H58:H66)","v":386235768.25740916},{"$f":"SUM('2.2 Repex'!I58:I66)","v":323720365.25934905},{"$f":"SUM('2.2 Repex'!J58:J66)","v":258600394.82787094}]
[null,"Connections",{"$f":"SUM('2.5 Connections'!C13:C63)","v":0},{"$f":"SUM('2.5 Connections'!D13:D63)","v":0},{"$f":"SUM('2.5 Connections'!E13:E63)","v":0},{"$f":"SUM('2.5 Connections'!F13:F63)","v":0},{"$f":"SUM('2.5 Connections'!G13:G63)","v":0},{"$f":"SUM('2.5 Connections'!H13:H63)","v":0},{"$f":"SUM('2.5 Connections'!I13:I63)","v":0}]
[null,"Augmentation Expenditure",{"$f":"SUM('2.3 Augex (b)'!C10:C12)","v":0},{"$f":"SUM('2.3 Augex (b)'!D10:D12)","v":0},{"$f":"SUM('2.3 Augex (b)'!E10:E12)","v":0},{"$f":"SUM('2.3 Augex (b)'!F10:F12)","v":0},{"$f":"SUM('2.3 Augex (b)'!G10:G12)","v":0},{"$f":"SUM('2.3 Augex (b)'!H10:H12)","v":0},{"$f":"SUM('2.3 Augex (b)'!I10:I12)","v":0}]
[null,"ICT",{"$f":"'2.6 Non-network'!D62","v":24612250.478375003},{"$f":"'2.6 Non-network'!E62","v":52457750.749999993},{"$f":"'2.6 Non-network'!F62","v":51380560.98728437},{"$f":"'2.6 Non-network'!G62","v":58081256.674388565},{"$f":"'2.6 Non-network'!H62","v":45201294.791323528},{"$f":"'2.6 Non-network'!I62","v":51656580.476368248},{"$f":"'2.6 Non-network'!J62","v":49772351.145102128}]
[null,"Property",{"$f":"'2.6 Non-network'!D70","v":991354.95200000005},{"$f":"'2.6 Non-network'!E70","v":13778952},{"$f":"'2.6 Non-network'!F70","v":21117310.431404009},{"$f":"'2.6 Non-network'!G70","v":7372468.2126131291},{"$f":"'2.6 Non-network'!H70","v":683869.61077363288},{"$f":"'2.6 Non-network'!I70","v":13600343.845574375},{"$f":"'2.6 Non-network'!J70","v":589895.00113352155}]
[null,"Fleet",{"$f":"SUM('2.6 Non-network'!D64:D68)","v":599337.06700000004},{"$f":"SUM('2.6 Non-network'!E64:E68)","v":1267509},{"$f":"SUM('2.6 Non-network'!F64:F68)","v":1263166.6457611246},{"$f":"SUM('2.6 Non-network'!G64:G68)","v":2807325.4353266554},{"$f":"SUM('2.6 Non-network'!H64:H68)","v":3645777.7743943688},{"$f":"SUM('2.6 Non-network'!I64:I68)","v":3209545.0969118015},{"$f":"SUM('2.6 Non-network'!J64:J68)","v":1176838.4522082042}]
[null,"Other Non-network",{"$f":"SUM('2.6 Non-network'!D72:D83)","v":1295369.5545000001},{"$f":"SUM('2.6 Non-network'!E72:E83)","v":3000000},{"$f":"SUM('2.6 Non-network'!F72:F83)","v":4074030.0982336872},{"$f":"SUM('2.6 Non-network'!G72:G83)","v":5007670.5742587307},{"$f":"SUM('2.6 Non-network'!H72:H83)","v":5085464.3319475707},{"$f":"SUM('2.6 Non-network'!I72:I83)","v":2063044.4305086026},{"$f":"SUM('2.6 Non-network'!J72:J83)","v":2127422.5027256249}]
[null,"Capitalised network overheads",{"$f":"'2.10 Overheads'!D13","v":11017887.755175},{"$f":"'2.10 Overheads'!E13","v":15284939.250000002},{"$f":"'2.10 Overheads'!F13","v":16832334.537573423},{"$f":"'2.10 Overheads'!G13","v":17210775.046267167},{"$f":"'2.10 Overheads'!H13","v":14335307.821093703},{"$f":"'2.10 Overheads'!I13","v":13167459.132150291},{"$f":"'2.10 Overheads'!J13","v":11918555.592935996}]
[null,"Capitalised corporate overheads",{"$f":"'2.10 Overheads'!D26+'2.10 Overheads'!D39","v":1295381.6041250001},{"$f":"'2.10 Overheads'!E26+'2.10 Overheads'!E39","v":2760934.25},{"$f":"'2.10 Overheads'!F26+'2.10 Overheads'!F39","v":1958885.5099453868},{"$f":"'2.10 Overheads'!G26+'2.10 Overheads'!G39","v":2109890.526555263},{"$f":"'2.10 Overheads'!H26+'2.10 Overheads'!H39","v":1881259.4438072159},{"$f":"'2.10 Overheads'!I26+'2.10 Overheads'!I39","v":2028387.8965723692},{"$f":"'2.10 Overheads'!J26+'2.10 Overheads'!J39","v":2011600.8372176383}]
[null,"Total gross capex",{"$f":"SUM(C12:C20)","v":249060813.91117495},{"$f":"SUM(D12:D20)","v":378963929.09999996},620651731.08454311,626138702.5469892,457068742.0307492,409445726.13743472,326197058.35919398]
[]
[null,"2.1.2 - PRESCRIBED TRANSMISSION SERVICES OPEX"]
[null,null,"EXPENDITURE"]
[null,null,{"$f":"CONCATENATE(\"Forecast  ($0's. real \",dms_DollarReal,\")\")","v":"Forecast  ($0's. real March 2027)"}]
[null,null,{"$f":"dms_y4","v":"2025-26"},{"$f":"dms_y5","v":"2026-27"},{"$f":"dms_y6","v":"2027-28"},{"$f":"dms_y7","v":"2028-29"},{"$f":"dms_y8","v":"2029-30"},{"$f":"dms_y9","v":"2030-31"},{"$f":"dms_y10","v":"2031-32"}]
[null,"Vegetation management",7438700.7405649256,7236030.6647054125]
[null,"Maintenance",33168617.597947456,32384770.623934813]
[null,"Non-network",49372333.755841225,50151542.784005836]
[null,"Network overheads",14467029.524222633,14464043.594490996]
[null,"Corporate overheads",305077295.09714991,299850796.66204107]
[null,"Other",613418.5419338136,614918.82504000003]
[null,"Total",{"$f":"SUM(C27:C32)","v":410137395.25765997},{"$f":"SUM(D27:D32)","v":404702103.15421808},{"$f":"'2.16 Opex Summary'!H22","v":427344260.74722403},{"$f":"'2.16 Opex Summary'!I22","v":429482594.07338333},{"$f":"'2.16 Opex Summary'!J22","v":428430558.53276139},{"$f":"'2.16 Opex Summary'!K22","v":433439937.69469309},{"$f":"'2.16 Opex Summary'!L22","v":437740206.33032465}]
[]
[]
[null,"2.1.8 - PRESCRIBED TRANSMISSION SERVICES CAPITALISED OVERHEADS"]
[null,null,"EXPENDITURE"]
[null,null,{"$f":"CONCATENATE(\"Forecast  ($0's. real \",dms_DollarReal,\")\")","v":"Forecast  ($0's. real March 2027)"}]
[null,null,{"$f":"dms_y4","v":"2025-26"},{"$f":"dms_y5","v":"2026-27"},{"$f":"dms_y6","v":"2027-28"},{"$f":"dms_y7","v":"2028-29"},{"$f":"dms_y8","v":"2029-30"},{"$f":"dms_y9","v":"2030-31"},{"$f":"dms_y10","v":"2031-32"}]
[null,"Replacement expenditure",{"$f":"'2.10 Overheads'!D13","v":11017887.755175},{"$f":"'2.10 Overheads'!E13","v":15284939.250000002},{"$f":"'2.10 Overheads'!F13","v":16832334.537573423},{"$f":"'2.10 Overheads'!G13","v":17210775.046267167},{"$f":"'2.10 Overheads'!H13","v":14335307.821093703},{"$f":"'2.10 Overheads'!I13","v":13167459.132150291},{"$f":"'2.10 Overheads'!J13","v":11918555.592935996}]
[null,"Connections",0,0,0,0,0,0,0]
[null,"Augmentation Expenditure",0,0,0,0,0,0,0]
[null,"Non-network",{"$f":"'2.10 Overheads'!D26","v":1295381.6041250001},{"$f":"'2.10 Overheads'!E26","v":2760934.25},{"$f":"'2.10 Overheads'!F26","v":1958885.5099453868},{"$f":"'2.10 Overheads'!G26","v":2109890.526555263},{"$f":"'2.10 Overheads'!H26","v":1881259.4438072159},{"$f":"'2.10 Overheads'!I26","v":2028387.8965723692},{"$f":"'2.10 Overheads'!J26","v":2011600.8372176383}]
[null,"Total",{"$f":"SUM(C40:C43)","v":12313269.359300001},18045873.5,18791220.047518808,19320665.572822429,16216567.264900919,15195847.028722659,13930156.430153634]

{"sheet":"2.2 Repex","index":4,"n_rows":66,"n_cols":10,"rows_kept":66,"cut":false,"hidden":false,"merged":[[5,1,5,2]]}
[null,{"$f":"(LOOKUP(dms_Model,dms_Model_List,dms_Worksheet_List))","v":"REGULATORY REPORTING STATEMENT"},null,null,null,null,"#25C6FF",null,"Protected (SOCI)"]
[null,{"$f":"INDEX(dms_TradingNameFull_List,MATCH(dms_TradingName,dms_TradingName_List))","v":"AusNet Transmission Group Pty Limited"},null,null,null,null,"#FFCCCC",null,"Confidential"]
[null,{"$f":"CONCATENATE(\"REGULATORY PERIOD FROM \", FRCP_y1,\" TO \",dms_MultiYear_FinalYear_Result)","v":"REGULATORY PERIOD FROM 2027-28 TO 2031-32"},null,null,null,null,"12.5% Grey",null,"Amended"]
[null,"2.2 REPEX",null,null,null,null,"#FFCCCC & \n12.5% Grey",null,"Amended Confidential"]
[]
[null,"There is ONE table (with three sub-tables) on this worksheet. See the Instructions sheet on how to group or ungroup tables. "]
[]
[null,"2.2.1 - REPLACEMENT EXPENDITURE, VOLUMES AND ASSET FAILURES BY ASSET CATEGORY"]
[null,"EXPENDITURE AS COMMISSIONED"]
[null,null,null,"EXPENDITURE"]
[null,null,null,{"$f":"CONCATENATE(\"Forecast  ($0's. real \",dms_DollarReal,\")\")","v":"Forecast  ($0's. real March 2027)"}]
[null,"ASSET GROUP",null,{"$f":"dms_y4","v":"2025-26"},{"$f":"dms_y5","v":"2026-27"},{"$f":"dms_y6","v":"2027-28"},{"$f":"dms_y7","v":"2028-29"},{"$f":"dms_y8","v":"2029-30"},{"$f":"dms_y9","v":"2030-31"},{"$f":"dms_y10","v":"2031-32"}]
[null,"TRANSMISSION TOWERS","$",30661911,51627766,{"$f":"'[1]Output| RIN'!C28*10^6","v":14520024.214581819},{"$f":"'[1]Output| RIN'!D28*10^6","v":14624766.536040148},{"$f":"'[1]Output| RIN'!E28*10^6","v":14801715.172184082},{"$f":"'[1]Output| RIN'!F28*10^6","v":14953355.35273646},{"$f":"'[1]Output| RIN'!G28*10^6","v":15133461.74414346}]
[null,"TRANSMISSION TOWER SUPPORT STRUCTURES","$",12724118,19546893,{"$f":"'[1]Output| RIN'!C29*10^6","v":121092017.81030278},{"$f":"'[1]Output| RIN'!D29*10^6","v":127060595.41753572},{"$f":"'[1]Output| RIN'!E29*10^6","v":32775709.589952774},{"$f":"'[1]Output| RIN'!F29*10^6","v":33111489.22509215},{"$f":"'[1]Output| RIN'!G29*10^6","v":33510302.113421701}]
[null,"CONDUCTORS","$",14915655,26094753,{"$f":"'[1]Output| RIN'!C30*10^6","v":22586257.216249272},{"$f":"'[1]Output| RIN'!D30*10^6","v":19485640.932614692},{"$f":"'[1]Output| RIN'!E30*10^6","v":15409869.751512783},{"$f":"'[1]Output| RIN'!F30*10^6","v":26285020.11842373},{"$f":"'[1]Output| RIN'!G30*10^6","v":21202125.509429757}]
[null,"TRANSMISSION CABLES","$",485619,5560000,{"$f":"'[1]Output| RIN'!C31*10^6","v":7840092.9806073681},{"$f":"'[1]Output| RIN'!D31*10^6","v":25209261.760230992},{"$f":"'[1]Output| RIN'!E31*10^6","v":20819084.268389672},{"$f":"'[1]Output| RIN'!F31*10^6","v":9201884.3628605809},{"$f":"'[1]Output| RIN'!G31*10^6","v":0}]
[null,"SUBSTATION SWITCHBAYS","$",60607384,71066709,{"$f":"'[1]Output| RIN'!C32*10^6","v":69966956.438105047},{"$f":"'[1]Output| RIN'!D32*10^6","v":66680169.039294824},{"$f":"'[1]Output| RIN'!E32*10^6","v":39010777.641002357},{"$f":"'[1]Output| RIN'!F32*10^6","v":138098212.50430059},{"$f":"'[1]Output| RIN'!G32*10^6","v":72887204.115160003}]
[null,"SUBSTATION POWER TRANSFORMERS","$",53217378,91913065,{"$f":"'[1]Output| RIN'!C33*10^6","v":104821308.93596435},{"$f":"'[1]Output| RIN'!D33*10^6","v":206360994.43375102},{"$f":"'[1]Output| RIN'!E33*10^6","v":47696910.942247719},{"$f":"'[1]Output| RIN'!F33*10^6","v":58989423.103908025},{"$f":"'[1]Output| RIN'!G33*10^6","v":55387731.310661472}]
[null,"SUBSTATION REACTIVE PLANT","$",899023,1321201,{"$f":"'[1]Output| RIN'!C34*10^6","v":0},{"$f":"'[1]Output| RIN'!D34*10^6","v":5045127.8774255132},{"$f":"'[1]Output| RIN'!E34*10^6","v":19744772.191320807},{"$f":"'[1]Output| RIN'!F34*10^6","v":15532849.691213153},{"$f":"'[1]Output| RIN'!G34*10^6","v":6430612.4529747665}]
[null,"SCADA, NETWORK CONTROL AND PROTECTION SYSTEMS","$",37114182,53303213,{"$f":"'[1]Output| RIN'!C35*10^6","v":64827647.279196851},{"$f":"'[1]Output| RIN'!D35*10^6","v":44720525.295281887},{"$f":"'[1]Output| RIN'!E35*10^6","v":36262415.770907745},{"$f":"'[1]Output| RIN'!F35*10^6","v":54864689.987644225},{"$f":"'[1]Output| RIN'!G35*10^6","v":41474405.439603776}]
[null,"OTHER","$",36932632,52414157,{"$f":"'[1]Output| RIN'!C36*10^6","v":89297755.86208719},{"$f":"'[1]Output| RIN'!D36*10^6","v":74970116.586932719},{"$f":"'[1]Output| RIN'!E36*10^6","v":56080735.029219642},{"$f":"'[1]Output| RIN'!F36*10^6","v":115325334.80476101},{"$f":"'[1]Output| RIN'!G36*10^6","v":63090187.051637277}]
[]
[]
[null,"ASSET REPLACEMENTS"]
[null,null,null,"VOLUMES "]
[null,null,null,"(0's)"]
[null,"ASSET GROUP",null,{"$f":"dms_y4","v":"2025-26"},{"$f":"dms_y5","v":"2026-27"},{"$f":"dms_y6","v":"2027-28"},{"$f":"dms_y7","v":"2028-29"},{"$f":"dms_y8","v":"2029-30"},{"$f":"dms_y9","v":"2030-31"},{"$f":"dms_y10","v":"2031-32"}]
[null,"TRANSMISSION TOWERS","number of assets",3,3,4,4,4,4,5]
[null,"TRANSMISSION TOWER SUPPORT STRUCTURES","number of assets",null,null,311,310,310,310,310]
[null,"CONDUCTORS","km",null,null,58,59,60,57.253,57.253]
[null,"TRANSMISSION CABLES","km",null,null,0,0,0,0,0]
[null,"SUBSTATION SWITCHBAYS","number of assets",44,73,151,157,191,159,38]
[null,"SUBSTATION POWER TRANSFORMERS","number of assets",2,9,25,44,25,112,26]
[null,"SUBSTATION REACTIVE PLANT","number of assets",null,null,null,1]
[null,"SCADA, NETWORK CONTROL AND PROTECTION SYSTEMS","number of assets",null,6,152,122,210,174,107]
[null,"OTHER","number of assets",null,null,384,396,342,345,331]
[]
[]
[null,"ASSET FAILURES"]
[null,null,null,"VOLUMES "]
[null,null,null,"(0's)"]
[null,"ASSET GROUP",null,{"$f":"dms_y4","v":"2025-26"},{"$f":"dms_y5","v":"2026-27"},{"$f":"dms_y6","v":"2027-28"},{"$f":"dms_y7","v":"2028-29"},{"$f":"dms_y8","v":"2029-30"},{"$f":"dms_y9","v":"2030-31"},{"$f":"dms_y10","v":"2031-32"}]
[null,"TRANSMISSION TOWERS","number of assets",0,0,0,0,0,0,0]
[null,"TRANSMISSION TOWER SUPPORT STRUCTURES","number of assets",0,0,0,0,0,0,0]
[null,"CONDUCTORS","km",0,0,0,0,0,0,0]
[null,"TRANSMISSION CABLES","km",0,0,0,0,0,0,0]
[null,"SUBSTATION SWITCHBAYS","number of assets",0,0,0,0,0,0,0]
[null,"SUBSTATION POWER TRANSFORMERS","number of assets",0,0,0,0,0,0,0]
[null,"SUBSTATION REACTIVE PLANT","number of assets",0,0,0,0,0,0,0]
[null,"SCADA, NETWORK CONTROL AND PROTECTION SYSTEMS","number of assets",0,0,0,0,0,0,0]
[null,"OTHER","number of assets",0,0,0,0,0,0,0]
[]
[]
[null,"EXPENDITURE AS INCURRED"]
[null,null,null,"EXPENDITURE"]
[null,null,null,{"$f":"CONCATENATE(\"Forecast  ($0's. real \",dms_DollarReal,\")\")","v":"Forecast  ($0's. real March 2027)"}]
[null,"ASSET GROUP",null,{"$f":"dms_y4","v":"2025-26"},{"$f":"dms_y5","v":"2026-27"},{"$f":"dms_y6","v":"2027-28"},{"$f":"dms_y7","v":"2028-29"},{"$f":"dms_y8","v":"2029-30"},{"$f":"dms_y9","v":"2030-31"},{"$f":"dms_y10","v":"2031-32"}]
[null,"TRANSMISSION TOWERS","$",29128815.449999999,49046377.699999996,{"$f":"'[1]Output| RIN'!C43*10^6","v":14068138.496596904},{"$f":"'[1]Output| RIN'!D43*10^6","v":14167755.26922459},{"$f":"'[1]Output| RIN'!E43*10^6","v":14272003.57805034},{"$f":"'[1]Output| RIN'!F43*10^6","v":14368894.647303358},{"$f":"'[1]Output| RIN'!G43*10^6","v":14466709.914629962}]
[null,"TRANSMISSION TOWER SUPPORT STRUCTURES","$",12087912.1,18569548.349999998,{"$f":"'[1]Output| RIN'!C44*10^6","v":117323446.03646936},{"$f":"'[1]Output| RIN'!D44*10^6","v":123090062.03972016},{"$f":"'[1]Output| RIN'!E44*10^6","v":31602759.48425252},{"$f":"'[1]Output| RIN'!F44*10^6","v":31817307.157326575},{"$f":"'[1]Output| RIN'!G44*10^6","v":32033901.299158536}]
[null,"CONDUCTORS","$",22316812.899999999,9010323.4499999993,{"$f":"'[1]Output| RIN'!C45*10^6","v":24395545.47677128},{"$f":"'[1]Output| RIN'!D45*10^6","v":22321369.304918472},{"$f":"'[1]Output| RIN'!E45*10^6","v":21172080.429363869},{"$f":"'[1]Output| RIN'!F45*10^6","v":19909411.359940194},{"$f":"'[1]Output| RIN'!G45*10^6","v":17392792.110775031}]
[null,"TRANSMISSION CABLES","$",461338.05,5282000,{"$f":"'[1]Output| RIN'!C46*10^6","v":7596097.1033792607},{"$f":"'[1]Output| RIN'!D46*10^6","v":24421494.200035281},{"$f":"'[1]Output| RIN'!E46*10^6","v":20074028.024033763},{"$f":"'[1]Output| RIN'!F46*10^6","v":8842223.2902005836},{"$f":"'[1]Output| RIN'!G46*10^6","v":0}]
[null,"SUBSTATION SWITCHBAYS","$",39183404.549999997,50259839.299999997,{"$f":"'[1]Output| RIN'!C47*10^6","v":76056720.764515251},{"$f":"'[1]Output| RIN'!D47*10^6","v":76493838.523897424},{"$f":"'[1]Output| RIN'!E47*10^6","v":75512970.880112603},{"$f":"'[1]Output| RIN'!F47*10^6","v":82049233.383523107},{"$f":"'[1]Output| RIN'!G47*10^6","v":68956301.304413125}]
[null,"SUBSTATION POWER TRANSFORMERS","$",36831072.5,76086570.649999991,{"$f":"'[1]Output| RIN'!C48*10^6","v":128881934.60708556},{"$f":"'[1]Output| RIN'!D48*10^6","v":140186876.71561402},{"$f":"'[1]Output| RIN'!E48*10^6","v":77280527.279870942},{"$f":"'[1]Output| RIN'!F48*10^6","v":37764337.105158426},{"$f":"'[1]Output| RIN'!G48*10^6","v":21798417.273365073}]
[null,"SUBSTATION REACTIVE PLANT","$",854071.85,1255140.95,{"$f":"'[1]Output| RIN'!C49*10^6","v":0},{"$f":"'[1]Output| RIN'!D49*10^6","v":4887472.0080598863},{"$f":"'[1]Output| RIN'!E49*10^6","v":19038162.542938493},{"$f":"'[1]Output| RIN'!F49*10^6","v":14925739.10808564},{"$f":"'[1]Output| RIN'!G49*10^6","v":6147291.7765556723}]
[null,"SCADA, NETWORK CONTROL AND PROTECTION SYSTEMS","$",32986861.399999999,42033457.75,{"$f":"'[1]Output| RIN'!C50*10^6","v":65196235.566533037},{"$f":"'[1]Output| RIN'!D50*10^6","v":46124125.963274613},{"$f":"'[1]Output| RIN'!E50*10^6","v":45429825.878660508},{"$f":"'[1]Output| RIN'!F50*10^6","v":41801362.231309287},{"$f":"'[1]Output| RIN'!G50*10^6","v":36729426.839819521}]
[null,"OTHER","$",35398943.699999996,38870585.699999996,{"$f":"'[1]Output| RIN'!C51*10^6","v":90507324.822990388},{"$f":"'[1]Output| RIN'!D51*10^6","v":81856322.05283533},{"$f":"'[1]Output| RIN'!E51*10^6","v":81853410.16012609},{"$f":"'[1]Output| RIN'!F51*10^6","v":72241856.976501867},{"$f":"'[1]Output| RIN'!G51*10^6","v":61075554.309154041}]

{"sheet":"2.3 Augex (b)","index":5,"n_rows":13,"n_cols":9,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
[null,{"$f":"(LOOKUP(dms_Model,dms_Model_List,dms_Worksheet_List))","v":"REGULATORY REPORTING STATEMENT"},null,null,null,"#25C6FF",null,"Protected (SOCI)"]
[null,{"$f":"INDEX(dms_TradingNameFull_List,MATCH(dms_TradingName,dms_TradingName_List))","v":"AusNet Transmission Group Pty Limited"},null,null,null,"#FFCCCC",null,"Confidential"]
[null,{"$f":"CONCATENATE(\"REGULATORY PERIOD FROM \", FRCP_y1,\" TO \",dms_MultiYear_FinalYear_Result)","v":"REGULATORY PERIOD FROM 2027-28 TO 2031-32"},null,null,null,"12.5% Grey",null,"Amended"]
[null,"2.3 AUGEX PROJECTS",null,null,null,"#FFCCCC & \n12.5% Grey",null,"Amended Confidential"]
[]
[null,"2.3.4 - AUGEX - TOTAL EXPENDITURE"]
[null,null,"EXPENDITURE"]
[null,null,{"$f":"CONCATENATE(\"Forecast  ($0's. real \",dms_DollarReal,\")\")","v":"Forecast  ($0's. real March 2027)"}]
[null,"As incurred",{"$f":"dms_y4","v":"2025-26"},{"$f":"dms_y5","v":"2026-27"},{"$f":"dms_y6","v":"2027-28"},{"$f":"dms_y7","v":"2028-29"},{"$f":"dms_y8","v":"2029-30"},{"$f":"dms_y9","v":"2030-31"},{"$f":"dms_y10","v":"2031-32"}]
[null,"Substations","Not required","Not required","Not required","Not required","Not required","Not required","Not required"]
[null,"Lines","Not required","Not required","Not required","Not required","Not required","Not required","Not required"]
[null,"Other assets","Not required","Not required","Not required","Not required","Not required","Not required","Not required"]
[null,"Total ",{"$f":"SUM(C10:C12)","v":0},0,0,0,0,0,0]

{"sheet":"2.5 Connections","index":6,"n_rows":93,"n_cols":9,"rows_kept":93,"cut":false,"hidden":false,"merged":[]}
[null,{"$f":"(LOOKUP(dms_Model,dms_Model_List,dms_Worksheet_List))","v":"REGULATORY REPORTING STATEMENT"},null,null,null,"#25C6FF",null,"Protected (SOCI)"]
[null,{"$f":"INDEX(dms_TradingNameFull_List,MATCH(dms_TradingName,dms_TradingName_List))","v":"AusNet Transmission Group Pty Limited"},null,null,null,"#FFCCCC",null,"Confidential"]
[null,{"$f":"CONCATENATE(\"REGULATORY PERIOD FROM \", FRCP_y1,\" TO \",dms_MultiYear_FinalYear_Result)","v":"REGULATORY PERIOD FROM 2027-28 TO 2031-32"},null,null,null,"12.5% Grey",null,"Amended"]
[null,"2.5 CONNECTIONS EXPENDITURE",null,null,null,"#FFCCCC & \n12.5% Grey",null,"Amended Confidential"]
[]
[null,"There are TWO tables on this worksheet. Each has been grouped (or sub-grouped).  See the Instructions sheet on how to group or ungroup data."]
[]
[null,"2.5.1 - EXPENDITURE ON CONNECTION PROJECTS"]
[null,null,"EXPENDITURE"]
[null,null,{"$f":"CONCATENATE(\"Forecast  ($0's. real \",dms_DollarReal,\")\")","v":"Forecast  ($0's. real March 2027)"}]
[null,null,{"$f":"dms_y4","v":"2025-26"},{"$f":"dms_y5","v":"2026-27"},{"$f":"dms_y6","v":"2027-28"},{"$f":"dms_y7","v":"2028-29"},{"$f":"dms_y8","v":"2029-30"},{"$f":"dms_y9","v":"2030-31"},{"$f":"dms_y10","v":"2031-32"}]
[null,"DIRECT MATERIALS EXPENDITURE"]
[null,"<Enter project description here…>","Not required","Not required","Not required","Not required","Not required","Not required","Not required"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"DIRECT LABOUR EXPENDITURE"]
[null,{"$f":"IF(ISBLANK(B13),\"\",B13)","v":"<Enter project description here…>"},"Not required","Not required","Not required","Not required","Not required","Not required","Not required"]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[]
[]
[]
[null,"2.5.2 - DESCRIPTION OF CONNECTION PROJECTS"]
[null,null,"CONNECTION RATING \n(MVA)","CONNECTION \nVOLTAGE \n(KV)","UNDERGROUND / OVERHEAD\n(drop down)","YEAR CONNECTION PROJECT COMPLETED "]
[null,{"$f":"IF(ISBLANK(B13),\"\",B13)","v":"<Enter project description here…>"},"Not required","Not required","Not required","Not required"]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]

{"sheet":"2.14 Forecast price changes","index":7,"n_rows":15,"n_cols":9,"rows_kept":15,"cut":false,"hidden":false,"merged":[[6,2,6,3],[6,4,6,8]]}
[null,{"$f":"(LOOKUP(dms_Model,dms_Model_List,dms_Worksheet_List))","v":"REGULATORY REPORTING STATEMENT"},null,null,null,"#25C6FF",null,"Protected (SOCI)"]
[null,{"$f":"INDEX(dms_TradingNameFull_List,MATCH(dms_TradingName,dms_TradingName_List))","v":"AusNet Transmission Group Pty Limited"},null,null,null,"#FFCCCC",null,"Confidential"]
[null,{"$f":"CONCATENATE(\"REGULATORY PERIOD FROM \", FRCP_y1,\" TO \",dms_MultiYear_FinalYear_Result)","v":"REGULATORY PERIOD FROM 2027-28 TO 2031-32"},null,null,null,"12.5% Grey",null,"Amended"]
[null,"2.14 FORECAST PRICE CHANGES",null,null,null,"#FFCCCC & \n12.5% Grey",null,"Amended Confidential"]
[]
[null,"2.14.2 - FORECAST CAPEX AND OPEX PRICE CHANGES"]
[null,null,"Price changes\n(% YoY real)\nCurrent regulatory period",null,"Price changes\n(%YoY real)\nForthcoming regulatory period "]
[null,null,"FORECAST"]
[null,"Description",{"$f":"dms_y4","v":"2025-26"},{"$f":"dms_y5","v":"2026-27"},{"$f":"dms_y6","v":"2027-28"},{"$f":"dms_y7","v":"2028-29"},{"$f":"dms_y8","v":"2029-30"},{"$f":"dms_y9","v":"2030-31"},{"$f":"dms_y10","v":"2031-32"}]
[null,"OPEX"]
[null,"Labour Price Growth - WPI",1.0436139272704334E-2,7.1922494031081072E-3,9.4532903132763194E-3,1.1677109032548483E-2,1.2078971675182581E-2,1.1092521820503005E-2,1.1075473210377598E-2]
[null,"Productivity Growth",5.0000000000000001E-3,5.0000000000000001E-3,5.1539999999999997E-3,5.1539999999999997E-3,5.1539999999999997E-3,5.1539999999999997E-3,5.1539999999999997E-3]
[null,"Output Growth"]
[null,"CAPEX"]
[null,"Labour Price Growth - WPI",{"$f":"'[1]Input| Escalations'!H25","v":8.100515567042995E-3},{"$f":"'[1]Input| Escalations'!I25","v":9.3135243940020672E-3},{"$f":"'[1]Input| Escalations'!J25","v":9.4532903132763194E-3},{"$f":"'[1]Input| Escalations'!K25","v":1.1677109032548483E-2},{"$f":"'[1]Input| Escalations'!L25","v":1.2078971675182581E-2},{"$f":"'[1]Input| Escalations'!M25","v":1.1092521820503005E-2},{"$f":"'[1]Input| Escalations'!N25","v":1.1075473210377598E-2}]

{"sheet":"2.6 Non-network","index":8,"n_rows":122,"n_cols":10,"rows_kept":122,"cut":false,"hidden":false,"merged":[]}
[null,{"$f":"(LOOKUP(dms_Model,dms_Model_List,dms_Worksheet_List))","v":"REGULATORY REPORTING STATEMENT"},null,null,null,"#25C6FF",null,"Protected (SOCI)"]
[null,{"$f":"INDEX(dms_TradingNameFull_List,MATCH(dms_TradingName,dms_TradingName_List))","v":"AusNet Transmission Group Pty Limited"},null,null,null,"#FFCCCC",null,"Confidential"]
[null,{"$f":"CONCATENATE(\"REGULATORY PERIOD FROM \", FRCP_y1,\" TO \",dms_MultiYear_FinalYear_Result)","v":"REGULATORY PERIOD FROM 2027-28 TO 2031-32"},null,null,null,"12.5% Grey",null,"Amended"]
[null,"2.6 NON NETWORK EXPENDITURE",null,null,null,"#FFCCCC & \n12.5% Grey",null,"Amended Confidential"]
[]
[null,"2.6.1 - NON-NETWORK EXPENDITURE"]
[null,null,null,"EXPENDITURE"]
[null,null,null,{"$f":"CONCATENATE(\"Forecast  ($0's. real \",dms_DollarReal,\")\")","v":"Forecast  ($0's. real March 2027)"}]
[null,null,null,{"$f":"dms_y4","v":"2025-26"},{"$f":"dms_y5","v":"2026-27"},{"$f":"dms_y6","v":"2027-28"},{"$f":"dms_y7","v":"2028-29"},{"$f":"dms_y8","v":"2029-30"},{"$f":"dms_y9","v":"2030-31"},{"$f":"dms_y10","v":"2031-32"}]
[null,"OPEX"]
[null,"INFORMATION & COMMUNICATIONS TECHNOLOGY"]
[null,"Device expenditure",null,"-   "," -   ",0,0,0,0,0]
[null,"Recurrent",null,20783679.930792835,21209665.558908749,21303382.871547729,23243460.761043977,25944623.855293773,27605630.859161895,28481211.179605]
[null,"Non-recurrent",null,5881366.0389937032,5894279.0923181102,4594506.0024973415,4608401.2375248298,4623635.5452875113,4635725.8301281733,4647792.3774535265]
[null,null,"Total IT and communications",{"$f":"SUM(D12:D14)","v":26665045.96978654},27103944.65122686,25897888.87404507,27851861.998568807,30568259.400581285,32241356.689290069,33129003.557058528]
[null,"MOTOR VEHICLES"]
[null,"Car",null,109035.75347006448,119939.32881707093,112286.04090183294,112625.62929888567,112997.94355935711,113293.42042180883,113588.31715842907]
[null,"Light commercial vehicle",null,219585.89240499091,234729.74705361098,226131.61014952461,226815.50344914471,227565.30300148306,228160.36057169831,228754.24983294739]
[null,"Elevated work platform (LCV)  ",null,0,0,0,0,0,0,0]
[null,"Elevated work platform (HCV)",null,0,0,0,0,0,0,0]
[null,"Heavy commercial vehicle",null,18172.625578344076,18172.625578344076,18714.340150305485,18770.938216480943,18832.990593226183,18882.236736968138,18931.38619307151]
[null,"BUILDINGS AND PROPERTY"]
[null,"Total buildings and property expenditure",null,22360493.514601294,22674756.43132994,26530090.646821316,26729047.741579462,26940295.632186104,27142219.558818992,27350303.555164672]
[null,"OTHER"]
[null,"Other expenditure",null,0,0,0,0,0,0,0]
[null,"Other - TNSP nominated"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"CAPEX"]
[null,"IT & COMMUNICATIONS"]
[null,"Recurrent"]
[null,"Advanced Energy Management System",null,null,null,{"$f":"'[1]Output| RIN'!C69*10^6","v":0},{"$f":"'[1]Output| RIN'!D69*10^6","v":0},{"$f":"'[1]Output| RIN'!E69*10^6","v":0},{"$f":"'[1]Output| RIN'!F69*10^6","v":0},{"$f":"'[1]Output| RIN'!G69*10^6","v":0}]
[null,"Asset Management & Field Enablement",null,null,null,{"$f":"'[1]Output| RIN'!C70*10^6","v":0},{"$f":"'[1]Output| RIN'!D70*10^6","v":0},{"$f":"'[1]Output| RIN'!E70*10^6","v":0},{"$f":"'[1]Output| RIN'!F70*10^6","v":0},{"$f":"'[1]Output| RIN'!G70*10^6","v":0}]
[null,"Customer Engagement",null,null,null,{"$f":"'[1]Output| RIN'!C71*10^6","v":0},{"$f":"'[1]Output| RIN'!D71*10^6","v":0},{"$f":"'[1]Output| RIN'!E71*10^6","v":0},{"$f":"'[1]Output| RIN'!F71*10^6","v":0},{"$f":"'[1]Output| RIN'!G71*10^6","v":0}]
[null,"Metering Systems",null,null,null,{"$f":"'[1]Output| RIN'!C72*10^6","v":0},{"$f":"'[1]Output| RIN'!D72*10^6","v":0},{"$f":"'[1]Output| RIN'!E72*10^6","v":0},{"$f":"'[1]Output| RIN'!F72*10^6","v":0},{"$f":"'[1]Output| RIN'!G72*10^6","v":0}]
[null,"Digital resilience – applications",null,null,null,{"$f":"'[1]Output| RIN'!C73*10^6","v":5739796.4258830454},{"$f":"'[1]Output| RIN'!D73*10^6","v":9259519.2683516089},{"$f":"'[1]Output| RIN'!E73*10^6","v":5985800.5614471007},{"$f":"'[1]Output| RIN'!F73*10^6","v":6361053.9338220693},{"$f":"'[1]Output| RIN'!G73*10^6","v":9901401.7315168455}]
[null,"Digital resilience – infrastructure",null,null,null,{"$f":"'[1]Output| RIN'!C74*10^6","v":5952018.6145253591},{"$f":"'[1]Output| RIN'!D74*10^6","v":4658863.8147196416},{"$f":"'[1]Output| RIN'!E74*10^6","v":7453310.0561008686},{"$f":"'[1]Output| RIN'!F74*10^6","v":8338459.1507291915},{"$f":"'[1]Output| RIN'!G74*10^6","v":4572620.4147856981}]
[null,"Cyber security",null,null,null,{"$f":"'[1]Output| RIN'!C75*10^6","v":4391588.807435696},{"$f":"'[1]Output| RIN'!D75*10^6","v":4430305.0595849007},{"$f":"'[1]Output| RIN'!E75*10^6","v":4470821.367272472},{"$f":"'[1]Output| RIN'!F75*10^6","v":4508478.2695114799},{"$f":"'[1]Output| RIN'!G75*10^6","v":4546494.3631266849}]
[null,"Other",null,5206437.6011947114,14159791.416213768,{"$f":"'[1]Output| RIN'!C76*10^6","v":0},{"$f":"'[1]Output| RIN'!D76*10^6","v":0},{"$f":"'[1]Output| RIN'!E76*10^6","v":0},{"$f":"'[1]Output| RIN'!F76*10^6","v":0},{"$f":"'[1]Output| RIN'!G76*10^6","v":0}]
[]
[]
[null,"Non-recurrent"]
[null,"Advanced Energy Management System",null,null,null,{"$f":"'[1]Output| RIN'!C77*10^6","v":12970342.573599471},{"$f":"'[1]Output| RIN'!D77*10^6","v":16319535.833479747},{"$f":"'[1]Output| RIN'!E77*10^6","v":15648706.801404504},{"$f":"'[1]Output| RIN'!F77*10^6","v":17833467.140333261},{"$f":"'[1]Output| RIN'!G77*10^6","v":18637020.052786123}]
[null,"Asset Management & Field Enablement",null,null,null,{"$f":"'[1]Output| RIN'!C78*10^6","v":8678660.6884565502},{"$f":"'[1]Output| RIN'!D78*10^6","v":7961063.3369872784},{"$f":"'[1]Output| RIN'!E78*10^6","v":3958950.4317778726},{"$f":"'[1]Output| RIN'!F78*10^6","v":4610742.8902631849},{"$f":"'[1]Output| RIN'!G78*10^6","v":4259832.6815009732}]
[null,"Customer Engagement",null,null,null,{"$f":"'[1]Output| RIN'!C79*10^6","v":3852075.5756413648},{"$f":"'[1]Output| RIN'!D79*10^6","v":0},{"$f":"'[1]Output| RIN'!E79*10^6","v":0},{"$f":"'[1]Output| RIN'!F79*10^6","v":0},{"$f":"'[1]Output| RIN'!G79*10^6","v":0}]
[null,"Metering Systems",null,null,null,{"$f":"'[1]Output| RIN'!C80*10^6","v":2291705.6827852423},{"$f":"'[1]Output| RIN'!D80*10^6","v":7859967.3650153158},{"$f":"'[1]Output| RIN'!E80*10^6","v":0},{"$f":"'[1]Output| RIN'!F80*10^6","v":2235441.8466539667},{"$f":"'[1]Output| RIN'!G80*10^6","v":0}]
[null,"Digital resilience – applications",null,null,null,{"$f":"'[1]Output| RIN'!C81*10^6","v":0},{"$f":"'[1]Output| RIN'!D81*10^6","v":0},{"$f":"'[1]Output| RIN'!E81*10^6","v":0},{"$f":"'[1]Output| RIN'!F81*10^6","v":0},{"$f":"'[1]Output| RIN'!G81*10^6","v":0}]
[null,"Digital resilience – infrastructure",null,null,null,{"$f":"'[1]Output| RIN'!C82*10^6","v":0},{"$f":"'[1]Output| RIN'!D82*10^6","v":0},{"$f":"'[1]Output| RIN'!E82*10^6","v":0},{"$f":"'[1]Output| RIN'!F82*10^6","v":0},{"$f":"'[1]Output| RIN'!G82*10^6","v":0}]
[null,"Cyber security",null,null,null,{"$f":"'[1]Output| RIN'!C83*10^6","v":7504372.6189576369},{"$f":"'[1]Output| RIN'!D83*10^6","v":7592001.9962500772},{"$f":"'[1]Output| RIN'!E83*10^6","v":7683705.573320712},{"$f":"'[1]Output| RIN'!F83*10^6","v":7768937.2450550916},{"$f":"'[1]Output| RIN'!G83*10^6","v":7854981.9013858028}]
[null,"Other",null,19405812.877180289,38297959.333786227,{"$f":"'[1]Output| RIN'!C84*10^6","v":0},{"$f":"'[1]Output| RIN'!D84*10^6","v":0},{"$f":"'[1]Output| RIN'!E84*10^6","v":0},{"$f":"'[1]Output| RIN'!F84*10^6","v":0},{"$f":"'[1]Output| RIN'!G84*10^6","v":0}]
[]
[]
[null,null,"Total IT and communications",{"$f":"SUM(D40:D61)","v":24612250.478375003},52457750.749999993,51380560.98728437,58081256.674388565,45201294.791323528,51656580.476368248,49772351.145102128]
[null,"MOTOR VEHICLES"]
[null,"Car",null,149834.26675000001,570379.05000000005,{"$f":"'[1]Output| RIN'!C58*10^6","v":311166.25188100414},{"$f":"'[1]Output| RIN'!D58*10^6","v":126379.75764264503},{"$f":"'[1]Output| RIN'!E58*10^6","v":126537.76259725644},{"$f":"'[1]Output| RIN'!F58*10^6","v":580386.54716601036},{"$f":"'[1]Output| RIN'!G58*10^6","v":632683.12660473527}]
[null,"Light commercial vehicle",null,449502.80025000003,697129.95000000007,{"$f":"'[1]Output| RIN'!C59*10^6","v":952000.39388012036},{"$f":"'[1]Output| RIN'!D59*10^6","v":2292084.8849374102},{"$f":"'[1]Output| RIN'!E59*10^6","v":3519240.0117971124},{"$f":"'[1]Output| RIN'!F59*10^6","v":2629158.5497457911},{"$f":"'[1]Output| RIN'!G59*10^6","v":544155.32560346881}]
[null,"Elevated work platform (LCV)  ",null,null,null,{"$f":"'[1]Output| RIN'!C60*10^6","v":0},{"$f":"'[1]Output| RIN'!D60*10^6","v":0},{"$f":"'[1]Output| RIN'!E60*10^6","v":0},{"$f":"'[1]Output| RIN'!F60*10^6","v":0},{"$f":"'[1]Output| RIN'!G60*10^6","v":0}]
[null,"Elevated work platform (HCV)",null,null,null,{"$f":"'[1]Output| RIN'!C61*10^6","v":0},{"$f":"'[1]Output| RIN'!D61*10^6","v":0},{"$f":"'[1]Output| RIN'!E61*10^6","v":0},{"$f":"'[1]Output| RIN'!F61*10^6","v":0},{"$f":"'[1]Output| RIN'!G61*10^6","v":0}]
[null,"Heavy commercial vehicle",null,null,null,{"$f":"'[1]Output| RIN'!C62*10^6","v":0},{"$f":"'[1]Output| RIN'!D62*10^6","v":388860.79274660005},{"$f":"'[1]Output| RIN'!E62*10^6","v":0},{"$f":"'[1]Output| RIN'!F62*10^6","v":0},{"$f":"'[1]Output| RIN'!G62*10^6","v":0}]
[null,"BUILDINGS AND PROPERTY"]
[null,"Total buildings and property expenditure",null,991354.95200000005,13778952,{"$f":"'[1]Output| TRR Driver'!C69*10^3","v":21117310.431404009},{"$f":"'[1]Output| TRR Driver'!D69*10^3","v":7372468.2126131291},{"$f":"'[1]Output| TRR Driver'!E69*10^3","v":683869.61077363288},{"$f":"'[1]Output| TRR Driver'!F69*10^3","v":13600343.845574375},{"$f":"'[1]Output| TRR Driver'!G69*10^3","v":589895.00113352155}]
[null,"OTHER"]
[null,"Other expenditure",null,1295369.5545000001,3000000]
[null,"OTHER - TNSP nominated"]
[null,"Testing Equipment",null,null,null,{"$f":"'[1]Output| TRR Driver'!C70*10^3","v":4074030.0982336872},{"$f":"'[1]Output| TRR Driver'!D70*10^3","v":5007670.5742587307},{"$f":"'[1]Output| TRR Driver'!E70*10^3","v":5085464.3319475707},{"$f":"'[1]Output| TRR Driver'!F70*10^3","v":2063044.4305086026},{"$f":"'[1]Output| TRR Driver'!G70*10^3","v":2127422.5027256249}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"2.6.3 - ANNUAL DESCRIPTOR METRICS"]
[null,"IT & COMMUNICATIONS"]
[null,null,null,"VOLUMES "]
[null,null,null,"(0's)"]
[null,null,null,{"$f":"dms_y4","v":"2025-26"},{"$f":"dms_y5","v":"2026-27"},{"$f":"dms_y6","v":"2027-28"},{"$f":"dms_y7","v":"2028-29"},{"$f":"dms_y8","v":"2029-30"},{"$f":"dms_y9","v":"2030-31"},{"$f":"dms_y10","v":"2031-32"}]
[null,"Number of devices",null,514.35,514.35,514.35,514.35,514.35,514.35,514.35]
[]
[null,"MOTOR VEHICLES"]
[null,null,null,"VOLUMES"]
[null,null,null,"  (0's or %)"]
[null,null,"Units",{"$f":"dms_y4","v":"2025-26"},{"$f":"dms_y5","v":"2026-27"},{"$f":"dms_y6","v":"2027-28"},{"$f":"dms_y7","v":"2028-29"},{"$f":"dms_y8","v":"2029-30"},{"$f":"dms_y9","v":"2030-31"},{"$f":"dms_y10","v":"2031-32"}]
[null,"CAR"]
[null,"Number purchased","0's",4,12,5,2,2,6,9]
[null,"Number leased","0's",0,0,0,0,0,0,0]
[null,"Number in fleet","0's",20,22,24,26,28,30,32]
[null,"Proportion of total fleet expenditure allocated as regulatory expenditure","%"]
[null,"LIGHT COMMERCIAL VEHICLE"]
[null,"Number purchased","0's",4,5,6,23,35,28,5]
[null,"Number leased","0's",0,0,0,0,0,0,0]
[null,"Number in fleet","0's",29,31,33,55,77,99,101]
[null,"Proportion of total fleet expenditure allocated as regulatory expenditure","%"]
[null,"ELEVATED WORK PLATFORM (LCV) "]
[null,"Number purchased","0's",0,0,0,0,0,0,0]
[null,"Number leased","0's",0,0,0,0,0,0,0]
[null,"Number in fleet","0's",0,0,0,0,0,0,0]
[null,"Proportion of total fleet expenditure allocated as regulatory expenditure","%"]
[null,"ELEVATED WORK PLATFORM (HCV)"]
[null,"Number purchased","0's",0,0,0,0,0,0,0]
[null,"Number leased","0's",0,0,0,0,0,0,0]
[null,"Number in fleet","0's",0,0,0,0,0,0,0]
[null,"Proportion of total fleet expenditure allocated as regulatory expenditure","%"]
[null,"HEAVY COMMERCIAL VEHICLE "]
[null,"Number purchased","0's",0,0,1,2,1,1,1]
[null,"Number leased","0's",0,0,0,0,0,0,0]
[null,"Number in fleet","0's",6,6,6,6,6,6,6]
[null,"Proportion of total fleet expenditure allocated as regulatory expenditure","%"]

{"sheet":"2.16 Opex Summary","index":9,"n_rows":60,"n_cols":13,"rows_kept":60,"cut":false,"hidden":false,"merged":[[8,10,8,11],[23,1,23,8],[5,10,5,12],[6,1,6,8],[6,10,6,11],[6,12,7,12],[7,1,7,8],[7,10,7,11]]}
[null,{"$f":"(LOOKUP(dms_Model,dms_Model_List,dms_Worksheet_List))","v":"REGULATORY REPORTING STATEMENT"},null,null,null,null,"#25C6FF",null,"Protected (SOCI)"]
[null,{"$f":"INDEX(dms_TradingNameFull_List,MATCH(dms_TradingName,dms_TradingName_List))","v":"AusNet Transmission Group Pty Limited"},null,null,null,null,"#FFCCCC",null,"Confidential"]
[null,{"$f":"CONCATENATE(\"REGULATORY PERIOD FROM \", FRCP_y1,\" TO \",dms_MultiYear_FinalYear_Result)","v":"REGULATORY PERIOD FROM 2027-28 TO 2031-32"},null,null,null,null,"12.5% Grey",null,"Amended"]
[null,"2.16 OPEX SUMMARY",null,null,null,null,"#FFCCCC & \n12.5% Grey",null,"Amended Confidential"]
[]
[null,"Instructions",null,null,null,null,null,null,null,null,"IMPORTANT!"]
[null,{"$f":"CONCATENATE(\"Complete the tables below in accordance with the regulatory information notice.\n\n\",dms_TradingName, \"'s total forecast opex must reconcile to Table 2.16.1. If \",dms_TradingName,\" did not forecast its total opex using a Base Year approach, total forecast opex must reconcile to Table 2.16.2\")","v":"Complete the tables below in accordance with the regulatory information notice.\n\nAusNet (T)'s total forecast opex must reconcile to Table 2.16.1. If AusNet (T) did not forecast its total opex using a Base Year approach, total forecast opex must reconcile to Table 2.16.2"},null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Has \",dms_TradingName,\" used a base-step-trend model to derive its opex forecast? \")","v":"Has AusNet (T) used a base-step-trend model to derive its opex forecast? "},null,"Yes"]
[null,"The total step changes and category specific forecasts in Table 2.16.1 must reconcile (in each year) to the total step changes and category secific forecasts for each year in Tables 2.17.1 and 2.17.5 of worksheet 2.17 Step Changes.\")",null,null,null,null,null,null,null,null,"Yes /  No"]
[null,null,null,null,null,null,null,null,null,null,"Please nominate the base year.",null,"2025-26"]
[]
[null,"2.16.1 - PRESCRIBED TRANSMISSION SERVICES - OPEX BY DRIVER"]
[null,null,"EXPENDITURE"]
[null,null,{"$f":"CONCATENATE(\"Forecast  ($0's. real \",dms_DollarReal,\")\")","v":"Forecast  ($0's. real March 2027)"}]
[null,null,{"$f":"CRCP_y1","v":"2022-23"},{"$f":"CRCP_y2","v":"2023-24"},{"$f":"CRCP_y3","v":"2024-25"},{"$f":"dms_y4","v":"2025-26"},{"$f":"dms_y5","v":"2026-27"},{"$f":"dms_y6","v":"2027-28"},{"$f":"dms_y7","v":"2028-29"},{"$f":"dms_y8","v":"2029-30"},{"$f":"dms_y9","v":"2030-31"},{"$f":"dms_y10","v":"2031-32"}]
[null,"Base year total opex, excluding category specific",null,null,null,124772146.52658163,124772146.52658163,124981880.29600616,124981880.29600616,124981880.29600616,124981880.29600616,124981880.29600616]
[null,"Increment from base year to final year",null,null,null,0,209733.76942453114,0,0,0,0,0]
[null,"Price growth",null,null,null,0,0,812763.05999061465,1825287.2248411106,2870147.7963016536,3824149.4002472386,4774255.5711307414]
[null,"Output growth",null,null,null,0,0,0,0,0,0,0]
[null,"Productivity growth",null,null,null,0,0,-629437.64942058339,-1263422.7614084752,-1893264.7729026638,-2517898.4342859597,-3139283.3286437406]
[null,"Step changes",null,null,null,0,0,16588238.013635609,15319331.704594593,10787515.748830486,12366134.103089547,13199073.4357388]
[null,"Category specific",null,null,null,279373089.73207897,273920041.41515011,285590817.02701223,288619517.60934991,291684279.46452576,294785672.3296361,297924280.35609269]
[null,"Total opex",null,null,null,{"$f":"SUM(F15:F21)","v":404145236.25866061},398901921.71115625,427344260.74722403,429482594.07338333,428430558.53276139,433439937.69469309,437740206.33032465]
[]
[]
[]
[null,"2.16.2 - PRESCRIBED TRANSMISSION SERVICES - OPEX BY CATEGORY"]
[null,null,"EXPENDITURE"]
[null,null,{"$f":"CONCATENATE(\"Forecast  ($0's. real \",dms_DollarReal,\")\")","v":"Forecast  ($0's. real March 2027)"}]
[null,null,{"$f":"CRCP_y1","v":"2022-23"},{"$f":"CRCP_y2","v":"2023-24"},{"$f":"CRCP_y3","v":"2024-25"},{"$f":"CRCP_y4","v":"2025-26"},{"$f":"CRCP_y5","v":"2026-27"},{"$f":"FRCP_y1","v":"2027-28"},{"$f":"FRCP_y2","v":"2028-29"},{"$f":"FRCP_y3","v":"2029-30"},{"$f":"FRCP_y4","v":"2030-31"},{"$f":"FRCP_y5","v":"2031-32"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Total opex",{"$f":"SUM(C30:C59)","v":0},0,0,0,0,0,0,0,0,0]

{"sheet":"2.10 Overheads","index":10,"n_rows":42,"n_cols":10,"rows_kept":42,"cut":false,"hidden":false,"merged":[]}
[null,{"$f":"(LOOKUP(dms_Model,dms_Model_List,dms_Worksheet_List))","v":"REGULATORY REPORTING STATEMENT"},null,null,null,"#25C6FF",null,"Protected (SOCI)"]
[null,{"$f":"INDEX(dms_TradingNameFull_List,MATCH(dms_TradingName,dms_TradingName_List))","v":"AusNet Transmission Group Pty Limited"},null,null,null,"#FFCCCC",null,"Confidential"]
[null,{"$f":"CONCATENATE(\"REGULATORY PERIOD FROM \", FRCP_y1,\" TO \",dms_MultiYear_FinalYear_Result)","v":"REGULATORY PERIOD FROM 2027-28 TO 2031-32"},null,null,null,"12.5% Grey",null,"Amended"]
[null,"2.10 OVERHEADS",null,null,null,"#FFCCCC & \n12.5% Grey",null,"Amended Confidential"]
[]
[null,"2.10.1 - NETWORK OVERHEADS EXPENDITURE"]
[null,null,null,"EXPENDITURE"]
[null,null,null,{"$f":"CONCATENATE(\"Forecast  ($0's. real \",dms_DollarReal,\")\")","v":"Forecast  ($0's. real March 2027)"}]
[null,null,null,{"$f":"dms_y4","v":"2025-26"},{"$f":"dms_y5","v":"2026-27"},{"$f":"dms_y6","v":"2027-28"},{"$f":"dms_y7","v":"2028-29"},{"$f":"dms_y8","v":"2029-30"},{"$f":"dms_y9","v":"2030-31"},{"$f":"dms_y10","v":"2031-32"}]
[null,"OPEX"]
[null,"Prescribed Transmission Services","Total  ",14467029.524222633,14464043.594490996,14911511.714709286,14956608.828474818,15006051.915184297,15045291.046428813,15084453.137347903]
[null,"CAPEX"]
[null,"Prescribed Transmission Services","Total  ",11017887.755175,{"$f":"SUM('[2]RY27 Template 2.4 - Consol'!$E$187:$E$194)","v":15284939.250000002},{"$f":"'[1]Output| RIN'!C18*10^6","v":16832334.537573423},{"$f":"'[1]Output| RIN'!D18*10^6","v":17210775.046267167},{"$f":"'[1]Output| RIN'!E18*10^6","v":14335307.821093703},{"$f":"'[1]Output| RIN'!F18*10^6","v":13167459.132150291},{"$f":"'[1]Output| RIN'!G18*10^6","v":11918555.592935996}]
[null,"OTHER TRANSMISSION SERVICES"]
[null,"Negotiated Services","Total  ",0,0,0,0,0,0,0]
[null,"Non-regulated Services","Total  ",0,0,0,0,0,0,0]
[]
[]
[null,"2.10.2 - CORPORATE OVERHEADS EXPENDITURE"]
[null,null,null,"EXPENDITURE"]
[null,null,null,{"$f":"CONCATENATE(\"Forecast  ($0's. real \",dms_DollarReal,\")\")","v":"Forecast  ($0's. real March 2027)"}]
[null,null,null,{"$f":"dms_y4","v":"2025-26"},{"$f":"dms_y5","v":"2026-27"},{"$f":"dms_y6","v":"2027-28"},{"$f":"dms_y7","v":"2028-29"},{"$f":"dms_y8","v":"2029-30"},{"$f":"dms_y9","v":"2030-31"},{"$f":"dms_y10","v":"2031-32"}]
[null,"OPEX"]
[null,"Prescribed Transmission Services","Total",305077295.09714991,299850796.66204107,302825788.85456192,305801223.70450711,308814469.19202304,311840704.61313593,314897746.23833621]
[null,"CAPEX"]
[null,"Prescribed Transmission Services","Total",1295381.6041250001,{"$f":"SUM('[2]RY27 Template 2.4 - Consol'!$E$198:$E$199)","v":2760934.25},{"$f":"'[1]Output| RIN'!C19*10^6","v":1958885.5099453868},{"$f":"'[1]Output| RIN'!D19*10^6","v":2109890.526555263},{"$f":"'[1]Output| RIN'!E19*10^6","v":1881259.4438072159},{"$f":"'[1]Output| RIN'!F19*10^6","v":2028387.8965723692},{"$f":"'[1]Output| RIN'!G19*10^6","v":2011600.8372176383}]
[null,"OTHER TRANSMISSION SERVICES"]
[null,"Negotiated Services","Total",0,0,0,0,0,0,0]
[null,"Non-regulated Services","Total",0,0,0,0,0,0,0]
[]
[]
[null,"2.10.3 - CORPORATE OVERHEADS EXPENDITURE - EASEMENT LEVY ONLY"]
[null,null,null,"EXPENDITURE"]
[null,null,null,{"$f":"CONCATENATE(\"Forecast  ($0's. real \",dms_DollarReal,\")\")","v":"Forecast  ($0's. real March 2027)"}]
[null,null,null,{"$f":"dms_y4","v":"2025-26"},{"$f":"dms_y5","v":"2026-27"},{"$f":"dms_y6","v":"2027-28"},{"$f":"dms_y7","v":"2028-29"},{"$f":"dms_y8","v":"2029-30"},{"$f":"dms_y9","v":"2030-31"},{"$f":"dms_y10","v":"2031-32"}]
[null,"OPEX"]
[null,"Prescribed Transmission Services","Total",279373089.73207897,273920041.41515011,277063485.65069848,279961007.1716215,282888830.88463771,285847273.68915212,288836655.7986939]
[null,"CAPEX"]
[null,"Prescribed Transmission Services","Total",0,0,0,0,0,0,0]
[null,"OTHER TRANSMISSION SERVICES"]
[null,"Negotiated Services","Total",0,0,0,0,0,0,0]
[null,"Non-regulated Services","Total",0,0,0,0,0,0,0]

{"sheet":"2.17 Step Changes","index":11,"n_rows":69,"n_cols":10,"rows_kept":69,"cut":false,"hidden":false,"merged":[[68,1,68,2],[46,1,46,2],[67,1,67,2],[23,1,23,2],[24,1,24,2]]}
[null,{"$f":"(LOOKUP(dms_Model,dms_Model_List,dms_Worksheet_List))","v":"REGULATORY REPORTING STATEMENT"},null,null,null,"#25C6FF",null,"Protected (SOCI)"]
[null,{"$f":"INDEX(dms_TradingNameFull_List,MATCH(dms_TradingName,dms_TradingName_List))","v":"AusNet Transmission Group Pty Limited"},null,null,null,"#FFCCCC",null,"Confidential"]
[null,{"$f":"CONCATENATE(\"REGULATORY PERIOD FROM \", FRCP_y1,\" TO \",dms_MultiYear_FinalYear_Result)","v":"REGULATORY PERIOD FROM 2027-28 TO 2031-32"},null,null,null,"12.5% Grey",null,"Amended"]
[null,"2.17 STEP CHANGES",null,null,null,"#FFCCCC & \n12.5% Grey",null,"Amended Confidential"]
[]
[null,"2.17.1 - STEP CHANGES FOR PRESCRIBED TRANSMISSION SERVICES - FORECAST OPEX "]
[null,null,null,"EXPENDITURE"]
[null,null,null,{"$f":"CONCATENATE(\"Forecast  ($0's. real \",dms_DollarReal,\")\")","v":"Forecast  ($0's. real March 2027)"}]
[null,"Step change","Description",{"$f":"dms_y4","v":"2025-26"},{"$f":"dms_y5","v":"2026-27"},{"$f":"dms_y6","v":"2027-28"},{"$f":"dms_y7","v":"2028-29"},{"$f":"dms_y8","v":"2029-30"},{"$f":"dms_y9","v":"2030-31"},{"$f":"dms_y10","v":"2031-32"}]
[null,"Delegated Responsibilites (linked to VicGrid Reforms)"]
[null,"Digital (inc SaaS, etc)","Opex associated with new capex initiatives",null,null,15168274.770357357,14044802.313048752,9605535.1720234491,11223817.304027714,12056756.636676967]
[null,"Landholder Engagement","Customer driven initiative",null,null,1419963.2432782515,1274529.3915458419,1181980.5768070361,1142316.7990618334,1142316.7990618334]
[null,"Insurance"]
[null,"Network Operations - Deliverability"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Total",null,{"$f":"SUM(D10:D23)","v":0},{"$f":"SUM(E10:E23)","v":0},16588238.013635609,15319331.704594593,10787515.748830486,12366134.103089547,13199073.4357388]
[null,"Check",null,null,null,{"$f":"IF(ROUND(F$24,0)-ROUND('2.16 Opex Summary'!C$20,0)=0,\"OK\",\"Error\")","v":"Error"},{"$f":"IF(ROUND(G$24,0)-ROUND('2.16 Opex Summary'!D$20,0)=0,\"OK\",\"Error\")","v":"Error"},{"$f":"IF(ROUND(H$24,0)-ROUND('2.16 Opex Summary'!E$20,0)=0,\"OK\",\"Error\")","v":"Error"},{"$f":"IF(ROUND(I$24,0)-ROUND('2.16 Opex Summary'!F$20,0)=0,\"OK\",\"Error\")","v":"Error"},{"$f":"IF(ROUND(J$24,0)-ROUND('2.16 Opex Summary'!G$20,0)=0,\"OK\",\"Error\")","v":"Error"}]
[]
[]
[null,"2.17.2 - STEP CHANGES FOR PRESCRIBED TRANSMISSION SERVICES - FORECAST CAPEX"]
[null,null,null,"EXPENDITURE"]
[null,null,null,{"$f":"CONCATENATE(\"Forecast  ($0's. real \",dms_DollarReal,\")\")","v":"Forecast  ($0's. real March 2027)"}]
[null,"Step change","Description",{"$f":"dms_y4","v":"2025-26"},{"$f":"dms_y5","v":"2026-27"},{"$f":"dms_y6","v":"2027-28"},{"$f":"dms_y7","v":"2028-29"},{"$f":"dms_y8","v":"2029-30"},{"$f":"dms_y9","v":"2030-31"},{"$f":"dms_y10","v":"2031-32"}]
[null,null,null,"Nil","Nil","Nil","Nil","Nil","Nil","Nil"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Total",null,{"$f":"SUM(D32:D46)","v":0},0,0,0,0,0,0]
[]
[]
[null,"2.17.5 - CATEGORY SPECIFIC OPEX FOR PRESCRIBED TRANSMISSION SERVICES"]
[null,null,null,"EXPENDITURE"]
[null,null,null,{"$f":"CONCATENATE(\"Forecast  ($0's. real \",dms_DollarReal,\")\")","v":"Forecast  ($0's. real March 2027)"}]
[null,"Category","Description",{"$f":"dms_y4","v":"2025-26"},{"$f":"dms_y5","v":"2026-27"},{"$f":"dms_y6","v":"2027-28"},{"$f":"dms_y7","v":"2028-29"},{"$f":"dms_y8","v":"2029-30"},{"$f":"dms_y9","v":"2030-31"},{"$f":"dms_y10","v":"2031-32"}]
[null,"Easement land tax",null,279373089.73207897,273920041.41515011,277063485.65069848,279961007.1716215,282888830.88463771,285847273.68915212,288836655.7986939]
[null,"AEMO participant fees",null,0,0,4119056.90625,4250235.9676646339,4387174.1098243017,4530124.1704202471,4679350.0873350389]
[null,"Group 3 roll in",null,0,0,4408274.4700637581,4408274.4700637581,4408274.4700637581,4408274.4700637581,4408274.4700637581]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Total",null,{"$f":"SUM(D54:D67)","v":279373089.73207897},{"$f":"SUM(E54:E67)","v":273920041.41515011},285590817.02701223,288619517.60934991,291684279.46452576,294785672.3296361,297924280.35609269]
[null,"Check",null,null,null,{"$f":"IF(ROUND(F$68,0)-ROUND('2.16 Opex Summary'!C$21,0)=0,\"OK\",\"Error\")","v":"Error"},{"$f":"IF(ROUND(G$68,0)-ROUND('2.16 Opex Summary'!D$21,0)=0,\"OK\",\"Error\")","v":"Error"},{"$f":"IF(ROUND(H$68,0)-ROUND('2.16 Opex Summary'!E$21,0)=0,\"OK\",\"Error\")","v":"Error"},{"$f":"IF(ROUND(I$68,0)-ROUND('2.16 Opex Summary'!F$21,0)=0,\"OK\",\"Error\")","v":"Error"},{"$f":"IF(ROUND(J$68,0)-ROUND('2.16 Opex Summary'!G$21,0)=0,\"OK\",\"Error\")","v":"Error"}]

{"sheet":"3.1 Revenue","index":12,"n_rows":44,"n_cols":9,"rows_kept":44,"cut":false,"hidden":false,"merged":[]}
[null,{"$f":"(LOOKUP(dms_Model,dms_Model_List,dms_Worksheet_List))","v":"REGULATORY REPORTING STATEMENT"},null,null,null,"#25C6FF",null,"Protected (SOCI)"]
[null,{"$f":"INDEX(dms_TradingNameFull_List,MATCH(dms_TradingName,dms_TradingName_List))","v":"AusNet Transmission Group Pty Limited"},null,null,null,"#FFCCCC",null,"Confidential"]
[null,{"$f":"CONCATENATE(\"REGULATORY PERIOD FROM \", FRCP_y1,\" TO \",dms_MultiYear_FinalYear_Result)","v":"REGULATORY PERIOD FROM 2027-28 TO 2031-32"},null,null,null,"12.5% Grey",null,"Amended"]
[null,"3.1 REVENUE",null,null,null,"#FFCCCC & \n12.5% Grey",null,"Amended Confidential"]
[]
[]
[null,"3.1.1 - REVENUE GROUPING BY CHARGEABLE QUANTITY"]
[null,null,"REVENUE"]
[null,null,{"$f":"CONCATENATE(\"Forecast  ($0's. real \",dms_DollarReal,\")\")","v":"Forecast  ($0's. real March 2027)"}]
[null,"REVENUE FROM PRESCRIBED SERVICES",{"$f":"dms_y4","v":"2025-26"},{"$f":"dms_y5","v":"2026-27"},{"$f":"dms_y6","v":"2027-28"},{"$f":"dms_y7","v":"2028-29"},{"$f":"dms_y8","v":"2029-30"},{"$f":"dms_y9","v":"2030-31"},{"$f":"dms_y10","v":"2031-32"}]
[null,"Prescribed entry services",8075488.7814962156,8634004.544665603,10402348.882492455,10767599.947626816,11145675.841277197,11537026.873496508,11942119.165788351]
[null,"Prescribed exit services",74548304.512611553,79824973.910119757,96174055.023164675,99550953.494107395,103046422.85488427,106664626.40979272,110409873.64658801]
[null,"Prescribed common transmission services",178799570.83065599,179151430.24730057,215843722.41051555,223422505.85679007,231267398.30954421,239387743.48519784,247793213.18014711]
[null,"Locational TUOS services",188492002.87115374,201589616.59380856,242877509.74051687,251405513.38008037,260232955.39149687,269370349.76401019,278828579.65788645]
[null,"Non-locational TUOS services",188492002.87115374,201589616.59380856,242877509.74051687,251405513.38008037,260232955.39149687,269370349.76401019,278828579.65788645]
[null,"Net revenue from modified load export charges"]
[null,"System strength services"]
[null,"Inter-regional settlements residues; proceeds from auctions"]
[null,"Intra-regional settlements residues"]
["TREV01","Total",{"$f":"SUM(C11:C19)","v":638407369.86707127},670789641.88970304,808175145.7972064,836552086.05868495,865925407.78869939,896330096.29650748,927802365.30829644]
[]
[]
[]
[null,"3.1.2 - REVENUE GROUPING BY TYPE OF CONNECTED EQUIPMENT"]
[null,null,"REVENUE"]
[null,null,{"$f":"CONCATENATE(\"Forecast  ($0's. real \",dms_DollarReal,\")\")","v":"Forecast  ($0's. real March 2027)"}]
[null,null,{"$f":"dms_y4","v":"2025-26"},{"$f":"dms_y5","v":"2026-27"},{"$f":"dms_y6","v":"2027-28"},{"$f":"dms_y7","v":"2028-29"},{"$f":"dms_y8","v":"2029-30"},{"$f":"dms_y9","v":"2030-31"},{"$f":"dms_y10","v":"2031-32"}]
["TREV0201","From other connected transmission networks"]
["TREV0202","From distribution networks",74350166.132456854,79608238.119475603,95912929.227140367,99280658.953964889,102766637.6343385,106375017.26861446,110110095.64369564]
["TREV0203","From directly connected end–users",198138.38015471876,216735.79064414438,261125.79602430051,270294.54014251172,279785.2205457823,289609.14117828407,299778.0028923963]
["TREV0204","From generators",8075488.7814962156,8634004.544665603,10402348.882492455,10767599.947626816,11145675.841277197,11537026.873496508,11942119.165788351]
["TREV0205","Other revenue",555783576.57296348,582330663.43491769,701598741.89154923,726233532.61695075,751733309.09253788,778128443.01321816,805450372.49591994]
["TREV02","Total",{"$f":"SUM(C28:C32)","v":638407369.86707127},670789641.88970304,808175145.7972064,836552086.05868495,865925407.78869939,896330096.29650736,927802365.30829632]
[]
[]
[null,"3.1.3 - REVENUE (penalties) ALLOWED (deducted) THROUGH INCENTIVE SCHEMES"]
[null,null,"REVENUE"]
[null,null,{"$f":"CONCATENATE(\"Forecast  ($0's. real \",dms_DollarReal,\")\")","v":"Forecast  ($0's. real March 2027)"}]
[null,null,{"$f":"dms_y4","v":"2025-26"},{"$f":"dms_y5","v":"2026-27"},{"$f":"dms_y6","v":"2027-28"},{"$f":"dms_y7","v":"2028-29"},{"$f":"dms_y8","v":"2029-30"},{"$f":"dms_y9","v":"2030-31"},{"$f":"dms_y10","v":"2031-32"}]
["TREV0301","EBSS",{"$f":"'[3]PTRM input'!J453*10^6","v":11661575.209095333},{"$f":"'[3]PTRM input'!K453*10^6","v":0},{"$f":"-'[4]PTRM input'!G453*10^6","v":850919.70065492718},{"$f":"-'[4]PTRM input'!H453*10^6","v":37450646.628942691},{"$f":"-'[4]PTRM input'!I453*10^6","v":33048932.293450732},{"$f":"-'[4]PTRM input'!J453*10^6","v":21027394.849523716},{"$f":"-'[4]PTRM input'!K453*10^6","v":-1.4210854715202004E-8}]
["TREV0302","STPIS",null,null,0,0,0,0,0]
["TREV0312","CESS",{"$f":"'[3]PTRM input'!J454*10^6","v":1649105.2062794364},{"$f":"'[3]PTRM input'!K454*10^6","v":1649105.2062794364},{"$f":"-'[4]PTRM input'!G454*10^6","v":6893764.3290015692},{"$f":"-'[4]PTRM input'!H454*10^6","v":6893764.3290015692},{"$f":"-'[4]PTRM input'!I454*10^6","v":6893764.3290015692},{"$f":"-'[4]PTRM input'!J454*10^6","v":6893764.3290015692},{"$f":"-'[4]PTRM input'!K454*10^6","v":6893764.3290015692}]
["TREV0303","Other",0,0,0,0,0,0,0]
["TREV03","Total",{"$f":"SUM(C40:C43)","v":13310680.415374769},1649105.2062794364,7744684.0296564959,44344410.957944259,39942696.622452304,27921159.178525284,6893764.3290015552]

{"sheet":"3.2 Operating expenditure","index":13,"n_rows":94,"n_cols":9,"rows_kept":94,"cut":false,"hidden":false,"merged":[]}
[null,{"$f":"(LOOKUP(dms_Model,dms_Model_List,dms_Worksheet_List))","v":"REGULATORY REPORTING STATEMENT"},null,null,null,"#25C6FF",null,"Protected (SOCI)"]
[null,{"$f":"INDEX(dms_TradingNameFull_List,MATCH(dms_TradingName,dms_TradingName_List))","v":"AusNet Transmission Group Pty Limited"},null,null,null,"#FFCCCC",null,"Confidential"]
[null,{"$f":"CONCATENATE(\"REGULATORY PERIOD FROM \", FRCP_y1,\" TO \",dms_MultiYear_FinalYear_Result)","v":"REGULATORY PERIOD FROM 2027-28 TO 2031-32"},null,null,null,"12.5% Grey",null,"Amended"]
[null,"3.2 OPERATING EXPENDITURE",null,null,null,"#FFCCCC & \n12.5% Grey",null,"Amended Confidential"]
[]
[]
[null,"3.2.1 - OPEX CATEGORIES"]
[null,null,"EXPENDITURE"]
[null,null,{"$f":"CONCATENATE(\"Forecast  ($0's. real \",dms_DollarReal,\")\")","v":"Forecast  ($0's. real March 2027)"}]
[null,null,{"$f":"dms_y4","v":"2025-26"},{"$f":"dms_y5","v":"2026-27"},{"$f":"dms_y6","v":"2027-28"},{"$f":"dms_y7","v":"2028-29"},{"$f":"dms_y8","v":"2029-30"},{"$f":"dms_y9","v":"2030-31"},{"$f":"dms_y10","v":"2031-32"}]
[null,"OPEX CATEGORIES AND COST ALLOCATIONS - approved CAM"]
[null,"Network Maintenance",40607318.338512383,39620801.288640223,45107375.35548304,45230462.271008454,45365410.974572197,45472509.261568911,45579397.27666048]
[null,"Network Operations",15427242.337609846,15451804.120980022,16882074.950534523,16783403.400576632,16742123.333398771,16743147.571879311,16783755.703104757]
[null,"Insurance ",8713540.5874434225,8904460.713750001,8733235.3365776855,8759647.3942583501,8788604.7609064784,8811585.96992925,8834522.0586915631]
[null,"Other Taxes and Charges",20486886.983214311,20801626.890933562,24652249.30293284,24845527.213290427,25050548.621018007,25247531.072610743,25450683.295783591]
[null,"OHS",413677.10117839242,363579.72577872645,414612.11337562004,415866.03115425975,417240.78799076541,418331.82553568878,419420.72098712414]
[null,"Finance",6187524.5744393161,6211454.6163428714,6201509.9048607145,6220265.2264570966,6240827.9834613539,6257147.0439112056,6273434.0642600693]
[null,"HR ",4070730.9295614897,4158311.4352737293,4079931.7846727092,4092270.7849946888,4105798.8849524776,4116535.0854015262,4127250.2068829667]
[null,"IT ",19663694.972231571,19987353.510279324,18880713.097789183,20813464.069901485,23506594.157573268,25161225.989089087,26030443.653903302]
[null,"IT - SaaS",7001350.9975549653,7116591.1409475394,17118217.842034135,14124992.885810181,7061665.2430080185,7080130.7002009833,7098559.9031552272]
[null,"Building Services",1873606.531386981,1873129.5403963765,1877841.3438884753,1883520.5282890364,1889747.0111680951,1894688.4862082505,1899620.2593810833]
[null,"Strategy and Business Development",714961.17742172652,667417.64901449694,716577.16588115355,718744.32120314881,721120.32355787617,723005.97177361662,724887.91779342212]
[null,"Other Corporate Services",5603770.9950265931,5625531.1067311121,5616436.8984954935,5633422.7748180488,5652045.566516405,5666825.0274324445,5681575.4710271908]
[null,"Non-Regulated Services",0,0,0,0,0,0,0]
[null,"Easement tax",279373089.73207897,273920041.41515011,277063485.65069848,279961007.1716215,282888830.88463771,285847273.68915212,288836655.7986939]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Total ",{"$f":"SUM(C12:C46)","v":410137395.25766003},404702103.15421808,427344260.74722409,429482594.07338333,428430558.53276145,433439937.69469315,437740206.33032465]
[]
[]
[]
[null,"Instructions\nTable 3.2.3 must be completed if there are any proposed changes to the CAM reported in response to Schedule 1, paragraph 1.3."]
[]
[null,"3.2.3 - OPEX CATEGORIES - Revised CAM"]
[null,null,"EXPENDITURE"]
[null,null,{"$f":"CONCATENATE(\"Forecast  ($0's. real \",dms_DollarReal,\")\")","v":"Forecast  ($0's. real March 2027)"}]
[null,null,{"$f":"dms_y4","v":"2025-26"},{"$f":"dms_y5","v":"2026-27"},{"$f":"dms_y6","v":"2027-28"},{"$f":"dms_y7","v":"2028-29"},{"$f":"dms_y8","v":"2029-30"},{"$f":"dms_y9","v":"2030-31"},{"$f":"dms_y10","v":"2031-32"}]
[null,"OPEX CATEGORIES AND COST ALLOCATIONS - revised CAM"]
[null,null,"Not required","Not required","Not required","Not required","Not required","Not required","Not required"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Total",{"$f":"SUM(C58:C93)","v":0},0,0,0,0,0,0]

{"sheet":"3.3 Assets (RAB)","index":14,"n_rows":93,"n_cols":9,"rows_kept":93,"cut":false,"hidden":false,"merged":[]}
[null,{"$f":"(LOOKUP(dms_Model,dms_Model_List,dms_Worksheet_List))","v":"REGULATORY REPORTING STATEMENT"},null,null,null,"#25C6FF",null,"Protected (SOCI)"]
[null,{"$f":"INDEX(dms_TradingNameFull_List,MATCH(dms_TradingName,dms_TradingName_List))","v":"AusNet Transmission Group Pty Limited"},null,null,null,"#FFCCCC",null,"Confidential"]
[null,{"$f":"CONCATENATE(\"REGULATORY PERIOD FROM \", FRCP_y1,\" TO \",dms_MultiYear_FinalYear_Result)","v":"REGULATORY PERIOD FROM 2027-28 TO 2031-32"},null,null,null,"12.5% Grey",null,"Amended"]
[null,"3.3 ASSETS",null,null,null,"#FFCCCC & \n12.5% Grey",null,"Amended Confidential"]
[]
[null,"3.3.1 - Benchmarking ASSET BASE VALUES"]
[null,null,"VALUES"]
[null,null,{"$f":"CONCATENATE(\"Forecast  ($0's. real \",dms_DollarReal,\")\")","v":"Forecast  ($0's. real March 2027)"}]
[null,null,{"$f":"dms_y4","v":"2025-26"},{"$f":"dms_y5","v":"2026-27"},{"$f":"dms_y6","v":"2027-28"},{"$f":"dms_y7","v":"2028-29"},{"$f":"dms_y8","v":"2029-30"},{"$f":"dms_y9","v":"2030-31"},{"$f":"dms_y10","v":"2031-32"}]
[null,"For total asset base:"]
["TRAB0101","Opening value",{"$f":"C25+C33+C41+C49+C57+C65","v":3852915334.3231697},{"$f":"C17","v":4016151326.2405605},{"$f":"E25+E33+E41+E49+E57+E65","v":4542142765.6533327},4898811156.4599161,5317084814.5756197,5387676225.7743511,5651707629.5094976]
["TRAB0102","Inflation addition",{"$f":"C26+C34+C42+C50+C58+C66","v":98249341.025240853},0,0,0,0,0,0]
["TRAB0103","Actual straight line depreciation",217791652.37580845,224558919.04922581,227129802.02269161,251819195.9726963,273773307.97164714,283867002.02378041,303739438.39173031]
["TRAB0104","Gross capex",276446998.69500005,446112904,574746014.40972328,659535809.30224979,339099656.30898386,538920160.89687538,364794137.67541933]
["TRAB0106","Disposals ",375321.71642594377,385492.5188874763,444589.78188288712,466819.27097703144,490160.23452588305,514668.24625217717,540401.65856478619]
["TRAB0108","Capex timing adjustment",6706626.2893838594,11928532.719934514,9496768.2014350817,11023864.057127297,5755223.0959204584,9492913.1083042473,6730462.1141343489]
["TRAB0107","Closing value ",{"$f":"(C11+C12+C14+C16)-C13-C15","v":4016151326.2405605},{"$f":"(D11+D12+D14+D16)-D13-D15","v":4249248351.3923817},{"$f":"(E11+E12+E14+E16)-E13-E15","v":4898811156.4599161},{"$f":"(F11+F12+F14+F16)-F13-F15","v":5317084814.5756197},{"$f":"(G11+G12+G14+G16)-G13-G15","v":5387676225.7743511},{"$f":"(H11+H12+H14+H16)-H13-H15","v":5651707629.5094976},{"$f":"(I11+I12+I14+I16)-I13-I15","v":5718952389.2487574}]
[]
[]
[null,"3.3.2 - Benchmarking ASSET VALUE ROLL FORWARD"]
[null,null,"VALUES"]
[null,null,{"$f":"CONCATENATE(\"Forecast  ($0's. real \",dms_DollarReal,\")\")","v":"Forecast  ($0's. real March 2027)"}]
[null,null,{"$f":"dms_y4","v":"2025-26"},{"$f":"dms_y5","v":"2026-27"},{"$f":"dms_y6","v":"2027-28"},{"$f":"dms_y7","v":"2028-29"},{"$f":"dms_y8","v":"2029-30"},{"$f":"dms_y9","v":"2030-31"},{"$f":"dms_y10","v":"2031-32"}]
[null,"For overhead assets:"]
["TRAB0201","Opening value",1154092674.248286,{"$f":"C31","v":1171879681.9117124},{"$f":"('[5]PTRM input summary'!$K$11+'[5]PTRM input summary'!$K$26)*10^6-E33","v":1284673873.1006422},1393709553.8948925,1499061215.7315514,1492557750.9512618,1494868479.338624]
["TRAB0202","Inflation addition",29429363.193331294,0]
["TRAB0203","Actual straight line depreciation",75481353.801623434,76058200.755082577,{"$f":"([4]Assets!G180+[4]Assets!G323)*10^6-E35","v":80826018.872840166},{"$f":"([4]Assets!H180+[4]Assets!H323)*10^6-F35","v":84534530.814774886},{"$f":"([4]Assets!I180+[4]Assets!I323)*10^6-G35","v":88219536.548400968},{"$f":"([4]Assets!J180+[4]Assets!J323)*10^6-H35","v":90025002.521899104},{"$f":"([4]Assets!K180+[4]Assets!K323)*10^6-I35","v":92017253.701321557}]
["TRAB0204","Gross capex",62324934.784000002,107609411.99999999,{"$f":"('[4]PTRM input'!G227+'[4]PTRM input'!G238)*10^6","v":186773179.39721677},{"$f":"('[4]PTRM input'!H227+'[4]PTRM input'!H238)*10^6","v":186762327.7104136},{"$f":"('[4]PTRM input'!I227+'[4]PTRM input'!I238)*10^6","v":80350385.339255407},{"$f":"('[4]PTRM input'!J227+'[4]PTRM input'!J238)*10^6","v":90735917.766714811},{"$f":"('[4]PTRM input'!K227+'[4]PTRM input'!K238)*10^6","v":86429305.023867428}]
["TRAB0206","Disposals ",0,0,{"$f":"('[4]PTRM input'!G119+'[4]PTRM input'!G130)*10^6","v":0},{"$f":"('[4]PTRM input'!H119+'[4]PTRM input'!H130)*10^6","v":0},{"$f":"('[4]PTRM input'!I119+'[4]PTRM input'!I130)*10^6","v":0},{"$f":"('[4]PTRM input'!J119+'[4]PTRM input'!J130)*10^6","v":0},{"$f":"('[4]PTRM input'!K119+'[4]PTRM input'!K130)*10^6","v":0}]
["TRAB0208","Capex timing adjustment",1514063.4877186231,2879837.2255131239,{"$f":"(E28-E29)*(1+[4]WACC!G$19)^0.5-(E28-E29)","v":3088520.2698736787},{"$f":"(F28-F29)*(1+[4]WACC!H$19)^0.5-(F28-F29)","v":3123864.9410201609},{"$f":"(G28-G29)*(1+[4]WACC!I$19)^0.5-(G28-G29)","v":1365686.4288558066},{"$f":"(H28-H29)*(1+[4]WACC!J$19)^0.5-(H28-H29)","v":1599813.14254646},{"$f":"(I28-I29)*(1+[4]WACC!K$19)^0.5-(I28-I29)","v":1596988.8720295429}]
["TRAB0207","Closing value ",{"$f":"(C25+C26+C28+C30)-C27-C29","v":1171879681.9117124},{"$f":"(D25+D26+D28+D30)-D27-D29","v":1206310730.382143},1393709553.8948925,1499061215.7315514,1492557750.9512618,1494868479.338624,1490877519.5331993]
[null,"For underground assets:"]
["TRAB0301","Opening value",28367208.640091226,{"$f":"C39","v":27235266.244973052},{"$f":"D39","v":25470246.301457848},23867770.644901671,22420086.809038706,21100667.930802241,19827961.61007626]
["TRAB0302","Inflation addition",723363.82032232627,0]
["TRAB0303","Actual straight line depreciation",1855306.2154405019,1765019.9435152055,{"$f":"([4]Assets!G180+[4]Assets!G323)*10^6*(E33/(E33+E25))","v":1602475.6565561777},{"$f":"([4]Assets!H180+[4]Assets!H323)*10^6*(F33/(F33+F25))","v":1447683.8358629651},{"$f":"([4]Assets!I180+[4]Assets!I323)*10^6*(G33/(G33+G25))","v":1319418.8782364633},{"$f":"([4]Assets!J180+[4]Assets!J323)*10^6*(H33/(H33+H25))","v":1272706.3207259821},{"$f":"([4]Assets!K180+[4]Assets!K323)*10^6*(I33/(I33+I25))","v":1220518.4596986575}]
["TRAB0305","Gross capex",0,0,0,0,0,0,0]
["TRAB0306","Disposals ",0,0,0,0,0,0,0]
["TRAB0308","Capex timing adjustment",0,0,{"$f":"(E36-E37)*(1+[4]WACC!G$19)^0.5-(E36-E37)","v":0},{"$f":"(F36-F37)*(1+[4]WACC!H$19)^0.5-(F36-F37)","v":0},{"$f":"(G36-G37)*(1+[4]WACC!I$19)^0.5-(G36-G37)","v":0},{"$f":"(H36-H37)*(1+[4]WACC!J$19)^0.5-(H36-H37)","v":0},{"$f":"(I36-I37)*(1+[4]WACC!K$19)^0.5-(I36-I37)","v":0}]
["TRAB0307","Closing value ",{"$f":"(C33+C34+C36+C38)-C35-C37","v":27235266.244973052},{"$f":"(D33+D34+D36+D38)-D35-D37","v":25470246.301457848},{"$f":"(E33+E34+E36+E38)-E35-E37","v":23867770.644901671},{"$f":"(F33+F34+F36+F38)-F35-F37","v":22420086.809038706},{"$f":"(G33+G34+G36+G38)-G35-G37","v":21100667.930802241},{"$f":"(H33+H34+H36+H38)-H35-H37","v":19827961.61007626},{"$f":"(I33+I34+I36+I38)-I35-I37","v":18607443.150377601}]
[null,"For switchyards, substations & transformers"]
["TRAB0401","Opening value",2047223858.6056352,{"$f":"C47","v":2170234339.9893217},{"$f":"('[5]PTRM input summary'!$K$8+'[5]PTRM input summary'!$K$9+'[5]PTRM input summary'!$K$10+'[5]PTRM input summary'!$K$12+'[5]PTRM input summary'!$K$19)*10^6","v":2443556033.4475846},{"$f":"E47","v":2608295300.5872784},2884362024.1745939,2967917758.1206708,3198807617.8457479]
["TRAB0402","Inflation addition",52204208.394443698,0]
["TRAB0403","Actual straight line depreciation",68672801.662201732,70970859.335660204,{"$f":"([4]Assets!G141+[4]Assets!G154+[4]Assets!G167+[4]Assets!G193+[4]Assets!G284)*10^6","v":69126717.124953583},{"$f":"([4]Assets!H141+[4]Assets!H154+[4]Assets!H167+[4]Assets!H193+[4]Assets!H284)*10^6","v":74323738.997501329},{"$f":"([4]Assets!I141+[4]Assets!I154+[4]Assets!I167+[4]Assets!I193+[4]Assets!I284)*10^6","v":82124442.373830765},{"$f":"([4]Assets!J141+[4]Assets!J154+[4]Assets!J167+[4]Assets!J193+[4]Assets!J284)*10^6","v":85862002.86688593},{"$f":"([4]Assets!K141+[4]Assets!K154+[4]Assets!K167+[4]Assets!K193+[4]Assets!K284)*10^6","v":92944840.69562766}]
["TRAB0405","Gross capex",136171062.62200001,195847855,{"$f":"('[4]PTRM input'!G224+'[4]PTRM input'!G225+'[4]PTRM input'!G226+'[4]PTRM input'!G228+'[4]PTRM input'!G235)*10^6","v":230127724.69637561},{"$f":"('[4]PTRM input'!H224+'[4]PTRM input'!H225+'[4]PTRM input'!H226+'[4]PTRM input'!H228+'[4]PTRM input'!H235)*10^6","v":344695494.06845731},{"$f":"('[4]PTRM input'!I224+'[4]PTRM input'!I225+'[4]PTRM input'!I226+'[4]PTRM input'!I228+'[4]PTRM input'!I235)*10^6","v":162984094.68978044},{"$f":"('[4]PTRM input'!J224+'[4]PTRM input'!J225+'[4]PTRM input'!J226+'[4]PTRM input'!J228+'[4]PTRM input'!J235)*10^6","v":311340309.9161126},{"$f":"('[4]PTRM input'!K224+'[4]PTRM input'!K225+'[4]PTRM input'!K226+'[4]PTRM input'!K228+'[4]PTRM input'!K235)*10^6","v":169286542.99305543}]
["TRAB0406","Disposals ",0,0,{"$f":"('[4]PTRM input'!G116+'[4]PTRM input'!G117+'[4]PTRM input'!G118+'[4]PTRM input'!G120+'[4]PTRM input'!G127)*10^6","v":66087.670279888611},{"$f":"('[4]PTRM input'!H116+'[4]PTRM input'!H117+'[4]PTRM input'!H118+'[4]PTRM input'!H120+'[4]PTRM input'!H127)*10^6","v":69392.053793883053},{"$f":"('[4]PTRM input'!I116+'[4]PTRM input'!I117+'[4]PTRM input'!I118+'[4]PTRM input'!I120+'[4]PTRM input'!I127)*10^6","v":72861.656483577201},{"$f":"('[4]PTRM input'!J116+'[4]PTRM input'!J117+'[4]PTRM input'!J118+'[4]PTRM input'!J120+'[4]PTRM input'!J127)*10^6","v":76504.73930775607},{"$f":"('[4]PTRM input'!K116+'[4]PTRM input'!K117+'[4]PTRM input'!K118+'[4]PTRM input'!K120+'[4]PTRM input'!K127)*10^6","v":80329.976273143882}]
["TRAB0408","Capex timing adjustment",3308012.0294445064,5241269.6332352106,{"$f":"(E44-E45)*(1+[4]WACC!G$19)^0.5-(E44-E45)","v":3804347.2385522127},{"$f":"(F44-F45)*(1+[4]WACC!H$19)^0.5-(F44-F45)","v":5764360.5701537728},{"$f":"(G44-G45)*(1+[4]WACC!I$19)^0.5-(G44-G45)","v":2768943.2866110206},{"$f":"(H44-H45)*(1+[4]WACC!J$19)^0.5-(H44-H45)","v":5488057.4151589274},{"$f":"(I44-I45)*(1+[4]WACC!K$19)^0.5-(I44-I45)","v":3126490.9418331981}]
["TRAB0407","Closing value ",{"$f":"(C41+C42+C44+C46)-C43-C45","v":2170234339.9893217},{"$f":"(D41+D42+D44+D46)-D43-D45","v":2300352605.2868967},{"$f":"(E41+E42+E44+E46)-E43-E45","v":2608295300.5872784},{"$f":"(F41+F42+F44+F46)-F43-F45","v":2884362024.1745939},{"$f":"(G41+G42+G44+G46)-G43-G45","v":2967917758.1206708},{"$f":"(H41+H42+H44+H46)-H43-H45","v":3198807617.8457479},{"$f":"(I41+I42+I44+I46)-I43-I45","v":3278195481.1087356}]
[null,"For easements:"]
["TRAB0501","Opening value",176014655.6803278,{"$f":"C55","v":180503029.40017617},{"$f":"'[5]PTRM input summary'!$K$20*10^6","v":181295095.35073763},{"$f":"E55","v":181295095.35073763},181295095.35073763,181295095.35073763,181295095.35073763]
["TRAB0502","Inflation addition",4488373.719848359,0]
["TRAB0503","Actual straight line depreciation",0,0,{"$f":"[4]Assets!G297*10^6","v":0},{"$f":"[4]Assets!H297*10^6","v":0},{"$f":"[4]Assets!I297*10^6","v":0},{"$f":"[4]Assets!J297*10^6","v":0},{"$f":"[4]Assets!K297*10^6","v":0}]
["TRAB0505","Gross capex",0,0,{"$f":"'[4]PTRM input'!G236*10^6","v":0},{"$f":"'[4]PTRM input'!H236*10^6","v":0},{"$f":"'[4]PTRM input'!I236*10^6","v":0},{"$f":"'[4]PTRM input'!J236*10^6","v":0},{"$f":"'[4]PTRM input'!K236*10^6","v":0}]
["TRAB0506","Disposals ",0,0,{"$f":"'[4]PTRM input'!G128*10^6","v":0},{"$f":"'[4]PTRM input'!H128*10^6","v":0},{"$f":"'[4]PTRM input'!I128*10^6","v":0},{"$f":"'[4]PTRM input'!J128*10^6","v":0},{"$f":"'[4]PTRM input'!K128*10^6","v":0}]
["TRAB0508","Capex timing adjustment",0,0,{"$f":"(E52-E53)*(1+[4]WACC!G$19)^0.5-(E52-E53)","v":0},{"$f":"(F52-F53)*(1+[4]WACC!H$19)^0.5-(F52-F53)","v":0},{"$f":"(G52-G53)*(1+[4]WACC!I$19)^0.5-(G52-G53)","v":0},{"$f":"(H52-H53)*(1+[4]WACC!J$19)^0.5-(H52-H53)","v":0},{"$f":"(I52-I53)*(1+[4]WACC!K$19)^0.5-(I52-I53)","v":0}]
["TRAB0507","Closing value ",{"$f":"(C49+C50+C52+C54)-C51-C53","v":180503029.40017617},{"$f":"(D49+D50+D52+D54)-D51-D53","v":180503029.40017617},{"$f":"(E49+E50+E52+E54)-E51-E53","v":181295095.35073763},{"$f":"(F49+F50+F52+F54)-F51-F53","v":181295095.35073763},{"$f":"(G49+G50+G52+G54)-G51-G53","v":181295095.35073763},{"$f":"(H49+H50+H52+H54)-H51-H53","v":181295095.35073763},{"$f":"(I49+I50+I52+I54)-I51-I53","v":181295095.35073763}]
[null,"For “other” assets with long lives:"]
["TRAB0601","Opening value",371955529.66973871,{"$f":"C63","v":383169130.05531126},{"$f":"('[5]PTRM input summary'!$K$7+'[5]PTRM input summary'!$K$13+'[5]PTRM input summary'!$K$17+'[5]PTRM input summary'!$K$18+'[5]PTRM input summary'!$K$21+'[5]PTRM input summary'!$K$31+'[5]PTRM input summary'!$K$54)*10^6","v":506243420.93405491},{"$f":"E63","v":543242687.24576032},548943633.76230323,533124291.74580681,545012129.82235622]
["TRAB0602","Inflation addition",9484866.0065783374,0]
["TRAB0603","Actual straight line depreciation",50965030.808657132,51189167.913331926,{"$f":"([4]Assets!G128+[4]Assets!G206+[4]Assets!G258+[4]Assets!G271+[4]Assets!G349+[4]Assets!G739+[4]Assets!G310)*10^6","v":58259432.483586974},{"$f":"([4]Assets!H128+[4]Assets!H206+[4]Assets!H258+[4]Assets!H271+[4]Assets!H349+[4]Assets!H739+[4]Assets!H310)*10^6","v":60107641.933139272},{"$f":"([4]Assets!I128+[4]Assets!I206+[4]Assets!I258+[4]Assets!I271+[4]Assets!I349+[4]Assets!I739+[4]Assets!I310)*10^6","v":61031703.345226027},{"$f":"([4]Assets!J128+[4]Assets!J206+[4]Assets!J258+[4]Assets!J271+[4]Assets!J349+[4]Assets!J739+[4]Assets!J310)*10^6","v":58093964.980360098},{"$f":"([4]Assets!K128+[4]Assets!K206+[4]Assets!K258+[4]Assets!K271+[4]Assets!K349+[4]Assets!K739+[4]Assets!K310)*10^6","v":60309007.853514731}]
["TRAB0605","Gross capex",51444032.139500014,86169442.999999985,{"$f":"('[4]PTRM input'!G223+'[4]PTRM input'!G229+'[4]PTRM input'!G233+'[4]PTRM input'!G234+'[4]PTRM input'!G240+'[4]PTRM input'!G270)*10^6","v":93935405.676513016},{"$f":"('[4]PTRM input'!H223+'[4]PTRM input'!H229+'[4]PTRM input'!H233+'[4]PTRM input'!H234+'[4]PTRM input'!H240+'[4]PTRM input'!H270)*10^6","v":64963570.222517744},{"$f":"('[4]PTRM input'!I223+'[4]PTRM input'!I229+'[4]PTRM input'!I233+'[4]PTRM input'!I234+'[4]PTRM input'!I240+'[4]PTRM input'!I270)*10^6","v":44706242.074947529},{"$f":"('[4]PTRM input'!J223+'[4]PTRM input'!J229+'[4]PTRM input'!J233+'[4]PTRM input'!J234+'[4]PTRM input'!J240+'[4]PTRM input'!J270)*10^6","v":69031265.875780165},{"$f":"('[4]PTRM input'!K223+'[4]PTRM input'!K229+'[4]PTRM input'!K233+'[4]PTRM input'!K234+'[4]PTRM input'!K240+'[4]PTRM input'!K270)*10^6","v":55858145.957365751}]
["TRAB0606","Disposals ",0,0,{"$f":"('[4]PTRM input'!G115+'[4]PTRM input'!G121+'[4]PTRM input'!G125+'[4]PTRM input'!G126+'[4]PTRM input'!G132+'[4]PTRM input'!G162+'[4]PTRM input'!G129)*10^6","v":226300.20429173985},{"$f":"('[4]PTRM input'!H115+'[4]PTRM input'!H121+'[4]PTRM input'!H125+'[4]PTRM input'!H126+'[4]PTRM input'!H132+'[4]PTRM input'!H162+'[4]PTRM input'!H129)*10^6","v":237615.21450632683},{"$f":"('[4]PTRM input'!I115+'[4]PTRM input'!I121+'[4]PTRM input'!I125+'[4]PTRM input'!I126+'[4]PTRM input'!I132+'[4]PTRM input'!I162+'[4]PTRM input'!I129)*10^6","v":249495.97523164318},{"$f":"('[4]PTRM input'!J115+'[4]PTRM input'!J121+'[4]PTRM input'!J125+'[4]PTRM input'!J126+'[4]PTRM input'!J132+'[4]PTRM input'!J162+'[4]PTRM input'!J129)*10^6","v":261970.77399322533},{"$f":"('[4]PTRM input'!K115+'[4]PTRM input'!K121+'[4]PTRM input'!K125+'[4]PTRM input'!K126+'[4]PTRM input'!K132+'[4]PTRM input'!K162+'[4]PTRM input'!K129)*10^6","v":275069.31269288663}]
["TRAB0608","Capex timing adjustment",1249733.0481513161,2306061.9423618005,{"$f":"(E60-E61)*(1+[4]WACC!G$19)^0.5-(E60-E61)","v":1549593.3230710924},{"$f":"(F60-F61)*(1+[4]WACC!H$19)^0.5-(F60-F61)","v":1082633.4416707978},{"$f":"(G60-G61)*(1+[4]WACC!I$19)^0.5-(G60-G61)","v":755615.22901382297},{"$f":"(H60-H61)*(1+[4]WACC!J$19)^0.5-(H60-H61)","v":1212507.9551226199},{"$f":"(I60-I61)*(1+[4]WACC!K$19)^0.5-(I60-I61)","v":1027030.7605758831}]
["TRAB0607","Closing value ",{"$f":"(C57+C58+C60+C62)-C59-C61","v":383169130.05531126},{"$f":"(D57+D58+D60+D62)-D59-D61","v":420455467.08434111},{"$f":"(E57+E58+E60+E62)-E59-E61","v":543242687.24576032},{"$f":"(F57+F58+F60+F62)-F59-F61","v":548943633.76230323},{"$f":"(G57+G58+G60+G62)-G59-G61","v":533124291.74580681},{"$f":"(H57+H58+H60+H62)-H59-H61","v":545012129.82235622},{"$f":"(I57+I58+I60+I62)-I59-I61","v":541313229.37409019}]
[null,"For “other” assets with short lives:"]
["TRAB0701","Opening value",75261407.479090929,{"$f":"C71","v":83129878.639065608},{"$f":"('[5]PTRM input summary'!$K$14+'[5]PTRM input summary'!$K$15+'[5]PTRM input summary'!$K$16+'[5]PTRM input summary'!$K$30+'[5]PTRM input summary'!$K$32+'[5]PTRM input summary'!$K$33+'[5]PTRM input summary'!$K$55)*10^6","v":100904096.51885536},{"$f":"E71","v":148400748.73634529},181002758.74739429,191680661.67507103,211896345.54195455]
["TRAB0702","Inflation addition",1919165.8907168189,0]
["TRAB0703","Actual straight line depreciation",20817159.887885623,24575671.101635866,{"$f":"([4]Assets!G219+[4]Assets!G336+[4]Assets!G362+[4]Assets!G375+[4]Assets!G232+[4]Assets!G245+[4]Assets!G388+[4]Assets!G401+[4]Assets!G752)*10^6","v":17315157.88475471},{"$f":"([4]Assets!H219+[4]Assets!H336+[4]Assets!H362+[4]Assets!H375+[4]Assets!H232+[4]Assets!H245+[4]Assets!H388+[4]Assets!H401+[4]Assets!H752)*10^6","v":31405600.391417876},{"$f":"([4]Assets!I219+[4]Assets!I336+[4]Assets!I362+[4]Assets!I375+[4]Assets!I232+[4]Assets!I245+[4]Assets!I388+[4]Assets!I401+[4]Assets!I752)*10^6","v":41078206.825952895},{"$f":"([4]Assets!J219+[4]Assets!J336+[4]Assets!J362+[4]Assets!J375+[4]Assets!J232+[4]Assets!J245+[4]Assets!J388+[4]Assets!J401+[4]Assets!J752)*10^6","v":48613325.333909288},{"$f":"([4]Assets!K219+[4]Assets!K336+[4]Assets!K362+[4]Assets!K375+[4]Assets!K232+[4]Assets!K245+[4]Assets!K388+[4]Assets!K401+[4]Assets!K752)*10^6","v":57247817.681567691}]
["TRAB0705","Gross capex",26506969.149500001,56486194,{"$f":"('[4]PTRM input'!G230+'[4]PTRM input'!G231+'[4]PTRM input'!G232+'[4]PTRM input'!G239+'[4]PTRM input'!G243+'[4]PTRM input'!G244+'[4]PTRM input'!G271)*10^6","v":63909704.639617801},{"$f":"('[4]PTRM input'!H230+'[4]PTRM input'!H231+'[4]PTRM input'!H232+'[4]PTRM input'!H239+'[4]PTRM input'!H243+'[4]PTRM input'!H244+'[4]PTRM input'!H271)*10^6","v":63114417.30086112},{"$f":"('[4]PTRM input'!I230+'[4]PTRM input'!I231+'[4]PTRM input'!I232+'[4]PTRM input'!I239+'[4]PTRM input'!I243+'[4]PTRM input'!I244+'[4]PTRM input'!I271)*10^6","v":51058934.205000468},{"$f":"('[4]PTRM input'!J230+'[4]PTRM input'!J231+'[4]PTRM input'!J232+'[4]PTRM input'!J239+'[4]PTRM input'!J243+'[4]PTRM input'!J244+'[4]PTRM input'!J271)*10^6","v":67812667.338267773},{"$f":"('[4]PTRM input'!K230+'[4]PTRM input'!K231+'[4]PTRM input'!K232+'[4]PTRM input'!K239+'[4]PTRM input'!K243+'[4]PTRM input'!K244+'[4]PTRM input'!K271)*10^6","v":53220143.701130725}]
["TRAB0706","Disposals ",375321.71642594377,385492.5188874763,{"$f":"('[4]PTRM input'!G122+'[4]PTRM input'!G131+'[4]PTRM input'!G123+'[4]PTRM input'!G163+'[4]PTRM input'!G124)*10^6","v":152201.90731125866},{"$f":"('[4]PTRM input'!H122+'[4]PTRM input'!H131+'[4]PTRM input'!H123+'[4]PTRM input'!H163+'[4]PTRM input'!H124)*10^6","v":159812.00267682158},{"$f":"('[4]PTRM input'!I122+'[4]PTRM input'!I131+'[4]PTRM input'!I123+'[4]PTRM input'!I163+'[4]PTRM input'!I124)*10^6","v":167802.60281066265},{"$f":"('[4]PTRM input'!J122+'[4]PTRM input'!J131+'[4]PTRM input'!J123+'[4]PTRM input'!J163+'[4]PTRM input'!J124)*10^6","v":176192.73295119582},{"$f":"('[4]PTRM input'!K122+'[4]PTRM input'!K131+'[4]PTRM input'!K123+'[4]PTRM input'!K163+'[4]PTRM input'!K124)*10^6","v":185002.36959875564}]
["TRAB0708","Capex timing adjustment",634817.72406941361,1501363.9188243786,{"$f":"(E68-E69)*(1+[4]WACC!G$19)^0.5-(E68-E69)","v":1054307.3699380979},{"$f":"(F68-F69)*(1+[4]WACC!H$19)^0.5-(F68-F69)","v":1053005.1042825654},{"$f":"(G68-G69)*(1+[4]WACC!I$19)^0.5-(G68-G69)","v":864978.15143980831},{"$f":"(H68-H69)*(1+[4]WACC!J$19)^0.5-(H68-H69)","v":1192534.5954762399},{"$f":"(I68-I69)*(1+[4]WACC!K$19)^0.5-(I68-I69)","v":979951.53969572484}]
["TRAB0707","Closing value ",{"$f":"(C65+C66+C68+C70)-C67-C69","v":83129878.639065608},{"$f":"(D65+D66+D68+D70)-D67-D69","v":116156272.93736665},{"$f":"(E65+E66+E68+E70)-E67-E69","v":148400748.73634529},{"$f":"(F65+F66+F68+F70)-F67-F69","v":181002758.74739429},{"$f":"(G65+G66+G68+G70)-G67-G69","v":191680661.67507103},{"$f":"(H65+H66+H68+H70)-H67-H69","v":211896345.54195455},{"$f":"(I65+I66+I68+I70)-I67-I69","v":208663620.73161456}]
[]
[]
[]
[null,"Table 3.3.3 Total disaggregated RAB asset values removed"]
[]
[]
[null,"3.3.4 - ASSET LIVES"]
[null,null,"ASSET LIFE"]
[null,null,"(Years)"]
[null,null,{"$f":"dms_y4","v":"2025-26"},{"$f":"dms_y5","v":"2026-27"},{"$f":"dms_y6","v":"2027-28"},{"$f":"dms_y7","v":"2028-29"},{"$f":"dms_y8","v":"2029-30"},{"$f":"dms_y9","v":"2030-31"},{"$f":"dms_y10","v":"2031-32"}]
[null,"ESTIMATED SERVICE LIFE OF NEW ASSETS"]
["TRAB0901","Overhead transmission assets (wires and towers/poles etc)",{"$f":"'[6]3.3 Assets (RAB)'!H83","v":68.752243199999995},{"$f":"'[6]3.3 Assets (RAB)'!I83","v":68.750691840000002},{"$f":"D83","v":68.750691840000002},{"$f":"E83","v":68.750691840000002},68.750691840000002,68.750691840000002,68.750691840000002]
["TRAB0902","Underground transmission assets (cables, ducts etc)",{"$f":"'[6]3.3 Assets (RAB)'!H84","v":60},{"$f":"'[6]3.3 Assets (RAB)'!I84","v":60},{"$f":"D84","v":60},60,60,60,60]
["TRAB0903","Substations, switchyards, transformers etc with transmission function",{"$f":"'[6]3.3 Assets (RAB)'!H85","v":40.752243200000009},{"$f":"'[6]3.3 Assets (RAB)'!I85","v":40.750691840000002},40.750691840000002,40.750691840000002,40.750691840000002,40.750691840000002,40.750691840000002]
["TRAB0904","Other assets with long lives",15.240325651368272,19.185132075789781,18.081846650985266,17.700506038247724,15.182229432008148,16.190891190203637,15.183489873198697]
["TRAB0905","Other assets with short lives",5.0171451379900773,5.031444044649227,5.2130368513215606,5.0936877425891263,5.1704711315685445,5.2784946530240573,5.0628378220391772]
[null,"ESTIMATED RESIDUAL SERVICE LIFE"]
["TRAB1001","Overhead transmission assets (wires and towers/poles etc)",{"$f":"'[6]3.3 Assets (RAB)'!H89","v":20.7},{"$f":"'[6]3.3 Assets (RAB)'!I89","v":20.9},{"$f":"D89","v":20.9},{"$f":"E89","v":20.9},20.9,20.9,20.9]
["TRAB1002","Underground transmission assets (cables, ducts etc)",{"$f":"'[6]3.3 Assets (RAB)'!H90","v":35.403020799999993},{"$f":"'[6]3.3 Assets (RAB)'!I90","v":35.295624959999998},{"$f":"D90","v":35.295624959999998},35.295624959999998,35.295624959999998,35.295624959999998,35.295624959999998]
["TRAB1003","Substations, switchyards, transformers etc with transmission function",{"$f":"'[6]3.3 Assets (RAB)'!H91","v":22.5},{"$f":"'[6]3.3 Assets (RAB)'!I91","v":22.2},22.2,22.2,22.2,22.2,22.2]
["TRAB1004","Other assets with long lives",8.9414287305311788,10.018388906410449,10.759634715264985,11.180896793250083,11.248171106463921,11.423527963838588,11.483472272019357]
["TRAB1005","Other assets with short lives",2.9664309238839386,3.5313312589607824,3.3914786172504146,3.5345260578427262,3.618383194361392,3.5280231435758336,3.5701630205388009]

{"sheet":"3.4 Operational data","index":15,"n_rows":92,"n_cols":10,"rows_kept":92,"cut":false,"hidden":false,"merged":[]}
[null,{"$f":"(LOOKUP(dms_Model,dms_Model_List,dms_Worksheet_List))","v":"REGULATORY REPORTING STATEMENT"},null,null,null,"#25C6FF",null,"Protected (SOCI)"]
[null,{"$f":"INDEX(dms_TradingNameFull_List,MATCH(dms_TradingName,dms_TradingName_List))","v":"AusNet Transmission Group Pty Limited"},null,null,null,"#FFCCCC",null,"Confidential"]
[null,{"$f":"CONCATENATE(\"REGULATORY PERIOD FROM \", FRCP_y1,\" TO \",dms_MultiYear_FinalYear_Result)","v":"REGULATORY PERIOD FROM 2027-28 TO 2031-32"},null,null,null,"12.5% Grey",null,"Amended"]
[null,"3.4 OPERATIONAL DATA",null,null,null,"#FFCCCC & \n12.5% Grey",null,"Amended Confidential"]
[]
[]
["NULL valid for Ausnet (T)","3.4.1 - ENERGY DELIVERY"]
[null,null,null,"VOLUMES "]
[null,null,null,"Forecast (0's)"]
[null,null,"Units",{"$f":"dms_y4","v":"2025-26"},{"$f":"dms_y5","v":"2026-27"},{"$f":"dms_y6","v":"2027-28"},{"$f":"dms_y7","v":"2028-29"},{"$f":"dms_y8","v":"2029-30"},{"$f":"dms_y9","v":"2030-31"},{"$f":"dms_y10","v":"2031-32"}]
[null,"Energy grouping by downstream connection type"]
["TOPED0101","To Other connected transmission networks","GWh","Not required","Not required","Not required","Not required","Not required","Not required","Not required"]
["TOPED0102","To Distribution networks","GWh","Not required","Not required","Not required","Not required","Not required","Not required","Not required"]
["TOPED0103","To Directly connected end–users (330 kV)","GWh","Not required","Not required","Not required","Not required","Not required","Not required","Not required"]
["TOPED0104","To Directly connected end–users (275 kV)","GWh","Not required","Not required","Not required","Not required","Not required","Not required","Not required"]
["TOPED0105","To Directly connected end–users (220 kV)","GWh","Not required","Not required","Not required","Not required","Not required","Not required","Not required"]
["TOPED0106","To Directly connected end–users (132 kV)","GWh","Not required","Not required","Not required","Not required","Not required","Not required","Not required"]
["TOPED0107","To Directly connected end–users (110 kV)","GWh","Not required","Not required","Not required","Not required","Not required","Not required","Not required"]
["TOPED0108","To Directly connected end–users (44 kV) ","GWh","Not required","Not required","Not required","Not required","Not required","Not required","Not required"]
["TOPED0109","To Directly connected end–users (33 kV)","GWh","Not required","Not required","Not required","Not required","Not required","Not required","Not required"]
["TOPED0110","To Directly connected end–users (22 kV)","GWh","Not required","Not required","Not required","Not required","Not required","Not required","Not required"]
["TOPED0111","To Directly connected end–users (11 kV)","GWh","Not required","Not required","Not required","Not required","Not required","Not required","Not required"]
["TOPED0112","To Directly connected end–users (6.6 kV)","GWh","Not required","Not required","Not required","Not required","Not required","Not required","Not required"]
["TOPED0113","Pumping and Power Station Auxillaries","GWh","Not required","Not required","Not required","Not required","Not required","Not required","Not required"]
["TOPED01","Total energy transported","GWh",{"$f":"SUM(D12:D24)","v":0},0,0,0,0,0,0]
[]
[]
[null,"3.4.2 -  CONNECTION POINTS"]
[null,null,null,"VOLUMES "]
[null,null,null,"Forecast (0's)"]
["NULL valid for Ausnet (T)",null,"Units",{"$f":"dms_y4","v":"2025-26"},{"$f":"dms_y5","v":"2026-27"},{"$f":"dms_y6","v":"2027-28"},{"$f":"dms_y7","v":"2028-29"},{"$f":"dms_y8","v":"2029-30"},{"$f":"dms_y9","v":"2030-31"},{"$f":"dms_y10","v":"2031-32"}]
[null,"AVERAGE Number of entry points at each transmission voltage level"]
["TOPCP0101","500kV","number","Not required","Not required","Not required","Not required","Not required","Not required","Not required"]
["TOPCP0102","330kV","number","Not required","Not required","Not required","Not required","Not required","Not required","Not required"]
["TOPCP0103","275kV","number","Not required","Not required","Not required","Not required","Not required","Not required","Not required"]
["TOPCP0104","220kV","number","Not required","Not required","Not required","Not required","Not required","Not required","Not required"]
["TOPCP0105","132 kV","number","Not required","Not required","Not required","Not required","Not required","Not required","Not required"]
["TOPCP0106","110kV","number","Not required","Not required","Not required","Not required","Not required","Not required","Not required"]
["TOPCP0107","66 kV","number","Not required","Not required","Not required","Not required","Not required","Not required","Not required"]
["TOPCP0108","33 kV","number","Not required","Not required","Not required","Not required","Not required","Not required","Not required"]
["TOPCP0109","22 kV","number","Not required","Not required","Not required","Not required","Not required","Not required","Not required"]
["TOPCP0110","11 kV","number","Not required","Not required","Not required","Not required","Not required","Not required","Not required"]
["TOPCP0111","6.6 kV","number","Not required","Not required","Not required","Not required","Not required","Not required","Not required"]
[null,"AVERAGE Number of exit points at each transmission voltage level "]
["TOPCP0201","500kV","number","Not required","Not required","Not required","Not required","Not required","Not required","Not required"]
["TOPCP0202","330kV","number","Not required","Not required","Not required","Not required","Not required","Not required","Not required"]
["TOPCP0203","275kV","number","Not required","Not required","Not required","Not required","Not required","Not required","Not required"]
["TOPCP0204","220kV","number","Not required","Not required","Not required","Not required","Not required","Not required","Not required"]
["TOPCP0205","132 kV","number","Not required","Not required","Not required","Not required","Not required","Not required","Not required"]
["TOPCP0206","110kV","number","Not required","Not required","Not required","Not required","Not required","Not required","Not required"]
["TOPCP0207","66 kV","number","Not required","Not required","Not required","Not required","Not required","Not required","Not required"]
["TOPCP0208","44 kV","number","Not required","Not required","Not required","Not required","Not required","Not required","Not required"]
["TOPCP0209","33kV","number","Not required","Not required","Not required","Not required","Not required","Not required","Not required"]
["TOPCP0210","22kV","number","Not required","Not required","Not required","Not required","Not required","Not required","Not required"]
["TOPCP0211","11kV","number","Not required","Not required","Not required","Not required","Not required","Not required","Not required"]
["TOPCP0212","6.6kV","number","Not required","Not required","Not required","Not required","Not required","Not required","Not required"]
[]
[]
["NULL valid for Ausnet (T)"]
[null,"3.4.3 - SYSTEM DEMAND"]
[null,null,null,"VOLUMES "]
[null,null,null,"Forecast (0's)"]
[null,null,"Units",{"$f":"dms_y4","v":"2025-26"},{"$f":"dms_y5","v":"2026-27"},{"$f":"dms_y6","v":"2027-28"},{"$f":"dms_y7","v":"2028-29"},{"$f":"dms_y8","v":"2029-30"},{"$f":"dms_y9","v":"2030-31"},{"$f":"dms_y10","v":"2031-32"}]
[null,"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,"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,"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":16,"n_rows":77,"n_cols":10,"rows_kept":77,"cut":false,"hidden":false,"merged":[[38,1,38,2],[23,1,23,2]]}
[null,{"$f":"(LOOKUP(dms_Model,dms_Model_List,dms_Worksheet_List))","v":"REGULATORY REPORTING STATEMENT"},null,null,null,"#25C6FF",null,"Protected (SOCI)"]
[null,{"$f":"INDEX(dms_TradingNameFull_List,MATCH(dms_TradingName,dms_TradingName_List))","v":"AusNet Transmission Group Pty Limited"},null,null,null,"#FFCCCC",null,"Confidential"]
[null,{"$f":"CONCATENATE(\"REGULATORY PERIOD FROM \", FRCP_y1,\" TO \",dms_MultiYear_FinalYear_Result)","v":"REGULATORY PERIOD FROM 2027-28 TO 2031-32"},null,null,null,"12.5% Grey",null,"Amended"]
[null,"3.5 PHYSICAL ASSETS",null,null,null,"#FFCCCC & \n12.5% Grey",null,"Amended Confidential"]
[]
[]
[null,"3.5.1 - TRANSMISSION SYSTEM CAPACITIES "]
[null,null,null,"VOLUMES "]
[null,null,null,"Forecast (0's)"]
[null,null,"Units",{"$f":"dms_y4","v":"2025-26"},{"$f":"dms_y5","v":"2026-27"},{"$f":"dms_y6","v":"2027-28"},{"$f":"dms_y7","v":"2028-29"},{"$f":"dms_y8","v":"2029-30"},{"$f":"dms_y9","v":"2030-31"},{"$f":"dms_y10","v":"2031-32"}]
[null,"Overhead network length of circuit at each voltage"]
["TPA0101","500 kV","km",{"$f":"IFERROR(INDEX('[7]3.5 Physical assets'!$F:$F,MATCH($A12,'[7]3.5 Physical assets'!$B:$B,0)),0)","v":1464.2213449999997},{"$f":"D12","v":1464.2213449999997},1464.2213449999997,1464.2213449999997,1464.2213449999997,1464.2213449999997,1464.2213449999997]
["TPA0102","330 kV","km",{"$f":"IFERROR(INDEX('[7]3.5 Physical assets'!$F:$F,MATCH($A13,'[7]3.5 Physical assets'!$B:$B,0)),0)","v":738.95156199999974},738.95156199999974,738.95156199999974,738.95156199999974,738.95156199999974,738.95156199999974,738.95156199999974]
["TPA0103","275 kV","km",{"$f":"IFERROR(INDEX('[7]3.5 Physical assets'!$F:$F,MATCH($A14,'[7]3.5 Physical assets'!$B:$B,0)),0)","v":156.73375799999997},156.73375799999997,156.73375799999997,156.73375799999997,156.73375799999997,156.73375799999997,156.73375799999997]
["TPA0104","220 kV","km",{"$f":"IFERROR(INDEX('[7]3.5 Physical assets'!$F:$F,MATCH($A15,'[7]3.5 Physical assets'!$B:$B,0)),0)","v":4006.9730160000004},4006.9730160000004,4006.9730160000004,4006.9730160000004,4006.9730160000004,4006.9730160000004,4006.9730160000004]
["TPA0105","132 kV","km",{"$f":"IFERROR(INDEX('[7]3.5 Physical assets'!$F:$F,MATCH($A16,'[7]3.5 Physical assets'!$B:$B,0)),0)","v":0},0,0,0,0,0,0]
["TPA0106","110 kV","km",{"$f":"IFERROR(INDEX('[7]3.5 Physical assets'!$F:$F,MATCH($A17,'[7]3.5 Physical assets'!$B:$B,0)),0)","v":0},0,0,0,0,0,0]
["TPA0107","88 kV","km",{"$f":"IFERROR(INDEX('[7]3.5 Physical assets'!$F:$F,MATCH($A18,'[7]3.5 Physical assets'!$B:$B,0)),0)","v":0},0,0,0,0,0,0]
["TPA0108","66 kV","km",{"$f":"IFERROR(INDEX('[7]3.5 Physical assets'!$F:$F,MATCH($A19,'[7]3.5 Physical assets'!$B:$B,0)),0)","v":175.73071800000002},175.73071800000002,175.73071800000002,175.73071800000002,175.73071800000002,175.73071800000002,175.73071800000002]
["TPA0109","33 kV","km",{"$f":"IFERROR(INDEX('[7]3.5 Physical assets'!$F:$F,MATCH($A20,'[7]3.5 Physical assets'!$B:$B,0)),0)","v":0},0,0,0,0,0,0]
["TPA0110","22 kV","km",{"$f":"IFERROR(INDEX('[7]3.5 Physical assets'!$F:$F,MATCH($A21,'[7]3.5 Physical assets'!$B:$B,0)),0)","v":0},0,0,0,0,0,0]
["TPA011","11 kV","km",{"$f":"IFERROR(INDEX('[7]3.5 Physical assets'!$F:$F,MATCH($A22,'[7]3.5 Physical assets'!$B:$B,0)),0)","v":0},0,0,0,0,0,0]
["TPA0112","Other voltages","km",{"$f":"IFERROR(INDEX('[7]3.5 Physical assets'!$F:$F,MATCH($A23,'[7]3.5 Physical assets'!$B:$B,0)),0)","v":0},0,0,0,0,0,0]
["TPA01","Total",null,{"$f":"SUM(D12:D22)","v":6542.6103989999992},6542.6103989999992,6542.6103989999992,6542.6103989999992,6542.6103989999992,6542.6103989999992,6542.6103989999992]
[]
[null,"Underground cable circuit length at each voltage"]
["TPA0201","500 kV","km",{"$f":"IFERROR(INDEX('[7]3.5 Physical assets'!$F:$F,MATCH($A27,'[7]3.5 Physical assets'!$B:$B,0)),0)","v":0},{"$f":"D27","v":0},0,0,0,0,0]
["TPA0202","330 kV","km",{"$f":"IFERROR(INDEX('[7]3.5 Physical assets'!$F:$F,MATCH($A28,'[7]3.5 Physical assets'!$B:$B,0)),0)","v":0},0,0,0,0,0,0]
["TPA0203","275 kV","km",{"$f":"IFERROR(INDEX('[7]3.5 Physical assets'!$F:$F,MATCH($A29,'[7]3.5 Physical assets'!$B:$B,0)),0)","v":0},0,0,0,0,0,0]
["TPA0204","220 kV","km",{"$f":"IFERROR(INDEX('[7]3.5 Physical assets'!$F:$F,MATCH($A30,'[7]3.5 Physical assets'!$B:$B,0)),0)","v":8.5423703333333343},8.5423703333333343,8.5423703333333343,8.5423703333333343,8.5423703333333343,8.5423703333333343,8.5423703333333343]
["TPA0205","132 kV","km",{"$f":"IFERROR(INDEX('[7]3.5 Physical assets'!$F:$F,MATCH($A31,'[7]3.5 Physical assets'!$B:$B,0)),0)","v":0},0,0,0,0,0,0]
["TPA0206","110 kV","km",{"$f":"IFERROR(INDEX('[7]3.5 Physical assets'!$F:$F,MATCH($A32,'[7]3.5 Physical assets'!$B:$B,0)),0)","v":0},0,0,0,0,0,0]
["TPA0207","88 kV","km",{"$f":"IFERROR(INDEX('[7]3.5 Physical assets'!$F:$F,MATCH($A33,'[7]3.5 Physical assets'!$B:$B,0)),0)","v":0},0,0,0,0,0,0]
["TPA0208","66 kV","km",{"$f":"IFERROR(INDEX('[7]3.5 Physical assets'!$F:$F,MATCH($A34,'[7]3.5 Physical assets'!$B:$B,0)),0)","v":0},0,0,0,0,0,0]
["TPA0209","33 kV","km",{"$f":"IFERROR(INDEX('[7]3.5 Physical assets'!$F:$F,MATCH($A35,'[7]3.5 Physical assets'!$B:$B,0)),0)","v":0},0,0,0,0,0,0]
["TPA0210","22 kV","km",{"$f":"IFERROR(INDEX('[7]3.5 Physical assets'!$F:$F,MATCH($A36,'[7]3.5 Physical assets'!$B:$B,0)),0)","v":0},0,0,0,0,0,0]
["TPA0211","11 kV","km",{"$f":"IFERROR(INDEX('[7]3.5 Physical assets'!$F:$F,MATCH($A37,'[7]3.5 Physical assets'!$B:$B,0)),0)","v":0},0,0,0,0,0,0]
["TPA0212","Other voltages","km",{"$f":"IFERROR(INDEX('[7]3.5 Physical assets'!$F:$F,MATCH($A38,'[7]3.5 Physical assets'!$B:$B,0)),0)","v":0},0,0,0,0,0,0]
["TPA02","Total",null,{"$f":"SUM(D27:D37)","v":8.5423703333333343},8.5423703333333343,8.5423703333333343,8.5423703333333343,8.5423703333333343,8.5423703333333343,8.5423703333333343]
[]
[null,"Estimated overhead network weighted average MVA capacity by voltage class"]
["TPA0301","500 kV","MVA",{"$f":"IFERROR(INDEX('[7]3.5 Physical assets'!$F:$F,MATCH($A42,'[7]3.5 Physical assets'!$B:$B,0)),0)","v":2667.0765982671483},{"$f":"D42","v":2667.0765982671483},2667.0765982671483,2667.0765982671483,2667.0765982671483,2667.0765982671483,2667.0765982671483]
["TPA0302","330 kV","MVA",{"$f":"IFERROR(INDEX('[7]3.5 Physical assets'!$F:$F,MATCH($A43,'[7]3.5 Physical assets'!$B:$B,0)),0)","v":801.98772791442286},801.98772791442286,801.98772791442286,801.98772791442286,801.98772791442286,801.98772791442286,801.98772791442286]
["TPA0303","275 kV","MVA",{"$f":"IFERROR(INDEX('[7]3.5 Physical assets'!$F:$F,MATCH($A44,'[7]3.5 Physical assets'!$B:$B,0)),0)","v":552.52420761447195},552.52420761447195,552.52420761447195,552.52420761447195,552.52420761447195,552.52420761447195,552.52420761447195]
["TPA0304","220 kV","MVA",{"$f":"IFERROR(INDEX('[7]3.5 Physical assets'!$F:$F,MATCH($A45,'[7]3.5 Physical assets'!$B:$B,0)),0)","v":401.87908310608964},401.87908310608964,401.87908310608964,401.87908310608964,401.87908310608964,401.87908310608964,401.87908310608964]
["TPA0305","132 kV","MVA",{"$f":"IFERROR(INDEX('[7]3.5 Physical assets'!$F:$F,MATCH($A46,'[7]3.5 Physical assets'!$B:$B,0)),0)","v":0},0,0,0,0,0,0]
["TPA0306","110 kV","MVA",{"$f":"IFERROR(INDEX('[7]3.5 Physical assets'!$F:$F,MATCH($A47,'[7]3.5 Physical assets'!$B:$B,0)),0)","v":0},0,0,0,0,0,0]
["TPA0307","88 kV","MVA",{"$f":"IFERROR(INDEX('[7]3.5 Physical assets'!$F:$F,MATCH($A48,'[7]3.5 Physical assets'!$B:$B,0)),0)","v":0},0,0,0,0,0,0]
["TPA0308","66 kV","MVA",{"$f":"IFERROR(INDEX('[7]3.5 Physical assets'!$F:$F,MATCH($A49,'[7]3.5 Physical assets'!$B:$B,0)),0)","v":93.078688846240098},93.078688846240098,93.078688846240098,93.078688846240098,93.078688846240098,93.078688846240098,93.078688846240098]
["TPA0309","33 kV","MVA",{"$f":"IFERROR(INDEX('[7]3.5 Physical assets'!$F:$F,MATCH($A50,'[7]3.5 Physical assets'!$B:$B,0)),0)","v":0},0,0,0,0,0,0]
["TPA0310","22 kV","MVA",{"$f":"IFERROR(INDEX('[7]3.5 Physical assets'!$F:$F,MATCH($A51,'[7]3.5 Physical assets'!$B:$B,0)),0)","v":0},0,0,0,0,0,0]
["TPA0311","11 kV","MVA",{"$f":"IFERROR(INDEX('[7]3.5 Physical assets'!$F:$F,MATCH($A52,'[7]3.5 Physical assets'!$B:$B,0)),0)","v":0},0,0,0,0,0,0]
["TPA0212","Other voltages","MVA",{"$f":"IFERROR(INDEX('[7]3.5 Physical assets'!$F:$F,MATCH($A53,'[7]3.5 Physical assets'!$B:$B,0)),0)","v":0},0,0,0,0,0,0]
[]
[null,"Estimated underground network weighted average MVA capacity by voltage class"]
["TPA0401","500 kV","MVA",{"$f":"IFERROR(INDEX('[7]3.5 Physical assets'!$F:$F,MATCH($A56,'[7]3.5 Physical assets'!$B:$B,0)),0)","v":0},{"$f":"D56","v":0},0,0,0,0,0]
["TPA0402","330 kV","MVA",{"$f":"IFERROR(INDEX('[7]3.5 Physical assets'!$F:$F,MATCH($A57,'[7]3.5 Physical assets'!$B:$B,0)),0)","v":0},0,0,0,0,0,0]
["TPA0403","275 kV","MVA",{"$f":"IFERROR(INDEX('[7]3.5 Physical assets'!$F:$F,MATCH($A58,'[7]3.5 Physical assets'!$B:$B,0)),0)","v":0},0,0,0,0,0,0]
["TPA0404","220 kV","MVA",{"$f":"IFERROR(INDEX('[7]3.5 Physical assets'!$F:$F,MATCH($A59,'[7]3.5 Physical assets'!$B:$B,0)),0)","v":449.6403896448806},449.6403896448806,449.6403896448806,449.6403896448806,449.6403896448806,449.6403896448806,449.6403896448806]
["TPA0405","132 kV","MVA",{"$f":"IFERROR(INDEX('[7]3.5 Physical assets'!$F:$F,MATCH($A60,'[7]3.5 Physical assets'!$B:$B,0)),0)","v":0},0,0,0,0,0,0]
["TPA0406","110 kV","MVA",{"$f":"IFERROR(INDEX('[7]3.5 Physical assets'!$F:$F,MATCH($A61,'[7]3.5 Physical assets'!$B:$B,0)),0)","v":0},0,0,0,0,0,0]
["TPA0407","88 kV","MVA",{"$f":"IFERROR(INDEX('[7]3.5 Physical assets'!$F:$F,MATCH($A62,'[7]3.5 Physical assets'!$B:$B,0)),0)","v":0},0,0,0,0,0,0]
["TPA0408","66 kV","MVA",{"$f":"IFERROR(INDEX('[7]3.5 Physical assets'!$F:$F,MATCH($A63,'[7]3.5 Physical assets'!$B:$B,0)),0)","v":0},0,0,0,0,0,0]
["TPA0409","33 kV","MVA",{"$f":"IFERROR(INDEX('[7]3.5 Physical assets'!$F:$F,MATCH($A64,'[7]3.5 Physical assets'!$B:$B,0)),0)","v":0},0,0,0,0,0,0]
["TPA0410","22 kV","MVA",{"$f":"IFERROR(INDEX('[7]3.5 Physical assets'!$F:$F,MATCH($A65,'[7]3.5 Physical assets'!$B:$B,0)),0)","v":0},0,0,0,0,0,0]
["TPA0411","11 kV","MVA",{"$f":"IFERROR(INDEX('[7]3.5 Physical assets'!$F:$F,MATCH($A66,'[7]3.5 Physical assets'!$B:$B,0)),0)","v":0},0,0,0,0,0,0]
["TPA0212","Other voltages","MVA",{"$f":"IFERROR(INDEX('[7]3.5 Physical assets'!$F:$F,MATCH($A67,'[7]3.5 Physical assets'!$B:$B,0)),0)","v":0},0,0,0,0,0,0]
[]
[null,"Installed transmission system transformer capacity"]
["TPA0501","Transmission substations (eg 500 kV to 330 kV)","MVA",{"$f":"IFERROR(INDEX('[7]3.5 Physical assets'!$F:$F,MATCH($A70,'[7]3.5 Physical assets'!$B:$B,0)),0)","v":13369.930000000015},{"$f":"D70","v":13369.930000000015},13369.930000000015,13369.930000000015,13369.930000000015,13369.930000000015,13369.930000000015]
["TPA0502","Terminal points to DNSP systems","MVA",{"$f":"IFERROR(INDEX('[7]3.5 Physical assets'!$F:$F,MATCH($A71,'[7]3.5 Physical assets'!$B:$B,0)),0)","v":15164},15164,15164,15164,15164,15164,15164]
["TPA0503","Transformer capacity for directly connected end–users owned by the TNSP","MVA",{"$f":"IFERROR(INDEX('[7]3.5 Physical assets'!$F:$F,MATCH($A72,'[7]3.5 Physical assets'!$B:$B,0)),0)","v":210},210,210,210,210,210,210]
["TPA0505","Interconnector capacity","MVA",{"$f":"IFERROR(INDEX('[7]3.5 Physical assets'!$F:$F,MATCH($A73,'[7]3.5 Physical assets'!$B:$B,0)),0)","v":740},740,740,740,740,740,740]
["TPA0506","Other","MVA",{"$f":"IFERROR(INDEX('[7]3.5 Physical assets'!$F:$F,MATCH($A74,'[7]3.5 Physical assets'!$B:$B,0)),0)","v":300},300,300,300,300,300,300]
[]
[null,"Cold spare capacity"]
["TPA06","Cold spare capacity included in 3.5.1.5","MVA",{"$f":"IFERROR(INDEX('[7]3.5 Physical assets'!$F:$F,MATCH($A77,'[7]3.5 Physical assets'!$B:$B,0)),0)","v":2799.9899999999993},{"$f":"D77","v":2799.9899999999993},2799.9899999999993,2799.9899999999993,2799.9899999999993,2799.9899999999993,2799.9899999999993]

{"sheet":"3.7 Operating environment","index":17,"n_rows":27,"n_cols":10,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
[null,{"$f":"(LOOKUP(dms_Model,dms_Model_List,dms_Worksheet_List))","v":"REGULATORY REPORTING STATEMENT"},null,null,null,"#25C6FF",null,"Protected (SOCI)"]
[null,{"$f":"INDEX(dms_TradingNameFull_List,MATCH(dms_TradingName,dms_TradingName_List))","v":"AusNet Transmission Group Pty Limited"},null,null,null,"#FFCCCC",null,"Confidential"]
[null,{"$f":"CONCATENATE(\"REGULATORY PERIOD FROM \", FRCP_y1,\" TO \",dms_MultiYear_FinalYear_Result)","v":"REGULATORY PERIOD FROM 2027-28 TO 2031-32"},null,null,null,"12.5% Grey",null,"Amended"]
[null,"3.7 OPERATING ENVIRONMENT FACTORS",null,null,null,"#FFCCCC & \n12.5% Grey",null,"Amended Confidential"]
[]
[]
["TEF01","3.7.1 - TERRAIN FACTORS"]
[null,null,null,"VOLUMES "]
[null,null,null,"Forecast (0's)"]
[null,null,"Units",{"$f":"dms_y4","v":"2025-26"},{"$f":"dms_y5","v":"2026-27"},{"$f":"dms_y6","v":"2027-28"},{"$f":"dms_y7","v":"2028-29"},{"$f":"dms_y8","v":"2029-30"},{"$f":"dms_y9","v":"2030-31"},{"$f":"dms_y10","v":"2031-32"}]
["TEF0101","Total number of vegetation maintenance spans","Number of spans",850]
["TEF0102","Average vegetation maintenance span cycle","Years",3]
["TEF0103","Average number of trees per vegetation maintenance span","Trees",12.52]
["TEF0104","Average number of defects per vegetation maintenance span","Defects",0.35]
["TEF0105","Tropical proportion","Number of spans",0]
["TEF0106","Standard vehicle access","km",2866.62]
["TEF0107","Altitude","km",212.5]
["TEF0108","Bushfire risk","Number of spans",730]
[]
["TEF02","3.7.2 - NETWORK CHARACTERISTICS"]
[null,null,null,"VOLUMES "]
[null,null,null,"Forecast (0's)"]
[null,null,"Units",{"$f":"dms_y4","v":"2025-26"},{"$f":"dms_y5","v":"2026-27"},{"$f":"dms_y6","v":"2027-28"},{"$f":"dms_y7","v":"2028-29"},{"$f":"dms_y8","v":"2029-30"},{"$f":"dms_y9","v":"2030-31"},{"$f":"dms_y10","v":"2031-32"}]
["TEF0201","Route line length","km",{"$f":"'[7]3.7 Operating environment'!$F$34","v":5024.7},{"$f":"D24","v":5024.7},5024.7,5024.7,5024.7,5024.7,5024.7]
["TEF0202","Variability of dispatch","%",{"$f":"IFERROR(INDEX('[7]3.7 Operating environment'!$F:$F,MATCH($A25,'[7]3.7 Operating environment'!$B:$B,0)),0)","v":0},0,0,0,0,0,0]
["TEF0203","Concentrated load distance","km",{"$f":"IFERROR(INDEX('[7]3.7 Operating environment'!$F:$F,MATCH($A26,'[7]3.7 Operating environment'!$B:$B,0)),0)","v":0},0,0,0,0,0,0]
["TEF0204","Total number of spans","number",{"$f":"IFERROR(INDEX('[7]3.7 Operating environment'!$F:$F,MATCH($A27,'[7]3.7 Operating environment'!$B:$B,0)),0)","v":13094},13094,13094,13094,13094,13094,13094]

{"sheet":"7.1  Policies and Procedures","index":18,"n_rows":225,"n_cols":6,"rows_kept":225,"cut":false,"hidden":false,"merged":[[211,1,211,4],[222,1,222,4],[75,1,75,4],[155,1,155,4],[160,1,160,4],[197,1,197,4],[201,1,201,4],[38,1,38,4],[41,1,41,4],[46,1,46,4],[70,1,70,4],[206,1,206,4],[6,1,6,3],[11,1,11,4],[15,1,15,4],[33,1,33,4],[37,1,37,4]]}
[null,{"$f":"(LOOKUP(dms_Model,dms_Model_List,dms_Worksheet_List))","v":"REGULATORY REPORTING STATEMENT"},null,"#25C6FF",null,"Protected (SOCI)"]
[null,{"$f":"INDEX(dms_TradingNameFull_List,MATCH(dms_TradingName,dms_TradingName_List))","v":"AusNet Transmission Group Pty Limited"},null,"#FFCCCC",null,"Confidential"]
[null,{"$f":"CONCATENATE(\"REGULATORY PERIOD FROM \", FRCP_y1,\" TO \",dms_MultiYear_FinalYear_Result)","v":"REGULATORY PERIOD FROM 2027-28 TO 2031-32"},null,"12.5% Grey",null,"Amended"]
[null,"7.1  PLANS, POLICIES, PROCEDURES AND STRATEGIES",null,"#FFCCCC & \n12.5% Grey",null,"Amended Confidential"]
[]
[null,"Instructions"]
[null,{"$f":"CONCATENATE(dms_TradingName, \" 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. \"&dms_TradingName,\" 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.\")","v":"AusNet (T) 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. AusNet (T) 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,"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,"AusNet Corporate Strategy","Represent corporate objectives and strategic directions","Balanced corporate directions that set the tone and priorities of espects of our Regulatory Proposal","No"]
[null,"RM 10-04 Risk Management Policy","The Risk Management Policy outlines AusNet’s approach to managing risk and the minimum accountabilities and expectations for risk management across AusNet.","Informs AusNet Services asset risk management approaches","No"]
[null,"RM 10-01 Enterprise Risk Management Framework","This Framework establishes a consistent and effective approach to the management of risk at all levels of the organisation. The Framework outlines the requirements of risk management at AusNet and includes an overview of risk management objective and principles, description of key roles and responsibilities in risk management, the process for identifying, assessing, and managing risks, criteria for assessing risk, control effectiveness and identifying treatment plans, and guidance on recording, reporting, and escalation of risks.","Informs AusNet Services asset risk management approaches","No"]
[null,"Governance framework"]
[null,"AMS 01-03 Strategic Asset Management Committee Charter","The purpose of the Strategic Asset Management Committee is to maintain an Asset Management System which optimises network performance, risk and asset lifecycle cost in alignment with AusNet’s vision, purpose and strategy. ","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, Environment 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 Policy","Outlines principles and rules guiding all procurement activities.","Demonstrates that cost forecasts based on unit rates are subject to formal competitive procedures","No"]
[null,"PTP 10-05 Sustainability Policy                  ","Embeds environmental and ethical considerations into procurement decisions.","Informs AusNet's procurement approaches","No"]
[null,"PTP 10-05(a) Social Procurement Policy                 ","Promotes social outcomes through procurement, including diversity and inclusion.","Informs AusNet's procurement approaches","No"]
[null,"PTP 10-04 Supplier Code of Conduct           ","Sets ethical standards and expectations for suppliers.","Informs AusNet's procurement approaches","No"]
[null,"PTP 10-06 Third Party Risk Framework        ","Manages risks associated with external suppliers and contractors.","Informs AusNet's procurement approaches","No"]
[null,"PTP 21-24 Tendering Procedure Manual","Provides step-by-step guidance for conducting tenders.","Informs AusNet's procurement approaches","No"]
[null,"ESMS 10-01 Electricity Safety Management Scheme - Electricity Transmission Network","Theis document describes the assets forming AusNet Services’ electricity transmission 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 public, AusNet Services’ staff and contractors. ","Forecast includes safety related expenditure required to meet the ESMS obligations which are outlined in this document","No"]
[null,"Project Cost Estimating Methodology","This document outlines the method used for estimating the cost of projects.","Chapter 4 (Capital Expenditure)","No"]
[null,"Top Down Review","This document investigates areas of potential overlap between various line items of the capital forecast to establish if expenditure has been double counted, or if overlaps have been removed. ","Chapter 4 (Capital Expenditure)","No"]
[]
[]
[]
[]
[]
[null,"Accounting policies, procedures and methodologies (including a capitalisation policy, depreciation policy and an approved expenditure allocation methodology)"]
[null,"FIN 10-11 Capital vs. Operating Expenditure","The objective of this policy is to prescribe the correct accounting treatment with respect to the distinction between capital expenditure (capex) and operating expenditure (opex). The policies in this document are consistent with the requirements of accounting standards AASB 116 Property, Plant and Equipment and AASB 138 Intangible Assets. ","Demonstrates consistency in capitalisation of assets","No"]
[null,"FIN 10-10 Property, Plant and Equipment","The objective of this policy is to prescribe the accounting treatment for property, plant and equipment.  This policy complies with the requirements of AASB 116 Property, plant and equipment. The principal accounting issues addressed by this policy are the measurement, presentation, and depreciation of assets once they have been capitalised to the Fixed Asset Register. ","Demonstrates consistency in depreciation of assets","No"]
[null,"FIN 10-81 Cost Allocation Methodology","This document sets out the method used by AusNet Services for the attribution and allocation of costs to, and between, categories of electricity transmission network services.","Provides the basis of allocation of costs in AusNet Services accounting","No"]
[null,"Asset management plan or equivalent documentation"]
[null,"Asset Management Policies"]
[null,"AMS 01-02 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,"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.","Underpins all asset-related expenditure","No"]
[null,"AMS 01-09 Asset Management Risk Overview","This document describes the risk assessment process used by AusNet Services to identify and assess the highest risks associated with network assets. ","Risk assessments are used to inform the development of optimised inspection, maintenance and replacement programs, forecast future asset replacement capital and operational expenditure, and assist in the prioritisation of work","No"]
[null,"Transmission Connection Planning Report","This document sets out a joint report on transmission connection asset planning in Victoria, prepared by the five Victorian electricity Distribution Businesses","These annual reports forecast and trace connection asset developments that generally will roll into AusNet Services RAB when the augmentations are established","No"]
[]
[null,"Asset Management Plans"]
[null,"AMS 01-08-10 Electricity Transmission Network Asset Management Plan","The AMP highlights the key factors, and defines the programs, projects and planned expenditure associated with managing AusNet Services’ network assets over the forward five-year period.  The AMP informs stakeholders of the context, drivers, challenges, risks, and opportunities for network investment.  ","Provides an overview of asset management priorities and activities planned to address these","No"]
[null,"RIT-T documents","These reports for each major station project describe the planned works and form the basis for RIT-T processes","Chapter 4 (Capital Expenditure)","No"]
[null,"Technical AMS 10-52 Auxiliary Power Supplies","This document includes a current assessment of the asset population, key risks, and strategy to manage the assets","Chapter 4 (Capital Expenditure)","No"]
[null,"Technical AMS 10-54 Circuit Breakers","This document includes a current assessment of the asset population, key risks, and strategy to manage the assets","Chapter 4 (Capital Expenditure)","No"]
[null,"Technical AMS 10-55 Transmission Infrastructure","This document includes a current assessment of the asset population, key risks, and strategy to manage the assets","Chapter 4 (Capital Expenditure)","No"]
[null,"Technical AMS 10-56 Communications Systems","This document includes a current assessment of the asset population, key risks, and strategy to manage the assets","Chapter 4 (Capital Expenditure)","No"]
[null,"Technical AMS 10-59 Disconnectors and Earth Switches","This document includes a current assessment of the asset population, key risks, and strategy to manage the assets","Chapter 4 (Capital Expenditure)","No"]
[null,"Technical AMS 10-64 Instrument Transformers","This document includes a current assessment of the asset population, key risks, and strategy to manage the assets","Chapter 4 (Capital Expenditure)","No"]
[null,"Technical AMS 10-67 Power Transformers and Oil Filled Reactors","This document includes a current assessment of the asset population, key risks, and strategy to manage the assets","Chapter 4 (Capital Expenditure)","No"]
[null,"Technical AMS 10-68 Protection (Secondary) Systems","This document includes a current assessment of the asset population, key risks, and strategy to manage the assets","Chapter 4 (Capital Expenditure)","No"]
[null,"Technical AMS 10-73 Surge Arresters","This document includes a current assessment of the asset population, key risks, and strategy to manage the assets","Chapter 4 (Capital Expenditure)","No"]
[null,"Technical AMS 10-75 Transmission Line Insulators","This document includes a current assessment of the asset population, key risks, and strategy to manage the assets","Chapter 4 (Capital Expenditure)","No"]
[null,"Technical AMS 10-77 Transmission Line Structures","This document includes a current assessment of the asset population, key risks, and strategy to manage the assets","Chapter 4 (Capital Expenditure)","No"]
[null,"Technical AMS 10-75-10 Ground Clearance ","This document includes a current assessment of the asset population, key risks, and strategy to manage the assets","Chapter 4 (Capital Expenditure)","No"]
[null,"Technical AMS 10-79 Transmission Line Conductors and groundwires","This document includes a current assessment of the asset population, key risks, and strategy to manage the assets","Chapter 4 (Capital Expenditure)","No"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Capital expenditure policies and procedures (including capex approval policies and procedures and replacement policy) "]
[null,"Regulated Capital Projects Decision Framework","This framework sets out the approval pathway for regulated capital projects","Chapter 4 (Capital Expenditure)","No"]
[null,"Regulated Capital Investment Guidelines","These guidelines outline key decision-making processes, roles and responsibilities relating to management of the regulated capital portfolio ","Chapter 4 (Capital Expenditure)","No"]
[]
[]
[null,"Internal standards for network planning, design, maintenance and operation"]
[null,"ANT - TRR 2028-32 Technical AMS 10-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. ","Chapter 4 (Capital Expenditure)","No"]
[null,"ANT - TRR 2028-32 Technical AMS 10-24 Asset Renewal Planning Guide","This document provides a framework for AusNet Services’ asset renewal planning for the Victorian electricity transmission network. ","Chapter 4 (Capital Expenditure)","No"]
[null,"ANT - TRR 2028-32 Technical AMS 10-19 Plant and Equipment Maintenance","This document outlines the plant and equipment maintenance strategies for management of assets in the transmission network.  It provides  background to the different categories of maintenance, condition monitoring, and current maintenance techniques and explores contemporary practice","Chapter 4 (Capital Expenditure)","No"]
[null,"TOC 10-10 Power System Security Procedure","This document describes how AusNet Services assists AEMO in seeking to meet its power system security responsibilities generally’ and the information and actions required from AusNet Services to assist in maintaining or restoring power system security. ","Underpins network operations activities","No"]
[null,"TOC 10-20 System Incident Management","The purpose is to provide guidelines for system incident management including a post-incident reenergisation such as auto-reclose, protection operation, remedial action scheme operation, forced outage, or prolonged outage. ","Underpins network operations activities","No"]
[null,"TOC 10-21 Incident reporting","This procedure is to define AusNet’s obligations to report transmission incidents and defines the process of reporting incidents and requesting resources including roles and responsibilities. It is specific for reporting only. ","Underpins network operations activities","No"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Procurement and contracting out policies"]
[]
[]
[]
[]
[null,"Information technology policies or strategies"]
[null,"ICT Strategy Electricity Transmission Network","This document sets out the ICT strategy forAusNet's transmission network","Chapter 4 (Capital Expenditure), Chapter 5 (Operating Expenditure)","Yes"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Demand management policies or strategies"]
[]
[]
[]
[null,"Self insurance guidelines or policy"]
[]
[]
[]
[]
[null,"Land and easement acquisition polices"]
[]
[]
[]
[]
[null,"Asset security plans and policies"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Disaster recovery policy"]
[null,"AMS 10-03 Network Asset Contingency Plan","The Transmission Network Contingency Plan supports the recovery from asset failure, natural events such as bushfires, floods or high winds; or actions that adversely affect the performance of the Victorian transmission network.  ","Provides the basis of strategies, processes and practices to ensure effective and efficient response to network failure events","No"]
[null,"EM 01-03 Strategic Plan for Integrated Response & Contingency System (SPIRACS)","The Strategic Plan for Integrated Response and Contingency System (SPIRACS) is AusNet’s Incident and Crisis Management Plan, detailing how AusNet operates before, during and after an emergency. ","Provides the basis of how AusNet responds to emergencies","No"]

{"sheet":"7.2 Contingent projects","index":19,"n_rows":31,"n_cols":6,"rows_kept":31,"cut":false,"hidden":false,"merged":[[7,1,7,3]]}
[null,{"$f":"(LOOKUP(dms_Model,dms_Model_List,dms_Worksheet_List))","v":"REGULATORY REPORTING STATEMENT"},null,null,"#25C6FF","Protected (SOCI)"]
[null,{"$f":"INDEX(dms_TradingNameFull_List,MATCH(dms_TradingName,dms_TradingName_List))","v":"AusNet Transmission Group Pty Limited"},null,null,"#FFCCCC","Confidential"]
[null,{"$f":"CONCATENATE(\"REGULATORY PERIOD FROM \", FRCP_y1,\" TO \",dms_MultiYear_FinalYear_Result)","v":"REGULATORY PERIOD FROM 2027-28 TO 2031-32"},null,null,"12.5% Grey","Amended"]
[null,"7.2 CONTINGENT PROJECTS",null,null,"#FFCCCC & \n12.5% Grey","Amended Confidential"]
[]
[]
[null,"Instructions"]
[null,{"$f":"CONCATENATE(dms_TradingName,\" is required to populate all input cells (yellow) in table 7.2.1 presented below.\"\n\n\n\n)","v":"AusNet (T) is required to populate all input cells (yellow) in table 7.2.1 presented below."}]
[]
[null,"7.2.1 - PROPOSED CONTINGENT PROJECTS FOR THE FORTHCOMING REGULATORY CONTROL PERIOD"]
[null,"Proposed contingent project name","Proposed contingent capital expenditure \n($0's, nominal)","Proposed trigger events",{"$f":"CONCATENATE(\"Proposed MAR for \", FRCP_y1,\" \n($0's, nominal)\")","v":"Proposed MAR for 2027-28 \n($0's, nominal)"},{"$f":"CONCATENATE(\"5 per cent of the \", FRCP_y1,\" ($0's, nominal) MAR\")","v":"5 per cent of the 2027-28 ($0's, nominal) MAR"}]
[null,"DDTS H3 330/220kV transformer & circuit breaker replacement",43721050.868400633,"AusNet board commitment to proceed with the project subject to the AER amending the revenue determination pursuant to the NER",{"$f":"'[4]Revenue summary'!$G$16*10^6","v":829347904.77147973},{"$f":"+E12*0.05","v":41467395.238573991}]
[null,null,null,null,{"$f":"+$E$12","v":829347904.77147973},41467395.238573991]
[null,null,null,null,829347904.77147973,41467395.238573991]
[null,null,null,null,829347904.77147973,41467395.238573991]
[null,null,null,null,829347904.77147973,41467395.238573991]
[null,null,null,null,829347904.77147973,41467395.238573991]
[null,null,null,null,829347904.77147973,41467395.238573991]
[null,null,null,null,829347904.77147973,41467395.238573991]
[null,null,null,null,829347904.77147973,41467395.238573991]
[null,null,null,null,829347904.77147973,41467395.238573991]
[null,null,null,null,829347904.77147973,41467395.238573991]
[null,null,null,null,829347904.77147973,41467395.238573991]
[null,null,null,null,829347904.77147973,41467395.238573991]
[null,null,null,null,829347904.77147973,41467395.238573991]
[null,null,null,null,829347904.77147973,41467395.238573991]
[null,null,null,null,829347904.77147973,41467395.238573991]
[null,null,null,null,829347904.77147973,41467395.238573991]
[null,null,null,null,829347904.77147973,41467395.238573991]
[null,null,null,null,829347904.77147973,41467395.238573991]
[null,null,null,null,829347904.77147973,41467395.238573991]

{"sheet":"7.3 Obligations","index":20,"n_rows":299,"n_cols":5,"rows_kept":299,"cut":false,"hidden":false,"merged":[[6,1,6,2]]}
[null,{"$f":"(LOOKUP(dms_Model,dms_Model_List,dms_Worksheet_List))","v":"REGULATORY REPORTING STATEMENT"},null,"#25C6FF","Protected (SOCI)"]
[null,{"$f":"INDEX(dms_TradingNameFull_List,MATCH(dms_TradingName,dms_TradingName_List))","v":"AusNet Transmission Group Pty Limited"},null,"#FFCCCC","Confidential"]
[null,{"$f":"CONCATENATE(\"REGULATORY PERIOD FROM \", FRCP_y1,\" TO \",dms_MultiYear_FinalYear_Result)","v":"REGULATORY PERIOD FROM 2027-28 TO 2031-32"},null,"12.5% Grey","Amended"]
[null,"7.3  OBLIGATIONS, REQUIREMENTS & STANDARDS",null,"#FFCCCC & \n12.5% Grey","Amended Confidential"]
[]
[null,"Instructions"]
[null,{"$f":"CONCATENATE(\"Outline those obligations and requirements that \",dms_TradingName, \" identifies as having a material impact on expenditure requirements.\")","v":"Outline those obligations and requirements that AusNet (T) identifies as having a material impact on expenditure requirements."}]
[]
[]
[null,"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,"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","No"]
[null,"Electricity Safety (Bushfire Mitigation) Regulations 2023","Requires the preparation of bushfire mitigation plans and specifies inspection of assets.","Chapter 4 Capex, Chapter 5 Opex","No"]
[null,"Electricity Safety (Electric Line Clearance) Interim Regulations 2025","Prescribes line clearance requirements including vegetation clearing","Chapter 4 Capex, Chapter 5 Opex","No"]
[null,"Electricity Safety (Management) Regulations 2019","Sets out requirements for Electricity Safety Management Schemes.","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","No"]
[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, Chapter 12 Cost Pass Through","No"]
[null,"Energy and Water Ombudsman Charter 2018","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 2017","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 2017","Legislative framework for the protection of the environment in Victoria.","Chapter 4 Capex, Chapter 5 Opex","No"]
[null,"Environment Protection Regulations 2021","Sets out requirements for the management and control of pollution and waste, including air and water pollution, contaminated land, noise, vehicle emissions, waste, and wastewater","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,"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).","Revenue Proposal","No"]
[null,"National Electricity (Victoria) Act 2005","This Act provides for the regulation of the national electricity wholesale market. It is part of a national scheme which gives effect to the National Electricity Law and the National Electricity Rules made under that Law. The lead legislation under the national scheme is the National Electricity (South Australia) Act 1996. The economic regulator is the Australian Energy Regulator (AER) and the rule-maker is the Australian Energy Market Commission (AEMC). The national electricity wholesale market is administered by the Australian Energy Market Operator (AEMO).","Revenue Proposal","No"]
[null,"Superannuation Guarantee (Administration) Act 1992, No. 111","The Act sets out relevant superannuation payment requirements.","Chapter 5 Opex","No"]
[null,"Roads Management Act 2004 (Vic)","Safety obligations when carrying out works on public roadways.","Chapter 4 Capex","No"]
[null,"Fair Work Act 2009","Sets out our obligations in relation to the negotiation of employment terms and conditions.","Chapter 5 Opex","No"]
[null,"The Security of Critical Infrastructure Act 2018 (Cth) ","Outlines the legal obligations you have if you own, operate, or have direct interests in critical infrastructure assets","Chapter 4 Capex","No"]
[null,"Emergency Management (Critical Infrastructure Resilience) Regulations 2025","These regulations refer to relevant guidance from the Australian Government that must be adhered to in protecting critical assets from emergencies","Chapter 4 Capex, Chapter 5 Opex","No"]
[null,"Workplace Injury Rehabilitation and Compensation Act 2013 (Vic)","This act sets out provisions applying to the rehabilitation of injured workers and compensation in relation to workplace accidents and diseases.","Chapter 5 Opex","No"]
[null,"Labour Hire Licensing Act 2018 (Vic) ","This act establishes a licensing system to regulate the provision of labour hire services, imposes civil penalties on providers and users of labour hire services who obtain those services from anyone other than licensed providers of labour hire services, and other matters relating to labour hiring. ","Chapter 5 Opex","No"]
[null,"Planning and Environment Act 1987 (Vic)","This act establishes a framework for planning the use, development and protection of land in Victoria in the present and long term interests of all Victorians.","Chapter 4 Capex, Chapter 5 Opex","No"]
[null,"AER Transmission Ring-fencing Guideline (Version 5)","This guideline sets out the accounting and functional separation required between the provision of prescribed transmission services or negotiated transmission services by TNSPs from the provision of other services/contestable services by them or their affiliated entities","Chapter 1 Introduction","No"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Licences"]
[]
[]
[]
[]
[null,"Rules"]
[]
[]
[]
[]
[null,"Orders"]
[]
[]
[]
[null,"Codes"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Guidelines"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Default agreements "]
[]
[]
[]
[]
[null,"Other"]

{"sheet":"7.4 Shared Assets","index":21,"n_rows":30,"n_cols":11,"rows_kept":30,"cut":false,"hidden":false,"merged":[[7,1,8,1],[7,2,8,2]]}
[null,{"$f":"(LOOKUP(dms_Model,dms_Model_List,dms_Worksheet_List))","v":"REGULATORY REPORTING STATEMENT"},null,null,null,"#25C6FF",null,"Protected (SOCI)"]
[null,{"$f":"INDEX(dms_TradingNameFull_List,MATCH(dms_TradingName,dms_TradingName_List))","v":"AusNet Transmission Group Pty Limited"},null,null,null,"#FFCCCC",null,"Confidential"]
[null,{"$f":"CONCATENATE(\"REGULATORY PERIOD FROM \", FRCP_y1,\" TO \",dms_MultiYear_FinalYear_Result)","v":"REGULATORY PERIOD FROM 2027-28 TO 2031-32"},null,null,null,"12.5% Grey",null,"Amended"]
[null,"7.4 SHARED ASSETS",null,null,null,"#FFCCCC & \n12.5% Grey",null,"Amended Confidential"]
[]
[]
[null,"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",{"$f":"CONCATENATE(\"REVENUE  ($0's, real \", dms_DollarReal,\")\")","v":"REVENUE  ($0's, real March 2027)"}]
[null,null,null,{"$f":"dms_y4","v":"2025-26"},{"$f":"dms_y5","v":"2026-27"},{"$f":"dms_y6","v":"2027-28"},{"$f":"dms_y7","v":"2028-29"},{"$f":"dms_y8","v":"2029-30"},{"$f":"dms_y9","v":"2030-31"},{"$f":"dms_y10","v":"2031-32"},{"$f":"CONCATENATE(\"Total \n\",FRCP_y1, \" to \", dms_MultiYear_FinalYear_Result)","v":"Total \n2027-28 to 2031-32"}]
[null,"HV CT & VT Testing","Yarraville Laboratory, Mobile and fixed Test Equip",1672981.1904000023,1739900.4380160025,1756792.6752782939,1792263.1559601033,1812177.1910263267,1833727.4062709643,1856890.2787712293,{"$f":"SUM(F10:J10)","v":9051850.7073069178}]
[null,"Transformer Testing (incl Condition Monitoring)","Yarraville Laboratory, Mobile and fixed Test Equip ",502183.95760000008,522271.31590400008,527341.91120403889,537989.1955064442,543966.85323429364,550435.64824572857,557388.51959199039,2717122.1277824957]
[null,"Chemical Testing & Analysis","Yarraville Laboratory, laboratory Test Equip",3019533.4312,3140314.7684480003,3170803.2613455537,3234823.2890984355,3270765.7700884184,3309661.3630300104,3351467.6118261795,16337521.295388598]
[null,"Calibration & Electrical Testing (incl NATA accredited) ","Yarraville Laboratory, laboratory Test Equip ",1692121.2256000005,1759806.0746240006,1776891.5704941365,1812767.8574412563,1832909.722523937,1854706.4867917891,1878134.3582038966,9155409.9954550155]
[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",2075927.4300000004,2652258.75,2639383.9805825241,2653837.8571428568,2644623.3796296297,2640751.8963963962,2648396.1782017546,13226993.291953161]
[null,"Leasing Access to third parties – Wireless Base Stations on EHV Towers","170 x EHV towers",7117662.3800000008,7284010.5,7248651.6990291262,7288346.4285714282,7263039.8148148144,7252407.9684684677,7273401.7810087726,36325847.691892609]
[null,"Leasing Access to third parties – Various communication equipment on communication towers","20 x communication towers",2011902.8,2043975.5,2034053.1553398059,2045191.6666666665,2038090.5092592591,2035107.3400900899,2040998.4402850876,10193441.111640908]
[null,"Property Leasing to third parties","Various network properties / sites",1042648.5800000001,1100000,1067961.1650485436,1047619.0476190476,1018518.5185185184,998423.42342342355,1001313.5964912283,5133835.7511007618]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[]
[]
[]
[null,"7.4.2 - SHARED ASSET UNREGULATED SERVICES - APPORTIONMENT METHODOLOGY"]
[null,"Name of shared asset unregulated service for which revenues were apportioned","Apportionment methodology"]
[null,"None","Not applicable"]

{"sheet":"7.5 Large Projects","index":22,"n_rows":93,"n_cols":9,"rows_kept":93,"cut":false,"hidden":false,"merged":[]}
[null,{"$f":"(LOOKUP(dms_Model,dms_Model_List,dms_Worksheet_List))","v":"REGULATORY REPORTING STATEMENT"},null,null,null,"#25C6FF",null,"Protected (SOCI)"]
[null,{"$f":"INDEX(dms_TradingNameFull_List,MATCH(dms_TradingName,dms_TradingName_List))","v":"AusNet Transmission Group Pty Limited"},null,null,null,"#FFCCCC",null,"Confidential"]
[null,{"$f":"CONCATENATE(\"REGULATORY PERIOD FROM \", FRCP_y1,\" TO \",dms_MultiYear_FinalYear_Result)","v":"REGULATORY PERIOD FROM 2027-28 TO 2031-32"},null,null,null,"12.5% Grey",null,"Amended"]
[null,"7.5 LARGE PROJECTS",null,null,null,"#FFCCCC & \n12.5% Grey",null,"Amended Confidential"]
[]
[]
[null,"\n7.5.1 - LARGE PROJECT OPERATING EXPENDITURE"]
[null,null,"EXPENDITURE"]
[null,null,{"$f":"CONCATENATE(\"Forecast  ($0's. real \",dms_DollarReal,\")\")","v":"Forecast  ($0's. real March 2027)"}]
[null,null,{"$f":"dms_y4","v":"2025-26"},{"$f":"dms_y5","v":"2026-27"},{"$f":"dms_y6","v":"2027-28"},{"$f":"dms_y7","v":"2028-29"},{"$f":"dms_y8","v":"2029-30"},{"$f":"dms_y9","v":"2030-31"},{"$f":"dms_y10","v":"2031-32"}]
[null,"PROJECT NAME/ID"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Total ",{"$f":"SUM(C12:C46)","v":0},0,0,0,0,0,0]
[]
[]
[]
[]
[null,"7.5.2 - LARGE PROJECT CAPITAL EXPENDITURE\t\t"]
[null,null,"EXPENDITURE"]
[null,null,{"$f":"CONCATENATE(\"Forecast  ($0's. real \",dms_DollarReal,\")\")","v":"Forecast  ($0's. real March 2027)"}]
[null,null,{"$f":"dms_y4","v":"2025-26"},{"$f":"dms_y5","v":"2026-27"},{"$f":"dms_y6","v":"2027-28"},{"$f":"dms_y7","v":"2028-29"},{"$f":"dms_y8","v":"2029-30"},{"$f":"dms_y9","v":"2030-31"},{"$f":"dms_y10","v":"2031-32"}]
[null,"PROJECT NAME/ID"]
[null,"MLTS CB Replacement",17832272.983715825,19891032.734520122,12207045.168289719,438324.91129844007,0,0,0]
[null,"TSTS - Tx and Switchgear Replacement",15052701.286775254,9122792.6642934103,0,0,0,0,0]
[null,"SHTS Transformer and CB Replacement",14518622.60808414,10506049.138541901,11850621.867262524,7153789.2010325659,0,0,0]
[null,"RCTS Transformer & SwitchgearReplacement",7251747.9464932028,25280082.663782779,21031823.362694528,15222992.947949937,0,0,0]
[null,"SYTS 500kV GIS Replacement",34755376.887408406,16400628.160685407,30084029.057389904,5075323.2814349756,0,0,0]
[null,"KTS 500/220kV Transformer Replacement",14132998.699975291,28692862.347045522,71254626.80384253,71768632.491146162,59714728.575937107,20147882.187427863,11222404.656931253]
[null,"SMTS 500kV GIS and F2 Transformer Replacement",3896535.6427092808,23134609.965127256,24818246.643172052,69145898.167106062,71346674.840109557,63723047.09881869,45227186.948796429]
[null,"SMTS 330/220kV Transformer Replacement",11445438.02006867,30403337.249562398,55855931.052778706,49523970.560283713,0,0,0]
[null,"NPSD 220kV GIS ",0,0,3101477.0395307234,19126786.611897498,48915899.04548768,49417031.223539524,37509177.734165959]
[null,"South West Network Comms Replacement",3237026.1951778862,7024322.8780318853,12507835.200395836,1154103.2038304408,0,0,0]
[null,"Transmission Insulator Replacement",13018593.665496031,20540059.050730467,22117.325536301327,0,0,0,0]
[null,"T624 to T628B HYTS-APD tower replacement",28059680.474308006,32456476.785942174,448642.2074399346,0,0,0,0]
[null,"Portland tower replacement - Stage 2",1943250.5509662523,19900112.581515543,88469302.145205289,94676706.440473169,0,0,0]
[null,"SOCI - Security Fencing",2371704.8684311565,12501005.762478292,17784051.841445833,7516700.3343539378,14469155.691925567,10568708.124401703,8022002.5696297409]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Total",{"$f":"SUM(C57:C92)","v":167515949.82960942},255853371.98225716,349435749.71498382,340803228.1508069,194446458.15345991,143856668.63418776,101980771.90952338]

{"sheet":"7.9 STPIS","index":23,"n_rows":10,"n_cols":6,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[null,{"$f":"(LOOKUP(dms_Model,dms_Model_List,dms_Worksheet_List))","v":"REGULATORY REPORTING STATEMENT"},null,"#25C6FF","Protected (SOCI)"]
[null,{"$f":"INDEX(dms_TradingNameFull_List,MATCH(dms_TradingName,dms_TradingName_List))","v":"AusNet Transmission Group Pty Limited"},null,"#FFCCCC","Confidential"]
[null,{"$f":"CONCATENATE(\"REGULATORY PERIOD FROM \", FRCP_y1,\" TO \",dms_MultiYear_FinalYear_Result)","v":"REGULATORY PERIOD FROM 2027-28 TO 2031-32"},null,"12.5% Grey","Amended"]
[null,"7.9 SERVICE TARGET PERFORMANCE INCENTIVE SCHEME (STPIS)",null,"#FFCCCC & \n12.5% Grey","Amended Confidential"]
[]
[]
[]
[null,"7.9.3 – NETWORK LIMIT INFORMATION"]
[null,"Limit definition","Define limit  ","Reason for the limit ","Is limit addressed by priority project","Supporting information reference"]
[null,"Not required","Not required","Not required","Not required"]

{"sheet":"8.2 Capex","index":24,"n_rows":61,"n_cols":4,"rows_kept":61,"cut":false,"hidden":false,"merged":[[8,2,8,3]]}
[null,{"$f":"(LOOKUP(dms_Model,dms_Model_List,dms_Worksheet_List))","v":"REGULATORY REPORTING STATEMENT"},"#25C6FF","Protected (SOCI)"]
[null,{"$f":"INDEX(dms_TradingNameFull_List,MATCH(dms_TradingName,dms_TradingName_List))","v":"AusNet Transmission Group Pty Limited"},"#FFCCCC","Confidential"]
[null,{"$f":"CONCATENATE(\"REGULATORY PERIOD FROM \", FRCP_y1,\" TO \",dms_MultiYear_FinalYear_Result)","v":"REGULATORY PERIOD FROM 2027-28 TO 2031-32"},"12.5% Grey","Amended"]
[null,"8.2 - CAPEX","#FFCCCC & \n12.5% Grey","Amended Confidential"]
[]
[null,"8.2.7 - IMMEDIATE EXPENSING OF CAPEX"]
[null,"ESTIMATED - AS COMMISSIONED"]
[null,null,"EXPENDITURE"]
[null,null,{"$f":"CONCATENATE(\"$0's, real \", dms_DollarReal)","v":"$0's, real March 2027"}]
[null,"Asset class",{"$f":"dms_y4","v":"2025-26"},{"$f":"dms_y5","v":"2026-27"}]
[null,"Secondary",1188809.1829250001,{"$f":"'[8]TAB input'!L72*10^6","v":1522800.9500000002}]
[null,"Switchgear",2081414.945575,{"$f":"'[8]TAB input'!L73*10^6","v":2330378.7000000002}]
[null,"Transformers",1929252.1272500001,{"$f":"'[8]TAB input'!L74*10^6","v":4004556.4000000004}]
[null,"Reactive",44874.751950000005,{"$f":"'[8]TAB input'!L75*10^6","v":66060.05}]
[null,"Towers and Conductor",5795103.0124749923,{"$f":"'[8]TAB input'!L76*10^6","v":3572615.85}]
[null,"Establishment",1079005.9239749999,{"$f":"'[8]TAB input'!L77*10^6","v":1317332.4500000002}]
[null,"Communications",1149497.6659250001,{"$f":"'[8]TAB input'!L78*10^6","v":1493850.2000000002}]
[null,"IT",498951.4873000001,{"$f":"'[8]TAB input'!L80*10^6","v":684100}]
[null,"Polymeric Insulators",635800.41157500003,{"$f":"'[8]TAB input'!L91*10^6","v":977344.65}]
[null,"In-house software",796430.11682500003,{"$f":"'[8]TAB input'!L120*10^6","v":2076834.25}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Total",{"$f":"SUM(C11:C60)","v":15199139.625774993},{"$f":"SUM(D11:D60)","v":18045873.5}]

{"sheet":"AER CF","index":25,"n_rows":76,"n_cols":25,"rows_kept":76,"cut":false,"hidden":true,"merged":[[41,38,41,59],[41,69,41,90],[3,1,3,22],[39,38,39,59],[39,69,39,90],[40,38,40,59],[40,69,40,90]]}
[null,"AER CONDITIONAL FORMATTING"]
[]
[null,"CELLS FLAGED \"Y\" and greyed out will be greyed out in the worksheets."]
[null,"CONDITIONAL FORMATTING MAP"]
[null,null,null,null,null,"=INDEX(dms_CF_3.6.1, MATCH(dms_TradingName,dms_CF_TradingName))=\"Y\"","=INDEX(dms_CF_3.6.5, MATCH(dms_TradingName,dms_CF_TradingName))=\"Y\"","=INDEX(dms_CF_3.6.6.1, MATCH(dms_TradingName,dms_CF_TradingName))=\"Y\"","=INDEX(dms_CF_3.6.6.2, MATCH(dms_TradingName,dms_CF_TradingName))=\"Y\"","=INDEX(dms_CF_3.6.6.3, MATCH(dms_TradingName,dms_CF_TradingName))=\"Y\"","=INDEX(dms_CF_3.6.7.1, MATCH(dms_TradingName,dms_CF_TradingName))=\"Y\"","=INDEX(dms_CF_3.6.7.2, MATCH(dms_TradingName,dms_CF_TradingName))=\"Y\"","=INDEX(dms_CF_3.6.7.3, MATCH(dms_TradingName,dms_CF_TradingName))=\"Y\"","=INDEX(dms_CF_3.6.7.4, MATCH(dms_TradingName,dms_CF_TradingName))=\"Y\"","=INDEX(dms_CF_3.6.8, MATCH(dms_TradingName,dms_CF_TradingName))=\"Y\"","=INDEX(dms_CF_4.1, MATCH(dms_TradingName,dms_CF_TradingName))=\"Y\"","=INDEX(dms_CF_6.8, MATCH(dms_TradingName,dms_CF_TradingName))=\"Y\"","=INDEX(dms_CF_7.12, MATCH(dms_TradingName,dms_CF_TradingName))=\"Y\"","=INDEX(dms_CF_8.1_A, MATCH(dms_TradingName,dms_CF_TradingName))=\"Y\"","=INDEX(dms_CF_8.1_B, MATCH(dms_TradingName,dms_CF_TradingName))=\"Y\"",{"$f":"INDEX(dms_CF_8.1_Neg, MATCH(dms_TradingName,dms_CF_TradingName))=\"Y\"","v":true},"=INDEX(dms_CF_4.4.1_Neg, MATCH(dms_TradingName,dms_CF_TradingName))=\"Y\"",null,null,"=INDEX(dms_CF_F10, MATCH(dms_TradingName,dms_CF_TradingName))=\"Y\""]
[null,"dms_CF_TradingName","JurisdictionList","Sector","Segment","dms_CF_3.6.1","dms_CF_3.6.5","dms_CF_3.6.6.1","dms_CF_3.6.6.2","dms_CF_3.6.6.3","dms_CF_3.6.7.1","dms_CF_3.6.7.2","dms_CF_3.6.7.3","dms_CF_3.6.7.4","dms_CF_3.6.8","dms_CF_4.1","dms_CF_6.8 (set from dms_MAIFI_flag)","dms_CF_7.12","dms_CF_8.1_A  (and 8.4)","dms_CF_8.1_B  (and 8.4)","dms_CF_8.1_Neg  (and 8.4)","dms_CF_4.4.1","dms_CF_MAIFI_flag (set from dms_MAIFI_flag)","9.5 TUOS (set from Jurisdiction)","dms_CF_F10"]
[null,"Amadeus","NT","Gas","Transmission","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-"]
[null,"APA GasNet","Vic","Gas","Transmission","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-"]
[null,"Ausgrid","NSW","Electricity","Distribution",null,"Y","N","N","N","N","N","N","Y","N","N",{"$f":"IFERROR(IF(dms_MAIFI_flag=\"Yes\",\"N\",\"Y\"),\"Y\")","v":"Y"},"Y","N","Y","Y","N",{"$f":"IFERROR(LEFT(dms_MAIFI_flag),\"N\")","v":"N"},{"$f":"IF('AER CF'!$C7=\"Vic\",\"Y\",\"N\")","v":"N"}]
[null,"Ausgrid (Tx Assets)","NSW","Electricity","Distribution",null,"Y","N","N","N","N","N","N","Y","N","N",{"$f":"IFERROR(IF(dms_MAIFI_flag=\"Yes\",\"N\",\"Y\"),\"Y\")","v":"Y"},"Y","N","Y","Y","N",{"$f":"IFERROR(LEFT(dms_MAIFI_flag),\"N\")","v":"N"},{"$f":"IF('AER CF'!$C8=\"Vic\",\"Y\",\"N\")","v":"Y"}]
[null,"AusNet (D)","Vic","Electricity","Distribution",null,"N","N",null,null,"N","N","N","N","N","N",{"$f":"IFERROR(IF(dms_MAIFI_flag=\"Yes\",\"N\",\"Y\"),\"Y\")","v":"Y"},"N","N","N","Y","N",{"$f":"IFERROR(LEFT(dms_MAIFI_flag),\"N\")","v":"N"},{"$f":"IF('AER CF'!$C9=\"Vic\",\"Y\",\"N\")","v":"N"}]
[null,"AusNet Services Tx","Vic","Electricity","Transmission",null,"N",null,null,null,"N","N","N","N","N","Y",{"$f":"IFERROR(IF(dms_MAIFI_flag=\"Yes\",\"N\",\"Y\"),\"Y\")","v":"Y"},"N","N","N","Y","N",{"$f":"IFERROR(LEFT(dms_MAIFI_flag),\"N\")","v":"N"},{"$f":"IF('AER CF'!$C10=\"Vic\",\"Y\",\"N\")","v":"N"}]
[null,"Australian Distribution Co.","NSW","Electricity","Distribution","N","N","N","N",null,"N","N","N","N","N","N",{"$f":"IFERROR(IF(dms_MAIFI_flag=\"Yes\",\"N\",\"Y\"),\"Y\")","v":"Y"},"N","N","N","N","N",{"$f":"IFERROR(LEFT(dms_MAIFI_flag),\"N\")","v":"N"},{"$f":"IF('AER CF'!$C13=\"Vic\",\"Y\",\"N\")","v":"N"}]
[null,"Australian Distribution Co. (Vic)","Vic","Electricity","Distribution","N","N","N","N",null,"N","N","N","N","N","N",{"$f":"IFERROR(IF(dms_MAIFI_flag=\"Yes\",\"N\",\"Y\"),\"Y\")","v":"Y"},"N","N","N","N","N",{"$f":"IFERROR(LEFT(dms_MAIFI_flag),\"N\")","v":"N"},{"$f":"IF('AER CF'!$C14=\"Vic\",\"Y\",\"N\")","v":"Y"}]
[null,"CitiPower","Vic","Electricity","Distribution",null,"N","N",null,null,"N","N","N","N","N","N",{"$f":"IFERROR(IF(dms_MAIFI_flag=\"Yes\",\"N\",\"Y\"),\"Y\")","v":"Y"},"N","N","N","Y","N",{"$f":"IFERROR(LEFT(dms_MAIFI_flag),\"N\")","v":"N"},{"$f":"IF('AER CF'!$C15=\"Vic\",\"Y\",\"N\")","v":"Y"}]
[null,"Directlink","Qld","Electricity","Transmission",null,"N",null,null,null,"N","N","N","N","N","-",{"$f":"IFERROR(IF(dms_MAIFI_flag=\"Yes\",\"N\",\"Y\"),\"Y\")","v":"Y"},"N","N","Y","Y","N",{"$f":"IFERROR(LEFT(dms_MAIFI_flag),\"N\")","v":"N"},{"$f":"IF('AER CF'!$C16=\"Vic\",\"Y\",\"N\")","v":"N"}]
[null,"ElectraNet","SA","Electricity","Transmission",null,"N",null,null,null,"N","N","N","N","N","-",{"$f":"IFERROR(IF(dms_MAIFI_flag=\"Yes\",\"N\",\"Y\"),\"Y\")","v":"Y"},"N","N","Y","Y","N",{"$f":"IFERROR(LEFT(dms_MAIFI_flag),\"N\")","v":"N"},{"$f":"IF('AER CF'!$C17=\"Vic\",\"Y\",\"N\")","v":"N"}]
[null,"Endeavour Energy","NSW","Electricity","Distribution",null,"Y","N","Y","Y","N","N","N","Y","N","N",{"$f":"IFERROR(IF(dms_MAIFI_flag=\"Yes\",\"N\",\"Y\"),\"Y\")","v":"Y"},"Y","N","Y","Y","Y",{"$f":"IFERROR(LEFT(dms_MAIFI_flag),\"N\")","v":"N"},{"$f":"IF('AER CF'!$C18=\"Vic\",\"Y\",\"N\")","v":"N"}]
[null,"Energex","Qld","Electricity","Distribution",null,"Y","N",null,null,"N","N","N","N","N","N",{"$f":"IFERROR(IF(dms_MAIFI_flag=\"Yes\",\"N\",\"Y\"),\"Y\")","v":"Y"},"Y","N","Y","Y","Y",{"$f":"IFERROR(LEFT(dms_MAIFI_flag),\"N\")","v":"N"},{"$f":"IF('AER CF'!$C19=\"Vic\",\"Y\",\"N\")","v":"N"}]
[null,"Ergon Energy","Qld","Electricity","Distribution",null,"Y","N","Y","Y","N","N","N","N","N","N",{"$f":"IFERROR(IF(dms_MAIFI_flag=\"Yes\",\"N\",\"Y\"),\"Y\")","v":"Y"},"Y","N","Y","Y","N",{"$f":"IFERROR(LEFT(dms_MAIFI_flag),\"N\")","v":"N"},{"$f":"IF('AER CF'!$C20=\"Vic\",\"Y\",\"N\")","v":"N"}]
[null,"Essential Energy","NSW","Electricity","Distribution",null,"Y","N","Y","Y","N","N","N","Y","N","N",{"$f":"IFERROR(IF(dms_MAIFI_flag=\"Yes\",\"N\",\"Y\"),\"Y\")","v":"Y"},"Y","N","Y","Y","N",{"$f":"IFERROR(LEFT(dms_MAIFI_flag),\"N\")","v":"N"},{"$f":"IF('AER CF'!$C21=\"Vic\",\"Y\",\"N\")","v":"N"}]
[null,"Evoenergy Distribution","ACT","Electricity","Distribution",null,"Y","N","Y","Y","Y","Y","N","Y","N","Y",{"$f":"IFERROR(IF(dms_MAIFI_flag=\"Yes\",\"N\",\"Y\"),\"Y\")","v":"Y"},"Y","N","Y","Y","N",{"$f":"IFERROR(LEFT(dms_MAIFI_flag),\"N\")","v":"N"},{"$f":"IF('AER CF'!$C22=\"Vic\",\"Y\",\"N\")","v":"N"}]
[null,"Evoenergy Distribution (Tx Assets)","ACT","Electricity","Distribution",null,"Y","N","Y","Y","Y","Y","N","Y","N","Y",{"$f":"IFERROR(IF(dms_MAIFI_flag=\"Yes\",\"N\",\"Y\"),\"Y\")","v":"Y"},"Y","N","Y","Y","N",{"$f":"IFERROR(LEFT(dms_MAIFI_flag),\"N\")","v":"N"},{"$f":"IF('AER CF'!$C23=\"Vic\",\"Y\",\"N\")","v":"N"}]
[null,"Jemena Electricity","Vic","Electricity","Distribution",null,"N","N",null,null,"N","N","N","N","N","N",{"$f":"IFERROR(IF(dms_MAIFI_flag=\"Yes\",\"N\",\"Y\"),\"Y\")","v":"Y"},"N","N","N","Y","N",{"$f":"IFERROR(LEFT(dms_MAIFI_flag),\"N\")","v":"N"},{"$f":"IF('AER CF'!$C25=\"Vic\",\"Y\",\"N\")","v":"Y"}]
[null,"JGN","Vic","Gas","Distribution","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-"]
[null,"Murraylink","SA","Electricity","Transmission",null,"N",null,null,null,"N","N","N","N","N","-",{"$f":"IFERROR(IF(dms_MAIFI_flag=\"Yes\",\"N\",\"Y\"),\"Y\")","v":"Y"},"N","N","Y","Y","N",{"$f":"IFERROR(LEFT(dms_MAIFI_flag),\"N\")","v":"N"},{"$f":"IF('AER CF'!$C26=\"Vic\",\"Y\",\"N\")","v":"N"}]
[null,"Power and Water","NT","Electricity","Distribution",null,"N","N",null,null,"N","Y","N","N","N","Y",{"$f":"IFERROR(IF(dms_MAIFI_flag=\"Yes\",\"N\",\"Y\"),\"Y\")","v":"Y"},"Y","Y","Y","Y","N",{"$f":"IFERROR(LEFT(dms_MAIFI_flag),\"N\")","v":"N"},{"$f":"IF('AER CF'!$C27=\"Vic\",\"Y\",\"N\")","v":"N"}]
[null,"Powercor Australia","Vic","Electricity","Distribution",null,"N","N",null,null,"N","N","N","N","N","N",{"$f":"IFERROR(IF(dms_MAIFI_flag=\"Yes\",\"N\",\"Y\"),\"Y\")","v":"Y"},"N","N","N","Y","N",{"$f":"IFERROR(LEFT(dms_MAIFI_flag),\"N\")","v":"N"},{"$f":"IF('AER CF'!$C28=\"Vic\",\"Y\",\"N\")","v":"Y"}]
[null,"Powerlink","Qld","Electricity","Transmission",null,"N",null,null,null,"N","N","N","N","N","-",{"$f":"IFERROR(IF(dms_MAIFI_flag=\"Yes\",\"N\",\"Y\"),\"Y\")","v":"Y"},"N","N","Y","Y","N",{"$f":"IFERROR(LEFT(dms_MAIFI_flag),\"N\")","v":"N"},{"$f":"IF('AER CF'!$C29=\"Vic\",\"Y\",\"N\")","v":"N"}]
[null,"Roma to Brisbane Pipeline","Qld","Gas","Transmission","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-"]
[null,"SA Power Networks","SA","Electricity","Distribution",null,"Y","N",null,null,"N","N","N","N","N","N",{"$f":"IFERROR(IF(dms_MAIFI_flag=\"Yes\",\"N\",\"Y\"),\"Y\")","v":"Y"},"Y","N","Y","N","N",{"$f":"IFERROR(LEFT(dms_MAIFI_flag),\"N\")","v":"N"},{"$f":"IF('AER CF'!$C31=\"Vic\",\"Y\",\"N\")","v":"N"}]
[null,"TasNetworks (D)","Tas","Electricity","Distribution",null,"Y","N",null,null,"N","N","N","N","N","N",{"$f":"IFERROR(IF(dms_MAIFI_flag=\"Yes\",\"N\",\"Y\"),\"Y\")","v":"Y"},"Y","N","Y","Y","N",{"$f":"IFERROR(LEFT(dms_MAIFI_flag),\"N\")","v":"N"},{"$f":"IF('AER CF'!$C32=\"Vic\",\"Y\",\"N\")","v":"N"}]
[null,"TasNetworks (T)","Tas","Electricity","Transmission",null,"N",null,null,null,"N","N","N","N","N","-",{"$f":"IFERROR(IF(dms_MAIFI_flag=\"Yes\",\"N\",\"Y\"),\"Y\")","v":"Y"},"N","N","Y","Y","N",{"$f":"IFERROR(LEFT(dms_MAIFI_flag),\"N\")","v":"N"},{"$f":"IF('AER CF'!$C33=\"Vic\",\"Y\",\"N\")","v":"N"}]
[null,"TransGrid","NSW","Electricity","Transmission",null,"N",null,null,null,"N","N","N","N","N","-",{"$f":"IFERROR(IF(dms_MAIFI_flag=\"Yes\",\"N\",\"Y\"),\"Y\")","v":"Y"},"N","N","Y","Y","N",{"$f":"IFERROR(LEFT(dms_MAIFI_flag),\"N\")","v":"N"},{"$f":"IF('AER CF'!$C34=\"Vic\",\"Y\",\"N\")","v":"N"}]
[null,"United Energy","Vic","Electricity","Distribution",null,"N","N",null,null,"N","N","N","N","N","N",{"$f":"IFERROR(IF(dms_MAIFI_flag=\"Yes\",\"N\",\"Y\"),\"Y\")","v":"Y"},"N","N","N","Y","N",{"$f":"IFERROR(LEFT(dms_MAIFI_flag),\"N\")","v":"N"},{"$f":"IF('AER CF'!$C35=\"Vic\",\"Y\",\"N\")","v":"Y"}]
[]
[]
[null,"Confidential"]
[null,"Amended"]
[]
[null,"Worksheet 6.2 STPIS reliability"]
[null,"Formula",null,null,null,"Applied to:"]
[]
[null,"=INDEX(dms_CBD_flag,MATCH(dms_TradingName,dms_TradingName_List))=\"NO\"",null,null,null,"$D$11,$D$17,$D$23,$D$33,$D$39,$D$45,$D$55,$D$61,$D$67,$D$77,$D$83,$D$89"]
[null,"=INDEX(dms_Urban_flag,MATCH(dms_TradingName,dms_TradingName_List))=\"NO\"",null,null,null,"$D$12,$D$18,$D$24,$D$56,$D$62,$D$78,$D$68,$D$84"]
[null,"=INDEX(dms_ShortRural_flag,MATCH(dms_TradingName,dms_TradingName_List))=\"NO\"",null,null,null,"$D$13,$D$19,$D$25,$D$57,$D$63,$D$69,$D$79,$D$85"]
[null,"=INDEX(dms_LongRural_flag,MATCH(dms_TradingName,dms_TradingName_List))=\"NO\"",null,null,null,"$D$14,$D$20,$D$26,$D$58,$D$64,$D$65,$D$70,$D$71,$D$80,$D$86"]
[null,"=INDEX(dms_FeederType_5_flag,MATCH(dms_TradingName,dms_TradingName_List))=\"NO\"",null,null,null,"$D$87,$D$81,$D$71,$D$65,$D$59,$D$49,$D$43,$D$37,$D$21,$D$15"]
[null,"=dms_MAIFI_Flag=\"No\"",null,null,null,"$D$55:$D$72"]
[]
[]
[null,"Business & other details"]
[null,"=(INDEX(dms_Model_Span,MATCH(dms_Model,dms_Model_List))>1)"]
[null,"=(INDEX(dms_Model_Span,MATCH(dms_Model,dms_Model_List))=1)"]
[]
[]
[null,"STYLES IN USE"]
[null,"HEADING ONE","dms_1"]
[null,"HEADING TWO","dms_2"]
[null,"HEADING THREE","dms_3"]
[null,"HEADING FOUR","dms_4"]
[null,"HEADING FIVE","dms_5"]
[null,5.1109999999999998,"dms_NUM"]
[null,5.45E-2,"dms_NUM%"]
[null,5.5555000000000003,"dms_NUM3d"]
[null,"Text description","dms_Row_Locked"]
[null,"Text description","dms_Row1"]
[null,"Text description","dms_Row2"]
[null,"Total","dms_T1"]
[null,"Total","dms_T2"]
[null,"EXPENSES","dms_BH"]
[null,2019,"dms_BY1"]
[null,2019,"dms_BY2"]
[null,"VOLUMES","dms_GH"]
[null,2019,"dms_GY1"]
[null,2019,"dms_GY2"]

{"sheet":"AER NRs","index":26,"n_rows":232,"n_cols":16,"rows_kept":232,"cut":false,"hidden":true,"merged":[[4,1,28,1],[32,1,55,1],[33,10,35,10],[33,36,33,57],[33,67,33,88],[34,36,34,57],[34,67,34,88],[35,36,35,57],[35,67,35,88],[36,10,40,10],[44,10,45,10],[65,1,78,1],[84,1,97,1],[100,1,107,1],[110,1,115,1],[118,1,132,1],[195,1,196,1],[199,1,200,1],[208,1,213,1],[135,1,150,1],[152,1,158,1],[160,1,174,1],[176,1,177,1],[179,1,184,1],[191,1,192,1]]}
[null,"AER NAMED RANGES"]
[]
[null,"DROP DOWN SELECTORS USED IN WORKBOOKS"]
[]
[null,"COVER SHEET","dms_DataQuality_List","dms_Confid_status_List"]
[null,null,"-- select --","-- select --"]
[null,null,"Actual","Public"]
[null,null,"Estimate","Confidential"]
[null,null,"Consolidated"]
[]
[]
[null,null,"For all files either AER or business needs to be able to specify the type of submission","For PTRM & RFM templates we must provide a choice in case they change their form of control - otherwise it is drawn from the business specific lookup table above."]
[null,null,"dms_SourceList","dms_FormControl_Choices"]
[null,null,"-- select --","Revenue cap"]
[null,null,"After appeal","Revenue yield"]
[null,null,"Draft decision","Tariff cap"]
[null,null,"Final decision","Weighted average price cap"]
[null,null,"PTRM update 1"]
[null,null,"PTRM update 2"]
[null,null,"PTRM update 3"]
[null,null,"PTRM update 4"]
[null,null,"PTRM update 5"]
[null,null,"PTRM update 6"]
[null,null,"PTRM update 7"]
[null,null,"Reallocated"]
[null,null,"Recast"]
[null,null,"Regulatory proposal"]
[null,null,"Reporting"]
[null,null,"Revised regulatory proposal"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"This is used to create an image to insert on 6.3 STPIS sheet - not for dropdown lists.",null,null,"GAS"]
[null,"CA & RESET RINS \nDNSP","dms_DNSP_020301_SubstationType","dms_DNSP_020301_ProjectType","dms_DNSP_020301_ProjectTrigger","dms_DNSP_020302_ProjectType","dms_DNSP_020302_ProjectTrigger","dms_STPIS_Exclusion_List","dms_Reason_Interruption","dms_Reason_Interruption_Detailed","Reason for interruption",null,null,"dms_N0205_AssetType"]
[null,null,"Subtransmission substation","New substation establishment","Demand growth","New line on new route - single circuit","Demand growth","Weather","Animal","Animal impact","Animal","Animal impact",null,"Cast Iron"]
[null,null,"Zone substation","Substation upgrade - capacity"," Voltage issues","New line on new route - dual circuit"," Voltage issues","Equipment failure","Asset failure","Animal nesting/burrowing, etc and other",null,"Animal nesting/burrowing, etc and other",null,"PVC"]
[null,null,"Switching station","Substation upgrade - voltage"," Reactive power issue","New line on new route - other"," Reactive power issue","Operational error","Other","Other",null,"Other",null,"Polyamide"]
[null,null,"Other","Other"," Fault level issues","Line rebuild over existing route - single circuit"," Fault level issues","Vegetation","Overloads","LV","Asset failure","LV",null,"High density polyethylene (80)"]
[null,null,null,null," Safety","Line rebuild over existing route - dual circuit"," Net market benefit","Animals","Planned","Distribution substation",null,"Distribution substation",null,"High density polyethylene (100)"]
[null,null,null,null," Environment","Reconductor - Single circuit"," Safety","Third party impacts","Network business","HV",null,"HV",null,"High density polyethylene (250)"]
[null,null,null,null," Other","Reconductor - Dual circuit"," Environment","Transmission failure","Third party","Zone substation",null,"Zone substation",null,"High density polyethylene (575)"]
[null,null,null,null,null,"Reconductor - Other"," Other","Load shedding","Unknown","Subtransmission",null,"Subtransmission",null,"Medium density polyethylene"]
[null,null,null,null,null,"Line upgrade - raising/retensoring",null,"Inter-distributor connection failure","Vegetation","insert description of 'other'","Other","insert description of 'other'",null,"Unprotected steel"]
[null,null,null,null,null,"Line upgrade - voltage upgrade",null,"Other","Weather","Network error","Overloads",null,null,"Protected steel"]
[null,null,null,null,null,"Line upgrade - capacity",null,null,"2 - STPIS Exclusion (3.3)(a)","Switching and protection error","Planned",null,null,"Other"]
[null,null,null,null,null,"String spare circuit",null,null,"3 - STPIS Exclusion (3.3)(a)","Fire","Network business","Network error"]
[null,null,null,null,null,"Other",null,null,"4 - STPIS Exclusion (3.3)(a)","Other",null,"Switching and protection error"]
[null,null,null,null,null,null,null,null,"5 - STPIS Exclusion (3.3)(a)","Dig-in","Third party","Fire"]
[null,null,null,null,null,null,null,null,"6 - STPIS Exclusion (3.3)(a)","Unauthorised access",null,"Other"]
[null,null,null,null,null,null,null,null,"7 - STPIS Exclusion (3.3)(a)","Vehicle impact",null,"Dig-in"]
[null,null,null,null,null,null,null,null,null,"Unknown",null,"Unauthorised access"]
[null,null,null,null,null,null,null,null,null,"Blow-in/Fall-in - NSP responsibility",null,"Vehicle impact"]
[null,null,null,null,null,null,null,null,null,"Grow-in - NSP responsibility","Unknown","Unknown"]
[null,null,null,null,null,null,null,null,null,"Blow-in/Fall-in - Other responsible party","Vegetation","Blow-in/Fall-in - NSP responsibility"]
[null,null,null,null,null,null,null,null,null,"Grow-in - Other responsible party",null,"Grow-in - NSP responsibility"]
[null,null,null,null,null,null,null,null,null,null,null,"Blow-in/Fall-in - Other responsible party"]
[null,null,null,null,null,null,null,null,null,null,null,"Grow-in - Other responsible party"]
[null,null,null,null,null,null,null,null,null,null,"Weather"]
[null,null,null,null,null,null,null,null,null,null,"2 - STPIS Exclusion (3.3)(a)"]
[null,null,null,null,null,null,null,null,null,null,"3 - STPIS Exclusion (3.3)(a)"]
[null,null,null,null,null,null,null,null,null,null,"4 - STPIS Exclusion (3.3)(a)"]
[null,null,null,null,null,null,null,null,null,null,"5 - STPIS Exclusion (3.3)(a)"]
[null,null,null,null,null,null,null,null,null,null,"6 - STPIS Exclusion (3.3)(a)"]
[null,null,null,null,null,null,null,null,null,null,"7 - STPIS Exclusion (3.3)(a)"]
[]
[]
[null,"CA & RESET RINS \nTNSP ","dms_TNSP_0203_SubstationType","dms_TNSP_020301_ProjectType","dms_TNSP_020301_ProjectTrigger","dms_TNSP_020302_ProjectType","dms_TNSP_0203_ProjectTrigger"]
[null,null,"Terminal station","New substation establishment","Demand growth","New line on new route - single circuit","Demand growth"]
[null,null,"Switching station","Capacity upgrade"," Voltage issues","New line on new route - dual circuit"," Voltage issues"]
[null,null,"Transmission substation","Voltage upgrade"," Reactive power issue","New line on new route - other"," Reactive power issue"]
[null,null,"Other","Other"," Fault level issues","Line rebuild over existing route - single circuit"," Fault level issues"]
[null,null,null,null,"Net market benefit","Line rebuild over existing route - dual circuit"," Net market benefit"]
[null,null,null,null," Safety","Reconductor - Single circuit"," Safety"]
[null,null,null,null," Environment","Reconductor - Dual circuit"," Environment"]
[null,null,null,null," Other","Reconductor - Other"," Other"]
[null,null,null,null,null,"Line upgrade - raising/retensoring"]
[null,null,null,null,null,"Line upgrade - voltage upgrade"]
[null,null,null,null,null,"Line upgrade - capacity"]
[null,null,null,null,null,"String spare circuit"]
[null,null,null,null,null,"Other"]
[]
[]
[]
[null,"NAMED RANGES USED IN ETL PROCESS"]
[null,null,null,null,null,null,null,null,null,null,null,null,"GAS ARR & RESET"]
[null,"CA & RESET RINS \nDNSP ONLY","dms_020303_01_UOM","dms_020501_01_UOM","dms_020501_02_UOM","dms_020501_03_UOM","dms_020501_04_UOM","dms_020701_01_UOM","dms_020701_02_UOM","dms_020701_01_Rows","dms_040102_01_UOM","dms_040102_04_UOM","dms_S140101_UOM","dms_S140201_UOM","dms_E050201_UOM","dms_E050202_UOM"]
[null,null,"Circuit line length in km","0's","0's","0's","0's","km","km","Route line length within zone","0's","days","number","number per km","per metre per connection","metres per connection"]
[null,null,"Circuit line length in km","0's","0's","0's","0's","0's","0's","Number of maintenance spans","0's","0's","number","number","per service per connection","number per connection"]
[null,null,"Circuit line length in km","MVA added","MVA added","MVA added","MVA added","km","km","Total length of maintenance spans","0's","$0s","number","number","number per connection","number per connection"]
[null,null,"Circuit line length in km","0's","0's","0's","0's","km","km","Length of vegetation corridors","$0s","0's","km"]
[null,null,"Number","total spend $0s","total spend $0s","total spend $0s","total spend $0s","0's","0's","Average number of trees per maintenance span"]
[null,null,"Number","net circuit km added","net circuit km added","net circuit km added","net circuit km added","years","years","Average frequency of cutting cycle"]
[null,null,"Number","total spend $0s","total spend $0s","total spend $0s","total spend $0s"]
[null,null,null,"net circuit km added","net circuit km added","net circuit km added","net circuit km added"]
[null,null,null,"total spend $0s","total spend $0s","total spend $0s","total spend $0s"]
[null,null,null,"0's",null,"$0s"]
[null,null,null,"0's"]
[null,null,null,"0's"]
[null,null,null,"$0s"]
[]
[]
[null,"CA & RESET RINS \nTNSP ONLY","dms_020701_01_UOM"]
[null,null,"km"]
[null,null,"0's"]
[null,null,"km"]
[null,null,"0's"]
[null,null,"km"]
[null,null,"metres"]
[null,null,"years"]
[]
[]
[null,"CA & RESET RINS \nDNSP & TNSP","dms_020603_01_UOM"]
[null,null,"0's"]
[null,null,"0's"]
[null,null,"0's"]
[null,null,"0's"]
[null,null,"(per cent)"]
[]
[]
[null,"EB & RESET RINS \nDNSP ONLY","dms_030601_01_UOM","dms_030601_02_UOM","dms_030701_01_UOM","dms_030702_01_UOM","dms_030703_01_UOM"]
[null,null,"minutes/customer","minutes/customer","Customer / km","%","km"]
[null,null,"minutes/customer","minutes/customer","MWh/customer","Number of spans"]
[null,null,"interruptions/customer","interruptions/customer","kVA / customer","Number of spans"]
[null,null,"interruptions/customer","interruptions/customer",null,"Number of spans"]
[null,null,null,null,null,"Number of spans"]
[null,null,null,null,null,"Years"]
[null,null,null,null,null,"Years"]
[null,null,null,null,null,"Trees"]
[null,null,null,null,null,"Trees"]
[null,null,null,null,null,"Defects"]
[null,null,null,null,null,"Defects"]
[null,null,null,null,null,"Spans"]
[null,null,null,null,null,"km"]
[null,null,null,null,null,"Spans"]
[]
[null,null,"WHEN INSERTING COVER SHEET INTO A TNSP FILE - APPLY THESE NAMED RANGES"]
[null,"EB & RESET RINS \nTNSP ONLY","dms_030601_01_UOM",null,"dms_030701_01_UOM","dms_030702_01_UOM"]
[null,null,"%",null,"Number of spans","km"]
[null,null,"number",null,"Years","%"]
[null,null,"number",null,"Trees","km"]
[null,null,"%",null,"Defects","number"]
[null,null,"number",null,"Number of spans"]
[null,null,"number",null,"km"]
[null,null,"%",null,"km"]
[null,null,"number",null,"Number of spans"]
[null,null,"number"]
[null,null,"%"]
[null,null,"number"]
[null,null,"%"]
[null,null,"number"]
[null,null,"%"]
[null,null,"number"]
[]
[null,"EB & RESET RINS \nDNSP & TNSP","dms_EB_RAB_PIT"]
[null,null,"Beginning of year"]
[null,null,"End of year"]
[null,null,"End of year"]
[null,null,"End of year"]
[null,null,"End of year"]
[null,null,"End of year"]
[]
[null,"ARR \nDNSP ONLY","dms_030605_UOM","dms_03060703_UOM","dms_E020202_UOM","Spare"]
[null,null,"number","number","Length of mains replaced"]
[null,null,"number","number","Number of services replaced"]
[null,null,"number","number"]
[null,null,"number","number"]
[null,null,"number","(per cent)"]
[null,null,"number"]
[null,null,"number"]
[null,null,"number"]
[null,null,"number"]
[null,null,"number"]
[null,null,"number"]
[null,null,"number"]
[null,null,"(per cent)"]
[null,null,"(per cent)",""]
[]
[null,"RFM","dms_Beg","dms_Mid","dms_End"]
[null,null,"Beginning of year","Mid year","End of Year"]
[]
[null,"PTRM","dms_PTRM_RAB_PIT","dms_PTRM_TAB_PIT","DMS_Xfactor"]
[null,null,"Beginning of year","Beginning of year","x factors"]
[null,null,"End of year","End of year"]
[null,null,"End of year","End of year"]
[null,null,"End of year","End of year"]
[null,null,"End of year"]
[]
[]
[null,"STPIS & MIC NAMED RANGES "]
[]
[null,"These \"row descriptions\" are the column headings in the various templates but become row descriptions in the ETL process"]
[]
[null,"Table 6.3 sustained interruptions - row descriptions","dms_060301_CustNo_Affected_Row","dms_060301_Avg_Duration_Sustained_Int_Row","dms_060301_Effect_unplanned_SAIDI_Row","dms_060301_Effect_unplanned_SAIFI_Row"]
[null,null,"Number of customers affected by the interruption","Average duration of sustained customer interruption","Effect on unplanned SAIDI","Effect on unplanned SAIFI"]
[]
[]
[null,"Table 6.1 telephone answering - row descriptions and start date","dms_060101_Rows","dms_060102_Rows","dms_060101_StartDateTxt"]
[null,null,"Total number of calls \n(after removing excluded events)","Number of calls answered within 30 seconds \n(after excluding excluded events) ",{"$f":"dms_060701_StartDateTxt","v":"1-Jul-2020"}]
[]
[]
[null,"Table 6.8.1 - row descriptions","dms_060801_01_Rows","dms_060801_02_Rows","dms_060801_03_Rows","dms_060801_04_Rows"]
[null,null,"Number of interruptions","Duration of interruptions","Total unplanned minutes off supply","Effect on unplanned MAIFI"]
[]
[]
[null,"Table 7.9.4 - market impact component - row descriptions","dms_070904_01_Rows","without exclusions","with exclusions"]
[]
[]
[null,"These headings (Lists) are determined from the INDEX/MATCH function on the NSP selected on the Business & other details sheet"]
[]
[null,"Table 6.7.1 - daily performance data - unplanned - MAIFI  -- row descriptions and header named range values","dms_060701_Feeder_Header_Lvl4",{"$f":"INDEX(dms_FeederName_1,MATCH(dms_TradingName,dms_TradingName_List))","v":"CBD"},{"$f":"INDEX(dms_FeederName_1,MATCH(dms_TradingName,dms_TradingName_List))","v":"CBD"},{"$f":"INDEX(dms_FeederName_2,MATCH(dms_TradingName,dms_TradingName_List))","v":"Urban"},{"$f":"INDEX(dms_FeederName_2,MATCH(dms_TradingName,dms_TradingName_List))","v":"Urban"},{"$f":"INDEX(dms_FeederName_3,MATCH(dms_TradingName,dms_TradingName_List))","v":"Short rural"},{"$f":"INDEX(dms_FeederName_3,MATCH(dms_TradingName,dms_TradingName_List))","v":"Short rural"},{"$f":"INDEX(dms_FeederName_4,MATCH(dms_TradingName,dms_TradingName_List))","v":"Long rural"},{"$f":"INDEX(dms_FeederName_4,MATCH(dms_TradingName,dms_TradingName_List))","v":"Long rural"},{"$f":"IF((INDEX(dms_FeederName_5,MATCH(dms_TradingName,dms_TradingName_List))=0),\"Network\",(INDEX(dms_FeederName_5,MATCH(dms_TradingName,dms_TradingName_List))))","v":"Network"},{"$f":"IF((INDEX(dms_FeederName_5,MATCH(dms_TradingName,dms_TradingName_List))=0),\"Network\",(INDEX(dms_FeederName_5,MATCH(dms_TradingName,dms_TradingName_List))))","v":"Network"},"Network","Network"]
[]
[null,null,"dms_060701_Rows","All events","After removing excluded events","All events","After removing excluded events","All events","After removing excluded events","All events","After removing excluded events","All events","After removing excluded events","All events","After removing excluded events"]
[null,null,null,"the number of column headings changes from 10 to 12 depending on the number of feeder categories for the NSP"]
[]
[null,null,"dms_0603_FeederList",{"$f":"INDEX(dms_FeederName_1,MATCH(dms_TradingName,dms_TradingName_List))","v":"CBD"},{"$f":"INDEX(dms_FeederName_2,MATCH(dms_TradingName,dms_TradingName_List))","v":"Urban"},{"$f":"INDEX(dms_FeederName_3,MATCH(dms_TradingName,dms_TradingName_List))","v":"Short rural"},{"$f":"INDEX(dms_FeederName_4,MATCH(dms_TradingName,dms_TradingName_List))","v":"Long rural"}]
[]
[]
[null,"Use these to add to specific worksheets in existing files","Use these to add to specific worksheets in existing files"]
[]
[]
[null,"ARRs 6.7 STPIS daily performance","dms_060101_Values","dms_060102_Values","dms_060701_Values"]
[null,null,"dms_LeapYear"]
[]
[]
[null,"ARR's  6.8 STPIS exclusions","dms_060801_Event_Date","dms_060801_OutageID","dms_060801_FeederID","dms_060801_FeederClass","dms_060801_CauseID","dms_060801_01_Values","dms_060801_02_Values","dms_060801_03_Values","dms_060801_Excl_Cat","dms_060801_04_Values"]
[null,null,"dms_060801_StartCell"]
[]
[]
[null,"CA 6.3 sustained interruptions","dms_060301_Event_Date","dms_060301_Event_Time","dms_060301_AssetID","dms_060301_FeederClass","dms_060301_Reason","dms_060301_DetailedReason","dms_060301_CustNo_Affected_Values","dms_060301_Avg_Duration_Sustained_Int_Values","dms_060301_Effect_unplanned_SAIDI_Values","dms_060301_Effect_unplanned_SAIFI_Values","dms_060301_MED"]
[]
[]
[]
[null,"PTRM input sheet","DMS_50_01_01a","DMS_50_01_01aa","DMS_50_01_01b","DMS_50_01_01bb","DMS_50_01_01c","DMS_50_01_01d","DMS_50_01_01dd"]

{"sheet":"AER lookups","index":27,"n_rows":98,"n_cols":36,"rows_kept":98,"cut":false,"hidden":true,"merged":[[19,1,19,4],[4,24,4,34],[5,24,5,27],[5,29,5,33],[5,34,7,34]]}
[null,"AER LOOKUP TABLES"]
[]
[null,"Template number",5]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FOR ELECTRICITY BUSINESSES ONLY"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Feeder Types",null,null,null,"TasNetworks (D)","Feeder Names"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CBD","Urban","Short rural","long rural","EXTRA"]
[null,"dms_TradingName_List","dms_TradingNameFull_List","dms_ABN_List","dms_JurisdictionList","dms_Sector_List","dms_Segment_List","dms_FormControl_List","dms_RPT_List","dms_RPTMonth_List","dms_CRCPlength_List","dms_FRCPlength_List","dms_PRCPlength_List","dms_663_List","dms_Addr1_List","dms_Addr2_List","dms_Suburb_List","dms_State_List","dms_PostCode_List","dms_PAddr1_List","dms_PAddr2_List","dms_PSuburb_List","dms_PState_List","dms_PPostCode_List","dms_CBD_flag","dms_Urban_flag","dms_ShortRural_flag","dms_LongRural_flag","dms_FeederType_5_flag","dms_FeederName_1","dms_FeederName_2","dms_FeederName_3","dms_FeederName_4","dms_FeederName_5","dms_Public_Lighting_List","Name"]
[null,"AusNet (T)","AusNet Transmission Group Pty Limited",78079798173,"VIC","Electricity","Transmission","Revenue cap","Financial","March",5,5,5,5,null,null,null,"Vic",3000,null,null,null,"VIC",null,"NO","NO","NO","NO","NO","CBD","Urban","Short rural","Long rural",null,"NO",{"$f":"B10","v":"AusNet (T)"}]
[null,"Australian Transmission Co.","Australian Transmission Co.",11222333444,"NSW","Electricity","Transmission","Revenue cap","Financial","June",5,5,5,5,"123 Straight Street",null,"SYDNEY","NSW",2000,"PO Box 123",null,"SYDNEY","NSW",2000,"NO","NO","NO","NO","NO","CBD","Urban","Short rural","Long rural",null,"NO",{"$f":"B11","v":"Australian Transmission Co."}]
[null,"Directlink","Directlink",16779340889,"Qld","Electricity","Transmission","Revenue cap","Financial","June",5,5,5,5,"Level 25","580 George Street","SYDNEY","NSW",2000,"PO Box R41",null,"ROYAL EXCHANGE","NSW",1225,"NO","NO","NO","NO","NO","CBD","Urban","Short rural","Long rural",null,"NO","Directlink"]
[null,"Murraylink","Murraylink",79181207909,"SA","Electricity","Transmission","Revenue cap","Financial","June",5,5,5,5,"Level 19","580 George Street","SYDNEY","NSW",2000,"PO Box R41",null,"ROYAL EXCHANGE","NSW",1225,"NO","NO","NO","NO","NO","CBD","Urban","Short rural","Long rural",null,"NO","Murraylink"]
[null,"TasNetworks (T)","TasNetworks (T)",24167357299,"Tas","Electricity","Transmission","Revenue cap","Financial","June",5,5,5,5,"1-7 Maria Street",null,"LENAH VALLEY","Tas",7008,"PO Box 606",null,"MOONAH","Tas",7009,"NO","NO","NO","NO","NO","CBD","Urban","Short rural","Long rural",null,"NO","TasNetworks (T)"]
[null,"TransGrid","NSW Electricity Networks Operations Pty Ltd trading as TransGrid","70 250 995 390","NSW","Electricity","Transmission","Revenue cap","Financial","June",5,5,4,5,"180 Thomas Street",null,"SYDNEY","NSW",2000,"PO Box A1000",null,"SYDNEY SOUTH","NSW",1235,"NO","NO","NO","NO","NO","CBD","Urban","Short rural","Long rural",null,"NO","TransGrid"]
[]
[]
[]
[]
[null,"The Reg Year Ending (dms_RYE) must be set to the last year of the regulatory period. For forecast data is is usually (FRCP_y5) for actual it is a single year (CRY). For historical actual data the RYE will need to be set manually in the business details sheet by setting the dms_Multiyear_flag to 1 and putting the correct value in 'dms_Specified_FinalYear. See cells C67:C68"]
[null,"dms_Model_List ","dms_Model_Name_Format1","dms_Worksheet_List","dms_Model_Span_List"]
[null,"ARR","Annual Reporting",{"$f":"IF(dms_MultiYear_ResponseFlag=\"yes\",\"NEW HISTORICAL ANNUAL REPORTING\",\"ANNUAL REPORTING\")","v":"ANNUAL REPORTING"},1]
[null,"CA","Category Analysis",{"$f":"IF(dms_MultiYear_ResponseFlag=\"yes\",\"NEW HISTORICAL CATEGORY ANALYSIS\",\"CATEGORY ANALYSIS\")","v":"CATEGORY ANALYSIS"},1]
[null,"CESS","Capitlal Expenditure","CAPITLAL EXPENDITURE SHARING SCHEMING",5]
[null,"CPI","CPI","CPI",5]
[null,"EB","Economic Benchmarking",{"$f":"IF(dms_MultiYear_ResponseFlag=\"yes\",\"NEW HISTORICAL ECONOMIC BENCHMARKING\",\"ECONOMIC BENCHMARKING\")","v":"ECONOMIC BENCHMARKING"},1]
[null,"EBSS","Efficiency Benefit Sharing Scheme","EFFICIENCY BENEFIT SHARING SCHEME",5]
[null,"Pricing","Pricing Proposal","PRICING PROPOSAL",5]
[null,"Profitability","Profitability","PROFITABILITY",5]
[null,"PTRM","Post Tax Revenue Model","POST TAX REVENUE MODEL",5]
[null,"Reset","Regulatory Reporting (Reset)","REGULATORY REPORTING STATEMENT",5]
[null,"RFM","Roll Forward Model","ROLL FORWARD MODEL",5]
[null,"WACC","Weighted Average Cost of Capital","WEIGHTED AVERAGE COST OF CAPITAL",1]
[]
[]
[]
[null,"Financial","Calendar",null,"PREVIOUS",null,"CURRENT",null,"FORTHCOMING"]
[null,"1987-88",1988,"PRCP_y1",{"$f":"INDEX(INDIRECT(dms_RPT),dms_PRCP_start_row)","v":"2017-18"},"CRCP_y1",{"$f":"INDEX(INDIRECT(dms_RPT),dms_CRCP_start_row)","v":"2022-23"},{"$f":"FRCP_y1","v":"2027-28"},{"$f":"INDEX(INDIRECT(dms_RPT),dms_FRCP_start_row)","v":"2027-28"}]
[null,"1988-89",1989,"PRCP_y2",{"$f":"INDEX(INDIRECT(dms_RPT),dms_PRCP_start_row+1)","v":"2018-19"},"CRCP_y2",{"$f":"INDEX(INDIRECT(dms_RPT),dms_CRCP_start_row+1)","v":"2023-24"},"FRCP_y2",{"$f":"INDEX(INDIRECT(dms_RPT),dms_FRCP_start_row+1)","v":"2028-29"}]
[null,"1989-90",1990,"PRCP_y3",{"$f":"INDEX(INDIRECT(dms_RPT),dms_PRCP_start_row+2)","v":"2019-20"},"CRCP_y3",{"$f":"INDEX(INDIRECT(dms_RPT),dms_CRCP_start_row+2)","v":"2024-25"},"FRCP_y3",{"$f":"INDEX(INDIRECT(dms_RPT),dms_FRCP_start_row+2)","v":"2029-30"}]
[null,"1990-91",1991,"PRCP_y4",{"$f":"INDEX(INDIRECT(dms_RPT),dms_PRCP_start_row+3)","v":"2020-21"},"CRCP_y4",{"$f":"INDEX(INDIRECT(dms_RPT),dms_CRCP_start_row+3)","v":"2025-26"},"FRCP_y4",{"$f":"INDEX(INDIRECT(dms_RPT),dms_FRCP_start_row+3)","v":"2030-31"}]
[null,"1991-92",1992,"PRCP_y5",{"$f":"INDEX(INDIRECT(dms_RPT),dms_PRCP_start_row+4)","v":"2021-22"},"CRCP_y5",{"$f":"INDEX(INDIRECT(dms_RPT),dms_CRCP_start_row+4)","v":"2026-27"},"FRCP_y5",{"$f":"INDEX(INDIRECT(dms_RPT),dms_FRCP_start_row+4)","v":"2031-32"}]
[null,"1992-93",1993,"PRCP_y6",{"$f":"INDEX(INDIRECT(dms_RPT),dms_PRCP_start_row+5)","v":"2022-23"},"CRCP_y6",{"$f":"INDEX(INDIRECT(dms_RPT),dms_CRCP_start_row+5)","v":"2027-28"},"FRCP_y6",{"$f":"INDEX(INDIRECT(dms_RPT),dms_FRCP_start_row+5)","v":"2032-33"}]
[null,"1993-94",1994,"PRCP_y7",{"$f":"INDEX(INDIRECT(dms_RPT),dms_PRCP_start_row+6)","v":"2023-24"},"CRCP_y7",{"$f":"INDEX(INDIRECT(dms_RPT),dms_CRCP_start_row+6)","v":"2028-29"},"FRCP_y7",{"$f":"INDEX(INDIRECT(dms_RPT),dms_FRCP_start_row+6)","v":"2033-34"}]
[null,"1994-95",1995,"PRCP_y8",{"$f":"INDEX(INDIRECT(dms_RPT),dms_PRCP_start_row+7)","v":"2024-25"},"CRCP_y8",{"$f":"INDEX(INDIRECT(dms_RPT),dms_CRCP_start_row+7)","v":"2029-30"},"FRCP_y8",{"$f":"INDEX(INDIRECT(dms_RPT),dms_FRCP_start_row+7)","v":"2034-35"}]
[null,"1995-96",1996,"PRCP_y9",{"$f":"INDEX(INDIRECT(dms_RPT),dms_PRCP_start_row+8)","v":"2025-26"},"CRCP_y9",{"$f":"INDEX(INDIRECT(dms_RPT),dms_CRCP_start_row+8)","v":"2030-31"},"FRCP_y9",{"$f":"INDEX(INDIRECT(dms_RPT),dms_FRCP_start_row+8)","v":"2035-36"}]
[null,"1996-97",1997,"PRCP_y10",{"$f":"INDEX(INDIRECT(dms_RPT),dms_PRCP_start_row+9)","v":"2026-27"},"CRCP_y10",{"$f":"INDEX(INDIRECT(dms_RPT),dms_CRCP_start_row+9)","v":"2031-32"},"FRCP_y10",{"$f":"INDEX(INDIRECT(dms_RPT),dms_FRCP_start_row+9)","v":"2036-37"}]
[null,"1997-98",1998,"PRCP_y11",{"$f":"INDEX(INDIRECT(dms_RPT),dms_PRCP_start_row+10)","v":"2027-28"},"CRCP_y11",{"$f":"INDEX(INDIRECT(dms_RPT),dms_CRCP_start_row+10)","v":"2032-33"},"FRCP_y11",{"$f":"INDEX(INDIRECT(dms_RPT),dms_FRCP_start_row+10)","v":"2037-38"}]
[null,"1998-99",1999,"PRCP_y12",{"$f":"INDEX(INDIRECT(dms_RPT),dms_PRCP_start_row+11)","v":"2028-29"},"CRCP_y12",{"$f":"INDEX(INDIRECT(dms_RPT),dms_CRCP_start_row+11)","v":"2033-34"},"FRCP_y12",{"$f":"INDEX(INDIRECT(dms_RPT),dms_FRCP_start_row+11)","v":"2038-39"}]
[null,"1999-00",2000,"PRCP_y13",{"$f":"INDEX(INDIRECT(dms_RPT),dms_PRCP_start_row+12)","v":"2029-30"},"CRCP_y13",{"$f":"INDEX(INDIRECT(dms_RPT),dms_CRCP_start_row+12)","v":"2034-35"},"FRCP_y13",{"$f":"INDEX(INDIRECT(dms_RPT),dms_FRCP_start_row+12)","v":"2039-40"}]
[null,"2000-01",2001,"PRCP_y14",{"$f":"INDEX(INDIRECT(dms_RPT),dms_PRCP_start_row+13)","v":"2030-31"},"CRCP_y14",{"$f":"INDEX(INDIRECT(dms_RPT),dms_CRCP_start_row+13)","v":"2035-36"},"FRCP_y14",{"$f":"INDEX(INDIRECT(dms_RPT),dms_FRCP_start_row+13)","v":"2040-41"}]
[null,"2001-02",2002,"PRCP_y15",{"$f":"INDEX(INDIRECT(dms_RPT),dms_PRCP_start_row+14)","v":"2031-32"},"CRCP_y15",{"$f":"INDEX(INDIRECT(dms_RPT),dms_CRCP_start_row+14)","v":"2036-37"},"FRCP_y15",{"$f":"INDEX(INDIRECT(dms_RPT),dms_FRCP_start_row+14)","v":"2041-42"}]
[null,"2002-03",2003,"PRCP_y16",{"$f":"INDEX(INDIRECT(dms_RPT),dms_PRCP_start_row+15)","v":"2032-33"},"CRCP_y16",{"$f":"INDEX(INDIRECT(dms_RPT),dms_CRCP_start_row+15)","v":"2037-38"},"FRCP_y16",{"$f":"INDEX(INDIRECT(dms_RPT),dms_FRCP_start_row+15)","v":"2042-43"}]
[null,"2003-04",2004]
[null,"2004-05",2005]
[null,"2005-06",2006,null,"CRY - FRY"]
[null,"2006-07",2007,"dms_y1",{"$f":"IFERROR(INDEX(INDIRECT(dms_RPT),dms_CRY_start_row),0)","v":"2022-23"}]
[null,"2007-08",2008,"dms_y2",{"$f":"IFERROR(INDEX(INDIRECT(dms_RPT),dms_CRY_start_row+1),0)","v":"2023-24"}]
[null,"2008-09",2009,"dms_y3",{"$f":"IFERROR(INDEX(INDIRECT(dms_RPT),dms_CRY_start_row+2),0)","v":"2024-25"}]
[null,"2009-10",2010,"dms_y4",{"$f":"IFERROR(INDEX(INDIRECT(dms_RPT),dms_CRY_start_row+3),0)","v":"2025-26"}]
[null,"2010-11",2011,"dms_y5",{"$f":"IFERROR(INDEX(INDIRECT(dms_RPT),dms_CRY_start_row+4),0)","v":"2026-27"}]
[null,"2011-12",2012,"dms_y6",{"$f":"IFERROR(INDEX(INDIRECT(dms_RPT),dms_CRY_start_row+5),0)","v":"2027-28"}]
[null,"2012-13",2013,"dms_y7",{"$f":"IFERROR(INDEX(INDIRECT(dms_RPT),dms_CRY_start_row+6),0)","v":"2028-29"}]
[null,"2013-14",2014,"dms_y8",{"$f":"IFERROR(INDEX(INDIRECT(dms_RPT),dms_CRY_start_row+7),0)","v":"2029-30"}]
[null,"2014-15",2015,"dms_y9",{"$f":"IFERROR(INDEX(INDIRECT(dms_RPT),dms_CRY_start_row+8),0)","v":"2030-31"}]
[null,"2015-16",2016,"dms_y10",{"$f":"IFERROR(INDEX(INDIRECT(dms_RPT),dms_CRY_start_row+9),0)","v":"2031-32"}]
[null,"2016-17",2017,"dms_y11",{"$f":"IFERROR(INDEX(INDIRECT(dms_RPT),dms_CRY_start_row+10),0)","v":"2032-33"}]
[null,"2017-18",2018,"dms_y12",{"$f":"IFERROR(INDEX(INDIRECT(dms_RPT),dms_CRY_start_row+11),0)","v":"2033-34"}]
[null,"2018-19",2019,"dms_y13",{"$f":"IFERROR(INDEX(INDIRECT(dms_RPT),dms_CRY_start_row+12),0)","v":"2034-35"}]
[null,"2019-20",2020,"dms_y14",{"$f":"IFERROR(INDEX(INDIRECT(dms_RPT),dms_CRY_start_row+13),0)","v":"2035-36"}]
[null,"2020-21",2021,"dms_y15",{"$f":"IFERROR(INDEX(INDIRECT(dms_RPT),dms_CRY_start_row+14),0)","v":"2036-37"}]
[null,"2021-22",2022,"dms_y16",{"$f":"IFERROR(INDEX(INDIRECT(dms_RPT),dms_CRY_start_row+15),0)","v":"2037-38"}]
[null,"2022-23",2023]
[null,"2023-24",2024]
[null,"2024-25",2025]
[null,"2025-26",2026]
[null,"2026-27",2027]
[null,"2027-28",2028]
[null,"2028-29",2029]
[null,"2029-30",2030]
[null,"2030-31",2031]
[null,"2031-32",2032]
[null,"2032-33",2033]
[null,"2033-34",2034]
[null,"2034-35",2035]
[null,"2035-36",2036]
[null,"2036-37",2037]
[null,"2037-38",2038]
[null,"2038-39",2039]
[null,"2039-40",2040]
[null,"2040-41",2041]
[null,"2041-42",2042]
[null,"2042-43",2043]
[null,"2043-44",2044]
[null,"2044-45",2045]
[null,"2045-46",2046]
[null,"2046-47",2047]
[null,"2047-28",2048]

{"sheet":"AER ETL","index":28,"n_rows":146,"n_cols":10,"rows_kept":146,"cut":false,"hidden":true,"merged":[[12,0,16,0],[13,4,13,8],[15,2,15,4],[19,0,26,0],[27,0,32,0],[35,0,60,0],[35,37,35,58],[35,68,35,89],[33,37,33,58],[72,1,74,1],[33,68,33,89],[34,37,34,58],[34,68,34,89]]}
[null,"AER ETL INFORMATION"]
[]
[null,"USES NAMED RANGES FLAG","yes","dms_Defined_Names_Used"]
[]
[null,"IF THIS IS AN ABC RIN - make sure the the named range CRY is applied and the named range dms_dollar_nom_UOM is applied"]
[null,"IF THIS IS A RESET RIN - make sure the named ranges CRY and dms_dollar_nom_UOM are NOT present in the workbook"]
[null,"FOR ABC RINS THAT SPAN MULTIPLE YEARS - make sure MultiYear Flag is set and final year entered as required"]
[]
[null,"Full trading name",{"$f":"INDEX(dms_TradingNameFull_List,MATCH(dms_TradingName,dms_TradingName_List))","v":"AusNet Transmission Group Pty Limited"},null,"dms_TradingNameFull"]
[null,"Trading name",{"$f":"dms_TradingName","v":"AusNet (T)"}]
[null,"Unique ID","ETTVIC200","dms_UID"]
["Selected here","Model / RIN","Reset","dms_Model"]
["Read from Business & other details","Source","Regulatory proposal","dms_Source",{"$f":"IF(dms_Model=\"Reset\", \"You have chosen Reset - make sure you have set Reg Proposal as source\",\"\")","v":"You have chosen Reset - make sure you have set Reg Proposal as source"}]
[null,"Data quality","Consolidated","For DB purposes this is always Consoldiated"]
[null,"Data status","Public","\"See \"& \" - For DB purposes this is always Public\""]
[null,"Amendment reason",{"$f":"dms_Amendment_Text","v":"."},null,null,"dms_AmendmentReason"]
[null,"Submission date",{"$f":"dms_Typed_Submission_Date","v":"dd/mm/yy"},"dms_SubmissionDate"]
[]
["Redundant","EBSS - First application of scheme in forthcoming period?","No"]
["Pre-populated from lookup table","Data ingestion data quality","Consolidated","dms_DataQuality","Always Consolidated"]
[null,"Sector",{"$f":"INDEX(dms_Sector_List,MATCH(dms_TradingName,dms_TradingName_List))","v":"Electricity"},"dms_Sector","=INDEX(dms_Sector_List,MATCH(dms_TradingName,dms_TradingName_List))"]
[null,"Segment",{"$f":"INDEX(dms_Segment_List,MATCH(dms_TradingName,dms_TradingName_List))","v":"Transmission"},"dms_Segment","=INDEX(dms_Segment_List,MATCH(dms_TradingName,dms_TradingName_List))"]
[null,"Regulatory Year Ending",{"$f":"IF(dms_MultiYear_Flag=1,LEFT(dms_Specified_FinalYear,2)&RIGHT(dms_Specified_FinalYear,2),dms_RYE_result)","v":"2032"},"dms_RYE","=IF(dms_MultiYear_Flag=1,LEFT(dms_Specified_FinalYear,2)&RIGHT(dms_Specified_FinalYear,2),dms_RYE_result)"]
[null,"Reporting Period Type","Financial","dms_RPT","=INDEX(dms_RPT_List,MATCH(dms_TradingName,dms_TradingName_List))"]
[null,"EB/CA Unit of Measure for Monetary Values","$0s","dms_dollar_nom_UOM",{"$f":"IF(dms_SingleYearModel=\"yes\",\"This is set to an historical template (EB, CA or ARR), apply UOM Named Range to cell !\",\"This is not an historical template, make sure UOM Named Range is not applied\")","v":"This is not an historical template, make sure UOM Named Range is not applied"},null,null,null,null,{"$f":"IFERROR(dms_dollar_nom_UOM, \"NR not applied\")","v":"NR not applied"}]
[null,"Security Classification","Public","dms_Classification","Always Public"]
[null,"Jurisdiction",{"$f":"INDEX(dms_JurisdictionList,MATCH(dms_TradingName,dms_TradingName_List))","v":"VIC"},"dms_Jurisdiction","=INDEX(dms_JurisdictionList,MATCH(dms_TradingName,dms_TradingName_List))"]
["Relevant for PTRM, RFMs and Reset RINS","$ REAL REFERENCES"]
[null,"Does the named range CRY exist in this file? ",{"$f":"IFERROR(CRY,\"NO\")","v":"2022-23"}]
[null,"CRY-1  (last full calendar year before CRY)",{"$f":"IFERROR(IF(dms_RPT=\"calendar\",CRY-1,LEFT(CRY,4)),\"CRY not present\")","v":"2022"},"dms_Cal_Year_B4_CRY","'=IF(dms_RPT=\"financial\",VALUE(LEFT(dms_SingleYear_FinalYear_Result,4)),VALUE(LEFT(dms_SingleYear_FinalYear_Result,4)-1))"]
[null,"Dollar $ real month",{"$f":"INDEX(dms_RPTMonth_List,MATCH(dms_TradingName,dms_TradingName_List))","v":"March"},"dms_RPTMonth","=INDEX(dms_RPTMonth_List,MATCH(dms_TradingName,dms_TradingName_List))"]
[null,"Dollar $ real  (the last month before the FRCP_y1)",{"$f":"IF(dms_Model=\"RFM\",dms_DollarReal_Prev, IF(dms_SingleYearModel=\"yes\",CONCATENATE(dms_RPTMonth)&\" \"&VALUE((LEFT(dms_CRY_start_year,2)&RIGHT(dms_CRY_start_year,2))),CONCATENATE(dms_RPTMonth)&\" \"&dms_DollarReal_year))","v":"March 2027"},"dms_DollarReal","=IF(dms_Model=\"RFM\",dms_DollarReal_Prev, IF(dms_SingleYearModel=\"yes\",CONCATENATE(dms_RPTMonth)&\" \"&VALUE((LEFT(dms_CRY_start_year,2)&RIGHT(dms_CRY_start_year,2))),CONCATENATE(dms_RPTMonth)&\" \"&dms_DollarReal_year))"]
[null,"Dollar $ real previous year (PRCP_y5)",{"$f":"CONCATENATE(dms_RPTMonth)&\" \"&dms_Previous_DollarReal_year","v":"March 2022"},"dms_DollarReal_Prev","=IF(SUM(dms_SingleYear_Model)>0,CONCATENATE(dms_RPTMonth)&\" \"&VALUE(((LEFT(CRY,2))&RIGHT(CRY,2))-1),CONCATENATE(dms_RPTMonth)&\" \"&VALUE(((LEFT(dms_CRCP_FirstYear_Result,2)&RIGHT(dms_CRCP_FirstYear_Result,2))))-1)"]
[null,"PTRM/ RFMs"]
[null,"Form of control",{"$f":"INDEX(dms_FormControl_List,MATCH(dms_TradingName,dms_TradingName_List))","v":"Revenue cap"},"dms_FormControl","=INDEX(dms_FormControl_List,MATCH(dms_TradingName,dms_TradingName_List))"]
["All potential values for Regulatory Years or RYEs as calculated","This block works out the various RYE's for ALL RIN types and MODELS"]
[null,"dms_start_year",{"$f":"FRCP_y1","v":"2027-28"},"=FRCP_y1","FRCP_y1 from cover sheet"]
[null,"dms_CRY_start_year",{"$f":"IFERROR(CRY,CRCP_y4)","v":"2022-23"},"=IFERROR(CRY,CRCP_y4)"]
[null,"dms_CRY_start_row",{"$f":"IFERROR(MATCH(dms_CRY_start_year,INDIRECT(dms_RPT),0),0)","v":36},"=IFERROR(MATCH(dms_CRY_start_year,INDIRECT(dms_RPT),0),0)"]
[null,"dms_FRCP_start_row",{"$f":"MATCH(dms_start_year,INDIRECT(dms_RPT),0)","v":41},"=MATCH(dms_start_year,INDIRECT(dms_RPT),0)","Uses FRCP_y1 as a start reference"]
[null,"dms_CRCP_start_row",{"$f":"dms_FRCP_start_row-dms_CRCPlength_Num","v":36},"=dms_FRCP_start_row-dms_CRCPlength_Num","Uses the value in dms_CRCPlength_Num"]
[null,"dms_PRCP_start_row",{"$f":"dms_FRCP_start_row-dms_CRCPlength_Num-dms_PRCPlength_Num","v":31},"=dms_FRCP_start_row-dms_CRCPlength_Num-dms_PRCPlength_Num","Uses the value in dms_CRCPlength_Num and dms_PRCPlength_Num"]
[null,"dms_RYE_start_row",{"$f":"dms_FRCP_start_row+(dms_FRCPlength_Num-1)","v":45},"=dms_FRCP_start_row+(dms_FRCPlength_Num-1)","Uses the value in dms_FRCPlength_Num-1"]
[null,"FRCP_start_year",{"$f":"INDEX(INDIRECT(dms_RPT),dms_FRCP_start_row)","v":"2027-28"},"=INDEX(INDIRECT(dms_RPT),dms_FRCP_start_row)","Converts the FRCP start row to display the year"]
[null,"CRCP_start_year",{"$f":"INDEX(INDIRECT(dms_RPT),dms_CRCP_start_row)","v":"2022-23"},"=INDEX(INDIRECT(dms_RPT),dms_CRCP_start_row)","Converts the CRCP start row to display the year"]
[null,"PRCP_start_year",{"$f":"INDEX(INDIRECT(dms_RPT),dms_PRCP_start_row)","v":"2017-18"},"=INDEX(INDIRECT(dms_RPT),dms_PRCP_start_row)","Converts the PRCP start row to display the year"]
[null,"FRCP_final_year",{"$f":"INDEX(INDIRECT(dms_RPT),dms_FRCP_start_row+dms_FRCPlength_Num-1)","v":"2031-32"},"=INDEX(INDIRECT(dms_RPT),dms_FRCP_start_row+dms_FRCPlength_Num-1)","Finds the FRCP final year"]
[null,"CRCP_final_year",{"$f":"INDEX(INDIRECT(dms_RPT),dms_CRCP_start_row+dms_CRCPlength_Num-1)","v":"2026-27"},"=INDEX(INDIRECT(dms_RPT),dms_CRCP_start_row+dms_CRCPlength_Num-1)","Finds the CRCP final year"]
[null,"PRCP_final_year",{"$f":"INDEX(INDIRECT(dms_RPT),dms_PRCP_start_row+dms_FRCPlength_Num-1)","v":"2021-22"},"=INDEX(INDIRECT(dms_RPT),dms_PRCP_start_row+dms_FRCPlength_Num-1)","Finds the PRCP final year"]
[null,"dms_Reset_final_year",{"$f":"INDEX(INDIRECT(dms_RPT),dms_RYE_start_row)","v":"2031-32"},"=INDEX(INDIRECT(dms_RPT),dms_RYE_start_row)","For Resets and PTRM/RFMs (same as FRCP_final_year)"]
[null,"dms_SpecifiedYear_final_year",{"$f":"FRY","v":"2022-23"},"=FRY","FRY from cover sheet"]
[null,"dms_DollarReal_year",{"$f":"LEFT(CRCP_final_year,2)&RIGHT(CRCP_final_year,2)","v":"2027"},"=LEFT(CRCP_final_year,2)&RIGHT(CRCP_final_year,2)","Uses the value in CRCP_final_year"]
[null,"dms_Previous_DollarReal_year",{"$f":"LEFT(PRCP_final_year,2)&RIGHT(PRCP_final_year,2)","v":"2022"},"=LEFT(PRCP_final_year,2)&RIGHT(PRCP_final_year,2)","Uses the value in PRCP_final_year"]
[null,"dms_CRY_RYE",{"$f":"IFERROR(LEFT(CRY,2)&RIGHT(CRY,2),0)","v":"2023"},"=IFERROR(LEFT(CRY,2)&RIGHT(CRY,2),0)","For ABC single year RINS"]
[null,"dms_Reset_RYE",{"$f":"IF(dms_Model_Span>1,IF(dms_Model=\"RFM\",(LEFT(dms_DollarReal_year,2)&RIGHT(dms_DollarReal_year,2)),(LEFT(dms_Reset_final_year,2)&RIGHT(dms_Reset_final_year,2))),0)","v":"2032"},"=IF(dms_Model_Span>1,IF(dms_Model=\"RFM\",(LEFT(dms_DollarReal_year,2)&RIGHT(dms_DollarReal_year,2)),(LEFT(dms_Reset_final_year,2)&RIGHT(dms_Reset_final_year,2))),0)","If model span > 1 then uses dms_Reset_RYE otherwise it's a multi year ABC and uses dms_Specified_RYE"]
[null,"dms_Specified_RYE",{"$f":"IF(dms_MultiYear_ResponseFlag=\"Yes\",(LEFT(dms_Specified_FinalYear,2)&RIGHT(dms_Specified_FinalYear,2)),0)","v":0},"=IF(dms_MultiYear_ResponseFlag=\"Yes\",(LEFT(dms_Specified_FinalYear,2)&RIGHT(dms_Specified_FinalYear,2)),0)","If multi year ABC - uses dms_Specified_FinalYear"]
[null,"dms_Model_Span",{"$f":"INDEX(dms_Model_Span_List,MATCH(dms_Model,dms_Model_List))","v":5},"=INDEX(dms_Model_Span_List,MATCH(dms_Model,dms_Model_List))","A result of 5 is used to signify that it is more than 1 year span"]
[null,"dms_RYE_result",{"$f":"IF(dms_MultiYear_ResponseFlag=\"yes\",dms_Specified_RYE,(IF(dms_Model_Span>1,dms_Reset_RYE,dms_CRY_RYE)))","v":"2032"},"=IF(dms_MultiYear_ResponseFlag=\"yes\",dms_Specified_RYE,(IF(dms_Model_Span>1,dms_Reset_RYE,dms_CRY_RYE)))","Nested IF - feeds into dms_RYE"]
[null,"dms_Reset_Span",{"$f":"IF(dms_Reset_RYE>0,CONCATENATE(FRCP_y1,\" to \",FRCP_final_year),0)","v":"2027-28 to 2031-32"},"=IF(dms_Reset_RYE>0,CONCATENATE(FRCP_y1,\" to \",FRCP_final_year),0)","Reset span of years as text"]
[null,"dms_SpecifiedYear_Span",{"$f":"IF(dms_Specified_RYE>0,CONCATENATE(CRY,\" to \",dms_Specified_FinalYear),0)","v":0},"=IF(dms_Specified_RYE>0,CONCATENATE(CRY,\" to \",dms_Specified_FinalYear),0)","Multi year ABC span of years as text"]
[null,"dms_Header_Span",{"$f":"IF(dms_MultiYear_Flag=1,dms_SpecifiedYear_Span,IF(dms_Model_Span>1,dms_y1&\" to \"&FRCP_final_year,CRY))","v":"2022-23 to 2031-32"},"=IF(dms_MultiYear_Flag=1,dms_SpecifiedYear_Span,IF(dms_Model_Span>1,dms_Reset_Span,CRY))","NESTED IF - for Sheet Headers"]
[null,"ABC RINS THAT SPAN MULTIPLE YEARS"]
[null,"This is a multi year ABC RIN?","No"]
[null,null,{"$f":"IF(dms_MultiYear_ResponseFlag=\"No\",0,1)","v":0},"dms_MultiYear_Flag","This is set from the answer provided above"]
[null,null,{"$f":"IF(dms_MultiYear_Flag=1,FRY,\"not a Multiple year submission\")","v":"not a Multiple year submission"},"dms_Specified_FinalYear","The result here is returned to dms_CRCP_FinalYear_Result if response to Q in C73 is \"yes\" and dms_MultiYear_Flag is set to 1"]
[null," Start year for 5.2 in Multi year ABC RINS",{"$f":"IFERROR(IF(dms_MultiYear_Flag=1,FRY,CRY),\"not an ABC\")","v":"2022-23"},"dms_0502_Inst_Year","=IF(dms_MultiYear_Flag=1,FRY,CRY)",null,"For single year RINS this is CRY - multi year RINS need to start a the end of the span of years (ie. FRY)"]
[null,"WHAT IS THE RYE?"]
[null,"Reg Period Lengths"]
[null,"PRCP length in years",{"$f":"INDEX(dms_PRCPlength_List,MATCH(dms_TradingName,dms_TradingName_List))","v":5},"dms_PRCPlength_Num","=INDEX(dms_PRCPlength_List,MATCH(dms_TradingName,dms_TradingName_List))"]
[null,"CRCP length in years",{"$f":"INDEX(dms_CRCPlength_List,MATCH(dms_TradingName,dms_TradingName_List))","v":5},"dms_CRCPlength_Num","=INDEX(dms_CRCPlength_List,MATCH(dms_TradingName,dms_TradingName_List))"]
[null,"FRCP length in years",{"$f":"INDEX(dms_FRCPlength_List,MATCH(dms_TradingName,dms_TradingName_List))","v":5},"dms_FRCPlength_Num","=INDEX(dms_FRCPlength_List,MATCH(dms_TradingName,dms_TradingName_List))"]
[null,"Single year RIN?"]
[null,"Single Year ABC RIN ?",{"$f":"IF(dms_Model=\"EB\",1,0)","v":0},"dms_EB"]
[null,null,{"$f":"IF(dms_Model=\"CA\",1,0)","v":0},"dms_CA","=dms_SingleYear_Model"]
[null,null,{"$f":"IF(dms_Model=\"ARR\",1,0)","v":0},"dms_ARR"]
[null,"Is this a single Year ABC RIN?",{"$f":"IF(SUM(dms_SingleYear_Model)=1,\"yes\",\"no\")","v":"no"},"dms_SingleYearModel","=IF(SUM(dms_SingleYear_Model)=1,\"yes\",\"no\")"]
[null,"Single Year Final Year Result",{"$f":"IF(AND(dms_SingleYearModel=\"yes\",dms_MultiYear_Flag=0),CRY,0)","v":0},"dms_SingleYear_FinalYear_Result","=IFERROR(IF(SUM(dms_SingleYear_Model)<>0,(INDIRECT(dms_SingleYear_FinalYear_Ref)),\"not a single year RIN\"),\"CRY not present\")"]
[null,"Multi year RIN?"]
[]
[null,"Multi Year Reset/Model?",{"$f":"IF(dms_Model_Span>1,\"yes\",\"no\")","v":"yes"}]
[null,"Final year result for Reset/Model",{"$f":"IF(dms_Model_Span>1,dms_Reset_final_year,0)","v":"2031-32"},"dms_MultiYear_FinalYear_Result","dms_CRCP_FinalYear_Result"]
[]
[null,"Multi Year ABC RIN?",{"$f":"IF(dms_MultiYear_Flag=1,\"yes\",\"no\")","v":"no"},"dms_MultiYear_ABC_RIN"]
[null,"Final year result for ABC multi year",{"$f":"IF(dms_MultiYear_Flag=1,C51,0)","v":0}]
[]
[null,"EB RINS"]
[null,"Calendar Year for table 3.6 data",{"$f":"IFERROR(IF(dms_Segment=\"Transmission\",dms_Cal_Year_B4_CRY,CRY),\"CRY not present\")","v":"2022"},"dms_0306_Year","=IF(dms_Segment=\"Transmission\",dms_Cal_Year_B4_CRY,CRY)"]
[null,"CA RINS"]
[null,"Find how many rows in tables 6.3 sustained interruptions?",null,null,"dms_060301_MaxRows only returns a valid value when cover sheet is attached to a CA file"]
[null,null,{"$f":"IF(dms_Model<>\"CA\",\"not a CA\",\"Is a CA\")","v":"not a CA"},null,"=IF(dms_Model<>\"CA\",\"not a CA\",\"Is a CA\")"]
[null,"dms_060301_Avg_Duration_Sustained_Int_Values present?",{"$f":"IFERROR(IF(INDEX(dms_060301_Avg_Duration_Sustained_Int_Values,1,1)<>\"\",\"yes\",\"no\"),\"no\")","v":"no"},"dms_060301_checkvalue","=IFERROR(IF(INDEX(dms_060301_Avg_Duration_Sustained_Int_Values,1,1)<>\"\",\"yes\",\"no\"),\"no\")"]
[null,null,{"$f":"IF(AND(dms_Model=\"CA\",(dms_060301_checkvalue=\"no\")),\"error - NR not present\",\"no errors\")","v":"no errors"},null,"=IF(AND(dms_Model=\"CA\",(dms_060301_checkvalue=\"no\")),\"error - NR not present\",\"no errors\")"]
[null,"Table 6.3.1 - last row reference",{"$f":"IFERROR(IF(dms_Model=\"CA\",LOOKUP(2,1/(dms_060301_Avg_Duration_Sustained_Int_Values<>\"\"),(ROW(dms_060301_Avg_Duration_Sustained_Int_Values))),\"not a CA\"),\"6.3 not present\")","v":"not a CA"},"dms_060301_LastRow","=IFERROR(IF(dms_Model=\"CA\",LOOKUP(2,1/(dms_060301_Avg_Duration_Sustained_Int_Values<>\"\"),(ROW(dms_060301_Avg_Duration_Sustained_Int_Values))),\"not a CA\"),\"6.3 not present\")"]
[null,"Table 6.3.1 - max number rows",{"$f":"IFERROR(IF(dms_Model=\"CA\",(dms_060301_LastRow-15),\"not a CA\"),\"error\")","v":"not a CA"},"dms_060301_MaxRows","=IFERROR(IF(dms_Model=\"CA\",(dms_060301_LastRow-15),\"not a CA\"),\"error\")"]
[null,"Table 6.6.3 - Public lighting repair - no. business days",{"$f":"INDEX(dms_663_List,MATCH(dms_TradingName,dms_TradingName_List))","v":5},"dms_663","=INDEX(dms_663_List,MATCH(dms_TradingName,dms_TradingName_List))"]
[null,"ARR or RESET RINS"]
[null,"How many rows in tables 6.1 or 6.7?  (leap year?)","insert dms_LeapYear NR if required",null,"'dms_LeapYear is used to determine dms_060701_Max_Rows BUT it is only found on worksheet 6.1 or 6.7 and the date value in the cell is used to determine whether it is a leap year"]
[null,"Is dms_LeapYear named range present?",{"$f":"IFERROR(IF(dms_LeapYear,\"yes\"),\"no\")","v":"no"}]
[null,"Table 6.7.1 - includes a leap year?",{"$f":"\nIFERROR(IF(MONTH(DATE(YEAR(dms_LeapYear),2,29))=2,\"is a leap year\",\"not a leap year\"),\n\"dms_LeapYear not present\")","v":"dms_LeapYear not present"},"dms_LeapYear_Result","=IFERROR(IF(MONTH(DATE(YEAR(dms_LeapYear),2,29))=2,\"is a leap year\",\"not a leap year\"),\"dms_LeapYear not present\")"]
[null,"MaxRows if Reset and leap year",{"$f":"IF(dms_LeapYear_Result=\"is a leap year\",1827,1826)","v":1826},"dms_060701_Reset_MaxRows","=IF(dms_LeapYear_Result=\"is a leap year\",1827,1826)",null,null,"number of days present in Reset RIN table"]
[null,"MaxRows if ARR and leap year",{"$f":"IF(dms_LeapYear_Result=\"is a leap year\",366,365)","v":365},"dms_060701_ARR_MaxRows","=IF(dms_LeapYear_Result=\"is a leap year\",366,365)",null,null,"number of days present in ARR RIN table"]
[null,"Table 6.7.1 - Max Rows (leap year/ non leap year)",{"$f":"IF(dms_Model=\"ARR\",dms_060701_ARR_MaxRows,IF(dms_Model=\"Reset\",dms_060701_Reset_MaxRows,\"not a relevant RIN type\"))","v":1826},"dms_060701_MaxRows","=IF(dms_Model=\"ARR\",dms_060701_ARR_MaxRows,IF(dms_Model=\"Reset\",dms_060701_Reset_MaxRows,\"not a relevant RIN type\"))"]
[null,"How many columns in 6.7?   (4 or 5 feeder categories)",{"$f":"IF(dms_FifthFeeder_flag_NSP=\"NO\",\"This NSP has only 4 feeder categories\",\"This NSP has 5 feeder categories\")","v":"This NSP has only 4 feeder categories"}]
[null,"Table 6.7.1 - Last column (# of feeder categories > 4)",{"$f":"IF(dms_FifthFeeder_flag_NSP=\"NO\",10,12)","v":10},"dms_060701_MaxCols","=IF(dms_FifthFeeder_flag_NSP=\"NO\",8,10)"]
[null,"Table 6.7.1 - Number of offset rows",{"$f":"IF(dms_Model=\"ARR\",15,9)","v":9},"dms_060701_OffsetRows","=IF(dms_Model=\"ARR\",15,9)"]
[null,"Start date for telephone answering in 6.1 or 6.7?",null,null,"Using 060101 as naming standard not 060701 for start dates"]
[null,"Table 6.1.1 and 6.7.1 - Start Date as Text",{"$f":"IF(dms_SingleYearModel=\"yes\",(CONCATENATE(IF(LEN(CRY)=4,\"1-Jan-\",\"1-Jul-\"),LEFT(CRY,4))),(CONCATENATE(IF(LEN(PRCP_y4)=4,\"1-Jan-\",\"1-Jul-\"),LEFT(PRCP_y4,4))))","v":"1-Jul-2020"},"dms_060101_StartDateTxt","=IF(SUM(dms_SingleYear_Model)>1,(CONCATENATE(IF(LEN(CRY)=4,\"1-Jan-\",\"1-Jul-\"),LEFT(CRY,4))),(CONCATENATE(IF(LEN(CRCP_y4)=4,\"1-Jan-\",\"1-Jul-\"),LEFT(CRCP_y4,4))))"]
[null,"Table 6.1.1 and 6.7.1 - Start Date as Date Value",{"$f":"DATEVALUE(dms_060701_StartDateTxt)","v":44013},"dms_060101_StartDateVal","=DATEVALUE(dms_060701_StartDateTxt)"]
[null,"ARRs"]
[null,"How many rows in table 6.8?","insert dms_060801_StartCell NR if required",null,"dms_060801_StartCell is only found on worksheet 6.8 and is used to determine the starting date for the date range"]
[null,"Is dms_060801_StartCell named range present?",{"$f":"IFERROR(IF((ROW(dms_060801_StartCell)-1)=1,\"yes\",\"yes\"),\"no\")","v":"no"},"Must be present for ARRs","=IFERROR(IF((ROW(dms_060801_StartCell)-1)=1,\"yes\",\"yes\"),\"no\")"]
[null,"Table 6.8 - Number of offset rows",12,"dms_0608_OffsetRows","=IFERROR(IF(dms_Model=\"ARR\",(ROW(dms_060801_StartCell)-1),\"not an ARR\"),\"6.8 error\")"]
[null,"Table 6.8 - Last row",{"$f":"IFERROR(IF(dms_060801_StartCell<>\"\",IF(dms_Model=\"ARR\",(LOOKUP(2,1/(dms_060801_01_Values<>\"\"),(ROW(dms_060801_01_Values)))),\"not an ARR\"),0),\"0\")","v":"0"},"dms_0608_LastRow","=IFERROR(IF(dms_060801_StartCell<>\"\",IF(dms_Model=\"ARR\",(LOOKUP(2,1/(dms_060801_01_Values<>\"\"),(ROW(dms_060801_01_Values)))),\"not an ARR\"),0),\"0\")"]
[null,"Table 6.8 - MaxRows",{"$f":"IFERROR(IF(dms_Model=\"ARR\",(MAX(0,dms_0608_LastRow-dms_0608_OffsetRows)),\"not an ARR\"),\"0\")","v":"not an ARR"},"dms_060801_MaxRows","=IFERROR(IF(dms_Model=\"ARR\",(MAX(0,dms_0608_LastRow-dms_0608_OffsetRows)),\"not an ARR\"),\"0\")"]
[null,"TNSP RESET RINS"]
[null,"Table 7.9.4 only appears in TNSPs Reset RIN"]
[null,"Table 7.9.4 - first year",{"$f":"LEFT(PRCP_y3,4)","v":"2019"},"dms_070904_Start_Year","=LEFT(PRCP_y3,4)"]
[]
[null,"MISC"]
[null,"Distribution Determination Reference","-","dms_DeterminationRef"]
[null,"Public lighting NSP?",{"$f":"INDEX(dms_Public_Lighting_List,MATCH(dms_TradingName,dms_TradingName_List))","v":"NO"},"dms_Public_Lighting","=INDEX(dms_Public_Lighting_List,MATCH(dms_TradingName,dms_TradingName_List))"]
[null,"CBD Feeder for this business",{"$f":"INDEX(dms_CBD_flag,MATCH(dms_TradingName,dms_TradingName_List))","v":"NO"},"dms_CBD_flag_NSP"]
[null,"Urban Feeder for this business",{"$f":"INDEX(dms_Urban_flag,MATCH(dms_TradingName,dms_TradingName_List))","v":"NO"},"dms_Urban_flag_NSP"]
[null,"Short rural Feeder for this business",{"$f":"INDEX(dms_ShortRural_flag,MATCH(dms_TradingName,dms_TradingName_List))","v":"NO"},"dms_ShortRural_flag_NSP"]
[null,"Long rural Feeder for this business",{"$f":"INDEX(dms_LongRural_flag,MATCH(dms_TradingName,dms_TradingName_List))","v":"NO"},"dms_LongRural_flag_NSP"]
[null,"Fifth Feeder Category (eg. TasNetworks (D))",{"$f":"INDEX(dms_FeederType_5_flag,MATCH(dms_TradingName,dms_TradingName_List))","v":"NO"},"dms_FifthFeeder_flag_NSP","=INDEX(dms_FeederType_5_flag,MATCH(dms_TradingName,dms_TradingName_List))"]
[]
[null,"DISCARD FILES"]
[null,"discard this record?","NO","dms_DISCARD","If record is to be discarded from DB set this flag to YES"]
[]
[null,"SUBSET FILES"]
[null,"Is this Submission File a Subset File","NO","dms_Partial"]
[]
[]
[null,"REGULATORY YEARS FOR MULTI RYE SUBMISSIONS"]
[null,"Multiple RYE flag","NO","dms_Multi_RYE_flag"]
[null,null,"Manually specify RYE","Named ranges to apply"]
[null,null,2013,"dms_RYE_01"]
[null,null,2014,"dms_RYE_02"]
[null,null,2015,"dms_RYE_03"]
[null,null,2016,"dms_RYE_04"]
[null,null,2017,"dms_RYE_05"]
[null,null,2018,"dms_RYE_06"]
[null,null,2019,"dms_RYE_07"]
[null,null,2020,"dms_RYE_08"]
[null,null,2021,"dms_RYE_09"]