{"text_format":"1","workbook":"xlsx","n_sheets":27,"sheets":["Cover","Index","ACC Pol","RFS Inc","DISAGG Inc","DISAGG Opex","Ls_XLB_WorkbookFile","Ls_AgXLB_WorkbookFile","DISAGG Aloc1","DISAGG Aloc2","PTS Adj","PTS PriceRedn","PTS PDisc","PTS Rev","PTS Asset Aging","DISAGG ProvSum","PTS ProvRec ","INF RelPartTrans","INF RevRec","Historic Opex Summary","Historic Opex by Category","Historic Capex by Category","Hist Capex by Asset Class ","Hist Capex - Network","Hist Capex - Non-Network","DRS","Sheet1"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":17,"defined_names":40,"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":"Cover","index":0,"n_rows":19,"n_cols":1,"rows_kept":19,"cut":false,"hidden":false,"merged":[[4,0,4,8],[6,0,6,8],[12,0,12,8],[13,0,13,8],[18,0,18,8]]}
[]
[]
[]
[]
["Tasmanian Networks Pty Ltd"]
[]
["ABN 24 167 357 299"]
[]
[]
[]
[]
[]
["Transmission Network Service Provider"]
["Regulatory Financial Statements"]
[]
[]
[]
[]
["2016-17"]

{"sheet":"Index","index":1,"n_rows":67,"n_cols":5,"rows_kept":67,"cut":false,"hidden":false,"merged":[[1,1,1,4],[37,1,40,1],[16,1,20,1],[10,1,12,1],[13,1,15,1],[21,1,29,1],[58,1,58,4],[54,1,56,1],[48,1,53,1],[44,1,47,1],[41,1,43,1]]}
[]
[null,"INFORMATION DISCLOSURE REQUIREMENTS"]
[]
[null,null,"TABLE OF CONTENTS"]
[null,null,"for the year ended 30 June 2017"]
[]
[null,"TYPE","PROFORMA STATEMENT","STATEMENT NUMBER","PAGE"]
[]
[null,"Accounting Policies","Accounting Policies","ACC Pol",3]
[]
[null,"Regulatory Financial Statements"]
[null,null,"Income Statement","RFS Inc",4]
[]
[null,"Disaggregation Statements"]
[null,null,"Income Statement","DISAGG Inc",5]
[]
[null,"Workpapers supporting the Disaggregation Statements:"]
[null,null,"Operations and maintenance expenditure","DISAGG Opex",6]
[null,null,"Causal allocations","DISAGG Aloc1",7]
[null,null,"Non-causal allocations","DISAGG Aloc2",8]
[]
[null,"Prescribed Transmission Services"]
[null,null,"Regulatory adjustment journals","PTS Adj",9]
[]
[null,null,"Price reduction/recovery ","PTS PriceRedn",10]
[]
[null,null,"Discount","PTS  Disc",11]
[]
[null,null,"Revenue analysis","PTS Rev",12]
[]
[null,"Asset schedules and supporting papers:"]
[null,"Prescribed Transmission Services","Asset Aging Schedule","PTS Asset Aging",13]
[]
[null,"Provisions Schedules:"]
[null,"Disaggregation Statements","Provisions Summary","DISAGG ProvSum",14]
[null,null,"Provisions Reconciliation","PTS ProvRec",15]
[]
[null,"Other Information"]
[null,null,"Related Party Transactions","Inf Rel Part Trans",16]
[null,null,"Revenue Reconciliation","Inf Rev Rec",17]
[]
[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",18]
[null,null,"Historic Opex by Category 2nd FY","HOE 2ndt FY",19]
[]
[null,"Historic Capital Expenditure (Capex)"]
[null,null,"Historic Capex by Category","HCE Cat",20]
[null,null,"Historic Capex by Asset Class ","HCE Ass Cls",21]
[null,null,"Historic Capex - Network","HCE Netw",23]
[null,null,"Historic Capex - Non-Network","HCE Non Netw",24]
[]
[null,"Directors Responsibility Statement"]
[null,null,"Directors Responsibility Statement","DRS",25]
[]
[null,"© Tasmanian Networks Pty Ltd 2017"]
[null,"This work is copyright.  Apart from any use as permitted under the Copyright Act 1968, no part of the work may be reproduced by any process without permission from Tasmanian Networks Pty Ltd."]
[]
[null,"Tasmanian Networks Pty Ltd"]
[null,"ABN 24 167 357 299"]
[]
[null,"Registered office","1-7 Maria Street"]
[null,"and postal address","Lenah Valley TAS 7008 Australia"]
[null,"Telephone","1300 137 008"]
[null,"Internet","www.tasnetworks.com.au"]

{"sheet":"ACC Pol","index":2,"n_rows":14,"n_cols":2,"rows_kept":14,"cut":false,"hidden":false,"merged":[[13,0,13,7],[1,0,1,7],[3,0,3,7],[5,1,5,7],[7,0,7,7],[9,0,9,7],[11,1,11,7]]}
[]
["SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES"]
[]
["The accounting policies adopted for TasNetworks' Transmission Network Service Provider Regulatory Financial Statements are the same as those identified in our audited financial report for the year ended 30 June 2017 with the following exceptions:"]
[]
["(a)","Property, plant and equipment"]
[]
["Depreciation is calculated using the effective life of the asset that was provided in the most recent regulatory determination."]
[]
["Proceeds received on the disposal of assets are deducted from the written down value of the asset. Any remaining balance of the asset is depreciated over the remaining effective life of the asset. Any excess is recognised as income in the year it is received."]
[]
["(b)","Customer contributions"]
[]
["Customer contributions received for the construction of a prescribed asset are deducted off the cost of the asset for regulatory purposes as opposed to being treated as revenue under the accounting standards."]

{"sheet":"RFS Inc","index":3,"n_rows":43,"n_cols":8,"rows_kept":43,"cut":false,"hidden":false,"merged":[[4,0,4,7],[1,0,1,7],[38,0,38,7]]}
[]
["INCOME STATEMENT - PRESCRIBED TRANSMISSION SERVICES"]
[]
[]
[]
[]
["for the period ended: 30 June 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,"Network charges",null,{"$f":"'DISAGG Inc'!F12","v":175101.98929},null,null,{"$f":"D13-F13","v":175101.98929}]
[null,"Gross proceeds from sale of assets",null,{"$f":"'DISAGG Inc'!F14","v":20},null,null,{"$f":"D14-F14","v":20}]
[null,"Other revenue (analysed as appropriate)",null,0,null,null,0]
[]
[null,"Total Revenue",null,{"$f":"SUM(D13:D16)","v":175121.98929},null,{"$f":"SUM(F12:F16)","v":0},{"$f":"SUM(G12:G16)","v":175121.98929}]
[]
[]
[null,"Opex costs"]
[null,"-","Field operations and maintenance",{"$f":"-'DISAGG Inc'!F23","v":15150.015319999993},null,null,{"$f":"D21+F21","v":15150.015319999993}]
[null,"-","Transmission services",{"$f":"-'DISAGG Inc'!F25","v":5561.5440562918575},null,null,{"$f":"D22+F22","v":5561.5440562918575}]
[null,"- ","Customer and Asset management",{"$f":"-'DISAGG Inc'!F26","v":1157.874676954093},null,null,1157.874676954093]
[null,"-","Corporate",{"$f":"-'DISAGG Inc'!F27","v":7307.5979154630941},null,null,7307.5979154630941]
[null,"-","Transmission operations",{"$f":"-'DISAGG Inc'!F28","v":2123.1997928686251},null,null,2123.1997928686251]
[null,"-","NCIPAP",{"$f":"-'DISAGG Inc'!F29","v":0},null,null,0]
[null,"Self Insurance",null,0,"77",{"$f":"'PTS Adj'!D18","v":747.95962248658407},{"$f":"D27+F27","v":747.95962248658407}]
[null,"Depreciation",null,{"$f":"-'DISAGG Inc'!F31","v":69614.426380469318},"78",{"$f":"-'PTS Adj'!E24","v":-8310},{"$f":"D28+F28","v":61304.426380469318}]
[null,"Book value of assets disposed",null,{"$f":"-'DISAGG Inc'!F33","v":14.787230000000001},null,{"$f":"-'PTS Adj'!E29","v":0},{"$f":"D29+F29","v":14.787230000000001}]
[null,null,null,null,null,null,{"$f":"D30-F30","v":0}]
[null,"Earnings before Interest and Tax (EBIT)",null,{"$f":"D17-SUM(D18:D30)","v":74192.543917953022},null,{"$f":"SUM(F18:F30)","v":-7562.0403775134164},{"$f":"G17-SUM(G18:G30)","v":81754.584295466426}]
[]
[]
[]
[null,"Taxation",null,{"$f":"D31*0.3","v":22257.763175385906},null,{"$f":"F31*0.3","v":-2268.6121132540247},{"$f":"G31*0.3","v":24526.375288639927}]
[]
[]
["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":4,"n_rows":58,"n_cols":16,"rows_kept":58,"cut":false,"hidden":false,"merged":[[1,0,1,9],[4,0,4,9],[53,0,53,9]]}
[]
["DISAGGREGATION STATEMENT - INCOME"]
[]
[]
[]
[]
["for the period ended: 30 June 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,"Regulated Transmission Charges",null,{"$f":"'[6]Summary P&L'!$B$11","v":178742},null,{"$f":"'[6]Summary P&L'!$L$11","v":175101.98929},{"$f":"'[6]Summary P&L'!$N$11","v":3640.0251800000001},null,{"$f":"D12-SUM(F12:H12)","v":-1.4469999994616956E-2}]
[null,"Regulated Distribution Charges",null,{"$f":"'[6]Summary P&L'!$B$10","v":325816.48615000001},null,null,null,null,{"$f":"D13-SUM(F13:H13)","v":325816.48615000001}]
[null,"Gross proceeds from sale of assets",null,89,null,20,null,null,69]
[null,"Other revenue:"]
[null,null,"Other non-regulated services",{"$f":"'[6]Summary P&L'!$B$12","v":35540},null,0,{"$f":"'[6]Summary P&L'!$N$12","v":0},{"$f":"'[6]Summary P&L'!$M$12","v":1727.8929900000001},{"$f":"D16-SUM(F16:H16)","v":33812.10701}]
[null,null,"Customer Contributions",{"$f":"'[6]Summary P&L'!$B$13","v":12114.488590000001},null,0,{"$f":"'[6]Summary P&L'!$N$13","v":936.25295999999992},{"$f":"'[6]Summary P&L'!$M$13","v":0},11178.235630000001]
[]
[]
[null,"Total Revenue",null,{"$f":"SUM(D12:D19)","v":552301.97473999998},null,{"$f":"SUM(F12:F19)","v":175121.98929},{"$f":"SUM(G12:G19)","v":4576.2781400000003},{"$f":"SUM(H12:H19)","v":1727.8929900000001},{"$f":"SUM(I12:I19)","v":370875.81432}]
[]
[null,"Opex costs",null,null,null,null,null,null,{"$f":"D22-SUM(F22:H22)","v":0}]
[null,"-","Field operations and maintenance",{"$f":"-('[7]Trans & Other Summary'!$B$107)/1000-D24","v":-15150.015319999993},null,{"$f":"D23","v":-15150.015319999993},0,0,{"$f":"D23-SUM(F23:H23)","v":0}]
[null,"- ","Other direct costs",{"$f":"SUM(F24:I24)","v":-6434.5303599999988},null,0,{"$f":"-('[7]Trans & Other Summary'!$B$158+'[7]Trans & Other Summary'!$B$161)/1000","v":-225.67618999999996},{"$f":"-('[7]Trans & Other Summary'!$B$167+'[7]Trans & Other Summary'!$B$172+'[7]Trans & Other Summary'!$B$175+'[7]Trans & Other Summary'!$B$178)/1000","v":-1817.5991999999997},{"$f":"-'[8]Trans & Other Summary'!$B$48/1000","v":-4391.254969999999}]
[null,"-","Transmission services",{"$f":"SUM(F25:I25)","v":-5689.7388300755383},null,{"$f":"-('[7]Trans & Other Summary'!$H$183+'[7]Trans & Other Summary'!$H$186+'[7]Trans & Other Summary'!$H$190+'[7]Trans & Other Summary'!$H$196+'[7]Trans & Other Summary'!$H$199+'[7]Trans & Other Summary'!$H$202+'[7]Trans & Other Summary'!$H$206)/1000-([9]Adjustments!$B$28/1000)","v":-5561.5440562918575},{"$f":"-('[7]Trans & Other Summary'!$H$158+'[7]Trans & Other Summary'!$H$161)/1000","v":-18.116629210148915},{"$f":"-('[7]Trans & Other Summary'!$H$167+'[7]Trans & Other Summary'!$H$172+'[7]Trans & Other Summary'!$H$175+'[7]Trans & Other Summary'!$H$178)/1000","v":-110.07814457353219},{"$f":"-'[8]Trans & Other Summary'!$H$48/1000","v":-7.4180661613354462E-15}]
[null,"- ","Customer and asset management",{"$f":"SUM(F26:I26)","v":-2224.731796178412},null,{"$f":"-('[7]Trans & Other Summary'!$F$183+'[7]Trans & Other Summary'!$F$186+'[7]Trans & Other Summary'!$F$190+'[7]Trans & Other Summary'!$F$196+'[7]Trans & Other Summary'!$F$199+'[7]Trans & Other Summary'!$F$202+'[7]Trans & Other Summary'!$F$206)/1000-([9]Adjustments!$D$28)/1000","v":-1157.874676954093},{"$f":"-('[7]Trans & Other Summary'!$F$158+'[7]Trans & Other Summary'!$F$161)/1000","v":-76.118920000000003},{"$f":"-('[7]Trans & Other Summary'!$F$167+'[7]Trans & Other Summary'!$F$172+'[7]Trans & Other Summary'!$F$175+'[7]Trans & Other Summary'!$F$178)/1000","v":-107.21110000000002},{"$f":"-'[8]Trans & Other Summary'!$F$48/1000","v":-883.52709922431927}]
[null,"-","Corporate",-8107.8216154630945,null,{"$f":"-('[7]Trans & Other Summary'!$G$183+'[7]Trans & Other Summary'!$G$186+'[7]Trans & Other Summary'!$G$190+'[7]Trans & Other Summary'!$G$196+'[7]Trans & Other Summary'!$G$199+'[7]Trans & Other Summary'!$G$202+'[7]Trans & Other Summary'!$G$206)/1000-([9]Adjustments!$E$28)/1000","v":-7307.5979154630941},{"$f":"-('[7]Trans & Other Summary'!$G$158+'[7]Trans & Other Summary'!$G$161)/1000","v":-117.89218000000002},{"$f":"-('[7]Trans & Other Summary'!$G$167+'[7]Trans & Other Summary'!$G$172+'[7]Trans & Other Summary'!$G$175+'[7]Trans & Other Summary'!$G$178)/1000","v":-330.19908000000009},{"$f":"-'[8]Trans & Other Summary'!$G$48/1000","v":-352.13243999999992},null,null,null,null,null,null,{"$f":"O27+O28","v":0}]
[null,"-","Transmission operations",-2253.1803928686249,null,{"$f":"-('[7]Trans & Other Summary'!$E$183+'[7]Trans & Other Summary'!$E$186+'[7]Trans & Other Summary'!$E$190+'[7]Trans & Other Summary'!$E$196+'[7]Trans & Other Summary'!$E$199+'[7]Trans & Other Summary'!$E$202+'[7]Trans & Other Summary'!$E$206)/1000-([9]Adjustments!$C$28/1000)","v":-2123.1997928686251},{"$f":"-('[7]Trans & Other Summary'!$E$158+'[7]Trans & Other Summary'!$E$161)/1000","v":-22.128350000000001},{"$f":"-('[7]Trans & Other Summary'!$E$167+'[7]Trans & Other Summary'!$E$172+'[7]Trans & Other Summary'!$E$175+'[7]Trans & Other Summary'!$E$178)/1000","v":-107.85224999999998},{"$f":"-'[8]Trans & Other Summary'!$E$48/1000","v":0}]
[null,"-","NCIPAP expenses",0,null,0,0,0,{"$f":"D29-SUM(F29:H29)","v":0}]
[null,"Distribution operating costs",null,{"$f":"-('[6]Summary P&L'!$C$16+'[6]Summary P&L'!$C$17)-D14-D33","v":-137150.49635308937},null,0,0,0,-137150.49635308937]
[null,"Depreciation ",null,{"$f":"-'[6]Summary P&L'!$B$19","v":-155747.04204},null,{"$f":"-'[6]Summary P&L'!$L$19","v":-69614.426380469318},{"$f":"-'[6]Summary P&L'!$N$19","v":-2204.2531226005531},{"$f":"-'[6]Summary P&L'!$M$19","v":-263.58201027704985},{"$f":"D31-SUM(F31:H31)","v":-83664.780526653078}]
[null,"Loss on Revaluation of Assets",null,{"$f":"F32","v":0},null,{"$f":"0","v":0},0,{"$f":"'[10]Opex summary'!$G$25","v":0},{"$f":"D32-SUM(F32:H32)","v":0}]
[null,"Book value of assets disposed",null,{"$f":"F33","v":-14.787230000000001},null,{"$f":"'[11]Hist Capex by Asset Class '!$G$55*1000","v":-14.787230000000001},null,null,{"$f":"D33-SUM(F33:H33)","v":0}]
[]
[null,"Earnings before Interest and Tax (EBIT)",null,{"$f":"SUM(D20:D34)","v":219529.63080232497},null,{"$f":"SUM(F20:F34)","v":74192.543917952993},{"$f":"SUM(G20:G34)","v":1912.0927481892986},{"$f":"SUM(H20:H34)","v":-1008.6287948505817},{"$f":"SUM(I20:I34)","v":144433.6229310332}]
[]
[null,"Interest and dividend income",null,null,null,null,null,null,{"$f":"D37-SUM(H37)","v":0}]
[null,"Finance charges",null,{"$f":"-'[6]Summary P&L'!$B$21","v":-85441.963130000004},null,null,null,null,{"$f":"D38-SUM(H38)","v":-85441.963130000004}]
[]
[null,"Profit(loss) before Income Tax Expense ",null,{"$f":"SUM(D35:D39)","v":134087.66767232498}]
[]
[null,"Australian income tax expense",null,{"$f":"-'[6]Summary P&L'!$B$23","v":-40159.559000000001},null,null,null,null,{"$f":"D42-H42","v":-40159.559000000001}]
[null,"Deferred income tax",null,null,null,null,null,null,{"$f":"D43-H43","v":0}]
[null,"Other income tax",null,null,null,null,null,null,0]
[]
[null,"Profit(loss) after income tax expense",null,{"$f":"SUM(D40:D45)","v":93928.108672324975}]
[]
[null,"Dividends paid",null,null,null,null,null,null,{"$f":"D48-H48","v":0}]
[]
[null,"Retained Profit(Loss)",null,{"$f":"SUM(D46:D49)","v":93928.108672324975}]
[]
[]
["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":5,"n_rows":44,"n_cols":13,"rows_kept":44,"cut":false,"hidden":false,"merged":[[4,0,4,12],[1,0,1,12],[43,2,43,11]]}
[]
["OPERATIONS AND MAINTENANCE EXPENDITURE"]
[]
[]
[]
[]
["for the period ended: 30 June 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,"Opex costs"]
[null,null,null,"Field operations and maintenance",null,null,null,null,{"$f":"-'DISAGG Inc'!F23","v":15150.015319999993},{"$f":"-'DISAGG Inc'!G23","v":0},{"$f":"-'DISAGG Inc'!H23","v":0},{"$f":"-'DISAGG Inc'!I23","v":0},{"$f":"SUM(I14:L14)","v":15150.015319999993}]
[null,null,null,"Other operating costs",null,null,null,null,0,{"$f":"-'DISAGG Inc'!G24","v":225.67618999999996},{"$f":"-'DISAGG Inc'!H24","v":1817.5991999999997},{"$f":"-'DISAGG Inc'!I24","v":4391.254969999999},{"$f":"SUM(I15:L15)","v":6434.5303599999988}]
[]
[null,null,null,null,null,null,"Subtotal of Directly Attributed costs",null,{"$f":"SUM(I14:I16)","v":15150.015319999993},{"$f":"SUM(J14:J16)","v":225.67618999999996},{"$f":"SUM(K14:K16)","v":1817.5991999999997},{"$f":"SUM(L14:L16)","v":4391.254969999999},{"$f":"SUM(M14:M16)","v":21584.545679999992}]
[]
[null,null,null,"Allocated Costs","Basis of allocation",null,"Work paper Ref.**"]
[null,null,null,"Transmission services","Causal",null,"DISAGG Aloc1",null,{"$f":"-'DISAGG Inc'!F25","v":5561.5440562918575},{"$f":"-'DISAGG Inc'!G25","v":18.116629210148915},{"$f":"-'DISAGG Inc'!H25","v":110.07814457353219},{"$f":"-'DISAGG Inc'!I25","v":7.4180661613354462E-15},{"$f":"SUM(I20:L20)","v":5689.7388300755383}]
[null,null,null,"Customer and Asset management","Causal",null,"DISAGG Aloc1",null,{"$f":"-'DISAGG Inc'!F26","v":1157.874676954093},{"$f":"-'DISAGG Inc'!G26","v":76.118920000000003},{"$f":"-'DISAGG Inc'!H26","v":107.21110000000002},{"$f":"-'DISAGG Inc'!I26","v":883.52709922431927},{"$f":"SUM(I21:L21)","v":2224.731796178412}]
[null,null,null,"Corporate","Causal & Non-Causal",null,"DISAGG Aloc1 & 2",null,{"$f":"-'DISAGG Inc'!F27","v":7307.5979154630941},{"$f":"-'DISAGG Inc'!G27","v":117.89218000000002},{"$f":"-'DISAGG Inc'!H27","v":330.19908000000009},{"$f":"-'DISAGG Inc'!I27","v":352.13243999999992},8107.8216154630945]
[null,null,null,"Transmission operations","Causal",null,"DISAGG Aloc1",null,{"$f":"-'DISAGG Inc'!F28","v":2123.1997928686251},{"$f":"-'DISAGG Inc'!G28","v":22.128350000000001},{"$f":"-'DISAGG Inc'!H28","v":107.85224999999998},{"$f":"-'DISAGG Inc'!I28","v":0},2253.1803928686249]
[]
[]
[null,null,null,null,null,null,"Subtotal of Allocated costs",null,{"$f":"SUM(I19:I24)","v":16150.21644157767},{"$f":"SUM(J19:J24)","v":234.25607921014895},{"$f":"SUM(K19:K24)","v":655.34057457353231},{"$f":"SUM(L19:L24)","v":1235.6595392243191},{"$f":"SUM(M19:M24)","v":18275.472634585669}]
[]
[null,null,null,null,null,null,"Total Opex Costs per DISAGG Inc",null,{"$f":"I17+I26","v":31300.231761577663},{"$f":"J17+J26","v":459.93226921014889},{"$f":"K17+K26","v":2472.9397745735318},{"$f":"L17+L26","v":5626.914509224318}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null," Total",{"$f":"M17+M26","v":39860.018314585657}]
[]
[]
["Explanation of opex costs required by the Commission (for example, bushfire costs, insurance etc)"]
[]
[]
[]
[]
[]
[]
[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":"Ls_XLB_WorkbookFile","index":6,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"Ls_AgXLB_WorkbookFile","index":7,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"DISAGG Aloc1","index":8,"n_rows":50,"n_cols":8,"rows_kept":50,"cut":false,"hidden":false,"merged":[[1,0,1,7],[4,10,4,11],[4,0,4,7],[8,0,8,7],[46,1,47,6]]}
[]
["CAUSAL ALLOCATION"]
[]
[]
[]
[]
["for the period ended: 30 June 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 - network overheads and some corporate overheads"]
[]
[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,"For each Account Heading that has been "]
[null,"allocated on this basis, provide the following information"]
[]
[null,"NETWORK OVERHEADS"]
[null,"Transmission Services - Direct Hours",null,{"$f":"[12]Hours!$B$14","v":27557.159999999963},{"$f":"[12]Hours!$B$11","v":656.21},{"$f":"[12]Hours!$B$12","v":607.59999999999991},{"$f":"[12]Hours!$B$13","v":5124.29}]
[null,"Customer and Asset management - ABC Survey",null,{"$f":"'[9]Regulated Accounts %'!$GR$33","v":0.17262091486718747},{"$f":"'[9]Regulated Accounts %'!$GR$34","v":3.9593744506238211E-3},{"$f":"'[9]Regulated Accounts %'!$GR$35","v":1.1470581000853632E-2},{"$f":"'[9]Regulated Accounts %'!$GR$36","v":5.9764180382623086E-2}]
[null,"Transmission Operations - ABC Survey",null,{"$f":"'[9]Regulated Accounts %'!$CD$33","v":0.38785016871604389},{"$f":"'[9]Regulated Accounts %'!$CD$34","v":3.3524262207887505E-3},{"$f":"'[9]Regulated Accounts %'!$CD$35","v":1.3719870608393574E-2},{"$f":"'[9]Regulated Accounts %'!$CD$36","v":0}]
[]
[null,"Corresponding cost allocation ($'000)",null,{"$f":"'DISAGG Opex'!I20+'DISAGG Opex'!I21+'DISAGG Opex'!I23","v":8842.6185261145765},{"$f":"'DISAGG Opex'!J21+'DISAGG Opex'!J20+'DISAGG Opex'!J23","v":116.36389921014892},{"$f":"'DISAGG Opex'!K20+'DISAGG Opex'!K21+'DISAGG Opex'!K23","v":325.14149457353216},{"$f":"'DISAGG Opex'!L20+'DISAGG Opex'!L21+'DISAGG Opex'!L23","v":883.52709922431927},{"$f":"SUM(D27:G27)","v":10167.651019122577}]
[]
[null,"CORPORATE OVERHEADS"]
[null,"General Counsel - ABC Survey",null,{"$f":"'[9]Regulated Accounts %'!$J$33","v":0.1262556105648221},{"$f":"'[9]Regulated Accounts %'!$J$34","v":4.226159252536352E-4},{"$f":"'[9]Regulated Accounts %'!$J$35","v":1.713108056775675E-3},{"$f":"'[9]Regulated Accounts %'!$J$36","v":4.5539937324876479E-3}]
[null,"Facilities - ABC Survey",null,{"$f":"'[9]Regulated Accounts %'!$AM$33","v":0.11104173799372991},{"$f":"'[9]Regulated Accounts %'!$AM$34","v":3.7169046693491813E-4},{"$f":"'[9]Regulated Accounts %'!$AM$35","v":1.5066775658081845E-3},{"$f":"'[9]Regulated Accounts %'!$AM$36","v":4.0052349088150327E-3}]
[null,"IT - IT applications, PC's & mobile devices",null,{"$f":"'[9]Regulated Accounts %'!$AQ$33","v":0.13000332867269496},{"$f":"'[9]Regulated Accounts %'!$AQ$34","v":4.3516067751187481E-4},{"$f":"'[9]Regulated Accounts %'!$AQ$35","v":1.7639592312811017E-3},{"$f":"'[9]Regulated Accounts %'!$AQ$36","v":4.6891725550210085E-3}]
[null,"Strategy & Stakeholder Relations - ABC Survey",null,{"$f":"'[9]Regulated Accounts %'!$W$33","v":0.12888621015645321},{"$f":"'[9]Regulated Accounts %'!$W$34","v":4.3142134210137395E-4},{"$f":"'[9]Regulated Accounts %'!$W$35","v":1.7488015307877496E-3},{"$f":"'[9]Regulated Accounts %'!$W$36","v":4.6488784983953159E-3}]
[null,"People & Performance - FTE Headcount",null,{"$f":"'[9]Regulated Accounts %'!$AZ$33","v":0.13951867110222804},{"$f":"'[9]Regulated Accounts %'!$AZ$34","v":4.6701142241716931E-4},{"$f":"'[9]Regulated Accounts %'!$AZ$35","v":1.8930688186181619E-3},{"$f":"'[9]Regulated Accounts %'!$AZ$36","v":5.0323874790367618E-3}]
[null,"Compliance and Risk - Asset allocation",null,{"$f":"'[9]Regulated Accounts %'!$AK$33","v":0.11142285721437982},{"$f":"'[9]Regulated Accounts %'!$AK$34","v":3.7296618887191861E-4},{"$f":"'[9]Regulated Accounts %'!$AK$35","v":1.5118488085321057E-3},{"$f":"'[9]Regulated Accounts %'!$AK$36","v":4.0189817398224329E-3}]
[]
[null,"Corresponding cost allocation ($'000)",null,{"$f":"'[9]Regulated Accounts %'!$BI$28/1000","v":4774.8283752223042},{"$f":"'[9]Regulated Accounts %'!$BI$29/1000","v":15.982802686505931},{"$f":"'[9]Regulated Accounts %'!$BI$30/1000","v":64.787591796681113},{"$f":"'[9]Regulated Accounts %'!$BI$31/1000","v":172.22631451536546},{"$f":"SUM(D37:G37)","v":5027.8250842208572}]
[]
[]
[]
[]
[null,"3.   Provide a detailed description and explanation of the basis of allocation:"]
[]
[null,"Allocation as per the Cost Allocation Methodology:"]
[null,"Network Overheads:"]
[null,"Transmission Services management costs (overheads) are allocated on the basis of direct labour hours via timesheet entry."]
[null,"Customer and Asset Management as well as Transmission Operations are allocated on the basis of Activity Based Costing (ABC) Survey using estimated staff effort."]
[]
[null,"Corporate Overheads:"]
[null,"Where a cost driver has been identified (above) the costs have been allocated based on the  cost driver."]

{"sheet":"DISAGG Aloc2","index":9,"n_rows":49,"n_cols":8,"rows_kept":49,"cut":false,"hidden":false,"merged":[[41,1,42,6],[1,0,1,6],[38,1,38,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],[33,1,35,6],[26,1,27,6]]}
[]
["NON-CAUSAL ALLOCATION"]
[]
[]
[]
[]
["for the period ended: 30 June 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 for corporate overhead"]
[]
[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,"Weighted Average Costs",null,{"$f":"'DISAGG Opex'!I22-'DISAGG Aloc1'!D37","v":2532.7695402407899},{"$f":"'DISAGG Opex'!J22-'DISAGG Aloc1'!E37","v":101.90937731349409},{"$f":"'DISAGG Opex'!K22-'DISAGG Aloc1'!F37","v":265.41148820331898},{"$f":"'DISAGG Opex'!L22-'DISAGG Aloc1'!G37","v":179.90612548463446},{"$f":"SUM(D20:G20)","v":3079.9965312422373}]
[]
[]
[]
[null,"3.   Provide a detailed description and explanation of the basis of allocation:"]
[]
[]
[null,"These corporate costs which don't have a causal driver such as the Board, the CEO, Finance the company secretary are allocated on a weighted average basis."]
[]
[]
[]
[null,"4.   Explain why no causal basis could be established:"]
[]
[]
[null,"These general business costs have no causal driver to directly allocate and the ABC Survey is not a practical as there is not a direct link between the effort and the service."]
[]
[]
[]
[]
[null,"5.  Explain the reasons for choosing this non-causal basis and why it was \npreferred over others:"]
[]
[]
[null,"The weighted average methodoly applies the non causal costs based on the weighted average of costs already allocated. This methodology was selected as it aligns these costs with the effort in the business."]
[]
[]
[]
[null,"6.  Date on which the Commission/AER granted approval:"]
[]
[]
[null,"The CAM received approval from the AER on 26th June 2015"]

{"sheet":"PTS Adj","index":10,"n_rows":46,"n_cols":6,"rows_kept":46,"cut":false,"hidden":false,"merged":[[4,0,4,5],[1,0,1,4],[11,0,13,5],[24,1,24,2]]}
[]
["REGULATORY ADJUSTMENT JOURNALS - PRESCRIBED TRANSMISSION SERVICES"]
[]
[]
[]
[]
["for the period ended: 30 June 2017"]
[]
["Journal","Account Debited",null,"Amount",null,"Supporting"]
["number",null,"Account Credited","Debit","Credit","Statement"]
[null,null,null,"$'000","$'000","No."]
["Journals 1-76 have been provided in previous years regulatory financial statements."]
[]
[]
[null,null,"Current Year Journals"]
[]
[]
[77,"Self Insurance",null,{"$f":"[13]Sheet1!$D$19*1000","v":747.95962248658407}]
[null,null,"Provision for self insurance",null,{"$f":"D18","v":747.95962248658407}]
[null,"(Self Insurance allowance for the year 2016-17)"]
[]
[]
[78,"Property, Plant & Equipment",null,8310]
[null,null,"Retained Profits",null,8310]
[null,"(Difference in depreciation and amortisation for regulatory purposes 2016-17)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["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":11,"n_rows":30,"n_cols":3,"rows_kept":30,"cut":false,"hidden":false,"merged":[[4,9,4,10],[1,0,1,3],[4,0,4,3]]}
[]
["PRICE REDUCTION/RECOVERY - PRESCRIBED TRANSMISSION SERVICES"]
[]
[]
[]
[]
["for the period ended: 30 June 2017"]
[]
[null,"$Customer TUOS","$Common service"]
[null,"general charges","charges"]
["Reduction in prices payable"]
["       by transmission customers"]
[]
[]
[]
[]
["     Total Reduction",{"$f":"SUM(B11:B16)","v":0},{"$f":"SUM(C11:C16)","v":0}]
[]
["*Recovery of  above reduction in prices"]
["     from other transmission customers"]
[]
[]
["     Total Recovery",{"$f":"SUM(B20:B22)","v":0},{"$f":"SUM(C20:C22)","v":0}]
[]
[]
["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":12,"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],[13,3,16,7]]}
[]
["PRUDENT DISCOUNTS - PRESCRIBED TRANSMISSION SERVICES"]
[]
[]
[]
[]
["for the period ended: 30 June 2017"]
[]
[]
[]
[]
[null,"Number of discounts recovered in previous year"]
["For each discount recovered:"]
[null,"Date of AER approval, if given",null,"Not Applicable to TasNetworks"]
[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":13,"n_rows":19,"n_cols":5,"rows_kept":19,"cut":false,"hidden":false,"merged":[[4,9,4,10],[4,0,4,4],[1,0,1,3],[11,0,14,4]]}
[]
["REVENUE ANALYSIS - PRESCRIBED TRANSMISSION SERVICES"]
[]
[]
[]
[]
["for the period ended: 30 June 2017"]
[]
["Account code or reference","Tariff Category",null,"Amount of electricity transmitted","Revenue"]
[null,null,null,"GWh","$'000"]
[]
["Not Required - Duplicated in Economic Benchmarking RIN"]
[]
[]
[]
[]
[]
[]
[null,null,"Total"]

{"sheet":"PTS Asset Aging","index":14,"n_rows":22,"n_cols":8,"rows_kept":22,"cut":false,"hidden":false,"merged":[[1,0,1,7],[4,0,4,7],[4,9,4,10],[14,0,17,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"]
[]
[]
["Not Required - Duplicated in Category Analysis RIN"]
[]
[]
[]
[]
[]
[]
[null,"Total net regulatory value"]

{"sheet":"DISAGG ProvSum","index":15,"n_rows":41,"n_cols":8,"rows_kept":41,"cut":false,"hidden":false,"merged":[[1,0,1,6],[4,0,4,6],[4,8,4,9],[40,0,40,5]]}
[]
["SUMMARY OF PROVISIONS"]
[]
[]
[]
[]
["for the period ended: 30 June 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,{"$f":"'[14]500H- 16-17'!$O$34*'[14]Labour splits'!$S$32","v":6414.3717673764049},null,null,{"$f":"'[14]500H- 16-17'!$O$34*('[14]Labour splits'!$S$34+'[14]Labour splits'!$S$36)","v":513.92062232359785},{"$f":"SUM(D12:G12)","v":6928.2923897000028}]
[null,null,null,null,null,null,null,{"$f":"SUM(D13:G13)","v":0}]
[null,"Expenditure incurred debited to provisions",null,{"$f":"'[14]500H- 16-17'!$O$36*'[14]Labour splits'!$S$32","v":-6448.3565136764018},null,null,{"$f":"'[14]500H- 16-17'!$O$36*('[14]Labour splits'!$S$34+'[14]Labour splits'!$S$36)","v":-516.64348632359759},-6964.9999999999991]
[null,null,null,null,null,null,null,0]
[null,"Amounts written back from provisions",null,{"$f":"-D20+D22-D12-D14","v":-1010.5897042097204},null,null,{"$f":"-G20+G22-G12-G14","v":1976.0906944157305},965.5009902060101]
[null,null,null,null,null,null,null,0]
[null,"Net movement in provisions",null,{"$f":"SUM(D12:D17)","v":-1044.5744505097173},{"$f":"SUM(E12:E17)","v":0},0,{"$f":"SUM(G12:G17)","v":1973.3678304157306},928.7933799060138]
[]
[null,"Balance at start of period",null,{"$f":"SUM('[14]3.2.3 Provisions - TNSP 2016-17'!$D$13,'[14]3.2.3 Provisions - TNSP 2016-17'!$D$33,'[14]3.2.3 Provisions - TNSP 2016-17'!$D$53,'[14]3.2.3 Provisions - TNSP 2016-17'!$D$73)/1000","v":39009.34175050971},0,0,{"$f":"'[14]500H- 16-17'!$O$32-D20","v":1068.3761695842695},{"$f":"SUM(D20:G20)","v":40077.717920093979}]
[]
[null,"Balance at end of period",null,{"$f":"'[14]500H- 16-17'!$O$43*'[14]Labour splits'!$S$32","v":37964.767299999992},{"$f":"SUM(E18:E21)","v":0},0,{"$f":"'[14]500H- 16-17'!$O$43*('[14]Labour splits'!$S$34+'[14]Labour splits'!$S$36)","v":3041.7440000000001},41006.511299999991]
[]
["Comprising:"]
[]
[null,"Current provisions",null,{"$f":"'[14]Summary Consolidated'!$O$55*'[14]Labour splits'!$I$32/1000","v":6137.4549535509996},null,null,{"$f":"('[14]Summary Consolidated'!$O$55*('[14]Labour splits'!$I$34+'[14]Labour splits'!$I$36))/1000","v":491.7339972800001},{"$f":"SUM(D26:G26)","v":6629.1889508309996}]
[null,"Non-current provision",null,{"$f":"D29-D26","v":31827.312346448991},0,0,{"$f":"G29-G26","v":2550.0100027200001},{"$f":"SUM(D27:G27)","v":34377.322349168993}]
[]
[null,null,"Total per balance sheet",{"$f":"D22","v":37964.767299999992},{"$f":"E22","v":0},0,{"$f":"G22","v":3041.7440000000001},{"$f":"SUM(H24:H28)","v":41006.511299999991}]
[]
[]
["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":"PTS ProvRec ","index":16,"n_rows":38,"n_cols":10,"rows_kept":38,"cut":false,"hidden":false,"merged":[[1,0,1,9],[4,0,4,9],[8,3,8,7],[14,3,18,9]]}
[]
["PROVISIONS RECONCILIATION - \nPRESCRIBED TRANSMISSION SERVICES"]
[]
[]
[]
[]
["for the period ended: 30 June 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",null,null,"Not required - Duplicated in Economic Benchmarking RIN"]
[]
["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."]

{"sheet":"INF RelPartTrans","index":17,"n_rows":47,"n_cols":5,"rows_kept":47,"cut":false,"hidden":false,"merged":[[1,0,1,4],[37,0,37,4],[4,0,4,4]]}
[]
["RELATED PARTY TRANSACTIONS"]
[]
[]
[]
[]
["for the period ended: 30 June 2017"]
[]
["Details of related party","Description of transaction","Prescribed","Procurement process","Monetary value of transaction"]
[null,null,null,null,"$'000"]
[]
[null,"Revenue"]
[]
[]
[null,"Expense"]
[]
[]
[null,"Capital"]
[]
[]
[]
["Balances with related parties at regulatory accounting date"]
[null,null,null,null,"$'000"]
[]
[null,"Current assets"]
[]
[null,"Non-current assets"]
[]
[null,"Total assets"]
[]
[null,"Current liabilities"]
[]
[null,"Non-current liabilities"]
[]
[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"]
[]
[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":18,"n_rows":24,"n_cols":6,"rows_kept":24,"cut":false,"hidden":false,"merged":[[1,0,1,5],[4,0,4,5]]}
[]
["REVENUE RECONCILIATION "]
[]
[]
[]
[]
["for the period ended: 30 June 2017"]
[]
[null,"Description",null,"Unit type","Unit"]
[]
[]
[null,"CPI (March Tx)",null,"CPI – All Groups Weighted Average of 8 \nCapital Cities (ABS)",{"$f":"'[15]2016-17'!$E$12","v":104.8},"Dec 2013 qtr"]
[null,"CPI (March Tx+1)",null,"As above",{"$f":"'[15]2016-17'!$E$13","v":108.4},"Dec 2015 qtr"]
[null,"Change in CPI",null,"Per cent",{"$f":"'[15]2016-17'!$E$14","v":2.38}]
[null,"X-factor",null,"Per cent",{"$f":"'[15]2016-17'!$E$15","v":2.31}]
[null,"AR (Tx)",null,"$",{"$f":"'[15]2016-17'!$E$16","v":172642496.08008501},"AER Final Decision PTRM, 2016"]
[null,"AR (Tx+1)",null,"$",{"$f":"'[15]2016-17'!$E$17","v":170366992}]
[null,"S-factor (Tx)",null,"$+",{"$f":"'[15]2016-17'!$E$18","v":2878177},"STPIS & Network Support"]
[null,"Other pass through",null,"$+",{"$f":"'[15]2016-17'!$E$19","v":2688195}]
[null,"Sub-total",null,null,{"$f":"SUM(E17:E19)","v":175933364}]
[null,"PY Under/over recovery",null,"$+",{"$f":"'[15]2016-17'!$E$21","v":1673490}]
[null,"CY adj (incl. forecast settlement residue)",null,"$+",{"$f":"'[15]2016-17'!$E$22","v":-14950000}]
[null,"Net load export charge",null,"$+",{"$f":"'[15]2016-17'!$E$23","v":-6573970}]
[null,"Revenue Cap Tx+1",null,"$",{"$f":"SUM(E20:E23)","v":156082884},"2016/17"]

{"sheet":"Historic Opex Summary","index":19,"n_rows":64,"n_cols":12,"rows_kept":64,"cut":false,"hidden":false,"merged":[[1,1,1,10],[20,2,27,11]]}
[]
[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","Not Required - Duplicated in Category Analysis RIN & Economic Benchmarking RIN"]
[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","index":20,"n_rows":67,"n_cols":12,"rows_kept":67,"cut":false,"hidden":false,"merged":[[31,2,39,11],[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","Not Required - Duplicated in Category Analysis RIN and Economic Benchmarking RIN"]
[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":21,"n_rows":36,"n_cols":12,"rows_kept":36,"cut":false,"hidden":false,"merged":[[1,1,1,9],[18,10,19,10],[18,11,19,11],[17,0,17,1],[18,9,19,9],[5,0,10,8],[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"]
[]
[]
[]
["Not Required - Duplicated in Category Analysis RIN"]
[]
[]
[]
[]
[]
[]
[]
["$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"]

{"sheet":"Hist Capex by Asset Class ","index":22,"n_rows":118,"n_cols":21,"rows_kept":118,"cut":false,"hidden":false,"merged":[[25,1,25,2],[1,1,1,18],[4,0,4,10],[4,12,4,20],[5,0,5,2],[6,0,6,2],[108,1,108,2],[109,1,109,2],[41,0,41,2],[29,0,38,10],[68,0,68,2],[87,1,87,2],[91,0,100,10],[67,0,67,2],[29,12,29,20],[40,0,40,10],[42,0,42,2],[63,0,63,10],[66,0,66,10],[66,12,66,20],[91,12,91,20],[102,0,102,10],[103,0,103,2],[104,0,104,2],[107,1,107,2],[105,1,105,2],[106,1,106,2],[117,0,117,10],[110,1,110,2],[111,1,111,2],[112,1,112,2],[113,1,113,2],[114,1,114,2]]}
[]
[null,"HISTORIC CAPEX by asset class"]
[]
[]
["Actual Gross Capital Expenditure – As Incurred ($m Nominal) incl NCIPAP",null,null,null,null,null,null,null,null,null,null,null,"Actual Gross NCIPAP Capital Expenditure – As Incurred ($m Nominal)"]
[null,null,null,"2013-14","2014-15","2015-16","2016-17","2017-18","2018-19",null,null,null,null,"2013-14","2014-15","2015-16","2016-17","2017-18","2018-19"]
["Asset Class"]
[null,"Transmission Lines And Cables - 60Yrs","Transmission Lines And Cables - 60Yrs",22.778164,1.7561077487677905,{"$f":"'[16]Hist Capex by Asset Class '!$F$8","v":3.2826781498158608},{"$f":"'[17]Hist Capex by Asset Class '!$G8","v":6.2778401176484415},null,null,null,null,null,"Transmission Lines And Cables - 60Yrs",null,0,{"$f":"'[16]Hist Capex by Asset Class '!$P$8","v":0},{"$f":"'[17]Hist Capex by Asset Class '!$Q8","v":7.4232669859999989E-2}]
[null,"Transmission Lines And Cables - 45Yrs","Transmission Lines And Cables - 45Yrs",0.11354400000000001,0.68669573916481053,{"$f":"'[16]Hist Capex by Asset Class '!$F$9","v":0.92489340514629059},{"$f":"'[17]Hist Capex by Asset Class '!$G9","v":6.5916236349593715},null,null,null,null,null,"Transmission Lines And Cables - 45Yrs",null,7.7666149999999989E-2,{"$f":"'[16]Hist Capex by Asset Class '!$P$9","v":0.11171664000000001},{"$f":"'[17]Hist Capex by Asset Class '!$Q9","v":0.54543250236999996}]
[null,"Transmission Lines And Cables - 10Yrs","Transmission Lines And Cables - 10Yrs",0.46624399999999999,0.12760861235603682,{"$f":"'[16]Hist Capex by Asset Class '!$F$10","v":0.17447116952784969},{"$f":"'[17]Hist Capex by Asset Class '!$G10","v":9.2300560032135692},null,null,null,null,null,"Transmission Lines And Cables - 10Yrs",null,0,{"$f":"'[16]Hist Capex by Asset Class '!$P$10","v":0},{"$f":"'[17]Hist Capex by Asset Class '!$Q10","v":0.91051218148000013}]
[null,"Transmission Substations - 60Yrs","Transmission Substations - 60Yrs",8.2339559999999992,4.7808991539840333,{"$f":"'[16]Hist Capex by Asset Class '!$F$11","v":1.5077817504953621},{"$f":"'[17]Hist Capex by Asset Class '!$G11","v":2.4216024882352496},null,null,null,null,null,"Transmission Substations - 60Yrs",null,0,{"$f":"'[16]Hist Capex by Asset Class '!$P$11","v":0},{"$f":"'[17]Hist Capex by Asset Class '!$Q11","v":0.11680240065000004}]
[null,"Transmission Substations - 45Yrs","Transmission Substations - 45Yrs",22.782575999999999,7.9481139509092618,{"$f":"'[16]Hist Capex by Asset Class '!$F$12","v":4.0455310124908461},{"$f":"'[17]Hist Capex by Asset Class '!$G12","v":11.399324884138542},null,null,null,null,null,"Transmission Substations - 45Yrs",null,9.4973899999999997E-3,{"$f":"'[16]Hist Capex by Asset Class '!$P$12","v":0.56497689000000006},{"$f":"'[17]Hist Capex by Asset Class '!$Q12","v":0.41650453949999994}]
[null,"Transmission Substations - 15Yrs","Transmission Substations - 15Yrs",3.3771450000000001,1.1766649465369321,{"$f":"'[16]Hist Capex by Asset Class '!$F$13","v":0.68828244513875458},{"$f":"'[17]Hist Capex by Asset Class '!$G13","v":0.30329711609196247},null,null,null,null,null,"Transmission Substations - 15Yrs",null,0.13943454999999999,{"$f":"'[16]Hist Capex by Asset Class '!$P$13","v":0.24872168},{"$f":"'[17]Hist Capex by Asset Class '!$Q13","v":0}]
[null,"Protection And Control - 15Yrs","Protection And Control - 15Yrs",14.167740999999999,4.4730206414099118,{"$f":"'[16]Hist Capex by Asset Class '!$F$14","v":4.004121852759214},{"$f":"'[17]Hist Capex by Asset Class '!$G14","v":2.7528467685103579},null,null,null,null,null,"Protection And Control - 15Yrs",null,2.0974340000000001E-2,{"$f":"'[16]Hist Capex by Asset Class '!$P$14","v":0.25984870999999998},{"$f":"'[17]Hist Capex by Asset Class '!$Q14","v":3.0113160000000003E-2}]
[null,"Protection And Control - 4Yrs","Protection And Control - 4Yrs",9.9852999999999997E-2,-1.6898200000000002E-2,{"$f":"'[16]Hist Capex by Asset Class '!$F$15","v":0},{"$f":"'[17]Hist Capex by Asset Class '!$G15","v":0},null,null,null,null,null,"Protection And Control - 4Yrs",null,0,{"$f":"'[16]Hist Capex by Asset Class '!$P$15","v":0},{"$f":"'[17]Hist Capex by Asset Class '!$Q15","v":0}]
[null,"Transmission Operations - 10Yrs","Transmission Operations - 10Yrs",1.411877,0.61025017679999993,{"$f":"'[16]Hist Capex by Asset Class '!$F$16","v":4.3518812599999999},{"$f":"'[17]Hist Capex by Asset Class '!$G16","v":6.5911148179564982},null,null,null,null,null,"Transmission Operations - 10Yrs",null,0,{"$f":"'[16]Hist Capex by Asset Class '!$P$16","v":3.4623960000000002E-2},{"$f":"'[17]Hist Capex by Asset Class '!$Q16","v":-1.5387599999999993E-3}]
[null,"Transmission Operations - 4Yrs","Transmission Operations - 4Yrs",1.511E-2,0,{"$f":"'[16]Hist Capex by Asset Class '!$F$17","v":0},{"$f":"'[17]Hist Capex by Asset Class '!$G17","v":0.29478176233177084},null,null,null,null,null,"Transmission Operations - 4Yrs",null,0,{"$f":"'[16]Hist Capex by Asset Class '!$P$17","v":0},{"$f":"'[17]Hist Capex by Asset Class '!$Q17","v":0}]
[null,"Other - 40Yrs","Other - 40Yrs",1.1474009999999999,0.24529494899999996,{"$f":"'[16]Hist Capex by Asset Class '!$F$18","v":7.572873860000004E-2},{"$f":"'[17]Hist Capex by Asset Class '!$G18","v":0.93838109387488744},null,null,null,null,null,"Other - 40Yrs",null,0,{"$f":"'[16]Hist Capex by Asset Class '!$P$18","v":0},{"$f":"'[17]Hist Capex by Asset Class '!$Q18","v":0}]
[null,"Other - 9Yrs","Other - 9Yrs",0.57231200000000004,0.94431320260561136,{"$f":"'[16]Hist Capex by Asset Class '!$F$19","v":4.7027449855999999},{"$f":"'[17]Hist Capex by Asset Class '!$G19","v":0.65443420916127293},null,null,null,null,null,"Other - 9Yrs",null,0,{"$f":"'[16]Hist Capex by Asset Class '!$P$19","v":0},{"$f":"'[17]Hist Capex by Asset Class '!$Q19","v":0}]
[null,"Other - 4Yrs","Other - 4Yrs",1.5250939999999999,2.1577946959999998,{"$f":"'[16]Hist Capex by Asset Class '!$F$20","v":0.98269833979999999},{"$f":"'[17]Hist Capex by Asset Class '!$G20","v":3.4284570743860887},null,null,null,null,null,"Other - 4Yrs",null,0,{"$f":"'[16]Hist Capex by Asset Class '!$P$20","v":0},{"$f":"'[17]Hist Capex by Asset Class '!$Q20","v":0}]
[null,"Communications - 45Yrs","Communications - 45Yrs",0,6.107073485133372E-3,{"$f":"'[16]Hist Capex by Asset Class '!$F$21","v":0},{"$f":"'[17]Hist Capex by Asset Class '!$G21","v":0},null,null,null,null,null,"Communications - 45Yrs",null,0,{"$f":"'[16]Hist Capex by Asset Class '!$P$21","v":0},{"$f":"'[17]Hist Capex by Asset Class '!$Q21","v":0}]
[null,"Communications - 10Yrs","Communications - 10Yrs",0,4.5933073394690813E-2,{"$f":"'[16]Hist Capex by Asset Class '!$F$22","v":0},{"$f":"'[17]Hist Capex by Asset Class '!$G22","v":0},null,null,null,null,null,"Communications - 10Yrs",null,0,{"$f":"'[16]Hist Capex by Asset Class '!$P$22","v":0},{"$f":"'[17]Hist Capex by Asset Class '!$Q22","v":0}]
[null,"Communications - 5Yrs","Communications - 5Yrs",0,1.14E-2,{"$f":"'[16]Hist Capex by Asset Class '!$F$23","v":0},{"$f":"'[17]Hist Capex by Asset Class '!$G23","v":0},null,null,null,null,null,"Communications - 5Yrs",null,0,{"$f":"'[16]Hist Capex by Asset Class '!$P$23","v":0},{"$f":"'[17]Hist Capex by Asset Class '!$Q23","v":0}]
[null,"Land and Buildings","Land and Buildings",8.4626999999999994E-2,8.5469878981619646E-2,{"$f":"'[16]Hist Capex by Asset Class '!$F$24","v":8.8785631852546273E-2},{"$f":"'[17]Hist Capex by Asset Class '!$G24","v":7.7530904870733205E-2},null,null,null,null,null,"Land and Buildings",null,0,{"$f":"'[16]Hist Capex by Asset Class '!$P$24","v":0},{"$f":"'[17]Hist Capex by Asset Class '!$Q24","v":5.5916140000000001E-5}]
[null,"Equity Raising","Equity Raising",0,0,{"$f":"'[16]Hist Capex by Asset Class '!$F$25","v":0},{"$f":"'[17]Hist Capex by Asset Class '!$G25","v":0},null,null,null,null,null,"Equity Raising",null,0,{"$f":"'[16]Hist Capex by Asset Class '!$P$25","v":0},{"$f":"'[17]Hist Capex by Asset Class '!$Q25","v":0}]
[null,null,null,null,null,null,null,null,null,"Total Yrs 1-5","Total",null,null,null,null,null,null,null,null,"Total Yrs 1-5","Total"]
[null,"Sub total",null,{"$f":"SUM(D8:D26)","v":76.775643999999986},{"$f":"SUM(E8:E26)","v":25.038775643395827},{"$f":"SUM(F8:F26)","v":24.829598741226722},50.961290875378751,{"$f":"SUM(H8:H26)","v":0},{"$f":"SUM(I8:I26)","v":0},{"$f":"SUM(E27:I27)","v":100.82966526000129},{"$f":"SUM(D27:I27)","v":177.60530926000126},null,"Sub total",{"$f":"SUM(N8:N26)","v":0},{"$f":"SUM(O8:O26)","v":0.24757242999999998},{"$f":"SUM(P8:P26)","v":1.2198878800000001},2.0921146100000003,{"$f":"SUM(R8:R26)","v":0},{"$f":"SUM(S8:S26)","v":0},{"$f":"SUM(O27:S27)","v":3.5595749200000002},{"$f":"SUM(N27:S27)","v":3.5595749200000002}]
[]
[]
["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",null,null,null,null,null,null,null,null,null,null,null,"Actual Gross NCIPAP Capital Expenditure – As Incurred ($m Nominal)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"2013-14","2014-15","2015-16","2016-17","2017-18","2018-19"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Weather Station refurbishment program",null,{"$f":"'[16]Hist Capex by Asset Class '!$O$33","v":0.13943454999999999},{"$f":"'[16]Hist Capex by Asset Class '!$P$33","v":0.24872168},{"$f":"'[17]Hist Capex by Asset Class '!$Q33","v":0.96798944000000053}]
[null,null,null,null,null,null,null,null,null,null,null,null,"ND1346 George Town Automatic Voltage Control",null,{"$f":"'[16]Hist Capex by Asset Class '!$O$34","v":0},{"$f":"'[16]Hist Capex by Asset Class '!$P$34","v":3.4623960000000002E-2},{"$f":"'[17]Hist Capex by Asset Class '!$Q34","v":-1.5387599999999993E-3}]
[null,null,null,null,null,null,null,null,null,null,null,null,"ND1351 Implementation of dynamic rating",null,{"$f":"'[16]Hist Capex by Asset Class '!$O$35","v":1.3020809999999999E-2},{"$f":"'[16]Hist Capex by Asset Class '!$P$35","v":1.1801799999999999E-2},{"$f":"'[17]Hist Capex by Asset Class '!$Q35","v":1.7698400000000003E-2}]
[null,null,null,null,null,null,null,null,null,null,null,null,"ND1363 TL Dead End Assembly Upgrade Prog Stg 2",null,{"$f":"'[16]Hist Capex by Asset Class '!$O$36","v":7.7666149999999989E-2},{"$f":"'[16]Hist Capex by Asset Class '!$P$36","v":3.1574890000000001E-2},{"$f":"'[17]Hist Capex by Asset Class '!$Q36","v":0.16677002999999999}]
[null,null,null,null,null,null,null,null,null,null,null,null,"ND1364 Power Transformer Dynamic Rating Progra",null,{"$f":"'[16]Hist Capex by Asset Class '!$O$37","v":7.9535300000000003E-3},{"$f":"'[16]Hist Capex by Asset Class '!$P$37","v":0.24804691000000001},{"$f":"'[17]Hist Capex by Asset Class '!$Q37","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"ND1365 Line Fault Indicator Comms Program",null,{"$f":"'[16]Hist Capex by Asset Class '!$O$38","v":0},{"$f":"'[16]Hist Capex by Asset Class '!$P$38","v":2.6981140000000001E-2},{"$f":"'[17]Hist Capex by Asset Class '!$Q38","v":1.6836770000000001E-2}]
[null,null,null,null,null,null,null,null,null,null,null,null,"ND1366 Sheffield Sub 220kV K and L Bay Upgrade",null,{"$f":"'[16]Hist Capex by Asset Class '!$O$39","v":7.4405299999999999E-3},{"$f":"'[16]Hist Capex by Asset Class '!$P$39","v":0.26112181000000001},{"$f":"'[17]Hist Capex by Asset Class '!$Q39","v":0.84447852999999984}]
[null,null,null,null,null,null,null,null,null,null,null,null,"ND1367 Castle Forbes Bay Tee disconnector upgr",null,{"$f":"'[16]Hist Capex by Asset Class '!$O$40","v":2.0568600000000002E-3},{"$f":"'[16]Hist Capex by Asset Class '!$P$40","v":0.30385508},{"$f":"'[17]Hist Capex by Asset Class '!$Q40","v":0}]
["Actual Asset Disposal – As Incurred ($m Nominal)",null,null,null,null,null,null,null,null,null,null,null,"ND1372 Modern fault location functionality",null,{"$f":"'[16]Hist Capex by Asset Class '!$O$41","v":0},{"$f":"'[16]Hist Capex by Asset Class '!$P$41","v":5.3160610000000004E-2},{"$f":"'[17]Hist Capex by Asset Class '!$Q41","v":7.9880199999999998E-2},null,null,"Total Yrs 1-5","Total"]
[null,null,null,"2013-14","2014-15","2015-16","2016-17","2017-18","2018-19",null,null,null,"Sub total",{"$f":"SUM(N33:N41)","v":0},0.24757242999999995,1.2198878799999999,2.0921146100000003,0,0,{"$f":"SUM(O42:S42)","v":3.5595749200000002},{"$f":"SUM(N42:S42)","v":3.5595749200000002}]
["Asset Class"]
[null,"Transmission Lines And Cables - 60Yrs",null,null,0,{"$f":"'[16]Hist Capex by Asset Class '!$F$44","v":0},{"$f":"'[17]Hist Capex by Asset Class '!$G44","v":0}]
[null,"Transmission Lines And Cables - 45Yrs",null,null,0,{"$f":"'[16]Hist Capex by Asset Class '!$F$45","v":0},{"$f":"'[17]Hist Capex by Asset Class '!$G45","v":0}]
[null,"Transmission Lines And Cables - 10Yrs",null,null,0,{"$f":"'[16]Hist Capex by Asset Class '!$F$46","v":0},{"$f":"'[17]Hist Capex by Asset Class '!$G46","v":0}]
[null,"Transmission Substations - 60Yrs",null,null,0,{"$f":"'[16]Hist Capex by Asset Class '!$F$47","v":0},{"$f":"'[17]Hist Capex by Asset Class '!$G47","v":0}]
[null,"Transmission Substations - 45Yrs",null,null,0,{"$f":"'[16]Hist Capex by Asset Class '!$F$48","v":0},{"$f":"'[17]Hist Capex by Asset Class '!$G48","v":0}]
[null,"Transmission Substations - 15Yrs",null,null,0,{"$f":"'[16]Hist Capex by Asset Class '!$F$49","v":0},{"$f":"'[17]Hist Capex by Asset Class '!$G49","v":0}]
[null,"Protection And Control - 15Yrs",null,null,0,{"$f":"'[16]Hist Capex by Asset Class '!$F$50","v":0},{"$f":"'[17]Hist Capex by Asset Class '!$G50","v":0}]
[null,"Protection And Control - 4Yrs",null,null,0,{"$f":"'[16]Hist Capex by Asset Class '!$F$51","v":0},{"$f":"'[17]Hist Capex by Asset Class '!$G51","v":0}]
[null,"Transmission Operations - 10Yrs",null,null,0,{"$f":"'[16]Hist Capex by Asset Class '!$F$52","v":0},{"$f":"'[17]Hist Capex by Asset Class '!$G52","v":0}]
[null,"Transmission Operations - 4Yrs",null,null,0,{"$f":"'[16]Hist Capex by Asset Class '!$F$53","v":0},{"$f":"'[17]Hist Capex by Asset Class '!$G53","v":0}]
[null,"Other - 40Yrs",null,null,0,{"$f":"'[16]Hist Capex by Asset Class '!$F$54","v":0},{"$f":"'[17]Hist Capex by Asset Class '!$G54","v":0}]
[null,"Other - 9Yrs",null,null,-2.7E-2,{"$f":"'[16]Hist Capex by Asset Class '!$F$55","v":-5.9999999999999995E-4},{"$f":"'[17]Hist Capex by Asset Class '!$G55","v":-1.478723E-2}]
[null,"Other - 4Yrs",null,null,0,{"$f":"'[16]Hist Capex by Asset Class '!$F$56","v":0},{"$f":"'[17]Hist Capex by Asset Class '!$G56","v":0}]
[null,"Communications - 45Yrs",null,null,0,{"$f":"'[16]Hist Capex by Asset Class '!$F$57","v":0},{"$f":"'[17]Hist Capex by Asset Class '!$G57","v":0}]
[null,"Communications - 10Yrs",null,null,0,{"$f":"'[16]Hist Capex by Asset Class '!$F$58","v":0},{"$f":"'[17]Hist Capex by Asset Class '!$G58","v":0}]
[null,"Communications - 5Yrs",null,null,0,{"$f":"'[16]Hist Capex by Asset Class '!$F$59","v":0},{"$f":"'[17]Hist Capex by Asset Class '!$G59","v":0}]
[null,"Land and Buildings",null,null,0,{"$f":"'[16]Hist Capex by Asset Class '!$F$60","v":0},{"$f":"'[17]Hist Capex by Asset Class '!$G60","v":0}]
[null,"Equity Raising",null,null,0,{"$f":"'[16]Hist Capex by Asset Class '!$F$61","v":0},{"$f":"'[17]Hist Capex by Asset Class '!$G61","v":0},null,null,"Total Yrs 1-5","Total"]
[null,"Sub total",null,{"$f":"SUM(D44:D61)","v":0},{"$f":"SUM(E44:E61)","v":-2.7E-2},{"$f":"SUM(F44:F61)","v":-5.9999999999999995E-4},{"$f":"SUM(G44:G61)","v":-1.478723E-2},0,0,{"$f":"SUM(E62:I62)","v":-4.2387229999999998E-2},{"$f":"SUM(D62:I62)","v":-4.2387229999999998E-2}]
[]
["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) incl NCIPAP",null,null,null,null,null,null,null,null,null,null,null,"Actual Gross NCIPAP Capital Expenditure – As commissioned ($m Nominal)"]
[null,null,null,"2013-14","2014-15","2015-16","2016-17","2017-18","2018-19",null,null,null,null,"2013-14","2014-15","2015-16","2016-17","2017-18","2018-19"]
["Asset Class"]
[null,"Transmission Lines And Cables - 60Yrs","Transmission Lines And Cables - 60Yrs",43.895156299999996,5.4215254499999999,{"$f":"'[16]Hist Capex by Asset Class '!$F70","v":2.6637168800000004},{"$f":"'[17]Hist Capex by Asset Class '!$G70","v":4.2201212700000008},null,null,null,null,null,"Transmission Lines And Cables - 60Yrs",null,0,{"$f":"'[16]Hist Capex by Asset Class '!$P73","v":0},{"$f":"'[17]Hist Capex by Asset Class '!$Q73","v":0}]
[null,"Transmission Lines And Cables - 45Yrs","Transmission Lines And Cables - 45Yrs",3.15982735,0.69969367000000005,{"$f":"'[16]Hist Capex by Asset Class '!$F71","v":0},{"$f":"'[17]Hist Capex by Asset Class '!$G71","v":0},null,null,null,null,null,"Transmission Lines And Cables - 45Yrs",null,0,{"$f":"'[16]Hist Capex by Asset Class '!$P74","v":0},{"$f":"'[17]Hist Capex by Asset Class '!$Q74","v":0}]
[null,"Transmission Lines And Cables - 10Yrs","Transmission Lines And Cables - 10Yrs",0.73140528000000016,0.47535361999999998,{"$f":"'[16]Hist Capex by Asset Class '!$F72","v":0.7851863},{"$f":"'[17]Hist Capex by Asset Class '!$G72","v":1.9110016400000003},null,null,null,null,null,"Transmission Lines And Cables - 10Yrs",null,0,{"$f":"'[16]Hist Capex by Asset Class '!$P75","v":0},{"$f":"'[17]Hist Capex by Asset Class '!$Q75","v":0}]
[null,"Transmission Substations - 60Yrs","Transmission Substations - 60Yrs",10.624222589999999,3.6910834000000001,{"$f":"'[16]Hist Capex by Asset Class '!$F73","v":3.0083654499999994},{"$f":"'[17]Hist Capex by Asset Class '!$G73","v":1.0595466600000005},null,null,null,null,null,"Transmission Substations - 60Yrs",null,0,{"$f":"'[16]Hist Capex by Asset Class '!$P76","v":0},{"$f":"'[17]Hist Capex by Asset Class '!$Q76","v":0}]
[null,"Transmission Substations - 45Yrs","Transmission Substations - 45Yrs",34.776148339999942,9.8473960399999996,{"$f":"'[16]Hist Capex by Asset Class '!$F74","v":8.8690961399999928},{"$f":"'[17]Hist Capex by Asset Class '!$G74","v":3.6702342700000012},null,null,null,null,null,"Transmission Substations - 45Yrs",null,0,{"$f":"'[16]Hist Capex by Asset Class '!$P77","v":0},{"$f":"'[17]Hist Capex by Asset Class '!$Q77","v":0}]
[null,"Transmission Substations - 15Yrs","Transmission Substations - 15Yrs",4.2076547400000006,1.8511796499999997,{"$f":"'[16]Hist Capex by Asset Class '!$F75","v":1.4839937289000003},{"$f":"'[17]Hist Capex by Asset Class '!$G75","v":1.1853036299999999},null,null,null,null,null,"Transmission Substations - 15Yrs",null,0,{"$f":"'[16]Hist Capex by Asset Class '!$P78","v":0},{"$f":"'[17]Hist Capex by Asset Class '!$Q78","v":0}]
[null,"Protection And Control - 15Yrs","Protection And Control - 15Yrs",23.127965529999997,4.4928939199999993,{"$f":"'[16]Hist Capex by Asset Class '!$F76","v":5.5248598999999992},{"$f":"'[17]Hist Capex by Asset Class '!$G76","v":1.7822087599999998},null,null,null,null,null,"Protection And Control - 15Yrs",null,0,{"$f":"'[16]Hist Capex by Asset Class '!$P79","v":0},{"$f":"'[17]Hist Capex by Asset Class '!$Q79","v":0}]
[null,"Protection And Control - 4Yrs","Protection And Control - 4Yrs",0,0,{"$f":"'[16]Hist Capex by Asset Class '!$F77","v":0},{"$f":"'[17]Hist Capex by Asset Class '!$G77","v":0.16366425999999998},null,null,null,null,null,"Protection And Control - 4Yrs",null,0,{"$f":"'[16]Hist Capex by Asset Class '!$P80","v":0},{"$f":"'[17]Hist Capex by Asset Class '!$Q80","v":0}]
[null,"Transmission Operations - 10Yrs","Transmission Operations - 10Yrs",1.1072172199999999,0.38758884999999998,{"$f":"'[16]Hist Capex by Asset Class '!$F78","v":0.79065718909999994},{"$f":"'[17]Hist Capex by Asset Class '!$G78","v":8.7552235155790221},null,null,null,null,null,"Transmission Operations - 10Yrs",null,0,{"$f":"'[16]Hist Capex by Asset Class '!$P81","v":0},{"$f":"'[17]Hist Capex by Asset Class '!$Q81","v":0}]
[null,"Transmission Operations - 4Yrs","Transmission Operations - 4Yrs",0.16535016999999999,0,{"$f":"'[16]Hist Capex by Asset Class '!$F79","v":0.43664076000000002},{"$f":"'[17]Hist Capex by Asset Class '!$G79","v":1.3215950322629535},null,null,null,null,null,"Transmission Operations - 4Yrs",null,0,{"$f":"'[16]Hist Capex by Asset Class '!$P82","v":0},{"$f":"'[17]Hist Capex by Asset Class '!$Q82","v":0}]
[null,"Other - 40Yrs","Other - 40Yrs",1.1335688799999999,0,{"$f":"'[16]Hist Capex by Asset Class '!$F80","v":0.17579876120000001},{"$f":"'[17]Hist Capex by Asset Class '!$G80","v":0.22625693879348963},null,null,null,null,null,"Other - 40Yrs",null,0,{"$f":"'[16]Hist Capex by Asset Class '!$P83","v":0},{"$f":"'[17]Hist Capex by Asset Class '!$Q83","v":0}]
[null,"Other - 9Yrs","Other - 9Yrs",0.59577568999999997,1.1864682187782514,{"$f":"'[16]Hist Capex by Asset Class '!$F81","v":9.8070881900000004E-2},{"$f":"'[17]Hist Capex by Asset Class '!$G81","v":0.53998939917452238},null,null,null,null,null,"Other - 9Yrs",null,0,{"$f":"'[16]Hist Capex by Asset Class '!$P84","v":0},{"$f":"'[17]Hist Capex by Asset Class '!$Q84","v":0}]
[null,"Other - 4Yrs","Other - 4Yrs",0,3.0453070455170788,{"$f":"'[16]Hist Capex by Asset Class '!$F82","v":0.81005492319999794},{"$f":"'[17]Hist Capex by Asset Class '!$G82","v":0.2498275409165733},null,null,null,null,null,"Other - 4Yrs",null,0,{"$f":"'[16]Hist Capex by Asset Class '!$P85","v":0},{"$f":"'[17]Hist Capex by Asset Class '!$Q85","v":0}]
[null,"Communications - 45Yrs","Communications - 45Yrs",0,0,{"$f":"'[16]Hist Capex by Asset Class '!$F83","v":0},{"$f":"'[17]Hist Capex by Asset Class '!$G83","v":2.2186790000000001E-2},null,null,null,null,null,"Communications - 45Yrs",null,0,{"$f":"'[16]Hist Capex by Asset Class '!$P86","v":0},{"$f":"'[17]Hist Capex by Asset Class '!$Q86","v":0}]
[null,"Communications - 10Yrs","Communications - 10Yrs",0,0,{"$f":"'[16]Hist Capex by Asset Class '!$F84","v":0},{"$f":"'[17]Hist Capex by Asset Class '!$G84","v":2.6306261500000034},null,null,null,null,null,"Communications - 10Yrs",null,0,{"$f":"'[16]Hist Capex by Asset Class '!$P87","v":0},{"$f":"'[17]Hist Capex by Asset Class '!$Q87","v":0}]
[null,"Communications - 5Yrs","Communications - 5Yrs",0,0,{"$f":"'[16]Hist Capex by Asset Class '!$F85","v":0},{"$f":"'[17]Hist Capex by Asset Class '!$G85","v":0},null,null,null,null,null,"Communications - 5Yrs",null,0,{"$f":"'[16]Hist Capex by Asset Class '!$P88","v":0},{"$f":"'[17]Hist Capex by Asset Class '!$Q88","v":0}]
[null,"Land and Buildings","Land and Buildings",0,0,{"$f":"'[16]Hist Capex by Asset Class '!$F86","v":0.27897920000000004},{"$f":"'[17]Hist Capex by Asset Class '!$G86","v":0},null,null,null,null,null,"Land and Buildings",null,0,{"$f":"'[16]Hist Capex by Asset Class '!$P89","v":0},{"$f":"'[17]Hist Capex by Asset Class '!$Q89","v":0}]
[null,"Equity Raising","Equity Raising",0,0,{"$f":"'[16]Hist Capex by Asset Class '!$F87","v":0},{"$f":"'[17]Hist Capex by Asset Class '!$G87","v":0},null,null,null,null,null,"Equity Raising",null,0,{"$f":"'[16]Hist Capex by Asset Class '!$P90","v":0},{"$f":"'[17]Hist Capex by Asset Class '!$Q90","v":0}]
[null,null,null,null,null,null,null,null,null,"Total Yrs 1-5","Total",null,null,null,null,null,null,null,null,"Total Yrs 1-5","Total"]
[null,"Sub total",null,{"$f":"SUM(D70:D88)","v":123.52429208999992},{"$f":"SUM(E70:E88)","v":31.098489864295328},{"$f":"SUM(F70:F88)","v":24.925420114299989},{"$f":"SUM(G70:G88)","v":27.737785856726571},0,0,{"$f":"SUM(E89:I89)","v":83.761695835321888},{"$f":"SUM(D89:I89)","v":207.28598792532179},null,"Sub total",{"$f":"SUM(N70:N88)","v":0},{"$f":"SUM(O70:O88)","v":0},{"$f":"SUM(P70:P88)","v":0},0,{"$f":"SUM(R70:R88)","v":0},{"$f":"SUM(S70:S88)","v":0},{"$f":"SUM(O89:S89)","v":0},{"$f":"SUM(N89:S89)","v":0}]
[]
[]
["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 ",null,null,null,null,null,null,null,null,null,null,null,"Actual Gross NCIPAP Capital Expenditure – As Commissioned ($m Nominal)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"2013-14","2014-15","2015-16","2016-17","2017-18","2018-19"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Weather Station refurbishment program",null,0,{"$f":"'[16]Hist Capex by Asset Class '!$P$98","v":0},{"$f":"'[17]Hist Capex by Asset Class '!$Q98","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"ND1346 George Town Automatic Voltage Control",null,0,{"$f":"'[16]Hist Capex by Asset Class '!$P$98","v":0},{"$f":"'[17]Hist Capex by Asset Class '!$Q99","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"ND1351 Implementation of dynamic rating",null,0,{"$f":"'[16]Hist Capex by Asset Class '!$P$98","v":0},{"$f":"'[17]Hist Capex by Asset Class '!$Q100","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"ND1363 TL Dead End Assembly Upgrade Prog Stg 2",null,0,{"$f":"'[16]Hist Capex by Asset Class '!$P$98","v":0},{"$f":"'[17]Hist Capex by Asset Class '!$Q101","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"ND1364 Power Transformer Dynamic Rating Progra",null,0,{"$f":"'[16]Hist Capex by Asset Class '!$P$98","v":0},{"$f":"'[17]Hist Capex by Asset Class '!$Q102","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"ND1365 Line Fault Indicator Comms Program",null,0,{"$f":"'[16]Hist Capex by Asset Class '!$P$98","v":0},{"$f":"'[17]Hist Capex by Asset Class '!$Q103","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"ND1366 Sheffield Sub 220kV K and L Bay Upgrade",null,0,{"$f":"'[16]Hist Capex by Asset Class '!$P$98","v":0},{"$f":"'[17]Hist Capex by Asset Class '!$Q104","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"ND1367 Castle Forbes Bay Tee disconnector upgr",null,0,{"$f":"'[16]Hist Capex by Asset Class '!$P$98","v":0},{"$f":"'[17]Hist Capex by Asset Class '!$Q105","v":0}]
["Actual Asset Disposal – As De-Commissioned ($m Nominal)",null,null,null,null,null,null,null,null,null,null,null,"ND1372 Modern fault location functionality",null,0,{"$f":"'[16]Hist Capex by Asset Class '!$P$98","v":0},{"$f":"'[17]Hist Capex by Asset Class '!$Q106","v":0}]
[null,null,null,"2013-14","2014-15","2015-16","2016-17","2017-18","2018-19",null,null,null,"Sub total",{"$f":"SUM(N95:N103)","v":0},0,0,0,0,0,{"$f":"SUM(O104:S104)","v":0},{"$f":"SUM(N104:S104)","v":0}]
["Asset Class"]
[null,"Insert asset class from RFM"]
[null,"Insert asset class from RFM"]
[null,"Insert asset class from RFM"]
[null,"Insert asset class from RFM"]
[null,"Insert asset class from RFM"]
[null,"Insert asset class from RFM"]
[null,"Insert asset class from RFM"]
[null,"Insert asset class from RFM"]
[null,"Insert asset class from RFM"]
[null,"Insert asset class from RFM",null,null,null,null,null,null,null,"Total Yrs 1-5","Total"]
[null,"Sub total",null,{"$f":"SUM(D106:D115)","v":0},0,0,0,0,0,{"$f":"SUM(E116:I116)","v":0},{"$f":"SUM(D116:I116)","v":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"]

{"sheet":"Hist Capex - Network","index":23,"n_rows":39,"n_cols":17,"rows_kept":39,"cut":false,"hidden":false,"merged":[[10,4,11,4],[10,8,11,10],[1,1,1,15],[14,5,15,11],[5,3,7,12]]}
[]
[null,"HISTORIC CAPEX - NETWORK- by project"]
[]
[]
[]
[null,null,null,"Not Required - Duplicated in Category Analysis RIN"]
[]
[]
[]
[]
[]
[]
[]
["$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"]

{"sheet":"Hist Capex - Non-Network","index":24,"n_rows":31,"n_cols":17,"rows_kept":31,"cut":false,"hidden":false,"merged":[[1,1,1,15],[10,8,11,10],[14,5,15,11]]}
[]
[null,"HISTORIC CAPEX - NON-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","2014-15","2015-16","2016-17","2017-18","2018-19","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"]
["ND1348","Maria Street Accomodation",null,"Business Support",null,null,{"$f":"'[16]Hist Capex - Non-Network'!$G18","v":0.38183004338291998},{"$f":"'[16]Hist Capex - Non-Network'!$H18","v":0},{"$f":"'[11]Hist Capex - Non-Network'!$I18","v":2.047469211935778E-2},null,null,{"$f":"SUM(F18:K18)","v":0.40230473550227774}]
["-","Fleet",null,"Business Support",null,null,{"$f":"'[16]Hist Capex - Non-Network'!$G19","v":0.67238528521705199},{"$f":"'[16]Hist Capex - Non-Network'!$H19","v":0.62679536310000006},{"$f":"'[11]Hist Capex - Non-Network'!$I19","v":0.65443420916127293},null,null,{"$f":"SUM(F19:K19)","v":1.953614857478325}]
["-","Rocherlea Accomodation Upgrade",null,"Business Support",null,null,{"$f":"'[16]Hist Capex - Non-Network'!$G20","v":0},{"$f":"'[16]Hist Capex - Non-Network'!$H20","v":0.24190237550000002},{"$f":"'[11]Hist Capex - Non-Network'!$I20","v":5.8479933897241251E-2},null,null,0.30038230939724125]
["Various","Business Support Projects < $250,000",null,"Business Support",null,null,{"$f":"'[16]Hist Capex - Non-Network'!$G21","v":0.204902},{"$f":"'[16]Hist Capex - Non-Network'!$H21","v":0.2476781841},{"$f":"'[11]Hist Capex - Non-Network'!$I21","v":0.85942646785828836},null,null,1.3120066519582885]
[]
[]
["-","Ajilis",null,"Information Technology",null,null,{"$f":"'[16]Hist Capex - Non-Network'!$G24","v":0.44677913877283504},{"$f":"'[16]Hist Capex - Non-Network'!$H24","v":3.5226964647000001},{"$f":"'[11]Hist Capex - Non-Network'!$I24","v":5.0253439779564983},null,null,8.9948195814293328]
["M/225591","176153 Data Centre - Remediation",null,"Information Technology",null,null,{"$f":"'[16]Hist Capex - Non-Network'!$G25","v":0.24280921577612702},{"$f":"'[16]Hist Capex - Non-Network'!$H25","v":2.4283565000000002E-3},{"$f":"'[11]Hist Capex - Non-Network'!$I25","v":0},null,null,0.24523757227612702]
["Various","Business Support Projects < $250,000",null,"Information Technology",null,null,{"$f":"'[16]Hist Capex - Non-Network'!$G26","v":1.2288779999999999},{"$f":"'[16]Hist Capex - Non-Network'!$H26","v":0.70984425749999991},{"$f":"'[11]Hist Capex - Non-Network'!$I26","v":3.4284570743860887},null,null,5.3671793318860885]
[]
[]
[null,null,null,null,null,"Subtotal",{"$f":"SUM(G18:G28)","v":3.1775836831489341},{"$f":"SUM(H18:H28)","v":5.3513450014000004},10.046616355378747,0,0,18.575545039927682]
[]
[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"]

{"sheet":"DRS","index":25,"n_rows":29,"n_cols":4,"rows_kept":29,"cut":false,"hidden":false,"merged":[[14,1,14,3],[16,0,16,3],[0,0,0,3],[4,1,4,3],[6,2,6,3],[8,2,8,3],[10,1,10,3],[12,1,12,3]]}
["Directors Responsibility Statement"]
[]
["In the opinion of the directors of Tasmanian Networks Pty Ltd:"]
[]
["●","The regulatory financial statements and other statements, schedules and work papers set out on pages 1 to 24 are drawn up to present fairly as required by the Australian Energy Regulator's (AER's) Transmission Network Service Providers Information Guideline issued April 2015, including:"]
[]
[null,"●","The results of each business segment for the regulatory accounting period ended 30 June 2017."]
[]
[null,"●","Information concerning the state of affairs at 30 June 2017, of each business segment."]
[]
["●","No related party transactions arose during the regulatory accounting period that require disclosure under paragraph 4.14 of the guideline."]
[]
["●","No third party benefit transactions arose during the regulatory accounting period that require disclosure under paragraph 4.15 of the guideline."]
[]
["●","No financing transactions arose during the regulatory accounting period that requires disclosure under paragraph 4.16 of the guideline."]
[]
["The terms and definitions used in this statement accord with the definitions set out in the AER's Transmission Network Service Provider Information Guideline referred to above."]
[]
["Signed in accordance with a resolution of directors:"]
[]
[]
[]
[]
[]
[]
["_________________________",null,null,"_______________________"]
["Dr Dan Norton AO",null,null,"Ms Joanne Doyle"]
[]
["25 October 2017",null,null,"25 October 2017"]

{"sheet":"Sheet1","index":26,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}