{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Cover page","Versions","SCS charges 2018-20","Price capped services 2018- 20","Metering Service Charge 2018-20","Public Lighting 2018-20"],"not_rendered":{"charts":0,"images":1,"macros":0,"external_links":27,"defined_names":735,"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":"Cover page","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Versions","index":1,"n_rows":3,"n_cols":3,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
[]
["Version","Date","Description"]
["v.1","2018-03-31","Draft submitted to the AER for approval"]

{"sheet":"SCS charges 2018-20","index":2,"n_rows":118,"n_cols":9,"rows_kept":118,"cut":false,"hidden":false,"merged":[[43,1,44,1],[2,2,5,2],[6,2,9,2],[26,2,30,2],[28,1,29,1],[31,2,35,2],[10,2,13,2],[14,2,17,2],[18,2,21,2],[22,2,25,2],[45,2,47,2],[48,2,50,2],[51,2,53,2],[36,2,38,2],[39,2,41,2],[42,2,44,2],[64,2,65,2],[66,2,68,2],[69,2,71,2],[54,2,57,2],[56,1,57,1],[58,2,61,2],[62,2,63,2],[82,2,85,2],[78,2,79,2],[80,2,81,2],[72,2,74,2],[75,2,77,2],[96,2,102,2],[102,1,104,1],[103,2,109,2],[86,2,89,2],[90,2,92,2],[93,2,95,2]]}
["2018/19 to 2019/20 SCS tariff charges"]
["Tariff Class","Tariff","Year","Tariff / \nCharge Element","Unit","DUOS","JURI","DPPC","NUOS"]
["CAC",null,"2018-19","Supply","$/day","Site-specific prices are confidential"]
[null,3000,null,"Demand","$/kVA/month",9.6509999999999998,0,1.3919999999999999,{"$f":"SUM(F4:H4)","v":11.042999999999999}]
[null,"EG 11kV",null,"Volume Off-Peak","c/kWh",0.39300000000000002,0,0.156,{"$f":"SUM(F5:H5)","v":0.54900000000000004}]
[null,null,null,"Volume Peak","c/kWh",0.39300000000000002,0,0.156,0.54900000000000004]
[null,null,"2019-20","Supply","$/day","Site-specific prices are confidential"]
[null,null,null,"Demand","$/kVA/month",9.5150000000000006,0,1.462,{"$f":"SUM(F8:H8)","v":10.977}]
[null,null,null,"Volume Off-Peak","c/kWh",0.68500000000000005,0,0.13200000000000001,0.81700000000000006]
[null,null,null,"Volume Peak","c/kWh",0.68500000000000005,0,0.13200000000000001,0.81700000000000006]
[null,null,"2018-19","Supply","$/day","Site-specific prices are confidential"]
[null,4000,null,"Demand","$/kVA/month",6.6840000000000002,0,1.3919999999999999,{"$f":"SUM(F12:H12)","v":8.0760000000000005}]
[null,"11kV Bus",null,"Volume Off-Peak","c/kWh",4.3999999999999997E-2,0,6.9000000000000006E-2,0.113]
[null,null,null,"Volume Peak","c/kWh",4.3999999999999997E-2,0,6.9000000000000006E-2,0.113]
[null,null,"2019-20","Supply","$/day","Site-specific prices are confidential"]
[null,null,null,"Demand","$/kVA/month",6.2690000000000001,0,1.462,{"$f":"SUM(F16:H16)","v":7.7309999999999999}]
[null,null,null,"Volume Off-Peak","c/kWh",0,0,7.2999999999999995E-2,7.2999999999999995E-2]
[null,null,null,"Volume Peak","c/kWh",0,0,7.2999999999999995E-2,7.2999999999999995E-2]
[null,null,"2018-19","Supply","$/day","Site-specific prices are confidential"]
[null,4500,null,"Demand","$/kVA/month",10.342000000000001,0,1.3919999999999999,11.734]
[null,"11kV Line",null,"Volume Off-Peak","c/kWh",0.39300000000000002,0,0.156,0.54900000000000004]
[null,null,null,"Volume Peak","c/kWh",0.39300000000000002,0,0.156,0.54900000000000004]
[null,null,"2019-20","Supply","$/day","Site-specific prices are confidential"]
[null,null,null,"Demand","$/kVA/month",9.5150000000000006,0,1.462,10.977]
[null,null,null,"Volume Off-Peak","c/kWh",0.68500000000000005,0,0.13200000000000001,0.81700000000000006]
[null,null,null,"Volume Peak","c/kWh",0.68500000000000005,0,0.13200000000000001,0.81700000000000006]
[null,null,"2018-19","Supply - CAV","$/day/$M-CAV",30.428000000000001,0,0,30.428000000000001]
[null,7400,null,"Supply - NCCAV","$/day/$M-NCCAV",68.441000000000003,0,0,68.441000000000003]
[null,"HV ToU Demand",null,"Peak Demand","$/kVA/month",8.2710000000000008,0,2.8039999999999998,11.075000000000001]
[null,null,null,"Excess Demand","$/kVA/month",1.6539999999999999,0,0.56100000000000005,2.2149999999999999]
[null,null,null,"Volume Flat","c/kWh",0.92600000000000005,0,0.40899999999999997,1.335]
[null,null,"2019-20","Supply - CAV","$/day/$M-CAV",31.341000000000001,0,0,31.341000000000001]
[null,null,null,"Supply - NCCAV","$/day/$M-NCCAV",70.495000000000005,0,0,70.495000000000005]
[null,null,null,"Peak Demand","$/kVA/month",8.4290000000000003,0,2.8580000000000001,11.287000000000001]
[null,null,null,"Excess Demand","$/kVA/month",1.6859999999999999,0,0.57199999999999995,2.258]
[null,null,null,"Volume Flat","c/kWh",0.995,0,0.44,1.4350000000000001]
[null,8000,"2018-19","Supply","$/day",24.78,0,20.87,45.650000000000006]
[null,"HV Demand",null,"Demand","$/kVA/month",9.8689999999999998,0,2.63,12.498999999999999]
[null,null,null,"Volume Flat","c/kWh",0.39300000000000002,0,0.35599999999999998,0.749]
[null,null,"2019-20","Supply","$/day",26.312999999999999,0,21.268999999999998,47.581999999999994]
[null,null,null,"Demand","$/kVA/month",9.08,0,2.762,11.842000000000001]
[null,null,null,"Volume Flat","c/kWh",0.68500000000000005,0,0.23200000000000001,0.91700000000000004]
[null,8100,"2018-19","Supply","$/day",28.353999999999999,0,5.407,33.760999999999996]
[null,"Demand Large",null,"Demand","$/kVA/month",13.898,0,2.7170000000000001,16.614999999999998]
[null,null,null,"Volume Flat","c/kWh",0.21299999999999999,0,0.159,0.372]
[null,null,"2019-20","Supply","$/day",28.895,0,5.51,34.405000000000001]
[null,null,null,"Demand","$/kVA/month",13.034000000000001,0,2.7690000000000001,15.803000000000001]
[null,null,null,"Volume Flat","c/kWh",0.40699999999999997,0,0.17499999999999999,0.58199999999999996]
[null,8300,"2018-19","Supply","$/day",3.2040000000000002,0,1.3149999999999999,4.5190000000000001]
[null,"Demand Small",null,"Demand","$/kVA/month",15.54,0,2.629,18.169]
[null,null,null,"Volume Flat","c/kWh",0,0,0.39200000000000002,0.39200000000000002]
[null,null,"2019-20","Supply","$/day",3.2650000000000001,0,1.34,4.6050000000000004]
[null,null,null,"Demand","$/kVA/month",14.555999999999999,0,2.6789999999999998,17.234999999999999]
[null,null,null,"Volume Flat","c/kWh",2.1000000000000001E-2,0,0.41799999999999998,0.439]
[null,null,"2018-19","Supply","$/day",4.2610000000000001,0,0,4.2610000000000001]
[null,7200,null,"Peak Demand","$/kVA/month",8.4160000000000004,0,2.7170000000000001,11.133000000000001]
[null,"Demand ToU LV",null,"Excess Demand","$/kVA/month",1.6830000000000001,0,0.54300000000000004,2.226]
[null,null,null,"Volume Flat","c/kWh",2.476,0,0.45900000000000002,2.9350000000000001]
[null,null,"2019-20","Supply","$/day",4.34,0,0,4.34]
[null,null,null,"Peak Demand","$/kVA/month",8.577,0,2.7690000000000001,11.346]
[null,null,null,"Excess Demand","$/kVA/month",1.7150000000000001,0,0.55400000000000005,2.2690000000000001]
[null,null,null,"Volume Flat","c/kWh",2.21,0,0.48799999999999999,2.698]
[null,8500,"2018-19","Supply","$/Day",0.46600000000000003,0,0.185,0.65100000000000002]
[null,"Business Flat",null,"Volume Flat","c/kWh",8.0660000000000007,0,1.034,9.1000000000000014]
[null,null,"2019-20","Supply","$/Day",0.47499999999999998,0,0.189,0.66399999999999992]
[null,null,null,"Volume Flat","c/kWh",7.5789999999999997,0,1.1499999999999999,8.7289999999999992]
[null,8800,"2018-19","Supply","$/day",0.46600000000000003,0,0.185,0.65100000000000002]
[null,"Business ToU",null,"Volume Off-Peak","c/kWh",6.1870000000000003,0,0.75800000000000001,6.9450000000000003]
[null,null,null,"Volume Peak","c/kWh",9.7899999999999991,0,1.302,11.091999999999999]
[null,null,"2019-20","Supply","$/day",0.47499999999999998,0,0.189,0.66399999999999992]
[null,null,null,"Volume Off-Peak","c/kWh",5.8380000000000001,0,0.78100000000000003,6.6189999999999998]
[null,null,null,"Volume Peak","c/kWh",9.2609999999999992,0,1.506,10.766999999999999]
[null,7100,"2018-19","Supply","$/day",0.439,0,0,0.439]
[null,"Business Demand",null,"Demand","$/kW/month",6.5519999999999996,0,2.1589999999999998,8.7109999999999985]
[null,null,null,"Volume Flat","c/kWh",4.109,0,0.10199999999999999,4.2110000000000003]
[null,null,"2019-20","Supply","$/day",0.44800000000000001,0,0,0.44800000000000001]
[null,null,null,"Demand","$/kW/month",6.6769999999999996,0,2.2010000000000001,8.8780000000000001]
[null,null,null,"Volume Flat","c/kWh",3.5539999999999998,0,0.2,3.754]
[null,8400,"2018-19","Supply","$/day",0.41399999999999998,0,6.6000000000000003E-2,0.48]
[null,"Residential Flat",null,"Volume Flat","c/kWh",7.0860000000000003,0,1.3420000000000001,{"$f":"SUM(F80:H80)","v":8.4280000000000008}]
[null,null,"2019-20","Supply","$/day",0.42199999999999999,0,6.7000000000000004E-2,0.48899999999999999]
[null,null,null,"Volume Flat","c/kWh",6.97,0,1.4419999999999999,8.411999999999999]
[null,8900,"2018-19","Supply","$/day",0.41399999999999998,0,6.6000000000000003E-2,0.48]
[null,"Residential ToU",null,"Volume Off-Peak","c/kWh",5.5890000000000004,0,0.216,5.8050000000000006]
[null,null,null,"Volume Shoulder","c/kWh",6.0860000000000003,0,1.3420000000000001,7.4280000000000008]
[null,null,null,"Volume Peak","c/kWh",12.706,0,3.7749999999999999,16.480999999999998]
[null,null,"2019-20","Supply","$/day",0.42199999999999999,0,6.7000000000000004E-2,0.48899999999999999]
[null,null,null,"Volume Off-Peak","c/kWh",5.7389999999999999,0,0.29499999999999998,6.0339999999999998]
[null,null,null,"Volume Shoulder","c/kWh",5.97,0,1.4419999999999999,7.4119999999999999]
[null,null,null,"Volume Peak","c/kWh",12.868,0,3.9220000000000002,16.79]
[null,7000,"2018-19","Supply","$/day",0.38,0,0,0.38]
[null,"Residential Demand",null,"Demand","$/kW/month",6.0839999999999996,0,1.6040000000000001,7.6879999999999997]
[null,null,null,"Volume Flat","c/kWh",2.2690000000000001,0,0.47199999999999998,2.7410000000000001]
[null,null,"2019-20","Supply","$/day",0.38900000000000001,0,0,0.38900000000000001]
[null,null,null,"Demand","$/kW/month",6.2,0,1.226,7.4260000000000002]
[null,null,null,"Volume Flat","c/kWh",1.984,0,0.872,2.8559999999999999]
[null,null,"2018-19","Supply Band 1","$/month",22.263999999999999,0,2.0099999999999998,24.274000000000001]
[null,null,null,"Supply Band 2","$/month",29.084,0,2.0099999999999998,31.094000000000001]
[null,null,null,"Supply Band 3","$/month",35.904000000000003,0,2.0099999999999998,37.914000000000001]
[null,null,null,"Supply Band 4","$/month",42.723999999999997,0,2.0099999999999998,44.733999999999995]
[null,null,null,"Supply Band 5","$/month",49.543999999999997,0,2.0099999999999998,51.553999999999995]
[null,6400,null,"Top Up","$/kWh/mth",3.601,0,0,3.601]
[null,"Residential Lifestyle Package",null,"Volume Flat","c/kWh",1.6060000000000001,0,1.3480000000000001,2.9540000000000002]
[null,null,"2019-20","Supply Band 1","$/month",21.443999999999999,0,2.04,23.483999999999998]
[null,null,null,"Supply Band 2","$/month",28.393999999999998,0,2.04,30.433999999999997]
[null,null,null,"Supply Band 3","$/month",35.344000000000001,0,2.04,37.384]
[null,null,null,"Supply Band 4","$/month",42.293999999999997,0,2.04,44.333999999999996]
[null,null,null,"Supply Band 5","$/month",49.244,0,2.04,51.283999999999999]
[null,null,null,"Top Up","$/kWh/mth",3.67,0,0,3.67]
[null,null,null,"Volume Flat","c/kWh",1.56,0,1.3919999999999999,2.952]
[null,9000,"2018-19","Volume Flat","c/kWh",4.6479999999999997,0,1.0669999999999999,{"$f":"SUM(F111:H111)","v":5.7149999999999999}]
[null,"Super Economy","2019-20","Volume Flat","c/kWh",4.9139999999999997,0,1.1619999999999999,6.0759999999999996]
[null,9100,"2018-19","Volume Flat","c/kWh",5.8959999999999999,0,1.0669999999999999,6.9630000000000001]
[null,"Economy","2019-20","Volume Flat","c/kWh",5.2290000000000001,0,1.1619999999999999,6.391]
[null,7300,"2018-19","Volume Flat","c/kWh",2.2690000000000001,0,0.47199999999999998,2.7410000000000001]
[null,"Smart Control","2019-20","Volume Flat","c/kWh",1.984,0,0.872,2.8559999999999999]
[null,9600,"2018-19","Volume Flat","c/kWh",6.141,0,1.1339999999999999,7.2750000000000004]
[null,"Unmetered","2019-20","Volume Flat","c/kWh",5.4960000000000004,0,1.115,6.6110000000000007]

{"sheet":"Price capped services 2018- 20","index":3,"n_rows":214,"n_cols":9,"rows_kept":214,"cut":false,"hidden":false,"merged":[[213,0,213,7],[28,1,36,1],[65,0,80,0],[75,1,80,1],[1,0,1,7],[8,3,8,4],[9,3,9,4],[10,3,10,4],[12,3,12,4],[13,3,13,4],[15,1,24,1],[15,0,25,0],[37,1,39,1],[40,0,42,0],[40,1,42,1],[43,0,54,0],[43,1,54,1],[55,3,55,4],[56,3,56,4],[57,3,57,4],[58,3,58,4],[55,0,58,0],[55,1,58,1],[89,0,94,0],[89,1,92,1],[93,1,94,1],[81,0,84,0],[81,1,84,1],[85,0,88,0],[85,1,88,1],[59,0,64,0],[59,1,64,1],[65,1,70,1],[71,1,74,1],[119,0,120,0],[119,1,120,1],[121,0,126,0],[121,1,126,1],[95,0,118,0],[95,1,100,1],[101,1,106,1],[107,1,112,1],[113,1,118,1],[133,0,137,0],[133,1,135,1],[133,3,133,4],[134,3,134,4],[135,3,135,4],[136,3,136,4],[137,3,137,4],[128,0,132,0],[128,1,130,1],[128,3,128,4],[129,3,129,4],[130,3,130,4],[131,3,131,4],[132,3,132,4],[138,3,138,4],[139,3,139,4],[165,1,170,1],[171,1,176,1],[177,0,179,0],[180,0,182,0],[180,1,182,1],[183,0,184,0],[142,0,176,0],[142,1,143,1],[144,1,145,1],[146,1,151,1],[152,1,162,1],[163,1,164,1],[187,0,190,0],[187,1,190,1],[191,0,203,0],[191,1,203,1],[210,0,212,0],[206,0,209,0],[206,3,206,4],[207,1,209,1],[207,3,207,4],[208,3,208,4],[209,3,209,4]]}
[]
["2018-19 Price Capped Services"]
[null,null,null,null,null,null,"CPI",1.9090909090908999E-2,"Escalation rate"]
[null,null,null,null,null,null,"X",-9.1000000000000004E-3,{"$f":"(1+H3)*(1-H4)-1","v":2.8364636363636508E-2}]
["CATEGORY","SERVICE DESCRIPTION","CHARGE TYPE","PEACE CHARGE CODE","Product Code","PERMUTATIONS","2018-19 ($/service) excluding GST1","2019-20 ($/service) excluding GST1"]
["Connections"]
["Pre-Connection Services"]
["Connection Applications Services"]
["Application assessment, design review and audit real estate development (sub-division) connection services - resubmission","Design Assessment and Preparation of Offer - Resubmission.","Price Cap","Charged Directly to Customer",null,null,173.88440824,{"$f":"G9*(1+$I$4)","v":178.81657624903372}]
["Negotiation services involved in negotiating a connection agreement - simple","Standard jobs for Small Customer Connections and Real Estate Developments (sub-divisions). If service is non-standard, a quoted price may apply.","Price Cap","Charged Directly to Customer",null,null,1623.48932616,{"$f":"G10*(1+$I$4)","v":1669.5390105367737}]
["Protection and Power Quality assessment prior to connection - simple","Solar PV 30-150kW \n","Price Cap","Charged Directly to Customer",null,null,4058.7335837599999,4173.8580859602316]
["Pre-Connection Consultation Services"]
["Site inspection in order to determine nature of connection","Small or large customer connection.","Price Cap","Charged Directly to Customer",null,null,347.77908484,{"$f":"G13*(1+$I$4)","v":357.6437121163649}]
["Provision of site-specific connection information and advice for small or large customer connections.","Protection devices and settings, fault level, network information.","Price Cap","Charged Directly to Customer",null,null,695.55816967999999,715.28742423272979]
["Connection Services - Large Customer Connections"]
["Customer request a temporary connection for short term supply (includes metered and unmetered) - Simple\n\n","Customer requested temporary connection (short term) and recovery of the temporary builders supply.\n\n","Price Cap Sch 8",120,"NCT1MB","BUSINESS HOURS - NO CT",412.77,{"$f":"G16*(1+$I$4)","v":424.47807095181821},"Subject to Schedule 8"]
[null,null,"Price Cap",124,"NCT1MA","AFTER HOURS - NO CT",2155.6368148000006,2216.7806691838705]
[null,null,"Price Cap",128,"NCT1MT","ANYTIME - NO CT",2155.6368148000006,2216.7806691838705]
[null,null,"Price Cap",125,"NCT1MAT","AFTER HOURS - NO CT - TRAFFIC CONTROL",3289.1302701200002,3382.4252541845835]
[null,null,"Price Cap",129,"NCT1MTT","ANYTIME - NO CT - TRAFFIC CONTROL",3289.1302701200002,3382.4252541845835]
[null,null,"Price Cap Sch 8",122,"NCT2MB","BUSINESS HOURS - CT",412.77,424.47807095181821,"Limited based on Schedule 8"]
[null,null,"Price Cap",126,"NCT2MA","AFTER HOURS - CT",3727.4557534400001,3833.1836804478703]
[null,null,"Price Cap",130,"NCT2MT","ANYTIME - CT",3727.4557534400001,3833.1836804478703]
[null,null,"Price Cap",127,"NCT2MAT","AFTER HOURS - CT - TRAFFIC CONTROL",4860.9492087600001,4998.8282654485838]
[null,null,"Price Cap",131,"NCT2MTT","ANYTIME - CT - TRAFFIC CONTROL",4860.9492087600001,4998.8282654485838]
[null,"Temporary Connection of unmetered equipment to an existing LV supply.","Price Cap Sch 8",1400,"TUMS",null,277.31759851999999,285.18361135925676,"Subject to Schedule 8"]
["Post-connection Services"]
["Supply Abolishment - Simple","Request to de-energise an unmetered supply point.","Price Cap",328,"DNUMS",null,425.80835248,{"$f":"G28*(1+$I$4)","v":437.88625155869437}]
[null,"Retailer requests the Service Provider to abolish supply at a specific connection point (simple). To be used for single dwellings and the community / unit one of multi-unit residential complexes.","Price Cap",800,"SA1","BUSINESS HOURS (excl meter removal)",485.35457212,499.12147806561217]
[null,null,"Price Cap",809,"SA1BHTC","BUSINESS HOURS + TRAFFIC CONTROL (excl meter removal)",1618.8480274399999,1664.7660630663258]
[0,null,"Price Cap",810,"SA4","Initial meter removal BUSINESS HOURS (includes travel)",196.69043580000002,202.26948848767222]
[null,null,"Price Cap",801,"SA1AH","AFTER HOURS (excl meter removal)",561.36097284000004,577.28377270334386]
[null,null,"Price Cap",805,"SA1AHT","AFTER HOURS + TRAFFIC CONTROL (excl meter removal)",1694.8544281599998,1742.9283577040574]
[null,null,"Price Cap",811,"SA4AH","Initial meter removal AFTER HOURS (includes travel)",280.68562060000005,288.64716616082069]
[null,null,"Price Cap",806,"SA1AT","ANYTIME (excl meter removal)",561.36097284000004,577.28377270334386]
[null,null,"Price Cap",807,"SA1ATT","ANYTIME + TRAFFIC CONTROL (excl meter removal)",1694.8544281599998,1742.9283577040574]
[0,null,"Price Cap",813,"SA4AT","Initial meter removal ANYTIME (includes travel)",280.68562060000005,288.64716616082069]
[0,"Retailer requests the Service Provider to abolish supply at a specific connection point (simple). To be used for multi-unit residential complexes for all units after the community / unit one - meter removal (charge per meter)","Price Cap",803,"SA3","BUSINESS HOURS (no travel)",128.49825704,132.14306337430068]
[0,0,"Price Cap",804,"SA3AH","AFTER HOURS (no travel)",183.43398303999999,188.63702126566307]
[0,0,"Price Cap",808,"SA3AT","ANYTIME (no travel)",183.43398303999999,188.63702126566307]
["Rearrange connection assets at customer's request - simple (upgrade from overhead to underground where main connection point is in existance)","Recovery of the overhead service and connection of the consumer mains to the pre-existing pillar for a customer requested conversion of existing overhead service to underground service.","Price Cap",1004,"MSOHtoUG","BUSINESS HOURS",259.62521423999999,266.98938903274882]
[0,0,"Price Cap",1019,"MSOHtoUGA","AFTER HOURS",370.50296552000003,381.01214740862378]
[0,0,"Price Cap",1035,"MSOHtoUGT","ANYTIME",370.50296552000003,381.01214740862378]
["Overhead Service Line Replacement at customers request (no material change to load)","Customer requests their existing overhead service to be replaced or relocated, e.g.as a result of point of attachment relocation. No material change to load. ","Price Cap",920,"MSOR1P2","Single Phase - BUSINESS HOURS",659.05414988000007,677.74798118529191]
[0,0,"Price Cap",921,"MSOR1P2A","Single Phase - AFTER HOURS",854.95392196,879.20437906406028]
[0,0,"Price Cap",923,"MSOR1P2T","Single Phase - ANYTIME",854.95392196,879.20437906406028]
[0,0,"Price Cap",559,"MSOR1PHTCB","Single Phase - BUSINESS HOURS + TRAFFIC CONTROL",1792.5476052000001,1843.3925661860055]
[0,0,"Price Cap",922,"MSOR1P2AT","Single Phase - AFTER HOURS + TRAFFIC CONTROL",1988.4473772800002,2044.848964064774]
[0,0,"Price Cap",925,"MSOR1P2TT","Single Phase - ANYTIME + TRAFFIC CONTROL",1988.4473772800002,2044.848964064774]
[0,0,"Price Cap",924,"MSOR3P2","Multi Phase - BUSINESS HOURS",925.49755515999993,951.74895676754795]
[0,0,"Price Cap",927,"MSOR3P2A","Multi Phase - AFTER HOURS",1172.8212741200002,1206.087923079951]
[0,0,"Price Cap",931,"MSOR3P2T","Multi Phase - ANYTIME",1172.8212741200002,1206.087923079951]
[0,0,"Price Cap",560,"MSORMPHTCB","Multi Phase - BUSINESS HOURS + TRAFFIC CONTROL",2058.9910104800001,2117.3935417682619]
[0,0,"Price Cap",929,"MSOR3P2AT","Multi Phase - AFTER HOURS + TRAFFIC CONTROL",2306.3249978000003,2371.743067698962]
[0,0,"Price Cap",933,"MSOR3P2TT","Multi Phase - ANYTIME + TRAFFIC CONTROL",2306.3249978000003,2371.743067698962]
["Auditing services – auditing/re-inspection of connection assets after energisation to network - simple","Auditing / re-inspection of connection assets after energisation - real estate development (sub-division)\nNumber of new, modified or recovered sites (i.e. stations numbers excluding street light pits and conduits).","Price Cap","Charged Directly to Customer",null,"0-6",476.80102823999999,490.32531602383557]
[0,0,"Price Cap","Charged Directly to Customer",null,"7-30",762.87753784000006,784.51628179081797]
[0,0,"Price Cap","Charged Directly to Customer",null,"31-60",912.72371532,938.61279160551908]
[0,0,"Price Cap","Charged Directly to Customer",null,"61+",1017.17347324,1046.0252289271898]
["Temporary disconnections and reconnections (which may involve a line drop) - Low Voltage","Temporary LV service disconnection / reconnection (No dismantling).","Price Cap",902,"MSDNNDB","No Dismantling - BUSINESS HOURS",372.40261212000001,382.96567679365216]
[0,0,"Price Cap",908,"MSDNNDA","No Dismantling - AFTER HOURS",531.42870344000005,546.50248536627453]
[0,0,"Price Cap",914,"MSDNNDT","No Dismantling - ANYTIME",531.42870344000005,546.50248536627453]
[0,"Temporary LV Service Disconnection/Reconnection (Dismantling - drop and re-erect service)","Price Cap",904,"MSDNPDB","Dismantling - BUSINESS HOURS",608.42086671999994,625.67850336056131]
[0,0,"Price Cap",910,"MSDNPDA","Dismantling - AFTER HOURS",868.24117979999994,892.86852514096165]
[0,0,"Price Cap",915,"MSDNPDT","Dismantling - ANYTIME",868.24117979999994,892.86852514096165]
["Customer initiated supply enhancement","Overhead Service Upgrade to Single Phase.","Price Cap",1008,"MSOU1P2","Single Phase Upgrade - BUSINESS HOURS",1087.9532787200001,1118.8126778515189]
[null,null,"Price Cap",1009,"MSOU1P1","Single Phase Upgrade (Fuse Only) - BUSINESS HOURS",188.81460368,194.17026125352734]
[null,0,"Price Cap",1053,"MSU1PHAH","Single Phase Upgrade - AFTER HOURS",1414.9697396400002,1455.1048417704383]
[null,null,"Price Cap",1056,"MSOU1P1AH ","Single Phase Upgrade (Fuse Only) - AFTER HOURS",269.45203476,277.09494374340937]
[null,0,"Price Cap",1055,"MSU1PHTCBH","Single Phase Upgrade - BUSINESS HOURS + TRAFFIC CONTROL",2221.4570024,2284.4678224705299]
[null,0,"Price Cap",1054,"MSU1PHTCAH","Single Phase Upgrade - AFTER HOURS + TRAFFIC CONTROL",2548.4631949600002,2620.7494267711518]
[null,"Overhead Service Upgrade to Multiphase.","Price Cap",1014,"MSOU3P1","Multi Phase Upgrade - BUSINESS HOURS",1226.1140625199998,1260.8923420437206]
[null,0,"Price Cap",1000,"MSUMPHAH","Multi Phase Upgrade-AFTER HOURS",1646.0797181599999,1692.7701707911656]
[null,0,"Price Cap",1001,"MSUMPHTC","Multi Phase Upgrade- BUSINESS HOURS - TRAFFIC CONTROL",2359.6075178400001,2426.5369270444348]
[null,0,"Price Cap",1052,"MSUMPHTCAH","Multi Phase Upgrade  - AFTER HOURS - TRAFFIC CONTROL",2779.5731734799997,2858.4147557918791]
[null,"Underground Service Upgrade.","Price Cap",1060,"MSUU1PHBH","BUSINESS HOURS - SINGLE PHASE",133.74538899999999,137.5390283242981]
[null,null,"Price Cap",1061,"MSUU1PHAH","AFTER HOURS - SINGLE PHASE",190.85800731999998,196.27162529472005]
[null,null,"Price Cap",1042,"MSUU3P","BUSINESS HOURS - TO MULTIPHASE",133.75565735999999,137.54958794259554]
[null,null,"Price Cap",1062,"MSUUMPHAH","AFTER HOURS - TO MULTIPHASE",190.85800731999998,196.27162529472005]
[null,null,"Price Cap",1063,"MSUUCTBH","BUSINESS HOURS - TO MULTIPHASE CT Metering",608.42086671999994,625.67850336056131]
[null,null,"Price Cap",1064,"MSUUCTAH","AFTER HOURS - TO MULTIPHASE CT Metering",868.24117979999994,892.86852514096165]
["Customer consultation or appointment.\n","A visit to the customers premise to advise on electrical supply matters, could be for various reasons.","Price Cap",952,"MSAPWR","Complex (customer requested)",236.02852296000003,242.72338618520666]
[null,null,"Price Cap",1074,"MCMSAPWR","Complex (Metering Coordinator/provider requested)",236.02852296000003,242.72338618520666]
[null,null,"Price Cap",953,"MSAPWRS","Simple (customer requested)",107.51999755999999,110.56976319260848]
[0,0,"Price Cap",1075,"MCMSAPWRS","Simple (Metering Coordinator/provider requested)",107.51999755999999,110.56976319260848]
["Customer requested works to allow customer or contractor to work close","Appointment negotiation and power isolation to allow third party to install contestable metering","Price Cap",1065,"SSWTI1M1V","1 man crew - initial visit",152.42353584,156.7469740073613]
[null,null,"Price Cap",1066,"SSWTI1M2V","1 man crew - subsequent visit",133.74538899999999,137.5390283242981]
[null,null,"Price Cap",1067,"SSWTI2M1V","2 man crew - initial visit",286.16892483999999,294.2860023316594]
[0,0,"Price Cap",1068,"SSWTI2M2V","2 man crew - subsequent visit",267.50104635999998,275.08861626689367]
["De-energisation","Retailer requested de-energisation of the customer's premises where the de-energisation can be performed at the premise ie by a method other than main switch seal (eg pole, pillar or meter isolation link).","Price Cap Sch 8",300,"DNSD1MB","NO CT",0,0,"Subject to Schedule 8"]
[0,0,"Price Cap Sch 8",302,"DNSD2MB","CT",0,0,"Subject to Schedule 8"]
[0,0,"Price Cap Sch 8",304,"DN$1MB","NON PAYMENT - NO CT",0,{"$f":"G92*(1+$I$4)","v":0},"Subject to Schedule 8"]
[0,0,"Price Cap Sch 8",306,"DN$2MB","NON PAYMENT - CT",0,0,"Subject to Schedule 8"]
[0,"Retailer requested de-energisation (MSS).","Price Cap Sch 8",320,"DNS","REASON OTHER THAN NON PAYMENT",0,0,"Subject to Schedule 8"]
[0,0,"Price Cap Sch 8",324,"DNS$1MB","NON PAYMENT",0,0,"Subject to Schedule 8"]
["Re-energisation","Retailer requests a re-energisation of the customer's premises where the customer has not paid their electricity account. No visual required.","Price Cap Sch 8",200,"RN$1MB","BUSINESS HOURS - NO CT",46.813453240000008,48.141299818078707,"Subject to Schedule 8"]
[0,0,"Price Cap Sch 8",204,"RN$1MA","AFTER HOURS - NO CT",71.200808240000001,73.220393274524611,"Subject to Schedule 8"]
[0,0,"Price Cap Sch 8",208,"RN$1MT","ANYTIME - NO CT",71.200808240000001,73.220393274524611,"Subject to Schedule 8"]
[0,0,"Price Cap Sch 8",202,"RN$2MB","BUSINESS HOURS - CT",46.813453240000008,48.141299818078707,"Subject to Schedule 8"]
[0,0,"Price Cap Sch 8",206,"RN$2MA","AFTER HOURS - CT",71.200808240000001,73.220393274524611,"Subject to Schedule 8"]
[0,0,"Price Cap Sch 8",210,"RN$2MT","ANYTIME - CT",71.200808240000001,73.220393274524611,"Subject to Schedule 8"]
[0,"Retailer requests a re-energisation for the customer's premises following a main switch seal (no visual required).","Price Cap Sch 8",406,"RNMSS","BUSINESS HOURS",0,0,"Subject to Schedule 8"]
[0,0,"Price Cap Sch 8",408,"RNMSSA","AFTER HOURS",81.007092040000003,83.304828748590239,"Subject to Schedule 8"]
[0,0,"Price Cap Sch 8",410,"RNMSST","ANYTIME",73.398237280000004,75.480151590179119,"Subject to Schedule 8"]
[0,0,"Price Cap Sch 8",412,"RNS$1MB","BUSINESS HOURS - NON PAYMENT",46.813453240000008,48.141299818078707,"Subject to Schedule 8"]
[0,0,"Price Cap Sch 8",416,"RNS$1MA","AFTER HOURS - NON PAYMENT",81.007092040000003,83.304828748590239,"Subject to Schedule 8"]
[0,0,"Price Cap Sch 8",414,"RNS$1MT","ANYTIME - NON PAYMENT",73.398237280000004,75.480151590179119,"Subject to Schedule 8"]
[0,"Retailer or metering coordinator/provider requests a visual examination upon re-energisation (physical or remote performed by either party) of the customer’s premises.","Price Cap Sch 8",224,"RNV1MB","BUSINESS HOURS - NO CT",0,0,"Subject to Schedule 8"]
[0,0,"Price Cap Sch 8",228,"RNV1MA","AFTER HOURS - NO CT",112.85954476000001,116.06076470728297,"Subject to Schedule 8"]
[0,0,"Price Cap Sch 8",232,"RNV1MT","ANYTIME - NO CT",112.85954476000001,116.06076470728297,"Subject to Schedule 8"]
[0,0,"Price Cap Sch 8",226,"RNV2MB","BUSINESS HOURS - CT",0,0,"Subject to Schedule 8"]
[0,0,"Price Cap Sch 8",230,"RNV2MA","AFTER HOURS - CT",112.85954476000001,116.06076470728297,"Subject to Schedule 8"]
[0,0,"Price Cap Sch 8",234,"RNV2MT","ANYTIME - CT",112.85954476000001,116.06076470728297,"Subject to Schedule 8"]
[0,"Retailer or metering coordinator/provider requests a visual examination upon re-energisation (physical or remote performed by either party) of the customer’s premises where the customer has not paid their electricity account. NMI de-energised > 30 days.","Price Cap Sch 8",212,"RN$V1MB","BUSINESS HOURS - NO CT",46.813453240000008,48.141299818078707,"Subject to Schedule 8"]
[0,0,"Price Cap Sch 8",216,"RN$V1MA","AFTER HOURS - NO CT",112.85954476000001,116.06076470728297,"Subject to Schedule 8"]
[0,0,"Price Cap Sch 8",220,"RN$V1MT","ANYTIME - NO CT",112.85954476000001,116.06076470728297,"Subject to Schedule 8"]
[0,0,"Price Cap Sch 8",214,"RN$V2MB","BUSINESS HOURS - CT",46.813453240000008,48.141299818078707,"Subject to Schedule 8"]
[0,0,"Price Cap Sch 8",218,"RN$V2MA","AFTER HOURS - CT",112.85954476000001,116.06076470728297,"Subject to Schedule 8"]
[0,0,"Price Cap Sch 8",222,"RN$V2MT","ANYTIME - CT",112.85954476000001,116.06076470728297,"Subject to Schedule 8"]
["Readings provided for an active site","Reading provided for an active site.","Price Cap",238,"RNNR","RETAIL REQUESTED FIELDWORK",10.247823280000002,10.538499060856012]
[null,null,"Price Cap",240,"RNRM","RETROSPECTIVE MOVE IN READ",10.247823280000002,10.538499060856012]
["Attending loss of supply (customer at fault)","EGX attending LV customers trouble call and found fault in LV customers installation/Non Energex Metering (includes tripped safety switch, internal fault, customers overload).","Price Cap",1500,"LOS","BUSINESS HOURS - Customer",236.02852296000003,242.72338618520666]
[null,null,"Price Cap",1501,"LOSMC","BUSINESS HOURS - Metering Provider",236.02852296000003,242.72338618520666]
[0,0,"Price Cap",1602,"LOST","AFTER HOURS - Customer",336.81247636000001,346.36603977468735]
[null,null,"Price Cap",1603,"LOSTMC","AFTER HOURS - Metering Provider",336.81247636000001,346.36603977468735]
[null,null,"Price Cap",1600,"LOSA","ANYTIME - Customer",336.81247636000001,346.36603977468735]
[0,0,"Price Cap",1601,"LOSAMC","ANYTIME - Metering Provider",336.81247636000001,346.36603977468735]
["Accreditation / Certification"]
["Accreditation of Design Consultants\n\nApplicant requests to obtain Energex accreditation to provide design services for real estate development (sub-division), Rate 2 public lighting, LCC & distribution works that are reticulated with Energex network (design accreditation)","DESKTOP MANAGEMENT SYSTEM EVALUATION. ","Price Cap","Charged Directly to Customer",null,"ISO9001 ACCREDITATION",10982.586048159999,{"$f":"G129*(1+$I$4)","v":11294.103107748406}]
[0,0,"Price Cap","Charged Directly to Customer",null,"NO ISO9001 ACCREDITATION",12798.95624856,13161.993988384498]
[0,0,"Price Cap","Charged Directly to Customer",null,"DESIGN SERVICE (RATE 2) ACCREDITATION",7504.8054681200001,7717.6765462030544]
[0,"ONSITE MANAGEMENT SYSTEM EVALUATION (irrespective of prior accreditations).","Price Cap","Charged Directly to Customer",null,null,726.5583485200001,747.1669118727342]
[0,"CAPABILITY EVALUATION (irrespective of prior accreditations).","Price Cap","Charged Directly to Customer",null,null,695.55816967999999,715.28742423272979]
["Accreditation of Alternative Service Providers\n\nApplicant requests to obtain Energex Accreditation to provide construction services for real estate development (sub-division) works that are reticulated with Energex network (Construction Accreditation)","DESKTOP MANAGEMENT SYSTEM EVALUATION","Price Cap","Charged Directly to Customer",null,"ISO9001/AS4801/ISO14001 ACCREDITATION",5356.1511381199998,5508.0764174614515]
[0,0,"Price Cap","Charged Directly to Customer",null,"NO ISO9001/AS4801/ISO14001 ACCREDITATION",10047.734017039998,10332.734338711878]
[0,0,"Price Cap","Charged Directly to Customer",null,"ADDITIONAL EGX ACCREDITATIONS WITH OR WITHOUT ISO9001/AS4801/ISO14001",5356.1511381199998,5508.0764174614515]
[0,"ONSITE MANAGEMENT SYSTEM EVALUATION (irrespective of prior accreditations).","Price Cap","Charged Directly to Customer",null,null,1453.0961603199999,1494.3127045088731]
[0,"CAPABILITY EVALUATION (irrespective of prior accreditations).","Price Cap","Charged Directly to Customer",null,null,1422.1062498399999,1462.4437764871664]
["Management System Re-Evaluation","Quality assessment (QA) process: This is conducted on request form existing service providers and design consultants with the intent to improve their management system score.","Price Cap","Charged Directly to Customer",null,null,7265.5218750400009,7471.6057610175567]
["Shared Assets Authority","High Level quality assessment (QA) and capability process: This is conducted to ensure the applicant has adequate Safety and QA documentation to meet Legislative and Energex WCS Requirements. Also involves a capability assessment of the applicant's ability to conduct the work. \n","Price Cap","Charged Directly to Customer",null,null,5449.1414062799995,5603.7043207631668]
["Auxiliary Metering Servies"]
["Meter Installations"]
["Meter Maintenance","Remove Meter - After hours provision of service (incremental costs only).","Price Cap",536,"AARM1AH","AFTER HOURS METER REMOVAL - NO CT",55.726389720000007,{"$f":"G143*(1+$I$4)","v":57.307048500266099}]
[0,0,"Price Cap",537,"AARMCTAH","AFTER HOURS METER REMOVAL - CT",177.69396980000002,182.73419463738801]
[0,"Customer requested meter accuracy testing of type 5-6 meter (physically test meter).","Price Cap Sch 8",704,"MIMT1MB","BUSINESS HOURS - NO CT",18.626805040000001,19.155147591575954,"Subject to Schedule 8"]
[0,0,"Price Cap Sch 8",706,"MIMT2MB","BUSINESS HOURS - CT",18.626805040000001,19.155147591575954,"Subject to Schedule 8"]
[0,"Customer requested meter inspection & investigation (no physical testing of meter) no fault in meter found.","Price Cap",957,"MSINSS","BUSINESS HOURS - NO CT",96.060507799999996,98.78522917265326]
[0,0,"Price Cap",965,"MCINSSA","AFTER HOURS - NO CT",173.31964844000001,178.23579724267393]
[0,0,"Price Cap",967,"MCINSST","ANYTIME - NO CT",173.31964844000001,178.23579724267393]
[0,0,"Price Cap",959,"MSINSC","BUSINESS HOURS - CT",346.63929688000002,356.47159448534785]
[0,0,"Price Cap",969,"MCINSCA","AFTER HOURS - CT",509.567365,524.0210580110014]
[0,0,"Price Cap",971,"MCINSCT","ANYTIME - CT",509.567365,524.0210580110014]
[0,"Customer Requested Meter Reconfiguration.","Price Cap",1200,"MRCL1M","CONTROLLED LOAD - NO CT",97.970422759999991,100.74931817597913]
[0,0,"Price Cap",1202,"MRCL2M","CONTROLLED LOAD - CT",451.06851807999993,463.86291257042353]
[0,0,"Price Cap",1204,"MRCT1M","BUSINESS HOURS - CHANGE TARIFF - NO CT",97.970422759999991,100.74931817597913]
[0,0,"Price Cap",1212,"MRCT1MA","AFTER HOURS - ONE TARIFF TO ANOTHER - NO CT",115.80656408000002,119.09137515865139]
[0,0,"Price Cap",1220,"MRCT1MT","ANYTIME - ONE TARIFF TO ANOTHER - NO CT",115.80656408000002,119.09137515865139]
[0,0,"Price Cap",1206,"MRCT2M","BUSINESS HOURS - CHANGE TARIFF - CT",451.06851807999993,463.86291257042353]
[0,0,"Price Cap",1214,"MRCT2MA","AFTER HOURS - ONE TARIFF TO ANOTHER - CT",643.70295167999996,661.96135183060267]
[0,0,"Price Cap",1222,"MRCT2MT","ANYTIME - MTr RECONFIG CHNG CTRL LOAD  - CT",643.70295167999996,661.96135183060267]
[0,0,"Price Cap",1201,"MRRT1M","Time of Use TRANSFER - NO CT",149.47651651999999,153.7163635559929]
[0,0,"Price Cap",1203,"MRRT2M","Time of Use TRANSFER - CT",498.28243736000002,512.41603750210288]
[0,0,"Price Cap",1205,"MRRV1M","Time of Use REVERSION",97.970422759999991,100.74931817597913]
[0,"Change Timeswitch.","Price Cap",1208,"MRCTS1M","BUSINESS HOURS - NO CT",131.12695719999999,134.84632565844811]
[0,0,"Price Cap",1210,"MRCTS2M","BUSINESS HOURS - CT",414.35913107999994,426.11227715703654]
[null,"Integrity verification as a result of a meter alteration – meter is being relocated or meter wiring altered and requires DNSP to visit site to verify the integrity of the metering equipment (Move Meter).","Price Cap",512,"AAMM1M","BUSINESS HOURS - NO CT",137.01072748000001,140.89698694288751]
[null,0,"Price Cap",513,"AAMM1MAH","AFTER HOURS - NO CT",195.94084551999998,201.49863635195825]
[null,0,"Price Cap",517,"AAMM1MAT","ANYTIME - NO CT",195.94084551999998,201.49863635195825]
[null,0,"Price Cap",514,"AAMM2M","BUSINESS HOURS - CT",849.04961495999999,873.13259854302601]
[null,0,"Price Cap",515,"AAMM2MAH","AFTER HOURS - CT",1211.6254065600001,1245.9927206260177]
[null,0,"Price Cap",519,"AAMM2MAT","ANYTIME - CT",1211.6254065600001,1245.9927206260177]
[0,"Integrity verification as a result of a meter alteration – meter is being relocated or meter wiring altered and requires DNSP to visit site to verify the integrity of the metering equipment (Move Meter).","Price Cap","TBA","TBA","BUSINESS HOURS - NO CT (no travel)",113.34215768,116.55706676726315]
[0,0,"Price Cap","TBA","TBA","AFTER HOURS - NO CT (no travel)",161.73693836000001,166.3245478031493]
[0,0,"Price Cap","TBA","TBA","ANYTIME - NO CT (no travel)",161.73693836000001,166.3245478031493]
[0,0,"Price Cap","TBA","TBA","BUSINESS HOURS - CT (no travel)",712.67552579999995,732.89030793458039]
[0,0,"Price Cap","TBA","TBA","AFTER HOURS - CT (no travel)",1017.01944784,1045.8668346527279]
[0,0,"Price Cap","TBA","TBA","ANYTIME - CT (no travel)",1017.01944784,1045.8668346527279]
["Meter Reading","Check Read","Price Cap Sch 8",400,"SRCR",null,8.1736145600000008,8.4054561647709249,"Subject to Schedule 8"]
[0,"Final Read","Price Cap Sch 8",402,"SRFR",null,8.1736145600000008,8.4054561647709249,"Subject to Schedule 8"]
[0,"Transfer Read","Price Cap Sch 8",404,"SRTR",null,8.1736145600000008,8.4054561647709249,"Subject to Schedule 8"]
["Type 5-7 non standard metering data services","A request to conduct a site review of the state of the customer’s metering installation(s) (no physical meter test), i.e. multiple premises.  Includes provision of meter data above the minimum requirements and meter inspection to check a reported or suspected fault.  Does not include provision of any hardware.","Price Cap",955,"MSINS","BUSINESS HOURS - FIRST UNIT",136.90804388000004,140.79139075991304]
[0,0,"Price Cap",961,"MSINSA","AFTER HOURS - FIRST UNIT",390.74190307999993,401.82515507289941]
[0,0,"Price Cap",963,"MSINST","ANYTIME - FIRST UNIT",390.74190307999993,401.82515507289941]
["CT Metering","Provision, installation, testing and maintenance of instrument transformers for metering purposes.","Price Cap",539,"CTP&T",null,1016.5779083599999,1045.4127710659375]
[0,"Testing and maintenance of instrument transformers for metering purposes.","Price Cap",540,"CTT&MT",null,186.19617188000001,191.47755858767738]
["Ancillary Network Services"]
["Other Recoverable Works"]
["Customer consultation or appointment.\n","A visit to the customers premise to advise on electrical supply matters, could be for various reasons.","Price Cap",952,"MSAPWR","Complex (customer requested)",236.02852296000003,{"$f":"G188*(1+$I$4)","v":242.72338618520666}]
[null,null,"Price Cap",1074,"MCMSAPWR","Complex (third party requested)",236.02852296000003,242.72338618520666]
[null,null,"Price Cap",953,"MSAPWRS","Simple (customer requested)",107.51999755999999,110.56976319260848]
[null,null,"Price Cap",1075,"MCMSAPWRS","Simple (third party requested)",107.51999755999999,110.56976319260848]
["Attendance at customers premises to perform a statutory right where access is prevented","Energex attends a site at the customers request and is unable to perform job due to customers fault / fault of a third party.","Price Cap",1044,"MSWTV","BUSINESS HOURS - TECHNICAL (customer at fault)",94.407301840000002,97.085130626763672]
[null,null,"Price Cap",1069,"MCMSWTV","BUSINESS HOURS - TECHNICAL (third party at fault)",94.407301840000002,97.085130626763672]
[0,0,"Price Cap",1050,"MSWTV2CR","BUSINESS HOURS - TECHNICAL (2 crew) (customer at fault)",188.81460368,194.17026125352734]
[null,null,"Price Cap",1072,"MCMSWTV2CR","BUSINESS HOURS - TECHNICAL (2 crew) (third party at fault)",188.81460368,194.17026125352734]
[null,null,"Price Cap",1045,"MSWTVA","AFTER HOURS - TECHNICAL (customer at fault)",134.73115156,138.55275168085339]
[null,null,"Price Cap",1070,"MCMSWTVA","AFTER HOURS - TECHNICAL (third party at fault)",134.73115156,138.55275168085339]
[0,0,"Price Cap",1051,"MSWTV2CRAH","AFTER HOURS - TECHNICAL (2 crew) (customer at fault)",269.45203476,277.09494374340937]
[null,null,"Price Cap",1073,"MCMS2MWTVA","AFTER HOURS - TECHNICAL (2 crew) (third party at fault)",269.45203476,277.09494374340937]
[null,null,"Price Cap",1047,"MSWTVT","ANYTIME - TECHNICAL (customer at fault)",134.73115156,138.55275168085339]
[null,null,"Price Cap",1071,"MCMSWTVT","ANYTIME - TECHNICAL (third party at fault)",134.73115156,138.55275168085339]
[null,null,"Price Cap",1046,"MSWTV2","BUSINESS HOURS - NON TECHNICAL (customer at fault)",11.26439092,11.583901272303649]
[null,null,"Price Cap",1048,"MSWTV2A","AFTER HOURS - NON TECHNICAL (customer at fault)",80.69904124,82.988040199666699]
[0,0,"Price Cap",1049,"MSWTV2T","ANYTIME - NON TECHNICAL (customer at fault)",80.69904124,82.988040199666699]
["Public Lighting Services"]
["Provision, Construction and maintenance of public lighting"]
["Application assessment, design review and audit","Rate 2 public lighting services.\n\nDesign assessment and preparation of offer.\nNumber of new, modified or recovered sites (i.e. stations numbers excluding street light pits and conduits)","Price Cap","Charged Directly to Customer",null,"RESUBMISSION",173.88440824,{"$f":"G207*(1+$I$4)","v":178.81657624903372}]
["00:00:00","Rate 3 public lighting services.\n\nDesign Assessment and Preparation of Offer\nNumber of new, modified or recovered sites (i.e. stations numbers excluding street light pits and conduits).","Price Cap","Charged Directly to Customer",null,"0-6 SITES",86.94220412,89.408288124516858]
["00:00:00","00:00:00","Price Cap","Charged Directly to Customer",null,"7-30 SITES",130.41844036000001,134.11771199592403]
["00:00:00","00:00:00","Price Cap","Charged Directly to Customer",null,"31+ SITES",260.82661235999996,268.22486437355053]
["Provision of glare shields, vandal guards, luminaire replacement with aero screens","Replacement of existing streetlight luminaries with aero screen low glare luminaries.","Price Cap",600,"SLAU",null,552.13998556000013,567.80123547223309]
[0,"Customer requests the supply and installation of adhesive luminaire glare screen(s).","Price Cap",602,"SLLGAD",null,200.70536455999999,206.39829924197548]
[0,"Customer requests the supply and installation of standard luminaire glare screen(s) – internal.","Price Cap",604,"SLLGSDI",null,164.04731935999999,168.70046192007572]
["Note: \n1. The prices for the ACS services subject to Schedule 8 are currently based on the AER's approved prices.  These prices will be updated when Schedule 8 prices are published."]

{"sheet":"Metering Service Charge 2018-20","index":4,"n_rows":10,"n_cols":8,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["2018-19 Metering Service Charge",null,null,null,null,"CPI",{"$f":"'Price capped services 2018- 20'!H3","v":1.9090909090908999E-2},"Escalations"]
[null,null,null,null,null,"X non-cap",-0.02,{"$f":"(1+G1)*(1-G2)-1","v":3.9472727272727326E-2}]
[null,null,null,null,null,"x cap",-0.01,{"$f":"(1+G1)*(1-G3)-1","v":2.9281818181818187E-2}]
[null,null,null,null,"Daily (cents)","2018-19","2019-20"]
[null,null,null,"Primary","Non Capital",2.3140000000000001,{"$f":"F5*(1+H2)","v":2.4053398909090911}]
[null,null,null,null,"Capital",7.1669999999999998,{"$f":"F6*(1+H3)","v":7.3768627909090911}]
[null,null,null,"Load Control","Non Capital",0.69399999999999995,{"$f":"F7*(1+H2)","v":0.72139407272727274}]
[null,null,null,null,"Capital",2.15,{"$f":"F8*(1+H3)","v":2.2129559090909092}]
[null,null,null,"Solar PV","Non Capital",1.619,{"$f":"F9*(1+H2)","v":1.6829063454545454}]
[null,null,null,null,"Capital",5.0170000000000003,{"$f":"F10*(1+H3)","v":5.1639068818181819}]

{"sheet":"Public Lighting 2018-20","index":5,"n_rows":9,"n_cols":5,"rows_kept":9,"cut":false,"hidden":false,"merged":[[8,0,8,3]]}
["2017-18 Street Light Utility Charges"]
[null,null,"CPI",{"$f":"'Metering Service Charge 2018-20'!G1","v":1.9090909090908999E-2},"Escalation"]
[null,null,"X",-9.7999999999999997E-3,{"$f":"(1+D2)*(1-D3)-1","v":2.9077999999999937E-2}]
["$/Day","Category","2018-191","2019-20"]
["Major Street Lights","non-contributed",0.84299999999999997,{"$f":"C5*(1+$E$3)","v":0.86751275399999994}]
[null,"contributed",0.29299999999999998,{"$f":"C6*(1+$E$3)","v":0.30151985399999998}]
["Minor Street Lights","non-contributed",0.38700000000000001,0.39825318599999998]
[null,"contributed",0.14199999999999999,0.14612907599999997]
["Notes:\n1. All prices exclude GST."]