{"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":"SA Power Networks"}]
[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":[[24,5,24,8],[28,3,28,4],[29,3,29,4],[28,6,28,7],[29,6,29,7],[51,3,51,4],[58,3,58,9],[59,0,65,0],[32,0,41,0],[32,2,32,9],[38,3,38,4],[43,0,46,0],[30,3,30,4],[30,6,30,7],[24,3,24,4],[0,11,0,19],[7,2,7,9],[11,2,11,9],[13,3,13,5],[14,3,14,5],[17,3,17,4],[19,3,19,4],[22,3,22,4],[17,5,17,8],[18,5,18,8],[19,5,19,8],[23,5,23,8],[22,5,22,8]]}
["HIDE THIS COLUMN",null,{"$f":"(LOOKUP(dms_Model,dms_Model_List,dms_Worksheet_List))","v":"REGULATORY REPORTING STATEMENT"},null,null,null,null,null,null,null,null,"Data in these columns used for data validation and database purposes."]
[null,null,{"$f":"dms_TradingName","v":"SA Power Networks"},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","SA Power Networks"]
[null,null,"ACN / ABN",{"$f":"INDEX(dms_ABN_List,MATCH(dms_TradingName,dms_TradingName_List))","v":13332330749}]
[]
[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,"1 Anzac Highway",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,"Keswick",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":"SA"},"p/code",5035,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 77",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,"Adelaide",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","SA","p/code",5001]
[]
[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","Richard Sibly",null,null,"Kelly Bernhardt",null,null,null,null,"ActewAGL Distribution",76670568688,"ACT","Electricity","Distribution","Revenue cap",5,6,"ACT"]
[null,null,"Contact phone/s","08 8404 5613",null,null,"08 8404 5664",null,null,null,null,"ActewAGL Distribution (Tx Assets)",76670568688,"ACT","Electricity","Distribution","Revenue cap",5,5,"ACT"]
[null,null,"Contact email address/s","richard.sibly@sapowernetworks.com.au",null,null,"kelly.bernhardt@sapowernetworks.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":"Confidential"},null,null,null,null,null,null,null,"Victorian DNSP Reset ",33333333333,"Vic","Electricity","Distribution","?",5,5,"Vic"]
[null,null,"Data quality (actual, estimate, public, consolidated)","Consolidated"]
[null,null,"EBSS - First application of scheme in forthcoming period?","No"]
[null,null,"Amended RIN submission - amendment reason","Corrected data in Table 3.5.2 for DPA0501 Distribution transformer capacity owned by utility - refer 24/6/16 R Sibly email to Anne Sastro"]
["HIDE THESE ROWS",null,"Template - version no.",1]
[null,null,"Dollar $ real  (the last month before the FRCP_y1)",{"$f":"CONCATENATE(IF(dms_RPT=\"Financial\",\"June \",\"December \"),(dms_RYE))","v":"June 2015"},null,null,null,null,null,null,null,"dms_SourceList","dms_FormControl"]
[null,null,"Form of control",{"$f":"INDEX(dms_FormControl_List,MATCH(dms_TradingName,dms_TradingName_List))","v":"Revenue cap"},null,null,null,null,null,null,null,"After appeal","Revenue cap"]
[null,null,"Length of current reg control period",{"$f":"INDEX(dms_CRCPlength_List,MATCH(dms_TradingName,dms_TradingName_List))","v":5},null,null,null,null,null,null,null,"Draft decision","Revenue yield"]
[null,null,"Length of forthcoming reg control period",{"$f":"INDEX(dms_FRCPlength_List,MATCH(dms_TradingName,dms_TradingName_List))","v":5},null,null,null,null,null,null,null,"Final decision","Weighted average price cap"]
[null,null,"RIN response - version no.",1,null,null,null,null,null,null,null,"Pass through decision"]
[null,null,"Jurisdiction",{"$f":"INDEX(dms_JurisdictionList,MATCH(dms_TradingName,dms_TradingName_List))","v":"SA"},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":"SA Power Networks"}]
[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"]
["ED_REV311_00001","DREV0101","Revenue from Fixed Customer Charges ",null,92995326,0]
["ED_REV311_00002","DREV0102","Revenue from Energy Delivery charges where time of use is not a determinant",null,424592256,0]
["ED_REV311_00003","DREV0103","Revenue from On–Peak Energy Delivery charges ",null,126440410,0]
["ED_REV311_00004","DREV0104","Revenue from Shoulder period Energy Delivery Charges",null,0,0]
["ED_REV311_00005","DREV0105","Revenue from Off–Peak Energy Delivery charges ",null,81151267,0]
["ED_REV311_00006","DREV0106","Revenue from controlled load customer charges",null,21765961,0]
["ED_REV311_00007","DREV0107","Revenue from unmetered supplies",null,7588957,0]
["ED_REV311_00008","DREV0108","Revenue from Contracted Maximum Demand charges",null,172096271,0]
["ED_REV311_00009","DREV0109","Revenue from Measured Maximum Demand charges",null,4179,0]
["ED_REV311_00010","DREV0110","Revenue from metering charges",null,0,27408080]
["ED_REV311_00011","DREV0111","Revenue from connection charges",null,0,0]
["ED_REV311_00012","DREV0112","Revenue from public lighting charges",null,0,0]
["ED_REV311_00013","DREV0113","Revenue from other Sources",null,1483525,0]
[null,"DREV01","Total revenue by chargeable quantity","$0's",{"$f":"SUM(E13:E25)","v":928118152},{"$f":"SUM(F13:F25)","v":27408080}]
[]
[null,null,"TABLE 3.1.2 REVENUE GROUPING BY CUSTOMER TYPE OR CLASS"]
["ED_REV312_00001","DREV0201","Revenue from residential Customers ",null,454591900,24068810]
["ED_REV312_00002","DREV0202","Revenue from Non residential customers not on demand tariffs ",null,176476676,3140510]
["ED_REV312_00003","DREV0203","Revenue from Non-residential low voltage demand tariff customers ",null,232765713,139130]
["ED_REV312_00004","DREV0204","Revenue from Non-residential high voltage demand tariff customers ",null,55211381,59630]
["ED_REV312_00005","DREV0205","Revenue from unmetered supplies",null,7588957,0]
["ED_REV312_00006","DREV0206","Revenue from Other Customers",null,1483525,0]
[null,"DREV02","Total revenue by customer class","$0's",{"$f":"SUM(E29:E34)","v":928118152},{"$f":"SUM(F29:F34)","v":27408080}]
[]
[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,14200208,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":14200208},{"$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":"SA Power Networks"}]
[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":"SA Power Networks 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","Distribution licence fee",null,3326815.8899999997,0]
["ED_OPX3211_00002","DOPEX0102","Network operating costs",null,27206508.059999999,0]
["ED_OPX3211_00003","DOPEX0103","Inspections",null,14446039.109999999,0]
["ED_OPX3211_00004","DOPEX0104","Maintenance & repair",null,15125984.829999998,1093158.5499999998]
["ED_OPX3211_00005","DOPEX0105","Substation property maintenance",null,7388833.1031400003,0]
["ED_OPX3211_00006","DOPEX0106","Vegetation management",null,46802128.289999999,0]
["ED_OPX3211_00007","DOPEX0107","Emergency response",null,32849401.830000002,0]
["ED_OPX3211_00008","DOPEX0108","Demand management",null,2669305.17,0]
["ED_OPX3211_00009","DOPEX0109","Guaranteed service level payments",null,3713691.06,0]
["ED_OPX3211_00010","DOPEX0110","Network insurance",null,2645505.0603800002,0]
["ED_OPX3211_00011","DOPEX0111","Call centre",null,3158852.8600000003,0]
["ED_OPX3211_00012","DOPEX0112","Full retail contestability",null,17340798.574999999,0]
["ED_OPX3211_00013","DOPEX0113","Meter reading",null,0,3566560.76]
["ED_OPX3211_00014","DOPEX0114","Other customer services",null,6434012.121041771,142705.71537173496]
["ED_OPX3211_00015","DOPEX0115","Corporate costs and other operating",null,67748422.762469605,848480.63466251735]
["ED_OPX3211_00016","DOPEX0116"]
["ED_OPX3211_00017","DOPEX0117"]
["ED_OPX3211_00018","DOPEX0118"]
["ED_OPX3211_00019","DOPEX0119"]
["ED_OPX3211_00020","DOPEX0120"]
["ED_OPX3211_00021","DOPEX0121"]
["ED_OPX3211_00022","DOPEX0122"]
["ED_OPX3211_00023","DOPEX0123"]
["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":250856298.72203141},{"$f":"SUM(F18:F59)","v":5650905.6600342523}]
[]
[]
["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","Distribution licence fee",null,3326815.8899999997,0]
["ED_OPX3212A_00002","DOPEX0102A","Network operating costs",null,27206508.059999999,0]
["ED_OPX3212A_00003","DOPEX0103A","Inspections",null,14446039.109999999,0]
["ED_OPX3212A_00004","DOPEX0104A","Maintenance & repair",null,15125984.829999998,1093158.5499999998]
["ED_OPX3212A_00005","DOPEX0105A","Substation property maintenance",null,7388833.1031400003,0]
["ED_OPX3212A_00006","DOPEX0106A","Vegetation management",null,46802128.289999999,0]
["ED_OPX3212A_00007","DOPEX0107A","Emergency response",null,32849401.830000002,0]
["ED_OPX3212A_00008","DOPEX0108A","Demand management",null,2669305.17,0]
["ED_OPX3212A_00009","DOPEX0109A","Guaranteed service level payments",null,3713691.06,0]
["ED_OPX3212A_00010","DOPEX0110A","Network insurance",null,2645505.0603800002,0]
["ED_OPX3212A_00011","DOPEX0111A","Call centre",null,3158852.8600000003,0]
["ED_OPX3212A_00012","DOPEX0112A","Full retail contestability",null,17340798.574999999,0]
["ED_OPX3212A_00013","DOPEX0113A","Meter reading",null,0,3566560.76]
["ED_OPX3212A_00014","DOPEX0114A","Other customer services",null,6434012.121041771,142705.71537173496]
["ED_OPX3212A_00015","DOPEX0115A","Corporate costs and other operating",null,67748422.762469605,848480.63466251735]
["ED_OPX3212A_00016","DOPEX0116A"]
["ED_OPX3212A_00017","DOPEX0117A"]
["ED_OPX3212A_00018","DOPEX0118A"]
["ED_OPX3212A_00019","DOPEX0119A"]
["ED_OPX3212A_00020","DOPEX0120A"]
["ED_OPX3212A_00021","DOPEX0121A"]
["ED_OPX3212A_00022","DOPEX0122A"]
["ED_OPX3212A_00023","DOPEX0123A"]
["ED_OPX3212A_00024","DOPEX0124A"]
["ED_OPX3212A_00025","DOPEX0125A"]
["ED_OPX3212A_00026","DOPEX0126A"]
["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":250856298.72203141},{"$f":"SUM(F64:F105)","v":5650905.6600342523}]
[]
["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,248377486.88966605,0]
["ED_OPX3221_00002","DOPEX0202","Opex for metering",null,0,5593920.3328629574]
["ED_OPX3221_00003","DOPEX0203","Opex for connection services",null,2478811.832365361,56985.327171294841]
["ED_OPX3221_00004","DOPEX0204","Opex for public lighting",null,0,0]
["ED_OPX3221_00005","DOPEX0205","Opex for amounts payable for easement levy or similar direct charges on DNSP",null,0,0]
["ED_OPX3221_00006","DOPEX0206","Opex for transmission connection point planning",null,0,0]
[null,null,"Total opex ","($0's)",{"$f":"SUM(E201:E206)","v":250856298.72203141},{"$f":"SUM(F201:F206)","v":5650905.6600342523}]
[]
[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,248377486.88966605,0]
["ED_OPX3222_00002","DOPEX0202A","Opex for metering",null,0,5593920.3328629574]
["ED_OPX3222_00003","DOPEX0203A","Opex for connection services",null,2478811.832365361,56985.327171294841]
["ED_OPX3222_00004","DOPEX0204A","Opex for public lighting",null,0,0]
["ED_OPX3222_00005","DOPEX0205A","Opex for amounts payable for easement levy or similar direct charges on DNSP",null,0,0]
["ED_OPX3222_00006","DOPEX0206A","Opex for transmission connection point planning",null,0,0]
[null,null,"Total opex ","($0's)",{"$f":"SUM(E210:E215)","v":250856298.72203141},{"$f":"SUM(F210:F215)","v":5650905.6600342523}]
[]
[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)",{"$f":"[1]Consolidated!M80*1000","v":1320819.8521998015}]

{"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":"SA Power Networks"}]
[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":"SA Power Networks 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","Provision name"]
[null,null,"Annual Leave"]
[null,"DOPEX0301A","Opening balance (the carrying amount at the beginning of the period)",null,15606000]
[null,null,"Additional provisions made in the period, including increases to existing provisions"]
[null,"DOPEX0302A","Opex component",null,13483000]
[null,"DOPEX0303A","Capex component",null,0]
[null,"DOPEX0304A","Other component",null,0]
[null,null,"Amounts used (that is, incurred and charged against the provision) during the period"]
[null,"DOPEX0305A","Opex component",null,-12851000]
[null,"DOPEX0306A","Capex component",null,0]
[null,"DOPEX0307A","Other component",null,0]
[null,null,"Unused amounts reversed during the period"]
[null,"DOPEX0308A","Opex component",null,0]
[null,"DOPEX0309A","Capex component",null,0]
[null,"DOPEX0310A","Other component",null,0]
[null,null,"The increase during the period in the discounted amount arising from the passage of time and the effect of any change in the discount rate"]
[null,"DOPEX0311A","Opex component",null,189000]
[null,"DOPEX0312A","Capex component",null,0]
[null,"DOPEX0313A","Other component",null,0]
[null,"DOPEX0314A","Closing balance (carrying amount at the end of the period)",null,16427000]
[null,"DOPEX03B","Provision name"]
[null,null,"Long Service Leave"]
[null,"DOPEX0301B","Opening balance (the carrying amount at the beginning of the period)",null,44074000]
[null,null,"Additional provisions made in the period, including increases to existing provisions"]
[null,"DOPEX0302B","Opex component",null,5098000]
[null,"DOPEX0303B","Capex component",null,0]
[null,"DOPEX0304B","Other component",null,0]
[null,null,"Amounts used (that is, incurred and charged against the provision) during the period"]
[null,"DOPEX0305B","Opex component",null,-3347000]
[null,"DOPEX0306B","Capex component",null,0]
[null,"DOPEX0307B","Other component",null,0]
[null,null,"Unused amounts reversed during the period"]
[null,"DOPEX0308B","Opex component",null,-375000]
[null,"DOPEX0309B","Capex component",null,0]
[null,"DOPEX0310B","Other component",null,0]
[null,null,"The increase during the period in the discounted amount arising from the passage of time and the effect of any change in the discount rate"]
[null,"DOPEX0311B","Opex component",null,2830000]
[null,"DOPEX0312B","Capex component",null,0]
[null,"DOPEX0313B","Other component",null,0]
[null,"DOPEX0314B","Closing balance (carrying amount at the end of the period)",null,48280000]
[null,"DOPEX03C","Provision name"]
[null,null,"Workers Compensation"]
[null,"DOPEX0301C","Opening balance (the carrying amount at the beginning of the period)",null,1056000]
[null,null,"Additional provisions made in the period, including increases to existing provisions"]
[null,"DOPEX0302C","Opex component",null,1550000]
[null,"DOPEX0303C","Capex component",null,0]
[null,"DOPEX0304C","Other component",null,0]
[null,null,"Amounts used (that is, incurred and charged against the provision) during the period"]
[null,"DOPEX0305C","Opex component",null,-613000]
[null,"DOPEX0306C","Capex component",null,0]
[null,"DOPEX0307C","Other component",null,0]
[null,null,"Unused amounts reversed during the period"]
[null,"DOPEX0308C","Opex component",null,-422000]
[null,"DOPEX0309C","Capex component",null,0]
[null,"DOPEX0310C","Other component",null,0]
[null,null,"The increase during the period in the discounted amount arising from the passage of time and the effect of any change in the discount rate"]
[null,"DOPEX0311C","Opex component",null,0]
[null,"DOPEX0312C","Capex component",null,0]
[null,"DOPEX0313C","Other component",null,0]
[null,"DOPEX0314C","Closing balance (carrying amount at the end of the period)",null,1571000]
[null,"DOPEX03D","Provision name"]
[null,null,"Self Insurance"]
[null,"DOPEX0301D","Opening balance (the carrying amount at the beginning of the period)",null,2510000]
[null,null,"Additional provisions made in the period, including increases to existing provisions"]
[null,"DOPEX0302D","Opex component",null,2353000]
[null,"DOPEX0303D","Capex component",null,0]
[null,"DOPEX0304D","Other component",null,0]
[null,null,"Amounts used (that is, incurred and charged against the provision) during the period"]
[null,"DOPEX0305D","Opex component",null,-927000]
[null,"DOPEX0306D","Capex component",null,0]
[null,"DOPEX0307D","Other component",null,0]
[null,null,"Unused amounts reversed during the period"]
[null,"DOPEX0308D","Opex component",null,-789000]
[null,"DOPEX0309D","Capex component",null,0]
[null,"DOPEX0310D","Other component",null,0]
[null,null,"The increase during the period in the discounted amount arising from the passage of time and the effect of any change in the discount rate"]
[null,"DOPEX0311D","Opex component",null,0]
[null,"DOPEX0312D","Capex component",null,0]
[null,"DOPEX0313D","Other component",null,0]
[null,"DOPEX0314D","Closing balance (carrying amount at the end of the period)",null,3147000]
[null,"DOPEX03E","Provision name"]
[null,null,"Income Protection Scheme"]
[null,"DOPEX0301E","Opening balance (the carrying amount at the beginning of the period)",null,37000]
[null,null,"Additional provisions made in the period, including increases to existing provisions"]
[null,"DOPEX0302E","Opex component",null,94000]
[null,"DOPEX0303E","Capex component",null,0]
[null,"DOPEX0304E","Other component",null,0]
[null,null,"Amounts used (that is, incurred and charged against the provision) during the period"]
[null,"DOPEX0305E","Opex component",null,-91000]
[null,"DOPEX0306E","Capex component",null,0]
[null,"DOPEX0307E","Other component",null,0]
[null,null,"Unused amounts reversed during the period"]
[null,"DOPEX0308E","Opex component",null,-40000]
[null,"DOPEX0309E","Capex component",null,0]
[null,"DOPEX0310E","Other component",null,0]
[null,null,"The increase during the period in the discounted amount arising from the passage of time and the effect of any change in the discount rate"]
[null,"DOPEX0311E","Opex component",null,0]
[null,"DOPEX0312E","Capex component",null,0]
[null,"DOPEX0313E","Other component",null,0]
[null,"DOPEX0314E","Closing balance (carrying amount at the end of the period)",null,0]
[null,"DOPEX03F","Provision name"]
[null,null,"Environmental - Demolition and Site Restoration"]
[null,"DOPEX0301F","Opening balance (the carrying amount at the beginning of the period)",null,1420000]
[null,null,"Additional provisions made in the period, including increases to existing provisions"]
[null,"DOPEX0302F","Opex component",null,179000]
[null,"DOPEX0303F","Capex component",null,0]
[null,"DOPEX0304F","Other component",null,0]
[null,null,"Amounts used (that is, incurred and charged against the provision) during the period"]
[null,"DOPEX0305F","Opex component",null,-397000]
[null,"DOPEX0306F","Capex component",null,0]
[null,"DOPEX0307F","Other component",null,0]
[null,null,"Unused amounts reversed during the period"]
[null,"DOPEX0308F","Opex component",null,-92000]
[null,"DOPEX0309F","Capex component",null,0]
[null,"DOPEX0310F","Other component",null,0]
[null,null,"The increase during the period in the discounted amount arising from the passage of time and the effect of any change in the discount rate"]
[null,"DOPEX0311F","Opex component",null,0]
[null,"DOPEX0312F","Capex component",null,0]
[null,"DOPEX0313F","Other component",null,0]
[null,"DOPEX0314F","Closing balance (carrying amount at the end of the period)",null,1110000]
[null,"DOPEX03G","Provision name"]
[null,null,"Employee Bonuses"]
[null,"DOPEX0301G","Opening balance (the carrying amount at the beginning of the period)",null,2569000]
[null,null,"Additional provisions made in the period, including increases to existing provisions"]
[null,"DOPEX0302G","Opex component",null,9585000]
[null,"DOPEX0303G","Capex component",null,0]
[null,"DOPEX0304G","Other component",null,0]
[null,null,"Amounts used (that is, incurred and charged against the provision) during the period"]
[null,"DOPEX0305G","Opex component",null,-5699000]
[null,"DOPEX0306G","Capex component",null,0]
[null,"DOPEX0307G","Other component",null,0]
[null,null,"Unused amounts reversed during the period"]
[null,"DOPEX0308G","Opex component",null,0]
[null,"DOPEX0309G","Capex component",null,0]
[null,"DOPEX0310G","Other component",null,0]
[null,null,"The increase during the period in the discounted amount arising from the passage of time and the effect of any change in the discount rate"]
[null,"DOPEX0311G","Opex component",null,0]
[null,"DOPEX0312G","Capex component",null,0]
[null,"DOPEX0313G","Other component",null,0]
[null,"DOPEX0314G","Closing balance (carrying amount at the end of the period)",null,6455000]
[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":"SA Power Networks"}]
[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"},"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,3456377697.9511766,3638144379.4071307,77811197.02100724]
["ED_RAB331_00002","DRAB0102","Inflation addition",null,45969823.38275066,48387320.24611485,1034888.9203793958]
["ED_RAB331_00003","DRAB0103","Straight line depreciation",null,-232846835.39084432,-241985608.63989556,-7415922.2356680883]
["ED_RAB331_00004","DRAB0104","Regulatory depreciation",null,{"$f":"SUM(E15+E14)","v":-186877012.00809366},{"$f":"SUM(F15+F14)","v":-193598288.39378071},{"$f":"SUM(G15+G14)","v":-6381033.3152886927}]
["ED_RAB331_00005","DRAB0105","Actual additions (recognised in RAB)",null,305232975.06277025,319390596.78038996,4337479.0777765475]
["ED_RAB331_00006","DRAB0106","Disposals ",null,-2388000,-2388000,0]
["ED_RAB331_00007","DRAB0107","Closing value for overhead distribution asset value",null,{"$f":"SUM(E13+E14+E15+E17+E18)","v":3572345661.0058532},{"$f":"SUM(F13+F14+F15+F17+F18)","v":3761548687.7937398},{"$f":"SUM(G13+G14+G15+G17+G18)","v":75767642.783495098}]
[]
[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,543342703.12237549,612452547.31498098,0]
["ED_RAB3321_00002","DRAB0202","Inflation addition",null,7154815.0498616118,8073975.9776232652,0]
["ED_RAB3321_00003","DRAB0203","Straight line depreciation",null,-32420290.548281752,-35787697.237837903,0]
["ED_RAB3321_00004","DRAB0204","Regulatory depreciation",null,{"$f":"SUM(E25+E24)","v":-25265475.498420142},{"$f":"SUM(F25+F24)","v":-27713721.260214638},0]
["ED_RAB3321_00005","DRAB0205","Actual additions (recognised in RAB)",null,19695798.003808454,25265239.049296275,0]
["ED_RAB3321_00006","DRAB0206","Disposals ",null,0,0,0]
["ED_RAB3321_00007","DRAB0207","Closing value for overhead distribution asset value",null,{"$f":"SUM(E23+E24+E25+E27+E28)","v":537773025.62776387},{"$f":"SUM(F23+F24+F25+F27+F28)","v":610004065.10406256},0]
[null,null,"For underground network assets less than 33kV:"]
["ED_RAB3322_00001","DRAB0301","Opening value",null,850055307.14781117,962712144.41115963,0]
["ED_RAB3322_00002","DRAB0302","Inflation addition",null,11264265.681216981,12762601.616819514,0]
["ED_RAB3322_00003","DRAB0303","Straight line depreciation",null,-59828823.017382838,-65600189.576877967,0]
["ED_RAB3322_00004","DRAB0304","Regulatory depreciation",null,{"$f":"SUM(E33+E32)","v":-48564557.33616586},{"$f":"SUM(F33+F32)","v":-52837587.960058451},0]
["ED_RAB3322_00005","DRAB0305","Actual additions (recognised in RAB)",null,57347647.320670709,65935827.99280262,0]
["ED_RAB3322_00006","DRAB0306","Disposals ",null,0,0,0]
["ED_RAB3322_00007","DRAB0307","Closing value for underground asset value",null,{"$f":"SUM(E31+E32+E33+E35+E36)","v":858838397.13231599},{"$f":"SUM(F31+F32+F33+F35+F36)","v":975810384.4439038},0]
[null,null,"For distribution substations and transformers:"]
["ED_RAB3323_00001","DRAB0401","Opening value",null,906423311.94034052,906423311.94034052,0]
["ED_RAB3323_00002","DRAB0402","Inflation addition",null,12096931.732705675,12096931.732705675,0]
["ED_RAB3323_00003","DRAB0403","Straight line depreciation",null,-43242921.77039548,-43242921.77039548,0]
["ED_RAB3323_00004","DRAB0404","Regulatory depreciation",null,{"$f":"SUM(E41+E40)","v":-31145990.037689805},{"$f":"SUM(F41+F40)","v":-31145990.037689805},0]
["ED_RAB3323_00005","DRAB0405","Actual additions (recognised in RAB)",null,70636655.127356514,70636655.127356514,0]
["ED_RAB3323_00006","DRAB0406","Disposals ",null,0,0,0]
["ED_RAB3323_00007","DRAB0407","Closing value for distribution substations and transformers asset value",null,{"$f":"SUM(E39+E40+E41+E43+E44)","v":945913977.03000724},{"$f":"SUM(F39+F40+F41+F43+F44)","v":945913977.03000724},0]
[null,null,"For overhead network assets 33kV and above:"]
["ED_RAB3324_00001","DRAB0501","Opening value",null,142966956.72989982,142966956.72989982,0]
["ED_RAB3324_00002","DRAB0502","Inflation addition",null,1894855.1160071499,1894855.1160071499,0]
["ED_RAB3324_00003","DRAB0503","Straight line depreciation",null,-6233941.0659353901,-6233941.0659353901,0]
["ED_RAB3324_00004","DRAB0504","Regulatory depreciation",null,{"$f":"SUM(E49+E48)","v":-4339085.9499282399},{"$f":"SUM(F49+F48)","v":-4339085.9499282399},0]
["ED_RAB3324_00005","DRAB0505","Actual additions (recognised in RAB)",null,7080139.7368135946,7080139.7368135946,0]
["ED_RAB3324_00006","DRAB0506","Disposals ",null,0,0,0]
["ED_RAB3324_00007","DRAB0507","Closing value for overhead asset 33kV and above value",null,{"$f":"SUM(E47+E48+E49+E51+E52)","v":145708010.51678517},{"$f":"SUM(F47+F48+F49+F51+F52)","v":145708010.51678517},0]
[null,null,"For underground network assets 33kV and above:"]
["ED_RAB3325_00001","DRAB0601","Opening value",null,24724133.300999843,24724133.300999843,0]
["ED_RAB3325_00002","DRAB0602","Inflation addition",null,327688.65999400866,327688.65999400866,0]
["ED_RAB3325_00003","DRAB0603","Straight line depreciation",null,-1078072.8178746316,-1078072.8178746316,0]
["ED_RAB3325_00004","DRAB0604","Regulatory depreciation",null,{"$f":"SUM(E57+E56)","v":-750384.15788062289},{"$f":"SUM(F57+F56)","v":-750384.15788062289},0]
["ED_RAB3325_00005","DRAB0605","Actual additions (recognised in RAB)",null,1224411.0292799957,1224411.0292799957,0]
["ED_RAB3325_00006","DRAB0606","Disposals ",null,0,0,0]
["ED_RAB3325_00007","DRAB0607","Closing value for underground asset 33kV and above value",null,{"$f":"SUM(E55+E56+E57+E59+E60)","v":25198160.172399215},{"$f":"SUM(F55+F56+F57+F59+F60)","v":25198160.172399215},0]
[null,null,"Zone substations and transformers"]
["ED_RAB3326_00001","DRAB0701","Opening value",null,487685387.33362913,487685387.33362913,0]
["ED_RAB3326_00002","DRAB0702","Inflation addition",null,6509822.0287805181,6509822.0287805181,0]
["ED_RAB3326_00003","DRAB0703","Straight line depreciation",null,-22948635.012444239,-22948635.012444239,0]
["ED_RAB3326_00004","DRAB0704","Regulatory depreciation",null,{"$f":"SUM(E65+E64)","v":-16438812.983663721},{"$f":"SUM(F65+F64)","v":-16438812.983663721},0]
["ED_RAB3326_00005","DRAB0705","Actual additions (recognised in RAB)",null,38017534.063145027,38017534.063145027,0]
["ED_RAB3326_00006","DRAB0706","Disposals ",null,0,0,0]
["ED_RAB3326_00007","DRAB0707","Closing value for zone substations and transformers",null,{"$f":"SUM(E63+E64+E65+E67+E68)","v":509264108.41311044},{"$f":"SUM(F63+F64+F65+F67+F68)","v":509264108.41311044},0]
[null,null,"For easements:"]
["ED_RAB3327_00001","DRAB0801","Opening value",null,4946005.1557346256,4946005.1557346256,0]
["ED_RAB3327_00002","DRAB0802","Inflation addition",null,65781.868571270519,65781.868571270519,0]
["ED_RAB3327_00003","DRAB0805","Actual additions (recognised in RAB)",null,1035631.3674654964,1035631.3674654964,0]
["ED_RAB3327_00004","DRAB0806","Disposals ",null,0,0,0]
["ED_RAB3327_00005","DRAB0807","Closing value for easements asset value",null,{"$f":"SUM(E71+E72+E73+E74)","v":6047418.391771392},{"$f":"SUM(F71+F72+F73+F74)","v":6047418.391771392},{"$f":"SUM(G71+G72+G73+G74)","v":0}]
[null,null,"For meters:"]
["ED_RAB3328_00001","DRAB0901","Opening value",null,0,0,77642027.063276693]
["ED_RAB3328_00002","DRAB0902","Inflation addition",null,0,0,1032638.9599415795]
["ED_RAB3328_00003","DRAB0903","Straight line depreciation",null,0,0,-7401319.7758634901]
["ED_RAB3328_00004","DRAB0904","Regulatory depreciation",null,{"$f":"SUM(E79+E78)","v":0},{"$f":"SUM(F79+F78)","v":0},-6368680.8159219101]
["ED_RAB3328_00005","DRAB0905","Actual additions (recognised in RAB)",null,0,0,4337479.0777765475]
["ED_RAB3328_00006","DRAB0906","Disposals ",null,0,0,0]
["ED_RAB3328_00007","DRAB0907","Closing value for meters asset value",null,{"$f":"SUM(E77+E78+E79+E81+E82)","v":0},{"$f":"SUM(F77+F78+F79+F81+F82)","v":0},75610825.325131342]
[null,null,"For “other” asset items with long lives:"]
["ED_RAB3329_00001","DRAB1001","Opening value",null,414193661.16306609,414193661.16306609,169169.95773055026]
["ED_RAB3329_00002","DRAB1002","Inflation addition",null,5543258.0804645298,5543258.0804645298,2249.9604378163185]
["ED_RAB3329_00003","DRAB1003","Straight line depreciation",null,-23588697.194875736,-23588697.194875736,-14602.459804598673]
["ED_RAB3329_00004","DRAB1004","Regulatory depreciation",null,{"$f":"SUM(E87+E86)","v":-18045439.114411205},{"$f":"SUM(F87+F86)","v":-18045439.114411205},-12352.499366782355]
["ED_RAB3329_00005","DRAB1005","Actual additions (recognised in RAB)",null,{"$f":"'[2]Consolidated ($''000)'!M84*1000","v":52416872.700371303},{"$f":"'[2]Consolidated ($''000)'!Y84*1000","v":52416872.700371303},0]
["ED_RAB3329_00006","DRAB1006","Disposals ",null,0,0,0]
["ED_RAB3329_00007","DRAB1007","Closing value for “other” asset (long life) value",null,{"$f":"SUM(E85+E86+E87+E89+E90)","v":448565094.74902624},{"$f":"SUM(F85+F86+F87+F89+F90)","v":448565094.74902624},156817.45836376789]
[null,null,"For “other” asset items with short lives:"]
["ED_RAB33210_00001","DRAB1101","Opening value",null,82040232.057320505,82040232.057320505,0]
["ED_RAB33210_00002","DRAB1102","Inflation addition",null,1112405.1651489122,1112405.1651489122,0]
["ED_RAB33210_00003","DRAB1103","Straight line depreciation",null,-43505453.963654228,-43505453.963654228,0]
["ED_RAB33210_00004","DRAB1104","Regulatory depreciation",null,{"$f":"SUM(E95+E94)","v":-42393048.798505314},{"$f":"SUM(F95+F94)","v":-42393048.798505314},0]
["ED_RAB33210_00005","DRAB1105","Actual additions (recognised in RAB)",null,57778285.713859141,57778285.713859141,0]
["ED_RAB33210_00006","DRAB1106","Disposals ",null,-2388000,-2388000,0]
["ED_RAB33210_00007","DRAB1107","Closing value for “other” asset (short life) value",null,{"$f":"SUM(E93+E94+E95+E97+E98)","v":95037468.97267434},{"$f":"SUM(F93+F94+F95+F97+F98)","v":95037468.97267434},0]
[]
[null,null,"TABLE 3.3.3 - TOTAL DISAGGREGATED RAB ASSET VALUES"]
["ED_RAB333_00001","DRAB1201","Overhead distribution assets (wires and poles)",null,540557864.37506974,611228306.20952189,0]
["ED_RAB333_00002","DRAB1202","Underground distribution assets (cables, ducts etc)",null,854446852.14006352,969261264.42753172,0]
["ED_RAB333_00003","DRAB1203","Distribution substations including transformers",null,926168644.48517394,926168644.48517394,0]
["ED_RAB333_00004","DRAB1204","Overhead assets 33kV and above (wires and towers / poles etc)",null,144337483.62334254,144337483.62334254,0]
["ED_RAB333_00005","DRAB1205","Underground assets 33kV and above (cables, ducts etc)",null,24961146.736699529,24961146.736699529,0]
["ED_RAB333_00006","DRAB1206","Zone substations",null,498474747.87336981,498474747.87336981,0]
["ED_RAB333_00007","DRAB1207","Easements ",null,5496711.7737530097,5496711.7737530097,0]
["ED_RAB333_00008","DRAB1208","Meters",null,0,0,76626426.194204018]
["ED_RAB333_00009","DRAB1209","Other assets with long lives (please specify)",null,431379377.95604616,431379377.95604616,162993.70804715907]
["ED_RAB333_00010","DRAB1210","Other assets with short lives (please specify)",null,88538850.514997423,88538850.514997423,0]
[]
[null,null,"Capital Contributions"]
["ED_RAB333_00011","DRAB13","Value of Capital Contributions or Contributed Assets ",null,0,-65594000,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"},"2014-15"]
["ED_RAB3341_00001","DRAB1401","Overhead network assets less than 33kV (wires and poles)",null,55,55,0]
["ED_RAB3341_00002","DRAB1402","Underground network assets less than 33kV (cables)",null,55,55,0]
["ED_RAB3341_00003","DRAB1403","Distribution substations including transformers",null,45,45,0]
["ED_RAB3341_00004","DRAB1404","Overhead network assets 33kV and above (wires and towers / poles etc) ",null,55,55,0]
["ED_RAB3341_00005","DRAB1405","Underground network assets 33kV and above(cables, ducts etc)",null,55,55,0]
["ED_RAB3341_00006","DRAB1406","Zone substations and transformers",null,45,45,0]
["ED_RAB3341_00007","DRAB1407","Meters",null,0,0,15]
["ED_RAB3341_00008","DRAB1408","“Other” assets with long lives",null,18.05528579771358,18.05528579771358,15]
["ED_RAB3341_00009","DRAB1409","“Other” assets with short lives",null,5,5,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,16.345395413172184,15.194379262098796,0]
["ED_RAB3342_00002","DRAB1502","Underground network assets less than 33kV (cables)",null,14.510630808499226,13.605007552031669,0]
["ED_RAB3342_00003","DRAB1503","Distribution substations including transformers",null,17.709156338800319,17.709156338800319,0]
["ED_RAB3342_00004","DRAB1504","Overhead network assets 33kV and above (wires and towers / poles etc) ",null,18.772868255482457,18.772868255482457,0]
["ED_RAB3342_00005","DRAB1505","Underground network assets 33kV and above (cables, ducts etc)",null,18.772868255482457,18.772868255482457,0]
["ED_RAB3342_00006","DRAB1506","Zone substations and transformers",null,17.673272993937424,17.673272993937424,0]
["ED_RAB3342_00007","DRAB1507","Meters",null,0,0,10.392359030687905]
["ED_RAB3342_00008","DRAB1508","“Other” assets with long lives",null,8.9213909167449756,8.9213909167449756,10.74]
["ED_RAB3342_00009","DRAB1509","“Other” assets with short lives",null,4.6074439377083252,4.6074439377083252,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":"SA Power Networks"}]
[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",10342.495546872093]
[]
[]
[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",3797.6848527711441]
["ED_OPD3411_00002","DOPED0202","Energy Delivery at On-peak times","GWh",3162.8549936811673]
["ED_OPD3411_00003","DOPED0203","Energy Delivery at Shoulder times ","GWh",0]
["ED_OPD3411_00004","DOPED0204","Energy Delivery at Off-peak times","GWh",2692.0192724545132]
["ED_OPD3411_00005","DOPED0205","Controlled load energy deliveries","GWh",567.02525610206908]
["ED_OPD3411_00005","DOPED0206","Energy Delivery to unmetered supplies","GWh",122.91117186319954]
[]
[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",4731.8218957139607]
["ED_OPD3412_00002","DOPED0302","Energy into DNSP network  at Shoulder times ","GWh",0]
["ED_OPD3412_00003","DOPED0303","Energy into DNSP network  at Off-peak times","GWh",5454.1714081680229]
["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",136.1516602554243]
["ED_OPD3413_00002","DOPED0402","Energy into DNSP network  at Shoulder times from non-residential embedded generation","GWh",0]
["ED_OPD3413_00003","DOPED0403","Energy into DNSP network  at Off-peak times from non-residential embedded generation","GWh",168.31226084457572]
["ED_OPD3413_00004","DOPED0404","Energy received from embedded generation not included in above categories from non-residential embedded generation","GWh",0]
["ED_OPD3413_00005","DOPED0405","Energy into DNSP network  at On-peak times from residential embedded generation","GWh",364.68029316705775]
["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",139.77874336741218]
["ED_OPD3413_00008","DOPED0408","Energy received from embedded generation not included in above categories from residential embedded generation","GWh",0]
[]
[null,null,"Table 3.4.1.4 Energy grouping  - customer type or class"]
["ED_OPD3414_00001","DOPED0501","Residential customers energy deliveries","GWh",3757.5829614826544]
["ED_OPD3414_00002","DOPED0502","Non residential customers not on demand tariffs energy deliveries","GWh",1538.9814761204366]
["ED_OPD3414_00003","DOPED0503","Non-residential low voltage demand tariff customers energy deliveries","GWh",2997.0424167988231]
["ED_OPD3414_00004","DOPED0504","Non-residential high voltage demand tariff customers energy deliveries","GWh",1925.9775206069792]
["ED_OPD3414_00005","DOPED0505","Other Customer Class Energy Deliveries","GWh",122.91117186319954]
[]
[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",750596]
["ED_OPD3421_00002","DOPCN0102","Non residential customers not on demand tariff customer numbers","number",95733]
["ED_OPD3421_00003","DOPCN0103","Low voltage demand tariff customer numbers","number",5340]
["ED_OPD3421_00004","DOPCN0104","High voltage demand tariff customer numbers","number",236]
["ED_OPD3421_00005","DOPCN0105","Unmetered Customer Numbers","number",2034]
["ED_OPD3421_00006","DOPCN0106","Other Customer Numbers","number",0]
["ED_OPD3421_99999","DOPCN01","Total customer numbers","number",853939]
[]
[null,null,"Table 3.4.2.2 Distribution customer numbers by location on the network"]
["ED_OPD3422_00001","DOPCN0201","Customers on CBD network","number",5113.5]
["ED_OPD3422_00002","DOPCN0202","Customers on Urban network","number",591686.5]
["ED_OPD3422_00003","DOPCN0203","Customers on Short rural network","number",118211.5]
["ED_OPD3422_00004","DOPCN0204","Customers on Long rural network","number",138927.5]
["ED_OPD3422_99999","DOPCN02","Total customer numbers","number",853939]
[]
[null,null,"Table 3.4.2.3 Distribution customer numbers by Aurora Feeder categories (Aurora only)"]
["ED_OPD3423_00001",null,"Critical Infrastructure","number"]
["ED_OPD3423_00002",null,"High Density Commercial","number"]
["ED_OPD3423_00003",null,"Urban","number"]
["ED_OPD3423_00004",null,"High Density Rural","number"]
["ED_OPD3423_00005",null,"Low Density Rural","number"]
["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"]
["ED_OPD3424_00002","DOPCN0302","Unmetered connections not reported in customer numbers in the economic benchmarking RIN","number"]
["ED_OPD3424_99999","DOPCN0303","Total unmetered connections","number"]
[]
[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 ",2780.6677966683524]
["ED_OPD3431_00002","DOPSD0102","Non–coincident Summated Weather Adjusted System Annual Maximum Demand 10% POE","MW ",2828.9653614614949]
["ED_OPD3431_00003","DOPSD0103","Non–coincident Summated Weather Adjusted System Annual Maximum Demand 50% POE","MW ",2590.6618261871536]
["ED_OPD3431_00004","DOPSD0104","Coincident Raw System Annual Maximum Demand","MW ",2418.4607796076548]
["ED_OPD3431_00005","DOPSD0105","Coincident Weather Adjusted System Annual Maximum Demand 10% POE","MW ",2612.8138763243965]
["ED_OPD3431_00006","DOPSD0106","Coincident Weather Adjusted System Annual Maximum Demand 50% POE","MW ",2387.353373417468]
[]
[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 ",2746.4357560000008]
["ED_OPD3432_00002","DOPSD0108","Non–coincident Summated Weather Adjusted System Annual Maximum Demand 10% POE","MW ",2783.8265527387302]
["ED_OPD3432_00003","DOPSD0109","Non–coincident Summated Weather Adjusted System Annual Maximum Demand 50% POE","MW ",2554.1902436348519]
["ED_OPD3432_00004","DOPSD0110","Coincident Raw System Annual Maximum Demand","MW ",2467.7579611607862]
["ED_OPD3432_00005","DOPSD0111","Coincident Weather Adjusted System Annual Maximum Demand 10% POE","MW ",2510.1046134913709]
["ED_OPD3432_00006","DOPSD0112","Coincident Weather Adjusted System Annual Maximum Demand 50% POE","MW ",2297.6431129409061]
[]
[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",2885.3654316615989]
["ED_OPD3433_00002","DOPSD0202","Non–coincident Summated Weather Adjusted System Annual Maximum Demand 10% POE"," MVA",2941.3941527675111]
["ED_OPD3433_00003","DOPSD0203","Non–coincident Summated Weather Adjusted System Annual Maximum Demand 50% POE"," MVA",2694.2379130506906]
["ED_OPD3433_00004","DOPSD0204","Coincident Raw System Annual Maximum Demand"," MVA",2510.5173725785489]
["ED_OPD3433_00005","DOPSD0205","Coincident Weather Adjusted System Annual Maximum Demand 10% POE"," MVA",2713.7946119123008]
["ED_OPD3433_00006","DOPSD0206","Coincident Weather Adjusted System Annual Maximum Demand 50% POE"," MVA",2479.9735350872506]
[]
[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",2788.2576024976584]
["ED_OPD3434_00002","DOPSD0208","Non–coincident Summated Weather Adjusted System Annual Maximum Demand 10% POE"," MVA",2827.1826222349714]
["ED_OPD3434_00003","DOPSD0209","Non–coincident Summated Weather Adjusted System Annual Maximum Demand 50% POE"," MVA",2594.6593649217061]
["ED_OPD3434_00004","DOPSD0210","Coincident Raw System Annual Maximum Demand"," MVA",2496.2507530047014]
["ED_OPD3434_00005","DOPSD0211","Coincident Weather Adjusted System Annual Maximum Demand 10% POE"," MVA",2545.0705261774797]
["ED_OPD3434_00006","DOPSD0212","Coincident Weather Adjusted System Annual Maximum Demand 50% POE"," MVA",2330.1364690504088]
[]
[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.98500072358443691]
["ED_OPD3435_00002","DOPSD0302","Average power factor conversion for  low voltage distribution lines","Factor",0.96422494108655821]
["ED_OPD3435_00003","DOPSD0303","Average power factor conversion for 3.3 kV lines","Factor",0.84726168841545757]
["ED_OPD3435_00004","DOPSD0304","Average power factor conversion for 6.6 kV lines","Factor",0.90144065931985062]
["ED_OPD3435_00005","DOPSD0305","Average power factor conversion for 7.6 kV lines","Factor",0.951732217592549]
["ED_OPD3435_00006","DOPSD0306","Average power factor conversion for 11 kV lines","Factor",0.96467140959975561]
["ED_OPD3435_00007","DOPSD0307","Average power factor conversion for SWER lines","Factor",0.95007581323210222]
["ED_OPD3435_00008","DOPSD0308","Average power factor conversion for 22 kV lines","Factor"]
["ED_OPD3435_00009","DOPSD0309","Average power factor conversion for 33 kV lines","Factor",0.95462133572337093]
["ED_OPD3435_00010","DOPSD0310","Average power factor conversion for 44 kV lines","Factor"]
["ED_OPD3435_00011","DOPSD0311","Average power factor conversion for 66 kV lines","Factor",0.99022952361914252]
["ED_OPD3435_00012","DOPSD0312","Average power factor conversion for 110 kV lines","Factor"]
["ED_OPD3435_00013","DOPSD0313","Average power factor conversion for 132 kV lines","Factor"]
["ED_OPD3435_00013","DOPSD0314","Average power factor conversion for 220 kV lines","Factor"]
[]
[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 ",3.075E-2]
[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",2078.222402713257]
["ED_OPD3437_00002","DOPSD0404","Summated Chargeable Measured Maximum Demand "," MVA",0]

{"sheet":"3.5 Physical assets","index":7,"n_rows":95,"n_cols":7,"rows_kept":95,"cut":false,"hidden":false,"merged":[]}
[null,null,"REGULATORY REPORTING STATEMENT"]
[null,null,{"$f":"dms_TradingName","v":"SA Power Networks"}]
[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",18932]
["ED_PHA3511_00002","DPA0102","Overhead 2.2 kV","km"]
["ED_PHA3511_00003","DPA0103","Overhead 6.6kv","km"]
["ED_PHA3511_00004","DPA0104","Overhead 7.6 kV","km",288]
["ED_PHA3511_00005","DPA0105","Overhead 11 kV","km",17505]
["ED_PHA3511_00006","DPA0106","Overhead SWER","km",29118]
["ED_PHA3511_00007","DPA0107","Overhead 22 kV","km"]
["ED_PHA3511_00008","DPA0108","Overhead 33 kV","km",3957]
["ED_PHA3511_00009","DPA0109","Overhead 44 kV","km"]
["ED_PHA3511_00010","DPA0110","Overhead 66 kV","km",1430]
["ED_PHA3511_00011","DPA0111","Overhead 110kV","km"]
["ED_PHA3511_00012","DPA0112","Overhead 132 kV","km"]
["ED_PHA3511_00013","DPA0113","Overhead 220kV","km"]
["ED_PHA3511_00014","DPA0114","Other ","km"]
[null,"DPA01","Total overhead circuit km","km",{"$f":"SUM(E14:E27)","v":71230}]
[]
[null,null,"Table 3.5.1.2 Underground network circuit length at each voltage"]
["ED_PHA3512_00001","DPA0201","Underground low voltage distribution","km",12851]
["ED_PHA3512_00002","DPA0202","Underground 5 kV","km"]
["ED_PHA3512_00003","DPA0203","Underground 6.6 Kv","km"]
["ED_PHA3512_00004","DPA0204","Underground 7.6 kV","km",110]
["ED_PHA3512_00005","DPA0205","Underground 11 kV","km",3782]
["ED_PHA3512_00006","DPA0206","Underground SWER","km",59]
["ED_PHA3512_00007","DPA0207","Underground 22 kV","km"]
["ED_PHA3512_00008","DPA0208","Underground 33 kV","km",115]
["ED_PHA3512_00010","DPA0209","Underground 66 kV","km",54]
["ED_PHA3512_00009","DPA0210","Underground 110 kV","km"]
["ED_PHA3512_00010","DPA0211","Underground 132 kV","km"]
["ED_PHA3512_00011","DPA0212","Other ","km"]
[null,"DPA02","Total underground circuit km","km",{"$f":"SUM(E31:E42)","v":16971}]
[]
[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.16681802648462909]
["ED_PHA3513_00002","DPA0302","Overhead 6.6 kV","MVA"]
["ED_PHA3513_00003","DPA0303","Overhead 7.6 kV","MVA",3.309400556240341]
["ED_PHA3513_00004","DPA0304","Overhead 11 kV","MVA",3.8946422168318184]
["ED_PHA3513_00005","DPA0305","Overhead SWER","MVA",0.2]
["ED_PHA3513_00006","DPA0306","Overhead 22 kV","MVA"]
["ED_PHA3513_00007","DPA0307","Overhead 33 kV","MVA",10.10654405658396]
["ED_PHA3513_00008","DPA0308","Overhead 44 kV","MVA"]
["ED_PHA3513_00009","DPA0309","Overhead 66 kV","MVA",58.780700139803137]
["ED_PHA3513_00010","DPA0310","Overhead 110 kV","MVA"]
["ED_PHA3513_00011","DPA0311","Overhead 132 kV","MVA"]
["ED_PHA3513_00012","DPA0312","Overhead 220 kV","MVA"]
["ED_PHA3513_00013","DPA0313","Other ","MVA"]
[]
[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",9.5583834053723588E-2]
["ED_PHA3514_00002","DPA0402","Underground 5 kV","MVA"]
["ED_PHA3514_00003","DPA0403","Underground 6.6 kV","MVA"]
["ED_PHA3514_00004","DPA0404","Underground 7.6 kV","MVA",3.2648592709845761]
["ED_PHA3514_00005","DPA0405","Underground 11 kV","MVA",4.7805075551680858]
["ED_PHA3514_00006","DPA0406","Underground SWER","MVA",0.2]
["ED_PHA3514_00007","DPA0407","Underground 12.7 kV","MVA"]
["ED_PHA3514_00008","DPA0408","Underground 22 kV","MVA"]
["ED_PHA3514_00009","DPA0409","Underground 33 kV","MVA",13.562961537897822]
["ED_PHA3514_00010","DPA0410","Underground 66 kV","MVA",127.05508307167651]
["ED_PHA3514_00010","DPA0411","Underground 110 kV","MVA"]
["ED_PHA3514_00011","DPA0412","Underground 132 kV","MVA"]
["ED_PHA3514_00012","DPA0413","Other","MVA"]
[]
[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",8852.7000000000007,null,"Corrected 6 July 2016"]
["ED_PHA3521_00002","DPA0502","Distribution transformer capacity owned by High Voltage Customers","MVA",783.10746834846714]
["ED_PHA3521_00003","DPA0503","Cold spare capacity included in DPA0501","MVA",157.77220000000003]
[]
[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",301.10000000000002]
["ED_PHA3522_00002","DPA0602","Total installed capacity for second step transformation where there are two steps to reach distribution voltage","MVA",125.51499999999999]
["ED_PHA3522_00003","DPA0603","Total zone substation transformer capacity where there is only a single step transformation to reach distribution voltage","MVA",4659.5900000000029]
["ED_PHA3522_00004","DPA0604","Total zone substation transformer  capacity ","MVA",5757.4550000000027]
["ED_PHA3522_00005","DPA0605","Cold spare capacity of zone substation transformers included in DPA0604","MVA",671.25]
[]
[null,null,"Table 3.5.2.3 Distribution - other transformer capacity"]
["ED_PHA3523_00001",null,"Distribution other - transformer capacity owned by utility ","MVA"]
[]
[null,null,"TABLE 3.5.3 - PUBLIC LIGHTING"]
["ED_PHA353_00001","DPA0701","Public lighting luminaires","Number",222805]
["ED_PHA353_00002","DPA0702","Public lighting poles","Number",100270]
["ED_PHA353_00003","DPA0703","Public lighting columns ","Number"]

{"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":"SA Power Networks"}]
[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",160.19999999999999]
["ED_QOS3611_00002","DQS0102","Whole of network unplanned SAIDI excluding excluded outages","minutes/customer",151.9]
["ED_QOS3611_00003","DQS0103","Whole of network unplanned SAIFI","interruptions/customer",1.2470000000000001]
["ED_QOS3611_00004","DQS0104","Whole of network unplanned SAIFI excluding excluded outages","interruptions/customer",1.228]
[null,null,"Table 3.6.1.2 Exclusive of MEDs"]
["ED_QOS3612_00001","DQS0105","Whole of network unplanned SAIDI","minutes/customer",131.30000000000001]
["ED_QOS3612_00002","DQS0106","Whole of network unplanned SAIDI excluding excluded outages","minutes/customer",123.7]
["ED_QOS3612_00003","DQS0107","Whole of network unplanned SAIFI","interruptions/customer",1.131]
["ED_QOS3612_00004","DQS0108","Whole of network unplanned SAIFI excluding excluded outages","interruptions/customer",1.123]
[]
[null,null,"TABLE 3.6.2 - ENERGY NOT SUPPLIED"]
["ED_QOS362_00001","DQS0201","Energy Not Supplied (planned)","GWh",1.7273050021330318]
["ED_QOS362_00002","DQS0202","Energy Not Supplied (unplanned)","GWh",2.9951784226484883]
[null,"DQS02","Total","GWh",{"$f":"SUM(E24:E25)","v":4.7224834247815206}]
[]
[null,null,"TABLE 3.6.3 - SYSTEM LOSSES"]
["ED_QOS363_00001","DQS03","System losses","%",6.2775634050505402E-2]
[]
[null,null,"TABLE 3.6.4 - CAPACITY UTILISATION"]
["ED_QOS364_00001","DQS04","Overall utilisation","%",0.50115292810132217]

{"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":"SA Power Networks"}]
[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",10.513150927640705]
["ED_OEF371_00002","DOEF0102","Energy density","MWh/customer",12.1115156315288]
["ED_OEF371_00003","DOEF0103","Demand density","kVA / customer",3.3788893956847019]
[]
[null,null,"TABLE 3.7.2 - TERRAIN FACTORS"]
["ED_OEF372_00001","DOEF0201","Rural proportion","%",0.73180999999999996]
["ED_OEF372_00002","DOEF0202","Urban and CBD vegetation maintenance spans","Number of spans",31482]
["ED_OEF372_00003","DOEF0203","Rural vegetation maintenance spans","Number of spans",75807]
["ED_OEF372_00004","DOEF0204","Total vegetation maintenance spans","Number of spans",107288.99999999999]
["ED_OEF372_00005","DOEF0205","Total number of spans","Number of spans",745862]
["ED_OEF372_00006","DOEF0206","Average urban and CBD vegetation maintenance span cycle","Years",2.8149999999999999]
["ED_OEF372_00007","DOEF0207","Average rural vegetation maintenance span cycle","Years",1.389]
["ED_OEF372_00008","DOEF0208","Average number of trees per urban and CBD vegetation maintenance span","Trees",3.3769999999999998]
["ED_OEF372_00009","DOEF0209","Average number of trees per rural vegetation maintenance span","Trees",8.5790000000000006]
["ED_OEF372_00010","DOEF0210","Average number of defects per urban and CBD vegetation maintenance span","Defects",1.907]
["ED_OEF372_00011","DOEF0211","Average number of defects per rural vegetation maintenance span","Defects",1.1950000000000001]
["ED_OEF372_00012","DOEF0212","Tropical proportion","Spans",0]
["ED_OEF372_00013","DOEF0213","Standard vehicle access","km",5685.89]
["ED_OEF372_00014","DOEF0214","Bushfire risk","Spans",416550]
[]
[null,null,"TABLE 3.7.3 - SERVICE AREA FACTORS"]
["ED_OEF373_00001","DOEF0301","Route Line length","km",81225.790999999997]

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