{"text_format":"1","workbook":"xlsx","n_sheets":14,"sheets":["Index","RFS Inc","DISAGG Inc","DISAGG Opex","DISAGG Aloc1","DISAGG Aloc2","PTS Adj","PTS PriceRedn","PTS PDisc","DISAGG ProvSum","INF RelPartTrans","INF RevRec","Hist Capex by Asset Class ","Hist Capex - Non-Network"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":5,"defined_names":30,"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":63,"n_cols":5,"rows_kept":63,"cut":false,"hidden":true,"merged":[[50,1,55,1],[56,1,59,1],[60,1,63,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,49,1]]}
[]
[null,"INFORMATION DISCLOSURE REQUIREMENTS"]
[]
[null,null,"TABLE OF CONTENTS"]
[null,null,"for the year ended [type here]"]
[]
[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",5]
[]
[null,"Prescribed Transmission Services"]
[null,null,"Regulatory adjustment journals","PTS Adj",6]
[]
[null,null,"Price reduction/recovery ","PTS PriceRedn",7]
[]
[null,null,"Discount","PTS  Disc",8]
[]
[null,null,"Revenue analysis","PTS Rev",9]
[]
[null,"Asset schedules and supporting papers:"]
[null,"Prescribed Transmission Services","Asset Aging Schedule","PTS Asset Aging",10]
[]
[null,"Provisions Schedules:"]
[null,"Disaggregation Statements","Provisions Summary","DISAGG ProvSum",11]
[null,null,"Provisions Reconciliation","PTS ProvRec",12]
[]
[null,"Other Information"]
[null,null,"Related Party Transactions","Inf Rel Part Trans",13]
[null,null,"Revenue Reconciliation","Inf Rev Rec",14]
[]
[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",15]
[null,null,"Historic Opex by Category base year","HOE Base",16]
[null,null,"Historic Opex by Category 1st FY","HOE 1st FY",17]
[null,null,"Historic Opex by Category 2nd FY","HOE 2ndt FY",18]
[null,null,"Historic Opex by Category 3rd FY","HOE 3rdt FY",19]
[null,null,"Historic Opex by Category 4th FY","HOE 4th FY",20]
[null,null,"Historic Opex by Category 5th FY","HOE 5th FY",21]
[]
[null,"Historic Capital Expenditure (Capex)"]
[null,null,"Historic Capex by Category","HCE Cat",22]
[null,null,"Historic Capex by Asset Class ","HCE Ass Cls",23]
[null,null,"Historic Capex - Network","HCE Netw",24]
[null,null,"Historic Capex - Non-Network","HCE Non Netw",25]
[]
[null,"Commentary"]
[null,null,"Commentary on Opex","Comm Opex",26]
[null,null,"Commentary on Historic Capex","Comm Hist Capex",27]
[]
[null,"Instructions"]
[null,null,"Opex Instructions","Ins Opex",28]
[null,null,"Historic Capex Instructions","Ins Capex",29]

{"sheet":"RFS Inc","index":1,"n_rows":47,"n_cols":8,"rows_kept":47,"cut":false,"hidden":false,"merged":[[4,0,4,7],[1,0,1,7],[42,0,42,7],[0,0,0,7]]}
["Powerlink "]
["INCOME STATEMENT - PRESCRIBED TRANSMISSION SERVICES"]
[]
[]
[]
[]
["for the period ended: ",null,"30 June 2018"]
[]
["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,"Network Charges",null,{"$f":"'DISAGG Inc'!F12","v":810828},null,null,{"$f":"D13+F13","v":810828}]
[null,"Grid Support Under Recovery Accrual",null,{"$f":"'DISAGG Inc'!F13","v":0}]
[null,"External Project Work",null,{"$f":"'DISAGG Inc'!F14","v":0}]
[null,"Other Revenue ",null,{"$f":"'DISAGG Inc'!F15","v":0}]
[null,null,"Customer Works",{"$f":"'DISAGG Inc'!F16","v":0}]
[null,null,"Other",{"$f":"'DISAGG Inc'!F17","v":5024},"2018-01",-4907.0678899999994,{"$f":"D18+F18","v":116.93211000000065}]
[]
[null,"Total Revenue",null,{"$f":"SUM(D12:D19)","v":815852},null,{"$f":"SUM(F12:F19)","v":-4907.0678899999994},{"$f":"SUM(G12:G19)","v":810944.93211000005}]
[]
[]
[null,"Opex Costs "]
[null,"-","Network Operations",{"$f":"'DISAGG Inc'!F21","v":14800},null,null,{"$f":"D24+F24","v":14800}]
[null,"-","Network Maintenance ",{"$f":"'DISAGG Inc'!F22","v":111604},null,null,111604]
[null,"-","Corporate / Business Support",{"$f":"'DISAGG Inc'!F23","v":52556},null,null,52556]
[null,"-","Insurance and Self Insurance",{"$f":"'DISAGG Inc'!F24","v":14051},"2018-01",-5897.9869097851843,8153.0130902148157]
[null,"-","Debt Management Costs",{"$f":"'DISAGG Inc'!F25","v":501},null,null,501]
[null,"-","Grid Support",{"$f":"'DISAGG Inc'!F26","v":0},null,null,0]
[null,"-","Other Costs ",{"$f":"'DISAGG Inc'!F27","v":0},null,null,0]
[null,"Depreciation",null,{"$f":"'DISAGG Inc'!F28","v":302021},null,null,302021]
[null,"Net Loss/(Gain) on Disposal of Property, Plant & Equipment",null,{"$f":"'DISAGG Inc'!F29","v":-306},null,null,-306]
[null,"Total Operating Costs",null,{"$f":"SUM(D24:D32)","v":495227},null,{"$f":"SUM(F24:F32)","v":-5897.9869097851843},{"$f":"SUM(G24:G32)","v":489329.01309021481}]
[]
[null,"Earnings before Interest and Tax (EBIT)",null,{"$f":"D20-D33","v":320625},null,{"$f":"F20-F33","v":990.9190197851849},{"$f":"G20-G33","v":321615.91901978524}]
[]
[null,"Taxation"]
[]
[]
["Note: The above numbers have been derived from Powerlink Queensland's financial reporting systems."]
[]
["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":58,"n_cols":10,"rows_kept":58,"cut":false,"hidden":false,"merged":[[1,0,1,9],[4,0,4,9],[53,0,53,9],[0,0,0,7]]}
["Powerlink "]
["DISAGGREGATION STATEMENT - INCOME"]
[]
[]
[]
[]
["for the period ended:",null,"30 June 2018"]
[]
["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,"Network Charges",null,987706,null,810828]
[null,"Grid Support Under Recovery Accrual"]
[null,"External Project Work"]
[null,"Other Revenue "]
[null,null,"Customer Works",12076,null,0]
[null,null,"Other",17969,null,5024]
[null,"Total Revenue",null,1017751,null,815852]
[]
[null,"Opex Costs "]
[null,"-","Network Operations ",16424,null,14800]
[null,"-","Network Maintenance",119236,null,111604]
[null,"-","Corporate / Business Support",62155,null,52556]
[null,"-","Insurance and Self Insurance",14051,null,14051]
[null,"-","Debt Management Costs",501,null,501]
[null,"-","Grid Support",0,null,0]
[null,"-","Other Costs ",10980,null,0]
[null,"Depreciation ",null,334758,null,302021]
[null,"Net Loss/(Gain) on Disposal of Property, Plant & Equipment",null,-306,null,-306]
[null,"Total Operating Costs",null,557799,null,495227]
[]
[null,"Earnings before Interest and Tax (EBIT)",null,459952,null,320625]
[]
[null,"Interest and Dividend Income",null,8052,null,null,null,null,8052]
[null,"Finance Charges",null,-224898,null,null,null,null,-224898]
[null,"Share of Net Profit/(Loss) of Associates"]
[null,"Profit(loss) before Income Tax Expense ",null,243106]
[]
[null,"Australian income tax expense",null,90930,null,null,null,null,90930]
[null,"Deferred income tax",null,-15149,null,null,null,null,-15149]
[null,"Other income tax",null,null,null,null,null,null,0]
[]
[]
[]
[null,"Profit(loss) after income tax expense",null,167325]
[]
[null,"Dividends Provided for / Paid",null,217325,null,null,null,null,217325]
[null,"Retained Earnings Adjustments",null,23776,null,null,null,null,23776]
[null,"Retained Profit(Loss)",null,-26224]
[]
[]
["Note: The above numbers have been derived from Powerlink Queensland's financial reporting systems."]
["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":52,"n_cols":13,"rows_kept":52,"cut":false,"hidden":false,"merged":[[4,0,4,12],[1,0,1,12],[51,2,51,11],[0,0,0,7]]}
["Powerlink "]
["OPERATIONS AND MAINTENANCE EXPENDITURE"]
[]
[]
[]
[]
["for the period ended: ",null,null,{"$f":"'RFS Inc'!C7","v":"30 June 2018"}]
[]
["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 ",null,null,null,null,14800,null,null,null,16424]
[null,null,null,"Network Maintenance ",null,null,null,null,111604,null,null,null,119236]
[null,null,null,"Corporate / Business Support",null,null,null,null,52556,null,null,null,53086]
[null,null,null,"Insurance and Self Insurance",null,null,null,null,8153.0130902148157,null,null,null,8153.0130902148157]
[null,null,null,"Debt Management Costs",null,null,null,null,501,null,null,null,501]
[null,null,null,"Grid Support",null,null,null,null,0,null,null,null,0]
[null,null,null,"Other Costs ",null,null,null,null,0,null,null,null,10980]
[null,null,null,"Depreciation ",null,null,null,null,302021,null,null,null,334758]
[null,null,null,"Net Loss/(Gain) on Disposal of Property, Plant & Equipment",null,null,null,null,-306,null,null,null,-306]
[null,null,null,null,null,null,"Subtotal of Directly Attributed costs",null,489329.01309021481,null,null,{"$f":"SUM(L13:L21)","v":0},542832.01309021481]
[]
[]
[]
[null,null,null,"Allocated Costs","Basis of allocation",null,"Work paper Ref."]
[null,null,null,"Network Operations","Causal",null,null,null,0,null,null,{"$f":"'DISAGG Aloc1'!G23","v":0},0]
[null,null,null,"Network Maintenance","Causal",null,null,null,0,null,null,{"$f":"'DISAGG Aloc1'!G24","v":0},0]
[null,null,null,"Corporate / Business Support","Causal",null,"DISAGG Aloc1",null,0,null,null,{"$f":"'DISAGG Aloc1'!G25","v":0},9069]
[]
[]
[]
[null,null,null,null,null,null,"Subtotal of Allocated costs",null,0,null,null,{"$f":"SUM(L27:L32)","v":0},9069]
[]
[]
[null,null,null,null,null,null,"Total Opex Costs per DISAGG Fperf 1",null,489329.01309021481,null,null,{"$f":"L22+L33","v":0}]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null," Total",551901.01309021481]
[]
[]
["Explanation of opex costs required by the Commission (for example, bushfire costs, insurance etc)"]
[]
[]
[]
[]
[null,null,"1 Including Regulatory Adjustments as per RFS Inc"]
[null,null,"*","Delete as appropriate"]
[null,null,"**","For each Account Heading item subject to Causal allocation, ensure that it is included on a  workpaper  Aloc 1"]
[null,null,null,"For each Account Heading item subject to Non-Causal allocation, ensure that it is included on a  workpaper  Aloc 2"]
[null,null,"Note:  Where Intersegmental costs arise, the total costs of all Business Segments will be greater than the costs \nin the Base Accounts. This is why the reconciliation to the Base Accounts is required on this schedule."]

{"sheet":"DISAGG Aloc1","index":4,"n_rows":33,"n_cols":8,"rows_kept":33,"cut":false,"hidden":false,"merged":[[1,0,1,7],[4,10,4,11],[4,0,4,7],[8,0,8,7],[0,0,0,7]]}
["Powerlink "]
["CAUSAL ALLOCATION"]
[]
[]
[]
[]
["for the period ended:",null,{"$f":"'RFS Inc'!C7","v":"30 June 2018"}]
[]
["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 ","GROSS BOOK VALUE"]
[]
[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,"Numeric quantity of allocator  (eg no of man-hours)",null,null,null,null,null,1185705]
[null,"Network Operations",null,null,null,null,null,0]
[null,"Network Maintenance",null,null,null,null,null,0]
[null,"Corporate / Business Support",null,null,null,null,null,9069]
[null,null,null,{"$f":"SUM(D23:D25)","v":0},null,null,{"$f":"SUM(G23:G25)","v":0},9069]
[]
[]
[]
[null,"3.   Provide a detailed description and explanation of the basis of allocation:"]
[]
[null,"Powerlink does not separately account for the above \"Negotiated\"  and \"Non-Regulated\" Corporate / Business Support  operating costs."]
[null,"These costs have been allocated on the basis of Opening Gross Book Value."]

{"sheet":"DISAGG Aloc2","index":5,"n_rows":56,"n_cols":8,"rows_kept":56,"cut":false,"hidden":true,"merged":[[1,0,1,6],[45,1,45,8],[17,1,17,2],[4,9,4,10],[8,0,8,8],[12,1,12,8],[4,0,4,7],[14,1,14,2]]}
[]
["NON-CAUSAL ALLOCATION"]
[]
[]
[]
[]
["for the period ended: [type here]"]
[]
["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":6,"n_rows":51,"n_cols":6,"rows_kept":51,"cut":false,"hidden":false,"merged":[[4,0,4,5],[1,0,1,4],[0,0,0,7]]}
["Powerlink "]
["REGULATORY ADJUSTMENT JOURNALS - PRESCRIBED TRANSMISSION SERVICES"]
[]
[]
[]
[]
["for the period ended: ",null,{"$f":"'RFS Inc'!C7","v":"30 June 2018"}]
[]
["Journal","Account Debited",null,"Amount",null,"Supporting"]
["number",null,"Account Credited","Debit","Credit","Statement"]
[null,null,null,"$'000","$'000","No."]
[]
[]
["2018-01","Other Revenue",null,4907.0678899999994]
[null,"Self Insurance Provision",null,990.91901978518467]
[null,null,"Insurance and Self Insurance",null,5897.9869097851843]
[]
[null,null,"Provision for self insurance has been provided in the Powerlink Queensland Transmission Network Revenue Cap 2017-18 to 2021-22.  This provision has only been made in the regulatory accounts due to AASB 137 - Provisions, Contingent Liabilities and Contingent Assets not allowing any provision for unidentifiable or unmeasurable costs."]
[null,null,"Revenue disclosed in the Financial Statements includes insurance proceeds.  For regulatory accounts, this is presented as an offset against self insurance costs."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Note:"]
["This schedule must contain for each Regulatory Adjustment made on "]
["the Income Statement, the following:"]
["a) a journal entry showing accounts debited and credited"]
["b) an explanation of why the adjustment has been made."]

{"sheet":"PTS PriceRedn","index":7,"n_rows":33,"n_cols":3,"rows_kept":33,"cut":false,"hidden":false,"merged":[[4,9,4,10],[1,0,1,3],[4,0,4,3],[0,0,0,7]]}
["Powerlink "]
["PRICE REDUCTION/RECOVERY - PRESCRIBED TRANSMISSION SERVICES"]
[]
[]
[]
[]
["for the period ended:",{"$f":"'RFS Inc'!C7","v":"30 June 2018"}]
[]
[null,"$'000 Customer TUOS","$'000 Common service"]
[null,"general charges","charges"]
["Reduction in prices payable"]
[]
[]
[]
[]
[]
["     Total Reduction"]
[]
["Recovery of  above reduction in prices"]
["from other transmission customers 1"]
[]
[]
[]
["     Total Recovery"]
[]
[]
["Note:"]
["Each instance of a price reduction/recovery should be detailed."]
["1 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. "]
[]
["COMMENTS"]

{"sheet":"PTS PDisc","index":8,"n_rows":35,"n_cols":4,"rows_kept":35,"cut":false,"hidden":false,"merged":[[0,0,0,7],[1,0,1,7],[4,0,4,7],[21,1,21,2],[21,3,21,7],[22,3,22,7],[23,3,23,7],[34,1,34,2],[34,3,34,7],[35,3,35,7],[36,3,36,7]]}
["Powerlink "]
["PRUDENT DISCOUNTS - PRESCRIBED TRANSMISSION SERVICES"]
[]
[]
[]
[]
["for the period ended: ",null,null,{"$f":"'RFS Inc'!C7","v":"30 June 2018"}]
[]
[]
[]
[]
[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."]
[]
[]
[]
["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":"DISAGG ProvSum","index":9,"n_rows":51,"n_cols":8,"rows_kept":51,"cut":false,"hidden":false,"merged":[[0,0,0,7],[1,0,1,6],[4,0,4,6],[4,8,4,9],[39,0,39,5],[50,0,50,5]]}
["Powerlink "]
["SUMMARY OF PROVISIONS"]
[]
[]
[]
[]
["for the period ended: ",null,null,{"$f":"'RFS Inc'!C7","v":"30 June 2018"}]
[]
[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,null,null,null,219514,{"$f":"SUM(D12:G12)","v":219514}]
[]
[null,"Expenditure incurred debited to provisions",null,null,null,null,-253462,{"$f":"SUM(D14:G14)","v":-253462}]
[]
[null,"Amounts written back from provisions",null,null,null,null,-148,{"$f":"SUM(D16:G16)","v":-148}]
[]
[null,"Net movement in provisions",null,{"$f":"SUM(D12:D17)","v":0},0,0,{"$f":"SUM(G12:G17)","v":-34096},{"$f":"SUM(H12:H17)","v":-34096}]
[]
[null,"Balance at start of period",null,null,null,null,242976,{"$f":"SUM(D20:G20)","v":242976}]
[]
[null,"Balance at end of period",null,null,null,null,{"$f":"SUM(G18:G21)","v":208880},{"$f":"SUM(H18:H21)","v":208880}]
[]
[]
["Comprising:"]
[]
[null,"Current provisions",null,null,null,null,205568,{"$f":"SUM(D27:G27)","v":205568}]
[null,"Non-current provision",null,null,null,null,3312,3312]
[]
[null,null,"Total per balance sheet",null,null,null,{"$f":"SUM(G27:G29)","v":208880},{"$f":"SUM(H27:H29)","v":208880}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["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."]

{"sheet":"INF RelPartTrans","index":10,"n_rows":66,"n_cols":5,"rows_kept":66,"cut":false,"hidden":false,"merged":[[1,0,1,4],[56,0,56,4],[4,0,4,4],[0,0,0,7]]}
["Powerlink "]
["RELATED PARTY TRANSACTIONS"]
[]
[]
[]
[]
["for the period ended: ",{"$f":"'RFS Inc'!C7","v":"30 June 2018"}]
[]
["Details of related party","Description of transaction","Prescribed","Procurement process","Monetary value of transaction"]
[null,null,null,null,"$'000"]
[]
[null,"Revenue"]
[null,"- Sale of Goods and Services","Part","Competitive Process",747689]
[null,"- Dividend and Interest Income","Part","N/A",8044]
[]
[]
[]
[null,"Expense"]
[null,"  - Purchases of Goods and Services","Part","Competitive Process",98844]
[null,"  - Borrowing Costs","Part","N/A",224534]
[]
[]
[]
[null,"Capital"]
[]
[]
[]
[]
[]
[]
["Balances with related parties at regulatory accounting date"]
[null,null,null,null,"$'000"]
[]
[null,"Current assets"]
[null,"- Receivables",null,null,51075]
[null,"- Advances",null,null,230770]
[null,"- Cash and cash equivalents",null,null,1224]
[null,"Non-current assets"]
[]
[]
[]
[]
[null,"Total assets",null,null,{"$f":"SUM(E35:E42)","v":283069}]
[]
[null,"Current liabilities"]
[null,"- Payables",null,null,831]
[]
[]
[null,"Non-current liabilities"]
[null,"- Loans",null,null,5265221]
[]
[]
[]
[null,"Total liabilities",null,null,{"$f":"SUM(E46:E53)","v":5266052}]
[]
["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"]
[]
[null,"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"]

{"sheet":"INF RevRec","index":11,"n_rows":20,"n_cols":6,"rows_kept":20,"cut":false,"hidden":false,"merged":[[1,0,1,5],[4,0,4,5],[0,0,0,7]]}
["Powerlink "]
["REVENUE RECONCILIATION "]
[]
[]
[]
[]
["for the period ended: ",null,null,{"$f":"'RFS Inc'!C7","v":"30 June 2018"}]
[]
[null,"Description",null,"Unit type","Unit"]
[]
[]
[null,"CPI (March Tx)",null,"CPI – All Groups Weighted Average of 8 \nCapital Cities (ABS)",null,"N/A    "]
[null,"CPI (March Tx+1)",null,"As above",null,"N/A    "]
[null,"Change in CPI",null,"Per cent",null,"N/A    "]
[null,"X-factor",null,"Per cent",null,"N/A    "]
[null,"AR (Tx)",null,"$",null,"N/A    "]
[null,"AR (Tx+1)",null,"$",null,752668.97606670402]
[null,"S-factor (Tx)",null,"$+",null,24004.305]
[null,"Under/over recovery AR (Tx)",null,"$+",null,"N/A    "]
[null,"Revenue Cap Tx+1",null,"$",null,776673.28106670408]

{"sheet":"Hist Capex by Asset Class ","index":12,"n_rows":115,"n_cols":12,"rows_kept":115,"cut":false,"hidden":false,"merged":[[0,0,0,7],[67,0,67,2],[40,1,40,2],[114,0,114,11],[68,1,68,2],[93,0,93,2],[94,0,94,2],[87,0,87,11],[92,0,92,11],[95,1,95,2],[37,0,37,11],[33,0,33,11],[38,0,38,2],[39,0,39,2],[66,0,66,2],[59,0,59,11],[65,0,65,11],[15,1,15,2],[28,1,28,2],[27,1,27,2],[29,1,29,2],[30,1,30,2],[1,1,1,15],[16,1,16,2],[24,1,24,2],[25,1,25,2],[26,1,26,2],[11,0,11,11],[17,1,17,2],[18,1,18,2],[19,1,19,2],[20,1,20,2],[21,1,21,2],[22,1,22,2],[23,1,23,2],[12,0,12,2],[13,0,13,2],[14,1,14,2]]}
["Powerlink "]
[null,"HISTORIC CAPEX by asset class"]
[]
[]
[]
[]
[]
[]
["for the period ended: ",null,{"$f":"'RFS Inc'!C7","v":"30 June 2018"}]
[]
[]
["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,"Transmission Lines - Overhead",null,null,1.2605004928275432,7.9698890394608863]
[null,"Transmission Lines - Underground",null,null,-1.873578332153052E-2,0]
[null,"Transmission Lines - Refit",null,null,43.004950814363056,66.497043295989172]
[null,"Substations Primary Plant",null,null,51.713134630997345,37.460218897783285]
[null,"Substations Secondary Systems",null,null,36.483386773313569,20.713484378493789]
[null,"Communications Other Assets",null,null,2.1326915619832261,1.2857378879700716]
[null,"Comms - Civil Works",null,null,0,0]
[null,"Network Switching Centres",null,null,0.17755073664990406,2.0165170251231664E-2]
[null,"Land",null,null,0.10259986221019929,3.4947056049158348E-2]
[null,"Easements",null,null,5.9340549706181989,-0.28215050875362363]
[null,"Commercial Buildings",null,null,1.2577742394977303,1.1390091385025827]
[null,"Computer Equipment",null,null,23.069432280878438,11.162722343664397]
[null,"Office Furniture & Miscellaneous",null,null,0,0]
[null,"Office Machines",null,null,0,0]
[null,"Vehicles",null,null,1.2593157645656574,2.9188503817527418]
[null,"Moveable Plant",null,null,1.4892354454166545,0.86727523883629276]
[null,"Insurance Spares",null,null,0,0,null,null,null,null,"Total Yrs 1-5","Total"]
[null,null,null,"Sub total",{"$f":"SUM(E15:E31)","v":167.86589179000001},{"$f":"SUM(F15:F31)","v":149.78719232},0,0,{"$f":"SUM(I15:I31)","v":0},{"$f":"SUM(J15:J31)","v":0},{"$f":"SUM(F32:J32)","v":149.78719232},{"$f":"SUM(E32:J32)","v":317.65308411000001}]
[]
["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,"Transmission Lines - Overhead",null,null,0,0]
[null,"Transmission Lines - Underground",null,null,0,0]
[null,"Transmission Lines - Refit",null,null,0,0]
[null,"Substations Primary Plant",null,null,0,0]
[null,"Substations Secondary Systems",null,null,0,0]
[null,"Communications Other Assets",null,null,0,1.5334909999999999]
[null,"Comms - Civil Works",null,null,0,0]
[null,"Network Switching Centres",null,null,0,0]
[null,"Land",null,null,0.4,0.25454545000000001]
[null,"Easements",null,null,0,0]
[null,"Commercial Buildings",null,null,0,0]
[null,"Computer Equipment",null,null,0,0]
[null,"Office Furniture & Miscellaneous",null,null,0,0]
[null,"Office Machines",null,null,0,0]
[null,"Vehicles",null,null,0.60088180999999996,0.58773631999999998]
[null,"Moveable Plant",null,null,0,0]
[null,"Insurance Spares",null,null,0,0,null,null,null,null,"Total Yrs 1-5","Total"]
[null,null,null,"Sub total",{"$f":"SUM(E41:E57)","v":1.0008818100000001},{"$f":"SUM(F41:F57)","v":2.3757727699999998},{"$f":"SUM(G41:G57)","v":0},{"$f":"SUM(H41:H57)","v":0},{"$f":"SUM(I41:I57)","v":0},0,{"$f":"SUM(F58:J58)","v":2.3757727699999998},{"$f":"SUM(E58:J58)","v":3.3766545799999999}]
[]
["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,"Transmission Lines - Overhead",null,null,0.62952481961007001,8.6869913145913973]
[null,"Transmission Lines - Underground",null,null,0,0]
[null,"Transmission Lines - Refit",null,null,16.052882900056787,9.2199523399532274E-2]
[null,"Substations Primary Plant",null,null,36.438022865417381,37.641063528899998]
[null,"Substations Secondary Systems",null,null,63.668491021010787,31.365190733154392]
[null,"Communications Other Assets",null,null,6.0719981802006435,1.2864917121034052]
[null,"Comms - Civil Works",null,null,4.8270273708120384E-2,2.5126165980396867E-2]
[null,"Network Switching Centres",null,null,0,0]
[null,"Land",null,null,-0.79847077758849139,3.1236466410010833E-3]
[null,"Easements",null,null,11.361615674048837,3.524927142268087]
[null,"Commercial Buildings",null,null,5.7029317124739736,2.3474113428086483]
[null,"Computer Equipment",null,null,14.690253298504638,30.796047465038988]
[null,"Office Furniture & Miscellaneous",null,null,0,1.1657118564967566E-3]
[null,"Office Machines",null,null,2.9726443558584137,0.37773371066036299]
[null,"Vehicles",null,null,1.4088886138557637,2.8696551253761688]
[null,"Moveable Plant",null,null,1.1353570628430816,1.8743943572211217]
[null,"Insurance Spares",null,null,0,0,null,null,null,null,"Total Yrs 1-5","Total"]
[null,null,null,"Sub total",{"$f":"SUM(E69:E85)","v":159.38240999999999},{"$f":"SUM(F69:F85)","v":120.89152147999999},{"$f":"SUM(G69:G85)","v":0},{"$f":"SUM(H69:H85)","v":0},{"$f":"SUM(I69:I85)","v":0},0,{"$f":"SUM(F86:J86)","v":120.89152147999999},{"$f":"SUM(E86:J86)","v":280.27393147999999}]
[]
["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,"Transmission Lines - Overhead",null,null,0,0]
[null,"Transmission Lines - Underground",null,null,0,0]
[null,"Transmission Lines - Refit",null,null,0,0]
[null,"Substations Primary Plant",null,null,0,0]
[null,"Substations Secondary Systems",null,null,0,0]
[null,"Communications Other Assets",null,null,0,1.5334909999999999]
[null,"Comms - Civil Works",null,null,0,0]
[null,"Network Switching Centres",null,null,0,0]
[null,"Land",null,null,0.4,0.25454545000000001]
[null,"Easements",null,null,0,0]
[null,"Commercial Buildings",null,null,0,0]
[null,"Computer Equipment",null,null,0,0]
[null,"Office Furniture & Miscellaneous",null,null,0,0]
[null,"Office Machines",null,null,0,0]
[null,"Vehicles",null,null,0.60088180999999996,0.58773631999999998]
[null,"Moveable Plant",null,null,0,0]
[null,"Insurance Spares",null,null,0,0,null,null,null,null,"Total Yrs 1-5","Total"]
[null,null,null,"Sub total",{"$f":"SUM(E96:E112)","v":1.0008818100000001},{"$f":"SUM(F96:F112)","v":2.3757727699999998},{"$f":"SUM(G96:G112)","v":0},{"$f":"SUM(H96:H112)","v":0},{"$f":"SUM(I96:I112)","v":0},0,{"$f":"SUM(F113:J113)","v":2.3757727699999998},{"$f":"SUM(E113:J113)","v":3.3766545799999999}]
[]
["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"]

{"sheet":"Hist Capex - Non-Network","index":13,"n_rows":110,"n_cols":17,"rows_kept":110,"cut":false,"hidden":false,"merged":[[1,1,1,15],[10,4,11,4],[10,8,11,10],[14,5,15,11],[0,0,0,7]]}
["Powerlink "]
[null,"HISTORIC CAPEX - NON-NETWORK- by project"]
[]
[]
[]
[]
[]
[]
[]
[]
["for the period ended: ",null,{"$f":"'RFS Inc'!C7","v":"30 June 2018"}]
[]
[]
["$M nominal"]
[null,null,null,null,null,"Yearly expenditure by project (exclusive 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,"IT",null,null,0.65746154000000001,null,null,null,null,{"$f":"SUM(F18:K18)","v":0.65746154000000001},null,"Obsolescence/Strategic","Bus Case"]
[null,null,null,"IT",null,null,1.1383581299999999,null,null,null,null,{"$f":"SUM(F19:K19)","v":1.1383581299999999},null,"Obsolescence/Strategic","Bus Case"]
[null,null,null,"IT",null,null,0.66404638000000005,null,null,null,null,0.66404638000000005,null,"Operational","Bus Case"]
[null,null,null,"IT",null,null,0.64424982999999991,null,null,null,null,0.64424982999999991,null,"Operational","Bus Case"]
[null,null,null,"IT",null,null,0.51454350999999998,null,null,null,null,0.51454350999999998,null,"Operational","Bus Case"]
[null,null,null,"IT",null,null,0.25361220000000001,null,null,null,null,0.25361220000000001,null,"Age/Condition/Obsolescence","Bus Case"]
[null,null,null,"IT",null,null,0.59544076000000001,null,null,null,null,0.59544076000000001,null,"Operational","Bus Case"]
[null,null,null,"IT",null,null,0.30249963000000002,null,null,null,null,0.30249963000000002,null,"Operational","Bus Case"]
[null,null,null,"IT",null,null,0.32000828000000003,null,null,null,null,0.32000828000000003,null,"Obsolescence/Strategic","Bus Case"]
[null,null,null,"IT",null,null,0.89896494999999998,null,null,null,null,0.89896494999999998,null,"Operational","Bus Case"]
[null,null,null,"IT",null,null,1.15941428,null,null,null,null,1.15941428,null,"Age/Condition/Obsolescence","Bus Case"]
[null,null,null,"IT",null,null,1.09637096,null,null,null,null,1.09637096,null,"Security","Bus Case"]
[null,null,null,"IT",null,null,0.62684627999999998,null,null,null,null,0.62684627999999998,null,"Security","Bus Case"]
[null,null,null,"IT",null,null,0.5313328100000001,null,null,null,null,0.5313328100000001,null,"Obsolescence/Strategic","Bus Case"]
[null,null,null,"IT",null,null,0.86044010999999998,null,null,null,null,0.86044010999999998,null,"Obsolescence/Strategic","Bus Case"]
[null,null,null,"IT",null,null,0.66185558999999994,null,null,null,null,0.66185558999999994]
[null,null,null,"IT",null,null,0.25418836,null,null,null,null,0.25418836]
[null,null,null,"MV",null,null,2.9232723700000003,null,null,null,null,2.9232723700000003,null,"Annual Cycle"]
[null,null,null,"Buildings",null,null,1.1407347099999998,null,null,null,null,1.1407347099999998,null,"Age/Condition/Obsolescence"]
[null,null,null,"Land",null,null,0,null,null,null,null,0]
[null,null,null,"Tools",null,null,0.86858913999999998,null,null,null,null,0.86858913999999998,null,"Additional requirements"]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(F83:K83)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[]
[null,null,null,null,null,"Subtotal",{"$f":"SUM(G18:G106)","v":16.112229820000003},{"$f":"SUM(H18:H106)","v":0},0,0,0,16.112229820000003]
[]
[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"]