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

{"sheet":"Input Data","index":0,"n_rows":96,"n_cols":7,"rows_kept":96,"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","#",35885.345045297261,34576.100678590032,32244.14177156322,29544.000593626886,26526.278700031078]
["Minor Conventional","#",110801.3297752769,107217.4768198989,100541.38596378837,92606.39394823648,83585.389012183427]
["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:C9)","v":149414.91239541859},{"$f":"SUM(D6:D9)","v":149714.91239541862},{"$f":"SUM(E6:E9)","v":150104.91239541859},{"$f":"SUM(F6:F9)","v":150584.91239541859},{"$f":"SUM(G6:G9)","v":151164.91239541859}]
[]
["NPL2 (Gifted & Energex Operated)"]
["Major Conventional","#",55559.541978556801,53790.261820842381,49557.771374853299,44443.805167376151,38489.78235114213]
["Minor Conventional","#",123472.78320086905,120148.73737032685,111454.28793071535,100764.6574122868,88164.787463128159]
["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(C13:C16)","v":184369.08760458144},{"$f":"SUM(D13:D16)","v":189434.08760458138},{"$f":"SUM(E13:E16)","v":194539.08760458138},{"$f":"SUM(F13:F16)","v":199694.08760458144},{"$f":"SUM(G13:G16)","v":204889.08760458138}]
["Total Opening Lights","#",{"$f":"SUM(C10,C17)","v":333784},{"$f":"SUM(D10,D17)","v":339149},{"$f":"SUM(E10,E17)","v":344644},{"$f":"SUM(F10,F17)","v":350279},{"$f":"SUM(G10,G17)","v":356054}]
[]
["Public Lights Additions by Type"]
[]
["NPL1 (Energex Owned & Operated)"]
["Major Conventional","#",0,0,0,0,0]
["Minor Conventional","#",0,0,0,0,0]
["Major LED","#",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(C23:C26)","v":7921.3348969296567},{"$f":"SUM(D23:D26)","v":9398.0497631373582},{"$f":"SUM(E23:E26)","v":11115.133193488209},{"$f":"SUM(F23:F26)","v":12618.726829648869},{"$f":"SUM(G23:G26)","v":14544.47657782691}]
[]
["NPL2 (Gifted & Energex Operated)"]
["Major Conventional","#",0,0,0,0,0]
["Minor Conventional","#",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(C30:C33)","v":15495.088413412162},{"$f":"SUM(D30:D33)","v":18031.939885600586},{"$f":"SUM(E30:E33)","v":20958.5967259057},{"$f":"SUM(F30:F33)","v":23748.892765392666},{"$f":"SUM(G30:G33)","v":27133.490127943562}]
["Total Additions","#",{"$f":"SUM(C27,C34)","v":23416.423310341819},{"$f":"SUM(D27,D34)","v":27429.989648737945},{"$f":"SUM(E27,E34)","v":32073.729919393911},{"$f":"SUM(F27,F34)","v":36367.619595041535},{"$f":"SUM(G27,G34)","v":41677.966705770472}]
[]
["Public Lights Disposals by Type"]
[]
["NPL1 (Energex Owned & Operated)"]
["Major Conventional","#",2012.8277152438754,2331.9589070268084,2700.1411779363393,3017.721893595809,3398.2543032211133]
["Minor Conventional","#",5608.5071816857817,6676.0908561105498,7934.9920155518712,9021.0049360530611,10476.222274605798]
["Major LED","#",0,0,0,0,0]
["Minor LED","#",0,0,0,0,0]
["Total","#",{"$f":"SUM(C40:C43)","v":7621.3348969296567},{"$f":"SUM(D40:D43)","v":9008.0497631373582},{"$f":"SUM(E40:E43)","v":10635.133193488211},{"$f":"SUM(F40:F43)","v":12038.726829648869},{"$f":"SUM(G40:G43)","v":13874.47657782691}]
[]
["NPL2 (Gifted & Energex Operated)"]
["Major Conventional (SV)","#",3465.809785323715,4232.4904459890777,5113.9662074771531,5954.0228162340172,6913.7881198837531]
["Minor Conventional (SV)","#",6964.2786280884466,8694.4494396115078,10689.630518428547,12599.869949158647,14974.702008059805]
["Major LED","#",0,0,0,0,0]
["Minor LED","#",0,0,0,0,0]
["Total","#",{"$f":"SUM(C47:C50)","v":10430.088413412162},{"$f":"SUM(D47:D50)","v":12926.939885600586},{"$f":"SUM(E47:E50)","v":15803.5967259057},{"$f":"SUM(F47:F50)","v":18553.892765392666},{"$f":"SUM(G47:G50)","v":21888.490127943558}]
["Total Disposals","#",{"$f":"SUM(C44,C51)","v":18051.423310341819},{"$f":"SUM(D44,D51)","v":21934.989648737945},{"$f":"SUM(E44,E51)","v":26438.729919393911},{"$f":"SUM(F44,F51)","v":30592.619595041535},{"$f":"SUM(G44,G51)","v":35762.966705770465}]
[]
["Closing Population Public Lights"]
[]
["NPL1 (Energex Owned & Operated)"]
["Major Conventional","#",{"$f":"C6+C23-C40","v":33872.517330053386},{"$f":"D6+D23-D40","v":32244.141771563223},29544.000593626879,26526.278700031078,23128.024396809964]
["Minor Conventional","#",{"$f":"C7+C24-C41","v":105192.82259359112},100541.38596378836,92606.393948236495,83585.389012183412,73109.166737577631]
["Major LED","#",{"$f":"C8+C25-C42","v":2746.4110637805206},4444.7866222706834,7264.9278002070223,10452.649693802832,14070.903997023946]
["Minor LED","#",{"$f":"C9+C26-C43","v":7903.1614079935725},12874.598037796331,21169.590053348202,30600.594989401263,41526.817264007062]
["Total","#",{"$f":"SUM(C57:C60)","v":149714.91239541859},{"$f":"SUM(D57:D60)","v":150104.91239541859},{"$f":"SUM(E57:E60)","v":150584.91239541859},{"$f":"SUM(F57:F60)","v":151164.91239541859},{"$f":"SUM(G57:G60)","v":151834.91239541859}]
[]
["NPL2 (Gifted & Energex Operated)"]
["Major Conventional","#",{"$f":"C13+C30-C47","v":52093.732193233089},{"$f":"D13+D30-D47","v":49557.771374853306},44443.805167376144,38489.78235114213,31575.994231258377]
["Minor Conventional","#",{"$f":"C14+C31-C48","v":116508.5045727806},111454.28793071535,100764.6574122868,88164.787463128159,73190.085455068358]
["Major LED","#",{"$f":"C15+C32-C49","v":6622.3394129330072},10628.300231312793,17232.266438789946,24686.289255023963,33120.07737490772]
["Minor LED","#",{"$f":"C16+C33-C50","v":14209.511425634719},22898.728067699954,37253.358586128503,53548.228535287155,72247.930543346971]
["Total","#",{"$f":"SUM(C64:C67)","v":189434.08760458144},{"$f":"SUM(D64:D67)","v":194539.08760458141},{"$f":"SUM(E64:E67)","v":199694.08760458141},{"$f":"SUM(F64:F67)","v":204889.08760458138},{"$f":"SUM(G64:G67)","v":210134.08760458144}]
["Total Closing Lights","#",{"$f":"SUM(C61,C68)","v":339149},{"$f":"SUM(D61,D68)","v":344644},{"$f":"SUM(E61,E68)","v":350279},{"$f":"SUM(F61,F68)","v":356054},{"$f":"SUM(G61,G68)","v":361969}]
[]
["Public Lights Contributed Assets"]
[]
["Contributed Assets (Conventional)"]
["Gifted","$M Nominal",1.5279960378748247,1.6076886947122644,1.581340431881465,1.6623258765108964,1.560466219281794]
["Cash Contribution","$M Nominal",0,0,0,0,0]
["Total Contributed","$M Nominal",{"$f":"SUM(C74:C75)","v":1.5279960378748247},{"$f":"SUM(D74:D75)","v":1.6076886947122644},1.581340431881465,1.6623258765108964,1.560466219281794]
[]
["Contributed Assets (LED)"]
["Gifted","$M Nominal",16.929377022812002,18.578244206162712,20.506388883575813,22.424845545321741,24.724866252566308]
["Cash Contribution","$M Nominal",0,0,0,0,0]
["Total Contributed","$M Nominal",{"$f":"SUM(C79:C80)","v":16.929377022812002},{"$f":"SUM(D79:D80)","v":18.578244206162712},{"$f":"SUM(E79:E80)","v":20.506388883575813},{"$f":"SUM(F79:F80)","v":22.424845545321741},{"$f":"SUM(G79:G80)","v":24.724866252566308}]
[]
["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.4498899036147659E-2]
["Discount rate for smoothing","%",4.8668627469626198E-2,4.757614402561864E-2,4.6483660581611075E-2,4.539117713760351E-2,4.4298693693595945E-2]
["X factor","%",0]
["Z factor Conventional","%",7.432733948696621E-2]
["Z factor LED","%",-0.56083766276908209]
[]
["% of PLAB associated with Poles, cabling and some residual brackets","%",0.7]

{"sheet":"Public Lighting Pricing","index":1,"n_rows":168,"n_cols":14,"rows_kept":168,"cut":false,"hidden":false,"merged":[]}
["Public Lighting Price Calculations","Units",{"$f":"'Input Data'!C1","v":"2020-21"},{"$f":"'Input Data'!D1","v":"2021-22"},{"$f":"'Input Data'!E1","v":"2022-23"},{"$f":"'Input Data'!F1","v":"2023-24"},{"$f":"'Input Data'!G1","v":"2024-25"},null,null,{"$f":"C1","v":"2020-21"},{"$f":"D1","v":"2021-22"},"2022-23","2023-24","2024-25"]
[]
["Building Block Revenue - Linked to PL PTRM"]
[]
["Opex Charge"]
["O&M Conventional","$M Nominal",12.569828136355305,12.384950592001607,11.635268299993779,10.643417215702247,9.362677269544756]
["O&M LED","$M Nominal",0.42868419523222512,0.66208178745014823,0.99193522203276652,1.4361240200835108,1.9502311590611994]
["Carry-over amounts Conventional","$M Nominal",0,0,0,0,0]
["Carry-over amounts LED","$M Nominal",0,0,0,0,0]
["Benchmark Tax liability Conventional","$M Nominal",0,0,0,0,0]
["Benchmark Tax liability LED","$M Nominal",2.0695234112146483,1.8340808835333418,1.6970710203951334,1.5794997605698393,1.5199253026176991]
["Total Benchmark Tax liability","$M Nominal",{"$f":"SUM(C10:C11)","v":2.0695234112146483},{"$f":"SUM(D10:D11)","v":1.8340808835333418},1.6970710203951334,1.5794997605698393,1.5199253026176991]
["Total Benchmark Tax Liability allocation - Conventional","%",{"$f":"C10/C12","v":0},{"$f":"D10/D12","v":0},0,0,0]
["Total Benchmark Tax Liability allocation - LED","%",{"$f":"1-C13","v":1},{"$f":"1-D13","v":1},1,1,1]
["Allocated Benchmark Tax liability Conventional","$M Nominal",{"$f":"C$12*C13","v":0},{"$f":"D$12*D13","v":0},{"$f":"E$12*E13","v":0},{"$f":"F$12*F13","v":0},{"$f":"G$12*G13","v":0}]
["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},{"$f":"D$15*'Input Data'!D74/'Input Data'!D$76","v":0},{"$f":"E$15*'Input Data'!E74/'Input Data'!E$76","v":0},{"$f":"F$15*'Input Data'!F74/'Input Data'!F$76","v":0},{"$f":"G$15*'Input Data'!G74/'Input Data'!G$76","v":0}]
["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}]
["Allocated Benchmark Tax liability LED","$M Nominal",{"$f":"C$12*C14","v":2.0695234112146483},{"$f":"D$12*D14","v":1.8340808835333418},{"$f":"E$12*E14","v":1.6970710203951334},{"$f":"F$12*F14","v":1.5794997605698393},{"$f":"G$12*G14","v":1.5199253026176991}]
["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$20*'Input Data'!C79/'Input Data'!C$81","v":2.0695234112146483},{"$f":"D$20*'Input Data'!D79/'Input Data'!D$81","v":1.8340808835333418},{"$f":"E$20*'Input Data'!E79/'Input Data'!E$81","v":1.6970710203951334},{"$f":"F$20*'Input Data'!F79/'Input Data'!F$81","v":1.5794997605698395},{"$f":"G$20*'Input Data'!G79/'Input Data'!G$81","v":1.5199253026176989}]
["Tax liability attributable to Contributed Assets","$M Nominal",{"$f":"C$20*'Input Data'!C80/'Input Data'!C$81","v":0},{"$f":"D$20*'Input Data'!D80/'Input Data'!D$81","v":0},{"$f":"E$20*'Input Data'!E80/'Input Data'!E$81","v":0},{"$f":"F$20*'Input Data'!F80/'Input Data'!F$81","v":0},{"$f":"G$20*'Input Data'!G80/'Input Data'!G$81","v":0}]
["Tax Liability allocated to opex - Conventional","%",{"$f":"IF(C30=1,C6/SUM(C6,C31,C32),1)","v":0.43807138360155362},{"$f":"IF(D30=1,D6/SUM(D6,D31,D32),1)","v":0.42828034706818591},{"$f":"IF(E30=1,E6/SUM(E6,E31,E32),1)","v":0.40654999779191237},{"$f":"IF(F30=1,F6/SUM(F6,F31,F32),1)","v":0.37825898622753995},{"$f":"IF(G30=1,G6/SUM(G6,G31,G32),1)","v":0.35009330999349653}]
["Tax Liability allocated to opex - LED","%",{"$f":"IF(C30=1,C7/SUM(C7,C35,C36),1)","v":0.58288329202850897},{"$f":"IF(D30=1,D7/SUM(D7,D35,D36),1)","v":0.36458474756872128},{"$f":"IF(E30=1,E7/SUM(E7,E35,E36),1)","v":0.34014563976327716},{"$f":"IF(F30=1,F7/SUM(F7,F35,F36),1)","v":0.34102780438755292},{"$f":"IF(G30=1,G7/SUM(G7,G35,G36),1)","v":0.346056529664301}]
["Total Opex Charge Conventional","$M Nominal",{"$f":"SUM(C6,C8,C16,SUM(C18,C19)*C25)","v":12.569828136355305},{"$f":"SUM(D6,D8,D16,SUM(D18,D19)*D25)","v":12.384950592001607},{"$f":"SUM(E6,E8,E16,SUM(E18,E19)*E25)","v":11.635268299993779},{"$f":"SUM(F6,F8,F16,SUM(F18,F19)*F25)","v":10.643417215702247},{"$f":"SUM(G6,G8,G16,SUM(G18,G19)*G25)","v":9.362677269544756}]
["Total Opex Charge LED","$M Nominal",{"$f":"SUM(C7,C9,C21,SUM(C23,C24)*C26)","v":1.6349748140910891},{"$f":"SUM(D7,D9,D21,SUM(D23,D24)*D26)","v":1.330759703393769},{"$f":"SUM(E7,E9,E21,SUM(E23,E24)*E26)","v":1.5691865299887868},{"$f":"SUM(F7,F9,F21,SUM(F23,F24)*F26)","v":1.9747773554613088},{"$f":"SUM(G7,G9,G21,SUM(G23,G24)*G26)","v":2.476211234634043}]
[]
["Capex Charge Conventional","NPL4 Switch",1,1,1,1,1]
["Return on capital","$M Nominal",6.8620205328945119,6.4620825740500747,6.0481928885726326,5.6272299777347472,5.187539085080429]
["Return of capital","$M Nominal",9.2617127156868229,10.070825607490914,10.936064978419695,11.867262554197522,12.193160346056931]
["Total Capex Charge Conventional","$M Nominal",{"$f":"SUM(C31,C32,C17,SUM(C18,C19)*(1-C25))*C30","v":16.123733248581335},{"$f":"SUM(D31,D32,D17,SUM(D18,D19)*(1-D25))*D30","v":16.532908181540989},{"$f":"SUM(E31,E32,E17,SUM(E18,E19)*(1-E25))*E30","v":16.98425786699233},{"$f":"SUM(F31,F32,F17,SUM(F18,F19)*(1-F25))*F30","v":17.49449253193227},{"$f":"SUM(G31,G32,G17,SUM(G18,G19)*(1-G25))*G30","v":17.380699431137359}]
["Capex Charge LED"]
["Return on capital","$M Nominal",0.13055690929790417,0.66037857323908833,1.1128595763541833,1.5886649973094369,2.0784145547937123]
["Return of capital","$M Nominal",0.17621349006006531,0.49352835487092567,0.8114125730293037,1.1863750038592957,1.6069397812463067]
["Total Capex Charge LED","$M Nominal",{"$f":"SUM(C35,C36,C22,SUM(C23,C24)*(1-C26))*C30","v":1.1700031917137539},{"$f":"SUM(D35,D36,D22,SUM(D23,D24)*(1-D26))*D30","v":2.3193098956997353},{"$f":"SUM(E35,E36,E22,SUM(E23,E24)*(1-E26))*E30","v":3.0440918618226003},{"$f":"SUM(F35,F36,F22,SUM(F23,F24)*(1-F26))*F30","v":3.8158864263607741},{"$f":"SUM(G35,G36,G22,SUM(G23,G24)*(1-G26))*G30","v":4.679299563084875}]
[]
["ARR for Conventional","$M Nominal",{"$f":"SUM(C27,C33)","v":28.69356138493664},{"$f":"SUM(D27,D33)","v":28.917858773542598},28.619526166986109,28.137909747634517,26.743376700682113]
["ARR for LED","$M Nominal",{"$f":"SUM(C28,C37)","v":2.804978005804843},{"$f":"SUM(D28,D37)","v":3.6500695990935044},4.6132783918113871,5.790663781822083,7.1555107977189181]
["ARR for Total","$M Nominal",{"$f":"SUM(C39:C40)","v":31.498539390741485},{"$f":"SUM(D39:D40)","v":32.567928372636104},33.232804558797497,33.9285735294566,33.898887498401031]
[]
["Opex and Capex Charge Components"]
["Opex Charge for Conventional Lights","$M Nominal",{"$f":"C27","v":12.569828136355305},{"$f":"D27","v":12.384950592001607},11.635268299993779,10.643417215702247,9.362677269544756]
["Opex Charge for LED","$M Nominal",{"$f":"C28","v":1.6349748140910891},{"$f":"D28","v":1.330759703393769},1.5691865299887868,1.9747773554613088,2.476211234634043]
["Capex Charge for Conventional Lights","$M Nominal",{"$f":"C33","v":16.123733248581335},{"$f":"D33","v":16.532908181540989},16.98425786699233,17.49449253193227,17.380699431137359]
["Capex Charge for LED","$M Nominal",{"$f":"C37","v":1.1700031917137539},{"$f":"D37","v":2.3193098956997353},3.0440918618226003,3.8158864263607741,4.679299563084875]
[]
["Public Lights Population"]
[]
["Average No of Lights by Tariff"]
["NPL1 (Energex Owned & Operated)"]
["Major Conventional","#",{"$f":"SUM('Input Data'!C6,'Input Data'!C57)/2","v":34878.93118767532},{"$f":"SUM('Input Data'!D6,'Input Data'!D57)/2","v":33410.121225076626},{"$f":"SUM('Input Data'!E6,'Input Data'!E57)/2","v":30894.071182595049},{"$f":"SUM('Input Data'!F6,'Input Data'!F57)/2","v":28035.139646828982},{"$f":"SUM('Input Data'!G6,'Input Data'!G57)/2","v":24827.151548420523}]
["Minor Conventional","#",{"$f":"SUM('Input Data'!C7,'Input Data'!C58)/2","v":107997.076184434},{"$f":"SUM('Input Data'!D7,'Input Data'!D58)/2","v":103879.43139184362},{"$f":"SUM('Input Data'!E7,'Input Data'!E58)/2","v":96573.889956012426},{"$f":"SUM('Input Data'!F7,'Input Data'!F58)/2","v":88095.891480209946},{"$f":"SUM('Input Data'!G7,'Input Data'!G58)/2","v":78347.277874880529}]
["Major LED","#",{"$f":"SUM('Input Data'!C8,'Input Data'!C59)/2","v":1724.9972061585829},{"$f":"SUM('Input Data'!D8,'Input Data'!D59)/2","v":3243.8071687572792},{"$f":"SUM('Input Data'!E8,'Input Data'!E59)/2","v":5854.8572112388529},{"$f":"SUM('Input Data'!F8,'Input Data'!F59)/2","v":8858.7887470049282},{"$f":"SUM('Input Data'!G8,'Input Data'!G59)/2","v":12261.776845413389}]
["Minor LED","#",{"$f":"SUM('Input Data'!C9,'Input Data'!C60)/2","v":4963.9078171506817},{"$f":"SUM('Input Data'!D9,'Input Data'!D60)/2","v":9376.5526097410566},{"$f":"SUM('Input Data'!E9,'Input Data'!E60)/2","v":17022.094045572267},{"$f":"SUM('Input Data'!F9,'Input Data'!F60)/2","v":25885.092521374732},{"$f":"SUM('Input Data'!G9,'Input Data'!G60)/2","v":36063.706126704164}]
["Total","#",{"$f":"SUM(C53:C56)","v":149564.91239541859},{"$f":"SUM(D53:D56)","v":149909.91239541859},{"$f":"SUM(E53:E56)","v":150344.91239541859},{"$f":"SUM(F53:F56)","v":150874.91239541859},{"$f":"SUM(G53:G56)","v":151499.91239541859}]
[]
["NPL2 (Gifted & Energex Operated)"]
["Major Conventional","#",{"$f":"SUM('Input Data'!C13,'Input Data'!C64)/2","v":53826.637085894945},{"$f":"SUM('Input Data'!D13,'Input Data'!D64)/2","v":51674.016597847847},{"$f":"SUM('Input Data'!E13,'Input Data'!E64)/2","v":47000.788271114725},{"$f":"SUM('Input Data'!F13,'Input Data'!F64)/2","v":41466.793759259141},{"$f":"SUM('Input Data'!G13,'Input Data'!G64)/2","v":35032.888291200252}]
["Minor Conventional","#",{"$f":"SUM('Input Data'!C14,'Input Data'!C65)/2","v":119990.64388682482},{"$f":"SUM('Input Data'!D14,'Input Data'!D65)/2","v":115801.51265052109},{"$f":"SUM('Input Data'!E14,'Input Data'!E65)/2","v":106109.47267150108},{"$f":"SUM('Input Data'!F14,'Input Data'!F65)/2","v":94464.722437707474},{"$f":"SUM('Input Data'!G14,'Input Data'!G65)/2","v":80677.436459098259}]
["Major LED","#",{"$f":"SUM('Input Data'!C15,'Input Data'!C66)/2","v":4159.4345202711502},{"$f":"SUM('Input Data'!D15,'Input Data'!D66)/2","v":7777.0550083182534},{"$f":"SUM('Input Data'!E15,'Input Data'!E66)/2","v":13930.283335051368},{"$f":"SUM('Input Data'!F15,'Input Data'!F66)/2","v":20959.277846906953},{"$f":"SUM('Input Data'!G15,'Input Data'!G66)/2","v":28903.183314965841}]
["Minor LED","#",{"$f":"SUM('Input Data'!C16,'Input Data'!C67)/2","v":8924.8721115904955},{"$f":"SUM('Input Data'!D16,'Input Data'!D67)/2","v":16734.003347894199},{"$f":"SUM('Input Data'!E16,'Input Data'!E67)/2","v":30076.04332691423},{"$f":"SUM('Input Data'!F16,'Input Data'!F67)/2","v":45400.793560707825},{"$f":"SUM('Input Data'!G16,'Input Data'!G67)/2","v":62898.079539317063}]
["Total","#",{"$f":"SUM(C60:C63)","v":186901.58760458141},{"$f":"SUM(D60:D63)","v":191986.58760458138},{"$f":"SUM(E60:E63)","v":197116.58760458141},{"$f":"SUM(F60:F63)","v":202291.58760458138},{"$f":"SUM(G60:G63)","v":207511.58760458141}]
["Grand total","#",{"$f":"SUM(C57,C64)","v":336466.5},{"$f":"SUM(D57,D64)","v":341896.5},347461.5,353166.5,359011.5]
[]
["Average No of Lights by Type"]
["Major Conventional","#",{"$f":"SUM(C53,C60)","v":88705.568273570272},{"$f":"SUM(D53,D60)","v":85084.137822924473},77894.859453709767,69501.933406088123,59860.039839620775]
["Minor Conventional","#",{"$f":"SUM(C54,C61)","v":227987.72007125884},219680.94404236472,202683.3626275135,182560.61391791742,159024.71433397877]
["Major LED","#",{"$f":"SUM(C55,C62)","v":5884.4317264297333},11020.862177075533,19785.140546290222,29818.066593911881,41164.960160379233]
["Minor LED","#",{"$f":"SUM(C56,C63)","v":13888.779928741176},26110.555957635253,47098.137372486497,71285.88608208255,98961.785666021227]
["Total","#",{"$f":"SUM(C68:C71)","v":336466.5},{"$f":"SUM(D68:D71)","v":341896.5},{"$f":"SUM(E68:E71)","v":347461.5},{"$f":"SUM(F68:F71)","v":353166.5},{"$f":"SUM(G68:G71)","v":359011.5}]
[]
["Price Components"]
[]
["Opex Charge"]
["NPL1 (Energex Owned & Operated)"]
["Major Conventional","$/day/light Nominal",{"$f":"C44*10^6/(C68+C69/'Input Data'!$C$86)","v":52.222537901982328},{"$f":"D44*10^6/(D68+D69/'Input Data'!$C$86)","v":53.489903235375529},{"$f":"E44*10^6/(E68+E69/'Input Data'!$C$86)","v":54.6212873715494},{"$f":"F44*10^6/(F68+F69/'Input Data'!$C$86)","v":55.663785152214572},{"$f":"G44*10^6/(G68+G69/'Input Data'!$C$86)","v":56.443657558070626}]
["Minor Conventional","$/day/light Nominal",{"$f":"C78/'Input Data'!$C$86","v":34.815025267988219},{"$f":"D78/'Input Data'!$C$86","v":35.659935490250355},{"$f":"E78/'Input Data'!$C$86","v":36.414191581032931},{"$f":"F78/'Input Data'!$C$86","v":37.109190101476379},{"$f":"G78/'Input Data'!$C$86","v":37.629105038713753}]
["Major LED","$/day/light Nominal",{"$f":"C45*10^6/(C70+C71/'Input Data'!$C$86)","v":107.9646077165671},{"$f":"D45*10^6/(D70+D71/'Input Data'!$C$86)","v":46.81174928976457},{"$f":"E45*10^6/(E70+E71/'Input Data'!$C$86)","v":30.657815581526062},{"$f":"F45*10^6/(F70+F71/'Input Data'!$C$86)","v":25.533055703631511},{"$f":"G45*10^6/(G70+G71/'Input Data'!$C$86)","v":23.112032498432658}]
["Minor LED","$/day/light Nominal",{"$f":"C80/'Input Data'!$C$86","v":71.976405144378063},{"$f":"D80/'Input Data'!$C$86","v":31.207832859843048},{"$f":"E80/'Input Data'!$C$86","v":20.438543721017375},{"$f":"F80/'Input Data'!$C$86","v":17.022037135754342},{"$f":"G80/'Input Data'!$C$86","v":15.408021665621773}]
[]
["NPL2 (Gifted & Energex Operated)"]
["Major Conventional","$/day/light Nominal",{"$f":"C78","v":52.222537901982328},{"$f":"D78","v":53.489903235375529},54.6212873715494,55.663785152214572,56.443657558070626]
["Minor Conventional","$/day/light Nominal",{"$f":"C79","v":34.815025267988219},35.659935490250355,36.414191581032931,37.109190101476379,37.629105038713753]
["Major LED","$/day/light Nominal",{"$f":"C80","v":107.9646077165671},46.81174928976457,30.657815581526062,25.533055703631511,23.112032498432658]
["Minor LED","$/day/light Nominal",{"$f":"C81","v":71.976405144378063},31.207832859843048,20.438543721017375,17.022037135754342,15.408021665621773]
[]
["Capex Charge"]
["NPL1 (Energex Owned & Operated)"]
["Major Conventional","$/day/light Nominal",{"$f":"C46*10^6/(C53+C54/'Input Data'!$C$87)*(1-'Input Data'!$C$84)","v":152.94869138016398},{"$f":"D46*10^6/(D53+D54/'Input Data'!$C$87)*(1-'Input Data'!$C$84)","v":163.29529974309119},{"$f":"E46*10^6/(E53+E54/'Input Data'!$C$87)*(1-'Input Data'!$C$84)","v":180.79850124615527},{"$f":"F46*10^6/(F53+F54/'Input Data'!$C$87)*(1-'Input Data'!$C$84)","v":204.54137720479423},{"$f":"G46*10^6/(G53+G54/'Input Data'!$C$87)*(1-'Input Data'!$C$84)","v":228.84926850308406}]
["Minor Conventional","$/day/light Nominal",{"$f":"C91/'Input Data'!$C$87","v":84.97149521120221},{"$f":"D91/'Input Data'!$C$87","v":90.719610968383989},{"$f":"E91/'Input Data'!$C$87","v":100.44361180341959},{"$f":"F91/'Input Data'!$C$87","v":113.6340984471079},{"$f":"G91/'Input Data'!$C$87","v":127.13848250171337}]
["Major LED","$/day/light Nominal",{"$f":"C47*10^6/(C55+C56/'Input Data'!$C$87)*(1-'Input Data'!$C$84)","v":234.90246695494253},{"$f":"D47*10^6/(D55+D56/'Input Data'!$C$87)*(1-'Input Data'!$C$84)","v":246.93932920150328},{"$f":"E47*10^6/(E55+E56/'Input Data'!$C$87)*(1-'Input Data'!$C$84)","v":178.92884789877226},{"$f":"F47*10^6/(F55+F56/'Input Data'!$C$87)*(1-'Input Data'!$C$84)","v":147.77913451654192},{"$f":"G47*10^6/(G55+G56/'Input Data'!$C$87)*(1-'Input Data'!$C$84)","v":130.39438808950919}]
["Minor LED","$/day/light Nominal",{"$f":"C93/'Input Data'!$C$87","v":130.50137053052362},{"$f":"D93/'Input Data'!$C$87","v":137.18851622305738},{"$f":"E93/'Input Data'!$C$87","v":99.404915499317923},{"$f":"F93/'Input Data'!$C$87","v":82.099519175856614},{"$f":"G93/'Input Data'!$C$87","v":72.441326716393988}]
[]
["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":"C46*10^6/(C68+C69/'Input Data'!$C$87)*'Input Data'!$C$84","v":7.4866864842075831},{"$f":"D46*10^6/(D68+D69/'Input Data'!$C$87)*'Input Data'!$C$84","v":7.9819338006730423},{"$f":"E46*10^6/(E68+E69/'Input Data'!$C$87)*'Input Data'!$C$84","v":8.9157740832320851},{"$f":"F46*10^6/(F68+F69/'Input Data'!$C$87)*'Input Data'!$C$84","v":10.23521664262698},{"$f":"G46*10^6/(G68+G69/'Input Data'!$C$87)*'Input Data'!$C$84","v":11.727305262214873}]
["Minor Conventional","$/day/light Nominal",{"$f":"C104/'Input Data'!$C$87","v":4.1592702690042129},{"$f":"D104/'Input Data'!$C$87","v":4.4344076670405785},{"$f":"E104/'Input Data'!$C$87","v":4.9532078240178246},{"$f":"F104/'Input Data'!$C$87","v":5.6862314681260999},{"$f":"G104/'Input Data'!$C$87","v":6.515169590119374}]
["Major LED","$/day/light Nominal",{"$f":"C47*10^6/(C70+C71/'Input Data'!$C$87)*'Input Data'!$C$84","v":8.602698609200333},{"$f":"D47*10^6/(D70+D71/'Input Data'!$C$87)*'Input Data'!$C$84","v":9.0858100696816511},{"$f":"E47*10^6/(E70+E71/'Input Data'!$C$87)*'Input Data'!$C$84","v":6.6246805037486114},{"$f":"F47*10^6/(F70+F71/'Input Data'!$C$87)*'Input Data'!$C$84","v":5.4967054958559309},{"$f":"G47*10^6/(G70+G71/'Input Data'!$C$87)*'Input Data'!$C$84","v":4.8669835924918132}]
["Minor LED","$/day/light Nominal",{"$f":"C106/'Input Data'!$C$87","v":4.7792770051112958},{"$f":"D106/'Input Data'!$C$87","v":5.0476722609342506},{"$f":"E106/'Input Data'!$C$87","v":3.6803780576381175},{"$f":"F106/'Input Data'!$C$87","v":3.0537252754755171},{"$f":"G106/'Input Data'!$C$87","v":2.703879773606563}]
[]
["NPL2 (Gifted & Energex Operated)"]
["Major Conventional","$/day/light Nominal",{"$f":"C104","v":7.4866864842075831},{"$f":"D104","v":7.9819338006730423},8.9157740832320851,10.23521664262698,11.727305262214873]
["Minor Conventional","$/day/light Nominal",{"$f":"C105","v":4.1592702690042129},4.4344076670405785,4.9532078240178246,5.6862314681260999,6.515169590119374]
["Major LED","$/day/light Nominal",{"$f":"C106","v":8.602698609200333},9.0858100696816511,6.6246805037486114,5.4967054958559309,4.8669835924918132]
["Minor LED","$/day/light Nominal",{"$f":"C107","v":4.7792770051112958},5.0476722609342506,3.6803780576381175,3.0537252754755171,2.703879773606563]
[]
[null,"2020-06-30",{"$f":"EOMONTH(B115,12)","v":"2021-06-30"},{"$f":"EOMONTH(C115,12)","v":"2022-06-30"},"2023-06-30","2024-06-30","2025-06-30"]
["Pricing Days in Year","#",{"$f":"C115-B115","v":365},{"$f":"D115-C115","v":365},{"$f":"E115-D115","v":365},{"$f":"F115-E115","v":366},{"$f":"G115-F115","v":365}]
[]
[]
["Unsmoothed Prices"]
[]
["NPL1 (Energex Owned & Operated)"]
["Major Conventional","$/day/light Nominal",{"$f":"SUM(C78,C91,C104)/C$116","v":0.58262442675713388},{"$f":"SUM(D78,D91,D104)/D$116","v":0.61580037473736915},0.66941250055051171,0.73890813934326727,0.81375405842019055]
["Minor Conventional","$/day/light Nominal",{"$f":"SUM(C79,C92,C105)/C$116","v":0.33957750889916338},{"$f":"SUM(D79,D92,D105)/D$116","v":0.3583943948648628},0.38852331837937082,0.42740306015494639,0.46926782775492187]
["Major LED","$/day/light Nominal",{"$f":"SUM(C80,C93,C106)/C$116","v":0.96293088570057517},0.82969010564643697,0.59235984653163543,0.48854889539898733,0.43389973748064015]
["Minor LED","$/day/light Nominal",{"$f":"SUM(C81,C94,C107)/C$116","v":0.56782754158907667},0.47518909957214983,0.33842147199444772,0.27916743603029093,0.24809103604280089]
[]
["NPL2 (Gifted & Energex Operated)"]
["Major Conventional","$/day/light Nominal",{"$f":"SUM(C84,C97,C110)/C$116","v":0.16358691612654769},{"$f":"SUM(D84,D97,D110)/D$116","v":0.16841599187958511},0.17407414097200408,0.18005191747224467,0.18676976115146712]
["Minor Conventional","$/day/light Nominal",{"$f":"SUM(C85,C98,C111)/C$116","v":0.10677889188217103},0.10984751549942723,0.11333534083575549,0.1169273813377117,0.12094321816118667]
["Major LED","$/day/light Nominal",{"$f":"SUM(C86,C99,C112)/C$116","v":0.31936248308429432},0.15314399824505814,0.10214382489116348,8.4780768304610496E-2,7.6654838605272529E-2]
["Minor LED","$/day/light Nominal",{"$f":"SUM(C87,C100,C113)/C$116","v":0.21028954013558729},9.9330151015828219E-2,6.6079237749741074E-2,5.4851809866748251E-2,4.962164777870777E-2]
[]
["Smoothed Prices"]
[]
["NPL1 (Energex Owned & Operated)"]
["Major Conventional","$/day/light Nominal",{"$f":"C122*(1+'Input Data'!$C$93)","v":0.62592935031811037},{"$f":"C136*(1-'Input Data'!$C$92)*(1+'Input Data'!$C$90)","v":0.64126393027531525},{"$f":"D136*(1-'Input Data'!$C$92)*(1+'Input Data'!$C$90)","v":0.65697419055865347},{"$f":"E136*(1-'Input Data'!$C$92)*(1+'Input Data'!$C$90)","v":0.67306933492250476},{"$f":"F136*(1-'Input Data'!$C$92)*(1+'Input Data'!$C$90)","v":0.68955879260309827}]
["Minor Conventional","$/day/light Nominal",{"$f":"C123*(1+'Input Data'!$C$93)","v":0.36481740168524979},{"$f":"C137*(1-'Input Data'!$C$92)*(1+'Input Data'!$C$90)","v":0.37375502637576646},{"$f":"D137*(1-'Input Data'!$C$92)*(1+'Input Data'!$C$90)","v":0.38291161303119908},{"$f":"E137*(1-'Input Data'!$C$92)*(1+'Input Data'!$C$90)","v":0.39229252597861886},{"$f":"F137*(1-'Input Data'!$C$92)*(1+'Input Data'!$C$90)","v":0.40190326096520435}]
["Major LED","$/day/light Nominal",{"$f":"C124*(1+'Input Data'!$C$94)","v":0.42288297835610245},{"$f":"C138*(1-'Input Data'!$C$92)*(1+'Input Data'!$C$90)","v":0.43324314574695399},{"$f":"D138*(1-'Input Data'!$C$92)*(1+'Input Data'!$C$90)","v":0.44385712583271164},{"$f":"E138*(1-'Input Data'!$C$92)*(1+'Input Data'!$C$90)","v":0.45473113674496191},{"$f":"F138*(1-'Input Data'!$C$92)*(1+'Input Data'!$C$90)","v":0.46587154895266936}]
["Minor LED","$/day/light Nominal",{"$f":"C125*(1+'Input Data'!$C$94)","v":0.24936847030834516},{"$f":"C139*(1-'Input Data'!$C$92)*(1+'Input Data'!$C$90)","v":0.25547772328522789},{"$f":"D139*(1-'Input Data'!$C$92)*(1+'Input Data'!$C$90)","v":0.26173664623397758},{"$f":"E139*(1-'Input Data'!$C$92)*(1+'Input Data'!$C$90)","v":0.26814890590412371},{"$f":"F139*(1-'Input Data'!$C$92)*(1+'Input Data'!$C$90)","v":0.27471825887652229}]
[]
["NPL2 (Gifted & Energex Operated)"]
["Major Conventional","$/day/light Nominal",{"$f":"C128*(1+'Input Data'!$C$93)","v":0.17574589637711144},{"$f":"C142*(1-'Input Data'!$C$92)*(1+'Input Data'!$C$90)","v":0.18005147734847157},{"$f":"D142*(1-'Input Data'!$C$92)*(1+'Input Data'!$C$90)","v":0.184462540313341},{"$f":"E142*(1-'Input Data'!$C$92)*(1+'Input Data'!$C$90)","v":0.18898166946442885},{"$f":"F142*(1-'Input Data'!$C$92)*(1+'Input Data'!$C$90)","v":0.19361151230432053}]
["Minor Conventional","$/day/light Nominal",{"$f":"C129*(1+'Input Data'!$C$93)","v":0.11471548282913921},{"$f":"C143*(1-'Input Data'!$C$92)*(1+'Input Data'!$C$90)","v":0.11752588586085322},{"$f":"D143*(1-'Input Data'!$C$92)*(1+'Input Data'!$C$90)","v":0.12040514067269208},{"$f":"E143*(1-'Input Data'!$C$92)*(1+'Input Data'!$C$90)","v":0.12335493405746552},{"$f":"F143*(1-'Input Data'!$C$92)*(1+'Input Data'!$C$90)","v":0.12637699413255002}]
["Major LED","$/day/light Nominal",{"$f":"C130*(1+'Input Data'!$C$94)","v":0.14025197449516819},{"$f":"C144*(1-'Input Data'!$C$92)*(1+'Input Data'!$C$90)","v":0.14368799345794567},{"$f":"D144*(1-'Input Data'!$C$92)*(1+'Input Data'!$C$90)","v":0.14720819110237851},{"$f":"E144*(1-'Input Data'!$C$92)*(1+'Input Data'!$C$90)","v":0.15081462971348961},{"$f":"F144*(1-'Input Data'!$C$92)*(1+'Input Data'!$C$90)","v":0.15450942210001439}]
["Minor LED","$/day/light Nominal",{"$f":"C131*(1+'Input Data'!$C$94)","v":9.2351245941159427E-2},{"$f":"C145*(1-'Input Data'!$C$92)*(1+'Input Data'!$C$90)","v":9.4613749791334328E-2},{"$f":"D145*(1-'Input Data'!$C$92)*(1+'Input Data'!$C$90)","v":9.6931682494903568E-2},{"$f":"E145*(1-'Input Data'!$C$92)*(1+'Input Data'!$C$90)","v":9.9306401997750135E-2},{"$f":"F145*(1-'Input Data'!$C$92)*(1+'Input Data'!$C$90)","v":0.10173929951393611}]
[]
["Recovered Revenue"]
[]
["Cumulative Discount Rate",null,{"$f":"(1+'Input Data'!C91)","v":1.0486686274696262},{"$f":"C149*(1+'Input Data'!D91)","v":1.098560237125269},{"$f":"D149*(1+'Input Data'!E91)","v":1.149625338316254},{"$f":"E149*(1+'Input Data'!F91)","v":1.2018081856896443},{"$f":"F149*(1+'Input Data'!G91)","v":1.2550467183859659}]
[]
["Recovered revenue Conventional","$M Nominal",{"$f":"(SUMPRODUCT(C136:C137,C53:C54)+SUMPRODUCT(C142:C143,C60:C61))*C116/10^6","v":30.826277463084924},{"$f":"(SUMPRODUCT(D136:D137,D53:D54)+SUMPRODUCT(D142:D143,D60:D61))*D116/10^6","v":30.354795633993511},{"$f":"(SUMPRODUCT(E136:E137,E53:E54)+SUMPRODUCT(E142:E143,E60:E61))*E116/10^6","v":28.733486993122227},{"$f":"(SUMPRODUCT(F136:F137,F53:F54)+SUMPRODUCT(F142:F143,F60:F61))*F116/10^6","v":26.688026837241878},{"$f":"(SUMPRODUCT(G136:G137,G53:G54)+SUMPRODUCT(G142:G143,G60:G61))*G116/10^6","v":23.939017570285941}]
["NPV of recovered revenue Conventional","$M Nominal",{"$f":"SUM(C151/C$149,D151/D$149,E151/E$149,F151/F$149,G151/G$149)","v":123.30161628972986}]
["NPV of revenue requirement Conventional","$M Nominal",{"$f":"SUM(C39/C$149,D39/D$149,E39/E$149,F39/F$149,G39/G$149)","v":123.30161628972989}]
["Difference Conventional","$M Nominal",{"$f":"C152-C153","v":0}]
[]
["Recovered revenue LED","$M Nominal",{"$f":"(SUMPRODUCT(C138:C139,C55:C56)+SUMPRODUCT(C144:C145,C62:C63))*C116/10^6","v":1.231840696910574},{"$f":"(SUMPRODUCT(D138:D139,D55:D56)+SUMPRODUCT(D144:D145,D62:D63))*D116/10^6","v":2.3730817260179022},{"$f":"(SUMPRODUCT(E138:E139,E55:E56)+SUMPRODUCT(E144:E145,E62:E63))*E116/10^6","v":4.3872997062015653},{"$f":"(SUMPRODUCT(F138:F139,F55:F56)+SUMPRODUCT(F144:F145,F62:F63))*F116/10^6","v":6.8218672289423958},{"$f":"(SUMPRODUCT(G138:G139,G55:G56)+SUMPRODUCT(G144:G145,G62:G63))*G116/10^6","v":9.6669491645323777}]
["NPV of recovered revenue LED","$M Nominal",{"$f":"SUM(C156/C$149,D156/D$149,E156/E$149,F156/F$149,G156/G$149)","v":20.52992977289912}]
["NPV of revenue requirement LED","$M Nominal",{"$f":"SUM(C40/C$149,D40/D$149,E40/E$149,F40/F$149,G40/G$149)","v":20.52992977289912}]
["Difference LED","$M Nominal",{"$f":"C157-C158","v":0}]
[]
[]
["Check Unsmoothed Prices"]
["Unsmoothed Prices X Volumes - Conventional",null,{"$f":"(SUMPRODUCT(C122:C123,C53:C54)+SUMPRODUCT(C128:C129,C60:C61))*C116/10^6","v":28.69356138493664},{"$f":"(SUMPRODUCT(D122:D123,D53:D54)+SUMPRODUCT(D128:D129,D60:D61))*D116/10^6","v":28.917858773542598},{"$f":"(SUMPRODUCT(E122:E123,E53:E54)+SUMPRODUCT(E128:E129,E60:E61))*E116/10^6","v":28.619526166986109},{"$f":"(SUMPRODUCT(F122:F123,F53:F54)+SUMPRODUCT(F128:F129,F60:F61))*F116/10^6","v":28.137909747634517},{"$f":"(SUMPRODUCT(G122:G123,G53:G54)+SUMPRODUCT(G128:G129,G60:G61))*G116/10^6","v":26.743376700682116}]
["Revenue requirement - Conventional",null,{"$f":"C39","v":28.69356138493664},{"$f":"D39","v":28.917858773542598},28.619526166986109,28.137909747634517,26.743376700682113]
["Check",null,{"$f":"C163-C164","v":0},{"$f":"D163-D164","v":0},0,0,0]
["Unsmoothed Prices X Volumes - LED",null,{"$f":"(SUMPRODUCT(C124:C125,C55:C56)+SUMPRODUCT(C130:C131,C62:C63))*C116/10^6","v":2.804978005804843},{"$f":"(SUMPRODUCT(D124:D125,D55:D56)+SUMPRODUCT(D130:D131,D62:D63))*D116/10^6","v":3.6500695990935053},{"$f":"(SUMPRODUCT(E124:E125,E55:E56)+SUMPRODUCT(E130:E131,E62:E63))*E116/10^6","v":4.6132783918113889},{"$f":"(SUMPRODUCT(F124:F125,F55:F56)+SUMPRODUCT(F130:F131,F62:F63))*F116/10^6","v":5.790663781822083},{"$f":"(SUMPRODUCT(G124:G125,G55:G56)+SUMPRODUCT(G130:G131,G62:G63))*G116/10^6","v":7.1555107977189181}]
["Revenue requirement - LED",null,{"$f":"C40","v":2.804978005804843},{"$f":"D40","v":3.6500695990935044},4.6132783918113871,5.790663781822083,7.1555107977189181]
["Check",null,{"$f":"C166-C167","v":0},{"$f":"D166-D167","v":0},{"$f":"E166-E167","v":0},{"$f":"F166-F167","v":0},{"$f":"G166-G167","v":0}]

{"sheet":"Output Tables","index":2,"n_rows":47,"n_cols":24,"rows_kept":47,"cut":false,"hidden":false,"merged":[[44,1,44,2],[44,3,44,4],[44,5,44,6],[44,7,44,8],[44,9,44,10],[45,1,46,1],[45,3,46,3],[45,5,46,5],[45,7,46,7],[45,9,46,9],[38,9,38,10],[41,1,41,2],[41,3,41,4],[41,5,41,6],[41,7,41,8],[41,9,41,10],[38,1,38,2],[38,3,38,4],[38,5,38,6],[38,7,38,8],[29,5,29,6],[29,7,29,8],[17,1,17,2],[29,1,29,2],[26,1,26,2],[20,1,20,2],[21,1,22,1],[33,1,34,1],[33,3,34,3],[33,5,34,5],[33,7,34,7],[33,9,34,9],[29,9,29,10],[17,3,17,4],[17,5,17,6],[17,7,17,8],[26,3,26,4],[26,5,26,6],[26,7,26,8],[26,9,26,10],[20,3,20,4],[20,5,20,6],[20,7,20,8],[20,9,20,10],[21,3,22,3],[21,5,22,5],[21,7,22,7],[29,3,29,4],[32,1,32,2],[32,3,32,4],[32,5,32,6],[32,7,32,8],[32,9,32,10],[21,9,22,9],[9,1,10,1],[9,3,10,3],[9,5,10,5],[9,7,10,7],[9,9,10,9],[14,1,14,2],[14,3,14,4],[14,5,14,6],[14,7,14,8],[14,9,14,10],[17,9,17,10],[5,1,5,2],[5,3,5,4],[5,5,5,6],[5,7,5,8],[5,9,5,10],[8,1,8,2],[8,3,8,4],[8,5,8,6],[8,7,8,8],[8,9,8,10],[0,1,0,2],[0,3,0,4],[0,5,0,6],[0,7,0,8],[0,9,0,10],[2,1,2,2],[2,3,2,4],[2,5,2,6],[2,7,2,8],[2,9,2,10],[0,15,0,17],[0,18,0,20],[12,15,12,17],[12,18,12,20],[21,22,22,22],[14,22,14,23],[17,22,17,23],[20,22,20,23],[0,22,0,23],[2,22,2,23],[5,22,5,23],[8,22,8,23],[9,22,10,22]]}
["Public Lighting Prices ($ Nominal)","2020-21",null,"2021-22",null,"2022-23",null,"2023-24",null,"2024-25",null,null,"LED Vs CON Prices",null,"2019-20",{"$f":"B1","v":"2020-21"},null,null,"Price Movement",null,null,null,"2020-21 Annual Prices"]
[null,"Conventional","LED","Conventional","LED","Conventional","LED","Conventional","LED","Conventional","LED",null,null,null,"All Lights","CON","LED","Average",{"$f":"P2","v":"CON"},{"$f":"Q2","v":"LED"},"Average",null,{"$f":"B2","v":"Conventional"},{"$f":"C2","v":"LED"}]
["NPL1 (Energex Owned & Operated)"]
["Major",{"$f":"ROUND('Public Lighting Pricing'!C136,5)","v":0.62592999999999999},{"$f":"ROUND('Public Lighting Pricing'!C138,5)","v":0.42287999999999998},{"$f":"ROUND('Public Lighting Pricing'!D136,5)","v":0.64126000000000005},{"$f":"ROUND('Public Lighting Pricing'!D138,5)","v":0.43324000000000001},{"$f":"ROUND('Public Lighting Pricing'!E136,5)","v":0.65697000000000005},{"$f":"ROUND('Public Lighting Pricing'!E138,5)","v":0.44385999999999998},{"$f":"ROUND('Public Lighting Pricing'!F136,5)","v":0.67306999999999995},{"$f":"ROUND('Public Lighting Pricing'!F138,5)","v":0.45473000000000002},{"$f":"ROUND('Public Lighting Pricing'!G136,5)","v":0.68955999999999995},{"$f":"ROUND('Public Lighting Pricing'!G138,5)","v":0.46587000000000001},null,{"$f":"C4/B4","v":0.67560270317767157},null,0.86624337291703846,{"$f":"B4","v":0.62592999999999999},{"$f":"C4","v":0.42287999999999998},{"$f":"(B4*'Public Lighting Pricing'!C$53+C4*'Public Lighting Pricing'!C$55)/SUM('Public Lighting Pricing'!C$53,'Public Lighting Pricing'!C$55)","v":0.61636106305580307},{"$f":"P4/$O4-1","v":-0.27742015746428539},{"$f":"Q4/$O4-1","v":-0.5118231051211749},-0.28846663382805127,null,{"$f":"B4*'Public Lighting Pricing'!$C$116","v":228.46445},{"$f":"C4*'Public Lighting Pricing'!$C$116","v":154.35120000000001}]
["Minor",{"$f":"ROUND('Public Lighting Pricing'!C137,5)","v":0.36481999999999998},{"$f":"ROUND('Public Lighting Pricing'!C139,5)","v":0.24937000000000001},{"$f":"ROUND('Public Lighting Pricing'!D137,5)","v":0.37375999999999998},{"$f":"ROUND('Public Lighting Pricing'!D139,5)","v":0.25547999999999998},{"$f":"ROUND('Public Lighting Pricing'!E137,5)","v":0.38290999999999997},{"$f":"ROUND('Public Lighting Pricing'!E139,5)","v":0.26173999999999997},{"$f":"ROUND('Public Lighting Pricing'!F137,5)","v":0.39229000000000003},{"$f":"ROUND('Public Lighting Pricing'!F139,5)","v":0.26815},{"$f":"ROUND('Public Lighting Pricing'!G137,5)","v":0.40189999999999998},{"$f":"ROUND('Public Lighting Pricing'!G139,5)","v":0.27472000000000002},null,{"$f":"C5/B5","v":0.6835425689381065},null,0.39766203248884929,{"$f":"B5","v":0.36481999999999998},{"$f":"C5","v":0.24937000000000001},{"$f":"(B5*'Public Lighting Pricing'!C$54+C5*'Public Lighting Pricing'!C$56)/SUM('Public Lighting Pricing'!C$54,'Public Lighting Pricing'!C$56)","v":0.35974671595812224},{"$f":"P5/$O5-1","v":-8.2587800206373019E-2},{"$f":"Q5/$O5-1","v":-0.37290970817790481},{"$f":"R5/$O5-1","v":-9.5345578488915006E-2},null,{"$f":"B5*'Public Lighting Pricing'!$C$116","v":133.1593},{"$f":"C5*'Public Lighting Pricing'!$C$116","v":91.020049999999998}]
["NPL2 (Gifted & Energex Operated)"]
["Major",{"$f":"ROUND('Public Lighting Pricing'!C142,5)","v":0.17574999999999999},{"$f":"ROUND('Public Lighting Pricing'!C144,5)","v":0.14025000000000001},{"$f":"ROUND('Public Lighting Pricing'!D142,5)","v":0.18004999999999999},{"$f":"ROUND('Public Lighting Pricing'!D144,5)","v":0.14369000000000001},{"$f":"ROUND('Public Lighting Pricing'!E142,5)","v":0.18446000000000001},{"$f":"ROUND('Public Lighting Pricing'!E144,5)","v":0.14721000000000001},{"$f":"ROUND('Public Lighting Pricing'!F142,5)","v":0.18898000000000001},{"$f":"ROUND('Public Lighting Pricing'!F144,5)","v":0.15081},{"$f":"ROUND('Public Lighting Pricing'!G142,5)","v":0.19361},{"$f":"ROUND('Public Lighting Pricing'!G144,5)","v":0.15451000000000001},null,{"$f":"C7/B7","v":0.79800853485064027},null,0.30145844954504908,{"$f":"B7","v":0.17574999999999999},{"$f":"C7","v":0.14025000000000001},{"$f":"(B7*'Public Lighting Pricing'!C$60+C7*'Public Lighting Pricing'!C$62)/SUM('Public Lighting Pricing'!C$60,'Public Lighting Pricing'!C$62)","v":0.17320352769415884},{"$f":"P7/$O7-1","v":-0.41700091583023813},{"$f":"Q7/$O7-1","v":-0.53476175502242329},{"$f":"R7/$O7-1","v":-0.42544809092081592},null,{"$f":"B7*'Public Lighting Pricing'!$C$116","v":64.148749999999993},{"$f":"C7*'Public Lighting Pricing'!$C$116","v":51.191250000000004}]
["Minor",{"$f":"ROUND('Public Lighting Pricing'!C143,5)","v":0.11472},{"$f":"ROUND('Public Lighting Pricing'!C145,5)","v":9.2350000000000002E-2},{"$f":"ROUND('Public Lighting Pricing'!D143,5)","v":0.11753},{"$f":"ROUND('Public Lighting Pricing'!D145,5)","v":9.461E-2},{"$f":"ROUND('Public Lighting Pricing'!E143,5)","v":0.12041},{"$f":"ROUND('Public Lighting Pricing'!E145,5)","v":9.6930000000000002E-2},{"$f":"ROUND('Public Lighting Pricing'!F143,5)","v":0.12335},{"$f":"ROUND('Public Lighting Pricing'!F145,5)","v":9.9309999999999996E-2},{"$f":"ROUND('Public Lighting Pricing'!G143,5)","v":0.12637999999999999},{"$f":"ROUND('Public Lighting Pricing'!G145,5)","v":0.10174},null,{"$f":"C8/B8","v":0.80500348675034872},null,0.14594988010704729,{"$f":"B8","v":0.11472},{"$f":"C8","v":9.2350000000000002E-2},{"$f":"(B8*'Public Lighting Pricing'!C$61+C8*'Public Lighting Pricing'!C$63)/SUM('Public Lighting Pricing'!C$61,'Public Lighting Pricing'!C$63)","v":0.11317131606083218},{"$f":"P8/$O8-1","v":-0.21397674382563148},-0.36724853811277081,-0.22458781070716605,null,{"$f":"B8*'Public Lighting Pricing'!$C$116","v":41.872799999999998},{"$f":"C8*'Public Lighting Pricing'!$C$116","v":33.707749999999997}]
["NPL4"]
["Major",null,{"$f":"(C4-C7)*PLAB_NPL4+C7*0.9","v":0.32406599999999997},null,{"$f":"ROUND(C10*(1-'Input Data'!$C$92)*(1+'Input Data'!$C$90),5)","v":0.33201000000000003},null,{"$f":"ROUND(E10*(1-'Input Data'!$C$92)*(1+'Input Data'!$C$90),5)","v":0.34014},null,{"$f":"ROUND(G10*(1-'Input Data'!$C$92)*(1+'Input Data'!$C$90),5)","v":0.34847},null,{"$f":"ROUND(I10*(1-'Input Data'!$C$92)*(1+'Input Data'!$C$90),5)","v":0.35700999999999999},null,null,null,{"$f":"(O4*SUM('Public Lighting Pricing'!C$53,'Public Lighting Pricing'!C$55)+O5*SUM('Public Lighting Pricing'!C$54,'Public Lighting Pricing'!C$56)+O7*SUM('Public Lighting Pricing'!C$60,'Public Lighting Pricing'!C$62)+O8*SUM('Public Lighting Pricing'!C$61,'Public Lighting Pricing'!C$63))*'Public Lighting Pricing'!C$116/10^6","v":41.217187083734238},{"$f":"(P4*'Public Lighting Pricing'!C$53+P5*'Public Lighting Pricing'!C$54+P7*'Public Lighting Pricing'!C$60+P8*'Public Lighting Pricing'!C$61)*'Public Lighting Pricing'!C$116/10^6","v":30.826666616254037},{"$f":"(Q4*'Public Lighting Pricing'!C$55+Q5*'Public Lighting Pricing'!C$56+Q7*'Public Lighting Pricing'!C$62+Q8*'Public Lighting Pricing'!C$63)*'Public Lighting Pricing'!C$116/10^6","v":1.2318345367849657},{"$f":"SUM(P10:Q10)","v":32.058501153039003},"Revenue",null,{"$f":"R10/O10-1","v":-0.22220550645751314},null,null,{"$f":"C10*'Public Lighting Pricing'!$C$116","v":118.28408999999999}]
["Minor",null,{"$f":"(C5-C8)*PLAB_NPL4+C8*0.9","v":0.19302900000000001},null,{"$f":"ROUND(C11*(1-'Input Data'!$C$92)*(1+'Input Data'!$C$90),5)","v":0.19775999999999999},null,{"$f":"ROUND(E11*(1-'Input Data'!$C$92)*(1+'Input Data'!$C$90),5)","v":0.2026},null,{"$f":"ROUND(G11*(1-'Input Data'!$C$92)*(1+'Input Data'!$C$90),5)","v":0.20755999999999999},null,{"$f":"ROUND(I11*(1-'Input Data'!$C$92)*(1+'Input Data'!$C$90),5)","v":0.21264},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"C11*'Public Lighting Pricing'!$C$116","v":70.455584999999999}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"O1","v":"2019-20"},{"$f":"P1","v":"2020-21"},null,null,"Price Movement"]
["Submission Model",{"$f":"B2","v":"Conventional"},{"$f":"C2","v":"LED"},"Conventional","LED","Conventional","LED","Conventional","LED","Conventional","LED",null,null,null,"All Lights","CON","LED","Average",{"$f":"P14","v":"CON"},{"$f":"Q14","v":"LED"},{"$f":"R14","v":"Average"},null,{"$f":"B14","v":"Conventional"},{"$f":"C14","v":"LED"}]
[{"$f":"A3","v":"NPL1 (Energex Owned & Operated)"}]
[{"$f":"A4","v":"Major"},0.61839999999999995,0.54454999999999998,0.63385999999999998,0.55815999999999999,0.64971000000000001,0.57211000000000001,0.66595000000000004,0.58640999999999999,0.68259999999999998,0.60106999999999999,null,{"$f":"C16/B16","v":0.88057891332470895},null,{"$f":"O4","v":0.86624337291703846},{"$f":"B16","v":0.61839999999999995},{"$f":"C16","v":0.54454999999999998},{"$f":"(B16*'Public Lighting Pricing'!C$53+C16*'Public Lighting Pricing'!C$55)/SUM('Public Lighting Pricing'!C$53,'Public Lighting Pricing'!C$55)","v":0.61491974393829629},{"$f":"P16/$O16-1","v":-0.28611286465885022},{"$f":"Q16/$O16-1","v":-0.37136604212480084},{"$f":"R16/$O16-1","v":-0.29013050701031085},null,{"$f":"B16*'Public Lighting Pricing'!$C$116","v":225.71599999999998},{"$f":"C16*'Public Lighting Pricing'!$C$116","v":198.76075}]
["Minor",0.37511,0.32756000000000002,0.38449,0.33574999999999999,0.39410000000000001,0.34414,0.40394999999999998,0.35274,0.41404999999999997,0.36155999999999999,null,{"$f":"C17/B17","v":0.8732371837594306},null,{"$f":"O5","v":0.39766203248884929},{"$f":"B17","v":0.37511},{"$f":"C17","v":0.32756000000000002},{"$f":"(B17*'Public Lighting Pricing'!C$54+C17*'Public Lighting Pricing'!C$56)/SUM('Public Lighting Pricing'!C$54,'Public Lighting Pricing'!C$56)","v":0.37302048370557572},{"$f":"P17/$O17-1","v":-5.671155565871544E-2},-0.17628545539060225,-6.1966058537319735E-2,null,{"$f":"B17*'Public Lighting Pricing'!$C$116","v":136.91515000000001},{"$f":"C17*'Public Lighting Pricing'!$C$116","v":119.55940000000001}]
["NPL2 (Gifted & Energex Operated)"]
["Major",0.31724000000000002,0.25717000000000001,0.32517000000000001,0.2636,0.33329999999999999,0.27018999999999999,0.34162999999999999,0.27694000000000002,0.35016999999999998,0.28386,null,{"$f":"C19/B19","v":0.81064808977430336},null,{"$f":"O7","v":0.30145844954504908},{"$f":"B19","v":0.31724000000000002},{"$f":"C19","v":0.25717000000000001},{"$f":"(B19*'Public Lighting Pricing'!C$60+C19*'Public Lighting Pricing'!C$62)/SUM('Public Lighting Pricing'!C$60,'Public Lighting Pricing'!C$62)","v":0.31293108193205971},{"$f":"P19/$O19-1","v":5.2350665502220783E-2},{"$f":"Q19/$O19-1","v":-0.14691394323790796},{"$f":"R19/$O19-1","v":3.8057093454586299E-2},null,{"$f":"B19*'Public Lighting Pricing'!$C$116","v":115.79260000000001},{"$f":"C19*'Public Lighting Pricing'!$C$116","v":93.867050000000006}]
["Minor",0.20777999999999999,0.16789000000000001,0.21296999999999999,0.17208999999999999,0.21829000000000001,0.17638999999999999,0.22375,0.18079999999999999,0.22933999999999999,0.18532000000000001,null,{"$f":"C20/B20","v":0.80801809606314379},null,0.14594988010704729,{"$f":"B20","v":0.20777999999999999},{"$f":"C20","v":0.16789000000000001},{"$f":"(B20*'Public Lighting Pricing'!C$61+C20*'Public Lighting Pricing'!C$63)/SUM('Public Lighting Pricing'!C$61,'Public Lighting Pricing'!C$63)","v":0.20501839953806861},{"$f":"P20/$O20-1","v":0.42363940174259307},0.1503263988765231,0.4047178345586675,null,{"$f":"B20*'Public Lighting Pricing'!$C$116","v":75.839699999999993},{"$f":"C20*'Public Lighting Pricing'!$C$116","v":61.279850000000003}]
["NPL4"]
["Major",null,0.54,null,0.55349999999999999,null,0.56733999999999996,null,0.58152000000000004,null,0.59606000000000003,null,null,null,{"$f":"(O16*SUM('Public Lighting Pricing'!C$53,'Public Lighting Pricing'!C$55)+O17*SUM('Public Lighting Pricing'!C$54,'Public Lighting Pricing'!C$56)+O19*SUM('Public Lighting Pricing'!C$60,'Public Lighting Pricing'!C$62)+O20*SUM('Public Lighting Pricing'!C$61,'Public Lighting Pricing'!C$63))*'Public Lighting Pricing'!C$116/10^6","v":41.217187083734238},{"$f":"(P16*'Public Lighting Pricing'!C$53+P17*'Public Lighting Pricing'!C$54+P19*'Public Lighting Pricing'!C$60+P20*'Public Lighting Pricing'!C$61)*'Public Lighting Pricing'!C$116/10^6","v":37.991949409926363},{"$f":"(Q16*'Public Lighting Pricing'!C$55+Q17*'Public Lighting Pricing'!C$56+Q19*'Public Lighting Pricing'!C$62+Q20*'Public Lighting Pricing'!C$63)*'Public Lighting Pricing'!C$116/10^6","v":1.8736922510712966},{"$f":"SUM(P22:Q22)","v":39.86564166099766},"Revenue",null,{"$f":"R22/O22-1","v":-3.279082145976786E-2},null,null,{"$f":"C22*'Public Lighting Pricing'!$C$116","v":197.10000000000002}]
["Minor",null,0.33,null,0.33825,null,0.34671000000000002,null,0.35537999999999997,null,0.36425999999999997,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"C23*'Public Lighting Pricing'!$C$116","v":120.45}]
[]
[]
["Difference $",{"$f":"B14","v":"Conventional"},{"$f":"C14","v":"LED"},"Conventional","LED","Conventional","LED","Conventional","LED","Conventional","LED"]
[{"$f":"A15","v":"NPL1 (Energex Owned & Operated)"}]
[{"$f":"A16","v":"Major"},{"$f":"B4-B16","v":7.5300000000000367E-3},{"$f":"C4-C16","v":-0.12167},7.4000000000000732E-3,-0.12491999999999998,7.2600000000000442E-3,-0.12825000000000003,7.1199999999999042E-3,-0.13167999999999996,6.9599999999999662E-3,-0.13519999999999999]
["Minor",{"$f":"B5-B17","v":-1.0290000000000021E-2},-7.8190000000000009E-2,-1.0730000000000017E-2,-8.0270000000000008E-2,-1.1190000000000033E-2,-8.2400000000000029E-2,-1.1659999999999948E-2,-8.4589999999999999E-2,-1.2149999999999994E-2,-8.6839999999999973E-2]
["NPL2 (Gifted & Energex Operated)"]
["Major",{"$f":"B7-B19","v":-0.14149000000000003},{"$f":"C7-C19","v":-0.11692},-0.14512000000000003,-0.11990999999999999,-0.14883999999999997,-0.12297999999999998,-0.15264999999999998,-0.12613000000000002,-0.15655999999999998,-0.12934999999999999]
["Minor",{"$f":"B8-B20","v":-9.305999999999999E-2},-7.554000000000001E-2,-9.5439999999999997E-2,-7.7479999999999993E-2,-9.7880000000000009E-2,-7.9459999999999989E-2,-0.1004,-8.1489999999999993E-2,-0.10296,-8.3580000000000015E-2]
["NPL4"]
["Major",null,{"$f":"C10-C22","v":-0.21593400000000007},null,-0.22148999999999996,null,{"$f":"G10-G22","v":-0.22719999999999996},null,{"$f":"I10-I22","v":-0.23305000000000003},null,{"$f":"K10-K22","v":-0.23905000000000004}]
["Minor",null,{"$f":"C11-C23","v":-0.13697100000000001},null,-0.14049,null,{"$f":"G11-G23","v":-0.14411000000000002},null,{"$f":"I11-I23","v":-0.14781999999999998},null,{"$f":"K11-K23","v":-0.15161999999999998}]
[]
[]
["Difference %",{"$f":"B26","v":"Conventional"},{"$f":"C26","v":"LED"},"Conventional","LED","Conventional","LED","Conventional","LED","Conventional","LED"]
[{"$f":"A27","v":"NPL1 (Energex Owned & Operated)"}]
[{"$f":"A28","v":"Major"},{"$f":"B28/B16","v":1.2176584734799543E-2},{"$f":"C28/C16","v":-0.22343219171793224},1.1674502256018795E-2,-0.22380679375089577,1.1174216188761207E-2,-0.22417017706385139,1.0691493355356864E-2,-0.2245527872989887,1.0196308233225851E-2,-0.2249322042357795]
["Minor",{"$f":"B29/B17","v":-2.7431953293700573E-2},-0.23870435950665528,-2.7907097713854762E-2,-0.23907669396872677,-2.8393808678000593E-2,-0.23943743825187433,-2.8864958534471963E-2,-0.23980835743040199,-2.9344282091534828E-2,-0.24018143599955741]
[{"$f":"A18","v":"NPL2 (Gifted & Energex Operated)"}]
[{"$f":"A19","v":"Major"},{"$f":"B31/B19","v":-0.44600302610011355},-0.45464089901621491,-0.4462896331149861,-0.45489377845220025,-0.44656465646564653,-0.45516118287131274,-0.44682844012528167,-0.45544161190149496,-0.44709712425393378,-0.45568237863735639]
["Minor",{"$f":"B32/B20","v":-0.44787756280681484},-0.44993745905056887,-0.44813823543222048,-0.45022953105932939,-0.44839433780750382,-0.45047905210045919,-0.4487150837988827,-0.45071902654867257,-0.4489404377779716,-0.45100366932872876]
[{"$f":"A21","v":"NPL4"}]
[{"$f":"A22","v":"Major"},null,{"$f":"C34/C22","v":-0.39987777777777789},null,-0.40016260162601619,null,{"$f":"G34/G22","v":-0.40046532943208651},null,{"$f":"I34/I22","v":-0.40076007703948274},null,{"$f":"K34/K22","v":-0.40105022984263333}]
["Minor",null,{"$f":"C35/C23","v":-0.41506363636363636},null,-0.41534368070953437,null,{"$f":"G35/G23","v":-0.4156499668310692},null,{"$f":"I35/I23","v":-0.41594912488040969},null,{"$f":"K35/K23","v":-0.41624114643386589}]