{"text_format":"1","workbook":"xlsx","n_sheets":32,"sheets":["Index","RFS Inc","DISAGG Inc","DISAGG Opex","DISAGG Aloc1","DISAGG Aloc1 (2)","DISAGG Aloc2","PTS Adj","PTS PriceRedn","PTS PDisc","PTS Rev","PTS Asset Aging","DISAGG ProvSum","PTS ProvRec ","INF RelPartTrans","INF RevRec","Historic Opex Summary","Hist Opex by Cat. Part Year","Historic Opex by Category Yr1","Historic Opex by Category Yr2","Historic Opex by Category Yr3","Historic Opex by Category Yr4","Historic Opex by Category Yr5","Historic Capex by Category","Hist Capex by Asset Class ","Hist Capex - Network","Hist Capex - Non-Network","NCIPAP projects","Commentary on Opex","Commentary on Historic Capex","Opex Instructions","Historic Capex Instructions"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":5,"defined_names":69,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Index","index":0,"n_rows":50,"n_cols":5,"rows_kept":50,"cut":false,"hidden":false,"merged":[[44,1,50,1],[38,1,40,1],[1,1,1,4],[34,1,37,1],[13,1,17,1],[7,1,9,1],[10,1,12,1],[18,1,26,1],[41,1,43,1]]}
[]
[null,"INFORMATION DISCLOSURE REQUIREMENTS"]
[]
[null,null,"TABLE OF CONTENTS"]
[null,null,"for the year ended 31 March 2017"]
[]
[null,"TYPE","PROFORMA STATEMENT","STATEMENT NUMBER","PAGE"]
[null,"Regulatory Financial Statements"]
[null,null,"Income Statement","RFS Inc",1]
[]
[null,"Disaggregation Statements"]
[null,null,"Income Statement","DISAGG Inc",2]
[]
[null,"Workpapers supporting the Disaggregation Statements:"]
[null,null,"Operations and maintenance expenditure","DISAGG Opex",3]
[null,null,"Causal allocations","DISAGG Aloc1",4]
[null,null,"Non-causal allocations","DISAGG Aloc2",7]
[]
[null,"Prescribed Transmission Services"]
[null,null,"Regulatory adjustment journals","PTS Adj",8]
[]
[null,null,"Price reduction/recovery ","PTS PriceRedn",9]
[]
[null,null,"Discount","PTS  Disc",10]
[]
[null,null,"Revenue analysis","PTS Rev",11]
[]
[null,"Asset schedules and supporting papers:"]
[null,"Prescribed Transmission Services","Asset Aging Schedule","PTS Asset Aging",12]
[]
[null,"Provisions Schedules:"]
[null,"Disaggregation Statements","Provisions Summary","DISAGG ProvSum",13]
[null,null,"Provisions Reconciliation","PTS ProvRec",14]
[]
[null,"Other Information"]
[null,null,"Related Party Transactions","Inf Rel Part Trans",15]
[null,null,"Revenue Reconciliation","Inf Rev Rec",16]
[]
[null,"Non-financial Schedules"]
[null,null,"Current Map of the Network","NFS Curr Map Netw","na"]
[]
[null,"Historic Operating Expenditure (Opex)"]
[null,null,"Historic Opex by Category - Summary","HOE Sum",17]
[]
[null,"Historic Capital Expenditure (Capex)"]
[null,null,"Historic Capex by Category","HCE Cat",18]
[null,null,"Historic Capex by Asset Class ","HCE Ass Cls",19]
[null,null,"Historic Capex - Network","HCE Netw",21]
[null,null,"Historic Capex - Non-Network","HCE Non Netw",22]
[null,null,"Historic Capex - NCIPAP","HCE NCIPAP",23]

{"sheet":"RFS Inc","index":1,"n_rows":53,"n_cols":8,"rows_kept":53,"cut":false,"hidden":false,"merged":[[1,0,1,7],[4,0,4,7],[48,0,48,7]]}
[]
["INCOME STATEMENT - PRESCRIBED TRANSMISSION SERVICES"]
[]
[]
[]
[]
["for the period ended: 31 March 2017"]
[]
["Account code or reference to Account Code",null,"Description","Disaggregation Statement  -  Prescribed Transmission Services","Journal number","Regulatory adjustments","Regulatory financial statements","Support reference"]
[null,null,null,"$'000",null,"$'000","$'000"]
[null,null,null,null,null,"Dr/(Cr)"]
[null,"REVENUE"]
[null,"Network charges",null,535057.63024220034,null,0,535057.63024220034,"DISAGG Inc"]
[null,"Other Network Revenue",null,34182.848010000002,null,0,34182.848010000002,"DISAGG Inc"]
[null,"Gross proceeds from sale of assets",null,252,null,null,252,"DISAGG Inc"]
[null,"Other Revenue",null,0,null,null,0]
[]
[null,"Total Revenue",null,569492.47825220029,null,0,569492.47825220029]
[]
[null,"EXPENDITURE"]
[null,"Opex costs "]
[null,"-","Network operations",6031.6295772341628,null,null,6031.6295772341628,"DISAGG Opex"]
[null,"-","Network maintenance ",29882.142054507502,null,null,29882.142054507502,"DISAGG Opex"]
[null,null,"Asset Works Maintenance",7514.9534234859866,1,-542.45580000000007,6972.4976234859869,"DISAGG Opex"]
[null,"-","Other costs ",null,null,null,0]
[null,null," -  Availability Rebate",165.99245000000002,null,null,165.99245000000002,"DISAGG Opex"]
[null,null," -  Easement Tax",111322.94,null,null,111322.94,"DISAGG Opex"]
[null,null," -  Insurance",4304.6129922290684,null,null,4304.6129922290684,"DISAGG Opex"]
[null,null," -  Other Taxes and Charges",4571.7430400000003,null,null,4571.7430400000003,"DISAGG Opex"]
[null,null," -  Self Insurance Costs",0,2,1702.2461538461539,1702.2461538461539,"PTS Adj"]
[null,null," -  Other Costs",34011.365111732899,null,null,34011.365111732899,"DISAGG Opex"]
[null,"- NCIPAP Opex",null,323.65943999999996,null,null,323.65943999999996,"DISAGG Opex"]
[null,"Depreciation",null,98187.123909999937,3,17971.399040000048,116158.52294999998]
[null,"Book value of assets disposed",null,2370.6528299999991,null,null,2370.6528299999991]
[null,null,null,null,null,null,0]
[null,"Total Expenditure",null,298686.8148291895,null,19131.189393846202,317818.00422303571]
[]
[null,"Earnings before Interest and Tax (EBIT)",null,270805.66342301079,null,-19131.189393846202,251674.47402916459]
[]
[]
[]
[null,"Taxation"]
[]
[]
["Note: Totals may not add due to rounding."]
[]
[]
["Note:"]
["In addition it is mandatory to produce for each cost or revenue item that has been allocated to the Prescribed Services \nSegment a supporting workpaper that includes the following: "]
["a) the amounts that have been directly attributed to the Prescribed Services Segment"]
["b) the amounts that have been allocated to each Prescribed Services Segment"]
["c) a description of the allocation basis "]
["d) the numeric quantity of each allocator."]

{"sheet":"DISAGG Inc","index":2,"n_rows":67,"n_cols":10,"rows_kept":67,"cut":false,"hidden":false,"merged":[[1,0,1,9],[4,0,4,9],[55,0,55,9],[62,0,62,9]]}
[]
["DISAGGREGATION STATEMENT - INCOME"]
[]
[]
[]
[]
["for the period ended: 31 March 2017"]
[]
["Account code or reference to Account Code",null,"Description","Audited financial statements",null,"Prescribed Transmission Services","Negotiated Transmission Services","Non-Regulated Transmission Services","Not Allocated","Workpaper reference"]
[null,null,null,"$'000",null,"$'000","$'000","$'000","$'000"]
[null,null,null,null,null,null,null,null,0]
[null,"Network charges",null,null,null,535057.63024220034,0,0]
[null,"Other Network Revenue",null,null,null,34182.848010000002,15288.88514,0,0]
[null,"Gross proceeds from sale of assets",null,null,null,251.72245000000001,0,0]
[null,"Other revenue",null,null,null,null,null,69241.875379999998,0]
[]
[null,"Total Revenue",null,null,null,569492.20070220029,15288.88514,69241.875379999998,0]
[]
[null,"Opex costs "]
[null,"-","Network operations ",null,null,6031.6295772341628,null,null,null,"DISAGG Opex"]
[null,"-","Network Maintenance",null,null,29882.142054507502,null,null,0,"DISAGG Opex"]
[null,"-","Asset Works Maintenance",null,null,7514.9534234859866,null,null,0,"DISAGG Opex"]
[null,"-","Other Costs"]
[null,null," -  Availability Rebate",null,null,165.99245000000002,null,null,0,"DISAGG Opex"]
[null,null," -  Easement Tax",null,null,111322.94,null,null,0,"DISAGG Opex"]
[null,null," -  Insurance",null,null,4304.6129922290684,null,null,null,"DISAGG Opex"]
[null,null," -  Other Taxes and Charges",null,null,4571.7430400000003,null,null,null,"DISAGG Opex"]
[null,null," -  Other Costs",null,null,34011.365111732899,null,null,null,"DISAGG Opex"]
[null,"NCIPAP Opex",null,null,null,323.65943999999996,null,null,null,"DISAGG Opex"]
[null,"Depreciation ",null,null,null,98187.123909999937]
[null,"Book value of assets disposed",null,null,null,2370.6528299999991]
[]
[null,"Total Expenditure"]
[]
[null,"Earnings before Interest and Tax (EBIT)",null,null,null,270805.38587301079]
[]
[null,"Interest and dividend income",null,null,null,null,null,null,12772.40919]
[null,"Finance charges",null,null,null,null,null,null,96944.225839999985]
[]
[null,"Profit(loss) before Income Tax Expense "]
[]
[null,"Australian income tax expense",null,null,null,null,null,null,69110.358959999998]
[null,"Deferred income tax"]
[null,"Other income tax"]
[]
[]
[]
[null,"Profit(loss) after income tax expense"]
[]
[300304,"Dividends paid",null,null,null,null,null,null,177550]
[]
[null,"Retained Profit(Loss)"]
[]
[]
["Note: Totals may not add due to rounding."]
["* Where the disclosures in the Regulatory Accounts template align with the audited statutory financial statements, the figures are sourced from the audited statutory financial statements. Where this is not possible, the figures are sourced from the audited trial balance of the audited statutory financial statements."]
[]
[]
[]
[]
[]
["Note:"]
["In addition it is mandatory to produce for each cost or revenue item that has been allocated to the Prescribed Services \nSegment a supporting workpaper that includes the following:"]
["a) the amounts that have been directly attributed to the Prescribed Services Segment"]
["b) the amounts that have been allocated to the Prescribed Services Segment"]
["c) a description of the allocation basis "]
["d) the numeric quantity of each allocator."]

{"sheet":"DISAGG Opex","index":3,"n_rows":70,"n_cols":13,"rows_kept":70,"cut":false,"hidden":false,"merged":[[1,0,1,12],[4,0,4,12]]}
[]
["OPERATIONS AND MAINTENANCE EXPENDITURE"]
[]
[]
[]
[]
["for the period ended: 31 March 2017"]
[]
["Account code or reference to account code",null,null,"Account Heading",null,null,"Ticks to indicate which rows are intersegmental costs",null,"Prescribed Transmission Services","Negotiated Transmission Services","Non-Regulated Transmission Services","Not Allocated","Total"]
[null,null,null,null,null,null,null,null,"$'000","$'000","$'000","$'000","$'000"]
[]
[null,null,null,"Directly Attributed Costs"]
[]
[null,null,null,"Network operations","Operations Workcodes",null,null,null,0,null,null,null,0]
[null,null,null,null,"Dedicated Responsibility Centres",null,null,null,6031.6295772341628]
[]
[null,null,null,"Network maintenance","GL Accounts",null,null,null,700.60137999999984]
[null,null,null,null,"Maintenance Workcodes",null,null,null,18568.025360000007]
[null,null,null,null,"Dedicated Responsibility Centres",null,null,null,136.02575475540402]
[]
[null,null,null,"Network maintenance support","GL Accounts",null,null,null,729.29313000000002]
[null,null,null,null,"Maintenance Workcodes",null,null,null,0]
[]
[null,null,null,"Asset Works maintenance","Asset Works Work Codes",null,null,null,5375.3502599999993]
[null,null,null,null,"Dedicated Responsibility Centres",null,null,null,546.87415286186956]
[]
[null,null,null,"Network Capability Incentive Parameter Action Plan (NCIPAP) Opex","Operations Workcodes",null,null,null,323.65943999999996]
[]
[null,null,null,"Other costs"]
[null,null,null," -  Availability Rebate","GL Account",null,null,null,165.99245000000002]
[null,null,null," -  Easement Tax","GL Account",null,null,null,111322.94]
[null,null,null," -  Insurance","GL Account",null,null,null,4304.6129922290684]
[null,null,null," -  Other Taxes and Charges","GL Account",null,null,null,4571.7430400000003]
[null,null,null," -  Other Costs"]
[null,null,null,"        - OHS","Maintenance Workcodes",null,null,null,0]
[null,null,null,"        - Listing & Share Registry","GL Account"]
[null,null,null,"        - Non Regulated Service Work Codes/Cost Centre","Work Codes",null,null,null,0]
[]
[]
[null,null,null,null,null,null,"Subtotal of Directly Attributed costs",null,152776.74753708052]
[]
[]
[]
[null,null,null,"Allocated Costs","Basis of allocation",null,"Work paper Ref.**"]
[null,null,null,"Network maintenance - Support","Causal",null,"DISAGG Aloc 1",null,9748.1964297520881]
[null,null,null,"Asset Works maintenance - Support","Causal",null,"DISAGG Aloc 1",null,1592.729010624118]
[null,null,null,"Other costs"]
[null,null,null,"- OHS","Causal",null,"DISAGG Aloc 1",null,939.30876348374284]
[null,null,null,"- Finance","Causal",null,"DISAGG Aloc 1",null,4854.2114642370007]
[null,null,null,"- HR","Causal",null,"DISAGG Aloc 1",null,2769.5232089212395]
[null,null,null,"- IT","Causal",null,"DISAGG Aloc 1",null,11384.364871249492]
[null,null,null,"- Building Services","Causal",null,"DISAGG Aloc 1",null,1173.4978085112041]
[null,null,null,"- Strategy and Business Development","Causal",null,"DISAGG Aloc 1",null,1692.3379779987033]
[null,null,null,"- Other Corporate Services","Causal",null,"DISAGG Aloc 1",null,11198.121017331512]
[]
[null,null,null,null,"Causal / Non- Causal*"]
[]
[null,null,null,null,null,null,"Subtotal of Allocated costs",null,45352.290552109102]
[]
[]
[null,null,null,null,null,null,"Total Opex Costs per DISAGG FPerf",null,198129.03808918962]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null," Total"]
[]
["Note: Totals may not add due to rounding."]

{"sheet":"DISAGG Aloc1","index":4,"n_rows":177,"n_cols":8,"rows_kept":177,"cut":false,"hidden":false,"merged":[[1,0,1,7],[4,0,4,7],[4,10,4,11],[8,0,8,7],[175,0,175,7]]}
[]
["CAUSAL ALLOCATION"]
[]
[]
[]
[]
["for the period ended: 31 March 2017"]
[]
["A copy of this workpaper is to be produced for each Causal basis that has been used to allocate costs between Business Segments."]
[]
[null,"1.   Causal basis of allocation",null,"ABC Survey of dedicated Responsibility Centres: Corporate Costs"]
[]
[null,"2.  Complete the table set out below to indicate: "]
[null,"-   the Account Headings and the amounts subject to this Causal basis; and"]
[null,"-   the description and quanta of allocator that has been used"]
[]
["Account code or reference to account code","Account Heading",null,"Prescribed Transmission Services","Negotiated Transmission Services","Non-Regulated Transmission Services","Not Allocated","Total"]
[null,null,null,"$'000","$'000","$'000","$'000","$'000"]
[null,"For each Account Heading that has been "]
[null,"allocated on this basis, provide the following information"]
[]
[null,"OH&S"]
[]
[]
[]
[null,12182,"Health Safety Enviro and Quality"]
[null,"Total OH&S"]
[null,"ABC allocation % (average)"]
[]
[null,"Finance"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,12155,"Taxation IR"]
[null,12350,"CES Finance"]
[null,12351,"Financial Planning"]
[null,12356,"Group Financial Control"]
[null,12385,"RES Finance"]
[null,12516,"Finance"]
[null,12903,"Treasury"]
[null,13456,"Billing and Receivables"]
[null,13834,"Shared Services"]
[]
[null,"Total Finance"]
[null,"ABC allocation % (average)"]
[]
[null,"HR"]
[]
[]
[]
[]
[]
[]
[]
[null,12109,"Corporate Relations"]
[null,12305,"People"]
[null,12306,"People & Safety"]
[null,13245,"Customer Services"]
[null,13506,"Support Services"]
[null,13939,"Customer Projects"]
[]
[null,"Total HR"]
[null,"ABC allocation % (average)"]
[]
[null,"IT"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,12210,"ICT Commercial"]
[null,12212,"Planning & Portfolio Services"]
[null,12343,"ICT Commercial Energy Services"]
[null,12420,"Digital & Innovation"]
[null,12488,"ICT Solutions & Delivery"]
[null,12627,"CIO Information Technology"]
[null,12721,"Enterprise Architecture"]
[null,13331,"Business Services"]
[null,13404,"ICT Enterprise Systems"]
[null,13450,"Infrastructure"]
[null,13655,"ICT Operations"]
[]
[null,"Total IT"]
[null,"ABC allocation % (average)"]
[]
[null,"Building Services"]
[]
[]
[null,13081,"Property Services"]
[null,13086,"Building Services"]
[]
[null,"Total Building Services"]
[null,"ABC allocation % (average)"]
[]
[null,"Strategy and Business Development"]
[null,12348,"Enterprise Prog Management Office"]
[null,12349,"Strategic Programs"]
[null,12388,"Strategy Business Development"]
[null,12410,"Business Development"]
[null,12450,"Workout"]
[null,12569,"Corporate Strategy"]
[null,12570,"EGM Strategy & Performance"]
[]
[null,"Total Strategy and Business Development"]
[null,"ABC allocation % (average)"]
[]
[null,"Other Corporate Services"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,12103,"Information Security"]
[null,12109,"Corporate Relations"]
[null,12273,"Risk Management & Security"]
[null,12287,"Risk & Assurance"]
[null,12467,"Legal & Company Secretary"]
[null,12510,"Managing Director"]
[null,12597,"Select Solutions"]
[null,12603,"Commercial and Contracts"]
[null,12604,"Emerging Energy Markets"]
[null,12640,"Asset Owner And Control"]
[null,13330,"Regulatory Frameworks"]
[null,13456,"Billing and Receivables"]
[null,13882,"Economic Regulation"]
[null,12092,"Asset Intelligence Development"]
[]
[]
[null,"Total Other Corporate Services"]
[null,"ABC allocation % (average)"]
[]
[]
[null,"Total this Workpaper:"]
[]
[]
[]
[]
[]
[null,"3.   Provide a detailed description and explanation of the basis of allocation:"]
[]
[]
[null,null,"Based on ABC Survey of dedicated Responsibility Centres."]
[]
[]
[]
[]
[]
["Note: Totals may not add due to rounding."]

{"sheet":"DISAGG Aloc1 (2)","index":5,"n_rows":185,"n_cols":8,"rows_kept":185,"cut":false,"hidden":false,"merged":[[1,0,1,7],[4,0,4,7],[4,10,4,11],[8,0,8,7],[110,0,110,7]]}
[]
["CAUSAL ALLOCATION"]
[]
[]
[]
[]
["for the period ended: 31 March 2017"]
[]
["A copy of this workpaper is to be produced for each Causal basis that has been used to allocate costs between Business Segments."]
[]
[null,"1.   Causal basis of allocation",null,"ABC Survey of dedicated Responsibility Centres:"]
[null,null,null,"                          Network Maintenance Support & Asset Works Support"]
[null,"2.  Complete the table set out below to indicate: "]
[null,"-   the Account Headings and the amounts subject to this Causal basis; and"]
[null,"-   the description and quanta of allocator that has been used"]
[]
["Account code or reference to account code","Account Heading",null,"Prescribed Transmission Services","Negotiated Transmission Services","Non-Regulated Transmission Services","Not Allocated","Total"]
[null,null,null,"$'000","$'000","$'000","$'000","$'000"]
[null,"For each Account Heading that has been "]
[null,"allocated on this basis, provide the following information"]
[]
[null,"Network Maintenance Support & Asset Works Support"]
[null,null,null,null,null,null,null,{"$f":"SUM(D23:G23)","v":0}]
[null,null,null,null,null,null,null,{"$f":"SUM(D24:G24)","v":0}]
[null,null,null,null,null,null,null,{"$f":"SUM(D25:G25)","v":0}]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,11517,"Major Contracts"]
[null,12014,"GM - Service Delivery"]
[null,12047,"Asset Management"]
[null,12902,"PM New Town"]
[null,12952,"Procurement & Fleet"]
[null,13025,"Planning & Scheduling Mgt"]
[null,13032,"Network Safety"]
[null,13058,"Commercial Partnership"]
[null,13123,"Network Strategy"]
[null,13125,"Asset Intelligence & Insights"]
[null,13140,"Powercor Contract"]
[null,13223,"Stations Assets"]
[null,13235,"Major Projects"]
[null,13237,"Energy Connections"]
[null,13260,"Transmission Delivery"]
[null,13305,"North Management"]
[null,13340,"Lines Assets"]
[null,13401,"North Bulk Project"]
[null,13418,"Metering Services Transformation"]
[null,13435,"CD&E Management"]
[null,13451,"Field Engineering Support"]
[null,13485,"Design"]
[null,13513,"Engineering Services"]
[null,13514,"Protection Control and Automation Assets"]
[null,13601,"Logistics"]
[null,13643,"Technical Standards"]
[null,13674,"South East Management"]
[null,13685,"East Transmission Contract"]
[null,13723,"Customer Team (East)"]
[null,13840,"Metering Business Strategy And Commercial"]
[null,13945,"Forward Program"]
[null,13967,"Asset Strategy & Planning (Gas)"]
[null,13996,"Asset Portfolio"]
[null,14122,"Scheduling (South East)"]
[null,14175,"Thomastown"]
[null,14223,"Central Delivery"]
[null,14230,"South Morang"]
[null,14345,"Hazelwood"]
[null,14715,"Rowville"]
[null,18932,"Operational Analytics & Performance"]
[null,12605,"Infrastructure Services Support"]
[null,13162,"Warehouse & Logistics"]
[null,13263,"Network Performance"]
[null,13417,"Network Planning"]
[null,13520,"Asset Management Systems"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Numeric quantity of allocator  (eg no of man-hours)"]
[null,"Corresponding cost allocation"]
[null,null,"ABC allocation % (average)"]
[]
[]
[]
[]
[null,"2.   Provide a detailed description and explanation of the basis of allocation:"]
[]
[null,null,null,null,"Prescribed Transmission Services (as above)","Network Maintenance Support","Asset Works Support"]
[]
[null,null,null,null,"$'000","$'000","$'000"]
[null,1601,"Logistics & Inventory"]
[]
[null,"Allocation based on:"]
[null," ABC survey"]
[]
[]
[null,null,null,null,"$'000","$'000","$'000"]
[null,5917,"Asset Engineering"]
[]
[null,"Allocation based on:"]
[null," ABC survey"]
[]
[]
[null,null,null,null,"$'000","$'000","$'000"]
[null,9952,"Procurement & Fleet"]
[]
[null,"Allocation based on:"]
[null," ABC survey"]
[]
[]
[null,null,null,null,"$'000","$'000","$'000"]
[null,13125,"Asset Intelligence & Insights",null,{"$f":"SUMIF($B$23:$B$104,B138,$D$23:$D$104)","v":0},0,{"$f":"E138","v":0}]
[]
[null,"Allocation based on:"]
[null," ABC survey"]
[]
[]
[null,null,null,null,"$'000","$'000","$'000"]
[null,13340,"Lines Assets",null,{"$f":"SUMIF($B$23:$B$104,B145,$D$23:$D$104)","v":0},0,{"$f":"E145","v":0}]
[]
[null,"Allocation based on:"]
[null," ABC survey"]
[]
[]
[null,null,null,null,"$'000","$'000","$'000"]
[null,13514,"Protection Control and Automation Assets",null,{"$f":"SUMIF($B$23:$B$104,B152,$D$23:$D$104)","v":0},0,{"$f":"E152","v":0}]
[]
[null,"Allocation based on:"]
[null," ABC survey"]
[]
[]
[null,null,null,null,"$'000","$'000","$'000"]
[null,13601,"Logistics",null,{"$f":"SUMIF($B$23:$B$104,B159,$D$23:$D$104)","v":0},0,{"$f":"E159","v":0}]
[]
[null,"Allocation based on:"]
[null," ABC survey"]
[]
[]
[null,null,null,null,"$'000","$'000","$'000"]
[null,13643,"Technical Standards",null,{"$f":"SUMIF($B$23:$B$104,B166,$D$23:$D$104)","v":0},0,{"$f":"E166","v":0}]
[]
[null,null,null,null,"Total Directly Attributed Cost",null,"Directly Attributed Asset Works Expenditure"]
[null,"Numeric quantity of allocator"]
[null,"(As a % of Total)"]
[]
[]
[null,null,"TOTAL Asset Works Support $'000:",null,null,null,{"$f":"G117+G124+G131+G138+G145+G152+G159+G166","v":0}]
[]
[]
[]
[]
[null,"3.   Provide a detailed description and explanation of the basis of allocation:"]
[]
[]
[null,null,"Based on ABC Survey of dedicated Responsibility Centres."]
[null,null,"Subsequent allocation to Asset Works Support per Table 2 above."]
[]
[]
["Note: Totals may not add due to rounding."]

{"sheet":"DISAGG Aloc2","index":6,"n_rows":56,"n_cols":8,"rows_kept":56,"cut":false,"hidden":false,"merged":[[17,1,17,2],[45,1,45,8],[1,0,1,6],[4,0,4,7],[4,9,4,10],[8,0,8,8],[12,1,12,8],[14,1,14,2]]}
[]
["NON-CAUSAL ALLOCATION"]
[null,null,null,"(Not Applicable to AusNet Services)"]
[]
[]
[]
["for the period ended: 31 March 2017"]
[]
["A copy of this workpaper is to be produced for each Non-causal basis that has been used to\n allocate costs between Business Segments."]
[]
[null,"1.   Non-causal basis of allocation ………………………………………"]
[]
[null,"2.  Complete the table set out below to indicate the Account Headings and the \namounts subject to this non-causal basis."]
[null,"     "]
["Account code or reference to account code","Account Heading",null,"Prescribed Transmission Services","Negotiated Transmission Services","Non-Regulated Transmission Services","Not Allocated","Total"]
[null,null,null,"$'000","$'000","$'000","$'000","$'000"]
[]
[null,"(List all Account Headings that \nhave been allocated on this basis)"]
[]
[]
[]
[]
[]
[]
[]
[null,"3.   Provide a detailed description and explanation of the basis of allocation:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"4.   Explain why no causal basis could be established:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"5.  Explain the reasons for choosing this non-causal basis and why it was \npreferred over others:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"6.  Date on which the Commission/AER granted approval:"]

{"sheet":"PTS Adj","index":7,"n_rows":26,"n_cols":6,"rows_kept":26,"cut":false,"hidden":false,"merged":[[1,0,1,4],[4,0,4,5],[20,1,20,2],[25,1,25,2]]}
[]
["REGULATORY ADJUSTMENT JOURNALS - PRESCRIBED TRANSMISSION SERVICES"]
[]
[]
[]
[]
["for the period ended: 31 March 2017"]
[]
["Journal","Account Debited",null,"Amount",null,"Supporting"]
["number",null,"Account Credited","Debit","Credit","Statement"]
[null,null,null,"$'000","$'000","No."]
[]
[]
[null,"Provision for Self Insurance Costs",null,2806.0678000000003,null,"PTS ProvRec"]
[1,null,"Asset Works maintenance costs",null,542.45580000000007,"RFS Inc"]
[null,null,"Capex Incurred",null,2263.6120000000001]
[null,"(To record claims against the Self Insurance Provision/Reserve) "]
[]
[null,"Self Insurance Costs",null,1702.2461538461539,null,"RFS Inc"]
[2,null,"Provision for Self Insurance Costs",null,1702.2461538461539,"PTS ProvRec"]
[null,"(Annual Provision for Self Insurance Costs as allowed in AER's Final Decision) "]
[]
[]
[null,"Depreciation",null,17971.399040000048,null,"RFS Inc"]
[3,null,"Property, Plant & Equipment",null,17971.399040000048]
[null,"(Adjustment in Depreciation, and Valuation adjustment in Accounting PP&E, to reflect Regulatory PP&E)"]

{"sheet":"PTS PriceRedn","index":8,"n_rows":31,"n_cols":3,"rows_kept":31,"cut":false,"hidden":false,"merged":[[1,0,1,3],[4,0,4,3],[4,9,4,10]]}
[]
["PRICE REDUCTION/RECOVERY - PRESCRIBED TRANSMISSION SERVICES"]
[null,"(Not Applicable to AusNet Services)"]
[]
[]
[]
["for the period ended: 31 March 2017"]
[]
[null,"$Customer TUOS","$Common service"]
[null,"general charges","charges"]
["Reduction in prices payable"]
["       by transmission customers"]
[]
[]
[]
[]
["     Total Reduction"]
[]
["*Recovery of  above reduction in prices"]
["     from other transmission customers"]
[]
[]
[]
["     Total Recovery"]
[]
[]
["Note:"]
["Each instance of a price reduction/recovery should be detailed."]
["*The amount of any reduction in a transmission customer's Customer TUOS general charges "]
["and/or common service charges recovered from other transmission customers under clause 6A.26.1"]
["of the Rules. "]

{"sheet":"PTS PDisc","index":9,"n_rows":22,"n_cols":4,"rows_kept":22,"cut":false,"hidden":false,"merged":[[1,0,1,7],[4,0,4,7],[21,1,21,2]]}
[]
["PRUDENT DISCOUNTS - PRESCRIBED TRANSMISSION SERVICES"]
[null,null,null,"(Not Applicable to AusNet Services)"]
[]
[]
[]
["for the period ended: 31 March 2017"]
[]
[]
[]
[]
[null,"Number of discounts recovered in previous year"]
["For each discount recovered:"]
[null,"Date of AER approval, if given"]
[null,"Expiry date"]
[null,"Party receiving the discount"]
[null,"Beneficiary of discount"]
[null,"Amount of discount offered in previous year"]
[null,"Amount recovered from the other custumers in previous year"]
[null,"Load subject to discount (max, min, average)"]
["For each discount approved by the AER:"]
[null,"Compliance with conditions - for each condition imposed provide information demonstrating that the condition has been met."]

{"sheet":"PTS Rev","index":10,"n_rows":30,"n_cols":5,"rows_kept":30,"cut":false,"hidden":false,"merged":[[1,0,1,3],[4,0,4,4],[4,9,4,10],[29,0,29,4]]}
[]
["REVENUE ANALYSIS - PRESCRIBED TRANSMISSION SERVICES"]
[]
[]
[]
[]
["for the period ended: 31 March 2017"]
[]
["Account code or reference","Tariff Category",null,"Amount of electricity transmitted","Revenue"]
[]
[null,"Network Connection & Use of System Charges"]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Total",null,{"$f":"SUM(E12:E18)","v":0}]
[]
[null,"Other Network Revenue"]
[]
[]
[]
[]
[null,null,"Total",null,{"$f":"SUM(E22:E25)","v":0}]
[]
[]
[]
["Note:\nPer AER's Explanatory Statement of April 2015 accompanying the Final Electricity Transmission Network Service Providers Information Guideline Version 2, this schedule is not required to be completed, as it is duplicated in the Economic Benchmarking Regulatory Information Notice (RIN). "]

{"sheet":"PTS Asset Aging","index":11,"n_rows":27,"n_cols":8,"rows_kept":27,"cut":false,"hidden":false,"merged":[[1,0,1,7],[4,0,4,7],[4,9,4,10],[27,0,27,6],[26,0,26,7]]}
[]
["ASSET AGING SCHEDULE - \nPRESCRIBED TRANSMISSION SERVICES"]
[]
[]
[]
[]
["All asset values are net regulatory values"]
[]
[]
[null,null,null,null,null,"Useful life remaining (years after Regulatory Accounting Date)"]
[null,null,"Total","1-5","6-10","11-15","16-20",">20"]
["Asset class",null,"$'000","$'000","$'000","$'000","$'000","$'000"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Total net regulatory value"]
[]
["Note:\nPer AER's Explanatory Statement of April 2015 accompanying the Final Electricity Transmission Network Service Providers Information Guideline Version 2, this schedule is not required to be completed, as it is duplicated in the Category Analysis Regulatory Information Notice (RIN). "]

{"sheet":"DISAGG ProvSum","index":12,"n_rows":37,"n_cols":8,"rows_kept":37,"cut":false,"hidden":false,"merged":[[1,0,1,6],[4,0,4,6],[4,8,4,9],[47,0,47,5]]}
[]
["SUMMARY OF PROVISIONS"]
[]
[]
[]
[]
["for the period ended: 31 March 2017"]
[]
[null,null,null,"Prescribed Transmission Services","Negotiated Transmission Services","Non-Regulated Transmission Services","Not Allocated","Total"]
[null,null,null,"$'000","$'000","$'000","$'000","$'000"]
[]
[null,"Amount set aside to provisions",null,27830.705668202081,null,null,315.274934378637]
[]
[null,"Expenditure incurred debited to provisions",null,-25125.256831931798,null,null,0]
[]
[null,"Amounts written back from provisions",null,-4864.3013789632778,null,null,-3235.1693799999998]
[]
[null,"Transfer from SPI Management Services Pty Ltd and EBS",null,0,null,null,0]
[]
[null,"Defined Benefit Adjustment",null,-5035.5176575526184,null,null,0]
[]
[null,"Net movement in provisions",null,-7194.370200245613,null,null,-2919.894445621363]
[]
[null,"Balance at start of period",null,38540.13347860003,null,null,3631.2496499999966]
[]
[null,"Balance at end of period",null,31345.763278354418,null,null,711.35520437863352]
[]
[]
["Comprising:"]
[]
[null,"Current provisions",null,27556.815273313703,null,null,711.3556143786368]
[null,"Non-current provision",null,3788.9480050407146,null,null,-4.1000000387430191E-4]
[]
[null,null,"Total per balance sheet",31345.763278354418,null,null,711.35520437863295]
[]
[null,null,null,null,null,null,null,1.745110348565504E-4]
["Note: Totals may not add due to rounding."]

{"sheet":"PTS ProvRec ","index":13,"n_rows":40,"n_cols":10,"rows_kept":40,"cut":false,"hidden":false,"merged":[[1,0,1,9],[4,0,4,9],[8,3,8,7],[39,0,39,8]]}
[]
["PROVISIONS RECONCILIATION - \nPRESCRIBED TRANSMISSION SERVICES"]
[]
[]
[]
[]
["for the period ended: 31 March 2017"]
[]
[null,null,"Description"," Discretionary Heading for each Material Provision ",null,null,null,null,"Others","Total"]
[]
[null,null,null,"$'000","$'000","$'000","$'000","$'000","$'000","$'000"]
[]
["Balance at start of period"]
[]
["Amount set aside to provisions"]
[]
["Expenditure incurred debited to provisions"]
[]
["Amounts written back from provisions"]
[]
[]
["Balance at end of period"]
[]
[]
[]
["Net Movement in provisions per RFS FPerf"]
[]
[]
["Note:"]
["In addition it is mandatory to produce for each item that has been allocated to the Prescribed Services Segment a"]
["supporting workpaper that includes the following:"]
["a) the amounts that have been directly attributed to the Prescribed Services Segment"]
["b) the amounts that have been allocated to the Prescribed Services Segment"]
["c) a description of the allocation basis "]
["d) the numeric quantity of each allocator."]
[]
["The basis of attribution of provisions to the Prescribed Services Segment, should follow the attribution of the expenses to"]
["which they relate. Taxation, interest and dividend provisions should be attributed  to the Not Allocated Segment."]
[]
["Note:\nPer AER's Explanatory Statement of April 2015 accompanying the Final Electricity Transmission Network Service Providers Information Guideline Version 2, this schedule is not required to be completed, as it is duplicated in the Economic Benchmarking RIN. "]

{"sheet":"INF RelPartTrans","index":14,"n_rows":84,"n_cols":5,"rows_kept":84,"cut":false,"hidden":false,"merged":[[72,0,72,4],[1,0,1,4],[4,0,4,4],[40,1,40,3],[48,1,48,3],[58,1,58,3]]}
[]
["RELATED PARTY TRANSACTIONS"]
[]
[]
[]
[]
["for the period ended: 31 March 2017"]
[]
["Details of related party","Description of transaction","Prescribed","Procurement process","Monetary value of transaction"]
[null,null,null,null,"$'000"]
[]
[null,"Revenue"]
[]
[]
["AusNet Electricity Services Pty Ltd (152)","Exit/Connection Charges","Prescribed","Regulatory obligation"]
[]
["AusNet Electricity Services Pty Ltd (152)","Excluded Services Revenue","Prescribed Excluded","A competitive process was not undertaken"]
[]
["Jemena Electricity Networks (Vic) Ltd","Exit/Connection Charges","Prescribed","Regulatory obligation"]
[]
["SP PowerAssets Ltd","Chemical Services","Non Regulated","Competitive"]
[]
["Jemena (Various)","Services including Connection Services, Chemical Services, Protection Control, Gas Technical Services, GAS SCADA revenue, Metering and other miscellaneous services","Non Regulated","Competitive"]
[]
["Jemena (Various)","Excluded Services Revenue","Prescribed Excluded"]
[]
["AusNet Finance Pty Ltd (204)","Interest expense on Inter-co loan from AusNet Finance Pty Ltd (lender) to AusNet Transmission Group Pty Ltd (borrower)","Not Allocated","n/a"]
[]
["AusNet (No.8) Pty Ltd  (133)","Interest expense on Inter-co loan from AusNet (N8) Pty Ltd (lender) to AusNet Transmission Group Pty Ltd  (borrower)","Not Allocated","n/a"]
[]
[null,"Capital"]
["Jemena (various)","Capital Expenditure","Prescribed","A competitive process was not undertaken"]
[]
[]
[]
["Balances with related parties at regulatory accounting date"]
[null,null,null,null,"$'000"]
[]
[null,"Current assets"]
[]
[]
[]
[]
[]
["SP PowerAssets Ltd","Account Receivable relating to chemical services"]
[]
["(Various inter-company)","System generated clearing account for inter-company transactions"]
[]
["Jemena (various) including United Energy Limited","Accounts Receivable relating to Exit Charges revenue for the month of Mar 2017, chemical services, gas technical services, asset inspection revenue and other miscellaneous charges."]
[]
[null,"Non-current assets"]
["AusNet Services (Transmission) Ltd"," Loan to AusNet Services (Transmission) Ltd "]
[]
[]
[]
[null,"Total assets"]
[]
[null,"Current liabilities"]
["AusNet Services (Transmission) Ltd ","Income tax liabilities (balance off-sets inter-co tax receivable in AusNet Services (Transmission) Ltd who submits the group's Tax returns"]
["(Various inter-company)","System generated clearing account for inter-company transactions"]
["Jemena (various)","Accounts payable relating to construction works, site installation and design work"]
["Singapore Power","Reimbursement of Travel costs/insurance"]
[]
[null,"Non-current liabilities"]
["AusNet (No.8) Pty Ltd","Loan from SPI (No. 8) Pty Ltd "]
["AusNet Finance Pty Ltd (8205)","Loan from AusNet Finance Pty Ltd"]
["AST Ltd (8200)","Loan from AST Ltd"]
[]
[]
[null,"Total liabilities"]
[]
["Commitments with related parties at regulatory accounting period"]
["Value of commitments with related parties that are expected to result in related party transactions in future regulatory accounting periods:"]
[null,null,"Recognised as liabilities","Not recognised as liabilities","Total"]
[null,null,"$'000","$'000","$'000"]
[]
["Jemena (various)","Payable:"]
[null,"Not later than one year"]
[null,"Later than one year and not later than five years"]
[null,"Later than five years"]
[]
[null,"Total commitments"]
[]
["Note: Totals may not add due to rounding."]

{"sheet":"INF RevRec","index":15,"n_rows":24,"n_cols":5,"rows_kept":24,"cut":false,"hidden":false,"merged":[[1,0,1,5],[4,0,4,5]]}
[]
["REVENUE RECONCILIATION "]
[]
[]
[]
[]
["for the period ended: 31 March 2017"]
[]
[null,"Description",null,"Unit type","Unit"]
[]
[]
[null,null,"CPI (SeptTx)","CPI – All Groups Weighted Average of 8 \nCapital Cities (ABS)",104]
[null,null,"CPI (Sept Tx+1)","As above",106.4]
[null,null,"CPI (Sept Tx+2)","As above",108]
[null,null,"Change in CPI (Tx+1)","Per cent",2.3076923076923217E-2]
[null,null,"Change in CPI (Tx+2)","Per cent",1.5037593984962294E-2]
[null,null,"X-factor","Per cent",3.2373859306025703E-2]
[null,null,"AR (Tx)","$",538100000]
[null,null,"AR (Tx+2)","$",523201033.39344603]
[null,null,"S-factor (Tx+1)","$+",10328876.237403801]
[null,null,"Under/over recovery AR (Tx+1)","$+",0]
[null,null,"Pass Through (Easement Tax)","$",3954796.6113505]
[null,null,"Closure of AIS - under-recovery of allowance for rebates","$",-2427076]
[null,null,"Revenue Cap Tx+2","$",535057630.24220037]

{"sheet":"Historic Opex Summary","index":16,"n_rows":65,"n_cols":12,"rows_kept":65,"cut":false,"hidden":false,"merged":[[1,1,1,10],[64,1,64,10]]}
[]
[null,"HISTORIC OPEX by expenditure category"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"$ million nominal","Financial year","Any part years","Year 1","Year 2","Year 3","Year 4","Year 5","Total","Revenue Cap Allowance","Key cost drivers and explanation for material differences over time"]
[null,"System Recurrent"]
[null,"Maintenance"]
[null,"Secondary Systems"]
[null,"Labour"]
[null,"Materials"]
[null,"Sub-Totals"]
[null,"Substations"]
[null,"Labour"]
[null,"Materials"]
[null,"Sub-Totals"]
[null,"Lines"]
[null,"Labour"]
[null,"Materials"]
[null,"Sub-Totals"]
[null,"Communications"]
[null,"Labour "]
[null,"Materials"]
[null,"Sub-Totals"]
[null,"Easements"]
[null,"Labour"]
[null,"Materials"]
[null,"Sub-Totals"]
[null,"Summary"]
[null,"Sub-Total Labour"]
[null,"Sub-Total Materials"]
[null,"Total Maintenance"]
[null,"Asset Management Support"]
[null,"Operations"]
[null,"OHS"]
[null,"Taxes and Charges"]
[null,"Insurance"]
[null,"Total System Recurrent"]
[null,"System Non-Recurrent"]
[null,"Asset Works Program"]
[null,"Asset Management Support"]
[null,"Total System Non-Recurrent"]
[null,"Non-System"]
[null,"Finance"]
[null,"HR"]
[null,"IT "]
[null,"Other"]
[null,"Total Non-System"]
[null,"Summary"]
[null,"Total Labour"]
[null,"Total Maintenance Materials"]
[null,"Total Other Materials"]
[null,"TOTAL OPEX"]
[]
[null,"Grand Total"]
[]
[null,"Revenue Cap Allowance"]
[null,"Note: Per AER's Explanatory Statement of April 2015 accompanying the Final Electricity Transmission Network Service Providers Information Guideline Version 2, this schedule is not required to be completed, as it is duplicated in the Economic Benchmarking RIN  and Category Analysis RIN. "]

{"sheet":"Hist Opex by Cat. Part Year","index":17,"n_rows":67,"n_cols":12,"rows_kept":67,"cut":false,"hidden":true,"merged":[[66,1,66,9],[0,1,0,10],[8,3,9,3],[11,3,11,9],[12,3,12,5],[8,5,9,5]]}
[null,"HISTORIC OPEX by expenditure category"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Any Part Year"]
[null,null,null,"Field Maintenance  "]
[null,"$ million, nominal ",null,"Routine","Condition-Based","Corrective",null,"TOTAL",null,"Revenue Cap Allowance ",null,"Key cost drivers and explanation for material differences \nover time"]
[null,"System Recurrent"]
[null,"Maintenance"]
[null,"Secondary Systems"]
[null,"Labour"]
[null,"Materials"]
[null,"Sub-Totals"]
[null,"Substations"]
[null,"Labour"]
[null,"Materials"]
[null,"Sub-Totals"]
[null,"Lines"]
[null,"Labour"]
[null,"Materials"]
[null,"Sub-Totals"]
[null,"Communications"]
[null,"Labour "]
[null,"Materials"]
[null,"Sub-Totals"]
[null,"Easements"]
[null,"Labour"]
[null,"Materials"]
[null,"Sub-Totals"]
[null,"Summary"]
[null,"Sub-Total Labour"]
[null,"Sub-Total Materials"]
[null,"Total Maintenance"]
[null,"Asset Management Support"]
[null,"Operations"]
[null,"OHS"]
[null,"Taxes and Charges"]
[null,"Insurance"]
[null,"Total System Recurrent"]
[null,"System Non-Recurrent"]
[null,"Asset Works Program"]
[null,"Asset Management Support"]
[null,"Total System Non-Recurrent"]
[null,"Non-System"]
[null,"Finance"]
[null,"HR"]
[null,"IT "]
[null,"Other"]
[null,"Total Non-System"]
[null,"Summary"]
[null,"Total Labour"]
[null,"Total Maintenance Materials"]
[null,"Total Other Materials"]
[null,"TOTAL OPEX"]
[]
[]
[null,"Grand Total"]
[]
[null,"Revenue Cap Allowance"]
[null,"Note: Per AER's Explanatory Statement of April 2015 accompanying the Final Electricity Transmission Network Service Providers Information Guideline Version 2, this schedule is not required to be completed, as it is duplicated in the Economic Benchmarking RIN  and Category Analysis RIN. "]

{"sheet":"Historic Opex by Category Yr1","index":18,"n_rows":67,"n_cols":12,"rows_kept":67,"cut":false,"hidden":true,"merged":[[1,1,1,10],[9,3,10,3],[13,3,13,5],[9,5,10,5],[12,3,12,9]]}
[]
[null,"HISTORIC OPEX by expenditure category"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Year 1"]
[null,null,null,"Field Maintenance  "]
[null,"$ million, nominal ",null,"Routine","Condition-Based","Corrective",null,"TOTAL",null,"Revenue Cap Allowance ",null,"Key cost drivers and explanation for material differences\n over time"]
[null,"System Recurrent"]
[null,"Maintenance"]
[null,"Secondary Systems"]
[null,"Labour"]
[null,"Materials"]
[null,"Sub-Totals"]
[null,"Substations"]
[null,"Labour"]
[null,"Materials"]
[null,"Sub-Totals"]
[null,"Lines"]
[null,"Labour"]
[null,"Materials"]
[null,"Sub-Totals"]
[null,"Communications"]
[null,"Labour "]
[null,"Materials"]
[null,"Sub-Totals"]
[null,"Easements"]
[null,"Labour"]
[null,"Materials"]
[null,"Sub-Totals"]
[null,"Summary"]
[null,"Sub-Total Labour"]
[null,"Sub-Total Materials"]
[null,"Total Maintenance"]
[null,"Asset Management Support"]
[null,"Operations"]
[null,"OHS"]
[null,"Taxes and Charges"]
[null,"Insurance"]
[null,"Total System Recurrent"]
[null,"System Non-Recurrent"]
[null,"Asset Works Program"]
[null,"Asset Management Support"]
[null,"Total System Non-Recurrent"]
[null,"Non-System"]
[null,"Finance"]
[null,"HR"]
[null,"IT "]
[null,"Other"]
[null,"Total Non-System"]
[null,"Summary"]
[null,"Total Labour"]
[null,"Total Maintenance Materials"]
[null,"Total Other Materials"]
[null,"TOTAL OPEX"]
[]
[]
[null,"Grand Total"]
[]
[null,"Revenue Cap Allowance"]

{"sheet":"Historic Opex by Category Yr2","index":19,"n_rows":67,"n_cols":12,"rows_kept":67,"cut":false,"hidden":true,"merged":[[13,3,13,5],[1,1,1,10],[9,3,10,3],[9,5,10,5],[12,3,12,9]]}
[]
[null,"HISTORIC OPEX by expenditure category"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Year 2"]
[null,null,null,"Field Maintenance  "]
[null,"$ million, nominal ",null,"Routine","Condition-Based","Corrective",null,"TOTAL",null,"Revenue Cap Allowance ",null,"Key cost drivers and explanation for material differences\n over time"]
[null,"System Recurrent"]
[null,"Maintenance"]
[null,"Secondary Systems"]
[null,"Labour"]
[null,"Materials"]
[null,"Sub-Totals"]
[null,"Substations"]
[null,"Labour"]
[null,"Materials"]
[null,"Sub-Totals"]
[null,"Lines"]
[null,"Labour"]
[null,"Materials"]
[null,"Sub-Totals"]
[null,"Communications"]
[null,"Labour "]
[null,"Materials"]
[null,"Sub-Totals"]
[null,"Easements"]
[null,"Labour"]
[null,"Materials"]
[null,"Sub-Totals"]
[null,"Summary"]
[null,"Sub-Total Labour"]
[null,"Sub-Total Materials"]
[null,"Total Maintenance"]
[null,"Asset Management Support"]
[null,"Operations"]
[null,"OHS"]
[null,"Taxes and Charges"]
[null,"Insurance"]
[null,"Total System Recurrent"]
[null,"System Non-Recurrent"]
[null,"Asset Works Program"]
[null,"Asset Management Support"]
[null,"Total System Non-Recurrent"]
[null,"Non-System"]
[null,"Finance"]
[null,"HR"]
[null,"IT "]
[null,"Other"]
[null,"Total Non-System"]
[null,"Summary"]
[null,"Total Labour"]
[null,"Total Maintenance Materials"]
[null,"Total Other Materials"]
[null,"TOTAL OPEX"]
[]
[]
[null,"Grand Total"]
[]
[null,"Revenue Cap Allowance"]

{"sheet":"Historic Opex by Category Yr3","index":20,"n_rows":67,"n_cols":12,"rows_kept":67,"cut":false,"hidden":true,"merged":[[13,3,13,5],[1,1,1,10],[9,3,10,3],[9,5,10,5],[12,3,12,9]]}
[]
[null,"HISTORIC OPEX by expenditure category"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Year 3"]
[null,null,null,"Field Maintenance  "]
[null,"$ million, nominal ",null,"Routine","Condition-Based","Corrective",null,"TOTAL",null,"Revenue Cap Allowance ",null,"Key cost drivers and explanation for material differences\n over time"]
[null,"System Recurrent"]
[null,"Maintenance"]
[null,"Secondary Systems"]
[null,"Labour"]
[null,"Materials"]
[null,"Sub-Totals"]
[null,"Substations"]
[null,"Labour"]
[null,"Materials"]
[null,"Sub-Totals"]
[null,"Lines"]
[null,"Labour"]
[null,"Materials"]
[null,"Sub-Totals"]
[null,"Communications"]
[null,"Labour "]
[null,"Materials"]
[null,"Sub-Totals"]
[null,"Easements"]
[null,"Labour"]
[null,"Materials"]
[null,"Sub-Totals"]
[null,"Summary"]
[null,"Sub-Total Labour"]
[null,"Sub-Total Materials"]
[null,"Total Maintenance"]
[null,"Asset Management Support"]
[null,"Operations"]
[null,"OHS"]
[null,"Taxes and Charges"]
[null,"Insurance"]
[null,"Total System Recurrent"]
[null,"System Non-Recurrent"]
[null,"Asset Works Program"]
[null,"Asset Management Support"]
[null,"Total System Non-Recurrent"]
[null,"Non-System"]
[null,"Finance"]
[null,"HR"]
[null,"IT "]
[null,"Other"]
[null,"Total Non-System"]
[null,"Summary"]
[null,"Total Labour"]
[null,"Total Maintenance Materials"]
[null,"Total Other Materials"]
[null,"TOTAL OPEX"]
[]
[]
[null,"Grand Total"]
[]
[null,"Revenue Cap Allowance"]

{"sheet":"Historic Opex by Category Yr4","index":21,"n_rows":67,"n_cols":12,"rows_kept":67,"cut":false,"hidden":true,"merged":[[13,3,13,5],[1,1,1,10],[9,3,10,3],[9,5,10,5],[12,3,12,9]]}
[]
[null,"HISTORIC OPEX by expenditure category"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Year 4"]
[null,null,null,"Field Maintenance  "]
[null,"$ million, nominal ",null,"Routine","Condition-Based","Corrective",null,"TOTAL",null,"Revenue Cap Allowance ",null,"Key cost drivers and explanation for material differences\n over time"]
[null,"System Recurrent"]
[null,"Maintenance"]
[null,"Secondary Systems"]
[null,"Labour"]
[null,"Materials"]
[null,"Sub-Totals"]
[null,"Substations"]
[null,"Labour"]
[null,"Materials"]
[null,"Sub-Totals"]
[null,"Lines"]
[null,"Labour"]
[null,"Materials"]
[null,"Sub-Totals"]
[null,"Communications"]
[null,"Labour "]
[null,"Materials"]
[null,"Sub-Totals"]
[null,"Easements"]
[null,"Labour"]
[null,"Materials"]
[null,"Sub-Totals"]
[null,"Summary"]
[null,"Sub-Total Labour"]
[null,"Sub-Total Materials"]
[null,"Total Maintenance"]
[null,"Asset Management Support"]
[null,"Operations"]
[null,"OHS"]
[null,"Taxes and Charges"]
[null,"Insurance"]
[null,"Total System Recurrent"]
[null,"System Non-Recurrent"]
[null,"Asset Works Program"]
[null,"Asset Management Support"]
[null,"Total System Non-Recurrent"]
[null,"Non-System"]
[null,"Finance"]
[null,"HR"]
[null,"IT "]
[null,"Other"]
[null,"Total Non-System"]
[null,"Summary"]
[null,"Total Labour"]
[null,"Total Maintenance Materials"]
[null,"Total Other Materials"]
[null,"TOTAL OPEX"]
[]
[]
[null,"Grand Total"]
[]
[null,"Revenue Cap Allowance"]

{"sheet":"Historic Opex by Category Yr5","index":22,"n_rows":67,"n_cols":12,"rows_kept":67,"cut":false,"hidden":true,"merged":[[13,3,13,5],[1,1,1,10],[9,3,10,3],[9,5,10,5],[12,3,12,9]]}
[]
[null,"HISTORIC OPEX by expenditure category"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Year 5"]
[null,null,null,"Field Maintenance  "]
[null,"$ million, nominal ",null,"Routine","Condition-Based","Corrective",null,"TOTAL",null,"Revenue Cap Allowance ",null,"Key cost drivers and explanation for material differences\n over time"]
[null,"System Recurrent"]
[null,"Maintenance"]
[null,"Secondary Systems"]
[null,"Labour"]
[null,"Materials"]
[null,"Sub-Totals"]
[null,"Substations"]
[null,"Labour"]
[null,"Materials"]
[null,"Sub-Totals"]
[null,"Lines"]
[null,"Labour"]
[null,"Materials"]
[null,"Sub-Totals"]
[null,"Communications"]
[null,"Labour "]
[null,"Materials"]
[null,"Sub-Totals"]
[null,"Easements"]
[null,"Labour"]
[null,"Materials"]
[null,"Sub-Totals"]
[null,"Summary"]
[null,"Sub-Total Labour"]
[null,"Sub-Total Materials"]
[null,"Total Maintenance"]
[null,"Asset Management Support"]
[null,"Operations"]
[null,"OHS"]
[null,"Taxes and Charges"]
[null,"Insurance"]
[null,"Total System Recurrent"]
[null,"System Non-Recurrent"]
[null,"Asset Works Program"]
[null,"Asset Management Support"]
[null,"Total System Non-Recurrent"]
[null,"Non-System"]
[null,"Finance"]
[null,"HR"]
[null,"IT "]
[null,"Other"]
[null,"Total Non-System"]
[null,"Summary"]
[null,"Total Labour"]
[null,"Total Maintenance Materials"]
[null,"Total Other Materials"]
[null,"TOTAL OPEX"]
[]
[]
[null,"Grand Total"]
[]
[null,"Revenue Cap Allowance"]

{"sheet":"Historic Capex by Category","index":23,"n_rows":38,"n_cols":12,"rows_kept":38,"cut":false,"hidden":false,"merged":[[37,0,37,8],[1,1,1,9],[18,10,19,10],[18,11,19,11],[17,0,17,1],[10,4,11,4],[10,8,11,10],[18,9,19,9],[10,12,11,14],[15,0,16,3],[15,5,16,5],[20,10,21,10],[20,11,21,11],[18,7,19,7],[20,7,21,7],[20,8,21,8],[20,9,21,9],[18,8,19,8]]}
[]
[null,"HISTORIC CAPEX by project category"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["$M nominal"]
[]
["Project Category",null,null,null,null,"Any Part Year","Year 1","Year 2","Year 3","Year 4","Year 5","TOTAL"]
[]
["NETWORK"]
["NON-LOAD DRIVEN ","Replacements"]
[]
[null,"Security/Compliance"]
[]
[null,"Other"]
[]
["NON NETWORK"]
["BUSINESS IT",null,"Information Technology"]
[]
["SUPPORT THE BUSINESS ",null,"Buildings"]
[]
[null,null,"Motor Vehicles"]
[]
[null,null,"Other"]
[]
[]
["TOTAL FDC"]
["TOTAL HISTORIC CAPEX"]
[]
["Note:\nPer AER's Explanatory Statement of April 2015 accompanying the Final Electricity Transmission Network Service Providers Information Guideline Version 2, this schedule is not required to be completed, as it is duplicated in the Category Analysis RIN. "]

{"sheet":"Hist Capex by Asset Class ","index":24,"n_rows":123,"n_cols":12,"rows_kept":123,"cut":false,"hidden":false,"merged":[[52,1,52,2],[33,1,33,11],[50,1,50,2],[51,1,51,2],[45,0,45,2],[46,0,46,2],[47,1,47,2],[48,1,48,2],[49,1,49,2],[35,1,35,11],[120,0,120,11],[103,1,103,2],[104,1,104,2],[109,1,109,2],[110,1,110,2],[111,1,111,2],[112,1,112,2],[114,1,114,2],[115,1,115,2],[116,1,116,2],[117,1,117,2],[105,1,105,2],[106,1,106,2],[107,1,107,2],[108,1,108,2],[113,1,113,2],[87,1,87,2],[101,0,101,2],[102,0,102,2],[95,0,95,11],[100,0,100,11],[92,1,92,11],[91,1,91,11],[93,1,93,11],[81,1,81,2],[82,1,82,2],[84,1,84,2],[85,1,85,2],[86,1,86,2],[83,1,83,2],[72,0,72,2],[73,1,73,2],[74,1,74,2],[79,1,79,2],[80,1,80,2],[75,1,75,2],[76,1,76,2],[77,1,77,2],[78,1,78,2],[60,1,60,2],[61,1,61,2],[71,0,71,2],[64,0,64,11],[70,0,70,11],[56,1,56,2],[58,1,58,2],[59,1,59,2],[53,1,53,2],[54,1,54,2],[55,1,55,2],[57,1,57,2],[28,1,28,2],[44,0,44,11],[40,0,40,11],[20,1,20,2],[12,0,12,2],[13,0,13,2],[14,1,14,2],[15,1,15,2],[21,1,21,2],[22,1,22,2],[23,1,23,2],[25,1,25,2],[26,1,26,2],[27,1,27,2],[32,1,32,11],[24,1,24,2],[1,1,1,11],[16,1,16,2],[17,1,17,2],[18,1,18,2],[19,1,19,2],[11,0,11,11]]}
[]
[null,"HISTORIC CAPEX by asset class"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Actual Gross Capital Expenditure – As Incurred ($m Nominal)"]
[null,null,null,"Year"," Year-1","Year 1 ","Year 2","Year 3","Year 4","Year 5"]
["Asset Class",null,null,null,"2013/14","2014/15","2015/16","2016/17","2017/18","2018/19"]
[null,"Secondary",null,null,22.83210468039541,19.465660642516806,25.589870173653473,22.710749813654758]
[null,"Switchgear",null,null,35.877728225982445,42.689826410909006,34.885451209620555,33.434845907347018]
[null,"Transformers",null,null,27.708005056516065,30.425251843003053,25.920314020372647,33.474629320051321]
[null,"Reactive",null,null,2.3706541887911592,4.780705191136998,0.92788693362605779,-0.52951966834055098]
[null,"Transmission Lines",null,null,16.508827640665459,11.673394612774308,24.98364677612286,18.491040782469192]
[null,"Establishment",null,null,9.4820413844320228,10.720904103934968,12.449506217603265,9.0965854045736609]
[null,"Communications",null,null,7.4007483102478266,9.2449017147418431,5.1066478303571863,7.6343364966567355]
[null,"Network Switching Centre",null,null,0,0,0,0]
[null,"Easements",null,null,0,0,0,0]
[null,"Land",null,null,0,0,0,0]
[null,"Inventory",null,null,0.82268350999999995,1.8376839300000007,-0.2882583161984682,-1.6880570638015195]
[null,"Non-System - IT",null,null,17.829885547794877,19.252516986367041,8.5902199355590767,6.4238288436792672]
[null,"Non-System - Motor Vehicles",null,null,1.082195620771875,0.77391822438256452,0.6881363832089149,0.59929508825646705]
[null,"Non-System - Premises",null,null,0.51538516445382854,0.12822143598848168,0,0.3504345612978248]
[null,"Non-System - Other",null,null,2.7167518610796657,2.1651706699914399,1.5640854533378956,1.4220831158575651,null,null,"Total Yrs 1-5","Total"]
[null,null,null,"Sub total",145.14701119113062,153.15815576574653,140.41750661726348,{"$f":"SUM(H15:H29)","v":131.42025260170169},{"$f":"SUM(I15:I29)","v":0},{"$f":"SUM(J15:J29)","v":0},{"$f":"SUM(F30:J30)","v":424.9959149847117},{"$f":"SUM(E30:J30)","v":570.14292617584238}]
[null,null,null,null,null,null,0,0]
[null,"Note 1:"]
[null,"2016/17: There are no customer contribution adjustments for 2016/17. Total Capital Expenditure reported is net of $2.264m claimed against self-insurance provision. \n2015/16: There are no customer contribution adjustments for 2015/16. Total Capital Expenditure reported is net of $0.548m claimed against self-insurance provision. \n2014/15: The 2014/15 total capital expenditure is net of customer contribution of $0.144m, and net of $3.283m in capex incurred claimed against self-insurance provision. \n2013/14: There were no customer contribution and self insurance adjustments for 2013/14."]
[]
[null,"Note 2:"]
[null,"Regarding Project XB17 Refurbishment of Geelong Terminal Station, the allocation into the asset class categories under 2013/14 have been amended to align with the final commissioning of the asset. This revised allocation was applied to the 2014/15 capex spend as well. Nil in 2015/16. Nil in 2016/17."]
[]
[]
[]
[]
["Notes: \n - Exclude half year rate of return. Inputs are assumed to be in middle of year terms because actual capex is reported evenly over a financial year.\n- The asset classes inputed by each TNSP must be the same as those used in the RFM/PTRM.\n-  Yr -1 is the final year of the previous regulatory control period.\n - Capex should be adjusted for any movements in capitalised provisions and be net of customer contributions. Where relevant please note the amount of any customer contributions excluded. \n- TNSPs are to update capex as incurred for previous years of the regulatory control period to reflect any movements that may have occurred (e.g. due to the final commissioning of assets). When this information is updated TNSPs must also note the reason for the movement.\n- Where capex related to Network Capability Incentive Parameter Action Plan (NCIPAP) projects has been incurred and reported across asset classes, the total amount for each project should be noted.\n\n"]
[]
[]
[]
["Actual Asset Disposal – As Incurred ($m Nominal)"]
[null,null,null,"Year","Year -1","Year 1 ","Year 2 ","Year 3","Year 4 ","Year 5"]
["Asset Class",null,null,null,"2013/14","2014/15","2015/16","2016/17","2017/18","2018/19"]
[null,"Secondary",null,null,0,0,0,0]
[null,"Switchgear",null,null,0,0,0,0]
[null,"Transformers",null,null,0,0,0,0]
[null,"Reactive",null,null,0,0,0,0]
[null,"Transmission Lines",null,null,0,0,0,0]
[null,"Establishment",null,null,0,0,0,0]
[null,"Communications",null,null,0,0,0,0]
[null,"Network Switching Centre",null,null,0,0,0,0]
[null,"Easements",null,null,0,0,0,4.5454499999999995E-3]
[null,"Land",null,null,0,0,0,0]
[null,"Inventory",null,null,0,0,0,0]
[null,"Non-System - IT",null,null,0,0,0,0]
[null,"Non-System - Motor Vehicles",null,null,0,0,0,0.1165935]
[null,"Non-System - Premises",null,null,0,0,0,0]
[null,"Non-System - Other",null,null,0,0,0,0,null,null,"Total Yrs 1-5","Total"]
[null,null,null,"Sub total",{"$f":"SUM(E48:E62)","v":0},0,0,{"$f":"SUM(H48:H62)","v":0.12113895},{"$f":"SUM(I48:I62)","v":0},0,{"$f":"SUM(F63:J63)","v":0.12113895},{"$f":"SUM(E63:J63)","v":0.12113895}]
[null,null,null,null,0,0,0,0]
["Notes: \n- Exclude half year rate of return. Inputs are assumed to be in middle of year terms because actual disposal is reported evenly over a financial year.\n- The asset classes inputed by each TNSP must be the same as those used in the RFM/PTRM.\n-  Yr -1 is the final year of the previous regulatory control period.\n"]
[]
[]
[]
[]
[]
["Actual Gross Capital Expenditure – As Commissioned ($m Nominal)"]
[null,null,null,"Year"," Year -1","Year 1","Year 2","Year 3","Year 4 ","Year 5"]
["Asset Class",null,null,null,"2013/14","2014/15","2015/16","2016/17","2017/18","2018/19"]
[null,"Secondary",null,null,19.725339989496597,40.164764456793812,15.246549637052485,28.707639230029905]
[null,"Switchgear",null,null,28.29735618939058,38.205402135977707,17.825673400143735,29.51234152016465]
[null,"Transformers",null,null,37.248642642026979,10.519436394220545,10.043675364227035,14.45647039558504]
[null,"Reactive",null,null,1.5406729361234837,4.9608781030424298,1.0606280569760191,0.15007790870233706]
[null,"Transmission Lines",null,null,27.500377860620649,24.276042344595236,18.474459016879393,21.764053960694866]
[null,"Establishment",null,null,23.048375485368489,29.348804584305554,27.18487846620889,9.7540009764565596]
[null,"Communications",null,null,8.634042372587615,19.635342159345022,3.6734818073850484,10.331201363411239]
[null,"Network Switching Centre",null,null,0,0,0,0]
[null,"Easements",null,null,0,0,0,0]
[null,"Land",null,null,0,0,0,0]
[null,"Inventory",null,null,0.82268350999999995,1.8376839300000007,-0.2882583161984682,-1.6880570638015195]
[null,"Non-System - IT",null,null,14.719180980357644,3.8346741475394399,33.452068014270438,6.5930119576154818]
[null,"Non-System - Motor Vehicles",null,null,1.6096788331765914,0.67303633126232487,0.68844100552316001,0.48839939125078502]
[null,"Non-System - Premises",null,null,0.2441075824500834,0.44512568635885108,0,0]
[null,"Non-System - Other",null,null,4.7494108467278355,3.1874545308005957,0.93648951106652889,1.6682347915923907,null,null,"Total Yrs 1-5","Total"]
[null,null,null,"Sub total",168.13986922832652,177.08864480424151,128.29808596353428,{"$f":"SUM(H74:H88)","v":121.73737443170174},{"$f":"SUM(I74:I88)","v":0},0,{"$f":"SUM(F89:J89)","v":427.12410519947753},{"$f":"SUM(E89:J89)","v":595.26397442780399}]
[null,null,null,null,null,null,0,0]
[null,"Note 3:"]
[null,"2016/17: There are no customer contribution adjustments for 2016/17. Total Capital Expenditure reported is net of $2.264m claimed against self-insurance provision as mentioned in Note 1 above."]
[null,"2015/16: There is no customer contribution adjustment. Total Capital Expenditure reported is net of $3.145m in capex commissioned relating to projects claimed against self-insurance provision in 2014/15 and 2015/16 as mentioned in Note 1 above."]
[null,"2014/15: Total Capital Expenditure reported is net of customer contribution of $0.144m, and net of $0.494m in capex commissioned relating to projects claimed against self-insurance provision in 2014/15 as mentioned in Note 1 above."]
[null,"2013/14: There are no customer contribution and self insurance adjustments."]
["Notes: \n - Exclude half year rate of return. Inputs are assumed to be in middle of year terms because actual capex is reported evenly over a financial year.\n- The asset classes inputed by each TNSP must be the same as those used in the RFM/PTRM.\n-  Yr -1 is the final year of the previous regulatory control period.\n -  Capex should be adjusted for any movements in capitalised provisions and be net of customer contributions. Where relevant please note the amount of any customer contributions excluded.\n- Where capex related to Network Capability Incentive Parameter Action Plan (NCIPAP) projects has been incurred and reported across asset classes, the total amount for each project should be noted.\n "]
[]
[]
[]
[]
["Actual Asset Disposal – As De-Commissioned ($m Nominal)"]
[null,null,null,"Year"," Year -1","Year 1 ","Year 2 ","Year 3","Year 4 ","Year 5"]
["Asset Class",null,null,null,"2013/14","2014/15","2015/16","2016/17","2017/18","2018/19"]
[null,"Secondary",null,null,0,0,0,0]
[null,"Switchgear",null,null,0,0,0,0]
[null,"Transformers",null,null,0,0,0,0]
[null,"Reactive",null,null,0,0,0,0]
[null,"Transmission Lines",null,null,0,0,0,0]
[null,"Establishment",null,null,0,0,0,0]
[null,"Communications",null,null,0,0,0,0]
[null,"Network Switching Centre",null,null,0,0,0,0]
[null,"Easements",null,null,0,0,0,4.5454499999999995E-3]
[null,"Land",null,null,0,0,0,0]
[null,"Inventory",null,null,0,0,0,0]
[null,"Non-System - IT",null,null,0,0,0,0]
[null,"Non-System - Motor Vehicles",null,null,0,0,0,0.1165935]
[null,"Non-System - Premises",null,null,0,0,0,0]
[null,"Non-System - Other",null,null,0,0,0,0,null,null,"Total Yrs 1-5","Total"]
[null,null,null,"Sub total",{"$f":"SUM(E104:E118)","v":0},0,0,0.12113895,{"$f":"SUM(I104:I118)","v":0},0,{"$f":"SUM(F119:J119)","v":0.12113895},{"$f":"SUM(E119:J119)","v":0.12113895}]
[null,null,null,null,0,0,0,0]
["Notes: \n- Exclude half year rate of return. Inputs are assumed to be in middle of year terms because actual disposal is reported evenly over a financial year.\n- The asset classes inputed by each TNSP must be the same as those used in the RFM/PTRM.\n-  Yr -1 is the final year of the previous regulatory control period.\n"]
[]
["Note: Totals may not add due to rounding."]

{"sheet":"Hist Capex - Network","index":25,"n_rows":112,"n_cols":17,"rows_kept":112,"cut":false,"hidden":false,"merged":[[10,4,11,4],[10,8,11,10],[1,1,1,15],[14,5,15,11]]}
[]
[null,"HISTORIC CAPEX - NETWORK- by project"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["$M nominal"]
[null,null,null,null,null,"Yearly expenditure by project (inclusive of FDC)"]
[]
["Project ID","Project Description"," Commissioning Date","Category^",null,"Any Part Year","Year 1","Year 2","Year 3","Year 4","Year 5","TOTAL",null,"REASON FOR PROJECT","Reg Test / Business Case (Y/N)","Reg Test / Business Case Cost Estimate","Reason for Variance from Cost Estimate / Expected Commissioning Date"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"Subtotal"]
[]
[null,null,null,"^refers to Categories (e.g Augmentation, Replacement, etc) as defined in  “Historic Capex Instructions” worksheet  ",null,null,null,null,null,"*Note that values in these columns are estimates only"]
[]
["Note:\nPer AER's Explanatory Statement of April 2015 accompanying the Final Electricity Transmission Network Service Providers Information Guideline Version 2, this schedule is not required to be completed, as it is duplicated in the Category Analysis RIN."]

{"sheet":"Hist Capex - Non-Network","index":26,"n_rows":33,"n_cols":17,"rows_kept":33,"cut":false,"hidden":false,"merged":[[1,1,1,15],[10,4,11,4],[10,8,11,10],[14,5,15,11]]}
[]
[null,"HISTORIC CAPEX - NON-NETWORK- by project"]
[null,null,null,null,null,null,null,null,"(Prescribed; Incurred)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["$M nominal"]
[null,null,null,null,null,"Yearly expenditure by project (inclusive of FDC)"]
[]
["Project ID","Project Description"," Commissioning Date","Category^",null,"Any Part Year","Year 1","Year 2","Year 3","Year 4","Year 5","TOTAL",null,"REASON FOR PROJECT","Reg Test / Business Case (Y/N)","Reg Test / Business Case Cost Estimate","Reason for Variance from Cost Estimate / Expected Commissioning Date"]
[null,"Computer Equipment/Projects",null,"Information Technology",null,null,19.28125790226597,8.7530900242491274,6.3030901293932553,null,null,{"$f":"SUM(G18:K18)","v":34.337438055908351}]
[null,"General Equipment and Funiture",null,"Other",null,null,0,0,0,null,null,{"$f":"SUM(G19:K19)","v":0}]
[null,"Tools and Equipment",null,"Other",null,null,1.3093433999999995,1.1967315701013599,1.3953544325139184,null,null,3.9014294026152774]
[null,"Other General Assets",null,"Other",null,null,0.8590595220744861,0.10739864647400735,0,null,null,0.96645816854849342]
[null,"Property - Buildings",null,"Buildings",null,null,0.12841285,0,0.34384798818043644,null,null,0.4722608381804364]
[null,"Vehicles/Plant",null,"Motor Vehicles",null,null,0.77507355999999983,0.65320377281977204,0.58803107107998132,null,null,2.0163084038997532]
[null,"Recoverable Works Construction",null,"Other",null,null,0,0,0,null,null,0]
[]
[]
[null,null,null,null,null,"Subtotal",{"$f":"SUM(G18:G25)","v":22.353147234340454},{"$f":"SUM(H18:H25)","v":10.710424013644266},8.6303236211675927,null,null,{"$f":"SUM(L18:L25)","v":41.693894869152317}]
[null,null,null,null,null,null,0,0,0,null,null,0]
[null,null,null,"^refers to Categories (e.g Augmentation, Replacement, etc) as defined in  “Historic Capex Instructions” worksheet  ",null,null,null,null,null,"*Note that values in these columns are estimates only"]
[]
[]
["Note: Totals may not add due to rounding."]
["Note: Capex presented in this schedule is not adjusted for any movements in capitalised provisions. "]

{"sheet":"NCIPAP projects","index":27,"n_rows":47,"n_cols":12,"rows_kept":47,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,"NCIPAP capex - by project"]
[null,null,"(Prescribed; Incurred & Commissioned)"]
[]
[]
["$M nominal"]
[]
[]
["Project ID","NCIPAP projects (As Incurred)",null,null,null,"Any Part Year","Year 1\n2014/15","Year 2\n2015/16","Year 3\n2016/17","Year 4\n","Year 5\n","TOTAL\n"]
[]
["XD05","Network Capability Incentive Parameter Action Plan (NCIPAP)",null,null,"see Note 1 below",null,-0.10403819396221334,3.8591884735205916E-3,7.8279999999999989E-5,null,null,{"$f":"SUM(G11:I11)","v":-0.10010072548869274}]
["026A","NCIPAP 4 Emergency Control Scheme for the loss of both DDTS to MSS 330kV lines",null,null,null,null,4.0732393705688347E-2,0.49643545805367728,1.1571783100000002,null,null,1.6943461617593658]
["027A","NCIPAP 5 Emergency Control Scheme for the loss of both DDTS to SMTS 330kV lines",null,null,null,null,4.962264365203297E-2,0.22529056822665286,1.2988874399999999,null,null,1.5738006518786858]
["028A","NCIPAP 6 Replace two 220kV isolators and protection setting change at Rowville T",null,null,null,null,4.5340125850324264E-2,6.9450272905219636E-3,6.6536999999999998E-4,null,null,5.2950523140846223E-2]
["029A","NCIPAP 7 Increase instrumentation range for eleven specified circuits",null,null,null,null,3.0764450501263495E-2,0.10944316118335295,5.386450000000001E-2,null,null,0.19407211168461647]
["030A","NCIPAP 8 Wind monitoring scheme on Rowville to Malvern 220kV lines",null,null,null,null,1.0677273223272469E-2,0.13107093517919519,5.1101750000000001E-2,null,null,0.19284995840246766]
["031A","NCIPAP 9 Establish inter-trip control systems for APD",null,null,null,null,2.0676572530078249E-2,1.0088234966692092E-2,0.74793655999999997,null,null,0.77870136749677032]
[]
[]
[]
[]
[null,null,null,null,null,"Subtotal",{"$f":"SUM(G10:G20)","v":9.3775265500446459E-2},{"$f":"SUM(H10:H20)","v":0.98313257337361293},3.3097122099999998,0,0,4.3866200488740601]
[null,null,null,null,null,null,0,0,0,0,0,0]
["Note 1:"]
["Project ID XD05 is a parent/general project number which records NCIPAP capex prior to being re-allocated to dedicated NCIPAP project numbers such as NCIPAP 4 to NCIPAP 9 above."]
["In 2014/15, the -$0.104m negative figure is largely due to a reallocation of costs captured in 2013/14 and 2014/15 to dedicated NCIPAP projects."]
[]
[]
[]
[]
[]
["Project ID","NCIPAP projects (As Commissioned)",null,null,null,"Any Part Year","Year 1\n2014/15","Year 2\n2015/16","Year 3\n2016/17","Year 4\n","Year 5\n","TOTAL\n"]
[]
["XD05","Network Capability Incentive Parameter Action Plan (NCIPAP)",null,null,null,null,0,0,0,null,null,{"$f":"SUM(G34:I34)","v":0}]
["026A","NCIPAP 4 Emergency Control Scheme for the loss of both DDTS to MSS 330kV lines",null,null,null,null,0,0,1.6526081354970141,null,null,1.6526081354970141]
["027A","NCIPAP 5 Emergency Control Scheme for the loss of both DDTS to SMTS 330kV lines",null,null,null,null,0,0,1.5350321083411533,null,null,1.5350321083411533]
["028A","NCIPAP 6 Replace two 220kV isolators and protection setting change at Rowville T",null,null,null,null,3.7361770000000002E-2,0,1.5204744369395206E-2,null,null,5.2566514369395211E-2]
["029A","NCIPAP 7 Increase instrumentation range for eleven specified circuits",null,null,null,null,0,0,0.18929139622215657,null,null,0.18929139622215657]
["030A","NCIPAP 8 Wind monitoring scheme on Rowville to Malvern 220kV lines",null,null,null,null,0,0,0.18809934910540552,null,null,0.18809934910540552]
["031A","NCIPAP 9 Establish inter-trip control systems for APD",null,null,null,null,0,0,0.75951906646487211,null,null,0.75951906646487211]
[]
[]
[]
[]
[null,null,null,null,null,"Subtotal",{"$f":"SUM(G33:G43)","v":3.7361770000000002E-2},{"$f":"SUM(H33:H43)","v":0},4.339754799999997,0,0,4.3771165699999974]
[null,null,null,null,null,null,0,0,0,0,0,0]
["Note: Totals may not add due to rounding."]

{"sheet":"Commentary on Opex","index":28,"n_rows":41,"n_cols":1,"rows_kept":41,"cut":false,"hidden":true,"merged":[]}
["Historic Opex Commentary proforma: key cost drivers"]
[]
["This pro forma is designed to allow the TNSP to provide context and background for the quantitative opex templates."]
[]
["The historic opex tables provide a column where the key cost drivers for historic opex should be briefly listed.  This commentary pro forma provides opportunity for more detailed explanations regarding material changes in particular expenses over the relevant regulatory period.  "]
[]
["The commentary should address the following:"]
[]
[">The main cost drivers for the particular opex item (eg changes in CPI, legislative and regulatory requirements, environmental factors)."]
[">Were these increases foreseeable? If not, why not?"]
[">Details of management induced opex efficiencies achieved."]
[">Major opex risks and mitigation strategies."]
[">Key Performance Indicators – are these benchmarked against other transmission companies?"]
[]
["In addition, the TNSP is requested to provide:"]
[]
[">Definitions of ‘opex’ and ‘capex’ used by the business.  Further, the TNSP should provide definitions for the categories and activities used in the opex templates.  These definitions should be added to the definition section in the opex instructions."]
[">A discussion on the relationship between opex and capex."]
[">Details of changes in accounting policies over the past regulatory period and how they may have impacted on opex in general or specific opex items."]
[]
[]
["Commentary on cost drivers and material changes over the current regulatory period"]
["Expense item eg. salaries"]
[]
["Expense item template"]
[]
["Expense item"]
[]
["Supporting information"]
["Please list documentation substantiating the reason for change"]
["(eg. asset management plan/strategy.)"]
[]
["Commentary on cost drivers and material changes affecting the upcoming regulatory period "]
["Expense item eg. salaries"]
[]
["Expense item"]
[]
["Expense item"]
[]
["Supporting information"]
["Please list documentation substantiating the reason for change"]

{"sheet":"Commentary on Historic Capex","index":29,"n_rows":27,"n_cols":1,"rows_kept":27,"cut":false,"hidden":true,"merged":[]}
["Historic Capex Commentary Proforma: reasons for variance"]
[]
["This pro forma is designed to allow TNSP's to provide context and background for the quantitative historic capex templates."]
[]
["Tables HOE Netw and HCE Non Netw provide a column where reasons for capex cost variances may be briefly listed.  This pro forma provides the opportunity for more detailed reasons to be given for material differences between actual project costs and amounts included in the regulatory test/business case assessment.  "]
[]
["The commentary should address the following:"]
[]
[">The main reasons for the project being undertaken (eg. demand growth)"]
[">The main reasons for material cost variances for the particular project (eg changes in material costs, legislative and regulatory requirements, environmental factors, technology changes) and whether they were forseeable."]
[">The main reason for any material variance in commissioning date (e.g delays in supply of materials, environmental approvals etc) and whether they were forseeable. "]
[">How does the project align with the TNSP's asset management strategy/plan?"]
[">Reference to the project's assessment in the TNSP's Annual Planning Reports."]
[">Details of management induced capex efficiencies which have reduced costs."]
[">Major project risks and strategies undertaken to mitigate them."]
[]
["In addition, the TNSP is requested to provide:"]
["Commentary on reasons for variance"]
["Project (unique identifying number or name)"]
[]
["Project"]
[]
[]
["Project"]
[]
["Supporting information"]
["Please list documentation in support of reasons"]

{"sheet":"Opex Instructions","index":30,"n_rows":29,"n_cols":2,"rows_kept":29,"cut":false,"hidden":true,"merged":[[1,0,1,1],[2,0,5,0],[6,0,10,0],[11,0,28,0]]}
["OPEX - Instructions and definitions"]
["Note: These definitions are a guide only.  TNSPs can adapt the definition section as necessary, given consultation with the AER."]
["PURPOSE OF INFORMATION AND USE BY THE AER:","The historic worksheets are a key input into the AER's assessment of a TNSP's historic opex performance to assist it in establishing a starting point from which to set efficient opex for the next regulatory period."]
[null,"The forecast worksheets are a key input into the AER's assessment of a TNSPs proposed forecast opex."]
[null,"Key cost drivers for expenditure are important to the AER's understanding of what has happened in the current regulatory period and any step changes in opex claimed for the next regulatory period."]
[]
["INSTRUCTIONS","Data to be input on the basis of the definitions provided."]
[null,"All expenditure must relate to the provision of prescribed transmission services."]
[null,"Key cost drivers for expenditure: reasons for material changes in costs should be expanded upon in the relevant opex commentary proforma."]
[null,"Templates must be completed in accordance with the instructions contained in the AER's Submission Guidelines and Cost Allocation Guidelines."]
[null,"All cells must be filled out where possible, especially in relation to any commentary on variances. "]
["DEFINITIONS","Asset Manager Support:  those operational activities to support the strategic development and ongoing asset management of the network. Asset Management Support has 5 major sub-elements: Grid Planning, Project Support, Network Customer & Regulatory Support, IT Support, and Operational Support."]
[null,"Asset monitoring: the asset monitoring team performing remote monitoring of TNSP’s network."]
[null,"Condition based maintenance: maintenance activities based on inspection/assessment of the condition of an asset."]
[null,"Corporate Support : the support activities required by the TNSP in order to ensure adequate and effective corporate governance. The three aspects of corporate support are: Insurance, Corporate Support (the Board etc), and Other Support."]
[null,"Corrective maintenance: activities that restore a failed component to an operational state."]
[null,"Direct Charges: costs associated with owning and managing assets, which include council rates charges, water charges, electricity bills and permits etc."]
[null,"Field maintenance: includes all field activities, performed by maintenance service providers, to ensure the item of plant can perform its required functions. "]
[null,"Field Support: field-based activities performed by maintenance service providers which are not directly related to working on an item of plant."]
[null,"Key cost drivers: significant factors driving expenditure such as age and condition of assets, size of network, CPI, labour costs, legislative requirements."]
[null,"Network Monitoring and control: includes all activities in operating and monitoring assets in the field."]
[null,"Network switching: the control centre function and ongoing management of the energy management system (EMS)."]
[null,"NMS support: the telecommunications network management system (NMS).  "]
[null,"Non-network: all activities not directly related to the operation and maintenance of the network, including administrative, planning and engineering support costs. "]
[null,"Operational refurbishment: TNSP to provide definition."]
[null,"Opex: expenditure related to operating and maintaining assets which is not capex."]
[null,"Other Support: Non field based activities associated with maintenance activities.  "]
[null,"Routine maintenance: recurrent activities undertaken to maintain assets."]
[null,"Support/corporate: opex that is not directly related to maintenance activities."]

{"sheet":"Historic Capex Instructions","index":31,"n_rows":28,"n_cols":2,"rows_kept":28,"cut":false,"hidden":true,"merged":[[13,0,27,0],[1,0,1,1],[2,0,5,0],[6,0,12,0]]}
["HISTORIC CAPEX - Instructions and definitions"]
["Note: These definitions are a guide only.  TNSPs can adapt the definition section as necessary, given consultation with the AER."]
["PURPOSE OF INFORMATION AND USE BY THE AER:","The templates are key inputs into the AER's assessment of historic capex and will assist in the analysis of the TNSP's forecast capex claim."]
[null,"Specifying expenditure by project enables the AER to select projects on which to undertake more detailed analysis."]
[null,"The capex categories are essentially divided between Network and Non-network.  Network includes augmentation capex which is subject to the Regulatory Test."]
[]
["INSTRUCTIONS:","Data to be input on the basis of the definitions provided."]
[null,"All expenditure must relate to the provision of prescribed transmission services."]
[null,"Categorisation of capex should be performed according to the primary reason for expenditure."]
[null,"Capex amounts should be entered exclusive of customer contributions."]
[null,"Reasons for variance: if actual expenditure materially varies from the amount determined under the Regulatory Test/Business case, or the date of commissioning was later than planned, then reasons should be given on the Historic Capex Commentary pro forma with a brief reference in the 'Reasons for variance' column of HOE Netw and HOE Non Netw."]
[null,"Templates must be completed according to the instructions contained in the AER's Submission Guidelines."]
[null,"All cells must be filled out where possible, especially in relation to any commentary on variances. "]
["DEFINITIONS:","Augmentation: are as defined under the National Electricity Rules (NER) as works to enlarge a network or to increase the capability of a network to transmit (or distribute) active energy.  "]
[null,"Business case: a detailed cost/benefit analysis undertaken to support an investment."]
[null,"Capex: expenditure that satisfies one or more of the following requirements - relates to the purchase or construction of a new asset; increases the functionality of the asset; or extends the service life of the asset. "]
[null,"Connections: changes to connections between the transmission and distribution networks."]
[null,"Easements: land acquisitions and rights of way for transmission lines.  "]
[null,"FDC: financing during construction - finance charges up to the point of completion of the project."]
[null,"IT: Business IT expenditure."]
[null,"Other (Load Driven): anything else driven by increasing load."]
[null,"Other (Non-Load Driven): all other projects associated with the network which provides prescribed transmission services such as communications systems enhancements."]
[null,"Project ID: A unique numerical identifier for a given project"]
[null,"Project Description: A short description of the project"]
[null,"Regulatory Test: the test as promulgated by the ACCC to assess augmentation expenditure. A prudency test must be applied to other capex undertaken in the current regulatory period."]
[null,"Replacements: replacement or life extension of network assets.  "]
[null,"Security/Compliance: projects undertaken to ensure the physical security of assets and compliance with amendments to various technical, safety or environmental legislation. "]
[null,"Support the business: non-network capex relating to commercial buildings, motor vehicles and tools (but excluding IT)."]