{"text_format":"1","workbook":"xlsx","n_sheets":16,"sheets":["AER only","Instructions","Contents","Business & other details","1. Inflation","3.1 Opex","3.2 Provisions","4. Capex","7. Capital Base","7.5 Benefit sharing allowance","8. Revenue","11 - User No. ","12. Demand","13. Pipeline capacity","14. Bill impacts","22. WACC"],"not_rendered":{"charts":0,"images":8,"macros":1,"external_links":8,"defined_names":995,"comments":1,"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":"AER only","index":0,"n_rows":98,"n_cols":40,"rows_kept":98,"cut":false,"hidden":true,"merged":[[81,4,81,11],[0,1,0,11],[3,28,3,38],[4,28,4,31],[4,34,4,38],[44,22,44,26],[45,1,45,5],[45,14,45,21],[45,22,45,26],[46,2,46,3],[46,34,48,34],[49,34,53,34],[57,34,58,34],[63,22,63,25]]}
[null,"Data in these columns used for data validation and database purposes."]
[null,"Date last modified:","2016-08-08","added new business names, improved column heading formatting"]
[null,null,"2016-09-21","changed APA Gasnet trading names"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FOR ELECTRICITY BUSINESSES ONLY"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Feeder Types",null,null,null,"TasNetworks (D)","MAIFI flag","Feeder Names"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CBD","Urban","Short rural","long rural","EXTRA"]
[null,"dms_TradingName_List","dms_TradingNameFull_List","dms_ABN_List","dms_JurisdictionList","dms_Sector_List","dms_Segment_List","dms_FormControl_List","dms_RPT_List","dms_RPTMonth_List","dms_CRCPlength_List","dms_FRCPlength_List","dms_663_List","dms_DeterminationRef_List","dms_Addr1_List","dms_Addr2_List","dms_Suburb_List","dms_State_List","dms_PostCode_List","dms_PAddr1_List","dms_PAddr2_List","dms_PSuburb_List","dms_PState_List","dms_PPostCode_List","dms_ContactName1_List","dms_ContactPh1_List","dms_ContactEmail_List",null,"dms_CBD_flag","dms_Urban_flag","dms_ShortRural_flag","dms_LongRural_flag","dms_FeederType_5_flag","dms_MAIFI_flag_List","dms_FeederName_1","dms_FeederName_2","dms_FeederName_3","dms_FeederName_4","dms_FeederName_5"]
[null,"ActewAGL Distribution","ActewAGL Distribution",76670568688,"ACT","Electricity","Distribution","Revenue cap","Financial","June",5,5,5,"2014-19 Distribution Determination","40 Bunda Street",null,"CANBERRA","ACT","2600","GPO BOX 366",null,"CANBERRA","ACT",2601,"Robert Walker","02 6248 3847","robert.walker@actewagle.com.au",null,"NO","YES","YES","NO","NO",null,"CBD","Urban","Short rural","Long rural",null,"ActewAGL Distribution"]
[null,"ActewAGL Distribution (Tx Assets)","ActewAGL Distribution (Tx Assets)",76670568688,"ACT","Electricity","Distribution","Revenue cap","Financial","June",5,5,5,"distribution determination","40 Bunda Street",null,"CANBERRA","ACT","2600","GPO BOX 366",null,"CANBERRA","ACT",2601,"Robert Walker","02 6248 3847","robert.walker@actewagle.com.au",null,null,null,null,null,null,null,"CBD","Urban","Short rural","Long rural",null,"ActewAGL Distribution (Tx Assets)"]
[null,"ActewAGL Gas","ActewAGL Gas",76670568688,"ACT","Gas","Distribution","Weighted average price cap","Financial","June",5,5,"x",null,"40 Bunda Street",null,"CANBERRA","ACT","2600","GPO BOX 366",null,"CANBERRA","ACT",2601,"Philip Deamer","02 6248 3438","GasAAReview@actewagl.com.au",null,null,null,null,null,null,null,null,null,null,null,null,"ActewAGL Gas"]
[null,"AGN (SA)","AGN (SA)",78551685,"SA","Gas","Distribution","Revenue cap","Financial","June",5,5,5,"distribution determination",null,null,null,"SA",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CBD","Urban","Short rural","Long rural",null,"AGN (SA)"]
[null,"AGN (Victoria)","Australian Gas Networks Limited",19078551685,"Vic","Gas","Distribution","Weighted average price cap","Calendar","December",5,5,"x",null,"Level 10","81 Flinders Street","ADELAIDE","SA","5000",null,null,null,null,null,null,"08 8227 1500",null,null,null,null,null,null,null,null,null,null,null,null,null,"AGN (Victoria)"]
[null,"Amadeus","APT Pipelines (NT) Pty Ltd",39009737393,"NT","Gas","Transmission","Weighted average price cap","Financial","June",5,5,"x","n/a","Level 19, HSBC Building","580 George Street","SYDNEY","NSW","2000","Level 19, HSBC Building","580 George Street","SYDNEY","NSW","2000","Alexandra Curran","02 9275 0020","alexandra.curran@apa.com.au",null,null,null,null,null,null,null,null,null,null,null,null,"Amadeus"]
[null,"APA VTS","APA VTS Australia (Operations) Pty Ltd",65083009,"Vic","Gas","Transmission","Weighted average price cap","Calendar","December",5,5,"x",null,"Level 19, HSBC Building","580 George Street","SYDNEY","NSW","2000","PO Box R41",null,"ROYAL EXCHANGE","NSW","1225",null,"02 9693 0000",null,null,null,null,null,null,null,null,null,null,null,null,null,"APA GasNet"]
[null,"Ausgrid","Ausgrid",67505337385,"NSW","Electricity","Distribution","Revenue cap","Financial","June",5,5,5,"2014-19 Distribution Determination","570 George St",null,"SYDNEY","NSW",2000,null,null,null,null,null,"John Thomson","(02) 9269 2312","john.thomson@ausgrid.com.au",null,"YES","YES","YES","YES","NO",null,"CBD","Urban","Short rural","Long rural",null,"Ausgrid"]
[null,"Ausgrid (Tx Assets)","Ausgrid (Tx Assets)",67505337385,"NSW","Electricity","Distribution","Revenue cap","Financial","June",5,5,5,"distribution determination",null,null,null,"NSW",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CBD","Urban","Short rural","Long rural",null,"Ausgrid (Tx Assets)"]
[null,"AusNet (D)","AusNet Services (D)",91064651118,"Vic","Electricity","Distribution","Revenue cap","Calendar","December",5,5,2,"2016-20 Distribution Determination","Level 32","2 Southbank Boulevard","SOUTHBANK","Vic","3006","Locked Bag 14051",null,"MELBOURNE CITY MAIL CENTRE","VIC",8001,"Hannah Williams","03 9683 4088","hwilliams@powercor.com.au",null,null,"YES","YES","YES","NO",null,"CBD","Urban","Short rural","Long rural",null,"AusNet (D)"]
[null,"AusNet (Gas)","AusNet Gas Services",86015036,"Vic","Gas","Distribution","Weighted average price cap","Calendar","December",5,5,"X",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AusNet (Gas)"]
[null,"AusNet (T)","AusNet (T)",78079798173,"Vic","Electricity","Transmission","Revenue cap","Financial","March",5,5,2,"transmission determination","Level 32","2 Southbank Boulevard","SOUTHBANK","Vic","3006","Locked Bag 14051",null,"MELBOURNE CITY MAIL CENTRE","Vic","8001","Clare Thompson","03 9695 6670","clare.e.thompson@ausnetservices.com.au",null,null,null,null,null,null,null,"CBD","Urban","Short rural","Long rural",null,"AusNet (T)"]
[null,"Australian Distribution Co.","Australian Distribution Co.",11222333444,"-","Electricity","Distribution","Revenue cap","Financial","June",5,5,2,"distribution determination","123 Straight Street",null,"SYDNEY","NSW","2000","PO Box 123",null,"SYDNEY","NSW",2000,"Bob Smith","02 1234 5678","bob@auselec.net.au",null,null,null,null,null,null,null,"CBD","Urban","Short rural","Long rural",null,"Australian Distribution Co."]
[null,"Australian Transmission Co.","Australian Transmission Co.",11222333444,"-","Electricity","Transmission","Revenue cap","Financial","June",5,5,5,"transmission determination","123 Straight Street",null,"SYDNEY","NSW","2000","PO Box 123",null,"SYDNEY","NSW",2000,"Bob Smith","02 1234 5678","bob@auselec.net.au",null,null,null,null,null,null,null,"CBD","Urban","Short rural","Long rural",null,"Australian Transmission Co."]
[null,"CitiPower","CitiPower",76064651056,"Vic","Electricity","Distribution","Revenue cap","Calendar","December",5,5,2,"2016-20 Distribution Determination","40 Market Street",null,"MELBOURNE","Vic","3000","Locked Bag 14090",null,"MELBOURNE","VIC",8001,"Hannah Williams","03 9683 4088","hwilliams@powercor.com.au",null,"YES","YES","NO","NO","NO",null,"CBD","Urban","Short rural","Long rural",null,"CitiPower"]
[null,"Directlink","Directlink",16779340889,"Qld","Electricity","Transmission","Revenue cap","Financial","June",9,5,5,"transmission determination",null,null,null,"NSW",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CBD","Urban","Short rural","Long rural",null,"Directlink"]
[null,"ElectraNet","ElectraNet",41094482416,"SA","Electricity","Transmission","Revenue cap","Financial","June",5,5,5,"transmission determination","52-55 East Terrace","Rymill Park","ADELAIDE","SA","5000","PO Box 7096","Hutt Street Post Office","ADELAIDE","SA",5000,"Bill Jackson","08 8404 7969","jackson.bill@electranet.com.au",null,null,null,null,null,null,null,"CBD","Urban","Short rural","Long rural",null,"ElectraNet"]
[null,"Endeavour Energy","Endeavour Energy",59253130878,"NSW","Electricity","Distribution","Revenue cap","Financial","June",5,5,5,"2014-19 Distribution Determination","51 Huntingwood Drive",null,"HUNTINGWOOD","NSW","2148","PO Box 811",null,"SEVEN HILLS","NSW","1730","Jon Hocking","02 9853 4386 / 0407 348 156","Jon.Hocking@Endeavourenergy.com.au",null,"NO","YES","YES","YES","NO",null,"CBD","Urban","Short rural","Long rural",null,"Endeavour Energy"]
[null,"Energex","Energex",40078849055,"Qld","Electricity","Distribution","Revenue cap","Financial","June",5,5,5,"2015-20 Distribution Determination","26 Reddacliff Street",null,"NEWSTEAD","Qld","4006","26 Reddacliff Street",null,"NEWSTEAD","QLD","4006","Nicola Roscoe","07 3664 5891","nicolaroscoe@energex.com.au",null,"YES","YES","YES","NO","NO",null,"CBD","Urban","Short rural","Long rural",null,"Energex"]
[null,"Ergon Energy","Ergon Energy",50087646062,"Qld","Electricity","Distribution","Revenue cap","Financial","June",5,5,5,"2015-20 Distribution Determination","22 Walker Street",null,"TOWNSVILLE","Qld","4810","Po Box 264",null,"FORTITUDE VALLEY","QLD",4006,"Jenny Doyle, Group Manager Regulatory Affairs","(07) 3851 6416","jenny.doyle@ergon.com.au",null,"NO","YES","YES","YES","NO",null,"CBD","Urban","Short rural","Long rural",null,"Ergon Energy"]
[null,"Essential Energy","Essential Energy",37428185226,"NSW","Electricity","Distribution","Revenue cap","Financial","June",5,5,5,"2014-19 Distribution Determination","8 Buller Street",null,"PORT MACQUARIE","NSW","2444","PO Box 5730",null,"PORT MACQUARIE","NSW","2444","Catherine Waddell","02 6338 3553","catherine.waddell@essentialenergy.com.au",null,null,null,"YES","YES","NO",null,"CBD","Urban","Short rural","Long rural",null,"Essential Energy"]
[null,"Jemena Electricity","Jemena Electricity",82064651083,"Vic","Electricity","Distribution","Revenue cap","Calendar","December",5,5,2,"2016-20 Distribution Determination","Level 16","567 Collins Street","MELBOURNE","VIC","3000","PO Box 16182",null,"MELBOURNE","VIC",8001,"Robert McMillan","03 9173 7000","robert.mcmillan@jemena.com.au",null,null,null,"YES","NO","NO",null,"CBD","Urban","Short rural","Long rural",null,"Jemena Electricity"]
[null,"JGN","Jemena Gas Networks",null,"NSW","Gas","Distribution","Weighted average price cap","Financial","June",5,5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"JGN"]
[null,"Multinet Gas","Multinet Gas (DB No.1) Pty Ltd (ACN 086 026 986), Multinet Gas (DB No.2) Pty Ltd (ACN 086 230 122)",86026986,"Vic","Gas","Distribution","Weighted average price cap","Calendar","December",5,5,"x",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Multinet Gas"]
[null,"Murraylink","Murraylink",79181207909,"SA","Electricity","Transmission","Revenue cap","Financial","June",5,5,5,"transmission determination",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CBD","Urban","Short rural","Long rural",null,"Murraylink"]
[null,"Powercor Australia","Powercor Australia",89064651109,"Vic","Electricity","Distribution","Revenue cap","Calendar","December",5,5,2,"2016-20 Distribution Determination","40 Market Street",null,"MELBOURNE","Vic","3000","Locked bag 14090",null,"MELBOURNE","VIC",8001,"Hannah Williams","03 9683 4088","hwilliams@powercor.com.au",null,null,null,"YES","YES","NO",null,"CBD","Urban","Short rural","Long rural",null,"Powercor Australia"]
[null,"Powerlink","Queensland Electricity Transmission Corporation Limited trading as Powerlink Queensland",82078849233,"Qld","Electricity","Transmission","Revenue cap","Financial","June",5,5,5,"transmission determination","33 Harold St",null,"VIRGINIA","Qld","4014","PO Box 1193",null,"VIRGINIA","QLD",4014,"Jennifer Harris","07 3860 2667","jharris@powerlink.com.au",null,null,null,null,null,null,null,"CBD","Urban","Short rural","Long rural",null,"Powerlink"]
[null,"Roma to Brisbane Pipeline","APT Petroleum Pipelines Limited t/a Roma to Brisbane Pipeline","009 737 393","Qld","Gas","Transmission","Revenue cap","Financial","June",5,5,"x","n/a",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CBD","Urban","Short rural","Long rural",null,"Roma to Brisbane Pipeline"]
[null,"SA Power Networks","SA Power Networks",13332330749,"SA","Electricity","Distribution","Revenue cap","Financial","June",5,5,5,"2015-20 Distribution Determination","1 Anzac Highway",null,"KESWICK","SA","5035","GPO Box 77",null,"ADELAIDE","SA","5000","Damien O'Connor","08 8404 5066","damien.oconnor@sapowernetworks.com.au",null,null,null,"YES","YES","NO",null,"CBD","Urban","Short rural","Long rural",null,"SA Power Networks"]
[null,"TasNetworks (D)","TasNetworks (D)",24167357299,"Tas","Electricity","Distribution","Revenue cap","Financial","June",5,5,5,"distribution determination","21 Kirksway Place",null,"HOBART","Tas","7000","GPO Box 191",null,"HOBART","Tas","7000","Leigh Mayne","03 6270 3691","rrp2012@auroraenergy.com.au",null,null,null,"YES","YES","YES",null,"Critical Infrastructure","High density commercial","Urban","High density rural","Low density rural","TasNetworks (D)"]
[null,"TasNetworks (T)","TasNetworks (T)",24167357299,"Tas","Electricity","Transmission","Revenue cap","Financial","March",5,5,5,"transmission determination","1-7 Maria Street",null,"LENAH VALLEY","Tas","7008","PO Box 606",null,"MOONAH","Tas","7009","Heath Dillon","03 6274 3664","heath.dillon@transend.com.au",null,null,null,null,null,null,null,"CBD","Urban","Short rural","Long rural",null,"TasNetworks (T)"]
[null,"TransGrid","TransGrid",19622755774,"NSW","Electricity","Transmission","Revenue cap","Financial","June",5,4,5,"transmission determination","180 Thomas Street",null,"HAYMARKET","NSW","2000","PO Box A1000",null,"SYDNEY SOUTH","NSW","1235","Andrew Kingsmill","02 9284 3149","andrew.kingsmill@transgrid.com.au",null,null,null,null,null,null,null,"CBD","Urban","Short rural","Long rural",null,"TransGrid"]
[null,"United Energy","United Energy",70064651029,"Vic","Electricity","Distribution","Revenue cap","Calendar","December",5,5,2,"2016-20 Distribution Determination","Level 3","6 Nexus Court","MULGRAVE","Vic","3149","PO Box 449",null,"MOUNT WAVERLEY","VIC",3170,"Mathew Abraham","03 8846 9758","mathew.abraham@ue.com.au",null,null,null,"YES","NO","NO",null,"CBD","Urban","Short rural","Long rural",null,"United Energy"]
[null,"Western Power (D)","Western Power (D)",18540492861,"WA","Electricity","Distribution","Revenue cap","Financial","June",12,4,"x","distribution determination","363 Wellington Street",null,"PERTH","WA","6000","GPO Box L921",null,"PERTH","WA",6842,"Judy Hunter","08 9326 6239","judy.hunter@westernpower.com.au",null,null,null,"YES","YES","NO","NO","CBD","Urban","Short rural","Long rural",null,"Western Power (D)"]
[null,"Western Power (T)","Western Power (T)",18540492861,"WA","Electricity","Transmission","Revenue cap","Financial","June",12,4,"x","transmission determination","363 Wellington Street",null,"PERTH","WA","6000","GPO Box L921",null,"PERTH","WA",6842,"Judy Hunter","08 9326 6239","judy.hunter@westernpower.com.au",null,null,null,"YES","YES","NO",null,"CBD","Urban","Short rural","Long rural",null,"Western Power (T)"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"For EB & Reset RINs only"]
[null,"The Reg Year Ending (dms_RYE) must be set to the last year of the regulatory period. For forecast data is is usually (FRCP_y5) for actual it is a single year (CRY). For historical actual data the RYE will need to be set manually in the business details sheet by setting the dms_Multiyear_flag to 1 and putting the correct value in 'dms_Specified_FinalYear. See cells C67:C68",null,null,null,null,{"$f":"IF(dms_RPT=\"financial\",VALUE(LEFT(CRCP_y1,4)-1)&\"-\"&TEXT(VALUE(RIGHT(CRCP_y1,2)-1),\"00\"),VALUE(LEFT(CRCP_y1,4)-1))","v":2012},null,null,null,null,null,null,"Drop down selector box for CA & Reset RINs.","For CA & Reset RINs only",null,null,null,null,null,null,null,"for DNSP only",null,null,null,null,null,null,null,null,null,null,null,"Reason for interruption","dms_Reason_Interruption_Detailed","dms_Reason_Interruption"]
[null,"dms_Model_List ","DELETE NR 'CRY' IF NOT AN ANNUAL RIN (EB, CA , ARR)",null,"dms_RYE_Formula_Result",null,null,null,null,null,null,null,null,"dms_0203_ProjectType","dms_020303_01_UOM","dms_020501_01_UOM","dms_020501_02_UOM","dms_020501_03_UOM","dms_020501_04_UOM","dms_020603_01_UOM","dms_040102_01_UOM","dms_040102_04_UOM","dms_030601_01_UOM","dms_030601_02_UOM","dms_030701_01_UOM","dms_030702_01_UOM","dms_030703_01_UOM",null,null,null,null,null,null,null,"Animal","Animal impact","Animal"]
[null,"ARR","ANNUAL REPORTING STATEMENT",null,{"$f":"LEFT(dms_SingleYear_FinalYear_Result,2)&RIGHT(dms_SingleYear_FinalYear_Result,2)","v":{"$error":"#REF!"}},"=LEFT(dms_SingleYear_FinalYear_Result,2)&RIGHT(dms_SingleYear_FinalYear_Result,2)",null,"Formula errors are OK",null,null,null,null,null,"New line on new route - single circuit","Circuit line length in km","0's","0's","0's","0's","0's","0's","days","minutes/customer","minutes/customer","Customer / km","%","km",null,null,null,null,null,null,null,null,"Animal nesting/burrowing, etc and other","Asset failure"]
[null,"CA","CATEGORY ANALYSIS",null,{"$f":"LEFT(dms_SingleYear_FinalYear_Result,2)&RIGHT(dms_SingleYear_FinalYear_Result,2)","v":{"$error":"#REF!"}},"=LEFT(dms_SingleYear_FinalYear_Result,2)&RIGHT(dms_SingleYear_FinalYear_Result,2)",null,"Formula errors are OK",null,null,null,null,null,"New line on new route - dual circuit","Circuit line length in km","0's","0's","0's","0's","0's","0's","0's","minutes/customer","minutes/customer","MWh/customer","Number of spans",null,null,null,null,null,null,null,null,null,"Other","Other"]
[null,"CPI","CPI",null,null,null,null,null,null,null,null,null,null,"New line on new route - other","Circuit line length in km","MVA added","MVA added","MVA added","MVA added","0's","0's","$0s","interruptions/customer","interruptions/customer","kVA / customer","Number of spans",null,null,null,null,null,null,null,null,"Asset failure","LV","Overloads"]
[null,"EB","ECONOMIC BENCHMARKING",null,{"$f":"LEFT(dms_SingleYear_FinalYear_Result,2)&RIGHT(dms_SingleYear_FinalYear_Result,2)","v":{"$error":"#REF!"}},"=LEFT(dms_SingleYear_FinalYear_Result,2)&RIGHT(dms_SingleYear_FinalYear_Result,2)",null,"Formula errors are OK",null,null,null,null,null,"Line rebuild over existing route - single circuit","Circuit line length in km","0's","0's","0's","0's","0's","$0s","0's","interruptions/customer","interruptions/customer",null,"Number of spans",null,null,null,null,null,null,null,null,null,"Distribution substation","Planned"]
[null,"PTRM","POST TAX REVENUE MODEL",null,{"$f":"LEFT(dms_MultiYear_FinalYear_Result,2)&RIGHT(dms_MultiYear_FinalYear_Result,2)","v":"2022"},"=LEFT(dms_MultiYear_FinalYear_Result,2)&RIGHT(dms_MultiYear_FinalYear_Result,2)",null,null,null,null,null,null,null,"Line rebuild over existing route - dual circuit","Number","total spend $0s","total spend $0s","total spend $0s","total spend $0s","(per cent)",null,null,null,null,null,"Number of spans",null,null,null,null,null,null,null,null,null,"HV","Network business"]
[null,"Reset","REGULATORY REPORTING STATEMENT",null,{"$f":"LEFT(dms_MultiYear_FinalYear_Result,2)&RIGHT(dms_MultiYear_FinalYear_Result,2)","v":"2022"},"=LEFT(dms_MultiYear_FinalYear_Result,2)&RIGHT(dms_MultiYear_FinalYear_Result,2)",null,"Formula errors are OK",null,null,null,null,null,"Reconductor - Single circuit","Number","net circuit km added","net circuit km added","net circuit km added","net circuit km added",null,null,null,null,null,null,"Years",null,null,null,null,null,null,null,null,null,"Zone substation","Third party"]
[null,"RFM","ROLL FORWARD MODEL",null,{"$f":"LEFT(dms_CRCP_FinalYear_Result,2)&RIGHT(dms_CRCP_FinalYear_Result,2)","v":"2017"},"=LEFT(dms_CRCP_FinalYear_Result,2)&RIGHT(dms_CRCP_FinalYear_Result,2)",null,null,null,null,null,null,null,"Reconductor - Dual circuit","Number","total spend $0s","total spend $0s","total spend $0s","total spend $0s",null,null,null,null,null,null,"Years",null,null,null,null,null,null,null,null,null,"Subtransmission","Unknown"]
[null,"WACC","WEIGHTED AVERAGE COST OF CAPITAL",null,{"$f":"LEFT(dms_MultiYear_FinalYear_Result,2)&RIGHT(dms_MultiYear_FinalYear_Result,2)","v":"2022"},"=LEFT(dms_MultiYear_FinalYear_Result,2)&RIGHT(dms_MultiYear_FinalYear_Result,2)",null,null,null,null,null,null,null,"Other",null,"net circuit km added","net circuit km added","net circuit km added","net circuit km added",null,null,null,null,null,null,"Trees",null,null,null,null,null,null,null,null,"Other","insert description of 'other'","Vegetation"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"total spend $0s","total spend $0s","total spend $0s","total spend $0s",null,null,null,null,null,null,"Trees",null,null,null,null,null,null,null,null,"Overloads","-","Weather"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"0's",null,"$0s",null,null,null,null,null,null,null,"Defects",null,null,null,null,null,null,null,null,"Planned","-","2 - STPIS Exclusion (3.3)(a)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"0's",null,null,null,null,null,null,null,null,null,"Defects",null,null,null,null,null,null,null,null,"Network business","Network error","3 - STPIS Exclusion (3.3)(a)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"0's",null,null,null,null,null,null,null,null,null,"Spans",null,null,null,null,null,null,null,null,null,"Switching and protection error","4 - STPIS Exclusion (3.3)(a)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"$0s",null,null,null,null,null,null,null,null,null,"km",null,null,null,null,null,null,null,null,"Third party","Fire","5 - STPIS Exclusion (3.3)(a)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Spans",null,null,null,"",null,null,null,null,null,"Other","6 - STPIS Exclusion (3.3)(a)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Dig-in","7 - STPIS Exclusion (3.3)(a)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Unauthorised access"]
[null,"For all files either AER or business needs to be able to specify the type of submission","For PTRM & RFM templates we must provide a choice in case they change their form of control - otherwise it is drawn from the business specific lookup table above.",null,"These are indeces and lookup values for various dates. All step from the value placed in FRCP_y1 on the business and other details worksheet",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"for TNSP only",null,null,null,null,null,null,null,null,null,null,null,null,"Vehicle impact"]
[null,"dms_SourceList","dms_FormControl_Choices",null,"dms_FRCPlength_Num_List","dms_FinalYear_List","dms_CRCPlength_Num_List","dms_CFinalYear_List","dms_FRCP_years",null,"dms_CRCP_years",null,"dms_CRCP_index",null,null,null,null,null,null,null,null,null,"dms_030601_01_UOM",null,"dms_030701_01_UOM","dms_030702_01_UOM",null,null,null,null,null,null,null,null,"Unknown","Unknown"]
[null,"After appeal","Revenue cap",null,1,"dms_FRCP_y1",1,"CRCP_y1",{"$f":"FRCP_y1","v":"2018"},"dms_FRCP_y1",{"$f":"IF(dms_RPT=\"financial\",VALUE(LEFT(dms_FRCP_y1,4)-1)&\"-\"&TEXT(VALUE(MID(dms_FRCP_y1,3,2)),\"00\"),VALUE(LEFT(dms_FRCP_y1,4)-1))","v":2017},"dms_CRCP_yZ",1,null,null,null,null,null,null,null,null,null,"%",null,"Number of spans","km",null,null,null,null,null,null,null,null,"Vegetation","Blow-in/Fall-in - NSP responsibility"]
[null,"Draft decision","Revenue yield",null,2,"dms_FRCP_y2",2,"CRCP_y2",{"$f":"IF(dms_RPT=\"financial\",VALUE(LEFT(dms_FRCP_y1,4)+1)&\"-\"&TEXT(VALUE(RIGHT(dms_FRCP_y1,2)+1),\"00\"),VALUE(LEFT(dms_FRCP_y1,4)+1))","v":2019},"dms_FRCP_y2",{"$f":"IF(dms_RPT=\"financial\",VALUE(LEFT(dms_CRCP_yZ,4)-1)&\"-\"&TEXT(VALUE(MID(dms_CRCP_yZ,3,2)),\"00\"),VALUE(LEFT(dms_CRCP_yZ,4)-1))","v":2016},"dms_CRCP_yY",2,null,null,null,null,null,null,null,null,null,"number",null,"Years","%",null,null,null,null,null,null,null,null,null,"Grow-in - NSP responsibility"]
[null,"Final decision","Weighted average price cap",null,3,"dms_FRCP_y3",3,"CRCP_y3",{"$f":"IF(dms_RPT=\"financial\",VALUE(LEFT(dms_FRCP_y2,4)+1)&\"-\"&TEXT(VALUE(RIGHT(dms_FRCP_y2,2)+1),\"00\"),VALUE(LEFT(dms_FRCP_y2,4)+1))","v":2020},"dms_FRCP_y3",{"$f":"IF(dms_RPT=\"financial\",VALUE(LEFT(dms_CRCP_yY,4)-1)&\"-\"&TEXT(VALUE(MID(dms_CRCP_yY,3,2)),\"00\"),VALUE(LEFT(dms_CRCP_yY,4)-1))","v":2015},"dms_CRCP_yX",3,null,null,null,null,null,null,null,null,null,"number",null,"Trees","km",null,null,null,null,null,null,null,null,null,"Blow-in/Fall-in - Other responsible party"]
[null,"PTRM update 1",null,null,4,"dms_FRCP_y4",4,"CRCP_y4",{"$f":"IF(dms_RPT=\"financial\",VALUE(LEFT(dms_FRCP_y3,4)+1)&\"-\"&TEXT(VALUE(RIGHT(dms_FRCP_y3,2)+1),\"00\"),VALUE(LEFT(dms_FRCP_y3,4)+1))","v":2021},"dms_FRCP_y4",{"$f":"IF(dms_RPT=\"financial\",VALUE(LEFT(dms_CRCP_yX,4)-1)&\"-\"&TEXT(VALUE(MID(dms_CRCP_yX,3,2)),\"00\"),VALUE(LEFT(dms_CRCP_yX,4)-1))","v":2014},"dms_CRCP_yW",4,null,null,null,null,null,null,null,null,null,"%",null,"Defects","number",null,null,null,null,null,null,null,null,null,"Grow-in - Other responsible party"]
[null,"PTRM update 2",null,null,5,"dms_FRCP_y5",5,"CRCP_y5",{"$f":"IF(dms_RPT=\"financial\",VALUE(LEFT(dms_FRCP_y4,4)+1)&\"-\"&TEXT(VALUE(RIGHT(dms_FRCP_y4,2)+1),\"00\"),VALUE(LEFT(dms_FRCP_y4,4)+1))","v":2022},"dms_FRCP_y5",{"$f":"IF(dms_RPT=\"financial\",VALUE(LEFT(dms_CRCP_yW,4)-1)&\"-\"&TEXT(VALUE(MID(dms_CRCP_yW,3,2)),\"00\"),VALUE(LEFT(dms_CRCP_yW,4)-1))","v":2013},"dms_CRCP_yV",5,null,null,null,null,null,null,null,null,null,"number",null,"Number of spans",null,null,null,null,null,null,null,null,null,"Weather"]
[null,"PTRM update 3",null,null,6,"dms_FRCP_y6",6,"CRCP_y6",{"$f":"IF(dms_RPT=\"financial\",VALUE(LEFT(dms_FRCP_y5,4)+1)&\"-\"&TEXT(VALUE(RIGHT(dms_FRCP_y5,2)+1),\"00\"),VALUE(LEFT(dms_FRCP_y5,4)+1))","v":2023},"dms_FRCP_y6",{"$f":"IF(dms_RPT=\"financial\",VALUE(LEFT(dms_CRCP_yV,4)-1)&\"-\"&TEXT(VALUE(MID(dms_CRCP_yV,3,2)),\"00\"),VALUE(LEFT(dms_CRCP_yV,4)-1))","v":2012},"dms_CRCP_yU",6,null,null,null,null,null,null,null,null,null,"number",null,"km",null,null,null,null,null,null,null,null,null,"2 - STPIS Exclusion (3.3)(a)"]
[null,"PTRM update 4",null,null,7,"dms_FRCP_y7",7,"CRCP_y7",{"$f":"IF(dms_RPT=\"financial\",VALUE(LEFT(dms_FRCP_y6,4)+1)&\"-\"&TEXT(VALUE(RIGHT(dms_FRCP_y6,2)+1),\"00\"),VALUE(LEFT(dms_FRCP_y6,4)+1))","v":2024},"dms_FRCP_y7",{"$f":"IF(dms_RPT=\"financial\",VALUE(LEFT(dms_CRCP_yU,4)-1)&\"-\"&TEXT(VALUE(MID(dms_CRCP_yU,3,2)),\"00\"),VALUE(LEFT(dms_CRCP_yU,4)-1))","v":2011},"dms_CRCP_yT",7,null,null,null,null,null,null,null,null,null,"%",null,"km",null,null,null,null,null,null,null,null,null,"3 - STPIS Exclusion (3.3)(a)"]
[null,"PTRM update 5",null,null,8,"dms_FRCP_y8",8,"CRCP_y8",{"$f":"IF(dms_RPT=\"financial\",VALUE(LEFT(dms_FRCP_y7,4)+1)&\"-\"&TEXT(VALUE(RIGHT(dms_FRCP_y7,2)+1),\"00\"),VALUE(LEFT(dms_FRCP_y7,4)+1))","v":2025},"dms_FRCP_y8",{"$f":"IF(dms_RPT=\"financial\",VALUE(LEFT(dms_CRCP_yT,4)-1)&\"-\"&TEXT(VALUE(MID(dms_CRCP_yT,3,2)),\"00\"),VALUE(LEFT(dms_CRCP_yT,4)-1))","v":2010},"dms_CRCP_yS",8,null,null,null,null,null,null,null,null,null,"number",null,"Number of spans",null,null,null,null,null,null,null,null,null,"4 - STPIS Exclusion (3.3)(a)"]
[null,"PTRM update 6",null,null,9,"dms_FRCP_y9",9,"CRCP_y9",{"$f":"IF(dms_RPT=\"financial\",VALUE(LEFT(dms_FRCP_y8,4)+1)&\"-\"&TEXT(VALUE(RIGHT(dms_FRCP_y8,2)+1),\"00\"),VALUE(LEFT(dms_FRCP_y8,4)+1))","v":2026},"dms_FRCP_y9",{"$f":"IF(dms_RPT=\"financial\",VALUE(LEFT(dms_CRCP_yS,4)-1)&\"-\"&TEXT(VALUE(MID(dms_CRCP_yS,3,2)),\"00\"),VALUE(LEFT(dms_CRCP_yS,4)-1))","v":2009},"dms_CRCP_yR",9,null,null,null,null,null,null,null,null,null,"number",null,null,null,null,null,null,null,null,null,null,null,"5 - STPIS Exclusion (3.3)(a)"]
[null,"PTRM update 7",null,null,10,"dms_FRCP_y10",10,"CRCP_y10",{"$f":"IF(dms_RPT=\"financial\",VALUE(LEFT(dms_FRCP_y9,4)+1)&\"-\"&TEXT(VALUE(RIGHT(dms_FRCP_y9,2)+1),\"00\"),VALUE(LEFT(dms_FRCP_y9,4)+1))","v":2027},"dms_FRCP_y10",{"$f":"IF(dms_RPT=\"financial\",VALUE(LEFT(dms_CRCP_yR,4)-1)&\"-\"&TEXT(VALUE(MID(dms_CRCP_yR,3,2)),\"00\"),VALUE(LEFT(dms_CRCP_yR,4)-1))","v":2008},"dms_CRCP_yQ",10,null,null,null,null,null,null,null,null,null,"%",null,null,null,null,null,null,null,null,null,null,null,"6 - STPIS Exclusion (3.3)(a)"]
[null,"Regulatory proposal",null,null,11,"dms_FRCP_y11",11,"CRCP_y11",{"$f":"IF(dms_RPT=\"financial\",VALUE(LEFT(dms_FRCP_y10,4)+1)&\"-\"&TEXT(VALUE(RIGHT(dms_FRCP_y10,2)+1),\"00\"),VALUE(LEFT(dms_FRCP_y10,4)+1))","v":2028},"dms_FRCP_y11",{"$f":"IF(dms_RPT=\"financial\",VALUE(LEFT(dms_CRCP_yQ,4)-1)&\"-\"&TEXT(VALUE(MID(dms_CRCP_yQ,3,2)),\"00\"),VALUE(LEFT(dms_CRCP_yQ,4)-1))","v":2007},"dms_CRCP_yP",11,null,null,null,null,null,null,null,null,null,"number",null,null,null,null,null,null,null,null,null,null,null,"7 - STPIS Exclusion (3.3)(a)"]
[null,"Reporting",null,null,12,"dms_FRCP_y12",12,"CRCP_y12",{"$f":"IF(dms_RPT=\"financial\",VALUE(LEFT(dms_FRCP_y11,4)+1)&\"-\"&TEXT(VALUE(RIGHT(dms_FRCP_y11,2)+1),\"00\"),VALUE(LEFT(dms_FRCP_y11,4)+1))","v":2029},"dms_FRCP_y12",{"$f":"IF(dms_RPT=\"financial\",VALUE(LEFT(dms_CRCP_yP,4)-1)&\"-\"&TEXT(VALUE(MID(dms_CRCP_yP,3,2)),\"00\"),VALUE(LEFT(dms_CRCP_yP,4)-1))","v":2006},"dms_CRCP_yO",12,null,null,null,null,null,null,null,null,null,"%"]
[null,"Revised regulatory proposal",null,null,13,"dms_FRCP_y13",13,"CRCP_y13",{"$f":"IF(dms_RPT=\"financial\",VALUE(LEFT(dms_FRCP_y12,4)+1)&\"-\"&TEXT(VALUE(RIGHT(dms_FRCP_y12,2)+1),\"00\"),VALUE(LEFT(dms_FRCP_y12,4)+1))","v":2030},"dms_FRCP_y13",{"$f":"IF(dms_RPT=\"financial\",VALUE(LEFT(dms_CRCP_yO,4)-1)&\"-\"&TEXT(VALUE(MID(dms_CRCP_yO,3,2)),\"00\"),VALUE(LEFT(dms_CRCP_yO,4)-1))","v":2005},"dms_CRCP_yN",13,null,null,null,null,null,null,null,null,null,"number"]
[null,null,null,null,14,"dms_FRCP_y14",14,"CRCP_y14",{"$f":"IF(dms_RPT=\"financial\",VALUE(LEFT(dms_FRCP_y13,4)+1)&\"-\"&TEXT(VALUE(RIGHT(dms_FRCP_y13,2)+1),\"00\"),VALUE(LEFT(dms_FRCP_y13,4)+1))","v":2031},"dms_FRCP_y14",{"$f":"IF(dms_RPT=\"financial\",VALUE(LEFT(dms_CRCP_yN,4)-1)&\"-\"&TEXT(VALUE(MID(dms_CRCP_yN,3,2)),\"00\"),VALUE(LEFT(dms_CRCP_yN,4)-1))","v":2004},"dms_CRCP_yM",14,null,null,null,null,null,null,null,null,null,"%"]
[null,null,null,null,15,"dms_FRCP_y15",15,"CRCP_y15",{"$f":"IF(dms_RPT=\"financial\",VALUE(LEFT(dms_FRCP_y14,4)+1)&\"-\"&TEXT(VALUE(RIGHT(dms_FRCP_y14,2)+1),\"00\"),VALUE(LEFT(dms_FRCP_y14,4)+1))","v":2032},"dms_FRCP_y15",{"$f":"IF(dms_RPT=\"financial\",VALUE(LEFT(dms_CRCP_yM,4)-1)&\"-\"&TEXT(VALUE(MID(dms_CRCP_yM,3,2)),\"00\"),VALUE(LEFT(dms_CRCP_yM,4)-1))","v":2003},"dms_CRCP_yL",15,null,null,null,null,null,null,null,null,null,"number"]
[]
[null,null,null,null,"These are drop down lists for businesses to select the correct FRCP_y1 on the business and other details worksheet.\nThis also populates the column headings in the worksheets"]
[null,"dms_DataQuality_List",null,null,"dms_RCP_fyear_list","dms_CRY_ListF","dms_CRY_ListC","dms_RCP_cyear_list","dms_FRCP_fyear_list","dms_FRCP_ListF","dms_FRCP_ListC","dms_FRCP_cyear_list"]
[null,"Actual",null,null,"dms_fy1","2006-07",2007,"dms_cy1","dms_frcp_fy1","2016-17","2017","dms_crcp_cy1"]
[null,"Estimate",null,null,"dms_fy2","2007-08","2008","dms_cy2","dms_frcp_fy2","2017-18","2018","dms_crcp_cy2"]
[null,"Consolidated",null,null,"dms_fy3","2008-09","2009","dms_cy3","dms_frcp_fy3","2018-19","2019","dms_crcp_cy3"]
[null,"Recast",null,null,"dms_fy4","2009-10","2010","dms_cy4","dms_frcp_fy4","2019-20","2020","dms_crcp_cy4"]
[null,"Public",null,null,"dms_fy5","2010-11","2011","dms_cy5","dms_frcp_fy5","2020-21","2021","dms_crcp_cy5"]
[null,null,null,null,"dms_fy6","2011-12","2012","dms_cy6","dms_frcp_fy6","2021-22","2022","dms_crcp_cy6"]
[null,null,null,null,"dms_fy7","2012-13","2013","dms_cy7","dms_frcp_fy7","2022-23","2023","dms_crcp_cy7"]
[null,null,null,null,"dms_fy8","2013-14","2014","dms_cy8","dms_frcp_fy8","2023-24","2024","dms_crcp_cy8"]
[null,null,null,null,"dms_fy9","2014-15","2015","dms_cy9","dms_frcp_fy9","2024-25","2025","dms_crcp_cy9"]
[null,null,null,null,"dms_fy10","2015-16","2016","dms_cy10","dms_frcp_fy10","2025-26","2026","dms_crcp_cy10"]
[null,null,null,null,"dms_fy11","2016-17","2017","dms_cy11","dms_frcp_fy11","2026-27","2027","dms_crcp_cy11"]
[null,null,null,null,"dms_fy12","2017-18","2018","dms_cy12","dms_frcp_fy12","2027-28","2028","dms_crcp_cy12"]
[null,null,null,null,"dms_fy13","2018-19",2019,"dms_cy13","dms_frcp_fy13","2028-29","2029","dms_crcp_cy13"]
[null,null,null,null,"dms_fy14","2019-20","2020","dms_cy14","dms_frcp_fy14","2029-30","2030","dms_crcp_cy14"]
[null,null,null,null,"dms_fy15","2020-21","2021","dms_cy15","dms_frcp_fy15","2030-31","2031","dms_crcp_cy15"]

{"sheet":"Instructions","index":1,"n_rows":25,"n_cols":4,"rows_kept":25,"cut":false,"hidden":false,"merged":[[24,2,24,4],[1,1,1,5],[2,1,2,5],[3,2,3,4],[4,2,4,4],[5,2,5,4],[7,2,7,3],[8,2,8,4],[10,2,10,4],[12,2,12,4],[20,2,20,4],[22,2,22,4]]}
[]
[null,{"$f":"CONCATENATE(dms_Segment,\" Network Service Provider\")","v":"Transmission Network Service Provider"}]
[null,"Regulatory Reporting RIN Template"]
[null,null,{"$f":"CONCATENATE(\"This template is to be used by \",dms_TradingName,\" to fulfil its reporting obligations to the AER.\")","v":"This template is to be used by APA VTS to fulfil its reporting obligations to the AER."}]
[null,null,"INSTRUCTIONS"]
[null,null,"Complete the Business & other details worksheet before entering data or values in any other worksheets. The Business & other details worksheet is linked to other worksheets within the workbook and automatically generates certain column headings and conditional formatting."]
[]
[null,null,"Identifying CONFIDENTIAL INFORMATION:\n\nPlease use the macro at the top of each \nworksheet to identify confidential information. \n\n"]
[null,null,"-Do this by selecting the cell or cells that contain confidential information and then run the Mark selected cells as CONFIDENTIAL macro. This will format the cells a specific colour that is identified by the AER's database which in turn marks that information as confidential.\n\n-To reverse this, select the cell or cells and run the Return cells to NON-CONFIDENTIAL macro"]
[]
[null,null,"UNITS OF MEASURE\n\nAll amounts are to be unrounded and reported on a one for one basis: that is 1000 is to be entered as '1000'. The units of measure including the dollar terms are as specified in the relevant column headings.\n\n"]
[]
[null,null,"COLOUR CODING OF INPUT / NON-INPUT CELLS:"]
[null,null,null,"Yellow = Input cell (mandatory)"]
[null,null,null,"Darker yellow = input cell (mandatory)"]
[null,null,null,"Orange = input cell (if data available)"]
[null,null,null,"Grey = Not applicable/No inputs required"]
[null,null,null,"Leave coloured cells blank if no information exists. \nPLEASE DO NOT ENTER TEXT into cells that are to contain numeric data."]
[]
[]
[null,null,"WORKSHEET NAVIGATION\n\nSome tables in the worksheets have been \"grouped\" to allow for easy navigation. To ungroup or group data use the outline symbols in the left margin of excel (for Row groupings) or above the columns (for column groupings). \n\n\n\n"]
[]
[null,null,"RETURNING COMPLETED RESPONSES\n\nPlease return two (2) files to the AER: \n1. A confidential version which must contain a complete set of all responses with confidential information marked using the Mark selected cells CONFIDENTIAL macro and which has been completed using the locked template file provided by the AER. \n\n2. A public version with confidential information either removed completely or aggregated in some form together with writtten consent to disclose the public version of the response.\n\nUse the drop down box on the Business and other details worksheet to identify the file as either confidential ('consolidated') or public. "]
[]
[null,null,"SUBMITTING AMENDED DATA TO THE AER\n\nIf an NSP wishes to correct data previously submitted to the AER it should resubmit that data using the original completed submission as the starting point. Please make any necessary changes to the data. Data that is not being amended should be left unchanged. \n\nNSPs must identify the reason for the amendments in the Amendment Reason box on the  Business and other details worksheet. NSPs may provide further details regarding any amendments in the Amendments worksheet. \n\nPlease resubmit two (2) files - a confidential version and a public version of the amended submission to the AER."]

{"sheet":"Contents","index":2,"n_rows":9,"n_cols":3,"rows_kept":9,"cut":false,"hidden":false,"merged":[[3,2,3,6],[4,2,4,6],[6,2,6,6],[7,2,7,6],[8,2,8,6]]}
["."]
[]
[]
[null,null,"Gas Transmission Regulatory Information Notice"]
[null,null,{"$f":"dms_TradingName","v":"APA VTS"}]
[]
[null,null,"for access arrangement period"]
[null,null,{"$f":"IF(SUM(dms_SingleYear_Model)>0,CRY,CONCATENATE(FRCP_y1,\" to \",dms_MultiYear_FinalYear_Result))","v":"2018 to 2022"}]
[null,null,"Table of Contents"]

{"sheet":"Business & other details","index":3,"n_rows":88,"n_cols":12,"rows_kept":88,"cut":false,"hidden":false,"merged":[[82,4,82,8],[18,4,18,7],[19,2,19,3],[19,4,19,7],[22,2,22,3],[22,4,22,7],[23,4,23,7],[24,2,24,3],[24,4,24,7],[32,1,32,8],[49,2,49,3],[51,2,51,8],[7,1,7,8],[11,1,11,8],[13,2,13,4],[14,2,14,4],[17,2,17,3],[17,4,17,7]]}
[null,{"$f":"IF(dms_DataQuality=\"backcast\",INDEX(dms_Worksheet_List,MATCH(dms_Model,dms_Model_List))&\" BACKCAST\",INDEX(dms_Worksheet_List,MATCH(dms_Model,dms_Model_List)))","v":"REGULATORY REPORTING STATEMENT"}]
[null,{"$f":"INDEX(dms_TradingNameFull_List,MATCH(dms_TradingName,dms_TradingName_List))","v":"APA VTS Australia (Operations) Pty Ltd"}]
[null,{"$f":"IF(SUM(dms_SingleYear_Model)>0,CRY,CONCATENATE(FRCP_y1,\" to \",dms_MultiYear_FinalYear_Result))","v":"2018 to 2022"}]
[null,"BUSINESS & OTHER DETAILS"]
[]
[]
[null,"Instructions"]
[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 and conditional formatting to distinguish business specific input and non-input cells. "]
[]
[null,"SUBMISSION PARTICULARS INPUT SHEETS"]
[]
[null,"ENTITY DETAILS"]
[]
[null,"Short name","APA VTS",null,null,"Select business name from drop down list first"]
[null,"ACN / ABN","ACN 083 009 278"]
[]
[]
[null,"Business address","Address 1",null,{"$f":"INDEX(dms_Addr1_List,MATCH(dms_TradingName,dms_TradingName_List))","v":"Level 19, HSBC Building"}]
[null,null,null,"Address 2",{"$f":"IF(ISBLANK(INDEX(dms_Addr2_List,MATCH(dms_TradingName,dms_TradingName_List))),\"\",INDEX(dms_Addr2_List,MATCH(dms_TradingName,dms_TradingName_List)))","v":"580 George Street"}]
[null,null,"Suburb",null,{"$f":"INDEX(dms_Suburb_List,MATCH(dms_TradingName,dms_TradingName_List))","v":"SYDNEY"}]
[null,null,null,"State",{"$f":"INDEX(dms_State_List,MATCH(dms_TradingName,dms_TradingName_List))","v":"NSW"},"p/code",{"$f":"INDEX(dms_PostCode_List,MATCH(dms_TradingName,dms_TradingName_List))","v":"2000"}]
[]
[null,"Postal address","Address 1",null,{"$f":"INDEX(dms_PAddr1_List,MATCH(dms_TradingName,dms_TradingName_List))","v":"PO Box R41"}]
[null,null,null,"Address 2",{"$f":"IF(ISBLANK(INDEX(dms_PAddr2_List,MATCH(dms_TradingName,dms_TradingName_List))),\"\",INDEX(dms_PAddr2_List,MATCH(dms_TradingName,dms_TradingName_List)))","v":""}]
[null,null,"Suburb",null,{"$f":"INDEX(dms_PSuburb_List,MATCH(dms_TradingName,dms_TradingName_List))","v":"ROYAL EXCHANGE"}]
[null,null,null,"State",{"$f":"INDEX(dms_PState_List,MATCH(dms_TradingName,dms_TradingName_List))","v":"NSW"},"p/code",{"$f":"INDEX(dms_PPostCode_List,MATCH(dms_TradingName,dms_TradingName_List))","v":"1225"}]
[]
[]
[null,"Contact name/s","Alexandra Curran",null,null,"Mark Allen"]
[null,"Contact phone/s","(02) 9275 0020",null,null,"(02) 9275 0010"]
[null,"Contact email address/s","alexandra.curran@apa.com.au",null,null,"mark.allen@apa.com.au"]
[]
[null,"REGULATORY CONTROL PERIODS"]
[]
[null,"Forthcoming regulatory control period","2018",{"$f":"dms_FRCP_y2","v":2019},{"$f":"dms_FRCP_y3","v":2020},{"$f":"dms_FRCP_y4","v":2021},{"$f":"dms_FRCP_y5","v":2022},{"$f":"dms_FRCP_y6","v":2023},{"$f":"dms_FRCP_y7","v":2024},{"$f":"dms_FRCP_y8","v":2025},{"$f":"dms_FRCP_y9","v":2026},{"$f":"dms_FRCP_y10","v":2027}]
[]
[null,null,"1 July to 31 December"]
[null,"Current regulatory control period",{"$f":"dms_CRCP_FirstYear_Result","v":2013},{"$f":"IF(dms_RPT=\"financial\",VALUE(LEFT(CRCP_y1,4)+1)&\"-\"&TEXT(MID(CRCP_y1,3,2)+2,\"00\"),VALUE(LEFT(CRCP_y1,4)+1))","v":2014},{"$f":"IF(dms_RPT=\"financial\",VALUE(LEFT(CRCP_y2,4)+1)&\"-\"&TEXT(VALUE(MID(CRCP_y2,3,2)+2),\"00\"),VALUE(LEFT(CRCP_y2,4)+1))","v":2015},{"$f":"IF(dms_RPT=\"financial\",VALUE(LEFT(CRCP_y3,4)+1)&\"-\"&TEXT(VALUE(MID(CRCP_y3,3,2)+2),\"00\"),VALUE(LEFT(CRCP_y3,4)+1))","v":2016},{"$f":"IF(dms_RPT=\"financial\",VALUE(LEFT(CRCP_y4,4)+1)&\"-\"&TEXT(VALUE(MID(CRCP_y4,3,2)+2),\"00\"),VALUE(LEFT(CRCP_y4,4)+1))","v":2017},{"$f":"IF(dms_RPT=\"financial\",VALUE(LEFT(CRCP_y5,4)+1)&\"-\"&TEXT(VALUE(MID(CRCP_y5,3,2)+2),\"00\"),VALUE(LEFT(CRCP_y5,4)+1))","v":2018},{"$f":"IF(dms_RPT=\"financial\",VALUE(LEFT(CRCP_y6,4)+1)&\"-\"&TEXT(VALUE(MID(CRCP_y6,3,2)+2),\"00\"),VALUE(LEFT(CRCP_y6,4)+1))","v":2019},{"$f":"IF(dms_RPT=\"financial\",VALUE(LEFT(CRCP_y7,4)+1)&\"-\"&TEXT(VALUE(MID(CRCP_y7,3,2)+2),\"00\"),VALUE(LEFT(CRCP_y7,4)+1))","v":2020},{"$f":"IF(dms_RPT=\"financial\",VALUE(LEFT(CRCP_y8,4)+1)&\"-\"&TEXT(VALUE(MID(CRCP_y8,3,2)+2),\"00\"),VALUE(LEFT(CRCP_y8,4)+1))","v":2021},{"$f":"IF(dms_RPT=\"financial\",VALUE(LEFT(CRCP_y9,4)+1)&\"-\"&TEXT(VALUE(MID(CRCP_y9,3,2)+2),\"00\"),VALUE(LEFT(CRCP_y9,4)+1))","v":2022}]
[]
[null,null,null,null,null,null,null,"1 January to 30 June"]
[null,"Previous regulatory control period",{"$f":"IF(dms_RPT=\"financial\",VALUE(LEFT(PRCP_y2,4)-1)&\"-\"&TEXT(VALUE(MID(PRCP_y2,3,2)),\"00\"),VALUE(LEFT(PRCP_y2,4)-1))","v":2008},{"$f":"IF(dms_RPT=\"financial\",VALUE(LEFT(PRCP_y3,4)-1)&\"-\"&TEXT(VALUE(MID(PRCP_y3,3,2)),\"00\"),VALUE(LEFT(PRCP_y3,4)-1))","v":2009},{"$f":"IF(dms_RPT=\"financial\",VALUE(LEFT(PRCP_y4,4)-1)&\"-\"&TEXT(VALUE(MID(PRCP_y4,3,2)),\"00\"),VALUE(LEFT(PRCP_y4,4)-1))","v":2010},{"$f":"IF(dms_RPT=\"financial\",VALUE(LEFT(PRCP_y5,4)-1)&\"-\"&TEXT(VALUE(RIGHT(PRCP_y5,2)-1),\"00\"),VALUE(LEFT(PRCP_y5,4)-1))","v":2011},{"$f":"IF(dms_RPT=\"financial\",VALUE(LEFT(CRCP_y1,4)-1)&\"-\"&TEXT(VALUE(RIGHT(CRCP_y1,2)-1),\"00\"),VALUE(LEFT(CRCP_y1,4)-1))","v":2012},2013]
[]
[]
[null,"Current regulatory year","2016-17","CRY"]
[]
[]
[null,null,"DELETE NR 'CRY' IF NOT AN ANNUAL RIN (EB, CA , ARR)"]
[null,null,"APPLY NR 'CRY' IF AN ANNUAL RIN (EB, CA , ARR) - including multi year annual RINs eg. Recast CA. EB"]
[]
[null,"Source","Regulatory proposal",null,"Please select the correct submission type from the dropdown list."]
[null,"Data quality (actual, estimate, public, consolidated)","Consolidated"]
[null,"Amended RIN submission - amendment reason"]
[null,"Submission Date","2017-01-03","dms_SubmissionDate","Please enter date this file submitted to AER (dd/mm/yyyy)"]
[null,"EBSS - First application of scheme in forthcoming period?","No"]
[null,"Sector",{"$f":"INDEX(dms_Sector_List,MATCH(dms_TradingName,dms_TradingName_List))","v":"Gas"},"dms_Sector","=INDEX(dms_Sector_List,MATCH(dms_TradingName,dms_TradingName_List))"]
[null,"Segment",{"$f":"INDEX(dms_Segment_List,MATCH(dms_TradingName,dms_TradingName_List))","v":"Transmission"},"dms_Segment","=INDEX(dms_Segment_List,MATCH(dms_TradingName,dms_TradingName_List))"]
[null,"Regulatory Year Ending",{"$f":"IF(dms_MultiYear_Flag=1,LEFT(dms_Specified_FinalYear,2)&RIGHT(dms_Specified_FinalYear,2),INDEX(dms_RYE_Formula_Result,MATCH(dms_Model,dms_Model_List)))","v":"2022"},"dms_RYE","=IF(dms_MultiYear_Flag=1,LEFT(dms_Specified_FinalYear,2)&RIGHT(dms_Specified_FinalYear,2),INDEX(dms_RYE_Formula_Result,MATCH(dms_Model,dms_Model_List)))"]
[null,"Reporting Period Type",{"$f":"INDEX(dms_RPT_List,MATCH(dms_TradingName,dms_TradingName_List))","v":"Calendar"},"dms_RPT","=INDEX(dms_RPT_List,MATCH(dms_TradingName,dms_TradingName_List))"]
[null,"Model or RIN Type","Reset","dms_Model","Drop down selection"]
[null,"Security Classification","Public","dms_Classification","Always Public"]
[null,"Template - version no.",5,"dms_TemplateNumber"]
[null,"Dollar $ real month",{"$f":"INDEX(dms_RPTMonth_List,MATCH(dms_TradingName,dms_TradingName_List))","v":"December"},"dms_RPTMonth","=INDEX(dms_RPTMonth_List,MATCH(dms_TradingName,dms_TradingName_List))"]
[null,"Dollar $ real  (the last month before the FRCP_y1)",{"$f":"CONCATENATE(dms_RPTMonth)&\" \"&VALUE((LEFT(dms_CRCP_FinalYear_Result,2)&RIGHT(dms_CRCP_FinalYear_Result,2)))","v":"December 2017"},"dms_DollarReal","=IF(SUM(dms_SingleYear_Model)>0,CONCATENATE(dms_RPTMonth)&\" \"&VALUE((LEFT(CRY,2))&RIGHT(CRY,2)),CONCATENATE(dms_RPTMonth)&\" \"&VALUE((LEFT(dms_CRCP_FinalYear_Result,2)&RIGHT(dms_CRCP_FinalYear_Result,2))))"]
[null,"Form of control",{"$f":"INDEX(dms_FormControl_List,MATCH(dms_TradingName,dms_TradingName_List))","v":"Weighted average price cap"},"dms_FormControl","=INDEX(dms_FormControl_List,MATCH(dms_TradingName,dms_TradingName_List))"]
[null,"RIN response - version no.",1,"dms_RINversion"]
[null,"Jurisdiction",{"$f":"INDEX(dms_JurisdictionList,MATCH(dms_TradingName,dms_TradingName_List))","v":"Vic"},"dms_Jurisdiction","=INDEX(dms_JurisdictionList,MATCH(dms_TradingName,dms_TradingName_List))"]
[null,"Backcast Multiyear EB, CA or ARR?",0,"dms_MultiYear_Flag","1=y, 0-n"]
[null,null,2013,"dms_Specified_FinalYear","The result here is returned to dms_CRCP_FinalYear_Result if dms_MultiYear_Flag is set to 1"]
[null,"Single Year Model T/F",{"$f":"IF(dms_Model=\"EB\",1,0)","v":0},"dms_EB"]
[null,null,{"$f":"IF(dms_Model=\"CA\",1,0)","v":0},"dms_CA","=dms_SingleYear_Model"]
[null,null,{"$f":"IF(dms_Model=\"ARR\",1,0)","v":0},"dms_ARR"]
[null,"Single Year Final Year Reference","CRY","dms_SingleYear_FinalYear_Ref","This is the reference for EB, CA & ARR RINs"]
[null,"Single Year Final Year Result",{"$f":"INDIRECT(dms_SingleYear_FinalYear_Ref)","v":{"$error":"#REF!"}},"dms_SingleYear_FinalYear_Result","=INDIRECT(dms_SingleYear_FinalYear_Ref)",null,null,null,"Formula errors OK"]
[null,"FRCP length in years",{"$f":"INDEX(dms_FRCPlength_List,MATCH(dms_TradingName,dms_TradingName_List))","v":5},"dms_FRCPlength_Num","=INDEX(dms_FRCPlength_List,MATCH(dms_TradingName,dms_TradingName_List))"]
[null,"Multi Year Final Year Reference",{"$f":"INDEX(dms_FinalYear_List,MATCH(dms_FRCPlength_Num,dms_FRCPlength_Num_List))","v":"dms_FRCP_y5"},"dms_MultiYear_FinalYear_Ref","=INDEX(dms_FinalYear_List,MATCH(dms_FRCPlength_Num,dms_FRCPlength_Num_List))"]
[null,"Multi Year Final Year Result",{"$f":"IF(dms_MultiYear_Flag=0,INDIRECT(dms_MultiYear_FinalYear_Ref),dms_Specified_FinalYear)","v":2022},"dms_MultiYear_FinalYear_Result","=IF(dms_MultiYear_Flag=0,INDIRECT(dms_MultiYear_FinalYear_Ref),dms_Specified_FinalYear)",null,null,null,"Formula errors OK"]
[null,"CRCP length in years",{"$f":"INDEX(dms_CRCPlength_List,MATCH(dms_TradingName,dms_TradingName_List))","v":5},"dms_CRCPlength_Num","=INDEX(dms_CRCPlength_List,MATCH(dms_TradingName,dms_TradingName_List))"]
[null,"CRCP Final Year Reference",{"$f":"INDEX(dms_CFinalYear_List,MATCH(dms_CRCPlength_Num,dms_CRCPlength_Num_List))","v":"CRCP_y5"},"dms_CRCP_FinalYear_Ref","=INDEX(dms_CFinalYear_List,MATCH(dms_CRCPlength_Num,dms_CRCPlength_Num_List))"]
[null,"CRCP First Year Result",{"$f":"INDEX(dms_CRCP_years,MATCH(dms_CRCPlength_Num,dms_CRCP_index))","v":2013},"dms_CRCP_FirstYear_Result","=INDEX(dms_CRCP_years,MATCH(dms_CRCPlength_Num,dms_CRCP_index))"]
[null,"CRCP Final Year Result",{"$f":"IF(dms_MultiYear_Flag=0,(IF(SUM(dms_SingleYear_Model)>0,CRY,dms_CRCP_yZ)),dms_Specified_FinalYear)","v":2017},"dms_CRCP_FinalYear_Result","=IF(dms_MultiYear_Flag=0,(IF(SUM(dms_SingleYear_Model)>0,CRY,dms_CRCP_yZ)),dms_Specified_FinalYear)"]
[null,"Table 6.6.3 - Public lighting repair - no. business days",{"$f":"INDEX(dms_663_List,MATCH(dms_TradingName,dms_TradingName_List))","v":"x"},"dms_663"]
[null,"Distribution Determination Reference",{"$f":"INDEX(dms_DeterminationRef_List,MATCH(dms_TradingName,dms_TradingName_List))","v":0}]
[null,"Backcast templates only - unit of measure ","$0s","dms_Backcast_UOM","If the cover sheet is for Backcast data ensure to apply dms_Backcast_UOM named range to this field. Otherwise, do not apply this named range."]
[null,"EB/CA Unit of Measure for Monetary Values","$0s","dms_dollar_nom_UOM","If the cover sheet is attached to an EB files make sure this field is set"]
[]
[null,"discard this record?","NO","dms_DISCARD","If record is to be discarded from DB set this flag to YES"]
[]
[null,"USES NAMED RANGES FLAG","yes","dms_Defined_Names_Used"]

{"sheet":"1. Inflation","index":4,"n_rows":12,"n_cols":22,"rows_kept":12,"cut":false,"hidden":false,"merged":[[5,1,5,6],[6,1,6,6],[9,10,9,21],[9,2,9,9]]}
[null,"REGULATORY REPORTING STATEMENT"]
[null,{"$f":"INDEX(dms_TradingNameFull_List,MATCH(dms_TradingName,dms_TradingName_List))","v":"APA VTS Australia (Operations) Pty Ltd"}]
[null,{"$f":"IF(SUM(dms_SingleYear_Model)>0,CRY,CONCATENATE(FRCP_y1,\" to \",dms_MultiYear_FinalYear_Result))","v":"2018 to 2022"}]
[null,"3. INFLATION OR EXTRAPOLATION RATES"]
[]
[null,"Instructions"]
[null,"For each rate used replace the temporary name with the correct name and enter the required details into the yellow cells."]
[]
[null,"3.1 - INFLATION OR EXTRAPOLATION RATES"]
[null,null,"Actual %",null,null,null,null,null,null,null,"Forecast %"]
[null,null,"2008","2009","2010","2011","2012",{"$f":"CRCP_y1","v":2013},{"$f":"CRCP_y2","v":2014},{"$f":"CRCP_y3","v":2015},{"$f":"CRCP_y4","v":2016},{"$f":"CRCP_y5","v":2017},{"$f":"FRCP_y1","v":"2018"},{"$f":"FRCP_y2","v":2019},{"$f":"FRCP_y3","v":2020},{"$f":"FRCP_y4","v":2021},{"$f":"FRCP_y5","v":2022},{"$f":"FRCP_y6","v":2023},{"$f":"FRCP_y7","v":2024},{"$f":"FRCP_y8","v":2025},{"$f":"FRCP_y9","v":2026},{"$f":"FRCP_y10","v":2027}]
[null,"ABS All groups CPI (Australia)",1.9767441860465196E-2,4.4469783352337311E-2,2.0742358078602585E-2,2.4598930481283476E-2,3.5490605427975108E-2,1.2096774193548487E-2,2.3904382470119501E-2,3.0155642023346418E-2,1.5108593012275628E-2,1.0232558139534831E-2,0.02,0.02,0.02,0.02,0.02]

{"sheet":"3.1 Opex","index":5,"n_rows":70,"n_cols":13,"rows_kept":70,"cut":false,"hidden":false,"merged":[[6,1,7,6],[5,1,5,6],[65,1,65,2],[36,1,36,3],[29,1,29,3],[30,1,30,3],[31,1,31,3],[32,1,32,3],[33,1,33,3],[34,1,34,3],[35,1,35,3],[44,1,44,3],[45,1,45,3],[46,1,46,3],[55,1,58,1],[48,1,48,3],[10,2,10,4],[10,5,10,12],[57,4,57,9],[55,4,55,9],[56,4,56,9],[27,4,27,9],[26,4,26,9],[49,1,49,3],[50,1,50,3],[51,1,51,3],[47,1,47,3],[25,4,25,9],[42,4,42,9],[41,4,41,9],[40,4,40,9]]}
[null,"REGULATORY REPORTING STATEMENT"]
[null,{"$f":"INDEX(dms_TradingNameFull_List,MATCH(dms_TradingName,dms_TradingName_List))","v":"APA VTS Australia (Operations) Pty Ltd"}]
[null,{"$f":"IF(SUM(dms_SingleYear_Model)>0,CRY,CONCATENATE(FRCP_y1,\" to \",dms_MultiYear_FinalYear_Result))","v":"2018 to 2022"}]
[null,"3.1 OPERATING EXPENDITURE"]
[]
[null,"Instructions:"]
[null,"Total opex reported in table 3.2.1 must reconcile with  total opex reported in table 3.2.4.  Total category specific forecasts in table 3.2.2 must reconcile with the total category specific forecasts reported in table 3.2.4. Total step changes reported  in table 3.2.3 must reconcile with the total step changes reported in table 3.2.4.   All totals must reconcile with the  proposed opex model."]
[]
[]
[null,"3.1.1 - OPERATING EXPENDITURE"]
[null,null,"EXPENDITURE\nActual ($0's)",null,null,{"$f":"CONCATENATE(\"EXPENDITURE\nForecast ($0's real, \",dms_DollarReal,\")\")","v":"EXPENDITURE\nForecast ($0's real, December 2017)"}]
[null,null,"1 July to 31 December 2013",{"$f":"CRCP_y2","v":2014},{"$f":"CRCP_y3","v":2015},{"$f":"CRCP_y4","v":2016},{"$f":"CRCP_y5","v":2017},{"$f":"FRCP_y1","v":"2018"},{"$f":"FRCP_y2","v":2019},{"$f":"FRCP_y3","v":2020},{"$f":"FRCP_y4","v":2021},{"$f":"FRCP_y5","v":2022},{"$f":"FRCP_y6","v":2023}]
[null,"Labour",4074884.334999999,8804387.6799999997,9743978.123999998,11162015.272700001,11714777.134319423,11468082.57599791,11549947.387567561,11577054.333958045,11970388.464426462,12072306.644721178]
[null,"Materials",674095.47399999993,977269.9439999999,1133993.703,1203229.7973100001,1262815.770493869,1236222.8805761621,1245047.6472715356,1247969.6900043462,1290369.8600915652,1301356.316248649]
[null,"Outside services",794422.24300000002,1606055.5350000001,2412830.003,2173383.6550500002,2027104.9610184045,1984417.357379342,1998583.1040907768,2003273.6436440416,2071335.5075675594,2088971.254839963]
[null,"Other operating costs",1504309.585,2862494.838,3113793.3859999999,3038215.8359099999,3442581.7450418714,3370086.4535530726,3394143.7875202158,3402109.6137359207,3517697.3779525855,3547647.7272377289]
[null,"Overheads/corporate costs",4031744,8920857.25,7528264.0184680084,6436052.732649941,6754776.9417702714,6612532.0919447811,6659735.5969874039,6675365.546609222,6902163.2299484769,6960929.5697864853]
[null,"Equity raising costs",null,null,null,null,null,null,0,0,0,0]
[null,"Debt raising costs",null,null,null,null,null,60438.651248016635,62301.803549242599,62431.633806532795,61523.399882897334,60163.41431802493]
[null,"Insurance costs",606821.02099999995,846264.01100000006,854859.47499999998,654863.59496999998,687293.54700095113,672820.23896695452,677623.16061652114,679213.49640519777,702289.9925763628,708269.42409567256]
[null,"Other overheads",165458,444045.5,307652,299962.93,314817.60127151752,308188.04373004352,310388.04150306131,311116.50127165962,321686.78408903553,324425.6869873539]
[null,"Total operating & maintenance expenditure - Pipeline Service",{"$f":"SUM(C13:C21)","v":11851734.657999998},24461374.758000001,{"$f":"SUM(E13:E21)","v":25095370.709468007},24967723.818589941,26204167.700916305,25712788.293396275,25897770.529106315,{"$f":"SUM(J13:J21)","v":25958534.459434971},26837454.616534948,{"$f":"SUM(L13:L21)","v":27064070.038235057},0]
[]
[null,null,null,null,null,null,0,0,0,0,0,0,0]
[null,"3.1.2 - CATEGORY SPECIFIC FORECASTS"]
[null,null,null,null,"Next access arrangement period"]
[null,null,null,null,{"$f":"CONCATENATE(\"$0's, real \",dms_DollarReal)","v":"$0's, real December 2017"}]
[null,null,null,null,"Forecast"]
[null,null,null,null,{"$f":"FRCP_y1","v":"2018"},{"$f":"FRCP_y2","v":2019},{"$f":"FRCP_y3","v":2020},{"$f":"FRCP_y4","v":2021},{"$f":"FRCP_y5","v":2022},{"$f":"FRCP_y6","v":2023}]
[null,"Augmentation and Expansion related opex",null,null,276101.17499999999,365701.88214285712,365701.88214285712,411576.08214285714,411576.08214285714,0]
[null,"Allowances",null,null,2354585.2329633548,2448103.6092293072,2508737.709300667,2555339.8434153344,2592357.8408578676,0]
[null,"Debt raising costs (as per PTRM)",null,null,60438.651248016635,62301.803549242599,62431.633806532795,61523.399882897334,60163.41431802493,0]
[]
[]
[]
[]
[null,"Total category specific forecasts",null,null,{"$f":"SUM(E30:E36)","v":2691125.0592113715},2876107.294921407,2936871.2252500569,3028439.325441089,3064097.3373187501,0]
[]
[null,null,null,null,0,0,0,0,0,0]
[null,"3.1.3 - STEP CHANGES"]
[null,null,null,null,"Next access arrangement period"]
[null,null,null,null,{"$f":"CONCATENATE(\"$0's, real \",dms_DollarReal)","v":"$0's, real December 2017"}]
[null,null,null,null,"Forecast"]
[null,null,null,null,{"$f":"FRCP_y1","v":"2018"},{"$f":"FRCP_y2","v":2019},{"$f":"FRCP_y3","v":2020},{"$f":"FRCP_y4","v":2021},{"$f":"FRCP_y5","v":2022},{"$f":"FRCP_y6","v":2023}]
[null,"Docklands lease",null,null,158300.67559497617,158300.67559497617,158300.67559497617,158300.67559497617,158300.67559497617,0]
[]
[]
[]
[]
[]
[]
[null,"Total step changes",null,null,{"$f":"SUM(E45:E51)","v":158300.67559497617},158300.67559497617,158300.67559497617,158300.67559497617,158300.67559497617,0]
[]
[]
[null,"3.1.4 - FORECAST OPEX SUMMARY"]
[null,null,null,"Current access arrangement period","Next access arrangement period"]
[null,null,null,null,{"$f":"CONCATENATE(\"$0's, real \",dms_DollarReal)","v":"$0's, real December 2017"}]
[null,null,null,null,"Forecast"]
[null,null,null,{"$f":"CRCP_y5","v":2017},{"$f":"FRCP_y1","v":"2018"},{"$f":"FRCP_y2","v":2019},{"$f":"FRCP_y3","v":2020},{"$f":"FRCP_y4","v":2021},{"$f":"FRCP_y5","v":2022},{"$f":"FRCP_y6","v":2023}]
[null,"Estimated final year opex",null,26204167.700916309,22863362.558589928,22863362.558589935,22863362.558589935,23650714.615498886,23841672.025321327]
[null,"Real price growth",null,null,0,0,0,0,0]
[null,"Output growth",null,null,0,0,0,0,0]
[null,"Productivity growth",null,null,0,0,0,0,0]
[null,"Step changes",null,null,158300.67559497617,158300.67559497617,158300.67559497617,158300.67559497617,158300.67559497617]
[null,"Category specific forecasts",null,null,2691125.0592113715,2876107.294921407,2936871.2252500569,3028439.325441089,3064097.3373187501]
[null,"Total opex",null,null,{"$f":"SUM(E60:E65)","v":25712788.293396279},25897770.529106319,25958534.459434971,26837454.616534952,27064070.038235053,0]
[]
[null,null,null,0,0,0,0,0,0]
[]
[null,"Note: 2017 forecast is calculated including 2016 base year plus step changes and separate forecasts (see forecast opex model for details)"]

{"sheet":"3.2 Provisions","index":6,"n_rows":139,"n_cols":8,"rows_kept":139,"cut":false,"hidden":false,"merged":[[57,5,57,7],[5,1,5,2],[11,2,11,4],[57,2,57,4],[11,5,11,7],[10,2,10,7],[56,2,56,7]]}
[null,"REGULATORY REPORTING STATEMENT"]
[null,{"$f":"INDEX(dms_TradingNameFull_List,MATCH(dms_TradingName,dms_TradingName_List))","v":"APA VTS Australia (Operations) Pty Ltd"}]
[null,{"$f":"IF(SUM(dms_SingleYear_Model)>0,CRY,CONCATENATE(FRCP_y1,\" to \",dms_MultiYear_FinalYear_Result))","v":"2018 to 2022"}]
[null,"3.2 CHANGES IN PROVISIONS"]
[]
[null,"There is ONE table on this worksheet. It has been sub-grouped for ease of navigation. See the Instructions sheet on how to group or ungroup tables. "]
[]
[]
[null,"3.2 - CHANGES IN PROVISIONS"]
[null,"3.2.1 - CHANGES IN PROVISIONS (including RPM)"]
[null,null,"$0's, nominal"]
[null,null,"Actual",null,null,"Forecast"]
[null,null,"1 July to 31 December 2013",{"$f":"CRCP_y2","v":2014},{"$f":"CRCP_y3","v":2015},{"$f":"CRCP_y4","v":2016},{"$f":"CRCP_y5","v":2017},{"$f":"CRCP_y6","v":2018}]
[null,"TOTAL PROVISIONS"]
[null,"Opening Balance",{"$f":"SUM(C61,C69,C77,C85,C93,C101,C109,C117,C125,C133)","v":-14442378.02},{"$f":"SUM(D61,D69,D77,D85,D93,D101,D109,D117,D125,D133)","v":-10484544.970000001},-18668462.539999999,-11532192.390000001,{"$f":"SUM(G61,G69,G77,G85,G93,G101,G109,G117,G125,G133)","v":-11140694.17},-11140694.17]
[null,"Liabilities paid from provision charged to opex",{"$f":"SUM(C62,C70,C78,C86,C94,C102,C110,C118,C126,C134)","v":901908},937018.55,791996.45,1008457.72,{"$f":"SUM(G62,G70,G78,G86,G94,G102,G110,G118,G126,G134)","v":0},0]
[null,"Liabilities paid from provision charged to capex",{"$f":"SUM(C63,C71,C79,C87,C95,C103,C111,C119,C127,C135)","v":0},0,0,0,{"$f":"SUM(G63,G71,G79,G87,G95,G103,G111,G119,G127,G135)","v":0},0]
[null,"Increase /decrease in provision charged to opex",{"$f":"SUM(C64,C72,C80,C88,C96,C104,C112,C120,C128,C136)","v":-447074.95000000007},-2203936.12,-960726.3,-441959.49999999988,{"$f":"SUM(G64,G72,G80,G88,G96,G104,G112,G120,G128,G136)","v":0},0]
[null,"Increase/decrease in provision charged to capex",{"$f":"SUM(C65,C73,C81,C89,C97,C105,C113,C121,C129,C137)","v":0},0,0,0,{"$f":"SUM(G65,G73,G81,G89,G97,G105,G113,G121,G129,G137)","v":0},0]
[null,"Other adjustments",{"$f":"SUM(C66,C74,C82,C90,C98,C106,C114,C122,C130,C138)","v":3503000},-6917000,7305000,-175000,{"$f":"SUM(G66,G74,G82,G90,G98,G106,G114,G122,G130,G138)","v":0},0]
[null,"Closing Balance",{"$f":"SUM(C67,C75,C83,C91,C99,C107,C115,C123,C131,C139)","v":-10484544.970000001},-18668462.539999999,-11532192.390000001,-11140694.17,{"$f":"SUM(G67,G75,G83,G91,G99,G107,G115,G123,G131,G139)","v":-11140694.17},-11140694.17]
[null,"Movement in total provisions",{"$f":"SUM(C68,C76,C84,C92,C100,C108,C116,C124,C132,C140)","v":0},0,0,0,{"$f":"SUM(G68,G76,G84,G92,G100,G108,G116,G124,G132,G140)","v":0},0]
[null,"ALLOCATION OF MOVEMENT IN TOTAL PROVISIONS"]
[null,"Operating and maintenance expenditure",{"$f":"SUM(C16,C18)","v":454833.04999999993},{"$f":"SUM(D16,D18)","v":-1266917.57},-168729.85000000009,566498.22000000009,{"$f":"SUM(G16,G18)","v":0},0]
[null,"Capital expenditure",{"$f":"SUM(C17,C19)","v":0},0,0,0,{"$f":"SUM(G17,G19)","v":0},0]
[null,"ALLOCATION OF MOVEMENT IN PROVISIONS FOR CAPEX BY ASSET CLASS"]
[null,"Pipelines"]
[null,"Compressors"]
[null,"City gates & Field regulators"]
[null,"Odourant plants"]
[null,"Gas quality"]
[null,"Other"]
[null,"General buildings"]
[null,"General land"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Source(s) of data:"]
[]
[]
[]
[null,"3.2.2 - CHANGES IN PROVISIONS BY PROVISION (including RPM)"]
[null,null,"$0's, nominal"]
[null,null,"Actual",null,null,"Forecast"]
[null,null,"1 July to 31 December 2013",{"$f":"CRCP_y2","v":2014},{"$f":"CRCP_y3","v":2015},{"$f":"CRCP_y4","v":2016},{"$f":"CRCP_y5","v":2017},{"$f":"CRCP_y6","v":2018}]
[null,"Provision - Staff Incentive "]
[null,"Opening Balance",-803825.69,{"$f":"C67","v":-315000},{"$f":"D67","v":-393068.45000000007},{"$f":"E67","v":-588506.46000000008},{"$f":"F67","v":0},{"$f":"F67","v":0}]
[null,"Liabilities paid from provision charged to opex",901908,937018.55,791996.45,1008457.72]
[null,"Liabilities paid from provision charged to capex"]
[null,"Increase /decrease in provision charged to opex",-413082.31000000006,-1015087.0000000001,-987434.46,-419951.25999999989]
[null,"Increase/decrease in provision charged to capex"]
[null,"Other adjustments"]
[null,"Closing Balance",{"$f":"C61+SUM(C62:C66)","v":-315000},-393068.45000000007,{"$f":"E61+SUM(E62:E66)","v":-588506.46000000008},0,{"$f":"G61+SUM(G62:G66)","v":0},0]
[null,"Provision - Annual Leave "]
[null,"Opening Balance",-1179344.3700000001,{"$f":"C75","v":-1095508.02},{"$f":"D75","v":-1367347.86},-1286774.6600000001,{"$f":"F75","v":-1251513.4600000002},{"$f":"F75","v":-1251513.4600000002}]
[null,"Liabilities paid from provision charged to opex"]
[null,"Liabilities paid from provision charged to capex"]
[null,"Increase /decrease in provision charged to opex",83836.350000000006,-271839.84000000003,80573.200000000012,35261.200000000004]
[null,"Increase/decrease in provision charged to capex"]
[null,"Other adjustments"]
[null,"Closing Balance",{"$f":"C69+SUM(C70:C74)","v":-1095508.02},-1367347.86,-1286774.6600000001,-1251513.4600000002,{"$f":"G69+SUM(G70:G74)","v":-1251513.4600000002},-1251513.4600000002]
[null,"Provision - Long Service Leave"]
[null,"Opening Balance",-3617207.96,{"$f":"C83","v":-3636036.95},{"$f":"D83","v":-3936046.23},-3646911.27,{"$f":"F83","v":-3633180.71},{"$f":"F83","v":-3633180.71}]
[null,"Liabilities paid from provision charged to opex"]
[null,"Liabilities paid from provision charged to capex"]
[null,"Increase /decrease in provision charged to opex",-18828.989999999991,-300009.27999999985,289134.96000000002,13730.560000000027]
[null,"Increase/decrease in provision charged to capex"]
[null,"Other adjustments"]
[null,"Closing Balance",{"$f":"C77+SUM(C78:C82)","v":-3636036.95},-3936046.23,-3646911.27,-3633180.71,{"$f":"G77+SUM(G78:G82)","v":-3633180.71},-3633180.71]
[null,"Defined Benefit Superannuation Obligation "]
[null,"Opening Balance",-8842000,{"$f":"C91","v":-5438000},{"$f":"D91","v":-12972000},-6010000,{"$f":"F91","v":-6256000},{"$f":"F91","v":-6256000}]
[null,"Liabilities paid from provision charged to opex"]
[null,"Liabilities paid from provision charged to capex"]
[null,"Increase /decrease in provision charged to opex",-99000,-617000,-343000,-71000]
[null,"Increase/decrease in provision charged to capex"]
[null,"Other adjustments",3503000,-6917000,7305000,-175000]
[null,"Closing Balance",{"$f":"C85+SUM(C86:C90)","v":-5438000},-12972000,-6010000,-6256000,{"$f":"G85+SUM(G86:G90)","v":-6256000},-6256000]
[null,"< Insert name of provision >"]
[null,"Opening Balance",null,{"$f":"C99","v":0},{"$f":"D99","v":0},0,{"$f":"E99","v":0},{"$f":"F99","v":0}]
[null,"Liabilities paid from provision charged to opex"]
[null,"Liabilities paid from provision charged to capex"]
[null,"Increase /decrease in provision charged to opex"]
[null,"Increase/decrease in provision charged to capex"]
[null,"Other adjustments"]
[null,"Closing Balance",{"$f":"C93+SUM(C94:C98)","v":0},0,0,0,{"$f":"G93+SUM(G94:G98)","v":0},0]
[null,"< Insert name of provision >"]
[null,"Opening Balance",null,{"$f":"C107","v":0},{"$f":"D107","v":0},0,{"$f":"E107","v":0},{"$f":"F107","v":0}]
[null,"Liabilities paid from provision charged to opex"]
[null,"Liabilities paid from provision charged to capex"]
[null,"Increase /decrease in provision charged to opex"]
[null,"Increase/decrease in provision charged to capex"]
[null,"Other adjustments"]
[null,"Closing Balance",{"$f":"C101+SUM(C102:C106)","v":0},0,0,0,{"$f":"G101+SUM(G102:G106)","v":0},0]
[null,"< Insert name of provision >"]
[null,"Opening Balance",null,{"$f":"C115","v":0},{"$f":"D115","v":0},0,{"$f":"E115","v":0},{"$f":"F115","v":0}]
[null,"Liabilities paid from provision charged to opex"]
[null,"Liabilities paid from provision charged to capex"]
[null,"Increase /decrease in provision charged to opex"]
[null,"Increase/decrease in provision charged to capex"]
[null,"Other adjustments"]
[null,"Closing Balance",{"$f":"C109+SUM(C110:C114)","v":0},0,0,0,{"$f":"G109+SUM(G110:G114)","v":0},0]
[null,"< Insert name of provision >"]
[null,"Opening Balance",null,{"$f":"C123","v":0},{"$f":"D123","v":0},0,{"$f":"E123","v":0},{"$f":"F123","v":0}]
[null,"Liabilities paid from provision charged to opex"]
[null,"Liabilities paid from provision charged to capex"]
[null,"Increase /decrease in provision charged to opex"]
[null,"Increase/decrease in provision charged to capex"]
[null,"Other adjustments"]
[null,"Closing Balance",{"$f":"C117+SUM(C118:C122)","v":0},0,0,0,{"$f":"G117+SUM(G118:G122)","v":0},0]
[null,"< Insert name of provision >"]
[null,"Opening Balance",null,{"$f":"C131","v":0},{"$f":"D131","v":0},0,{"$f":"E131","v":0},{"$f":"F131","v":0}]
[null,"Liabilities paid from provision charged to opex"]
[null,"Liabilities paid from provision charged to capex"]
[null,"Increase /decrease in provision charged to opex"]
[null,"Increase/decrease in provision charged to capex"]
[null,"Other adjustments"]
[null,"Closing Balance",{"$f":"C125+SUM(C126:C130)","v":0},0,0,0,{"$f":"G125+SUM(G126:G130)","v":0},0]
[null,"< Insert name of provision >"]
[null,"Opening Balance",null,{"$f":"C139","v":0},{"$f":"D139","v":0},0,{"$f":"E139","v":0},{"$f":"F139","v":0}]
[null,"Liabilities paid from provision charged to opex"]
[null,"Liabilities paid from provision charged to capex"]
[null,"Increase /decrease in provision charged to opex"]
[null,"Increase/decrease in provision charged to capex"]
[null,"Other adjustments"]
[null,"Closing Balance",{"$f":"C133+SUM(C134:C138)","v":0},0,0,0,{"$f":"G133+SUM(G134:G138)","v":0},0]

{"sheet":"4. Capex","index":7,"n_rows":267,"n_cols":12,"rows_kept":267,"cut":false,"hidden":false,"merged":[[113,1,114,1],[170,1,171,1],[113,2,113,4],[113,5,113,11],[170,2,171,2],[170,3,171,3],[170,4,171,4],[170,5,170,11],[7,1,7,5],[51,1,52,1],[12,1,13,1],[12,5,12,11],[12,2,12,4],[51,2,51,4],[51,5,51,11]]}
[null,"REGULATORY REPORTING STATEMENT"]
[null,{"$f":"INDEX(dms_TradingNameFull_List,MATCH(dms_TradingName,dms_TradingName_List))","v":"APA VTS Australia (Operations) Pty Ltd"}]
[null,{"$f":"IF(SUM(dms_SingleYear_Model)>0,CRY,CONCATENATE(FRCP_y1,\" to \",dms_MultiYear_FinalYear_Result))","v":"2018 to 2022"}]
[null,"4. CAPITAL EXPENDITURE"]
[]
[]
[null,"Instructions"]
[null,"In Tables 4.1.1 - 4.1.3, for each project relevant to augmentations, refurbishments and upgrades, non-system and other capex, insert each project name and then enter the required details into the yellow cells. \n\nIn the Table 4.3 provide the total capital expenditure for the next access arrangement period split by direct labour, materials, contractor and other costs and overheads."]
[]
[null,"4.1 - CAPEX"]
[]
[null,"4.1.1 - EXPANSION (by Project)"]
[null,null,"EXPENDITURE\nActual ($0's)",null,null,{"$f":"CONCATENATE(\"EXPENDITURE\nForecast ($0's real, \",dms_DollarReal,\")\")","v":"EXPENDITURE\nForecast ($0's real, December 2017)"}]
[null,null,"1 July to 31 December 2013",{"$f":"CRCP_y2","v":2014},{"$f":"CRCP_y3","v":2015},{"$f":"CRCP_y4","v":2016},{"$f":"CRCP_y5","v":2017},{"$f":"FRCP_y1","v":"2018"},{"$f":"FRCP_y2","v":2019},{"$f":"FRCP_y3","v":2020},{"$f":"FRCP_y4","v":2021},{"$f":"FRCP_y5","v":2022}]
[null,"Stonehaven CS - now Winchelsea",8134553.96,26606375.390000001,2492547.9799999995,886.04270000000292,0,1456774.406220963,0,0,0,0]
[null,"VNIE Looping 6 to 8",0,0,6392032.4512848351,92414222.78365016,43063099.490152895,0,0,0,0,0]
[null,"Wollert to Clonbinane Looping",4006990.75,85648927.659999996,65640112.890000001,641555.4440999995,0,0,0,0,0,0]
[null,"Warragul Looping",0,0,0,0,0,0,5540353.9566572225,2087002.4512747868,0,0]
[null,"Anglesea Pipeline Extension",0,0,0,0,9267887.2827350423,17048466.253059242,0,0,0,0]
[null,"VTS - EUROA CS NEW (PPOM)",116664.37,121805.28,59020.54,-2970.6523999999999,0,0,0,0,0,0]
[null,"VTS - SUNBURY PIPE LOOP (NEW)",51715.09,38571.050000000003,5019.9499999999989,4069.3708000000001,0,0,0,0,0,0]
[null,"BCS Reconfiguration (2B)",0,0,0,0,0,2010116.4816430588,0,0,0,0]
[null,"WORM Easement",0,0,0,0,0,8897765.1558073591,8897765.1558073591,8897765.1558073591,0,0]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Total",{"$f":"SUM(C15:C46)","v":12309924.17},112415679.38,74588733.81128484,93057762.988850147,52330986.772887938,29413122.296730623,14438119.112464581,10984767.607082145,0,0]
[null,null,0,0,0,0,0,0,0,0,0,0]
[]
[]
[null,"4.1.2 - REPLACEMENT (by Project)"]
[null,null,"EXPENDITURE\nActual ($0's)",null,null,{"$f":"CONCATENATE(\"EXPENDITURE\nForecast ($0's real, \",dms_DollarReal,\")\")","v":"EXPENDITURE\nForecast ($0's real, December 2017)"}]
[null,null,"1 July to 31 December 2013",{"$f":"CRCP_y2","v":2014},{"$f":"CRCP_y3","v":2015},{"$f":"CRCP_y4","v":2016},{"$f":"CRCP_y5","v":2017},{"$f":"FRCP_y1","v":"2018"},{"$f":"FRCP_y2","v":2019},{"$f":"FRCP_y3","v":2020},{"$f":"FRCP_y4","v":2021},{"$f":"FRCP_y5","v":2022}]
[null,"Regulator upgrade - Dandenong City Gate (exclude filters)",479498.95999999996,2616566.96,7811136.25,757968.43800000043,0,0,0,0,0,0]
[null,"BCS Unit 10 & 11 Cooler Upgrade",27089.84,889622.64999999991,5007242.5399999991,3304956.4309000005,0,0,0,0,0,0]
[null,"Pigging Program (T1 Dandenong - Morwell)",0,0,0,0,3000000,0,0,0,0,0]
[null,"Pig Trap - Keon Park Install",325106.7200000002,1640823.98,0,0,0,0,0,0,0,0]
[null,"Pig Trap - Dandenong to Princes Highway Pipeline Install (129)",0,0,31113.5,354230.71479999996,1500000,0,0,0,0,0]
[null,"BCS Station Isolation and Loading Valves",2244.6,16577.75,183683.64,1626560.0853000002,0,0,0,0,0,0]
[null,"Pig Trap - Somerton to Somerton Pipeline Install (238)",0,1590,24041.279999999999,3753.2812000000026,1500000,0,0,0,0,0]
[null,"CP - Cathodic Protection Replacement",18725,98704,20000,90698,50000,238391.23798300279,238391.23798300279,238391.23798300279,238391.23798300279,238391.23798300279]
[null,"Hazardous Area Rectification ",10313.6,32182.300000000003,134741.20000000001,164612.99160000001,100000,182538.24362606226,182538.24362606226,182538.24362606226,182538.24362606226,182538.24362606226]
[null,"Pig Trap - A Branch Valve on Pipeline 108 to Newport Install(124)",0,0,20098.400000000001,877507.21019999997,0,0,0,0,0,0]
[null,"GCS Anti-Surge & Fast-Stop Valves Upgrade ",0,0,10038.5,502275.56539999996,365000,0,0,0,0,0]
[null,"BLP Safety Measures for High Consequence areas-(urban growth, fracture control)",0,0,0,0,0,6193874.870859297,4419045.9567894228,0,0,0]
[null,"WOP Safety Measures for High Consequence areas-(urban growth, fracture control)",0,0,0,0,0,4614866.8862700649,3255708.3178092539,0,0,0]
[null,"BCP Safety Measures for High Consequence areas-(urban growth, fracture control)",0,0,0,0,0,3190712.6774315382,2275996.7888574121,0,0,0]
[null,"Turbine Overhauls",0,0,0,0,0,0,0,0,1030207.477707561,3686038.0452386132]
[null,"Pig Trap Installation Trugannina to Plumpton",0,0,0,0,0,0,0,0,3004080.4612603462,331199.54957845405]
[null,"BCS Unit 10 & 11 controls upgrade",0,0,0,0,0,0,0,0,1278493.0898016992,1278493.0898016992]
[null,"Pigging Program T60 Longford -Dandenong",0,0,0,0,0,0,0,0,0,2441626.2962039653]
[null,"VNIE Safety Measures for High Consequence areas-(urban growth, fracture control)",0,0,0,0,0,1249201.8939848908,1067344.9264966943,0,0,0]
[null,"BCS Unit 8 & 9 controls upgrade",0,0,0,0,0,0,1145688.6520113309,1145688.6520113309,0,0]
[null,"Pig Trap Installation James Street to Laverton Pipeline (253)",0,0,0,0,0,0,1943118.4829984305,213148.34836794669,0,0]
[null,"Actuate MLV's in T1 areas",0,0,0,0,0,981102.44985835685,981102.44985835685,0,0,0]
[null,"Pig Trap Installation Regent St Pipeline (36)",0,0,0,0,0,0,0,1649568.0703472039,212993.90070360212,0]
[null,"Coogee Decommissioning",0,0,0,0,0,1818932.1500283279,0,0,0,0]
[null,"Iona CS aftercooler augmentation",0,0,0,0,0,0,0,0,1698571.0674220964,0]
[null,"Pig Trap Installation Packenham (200mm)",0,0,0,0,0,0,0,1475634.8941124773,195619.09791964968,0]
[null,"Pigging Program T24 Brooklyn - Corio",0,0,0,0,0,0,0,0,1415864.080679886,0]
[null,"Pigging Program T16 Dandenong – West Melbourne",0,0,0,0,0,0,0,0,1412896.2139376763,0]
[null,"Emergency- Response Equipment",0,0,0,0,0,264381.66424151126,264381.66424151126,264381.66424151126,264381.66424151126,264381.66424151126]
[null,"BCS Unit 8,9,10,11 electric start conversion",0,0,0,0,0,0,0,0,0,1319112.1150708213]
[null,"Iona CS Automation replacement",0,0,0,0,0,0,0,1203328.5481019828,0,0]
[null,"BCS Unit 8,9,10,11 exhaust stack replacement",0,0,0,0,0,0,0,0,1191630.2258356938,0]
[null,"Pig Trap Installation Laverton North to Laverton North Pipeline (162)",0,0,0,0,0,0,1044759.3325732219,139587.27241048447,0,0]
[null,"Pig Trap Installation Somerton to Somerton",0,0,0,0,0,1056063.6340894187,120828.8032531772,0,0,0]
[null,"BCS Unit 8,9,10,11 Fuel Gas Modification",0,0,0,0,0,1136433.9733144473,0,0,0,0]
[null,"Pigging Program T1 Morwell - Dandenong Repair Program",0,0,0,0,0,949120.2318413594,178554.93099150134,0,0,0]
[null,"Compressor Type B Compliance",0,0,0,0,0,222243.94186968825,222243.94186968825,222243.94186968825,222243.94186968825,222243.94186968825]
[null,"WCS A Process Safety",0,0,0,0,0,0,0,1072161.7142209627,0,0]
[null,"Pigging Program T33 South Melbourne – Brooklyn",0,0,0,0,0,0,0,0,1049759.800566572,0]
[null,"Compressor Station Vent Stack Upgrade (BCS, WCS, GCS, SCS)",0,0,0,0,0,0,338821.45790368255,338821.45790368255,338821.45790368255,0]
[null,"BBP Safety Measures for High Consequence areas-(urban growth, fracture control)",0,0,0,0,0,543570.11581680796,459010.15467422071,0,0,0]
[null,"Culcairn Injection Gas Quality equipment",0,0,0,0,0,998792.25155807321,0,0,0,0]
[null,"GCS unit discharge and station manifold check valves replacement",0,0,0,0,0,0,0,924949.3175070819,0,0]
[null,"Pipe Support replacement",0,0,0,0,0,169013.02201019821,169013.02201019821,169013.02201019821,169013.02201019821,169013.02201019821]
[null,"Remote CP/critical drainage bond monitoring",0,0,0,0,0,587664.21403840091,61997.94082467736,61997.94082467736,61997.94082467736,61997.94082467736]
[null,"Pigging Program T60 Longford – Tyers",0,0,0,0,0,0,0,0,0,767479.05087818683]
[null,"Other Replacement (details in forecast capex model)",687463.28,2225620.6800000002,966237.34000000008,2946756.3959000004,1590000,7672470.7730204025,4360649.5336132683,2632272.365260982,2394161.2115193112,2395848.963205718]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Total",{"$f":"SUM(C54:C109)","v":1550442.0000000002},7521688.3200000003,14208332.649999999,10629319.113300001,8105000,32069374.231841847,22729195.838385113,11933726.690799274,16361664.13581292,13358363.160532599]
[null,null,0,0,0,0,0,0,0,0,0,0]
[]
[null,"4.1.3 - NON SYSTEM CAPEX"]
[null,null,"EXPENDITURE\nActual ($0's)",null,null,{"$f":"CONCATENATE(\"EXPENDITURE\nForecast ($0's real, \",dms_DollarReal,\")\")","v":"EXPENDITURE\nForecast ($0's real, December 2017)"}]
[null,null,"1 July to 31 December 2013",{"$f":"CRCP_y2","v":2014},{"$f":"CRCP_y3","v":2015},{"$f":"CRCP_y4","v":2016},{"$f":"CRCP_y5","v":2017},{"$f":"FRCP_y1","v":"2018"},{"$f":"FRCP_y2","v":2019},{"$f":"FRCP_y3","v":2020},{"$f":"FRCP_y4","v":2021},{"$f":"FRCP_y5","v":2022}]
[null,"Enterprise Asset Management",806330.32735472836,1986550.9701373517,2564771.5454456266,1789.5946402541681,0,0,0,0,0,0]
[null,"Dandenong site fire mains replacement",4961.33781,88164.18140999999,1020411.51696,30477.795400499999,47050,0,0,0,0,0]
[null,"Corporate IT",211241.59609766386,302736.87171848048,276048.92102265212,378067.59072475095,0.27530366714927368,0,0,0,0,0]
[null,"SCADA - Comms upgrade to IP network-VTS only",0,0,0,56484.25,1000000,0,0,0,0,0]
[null,"Data Centre",65362.018908852959,895833.23438823572,79250.174489848083,0,0,0,0,0,0,0]
[null,"Equipment - Victorian low value pool purchases",52890.504699999998,215346.10914999997,550230.76062000007,165018.12962759999,28230,0,0,0,0,0]
[null,"SCADA System Upgrade",0,0,25383.25,114169.9253,450000,410198.30028328602,0,0,0,0]
[null,"Corporate other ",242365.2632114446,340342.97298974404,308327.88047802,17698.081034217437,0,0,0,0,0,0]
[null,"APA Grid Extend Program ",0,0,0,0,261222.2369554062,267882.29398826347,0,0,0,0]
[null,"BI - Transmission Dashboard and Enterprise Pilot ",0,0,0,0,125386.67373859498,214305.83519061081,160729.3763929581,0,0,0]
[null,"Enterprise Content Management",0,0,104729.08412195355,329210.01831734658,-5.1116942660883069E-2,0,0,0,0,0]
[null,"Dandenong Relocation",0,0,0,0,5057811.8724316359,0,0,0,0,0]
[null,"WAN Upgrade (Satellite project)",0,0,0,0,0,971136.18991501362,971136.18991501362,971136.18991501362,971136.18991501362,971136.18991501362]
[null,"Applications Renewal",0,0,0,0,0,739355.13140760723,923658.14967153256,739355.13140760723,923658.14967153256,739355.13140760723]
[null,"Storage shed-Dandenong, Wollert & Springhurst",0,0,0,0,0,0,616300.67733666999,616300.67733666999,616300.67733666999,0]
[null,"Other Non System (details in forecast capex model)",352672.28126825538,408852.67037748056,800943.28713415144,1283725.325636707,1581119.3715806098,2009398.7527687494,854175.389207158,877630.79659194499,1005995.2214817875,565318.37788979337]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Total",{"$f":"SUM(C116:C165)","v":1735823.3293509451},4237827.0101712923,5730096.4202722516,2376640.710681376,8550820.3788929712,4612276.5035535302,3525999.7825233322,3204422.7952512358,3517090.2384050037,2275809.6992124142]
[null,null,0,0,0,0,0,0,0,0,0,0]
[]
[]
[null,"4.3 - FORECAST CAPEX"]
[null,null,null,null,null,{"$f":"CONCATENATE(\"EXPENDITURE\nForecast ($0's real, \",dms_DollarReal,\")\")","v":"EXPENDITURE\nForecast ($0's real, December 2017)"}]
[null,null,null,null,null,{"$f":"CRCP_y4","v":2016},{"$f":"CRCP_y5","v":2017},{"$f":"FRCP_y1","v":"2018"},{"$f":"FRCP_y2","v":2019},{"$f":"FRCP_y3","v":2020},{"$f":"FRCP_y4","v":2021},{"$f":"FRCP_y5","v":2022}]
[null,"Direct labour expenditure",null,null,null,13777551.480597425,10296658.230284238,18971344.888271943,8158137.4516712958,4638135.6001216443,4944666.9468483524,4090711.0227008411]
[null,"Direct materials expenditure",null,null,null,31494226.582876518,19259904.591681283,16087606.412478881,10028413.200748131,5048121.3461515345,4270298.2502603959,2882681.4597220034]
[null,"Direct contractor expenditure",null,null,null,56200349.904548086,35202122.698741913,18337201.442598354,13401344.83692761,7382692.4232219178,10507586.609278968,8572944.1928725094]
[null,"Other direct expenditure",null,null,null,4591594.9562875694,4228121.2521805149,12698620.288776824,9105419.244025996,9053967.723637566,156202.56783020654,87836.184449658875]
[null,"Overheads",null,null,null,0,0]
[null,"Total",null,null,null,{"$f":"SUM(F173:F177)","v":106063722.92430958},68986806.772887945,66094773.032126002,40693314.733373031,26122917.09313266,19878754.37421792,15634172.859745013]
[]
[null,null,null,null,null,{"$f":"F47+F110+F166-F178","v":-0.1114780604839325},{"$f":"G47+G110+G166-G178","v":0.37889295816421509},0,0,0,0,0]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[" "]

{"sheet":"7. Capital Base","index":8,"n_rows":534,"n_cols":12,"rows_kept":534,"cut":false,"hidden":false,"merged":[[531,1,531,11],[533,1,533,11],[8,2,8,4],[8,5,8,11],[5,1,5,2],[269,2,269,4],[269,5,269,11]]}
[null,"REGULATORY REPORTING STATEMENT"]
[null,{"$f":"INDEX(dms_TradingNameFull_List,MATCH(dms_TradingName,dms_TradingName_List))","v":"APA VTS Australia (Operations) Pty Ltd"}]
[null,{"$f":"IF(SUM(dms_SingleYear_Model)>0,CRY,CONCATENATE(FRCP_y1,\" to \",dms_MultiYear_FinalYear_Result))","v":"2018 to 2022"}]
[null,"7. CAPITAL BASE"]
[]
[null,"There are ONE table on this worksheet. Each sub-table has been 'grouped' for easy navigation.  See the Instructions sheet on how to group or ungroup data."]
[]
[null,"7.1 - CAPITAL EXPENDITURE - AS INCURRED (by driver)"]
[null,null,"EXPENDITURE\nActual ($0's)",null,null,{"$f":"CONCATENATE(\"EXPENDITURE\nForecast ($0's real, \",dms_DollarReal,\")\")","v":"EXPENDITURE\nForecast ($0's real, December 2017)"}]
[null,null,"1 July to 31 December 2013",{"$f":"CRCP_y2","v":2014},{"$f":"CRCP_y3","v":2015},{"$f":"CRCP_y4","v":2016},{"$f":"CRCP_y5","v":2017},{"$f":"FRCP_y1","v":"2018"},{"$f":"FRCP_y2","v":2019},{"$f":"FRCP_y3","v":2020},{"$f":"FRCP_y4","v":2021},{"$f":"FRCP_y5","v":2022}]
[null,"PIPELINE"]
[null,"Replacement"]
[null,"Conforming capital expenditure",52902.3,138555.75,40185.4,1125263.7452,210000,20778554.453968041,15845201.629424894,3883697.5562568088,3581706.481893796,500212.57158865227]
[null,"Non-conforming capital expenditure - recovered by a surcharge"]
[null,"Non-conforming capital expenditure - added to the speculative capital expenditure account"]
[null,"Non-conforming capital expenditure - other"]
[null,"Capital contributions rolled into the capital base"]
[null,"Speculative capital expenditure account rolled into the capital base"]
[null,"Re-use of redundant assets rolled into the capital base"]
[null,"Redundant assets rolled out of the capital base"]
[null,"Disposals"]
[null,"Expansion"]
[null,"Conforming capital expenditure",4058705.84,85687498.709999993,72037165.291284844,93059847.598550156,52330986.772887938,17048466.253059242,5540353.9566572225,2087002.4512747868,0,0]
[null,"Non-conforming capital expenditure - recovered by a surcharge"]
[null,"Non-conforming capital expenditure - added to the speculative capital expenditure account"]
[null,"Non-conforming capital expenditure - other"]
[null,"Capital contributions rolled into the capital base"]
[null,"Speculative capital expenditure account rolled into the capital base"]
[null,"Re-use of redundant assets rolled into the capital base"]
[null,"Redundant assets rolled out of the capital base"]
[null,"Disposals"]
[null,"Non-system"]
[null,"Conforming capital expenditure",null,null,null,null,0,0,0,0,0,0]
[null,"Non-conforming capital expenditure - recovered by a surcharge"]
[null,"Non-conforming capital expenditure - added to the speculative capital expenditure account"]
[null,"Non-conforming capital expenditure - other"]
[null,"Capital contributions rolled into the capital base"]
[null,"Speculative capital expenditure account rolled into the capital base"]
[null,"Re-use of redundant assets rolled into the capital base"]
[null,"Redundant assets rolled out of the capital base"]
[null,"Disposals"]
[]
[null,"COMPRESSORS"]
[null,"Replacement"]
[null,"Conforming capital expenditure",150026.93,1070306.1099999999,5214100.6799999988,6351963.093700001,965000,5381714.9878638322,2141313.7659112359,5331213.2532084966,6183986.8821341889,7238641.7261451278]
[null,"Non-conforming capital expenditure - recovered by a surcharge"]
[null,"Non-conforming capital expenditure - added to the speculative capital expenditure account"]
[null,"Non-conforming capital expenditure - other"]
[null,"Capital contributions rolled into the capital base"]
[null,"Speculative capital expenditure account rolled into the capital base"]
[null,"Re-use of redundant assets rolled into the capital base"]
[null,"Redundant assets rolled out of the capital base"]
[null,"Disposals"]
[null,"Expansion"]
[null,"Conforming capital expenditure",8251218.3300000001,26728180.670000002,2551568.5199999996,886.04270000000292,0,3466890.8878640216,0,0,0,0]
[null,"Non-conforming capital expenditure - recovered by a surcharge"]
[null,"Non-conforming capital expenditure - added to the speculative capital expenditure account"]
[null,"Non-conforming capital expenditure - other"]
[null,"Capital contributions rolled into the capital base"]
[null,"Speculative capital expenditure account rolled into the capital base"]
[null,"Re-use of redundant assets rolled into the capital base"]
[null,"Redundant assets rolled out of the capital base"]
[null,"Disposals"]
[null,"Non-system"]
[null,"Conforming capital expenditure",15596189.499350945,124175194.71017128,94527162.881557092,106063722.81283152,0,0,0,0,0,84093.453212464548]
[null,"Non-conforming capital expenditure - recovered by a surcharge"]
[null,"Non-conforming capital expenditure - added to the speculative capital expenditure account"]
[null,"Non-conforming capital expenditure - other"]
[null,"Capital contributions rolled into the capital base"]
[null,"Speculative capital expenditure account rolled into the capital base"]
[null,"Re-use of redundant assets rolled into the capital base"]
[null,"Redundant assets rolled out of the capital base"]
[null,"Disposals"]
[]
[null,"CITY GATES & FIELD REGULATORS"]
[null,"Replacement"]
[null,"Conforming capital expenditure",1103730.3900000001,5106391.5600000005,8375791.2600000007,1518056.6438000007,3460000,0,635046.24249291758,351074.6143909347,678111.43405099108,245102.23394900837]
[null,"Non-conforming capital expenditure - recovered by a surcharge"]
[null,"Non-conforming capital expenditure - added to the speculative capital expenditure account"]
[null,"Non-conforming capital expenditure - other"]
[null,"Capital contributions rolled into the capital base"]
[null,"Speculative capital expenditure account rolled into the capital base"]
[null,"Re-use of redundant assets rolled into the capital base"]
[null,"Redundant assets rolled out of the capital base"]
[null,"Disposals"]
[null,"Expansion"]
[null,"Conforming capital expenditure",null,null,null,null,0,0,0,0,0,0]
[null,"Non-conforming capital expenditure - recovered by a surcharge"]
[null,"Non-conforming capital expenditure - added to the speculative capital expenditure account"]
[null,"Non-conforming capital expenditure - other"]
[null,"Capital contributions rolled into the capital base"]
[null,"Speculative capital expenditure account rolled into the capital base"]
[null,"Re-use of redundant assets rolled into the capital base"]
[null,"Redundant assets rolled out of the capital base"]
[null,"Disposals"]
[null,"Non-system"]
[null,"Conforming capital expenditure",null,null,null,null,0,0,0,0,0,0]
[null,"Non-conforming capital expenditure - recovered by a surcharge"]
[null,"Non-conforming capital expenditure - added to the speculative capital expenditure account"]
[null,"Non-conforming capital expenditure - other"]
[null,"Capital contributions rolled into the capital base"]
[null,"Speculative capital expenditure account rolled into the capital base"]
[null,"Re-use of redundant assets rolled into the capital base"]
[null,"Redundant assets rolled out of the capital base"]
[null,"Disposals"]
[]
[null,"ODOURANT PLANTS"]
[null,"Replacement"]
[null,"Conforming capital expenditure",null,null,null,null,0,77495.893484419255,0,0,0,0]
[null,"Non-conforming capital expenditure - recovered by a surcharge"]
[null,"Non-conforming capital expenditure - added to the speculative capital expenditure account"]
[null,"Non-conforming capital expenditure - other"]
[null,"Capital contributions rolled into the capital base"]
[null,"Speculative capital expenditure account rolled into the capital base"]
[null,"Re-use of redundant assets rolled into the capital base"]
[null,"Redundant assets rolled out of the capital base"]
[null,"Disposals"]
[null,"Expansion"]
[null,"Conforming capital expenditure",null,null,null,null,0,0,0,0,0,0]
[null,"Non-conforming capital expenditure - recovered by a surcharge"]
[null,"Non-conforming capital expenditure - added to the speculative capital expenditure account"]
[null,"Non-conforming capital expenditure - other"]
[null,"Capital contributions rolled into the capital base"]
[null,"Speculative capital expenditure account rolled into the capital base"]
[null,"Re-use of redundant assets rolled into the capital base"]
[null,"Redundant assets rolled out of the capital base"]
[null,"Disposals"]
[null,"Non-system"]
[null,"Conforming capital expenditure",null,null,null,null,0,0,0,0,0,0]
[null,"Non-conforming capital expenditure - recovered by a surcharge"]
[null,"Non-conforming capital expenditure - added to the speculative capital expenditure account"]
[null,"Non-conforming capital expenditure - other"]
[null,"Capital contributions rolled into the capital base"]
[null,"Speculative capital expenditure account rolled into the capital base"]
[null,"Re-use of redundant assets rolled into the capital base"]
[null,"Redundant assets rolled out of the capital base"]
[null,"Disposals"]
[]
[null,"GAS QUALITY"]
[null,"Replacement"]
[null,"Conforming capital expenditure",0,91009.78,285847.41000000003,354457.98500000004,50000,0,0,0,0,0]
[null,"Non-conforming capital expenditure - recovered by a surcharge"]
[null,"Non-conforming capital expenditure - added to the speculative capital expenditure account"]
[null,"Non-conforming capital expenditure - other"]
[null,"Capital contributions rolled into the capital base"]
[null,"Speculative capital expenditure account rolled into the capital base"]
[null,"Re-use of redundant assets rolled into the capital base"]
[null,"Redundant assets rolled out of the capital base"]
[null,"Disposals"]
[null,"Expansion"]
[null,"Conforming capital expenditure",null,null,null,null,0,0,0,0,0,0]
[null,"Non-conforming capital expenditure - recovered by a surcharge"]
[null,"Non-conforming capital expenditure - added to the speculative capital expenditure account"]
[null,"Non-conforming capital expenditure - other"]
[null,"Capital contributions rolled into the capital base"]
[null,"Speculative capital expenditure account rolled into the capital base"]
[null,"Re-use of redundant assets rolled into the capital base"]
[null,"Redundant assets rolled out of the capital base"]
[null,"Disposals"]
[null,"Non-system"]
[null,"Conforming capital expenditure",null,null,null,null,0,0,0,0,0,0]
[null,"Non-conforming capital expenditure - recovered by a surcharge"]
[null,"Non-conforming capital expenditure - added to the speculative capital expenditure account"]
[null,"Non-conforming capital expenditure - other"]
[null,"Capital contributions rolled into the capital base"]
[null,"Speculative capital expenditure account rolled into the capital base"]
[null,"Re-use of redundant assets rolled into the capital base"]
[null,"Redundant assets rolled out of the capital base"]
[null,"Disposals"]
[]
[null,"BUILDINGS"]
[null,"Replacement"]
[null,"Conforming capital expenditure",null,null,null,null,0,0,0,0,0,0]
[null,"Non-conforming capital expenditure - recovered by a surcharge"]
[null,"Non-conforming capital expenditure - added to the speculative capital expenditure account"]
[null,"Non-conforming capital expenditure - other"]
[null,"Capital contributions rolled into the capital base"]
[null,"Speculative capital expenditure account rolled into the capital base"]
[null,"Re-use of redundant assets rolled into the capital base"]
[null,"Redundant assets rolled out of the capital base"]
[null,"Disposals"]
[null,"Expansion"]
[null,"Conforming capital expenditure",null,null,null,null,0,0,0,0,0,0]
[null,"Non-conforming capital expenditure - recovered by a surcharge"]
[null,"Non-conforming capital expenditure - added to the speculative capital expenditure account"]
[null,"Non-conforming capital expenditure - other"]
[null,"Capital contributions rolled into the capital base"]
[null,"Speculative capital expenditure account rolled into the capital base"]
[null,"Re-use of redundant assets rolled into the capital base"]
[null,"Redundant assets rolled out of the capital base"]
[null,"Disposals"]
[null,"Non-system"]
[null,"Conforming capital expenditure",0,0,0,0,5104861.8724316359,654914.31954016467,963259.49436527374,963259.49436527374,963259.49436527374,346958.81702860357]
[null,"Non-conforming capital expenditure - recovered by a surcharge"]
[null,"Non-conforming capital expenditure - added to the speculative capital expenditure account"]
[null,"Non-conforming capital expenditure - other"]
[null,"Capital contributions rolled into the capital base"]
[null,"Speculative capital expenditure account rolled into the capital base"]
[null,"Re-use of redundant assets rolled into the capital base"]
[null,"Redundant assets rolled out of the capital base"]
[null,"Disposals"]
[]
[null,"LAND"]
[null,"Replacement"]
[null,"Conforming capital expenditure",null,null,null,null,0,0,0,0,0,0]
[null,"Non-conforming capital expenditure - recovered by a surcharge"]
[null,"Non-conforming capital expenditure - added to the speculative capital expenditure account"]
[null,"Non-conforming capital expenditure - other"]
[null,"Capital contributions rolled into the capital base"]
[null,"Speculative capital expenditure account rolled into the capital base"]
[null,"Re-use of redundant assets rolled into the capital base"]
[null,"Redundant assets rolled out of the capital base"]
[null,"Disposals"]
[null,"Expansion"]
[null,"Conforming capital expenditure",null,null,null,null,0,8897765.1558073591,8897765.1558073591,8897765.1558073591,0,0]
[null,"Non-conforming capital expenditure - recovered by a surcharge"]
[null,"Non-conforming capital expenditure - added to the speculative capital expenditure account"]
[null,"Non-conforming capital expenditure - other"]
[null,"Capital contributions rolled into the capital base"]
[null,"Speculative capital expenditure account rolled into the capital base"]
[null,"Re-use of redundant assets rolled into the capital base"]
[null,"Redundant assets rolled out of the capital base"]
[null,"Disposals"]
[null,"Non-system"]
[null,"Conforming capital expenditure",null,null,null,null,0,0,0,0,0,0]
[null,"Non-conforming capital expenditure - recovered by a surcharge"]
[null,"Non-conforming capital expenditure - added to the speculative capital expenditure account"]
[null,"Non-conforming capital expenditure - other"]
[null,"Capital contributions rolled into the capital base"]
[null,"Speculative capital expenditure account rolled into the capital base"]
[null,"Re-use of redundant assets rolled into the capital base"]
[null,"Redundant assets rolled out of the capital base"]
[null,"Disposals"]
[]
[null,"OTHER"]
[null,"Replacement"]
[null,"Conforming capital expenditure",243782.38,1115425.1199999999,292407.90000000002,1279577.6456000002,3420000,5831608.8965255553,4107634.2005560631,2367741.2669430352,5917859.3377339412,5374406.62884981]
[null,"Non-conforming capital expenditure - recovered by a surcharge"]
[null,"Non-conforming capital expenditure - added to the speculative capital expenditure account"]
[null,"Non-conforming capital expenditure - other"]
[null,"Capital contributions rolled into the capital base"]
[null,"Speculative capital expenditure account rolled into the capital base"]
[null,"Re-use of redundant assets rolled into the capital base"]
[null,"Redundant assets rolled out of the capital base"]
[null,"Disposals"]
[null,"Expansion"]
[null,"Conforming capital expenditure",null,null,null,null,0,0,0,0,0,0]
[null,"Non-conforming capital expenditure - recovered by a surcharge"]
[null,"Non-conforming capital expenditure - added to the speculative capital expenditure account"]
[null,"Non-conforming capital expenditure - other"]
[null,"Capital contributions rolled into the capital base"]
[null,"Speculative capital expenditure account rolled into the capital base"]
[null,"Re-use of redundant assets rolled into the capital base"]
[null,"Redundant assets rolled out of the capital base"]
[null,"Disposals"]
[null,"Non-system"]
[null,"Conforming capital expenditure",0,0,0,0,3445958.5064613358,3957362.1840133658,2562740.2881580591,2241163.3008859628,2553830.7440397302,1844757.428971346]
[null,"Non-conforming capital expenditure - recovered by a surcharge"]
[null,"Non-conforming capital expenditure - added to the speculative capital expenditure account"]
[null,"Non-conforming capital expenditure - other"]
[null,"Capital contributions rolled into the capital base"]
[null,"Speculative capital expenditure account rolled into the capital base"]
[null,"Re-use of redundant assets rolled into the capital base"]
[null,"Redundant assets rolled out of the capital base"]
[null,"Disposals"]
[null,null,0,0,0,0,0,0,0,0,0,0]
[null,null,0,0,0,0]
[null,null,0,0,0,0]
[null,"7.2 - CAPITAL EXPENDITURE - AS COMMISSIONED (by driver)"]
[null,null,"EXPENDITURE\nActual ($0's)",null,null,{"$f":"CONCATENATE(\"EXPENDITURE\nForecast ($0's real, \",dms_DollarReal,\")\")","v":"EXPENDITURE\nForecast ($0's real, December 2017)"}]
[null,null,"1 July to 31 December 2013",{"$f":"CRCP_y2","v":2014},{"$f":"CRCP_y3","v":2015},{"$f":"CRCP_y4","v":2016},{"$f":"CRCP_y5","v":2017},{"$f":"FRCP_y1","v":"2018"},{"$f":"FRCP_y2","v":2019},{"$f":"FRCP_y3","v":2020},{"$f":"FRCP_y4","v":2021},{"$f":"FRCP_y5","v":2022}]
[null,"PIPELINE"]
[null,"Replacement"]
[null,"Conforming capital expenditure",null,null,null,null,0,2316559.0913586393,31319319.176462635,3746372.4073687801,3702828.9850931312,3504293.0328489984]
[null,"Non-conforming capital expenditure - recovered by a surcharge"]
[null,"Non-conforming capital expenditure - added to the speculative capital expenditure account"]
[null,"Non-conforming capital expenditure - other"]
[null,"Capital contributions rolled into the capital base"]
[null,"Speculative capital expenditure account rolled into the capital base"]
[null,"Re-use of redundant assets rolled into the capital base"]
[null,"Redundant assets rolled out of the capital base"]
[null,"Disposals"]
[null,"Expansion"]
[null,"Conforming capital expenditure",null,null,null,null,0,26316353.535794284,0,0,7627356.4079320086,0]
[null,"Non-conforming capital expenditure - recovered by a surcharge"]
[null,"Non-conforming capital expenditure - added to the speculative capital expenditure account"]
[null,"Non-conforming capital expenditure - other"]
[null,"Capital contributions rolled into the capital base"]
[null,"Speculative capital expenditure account rolled into the capital base"]
[null,"Re-use of redundant assets rolled into the capital base"]
[null,"Redundant assets rolled out of the capital base"]
[null,"Disposals"]
[null,"Non-system"]
[null,"Conforming capital expenditure",null,null,null,null,0,0,0,0,0,0]
[null,"Non-conforming capital expenditure - recovered by a surcharge"]
[null,"Non-conforming capital expenditure - added to the speculative capital expenditure account"]
[null,"Non-conforming capital expenditure - other"]
[null,"Capital contributions rolled into the capital base"]
[null,"Speculative capital expenditure account rolled into the capital base"]
[null,"Re-use of redundant assets rolled into the capital base"]
[null,"Redundant assets rolled out of the capital base"]
[null,"Disposals"]
[]
[null,"COMPRESSORS"]
[null,"Replacement"]
[null,"Conforming capital expenditure",null,null,null,null,0,4990251.9753614711,1048266.6684985833,6138080.4473161455,4552929.2304322934,9547342.2936543878]
[null,"Non-conforming capital expenditure - recovered by a surcharge"]
[null,"Non-conforming capital expenditure - added to the speculative capital expenditure account"]
[null,"Non-conforming capital expenditure - other"]
[null,"Capital contributions rolled into the capital base"]
[null,"Speculative capital expenditure account rolled into the capital base"]
[null,"Re-use of redundant assets rolled into the capital base"]
[null,"Redundant assets rolled out of the capital base"]
[null,"Disposals"]
[null,"Expansion"]
[null,"Conforming capital expenditure",null,null,null,null,0,3466890.8878640216,0,0,0,0]
[null,"Non-conforming capital expenditure - recovered by a surcharge"]
[null,"Non-conforming capital expenditure - added to the speculative capital expenditure account"]
[null,"Non-conforming capital expenditure - other"]
[null,"Capital contributions rolled into the capital base"]
[null,"Speculative capital expenditure account rolled into the capital base"]
[null,"Re-use of redundant assets rolled into the capital base"]
[null,"Redundant assets rolled out of the capital base"]
[null,"Disposals"]
[null,"Non-system"]
[null,"Conforming capital expenditure",null,null,null,null,0,0,0,0,0,84093.453212464548]
[null,"Non-conforming capital expenditure - recovered by a surcharge"]
[null,"Non-conforming capital expenditure - added to the speculative capital expenditure account"]
[null,"Non-conforming capital expenditure - other"]
[null,"Capital contributions rolled into the capital base"]
[null,"Speculative capital expenditure account rolled into the capital base"]
[null,"Re-use of redundant assets rolled into the capital base"]
[null,"Redundant assets rolled out of the capital base"]
[null,"Disposals"]
[]
[null,"CITY GATES & FIELD REGULATORS"]
[null,"Replacement"]
[null,"Conforming capital expenditure",null,null,null,null,0,0,635046.24249291758,351074.6143909347,678111.43405099108,245102.23394900837]
[null,"Non-conforming capital expenditure - recovered by a surcharge"]
[null,"Non-conforming capital expenditure - added to the speculative capital expenditure account"]
[null,"Non-conforming capital expenditure - other"]
[null,"Capital contributions rolled into the capital base"]
[null,"Speculative capital expenditure account rolled into the capital base"]
[null,"Re-use of redundant assets rolled into the capital base"]
[null,"Redundant assets rolled out of the capital base"]
[null,"Disposals"]
[null,"Expansion"]
[null,"Conforming capital expenditure",null,null,null,null,0,0,0,0,0,0]
[null,"Non-conforming capital expenditure - recovered by a surcharge"]
[null,"Non-conforming capital expenditure - added to the speculative capital expenditure account"]
[null,"Non-conforming capital expenditure - other"]
[null,"Capital contributions rolled into the capital base"]
[null,"Speculative capital expenditure account rolled into the capital base"]
[null,"Re-use of redundant assets rolled into the capital base"]
[null,"Redundant assets rolled out of the capital base"]
[null,"Disposals"]
[null,"Non-system"]
[null,"Conforming capital expenditure",null,null,null,null,0,0,0,0,0,0]
[null,"Non-conforming capital expenditure - recovered by a surcharge"]
[null,"Non-conforming capital expenditure - added to the speculative capital expenditure account"]
[null,"Non-conforming capital expenditure - other"]
[null,"Capital contributions rolled into the capital base"]
[null,"Speculative capital expenditure account rolled into the capital base"]
[null,"Re-use of redundant assets rolled into the capital base"]
[null,"Redundant assets rolled out of the capital base"]
[null,"Disposals"]
[]
[null,"ODOURANT PLANTS"]
[null,"Replacement"]
[null,"Conforming capital expenditure",null,null,null,null,0,77495.893484419255,0,0,0,0]
[null,"Non-conforming capital expenditure - recovered by a surcharge"]
[null,"Non-conforming capital expenditure - added to the speculative capital expenditure account"]
[null,"Non-conforming capital expenditure - other"]
[null,"Capital contributions rolled into the capital base"]
[null,"Speculative capital expenditure account rolled into the capital base"]
[null,"Re-use of redundant assets rolled into the capital base"]
[null,"Redundant assets rolled out of the capital base"]
[null,"Disposals"]
[null,"Expansion"]
[null,"Conforming capital expenditure",null,null,null,null,0,0,0,0,0,0]
[null,"Non-conforming capital expenditure - recovered by a surcharge"]
[null,"Non-conforming capital expenditure - added to the speculative capital expenditure account"]
[null,"Non-conforming capital expenditure - other"]
[null,"Capital contributions rolled into the capital base"]
[null,"Speculative capital expenditure account rolled into the capital base"]
[null,"Re-use of redundant assets rolled into the capital base"]
[null,"Redundant assets rolled out of the capital base"]
[null,"Disposals"]
[null,"Non-system"]
[null,"Conforming capital expenditure",null,null,null,null,0,0,0,0,0,0]
[null,"Non-conforming capital expenditure - recovered by a surcharge"]
[null,"Non-conforming capital expenditure - added to the speculative capital expenditure account"]
[null,"Non-conforming capital expenditure - other"]
[null,"Capital contributions rolled into the capital base"]
[null,"Speculative capital expenditure account rolled into the capital base"]
[null,"Re-use of redundant assets rolled into the capital base"]
[null,"Redundant assets rolled out of the capital base"]
[null,"Disposals"]
[]
[null,"GAS QUALITY"]
[null,"Replacement"]
[null,"Conforming capital expenditure",null,null,null,null,0,0,0,0,0,0]
[null,"Non-conforming capital expenditure - recovered by a surcharge"]
[null,"Non-conforming capital expenditure - added to the speculative capital expenditure account"]
[null,"Non-conforming capital expenditure - other"]
[null,"Capital contributions rolled into the capital base"]
[null,"Speculative capital expenditure account rolled into the capital base"]
[null,"Re-use of redundant assets rolled into the capital base"]
[null,"Redundant assets rolled out of the capital base"]
[null,"Disposals"]
[null,"Expansion"]
[null,"Conforming capital expenditure",null,null,null,null,0,0,0,0,0,0]
[null,"Non-conforming capital expenditure - recovered by a surcharge"]
[null,"Non-conforming capital expenditure - added to the speculative capital expenditure account"]
[null,"Non-conforming capital expenditure - other"]
[null,"Capital contributions rolled into the capital base"]
[null,"Speculative capital expenditure account rolled into the capital base"]
[null,"Re-use of redundant assets rolled into the capital base"]
[null,"Redundant assets rolled out of the capital base"]
[null,"Disposals"]
[null,"Non-system"]
[null,"Conforming capital expenditure",null,null,null,null,0,0,0,0,0,0]
[null,"Non-conforming capital expenditure - recovered by a surcharge"]
[null,"Non-conforming capital expenditure - added to the speculative capital expenditure account"]
[null,"Non-conforming capital expenditure - other"]
[null,"Capital contributions rolled into the capital base"]
[null,"Speculative capital expenditure account rolled into the capital base"]
[null,"Re-use of redundant assets rolled into the capital base"]
[null,"Redundant assets rolled out of the capital base"]
[null,"Disposals"]
[]
[null,"BUILDINGS"]
[null,"Replacement"]
[null,"Conforming capital expenditure",null,null,null,null,0,0,0,0,0,0]
[null,"Non-conforming capital expenditure - recovered by a surcharge"]
[null,"Non-conforming capital expenditure - added to the speculative capital expenditure account"]
[null,"Non-conforming capital expenditure - other"]
[null,"Capital contributions rolled into the capital base"]
[null,"Speculative capital expenditure account rolled into the capital base"]
[null,"Re-use of redundant assets rolled into the capital base"]
[null,"Redundant assets rolled out of the capital base"]
[null,"Disposals"]
[null,"Expansion"]
[null,"Conforming capital expenditure",null,null,null,null,0,0,0,0,0,0]
[null,"Non-conforming capital expenditure - recovered by a surcharge",null,null,null,null,"`"]
[null,"Non-conforming capital expenditure - added to the speculative capital expenditure account"]
[null,"Non-conforming capital expenditure - other"]
[null,"Capital contributions rolled into the capital base"]
[null,"Speculative capital expenditure account rolled into the capital base"]
[null,"Re-use of redundant assets rolled into the capital base"]
[null,"Redundant assets rolled out of the capital base"]
[null,"Disposals"]
[null,"Non-system"]
[null,"Conforming capital expenditure",null,null,null,null,0,307955.50251156109,0,0,1848902.03201001,1734794.0851430178]
[null,"Non-conforming capital expenditure - recovered by a surcharge"]
[null,"Non-conforming capital expenditure - added to the speculative capital expenditure account"]
[null,"Non-conforming capital expenditure - other"]
[null,"Capital contributions rolled into the capital base"]
[null,"Speculative capital expenditure account rolled into the capital base"]
[null,"Re-use of redundant assets rolled into the capital base"]
[null,"Redundant assets rolled out of the capital base"]
[null,"Disposals"]
[]
[null,"LAND "]
[null,"Replacement"]
[null,"Conforming capital expenditure",null,null,null,null,0,0,0,0,0,0]
[null,"Non-conforming capital expenditure - recovered by a surcharge"]
[null,"Non-conforming capital expenditure - added to the speculative capital expenditure account"]
[null,"Non-conforming capital expenditure - other"]
[null,"Capital contributions rolled into the capital base"]
[null,"Speculative capital expenditure account rolled into the capital base"]
[null,"Re-use of redundant assets rolled into the capital base"]
[null,"Redundant assets rolled out of the capital base"]
[null,"Disposals"]
[null,"Expansion"]
[null,"Conforming capital expenditure",null,null,null,null,0,8897765.1558073591,8897765.1558073591,8897765.1558073591,0,0]
[null,"Non-conforming capital expenditure - recovered by a surcharge"]
[null,"Non-conforming capital expenditure - added to the speculative capital expenditure account"]
[null,"Non-conforming capital expenditure - other"]
[null,"Capital contributions rolled into the capital base"]
[null,"Speculative capital expenditure account rolled into the capital base"]
[null,"Re-use of redundant assets rolled into the capital base"]
[null,"Redundant assets rolled out of the capital base"]
[null,"Disposals"]
[null,"Non-system"]
[null,"Conforming capital expenditure",null,null,null,null,0,0,0,0,0,0]
[null,"Non-conforming capital expenditure - recovered by a surcharge"]
[null,"Non-conforming capital expenditure - added to the speculative capital expenditure account"]
[null,"Non-conforming capital expenditure - other"]
[null,"Capital contributions rolled into the capital base"]
[null,"Speculative capital expenditure account rolled into the capital base"]
[null,"Re-use of redundant assets rolled into the capital base"]
[null,"Redundant assets rolled out of the capital base"]
[null,"Disposals"]
[]
[null,"OTHER"]
[null,"Replacement"]
[null,"Conforming capital expenditure",null,null,null,null,0,4715880.3426794019,5793513.4517393289,1773841.6475223158,5941608.25981755,5374406.62884981]
[null,"Non-conforming capital expenditure - recovered by a surcharge"]
[null,"Non-conforming capital expenditure - added to the speculative capital expenditure account"]
[null,"Non-conforming capital expenditure - other"]
[null,"Capital contributions rolled into the capital base"]
[null,"Speculative capital expenditure account rolled into the capital base"]
[null,"Re-use of redundant assets rolled into the capital base"]
[null,"Redundant assets rolled out of the capital base"]
[null,"Disposals"]
[null,"Expansion"]
[null,"Conforming capital expenditure",null,null,null,null,0,0,0,0,0,0]
[null,"Non-conforming capital expenditure - recovered by a surcharge"]
[null,"Non-conforming capital expenditure - added to the speculative capital expenditure account"]
[null,"Non-conforming capital expenditure - other"]
[null,"Capital contributions rolled into the capital base"]
[null,"Speculative capital expenditure account rolled into the capital base"]
[null,"Re-use of redundant assets rolled into the capital base"]
[null,"Redundant assets rolled out of the capital base"]
[null,"Disposals"]
[null,"Non-system"]
[null,"Conforming capital expenditure",null,null,null,null,0,4676335.5304689659,2340786.6520859515,2188549.1991104498,2109425.1354317507,1844757.428971346]
[null,"Non-conforming capital expenditure - recovered by a surcharge"]
[null,"Non-conforming capital expenditure - added to the speculative capital expenditure account"]
[null,"Non-conforming capital expenditure - other"]
[null,"Capital contributions rolled into the capital base"]
[null,"Speculative capital expenditure account rolled into the capital base"]
[null,"Re-use of redundant assets rolled into the capital base"]
[null,"Redundant assets rolled out of the capital base"]
[null,"Disposals"]
[]
[null,null,null,null,null,null,null,0,0,0,0,0]
[null,"Note: Regarding 7.2 - CAPITAL EXPENDITURE - AS COMMISSIONED (by driver)"]
[]
[null,"As per S5.2.2 of the submission :"]
[null,"APA VTS has recorded all capital expenditure on an “as Incurred” basis.  The distinction between capital expenditure “as Incurred” vs “as Commissioned” is that the Service Provider is allowed to earn a return on capital invested “as Incurred”, but does not record depreciation on the investment until a depreciable asset has been created (that is, it has been Commissioned)."]
[]
[null,"Since APA VTS has applied the forecast depreciation from the earlier PTRM, the distinction between capex “as Incurred” and “as Commissioned” is not required to drive the calculation of depreciation in the Roll Forward Model."]

{"sheet":"7.5 Benefit sharing allowance","index":9,"n_rows":63,"n_cols":24,"rows_kept":63,"cut":false,"hidden":false,"merged":[[31,3,31,9],[31,11,31,17],[41,13,41,22],[42,11,42,12],[48,13,48,22],[43,11,43,12],[44,11,44,12],[45,11,45,12],[46,11,46,12],[7,2,7,12],[11,8,11,9],[11,17,11,18],[11,3,11,7],[22,11,22,17],[22,3,22,9]]}
[null,null,{"$f":"IF(dms_DataQuality=\"backcast\",INDEX(dms_Worksheet_List,MATCH(dms_Model,dms_Model_List))&\" BACKCAST\",INDEX(dms_Worksheet_List,MATCH(dms_Model,dms_Model_List)))","v":"REGULATORY REPORTING STATEMENT"}]
[null,null,{"$f":"INDEX(dms_TradingNameFull_List,MATCH(dms_TradingName,dms_TradingName_List))","v":"APA VTS Australia (Operations) Pty Ltd"}]
[null,null,{"$f":"IF(SUM(dms_SingleYear_Model)>0,CRY,CONCATENATE(FRCP_y1,\" to \",dms_MultiYear_FinalYear_Result))","v":"2018 to 2022"}]
[null,null,"7.5 BENEFIT SHARING ALLOWANCE"]
[]
[]
[null,null,"Instructions"]
[null,null,"APA GasNet is required to populate all input cells (yellow) in the tables presented below.\n\nEfficiency gains are calculated using the formulae below.  Adjusted target and actual amounts are used to calculate the carry-over amounts.\n\nFor the first application of the scheme, the efficiency carry forward amount for the first year of the regulatory period is expressed mathematically as: \n                 E1 = F1 – A1 where A1 is the actual operating cost for year 1 and F1 is the regulatory target operating cost for that year. \n\nFor savings that arose in the second to fifth year of the regulatory period, the efficiency carry forward amount is calculated as:\n                 Et = (Ft – At) – (Ft-1 – At-1), where: Et is the efficiency benefit/loss in year t;\n                 At, At-1 is the actual operating cost for the years t and t-1 respectively; and\n                 Ft, Ft-1 is the forecast operating cost for the years t and t-1 respectively \n\nBecause the revenue determination will  occur prior to the completion of the current period, opex for the final year will be estimated as follows:\n                 A5 = F5 – (F4 – A4)"]
[]
[]
[null,null,"Actual and estimated inflation"]
[null,null,null,"Actual",null,null,null,null,"Estimate",null,null,null,"Actual",null,null,null,null,"Estimate"]
[null,null,null,{"$f":"PRCP_y4","v":2011},{"$f":"PRCP_y5","v":2012},2013,{"$f":"CRCP_y2","v":2014},{"$f":"CRCP_y3","v":2015},{"$f":"CRCP_y4","v":2016},{"$f":"CRCP_y5","v":2017},null,null,{"$f":"PRCP_y4","v":2011},{"$f":"PRCP_y5","v":2012},{"$f":"CRCP_y1","v":2013},{"$f":"CRCP_y2","v":2014},{"$f":"CRCP_y3","v":2015},{"$f":"CRCP_y4","v":2016},{"$f":"CRCP_y5","v":2017}]
["ED_EBS751_00001",null,"ABS CPI index - December (old base)",179.4,null,null,null,null,null,null,null,"Inflation rate (per cent)",null,{"$f":"E15/D15-1","v":2.2044088176352838E-2},2.7450980392156765E-2,1.7175572519083859E-2,1.6885553470919357E-2,1.4999999999999902E-2,2.0000000000000018E-2]
["ED_EBS751_00002",null,"ABS CPI index - December (rebased index in March 2012)",99.8,102,104.8,106.6,108.4,{"$f":"H15*1.015","v":110.026},{"$f":"I15*1.02","v":112.22651999999999},null,{"$f":"CONCATENATE(\"Cumulative index (\",CRCP_y5,\"=1)\")","v":"Cumulative index (2017=1)"},{"$f":"N15/(1+N14)","v":0.88927287418339263},0.90887608383473006,0.93382562339097752,0.94986461310570791,0.96590360282043852,0.98039215686274506,1]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Estimate"]
[null,null,"CPI used in opex forecasting model for 2013-17",null,null,null,null,null,null,null,null,null,null,2.5000000000000001E-2]
[]
[null,null,{"$f":"CONCATENATE(\"7.5.1 - The carryover amounts that arise from applying the Benefit Sharing Allowance during the \", dms_Reg_Year_Span, \" regulatory control period\")","v":"7.5.1 - The carryover amounts that arise from applying the Benefit Sharing Allowance during the 2018 to 2022 regulatory control period"}]
[]
[null,null,"7.5.1.1 - Opex allowance applicable to Benefit Sharing Allowance (Benefit Sharing Allowance target)"]
[null,null,null,{"$f":"CONCATENATE(\"$m, real \", (PRCP_y5))","v":"$m, real 2012"},null,null,null,null,null,null,null,"$m, Dec 2011"]
[null,null,null,{"$f":"PRCP_y4","v":2011},{"$f":"PRCP_y5","v":2012},{"$f":"CRCP_y1","v":2013},{"$f":"CRCP_y2","v":2014},{"$f":"CRCP_y3","v":2015},{"$f":"CRCP_y4","v":2016},{"$f":"CRCP_y5","v":2017},null,{"$f":"PRCP_y4","v":2011},{"$f":"PRCP_y5","v":2012},{"$f":"CRCP_y1","v":2013},{"$f":"CRCP_y2","v":2014},{"$f":"CRCP_y3","v":2015},{"$f":"CRCP_y4","v":2016},{"$f":"CRCP_y5","v":2017},{"$f":"FRCP","v":"2018"},2019,2020,2021,2022]
["ED_EBS751_00003",null,"Total opex allowance",27.500800000000002,27.935199999999998,28.189977282137562,28.683893522134614,29.533568950804479,30.48877450154615,30.460313470201807,null,{"$f":"+D25/(1+$N$18)","v":26.830048780487807},27.253853658536585,27.502416860622013,27.984286363058164,28.81323800078486,29.745145855166978,29.717378995318839]
[]
["ED_EBS751_00008",null,"Approved cost pass through events (clause 8.2(f)(ii))",null,null,null,null,null,null,null,null,{"$f":"+D27/(1+$N$18)","v":0},0,0,0,0,0,0]
[null,null,"Costs associated with extensions and expansions (clause 8.2(f)(iii)) ",0,0,1.9820169999999999,2.1576029999999999,2.1287929999999999,2.083526,2.2041949999999999,null,0,0,1.9336751219512196,2.1049785365853659,2.0768712195121952,2.0327082926829272,2.1504341463414636]
["ED_EBS751_00011",null,"Forecast opex for Benefit Sharing Allowance purposes",{"$f":"D25+SUM(D27:D28)","v":27.500800000000002},{"$f":"E25+SUM(E27:E28)","v":27.935199999999998},30.171994282137561,30.841496522134612,31.662361950804481,32.572300501546152,32.66450847020181,null,{"$f":"+SUM(L25:L28)","v":26.830048780487807},{"$f":"+SUM(M25:M28)","v":27.253853658536585},29.436091982573231,30.089264899643531,30.890109220297056,31.777854147849904,31.867813141660303]
[]
[null,null,"7.5.1.2 - Actual and estimated opex applicable to Benefit Sharing Allowance"]
[null,null,null,{"$f":"CONCATENATE(\"$m, real \", (PRCP_y5))","v":"$m, real 2012"},null,null,null,null,null,null,null,"$m, Dec 2011"]
[null,null,null,{"$f":"PRCP_y4","v":2011},{"$f":"PRCP_y5","v":2012},{"$f":"CRCP_y1","v":2013},{"$f":"CRCP_y2","v":2014},{"$f":"CRCP_y3","v":2015},{"$f":"CRCP_y4","v":2016},{"$f":"CRCP_y5","v":2017},null,{"$f":"PRCP_y4","v":2011},{"$f":"PRCP_y5","v":2012},{"$f":"CRCP_y1","v":2013},{"$f":"CRCP_y2","v":2014},{"$f":"CRCP_y3","v":2015},{"$f":"CRCP_y4","v":2016},{"$f":"CRCP_y5","v":2017}]
["ED_EBS751_00012",null,"Total opex (actual)",26.317813364999999,26.708098152000002,23.422400509881413,23.604803643388703,23.511260944841371,22.817803817316687,null,null,{"$f":"(D34/M$15*(1+M$14)^0.5)*$M$15","v":26.317813364999999},{"$f":"(E34/M$15*(1+M$14)^0.5)*$M$15","v":26.708098152000002},{"$f":"(F34/O$15*(1+O$14)^0.5)*M15","v":22.608992874585038},{"$f":"(G34/P$15*(1+P$14)^0.5)*$M$15","v":22.288030311728761},{"$f":"(H34/Q$15*(1+Q$14)^0.5)*$M$15","v":21.827963528555898},{"$f":"(I34/R$15*(1+R$14)^0.5)*$M$15","v":20.85172937575004}]
[]
["ED_EBS751_00013",null,"Movements in provisions",null,null,null,null,null,null,null,null,{"$f":"(D36/M$15*(1+M$14)^0.5)*$M$15","v":0},{"$f":"(E36/M$15*(1+M$14)^0.5)*$M$15","v":0},{"$f":"(F36/O$15*(1+O$14)^0.5)*M15","v":0},{"$f":"G36/P$15*(1+P$14)^0.5","v":0},{"$f":"H36/Q$15*(1+Q$14)^0.5","v":0},{"$f":"I36/R$15*(1+R$14)^0.5","v":0}]
["ED_EBS751_00021",null,"Actual opex for Benefit Sharing Allowance purposes",{"$f":"+D34+SUM(D36:D36)","v":26.317813364999999},{"$f":"+E34+SUM(E36:E36)","v":26.708098152000002},23.422400509881413,23.604803643388703,23.511260944841371,22.817803817316687,null,null,{"$f":"L34+SUM(L36:L36)","v":26.317813364999999},{"$f":"M34+SUM(M36:M36)","v":26.708098152000002},22.608992874585038,22.288030311728761,21.827963528555898,20.85172937575004,{"$f":"+Q37+R29-Q29","v":20.941688369560442}]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Incremental gain $m, Dec 2011"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(N29-N37)-(M29-M37)+(L29-L37)","v":6.7935790169394181},{"$f":"(O29-O37)-(N29-N37)","v":0.97413547992657712},{"$f":"(P29-P37)-(O29-O37)","v":1.2609111038263876},{"$f":"(Q29-Q37)-(P29-P37)","v":1.8639790803587069},{"$f":"(R29-R37)-(Q29-Q37)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Carryover",null,"$m, real Dec 2011",null,null,null,null,null,null,null,null,null,"Total "]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"CRCP_y1","v":2013},null,null,{"$f":"$N$40/2","v":3.3967895084697091},{"$f":"$N$40/2","v":3.3967895084697091},3.3967895084697091,3.3967895084697091,3.3967895084697091]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"CRCP_y2","v":2014},null,null,null,{"$f":"$O$40","v":0.97413547992657712},{"$f":"$O$40","v":0.97413547992657712},{"$f":"$O$40","v":0.97413547992657712},{"$f":"$O$40","v":0.97413547992657712},{"$f":"$O$40","v":0.97413547992657712}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"CRCP_y3","v":2015},null,null,null,null,{"$f":"$P$40","v":1.2609111038263876},{"$f":"$P$40","v":1.2609111038263876},{"$f":"$P$40","v":1.2609111038263876},{"$f":"$P$40","v":1.2609111038263876},{"$f":"$P$40","v":1.2609111038263876}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"CRCP_y4","v":2016},null,null,null,null,null,{"$f":"$Q$40","v":1.8639790803587069},{"$f":"$Q$40","v":1.8639790803587069},{"$f":"$Q$40","v":1.8639790803587069},{"$f":"$Q$40","v":1.8639790803587069},{"$f":"$Q$40","v":1.8639790803587069}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"CRCP_y5","v":2017},null,null,null,null,null,null,{"$f":"+$R$40","v":0},{"$f":"+$R$40","v":0},{"$f":"+$R$40","v":0},{"$f":"+$R$40","v":0},{"$f":"+$R$40","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"Total Carryover Amount ($million, 2015-16)",null,null,null,null,null,null,{"$f":"+SUM(S43:S47)","v":7.4958151725813806},{"$f":"+SUM(T43:T47)","v":4.0990256641116716},{"$f":"+SUM(U43:U47)","v":3.1248901841850945},{"$f":"+SUM(V43:V47)","v":1.8639790803587069},{"$f":"+SUM(W43:W47)","v":0},{"$f":"+SUM(S48:W48)","v":16.583710101236854}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"$m, real Dec 2017"]
[null,null,null,null,null,null,null,null,null,null,null,"PTRM inputs ($m, Dec 2017)",null,null,null,null,null,null,{"$f":"S48/$M$15","v":8.4291508154509796},{"$f":"T48/$M$15","v":4.609412682103625},{"$f":"U48/$M$15","v":3.5139834744814848},{"$f":"V48/$M$15","v":2.0960709974093992},{"$f":"W48/$M$15","v":0},{"$f":"+SUM(S50:W50)","v":18.648617969445489}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,"7.5.2 - Proposed forecast opex for the Benefit Sharing Allowance for the forthcoming regulatory control period"]
[null,null,null,{"$f":"CONCATENATE(\"$m, real \", dms_DollarReal)","v":"$m, real December 2017"}]
["ED_EBS752_00001",null,null,{"$f":"FRCP","v":"2018"},2019,2020,2021,2022,"Total"]
[null,null,"Forecast opex ($million, 2017)",25.652349642148263,25.835468725557075,25.896102825628429,26.775931216652044,27.003906623917029,{"$f":"+SUM(D56:H56)","v":131.16375903390283}]
["ED_EBS752_00002",null,"Less excluded costs "]
["ED_EBS752_00003",null,"Approved cost pass through events (clause 8.2(f)(ii))",0,0,0,0,0,{"$f":"+SUM(D58:H58)","v":0}]
["ED_EBS752_00004",null,"Costs associated with extensions and expansions (clause 8.2(f)(iii)) ",0.27610117499999998,0.36570188214285715,0.36570188214285715,0.41157608214285712,0.41157608214285712,1.8306571035714285]
["ED_EBS752_00005",null,"Allowances",2.354585232963355,2.4481036092293071,2.5087377093006671,2.5553398434153345,2.5923578408578676,12.459124235766531]
["ED_EBS752_99999",null,"Debt Raising Costs",6.0304776627551598E-2,6.2173460144602212E-2,6.2298839012220296E-2,6.1376171093415921E-2,5.9991768927877824E-2,0.30614501580566783]
[null,null,"Equity Raising costs",0,0,0,0,0]
[null,null,"Adjusted forecast opex ($million, 2015-16)",{"$f":"+D56-SUM(D58:D61)","v":22.961358457557356},22.959489774040307,22.959364395172685,23.747639120000436,23.939980931988426,116.5678326787592]

{"sheet":"8. Revenue","index":10,"n_rows":12,"n_cols":13,"rows_kept":12,"cut":false,"hidden":false,"merged":[[7,2,7,10],[7,11,7,12]]}
[null,"REGULATORY REPORTING STATEMENT"]
[null,{"$f":"INDEX(dms_TradingNameFull_List,MATCH(dms_TradingName,dms_TradingName_List))","v":"APA VTS Australia (Operations) Pty Ltd"}]
[null,{"$f":"IF(SUM(dms_SingleYear_Model)>0,CRY,CONCATENATE(FRCP_y1,\" to \",dms_MultiYear_FinalYear_Result))","v":"2018 to 2022"}]
[null,"8. REVENUE"]
[]
[]
[null,"8.1 - REVENUE GROUPING BY SERVICE TYPE"]
[null,null,"Actual",null,null,null,null,null,null,null,null,"Forecast"]
[null,null,{"$f":"PRCP_y1","v":2008},{"$f":"PRCP_y2","v":2009},{"$f":"PRCP_y3","v":2010},{"$f":"PRCP_y4","v":2011},{"$f":"PRCP_y5","v":2012},"1 January to 30 June 2013","1 July to 31 December 2013",{"$f":"CRCP_y2","v":2014},{"$f":"CRCP_y3","v":2015},{"$f":"CRCP_y4","v":2016},{"$f":"CRCP_y5","v":2017}]
[null,"Revenue from ancillary reference services"]
[null,"Revenue from haulage reference services",114.2,110.8,115.8,122.1,131.5,64.599999999999994,55.1,95.82,105.39,108.86,103.2]
[null,"Total",{"$f":"SUM(C10:C11)","v":114.2},{"$f":"SUM(D10:D11)","v":110.8},115.8,122.1,131.5,{"$f":"SUM(H10:H11)","v":64.599999999999994},55.1,95.82,105.39,108.86,103.2]

{"sheet":"11 - User No. ","index":11,"n_rows":56,"n_cols":17,"rows_kept":56,"cut":false,"hidden":false,"merged":[[7,1,9,5],[14,5,14,16],[14,2,14,4]]}
[null,"REGULATORY REPORTING STATEMENT"]
[null,"APA GasNet Australia (Operations) Pty Ltd"]
[null,"2018 to 2022"]
[null,"11. User Numbers"]
[]
[]
[null,"Instructions"]
[null,"For each zone enter the number of users for each year into the yellow cells. This may require the insertion of new lines in the table. "]
[]
[]
[]
[null,"Unit used in this sheet","No."]
[]
[null,"Table 11.1 User numbers – by zone"]
[null,null,"Actual ",null,null,"Forecast"]
[null,null,"2013",2014,2015,2016,2017,"2018",2019,2020,2021,2022,2023,2024,2025,2026,2027]
[null,"LaTrobe",12,12,14,14,14,{"$f":"+G17","v":14},{"$f":"+H17","v":14},14,14,14]
[null,"West Gippsland",0,0,0,0,0,{"$f":"+G18","v":0},0,0,0,0]
[null,"Lurgi",10,12,12,12,12,12,12,12,12,12]
[null,"Metro North West",14,13,14,14,14,14,14,14,14,14]
[null,"Calder",9,11,11,12,12,12,12,12,12,12]
[null,"South Hume",10,11,12,13,13,13,13,13,13,13]
[null,"Echuca",10,11,11,11,11,11,11,11,11,11]
[null,"North Hume",10,10,12,13,13,13,13,13,13,13]
[null,"Western",9,9,10,10,10,10,10,10,10,10]
[null,"Murray Valley",9,10,11,11,11,11,11,11,11,11]
[null,"Interconnect",1,1,1,1,1,1,1,1,1,1]
[null,"South West",9,9,10,11,11,11,11,11,11,11]
[null,"Wodonga",11,12,13,13,13,13,13,13,13,13]
[null,"Tyers",10,11,11,11,11,11,11,11,11,11]
[null,"NSW Transfers",6,7,6,6,7,7,7,7,7,7]
[null,"Metro South East",13,12,14,14,15,15,15,15,15,15]
[null,"Warrnambool",9,10,10,10,10,10,10,10,10,10]
[null,"Koroit",9,9,10,10,10,{"$f":"+G34","v":10},10,10,10,10]
[null,"Refill LNG",5,3,4,7,7,7,7,7,7,7]
[null,"Geelong",12,11,13,13,13,13,13,13,13,13]
[null,"Maryvale",1,1,1,1,1,1,1,1,1,1]
[null,"VicHub",6,7,7,4,4,4,4,4,4,4]
[null,"Refill WUGS",7,7,7,7,7,7,7,7,7,7]
[null,"SEAGas",3,2,1,2,2,2,2,2,2,2]
[null,"Otway Gas",0,0,0,0,0,0,0,0,0,0]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Total number of users",23,23,23,21,23,{"$f":"+G56","v":23},{"$f":"+H56","v":23},23,23,23]

{"sheet":"12. Demand","index":12,"n_rows":79,"n_cols":17,"rows_kept":79,"cut":false,"hidden":false,"merged":[[65,2,65,4],[65,5,65,16],[7,1,7,5],[10,2,10,4],[10,5,10,16],[30,2,30,4],[30,5,30,16],[45,2,45,4],[45,5,45,16]]}
[null,"REGULATORY REPORTING STATEMENT"]
[null,"APA VTS Australia (Operations) Pty Ltd"]
[null,"2018 to 2022"]
[null,"12. DEMAND"]
[]
[]
[null,"Instructions"]
[null,"For each inject or withdrawal point, replace the temporary title (e..g, 'withdrawal point A') with the correct title and then enter the required details into the yellow cells. This may require the insertion of new lines in each table. "]
[]
[null,"12.1 Withdrawals  – Peak Volume – by location"]
[null,null,"Actual TJ/D",null,null,"Forecast TJ/day"]
[null,null,"2013",2014,2015,2016,2017,"2018",2019,2020,2021,2022,2023,2024,2025,2026,2027]
[null,"Exports Culcairn"]
[null,"  minimum withdrawals",{"$f":"1331.85/1000","v":1.33185},0,0,{"$f":"3206.28/1000","v":3.20628},0,0,0,0,0,0]
[null,"  maximum withdrawals",{"$f":"83020.51/1000","v":83.020510000000002},{"$f":"85336.44/1000","v":85.336439999999996},{"$f":"118999.15/1000","v":118.99915},{"$f":"128412.82/1000","v":128.41282000000001},{"$f":"AVERAGE($C15:$F15)/AVERAGE($C16:$F16)*G16","v":186.41561412333164},{"$f":"AVERAGE($C15:$F15)/AVERAGE($C16:$F16)*H16","v":186.41561412333164},186.41561412333164,186.41561412333164,186.41561412333164,186.41561412333164]
[null,"  average withdrawals",{"$f":"49325.87/1000","v":49.325870000000002},{"$f":"26956.87/1000","v":26.956869999999999},{"$f":"38853.58/1000","v":38.853580000000001},{"$f":"62068.23/1000","v":62.06823},{"$f":"29000/365","v":79.452054794520549},{"$f":"29000/365","v":79.452054794520549},{"$f":"29000/365","v":79.452054794520549},79.452054794520549,79.452054794520549,79.452054794520549]
[null,"Exports VicHub"]
[null,"  minimum withdrawals",0,0,0,0,0,0,0,0,0,0]
[null,"  maximum withdrawals",{"$f":"35065/1000","v":35.064999999999998},{"$f":"26161.78/1000","v":26.16178},{"$f":"25015.43/1000","v":25.015430000000002},{"$f":"26000.01/1000","v":26.00001},{"$f":"AVERAGE($C19:$F19)/AVERAGE($C20:$F20)*G20","v":28.060554999999997},{"$f":"AVERAGE($C19:$F19)/AVERAGE($C20:$F20)*H20","v":28.060554999999997},28.060554999999997,28.060554999999997,28.060554999999997,28.060554999999997]
[null,"  average withdrawals",{"$f":"8353.26/1000","v":8.3532600000000006},{"$f":"5653.28/1000","v":5.6532799999999996},{"$f":"5238.05/1000","v":5.2380500000000003},{"$f":"5734/1000","v":5.734},{"$f":"AVERAGE($C$20:$F$20)","v":6.244647500000001},{"$f":"AVERAGE($C$20:$F$20)","v":6.244647500000001},6.244647500000001,6.244647500000001,6.244647500000001,6.244647500000001]
[null,"Exports Port Campbell"]
[null,"  minimum withdrawals",0,0,0,0,0,0,0,0,0,0]
[null,"  maximum withdrawals",111.79,120.36,128.84,141.93,{"$f":"AVERAGE($C23:$F23)/AVERAGE($C24:$F24)*G24","v":125.73},{"$f":"AVERAGE($C23:$F23)/AVERAGE($C24:$F24)*H24","v":125.73},125.73,125.73,125.73,125.73]
[null,"  average withdrawals",58.7,42.66,41.195,60.16,{"$f":"AVERAGE($C$24:$F$24)","v":50.678750000000001},{"$f":"AVERAGE($C$24:$F$24)","v":50.678750000000001},50.678750000000001,50.678750000000001,50.678750000000001,50.678750000000001]
[null,"GPG"]
[null,"  minimum withdrawals",{"$f":"0.08/1000","v":8.0000000000000007E-5},0,{"$f":"4.51/1000","v":4.5100000000000001E-3},{"$f":"0.59/1000","v":5.8999999999999992E-4},null,0,0,0,0,0]
[null,"  maximum withdrawals",{"$f":"115931.1/1000","v":115.9311},{"$f":"189696.29/1000","v":189.69629},{"$f":"124800.75/1000","v":124.80074999999999},{"$f":"177219.75/1000","v":177.21975},8.2844341850000003,8.2639999999999993,5.2683,7.2580904139999998,8.6459190929999998,14.009918649999999]
[null,"  average withdrawals",{"$f":"7179.46/1000","v":7.1794599999999997},{"$f":"11031.38/1000","v":11.031379999999999},{"$f":"8647.49/1000","v":8.6474899999999995},{"$f":"12996.21/1000","v":12.99621},{"$f":"15.61*1000/365","v":42.767123287671232},{"$f":"5.27*1000/365","v":14.438356164383562},{"$f":"1.79*1000/365","v":4.904109589041096},{"$f":"1.88*1000/365","v":5.1506849315068495},{"$f":"0.59*1000/365","v":1.6164383561643836},{"$f":"0.8*1000/365","v":2.1917808219178081}]
[]
[null,"12.2 Withdrawals  – Annual Volume "]
[null,null,"Actual TJ",null,null,"Forecast TJ"]
[null,null,"2013",2014,2015,2016,2017,"2018",2019,2020,2021,2022,2023,2024,2025,2026,2027]
[null,"Annual withdrawals (excluding GPG)"]
[null,"Forecast ",{"$f":"C39-C36","v":209332.87299999999},{"$f":"D39-D36","v":207260.19495665099},212666.73710452599,212076.66650449301,211080.30247987318,{"$f":"+H39-(H28*365)","v":209964.36751921542},{"$f":"+I39-(I28*365)","v":207889.79560629287},205562.91082879261,204710.04432392283,202874.48150094697,{"$f":"M40-M37","v":0},0,0,0,0]
[null,"Actual ",{"$f":"C40-C37","v":220694.58815999998},205580.58585,221887.36877999999,{"$f":"F40-F37","v":223140.07931}]
[null,"Forecast GPG",null,null,null,null,15610,5270,1790,1880,590,800]
[null,"Actual GPG"]
[null,"Annual withdrawals (including GPG)"]
[null,"Forecast ",209332.87299999999,207260.19495665099,212666.73710452599,212076.66650449301,226690.30247987318,215234.36751921542,209679.79560629287,207442.91082879261,205300.04432392283,203674.48150094697]
[null,"Actual ",{"$f":"220694588.16/1000","v":220694.58815999998},{"$f":"205580585.85/1000","v":205580.58585},{"$f":"221887368.78/1000","v":221887.36877999999},{"$f":"(198516156.5+12696087.18+11927835.63)/1000","v":223140.07931}]
[null,"Effective Degree Day"]
[null,"Forecast ",1309,1309,1309,1309,1309,1340,1340,1340,1340,1340]
[null,"Actual ",1242.4000000000001,1163.4000000000001,1471.6,1309]
[]
[null,"12.3 Injections – Peak Volume – by source"]
[null,null,"Actual TJ",null,null,"Forecast TJ/day"]
[null,null,"2013",2014,2015,2016,2017,"2018",2019,2020,2021,2022,2023,2024,2025,2026,2027]
[null,"Longford (including VICHub)"]
[null,"  minimum injections",{"$f":"159106.2221/1000","v":159.10622210000002},{"$f":"186869.519/1000","v":186.869519},{"$f":"144543.61/1000","v":144.54360999999997},{"$f":"225967.4757/1000","v":225.96747570000002},{"$f":"AVERAGE($C49:$F49)/AVERAGE($C51:$F51)*G51","v":182.19852419681067},{"$f":"AVERAGE($C49:$F49)/AVERAGE($C51:$F51)*H51","v":172.973331563069},168.5005534885729,166.70297293480948,164.98094630330394,163.67462952342598]
[null,"  maximum injections",{"$f":"817712.4208/1000","v":817.71242080000002},{"$f":"789854.741/1000","v":789.85474099999999},{"$f":"790657.18/1000","v":790.65718000000004},{"$f":"861623.0083/1000","v":861.62300830000004},669.59426323828188,661.44158443993979,649.54445838979905,640.67771687868594,634.21120514020186,631.10141208490268]
[null,"  average injectionls",{"$f":"459860.73/1000","v":459.86072999999999},{"$f":"435827.61/1000","v":435.82760999999999},{"$f":"466334.68/1000","v":466.33467999999999},{"$f":"578586.57/1000","v":578.58656999999994},{"$f":"+G69/365","v":493.48597924588915},{"$f":"+H69/365","v":468.49948036691717},456.3849296164513,451.51617009297081,446.85204889724656,443.31388074706405]
[null,"Pakenham"]
[null,"  minimum injections",{"$f":"1065.384171/1000","v":1.0653841709999998},{"$f":"1202.641607/1000","v":1.2026416070000001},{"$f":"1973.89/1000","v":1.9738900000000001},{"$f":"2215.63/1000","v":2.21563},{"$f":"AVERAGE($C53:$F53)/AVERAGE($C55:$F55)*G55","v":1.7142162374248846},{"$f":"AVERAGE($C53:$F53)/AVERAGE($C55:$F55)*H55","v":1.6274209405044215},1.585338773069207,1.568426222394472,1.552224521387189,1.5399340297646085]
[null,"  maximum injections",{"$f":"66759.21257/1000","v":66.759212570000003},{"$f":"49743.29628/1000","v":49.743296280000003},{"$f":"63747.58/1000","v":63.747579999999999},{"$f":"57753.87/1000","v":57.753869999999999},57.753869999999999,57.753869999999999,57.753869999999999,57.753869999999999,57.753869999999999,57.753869999999999]
[null,"  average injectionls",{"$f":"46543.94/1000","v":46.543939999999999},{"$f":"38003.645/1000","v":38.003644999999999},{"$f":"41067.98/1000","v":41.067980000000006},{"$f":"49239.45/1000","v":49.239449999999998},{"$f":"+G72/365","v":46.416907632206616},{"$f":"+H72/365","v":44.066696969099638},42.927211741881329,42.469260005481104,42.030556391128812,41.69775904506195]
[null,"Port Campbell (Iona and SEAGas facilities)"]
[null,"  minimum injections",{"$f":"25049.92608/1000","v":25.049926080000002},0,{"$f":"37.41/1000","v":3.7409999999999999E-2},{"$f":"1/1000","v":1E-3},0,0,0,0,0,0]
[null,"  maximum injections",{"$f":"349363.1694/1000","v":349.3631694},{"$f":"351604.4/1000","v":351.6044},{"$f":"396315.06/1000","v":396.31506000000002},{"$f":"341943.2/1000","v":341.94319999999999},429,429,429,429,429,429]
[null,"  average injectionls",{"$f":"154302.16/1000","v":154.30216000000001},{"$f":"120793.92/1000","v":120.79392},{"$f":"134533.17/1000","v":134.53317000000001},{"$f":"81120.153/1000","v":81.120153000000002},{"$f":"+G75/365","v":71.538870555421411},{"$f":"+H75/365","v":67.916668539332733},66.160466105174351,65.454659715602745,64.778519001360763,64.265603611776626]
[null,"Culcairn"]
[null,"  minimum injections",0,0,0,0,0,0,0,0,0,0]
[null,"  maximum injections",{"$f":"16267.28738/1000","v":16.267287379999999},{"$f":"84700.3353/1000","v":84.700335300000006},{"$f":"60012.69/1000","v":60.012689999999999},{"$f":"65970.82/1000","v":65.970820000000003},65.970820000000003,65.970820000000003,65.970820000000003,65.970820000000003,65.970820000000003,65.970820000000003]
[null,"  average injectionls",{"$f":"577.74/1000","v":0.57774000000000003},{"$f":"11156.46/1000","v":11.156459999999999},{"$f":"8665.26/1000","v":8.66526},{"$f":"7968.29/1000","v":7.9682899999999997},{"$f":"+G78/365","v":6.9688995915785537},{"$f":"+H78/365","v":6.6160457939919706},6.4449667941263789,6.3762112515544773,6.3103455660782135,6.2603803398839002]
[]
[null,"12.4 Injections  – Annual Volume "]
[null,null,"Actual TJ",null,null,"Forecast TJ"]
[null,null,"2013",2014,2015,2016,2017,"2018",2019,2020,2021,2022,2023,2024,2025,2026,2027]
[null,"Longford (including VICHub)"]
[null,"Forecast ",null,null,null,null,180122.38242474955,171002.31033392478,166580.49931000473,164803.40208393434,163100.99784749499,161809.56647267839]
[null,"Actual",{"$f":"167849165.3/1000","v":167849.16530000002},{"$f":"159077078/1000","v":159077.07800000001},{"$f":"170212157.71/1000","v":170212.15771},{"$f":"(176468903.8+10887424.62+9133270.74)/1000","v":196489.59916000001}]
[null,"Pakenham"]
[null,"Forecast ",null,null,null,null,16942.171285755416,16084.344393721369,15668.432285786685,15501.279902000602,15341.153082762015,15219.682051447613]
[null,"Actual",{"$f":"16988537.18/1000","v":16988.537179999999},{"$f":"13871330.52/1000","v":13871.33052},{"$f":"14989812.68/1000","v":14989.812679999999},{"$f":"(15018031.21+1739508.87+1724118.89)/1000","v":18481.658970000004}]
[null,"Port Campbell (Iona and SEAGas facilities)"]
[null,"Forecast ",null,null,null,null,26111.687752728816,24789.584016856446,24148.570128388637,23890.950796195004,23644.15943549668,23456.945318298469]
[null,"Actual",{"$f":"56320290.9/1000","v":56320.2909},{"$f":"44089780/1000","v":44089.78},{"$f":"49104606.65/1000","v":49104.606650000002},{"$f":"(24741641.3832+939966.46+2802775.89)/1000","v":28484.383733200004}]
[null,"Culcairn"]
[null,"Forecast ",null,null,null,null,2543.648350926172,2414.8567148070692,2352.4128798561283,2327.3171068173842,2303.2761316185479,2285.0388240576235]
[null,"Actual",{"$f":"210875.9967/1000","v":210.8759967},{"$f":"4072108.514/1000","v":4072.108514},{"$f":"3162820.9/1000","v":3162.8208999999997},{"$f":"(2430328.507+128482.37+215971.68)/1000","v":2774.7825570000005}]

{"sheet":"13. Pipeline capacity","index":13,"n_rows":56,"n_cols":17,"rows_kept":56,"cut":false,"hidden":false,"merged":[[50,2,50,4],[50,5,50,16],[6,1,6,5],[10,2,10,4],[10,5,10,16],[22,2,22,4],[22,5,22,16],[34,2,34,4],[34,5,34,16]]}
[null,"REGULATORY REPORTING STATEMENT"]
[null,"APA VTS Australia (Operations) Pty Ltd"]
[null,"2018 to 2022"]
[null,"13. PIPELINE CAPACITY"]
[]
[]
[null,"For each  pipeline, replace the temporary title (e..g, 'Pipeline A') with the correct title and then enter the required details into the yellow cells. This may require the insertion of new lines in each table. "]
[]
[]
[null,"13.1 Pipeline capacity - by pipeline"]
[null,null,"Actual (TJ/day)",null,null,"Forecast (TJ/day)"]
[null,null,"2013",2014,2015,2016,2017,"2018",2019,2020,2021,2022,2023,2024,2025,2026,2027]
[null,"Pipeline capacity "]
[null,"Longford to Melbourne",1030,1030,1030,1030,1030,1030,1030,1030,1030,1030,1030,1030,1030,1030,1030]
[null,"South West Pipeline (from Iona)",353,353,429,429,429,429,429,429,429,429,429,429,429,429,429]
[null,"South West Pipeline (to Iona)",92,92,92,102,102,102,150,150,150,150,150,150,150,150,150]
[null,"Western Transmission System",28,28,28,28,28,28,28,28,28,28,28,28,28,28,28]
[null,"New South Wales Interconnect (to Vic)",120,120,125,125,125,125,125,125,125,125,125,125,125,125,125]
[null,"New South Wales Interconnect (from Vic (summer))",83,83,126,148,201,201,201,201,201,201,201,201,201,201,201]
[null,"New South Wales Interconnect (from Vic (winter))",46,57,57,118,201,201,201,201,201,201,201,201,201,201,201]
[]
[null,"13.2 Average utilisation - by pipeline"]
[null,null,"Actual (%)",null,null,"Forecast (%)"]
[null,null,"2013",2014,2015,2016,2017,"2018",2019,2020,2021,2022,2023,2024,2025,2026,2027]
[null,"Average utilisation"]
[null,"Longford to Melbourne",{"$f":"'12. Demand'!C51/C14","v":0.44646672815533978},{"$f":"'12. Demand'!D51/D14","v":0.42313360194174754},{"$f":"'12. Demand'!E51/E14","v":0.45275211650485436},{"$f":"'12. Demand'!F51/F14","v":0.56173453398058248},{"$f":"'12. Demand'!G51/G14","v":0.47911260120960114},{"$f":"'12. Demand'!H51/H14","v":0.45485386443390019},{"$f":"'12. Demand'!I51/I14","v":0.4430921646761663},{"$f":"'12. Demand'!J51/J14","v":0.43836521368249592},{"$f":"'12. Demand'!K51/K14","v":0.4338369406769384},{"$f":"'12. Demand'!L51/L14","v":0.43040182596802334},"n/a","n/a","n/a","n/a","n/a"]
[null,"South West Pipeline (from Iona)",{"$f":"'12. Demand'!C59/C15","v":0.43711660056657226},{"$f":"'12. Demand'!D59/D15","v":0.34219240793201133},{"$f":"'12. Demand'!E59/E15","v":0.31359713286713292},{"$f":"'12. Demand'!F59/F15","v":0.18909126573426574},{"$f":"'12. Demand'!G59/G15","v":0.16675727402196133},{"$f":"'12. Demand'!H59/H15","v":0.15831391267909728},{"$f":"'12. Demand'!I59/I15","v":0.15422020071136211},{"$f":"'12. Demand'!J59/J15","v":0.15257496437203438},{"$f":"'12. Demand'!K59/K15","v":0.15099887879105073},{"$f":"'12. Demand'!L59/L15","v":0.14980327182232314},"n/a","n/a","n/a","n/a","n/a"]
[null,"South West Pipeline (to Iona)",0.28499999999999998,0.29630434782608694,0.33146739130434782,0.20843137254901958,{"$f":"G56/G16","v":0.2579289215686274},{"$f":"H56/H16","v":0.2579289215686274},0.17539166666666664,0.17539166666666664,0.17539166666666664,0.17539166666666664,"n/a","n/a","n/a","n/a","n/a"]
[null,"Western Transmission System",0.42017678571428574,0.44564678571428573,0.45112607142857147,0.43674464285714282,0.41131295525577272,0.35947230490510568,0.35380855203224115,0.34707397094398129,0.34455529931028644,0.34102164376456073,"n/a","n/a","n/a","n/a","n/a"]
[null,"New South Wales Interconnect (to Vic)",{"$f":"'12. Demand'!C63/'13. Pipeline capacity'!C18","v":4.8145000000000002E-3},{"$f":"'12. Demand'!D63/'13. Pipeline capacity'!D18","v":9.2970499999999998E-2},{"$f":"'12. Demand'!E63/'13. Pipeline capacity'!E18","v":6.9322079999999994E-2},{"$f":"'12. Demand'!F63/'13. Pipeline capacity'!F18","v":6.3746319999999995E-2},{"$f":"'12. Demand'!G63/'13. Pipeline capacity'!G18","v":5.5751196732628426E-2},{"$f":"'12. Demand'!H63/'13. Pipeline capacity'!H18","v":5.2928366351935763E-2},{"$f":"'12. Demand'!I63/'13. Pipeline capacity'!I18","v":5.1559734353011033E-2},{"$f":"'12. Demand'!J63/'13. Pipeline capacity'!J18","v":5.100969001243582E-2},{"$f":"'12. Demand'!K63/'13. Pipeline capacity'!K18","v":5.0482764528625705E-2},{"$f":"'12. Demand'!L63/'13. Pipeline capacity'!L18","v":5.00830427190712E-2},"n/a","n/a","n/a","n/a","n/a"]
[null,"New South Wales Interconnect (from Vic (summer))",0.61024614457831328,0.38324036144578311,0.26591936507936509,0.48882817567567577,0.39528385469910721,0.39528385469910721,0.39528385469910721,0.39528385469910721,0.39528385469910721,0.39528385469910721,"n/a","n/a","n/a","n/a","n/a"]
[null,"New South Wales Interconnect (from Vic (winter))",1.0439760869565218,0.38919122807017548,0.77393210526315781,0.46872127118644069,0,0,0,0,0,0,"n/a","n/a","n/a","n/a","n/a"]
[]
[null,"13.3 Peak utilisation - by pipeline"]
[null,null,"Actual (%)",null,null,"Forecast (%)"]
[null,null,"2013",2014,2015,2016,2017,"2018",2019,2020,2021,2022,2023,2024,2025,2026,2027]
[null,"Peak utilisation"]
[null,"Longford to Melbourne",{"$f":"'12. Demand'!C50/C14","v":0.79389555417475732},{"$f":"'12. Demand'!D50/D14","v":0.76684926310679613},{"$f":"'12. Demand'!E50/E14","v":0.76762833009708742},{"$f":"'12. Demand'!F50/F14","v":0.83652719252427188},{"$f":"'12. Demand'!G50/G14","v":0.65009151770706974},{"$f":"'12. Demand'!H50/H14","v":0.64217629557275713},{"$f":"'12. Demand'!I50/I14","v":0.63062568775708649},{"$f":"'12. Demand'!J50/J14","v":0.6220172008530932},{"$f":"'12. Demand'!K50/K14","v":0.61573903411670083},{"$f":"'12. Demand'!L50/L14","v":0.61271981755815796},"n/a","n/a","n/a","n/a","n/a"]
[null,"South West Pipeline (from Iona)",{"$f":"'12. Demand'!C58/C15","v":0.98969736373937678},{"$f":"'12. Demand'!D58/D15","v":0.99604645892351273},{"$f":"'12. Demand'!E58/E15","v":0.92381132867132876},{"$f":"'12. Demand'!F58/F15","v":0.79707039627039622},{"$f":"'12. Demand'!G58/G15","v":1},{"$f":"'12. Demand'!H58/H15","v":1},{"$f":"'12. Demand'!I58/I15","v":1},{"$f":"'12. Demand'!J58/J15","v":1},{"$f":"'12. Demand'!K58/K15","v":1},{"$f":"'12. Demand'!L58/L15","v":1},"n/a","n/a","n/a","n/a","n/a"]
[null,"South West Pipeline (to Iona)",1.0728260869565218,1.1456521739130436,0.99130434782608701,1.0196078431372548,{"$f":"G55/G16","v":0.97867647058823537},{"$f":"H55/H16","v":0.97867647058823537},0.97867647058823537,0.97867647058823537,0.97867647058823537,0.97867647058823537,"n/a","n/a","n/a","n/a","n/a"]
[null,"Western Transmission System",0.7111035714285715,0.68440714285714299,0.69006642857142864,0.70866428571428564,0.65536377066753659,0.57276368804542799,0.5637393711804719,0.55300885467358563,0.54899573979879357,0.54336540456841653,"n/a","n/a","n/a","n/a","n/a"]
[null,"New South Wales Interconnect (to Vic)",{"$f":"'12. Demand'!C62/'13. Pipeline capacity'!C18","v":0.13556072816666667},{"$f":"'12. Demand'!D62/'13. Pipeline capacity'!D18","v":0.70583612750000002},{"$f":"'12. Demand'!E62/'13. Pipeline capacity'!E18","v":0.48010152},{"$f":"'12. Demand'!F62/'13. Pipeline capacity'!F18","v":0.52776656},{"$f":"'12. Demand'!G62/'13. Pipeline capacity'!G18","v":0.52776656},{"$f":"'12. Demand'!H62/'13. Pipeline capacity'!H18","v":0.52776656},{"$f":"'12. Demand'!I62/'13. Pipeline capacity'!I18","v":0.52776656},{"$f":"'12. Demand'!J62/'13. Pipeline capacity'!J18","v":0.52776656},{"$f":"'12. Demand'!K62/'13. Pipeline capacity'!K18","v":0.52776656},{"$f":"'12. Demand'!L62/'13. Pipeline capacity'!L18","v":0.52776656},"n/a","n/a","n/a","n/a","n/a"]
[null,"New South Wales Interconnect (from Vic (summer))",1.000247108433735,1.0281498795180724,0.68177944444444449,0.81687155405405409,0.92744086628523204,0.92744086628523204,0.92744086628523204,0.92744086628523204,0.92744086628523204,0.92744086628523204,"n/a","n/a","n/a","n/a","n/a"]
[null,"New South Wales Interconnect (from Vic (winter))",1.6770195652173912,1.36446,2.0877043859649125,1.0882442372881356,0,0,0,0,0,0,"n/a","n/a","n/a","n/a","n/a"]
[]
[]
[]
[null,"For the purposes of calculating utilisation of SW Pipelne capacity, injections from Poert Campbell are deducted in order to derive the volumes of gas actually travelling westbound on the SW Pipelne."]
[]
[null,"12.1 Withdrawals  – Peak Volume – by location"]
[null,null,"Actual TJ/D",null,null,"Forecast TJ/day"]
[null,null,"2013",2014,2015,2016,2017,"2018",2019,2020,2021,2022,2023,2024,2025,2026,2027]
[null,"Exports Port Campbell"]
[null,"  minimum withdrawals",0,0,0,0]
[null,"  maximum withdrawals",98.7,105.4,91.2,104,{"$f":"AVERAGE(C55:F55)","v":99.825000000000003},{"$f":"+G55","v":99.825000000000003},{"$f":"+H55*I16/H16","v":146.8014705882353},{"$f":"+I55","v":146.8014705882353},146.8014705882353,146.8014705882353]
[null,"  average withdrawals",26.22,27.259999999999998,30.495000000000001,21.259999999999998,{"$f":"AVERAGE(C56:F56)","v":26.308749999999996},{"$f":"+G56","v":26.308749999999996},{"$f":"+H56","v":26.308749999999996},26.308749999999996,26.308749999999996,26.308749999999996]

{"sheet":"14. Bill impacts","index":14,"n_rows":140,"n_cols":34,"rows_kept":140,"cut":false,"hidden":false,"merged":[[42,3,42,9],[42,10,43,10],[6,1,6,7],[13,3,13,4],[18,3,18,4],[23,3,23,4],[33,3,33,9],[33,10,34,10]]}
[null,"REGULATORY REPORTING STATEMENT"]
[null,"APA VTS Australia (Operations) Pty Ltd"]
[null,"2018 to 2022"]
[null,"14. INDICATIVE BILL IMPACTS"]
[]
[]
[null,"This worksheet uses assumptions and calculations determined by the AER. These assumptions and outcomes shown are not part of the APA VTS access arrangement proposal. APA VTS is to insert its access arrangement proposal values for forecast inflation and X factors in table 14.3. If APA VTS proposes alternative: (a) transmission cost proportion of a typical customer's gas bill; (b) annual gas bill amount for a typical residential customer; (c) annual gas bill amount for a typical small business customer – it may insert these in the relevant input cells and source appropriately."]
[]
[]
[null,"14 - INDICATIVE IMPACT OF THE REGULATORY PROPOSAL ON THE AVERAGE RESIDENTIAL AND SMALL BUSINESS CUSTOMER GAS BILLS"]
[]
[null,null,null,"Residential","Small business (<10Tj)"]
[null,"Transmission costs as a proportion of a typical customer's gas bill (per cent)",null,{"$f":"AVERAGE(G140,N140)","v":2.0658534846397479E-2},{"$f":"AVERAGE(W139,AG139)","v":2.8148027012993397E-2}]
[null,"Source(s) of data:",null,"See Analysis below"]
[]
[null,"14.1 - TYPICAL GAS BILL - RESIDENTIAL CUSTOMER"]
[null,"Tariff type",null,"Description of tariff type","Annual bill amount 2017"]
[null,"Residential",null,"See below",{"$f":"AVERAGE(G118,N118)","v":1270.5114399999998}]
[null,"Source(s) of data:",null,"See analysis below"]
[]
[null,"14.2 - TYPICAL GAS BILL - SMALL BUSINESS CUSTOMER"]
[null,"Tariff type",null,"Description of tariff type","Annual bill amount 2017"]
[null,"Small business (<10Tj)",null,"See below",{"$f":"AVERAGE(W117,AG117)","v":7774.9954999999991}]
[null,"Source(s) of data:",null,"See analysis below"]
[]
[null,"14.3 - INDICATIVE ANNUAL AVERAGE TRANSMISSION PRICE IMPACT"]
[null,null,null,2017,"2018",2019,2020,2021,2022,"Average"]
[null,"Forecast inflation","(per cent)",null,0.02,{"$f":"+E28","v":0.02},{"$f":"+F28","v":0.02},{"$f":"+G28","v":0.02},{"$f":"+H28","v":0.02}]
[null,"Forecast X factors ","(per cent)",null,-0.15770000000000001,-0.06,-0.06,-0.06,-0.06]
[null,"Forecast annual price path ($nominal)","(per cent)",null,{"$f":"+(1+E28)*(1-E29)-1","v":0.18085400000000007},{"$f":"+(1+F28)*(1-F29)-1","v":8.1200000000000161E-2},{"$f":"+(1+G28)*(1-G29)-1","v":8.1200000000000161E-2},{"$f":"+(1+H28)*(1-H29)-1","v":8.1200000000000161E-2},{"$f":"+(1+I28)*(1-I29)-1","v":8.1200000000000161E-2},{"$f":"+AVERAGE(E30:I30)","v":0.10113080000000015}]
[]
[]
[null,"14.4 - TRANSMISSION BILL COMPONENT - RESIDENTIAL CUSTOMER"]
[null,null,null,"$0's, Nominal",null,null,null,null,null,null,"Annual impact on customer bill"]
[null,null,null,2017,"2018",2019,2020,2021,2022,{"$f":"\"Total \"&D35&\"-\"&RIGHT(I35,2)","v":"Total 2017-22"}]
[null,"Transmission bill component",null,{"$f":"AVERAGE(G135,N135)*(C77+C96)/1000","v":26.254808219178081},{"$f":"+D36*(1+E30)","v":31.003095304849314},{"$f":"+E36*(1+F30)","v":33.520546643603083},{"$f":"+F36*(1+G30)","v":36.242415031063658},{"$f":"+G36*(1+H30)","v":39.185299131586035},{"$f":"+H36*(1+I30)","v":42.36714542107083}]
[null,"Annual change",null,null,{"$f":"+E36-D36","v":4.7482870856712331},{"$f":"+F36-E36","v":2.5174513387537694},2.7218683874605745,2.9428841005223774,3.1818462894847954,{"$f":"I36/D36-1","v":0.61369091205638049},{"$f":"+AVERAGE(E37:I37)","v":3.22246744037855}]
[null,"Total bill (residential)",null,{"$f":"+E18","v":1270.5114399999998},{"$f":"+D38+E37","v":1275.2597270856711},{"$f":"+E38+F37","v":1277.7771784244248},1280.4990468118854,1283.4419309124078,1286.6237772018926]
[null,"% change in total bill",null,null,{"$f":"+E37/D38","v":3.7373036843109685E-3},{"$f":"+F37/E38","v":1.9740695054385957E-3},2.1301588676179051E-3,2.2982321680358958E-3,2.4791509556048234E-3,{"$f":"I38/D38-1","v":1.2681772626850885E-2},{"$f":"+(I38/D38)^(1/5)-1","v":2.5235853756735427E-3}]
[]
[]
[null,"14.5 - TRANSMISSION BILL COMPONENT - SMALL BUSINESS CUSTOMER"]
[null,null,null,"$0's, Nominal",null,null,null,null,null,null,"Annual impact on customer bill"]
[null,null,null,2017,"2018",2019,2020,2021,2022,{"$f":"\"Total \"&D44&\"-\"&RIGHT(I44,2)","v":"Total 2017-22"}]
[null,"Transmission bill component",null,{"$f":"+E13*E23","v":218.85078335990207},{"$f":"+D45*(1+E30)","v":258.43082293367382},{"$f":"+E45*(1+F30)","v":279.41540575588817},{"$f":"+F45*(1+G30)","v":302.10393670326636},{"$f":"+G45*(1+H30)","v":326.63477636357163},{"$f":"+H45*(1+I30)","v":353.15752020429369}]
[null,"Annual change",null,null,{"$f":"+E45-D45","v":39.580039573771757},{"$f":"+F45-E45","v":20.98458282221435},22.688530947378183,24.530839660305276,26.522743840722057,{"$f":"I45/D45-1","v":0.61369091205638049},{"$f":"+AVERAGE(E46:I46)","v":26.861347368878324}]
[null,"Total bill (small business <10Tj)",null,{"$f":"+E23","v":7774.9954999999991},{"$f":"+D47+E46","v":7814.5755395737706},{"$f":"+E47+F46","v":7835.5601223959848},7858.248653343363,7882.779493003668,7909.3022368443899]
[null,"% change in total bill",null,null,{"$f":"+E46/D47","v":5.0906832774079112E-3},{"$f":"+F46/E47","v":2.6853131965960762E-3},2.8955850753449907E-3,3.1216675295542358E-3,3.3646436341727205E-3,{"$f":"I47/D47-1","v":1.7274188370191457E-2},{"$f":"+(I47/D47)^(1/5)-1","v":3.4312103339424471E-3}]
[]
[]
[null,null,"AGL Residential Saver Tariff Applicable from 1 December 2016:  Postcode 3220",null,null,null,null,null,null,"AGL Residential Saver Tariff Applicable from 1 December 2016: Postcode 3987",null,null,null,null,null,null,"AGL Geelong Business Saver tariffs from 1 September 2016 Postcode 3220",null,null,null,null,null,null,null,null,"AGL Business Saver Tariff Applicable from 1 December 2016: Postcode 3987"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Assumption:  consumer uses 60 GJ/year:  45GJ over the 4 months of winter and 15 GJ over the 8 months of summer",null,null,null,null,null,null,"Assumption:  consumer uses 60 GJ/year:  45GJ over the 4 months of winter and 15 GJ over the 8 months of summer",null,null,null,null,null,null,"Geelong Business",null,null,null,null,null,null,null,null,"Metro South East"]
[]
[null,"Winter consumption costs:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Assumption:  consumer uses 500 GJ/year:  166GJ over the 4 months of winter and 334 GJ over the 8 months of summer (ie no seasonality of usage)",null,null,null,null,null,null,null,null,"Assumption:  consumer uses 500 GJ/year:  166GJ over the 4 months of winter and 334 GJ over the 8 months of summer (ie no seasonality of usage)"]
[null,"Total winter consumtion",45000,"MJ",null,null,null,null,null,45000,"MJ"]
[null,"Number of 2-month periods",2,null,null,null,null,null,null,2,null,null,null,null,null,null,"Winter consumption costs:",null,null,null,null,null,null,null,null,"Winter consumption costs:"]
[null,"Consumption per 2-month period",{"$f":"+C77/C78","v":22500},"MJ",null,null,null,null,null,{"$f":"+J77/J78","v":22500},"MJ",null,null,null,null,null,"Total winter consumtion",null,null,null,166,"GJ",null,null,null,"Total winter consumtion",null,null,null,null,166,"GJ"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Number of 2-month periods",null,null,null,2,null,null,null,null,"Number of 2-month periods",null,null,null,null,2]
[null,null,"Geelong",null,null,null,null,null,null,"Melbourne Metro South East",null,null,null,null,null,null,"Consumption per 2-month period",null,null,null,{"$f":"+U79/U80","v":83},"GJ",null,null,null,"Consumption per 2-month period",null,null,null,null,{"$f":"+AE79/AE80","v":83},"GJ"]
[]
[null,"For the first",{"$f":"6000","v":6000},"MJ @",{"$f":"2.009/100","v":2.009E-2},"/MJ",{"$f":"+C83*E83","v":120.54},null,null,{"$f":"1644","v":1644},"MJ @",{"$f":"2.245/100","v":2.2450000000000001E-2},"/MJ",{"$f":"+J83*L83","v":36.907800000000002},null,null,"For the first",{"$f":"+U81","v":83},"GJ",15,"/GJ",null,{"$f":"+R83*T83","v":1245},null,null,"For the first",null,3,"GJ",19.940000000000001,"/GJ",null,{"$f":"+AB83*AD83","v":59.820000000000007}]
[null,"For the next",{"$f":"6000","v":6000},"MJ @",{"$f":"1.9/100","v":1.9E-2},"/MJ",{"$f":"+C84*E84","v":114},null,null,{"$f":"1314","v":1314},"MJ @",{"$f":"1.922/100","v":1.9220000000000001E-2},"/MJ",{"$f":"+J84*L84","v":25.25508},null,null,"For the next",0,"GJ",11.78,"/GJ",null,{"$f":"+R84*T84","v":0},null,null,"For the next",null,30,"GJ",15.63,"/GJ",null,{"$f":"+AB84*AD84","v":468.90000000000003}]
[null,"For the next",{"$f":"+C79-C83-C84","v":10500},"MJ @",{"$f":"1.263/100","v":1.2629999999999999E-2},"/MJ",{"$f":"+C85*E85","v":132.61499999999998},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"For the next",null,49.2,"GJ",14.35,"/GJ",null,{"$f":"+AB85*AD85","v":706.02}]
[null,"For the remaining",0,"MJ @",{"$f":"1.222/100","v":1.222E-2},"/MJ",{"$f":"+C86*E86","v":0},null,null,{"$f":"+J79-J83-J84","v":19542},"MJ @",{"$f":"1.53/100","v":1.5300000000000001E-2},"/MJ",{"$f":"+J86*L86","v":298.99260000000004},null,null,"For the remaining",0,"GJ",11.56,"/GJ",null,{"$f":"+R86*T86","v":0},null,null,"For the remaining",null,{"$f":"+AE81-AB83-AB84-AB85","v":0.79999999999999716},"GJ",12.06,"/GJ",null,{"$f":"+AB86*AD86","v":9.6479999999999659}]
[]
[null,"Total per 2-month winter period",null,null,null,null,{"$f":"+G83+G84+G85+G86","v":367.15499999999997},null,null,null,null,null,null,{"$f":"+N83+N84+N86","v":361.15548000000001},null,null,"Total per 2-month winter period",null,null,null,null,null,{"$f":"+W83+W84+W85+W86","v":1245},null,null,"Total per 2-month winter period",null,null,null,null,null,null,{"$f":"SUM(AG83:AG87)","v":1244.3879999999999}]
[]
[null,"Number of 2-month periods in winter",null,null,null,null,2,null,null,null,null,null,null,2,null,null,"Number of 2-month periods in winter",null,null,null,null,null,2,null,null,"Number of 2-month periods in winter",null,null,null,null,null,null,2]
[]
[null,"Total Winter gas costs",null,null,null,null,{"$f":"+G88*G90","v":734.31},null,null,null,null,null,null,{"$f":"+N88*N90","v":722.31096000000002},null,null,"Total Winter gas costs",null,null,null,null,null,{"$f":"+W88*W90","v":2490},null,null,"Total Winter gas costs",null,null,null,null,null,null,{"$f":"+AG88*AG90","v":2488.7759999999998}]
[]
[]
[null,"Summer consumption costs:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Summer consumption costs:",null,null,null,null,null,null,null,null,"Summer consumption costs:"]
[null,"Total summer consumtion",15000,"MJ",null,null,null,null,null,15000,"MJ",null,null,null,null,null,"Total summer consumtion",null,null,null,334,"GJ",null,null,null,"Total summer consumtion",null,null,null,null,334,"GJ"]
[null,"Number of 2-month periods",4,null,null,null,null,null,null,4,null,null,null,null,null,null,"Number of 2-month periods",null,null,null,4,null,null,null,null,"Number of 2-month periods",null,null,null,null,4]
[null,"Consumption per 2-month period",{"$f":"+C96/C97","v":3750},"MJ",null,null,null,null,null,{"$f":"+J96/J97","v":3750},"MJ",null,null,null,null,null,"Consumption per 2-month period",null,null,null,{"$f":"+U96/U97","v":83.5},"GJ",null,null,null,"Consumption per 2-month period",null,null,null,null,{"$f":"+AE96/AE97","v":83.5},"GJ"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"For the first",{"$f":"+U98","v":83.5},"GJ",14.92,"/GJ",null,{"$f":"+R100*T100","v":1245.82},null,null,"For the first",null,3,"GJ",{"$f":"+AD83","v":19.940000000000001},"/GJ",null,{"$f":"+AB100*AD100","v":59.820000000000007}]
[null,"For the first",{"$f":"+C98","v":3750},"MJ @",{"$f":"1.837/100","v":1.8370000000000001E-2},"/MJ",{"$f":"+C101*E101","v":68.887500000000003},null,null,{"$f":"1644","v":1644},"MJ @",{"$f":"2.245/100","v":2.2450000000000001E-2},"/MJ",{"$f":"+J101*L101","v":36.907800000000002},null,null,"For the next",0,"GJ",11.72,"/GJ",null,{"$f":"+R101*T101","v":0},null,null,null,null,30,null,{"$f":"+AD84","v":15.63},"/GJ",null,{"$f":"+AB101*AD101","v":468.90000000000003}]
[null,"For the next",0,"MJ @",{"$f":"1.4/100","v":1.3999999999999999E-2},"/MJ",{"$f":"+C102*E102","v":0},null,null,{"$f":"1314","v":1314},"MJ @",{"$f":"1.922/100","v":1.9220000000000001E-2},"/MJ",{"$f":"+J102*L102","v":25.25508},null,null,null,null,null,null,null,null,null,null,null,"For the next",null,49.2,"GJ",14.35,"/GJ",null,{"$f":"+AB102*AD102","v":706.02}]
[null,"For the next",0,"MJ @",{"$f":"1.254/100","v":1.2540000000000001E-2},"/MJ",{"$f":"+C103*E103","v":0},null,null,null,null,null,null,null,null,null,"For the remaining",0,"GJ",11.48,"/GJ",null,{"$f":"+R103*T103","v":0},null,null,"For the remaining",null,{"$f":"+AE98-AB100-AB101-AB102","v":1.2999999999999972},"GJ",12.06,"/GJ",null,{"$f":"+AB103*AD103","v":15.677999999999967}]
[null,"For the remaining",0,"MJ @",{"$f":"1.134/100","v":1.1339999999999999E-2},"/MJ",{"$f":"+C104*E104","v":0},null,null,{"$f":"+J98-J101-J102","v":792},"MJ @",{"$f":"1.53/100","v":1.5300000000000001E-2},"/MJ",{"$f":"+J104*L104","v":12.117600000000001}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total per 2-month winter period",null,null,null,null,null,{"$f":"+W100+W101+W102+W103","v":1245.82},null,null,"Total per 2-month winter period",null,null,null,null,null,null,{"$f":"SUM(AG100:AG104)","v":1250.4179999999999}]
[null,"Total per 2-month period",null,null,null,null,{"$f":"+G101+G102+G103+G104","v":68.887500000000003},null,null,null,null,null,null,{"$f":"+N101+N102+N104","v":74.280479999999997}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Number of 2-month periods in summer",null,null,null,null,null,4,null,null,"Number of 2-month periods in summer",null,null,null,null,null,null,4]
[null,"Number of 2-month periods in summer",null,null,null,null,4,null,null,null,null,null,null,4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Summer gas costs",null,null,null,null,null,{"$f":"+W105*W107","v":4983.28},null,null,"Total Summer gas costs",null,null,null,null,null,null,{"$f":"+AG105*AG107","v":5001.6719999999996}]
[null,"Total Summer gas costs",null,null,null,null,{"$f":"+G106*G108","v":275.55},null,null,null,null,null,null,{"$f":"+N106*N108","v":297.12191999999999}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Annual Gas costs",null,null,null,null,null,{"$f":"+W92+W109","v":7473.28},null,null,"Total Annual Gas costs",null,null,null,null,null,null,{"$f":"+AG92+AG109","v":7490.4479999999994}]
[null,"Total Annual Gas costs",null,null,null,null,{"$f":"+G92+G110","v":1009.8599999999999},null,null,null,null,null,null,{"$f":"+N92+N110","v":1019.4328800000001}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Supply charges:",0.77110000000000001,"per day",365,"days",null,{"$f":"+R115*T115","v":281.45150000000001},null,null,"Supply charges:",null,0.83509999999999995,"per day",365,"days",null,{"$f":"+AB115*AD115","v":304.81149999999997}]
[null,"Supply charges:",0.72450000000000003,"per day",365,"days",{"$f":"+C116*E116","v":264.4425},null,null,0.67749999999999999,"per day",365,"days",{"$f":"+J116*L116","v":247.28749999999999}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total annual gas costs",null,null,null,null,null,{"$f":"+W92+W109+W115","v":7754.7314999999999},null,null,"Total annual gas costs",null,null,null,null,null,null,{"$f":"+AG92+AG109+AG115","v":7795.2594999999992}]
[null,"Total annual gas costs",null,null,null,null,{"$f":"+G92+G110+G116","v":1274.3024999999998},null,null,null,null,null,null,{"$f":"+N92+N110+N116","v":1266.72038}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Average cost per GJ",null,null,null,null,null,{"$f":"+W117/(U79+U96)","v":15.509463},"/GJ",null,"Average cost per GJ",null,null,null,null,null,null,{"$f":"+AG117/(AE79+AE96)","v":15.590518999999999},"/GJ"]
[null,"Average cost per GJ",null,null,null,null,{"$f":"+G118/(C77+C96)*1000","v":21.238374999999998},"/GJ",null,null,null,null,null,{"$f":"+N118/(J77+J96)*1000","v":21.112006333333333},"/GJ"]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VTS costs:",null,null,null,null,null,null,null,null,"VTS costs:"]
[null,"VTS costs:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Injection charge:",{"$f":"+C131","v":2.14},"over",10,"peak days",null,{"$f":"+R130*T130/365","v":5.8630136986301373E-2},"/GJ",null,"Injection charge:",null,{"$f":"+C131","v":2.14},"over",10,"peak days",null,{"$f":"+AB130*AD130/365","v":5.8630136986301373E-2},"/GJ"]
[null,"Injection charge:",2.14,"over",10,"peak days",{"$f":"+C131*E131/365","v":5.8630136986301373E-2},"/GJ",null,{"$f":"+C131","v":2.14},"over",10,"peak days",{"$f":"+J131*L131/365","v":5.8630136986301373E-2},"/GJ",null,"Cross System Charge",{"$f":"+C132","v":0.17430000000000001},null,null,null,null,{"$f":"+R131","v":0.17430000000000001},null,null,"Cross System Charge",null,0,null,null,null,null,{"$f":"+AB131","v":0}]
[null,"Cross System Charge",0.17430000000000001,null,null,null,{"$f":"+C132","v":0.17430000000000001},null,null,0,null,null,null,{"$f":"+J132","v":0},null,null,"Delivery charge - Geelong",null,null,null,null,null,{"$f":"+G133","v":0.25009999999999999},"/GJ",null,"Delivery charge - Metro South East",null,null,null,null,null,null,{"$f":"+N133","v":0.33350000000000002},"/GJ"]
[null,null,"Delivery charge - Geelong",null,null,null,0.25009999999999999,"/GJ",null,"Delivery charge - Metro South East",null,null,null,0.33350000000000002,"/GJ"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total",null,null,null,null,null,{"$f":"+W130+W131+W132","v":0.48303013698630137},"/GJ",null,"Total",null,null,null,null,null,null,{"$f":"+AG130+AG131+AG132","v":0.39213013698630139},"/GJ"]
[null,"Total",null,null,null,null,{"$f":"+G131+G132+G133","v":0.48303013698630137},"/GJ",null,null,null,null,null,{"$f":"+N131+N132+N133","v":0.39213013698630139},"/GJ"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VTS charges as a proportion of total business retail gas costs:",null,null,null,null,null,{"$f":"+W134/W120","v":3.1144220595277952E-2},null,null,"VTS charges as a proportion of total retail gas costs:",null,null,null,null,null,null,{"$f":"+AG134/AG120","v":2.5151833430708846E-2}]
[null,"VTS charges as a proportion of total retail gas costs:",null,null,null,null,{"$f":"+G135/G121","v":2.2743271883385683E-2},null,null,"VTS charges as a proportion of total retail gas costs:",null,null,null,{"$f":"+N135/N121","v":1.8573797809409275E-2}]

{"sheet":"22. WACC","index":15,"n_rows":50,"n_cols":4,"rows_kept":50,"cut":false,"hidden":false,"merged":[[9,1,10,3]]}
[null,"REGULATORY REPORTING STATEMENT"]
[null,"APA VTS Australia (Operations) Pty Ltd"]
[null,"2018 to 2022"]
[null,"22. WACC AND CAPM PARAMETERS"]
[]
[]
[null,"Instructions"]
[null,"This template asks for inputs used to determine the weighted average cost of capital  (WACC) and capital asset pricing model (CAPM)."]
[null,"Where APA VTS intends to apply the Rate of return guideline, in tables 22.1 to 22.4 enter the relevant value or formula used for each item."]
[null,"Where APA VTS does not intend to apply the Rate of return guideline, APA VTS should provide a separate model, which shows the build-up of its forecast rate of return."]
[]
[]
[null,"22 - WACC AND CAPM PARAMETERS"]
[null,"22.1 - Rate of return on equity"]
[null,"Nominated (placeholder) equity averaging period (if nominated)","20 trading days to 31 October 2016"]
[]
[null,"Nominated equity averaging period (if nominated)",null,"CONFIDENTIAL"]
[null,"Nominal risk free rate",2.24E-2]
[null,"Equity term -risk free rate","10  years"]
[null,"Inflation rate",0.02]
[null,"Market risk premium",7.7600000000000002E-2]
[null,"Equity beta",0.8]
[null,"Equity risk premium",6.2600000000000003E-2]
[]
[null,"22.2 - Rate of return on debt - Transition - 'trailing average' approach"]
[null,"Year 1 nominated (placeholder) debt averaging period (if nominated)","20 trading days to 31 October 2016"]
[]
[null,"Year 1 nominated debt averaging period",null,"CONFIDENTIAL"]
[null,"Year 2 nominated debt averaging period",null,"CONFIDENTIAL"]
[null,"Year 3 nominated debt averaging period",null,"CONFIDENTIAL"]
[null,"Year 4 nominated debt averaging period",null,"CONFIDENTIAL"]
[null,"Year 5 nominated debt averaging period",null,"CONFIDENTIAL"]
[null,"Credit rating","BBB+"]
[null,"Debt term","10 years"]
[null,"3rd party debt proxy/ies (e.g. 50% RBA BBB and 50% Bloomberg BBB)","RBA BBB"]
[null,"Effective annual yield to maturity for debt for each year of the regulatory control period (insert formula for calculation for each year)","(1 + Interpolated yield/2)^2 - 1"]
[]
[null,"22.3 - Other WACC parameters"]
[null,"Corporate tax rate",0.3]
[null,"Value of imputation credits (gamma)",0.25]
[null,"Debt to equity ratio",0.6]
[]
[null,"22.4 - Debt and equity raising  expenditure"]
[null,"Equity raising expenditure",0.03,"  See APA VTS post-tax revenue model"]
[null,"Debt raising expenditure",1E-4,"  See APA VTS post-tax revenue model"]
[]
[null,"22.5 - Cost of capital measures "]
[null,"Return on equity (nominal post-tax) ",8.5000000000000006E-2]
[null,"Return on debt (nominal post-tax)",7.4700000000000003E-2,"  Model provided as attachment to APA VTS Submission"]
[null,"Weighted cost of capital (nominal vanilla)",7.8799999999999995E-2]