{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Revised Regulatory Proposal"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":5,"defined_names":22,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Revised Regulatory Proposal","index":0,"n_rows":97,"n_cols":13,"rows_kept":97,"cut":false,"hidden":false,"merged":[[94,2,96,2]]}
[null,null,null,null,null,null,null,null,null,null,null,"Escalation"]
["Measure","2014-15","2015-16","2016-17","2017-18","2018-19","Targets",null,null,null,null,"Index Numbers All groups CPI"]
["Unplanned SAIDI - CBD",{"$f":"B74+$C40","v":8.285982544553482},{"$f":"C74+$C40","v":7.4569825445534823},5.5769825445534824,5.4329825445534823,6.314982544553482,{"$f":"AVERAGE(B3:F3)","v":6.6135825445534824},null,null,null,null,"2014-09-01",106.4]
["Unplanned SAIDI - urban",{"$f":"B75+$D40","v":74.176982544553482},{"$f":"C75+$D40","v":57.296982544553479},57.466982544553481,57.966982544553481,52.328982544553483,{"$f":"AVERAGE(B4:F4)","v":59.847382544553476},null,null,null,null,"2018-12-01",116.9]
["Unplanned SAIDI - short rural",{"$f":"B76+$E40","v":150.27098254455348},{"$f":"C76+$E40","v":135.13698254455349},127.56698254455348,125.74698254455349,145.37998254455349,{"$f":"AVERAGE(B5:F5)","v":136.8203825445535},null,null,null,null,"CPI",{"$f":"M4/M3-1","v":9.8684210526315708E-2}]
["Unplanned SAIDI - long rural",null,null,null,null,null,null,null,null,null,null,"Source: ABS"]
[]
["Unplanned SAIFI - CBD",{"$f":"B79+$C41","v":0.19706375487688854},{"$f":"C79+$C41","v":5.6663754876888538E-2},4.946375487688854E-2,4.8563754876888542E-2,5.0763754876888542E-2,{"$f":"AVERAGE(B8:F8)","v":8.0503754876888531E-2}]
["Unplanned SAIFI - urban",{"$f":"B80+$D41","v":0.75446375487688855},{"$f":"C80+$D41","v":0.65176375487688853},0.62376375487688851,0.57566375487688859,0.59516375487688855,{"$f":"AVERAGE(B9:F9)","v":0.64016375487688859}]
["Unplanned SAIFI - short rural",{"$f":"B81+$E41","v":1.4697637548768885},{"$f":"C81+$E41","v":1.2807637548768884},1.2397637548768885,1.1217637548768884,1.2388637548768884,{"$f":"AVERAGE(B10:F10)","v":1.2701837548768884}]
["Unplanned SAIFI - long rural"]
[]
["Telephone answering parameter (measured as a percentage in STPIS)",{"$f":"'[3]Actual Performance'!G$18","v":82.7},{"$f":"'[3]Actual Performance'!H$18","v":91.5},{"$f":"'[3]Actual Performance'!I$18","v":88.5},{"$f":"'[3]Actual Performance'!J$18","v":88.1},{"$f":"'[3]Actual Performance'!K$18","v":89.6},{"$f":"AVERAGE(B13:F13)","v":88.08}]
[]
[]
[]
[]
[null,null,"CBD","Urban","Short rural"]
["Output parmaeters"]
["ir - SAIDI",null,{"$f":"((C23*(1+C24)*(1-(1/(1+C25)))*C26)/C27)/(365.25*24*60)*100","v":3.273499367690314E-3},{"$f":"((D23*(1+D24)*(1-(1/(1+D25)))*D26)/D27)/(365.25*24*60)*100","v":7.0393737792536465E-2},{"$f":"((E23*(1+E24)*(1-(1/(1+E25)))*E26)/E27)/(365.25*24*60)*100","v":1.7813701105848907E-2}]
["ir - SAIFI",null,{"$f":"(C23*(1+C24)/(1+C25))*C26/C27/(365.25*24*60)*C28/C29*100","v":0.17928404549470112},{"$f":"(D23*(1+D24)/(1+D25))*D26/D27/(365.25*24*60)*D28/D29*100","v":4.3872950968314974},{"$f":"(E23*(1+E24)/(1+E25))*E26/E27/(365.25*24*60)*E28/E29*100","v":1.2792256188542916}]
["Input parameters"]
["VCR",null,{"$f":"'[4]Reliablity Incentive Rates'!$E$78","v":44720},{"$f":"'[4]Reliablity Incentive Rates'!$E$79","v":39710},{"$f":"'[4]Reliablity Incentive Rates'!$E$79","v":39710}]
["CPI",null,{"$f":"M5","v":9.8684210526315708E-2},{"$f":"M5","v":9.8684210526315708E-2},{"$f":"M5","v":9.8684210526315708E-2}]
["w_n",null,1.5,1.5,1.5]
["C_n",null,{"$f":"I95","v":654006.59931269404},{"$f":"I96","v":15838199.285896957},{"$f":"I97","v":4007983.6215736754}]
["R",null,{"$f":"G30","v":1119806750.0241675},{"$f":"$G$30","v":1119806750.0241675},{"$f":"$G$30","v":1119806750.0241675}]
["SAIDI",null,{"$f":"G3","v":6.6135825445534824},{"$f":"G4","v":59.847382544553476},{"$f":"G5","v":136.8203825445535}]
["SAIFI",null,{"$f":"G8","v":8.0503754876888531E-2},{"$f":"G9","v":0.64016375487688859},{"$f":"G10","v":1.2701837548768884}]
["Smoothed MAR",null,null,null,null,null,{"$f":"AVERAGE('[5]Revenue summary'!$G$44:$K$44)*1000000","v":1119806750.0241675}]
[]
["%above cap exlcuding telephone answering",null,null,{"$f":"G89","v":2.6992623861876022E-2},null,null,null,"UPDATED BY EQ - Consistent with discussion with the AER that the averaging in undertaken in rows 86 and 89"]
["SAIDI proportion",null,null,{"$f":"D32*0.6","v":1.6195574317125611E-2}]
["SAIFI proportion",null,null,{"$f":"D32*0.4","v":1.0797049544750409E-2},null,null,"TOTAL"]
["SAIDI Incentive rates in current regulatory period",null,2.8E-5,4.9399999999999997E-4,1.16E-4,null,{"$f":"SUM(C35:E35)","v":6.38E-4}]
["Adj required to 2025-25 RCP reliability targets due to R@R cap for 2015/16 SAIDI",null,{"$f":"$D33*C$35/$G$35","v":7.107775562374876E-4},{"$f":"$D33*D$35/$G$35","v":1.2540146885047104E-2},2.9446498758410205E-3]
["SAIFI Incentive rates in current regulatory period",null,2.735E-3,3.3749000000000001E-2,9.6930000000000002E-3,null,{"$f":"SUM(C37:E37)","v":4.6177000000000003E-2}]
["Adj required to 2025-25 RCP reliability targets due to R@R cap for 2015/16 SAIFI",null,{"$f":"$D34*C$37/$G$37","v":6.3949434794145072E-4},{"$f":"$D34*D$37/$G$37","v":7.8911498167005562E-3},2.2664053801084026E-3]
[]
["Adj required to 2025-25 RCP reliability targets due to R@R",null,{"$f":"(C36/C35)/5","v":5.0769825445534824},{"$f":"D36/D35/5","v":5.0769825445534833},5.0769825445534833]
["Adj required to 2025-25 RCP reliability targets due to R@R",null,{"$f":"C38/C37/5","v":4.6763754876888539E-2},{"$f":"D38/D37/5","v":4.6763754876888539E-2},4.6763754876888532E-2]
[]
["Output tables"]
["Table 1 incentive rates"]
[null,{"$f":"C18","v":"CBD"},{"$f":"D18","v":"Urban"},{"$f":"E18","v":"Short rural"}]
["SAIDI",{"$f":"C20","v":3.273499367690314E-3},7.0393737792536465E-2,1.7813701105848907E-2]
["SAIFI",0.17928404549470112,4.3872950968314974,1.2792256188542916]
[]
["Table 2 targets"]
[null,"value"]
[{"$f":"B45","v":"CBD"}]
["SAIDI",{"$f":"G3","v":6.6135825445534824}]
["SAIFI",{"$f":"G8","v":8.0503754876888531E-2}]
[{"$f":"C45","v":"Urban"}]
["SAIDI",{"$f":"G4","v":59.847382544553476}]
["SAIFI",{"$f":"G9","v":0.64016375487688859}]
[{"$f":"D45","v":"Short rural"}]
["SAIDI",{"$f":"G5","v":136.8203825445535}]
["SAIFI",{"$f":"G10","v":1.2701837548768884}]
["Telephone answering"]
["Percentage of calls will be answered within 30 seconds",{"$f":"G13","v":88.08}]
[]
["Table 3"]
[null,{"$f":"B45","v":"CBD"},{"$f":"C45","v":"Urban"},{"$f":"D45","v":"Short rural"}]
["VCR",{"$f":"C23","v":44720},{"$f":"D23","v":39710},{"$f":"E23","v":39710}]
[]
[]
[]
[]
[]
[]
["Backcasted  data (<= 3MIN Momentary Removed)"]
["Measure",{"$f":"B2","v":"2014-15"},{"$f":"C2","v":"2015-16"},"2016-17","2017-18","2018-19"]
["Unplanned SAIDI - CBD",3.2090000000000001,2.38,0.5,0.35599999999999998,1.238]
["Unplanned SAIDI - urban",69.099999999999994,52.22,52.39,52.89,47.252000000000002]
["Unplanned SAIDI - short rural",145.19399999999999,130.06,122.49,120.67,140.303]
["Unplanned SAIDI - long rural"]
[]
["Unplanned SAIFI - CBD",0.15029999999999999,9.9000000000000008E-3,2.7000000000000001E-3,1.8E-3,4.0000000000000001E-3]
["Unplanned SAIFI - urban",0.7077,0.60499999999999998,0.57699999999999996,0.52890000000000004,0.5484]
["Unplanned SAIFI - short rural",1.423,1.234,1.1930000000000001,1.075,1.1920999999999999]
["Unplanned SAIFI - long rural"]
[]
[]
[]
["S-Factor",{"$f":"B2","v":"2014-15"},{"$f":"C2","v":"2015-16"},"2016-17","2017-18","2018-19","Cumulative"]
["sum of the raw s-factors for the relaibility of supply parameters",{"$f":"SUM('[3]S-factor'!I$9:I$15)","v":1.4981374049200046E-2},{"$f":"SUM('[3]S-factor'!J$9:J$15)","v":1.8408905636560009E-2},{"$f":"SUM('[3]S-factor'!K$9:K$15)","v":2.9830663989492249E-2},{"$f":"SUM('[3]S-factor'!L$9:L$15)","v":2.7335407310207865E-2},{"$f":"SUM('[3]S-factor'!M$9:M$15)","v":2.6826552562175907E-2}]
["Reliability cap",0.02,1.9E-2,1.9E-2,1.9E-2,1.9E-2]
["performance over the cap",{"$f":"IF(B87>B88,B87-B88,0)","v":0},{"$f":"IF(C87>C88,C87-C88,0)","v":0},1.0830663989492249E-2,8.3354073102078659E-3,7.826552562175907E-3,{"$f":"SUM(B89:F89)","v":2.6992623861876022E-2}]
[]
[]
[]
["FORECAST ENERGY CONSUMPTION BY NETWORK TYPE"]
["Network Type",null,"Source","2020-21","2021-22","2022-23","2023-24","2024-25","5 Year Average MWH"]
["CBD",null,null,652056.12700912787,654217.8864705998,653225.24941638566,654183.58630439825,656350.14736295841,{"$f":"AVERAGE(D95:H95)","v":654006.59931269404}]
[" URBAN",null,null,15790964.335855216,15843316.06624287,15819277.190335914,15842485.412747309,15894953.424303465,{"$f":"AVERAGE(D96:H96)","v":15838199.285896957}]
[" SHORT RURAL",null,null,3996030.4378363225,4009278.4639639896,4003195.2332142722,4009068.2604209404,4022345.7124328534,4007983.6215736754]