{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Ergon >>>","Input Data","Public Lighting Pricing","Output Tables","Changes register"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":12,"defined_names":204,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Ergon >>>","index":0,"n_rows":3,"n_cols":1,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
[]
["ACS Public Lighting pricing model for Ergon Energy"]
["Regulatory control period 1 July 2020 to 30 June 2025"]

{"sheet":"Input Data","index":1,"n_rows":82,"n_cols":9,"rows_kept":82,"cut":false,"hidden":false,"merged":[]}
["Public Lighting Quantity Inputs","Units","2020-21","2021-22","2022-23","2023-24","2024-25"]
[]
["Opening Population Public Lights"]
[]
["NPL1 (Ergon 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 & Ergon 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 (Ergon 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 & Ergon 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 (Ergon 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 & Ergon Operated)"]
["Major Conventional","#",669,816,980,1139,1315]
["Minor Conventional ","#",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}]
[]
[]
["Pricing Allocators"]
["Proportion of asset base related to refurbishment","%",0.1]
["Relativity Major to Minor"]
["Opex + tax","#",1.5]
["Asset charge","#",1.8]
[]
["Price Smoothing Inputs"]
["Expected CPI","%",2.3699999999999999E-2]
["WACC (Discount rate for smoothing)","%",4.6734187198390856E-2,4.5406260215142207E-2,4.4078333231893557E-2,4.2750406248644908E-2,4.1422479265396259E-2,"Source: Public lighting PTRM"]
["X Factors",null,null,"X_02","X_03","X_04","X_05"]
["X factor Conventional","%",0.30154028053470144,0,0,0,0,"X factors for 2021-22 to 2024-25 in accordance with AER's Draft Decision for ACS"]
["X factor LED","%",-0.12408477319631329,0,0,0,0,"X factors for 2021-22 to 2024-25 in accordance with AER's Draft Decision for ACS"]
[]
["% of PLAB associated with Poles, cabling and some residual brackets","%",0.7]
[]
["Million",null,1000000]
[]
["Price t-1 to be used for price smoothing"]
[]
["NPL1 Conventional",null,"2019-20","Source: Approved Ergon Energy's 2019-20 prices in the 2019-20 price schedule"]
["Major","$/day/light Nominal",1.30966,"Used as starting point for smoothing in accordance with the formula in the Control Mechanism and ACS Draft Determination"]
["Minor","$/day/light Nominal",0.78027999999999997,"Used as starting point for smoothing in accordance with the formula in the Control Mechanism and ACS Draft Determination"]
[]
["NPL2 conventional"]
["Major","$/day/light Nominal",0.52886999999999995,"Used as starting point for smoothing in accordance with the formula in the Control Mechanism and ACS Draft Determination"]
["Minor","$/day/light Nominal",0.34644999999999998,"Used as starting point for smoothing in accordance with the formula in the Control Mechanism and ACS Draft Determination"]
[]
[null,"Note: For LED the price smoothing starting point is 2020-21 as these are new tariffs which will be introduced from 1 July 2020"]

{"sheet":"Public Lighting Pricing","index":2,"n_rows":229,"n_cols":9,"rows_kept":229,"cut":false,"hidden":false,"merged":[]}
["Public Lighting Price Calculations","Units","2020-21","2021-22","2022-23","2023-24","2024-25"]
[]
["Building Block Revenue - Linked to PL PTRM"]
[]
["Opex Charge"]
["O&M Conventional","$M Nominal",13.295696869583097,12.470740552622612,11.273494365295047,9.7753715476090672,7.9348526957049632,null,"Updated reflecting the Ergon 2020-25 - Revised Regulatory Proposal - Public Lighting PTRM CON - December 2019.xlsm"]
["O&M LED","$M Nominal",0.30203641517441704,0.90386264275391792,1.7759249600802611,2.9131042926841562,4.348197603612407,null,"Updated reflecting the Ergon 2020-25 - Revised Regulatory Proposal - Public Lighting PTRM LED - December 2019.xlsm"]
["Carry-over amounts Conventional","$M Nominal",0,0,0,0,0]
["Carry-over amounts LED","$M Nominal",0,0,0,0,0]
["Benchmark Tax liability Conventional","$M Nominal",0,0,0,0,0,null,"Updated reflecting the Ergon 2020-25 - Revised Regulatory Proposal - Public Lighting PTRM CON - December 2019.xlsm"]
["Tax liability attributable to O&M Revenue","$M Nominal",0,0,0,0,0]
["Tax liability attributable to Capex Revenue","$M Nominal",0,0,0,0,0]
["Tax liability attributable to Gifted Assets","$M Nominal",{"$f":"C10","v":0},{"$f":"D10","v":0},0,0,0]
["Tax liability attributable to Contributed Assets","$M Nominal",0,0,0,0,0]
["Benchmark Tax liability LED","$M Nominal",0.78660401616782805,0.6634043120625871,0.58300613329162021,0.52246464769644863,0.49355192006264659,null,"Updated reflecting the Ergon 2020-25 - Revised Regulatory Proposal - Public Lighting PTRM LED - December 2019.xlsm"]
["Tax liability attributable to O&M Revenue","$M Nominal",0,0,0,0,0]
["Tax liability attributable to Capex Revenue","$M Nominal",0,0,0,0,0]
["Tax liability attributable to Gifted Assets","$M Nominal",0.78660401616782805,0.6634043120625871,0.58300613329162021,0.52246464769644863,0.49355192006264659]
["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.295696869583097},{"$f":"SUM(D6,D8)+D11+D6/(D6+D24+D25)*(D13+D14)","v":12.470740552622612},11.273494365295047,9.7753715476090672,7.9348526957049632]
["Total Opex Charge LED","$M Nominal",{"$f":"SUM(C7,C9)+C16+C7/(C7+C28+C29)*(C18+C19)","v":0.93796661179605034},{"$f":"SUM(D7,D9)+D16+D7/(D7+D28+D29)*(D18+D19)","v":1.2083660859485543},2.0397994981422989,3.1519656988428673,4.5777561055958662]
[]
["Capex Charge Conventional","Flag",1,1,1,1,1]
["Return on capital","$M Nominal",4.6630715864871846,4.2667601554782362,3.8699894040220344,3.4715387531540394,3.0744040314568641,null,"Updated reflecting the Ergon 2020-25 - Revised Regulatory Proposal - Public Lighting PTRM CON - December 2019.xlsm"]
["Return of capital","$M Nominal",6.4884333016371007,6.8706749849988809,7.268369213576892,7.6807626205337547,8.1095891973178613,null,"Updated reflecting the Ergon 2020-25 - Revised Regulatory Proposal - Public Lighting PTRM CON - December 2019.xlsm"]
["Total Capex Charge Conventional","$M Nominal",{"$f":"(SUM(C24:C25)+C12+(C24+C25)/(C6+C24+C25)*(C13+C14))*C23","v":11.151504888124286},{"$f":"(SUM(D24:D25)+D12+(D24+D25)/(D6+D24+D25)*(D13+D14))*D23","v":11.137435140477116},11.138358617598927,11.152301373687795,11.183993228774725]
["Capex Charge LED"]
["Return on capital","$M Nominal",2.9924455771606441E-2,0.39100672936839803,0.74012825400813687,1.1214444102802819,1.523665446293905,null,"Updated reflecting the Ergon 2020-25 - Revised Regulatory Proposal - Public Lighting PTRM CON - December 2019.xlsm"]
["Return of capital","$M Nominal",4.1638399016757491E-2,0.67432469814623608,1.4076870285152576,2.3373220502745857,3.4767834063653571,null,"Updated reflecting the Ergon 2020-25 - Revised Regulatory Proposal - Public Lighting PTRM CON - December 2019.xlsm"]
["Total Capex Charge LED","$M Nominal",{"$f":"(SUM(C28:C29)+C17+(C28+C29)/(C7+C28+C29)*(C18+C19))*C23","v":0.22223667433455871},{"$f":"(SUM(D28:D29)+D17+(D28+D29)/(D7+D28+D29)*(D18+D19))*D23","v":1.4242322963825849},2.4669468777529771,3.7423697020926054,5.2644422707384493]
[]
["ARR for Conventional","$M Nominal",{"$f":"SUM(C20,C26)","v":24.447201757707383},{"$f":"SUM(D20,D26)","v":23.608175693099728},22.411852982893976,20.92767292129686,19.118845924479686]
["ARR for LED","$M Nominal",{"$f":"SUM(C21,C30)","v":1.1602032861306091},{"$f":"SUM(D21,D30)","v":2.632598382331139},4.5067463758952755,6.8943354009354731,9.8421983763343164]
["ARR for Total","$M Nominal",{"$f":"C32+C33","v":25.607405043837993},{"$f":"D32+D33","v":26.240774075430867},{"$f":"E32+E33","v":26.918599358789251},{"$f":"F32+F33","v":27.822008322232335},{"$f":"G32+G33","v":28.961044300814002}]
[]
["Opex and Capex Charge Components"]
["Opex Charge for Conventional Lights","$M Nominal",{"$f":"C20","v":13.295696869583097},12.470740552622612,11.273494365295047,9.7753715476090672,7.9348526957049632]
["Opex Charge for LED","$M Nominal",0.93796661179605034,1.2083660859485543,2.0397994981422989,3.1519656988428673,4.5777561055958662]
["Capex Charge for Conventional Lights","$M Nominal",{"$f":"C26","v":11.151504888124286},{"$f":"D26","v":11.137435140477116},11.138358617598927,11.152301373687795,11.183993228774725]
["Capex Charge for LED","$M Nominal",{"$f":"C30","v":0.22223667433455871},{"$f":"D30","v":1.4242322963825849},{"$f":"E30","v":2.4669468777529771},{"$f":"F30","v":3.7423697020926054},{"$f":"G30","v":5.2644422707384493}]
[]
["Public Lights Population"]
[]
["Opening Population Public Lights"]
["NPL1 (Ergon Owned & Operated)"]
["Major Conventional","#",{"$f":"'Input Data'!C6","v":26804},{"$f":"'Input Data'!D6","v":24714},{"$f":"'Input Data'!E6","v":21939},{"$f":"'Input Data'!F6","v":18662},{"$f":"'Input Data'!G6","v":14876}]
["Minor Conventional","#",{"$f":"'Input Data'!C7","v":69606},{"$f":"'Input Data'!D7","v":64108},{"$f":"'Input Data'!E7","v":56905},{"$f":"'Input Data'!F7","v":48458},{"$f":"'Input Data'!G7","v":38710}]
["Major LED","#",{"$f":"'Input Data'!C8","v":1391},{"$f":"'Input Data'!D8","v":3827},{"$f":"'Input Data'!E8","v":6952},{"$f":"'Input Data'!F8","v":10582},{"$f":"'Input Data'!G8","v":14729}]
["Minor LED","#",{"$f":"'Input Data'!C9","v":3419},{"$f":"'Input Data'!D9","v":9425},{"$f":"'Input Data'!E9","v":17153},{"$f":"'Input Data'!F9","v":26142},{"$f":"'Input Data'!G9","v":36445}]
["Total","#",{"$f":"SUM(C46:C49)","v":101220},{"$f":"SUM(D46:D49)","v":102074},{"$f":"SUM(E46:E49)","v":102949},{"$f":"SUM(F46:F49)","v":103844},{"$f":"SUM(G46:G49)","v":104760}]
[]
["NPL2 (Gifted & Ergon Operated)"]
["Major Conventional","#",{"$f":"'Input Data'!C13","v":13044},{"$f":"'Input Data'!D13","v":12027},{"$f":"'Input Data'!E13","v":10677},{"$f":"'Input Data'!F13","v":9082},{"$f":"'Input Data'!G13","v":7239}]
["Minor Conventional","#",{"$f":"'Input Data'!C14","v":33873},{"$f":"'Input Data'!D14","v":31198},{"$f":"'Input Data'!E14","v":27692},{"$f":"'Input Data'!F14","v":23581},{"$f":"'Input Data'!G14","v":18837}]
["Major LED","#",{"$f":"'Input Data'!C15","v":677},{"$f":"'Input Data'!D15","v":1863},{"$f":"'Input Data'!E15","v":3383},{"$f":"'Input Data'!F15","v":5150},{"$f":"'Input Data'!G15","v":7167}]
["Minor LED","#",{"$f":"'Input Data'!C16","v":1664},{"$f":"'Input Data'!D16","v":4587},{"$f":"'Input Data'!E16","v":8347},{"$f":"'Input Data'!F16","v":12722},{"$f":"'Input Data'!G16","v":17735}]
["Total","#",{"$f":"SUM(C53:C56)","v":49258},{"$f":"SUM(D53:D56)","v":49675},{"$f":"SUM(E53:E56)","v":50099},{"$f":"SUM(F53:F56)","v":50535},{"$f":"SUM(G53:G56)","v":50978}]
["Total Opening Lights","#",{"$f":"SUM(C50,C57)","v":150478},{"$f":"SUM(D50,D57)","v":151749},{"$f":"SUM(E50,E57)","v":153048},{"$f":"SUM(F50,F57)","v":154379},{"$f":"SUM(G50,G57)","v":155738}]
[]
["Plus Additions"]
["NPL1 (Ergon Owned & Operated)"]
["Major Conventional","#",{"$f":"'Input Data'!C23","v":0},{"$f":"'Input Data'!D23","v":0},{"$f":"'Input Data'!E23","v":0},{"$f":"'Input Data'!F23","v":0},{"$f":"'Input Data'!G23","v":0}]
["Minor Conventional","#",{"$f":"'Input Data'!C24","v":0},{"$f":"'Input Data'!D24","v":0},{"$f":"'Input Data'!E24","v":0},{"$f":"'Input Data'!F24","v":0},{"$f":"'Input Data'!G24","v":0}]
["Major LED","#",{"$f":"'Input Data'!C25","v":2087},{"$f":"'Input Data'!D25","v":2547},{"$f":"'Input Data'!E25","v":3035},{"$f":"'Input Data'!F25","v":3509},{"$f":"'Input Data'!G25","v":4010}]
["Minor LED","#",{"$f":"'Input Data'!C26","v":5165},{"$f":"'Input Data'!D26","v":6325},{"$f":"'Input Data'!E26","v":7545},{"$f":"'Input Data'!F26","v":8723},{"$f":"'Input Data'!G26","v":10015}]
["Total","#",{"$f":"SUM(C62:C65)","v":7252},{"$f":"SUM(D62:D65)","v":8872},{"$f":"SUM(E62:E65)","v":10580},{"$f":"SUM(F62:F65)","v":12232},{"$f":"SUM(G62:G65)","v":14025}]
[]
["NPL2 (Gifted & Ergon Operated)"]
["Major Conventional","#",{"$f":"'Input Data'!C30","v":0},{"$f":"'Input Data'!D30","v":0},{"$f":"'Input Data'!E30","v":0},{"$f":"'Input Data'!F30","v":0},{"$f":"'Input Data'!G30","v":0}]
["Minor Conventional","#",{"$f":"'Input Data'!C31","v":0},{"$f":"'Input Data'!D31","v":0},{"$f":"'Input Data'!E31","v":0},{"$f":"'Input Data'!F31","v":0},{"$f":"'Input Data'!G31","v":0}]
["Major LED","#",{"$f":"'Input Data'!C32","v":1471},{"$f":"'Input Data'!D32","v":1717},{"$f":"'Input Data'!E32","v":1991},{"$f":"'Input Data'!F32","v":2258},{"$f":"'Input Data'!G32","v":2553}]
["Minor LED","#",{"$f":"'Input Data'!C33","v":3580},{"$f":"'Input Data'!D33","v":4208},{"$f":"'Input Data'!E33","v":4899},{"$f":"'Input Data'!F33","v":5561},{"$f":"'Input Data'!G33","v":6335}]
["Total","#",{"$f":"SUM(C69:C72)","v":5051},{"$f":"SUM(D69:D72)","v":5925},{"$f":"SUM(E69:E72)","v":6890},{"$f":"SUM(F69:F72)","v":7819},{"$f":"SUM(G69:G72)","v":8888}]
["Total Additions","#",{"$f":"SUM(C66,C73)","v":12303},{"$f":"SUM(D66,D73)","v":14797},{"$f":"SUM(E66,E73)","v":17470},{"$f":"SUM(F66,F73)","v":20051},{"$f":"SUM(G66,G73)","v":22913}]
[]
["Less Disposals"]
["NPL1 (Ergon Owned & Operated)"]
["Major Conventional","#",{"$f":"'Input Data'!C40","v":1927},{"$f":"'Input Data'!D40","v":2377},{"$f":"'Input Data'!E40","v":2865},{"$f":"'Input Data'!F40","v":3329},{"$f":"'Input Data'!G40","v":3820}]
["Minor Conventional","#",{"$f":"'Input Data'!C41","v":5010},{"$f":"'Input Data'!D41","v":6150},{"$f":"'Input Data'!E41","v":7340},{"$f":"'Input Data'!F41","v":8498},{"$f":"'Input Data'!G41","v":9770}]
["Major LED","#",{"$f":"'Input Data'!C42","v":0},{"$f":"'Input Data'!D42","v":0},{"$f":"'Input Data'!E42","v":0},{"$f":"'Input Data'!F42","v":0},{"$f":"'Input Data'!G42","v":0}]
["Minor LED","#",{"$f":"'Input Data'!C43","v":0},{"$f":"'Input Data'!D43","v":0},{"$f":"'Input Data'!E43","v":0},{"$f":"'Input Data'!F43","v":0},{"$f":"'Input Data'!G43","v":0}]
["Total","#",{"$f":"SUM(C78:C81)","v":6937},{"$f":"SUM(D78:D81)","v":8527},{"$f":"SUM(E78:E81)","v":10205},{"$f":"SUM(F78:F81)","v":11827},{"$f":"SUM(G78:G81)","v":13590}]
[]
["NPL2 (Gifted & Ergon Operated)"]
["Major Conventional","#",{"$f":"'Input Data'!C47","v":669},{"$f":"'Input Data'!D47","v":816},{"$f":"'Input Data'!E47","v":980},{"$f":"'Input Data'!F47","v":1139},{"$f":"'Input Data'!G47","v":1315}]
["Minor Conventional","#",{"$f":"'Input Data'!C48","v":1785},{"$f":"'Input Data'!D48","v":2159},{"$f":"'Input Data'!E48","v":2572},{"$f":"'Input Data'!F48","v":2967},{"$f":"'Input Data'!G48","v":3429}]
["Major LED","#",{"$f":"'Input Data'!C49","v":0},{"$f":"'Input Data'!D49","v":0},{"$f":"'Input Data'!E49","v":0},{"$f":"'Input Data'!F49","v":0},{"$f":"'Input Data'!G49","v":0}]
["Minor LED","#",{"$f":"'Input Data'!C50","v":0},{"$f":"'Input Data'!D50","v":0},{"$f":"'Input Data'!E50","v":0},{"$f":"'Input Data'!F50","v":0},{"$f":"'Input Data'!G50","v":0}]
["Total","#",{"$f":"SUM(C85:C88)","v":2454},{"$f":"SUM(D85:D88)","v":2975},{"$f":"SUM(E85:E88)","v":3552},{"$f":"SUM(F85:F88)","v":4106},{"$f":"SUM(G85:G88)","v":4744}]
["Total Disposals","#",{"$f":"SUM(C82,C89)","v":9391},{"$f":"SUM(D82,D89)","v":11502},{"$f":"SUM(E82,E89)","v":13757},{"$f":"SUM(F82,F89)","v":15933},{"$f":"SUM(G82,G89)","v":18334}]
[]
["Closing Population Public Lights"]
["NPL1 (Ergon Owned & Operated)"]
["Major Conventional","#",{"$f":"(C46+C62-C78)","v":24877},22337,19074,15333,11056]
["Minor Conventional","#",64596,57958,49565,39960,28940]
["Major LED","#",3478,6374,9987,14091,18739]
["Minor LED","#",8584,15750,24698,34865,46460]
["Total","#",{"$f":"SUM(C94:C97)","v":101535},{"$f":"SUM(D94:D97)","v":102419},{"$f":"SUM(E94:E97)","v":103324},{"$f":"SUM(F94:F97)","v":104249},{"$f":"SUM(G94:G97)","v":105195}]
[]
["NPL2 (Gifted & Ergon Operated)"]
["Major Conventional","#",{"$f":"(C53+C69-C85)","v":12375},11211,9697,7943,5924]
["Minor Conventional","#",32088,29039,25120,20614,15408]
["Major LED","#",2148,3580,5374,7408,9720]
["Minor LED","#",5244,8795,13246,18283,24070]
["Total","#",{"$f":"SUM(C101:C104)","v":51855},{"$f":"SUM(D101:D104)","v":52625},{"$f":"SUM(E101:E104)","v":53437},{"$f":"SUM(F101:F104)","v":54248},{"$f":"SUM(G101:G104)","v":55122}]
["Grand Total","#",{"$f":"SUM(C98,C105)","v":153390},{"$f":"SUM(D98,D105)","v":155044},{"$f":"SUM(E98,E105)","v":156761},{"$f":"SUM(F98,F105)","v":158497},{"$f":"SUM(G98,G105)","v":160317}]
[]
["Average No of Lights"]
["NPL1 (Ergon Owned & Operated)"]
["Major Conventional","#",{"$f":"AVERAGE(C46,C94)","v":25840.5},23525.5,20506.5,16997.5,12966]
["Minor Conventional","#",67101,61033,53235,44209,33825]
["Major LED","#",2434.5,5100.5,8469.5,12336.5,16734]
["Minor LED","#",6001.5,12587.5,20925.5,30503.5,41452.5]
["Total","#",{"$f":"SUM(C110:C113)","v":101377.5},{"$f":"SUM(D110:D113)","v":102246.5},{"$f":"SUM(E110:E113)","v":103136.5},{"$f":"SUM(F110:F113)","v":104046.5},{"$f":"SUM(G110:G113)","v":104977.5}]
[]
["NPL2 (Gifted & Ergon Operated)"]
["Major Conventional","#",{"$f":"AVERAGE(C53,C101)","v":12709.5},11619,10187,8512.5,6581.5]
["Minor Conventional","#",32980.5,30118.5,26406,22097.5,17122.5]
["Major LED","#",1412.5,2721.5,4378.5,6279,8443.5]
["Minor LED","#",3454,6691,10796.5,15502.5,20902.5]
["Total","#",{"$f":"SUM(C117:C120)","v":50556.5},{"$f":"SUM(D117:D120)","v":51150},{"$f":"SUM(E117:E120)","v":51768},{"$f":"SUM(F117:F120)","v":52391.5},{"$f":"SUM(G117:G120)","v":53050}]
["Grand total","#",{"$f":"SUM(C114,C121)","v":151934},{"$f":"SUM(D114,D121)","v":153396.5},{"$f":"SUM(E114,E121)","v":154904.5},{"$f":"SUM(F114,F121)","v":156438},{"$f":"SUM(G114,G121)","v":158027.5}]
[]
["2020-25 TSS Pricing Methodology"]
["Major Conventional","#",{"$f":"SUM(C110+C117)","v":38550},{"$f":"SUM(D110+D117)","v":35144.5},30693.5,25510,19547.5]
["Minor Conventional","#",100081.5,91151.5,79641,66306.5,50947.5]
["Major LED","#",3847,7822,12848,18615.5,25177.5]
["Minor LED","#",9455.5,19278.5,31722,46006,62355]
["Total","#",{"$f":"SUM(C125:C128)","v":151934},{"$f":"SUM(D125:D128)","v":153396.5},{"$f":"SUM(E125:E128)","v":154904.5},{"$f":"SUM(F125:F128)","v":156438},{"$f":"SUM(G125:G128)","v":158027.5}]
[]
["Weighted Average No of Lights"]
["Major Conventional",null,{"$f":"ROUND(C125*'Input Data'!$C$59,0)","v":69390},{"$f":"ROUND(D125*'Input Data'!$C$59,0)","v":63260},{"$f":"ROUND(E125*'Input Data'!$C$59,0)","v":55248},{"$f":"ROUND(F125*'Input Data'!$C$59,0)","v":45918},{"$f":"ROUND(G125*'Input Data'!$C$59,0)","v":35186}]
["Minor Conventional",null,{"$f":"C126","v":100081.5},{"$f":"D126","v":91151.5},{"$f":"E126","v":79641},{"$f":"F126","v":66306.5},{"$f":"G126","v":50947.5}]
["Major LED",null,{"$f":"ROUND(C127*'Input Data'!$C$59,0)","v":6925},{"$f":"ROUND(D127*'Input Data'!$C$59,0)","v":14080},{"$f":"ROUND(E127*'Input Data'!$C$59,0)","v":23126},{"$f":"ROUND(F127*'Input Data'!$C$59,0)","v":33508},{"$f":"ROUND(G127*'Input Data'!$C$59,0)","v":45320}]
["Minor LED",null,{"$f":"C128","v":9455.5},{"$f":"D128","v":19278.5},{"$f":"E128","v":31722},{"$f":"F128","v":46006},{"$f":"G128","v":62355}]
["Total",null,{"$f":"SUM(C132:C135)","v":185852},{"$f":"SUM(D132:D135)","v":187770},{"$f":"SUM(E132:E135)","v":189737},{"$f":"SUM(F132:F135)","v":191738.5},{"$f":"SUM(G132:G135)","v":193808.5}]
[]
["Price Components"]
[]
["Opex Charge"]
["NPL1 (Ergon Owned & Operated)"]
["Major Conventional","$/light Nominal",{"$f":"C$37*Million/(C$125+C$126/'Input Data'!$C$58)","v":126.29971093257494},{"$f":"D$37*Million/(D$125+D$126/'Input Data'!$C$58)","v":130.02250898953676},{"$f":"E$37*Million/(E$125+E$126/'Input Data'!$C$58)","v":134.54864228309768},{"$f":"F$37*Million/(F$125+F$126/'Input Data'!$C$58)","v":140.22039773182559},{"$f":"G$37*Million/(G$125+G$126/'Input Data'!$C$58)","v":148.28035871441182}]
["Minor Conventional","$/light Nominal",{"$f":"C142/'Input Data'!$C$58","v":84.199807288383298},{"$f":"D142/'Input Data'!$C$58","v":86.681672659691174},{"$f":"E142/'Input Data'!$C$58","v":89.699094855398457},{"$f":"F142/'Input Data'!$C$58","v":93.480265154550395},{"$f":"G142/'Input Data'!$C$58","v":98.85357247627455}]
["Major LED","$/light Nominal",{"$f":"C$38*Million/(C$127+C$128/'Input Data'!$C$58)","v":92.40443436845365},{"$f":"D$38*Million/(D$127+D$128/'Input Data'!$C$58)","v":58.44764454872648},{"$f":"E$38*Million/(E$127+E$128/'Input Data'!$C$58)","v":60.001161846755465},{"$f":"F$38*Million/(F$127+F$128/'Input Data'!$C$58)","v":63.952340220742137},{"$f":"G$38*Million/(G$127+G$128/'Input Data'!$C$58)","v":68.583184472764771}]
["Minor LED","$/light Nominal",{"$f":"C144/'Input Data'!$C$58","v":61.602956245635767},{"$f":"D144/'Input Data'!$C$58","v":38.965096365817651},{"$f":"E144/'Input Data'!$C$58","v":40.000774564503644},{"$f":"F144/'Input Data'!$C$58","v":42.63489348049476},{"$f":"G144/'Input Data'!$C$58","v":45.722122981843178}]
[]
["NPL2 (Gifted & Ergon Operated)"]
["Major Conventional","$/light Nominal",{"$f":"C142","v":126.29971093257494},130.02250898953676,134.54864228309768,140.22039773182559,148.28035871441182]
["Minor Conventional","$/light Nominal",84.199807288383298,86.681672659691174,89.699094855398457,93.480265154550395,98.85357247627455]
["Major LED","$/light Nominal",92.40443436845365,58.44764454872648,60.001161846755465,63.952340220742137,68.583184472764771]
["Minor LED","$/light Nominal",61.602956245635767,38.965096365817651,40.000774564503644,42.63489348049476,45.722122981843178]
[]
["Capex Charge"]
["NPL1 (Ergon Owned & Operated)"]
["Major Conventional","$/light Nominal",{"$f":"C$39*Million/(C$110+C$111/'Input Data'!$C$59)*(1-'Input Data'!$C$56)","v":159.00728624544485},{"$f":"D$39*Million/(D$110+D$111/'Input Data'!$C$59)*(1-'Input Data'!$C$56)","v":174.52927945231502},{"$f":"E$39*Million/(E$110+E$111/'Input Data'!$C$59)*(1-'Input Data'!$C$56)","v":200.16418749117008},{"$f":"F$39*Million/(F$110+F$111/'Input Data'!$C$59)*(1-'Input Data'!$C$56)","v":241.51926990186723},{"$f":"G$39*Million/(G$110+G$111/'Input Data'!$C$59)*(1-'Input Data'!$C$56)","v":316.95004584396162}]
["Minor Conventional","$/light Nominal",{"$f":"ROUND(C155/'Input Data'!$C$59,2)","v":88.34},{"$f":"ROUND(D155/'Input Data'!$C$59,2)","v":96.96},{"$f":"ROUND(E155/'Input Data'!$C$59,2)","v":111.2},{"$f":"ROUND(F155/'Input Data'!$C$59,2)","v":134.18},{"$f":"ROUND(G155/'Input Data'!$C$59,2)","v":176.08}]
["Major LED","$/light Nominal",{"$f":"C$40*Million/(C$112+C$113/'Input Data'!$C$59)*(1-'Input Data'!$C$56)","v":34.672311377748102},{"$f":"D$40*Million/(D$112+D$113/'Input Data'!$C$59)*(1-'Input Data'!$C$56)","v":105.99108433048767},{"$f":"E$40*Million/(E$112+E$113/'Input Data'!$C$59)*(1-'Input Data'!$C$56)","v":110.48901433650045},{"$f":"F$40*Million/(F$112+F$113/'Input Data'!$C$59)*(1-'Input Data'!$C$56)","v":115.02050718641189},{"$f":"G$40*Million/(G$112+G$113/'Input Data'!$C$59)*(1-'Input Data'!$C$56)","v":119.15545065570575}]
["Minor LED","$/light Nominal",{"$f":"ROUND(C157/'Input Data'!$C$59,2)","v":19.260000000000002},{"$f":"ROUND(D157/'Input Data'!$C$59,2)","v":58.88},{"$f":"ROUND(E157/'Input Data'!$C$59,2)","v":61.38},{"$f":"ROUND(F157/'Input Data'!$C$59,2)","v":63.9},{"$f":"ROUND(G157/'Input Data'!$C$59,2)","v":66.2}]
[]
["NPL2 (Gifted & Ergon Operated)"]
["Major Conventional","$/light Nominal",0,0,0,0,0,null,"Capex is not allocated to NPL2"]
["Minor Conventional","$/light Nominal",0,0,0,0,0]
["Major LED","$/light Nominal",0,0,0,0,0]
["Minor LED","$/light Nominal",0,0,0,0,0]
[]
["Refurbishment Charge"]
["NPL1 (Ergon Owned & Operated)"]
["Major Conventional","$/light Nominal",{"$f":"C$39*Million/(C$125+C$126/'Input Data'!$C$59)*'Input Data'!$C$56","v":11.844297594948838},{"$f":"D$39*Million/(D$125+D$126/'Input Data'!$C$59)*'Input Data'!$C$56","v":12.983081098090304},{"$f":"E$39*Million/(E$125+E$126/'Input Data'!$C$59)*'Input Data'!$C$56","v":14.863332756325423},{"$f":"F$39*Million/(F$125+F$126/'Input Data'!$C$59)*'Input Data'!$C$56","v":17.887486665245138},{"$f":"G$39*Million/(G$125+G$126/'Input Data'!$C$59)*'Input Data'!$C$56","v":23.372212522255705}]
["Minor Conventional","$/light Nominal",{"$f":"ROUND(C168/'Input Data'!$C$59,2)","v":6.58},{"$f":"ROUND(D168/'Input Data'!$C$59,2)","v":7.21},{"$f":"ROUND(E168/'Input Data'!$C$59,2)","v":8.26},{"$f":"ROUND(F168/'Input Data'!$C$59,2)","v":9.94},{"$f":"ROUND(G168/'Input Data'!$C$59,2)","v":12.98}]
["Major LED","$/light Nominal",{"$f":"C$40*Million/(C$127+C$128/'Input Data'!$C$59)*'Input Data'!$C$56","v":2.4421463471053642},{"$f":"D$40*Million/(D$127+D$128/'Input Data'!$C$59)*'Input Data'!$C$56","v":7.6851443382226599},{"$f":"E$40*Million/(E$127+E$128/'Input Data'!$C$59)*'Input Data'!$C$56","v":8.0959597362099149},{"$f":"F$40*Million/(F$127+F$128/'Input Data'!$C$59)*'Input Data'!$C$56","v":8.4718086570608282},{"$f":"G$40*Million/(G$127+G$128/'Input Data'!$C$59)*'Input Data'!$C$56","v":8.8005944651047443}]
["Minor LED","$/light Nominal",{"$f":"ROUND(C170/'Input Data'!$C$59,2)","v":1.36},{"$f":"ROUND(D170/'Input Data'!$C$59,2)","v":4.2699999999999996},{"$f":"ROUND(E170/'Input Data'!$C$59,2)","v":4.5},{"$f":"ROUND(F170/'Input Data'!$C$59,2)","v":4.71},{"$f":"ROUND(G170/'Input Data'!$C$59,2)","v":4.8899999999999997}]
[]
["NPL2 (Gifted & Ergon Operated)"]
["Major Conventional","$/light Nominal",{"$f":"C168","v":11.844297594948838},{"$f":"D168","v":12.983081098090304},14.863332756325423,17.887486665245138,23.372212522255705]
["Minor Conventional","$/light Nominal",{"$f":"C169","v":6.58},7.21,8.26,9.94,12.98]
["Major LED","$/light Nominal",2.4421463471053642,7.6851443382226599,8.0959597362099149,8.4718086570608282,8.8005944651047443]
["Minor LED","$/light Nominal",1.36,4.2699999999999996,4.5,4.71,4.8899999999999997]
[]
["Pricing Days in Year","#",365.25,365.25,365.25,365.25,365.25]
[]
["Unsmoothed Prices"]
[]
["NPL1 (Ergon Owned & Operated)"]
["Major Conventional","$/day/light Nominal",{"$f":"SUM(C142,C155,C168)/C$179","v":0.81355590629149521},{"$f":"SUM(D142,D155,D168)/D$179","v":0.86936309251181942},0.95708737174700398,1.094119518956709,1.3377210597690052]
["Minor Conventional","$/day/light Nominal",0.49040330537545057,0.52252340221681359,0.57264639248569049,0.6505140729761818,0.78826440103018358]
["Major LED","$/day/light Nominal",0.35460340066613855,0.47124948177258541,0.48894219279799001,0.51319549914911666,0.53809508444510679]
["Minor LED","$/day/light Nominal",0.22511418547744222,0.27957589696322421,0.28988576198358285,0.30457191917999932,0.31981416285241121]
[]
["NPL2 (Gifted & Ergon Operated)"]
["Major Conventional","$/day/light Nominal",{"$f":"SUM(C148,C174)/C$179","v":0.37821768248466464},{"$f":"SUM(D148,D174)/D$179","v":0.39152796738570039},0.40906769346864646,0.43287579574831136,0.46995912727355926]
["Minor Conventional","$/day/light Nominal",0.24854156684020068,0.25706138989648508,0.26819738495660084,0.2831492543587964,0.30618363443196317]
["Major LED","$/day/light Nominal",0.25967578566888161,0.1810617081093748,0.18643975792735218,0.19828651301246533,0.21186524007630259]
["Minor LED","$/day/light Nominal",0.17238317931727792,0.11837124261688611,0.12183648066941449,0.12962325388225807,0.13856844074426605]
[]
["NPL4 (Gifted & Ergon Operated)"]
["Major LED","$/day/light Nominal",{"$f":"(C192*0.9)+((C186-C192)*0.7)","v":0.3001575376000733},{"$f":"(D192*0.9)+((D186-D192)*0.7)","v":0.36608697886268471},0.37954748654406345,{"$f":"(F192*0.9)+((F186-F192)*0.7)","v":0.39889415200687472},{"$f":"(G192*0.9)+((G186-G192)*0.7)","v":0.4190396071268353}]
["Minor LED","$/day/light Nominal",{"$f":"(C193*0.9)+((C187-C193)*0.7)","v":0.19205656569766516},{"$f":"(D193*0.9)+((D187-D193)*0.7)","v":0.21937737639763416},0.22728732952239089,0.23912499420245112,0.25158360214554104]
[]
["Smoothed Prices"]
[]
["NPL1 (Ergon Owned & Operated)"]
["Major Conventional","$/day/light Nominal",{"$f":"ROUND('Input Data'!C75*(1+'Input Data'!$C$62)*(1-'Input Data'!C$65),5)","v":0.93642000000000003},{"$f":"ROUND(C202*(1+'Input Data'!$C$62)*(1-'Input Data'!D$65),5)","v":0.95860999999999996},{"$f":"ROUND(D202*(1+'Input Data'!$C$62)*(1-'Input Data'!E$65),5)","v":0.98133000000000004},{"$f":"ROUND(E202*(1+'Input Data'!$C$62)*(1-'Input Data'!F$65),5)","v":1.0045900000000001},{"$f":"ROUND(F202*(1+'Input Data'!$C$62)*(1-'Input Data'!G$65),5)","v":1.0284}]
["Minor Conventional","$/day/light Nominal",{"$f":"ROUND('Input Data'!C76*(1+'Input Data'!$C$62)*(1-'Input Data'!C$65),5)","v":0.55791000000000002},{"$f":"ROUND(C203*(1+'Input Data'!$C$62)*(1-'Input Data'!D$65),5)","v":0.57113000000000003},{"$f":"ROUND(D203*(1+'Input Data'!$C$62)*(1-'Input Data'!E$65),5)","v":0.58467000000000002},{"$f":"ROUND(E203*(1+'Input Data'!$C$62)*(1-'Input Data'!F$65),5)","v":0.59853000000000001},{"$f":"ROUND(F203*(1+'Input Data'!$C$62)*(1-'Input Data'!G$65),5)","v":0.61272000000000004}]
["Major LED","$/day/light Nominal",{"$f":"ROUND(C186*(1-'Input Data'!$C$66),5)","v":0.39860000000000001},{"$f":"ROUND(C204*(1+'Input Data'!$C$62)*(1-'Input Data'!D$66),5)","v":0.40805000000000002},{"$f":"ROUND(D204*(1+'Input Data'!$C$62)*(1-'Input Data'!E$66),5)","v":0.41771999999999998},{"$f":"ROUND(E204*(1+'Input Data'!$C$62)*(1-'Input Data'!F$66),5)","v":0.42762},{"$f":"ROUND(F204*(1+'Input Data'!$C$62)*(1-'Input Data'!G$66),5)","v":0.43774999999999997}]
["Minor LED","$/day/light Nominal",{"$f":"ROUND(C187*(1-'Input Data'!C$66),5)","v":0.25305},{"$f":"ROUND(C205*(1+'Input Data'!$C$62)*(1-'Input Data'!D$66),5)","v":0.25905},{"$f":"ROUND(D205*(1+'Input Data'!$C$62)*(1-'Input Data'!E$66),5)","v":0.26518999999999998},{"$f":"ROUND(E205*(1+'Input Data'!$C$62)*(1-'Input Data'!F$66),5)","v":0.27148},{"$f":"ROUND(F205*(1+'Input Data'!$C$62)*(1-'Input Data'!G$66),5)","v":0.27790999999999999}]
[]
["NPL2 (Gifted & Ergon Operated)"]
["Major Conventional","$/day/light Nominal",{"$f":"ROUND('Input Data'!$C$79*(1+'Input Data'!$C$62)*(1-'Input Data'!C$65),5)","v":0.37814999999999999},{"$f":"ROUND(C208*(1+'Input Data'!$C$62)*(1-'Input Data'!D$65),5)","v":0.38711000000000001},{"$f":"ROUND(D208*(1+'Input Data'!$C$62)*(1-'Input Data'!E$65),5)","v":0.39628000000000002},{"$f":"ROUND(E208*(1+'Input Data'!$C$62)*(1-'Input Data'!F$65),5)","v":0.40566999999999998},{"$f":"ROUND(F208*(1+'Input Data'!$C$62)*(1-'Input Data'!G$65),5)","v":0.41527999999999998}]
["Minor Conventional","$/day/light Nominal",{"$f":"ROUND('Input Data'!C80*(1+'Input Data'!$C$62)*(1-'Input Data'!C$65),5)","v":0.24772},{"$f":"ROUND(C209*(1+'Input Data'!$C$62)*(1-'Input Data'!D$65),5)","v":0.25358999999999998},{"$f":"ROUND(D209*(1+'Input Data'!$C$62)*(1-'Input Data'!E$65),5)","v":0.2596},{"$f":"ROUND(E209*(1+'Input Data'!$C$62)*(1-'Input Data'!F$65),5)","v":0.26574999999999999},{"$f":"ROUND(F209*(1+'Input Data'!$C$62)*(1-'Input Data'!G$65),5)","v":0.27205000000000001}]
["Major LED","$/day/light Nominal",{"$f":"ROUND(C192*(1-'Input Data'!C$66),5)","v":0.29189999999999999},{"$f":"ROUND(C210*(1+'Input Data'!$C$62)*(1-'Input Data'!D$66),5)","v":0.29881999999999997},{"$f":"ROUND(D210*(1+'Input Data'!$C$62)*(1-'Input Data'!E$66),5)","v":0.30590000000000001},{"$f":"ROUND(E210*(1+'Input Data'!$C$62)*(1-'Input Data'!F$66),5)","v":0.31314999999999998},{"$f":"ROUND(F210*(1+'Input Data'!$C$62)*(1-'Input Data'!G$66),5)","v":0.32057000000000002}]
["Minor LED","$/day/light Nominal",{"$f":"ROUND(C193*(1-'Input Data'!C$66),5)","v":0.19377},{"$f":"ROUND(C211*(1+'Input Data'!$C$62)*(1-'Input Data'!D$66),5)","v":0.19836000000000001},{"$f":"ROUND(D211*(1+'Input Data'!$C$62)*(1-'Input Data'!E$66),5)","v":0.20305999999999999},{"$f":"ROUND(E211*(1+'Input Data'!$C$62)*(1-'Input Data'!F$66),5)","v":0.20787},{"$f":"ROUND(F211*(1+'Input Data'!$C$62)*(1-'Input Data'!G$66),5)","v":0.21279999999999999}]
[]
["NPL4 (Gifted & Ergon Operated)"]
["Major LED","$/day/light Nominal",{"$f":"(C210*0.9)+((C204-C210)*0.7)","v":0.33740000000000003},{"$f":"(D210*0.9)+((D204-D210)*0.7)","v":0.34539900000000001},0.35358400000000001,0.36196400000000001,{"$f":"(G210*0.9)+((G204-G210)*0.7)","v":0.37053899999999995}]
["Minor LED","$/day/light Nominal",{"$f":"(C211*0.9)+((C205-C211)*0.7)","v":0.215889},{"$f":"(D211*0.9)+((D205-D211)*0.7)","v":0.22100700000000001},0.22624499999999997,0.23160999999999998,0.237097]
[]
["Recovered Revenue"]
["1 + WACC",null,{"$f":"1+'Input Data'!C63","v":1.0467341871983908},{"$f":"1+'Input Data'!D63","v":1.0454062602151422},{"$f":"1+'Input Data'!E63","v":1.0440783332318935},{"$f":"1+'Input Data'!F63","v":1.042750406248645},{"$f":"1+'Input Data'!G63","v":1.0414224792653963}]
["Recovered revenue Conventional","$M Nominal",{"$f":"(SUMPRODUCT(C202:C203,C110:C111)+SUMPRODUCT(C208:C209,C117:C118))*C179/Million","v":27.251268460526255},{"$f":"(SUMPRODUCT(D202:D203,D110:D111)+SUMPRODUCT(D208:D209,D117:D118))*D179/Million","v":25.401361782337499},{"$f":"(SUMPRODUCT(E202:E203,E110:E111)+SUMPRODUCT(E208:E209,E117:E118))*E179/Million","v":22.696800478338751},{"$f":"(SUMPRODUCT(F202:F203,F110:F111)+SUMPRODUCT(F208:F209,F117:F118))*F179/Million","v":19.307702247123753},{"$f":"(SUMPRODUCT(G202:G203,G110:G111)+SUMPRODUCT(G208:G209,G117:G118))*G179/Million","v":15.139915600886249}]
["NPV of recovered revenue Conventional","$M Nominal",{"$f":"SUMPRODUCT(C219:G219, C229:G229)","v":97.523369348220513}]
["NPV of revenue requirement Conventional","$M Nominal",{"$f":"SUMPRODUCT(C32:G32, C229:G229)","v":97.52320450282204}]
["Difference Conventional","$M Nominal",{"$f":"C220-C221","v":1.6484539847283486E-4}]
[]
["Recovered revenue LED","$M Nominal",{"$f":"(SUMPRODUCT(C204:C205,C112:C113)+SUMPRODUCT(C210:C211,C119:C120))*C179/Million","v":1.30418415122625},{"$f":"(SUMPRODUCT(D204:D205,D112:D113)+SUMPRODUCT(D210:D211,D119:D120))*D179/Million","v":2.7329890749224997},{"$f":"(SUMPRODUCT(E204:E205,E112:E113)+SUMPRODUCT(E210:E211,E119:E120))*E179/Million","v":4.6090288719562498},{"$f":"(SUMPRODUCT(F204:F205,F112:F113)+SUMPRODUCT(F210:F211,F119:F120))*F179/Million","v":6.8466835092337499},{"$f":"(SUMPRODUCT(G204:G205,G112:G113)+SUMPRODUCT(G210:G211,G119:G120))*G179/Million","v":9.4965575524424981}]
["NPV of recovered revenue LED","$M Nominal",{"$f":"SUMPRODUCT(C224:G224, C229:G229)","v":21.17902753192844}]
["NPV of revenue requirement LED","$M Nominal",{"$f":"SUMPRODUCT(C33:G33, C229:G229)","v":21.178793884276867}]
["Difference LED","$M Nominal",{"$f":"C225-C226","v":2.3364765157296574E-4}]
[]
["Discount Factor",null,{"$f":"1/PRODUCT($C218:C218)","v":0.95535238289725111},{"$f":"1/PRODUCT($C218:D218)","v":0.91385753008657311},{"$f":"1/PRODUCT($C218:E218)","v":0.87527678814842536},{"$f":"1/PRODUCT($C218:F218)","v":0.83939242114254764},{"$f":"1/PRODUCT($C218:G218)","v":0.80600566806916085}]

{"sheet":"Output Tables","index":3,"n_rows":11,"n_cols":11,"rows_kept":11,"cut":false,"hidden":false,"merged":[[0,1,0,2],[0,3,0,4],[0,5,0,6],[0,7,0,8],[0,9,0,10],[2,7,2,8],[5,7,5,8],[2,9,2,10],[5,9,5,10],[2,1,2,2],[5,1,5,2],[2,3,2,4],[5,3,5,4],[2,5,2,6],[5,5,5,6],[8,1,8,2],[8,3,8,4],[8,5,8,6],[8,7,8,8],[8,9,8,10],[9,1,10,1],[9,3,10,3],[9,5,10,5],[9,7,10,7],[9,9,10,9]]}
["Public Lighting Prices","2020-21",null,"2021-22",null,"2022-23",null,"2023-24",null,"2024-25"]
[null,"Conventional","LED","Conventional","LED","Conventional","LED","Conventional","LED","Conventional","LED"]
["NPL1 (Ergon Owned & Operated)"]
["Major",{"$f":"'Public Lighting Pricing'!C202","v":0.93642000000000003},{"$f":"'Public Lighting Pricing'!C204","v":0.39860000000000001},{"$f":"'Public Lighting Pricing'!D202","v":0.95860999999999996},{"$f":"'Public Lighting Pricing'!D204","v":0.40805000000000002},{"$f":"'Public Lighting Pricing'!E202","v":0.98133000000000004},{"$f":"'Public Lighting Pricing'!E204","v":0.41771999999999998},{"$f":"'Public Lighting Pricing'!F202","v":1.0045900000000001},{"$f":"'Public Lighting Pricing'!F204","v":0.42762},{"$f":"'Public Lighting Pricing'!G202","v":1.0284},{"$f":"'Public Lighting Pricing'!G204","v":0.43774999999999997}]
["Minor",{"$f":"'Public Lighting Pricing'!C203","v":0.55791000000000002},{"$f":"'Public Lighting Pricing'!C205","v":0.25305},{"$f":"'Public Lighting Pricing'!D203","v":0.57113000000000003},{"$f":"'Public Lighting Pricing'!D205","v":0.25905},{"$f":"'Public Lighting Pricing'!E203","v":0.58467000000000002},{"$f":"'Public Lighting Pricing'!E205","v":0.26518999999999998},{"$f":"'Public Lighting Pricing'!F203","v":0.59853000000000001},{"$f":"'Public Lighting Pricing'!F205","v":0.27148},{"$f":"'Public Lighting Pricing'!G203","v":0.61272000000000004},{"$f":"'Public Lighting Pricing'!G205","v":0.27790999999999999}]
["NPL2 (Gifted & Ergon Operated)"]
["Major",{"$f":"'Public Lighting Pricing'!C208","v":0.37814999999999999},{"$f":"'Public Lighting Pricing'!C210","v":0.29189999999999999},{"$f":"'Public Lighting Pricing'!D208","v":0.38711000000000001},{"$f":"'Public Lighting Pricing'!D210","v":0.29881999999999997},{"$f":"'Public Lighting Pricing'!E208","v":0.39628000000000002},{"$f":"'Public Lighting Pricing'!E210","v":0.30590000000000001},{"$f":"'Public Lighting Pricing'!F208","v":0.40566999999999998},{"$f":"'Public Lighting Pricing'!F210","v":0.31314999999999998},{"$f":"'Public Lighting Pricing'!G208","v":0.41527999999999998},{"$f":"'Public Lighting Pricing'!G210","v":0.32057000000000002}]
["Minor",{"$f":"'Public Lighting Pricing'!C209","v":0.24772},{"$f":"'Public Lighting Pricing'!C211","v":0.19377},{"$f":"'Public Lighting Pricing'!D209","v":0.25358999999999998},{"$f":"'Public Lighting Pricing'!D211","v":0.19836000000000001},{"$f":"'Public Lighting Pricing'!E209","v":0.2596},{"$f":"'Public Lighting Pricing'!E211","v":0.20305999999999999},{"$f":"'Public Lighting Pricing'!F209","v":0.26574999999999999},{"$f":"'Public Lighting Pricing'!F211","v":0.20787},{"$f":"'Public Lighting Pricing'!G209","v":0.27205000000000001},{"$f":"'Public Lighting Pricing'!G211","v":0.21279999999999999}]
["NPL4"]
["Major",null,{"$f":"'Public Lighting Pricing'!C214","v":0.33740000000000003},null,{"$f":"'Public Lighting Pricing'!D214","v":0.34539900000000001},null,{"$f":"'Public Lighting Pricing'!E214","v":0.35358400000000001},null,{"$f":"'Public Lighting Pricing'!F214","v":0.36196400000000001},null,{"$f":"'Public Lighting Pricing'!G214","v":0.37053899999999995}]
["Minor",null,{"$f":"'Public Lighting Pricing'!C215","v":0.215889},null,{"$f":"'Public Lighting Pricing'!D215","v":0.22100700000000001},null,{"$f":"'Public Lighting Pricing'!E215","v":0.22624499999999997},null,{"$f":"'Public Lighting Pricing'!F215","v":0.23160999999999998},null,{"$f":"'Public Lighting Pricing'!G215","v":0.237097}]

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