{"text_format":"1","workbook":"xlsx","n_sheets":13,"sheets":["Overview of the model","R1 Results","R1.1 Case studies","Inputs ->","I1 General","I2 Capex","I3 Opex","I4 Benefits","Calculations ->","S1","S2","S3","Weighted"],"not_rendered":{"charts":1,"images":2,"macros":0,"external_links":8,"defined_names":154,"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":"Overview of the model","index":0,"n_rows":36,"n_cols":4,"rows_kept":36,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[null,"Transgrid Operability RIT-T PACR NPV assessment"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Creation Date",null,"2025-09-25"]
[null,"Client",null,"Transgrid"]
[null,"Description",null,"Operability RIT-T PACR NPV assessment"]
[null,"Creators",null,"Houston Kemp Economists"]
[]
[null,"Cell legend applied throughout the model"]
[null,null,null,"Table Row Name"]
[null,null,null,"Input Cell"]
[null,null,null,"Calculation cell"]
[null,null,null,"Parameter Cell"]
[null,null,null,"Output Cell"]

{"sheet":"R1 Results","index":1,"n_rows":53,"n_cols":12,"rows_kept":53,"cut":false,"hidden":false,"merged":[[43,1,44,1],[33,1,34,1],[35,1,36,1],[37,1,38,1],[39,1,40,1],[41,1,42,1]]}
["R1 Results"]
["Interface for scenario settings and key results"]
[]
[null,"Scenario settings"]
[]
[null,"Parameters",null,null,null,"S1","S2","S3","S4",null,"Sensitivity parameters"]
[null,"General parameters",null,null,"Unit","Step","Progressive","Green","[Spare scenario]",null,"Upper bound","Lower bound"]
[null,"Commercial discount rate",null,null,"Percent",7.0000000000000007E-2,7.0000000000000007E-2,7.0000000000000007E-2,7.0000000000000007E-2,null,0.1,4.1799999999999997E-2]
[null,"VCR for involuntary load shedding",null,null,"$/MWh",1,1,1,20000,null,1,1]
[]
[null,"Cost parameters",null,null,"Unit","Step","Progressive","Green","[Spare scenario]",null,"Upper bound","Lower bound"]
[null,"Capital cost",null,null,"Factor",1,1,1,1,null,1.3,0.7]
[null,"Planned routine maintenance and refurbishment ",null,null,"Factor",1,1,1,1,null,1.3,0.7]
[]
[null,"Benefit parameters",null,null,"Unit","Step","Progressive","Green","[Spare scenario]",null,"Upper bound","Lower bound"]
[null,"Involuntary load shedding",null,null,"Factor",1,1,1,1,null,1,1]
[null,"Avoided generation dispatch costs",null,null,"Factor",1,1,1,1,null,1,1]
[null,"Greenhouse gases",null,null,"Factor",1,1,1,1,null,1,1]
[]
[null,"Scenario weightings",null,null,"Unit","Step","Progressive","Green","[Spare scenario]"]
[null,"Weightings",null,null,"%",0.43,0.42,0.15,0]
[]
[]
[null,"Weighted NPV results"]
[]
[null,"Net present value ($, PV)","S1","S2","S3","S4",null,null,null,"Weighted NPV results"]
[null,"Option ","Step","Progressive","Green","[Spare scenario]","Weighted NPV","Rank"]
[null,"Option 1",47869156.776071176,39951182.367824793,97787001.346470103,-137225168.38248974,52031284.210167535,2]
[null,"Option 2",135540244.39515078,73590684.011477292,198103466.78129774,-177929670.34468925,118905912.39192995,1]
[]
[null,"Sensitivities"]
[]
[null,"Sensitivity",null,"Option 1","Option 2"]
[null,"Capital cost ","High (+25%)",19.889177940687272,76.300594094316452]
[null,null,"Low (-25%)",64.975608222481682,135.03744258676224]
[null,"Operating cost ","High (+25%)",43.748478834850239,107.86507935111727]
[null,null,"Low (-25%)",60.314089585484815,129.94674543274263]
[null,"Discount rate ","High (10.0%)",30.720639085714435,77.017555203298983]
[null,null,"Low (4.18%)",80.945728162864384,175.81472042944679]
[null,"Value of customer reliability","High (+30%)",83.081506228695346,167.04614210272604]
[null,null,"Low (-30%)",20.981062191639726,70.765682681133825]
[null,"Value of emissions reduction","High (+25%)",61.406792421303642,133.65068922704086]
[null,null,"Low (-25%)",42.655775999031427,104.16113555681905]
[null,"Total gross benefits ","High (+25%)",99.345397358331866,193.11480807608473]
[null,null,"Low (-25%)",4.7171710620032155,44.697016707775155]
[]
[null,"Threshold tests"]
[]
[null,null,"Option 2 no longer preferred","Option 2 to have zero NPV"]
[null,"Capital costs",1.597217835191711,0.72576455243080984]
[null,"Operating costs",6.061816295246472,2.6924126094559981]
[null,"Total costs",1.2806070978671245,0.56437685025663864]
[null,"Gross benefits",-0.62163198468207614,-0.40057836495105981]

{"sheet":"R1.1 Case studies","index":2,"n_rows":159,"n_cols":19,"rows_kept":159,"cut":false,"hidden":false,"merged":[]}
["R1.1 Case studies"]
["Insert description"]
[]
[null,"Outputs","$2024/25"]
[]
[null,"Inputs"]
[]
[null,"Scenario","Weighting"]
[null,"Step change",0.43]
[null,"Progressive change",0.42]
[null,"Green energy exports",0.15]
[]
[null,"Key outputs (weighted)"]
[]
[null,"Incremental gross benefits","Case study 1","Case study 2","Case study 3","Total","Check"]
[null,"Option 1",103500740.06175932,10911282.019867275,74844430.511030614,189256452.59265721,true,189256452.59265727]
[null,"Option 2",160467432.3693203,61523719.856268123,74844430.511030614,296835582.73661906,true,296835582.73661911]
[]
[null,"Incremental capex (NPV)","Case study 1","Case study 2","Case study 3","Enabling tech","Total","Check"]
[null,"Option 1",20730681.595153354,1609288.7755626861,2330715.8784438977,79423260.632060647,104093946.88122058,true,104093946.88122058]
[null,"Option 2",29992418.173151605,7526470.9912807699,2330715.8784438977,93916733.138562202,133766338.18143848,false,133766338.18143854]
[]
[null,"Incremental opex (NPV)","Case study 1","Case study 2","Case study 3","Enabling tech","Total","Check"]
[null,"Option 1",11194749.768605413,0,0,21936471.73266371,33131221.501269124,true,33131222]
[null,"Option 2",16316098.819697132,1697683.2443885393,0,26149550.099165048,44163332.163250715,true,44163332]
[]
[]
[null,"Case study 1 - total gross benefits"]
[]
[null,"Base case"]
[null,"Scenario","NPV",2025,2026,2027,2028,2029,2030,2031,2032,2033,2034,2035,2036,2037,2038,2039]
[null,"Step change",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Progressive change",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Green energy exports",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"Option 1"]
[null,"Scenario","NPV",2025,2026,2027,2028,2029,2030,2031,2032,2033,2034,2035,2036,2037,2038,2039]
[null,"Step change",94589185.195595846,8639961.9368104246,9871827.2031732351,1715881.7517046314,2593947.5922763105,2948869.053945452,4915093.7679315452,8724544.2395891007,9953106.6842633914,11286014.578627951,12825235.691948764,14566524.673798833,16581015.20000184,18761865.322531275,21277690.408938605,24119978.443952776]
[null,"Progressive change",112766419.88056251,8328611.9571055453,9173163.675767418,10095142.436452072,11131664.104420278,2454479.913765002,13395495.267295701,14700015.772647487,16165699.800629113,17670028.756844968,19356320.443650417,9728026.3144047353,10674331.946429584,11643040.277436245,12728454.375146581,13908775.549176848]
[null,"Green energy exports",103103293.8521124,8795636.9266628642,1557635.280991951,1810313.3315121997,2786012.4715358615,3224280.4604068827,5470973.3051209822,9886236.6488502659,11481599.049427133,13253780.969182586,15332748.14180639,17728257.880933288,20543606.781810902,23664484.873354893,27321276.80452418,31528904.843437634]
[]
[null,"Option 2"]
[null,"Scenario","NPV",2025,2026,2027,2028,2029,2030,2031,2032,2033,2034,2035,2036,2037,2038,2039]
[null,"Step change",165977030.42172465,8639961.9368104246,9871827.2031732351,1715881.7517046314,2593947.5922763105,3753724.4036966376,6837537.1453202404,19006064.923033267,21682438.260625478,24586123.918125167,27939254.535301875,31732581.788848314,36121067.499553241,40871960.827380724,34686574.539243698,39320030.233622223]
[null,"Progressive change",150677709.02163801,8328611.9571055453,9173163.675767418,10095142.436452072,11131664.104420278,12198745.828775713,13395495.267295701,14700015.772647487,16165699.800629113,17670028.756844968,19356320.443650417,21192109.825700212,23253598.172298752,25363889.887830574,27728420.371365581,30299702.062144961]
[null,"Green energy exports",172084476.65927172,8795636.9266628642,1557635.280991951,1810313.3315121997,2786012.4715358615,4104305.7616947126,7610838.1571248919,11681548.943882467,25012196.736127343,28872822.998925023,33401768.462511074,38620289.037947878,33489882.324955881,38577491.387298338,44538739.222811691,51397951.891112916]
[]
[null,"Case study 1 - incremental gross benefits"]
[]
[null,"Option 1"]
[null,"Scenario","NPV",2025,2026,2027,2028,2029,2030,2031,2032,2033,2034,2035,2036,2037,2038,2039]
[null,"Step change",94589185.195595846,8639961.9368104246,9871827.2031732351,1715881.7517046314,2593947.5922763105,2948869.053945452,4915093.7679315452,8724544.2395891007,9953106.6842633914,11286014.578627951,12825235.691948764,14566524.673798833,16581015.20000184,18761865.322531275,21277690.408938605,24119978.443952776]
[null,"Progressive change",112766419.88056251,8328611.9571055453,9173163.675767418,10095142.436452072,11131664.104420278,2454479.913765002,13395495.267295701,14700015.772647487,16165699.800629113,17670028.756844968,19356320.443650417,9728026.3144047353,10674331.946429584,11643040.277436245,12728454.375146581,13908775.549176848]
[null,"Green energy exports",103103293.8521124,8795636.9266628642,1557635.280991951,1810313.3315121997,2786012.4715358615,3224280.4604068827,5470973.3051209822,9886236.6488502659,11481599.049427133,13253780.969182586,15332748.14180639,17728257.880933288,20543606.781810902,23664484.873354893,27321276.80452418,31528904.843437634]
[null,"Weighted",103500740.06175932]
[]
[null,"Option 2"]
[null,"Scenario","NPV",2025,2026,2027,2028,2029,2030,2031,2032,2033,2034,2035,2036,2037,2038,2039]
[null,"Step change",165977030.42172465,8639961.9368104246,9871827.2031732351,1715881.7517046314,2593947.5922763105,3753724.4036966376,6837537.1453202404,19006064.923033267,21682438.260625478,24586123.918125167,27939254.535301875,31732581.788848314,36121067.499553241,40871960.827380724,34686574.539243698,39320030.233622223]
[null,"Progressive change",150677709.02163801,8328611.9571055453,9173163.675767418,10095142.436452072,11131664.104420278,12198745.828775713,13395495.267295701,14700015.772647487,16165699.800629113,17670028.756844968,19356320.443650417,21192109.825700212,23253598.172298752,25363889.887830574,27728420.371365581,30299702.062144961]
[null,"Green energy exports",172084476.65927172,8795636.9266628642,1557635.280991951,1810313.3315121997,2786012.4715358615,4104305.7616947126,7610838.1571248919,11681548.943882467,25012196.736127343,28872822.998925023,33401768.462511074,38620289.037947878,33489882.324955881,38577491.387298338,44538739.222811691,51397951.891112916]
[null,"Weighted",160467432.3693203]
[]
[null,"Case study 2 - total gross benefits"]
[]
[null,"Scenario","NPV",2025,2026,2027,2028,2029,2030,2031,2032,2033,2034,2035,2036,2037,2038,2039]
["Base","Step change",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Option 1","Step change",12235935.965351801,0,0,0,0,0,417544.77161465306,1611156.4866317243,1719807.9722266933,1879103.7721582819,2183720.7453818559,2495979.8684509778,2881249.9883859446,3166290.5657192501,4081207.8394655827,4577073.7055827398]
["Option 2","Step change",69223680.320502013,0,0,0,0,366735.56096865411,1252634.3148439592,4296417.2976845978,10318847.833360162,11274622.632949691,13102324.472291134,14975879.210705865,17287499.930315666,18997743.394315504,24487247.036793496,27462442.233496442]
["Base","Progressive change",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Option 1","Progressive change",7884038.0869483128,0,0,0,0,0,188395.91219976387,1254832.653575338,1272254.9727108274,1278757.2767545201,1422436.953524102,1659197.1081223232,1990936.9193094694,2133663.026557385,2327554.6047513313,2322625.8757944815]
["Option 2","Progressive change",44316752.551724732,0,0,0,0,265639.38032387587,565187.73659929167,3346220.4095342346,7633529.8362649651,7672543.6605271213,8534621.7211446129,9955182.64873394,11945621.515856817,12801978.159344312,13965327.628507989,13935755.254766891]
["Base","Green energy exports",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Option 1","Green energy exports",15590223.721651396,0,0,0,0,0,653319.97011751565,2189367.9102063826,2416860.9816167708,2698715.1676802905,2975706.2841263507,3514841.1736779837,3781223.6391326664,3997141.0654905029,4478505.4220853392,4524775.170151771]
["Option 2","Green energy exports",87630008.311519116,0,0,0,0,457447.59960190748,1959959.910352547,5838314.4272170207,14501165.889700625,16192291.006081743,17854237.704758108,21089047.0420679,22687341.834795997,23982846.392943013,26871032.532512043,27148651.020910628]
[]
[null,"Case study 2 - incremental gross benefits"]
[]
[null,"Option 1"]
[null,"Scenario","NPV",2025,2026,2027,2028,2029,2030,2031,2032,2033,2034,2035,2036,2037,2038,2039]
[null,"Step change",12235935.965351801,0,0,0,0,0,417544.77161465306,1611156.4866317243,1719807.9722266933,1879103.7721582819,2183720.7453818559,2495979.8684509778,2881249.9883859446,3166290.5657192501,4081207.8394655827,4577073.7055827398]
[null,"Progressive change",7884038.0869483128,0,0,0,0,0,188395.91219976387,1254832.653575338,1272254.9727108274,1278757.2767545201,1422436.953524102,1659197.1081223232,1990936.9193094694,2133663.026557385,2327554.6047513313,2322625.8757944815]
[null,"Green energy exports",15590223.721651396,0,0,0,0,0,653319.97011751565,2189367.9102063826,2416860.9816167708,2698715.1676802905,2975706.2841263507,3514841.1736779837,3781223.6391326664,3997141.0654905029,4478505.4220853392,4524775.170151771]
[null,"Weighted",10911282.019867275]
[]
[null,"Option 2"]
[null,"Scenario","NPV",2025,2026,2027,2028,2029,2030,2031,2032,2033,2034,2035,2036,2037,2038,2039]
[null,"Step change",69223680.320502013,0,0,0,0,366735.56096865411,1252634.3148439592,4296417.2976845978,10318847.833360162,11274622.632949691,13102324.472291134,14975879.210705865,17287499.930315666,18997743.394315504,24487247.036793496,27462442.233496442]
[null,"Progressive change",44316752.551724732,0,0,0,0,265639.38032387587,565187.73659929167,3346220.4095342346,7633529.8362649651,7672543.6605271213,8534621.7211446129,9955182.64873394,11945621.515856817,12801978.159344312,13965327.628507989,13935755.254766891]
[null,"Green energy exports",87630008.311519116,0,0,0,0,457447.59960190748,1959959.910352547,5838314.4272170207,14501165.889700625,16192291.006081743,17854237.704758108,21089047.0420679,22687341.834795997,23982846.392943013,26871032.532512043,27148651.020910628]
[null,"Weighted",61523719.856268123]
[]
[null,"Case study 3 - total gross benefits"]
[]
[null,"Scenario","NPV",2025,2026,2027,2028,2029,2030,2031,2032,2033,2034,2035,2036,2037,2038,2039]
["Base","Step change",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Option 1","Step change",78269203.997613207,0,0,0,2330163.8971068515,9902714.0821856614,8144210.1897186954,10076374.70831974,10333843.73911047,10852145.454831861,12135847.352056554,13342525.216798056,14815230.542356603,15643638.244943015,19405216.765157036,20935342.640343241]
["Option 2","Step change",78269203.997613207,0,0,0,2330163.8971068515,9902714.0821856614,8144210.1897186954,10076374.70831974,10333843.73911047,10852145.454831861,12135847.352056554,13342525.216798056,14815230.542356603,15643638.244943015,19405216.765157036,20935342.640343241]
["Base","Progressive change",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Option 1","Progressive change",56525892.78280367,0,0,0,1869186.9487816214,7572572.2774390914,3918639.2689042194,8443759.5756403171,8318010.8232768616,8124546.7558612507,8784759.5763824675,9961266.2548567057,11620810.933835533,12106587.761744456,12838074.561984409,12449483.185904462]
["Option 2","Progressive change",56525892.78280367,0,0,0,1869186.9487816214,7572572.2774390914,3918639.2689042194,8443759.5756403171,8318010.8232768616,8124546.7558612507,8784759.5763824675,9961266.2548567057,11620810.933835533,12106587.761744456,12838074.561984409,12449483.185904462]
["Base","Green energy exports",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Option 1","Green energy exports",116318652.15519595,0,0,0,3203564.2178111011,13926600.281612605,13537327.156468866,14851184.939638155,16305354.44281859,17817821.417887516,18829914.236528285,21311902.564030759,22803231.095898882,23745457.727274463,25274403.821323395,25955140.845857944]
["Option 2","Green energy exports",116318652.15519595,0,0,0,3203564.2178111011,13926600.281612605,13537327.156468866,14851184.939638155,16305354.44281859,17817821.417887516,18829914.236528285,21311902.564030759,22803231.095898882,23745457.727274463,25274403.821323395,25955140.845857944]
[]
[null,"Case study 3 - incremental gross benefits"]
[]
[null,"Option 1"]
[null,"Scenario","NPV",2025,2026,2027,2028,2029,2030,2031,2032,2033,2034,2035,2036,2037,2038,2039]
[null,"Step change",78269203.997613207,0,0,0,2330163.8971068515,9902714.0821856614,8144210.1897186954,10076374.70831974,10333843.73911047,10852145.454831861,12135847.352056554,13342525.216798056,14815230.542356603,15643638.244943015,19405216.765157036,20935342.640343241]
[null,"Progressive change",56525892.78280367,0,0,0,1869186.9487816214,7572572.2774390914,3918639.2689042194,8443759.5756403171,8318010.8232768616,8124546.7558612507,8784759.5763824675,9961266.2548567057,11620810.933835533,12106587.761744456,12838074.561984409,12449483.185904462]
[null,"Green energy exports",116318652.15519595,0,0,0,3203564.2178111011,13926600.281612605,13537327.156468866,14851184.939638155,16305354.44281859,17817821.417887516,18829914.236528285,21311902.564030759,22803231.095898882,23745457.727274463,25274403.821323395,25955140.845857944]
[null,"Weighted",74844430.511030614]
[]
[null,"Option 2"]
[null,"Scenario","NPV",2025,2026,2027,2028,2029,2030,2031,2032,2033,2034,2035,2036,2037,2038,2039]
[null,"Step change",78269203.997613207,0,0,0,2330163.8971068515,9902714.0821856614,8144210.1897186954,10076374.70831974,10333843.73911047,10852145.454831861,12135847.352056554,13342525.216798056,14815230.542356603,15643638.244943015,19405216.765157036,20935342.640343241]
[null,"Progressive change",56525892.78280367,0,0,0,1869186.9487816214,7572572.2774390914,3918639.2689042194,8443759.5756403171,8318010.8232768616,8124546.7558612507,8784759.5763824675,9961266.2548567057,11620810.933835533,12106587.761744456,12838074.561984409,12449483.185904462]
[null,"Green energy exports",116318652.15519595,0,0,0,3203564.2178111011,13926600.281612605,13537327.156468866,14851184.939638155,16305354.44281859,17817821.417887516,18829914.236528285,21311902.564030759,22803231.095898882,23745457.727274463,25274403.821323395,25955140.845857944]
[null,"Weighted",74844430.511030614]
[]
[null,"Capex"]
[]
[null,"Function","Option","NPV",2025,2026,2027,2028,2029,2030,2031,2032,2033,2034,2035,2036,2037,2038,2039]
[null,"Enabling","Base case",27798740.36427369,0,0,0,0,10000000,15000000,5000000,0,0,5000000,5000000,10000000,15000000,5000000,-32500000]
[null,"Enabling","Option 1",107222000.99633434,5200000,1689542.2594698702,25332100.426614434,38009848.791108377,11940332.391119469,15454121.185789671,6316127.9557325197,12803426.764446251,6185953.6126930285,12435801.160349913,9227489.5582090728,15714788.366922803,6185953.6126930285,6185953.6126930285,-33147390.521870729]
[null,"CS1","Option 1",20730681.595153354,2990000,0,3217475.1398260873,8012536.9466280192,10052367.249704348,3156792.4878531401,0,0,0,0,0,0,0,0,-3944783.251863189]
[null,"CS2","Option 1",1609288.7755626861,0,0,0,0,1743115.8704115939,652598.7836057971,0,0,0,0,0,0,0,0,-479142.93080347823]
[null,"CS3","Option 1",2330715.8784438977,0,0,387904.81815652177,1082336.7468695655,0,0,588096.62601043493,588096.62601043493,0,0,588096.62601043493,588096.62601043493,0,0,-588096.62601043493]
[null,"Enabling","Option 2",121715473.5028359,5200000,2220875.3601663643,22696531.138527445,40618197.618642852,20813004.752497453,7267691.664378088,17794915.582663089,21104457.052676272,14541762.800201112,0,11380242.529598517,24069670.026802458,14541762.800201112,0,-43168562.800245851]
[null,"CS1","Option 2",29992418.173151605,2990000,0,1167577.3357554777,5936971.9381152447,12522782.251354851,20077792.242700871,2457421.5766847292,0,0,0,0,0,0,0,-11268115.439780977]
[null,"CS2","Option 2",7526470.9912807699,0,0,0,0,1136691.0010086205,10424254.534628492,685416.71282266011,0,0,0,0,0,0,0,-3171021.0691344831]
[null,"CS3","Option 2",2330715.8784438977,0,0,387904.81815652177,1082336.7468695655,0,0,588096.62601043493,588096.62601043493,0,0,588096.62601043493,588096.62601043493,0,0,-588096.62601043493]
[]
[null,"Opex"]
[]
[null,"Function","Option","NPV",2025,2026,2027,2028,2029,2030,2031,2032,2033,2034,2035,2036,2037,2038,2039]
[null,"Enabling","Base case",452263.12585986243,0,0,0,0,250000,250000,125000,0,0,0,0,0,0,0,0]
[null,"CS1","Base case",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Enabling","Option 1",22388734.858523574,0,0,0,0,1387670,2533480.3333333335,4202931,4202931,4202931,4202931,4202931,4202931,4202931,4202931,4202931]
[null,"CS1","Option 1",11194749.768605413,0,0,0,788579.16666666674,1096295,1596295,1846295,1846295,1846295,1846295,1846295,1846295,1846295,1846295,1846295]
[null,"CS2","Option 1",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"CS3","Option 1",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Enabling","Option 2",26601813.225024913,0,0,0,0,1844840,2850910.3333333335,5184087.666666666,4952931,4952931,4952931,4952931,4952931,4952931,4952931,4952931]
[null,"CS1","Option 2",16316098.819697132,0,0,0,788579.16666666674,1096295,2416295,2724025,2839485,2839485,2839485,2839485,2839485,2839485,2839485,2839485]
[null,"CS2","Option 2",1697683.2443885393,0,0,0,0,0,0,134703.33333333334,404110,404110,404110,404110,404110,404110,404110,404110]
[null,"CS3","Option 2",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"Outage management system deep dive"]
[]
[null,null,"Option","NPV",2025,2026,2027,2028,2029,2030,2031,2032,2033,2034,2035,2036,2037,2038,2039]
[null,null,"Base case",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Option 1",2330715.8784438977,0,0,387904.81815652177,1082336.7468695655,0,0,588096.62601043493,588096.62601043493,0,0,588096.62601043493,588096.62601043493,0,0,-588096.62601043493]
[null,null,"Option 2",2330715.8784438977,0,0,387904.81815652177,1082336.7468695655,0,0,588096.62601043493,588096.62601043493,0,0,588096.62601043493,588096.62601043493,0,0,-588096.62601043493]
[]
[null,null,"Option","NPV cost","NPV benefit"]
[null,null,"Base case",0,0]
[null,null,"Option 1",2330715.8784438977,74844430.511030614]
[null,null,"Option 2",2330715.8784438977,74844430.511030614]

{"sheet":"Inputs ->","index":3,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"I1 General","index":4,"n_rows":60,"n_cols":10,"rows_kept":60,"cut":false,"hidden":false,"merged":[]}
["I1 General"]
["Inputs and parameters for RIT-T assessment"]
[]
[null,"General parameter and option inputs"]
[]
[null,"General parameters"]
[null,"Parameter",null,"Unit","Value","Note"]
[null,"First year of analysis",null,"Financial year",2025,"Earliest initiation of project options"]
[null,"Base year for dollar inputs",null,"Financial year",2025]
[null,"Analysis period",null,"Years",15,""]
[]
[null,"Option descriptions"]
[null,"Option name",null,"Option applicable 1/0","Short description"]
[null,"Base case",null,1]
[null,"Option 1",null,1,"Reactive uplift"]
[null,"Option 2",null,1,"Proactive uplift"]
[null,"Option 3",null,1]
[null,"Option 4",null,1]
[null,"Option 5",null,1]
[null,"Option 6",null,1]
[null,"Option 7",null,1]
[null,"Option 8",null,1]
[null,"Option 9",null,1]
[null,"Option 10",null,1]
[null,"Option 11",null,1]
[null,"Option 12",null,1]
[null,"Option 13",null,1]
[null,"Option 14",null,1]
[null,"Option 15",null,1]
[]
[null,"Scenario inputs"]
[]
[]
[null,"Cost and benefit categories",null,null,null,null,null,null,"Scenarios"]
[]
[null,"Cost categories",null,null,null,null,null,null,"Scenario","Name"]
[null,"Capital cost",null,null,null,null,null,null,"S1","Step"]
[null,"Planned routine maintenance and refurbishment ",null,null,null,null,null,null,"S2","Progressive"]
[null,null,null,null,null,null,null,null,"S3","Green"]
[]
[null,"Benefit categories",null,null,"Benefit input category"]
[null,"Involuntary load shedding",null,null,"Involuntary load shedding"]
[null,"Avoided generation dispatch costs",null,null,"Avoided generation dispatch costs"]
[null,"Greenhouse gases",null,null,"Greenhouse gases"]
[]
[]
[null,"RIT market benefits"]
[]
[null,"NER","RIT-T market benefits"]
[null,"5.15A.2(c)(4)(i)","changes in fuel consumption arising through different patterns of generation dispatch"]
[null,"5.15A.2(c)(4)(ii)","changes in voluntary load curtailment"]
[null,"5.15A.2(c)(4)(iii)","changes in involuntary load shedding"]
[null,"5.15A.2(c)(4)(iv)","changes in costs for parties, other than the RIT-T proponent"]
[null,"5.15A.2(c)(4)(v)","differences in the timing of expenditure"]
[null,"5.15A.2(c)(4)(vi)","changes in network losses"]
[null,"5.15A.2(c)(4)(vii)","changes in ancillary services costs"]
[null,"5.15A.2(c)(4)(viii)","changes in Austraia's greenhouse gas emissions"]
[null,"5.15A.2(c)(4)(ix)","competition benefits"]
[null,"5.15A.2(c)(4)(x)","any additional option value"]
[null,"5.15A.2(c)(4)(xi)","other classes of market benefits"]

{"sheet":"I2 Capex","index":5,"n_rows":76,"n_cols":25,"rows_kept":76,"cut":false,"hidden":false,"merged":[]}
["I2 Capex"]
["Inputs and parameters for RIT-T assessment"]
[]
[]
[null,"Cost inputs",null,null,null,null,null,null,"All inputs based on financial years"]
[]
[null,null,null,null,null,null,null,null,null,null,2025,2026,2027,2028,2029,2030,2031,2032,2033,2034,2035,2036,2037,2038,2039]
[null,null,null,null,null,null,null,null,null,null,0,1,2,3,4,5,6,7,8,9,10,11,12,13,14]
[null,null,null,null,null,null,null,null,null,null,1,0.93457943925233644,0.87343872827321156,0.81629787689085187,0.7628952120475252,0.71298617948366838,0.66634222381651254,0.62274974188459109,0.5820091045650384,0.54393374258414806,0.5083492921347178,0.47509279638758667,0.44401195924073528,0.41496444788853759,0.3878172410173249]
[]
[null,"Capex",null,null,null,null,null,null,null,null,"Build period"]
[null,"Option","UI","Component","Commissioning","Asset life","Build Periods","Unit","Total amount","NPV",2025,2026,2027,2028,2029,2030,2031,2032,2033,2034,2035,2036,2037,2038,2039]
[null,"Base case",1,"SCADA/EMS",2032,7,3,"$, real",30000000,21655455.931812841,0,0,0,0,10000000,15000000,5000000,0,0,0,0,0,0,0,0]
[null,"Base case",2,"SCADA/EMS (hardware refresh)",2036,4,2,"$, real",10000000,5261415.1735943295,0,0,0,0,0,0,0,0,0,5000000,5000000,0,0,0,0]
[null,"Base case",3,"SCADA/EMS (refresh 1)",2039,7,3,"$, real",30000000,13485929.591929583,0,0,0,0,0,0,0,0,0,0,0,10000000,15000000,5000000,0]
[null,"Option 1",4,"Project management",2031,"N/A",5,"$, real",14458480.551772462,11372833.844546473,0,423071.55576521734,3615534.2052043471,2092911.0911884054,3487211.5304057966,4839752.1692086961,0,0,0,0,0,0,0,0,0]
[null,"Option 1",5,"Project management(refresh)",2031,"N/A",9,"$, real",8473507.0269675516,4639938.2571806917,0,0,0,0,0,633033.28859601519,699313.69667165144,1356397.9003534981,626561.61269302899,1259594.9012890442,994199.09914820432,1651283.3028300512,626561.61269302899,626561.61269302899,0]
[null,"Option 1",6,"Data Management and Network Modelling ",2029,4,2,"$, real",21063053.471478257,17512610.027729161,0,0,5580669.3531594202,15482384.118318837,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 1",7,"Data Management and Network Modelling (refresh)",2033,4,3,"$, real",16850442.777182605,11245301.073627964,0,0,0,0,0,5616814.2590608681,5616814.2590608681,5616814.2590608681,0,0,0,0,0,0,0]
[null,"Option 1",8,"Data Management and Network Modelling (refresh) (refresh)",2037,4,3,"$, real",16850442.777182605,8578986.3471036665,0,0,0,0,0,0,0,0,0,5616814.2590608681,5616814.2590608681,5616814.2590608681,0,0,0]
[null,"Option 1",9,"Enhanced EMS/SCADA ",2031,10,5,"$, real",30501792.480730444,24626379.315014243,0,266470.70370465296,6998581.8481083727,13719936.847540526,5602281.6124528013,3914521.4689240898,0,0,0,0,0,0,0,0,0]
[null,"Option 1",10,"Enhanced EMS/SCADA (hardware refresh)",2035,4,2,"$, real",11118784,6259557.6568984101,0,0,0,0,0,0,0,0,5559392,5559392,0,0,0,0,0]
[null,"Option 1",11,"Enhanced EMS/SCADA (hardware refresh) (refresh)",2039,4,2,"$, real",11118784,4775386.5659832228,0,0,0,0,0,0,0,0,0,0,0,0,5559392,5559392,0]
[null,"Option 1",12,"Enhanced EMS/SCADA (refresh)",2041,10,0,"$, real",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 1",13,"Outage Management System and Switching execution ",2029,4,2,"$, real",1470241.5650260872,1222320.2796122613,0,0,387904.81815652177,1082336.7468695655,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 1",14,"Outage Management and Switching Execution  (refresh)",2033,4,2,"$, real",1176193.2520208699,758110.63564597839,0,0,0,0,0,0,588096.62601043493,588096.62601043493,0,0,0,0,0,0,0]
[null,"Option 1",15,"Outage Management and Switching Execution  (refresh) (refresh)",2037,4,2,"$, real",1176193.2520208699,578358.97413662274,0,0,0,0,0,0,0,0,0,0,588096.62601043493,588096.62601043493,0,0,0]
[null,"Option 1",16,"Fault level and system parameter monitoring ",2031,10,2,"$, real",3422449.5057391301,2564440.9500569226,0,0,0,0,2490165.5291594202,932283.97657971014,0,0,0,0,0,0,0,0,0]
[null,"Option 1",17,"Fault Level andsystem parameter monitoring (refresh)",2041,10,0,"$, real",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 1",18,"Alarm Management technologies ",2030,10,4,"$, real",15410511.129391303,13222405.478994215,2990000,0,3217475.1398260873,7512471.3916521734,1690564.5979130436,0,0,0,0,0,0,0,0,0,0]
[null,"Option 1",19,"Alarm Management Technologies (refresh)",2040,10,0,"$, real",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 1",20,"Operator Visualisation and Situational Awareness technology ",2031,10,3,"$, real",10991925.842898551,8268798.7882909914,0,0,0,500065.55497584539,7614752.9930434786,2877107.2948792269,0,0,0,0,0,0,0,0,0]
[null,"Option 1",21,"Operator Visualisation and Situational Awareness technologies  (refresh)",2041,10,0,"$, real",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 1",22,"Training technologies ",2030,10,2,"$, real",6632050.3461739132,5261486.2041179277,0,0,0,3781211.0979130436,2850839.2482608696,0,0,0,0,0,0,0,0,0,0]
[null,"Option 1",23,"Training Technologies  (refresh)",2040,10,0,"$, real",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 1",24,"Operational Documentation Management System ",2029,4,2,"$, real",2979283.7153739128,2478436.466615573,0,0,812964.69997470349,2166319.0153992092,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 1",25,"Opertional Document Management System (refresh)",2033,4,1,"$, real",2383426.9722991302,1484278.5318000556,0,0,0,0,0,0,0,2383426.9722991302,0,0,0,0,0,0,0]
[null,"Option 1",26,"Opertional Document Management System (refresh) (refresh)",2037,4,1,"$, real",2383426.9722991302,1132348.9852551927,0,0,0,0,0,0,0,0,0,0,0,2383426.9722991302,0,0,0]
[null,"Option 1",27,"Operational Planning Systems ",2029,4,2,"$, real",4308484.5409159437,3729331.3657787316,0,0,3715810.6201675907,592673.92074835324,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 1",28,"Operational planning system (refresh)",2033,4,1,"$, real",3446787.632732755,2146486.1086153239,0,0,0,0,0,0,0,3446787.632732755,0,0,0,0,0,0,0]
[null,"Option 1",29,"Operational planning system (refresh) (refresh)",2037,4,1,"$, real",3446787.632732755,1637543.9749891546,0,0,0,0,0,0,0,0,0,0,0,3446787.632732755,0,0,0]
[null,"Option 1",30,"Facilities",2029,8,3,"$, real",5232952.4000000004,4488493.55224506,0,0,4608539.7,174412.7,0,450000,0,0,0,0,0,0,0,0,0]
[null,"Option 1",31,"Facilities(refresh)",2037,8,2,"$, real",5232952.4000000004,2573152.8186969031,0,0,0,0,0,0,0,0,0,0,2616476.2000000002,2616476.2000000002,0,0,0]
[null,"Option 1",32,"CPA submission ",2032,"N/A",2,"$, real",6200000,6134579.4392523365,5200000,1000000,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 2",33,"Data Management and Network Modelling ",2030,4,3,"$, real",28098033.563686855,22619162.984044507,0,0,2779235.9803789253,16405196.168306807,8913601.4150011241,0,0,0,0,0,0,0,0,0,0]
[null,"Option 2",34,"Data Management and Network Modelling (refresh)",2034,4,3,"$, real",22478426.850949485,14019802.846236922,0,0,0,0,0,0,7492808.9503164953,7492808.9503164953,7492808.9503164953,0,0,0,0,0,0]
[null,"Option 2",35,"Data Management and Network Modelling (refresh) (refresh)",2038,4,3,"$, real",22478426.850949485,10695640.465244412,0,0,0,0,0,0,0,0,0,0,7492808.9503164953,7492808.9503164953,7492808.9503164953,0,0]
[null,"Option 2",36,"Enhanced EMS/SCADA ",2032,10,6,"$, real",34667093.416334681,27246700.995640364,0,324279.57949586608,5888877.5561953578,13640049.182315217,5589935.6451846845,5464279.123619467,3759672.3295240891,0,0,0,0,0,0,0,0]
[null,"Option 2",37,"Enhanced EMS/SCADA (hardware refresh)",2034,4,2,"$, real",11118784,6697726.6928812992,0,0,0,0,0,0,0,5559392,5559392,0,0,0,0,0,0]
[null,"Option 2",38,"Enhanced EMS/SCADA (hardware refresh) (refresh)",2038,4,2,"$, real",11118784,5109663.6256020479,0,0,0,0,0,0,0,0,0,0,0,5559392,5559392,0,0]
[null,"Option 2",39,"Enhanced EMS/SCADA (refresh)",2042,10,0,"$, real",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 2",40,"Outage Management System and Switching execution ",2029,4,2,"$, real",1470241.5650260872,1222320.2796122613,0,0,387904.81815652177,1082336.7468695655,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 2",41,"Outage Management System and Switching execution (refresh)",2033,4,2,"$, real",1176193.2520208699,758110.63564597839,0,0,0,0,0,0,588096.62601043493,588096.62601043493,0,0,0,0,0,0,0]
[null,"Option 2",42,"Outage Management System and Switching execution (refresh)(refresh)",2037,4,2,"$, real",1176193.2520208699,578358.97413662274,0,0,0,0,0,0,0,0,0,0,588096.62601043493,588096.62601043493,0,0,0]
[null,"Option 2",43,"Fault level and system parameter monitoring ",2031,10,2,"$, real",7184108.6486206912,5203214.6757819066,0,0,0,0,1623844.2871551723,5560264.3614655184,0,0,0,0,0,0,0,0,0]
[null,"Option 2",44,"Fault level and system parameter monitoring (refresh)",2041,10,0,"$, real",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 2",45,"Alarm Management technologies ",2031,10,5,"$, real",20621249.041437559,16645125.920389077,2990000,0,1167577.3357554777,5936971.9381152447,5682130.1561036501,4844569.6114631873,0,0,0,0,0,0,0,0,0]
[null,"Option 2",46,"Alarm Management technologies (refresh)",2041,10,0,"$, real",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 2",47,"Operator Visualisation and Situational Awareness technology ",2032,10,3,"$, real",14683682.917380512,10711653.470403509,0,0,0,0,6353498.8091046484,6728551.2386206891,1601632.8696551726,0,0,0,0,0,0,0,0]
[null,"Option 2",48,"Operator Visualisation and Situational Awareness technology (refresh)",2042,10,0,"$, real",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 2",49,"Training technologies ",2030,10,2,"$, real",6632050.3461739132,5261486.2041179277,0,0,0,3781211.0979130436,2850839.2482608696,0,0,0,0,0,0,0,0,0,0]
[null,"Option 2",50,"Training technologies (refresh)",2040,10,0,"$, real",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 2",51,"Operational Documentation Management System ",2029,4,2,"$, real",2979283.7153739128,2478436.466615573,0,0,812964.69997470349,2166319.0153992092,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 2",52,"Operational Documentation Management System (refresh)",2033,4,1,"$, real",2383426.9722991302,1484278.5318000556,0,0,0,0,0,0,0,2383426.9722991302,0,0,0,0,0,0,0]
[null,"Option 2",53,"Operational Documentation Management System (refresh)(refresh)",2037,4,1,"$, real",2383426.9722991302,1132348.9852551927,0,0,0,0,0,0,0,0,0,0,0,2383426.9722991302,0,0,0]
[null,"Option 2",54,"Operational Planning Systems ",2029,4,2,"$, real",4308484.5409159437,3729331.3657787316,0,0,3715810.6201675907,592673.92074835324,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 2",55,"Operational Planning Systems (refresh)",2033,4,1,"$, real",3446787.632732755,2146486.1086153239,0,0,0,0,0,0,0,3446787.632732755,0,0,0,0,0,0,0]
[null,"Option 2",56,"Operational Planning Systems (refresh)(refresh)",2037,4,1,"$, real",3446787.632732755,1637543.9749891546,0,0,0,0,0,0,0,0,0,0,0,3446787.632732755,0,0,0]
[null,"Option 2",57,"Facilities",2029,8,3,"$, real",5322952.4000000004,4527474.5723383259,0,0,4608539.7,174412.7,0,0,540000,0,0,0,0,0,0,0,0]
[null,"Option 2",58,"Facilities (refresh)",2037,8,2,"$, real",5322952.4000000004,2617407.7126804069,0,0,0,0,0,0,0,0,0,0,2661476.2000000002,2661476.2000000002,0,0,0]
[null,"Option 2",59,"Operational forecasts and look-ahead contingency assessment ",2032,10,2,"$, real",4187958.5178160928,2962950.9859248828,0,0,0,0,0,3694742.2543185558,493216.263497537,0,0,0,0,0,0,0,0]
[null,"Option 2",60,"Wide Area Monitoring ",2032,10,2,"$, real",6721015.8339080466,4766038.2413114998,0,0,0,0,0,6164605.8985878499,556409.93532019702,0,0,0,0,0,0,0,0]
[null,"Option 2",61,"Smart Transmission Device Management ",2032,10,2,"$, real",4000892.6339080459,2829651.9541816213,0,0,0,0,0,3509313.4128735634,491579.22103448276,0,0,0,0,0,0,0,0]
[null,"Option 2",62,"CPA submission ",2027,"N/A",2,"$, real",6200000,6134579.4392523365,5200000,1000000,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 2",63,"Project management",2032,"N/A",6,"$, real",19988288.578917652,15569109.696002468,0,896595.78067049815,4891102.5818108711,3858335.533960219,3458628.444050774,1803412.5407586207,5080213.6976666683,0,0,0,0,0,0,0,0]
[null,"Option 2",64,"Project management(refresh)",2032,"N/A",6,"$, real",9875121.4529890586,5349805.7596153263,0,0,0,0,0,0,922220.60515583563,2222041.4973278912,1489561.8498846162,0,1225957.3792820221,2525778.2714540777,1489561.8498846162,0,0]

{"sheet":"I3 Opex","index":6,"n_rows":10,"n_cols":34,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["I3 Opex"]
["Inputs and parameters for RIT-T assessment"]
[]
[]
[null,"Cost inputs",null,null,"All inputs based on financial years"]
[null,"Opex"]
[null,"Option","Cost type","Unit",2025,2026,2027,2028,2029,2030,2031,2032,2033,2034,2035,2036,2037,2038,2039,2040,2041,2042,2043,2044,2045,2046,2047,2048,2049,2050,2051,2052,2053,2054]
[null,"Base case","Planned routine maintenance and refurbishment ","$, real",0,0,0,0,250000,250000,125000,0,0,0,0,0,0,0,0]
[null,"Option 1","Planned routine maintenance and refurbishment ","$, real",0,0,0,788579.16666666674,2483965,4129775.3333333335,6049226,6049226,6049226,6049226,6049226,6049226,6049226,6049226,6049226]
[null,"Option 2","Planned routine maintenance and refurbishment ","$, real",0,0,0,788579.16666666674,2941135,5267205.333333334,8042816,8196526,8196526,8196526,8196526,8196526,8196526,8196526,8196526]

{"sheet":"I4 Benefits","index":7,"n_rows":263,"n_cols":35,"rows_kept":263,"cut":false,"hidden":false,"merged":[]}
["I4 Benefits"]
["Inputs and parameters for RIT-T assessment"]
[]
[]
[null,"Benefit inputs",null,null,null,"All inputs based on financial years"]
[null,"Market benefits"]
[null,"Benefit type","Scenario","Option","Unit",2025,2026,2027,2028,2029,2030,2031,2032,2033,2034,2035,2036,2037,2038,2039,2040,2041,2042,2043,2044,2045,2046,2047,2048,2049,2050,2051,2052,2053,2054]
[null,"Involuntary load shedding","Step","Base case","MWh"]
[null,"Involuntary load shedding","Step","Option 1","MWh",-8639961.9368104246,-9871827.2031732351,-1715881.7517046314,-2593947.5922763105,-2948869.053945452,-4915093.7679315452,-8724544.2395891007,-9953106.6842633914,-11286014.578627951,-12825235.691948764,-14566524.673798833,-16581015.20000184,-18761865.322531275,-21277690.408938605,-24119978.443952776]
[null,"Involuntary load shedding","Step","Option 2","MWh",-8639961.9368104246,-9871827.2031732351,-1715881.7517046314,-2593947.5922763105,-3753724.4036966376,-6837537.1453202404,-19006064.923033267,-21682438.260625478,-24586123.918125167,-27939254.535301875,-31732581.788848314,-36121067.499553241,-40871960.827380724,-34686574.539243698,-39320030.233622223]
[]
[null,"Involuntary load shedding","Progressive","Base case","MWh"]
[null,"Involuntary load shedding","Progressive","Option 1","MWh",-8328611.9571055453,-9173163.675767418,-10095142.436452072,-11131664.104420278,-2454479.913765002,-13395495.267295701,-14700015.772647487,-16165699.800629113,-17670028.756844968,-19356320.443650417,-9728026.3144047353,-10674331.946429584,-11643040.277436245,-12728454.375146581,-13908775.549176848]
[null,"Involuntary load shedding","Progressive","Option 2","MWh",-8328611.9571055453,-9173163.675767418,-10095142.436452072,-11131664.104420278,-12198745.828775713,-13395495.267295701,-14700015.772647487,-16165699.800629113,-17670028.756844968,-19356320.443650417,-21192109.825700212,-23253598.172298752,-25363889.887830574,-27728420.371365581,-30299702.062144961]
[]
[null,"Involuntary load shedding","Green","Base case","MWh"]
[null,"Involuntary load shedding","Green","Option 1","MWh",-8795636.9266628642,-1557635.280991951,-1810313.3315121997,-2786012.4715358615,-3224280.4604068827,-5470973.3051209822,-9886236.6488502659,-11481599.049427133,-13253780.969182586,-15332748.14180639,-17728257.880933288,-20543606.781810902,-23664484.873354893,-27321276.80452418,-31528904.843437634]
[null,"Involuntary load shedding","Green","Option 2","MWh",-8795636.9266628642,-1557635.280991951,-1810313.3315121997,-2786012.4715358615,-4104305.7616947126,-7610838.1571248919,-11681548.943882467,-25012196.736127343,-28872822.998925023,-33401768.462511074,-38620289.037947878,-33489882.324955881,-38577491.387298338,-44538739.222811691,-51397951.891112916]
[]
[null,"Avoided generation dispatch costs","Step","Base case","$, real",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Avoided generation dispatch costs","Step","Option 1","$, real",0,0,0,-1249170.4378687283,-5147664.9316442413,-4554676.4965305403,-6802883.4439975508,-6519173.5897245565,-6439686.0669791652,-7577591.7364758682,-8035627.6289704302,-8632961.0665920489,-8929641.9464127682,-13126961.249169031,-13907187.507355466]
[null,"Avoided generation dispatch costs","Step","Option 2","$, real",0,0,0,-1249170.4378687283,-5338153.5433378536,-4998377.6453977535,-8364500.6586012375,-11167076.8016409,-11190451.879164319,-13352808.485395432,-14364328.298430096,-15657634.113362372,-16444611.507652747,-24527860.082432084,-26377345.293357566]
[]
[null,"Avoided generation dispatch costs","Progressive","Base case","$, real",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Avoided generation dispatch costs","Progressive","Option 1","$, real",0,0,0,-1052196.2092873065,-4535699.1267741472,-2478571.5131752165,-6042886.3953037933,-5653601.8720639748,-5294236.5455294615,-5625065.6168545978,-6294956.4582429305,-7267165.0230478514,-7397206.0305481646,-7662613.9218025357,-7059200.9709042832]
[null,"Avoided generation dispatch costs","Progressive","Option 2","$, real",0,0,0,-1052196.2092873065,-4694612.5892389668,-2705661.137559033,-7345016.1566974027,-9401063.1072294265,-8891707.1787501723,-9541926.8406283036,-10785865.309385972,-12577832.091645731,-12934479.472438179,-13537742.031521846,-12604159.280465644]
[]
[null,"Avoided generation dispatch costs","Green","Base case","$, real",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Avoided generation dispatch costs","Green","Option 1","$, real",0,0,0,-2060261.2702825712,-8826510.3810609635,-9881619.5715178251,-11877266.535303857,-12881007.003432706,-13831846.457595095,-14544939.507175822,-16301835.90713089,-16636900.770867284,-16832320.680468149,-18150315.754386246,-17486067.297540102]
[null,"Avoided generation dispatch costs","Green","Option 2","$, real",0,0,0,-2060261.2702825712,-9157775.3866936304,-10861456.459467605,-14661260.715720041,-22293968.286708206,-24318350.075500287,-25982717.049331345,-29590425.381527908,-30686664.213905111,-31559278.903406963,-34595163.374329753,-33886274.669655524]
[]
[null,"Avoided generation dispatch costs","[Spare scenario]","Base case","$, real"]
[null,"Avoided generation dispatch costs","[Spare scenario]","Option 1","$, real"]
[null,"Avoided generation dispatch costs","[Spare scenario]","Option 2","$, real"]
[null,"Avoided generation dispatch costs","[Spare scenario]","Option 3","$, real"]
[null,"Avoided generation dispatch costs","[Spare scenario]","Option 4","$, real"]
[null,"Avoided generation dispatch costs","[Spare scenario]","Option 5","$, real"]
[null,"Avoided generation dispatch costs","[Spare scenario]","Option 6","$, real"]
[null,"Avoided generation dispatch costs","[Spare scenario]","Option 7","$, real"]
[null,"Avoided generation dispatch costs","[Spare scenario]","Option 8","$, real"]
[null,"Avoided generation dispatch costs","[Spare scenario]","Option 9","$, real"]
[null,"Avoided generation dispatch costs","[Spare scenario]","Option 10","$, real"]
[null,"Avoided generation dispatch costs","[Spare scenario]","Option 11","$, real"]
[null,"Avoided generation dispatch costs","[Spare scenario]","Option 12","$, real"]
[null,"Avoided generation dispatch costs","[Spare scenario]","Option 13","$, real"]
[null,"Avoided generation dispatch costs","[Spare scenario]","Option 14","$, real"]
[null,"Avoided generation dispatch costs","[Spare scenario]","Option 15","$, real"]
[]
[null,"Avoided voluntary load curtailment ","Step","Base case","$, real"]
[null,"Avoided voluntary load curtailment ","Step","Option 1","$, real"]
[null,"Avoided voluntary load curtailment ","Step","Option 2","$, real"]
[null,"Avoided voluntary load curtailment ","Step","Option 3","$, real"]
[null,"Avoided voluntary load curtailment ","Step","Option 4","$, real"]
[null,"Avoided voluntary load curtailment ","Step","Option 5","$, real"]
[null,"Avoided voluntary load curtailment ","Step","Option 6","$, real"]
[null,"Avoided voluntary load curtailment ","Step","Option 7","$, real"]
[null,"Avoided voluntary load curtailment ","Step","Option 8","$, real"]
[null,"Avoided voluntary load curtailment ","Step","Option 9","$, real"]
[null,"Avoided voluntary load curtailment ","Step","Option 10","$, real"]
[null,"Avoided voluntary load curtailment ","Step","Option 11","$, real"]
[null,"Avoided voluntary load curtailment ","Step","Option 12","$, real"]
[null,"Avoided voluntary load curtailment ","Step","Option 13","$, real"]
[null,"Avoided voluntary load curtailment ","Step","Option 14","$, real"]
[null,"Avoided voluntary load curtailment ","Step","Option 15","$, real"]
[]
[null,"Avoided voluntary load curtailment ","Progressive","Base case","$, real"]
[null,"Avoided voluntary load curtailment ","Progressive","Option 1","$, real"]
[null,"Avoided voluntary load curtailment ","Progressive","Option 2","$, real"]
[null,"Avoided voluntary load curtailment ","Progressive","Option 3","$, real"]
[null,"Avoided voluntary load curtailment ","Progressive","Option 4","$, real"]
[null,"Avoided voluntary load curtailment ","Progressive","Option 5","$, real"]
[null,"Avoided voluntary load curtailment ","Progressive","Option 6","$, real"]
[null,"Avoided voluntary load curtailment ","Progressive","Option 7","$, real"]
[null,"Avoided voluntary load curtailment ","Progressive","Option 8","$, real"]
[null,"Avoided voluntary load curtailment ","Progressive","Option 9","$, real"]
[null,"Avoided voluntary load curtailment ","Progressive","Option 10","$, real"]
[null,"Avoided voluntary load curtailment ","Progressive","Option 11","$, real"]
[null,"Avoided voluntary load curtailment ","Progressive","Option 12","$, real"]
[null,"Avoided voluntary load curtailment ","Progressive","Option 13","$, real"]
[null,"Avoided voluntary load curtailment ","Progressive","Option 14","$, real"]
[null,"Avoided voluntary load curtailment ","Progressive","Option 15","$, real"]
[]
[null,"Avoided voluntary load curtailment ","Green","Base case","$, real"]
[null,"Avoided voluntary load curtailment ","Green","Option 1","$, real"]
[null,"Avoided voluntary load curtailment ","Green","Option 2","$, real"]
[null,"Avoided voluntary load curtailment ","Green","Option 3","$, real"]
[null,"Avoided voluntary load curtailment ","Green","Option 4","$, real"]
[null,"Avoided voluntary load curtailment ","Green","Option 5","$, real"]
[null,"Avoided voluntary load curtailment ","Green","Option 6","$, real"]
[null,"Avoided voluntary load curtailment ","Green","Option 7","$, real"]
[null,"Avoided voluntary load curtailment ","Green","Option 8","$, real"]
[null,"Avoided voluntary load curtailment ","Green","Option 9","$, real"]
[null,"Avoided voluntary load curtailment ","Green","Option 10","$, real"]
[null,"Avoided voluntary load curtailment ","Green","Option 11","$, real"]
[null,"Avoided voluntary load curtailment ","Green","Option 12","$, real"]
[null,"Avoided voluntary load curtailment ","Green","Option 13","$, real"]
[null,"Avoided voluntary load curtailment ","Green","Option 14","$, real"]
[null,"Avoided voluntary load curtailment ","Green","Option 15","$, real"]
[]
[null,"Avoided voluntary load curtailment ","[Spare scenario]","Base case","$, real"]
[null,"Avoided voluntary load curtailment ","[Spare scenario]","Option 1","$, real"]
[null,"Avoided voluntary load curtailment ","[Spare scenario]","Option 2","$, real"]
[null,"Avoided voluntary load curtailment ","[Spare scenario]","Option 3","$, real"]
[null,"Avoided voluntary load curtailment ","[Spare scenario]","Option 4","$, real"]
[null,"Avoided voluntary load curtailment ","[Spare scenario]","Option 5","$, real"]
[null,"Avoided voluntary load curtailment ","[Spare scenario]","Option 6","$, real"]
[null,"Avoided voluntary load curtailment ","[Spare scenario]","Option 7","$, real"]
[null,"Avoided voluntary load curtailment ","[Spare scenario]","Option 8","$, real"]
[null,"Avoided voluntary load curtailment ","[Spare scenario]","Option 9","$, real"]
[null,"Avoided voluntary load curtailment ","[Spare scenario]","Option 10","$, real"]
[null,"Avoided voluntary load curtailment ","[Spare scenario]","Option 11","$, real"]
[null,"Avoided voluntary load curtailment ","[Spare scenario]","Option 12","$, real"]
[null,"Avoided voluntary load curtailment ","[Spare scenario]","Option 13","$, real"]
[null,"Avoided voluntary load curtailment ","[Spare scenario]","Option 14","$, real"]
[null,"Avoided voluntary load curtailment ","[Spare scenario]","Option 15","$, real"]
[]
[null,"Cost for non-RIT-T proponent parties","Step","Base case","$, real"]
[null,"Cost for non-RIT-T proponent parties","Step","Option 1","$, real"]
[null,"Cost for non-RIT-T proponent parties","Step","Option 2","$, real"]
[null,"Cost for non-RIT-T proponent parties","Step","Option 3","$, real"]
[null,"Cost for non-RIT-T proponent parties","Step","Option 4","$, real"]
[null,"Cost for non-RIT-T proponent parties","Step","Option 5","$, real"]
[null,"Cost for non-RIT-T proponent parties","Step","Option 6","$, real"]
[null,"Cost for non-RIT-T proponent parties","Step","Option 7","$, real"]
[null,"Cost for non-RIT-T proponent parties","Step","Option 8","$, real"]
[null,"Cost for non-RIT-T proponent parties","Step","Option 9","$, real"]
[null,"Cost for non-RIT-T proponent parties","Step","Option 10","$, real"]
[null,"Cost for non-RIT-T proponent parties","Step","Option 11","$, real"]
[null,"Cost for non-RIT-T proponent parties","Step","Option 12","$, real"]
[null,"Cost for non-RIT-T proponent parties","Step","Option 13","$, real"]
[null,"Cost for non-RIT-T proponent parties","Step","Option 14","$, real"]
[null,"Cost for non-RIT-T proponent parties","Step","Option 15","$, real"]
[]
[null,"Cost for non-RIT-T proponent parties","Progressive","Base case","$, real"]
[null,"Cost for non-RIT-T proponent parties","Progressive","Option 1","$, real"]
[null,"Cost for non-RIT-T proponent parties","Progressive","Option 2","$, real"]
[null,"Cost for non-RIT-T proponent parties","Progressive","Option 3","$, real"]
[null,"Cost for non-RIT-T proponent parties","Progressive","Option 4","$, real"]
[null,"Cost for non-RIT-T proponent parties","Progressive","Option 5","$, real"]
[null,"Cost for non-RIT-T proponent parties","Progressive","Option 6","$, real"]
[null,"Cost for non-RIT-T proponent parties","Progressive","Option 7","$, real"]
[null,"Cost for non-RIT-T proponent parties","Progressive","Option 8","$, real"]
[null,"Cost for non-RIT-T proponent parties","Progressive","Option 9","$, real"]
[null,"Cost for non-RIT-T proponent parties","Progressive","Option 10","$, real"]
[null,"Cost for non-RIT-T proponent parties","Progressive","Option 11","$, real"]
[null,"Cost for non-RIT-T proponent parties","Progressive","Option 12","$, real"]
[null,"Cost for non-RIT-T proponent parties","Progressive","Option 13","$, real"]
[null,"Cost for non-RIT-T proponent parties","Progressive","Option 14","$, real"]
[null,"Cost for non-RIT-T proponent parties","Progressive","Option 15","$, real"]
[]
[null,"Cost for non-RIT-T proponent parties","Green","Base case","$, real"]
[null,"Cost for non-RIT-T proponent parties","Green","Option 1","$, real"]
[null,"Cost for non-RIT-T proponent parties","Green","Option 2","$, real"]
[null,"Cost for non-RIT-T proponent parties","Green","Option 3","$, real"]
[null,"Cost for non-RIT-T proponent parties","Green","Option 4","$, real"]
[null,"Cost for non-RIT-T proponent parties","Green","Option 5","$, real"]
[null,"Cost for non-RIT-T proponent parties","Green","Option 6","$, real"]
[null,"Cost for non-RIT-T proponent parties","Green","Option 7","$, real"]
[null,"Cost for non-RIT-T proponent parties","Green","Option 8","$, real"]
[null,"Cost for non-RIT-T proponent parties","Green","Option 9","$, real"]
[null,"Cost for non-RIT-T proponent parties","Green","Option 10","$, real"]
[null,"Cost for non-RIT-T proponent parties","Green","Option 11","$, real"]
[null,"Cost for non-RIT-T proponent parties","Green","Option 12","$, real"]
[null,"Cost for non-RIT-T proponent parties","Green","Option 13","$, real"]
[null,"Cost for non-RIT-T proponent parties","Green","Option 14","$, real"]
[null,"Cost for non-RIT-T proponent parties","Green","Option 15","$, real"]
[]
[null,"Cost for non-RIT-T proponent parties","[Spare scenario]","Base case","$, real"]
[null,"Cost for non-RIT-T proponent parties","[Spare scenario]","Option 1","$, real"]
[null,"Cost for non-RIT-T proponent parties","[Spare scenario]","Option 2","$, real"]
[null,"Cost for non-RIT-T proponent parties","[Spare scenario]","Option 3","$, real"]
[null,"Cost for non-RIT-T proponent parties","[Spare scenario]","Option 4","$, real"]
[null,"Cost for non-RIT-T proponent parties","[Spare scenario]","Option 5","$, real"]
[null,"Cost for non-RIT-T proponent parties","[Spare scenario]","Option 6","$, real"]
[null,"Cost for non-RIT-T proponent parties","[Spare scenario]","Option 7","$, real"]
[null,"Cost for non-RIT-T proponent parties","[Spare scenario]","Option 8","$, real"]
[null,"Cost for non-RIT-T proponent parties","[Spare scenario]","Option 9","$, real"]
[null,"Cost for non-RIT-T proponent parties","[Spare scenario]","Option 10","$, real"]
[null,"Cost for non-RIT-T proponent parties","[Spare scenario]","Option 11","$, real"]
[null,"Cost for non-RIT-T proponent parties","[Spare scenario]","Option 12","$, real"]
[null,"Cost for non-RIT-T proponent parties","[Spare scenario]","Option 13","$, real"]
[null,"Cost for non-RIT-T proponent parties","[Spare scenario]","Option 14","$, real"]
[null,"Cost for non-RIT-T proponent parties","[Spare scenario]","Option 15","$, real"]
[]
[null,"Competition benefits","Step","Base case","$, real"]
[null,"Competition benefits","Step","Option 1","$, real"]
[null,"Competition benefits","Step","Option 2","$, real"]
[null,"Competition benefits","Step","Option 3","$, real"]
[null,"Competition benefits","Step","Option 4","$, real"]
[null,"Competition benefits","Step","Option 5","$, real"]
[null,"Competition benefits","Step","Option 6","$, real"]
[null,"Competition benefits","Step","Option 7","$, real"]
[null,"Competition benefits","Step","Option 8","$, real"]
[null,"Competition benefits","Step","Option 9","$, real"]
[null,"Competition benefits","Step","Option 10","$, real"]
[null,"Competition benefits","Step","Option 11","$, real"]
[null,"Competition benefits","Step","Option 12","$, real"]
[null,"Competition benefits","Step","Option 13","$, real"]
[null,"Competition benefits","Step","Option 14","$, real"]
[null,"Competition benefits","Step","Option 15","$, real"]
[]
[null,"Competition benefits","Progressive","Base case","$, real"]
[null,"Competition benefits","Progressive","Option 1","$, real"]
[null,"Competition benefits","Progressive","Option 2","$, real"]
[null,"Competition benefits","Progressive","Option 3","$, real"]
[null,"Competition benefits","Progressive","Option 4","$, real"]
[null,"Competition benefits","Progressive","Option 5","$, real"]
[null,"Competition benefits","Progressive","Option 6","$, real"]
[null,"Competition benefits","Progressive","Option 7","$, real"]
[null,"Competition benefits","Progressive","Option 8","$, real"]
[null,"Competition benefits","Progressive","Option 9","$, real"]
[null,"Competition benefits","Progressive","Option 10","$, real"]
[null,"Competition benefits","Progressive","Option 11","$, real"]
[null,"Competition benefits","Progressive","Option 12","$, real"]
[null,"Competition benefits","Progressive","Option 13","$, real"]
[null,"Competition benefits","Progressive","Option 14","$, real"]
[null,"Competition benefits","Progressive","Option 15","$, real"]
[]
[null,"Competition benefits","Green","Base case","$, real"]
[null,"Competition benefits","Green","Option 1","$, real"]
[null,"Competition benefits","Green","Option 2","$, real"]
[null,"Competition benefits","Green","Option 3","$, real"]
[null,"Competition benefits","Green","Option 4","$, real"]
[null,"Competition benefits","Green","Option 5","$, real"]
[null,"Competition benefits","Green","Option 6","$, real"]
[null,"Competition benefits","Green","Option 7","$, real"]
[null,"Competition benefits","Green","Option 8","$, real"]
[null,"Competition benefits","Green","Option 9","$, real"]
[null,"Competition benefits","Green","Option 10","$, real"]
[null,"Competition benefits","Green","Option 11","$, real"]
[null,"Competition benefits","Green","Option 12","$, real"]
[null,"Competition benefits","Green","Option 13","$, real"]
[null,"Competition benefits","Green","Option 14","$, real"]
[null,"Competition benefits","Green","Option 15","$, real"]
[]
[null,"Competition benefits","[Spare scenario]","Base case","$, real"]
[null,"Competition benefits","[Spare scenario]","Option 1","$, real"]
[null,"Competition benefits","[Spare scenario]","Option 2","$, real"]
[null,"Competition benefits","[Spare scenario]","Option 3","$, real"]
[null,"Competition benefits","[Spare scenario]","Option 4","$, real"]
[null,"Competition benefits","[Spare scenario]","Option 5","$, real"]
[null,"Competition benefits","[Spare scenario]","Option 6","$, real"]
[null,"Competition benefits","[Spare scenario]","Option 7","$, real"]
[null,"Competition benefits","[Spare scenario]","Option 8","$, real"]
[null,"Competition benefits","[Spare scenario]","Option 9","$, real"]
[null,"Competition benefits","[Spare scenario]","Option 10","$, real"]
[null,"Competition benefits","[Spare scenario]","Option 11","$, real"]
[null,"Competition benefits","[Spare scenario]","Option 12","$, real"]
[null,"Competition benefits","[Spare scenario]","Option 13","$, real"]
[null,"Competition benefits","[Spare scenario]","Option 14","$, real"]
[null,"Competition benefits","[Spare scenario]","Option 15","$, real"]
[]
[null,"Greenhouse gases","Step","Base case","$, real",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Greenhouse gases","Step","Option 1","$, real",0,0,0,-1080993.4592381229,-4755049.1505414201,-4007078.4648028086,-4884647.7509539137,-5534478.1216126066,-6291563.1600109786,-6741976.3609625408,-7802877.4562786035,-9063519.4641504977,-9880286.8642494977,-10359463.355453588,-11605228.838570513]
[null,"Greenhouse gases","Step","Option 2","$, real",0,0,0,-1080993.4592381229,-4931296.099816462,-4398466.8591649011,-6008291.3474031016,-9485614.7708297316,-10936316.208617235,-11885363.338952255,-13954076.129073827,-16445096.359309895,-18196770.13160577,-19364603.719518445,-22020439.580482118]
[]
[null,"Greenhouse gases","Progressive","Base case","$, real",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Greenhouse gases","Progressive","Option 1","$, real",0,0,0,-816990.73949431488,-3036873.1506649442,-1628463.6679287669,-3655705.8339118627,-3936663.9239237141,-4109067.4870863091,-4582130.9130519722,-5325506.9047360998,-6344582.8300971501,-6843044.7577536767,-7503015.2449332029,-7712908.0907946602]
[null,"Greenhouse gases","Progressive","Option 2","$, real",0,0,0,-816990.73949431488,-3143599.0685240002,-1778165.8679444783,-4444963.8284771498,-6550477.5523124011,-6905383.2376381997,-7777454.4568987787,-9130583.5942046754,-10988600.358046617,-11974086.448650587,-13265660.15897055,-13781079.160205707]
[]
[null,"Greenhouse gases","Green","Base case","$, real",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Greenhouse gases","Green","Option 1","$, real",0,0,0,-1143302.9475285299,-5100089.9005516423,-4309027.5550685581,-5163286.3145406796,-5841208.4210026534,-6684690.1279727127,-7260681.0134788109,-8524907.8305778541,-9947553.9641642645,-10910278.112296818,-11602593.489022486,-12993848.718469612]
[null,"Greenhouse gases","Green","Option 2","$, real",0,0,0,-1143302.9475285299,-5226272.4945208821,-4635830.6073538084,-6028238.6511351345,-8512552.0458110087,-9691762.3484689742,-10701434.891955046,-12810524.224570755,-14803908.716789773,-16169025.216810517,-17550272.979505681,-19217517.197113045]

{"sheet":"Calculations ->","index":8,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"S1","index":9,"n_rows":126,"n_cols":35,"rows_kept":126,"cut":false,"hidden":false,"merged":[]}
["S1","Step"]
["Calculating costs, benefits and NPV for each option"]
[]
[null,"Parameters for S1"]
[]
[null,"Parameters"]
[null,"General parameters",null,null,"Unit","Active","Scenario"]
[null,"Commercial discount rate",null,null,"Percent",7.0000000000000007E-2,7.0000000000000007E-2]
[]
[null,"Cost parameters",null,null,"Unit","Active","Scenario"]
[null,"Capital cost",null,null,"Factor",1,1]
[null,"Planned routine maintenance and refurbishment ",null,null,"Factor",1,1]
[]
[null,"Benefit parameters",null,null,"Unit","Active","Scenario"]
[null,"Involuntary load shedding",null,null,"Factor",1,1]
[null,"Avoided generation dispatch costs",null,null,"Factor",1,1]
[null,"Greenhouse gases",null,null,"Factor",1,1]
[]
[null,"Discount factor"]
[]
[null,null,null,null,null,2025,2026,2027,2028,2029,2030,2031,2032,2033,2034,2035,2036,2037,2038,2039,2040,2041,2042,2043,2044,2045,2046,2047,2048,2049,2050,2051,2052,2053,2054]
[null,null,null,null,"Discount year",0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29]
[null,null,null,null,"Discount factor",1,0.93457943925233644,0.87343872827321156,0.81629787689085187,0.7628952120475252,0.71298617948366838,0.66634222381651254,0.62274974188459109,0.5820091045650384,0.54393374258414806,0.5083492921347178,0.47509279638758667,0.44401195924073528,0.41496444788853759,0.3878172410173249,0.36244601964235967,0.33873459779659787,0.31657439046411018,0.29586391632159825,0.27650833301083949,0.2584190028138687,0.24151308674193336,0.22571316517937698,0.21094688334521211,0.19714661994879637,0.18424917752223957,0.17219549301143888,0.16093036730041013,0.15040221243028987,0.1405628153554111]
[]
[]
[null,"Gross calculations for the base case"]
[]
[null,"Gross costs for the base case"]
[null,"Category",null,"Units","PV",2025,2026,2027,2028,2029,2030,2031,2032,2033,2034,2035,2036,2037,2038,2039,"","","","","","","","","","","","","","",""]
[null,"Capital cost",null,"$",-27798740.364273697,0,0,0,0,-10000000,-15000000,-5000000,0,0,-5000000,-5000000,-10000000,-15000000,-5000000,32500000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Planned routine maintenance and refurbishment ",null,"$",-452263.12585986248,0,0,0,0,-250000,-250000,-125000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"Incremental net present value calculation"]
[]
[null,"Net present value for each option",null,null,null,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option name",null,"Units","NPV",2025,2026,2027,2028,2029,2030,2031,2032,2033,2034,2035,2036,2037,2038,2039,"","","","","","","","","","","","","","",""]
[null,"Option 1",null,"$",47869156.776071176,449961.93681042455,8182284.9437033646,-27221598.632892407,-42969190.161889464,-3118197.3751042951,5333560.938682951,12583624.852797611,2566009.0051438706,11782084.192925066,13659776.629037261,19540217.57482836,21925384.737811148,40336614.520500511,37528935.400868192,49242582.120426588,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 2",null,"$",135540244.39515078,449961.93681042455,7650951.8430068707,-22536131.540734813,-43501973.980911158,-13140438.958009968,-11552562.125157889,8935190.4308566917,12446050.154409401,23974603.205705613,49980900.359649569,44886121.060743287,45369505.319412611,67775053.666438133,75382512.341194227,105217085.04263365,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[]
[null,"Incremental cost calculation",null,null,null,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"Capital outflow"]
[null,"Option name","Capex component","Units","PV",2025,2026,2027,2028,2029,2030,2031,2032,2033,2034,2035,2036,2037,2038,2039,2040,2041,2042,2043,2044,2045,2046,2047,2048,2049,2050,2051,2052,2053,2054]
[null,"Base case","SCADA/EMS","$",-21655455.931812841,0,0,0,0,-10000000,-15000000,-5000000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Base case","SCADA/EMS (hardware refresh)","$",-4291872.0710510174,0,0,0,0,0,0,0,0,0,-5000000,-5000000,0,0,0,2500000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Base case","SCADA/EMS (refresh 1)","$",-1851412.3614098355,0,0,0,0,0,0,0,0,0,0,0,-10000000,-15000000,-5000000,30000000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 1","Project management","$",-11372833.844546473,0,-423071.55576521734,-3615534.2052043471,-2092911.0911884054,-3487211.5304057966,-4839752.1692086961,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 1","Project management(refresh)","$",-4639938.2571806917,0,0,0,0,0,-633033.28859601519,-699313.69667165144,-1356397.9003534981,-626561.61269302899,-1259594.9012890442,-994199.09914820432,-1651283.3028300512,-626561.61269302899,-626561.61269302899,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 1","Data Management and Network Modelling ","$",-17512610.027729161,0,0,-5580669.3531594202,-15482384.118318837,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 1","Data Management and Network Modelling (refresh)","$",-11245301.073627964,0,0,0,0,0,-5616814.2590608681,-5616814.2590608681,-5616814.2590608681,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 1","Data Management and Network Modelling (refresh) (refresh)","$",-5311540.2332200324,0,0,0,0,0,0,0,0,0,-5616814.2590608681,-5616814.2590608681,-5616814.2590608681,0,0,8425221.3885913026,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 1","Enhanced EMS/SCADA ","$",-22260555.11382227,0,-266470.70370465296,-6998581.8481083727,-13719936.847540526,-5602281.6124528013,-3914521.4689240898,0,0,0,0,0,0,0,0,6100358.4961460903,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 1","Enhanced EMS/SCADA (hardware refresh)","$",-6259557.6568984101,0,0,0,0,0,0,0,0,-5559392,-5559392,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 1","Enhanced EMS/SCADA (hardware refresh) (refresh)","$",-463330.43163564708,0,0,0,0,0,0,0,0,0,0,0,0,-5559392,-5559392,11118784,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 1","Outage Management System and Switching execution ","$",-1222320.2796122613,0,0,-387904.81815652177,-1082336.7468695655,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 1","Outage Management and Switching Execution  (refresh)","$",-758110.63564597839,0,0,0,0,0,0,-588096.62601043493,-588096.62601043493,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 1","Outage Management and Switching Execution  (refresh) (refresh)","$",-350284.96318565833,0,0,0,0,0,0,0,0,0,0,-588096.62601043493,-588096.62601043493,0,0,588096.62601043493,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 1","Fault level and system parameter monitoring ","$",-2298983.9650895512,0,0,0,0,-2490165.5291594202,-932283.97657971014,0,0,0,0,0,0,0,0,684489.90114782611,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 1","Alarm Management technologies ","$",-12624759.288107483,-2990000,0,-3217475.1398260873,-7512471.3916521734,-1690564.5979130436,0,0,0,0,0,0,0,0,0,1541051.1129391305,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 1","Operator Visualisation and Situational Awareness technology ","$",-7416227.1175190015,0,0,0,-500065.55497584539,-7614752.9930434786,-2877107.2948792269,0,0,0,0,0,0,0,0,2198385.1685797106,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 1","Training technologies ","$",-5004283.8573638117,0,0,0,-3781211.0979130436,-2850839.2482608696,0,0,0,0,0,0,0,0,0,663205.03461739141,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 1","Operational Documentation Management System ","$",-2478436.466615573,0,0,-812964.69997470349,-2166319.0153992092,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 1","Opertional Document Management System (refresh)","$",-1484278.5318000556,0,0,0,0,0,0,0,-2383426.9722991302,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 1","Opertional Document Management System (refresh) (refresh)","$",-670181.94897353044,0,0,0,0,0,0,0,0,0,0,0,-2383426.9722991302,0,0,1191713.4861495651,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 1","Operational Planning Systems ","$",-3729331.3657787316,0,0,-3715810.6201675907,-592673.92074835324,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 1","Operational planning system (refresh)","$",-2146486.1086153239,0,0,0,0,0,0,0,-3446787.632732755,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 1","Operational planning system (refresh) (refresh)","$",-969182.13993962784,0,0,0,0,0,0,0,0,0,0,0,-3446787.632732755,0,0,1723393.8163663775,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 1","Facilities","$",-4488493.55224506,0,0,-4608539.7,-174412.7,0,-450000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 1","Facilities(refresh)","$",-1051080.9470896614,0,0,0,0,0,0,0,0,0,0,-2616476.2000000002,-2616476.2000000002,0,0,3924714.3000000003,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 1","CPA submission ","$",-6134579.4392523365,-5200000,-1000000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 2","Data Management and Network Modelling ","$",-22619162.984044507,0,0,-2779235.9803789253,-16405196.168306807,-8913601.4150011241,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 2","Data Management and Network Modelling (refresh)","$",-14019802.846236922,0,0,0,0,0,0,-7492808.9503164953,-7492808.9503164953,-7492808.9503164953,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 2","Data Management and Network Modelling (refresh) (refresh)","$",-4157499.3524356745,0,0,0,0,0,0,0,0,0,0,-7492808.9503164953,-7492808.9503164953,-7492808.9503164953,0,16858820.138212115,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 2","Enhanced EMS/SCADA ","$",-23213352.038796529,0,-324279.57949586608,-5888877.5561953578,-13640049.182315217,-5589935.6451846845,-5464279.123619467,-3759672.3295240891,0,0,0,0,0,0,0,10400128.024900407,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 2","Enhanced EMS/SCADA (hardware refresh)","$",-6697726.6928812992,0,0,0,0,0,0,0,-5559392,-5559392,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 2","Enhanced EMS/SCADA (hardware refresh) (refresh)","$",-1875621.5248413659,0,0,0,0,0,0,0,0,0,0,0,-5559392,-5559392,0,8339088,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 2","Outage Management System and Switching execution ","$",-1222320.2796122613,0,0,-387904.81815652177,-1082336.7468695655,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 2","Outage Management System and Switching execution (refresh)","$",-758110.63564597839,0,0,0,0,0,0,-588096.62601043493,-588096.62601043493,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 2","Outage Management System and Switching execution (refresh)(refresh)","$",-350284.96318565833,0,0,0,0,0,0,0,0,0,0,-588096.62601043493,-588096.62601043493,0,0,588096.62601043493,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 2","Fault level and system parameter monitoring ","$",-4645990.4367265506,0,0,0,0,-1623844.2871551723,-5560264.3614655184,0,0,0,0,0,0,0,0,1436821.729724138,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 2","Alarm Management technologies ","$",-15045670.738472782,-2990000,0,-1167577.3357554777,-5936971.9381152447,-5682130.1561036501,-4844569.6114631873,0,0,0,0,0,0,0,0,4124249.8082875125,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 2","Operator Visualisation and Situational Awareness technology ","$",-9003277.8513059895,0,0,0,0,-6353498.8091046484,-6728551.2386206891,-1601632.8696551726,0,0,0,0,0,0,0,4405104.8752141539,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 2","Training technologies ","$",-5004283.8573638117,0,0,0,-3781211.0979130436,-2850839.2482608696,0,0,0,0,0,0,0,0,0,663205.03461739141,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 2","Operational Documentation Management System ","$",-2478436.466615573,0,0,-812964.69997470349,-2166319.0153992092,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 2","Operational Documentation Management System (refresh)","$",-1484278.5318000556,0,0,0,0,0,0,0,-2383426.9722991302,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 2","Operational Documentation Management System (refresh)(refresh)","$",-670181.94897353044,0,0,0,0,0,0,0,0,0,0,0,-2383426.9722991302,0,0,1191713.4861495651,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 2","Operational Planning Systems ","$",-3729331.3657787316,0,0,-3715810.6201675907,-592673.92074835324,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 2","Operational Planning Systems (refresh)","$",-2146486.1086153239,0,0,0,0,0,0,0,-3446787.632732755,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 2","Operational Planning Systems (refresh)(refresh)","$",-969182.13993962784,0,0,0,0,0,0,0,0,0,0,0,-3446787.632732755,0,0,1723393.8163663775,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 2","Facilities","$",-4527474.5723383259,0,0,-4608539.7,-174412.7,0,0,-540000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 2","Facilities (refresh)","$",-1069158.1773044958,0,0,0,0,0,0,0,0,0,0,-2661476.2000000002,-2661476.2000000002,0,0,3992214.3000000003,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 2","Operational forecasts and look-ahead contingency assessment ","$",-2475702.23056255,0,0,0,0,0,-3694742.2543185558,-493216.263497537,0,0,0,0,0,0,0,1256387.5553448279,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 2","Wide Area Monitoring ","$",-3984080.4960495075,0,0,0,0,0,-6164605.8985878499,-556409.93532019702,0,0,0,0,0,0,0,2016304.7501724139,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 2","Smart Transmission Device Management ","$",-2364167.4113149941,0,0,0,0,0,-3509313.4128735634,-491579.22103448276,0,0,0,0,0,0,0,1200267.7901724139,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 2","CPA submission ","$",-6134579.4392523365,-5200000,-1000000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 2","Project management","$",-15569109.696002468,0,-896595.78067049815,-4891102.5818108711,-3858335.533960219,-3458628.444050774,-1803412.5407586207,-5080213.6976666683,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 2","Project management(refresh)","$",-5349805.7596153263,0,0,0,0,0,0,-922220.60515583563,-2222041.4973278912,-1489561.8498846162,0,-1225957.3792820221,-2525778.2714540777,-1489561.8498846162,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"Capital cost"]
[null,"Option name",null,"Units","PV",2025,2026,2027,2028,2029,2030,2031,2032,2033,2034,2035,2036,2037,2038,2039,2040,2041,2042,2043,2044,2045,2046,2047,2048,2049,2050,2051,2052,2053,2054]
[null,"Option 1",null,"$",-104093946.88122059,-8190000,-1689542.2594698702,-28937480.384597041,-47104722.484605961,-13735815.511235408,-4263512.4572486095,-1904224.5817429544,-13391523.390456686,-6185953.6126930285,-7435801.1603499129,-4815586.1842195075,-6302884.9929332398,8814046.3873069715,-1185953.6126930285,5659413.330547832,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 2",null,"$",-133766338.18143854,-8190000,-2220875.3601663643,-24252013.292439446,-47637506.303627655,-24472478.004860923,-22769738.441707447,-16525850.498180915,-21692553.678686708,-14541762.800201112,5000000,-6968339.155608952,-14657766.652812894,458237.1997988876,5000000,25695795.935171746,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"Planned routine maintenance and refurbishment "]
[null,"Option name",null,"Units","PV",2025,2026,2027,2028,2029,2030,2031,2032,2033,2034,2035,2036,2037,2038,2039,2040,2041,2042,2043,2044,2045,2046,2047,2048,2049,2050,2051,2052,2053,2054]
[null,"Option 1",null,"$",-33131221.501269139,0,0,0,-788579.16666666674,-2233965,-3879775.3333333335,-5924226,-6049226,-6049226,-6049226,-6049226,-6049226,-6049226,-6049226,-6049226,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 2",null,"$",-44163332.163250737,0,0,0,-788579.16666666674,-2691135,-5017205.333333334,-7917816,-8196526,-8196526,-8196526,-8196526,-8196526,-8196526,-8196526,-8196526,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[]
[null,"Incremental 'market benefits' calculation"]
[]
[null,"Involuntary load shedding"]
[null,"Option name",null,"Units","PV",2025,2026,2027,2028,2029,2030,2031,2032,2033,2034,2035,2036,2037,2038,2039,2040,2041,2042,2043,2044,2045,2046,2047,2048,2049,2050,2051,2052,2053,2054]
[null,"Option 1",null,"$",94589185.19559586,8639961.9368104246,9871827.2031732351,1715881.7517046314,2593947.5922763105,2948869.053945452,4915093.7679315452,8724544.2395891007,9953106.6842633914,11286014.578627951,12825235.691948764,14566524.673798833,16581015.20000184,18761865.322531275,21277690.408938605,24119978.443952776,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 2",null,"$",165977030.42172471,8639961.9368104246,9871827.2031732351,1715881.7517046314,2593947.5922763105,3753724.4036966376,6837537.1453202404,19006064.923033267,21682438.260625478,24586123.918125167,27939254.535301875,31732581.788848314,36121067.499553241,40871960.827380724,34686574.539243698,39320030.233622223,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"Avoided generation dispatch costs"]
[null,"Option name",null,"Units","PV",2025,2026,2027,2028,2029,2030,2031,2032,2033,2034,2035,2036,2037,2038,2039,2040,2041,2042,2043,2044,2045,2046,2047,2048,2049,2050,2051,2052,2053,2054]
[null,"Option 1",null,"$",47648671.771038502,0,0,0,1249170.4378687283,5147664.9316442413,4554676.4965305403,6802883.4439975508,6519173.5897245565,6439686.0669791652,7577591.7364758682,8035627.6289704302,8632961.0665920489,8929641.9464127682,13126961.249169031,13907187.507355466,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 2",null,"$",77410131.940557405,0,0,0,1249170.4378687283,5338153.5433378536,4998377.6453977535,8364500.6586012375,11167076.8016409,11190451.879164319,13352808.485395432,14364328.298430096,15657634.113362372,16444611.507652747,24527860.082432084,26377345.293357566,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"Greenhouse gases"]
[null,"Option name",null,"Units","PV",2025,2026,2027,2028,2029,2030,2031,2032,2033,2034,2035,2036,2037,2038,2039,2040,2041,2042,2043,2044,2045,2046,2047,2048,2049,2050,2051,2052,2053,2054]
[null,"Option 1",null,"$",42856468.191926546,0,0,0,1080993.4592381229,4755049.1505414201,4007078.4648028086,4884647.7509539137,5534478.1216126066,6291563.1600109786,6741976.3609625408,7802877.4562786035,9063519.4641504977,9880286.8642494977,10359463.355453588,11605228.838570513,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 2",null,"$",70082752.377557874,0,0,0,1080993.4592381229,4931296.099816462,4398466.8591649011,6008291.3474031016,9485614.7708297316,10936316.208617235,11885363.338952255,13954076.129073827,16445096.359309895,18196770.13160577,19364603.719518445,22020439.580482118,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]

{"sheet":"S2","index":10,"n_rows":125,"n_cols":35,"rows_kept":125,"cut":false,"hidden":false,"merged":[]}
["S2","Progressive"]
["Calculating costs, benefits and NPV for each option"]
[]
[null,"Parameters for S2"]
[]
[null,"Parameters"]
[null,"General parameters",null,null,"Unit","Active","Scenario"]
[null,"Commercial discount rate",null,null,"Percent",7.0000000000000007E-2,7.0000000000000007E-2]
[]
[null,"Cost parameters",null,null,"Unit","Active","Scenario"]
[null,"Capital cost",null,null,"Factor",1,1]
[null,"Planned routine maintenance and refurbishment ",null,null,"Factor",1,1]
[]
[null,"Benefit parameters",null,null,"Unit","Active","Scenario"]
[null,"Involuntary load shedding",null,null,"Factor",1,1]
[null,"Avoided generation dispatch costs",null,null,"Factor",1,1]
[null,"Greenhouse gases",null,null,"Factor",1,1]
[]
[null,"Discount factor"]
[]
[null,null,null,null,null,2025,2026,2027,2028,2029,2030,2031,2032,2033,2034,2035,2036,2037,2038,2039,2040,2041,2042,2043,2044,2045,2046,2047,2048,2049,2050,2051,2052,2053,2054]
[null,null,null,null,"Discount year",0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29]
[null,null,null,null,"Discount factor",1,0.93457943925233644,0.87343872827321156,0.81629787689085187,0.7628952120475252,0.71298617948366838,0.66634222381651254,0.62274974188459109,0.5820091045650384,0.54393374258414806,0.5083492921347178,0.47509279638758667,0.44401195924073528,0.41496444788853759,0.3878172410173249,0.36244601964235967,0.33873459779659787,0.31657439046411018,0.29586391632159825,0.27650833301083949,0.2584190028138687,0.24151308674193336,0.22571316517937698,0.21094688334521211,0.19714661994879637,0.18424917752223957,0.17219549301143888,0.16093036730041013,0.15040221243028987,0.1405628153554111]
[]
[]
[null,"Gross calculations for the base case"]
[]
[null,"Gross costs for the base case"]
[null,"Category",null,"Units","PV",2025,2026,2027,2028,2029,2030,2031,2032,2033,2034,2035,2036,2037,2038,2039,"","","","","","","","","","","","","","",""]
[null,"Capital cost",null,"$",-27798740.364273697,0,0,0,0,-10000000,-15000000,-5000000,0,0,-5000000,-5000000,-10000000,-15000000,-5000000,32500000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Planned routine maintenance and refurbishment ",null,"$",-452263.12585986248,0,0,0,0,-250000,-250000,-125000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"Incremental net present value calculation"]
[]
[null,"Net present value for each option",null,null,null,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option name",null,"Units","NPV",2025,2026,2027,2028,2029,2030,2031,2032,2033,2034,2035,2036,2037,2038,2039,"","","","","","","","","","","","","","",""]
[null,"Option 1",null,"$",39951182.367824793,138611.95710554533,7483621.4162975475,-18842337.948144969,-34892450.598070726,-5942728.3200313151,9359242.6578177419,16570157.420120187,6315216.2061601179,14838153.176767709,16078489.813207073,10483677.493164258,11933968.806641346,28648111.453045059,20658903.929189291,28291071.941423625,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 2",null,"$",73590684.011477292,138611.95710554533,6952288.3156010536,-14156870.855987374,-35425234.417092413,-7126655.5183222434,-9907621.5022415705,2046329.2596411249,2228160.7814842323,10728830.373032229,33479175.741177499,25943693.57368191,23965737.969178207,42534167.008718222,51335296.561857976,74184210.437988058,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[]
[null,"Incremental cost calculation",null,null,null,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"Capital outflow"]
[null,"Option name","Capex component","Units","PV",2025,2026,2027,2028,2029,2030,2031,2032,2033,2034,2035,2036,2037,2038,2039,2040,2041,2042,2043,2044,2045,2046,2047,2048,2049,2050,2051,2052,2053,2054]
[null,"Base case","SCADA/EMS","$",-21655455.931812841,0,0,0,0,-10000000,-15000000,-5000000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Base case","SCADA/EMS (hardware refresh)","$",-4291872.0710510174,0,0,0,0,0,0,0,0,0,-5000000,-5000000,0,0,0,2500000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Base case","SCADA/EMS (refresh 1)","$",-1851412.3614098355,0,0,0,0,0,0,0,0,0,0,0,-10000000,-15000000,-5000000,30000000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 1","Project management","$",-11372833.844546473,0,-423071.55576521734,-3615534.2052043471,-2092911.0911884054,-3487211.5304057966,-4839752.1692086961,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 1","Project management(refresh)","$",-4639938.2571806917,0,0,0,0,0,-633033.28859601519,-699313.69667165144,-1356397.9003534981,-626561.61269302899,-1259594.9012890442,-994199.09914820432,-1651283.3028300512,-626561.61269302899,-626561.61269302899,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 1","Data Management and Network Modelling ","$",-17512610.027729161,0,0,-5580669.3531594202,-15482384.118318837,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 1","Data Management and Network Modelling (refresh)","$",-11245301.073627964,0,0,0,0,0,-5616814.2590608681,-5616814.2590608681,-5616814.2590608681,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 1","Data Management and Network Modelling (refresh) (refresh)","$",-5311540.2332200324,0,0,0,0,0,0,0,0,0,-5616814.2590608681,-5616814.2590608681,-5616814.2590608681,0,0,8425221.3885913026,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 1","Enhanced EMS/SCADA ","$",-22260555.11382227,0,-266470.70370465296,-6998581.8481083727,-13719936.847540526,-5602281.6124528013,-3914521.4689240898,0,0,0,0,0,0,0,0,6100358.4961460903,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 1","Enhanced EMS/SCADA (hardware refresh)","$",-6259557.6568984101,0,0,0,0,0,0,0,0,-5559392,-5559392,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 1","Enhanced EMS/SCADA (hardware refresh) (refresh)","$",-463330.43163564708,0,0,0,0,0,0,0,0,0,0,0,0,-5559392,-5559392,11118784,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 1","Outage Management System and Switching execution ","$",-1222320.2796122613,0,0,-387904.81815652177,-1082336.7468695655,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 1","Outage Management and Switching Execution  (refresh)","$",-758110.63564597839,0,0,0,0,0,0,-588096.62601043493,-588096.62601043493,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 1","Outage Management and Switching Execution  (refresh) (refresh)","$",-350284.96318565833,0,0,0,0,0,0,0,0,0,0,-588096.62601043493,-588096.62601043493,0,0,588096.62601043493,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 1","Fault level and system parameter monitoring ","$",-2298983.9650895512,0,0,0,0,-2490165.5291594202,-932283.97657971014,0,0,0,0,0,0,0,0,684489.90114782611,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 1","Alarm Management technologies ","$",-12624759.288107483,-2990000,0,-3217475.1398260873,-7512471.3916521734,-1690564.5979130436,0,0,0,0,0,0,0,0,0,1541051.1129391305,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 1","Operator Visualisation and Situational Awareness technology ","$",-7416227.1175190015,0,0,0,-500065.55497584539,-7614752.9930434786,-2877107.2948792269,0,0,0,0,0,0,0,0,2198385.1685797106,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 1","Training technologies ","$",-5004283.8573638117,0,0,0,-3781211.0979130436,-2850839.2482608696,0,0,0,0,0,0,0,0,0,663205.03461739141,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 1","Operational Documentation Management System ","$",-2478436.466615573,0,0,-812964.69997470349,-2166319.0153992092,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 1","Opertional Document Management System (refresh)","$",-1484278.5318000556,0,0,0,0,0,0,0,-2383426.9722991302,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 1","Opertional Document Management System (refresh) (refresh)","$",-670181.94897353044,0,0,0,0,0,0,0,0,0,0,0,-2383426.9722991302,0,0,1191713.4861495651,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 1","Operational Planning Systems ","$",-3729331.3657787316,0,0,-3715810.6201675907,-592673.92074835324,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 1","Operational planning system (refresh)","$",-2146486.1086153239,0,0,0,0,0,0,0,-3446787.632732755,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 1","Operational planning system (refresh) (refresh)","$",-969182.13993962784,0,0,0,0,0,0,0,0,0,0,0,-3446787.632732755,0,0,1723393.8163663775,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 1","Facilities","$",-4488493.55224506,0,0,-4608539.7,-174412.7,0,-450000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 1","Facilities(refresh)","$",-1051080.9470896614,0,0,0,0,0,0,0,0,0,0,-2616476.2000000002,-2616476.2000000002,0,0,3924714.3000000003,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 1","CPA submission ","$",-6134579.4392523365,-5200000,-1000000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 2","Data Management and Network Modelling ","$",-22619162.984044507,0,0,-2779235.9803789253,-16405196.168306807,-8913601.4150011241,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 2","Data Management and Network Modelling (refresh)","$",-14019802.846236922,0,0,0,0,0,0,-7492808.9503164953,-7492808.9503164953,-7492808.9503164953,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 2","Data Management and Network Modelling (refresh) (refresh)","$",-4157499.3524356745,0,0,0,0,0,0,0,0,0,0,-7492808.9503164953,-7492808.9503164953,-7492808.9503164953,0,16858820.138212115,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 2","Enhanced EMS/SCADA ","$",-23213352.038796529,0,-324279.57949586608,-5888877.5561953578,-13640049.182315217,-5589935.6451846845,-5464279.123619467,-3759672.3295240891,0,0,0,0,0,0,0,10400128.024900407,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 2","Enhanced EMS/SCADA (hardware refresh)","$",-6697726.6928812992,0,0,0,0,0,0,0,-5559392,-5559392,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 2","Enhanced EMS/SCADA (hardware refresh) (refresh)","$",-1875621.5248413659,0,0,0,0,0,0,0,0,0,0,0,-5559392,-5559392,0,8339088,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 2","Outage Management System and Switching execution ","$",-1222320.2796122613,0,0,-387904.81815652177,-1082336.7468695655,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 2","Outage Management System and Switching execution (refresh)","$",-758110.63564597839,0,0,0,0,0,0,-588096.62601043493,-588096.62601043493,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 2","Outage Management System and Switching execution (refresh)(refresh)","$",-350284.96318565833,0,0,0,0,0,0,0,0,0,0,-588096.62601043493,-588096.62601043493,0,0,588096.62601043493,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 2","Fault level and system parameter monitoring ","$",-4645990.4367265506,0,0,0,0,-1623844.2871551723,-5560264.3614655184,0,0,0,0,0,0,0,0,1436821.729724138,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 2","Alarm Management technologies ","$",-15045670.738472782,-2990000,0,-1167577.3357554777,-5936971.9381152447,-5682130.1561036501,-4844569.6114631873,0,0,0,0,0,0,0,0,4124249.8082875125,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 2","Operator Visualisation and Situational Awareness technology ","$",-9003277.8513059895,0,0,0,0,-6353498.8091046484,-6728551.2386206891,-1601632.8696551726,0,0,0,0,0,0,0,4405104.8752141539,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 2","Training technologies ","$",-5004283.8573638117,0,0,0,-3781211.0979130436,-2850839.2482608696,0,0,0,0,0,0,0,0,0,663205.03461739141,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 2","Operational Documentation Management System ","$",-2478436.466615573,0,0,-812964.69997470349,-2166319.0153992092,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 2","Operational Documentation Management System (refresh)","$",-1484278.5318000556,0,0,0,0,0,0,0,-2383426.9722991302,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 2","Operational Documentation Management System (refresh)(refresh)","$",-670181.94897353044,0,0,0,0,0,0,0,0,0,0,0,-2383426.9722991302,0,0,1191713.4861495651,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 2","Operational Planning Systems ","$",-3729331.3657787316,0,0,-3715810.6201675907,-592673.92074835324,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 2","Operational Planning Systems (refresh)","$",-2146486.1086153239,0,0,0,0,0,0,0,-3446787.632732755,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 2","Operational Planning Systems (refresh)(refresh)","$",-969182.13993962784,0,0,0,0,0,0,0,0,0,0,0,-3446787.632732755,0,0,1723393.8163663775,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 2","Facilities","$",-4527474.5723383259,0,0,-4608539.7,-174412.7,0,0,-540000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 2","Facilities (refresh)","$",-1069158.1773044958,0,0,0,0,0,0,0,0,0,0,-2661476.2000000002,-2661476.2000000002,0,0,3992214.3000000003,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 2","Operational forecasts and look-ahead contingency assessment ","$",-2475702.23056255,0,0,0,0,0,-3694742.2543185558,-493216.263497537,0,0,0,0,0,0,0,1256387.5553448279,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 2","Wide Area Monitoring ","$",-3984080.4960495075,0,0,0,0,0,-6164605.8985878499,-556409.93532019702,0,0,0,0,0,0,0,2016304.7501724139,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 2","Smart Transmission Device Management ","$",-2364167.4113149941,0,0,0,0,0,-3509313.4128735634,-491579.22103448276,0,0,0,0,0,0,0,1200267.7901724139,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 2","CPA submission ","$",-6134579.4392523365,-5200000,-1000000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 2","Project management","$",-15569109.696002468,0,-896595.78067049815,-4891102.5818108711,-3858335.533960219,-3458628.444050774,-1803412.5407586207,-5080213.6976666683,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 2","Project management(refresh)","$",-5349805.7596153263,0,0,0,0,0,0,-922220.60515583563,-2222041.4973278912,-1489561.8498846162,0,-1225957.3792820221,-2525778.2714540777,-1489561.8498846162,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"Capital cost"]
[null,"Option name",null,"Units","PV",2025,2026,2027,2028,2029,2030,2031,2032,2033,2034,2035,2036,2037,2038,2039,2040,2041,2042,2043,2044,2045,2046,2047,2048,2049,2050,2051,2052,2053,2054]
[null,"Option 1",null,"$",-104093946.88122059,-8190000,-1689542.2594698702,-28937480.384597041,-47104722.484605961,-13735815.511235408,-4263512.4572486095,-1904224.5817429544,-13391523.390456686,-6185953.6126930285,-7435801.1603499129,-4815586.1842195075,-6302884.9929332398,8814046.3873069715,-1185953.6126930285,5659413.330547832,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 2",null,"$",-133766338.18143854,-8190000,-2220875.3601663643,-24252013.292439446,-47637506.303627655,-24472478.004860923,-22769738.441707447,-16525850.498180915,-21692553.678686708,-14541762.800201112,5000000,-6968339.155608952,-14657766.652812894,458237.1997988876,5000000,25695795.935171746,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"Planned routine maintenance and refurbishment "]
[null,"Option name",null,"Units","PV",2025,2026,2027,2028,2029,2030,2031,2032,2033,2034,2035,2036,2037,2038,2039,2040,2041,2042,2043,2044,2045,2046,2047,2048,2049,2050,2051,2052,2053,2054]
[null,"Option 1",null,"$",-33131221.501269139,0,0,0,-788579.16666666674,-2233965,-3879775.3333333335,-5924226,-6049226,-6049226,-6049226,-6049226,-6049226,-6049226,-6049226,-6049226,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 2",null,"$",-44163332.163250737,0,0,0,-788579.16666666674,-2691135,-5017205.333333334,-7917816,-8196526,-8196526,-8196526,-8196526,-8196526,-8196526,-8196526,-8196526,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"Incremental 'market benefits' calculation"]
[]
[null,"Involuntary load shedding"]
[null,"Option name",null,"Units","PV",2025,2026,2027,2028,2029,2030,2031,2032,2033,2034,2035,2036,2037,2038,2039,2040,2041,2042,2043,2044,2045,2046,2047,2048,2049,2050,2051,2052,2053,2054]
[null,"Option 1",null,"$",112766419.88056251,8328611.9571055453,9173163.675767418,10095142.436452072,11131664.104420278,2454479.913765002,13395495.267295701,14700015.772647487,16165699.800629113,17670028.756844968,19356320.443650417,9728026.3144047353,10674331.946429584,11643040.277436245,12728454.375146581,13908775.549176848,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 2",null,"$",150677709.02163807,8328611.9571055453,9173163.675767418,10095142.436452072,11131664.104420278,12198745.828775713,13395495.267295701,14700015.772647487,16165699.800629113,17670028.756844968,19356320.443650417,21192109.825700212,23253598.172298752,25363889.887830574,27728420.371365581,30299702.062144961,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"Avoided generation dispatch costs"]
[null,"Option name",null,"Units","PV",2025,2026,2027,2028,2029,2030,2031,2032,2033,2034,2035,2036,2037,2038,2039,2040,2041,2042,2043,2044,2045,2046,2047,2048,2049,2050,2051,2052,2053,2054]
[null,"Option 1",null,"$",35629176.796987742,0,0,0,1052196.2092873065,4535699.1267741472,2478571.5131752165,6042886.3953037933,5653601.8720639748,5294236.5455294615,5625065.6168545978,6294956.4582429305,7267165.0230478514,7397206.0305481646,7662613.9218025357,7059200.9709042832,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 2",null,"$",55191016.443821386,0,0,0,1052196.2092873065,4694612.5892389668,2705661.137559033,7345016.1566974027,9401063.1072294265,8891707.1787501723,9541926.8406283036,10785865.309385972,12577832.091645731,12934479.472438179,13537742.031521846,12604159.280465644,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"Greenhouse gases"]
[null,"Option name",null,"Units","PV",2025,2026,2027,2028,2029,2030,2031,2032,2033,2034,2035,2036,2037,2038,2039,2040,2041,2042,2043,2044,2045,2046,2047,2048,2049,2050,2051,2052,2053,2054]
[null,"Option 1",null,"$",28780754.072764259,0,0,0,816990.73949431488,3036873.1506649442,1628463.6679287669,3655705.8339118627,3936663.9239237141,4109067.4870863091,4582130.9130519722,5325506.9047360998,6344582.8300971501,6843044.7577536767,7503015.2449332029,7712908.0907946602,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 2",null,"$",45651628.890707053,0,0,0,816990.73949431488,3143599.0685240002,1778165.8679444783,4444963.8284771498,6550477.5523124011,6905383.2376381997,7777454.4568987787,9130583.5942046754,10988600.358046617,11974086.448650587,13265660.15897055,13781079.160205707,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]

{"sheet":"S3","index":11,"n_rows":125,"n_cols":35,"rows_kept":125,"cut":false,"hidden":false,"merged":[]}
["S3","Green"]
["Calculating costs, benefits and NPV for each option"]
[]
[null,"Parameters for S3"]
[]
[null,"Parameters"]
[null,"General parameters",null,null,"Unit","Active","Scenario"]
[null,"Commercial discount rate",null,null,"Percent",7.0000000000000007E-2,7.0000000000000007E-2]
[]
[null,"Cost parameters",null,null,"Unit","Active","Scenario"]
[null,"Capital cost",null,null,"Factor",1,1]
[null,"Planned routine maintenance and refurbishment ",null,null,"Factor",1,1]
[]
[null,"Benefit parameters",null,null,"Unit","Active","Scenario"]
[null,"Involuntary load shedding",null,null,"Factor",1,1]
[null,"Avoided generation dispatch costs",null,null,"Factor",1,1]
[null,"Greenhouse gases",null,null,"Factor",1,1]
[]
[null,"Discount factor"]
[]
[null,null,null,null,null,2025,2026,2027,2028,2029,2030,2031,2032,2033,2034,2035,2036,2037,2038,2039,2040,2041,2042,2043,2044,2045,2046,2047,2048,2049,2050,2051,2052,2053,2054]
[null,null,null,null,"Discount year",0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29]
[null,null,null,null,"Discount factor",1,0.93457943925233644,0.87343872827321156,0.81629787689085187,0.7628952120475252,0.71298617948366838,0.66634222381651254,0.62274974188459109,0.5820091045650384,0.54393374258414806,0.5083492921347178,0.47509279638758667,0.44401195924073528,0.41496444788853759,0.3878172410173249,0.36244601964235967,0.33873459779659787,0.31657439046411018,0.29586391632159825,0.27650833301083949,0.2584190028138687,0.24151308674193336,0.22571316517937698,0.21094688334521211,0.19714661994879637,0.18424917752223957,0.17219549301143888,0.16093036730041013,0.15040221243028987,0.1405628153554111]
[]
[]
[null,"Gross calculations for the base case"]
[]
[null,"Gross costs for the base case"]
[null,"Category",null,"Units","PV",2025,2026,2027,2028,2029,2030,2031,2032,2033,2034,2035,2036,2037,2038,2039,"","","","","","","","","","","","","","",""]
[null,"Capital cost",null,"$",-27798740.364273697,0,0,0,0,-10000000,-15000000,-5000000,0,0,-5000000,-5000000,-10000000,-15000000,-5000000,32500000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Planned routine maintenance and refurbishment ",null,"$",-452263.12585986248,0,0,0,0,-250000,-250000,-125000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"Incremental net present value calculation"]
[]
[null,"Net present value for each option",null,null,null,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option name",null,"Units","NPV",2025,2026,2027,2028,2029,2030,2031,2032,2033,2034,2035,2036,2037,2038,2039,"","","","","","","","","","","","","","",""]
[null,"Option 1",null,"$",97787001.346470103,605636.92666286416,-131906.97847791924,-27127167.053084843,-41903724.961925656,1181100.23078408,11518332.641125422,19098338.91695185,10763065.083405808,21535137.942057364,23653341.502111111,31690189.434422527,34775950.523909211,54171904.053426832,49839006.435239881,61619008.189995177,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 2",null,"$",198103466.78129774,605636.92666286416,-663240.07917441335,-22441699.960927248,-42436508.780947357,-8675259.3619516958,-4678818.551094478,7927381.8125567278,25929637.389959849,40144646.622693174,66889394.403797463,65856373.488437593,56126162.602837868,78567506.7073147,93487649.576647133,122001013.69305322,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[]
[null,"Incremental cost calculation",null,null,null,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"Capital outflow"]
[null,"Option name","Capex component","Units","PV",2025,2026,2027,2028,2029,2030,2031,2032,2033,2034,2035,2036,2037,2038,2039,2040,2041,2042,2043,2044,2045,2046,2047,2048,2049,2050,2051,2052,2053,2054]
[null,"Base case","SCADA/EMS","$",-21655455.931812841,0,0,0,0,-10000000,-15000000,-5000000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Base case","SCADA/EMS (hardware refresh)","$",-4291872.0710510174,0,0,0,0,0,0,0,0,0,-5000000,-5000000,0,0,0,2500000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Base case","SCADA/EMS (refresh 1)","$",-1851412.3614098355,0,0,0,0,0,0,0,0,0,0,0,-10000000,-15000000,-5000000,30000000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 1","Project management","$",-11372833.844546473,0,-423071.55576521734,-3615534.2052043471,-2092911.0911884054,-3487211.5304057966,-4839752.1692086961,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 1","Project management(refresh)","$",-4639938.2571806917,0,0,0,0,0,-633033.28859601519,-699313.69667165144,-1356397.9003534981,-626561.61269302899,-1259594.9012890442,-994199.09914820432,-1651283.3028300512,-626561.61269302899,-626561.61269302899,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 1","Data Management and Network Modelling ","$",-17512610.027729161,0,0,-5580669.3531594202,-15482384.118318837,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 1","Data Management and Network Modelling (refresh)","$",-11245301.073627964,0,0,0,0,0,-5616814.2590608681,-5616814.2590608681,-5616814.2590608681,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 1","Data Management and Network Modelling (refresh) (refresh)","$",-5311540.2332200324,0,0,0,0,0,0,0,0,0,-5616814.2590608681,-5616814.2590608681,-5616814.2590608681,0,0,8425221.3885913026,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 1","Enhanced EMS/SCADA ","$",-22260555.11382227,0,-266470.70370465296,-6998581.8481083727,-13719936.847540526,-5602281.6124528013,-3914521.4689240898,0,0,0,0,0,0,0,0,6100358.4961460903,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 1","Enhanced EMS/SCADA (hardware refresh)","$",-6259557.6568984101,0,0,0,0,0,0,0,0,-5559392,-5559392,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 1","Enhanced EMS/SCADA (hardware refresh) (refresh)","$",-463330.43163564708,0,0,0,0,0,0,0,0,0,0,0,0,-5559392,-5559392,11118784,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 1","Outage Management System and Switching execution ","$",-1222320.2796122613,0,0,-387904.81815652177,-1082336.7468695655,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 1","Outage Management and Switching Execution  (refresh)","$",-758110.63564597839,0,0,0,0,0,0,-588096.62601043493,-588096.62601043493,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 1","Outage Management and Switching Execution  (refresh) (refresh)","$",-350284.96318565833,0,0,0,0,0,0,0,0,0,0,-588096.62601043493,-588096.62601043493,0,0,588096.62601043493,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 1","Fault level and system parameter monitoring ","$",-2298983.9650895512,0,0,0,0,-2490165.5291594202,-932283.97657971014,0,0,0,0,0,0,0,0,684489.90114782611,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 1","Alarm Management technologies ","$",-12624759.288107483,-2990000,0,-3217475.1398260873,-7512471.3916521734,-1690564.5979130436,0,0,0,0,0,0,0,0,0,1541051.1129391305,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 1","Operator Visualisation and Situational Awareness technology ","$",-7416227.1175190015,0,0,0,-500065.55497584539,-7614752.9930434786,-2877107.2948792269,0,0,0,0,0,0,0,0,2198385.1685797106,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 1","Training technologies ","$",-5004283.8573638117,0,0,0,-3781211.0979130436,-2850839.2482608696,0,0,0,0,0,0,0,0,0,663205.03461739141,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 1","Operational Documentation Management System ","$",-2478436.466615573,0,0,-812964.69997470349,-2166319.0153992092,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 1","Opertional Document Management System (refresh)","$",-1484278.5318000556,0,0,0,0,0,0,0,-2383426.9722991302,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 1","Opertional Document Management System (refresh) (refresh)","$",-670181.94897353044,0,0,0,0,0,0,0,0,0,0,0,-2383426.9722991302,0,0,1191713.4861495651,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 1","Operational Planning Systems ","$",-3729331.3657787316,0,0,-3715810.6201675907,-592673.92074835324,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 1","Operational planning system (refresh)","$",-2146486.1086153239,0,0,0,0,0,0,0,-3446787.632732755,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 1","Operational planning system (refresh) (refresh)","$",-969182.13993962784,0,0,0,0,0,0,0,0,0,0,0,-3446787.632732755,0,0,1723393.8163663775,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 1","Facilities","$",-4488493.55224506,0,0,-4608539.7,-174412.7,0,-450000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 1","Facilities(refresh)","$",-1051080.9470896614,0,0,0,0,0,0,0,0,0,0,-2616476.2000000002,-2616476.2000000002,0,0,3924714.3000000003,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 1","CPA submission ","$",-6134579.4392523365,-5200000,-1000000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 2","Data Management and Network Modelling ","$",-22619162.984044507,0,0,-2779235.9803789253,-16405196.168306807,-8913601.4150011241,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 2","Data Management and Network Modelling (refresh)","$",-14019802.846236922,0,0,0,0,0,0,-7492808.9503164953,-7492808.9503164953,-7492808.9503164953,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 2","Data Management and Network Modelling (refresh) (refresh)","$",-4157499.3524356745,0,0,0,0,0,0,0,0,0,0,-7492808.9503164953,-7492808.9503164953,-7492808.9503164953,0,16858820.138212115,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 2","Enhanced EMS/SCADA ","$",-23213352.038796529,0,-324279.57949586608,-5888877.5561953578,-13640049.182315217,-5589935.6451846845,-5464279.123619467,-3759672.3295240891,0,0,0,0,0,0,0,10400128.024900407,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 2","Enhanced EMS/SCADA (hardware refresh)","$",-6697726.6928812992,0,0,0,0,0,0,0,-5559392,-5559392,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 2","Enhanced EMS/SCADA (hardware refresh) (refresh)","$",-1875621.5248413659,0,0,0,0,0,0,0,0,0,0,0,-5559392,-5559392,0,8339088,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 2","Outage Management System and Switching execution ","$",-1222320.2796122613,0,0,-387904.81815652177,-1082336.7468695655,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 2","Outage Management System and Switching execution (refresh)","$",-758110.63564597839,0,0,0,0,0,0,-588096.62601043493,-588096.62601043493,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 2","Outage Management System and Switching execution (refresh)(refresh)","$",-350284.96318565833,0,0,0,0,0,0,0,0,0,0,-588096.62601043493,-588096.62601043493,0,0,588096.62601043493,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 2","Fault level and system parameter monitoring ","$",-4645990.4367265506,0,0,0,0,-1623844.2871551723,-5560264.3614655184,0,0,0,0,0,0,0,0,1436821.729724138,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 2","Alarm Management technologies ","$",-15045670.738472782,-2990000,0,-1167577.3357554777,-5936971.9381152447,-5682130.1561036501,-4844569.6114631873,0,0,0,0,0,0,0,0,4124249.8082875125,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 2","Operator Visualisation and Situational Awareness technology ","$",-9003277.8513059895,0,0,0,0,-6353498.8091046484,-6728551.2386206891,-1601632.8696551726,0,0,0,0,0,0,0,4405104.8752141539,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 2","Training technologies ","$",-5004283.8573638117,0,0,0,-3781211.0979130436,-2850839.2482608696,0,0,0,0,0,0,0,0,0,663205.03461739141,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 2","Operational Documentation Management System ","$",-2478436.466615573,0,0,-812964.69997470349,-2166319.0153992092,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 2","Operational Documentation Management System (refresh)","$",-1484278.5318000556,0,0,0,0,0,0,0,-2383426.9722991302,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 2","Operational Documentation Management System (refresh)(refresh)","$",-670181.94897353044,0,0,0,0,0,0,0,0,0,0,0,-2383426.9722991302,0,0,1191713.4861495651,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 2","Operational Planning Systems ","$",-3729331.3657787316,0,0,-3715810.6201675907,-592673.92074835324,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 2","Operational Planning Systems (refresh)","$",-2146486.1086153239,0,0,0,0,0,0,0,-3446787.632732755,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 2","Operational Planning Systems (refresh)(refresh)","$",-969182.13993962784,0,0,0,0,0,0,0,0,0,0,0,-3446787.632732755,0,0,1723393.8163663775,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 2","Facilities","$",-4527474.5723383259,0,0,-4608539.7,-174412.7,0,0,-540000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 2","Facilities (refresh)","$",-1069158.1773044958,0,0,0,0,0,0,0,0,0,0,-2661476.2000000002,-2661476.2000000002,0,0,3992214.3000000003,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 2","Operational forecasts and look-ahead contingency assessment ","$",-2475702.23056255,0,0,0,0,0,-3694742.2543185558,-493216.263497537,0,0,0,0,0,0,0,1256387.5553448279,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 2","Wide Area Monitoring ","$",-3984080.4960495075,0,0,0,0,0,-6164605.8985878499,-556409.93532019702,0,0,0,0,0,0,0,2016304.7501724139,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 2","Smart Transmission Device Management ","$",-2364167.4113149941,0,0,0,0,0,-3509313.4128735634,-491579.22103448276,0,0,0,0,0,0,0,1200267.7901724139,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 2","CPA submission ","$",-6134579.4392523365,-5200000,-1000000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 2","Project management","$",-15569109.696002468,0,-896595.78067049815,-4891102.5818108711,-3858335.533960219,-3458628.444050774,-1803412.5407586207,-5080213.6976666683,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 2","Project management(refresh)","$",-5349805.7596153263,0,0,0,0,0,0,-922220.60515583563,-2222041.4973278912,-1489561.8498846162,0,-1225957.3792820221,-2525778.2714540777,-1489561.8498846162,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"Capital cost"]
[null,"Option name",null,"Units","PV",2025,2026,2027,2028,2029,2030,2031,2032,2033,2034,2035,2036,2037,2038,2039,2040,2041,2042,2043,2044,2045,2046,2047,2048,2049,2050,2051,2052,2053,2054]
[null,"Option 1",null,"$",-104093946.88122059,-8190000,-1689542.2594698702,-28937480.384597041,-47104722.484605961,-13735815.511235408,-4263512.4572486095,-1904224.5817429544,-13391523.390456686,-6185953.6126930285,-7435801.1603499129,-4815586.1842195075,-6302884.9929332398,8814046.3873069715,-1185953.6126930285,5659413.330547832,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 2",null,"$",-133766338.18143854,-8190000,-2220875.3601663643,-24252013.292439446,-47637506.303627655,-24472478.004860923,-22769738.441707447,-16525850.498180915,-21692553.678686708,-14541762.800201112,5000000,-6968339.155608952,-14657766.652812894,458237.1997988876,5000000,25695795.935171746,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"Planned routine maintenance and refurbishment "]
[null,"Option name",null,"Units","PV",2025,2026,2027,2028,2029,2030,2031,2032,2033,2034,2035,2036,2037,2038,2039,2040,2041,2042,2043,2044,2045,2046,2047,2048,2049,2050,2051,2052,2053,2054]
[null,"Option 1",null,"$",-33131221.501269139,0,0,0,-788579.16666666674,-2233965,-3879775.3333333335,-5924226,-6049226,-6049226,-6049226,-6049226,-6049226,-6049226,-6049226,-6049226,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 2",null,"$",-44163332.163250737,0,0,0,-788579.16666666674,-2691135,-5017205.333333334,-7917816,-8196526,-8196526,-8196526,-8196526,-8196526,-8196526,-8196526,-8196526,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"Incremental 'market benefits' calculation"]
[]
[null,"Involuntary load shedding"]
[null,"Option name",null,"Units","PV",2025,2026,2027,2028,2029,2030,2031,2032,2033,2034,2035,2036,2037,2038,2039,2040,2041,2042,2043,2044,2045,2046,2047,2048,2049,2050,2051,2052,2053,2054]
[null,"Option 1",null,"$",103103293.85211244,8795636.9266628642,1557635.280991951,1810313.3315121997,2786012.4715358615,3224280.4604068827,5470973.3051209822,9886236.6488502659,11481599.049427133,13253780.969182586,15332748.14180639,17728257.880933288,20543606.781810902,23664484.873354893,27321276.80452418,31528904.843437634,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 2",null,"$",172084476.65927181,8795636.9266628642,1557635.280991951,1810313.3315121997,2786012.4715358615,4104305.7616947126,7610838.1571248919,11681548.943882467,25012196.736127343,28872822.998925023,33401768.462511074,38620289.037947878,33489882.324955881,38577491.387298338,44538739.222811691,51397951.891112916,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"Avoided generation dispatch costs"]
[null,"Option name",null,"Units","PV",2025,2026,2027,2028,2029,2030,2031,2032,2033,2034,2035,2036,2037,2038,2039,2040,2041,2042,2043,2044,2045,2046,2047,2048,2049,2050,2051,2052,2053,2054]
[null,"Option 1",null,"$",85336643.800480425,0,0,0,2060261.2702825712,8826510.3810609635,9881619.5715178251,11877266.535303857,12881007.003432706,13831846.457595095,14544939.507175822,16301835.90713089,16636900.770867284,16832320.680468149,18150315.754386246,17486067.297540102,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 2",null,"$",139483062.5734036,0,0,0,2060261.2702825712,9157775.3866936304,10861456.459467605,14661260.715720041,22293968.286708206,24318350.075500287,25982717.049331345,29590425.381527908,30686664.213905111,31559278.903406963,34595163.374329753,33886274.669655524,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"Greenhouse gases"]
[null,"Option name",null,"Units","PV",2025,2026,2027,2028,2029,2030,2031,2032,2033,2034,2035,2036,2037,2038,2039,2040,2041,2042,2043,2044,2045,2046,2047,2048,2049,2050,2051,2052,2053,2054]
[null,"Option 1",null,"$",46572232.076366968,0,0,0,1143302.9475285299,5100089.9005516423,4309027.5550685581,5163286.3145406796,5841208.4210026534,6684690.1279727127,7260681.0134788109,8524907.8305778541,9947553.9641642645,10910278.112296818,11602593.489022486,12993848.718469612,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 2",null,"$",64465597.893311545,0,0,0,1143302.9475285299,5226272.4945208821,4635830.6073538084,6028238.6511351345,8512552.0458110087,9691762.3484689742,10701434.891955046,12810524.224570755,14803908.716789773,16169025.216810517,17550272.979505681,19217517.197113045,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]

{"sheet":"Weighted","index":12,"n_rows":218,"n_cols":35,"rows_kept":218,"cut":false,"hidden":false,"merged":[]}
["Weighted"]
["Calculating costs, benefits and NPV for each option"]
[]
[null,"Parameters for Weighted"]
[]
[null,"Parameters"]
[null,"General parameters",null,"Unit","Step","Progressive","Green","[Spare scenario]"]
[null,"Scenario weighting",null,"%",0.43,0.42,0.15,0]
[]
[]
[null,"Gross calculations for the base case"]
[]
[null,"Gross costs for base case"]
[null,"Category",null,"Units","PV",2025,2026,2027,2028,2029,2030,2031,2032,2033,2034,2035,2036,2037,2038,2039,"","","","","","","","","","","","","","",""]
[null,"Capital cost",null,"$",-27798740.364273697,0,0,0,0,-10000000,-15000000,-5000000,0,0,-5000000,-5000000,-10000000,-15000000,-5000000,32500000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Planned routine maintenance and refurbishment ",null,"$",-452263.12585986248,0,0,0,0,-250000,-250000,-125000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"Incremental net present value calculation"]
[]
[null,"Net present value for each option",null,null,null,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option name",null,"Units","NPV",2025,2026,2027,2028,2029,2030,2031,2032,2033,2034,2035,2036,2037,2038,2039,"","","","","","","","","","","","","","",""]
[null,"Option 1",null,"$",52031284.210167535,342546.1938122412,6641717.4738657298,-23688144.408327349,-39417139.765091024,-3659605.7310903869,7952063.0160859339,15235175.640696229,5370234.4413099848,14528591.228508821,16174670.897349659,17558966.519468561,19656574.914634541,37502736.662108168,32290032.837918807,42299411.755680636,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 2",null,"$",118905912.39192995,342546.1938122412,6110384.373169235,-19002677.316169754,-39949923.584112711,-9944872.9739323817,-9830625.5274235234,5890697.4462011587,10177074.703113398,20836885.128530923,45586450.126513481,40075839.38033165,37993421.624827951,58792749.226327248,67998452.299190938,94700867.006245434,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[]
[null,"Incremental cost calculation",null,null,null,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"Capital cost"]
[null,"Option name",null,"Units","PV",2025,2026,2027,2028,2029,2030,2031,2032,2033,2034,2035,2036,2037,2038,2039,2040,2041,2042,2043,2044,2045,2046,2047,2048,2049,2050,2051,2052,2053,2054]
[null,"Option 1",null,"$",-104093946.88122058,-8190000,-1689542.2594698702,-28937480.384597041,-47104722.484605961,-13735815.511235408,-4263512.4572486095,-1904224.5817429544,-13391523.390456686,-6185953.6126930285,-7435801.1603499129,-4815586.1842195075,-6302884.9929332398,8814046.3873069715,-1185953.6126930285,5659413.330547832,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 2",null,"$",-133766338.18143854,-8190000,-2220875.3601663643,-24252013.29243945,-47637506.303627647,-24472478.004860923,-22769738.441707447,-16525850.498180915,-21692553.678686708,-14541762.800201112,5000000,-6968339.155608952,-14657766.652812893,458237.1997988876,5000000,25695795.935171746,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"Planned routine maintenance and refurbishment "]
[null,"Option name",null,"Units","PV",2025,2026,2027,2028,2029,2030,2031,2032,2033,2034,2035,2036,2037,2038,2039,2040,2041,2042,2043,2044,2045,2046,2047,2048,2049,2050,2051,2052,2053,2054]
[null,"Option 1",null,"$",-33131221.501269139,0,0,0,-788579.16666666674,-2233965,-3879775.333333333,-5924226,-6049226,-6049226,-6049226,-6049226,-6049226,-6049226,-6049226,-6049226,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 2",null,"$",-44163332.163250737,0,0,0,-788579.16666666674,-2691135,-5017205.333333333,-7917816,-8196526,-8196526,-8196526,-8196526,-8196526,-8196526,-8196526,-8196526,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Unplanned corrective maintenance"]
[null,"Option name",null,"Units","PV",2025,2026,2027,2028,2029,2030,2031,2032,2033,2034,2035,2036,2037,2038,2039,2040,2041,2042,2043,2044,2045,2046,2047,2048,2049,2050,2051,2052,2053,2054]
[null,"Option 1",null,"$",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 2",null,"$",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 3",null,"$",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 4",null,"$",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 5",null,"$",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 6",null,"$",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 7",null,"$",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 8",null,"$",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 9",null,"$",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 10",null,"$",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 11",null,"$",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 12",null,"$",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 13",null,"$",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 14",null,"$",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 15",null,"$",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"Decommissioning costs"]
[null,"Option name",null,"Units","PV",2025,2026,2027,2028,2029,2030,2031,2032,2033,2034,2035,2036,2037,2038,2039,2040,2041,2042,2043,2044,2045,2046,2047,2048,2049,2050,2051,2052,2053,2054]
[null,"Option 1",null,"$",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 2",null,"$",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 3",null,"$",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 4",null,"$",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 5",null,"$",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 6",null,"$",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 7",null,"$",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 8",null,"$",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 9",null,"$",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 10",null,"$",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 11",null,"$",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 12",null,"$",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 13",null,"$",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 14",null,"$",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 15",null,"$",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"NNO proponent charges"]
[null,"Option name",null,"Units","PV",2025,2026,2027,2028,2029,2030,2031,2032,2033,2034,2035,2036,2037,2038,2039,2040,2041,2042,2043,2044,2045,2046,2047,2048,2049,2050,2051,2052,2053,2054]
[null,"Option 1",null,"$",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 2",null,"$",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 3",null,"$",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 4",null,"$",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 5",null,"$",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 6",null,"$",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 7",null,"$",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 8",null,"$",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 9",null,"$",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 10",null,"$",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 11",null,"$",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 12",null,"$",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 13",null,"$",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 14",null,"$",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 15",null,"$",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"[Spare cost category]"]
[null,"Option name",null,"Units","PV",2025,2026,2027,2028,2029,2030,2031,2032,2033,2034,2035,2036,2037,2038,2039,2040,2041,2042,2043,2044,2045,2046,2047,2048,2049,2050,2051,2052,2053,2054]
[null,"Option 1",null,"$",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 2",null,"$",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 3",null,"$",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 4",null,"$",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 5",null,"$",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 6",null,"$",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 7",null,"$",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 8",null,"$",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 9",null,"$",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 10",null,"$",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 11",null,"$",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 12",null,"$",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 13",null,"$",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 14",null,"$",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 15",null,"$",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[]
[null,"Incremental avoided 'risk cost' benefits calculation"]
[]
[null,"Reliability and security risk costs"]
[null,"Option name",null,"Units","PV",2025,2026,2027,2028,2029,2030,2031,2032,2033,2034,2035,2036,2037,2038,2039,2040,2041,2042,2043,2044,2045,2046,2047,2048,2049,2050,2051,2052,2053,2054]
[null,"Option 1",null,"$",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 2",null,"$",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 3",null,"$",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 4",null,"$",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 5",null,"$",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 6",null,"$",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 7",null,"$",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 8",null,"$",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 9",null,"$",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 10",null,"$",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 11",null,"$",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 12",null,"$",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 13",null,"$",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 14",null,"$",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 15",null,"$",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"Safety and health risk costs"]
[null,"Option name",null,"Units","PV",2025,2026,2027,2028,2029,2030,2031,2032,2033,2034,2035,2036,2037,2038,2039,2040,2041,2042,2043,2044,2045,2046,2047,2048,2049,2050,2051,2052,2053,2054]
[null,"Option 1",null,"$",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 2",null,"$",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 3",null,"$",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 4",null,"$",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 5",null,"$",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 6",null,"$",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 7",null,"$",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 8",null,"$",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 9",null,"$",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 10",null,"$",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 11",null,"$",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 12",null,"$",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 13",null,"$",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 14",null,"$",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 15",null,"$",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"Environmental risk costs"]
[null,"Option name",null,"Units","PV",2025,2026,2027,2028,2029,2030,2031,2032,2033,2034,2035,2036,2037,2038,2039,2040,2041,2042,2043,2044,2045,2046,2047,2048,2049,2050,2051,2052,2053,2054]
[null,"Option 1",null,"$",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 2",null,"$",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 3",null,"$",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 4",null,"$",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 5",null,"$",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 6",null,"$",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 7",null,"$",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 8",null,"$",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 9",null,"$",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 10",null,"$",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 11",null,"$",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 12",null,"$",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 13",null,"$",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 14",null,"$",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 15",null,"$",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"Legal/regulatory compliance risk costs"]
[null,"Option name",null,"Units","PV",2025,2026,2027,2028,2029,2030,2031,2032,2033,2034,2035,2036,2037,2038,2039,2040,2041,2042,2043,2044,2045,2046,2047,2048,2049,2050,2051,2052,2053,2054]
[null,"Option 1",null,"$",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 2",null,"$",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 3",null,"$",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 4",null,"$",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 5",null,"$",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 6",null,"$",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 7",null,"$",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 8",null,"$",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 9",null,"$",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 10",null,"$",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 11",null,"$",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 12",null,"$",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 13",null,"$",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 14",null,"$",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 15",null,"$",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"Financial risk costs"]
[null,"Option name",null,"Units","PV",2025,2026,2027,2028,2029,2030,2031,2032,2033,2034,2035,2036,2037,2038,2039,2040,2041,2042,2043,2044,2045,2046,2047,2048,2049,2050,2051,2052,2053,2054]
[null,"Option 1",null,"$",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 2",null,"$",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 3",null,"$",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 4",null,"$",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 5",null,"$",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 6",null,"$",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 7",null,"$",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 8",null,"$",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 9",null,"$",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 10",null,"$",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 11",null,"$",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 12",null,"$",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 13",null,"$",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 14",null,"$",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 15",null,"$",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[]
[null,"Incremental 'market benefits' calculation"]
[]
[null,"Involuntary load shedding"]
[null,"Option name",null,"Units","PV",2025,2026,2027,2028,2029,2030,2031,2032,2033,2034,2035,2036,2037,2038,2039,2040,2041,2042,2043,2044,2045,2046,2047,2048,2049,2050,2051,2052,2053,2054]
[null,"Option 1",null,"$",103500740.06175935,8532546.1938122399,8331259.7333355993,5249335.9762696922,6208598.2592657097,2782537.3260388775,8560244.3282429054,11408496.144862797,12791669.647911556,14262465.492062293,15944418.155142101,13008615.343923479,14694596.970772851,16507351.736214904,18593549.23408379,20942612.188069612,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 2",null,"$",160467432.36932036,8532546.1938122399,8331259.7333355993,5249335.9762696922,6208598.2592657097,7353220.605929561,9707874.7083206307,16098846.882998619,19864871.878752284,22324368.812507462,25153799.305889644,28338739.651691046,30322052.60591675,34014400.616757303,33241974.491270084,37343180.650225379,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"Avoided generation dispatch costs"]
[null,"Option name",null,"Units","PV",2025,2026,2027,2028,2029,2030,2031,2032,2033,2034,2035,2036,2037,2038,2039,2040,2041,2042,2043,2044,2045,2046,2047,2048,2049,2050,2051,2052,2053,2054]
[null,"Option 1",null,"$",48253679.686353467,0,0,0,1288104.8867266076,5442466.1110113095,4481753.8647693973,7244842.1472421177,7109908.4803633345,7067421.3265626784,7802632.9318399271,8544476.9789889492,9259917.6839447711,9471420.6718579419,11585438.547457686,11567865.130573664,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 2",null,"$",77389043.026855201,0,0,0,1288104.8867266076,5640809.619119687,4914898.5342159681,8880831.1763694473,12094384.772748178,12194163.834440771,13646724.479183624,15145288.405496236,16618471.779322792,17237556.162225761,21422105.994834434,21718946.574387655,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"Greenhouse gases"]
[null,"Option name",null,"Units","PV",2025,2026,2027,2028,2029,2030,2031,2032,2033,2034,2035,2036,2037,2038,2039,2040,2041,2042,2043,2044,2045,2046,2047,2048,2049,2050,2051,2052,2053,2054]
[null,"Option 1",null,"$",37502032.844544448,0,0,0,979458.74018928455,4085171.3430948337,3053352.6136555732,4410287.9303342672,4909405.7034917781,5433884.0225768778,5912646.9707175419,6870686.3807756389,8054171.2528501563,8759143.8667283505,9346224.6690703612,10178747.106489521,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Option 2",null,"$",58979107.340443574,0,0,0,979458.74018928455,4224709.8058792911,3333545.0050806599,5354685.8850140069,8106897.7302996442,9056641.2817838006,9982452.341440212,11756676.478753323,13907189.892401299,15279081.247545306,16530897.813086413,18139469.846460663,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]