{"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","#",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}]
[]
["Closing Population Public Lights"]
[]
["NPL1 (Energex Owned & Operated)"]
["Major Conventional","#",{"$f":"C6+C23-C40","v":37779},{"$f":"D6+D23-D40","v":35835},32242,28160,23454]
["Minor Conventional","#",{"$f":"C7+C24-C41","v":96663},91869,82985,72873,60860]
["Major LED","#",{"$f":"C8+C25-C42","v":4682},7346,11695,16564,22084]
["Minor LED","#",{"$f":"C9+C26-C43","v":12109},18709,29422,41409,55319]
["Total","#",{"$f":"SUM(C57:C60)","v":151233},{"$f":"SUM(D57:D60)","v":153759},{"$f":"SUM(E57:E60)","v":156344},{"$f":"SUM(F57:F60)","v":159006},{"$f":"SUM(G57:G60)","v":161717}]
[]
["NPL2 (Gifted & Energex Operated)"]
["Major Conventional","#",{"$f":"C13+C30-C47","v":45448},{"$f":"D13+D30-D47","v":42685},37839,32370,26094]
["Minor Conventional","#",{"$f":"C14+C31-C48","v":118752},112442,101073,88067,72714]
["Major LED","#",{"$f":"C15+C32-C49","v":8171},11779,17514,23896,31133]
["Minor LED","#",{"$f":"C16+C33-C50","v":18228},26727,40326,55603,73269]
["Total","#",{"$f":"SUM(C64:C67)","v":190599},{"$f":"SUM(D64:D67)","v":193633},{"$f":"SUM(E64:E67)","v":196752},{"$f":"SUM(F64:F67)","v":199936},{"$f":"SUM(G64:G67)","v":203210}]
["Total Closing Lights","#",{"$f":"SUM(C61,C68)","v":341832},{"$f":"SUM(D61,D68)","v":347392},{"$f":"SUM(E61,E68)","v":353096},{"$f":"SUM(F61,F68)","v":358942},{"$f":"SUM(G61,G68)","v":364927}]
[]
[]
["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","%",-4.9233506125303431E-2]
["Z factor LED","%",0.26742060942163315]
[]
["% of PLAB associated with Poles, cabling and some residual brackets","%",0.7]
[]
["2019-20 Prices"]
["NPL1 (Energex Owned & Operated)"]
["Major",null,0.86599999999999999]
["Minor",null,0.39800000000000002]
["NPL2 (Gifted & Energex Operated)"]
["Major",null,0.30099999999999999]
["Minor",null,0.14599999999999999]

{"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",25.233887034981588,24.533063304514052,22.829363072646764,20.72440570474744,18.175572902857756]
["O&M LED","$M Nominal",0.67138671502118119,1.3614391742503016,2.6295173251870971,4.2473317407674367,6.2673324947112947]
["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",2.0535771294107987,1.8159085818902305,1.6728212453033118,1.5449246047756078,1.47414215312654]
["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":25.233887034981588},{"$f":"SUM(D6,D8,D11)+D6/(D6+D24+D25)*(D13+D14)","v":24.533063304514052},{"$f":"SUM(E6,E8,E11)+E6/(E6+E24+E25)*(E13+E14)","v":22.829363072646764},20.72440570474744,18.175572902857756]
["Total Opex Charge LED","$M Nominal",{"$f":"SUM(C7,C9,C16)+C7/(C7+C28+C29)*(C18+C19)","v":2.136669349124273},{"$f":"SUM(D7,D9,D16)+D7/(D7+D28+D29)*(D18+D19)","v":2.3635535766602707},3.6078233194554681,5.1912382550643201,7.202640630059137]
[]
["Capex Charge Conventional","NPL4 Switch",1,1,1,1,1]
["Return on capital","$M Nominal",5.8881611392219941,5.4327309613444363,4.9740702683321496,4.5075820819858476,4.0401108514011019]
["Return of capital","$M Nominal",8.2795038345526688,8.7729317094693613,9.2869694190835066,9.8187987474581018,10.373625277704519]
["Total Capex Charge Conventional","$M Nominal",{"$f":"(SUM(C24,C25,C12)+(C24+25)/(C6+C24+25)*(C13+C14))*C23","v":14.167664973774663},{"$f":"(SUM(D24,D25,D12)+(D24+25)/(D6+D24+25)*(D13+D14))*D23","v":14.205662670813798},14.261039687415657,14.326380829443949,14.413736129105622]
["Capex Charge LED"]
["Return on capital","$M Nominal",0.1120282453396534,0.61985375239359686,1.0524746259230515,1.5033679187317772,1.9632719068134263]
["Return of capital","$M Nominal",0.15752596862361409,0.48573985354287386,0.81426225998226487,1.2010558497250428,1.6473584525860938]
["Total Capex Charge LED","$M Nominal",{"$f":"(SUM(C28,C29,C17)+(C28+C29)/(C7+C28+C29)*(C18+C19))*C23","v":0.85784870927097434},{"$f":"(SUM(D28,D29,D17)+(D28+D29)/(D7+D28+D29)*(D18+D19))*D23","v":1.9193877854167321},2.5612521369402574,3.3054418589355441,4.1494643771782176]
[]
["ARR for Conventional","$M Nominal",{"$f":"SUM(C20,C26)","v":39.401552008756255},{"$f":"SUM(D20,D26)","v":38.738725975327853},{"$f":"SUM(E20,E26)","v":37.090402760062418},{"$f":"SUM(F20,F26)","v":35.050786534191388},{"$f":"SUM(G20,G26)","v":32.589309031963381}]
["ARR for LED","$M Nominal",{"$f":"SUM(C21,C30)","v":2.9945180583952471},{"$f":"SUM(D21,D30)","v":4.2829413620770023},{"$f":"SUM(E21,E30)","v":6.169075456395726},{"$f":"SUM(F21,F30)","v":8.4966801139998651},{"$f":"SUM(G21,G30)","v":11.352105007237355}]
["ARR for Total","$M Nominal",{"$f":"SUM(C32:C33)","v":42.396070067151499},{"$f":"SUM(D32:D33)","v":43.021667337404857},43.259478216458142,43.547466648191254,43.941414039200737]
[]
["Opex and Capex Charge Components"]
["Opex Charge for Conventional Lights","$M Nominal",{"$f":"C20","v":25.233887034981588},24.533063304514052,22.829363072646764,20.72440570474744,18.175572902857756]
["Opex Charge for LED","$M Nominal",2.136669349124273,2.3635535766602707,3.6078233194554681,5.1912382550643201,7.202640630059137]
["Capex Charge for Conventional Lights","$M Nominal",{"$f":"C26","v":14.167664973774663},{"$f":"D26","v":14.205662670813798},14.261039687415657,14.326380829443949,14.413736129105622]
["Capex Charge for LED","$M Nominal",{"$f":"C30","v":0.85784870927097434},{"$f":"D30","v":1.9193877854167321},2.5612521369402574,3.3054418589355441,4.1494643771782176]
[]
["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":38785.5},{"$f":"SUM('Input Data'!D6,'Input Data'!D57)/2","v":37001},{"$f":"SUM('Input Data'!E6,'Input Data'!E57)/2","v":33592},{"$f":"SUM('Input Data'!F6,'Input Data'!F57)/2","v":29669},{"$f":"SUM('Input Data'!G6,'Input Data'!G57)/2","v":25153}]
["Minor Conventional","#",{"$f":"SUM('Input Data'!C7,'Input Data'!C58)/2","v":99467.5},{"$f":"SUM('Input Data'!D7,'Input Data'!D58)/2","v":95207},{"$f":"SUM('Input Data'!E7,'Input Data'!E58)/2","v":86952.5},{"$f":"SUM('Input Data'!F7,'Input Data'!F58)/2","v":77383.5},{"$f":"SUM('Input Data'!G7,'Input Data'!G58)/2","v":66098}]
["Major LED","#",{"$f":"SUM('Input Data'!C8,'Input Data'!C59)/2","v":3660.5},{"$f":"SUM('Input Data'!D8,'Input Data'!D59)/2","v":6145},{"$f":"SUM('Input Data'!E8,'Input Data'!E59)/2","v":10285},{"$f":"SUM('Input Data'!F8,'Input Data'!F59)/2","v":14970},{"$f":"SUM('Input Data'!G8,'Input Data'!G59)/2","v":20275}]
["Minor LED","#",{"$f":"SUM('Input Data'!C9,'Input Data'!C60)/2","v":9169.5},{"$f":"SUM('Input Data'!D9,'Input Data'!D60)/2","v":15211},{"$f":"SUM('Input Data'!E9,'Input Data'!E60)/2","v":25274.5},{"$f":"SUM('Input Data'!F9,'Input Data'!F60)/2","v":36693.5},{"$f":"SUM('Input Data'!G9,'Input Data'!G60)/2","v":49856}]
["Total","#",{"$f":"SUM(C46:C49)","v":151083},{"$f":"SUM(D46:D49)","v":153564},{"$f":"SUM(E46:E49)","v":156104},{"$f":"SUM(F46:F49)","v":158716},{"$f":"SUM(G46:G49)","v":161382}]
[]
["NPL2 (Gifted & Energex Operated)"]
["Major Conventional","#",{"$f":"SUM('Input Data'!C13,'Input Data'!C64)/2","v":47181},{"$f":"SUM('Input Data'!D13,'Input Data'!D64)/2","v":44801},{"$f":"SUM('Input Data'!E13,'Input Data'!E64)/2","v":40396},{"$f":"SUM('Input Data'!F13,'Input Data'!F64)/2","v":35347},{"$f":"SUM('Input Data'!G13,'Input Data'!G64)/2","v":29551}]
["Minor Conventional","#",{"$f":"SUM('Input Data'!C14,'Input Data'!C65)/2","v":122234},{"$f":"SUM('Input Data'!D14,'Input Data'!D65)/2","v":116789},{"$f":"SUM('Input Data'!E14,'Input Data'!E65)/2","v":106418},{"$f":"SUM('Input Data'!F14,'Input Data'!F65)/2","v":94367},{"$f":"SUM('Input Data'!G14,'Input Data'!G65)/2","v":80201.5}]
["Major LED","#",{"$f":"SUM('Input Data'!C15,'Input Data'!C66)/2","v":5708},{"$f":"SUM('Input Data'!D15,'Input Data'!D66)/2","v":8928},{"$f":"SUM('Input Data'!E15,'Input Data'!E66)/2","v":14212},{"$f":"SUM('Input Data'!F15,'Input Data'!F66)/2","v":20169},{"$f":"SUM('Input Data'!G15,'Input Data'!G66)/2","v":26916}]
["Minor LED","#",{"$f":"SUM('Input Data'!C16,'Input Data'!C67)/2","v":12943.5},{"$f":"SUM('Input Data'!D16,'Input Data'!D67)/2","v":20562.5},{"$f":"SUM('Input Data'!E16,'Input Data'!E67)/2","v":33148.5},{"$f":"SUM('Input Data'!F16,'Input Data'!F67)/2","v":47455.5},{"$f":"SUM('Input Data'!G16,'Input Data'!G67)/2","v":63919}]
["Total","#",{"$f":"SUM(C53:C56)","v":188066.5},{"$f":"SUM(D53:D56)","v":191080.5},{"$f":"SUM(E53:E56)","v":194174.5},{"$f":"SUM(F53:F56)","v":197338.5},{"$f":"SUM(G53:G56)","v":200587.5}]
["Grand total","#",{"$f":"SUM(C50,C57)","v":339149.5},{"$f":"SUM(D50,D57)","v":344644.5},350278.5,356054.5,361969.5]
[]
["Average No of Lights by Type"]
["Major Conventional","#",{"$f":"SUM(C46,C53)","v":85966.5},{"$f":"SUM(D46,D53)","v":81802},73988,65016,54704]
["Minor Conventional","#",{"$f":"SUM(C47,C54)","v":221701.5},211996,193370.5,171750.5,146299.5]
["Major LED","#",{"$f":"SUM(C48,C55)","v":9368.5},15073,24497,35139,47191]
["Minor LED","#",{"$f":"SUM(C49,C56)","v":22113},35773.5,58423,84149,113775]
["Total","#",{"$f":"SUM(C61:C64)","v":339149.5},{"$f":"SUM(D61:D64)","v":344644.5},{"$f":"SUM(E61:E64)","v":350278.5},{"$f":"SUM(F61:F64)","v":356054.5},{"$f":"SUM(G61:G64)","v":361969.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":107.94437650649294},{"$f":"D37*10^6/(D61+D62/'Input Data'!$C$75)","v":109.94832657633},{"$f":"E37*10^6/(E61+E62/'Input Data'!$C$75)","v":112.51441867232943},{"$f":"F37*10^6/(F61+F62/'Input Data'!$C$75)","v":115.44579437384959},{"$f":"G37*10^6/(G61+G62/'Input Data'!$C$75)","v":119.38998339994716}]
["Minor Conventional","$/day/light Nominal",{"$f":"C71/'Input Data'!$C$75","v":71.962917670995296},{"$f":"D71/'Input Data'!$C$75","v":73.298884384220003},{"$f":"E71/'Input Data'!$C$75","v":75.009612448219613},{"$f":"F71/'Input Data'!$C$75","v":76.963862915899725},{"$f":"G71/'Input Data'!$C$75","v":79.593322266631432}]
["Major LED","$/day/light Nominal",{"$f":"C38*10^6/(C63+C64/'Input Data'!$C$75)","v":88.619868900448878},{"$f":"D38*10^6/(D63+D64/'Input Data'!$C$75)","v":60.725388640364599},{"$f":"E38*10^6/(E63+E64/'Input Data'!$C$75)","v":56.864771212987513},{"$f":"F38*10^6/(F63+F64/'Input Data'!$C$75)","v":56.897556820755014},{"$f":"G38*10^6/(G63+G64/'Input Data'!$C$75)","v":58.538541055901177}]
["Minor LED","$/day/light Nominal",{"$f":"C73/'Input Data'!$C$75","v":59.079912600299252},{"$f":"D73/'Input Data'!$C$75","v":40.48359242690973},{"$f":"E73/'Input Data'!$C$75","v":37.909847475325009},{"$f":"F73/'Input Data'!$C$75","v":37.931704547170007},{"$f":"G73/'Input Data'!$C$75","v":39.025694037267449}]
[]
["NPL2 (Gifted & Energex Operated)"]
["Major Conventional","$/day/light Nominal",{"$f":"C71","v":107.94437650649294},{"$f":"D71","v":109.94832657633},112.51441867232943,115.44579437384959,119.38998339994716,null,"Opex NPL2 is set equal to Opex NPL1"]
["Minor Conventional","$/day/light Nominal",{"$f":"C72","v":71.962917670995296},73.298884384220003,75.009612448219613,76.963862915899725,79.593322266631432,null,"Opex NPL2 is set equal to Opex NPL1"]
["Major LED","$/day/light Nominal",{"$f":"C73","v":88.619868900448878},60.725388640364599,56.864771212987513,56.897556820755014,58.538541055901177,null,"Opex NPL2 is set equal to Opex NPL1"]
["Minor LED","$/day/light Nominal",{"$f":"C74","v":59.079912600299252},40.48359242690973,37.909847475325009,37.931704547170007,39.025694037267449,null,"Opex NPL2 is set equal to Opex NPL1"]
[]
["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":135.58262902784921},{"$f":"D39*10^6/(D46+D47/'Input Data'!$C$76)*(1-'Input Data'!$C$73)","v":142.22448671962434},{"$f":"E39*10^6/(E46+E47/'Input Data'!$C$76)*(1-'Input Data'!$C$73)","v":156.71674165935775},{"$f":"F39*10^6/(F46+F47/'Input Data'!$C$76)*(1-'Input Data'!$C$73)","v":177.45351392905599},{"$f":"G39*10^6/(G46+G47/'Input Data'!$C$76)*(1-'Input Data'!$C$73)","v":209.65735560871005}]
["Minor Conventional","$/day/light Nominal",{"$f":"C84/'Input Data'!$C$76","v":75.32368279324956},{"$f":"D84/'Input Data'!$C$76","v":79.013603733124626},{"$f":"E84/'Input Data'!$C$76","v":87.064856477420975},{"$f":"F84/'Input Data'!$C$76","v":98.585285516142207},{"$f":"G84/'Input Data'!$C$76","v":116.47630867150558}]
["Major LED","$/day/light Nominal",{"$f":"C40*10^6/(C48+C49/'Input Data'!$C$76)*(1-'Input Data'!$C$73)","v":88.188833194929586},{"$f":"D40*10^6/(D48+D49/'Input Data'!$C$76)*(1-'Input Data'!$C$73)","v":118.35445388151287},{"$f":"E40*10^6/(E48+E49/'Input Data'!$C$76)*(1-'Input Data'!$C$73)","v":94.758286311006955},{"$f":"F40*10^6/(F48+F49/'Input Data'!$C$76)*(1-'Input Data'!$C$73)","v":84.142958563087092},{"$f":"G40*10^6/(G48+G49/'Input Data'!$C$76)*(1-'Input Data'!$C$73)","v":77.846606189027483}]
["Minor LED","$/day/light Nominal",{"$f":"C86/'Input Data'!$C$76","v":48.993796219405326},{"$f":"D86/'Input Data'!$C$76","v":65.75247437861826},{"$f":"E86/'Input Data'!$C$76","v":52.643492395003861},{"$f":"F86/'Input Data'!$C$76","v":46.746088090603941},{"$f":"G86/'Input Data'!$C$76","v":43.248114549459714}]
[]
["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":6.7744436455930952},{"$f":"D39*10^6/(D61+D62/'Input Data'!$C$76)*'Input Data'!$C$73","v":7.1178658498297054},{"$f":"E39*10^6/(E61+E62/'Input Data'!$C$76)*'Input Data'!$C$73","v":7.8609578649164593},{"$f":"F39*10^6/(F61+F62/'Input Data'!$C$76)*'Input Data'!$C$73","v":8.9298247807232407},{"$f":"G39*10^6/(G61+G62/'Input Data'!$C$76)*'Input Data'!$C$73","v":10.599777270515197}]
["Minor Conventional","$/day/light Nominal",{"$f":"C97/'Input Data'!$C$76","v":3.7635798031072749},{"$f":"D97/'Input Data'!$C$76","v":3.9543699165720585},{"$f":"E97/'Input Data'!$C$76","v":4.3671988138424771},{"$f":"F97/'Input Data'!$C$76","v":4.9610137670684669},{"$f":"G97/'Input Data'!$C$76","v":5.8887651502862211}]
["Major LED","$/day/light Nominal",{"$f":"C40*10^6/(C63+C64/'Input Data'!$C$76)*'Input Data'!$C$73","v":3.9617092353244256},{"$f":"D40*10^6/(D63+D64/'Input Data'!$C$76)*'Input Data'!$C$73","v":5.4922557920767971},{"$f":"E40*10^6/(E63+E64/'Input Data'!$C$76)*'Input Data'!$C$73","v":4.4970364566596022},{"$f":"F40*10^6/(F63+F64/'Input Data'!$C$76)*'Input Data'!$C$73","v":4.0365180720682208},{"$f":"G40*10^6/(G63+G64/'Input Data'!$C$76)*'Input Data'!$C$73","v":3.7585955022477955}]
["Minor LED","$/day/light Nominal",{"$f":"C99/'Input Data'!$C$76","v":2.2009495751802364},{"$f":"D99/'Input Data'!$C$76","v":3.0512532178204426},{"$f":"E99/'Input Data'!$C$76","v":2.4983535870331122},{"$f":"F99/'Input Data'!$C$76","v":2.2425100400379003},{"$f":"G99/'Input Data'!$C$76","v":2.0881086123598864}]
[]
["NPL2 (Gifted & Energex Operated)"]
["Major Conventional","$/day/light Nominal",{"$f":"C97","v":6.7744436455930952},{"$f":"D97","v":7.1178658498297054},7.8609578649164593,8.9298247807232407,10.599777270515197]
["Minor Conventional","$/day/light Nominal",{"$f":"C98","v":3.7635798031072749},3.9543699165720585,4.3671988138424771,4.9610137670684669,5.8887651502862211]
["Major LED","$/day/light Nominal",{"$f":"C99","v":3.9617092353244256},5.4922557920767971,4.4970364566596022,4.0365180720682208,3.7585955022477955]
["Minor LED","$/day/light Nominal",{"$f":"C100","v":2.2009495751802364},3.0512532178204426,2.4983535870331122,2.2425100400379003,2.0881086123598864]
[]
[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.68575739501352118},{"$f":"SUM(D71,D84,D97)/D$109","v":0.71038542231721657},0.75915648820987314,0.82466976252357604,0.93054004460047235]
["Minor Conventional","$/day/light Nominal",{"$f":"SUM(C72,C85,C98)/C$109","v":0.41383611032151263},{"$f":"SUM(D72,D85,D98)/D$109","v":0.42812837817511423},0.45600456914926862,0.49319716447844369,0.55331067421485813]
["Major LED","$/day/light Nominal",{"$f":"SUM(C73,C86,C99)/C$109","v":0.49526140090603532},0.50567698168206654,0.42772628487850434,0.39638533731123038,0.38395545958130534]
["Minor LED","$/day/light Nominal",{"$f":"SUM(C74,C87,C100)/C$109","v":0.30212235176680768},0.2994173151324615,0.25493614645852597,0.23748716578637116,0.23112854027147139]
[]
["NPL2 (Gifted & Energex Operated)"]
["Major Conventional","$/day/light Nominal",{"$f":"SUM(C77,C90,C103)/C$109","v":0.31429813740297546},{"$f":"SUM(D77,D90,D103)/D$109","v":0.32072929431824582},0.32979555215683803,0.33982409605074543,0.3561363306040064]
["Minor Conventional","$/day/light Nominal",{"$f":"SUM(C78,C91,C104)/C$109","v":0.20746985609343171},0.21165275150901935,0.21747071578647148,0.22383846088242676,0.23419749977237714]
["Major LED","$/day/light Nominal",{"$f":"SUM(C79,C92,C105)/C$109","v":0.25364815927609125},0.18141820392449701,0.16811454156067701,0.1664865434230143,0.17067708646068211]
["Minor LED","$/day/light Nominal",{"$f":"SUM(C80,C93,C106)/C$109","v":0.16789277308350545},0.11927354971158952,0.11070740017084417,0.1097656136262511,0.11264055520445847]
[]
["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.92929851381652984},{"$f":"C129*(1-'Input Data'!$C$81)*(1+'Input Data'!$C$79)","v":0.95043066992631597},{"$f":"D129*(1-'Input Data'!$C$81)*(1+'Input Data'!$C$79)","v":0.97204336917182099},{"$f":"E129*(1-'Input Data'!$C$81)*(1+'Input Data'!$C$79)","v":0.99414753905632902},{"$f":"F129*(1-'Input Data'!$C$81)*(1+'Input Data'!$C$79)","v":1.0167543555734657}]
["Minor Conventional","$/day/light Nominal",{"$f":"'Input Data'!C90*(1+'Input Data'!$C$79)*(1-'Input Data'!$C$82)","v":0.42709100288565693},{"$f":"C130*(1-'Input Data'!$C$81)*(1+'Input Data'!$C$79)","v":0.43680300996613602},{"$f":"D130*(1-'Input Data'!$C$81)*(1+'Input Data'!$C$79)","v":0.44673586712515567},{"$f":"E130*(1-'Input Data'!$C$81)*(1+'Input Data'!$C$79)","v":0.45689459647161546},{"$f":"F130*(1-'Input Data'!$C$81)*(1+'Input Data'!$C$79)","v":0.4672843343166736}]
["Major LED","$/day/light Nominal",{"$f":"C117*(1-'Input Data'!$C$83)","v":0.36281829525273157},{"$f":"C131*(1-'Input Data'!$C$81)*(1+'Input Data'!$C$79)","v":0.37106874733112682},{"$f":"D131*(1-'Input Data'!$C$81)*(1+'Input Data'!$C$79)","v":0.37950681387215679},{"$f":"E131*(1-'Input Data'!$C$81)*(1+'Input Data'!$C$79)","v":0.38813676121010904},{"$f":"F131*(1-'Input Data'!$C$81)*(1+'Input Data'!$C$79)","v":0.39696295269529003}]
["Minor LED","$/day/light Nominal",{"$f":"C118*(1-'Input Data'!$C$83)","v":0.22132860833743095},{"$f":"C132*(1-'Input Data'!$C$81)*(1+'Input Data'!$C$79)","v":0.22636159895714017},{"$f":"D132*(1-'Input Data'!$C$81)*(1+'Input Data'!$C$79)","v":0.23150903928476721},{"$f":"E132*(1-'Input Data'!$C$81)*(1+'Input Data'!$C$79)","v":0.23677353189532807},{"$f":"F132*(1-'Input Data'!$C$81)*(1+'Input Data'!$C$79)","v":0.24215773854613665}]
[]
["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.323000984594429},{"$f":"C135*(1-'Input Data'!$C$81)*(1+'Input Data'!$C$79)","v":0.33034599497438927},{"$f":"D135*(1-'Input Data'!$C$81)*(1+'Input Data'!$C$79)","v":0.33785803016249205},{"$f":"E135*(1-'Input Data'!$C$81)*(1+'Input Data'!$C$79)","v":0.34554088828632218},{"$f":"F135*(1-'Input Data'!$C$81)*(1+'Input Data'!$C$79)","v":0.3533984538425094}]
["Minor Conventional","$/day/light Nominal",{"$f":"'Input Data'!C93*(1+'Input Data'!$C$79)*(1-'Input Data'!$C$82)","v":0.15667157392287914},{"$f":"C136*(1-'Input Data'!$C$81)*(1+'Input Data'!$C$79)","v":0.1602342699875775},{"$f":"D136*(1-'Input Data'!$C$81)*(1+'Input Data'!$C$79)","v":0.16387798140772039},{"$f":"E136*(1-'Input Data'!$C$81)*(1+'Input Data'!$C$79)","v":0.16760455046446193},{"$f":"F136*(1-'Input Data'!$C$81)*(1+'Input Data'!$C$79)","v":0.17141586133224709}]
["Major LED","$/day/light Nominal",{"$f":"C123*(1-'Input Data'!$C$83)","v":0.18581741394380347},{"$f":"C137*(1-'Input Data'!$C$81)*(1+'Input Data'!$C$79)","v":0.19004288352219606},{"$f":"D137*(1-'Input Data'!$C$81)*(1+'Input Data'!$C$79)","v":0.19436443986005308},{"$f":"E137*(1-'Input Data'!$C$81)*(1+'Input Data'!$C$79)","v":0.19878426796076248},{"$f":"F137*(1-'Input Data'!$C$81)*(1+'Input Data'!$C$79)","v":0.20330460251447266}]
["Minor LED","$/day/light Nominal",{"$f":"C124*(1-'Input Data'!$C$83)","v":0.12299478538802645},{"$f":"C138*(1-'Input Data'!$C$81)*(1+'Input Data'!$C$79)","v":0.1257916746188453},{"$f":"D138*(1-'Input Data'!$C$81)*(1+'Input Data'!$C$79)","v":0.12865216483359848},{"$f":"E138*(1-'Input Data'!$C$81)*(1+'Input Data'!$C$79)","v":0.13157770231235774},{"$f":"F138*(1-'Input Data'!$C$81)*(1+'Input Data'!$C$79)","v":0.13456976622346034}]
[]
["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":41.214005827242659},{"$f":"(SUMPRODUCT(D129:D130,D46:D47)+SUMPRODUCT(D135:D136,D53:D54))*D109/10^6","v":40.247462470168962},{"$f":"(SUMPRODUCT(E129:E130,E46:E47)+SUMPRODUCT(E135:E136,E53:E54))*E109/10^6","v":37.443656894688409},{"$f":"(SUMPRODUCT(F129:F130,F46:F47)+SUMPRODUCT(F135:F136,F53:F54))*F109/10^6","v":33.994679776739154},{"$f":"(SUMPRODUCT(G129:G130,G46:G47)+SUMPRODUCT(G135:G136,G53:G54))*G109/10^6","v":29.438005238852497}]
["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":160.93248648481909}]
["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":160.93248648481901}]
["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":2.1937222142951045},{"$f":"(SUMPRODUCT(D131:D132,D48:D49)+SUMPRODUCT(D137:D138,D55:D56))*D109/10^6","v":3.6524447362458976},{"$f":"(SUMPRODUCT(E131:E132,E48:E49)+SUMPRODUCT(E137:E138,E55:E56))*E109/10^6","v":6.1252243222647911},{"$f":"(SUMPRODUCT(F131:F132,F48:F49)+SUMPRODUCT(F137:F138,F55:F56))*F109/10^6","v":9.0591670205434642},{"$f":"(SUMPRODUCT(G131:G132,G48:G49)+SUMPRODUCT(G137:G138,G55:G56))*G109/10^6","v":12.481230351290089}]
["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":28.396143025760939}]
["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":28.396340022562065}]
["Difference LED","$M Nominal",{"$f":"C150-C151","v":-1.969968011259482E-4}]
[]
[]
["Check Unsmoothed Prices"]
["Unsmoothed Prices X Volumes - Conventional",null,{"$f":"(SUMPRODUCT(C115:C116,C46:C47)+SUMPRODUCT(C121:C122,C53:C54))*C109/10^6","v":39.401552008756248},{"$f":"(SUMPRODUCT(D115:D116,D46:D47)+SUMPRODUCT(D121:D122,D53:D54))*D109/10^6","v":38.738725975327853},{"$f":"(SUMPRODUCT(E115:E116,E46:E47)+SUMPRODUCT(E121:E122,E53:E54))*E109/10^6","v":37.090402760062418},{"$f":"(SUMPRODUCT(F115:F116,F46:F47)+SUMPRODUCT(F121:F122,F53:F54))*F109/10^6","v":35.050786534191388},{"$f":"(SUMPRODUCT(G115:G116,G46:G47)+SUMPRODUCT(G121:G122,G53:G54))*G109/10^6","v":32.589309031963381}]
["Revenue requirement - Conventional",null,{"$f":"C32","v":39.401552008756255},{"$f":"D32","v":38.738725975327853},{"$f":"E32","v":37.090402760062418},{"$f":"F32","v":35.050786534191388},{"$f":"G32","v":32.589309031963381}]
["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":2.9945180583952467},{"$f":"(SUMPRODUCT(D117:D118,D48:D49)+SUMPRODUCT(D123:D124,D55:D56))*D109/10^6","v":4.2829413620770032},{"$f":"(SUMPRODUCT(E117:E118,E48:E49)+SUMPRODUCT(E123:E124,E55:E56))*E109/10^6","v":6.1690754563957251},{"$f":"(SUMPRODUCT(F117:F118,F48:F49)+SUMPRODUCT(F123:F124,F55:F56))*F109/10^6","v":8.4966801139998616},{"$f":"(SUMPRODUCT(G117:G118,G48:G49)+SUMPRODUCT(G123:G124,G55:G56))*G109/10^6","v":11.352105007237355}]
["Revenue requirement - LED",null,{"$f":"C33","v":2.9945180583952471},{"$f":"D33","v":4.2829413620770023},{"$f":"E33","v":6.169075456395726},{"$f":"F33","v":8.4966801139998651},{"$f":"G33","v":11.352105007237355}]
["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":[[44,1,44,2],[44,3,44,4],[44,5,44,6],[44,7,44,8],[44,9,44,10],[45,1,46,1],[45,3,46,3],[45,5,46,5],[45,7,46,7],[45,9,46,9],[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],[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],[33,1,34,1],[33,3,34,3],[33,5,34,5],[33,7,34,7],[33,9,34,9],[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],[32,1,32,2],[32,3,32,4],[32,5,32,6],[32,7,32,8],[32,9,32,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],[5,1,5,2],[5,3,5,4],[5,5,5,6],[5,7,5,8],[5,9,5,10],[8,1,8,2],[8,3,8,4],[8,5,8,6],[8,7,8,8],[8,9,8,10],[0,1,0,2],[0,3,0,4],[0,5,0,6],[0,7,0,8],[0,9,0,10],[2,1,2,2],[2,3,2,4],[2,5,2,6],[2,7,2,8],[2,9,2,10],[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]]}
["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.92930000000000001},{"$f":"ROUND('Public Lighting Pricing'!C131,5)","v":0.36281999999999998},{"$f":"ROUND('Public Lighting Pricing'!D129,5)","v":0.95043},{"$f":"ROUND('Public Lighting Pricing'!D131,5)","v":0.37107000000000001},{"$f":"ROUND('Public Lighting Pricing'!E129,5)","v":0.97204000000000002},{"$f":"ROUND('Public Lighting Pricing'!E131,5)","v":0.37951000000000001},{"$f":"ROUND('Public Lighting Pricing'!F129,5)","v":0.99414999999999998},{"$f":"ROUND('Public Lighting Pricing'!F131,5)","v":0.38813999999999999},{"$f":"ROUND('Public Lighting Pricing'!G129,5)","v":1.01675},{"$f":"ROUND('Public Lighting Pricing'!G131,5)","v":0.39695999999999998},null,{"$f":"C4/B4","v":0.39042289895620358},null,{"$f":"'Input Data'!C89","v":0.86599999999999999},{"$f":"B4","v":0.92930000000000001},{"$f":"C4","v":0.36281999999999998},{"$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.88044733920746354},{"$f":"P4/$O4-1","v":7.3094688221708948E-2},{"$f":"Q4/$O4-1","v":-0.58103926096997693},1.6682839731482213E-2,null,{"$f":"B4*'Public Lighting Pricing'!$C$109","v":339.19450000000001},{"$f":"C4*'Public Lighting Pricing'!$C$109","v":132.42929999999998}]
["Minor",{"$f":"ROUND('Public Lighting Pricing'!C130,5)","v":0.42709000000000003},{"$f":"ROUND('Public Lighting Pricing'!C132,5)","v":0.22133},{"$f":"ROUND('Public Lighting Pricing'!D130,5)","v":0.43680000000000002},{"$f":"ROUND('Public Lighting Pricing'!D132,5)","v":0.22636000000000001},{"$f":"ROUND('Public Lighting Pricing'!E130,5)","v":0.44674000000000003},{"$f":"ROUND('Public Lighting Pricing'!E132,5)","v":0.23150999999999999},{"$f":"ROUND('Public Lighting Pricing'!F130,5)","v":0.45689000000000002},{"$f":"ROUND('Public Lighting Pricing'!F132,5)","v":0.23677000000000001},{"$f":"ROUND('Public Lighting Pricing'!G130,5)","v":0.46727999999999997},{"$f":"ROUND('Public Lighting Pricing'!G132,5)","v":0.24215999999999999},null,{"$f":"C5/B5","v":0.5182280081481655},null,{"$f":"'Input Data'!C90","v":0.39800000000000002},{"$f":"B5","v":0.42709000000000003},{"$f":"C5","v":0.22133},{"$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.40972283853567393},{"$f":"P5/$O5-1","v":7.3090452261306504E-2},{"$f":"Q5/$O5-1","v":-0.44389447236180912},{"$f":"R5/$O5-1","v":2.9454368180085178E-2},null,{"$f":"B5*'Public Lighting Pricing'!$C$109","v":155.88785000000001},{"$f":"C5*'Public Lighting Pricing'!$C$109","v":80.785449999999997}]
["NPL2 (Gifted & Energex Operated)"]
["Major",{"$f":"ROUND('Public Lighting Pricing'!C135,5)","v":0.32300000000000001},{"$f":"ROUND('Public Lighting Pricing'!C137,5)","v":0.18582000000000001},{"$f":"ROUND('Public Lighting Pricing'!D135,5)","v":0.33034999999999998},{"$f":"ROUND('Public Lighting Pricing'!D137,5)","v":0.19003999999999999},{"$f":"ROUND('Public Lighting Pricing'!E135,5)","v":0.33785999999999999},{"$f":"ROUND('Public Lighting Pricing'!E137,5)","v":0.19436},{"$f":"ROUND('Public Lighting Pricing'!F135,5)","v":0.34554000000000001},{"$f":"ROUND('Public Lighting Pricing'!F137,5)","v":0.19878000000000001},{"$f":"ROUND('Public Lighting Pricing'!G135,5)","v":0.35339999999999999},{"$f":"ROUND('Public Lighting Pricing'!G137,5)","v":0.20330000000000001},null,{"$f":"C7/B7","v":0.57529411764705884},null,{"$f":"'Input Data'!C92","v":0.30099999999999999},{"$f":"B7","v":0.32300000000000001},{"$f":"C7","v":0.18582000000000001},{"$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.30819496606099567},{"$f":"P7/$O7-1","v":7.3089700996677776E-2},{"$f":"Q7/$O7-1","v":-0.38265780730897003},{"$f":"R7/$O7-1","v":2.3903541730882605E-2},null,{"$f":"B7*'Public Lighting Pricing'!$C$109","v":117.89500000000001},{"$f":"C7*'Public Lighting Pricing'!$C$109","v":67.824300000000008}]
["Minor",{"$f":"ROUND('Public Lighting Pricing'!C136,5)","v":0.15667},{"$f":"ROUND('Public Lighting Pricing'!C138,5)","v":0.12299},{"$f":"ROUND('Public Lighting Pricing'!D136,5)","v":0.16023000000000001},{"$f":"ROUND('Public Lighting Pricing'!D138,5)","v":0.12579000000000001},{"$f":"ROUND('Public Lighting Pricing'!E136,5)","v":0.16388},{"$f":"ROUND('Public Lighting Pricing'!E138,5)","v":0.12864999999999999},{"$f":"ROUND('Public Lighting Pricing'!F136,5)","v":0.1676},{"$f":"ROUND('Public Lighting Pricing'!F138,5)","v":0.13158},{"$f":"ROUND('Public Lighting Pricing'!G136,5)","v":0.17141999999999999},{"$f":"ROUND('Public Lighting Pricing'!G138,5)","v":0.13457},null,{"$f":"C8/B8","v":0.7850258505138189},null,{"$f":"'Input Data'!C93","v":0.14599999999999999},{"$f":"B8","v":0.15667},{"$f":"C8","v":0.12299},{"$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.15344507662147916},{"$f":"P8/$O8-1","v":7.3082191780821981E-2},-0.15760273972602734,5.0993675489583445E-2,null,{"$f":"B8*'Public Lighting Pricing'!$C$109","v":57.184550000000002},{"$f":"C8*'Public Lighting Pricing'!$C$109","v":44.891350000000003}]
["NPL4"]
["Major",null,{"$f":"(C4-C7)*PLAB_NPL4+C7*0.9","v":0.29113800000000001},null,{"$f":"ROUND(C10*(1-'Input Data'!$C$81)*(1+'Input Data'!$C$79),5)","v":0.29776000000000002},null,{"$f":"ROUND(E10*(1-'Input Data'!$C$81)*(1+'Input Data'!$C$79),5)","v":0.30453000000000002},null,{"$f":"ROUND(G10*(1-'Input Data'!$C$81)*(1+'Input Data'!$C$79),5)","v":0.31145},null,{"$f":"ROUND(I10*(1-'Input Data'!$C$81)*(1+'Input Data'!$C$79),5)","v":0.31852999999999998},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":42.212712089999997},{"$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":41.213903279325002},{"$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":2.1937119295499996},{"$f":"SUM(P10:Q10)","v":43.407615208875001},"Revenue",null,{"$f":"R10/O10-1","v":2.8306712829239578E-2},null,null,{"$f":"C10*'Public Lighting Pricing'!$C$109","v":106.26537}]
["Minor",null,{"$f":"(C5-C8)*PLAB_NPL4+C8*0.9","v":0.17952899999999999},null,{"$f":"ROUND(C11*(1-'Input Data'!$C$81)*(1+'Input Data'!$C$79),5)","v":0.18361},null,{"$f":"ROUND(E11*(1-'Input Data'!$C$81)*(1+'Input Data'!$C$79),5)","v":0.18779000000000001},null,{"$f":"ROUND(G11*(1-'Input Data'!$C$81)*(1+'Input Data'!$C$79),5)","v":0.19206000000000001},null,{"$f":"ROUND(I11*(1-'Input Data'!$C$81)*(1+'Input Data'!$C$79),5)","v":0.19642999999999999},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"C11*'Public Lighting Pricing'!$C$109","v":65.528085000000004}]
[]
[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.84367000000000003,0.42425000000000002,0.86365999999999998,0.43430000000000002,0.88412999999999997,0.44458999999999999,0.90508,0.45512999999999998,0.92652999999999996,0.46592,null,{"$f":"C16/B16","v":0.50286249362902558},null,{"$f":"O4","v":0.86599999999999999},{"$f":"B16","v":0.84367000000000003},{"$f":"C16","v":0.42425000000000002},{"$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.80749964448946909},{"$f":"P16/$O16-1","v":-2.578521939953804E-2},{"$f":"Q16/$O16-1","v":-0.51010392609699773},{"$f":"R16/$O16-1","v":-6.755237356874233E-2},null,{"$f":"B16*'Public Lighting Pricing'!$C$109","v":307.93955},{"$f":"C16*'Public Lighting Pricing'!$C$109","v":154.85124999999999}]
["Minor",0.38773999999999997,0.25749,0.39693000000000001,0.26358999999999999,0.40633999999999998,0.26984000000000002,0.41597000000000001,0.27623999999999999,0.42582999999999999,0.28278999999999999,null,{"$f":"C17/B17","v":0.66407902202506841},null,{"$f":"O5","v":0.39800000000000002},{"$f":"B17","v":0.38773999999999997},{"$f":"C17","v":0.25749},{"$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.37674625592569749},{"$f":"P17/$O17-1","v":-2.5778894472361924E-2},-0.3530402010050252,-5.3401367020860624E-2,null,{"$f":"B17*'Public Lighting Pricing'!$C$109","v":141.52509999999998},{"$f":"C17*'Public Lighting Pricing'!$C$109","v":93.983850000000004}]
["NPL2 (Gifted & Energex Operated)"]
["Major",0.29324,0.19739999999999999,0.30019000000000001,0.20208000000000001,0.30730000000000002,0.20687,0.31458000000000003,0.21177000000000001,0.32203999999999999,0.21679000000000001,null,{"$f":"C19/B19","v":0.67316873550675216},null,{"$f":"O7","v":0.30099999999999999},{"$f":"B19","v":0.29324},{"$f":"C19","v":0.19739999999999999},{"$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.28289655013329806},{"$f":"P19/$O19-1","v":-2.578073089700994E-2},{"$f":"Q19/$O19-1","v":-0.34418604651162787},{"$f":"R19/$O19-1","v":-6.0144351716617694E-2},null,{"$f":"B19*'Public Lighting Pricing'!$C$109","v":107.0326},{"$f":"C19*'Public Lighting Pricing'!$C$109","v":72.051000000000002}]
["Minor",0.14224000000000001,0.13148000000000001,0.14560999999999999,0.1346,0.14906,0.13779,0.15259,0.14105999999999999,0.15620999999999999,0.1444,null,{"$f":"C20/B20","v":0.92435320584926894},null,0.14599999999999999,{"$f":"B20","v":0.14224000000000001},{"$f":"C20","v":0.13148000000000001},{"$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.14120970975199276},{"$f":"P20/$O20-1","v":-2.5753424657534163E-2},-9.945205479452035E-2,-3.2810207178131656E-2,null,{"$f":"B20*'Public Lighting Pricing'!$C$109","v":51.9176},{"$f":"C20*'Public Lighting Pricing'!$C$109","v":47.990200000000002}]
["NPL4"]
["Major",null,0.336455,null,0.34442600000000001,null,0.35258699999999998,null,0.36094499999999996,null,0.369502,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":42.212712089999997},{"$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":37.416738319775007},{"$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":2.4610461748999999},{"$f":"SUM(P22:Q22)","v":39.877784494675005},"Revenue",null,{"$f":"R22/O22-1","v":-5.5313375514626673E-2},null,null,{"$f":"C22*'Public Lighting Pricing'!$C$109","v":122.80607500000001}]
["Minor",null,0.206539,null,0.21143299999999998,null,0.21644600000000003,null,0.22157999999999997,null,0.22683299999999998,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"C23*'Public Lighting Pricing'!$C$109","v":75.386735000000002}]
[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,42.318282630000006,"Actual Revenue as per RIN"]
["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.5629999999999984E-2},{"$f":"C4-C16","v":-6.143000000000004E-2},8.6770000000000014E-2,-6.3230000000000008E-2,8.7910000000000044E-2,-6.5079999999999971E-2,8.9069999999999983E-2,-6.6989999999999994E-2,9.0220000000000078E-2,-6.8960000000000021E-2]
["Minor",{"$f":"B5-B17","v":3.9350000000000052E-2},-3.6159999999999998E-2,3.9870000000000017E-2,-3.7229999999999985E-2,4.0400000000000047E-2,-3.8330000000000031E-2,4.0920000000000012E-2,-3.9469999999999977E-2,4.1449999999999987E-2,-4.0629999999999999E-2]
["NPL2 (Gifted & Energex Operated)"]
["Major",{"$f":"B7-B19","v":2.9760000000000009E-2},{"$f":"C7-C19","v":-1.1579999999999979E-2},3.0159999999999965E-2,-1.2040000000000023E-2,3.0559999999999976E-2,-1.2509999999999993E-2,3.0959999999999988E-2,-1.2990000000000002E-2,3.1359999999999999E-2,-1.3490000000000002E-2]
["Minor",{"$f":"B8-B20","v":1.4429999999999998E-2},-8.4900000000000114E-3,1.4620000000000022E-2,-8.8099999999999845E-3,1.482E-2,-9.1400000000000092E-3,1.5009999999999996E-2,-9.4799999999999884E-3,1.5210000000000001E-2,-9.8300000000000054E-3]
["NPL4"]
["Major",null,{"$f":"C10-C22","v":-4.5316999999999996E-2},null,-4.6665999999999985E-2,null,{"$f":"G10-G22","v":-4.8056999999999961E-2},null,{"$f":"I10-I22","v":-4.9494999999999956E-2},null,{"$f":"K10-K22","v":-5.0972000000000017E-2}]
["Minor",null,{"$f":"C11-C23","v":-2.7010000000000006E-2},null,-2.7822999999999987E-2,null,{"$f":"G11-G23","v":-2.8656000000000015E-2},null,{"$f":"I11-I23","v":-2.9519999999999963E-2},null,{"$f":"K11-K23","v":-3.0402999999999986E-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":0.10149703082958975},{"$f":"C28/C16","v":-0.14479670005892761},0.10046777667137533,-0.14559060557218514,9.9431079139945533E-2,-0.14638205987539074,9.8411190171034585E-2,-0.14718871531210861,9.7374073154673974E-2,-0.14800824175824182]
["Minor",{"$f":"B29/B17","v":0.10148553154175492},-0.14043263816070525,0.10044592245484095,-0.14124208050381268,9.9424127577890556E-2,-0.14204713904536032,9.8372478784527762E-2,-0.14288300028960316,9.7339313810675593E-2,-0.14367551893631317]
[{"$f":"A18","v":"NPL2 (Gifted & Energex Operated)"}]
[{"$f":"A19","v":"Major"},{"$f":"B31/B19","v":0.10148683672077483},-5.8662613981762812E-2,0.10046970252173611,-5.9580364212193301E-2,9.944679466319549E-2,-6.0472760670952738E-2,9.8416936868205185E-2,-6.1340133163337585E-2,9.7379207551856917E-2,-6.2226117440841375E-2]
["Minor",{"$f":"B32/B20","v":0.10144825646794149},-6.4572558564040233E-2,0.10040519195110242,-6.5453194650817129E-2,9.9423051120354225E-2,-6.6332825313883514E-2,9.8368176158332751E-2,-6.7205444491705582E-2,9.7368926445169979E-2,-6.8074792243767349E-2]
[{"$f":"A21","v":"NPL4"}]
[{"$f":"A22","v":"Major"},null,{"$f":"C34/C22","v":-0.13468963160006536},null,-0.13548919071150256,null,{"$f":"G34/G22","v":-0.13629827531928279},null,{"$f":"I34/I22","v":-0.13712615495435582},null,{"$f":"K34/K22","v":-0.13794783248805154}]
["Minor",null,{"$f":"C35/C23","v":-0.13077433317678505},null,-0.13159251394058633,null,{"$f":"G35/G23","v":-0.13239329902146499},null,{"$f":"I35/I23","v":-0.13322502030869196},null,{"$f":"K35/K23","v":-0.13403252613155928}]