{"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","#",25772.380369178449,24015.264595976361,21637.785714317331,18772.527781023833,15443.971184516302]
["Minor Conventional","#",66186.187413448002,61596.280661974633,55446.292500497977,48106.417721930819,39608.881240400151]
["Major LED","#",169.61963082155185,2086.7354040236373,4634.2142856826686,7669.4722189761642,11178.0288154837]
["Minor LED","#",419.81258655199815,5164.7193380253648,11489.707499502027,19034.582278069185,27757.118759599849]
["Total","#",{"$f":"SUM(C6:C9)","v":92548.000000000015},{"$f":"SUM(D6:D9)","v":92862.999999999985},{"$f":"SUM(E6:E9)","v":93208},{"$f":"SUM(F6:F9)","v":93583},{"$f":"SUM(G6:G9)","v":93988}]
[]
["NPL2 (Gifted & Energex Operated)"]
["Major Conventional","#",15599.463781526436,14598.412792943118,13231.364480764183,11590.013464837451,9682.1883722674247]
["Minor Conventional","#",41292.968435847113,38593.601518617128,34975.575493550554,30666.424976095841,25695.910762964486]
["Major LED","#",119.53621847356165,1470.5872070568826,3187.6355192358169,5178.9865351625485,7436.8116277325735]
["Minor LED","#",291.03156415288851,3580.3984813828793,7788.4245064494362,12687.575023904159,18248.08923703551]
["Total","#",{"$f":"SUM(C13:C16)","v":57303},{"$f":"SUM(D13:D16)","v":58243.000000000007},{"$f":"SUM(E13:E16)","v":59182.999999999993},{"$f":"SUM(F13:F16)","v":60123},{"$f":"SUM(G13:G16)","v":61063}]
["Total Opening Lights","#",{"$f":"SUM(C10,C17)","v":149851},{"$f":"SUM(D10,D17)","v":151106},{"$f":"SUM(E10,E17)","v":152391},{"$f":"SUM(F10,F17)","v":153706},{"$f":"SUM(G10,G17)","v":155051}]
[]
["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","#",2086.7354040236373,2547.4788816590308,3035.2579332934956,3508.5565965075357,4009.8596759843308]
["Minor LED","#",5164.7193380253648,6324.9881614766618,7544.8747785671594,8722.5364815306639,10015.050283513712]
["Total","#",{"$f":"SUM(C23:C26)","v":7251.4547420490017},{"$f":"SUM(D23:D26)","v":8872.4670431356935},{"$f":"SUM(E23:E26)","v":10580.132711860655},{"$f":"SUM(F23:F26)","v":12231.0930780382},{"$f":"SUM(G23:G26)","v":14024.909959498043}]
[]
["NPL2 (Gifted & Energex Operated)"]
["Major Conventional","#",0,0,0,0,0]
["Minor Conventional","#",0,0,0,0,0]
["Major LED","#",1470.5872070568826,1717.0483121789346,1991.3510159267316,2257.8250925700249,2552.9093334020777]
["Minor LED","#",3580.3984813828793,4208.0260250665569,4899.1505174547228,5560.5142131313514,6334.9187896059102]
["Total","#",{"$f":"SUM(C30:C33)","v":5050.9856884397614},{"$f":"SUM(D30:D33)","v":5925.0743372454917},{"$f":"SUM(E30:E33)","v":6890.5015333814545},{"$f":"SUM(F30:F33)","v":7818.3393057013764},{"$f":"SUM(G30:G33)","v":8887.8281230079883}]
["Total Additions","#",{"$f":"SUM(C27,C34)","v":12302.440430488763},{"$f":"SUM(D27,D34)","v":14797.541380381186},{"$f":"SUM(E27,E34)","v":17470.634245242109},{"$f":"SUM(F27,F34)","v":20049.432383739579},{"$f":"SUM(G27,G34)","v":22912.738082506032}]
[]
["Public Lights Disposals by Type"]
[]
["NPL1 (Energex Owned & Operated)"]
["Major Conventional","#",1926.7354040236373,2377.4788816590308,2865.2579332934956,3328.5565965075357,3819.8596759843304]
["Minor Conventional","#",5009.7193380253639,6149.9881614766618,7339.8747785671603,8497.5364815306639,9770.0502835137122]
["Major LED","#",0,0,0,0,0]
["Minor LED","#",0,0,0,0,0]
["Total","#",{"$f":"SUM(C40:C43)","v":6936.4547420490017},{"$f":"SUM(D40:D43)","v":8527.4670431356935},{"$f":"SUM(E40:E43)","v":10205.132711860657},{"$f":"SUM(F40:F43)","v":11826.0930780382},{"$f":"SUM(G40:G43)","v":13589.909959498043}]
[]
["NPL2 (Gifted & Energex Operated)"]
["Major Conventional (SV)","#",1120.5872070568826,1367.0483121789343,1641.3510159267314,1907.8250925700249,2202.9093334020772]
["Minor Conventional (SV)","#",2990.3984813828793,3618.0260250665569,4309.1505174547228,4970.5142131313514,5744.9187896059102]
["Major LED","#",0,0,0,0,0]
["Minor LED","#",0,0,0,0,0]
["Total","#",{"$f":"SUM(C47:C50)","v":4110.9856884397614},{"$f":"SUM(D47:D50)","v":4985.0743372454908},{"$f":"SUM(E47:E50)","v":5950.5015333814545},{"$f":"SUM(F47:F50)","v":6878.3393057013764},{"$f":"SUM(G47:G50)","v":7947.8281230079874}]
["Total Disposals","#",{"$f":"SUM(C44,C51)","v":11047.440430488763},{"$f":"SUM(D44,D51)","v":13512.541380381184},{"$f":"SUM(E44,E51)","v":16155.634245242112},{"$f":"SUM(F44,F51)","v":18704.432383739579},{"$f":"SUM(G44,G51)","v":21537.738082506032}]
[]
["Closing Population Public Lights"]
[]
["NPL1 (Energex Owned & Operated)"]
["Major Conventional","#",{"$f":"C6+C23-C40","v":23845.64496515481},{"$f":"D6+D23-D40","v":21637.785714317331},18772.527781023837,15443.971184516296,11624.111508531973]
["Minor Conventional","#",{"$f":"C7+C24-C41","v":61176.468075422636},55446.29250049797,48106.417721930819,39608.881240400151,29838.830956886439]
["Major LED","#",{"$f":"C8+C25-C42","v":2256.355034845189},4634.2142856826686,7669.4722189761642,11178.0288154837,15187.888491468031]
["Minor LED","#",{"$f":"C9+C26-C43","v":5584.5319245773626},11489.707499502027,19034.582278069185,27757.118759599849,37772.169043113565]
["Total","#",{"$f":"SUM(C57:C60)","v":92862.999999999985},{"$f":"SUM(D57:D60)","v":93207.999999999985},{"$f":"SUM(E57:E60)","v":93583},{"$f":"SUM(F57:F60)","v":93988},{"$f":"SUM(G57:G60)","v":94423}]
[]
["NPL2 (Gifted & Energex Operated)"]
["Major Conventional","#",{"$f":"C13+C30-C47","v":14478.876574469554},{"$f":"D13+D30-D47","v":13231.364480764183},11590.013464837451,9682.1883722674265,7479.2790388653475]
["Minor Conventional","#",{"$f":"C14+C31-C48","v":38302.569954464234},34975.575493550568,30666.42497609583,25695.91076296449,19950.991973358578]
["Major LED","#",{"$f":"C15+C32-C49","v":1590.1234255304441},3187.6355192358169,5178.9865351625485,7436.8116277325735,9989.7209611346516]
["Minor LED","#",{"$f":"C16+C33-C50","v":3871.4300455357679},7788.4245064494362,12687.575023904159,18248.08923703551,24583.008026641422]
["Total","#",{"$f":"SUM(C64:C67)","v":58243},{"$f":"SUM(D64:D67)","v":59183.000000000007},{"$f":"SUM(E64:E67)","v":60122.999999999993},{"$f":"SUM(F64:F67)","v":61063},{"$f":"SUM(G64:G67)","v":62003}]
["Total Closing Lights","#",{"$f":"SUM(C61,C68)","v":151106},{"$f":"SUM(D61,D68)","v":152391},{"$f":"SUM(E61,E68)","v":153706},{"$f":"SUM(F61,F68)","v":155051},{"$f":"SUM(G61,G68)","v":156426}]
[]
["Public Lights Contributed Assets"]
[]
["Contributed Assets (Conventional)"]
["Gifted","$M Nominal",0.57602150860457679,0.58819053676805777,0.56300056005742216,0.57702737395720849,0.52711452348598997]
["Cash Contribution","$M Nominal",0,0,0,0,0]
["Total Contributed","$M Nominal",{"$f":"SUM(C74:C75)","v":0.57602150860457679},{"$f":"SUM(D74:D75)","v":0.58819053676805777},0.56300056005742216,0.57702737395720849,0.52711452348598997]
[]
["Contributed Assets (LED)"]
["Gifted","$M Nominal",7.0764773698959171,7.6824785068437142,8.3769485680772711,9.070130121845704,9.8751989679943009]
["Cash Contribution","$M Nominal",0,0,0,0,0]
["Total Contributed","$M Nominal",{"$f":"SUM(C79:C80)","v":7.0764773698959171},{"$f":"SUM(D79:D80)","v":7.6824785068437142},{"$f":"SUM(E79:E80)","v":8.3769485680772711},{"$f":"SUM(F79:F80)","v":9.070130121845704},{"$f":"SUM(G79:G80)","v":9.8751989679943009}]
[]
["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","%",9.3782684908022884E-2]
["Z factor LED","%",-0.46985280657464085]
[]
["% 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",11.23382631232597,10.56783719206433,9.5336587139213496,8.1959093858120173,6.505383686341613]
["O&M LED","$M Nominal",0.20899124214791492,0.39943213641772041,0.60318698133236748,0.8788825168490455,1.1988630973367396]
["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",0.7111409895457792,0.52065617836777534,0.38582571149575673,0.27141372806635516,0.16183268432942374]
["Total Benchmark Tax liability","$M Nominal",{"$f":"SUM(C10:C11)","v":0.7111409895457792},{"$f":"SUM(D10:D11)","v":0.52065617836777534},0.38582571149575673,0.27141372806635516,0.16183268432942374]
["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":0.7111409895457792},{"$f":"D$12*D14","v":0.52065617836777534},{"$f":"E$12*E14","v":0.38582571149575673},{"$f":"F$12*F14","v":0.27141372806635516},{"$f":"G$12*G14","v":0.16183268432942374}]
["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":0.7111409895457792},{"$f":"D$20*'Input Data'!D79/'Input Data'!D$81","v":0.52065617836777534},{"$f":"E$20*'Input Data'!E79/'Input Data'!E$81","v":0.38582571149575673},{"$f":"F$20*'Input Data'!F79/'Input Data'!F$81","v":0.27141372806635516},{"$f":"G$20*'Input Data'!G79/'Input Data'!G$81","v":0.16183268432942374}]
["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.4760681858822769},{"$f":"IF(D30=1,D6/SUM(D6,D31,D32),1)","v":0.46041560133229203},{"$f":"IF(E30=1,E6/SUM(E6,E31,E32),1)","v":0.4342256114158406},{"$f":"IF(F30=1,F6/SUM(F6,F31,F32),1)","v":0.39669588330085931},{"$f":"IF(G30=1,G6/SUM(G6,G31,G32),1)","v":0.34946458432617683}]
["Tax Liability allocated to opex - LED","%",{"$f":"IF(C30=1,C7/SUM(C7,C35,C36),1)","v":0.72483253395291602},{"$f":"IF(D30=1,D7/SUM(D7,D35,D36),1)","v":0.30382400460385534},{"$f":"IF(E30=1,E7/SUM(E7,E35,E36),1)","v":0.24303754896650964},{"$f":"IF(F30=1,F7/SUM(F7,F35,F36),1)","v":0.22889868679458228},{"$f":"IF(G30=1,G7/SUM(G7,G35,G36),1)","v":0.22459080342224361}]
["Total Opex Charge Conventional","$M Nominal",{"$f":"SUM(C6,C8,C16,SUM(C18,C19)*C25)","v":11.23382631232597},{"$f":"SUM(D6,D8,D16,SUM(D18,D19)*D25)","v":10.56783719206433},{"$f":"SUM(E6,E8,E16,SUM(E18,E19)*E25)","v":9.5336587139213496},{"$f":"SUM(F6,F8,F16,SUM(F18,F19)*F25)","v":8.1959093858120173},{"$f":"SUM(G6,G8,G16,SUM(G18,G19)*G25)","v":6.505383686341613}]
["Total Opex Charge LED","$M Nominal",{"$f":"SUM(C7,C9,C21,SUM(C23,C24)*C26)","v":0.72444936759816625},{"$f":"SUM(D7,D9,D21,SUM(D23,D24)*D26)","v":0.55761998155115711},{"$f":"SUM(E7,E9,E21,SUM(E23,E24)*E26)","v":0.69695711658255588},{"$f":"SUM(F7,F9,F21,SUM(F23,F24)*F26)","v":0.94100876278145607},{"$f":"SUM(G7,G9,G21,SUM(G23,G24)*G26)","v":1.2352092299302633}]
[]
["Capex Charge Conventional","NPL4 Switch",1,1,1,1,1]
["Return on capital","$M Nominal",5.2083235160137473,4.7829197036557352,4.3531098773103096,3.9146898179499452,3.4701953096934752]
["Return of capital","$M Nominal",7.1549453892430339,7.6020647755796666,8.0687735584720457,8.5498354788841713,8.6397084411311837]
["Total Capex Charge Conventional","$M Nominal",{"$f":"SUM(C31,C32,C17,SUM(C18,C19)*(1-C25))*C30","v":12.363268905256781},{"$f":"SUM(D31,D32,D17,SUM(D18,D19)*(1-D25))*D30","v":12.384984479235403},{"$f":"SUM(E31,E32,E17,SUM(E18,E19)*(1-E25))*E30","v":12.421883435782355},{"$f":"SUM(F31,F32,F17,SUM(F18,F19)*(1-F25))*F30","v":12.464525296834116},{"$f":"SUM(G31,G32,G17,SUM(G18,G19)*(1-G25))*G30","v":12.109903750824659}]
["Capex Charge LED"]
["Return on capital","$M Nominal",3.3423515768193857E-2,0.44963474381309487,0.899199591497712,1.3899404927053842,1.8993863820605652]
["Return of capital","$M Nominal",4.59156251148089E-2,0.46561573327276534,0.97948087480241008,1.5707906167035937,2.2397388935406912]
["Total Capex Charge LED","$M Nominal",{"$f":"SUM(C35,C36,C22,SUM(C23,C24)*(1-C26))*C30","v":0.27502200497853069},{"$f":"SUM(D35,D36,D22,SUM(D23,D24)*(1-D26))*D30","v":1.2777188103201989},{"$f":"SUM(E35,E36,E22,SUM(E23,E24)*(1-E26))*E30","v":2.1707360425456903},{"$f":"SUM(F35,F36,F22,SUM(F23,F24)*(1-F26))*F30","v":3.1700185915429224},{"$f":"SUM(G35,G36,G22,SUM(G23,G24)*(1-G26))*G30","v":4.2646118273371565}]
[]
["ARR for Conventional","$M Nominal",{"$f":"SUM(C27,C33)","v":23.597095217582751},{"$f":"SUM(D27,D33)","v":22.952821671299731},21.955542149703703,20.660434682646134,18.615287437166273]
["ARR for LED","$M Nominal",{"$f":"SUM(C28,C37)","v":0.99947137257669694},{"$f":"SUM(D28,D37)","v":1.835338791871356},2.8676931591282462,4.1110273543243787,5.49982105726742]
["ARR for Total","$M Nominal",{"$f":"SUM(C39:C40)","v":24.596566590159448},{"$f":"SUM(D39:D40)","v":24.788160463171085},24.823235308831951,24.771462036970512,24.115108494433692]
[]
["Opex and Capex Charge Components"]
["Opex Charge for Conventional Lights","$M Nominal",{"$f":"C27","v":11.23382631232597},{"$f":"D27","v":10.56783719206433},9.5336587139213496,8.1959093858120173,6.505383686341613]
["Opex Charge for LED","$M Nominal",{"$f":"C28","v":0.72444936759816625},{"$f":"D28","v":0.55761998155115711},0.69695711658255588,0.94100876278145607,1.2352092299302633]
["Capex Charge for Conventional Lights","$M Nominal",{"$f":"C33","v":12.363268905256781},{"$f":"D33","v":12.384984479235403},12.421883435782355,12.464525296834116,12.109903750824659]
["Capex Charge for LED","$M Nominal",{"$f":"C37","v":0.27502200497853069},{"$f":"D37","v":1.2777188103201989},2.1707360425456903,3.1700185915429224,4.2646118273371565]
[]
["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":24809.012667166629},{"$f":"SUM('Input Data'!D6,'Input Data'!D57)/2","v":22826.525155146846},{"$f":"SUM('Input Data'!E6,'Input Data'!E57)/2","v":20205.156747670582},{"$f":"SUM('Input Data'!F6,'Input Data'!F57)/2","v":17108.249482770065},{"$f":"SUM('Input Data'!G6,'Input Data'!G57)/2","v":13534.041346524136}]
["Minor Conventional","#",{"$f":"SUM('Input Data'!C7,'Input Data'!C58)/2","v":63681.327744435315},{"$f":"SUM('Input Data'!D7,'Input Data'!D58)/2","v":58521.286581236302},{"$f":"SUM('Input Data'!E7,'Input Data'!E58)/2","v":51776.355111214398},{"$f":"SUM('Input Data'!F7,'Input Data'!F58)/2","v":43857.649481165485},{"$f":"SUM('Input Data'!G7,'Input Data'!G58)/2","v":34723.856098643293}]
["Major LED","#",{"$f":"SUM('Input Data'!C8,'Input Data'!C59)/2","v":1212.9873328333704},{"$f":"SUM('Input Data'!D8,'Input Data'!D59)/2","v":3360.4748448531527},{"$f":"SUM('Input Data'!E8,'Input Data'!E59)/2","v":6151.8432523294159},{"$f":"SUM('Input Data'!F8,'Input Data'!F59)/2","v":9423.7505172299316},{"$f":"SUM('Input Data'!G8,'Input Data'!G59)/2","v":13182.958653475866}]
["Minor LED","#",{"$f":"SUM('Input Data'!C9,'Input Data'!C60)/2","v":3002.1722555646802},{"$f":"SUM('Input Data'!D9,'Input Data'!D60)/2","v":8327.2134187636948},{"$f":"SUM('Input Data'!E9,'Input Data'!E60)/2","v":15262.144888785606},{"$f":"SUM('Input Data'!F9,'Input Data'!F60)/2","v":23395.850518834515},{"$f":"SUM('Input Data'!G9,'Input Data'!G60)/2","v":32764.643901356707}]
["Total","#",{"$f":"SUM(C53:C56)","v":92705.499999999985},{"$f":"SUM(D53:D56)","v":93035.5},{"$f":"SUM(E53:E56)","v":93395.5},{"$f":"SUM(F53:F56)","v":93785.5},{"$f":"SUM(G53:G56)","v":94205.5}]
[]
["NPL2 (Gifted & Energex Operated)"]
["Major Conventional","#",{"$f":"SUM('Input Data'!C13,'Input Data'!C64)/2","v":15039.170177997996},{"$f":"SUM('Input Data'!D13,'Input Data'!D64)/2","v":13914.888636853651},{"$f":"SUM('Input Data'!E13,'Input Data'!E64)/2","v":12410.688972800817},{"$f":"SUM('Input Data'!F13,'Input Data'!F64)/2","v":10636.100918552438},{"$f":"SUM('Input Data'!G13,'Input Data'!G64)/2","v":8580.7337055663866}]
["Minor Conventional","#",{"$f":"SUM('Input Data'!C14,'Input Data'!C65)/2","v":39797.769195155677},{"$f":"SUM('Input Data'!D14,'Input Data'!D65)/2","v":36784.588506083848},{"$f":"SUM('Input Data'!E14,'Input Data'!E65)/2","v":32821.000234823194},{"$f":"SUM('Input Data'!F14,'Input Data'!F65)/2","v":28181.167869530167},{"$f":"SUM('Input Data'!G14,'Input Data'!G65)/2","v":22823.451368161532}]
["Major LED","#",{"$f":"SUM('Input Data'!C15,'Input Data'!C66)/2","v":854.82982200200286},{"$f":"SUM('Input Data'!D15,'Input Data'!D66)/2","v":2329.1113631463495},{"$f":"SUM('Input Data'!E15,'Input Data'!E66)/2","v":4183.3110271991827},{"$f":"SUM('Input Data'!F15,'Input Data'!F66)/2","v":6307.899081447561},{"$f":"SUM('Input Data'!G15,'Input Data'!G66)/2","v":8713.2662944336116}]
["Minor LED","#",{"$f":"SUM('Input Data'!C16,'Input Data'!C67)/2","v":2081.2308048443283},{"$f":"SUM('Input Data'!D16,'Input Data'!D67)/2","v":5684.4114939161573},{"$f":"SUM('Input Data'!E16,'Input Data'!E67)/2","v":10237.999765176797},{"$f":"SUM('Input Data'!F16,'Input Data'!F67)/2","v":15467.832130469835},{"$f":"SUM('Input Data'!G16,'Input Data'!G67)/2","v":21415.548631838465}]
["Total","#",{"$f":"SUM(C60:C63)","v":57773},{"$f":"SUM(D60:D63)","v":58713.000000000007},{"$f":"SUM(E60:E63)","v":59652.999999999993},{"$f":"SUM(F60:F63)","v":60593},{"$f":"SUM(G60:G63)","v":61532.999999999993}]
["Grand total","#",{"$f":"SUM(C57,C64)","v":150478.5},{"$f":"SUM(D57,D64)","v":151748.5},153048.5,154378.5,155738.5]
[]
["Average No of Lights by Type"]
["Major Conventional","#",{"$f":"SUM(C53,C60)","v":39848.182845164629},{"$f":"SUM(D53,D60)","v":36741.413792000501},32615.8457204714,27744.350401322503,22114.775052090525]
["Minor Conventional","#",{"$f":"SUM(C54,C61)","v":103479.09693959099},95305.87508732015,84597.355346037599,72038.817350695652,57547.307466804821]
["Major LED","#",{"$f":"SUM(C55,C62)","v":2067.817154835373},5689.5862079995022,10335.154279528599,15731.649598677493,21896.224947909475]
["Minor LED","#",{"$f":"SUM(C56,C63)","v":5083.4030604090085},14011.624912679852,25500.144653962401,38863.682649304348,54180.192533195172]
["Total","#",{"$f":"SUM(C68:C71)","v":150478.5},{"$f":"SUM(D68:D71)","v":151748.50000000003},{"$f":"SUM(E68:E71)","v":153048.5},{"$f":"SUM(F68:F71)","v":154378.5},{"$f":"SUM(G68:G71)","v":155738.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":103.21958917629927},{"$f":"D44*10^6/(D68+D69/'Input Data'!$C$86)","v":105.38470285014458},{"$f":"E44*10^6/(E68+E69/'Input Data'!$C$86)","v":107.10281377445469},{"$f":"F44*10^6/(F68+F69/'Input Data'!$C$86)","v":108.16793790184241},{"$f":"G44*10^6/(G68+G69/'Input Data'!$C$86)","v":107.56318929859779}]
["Minor Conventional","$/day/light Nominal",{"$f":"C78/'Input Data'!$C$86","v":68.813059450866177},{"$f":"D78/'Input Data'!$C$86","v":70.256468566763047},{"$f":"E78/'Input Data'!$C$86","v":71.401875849636454},{"$f":"F78/'Input Data'!$C$86","v":72.111958601228267},{"$f":"G78/'Input Data'!$C$86","v":71.708792865731866}]
["Major LED","$/day/light Nominal",{"$f":"C45*10^6/(C70+C71/'Input Data'!$C$86)","v":132.7619978773514},{"$f":"D45*10^6/(D70+D71/'Input Data'!$C$86)","v":37.098812010829398},{"$f":"E45*10^6/(E70+E71/'Input Data'!$C$86)","v":25.496642552733853},{"$f":"F45*10^6/(F70+F71/'Input Data'!$C$86)","v":22.598254833845321},{"$f":"G45*10^6/(G70+G71/'Input Data'!$C$86)","v":21.290707871127971}]
["Minor LED","$/day/light Nominal",{"$f":"C80/'Input Data'!$C$86","v":88.507998584900932},{"$f":"D80/'Input Data'!$C$86","v":24.732541340552931},{"$f":"E80/'Input Data'!$C$86","v":16.997761701822569},{"$f":"F80/'Input Data'!$C$86","v":15.065503222563548},{"$f":"G80/'Input Data'!$C$86","v":14.193805247418647}]
[]
["NPL2 (Gifted & Energex Operated)"]
["Major Conventional","$/day/light Nominal",{"$f":"C78","v":103.21958917629927},{"$f":"D78","v":105.38470285014458},107.10281377445469,108.16793790184241,107.56318929859779]
["Minor Conventional","$/day/light Nominal",{"$f":"C79","v":68.813059450866177},70.256468566763047,71.401875849636454,72.111958601228267,71.708792865731866]
["Major LED","$/day/light Nominal",{"$f":"C80","v":132.7619978773514},37.098812010829398,25.496642552733853,22.598254833845321,21.290707871127971]
["Minor LED","$/day/light Nominal",{"$f":"C81","v":88.507998584900932},24.732541340552931,16.997761701822569,15.065503222563548,14.193805247418647]
[]
["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":184.87122448033202},{"$f":"D46*10^6/(D53+D54/'Input Data'!$C$87)*(1-'Input Data'!$C$84)","v":201.42425321892406},{"$f":"E46*10^6/(E53+E54/'Input Data'!$C$87)*(1-'Input Data'!$C$84)","v":228.29775576175143},{"$f":"F46*10^6/(F53+F54/'Input Data'!$C$87)*(1-'Input Data'!$C$84)","v":270.48700811140185},{"$f":"G46*10^6/(G53+G54/'Input Data'!$C$87)*(1-'Input Data'!$C$84)","v":332.03013859642527}]
["Minor Conventional","$/day/light Nominal",{"$f":"C91/'Input Data'!$C$87","v":102.70623582240667},{"$f":"D91/'Input Data'!$C$87","v":111.90236289940225},{"$f":"E91/'Input Data'!$C$87","v":126.83208653430634},{"$f":"F91/'Input Data'!$C$87","v":150.27056006188991},{"$f":"G91/'Input Data'!$C$87","v":184.46118810912515}]
["Major LED","$/day/light Nominal",{"$f":"C47*10^6/(C55+C56/'Input Data'!$C$87)*(1-'Input Data'!$C$84)","v":85.918696169107164},{"$f":"D47*10^6/(D55+D56/'Input Data'!$C$87)*(1-'Input Data'!$C$84)","v":143.98265594133474},{"$f":"E47*10^6/(E55+E56/'Input Data'!$C$87)*(1-'Input Data'!$C$84)","v":133.53068534410303},{"$f":"F47*10^6/(F55+F56/'Input Data'!$C$87)*(1-'Input Data'!$C$84)","v":127.24499694770336},{"$f":"G47*10^6/(G55+G56/'Input Data'!$C$87)*(1-'Input Data'!$C$84)","v":122.29041832551484}]
["Minor LED","$/day/light Nominal",{"$f":"C93/'Input Data'!$C$87","v":47.732608982837313},{"$f":"D93/'Input Data'!$C$87","v":79.990364411852639},{"$f":"E93/'Input Data'!$C$87","v":74.183714080057243},{"$f":"F93/'Input Data'!$C$87","v":70.691664970946306},{"$f":"G93/'Input Data'!$C$87","v":67.939121291952688}]
[]
["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":12.701566226301496},{"$f":"D46*10^6/(D68+D69/'Input Data'!$C$87)*'Input Data'!$C$84","v":13.808792169054241},{"$f":"E46*10^6/(E68+E69/'Input Data'!$C$87)*'Input Data'!$C$84","v":15.602563238981142},{"$f":"F46*10^6/(F68+F69/'Input Data'!$C$87)*'Input Data'!$C$84","v":18.393502378268817},{"$f":"G46*10^6/(G68+G69/'Input Data'!$C$87)*'Input Data'!$C$84","v":22.390295795202544}]
["Minor Conventional","$/day/light Nominal",{"$f":"C104/'Input Data'!$C$87","v":7.0564256812786086},{"$f":"D104/'Input Data'!$C$87","v":7.6715512050301342},{"$f":"E104/'Input Data'!$C$87","v":8.6680906883228559},{"$f":"F104/'Input Data'!$C$87","v":10.218612432371565},{"$f":"G104/'Input Data'!$C$87","v":12.439053219556968}]
["Major LED","$/day/light Nominal",{"$f":"C47*10^6/(C70+C71/'Input Data'!$C$87)*'Input Data'!$C$84","v":5.6219530304037209},{"$f":"D47*10^6/(D70+D71/'Input Data'!$C$87)*'Input Data'!$C$84","v":9.4829721266863345},{"$f":"E47*10^6/(E70+E71/'Input Data'!$C$87)*'Input Data'!$C$84","v":8.859459578768929},{"$f":"F47*10^6/(F70+F71/'Input Data'!$C$87)*'Input Data'!$C$84","v":8.4935666759888448},{"$f":"G47*10^6/(G70+G71/'Input Data'!$C$87)*'Input Data'!$C$84","v":8.2017551442926315}]
["Minor LED","$/day/light Nominal",{"$f":"C106/'Input Data'!$C$87","v":3.1233072391131782},{"$f":"D106/'Input Data'!$C$87","v":5.2683178481590742},{"$f":"E106/'Input Data'!$C$87","v":4.9219219882049607},{"$f":"F106/'Input Data'!$C$87","v":4.7186481533271358},{"$f":"G106/'Input Data'!$C$87","v":4.5565306357181283}]
[]
["NPL2 (Gifted & Energex Operated)"]
["Major Conventional","$/day/light Nominal",{"$f":"C104","v":12.701566226301496},{"$f":"D104","v":13.808792169054241},15.602563238981142,18.393502378268817,22.390295795202544]
["Minor Conventional","$/day/light Nominal",{"$f":"C105","v":7.0564256812786086},7.6715512050301342,8.6680906883228559,10.218612432371565,12.439053219556968]
["Major LED","$/day/light Nominal",{"$f":"C106","v":5.6219530304037209},9.4829721266863345,8.859459578768929,8.4935666759888448,8.2017551442926315]
["Minor LED","$/day/light Nominal",{"$f":"C107","v":3.1233072391131782},5.2683178481590742,4.9219219882049607,4.7186481533271358,4.5565306357181283]
[]
[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.82408871200803502},{"$f":"SUM(D78,D91,D104)/D$116","v":0.87840478969348734},0.96165241856215689,1.0848318262063199,1.2657085580554126]
["Minor Conventional","$/day/light Nominal",{"$f":"SUM(C79,C92,C105)/C$116","v":0.48924855056041494},{"$f":"SUM(D79,D92,D105)/D$116","v":0.52008324019505592},0.56685493992401548,0.6355222161078955,0.73591516217647668]
["Major LED","$/day/light Nominal",{"$f":"SUM(C80,C93,C106)/C$116","v":0.61452780021058162},0.52209435638041224,0.45996380130302961,0.43261425808070358,0.41584351052311075]
["Minor LED","$/day/light Nominal",{"$f":"SUM(C81,C94,C107)/C$116","v":0.38181894467630528},0.30134581808373873,0.26329698019201309,0.24720168400775136,0.23750536212353279]
[]
["NPL2 (Gifted & Energex Operated)"]
["Major Conventional","$/day/light Nominal",{"$f":"SUM(C84,C97,C110)/C$116","v":0.31759220658246784},{"$f":"SUM(D84,D97,D110)/D$116","v":0.32655752060054472},0.33617911510530368,0.34579628491833669,0.35603694546246667]
["Minor Conventional","$/day/light Nominal",{"$f":"SUM(C85,C98,C111)/C$116","v":0.20786160310176655},0.21350142403231007,0.21936977133687485,0.22494691539234923,0.23054204406928447]
["Major LED","$/day/light Nominal",{"$f":"SUM(C86,C99,C112)/C$116","v":0.37913411207604142},0.12762132640415269,9.4126307209596652E-2,8.4950331994082418E-2,8.0801268535398915E-2]
["Minor LED","$/day/light Nominal",{"$f":"SUM(C87,C100,C113)/C$116","v":0.25104467349044962},8.2194134763594537E-2,6.0053927917883644E-2,5.4055058404072903E-2,5.1370783241470611E-2]
[]
["Smoothed Prices"]
[]
["NPL1 (Energex Owned & Operated)"]
["Major Conventional","$/day/light Nominal",{"$f":"C122*(1+'Input Data'!$C$93)","v":0.90137396402254288},{"$f":"C136*(1-'Input Data'!$C$92)*(1+'Input Data'!$C$90)","v":0.92345663376094334},{"$f":"D136*(1-'Input Data'!$C$92)*(1+'Input Data'!$C$90)","v":0.94608030459571346},{"$f":"E136*(1-'Input Data'!$C$92)*(1+'Input Data'!$C$90)","v":0.96925823045809167},{"$f":"F136*(1-'Input Data'!$C$92)*(1+'Input Data'!$C$90)","v":0.99300398998603956}]
["Minor Conventional","$/day/light Nominal",{"$f":"C123*(1+'Input Data'!$C$93)","v":0.53513159321932924},{"$f":"C137*(1-'Input Data'!$C$92)*(1+'Input Data'!$C$90)","v":0.54824172809266247},{"$f":"D137*(1-'Input Data'!$C$92)*(1+'Input Data'!$C$90)","v":0.56167304683660768},{"$f":"E137*(1-'Input Data'!$C$92)*(1+'Input Data'!$C$90)","v":0.57543341810238313},{"$f":"F137*(1-'Input Data'!$C$92)*(1+'Input Data'!$C$90)","v":0.58953090331449876}]
["Major LED","$/day/light Nominal",{"$f":"C124*(1+'Input Data'!$C$94)","v":0.32579018856349973},{"$f":"C138*(1-'Input Data'!$C$92)*(1+'Input Data'!$C$90)","v":0.3337716895000844},{"$f":"D138*(1-'Input Data'!$C$92)*(1+'Input Data'!$C$90)","v":0.34194872842227142},{"$f":"E138*(1-'Input Data'!$C$92)*(1+'Input Data'!$C$90)","v":0.35032609579542773},{"$f":"F138*(1-'Input Data'!$C$92)*(1+'Input Data'!$C$90)","v":0.3589086994460477}]
["Minor LED","$/day/light Nominal",{"$f":"C125*(1+'Input Data'!$C$94)","v":0.20242024191677574},{"$f":"C139*(1-'Input Data'!$C$92)*(1+'Input Data'!$C$90)","v":0.20737931498636741},{"$f":"D139*(1-'Input Data'!$C$92)*(1+'Input Data'!$C$90)","v":0.21245987988640389},{"$f":"E139*(1-'Input Data'!$C$92)*(1+'Input Data'!$C$90)","v":0.21766491303297295},{"$f":"F139*(1-'Input Data'!$C$92)*(1+'Input Data'!$C$90)","v":0.22299746376107962}]
[]
["NPL2 (Gifted & Energex Operated)"]
["Major Conventional","$/day/light Nominal",{"$f":"C128*(1+'Input Data'!$C$93)","v":0.34737685642163507},{"$f":"C142*(1-'Input Data'!$C$92)*(1+'Input Data'!$C$90)","v":0.35588720695460307},{"$f":"D142*(1-'Input Data'!$C$92)*(1+'Input Data'!$C$90)","v":0.36460605170604049},{"$f":"E142*(1-'Input Data'!$C$92)*(1+'Input Data'!$C$90)","v":0.37353849855475518},{"$f":"F142*(1-'Input Data'!$C$92)*(1+'Input Data'!$C$90)","v":0.38268978051696234}]
["Minor Conventional","$/day/light Nominal",{"$f":"C129*(1+'Input Data'!$C$93)","v":0.227355422329936},{"$f":"C143*(1-'Input Data'!$C$92)*(1+'Input Data'!$C$90)","v":0.2329253798669178},{"$f":"D143*(1-'Input Data'!$C$92)*(1+'Input Data'!$C$90)","v":0.23863179523123376},{"$f":"E143*(1-'Input Data'!$C$92)*(1+'Input Data'!$C$90)","v":0.24447801148941842},{"$f":"F143*(1-'Input Data'!$C$92)*(1+'Input Data'!$C$90)","v":0.25046745360945583}]
["Major LED","$/day/light Nominal",{"$f":"C130*(1+'Input Data'!$C$94)","v":0.20099688544892894},{"$f":"C144*(1-'Input Data'!$C$92)*(1+'Input Data'!$C$90)","v":0.20592108785212238},{"$f":"D144*(1-'Input Data'!$C$92)*(1+'Input Data'!$C$90)","v":0.21096592779282522},{"$f":"E144*(1-'Input Data'!$C$92)*(1+'Input Data'!$C$90)","v":0.21613436075788886},{"$f":"F144*(1-'Input Data'!$C$92)*(1+'Input Data'!$C$90)","v":0.22142941464033869}]
["Minor LED","$/day/light Nominal",{"$f":"C131*(1+'Input Data'!$C$94)","v":0.13309062907534755},{"$f":"C145*(1-'Input Data'!$C$92)*(1+'Input Data'!$C$90)","v":0.13635120295972186},{"$f":"D145*(1-'Input Data'!$C$92)*(1+'Input Data'!$C$90)","v":0.13969165731448938},{"$f":"E145*(1-'Input Data'!$C$92)*(1+'Input Data'!$C$90)","v":0.14311394912322919},{"$f":"F145*(1-'Input Data'!$C$92)*(1+'Input Data'!$C$90)","v":0.14662008331346357}]
[]
["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":25.810094163117927},{"$f":"(SUMPRODUCT(D136:D137,D53:D54)+SUMPRODUCT(D142:D143,D60:D61))*D116/10^6","v":24.339409051117975},{"$f":"(SUMPRODUCT(E136:E137,E53:E54)+SUMPRODUCT(E142:E143,E60:E61))*E116/10^6","v":22.102294129687849},{"$f":"(SUMPRODUCT(F136:F137,F53:F54)+SUMPRODUCT(F142:F143,F60:F61))*F116/10^6","v":19.281662442329974},{"$f":"(SUMPRODUCT(G136:G137,G53:G54)+SUMPRODUCT(G142:G143,G60:G61))*G116/10^6","v":15.662308466703008}]
["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":94.516973407312449}]
["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":94.516973407312435}]
["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":0.5298669430805274},{"$f":"(SUMPRODUCT(D138:D139,D55:D56)+SUMPRODUCT(D144:D145,D62:D63))*D116/10^6","v":1.4976726252650521},{"$f":"(SUMPRODUCT(E138:E139,E55:E56)+SUMPRODUCT(E144:E145,E62:E63))*E116/10^6","v":2.7955013084375273},{"$f":"(SUMPRODUCT(F138:F139,F55:F56)+SUMPRODUCT(F144:F145,F62:F63))*F116/10^6","v":4.3813339442689019},{"$f":"(SUMPRODUCT(G138:G139,G55:G56)+SUMPRODUCT(G144:G145,G62:G63))*G116/10^6","v":6.2441404158374558}]
["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":12.921087553936697}]
["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":12.921087553936692}]
["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":23.597095217582755},{"$f":"(SUMPRODUCT(D122:D123,D53:D54)+SUMPRODUCT(D128:D129,D60:D61))*D116/10^6","v":22.952821671299731},{"$f":"(SUMPRODUCT(E122:E123,E53:E54)+SUMPRODUCT(E128:E129,E60:E61))*E116/10^6","v":21.955542149703703},{"$f":"(SUMPRODUCT(F122:F123,F53:F54)+SUMPRODUCT(F128:F129,F60:F61))*F116/10^6","v":20.660434682646137},{"$f":"(SUMPRODUCT(G122:G123,G53:G54)+SUMPRODUCT(G128:G129,G60:G61))*G116/10^6","v":18.61528743716627}]
["Revenue requirement - Conventional",null,{"$f":"C39","v":23.597095217582751},{"$f":"D39","v":22.952821671299731},21.955542149703703,20.660434682646134,18.615287437166273]
["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":0.99947137257669694},{"$f":"(SUMPRODUCT(D124:D125,D55:D56)+SUMPRODUCT(D130:D131,D62:D63))*D116/10^6","v":1.835338791871356},{"$f":"(SUMPRODUCT(E124:E125,E55:E56)+SUMPRODUCT(E130:E131,E62:E63))*E116/10^6","v":2.8676931591282457},{"$f":"(SUMPRODUCT(F124:F125,F55:F56)+SUMPRODUCT(F130:F131,F62:F63))*F116/10^6","v":4.1110273543243787},{"$f":"(SUMPRODUCT(G124:G125,G55:G56)+SUMPRODUCT(G130:G131,G62:G63))*G116/10^6","v":5.49982105726742}]
["Revenue requirement - LED",null,{"$f":"C40","v":0.99947137257669694},{"$f":"D40","v":1.835338791871356},2.8676931591282462,4.1110273543243787,5.49982105726742]
["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":[[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],[2,1,2,2],[2,3,2,4],[2,5,2,6],[2,7,2,8],[2,9,2,10],[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],[5,1,5,2],[5,3,5,4],[5,5,5,6],[5,7,5,8],[5,9,5,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],[32,1,32,2],[32,3,32,4],[32,5,32,6],[32,7,32,8],[32,9,32,10],[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],[33,1,34,1],[33,3,34,3],[33,5,34,5],[33,7,34,7],[33,9,34,9],[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],[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],[45,1,46,1],[45,3,46,3],[45,5,46,5],[45,7,46,7],[45,9,46,9],[44,1,44,2],[44,3,44,4],[44,5,44,6],[44,7,44,8],[44,9,44,10]]}
["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.90137},{"$f":"ROUND('Public Lighting Pricing'!C138,5)","v":0.32579000000000002},{"$f":"ROUND('Public Lighting Pricing'!D136,5)","v":0.92345999999999995},{"$f":"ROUND('Public Lighting Pricing'!D138,5)","v":0.33377000000000001},{"$f":"ROUND('Public Lighting Pricing'!E136,5)","v":0.94608000000000003},{"$f":"ROUND('Public Lighting Pricing'!E138,5)","v":0.34194999999999998},{"$f":"ROUND('Public Lighting Pricing'!F136,5)","v":0.96926000000000001},{"$f":"ROUND('Public Lighting Pricing'!F138,5)","v":0.35032999999999997},{"$f":"ROUND('Public Lighting Pricing'!G136,5)","v":0.99299999999999999},{"$f":"ROUND('Public Lighting Pricing'!G138,5)","v":0.35891000000000001},null,{"$f":"C4/B4","v":0.3614386988694987},null,1.30966027082248,{"$f":"B4","v":0.90137},{"$f":"C4","v":0.32579000000000002},{"$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.87453996199245909},{"$f":"P4/$O4-1","v":-0.31175281095307994},{"$f":"Q4/$O4-1","v":-0.75124083149029131},-0.33223906880580634,null,{"$f":"B4*'Public Lighting Pricing'!$C$116","v":329.00004999999999},{"$f":"C4*'Public Lighting Pricing'!$C$116","v":118.91335000000001}]
["Minor",{"$f":"ROUND('Public Lighting Pricing'!C137,5)","v":0.53512999999999999},{"$f":"ROUND('Public Lighting Pricing'!C139,5)","v":0.20241999999999999},{"$f":"ROUND('Public Lighting Pricing'!D137,5)","v":0.54823999999999995},{"$f":"ROUND('Public Lighting Pricing'!D139,5)","v":0.20738000000000001},{"$f":"ROUND('Public Lighting Pricing'!E137,5)","v":0.56167},{"$f":"ROUND('Public Lighting Pricing'!E139,5)","v":0.21246000000000001},{"$f":"ROUND('Public Lighting Pricing'!F137,5)","v":0.57543},{"$f":"ROUND('Public Lighting Pricing'!F139,5)","v":0.21765999999999999},{"$f":"ROUND('Public Lighting Pricing'!G137,5)","v":0.58953},{"$f":"ROUND('Public Lighting Pricing'!G139,5)","v":0.223},null,{"$f":"C5/B5","v":0.37826322575822696},null,0.78027904865298836,{"$f":"B5","v":0.53512999999999999},{"$f":"C5","v":0.20241999999999999},{"$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.52015099123247988},{"$f":"P5/$O5-1","v":-0.31418125230479299},{"$f":"Q5/$O5-1","v":-0.74057998821134341},{"$f":"R5/$O5-1","v":-0.3333782418861212},null,{"$f":"B5*'Public Lighting Pricing'!$C$116","v":195.32245},{"$f":"C5*'Public Lighting Pricing'!$C$116","v":73.883299999999991}]
["NPL2 (Gifted & Energex Operated)"]
["Major",{"$f":"ROUND('Public Lighting Pricing'!C142,5)","v":0.34738000000000002},{"$f":"ROUND('Public Lighting Pricing'!C144,5)","v":0.20100000000000001},{"$f":"ROUND('Public Lighting Pricing'!D142,5)","v":0.35588999999999998},{"$f":"ROUND('Public Lighting Pricing'!D144,5)","v":0.20591999999999999},{"$f":"ROUND('Public Lighting Pricing'!E142,5)","v":0.36460999999999999},{"$f":"ROUND('Public Lighting Pricing'!E144,5)","v":0.21096999999999999},{"$f":"ROUND('Public Lighting Pricing'!F142,5)","v":0.37353999999999998},{"$f":"ROUND('Public Lighting Pricing'!F144,5)","v":0.21612999999999999},{"$f":"ROUND('Public Lighting Pricing'!G142,5)","v":0.38268999999999997},{"$f":"ROUND('Public Lighting Pricing'!G144,5)","v":0.22142999999999999},null,{"$f":"C7/B7","v":0.57861707640048365},null,0.52887057530419268,{"$f":"B7","v":0.34738000000000002},{"$f":"C7","v":0.20100000000000001},{"$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.33950721848844517},{"$f":"P7/$O7-1","v":-0.34316633176236733},{"$f":"Q7/$O7-1","v":-0.61994482320293587},{"$f":"R7/$O7-1","v":-0.35805235847509687},null,{"$f":"B7*'Public Lighting Pricing'!$C$116","v":126.7937},{"$f":"C7*'Public Lighting Pricing'!$C$116","v":73.365000000000009}]
["Minor",{"$f":"ROUND('Public Lighting Pricing'!C143,5)","v":0.22736000000000001},{"$f":"ROUND('Public Lighting Pricing'!C145,5)","v":0.13309000000000001},{"$f":"ROUND('Public Lighting Pricing'!D143,5)","v":0.23293},{"$f":"ROUND('Public Lighting Pricing'!D145,5)","v":0.13635},{"$f":"ROUND('Public Lighting Pricing'!E143,5)","v":0.23863000000000001},{"$f":"ROUND('Public Lighting Pricing'!E145,5)","v":0.13969000000000001},{"$f":"ROUND('Public Lighting Pricing'!F143,5)","v":0.24448},{"$f":"ROUND('Public Lighting Pricing'!F145,5)","v":0.14310999999999999},{"$f":"ROUND('Public Lighting Pricing'!G143,5)","v":0.25047000000000003},{"$f":"ROUND('Public Lighting Pricing'!G145,5)","v":0.14662},null,{"$f":"C8/B8","v":0.58537121745249832},null,0.34645262115254238,{"$f":"B8","v":0.22736000000000001},{"$f":"C8","v":0.13309000000000001},{"$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.22267513102097292},{"$f":"P8/$O8-1","v":-0.34374865098828666},-0.61584934887416898,-0.35727104537353316,null,{"$f":"B8*'Public Lighting Pricing'!$C$116","v":82.986400000000003},{"$f":"C8*'Public Lighting Pricing'!$C$116","v":48.577850000000005}]
["NPL4"]
["Major",null,{"$f":"(C4-C7)*PLAB_NPL4+C7*0.9","v":0.26825300000000002},null,{"$f":"ROUND(C10*(1-'Input Data'!$C$92)*(1+'Input Data'!$C$90),5)","v":0.27482000000000001},null,{"$f":"ROUND(E10*(1-'Input Data'!$C$92)*(1+'Input Data'!$C$90),5)","v":0.28155000000000002},null,{"$f":"ROUND(G10*(1-'Input Data'!$C$92)*(1+'Input Data'!$C$90),5)","v":0.28844999999999998},null,{"$f":"ROUND(I10*(1-'Input Data'!$C$92)*(1+'Input Data'!$C$90),5)","v":0.29552},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":39.794736649964101},{"$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":25.810104987579425},{"$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":0.52986708840862706},{"$f":"SUM(P10:Q10)","v":26.339972075988051},"Revenue",null,{"$f":"R10/O10-1","v":-0.33810412397811873},null,null,{"$f":"C10*'Public Lighting Pricing'!$C$116","v":97.912345000000002}]
["Minor",null,{"$f":"(C5-C8)*PLAB_NPL4+C8*0.9","v":0.16831199999999999},null,{"$f":"ROUND(C11*(1-'Input Data'!$C$92)*(1+'Input Data'!$C$90),5)","v":0.17244000000000001},null,{"$f":"ROUND(E11*(1-'Input Data'!$C$92)*(1+'Input Data'!$C$90),5)","v":0.17666000000000001},null,{"$f":"ROUND(G11*(1-'Input Data'!$C$92)*(1+'Input Data'!$C$90),5)","v":0.18099000000000001},null,{"$f":"ROUND(I11*(1-'Input Data'!$C$92)*(1+'Input Data'!$C$90),5)","v":0.18542},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"C11*'Public Lighting Pricing'!$C$116","v":61.433879999999995}]
[]
[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.77964,0.81542000000000003,0.79913000000000001,0.83581000000000005,0.81911,0.85670999999999997,0.83958999999999995,0.87812999999999997,0.86058000000000001,0.90007999999999999,null,{"$f":"C16/B16","v":1.0458929762454467},null,{"$f":"O4","v":1.30966027082248},{"$f":"B16","v":0.77964},{"$f":"C16","v":0.81542000000000003},{"$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.7813078459291668},{"$f":"P16/$O16-1","v":-0.40470057970806572},{"$f":"Q16/$O16-1","v":-0.37738051755367985},{"$f":"R16/$O16-1","v":-0.40342708461447219},null,{"$f":"B16*'Public Lighting Pricing'!$C$116","v":284.5686},{"$f":"C16*'Public Lighting Pricing'!$C$116","v":297.62830000000002}]
["Minor",0.47888999999999998,0.49221999999999999,0.49086000000000002,0.50453000000000003,0.50312999999999997,0.51714000000000004,0.51571,0.53007000000000004,0.52859999999999996,0.54332000000000003,null,{"$f":"C17/B17","v":1.02783520223851},null,{"$f":"O5","v":0.78027904865298836},{"$f":"B17","v":0.47888999999999998},{"$f":"C17","v":0.49221999999999999},{"$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.47949013280896591},{"$f":"P17/$O17-1","v":-0.38625803060236263},-0.36917439876191804,-0.38548890472361197,null,{"$f":"B17*'Public Lighting Pricing'!$C$116","v":174.79485},{"$f":"C17*'Public Lighting Pricing'!$C$116","v":179.66030000000001}]
["NPL2 (Gifted & Energex Operated)"]
["Major",0.44861000000000001,0.39917999999999998,0.45983000000000002,0.40916000000000002,0.47133000000000003,0.41938999999999999,0.48310999999999998,0.42986999999999997,0.49519000000000002,0.44062000000000001,null,{"$f":"C19/B19","v":0.88981520697264882},null,{"$f":"O7","v":0.52887057530419268},{"$f":"B19","v":0.44861000000000001},{"$f":"C19","v":0.39917999999999998},{"$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.44595149753985408},{"$f":"P19/$O19-1","v":-0.15175844346800516},{"$f":"Q19/$O19-1","v":-0.24522176381168126},{"$f":"R19/$O19-1","v":-0.15678519780883193},null,{"$f":"B19*'Public Lighting Pricing'!$C$116","v":163.74265},{"$f":"C19*'Public Lighting Pricing'!$C$116","v":145.70069999999998}]
["Minor",0.29499999999999998,0.26096999999999998,0.30237999999999998,0.26749000000000001,0.30993999999999999,0.27417999999999998,0.31768999999999997,0.28103,0.32562999999999998,0.28805999999999998,null,{"$f":"C20/B20","v":0.8846440677966102},null,0.34645262115254238,{"$f":"B20","v":0.29499999999999998},{"$f":"C20","v":0.26096999999999998},{"$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.29330883535211316},{"$f":"P20/$O20-1","v":-0.14851272009827832},-0.24673682903067018,-0.15339409360978717,null,{"$f":"B20*'Public Lighting Pricing'!$C$116","v":107.675},{"$f":"C20*'Public Lighting Pricing'!$C$116","v":95.254049999999992}]
["NPL4"]
["Major",null,0.71,null,0.72775000000000001,null,0.74594000000000005,null,0.76458999999999999,null,0.78369999999999995,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":39.794736649964101},{"$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":24.938812509802037},{"$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.2231854924719063},{"$f":"SUM(P22:Q22)","v":26.161998002273943},"Revenue",null,{"$f":"R22/O22-1","v":-0.34257642581239334},null,null,{"$f":"C22*'Public Lighting Pricing'!$C$116","v":259.14999999999998}]
["Minor",null,0.44,null,0.45100000000000001,null,0.46228000000000002,null,0.47383999999999998,null,0.48569000000000001,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"C23*'Public Lighting Pricing'!$C$116","v":160.6}]
[]
[]
["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":0.12173},{"$f":"C4-C16","v":-0.48963000000000001},0.12432999999999994,-0.50204000000000004,0.12697000000000003,-0.51476,0.12967000000000006,-0.52780000000000005,0.13241999999999998,-0.54116999999999993]
["Minor",{"$f":"B5-B17","v":5.6240000000000012E-2},-0.2898,5.7379999999999931E-2,-0.29715000000000003,5.8540000000000036E-2,-0.30468000000000006,5.9719999999999995E-2,-0.31241000000000008,6.093000000000004E-2,-0.32032000000000005]
["NPL2 (Gifted & Energex Operated)"]
["Major",{"$f":"B7-B19","v":-0.10122999999999999},{"$f":"C7-C19","v":-0.19817999999999997},-0.10394000000000003,-0.20324000000000003,-0.10672000000000004,-0.20841999999999999,-0.10957,-0.21373999999999999,-0.11250000000000004,-0.21919000000000002]
["Minor",{"$f":"B8-B20","v":-6.7639999999999978E-2},-0.12787999999999997,-6.9449999999999984E-2,-0.13114000000000001,-7.1309999999999985E-2,-0.13448999999999997,-7.320999999999997E-2,-0.13792000000000001,-7.5159999999999949E-2,-0.14143999999999998]
["NPL4"]
["Major",null,{"$f":"C10-C22","v":-0.44174699999999995},null,-0.45293,null,{"$f":"G10-G22","v":-0.46439000000000002},null,{"$f":"I10-I22","v":-0.47614000000000001},null,{"$f":"K10-K22","v":-0.48817999999999995}]
["Minor",null,{"$f":"C11-C23","v":-0.27168800000000004},null,-0.27856000000000003,null,{"$f":"G11-G23","v":-0.28561999999999999},null,{"$f":"I11-I23","v":-0.29284999999999994},null,{"$f":"K11-K23","v":-0.30027000000000004}]
[]
[]
["Difference %",{"$f":"B26","v":"Conventional"},{"$f":"C26","v":"LED"},"Conventional","LED","Conventional","LED","Conventional","LED","Conventional","LED"]
[{"$f":"A27","v":"NPL1 (Energex Owned & Operated)"}]
[{"$f":"A28","v":"Major"},{"$f":"B28/B16","v":0.15613616540967626},{"$f":"C28/C16","v":-0.60046356478869789},0.15558169509341402,-0.60066283006903487,0.155009705656139,-0.60085676600016347,0.15444443121047186,-0.60104995843440046,0.15387296939273512,-0.60124655586170106]
["Minor",{"$f":"B29/B17","v":0.1174382426026854},-0.5887611230750478,0.11689687487267231,-0.58896398628426461,0.11635163874147843,-0.58916347604130415,0.11580151635609159,-0.58937498820910461,0.11526674233825207,-0.58956048001177952]
[{"$f":"A18","v":"NPL2 (Gifted & Energex Operated)"}]
[{"$f":"A19","v":"Major"},{"$f":"B31/B19","v":-0.22565257127571831},-0.49646775890575673,-0.22604005828240878,-0.49672499755596838,-0.22642310058769871,-0.49695987028779898,-0.22680134958912049,-0.49722008979458904,-0.22718552474807657,-0.49745812718442201]
["Minor",{"$f":"B32/B20","v":-0.22928813559322028},-0.49001800973291942,-0.22967788874925588,-0.49026131818011892,-0.23007678905594628,-0.49051717849587856,-0.23044477320658496,-0.49076611037967482,-0.2308141141786689,-0.49100881760744286]
[{"$f":"A21","v":"NPL4"}]
[{"$f":"A22","v":"Major"},null,{"$f":"C34/C22","v":-0.62217887323943655},null,-0.6223703194778426,null,{"$f":"G34/G22","v":-0.62255677400327103},null,{"$f":"I34/I22","v":-0.62273898429223506},null,{"$f":"K34/K22","v":-0.62291693249968094}]
["Minor",null,{"$f":"C35/C23","v":-0.6174727272727274},null,-0.61764966740576499,null,{"$f":"G35/G23","v":-0.61785065328372413},null,{"$f":"I35/I23","v":-0.61803562383927058},null,{"$f":"K35/K23","v":-0.61823385286911414}]