{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Ergon >>>","Input Data","Public Lighting Pricing","Output Tables"],"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":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Input Data","index":1,"n_rows":91,"n_cols":7,"rows_kept":91,"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 (SV)","#",7799.1119530484129,7267.3821541952557,6547.9210994359501,5680.8507289070203,4673.5791782641572]
["Minor Conventional (SV)","#",20028.940982116179,18639.965804192609,16778.886404687852,14557.729324922677,11986.246311121287]
["Major Conventional (non SV)","#",17973.268416130035,16747.882441781105,15089.86461488138,13091.677052116815,10770.392006252145]
["Minor Conventional (non SV)","#",46157.246431331827,42956.314857782025,38667.406095810125,33548.68839700814,27622.634929278865]
["Major LED","#",169.61963082155185,2086.7354040236373,4634.2142856826686,7669.4722189761642,11178.0288154837]
["Minor LED","#",419.81258655199815,5164.7193380253648,11489.707499502027,19034.582278069185,27757.118759599849]
["Total","#",{"$f":"SUM(C6:C11)","v":92548.000000000015},{"$f":"SUM(D6:D11)","v":92862.999999999985},93208,93583,93988]
[]
["NPL2 (Gifted & Energex Operated)"]
["Major Conventional (SV)","#",6289.2285880251129,5885.6353245871214,5334.4830897039592,4672.7403607920069,3903.5634018152186]
["Minor Conventional (SV)","#",16648.066959756488,15559.764449928114,14101.086573063236,12363.768354691278,10359.80844143893]
["Major Conventional (non SV)","#",9310.235193501323,8712.7774683559965,7896.881391060223,6917.2731040454446,5778.624970452207]
["Minor Conventional (non SV)","#",24644.901476090621,23033.837068689012,20874.488920487322,18302.656621404563,15336.102321525557]
["Major LED","#",119.53621847356165,1470.5872070568826,3187.6355192358169,5178.9865351625485,7436.8116277325735]
["Minor LED","#",291.03156415288851,3580.3984813828793,7788.4245064494362,12687.575023904159,18248.08923703551]
["Total","#",{"$f":"SUM(C15:C20)","v":57302.999999999993},{"$f":"SUM(D15:D20)","v":58243.000000000007},59182.999999999993,60123,61063]
["Total Opening Lights","#",{"$f":"SUM(C12,C21)","v":149851},{"$f":"SUM(D12,D21)","v":151106},152391,153706,155051]
[]
["Public Lights Additions by Type"]
[]
["NPL1 (Ergon Owned & Operated)"]
["Major Conventional (SV)","#",0,0,0,0,0]
["Minor Conventional (SV)","#",0,0,0,0,0]
["Major Conventional (non SV)","#",0,0,0,0,0]
["Minor Conventional (non SV)","#",0,0,0,0,0]
["Major LED","#",2086.7354040236373,2547.4788816590308,3035.2579332934956,3508.5565965075357,4009.8596759843308]
["Minor LED","#",5164.7193380253648,6324.9881614766618,7544.8747785671594,8722.5364815306639,10015.050283513712]
["Total","#",{"$f":"SUM(C27:C32)","v":7251.4547420490017},8872.4670431356935,10580.132711860655,12231.0930780382,14024.909959498043]
[]
["NPL2 (Gifted & Ergon Operated)"]
["Major Conventional (SV)","#",0,0,0,0,0]
["Minor Conventional (SV)","#",0,0,0,0,0]
["Major Conventional (non SV)","#",0,0,0,0,0]
["Minor Conventional (non SV)","#",0,0,0,0,0]
["Major LED","#",1470.5872070568826,1717.0483121789346,1991.3510159267316,2257.8250925700249,2552.9093334020777]
["Minor LED","#",3580.3984813828793,4208.0260250665569,4899.1505174547228,5560.5142131313514,6334.9187896059102]
["Total","#",{"$f":"SUM(C36:C41)","v":5050.9856884397614},5925.0743372454917,6890.5015333814545,7818.3393057013764,8887.8281230079883]
["Total Additions","#",{"$f":"SUM(C33,C42)","v":12302.440430488763},14797.541380381186,17470.634245242109,20049.432383739579,22912.738082506032]
[]
["Public Lights Disposals by Type"]
[]
["NPL1 (Ergon Owned & Operated)"]
["Major Conventional (SV)","#",583.05926362366995,719.46105475930449,867.07037052893054,1007.2715506428632,1155.9472905174532]
["Minor Conventional (SV)","#",1516.0168137723665,1861.0793995047588,2221.1570797651743,2571.483013801389,2956.5649294529949]
["Major Conventional (non SV)","#",1343.6761403999674,1658.0178268997263,1998.187562764565,2321.2850458646726,2663.9123854668774]
["Minor Conventional (non SV)","#",3493.7025242529976,4288.908761971903,5118.7176988019855,5926.0534677292744,6813.4853540607173]
["Major LED","#",0,0,0,0,0]
["Minor LED","#",0,0,0,0,0]
["Total","#",{"$f":"SUM(C48:C53)","v":6936.4547420490017},8527.4670431356935,10205.132711860655,11826.093078038199,13589.909959498043]
[]
["NPL2 (Gifted & Ergon Operated)"]
["Major Conventional (SV)","#",451.78662527768876,551.15223488316178,661.74272891195199,769.17695897678857,888.1459356870273]
["Minor Conventional (SV)","#",1205.6375707588429,1458.6778768648721,1737.3182183719616,2003.9599132523467,2316.1762476900103]
["Major Conventional (non SV)","#",668.80058177919375,815.89607729577267,979.60828701477942,1138.6481335932365,1314.7633977150501]
["Minor Conventional (non SV)","#",1784.7609106240361,2159.3481482016846,2571.832299082761,2966.5542998790042,3428.7425419158999]
["Major LED","#",0,0,0,0,0]
["Minor LED","#",0,0,0,0,0]
["Total","#",{"$f":"SUM(C57:C62)","v":4110.9856884397614},4985.0743372454908,5950.5015333814536,6878.3393057013764,7947.8281230079874]
["Total Disposals","#",{"$f":"SUM(C54,C63)","v":11047.440430488763},13512.541380381184,16155.634245242109,18704.432383739575,21537.738082506032]
[]
["Public Lights Contributed Assets"]
[]
["Contributed Assets (Conventional)"]
["Gifted","$M Nominal",0.40391459482471159,0.41104938292496385,0.39106166792276736,0.39773692837315444,0.36015944321221266]
["Cash Contribution","$M Nominal",2.1118148833544694,2.1118148833544694,2.1118148833544694,2.1118148833544694,2.1118148833544694]
["Total Contributed","$M Nominal",{"$f":"SUM(C69:C70)","v":2.515729478179181},{"$f":"SUM(D69:D70)","v":2.5228642662794334},2.5028765512772368,2.5095518117276239,2.471974326566682]
[]
["Contributed Assets (LED)"]
["Gifted","$M Nominal",8.0223862437687146,8.4290593690366666,8.8789086663422445,9.3121724928465266,9.8076460941760804]
["Cash Contribution","$M Nominal",2.1118148833544694,2.1118148833544694,2.1118148833544694,2.1118148833544694,2.1118148833544694]
["Total Contributed","$M Nominal",{"$f":"SUM(C74:C75)","v":10.134201127123184},{"$f":"SUM(D74:D75)","v":10.540874252391136},10.990723549696714,11.423987376200996,11.91946097753055]
[]
["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.5000000000000001E-2]
["Discount rate for smoothing","%",5.4920000000000004E-2]
["X factor","%",0]
["Z factor Conventional","%",0.20457660261384553]
["Z factor LED","%",0.11546254822655058]
[]
["% of PLAB associated with Poles, cabling and some residual brackets","%",0.7]

{"sheet":"Public Lighting Pricing","index":2,"n_rows":219,"n_cols":9,"rows_kept":219,"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.05938274656304,12.287610903301667,11.119841413284217,9.589832477285638,7.6401653102874825]
["O&M LED","$M Nominal",0.60868382248223385,1.5826537698409648,2.720605737847591,4.2584714785490174,6.0965973060328214]
["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",{"$f":"1.00317406959349*(C125+C126)/C129","v":0.95550002522246069},{"$f":"0.990862955391002*(D125+D126)/D129","v":0.8622211548076788},{"$f":"1.00995590023751*(E125+E126)/E129","v":0.77348137357011915},{"$f":"1.02916555307366*(F125+F126)/F129","v":0.66520531697708918},{"$f":"1.05163753470235*(G125+G126)/G129","v":0.53792502219699234},null,"Tax Building Block for ACS Public Lighting LED is pro-rata allocated to both Conventional and LED based on the porportion of lights in the total public light population"]
["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*'Input Data'!C69/'Input Data'!C$71","v":0.15341093265006595},{"$f":"D10*'Input Data'!D69/'Input Data'!D$71","v":0.14048138790725212},{"$f":"E10*'Input Data'!E69/'Input Data'!E$71","v":0.12085251104420897},{"$f":"F10*'Input Data'!F69/'Input Data'!F$71","v":0.10542787691233929},{"$f":"G10*'Input Data'!G69/'Input Data'!G$71","v":7.8374105427490071E-2}]
["Tax liability attributable to Contributed Assets","$M Nominal",{"$f":"C10*'Input Data'!C70/'Input Data'!C$71","v":0.80208909257239469},{"$f":"D10*'Input Data'!D70/'Input Data'!D$71","v":0.72173976690042663},{"$f":"E10*'Input Data'!E70/'Input Data'!E$71","v":0.65262886252591024},{"$f":"F10*'Input Data'!F70/'Input Data'!F$71","v":0.55977744006474983},{"$f":"G10*'Input Data'!G70/'Input Data'!G$71","v":0.45955091676950227}]
["Benchmark Tax liability LED","$M Nominal",{"$f":"1.00317406959349*(C127+C128)/C129","v":4.7674044371029352E-2},{"$f":"0.990862955391002*(D127+D128)/D129","v":0.12864180058332317},{"$f":"1.00995590023751*(E127+E128)/E129","v":0.23647452666739099},{"$f":"1.02916555307366*(F127+F128)/F129","v":0.36396023609657085},{"$f":"1.05163753470235*(G127+G128)/G129","v":0.51371251250535777},null,"Tax Building Block for ACS Public Lighting LED is pro-rata allocated to both Conventional and LED based on the porportion of lights in the total public light population"]
["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":"C$15*'Input Data'!C74/'Input Data'!C$76","v":3.7739491544464224E-2},{"$f":"D$15*'Input Data'!D74/'Input Data'!D$76","v":0.10286901717005427},{"$f":"E$15*'Input Data'!E74/'Input Data'!E$76","v":0.19103707910606277},{"$f":"F$15*'Input Data'!F74/'Input Data'!F$76","v":0.29667929309245267},{"$f":"G$15*'Input Data'!G74/'Input Data'!G$76","v":0.42269617110205765}]
["Tax liability attributable to Contributed Assets","$M Nominal",{"$f":"C$15*'Input Data'!C75/'Input Data'!C$76","v":9.9345528265651298E-3},{"$f":"D$15*'Input Data'!D75/'Input Data'!D$76","v":2.5772783413268902E-2},{"$f":"E$15*'Input Data'!E75/'Input Data'!E$76","v":4.5437447561328233E-2},{"$f":"F$15*'Input Data'!F75/'Input Data'!F$76","v":6.7280943004118188E-2},{"$f":"G$15*'Input Data'!G75/'Input Data'!G$76","v":9.1016341403300088E-2}]
["Total Opex Charge Conventional","$M Nominal",{"$f":"SUM(C6,C8)+C11+C6/(C6+C24+C25)*(C13+C14)","v":13.590581422437749},{"$f":"SUM(D6,D8)+D11+D6/(D6+D24+D25)*(D13+D14)","v":12.759904574244601},11.53396044107817,9.9359312732947576,7.9139629887244167]
["Total Opex Charge LED","$M Nominal",{"$f":"SUM(C7,C9)+C16+C7/(C7+C28+C29)*(C18+C19)","v":0.63060497944458049},{"$f":"SUM(D7,D9)+D16+D7/(D7+D28+D29)*(D18+D19)","v":1.6403767393524997},2.8242201474070918,4.4189101064167664,6.3249856175032289]
[]
["Capex Charge Conventional",null,1,1,1,1,1]
["Return on capital","$M Nominal",4.3244707049163393,3.8428471480321571,3.2852674352724733,2.6302230840637648,1.8772353831680704]
["Return of capital","$M Nominal",6.1068687781707807,6.3018520021123994,6.3642584902182247,6.2116975287188154,5.4930848504228926]
["Total Capex Charge Conventional","$M Nominal",{"$f":"(SUM(C24:C25)+C12+(C24+C25)/(C6+C24+C25)*(C13+C14))*C23","v":10.855640832434872},{"$f":"(SUM(D24:D25)+D12+(D24+D25)/(D6+D24+D25)*(D13+D14))*D23","v":10.534626634009303},10.008888271266864,9.1610271337505491,7.634447577351021]
["Capex Charge LED"]
["Return on capital","$M Nominal",0.34065653198040874,0.966776150436502,1.6622728663803819,2.449984926399817,3.3161092095620344]
["Return of capital","$M Nominal",0.37442278499162701,0.97768298425945677,1.8262380315875304,2.9520243990930681,4.300334662614989]
["Total Capex Charge LED","$M Nominal",{"$f":"SUM(C28:C29)+C17+(C28+C29)/(C7+C28+C29)*(C18+C19)","v":0.74083220438071851},{"$f":"SUM(D28:D29)+D17+(D28+D29)/(D7+D28+D29)*(D18+D19)","v":2.0153779657677471},3.6213710150758023,5.605530933721707,7.9017680732119731]
[]
["ARR for Conventional","$M Nominal",{"$f":"SUM(C20,C26)","v":24.446222254872623},{"$f":"SUM(D20,D26)","v":23.294531208253904},21.542848712345034,19.096958407045307,15.548410566075438]
["ARR for LED","$M Nominal",{"$f":"SUM(C21,C30)","v":1.371437183825299},{"$f":"SUM(D21,D30)","v":3.6557547051202466},6.4455911624828941,10.024441040138473,14.226753690715203]
["ARR for Total","$M Nominal",{"$f":"C32+C33","v":25.817659438697923},{"$f":"D32+D33","v":26.950285913374152},{"$f":"E32+E33","v":27.988439874827929},{"$f":"F32+F33","v":29.12139944718378},{"$f":"G32+G33","v":29.775164256790639}]
[]
["Opex and Capex Charge Components"]
["Opex Charge for Conventional Lights","$M Nominal",{"$f":"C20","v":13.590581422437749},12.759904574244601,11.53396044107817,9.9359312732947576,7.9139629887244167]
["Opex Charge for LED","$M Nominal",0.63060497944458049,1.6403767393524997,2.8242201474070918,4.4189101064167664,6.3249856175032289]
["Capex Charge for Conventional Lights","$M Nominal",{"$f":"C26","v":10.855640832434872},{"$f":"D26","v":10.534626634009303},10.008888271266864,9.1610271337505491,7.634447577351021]
["Capex Charge for LED","$M Nominal",{"$f":"C30","v":0.74083220438071851},{"$f":"D30","v":2.0153779657677471},{"$f":"E30","v":3.6213710150758023},{"$f":"F30","v":5.605530933721707},{"$f":"G30","v":7.9017680732119731}]
[]
["Public Lights Population"]
[]
["Opening Population Public Lights"]
["NPL1 (Ergon Owned & Operated)"]
["Major Conventional","#",{"$f":"'Input Data'!C6+'Input Data'!C8","v":25772.380369178449},{"$f":"'Input Data'!D6+'Input Data'!D8","v":24015.264595976361},{"$f":"'Input Data'!E6+'Input Data'!E8","v":21637.785714317331},{"$f":"'Input Data'!F6+'Input Data'!F8","v":18772.527781023833},{"$f":"'Input Data'!G6+'Input Data'!G8","v":15443.971184516302}]
["Minor Conventional","#",{"$f":"'Input Data'!C7+'Input Data'!C9","v":66186.187413448002},{"$f":"'Input Data'!D7+'Input Data'!D9","v":61596.280661974633},{"$f":"'Input Data'!E7+'Input Data'!E9","v":55446.292500497977},{"$f":"'Input Data'!F7+'Input Data'!F9","v":48106.417721930819},{"$f":"'Input Data'!G7+'Input Data'!G9","v":39608.881240400151}]
["Major LED","#",{"$f":"'Input Data'!C10","v":169.61963082155185},{"$f":"'Input Data'!D10","v":2086.7354040236373},{"$f":"'Input Data'!E10","v":4634.2142856826686},{"$f":"'Input Data'!F10","v":7669.4722189761642},{"$f":"'Input Data'!G10","v":11178.0288154837}]
["Minor LED","#",{"$f":"'Input Data'!C11","v":419.81258655199815},{"$f":"'Input Data'!D11","v":5164.7193380253648},{"$f":"'Input Data'!E11","v":11489.707499502027},{"$f":"'Input Data'!F11","v":19034.582278069185},{"$f":"'Input Data'!G11","v":27757.118759599849}]
["Total","#",{"$f":"SUM(C46:C49)","v":92548.000000000015},{"$f":"SUM(D46:D49)","v":92862.999999999985},{"$f":"SUM(E46:E49)","v":93208},{"$f":"SUM(F46:F49)","v":93583},{"$f":"SUM(G46:G49)","v":93988}]
[]
["NPL2 (Gifted & Ergon Operated)"]
["Major Conventional","#",{"$f":"'Input Data'!C15+'Input Data'!C17","v":15599.463781526436},{"$f":"'Input Data'!D15+'Input Data'!D17","v":14598.412792943118},{"$f":"'Input Data'!E15+'Input Data'!E17","v":13231.364480764183},{"$f":"'Input Data'!F15+'Input Data'!F17","v":11590.013464837451},{"$f":"'Input Data'!G15+'Input Data'!G17","v":9682.1883722674247}]
["Minor Conventional","#",{"$f":"'Input Data'!C16+'Input Data'!C18","v":41292.968435847113},{"$f":"'Input Data'!D16+'Input Data'!D18","v":38593.601518617128},{"$f":"'Input Data'!E16+'Input Data'!E18","v":34975.575493550554},{"$f":"'Input Data'!F16+'Input Data'!F18","v":30666.424976095841},{"$f":"'Input Data'!G16+'Input Data'!G18","v":25695.910762964486}]
["Major LED","#",{"$f":"'Input Data'!C19","v":119.53621847356165},{"$f":"'Input Data'!D19","v":1470.5872070568826},{"$f":"'Input Data'!E19","v":3187.6355192358169},{"$f":"'Input Data'!F19","v":5178.9865351625485},{"$f":"'Input Data'!G19","v":7436.8116277325735}]
["Minor LED","#",{"$f":"'Input Data'!C20","v":291.03156415288851},{"$f":"'Input Data'!D20","v":3580.3984813828793},{"$f":"'Input Data'!E20","v":7788.4245064494362},{"$f":"'Input Data'!F20","v":12687.575023904159},{"$f":"'Input Data'!G20","v":18248.08923703551}]
["Total","#",{"$f":"SUM(C53:C56)","v":57303},{"$f":"SUM(D53:D56)","v":58243.000000000007},{"$f":"SUM(E53:E56)","v":59182.999999999993},{"$f":"SUM(F53:F56)","v":60123},{"$f":"SUM(G53:G56)","v":61063}]
["Total Opening Lights","#",{"$f":"SUM(C50,C57)","v":149851},{"$f":"SUM(D50,D57)","v":151106},{"$f":"SUM(E50,E57)","v":152391},{"$f":"SUM(F50,F57)","v":153706},{"$f":"SUM(G50,G57)","v":155051}]
[]
["Plus Additions"]
["NPL1 (Ergon Owned & Operated)"]
["Major Conventional","#",{"$f":"'Input Data'!C27+'Input Data'!C29","v":0},{"$f":"'Input Data'!D27+'Input Data'!D29","v":0},{"$f":"'Input Data'!E27+'Input Data'!E29","v":0},{"$f":"'Input Data'!F27+'Input Data'!F29","v":0},{"$f":"'Input Data'!G27+'Input Data'!G29","v":0}]
["Minor Conventional","#",{"$f":"'Input Data'!C28+'Input Data'!C30","v":0},{"$f":"'Input Data'!D28+'Input Data'!D30","v":0},{"$f":"'Input Data'!E28+'Input Data'!E30","v":0},{"$f":"'Input Data'!F28+'Input Data'!F30","v":0},{"$f":"'Input Data'!G28+'Input Data'!G30","v":0}]
["Major LED","#",{"$f":"'Input Data'!C31","v":2086.7354040236373},{"$f":"'Input Data'!D31","v":2547.4788816590308},{"$f":"'Input Data'!E31","v":3035.2579332934956},{"$f":"'Input Data'!F31","v":3508.5565965075357},{"$f":"'Input Data'!G31","v":4009.8596759843308}]
["Minor LED","#",{"$f":"'Input Data'!C32","v":5164.7193380253648},{"$f":"'Input Data'!D32","v":6324.9881614766618},{"$f":"'Input Data'!E32","v":7544.8747785671594},{"$f":"'Input Data'!F32","v":8722.5364815306639},{"$f":"'Input Data'!G32","v":10015.050283513712}]
["Total","#",{"$f":"SUM(C62:C65)","v":7251.4547420490017},{"$f":"SUM(D62:D65)","v":8872.4670431356935},{"$f":"SUM(E62:E65)","v":10580.132711860655},{"$f":"SUM(F62:F65)","v":12231.0930780382},{"$f":"SUM(G62:G65)","v":14024.909959498043}]
[]
["NPL2 (Gifted & Ergon Operated)"]
["Major Conventional","#",{"$f":"'Input Data'!C36+'Input Data'!C38","v":0},{"$f":"'Input Data'!D36+'Input Data'!D38","v":0},{"$f":"'Input Data'!E36+'Input Data'!E38","v":0},{"$f":"'Input Data'!F36+'Input Data'!F38","v":0},{"$f":"'Input Data'!G36+'Input Data'!G38","v":0}]
["Minor Conventional","#",{"$f":"'Input Data'!C37+'Input Data'!C39","v":0},{"$f":"'Input Data'!D37+'Input Data'!D39","v":0},{"$f":"'Input Data'!E37+'Input Data'!E39","v":0},{"$f":"'Input Data'!F37+'Input Data'!F39","v":0},{"$f":"'Input Data'!G37+'Input Data'!G39","v":0}]
["Major LED","#",{"$f":"'Input Data'!C40","v":1470.5872070568826},{"$f":"'Input Data'!D40","v":1717.0483121789346},{"$f":"'Input Data'!E40","v":1991.3510159267316},{"$f":"'Input Data'!F40","v":2257.8250925700249},{"$f":"'Input Data'!G40","v":2552.9093334020777}]
["Minor LED","#",{"$f":"'Input Data'!C41","v":3580.3984813828793},{"$f":"'Input Data'!D41","v":4208.0260250665569},{"$f":"'Input Data'!E41","v":4899.1505174547228},{"$f":"'Input Data'!F41","v":5560.5142131313514},{"$f":"'Input Data'!G41","v":6334.9187896059102}]
["Total","#",{"$f":"SUM(C69:C72)","v":5050.9856884397614},{"$f":"SUM(D69:D72)","v":5925.0743372454917},{"$f":"SUM(E69:E72)","v":6890.5015333814545},{"$f":"SUM(F69:F72)","v":7818.3393057013764},{"$f":"SUM(G69:G72)","v":8887.8281230079883}]
["Total Additions","#",{"$f":"SUM(C66,C73)","v":12302.440430488763},{"$f":"SUM(D66,D73)","v":14797.541380381186},{"$f":"SUM(E66,E73)","v":17470.634245242109},{"$f":"SUM(F66,F73)","v":20049.432383739579},{"$f":"SUM(G66,G73)","v":22912.738082506032}]
[]
["Less Disposals"]
["NPL1 (Ergon Owned & Operated)"]
["Major Conventional","#",{"$f":"'Input Data'!C48+'Input Data'!C50","v":1926.7354040236373},{"$f":"'Input Data'!D48+'Input Data'!D50","v":2377.4788816590308},{"$f":"'Input Data'!E48+'Input Data'!E50","v":2865.2579332934956},{"$f":"'Input Data'!F48+'Input Data'!F50","v":3328.5565965075357},{"$f":"'Input Data'!G48+'Input Data'!G50","v":3819.8596759843304}]
["Minor Conventional","#",{"$f":"'Input Data'!C49+'Input Data'!C51","v":5009.7193380253639},{"$f":"'Input Data'!D49+'Input Data'!D51","v":6149.9881614766618},{"$f":"'Input Data'!E49+'Input Data'!E51","v":7339.8747785671603},{"$f":"'Input Data'!F49+'Input Data'!F51","v":8497.5364815306639},{"$f":"'Input Data'!G49+'Input Data'!G51","v":9770.0502835137122}]
["Major LED","#",{"$f":"'Input Data'!C52","v":0},{"$f":"'Input Data'!D52","v":0},{"$f":"'Input Data'!E52","v":0},{"$f":"'Input Data'!F52","v":0},{"$f":"'Input Data'!G52","v":0}]
["Minor LED","#",{"$f":"'Input Data'!C53","v":0},{"$f":"'Input Data'!D53","v":0},{"$f":"'Input Data'!E53","v":0},{"$f":"'Input Data'!F53","v":0},{"$f":"'Input Data'!G53","v":0}]
["Total","#",{"$f":"SUM(C78:C81)","v":6936.4547420490017},{"$f":"SUM(D78:D81)","v":8527.4670431356935},{"$f":"SUM(E78:E81)","v":10205.132711860657},{"$f":"SUM(F78:F81)","v":11826.0930780382},{"$f":"SUM(G78:G81)","v":13589.909959498043}]
[]
["NPL2 (Gifted & Ergon Operated)"]
["Major Conventional","#",{"$f":"'Input Data'!C57+'Input Data'!C59","v":1120.5872070568826},{"$f":"'Input Data'!D57+'Input Data'!D59","v":1367.0483121789343},{"$f":"'Input Data'!E57+'Input Data'!E59","v":1641.3510159267314},{"$f":"'Input Data'!F57+'Input Data'!F59","v":1907.8250925700249},{"$f":"'Input Data'!G57+'Input Data'!G59","v":2202.9093334020772}]
["Minor Conventional","#",{"$f":"'Input Data'!C58+'Input Data'!C60","v":2990.3984813828793},{"$f":"'Input Data'!D58+'Input Data'!D60","v":3618.0260250665569},{"$f":"'Input Data'!E58+'Input Data'!E60","v":4309.1505174547228},{"$f":"'Input Data'!F58+'Input Data'!F60","v":4970.5142131313514},{"$f":"'Input Data'!G58+'Input Data'!G60","v":5744.9187896059102}]
["Major LED","#",{"$f":"'Input Data'!C61","v":0},{"$f":"'Input Data'!D61","v":0},{"$f":"'Input Data'!E61","v":0},{"$f":"'Input Data'!F61","v":0},{"$f":"'Input Data'!G61","v":0}]
["Minor LED","#",{"$f":"'Input Data'!C62","v":0},{"$f":"'Input Data'!D62","v":0},{"$f":"'Input Data'!E62","v":0},{"$f":"'Input Data'!F62","v":0},{"$f":"'Input Data'!G62","v":0}]
["Total","#",{"$f":"SUM(C85:C88)","v":4110.9856884397614},{"$f":"SUM(D85:D88)","v":4985.0743372454908},{"$f":"SUM(E85:E88)","v":5950.5015333814545},{"$f":"SUM(F85:F88)","v":6878.3393057013764},{"$f":"SUM(G85:G88)","v":7947.8281230079874}]
["Total Disposals","#",{"$f":"SUM(C82,C89)","v":11047.440430488763},{"$f":"SUM(D82,D89)","v":13512.541380381184},{"$f":"SUM(E82,E89)","v":16155.634245242112},{"$f":"SUM(F82,F89)","v":18704.432383739579},{"$f":"SUM(G82,G89)","v":21537.738082506032}]
[]
["Closing Population Public Lights"]
["NPL1 (Ergon Owned & Operated)"]
["Major Conventional","#",{"$f":"(C46+C62-C78)","v":23845.64496515481},21637.785714317331,18772.527781023837,15443.971184516296,11624.111508531973]
["Minor Conventional","#",61176.468075422636,55446.29250049797,48106.417721930819,39608.881240400151,29838.830956886439]
["Major LED","#",2256.355034845189,4634.2142856826686,7669.4722189761642,11178.0288154837,15187.888491468031]
["Minor LED","#",5584.5319245773626,11489.707499502027,19034.582278069185,27757.118759599849,37772.169043113565]
["Total","#",{"$f":"SUM(C94:C97)","v":92862.999999999985},{"$f":"SUM(D94:D97)","v":93207.999999999985},{"$f":"SUM(E94:E97)","v":93583},{"$f":"SUM(F94:F97)","v":93988},{"$f":"SUM(G94:G97)","v":94423}]
[]
["NPL2 (Gifted & Ergon Operated)"]
["Major Conventional","#",{"$f":"(C53+C69-C85)","v":14478.876574469554},13231.364480764183,11590.013464837451,9682.1883722674265,7479.2790388653475]
["Minor Conventional","#",38302.569954464234,34975.575493550568,30666.42497609583,25695.91076296449,19950.991973358578]
["Major LED","#",1590.1234255304441,3187.6355192358169,5178.9865351625485,7436.8116277325735,9989.7209611346516]
["Minor LED","#",3871.4300455357679,7788.4245064494362,12687.575023904159,18248.08923703551,24583.008026641422]
["Total","#",{"$f":"SUM(C101:C104)","v":58243},{"$f":"SUM(D101:D104)","v":59183.000000000007},{"$f":"SUM(E101:E104)","v":60122.999999999993},{"$f":"SUM(F101:F104)","v":61063},{"$f":"SUM(G101:G104)","v":62003}]
["Grand Total","#",{"$f":"SUM(C98,C105)","v":151106},{"$f":"SUM(D98,D105)","v":152391},{"$f":"SUM(E98,E105)","v":153706},{"$f":"SUM(F98,F105)","v":155051},{"$f":"SUM(G98,G105)","v":156426}]
[]
["Average No of Lights"]
["NPL1 (Ergon Owned & Operated)"]
["Major Conventional","#",{"$f":"(C46+C94)/2","v":24809.012667166629},22826.525155146846,20205.156747670582,17108.249482770065,13534.041346524136]
["Minor Conventional","#",63681.327744435315,58521.286581236302,51776.355111214398,43857.649481165485,34723.856098643293]
["Major LED","#",1212.9873328333704,3360.4748448531527,6151.8432523294159,9423.7505172299316,13182.958653475866]
["Minor LED","#",3002.1722555646802,8327.2134187636948,15262.144888785606,23395.850518834515,32764.643901356707]
["Total","#",{"$f":"SUM(C110:C113)","v":92705.499999999985},{"$f":"SUM(D110:D113)","v":93035.5},{"$f":"SUM(E110:E113)","v":93395.5},{"$f":"SUM(F110:F113)","v":93785.5},{"$f":"SUM(G110:G113)","v":94205.5}]
[]
["NPL2 (Gifted & Ergon Operated)"]
["Major Conventional","#",{"$f":"(C53+C101)/2","v":15039.170177997996},13914.888636853651,12410.688972800817,10636.100918552438,8580.7337055663866]
["Minor Conventional","#",39797.769195155677,36784.588506083848,32821.000234823194,28181.167869530167,22823.451368161532]
["Major LED","#",854.82982200200286,2329.1113631463495,4183.3110271991827,6307.899081447561,8713.2662944336116]
["Minor LED","#",2081.2308048443283,5684.4114939161573,10237.999765176797,15467.832130469835,21415.548631838465]
["Total","#",{"$f":"SUM(C117:C120)","v":57773},{"$f":"SUM(D117:D120)","v":58713.000000000007},{"$f":"SUM(E117:E120)","v":59652.999999999993},{"$f":"SUM(F117:F120)","v":60593},{"$f":"SUM(G117:G120)","v":61532.999999999993}]
["Grand total","#",{"$f":"SUM(C114,C121)","v":150478.5},{"$f":"SUM(D114,D121)","v":151748.5},{"$f":"SUM(E114,E121)","v":153048.5},{"$f":"SUM(F114,F121)","v":154378.5},{"$f":"SUM(G114,G121)","v":155738.5}]
[]
["2020-25 TSS Pricing Methodology"]
["Major Conventional","#",{"$f":"SUM(C110+C117)","v":39848.182845164629},36741.413792000501,32615.8457204714,27744.350401322503,22114.775052090525]
["Minor Conventional","#",103479.09693959099,95305.87508732015,84597.355346037599,72038.817350695652,57547.307466804821]
["Major LED","#",2067.817154835373,5689.5862079995022,10335.154279528599,15731.649598677493,21896.224947909475]
["Minor LED","#",5083.4030604090085,14011.624912679852,25500.144653962401,38863.682649304348,54180.192533195172]
["Total","#",{"$f":"SUM(C125:C128)","v":150478.5},{"$f":"SUM(D125:D128)","v":151748.50000000003},{"$f":"SUM(E125:E128)","v":153048.5},{"$f":"SUM(F125:F128)","v":154378.5},{"$f":"SUM(G125:G128)","v":155738.5}]
[]
["Weighted Average No of Lights"]
["Major Conventional",null,{"$f":"ROUND(C125*'Input Data'!$C$82,0)","v":71727},{"$f":"ROUND(D125*'Input Data'!$C$82,0)","v":66135},{"$f":"ROUND(E125*'Input Data'!$C$82,0)","v":58709},{"$f":"ROUND(F125*'Input Data'!$C$82,0)","v":49940},{"$f":"ROUND(G125*'Input Data'!$C$82,0)","v":39807}]
["Minor Conventional",null,{"$f":"C126","v":103479.09693959099},{"$f":"D126","v":95305.87508732015},{"$f":"E126","v":84597.355346037599},{"$f":"F126","v":72038.817350695652},{"$f":"G126","v":57547.307466804821}]
["Major LED",null,{"$f":"ROUND(C127*'Input Data'!$C$82,0)","v":3722},{"$f":"ROUND(D127*'Input Data'!$C$82,0)","v":10241},{"$f":"ROUND(E127*'Input Data'!$C$82,0)","v":18603},{"$f":"ROUND(F127*'Input Data'!$C$82,0)","v":28317},{"$f":"ROUND(G127*'Input Data'!$C$82,0)","v":39413}]
["Minor LED",null,{"$f":"C128","v":5083.4030604090085},{"$f":"D128","v":14011.624912679852},{"$f":"E128","v":25500.144653962401},{"$f":"F128","v":38863.682649304348},{"$f":"G128","v":54180.192533195172}]
["Total",null,{"$f":"SUM(C132:C135)","v":184011.5},{"$f":"SUM(D132:D135)","v":185693.50000000003},{"$f":"SUM(E132:E135)","v":187409.5},{"$f":"SUM(F132:F135)","v":189159.5},{"$f":"SUM(G132:G135)","v":190947.49999999997}]
[]
["Price Components"]
[]
["Opex Charge"]
["NPL1 (Ergon Owned & Operated)"]
["Major Conventional","$/day/light Nominal",{"$f":"C$37*1000000/(C$125+C$126/'Input Data'!$C$81)","v":124.87412499442642},{"$f":"D$37*1000000/(D$125+D$126/'Input Data'!$C$81)","v":127.24446142704943},{"$f":"E$37*1000000/(E$125+E$126/'Input Data'!$C$81)","v":129.57455833811943},{"$f":"F$37*1000000/(F$125+F$126/'Input Data'!$C$81)","v":131.13239133990737},{"$f":"G$37*1000000/(G$125+G$126/'Input Data'!$C$81)","v":130.85332704441501}]
["Minor Conventional","$/day/light Nominal",{"$f":"C142/'Input Data'!$C$81","v":83.249416662950949},{"$f":"D142/'Input Data'!$C$81","v":84.829640951366287},{"$f":"E142/'Input Data'!$C$81","v":86.383038892079625},{"$f":"F142/'Input Data'!$C$81","v":87.42159422660491},{"$f":"G142/'Input Data'!$C$81","v":87.23555136294334}]
["Major LED","$/day/light Nominal",{"$f":"C$38*1000000/(C$127+C$128/'Input Data'!$C$81)","v":115.56415215052849},{"$f":"D$38*1000000/(D$127+D$128/'Input Data'!$C$81)","v":109.13530772496654},{"$f":"E$38*1000000/(E$127+E$128/'Input Data'!$C$81)","v":103.31787978828741},{"$f":"F$38*1000000/(F$127+F$128/'Input Data'!$C$81)","v":106.11979465259503},{"$f":"G$38*1000000/(G$127+G$128/'Input Data'!$C$81)","v":109.0207373846696}]
["Minor LED","$/day/light Nominal",{"$f":"C144/'Input Data'!$C$81","v":77.042768100352319},{"$f":"D144/'Input Data'!$C$81","v":72.756871816644363},{"$f":"E144/'Input Data'!$C$81","v":68.878586525524938},{"$f":"F144/'Input Data'!$C$81","v":70.746529768396684},{"$f":"G144/'Input Data'!$C$81","v":72.680491589779734}]
[]
["NPL2 (Gifted & Ergon Operated)"]
["Major Conventional","$/day/light Nominal",{"$f":"C142","v":124.87412499442642},127.24446142704943,129.57455833811943,131.13239133990737,130.85332704441501]
["Minor Conventional","$/day/light Nominal",83.249416662950949,84.829640951366287,86.383038892079625,87.42159422660491,87.23555136294334]
["Major LED","$/day/light Nominal",115.56415215052849,109.13530772496654,103.31787978828741,106.11979465259503,109.0207373846696]
["Minor LED","$/day/light Nominal",77.042768100352319,72.756871816644363,68.878586525524938,70.746529768396684,72.680491589779734]
[]
["Capex Charge"]
["NPL1 (Ergon Owned & Operated)"]
["Major Conventional","$/day/light Nominal",{"$f":"C$39*1000000/(C$125+C$126/'Input Data'!$C$82)*(1-'Input Data'!$C$79)","v":100.3741630283058},{"$f":"D$39*1000000/(D$125+D$126/'Input Data'!$C$82)*(1-'Input Data'!$C$79)","v":105.71141450387897},{"$f":"E$39*1000000/(E$125+E$126/'Input Data'!$C$82)*(1-'Input Data'!$C$79)","v":113.1453870989026},{"$f":"F$39*1000000/(F$125+F$126/'Input Data'!$C$82)*(1-'Input Data'!$C$79)","v":121.66771964700642},{"$f":"G$39*1000000/(G$125+G$126/'Input Data'!$C$82)*(1-'Input Data'!$C$79)","v":127.0396435069888}]
["Minor Conventional","$/day/light Nominal",{"$f":"ROUND(C155/'Input Data'!$C$82,2)","v":55.76},{"$f":"ROUND(D155/'Input Data'!$C$82,2)","v":58.73},{"$f":"ROUND(E155/'Input Data'!$C$82,2)","v":62.86},{"$f":"ROUND(F155/'Input Data'!$C$82,2)","v":67.59},{"$f":"ROUND(G155/'Input Data'!$C$82,2)","v":70.58}]
["Major LED","$/day/light Nominal",{"$f":"C$40*1000000/(C$127+C$128/'Input Data'!$C$82)*(1-'Input Data'!$C$79)","v":136.29569281511064},{"$f":"D$40*1000000/(D$127+D$128/'Input Data'!$C$82)*(1-'Input Data'!$C$79)","v":134.61957065805043},{"$f":"E$40*1000000/(E$127+E$128/'Input Data'!$C$82)*(1-'Input Data'!$C$79)","v":133.01963273778719},{"$f":"F$40*1000000/(F$127+F$128/'Input Data'!$C$82)*(1-'Input Data'!$C$79)","v":135.17225350100856},{"$f":"G$40*1000000/(G$127+G$128/'Input Data'!$C$82)*(1-'Input Data'!$C$79)","v":136.77101834974326}]
["Minor LED","$/day/light Nominal",{"$f":"ROUND(C157/'Input Data'!$C$82,2)","v":75.72},{"$f":"ROUND(D157/'Input Data'!$C$82,2)","v":74.790000000000006},{"$f":"ROUND(E157/'Input Data'!$C$82,2)","v":73.900000000000006},{"$f":"ROUND(F157/'Input Data'!$C$82,2)","v":75.099999999999994},{"$f":"ROUND(G157/'Input Data'!$C$82,2)","v":75.98}]
[]
["NPL2 (Gifted & Ergon Operated)"]
["Major Conventional","$/day/light Nominal",0,0,0,0,0]
["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 (Ergon Owned & Operated)"]
["Major Conventional","$/day/light Nominal",{"$f":"C$39*1000000/(C$125+C$126/'Input Data'!$C$82)*'Input Data'!$C$79","v":11.152684780922868},{"$f":"D$39*1000000/(D$125+D$126/'Input Data'!$C$82)*'Input Data'!$C$79","v":11.745712722653218},{"$f":"E$39*1000000/(E$125+E$126/'Input Data'!$C$82)*'Input Data'!$C$79","v":12.571709677655846},{"$f":"F$39*1000000/(F$125+F$126/'Input Data'!$C$82)*'Input Data'!$C$79","v":13.518635516334047},{"$f":"G$39*1000000/(G$125+G$126/'Input Data'!$C$82)*'Input Data'!$C$79","v":14.115515945220977}]
["Minor Conventional","$/day/light Nominal",{"$f":"ROUND(C168/'Input Data'!$C$82,2)","v":6.2},{"$f":"ROUND(D168/'Input Data'!$C$82,2)","v":6.53},{"$f":"ROUND(E168/'Input Data'!$C$82,2)","v":6.98},{"$f":"ROUND(F168/'Input Data'!$C$82,2)","v":7.51},{"$f":"ROUND(G168/'Input Data'!$C$82,2)","v":7.84}]
["Major LED","$/day/light Nominal",{"$f":"C$40*1000000/(C$127+C$128/'Input Data'!$C$82)*'Input Data'!$C$79","v":15.143965868345626},{"$f":"D$40*1000000/(D$127+D$128/'Input Data'!$C$82)*'Input Data'!$C$79","v":14.957730073116716},{"$f":"E$40*1000000/(E$127+E$128/'Input Data'!$C$82)*'Input Data'!$C$79","v":14.779959193087464},{"$f":"F$40*1000000/(F$127+F$128/'Input Data'!$C$82)*'Input Data'!$C$79","v":15.019139277889838},{"$f":"G$40*1000000/(G$127+G$128/'Input Data'!$C$82)*'Input Data'!$C$79","v":15.19677981663814}]
["Minor LED","$/day/light Nominal",{"$f":"ROUND(C170/'Input Data'!$C$82,2)","v":8.41},{"$f":"ROUND(D170/'Input Data'!$C$82,2)","v":8.31},{"$f":"ROUND(E170/'Input Data'!$C$82,2)","v":8.2100000000000009},{"$f":"ROUND(F170/'Input Data'!$C$82,2)","v":8.34},{"$f":"ROUND(G170/'Input Data'!$C$82,2)","v":8.44}]
[]
["NPL2 (Gifted & Ergon Operated)"]
["Major Conventional","$/day/light Nominal",{"$f":"C168","v":11.152684780922868},11.745712722653218,12.571709677655846,13.518635516334047,14.115515945220977]
["Minor Conventional","$/day/light Nominal",6.2,6.53,6.98,7.51,7.84]
["Major LED","$/day/light Nominal",15.143965868345626,14.957730073116716,14.779959193087464,15.019139277889838,15.19677981663814]
["Minor LED","$/day/light Nominal",8.41,8.31,8.2100000000000009,8.34,8.44]
[]
["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.64723058946928158},0.66995643710768416,0.69895045890397778,0.72914098974195163,0.7447186488613956]
["Minor Conventional","$/day/light Nominal",0.39756171570965348,0.41092304161907262,0.42771536999884907,0.44495987467927423,0.45354018169183663]
["Major LED","$/day/light Nominal",0.73101659365909577,0.7083165187026248,0.68752216760893103,0.70174178626007777,0.71454766749089926]
["Minor LED","$/day/light Nominal",0.44126699000780922,0.42671285918314683,0.41338422046687184,0.42213971189157207,0.43011770455791848]
[]
["NPL2 (Gifted & Ergon Operated)"]
["Major Conventional","$/day/light Nominal",{"$f":"SUM(C148,C174)/C$179","v":0.37242110821450869},0.38053435769939126,0.38917527177488093,0.39603292773782733,0.39690306088880489]
["Minor Conventional","$/day/light Nominal",0.24489915581916757,0.25012906489080433,0.25561406951972521,0.25990853997701552,0.26030267313605299]
["Major LED","$/day/light Nominal",0.35785932380253005,0.33974822121309584,0.32333426141375737,0.33166032561392161,0.34008902724519574]
["Minor LED","$/day/light Nominal",0.2339569284061665,0.22194899881353694,0.21105704729780952,0.21652711777795122,0.22209580175162144]
[]
["Smoothed Prices"]
[]
["NPL1 (Ergon Owned & Operated)"]
["Major Conventional","$/day/light Nominal",{"$f":"ROUND(C184*(1+'Input Data'!$C$88),5)","v":0.77964},{"$f":"ROUND(C198*(1+'Input Data'!$C$85)*(1+'Input Data'!$C$87),5)","v":0.79913000000000001},{"$f":"ROUND(D198*(1+'Input Data'!$C$85)*(1+'Input Data'!$C$87),5)","v":0.81911},{"$f":"ROUND(E198*(1+'Input Data'!$C$85)*(1+'Input Data'!$C$87),5)","v":0.83958999999999995},{"$f":"ROUND(F198*(1+'Input Data'!$C$85)*(1+'Input Data'!$C$87),5)","v":0.86058000000000001}]
["Minor Conventional","$/day/light Nominal",{"$f":"ROUND(C185*(1+'Input Data'!$C$88),5)","v":0.47888999999999998},{"$f":"ROUND(C199*(1+'Input Data'!$C$85)*(1+'Input Data'!$C$87),5)","v":0.49086000000000002},{"$f":"ROUND(D199*(1+'Input Data'!$C$85)*(1+'Input Data'!$C$87),5)","v":0.50312999999999997},{"$f":"ROUND(E199*(1+'Input Data'!$C$85)*(1+'Input Data'!$C$87),5)","v":0.51571},{"$f":"ROUND(F199*(1+'Input Data'!$C$85)*(1+'Input Data'!$C$87),5)","v":0.52859999999999996}]
["Major LED","$/day/light Nominal",{"$f":"ROUND(C186*(1+'Input Data'!$C$89),5)","v":0.81542000000000003},{"$f":"ROUND(C200*(1+'Input Data'!$C$85)*(1+'Input Data'!$C$87),5)","v":0.83581000000000005},{"$f":"ROUND(D200*(1+'Input Data'!$C$85)*(1+'Input Data'!$C$87),5)","v":0.85670999999999997},{"$f":"ROUND(E200*(1+'Input Data'!$C$85)*(1+'Input Data'!$C$87),5)","v":0.87812999999999997},{"$f":"ROUND(F200*(1+'Input Data'!$C$85)*(1+'Input Data'!$C$87),5)","v":0.90007999999999999}]
["Minor LED","$/day/light Nominal",{"$f":"ROUND(C187*(1+'Input Data'!$C$89),5)","v":0.49221999999999999},{"$f":"ROUND(C201*(1+'Input Data'!$C$85)*(1+'Input Data'!$C$87),5)","v":0.50453000000000003},{"$f":"ROUND(D201*(1+'Input Data'!$C$85)*(1+'Input Data'!$C$87),5)","v":0.51714000000000004},{"$f":"ROUND(E201*(1+'Input Data'!$C$85)*(1+'Input Data'!$C$87),5)","v":0.53007000000000004},{"$f":"ROUND(F201*(1+'Input Data'!$C$85)*(1+'Input Data'!$C$87),5)","v":0.54332000000000003}]
[]
["NPL2 (Gifted & Ergon Operated)"]
["Major Conventional","$/day/light Nominal",{"$f":"ROUND(C190*(1+'Input Data'!$C$88),5)","v":0.44861000000000001},{"$f":"ROUND(C204*(1+'Input Data'!$C$85)*(1+'Input Data'!$C$87),5)","v":0.45983000000000002},{"$f":"ROUND(D204*(1+'Input Data'!$C$85)*(1+'Input Data'!$C$87),5)","v":0.47133000000000003},{"$f":"ROUND(E204*(1+'Input Data'!$C$85)*(1+'Input Data'!$C$87),5)","v":0.48310999999999998},{"$f":"ROUND(F204*(1+'Input Data'!$C$85)*(1+'Input Data'!$C$87),5)","v":0.49519000000000002}]
["Minor Conventional","$/day/light Nominal",{"$f":"ROUND(C191*(1+'Input Data'!$C$88),5)","v":0.29499999999999998},{"$f":"ROUND(C205*(1+'Input Data'!$C$85)*(1+'Input Data'!$C$87),5)","v":0.30237999999999998},{"$f":"ROUND(D205*(1+'Input Data'!$C$85)*(1+'Input Data'!$C$87),5)","v":0.30993999999999999},{"$f":"ROUND(E205*(1+'Input Data'!$C$85)*(1+'Input Data'!$C$87),5)","v":0.31768999999999997},{"$f":"ROUND(F205*(1+'Input Data'!$C$85)*(1+'Input Data'!$C$87),5)","v":0.32562999999999998}]
["Major LED","$/day/light Nominal",{"$f":"ROUND(C192*(1+'Input Data'!$C$89),5)","v":0.39917999999999998},{"$f":"ROUND(C206*(1+'Input Data'!$C$85)*(1+'Input Data'!$C$87),5)","v":0.40916000000000002},{"$f":"ROUND(D206*(1+'Input Data'!$C$85)*(1+'Input Data'!$C$87),5)","v":0.41938999999999999},{"$f":"ROUND(E206*(1+'Input Data'!$C$85)*(1+'Input Data'!$C$87),5)","v":0.42986999999999997},{"$f":"ROUND(F206*(1+'Input Data'!$C$85)*(1+'Input Data'!$C$87),5)","v":0.44062000000000001}]
["Minor LED","$/day/light Nominal",{"$f":"ROUND(C193*(1+'Input Data'!$C$89),5)","v":0.26096999999999998},{"$f":"ROUND(C207*(1+'Input Data'!$C$85)*(1+'Input Data'!$C$87),5)","v":0.26749000000000001},{"$f":"ROUND(D207*(1+'Input Data'!$C$85)*(1+'Input Data'!$C$87),5)","v":0.27417999999999998},{"$f":"ROUND(E207*(1+'Input Data'!$C$85)*(1+'Input Data'!$C$87),5)","v":0.28103},{"$f":"ROUND(F207*(1+'Input Data'!$C$85)*(1+'Input Data'!$C$87),5)","v":0.28805999999999998}]
[]
["Recovered Revenue"]
[]
["Recovered revenue Conventional","$M Nominal",{"$f":"(SUMPRODUCT(C198:C199,C110:C111)+SUMPRODUCT(C204:C205,C117:C118))*C179/1000000","v":24.955893888233405},{"$f":"(SUMPRODUCT(D198:D199,D110:D111)+SUMPRODUCT(D204:D205,D117:D118))*D179/1000000","v":23.554434447614263},21.411887971596936,18.654422575710445,15.224806926776186]
["NPV of recovered revenue Conventional","$M Nominal",{"$f":"NPV('Input Data'!C$86,C211:G211)","v":89.777394160723105}]
["NPV of revenue requirement Conventional","$M Nominal",{"$f":"NPV('Input Data'!C$86,C$32:G$32)","v":89.777288535212264}]
["Difference Conventional","$M Nominal",{"$f":"C212-C213","v":1.056255108409232E-4}]
[]
["Recovered revenue LED","$M Nominal",{"$f":"(SUMPRODUCT(C200:C201,C112:C113)+SUMPRODUCT(C206:C207,C119:C120))*C179/1000000","v":1.2240232907544213},{"$f":"(SUMPRODUCT(D200:D201,D112:D113)+SUMPRODUCT(D206:D207,D119:D120))*D179/1000000","v":3.4638666017413513},{"$f":"(SUMPRODUCT(E200:E201,E112:E113)+SUMPRODUCT(E206:E207,E119:E120))*E179/1000000","v":6.4738753883550313},{"$f":"(SUMPRODUCT(F200:F201,F112:F113)+SUMPRODUCT(F206:F207,F119:F120))*F179/1000000","v":10.130288362805254},{"$f":"(SUMPRODUCT(G200:G201,G112:G113)+SUMPRODUCT(G206:G207,G119:G120))*G179/1000000","v":14.491515121759651}]
["NPV of recovered revenue LED","$M Nominal",{"$f":"NPV('Input Data'!C$86,C216:G216)","v":29.059366273957959}]
["NPV of revenue requirement LED","$M Nominal",{"$f":"NPV('Input Data'!C$86,C$33:G$33)","v":29.059318901841664}]
["Difference LED","$M Nominal",{"$f":"C217-C218","v":4.7372116295463229E-5}]

{"sheet":"Output Tables","index":3,"n_rows":11,"n_cols":11,"rows_kept":11,"cut":false,"hidden":false,"merged":[[9,1,10,1],[9,3,10,3],[9,5,10,5],[9,7,10,7],[9,9,10,9],[8,1,8,2],[8,3,8,4],[8,5,8,6],[8,7,8,8],[8,9,8,10],[2,7,2,8],[5,7,5,8],[2,9,2,10],[5,9,5,10],[2,1,2,2],[5,1,5,2],[2,3,2,4],[5,3,5,4],[2,5,2,6],[5,5,5,6],[0,1,0,2],[0,3,0,4],[0,5,0,6],[0,7,0,8],[0,9,0,10]]}
["Public Lighting Prices","2020-21",null,"2021-22",null,"2022-23",null,"2023-24",null,"2024-25"]
[null,"Conventional","LED","Conventional","LED","Conventional","LED","Conventional","LED","Conventional","LED"]
["NPL1 (Ergon Owned & Operated)"]
["Major",{"$f":"'Public Lighting Pricing'!C198","v":0.77964},{"$f":"'Public Lighting Pricing'!C200","v":0.81542000000000003},{"$f":"'Public Lighting Pricing'!D198","v":0.79913000000000001},{"$f":"'Public Lighting Pricing'!D200","v":0.83581000000000005},{"$f":"'Public Lighting Pricing'!E198","v":0.81911},{"$f":"'Public Lighting Pricing'!E200","v":0.85670999999999997},{"$f":"'Public Lighting Pricing'!F198","v":0.83958999999999995},{"$f":"'Public Lighting Pricing'!F200","v":0.87812999999999997},{"$f":"'Public Lighting Pricing'!G198","v":0.86058000000000001},{"$f":"'Public Lighting Pricing'!G200","v":0.90007999999999999}]
["Minor",{"$f":"'Public Lighting Pricing'!C199","v":0.47888999999999998},{"$f":"'Public Lighting Pricing'!C201","v":0.49221999999999999},{"$f":"'Public Lighting Pricing'!D199","v":0.49086000000000002},{"$f":"'Public Lighting Pricing'!D201","v":0.50453000000000003},{"$f":"'Public Lighting Pricing'!E199","v":0.50312999999999997},{"$f":"'Public Lighting Pricing'!E201","v":0.51714000000000004},{"$f":"'Public Lighting Pricing'!F199","v":0.51571},{"$f":"'Public Lighting Pricing'!F201","v":0.53007000000000004},{"$f":"'Public Lighting Pricing'!G199","v":0.52859999999999996},{"$f":"'Public Lighting Pricing'!G201","v":0.54332000000000003}]
["NPL2 (Gifted & Ergon Operated)"]
["Major",{"$f":"'Public Lighting Pricing'!C204","v":0.44861000000000001},{"$f":"'Public Lighting Pricing'!C206","v":0.39917999999999998},{"$f":"'Public Lighting Pricing'!D204","v":0.45983000000000002},{"$f":"'Public Lighting Pricing'!D206","v":0.40916000000000002},{"$f":"'Public Lighting Pricing'!E204","v":0.47133000000000003},{"$f":"'Public Lighting Pricing'!E206","v":0.41938999999999999},{"$f":"'Public Lighting Pricing'!F204","v":0.48310999999999998},{"$f":"'Public Lighting Pricing'!F206","v":0.42986999999999997},{"$f":"'Public Lighting Pricing'!G204","v":0.49519000000000002},{"$f":"'Public Lighting Pricing'!G206","v":0.44062000000000001}]
["Minor",{"$f":"'Public Lighting Pricing'!C205","v":0.29499999999999998},{"$f":"'Public Lighting Pricing'!C207","v":0.26096999999999998},{"$f":"'Public Lighting Pricing'!D205","v":0.30237999999999998},{"$f":"'Public Lighting Pricing'!D207","v":0.26749000000000001},{"$f":"'Public Lighting Pricing'!E205","v":0.30993999999999999},{"$f":"'Public Lighting Pricing'!E207","v":0.27417999999999998},{"$f":"'Public Lighting Pricing'!F205","v":0.31768999999999997},{"$f":"'Public Lighting Pricing'!F207","v":0.28103},{"$f":"'Public Lighting Pricing'!G205","v":0.32562999999999998},{"$f":"'Public Lighting Pricing'!G207","v":0.28805999999999998}]
["NPL4"]
["Major",null,0.71,null,{"$f":"ROUND(C10*(1+'Input Data'!$C$85)*(1+'Input Data'!$C$87),5)","v":0.72775000000000001},null,{"$f":"ROUND(E10*(1+'Input Data'!$C$85)*(1+'Input Data'!$C$87),5)","v":0.74594000000000005},null,{"$f":"ROUND(G10*(1+'Input Data'!$C$85)*(1+'Input Data'!$C$87),5)","v":0.76458999999999999},null,{"$f":"ROUND(I10*(1+'Input Data'!$C$85)*(1+'Input Data'!$C$87),5)","v":0.78369999999999995}]
["Minor",null,0.44,null,{"$f":"ROUND(C11*(1+'Input Data'!$C$85)*(1+'Input Data'!$C$87),5)","v":0.45100000000000001},null,{"$f":"ROUND(E11*(1+'Input Data'!$C$85)*(1+'Input Data'!$C$87),5)","v":0.46228000000000002},null,{"$f":"ROUND(G11*(1+'Input Data'!$C$85)*(1+'Input Data'!$C$87),5)","v":0.47383999999999998},null,{"$f":"ROUND(I11*(1+'Input Data'!$C$85)*(1+'Input Data'!$C$87),5)","v":0.48569000000000001}]