{"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":104,"n_cols":10,"rows_kept":104,"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,null,null,5000,5000,5000,5000,5000]
[]
[]
[null,"LED conversion",null,null,null,0.125,0.15,0.17499999999999999,0.2,0.22500000000000001]
[]
[]
[null,"Major LED",null,null,null,5884,11021,19785,29818,41165]
[null,"Minor LED",null,null,null,13889,26111,47098,71286,98962]
[null,"Major Conventional",null,null,null,88706,85084,77895,69502,59860]
[null,"Minor Conventional",null,null,null,227988,219681,202683,182561,159025]
[null,"TOTAL",362730,null,null,{"$f":"SUM(F12:F15)","v":336467},{"$f":"SUM(G12:G15)","v":341897},347461,353167,359012]
[null,"LED portion of total",null,null,null,{"$f":"SUM(F12:F13)/F16","v":5.8766535796972663E-2},{"$f":"SUM(G12:G13)/G16","v":0.10860580818199633},0.19249066801741779,0.28627816302202641,0.3903128586231101]
[null,"MV portion of total",null,null,null,{"$f":"SUM(F14:F15)/F16","v":0.94123346420302734},{"$f":"SUM(G14:G15)/G16","v":0.89139419181800372},0.80750933198258223,0.71372183697797364,0.60968714137688995]
[]
[null,"ACTUAL 2018/19 Operating Costs (RIN basis)",null,{"$f":"15984892+'Forecast_Opex Exp (Rev Prop)'!D79*(1/(1+C58))","v":18569284.21531463}]
[null,"Actual 2018/19 Operating Costs (Direct costs - operating accounts)",null,12011644.359999994]
[null,"All - Luminaire Maintenance Activity"]
[null,"Major Road Luminaires Maintenance - Labour",null,{"$f":"1422513.79048334","v":1422513.7904833399},{"$f":"D23*(1+E$4)*(1-E$5)","v":1422513.7904833399},{"$f":"E23*(1+F$4)*(1-F$5)","v":1426845.7438931393},1433660.556486073,1441461.0876753626,1448972.4494978108,1455666.469563023]
[null,"Major Road Luminaires Maintenance - Materials",null,766596.17890000122,{"$f":"D24","v":766596.17890000122},{"$f":"E24","v":766596.17890000122},766596.17890000122,766596.17890000122,766596.17890000122,766596.17890000122]
[null,"Total Maintenance - Major",null,{"$f":"SUM(D23:D24)","v":2189109.9693833413},{"$f":"SUM(E23:E24)","v":2189109.9693833413},{"$f":"SUM(F23:F24)","v":2193441.9227931406},2200256.7353860741,2208057.2665753639,2215568.6283978121,2222262.6484630243]
[null,"Major Luminaires - maintenance volume",null,18020,{"$f":"D26","v":18020},{"$f":"D26/F$16*F$16","v":18020},{"$f":"F26/F$16*G$16","v":18310.811877539254},18608.800328115387,18914.393803850005,19227.43163519751]
[]
[null,"Minor Road Luminaires Maintenance - Labour",null,3241564.7495166622,{"$f":"D28*(1+E$4)*(1-E$5)","v":3241564.7495166622},{"$f":"E28*(1+F$4)*(1-F$5)","v":3251436.2232160368},3266965.5322628831,3284741.0554949739,3301857.6317049242,3317111.6838069963]
[null,"Materials",null,1315254.651100002,{"$f":"D29","v":1315254.651100002},{"$f":"E29","v":1315254.651100002},1315254.651100002,1315254.651100002,1315254.651100002,1315254.651100002]
[null,"Total Maintenance - Minor",null,{"$f":"D28+D29","v":4556819.4006166644},{"$f":"SUM(E28:E29)","v":4556819.4006166644},{"$f":"SUM(F28:F29)","v":4566690.8743160386},4582220.1833628854,4599995.7065949757,4617112.2828049259,4632366.3349069981]
[null,"Minor Luminaires - maintenance volume",null,50391,{"$f":"D31","v":50391},{"$f":"D31/F$16*F$16","v":50391},{"$f":"F31/F$16*G$16","v":51204.224268650418},52037.517055164404,52892.076480011412,53767.453248015408]
[]
[null,"Portion of difference between RIN and operating accounts attributed to Luminaires (all labour)",null,{"$f":"(D20-D21)*SUM(D25,D30)/D21","v":3682874.2153875772},{"$f":"D33*(1+E$4)*(1-E$5)","v":3682874.2153875772},{"$f":"E33*(1+F$4)*(1-F$5)","v":3694089.6001676358},3711733.0829578354,3731928.5815010164,3751375.4233969678,3768706.1755206995]
[null,"Non-network capex (excluded from SCS)",null,{"$f":"469638","v":469638},{"$f":"D34","v":469638},{"$f":"E34","v":469638},469638,469638,469638,469638]
[]
[null,"Total Luminaire Maintenance - ALL",null,{"$f":"SUM(D25,D30,D33:D34)","v":10898441.585387584},{"$f":"SUM(E25,E30,E33:E34)","v":10898441.585387584},10923860.397276815,10963848.001706796,11009619.554671356,11053694.334599705,11092973.158890722]
[null,"Unadjusted Luminaire Maintenance Volume",null,{"$f":"D31+D26","v":68411},{"$f":"D37","v":68411},68411,69515.036146189668,70646.317383279791,71806.470283861418,72994.884883212915]
[null,"Maintenance Unit Rate - All",null,{"$f":"D36/(D26+D31)","v":159.30832154752281},159.30832154752281,159.67988185053304,157.71908653906033,155.84137945847206,153.9373024589963,151.96918491807693]
[]
[null,"Reduction in Maintenance Cost of Conventional/MV Luminaires"]
[null,"Portion of conventional/MV luminaires requiring maintenance",null,null,null,{"$f":"F37/(F14+F15)","v":0.21601609124265064}]
[null,"Adjusted Conventional/MV Luminair Maintenance Volume",null,null,null,{"$f":"ROUND($F$41*SUM(F14:F15),0)","v":68411},{"$f":"ROUND($F$41*SUM(G14:G15),0)","v":65834},{"$f":"ROUND($F$41*SUM(H14:H15),0)","v":60609},54450,47283]
[null,"Reduction in maintenance volume due to LEDs",null,null,null,{"$f":"F37-F42","v":0},3681.0361461896682,10037.317383279791,17356.470283861418,25711.884883212915]
[null,"Reduction in Conventional/MV Luminiaire Maintenance",null,null,null,{"$f":"F38*F43","v":0},{"$f":"G38*G43","v":580569.65849429742},1564229.3870728237,2671808.2157073566,3907414.1884092903]
[]
[null,"Increase in Maintenance Cost of LEDs Luminaires"]
[null,"Portion of LED luminaires requiring maintenance",null,null,null,0.01,0.02,0.03,0.04,0.05]
[null,"LED Luminair Maintenance Volume",null,null,null,{"$f":"ROUND(SUM(F12:F13)*F47,0)","v":198},{"$f":"ROUND(SUM(G12:G13)*G47,0)","v":743},2006,4044,7006]
[null,"Addition of LED Luminaire Maintenance",null,null,null,{"$f":"F48*F38","v":31616.61660640554},117185.28129852182,312617.80719369493,622522.45114418108,1064696.1095360471]
[]
[null,"Total Pole Maintenance",null,{"$f":"D20-D36","v":7670842.6299270466},{"$f":"SUM(E52:E53)","v":7670842.6299270466},{"$f":"SUM(F52:F53)","v":7690698.5168384388},7721934.8057286963,7757689.2219218537,7792118.2050590459,7822800.8308455534]
[null,"Labour portion",null,{"$f":"D51-D53","v":6520216.2354379892},{"$f":"D52*(1+E$4)*(1-E$5)","v":6520216.2354379892},{"$f":"E52*(1+F$4)*(1-F$5)","v":6540072.1223493824},6571308.4112396399,6607062.8274327973,6641491.8105699895,6672174.4363564961]
[null,"Material Portion",0.15,{"$f":"D51*$C53","v":1150626.3944890569},{"$f":"D53","v":1150626.3944890569},{"$f":"E53","v":1150626.3944890569},1150626.3944890569,1150626.3944890569,1150626.3944890569,1150626.3944890569]
[]
[null,"Opex Conventional/MV "]
[null,"  Pole maintenance",null,{"$f":"D20-D62-D57","v":7670842.6299270466},null,{"$f":"F51*SUM(F14:F15)/F16","v":7238742.8071449278},{"$f":"G51*SUM(G14:G15)/G16","v":6883287.8354238449},6264406.4413225939,5561404.9192642523,4769461.0761189843]
[null,"   Luminaire maintenance",null,{"$f":"D36-D44","v":10898441.585387584},{"$f":"E36-E44","v":10898441.585387584},{"$f":"F36-F44","v":10923860.397276815},{"$f":"G36-G44","v":10383278.343212498},9445390.1675985325,8381886.1188923493,7185558.970481432]
[null,"   Overhead",0.31900000000000001,{"$f":"SUM(D56:D57)*$C58","v":5923601.6646853676},3476602.8657386391,5793870.422210536,5508034.6109849932,5011425.1182458391,4447909.8411719566,3813651.3948655329]
[null,"TOTAL",null,{"$f":"SUM(D56:D58)","v":24492885.879999999},{"$f":"SUM(E56:E58)","v":14375044.451126223},23956473.626632281,22774600.789621335,20721221.727166966,18391200.87932856,15768671.44146595]
[]
[null,"Opex LED"]
[null,"  Pole maintenance",null,null,null,{"$f":"F51*F17","v":451955.70969351067},838646.97030485189,1493282.7805992598,2230713.2857947932,3053339.7547265687]
[null,"  Luminaire maintenance",null,null,null,{"$f":"F49","v":31616.61660640554},117185.28129852182,312617.80719369493,622522.45114418108,1064696.1095360471]
[null,"  Overhead",{"$f":"C58","v":0.31900000000000001},null,null,{"$f":"SUM(F62:F63)*$C64","v":154259.57208967328},304910.48826147622,576082.28750595252,910182.20008353284,1313653.4406997745]
[null,"Total Operating Cost",null,null,null,{"$f":"SUM(F62:F64)","v":637831.89838958951},1260742.73986485,2381982.875298907,3763417.9370225072,5431689.3049623901]
[]
[null,"Opex per Conventional/MV installation",null,null,null,{"$f":"F59/SUM(F14:F15)","v":75.645492578426754},74.728399880633717,73.851911864675657,72.962715191553542,72.040895636822754]
[null,"Opex per LED installation",null,null,null,{"$f":"F65/SUM(F12:F13)","v":32.257720041955672},33.952998488227138,35.614175131182918,37.223234857399383,38.76261751812563]
[]
[null,"Total PL Opex",null,null,null,{"$f":"SUM(F59,F65)","v":24594305.52502187},24035343.529486183,23103204.602465872,22154618.816351067,21200360.746428341]
[]
[null,"Percentage decline 2020- 2025",{"$f":"(F70-J70)/F70","v":0.1379971788648629}]
[]
[]
[null,"Key"]
[null,"Blue = Assumptions and sourced data"]
[null,"Black = calculated data"]
[null,"RIN DATA :  2018-19 Actual O & M",null,24492885.879999999]
[null,"Difference",null,{"$f":"D78-D59","v":0}]
[]
[null,"PTRM Input Data ($M)"]
[null,"PL Opex (Real 2018/19 mid year)"]
[null,{"$f":"B55","v":"Opex Conventional/MV "},null,null,null,{"$f":"F59/10^6","v":23.956473626632281},{"$f":"G59/10^6","v":22.774600789621335},20.721221727166967,18.391200879328562,15.768671441465949]
[null,{"$f":"B61","v":"Opex LED"},null,null,null,{"$f":"F65/10^6","v":0.63783189838958954},{"$f":"G65/10^6","v":1.2607427398648499},2.381982875298907,3.7634179370225072,5.43168930496239]
[null,"Total PL Opex",null,null,null,{"$f":"SUM(F83:F84)","v":24.59430552502187},{"$f":"SUM(G83:G84)","v":24.035343529486184},23.103204602465873,22.154618816351068,21.200360746428338]
[]
[]
[null,"Total PL Opex Converted to Real 2019/20 end of year"]
[null,"CPI 2018-19  6months",null,null,{"$f":"(1+E103)^0.5-1","v":8.8811690196710646E-3}]
[null,"CPI 2019-20  12 months",null,null,{"$f":"E104","v":1.8404907975460238E-2}]
[null,"CPI June 2019 to Dec 2020",null,null,{"$f":"(1+E89)*(1+E90)-1","v":2.7449534093652916E-2}]
[]
[null,{"$f":"B83","v":"Opex Conventional/MV "},null,null,null,{"$f":"F83*(1+$E$91)","v":24.614067666210222},{"$f":"G83*(1+$E$91)","v":23.399752970465382},21.290009609428978,18.89603077488891,16.201514125810082]
[null,{"$f":"B84","v":"Opex LED"},null,null,null,{"$f":"F84*(1+$E$91)","v":0.65534008683045397},1.2953495406860955,2.4473671954449219,3.8667220059934713,5.5807866457250848]
[null,"Total PL Opex",null,null,null,{"$f":"SUM(F93:F94)","v":25.269407753040674},{"$f":"SUM(G93:G94)","v":24.695102511151479},23.7373768048739,22.76275278088238,21.782300771535166]
[]
[null,"Difference from Revised Poroposal"]
[null,{"$f":"B93","v":"Opex Conventional/MV "},null,null,null,{"$f":"F93-'Forecast_Opex Exp (Rev Prop)'!F93","v":3.4911794331127126},{"$f":"G93-'Forecast_Opex Exp (Rev Prop)'!G93","v":3.3393806366681034},{"$f":"H93-'Forecast_Opex Exp (Rev Prop)'!H93","v":3.0598172638998093},{"$f":"I93-'Forecast_Opex Exp (Rev Prop)'!I93","v":2.7286025599699144},{"$f":"J93-'Forecast_Opex Exp (Rev Prop)'!J93","v":2.3696312658599474}]
[null,{"$f":"B94","v":"Opex LED"},null,null,null,{"$f":"F94-'Forecast_Opex Exp (Rev Prop)'!F94","v":9.8046028277857022E-2},{"$f":"G94-'Forecast_Opex Exp (Rev Prop)'!G94","v":0.19382738755041129},{"$f":"H94-'Forecast_Opex Exp (Rev Prop)'!H94","v":0.36684244210974004},{"$f":"I94-'Forecast_Opex Exp (Rev Prop)'!I94","v":0.57958258876670454},{"$f":"J94-'Forecast_Opex Exp (Rev Prop)'!J94","v":0.84382682409576315}]
[null,"Total PL Opex",null,null,null,{"$f":"F95-'Forecast_Opex Exp (Rev Prop)'!F95","v":3.5892254613905692},{"$f":"G95-'Forecast_Opex Exp (Rev Prop)'!G95","v":3.5332080242185171},{"$f":"H95-'Forecast_Opex Exp (Rev Prop)'!H95","v":3.4266597060095485},{"$f":"I95-'Forecast_Opex Exp (Rev Prop)'!I95","v":3.3081851487366194},{"$f":"J95-'Forecast_Opex Exp (Rev Prop)'!J95","v":3.2134580899557115}]
[]
[]
[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":95,"n_cols":10,"rows_kept":95,"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,null,null,5000,5000,5000,5000,5000]
[]
[]
[null,"LED conversion",null,null,null,0.125,0.15,0.17499999999999999,0.2,0.22500000000000001]
[]
[]
[null,"Major LED",null,null,null,5884,11021,19785,29818,41165]
[null,"Minor LED",null,null,null,13889,26111,47098,71286,98962]
[null,"Major Conventional",null,null,null,88706,85084,77895,69502,59860]
[null,"Minor Conventional",null,null,null,227988,219681,202683,182561,159025]
[null,"TOTAL",362730,null,null,{"$f":"SUM(F12:F15)","v":336467},{"$f":"SUM(G12:G15)","v":341897},347461,353167,359012]
[null,"LED portion of total",null,null,null,{"$f":"SUM(F12:F13)/F16","v":5.8766535796972663E-2},{"$f":"SUM(G12:G13)/G16","v":0.10860580818199633},0.19249066801741779,0.28627816302202641,0.3903128586231101]
[null,"MV portion of total",null,null,null,{"$f":"SUM(F14:F15)/F16","v":0.94123346420302734},{"$f":"SUM(G14:G15)/G16","v":0.89139419181800372},0.80750933198258223,0.71372183697797364,0.60968714137688995]
[]
[null,"ACTUAL 2018/19 Operating Costs (RIN basis)",null,15984892]
[null,"Actual 2018/19 Operating Costs (Direct costs - operating accounts)",null,12011644.359999994]
[null,"All - Luminaire Maintenance Activity"]
[null,"Major Road Luminaires Maintenance - Labour",null,{"$f":"1422513.79048334","v":1422513.7904833399},{"$f":"D23*(1+E$4)*(1-E$5)","v":1422513.7904833399},{"$f":"E23*(1+F$4)*(1-F$5)","v":1425095.4775037132},1430224.8926171076,1436054.9224065696,1442284.8485502119,1445107.4990825013]
[null,"Major Road Luminaires Maintenance - Materials",null,766596.17890000122,{"$f":"D24","v":766596.17890000122},{"$f":"E24","v":766596.17890000122},766596.17890000122,766596.17890000122,766596.17890000122,766596.17890000122]
[null,"Total Maintenance - Major",null,{"$f":"SUM(D23:D24)","v":2189109.9693833413},{"$f":"SUM(E23:E24)","v":2189109.9693833413},{"$f":"SUM(F23:F24)","v":2191691.6564037143},2196821.0715171089,2202651.1013065707,2208881.0274502132,2211703.6779825026]
[null,"Major Luminaires - maintenance volume",null,18020,{"$f":"D26","v":18020},{"$f":"D26/F$16*F$16","v":18020},{"$f":"F26/F$16*G$16","v":18310.811877539254},18608.800328115387,18914.393803850005,19227.43163519751]
[]
[null,"Minor Road Luminaires Maintenance - Labour",null,3241564.7495166622,{"$f":"D28*(1+E$4)*(1-E$5)","v":3241564.7495166622},{"$f":"E28*(1+F$4)*(1-F$5)","v":3247447.7895936817},3259136.4855686906,3272421.7128758584,3286618.2072187788,3293050.344838032]
[null,"Materials",null,1315254.651100002,{"$f":"D29","v":1315254.651100002},{"$f":"E29","v":1315254.651100002},1315254.651100002,1315254.651100002,1315254.651100002,1315254.651100002]
[null,"Total Maintenance - Minor",null,{"$f":"D28+D29","v":4556819.4006166644},{"$f":"SUM(E28:E29)","v":4556819.4006166644},{"$f":"SUM(F28:F29)","v":4562702.4406936839},4574391.1366686923,4587676.3639758602,4601872.8583187805,4608304.9959380338]
[null,"Minor Luminaires - maintenance volume",null,50391,{"$f":"D31","v":50391},{"$f":"D31/F$16*F$16","v":50391},{"$f":"F31/F$16*G$16","v":51204.224268650418},52037.517055164404,52892.076480011412,53767.453248015408]
[]
[null,"Portion of difference between RIN and operating accounts attributed to Luminaires (all labour)",null,{"$f":"(D20-D21)*SUM(D25,D30)/D21","v":2231438.68946177},{"$f":"D33*(1+E$4)*(1-E$5)","v":2231438.68946177},{"$f":"E33*(1+F$4)*(1-F$5)","v":2235488.4753688611},2243534.7772148694,2252680.1043954939,2262452.7324869866,2266880.5079129389]
[null,"Non-network capex (excluded from SCS)",null,{"$f":"469638","v":469638},{"$f":"D34","v":469638},{"$f":"E34","v":469638},469638,469638,469638,469638]
[]
[null,"Total Luminaire Maintenance - ALL",null,{"$f":"SUM(D25,D30,D33:D34)","v":9447006.0594617762},{"$f":"SUM(E25,E30,E33:E34)","v":9447006.0594617762},9459520.5724662598,9484384.9854006711,9512645.5696779247,9542844.6182559803,9556527.1818334758]
[null,"Unadjusted Luminaire Maintenance Volume",null,{"$f":"D31+D26","v":68411},{"$f":"D37","v":68411},{"$f":"F31+F26","v":68411},{"$f":"G31+G26","v":69515.036146189668},{"$f":"H31+H26","v":70646.317383279791},{"$f":"I31+I26","v":71806.470283861418},{"$f":"J31+J26","v":72994.884883212915}]
[null,"Maintenance Unit Rate - All",null,{"$f":"D36/(D26+D31)","v":138.09191591208688},138.09191591208688,138.27484720975076,136.43645333730493,134.65168351336214,132.89672338066094,130.92050486994123]
[]
[null,"Reduction in Maintenance Cost of Conventional/MV Luminaires"]
[null,"Portion of conventional/MV luminaires requiring maintenance",null,null,null,{"$f":"F37/(F14+F15)","v":0.21601609124265064}]
[null,"Adjusted Conventional/MV Luminair Maintenance Volume",null,null,null,{"$f":"ROUND($F$41*SUM(F14:F15),0)","v":68411},{"$f":"ROUND($F$41*SUM(G14:G15),0)","v":65834},{"$f":"ROUND($F$41*SUM(H14:H15),0)","v":60609},54450,47283]
[null,"Reduction in maintenance volume due to LEDs",null,null,null,{"$f":"F37-F42","v":0},3681.0361461896682,10037.317383279791,17356.470283861418,25711.884883212915]
[null,"Reduction in Conventional/MV Luminiaire Maintenance",null,null,null,{"$f":"F38*F43","v":0},{"$f":"G38*G43","v":502227.51639253943},1351541.6836165588,2306618.0301789925,3366212.9500680445]
[]
[null,"Increase in Maintenance Cost of LEDs Luminaires"]
[null,"Portion of LED luminaires requiring maintenance",null,null,null,0.01,0.02,0.03,0.04,0.05]
[null,"LED Luminair Maintenance Volume",null,null,null,{"$f":"ROUND(SUM(F12:F13)*F47,0)","v":198},{"$f":"ROUND(SUM(G12:G13)*G47,0)","v":743},2006,4044,7006]
[null,"Addition of LED Luminaire Maintenance",null,null,null,{"$f":"F48*F38","v":27378.41974753065},101372.28482961757,270111.27712780447,537434.34935139283,917229.05711880827]
[]
[null,"Total Pole Maintenance",null,{"$f":"D20-D36","v":6537885.9405382238},{"$f":"SUM(E52:E53)","v":6537885.9405382238},{"$f":"SUM(F52:F53)","v":6547971.5784268295},6568010.1900035953,6590785.8281317977,6615123.7043583477,6626150.6921109669]
[null,"Labour portion",null,{"$f":"D51-D53","v":5557203.0494574904},{"$f":"D52*(1+E$4)*(1-E$5)","v":5557203.0494574904},{"$f":"E52*(1+F$4)*(1-F$5)","v":5567288.6873460962},5587327.2989228619,5610102.9370510643,5634440.8132776143,5645467.8010302335]
[null,"Material Portion",0.15,{"$f":"D51*$C53","v":980682.89108073351},{"$f":"D53","v":980682.89108073351},{"$f":"E53","v":980682.89108073351},980682.89108073351,980682.89108073351,980682.89108073351,980682.89108073351]
[]
[null,"Opex Conventional/MV "]
[null,"  Pole maintenance",null,{"$f":"D20-D62-D57","v":6537885.9405382238},null,{"$f":"F51*SUM(F14:F15)/F16","v":6163169.9722656496},{"$f":"G51*SUM(G14:G15)/G16","v":5854686.1351706674},5322121.0613149777,4721358.2421111772,4039878.8738056361]
[null,"   Luminaire maintenance",null,{"$f":"D36-D44","v":9447006.0594617762},{"$f":"E36-E44","v":9447006.0594617762},{"$f":"F36-F44","v":9459520.5724662598},{"$f":"G36-G44","v":8982157.469008131},8161103.8860613657,7236226.5880769882,6190314.2317654314]
[null,"   Overhead",0.31900000000000001,{"$f":"SUM(D56:D57)*$C58","v":5099180.5480000004},3013594.9329683068,4983638.283769479,4732953.1097330367,4301148.7582130544,3814469.560830025,3263431.6006771703]
[null,"TOTAL",null,{"$f":"SUM(D56:D58)","v":21084072.548},{"$f":"SUM(E56:E58)","v":12460600.992430083},20606328.828501388,19569796.713911835,17784373.705589399,15772054.391018191,13493624.706248237]
[]
[null,"Opex LED"]
[null,"  Pole maintenance",null,null,null,{"$f":"F51*F17","v":384801.60616117989},713324.05483292777,1268664.7668168198,1893765.4622471703,2586271.8183053308]
[null,"  Luminaire maintenance",null,null,null,{"$f":"F49","v":27378.41974753065},101372.28482961757,270111.27712780447,537434.34935139283,917229.05711880827]
[null,"  Overhead",{"$f":"C58","v":0.31900000000000001},null,null,{"$f":"SUM(F62:F63)*$C64","v":131485.42826487866},{"$f":"SUM(G62:G63)*$C64","v":259888.13235235197},{"$f":"SUM(H62:H63)*$C64","v":490869.55801833514},{"$f":"SUM(I62:I63)*$C64","v":775552.7398999416},{"$f":"SUM(J62:J63)*$C64","v":1117616.7792603003}]
[null,"Total Operating Cost",null,null,null,{"$f":"SUM(F62:F64)","v":543665.45417358924},{"$f":"SUM(G62:G64)","v":1074584.4720148973},{"$f":"SUM(H62:H64)","v":2029645.6019629594},{"$f":"SUM(I62:I64)","v":3206752.5514985048},{"$f":"SUM(J62:J64)","v":4621117.6546844393}]
[]
[null,"Opex per Conventional/MV installation",null,null,null,{"$f":"F59/SUM(F14:F15)","v":65.067001043598509},64.212743306848992,63.38477608932061,62.571874456061344,61.647096449040532]
[null,"Opex per LED installation",null,null,null,{"$f":"F65/SUM(F12:F13)","v":27.495344872987875},28.939579662148478,30.346210576124864,31.717365796590688,32.978067429435008]
[]
[null,"Total PL Opex",null,null,null,{"$f":"SUM(F59,F65)","v":21149994.282674979},20644381.185926732,19814019.30755236,18978806.942516696,18114742.360932678]
[]
[null,"Percentage decline 2020- 2025",{"$f":"(F70-J70)/F70","v":0.14351076795461021}]
[]
[]
[null,"Key"]
[null,"Blue = Assumptions and sourced data"]
[null,"Black = calculated data"]
[null,"RIN DATA :  2018-19 Actual O & M",null,24492885.879999999]
[null,"Difference",null,{"$f":"D78-D59","v":3408813.3319999985}]
[]
[null,"PTRM Input Data ($M)"]
[null,"PL Opex (Real 2018/19 mid year)"]
[null,{"$f":"B55","v":"Opex Conventional/MV "},null,null,null,{"$f":"F59/10^6","v":20.60632882850139},{"$f":"G59/10^6","v":19.569796713911835},17.784373705589399,15.772054391018191,13.493624706248237]
[null,{"$f":"B61","v":"Opex LED"},null,null,null,{"$f":"F65/10^6","v":0.54366545417358925},{"$f":"G65/10^6","v":1.0745844720148974},2.0296456019629594,3.2067525514985049,4.621117654684439]
[null,"Total PL Opex",null,null,null,{"$f":"SUM(F83:F84)","v":21.149994282674978},{"$f":"SUM(G83:G84)","v":20.644381185926733},19.814019307552357,18.978806942516695,18.114742360932677]
[]
[]
[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+E89)*(1+E90)-1","v":2.5067997744539827E-2}]
[]
[null,{"$f":"B83","v":"Opex Conventional/MV "},null,null,null,{"$f":"F83*(1+$E$91)","v":21.122888233097509},{"$f":"G83*(1+$E$91)","v":20.060372333797279},18.230192345529169,16.167428214918996,13.831882859950134]
[null,{"$f":"B84","v":"Opex LED"},null,null,null,{"$f":"F84*(1+$E$91)","v":0.55729405855259695},1.1015221531356842,2.0805247533351818,3.2871394172267667,4.7369598216293216]
[null,"Total PL Opex",null,null,null,{"$f":"SUM(F93:F94)","v":21.680182291650105},{"$f":"SUM(G93:G94)","v":21.161894486932962},20.310717098864352,19.454567632145761,18.568842681579454]