{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["Contents","Business & other details","3.1 Revenue","3.2 Operating expenditure","3.2.3 Provisions","3.3 Assets (RAB)","3.4 Operational data","3.5 Physical assets","3.6 Quality of services","3.7 Operating environment","Unlocked worksheet"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":85,"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":"Contents","index":0,"n_rows":12,"n_cols":2,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[null,"REGULATORY REPORTING STATEMENT"]
[null,{"$f":"dms_TradingName","v":"Australian Transmission Co."}]
[null,{"$f":"CONCATENATE(\"Benchmarking RIN response \",CRY)","v":"Benchmarking RIN response 2014-15"}]
[]
[null,"CONTENTS"]
[]
[]
[]
[]
[]
[]
[null,"3.             ECONOMIC BENCHMARKING"]

{"sheet":"Business & other details","index":1,"n_rows":82,"n_cols":20,"rows_kept":82,"cut":false,"hidden":false,"merged":[[51,3,51,4],[58,3,58,9],[59,0,65,0],[30,3,30,4],[30,6,30,7],[32,0,41,0],[32,2,32,9],[38,3,38,4],[43,0,46,0],[24,3,24,4],[24,5,24,8],[28,3,28,4],[28,6,28,7],[29,3,29,4],[29,6,29,7],[23,5,23,8],[0,11,0,19],[7,2,7,9],[11,2,11,9],[13,3,13,5],[14,3,14,5],[17,3,17,4],[17,5,17,8],[18,5,18,8],[19,3,19,4],[19,5,19,8],[22,3,22,4],[22,5,22,8]]}
["HIDE THIS COLUMN",null,{"$f":"(LOOKUP(dms_Model,dms_Model_List,dms_Worksheet_List))","v":"REGULATORY REPORTING STATEMENT"},null,null,null,null,null,null,null,null,"Data in these columns used for data validation and database purposes."]
[null,null,{"$f":"dms_TradingName","v":"Australian Transmission Co."},null,null,null,null,null,null,null,null,"Date last modified:"]
[null,null,{"$f":"CONCATENATE(\"Economic Benchmarking RIN response \", CRY)","v":"Economic Benchmarking RIN response 2014-15"},null,null,null,null,null,null,null,null,"14 April 2015","merged cell C46/47"]
[null,null,"BUSINESS & OTHER DETAILS",null,null,null,null,null,null,null,null,"17 April 2015","adjusted dms_RYE to automate based on dms_Model (NB: EB & CA refer to CRCP_y5)"]
[null,null,null,null,null,null,null,null,null,null,null,"14 May 2015","adapted this cover for use in CA & EB RINs"]
[]
[null,null,"Instructions"]
[null,null,"Complete the following business details regulatory template before entering data or values in any other regulatory template. This regulatory template is linked to other cells within the spreadsheet and automatically generates column headings."]
[]
[null,null,"SUBMISSION PARTICULARS INPUT SHEETS"]
[]
[null,null,"Entity details"]
[]
[null,null,"Trading name","Australian Transmission Co."]
[null,null,"ACN / ABN",{"$f":"INDEX(dms_ABN_List,MATCH(dms_TradingName,dms_TradingName_List))","v":11222333444}]
[]
[null,null,null,null,null,null,null,null,null,null,null,"dms_Model_List ","dms_Worksheet_List ",null,"dms_RYE_List1","dms_RYE_List2"]
[null,null,"Business address","Address 1",null,null,null,null,null,null,null,"CA","REGULATORY REPORTING STATEMENT",null,"dms_RYE",{"$f":"CONCATENATE(LEFT(CRY, 2) &IF(CRY>\"2009-10\",,\"\") &RIGHT(CRY,2))","v":"2015"}]
[null,null,null,null,"Address 2",null,null,null,null,null,null,"CAM/Service change Backcast","REGULATORY REPORTING STATEMENT",null,"dms_RYE",{"$f":"CONCATENATE(LEFT(CRCP_y5, 2) &IF(CRCP_y5>\"2009-10\",,\"\") &RIGHT(CRCP_y5,2))","v":"2016"}]
[null,null,null,"Suburb",null,null,null,null,null,null,null,"CPI","CPI",null,"dms_RYE",{"$f":"CONCATENATE(LEFT(CRCP_y5, 2) &IF(CRCP_y5>\"2009-10\",,\"\") &RIGHT(CRCP_y5,2))","v":"2016"}]
[null,null,null,null,"State",{"$f":"INDEX(dms_State_List,MATCH(dms_TradingName,dms_TradingName_List))","v":"-"},"p/code",null,null,null,null,"EB","REGULATORY REPORTING STATEMENT",null,"dms_RYE",{"$f":"CONCATENATE(LEFT(CRY, 2) &IF(CRY>\"2009-10\",,\"\") &RIGHT(CRY,2))","v":"2015"}]
[null,null,null,null,null,null,null,null,null,null,null,"PTRM","POST TAX REVENUE MODEL",null,"FRCP",{"$f":"CONCATENATE(LEFT(FRCP_y5, 2) &IF(FRCP_y1>\"2009-10\",,\"\") &RIGHT(FRCP_y5,2))","v":"2021"}]
[null,null,"Postal address","Address 1",null,null,null,null,null,null,null,"Reset","REGULATORY REPORTING STATEMENT",null,"FRCP",{"$f":"CONCATENATE(LEFT(CRCP_y5, 2) &IF(CRCP_y5>\"2009-10\",,\"\") &RIGHT(CRCP_y5,2))","v":"2016"}]
[null,null,null,null,"Address 2",null,null,null,null,null,null,"RFM","ROLL FORWARD MODEL",null,"CRCP",{"$f":"CONCATENATE(LEFT(CRCP_y5, 2) &IF(CRCP_y1>\"2009-10\",,\"\") &RIGHT(CRCP_y5,2))","v":"2016"}]
[null,null,null,"Suburb",null,null,null,null,null,null,null,"WACC","WEIGHTED AVERAGE COST OF CAPITAL",null,"dms_RYE",{"$f":"CONCATENATE(LEFT(CRCP_y5, 2) &IF(CRCP_y5>\"2009-10\",,\"\") &RIGHT(CRCP_y5,2))","v":"2016"}]
[null,null,null,null,"State",null,"p/code"]
[]
[null,null,null,null,null,null,null,null,null,null,null,"dms_TradingName_List","dms_ABN_List","dms_State_List","dms_Sector_List","dms_Segment_List","dms_FormControl","dms_CRCPlength_List","dms_FRCPlength_List","dms_JurisdictionList"]
[null,null,"Contact name/s",null,null,null,null,null,null,null,null,"ActewAGL Distribution",76670568688,"ACT","Electricity","Distribution","Revenue cap",5,6,"ACT"]
[null,null,"Contact phone/s",null,null,null,null,null,null,null,null,"ActewAGL Distribution (Tx Assets)",76670568688,"ACT","Electricity","Distribution","Revenue cap",5,5,"ACT"]
[null,null,"Contact email address/s",null,null,null,null,null,null,null,null,"AGN",78551685,"SA","Gas","Distribution","Revenue cap",5,5,"SA"]
[null,null,null,null,null,null,null,null,null,null,null,"Ausgrid",67505337385,"NSW","Electricity","Distribution","Revenue cap",5,5,"NSW"]
["KEEP VISIBLE FOR\n RESET, PTRM & RFMS",null,"Regulatory control period details",null,null,null,null,null,null,null,null,"Ausgrid (Tx Assets)",67505337385,"NSW","Electricity","Distribution","Revenue cap",5,5,"NSW"]
[null,null,null,null,null,null,null,null,null,null,null,"AusNet (D)",91064651118,"Vic","Electricity","Distribution","Revenue cap",5,5,"Vic"]
[null,null,"Forthcoming regulatory control period",{"$f":"CONCATENATE(IF(dms_RPT=\"Calendar\",CRCP_y5+1,(LEFT(CRCP_y5,4)+1&\"-\"&IF(MID(CRCP_y5,6,2)<\"09\",\"0\"&RIGHT(CRCP_y5,1)+1,RIGHT(CRCP_y5,2)+1))))","v":"2016-17"},{"$f":"CONCATENATE(IF(dms_RPT=\"Calendar\",FRCP_y1+1,(LEFT(FRCP_y1,4)+1&\"-\"&IF(MID(FRCP_y1,6,2)<\"09\",\"0\"&RIGHT(FRCP_y1,1)+1,RIGHT(FRCP_y1,2)+1))))","v":"2017-18"},{"$f":"CONCATENATE(IF(dms_RPT=\"Calendar\",FRCP_y2+1,(LEFT(FRCP_y2,4)+1&\"-\"&IF(MID(FRCP_y2,6,2)<\"09\",\"0\"&RIGHT(FRCP_y2,1)+1,RIGHT(FRCP_y2,2)+1))))","v":"2018-19"},{"$f":"CONCATENATE(IF(dms_RPT=\"Calendar\",FRCP_y3+1,(LEFT(FRCP_y3,4)+1&\"-\"&IF(MID(FRCP_y3,6,2)<\"09\",\"0\"&RIGHT(FRCP_y3,1)+1,RIGHT(FRCP_y3,2)+1))))","v":"2019-20"},{"$f":"CONCATENATE(IF(dms_RPT=\"Calendar\",FRCP_y4+1,(LEFT(FRCP_y4,4)+1&\"-\"&IF(MID(FRCP_y4,6,2)<\"09\",\"0\"&RIGHT(FRCP_y4,1)+1,RIGHT(FRCP_y4,2)+1))))","v":"2020-21"},null,null,null,"AusNet (T)",78079798173,"Vic","Electricity","Transmission","Revenue cap",5,5,"Vic"]
[null,null,null,null,null,null,null,null,null,null,null,"Australian Distribution Co.",11222333444,"-","Electricity","Distribution","Revenue cap",5,5,"-"]
[null,null,null,null,null,null,null,null,null,null,null,"Australian Transmission Co.",11222333444,"-","Electricity","Transmission","Revenue cap",5,5,"-"]
[null,null,"Current regulatory control period","2011-12",{"$f":"CONCATENATE(IF(dms_RPT=\"Calendar\",CRCP_y1+1,(LEFT(CRCP_y1,4)+1&\"-\"&IF(MID(CRCP_y1,6,2)<\"09\",\"0\"&RIGHT(CRCP_y1,1)+1,RIGHT(CRCP_y1,2)+1))))","v":"2012-13"},{"$f":"CONCATENATE(IF(dms_RPT=\"Calendar\",CRCP_y2+1,(LEFT(CRCP_y2,4)+1&\"-\"&IF(MID(CRCP_y2,6,2)<\"09\",\"0\"&RIGHT(CRCP_y2,1)+1,RIGHT(CRCP_y2,2)+1))))","v":"2013-14"},{"$f":"CONCATENATE(IF(dms_RPT=\"Calendar\",CRCP_y3+1,(LEFT(CRCP_y3,4)+1&\"-\"&IF(MID(CRCP_y3,6,2)<\"09\",\"0\"&RIGHT(CRCP_y3,1)+1,RIGHT(CRCP_y3,2)+1))))","v":"2014-15"},{"$f":"CONCATENATE(IF(dms_RPT=\"Calendar\",CRCP_y4+1,(LEFT(CRCP_y4,4)+1&\"-\"&IF(MID(CRCP_y4,6,2)<\"09\",\"0\"&RIGHT(CRCP_y4,1)+1,RIGHT(CRCP_y4,2)+1))))","v":"2015-16"},null,null,null,"CitiPower",76064651056,"Vic","Electricity","Distribution","Revenue cap",5,5,"Vic"]
[null,null,null,null,null,null,null,null,null,null,null,"Directlink",16779340889,"NSW","Electricity","Transmission","Revenue cap",10,5,"Qld"]
[null,null,null,null,null,null,null,null,null,null,null,"ElectraNet",41094482416,"SA","Electricity","Transmission","Revenue cap",5,5,"SA"]
[null,null,"Previous regulatory control period",{"$f":"CONCATENATE(IF(dms_RPT=\"Calendar\",PRCP_y2-1,(LEFT(PRCP_y2,4)-1&\"-\"&IF(MID(PRCP_y2,3,1)=\"0\",\"0\"&RIGHT(PRCP_y2,2)-1,RIGHT(PRCP_y2,2)-1))))","v":"2006-07"},{"$f":"CONCATENATE(IF(dms_RPT=\"Calendar\",PRCP_y3-1,(LEFT(PRCP_y3,4)-1&\"-\"&IF(MID(PRCP_y3,3,1)=\"0\",\"0\"&RIGHT(PRCP_y3,2)-1,RIGHT(PRCP_y3,2)-1))))","v":"2007-08"},{"$f":"CONCATENATE(IF(dms_RPT=\"Calendar\",PRCP_y4-1,(LEFT(PRCP_y4,4)-1&\"-\"&IF(MID(PRCP_y4,3,1)=\"0\",\"0\"&RIGHT(PRCP_y4,2)-1,RIGHT(PRCP_y4,2)-1))))","v":"2008-09"},{"$f":"CONCATENATE(IF(dms_RPT=\"Calendar\",PRCP_y5-1,(LEFT(PRCP_y5,4)-1&\"-\"&IF(MID(PRCP_y5,3,1)=\"0\",\"0\"&RIGHT(PRCP_y5,2)-1,RIGHT(PRCP_y5,2)-1))))","v":"2009-10"},{"$f":"CONCATENATE(IF(dms_RPT=\"Calendar\",CRCP_y1-1,(LEFT(CRCP_y1,4)-1&\"-\"&IF(MID(CRCP_y1,3,1)=\"0\",\"0\"&RIGHT(CRCP_y1,2)-1,RIGHT(CRCP_y1,2)-1))))","v":"2010-11"},null,null,null,"Endeavour Energy",59253130878,"NSW","Electricity","Distribution","Revenue cap",5,5,"NSW"]
[null,null,null,null,null,null,null,null,null,null,null,"Energex",40078849055,"Qld","Electricity","Distribution","Revenue cap",5,5,"Qld"]
[null,null,null,null,null,null,null,null,null,null,null,"Ergon Energy",50087646062,"Qld","Electricity","Distribution","Revenue cap",5,5,"Qld"]
["KEEP VISIBLE FOR\nCA & EB ONLY",null,null,null,null,null,null,null,null,null,null,"Essential Energy",37428185226,"NSW","Electricity","Distribution","Revenue cap",5,5,"NSW"]
[null,null,"Current regulatory year","2014-15",null,null,null,null,null,null,null,"Jemena Electricity",82064651083,"Vic","Electricity","Distribution","Revenue cap",5,5,"Vic"]
[null,null,null,null,null,null,null,null,null,null,null,"Murraylink",79181207909,"NSW","Electricity","Transmission","Revenue cap",5,5,"SA"]
[null,null,null,null,null,null,null,null,null,null,null,"Powercor Australia",89064651109,"Vic","Electricity","Distribution","Revenue cap",5,5,"Vic"]
[null,null,null,null,null,null,null,null,null,null,null,"Powerlink",82078849233,"Qld","Electricity","Transmission","Revenue cap",5,5,"Qld"]
[null,null,null,null,null,null,null,null,null,null,null,"Qld,SA &ACT Gas Reset",22222222222,"-","Gas","Distribution","?",5,5,"-"]
[null,null,"Sector",{"$f":"INDEX(dms_Sector_List,MATCH(dms_TradingName,dms_TradingName_List))","v":"Electricity"},null,null,null,null,null,null,null,"SA Power Networks",13332330749,"SA","Electricity","Distribution","Revenue cap",5,5,"SA"]
[null,null,"Segment",{"$f":"INDEX(dms_Segment_List,MATCH(dms_TradingName,dms_TradingName_List))","v":"Transmission"},null,null,null,null,null,null,null,"TasNetworks (D)",24167357299,"Tas","Electricity","Distribution","Revenue cap",5,5,"Tas"]
[null,null,"Source","Reporting",null,null,null,null,null,null,null,"TasNetworks (T)",24167357299,"Tas","Electricity","Transmission","Revenue cap",5,5,"Tas"]
[null,null,"Regulatory Year Ending",{"$f":"(LOOKUP(dms_Model,dms_Model_List,dms_RYE_List2))","v":"2015"},null,null,null,null,null,null,null,"TransGrid",19622755774,"NSW","Electricity","Transmission","Revenue cap",5,5,"NSW"]
[null,null,"Reporting Period Type",{"$f":"IF(LEN(CRCP_y1)>4,\"Financial\",\"Calendar\")","v":"Financial"},null,null,null,null,null,null,null,"United Energy",70064651029,"Vic","Electricity","Distribution","Revenue cap",5,5,"Vic"]
[null,null,"Model or RIN Type","EB",null,null,null,null,null,null,null,"Victorian DNSP Backcasting",33333333666,"Vic","Electricity","Distribution","?",5,5,"Vic"]
[null,null,"Security Classification",{"$f":"IF(dms_DataQuality=\"Public\",\"Public\",\"Confidential\")","v":"Confidential"},null,null,null,null,null,null,null,"Victorian DNSP Reset ",33333333333,"Vic","Electricity","Distribution","?",5,5,"Vic"]
[null,null,"Data quality (actual, estimate, public, consolidated)","Consolidated"]
[null,null,"EBSS - First application of scheme in forthcoming period?","No"]
[null,null,"Amended RIN submission - amendment reason","Revised EB to bring into line with an amended Reset RIN"]
["HIDE THESE ROWS",null,"Template - version no.",1]
[null,null,"Dollar $ real  (the last month before the FRCP_y1)",{"$f":"CONCATENATE(IF(dms_RPT=\"Financial\",\"June \",\"December \"),(dms_RYE))","v":"June 2015"},null,null,null,null,null,null,null,"dms_SourceList","dms_FormControl"]
[null,null,"Form of control",{"$f":"INDEX(dms_FormControl_List,MATCH(dms_TradingName,dms_TradingName_List))","v":"Revenue cap"},null,null,null,null,null,null,null,"After appeal","Revenue cap"]
[null,null,"Length of current reg control period",{"$f":"INDEX(dms_CRCPlength_List,MATCH(dms_TradingName,dms_TradingName_List))","v":5},null,null,null,null,null,null,null,"Draft decision","Revenue yield"]
[null,null,"Length of forthcoming reg control period",{"$f":"INDEX(dms_FRCPlength_List,MATCH(dms_TradingName,dms_TradingName_List))","v":5},null,null,null,null,null,null,null,"Final decision","Weighted average price cap"]
[null,null,"RIN response - version no.",1,null,null,null,null,null,null,null,"Pass through decision"]
[null,null,"Jurisdiction",{"$f":"INDEX(dms_JurisdictionList,MATCH(dms_TradingName,dms_TradingName_List))","v":"-"},null,null,null,null,null,null,null,"PTRM annual update"]
[null,null,null,null,null,null,null,null,null,null,null,"PTRM interim update 1"]
[null,null,null,null,null,null,null,null,null,null,null,"PTRM interim update 2"]
[null,null,null,null,null,null,null,null,null,null,null,"PTRM interim update 3"]
[null,null,null,null,null,null,null,null,null,null,null,"PTRM interim update 4"]
[null,null,null,null,null,null,null,null,null,null,null,"Regulatory proposal"]
[null,null,null,null,null,null,null,null,null,null,null,"Reporting"]
[null,null,null,null,null,null,null,null,null,null,null,"Revised regulatory proposal"]
[null,null,null,null,null,null,null,null,null,null,null,"RFM annual update"]
[null,null,null,null,null,null,null,null,null,null,null,"WACC annual update"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Notes"]
[null,null,null,null,null,null,null,null,null,null,null,"RFM - Base year is usually CRCP_y1","EG. Victorian 2016-20 - base year = 2011"]
[null,null,null,null,null,null,null,null,null,null,null,"RFM - Form of Control Field is not relevant"]
[null,null,null,null,null,null,null,null,null,null,null,"PTRM - capture base year input by NSP","='[Published version - PTRM - TNSP - version 3 - January 2015 - Appendix A.xlsm]PTRM input'!Q7"]

{"sheet":"3.1 Revenue","index":2,"n_rows":37,"n_cols":8,"rows_kept":37,"cut":false,"hidden":false,"merged":[]}
[null,null,{"$f":"(LOOKUP(dms_Model,dms_Model_List,dms_Worksheet_List))","v":"REGULATORY REPORTING STATEMENT"}]
[null,null,{"$f":"dms_TradingName","v":"Australian Transmission Co."}]
[null,null,{"$f":"CONCATENATE(\"Economic Benchmarking RIN response \", CRY)","v":"Economic Benchmarking RIN response 2014-15"}]
[null,null,"3.1 REVENUE"]
[]
[]
[null,null,null,null,"Actual\n($0's)"]
[null,null,null,null,{"$f":"CRY","v":"2014-15"}]
[]
[null,null,"TABLE 3.1.1 REVENUE GROUPING BY CHARGEABLE QUANTITY"]
["ET_REV3110_00001","TREV0101","From Fixed Customer (Exit Point) Charges",null,96161179.454545498]
["ET_REV3110_00002","TREV0102","From Variable Customer (Exit Point) Charges",null,0]
["ET_REV3110_00003","TREV0103","From Fixed Generator (Entry Point) Charges",null,7977000]
["ET_REV3110_00004","TREV0104","From Variable Generator (Entry Point) Charges",null,0]
["ET_REV3110_00005","TREV0105","From Fixed Energy Usage Charges (Charge per day basis)",null,182048446.18181801]
["ET_REV3110_00006","TREV0106","From Variable Energy Usage charges (Charge per kWh basis)",null,88676503.463451296]
["ET_REV3110_00007","TREV0107","From Energy based Common Service and General Charges",null,399058304.36363602]
["ET_REV3110_00008","TREV0108","From Fixed Demand based Usage Charges",null,36967781]
["ET_REV3110_00009","TREV0109","From Variable Demand based Usage Charges",null,7494746.6101172296]
["ET_REV3110_00010","TREV0110","Revenue from other Sources",null,137873739.39643201]
[null,"TREV01","Total revenue by chargeable quantity","$0's",{"$f":"SUM(E11:E20)","v":956257700.47000003}]
[]
[]
[null,null,"TABLE 3.1.2 REVENUE GROUPING BY TYPE OF CONNECTED EQUIPMENT"]
["ET_REV3120_00001","TREV0201","From Other connected transmission networks",null,0]
["ET_REV3120_00002","TREV0202","From Distribution networks",null,695645101.35752499]
["ET_REV3120_00003","TREV0203","From Directly connected end–users",null,114761859.716043]
["ET_REV3120_00004","TREV0204","From Generators",null,7977000]
["ET_REV3120_00005","TREV0205","Other revenue",null,137873739.39643201]
[null,"TREV02","Total revenue by type of connected equipment","$0's",{"$f":"SUM(E25:E29)","v":956257700.47000003}]
[]
[null,null,null,null,null,null,null,"`"]
[null,null,"TABLE 3.1.3 REVENUE (penalties) ALLOWED (deducted) THROUGH INCENTIVE SCHEMES"]
["ET_REV3130_00001","TREV0301","EBSS",null,-2932859.5202212902]
["ET_REV3130_00002","TREV0302","STPIS",null,20657814.9985261]
["ET_REV3130_00003","TREV0303","Other",null,0]
[null,"TREV03","Total revenue of incentive schemes","$0's",{"$f":"SUM(E34:E36)","v":17724955.478304811}]

{"sheet":"3.2 Operating expenditure","index":3,"n_rows":195,"n_cols":5,"rows_kept":195,"cut":false,"hidden":false,"merged":[]}
[null,null,"REGULATORY REPORTING STATEMENT"]
[null,null,{"$f":"dms_TradingName","v":"Australian Transmission Co."}]
[null,null,{"$f":"CONCATENATE(\"Benchmarking RIN response \",CRY)","v":"Benchmarking RIN response 2014-15"}]
[null,null,"3.2 OPERATING EXPENDITURE"]
[]
[]
[null,null,"Instructions"]
[null,null,{"$f":"CONCATENATE(dms_TradingName, \" must fill in opex in table 3.2.1 for opex categories reported in response to its annual reporting RIN.\")","v":"Australian Transmission Co. must fill in opex in table 3.2.1 for opex categories reported in response to its annual reporting RIN."}]
[]
[]
[]
[]
[null,null,null,null,"Actual\n($0's)"]
["ET_OPX3211",null,null,null,{"$f":"CRY","v":"2014-15"}]
[]
[null,null,"TABLE 3.2.1 - OPEX CATEGORIES"]
[]
[null,null,"Table 3.2.1.1 Current opex categories  and cost allocations"]
["ET_OPX3211_00001","TOPEX0101","Field Maintenance - Routine",null,23777725.300000001]
["ET_OPX3211_00002","TOPEX0102","Field Maintenance - Condition-based",null,24814083.600000001]
["ET_OPX3211_00003","TOPEX0103","Field Maintenance - Corrective",null,15584853.039999999]
["ET_OPX3211_00004","TOPEX0104","Maintenance Support",null,12687229.07]
["ET_OPX3211_00005","TOPEX0105","Refurbishment",null,37504950.409999996]
["ET_OPX3211_00006","TOPEX0106","Insurance Premiums",null,6668626]
["ET_OPX3211_00007","TOPEX0107","Self Insurance",null,1704437.8096598999]
["ET_OPX3211_00008","TOPEX0108","Network Operations",null,15160197.83]
["ET_OPX3211_00009","TOPEX0109","Asset Management Support",null,34175018.450000003]
["ET_OPX3211_00010","TOPEX0110","Corporate Support",null,18839396.120000001]
["ET_OPX3211_00011","TOPEX0111","AEMC Levy",null,3790000]
["ET_OPX3211_00012","TOPEX0112","Project 500kV - write-off",null,12053999.380000001]
["ET_OPX3211_00013","TOPEX0113","Revenue Reset",null,1356031.1]
["ET_OPX3211_00014","TOPEX0114","Debt Management Costs",null,500000]
["ET_OPX3211_00015","TOPEX0115","Grid Support",null,2644445.5499999998]
["ET_OPX3211_00016","TOPEX0116"]
["ET_OPX3211_00017","TOPEX0117"]
["ET_OPX3211_00018","TOPEX0118"]
["ET_OPX3211_00019","TOPEX0119"]
["ET_OPX3211_00020","TOPEX0120"]
["ET_OPX3211_00021","TOPEX0121"]
["ET_OPX3211_00022","TOPEX0122"]
["ET_OPX3211_00023","TOPEX0123"]
["ET_OPX3211_00024","TOPEX0124"]
["ET_OPX3211_00025","TOPEX0125"]
["ET_OPX3211_00026","TOPEX0126"]
["ET_OPX3211_00027","TOPEX0127"]
["ET_OPX3211_00028","TOPEX0128"]
["ET_OPX3211_00029","TOPEX0129"]
["ET_OPX3211_00030","TOPEX0130"]
["ET_OPX3211_00031","TOPEX0131"]
["ET_OPX3211_00032","TOPEX0132"]
["ET_OPX3211_00033","TOPEX0133"]
["ET_OPX3211_00034","TOPEX0134"]
["ET_OPX3211_00035","TOPEX0135"]
["ET_OPX3211_00036","TOPEX0136"]
["ET_OPX3211_00037","TOPEX0137"]
["ET_OPX3211_00038","TOPEX0138"]
["ET_OPX3211_00039","TOPEX0139"]
["ET_OPX3211_00040","TOPEX0140"]
["ET_OPX3211_00041","TOPEX0141"]
[null,"TOPEX01","Total opex ","($0's)",{"$f":"SUM(E19:E59)","v":211260993.65965989}]
[]
["ET_OPX3211A",null,"Table 3.2.1.2A - Historical opex categories and cost allocations",null,{"$f":"CRY","v":"2014-15"}]
["ET_OPX3211A_00001","TOPEX0101A","Field Maintenance - Routine",null,23777725.300000001]
["ET_OPX3211A_00002","TOPEX0102A","Field Maintenance - Condition-based",null,24814083.600000001]
["ET_OPX3211A_00003","TOPEX0103A","Field Maintenance - Corrective",null,15584853.039999999]
["ET_OPX3211A_00004","TOPEX0104A","Maintenance Support",null,12687229.07]
["ET_OPX3211A_00005","TOPEX0105A","Refurbishment",null,37504950.409999996]
["ET_OPX3211A_00006","TOPEX0106A","Insurance Premiums",null,6668626]
["ET_OPX3211A_00007","TOPEX0107A","Self Insurance",null,1704437.8096598999]
["ET_OPX3211A_00008","TOPEX0108A","Network Operations",null,15160197.83]
["ET_OPX3211A_00009","TOPEX0109A","Asset Management Support",null,34175018.450000003]
["ET_OPX3211A_00010","TOPEX0110A","Corporate Support",null,18839396.120000001]
["ET_OPX3211A_00011","TOPEX0111A","AEMC Levy",null,3790000]
["ET_OPX3211A_00012","TOPEX0112A","Project 500kV - write-off",null,12053999.380000001]
["ET_OPX3211A_00013","TOPEX0113A","Revenue Reset",null,1356031.1]
["ET_OPX3211A_00014","TOPEX0114A","Debt Management Costs",null,500000]
["ET_OPX3211A_00015","TOPEX0115A","Grid Support",null,2644445.5499999998]
["ET_OPX3211A_00016","TOPEX0116A"]
["ET_OPX3211A_00017","TOPEX0117A"]
["ET_OPX3211A_00018","TOPEX0118A"]
["ET_OPX3211A_00019","TOPEX0119A"]
["ET_OPX3211A_00020","TOPEX0120A"]
["ET_OPX3211A_00021","TOPEX0121A"]
["ET_OPX3211A_00022","TOPEX0122A"]
["ET_OPX3211A_00023","TOPEX0123A"]
["ET_OPX3211A_00024","TOPEX0124A"]
["ET_OPX3211A_00025","TOPEX0125A"]
["ET_OPX3211A_00026","TOPEX0126A"]
["ET_OPX3211A_00027","TOPEX0127A"]
["ET_OPX3211A_00028","TOPEX0128A"]
["ET_OPX3211A_00029","TOPEX0129A"]
["ET_OPX3211A_00030","TOPEX0130A"]
["ET_OPX3211A_00031","TOPEX0131A"]
["ET_OPX3211A_00032","TOPEX0132A"]
["ET_OPX3211A_00033","TOPEX0133A"]
["ET_OPX3211A_00034","TOPEX0134A"]
["ET_OPX3211A_00035","TOPEX0135A"]
["ET_OPX3211A_00036","TOPEX0136A"]
["ET_OPX3211A_00037","TOPEX0137A"]
["ET_OPX3211A_00038","TOPEX0138A"]
["ET_OPX3211A_00039","TOPEX0139A"]
["ET_OPX3211A_00040","TOPEX0140A"]
["ET_OPX3211A_00041","TOPEX0141A"]
["ET_OPX3211A_00042","TOPEX0142A"]
[null,"TOPEX01A","Total opex ","($0's)",{"$f":"SUM(E63:E104)","v":211260993.65965989}]
[]
["ET_OPX3211B",null,"Table 3.2.1.2B - Historical opex categories and cost allocations",null,{"$f":"CRY","v":"2014-15"}]
["ET_OPX3211B_00001","TOPEX0101B"]
["ET_OPX3211B_00002","TOPEX0102B"]
["ET_OPX3211B_00003","TOPEX0103B"]
["ET_OPX3211B_00004","TOPEX0104B"]
["ET_OPX3211B_00005","TOPEX0105B"]
["ET_OPX3211B_00006","TOPEX0106B"]
["ET_OPX3211B_00007","TOPEX0107B"]
["ET_OPX3211B_00008","TOPEX0108B"]
["ET_OPX3211B_00009","TOPEX0109B"]
["ET_OPX3211B_00010","TOPEX0110B"]
["ET_OPX3211B_00011","TOPEX0111B"]
["ET_OPX3211B_00012","TOPEX0112B"]
["ET_OPX3211B_00013","TOPEX0113B"]
["ET_OPX3211B_00014","TOPEX0114B"]
["ET_OPX3211B_00015","TOPEX0115B"]
["ET_OPX3211B_00016","TOPEX0116B"]
["ET_OPX3211B_00017","TOPEX0117B"]
["ET_OPX3211B_00018","TOPEX0118B"]
["ET_OPX3211B_00019","TOPEX0119B"]
["ET_OPX3211B_00020","TOPEX0120B"]
["ET_OPX3211B_00021","TOPEX0121B"]
["ET_OPX3211B_00022","TOPEX0122B"]
["ET_OPX3211B_00023","TOPEX0123B"]
["ET_OPX3211B_00024","TOPEX0124B"]
["ET_OPX3211B_00025","TOPEX0125B"]
["ET_OPX3211B_00026","TOPEX0126B"]
["ET_OPX3211B_00027","TOPEX0127B"]
["ET_OPX3211B_00028","TOPEX0128B"]
["ET_OPX3211B_00029","TOPEX0129B"]
["ET_OPX3211B_00030","TOPEX0130B"]
["ET_OPX3211B_00031","TOPEX0131B"]
["ET_OPX3211B_00032","TOPEX0132B"]
["ET_OPX3211B_00033","TOPEX0133B"]
["ET_OPX3211B_00034","TOPEX0134B"]
["ET_OPX3211B_00035","TOPEX0135B"]
["ET_OPX3211B_00036","TOPEX0136B"]
["ET_OPX3211B_00037","TOPEX0137B"]
["ET_OPX3211B_00038","TOPEX0138B"]
["ET_OPX3211B_00039","TOPEX0139B"]
["ET_OPX3211B_00040","TOPEX0140B"]
["ET_OPX3211B_00041","TOPEX0141B"]
["ET_OPX3211B_00042","TOPEX0142B"]
[null,"TOPEX01B","Total opex ","($0's)",{"$f":"SUM(E108:E149)","v":0}]
[]
["ET_OPX3211C",null,"Table 3.2.1.2C - Historical opex categories and cost allocations",null,{"$f":"CRY","v":"2014-15"}]
["ET_OPX3211C_00001","TOPEX0101C"]
["ET_OPX3211C_00002","TOPEX0102C"]
["ET_OPX3211C_00003","TOPEX0103C"]
["ET_OPX3211C_00004","TOPEX0104C"]
["ET_OPX3211C_00005","TOPEX0105C"]
["ET_OPX3211C_00006","TOPEX0106C"]
["ET_OPX3211C_00007","TOPEX0107C"]
["ET_OPX3211C_00008","TOPEX0108C"]
["ET_OPX3211C_00009","TOPEX0109C"]
["ET_OPX3211C_00010","TOPEX0110C"]
["ET_OPX3211C_00011","TOPEX0111C"]
["ET_OPX3211C_00012","TOPEX0112C"]
["ET_OPX3211C_00013","TOPEX0113C"]
["ET_OPX3211C_00014","TOPEX0114C"]
["ET_OPX3211C_00015","TOPEX0115C"]
["ET_OPX3211C_00016","TOPEX0116C"]
["ET_OPX3211C_00017","TOPEX0117C"]
["ET_OPX3211C_00018","TOPEX0118C"]
["ET_OPX3211C_00019","TOPEX0119C"]
["ET_OPX3211C_00020","TOPEX0120C"]
["ET_OPX3211C_00021","TOPEX0121C"]
["ET_OPX3211C_00022","TOPEX0122C"]
["ET_OPX3211C_00023","TOPEX0123C"]
["ET_OPX3211C_00024","TOPEX0124C"]
["ET_OPX3211C_00025","TOPEX0125C"]
["ET_OPX3211C_00026","TOPEX0126C"]
["ET_OPX3211C_00027","TOPEX0127C"]
["ET_OPX3211C_00028","TOPEX0128C"]
["ET_OPX3211C_00029","TOPEX0129C"]
["ET_OPX3211C_00030","TOPEX0130C"]
["ET_OPX3211C_00031","TOPEX0131C"]
["ET_OPX3211C_00032","TOPEX0132C"]
["ET_OPX3211C_00033","TOPEX0133C"]
["ET_OPX3211C_00034","TOPEX0134C"]
["ET_OPX3211C_00035","TOPEX0135C"]
["ET_OPX3211C_00036","TOPEX0136C"]
["ET_OPX3211C_00037","TOPEX0137C"]
["ET_OPX3211C_00038","TOPEX0138C"]
["ET_OPX3211C_00039","TOPEX0139C"]
["ET_OPX3211C_00040","TOPEX0140C"]
["ET_OPX3211C_00041","TOPEX0141C"]
["ET_OPX3211C_00042","TOPEX0142C"]
[null,"TOPEX01C","Total opex ","($0's)",{"$f":"SUM(E153:E194)","v":0}]

{"sheet":"3.2.3 Provisions","index":4,"n_rows":374,"n_cols":5,"rows_kept":374,"cut":false,"hidden":false,"merged":[]}
[null,null,"REGULATORY REPORTING STATEMENT"]
[null,null,{"$f":"dms_TradingName","v":"Australian Transmission Co."}]
[null,null,{"$f":"CONCATENATE(\"Benchmarking RIN response \",CRY)","v":"Benchmarking RIN response 2014-15"}]
[null,null,"3.2 OPERATING EXPENDITURE"]
[]
[]
[null,null,"Instructions"]
[null,null,{"$f":"CONCATENATE(TradingName, \" must fill in opex in table 3.2.3 for opex categories reported in response to its annual reporting RIN.\")","v":{"$error":"#NAME?"}}]
[]
[null,null,"TABLE 3.2.3 - PROVISIONS"]
[null,null,"For each provision report:"]
[null,null,null,null,"$0's"]
[null,null,null,null,{"$f":"CRY","v":"2014-15"}]
[]
[null,"TOPEX03A","Other Provision"]
[null,null,"Provision for Powerlinks restructure activities. "]
[null,"TOPEX0301A","Opening balance (the carrying amount at the beginning of the period)",null,991001]
[null,null,"Additional provisions made in the period, including increases to existing provisions"]
[null,"TOPEX0302A","Opex component",null,178036]
[null,"TOPEX0303A","Capex component",null,0]
[null,"TOPEX0304A","Other component",null,0]
[null,null,"Amounts used (that is, incurred and charged against the provision) during the period"]
[null,"TOPEX0305A","Opex component",null,-991001]
[null,"TOPEX0306A","Capex component",null,0]
[null,"TOPEX0307A","Other component",null,0]
[null,null,"Unused amounts reversed during the period"]
[null,"TOPEX0308A","Opex component",null,0]
[null,"TOPEX0309A","Capex component",null,0]
[null,"TOPEX0310A","Other component",null,0]
[null,null,"The increase during the period in the discounted amount arising from the passage of time and the effect of any change in the discount rate"]
[null,"TOPEX0311A","Opex component",null,0]
[null,"TOPEX0312A","Capex component",null,0]
[null,"TOPEX0313A","Other component",null,0]
[null,"TOPEX0314A","Closing balance (carrying amount at the end of the period)",null,178036]
[null,"TOPEX03B","Employee Entitlements"]
[null,null,"Employee Annual and Long Service leave Liability "]
[null,"TOPEX0301B","Opening balance (the carrying amount at the beginning of the period)",null,31436206.668343101]
[null,null,"Additional provisions made in the period, including increases to existing provisions"]
[null,"TOPEX0302B","Opex component",null,5966260.2873043297]
[null,"TOPEX0303B","Capex component",null,4644805.5232284097]
[null,"TOPEX0304B","Other component",null,0]
[null,null,"Amounts used (that is, incurred and charged against the provision) during the period"]
[null,"TOPEX0305B","Opex component",null,-6291063.8368300796]
[null,"TOPEX0306B","Capex component",null,-4897669.0002060505]
[null,"TOPEX0307B","Other component",null,0]
[null,null,"Unused amounts reversed during the period"]
[null,"TOPEX0308B","Opex component",null,0]
[null,"TOPEX0309B","Capex component",null,0]
[null,"TOPEX0310B","Other component",null,0]
[null,null,"The increase during the period in the discounted amount arising from the passage of time and the effect of any change in the discount rate"]
[null,"TOPEX0311B","Opex component",null,64964.594669887803]
[null,"TOPEX0312B","Capex component",null,50575.719731685604]
[null,"TOPEX0313B","Other component",null,0]
[null,"TOPEX0314B","Closing balance (carrying amount at the end of the period)",null,30974079.956241298]
[null,"TOPEX03C","Dividends"]
[null,null,"Provision for Dividends declared by the Board of Directors"]
[null,"TOPEX0301C","Opening balance (the carrying amount at the beginning of the period)",null,147571325.13216001]
[null,null,"Additional provisions made in the period, including increases to existing provisions"]
[null,"TOPEX0302C","Opex component",null,1123116033.79969]
[null,"TOPEX0303C","Capex component",null,0]
[null,"TOPEX0304C","Other component",null,0]
[null,null,"Amounts used (that is, incurred and charged against the provision) during the period"]
[null,"TOPEX0305C","Opex component",null,-147571325.13216001]
[null,"TOPEX0306C","Capex component",null,0]
[null,"TOPEX0307C","Other component",null,0]
[null,null,"Unused amounts reversed during the period"]
[null,"TOPEX0308C","Opex component",null,0]
[null,"TOPEX0309C","Capex component",null,0]
[null,"TOPEX0310C","Other component",null,0]
[null,null,"The increase during the period in the discounted amount arising from the passage of time and the effect of any change in the discount rate"]
[null,"TOPEX0311C","Opex component",null,0]
[null,"TOPEX0312C","Capex component",null,0]
[null,"TOPEX0313C","Other component",null,0]
[null,"TOPEX0314C","Closing balance (carrying amount at the end of the period)",null,1123116033.79969]
[null,"TOPEX03D","Provision name"]
[null,null,"Brief description of provision"]
[null,"TOPEX0301D","Opening balance (the carrying amount at the beginning of the period)"]
[null,null,"Additional provisions made in the period, including increases to existing provisions"]
[null,"TOPEX0302D","Opex component"]
[null,"TOPEX0303D","Capex component"]
[null,"TOPEX0304D","Other component"]
[null,null,"Amounts used (that is, incurred and charged against the provision) during the period"]
[null,"TOPEX0305D","Opex component"]
[null,"TOPEX0306D","Capex component"]
[null,"TOPEX0307D","Other component"]
[null,null,"Unused amounts reversed during the period"]
[null,"TOPEX0308D","Opex component"]
[null,"TOPEX0309D","Capex component"]
[null,"TOPEX0310D","Other component"]
[null,null,"The increase during the period in the discounted amount arising from the passage of time and the effect of any change in the discount rate"]
[null,"TOPEX0311D","Opex component"]
[null,"TOPEX0312D","Capex component"]
[null,"TOPEX0313D","Other component"]
[null,"TOPEX0314D","Closing balance (carrying amount at the end of the period)"]
[null,"TOPEX03E","Provision name"]
[null,null,"Brief description of provision"]
[null,"TOPEX0301E","Opening balance (the carrying amount at the beginning of the period)"]
[null,null,"Additional provisions made in the period, including increases to existing provisions"]
[null,"TOPEX0302E","Opex component"]
[null,"TOPEX0303E","Capex component"]
[null,"TOPEX0304E","Other component"]
[null,null,"Amounts used (that is, incurred and charged against the provision) during the period"]
[null,"TOPEX0305E","Opex component"]
[null,"TOPEX0306E","Capex component"]
[null,"TOPEX0307E","Other component"]
[null,null,"Unused amounts reversed during the period"]
[null,"TOPEX0308E","Opex component"]
[null,"TOPEX0309E","Capex component"]
[null,"TOPEX0310E","Other component"]
[null,null,"The increase during the period in the discounted amount arising from the passage of time and the effect of any change in the discount rate"]
[null,"TOPEX0311E","Opex component"]
[null,"TOPEX0312E","Capex component"]
[null,"TOPEX0313E","Other component"]
[null,"TOPEX0314E","Closing balance (carrying amount at the end of the period)"]
[null,"TOPEX03F","Provision name"]
[null,null,"Brief description of provision"]
[null,"TOPEX0301F","Opening balance (the carrying amount at the beginning of the period)"]
[null,null,"Additional provisions made in the period, including increases to existing provisions"]
[null,"TOPEX0302F","Opex component"]
[null,"TOPEX0303F","Capex component"]
[null,"TOPEX0304F","Other component"]
[null,null,"Amounts used (that is, incurred and charged against the provision) during the period"]
[null,"TOPEX0305F","Opex component"]
[null,"TOPEX0306F","Capex component"]
[null,"TOPEX0307F","Other component"]
[null,null,"Unused amounts reversed during the period"]
[null,"TOPEX0308F","Opex component"]
[null,"TOPEX0309F","Capex component"]
[null,"TOPEX0310F","Other component"]
[null,null,"The increase during the period in the discounted amount arising from the passage of time and the effect of any change in the discount rate"]
[null,"TOPEX0311F","Opex component"]
[null,"TOPEX0312F","Capex component"]
[null,"TOPEX0313F","Other component"]
[null,"TOPEX0314F","Closing balance (carrying amount at the end of the period)"]
[null,"TOPEX03G","Provision name"]
[null,null,"Brief description of provision"]
[null,"TOPEX0301G","Opening balance (the carrying amount at the beginning of the period)"]
[null,null,"Additional provisions made in the period, including increases to existing provisions"]
[null,"TOPEX0302G","Opex component"]
[null,"TOPEX0303G","Capex component"]
[null,"TOPEX0304G","Other component"]
[null,null,"Amounts used (that is, incurred and charged against the provision) during the period"]
[null,"TOPEX0305G","Opex component"]
[null,"TOPEX0306G","Capex component"]
[null,"TOPEX0307G","Other component"]
[null,null,"Unused amounts reversed during the period"]
[null,"TOPEX0308G","Opex component"]
[null,"TOPEX0309G","Capex component"]
[null,"TOPEX0310G","Other component"]
[null,null,"The increase during the period in the discounted amount arising from the passage of time and the effect of any change in the discount rate"]
[null,"TOPEX0311G","Opex component"]
[null,"TOPEX0312G","Capex component"]
[null,"TOPEX0313G","Other component"]
[null,"TOPEX0314G","Closing balance (carrying amount at the end of the period)"]
[null,"TOPEX03H","Provision name"]
[null,null,"Brief description of provision"]
[null,"TOPEX0301H","Opening balance (the carrying amount at the beginning of the period)"]
[null,null,"Additional provisions made in the period, including increases to existing provisions"]
[null,"TOPEX0302H","Opex component"]
[null,"TOPEX0303H","Capex component"]
[null,"TOPEX0304H","Other component"]
[null,null,"Amounts used (that is, incurred and charged against the provision) during the period"]
[null,"TOPEX0305H","Opex component"]
[null,"TOPEX0306H","Capex component"]
[null,"TOPEX0307H","Other component"]
[null,null,"Unused amounts reversed during the period"]
[null,"TOPEX0308H","Opex component"]
[null,"TOPEX0309H","Capex component"]
[null,"TOPEX0310H","Other component"]
[null,null,"The increase during the period in the discounted amount arising from the passage of time and the effect of any change in the discount rate"]
[null,"TOPEX0311H","Opex component"]
[null,"TOPEX0312H","Capex component"]
[null,"TOPEX0313H","Other component"]
[null,"TOPEX0314H","Closing balance (carrying amount at the end of the period)"]
[null,"TOPEX03I","Provision name"]
[null,null,"Brief description of provision"]
[null,"TOPEX0301I","Opening balance (the carrying amount at the beginning of the period)"]
[null,null,"Additional provisions made in the period, including increases to existing provisions"]
[null,"TOPEX0302I","Opex component"]
[null,"TOPEX0303I","Capex component"]
[null,"TOPEX0304I","Other component"]
[null,null,"Amounts used (that is, incurred and charged against the provision) during the period"]
[null,"TOPEX0305I","Opex component"]
[null,"TOPEX0306I","Capex component"]
[null,"TOPEX0307I","Other component"]
[null,null,"Unused amounts reversed during the period"]
[null,"TOPEX0308I","Opex component"]
[null,"TOPEX0309I","Capex component"]
[null,"TOPEX0310I","Other component"]
[null,null,"The increase during the period in the discounted amount arising from the passage of time and the effect of any change in the discount rate"]
[null,"TOPEX0311I","Opex component"]
[null,"TOPEX0312I","Capex component"]
[null,"TOPEX0313I","Other component"]
[null,"TOPEX0314I","Closing balance (carrying amount at the end of the period)"]
[null,"TOPEX03J","Provision name"]
[null,null,"Brief description of provision"]
[null,"TOPEX0301J","Opening balance (the carrying amount at the beginning of the period)"]
[null,null,"Additional provisions made in the period, including increases to existing provisions"]
[null,"TOPEX0302J","Opex component"]
[null,"TOPEX0303J","Capex component"]
[null,"TOPEX0304J","Other component"]
[null,null,"Amounts used (that is, incurred and charged against the provision) during the period"]
[null,"TOPEX0305J","Opex component"]
[null,"TOPEX0306J","Capex component"]
[null,"TOPEX0307J","Other component"]
[null,null,"Unused amounts reversed during the period"]
[null,"TOPEX0308J","Opex component"]
[null,"TOPEX0309J","Capex component"]
[null,"TOPEX0310J","Other component"]
[null,null,"The increase during the period in the discounted amount arising from the passage of time and the effect of any change in the discount rate"]
[null,"TOPEX0311J","Opex component"]
[null,"TOPEX0312J","Capex component"]
[null,"TOPEX0313J","Other component"]
[null,"TOPEX0314J","Closing balance (carrying amount at the end of the period)"]
[null,"TOPEX03K","Provision name"]
[null,null,"Brief description of provision"]
[null,"TOPEX0301K","Opening balance (the carrying amount at the beginning of the period)"]
[null,null,"Additional provisions made in the period, including increases to existing provisions"]
[null,"TOPEX0302K","Opex component"]
[null,"TOPEX0303K","Capex component"]
[null,"TOPEX0304K","Other component"]
[null,null,"Amounts used (that is, incurred and charged against the provision) during the period"]
[null,"TOPEX0305K","Opex component"]
[null,"TOPEX0306K","Capex component"]
[null,"TOPEX0307K","Other component"]
[null,null,"Unused amounts reversed during the period"]
[null,"TOPEX0308K","Opex component"]
[null,"TOPEX0309K","Capex component"]
[null,"TOPEX0310K","Other component"]
[null,null,"The increase during the period in the discounted amount arising from the passage of time and the effect of any change in the discount rate"]
[null,"TOPEX0311K","Opex component"]
[null,"TOPEX0312K","Capex component"]
[null,"TOPEX0313K","Other component"]
[null,"TOPEX0314K","Closing balance (carrying amount at the end of the period)"]
[null,"TOPEX03L","Provision name"]
[null,null,"Brief description of provision"]
[null,"TOPEX0301L","Opening balance (the carrying amount at the beginning of the period)"]
[null,null,"Additional provisions made in the period, including increases to existing provisions"]
[null,"TOPEX0302L","Opex component"]
[null,"TOPEX0303L","Capex component"]
[null,"TOPEX0304L","Other component"]
[null,null,"Amounts used (that is, incurred and charged against the provision) during the period"]
[null,"TOPEX0305L","Opex component"]
[null,"TOPEX0306L","Capex component"]
[null,"TOPEX0307L","Other component"]
[null,null,"Unused amounts reversed during the period"]
[null,"TOPEX0308L","Opex component"]
[null,"TOPEX0309L","Capex component"]
[null,"TOPEX0310L","Other component"]
[null,null,"The increase during the period in the discounted amount arising from the passage of time and the effect of any change in the discount rate"]
[null,"TOPEX0311L","Opex component"]
[null,"TOPEX0312L","Capex component"]
[null,"TOPEX0313L","Other component"]
[null,"TOPEX0314L","Closing balance (carrying amount at the end of the period)"]
[null,"TOPEX03M","Provision name"]
[null,null,"Brief description of provision"]
[null,"TOPEX0301M","Opening balance (the carrying amount at the beginning of the period)"]
[null,null,"Additional provisions made in the period, including increases to existing provisions"]
[null,"TOPEX0302M","Opex component"]
[null,"TOPEX0303M","Capex component"]
[null,"TOPEX0304M","Other component"]
[null,null,"Amounts used (that is, incurred and charged against the provision) during the period"]
[null,"TOPEX0305M","Opex component"]
[null,"TOPEX0306M","Capex component"]
[null,"TOPEX0307M","Other component"]
[null,null,"Unused amounts reversed during the period"]
[null,"TOPEX0308M","Opex component"]
[null,"TOPEX0309M","Capex component"]
[null,"TOPEX0310M","Other component"]
[null,null,"The increase during the period in the discounted amount arising from the passage of time and the effect of any change in the discount rate"]
[null,"TOPEX0311M","Opex component"]
[null,"TOPEX0312M","Capex component"]
[null,"TOPEX0313M","Other component"]
[null,"TOPEX0314M","Closing balance (carrying amount at the end of the period)"]
[null,"TOPEX03N","Provision name"]
[null,null,"Brief description of provision"]
[null,"TOPEX0301N","Opening balance (the carrying amount at the beginning of the period)"]
[null,null,"Additional provisions made in the period, including increases to existing provisions"]
[null,"TOPEX0302N","Opex component"]
[null,"TOPEX0303N","Capex component"]
[null,"TOPEX0304N","Other component"]
[null,null,"Amounts used (that is, incurred and charged against the provision) during the period"]
[null,"TOPEX0305N","Opex component"]
[null,"TOPEX0306N","Capex component"]
[null,"TOPEX0307N","Other component"]
[null,null,"Unused amounts reversed during the period"]
[null,"TOPEX0308N","Opex component"]
[null,"TOPEX0309N","Capex component"]
[null,"TOPEX0310N","Other component"]
[null,null,"The increase during the period in the discounted amount arising from the passage of time and the effect of any change in the discount rate"]
[null,"TOPEX0311N","Opex component"]
[null,"TOPEX0312N","Capex component"]
[null,"TOPEX0313N","Other component"]
[null,"TOPEX0314N","Closing balance (carrying amount at the end of the period)"]
[null,"TOPEX03O","Provision name"]
[null,null,"Brief description of provision"]
[null,"TOPEX0301O","Opening balance (the carrying amount at the beginning of the period)"]
[null,null,"Additional provisions made in the period, including increases to existing provisions"]
[null,"TOPEX0302O","Opex component"]
[null,"TOPEX0303O","Capex component"]
[null,"TOPEX0304O","Other component"]
[null,null,"Amounts used (that is, incurred and charged against the provision) during the period"]
[null,"TOPEX0305O","Opex component"]
[null,"TOPEX0306O","Capex component"]
[null,"TOPEX0307O","Other component"]
[null,null,"Unused amounts reversed during the period"]
[null,"TOPEX0308O","Opex component"]
[null,"TOPEX0309O","Capex component"]
[null,"TOPEX0310O","Other component"]
[null,null,"The increase during the period in the discounted amount arising from the passage of time and the effect of any change in the discount rate"]
[null,"TOPEX0311O","Opex component"]
[null,"TOPEX0312O","Capex component"]
[null,"TOPEX0313O","Other component"]
[null,"TOPEX0314O","Closing balance (carrying amount at the end of the period)"]
[null,"TOPEX03P","Provision name"]
[null,null,"Brief description of provision"]
[null,"TOPEX0301P","Opening balance (the carrying amount at the beginning of the period)"]
[null,null,"Additional provisions made in the period, including increases to existing provisions"]
[null,"TOPEX0302P","Opex component"]
[null,"TOPEX0303P","Capex component"]
[null,"TOPEX0304P","Other component"]
[null,null,"Amounts used (that is, incurred and charged against the provision) during the period"]
[null,"TOPEX0305P","Opex component"]
[null,"TOPEX0306P","Capex component"]
[null,"TOPEX0307P","Other component"]
[null,null,"Unused amounts reversed during the period"]
[null,"TOPEX0308P","Opex component"]
[null,"TOPEX0309P","Capex component"]
[null,"TOPEX0310P","Other component"]
[null,null,"The increase during the period in the discounted amount arising from the passage of time and the effect of any change in the discount rate"]
[null,"TOPEX0311P","Opex component"]
[null,"TOPEX0312P","Capex component"]
[null,"TOPEX0313P","Other component"]
[null,"TOPEX0314P","Closing balance (carrying amount at the end of the period)"]
[null,"TOPEX03Q","Provision name"]
[null,null,"Brief description of provision"]
[null,"TOPEX0301Q","Opening balance (the carrying amount at the beginning of the period)"]
[null,null,"Additional provisions made in the period, including increases to existing provisions"]
[null,"TOPEX0302Q","Opex component"]
[null,"TOPEX0303Q","Capex component"]
[null,"TOPEX0304Q","Other component"]
[null,null,"Amounts used (that is, incurred and charged against the provision) during the period"]
[null,"TOPEX0305Q","Opex component"]
[null,"TOPEX0306Q","Capex component"]
[null,"TOPEX0307Q","Other component"]
[null,null,"Unused amounts reversed during the period"]
[null,"TOPEX0308Q","Opex component"]
[null,"TOPEX0309Q","Capex component"]
[null,"TOPEX0310Q","Other component"]
[null,null,"The increase during the period in the discounted amount arising from the passage of time and the effect of any change in the discount rate"]
[null,"TOPEX0311Q","Opex component"]
[null,"TOPEX0312Q","Capex component"]
[null,"TOPEX0313Q","Other component"]
[null,"TOPEX0314Q","Closing balance (carrying amount at the end of the period)"]
[null,"TOPEX03R","Provision name"]
[null,null,"Brief description of provision"]
[null,"TOPEX0301R","Opening balance (the carrying amount at the beginning of the period)"]
[null,null,"Additional provisions made in the period, including increases to existing provisions"]
[null,"TOPEX0302R","Opex component"]
[null,"TOPEX0303R","Capex component"]
[null,"TOPEX0304R","Other component"]
[null,null,"Amounts used (that is, incurred and charged against the provision) during the period"]
[null,"TOPEX0305R","Opex component"]
[null,"TOPEX0306R","Capex component"]
[null,"TOPEX0307R","Other component"]
[null,null,"Unused amounts reversed during the period"]
[null,"TOPEX0308R","Opex component"]
[null,"TOPEX0309R","Capex component"]
[null,"TOPEX0310R","Other component"]
[null,null,"The increase during the period in the discounted amount arising from the passage of time and the effect of any change in the discount rate"]
[null,"TOPEX0311R","Opex component"]
[null,"TOPEX0312R","Capex component"]
[null,"TOPEX0313R","Other component"]
[null,"TOPEX0314R","Closing balance (carrying amount at the end of the period)"]

{"sheet":"3.3 Assets (RAB)","index":5,"n_rows":94,"n_cols":5,"rows_kept":94,"cut":false,"hidden":false,"merged":[]}
[null,null,"REGULATORY REPORTING STATEMENT"]
[null,null,{"$f":"dms_TradingName","v":"Australian Transmission Co."}]
[null,null,{"$f":"CONCATENATE(\"Benchmarking RIN response \",CRY)","v":"Benchmarking RIN response 2014-15"}]
[null,null,"3.3 ASSETS"]
[]
[]
[null,null,null,null,"Actual\n($0's)"]
[null,null,null,null,{"$f":"CRY","v":"2014-15"}]
[]
[null,null,"TABLE 3.3.1 - REGULATORY ASSET BASE VALUES"]
[null,null,"For total asset base:"]
["ET_RAB3310_00001","TRAB0101","Opening value",null,6569026126.26085]
["ET_RAB3310_00002","TRAB0102","Inflation addition",null,87368047.479269296]
["ET_RAB3310_00003","TRAB0103","Straight line depreciation",null,-261726286.52177399]
["ET_RAB3310_00004","TRAB0104","Regulatory depreciation",null,{"$f":"SUM(E14+E13)","v":-174358239.0425047}]
["ET_RAB3310_00005","TRAB0105","Actual additions (recognised in RAB)",null,245700209.10001501]
["ET_RAB3310_00006","TRAB0106","Disposals ",null,-1367869.34299888]
["ET_RAB3310_00007","TRAB0107","Closing value ","$0's",{"$f":"SUM(E12+E13+E14+E16+E17)","v":6639000226.9753609}]
[]
[]
[null,null,"TABLE 3.3.2 - ASSET VALUE ROLL FORWARD"]
[null,null,"For overhead transmission assets:"]
["ET_RAB3321_00001","TRAB0201","Opening value",null,3393401069.7621198]
["ET_RAB3321_00002","TRAB0202","Inflation addition",null,45132234.227836102]
["ET_RAB3321_00003","TRAB0203","Straight line depreciation",null,-111435995.21522]
["ET_RAB3321_00004","TRAB0204","Regulatory depreciation",null,{"$f":"SUM(E25+E24)","v":-66303760.987383902}]
["ET_RAB3321_00005","TRAB0205","Actual additions (recognised in RAB)",null,34536352.483722404]
["ET_RAB3321_00006","TRAB0206","Disposals ",null,0]
["ET_RAB3321_00007","TRAB0207","Closing value ","$0's",{"$f":"SUM(E23+E24+E25+E27+E28)","v":3361633661.2584581}]
[null,null,"For underground transmission assets:"]
["ET_RAB3322_00001","TRAB0301","Opening value",null,48708714.551022202]
["ET_RAB3322_00002","TRAB0302","Inflation addition",null,647825.90352859604]
["ET_RAB3322_00003","TRAB0303","Straight line depreciation",null,-2041967.0516091899]
["ET_RAB3322_00004","TRAB0304","Regulatory depreciation",null,{"$f":"SUM(E33+E32)","v":-1394141.1480805939}]
["ET_RAB3322_00005","TRAB0305","Actual additions (recognised in RAB)",null,0]
["ET_RAB3322_00006","TRAB0306","Disposals ",null,0]
["ET_RAB3322_00007","TRAB0307","Closing value ","$0's",{"$f":"SUM(E31+E32+E33+E35+E36)","v":47314573.402941607}]
[null,null,"For transmission switchyards, substations"]
["ET_RAB3323_00001","TRAB0401","Opening value",null,2422218684.4793501]
["ET_RAB3323_00002","TRAB0402","Inflation addition",null,32221309.033655498]
["ET_RAB3323_00003","TRAB0403","Straight line depreciation",null,-112832328.371066]
["ET_RAB3323_00004","TRAB0404","Regulatory depreciation",null,{"$f":"SUM(E41+E40)","v":-80611019.33741051}]
["ET_RAB3323_00005","TRAB0405","Actual additions (recognised in RAB)",null,161063006.878355]
["ET_RAB3323_00006","TRAB0406","Disposals ",null,0]
["ET_RAB3323_00007","TRAB0407","Closing value ","$0's",{"$f":"SUM(E39+E40+E41+E43+E44)","v":2502670672.0202947}]
[null,null,"For easements:"]
["ET_RAB3324_00001","TRAB0501","Opening value",null,418601904.89205199]
["ET_RAB3324_00002","TRAB0502","Inflation addition",null,5521685.4473858103]
["ET_RAB3324_00003","TRAB0503","Straight line depreciation",null,0]
["ET_RAB3324_00004","TRAB0504","Regulatory depreciation",null,{"$f":"SUM(E49+E48)","v":5521685.4473858103}]
["ET_RAB3324_00005","TRAB0505","Actual additions (recognised in RAB)",null,3599895.2903481298]
["ET_RAB3324_00006","TRAB0506","Disposals ",null,-470768.68095192302]
["ET_RAB3324_00007","TRAB0507","Closing value ","$0's",{"$f":"SUM(E47+E48+E49+E51+E52)","v":427252716.948834}]
[null,null,"For “other” assets with long lives:"]
["ET_RAB3325_00001","TRAB0601","Opening value",null,215894244.41831499]
["ET_RAB3325_00002","TRAB0602","Inflation addition",null,2911312.8083619801]
["ET_RAB3325_00003","TRAB0603","Straight line depreciation",null,-13161046.585741401]
["ET_RAB3325_00004","TRAB0604","Regulatory depreciation",null,{"$f":"SUM(E57+E56)","v":-10249733.77737942}]
["ET_RAB3325_00005","TRAB0605","Actual additions (recognised in RAB)",null,37464601.3109084]
["ET_RAB3325_00006","TRAB0606","Disposals ",null,-78896.131561993097]
["ET_RAB3325_00007","TRAB0607","Closing value ","$0's",{"$f":"SUM(E55+E56+E57+E59+E60)","v":243030215.82028198}]
[null,null,"For “other” assets with short lives:"]
["ET_RAB3326_00001","TRAB0701","Opening value",null,70201508.157987803]
["ET_RAB3326_00002","TRAB0702","Inflation addition",null,933680.05850123696]
["ET_RAB3326_00003","TRAB0703","Straight line depreciation",null,-22254949.298137199]
["ET_RAB3326_00004","TRAB0704","Regulatory depreciation",null,{"$f":"SUM(E65+E64)","v":-21321269.239635963}]
["ET_RAB3326_00005","TRAB0705","Actual additions (recognised in RAB)",null,9036353.1366808005]
["ET_RAB3326_00006","TRAB0706","Disposals ",null,-818204.53048495902]
["ET_RAB3326_00007","TRAB0707","Closing value ","$0's",{"$f":"SUM(E63+E64+E65+E67+E68)","v":57098387.524547681}]
[]
[]
[null,null,"TABLE 3.3.3 - TOTAL DISAGGREGATED RAB ASSET VALUES"]
["ET_RAB3330_00001","TRAB0801","Overhead transmission assets (wires and towers/poles etc)",null,3377517365.5102901]
["ET_RAB3330_00002","TRAB0802","Underground transmission assets (cables, ducts etc)",null,48011643.976981901]
["ET_RAB3330_00003","TRAB0803","Substations, switchyards, Transformers etc with transmission function",null,2462444678.2498298]
["ET_RAB3330_00004","TRAB0804","Easements",null,422927310.920443]
["ET_RAB3330_00005","TRAB0805","Other assets with long lives (please specify)",null,229462230.11929899]
["ET_RAB3330_00006","TRAB0806","Other assets with short lives (please specify)","$0's",63649947.841267698]
[]
[]
[null,null,"TABLE 3.3.4 - ASSET LIVES",null,"Service Life \n(Years)"]
[null,null,"3.3.4.1 Asset Lives – estimated service life of new assets",null,{"$f":"CRY","v":"2014-15"}]
["ET_RAB3341_00001","TRAB0901","Overhead transmission assets ",null,49.676998364986524]
["ET_RAB3341_00002","TRAB0902","Underground transmission assets",null,45]
["ET_RAB3341_00003","TRAB0903","Switchyard, substation and transformer assets",null,34.874765150071568]
["ET_RAB3341_00004","TRAB0904","“Other” assets with long lives",null,28.575100371026846]
["ET_RAB3341_00005","TRAB0905","“Other assets with short lives",null,5.6582203053284426]
[]
[null,null,"3.3.4.2 Asset Lives – estimated residual service life"]
["ET_RAB3342_00001","TRAB1001","Overhead transmission assets ",null,23.12377025160129]
["ET_RAB3342_00002","TRAB1002","Underground transmission assets",null,25.327331486611268]
["ET_RAB3342_00003","TRAB1003","Switchyard, substation and transformer assets",null,21.065400843881857]
["ET_RAB3342_00004","TRAB1004","Other assets with long lives",null,22.387886011119537]
["ET_RAB3342_00005","TRAB1005","Other assets with short lives",null,3.6845587063594971]

{"sheet":"3.4 Operational data","index":6,"n_rows":89,"n_cols":5,"rows_kept":89,"cut":false,"hidden":false,"merged":[]}
[null,null,"REGULATORY REPORTING STATEMENT"]
[null,null,{"$f":"dms_TradingName","v":"Australian Transmission Co."}]
[null,null,{"$f":"CONCATENATE(\"Benchmarking RIN response \",CRY)","v":"Benchmarking RIN response 2014-15"}]
[null,null,"3.4 OPERATIONAL DATA"]
[]
[]
[]
[null,null,null,null,"Actual"]
[null,null,null,null,{"$f":"CRY","v":"2014-15"}]
[null,null,null,"Units"]
[null,null,"TABLE 3.4.1 - ENERGY DELIVERY"]
[null,null,"Energy Grouping by Downstream Connection type"]
["ET_OPD3410_00001","TOPED0101","To Other connected transmission networks","GWh",6105.3519999999999]
["ET_OPD3410_00002","TOPED0102","To Distribution networks","GWh",33652.159325000044]
["ET_OPD3410_00004","TOPED0103","To Directly connected end–users (330 kV)","GWh",0]
["ET_OPD3410_00005","TOPED0104","To Directly connected end–users (275 kV)","GWh",6091.4769999999999]
["ET_OPD3410_00006","TOPED0105","To Directly connected end–users (220 kV)","GWh",0]
["ET_OPD3410_00007","TOPED0106","To Directly connected end–users (132 kV)","GWh",7039.8159999999998]
["ET_OPD3410_00008","TOPED0107","To Directly connected end–users (110 kV)","GWh",0]
["ET_OPD3410_00009","TOPED0108","To Directly connected end–users (44 kV) ","GWh",0]
["ET_OPD3410_00010","TOPED0109","To Directly connected end–users (33 kV)","GWh",0]
["ET_OPD3410_00011","TOPED0110","To Directly connected end–users (22 kV)","GWh",0]
["ET_OPD3410_00012","TOPED0111","To Directly connected end–users (11 kV)","GWh",0]
["ET_OPD3410_00013","TOPED0112","To Directly connected end–users (6.6 kV)","GWh",0]
["ET_OPD3410_00014","TOPED0113","Pumping and Power Station Auxillaries","GWh",198.75909999999999]
[null,"TOPED01","Total energy transported","GWh",{"$f":"SUM(E13:E25)","v":53087.563425000044}]
[]
[]
[null,null,"TABLE 3.4.2 -  CONNECTION POINTS"]
[null,null,"Number of entry points at each transmission voltage level"]
["ET_OPD3421_00001","TOPCP0101","500kV","number",0]
["ET_OPD3421_00002","TOPCP0102","330kV","number",1]
["ET_OPD3421_00003","TOPCP0103","275kV","number",12.5]
["ET_OPD3421_00004","TOPCP0104","220kV","number",0]
["ET_OPD3421_00005","TOPCP0105","132 kV","number",10.5]
["ET_OPD3421_00006","TOPCP0106","110kV","number",1]
["ET_OPD3421_00007","TOPCP0107","66 kV","number",0]
["ET_OPD3421_00008","TOPCP0108","33 kV","number",0]
["ET_OPD3421_00009","TOPCP0109","22 kV","number",0]
["ET_OPD3421_00010","TOPCP0110","11 kV","number",0]
["ET_OPD3421_00010","TOPCP0111","6.6 kV","number",0]
[]
[null,null,"Number of exit points at each transmission voltage level "]
["ET_OPD3422_00001","TOPCP0201","500kV","number",0]
["ET_OPD3422_00002","TOPCP0202","330kV","number",1]
["ET_OPD3422_00003","TOPCP0203","275kV","number",3.5]
["ET_OPD3422_00004","TOPCP0204","220kV","number",0]
["ET_OPD3422_00005","TOPCP0205","132 kV","number",49.5]
["ET_OPD3422_00006","TOPCP0206","110kV","number",17.5]
["ET_OPD3422_00007","TOPCP0207","66 kV","number",22.5]
["ET_OPD3422_00008","TOPCP0208","44 kV","number",0]
["ET_OPD3422_00009","TOPCP0209","33kV","number",14]
["ET_OPD3422_00010","TOPCP0210","22kV","number",7]
["ET_OPD3422_00011","TOPCP0211","11kV","number",4]
["ET_OPD3422_00012","TOPCP0212","6.6kV","number",0]
[]
[]
[null,null,"TABLE 3.4.3 - SYSTEM DEMAND"]
[null,null,"Table 3.4.3.1 Annual system maximum demand characteristics – MW measure"]
["ET_OPD3431_00001","TOPSD0101","Transmission System coincident maximum demand","MW",8105.0587999999998]
["ET_OPD3431_00002","TOPSD0102","Transmission System coincident weather adjusted maximum demand 10% POE","MW",8407.76]
["ET_OPD3431_00003","TOPSD0103","Transmission System coincident weather adjusted maximum demand 50% POE","MW",7863.1350000000002]
["ET_OPD3431_00004","TOPSD0104","Transmission System non-coincident summated maximum demand","MW",11413.174000000001]
["ET_OPD3431_00005","TOPSD0105","Transmission System non-coincident weather adjusted summated maximum demand 10% POE","MW",11862.593000000001]
["ET_OPD3431_00006","TOPSD0106","Transmission System non-coincident weather adjusted summated maximum demand 50% POE","MW",11194.901]
[]
[null,null,"Table 3.4.3.2 Annual system maximum demand characteristics – MVA measure"]
["ET_OPD3432_00001","TOPSD0201","Transmission System coincident maximum demand","MVA",8628.2898699999987]
["ET_OPD3432_00002","TOPSD0202","Transmission System coincident weather adjusted maximum demand 10% POE","MVA",8940.5589999999993]
["ET_OPD3432_00003","TOPSD0203","Transmission System coincident weather adjusted maximum demand 50% POE","MVA",8378.7199999999993]
["ET_OPD3432_00004","TOPSD0204","Transmission System non-coincident summated maximum demand","MVA",11832.312]
["ET_OPD3432_00005","TOPSD0205","Transmission System non-coincident weather adjusted summated maximum demand 10% POE","MVA",12273.817999999999]
["ET_OPD3432_00006","TOPSD0206","Transmission System non-coincident weather adjusted summated maximum demand 50% POE","MVA",11589.096]
[]
[null,null,"Table 3.4.3.3 Power factor"]
[null,null,"Power factor conversion between MVA and MW"]
["ET_OPD3433_00001","TOPSD0301","Average overall network power factor conversion between MVA and MW","Factor",0.99099999999999999]
["ET_OPD3433_00002","TOPSD0302","Average power factor conversion for 500 kV lines","Factor",0]
["ET_OPD3433_00003","TOPSD0303","Average power factor conversion for 330 kV lines","Factor",0.95899999999999996]
["ET_OPD3433_00004","TOPSD0304","Average power factor conversion for  275 kV lines","Factor",0.95499999999999996]
["ET_OPD3433_00005","TOPSD0305","Average power factor conversion for  220 kV lines","Factor",0]
["ET_OPD3433_00006","TOPSD0306","Average power factor conversion for  132 kV lines","Factor",0.99999000000000005]
["ET_OPD3433_00007","TOPSD0307","Average power factor conversion for  110 kV lines","Factor",0.98599999999999999]
["ET_OPD3433_00008","TOPSD0308","Average power factor conversion for  88 kV lines","Factor",0]
["ET_OPD3433_00009","TOPSD0309","Average power factor conversion for  66 kV lines","Factor",0.96199999999999997]
["ET_OPD3433_00010","TOPSD0310","Average power factor conversion for  33 kV lines","Factor",0.998]
["ET_OPD3433_00011","TOPSD0311","Average power factor conversion for  22 kV lines","Factor",0.998]
["ET_OPD3433_00011","TOPSD0311","Average power factor conversion for  11 kV lines","Factor",0.97299999999999998]
[null,"TOPSD0312","Average power factor conversion for  6.6 kV lines","Factor",0]

{"sheet":"3.5 Physical assets","index":7,"n_rows":74,"n_cols":5,"rows_kept":74,"cut":false,"hidden":false,"merged":[]}
[null,null,"REGULATORY REPORTING STATEMENT"]
[null,null,{"$f":"dms_TradingName","v":"Australian Transmission Co."}]
[null,null,{"$f":"CONCATENATE(\"Benchmarking RIN response \",CRY)","v":"Benchmarking RIN response 2014-15"}]
[null,null,"3.5 PHYSICAL ASSETS"]
[]
[]
[null,null,null,null,"Actual"]
[null,null,null,null,{"$f":"CRY","v":"2014-15"}]
[null,null,null,"Unit"]
[null,null,"TABLE 3.5.1 - TRANSMISSION SYSTEM CAPACITIES "]
[null,null,"Table 3.5.1.1 Overhead network length of circuit at each voltage"]
["ET_PHA3511_00001","TPA0101","500 kV","km",0]
["ET_PHA3511_00002","TPA0102","330 kV","km",604]
["ET_PHA3511_00003","TPA0103","275 kV","km",9367]
["ET_PHA3511_00004","TPA0104","220 kV","km",0]
["ET_PHA3511_00005","TPA0105","132 kV","km",4368]
["ET_PHA3511_00006","TPA0106","110 kV","km",393]
["ET_PHA3511_00007","TPA0107","88 kV","km",0]
["ET_PHA3511_00008","TPA0108","66 kV","km",1]
["ET_PHA3511_00009","TPA0109","33 kV","km",0]
["ET_PHA3511_00009","TPA0109","22 kV","km",0]
["ET_PHA3511_00009","TPA0109","11 kV","km",0]
[null,"TPA01","Total overhead circuit kilometres","km",{"$f":"SUM(E12:E22)","v":14733}]
[]
[null,null,"Table 3.5.1.2 Underground cable circuit length at each voltage"]
["ET_PHA3512_00001","TPA0201","500 kV","km",0]
["ET_PHA3512_00002","TPA0202","330 kV","km",0]
["ET_PHA3512_00003","TPA0203","275 kV","km",9.4]
["ET_PHA3512_00004","TPA0204","220 kV","km",0]
["ET_PHA3512_00005","TPA0205","132 kV","km",3.2]
["ET_PHA3512_00006","TPA0206","110 kV","km",7.6]
["ET_PHA3511_00007","TPA0207","88 kV","km",0]
["ET_PHA3512_00007","TPA0208","66 kV","km",1.3]
["ET_PHA3512_00008","TPA0209","33 kV","km",0]
["ET_PHA3512_00007","TPA0210","22 kV","km",0]
["ET_PHA3512_00008","TPA0211","11 kV","km",0]
[null,"TPA02","Total underground circuit kilometres","km",{"$f":"SUM(E26:E36)","v":21.500000000000004}]
[]
[null,"TPA0301","Table 3.5.1.3 Estimated overhead network weighted average MVA capacity by voltage class"]
["ET_PHA3513_00001","TPA0302","500 kV","MVA",0]
["ET_PHA3513_00002","TPA0303","330 kV","MVA",1237.5]
["ET_PHA3513_00003","TPA0304","275 kV","MVA",837.9]
["ET_PHA3513_00004","TPA0305","220 kV","MVA",0]
["ET_PHA3513_00005","TPA0306","132 kV","MVA",139.6]
["ET_PHA3513_00006","TPA0307","110 kV","MVA",158.80000000000001]
["ET_PHA3513_00007","TPA0308","88 kV","MVA",0]
["ET_PHA3513_00008","TPA0309","66 kV","MVA",57]
["ET_PHA3513_00009","TPA0310","33 kV","MVA",0]
["ET_PHA3513_00008","TPA0311","22 kV","MVA",0]
["ET_PHA3513_00009","TPA0312","11 kV","MVA",0]
[]
[null,null,"Table 3.5.1.4 Estimated underground network weighted average MVA capacity by voltage class"]
["ET_PHA3514_00001","TPA0401","500 kV","MVA",0]
["ET_PHA3514_00002","TPA0402","330 kV","MVA",0]
["ET_PHA3514_00003","TPA0403","275 kV","MVA",568.9]
["ET_PHA3514_00004","TPA0404","220 kV","MVA",0]
["ET_PHA3514_00005","TPA0405","132 kV","MVA",207.9]
["ET_PHA3514_00006","TPA0406","110 kV","MVA",200.8]
["ET_PHA3514_00007","TPA0407","88 kV","MVA",0]
["ET_PHA3514_00006","TPA0408","66 kV","MVA",57]
["ET_PHA3514_00007","TPA0409","33 kV","MVA",0]
["ET_PHA3514_00008","TPA0410","22 kV","MVA",0]
[null,"TPA0411","11 kV",null,0]
[]
[null,null,"Table 3.5.1.5 Installed transmission system transformer capacity"]
["ET_PHA3515_00001","TPA0501","Transmission substations (eg 500 kV to 330 kV)","MVA",9929]
["ET_PHA3515_00002","TPA0502","Terminal points to DNSP systems","MVA",23477]
["ET_PHA3515_00003","TPA0503","Transformer capacity for directly connected end–users owned by the TNSP","MVA",2197]
["ET_PHA3515_00004","TPA0504","Transformer capacity for directly connected end–users owned by the end–user","MVA",3393]
["ET_PHA3515_00005","TPA0505","Interconnector capacity","MVA",0]
["ET_PHA3515_00010","TPA0506","Other","MVA",3097]
[]
[null,null,"Table 3.5.1.6 Cold spare capacity"]
["ET_PHA3516_00001","TPA06","Cold spare capacity included in Table 3.5.1.5","MVA",2975]

{"sheet":"3.6 Quality of services","index":8,"n_rows":60,"n_cols":5,"rows_kept":60,"cut":false,"hidden":false,"merged":[]}
[null,null,"REGULATORY REPORTING STATEMENT"]
[null,null,{"$f":"dms_TradingName","v":"Australian Transmission Co."}]
[null,null,{"$f":"CONCATENATE(\"Benchmarking RIN response \",CRY)","v":"Benchmarking RIN response 2014-15"}]
[null,null,"3.6 QUALITY OF SERVICE DATA"]
[]
[]
[null,null,null,null,"Actual"]
[null,null,null,null,{"$f":"CONCATENATE(\"Calendar Year \", dms_RYE-1)","v":"Calendar Year 2014"}]
[null,null,null,"Unit"]
[null,null,"TABLE 3.6.1 - SERVICE COMPONENT"]
[null,null,"Table 3.6.1.1 Service Parameter 1 – Average Circuit outage rate"]
["ET_QOS3611_00001","TQS0101","Lines outage rate - fault","%",0.19594594594594594]
["ET_QOS3611_00002","TQS0102","Number of Lines fault outages","number",58]
["ET_QOS3611_00003","TQS0103","Number of defined Lines","number",296]
["ET_QOS3611_00004","TQS0104","Transformers outage rate - fault","%",0.19411764705882356]
["ET_QOS3611_00005","TQS0105","Number of Transformer fault outages","number",33]
["ET_QOS3611_00006","TQS0106","Number of defined Transformers","number",170]
["ET_QOS3611_00007","TQS0107","Reactive plant outage rate - fault","%",0.29078014184397161]
["ET_QOS3611_00008","TQS0108","Number of Reactive plant fault outages","number",41]
["ET_QOS3611_00009","TQS0109","Number of defined Reactive plant","number",141]
["ET_QOS3611_00010","TQS0110","Lines outage rate – forced outage","%",0.22297297297297297]
["ET_QOS3611_00011","TQS0111","Number of Lines forced outages","number",66]
["ET_QOS3611_00012","TQS0112","Transformer outage rate – forced outage","%",18.823529411764699]
["ET_QOS3611_00013","TQS0113","Number of Transformers forced outages","number",32]
["ET_QOS3611_00014","TQS0114","Reactive plant outage rate – forced outage","%",0.31914893617021278]
["ET_QOS3611_00015","TQS0115","Number of Reactive plant forced outages","number",45]
[]
[null,null,"Table 3.6.1.2 Service Parameter 2 – Loss of supply event frequency – number in ranges specified"]
["ET_QOS3612_00001","TQS0116","Number of events greater than 0.05 system minutes per annum (X)","number"]
["ET_QOS3612_00002","TQS0117","Number of events greater than 0.1 system minutes per annum (X)","number",3]
["ET_QOS3612_00003","TQS0118","Number of events greater than 0.2 system minutes per annum (X)","number"]
["ET_QOS3612_00004","TQS0119","Number of events greater than 0.25 system minutes per annum (X)","number"]
["ET_QOS3612_00005","TQS0120","Number of events greater than 0.30 system minutes per annum (X)","number"]
["ET_QOS3612_00006","TQS0121","Number of events greater than 0.5 system minutes per annum (X)","number"]
["ET_QOS3612_00007","TQS0122","Number of events greater than 0.75 system minutes per annum (X)","number"]
["ET_QOS3612_00008","TQS0123","Number of events greater than 1.0 system minutes per annum (X)","number"]
["ET_QOS3612_00009","TQS0124","Number of events greater than 0.05 system minutes per annum (Y)","number"]
["ET_QOS3612_00010","TQS0125","Number of events greater than 0.1 system minutes per annum (Y)","number"]
["ET_QOS3612_00011","TQS0126","Number of events greater than 0.2 system minutes per annum (Y)","number"]
["ET_QOS3612_00012","TQS0127","Number of events greater than 0.25 system minutes per annum (Y)","number"]
["ET_QOS3612_00013","TQS0128","Number of events greater than 0.30 system minutes per annum (Y)","number"]
["ET_QOS3612_00014","TQS0129","Number of events greater than 0.5 system minutes per annum (Y)","number"]
["ET_QOS3612_00015","TQS0130","Number of events greater than 0.75 system minutes per annum (Y)","number",0]
["ET_QOS3612_00016","TQS0131","Number of events greater than 1.0 system minutes per annum (Y)","number"]
[]
[null,null,"Table 3.6.1.3 Service Parameter 3 – Average outage duration"]
["ET_QOS3613_00001","TQS0118","Average outage duration ","minutes",115.971]
[]
[null,null,"Table  3.6.1.4 System Parameter 4 – Proper operation of equipment – number of failure events"]
["ET_QOS3614_00001","TQS0119","Failure of protection system","number",16]
["ET_QOS3614_00002","TQS0120","Material failure of Supervisory Control and Data Acquisition (SCADA) system","number",0]
["ET_QOS3614_00003","TQS0121","Incorrect operational isolation of primary or secondary equipment","number",10]
[]
[]
[null,null,"TABLE 3.6.2 - MARKET IMPACT COMPONENT"]
["ET_QOS3620_00001","TQS02","Market Impact Parameter","Number of dispatch intervals",3941]
[]
[]
[null,null,"TABLE 3.6.3 - SYSTEM LOSSES"]
["ET_QOS3630_00001","TQS03","System losses","%",2.8510000000000001E-2]

{"sheet":"3.7 Operating environment","index":9,"n_rows":24,"n_cols":5,"rows_kept":24,"cut":false,"hidden":false,"merged":[[9,2,9,4],[19,2,19,4]]}
[null,null,"REGULATORY REPORTING STATEMENT"]
[null,null,{"$f":"dms_TradingName","v":"Australian Transmission Co."}]
[null,null,{"$f":"CONCATENATE(\"Benchmarking RIN response \",CRY)","v":"Benchmarking RIN response 2014-15"}]
[null,null,"3.7 OPERATING ENVIRONMENT FACTORS"]
[]
[]
[null,null,null,null,"Actual"]
[null,null,null,null,{"$f":"CRY","v":"2014-15"}]
[null,null,null,"Unit"]
[null,"TEF01","TABLE 3.7.1 - TERRAIN FACTORS"]
["ET_OEF3710_00001","TEF0101","Total number of vegetation maintenance spans","Number of spans",10833]
["ET_OEF3710_00002","TEF0102","Average vegetation maintenance span cycle","Years",2.6080000000000001]
["ET_OEF3710_00003","TEF0103","Average number of trees per vegetation maintenance span","Trees",576]
["ET_OEF3710_00004","TEF0104","Average number of defects per vegetation maintenance span","Defects",2.794E-2]
["ET_OEF3710_00005","TEF0105","Tropical proportion","Number of spans",7327]
["ET_OEF3710_00006","TEF0106","Standard vehicle access","km",8019]
["ET_OEF3710_00007","TEF0107","Altitude","km",239.5]
["ET_OEF3710_00008","TEF0108","Bushfire risk","Number of spans",3220]
[]
[null,"TEF02","TABLE 3.7.2 - NETWORK CHARACTERISTICS"]
["ET_OEF3720_00001","TEF0201","Route line length","km",9698]
["ET_OEF3720_00002","TEF0202","Variability of dispatch","%",5.8999999999999997E-2]
["ET_OEF3720_00003","TEF0203","Concentrated load distance","km",565.4]
["ET_OEF3720_00004","TEF0204","Total number of spans","number",24096]

{"sheet":"Unlocked worksheet","index":10,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}