{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Input Data","Public Lighting Pricing","Output Tables"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":6,"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":"Input Data","index":0,"n_rows":93,"n_cols":9,"rows_kept":93,"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","#",26804,24714,21939,18662,14876,null,"Source: Ergon PL Opex review model. Allocation between NPL1 and NPL2 based on the 2018-19 volume ratio"]
["Minor Conventional","#",69606,64108,56905,48458,38710,null,"Source: Ergon PL Opex review model. Allocation between NPL1 and NPL2 based on the 2018-19 volume ratio"]
["Major LED","#",1391,3827,6952,10582,14729,null,"Source: Ergon PL Opex review model. Allocation between NPL1 and NPL2 based on the 2018-19 volume ratio"]
["Minor LED","#",3419,9425,17153,26142,36445,null,"Source: Ergon PL Opex review model. Allocation between NPL1 and NPL2 based on the 2018-19 volume ratio"]
["Total","#",{"$f":"SUM(C6:C9)","v":101220},{"$f":"SUM(D6:D9)","v":102074},{"$f":"SUM(E6:E9)","v":102949},{"$f":"SUM(F6:F9)","v":103844},{"$f":"SUM(G6:G9)","v":104760}]
[]
["NPL2 (Gifted & Energex Operated)"]
["Major Conventional","#",13044,12027,10677,9082,7239,null,"Source: Ergon PL Opex review model. Allocation between NPL1 and NPL2 based on the 2018-19 volume ratio"]
["Minor Conventional","#",33873,31198,27692,23581,18837,null,"Source: Ergon PL Opex review model. Allocation between NPL1 and NPL2 based on the 2018-19 volume ratio"]
["Major LED","#",677,1863,3383,5150,7167,null,"Source: Ergon PL Opex review model. Allocation between NPL1 and NPL2 based on the 2018-19 volume ratio"]
["Minor LED","#",1664,4587,8347,12722,17735,null,"Source: Ergon PL Opex review model. Allocation between NPL1 and NPL2 based on the 2018-19 volume ratio"]
["Total","#",{"$f":"SUM(C13:C16)","v":49258},{"$f":"SUM(D13:D16)","v":49675},{"$f":"SUM(E13:E16)","v":50099},{"$f":"SUM(F13:F16)","v":50535},{"$f":"SUM(G13:G16)","v":50978}]
["Total Opening Lights","#",{"$f":"SUM(C10,C17)","v":150478},{"$f":"SUM(D10,D17)","v":151749},{"$f":"SUM(E10,E17)","v":153048},{"$f":"SUM(F10,F17)","v":154379},{"$f":"SUM(G10,G17)","v":155738}]
[]
["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","#",2087,2547,3035,3509,4010]
["Minor LED","#",5165,6325,7545,8723,10015]
["Total","#",{"$f":"SUM(C23:C26)","v":7252},{"$f":"SUM(D23:D26)","v":8872},{"$f":"SUM(E23:E26)","v":10580},{"$f":"SUM(F23:F26)","v":12232},{"$f":"SUM(G23:G26)","v":14025}]
[]
["NPL2 (Gifted & Energex Operated)"]
["Major Conventional","#",0,0,0,0,0]
["Minor Conventional","#",0,0,0,0,0]
["Major LED","#",1471,1717,1991,2258,2553]
["Minor LED","#",3580,4208,4899,5561,6335]
["Total","#",{"$f":"SUM(C30:C33)","v":5051},{"$f":"SUM(D30:D33)","v":5925},{"$f":"SUM(E30:E33)","v":6890},{"$f":"SUM(F30:F33)","v":7819},{"$f":"SUM(G30:G33)","v":8888}]
["Total Additions","#",{"$f":"SUM(C27,C34)","v":12303},{"$f":"SUM(D27,D34)","v":14797},{"$f":"SUM(E27,E34)","v":17470},{"$f":"SUM(F27,F34)","v":20051},{"$f":"SUM(G27,G34)","v":22913}]
[]
["Public Lights Disposals by Type"]
[]
["NPL1 (Energex Owned & Operated)"]
["Major Conventional","#",1927,2377,2865,3329,3820]
["Minor Conventional","#",5010,6150,7340,8498,9770]
["Major LED","#",0,0,0,0,0]
["Minor LED","#",0,0,0,0,0]
["Total","#",{"$f":"SUM(C40:C43)","v":6937},{"$f":"SUM(D40:D43)","v":8527},{"$f":"SUM(E40:E43)","v":10205},{"$f":"SUM(F40:F43)","v":11827},{"$f":"SUM(G40:G43)","v":13590}]
[]
["NPL2 (Gifted & Energex Operated)"]
["Major Conventional (SV)","#",669,816,980,1139,1315]
["Minor Conventional (SV)","#",1785,2159,2572,2967,3429]
["Major LED","#",0,0,0,0,0]
["Minor LED","#",0,0,0,0,0]
["Total","#",{"$f":"SUM(C47:C50)","v":2454},{"$f":"SUM(D47:D50)","v":2975},{"$f":"SUM(E47:E50)","v":3552},{"$f":"SUM(F47:F50)","v":4106},{"$f":"SUM(G47:G50)","v":4744}]
["Total Disposals","#",{"$f":"SUM(C44,C51)","v":9391},{"$f":"SUM(D44,D51)","v":11502},{"$f":"SUM(E44,E51)","v":13757},{"$f":"SUM(F44,F51)","v":15933},{"$f":"SUM(G44,G51)","v":18334}]
[]
["Closing Population Public Lights"]
[]
["NPL1 (Energex Owned & Operated)"]
["Major Conventional","#",{"$f":"C6+C23-C40","v":24877},{"$f":"D6+D23-D40","v":22337},19074,15333,11056]
["Minor Conventional","#",{"$f":"C7+C24-C41","v":64596},57958,49565,39960,28940]
["Major LED","#",{"$f":"C8+C25-C42","v":3478},6374,9987,14091,18739]
["Minor LED","#",{"$f":"C9+C26-C43","v":8584},15750,24698,34865,46460]
["Total","#",{"$f":"SUM(C57:C60)","v":101535},{"$f":"SUM(D57:D60)","v":102419},{"$f":"SUM(E57:E60)","v":103324},{"$f":"SUM(F57:F60)","v":104249},{"$f":"SUM(G57:G60)","v":105195}]
[]
["NPL2 (Gifted & Energex Operated)"]
["Major Conventional","#",{"$f":"C13+C30-C47","v":12375},{"$f":"D13+D30-D47","v":11211},9697,7943,5924]
["Minor Conventional","#",{"$f":"C14+C31-C48","v":32088},29039,25120,20614,15408]
["Major LED","#",{"$f":"C15+C32-C49","v":2148},3580,5374,7408,9720]
["Minor LED","#",{"$f":"C16+C33-C50","v":5244},8795,13246,18283,24070]
["Total","#",{"$f":"SUM(C64:C67)","v":51855},{"$f":"SUM(D64:D67)","v":52625},{"$f":"SUM(E64:E67)","v":53437},{"$f":"SUM(F64:F67)","v":54248},{"$f":"SUM(G64:G67)","v":55122}]
["Total Closing Lights","#",{"$f":"SUM(C61,C68)","v":153390},{"$f":"SUM(D61,D68)","v":155044},{"$f":"SUM(E61,E68)","v":156761},{"$f":"SUM(F61,F68)","v":158497},{"$f":"SUM(G61,G68)","v":160317}]
[]
[]
["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.2739900899011012E-2]
["Discount rate for smoothing","%",4.7284068405475013E-2,4.6002628135530035E-2,4.4721187865585064E-2,4.3439747595640094E-2,4.2158307325695123E-2]
["X factor (years 2 to 5)","%",0]
["P0 Conventional","%",0.29426954682903617]
["Z factor LED","%",0.10905958736175553]
[]
["% of PLAB associated with Poles, cabling and some residual brackets","%",0.7]
[]
["2019-20 Prices"]
["NPL1 (Energex Owned & Operated)"]
["Major",null,1.30966027082248]
["Minor",null,0.78027904865298836]
["NPL2 (Gifted & Energex Operated)"]
["Major",null,0.52887057530419268]
["Minor",null,0.34645262115254238]

{"sheet":"Public Lighting Pricing","index":1,"n_rows":161,"n_cols":9,"rows_kept":161,"cut":false,"hidden":false,"merged":[]}
["Public Lighting Price Calculations","Units",{"$f":"'Input Data'!C1","v":"2020-21"},{"$f":"'Input Data'!D1","v":"2021-22"},{"$f":"'Input Data'!E1","v":"2022-23"},{"$f":"'Input Data'!F1","v":"2023-24"},{"$f":"'Input Data'!G1","v":"2024-25"}]
[]
["Building Block Revenue - Linked to PL PTRM"]
[]
["Opex Charge"]
["O&M Conventional","$M Nominal",13.35396519368248,12.525380283429159,11.324940575620722,9.81830614945512,7.9803260458587415]
["O&M LED","$M Nominal",0.30314205691109702,0.90819664621755669,1.7849891301446035,2.9274277632202694,4.3750756094840417]
["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"]
["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"]
["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.78545987020018004,0.60594832331984017,0.45992642772695114,0.31768656111863286,0.19017096085982349]
["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":13.35396519368248},{"$f":"SUM(D6,D8,D11)+D6/(D6+D24+D25)*(D13+D14)","v":12.525380283429159},{"$f":"SUM(E6,E8,E11)+E6/(E6+E24+E25)*(E13+E14)","v":11.324940575620722},9.81830614945512,7.9803260458587415]
["Total Opex Charge LED","$M Nominal",{"$f":"SUM(C7,C9,C16)+C7/(C7+C28+C29)*(C18+C19)","v":0.93686966626163715},{"$f":"SUM(D7,D9,D16)+D7/(D7+D28+D29)*(D18+D19)","v":1.2576732738813605},2.0500862713887411,3.1130071930624665,4.4881947167852632]
[]
["Capex Charge Conventional","NPL4 Switch",1,1,1,1,1]
["Return on capital","$M Nominal",4.724747099404099,4.3231915992757459,3.9212694991428112,3.5177904203993253,3.1155874718404855]
["Return of capital","$M Nominal",6.5853755820274831,6.9547167984432443,7.3383608955645343,7.7355290557359817,8.1478637113586689]
["Total Capex Charge Conventional","$M Nominal",{"$f":"(SUM(C24,C25,C12)+(C24+25)/(C6+C24+25)*(C13+C14))*C23","v":11.310122681431583},{"$f":"(SUM(D24,D25,D12)+(D24+25)/(D6+D24+25)*(D13+D14))*D23","v":11.27790839771899},11.259630394707346,11.253319476135307,11.263451183199155]
["Capex Charge LED"]
["Return on capital","$M Nominal",3.0320247713514784E-2,0.3951026373412968,0.7705628885616933,1.1991400878857883,1.6728055561242954]
["Return of capital","$M Nominal",4.2260509342137695E-2,0.27139896936591174,0.54128889895109222,0.88478744733119663,1.307307116371454]
["Total Capex Charge LED","$M Nominal",{"$f":"(SUM(C28,C29,C17)+(C28+C29)/(C7+C28+C29)*(C18+C19))*C23","v":0.22431301790529248},{"$f":"(SUM(D28,D29,D17)+(D28+D29)/(D7+D28+D29)*(D18+D19))*D23","v":0.92297330236324482},1.5066810739955991,2.216034666493421,3.0571645260543514]
[]
["ARR for Conventional","$M Nominal",{"$f":"SUM(C20,C26)","v":24.664087875114063},{"$f":"SUM(D20,D26)","v":23.80328868114815},{"$f":"SUM(E20,E26)","v":22.584570970328066},{"$f":"SUM(F20,F26)","v":21.071625625590428},{"$f":"SUM(G20,G26)","v":19.243777229057898}]
["ARR for LED","$M Nominal",{"$f":"SUM(C21,C30)","v":1.1611826841669297},{"$f":"SUM(D21,D30)","v":2.1806465762446052},{"$f":"SUM(E21,E30)","v":3.5567673453843405},{"$f":"SUM(F21,F30)","v":5.3290418595558879},{"$f":"SUM(G21,G30)","v":7.5453592428396146}]
["ARR for Total","$M Nominal",{"$f":"SUM(C32:C33)","v":25.825270559280995},{"$f":"SUM(D32:D33)","v":25.983935257392755},26.141338315712407,26.400667485146315,26.789136471897514]
[]
["Opex and Capex Charge Components"]
["Opex Charge for Conventional Lights","$M Nominal",{"$f":"C20","v":13.35396519368248},12.525380283429159,11.324940575620722,9.81830614945512,7.9803260458587415]
["Opex Charge for LED","$M Nominal",0.93686966626163715,1.2576732738813605,2.0500862713887411,3.1130071930624665,4.4881947167852632]
["Capex Charge for Conventional Lights","$M Nominal",{"$f":"C26","v":11.310122681431583},{"$f":"D26","v":11.27790839771899},11.259630394707346,11.253319476135307,11.263451183199155]
["Capex Charge for LED","$M Nominal",{"$f":"C30","v":0.22431301790529248},{"$f":"D30","v":0.92297330236324482},1.5066810739955991,2.216034666493421,3.0571645260543514]
[]
["Public Lights Population"]
[]
["Average No of Lights by Tariff"]
["NPL1 (Energex Owned & Operated)"]
["Major Conventional","#",{"$f":"SUM('Input Data'!C6,'Input Data'!C57)/2","v":25840.5},{"$f":"SUM('Input Data'!D6,'Input Data'!D57)/2","v":23525.5},{"$f":"SUM('Input Data'!E6,'Input Data'!E57)/2","v":20506.5},{"$f":"SUM('Input Data'!F6,'Input Data'!F57)/2","v":16997.5},{"$f":"SUM('Input Data'!G6,'Input Data'!G57)/2","v":12966}]
["Minor Conventional","#",{"$f":"SUM('Input Data'!C7,'Input Data'!C58)/2","v":67101},{"$f":"SUM('Input Data'!D7,'Input Data'!D58)/2","v":61033},{"$f":"SUM('Input Data'!E7,'Input Data'!E58)/2","v":53235},{"$f":"SUM('Input Data'!F7,'Input Data'!F58)/2","v":44209},{"$f":"SUM('Input Data'!G7,'Input Data'!G58)/2","v":33825}]
["Major LED","#",{"$f":"SUM('Input Data'!C8,'Input Data'!C59)/2","v":2434.5},{"$f":"SUM('Input Data'!D8,'Input Data'!D59)/2","v":5100.5},{"$f":"SUM('Input Data'!E8,'Input Data'!E59)/2","v":8469.5},{"$f":"SUM('Input Data'!F8,'Input Data'!F59)/2","v":12336.5},{"$f":"SUM('Input Data'!G8,'Input Data'!G59)/2","v":16734}]
["Minor LED","#",{"$f":"SUM('Input Data'!C9,'Input Data'!C60)/2","v":6001.5},{"$f":"SUM('Input Data'!D9,'Input Data'!D60)/2","v":12587.5},{"$f":"SUM('Input Data'!E9,'Input Data'!E60)/2","v":20925.5},{"$f":"SUM('Input Data'!F9,'Input Data'!F60)/2","v":30503.5},{"$f":"SUM('Input Data'!G9,'Input Data'!G60)/2","v":41452.5}]
["Total","#",{"$f":"SUM(C46:C49)","v":101377.5},{"$f":"SUM(D46:D49)","v":102246.5},{"$f":"SUM(E46:E49)","v":103136.5},{"$f":"SUM(F46:F49)","v":104046.5},{"$f":"SUM(G46:G49)","v":104977.5}]
[]
["NPL2 (Gifted & Energex Operated)"]
["Major Conventional","#",{"$f":"SUM('Input Data'!C13,'Input Data'!C64)/2","v":12709.5},{"$f":"SUM('Input Data'!D13,'Input Data'!D64)/2","v":11619},{"$f":"SUM('Input Data'!E13,'Input Data'!E64)/2","v":10187},{"$f":"SUM('Input Data'!F13,'Input Data'!F64)/2","v":8512.5},{"$f":"SUM('Input Data'!G13,'Input Data'!G64)/2","v":6581.5}]
["Minor Conventional","#",{"$f":"SUM('Input Data'!C14,'Input Data'!C65)/2","v":32980.5},{"$f":"SUM('Input Data'!D14,'Input Data'!D65)/2","v":30118.5},{"$f":"SUM('Input Data'!E14,'Input Data'!E65)/2","v":26406},{"$f":"SUM('Input Data'!F14,'Input Data'!F65)/2","v":22097.5},{"$f":"SUM('Input Data'!G14,'Input Data'!G65)/2","v":17122.5}]
["Major LED","#",{"$f":"SUM('Input Data'!C15,'Input Data'!C66)/2","v":1412.5},{"$f":"SUM('Input Data'!D15,'Input Data'!D66)/2","v":2721.5},{"$f":"SUM('Input Data'!E15,'Input Data'!E66)/2","v":4378.5},{"$f":"SUM('Input Data'!F15,'Input Data'!F66)/2","v":6279},{"$f":"SUM('Input Data'!G15,'Input Data'!G66)/2","v":8443.5}]
["Minor LED","#",{"$f":"SUM('Input Data'!C16,'Input Data'!C67)/2","v":3454},{"$f":"SUM('Input Data'!D16,'Input Data'!D67)/2","v":6691},{"$f":"SUM('Input Data'!E16,'Input Data'!E67)/2","v":10796.5},{"$f":"SUM('Input Data'!F16,'Input Data'!F67)/2","v":15502.5},{"$f":"SUM('Input Data'!G16,'Input Data'!G67)/2","v":20902.5}]
["Total","#",{"$f":"SUM(C53:C56)","v":50556.5},{"$f":"SUM(D53:D56)","v":51150},{"$f":"SUM(E53:E56)","v":51768},{"$f":"SUM(F53:F56)","v":52391.5},{"$f":"SUM(G53:G56)","v":53050}]
["Grand total","#",{"$f":"SUM(C50,C57)","v":151934},{"$f":"SUM(D50,D57)","v":153396.5},154904.5,156438,158027.5]
[]
["Average No of Lights by Type"]
["Major Conventional","#",{"$f":"SUM(C46,C53)","v":38550},{"$f":"SUM(D46,D53)","v":35144.5},30693.5,25510,19547.5]
["Minor Conventional","#",{"$f":"SUM(C47,C54)","v":100081.5},91151.5,79641,66306.5,50947.5]
["Major LED","#",{"$f":"SUM(C48,C55)","v":3847},7822,12848,18615.5,25177.5]
["Minor LED","#",{"$f":"SUM(C49,C56)","v":9455.5},19278.5,31722,46006,62355]
["Total","#",{"$f":"SUM(C61:C64)","v":151934},{"$f":"SUM(D61:D64)","v":153396.5},{"$f":"SUM(E61:E64)","v":154904.5},{"$f":"SUM(F61:F64)","v":156438},{"$f":"SUM(G61:G64)","v":158027.5}]
[]
["Price Components"]
[]
["Opex Charge"]
["NPL1 (Energex Owned & Operated)"]
["Major Conventional","$/day/light Nominal",{"$f":"C37*10^6/(C61+C62/'Input Data'!$C$75)","v":126.85321877518481},{"$f":"D37*10^6/(D61+D62/'Input Data'!$C$75)","v":130.59219407439613},{"$f":"E37*10^6/(E61+E62/'Input Data'!$C$75)","v":135.16265046242842},{"$f":"F37*10^6/(F61+F62/'Input Data'!$C$75)","v":140.83626250156763},{"$f":"G37*10^6/(G61+G62/'Input Data'!$C$75)","v":149.13012933162798}]
["Minor Conventional","$/day/light Nominal",{"$f":"C71/'Input Data'!$C$75","v":84.568812516789876},{"$f":"D71/'Input Data'!$C$75","v":87.061462716264089},{"$f":"E71/'Input Data'!$C$75","v":90.108433641618944},{"$f":"F71/'Input Data'!$C$75","v":93.890841667711754},{"$f":"G71/'Input Data'!$C$75","v":99.420086221085327}]
["Major LED","$/day/light Nominal",{"$f":"C38*10^6/(C63+C64/'Input Data'!$C$75)","v":92.296368014741589},{"$f":"D38*10^6/(D63+D64/'Input Data'!$C$75)","v":60.832591484515113},{"$f":"E38*10^6/(E63+E64/'Input Data'!$C$75)","v":60.303749599621753},{"$f":"F38*10^6/(F63+F64/'Input Data'!$C$75)","v":63.161885040003781},{"$f":"G38*10^6/(G63+G64/'Input Data'!$C$75)","v":67.241390565718021}]
["Minor LED","$/day/light Nominal",{"$f":"C73/'Input Data'!$C$75","v":61.530912009827723},{"$f":"D73/'Input Data'!$C$75","v":40.55506098967674},{"$f":"E73/'Input Data'!$C$75","v":40.202499733081169},{"$f":"F73/'Input Data'!$C$75","v":42.107923360002523},{"$f":"G73/'Input Data'!$C$75","v":44.827593710478681}]
[]
["NPL2 (Gifted & Energex Operated)"]
["Major Conventional","$/day/light Nominal",{"$f":"C71","v":126.85321877518481},{"$f":"D71","v":130.59219407439613},135.16265046242842,140.83626250156763,149.13012933162798]
["Minor Conventional","$/day/light Nominal",{"$f":"C72","v":84.568812516789876},87.061462716264089,90.108433641618944,93.890841667711754,99.420086221085327]
["Major LED","$/day/light Nominal",{"$f":"C73","v":92.296368014741589},60.832591484515113,60.303749599621753,63.161885040003781,67.241390565718021]
["Minor LED","$/day/light Nominal",{"$f":"C74","v":61.530912009827723},40.55506098967674,40.202499733081169,42.107923360002523,44.827593710478681]
[]
["Capex Charge"]
["NPL1 (Energex Owned & Operated)"]
["Major Conventional","$/day/light Nominal",{"$f":"C39*10^6/(C46+C47/'Input Data'!$C$76)*(1-'Input Data'!$C$73)","v":161.26898860015513},{"$f":"D39*10^6/(D46+D47/'Input Data'!$C$76)*(1-'Input Data'!$C$73)","v":176.73056691747317},{"$f":"E39*10^6/(E46+E47/'Input Data'!$C$76)*(1-'Input Data'!$C$73)","v":202.34352715546882},{"$f":"F39*10^6/(F46+F47/'Input Data'!$C$76)*(1-'Input Data'!$C$73)","v":243.7069635027197},{"$f":"G39*10^6/(G46+G47/'Input Data'!$C$76)*(1-'Input Data'!$C$73)","v":319.20185356436474}]
["Minor Conventional","$/day/light Nominal",{"$f":"C84/'Input Data'!$C$76","v":89.593882555641741},{"$f":"D84/'Input Data'!$C$76","v":98.183648287485084},{"$f":"E84/'Input Data'!$C$76","v":112.41307064192712},{"$f":"F84/'Input Data'!$C$76","v":135.39275750151094},{"$f":"G84/'Input Data'!$C$76","v":177.33436309131375}]
["Major LED","$/day/light Nominal",{"$f":"C40*10^6/(C48+C49/'Input Data'!$C$76)*(1-'Input Data'!$C$73)","v":34.996252649040201},{"$f":"D40*10^6/(D48+D49/'Input Data'!$C$76)*(1-'Input Data'!$C$73)","v":68.687489656036121},{"$f":"E40*10^6/(E48+E49/'Input Data'!$C$76)*(1-'Input Data'!$C$73)","v":67.480864013117582},{"$f":"F40*10^6/(F48+F49/'Input Data'!$C$76)*(1-'Input Data'!$C$73)","v":68.109099734379242},{"$f":"G40*10^6/(G48+G49/'Input Data'!$C$76)*(1-'Input Data'!$C$73)","v":69.19589922287166}]
["Minor LED","$/day/light Nominal",{"$f":"C86/'Input Data'!$C$76","v":19.442362582800111},{"$f":"D86/'Input Data'!$C$76","v":38.159716475575621},{"$f":"E86/'Input Data'!$C$76","v":37.489368896176437},{"$f":"F86/'Input Data'!$C$76","v":37.838388741321801},{"$f":"G86/'Input Data'!$C$76","v":38.442166234928699}]
[]
["NPL2 (Gifted & Energex Operated)"]
["Major Conventional","$/day/light Nominal",0,0,0,0,0,null,"Capex is not allocated to NPL2"]
["Minor Conventional","$/day/light Nominal",0,0,0,0,0]
["Major LED","$/day/light Nominal",0,0,0,0,0]
["Minor LED","$/day/light Nominal",0,0,0,0,0]
[]
["Refurbishment Charge"]
["NPL1 (Energex Owned & Operated)"]
["Major Conventional","$/day/light Nominal",{"$f":"C39*10^6/(C61+C62/'Input Data'!$C$76)*'Input Data'!$C$73","v":12.012769596408157},{"$f":"D39*10^6/(D61+D62/'Input Data'!$C$76)*'Input Data'!$C$73","v":13.146832955486625},{"$f":"E39*10^6/(E61+E62/'Input Data'!$C$76)*'Input Data'!$C$73","v":15.025161158426371},{"$f":"F39*10^6/(F61+F62/'Input Data'!$C$76)*'Input Data'!$C$73","v":18.049512412212618},{"$f":"G39*10^6/(G61+G62/'Input Data'!$C$76)*'Input Data'!$C$73","v":23.53826306962312}]
["Minor Conventional","$/day/light Nominal",{"$f":"C97/'Input Data'!$C$76","v":6.6737608868934206},{"$f":"D97/'Input Data'!$C$76","v":7.3037960863814577},{"$f":"E97/'Input Data'!$C$76","v":8.3473117546813178},{"$f":"F97/'Input Data'!$C$76","v":10.027506895673676},{"$f":"G97/'Input Data'!$C$76","v":13.076812816457288}]
["Major LED","$/day/light Nominal",{"$f":"C40*10^6/(C63+C64/'Input Data'!$C$76)*'Input Data'!$C$73","v":2.464963170124276},{"$f":"D40*10^6/(D63+D64/'Input Data'!$C$76)*'Input Data'!$C$73","v":4.9803554286780143},{"$f":"E40*10^6/(E63+E64/'Input Data'!$C$76)*'Input Data'!$C$73","v":4.9445853173330097},{"$f":"F40*10^6/(F63+F64/'Input Data'!$C$76)*'Input Data'!$C$73","v":5.0165598715295792},{"$f":"G40*10^6/(G63+G64/'Input Data'!$C$76)*'Input Data'!$C$73","v":5.1106772233888558}]
["Minor LED","$/day/light Nominal",{"$f":"C99/'Input Data'!$C$76","v":1.3694239834023756},{"$f":"D99/'Input Data'!$C$76","v":2.7668641270433412},{"$f":"E99/'Input Data'!$C$76","v":2.7469918429627831},{"$f":"F99/'Input Data'!$C$76","v":2.7869777064053216},{"$f":"G99/'Input Data'!$C$76","v":2.8392651241049198}]
[]
["NPL2 (Gifted & Energex Operated)"]
["Major Conventional","$/day/light Nominal",{"$f":"C97","v":12.012769596408157},{"$f":"D97","v":13.146832955486625},15.025161158426371,18.049512412212618,23.53826306962312]
["Minor Conventional","$/day/light Nominal",{"$f":"C98","v":6.6737608868934206},7.3037960863814577,8.3473117546813178,10.027506895673676,13.076812816457288]
["Major LED","$/day/light Nominal",{"$f":"C99","v":2.464963170124276},4.9803554286780143,4.9445853173330097,5.0165598715295792,5.1106772233888558]
["Minor LED","$/day/light Nominal",{"$f":"C100","v":1.3694239834023756},2.7668641270433412,2.7469918429627831,2.7869777064053216,2.8392651241049198]
[]
[null,"2020-06-30",{"$f":"EOMONTH(B108,12)","v":"2021-06-30"},{"$f":"EOMONTH(C108,12)","v":"2022-06-30"},"2023-06-30","2024-06-30","2025-06-30"]
["Pricing Days in Year","#",{"$f":"C108-B108","v":365},{"$f":"D108-C108","v":365},365,366,365]
[]
[]
["Unsmoothed Prices"]
[]
["NPL1 (Energex Owned & Operated)"]
["Major Conventional","$/day/light Nominal",{"$f":"SUM(C71,C84,C97)/C$109","v":0.82228760814177559},{"$f":"SUM(D71,D84,D97)/D$109","v":0.8779988875270025},0.96583928431869492,1.0999801596079235,1.3475897149742899]
["Minor Conventional","$/day/light Nominal",{"$f":"SUM(C72,C85,C98)/C$109","v":0.49544234509404128},{"$f":"SUM(D72,D85,D98)/D$109","v":0.5275312523017277},0.57772278366637642,0.65385548105162938,0.79405825240782557]
["Major LED","$/day/light Nominal",{"$f":"SUM(C73,C86,C99)/C$109","v":0.35550022968193445},0.36849434676501169,0.36364164090430784,0.37237034056260271,0.38780264934788639]
["Minor LED","$/day/light Nominal",{"$f":"SUM(C74,C87,C100)/C$109","v":0.22559643445487726},0.22323737422546763,0.22038043964991891,0.22604723991182965,0.23591513717674603]
[]
["NPL2 (Gifted & Energex Operated)"]
["Major Conventional","$/day/light Nominal",{"$f":"SUM(C77,C90,C103)/C$109","v":0.38045476266189859},{"$f":"SUM(D77,D90,D103)/D$109","v":0.39380555350652807},0.41147345649549261,0.43411413910868918,0.47306408877055101]
["Minor Conventional","$/day/light Nominal",{"$f":"SUM(C78,C91,C104)/C$109","v":0.24997965316077614},0.25853495562368639,0.26974176820904183,0.28392991410761048,0.30821068229463733]
["Major LED","$/day/light Nominal",{"$f":"SUM(C79,C92,C105)/C$109","v":0.2596200854379887},0.18030944359778939,0.17876256141631441,0.18627990412987258,0.19822484325782708]
["Minor LED","$/day/light Nominal",{"$f":"SUM(C80,C93,C106)/C$109","v":0.17232968765268522},0.1186902057992331,0.117669839934367,0.12266366411586843,0.13059413379337972]
[]
["Smoothed Prices"]
[]
["NPL1 (Energex Owned & Operated)"]
["Major Conventional","$/day/light Nominal",{"$f":"'Input Data'!C89*(1+'Input Data'!$C$79)*(1-'Input Data'!$C$82)","v":0.94528487951413132},{"$f":"C129*(1-'Input Data'!$C$81)*(1+'Input Data'!$C$79)","v":0.96678056399561618},{"$f":"D129*(1-'Input Data'!$C$81)*(1+'Input Data'!$C$79)","v":0.98876505821196647},{"$f":"E129*(1-'Input Data'!$C$81)*(1+'Input Data'!$C$79)","v":1.0112494776481114},{"$f":"F129*(1-'Input Data'!$C$81)*(1+'Input Data'!$C$79)","v":1.034245190554006}]
["Minor Conventional","$/day/light Nominal",{"$f":"'Input Data'!C90*(1+'Input Data'!$C$79)*(1-'Input Data'!$C$82)","v":0.56318879248748199},{"$f":"C130*(1-'Input Data'!$C$81)*(1+'Input Data'!$C$79)","v":0.57599564981608098},{"$f":"D130*(1-'Input Data'!$C$81)*(1+'Input Data'!$C$79)","v":0.58909373381116015},{"$f":"E130*(1-'Input Data'!$C$81)*(1+'Input Data'!$C$79)","v":0.60248966693825434},{"$f":"F130*(1-'Input Data'!$C$81)*(1+'Input Data'!$C$79)","v":0.6161902222571084}]
["Major LED","$/day/light Nominal",{"$f":"C117*(1-'Input Data'!$C$83)","v":0.31672952132581339},{"$f":"C131*(1-'Input Data'!$C$81)*(1+'Input Data'!$C$79)","v":0.3239319192525536},{"$f":"D131*(1-'Input Data'!$C$81)*(1+'Input Data'!$C$79)","v":0.33129809899438312},{"$f":"E131*(1-'Input Data'!$C$81)*(1+'Input Data'!$C$79)","v":0.33883178493354615},{"$f":"F131*(1-'Input Data'!$C$81)*(1+'Input Data'!$C$79)","v":0.34653678614437}]
["Minor LED","$/day/light Nominal",{"$f":"C118*(1-'Input Data'!$C$83)","v":0.20099298040294503},{"$f":"C132*(1-'Input Data'!$C$81)*(1+'Input Data'!$C$79)","v":0.20556354085870485},{"$f":"D132*(1-'Input Data'!$C$81)*(1+'Input Data'!$C$79)","v":0.21023803540628161},{"$f":"E132*(1-'Input Data'!$C$81)*(1+'Input Data'!$C$79)","v":0.21501882749662321},{"$f":"F132*(1-'Input Data'!$C$81)*(1+'Input Data'!$C$79)","v":0.21990833432531798}]
[]
["NPL2 (Gifted & Energex Operated)"]
["Major Conventional","$/day/light Nominal",{"$f":"'Input Data'!C92*(1+'Input Data'!$C$79)*(1-'Input Data'!$C$82)","v":0.38172751299925273},{"$f":"C135*(1-'Input Data'!$C$81)*(1+'Input Data'!$C$79)","v":0.39040795881528167},{"$f":"D135*(1-'Input Data'!$C$81)*(1+'Input Data'!$C$79)","v":0.39928579710892637},{"$f":"E135*(1-'Input Data'!$C$81)*(1+'Input Data'!$C$79)","v":0.40836551656556597},{"$f":"F135*(1-'Input Data'!$C$81)*(1+'Input Data'!$C$79)","v":0.4176517079428404}]
["Minor Conventional","$/day/light Nominal",{"$f":"'Input Data'!C93*(1+'Input Data'!$C$79)*(1-'Input Data'!$C$82)","v":0.25006212033741004},{"$f":"C136*(1-'Input Data'!$C$81)*(1+'Input Data'!$C$79)","v":0.25574850817247929},{"$f":"D136*(1-'Input Data'!$C$81)*(1+'Input Data'!$C$79)","v":0.26156420390339136},{"$f":"E136*(1-'Input Data'!$C$81)*(1+'Input Data'!$C$79)","v":0.26751214797888317},{"$f":"F136*(1-'Input Data'!$C$81)*(1+'Input Data'!$C$79)","v":0.27359534771320454}]
["Major LED","$/day/light Nominal",{"$f":"C123*(1-'Input Data'!$C$83)","v":0.23130602604929795},{"$f":"C137*(1-'Input Data'!$C$81)*(1+'Input Data'!$C$79)","v":0.23656590215900306},{"$f":"D137*(1-'Input Data'!$C$81)*(1+'Input Data'!$C$79)","v":0.24194538733018392},{"$f":"E137*(1-'Input Data'!$C$81)*(1+'Input Data'!$C$79)","v":0.24744720146104512},{"$f":"F137*(1-'Input Data'!$C$81)*(1+'Input Data'!$C$79)","v":0.25307412630000692}]
["Minor LED","$/day/light Nominal",{"$f":"C124*(1-'Input Data'!$C$83)","v":0.15353548302710315},{"$f":"C138*(1-'Input Data'!$C$81)*(1+'Input Data'!$C$79)","v":0.15702686469562127},{"$f":"D138*(1-'Input Data'!$C$81)*(1+'Input Data'!$C$79)","v":0.16059764003728211},{"$f":"E138*(1-'Input Data'!$C$81)*(1+'Input Data'!$C$79)","v":0.16424961445634495},{"$f":"F138*(1-'Input Data'!$C$81)*(1+'Input Data'!$C$79)","v":0.16798463441178299}]
[]
["Recovered Revenue"]
[]
["Cumulative Discount Rate",null,{"$f":"(1+'Input Data'!C80)","v":1.0472840684054749},{"$f":"C142*(1+'Input Data'!D80)","v":1.0954618879565972},{"$f":"D142*(1+'Input Data'!E80)","v":1.1444522448474928},{"$f":"E142*(1+'Input Data'!F80)","v":1.1941669614989314},{"$f":"F142*(1+'Input Data'!G80)","v":1.2445110192599949}]
[]
["Recovered revenue Conventional","$M Nominal",{"$f":"(SUMPRODUCT(C129:C130,C46:C47)+SUMPRODUCT(C135:C136,C53:C54))*C109/10^6","v":27.490305208214377},{"$f":"(SUMPRODUCT(D129:D130,D46:D47)+SUMPRODUCT(D135:D136,D53:D54))*D109/10^6","v":25.600242312185529},{"$f":"(SUMPRODUCT(E129:E130,E46:E47)+SUMPRODUCT(E135:E136,E53:E54))*E109/10^6","v":22.852980094715075},{"$f":"(SUMPRODUCT(F129:F130,F46:F47)+SUMPRODUCT(F135:F136,F53:F54))*F109/10^6","v":19.47549677841128},{"$f":"(SUMPRODUCT(G129:G130,G46:G47)+SUMPRODUCT(G135:G136,G53:G54))*G109/10^6","v":15.215414989949506}]
["NPV of recovered revenue Conventional","$M Nominal",{"$f":"SUM(C144/C$142,D144/D$142,E144/E$142,F144/F$142,G144/G$142)","v":98.121860063945022}]
["NPV of revenue requirement Conventional","$M Nominal",{"$f":"SUM(C32/C$142,D32/D$142,E32/E$142,F32/F$142,G32/G$142)","v":98.121860063945036}]
["Difference Conventional","$M Nominal",{"$f":"C145-C146","v":0}]
[]
["Recovered revenue LED","$M Nominal",{"$f":"(SUMPRODUCT(C131:C132,C48:C49)+SUMPRODUCT(C137:C138,C55:C56))*C109/10^6","v":1.0345445797800685},{"$f":"(SUMPRODUCT(D131:D132,D48:D49)+SUMPRODUCT(D137:D138,D55:D56))*D109/10^6","v":2.1659927378754151},{"$f":"(SUMPRODUCT(E131:E132,E48:E49)+SUMPRODUCT(E137:E138,E55:E56))*E109/10^6","v":3.6494581788214027},{"$f":"(SUMPRODUCT(F131:F132,F48:F49)+SUMPRODUCT(F137:F138,F55:F56))*F109/10^6","v":5.4310102228381147},{"$f":"(SUMPRODUCT(G131:G132,G48:G49)+SUMPRODUCT(G137:G138,G55:G56))*G109/10^6","v":7.505431860170785}]
["NPV of recovered revenue LED","$M Nominal",{"$f":"SUM(C149/C$142,D149/D$142,E149/E$142,F149/F$142,G149/G$142)","v":16.732679222257726}]
["NPV of revenue requirement LED","$M Nominal",{"$f":"SUM(C33/C$142,D33/D$142,E33/E$142,F33/F$142,G33/G$142)","v":16.73267922225773}]
["Difference LED","$M Nominal",{"$f":"C150-C151","v":0}]
[]
[]
["Check Unsmoothed Prices"]
["Unsmoothed Prices X Volumes - Conventional",null,{"$f":"(SUMPRODUCT(C115:C116,C46:C47)+SUMPRODUCT(C121:C122,C53:C54))*C109/10^6","v":24.664087875114063},{"$f":"(SUMPRODUCT(D115:D116,D46:D47)+SUMPRODUCT(D121:D122,D53:D54))*D109/10^6","v":23.80328868114815},{"$f":"(SUMPRODUCT(E115:E116,E46:E47)+SUMPRODUCT(E121:E122,E53:E54))*E109/10^6","v":22.584570970328066},{"$f":"(SUMPRODUCT(F115:F116,F46:F47)+SUMPRODUCT(F121:F122,F53:F54))*F109/10^6","v":21.071625625590428},{"$f":"(SUMPRODUCT(G115:G116,G46:G47)+SUMPRODUCT(G121:G122,G53:G54))*G109/10^6","v":19.243777229057901}]
["Revenue requirement - Conventional",null,{"$f":"C32","v":24.664087875114063},{"$f":"D32","v":23.80328868114815},{"$f":"E32","v":22.584570970328066},{"$f":"F32","v":21.071625625590428},{"$f":"G32","v":19.243777229057898}]
["Check",null,{"$f":"C156-C157","v":0},{"$f":"D156-D157","v":0},0,0,0]
["Unsmoothed Prices X Volumes - LED",null,{"$f":"(SUMPRODUCT(C117:C118,C48:C49)+SUMPRODUCT(C123:C124,C55:C56))*C109/10^6","v":1.1611826841669295},{"$f":"(SUMPRODUCT(D117:D118,D48:D49)+SUMPRODUCT(D123:D124,D55:D56))*D109/10^6","v":2.1806465762446052},{"$f":"(SUMPRODUCT(E117:E118,E48:E49)+SUMPRODUCT(E123:E124,E55:E56))*E109/10^6","v":3.5567673453843414},{"$f":"(SUMPRODUCT(F117:F118,F48:F49)+SUMPRODUCT(F123:F124,F55:F56))*F109/10^6","v":5.3290418595558879},{"$f":"(SUMPRODUCT(G117:G118,G48:G49)+SUMPRODUCT(G123:G124,G55:G56))*G109/10^6","v":7.5453592428396146}]
["Revenue requirement - LED",null,{"$f":"C33","v":1.1611826841669297},{"$f":"D33","v":2.1806465762446052},{"$f":"E33","v":3.5567673453843405},{"$f":"F33","v":5.3290418595558879},{"$f":"G33","v":7.5453592428396146}]
["Check",null,{"$f":"C159-C160","v":0},{"$f":"D159-D160","v":0},{"$f":"E159-E160","v":0},{"$f":"F159-F160","v":0},{"$f":"G159-G160","v":0}]

{"sheet":"Output Tables","index":2,"n_rows":47,"n_cols":24,"rows_kept":47,"cut":false,"hidden":false,"merged":[[0,15,0,17],[0,18,0,20],[12,15,12,17],[12,18,12,20],[21,22,22,22],[14,22,14,23],[17,22,17,23],[20,22,20,23],[0,22,0,23],[2,22,2,23],[5,22,5,23],[8,22,8,23],[9,22,10,22],[2,1,2,2],[2,3,2,4],[2,5,2,6],[2,7,2,8],[2,9,2,10],[0,1,0,2],[0,3,0,4],[0,5,0,6],[0,7,0,8],[0,9,0,10],[8,1,8,2],[8,3,8,4],[8,5,8,6],[8,7,8,8],[8,9,8,10],[5,1,5,2],[5,3,5,4],[5,5,5,6],[5,7,5,8],[5,9,5,10],[21,9,22,9],[9,1,10,1],[9,3,10,3],[9,5,10,5],[9,7,10,7],[9,9,10,9],[14,1,14,2],[14,3,14,4],[14,5,14,6],[14,7,14,8],[14,9,14,10],[17,9,17,10],[32,1,32,2],[32,3,32,4],[32,5,32,6],[32,7,32,8],[32,9,32,10],[29,9,29,10],[17,3,17,4],[17,5,17,6],[17,7,17,8],[26,3,26,4],[26,5,26,6],[26,7,26,8],[26,9,26,10],[20,3,20,4],[20,5,20,6],[20,7,20,8],[20,9,20,10],[21,3,22,3],[21,5,22,5],[21,7,22,7],[29,3,29,4],[33,1,34,1],[33,3,34,3],[33,5,34,5],[33,7,34,7],[33,9,34,9],[29,5,29,6],[29,7,29,8],[17,1,17,2],[29,1,29,2],[26,1,26,2],[20,1,20,2],[21,1,22,1],[38,9,38,10],[41,1,41,2],[41,3,41,4],[41,5,41,6],[41,7,41,8],[41,9,41,10],[38,1,38,2],[38,3,38,4],[38,5,38,6],[38,7,38,8],[45,1,46,1],[45,3,46,3],[45,5,46,5],[45,7,46,7],[45,9,46,9],[44,1,44,2],[44,3,44,4],[44,5,44,6],[44,7,44,8],[44,9,44,10]]}
["Public Lighting Prices ($ Nominal)","2020-21",null,"2021-22",null,"2022-23",null,"2023-24",null,"2024-25",null,null,"LED Vs CON Prices",null,"2019-20",{"$f":"B1","v":"2020-21"},null,null,"Price Movement",null,null,null,"2020-21 Annual Prices"]
[null,"Conventional","LED","Conventional","LED","Conventional","LED","Conventional","LED","Conventional","LED",null,null,null,"All Lights","CON","LED","Average",{"$f":"P2","v":"CON"},{"$f":"Q2","v":"LED"},"Average",null,{"$f":"B2","v":"Conventional"},{"$f":"C2","v":"LED"}]
["NPL1 (Energex Owned & Operated)"]
["Major",{"$f":"ROUND('Public Lighting Pricing'!C129,5)","v":0.94528000000000001},{"$f":"ROUND('Public Lighting Pricing'!C131,5)","v":0.31673000000000001},{"$f":"ROUND('Public Lighting Pricing'!D129,5)","v":0.96677999999999997},{"$f":"ROUND('Public Lighting Pricing'!D131,5)","v":0.32393},{"$f":"ROUND('Public Lighting Pricing'!E129,5)","v":0.98877000000000004},{"$f":"ROUND('Public Lighting Pricing'!E131,5)","v":0.33129999999999998},{"$f":"ROUND('Public Lighting Pricing'!F129,5)","v":1.01125},{"$f":"ROUND('Public Lighting Pricing'!F131,5)","v":0.33883000000000002},{"$f":"ROUND('Public Lighting Pricing'!G129,5)","v":1.0342499999999999},{"$f":"ROUND('Public Lighting Pricing'!G131,5)","v":0.34654000000000001},null,{"$f":"C4/B4","v":0.33506474272173326},null,{"$f":"'Input Data'!C89","v":1.30966027082248},{"$f":"B4","v":0.94528000000000001},{"$f":"C4","v":0.31673000000000001},{"$f":"(B4*'Public Lighting Pricing'!C$46+C4*'Public Lighting Pricing'!C$48)/SUM('Public Lighting Pricing'!C$46,'Public Lighting Pricing'!C$48)","v":0.89116134482758624},{"$f":"P4/$O4-1","v":-0.27822503204868965},{"$f":"Q4/$O4-1","v":-0.75815865606040689},-0.3195476989861441,null,{"$f":"B4*'Public Lighting Pricing'!$C$109","v":345.02719999999999},{"$f":"C4*'Public Lighting Pricing'!$C$109","v":115.60645000000001}]
["Minor",{"$f":"ROUND('Public Lighting Pricing'!C130,5)","v":0.56318999999999997},{"$f":"ROUND('Public Lighting Pricing'!C132,5)","v":0.20099},{"$f":"ROUND('Public Lighting Pricing'!D130,5)","v":0.57599999999999996},{"$f":"ROUND('Public Lighting Pricing'!D132,5)","v":0.20555999999999999},{"$f":"ROUND('Public Lighting Pricing'!E130,5)","v":0.58909},{"$f":"ROUND('Public Lighting Pricing'!E132,5)","v":0.21024000000000001},{"$f":"ROUND('Public Lighting Pricing'!F130,5)","v":0.60248999999999997},{"$f":"ROUND('Public Lighting Pricing'!F132,5)","v":0.21501999999999999},{"$f":"ROUND('Public Lighting Pricing'!G130,5)","v":0.61619000000000002},{"$f":"ROUND('Public Lighting Pricing'!G132,5)","v":0.21990999999999999},null,{"$f":"C5/B5","v":0.35687778547204319},null,{"$f":"'Input Data'!C90","v":0.78027904865298836},{"$f":"B5","v":0.56318999999999997},{"$f":"C5","v":0.20099},{"$f":"(B5*'Public Lighting Pricing'!C$47+C5*'Public Lighting Pricing'!C$49)/SUM('Public Lighting Pricing'!C$47,'Public Lighting Pricing'!C$49)","v":0.53345444649635787},{"$f":"P5/$O5-1","v":-0.27821975872318194},{"$f":"Q5/$O5-1","v":-0.74241266589565214},{"$f":"R5/$O5-1","v":-0.31632862958800301},null,{"$f":"B5*'Public Lighting Pricing'!$C$109","v":205.56434999999999},{"$f":"C5*'Public Lighting Pricing'!$C$109","v":73.361350000000002}]
["NPL2 (Gifted & Energex Operated)"]
["Major",{"$f":"ROUND('Public Lighting Pricing'!C135,5)","v":0.38173000000000001},{"$f":"ROUND('Public Lighting Pricing'!C137,5)","v":0.23130999999999999},{"$f":"ROUND('Public Lighting Pricing'!D135,5)","v":0.39040999999999998},{"$f":"ROUND('Public Lighting Pricing'!D137,5)","v":0.23657},{"$f":"ROUND('Public Lighting Pricing'!E135,5)","v":0.39928999999999998},{"$f":"ROUND('Public Lighting Pricing'!E137,5)","v":0.24195},{"$f":"ROUND('Public Lighting Pricing'!F135,5)","v":0.40837000000000001},{"$f":"ROUND('Public Lighting Pricing'!F137,5)","v":0.24745},{"$f":"ROUND('Public Lighting Pricing'!G135,5)","v":0.41765000000000002},{"$f":"ROUND('Public Lighting Pricing'!G137,5)","v":0.25307000000000002},null,{"$f":"C7/B7","v":0.60595185078458591},null,{"$f":"'Input Data'!C92","v":0.52887057530419268},{"$f":"B7","v":0.38173000000000001},{"$f":"C7","v":0.23130999999999999},{"$f":"(B7*'Public Lighting Pricing'!C$53+C7*'Public Lighting Pricing'!C$55)/SUM('Public Lighting Pricing'!C$53,'Public Lighting Pricing'!C$55)","v":0.36668480456026065},{"$f":"P7/$O7-1","v":-0.27821660378734669},{"$f":"Q7/$O7-1","v":-0.56263401519935863},{"$f":"R7/$O7-1","v":-0.30666438693558806},null,{"$f":"B7*'Public Lighting Pricing'!$C$109","v":139.33145000000002},{"$f":"C7*'Public Lighting Pricing'!$C$109","v":84.428150000000002}]
["Minor",{"$f":"ROUND('Public Lighting Pricing'!C136,5)","v":0.25006},{"$f":"ROUND('Public Lighting Pricing'!C138,5)","v":0.15354000000000001},{"$f":"ROUND('Public Lighting Pricing'!D136,5)","v":0.25574999999999998},{"$f":"ROUND('Public Lighting Pricing'!D138,5)","v":0.15703},{"$f":"ROUND('Public Lighting Pricing'!E136,5)","v":0.26156000000000001},{"$f":"ROUND('Public Lighting Pricing'!E138,5)","v":0.16059999999999999},{"$f":"ROUND('Public Lighting Pricing'!F136,5)","v":0.26751000000000003},{"$f":"ROUND('Public Lighting Pricing'!F138,5)","v":0.16425000000000001},{"$f":"ROUND('Public Lighting Pricing'!G136,5)","v":0.27360000000000001},{"$f":"ROUND('Public Lighting Pricing'!G138,5)","v":0.16797999999999999},null,{"$f":"C8/B8","v":0.61401263696712793},null,{"$f":"'Input Data'!C93","v":0.34645262115254238},{"$f":"B8","v":0.25006},{"$f":"C8","v":0.15354000000000001},{"$f":"(B8*'Public Lighting Pricing'!C$54+C8*'Public Lighting Pricing'!C$56)/SUM('Public Lighting Pricing'!C$54,'Public Lighting Pricing'!C$56)","v":0.24090987909810757},{"$f":"P8/$O8-1","v":-0.27822742639923892},-0.55682251879284628,-0.3046383130349144,null,{"$f":"B8*'Public Lighting Pricing'!$C$109","v":91.271900000000002},{"$f":"C8*'Public Lighting Pricing'!$C$109","v":56.042100000000005}]
["NPL4"]
["Major",null,{"$f":"(C4-C7)*PLAB_NPL4+C7*0.9","v":0.26797300000000002},null,{"$f":"ROUND(C10*(1-'Input Data'!$C$81)*(1+'Input Data'!$C$79),5)","v":0.27406999999999998},null,{"$f":"ROUND(E10*(1-'Input Data'!$C$81)*(1+'Input Data'!$C$79),5)","v":0.28029999999999999},null,{"$f":"ROUND(G10*(1-'Input Data'!$C$81)*(1+'Input Data'!$C$79),5)","v":0.28666999999999998},null,{"$f":"ROUND(I10*(1-'Input Data'!$C$81)*(1+'Input Data'!$C$79),5)","v":0.29319000000000001},null,null,null,{"$f":"(O4*SUM('Public Lighting Pricing'!C$46,'Public Lighting Pricing'!C$48)+O5*SUM('Public Lighting Pricing'!C$47,'Public Lighting Pricing'!C$49)+O7*SUM('Public Lighting Pricing'!C$53,'Public Lighting Pricing'!C$55)+O8*SUM('Public Lighting Pricing'!C$54,'Public Lighting Pricing'!C$56))*'Public Lighting Pricing'!C$109/10^6","v":41.669324034543415},{"$f":"(P4*'Public Lighting Pricing'!C$46+P5*'Public Lighting Pricing'!C$47+P7*'Public Lighting Pricing'!C$53+P8*'Public Lighting Pricing'!C$54)*'Public Lighting Pricing'!C$109/10^6","v":27.490274772675001},{"$f":"(Q4*'Public Lighting Pricing'!C$48+Q5*'Public Lighting Pricing'!C$49+Q7*'Public Lighting Pricing'!C$55+Q8*'Public Lighting Pricing'!C$56)*'Public Lighting Pricing'!C$109/10^6","v":1.0345462198249999},{"$f":"SUM(P10:Q10)","v":28.5248209925},"Revenue",null,{"$f":"R10/O10-1","v":-0.31544795473876097},null,null,{"$f":"C10*'Public Lighting Pricing'!$C$109","v":97.810145000000006}]
["Minor",null,{"$f":"(C5-C8)*PLAB_NPL4+C8*0.9","v":0.171401},null,{"$f":"ROUND(C11*(1-'Input Data'!$C$81)*(1+'Input Data'!$C$79),5)","v":0.17530000000000001},null,{"$f":"ROUND(E11*(1-'Input Data'!$C$81)*(1+'Input Data'!$C$79),5)","v":0.17929},null,{"$f":"ROUND(G11*(1-'Input Data'!$C$81)*(1+'Input Data'!$C$79),5)","v":0.18337000000000001},null,{"$f":"ROUND(I11*(1-'Input Data'!$C$81)*(1+'Input Data'!$C$79),5)","v":0.18754000000000001},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"C11*'Public Lighting Pricing'!$C$109","v":62.561365000000002}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"O1","v":"2019-20"},{"$f":"P1","v":"2020-21"},null,null,"Price Movement"]
["Revised Submission Model",{"$f":"B2","v":"Conventional"},{"$f":"C2","v":"LED"},"Conventional","LED","Conventional","LED","Conventional","LED","Conventional","LED",null,null,null,"All Lights","CON","LED","Average",{"$f":"P14","v":"CON"},{"$f":"Q14","v":"LED"},{"$f":"R14","v":"Average"},null,{"$f":"B14","v":"Conventional"},{"$f":"C14","v":"LED"}]
[{"$f":"A3","v":"NPL1 (Energex Owned & Operated)"}]
[{"$f":"A4","v":"Major"},0.93642000000000003,0.39860000000000001,0.95860999999999996,0.40805000000000002,0.98133000000000004,0.41771999999999998,1.0045900000000001,0.42762,1.0284,0.43774999999999997,null,{"$f":"C16/B16","v":0.42566369791332948},null,{"$f":"O4","v":1.30966027082248},{"$f":"B16","v":0.93642000000000003},{"$f":"C16","v":0.39860000000000001},{"$f":"(B16*'Public Lighting Pricing'!C$46+C16*'Public Lighting Pricing'!C$48)/SUM('Public Lighting Pricing'!C$46,'Public Lighting Pricing'!C$48)","v":0.89011327002652529},{"$f":"P16/$O16-1","v":-0.2849901452596415},{"$f":"Q16/$O16-1","v":-0.69564626118674644},{"$f":"R16/$O16-1","v":-0.32034796362302032},null,{"$f":"B16*'Public Lighting Pricing'!$C$109","v":341.79329999999999},{"$f":"C16*'Public Lighting Pricing'!$C$109","v":145.489}]
["Minor",0.55791000000000002,0.25305,0.57113000000000003,0.25905,0.58467000000000002,0.26518999999999998,0.59853000000000001,0.27148,0.61272000000000004,0.27790999999999999,null,{"$f":"C17/B17","v":0.45356777974942192},null,{"$f":"O5","v":0.78027904865298836},{"$f":"B17","v":0.55791000000000002},{"$f":"C17","v":0.25305},{"$f":"(B17*'Public Lighting Pricing'!C$47+C17*'Public Lighting Pricing'!C$49)/SUM('Public Lighting Pricing'!C$47,'Public Lighting Pricing'!C$49)","v":0.53288189165897204},{"$f":"P17/$O17-1","v":-0.2849865686344758},-0.67569294544452352,-0.31706241173731764,null,{"$f":"B17*'Public Lighting Pricing'!$C$109","v":203.63715000000002},{"$f":"C17*'Public Lighting Pricing'!$C$109","v":92.363249999999994}]
["NPL2 (Gifted & Energex Operated)"]
["Major",0.37814999999999999,0.29189999999999999,0.38711000000000001,0.29881999999999997,0.39628000000000002,0.30590000000000001,0.40566999999999998,0.31314999999999998,0.41527999999999998,0.32057000000000002,null,{"$f":"C19/B19","v":0.77191590638635466},null,{"$f":"O7","v":0.52887057530419268},{"$f":"B19","v":0.37814999999999999},{"$f":"C19","v":0.29189999999999999},{"$f":"(B19*'Public Lighting Pricing'!C$53+C19*'Public Lighting Pricing'!C$55)/SUM('Public Lighting Pricing'!C$53,'Public Lighting Pricing'!C$55)","v":0.36952316775244298},{"$f":"P19/$O19-1","v":-0.28498574574223967},{"$f":"Q19/$O19-1","v":-0.4480691238454575},{"$f":"R19/$O19-1","v":-0.30129754800613961},null,{"$f":"B19*'Public Lighting Pricing'!$C$109","v":138.02474999999998},{"$f":"C19*'Public Lighting Pricing'!$C$109","v":106.54349999999999}]
["Minor",0.24772,0.19377,0.25358999999999998,0.19836000000000001,0.2596,0.20305999999999999,0.26574999999999999,0.20787,0.27205000000000001,0.21279999999999999,null,{"$f":"C20/B20","v":0.78221378976263523},null,0.34645262115254238,{"$f":"B20","v":0.24772},{"$f":"C20","v":0.19377},{"$f":"(B20*'Public Lighting Pricing'!C$54+C20*'Public Lighting Pricing'!C$56)/SUM('Public Lighting Pricing'!C$54,'Public Lighting Pricing'!C$56)","v":0.24260552608104957},{"$f":"P20/$O20-1","v":-0.28498159668727285},-0.44070274499472339,-0.29974400172244375,null,{"$f":"B20*'Public Lighting Pricing'!$C$109","v":90.4178},{"$f":"C20*'Public Lighting Pricing'!$C$109","v":70.726050000000001}]
["NPL4"]
["Major",null,0.33740000000000003,null,0.34539900000000001,null,0.35358400000000001,null,0.36196400000000001,null,0.37053899999999995,null,null,null,{"$f":"(O16*SUM('Public Lighting Pricing'!C$46,'Public Lighting Pricing'!C$48)+O17*SUM('Public Lighting Pricing'!C$47,'Public Lighting Pricing'!C$49)+O19*SUM('Public Lighting Pricing'!C$53,'Public Lighting Pricing'!C$55)+O20*SUM('Public Lighting Pricing'!C$54,'Public Lighting Pricing'!C$56))*'Public Lighting Pricing'!C$109/10^6","v":41.669324034543415},{"$f":"(P16*'Public Lighting Pricing'!C$46+P17*'Public Lighting Pricing'!C$47+P19*'Public Lighting Pricing'!C$53+P20*'Public Lighting Pricing'!C$54)*'Public Lighting Pricing'!C$109/10^6","v":27.232615983825003},{"$f":"(Q16*'Public Lighting Pricing'!C$48+Q17*'Public Lighting Pricing'!C$49+Q19*'Public Lighting Pricing'!C$55+Q20*'Public Lighting Pricing'!C$56)*'Public Lighting Pricing'!C$109/10^6","v":1.3032914858249998},{"$f":"SUM(P22:Q22)","v":28.535907469650002},"Revenue",null,{"$f":"R22/O22-1","v":-0.31518189625552728},null,null,{"$f":"C22*'Public Lighting Pricing'!$C$109","v":123.15100000000001}]
["Minor",null,0.215889,null,0.22100700000000001,null,0.22624499999999997,null,0.23160999999999998,null,0.237097,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"C23*'Public Lighting Pricing'!$C$109","v":78.799485000000004}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2018-19"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,39.304282909999998,"Actual Revenue"]
["Difference $",{"$f":"B14","v":"Conventional"},{"$f":"C14","v":"LED"},"Conventional","LED","Conventional","LED","Conventional","LED","Conventional","LED"]
[{"$f":"A15","v":"NPL1 (Energex Owned & Operated)"}]
[{"$f":"A16","v":"Major"},{"$f":"B4-B16","v":8.859999999999979E-3},{"$f":"C4-C16","v":-8.1869999999999998E-2},8.1700000000000106E-3,-8.4120000000000028E-2,7.4400000000000022E-3,-8.6419999999999997E-2,6.6599999999998882E-3,-8.878999999999998E-2,5.8499999999999108E-3,-9.1209999999999958E-2]
["Minor",{"$f":"B5-B17","v":5.2799999999999514E-3},-5.2059999999999995E-2,4.8699999999999299E-3,-5.349000000000001E-2,4.4199999999999795E-3,-5.4949999999999971E-2,3.9599999999999635E-3,-5.646000000000001E-2,3.4699999999999731E-3,-5.7999999999999996E-2]
["NPL2 (Gifted & Energex Operated)"]
["Major",{"$f":"B7-B19","v":3.5800000000000276E-3},{"$f":"C7-C19","v":-6.0590000000000005E-2},3.2999999999999696E-3,-6.2249999999999972E-2,3.0099999999999572E-3,-6.3950000000000007E-2,2.7000000000000357E-3,-6.5699999999999981E-2,2.3700000000000387E-3,-6.7500000000000004E-2]
["Minor",{"$f":"B8-B20","v":2.3400000000000087E-3},-4.0229999999999988E-2,2.1599999999999953E-3,-4.1330000000000006E-2,1.9600000000000173E-3,-4.2459999999999998E-2,1.7600000000000393E-3,-4.3619999999999992E-2,1.5499999999999958E-3,-4.4819999999999999E-2]
["NPL4"]
["Major",null,{"$f":"C10-C22","v":-6.9427000000000016E-2},null,-7.1329000000000031E-2,null,{"$f":"G10-G22","v":-7.3284000000000016E-2},null,{"$f":"I10-I22","v":-7.5294000000000028E-2},null,{"$f":"K10-K22","v":-7.7348999999999946E-2}]
["Minor",null,{"$f":"C11-C23","v":-4.4488E-2},null,-4.5706999999999998E-2,null,{"$f":"G11-G23","v":-4.6954999999999969E-2},null,{"$f":"I11-I23","v":-4.8239999999999977E-2},null,{"$f":"K11-K23","v":-4.955699999999999E-2}]
[]
[]
["Difference %",{"$f":"B26","v":"Conventional"},{"$f":"C26","v":"LED"},"Conventional","LED","Conventional","LED","Conventional","LED","Conventional","LED"]
[{"$f":"A27","v":"NPL1 (Energex Owned & Operated)"}]
[{"$f":"A28","v":"Major"},{"$f":"B28/B16","v":9.4615663911492478E-3},{"$f":"C28/C16","v":-0.20539387857501254},8.522756908440357E-3,-0.20615120695993144,7.5815474916694709E-3,-0.20688499473331418,6.6295702724493448E-3,-0.20763762218792381,5.6884480746790264E-3,-0.20836093660765267]
["Minor",{"$f":"B29/B17","v":9.4638920255954388E-3},-0.20573009286702232,8.5269553341619769E-3,-0.20648523451071224,7.5598200694408455E-3,-0.20720992495946294,6.6162097137987463E-3,-0.20797112126123476,5.6632719676197492E-3,-0.20870065848656039]
[{"$f":"A18","v":"NPL2 (Gifted & Energex Operated)"}]
[{"$f":"A19","v":"Major"},{"$f":"B31/B19","v":9.4671426682534122E-3},-0.20757108598835219,8.5247087391180018E-3,-0.20831938959908969,7.5956394468556501E-3,-0.20905524681268389,6.6556560751350503E-3,-0.20980360849433174,5.7069928722790382E-3,-0.210562435661478]
["Minor",{"$f":"B32/B20","v":9.4461488777652543E-3},-0.2076172782164421,8.5176860286288718E-3,-0.20835854002823151,7.5500770416025318E-3,-0.20910075839653305,6.6227657572908352E-3,-0.20984269014287774,5.6974820804998926E-3,-0.21062030075187971]
[{"$f":"A21","v":"NPL4"}]
[{"$f":"A22","v":"Major"},null,{"$f":"C34/C22","v":-0.20577059869590994},null,-0.20651188914849211,null,{"$f":"G34/G22","v":-0.20726050952531794},null,{"$f":"I34/I22","v":-0.20801516172879078},null,{"$f":"K34/K22","v":-0.20874725737371763}]
["Minor",null,{"$f":"C35/C23","v":-0.20606885946018555},null,-0.20681245390417496,null,{"$f":"G35/G23","v":-0.20754049813255529},null,{"$f":"I35/I23","v":-0.20828116229869167},null,{"$f":"K35/K23","v":-0.20901571930475707}]