{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["Home","Methodology","Report|Table","Calc|RIN Indicative bill impact","Calc|Network Bill Impacts","Calc|Retail Bill Impacts","Data|Typical customer","Data|Wholesale forecast","Data|Retail tariffs","Data|Network tariffs","Data|PTRM Revenues"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":8,"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":"Home","index":0,"n_rows":26,"n_cols":3,"rows_kept":26,"cut":false,"hidden":false,"merged":[[22,1,22,3],[17,1,17,3],[7,2,7,3],[4,1,4,3],[15,2,15,3],[20,1,20,3],[19,1,19,3],[18,1,18,3],[6,2,6,3],[8,2,8,3],[9,2,9,3],[10,2,10,3],[11,2,11,3],[13,2,13,3],[14,2,14,3],[12,2,12,3]]}
[]
[null,"Evoenergy revised proposal gas network | customer impacts model"]
[null,{"$f":"HYPERLINK(\"#'\"&RIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1)))&\"'!A1\",RIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1))))","v":"Home"}]
[]
[null,"Contents"]
[null,{"$f":"HYPERLINK(\"#'\"&RIGHT(CELL(\"filename\",Home!A1),LEN(CELL(\"filename\",Home!A1))-FIND(\"]\",CELL(\"filename\",Home!A1)))&\"'!A1\",RIGHT(CELL(\"filename\",Home!A1),LEN(CELL(\"filename\",Home!A1))-FIND(\"]\",CELL(\"filename\",Home!A1))))","v":"Home"}]
[null,{"$f":"HYPERLINK(\"#'\"&RIGHT(CELL(\"filename\",Methodology!A1),LEN(CELL(\"filename\",Methodology!A1))-FIND(\"]\",CELL(\"filename\",Methodology!A1)))&\"'!A1\",RIGHT(CELL(\"filename\",Methodology!A1),LEN(CELL(\"filename\",Methodology!A1))-FIND(\"]\",CELL(\"filename\",Methodology!A1))))","v":"Methodology"},"Explains the calculations and assumptions applied in this model."]
[null,{"$f":"HYPERLINK(\"#'\"&RIGHT(CELL(\"filename\",'Report|Table'!A1),LEN(CELL(\"filename\",'Report|Table'!A1))-FIND(\"]\",CELL(\"filename\",'Report|Table'!A1)))&\"'!A1\",RIGHT(CELL(\"filename\",'Report|Table'!A1),LEN(CELL(\"filename\",'Report|Table'!A1))-FIND(\"]\",CELL(\"filename\",'Report|Table'!A1))))","v":"Report|Table"},"Shows the table of price and bill impacts in the revised proposal document"]
[null,{"$f":"HYPERLINK(\"#'\"&RIGHT(CELL(\"filename\",'Calc|RIN Indicative bill impact'!A1),LEN(CELL(\"filename\",'Calc|RIN Indicative bill impact'!A1))-FIND(\"]\",CELL(\"filename\",'Calc|RIN Indicative bill impact'!A1)))&\"'!A1\",RIGHT(CELL(\"filename\",'Calc|RIN Indicative bill impact'!A1),LEN(CELL(\"filename\",'Calc|RIN Indicative bill impact'!A1))-FIND(\"]\",CELL(\"filename\",'Calc|RIN Indicative bill impact'!A1))))","v":"Calc|RIN Indicative bill impact"},"This sheet (sourced from the RIN) calculates the network bill by applying an assumed proportion to a total retail bill and the annual nominal price change from the PTRM."]
[null,{"$f":"HYPERLINK(\"#'\"&RIGHT(CELL(\"filename\",'Calc|Network Bill Impacts'!A1),LEN(CELL(\"filename\",'Calc|Network Bill Impacts'!A1))-FIND(\"]\",CELL(\"filename\",'Calc|Network Bill Impacts'!A1)))&\"'!A1\",RIGHT(CELL(\"filename\",'Calc|Network Bill Impacts'!A1),LEN(CELL(\"filename\",'Calc|Network Bill Impacts'!A1))-FIND(\"]\",CELL(\"filename\",'Calc|Network Bill Impacts'!A1))))","v":"Calc|Network Bill Impacts"},"This sheet calculates network bills for the typical customer using the network tariffs from the PTRM. This is more accurate than the RIN method."]
[null,{"$f":"HYPERLINK(\"#'\"&RIGHT(CELL(\"filename\",'Calc|Retail Bill Impacts'!A1),LEN(CELL(\"filename\",'Calc|Retail Bill Impacts'!A1))-FIND(\"]\",CELL(\"filename\",'Calc|Retail Bill Impacts'!A1)))&\"'!A1\",RIGHT(CELL(\"filename\",'Calc|Retail Bill Impacts'!A1),LEN(CELL(\"filename\",'Calc|Retail Bill Impacts'!A1))-FIND(\"]\",CELL(\"filename\",'Calc|Retail Bill Impacts'!A1))))","v":"Calc|Retail Bill Impacts"},"This sheet calculates the network and retail bills using the 2020-21 tariffs from the PTRM and Energy Made Easy website. The network tariffs continue to be applied for the network bill until 2025-26. The wholesale component of the retail bill is grown in the AEMO wholesale price growth forecast. The residual (not network or whoelsale) is constant in real terms."]
[null,{"$f":"HYPERLINK(\"#'\"&RIGHT(CELL(\"filename\",'Data|Typical customer'!A1),LEN(CELL(\"filename\",'Data|Typical customer'!A1))-FIND(\"]\",CELL(\"filename\",'Data|Typical customer'!A1)))&\"'!A1\",RIGHT(CELL(\"filename\",'Data|Typical customer'!A1),LEN(CELL(\"filename\",'Data|Typical customer'!A1))-FIND(\"]\",CELL(\"filename\",'Data|Typical customer'!A1))))","v":"Data|Typical customer"},"This sheet contains the assumptions for the typical customers."]
[null,{"$f":"HYPERLINK(\"#'\"&RIGHT(CELL(\"filename\",'Data|Wholesale forecast'!A1),LEN(CELL(\"filename\",'Data|Wholesale forecast'!A1))-FIND(\"]\",CELL(\"filename\",'Data|Wholesale forecast'!A1)))&\"'!A1\",RIGHT(CELL(\"filename\",'Data|Wholesale forecast'!A1),LEN(CELL(\"filename\",'Data|Wholesale forecast'!A1))-FIND(\"]\",CELL(\"filename\",'Data|Wholesale forecast'!A1))))","v":"Data|Wholesale forecast"},"This sheet contains the AEMO wholesale gas price forecast used to escalate the whole sale companent of the retail bills."]
[null,{"$f":"HYPERLINK(\"#'\"&RIGHT(CELL(\"filename\",'Data|Retail tariffs'!A1),LEN(CELL(\"filename\",'Data|Retail tariffs'!A1))-FIND(\"]\",CELL(\"filename\",'Data|Retail tariffs'!A1)))&\"'!A1\",RIGHT(CELL(\"filename\",'Data|Retail tariffs'!A1),LEN(CELL(\"filename\",'Data|Retail tariffs'!A1))-FIND(\"]\",CELL(\"filename\",'Data|Retail tariffs'!A1))))","v":"Data|Retail tariffs"},"This sheet contains the retail tariffs from the Energy Made Easy website in summary form to be used in the Retail Bill calculations."]
[null,{"$f":"HYPERLINK(\"#'\"&RIGHT(CELL(\"filename\",'Data|Network tariffs'!A1),LEN(CELL(\"filename\",'Data|Network tariffs'!A1))-FIND(\"]\",CELL(\"filename\",'Data|Network tariffs'!A1)))&\"'!A1\",RIGHT(CELL(\"filename\",'Data|Network tariffs'!A1),LEN(CELL(\"filename\",'Data|Network tariffs'!A1))-FIND(\"]\",CELL(\"filename\",'Data|Network tariffs'!A1))))","v":"Data|Network tariffs"},"This sheet contains the block structure and tariffs from the PTRM."]
[null,{"$f":"HYPERLINK(\"#'\"&RIGHT(CELL(\"filename\",'Data|PTRM Revenues'!A1),LEN(CELL(\"filename\",'Data|PTRM Revenues'!A1))-FIND(\"]\",CELL(\"filename\",'Data|PTRM Revenues'!A1)))&\"'!A1\",RIGHT(CELL(\"filename\",'Data|PTRM Revenues'!A1),LEN(CELL(\"filename\",'Data|PTRM Revenues'!A1))-FIND(\"]\",CELL(\"filename\",'Data|PTRM Revenues'!A1))))","v":"Data|PTRM Revenues"},"This sheet contains the PTRM CPI and x-factors."]
[]
[null,"Colour legend"]
[null,"Label"]
[null,"Calculation or link"]
[null,"Data inputs"]
[]
[null,"Sheet prefixes"]
[null,"\"Calc|\"   Sheet contains mostly calculations"]
[null,"\"Data|\"   Sheet contains the data used in the calculations"]
[null,"\"XXXXX\"   Sheet contains cells used to setup the model, these should not be changed unless you know how they affect the model"]

{"sheet":"Methodology","index":1,"n_rows":27,"n_cols":2,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
[]
[null,{"$f":"HYPERLINK(\"#'\"&RIGHT(CELL(\"filename\",Home!A1),LEN(CELL(\"filename\",Home!A1))-FIND(\"]\",CELL(\"filename\",Home!A1)))&\"'!A1\",\"Click to go to \"\"\"&RIGHT(CELL(\"filename\",Home!A1),LEN(CELL(\"filename\",Home!A1))-FIND(\"]\",CELL(\"filename\",Home!A1)))&\"\"\"\")","v":"Click to go to \"Home\""}]
[null,"Evoenergy Revised Proposal gas distribution network revenue customer impacts model"]
[null,{"$f":"HYPERLINK(\"#'\"&RIGHT(CELL(\"filename\",A3),LEN(CELL(\"filename\",A3))-FIND(\"]\",CELL(\"filename\",A3)))&\"'!A1\",RIGHT(CELL(\"filename\",A3),LEN(CELL(\"filename\",A3))-FIND(\"]\",CELL(\"filename\",A3))))","v":"Methodology"}]
[]
[null,"Purpose"]
[null,"This spreadsheet caclulates the impact of the network prices from the PTRM on the network bill and retail bill for the \"typical\" resdiential and business customer. It also calculates the weighted average price change for network tariffs over the period, which is the equivalent to a negative x-factor."]
[]
[null,"Methodology"]
[null,{"$f":"\"The assumptions for the typical customers are shown on the \"\"Data|Typical Customer\"\" sheet. The assumptions required are the typical annual consumption of \"& ROUND('Data|Typical customer'!$D$8,0) &\" GJ per annum for residential customers and \"& ROUND('Data|Typical customer'!D14,0) &\" GJ per annum for business customers. The other assumption is that the wholesale proportion of the customer retail bill is \"& ROUND('Data|Typical customer'!$D$12,2)*100&\"% for the typical residential customer and \"& ROUND('Data|Typical customer'!$D$18,2)*100&\"% for the typical business customer. The network bill and the retail bill amounts are calculated in this spreadsheet so the network proportion of the customer bill is calculated accordingly\"","v":"The assumptions for the typical customers are shown on the \"Data|Typical Customer\" sheet. The assumptions required are the typical annual consumption of 28 GJ per annum for residential customers and 469 GJ per annum for business customers. The other assumption is that the wholesale proportion of the customer retail bill is 51% for the typical residential customer and 51% for the typical business customer. The network bill and the retail bill amounts are calculated in this spreadsheet so the network proportion of the customer bill is calculated accordingly"}]
[null,"The 2020-21 retail tariffs are taken from the Energy Made Easy website. The retail tariffs were chosen by entering the typical consumption into the EME website, which resulted in the following 4 plans for residential customers:"]
[null," - EnergyAustralia - \"Total Plan Home\""]
[null," - Origin Energy - \"Origin Go\""]
[null," - Red Energy - \"Living Energy Saver\""]
[null," - ActewAGL - \"Home Gas Plan - ACT\""]
[null,"The following plans were used for business customers and were also chosen using the EME website:"]
[null," - EnergyAustralia - \"Total Plan Business\""]
[null," - Origin Energy - \"Business Flexi Usage\""]
[null," - Red Energy - \"Red Taronga Saver\""]
[null," - ActewAGL - \"ACT Business Gas - 15% off usage\""]
[null,"The 2020-21 retail bill for the typical customers was calculated by assumption the annual consumption was based on equal consumption for each billing period and mulitplied by each retail tariff described above, minus the discounts stated on the Energy Made Easy website. The average total bill from the four retailers was chosen as the \"typical\" customer bill."]
[null,"The retail bill for 2020-21 was split into the network component, the wholesale component and the residual."]
[null,"The retail bill was forecast as the sume of the above three component for 2021-22 to 2025-26 as follows:"]
[null," 1. The wholesale component was caclulated using the rate of change from the AEMO wholesale price forecast."]
[null," 2. The residual was held constant in real terms; and"]
[null," 3. The network bill was calculated using the forecast network tariffs and volumes from the PTRM."]
[null,"The AER RIN workbook is based on the AER's calculations but the inputs for the typical customer have been changed to be consistent with the typical network and retail bill as described above."]

{"sheet":"Report|Table","index":2,"n_rows":11,"n_cols":8,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[]
[null,{"$f":"HYPERLINK(\"#'\"&RIGHT(CELL(\"filename\",Home!A1),LEN(CELL(\"filename\",Home!A1))-FIND(\"]\",CELL(\"filename\",Home!A1)))&\"'!A1\",\"Click to go to \"\"\"&RIGHT(CELL(\"filename\",Home!A1),LEN(CELL(\"filename\",Home!A1))-FIND(\"]\",CELL(\"filename\",Home!A1)))&\"\"\"\")","v":"Click to go to \"Home\""}]
[null,{"$f":"ModelName","v":"Evoenergy revised proposal gas network | customer impacts model"}]
[null,{"$f":"HYPERLINK(\"#'\"&RIGHT(CELL(\"filename\",A3),LEN(CELL(\"filename\",A3))-FIND(\"]\",CELL(\"filename\",A3)))&\"'!A1\",RIGHT(CELL(\"filename\",A3),LEN(CELL(\"filename\",A3))-FIND(\"]\",CELL(\"filename\",A3))))","v":"Report|Table"}]
[]
[null,"$ nominal","2020/21","2021/22","2022/23","2023/24","2024/25","2025/26"]
[null,"Revised proposal"]
[null,"Real weighted average price increase across all tariffs* (%)",null,{"$f":"-'Data|PTRM Revenues'!E9","v":5.3516442139300803E-4},{"$f":"-'Data|PTRM Revenues'!F9","v":0},{"$f":"-'Data|PTRM Revenues'!G9","v":0},{"$f":"-'Data|PTRM Revenues'!H9","v":0},{"$f":"-'Data|PTRM Revenues'!I9","v":0}]
[null,"Increase in the typical residential customer network bill ($)",null,{"$f":"'Calc|Network Bill Impacts'!D7-'Calc|Network Bill Impacts'!C7","v":9.8099999999999454},{"$f":"'Calc|Network Bill Impacts'!E7-'Calc|Network Bill Impacts'!D7","v":8.2238454849699565},{"$f":"'Calc|Network Bill Impacts'!F7-'Calc|Network Bill Impacts'!E7","v":8.4191049620596914},{"$f":"'Calc|Network Bill Impacts'!G7-'Calc|Network Bill Impacts'!F7","v":8.6190005018606257},{"$f":"'Calc|Network Bill Impacts'!H7-'Calc|Network Bill Impacts'!G7","v":8.8236421788115535}]
[null,"Estimated Evoenergy network gas bill for the typical residential customer ($)",{"$f":"'Calc|Network Bill Impacts'!C7","v":336.55799999999999},{"$f":"'Calc|Network Bill Impacts'!D7","v":346.36799999999994},{"$f":"'Calc|Network Bill Impacts'!E7","v":354.59184548496989},{"$f":"'Calc|Network Bill Impacts'!F7","v":363.01095044702959},{"$f":"'Calc|Network Bill Impacts'!G7","v":371.62995094889021},{"$f":"'Calc|Network Bill Impacts'!H7","v":380.45359312770177}]
[null,"Estimated retail gas bill for the typical residential customer ($)",{"$f":"'Calc|Retail Bill Impacts'!C7","v":1440.1432058602272},{"$f":"'Calc|Retail Bill Impacts'!D7","v":1487.5596442711576},{"$f":"'Calc|Retail Bill Impacts'!E7","v":1546.6541187743269},{"$f":"'Calc|Retail Bill Impacts'!F7","v":1615.6691202842799},{"$f":"'Calc|Retail Bill Impacts'!G7","v":1673.5166087174957},{"$f":"'Calc|Retail Bill Impacts'!H7","v":1721.3966043410219}]

{"sheet":"Calc|RIN Indicative bill impact","index":3,"n_rows":60,"n_cols":12,"rows_kept":60,"cut":false,"hidden":false,"merged":[[31,2,31,3],[27,1,27,2],[14,1,14,2],[15,1,15,2],[12,1,12,2],[13,1,13,2],[16,2,16,3],[23,2,23,3],[28,1,28,2],[29,1,29,2],[30,1,30,2]]}
[]
[null,{"$f":"HYPERLINK(\"#'\"&RIGHT(CELL(\"filename\",Home!A1),LEN(CELL(\"filename\",Home!A1))-FIND(\"]\",CELL(\"filename\",Home!A1)))&\"'!A1\",\"Click to go to \"\"\"&RIGHT(CELL(\"filename\",Home!A1),LEN(CELL(\"filename\",Home!A1))-FIND(\"]\",CELL(\"filename\",Home!A1)))&\"\"\"\")","v":"Click to go to \"Home\""}]
[null,{"$f":"ModelName","v":"Evoenergy revised proposal gas network | customer impacts model"}]
[null,{"$f":"HYPERLINK(\"#'\"&RIGHT(CELL(\"filename\",A3),LEN(CELL(\"filename\",A3))-FIND(\"]\",CELL(\"filename\",A3)))&\"'!A1\",RIGHT(CELL(\"filename\",A3),LEN(CELL(\"filename\",A3))-FIND(\"]\",CELL(\"filename\",A3))))","v":"Calc|RIN Indicative bill impact"}]
[]
[null,"REGULATORY REPORTING STATEMENT"]
[null,"Evoenergy Distribution"]
[null,"2021-22 to 2025-26"]
[]
[null,"1 - TYPICAL GAS BILL"]
[]
[null,"A. ANNUAL USAGE PER CUSTOMER"]
[null,null,null,"MJ"]
[null,null,null,"2020-21"]
[null,"Residential customer",null,{"$f":"'Data|Typical customer'!D8*1000","v":28000}]
[null,"Small business customer",null,{"$f":"'Data|Typical customer'!D14*1000","v":468800}]
[null,"Source(s) of data:","CIE Forecast for 2021-26 access arrangement period"]
[]
[]
[null,"B. TYPICAL ANNUAL GAS BILL"]
[null,null,"Tariff type","($ real, June 2021)"]
[null,"Residential customer","Home Gas Plan",{"$f":"'Data|Typical customer'!D10","v":1440.1432058602272}]
[null,"Small business customer","Business Gas Plan",{"$f":"'Data|Typical customer'!D16","v":11870.401489421023}]
[null,"Source(s) of data:","ActewAGL standard contract natural gas prices for 2020/21 applied to volumes above."]
[]
[]
[null,"C. DISTRIBUTION COSTS AS A PROPORTION OF A TYPICAL CUSTOMER'S GAS BILL"]
[null,null,null,"Proportion (%)"]
[null,null,null,"2020-21"]
[null,"Residential customer",null,{"$f":"'Data|Typical customer'!D11","v":0.23369759245502739}]
[null,"Small business customer",null,{"$f":"'Data|Typical customer'!D17","v":0.2563345142716324}]
[null,"Source(s) of data:","ActewAGL standard contract prices and Evoenergy approved tariff variation notice (VRI) both for 2020/21 using volumes above."]
[]
[]
[null,"2 - INDICATIVE ANNUAL AVERAGE DISTRIBUTION PRICE IMPACT"]
[null,null,null,"2020-21","2021-22","2022-23","2023-24","2024-25","2025-26","Annual Average"]
[null,"Forecast inflation (per cent)",null,null,{"$f":"'Data|PTRM Revenues'!E8","v":2.3743086789108414E-2},{"$f":"'Data|PTRM Revenues'!F8","v":2.3743086789108414E-2},{"$f":"'Data|PTRM Revenues'!G8","v":2.3743086789108414E-2},{"$f":"'Data|PTRM Revenues'!H8","v":2.3743086789108414E-2},{"$f":"'Data|PTRM Revenues'!I8","v":2.3743086789108414E-2}]
[]
[null,"Forecast X factors (per cent)",null,null,{"$f":"'Data|PTRM Revenues'!E9","v":-5.3516442139300803E-4},{"$f":"'Data|PTRM Revenues'!F9","v":0},{"$f":"'Data|PTRM Revenues'!G9","v":0},{"$f":"'Data|PTRM Revenues'!H9","v":0},{"$f":"'Data|PTRM Revenues'!I9","v":0}]
[]
[null,"Annual price path (index, nominal)",null,1,{"$f":"D41*(1+E37)*(1-E39)","v":1.0242909576658048},{"$f":"E41*(1+F37)*(1-F39)","v":1.0486107867709631},{"$f":"F41*(1+G37)*(1-G39)","v":1.0735080436892612},{"$f":"G41*(1+H37)*(1-H39)","v":1.0989964383393813},{"$f":"H41*(1+I37)*(1-I39)","v":1.1250900061557942}]
[null,"Annual price path (per cent, nominal)",null,null,{"$f":"E41/D41-1","v":2.4290957665804802E-2},{"$f":"F41/E41-1","v":2.3743086789108414E-2},{"$f":"G41/F41-1","v":2.3743086789108414E-2},{"$f":"H41/G41-1","v":2.3743086789108414E-2},{"$f":"I41/H41-1","v":2.3743086789108414E-2},{"$f":"(I41/D41)^(1/5)-1","v":2.3852637515896502E-2}]
[]
[null,"Annual price path (index, real June 2021)",null,1,{"$f":"D44*(1-E39)","v":1.0005351644213929},{"$f":"E44*(1-F39)","v":1.0005351644213929},{"$f":"F44*(1-G39)","v":1.0005351644213929},{"$f":"G44*(1-H39)","v":1.0005351644213929},{"$f":"H44*(1-I39)","v":1.0005351644213929}]
[null,"Annual price path (per cent, real June 2021)",null,null,{"$f":"E44/D44-1","v":5.3516442139289744E-4},{"$f":"F44/E44-1","v":0},{"$f":"G44/F44-1","v":0},{"$f":"H44/G44-1","v":0},{"$f":"I44/H44-1","v":0},{"$f":"(I44/D44)^(1/5)-1","v":1.0700997955614966E-4}]
[]
[null,"3 - DISTRIBUTION BILL COMPONENT"]
[null,"Residential customer"]
[null,null,null,"2020-21","2021-22","2022-23","2023-24","2024-25","2025-26",{"$f":"\"Total \n\"&E49&\" to \n\"&I49&\"\"","v":"Total \n2021-22 to \n2025-26"},"Annual Average","Average annual impact on total bill (%)"]
[null,"Distribution charges bill component ($, nominal)",null,{"$f":"D22*$D$30","v":336.55799999999999},{"$f":"D50*(1+E$42)","v":344.73331613008793},{"$f":"E50*(1+F$42)","v":352.91834917406175},{"$f":"F50*(1+G$42)","v":361.29772016797034},{"$f":"G50*(1+H$42)","v":369.87604329462545},{"$f":"H50*(1+I$42)","v":378.65804229178178},null,{"$f":"+AVERAGE(E50:I50)","v":361.49669421170546}]
[null,"Annual change ($, nominal)",null,null,{"$f":"+E50-D50","v":8.1753161300879356},{"$f":"+F50-E50","v":8.1850330439738173},{"$f":"+G50-F50","v":8.3793709939085943},{"$f":"+H50-G50","v":8.578323126655107},{"$f":"+I50-H50","v":8.7819989971563359},{"$f":"+SUM(E51:I51)","v":42.10004229178179},{"$f":"+AVERAGE(E51:I51)","v":8.4200084583563584},{"$f":"K51/D22","v":5.8466466557587334E-3}]
[null,"Distribution charges bill component ($, real June 2021)",null,{"$f":"D22*$D$30","v":336.55799999999999},{"$f":"D52*(1+E$45)","v":336.73811386733513},{"$f":"E52*(1+F$45)","v":336.73811386733513},{"$f":"F52*(1+G$45)","v":336.73811386733513},{"$f":"G52*(1+H$45)","v":336.73811386733513},{"$f":"H52*(1+I$45)","v":336.73811386733513},null,{"$f":"+AVERAGE(E52:I52)","v":336.73811386733513}]
[null,"Annual change ($, real June 2021)",null,null,{"$f":"+E52-D52","v":0.18011386733513746},{"$f":"+F52-E52","v":0},{"$f":"+G52-F52","v":0},{"$f":"+H52-G52","v":0},{"$f":"+I52-H52","v":0},{"$f":"+SUM(E53:I53)","v":0.18011386733513746},{"$f":"+AVERAGE(E53:I53)","v":3.6022773467027494E-2},{"$f":"K53/D22","v":2.5013327369419729E-5}]
[]
[null,"Small Business customer"]
[null,null,null,"2020-21","2021-22","2022-23","2023-24","2024-25","2025-26",{"$f":"\"Total \n\"&E56&\" to \n\"&I56&\"\"","v":"Total \n2021-22 to \n2025-26"},"Annual Average","Average annual impact on total bill (%)"]
[null,"Distribution charges bill component ($, nominal)",null,{"$f":"D23*$D$31","v":3042.7935999999995},{"$f":"D57*(1+E$42)","v":3116.7059705233814},{"$f":"E57*(1+F$42)","v":3190.7061908776504},{"$f":"F57*(1+G$42)","v":3266.463404886204},{"$f":"G57*(1+H$42)","v":3344.0193290018638},{"$f":"H57*(1+I$42)","v":3423.4166701548111},null,{"$f":"+AVERAGE(E57:I57)","v":3268.2623130887819}]
[null,"Annual change ($, nominal)",null,null,{"$f":"+E57-D57","v":73.912370523381924},{"$f":"+F57-E57","v":74.000220354269004},{"$f":"+G57-F57","v":75.757214008553547},{"$f":"+H57-G57","v":77.555924115659764},{"$f":"+I57-H57","v":79.39734115294732},{"$f":"+SUM(E58:I58)","v":380.62307015481156},{"$f":"+AVERAGE(E58:I58)","v":76.124614030962306},{"$f":"K58/D23","v":6.4129771936362089E-3}]
[null,"Distribution charges bill component ($, real June 2021)",null,{"$f":"D23*$D$31","v":3042.7935999999995},{"$f":"D59*(1+E$45)","v":3044.4219948763616},{"$f":"E59*(1+F$45)","v":3044.4219948763616},{"$f":"F59*(1+G$45)","v":3044.4219948763616},{"$f":"G59*(1+H$45)","v":3044.4219948763616},{"$f":"H59*(1+I$45)","v":3044.4219948763616},null,{"$f":"+AVERAGE(E59:I59)","v":3044.4219948763616}]
[null,"Annual change ($, real June 2021)",null,null,{"$f":"+E59-D59","v":1.6283948763621083},{"$f":"+F59-E59","v":0},{"$f":"+G59-F59","v":0},{"$f":"+H59-G59","v":0},{"$f":"+I59-H59","v":0},{"$f":"+SUM(E60:I60)","v":1.6283948763621083},{"$f":"+AVERAGE(E60:I60)","v":0.32567897527242168},{"$f":"K60/D23","v":2.7436222402643149E-5}]

{"sheet":"Calc|Network Bill Impacts","index":4,"n_rows":60,"n_cols":8,"rows_kept":60,"cut":false,"hidden":false,"merged":[]}
[]
[null,{"$f":"HYPERLINK(\"#'\"&RIGHT(CELL(\"filename\",Home!A1),LEN(CELL(\"filename\",Home!A1))-FIND(\"]\",CELL(\"filename\",Home!A1)))&\"'!A1\",\"Click to go to \"\"\"&RIGHT(CELL(\"filename\",Home!A1),LEN(CELL(\"filename\",Home!A1))-FIND(\"]\",CELL(\"filename\",Home!A1)))&\"\"\"\")","v":"Click to go to \"Home\""}]
[null,{"$f":"ModelName","v":"Evoenergy revised proposal gas network | customer impacts model"}]
[null,{"$f":"HYPERLINK(\"#'\"&RIGHT(CELL(\"filename\",A3),LEN(CELL(\"filename\",A3))-FIND(\"]\",CELL(\"filename\",A3)))&\"'!A1\",RIGHT(CELL(\"filename\",A3),LEN(CELL(\"filename\",A3))-FIND(\"]\",CELL(\"filename\",A3))))","v":"Calc|Network Bill Impacts"}]
[]
[null,"Typical customer bill","FY21","FY22","FY23","FY24","FY25","FY26"]
[null,"Residential",{"$f":"H21","v":336.55799999999999},{"$f":"H24","v":346.36799999999994},{"$f":"H27","v":354.59184548496989},{"$f":"H30","v":363.01095044702959},{"$f":"H33","v":371.62995094889021},{"$f":"H36","v":380.45359312770177}]
[null,"% change (nominal)",null,{"$f":"D7/C7-1","v":2.9148022034834797E-2},{"$f":"E7/D7-1","v":2.3743086789108636E-2},{"$f":"F7/E7-1","v":2.3743086789108192E-2},{"$f":"G7/F7-1","v":2.3743086789108636E-2},{"$f":"H7/G7-1","v":2.3743086789108192E-2}]
[null,"% change (real)",null,{"$f":"(1+D8)/(1+'Data|PTRM Revenues'!E$8)-1","v":5.2795816796951112E-3},{"$f":"(1+E8)/(1+'Data|PTRM Revenues'!F$8)-1","v":0},{"$f":"(1+F8)/(1+'Data|PTRM Revenues'!G$8)-1","v":0},{"$f":"(1+G8)/(1+'Data|PTRM Revenues'!H$8)-1","v":0},{"$f":"(1+H8)/(1+'Data|PTRM Revenues'!I$8)-1","v":0}]
[null,"Small business",{"$f":"$H$45","v":3042.7936},{"$f":"$H$48","v":3118.1827999999996},{"$f":"$H$51","v":3192.2180848447051},{"$f":"$H$54","v":3268.0111958829339},{"$f":"$H$57","v":3345.6038693345608},{"$f":"$H$60","v":3425.0388323661482}]
[null,"% change (nominal)",null,{"$f":"D10/C10-1","v":2.4776310821739367E-2},{"$f":"E10/D10-1","v":2.3743086789108636E-2},{"$f":"F10/E10-1","v":2.3743086789108192E-2},{"$f":"G10/F10-1","v":2.3743086789108636E-2},{"$f":"H10/G10-1","v":2.3743086789108414E-2}]
[null,"% change (real)",null,{"$f":"(1+D11)/(1+'Data|PTRM Revenues'!E$8)-1","v":1.0092610596976748E-3},{"$f":"(1+E11)/(1+'Data|PTRM Revenues'!F$8)-1","v":0},{"$f":"(1+F11)/(1+'Data|PTRM Revenues'!G$8)-1","v":0},{"$f":"(1+G11)/(1+'Data|PTRM Revenues'!H$8)-1","v":0},{"$f":"(1+H11)/(1+'Data|PTRM Revenues'!I$8)-1","v":0}]
[]
[null,"Typical residential customer consumption GJ p.a.",{"$f":"'Data|Typical customer'!D8","v":28},{"$f":"C14=H18","v":true}]
[]
[null,"Item","Fixed charge","Block 1","Block 2","Block 3","Block 4","Total Bill"]
[null,"Blocks",null,{"$f":"'Data|Network tariffs'!$E$8","v":15},{"$f":"'Data|Network tariffs'!$F$8","v":176.4},{"$f":"'Data|Network tariffs'!$G$8","v":720},{"$f":"'Data|Network tariffs'!$H$8","v":"∞"}]
[null,"Volume",1,{"$f":"MIN($C$14,$D$17)","v":15},{"$f":"MIN($C$14-$D$18,$E$17-$D$17)","v":13},{"$f":"MIN($C$14-$E$18-$D$18,$F$17-$E$17)","v":0},{"$f":"MAX($C$14-$F$18-$E$18-$D$18,0)","v":0},{"$f":"SUM(D18:G18)","v":28}]
[null,"FY21"]
[null,"Tariffs",{"$f":"'Data|Network tariffs'!D10","v":71.22},{"$f":"'Data|Network tariffs'!E10","v":12.016},{"$f":"'Data|Network tariffs'!F10","v":6.5460000000000003},{"$f":"'Data|Network tariffs'!G10","v":5.9329999999999998},{"$f":"'Data|Network tariffs'!H10","v":5.7220000000000004}]
[null,"Charges",{"$f":"C$18*C20","v":71.22},{"$f":"D$18*D20","v":180.24},{"$f":"E$18*E20","v":85.097999999999999},{"$f":"F$18*F20","v":0},{"$f":"G$18*G20","v":0},{"$f":"SUM(C21:G21)","v":336.55799999999999}]
[null,"FY22"]
[null,"Tariffs",{"$f":"'Data|Network tariffs'!D11","v":73.66},{"$f":"'Data|Network tariffs'!E11","v":12.36},{"$f":"'Data|Network tariffs'!F11","v":6.7160000000000002},{"$f":"'Data|Network tariffs'!G11","v":6.0709999999999997},{"$f":"'Data|Network tariffs'!H11","v":5.8620000000000001}]
[null,"Charges",{"$f":"C$18*C23","v":73.66},{"$f":"D$18*D23","v":185.39999999999998},{"$f":"E$18*E23","v":87.308000000000007},{"$f":"F$18*F23","v":0},{"$f":"G$18*G23","v":0},{"$f":"SUM(C24:G24)","v":346.36799999999994}]
[null,"FY23"]
[null,"Tariffs",{"$f":"'Data|Network tariffs'!D12","v":75.40891577288572},{"$f":"'Data|Network tariffs'!E12","v":12.653464552713379},{"$f":"'Data|Network tariffs'!F12","v":6.8754585708756526},{"$f":"'Data|Network tariffs'!G12","v":6.2151442798966769},{"$f":"'Data|Network tariffs'!H12","v":6.0011819747577535}]
[null,"Charges",{"$f":"C$18*C26","v":75.40891577288572},{"$f":"D$18*D26","v":189.80196829070067},{"$f":"E$18*E26","v":89.380961421383489},{"$f":"F$18*F26","v":0},{"$f":"G$18*G26","v":0},{"$f":"SUM(C27:G27)","v":354.59184548496989}]
[null,"FY24"]
[null,"Tariffs",{"$f":"'Data|Network tariffs'!D13","v":77.199356204753911},{"$f":"'Data|Network tariffs'!E13","v":12.953896859771358},{"$f":"'Data|Network tariffs'!F13","v":7.0387031804388727},{"$f":"'Data|Network tariffs'!G13","v":6.3627109899410943},{"$f":"'Data|Network tariffs'!H13","v":6.14366855922166}]
[null,"Charges",{"$f":"C$18*C29","v":77.199356204753911},{"$f":"D$18*D29","v":194.30845289657037},{"$f":"E$18*E29","v":91.503141345705345},{"$f":"F$18*F29","v":0},{"$f":"G$18*G29","v":0},{"$f":"SUM(C30:G30)","v":363.01095044702959}]
[null,"FY25"]
[null,"Tariffs",{"$f":"'Data|Network tariffs'!D14","v":79.032307219186677},{"$f":"'Data|Network tariffs'!E14","v":13.261462357170069},{"$f":"'Data|Network tariffs'!F14","v":7.2058237209348066},{"$f":"'Data|Network tariffs'!G14","v":6.5137813891892797},{"$f":"'Data|Network tariffs'!H14","v":6.2895382150267762}]
[null,"Charges",{"$f":"C$18*C32","v":79.032307219186677},{"$f":"D$18*D32","v":198.92193535755104},{"$f":"E$18*E32","v":93.675708372152485},{"$f":"F$18*F32","v":0},{"$f":"G$18*G32","v":0},{"$f":"SUM(C33:G33)","v":371.62995094889021}]
[null,"FY26"]
[null,"Tariffs",{"$f":"'Data|Network tariffs'!D15","v":80.908778148635307},{"$f":"'Data|Network tariffs'!E15","v":13.576330408866852},{"$f":"'Data|Network tariffs'!F15","v":7.3769122189279779},{"$f":"'Data|Network tariffs'!G15","v":6.6684386660380799},{"$f":"'Data|Network tariffs'!H15","v":6.4388712667295707}]
[null,"Charges",{"$f":"C$18*C35","v":80.908778148635307},{"$f":"D$18*D35","v":203.64495613300278},{"$f":"E$18*E35","v":95.899858846063708},{"$f":"F$18*F35","v":0},{"$f":"G$18*G35","v":0},{"$f":"SUM(C36:G36)","v":380.45359312770177}]
[]
[null,"Typical small business customer consumption GJ p.a.",{"$f":"'Data|Typical customer'!D14","v":468.8},{"$f":"C38=H42","v":true}]
[]
[null,"Item","Fixed charge","Block 1","Block 2","Block 3","Block 4","Total Bill"]
[null,"Blocks",null,{"$f":"'Data|Network tariffs'!$E$8","v":15},{"$f":"'Data|Network tariffs'!$F$8","v":176.4},{"$f":"'Data|Network tariffs'!$G$8","v":720},{"$f":"'Data|Network tariffs'!$H$8","v":"∞"}]
[null,"Volume",1,{"$f":"MIN($C$38,$D$41)","v":15},{"$f":"MIN($C$38-$D$42,$E$41-$D$41)","v":161.4},{"$f":"MIN($C$38-$E$42-$D$42,$F$41-$E$41)","v":292.39999999999998},{"$f":"MAX($C$38-$F$42-$E$42-$D$42,0)","v":2.8421709430404007E-14},{"$f":"SUM(D42:G42)","v":468.79999999999995}]
[null,"FY21"]
[null,"Tariffs",{"$f":"'Data|Network tariffs'!$D$21","v":71.22},{"$f":"'Data|Network tariffs'!$E$21","v":12.016},{"$f":"'Data|Network tariffs'!$F$21","v":6.5460000000000003},{"$f":"'Data|Network tariffs'!$G$21","v":5.9329999999999998},{"$f":"'Data|Network tariffs'!$H$21","v":5.7220000000000004}]
[null,"Charges",{"$f":"C$42*C44","v":71.22},{"$f":"D$42*D44","v":180.24},{"$f":"E$42*E44","v":1056.5244},{"$f":"F$42*F44","v":1734.8091999999999},{"$f":"G$42*G44","v":1.6262902136077174E-13},{"$f":"SUM(C45:G45)","v":3042.7936}]
[null,"FY22"]
[null,"Tariffs",{"$f":"'Data|Network tariffs'!$D$22","v":73.66},{"$f":"'Data|Network tariffs'!$E$22","v":12.36},{"$f":"'Data|Network tariffs'!$F$22","v":6.7160000000000002},{"$f":"'Data|Network tariffs'!$G$22","v":6.0709999999999997},{"$f":"'Data|Network tariffs'!$H$22","v":5.8620000000000001}]
[null,"Charges",{"$f":"C$42*C47","v":73.66},{"$f":"D$42*D47","v":185.39999999999998},{"$f":"E$42*E47","v":1083.9624000000001},{"$f":"F$42*F47","v":1775.1603999999998},{"$f":"G$42*G47","v":1.6660806068102829E-13},{"$f":"SUM(C48:G48)","v":3118.1827999999996}]
[null,"FY23"]
[null,"Tariffs",{"$f":"'Data|Network tariffs'!$D$23","v":75.40891577288572},{"$f":"'Data|Network tariffs'!$E$23","v":12.653464552713379},{"$f":"'Data|Network tariffs'!$F$23","v":6.8754585708756526},{"$f":"'Data|Network tariffs'!$G$23","v":6.2151442798966769},{"$f":"'Data|Network tariffs'!$H$23","v":6.0011819747577535}]
[null,"Charges",{"$f":"C$42*C50","v":75.40891577288572},{"$f":"D$42*D50","v":189.80196829070067},{"$f":"E$42*E50","v":1109.6990133393303},{"$f":"F$42*F50","v":1817.3081874417883},{"$f":"G$42*G50","v":1.7056385032554299E-13},{"$f":"SUM(C51:G51)","v":3192.2180848447051}]
[null,"FY24"]
[null,"Tariffs",{"$f":"'Data|Network tariffs'!$D$24","v":77.199356204753911},{"$f":"'Data|Network tariffs'!$E$24","v":12.953896859771358},{"$f":"'Data|Network tariffs'!$F$24","v":7.0387031804388727},{"$f":"'Data|Network tariffs'!$G$24","v":6.3627109899410943},{"$f":"'Data|Network tariffs'!$H$24","v":6.14366855922166}]
[null,"Charges",{"$f":"C$42*C53","v":77.199356204753911},{"$f":"D$42*D53","v":194.30845289657037},{"$f":"E$42*E53","v":1136.046693322834},{"$f":"F$42*F53","v":1860.4566934587758},{"$f":"G$42*G53","v":1.7461356262690686E-13},{"$f":"SUM(C54:G54)","v":3268.0111958829339}]
[null,"FY25"]
[null,"Tariffs",{"$f":"'Data|Network tariffs'!$D$25","v":79.032307219186677},{"$f":"'Data|Network tariffs'!$E$25","v":13.261462357170069},{"$f":"'Data|Network tariffs'!$F$25","v":7.2058237209348066},{"$f":"'Data|Network tariffs'!$G$25","v":6.5137813891892797},{"$f":"'Data|Network tariffs'!$H$25","v":6.2895382150267762}]
[null,"Charges",{"$f":"C$42*C56","v":79.032307219186677},{"$f":"D$42*D56","v":198.92193535755104},{"$f":"E$42*E56","v":1163.0199485588778},{"$f":"F$42*F56","v":1904.6296781989452},{"$f":"G$42*G56","v":1.7875942759891291E-13},{"$f":"SUM(C57:G57)","v":3345.6038693345608}]
[null,"FY26"]
[null,"Tariffs",{"$f":"'Data|Network tariffs'!$D$26","v":80.908778148635307},{"$f":"'Data|Network tariffs'!$E$26","v":13.576330408866852},{"$f":"'Data|Network tariffs'!$F$26","v":7.3769122189279779},{"$f":"'Data|Network tariffs'!$G$26","v":6.6684386660380799},{"$f":"'Data|Network tariffs'!$H$26","v":6.4388712667295707}]
[null,"Charges",{"$f":"C$42*C59","v":80.908778148635307},{"$f":"D$42*D59","v":203.64495613300278},{"$f":"E$42*E59","v":1190.6336321349756},{"$f":"F$42*F59","v":1949.8514659495345},{"$f":"G$42*G59","v":1.8300372820276524E-13},{"$f":"SUM(C60:G60)","v":3425.0388323661482}]

{"sheet":"Calc|Retail Bill Impacts","index":5,"n_rows":70,"n_cols":9,"rows_kept":70,"cut":false,"hidden":false,"merged":[]}
[]
[null,{"$f":"HYPERLINK(\"#'\"&RIGHT(CELL(\"filename\",Home!A1),LEN(CELL(\"filename\",Home!A1))-FIND(\"]\",CELL(\"filename\",Home!A1)))&\"'!A1\",\"Click to go to \"\"\"&RIGHT(CELL(\"filename\",Home!A1),LEN(CELL(\"filename\",Home!A1))-FIND(\"]\",CELL(\"filename\",Home!A1)))&\"\"\"\")","v":"Click to go to \"Home\""}]
[null,{"$f":"ModelName","v":"Evoenergy revised proposal gas network | customer impacts model"}]
[null,{"$f":"HYPERLINK(\"#'\"&RIGHT(CELL(\"filename\",A3),LEN(CELL(\"filename\",A3))-FIND(\"]\",CELL(\"filename\",A3)))&\"'!A1\",RIGHT(CELL(\"filename\",A3),LEN(CELL(\"filename\",A3))-FIND(\"]\",CELL(\"filename\",A3))))","v":"Calc|Retail Bill Impacts"}]
[]
[null,"Typical customer bill","FY21","FY22","FY23","FY24","FY25","FY26"]
[null,"Residential (minimum of retail offers)",{"$f":"AVERAGE(H31,H36,H41,H46)","v":1440.1432058602272},{"$f":"SUM(D8:D10)","v":1487.5596442711576},{"$f":"SUM(E8:E10)","v":1546.6541187743269},{"$f":"SUM(F8:F10)","v":1615.6691202842799},{"$f":"SUM(G8:G10)","v":1673.5166087174957},{"$f":"SUM(H8:H10)","v":1721.3966043410219}]
[null,"Assumed wholesale component",{"$f":"C7*'Data|Typical customer'!$D$12","v":727.29313011070872},{"$f":"C8*(1+'Data|Wholesale forecast'!G$12)","v":755.9652331090648},{"$f":"D8*(1+'Data|Wholesale forecast'!H$12)","v":797.68939801358567},{"$f":"E8*(1+'Data|Wholesale forecast'!I$12)","v":848.92166515653605},{"$f":"F8*(1+'Data|Wholesale forecast'!J$12)","v":888.56420221732571},{"$f":"G8*(1+'Data|Wholesale forecast'!K$12)","v":917.80700472799901}]
[null,"Evo distribution component",{"$f":"'Calc|Network Bill Impacts'!C7","v":336.55799999999999},{"$f":"'Calc|Network Bill Impacts'!D7","v":346.36799999999994},{"$f":"'Calc|Network Bill Impacts'!E7","v":354.59184548496989},{"$f":"'Calc|Network Bill Impacts'!F7","v":363.01095044702959},{"$f":"'Calc|Network Bill Impacts'!G7","v":371.62995094889021},{"$f":"'Calc|Network Bill Impacts'!H7","v":380.45359312770177}]
[null,"Residual (zero real growth assumed)",{"$f":"C7-C8-C9","v":376.29207574951852},{"$f":"C10*(1+'Data|PTRM Revenues'!E$8)","v":385.22641116209309},{"$f":"D10*(1+'Data|PTRM Revenues'!F$8)","v":394.37287527577143},{"$f":"E10*(1+'Data|PTRM Revenues'!G$8)","v":403.73650468071429},{"$f":"F10*(1+'Data|PTRM Revenues'!H$8)","v":413.32245555127975},{"$f":"G10*(1+'Data|PTRM Revenues'!I$8)","v":423.13600648532116}]
[null,"% change (nominal)",null,{"$f":"D7/C7-1","v":3.2924807906591136E-2},{"$f":"E7/D7-1","v":3.9725784932894692E-2},{"$f":"F7/E7-1","v":4.4622130230801194E-2},{"$f":"G7/F7-1","v":3.5804044099720933E-2},{"$f":"H7/G7-1","v":2.8610409585489105E-2}]
[null,"% change (real)",null,{"$f":"(1+D11)/(1+'Data|PTRM Revenues'!E$8)-1","v":8.9687747208926361E-3},{"$f":"(1+E11)/(1+'Data|PTRM Revenues'!F$8)-1","v":1.5612020584104602E-2},{"$f":"(1+F11)/(1+'Data|PTRM Revenues'!G$8)-1","v":2.039480775120861E-2},{"$f":"(1+G11)/(1+'Data|PTRM Revenues'!H$8)-1","v":1.1781234438848154E-2},{"$f":"(1+H11)/(1+'Data|PTRM Revenues'!I$8)-1","v":4.7544377678256922E-3}]
[null,"% contribution from Evo (nominal)",null,{"$f":"(D9-C9)/C7","v":6.8118225743669918E-3},{"$f":"(E9-D9)/D7","v":5.5284139473945589E-3},{"$f":"(F9-E9)/E7","v":5.4434309907192167E-3},{"$f":"(G9-F9)/F7","v":5.3346321927252634E-3},{"$f":"(H9-G9)/G7","v":5.2725154521015343E-3}]
[null,"% contribution from Evo (real)",null,{"$f":"(1+D13)/(1+'Data|PTRM Revenues'!E$8)-1","v":-1.6538587105721092E-2},{"$f":"(1+E13)/(1+'Data|PTRM Revenues'!F$8)-1","v":-1.7792230371823869E-2},{"$f":"(1+F13)/(1+'Data|PTRM Revenues'!G$8)-1","v":-1.7875242367481725E-2},{"$f":"(1+G13)/(1+'Data|PTRM Revenues'!H$8)-1","v":-1.7981517857297513E-2},{"$f":"(1+H13)/(1+'Data|PTRM Revenues'!I$8)-1","v":-1.804219395994977E-2}]
[null,"Small business (minimum of retail offers)",{"$f":"AVERAGE(H55,H60,H65,H70)","v":11870.401489421023},{"$f":"SUM(D16:D18)","v":12249.382319973163},{"$f":"SUM(E16:E18)","v":12736.188040284855},{"$f":"SUM(F16:F18)","v":13304.757169732909},{"$f":"SUM(G16:G18)","v":13781.271070132037},{"$f":"SUM(H16:H18)","v":14175.620763754165}]
[null,"Assumed wholesale component",{"$f":"C15*'Data|Typical customer'!$D$18","v":5994.724288377286},{"$f":"C16*(1+'Data|Wholesale forecast'!G$12)","v":6231.054517726403},{"$f":"D16*(1+'Data|Wholesale forecast'!H$12)","v":6574.9665587040436},{"$f":"E16*(1+'Data|Wholesale forecast'!I$12)","v":6997.2492717880068},{"$f":"F16*(1+'Data|Wholesale forecast'!J$12)","v":7324.0034647432431},{"$f":"G16*(1+'Data|Wholesale forecast'!K$12)","v":7565.0376931901264}]
[null,"Evo distribution component",{"$f":"'Calc|Network Bill Impacts'!C10","v":3042.7936},{"$f":"'Calc|Network Bill Impacts'!D10","v":3118.1827999999996},{"$f":"'Calc|Network Bill Impacts'!E10","v":3192.2180848447051},{"$f":"'Calc|Network Bill Impacts'!F10","v":3268.0111958829339},{"$f":"'Calc|Network Bill Impacts'!G10","v":3345.6038693345608},{"$f":"'Calc|Network Bill Impacts'!H10","v":3425.0388323661482}]
[null,"Residual (zero real growth assumed)",{"$f":"C15-C16-C17","v":2832.8836010437371},{"$f":"C18*(1+'Data|PTRM Revenues'!E$8)","v":2900.1450022467607},{"$f":"D18*(1+'Data|PTRM Revenues'!F$8)","v":2969.0033967361046},{"$f":"E18*(1+'Data|PTRM Revenues'!G$8)","v":3039.4967020619674},{"$f":"F18*(1+'Data|PTRM Revenues'!H$8)","v":3111.6637360542336},{"$f":"G18*(1+'Data|PTRM Revenues'!I$8)","v":3185.5442381978905}]
[null,"% change (nominal)",null,{"$f":"D15/C15-1","v":3.1926538532828008E-2},{"$f":"E15/D15-1","v":3.9741246341697734E-2},{"$f":"F15/E15-1","v":4.46420175055251E-2},{"$f":"G15/F15-1","v":3.5815302325333143E-2},{"$f":"H15/G15-1","v":2.8614900005616839E-2}]
[null,"% change (real)",null,{"$f":"(1+D19)/(1+'Data|PTRM Revenues'!E$8)-1","v":7.9936576366892442E-3},{"$f":"(1+E19)/(1+'Data|PTRM Revenues'!F$8)-1","v":1.5627123405312915E-2},{"$f":"(1+F19)/(1+'Data|PTRM Revenues'!G$8)-1","v":2.0414233791765657E-2},{"$f":"(1+G19)/(1+'Data|PTRM Revenues'!H$8)-1","v":1.1792231558884758E-2},{"$f":"(1+H19)/(1+'Data|PTRM Revenues'!I$8)-1","v":4.7588240442126839E-3}]
[null,"% contribution from Evo (nominal)",null,{"$f":"(D17-C17)/C15","v":6.3510235999335784E-3},{"$f":"(E17-D17)/D15","v":6.044001477853108E-3},{"$f":"(F17-E17)/E15","v":5.9510043977439248E-3},{"$f":"(G17-F17)/F15","v":5.8319496148447657E-3},{"$f":"(H17-G17)/G15","v":5.7639794346506746E-3}]
[null,"% contribution from Evo (real)",null,{"$f":"(1+D21)/(1+'Data|PTRM Revenues'!E$8)-1","v":-1.6988699033586352E-2},{"$f":"(1+E21)/(1+'Data|PTRM Revenues'!F$8)-1","v":-1.7288600567518464E-2},{"$f":"(1+F21)/(1+'Data|PTRM Revenues'!G$8)-1","v":-1.7379440819637604E-2},{"$f":"(1+G21)/(1+'Data|PTRM Revenues'!H$8)-1","v":-1.7495734433177645E-2},{"$f":"(1+H21)/(1+'Data|PTRM Revenues'!I$8)-1","v":-1.7562128219930528E-2}]
[]
[null,"Typical residential customer consumption GJ p.a.",{"$f":"'Data|Typical customer'!D8","v":28}]
[]
[null,"Item","Fixed charge","Block 1","Block 2","Block 3","Block 4","Total Bill"]
[null,"FY21 - Energy Australia",null,null,null,null,null,null,{"$f":"$C$24=H29","v":true}]
[null,"Blocks",null,{"$f":"'Data|Retail tariffs'!$E$9","v":3.7500099999999996},{"$f":"'Data|Retail tariffs'!$F$9","v":246.75003749999999},{"$f":"'Data|Retail tariffs'!$G$9","v":1000.4999487499999},{"$f":"'Data|Retail tariffs'!$H$9","v":"∞"}]
[null,"Volume",1,{"$f":"MIN($C$24,$D28)","v":3.7500099999999996},{"$f":"MIN($C$24-$D29,$E28-$D28)","v":24.24999},{"$f":"MIN($C$24-$E29-$D29,$F28-$E28)","v":0},{"$f":"MAX($C$24-$F29-$E29-$D29,0)","v":0},{"$f":"SUM(D29:G29)","v":28}]
[null,"Tariffs",{"$f":"'Data|Retail tariffs'!$D$10","v":579.6},{"$f":"'Data|Retail tariffs'!$E$10","v":28.941818181818185},{"$f":"'Data|Retail tariffs'!$F$10","v":25.2},{"$f":"'Data|Retail tariffs'!$G$10","v":24.436363636363634},{"$f":"'Data|Retail tariffs'!$H$10","v":23.061818181818179}]
[null,"Charges",{"$f":"C29*C30","v":579.6},{"$f":"D29*D30","v":108.5321076},{"$f":"E29*E30","v":611.09974799999998},{"$f":"F29*F30","v":0},{"$f":"G29*G30","v":0},{"$f":"SUM(C31:G31)","v":1299.2318556}]
[null,"FY21 - Origin Energy",null,null,null,null,null,null,{"$f":"$C$24=H34","v":true}]
[null,"Blocks",null,{"$f":"'Data|Retail tariffs'!$E$12","v":3.750000875},{"$f":"'Data|Retail tariffs'!$F$12","v":40.350001750000004},{"$f":"'Data|Retail tariffs'!$G$12","v":135.90000287500001},{"$f":"'Data|Retail tariffs'!$H$12","v":"∞"}]
[null,"Volume",1,{"$f":"MIN($C$24,$D33)","v":3.750000875},{"$f":"MIN($C$24-$D34,$E33-$D33)","v":24.249999124999999},{"$f":"MIN($C$24-$E34-$D34,$F33-$E33)","v":1.3322676295501878E-15},{"$f":"MAX($C$24-$F34-$E34-$D34,0)","v":1.3322676295501878E-15},{"$f":"SUM(D34:G34)","v":28}]
[null,"Tariffs",{"$f":"'Data|Retail tariffs'!$D$13","v":620.90909090909088},{"$f":"'Data|Retail tariffs'!$E$13","v":29.454545454545453},{"$f":"'Data|Retail tariffs'!$F$13","v":24.545454545454547},{"$f":"'Data|Retail tariffs'!$G$13","v":22.90909090909091},{"$f":"'Data|Retail tariffs'!$H$13","v":21.636363636363637}]
[null,"Charges",{"$f":"C34*C35","v":620.90909090909088},{"$f":"D34*D35","v":110.45457122727272},{"$f":"E34*E35","v":595.22725124999999},{"$f":"F34*F35","v":3.0521040240604306E-14},{"$f":"G34*G35","v":2.8825426893904063E-14},{"$f":"SUM(C36:G36)","v":1326.5909133863636}]
[null,"FY21 - Red Energy",null,null,null,null,null,null,{"$f":"$C$24=H39","v":true}]
[null,"Blocks",null,{"$f":"'Data|Retail tariffs'!$E$15","v":3.7500099999999996},{"$f":"'Data|Retail tariffs'!$F$15","v":40.350020000000001},{"$f":"'Data|Retail tariffs'!$G$15","v":135.90000287500001},{"$f":"'Data|Retail tariffs'!$H$15","v":"∞"}]
[null,"Volume",1,{"$f":"MIN($C$24,$D38)","v":3.7500099999999996},{"$f":"MIN($C$24-$D39,$E38-$D38)","v":24.24999},{"$f":"MIN($C$24-$E39-$D39,$F38-$E38)","v":0},{"$f":"MAX($C$24-$F39-$E39-$D39,0)","v":0},{"$f":"SUM(D39:G39)","v":28}]
[null,"Tariffs",{"$f":"'Data|Retail tariffs'!$D$16","v":779.81818181818187},{"$f":"'Data|Retail tariffs'!$E$16","v":28.90909090909091},{"$f":"'Data|Retail tariffs'!$F$16","v":23.90909090909091},{"$f":"'Data|Retail tariffs'!$G$16","v":21.818181818181817},{"$f":"'Data|Retail tariffs'!$H$16","v":19.818181818181817}]
[null,"Charges",{"$f":"C39*C40","v":779.81818181818187},{"$f":"D39*D40","v":108.40938},{"$f":"E39*E40","v":579.79521545454554},{"$f":"F39*F40","v":0},{"$f":"G39*G40","v":0},{"$f":"SUM(C41:G41)","v":1468.0227772727274}]
[null,"FY21 - ActewAGL",null,null,null,null,null,null,{"$f":"$C$24=H44","v":true}]
[null,"Blocks",null,{"$f":"'Data|Retail tariffs'!$E$18","v":3.750000875},{"$f":"'Data|Retail tariffs'!$F$18","v":40.350001750000004},{"$f":"'Data|Retail tariffs'!$G$18","v":135.90000287500001},{"$f":"'Data|Retail tariffs'!$H$18","v":"∞"}]
[null,"Volume",1,{"$f":"MIN($C$24,$D43)","v":3.750000875},{"$f":"MIN($C$24-$D44,$E43-$D43)","v":24.249999124999999},{"$f":"MIN($C$24-$E44-$D44,$F43-$E43)","v":1.3322676295501878E-15},{"$f":"MAX($C$24-$F44-$E44-$D44,0)","v":1.3322676295501878E-15},{"$f":"SUM(D44:G44)","v":28}]
[null,"Tariffs",{"$f":"'Data|Retail tariffs'!$D$19","v":787.27272727272725},{"$f":"'Data|Retail tariffs'!$E$19","v":35.81818181818182},{"$f":"'Data|Retail tariffs'!$F$19","v":30.727272727272727},{"$f":"'Data|Retail tariffs'!$G$19","v":28.181818181818183},{"$f":"'Data|Retail tariffs'!$H$19","v":26.272727272727273}]
[null,"Charges",{"$f":"C44*C45","v":787.27272727272725},{"$f":"D44*D45","v":134.31821315909093},{"$f":"E44*E45","v":745.13633674999994},{"$f":"F44*F45","v":3.7545724105505294E-14},{"$f":"G44*G45","v":3.5002304085454933E-14},{"$f":"SUM(C46:G46)","v":1666.727277181818}]
[]
[null,"Typical small business customer consumption GJ p.a.",{"$f":"'Data|Typical customer'!D14","v":468.8}]
[]
[null,"Item","Fixed charge","Block 1","Block 2","Block 3","Block 4","Total Bill"]
[null,"FY21 - Energy Australia",null,null,null,null,null,null,{"$f":"$C$48=H53","v":true}]
[null,"Blocks",null,{"$f":"'Data|Retail tariffs'!$E$24","v":3.7500099999999996},{"$f":"'Data|Retail tariffs'!$F$24","v":246.75003749999999},{"$f":"'Data|Retail tariffs'!$G$24","v":1000.4999487499999},{"$f":"'Data|Retail tariffs'!$H$24","v":"∞"}]
[null,"Volume",1,{"$f":"MAX(MIN($C$48,$D52),0)","v":3.7500099999999996},{"$f":"MAX(MIN($C$48-$D53,$E52-$D52),0)","v":243.00002749999999},{"$f":"MAX(MIN($C$48-$E53-$D53,$F52-$E52),0)","v":222.04996250000002},{"$f":"MAX($C$48-$F53-$E53-$D53,0)","v":3.5527136788005009E-15},{"$f":"SUM(D53:G53)","v":468.8}]
[null,"Tariffs",{"$f":"'Data|Retail tariffs'!$D$25","v":1137.24},{"$f":"'Data|Retail tariffs'!$E$25","v":24.22636363636364},{"$f":"'Data|Retail tariffs'!$F$25","v":22.459090909090911},{"$f":"'Data|Retail tariffs'!$G$25","v":22.311818181818186},{"$f":"'Data|Retail tariffs'!$H$25","v":22.238181818181818}]
[null,"Charges",{"$f":"C53*C54","v":1137.24},{"$f":"D53*D54","v":90.849105899999998},{"$f":"E53*E54","v":5457.5597085340914},{"$f":"F53*F54","v":4954.3383905795472},{"$f":"G53*G54","v":7.900589273710714E-14},{"$f":"SUM(C55:G55)","v":11639.987205013638}]
[null,"FY21 - Origin Energy",null,null,null,null,null,null,{"$f":"$C$48=H58","v":true}]
[null,"Blocks",null,{"$f":"'Data|Retail tariffs'!$E$27","v":7.50000175},{"$f":"'Data|Retail tariffs'!$F$27","v":285.00000262499998},{"$f":"'Data|Retail tariffs'!$G$27","v":0},{"$f":"'Data|Retail tariffs'!$H$27","v":"∞"}]
[null,"Volume",1,{"$f":"MAX(MIN($C$48,$D57),0)","v":7.50000175},{"$f":"MAX(MIN($C$48-$D58,$E57-$D57),0)","v":277.50000087499996},{"$f":"MAX(MIN($C$48-$E58-$D58,$F57-$E57),0)","v":0},{"$f":"MAX($C$48-$F58-$E58-$D58,0)","v":183.79999737500006},{"$f":"SUM(D58:G58)","v":468.80000000000007}]
[null,"Tariffs",{"$f":"'Data|Retail tariffs'!$D$28","v":1472.7272727272727},{"$f":"'Data|Retail tariffs'!$E$28","v":23.877272727272725},{"$f":"'Data|Retail tariffs'!$F$28","v":21.559090909090909},{"$f":"'Data|Retail tariffs'!$G$28","v":0},{"$f":"'Data|Retail tariffs'!$H$28","v":21.095454545454544}]
[null,"Charges",{"$f":"C58*C59","v":1472.7272727272727},{"$f":"D58*D59","v":179.07958723977271},{"$f":"E58*E59","v":5982.6477461369304},{"$f":"F58*F59","v":0},{"$f":"G58*G59","v":3877.3444900789782},{"$f":"SUM(C60:G60)","v":11511.799096182955}]
[null,"FY21 - Red Energy",null,null,null,null,null,null,{"$f":"$C$48=H63","v":true}]
[null,"Blocks",null,{"$f":"'Data|Retail tariffs'!$E$30","v":7.5000199999999992},{"$f":"'Data|Retail tariffs'!$F$30","v":285.00000262499998},{"$f":"'Data|Retail tariffs'!$G$30","v":0},{"$f":"'Data|Retail tariffs'!$H$30","v":"∞"}]
[null,"Volume",1,{"$f":"MAX(MIN($C$48,$D62),0)","v":7.5000199999999992},{"$f":"MAX(MIN($C$48-$D63,$E62-$D62),0)","v":277.49998262499997},{"$f":"MAX(MIN($C$48-$E63-$D63,$F62-$E62),0)","v":0},{"$f":"MAX($C$48-$F63-$E63-$D63,0)","v":183.79999737500003},{"$f":"SUM(D63:G63)","v":468.8}]
[null,"Tariffs",{"$f":"'Data|Retail tariffs'!$D$31","v":999.81818181818198},{"$f":"'Data|Retail tariffs'!$E$31","v":28.90909090909091},{"$f":"'Data|Retail tariffs'!$F$31","v":23.90909090909091},{"$f":"'Data|Retail tariffs'!$G$31","v":0},{"$f":"'Data|Retail tariffs'!$H$31","v":21.818181818181817}]
[null,"Charges",{"$f":"C63*C64","v":999.81818181818198},{"$f":"D63*D64","v":216.81876},{"$f":"E63*E64","v":6634.7723118522727},{"$f":"F63*F64","v":0},{"$f":"G63*G64","v":4010.1817609090913},{"$f":"SUM(C65:G65)","v":11861.591014579546}]
[null,"FY21 - ActewAGL",null,null,null,null,null,null,{"$f":"$C$48=H68","v":true}]
[null,"Blocks",null,{"$f":"'Data|Retail tariffs'!$E$33","v":7.50000175},{"$f":"'Data|Retail tariffs'!$F$33","v":285.00000262499998},{"$f":"'Data|Retail tariffs'!$G$33","v":0},{"$f":"'Data|Retail tariffs'!$H$33","v":"∞"}]
[null,"Volume",1,{"$f":"MAX(MIN($C$48,$D67),0)","v":7.50000175},{"$f":"MAX(MIN($C$48-$D68,$E67-$D67),0)","v":277.50000087499996},{"$f":"MAX(MIN($C$48-$E68-$D68,$F67-$E67),0)","v":0},{"$f":"MAX($C$48-$F68-$E68-$D68,0)","v":183.79999737500006},{"$f":"SUM(D68:G68)","v":468.80000000000007}]
[null,"Tariffs",{"$f":"'Data|Retail tariffs'!$D$34","v":1661.1818181818182},{"$f":"'Data|Retail tariffs'!$E$34","v":25.5},{"$f":"'Data|Retail tariffs'!$F$34","v":23.259090909090908},{"$f":"'Data|Retail tariffs'!$G$34","v":0},{"$f":"'Data|Retail tariffs'!$H$34","v":22.640909090909091}]
[null,"Charges",{"$f":"C68*C69","v":1661.1818181818182},{"$f":"D68*D69","v":191.25004462499999},{"$f":"E68*E69","v":6454.3977476244308},{"$f":"F68*F69","v":0},{"$f":"G68*G69","v":4161.3990314767061},{"$f":"SUM(C70:G70)","v":12468.228641907954}]

{"sheet":"Data|Typical customer","index":6,"n_rows":18,"n_cols":4,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
[]
[null,{"$f":"HYPERLINK(\"#'\"&RIGHT(CELL(\"filename\",Home!A1),LEN(CELL(\"filename\",Home!A1))-FIND(\"]\",CELL(\"filename\",Home!A1)))&\"'!A1\",\"Click to go to \"\"\"&RIGHT(CELL(\"filename\",Home!A1),LEN(CELL(\"filename\",Home!A1))-FIND(\"]\",CELL(\"filename\",Home!A1)))&\"\"\"\")","v":"Click to go to \"Home\""}]
[null,{"$f":"ModelName","v":"Evoenergy revised proposal gas network | customer impacts model"}]
[null,{"$f":"HYPERLINK(\"#'\"&RIGHT(CELL(\"filename\",A3),LEN(CELL(\"filename\",A3))-FIND(\"]\",CELL(\"filename\",A3)))&\"'!A1\",RIGHT(CELL(\"filename\",A3),LEN(CELL(\"filename\",A3))-FIND(\"]\",CELL(\"filename\",A3))))","v":"Data|Typical customer"}]
[]
[null,"Customer type","Units","Value 2020-21"]
[null,"Residential"]
[null,"Typical usage","GJ p.a.",28]
[null,"Typical usage","MJ/day",{"$f":"D8*1000/365","v":76.712328767123282}]
[null,"Typical gas bill","$/year",{"$f":"'Calc|Retail Bill Impacts'!$C$7","v":1440.1432058602272}]
[null,"Distribution proportion","%",{"$f":"'Calc|Network Bill Impacts'!C7/D10","v":0.23369759245502739}]
[null,"Wholesale component","%",0.50501445075129281]
[null,"Small business"]
[null,"Typical usage","GJ p.a.",468.8]
[null,"Typical usage","MJ/day",{"$f":"D14*1000/365","v":1284.3835616438357}]
[null,"Typical gas bill","$/year",{"$f":"'Calc|Retail Bill Impacts'!$C$15","v":11870.401489421023}]
[null,"Distribution proportion","%",{"$f":"'Calc|Network Bill Impacts'!$C$10/D16","v":0.2563345142716324}]
[null,"Wholesale component","%",0.50501445075129281]

{"sheet":"Data|Wholesale forecast","index":7,"n_rows":12,"n_cols":11,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[]
[null,{"$f":"HYPERLINK(\"#'\"&RIGHT(CELL(\"filename\",Home!A1),LEN(CELL(\"filename\",Home!A1))-FIND(\"]\",CELL(\"filename\",Home!A1)))&\"'!A1\",\"Click to go to \"\"\"&RIGHT(CELL(\"filename\",Home!A1),LEN(CELL(\"filename\",Home!A1))-FIND(\"]\",CELL(\"filename\",Home!A1)))&\"\"\"\")","v":"Click to go to \"Home\""}]
[null,{"$f":"ModelName","v":"Evoenergy revised proposal gas network | customer impacts model"}]
[null,{"$f":"HYPERLINK(\"#'\"&RIGHT(CELL(\"filename\",A3),LEN(CELL(\"filename\",A3))-FIND(\"]\",CELL(\"filename\",A3)))&\"'!A1\",RIGHT(CELL(\"filename\",A3),LEN(CELL(\"filename\",A3))-FIND(\"]\",CELL(\"filename\",A3))))","v":"Data|Wholesale forecast"}]
[]
[null,"Weighted Average Wholesale + Transmission + Storage"]
[null,"Calendar year",2018,2019,2020,2021,2022,2023,2024,2025,2026]
[null,"Price",8.7260000000000009,8.4819228571428571,8.4955905756302776,8.7553266309285238,9.1756740997071198,9.7449965239620688,10.390869957053948,10.685291566470614,11.084490100176415]
[]
[null,"Financial year",null,"2018-19","2019-20","2020-21","2021-22","2022-23","2023-24","2024-25","2025-26"]
[null,"Price",null,{"$f":"AVERAGE(C8:D8)","v":8.603961428571429},{"$f":"AVERAGE(D8:E8)","v":8.4887567163865683},8.6254586032794016,8.9655003653178227,9.4603353118345943,10.067933240508008,10.538080761762281,10.884890833323514]
[null,"Rate of change (nominal)",null,null,{"$f":"E11/D11-1","v":-1.3389729038335463E-2},{"$f":"F11/E11-1","v":1.6103876157617547E-2},3.942303565275207E-2,5.5193232541821402E-2,6.4225834354235456E-2,4.6697520734707343E-2,3.2910174006223425E-2]

{"sheet":"Data|Retail tariffs","index":8,"n_rows":34,"n_cols":19,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
[]
[null,{"$f":"HYPERLINK(\"#'\"&RIGHT(CELL(\"filename\",Home!A1),LEN(CELL(\"filename\",Home!A1))-FIND(\"]\",CELL(\"filename\",Home!A1)))&\"'!A1\",\"Click to go to \"\"\"&RIGHT(CELL(\"filename\",Home!A1),LEN(CELL(\"filename\",Home!A1))-FIND(\"]\",CELL(\"filename\",Home!A1)))&\"\"\"\")","v":"Click to go to \"Home\""}]
[null,{"$f":"ModelName","v":"Evoenergy revised proposal gas network | customer impacts model"}]
[null,{"$f":"HYPERLINK(\"#'\"&RIGHT(CELL(\"filename\",A3),LEN(CELL(\"filename\",A3))-FIND(\"]\",CELL(\"filename\",A3)))&\"'!A1\",RIGHT(CELL(\"filename\",A3),LEN(CELL(\"filename\",A3))-FIND(\"]\",CELL(\"filename\",A3))))","v":"Data|Retail tariffs"}]
[null,null,null,null,null,null,null,null,null,"Discounts"]
[null,"Residential tariffs for 2020/21 ($ nominal)",null,null,null,null,null,null,null,null,null,null,"Residential"]
[null,"Item","Units","Fixed charge","Block 1","Block 2","Block 3","Block 4",null,"Fixed charges discount","Usage charges discount",null,"Item","Units","Fixed charge","Block 1","Block 2","Block 3","Block 4"]
[null,"EnergyAustralia",null,null,null,null,null,null,null,null,null,null,"EnergyAustralia"]
[null,"Blocks","GJ/year",null,{"$f":"P9","v":3.7500099999999996},{"$f":"Q9","v":246.75003749999999},{"$f":"R9","v":1000.4999487499999},{"$f":"S9","v":"∞"},null,null,null,null,"Blocks","GJ/year",null,3.7500099999999996,246.75003749999999,1000.4999487499999,"∞"]
[null,"Annual (excl. GST)","$/GJ/year",{"$f":"O10*(1-$J10)","v":579.6},{"$f":"P10*(1-$K10)","v":28.941818181818185},{"$f":"Q10*(1-$K10)","v":25.2},{"$f":"R10*(1-$K10)","v":24.436363636363634},{"$f":"S10*(1-$K10)","v":23.061818181818179},null,0.16,0.16,null,"Annual (excl. GST)","$/GJ/year",690,34.45454545454546,30,29.09090909090909,27.454545454545453]
[null,"Origin Energy",null,null,null,null,null,null,null,null,null,null,"Origin Energy"]
[null,"Blocks","GJ/year",null,{"$f":"P12","v":3.750000875},{"$f":"Q12","v":40.350001750000004},{"$f":"R12","v":135.90000287500001},{"$f":"S12","v":"∞"},null,null,null,null,"Blocks","GJ/year",null,3.750000875,40.350001750000004,135.90000287500001,"∞"]
[null,"Annual (excl. GST)","$/GJ/year",{"$f":"O13*(1-$J13)","v":620.90909090909088},{"$f":"P13*(1-$K13)","v":29.454545454545453},{"$f":"Q13*(1-$K13)","v":24.545454545454547},{"$f":"R13*(1-$K13)","v":22.90909090909091},{"$f":"S13*(1-$K13)","v":21.636363636363637},null,0,0,null,"Annual (excl. GST)","$/GJ/year",620.90909090909088,29.454545454545453,24.545454545454547,22.90909090909091,21.636363636363637]
[null,"Red Energy",null,null,null,null,null,null,null,null,null,null,"Red Energy"]
[null,"Blocks","GJ/year",null,{"$f":"P15","v":3.7500099999999996},{"$f":"Q15","v":40.350020000000001},{"$f":"R15","v":135.90000287500001},{"$f":"S15","v":"∞"},null,null,null,null,"Blocks","GJ/year",null,3.7500099999999996,40.350020000000001,135.90000287500001,"∞"]
[null,"Annual (excl. GST)","$/GJ/year",{"$f":"O16*(1-$J16)","v":779.81818181818187},{"$f":"P16*(1-$K16)","v":28.90909090909091},{"$f":"Q16*(1-$K16)","v":23.90909090909091},{"$f":"R16*(1-$K16)","v":21.818181818181817},{"$f":"S16*(1-$K16)","v":19.818181818181817},null,0,0,null,"Annual (excl. GST)","$/GJ/year",779.81818181818187,28.90909090909091,23.90909090909091,21.818181818181817,19.818181818181817]
[null,"ActewAGL",null,null,null,null,null,null,null,null,null,null,"ActewAGL"]
[null,"Blocks","GJ/year",null,{"$f":"P18","v":3.750000875},{"$f":"Q18","v":40.350001750000004},{"$f":"R18","v":135.90000287500001},{"$f":"S18","v":"∞"},null,null,null,null,"Blocks","GJ/year",null,3.750000875,40.350001750000004,135.90000287500001,"∞"]
[null,"Annual (excl. GST)","$/GJ/year",{"$f":"O19*(1-$J19)","v":787.27272727272725},{"$f":"P19*(1-$K19)","v":35.81818181818182},{"$f":"Q19*(1-$K19)","v":30.727272727272727},{"$f":"R19*(1-$K19)","v":28.181818181818183},{"$f":"S19*(1-$K19)","v":26.272727272727273},null,0,0,null,"Annual (excl. GST)","$/GJ/year",787.27272727272725,35.81818181818182,30.727272727272727,28.181818181818183,26.272727272727273]
[]
[null,"Small business tariffs for 2020/21 ($ nominal)",null,null,null,null,null,null,null,null,null,null,"Small Business"]
[null,"Item","Units","Fixed charge","Block 1","Block 2","Block 3","Block 4",null,null,null,null,"Item","Units","Fixed charge","Block 1","Block 2","Block 3","Block 4"]
[null,"EnergyAustralia",null,null,null,null,null,null,null,null,null,null,"EnergyAustralia"]
[null,"Blocks","GJ/year",null,{"$f":"P24","v":3.7500099999999996},{"$f":"Q24","v":246.75003749999999},{"$f":"R24","v":1000.4999487499999},{"$f":"S24","v":"∞"},null,null,null,null,"Blocks","GJ/year",null,3.7500099999999996,246.75003749999999,1000.4999487499999,"∞"]
[null,"Annual (excl. GST)","$/GJ/year",{"$f":"O25*(1-$J25)","v":1137.24},{"$f":"P25*(1-$K25)","v":24.22636363636364},{"$f":"Q25*(1-$K25)","v":22.459090909090911},{"$f":"R25*(1-$K25)","v":22.311818181818186},{"$f":"S25*(1-$K25)","v":22.238181818181818},null,0.19,0.19,null,"Annual (excl. GST)","$/GJ/year",1404,29.90909090909091,27.727272727272727,27.545454545454547,27.454545454545453]
[null,"Origin Energy",null,null,null,null,null,null,null,null,null,null,"Origin Energy"]
[null,"Blocks","GJ/year",null,{"$f":"P27","v":7.50000175},{"$f":"Q27","v":285.00000262499998},{"$f":"R27","v":0},{"$f":"S27","v":"∞"},null,null,null,null,"Blocks","GJ/year",null,7.50000175,285.00000262499998,0,"∞"]
[null,"Annual (excl. GST)","$/GJ/year",{"$f":"O28*(1-$J28)","v":1472.7272727272727},{"$f":"P28*(1-$K28)","v":23.877272727272725},{"$f":"Q28*(1-$K28)","v":21.559090909090909},{"$f":"R28*(1-$K28)","v":0},{"$f":"S28*(1-$K28)","v":21.095454545454544},null,0,0.15,null,"Annual (excl. GST)","$/GJ/year",1472.7272727272727,28.09090909090909,25.363636363636363,0,24.818181818181817]
[null,"Red Energy",null,null,null,null,null,null,null,null,null,null,"Red Energy"]
[null,"Blocks","GJ/year",null,{"$f":"P30","v":7.5000199999999992},{"$f":"Q30","v":285.00000262499998},{"$f":"R30","v":0},{"$f":"S30","v":"∞"},null,null,null,null,"Blocks","GJ/year",null,7.5000199999999992,285.00000262499998,0,"∞"]
[null,"Annual (excl. GST)","$/GJ/year",{"$f":"O31*(1-$J31)","v":999.81818181818198},{"$f":"P31*(1-$K31)","v":28.90909090909091},{"$f":"Q31*(1-$K31)","v":23.90909090909091},{"$f":"R31*(1-$K31)","v":0},{"$f":"S31*(1-$K31)","v":21.818181818181817},null,0,0,null,"Annual (excl. GST)","$/GJ/year",999.81818181818198,28.90909090909091,23.90909090909091,0,21.818181818181817]
[null,"ActewAGL",null,null,null,null,null,null,null,null,null,null,"ActewAGL"]
[null,"Blocks","GJ/year",null,{"$f":"P33","v":7.50000175},{"$f":"Q33","v":285.00000262499998},{"$f":"R33","v":0},{"$f":"S33","v":"∞"},null,null,null,null,"Blocks","GJ/year",null,7.50000175,285.00000262499998,0,"∞"]
[null,"Annual (excl. GST)","$/GJ/year",{"$f":"O34*(1-$J34)","v":1661.1818181818182},{"$f":"P34*(1-$K34)","v":25.5},{"$f":"Q34*(1-$K34)","v":23.259090909090908},{"$f":"R34*(1-$K34)","v":0},{"$f":"S34*(1-$K34)","v":22.640909090909091},null,0,0.15,null,"Annual (excl. GST)","$/GJ/year",1661.1818181818182,30,27.363636363636363,0,26.636363636363637]

{"sheet":"Data|Network tariffs","index":9,"n_rows":26,"n_cols":8,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
[]
[null,{"$f":"HYPERLINK(\"#'\"&RIGHT(CELL(\"filename\",Home!A1),LEN(CELL(\"filename\",Home!A1))-FIND(\"]\",CELL(\"filename\",Home!A1)))&\"'!A1\",\"Click to go to \"\"\"&RIGHT(CELL(\"filename\",Home!A1),LEN(CELL(\"filename\",Home!A1))-FIND(\"]\",CELL(\"filename\",Home!A1)))&\"\"\"\")","v":"Click to go to \"Home\""}]
[null,{"$f":"ModelName","v":"Evoenergy revised proposal gas network | customer impacts model"}]
[null,{"$f":"HYPERLINK(\"#'\"&RIGHT(CELL(\"filename\",A3),LEN(CELL(\"filename\",A3))-FIND(\"]\",CELL(\"filename\",A3)))&\"'!A1\",RIGHT(CELL(\"filename\",A3),LEN(CELL(\"filename\",A3))-FIND(\"]\",CELL(\"filename\",A3))))","v":"Data|Network tariffs"}]
[]
[null,"Residential tariffs ($ nominal)"]
[null,"Item","Units","Fixed charge","Block 1","Block 2","Block 3","Block 4"]
[null,"Blocks","GJ/year",null,15,176.4,720,"∞"]
[null,"Annual (excl. GST)"]
[null,"FY21","$/GJ/year",71.22,12.016,6.5460000000000003,5.9329999999999998,5.7220000000000004]
[null,"FY22","$/GJ/year",73.66,12.36,6.7160000000000002,6.0709999999999997,5.8620000000000001]
[null,"FY23","$/GJ/year",75.40891577288572,12.653464552713379,6.8754585708756526,6.2151442798966769,6.0011819747577535]
[null,"FY24","$/GJ/year",77.199356204753911,12.953896859771358,7.0387031804388727,6.3627109899410943,6.14366855922166]
[null,"FY25","$/GJ/year",79.032307219186677,13.261462357170069,7.2058237209348066,6.5137813891892797,6.2895382150267762]
[null,"FY26","$/GJ/year",80.908778148635307,13.576330408866852,7.3769122189279779,6.6684386660380799,6.4388712667295707]
[]
[null,"Small business tariffs ($ nominal)"]
[null,"Item","Units","Fixed charge","Block 1","Block 2","Block 3","Block 4"]
[null,"Blocks","GJ/year",null,15,176.4,720,"∞"]
[null,"Annual (excl. GST)"]
[null,"FY21","$/GJ/year",71.22,12.016,6.5460000000000003,5.9329999999999998,5.7220000000000004]
[null,"FY22","$/GJ/year",73.66,12.36,6.7160000000000002,6.0709999999999997,5.8620000000000001]
[null,"FY23","$/GJ/year",75.40891577288572,12.653464552713379,6.8754585708756526,6.2151442798966769,6.0011819747577535]
[null,"FY24","$/GJ/year",77.199356204753911,12.953896859771358,7.0387031804388727,6.3627109899410943,6.14366855922166]
[null,"FY25","$/GJ/year",79.032307219186677,13.261462357170069,7.2058237209348066,6.5137813891892797,6.2895382150267762]
[null,"FY26","$/GJ/year",80.908778148635307,13.576330408866852,7.3769122189279779,6.6684386660380799,6.4388712667295707]

{"sheet":"Data|PTRM Revenues","index":10,"n_rows":9,"n_cols":9,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[]
[null,{"$f":"HYPERLINK(\"#'\"&RIGHT(CELL(\"filename\",Home!A1),LEN(CELL(\"filename\",Home!A1))-FIND(\"]\",CELL(\"filename\",Home!A1)))&\"'!A1\",\"Click to go to \"\"\"&RIGHT(CELL(\"filename\",Home!A1),LEN(CELL(\"filename\",Home!A1))-FIND(\"]\",CELL(\"filename\",Home!A1)))&\"\"\"\")","v":"Click to go to \"Home\""}]
[null,{"$f":"ModelName","v":"Evoenergy revised proposal gas network | customer impacts model"}]
[null,{"$f":"HYPERLINK(\"#'\"&RIGHT(CELL(\"filename\",A3),LEN(CELL(\"filename\",A3))-FIND(\"]\",CELL(\"filename\",A3)))&\"'!A1\",RIGHT(CELL(\"filename\",A3),LEN(CELL(\"filename\",A3))-FIND(\"]\",CELL(\"filename\",A3))))","v":"Data|PTRM Revenues"}]
[]
[null,"Categories","Tariffs"]
[null,"Tariff Name","Units","FY21","FY22","FY23","FY24","FY25","FY26"]
[null,"CPI","%",0,2.3743086789108414E-2,2.3743086789108414E-2,2.3743086789108414E-2,2.3743086789108414E-2,2.3743086789108414E-2]
[null,"X-factors","%",0,-5.3516442139300803E-4,0,0,0,0]