{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Energex >>>","Input Data","Public Lighting Pricing","Output Tables","Changes register"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":12,"defined_names":204,"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":"Energex >>>","index":0,"n_rows":3,"n_cols":1,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
[]
["ACS Public Lighting pricing model for Energex "]
["Regulatory control period 1 July 2020 to 30 June 2025"]

{"sheet":"Input Data","index":1,"n_rows":82,"n_cols":9,"rows_kept":82,"cut":false,"hidden":false,"merged":[]}
["Public Lighting Quantity Inputs","Units","2020-21","2021-22","2022-23","2023-24","2024-25"]
[]
["Opening Population Public Lights"]
[]
["NPL1 (Energex Owned & Operated)"]
["Major Conventional ","#",39792,38167,34942,31178,26852,null,"Source: Energex PL Opex review model. Allocation between NPL1 and NPL2 based on the 2018-19 volume ratio"]
["Minor Conventional","#",102272,98545,90920,81894,71336,null,"Source: Energex PL Opex review model. Allocation between NPL1 and NPL2 based on the 2018-19 volume ratio"]
["Major LED","#",2639,4944,8875,13376,18466,null,"Source: Energex PL Opex review model. Allocation between NPL1 and NPL2 based on the 2018-19 volume ratio"]
["Minor LED","#",6230,11713,21127,31978,44393,null,"Source: Energex PL Opex review model. Allocation between NPL1 and NPL2 based on the 2018-19 volume ratio"]
["Total","#",{"$f":"SUM(C6:C9)","v":150933},{"$f":"SUM(D6:D9)","v":153369},{"$f":"SUM(E6:E9)","v":155864},{"$f":"SUM(F6:F9)","v":158426},{"$f":"SUM(G6:G9)","v":161047}]
[]
["NPL2 (Gifted & Energex Operated)"]
["Major Conventional","#",48914,46917,42953,38324,33008,null,"Source: Energex PL Opex review model. Allocation between NPL1 and NPL2 based on the 2018-19 volume ratio"]
["Minor Conventional","#",125716,121136,111763,100667,87689,null,"Source: Energex PL Opex review model. Allocation between NPL1 and NPL2 based on the 2018-19 volume ratio"]
["Major LED","#",3245,6077,10910,16442,22699,null,"Source: Energex PL Opex review model. Allocation between NPL1 and NPL2 based on the 2018-19 volume ratio"]
["Minor LED","#",7659,14398,25971,39308,54569,null,"Source: Energex PL Opex review model. Allocation between NPL1 and NPL2 based on the 2018-19 volume ratio"]
["Total","#",{"$f":"SUM(C13:C16)","v":185534},{"$f":"SUM(D13:D16)","v":188528},{"$f":"SUM(E13:E16)","v":191597},{"$f":"SUM(F13:F16)","v":194741},{"$f":"SUM(G13:G16)","v":197965}]
["Total Opening Lights","#",{"$f":"SUM(C10,C17)","v":336467},{"$f":"SUM(D10,D17)","v":341897},{"$f":"SUM(E10,E17)","v":347461},{"$f":"SUM(F10,F17)","v":353167},{"$f":"SUM(G10,G17)","v":359012}]
[]
["Public Lights Additions by Type"]
[]
["NPL1 (Energex Owned & Operated)"]
["Major Conventional ","#",0,0,0,0,0]
["Minor Conventional","#",0,0,0,0,0]
["Major LED","#",2043,2402,2820,3188,3618]
["Minor LED","#",5879,6996,8295,9431,10926]
["Total","#",{"$f":"SUM(C23:C26)","v":7922},{"$f":"SUM(D23:D26)","v":9398},{"$f":"SUM(E23:E26)","v":11115},{"$f":"SUM(F23:F26)","v":12619},{"$f":"SUM(G23:G26)","v":14544}]
[]
["NPL2 (Gifted & Energex Operated)"]
["Major Conventional ","#",0,0,0,0,0]
["Minor Conventional","#",0,0,0,0,0]
["Major LED","#",4926,5702,6604,7454,8434]
["Minor LED","#",10569,12329,14355,16295,18700]
["Total","#",{"$f":"SUM(C30:C33)","v":15495},{"$f":"SUM(D30:D33)","v":18031},{"$f":"SUM(E30:E33)","v":20959},{"$f":"SUM(F30:F33)","v":23749},{"$f":"SUM(G30:G33)","v":27134}]
["Total Additions","#",{"$f":"SUM(C27,C34)","v":23417},{"$f":"SUM(D27,D34)","v":27429},{"$f":"SUM(E27,E34)","v":32074},{"$f":"SUM(F27,F34)","v":36368},{"$f":"SUM(G27,G34)","v":41678}]
[]
["Public Lights Disposals by Type"]
[]
["NPL1 (Energex Owned & Operated)"]
["Major Conventional","#",2013,2332,2700,3018,3398]
["Minor Conventional","#",5609,6676,7935,9021,10476]
["Major LED","#",0,0,0,0,0]
["Minor LED","#",0,0,0,0,0]
["Total","#",{"$f":"SUM(C40:C43)","v":7622},{"$f":"SUM(D40:D43)","v":9008},{"$f":"SUM(E40:E43)","v":10635},{"$f":"SUM(F40:F43)","v":12039},{"$f":"SUM(G40:G43)","v":13874}]
[]
["NPL2 (Gifted & Energex Operated)"]
["Major Conventional (SV)","#",3466,4232,5114,5954,6914]
["Minor Conventional (SV)","#",6964,8694,10690,12600,14975]
["Major LED","#",0,0,0,0,0]
["Minor LED","#",0,0,0,0,0]
["Total","#",{"$f":"SUM(C47:C50)","v":10430},{"$f":"SUM(D47:D50)","v":12926},{"$f":"SUM(E47:E50)","v":15804},{"$f":"SUM(F47:F50)","v":18554},{"$f":"SUM(G47:G50)","v":21889}]
["Total Disposals","#",{"$f":"SUM(C44,C51)","v":18052},{"$f":"SUM(D44,D51)","v":21934},{"$f":"SUM(E44,E51)","v":26439},{"$f":"SUM(F44,F51)","v":30593},{"$f":"SUM(G44,G51)","v":35763}]
[]
[]
["Pricing Allocators"]
["Proportion of asset base related to refurbishment","%",0.1]
["Relativity Major to Minor"]
["Opex + tax","#",1.5]
["Asset charge","#",1.8]
[]
["Price Smoothing Inputs"]
["Expected CPI","%",2.3699999999999999E-2]
["WACC (Discount rate for smoothing)","%",4.6734187198390856E-2,4.5406260215142207E-2,4.4078333231893557E-2,4.2750406248644908E-2,4.1422479265396259E-2,"Source: Public lighting PTRM"]
["X Factors",null,"P_0","X_02","X_03","X_04","X_05"]
["X factor Conventional","%",4.8337521865207192E-2,0,0,0,0,"X factors for 2021-22 to 2024-25 in accordance with AER's Draft Decision for ACS"]
["X factor LED","%",0.1234574777137669,0,0,0,0,"X factors for 2021-22 to 2024-25 in accordance with AER's Draft Decision for ACS"]
[]
["% of PLAB associated with Poles, cabling and some residual brackets","%",0.7]
[]
["Million",null,1000000]
[]
["Price t-1 to be used for price smoothing"]
[]
["NPL1 Conventional",null,null,"Source: Approved Energex's 2019-20 prices in the 2019-20 price schedule"]
["Major","$/day/light Nominal",0.86599999999999999,"Used as starting point for smoothing in accordance with the formula in the Control Mechanism and ACS Draft Determination"]
["Minor","$/day/light Nominal",0.39800000000000002,"Used as starting point for smoothing in accordance with the formula in the Control Mechanism and ACS Draft Determination"]
[]
["NPL2 Conventional"]
["Major","$/day/light Nominal",0.30099999999999999,"Used as starting point for smoothing in accordance with the formula in the Control Mechanism and ACS Draft Determination"]
["Minor","$/day/light Nominal",0.14599999999999999,"Used as starting point for smoothing in accordance with the formula in the Control Mechanism and ACS Draft Determination"]
[]
[null,"Note: For LED the price smoothing starting point is 2020-21 as these are new tariffs which will be introduced from 1 July 2020"]

{"sheet":"Public Lighting Pricing","index":2,"n_rows":230,"n_cols":9,"rows_kept":230,"cut":false,"hidden":false,"merged":[]}
["Public Lighting Price Calculations","Units","2020-21","2021-22","2022-23","2023-24","2024-25"]
[]
["Building Block Revenue - Linked to PL PTRM"]
[]
["Opex Charge"]
["O&M Conventional","$M Nominal",21.661258642812545,21.058094354573495,19.590596085367004,17.786209869876405,15.578590257745299,null,"Updated reflecting the Energex 2020-25 - Revised Regulatory Proposal - Public Lighting PTRM CON - December 2019.xlsm"]
["O&M LED","$M Nominal",0.57122031124721528,1.1588138525426508,2.2395989711037836,3.6209370510430334,5.3398443914367917,null,"Updated reflecting the Energex 2020-25 - Revised Regulatory Proposal - Public Lighting PTRM LED - December 2019.xlsm"]
["Carry-over amounts Conventional","$M Nominal",0,0,0,0,0]
["Carry-over amounts LED","$M Nominal",0,0,0,0,0]
["Benchmark Tax liability Conventional","$M Nominal",0,0,0,0,0,null,"Updated reflecting the Energex 2020-25 - Revised Regulatory Proposal - Public Lighting PTRM CON - December 2019.xlsm"]
["Tax liability attributable to O&M Revenue","$M Nominal",0,0,0,0,0]
["Tax liability attributable to Capex Revenue","$M Nominal",0,0,0,0,0]
["Tax liability attributable to Gifted Assets","$M Nominal",0,0,0,0,0]
["Tax liability attributable to Contributed Assets","$M Nominal",0,0,0,0,0]
["Benchmark Tax liability LED","$M Nominal",2.0546800462435382,1.8967797973922274,1.8331354815373633,1.7967025518868702,1.829388839268379,null,"Updated reflecting the Energex 2020-25 - Revised Regulatory Proposal - Public Lighting PTRM CON - December 2019.xlsm"]
["Tax liability attributable to O&M Revenue","$M Nominal",0,0,0,0,0]
["Tax liability attributable to Capex Revenue","$M Nominal",0,0,0,0,0]
["Tax liability attributable to Gifted Assets","$M Nominal",2.0546800462435382,1.8967797973922274,1.8331354815373633,1.7967025518868702,1.829388839268379]
["Tax liability attributable to Contributed Assets","$M Nominal",0,0,0,0,0]
["Total Opex Charge Conventional","$M Nominal",{"$f":"SUM(C6,C8)+C11+C6/(C6+C24+C25)*(C13+C14)","v":21.661258642812545},{"$f":"SUM(D6,D8)+D11+D6/(D6+D24+D25)*(D13+D14)","v":21.058094354573495},19.590596085367004,17.786209869876405,15.578590257745299]
["Total Opex Charge LED","$M Nominal",{"$f":"SUM(C7,C9)+C16+C7/(C7+C28+C29)*(C18+C19)","v":1.972663552270018},{"$f":"SUM(D7,D9)+D16+D7/(D7+D28+D29)*(D18+D19)","v":1.9337014698751909},3.028641411269958,4.4323489691298645,6.2036296781578333]
[]
["Capex Charge Conventional","Flag",1,1,1,1,1]
["Return on capital","$M Nominal",5.8336321795513157,5.3811023087252359,4.9253177005005551,4.4618407389298254,3.997521026540527,null,"Updated reflecting the Energex 2020-25 - Revised Regulatory Proposal - Public Lighting PTRM CON - December 2019.xlsm"]
["Return of capital","$M Nominal",8.160659680533211,8.6682982736671601,9.1979153795004667,9.7468848458124988,10.320380568478837,null,"Updated reflecting the Energex 2020-25 - Revised Regulatory Proposal - Public Lighting PTRM CON - December 2019.xlsm"]
["Total Capex Charge Conventional","$M Nominal",{"$f":"(SUM(C24:C25)+C12+(C24+C25)/(C6+C24+C25)*(C13+C14))*C23","v":13.994291860084527},{"$f":"(SUM(D24:D25)+D12+(D24+D25)/(D6+D24+D25)*(D13+D14))*D23","v":14.049400582392396},14.123233080001022,14.208725584742325,14.317901595019364]
["Capex Charge LED"]
["Return on capital","$M Nominal",0.11099077650555383,0.61788070999662215,1.0172918937529887,1.4111426774988485,1.788549258823078,null,"Updated reflecting the Energex 2020-25 - Revised Regulatory Proposal - Public Lighting PTRM LED - December 2019.xlsm"]
["Return of capital","$M Nominal",0.15526483790234624,1.0598647723583006,1.9462365328029674,2.9857305781765127,4.1807266638941805,null,"Updated reflecting the Energex 2020-25 - Revised Regulatory Proposal - Public Lighting PTRM LED - December 2019.xlsm"]
["Total Capex Charge LED","$M Nominal",{"$f":"(SUM(C28:C29)+C17+(C28+C29)/(C7+C28+C29)*(C18+C19))*C23","v":0.91949241962863559},{"$f":"(SUM(D28:D29)+D17+(D28+D29)/(D7+D28+D29)*(D18+D19))*D23","v":2.79963766241461},4.0076214679271445,5.3821638894754003,6.9348794752645961]
[]
["ARR for Conventional","$M Nominal",{"$f":"SUM(C20,C26)","v":35.655550502897071},{"$f":"SUM(D20,D26)","v":35.107494936965892},33.713829165368026,31.99493545461873,29.896491852764662]
["ARR for LED","$M Nominal",{"$f":"SUM(C21,C30)","v":2.8921559718986538},{"$f":"SUM(D21,D30)","v":4.7333391322898013},7.0362628791971025,9.8145128586052657,13.138509153422429]
["ARR for Total","$M Nominal",{"$f":"C32+C33","v":38.547706474795724},{"$f":"D32+D33","v":39.840834069255692},{"$f":"E32+E33","v":40.750092044565129},{"$f":"F32+F33","v":41.809448313223996},{"$f":"G32+G33","v":43.035001006187088}]
[]
["Opex and Capex Charge Components"]
["Opex Charge for Conventional Lights","$M Nominal",{"$f":"C20","v":21.661258642812545},21.058094354573495,19.590596085367004,17.786209869876405,15.578590257745299]
["Opex Charge for LED","$M Nominal",1.972663552270018,1.9337014698751909,3.028641411269958,4.4323489691298645,6.2036296781578333]
["Capex Charge for Conventional Lights","$M Nominal",{"$f":"C26","v":13.994291860084527},{"$f":"D26","v":14.049400582392396},14.123233080001022,14.208725584742325,14.317901595019364]
["Capex Charge for LED","$M Nominal",{"$f":"C30","v":0.91949241962863559},{"$f":"D30","v":2.79963766241461},{"$f":"E30","v":4.0076214679271445},{"$f":"F30","v":5.3821638894754003},{"$f":"G30","v":6.9348794752645961}]
[]
["Public Lights Population"]
[]
["Opening Population Public Lights"]
["NPL1 (Energex Owned & Operated)"]
["Major Conventional","#",{"$f":"'Input Data'!C6","v":39792},{"$f":"'Input Data'!D6","v":38167},{"$f":"'Input Data'!E6","v":34942},{"$f":"'Input Data'!F6","v":31178},{"$f":"'Input Data'!G6","v":26852}]
["Minor Conventional","#",{"$f":"'Input Data'!C7","v":102272},{"$f":"'Input Data'!D7","v":98545},{"$f":"'Input Data'!E7","v":90920},{"$f":"'Input Data'!F7","v":81894},{"$f":"'Input Data'!G7","v":71336}]
["Major LED","#",{"$f":"'Input Data'!C8","v":2639},{"$f":"'Input Data'!D8","v":4944},{"$f":"'Input Data'!E8","v":8875},{"$f":"'Input Data'!F8","v":13376},{"$f":"'Input Data'!G8","v":18466}]
["Minor LED","#",{"$f":"'Input Data'!C9","v":6230},{"$f":"'Input Data'!D9","v":11713},{"$f":"'Input Data'!E9","v":21127},{"$f":"'Input Data'!F9","v":31978},{"$f":"'Input Data'!G9","v":44393}]
["Total","#",{"$f":"SUM(C46:C49)","v":150933},{"$f":"SUM(D46:D49)","v":153369},{"$f":"SUM(E46:E49)","v":155864},{"$f":"SUM(F46:F49)","v":158426},{"$f":"SUM(G46:G49)","v":161047}]
[]
["NPL2 (Gifted & Energex Operated)"]
["Major Conventional","#",{"$f":"'Input Data'!C13","v":48914},{"$f":"'Input Data'!D13","v":46917},{"$f":"'Input Data'!E13","v":42953},{"$f":"'Input Data'!F13","v":38324},{"$f":"'Input Data'!G13","v":33008}]
["Minor Conventional","#",{"$f":"'Input Data'!C14","v":125716},{"$f":"'Input Data'!D14","v":121136},{"$f":"'Input Data'!E14","v":111763},{"$f":"'Input Data'!F14","v":100667},{"$f":"'Input Data'!G14","v":87689}]
["Major LED","#",{"$f":"'Input Data'!C15","v":3245},{"$f":"'Input Data'!D15","v":6077},{"$f":"'Input Data'!E15","v":10910},{"$f":"'Input Data'!F15","v":16442},{"$f":"'Input Data'!G15","v":22699}]
["Minor LED","#",{"$f":"'Input Data'!C16","v":7659},{"$f":"'Input Data'!D16","v":14398},{"$f":"'Input Data'!E16","v":25971},{"$f":"'Input Data'!F16","v":39308},{"$f":"'Input Data'!G16","v":54569}]
["Total","#",{"$f":"SUM(C53:C56)","v":185534},{"$f":"SUM(D53:D56)","v":188528},{"$f":"SUM(E53:E56)","v":191597},{"$f":"SUM(F53:F56)","v":194741},{"$f":"SUM(G53:G56)","v":197965}]
["Total Opening Lights","#",{"$f":"SUM(C50,C57)","v":336467},{"$f":"SUM(D50,D57)","v":341897},{"$f":"SUM(E50,E57)","v":347461},{"$f":"SUM(F50,F57)","v":353167},{"$f":"SUM(G50,G57)","v":359012}]
[]
["Plus Additions"]
["NPL1 (Energex Owned & Operated)"]
["Major Conventional","#",{"$f":"'Input Data'!C23","v":0},0,0,0,0]
["Minor Conventional","#",{"$f":"'Input Data'!C24","v":0},0,0,0,0]
["Major LED","#",{"$f":"'Input Data'!C25","v":2043},{"$f":"'Input Data'!D25","v":2402},{"$f":"'Input Data'!E25","v":2820},{"$f":"'Input Data'!F25","v":3188},{"$f":"'Input Data'!G25","v":3618}]
["Minor LED","#",{"$f":"'Input Data'!C26","v":5879},{"$f":"'Input Data'!D26","v":6996},{"$f":"'Input Data'!E26","v":8295},{"$f":"'Input Data'!F26","v":9431},{"$f":"'Input Data'!G26","v":10926}]
["Total","#",{"$f":"SUM(C62:C65)","v":7922},{"$f":"SUM(D62:D65)","v":9398},{"$f":"SUM(E62:E65)","v":11115},{"$f":"SUM(F62:F65)","v":12619},{"$f":"SUM(G62:G65)","v":14544}]
[]
["NPL2 (Gifted & Energex Operated)"]
["Major Conventional","#",{"$f":"'Input Data'!C30","v":0},{"$f":"'Input Data'!D30","v":0},{"$f":"'Input Data'!E30","v":0},{"$f":"'Input Data'!F30","v":0},{"$f":"'Input Data'!G30","v":0}]
["Minor Conventional","#",{"$f":"'Input Data'!C31","v":0},{"$f":"'Input Data'!D31","v":0},{"$f":"'Input Data'!E31","v":0},{"$f":"'Input Data'!F31","v":0},{"$f":"'Input Data'!G31","v":0}]
["Major LED","#",{"$f":"'Input Data'!C32","v":4926},{"$f":"'Input Data'!D32","v":5702},{"$f":"'Input Data'!E32","v":6604},{"$f":"'Input Data'!F32","v":7454},{"$f":"'Input Data'!G32","v":8434}]
["Minor LED","#",{"$f":"'Input Data'!C33","v":10569},{"$f":"'Input Data'!D33","v":12329},{"$f":"'Input Data'!E33","v":14355},{"$f":"'Input Data'!F33","v":16295},{"$f":"'Input Data'!G33","v":18700}]
["Total","#",{"$f":"SUM(C69:C72)","v":15495},{"$f":"SUM(D69:D72)","v":18031},{"$f":"SUM(E69:E72)","v":20959},{"$f":"SUM(F69:F72)","v":23749},{"$f":"SUM(G69:G72)","v":27134}]
["Total Additions","#",{"$f":"SUM(C66,C73)","v":23417},{"$f":"SUM(D66,D73)","v":27429},{"$f":"SUM(E66,E73)","v":32074},{"$f":"SUM(F66,F73)","v":36368},{"$f":"SUM(G66,G73)","v":41678}]
[]
["Less Disposals"]
["NPL1 (Energex Owned & Operated)"]
["Major Conventional","#",{"$f":"'Input Data'!C40","v":2013},{"$f":"'Input Data'!D40","v":2332},{"$f":"'Input Data'!E40","v":2700},{"$f":"'Input Data'!F40","v":3018},{"$f":"'Input Data'!G40","v":3398}]
["Minor Conventional","#",{"$f":"'Input Data'!C41","v":5609},{"$f":"'Input Data'!D41","v":6676},{"$f":"'Input Data'!E41","v":7935},{"$f":"'Input Data'!F41","v":9021},{"$f":"'Input Data'!G41","v":10476}]
["Major LED","#",{"$f":"'Input Data'!C42","v":0},{"$f":"'Input Data'!D42","v":0},{"$f":"'Input Data'!E42","v":0},{"$f":"'Input Data'!F42","v":0},{"$f":"'Input Data'!G42","v":0}]
["Minor LED","#",{"$f":"'Input Data'!C43","v":0},{"$f":"'Input Data'!D43","v":0},{"$f":"'Input Data'!E43","v":0},{"$f":"'Input Data'!F43","v":0},{"$f":"'Input Data'!G43","v":0}]
["Total","#",{"$f":"SUM(C78:C81)","v":7622},{"$f":"SUM(D78:D81)","v":9008},{"$f":"SUM(E78:E81)","v":10635},{"$f":"SUM(F78:F81)","v":12039},{"$f":"SUM(G78:G81)","v":13874}]
[]
["NPL2 (Gifted & Energex Operated)"]
["Major Conventional","#",{"$f":"'Input Data'!C47","v":3466},{"$f":"'Input Data'!D47","v":4232},{"$f":"'Input Data'!E47","v":5114},{"$f":"'Input Data'!F47","v":5954},{"$f":"'Input Data'!G47","v":6914}]
["Minor Conventional","#",{"$f":"'Input Data'!C48","v":6964},{"$f":"'Input Data'!D48","v":8694},{"$f":"'Input Data'!E48","v":10690},{"$f":"'Input Data'!F48","v":12600},{"$f":"'Input Data'!G48","v":14975}]
["Major LED","#",{"$f":"'Input Data'!C49","v":0},{"$f":"'Input Data'!D49","v":0},{"$f":"'Input Data'!E49","v":0},{"$f":"'Input Data'!F49","v":0},{"$f":"'Input Data'!G49","v":0}]
["Minor LED","#",{"$f":"'Input Data'!C50","v":0},{"$f":"'Input Data'!D50","v":0},{"$f":"'Input Data'!E50","v":0},{"$f":"'Input Data'!F50","v":0},{"$f":"'Input Data'!G50","v":0}]
["Total","#",{"$f":"SUM(C85:C88)","v":10430},{"$f":"SUM(D85:D88)","v":12926},{"$f":"SUM(E85:E88)","v":15804},{"$f":"SUM(F85:F88)","v":18554},{"$f":"SUM(G85:G88)","v":21889}]
["Total Disposals","#",{"$f":"SUM(C82,C89)","v":18052},{"$f":"SUM(D82,D89)","v":21934},{"$f":"SUM(E82,E89)","v":26439},{"$f":"SUM(F82,F89)","v":30593},{"$f":"SUM(G82,G89)","v":35763}]
[]
["Closing Population Public Lights"]
["NPL1 (Energex Owned & Operated)"]
["Major Conventional","#",{"$f":"(C46+C62-C78)","v":37779},35835,32242,28160,23454]
["Minor Conventional","#",96663,91869,82985,72873,60860]
["Major LED","#",4682,7346,11695,16564,22084]
["Minor LED","#",12109,18709,29422,41409,55319]
["Total","#",{"$f":"SUM(C94:C97)","v":151233},{"$f":"SUM(D94:D97)","v":153759},{"$f":"SUM(E94:E97)","v":156344},{"$f":"SUM(F94:F97)","v":159006},{"$f":"SUM(G94:G97)","v":161717}]
[]
["NPL2 (Gifted & Energex Operated)"]
["Major Conventional","#",{"$f":"(C53+C69-C85)","v":45448},42685,37839,32370,26094]
["Minor Conventional","#",118752,112442,101073,88067,72714]
["Major LED","#",8171,11779,17514,23896,31133]
["Minor LED","#",18228,26727,40326,55603,73269]
["Total","#",{"$f":"SUM(C101:C104)","v":190599},{"$f":"SUM(D101:D104)","v":193633},{"$f":"SUM(E101:E104)","v":196752},{"$f":"SUM(F101:F104)","v":199936},{"$f":"SUM(G101:G104)","v":203210}]
["Grand Total","#",{"$f":"SUM(C98,C105)","v":341832},{"$f":"SUM(D98,D105)","v":347392},{"$f":"SUM(E98,E105)","v":353096},{"$f":"SUM(F98,F105)","v":358942},{"$f":"SUM(G98,G105)","v":364927}]
[]
["Average No of Lights"]
["NPL1 (Energex Owned & Operated)"]
["Major Conventional","#",{"$f":"AVERAGE(C46,C94)","v":38785.5},{"$f":"AVERAGE(D46,D94)","v":37001},33592,29669,25153]
["Minor Conventional","#",{"$f":"AVERAGE(C47,C95)","v":99467.5},95207,86952.5,77383.5,66098]
["Major LED","#",3660.5,6145,10285,14970,20275]
["Minor LED","#",9169.5,15211,25274.5,36693.5,49856]
["Total","#",{"$f":"SUM(C110:C113)","v":151083},{"$f":"SUM(D110:D113)","v":153564},{"$f":"SUM(E110:E113)","v":156104},{"$f":"SUM(F110:F113)","v":158716},{"$f":"SUM(G110:G113)","v":161382}]
[]
["NPL2 (Gifted & Energex Operated)"]
["Major Conventional","#",{"$f":"AVERAGE(C53,C101)","v":47181},44801,40396,35347,29551]
["Minor Conventional","#",122234,116789,106418,94367,80201.5]
["Major LED","#",5708,8928,14212,20169,26916]
["Minor LED","#",12943.5,20562.5,33148.5,47455.5,63919]
["Total","#",{"$f":"SUM(C117:C120)","v":188066.5},{"$f":"SUM(D117:D120)","v":191080.5},{"$f":"SUM(E117:E120)","v":194174.5},{"$f":"SUM(F117:F120)","v":197338.5},{"$f":"SUM(G117:G120)","v":200587.5}]
["Grand total","#",{"$f":"SUM(C114,C121)","v":339149.5},{"$f":"SUM(D114,D121)","v":344644.5},{"$f":"SUM(E114,E121)","v":350278.5},{"$f":"SUM(F114,F121)","v":356054.5},{"$f":"SUM(G114,G121)","v":361969.5}]
[]
["2020-25 TSS Pricing Methodology"]
["Major Conventional","#",{"$f":"SUM(C110+C117)","v":85966.5},{"$f":"SUM(D110+D117)","v":81802},73988,65016,54704]
["Minor Conventional","#",221701.5,211996,193370.5,171750.5,146299.5]
["Major LED","#",9368.5,15073,24497,35139,47191]
["Minor LED","#",22113,35773.5,58423,84149,113775]
["Total","#",{"$f":"SUM(C125:C128)","v":339149.5},{"$f":"SUM(D125:D128)","v":344644.5},{"$f":"SUM(E125:E128)","v":350278.5},{"$f":"SUM(F125:F128)","v":356054.5},{"$f":"SUM(G125:G128)","v":361969.5}]
[]
["Weighted Average No of Lights"]
["Major Conventional",null,{"$f":"ROUND(C125*'Input Data'!$C$59,0)","v":154740},{"$f":"ROUND(D125*'Input Data'!$C$59,0)","v":147244},{"$f":"ROUND(E125*'Input Data'!$C$59,0)","v":133178},{"$f":"ROUND(F125*'Input Data'!$C$59,0)","v":117029},{"$f":"ROUND(G125*'Input Data'!$C$59,0)","v":98467}]
["Minor Conventional",null,{"$f":"C126","v":221701.5},{"$f":"D126","v":211996},{"$f":"E126","v":193370.5},{"$f":"F126","v":171750.5},{"$f":"G126","v":146299.5}]
["Major LED",null,{"$f":"ROUND(C127*'Input Data'!$C$59,0)","v":16863},{"$f":"ROUND(D127*'Input Data'!$C$59,0)","v":27131},{"$f":"ROUND(E127*'Input Data'!$C$59,0)","v":44095},{"$f":"ROUND(F127*'Input Data'!$C$59,0)","v":63250},{"$f":"ROUND(G127*'Input Data'!$C$59,0)","v":84944}]
["Minor LED",null,{"$f":"C128","v":22113},{"$f":"D128","v":35773.5},{"$f":"E128","v":58423},{"$f":"F128","v":84149},{"$f":"G128","v":113775}]
["Total",null,{"$f":"SUM(C132:C135)","v":415417.5},{"$f":"SUM(D132:D135)","v":422144.5},{"$f":"SUM(E132:E135)","v":429066.5},{"$f":"SUM(F132:F135)","v":436178.5},{"$f":"SUM(G132:G135)","v":443485.5}]
[]
["Price Components"]
[]
["Opex Charge"]
["NPL1 (Energex Owned & Operated)"]
["Major Conventional","$/light Nominal",{"$f":"C$37*Million/(C$125+C$126/'Input Data'!$C$58)","v":92.661548944196895},{"$f":"D$37*Million/(D$125+D$126/'Input Data'!$C$58)","v":94.374771158145805},{"$f":"E$37*Million/(E$125+E$126/'Input Data'!$C$58)","v":96.552169369564908},{"$f":"F$37*Million/(F$125+F$126/'Input Data'!$C$58)","v":99.078504666482004},{"$f":"G$37*Million/(G$125+G$126/'Input Data'!$C$58)","v":102.33116954318135}]
["Minor Conventional","$/light Nominal",{"$f":"C142/'Input Data'!$C$58","v":61.77436596279793},{"$f":"D142/'Input Data'!$C$58","v":62.916514105430537},{"$f":"E142/'Input Data'!$C$58","v":64.368112913043277},{"$f":"F142/'Input Data'!$C$58","v":66.052336444321341},{"$f":"G142/'Input Data'!$C$58","v":68.220779695454226}]
["Major LED","$/light Nominal",{"$f":"C$38*Million/(C$127+C$128/'Input Data'!$C$58)","v":81.81761275253595},{"$f":"D$38*Million/(D$127+D$128/'Input Data'!$C$58)","v":49.681451874908561},{"$f":"E$38*Million/(E$127+E$128/'Input Data'!$C$58)","v":47.735985298758912},{"$f":"F$38*Million/(F$127+F$128/'Input Data'!$C$58)","v":48.579898461500434},{"$f":"G$38*Million/(G$127+G$128/'Input Data'!$C$58)","v":50.419207241145905}]
["Minor LED","$/light Nominal",{"$f":"C144/'Input Data'!$C$58","v":54.5450751683573},{"$f":"D144/'Input Data'!$C$58","v":33.120967916605707},{"$f":"E144/'Input Data'!$C$58","v":31.823990199172609},{"$f":"F144/'Input Data'!$C$58","v":32.386598974333623},{"$f":"G144/'Input Data'!$C$58","v":33.612804827430601}]
[]
["NPL2 (Gifted & Energex Operated)"]
["Major Conventional","$/light Nominal",{"$f":"C142","v":92.661548944196895},{"$f":"D142","v":94.374771158145805},96.552169369564908,99.078504666482004,102.33116954318135,null,"Opex NPL2 is set equal to Opex NPL1"]
["Minor Conventional","$/light Nominal",61.77436596279793,62.916514105430537,64.368112913043277,66.052336444321341,68.220779695454226,null,"Opex NPL2 is set equal to Opex NPL1"]
["Major LED","$/light Nominal",81.81761275253595,49.681451874908561,47.735985298758912,48.579898461500434,50.419207241145905,null,"Opex NPL2 is set equal to Opex NPL1"]
["Minor LED","$/light Nominal",54.5450751683573,33.120967916605707,31.823990199172609,32.386598974333623,33.612804827430601,null,"Opex NPL2 is set equal to Opex NPL1"]
[]
["Capex Charge"]
["NPL1 (Energex Owned & Operated)"]
["Major Conventional","$/light Nominal",{"$f":"C$39*Million/(C$110+C$111/'Input Data'!$C$59)*(1-'Input Data'!$C$56)","v":133.92347188372102},{"$f":"D$39*Million/(D$110+D$111/'Input Data'!$C$59)*(1-'Input Data'!$C$56)","v":140.66001937765859},{"$f":"E$39*Million/(E$110+E$111/'Input Data'!$C$59)*(1-'Input Data'!$C$56)","v":155.20236381829406},{"$f":"F$39*Million/(F$110+F$111/'Input Data'!$C$59)*(1-'Input Data'!$C$56)","v":175.99617890124654},{"$f":"G$39*Million/(G$110+G$111/'Input Data'!$C$59)*(1-'Input Data'!$C$56)","v":208.26337872356748}]
["Minor Conventional","$/light Nominal",{"$f":"ROUND(C155/'Input Data'!$C$59,2)","v":74.400000000000006},{"$f":"ROUND(D155/'Input Data'!$C$59,2)","v":78.14},{"$f":"ROUND(E155/'Input Data'!$C$59,2)","v":86.22},{"$f":"ROUND(F155/'Input Data'!$C$59,2)","v":97.78},{"$f":"ROUND(G155/'Input Data'!$C$59,2)","v":115.7}]
["Major LED","$/light Nominal",{"$f":"C$40*Million/(C$112+C$113/'Input Data'!$C$59)*(1-'Input Data'!$C$56)","v":94.525949322164024},{"$f":"D$40*Million/(D$112+D$113/'Input Data'!$C$59)*(1-'Input Data'!$C$56)","v":172.63295573658908},{"$f":"E$40*Million/(E$112+E$113/'Input Data'!$C$59)*(1-'Input Data'!$C$56)","v":148.26940971834367},{"$f":"F$40*Million/(F$112+F$113/'Input Data'!$C$59)*(1-'Input Data'!$C$56)","v":137.00776248949393},{"$f":"G$40*Million/(G$112+G$113/'Input Data'!$C$59)*(1-'Input Data'!$C$56)","v":130.10277529998083}]
["Minor LED","$/light Nominal",{"$f":"ROUND(C157/'Input Data'!$C$59,2)","v":52.51},{"$f":"ROUND(D157/'Input Data'!$C$59,2)","v":95.91},{"$f":"ROUND(E157/'Input Data'!$C$59,2)","v":82.37},{"$f":"ROUND(F157/'Input Data'!$C$59,2)","v":76.12},{"$f":"ROUND(G157/'Input Data'!$C$59,2)","v":72.28}]
[]
["NPL2 (Gifted & Energex Operated)"]
["Major Conventional","$/light Nominal",0,0,0,0,0,null,"Capex is not allocated to NPL2"]
["Minor Conventional","$/light Nominal",0,0,0,0,0]
["Major LED","$/light Nominal",0,0,0,0,0]
["Minor LED","$/light Nominal",0,0,0,0,0]
[]
["Refurbishment Charge"]
["NPL1 (Energex Owned & Operated)"]
["Major Conventional","$/light Nominal",{"$f":"C$39*Million/(C$125+C$126/'Input Data'!$C$59)*'Input Data'!$C$56","v":6.6915431541903887},{"$f":"D$39*Million/(D$125+D$126/'Input Data'!$C$59)*'Input Data'!$C$56","v":7.0395694261730375},{"$f":"E$39*Million/(E$125+E$126/'Input Data'!$C$59)*'Input Data'!$C$56","v":7.7849962269056299},{"$f":"F$39*Million/(F$125+F$126/'Input Data'!$C$59)*'Input Data'!$C$56","v":8.8564886931079148},{"$f":"G$39*Million/(G$125+G$126/'Input Data'!$C$59)*'Input Data'!$C$56","v":10.529301114504079}]
["Minor Conventional","$/light Nominal",{"$f":"ROUND(C168/'Input Data'!$C$59,2)","v":3.72},{"$f":"ROUND(D168/'Input Data'!$C$59,2)","v":3.91},{"$f":"ROUND(E168/'Input Data'!$C$59,2)","v":4.32},{"$f":"ROUND(F168/'Input Data'!$C$59,2)","v":4.92},{"$f":"ROUND(G168/'Input Data'!$C$59,2)","v":5.85}]
["Major LED","$/light Nominal",{"$f":"C$40*Million/(C$125+C$126/'Input Data'!$C$59)*'Input Data'!$C$56","v":0.43966663461160582},{"$f":"D$40*Million/(D$125+D$126/'Input Data'!$C$59)*'Input Data'!$C$56","v":1.4027818181365022},{"$f":"E$40*Million/(E$125+E$126/'Input Data'!$C$59)*'Input Data'!$C$56","v":2.209077612041829},{"$f":"F$40*Million/(F$125+F$126/'Input Data'!$C$59)*'Input Data'!$C$56","v":3.3547747366434231},{"$f":"G$40*Million/(G$125+G$126/'Input Data'!$C$59)*'Input Data'!$C$56","v":5.0998698170446692}]
["Minor LED","$/light Nominal",{"$f":"ROUND(C170/'Input Data'!$C$59,2)","v":0.24},{"$f":"ROUND(D170/'Input Data'!$C$59,2)","v":0.78},{"$f":"ROUND(E170/'Input Data'!$C$59,2)","v":1.23},{"$f":"ROUND(F170/'Input Data'!$C$59,2)","v":1.86},{"$f":"ROUND(G170/'Input Data'!$C$59,2)","v":2.83}]
[]
["NPL2 (Gifted & Energex Operated)"]
["Major Conventional","$/light Nominal",{"$f":"C168","v":6.6915431541903887},7.0395694261730375,7.7849962269056299,8.8564886931079148,10.529301114504079]
["Minor Conventional","$/light Nominal",3.72,3.91,4.32,4.92,5.85]
["Major LED","$/light Nominal",0.43966663461160582,1.4027818181365022,2.209077612041829,3.3547747366434231,5.0998698170446692]
["Minor LED","$/light Nominal",0.24,0.78,1.23,1.86,2.83]
[]
["Pricing Days in Year","#",365.25,365.25,365.25,365.25,365.25]
[]
["Unsmoothed Prices"]
[]
["NPL1 (Energex Owned & Operated)"]
["Major Conventional","$/day/light Nominal",{"$f":"SUM(C142,C155,C168)/C$179","v":0.63867642431788718},0.66276347696639959,0.71058050490010827,0.77736118346567129,0.87918918379535349]
["Minor Conventional","$/day/light Nominal",0.38300989996659257,0.39689668475134987,0.42411529887212396,0.46201871716446635,0.51956407856387188]
["Major LED","$/day/light Nominal",0.48400610187354298,0.61250428317490524,0.5426816499086774,0.51729619627005552,0.5082049345877383]
["Minor LED","$/day/light Nominal",0.29375790600508495,0.35540306068885885,0.3160136624207327,0.30216727987497227,0.29766681677599072]
[]
["NPL2 (Gifted & Energex Operated)"]
["Major Conventional","$/day/light Nominal",{"$f":"SUM(C148,C174)/C$179","v":0.27201394140557777},{"$f":"SUM(D148,D174)/D$179","v":0.27765733219526034},0.28565959095542925,0.29550990652865139,0.30899512842624344]
["Minor Conventional","$/day/light Nominal",0.17931380140396422,0.18296102424484745,0.18805780400559421,0.1943116671986895,0.20279474249268781]
["Major LED","$/day/light Nominal",0.22520815711744713,0.13986100942654364,0.13674212980369813,0.14218938589498659,0.15200294882461485]
["Minor LED","$/day/light Nominal",0.14999336117277837,9.2815791695019051E-2,9.0496893084661495E-2,9.3762077958476728E-2,9.9774961882082402E-2]
[]
["NPL4 (Gifted & Ergon Operated)"]
["Major LED","$/day/light Nominal",{"$f":"(C192*0.9)+((C186-C192)*0.7)","v":0.38384590273496949},{"$f":"(D192*0.9)+((D186-D192)*0.7)","v":0.45672520010774237},0.40722558089681382,0.39054521456803615,0.38614404397633978]
["Minor LED","$/day/light Nominal",{"$f":"(C193*0.9)+((C187-C193)*0.7)","v":0.23562920643811514},0.267345300821205,0.2393089423114452,0.23026951150417591,0.22832176411960997]
[]
[]
["Smoothed Prices"]
[]
["NPL1 (Energex Owned & Operated)"]
["Major Conventional","$/day/light Nominal",{"$f":"ROUND('Input Data'!C75*(1+'Input Data'!$C$62)*(1-'Input Data'!C$65),5)","v":0.84367000000000003},{"$f":"ROUND(C203*(1+'Input Data'!$C$62)*(1-'Input Data'!D$65),5)","v":0.86365999999999998},{"$f":"ROUND(D203*(1+'Input Data'!$C$62)*(1-'Input Data'!E$65),5)","v":0.88412999999999997},{"$f":"ROUND(E203*(1+'Input Data'!$C$62)*(1-'Input Data'!F$65),5)","v":0.90508},{"$f":"ROUND(F203*(1+'Input Data'!$C$62)*(1-'Input Data'!G$65),5)","v":0.92652999999999996}]
["Minor Conventional","$/day/light Nominal",{"$f":"ROUND('Input Data'!C76*(1+'Input Data'!$C$62)*(1-'Input Data'!C$65),5)","v":0.38773999999999997},{"$f":"ROUND(C204*(1+'Input Data'!$C$62)*(1-'Input Data'!D$65),5)","v":0.39693000000000001},{"$f":"ROUND(D204*(1+'Input Data'!$C$62)*(1-'Input Data'!E$65),5)","v":0.40633999999999998},{"$f":"ROUND(E204*(1+'Input Data'!$C$62)*(1-'Input Data'!F$65),5)","v":0.41597000000000001},{"$f":"ROUND(F204*(1+'Input Data'!$C$62)*(1-'Input Data'!G$65),5)","v":0.42582999999999999}]
["Major LED","$/day/light Nominal",{"$f":"ROUND(C186*(1-'Input Data'!$C$66),5)","v":0.42425000000000002},{"$f":"ROUND(C205*(1+'Input Data'!$C$62)*(1-'Input Data'!D$66),5)","v":0.43430000000000002},{"$f":"ROUND(D205*(1+'Input Data'!$C$62)*(1-'Input Data'!E$66),5)","v":0.44458999999999999},{"$f":"ROUND(E205*(1+'Input Data'!$C$62)*(1-'Input Data'!F$66),5)","v":0.45512999999999998},{"$f":"ROUND(F205*(1+'Input Data'!$C$62)*(1-'Input Data'!G$66),5)","v":0.46592}]
["Minor LED","$/day/light Nominal",{"$f":"ROUND(C187*(1-'Input Data'!$C$66),5)","v":0.25749},{"$f":"ROUND(C206*(1+'Input Data'!$C$62)*(1-'Input Data'!$D$66),5)","v":0.26358999999999999},{"$f":"ROUND(D206*(1+'Input Data'!$C$62)*(1-'Input Data'!$D$66),5)","v":0.26984000000000002},{"$f":"ROUND(E206*(1+'Input Data'!$C$62)*(1-'Input Data'!$D$66),5)","v":0.27623999999999999},{"$f":"ROUND(F206*(1+'Input Data'!$C$62)*(1-'Input Data'!$D$66),5)","v":0.28278999999999999}]
[]
["NPL2 (Gifted & Energex Operated)"]
["Major Conventional","$/day/light Nominal",{"$f":"ROUND('Input Data'!C79*(1+'Input Data'!$C$62)*(1-'Input Data'!C$65),5)","v":0.29324},{"$f":"ROUND(C209*(1+'Input Data'!$C$62)*(1-'Input Data'!D$65),5)","v":0.30019000000000001},{"$f":"ROUND(D209*(1+'Input Data'!$C$62)*(1-'Input Data'!E$65),5)","v":0.30730000000000002},{"$f":"ROUND(E209*(1+'Input Data'!$C$62)*(1-'Input Data'!F$65),5)","v":0.31458000000000003},{"$f":"ROUND(F209*(1+'Input Data'!$C$62)*(1-'Input Data'!G$65),5)","v":0.32203999999999999}]
["Minor Conventional","$/day/light Nominal",{"$f":"ROUND('Input Data'!C80*(1+'Input Data'!$C$62)*(1-'Input Data'!C$65),5)","v":0.14224000000000001},{"$f":"ROUND(C210*(1+'Input Data'!$C$62)*(1-'Input Data'!D$65),5)","v":0.14560999999999999},{"$f":"ROUND(D210*(1+'Input Data'!$C$62)*(1-'Input Data'!E$65),5)","v":0.14906},{"$f":"ROUND(E210*(1+'Input Data'!$C$62)*(1-'Input Data'!F$65),5)","v":0.15259},{"$f":"ROUND(F210*(1+'Input Data'!$C$62)*(1-'Input Data'!G$65),5)","v":0.15620999999999999}]
["Major LED","$/day/light Nominal",{"$f":"ROUND(C192*(1-'Input Data'!$C$66),5)","v":0.19739999999999999},{"$f":"ROUND(C211*(1+'Input Data'!$C$62)*(1-'Input Data'!D$66),5)","v":0.20208000000000001},{"$f":"ROUND(D211*(1+'Input Data'!$C$62)*(1-'Input Data'!E$66),5)","v":0.20687},{"$f":"ROUND(E211*(1+'Input Data'!$C$62)*(1-'Input Data'!F$66),5)","v":0.21177000000000001},{"$f":"ROUND(F211*(1+'Input Data'!$C$62)*(1-'Input Data'!G$66),5)","v":0.21679000000000001}]
["Minor LED","$/day/light Nominal",{"$f":"ROUND(C193*(1-'Input Data'!$C$66),5)","v":0.13148000000000001},{"$f":"ROUND(C212*(1+'Input Data'!$C$62)*(1-'Input Data'!D$66),5)","v":0.1346},{"$f":"ROUND(D212*(1+'Input Data'!$C$62)*(1-'Input Data'!E$66),5)","v":0.13779},{"$f":"ROUND(E212*(1+'Input Data'!$C$62)*(1-'Input Data'!F$66),5)","v":0.14105999999999999},{"$f":"ROUND(F212*(1+'Input Data'!$C$62)*(1-'Input Data'!G$66),5)","v":0.1444}]
[]
["NPL4 (Gifted & Ergon Operated)"]
["Major LED","$/day/light Nominal",{"$f":"(C211*0.9)+((C205-C211)*0.7)","v":0.336455},{"$f":"(D211*0.9)+((D205-D211)*0.7)","v":0.34442600000000001},0.35258699999999998,0.36094499999999996,0.369502]
["Minor LED","$/day/light Nominal",{"$f":"(C212*0.9)+((C206-C212)*0.7)","v":0.206539},{"$f":"(D212*0.9)+((D206-D212)*0.7)","v":0.21143299999999998},0.21644600000000003,0.22157999999999997,0.22683299999999998]
[]
["Recovered Revenue"]
["1 + WACC",null,{"$f":"1+'Input Data'!C63","v":1.0467341871983908},{"$f":"1+'Input Data'!D63","v":1.0454062602151422},{"$f":"1+'Input Data'!E63","v":1.0440783332318935},{"$f":"1+'Input Data'!F63","v":1.042750406248645},{"$f":"1+'Input Data'!G63","v":1.0414224792653963}]
["Recovered revenue Conventional","$M Nominal",{"$f":"(SUMPRODUCT(C203:C204,C110:C111)+SUMPRODUCT(C209:C210,C117:C118))*C179/Million","v":37.442366222733753},{"$f":"(SUMPRODUCT(D203:D204,D110:D111)+SUMPRODUCT(D209:D210,D117:D118))*D179/Million","v":36.598508991412501},{"$f":"(SUMPRODUCT(E203:E204,E110:E111)+SUMPRODUCT(E209:E210,E117:E118))*E179/Million","v":34.080868149772492},{"$f":"(SUMPRODUCT(F203:F204,F110:F111)+SUMPRODUCT(F209:F210,F117:F118))*F179/Million","v":30.885888012026253},{"$f":"(SUMPRODUCT(G203:G204,G110:G111)+SUMPRODUCT(G209:G210,G117:G118))*G179/Million","v":26.844560386721252}]
["NPV of recovered revenue Conventional","$M Nominal",{"$f":"SUMPRODUCT(C220:G220, C230:G230)","v":146.60891778146103}]
["NPV of revenue requirement Conventional","$M Nominal",{"$f":"SUMPRODUCT(C32:G32, C230:G230)","v":146.60884407939031}]
["Difference Conventional","$M Nominal",{"$f":"C221-C222","v":7.3702070721992641E-5}]
[]
["Recovered revenue LED","$M Nominal",{"$f":"(SUMPRODUCT(C205:C206,C112:C113)+SUMPRODUCT(C211:C212,C119:C120))*C179/Million","v":2.4627318229650004},{"$f":"(SUMPRODUCT(D205:D206,D112:D113)+SUMPRODUCT(D211:D212,D119:D120))*D179/Million","v":4.1091076923824996},{"$f":"(SUMPRODUCT(E205:E206,E112:E113)+SUMPRODUCT(E211:E212,E119:E120))*E179/Million","v":6.9033153938962499},{"$f":"(SUMPRODUCT(F205:F206,F112:F113)+SUMPRODUCT(F211:F212,F119:F120))*F179/Million","v":10.195869925124999},{"$f":"(SUMPRODUCT(G205:G206,G112:G113)+SUMPRODUCT(G211:G212,G119:G120))*G179/Million","v":14.10242284257}]
["NPV of recovered revenue LED","$M Nominal",{"$f":"SUMPRODUCT(C225:G225, C230:G230)","v":32.075196134396592}]
["NPV of revenue requirement LED","$M Nominal",{"$f":"SUMPRODUCT(C33:G33, C230:G230)","v":32.075243839788378}]
["Difference LED","$M Nominal",{"$f":"C226-C227","v":-4.7705391786223572E-5}]
[]
["Discount factor",null,{"$f":"1/PRODUCT($C219:C219)","v":0.95535238289725111},{"$f":"1/PRODUCT($C219:D219)","v":0.91385753008657311},{"$f":"1/PRODUCT($C219:E219)","v":0.87527678814842536},{"$f":"1/PRODUCT($C219:F219)","v":0.83939242114254764},{"$f":"1/PRODUCT($C219:G219)","v":0.80600566806916085}]

{"sheet":"Output Tables","index":3,"n_rows":11,"n_cols":11,"rows_kept":11,"cut":false,"hidden":false,"merged":[[9,1,10,1],[9,3,10,3],[9,5,10,5],[9,7,10,7],[9,9,10,9],[8,1,8,2],[8,3,8,4],[8,5,8,6],[8,7,8,8],[8,9,8,10],[2,7,2,8],[5,7,5,8],[2,9,2,10],[5,9,5,10],[2,1,2,2],[5,1,5,2],[2,3,2,4],[5,3,5,4],[2,5,2,6],[5,5,5,6],[0,1,0,2],[0,3,0,4],[0,5,0,6],[0,7,0,8],[0,9,0,10]]}
["Public Lighting Prices","2020-21",null,"2021-22",null,"2022-23",null,"2023-24",null,"2024-25"]
[null,"Conventional","LED","Conventional","LED","Conventional","LED","Conventional","LED","Conventional","LED"]
["NPL1 (Energex Owned & Operated)"]
["Major",{"$f":"'Public Lighting Pricing'!C203","v":0.84367000000000003},{"$f":"'Public Lighting Pricing'!C205","v":0.42425000000000002},{"$f":"'Public Lighting Pricing'!D203","v":0.86365999999999998},{"$f":"'Public Lighting Pricing'!D205","v":0.43430000000000002},{"$f":"'Public Lighting Pricing'!E203","v":0.88412999999999997},{"$f":"'Public Lighting Pricing'!E205","v":0.44458999999999999},{"$f":"'Public Lighting Pricing'!F203","v":0.90508},{"$f":"'Public Lighting Pricing'!F205","v":0.45512999999999998},{"$f":"'Public Lighting Pricing'!G203","v":0.92652999999999996},{"$f":"'Public Lighting Pricing'!G205","v":0.46592}]
["Minor",{"$f":"'Public Lighting Pricing'!C204","v":0.38773999999999997},{"$f":"'Public Lighting Pricing'!C206","v":0.25749},{"$f":"'Public Lighting Pricing'!D204","v":0.39693000000000001},{"$f":"'Public Lighting Pricing'!D206","v":0.26358999999999999},{"$f":"'Public Lighting Pricing'!E204","v":0.40633999999999998},{"$f":"'Public Lighting Pricing'!E206","v":0.26984000000000002},{"$f":"'Public Lighting Pricing'!F204","v":0.41597000000000001},{"$f":"'Public Lighting Pricing'!F206","v":0.27623999999999999},{"$f":"'Public Lighting Pricing'!G204","v":0.42582999999999999},{"$f":"'Public Lighting Pricing'!G206","v":0.28278999999999999}]
["NPL2 (Gifted & Energex Operated)"]
["Major",{"$f":"'Public Lighting Pricing'!C209","v":0.29324},{"$f":"'Public Lighting Pricing'!C211","v":0.19739999999999999},{"$f":"'Public Lighting Pricing'!D209","v":0.30019000000000001},{"$f":"'Public Lighting Pricing'!D211","v":0.20208000000000001},{"$f":"'Public Lighting Pricing'!E209","v":0.30730000000000002},{"$f":"'Public Lighting Pricing'!E211","v":0.20687},{"$f":"'Public Lighting Pricing'!F209","v":0.31458000000000003},{"$f":"'Public Lighting Pricing'!F211","v":0.21177000000000001},{"$f":"'Public Lighting Pricing'!G209","v":0.32203999999999999},{"$f":"'Public Lighting Pricing'!G211","v":0.21679000000000001}]
["Minor",{"$f":"'Public Lighting Pricing'!C210","v":0.14224000000000001},{"$f":"'Public Lighting Pricing'!C212","v":0.13148000000000001},{"$f":"'Public Lighting Pricing'!D210","v":0.14560999999999999},{"$f":"'Public Lighting Pricing'!D212","v":0.1346},{"$f":"'Public Lighting Pricing'!E210","v":0.14906},{"$f":"'Public Lighting Pricing'!E212","v":0.13779},{"$f":"'Public Lighting Pricing'!F210","v":0.15259},{"$f":"'Public Lighting Pricing'!F212","v":0.14105999999999999},{"$f":"'Public Lighting Pricing'!G210","v":0.15620999999999999},{"$f":"'Public Lighting Pricing'!G212","v":0.1444}]
["NPL4"]
["Major",null,{"$f":"'Public Lighting Pricing'!C215","v":0.336455},null,{"$f":"'Public Lighting Pricing'!D215","v":0.34442600000000001},null,{"$f":"'Public Lighting Pricing'!E215","v":0.35258699999999998},null,{"$f":"'Public Lighting Pricing'!F215","v":0.36094499999999996},null,{"$f":"'Public Lighting Pricing'!G215","v":0.369502}]
["Minor",null,{"$f":"'Public Lighting Pricing'!C216","v":0.206539},null,{"$f":"'Public Lighting Pricing'!D216","v":0.21143299999999998},null,{"$f":"'Public Lighting Pricing'!E216","v":0.21644600000000003},null,{"$f":"'Public Lighting Pricing'!F216","v":0.22157999999999997},null,{"$f":"'Public Lighting Pricing'!G216","v":0.22683299999999998}]

{"sheet":"Changes register","index":4,"n_rows":12,"n_cols":5,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
["Date ","Type of change ","Tab","Cell range","Description"]
["2019-09-10","Removal of PL contributed assets","Input Data","A66:G76","Customer contributions not used in the pricing model and not required.  In removing them, there is no impact on the calculations"]
["2019-09-10","Adjustments to quantities","Public Lighting Pricing","C155:G158","Removal of the contributed public lighting assets from the quantities used to calculate the Capex component of the NPL1 tariff"]
["2019-11-05","WACC","Input Data","C76:G76","Addition of discount rates for smoothing (WACC) for years 2 to 5 "]
["2019-11-08","Alignment to PTRM","Public Lighting Pricing","C10:G19","Removal of pro-rata allocation of tax builiding block for LED public lighting to Conventional public lighting"]
["2019-11-11","Simplified volumes","Input Data",null,"Volumes for Conventional: (SV) and (non SV) consolidated into a single volume "]
["2019-11-10","VBA ","VBA ",null,"Removed the VBA script and replace by 2 goalseek macros to calculate the z factors for conventional and LED lights"]
["2019-11-12","Smoothing formula for conventional lights","Public Lighting Pricing","C203:G203; C204:G204; C209:G209; C201:G210","Adjusted formula to comply with F&A: Pt-1*(1+CPI)*(1-X) for conventional lights"]
["2019-11-12","Smoothing formula for conventional lights","Public Lighting Pricing","C205:G205; C206:G206; C211:G211; C212:G212","Given there is no price in Pt-1 for LED, the above formula stat Pt: Pt*(1-X) in first year then it becomes Pt*(1+CPI)*(1-X)"]
["2019-11-11","Changes in volumes","Input data","C6:G16","Reflects updates in LED volumes"]
["2019-11-11","Changes in capex and opex","Public Lighting Pricing","C6:G29","Reflects updates to LED capex and opex "]
["2019-11-12","Change to formula","Public Lighting Pricing","C168:G168","Refurbishment capex was initially recovered from NPL1 volumes when it should have been allocated to NPL1 and NPL2. This had the effect to recover too much capex from NPL2 lights.  "]