{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Cover Page","STPIS Targets & Incentive Rates"],"not_rendered":{"charts":0,"images":2,"macros":0,"external_links":2,"defined_names":23,"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":"Cover Page","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"STPIS Targets & Incentive Rates","index":1,"n_rows":98,"n_cols":13,"rows_kept":98,"cut":false,"hidden":false,"merged":[[95,2,97,2]]}
[null,null,null,null,null,null,null,null,null,null,null,"Escalation"]
["Measure","2018-19","2019-20","2020-21","2021-22","2022-23","Targets",null,null,null,null,"Index Numbers All groups CPI"]
["Unplanned SAIDI - CBD",{"$f":"B75+$C40","v":3.1512018415055003},{"$f":"C75+$C40","v":3.8813335245904201},6.7082072568055002,5.0566183435054999,3.3805631239055001,{"$f":"AVERAGE(B3:F3)","v":4.4355848180624839},null,null,null,null,"2019-09-01",115.4]
["Unplanned SAIDI - urban",{"$f":"B76+$D40","v":49.1652018415055},{"$f":"C76+$D40","v":53.728397227794794},51.657203702505498,59.546142131505498,56.078926432405495,{"$f":"AVERAGE(B4:F4)","v":54.035174267143361},null,null,null,null,"DEC 2025",144.6]
["Unplanned SAIDI - short rural",{"$f":"B77+$E40","v":142.21620184150549},{"$f":"C77+$E40","v":124.7807445780895},129.97288548190551,154.51877820840551,110.4361778816055,{"$f":"AVERAGE(B5:F5)","v":132.38495759830232},null,null,null,null,"CPI",{"$f":"M4/M3-1","v":0.25303292894280749}]
["Unplanned SAIDI - long rural",null,null,null,null,null,null,null,null,null,null,"Source: ABS"]
[]
["Unplanned SAIFI - CBD",{"$f":"B80+$C41","v":2.3959919951209201E-2},{"$f":"C80+$C41","v":3.30945499082691E-2},9.5441049651209198E-2,8.3695097851209196E-2,2.4645493351209202E-2,{"$f":"AVERAGE(B8:F8)","v":5.2167222142621185E-2}]
["Unplanned SAIFI - urban",{"$f":"B81+$D41","v":0.56835991995120916},{"$f":"C81+$D41","v":0.57961615574074721},0.5615982363512092,0.57725093225120916,0.53864321885120914,{"$f":"AVERAGE(B9:F9)","v":0.56509369262911668}]
["Unplanned SAIFI - short rural",{"$f":"B82+$E41","v":1.2120599199512092},{"$f":"C82+$E41","v":1.2566528261116994},1.1867893159512093,1.2815769083512092,0.95582377685120912,{"$f":"AVERAGE(B10:F10)","v":1.1785805494433073}]
["Unplanned SAIFI - long rural"]
[]
[]
[]
[]
[]
[]
[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":2.5394386606547152E-3},{"$f":"((D23*(1+D24)*(1-(1/(1+D25)))*D26)/D27)/(365.25*24*60)*100","v":5.4244526334024337E-2},{"$f":"((E23*(1+E24)*(1-(1/(1+E25)))*E26)/E27)/(365.25*24*60)*100","v":1.9582751818502931E-2}]
["ir - SAIFI",null,{"$f":"(C23*(1+C24)/(1+C25))*C26/C27/(365.25*24*60)*C28/C29*100","v":0.14394601446359495},{"$f":"(D23*(1+D24)/(1+D25))*D26/D27/(365.25*24*60)*D28/D29*100","v":3.4579663180696731},{"$f":"(E23*(1+E24)/(1+E25))*E26/E27/(365.25*24*60)*E28/E29*100","v":1.4664316723339312}]
["Input parameters"]
["VCR",null,{"$f":"B66","v":44520},{"$f":"C66","v":40030},{"$f":"D66","v":40030}]
["CPI",null,{"$f":"M5","v":0.25303292894280749},{"$f":"M5","v":0.25303292894280749},{"$f":"M5","v":0.25303292894280749}]
["w_n",null,1.5,1.5,1.5]
["C_n",null,{"$f":"I96","v":650234.59059508145},{"$f":"I97","v":15447486.657237802},{"$f":"I98","v":5576678.7521671196}]
["R",null,{"$f":"G30","v":1629478052.9097283},{"$f":"$G$30","v":1629478052.9097283},{"$f":"$G$30","v":1629478052.9097283}]
["SAIDI",null,{"$f":"G3","v":4.4355848180624839},{"$f":"G4","v":54.035174267143361},{"$f":"G5","v":132.38495759830232}]
["SAIFI",null,{"$f":"G8","v":5.2167222142621185E-2},{"$f":"G9","v":0.56509369262911668},{"$f":"G10","v":1.1785805494433073}]
["Smoothed MAR",null,null,null,null,null,1629478052.9097283]
[]
["%above cap exlcuding telephone answering",null,null,{"$f":"G90","v":1.3492855987217542E-2},"(5 years - 2018/19 to 2022/23)"]
["SAIDI proportion",null,null,{"$f":"D32*0.6","v":8.0957135923305241E-3}]
["SAIFI proportion",null,null,{"$f":"D32*0.4","v":5.3971423948870169E-3}]
["SAIDI Incentive rates in current regulatory period",null,2.9900000000000002E-5,6.5149999999999995E-4,1.6490000000000002E-4]
["Adj required to 2025-30 RCP reliability targets due to R@R cap for 2020-25 SAIDI",null,{"$f":"$D33*C$35/(SUM($C$35:$E$35))","v":2.8602367530507227E-4},{"$f":"$D33*D$35/(SUM($C$35:$E$35))","v":6.2322549987041667E-3},1.5774349183212851E-3]
["SAIFI Incentive rates in current regulatory period",null,1.6386E-3,4.06025E-2,1.1838700000000001E-2]
["Adj required to 2025-30 RCP reliability targets due to R@R cap for 2020-25 SAIFI",null,{"$f":"$D34*C$37/SUM($C$37:$E$37)","v":1.63531624160257E-4},{"$f":"$D34*D$37/SUM($C$37:$E$37)","v":4.052113249094858E-3},1.1814975216319021E-3]
[]
["Adj required to 2025-30 RCP reliability targets due to R@R",null,{"$f":"C36/C35/5","v":1.9132018415055001},{"$f":"D36/D35/5","v":1.9132018415055003},1.9132018415055001]
["Adj required to 2025-30 RCP reliability targets due to R@R",null,{"$f":"C38/C37/5","v":1.9959919951209201E-2},{"$f":"D38/D37/5","v":1.9959919951209201E-2},1.9959919951209205E-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":2.5394386606547152E-3},{"$f":"D20","v":5.4244526334024337E-2},1.9582751818502931E-2]
["SAIFI",{"$f":"C21","v":0.14394601446359495},3.4579663180696731,1.4664316723339312]
[]
["Table 2 targets"]
[null,"value"]
[{"$f":"B46","v":"CBD"}]
["SAIDI",{"$f":"G3","v":4.4355848180624839}]
["SAIFI",{"$f":"G8","v":5.2167222142621185E-2}]
[{"$f":"C46","v":"Urban"}]
["SAIDI",{"$f":"G4","v":54.035174267143361}]
["SAIFI",{"$f":"G9","v":0.56509369262911668}]
[{"$f":"D46","v":"Short rural"}]
["SAIDI",{"$f":"G5","v":132.38495759830232}]
["SAIFI",{"$f":"G10","v":1.1785805494433073}]
[]
[]
[]
["Table 3"]
[null,{"$f":"B46","v":"CBD"},{"$f":"C46","v":"Urban"},{"$f":"D46","v":"Short rural"}]
["VCR",44520,40030,40030]
[]
[]
[]
[]
[]
[]
["data (<= 3MIN Momentary Removed)"]
["Measure",{"$f":"B2","v":"2018-19"},"2019-20","2020-21","2021-22","2022-23"]
["Unplanned SAIDI - CBD",1.238,1.96813168308492,4.7950054153000004,3.143416502,1.4673612824]
["Unplanned SAIDI - urban",47.252000000000002,51.815195386289297,49.744001861000001,57.632940290000001,54.165724590899998]
["Unplanned SAIDI - short rural",140.303,122.867542736584,128.05968364040001,152.60557636690001,108.5229760401]
["Unplanned SAIDI - long rural"]
[]
["Unplanned SAIFI - CBD",4.0000000000000001E-3,1.31346299570599E-2,7.5481129699999996E-2,6.3735177899999995E-2,4.6855734000000003E-3]
["Unplanned SAIFI - urban",0.5484,0.55965623578953805,0.54163831640000004,0.5572910123,0.51868329889999998]
["Unplanned SAIFI - short rural",1.1920999999999999,1.2366929061604901,1.166829396,1.2616169883999999,0.93586385689999996]
["Unplanned SAIFI - long rural"]
[]
[]
[]
["S-Factor","2018-19","2019-20","2020-21","2021-22","2022-23","Cumulative"]
["sum of the raw s-factors for the relaibility of supply parameters",2.6826552562175907E-2,2.4666303425041634E-2,1.3314913122571409E-2,2.4365253999158259E-3,1.7536512630000001E-2]
["Reliability cap",1.9E-2,1.9E-2,1.7999999999999999E-2,1.7999999999999999E-2,1.7999999999999999E-2]
["performance over the cap",{"$f":"IF(B88>B89,B88-B89,0)","v":7.826552562175907E-3},{"$f":"IF(C88>C89,C88-C89,0)","v":5.6663034250416348E-3},0,0,0,{"$f":"SUM(B90:F90)","v":1.3492855987217542E-2}]
[]
[]
[]
["FORECAST ENERGY CONSUMPTION BY NETWORK TYPE"]
["Network Type",null,"Source","2023/24","2024/25","2025/26","2026/27","2027/28","5 Year Average MWH"]
["CBD",null,null,657092.61791810009,653612.60405340127,648482.58361492271,644852.56915260747,647132.5782363757,{"$f":"AVERAGE(D96:H96)","v":650234.59059508145}]
[" URBAN",null,null,15610411.372563003,15527737.413780309,15405864.595229963,15319627.103741119,15373792.800874608,{"$f":"AVERAGE(D97:H97)","v":15447486.657237802}]
[" SHORT RURAL",null,null,5635496.009518899,5605649.9821662903,5561652.8211551169,5530520.3271062747,5550074.6208890183,5576678.7521671196]