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

{"sheet":"Energex >>>","index":0,"n_rows":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)","#",32990.731841774854,31787.094820509737,29643.238299953809,27160.898129508507,24386.594200174568]
["Minor Conventional (SV)","#",26438.725820891897,25583.569065446765,23990.561688567301,22097.163128138174,19944.626903013945]
["Major Conventional (non SV)","#",2894.6132035224064,2789.0058580802947,2600.903471609412,2383.1024641183794,2139.6844998565089]
["Minor Conventional (non SV)","#",84362.603954385006,81633.907754452142,76550.824275221064,70509.23082009831,63640.762109169482]
["Major LED","#",703.5833485366453,2042.8277152438754,4444.7866222706834,7264.9278002070223,10452.649693802832]
["Minor LED","#",2024.6542263077906,5878.5071816857817,12874.598037796331,21169.590053348202,30600.594989401263]
["Total","#",{"$f":"SUM(C6:C11)","v":149414.91239541859},{"$f":"SUM(D6:D11)","v":149714.91239541862},{"$f":"SUM(E6:E11)","v":150104.91239541859},{"$f":"SUM(F6:F11)","v":150584.91239541859},{"$f":"SUM(G6:G11)","v":151164.91239541859}]
[]
["NPL2 (Gifted & Energex Operated)"]
["Major Conventional (SV)","#",54799.284812482205,53054.214860086162,48879.640319760008,43835.651821202751,37963.101752075978]
["Minor Conventional (SV)","#",27466.546925985553,26727.112222872202,24793.030092884073,22415.119506887026,19612.275752592795]
["Major Conventional (non SV)","#",760.25716607459719,736.0469607562178,678.13105509329193,608.15334617340227,526.68059906615281]
["Minor Conventional (non SV)","#",96006.2362748835,93421.625147454659,86661.257837831276,78349.537905399775,68552.511710535357]
["Major LED","#",1696.5296276092924,4925.809785323715,10628.300231312793,17232.266438789946,24686.289255023963]
["Minor LED","#",3640.2327975462713,10569.278628088447,22898.728067699954,37253.358586128503,53548.228535287155]
["Total","#",{"$f":"SUM(C15:C20)","v":184369.08760458147},{"$f":"SUM(D15:D20)","v":189434.08760458138},{"$f":"SUM(E15:E20)","v":194539.08760458138},{"$f":"SUM(F15:F20)","v":199694.08760458144},{"$f":"SUM(G15:G20)","v":204889.08760458138}]
["Total Opening Lights","#",{"$f":"SUM(C12,C21)","v":333784.00000000006},{"$f":"SUM(D12,D21)","v":339149},{"$f":"SUM(E12,E21)","v":344644},{"$f":"SUM(F12,F21)","v":350279},{"$f":"SUM(G12,G21)","v":356054}]
[]
["Public Lights Additions by Type"]
[]
["NPL1 (Energex 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","#",2042.8277152438754,2401.9589070268084,2820.1411779363393,3187.721893595809,3618.2543032211133]
["Minor LED","#",5878.5071816857817,6996.0908561105498,8294.9920155518703,9431.0049360530611,10926.222274605798]
["Total","#",{"$f":"SUM(C27:C32)","v":7921.3348969296567},{"$f":"SUM(D27:D32)","v":9398.0497631373582},{"$f":"SUM(E27:E32)","v":11115.133193488209},{"$f":"SUM(F27:F32)","v":12618.726829648869},{"$f":"SUM(G27:G32)","v":14544.47657782691}]
[]
["NPL2 (Gifted & Energex 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","#",4925.809785323715,5702.4904459890777,6603.9662074771531,7454.0228162340172,8433.7881198837531]
["Minor LED","#",10569.278628088447,12329.449439611508,14354.630518428547,16294.869949158649,18699.702008059809]
["Total","#",{"$f":"SUM(C36:C41)","v":15495.088413412162},{"$f":"SUM(D36:D41)","v":18031.939885600586},{"$f":"SUM(E36:E41)","v":20958.5967259057},{"$f":"SUM(F36:F41)","v":23748.892765392666},{"$f":"SUM(G36:G41)","v":27133.490127943562}]
["Total Additions","#",{"$f":"SUM(C33,C42)","v":23416.423310341819},{"$f":"SUM(D33,D42)","v":27429.989648737945},{"$f":"SUM(E33,E42)","v":32073.729919393911},{"$f":"SUM(F33,F42)","v":36367.619595041535},{"$f":"SUM(G33,G42)","v":41677.966705770472}]
[]
["Public Lights Disposals by Type"]
[]
["NPL1 (Energex Owned & Operated)"]
["Major Conventional (SV)","#",1850.4673513235541,2143.8565205559257,2482.3401704453067,2774.3039293339384,3124.1415208969051]
["Minor Conventional (SV)","#",1338.2671845349967,1593.0073768794639,1893.3985604291274,2152.5362251242286,2499.7711572485591]
["Major Conventional (non SV)","#",162.36036392032128,188.10238647088269,217.80100749103244,243.41796426187074,274.11278232420824]
["Minor Conventional (non SV)","#",4270.2399971507848,5083.0834792310861,6041.5934551227438,6868.4687109288325,7976.4511173572391]
["Major LED","#",0,0,0,0,0]
["Minor LED","#",0,0,0,0,0]
["Total","#",{"$f":"SUM(C48:C53)","v":7621.3348969296567},{"$f":"SUM(D48:D53)","v":9008.0497631373582},{"$f":"SUM(E48:E53)","v":10635.133193488211},{"$f":"SUM(F48:F53)","v":12038.726829648869},{"$f":"SUM(G48:G53)","v":13874.476577826912}]
[]
["NPL2 (Gifted & Energex Operated)"]
["Major Conventional (SV)","#",3418.3848672680415,4174.5745403261517,5043.9884985572635,5872.550069126768,6819.1822830521305]
["Minor Conventional (SV)","#",1549.2052643929003,1934.0821299881206,2377.9105859970473,2802.8437542942288,3331.1256516985177]
["Major Conventional (non SV)","#",47.424918055673636,57.915905662925852,69.977708919889622,81.472747107249418,94.605836831622753]
["Minor Conventional (non SV)","#",5415.0733636955465,6760.367309623387,8311.7199324314988,9797.0261948644184,11643.576356361287]
["Major LED","#",0,0,0,0,0]
["Minor LED","#",0,0,0,0,0]
["Total","#",{"$f":"SUM(C57:C62)","v":10430.088413412162},{"$f":"SUM(D57:D62)","v":12926.939885600586},{"$f":"SUM(E57:E62)","v":15803.5967259057},{"$f":"SUM(F57:F62)","v":18553.892765392666},{"$f":"SUM(G57:G62)","v":21888.490127943558}]
["Total Disposals","#",{"$f":"SUM(C54,C63)","v":18051.423310341819},{"$f":"SUM(D54,D63)","v":21934.989648737945},{"$f":"SUM(E54,E63)","v":26438.729919393911},{"$f":"SUM(F54,F63)","v":30592.619595041535},{"$f":"SUM(G54,G63)","v":35762.966705770472}]
[]
["Public Lights Contributed Assets"]
[]
["Contributed Assets (Conventional)"]
["Gifted","$M Nominal",1.5042098341992407,1.5448156388527219,1.4831619616261278,1.521836068114391,1.3944231460429859]
["Cash Contribution","$M Nominal",0,0,0,0,0]
["Total Contributed","$M Nominal",{"$f":"SUM(C69:C70)","v":1.5042098341992407},{"$f":"SUM(D69:D70)","v":1.5448156388527219},{"$f":"SUM(E69:E70)","v":1.4831619616261278},{"$f":"SUM(F69:F70)","v":1.521836068114391},{"$f":"SUM(G69:G70)","v":1.3944231460429859}]
[]
["Contributed Assets (LED)"]
["Gifted","$M Nominal",25.796431093468993,27.044517952573436,28.508170597355598,29.866799592954738,31.51326438017588]
["Cash Contribution","$M Nominal",0,0,0,0,0]
["Total Contributed","$M Nominal",{"$f":"SUM(C74:C75)","v":25.796431093468993},{"$f":"SUM(D74:D75)","v":27.044517952573436},{"$f":"SUM(E74:E75)","v":28.508170597355598},{"$f":"SUM(F74:F75)","v":29.866799592954738},{"$f":"SUM(G74:G75)","v":31.51326438017588}]
[]
["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","%",{"$f":"'[13]Energex Revenue Requirement'!$F$2","v":5.4920000000000004E-2}]
["X factor","%",0]
["Z factor Conventional","%",0.3864677545318968]
["Z factor LED","%",0.5453006973777772]
[]
["% 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",16.889798294330912,16.643774968294352,15.684220157220629,14.391431386866838,12.705212486011206]
["O&M LED","$M Nominal",0.74388687151568,1.3204137055823768,2.2470105020613582,3.4886033500676952,4.9662974862915279]
["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":"2.41091367694536*(C125+C126)/C129","v":2.2692309049113333},{"$f":"2.41580202593078*(D125+D126)/D129","v":2.1534356221930486},{"$f":"2.50342619552143*(E125+E126)/E129","v":2.0215387058737835},{"$f":"2.58031958884931*(F125+F126)/F129","v":1.8416297368957355},{"$f":"2.67560855953958*(G125+G126)/G129","v":1.6312845739470732},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":2.2692309049113333},{"$f":"D10*'Input Data'!D69/'Input Data'!D$71","v":2.1534356221930486},{"$f":"E10*'Input Data'!E69/'Input Data'!E$71","v":2.0215387058737835},{"$f":"F10*'Input Data'!F69/'Input Data'!F$71","v":1.8416297368957355},{"$f":"G10*'Input Data'!G69/'Input Data'!G$71","v":1.6312845739470729}]
["Tax liability attributable to Contributed Assets","$M Nominal",{"$f":"C10*'Input Data'!C70/'Input Data'!C$71","v":0},{"$f":"D10*'Input Data'!D70/'Input Data'!D$71","v":0},{"$f":"E10*'Input Data'!E70/'Input Data'!E$71","v":0},{"$f":"F10*'Input Data'!F70/'Input Data'!F$71","v":0},{"$f":"G10*'Input Data'!G70/'Input Data'!G$71","v":0}]
["Benchmark Tax liability LED","$M Nominal",{"$f":"2.41091367694536*(C127+C128)/C129","v":0.14168277203402702},{"$f":"2.41580202593078*(D127+D128)/D129","v":0.26236640373773124},{"$f":"2.50342619552143*(E127+E128)/E129","v":0.48188748964764627},{"$f":"2.58031958884931*(F127+F128)/F129","v":0.73868985195357439},{"$f":"2.67560855953958*(G127+G128)/G129","v":1.0443239855925066},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":0.14168277203402702},{"$f":"D$15*'Input Data'!D74/'Input Data'!D$76","v":0.26236640373773124},{"$f":"E$15*'Input Data'!E74/'Input Data'!E$76","v":0.48188748964764627},{"$f":"F$15*'Input Data'!F74/'Input Data'!F$76","v":0.73868985195357439},{"$f":"G$15*'Input Data'!G74/'Input Data'!G$76","v":1.0443239855925066}]
["Tax liability attributable to Contributed Assets","$M Nominal",{"$f":"C$15*'Input Data'!C75/'Input Data'!C$76","v":0},{"$f":"D$15*'Input Data'!D75/'Input Data'!D$76","v":0},{"$f":"E$15*'Input Data'!E75/'Input Data'!E$76","v":0},{"$f":"F$15*'Input Data'!F75/'Input Data'!F$76","v":0},{"$f":"G$15*'Input Data'!G75/'Input Data'!G$76","v":0}]
["Total Opex Charge Conventional","$M Nominal",{"$f":"SUM(C6,C8)+C11+C6/(C6+(C24+C25)*C23)*(C13+C14)","v":17.99399815309906},{"$f":"SUM(D6,D8)+D11+D6/(D6+(D24+D25)*D23)*(D13+D14)","v":17.681962906684539},16.633000961427285,15.225701296651833,13.422701423532784]
["Total Opex Charge LED","$M Nominal",{"$f":"SUM(C7,C9)+C16+C7/(C7+C28+C29)*(C18+C19)","v":0.80621450655064908},{"$f":"SUM(D7,D9)+D16+D7/(D7+D28+D29)*(D18+D19)","v":1.4128750975478843},{"$f":"SUM(E7,E9)+E16+E7/(E7+E28+E29)*(E18+E19)","v":2.4179514979688741},{"$f":"SUM(F7,F9)+F16+F7/(F7+F28+F29)*(F18+F19)","v":3.7586012922542285},{"$f":"SUM(G7,G9)+G16+G7/(G7+G28+G29)*(G18+G19)","v":5.3602667568773414}]
[]
["Capex Charge Conventional","NPL4 Switch",1,1,1,1,1]
["Return on capital","$M Nominal",8.0650951487275186,7.616057148858161,7.0762839365610928,6.4553072561202001,5.7460412099239457]
["Return of capital","$M Nominal",9.7551746328169564,10.263105955182926,10.657391777097768,10.921982352091197,10.435347968953257]
["Total Capex Charge Conventional","$M Nominal",{"$f":"(SUM(C24:C25)+C12+(C24+C25)/(C6+C24+C25)*(C13+C14))*C23","v":18.985300827687659},{"$f":"(SUM(D24:D25)+D12+(D24+D25)/(D6+D24+D25)*(D13+D14))*D23","v":18.994410787843947},18.806433615325989,18.384649435322139,17.095184815302698]
["Capex Charge LED"]
["Return on capital","$M Nominal",0.42864376648807712,1.2417121130683384,2.015600196047211,2.8561366346782551,3.7565225667106317]
["Return of capital","$M Nominal",0.51846812966854428,1.1846509496343129,2.0717752945650338,3.1997619892945783,4.441718330435835]
["Total Capex Charge LED","$M Nominal",{"$f":"SUM(C28:C29)+C17+(C28+C29)/(C7+C28+C29)*(C18+C19)","v":1.0264670331556793},{"$f":"SUM(D28:D29)+D17+(D28+D29)/(D7+D28+D29)*(D18+D19)","v":2.596268074474875},{"$f":"SUM(E28:E29)+E17+(E28+E29)/(E7+E28+E29)*(E18+E19)","v":4.3983219843523749},{"$f":"SUM(F28:F29)+F17+(F28+F29)/(F7+F28+F29)*(F18+F19)","v":6.5245905337398744},{"$f":"SUM(G28:G29)+G17+(G28+G29)/(G7+G28+G29)*(G18+G19)","v":8.8485956121531579}]
[]
["ARR for Conventional","$M Nominal",{"$f":"SUM(C20,C26)","v":36.979298980786723},{"$f":"SUM(D20,D26)","v":36.676373694528486},{"$f":"SUM(E20,E26)","v":35.439434576753271},{"$f":"SUM(F20,F26)","v":33.610350731973973},{"$f":"SUM(G20,G26)","v":30.51788623883548}]
["ARR for LED","$M Nominal",{"$f":"SUM(C21,C30)","v":1.8326815397063285},{"$f":"SUM(D21,D30)","v":4.0091431720227595},{"$f":"SUM(E21,E30)","v":6.8162734823212485},{"$f":"SUM(F21,F30)","v":10.283191825994102},{"$f":"SUM(G21,G30)","v":14.208862369030498}]
["ARR for Total","$M Nominal",{"$f":"C32+C33","v":38.811980520493051},{"$f":"D32+D33","v":40.685516866551247},{"$f":"E32+E33","v":42.255708059074522},{"$f":"F32+F33","v":43.893542557968075},{"$f":"G32+G33","v":44.726748607865979}]
[]
["Opex and Capex Charge Components"]
["Opex Charge for Conventional Lights","$M Nominal",{"$f":"C20","v":17.99399815309906},17.681962906684539,16.633000961427285,15.225701296651833,13.422701423532784]
["Opex Charge for LED","$M Nominal",0.80621450655064908,1.4128750975478843,2.4179514979688741,3.7586012922542285,5.3602667568773414]
["Capex Charge for Conventional Lights","$M Nominal",{"$f":"C26","v":18.985300827687659},{"$f":"D26","v":18.994410787843947},{"$f":"E26","v":18.806433615325989},{"$f":"F26","v":18.384649435322139},{"$f":"G26","v":17.095184815302698}]
["Capex Charge for LED","$M Nominal",{"$f":"C30","v":1.0264670331556793},{"$f":"D30","v":2.596268074474875},{"$f":"E30","v":4.3983219843523749},{"$f":"F30","v":6.5245905337398744},{"$f":"G30","v":8.8485956121531579}]
[]
["Public Lights Population"]
[]
["Opening Population Public Lights"]
["NPL1 (Energex Owned & Operated)"]
["Major Conventional","#",{"$f":"'Input Data'!C6+'Input Data'!C8","v":35885.345045297261},{"$f":"'Input Data'!D6+'Input Data'!D8","v":34576.100678590032},{"$f":"'Input Data'!E6+'Input Data'!E8","v":32244.14177156322},{"$f":"'Input Data'!F6+'Input Data'!F8","v":29544.000593626886},{"$f":"'Input Data'!G6+'Input Data'!G8","v":26526.278700031078}]
["Minor Conventional","#",{"$f":"'Input Data'!C7+'Input Data'!C9","v":110801.3297752769},{"$f":"'Input Data'!D7+'Input Data'!D9","v":107217.4768198989},{"$f":"'Input Data'!E7+'Input Data'!E9","v":100541.38596378837},{"$f":"'Input Data'!F7+'Input Data'!F9","v":92606.39394823648},{"$f":"'Input Data'!G7+'Input Data'!G9","v":83585.389012183427}]
["Major LED","#",{"$f":"'Input Data'!C10","v":703.5833485366453},{"$f":"'Input Data'!D10","v":2042.8277152438754},{"$f":"'Input Data'!E10","v":4444.7866222706834},{"$f":"'Input Data'!F10","v":7264.9278002070223},{"$f":"'Input Data'!G10","v":10452.649693802832}]
["Minor LED","#",{"$f":"'Input Data'!C11","v":2024.6542263077906},{"$f":"'Input Data'!D11","v":5878.5071816857817},{"$f":"'Input Data'!E11","v":12874.598037796331},{"$f":"'Input Data'!F11","v":21169.590053348202},{"$f":"'Input Data'!G11","v":30600.594989401263}]
["Total","#",{"$f":"SUM(C46:C49)","v":149414.91239541859},{"$f":"SUM(D46:D49)","v":149714.91239541862},{"$f":"SUM(E46:E49)","v":150104.91239541859},{"$f":"SUM(F46:F49)","v":150584.91239541859},{"$f":"SUM(G46:G49)","v":151164.91239541859}]
[]
["NPL2 (Gifted & Energex Operated)"]
["Major Conventional","#",{"$f":"'Input Data'!C15+'Input Data'!C17","v":55559.541978556801},{"$f":"'Input Data'!D15+'Input Data'!D17","v":53790.261820842381},{"$f":"'Input Data'!E15+'Input Data'!E17","v":49557.771374853299},{"$f":"'Input Data'!F15+'Input Data'!F17","v":44443.805167376151},{"$f":"'Input Data'!G15+'Input Data'!G17","v":38489.78235114213}]
["Minor Conventional","#",{"$f":"'Input Data'!C16+'Input Data'!C18","v":123472.78320086905},{"$f":"'Input Data'!D16+'Input Data'!D18","v":120148.73737032685},{"$f":"'Input Data'!E16+'Input Data'!E18","v":111454.28793071535},{"$f":"'Input Data'!F16+'Input Data'!F18","v":100764.6574122868},{"$f":"'Input Data'!G16+'Input Data'!G18","v":88164.787463128159}]
["Major LED","#",{"$f":"'Input Data'!C19","v":1696.5296276092924},{"$f":"'Input Data'!D19","v":4925.809785323715},{"$f":"'Input Data'!E19","v":10628.300231312793},{"$f":"'Input Data'!F19","v":17232.266438789946},{"$f":"'Input Data'!G19","v":24686.289255023963}]
["Minor LED","#",{"$f":"'Input Data'!C20","v":3640.2327975462713},{"$f":"'Input Data'!D20","v":10569.278628088447},{"$f":"'Input Data'!E20","v":22898.728067699954},{"$f":"'Input Data'!F20","v":37253.358586128503},{"$f":"'Input Data'!G20","v":53548.228535287155}]
["Total","#",{"$f":"SUM(C53:C56)","v":184369.08760458144},{"$f":"SUM(D53:D56)","v":189434.08760458138},{"$f":"SUM(E53:E56)","v":194539.08760458138},{"$f":"SUM(F53:F56)","v":199694.08760458144},{"$f":"SUM(G53:G56)","v":204889.08760458138}]
["Total Opening Lights","#",{"$f":"SUM(C50,C57)","v":333784},{"$f":"SUM(D50,D57)","v":339149},{"$f":"SUM(E50,E57)","v":344644},{"$f":"SUM(F50,F57)","v":350279},{"$f":"SUM(G50,G57)","v":356054}]
[]
["Plus Additions"]
["NPL1 (Energex 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":2042.8277152438754},{"$f":"'Input Data'!D31","v":2401.9589070268084},{"$f":"'Input Data'!E31","v":2820.1411779363393},{"$f":"'Input Data'!F31","v":3187.721893595809},{"$f":"'Input Data'!G31","v":3618.2543032211133}]
["Minor LED","#",{"$f":"'Input Data'!C32","v":5878.5071816857817},{"$f":"'Input Data'!D32","v":6996.0908561105498},{"$f":"'Input Data'!E32","v":8294.9920155518703},{"$f":"'Input Data'!F32","v":9431.0049360530611},{"$f":"'Input Data'!G32","v":10926.222274605798}]
["Total","#",{"$f":"SUM(C62:C65)","v":7921.3348969296567},{"$f":"SUM(D62:D65)","v":9398.0497631373582},{"$f":"SUM(E62:E65)","v":11115.133193488209},{"$f":"SUM(F62:F65)","v":12618.726829648869},{"$f":"SUM(G62:G65)","v":14544.47657782691}]
[]
["NPL2 (Gifted & Energex 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":4925.809785323715},{"$f":"'Input Data'!D40","v":5702.4904459890777},{"$f":"'Input Data'!E40","v":6603.9662074771531},{"$f":"'Input Data'!F40","v":7454.0228162340172},{"$f":"'Input Data'!G40","v":8433.7881198837531}]
["Minor LED","#",{"$f":"'Input Data'!C41","v":10569.278628088447},{"$f":"'Input Data'!D41","v":12329.449439611508},{"$f":"'Input Data'!E41","v":14354.630518428547},{"$f":"'Input Data'!F41","v":16294.869949158649},{"$f":"'Input Data'!G41","v":18699.702008059809}]
["Total","#",{"$f":"SUM(C69:C72)","v":15495.088413412162},{"$f":"SUM(D69:D72)","v":18031.939885600586},{"$f":"SUM(E69:E72)","v":20958.5967259057},{"$f":"SUM(F69:F72)","v":23748.892765392666},{"$f":"SUM(G69:G72)","v":27133.490127943562}]
["Total Additions","#",{"$f":"SUM(C66,C73)","v":23416.423310341819},{"$f":"SUM(D66,D73)","v":27429.989648737945},{"$f":"SUM(E66,E73)","v":32073.729919393911},{"$f":"SUM(F66,F73)","v":36367.619595041535},{"$f":"SUM(G66,G73)","v":41677.966705770472}]
[]
["Less Disposals"]
["NPL1 (Energex Owned & Operated)"]
["Major Conventional","#",{"$f":"'Input Data'!C48+'Input Data'!C50","v":2012.8277152438754},{"$f":"'Input Data'!D48+'Input Data'!D50","v":2331.9589070268084},{"$f":"'Input Data'!E48+'Input Data'!E50","v":2700.1411779363393},{"$f":"'Input Data'!F48+'Input Data'!F50","v":3017.721893595809},{"$f":"'Input Data'!G48+'Input Data'!G50","v":3398.2543032211133}]
["Minor Conventional","#",{"$f":"'Input Data'!C49+'Input Data'!C51","v":5608.5071816857817},{"$f":"'Input Data'!D49+'Input Data'!D51","v":6676.0908561105498},{"$f":"'Input Data'!E49+'Input Data'!E51","v":7934.9920155518712},{"$f":"'Input Data'!F49+'Input Data'!F51","v":9021.0049360530611},{"$f":"'Input Data'!G49+'Input Data'!G51","v":10476.222274605798}]
["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":7621.3348969296567},{"$f":"SUM(D78:D81)","v":9008.0497631373582},{"$f":"SUM(E78:E81)","v":10635.133193488211},{"$f":"SUM(F78:F81)","v":12038.726829648869},{"$f":"SUM(G78:G81)","v":13874.47657782691}]
[]
["NPL2 (Gifted & Energex Operated)"]
["Major Conventional","#",{"$f":"'Input Data'!C57+'Input Data'!C59","v":3465.809785323715},{"$f":"'Input Data'!D57+'Input Data'!D59","v":4232.4904459890777},{"$f":"'Input Data'!E57+'Input Data'!E59","v":5113.9662074771531},{"$f":"'Input Data'!F57+'Input Data'!F59","v":5954.0228162340172},{"$f":"'Input Data'!G57+'Input Data'!G59","v":6913.7881198837531}]
["Minor Conventional","#",{"$f":"'Input Data'!C58+'Input Data'!C60","v":6964.2786280884466},{"$f":"'Input Data'!D58+'Input Data'!D60","v":8694.4494396115078},{"$f":"'Input Data'!E58+'Input Data'!E60","v":10689.630518428547},{"$f":"'Input Data'!F58+'Input Data'!F60","v":12599.869949158647},{"$f":"'Input Data'!G58+'Input Data'!G60","v":14974.702008059805}]
["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":10430.088413412162},{"$f":"SUM(D85:D88)","v":12926.939885600586},{"$f":"SUM(E85:E88)","v":15803.5967259057},{"$f":"SUM(F85:F88)","v":18553.892765392666},{"$f":"SUM(G85:G88)","v":21888.490127943558}]
["Total Disposals","#",{"$f":"SUM(C82,C89)","v":18051.423310341819},{"$f":"SUM(D82,D89)","v":21934.989648737945},{"$f":"SUM(E82,E89)","v":26438.729919393911},{"$f":"SUM(F82,F89)","v":30592.619595041535},{"$f":"SUM(G82,G89)","v":35762.966705770465}]
[]
["Closing Population Public Lights"]
["NPL1 (Energex Owned & Operated)"]
["Major Conventional","#",{"$f":"(C46+C62-C78)","v":33872.517330053386},32244.141771563223,29544.000593626879,26526.278700031078,23128.024396809964]
["Minor Conventional","#",105192.82259359112,100541.38596378836,92606.393948236495,83585.389012183412,73109.166737577631]
["Major LED","#",2746.4110637805206,4444.7866222706834,7264.9278002070223,10452.649693802832,14070.903997023946]
["Minor LED","#",7903.1614079935725,12874.598037796331,21169.590053348202,30600.594989401263,41526.817264007062]
["Total","#",{"$f":"SUM(C94:C97)","v":149714.91239541859},{"$f":"SUM(D94:D97)","v":150104.91239541859},{"$f":"SUM(E94:E97)","v":150584.91239541859},{"$f":"SUM(F94:F97)","v":151164.91239541859},{"$f":"SUM(G94:G97)","v":151834.91239541859}]
[]
["NPL2 (Gifted & Energex Operated)"]
["Major Conventional","#",{"$f":"(C53+C69-C85)","v":52093.732193233089},49557.771374853306,44443.805167376144,38489.78235114213,31575.994231258377]
["Minor Conventional","#",116508.5045727806,111454.28793071535,100764.6574122868,88164.787463128159,73190.085455068358]
["Major LED","#",6622.3394129330072,10628.300231312793,17232.266438789946,24686.289255023963,33120.07737490772]
["Minor LED","#",14209.511425634719,22898.728067699954,37253.358586128503,53548.228535287155,72247.930543346971]
["Total","#",{"$f":"SUM(C101:C104)","v":189434.08760458144},{"$f":"SUM(D101:D104)","v":194539.08760458141},{"$f":"SUM(E101:E104)","v":199694.08760458141},{"$f":"SUM(F101:F104)","v":204889.08760458138},{"$f":"SUM(G101:G104)","v":210134.08760458144}]
["Grand Total","#",{"$f":"SUM(C98,C105)","v":339149},{"$f":"SUM(D98,D105)","v":344644},{"$f":"SUM(E98,E105)","v":350279},{"$f":"SUM(F98,F105)","v":356054},{"$f":"SUM(G98,G105)","v":361969}]
[]
["Average No of Lights by Tariff"]
["NPL1 (Energex Owned & Operated)"]
["Major Conventional","#",{"$f":"(C46+C94)/2","v":34878.93118767532},33410.121225076626,30894.071182595049,28035.139646828982,24827.151548420523]
["Minor Conventional","#",107997.076184434,103879.43139184362,96573.889956012426,88095.891480209946,78347.277874880529]
["Major LED","#",1724.9972061585829,3243.8071687572792,5854.8572112388529,8858.7887470049282,12261.776845413389]
["Minor LED","#",4963.9078171506817,9376.5526097410566,17022.094045572267,25885.092521374732,36063.706126704164]
["Total","#",{"$f":"SUM(C110:C113)","v":149564.91239541859},{"$f":"SUM(D110:D113)","v":149909.91239541859},{"$f":"SUM(E110:E113)","v":150344.91239541859},{"$f":"SUM(F110:F113)","v":150874.91239541859},{"$f":"SUM(G110:G113)","v":151499.91239541859}]
[]
["NPL2 (Gifted & Energex Operated)"]
["Major Conventional","#",{"$f":"(C53+C101)/2","v":53826.637085894945},51674.016597847847,47000.788271114725,41466.793759259141,35032.888291200252]
["Minor Conventional","#",119990.64388682482,115801.51265052109,106109.47267150108,94464.722437707474,80677.436459098259]
["Major LED","#",4159.4345202711502,7777.0550083182534,13930.283335051368,20959.277846906953,28903.183314965841]
["Minor LED","#",8924.8721115904955,16734.003347894199,30076.04332691423,45400.793560707825,62898.079539317063]
["Total","#",{"$f":"SUM(C117:C120)","v":186901.58760458141},{"$f":"SUM(D117:D120)","v":191986.58760458138},{"$f":"SUM(E117:E120)","v":197116.58760458141},{"$f":"SUM(F117:F120)","v":202291.58760458138},{"$f":"SUM(G117:G120)","v":207511.58760458141}]
["Grand total","#",{"$f":"SUM(C114,C121)","v":336466.5},{"$f":"SUM(D114,D121)","v":341896.5},{"$f":"SUM(E114,E121)","v":347461.5},{"$f":"SUM(F114,F121)","v":353166.5},{"$f":"SUM(G114,G121)","v":359011.5}]
[]
["Average No of Lights by Type"]
["Major Conventional","#",{"$f":"SUM(C110+C117)","v":88705.568273570272},85084.137822924473,77894.859453709767,69501.933406088123,59860.039839620775]
["Minor Conventional","#",227987.72007125884,219680.94404236472,202683.3626275135,182560.61391791742,159024.71433397877]
["Major LED","#",5884.4317264297333,11020.862177075533,19785.140546290222,29818.066593911881,41164.960160379233]
["Minor LED","#",13888.779928741176,26110.555957635253,47098.137372486497,71285.88608208255,98961.785666021227]
["Total","#",{"$f":"SUM(C125:C128)","v":336466.5},{"$f":"SUM(D125:D128)","v":341896.5},{"$f":"SUM(E125:E128)","v":347461.5},{"$f":"SUM(F125:F128)","v":353166.5},{"$f":"SUM(G125:G128)","v":359011.5}]
[]
["Weighted Average No of Lights by Type"]
["Major Conventional","#",{"$f":"ROUND(C125*'Input Data'!$C$82,0)","v":159670},{"$f":"ROUND(D125*'Input Data'!$C$82,0)","v":153151},{"$f":"ROUND(E125*'Input Data'!$C$82,0)","v":140211},{"$f":"ROUND(F125*'Input Data'!$C$82,0)","v":125103},{"$f":"ROUND(G125*'Input Data'!$C$82,0)","v":107748}]
["Minor Conventional","#",{"$f":"C126","v":227987.72007125884},{"$f":"D126","v":219680.94404236472},{"$f":"E126","v":202683.3626275135},{"$f":"F126","v":182560.61391791742},{"$f":"G126","v":159024.71433397877}]
["Major LED","#",{"$f":"ROUND(C127*'Input Data'!$C$82,0)","v":10592},{"$f":"ROUND(D127*'Input Data'!$C$82,0)","v":19838},{"$f":"ROUND(E127*'Input Data'!$C$82,0)","v":35613},{"$f":"ROUND(F127*'Input Data'!$C$82,0)","v":53673},{"$f":"ROUND(G127*'Input Data'!$C$82,0)","v":74097}]
["Minor LED","#",{"$f":"C128","v":13888.779928741176},{"$f":"D128","v":26110.555957635253},{"$f":"E128","v":47098.137372486497},{"$f":"F128","v":71285.88608208255},{"$f":"G128","v":98961.785666021227}]
["Total","#",{"$f":"SUM(C132:C135)","v":412138.5},{"$f":"SUM(D132:D135)","v":418780.5},{"$f":"SUM(E132:E135)","v":425605.5},{"$f":"SUM(F132:F135)","v":432622.5},{"$f":"SUM(G132:G135)","v":439831.5}]
[]
["Price Components"]
[]
["Opex Charge"]
["NPL1 (Energex Owned & Operated)"]
["Major Conventional","$/day/light Nominal",{"$f":"C$37*1000000/(C$125+C$126/'Input Data'!$C$81)","v":74.757764415296521},{"$f":"D$37*1000000/(D$125+D$126/'Input Data'!$C$81)","v":76.367400730760437},{"$f":"E$37*1000000/(E$125+E$126/'Input Data'!$C$81)","v":78.082937319620115},{"$f":"F$37*1000000/(F$125+F$126/'Input Data'!$C$81)","v":79.628576855774753},{"$f":"G$37*1000000/(G$125+G$126/'Input Data'!$C$81)","v":80.919841712214634}]
["Minor Conventional","$/day/light Nominal",{"$f":"C142/'Input Data'!$C$81","v":49.838509610197683},{"$f":"D142/'Input Data'!$C$81","v":50.911600487173622},{"$f":"E142/'Input Data'!$C$81","v":52.055291546413407},{"$f":"F142/'Input Data'!$C$81","v":53.085717903849833},{"$f":"G142/'Input Data'!$C$81","v":53.946561141476423}]
["Major LED","$/day/light Nominal",{"$f":"C$38*1000000/(C$127+C$128/'Input Data'!$C$81)","v":53.237904452696448},{"$f":"D$38*1000000/(D$127+D$128/'Input Data'!$C$81)","v":49.700298765804142},{"$f":"E$38*1000000/(E$127+E$128/'Input Data'!$C$81)","v":47.240471220673896},{"$f":"F$38*1000000/(F$127+F$128/'Input Data'!$C$81)","v":48.597162559852379},{"$f":"G$38*1000000/(G$127+G$128/'Input Data'!$C$81)","v":50.030731527444352}]
["Minor LED","$/day/light Nominal",{"$f":"C144/'Input Data'!$C$81","v":35.491936301797629},{"$f":"D144/'Input Data'!$C$81","v":33.133532510536092},{"$f":"E144/'Input Data'!$C$81","v":31.493647480449265},{"$f":"F144/'Input Data'!$C$81","v":32.398108373234919},{"$f":"G144/'Input Data'!$C$81","v":33.353821018296237}]
[]
["NPL2 (Gifted & Energex Operated)"]
["Major Conventional","$/day/light Nominal",{"$f":"C142","v":74.757764415296521},76.367400730760437,78.082937319620115,79.628576855774753,80.919841712214634]
["Minor Conventional","$/day/light Nominal",49.838509610197683,50.911600487173622,52.055291546413407,53.085717903849833,53.946561141476423]
["Major LED","$/day/light Nominal",53.237904452696448,49.700298765804142,47.240471220673896,48.597162559852379,50.030731527444352]
["Minor LED","$/day/light Nominal",35.491936301797629,33.133532510536092,31.493647480449265,32.398108373234919,33.353821018296237]
[]
["Capex Charge"]
["NPL1 (Energex 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":79.338509030464948},{"$f":"D$39*1000000/(D$125+D$126/'Input Data'!$C$82)*(1-'Input Data'!$C$79)","v":82.532918615353978},{"$f":"E$39*1000000/(E$125+E$126/'Input Data'!$C$82)*(1-'Input Data'!$C$79)","v":88.850818955280459},{"$f":"F$39*1000000/(F$125+F$126/'Input Data'!$C$82)*(1-'Input Data'!$C$79)","v":96.804055661075836},{"$f":"G$39*1000000/(G$125+G$126/'Input Data'!$C$82)*(1-'Input Data'!$C$79)","v":103.81193603491508}]
["Minor Conventional","$/day/light Nominal",{"$f":"ROUND(C155/'Input Data'!$C$82,2)","v":44.08},{"$f":"ROUND(D155/'Input Data'!$C$82,2)","v":45.85},{"$f":"ROUND(E155/'Input Data'!$C$82,2)","v":49.36},{"$f":"ROUND(F155/'Input Data'!$C$82,2)","v":53.78},{"$f":"ROUND(G155/'Input Data'!$C$82,2)","v":57.67}]
["Major LED","$/day/light Nominal",{"$f":"C$40*1000000/(C$127+C$128/'Input Data'!$C$82)*(1-'Input Data'!$C$79)","v":67.92586484337447},{"$f":"D$40*1000000/(D$127+D$128/'Input Data'!$C$82)*(1-'Input Data'!$C$79)","v":91.537050708723669},{"$f":"E$40*1000000/(E$127+E$128/'Input Data'!$C$82)*(1-'Input Data'!$C$79)","v":86.146316535113499},{"$f":"F$40*1000000/(F$127+F$128/'Input Data'!$C$82)*(1-'Input Data'!$C$79)","v":84.586839790456906},{"$f":"G$40*1000000/(G$127+G$128/'Input Data'!$C$82)*(1-'Input Data'!$C$79)","v":82.831569495194955}]
["Minor LED","$/day/light Nominal",{"$f":"ROUND(C157/'Input Data'!$C$82,2)","v":37.74},{"$f":"ROUND(D157/'Input Data'!$C$82,2)","v":50.85},{"$f":"ROUND(E157/'Input Data'!$C$82,2)","v":47.86},{"$f":"ROUND(F157/'Input Data'!$C$82,2)","v":46.99},{"$f":"ROUND(G157/'Input Data'!$C$82,2)","v":46.02}]
[]
["NPL2 (Gifted & Energex 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 (Energex Owned & Operated)"]
["Major Conventional","$/day/light Nominal",{"$f":"C$39*1000000/(C$125+C$126/'Input Data'!$C$82)*'Input Data'!$C$79","v":8.8153898922738829},{"$f":"D$39*1000000/(D$125+D$126/'Input Data'!$C$82)*'Input Data'!$C$79","v":9.1703242905948859},{"$f":"E$39*1000000/(E$125+E$126/'Input Data'!$C$82)*'Input Data'!$C$79","v":9.8723132172533852},{"$f":"F$39*1000000/(F$125+F$126/'Input Data'!$C$82)*'Input Data'!$C$79","v":10.756006184563981},{"$f":"G$39*1000000/(G$125+G$126/'Input Data'!$C$82)*'Input Data'!$C$79","v":11.53465955943501}]
["Minor Conventional","$/day/light Nominal",{"$f":"ROUND(C168/'Input Data'!$C$82,2)","v":4.9000000000000004},{"$f":"ROUND(D168/'Input Data'!$C$82,2)","v":5.09},{"$f":"ROUND(E168/'Input Data'!$C$82,2)","v":5.48},{"$f":"ROUND(F168/'Input Data'!$C$82,2)","v":5.98},{"$f":"ROUND(G168/'Input Data'!$C$82,2)","v":6.41}]
["Major LED","$/day/light Nominal",{"$f":"C$40*1000000/(C$127+C$128/'Input Data'!$C$82)*'Input Data'!$C$79","v":7.5473183159304966},{"$f":"D$40*1000000/(D$127+D$128/'Input Data'!$C$82)*'Input Data'!$C$79","v":10.170783412080409},{"$f":"E$40*1000000/(E$127+E$128/'Input Data'!$C$82)*'Input Data'!$C$79","v":9.5718129483459435},{"$f":"F$40*1000000/(F$127+F$128/'Input Data'!$C$82)*'Input Data'!$C$79","v":9.3985377544952122},{"$f":"G$40*1000000/(G$127+G$128/'Input Data'!$C$82)*'Input Data'!$C$79","v":9.2035077216883288}]
["Minor LED","$/day/light Nominal",{"$f":"ROUND(C170/'Input Data'!$C$82,2)","v":4.1900000000000004},{"$f":"ROUND(D170/'Input Data'!$C$82,2)","v":5.65},{"$f":"ROUND(E170/'Input Data'!$C$82,2)","v":5.32},{"$f":"ROUND(F170/'Input Data'!$C$82,2)","v":5.22},{"$f":"ROUND(G170/'Input Data'!$C$82,2)","v":5.1100000000000003}]
[]
["NPL2 (Gifted & Energex Operated)"]
["Major Conventional","$/day/light Nominal",{"$f":"C168","v":8.8153898922738829},9.1703242905948859,9.8723132172533852,10.756006184563981,11.53465955943501]
["Minor Conventional","$/day/light Nominal",4.9000000000000004,5.09,5.48,5.98,6.41]
["Major LED","$/day/light Nominal",7.5473183159304966,10.170783412080409,9.5718129483459435,9.3985377544952122,9.2035077216883288]
["Minor LED","$/day/light Nominal",4.1900000000000004,5.65,5.32,5.22,5.1100000000000003]
[]
["Pricing Days in Year","#",365.25,365.25,365.25,365.25,365.25]
[]
["Unsmoothed Prices"]
[]
["NPL1 (Energex Owned & Operated)"]
["Major Conventional","$/day/light Nominal",{"$f":"SUM(C142,C155,C168)/C$179","v":0.44602782570304},0.4601523439745635,0.48406863652882676,0.5124945618108544,0.53734821986739145]
["Minor Conventional","$/day/light Nominal",0.27055033431950082,0.27885448456447265,0.29266335810106342,0.30895473758754233,0.32313911332368628]
["Major LED","$/day/light Nominal",0.35239175253114685,0.41453287580180204,0.39139931746511525,0.39036971965723344,0.38895498629521602]
["Minor LED","$/day/light Nominal",0.21196970924516806,0.24540323753740206,0.23182381240369407,0.23164437610741936,0.23130409587486991]
[]
["NPL2 (Gifted & Energex Operated)"]
["Major Conventional","$/day/light Nominal",{"$f":"SUM(C148,C174)/C$179","v":0.22881082630409419},0.23418952777920693,0.24080835191478031,0.2474595018215982,0.25312662908049183]
["Minor Conventional","$/day/light Nominal",0.14986587162271781,0.15332402597446576,0.15752304324822286,0.16171312225557791,0.165247258429778]
["Major LED","$/day/light Nominal",0.16642087000308542,0.16391808946717196,0.15554355693092359,0.15878357375591401,0.16217450855340912]
["Minor LED","$/day/light Nominal",0.10864322053880254,0.10618352501173468,0.10079027373155171,0.10299276762008192,0.10530820265105062]
[]
["Smoothed Prices"]
[]
["NPL1 (Energex Owned & Operated)"]
["Major Conventional","$/day/light Nominal",{"$f":"ROUND(C184*(1+'Input Data'!$C$88),5)","v":0.61839999999999995},{"$f":"ROUND(C198*(1+'Input Data'!$C$85)*(1+'Input Data'!$C$87),5)","v":0.63385999999999998},{"$f":"ROUND(D198*(1+'Input Data'!$C$85)*(1+'Input Data'!$C$87),5)","v":0.64971000000000001},{"$f":"ROUND(E198*(1+'Input Data'!$C$85)*(1+'Input Data'!$C$87),5)","v":0.66595000000000004},{"$f":"ROUND(F198*(1+'Input Data'!$C$85)*(1+'Input Data'!$C$87),5)","v":0.68259999999999998}]
["Minor Conventional","$/day/light Nominal",{"$f":"ROUND(C185*(1+'Input Data'!$C$88),5)","v":0.37511},{"$f":"ROUND(C199*(1+'Input Data'!$C$85)*(1+'Input Data'!$C$87),5)","v":0.38449},{"$f":"ROUND(D199*(1+'Input Data'!$C$85)*(1+'Input Data'!$C$87),5)","v":0.39410000000000001},{"$f":"ROUND(E199*(1+'Input Data'!$C$85)*(1+'Input Data'!$C$87),5)","v":0.40394999999999998},{"$f":"ROUND(F199*(1+'Input Data'!$C$85)*(1+'Input Data'!$C$87),5)","v":0.41404999999999997}]
["Major LED","$/day/light Nominal",{"$f":"ROUND(C186*(1+'Input Data'!$C$89),5)","v":0.54454999999999998},{"$f":"ROUND(C200*(1+'Input Data'!$C$85)*(1+'Input Data'!$C$87),5)","v":0.55815999999999999},{"$f":"ROUND(D200*(1+'Input Data'!$C$85)*(1+'Input Data'!$C$87),5)","v":0.57211000000000001},{"$f":"ROUND(E200*(1+'Input Data'!$C$85)*(1+'Input Data'!$C$87),5)","v":0.58640999999999999},{"$f":"ROUND(F200*(1+'Input Data'!$C$85)*(1+'Input Data'!$C$87),5)","v":0.60106999999999999}]
["Minor LED","$/day/light Nominal",{"$f":"ROUND(C187*(1+'Input Data'!$C$89),5)","v":0.32756000000000002},{"$f":"ROUND(C201*(1+'Input Data'!$C$85)*(1+'Input Data'!$C$87),5)","v":0.33574999999999999},{"$f":"ROUND(D201*(1+'Input Data'!$C$85)*(1+'Input Data'!$C$87),5)","v":0.34414},{"$f":"ROUND(E201*(1+'Input Data'!$C$85)*(1+'Input Data'!$C$87),5)","v":0.35274},{"$f":"ROUND(F201*(1+'Input Data'!$C$85)*(1+'Input Data'!$C$87),5)","v":0.36155999999999999}]
[]
["NPL2 (Gifted & Energex Operated)"]
["Major Conventional","$/day/light Nominal",{"$f":"ROUND(C190*(1+'Input Data'!$C$88),5)","v":0.31724000000000002},{"$f":"ROUND(C204*(1+'Input Data'!$C$85)*(1+'Input Data'!$C$87),5)","v":0.32517000000000001},{"$f":"ROUND(D204*(1+'Input Data'!$C$85)*(1+'Input Data'!$C$87),5)","v":0.33329999999999999},{"$f":"ROUND(E204*(1+'Input Data'!$C$85)*(1+'Input Data'!$C$87),5)","v":0.34162999999999999},{"$f":"ROUND(F204*(1+'Input Data'!$C$85)*(1+'Input Data'!$C$87),5)","v":0.35016999999999998}]
["Minor Conventional","$/day/light Nominal",{"$f":"ROUND(C191*(1+'Input Data'!$C$88),5)","v":0.20777999999999999},{"$f":"ROUND(C205*(1+'Input Data'!$C$85)*(1+'Input Data'!$C$87),5)","v":0.21296999999999999},{"$f":"ROUND(D205*(1+'Input Data'!$C$85)*(1+'Input Data'!$C$87),5)","v":0.21829000000000001},{"$f":"ROUND(E205*(1+'Input Data'!$C$85)*(1+'Input Data'!$C$87),5)","v":0.22375},{"$f":"ROUND(F205*(1+'Input Data'!$C$85)*(1+'Input Data'!$C$87),5)","v":0.22933999999999999}]
["Major LED","$/day/light Nominal",{"$f":"ROUND(C192*(1+'Input Data'!$C$89),5)","v":0.25717000000000001},{"$f":"ROUND(C206*(1+'Input Data'!$C$85)*(1+'Input Data'!$C$87),5)","v":0.2636},{"$f":"ROUND(D206*(1+'Input Data'!$C$85)*(1+'Input Data'!$C$87),5)","v":0.27018999999999999},{"$f":"ROUND(E206*(1+'Input Data'!$C$85)*(1+'Input Data'!$C$87),5)","v":0.27694000000000002},{"$f":"ROUND(F206*(1+'Input Data'!$C$85)*(1+'Input Data'!$C$87),5)","v":0.28386}]
["Minor LED","$/day/light Nominal",{"$f":"ROUND(C193*(1+'Input Data'!$C$89),5)","v":0.16789000000000001},{"$f":"ROUND(C207*(1+'Input Data'!$C$85)*(1+'Input Data'!$C$87),5)","v":0.17208999999999999},{"$f":"ROUND(D207*(1+'Input Data'!$C$85)*(1+'Input Data'!$C$87),5)","v":0.17638999999999999},{"$f":"ROUND(E207*(1+'Input Data'!$C$85)*(1+'Input Data'!$C$87),5)","v":0.18079999999999999},{"$f":"ROUND(F207*(1+'Input Data'!$C$85)*(1+'Input Data'!$C$87),5)","v":0.18532000000000001}]
[]
["Recovered Revenue"]
[]
["Recovered revenue Conventional","$M Nominal",{"$f":"(SUMPRODUCT(C198:C199,C110:C111)+SUMPRODUCT(C204:C205,C117:C118))*C179/1000000","v":38.017971293083846},{"$f":"(SUMPRODUCT(D198:D199,D110:D111)+SUMPRODUCT(D204:D205,D117:D118))*D179/1000000","v":37.468451759321923},{"$f":"(SUMPRODUCT(E198:E199,E110:E111)+SUMPRODUCT(E204:E205,E117:E118))*E179/1000000","v":35.414624126210477},{"$f":"(SUMPRODUCT(F198:F199,F110:F111)+SUMPRODUCT(F204:F205,F117:F118))*F179/1000000","v":32.711468217909164},{"$f":"(SUMPRODUCT(G198:G199,G110:G111)+SUMPRODUCT(G204:G205,G117:G118))*G179/1000000","v":29.27724702830481}]
["NPV of recovered revenue Conventional","$M Nominal",{"$f":"NPV('Input Data'!C$86,C211:G211)","v":148.6966695427401}]
["NPV of revenue requirement Conventional","$M Nominal",{"$f":"NPV('Input Data'!C$86,C$32:G$32)","v":148.6968815107447}]
["Difference Conventional","$M Nominal",{"$f":"C212-C213","v":-2.1196800460643317E-4}]
[]
["Recovered revenue LED","$M Nominal",{"$f":"(SUMPRODUCT(C200:C201,C112:C113)+SUMPRODUCT(C206:C207,C119:C120))*C179/1000000","v":1.8749756019281947},{"$f":"(SUMPRODUCT(D200:D201,D112:D113)+SUMPRODUCT(D206:D207,D119:D120))*D179/1000000","v":3.6117845906146546},{"$f":"(SUMPRODUCT(E200:E201,E112:E113)+SUMPRODUCT(E206:E207,E119:E120))*E179/1000000","v":6.6755070899395896},{"$f":"(SUMPRODUCT(F200:F201,F112:F113)+SUMPRODUCT(F206:F207,F119:F120))*F179/1000000","v":10.350642869585988},{"$f":"(SUMPRODUCT(G200:G201,G112:G113)+SUMPRODUCT(G206:G207,G119:G120))*G179/1000000","v":14.708657499132437}]
["NPV of recovered revenue LED","$M Nominal",{"$f":"NPV('Input Data'!C$86,C216:G216)","v":30.325232195978611}]
["NPV of revenue requirement LED","$M Nominal",{"$f":"NPV('Input Data'!C$86,C$33:G$33)","v":30.325088206066912}]
["Difference LED","$M Nominal",{"$f":"C217-C218","v":1.4398991169883857E-4}]

{"sheet":"Output Tables","index":3,"n_rows":11,"n_cols":11,"rows_kept":11,"cut":false,"hidden":false,"merged":[[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],[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 (Energex Owned & Operated)"]
["Major",{"$f":"'Public Lighting Pricing'!C198","v":0.61839999999999995},{"$f":"'Public Lighting Pricing'!C200","v":0.54454999999999998},{"$f":"'Public Lighting Pricing'!D198","v":0.63385999999999998},{"$f":"'Public Lighting Pricing'!D200","v":0.55815999999999999},{"$f":"'Public Lighting Pricing'!E198","v":0.64971000000000001},{"$f":"'Public Lighting Pricing'!E200","v":0.57211000000000001},{"$f":"'Public Lighting Pricing'!F198","v":0.66595000000000004},{"$f":"'Public Lighting Pricing'!F200","v":0.58640999999999999},{"$f":"'Public Lighting Pricing'!G198","v":0.68259999999999998},{"$f":"'Public Lighting Pricing'!G200","v":0.60106999999999999}]
["Minor",{"$f":"'Public Lighting Pricing'!C199","v":0.37511},{"$f":"'Public Lighting Pricing'!C201","v":0.32756000000000002},{"$f":"'Public Lighting Pricing'!D199","v":0.38449},{"$f":"'Public Lighting Pricing'!D201","v":0.33574999999999999},{"$f":"'Public Lighting Pricing'!E199","v":0.39410000000000001},{"$f":"'Public Lighting Pricing'!E201","v":0.34414},{"$f":"'Public Lighting Pricing'!F199","v":0.40394999999999998},{"$f":"'Public Lighting Pricing'!F201","v":0.35274},{"$f":"'Public Lighting Pricing'!G199","v":0.41404999999999997},{"$f":"'Public Lighting Pricing'!G201","v":0.36155999999999999}]
["NPL2 (Gifted & Energex Operated)"]
["Major",{"$f":"'Public Lighting Pricing'!C204","v":0.31724000000000002},{"$f":"'Public Lighting Pricing'!C206","v":0.25717000000000001},{"$f":"'Public Lighting Pricing'!D204","v":0.32517000000000001},{"$f":"'Public Lighting Pricing'!D206","v":0.2636},{"$f":"'Public Lighting Pricing'!E204","v":0.33329999999999999},{"$f":"'Public Lighting Pricing'!E206","v":0.27018999999999999},{"$f":"'Public Lighting Pricing'!F204","v":0.34162999999999999},{"$f":"'Public Lighting Pricing'!F206","v":0.27694000000000002},{"$f":"'Public Lighting Pricing'!G204","v":0.35016999999999998},{"$f":"'Public Lighting Pricing'!G206","v":0.28386}]
["Minor",{"$f":"'Public Lighting Pricing'!C205","v":0.20777999999999999},{"$f":"'Public Lighting Pricing'!C207","v":0.16789000000000001},{"$f":"'Public Lighting Pricing'!D205","v":0.21296999999999999},{"$f":"'Public Lighting Pricing'!D207","v":0.17208999999999999},{"$f":"'Public Lighting Pricing'!E205","v":0.21829000000000001},{"$f":"'Public Lighting Pricing'!E207","v":0.17638999999999999},{"$f":"'Public Lighting Pricing'!F205","v":0.22375},{"$f":"'Public Lighting Pricing'!F207","v":0.18079999999999999},{"$f":"'Public Lighting Pricing'!G205","v":0.22933999999999999},{"$f":"'Public Lighting Pricing'!G207","v":0.18532000000000001}]
["NPL4"]
["Major",null,0.54,null,{"$f":"ROUND(C10*(1+'Input Data'!$C$85)*(1+'Input Data'!$C$87),5)","v":0.55349999999999999},null,{"$f":"ROUND(E10*(1+'Input Data'!$C$85)*(1+'Input Data'!$C$87),5)","v":0.56733999999999996},null,{"$f":"ROUND(G10*(1+'Input Data'!$C$85)*(1+'Input Data'!$C$87),5)","v":0.58152000000000004},null,{"$f":"ROUND(I10*(1+'Input Data'!$C$85)*(1+'Input Data'!$C$87),5)","v":0.59606000000000003}]
["Minor",null,0.33,null,{"$f":"ROUND(C11*(1+'Input Data'!$C$85)*(1+'Input Data'!$C$87),5)","v":0.33825},null,{"$f":"ROUND(E11*(1+'Input Data'!$C$85)*(1+'Input Data'!$C$87),5)","v":0.34671000000000002},null,{"$f":"ROUND(G11*(1+'Input Data'!$C$85)*(1+'Input Data'!$C$87),5)","v":0.35537999999999997},null,{"$f":"ROUND(I11*(1+'Input Data'!$C$85)*(1+'Input Data'!$C$87),5)","v":0.36425999999999997}]