{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Table for Chapter","Incentive Rate Calculator (New)","VCR Calculation","Share of customer calculation","Source data >>","Energy Consumption forecast","PTRM","Inflation"],"not_rendered":{"charts":0,"images":2,"macros":0,"external_links":6,"defined_names":322,"comments":0,"pivot_tables":1},"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":"Table for Chapter","index":0,"n_rows":15,"n_cols":6,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Measure","Average Historic Performance","Modification","Proposed Targets","Proposed Incentive Rates"]
[null,"USAIDI ",null,null,null,"(%/minute)"]
[null,"Urban",{"$f":"'Incentive Rate Calculator (New)'!H30","v":88.03},0,{"$f":"C5+D5","v":88.03},{"$f":"'Incentive Rate Calculator (New)'!H50","v":2.017141892694929E-4}]
[null,"Rural Short",{"$f":"'Incentive Rate Calculator (New)'!H34","v":184.24},0,{"$f":"C6+D6","v":184.24},{"$f":"'Incentive Rate Calculator (New)'!H63","v":2.0032470759472006E-4}]
[null,"Rural long",{"$f":"'Incentive Rate Calculator (New)'!H38","v":295.08},0,295.08,{"$f":"'Incentive Rate Calculator (New)'!H75","v":7.9197185301898684E-5}]
[null,"USAIFI ",null,null,null,"(%/0.01 Interruptions)"]
[null,"Urban",{"$f":"'Incentive Rate Calculator (New)'!H29","v":0.81200000000000006},0,0.81200000000000006,{"$f":"'Incentive Rate Calculator (New)'!H48","v":1.457873569900941E-2}]
[null,"Rural Short",{"$f":"'Incentive Rate Calculator (New)'!H33","v":1.506},0,1.506,{"$f":"'Incentive Rate Calculator (New)'!H61","v":1.5917311008247115E-2}]
[null,"Rural long",{"$f":"'Incentive Rate Calculator (New)'!H37","v":2.1459999999999999},0,2.1459999999999999,{"$f":"'Incentive Rate Calculator (New)'!H73","v":7.2598650012066683E-3}]
[null,"MAIFI ",null,null,null,"(%/0.01 Interruptions)"]
[null,"Urban",2.9409999999999998,0,2.9409999999999998,{"$f":"'Incentive Rate Calculator (New)'!H49","v":1.1662988559207528E-3}]
[null,"Rural Short",4.9480000000000004,0,4.9480000000000004,{"$f":"'Incentive Rate Calculator (New)'!H62","v":1.2733848806597693E-3}]
[null,"Rural long",8.8390000000000004,0,8.8390000000000004,{"$f":"'Incentive Rate Calculator (New)'!H74","v":5.8078920009653348E-4}]

{"sheet":"Incentive Rate Calculator (New)","index":1,"n_rows":75,"n_cols":19,"rows_kept":75,"cut":false,"hidden":false,"merged":[[12,0,12,1],[0,7,0,11],[1,0,2,2],[5,0,5,2],[10,0,10,2],[11,0,11,1],[54,2,54,3],[15,0,15,1],[16,0,16,1],[19,6,19,7],[40,0,40,5],[41,2,41,3],[42,2,42,3],[44,2,44,3],[45,2,45,3],[46,2,46,3],[47,2,47,3],[53,0,53,5],[72,2,72,3],[55,2,55,3],[57,2,57,3],[58,2,58,3],[59,2,59,3],[60,2,60,3],[65,0,65,5],[66,2,66,3],[67,2,67,3],[69,2,69,3],[70,2,70,3],[71,2,71,3]]}
[null,null,null,null,null,null,null,"REG Period 1"]
["S-Factor Example of USAIDI and USAIFI",null,null,null,null,null,null,2027,2028,2029,2030,2031]
[null,null,null,null,null,null,null,"Year 1","Year 2","Year 3","Year 4","Year 5"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CBD",95700,1.5]
[null,"Year",null,null,null,null,{"$f":"\"Energy - \"&A7&\" (MWh)\"","v":"Energy - Urban (MWh)"},{"$f":"'Energy Consumption forecast'!$L$4*1000000*H11","v":3112094.4575866298},{"$f":"'Energy Consumption forecast'!$L$5*1000000*I11/SUM($I$11:$I$13)","v":3229609.8278975436},{"$f":"'Energy Consumption forecast'!$L$6*1000000*J11/SUM($J$11:$J$13)","v":3351574.3234189446},{"$f":"'Energy Consumption forecast'!$L$7*1000000*K11/SUM($K$11:$K$13)","v":3479674.6630222662},{"$f":"'Energy Consumption forecast'!$L$8*1000000*L11/SUM($L$11:$L$13)","v":3603650.5850864081},null,null,null,null,"Urban",47850,1.5]
["VCR",null,null,null,null,null,{"$f":"\"Energy - \"&A8&\" (MWh)\"","v":"Energy - Short Rural (MWh)"},{"$f":"'Energy Consumption forecast'!$L$4*1000000*H12","v":3090657.2040417055},{"$f":"'Energy Consumption forecast'!$L$5*1000000*I12/SUM($I$11:$I$13)","v":3207363.0851731892},{"$f":"'Energy Consumption forecast'!$L$6*1000000*J12/SUM($J$11:$J$13)","v":3328487.4443010441},{"$f":"'Energy Consumption forecast'!$L$7*1000000*K12/SUM($K$11:$K$13)","v":3455705.3815555},{"$f":"'Energy Consumption forecast'!$L$8*1000000*L12/SUM($L$11:$L$13)","v":3578827.3117787852},null,null,null,null,"Short Rural",47850,1.5]
["Urban","2023-09-01",{"$f":"'VCR Calculation'!O7*1000","v":44899.549907770117},null,null,null,{"$f":"\"Energy - \"&A9&\" (MWh)\"","v":"Energy - Long Rural (MWh)"},{"$f":"'Energy Consumption forecast'!$L$4*1000000*H13","v":1221872.9992524923},{"$f":"'Energy Consumption forecast'!$L$5*1000000*I13/SUM($I$11:$I$13)","v":1268011.977338464},{"$f":"'Energy Consumption forecast'!$L$6*1000000*J13/SUM($J$11:$J$13)","v":1315897.7745004876},{"$f":"'Energy Consumption forecast'!$L$7*1000000*K13/SUM($K$11:$K$13)","v":1366192.6316423733},{"$f":"'Energy Consumption forecast'!$L$8*1000000*L13/SUM($L$11:$L$13)","v":1414868.1566921747},null,null,null,null,"Long Rural",47850,1.5]
["Short Rural","2023-09-01",{"$f":"'VCR Calculation'!O6*1000","v":43743.091989422108}]
["Long Rural","2023-09-01",{"$f":"'VCR Calculation'!O7*1000","v":44899.549907770117}]
[]
["Ratio",null,null,null,null,null,{"$f":"\"Customers - \"&A7","v":"Customers - Urban"},{"$f":"'Share of customer calculation'!B17","v":0.41915848944981193},{"$f":"H11","v":0.41915848944981193},{"$f":"I11","v":0.41915848944981193},0.41915848944981193,0.41915848944981193,"* use the average customer share from RY 22 to RY 24 to split total energy delivered, this is because RY 21 is affected by COVID where the share of customer at shorrual is abnormally high while the share for urban is low,"]
[{"$f":"A7","v":"Urban"},null,{"$f":"VLOOKUP(A12,Q4:S6,3,FALSE)","v":1.5},null,null,null,{"$f":"\"Customers - \"&A8","v":"Customers - Short Rural"},{"$f":"'Share of customer calculation'!C17","v":0.41627117129918895},{"$f":"H12","v":0.41627117129918895},0.41627117129918895,0.41627117129918895,0.41627117129918895]
["Short Rural",null,{"$f":"VLOOKUP(A13,Q4:S6,3,FALSE)","v":1.5},null,null,null,"Customers - Long Rural",{"$f":"'Share of customer calculation'!D17","v":0.16457033925099915},0.16457033925099915,0.16457033925099915,0.16457033925099915,0.16457033925099915]
["Long Rural",null,{"$f":"VLOOKUP(A14,Q5:S7,3,FALSE)","v":1.5}]
[null,null,null,null,null,null,null,{"$f":"H2","v":2027},{"$f":"I2","v":2028},{"$f":"J2","v":2029},{"$f":"K2","v":2030},{"$f":"L2","v":2031}]
["CPI",null,null,null,null,null,"DUOS Revenue",827.45884050715301,906.95410722762676,994.08660872232326,1089.5900660969494,1194.268690192944,"*the revenue forecast will change"]
["CPI (September 2023 - June 2026) ",null,{"$f":"Inflation!F86/Inflation!F75-1","v":8.8339725055432528E-2},null,null,null,"Deflator",{"$f":"Inflation!F90/Inflation!F86","v":1.0249999999999999},{"$f":"Inflation!F94/Inflation!F86","v":1.0506249999999999},{"$f":"1.025^3","v":1.0768906249999999},{"$f":"1.025^4","v":1.1038128906249998},{"$f":"1.025^5","v":1.1314082128906247},"*apply the RBA long term forecast of 2.5%"]
[null,null,null,null,null,null,"DUOS $2021",{"$f":"H16/H17","v":807.27691756795423},{"$f":"I16/I17","v":863.25197594539145},923.10823926276021,987.11482294793893,1055.5595023848357]
[]
[null,null,null,null,null,null,"Average for Reg Period"]
[null,null,null,null,null,null,{"$f":"G5","v":"Energy - Urban (MWh)"},{"$f":"AVERAGE(H5:L5)","v":3355320.7714023581}]
[null,null,null,null,null,null,{"$f":"G6","v":"Energy - Short Rural (MWh)"},{"$f":"AVERAGE(H6:L6)","v":3332208.0853700447}]
[null,null,null,null,null,null,{"$f":"G7","v":"Energy - Long Rural (MWh)"},{"$f":"AVERAGE(H7:L7)","v":1317368.7078851983}]
[]
[null,null,null,null,null,null,{"$f":"G16","v":"DUOS Revenue"},{"$f":"AVERAGE(H18:L18)","v":927.26229162177628}]
[null,null,null,null,null,null,null,{"$f":"H25*1000000","v":927262291.62177634}]
[]
[]
[null,null,null,null,null,null,{"$f":"A7&\" - USAIFI\"","v":"Urban - USAIFI"},0.81200000000000006,{"$f":"H29","v":0.81200000000000006},0.81200000000000006,0.81200000000000006,0.81200000000000006,"*update when RY 25 actual data is available"]
[null,null,null,null,null,null,{"$f":"A7&\" - USAIDI\"","v":"Urban - USAIDI"},88.03,88.03,88.03,88.03,88.03]
[null,null,null,null,null,null,{"$f":"A7&\" - CAIDI\"","v":"Urban - CAIDI"}]
[]
[null,null,null,null,null,null,{"$f":"A8&\" - USAIFI\"","v":"Short Rural - USAIFI"},1.506,{"$f":"H33","v":1.506},1.506,1.506,1.506]
[null,null,null,null,null,null,{"$f":"A8&\" - USAIDI\"","v":"Short Rural - USAIDI"},184.24,184.24,184.24,184.24,184.24]
[null,null,null,null,null,null,{"$f":"A8&\" - CAIDI\"","v":"Short Rural - CAIDI"}]
[]
[null,null,null,null,null,null,{"$f":"A14&\" - USAIFI\"","v":"Long Rural - USAIFI"},2.1459999999999999,{"$f":"H37","v":2.1459999999999999},2.1459999999999999,2.1459999999999999,2.1459999999999999]
[null,null,null,null,null,null,{"$f":"A14&\" - USAIDI\"","v":"Long Rural - USAIDI"},295.08,295.08,295.08,295.08,295.08]
[null,null,null,null,null,null,{"$f":"A14&\" - USAIFI\"","v":"Long Rural - USAIFI"}]
[]
[{"$f":"A7&\" Incentive Rate Calculator\"","v":"Urban Incentive Rate Calculator"}]
[null,null,"STPIS Formula (1)",null,"$VCR in $Year0",null,{"$f":"\"VCR - \"&A7","v":"VCR - Urban"},{"$f":"($C$7*(1+C17))","v":48865.963801735197}]
[null,null,"STPIS Formula (2)",null,"VCR Split",null,"VCRSAIFI",{"$f":"H42/(1+$C$12)","v":19546.385520694079}]
[null,null,null,null,"VCR Split",null,"VCRSAIDI",{"$f":"H42-H43","v":29319.578281041118}]
[null,null,"STPIS Formula (3)",null,"(VCR * Energy(MWh)) / Revenue ($))",null,"(3)",{"$f":"((H43*((H21)))/(H26))","v":70.729063325455002}]
[null,null,"STPIS Formula (4)",null,"(3) / Per Minute",null,"Factor",{"$f":"H45/(365.25*24*60)","v":1.3447612617966195E-4}]
[null,null,"STPIS Formula (5)",null,"Factor * CAIDI",null,null,{"$f":"H46*(H30/H29)","v":1.457873569900941E-2}]
[null,null,"STPIS Formula (6)",null,"Expressed as Per SAIFI",null,"%0.01/USAIFI",{"$f":"H47","v":1.457873569900941E-2},{"$f":"H48","v":1.457873569900941E-2},1.457873569900941E-2,1.457873569900941E-2,1.457873569900941E-2]
[null,null,null,null,"MAIFI (8% SAIFI)",null,"%0.01/UMAIFI",{"$f":"H48*0.08","v":1.1662988559207528E-3},1.1662988559207528E-3,1.1662988559207528E-3,1.1662988559207528E-3,1.1662988559207528E-3]
[null,null,null,null,"Expressed as Per SAIDI",null,"% USAIDI",{"$f":"(((($C$7*(1+C17))*((1-(1/(1+$C$12))))*(H21))/(H26))/(365.25*24*60))","v":2.017141892694929E-4},2.017141892694929E-4,2.017141892694929E-4,2.017141892694929E-4,2.017141892694929E-4]
[]
[]
[]
[{"$f":"A8&\" Incentive Rate Calculator\"","v":"Short Rural Incentive Rate Calculator"}]
[null,null,"STPIS Formula (1)",null,"$VCR in $Year0",null,{"$f":"\"VCR - \"&A8","v":"VCR - Short Rural"},{"$f":"($C$8*(1+C17))","v":47607.344708842153}]
[null,null,"STPIS Formula (2)",null,"VCR Split",null,"VCRSAIFI",{"$f":"H55/(1+$C$13)","v":19042.937883536863}]
[null,null,null,null,"VCR Split",null,"VCRSAIDI",{"$f":"H55-H56","v":28564.40682530529}]
[null,null,"STPIS Formula (3)",null,"(VCR * Energy(MWh)) / Revenue ($))",null,"(3)",{"$f":"((H56*((H22)))/(H26))","v":68.432666957413502}]
[null,null,"STPIS Formula (4)",null,"(3) / Per Minute",null,"Factor",{"$f":"H58/(365.25*24*60)","v":1.3011002159368299E-4}]
[null,null,"STPIS Formula (5)",null,"Factor * CAIDI",null,null,{"$f":"H59*H34/H33","v":1.5917311008247115E-2}]
[null,null,"STPIS Formula (6)",null,"Expressed as Per SAIFI",null,"%0.01/USAIFI",{"$f":"H60","v":1.5917311008247115E-2},{"$f":"H61","v":1.5917311008247115E-2},{"$f":"I61","v":1.5917311008247115E-2},1.5917311008247115E-2,1.5917311008247115E-2]
[null,null,null,null,"MAIFI (8% SAIFI)",null,"%0.01/UMAIFI",{"$f":"H61*0.08","v":1.2733848806597693E-3},1.2733848806597693E-3,1.2733848806597693E-3,1.2733848806597693E-3,1.2733848806597693E-3]
[null,null,null,null,"Expressed as Per SAIDI",null,"% USAIDI",{"$f":"((($C$7*(1+C17)*((1-(1/(1+$C$13))))*(H22))/(H26))/(365.25*24*60))","v":2.0032470759472006E-4},{"$f":"H63","v":2.0032470759472006E-4},2.0032470759472006E-4,2.0032470759472006E-4,2.0032470759472006E-4]
[]
[]
[{"$f":"A14&\" Incentive Rate Calculator\"","v":"Long Rural Incentive Rate Calculator"}]
[null,null,"STPIS Formula (1)",null,"$VCR in $Year0",null,{"$f":"\"VCR - \"&A14","v":"VCR - Long Rural"},{"$f":"($C$9*(1+C17))","v":48865.963801735197}]
[null,null,"STPIS Formula (2)",null,"VCR Split",null,"VCRSAIFI",{"$f":"H67/(1+$C$13)","v":19546.385520694079}]
[null,null,null,null,"VCR Split",null,"VCRSAIDI",{"$f":"H67-H68","v":29319.578281041118}]
[null,null,"STPIS Formula (3)",null,"(VCR * Energy(MWh)) / Revenue ($))",null,"(3)",{"$f":"((H68*((H23)))/(H26))","v":27.769701054257755}]
[null,null,"STPIS Formula (4)",null,"(3) / Per Minute",null,"Factor",{"$f":"H70/(365.25*24*60)","v":5.2798123534599127E-5}]
[null,null,"STPIS Formula (5)",null,"Factor * CAIDI",null,null,{"$f":"H71*H38/H37","v":7.2598650012066683E-3}]
[null,null,"STPIS Formula (6)",null,"Expressed as Per SAIFI",null,"%0.01/USAIFI",{"$f":"H72","v":7.2598650012066683E-3},{"$f":"H73","v":7.2598650012066683E-3},{"$f":"I73","v":7.2598650012066683E-3},{"$f":"J73","v":7.2598650012066683E-3},{"$f":"K73","v":7.2598650012066683E-3}]
[null,null,null,null,"MAIFI (8% SAIFI)",null,"%0.01/UMAIFI",{"$f":"H73*0.08","v":5.8078920009653348E-4},5.8078920009653348E-4,5.8078920009653348E-4,5.8078920009653348E-4,5.8078920009653348E-4]
[null,null,null,null,"Expressed as Per SAIDI",null,"% USAIDI",{"$f":"((($C$7*(1+C17)*((1-(1/(1+$C$13))))*(H23))/(H26))/(365.25*24*60))","v":7.9197185301898684E-5},{"$f":"H75","v":7.9197185301898684E-5},{"$f":"I75","v":7.9197185301898684E-5},{"$f":"J75","v":7.9197185301898684E-5},{"$f":"K75","v":7.9197185301898684E-5}]

{"sheet":"VCR Calculation","index":2,"n_rows":10,"n_cols":15,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,"% Energy",null,null,null,"$VCR Value (kWh)",null,null,null,"VCR_Weighted"]
[null,null,"Commercial","Agri","Indust","Res","Commercial","Agri","Indust","Res","Commercial","Agri","Indust","Res","Total_VCR"]
[null,"Long rural",0.25328554743599041,0.21035247038298388,0.13895875033792982,0.39740323184309589,52.2,44.4,74.790000000000006,25.13,{"$f":"G5*C5","v":13.2215055761587},{"$f":"H5*D5","v":9.3396496850044848},10.392724937773771,9.9867432162169987,{"$f":"SUM(K5:N5)","v":42.940623415153958}]
[null,"Short rural",0.29081507783893584,6.045280748461971E-2,0.19282727007840292,0.45590484459804154,{"$f":"G5","v":52.2},{"$f":"H5","v":44.4},74.790000000000006,25.13,{"$f":"G6*C6","v":15.180547063192451},{"$f":"H6*D6","v":2.684104652317115},{"$f":"I6*E6","v":14.421551529163755},{"$f":"J6*F6","v":11.456888744748783},{"$f":"SUM(K6:N6)","v":43.743091989422105}]
[null,"Urban",0.48156182361144712,1.4212392783520716E-3,0.13504398030033007,0.38197295680987076,{"$f":"G6","v":52.2},44.4,74.790000000000006,25.13,25.137527192517542,6.310302395883198E-2,10.099939286661687,9.5989804046320515,44.899549907770115]
[]
[null,null,"VCR Rates as of September 2023"]
[null,null,"https://www.aer.gov.au/documents/aer-value-customer-reliability-update-summary-december-2023"]

{"sheet":"Share of customer calculation","index":3,"n_rows":17,"n_cols":10,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
[]
[]
["Average of Avg FdrClass Cust","Column Labels",null,null,null,null,null,"Note:","ELM15 (Short Rural) was inadvertently omitted in the RY21 (STPIS1) submission."]
["Row Labels","URBAN","RURAL SHORT","RURAL LONG","TOTAL",null,null,null,"This is the main reason why this version of STPIS2 recast, the Short Rural USAIDI is about 2.4mins higher than the STPIS1 value."]
["RY21",308958.5,325369.5,125639.5,{"$f":"SUM(B5:D5)","v":759967.5},"actual",null,null,4.1399999999999997,"Total Short Rural USAIDI minutes unaccounted in the RY21 STPIS1 from ELM15"]
["RY22",334819,315746,127846.5,{"$f":"SUM(B6:D6)","v":778411.5},"actual",null,null,2.39,"Net Short Rural USAIDI minutes unaccounted in the RY21 STPIS1 from ELM15"]
["RY23",334918.5,330339,130646.5,795904,"actual"]
["RY24",367629.5,306124,135536,809289.5,"actual"]
[null,null,null,null,null,null,null,null,"Datalink Source:","\"G:\\01 Distribution\\Regulatory\\2024 Review for EDPR FY2731\\Tableau\\NOS_CA_RIN_Summary.csv\""]
["RY25",359189.04816076945,325794.15742867312,138016.79441055737,823000,"forecast"]
[]
[]
[null,"URBAN","RURAL SHORT","RURAL LONG","TOTAL"]
["RY22",{"$f":"GETPIVOTDATA(\"Avg FdrClass Cust\",$A$3,\"Feeder classification\",\"URBAN\",\"AER_RY\",\"RY21\")/$E5","v":0.40654172711333053},{"$f":"GETPIVOTDATA(\"Avg FdrClass Cust\",$A$3,\"Feeder classification\",\"RURAL SHORT\",\"AER_RY\",\"RY21\")/E5","v":0.42813607160832534},{"$f":"GETPIVOTDATA(\"Avg FdrClass Cust\",$A$3,\"Feeder classification\",\"RURAL LONG\",\"AER_RY\",\"RY21\")/E5","v":0.16532220127834413},{"$f":"SUM(B14:D14)","v":1}]
["RY23",{"$f":"GETPIVOTDATA(\"Avg FdrClass Cust\",$A$3,\"Feeder classification\",\"URBAN\",\"AER_RY\",\"RY22\")/E6","v":0.43013110674752364},{"$f":"GETPIVOTDATA(\"Avg FdrClass Cust\",$A$3,\"Feeder classification\",\"RURAL SHORT\",\"AER_RY\",\"RY22\")/E6","v":0.40562864243398256},{"$f":"GETPIVOTDATA(\"Avg FdrClass Cust\",$A$3,\"Feeder classification\",\"RURAL LONG\",\"AER_RY\",\"RY22\")/E6","v":0.1642402508184938},{"$f":"SUM(B15:D15)","v":1}]
["RY24",{"$f":"GETPIVOTDATA(\"Avg FdrClass Cust\",$A$3,\"Feeder classification\",\"URBAN\",\"AER_RY\",\"RY23\")/E7","v":0.42080263448858152},{"$f":"GETPIVOTDATA(\"Avg FdrClass Cust\",$A$3,\"Feeder classification\",\"RURAL SHORT\",\"AER_RY\",\"RY23\")/E7","v":0.41504879985525894},{"$f":"GETPIVOTDATA(\"Avg FdrClass Cust\",$A$3,\"Feeder classification\",\"RURAL LONG\",\"AER_RY\",\"RY23\")/E7","v":0.16414856565615954},1]
["Average",{"$f":"AVERAGE(B14:B16)","v":0.41915848944981193},{"$f":"AVERAGE(C14:C16)","v":0.41627117129918895},0.16457033925099915,1]

{"sheet":"Source data >>","index":4,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Energy Consumption forecast","index":5,"n_rows":15,"n_cols":12,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
["asset_type","asset","demand_year","scenario","Base_Load","PV_Generation","EV_Load","Gas_Load","Operational_Demand",null,"Reg Year","Operational_Demand"]
["network","network",2024,"Step Change",{"$f":"I2-H2-G2-F2","v":8.4730128840737251},{"$f":"GETPIVOTDATA(\"value\",[5]Pivot!$A$3,\"demand_type\",\"PV_Generation\",\"demand_year\",C2)","v":-1.63197279453947},{"$f":"GETPIVOTDATA(\"value\",[5]Pivot!$A$3,\"demand_type\",\"EV_Load\",\"demand_year\",C2)","v":4.2943992319526697E-2},{"$f":"GETPIVOTDATA(\"value\",[5]Pivot!$A$3,\"demand_type\",\"Gas_Load\",\"demand_year\",C2)","v":0.132277049649589},{"$f":"GETPIVOTDATA(\"value\",[5]Pivot!$A$3,\"demand_type\",\"Operational_Demand_Actual_Residuals\",\"demand_year\",C2)","v":7.0162611315033701},null,"2024-25",{"$f":"9/12*I2+3/12*I3","v":7.0486240370003674}]
["network","network",2025,"Step Change",{"$f":"I3-H3-G3-F3","v":8.6251703756003018},{"$f":"GETPIVOTDATA(\"value\",[5]Pivot!$A$3,\"demand_type\",\"PV_Generation\",\"demand_year\",C3)","v":-1.80464702503573},{"$f":"GETPIVOTDATA(\"value\",[5]Pivot!$A$3,\"demand_type\",\"EV_Load\",\"demand_year\",C3)","v":8.8498938022875798E-2},{"$f":"GETPIVOTDATA(\"value\",[5]Pivot!$A$3,\"demand_type\",\"Gas_Load\",\"demand_year\",C3)","v":0.23669046490391199},{"$f":"GETPIVOTDATA(\"value\",[5]Pivot!$A$3,\"demand_type\",\"Operational_Demand_Actual_Residuals\",\"demand_year\",C3)","v":7.1457127534913596},null,"2025-26",{"$f":"9/12*I3+3/12*I4","v":7.1979956686368869}]
["network","network",2026,"Step Change",8.7812341940999286,{"$f":"GETPIVOTDATA(\"value\",[5]Pivot!$A$3,\"demand_type\",\"PV_Generation\",\"demand_year\",C4)","v":-1.95018708486422},{"$f":"GETPIVOTDATA(\"value\",[5]Pivot!$A$3,\"demand_type\",\"EV_Load\",\"demand_year\",C4)","v":0.14619270449204499},{"$f":"GETPIVOTDATA(\"value\",[5]Pivot!$A$3,\"demand_type\",\"Gas_Load\",\"demand_year\",C4)","v":0.37760460034571602},{"$f":"GETPIVOTDATA(\"value\",[5]Pivot!$A$3,\"demand_type\",\"Operational_Demand_Actual_Residuals\",\"demand_year\",C4)","v":7.3548444140734697},null,"2026-27",{"$f":"9/12*I4+3/12*I5","v":7.4246246608808271}]
["network","network",2027,"Step Change",8.9407016241082236,{"$f":"GETPIVOTDATA(\"value\",[5]Pivot!$A$3,\"demand_type\",\"PV_Generation\",\"demand_year\",C5)","v":-2.0737912528973799},{"$f":"GETPIVOTDATA(\"value\",[5]Pivot!$A$3,\"demand_type\",\"EV_Load\",\"demand_year\",C5)","v":0.21594031294522001},{"$f":"GETPIVOTDATA(\"value\",[5]Pivot!$A$3,\"demand_type\",\"Gas_Load\",\"demand_year\",C5)","v":0.55111471714683702},{"$f":"GETPIVOTDATA(\"value\",[5]Pivot!$A$3,\"demand_type\",\"Operational_Demand_Actual_Residuals\",\"demand_year\",C5)","v":7.6339654013029001},null,"2027-28",7.7049848904091967]
["network","network",2028,"Step Change",9.0996802612914394,{"$f":"GETPIVOTDATA(\"value\",[5]Pivot!$A$3,\"demand_type\",\"PV_Generation\",\"demand_year\",C6)","v":-2.1677667682359898},{"$f":"GETPIVOTDATA(\"value\",[5]Pivot!$A$3,\"demand_type\",\"EV_Load\",\"demand_year\",C6)","v":0.30660653682480499},{"$f":"GETPIVOTDATA(\"value\",[5]Pivot!$A$3,\"demand_type\",\"Gas_Load\",\"demand_year\",C6)","v":0.67952332784783498},{"$f":"GETPIVOTDATA(\"value\",[5]Pivot!$A$3,\"demand_type\",\"Operational_Demand_Actual_Residuals\",\"demand_year\",C6)","v":7.9180433577280898},null,"2028-29",7.9959595422204757]
["network","network",2029,"Step Change",9.2581494490068081,{"$f":"GETPIVOTDATA(\"value\",[5]Pivot!$A$3,\"demand_type\",\"PV_Generation\",\"demand_year\",C7)","v":-2.2536336435964301},{"$f":"GETPIVOTDATA(\"value\",[5]Pivot!$A$3,\"demand_type\",\"EV_Load\",\"demand_year\",C7)","v":0.41214560128911898},{"$f":"GETPIVOTDATA(\"value\",[5]Pivot!$A$3,\"demand_type\",\"Gas_Load\",\"demand_year\",C7)","v":0.81304668899813404},{"$f":"GETPIVOTDATA(\"value\",[5]Pivot!$A$3,\"demand_type\",\"Operational_Demand_Actual_Residuals\",\"demand_year\",C7)","v":8.2297080956976298},null,"2029-30",8.3015726762201396]
["network","network",2030,"Step Change",9.416211275189438,{"$f":"GETPIVOTDATA(\"value\",[5]Pivot!$A$3,\"demand_type\",\"PV_Generation\",\"demand_year\",C8)","v":-2.3447744335389702},{"$f":"GETPIVOTDATA(\"value\",[5]Pivot!$A$3,\"demand_type\",\"EV_Load\",\"demand_year\",C8)","v":0.52279813759649496},{"$f":"GETPIVOTDATA(\"value\",[5]Pivot!$A$3,\"demand_type\",\"Gas_Load\",\"demand_year\",C8)","v":0.92293143854070803},{"$f":"GETPIVOTDATA(\"value\",[5]Pivot!$A$3,\"demand_type\",\"Operational_Demand_Actual_Residuals\",\"demand_year\",C8)","v":8.5171664177876707},null,"2030-31",8.5973460535573683]
["network","network",2031,"Step Change",9.5797826251465263,{"$f":"GETPIVOTDATA(\"value\",[5]Pivot!$A$3,\"demand_type\",\"PV_Generation\",\"demand_year\",C9)","v":-2.4343322358511301},{"$f":"GETPIVOTDATA(\"value\",[5]Pivot!$A$3,\"demand_type\",\"EV_Load\",\"demand_year\",C9)","v":0.656995199912213},{"$f":"GETPIVOTDATA(\"value\",[5]Pivot!$A$3,\"demand_type\",\"Gas_Load\",\"demand_year\",C9)","v":1.0354393716588499},{"$f":"GETPIVOTDATA(\"value\",[5]Pivot!$A$3,\"demand_type\",\"Operational_Demand_Actual_Residuals\",\"demand_year\",C9)","v":8.8378849608664591},null,"2031-32",8.9199531539967793]
["network","network",2032,"Step Change",9.7490087422805267,{"$f":"GETPIVOTDATA(\"value\",[5]Pivot!$A$3,\"demand_type\",\"PV_Generation\",\"demand_year\",C10)","v":-2.5247615435343098},{"$f":"GETPIVOTDATA(\"value\",[5]Pivot!$A$3,\"demand_type\",\"EV_Load\",\"demand_year\",C10)","v":0.796060985786602},{"$f":"GETPIVOTDATA(\"value\",[5]Pivot!$A$3,\"demand_type\",\"Gas_Load\",\"demand_year\",C10)","v":1.1458495488549201},{"$f":"GETPIVOTDATA(\"value\",[5]Pivot!$A$3,\"demand_type\",\"Operational_Demand_Actual_Residuals\",\"demand_year\",C10)","v":9.16615773338774},null,"2032-33",9.2499200318378776]
["network","network",2033,"Step Change",9.9180023691475814,{"$f":"GETPIVOTDATA(\"value\",[5]Pivot!$A$3,\"demand_type\",\"PV_Generation\",\"demand_year\",C11)","v":-2.6092178930487999},{"$f":"GETPIVOTDATA(\"value\",[5]Pivot!$A$3,\"demand_type\",\"EV_Load\",\"demand_year\",C11)","v":0.939482335544368},{"$f":"GETPIVOTDATA(\"value\",[5]Pivot!$A$3,\"demand_type\",\"Gas_Load\",\"demand_year\",C11)","v":1.2529401155451401},{"$f":"GETPIVOTDATA(\"value\",[5]Pivot!$A$3,\"demand_type\",\"Operational_Demand_Actual_Residuals\",\"demand_year\",C11)","v":9.5012069271882904},null,"2033-34",9.586149012833399]
["network","network",2034,"Step Change",10.0862440273935,{"$f":"GETPIVOTDATA(\"value\",[5]Pivot!$A$3,\"demand_type\",\"PV_Generation\",\"demand_year\",C12)","v":-2.6898371537572001},{"$f":"GETPIVOTDATA(\"value\",[5]Pivot!$A$3,\"demand_type\",\"EV_Load\",\"demand_year\",C12)","v":1.0870128250786399},{"$f":"GETPIVOTDATA(\"value\",[5]Pivot!$A$3,\"demand_type\",\"Gas_Load\",\"demand_year\",C12)","v":1.3575555710537901},{"$f":"GETPIVOTDATA(\"value\",[5]Pivot!$A$3,\"demand_type\",\"Operational_Demand_Actual_Residuals\",\"demand_year\",C12)","v":9.8409752697687303},null,"2034-35",9.9261305578359469]
["network","network",2035,"Step Change",10.253683868329432,{"$f":"GETPIVOTDATA(\"value\",[5]Pivot!$A$3,\"demand_type\",\"PV_Generation\",\"demand_year\",C13)","v":-2.7705045715614398},{"$f":"GETPIVOTDATA(\"value\",[5]Pivot!$A$3,\"demand_type\",\"EV_Load\",\"demand_year\",C13)","v":1.2378447484669199},{"$f":"GETPIVOTDATA(\"value\",[5]Pivot!$A$3,\"demand_type\",\"Gas_Load\",\"demand_year\",C13)","v":1.4605723768026899},{"$f":"GETPIVOTDATA(\"value\",[5]Pivot!$A$3,\"demand_type\",\"Operational_Demand_Actual_Residuals\",\"demand_year\",C13)","v":10.1815964220376},null,"2035-36",10.26714372873195]
["network","network",2036,"Step Change",10.42477747810106,{"$f":"GETPIVOTDATA(\"value\",[5]Pivot!$A$3,\"demand_type\",\"PV_Generation\",\"demand_year\",C14)","v":-2.85801972362531},{"$f":"GETPIVOTDATA(\"value\",[5]Pivot!$A$3,\"demand_type\",\"EV_Load\",\"demand_year\",C14)","v":1.39218908608541},{"$f":"GETPIVOTDATA(\"value\",[5]Pivot!$A$3,\"demand_type\",\"Gas_Load\",\"demand_year\",C14)","v":1.56483880825384},{"$f":"GETPIVOTDATA(\"value\",[5]Pivot!$A$3,\"demand_type\",\"Operational_Demand_Actual_Residuals\",\"demand_year\",C14)","v":10.523785648815}]
["network","network",2037,"Step Change",10.599171613222198,{"$f":"GETPIVOTDATA(\"value\",[5]Pivot!$A$3,\"demand_type\",\"PV_Generation\",\"demand_year\",C15)","v":-2.9473242121825298},{"$f":"GETPIVOTDATA(\"value\",[5]Pivot!$A$3,\"demand_type\",\"EV_Load\",\"demand_year\",C15)","v":1.5497081976047899},{"$f":"GETPIVOTDATA(\"value\",[5]Pivot!$A$3,\"demand_type\",\"Gas_Load\",\"demand_year\",C15)","v":1.6679371479479399},{"$f":"GETPIVOTDATA(\"value\",[5]Pivot!$A$3,\"demand_type\",\"Operational_Demand_Actual_Residuals\",\"demand_year\",C15)","v":10.8694927465924}]

{"sheet":"PTRM","index":6,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Inflation","index":7,"n_rows":96,"n_cols":23,"rows_kept":96,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Worksheet check:",{"$f":"IF(COUNTA($T$5:$T$95)=COUNTIF($T5:$T96,\"OK\"),\"OK\",\"Check\")","v":"OK"},null,"Overall Check:",{"$f":"'[6]Check|List'!$S$1","v":"Ok"}]
[]
[]
[null,"Input | General inputs"]
[]
[null,null,null,"Index value, new base","Percentage Change from Corresponding Quarter of Previous Year","Index value, new base","Percentage Change from Corresponding Quarter of Previous Year"]
[null,null,"Source","ABS","Calculated","ABS","Calculated"]
[null,null,"Unit","index","Percent","index","Percent"]
[null,null,"2007-03-31",155.6,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C9>EOMONTH(DATE('[6]Input|General'!$G$12,MONTH('[6]Input|General'!$G$9),1),0),\"Ok\",IF(ISBLANK($D9),\"Check\",\"Ok\"))","v":"Ok"}]
[null,null,"2007-06-30",157.5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C10>EOMONTH(DATE('[6]Input|General'!$G$12,MONTH('[6]Input|General'!$G$9),1),0),\"Ok\",IF(ISBLANK($D10),\"Check\",\"Ok\"))","v":"Ok"}]
[null,null,"2007-09-30",158.6,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C11>EOMONTH(DATE('[6]Input|General'!$G$12,MONTH('[6]Input|General'!$G$9),1),0),\"Ok\",IF(ISBLANK($D11),\"Check\",\"Ok\"))","v":"Ok"}]
[null,null,"2007-12-31",160.1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C12>EOMONTH(DATE('[6]Input|General'!$G$12,MONTH('[6]Input|General'!$G$9),1),0),\"Ok\",IF(ISBLANK($D12),\"Check\",\"Ok\"))","v":"Ok"}]
[null,null,"2008-03-31",162.19999999999999,{"$f":"D13/D9-1","v":4.2416452442159303E-2},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C13>EOMONTH(DATE('[6]Input|General'!$G$12,MONTH('[6]Input|General'!$G$9),1),0),\"Ok\",IF(ISBLANK($D13),\"Check\",\"Ok\"))","v":"Ok"}]
[null,null,"2008-06-30",164.6,{"$f":"D14/D10-1","v":4.5079365079365052E-2},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C14>EOMONTH(DATE('[6]Input|General'!$G$12,MONTH('[6]Input|General'!$G$9),1),0),\"Ok\",IF(ISBLANK($D14),\"Check\",\"Ok\"))","v":"Ok"}]
[null,null,"2008-09-30",166.5,4.9810844892812067E-2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C15>EOMONTH(DATE('[6]Input|General'!$G$12,MONTH('[6]Input|General'!$G$9),1),0),\"Ok\",IF(ISBLANK($D15),\"Check\",\"Ok\"))","v":"Ok"}]
[null,null,"2008-12-31",166,3.6851967520299844E-2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C16>EOMONTH(DATE('[6]Input|General'!$G$12,MONTH('[6]Input|General'!$G$9),1),0),\"Ok\",IF(ISBLANK($D16),\"Check\",\"Ok\"))","v":"Ok"}]
[null,null,"2009-03-31",166.2,2.4660912453760897E-2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C17>EOMONTH(DATE('[6]Input|General'!$G$12,MONTH('[6]Input|General'!$G$9),1),0),\"Ok\",IF(ISBLANK($D17),\"Check\",\"Ok\"))","v":"Ok"}]
[null,null,"2009-06-30",167,1.4580801944106936E-2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C18>EOMONTH(DATE('[6]Input|General'!$G$12,MONTH('[6]Input|General'!$G$9),1),0),\"Ok\",IF(ISBLANK($D18),\"Check\",\"Ok\"))","v":"Ok"}]
[null,null,"2009-09-30",168.6,1.2612612612612484E-2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C19>EOMONTH(DATE('[6]Input|General'!$G$12,MONTH('[6]Input|General'!$G$9),1),0),\"Ok\",IF(ISBLANK($D19),\"Check\",\"Ok\"))","v":"Ok"}]
[null,null,"2009-12-31",169.5,2.108433734939763E-2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C20>EOMONTH(DATE('[6]Input|General'!$G$12,MONTH('[6]Input|General'!$G$9),1),0),\"Ok\",IF(ISBLANK($D20),\"Check\",\"Ok\"))","v":"Ok"}]
[null,null,"2010-03-31",171,2.8880866425992746E-2,95.2,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C21>EOMONTH(DATE('[6]Input|General'!$G$12,MONTH('[6]Input|General'!$G$9),1),0),\"Ok\",IF(ISBLANK($F21),\"Check\",\"Ok\"))","v":"Ok"}]
[null,null,"2010-06-30",172.1,3.0538922155688653E-2,95.8,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C22>EOMONTH(DATE('[6]Input|General'!$G$12,MONTH('[6]Input|General'!$G$9),1),0),\"Ok\",IF(ISBLANK($F22),\"Check\",\"Ok\"))","v":"Ok"}]
[null,null,"2010-09-30",173.3,2.7876631079478242E-2,96.5,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C23>EOMONTH(DATE('[6]Input|General'!$G$12,MONTH('[6]Input|General'!$G$9),1),0),\"Ok\",IF(ISBLANK($F23),\"Check\",\"Ok\"))","v":"Ok"}]
[null,null,"2010-12-31",174,2.6548672566371723E-2,96.9,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C24>EOMONTH(DATE('[6]Input|General'!$G$12,MONTH('[6]Input|General'!$G$9),1),0),\"Ok\",IF(ISBLANK($F24),\"Check\",\"Ok\"))","v":"Ok"}]
[null,null,"2011-03-31",176.7,3.3333333333333215E-2,98.3,{"$f":"IF(ISBLANK(F25),\"\",F25/F21-1)","v":3.2563025210083918E-2},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C25>EOMONTH(DATE('[6]Input|General'!$G$12,MONTH('[6]Input|General'!$G$9),1),0),\"Ok\",IF(ISBLANK($F25),\"Check\",\"Ok\"))","v":"Ok"}]
[null,null,"2011-06-30",178.3,3.6025566531086683E-2,99.2,{"$f":"IF(ISBLANK(F26),\"\",F26/F22-1)","v":3.5490605427975108E-2},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C26>EOMONTH(DATE('[6]Input|General'!$G$12,MONTH('[6]Input|General'!$G$9),1),0),\"Ok\",IF(ISBLANK($F26),\"Check\",\"Ok\"))","v":"Ok"}]
[null,null,"2011-09-30",179.4,3.5199076745527913E-2,99.8,3.4196891191709877E-2,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C27>EOMONTH(DATE('[6]Input|General'!$G$12,MONTH('[6]Input|General'!$G$9),1),0),\"Ok\",IF(ISBLANK($F27),\"Check\",\"Ok\"))","v":"Ok"}]
[null,null,"2011-12-31",179.4,3.1034482758620641E-2,99.8,2.9927760577915352E-2,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C28>EOMONTH(DATE('[6]Input|General'!$G$12,MONTH('[6]Input|General'!$G$9),1),0),\"Ok\",IF(ISBLANK($F28),\"Check\",\"Ok\"))","v":"Ok"}]
[null,null,"2012-03-31",179.5,1.5846066779853007E-2,99.9,1.6276703967446737E-2,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C29>EOMONTH(DATE('[6]Input|General'!$G$12,MONTH('[6]Input|General'!$G$9),1),0),\"Ok\",IF(ISBLANK($F29),\"Check\",\"Ok\"))","v":"Ok"}]
[null,null,"2012-06-30",null,null,100.4,1.2096774193548487E-2,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C30>EOMONTH(DATE('[6]Input|General'!$G$12,MONTH('[6]Input|General'!$G$9),1),0),\"Ok\",IF(ISBLANK($F30),\"Check\",\"Ok\"))","v":"Ok"}]
[null,null,"2012-09-30",null,null,101.8,2.0040080160320661E-2,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C31>EOMONTH(DATE('[6]Input|General'!$G$12,MONTH('[6]Input|General'!$G$9),1),0),\"Ok\",IF(ISBLANK($F31),\"Check\",\"Ok\"))","v":"Ok"}]
[null,null,"2012-12-31",null,null,102,2.2044088176352838E-2,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C32>EOMONTH(DATE('[6]Input|General'!$G$12,MONTH('[6]Input|General'!$G$9),1),0),\"Ok\",IF(ISBLANK($F32),\"Check\",\"Ok\"))","v":"Ok"}]
[null,null,"2013-03-31",null,null,102.4,2.5025025025025016E-2,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C33>EOMONTH(DATE('[6]Input|General'!$G$12,MONTH('[6]Input|General'!$G$9),1),0),\"Ok\",IF(ISBLANK($F33),\"Check\",\"Ok\"))","v":"Ok"}]
[null,null,"2013-06-30",null,null,102.8,2.3904382470119501E-2,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C34>EOMONTH(DATE('[6]Input|General'!$G$12,MONTH('[6]Input|General'!$G$9),1),0),\"Ok\",IF(ISBLANK($F34),\"Check\",\"Ok\"))","v":"Ok"}]
[null,null,"2013-09-30",null,null,104,2.16110019646365E-2,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C35>EOMONTH(DATE('[6]Input|General'!$G$12,MONTH('[6]Input|General'!$G$9),1),0),\"Ok\",IF(ISBLANK($F35),\"Check\",\"Ok\"))","v":"Ok"}]
[null,null,"2013-12-31",null,null,104.8,2.7450980392156765E-2,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C36>EOMONTH(DATE('[6]Input|General'!$G$12,MONTH('[6]Input|General'!$G$9),1),0),\"Ok\",IF(ISBLANK($F36),\"Check\",\"Ok\"))","v":"Ok"}]
[null,null,"2014-03-31",null,null,105.4,2.9296875E-2,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C37>EOMONTH(DATE('[6]Input|General'!$G$12,MONTH('[6]Input|General'!$G$9),1),0),\"Ok\",IF(ISBLANK($F37),\"Check\",\"Ok\"))","v":"Ok"}]
[null,null,"2014-06-30",null,null,105.9,3.0155642023346418E-2,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C38>EOMONTH(DATE('[6]Input|General'!$G$12,MONTH('[6]Input|General'!$G$9),1),0),\"Ok\",IF(ISBLANK($F38),\"Check\",\"Ok\"))","v":"Ok"}]
[null,null,"2014-09-30",null,null,106.4,2.3076923076923217E-2,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C39>EOMONTH(DATE('[6]Input|General'!$G$12,MONTH('[6]Input|General'!$G$9),1),0),\"Ok\",IF(ISBLANK($F39),\"Check\",\"Ok\"))","v":"Ok"}]
[null,null,"2014-12-31",null,null,106.6,1.7175572519083859E-2,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C40>EOMONTH(DATE('[6]Input|General'!$G$12,MONTH('[6]Input|General'!$G$9),1),0),\"Ok\",IF(ISBLANK($F40),\"Check\",\"Ok\"))","v":"Ok"}]
[null,null,"2015-03-31",null,null,106.8,1.3282732447817747E-2,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C41>EOMONTH(DATE('[6]Input|General'!$G$12,MONTH('[6]Input|General'!$G$9),1),0),\"Ok\",IF(ISBLANK($F41),\"Check\",\"Ok\"))","v":"Ok"}]
[null,null,"2015-06-30",null,null,107.5,1.5108593012275628E-2,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C42>EOMONTH(DATE('[6]Input|General'!$G$12,MONTH('[6]Input|General'!$G$9),1),0),\"Ok\",IF(ISBLANK($F42),\"Check\",\"Ok\"))","v":"Ok"}]
[null,null,"2015-09-30",null,null,108,1.5037593984962294E-2,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C43>EOMONTH(DATE('[6]Input|General'!$G$12,MONTH('[6]Input|General'!$G$9),1),0),\"Ok\",IF(ISBLANK($F43),\"Check\",\"Ok\"))","v":"Ok"}]
[null,null,"2015-12-31",null,null,108.4,1.6885553470919357E-2,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C44>EOMONTH(DATE('[6]Input|General'!$G$12,MONTH('[6]Input|General'!$G$9),1),0),\"Ok\",IF(ISBLANK($F44),\"Check\",\"Ok\"))","v":"Ok"}]
[null,null,"2016-03-31",null,null,108.2,1.3108614232209881E-2,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C45>EOMONTH(DATE('[6]Input|General'!$G$12,MONTH('[6]Input|General'!$G$9),1),0),\"Ok\",IF(ISBLANK($F45),\"Check\",\"Ok\"))","v":"Ok"}]
[null,null,"2016-06-30",null,null,108.6,1.0232558139534831E-2,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C46>EOMONTH(DATE('[6]Input|General'!$G$12,MONTH('[6]Input|General'!$G$9),1),0),\"Ok\",IF(ISBLANK($F46),\"Check\",\"Ok\"))","v":"Ok"}]
[null,null,"2016-09-30",null,null,109.4,1.2962962962963065E-2,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C47>EOMONTH(DATE('[6]Input|General'!$G$12,MONTH('[6]Input|General'!$G$9),1),0),\"Ok\",IF(ISBLANK($F47),\"Check\",\"Ok\"))","v":"Ok"}]
[null,null,"2016-12-31",null,null,110,1.4760147601476037E-2,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C48>EOMONTH(DATE('[6]Input|General'!$G$12,MONTH('[6]Input|General'!$G$9),1),0),\"Ok\",IF(ISBLANK($F48),\"Check\",\"Ok\"))","v":"Ok"}]
[null,null,"2017-03-31",null,null,110.5,2.1256931608133023E-2,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C49>EOMONTH(DATE('[6]Input|General'!$G$12,MONTH('[6]Input|General'!$G$9),1),0),\"Ok\",IF(ISBLANK($F49),\"Check\",\"Ok\"))","v":"Ok"}]
[null,null,"2017-06-30",null,null,110.7,1.9337016574585641E-2,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C50>EOMONTH(DATE('[6]Input|General'!$G$12,MONTH('[6]Input|General'!$G$9),1),0),\"Ok\",IF(ISBLANK($F50),\"Check\",\"Ok\"))","v":"Ok"}]
[null,null,"2017-09-30",null,null,111.4,1.8281535648994485E-2,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C51>EOMONTH(DATE('[6]Input|General'!$G$12,MONTH('[6]Input|General'!$G$9),1),0),\"Ok\",IF(ISBLANK($F51),\"Check\",\"Ok\"))","v":"Ok"}]
[null,null,"2017-12-31",null,null,112.1,1.9090909090909047E-2,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C52>EOMONTH(DATE('[6]Input|General'!$G$12,MONTH('[6]Input|General'!$G$9),1),0),\"Ok\",IF(ISBLANK($F52),\"Check\",\"Ok\"))","v":"Ok"}]
[null,null,"2018-03-31",null,null,112.6,1.9004524886877761E-2,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C53>EOMONTH(DATE('[6]Input|General'!$G$12,MONTH('[6]Input|General'!$G$9),1),0),\"Ok\",IF(ISBLANK($F53),\"Check\",\"Ok\"))","v":"Ok"}]
[null,null,"2018-06-30",null,null,113,2.0776874435411097E-2,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C54>EOMONTH(DATE('[6]Input|General'!$G$12,MONTH('[6]Input|General'!$G$9),1),0),\"Ok\",IF(ISBLANK($F54),\"Check\",\"Ok\"))","v":"Ok"}]
[null,null,"2018-09-30",null,null,113.5,1.8850987432674993E-2,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C55>EOMONTH(DATE('[6]Input|General'!$G$12,MONTH('[6]Input|General'!$G$9),1),0),\"Ok\",IF(ISBLANK($F55),\"Check\",\"Ok\"))","v":"Ok"}]
[null,null,"2018-12-31",null,null,114.1,1.7841213202497874E-2,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C56>EOMONTH(DATE('[6]Input|General'!$G$12,MONTH('[6]Input|General'!$G$9),1),0),\"Ok\",IF(ISBLANK($F56),\"Check\",\"Ok\"))","v":"Ok"}]
[null,null,"2019-03-31",null,null,114.1,1.3321492007104752E-2,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C57>EOMONTH(DATE('[6]Input|General'!$G$12,MONTH('[6]Input|General'!$G$9),1),0),\"Ok\",IF(ISBLANK($F57),\"Check\",\"Ok\"))","v":"Ok"}]
[null,null,"2019-06-30",null,null,114.8,1.5929203539823078E-2,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C58>EOMONTH(DATE('[6]Input|General'!$G$12,MONTH('[6]Input|General'!$G$9),1),0),\"Ok\",IF(ISBLANK($F58),\"Check\",\"Ok\"))","v":"Ok"}]
[null,null,"2019-09-30",null,null,115.4,1.6740088105726914E-2,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C59>EOMONTH(DATE('[6]Input|General'!$G$12,MONTH('[6]Input|General'!$G$9),1),0),\"Ok\",IF(ISBLANK($F59),\"Check\",\"Ok\"))","v":"Ok"}]
[null,null,"2019-12-31",null,null,116.2,1.8404907975460238E-2,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C60>EOMONTH(DATE('[6]Input|General'!$G$12,MONTH('[6]Input|General'!$G$9),1),0),\"Ok\",IF(ISBLANK($F60),\"Check\",\"Ok\"))","v":"Ok"}]
[null,null,"2020-03-31",null,null,116.6,2.1910604732690686E-2,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C61>EOMONTH(DATE('[6]Input|General'!$G$12,MONTH('[6]Input|General'!$G$9),1),0),\"Ok\",IF(ISBLANK($F61),\"Check\",\"Ok\"))","v":"Ok"}]
[null,null,"2020-06-30",null,null,114.4,-3.4843205574912606E-3,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C62>EOMONTH(DATE('[6]Input|General'!$G$12,MONTH('[6]Input|General'!$G$9),1),0),\"Ok\",IF(ISBLANK($F62),\"Check\",\"Ok\"))","v":"Ok"}]
[null,null,"2020-09-30",null,null,116.2,6.9324090121316573E-3,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C63>EOMONTH(DATE('[6]Input|General'!$G$12,MONTH('[6]Input|General'!$G$9),1),0),\"Ok\",IF(ISBLANK($F63),\"Check\",\"Ok\"))","v":"Ok"}]
[118,null,"2020-12-31",null,null,117.2,{"$f":"IF(ISBLANK(F64),\"\",F64/F60-1)","v":8.6058519793459354E-3},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C64>EOMONTH(DATE('[6]Input|General'!$G$12,MONTH('[6]Input|General'!$G$9),1),0),\"Ok\",IF(ISBLANK($F64),\"Check\",\"Ok\"))","v":"Ok"}]
[null,null,"2021-03-31",null,null,117.9,1.1149228130360234E-2,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C65>EOMONTH(DATE('[6]Input|General'!$G$12,MONTH('[6]Input|General'!$G$9),1),0),\"Ok\",IF(ISBLANK($F65),\"Check\",\"Ok\"))","v":"Ok"}]
[null,null,"2021-06-30",null,null,118.8,3.8461538461538325E-2,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C66>EOMONTH(DATE('[6]Input|General'!$G$12,MONTH('[6]Input|General'!$G$9),1),0),\"Ok\",IF(ISBLANK($F66),\"Check\",\"Ok\"))","v":"Ok"}]
[null,null,"2021-09-30",null,null,119.7,3.0120481927710774E-2,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C67>EOMONTH(DATE('[6]Input|General'!$G$12,MONTH('[6]Input|General'!$G$9),1),0),\"Ok\",IF(ISBLANK($F67),\"Check\",\"Ok\"))","v":"Ok"}]
[null,null,"2021-12-31",null,null,121.3,3.4982935153583528E-2,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C68>EOMONTH(DATE('[6]Input|General'!$G$12,MONTH('[6]Input|General'!$G$9),1),0),\"Ok\",IF(ISBLANK($F68),\"Check\",\"Ok\"))","v":"Ok"}]
[null,null,"2022-03-31",null,null,123.9,5.0890585241730291E-2,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C69>EOMONTH(DATE('[6]Input|General'!$G$12,MONTH('[6]Input|General'!$G$9),1),0),\"Ok\",IF(ISBLANK($F69),\"Check\",\"Ok\"))","v":"Ok"}]
[null,null,"2022-06-30",null,null,126.1,6.1447811447811418E-2,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C70>EOMONTH(DATE('[6]Input|General'!$G$12,MONTH('[6]Input|General'!$G$9),1),0),\"Ok\",IF(ISBLANK($F70),\"Check\",\"Ok\"))","v":"Ok"}]
[null,null,"2022-09-30",null,null,128.4,7.268170426065157E-2,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C71>EOMONTH(DATE('[6]Input|General'!$G$12,MONTH('[6]Input|General'!$G$9),1),0),\"Ok\",IF(ISBLANK($F71),\"Check\",\"Ok\"))","v":"Ok"}]
[null,null,"2022-12-31",null,null,130.80000000000001,7.8318219291014124E-2,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C72>EOMONTH(DATE('[6]Input|General'!$G$12,MONTH('[6]Input|General'!$G$9),1),0),\"Ok\",IF(ISBLANK($F72),\"Check\",\"Ok\"))","v":"Ok"}]
[null,null,"2023-03-31",null,null,132.6,7.0217917675544639E-2,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C73>EOMONTH(DATE('[6]Input|General'!$G$12,MONTH('[6]Input|General'!$G$9),1),0),\"Ok\",IF(ISBLANK($F73),\"Check\",\"Ok\"))","v":"Ok"}]
[null,null,"2023-06-30",null,null,133.69999999999999,6.0269627279936566E-2,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C74>EOMONTH(DATE('[6]Input|General'!$G$12,MONTH('[6]Input|General'!$G$9),1),0),\"Ok\",IF(ISBLANK($F74),\"Check\",\"Ok\"))","v":"Ok"}]
[null,null,"2023-09-30",null,null,135.30000000000001,5.3738317757009435E-2,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C75>EOMONTH(DATE('[6]Input|General'!$G$12,MONTH('[6]Input|General'!$G$9),1),0),\"Ok\",IF(ISBLANK($F75),\"Check\",\"Ok\"))","v":"Ok"}]
[null,null,"2023-12-31",null,null,136.1,4.0519877675840865E-2,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C76>EOMONTH(DATE('[6]Input|General'!$G$12,MONTH('[6]Input|General'!$G$9),1),0),\"Ok\",IF(ISBLANK($F76),\"Check\",\"Ok\"))","v":"Ok"}]
[null,null,"2024-03-31",null,null,137.4,3.6199095022624528E-2,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C77>EOMONTH(DATE('[6]Input|General'!$G$12,MONTH('[6]Input|General'!$G$9),1),0),\"Ok\",IF(ISBLANK($F77),\"Check\",\"Ok\"))","v":"Ok"}]
[null,null,"2024-06-30",null,null,138.80000000000001,3.7999999999999999E-2,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C78>EOMONTH(DATE('[6]Input|General'!$G$12,MONTH('[6]Input|General'!$G$9),1),0),\"Ok\",IF(ISBLANK($F78),\"Check\",\"Ok\"))","v":"Ok"}]
[null,null,"2024-09-30",null,null,{"$f":"AVERAGE(F78,F80)","v":139.4915},{"$f":"IF(ISBLANK(F79),\"\",F79/F75-1)","v":3.0979305247597955E-2},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C79>EOMONTH(DATE('[6]Input|General'!$G$12,MONTH('[6]Input|General'!$G$9),1),0),\"Ok\",IF(ISBLANK($F79),\"Check\",\"Ok\"))","v":"Ok"}]
[null,null,"2024-12-31",null,null,{"$f":"(F76*(1+G80))","v":140.18299999999999},0.03,"Source: RBA Statement of Monetary Policy, Aug 2024",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C80>EOMONTH(DATE('[6]Input|General'!$G$12,MONTH('[6]Input|General'!$G$9),1),0),\"Ok\",IF(ISBLANK($F80),\"Check\",\"Ok\"))","v":"Ok"}]
[null,null,"2025-03-31",null,null,{"$f":"AVERAGE(F80,F82)","v":141.43470000000002},{"$f":"IF(ISBLANK(F81),\"\",F81/F77-1)","v":2.9364628820960803E-2},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C81>EOMONTH(DATE('[6]Input|General'!$G$12,MONTH('[6]Input|General'!$G$9),1),0),\"Ok\",IF(ISBLANK($F81),\"Check\",\"Ok\"))","v":"Ok"}]
[null,null,"2025-06-30",null,null,{"$f":"(F78*(1+G82))","v":142.68640000000002},2.8000000000000001E-2,"Source: RBA Statement of Monetary Policy, Aug 2024",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C82>EOMONTH(DATE('[6]Input|General'!$G$12,MONTH('[6]Input|General'!$G$9),1),0),\"Ok\",IF(ISBLANK($F82),\"Check\",\"Ok\"))","v":"Ok"}]
[null,null,"2025-09-30",null,null,{"$f":"AVERAGE(F82,F84)","v":144.0280855},{"$f":"IF(ISBLANK(F83),\"\",F83/F79-1)","v":3.2522307810870288E-2},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C83>EOMONTH(DATE('[6]Input|General'!$G$12,MONTH('[6]Input|General'!$G$9),1),0),\"Ok\",IF(ISBLANK($F83),\"Check\",\"Ok\"))","v":"Ok"}]
[null,null,"2025-12-31",null,null,{"$f":"(F80*(1+G84))","v":145.36977099999999},3.6999999999999998E-2,"Source: RBA Statement of Monetary Policy, Aug 2024",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C84>EOMONTH(DATE('[6]Input|General'!$G$12,MONTH('[6]Input|General'!$G$9),1),0),\"Ok\",IF(ISBLANK($F84),\"Check\",\"Ok\"))","v":"Ok"}]
[null,null,"2026-03-31",null,null,{"$f":"AVERAGE(F84,F86)","v":146.31106790000001},{"$f":"IF(ISBLANK(F85),\"\",F85/F81-1)","v":3.4477874948651177E-2},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C85>EOMONTH(DATE('[6]Input|General'!$G$12,MONTH('[6]Input|General'!$G$9),1),0),\"Ok\",IF(ISBLANK($F85),\"Check\",\"Ok\"))","v":"Ok"}]
[null,null,"2026-06-30",null,null,{"$f":"(F82*(1+G86))","v":147.25236480000004},3.2000000000000001E-2,"Source: RBA Statement of Monetary Policy, Aug 2024",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C86>EOMONTH(DATE('[6]Input|General'!$G$12,MONTH('[6]Input|General'!$G$9),1),0),\"Ok\",IF(ISBLANK($F86),\"Check\",\"Ok\"))","v":"Ok"}]
[null,null,"2026-09-30",null,null,{"$f":"AVERAGE(F86,F88)","v":148.20087492300001},{"$f":"IF(ISBLANK(F87),\"\",F87/F83-1)","v":2.8972053669351849E-2},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C87>EOMONTH(DATE('[6]Input|General'!$G$12,MONTH('[6]Input|General'!$G$9),1),0),\"Ok\",IF(ISBLANK($F87),\"Check\",\"Ok\"))","v":"Ok"}]
[null,null,"2026-12-31",null,null,{"$f":"(F84*(1+G88))","v":149.14938504599999},2.5999999999999999E-2,"Source: RBA Statement of Monetary Policy, Aug 2024",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C88>EOMONTH(DATE('[6]Input|General'!$G$12,MONTH('[6]Input|General'!$G$9),1),0),\"Ok\",IF(ISBLANK($F88),\"Check\",\"Ok\"))","v":"Ok"}]
[null,null,"2027-03-31",null,null,{"$f":"(F85*(1+G89))","v":149.96884459750001},2.5000000000000001E-2,"AS: based on the RBA's LT forecast",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C89>EOMONTH(DATE('[6]Input|General'!$G$12,MONTH('[6]Input|General'!$G$9),1),0),\"Ok\",IF(ISBLANK($F89),\"Check\",\"Ok\"))","v":"Ok"}]
[null,null,"2027-06-30",null,null,{"$f":"(F86*(1+G90))","v":150.93367392000002},2.5000000000000001E-2,"AS: based on the RBA's LT forecast",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C90>EOMONTH(DATE('[6]Input|General'!$G$12,MONTH('[6]Input|General'!$G$9),1),0),\"Ok\",IF(ISBLANK($F90),\"Check\",\"Ok\"))","v":"Ok"}]
[null,null,"2027-09-30",null,null,151.90589679607501,2.5000000000000001E-2,"AS: based on the RBA's LT forecast",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C91>EOMONTH(DATE('[6]Input|General'!$G$12,MONTH('[6]Input|General'!$G$9),1),0),\"Ok\",IF(ISBLANK($F91),\"Check\",\"Ok\"))","v":"Ok"}]
[null,null,"2027-12-31",null,null,152.87811967214998,2.5000000000000001E-2,"AS: based on the RBA's LT forecast",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C92>EOMONTH(DATE('[6]Input|General'!$G$12,MONTH('[6]Input|General'!$G$9),1),0),\"Ok\",IF(ISBLANK($F92),\"Check\",\"Ok\"))","v":"Ok"}]
[null,null,"2028-03-31",null,null,153.71806571243749,2.5000000000000001E-2,"AS: based on the RBA's LT forecast",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C93>EOMONTH(DATE('[6]Input|General'!$G$12,MONTH('[6]Input|General'!$G$9),1),0),\"Ok\",IF(ISBLANK($F93),\"Check\",\"Ok\"))","v":"Ok"}]
[null,null,"2028-06-30",null,null,154.70701576800002,2.5000000000000001E-2,"AS: based on the RBA's LT forecast",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C94>EOMONTH(DATE('[6]Input|General'!$G$12,MONTH('[6]Input|General'!$G$9),1),0),\"Ok\",IF(ISBLANK($F94),\"Check\",\"Ok\"))","v":"Ok"}]
[]
[null,"End"]