{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Final Decision Forecast_Opex","Forecast_Opex Exp (Rev Prop)"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"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":"Final Decision Forecast_Opex","index":0,"n_rows":91,"n_cols":10,"rows_kept":91,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,"2018-03-01","2019-06-01","2020-06-01","2021-06-01","2022-06-01","2023-06-01","2024-06-01","2025-06-01"]
[]
[null,"Real labour escalation (BIS/DAE)",null,null,null,8.0857089764536597E-3,9.8252646141938002E-3,1.0493456191476618E-2,1.0262247478872492E-2,9.6681803386212059E-3]
[null,"Productivity Factor",null,null,null,5.0000000000000001E-3,5.0000000000000001E-3,5.0000000000000001E-3,5.0000000000000001E-3,5.0000000000000001E-3]
[null,"Annual increase in total lights",null,1500,1500,1500,1500,1500,1500,1500]
[]
[]
[null,"LED conversion",null,null,0.1,0.125,0.15,0.17499999999999999,0.2,0.22500000000000001]
[]
[]
[null,"Major LED",null,null,null,2068,5690,10335,15732,21896]
[null,"Minor LED",null,null,null,5083,14012,25500,38864,54180]
[null,"Major Conventional",null,null,null,39848,36741,32616,27744,22115]
[null,"Minor Conventional",null,null,null,103479,95306,84597,72039,57547]
[null,"TOTAL",157804,159679,161179,{"$f":"SUM(F12:F15)","v":150478},{"$f":"SUM(G12:G15)","v":151749},153048,154379,155738]
[null,"LED portion of total",null,null,null,{"$f":"SUM(F12:F13)/F16","v":4.7521896888581716E-2},{"$f":"SUM(G12:G13)/G16","v":0.12983281603173663},{"$f":"SUM(H12:H13)/H16","v":0.23414222988866237},{"$f":"SUM(I12:I13)/I16","v":0.3536491362167134},{"$f":"SUM(J12:J13)/J16","v":0.48848707444554318}]
[]
[]
[null,"ACTUAL 2018/19 Operating Costs ","Proportion",{"$f":"9547086+('Forecast_Opex Exp (Rev Prop)'!D64-'Forecast_Opex Exp (Rev Prop)'!D63)*1/(1+A51)","v":9555851.8518518526}]
[null,"Labour proportion",{"$f":"D21/(D20-D23)","v":0.76252078653800126},6392190.29]
[null,"Material proportion",{"$f":"1-C21","v":0.23747921346199874},1982016.15]
[null,"Portion incorrectly allocated to SCS",null,1172880]
[]
[]
[null,"Luminaire maintenance total",null,{"$f":"6745929/12011644*D20","v":5366717.3392011216},{"$f":"SUM(E27:E28)","v":5366717.3392011216},{"$f":"SUM(F27:F28)","v":5379179.3378811423},5398783.9313529031,5421224.2025627652,5442832.6023448948,5462089.7044706922]
[null,"All Luminaires maintenance - Labour",null,{"$f":"D26*$C21","v":4092233.5266147684},{"$f":"D27*(1+E$4)*(1-E$5)","v":4092233.5266147684},{"$f":"E27*(1+F$4)*(1-F$5)","v":4104695.5252947886},4124300.11876655,4146740.3899764121,4168348.7897585412,4187605.891884339]
[null,"All Luminaires maintenance - Materials",null,{"$f":"D26*$C22","v":1274483.8125863532},{"$f":"D28","v":1274483.8125863532},{"$f":"E28","v":1274483.8125863532},1274483.8125863532,1274483.8125863532,1274483.8125863532,1274483.8125863532]
[]
[null,"Maintenance volume",null,{"$f":"68411/368980*D16","v":29605.398853596402},{"$f":"68411/368980*E16","v":29883.507423166568},27899.480887853002,28135.131549135454,28375.973570383219,28622.74857444848,28874.71493847905]
[null,"Maintenance Unit Rate - All",null,{"$f":"D26/D30","v":181.2749548060618},{"$f":"E26/E30","v":179.58793334415242},192.80571418169836,191.88763777146082,191.04980448040189,190.15758001674618,189.16514729611399]
[]
[null,"Reduction in Maintenance Cost of Conventional/MV Luminaires"]
[null,"Portion of conventional/MV luminaires requiring maintenance",null,null,null,{"$f":"F30/SUM(F14:F15)","v":0.19465614216339561}]
[null,"Adjusted Conventional/MV Luminair Maintenance Volume",null,null,null,{"$f":"ROUND($F$34*(SUM(F14:F15)),0)","v":27899},{"$f":"ROUND($F$34*(SUM(G14:G15)),0)","v":25704},{"$f":"ROUND($F$34*(SUM(H14:H15)),0)","v":22816},{"$f":"ROUND($F$34*(SUM(I14:I15)),0)","v":19423},{"$f":"ROUND($F$34*(SUM(J14:J15)),0)","v":15507}]
[null,"Reduction in maintenance volume due to LEDs",null,null,null,{"$f":"F30-F35","v":0.48088785300205927},2431.1315491354544,5559.9735703832193,9199.7485744484802,13367.71493847905]
[null,"Reduction in Conventional/MV Luminiaire Maintenance",null,null,null,{"$f":"F31*F36","v":92.717925939365614},466504.09007527446,1062231.863537916,1749401.9256796334,2528705.7653498529]
[]
[null,"Increase in Maintenance Cost of LEDs Luminaires"]
[null,"Portion of LED luminaires requiring maintenance",null,0,0,0.01,0.02,0.03,0.04,0.05]
[null,"LED Luminair Maintenance Volume",null,null,null,{"$f":"ROUND(F40*SUM(F12:F13),0)","v":72},{"$f":"ROUND(G40*SUM(G12:G13),0)","v":394},{"$f":"ROUND(H40*SUM(H12:H13),0)","v":1075},{"$f":"ROUND(I40*SUM(I12:I13),0)","v":2184},{"$f":"ROUND(J40*SUM(J12:J13),0)","v":3804}]
[null,"Addition of LED Luminaire Maintenance",null,null,null,{"$f":"F41*F31","v":13882.011421082283},75603.729281955559,205378.53981643202,415304.15475657367,719584.22031441762]
[]
[null,"Total Pole Maintenance",null,{"$f":"D20-D26","v":4189134.512650731},{"$f":"SUM(E45:E46)","v":4189134.512650731},{"$f":"SUM(F45:F46)","v":4199978.0386038367},4217036.5316730076,4236562.425512895,4255364.485267424,4272120.616610745]
[null,"Labour portion",null,{"$f":"D44-D46","v":3560764.3357531214},{"$f":"D45*(1+E$4)*(1-E$5)","v":3560764.3357531214},{"$f":"E45*(1+F$4)*(1-F$5)","v":3571607.8617062275},3588666.354775398,3608192.2486152849,3626994.3083698144,3643750.4397131349]
[0.15,"Material Portion",null,{"$f":"D44*A46","v":628370.17689760961},{"$f":"D46","v":628370.17689760961},{"$f":"E46","v":628370.17689760961},628370.17689760961,628370.17689760961,628370.17689760961,628370.17689760961]
[]
[null,"Opex Conventional/MV "]
[null,"  Pole maintenance",null,{"$f":"D20-D55-D50","v":4189134.512650731},null,{"$f":"F44*SUM(F14:F15)/F16","v":4000387.1153189973},{"$f":"G44*SUM(G14:G15)/G16","v":3669526.8034571935},{"$f":"H44*SUM(H14:H15)/H16","v":3244604.2521407856},2750458.5107653202,2185244.9149240726]
[null,"   Luminaire maintenance",null,{"$f":"D26-D37","v":5366717.3392011216},null,{"$f":"F26-F37","v":5379086.6199552026},4932279.8412776291,4358992.3390248492,3693430.6766652614,2933383.9391208393]
[0.35,"   Overhead",null,{"$f":"SUM(D49:D50)*$A51","v":3344548.1481481483},null,{"$f":"SUM(F49:F50)*$A51","v":3282815.8073459696},3010632.3256571875,2661258.8069079719,2255361.2156007034,1791520.0989157192]
[null,"TOTAL",null,{"$f":"SUM(D49:D51)","v":12900400},null,{"$f":"SUM(F49:F51)","v":12662289.542620169},11612438.970392009,10264855.398073606,8699250.403031284,6910148.9529606318]
[]
[null,"Opex LED"]
[null,"  Pole maintenance",null,{"$f":"D44*D17","v":0},null,199590.9232848392,547509.72821581434,991958.1733721093,1504905.9745021036,2086875.7016866729]
[null,"  Luminaire maintenance",null,{"$f":"D42","v":0},null,13882.011421082283,75603.729281955559,205378.53981643202,415304.15475657367,719584.22031441762]
[{"$f":"A51","v":0.35},"  Overhead",null,{"$f":"SUM(D55:D56)*$A57","v":0},null,{"$f":"SUM(F55:F56)*$A57","v":74715.527147072513},218089.71012421945,419067.84961598943,672073.54524053703,982260.97270038154]
[null,"Total Operating Cost",null,{"$f":"SUM(D55:D57)","v":0},null,{"$f":"SUM(F55:F57)","v":288188.46185299399},841203.16762198927,1616404.5628045308,2592283.6744992146,3788720.894701472]
[]
[null,"Opex per Conventional/MV installation",null,null,null,{"$f":"F52/SUM(F14:F15)","v":88.345458585054942},{"$f":"G52/SUM(G14:G15)","v":87.941709924436068},{"$f":"H52/SUM(H14:H15)","v":87.574376545891724},{"$f":"I52/SUM(I14:I15)","v":87.181688293910625},{"$f":"J52/SUM(J14:J15)","v":86.743352576644213}]
[null,"Opex per LED installation",null,null,null,{"$f":"F58/SUM(F12:F13)","v":40.300442155362049},{"$f":"G58/SUM(G12:G13)","v":42.696333754034576},{"$f":"H58/SUM(H12:H13)","v":45.106866549589249},{"$f":"I58/SUM(I12:I13)","v":47.481201452472973},{"$f":"J58/SUM(J12:J13)","v":49.801788930825388}]
[]
[null,"Total PL Opex",null,{"$f":"SUM(D52,D58)","v":12900400},{"$f":"SUM(E52,E58)","v":0},{"$f":"SUM(F52,F58)","v":12950478.004473163},12453642.138013998,11881259.960878137,11291534.0775305,10698869.847662104]
[null,"RIN ",{"$f":"D63-D64","v":0},12900400]
[null,"Percentage decline 2020- 2025",null,{"$f":"(F63-J63)/F63","v":0.17386293818910323}]
[]
[]
[null,"PTRM Input Data ($M)"]
[null,"PL Opex (Real 2018/19 mid year)"]
[null,{"$f":"B48","v":"Opex Conventional/MV "},null,null,null,{"$f":"F52/10^6","v":12.662289542620169},{"$f":"G52/10^6","v":11.612438970392009},{"$f":"H52/10^6","v":10.264855398073607},{"$f":"I52/10^6","v":8.6992504030312841},{"$f":"J52/10^6","v":6.9101489529606317}]
[null,{"$f":"B54","v":"Opex LED"},null,null,null,{"$f":"F58/10^6","v":0.28818846185299402},{"$f":"G58/10^6","v":0.84120316762198932},{"$f":"H58/10^6","v":1.6164045628045309},{"$f":"I58/10^6","v":2.5922836744992148},{"$f":"J58/10^6","v":3.7887208947014721}]
[null,"Total PL Opex",null,null,null,{"$f":"SUM(F70:F71)","v":12.950478004473164},{"$f":"SUM(G70:G71)","v":12.453642138013999},11.881259960878138,11.2915340775305,10.698869847662104]
[]
[]
[null,"Total PL Opex Converted to Real 2019/20 end of year"]
[null,"CPI 2018-19  6months",null,null,{"$f":"(1+E90)^0.5-1","v":8.8811690196710646E-3}]
[null,"CPI 2019-20  12 months",null,null,{"$f":"E91","v":1.8404907975460238E-2}]
[null,"CPI June 2019 to Dec2020",null,null,{"$f":"(1+E76)*(1+E77)-1","v":2.7449534093652916E-2}]
[]
[null,{"$f":"B70","v":"Opex Conventional/MV "},null,null,null,{"$f":"F70*(1+$E$78)","v":13.009863491124026},{"$f":"G70*(1+$E$78)","v":11.931195009820248},10.546620896289445,8.9380407735585159,7.0998293222371442]
[null,{"$f":"B71","v":"Opex LED"},null,null,null,{"$f":"F71*(1+$E$78)","v":0.29609910086202518},0.86429380265131794,1.6607741149603701,2.6634406536028008,3.8927195180719152]
[null,"Total PL Opex",null,null,null,{"$f":"SUM(F80:F81)","v":13.30596259198605},{"$f":"SUM(G80:G81)","v":12.795488812471566},12.207395011249815,11.601481427161318,10.992548840309059]
[]
[null,"Difference from Revised Poroposal"]
[null,{"$f":"B80","v":"Opex Conventional/MV "},null,null,null,{"$f":"F80-'Forecast_Opex Exp (Rev Prop)'!F80","v":5.4782316975551026E-2},{"$f":"G80-'Forecast_Opex Exp (Rev Prop)'!G80","v":6.1375950345079033E-2},{"$f":"H80-'Forecast_Opex Exp (Rev Prop)'!H80","v":6.5670956085979171E-2},{"$f":"I80-'Forecast_Opex Exp (Rev Prop)'!I80","v":6.1850786297021898E-2},{"$f":"J80-'Forecast_Opex Exp (Rev Prop)'!J80","v":6.414989642996094E-2}]
[null,{"$f":"B81","v":"Opex LED"},null,null,null,{"$f":"F81-'Forecast_Opex Exp (Rev Prop)'!F81","v":1.2631133955527396E-3},{"$f":"G81-'Forecast_Opex Exp (Rev Prop)'!G81","v":4.5289933808446703E-3},{"$f":"H81-'Forecast_Opex Exp (Rev Prop)'!H81","v":1.0562625238050627E-2},{"$f":"I81-'Forecast_Opex Exp (Rev Prop)'!I81","v":1.8819469080399998E-2},{"$f":"J81-'Forecast_Opex Exp (Rev Prop)'!J81","v":3.5956350361335598E-2}]
[null,"Total PL Opex",null,null,null,{"$f":"F82-'Forecast_Opex Exp (Rev Prop)'!F82","v":5.6045430371103322E-2},{"$f":"G82-'Forecast_Opex Exp (Rev Prop)'!G82","v":6.5904943725923815E-2},{"$f":"H82-'Forecast_Opex Exp (Rev Prop)'!H82","v":7.6233581324029132E-2},{"$f":"I82-'Forecast_Opex Exp (Rev Prop)'!I82","v":8.0670255377423672E-2},{"$f":"J82-'Forecast_Opex Exp (Rev Prop)'!J82","v":0.10010624679129521}]
[]
[]
[null,"CPI 2018-19",null,null,1.7841213202497899E-2]
[null,"CPI 2019-20",null,null,1.8404907975460238E-2]

{"sheet":"Forecast_Opex Exp (Rev Prop)","index":1,"n_rows":82,"n_cols":10,"rows_kept":82,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,"2018-03-01","2019-06-01","2020-06-01","2021-06-01","2022-06-01","2023-06-01","2024-06-01","2025-06-01"]
[]
[null,"Real labour escalation (BIS/DAE)",null,null,null,6.8491222314366849E-3,8.6425611965758563E-3,9.1219124004980282E-3,9.3851484987669768E-3,6.99202884332056E-3]
[null,"Productivity Factor",null,null,null,5.0000000000000001E-3,5.0000000000000001E-3,5.0000000000000001E-3,5.0000000000000001E-3,5.0000000000000001E-3]
[null,"Annual increase in total lights",null,1500,1500,1500,1500,1500,1500,1500]
[]
[]
[null,"LED conversion",null,null,0.1,0.125,0.15,0.17499999999999999,0.2,0.22500000000000001]
[]
[]
[null,"Major LED",null,null,null,2068,5690,10335,15732,21896]
[null,"Minor LED",null,null,null,5083,14012,25500,38864,54180]
[null,"Major Conventional",null,null,null,39848,36741,32616,27744,22115]
[null,"Minor Conventional",null,null,null,103479,95306,84597,72039,57547]
[null,"TOTAL",157804,159679,161179,{"$f":"SUM(F12:F15)","v":150478},{"$f":"SUM(G12:G15)","v":151749},153048,154379,155738]
[null,"LED portion of total",null,null,null,{"$f":"SUM(F12:F13)/F16","v":4.7521896888581716E-2},{"$f":"SUM(G12:G13)/G16","v":0.12983281603173663},{"$f":"SUM(H12:H13)/H16","v":0.23414222988866237},{"$f":"SUM(I12:I13)/I16","v":0.3536491362167134},{"$f":"SUM(J12:J13)/J16","v":0.48848707444554318}]
[]
[]
[null,"ACTUAL 2018/19 Operating Costs ","Proportion",9547086]
[null,"Labour proportion",{"$f":"D21/(D20-D23)","v":0.76331896898643292},6392190.29]
[null,"Material proportion",{"$f":"1-C21","v":0.23668103101356708},1982016.15]
[null,"Portion incorrectly allocated to SCS",null,1172880]
[]
[]
[null,"Luminaire maintenance total",null,{"$f":"6745929/12011644*D20","v":5361794.2983403439},{"$f":"SUM(E27:E28)","v":5361794.2983403439},{"$f":"SUM(F27:F28)","v":5369222.1514985897},5383980.1535140583,5400753.9161129259,5418678.2331259921,5426799.3700048756]
[null,"All Luminaires maintenance - Labour",null,{"$f":"D26*$C21","v":4092759.295726486},{"$f":"D27*(1+E$4)*(1-E$5)","v":4092759.295726486},{"$f":"E27*(1+F$4)*(1-F$5)","v":4100187.1488847313},4114945.1509002,4131718.913499068,4149643.2305121338,4157764.3673910173]
[null,"All Luminaires maintenance - Materials",null,{"$f":"D26*$C22","v":1269035.0026138581},{"$f":"D28","v":1269035.0026138581},{"$f":"E28","v":1269035.0026138581},1269035.0026138581,1269035.0026138581,1269035.0026138581,1269035.0026138581]
[]
[null,"Maintenance volume",null,{"$f":"68411/368980*D16","v":29605.398853596402},{"$f":"68411/368980*E16","v":29883.507423166568},27899.480887853002,28135.131549135454,28375.973570383219,28622.74857444848,28874.71493847905]
[null,"Maintenance Unit Rate - All",null,{"$f":"D26/D30","v":181.10866618805929},{"$f":"E26/E30","v":179.4231922784179},192.44881914044018,191.36147076872291,190.32840944530059,189.31369288424119,187.94295914495797]
[]
[null,"Reduction in Maintenance Cost of Conventional/MV Luminaires"]
[null,"Portion of conventional/MV luminaires requiring maintenance",null,null,null,{"$f":"F30/SUM(F14:F15)","v":0.19465614216339561}]
[null,"Adjusted Conventional/MV Luminair Maintenance Volume",null,null,null,{"$f":"ROUND($F$34*(SUM(F14:F15)),0)","v":27899},{"$f":"ROUND($F$34*(SUM(G14:G15)),0)","v":25704},{"$f":"ROUND($F$34*(SUM(H14:H15)),0)","v":22816},{"$f":"ROUND($F$34*(SUM(I14:I15)),0)","v":19423},{"$f":"ROUND($F$34*(SUM(J14:J15)),0)","v":15507}]
[null,"Reduction in maintenance volume due to LEDs",null,null,null,{"$f":"F30-F35","v":0.48088785300205927},2431.1315491354544,5559.9735703832193,9199.7485744484802,13367.71493847905]
[null,"Reduction in Conventional/MV Luminiaire Maintenance",null,null,null,{"$f":"F31*F36","v":92.546299449227888},465224.90887480433,1058220.9262089471,1741638.3762353754,2512367.9025440123]
[]
[null,"Increase in Maintenance Cost of LEDs Luminaires"]
[null,"Portion of LED luminaires requiring maintenance",null,0,0,0.01,0.02,0.03,0.04,0.05]
[null,"LED Luminair Maintenance Volume",null,null,null,{"$f":"ROUND(F40*SUM(F12:F13),0)","v":72},{"$f":"ROUND(G40*SUM(G12:G13),0)","v":394},{"$f":"ROUND(H40*SUM(H12:H13),0)","v":1075},{"$f":"ROUND(I40*SUM(I12:I13),0)","v":2184},{"$f":"ROUND(J40*SUM(J12:J13),0)","v":3804}]
[null,"Addition of LED Luminaire Maintenance",null,null,null,{"$f":"F41*F31","v":13856.314978111694},75396.419482876823,204603.04015369815,413461.10525918275,714935.01658742013]
[]
[null,"Total Pole Maintenance",null,{"$f":"D20-D26","v":4185291.7016596561},{"$f":"SUM(E45:E46)","v":4185291.7016596561},{"$f":"SUM(F45:F46)","v":4191748.1215092889},4204576.0349216349,4219156.0826809444,4234736.2124558324,4241795.2466383008]
[null,"Labour portion",null,{"$f":"D44-D46","v":3557497.9464107077},{"$f":"D45*(1+E$4)*(1-E$5)","v":3557497.9464107077},{"$f":"E45*(1+F$4)*(1-F$5)","v":3563954.3662603404},3576782.2796726865,3591362.3274319964,3606942.4572068839,3614001.4913893528]
[0.15,"Material Portion",null,{"$f":"D44*A46","v":627793.75524894835},{"$f":"D46","v":627793.75524894835},{"$f":"E46","v":627793.75524894835},627793.75524894835,627793.75524894835,627793.75524894835,627793.75524894835]
[]
[null,"Opex Conventional/MV "]
[null,"  Pole maintenance",null,{"$f":"D20-D55-D50","v":4185291.7016596561},null,{"$f":"F44*SUM(F14:F15)/F16","v":3992548.2994960188},{"$f":"G44*SUM(G14:G15)/G16","v":3658684.0880882055},{"$f":"H44*SUM(H14:H15)/H16","v":3231273.4692337145},2737125.4088151907,2169733.0962109459]
[null,"   Luminaire maintenance",null,{"$f":"D26-D37","v":5361794.2983403439},null,{"$f":"F26-F37","v":5369129.6051991405},4918755.2446392542,4342532.989903979,3677039.8568906169,2914431.4674608633]
[0.35,"   Overhead",null,{"$f":"SUM(D49:D50)*$A51","v":3341480.0999999996},null,{"$f":"SUM(F49:F50)*$A51","v":3276587.2666433053},3002103.766454611,2650832.2606981923,2244957.8429970322,1779457.5972851329]
[null,"TOTAL",null,{"$f":"SUM(D49:D51)","v":12888566.1},null,{"$f":"SUM(F49:F51)","v":12638265.171338465},11579543.099182071,10224638.719835885,8659123.1087028384,6863622.1609569415]
[]
[null,"Opex LED"]
[null,"  Pole maintenance",null,{"$f":"D44*D17","v":0},null,199199.82201327052,545891.94683342928,987882.61344722984,1497610.8036406417,2072062.1504273547]
[null,"  Luminaire maintenance",null,{"$f":"D42","v":0},null,13856.314978111694,75396.419482876823,204603.04015369815,413461.10525918275,714935.01658742013]
[{"$f":"A51","v":0.35},"  Overhead",null,{"$f":"SUM(D55:D56)*$A57","v":0},null,{"$f":"SUM(F55:F56)*$A57","v":74569.647946983765},217450.92821070712,417369.97876032477,668875.16811493854,975449.00845517113]
[null,"Total Operating Cost",null,{"$f":"SUM(D55:D57)","v":0},null,{"$f":"SUM(F55:F57)","v":287625.78493836598},838739.2945270132,1609855.6323612528,2579947.0770147629,3762446.1754699461]
[]
[null,"Opex per Conventional/MV installation",null,null,null,{"$f":"F52/SUM(F14:F15)","v":88.177839285957745},{"$f":"G52/SUM(G14:G15)","v":87.692587481594217},{"$f":"H52/SUM(H14:H15)","v":87.231268885156808},{"$f":"I52/SUM(I14:I15)","v":86.779542694675825},{"$f":"J52/SUM(J14:J15)","v":86.159300054692849}]
[null,"Opex per LED installation",null,null,null,{"$f":"F58/SUM(F12:F13)","v":40.221757088290587},{"$f":"G58/SUM(G12:G13)","v":42.571276749924536},{"$f":"H58/SUM(H12:H13)","v":44.92411420011868},{"$f":"I58/SUM(I12:I13)","v":47.25523988963959},{"$f":"J58/SUM(J12:J13)","v":49.456414315552159}]
[]
[null,"Total PL Opex",null,{"$f":"SUM(D52,D58)","v":12888566.1},{"$f":"SUM(E52,E58)","v":0},{"$f":"SUM(F52,F58)","v":12925890.95627683},12418282.393709084,11834494.352197137,11239070.185717601,10626068.336426888]
[null,"RIN ",{"$f":"D63-D64","v":-11833.900000000373},12900400]
[null,"Percentage decline 2020- 2025",null,{"$f":"(F63-J63)/F63","v":0.17792372128384276}]
[]
[]
[null,"PTRM Input Data ($M)"]
[null,"PL Opex (Real 2018/19 mid year)"]
[null,{"$f":"B48","v":"Opex Conventional/MV "},null,null,null,{"$f":"F52/10^6","v":12.638265171338466},{"$f":"G52/10^6","v":11.579543099182072},{"$f":"H52/10^6","v":10.224638719835886},{"$f":"I52/10^6","v":8.659123108702838},{"$f":"J52/10^6","v":6.8636221609569414}]
[null,{"$f":"B54","v":"Opex LED"},null,null,null,{"$f":"F58/10^6","v":0.28762578493836599},{"$f":"G58/10^6","v":0.83873929452701323},{"$f":"H58/10^6","v":1.6098556323612527},{"$f":"I58/10^6","v":2.5799470770147628},{"$f":"J58/10^6","v":3.7624461754699463}]
[null,"Total PL Opex",null,null,null,{"$f":"SUM(F70:F71)","v":12.925890956276831},{"$f":"SUM(G70:G71)","v":12.418282393709084},11.834494352197138,11.239070185717601,10.626068336426888]
[]
[]
[null,"Total PL Opex Converted to Real 2019/20 end of year"]
[null,"CPI June 2019 6months",null,null,{"$f":"((1.59292035398231%+1)^0.5)-1","v":7.93313445874122E-3}]
[null,"CPI June 2020 12 months",null,null,1.7000000000000001E-2]
[null,"CPI June 2019 to Dec2020",null,null,{"$f":"(1+E76)*(1+E77)-1","v":2.5067997744539827E-2}]
[]
[null,{"$f":"B70","v":"Opex Conventional/MV "},null,null,null,{"$f":"F70*(1+$E$78)","v":12.955081174148475},{"$f":"G70*(1+$E$78)","v":11.869819059475169},10.480949940203466,8.876189987261494,7.0356794258071833]
[null,{"$f":"B71","v":"Opex LED"},null,null,null,{"$f":"F71*(1+$E$78)","v":0.29483598746647244},{"$f":"G71*(1+$E$78)","v":0.85976480927047327},1.6502114897223195,2.6446211845224008,3.8567631677105796]
[null,"Total PL Opex",null,null,null,{"$f":"SUM(F80:F81)","v":13.249917161614947},{"$f":"SUM(G80:G81)","v":12.729583868745642},12.131161429925786,11.520811171783894,10.892442593517764]