{"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 service","3.7 Operating environment","Unlocked worksheet"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":2,"defined_names":93,"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":"ActewAGL Distribution"}]
[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":[[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],[24,3,24,4],[24,5,24,8],[28,3,28,4],[28,6,28,7],[29,3,29,4],[29,6,29,7],[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]]}
["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":"ActewAGL Distribution"},null,null,null,null,null,null,null,null,"Date last modified:"]
[null,null,{"$f":"CONCATENATE(\"Benchmarking RIN response \",CRY)","v":"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","ActewAGL Distribution"]
[null,null,"ACN / ABN",{"$f":"INDEX(dms_ABN_List,MATCH(dms_TradingName,dms_TradingName_List))","v":76670568688}]
[]
[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,"40 Bunda Street",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,"Canberra",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":"ACT"},"p/code",2601,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,"GPO Box 366",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,"Canberra",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","ACT","p/code",2601]
[]
[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","Robert Walker",null,null,"Stephen Devlin",null,null,null,null,"ActewAGL Distribution",76670568688,"ACT","Electricity","Distribution","Revenue cap",5,6,"ACT"]
[null,null,"Contact phone/s","02 6248 3847",null,null,"02 6293 5850",null,null,null,null,"ActewAGL Distribution (Tx Assets)",76670568688,"ACT","Electricity","Distribution","Revenue cap",5,5,"ACT"]
[null,null,"Contact email address/s","Robert.Walker@actewagl.com.au",null,null,"Stephen.Devlin@actewagl.com.au",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":"Distribution"},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":"Public"},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)","Public"]
[null,null,"EBSS - First application of scheme in forthcoming period?","No"]
[null,null,"Amended RIN submission - amendment reason","20160121 - amended 3.3 Assets RAB"]
["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":6},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":"ACT"},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":43,"n_cols":6,"rows_kept":43,"cut":false,"hidden":false,"merged":[[8,4,8,5]]}
[null,null,"REGULATORY REPORTING STATEMENT"]
[null,null,{"$f":"dms_TradingName","v":"ActewAGL Distribution"}]
[null,null,{"$f":"CONCATENATE(\"Benchmarking RIN response \",CRY)","v":"Benchmarking RIN response 2014-15"}]
[null,null,"3.1 REVENUE"]
[]
[]
[]
[null,null,null,null,"Standard control services","Alternative control services"]
[null,null,null,null,"Actual\n($0's)"]
[null,null,null,null,{"$f":"CRY","v":"2014-15"},{"$f":"CRY","v":"2014-15"}]
[]
[null,null,"TABLE 3.1.1 - REVENUE GROUPING BY CHARGEABLE QUANTITY",null," "]
["ED_REV311_00001","DREV0101","Revenue from Fixed Customer Charges ",null,{"$f":"'[1]3.1 Revenue'!E13+'[2]3.1 Revenue'!E13","v":18011603.350000001},{"$f":"'[1]3.1 Revenue'!F13+'[2]3.1 Revenue'!F13","v":0}]
["ED_REV311_00002","DREV0102","Revenue from Energy Delivery charges where time of use is not a determinant",null,{"$f":"'[1]3.1 Revenue'!E14+'[2]3.1 Revenue'!E14","v":104535207.04783696},{"$f":"'[1]3.1 Revenue'!F14+'[2]3.1 Revenue'!F14","v":0}]
["ED_REV311_00003","DREV0103","Revenue from On–Peak Energy Delivery charges ",null,{"$f":"'[1]3.1 Revenue'!E15+'[2]3.1 Revenue'!E15","v":40581618.840050928},{"$f":"'[1]3.1 Revenue'!F15+'[2]3.1 Revenue'!F15","v":0}]
["ED_REV311_00004","DREV0104","Revenue from Shoulder period Energy Delivery Charges",null,{"$f":"'[1]3.1 Revenue'!E16+'[2]3.1 Revenue'!E16","v":12333719.792216681},{"$f":"'[1]3.1 Revenue'!F16+'[2]3.1 Revenue'!F16","v":0}]
["ED_REV311_00005","DREV0105","Revenue from Off–Peak Energy Delivery charges ",null,{"$f":"'[1]3.1 Revenue'!E17+'[2]3.1 Revenue'!E17","v":15892749.050010903},{"$f":"'[1]3.1 Revenue'!F17+'[2]3.1 Revenue'!F17","v":0}]
["ED_REV311_00006","DREV0106","Revenue from controlled load customer charges",null,{"$f":"'[1]3.1 Revenue'!E18+'[2]3.1 Revenue'!E18","v":2537717.2998845177},{"$f":"'[1]3.1 Revenue'!F18+'[2]3.1 Revenue'!F18","v":0}]
["ED_REV311_00007","DREV0107","Revenue from unmetered supplies",null,{"$f":"'[1]3.1 Revenue'!E19+'[2]3.1 Revenue'!E19","v":170611.25},{"$f":"'[1]3.1 Revenue'!F19+'[2]3.1 Revenue'!F19","v":0}]
["ED_REV311_00008","DREV0108","Revenue from Contracted Maximum Demand charges",null,{"$f":"'[1]3.1 Revenue'!E20+'[2]3.1 Revenue'!E20","v":0},{"$f":"'[1]3.1 Revenue'!F20+'[2]3.1 Revenue'!F20","v":0}]
["ED_REV311_00009","DREV0109","Revenue from Measured Maximum Demand charges",null,{"$f":"'[1]3.1 Revenue'!E21+'[2]3.1 Revenue'!E21","v":51568347.709999986},{"$f":"'[1]3.1 Revenue'!F21+'[2]3.1 Revenue'!F21","v":0}]
["ED_REV311_00010","DREV0110","Revenue from metering charges",null,{"$f":"'[1]3.1 Revenue'!E22+'[2]3.1 Revenue'!E22","v":0},{"$f":"'[1]3.1 Revenue'!F22+'[2]3.1 Revenue'!F22","v":9097555.5800000001}]
["ED_REV311_00011","DREV0111","Revenue from connection charges",null,{"$f":"'[1]3.1 Revenue'!E23+'[2]3.1 Revenue'!E23","v":0},{"$f":"'[1]3.1 Revenue'!F23+'[2]3.1 Revenue'!F23","v":2720614.05}]
["ED_REV311_00012","DREV0112","Revenue from public lighting charges",null,{"$f":"'[1]3.1 Revenue'!E24+'[2]3.1 Revenue'!E24","v":0},{"$f":"'[1]3.1 Revenue'!F24+'[2]3.1 Revenue'!F24","v":0}]
["ED_REV311_00013","DREV0113","Revenue from other Sources",null,{"$f":"'[1]3.1 Revenue'!E25+'[2]3.1 Revenue'!E25","v":35381599.009999998},{"$f":"'[1]3.1 Revenue'!F25+'[2]3.1 Revenue'!F25","v":2319940.98}]
[null,"DREV01","Total revenue by chargeable quantity","$0's",{"$f":"SUM(E13:E25)","v":281013173.34999996},{"$f":"SUM(F13:F25)","v":14138110.609999999}]
[]
[null,null,"TABLE 3.1.2 REVENUE GROUPING BY CUSTOMER TYPE OR CLASS"]
["ED_REV312_00001","DREV0201","Revenue from residential Customers ",null,{"$f":"'[1]3.1 Revenue'!E29+'[2]3.1 Revenue'!E29","v":96417301.329999983},{"$f":"'[1]3.1 Revenue'!F29+'[2]3.1 Revenue'!F29","v":0}]
["ED_REV312_00002","DREV0202","Revenue from Non residential customers not on demand tariffs ",null,{"$f":"'[1]3.1 Revenue'!E30+'[2]3.1 Revenue'!E30","v":49949152.310000002},{"$f":"'[1]3.1 Revenue'!F30+'[2]3.1 Revenue'!F30","v":0}]
["ED_REV312_00003","DREV0203","Revenue from Non-residential low voltage demand tariff customers ",null,{"$f":"'[1]3.1 Revenue'!E31+'[2]3.1 Revenue'!E31","v":76888308.949999988},{"$f":"'[1]3.1 Revenue'!F31+'[2]3.1 Revenue'!F31","v":0}]
["ED_REV312_00004","DREV0204","Revenue from Non-residential high voltage demand tariff customers ",null,{"$f":"'[1]3.1 Revenue'!E32+'[2]3.1 Revenue'!E32","v":22203102.560000002},{"$f":"'[1]3.1 Revenue'!F32+'[2]3.1 Revenue'!F32","v":0}]
["ED_REV312_00005","DREV0205","Revenue from unmetered supplies",null,{"$f":"'[1]3.1 Revenue'!E33+'[2]3.1 Revenue'!E33","v":173709.19},{"$f":"'[1]3.1 Revenue'!F33+'[2]3.1 Revenue'!F33","v":0}]
["ED_REV312_00006","DREV0206","Revenue from Other Customers",null,{"$f":"'[1]3.1 Revenue'!E34+'[2]3.1 Revenue'!E34","v":35381599.009999998},{"$f":"'[1]3.1 Revenue'!F34+'[2]3.1 Revenue'!F34","v":14138110.609999999}]
[null,"DREV02","Total revenue by customer class","$0's",{"$f":"SUM(E29:E34)","v":281013173.34999996},{"$f":"SUM(F29:F34)","v":14138110.609999999}]
[]
[null,null,"TABLE 3.1.3 REVENUE (penalties) ALLOWED (deducted) THROUGH INCENTIVE SCHEMES"]
["ED_REV313_00001","DREV0301","EBSS",null,0,0]
["ED_REV313_00002","DREV0302","STPIS",null,0,0]
["ED_REV313_00003","DREV0303","F-Factor ",null,0,0]
["ED_REV313_00004","DREV0304","S-Factor True up",null,0,0]
["ED_REV313_00005","DREV0305","Other",null,0,0]
[null,"DREV03","Total revenue of incentive schemes","$0's",{"$f":"SUM(E38:E42)","v":0},{"$f":"SUM(F38:F42)","v":0}]

{"sheet":"3.2 Operating expenditure","index":3,"n_rows":219,"n_cols":6,"rows_kept":219,"cut":false,"hidden":false,"merged":[[11,4,11,5]]}
[null,null,"REGULATORY REPORTING STATEMENT",null,null,"Worksheet navigation"]
[null,null,{"$f":"dms_TradingName","v":"ActewAGL Distribution"}]
[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":"ActewAGL Distribution must fill in opex in table 3.2.1 for opex categories reported in response to its annual reporting RIN."}]
[]
[]
[null,null,null,null,"Standard control services","Alternative control services"]
[null,null,null,null,"Actual\n($0's)"]
["ED_OPX3211",null,null,null,{"$f":"CRY","v":"2014-15"},{"$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"]
["ED_OPX3211_00001","DOPEX0101","VEGETATION MANAGEMENT",null,{"$f":"'[1]3.2 Operating expenditure'!E18+'[2]3.2 Operating expenditure'!E18","v":2765697.4987194855},{"$f":"'[1]3.2 Operating expenditure'!F18+'[2]3.2 Operating expenditure'!F18","v":0}]
["ED_OPX3211_00002","DOPEX0102","ROUTINE MAINTENANCE",null,{"$f":"'[1]3.2 Operating expenditure'!E19+'[2]3.2 Operating expenditure'!E19","v":1962311.1231500991},{"$f":"'[1]3.2 Operating expenditure'!F19+'[2]3.2 Operating expenditure'!F19","v":225.77}]
["ED_OPX3211_00003","DOPEX0103","NON-ROUTINE MAINTENANCE",null,{"$f":"'[1]3.2 Operating expenditure'!E20+'[2]3.2 Operating expenditure'!E20","v":5876754.8967152517},{"$f":"'[1]3.2 Operating expenditure'!F20+'[2]3.2 Operating expenditure'!F20","v":60075.560000000005}]
["ED_OPX3211_00004","DOPEX0104","CONDITION MONITORING",null,{"$f":"'[1]3.2 Operating expenditure'!E21+'[2]3.2 Operating expenditure'!E21","v":4626759.1947908094},{"$f":"'[1]3.2 Operating expenditure'!F21+'[2]3.2 Operating expenditure'!F21","v":405920.64}]
["ED_OPX3211_00005","DOPEX0105","EMERGENCY RESPONSE",null,{"$f":"'[1]3.2 Operating expenditure'!E22+'[2]3.2 Operating expenditure'!E22","v":0},{"$f":"'[1]3.2 Operating expenditure'!F22+'[2]3.2 Operating expenditure'!F22","v":0}]
["ED_OPX3211_00006","DOPEX0106","NON NETWORK IT AND COMMUNICATIONS",null,{"$f":"'[1]3.2 Operating expenditure'!E23+'[2]3.2 Operating expenditure'!E23","v":7674266.1313033504},{"$f":"'[1]3.2 Operating expenditure'!F23+'[2]3.2 Operating expenditure'!F23","v":0}]
["ED_OPX3211_00007","DOPEX0107","NETWORK MANAGEMENT ",null,{"$f":"'[1]3.2 Operating expenditure'!E24+'[2]3.2 Operating expenditure'!E24","v":0},{"$f":"'[1]3.2 Operating expenditure'!F24+'[2]3.2 Operating expenditure'!F24","v":0}]
["ED_OPX3211_00008","DOPEX0108","NETWORK PLANNING",null,{"$f":"'[1]3.2 Operating expenditure'!E25+'[2]3.2 Operating expenditure'!E25","v":3635750.0219625095},{"$f":"'[1]3.2 Operating expenditure'!F25+'[2]3.2 Operating expenditure'!F25","v":152918.82999999999}]
["ED_OPX3211_00009","DOPEX0109","NETWORK CONTROL AND OPERATIONAL SWITCHING",null,{"$f":"'[1]3.2 Operating expenditure'!E26+'[2]3.2 Operating expenditure'!E26","v":5395908.6149700619},{"$f":"'[1]3.2 Operating expenditure'!F26+'[2]3.2 Operating expenditure'!F26","v":0}]
["ED_OPX3211_00010","DOPEX0110","QUALITY AND STANDARD FUNCTIONS",null,{"$f":"'[1]3.2 Operating expenditure'!E27+'[2]3.2 Operating expenditure'!E27","v":1607996.0634954339},{"$f":"'[1]3.2 Operating expenditure'!F27+'[2]3.2 Operating expenditure'!F27","v":0}]
["ED_OPX3211_00011","DOPEX0111","PROJECT GOVERNANCE AND RELATED FUNCTIONS ",null,{"$f":"'[1]3.2 Operating expenditure'!E28+'[2]3.2 Operating expenditure'!E28","v":0},{"$f":"'[1]3.2 Operating expenditure'!F28+'[2]3.2 Operating expenditure'!F28","v":0}]
["ED_OPX3211_00012","DOPEX0112","REGULATORY OPERATIONS",null,{"$f":"'[1]3.2 Operating expenditure'!E29+'[2]3.2 Operating expenditure'!E29","v":6663555.0814969856},{"$f":"'[1]3.2 Operating expenditure'!F29+'[2]3.2 Operating expenditure'!F29","v":0}]
["ED_OPX3211_00013","DOPEX0113","CUSTOMER SERVICE",null,{"$f":"'[1]3.2 Operating expenditure'!E30+'[2]3.2 Operating expenditure'!E30","v":5792857.0549464505},{"$f":"'[1]3.2 Operating expenditure'!F30+'[2]3.2 Operating expenditure'!F30","v":0}]
["ED_OPX3211_00014","DOPEX0114","ADVERTISING & MARKETING",null,{"$f":"'[1]3.2 Operating expenditure'!E31+'[2]3.2 Operating expenditure'!E31","v":1003205.9599999998},{"$f":"'[1]3.2 Operating expenditure'!F31+'[2]3.2 Operating expenditure'!F31","v":0}]
["ED_OPX3211_00015","DOPEX0115","BILLING & REVENUE OPERATIONS",null,{"$f":"'[1]3.2 Operating expenditure'!E32+'[2]3.2 Operating expenditure'!E32","v":1157554.9109781741},{"$f":"'[1]3.2 Operating expenditure'!F32+'[2]3.2 Operating expenditure'!F32","v":0}]
["ED_OPX3211_00016","DOPEX0116","TRAINING APPRENTICESHIP & GRADUATE ENGINEER",null,{"$f":"'[1]3.2 Operating expenditure'!E33+'[2]3.2 Operating expenditure'!E33","v":2050486.9582139945},{"$f":"'[1]3.2 Operating expenditure'!F33+'[2]3.2 Operating expenditure'!F33","v":0}]
["ED_OPX3211_00017","DOPEX0117","BUSINESS OVERHEADS",null,{"$f":"'[1]3.2 Operating expenditure'!E34+'[2]3.2 Operating expenditure'!E34","v":4538041.2500000075},{"$f":"'[1]3.2 Operating expenditure'!F34+'[2]3.2 Operating expenditure'!F34","v":0}]
["ED_OPX3211_00018","DOPEX0118","RECOVERIES",null,{"$f":"'[1]3.2 Operating expenditure'!E35+'[2]3.2 Operating expenditure'!E35","v":2143990.099999994},{"$f":"'[1]3.2 Operating expenditure'!F35+'[2]3.2 Operating expenditure'!F35","v":0}]
["ED_OPX3211_00019","DOPEX0119","METER READING",null,{"$f":"'[1]3.2 Operating expenditure'!E36+'[2]3.2 Operating expenditure'!E36","v":0},{"$f":"'[1]3.2 Operating expenditure'!F36+'[2]3.2 Operating expenditure'!F36","v":1862128.26}]
["ED_OPX3211_00020","DOPEX0120","METER DATA SERVICES",null,{"$f":"'[1]3.2 Operating expenditure'!E37+'[2]3.2 Operating expenditure'!E37","v":0},{"$f":"'[1]3.2 Operating expenditure'!F37+'[2]3.2 Operating expenditure'!F37","v":983359.60000000009}]
["ED_OPX3211_00021","DOPEX0121","ANCILLARY SERVICES - QUOTED SERVICES",null,{"$f":"'[1]3.2 Operating expenditure'!E38+'[2]3.2 Operating expenditure'!E38","v":0},{"$f":"'[1]3.2 Operating expenditure'!F38+'[2]3.2 Operating expenditure'!F38","v":1200394.95}]
["ED_OPX3211_00022","DOPEX0122","ANCILLARY SERVICES - FEE BASED SERVICES",null,{"$f":"'[1]3.2 Operating expenditure'!E39+'[2]3.2 Operating expenditure'!E39","v":0},{"$f":"'[1]3.2 Operating expenditure'!F39+'[2]3.2 Operating expenditure'!F39","v":3222082.7}]
["ED_OPX3211_00023","DOPEX0123","Restructuring Expenditure",null,{"$f":"'[1]3.2 Operating expenditure'!E40+'[2]3.2 Operating expenditure'!E40","v":16684707.82},{"$f":"'[1]3.2 Operating expenditure'!F40+'[2]3.2 Operating expenditure'!F40","v":0}]
["ED_OPX3211_00024","DOPEX0124"]
["ED_OPX3211_00025","DOPEX0125"]
["ED_OPX3211_00026","DOPEX0126"]
["ED_OPX3211_00027","DOPEX0127"]
["ED_OPX3211_00028","DOPEX0128"]
["ED_OPX3211_00029","DOPEX0129"]
["ED_OPX3211_00030","DOPEX0130"]
["ED_OPX3211_00031","DOPEX0131"]
["ED_OPX3211_00032","DOPEX0132"]
["ED_OPX3211_00033","DOPEX0133"]
["ED_OPX3211_00034","DOPEX0134"]
["ED_OPX3211_00035","DOPEX0135"]
["ED_OPX3211_00036","DOPEX0136"]
["ED_OPX3211_00037","DOPEX0137"]
["ED_OPX3211_00038","DOPEX0138"]
["ED_OPX3211_00039","DOPEX0139"]
["ED_OPX3211_00040","DOPEX0140"]
["ED_OPX3211_00041","DOPEX0141"]
["ED_OPX3211_00042","DOPEX0142"]
[null,"DOPEX01","Total opex ","($0's)",{"$f":"SUM(E18:E59)","v":73579842.680742621},{"$f":"SUM(F18:F59)","v":7887106.3100000005}]
[]
[]
["ED_OPX3212A",null,"Table 3.2.1.2A - Historical opex categories and cost allocations",null,{"$f":"CRY","v":"2014-15"},{"$f":"CRY","v":"2014-15"}]
["ED_OPX3212A_00001","DOPEX0101A","Network control",null,{"$f":"'[1]3.2 Operating expenditure'!E64+'[2]3.2 Operating expenditure'!E64","v":5395908.6149700619},{"$f":"'[1]3.2 Operating expenditure'!F64+'[2]3.2 Operating expenditure'!F64","v":0}]
["ED_OPX3212A_00002","DOPEX0102A","IT planning and operations",null,{"$f":"'[1]3.2 Operating expenditure'!E65+'[2]3.2 Operating expenditure'!E65","v":7674266.1313033504},{"$f":"'[1]3.2 Operating expenditure'!F65+'[2]3.2 Operating expenditure'!F65","v":0}]
["ED_OPX3212A_00003","DOPEX0103A","Network systems operations",null,{"$f":"'[1]3.2 Operating expenditure'!E66+'[2]3.2 Operating expenditure'!E66","v":5792857.0549464505},{"$f":"'[1]3.2 Operating expenditure'!F66+'[2]3.2 Operating expenditure'!F66","v":0}]
["ED_OPX3212A_00004","DOPEX0104A","Quality, environmental and safety systems",null,{"$f":"'[1]3.2 Operating expenditure'!E67+'[2]3.2 Operating expenditure'!E67","v":1416305.39},{"$f":"'[1]3.2 Operating expenditure'!F67+'[2]3.2 Operating expenditure'!F67","v":0}]
["ED_OPX3212A_00005","DOPEX0105A","Executive & financial management",null,{"$f":"'[1]3.2 Operating expenditure'!E68+'[2]3.2 Operating expenditure'!E68","v":1612770.29},{"$f":"'[1]3.2 Operating expenditure'!F68+'[2]3.2 Operating expenditure'!F68","v":0}]
["ED_OPX3212A_00006","DOPEX0106A","Other network operating costs (itemise in table 3 below)",null,{"$f":"'[1]3.2 Operating expenditure'!E69+'[2]3.2 Operating expenditure'!E69","v":10275327.172714356},{"$f":"'[1]3.2 Operating expenditure'!F69+'[2]3.2 Operating expenditure'!F69","v":0}]
["ED_OPX3212A_00007","DOPEX0107A","Non-network alternatives (demand management)",null,{"$f":"'[1]3.2 Operating expenditure'!E70+'[2]3.2 Operating expenditure'!E70","v":0},{"$f":"'[1]3.2 Operating expenditure'!F70+'[2]3.2 Operating expenditure'!F70","v":0}]
["ED_OPX3212A_00008","DOPEX0108A","Advertising & marketing",null,{"$f":"'[1]3.2 Operating expenditure'!E71+'[2]3.2 Operating expenditure'!E71","v":1003205.9599999998},{"$f":"'[1]3.2 Operating expenditure'!F71+'[2]3.2 Operating expenditure'!F71","v":0}]
["ED_OPX3212A_00009","DOPEX0109A","Corporate management fee",null,{"$f":"'[1]3.2 Operating expenditure'!E72+'[2]3.2 Operating expenditure'!E72","v":0},{"$f":"'[1]3.2 Operating expenditure'!F72+'[2]3.2 Operating expenditure'!F72","v":0}]
["ED_OPX3212A_00010","DOPEX0110A","Business services provided by ActewAGL retail",null,{"$f":"'[1]3.2 Operating expenditure'!E73+'[2]3.2 Operating expenditure'!E73","v":0},{"$f":"'[1]3.2 Operating expenditure'!F73+'[2]3.2 Operating expenditure'!F73","v":0}]
["ED_OPX3212A_00011","DOPEX0111A","Apprentice training program",null,{"$f":"'[1]3.2 Operating expenditure'!E74+'[2]3.2 Operating expenditure'!E74","v":2050486.9582139945},{"$f":"'[1]3.2 Operating expenditure'!F74+'[2]3.2 Operating expenditure'!F74","v":0}]
["ED_OPX3212A_00012","DOPEX0112A","Business overheads",null,{"$f":"'[1]3.2 Operating expenditure'!E75+'[2]3.2 Operating expenditure'!E75","v":20337663.490000002},{"$f":"'[1]3.2 Operating expenditure'!F75+'[2]3.2 Operating expenditure'!F75","v":0}]
["ED_OPX3212A_00013","DOPEX0113A","Regulated miscellaneous charges",null,{"$f":"'[1]3.2 Operating expenditure'!E76+'[2]3.2 Operating expenditure'!E76","v":0},{"$f":"'[1]3.2 Operating expenditure'!F76+'[2]3.2 Operating expenditure'!F76","v":3222082.7}]
["ED_OPX3212A_00014","DOPEX0114A","External business expenditure",null,{"$f":"'[1]3.2 Operating expenditure'!E77+'[2]3.2 Operating expenditure'!E77","v":0},{"$f":"'[1]3.2 Operating expenditure'!F77+'[2]3.2 Operating expenditure'!F77","v":1200394.95}]
["ED_OPX3212A_00015","DOPEX0115A","Zone substation Planned",null,{"$f":"'[1]3.2 Operating expenditure'!E78+'[2]3.2 Operating expenditure'!E78","v":3995829.0561291534},{"$f":"'[1]3.2 Operating expenditure'!F78+'[2]3.2 Operating expenditure'!F78","v":0}]
["ED_OPX3212A_00016","DOPEX0116A","Zone substation Reactive",null,{"$f":"'[1]3.2 Operating expenditure'!E79+'[2]3.2 Operating expenditure'!E79","v":342719.85158351017},{"$f":"'[1]3.2 Operating expenditure'!F79+'[2]3.2 Operating expenditure'!F79","v":0}]
["ED_OPX3212A_00017","DOPEX0117A","Transmission Planned",null,{"$f":"'[1]3.2 Operating expenditure'!E80+'[2]3.2 Operating expenditure'!E80","v":85365.742800119944},{"$f":"'[1]3.2 Operating expenditure'!F80+'[2]3.2 Operating expenditure'!F80","v":0}]
["ED_OPX3212A_00018","DOPEX0118A","Transmission Reactive",null,{"$f":"'[1]3.2 Operating expenditure'!E81+'[2]3.2 Operating expenditure'!E81","v":20265.579508804531},{"$f":"'[1]3.2 Operating expenditure'!F81+'[2]3.2 Operating expenditure'!F81","v":0}]
["ED_OPX3212A_00019","DOPEX0119A","Underground distribution Planned",null,{"$f":"'[1]3.2 Operating expenditure'!E82+'[2]3.2 Operating expenditure'!E82","v":0},{"$f":"'[1]3.2 Operating expenditure'!F82+'[2]3.2 Operating expenditure'!F82","v":0}]
["ED_OPX3212A_00020","DOPEX0120A","Underground distribution Reactive",null,{"$f":"'[1]3.2 Operating expenditure'!E83+'[2]3.2 Operating expenditure'!E83","v":0},{"$f":"'[1]3.2 Operating expenditure'!F83+'[2]3.2 Operating expenditure'!F83","v":0}]
["ED_OPX3212A_00021","DOPEX0121A","Overhead distribution Planned",null,{"$f":"'[1]3.2 Operating expenditure'!E84+'[2]3.2 Operating expenditure'!E84","v":7688963.8746188479},{"$f":"'[1]3.2 Operating expenditure'!F84+'[2]3.2 Operating expenditure'!F84","v":0}]
["ED_OPX3212A_00022","DOPEX0122A","Overhead distribution Reactive",null,{"$f":"'[1]3.2 Operating expenditure'!E85+'[2]3.2 Operating expenditure'!E85","v":5887907.5139539586},{"$f":"'[1]3.2 Operating expenditure'!F85+'[2]3.2 Operating expenditure'!F85","v":0}]
["ED_OPX3212A_00023","DOPEX0123A","Distribution station Planned",null,{"$f":"'[1]3.2 Operating expenditure'!E86+'[2]3.2 Operating expenditure'!E86","v":0},{"$f":"'[1]3.2 Operating expenditure'!F86+'[2]3.2 Operating expenditure'!F86","v":0}]
["ED_OPX3212A_00024","DOPEX0124A","Distribution station Reactive",null,{"$f":"'[1]3.2 Operating expenditure'!E87+'[2]3.2 Operating expenditure'!E87","v":0},{"$f":"'[1]3.2 Operating expenditure'!F87+'[2]3.2 Operating expenditure'!F87","v":0}]
["ED_OPX3212A_00025","DOPEX0125A","Meter reading expenditures",null,{"$f":"'[1]3.2 Operating expenditure'!E88+'[2]3.2 Operating expenditure'!E88","v":0},{"$f":"'[1]3.2 Operating expenditure'!F88+'[2]3.2 Operating expenditure'!F88","v":2845487.8600000003}]
["ED_OPX3212A_00026","DOPEX0126A","Maintenance and repair of meters",null,{"$f":"'[1]3.2 Operating expenditure'!E89+'[2]3.2 Operating expenditure'!E89","v":0},{"$f":"'[1]3.2 Operating expenditure'!F89+'[2]3.2 Operating expenditure'!F89","v":619140.80000000005}]
["ED_OPX3212A_00027","DOPEX0127A"]
["ED_OPX3212A_00028","DOPEX0128A"]
["ED_OPX3212A_00029","DOPEX0129A"]
["ED_OPX3212A_00030","DOPEX0130A"]
["ED_OPX3212A_00031","DOPEX0131A"]
["ED_OPX3212A_00032","DOPEX0132A"]
["ED_OPX3212A_00033","DOPEX0133A"]
["ED_OPX3212A_00034","DOPEX0134A"]
["ED_OPX3212A_00035","DOPEX0135A"]
["ED_OPX3212A_00036","DOPEX0136A"]
["ED_OPX3212A_00037","DOPEX0137A"]
["ED_OPX3212A_00038","DOPEX0138A"]
["ED_OPX3212A_00039","DOPEX0139A"]
["ED_OPX3212A_00040","DOPEX0140A"]
["ED_OPX3212A_00041","DOPEX0141A"]
["ED_OPX3212A_00042","DOPEX0142A"]
[null,"DOPEX01A","Total opex ","($0's)",{"$f":"SUM(E64:E105)","v":73579842.680742607},{"$f":"SUM(F64:F105)","v":7887106.3100000005}]
[]
["ED_OPX3212B",null,"Table 3.2.1.2B - Historical opex categories and cost allocations",null,{"$f":"CRY","v":"2014-15"},{"$f":"CRY","v":"2014-15"}]
["ED_OPX3212B_00001","DOPEX0101B"]
["ED_OPX3212B_00002","DOPEX0102B"]
["ED_OPX3212B_00003","DOPEX0103B"]
["ED_OPX3212B_00004","DOPEX0104B"]
["ED_OPX3212B_00005","DOPEX0105B"]
["ED_OPX3212B_00006","DOPEX0106B"]
["ED_OPX3212B_00007","DOPEX0107B"]
["ED_OPX3212B_00008","DOPEX0108B"]
["ED_OPX3212B_00009","DOPEX0109B"]
["ED_OPX3212B_00010","DOPEX0110B"]
["ED_OPX3212B_00011","DOPEX0111B"]
["ED_OPX3212B_00012","DOPEX0112B"]
["ED_OPX3212B_00013","DOPEX0113B"]
["ED_OPX3212B_00014","DOPEX0114B"]
["ED_OPX3212B_00015","DOPEX0115B"]
["ED_OPX3212B_00016","DOPEX0116B"]
["ED_OPX3212B_00017","DOPEX0117B"]
["ED_OPX3212B_00018","DOPEX0118B"]
["ED_OPX3212B_00019","DOPEX0119B"]
["ED_OPX3212B_00020","DOPEX0120B"]
["ED_OPX3212B_00021","DOPEX0121B"]
["ED_OPX3212B_00022","DOPEX0122B"]
["ED_OPX3212B_00023","DOPEX0123B"]
["ED_OPX3212B_00024","DOPEX0124B"]
["ED_OPX3212B_00025","DOPEX0125B"]
["ED_OPX3212B_00026","DOPEX0126B"]
["ED_OPX3212B_00027","DOPEX0127B"]
["ED_OPX3212B_00028","DOPEX0128B"]
["ED_OPX3212B_00029","DOPEX0129B"]
["ED_OPX3212B_00030","DOPEX0130B"]
["ED_OPX3212B_00031","DOPEX0131B"]
["ED_OPX3212B_00032","DOPEX0132B"]
["ED_OPX3212B_00033","DOPEX0133B"]
["ED_OPX3212B_00034","DOPEX0134B"]
["ED_OPX3212B_00035","DOPEX0135B"]
["ED_OPX3212B_00036","DOPEX0136B"]
["ED_OPX3212B_00037","DOPEX0137B"]
["ED_OPX3212B_00038","DOPEX0138B"]
["ED_OPX3212B_00039","DOPEX0139B"]
["ED_OPX3212B_00040","DOPEX0140B"]
["ED_OPX3212B_00041","DOPEX0141B"]
["ED_OPX3212B_00042","DOPEX0142B"]
[null,"DOPEX01B","Total opex ","($0's)",{"$f":"SUM(E109:E150)","v":0},{"$f":"SUM(F109:F150)","v":0}]
[]
["ED_OPX3212C",null,"Table 3.2.1.2C - Historical opex categories and cost allocations",null,{"$f":"CRY","v":"2014-15"},{"$f":"CRY","v":"2014-15"}]
["ED_OPX3212C_00001","DOPEX0101C"]
["ED_OPX3212C_00002","DOPEX0102C"]
["ED_OPX3212C_00003","DOPEX0103C"]
["ED_OPX3212C_00004","DOPEX0104C"]
["ED_OPX3212C_00005","DOPEX0105C"]
["ED_OPX3212C_00006","DOPEX0106C"]
["ED_OPX3212C_00007","DOPEX0107C"]
["ED_OPX3212C_00008","DOPEX0108C"]
["ED_OPX3212C_00009","DOPEX0109C"]
["ED_OPX3212C_00010","DOPEX0110C"]
["ED_OPX3212C_00011","DOPEX0111C"]
["ED_OPX3212C_00012","DOPEX0112C"]
["ED_OPX3212C_00013","DOPEX0113C"]
["ED_OPX3212C_00014","DOPEX0114C"]
["ED_OPX3212C_00015","DOPEX0115C"]
["ED_OPX3212C_00016","DOPEX0116C"]
["ED_OPX3212C_00017","DOPEX0117C"]
["ED_OPX3212C_00018","DOPEX0118C"]
["ED_OPX3212C_00019","DOPEX0119C"]
["ED_OPX3212C_00020","DOPEX0120C"]
["ED_OPX3212C_00021","DOPEX0121C"]
["ED_OPX3212C_00022","DOPEX0122C"]
["ED_OPX3212C_00023","DOPEX0123C"]
["ED_OPX3212C_00024","DOPEX0124C"]
["ED_OPX3212C_00025","DOPEX0125C"]
["ED_OPX3212C_00026","DOPEX0126C"]
["ED_OPX3212C_00027","DOPEX0127C"]
["ED_OPX3212C_00028","DOPEX0128C"]
["ED_OPX3212C_00029","DOPEX0129C"]
["ED_OPX3212C_00030","DOPEX0130C"]
["ED_OPX3212C_00031","DOPEX0131C"]
["ED_OPX3212C_00032","DOPEX0132C"]
["ED_OPX3212C_00033","DOPEX0133C"]
["ED_OPX3212C_00034","DOPEX0134C"]
["ED_OPX3212C_00035","DOPEX0135C"]
["ED_OPX3212C_00036","DOPEX0136C"]
["ED_OPX3212C_00037","DOPEX0137C"]
["ED_OPX3212C_00038","DOPEX0138C"]
["ED_OPX3212C_00039","DOPEX0139C"]
["ED_OPX3212C_00040","DOPEX0140C"]
["ED_OPX3212C_00041","DOPEX0141C"]
["ED_OPX3212C_00042","DOPEX0142C"]
[null,"DOPEX01C","Total opex ","($0's)",{"$f":"SUM(E154:E195)","v":0},{"$f":"SUM(F154:F195)","v":0}]
[]
[null,null,"TABLE 3.2.2 - OPEX CONSISTENCY"]
[]
[null,null,"Table 3.2.2.1  Opex consistency - current cost allocation approach",null,{"$f":"CRY","v":"2014-15"},{"$f":"CRY","v":"2014-15"}]
["ED_OPX3221_00001","DOPEX0201","Opex for network services",null,{"$f":"'[1]3.2 Operating expenditure'!E201","v":73579842.680742621},{"$f":"'[1]3.2 Operating expenditure'!F201","v":0}]
["ED_OPX3221_00002","DOPEX0202","Opex for metering",null,{"$f":"'[1]3.2 Operating expenditure'!E202","v":0},{"$f":"'[1]3.2 Operating expenditure'!F202","v":3464628.66}]
["ED_OPX3221_00003","DOPEX0203","Opex for connection services",null,{"$f":"'[1]3.2 Operating expenditure'!E203","v":0},{"$f":"'[1]3.2 Operating expenditure'!F203","v":4422477.6500000004}]
["ED_OPX3221_00004","DOPEX0204","Opex for public lighting",null,{"$f":"'[1]3.2 Operating expenditure'!E204","v":0},{"$f":"'[1]3.2 Operating expenditure'!F204","v":0}]
["ED_OPX3221_00005","DOPEX0205","Opex for amounts payable for easement levy or similar direct charges on DNSP",null,{"$f":"'[1]3.2 Operating expenditure'!E205","v":0},{"$f":"'[1]3.2 Operating expenditure'!F205","v":0}]
["ED_OPX3221_00006","DOPEX0206","Opex for transmission connection point planning",null,{"$f":"'[1]3.2 Operating expenditure'!E206","v":0},{"$f":"'[1]3.2 Operating expenditure'!F206","v":0}]
[null,null,"Total opex ","($0's)",{"$f":"SUM(E201:E206)","v":73579842.680742621},{"$f":"SUM(F201:F206)","v":7887106.3100000005}]
[]
[null,null,"Table 3.2.2.2  Opex consistency - historical cost allocation approaches",null,{"$f":"CRY","v":"2014-15"},{"$f":"CRY","v":"2014-15"}]
["ED_OPX3222_00001","DOPEX0201A","Opex for network services",null,{"$f":"'[1]3.2 Operating expenditure'!E210","v":73579842.680742607},{"$f":"'[1]3.2 Operating expenditure'!F210","v":0}]
["ED_OPX3222_00002","DOPEX0202A","Opex for metering",null,{"$f":"'[1]3.2 Operating expenditure'!E211","v":0},{"$f":"'[1]3.2 Operating expenditure'!F211","v":3464628.66}]
["ED_OPX3222_00003","DOPEX0203A","Opex for connection services",null,{"$f":"'[1]3.2 Operating expenditure'!E212","v":0},{"$f":"'[1]3.2 Operating expenditure'!F212","v":4422477.6500000004}]
["ED_OPX3222_00004","DOPEX0204A","Opex for public lighting",null,{"$f":"'[1]3.2 Operating expenditure'!E213","v":0},{"$f":"'[1]3.2 Operating expenditure'!F213","v":0}]
["ED_OPX3222_00005","DOPEX0205A","Opex for amounts payable for easement levy or similar direct charges on DNSP",null,{"$f":"'[1]3.2 Operating expenditure'!E214","v":0},{"$f":"'[1]3.2 Operating expenditure'!F214","v":0}]
["ED_OPX3222_00006","DOPEX0206A","Opex for transmission connection point planning",null,{"$f":"'[1]3.2 Operating expenditure'!E215","v":0},{"$f":"'[1]3.2 Operating expenditure'!F215","v":0}]
[null,null,"Total opex ","($0's)",{"$f":"SUM(E210:E215)","v":73579842.680742607},{"$f":"SUM(F210:F215)","v":7887106.3100000005}]
[]
[null,null,"TABLE 3.2.4 - OPEX FOR HIGH VOLTAGE CUSTOMERS",null,"End user costs (not standard control services)"]
["ED_OPX324_00001","DOPEX0401","Opex for high voltage customers","($0's)",50897.42]

{"sheet":"3.2.3 Provisions","index":4,"n_rows":373,"n_cols":5,"rows_kept":373,"cut":false,"hidden":false,"merged":[]}
[null,null,"REGULATORY REPORTING STATEMENT"]
[null,null,{"$f":"dms_TradingName","v":"ActewAGL Distribution"}]
[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.3 for opex categories reported in response to its annual reporting RIN.\")","v":"ActewAGL Distribution must fill in opex in table 3.2.3 for opex categories reported in response to its annual reporting RIN."}]
[]
[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,"DOPEX03A","Employee entitlements provision"]
[null,null,"Provision required to account for employee entitlements such as recreation leave, long service leave and sick leave."]
[null,"DOPEX0301A","Opening balance (the carrying amount at the beginning of the period)",null,{"$f":"'[1]3.2.3 Provisions'!E16+'[2]3.2.3 Provisions'!E16","v":17292939}]
[null,null,"Additional provisions made in the period, including increases to existing provisions"]
[null,"DOPEX0302A","Opex component",null,{"$f":"'[1]3.2.3 Provisions'!E18+'[2]3.2.3 Provisions'!E18","v":5343635}]
[null,"DOPEX0303A","Capex component",null,{"$f":"'[1]3.2.3 Provisions'!E19+'[2]3.2.3 Provisions'!E19","v":0}]
[null,"DOPEX0304A","Other component",null,{"$f":"'[1]3.2.3 Provisions'!E20+'[2]3.2.3 Provisions'!E20","v":0}]
[null,null,"Amounts used (that is, incurred and charged against the provision) during the period"]
[null,"DOPEX0305A","Opex component",null,{"$f":"'[1]3.2.3 Provisions'!E22+'[2]3.2.3 Provisions'!E22","v":-6264692}]
[null,"DOPEX0306A","Capex component",null,{"$f":"'[1]3.2.3 Provisions'!E23+'[2]3.2.3 Provisions'!E23","v":0}]
[null,"DOPEX0307A","Other component",null,{"$f":"'[1]3.2.3 Provisions'!E24+'[2]3.2.3 Provisions'!E24","v":0}]
[null,null,"Unused amounts reversed during the period"]
[null,"DOPEX0308A","Opex component",null,{"$f":"'[1]3.2.3 Provisions'!E26+'[2]3.2.3 Provisions'!E26","v":-1082411}]
[null,"DOPEX0309A","Capex component",null,{"$f":"'[1]3.2.3 Provisions'!E27+'[2]3.2.3 Provisions'!E27","v":0}]
[null,"DOPEX0310A","Other component",null,{"$f":"'[1]3.2.3 Provisions'!E28+'[2]3.2.3 Provisions'!E28","v":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,"DOPEX0311A","Opex component",null,{"$f":"'[1]3.2.3 Provisions'!E30+'[2]3.2.3 Provisions'!E30","v":0}]
[null,"DOPEX0312A","Capex component",null,{"$f":"'[1]3.2.3 Provisions'!E31+'[2]3.2.3 Provisions'!E31","v":0}]
[null,"DOPEX0313A","Other component",null,{"$f":"'[1]3.2.3 Provisions'!E32+'[2]3.2.3 Provisions'!E32","v":0}]
[null,"DOPEX0314A","Closing balance (carrying amount at the end of the period)",null,{"$f":"'[1]3.2.3 Provisions'!E33+'[2]3.2.3 Provisions'!E33","v":15289471}]
[null,"DOPEX03B","Redundancy provision"]
[null,null,"The redundancy provision is based on planned management efficiencies"]
[null,"DOPEX0301B","Opening balance (the carrying amount at the beginning of the period)",null,{"$f":"'[1]3.2.3 Provisions'!E36+'[2]3.2.3 Provisions'!E36","v":4038110}]
[null,null,"Additional provisions made in the period, including increases to existing provisions"]
[null,"DOPEX0302B","Opex component",null,{"$f":"'[1]3.2.3 Provisions'!E38+'[2]3.2.3 Provisions'!E38","v":15230868}]
[null,"DOPEX0303B","Capex component",null,{"$f":"'[1]3.2.3 Provisions'!E39+'[2]3.2.3 Provisions'!E39","v":0}]
[null,"DOPEX0304B","Other component",null,{"$f":"'[1]3.2.3 Provisions'!E40+'[2]3.2.3 Provisions'!E40","v":0}]
[null,null,"Amounts used (that is, incurred and charged against the provision) during the period"]
[null,"DOPEX0305B","Opex component",null,{"$f":"'[1]3.2.3 Provisions'!E42+'[2]3.2.3 Provisions'!E42","v":-7404366}]
[null,"DOPEX0306B","Capex component",null,{"$f":"'[1]3.2.3 Provisions'!E43+'[2]3.2.3 Provisions'!E43","v":0}]
[null,"DOPEX0307B","Other component",null,{"$f":"'[1]3.2.3 Provisions'!E44+'[2]3.2.3 Provisions'!E44","v":0}]
[null,null,"Unused amounts reversed during the period"]
[null,"DOPEX0308B","Opex component",null,{"$f":"'[1]3.2.3 Provisions'!E46+'[2]3.2.3 Provisions'!E46","v":0}]
[null,"DOPEX0309B","Capex component",null,{"$f":"'[1]3.2.3 Provisions'!E47+'[2]3.2.3 Provisions'!E47","v":0}]
[null,"DOPEX0310B","Other component",null,{"$f":"'[1]3.2.3 Provisions'!E48+'[2]3.2.3 Provisions'!E48","v":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,"DOPEX0311B","Opex component",null,{"$f":"'[1]3.2.3 Provisions'!E50+'[2]3.2.3 Provisions'!E50","v":0}]
[null,"DOPEX0312B","Capex component",null,{"$f":"'[1]3.2.3 Provisions'!E51+'[2]3.2.3 Provisions'!E51","v":0}]
[null,"DOPEX0313B","Other component",null,{"$f":"'[1]3.2.3 Provisions'!E52+'[2]3.2.3 Provisions'!E52","v":0}]
[null,"DOPEX0314B","Closing balance (carrying amount at the end of the period)",null,{"$f":"'[1]3.2.3 Provisions'!E53+'[2]3.2.3 Provisions'!E53","v":11864612}]
[null,"DOPEX03C","Public liability provision"]
[null,null,"Public liability provisions include public liability and legal claims."]
[null,"DOPEX0301C","Opening balance (the carrying amount at the beginning of the period)",null,{"$f":"'[1]3.2.3 Provisions'!E56+'[2]3.2.3 Provisions'!E56","v":110368}]
[null,null,"Additional provisions made in the period, including increases to existing provisions"]
[null,"DOPEX0302C","Opex component",null,{"$f":"'[1]3.2.3 Provisions'!E58+'[2]3.2.3 Provisions'!E58","v":994223}]
[null,"DOPEX0303C","Capex component",null,{"$f":"'[1]3.2.3 Provisions'!E59+'[2]3.2.3 Provisions'!E59","v":0}]
[null,"DOPEX0304C","Other component",null,{"$f":"'[1]3.2.3 Provisions'!E60+'[2]3.2.3 Provisions'!E60","v":0}]
[null,null,"Amounts used (that is, incurred and charged against the provision) during the period"]
[null,"DOPEX0305C","Opex component",null,{"$f":"'[1]3.2.3 Provisions'!E62+'[2]3.2.3 Provisions'!E62","v":-127371}]
[null,"DOPEX0306C","Capex component",null,{"$f":"'[1]3.2.3 Provisions'!E63+'[2]3.2.3 Provisions'!E63","v":0}]
[null,"DOPEX0307C","Other component",null,{"$f":"'[1]3.2.3 Provisions'!E64+'[2]3.2.3 Provisions'!E64","v":0}]
[null,null,"Unused amounts reversed during the period"]
[null,"DOPEX0308C","Opex component",null,{"$f":"'[1]3.2.3 Provisions'!E66+'[2]3.2.3 Provisions'!E66","v":0}]
[null,"DOPEX0309C","Capex component",null,{"$f":"'[1]3.2.3 Provisions'!E67+'[2]3.2.3 Provisions'!E67","v":0}]
[null,"DOPEX0310C","Other component",null,{"$f":"'[1]3.2.3 Provisions'!E68+'[2]3.2.3 Provisions'!E68","v":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,"DOPEX0311C","Opex component",null,{"$f":"'[1]3.2.3 Provisions'!E70+'[2]3.2.3 Provisions'!E70","v":0}]
[null,"DOPEX0312C","Capex component",null,{"$f":"'[1]3.2.3 Provisions'!E71+'[2]3.2.3 Provisions'!E71","v":0}]
[null,"DOPEX0313C","Other component",null,{"$f":"'[1]3.2.3 Provisions'!E72+'[2]3.2.3 Provisions'!E72","v":0}]
[null,"DOPEX0314C","Closing balance (carrying amount at the end of the period)",null,{"$f":"'[1]3.2.3 Provisions'!E73+'[2]3.2.3 Provisions'!E73","v":977221}]
[null,"DOPEX03D","Workers' compensation"]
[null,null,"The ACT Government and ACTEW Corporation Ltd (ACTEW) have agreed to exit ACTEW's workers' compensation arrangement with ComCare. The exit arrangements include annual payments over the period to 30 June 2022 for incidents that occurred during the period of cover, where future additional expenditure is incurred by ComCare."]
[null,"DOPEX0301D","Opening balance (the carrying amount at the beginning of the period)",null,{"$f":"'[1]3.2.3 Provisions'!E76+'[2]3.2.3 Provisions'!E76","v":2962521}]
[null,null,"Additional provisions made in the period, including increases to existing provisions"]
[null,"DOPEX0302D","Opex component",null,{"$f":"'[1]3.2.3 Provisions'!E78+'[2]3.2.3 Provisions'!E78","v":461211}]
[null,"DOPEX0303D","Capex component",null,{"$f":"'[1]3.2.3 Provisions'!E79+'[2]3.2.3 Provisions'!E79","v":0}]
[null,"DOPEX0304D","Other component",null,{"$f":"'[1]3.2.3 Provisions'!E80+'[2]3.2.3 Provisions'!E80","v":0}]
[null,null,"Amounts used (that is, incurred and charged against the provision) during the period"]
[null,"DOPEX0305D","Opex component",null,{"$f":"'[1]3.2.3 Provisions'!E82+'[2]3.2.3 Provisions'!E82","v":0}]
[null,"DOPEX0306D","Capex component",null,{"$f":"'[1]3.2.3 Provisions'!E83+'[2]3.2.3 Provisions'!E83","v":0}]
[null,"DOPEX0307D","Other component",null,{"$f":"'[1]3.2.3 Provisions'!E84+'[2]3.2.3 Provisions'!E84","v":0}]
[null,null,"Unused amounts reversed during the period"]
[null,"DOPEX0308D","Opex component",null,{"$f":"'[1]3.2.3 Provisions'!E86+'[2]3.2.3 Provisions'!E86","v":0}]
[null,"DOPEX0309D","Capex component",null,{"$f":"'[1]3.2.3 Provisions'!E87+'[2]3.2.3 Provisions'!E87","v":0}]
[null,"DOPEX0310D","Other component",null,{"$f":"'[1]3.2.3 Provisions'!E88+'[2]3.2.3 Provisions'!E88","v":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,"DOPEX0311D","Opex component",null,{"$f":"'[1]3.2.3 Provisions'!E90+'[2]3.2.3 Provisions'!E90","v":-469756}]
[null,"DOPEX0312D","Capex component",null,{"$f":"'[1]3.2.3 Provisions'!E91+'[2]3.2.3 Provisions'!E91","v":0}]
[null,"DOPEX0313D","Other component",null,{"$f":"'[1]3.2.3 Provisions'!E92+'[2]3.2.3 Provisions'!E92","v":0}]
[null,"DOPEX0314D","Closing balance (carrying amount at the end of the period)",null,{"$f":"'[1]3.2.3 Provisions'!E93+'[2]3.2.3 Provisions'!E93","v":2953975}]
[null,"DOPEX03E","Transmission use of System refund to customers "]
[null,null,"Provision for Transmission use of System refund to customers "]
[null,"DOPEX0301E","Opening balance (the carrying amount at the beginning of the period)",null,{"$f":"'[1]3.2.3 Provisions'!E96","v":0}]
[null,null,"Additional provisions made in the period, including increases to existing provisions"]
[null,"DOPEX0302E","Opex component",null,{"$f":"'[1]3.2.3 Provisions'!E98","v":0}]
[null,"DOPEX0303E","Capex component",null,{"$f":"'[1]3.2.3 Provisions'!E99","v":0}]
[null,"DOPEX0304E","Other component",null,{"$f":"'[1]3.2.3 Provisions'!E100","v":0}]
[null,null,"Amounts used (that is, incurred and charged against the provision) during the period"]
[null,"DOPEX0305E","Opex component",null,{"$f":"'[1]3.2.3 Provisions'!E102","v":0}]
[null,"DOPEX0306E","Capex component",null,{"$f":"'[1]3.2.3 Provisions'!E103","v":0}]
[null,"DOPEX0307E","Other component",null,{"$f":"'[1]3.2.3 Provisions'!E104","v":0}]
[null,null,"Unused amounts reversed during the period"]
[null,"DOPEX0308E","Opex component",null,{"$f":"'[1]3.2.3 Provisions'!E106","v":0}]
[null,"DOPEX0309E","Capex component",null,{"$f":"'[1]3.2.3 Provisions'!E107","v":0}]
[null,"DOPEX0310E","Other component",null,{"$f":"'[1]3.2.3 Provisions'!E108","v":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,"DOPEX0311E","Opex component",null,{"$f":"'[1]3.2.3 Provisions'!E110","v":0}]
[null,"DOPEX0312E","Capex component",null,{"$f":"'[1]3.2.3 Provisions'!E111","v":0}]
[null,"DOPEX0313E","Other component",null,{"$f":"'[1]3.2.3 Provisions'!E112","v":0}]
[null,"DOPEX0314E","Closing balance (carrying amount at the end of the period)",null,{"$f":"'[1]3.2.3 Provisions'!E113","v":0}]
[null,"DOPEX03F","Provision name"]
[null,null,"Brief description of provision"]
[null,"DOPEX0301F","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,"DOPEX0302F","Opex component"]
[null,"DOPEX0303F","Capex component"]
[null,"DOPEX0304F","Other component"]
[null,null,"Amounts used (that is, incurred and charged against the provision) during the period"]
[null,"DOPEX0305F","Opex component"]
[null,"DOPEX0306F","Capex component"]
[null,"DOPEX0307F","Other component"]
[null,null,"Unused amounts reversed during the period"]
[null,"DOPEX0308F","Opex component"]
[null,"DOPEX0309F","Capex component"]
[null,"DOPEX0310F","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,"DOPEX0311F","Opex component"]
[null,"DOPEX0312F","Capex component"]
[null,"DOPEX0313F","Other component"]
[null,"DOPEX0314F","Closing balance (carrying amount at the end of the period)"]
[null,"DOPEX03G","Provision name"]
[null,null,"Brief description of provision"]
[null,"DOPEX0301G","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,"DOPEX0302G","Opex component"]
[null,"DOPEX0303G","Capex component"]
[null,"DOPEX0304G","Other component"]
[null,null,"Amounts used (that is, incurred and charged against the provision) during the period"]
[null,"DOPEX0305G","Opex component"]
[null,"DOPEX0306G","Capex component"]
[null,"DOPEX0307G","Other component"]
[null,null,"Unused amounts reversed during the period"]
[null,"DOPEX0308G","Opex component"]
[null,"DOPEX0309G","Capex component"]
[null,"DOPEX0310G","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,"DOPEX0311G","Opex component"]
[null,"DOPEX0312G","Capex component"]
[null,"DOPEX0313G","Other component"]
[null,"DOPEX0314G","Closing balance (carrying amount at the end of the period)"]
[null,"DOPEX03H","Provision name"]
[null,null,"Brief description of provision"]
[null,"DOPEX0301H","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,"DOPEX0302H","Opex component"]
[null,"DOPEX0303H","Capex component"]
[null,"DOPEX0304H","Other component"]
[null,null,"Amounts used (that is, incurred and charged against the provision) during the period"]
[null,"DOPEX0305H","Opex component"]
[null,"DOPEX0306H","Capex component"]
[null,"DOPEX0307H","Other component"]
[null,null,"Unused amounts reversed during the period"]
[null,"DOPEX0308H","Opex component"]
[null,"DOPEX0309H","Capex component"]
[null,"DOPEX0310H","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,"DOPEX0311H","Opex component"]
[null,"DOPEX0312H","Capex component"]
[null,"DOPEX0313H","Other component"]
[null,"DOPEX0314H","Closing balance (carrying amount at the end of the period)"]
[null,"DOPEX03I","Provision name"]
[null,null,"Brief description of provision"]
[null,"DOPEX0301I","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,"DOPEX0302I","Opex component"]
[null,"DOPEX0303I","Capex component"]
[null,"DOPEX0304I","Other component"]
[null,null,"Amounts used (that is, incurred and charged against the provision) during the period"]
[null,"DOPEX0305I","Opex component"]
[null,"DOPEX0306I","Capex component"]
[null,"DOPEX0307I","Other component"]
[null,null,"Unused amounts reversed during the period"]
[null,"DOPEX0308I","Opex component"]
[null,"DOPEX0309I","Capex component"]
[null,"DOPEX0310I","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,"DOPEX0311I","Opex component"]
[null,"DOPEX0312I","Capex component"]
[null,"DOPEX0313I","Other component"]
[null,"DOPEX0314I","Closing balance (carrying amount at the end of the period)"]
[null,"DOPEX03J","Provision name"]
[null,null,"Brief description of provision"]
[null,"DOPEX0301J","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,"DOPEX0302J","Opex component"]
[null,"DOPEX0303J","Capex component"]
[null,"DOPEX0304J","Other component"]
[null,null,"Amounts used (that is, incurred and charged against the provision) during the period"]
[null,"DOPEX0305J","Opex component"]
[null,"DOPEX0306J","Capex component"]
[null,"DOPEX0307J","Other component"]
[null,null,"Unused amounts reversed during the period"]
[null,"DOPEX0308J","Opex component"]
[null,"DOPEX0309J","Capex component"]
[null,"DOPEX0310J","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,"DOPEX0311J","Opex component"]
[null,"DOPEX0312J","Capex component"]
[null,"DOPEX0313J","Other component"]
[null,"DOPEX0314J","Closing balance (carrying amount at the end of the period)"]
[null,"DOPEX03K","Provision name"]
[null,null,"Brief description of provision"]
[null,"DOPEX0301K","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,"DOPEX0302K","Opex component"]
[null,"DOPEX0303K","Capex component"]
[null,"DOPEX0304K","Other component"]
[null,null,"Amounts used (that is, incurred and charged against the provision) during the period"]
[null,"DOPEX0305K","Opex component"]
[null,"DOPEX0306K","Capex component"]
[null,"DOPEX0307K","Other component"]
[null,null,"Unused amounts reversed during the period"]
[null,"DOPEX0308K","Opex component"]
[null,"DOPEX0309K","Capex component"]
[null,"DOPEX0310K","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,"DOPEX0311K","Opex component"]
[null,"DOPEX0312K","Capex component"]
[null,"DOPEX0313K","Other component"]
[null,"DOPEX0314K","Closing balance (carrying amount at the end of the period)"]
[null,"DOPEX03L","Provision name"]
[null,null,"Brief description of provision"]
[null,"DOPEX0301L","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,"DOPEX0302L","Opex component"]
[null,"DOPEX0303L","Capex component"]
[null,"DOPEX0304L","Other component"]
[null,null,"Amounts used (that is, incurred and charged against the provision) during the period"]
[null,"DOPEX0305L","Opex component"]
[null,"DOPEX0306L","Capex component"]
[null,"DOPEX0307L","Other component"]
[null,null,"Unused amounts reversed during the period"]
[null,"DOPEX0308L","Opex component"]
[null,"DOPEX0309L","Capex component"]
[null,"DOPEX0310L","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,"DOPEX0311L","Opex component"]
[null,"DOPEX0312L","Capex component"]
[null,"DOPEX0313L","Other component"]
[null,"DOPEX0314L","Closing balance (carrying amount at the end of the period)"]
[null,"DOPEX03M","Provision name"]
[null,null,"Brief description of provision"]
[null,"DOPEX0301M","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,"DOPEX0302M","Opex component"]
[null,"DOPEX0303M","Capex component"]
[null,"DOPEX0304M","Other component"]
[null,null,"Amounts used (that is, incurred and charged against the provision) during the period"]
[null,"DOPEX0305M","Opex component"]
[null,"DOPEX0306M","Capex component"]
[null,"DOPEX0307M","Other component"]
[null,null,"Unused amounts reversed during the period"]
[null,"DOPEX0308M","Opex component"]
[null,"DOPEX0309M","Capex component"]
[null,"DOPEX0310M","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,"DOPEX0311M","Opex component"]
[null,"DOPEX0312M","Capex component"]
[null,"DOPEX0313M","Other component"]
[null,"DOPEX0314M","Closing balance (carrying amount at the end of the period)"]
[null,"DOPEX03N","Provision name"]
[null,null,"Brief description of provision"]
[null,"DOPEX0301N","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,"DOPEX0302N","Opex component"]
[null,"DOPEX0303N","Capex component"]
[null,"DOPEX0304N","Other component"]
[null,null,"Amounts used (that is, incurred and charged against the provision) during the period"]
[null,"DOPEX0305N","Opex component"]
[null,"DOPEX0306N","Capex component"]
[null,"DOPEX0307N","Other component"]
[null,null,"Unused amounts reversed during the period"]
[null,"DOPEX0308N","Opex component"]
[null,"DOPEX0309N","Capex component"]
[null,"DOPEX0310N","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,"DOPEX0311N","Opex component"]
[null,"DOPEX0312N","Capex component"]
[null,"DOPEX0313N","Other component"]
[null,"DOPEX0314N","Closing balance (carrying amount at the end of the period)"]
[null,"DOPEX03O","Provision name"]
[null,null,"Brief description of provision"]
[null,"DOPEX0301O","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,"DOPEX0302O","Opex component"]
[null,"DOPEX0303O","Capex component"]
[null,"DOPEX0304O","Other component"]
[null,null,"Amounts used (that is, incurred and charged against the provision) during the period"]
[null,"DOPEX0305O","Opex component"]
[null,"DOPEX0306O","Capex component"]
[null,"DOPEX0307O","Other component"]
[null,null,"Unused amounts reversed during the period"]
[null,"DOPEX0308O","Opex component"]
[null,"DOPEX0309O","Capex component"]
[null,"DOPEX0310O","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,"DOPEX0311O","Opex component"]
[null,"DOPEX0312O","Capex component"]
[null,"DOPEX0313O","Other component"]
[null,"DOPEX0314O","Closing balance (carrying amount at the end of the period)"]
[null,"DOPEX03P","Provision name"]
[null,null,"Brief description of provision"]
[null,"DOPEX0301P","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,"DOPEX0302P","Opex component"]
[null,"DOPEX0303P","Capex component"]
[null,"DOPEX0304P","Other component"]
[null,null,"Amounts used (that is, incurred and charged against the provision) during the period"]
[null,"DOPEX0305P","Opex component"]
[null,"DOPEX0306P","Capex component"]
[null,"DOPEX0307P","Other component"]
[null,null,"Unused amounts reversed during the period"]
[null,"DOPEX0308P","Opex component"]
[null,"DOPEX0309P","Capex component"]
[null,"DOPEX0310P","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,"DOPEX0311P","Opex component"]
[null,"DOPEX0312P","Capex component"]
[null,"DOPEX0313P","Other component"]
[null,"DOPEX0314P","Closing balance (carrying amount at the end of the period)"]
[null,"DOPEX03Q","Provision name"]
[null,null,"Brief description of provision"]
[null,"DOPEX0301Q","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,"DOPEX0302Q","Opex component"]
[null,"DOPEX0303Q","Capex component"]
[null,"DOPEX0304Q","Other component"]
[null,null,"Amounts used (that is, incurred and charged against the provision) during the period"]
[null,"DOPEX0305Q","Opex component"]
[null,"DOPEX0306Q","Capex component"]
[null,"DOPEX0307Q","Other component"]
[null,null,"Unused amounts reversed during the period"]
[null,"DOPEX0308Q","Opex component"]
[null,"DOPEX0309Q","Capex component"]
[null,"DOPEX0310Q","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,"DOPEX0311Q","Opex component"]
[null,"DOPEX0312Q","Capex component"]
[null,"DOPEX0313Q","Other component"]
[null,"DOPEX0314Q","Closing balance (carrying amount at the end of the period)"]
[null,"DOPEX03R","Provision name"]
[null,null,"Brief description of provision"]
[null,"DOPEX0301R","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,"DOPEX0302R","Opex component"]
[null,"DOPEX0303R","Capex component"]
[null,"DOPEX0304R","Other component"]
[null,null,"Amounts used (that is, incurred and charged against the provision) during the period"]
[null,"DOPEX0305R","Opex component"]
[null,"DOPEX0306R","Capex component"]
[null,"DOPEX0307R","Other component"]
[null,null,"Unused amounts reversed during the period"]
[null,"DOPEX0308R","Opex component"]
[null,"DOPEX0309R","Capex component"]
[null,"DOPEX0310R","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,"DOPEX0311R","Opex component"]
[null,"DOPEX0312R","Capex component"]
[null,"DOPEX0313R","Other component"]
[null,"DOPEX0314R","Closing balance (carrying amount at the end of the period)"]

{"sheet":"3.3 Assets (RAB)","index":5,"n_rows":137,"n_cols":7,"rows_kept":137,"cut":false,"hidden":false,"merged":[[115,4,115,6],[7,4,7,6]]}
[null,null,"REGULATORY REPORTING STATEMENT"]
[null,null,{"$f":"dms_TradingName","v":"ActewAGL Distribution"}]
[null,null,{"$f":"CONCATENATE(\"Benchmarking RIN response \",CRY)","v":"Benchmarking RIN response 2014-15"}]
[null,null,"3.3 ASSETS"]
[]
[]
[null,null,null,null,"Network services","Standard control services","Alternative control services"]
[null,null,null,null,"Actual\n($0's)"]
[null,null,null,null,{"$f":"CRY","v":"2014-15"},{"$f":"CRY","v":"2014-15"},{"$f":"CRY","v":"2014-15"}]
[]
[null,null,"TABLE 3.3.1 - REGULATORY ASSET BASE VALUES"]
[null,null,"For total asset base:"]
["ED_RAB331_00001","DRAB0101","Opening value",null,846577353.10725284,846577353.10725284,49992286.404922664]
["ED_RAB331_00002","DRAB0102","Inflation addition",null,21395175.73628122,21395175.73628122,1244807.9314825705]
["ED_RAB331_00003","DRAB0103","Straight line depreciation",null,-52051770.245617501,-52051770.245617501,-3033419.1083657793]
["ED_RAB331_00004","DRAB0104","Regulatory depreciation",null,-30656594.509336282,-30656594.509336282,-1788611.1768832088]
["ED_RAB331_00005","DRAB0105","Actual additions (recognised in RAB)",null,75556477.901482075,75556477.901482075,5068340.9611865636]
["ED_RAB331_00006","DRAB0106","Disposals ",null,0,0,0]
["ED_RAB331_00007","DRAB0107","Closing value for overhead distribution asset value",null,891477236.49939871,891477236.49939871,53272016.189226016]
[]
[null,null,"TABLE 3.3.2 - ASSET VALUE ROLL FORWARD"]
[null,null,"For overhead network assets less than 33kV:"]
["ED_RAB3321_00001","DRAB0201","Opening value",null,175854143.78816286,175854143.78816286,0]
["ED_RAB3321_00002","DRAB0202","Inflation addition",null,4452448.3880651724,4452448.3880651724,0]
["ED_RAB3321_00003","DRAB0203","Straight line depreciation",null,-8836016.7006935719,-8836016.7006935719,0]
["ED_RAB3321_00004","DRAB0204","Regulatory depreciation",null,-4383568.3126283996,-4383568.3126283996,0]
["ED_RAB3321_00005","DRAB0205","Actual additions (recognised in RAB)",null,20426123.268740304,20426123.268740304,0]
["ED_RAB3321_00006","DRAB0206","Disposals ",null,0,0,0]
["ED_RAB3321_00007","DRAB0207","Closing value for overhead distribution asset value",null,191896698.74427474,191896698.74427474,0]
[null,null,"For underground network assets less than 33kV:"]
["ED_RAB3322_00001","DRAB0301","Opening value",null,268778742.37643707,268778742.37643707,0]
["ED_RAB3322_00002","DRAB0302","Inflation addition",null,6816734.0275371633,6816734.0275371633,0]
["ED_RAB3322_00003","DRAB0303","Straight line depreciation",null,-12021616.531672666,-12021616.531672666,0]
["ED_RAB3322_00004","DRAB0304","Regulatory depreciation",null,-5204882.5041355025,-5204882.5041355025,0]
["ED_RAB3322_00005","DRAB0305","Actual additions (recognised in RAB)",null,12825645.390257275,12825645.390257275,0]
["ED_RAB3322_00006","DRAB0306","Disposals ",null,0,0,0]
["ED_RAB3322_00007","DRAB0307","Closing value for underground asset value",null,276399505.26255888,276399505.26255888,0]
[null,null,"For distribution substations and transformers:"]
["ED_RAB3323_00001","DRAB0401","Opening value",null,170044690.55366459,170044690.55366459,0]
["ED_RAB3323_00002","DRAB0402","Inflation addition",null,4309336.4641670138,4309336.4641670138,0]
["ED_RAB3323_00003","DRAB0403","Straight line depreciation",null,-10886802.843549056,-10886802.843549056,0]
["ED_RAB3323_00004","DRAB0404","Regulatory depreciation",null,-6577466.3793820422,-6577466.3793820422,0]
["ED_RAB3323_00005","DRAB0405","Actual additions (recognised in RAB)",null,6880614.3659712356,6880614.3659712356,0]
["ED_RAB3323_00006","DRAB0406","Disposals ",null,0,0,0]
["ED_RAB3323_00007","DRAB0407","Closing value for distribution substations and transformers asset value",null,170347838.54025382,170347838.54025382,0]
[null,null,"For overhead network assets 33kV and above:"]
["ED_RAB3324_00001","DRAB0501","Opening value",null,52162901.46327769,52162901.46327769,0]
["ED_RAB3324_00002","DRAB0502","Inflation addition",null,1313651.3398382585,1313651.3398382585,0]
["ED_RAB3324_00003","DRAB0503","Straight line depreciation",null,-2655305.6474642833,-2655305.6474642833,0]
["ED_RAB3324_00004","DRAB0504","Regulatory depreciation",null,-1341654.3076260248,-1341654.3076260248,0]
["ED_RAB3324_00005","DRAB0505","Actual additions (recognised in RAB)",null,790715.87375234033,790715.87375234033,0]
["ED_RAB3324_00006","DRAB0506","Disposals ",null,0,0,0]
["ED_RAB3324_00007","DRAB0507","Closing value for overhead asset 33kV and above value",null,51611963.029404007,51611963.029404007,0]
[null,null,"For underground network assets 33kV and above:"]
["ED_RAB3325_00001","DRAB0601","Opening value",null,615239.87743639317,615239.87743639317,0]
["ED_RAB3325_00002","DRAB0602","Inflation addition",null,15710.668596211817,15710.668596211817,0]
["ED_RAB3325_00003","DRAB0603","Straight line depreciation",null,-33769.708641299301,-33769.708641299301,0]
["ED_RAB3325_00004","DRAB0604","Regulatory depreciation",null,-18059.040045087484,-18059.040045087484,0]
["ED_RAB3325_00005","DRAB0605","Actual additions (recognised in RAB)",null,0,0,0]
["ED_RAB3325_00006","DRAB0606","Disposals ",null,0,0,0]
["ED_RAB3325_00007","DRAB0607","Closing value for underground asset 33kV and above value",null,597180.83739130571,597180.83739130571,0]
[null,null,"Zone substations and transformers"]
["ED_RAB3326_00001","DRAB0701","Opening value",null,72332607.708104685,72332607.708104685,0]
["ED_RAB3326_00002","DRAB0702","Inflation addition",null,1814009.7739228725,1814009.7739228725,0]
["ED_RAB3326_00003","DRAB0703","Straight line depreciation",null,-3012046.0968080675,-3012046.0968080675,0]
["ED_RAB3326_00004","DRAB0704","Regulatory depreciation",null,-1198036.322885195,-1198036.322885195,0]
["ED_RAB3326_00005","DRAB0705","Actual additions (recognised in RAB)",null,4264665.6454983158,4264665.6454983158,0]
["ED_RAB3326_00006","DRAB0706","Disposals ",null,0,0,0]
["ED_RAB3326_00007","DRAB0707","Closing value for zone substations and transformers",null,75399237.03071782,75399237.03071782,0]
[null,null,"For easements:"]
["ED_RAB3327_00001","DRAB0801","Opening value"]
["ED_RAB3327_00002","DRAB0802","Inflation addition"]
["ED_RAB3327_00003","DRAB0805","Actual additions (recognised in RAB)"]
["ED_RAB3327_00004","DRAB0806","Disposals "]
["ED_RAB3327_00005","DRAB0807","Closing value for easements asset value",null,0,0,0]
[null,null,"For meters:"]
["ED_RAB3328_00001","DRAB0901","Opening value",null,0,0,49992286.404922664]
["ED_RAB3328_00002","DRAB0902","Inflation addition",null,0,0,1244807.9314825705]
["ED_RAB3328_00003","DRAB0903","Straight line depreciation",null,0,0,-3033419.1083657793]
["ED_RAB3328_00004","DRAB0904","Regulatory depreciation",null,0,0,-1788611.1768832088]
["ED_RAB3328_00005","DRAB0905","Actual additions (recognised in RAB)",null,0,0,5068340.9611865636]
["ED_RAB3328_00006","DRAB0906","Disposals ",null,0,0,0]
["ED_RAB3328_00007","DRAB0907","Closing value for meters asset value",null,0,0,53272016.189226016]
[null,null,"For “other” asset items with long lives:"]
["ED_RAB3329_00001","DRAB1001","Opening value",null,73441256.387339294,73441256.387339294,0]
["ED_RAB3329_00002","DRAB1002","Inflation addition",null,1837888.1871474925,1837888.1871474925,0]
["ED_RAB3329_00003","DRAB1003","Straight line depreciation",null,-4778032.4589847485,-4778032.4589847485,0]
["ED_RAB3329_00004","DRAB1004","Regulatory depreciation",null,-2940144.2718372559,-2940144.2718372559,0]
["ED_RAB3329_00005","DRAB1005","Actual additions (recognised in RAB)",null,22707907.692089483,22707907.692089483,0]
["ED_RAB3329_00006","DRAB1006","Disposals ",null,0,0,0]
["ED_RAB3329_00007","DRAB1007","Closing value for “other” asset (long life) value",null,93209019.807591528,93209019.807591528,0]
[null,null,"For “other” asset items with short lives:"]
["ED_RAB33210_00001","DRAB1101","Opening value",null,33347770.952830389,33347770.952830389,0]
["ED_RAB33210_00002","DRAB1102","Inflation addition",null,835396.88700703718,835396.88700703718,0]
["ED_RAB33210_00003","DRAB1103","Straight line depreciation",null,-9828180.2578038089,-9828180.2578038089,0]
["ED_RAB33210_00004","DRAB1104","Regulatory depreciation",null,-8992783.3707967717,-8992783.3707967717,0]
["ED_RAB33210_00005","DRAB1105","Actual additions (recognised in RAB)",null,7682970.5286531802,7682970.5286531802,0]
["ED_RAB33210_00006","DRAB1106","Disposals ",null,0,0,0]
["ED_RAB33210_00007","DRAB1107","Closing value for “other” asset (short life) value",null,32037958.110686794,32037958.110686794,0]
[]
[null,null,"TABLE 3.3.3 - TOTAL DISAGGREGATED RAB ASSET VALUES"]
["ED_RAB333_00001","DRAB1201","Overhead distribution assets (wires and poles)",null,183875421.26621878,183875421.26621878,0]
["ED_RAB333_00002","DRAB1202","Underground distribution assets (cables, ducts etc)",null,272589123.81949794,272589123.81949794,0]
["ED_RAB333_00003","DRAB1203","Distribution substations including transformers",null,170196264.54695922,170196264.54695922,0]
["ED_RAB333_00004","DRAB1204","Overhead assets 33kV and above (wires and towers / poles etc)",null,51887432.246340849,51887432.246340849,0]
["ED_RAB333_00005","DRAB1205","Underground assets 33kV and above (cables, ducts etc)",null,606210.35741384944,606210.35741384944,0]
["ED_RAB333_00006","DRAB1206","Zone substations",null,73865922.36941126,73865922.36941126,0]
["ED_RAB333_00007","DRAB1207","Easements "]
["ED_RAB333_00008","DRAB1208","Meters",null,0,0,51632151.29707434]
["ED_RAB333_00009","DRAB1209","Other assets with long lives (please specify)",null,83325138.097465411,83325138.097465411,0]
["ED_RAB333_00010","DRAB1210","Other assets with short lives (please specify)",null,32692864.531758592,32692864.531758592,0]
[]
[null,null,"Capital Contributions"]
["ED_RAB333_00011","DRAB13","Value of Capital Contributions or Contributed Assets ",null,0,6728137.6851685522,0]
[]
[null,null,"TABLE 3.3.4 - ASSET LIVES",null,"Service Life (Years)"]
[null,null,"Table 3.3.4.1 Asset Lives – estimated service life of new assets",null,{"$f":"CRY","v":"2014-15"},{"$f":"CRY","v":"2014-15"},{"$f":"CRY","v":"2014-15"}]
["ED_RAB3341_00001","DRAB1401","Overhead network assets less than 33kV (wires and poles)",null,62,62,0]
["ED_RAB3341_00002","DRAB1402","Underground network assets less than 33kV (cables)",null,48,48,0]
["ED_RAB3341_00003","DRAB1403","Distribution substations including transformers",null,72.8,72.8,0]
["ED_RAB3341_00004","DRAB1404","Overhead network assets 33kV and above (wires and towers / poles etc) ",null,60,60,0]
["ED_RAB3341_00005","DRAB1405","Underground network assets 33kV and above(cables, ducts etc)",null,50,50,0]
["ED_RAB3341_00006","DRAB1406","Zone substations and transformers",null,46.1,46.1,0]
["ED_RAB3341_00007","DRAB1407","Meters",null,0,0,20]
["ED_RAB3341_00008","DRAB1408","“Other” assets with long lives",null,10.475705365176744,10.475705365176744,0]
["ED_RAB3341_00009","DRAB1409","“Other” assets with short lives",null,6.495558913719214,6.495558913719214,0]
[]
[null,null,"Table 3.3.4.2 Asset Lives – estimated residual service life"]
["ED_RAB3342_00001","DRAB1501","Overhead network assets less than 33kV (wires and poles)",null,28.223645451562305,28.223645451562305,0]
["ED_RAB3342_00002","DRAB1502","Underground network assets less than 33kV (cables)",null,21.425794116952755,21.425794116952755,0]
["ED_RAB3342_00003","DRAB1503","Distribution substations including transformers",null,48.275956364753711,48.275956364753711,0]
["ED_RAB3342_00004","DRAB1504","Overhead network assets 33kV and above (wires and towers / poles etc) ",null,25.946164036487254,25.946164036487254,0]
["ED_RAB3342_00005","DRAB1505","Underground network assets 33kV and above (cables, ducts etc)",null,42.791476761607207,42.791476761607207,0]
["ED_RAB3342_00006","DRAB1506","Zone substations and transformers",null,21.127006851865545,21.127006851865545,0]
["ED_RAB3342_00007","DRAB1507","Meters",null,0,0,14.07]
["ED_RAB3342_00008","DRAB1508","“Other” assets with long lives",null,22.156751016690706,22.156751016690706,0]
["ED_RAB3342_00009","DRAB1509","“Other” assets with short lives",null,4.0792295591315497,4.0792295591315497,0]

{"sheet":"3.4 Operational data","index":6,"n_rows":130,"n_cols":5,"rows_kept":130,"cut":false,"hidden":false,"merged":[]}
[null,null,"REGULATORY REPORTING STATEMENT"]
[null,null,{"$f":"dms_TradingName","v":"ActewAGL Distribution"}]
[null,null,{"$f":"CONCATENATE(\"Benchmarking RIN response \",CRY)","v":"Benchmarking RIN response 2014-15"}]
[null,null,"3.4 OPERATIONAL DATA"]
[]
[]
[null,null,null,null,"Standard control services"]
[null,null,null,null,"Actual"]
[null,null,null,null,{"$f":"CRY","v":"2014-15"}]
[null,null,null,"Unit"]
[null,null,"TABLE 3.4.1 - ENERGY DELIVERY"]
["ED_OPD3410_00001","DOPED01","Total energy delivered","GWh",2856.06]
[]
[]
[null,null,"Table 3.4.1.1 Energy grouping - delivery by chargeable quantity"]
["ED_OPD3411_00001","DOPED0201","Energy Delivery where time of use is not a determinant","GWh",1371.152]
["ED_OPD3411_00002","DOPED0202","Energy Delivery at On-peak times","GWh",549.82399999999996]
["ED_OPD3411_00003","DOPED0203","Energy Delivery at Shoulder times ","GWh",205.136]
["ED_OPD3411_00004","DOPED0204","Energy Delivery at Off-peak times","GWh",633.84900000000005]
["ED_OPD3411_00005","DOPED0205","Controlled load energy deliveries","GWh",94.576999999999998]
["ED_OPD3411_00005","DOPED0206","Energy Delivery to unmetered supplies","GWh",1.522]
[]
[null,null,"Table 3.4.1.2 Energy - received from TNSP and other DNSPs by time of receipt"]
["ED_OPD3412_00001","DOPED0301","Energy into DNSP network  at On-peak times","GWh",523.27499999999998]
["ED_OPD3412_00002","DOPED0302","Energy into DNSP network  at Shoulder times ","GWh",968.56299999999999]
["ED_OPD3412_00003","DOPED0303","Energy into DNSP network  at Off-peak times","GWh",1382.6959999999999]
["ED_OPD3412_00004","DOPED0304","Energy received from TNSP and other DNSPs not included in the above categories","GWh",0]
[]
[null,null,"Table 3.4.1.3 Energy - received into DNSP system from embedded generation by time of receipt"]
["ED_OPD3413_00001","DOPED0401","Energy into DNSP network  at On-peak times from non-residential embedded generation","GWh",2.5680000000000001]
["ED_OPD3413_00002","DOPED0402","Energy into DNSP network  at Shoulder times from non-residential embedded generation","GWh",20.763999999999999]
["ED_OPD3413_00003","DOPED0403","Energy into DNSP network  at Off-peak times from non-residential embedded generation","GWh",10.111000000000001]
["ED_OPD3413_00004","DOPED0404","Energy received from embedded generation not included in above categories from non-residential embedded generation","GWh",23.805]
["ED_OPD3413_00005","DOPED0405","Energy into DNSP network  at On-peak times from residential embedded generation","GWh",0]
["ED_OPD3413_00006","DOPED0406","Energy into DNSP network  at Shoulder times from residential embedded generation","GWh",0]
["ED_OPD3413_00007","DOPED0407","Energy into DNSP network  at Off-peak times from residential embedded generation","GWh",0]
["ED_OPD3413_00008","DOPED0408","Energy received from embedded generation not included in above categories from residential embedded generation","GWh",56.302999999999997]
[]
[null,null,"Table 3.4.1.4 Energy grouping  - customer type or class"]
["ED_OPD3414_00001","DOPED0501","Residential customers energy deliveries","GWh",1154.8399999999999]
["ED_OPD3414_00002","DOPED0502","Non residential customers not on demand tariffs energy deliveries","GWh",440.262]
["ED_OPD3414_00003","DOPED0503","Non-residential low voltage demand tariff customers energy deliveries","GWh",890.03300000000002]
["ED_OPD3414_00004","DOPED0504","Non-residential high voltage demand tariff customers energy deliveries","GWh",370.92500000000001]
["ED_OPD3414_00005","DOPED0505","Other Customer Class Energy Deliveries","GWh",0]
[]
[null,null,"TABLE 3.4.2 -  CUSTOMER NUMBERS"]
[null,null,"Table 3.4.2.1 Distribution customer numbers by customer type or class"]
["ED_OPD3421_00001","DOPCN0101","Residential customer numbers","number",163664]
["ED_OPD3421_00002","DOPCN0102","Non residential customers not on demand tariff customer numbers","number",14028]
["ED_OPD3421_00003","DOPCN0103","Low voltage demand tariff customer numbers","number",1867]
["ED_OPD3421_00004","DOPCN0104","High voltage demand tariff customer numbers","number",25]
["ED_OPD3421_00005","DOPCN0105","Unmetered Customer Numbers","number",23]
["ED_OPD3421_00006","DOPCN0106","Other Customer Numbers","number",2244]
["ED_OPD3421_99999","DOPCN01","Total customer numbers","number",181851]
[]
[null,null,"Table 3.4.2.2 Distribution customer numbers by location on the network"]
["ED_OPD3422_00001","DOPCN0201","Customers on CBD network","number",0]
["ED_OPD3422_00002","DOPCN0202","Customers on Urban network","number",122462]
["ED_OPD3422_00003","DOPCN0203","Customers on Short rural network","number",59264]
["ED_OPD3422_00004","DOPCN0204","Customers on Long rural network","number",0]
["ED_OPD3422_99999","DOPCN02","Total customer numbers","number",181726]
[]
[null,null,"Table 3.4.2.3 Distribution customer numbers by Aurora Feeder categories (Aurora only)"]
["ED_OPD3423_00001",null,"Critical Infrastructure","number",0]
["ED_OPD3423_00002",null,"High Density Commercial","number",0]
["ED_OPD3423_00003",null,"Urban","number",0]
["ED_OPD3423_00004",null,"High Density Rural","number",0]
["ED_OPD3423_00005",null,"Low Density Rural","number",0]
["ED_OPD3423_99999",null,"Total customer numbers","number",0]
[]
[null,null,"Table 3.4.2.4 Unmetered Supply (Aurora only)"]
["ED_OPD3424_00001","DOPCN0301","Number of unmetered connections reported in customer numbers in the economic benchmarking RIN","number",0]
["ED_OPD3424_00002","DOPCN0302","Unmetered connections not reported in customer numbers in the economic benchmarking RIN","number",0]
["ED_OPD3424_99999","DOPCN0303","Total unmetered connections","number",0]
[]
[null,null,"TABLE 3.4.3 - SYSTEM DEMAND"]
[null,null,"Table 3.4.3.1 Annual system maximum demand characteristics at the zone substation level – MW measure"]
["ED_OPD3431_00001","DOPSD0101","Non-coincident Summated Raw System Annual Maximum Demand","MW ",630.471]
["ED_OPD3431_00002","DOPSD0102","Non–coincident Summated Weather Adjusted System Annual Maximum Demand 10% POE","MW ",649.54300000000001]
["ED_OPD3431_00003","DOPSD0103","Non–coincident Summated Weather Adjusted System Annual Maximum Demand 50% POE","MW ",626.27]
["ED_OPD3431_00004","DOPSD0104","Coincident Raw System Annual Maximum Demand","MW ",566.31700000000001]
["ED_OPD3431_00005","DOPSD0105","Coincident Weather Adjusted System Annual Maximum Demand 10% POE","MW ",591.69000000000005]
["ED_OPD3431_00006","DOPSD0106","Coincident Weather Adjusted System Annual Maximum Demand 50% POE","MW ",575.77200000000005]
[]
[null,null,"Table 3.4.3.2 Annual system maximum demand characteristics at the transmission connection point  – MW measure"]
["ED_OPD3432_00001","DOPSD0107","Non-coincident Summated Raw System Annual Maximum Demand","MW ",723.98900000000003]
["ED_OPD3432_00002","DOPSD0108","Non–coincident Summated Weather Adjusted System Annual Maximum Demand 10% POE","MW ",727.399]
["ED_OPD3432_00003","DOPSD0109","Non–coincident Summated Weather Adjusted System Annual Maximum Demand 50% POE","MW ",691.94299999999998]
["ED_OPD3432_00004","DOPSD0110","Coincident Raw System Annual Maximum Demand","MW ",591.94100000000003]
["ED_OPD3432_00005","DOPSD0111","Coincident Weather Adjusted System Annual Maximum Demand 10% POE","MW ",618.46400000000006]
["ED_OPD3432_00006","DOPSD0112","Coincident Weather Adjusted System Annual Maximum Demand 50% POE","MW ",601.82399999999996]
[]
[null,null,"Table 3.4.3.3 Annual system maximum demand characteristics at the zone substation level – MVA measure"]
["ED_OPD3433_00001","DOPSD0201","Non–coincident Summated Raw System Annual Maximum Demand"," MVA",654.41600000000005]
["ED_OPD3433_00002","DOPSD0202","Non–coincident Summated Weather Adjusted System Annual Maximum Demand 10% POE"," MVA",674.21199999999999]
["ED_OPD3433_00003","DOPSD0203","Non–coincident Summated Weather Adjusted System Annual Maximum Demand 50% POE"," MVA",649.92499999999995]
["ED_OPD3433_00004","DOPSD0204","Coincident Raw System Annual Maximum Demand"," MVA",593.73199999999997]
["ED_OPD3433_00005","DOPSD0205","Coincident Weather Adjusted System Annual Maximum Demand 10% POE"," MVA",620.33399999999995]
["ED_OPD3433_00006","DOPSD0206","Coincident Weather Adjusted System Annual Maximum Demand 50% POE"," MVA",603.64499999999998]
[]
[null,null,"Table 3.4.3.4 Annual system maximum demand characteristics at the transmission connection point – MVA measure"]
["ED_OPD3434_00001","DOPSD0207","Non–coincident Summated Raw System Annual Maximum Demand"," MVA",739.28899999999999]
["ED_OPD3434_00002","DOPSD0208","Non–coincident Summated Weather Adjusted System Annual Maximum Demand 10% POE"," MVA",742.82]
["ED_OPD3434_00003","DOPSD0209","Non–coincident Summated Weather Adjusted System Annual Maximum Demand 50% POE"," MVA",706.548]
["ED_OPD3434_00004","DOPSD0210","Coincident Raw System Annual Maximum Demand"," MVA",620.76499999999999]
["ED_OPD3434_00005","DOPSD0211","Coincident Weather Adjusted System Annual Maximum Demand 10% POE"," MVA",648.57799999999997]
["ED_OPD3434_00006","DOPSD0212","Coincident Weather Adjusted System Annual Maximum Demand 50% POE"," MVA",631.13]
[]
[null,null,"Table 3.4.3.5 Power factor conversion between MVA and MW"]
["ED_OPD3435_00001","DOPSD0301","Average overall network power factor conversion between MVA and MW","Factor",0.98]
["ED_OPD3435_00002","DOPSD0302","Average power factor conversion for  low voltage distribution lines","Factor",0.99]
["ED_OPD3435_00003","DOPSD0303","Average power factor conversion for 3.3 kV lines","Factor",0]
["ED_OPD3435_00004","DOPSD0304","Average power factor conversion for 6.6 kV lines","Factor",0]
["ED_OPD3435_00005","DOPSD0305","Average power factor conversion for 7.6 kV lines","Factor",0]
["ED_OPD3435_00006","DOPSD0306","Average power factor conversion for 11 kV lines","Factor",0.97499999999999998]
["ED_OPD3435_00007","DOPSD0307","Average power factor conversion for SWER lines","Factor",0]
["ED_OPD3435_00008","DOPSD0308","Average power factor conversion for 22 kV lines","Factor",0.94]
["ED_OPD3435_00009","DOPSD0309","Average power factor conversion for 33 kV lines","Factor",0]
["ED_OPD3435_00010","DOPSD0310","Average power factor conversion for 44 kV lines","Factor",0]
["ED_OPD3435_00011","DOPSD0311","Average power factor conversion for 66 kV lines","Factor",0.97299999999999998]
["ED_OPD3435_00012","DOPSD0312","Average power factor conversion for 110 kV lines","Factor",0]
["ED_OPD3435_00013","DOPSD0313","Average power factor conversion for 132 kV lines","Factor",0.98]
["ED_OPD3435_00013","DOPSD0314","Average power factor conversion for 220 kV lines","Factor",0]
[]
[null,null,"Table 3.4.3.6 Demand supplied (for customers charged on this basis) – MW measure"]
["ED_OPD3436_00001","DOPSD0401","Summated Chargeable Contracted Maximum Demand","MW ",0]
["ED_OPD3436_00002","DOPSD0402","Summated Chargeable Measured Maximum Demand ","MW ",0]
[null,null,"Table 3.4.3.7 Demand supplied (for customers charged on this basis) – MVA measure"]
["ED_OPD3437_00001","DOPSD0403","Summated Chargeable Contracted Maximum Demand"," MVA",0]
["ED_OPD3437_00002","DOPSD0404","Summated Chargeable Measured Maximum Demand "," MVA",397327.875]

{"sheet":"3.5 Physical assets","index":7,"n_rows":95,"n_cols":5,"rows_kept":95,"cut":false,"hidden":false,"merged":[]}
[null,null,"REGULATORY REPORTING STATEMENT"]
[null,null,{"$f":"dms_TradingName","v":"ActewAGL Distribution"}]
[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 - NETWORK CAPACITIES"]
[null,null,"Circuit length"]
[null,null,"Table 3.5.1.1 Overhead network length of circuit at each voltage"]
["ED_PHA3511_00001","DPA0101","Overhead low voltage distribution","km",1169.163]
["ED_PHA3511_00002","DPA0102","Overhead 2.2 kV","km",0]
["ED_PHA3511_00003","DPA0103","Overhead 6.6kv","km",0]
["ED_PHA3511_00004","DPA0104","Overhead 7.6 kV","km",0]
["ED_PHA3511_00005","DPA0105","Overhead 11 kV","km",968.43899999999996]
["ED_PHA3511_00006","DPA0106","Overhead SWER","km",0]
["ED_PHA3511_00007","DPA0107","Overhead 22 kV","km",33.81]
["ED_PHA3511_00008","DPA0108","Overhead 33 kV","km",0]
["ED_PHA3511_00009","DPA0109","Overhead 44 kV","km",0]
["ED_PHA3511_00010","DPA0110","Overhead 66 kV","km",7.1559999999999997]
["ED_PHA3511_00011","DPA0111","Overhead 110kV","km",0]
["ED_PHA3511_00012","DPA0112","Overhead 132 kV","km",189.01900000000001]
["ED_PHA3511_00013","DPA0113","Overhead 220kV","km",0]
["ED_PHA3511_00014","DPA0114","Other ","km",0]
[null,"DPA01","Total overhead circuit km","km",2367.5869999999995]
[]
[null,null,"Table 3.5.1.2 Underground network circuit length at each voltage"]
["ED_PHA3512_00001","DPA0201","Underground low voltage distribution","km",1360.9169999999999]
["ED_PHA3512_00002","DPA0202","Underground 5 kV","km",0]
["ED_PHA3512_00003","DPA0203","Underground 6.6 Kv","km",0]
["ED_PHA3512_00004","DPA0204","Underground 7.6 kV","km",0]
["ED_PHA3512_00005","DPA0205","Underground 11 kV","km",1528.9190000000001]
["ED_PHA3512_00006","DPA0206","Underground SWER","km",0]
["ED_PHA3512_00007","DPA0207","Underground 22 kV","km",2.4620000000000002]
["ED_PHA3512_00008","DPA0208","Underground 33 kV","km",0]
["ED_PHA3512_00010","DPA0209","Underground 66 kV","km",0]
["ED_PHA3512_00009","DPA0210","Underground 110 kV","km",0]
["ED_PHA3512_00010","DPA0211","Underground 132 kV","km",6.0209999999999999]
["ED_PHA3512_00011","DPA0212","Other ","km",0.1]
[null,"DPA02","Total underground circuit km","km",2898.4190000000003]
[]
[null,null,"Circuit Capacity MVA"]
[null,null,"Table 3.5.1.3 Estimated overhead network weighted average MVA capacity by voltage class"]
["ED_PHA3513_00001","DPA0301","Overhead low voltage distribution","MVA",0.26]
["ED_PHA3513_00002","DPA0302","Overhead 6.6 kV","MVA",0]
["ED_PHA3513_00003","DPA0303","Overhead 7.6 kV","MVA",0]
["ED_PHA3513_00004","DPA0304","Overhead 11 kV","MVA",5.94]
["ED_PHA3513_00005","DPA0305","Overhead SWER","MVA",0]
["ED_PHA3513_00006","DPA0306","Overhead 22 kV","MVA",13.654999999999999]
["ED_PHA3513_00007","DPA0307","Overhead 33 kV","MVA",0]
["ED_PHA3513_00008","DPA0308","Overhead 44 kV","MVA",0]
["ED_PHA3513_00009","DPA0309","Overhead 66 kV","MVA",57.2]
["ED_PHA3513_00010","DPA0310","Overhead 110 kV","MVA",0]
["ED_PHA3513_00011","DPA0311","Overhead 132 kV","MVA",347.69]
["ED_PHA3513_00012","DPA0312","Overhead 220 kV","MVA",0]
["ED_PHA3513_00013","DPA0313","Other ","MVA",0]
[]
[null,null,"Table 3.5.1.4 Estimated underground network weighted average MVA capacity by voltage class"]
["ED_PHA3514_00001","DPA0401","Underground low voltage distribution","MVA",0.25700000000000001]
["ED_PHA3514_00002","DPA0402","Underground 5 kV","MVA",0]
["ED_PHA3514_00003","DPA0403","Underground 6.6 kV","MVA",0]
["ED_PHA3514_00004","DPA0404","Underground 7.6 kV","MVA",0]
["ED_PHA3514_00005","DPA0405","Underground 11 kV","MVA",6.8029999999999999]
["ED_PHA3514_00006","DPA0406","Underground SWER","MVA",0]
["ED_PHA3514_00007","DPA0407","Underground 12.7 kV","MVA",0]
["ED_PHA3514_00008","DPA0408","Underground 22 kV","MVA",8.6460000000000008]
["ED_PHA3514_00009","DPA0409","Underground 33 kV","MVA",0]
["ED_PHA3514_00010","DPA0410","Underground 66 kV","MVA",0]
["ED_PHA3514_00010","DPA0411","Underground 110 kV","MVA",0]
["ED_PHA3514_00011","DPA0412","Underground 132 kV","MVA",270]
["ED_PHA3514_00012","DPA0413","Other","MVA",0]
[]
[null,null,"TABLE 3.5.2 - TRANSFORMER CAPACITIES"]
[null,null,"Table 3.5.2.1 Distribution transformer total installed capacity"]
["ED_PHA3521_00001","DPA0501","Distribution transformer capacity owned by utility","MVA",2151.0149999999999]
["ED_PHA3521_00002","DPA0502","Distribution transformer capacity owned by High Voltage Customers","MVA",28.7]
["ED_PHA3521_00003","DPA0503","Cold spare capacity included in DPA0501","MVA",27.425000000000001]
[]
[null,null,"Table 3.5.2.2 Zone substation transformer capacity"]
["ED_PHA3522_00001","DPA0601","Total installed capacity for first step transformation where there are two steps to reach distribution voltage","MVA",0]
["ED_PHA3522_00002","DPA0602","Total installed capacity for second step transformation where there are two steps to reach distribution voltage","MVA",0]
["ED_PHA3522_00003","DPA0603","Total zone substation transformer capacity where there is only a single step transformation to reach distribution voltage","MVA",1478]
["ED_PHA3522_00004","DPA0604","Total zone substation transformer  capacity ","MVA",1478]
["ED_PHA3522_00005","DPA0605","Cold spare capacity of zone substation transformers included in DPA0604","MVA",0]
[null,null,null,null,0]
[null,null,"Table 3.5.2.3 Distribution - other transformer capacity"]
["ED_PHA3523_00001",null,"Distribution other - transformer capacity owned by utility ","MVA",0]
[]
[null,null,"TABLE 3.5.3 - PUBLIC LIGHTING"]
["ED_PHA353_00001","DPA0701","Public lighting luminaires","Number",0]
["ED_PHA353_00002","DPA0702","Public lighting poles","Number",0]
["ED_PHA353_00003","DPA0703","Public lighting columns ","Number",0]

{"sheet":"3.6 Quality of service","index":8,"n_rows":32,"n_cols":5,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
[null,null,"REGULATORY REPORTING STATEMENT"]
[null,null,{"$f":"dms_TradingName","v":"ActewAGL Distribution"}]
[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":"CRY","v":"2014-15"}]
[null,null,null,"Unit"]
[null,null,"TABLE 3.6.1 - RELIABILITY"]
[null,null,"Table 3.6.1.1 Inclusive of MEDs"]
["ED_QOS3611_00001","DQS0101","Whole of network unplanned SAIDI","minutes/customer",32.869999999999997]
["ED_QOS3611_00002","DQS0102","Whole of network unplanned SAIDI excluding excluded outages","minutes/customer",32.869999999999997]
["ED_QOS3611_00003","DQS0103","Whole of network unplanned SAIFI","interruptions/customer",0.60499999999999998]
["ED_QOS3611_00004","DQS0104","Whole of network unplanned SAIFI excluding excluded outages","interruptions/customer",0.60499999999999998]
[null,null,"Table 3.6.1.2 Exclusive of MEDs"]
["ED_QOS3612_00001","DQS0105","Whole of network unplanned SAIDI","minutes/customer",32.869999999999997]
["ED_QOS3612_00002","DQS0106","Whole of network unplanned SAIDI excluding excluded outages","minutes/customer",32.869999999999997]
["ED_QOS3612_00003","DQS0107","Whole of network unplanned SAIFI","interruptions/customer",0.60499999999999998]
["ED_QOS3612_00004","DQS0108","Whole of network unplanned SAIFI excluding excluded outages","interruptions/customer",0.60499999999999998]
[]
[null,null,"TABLE 3.6.2 - ENERGY NOT SUPPLIED"]
["ED_QOS362_00001","DQS0201","Energy Not Supplied (planned)","GWh",0.27]
["ED_QOS362_00002","DQS0202","Energy Not Supplied (unplanned)","GWh",0.17899999999999999]
[null,"DQS02","Total","GWh",0.44900000000000001]
[]
[null,null,"TABLE 3.6.3 - SYSTEM LOSSES"]
["ED_QOS363_00001","DQS03","System losses","%",4.4200000000000003E-2]
[]
[null,null,"TABLE 3.6.4 - CAPACITY UTILISATION"]
["ED_QOS364_00001","DQS04","Overall utilisation","%",0.44277131258457381]

{"sheet":"3.7 Operating environment","index":9,"n_rows":33,"n_cols":5,"rows_kept":33,"cut":false,"hidden":false,"merged":[]}
[null,null,"REGULATORY REPORTING STATEMENT"]
[null,null,{"$f":"dms_TradingName","v":"ActewAGL Distribution"}]
[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,"TABLE 3.7.1 - DENSITY FACTORS"]
["ED_OEF371_00001","DOEF0101","Customer density","Customer / km",78.805724197745008]
["ED_OEF371_00002","DOEF0102","Energy density","MWh/customer",15.716298163168727]
["ED_OEF371_00003","DOEF0103","Demand density","kVA / customer",3.6011137646786922]
[]
[null,null,"TABLE 3.7.2 - TERRAIN FACTORS"]
["ED_OEF372_00001","DOEF0201","Rural proportion","%",0.35589999999999999]
["ED_OEF372_00002","DOEF0202","Urban and CBD vegetation maintenance spans","Number of spans",5415]
["ED_OEF372_00003","DOEF0203","Rural vegetation maintenance spans","Number of spans",1082]
["ED_OEF372_00004","DOEF0204","Total vegetation maintenance spans","Number of spans",6497]
["ED_OEF372_00005","DOEF0205","Total number of spans","Number of spans",50703]
["ED_OEF372_00006","DOEF0206","Average urban and CBD vegetation maintenance span cycle","Years",3]
["ED_OEF372_00007","DOEF0207","Average rural vegetation maintenance span cycle","Years",1]
["ED_OEF372_00008","DOEF0208","Average number of trees per urban and CBD vegetation maintenance span","Trees",1.34]
["ED_OEF372_00009","DOEF0209","Average number of trees per rural vegetation maintenance span","Trees",1.9890000000000001]
["ED_OEF372_00010","DOEF0210","Average number of defects per urban and CBD vegetation maintenance span","Defects",1.34]
["ED_OEF372_00011","DOEF0211","Average number of defects per rural vegetation maintenance span","Defects",1.9890000000000001]
["ED_OEF372_00012","DOEF0212","Tropical proportion","Spans",0]
["ED_OEF372_00013","DOEF0213","Standard vehicle access","km",259]
["ED_OEF372_00014","DOEF0214","Bushfire risk","Spans",6793]
[]
[null,null,"TABLE 3.7.3 - SERVICE AREA FACTORS"]
["ED_OEF373_00001","DOEF0301","Route Line length","km",2306]

{"sheet":"Unlocked worksheet","index":10,"n_rows":33,"n_cols":4,"rows_kept":33,"cut":false,"hidden":false,"merged":[]}
[null,"Supporting Calculations"]
[]
[null,"Table 3.6.2 Energy Not Supplied calculation"]
[null,"Year","2014-15"]
[null,"Minutes per year",{"$f":"(365*24*60)","v":525600}]
[null,"Network Customers (Average Customer Number)",181726]
[null,"System Throughput GWh",2856,"Total Electricity Network Sales"]
[null,"Average Energy use per minute (GWh)",{"$f":"C7/C5","v":5.4337899543378991E-3}]
[null,"Planned outage Minutes",49.686528069731402,"Planned SAIDI"]
[null,"Energy Not Supplied (planned) GWh",{"$f":"C8*C9","v":0.26998615709123452}]
[null,"Unplanned outage Minutes",32.8695924083504,"Unplanned SAIDI"]
[null,"Energy Not Supplied (unplanned) GWh",{"$f":"(C8*C11)","v":0.17860646103167568}]
[null,"Total Energy Not Supplied",{"$f":"SUM(C10+C12)","v":0.44859261812291018}]
[]
[]
[null,"TABLE 3.6.3 - SYSTEM LOSSES"]
[null,"System losses (%)",null,{"$f":"C26/C22","v":4.4183816725427712E-2}]
[]
[null,"Energy IN"]
[null,"Table 3.4.1.2 Energy - received from TNSP and other DNSPs by time of receipt\n",{"$f":"'[1]3.4 Operational data'!E24+'[1]3.4 Operational data'!E25+'[1]3.4 Operational data'!E26+'[1]3.4 Operational data'!E27","v":2874.5339999999997},"GWh"]
[null,"Table 3.4.1.3 Energy - received into DNSP system from embedded generation by time of receipt",{"$f":"'[1]3.4 Operational data'!E30+'[1]3.4 Operational data'!E31+'[1]3.4 Operational data'!E32+'[1]3.4 Operational data'!E33+'[1]3.4 Operational data'!E34+'[1]3.4 Operational data'!E35+'[1]3.4 Operational data'!E36+'[1]3.4 Operational data'!E37","v":113.55099999999999},"GWh"]
[null,null,{"$f":"C20+C21","v":2988.0849999999996},"Gwh"]
[null,"Energy OUT"]
[null,"Table 3.4.1.1 Energy grouping - delivery by chargeable quantity",{"$f":"'[1]3.4 Operational data'!E12","v":2856.06},"GWh"]
[]
[null,null,{"$f":"C22-C24","v":132.02499999999964},"GWh"]
[null,"TABLE 3.7.1 - DENSITY FACTORS"]
[null,"Customers",{"$f":"'[1]3.4 Operational data'!E61","v":181726}]
[null,"Route line length",{"$f":"'[1]3.7 Operating environment'!E33","v":2306}]
[null,"MVA",{"$f":"'[1]3.4 Operational data'!E94","v":654.41600000000005}]
[null,"kVA",{"$f":"C30*1000","v":654416}]
[null,"GWh",{"$f":"'[1]3.4 Operational data'!E12","v":2856.06}]
[null,"MWh",{"$f":"C32*1000","v":2856060}]