75INDEX(Workstreams[Workstream], MATCH($A1, Workstreams[Code], 0))Nuclear power generation754INDEX(Modules[Module], MATCH($A2, Modules[Code], 0))Nuclear power134182513361336II.a.Scenario22253745Preferences.EnergyUnitsTWh7841844269169272072172272372472572672745INDEX(Vectors[Description], MATCH([Vector], Vectors[Code], 0))Electricity (delivered to end user)INDEX(INDIRECT("'"&II.a.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&II.a.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH([Vector], INDIRECT("'"&II.a.Inputs[#Headers]&"'!Year.Vectors"), 0))-354.55512401053005INDEX(INDIRECT("'"&II.a.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&II.a.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH([Vector], INDIRECT("'"&II.a.Inputs[#Headers]&"'!Year.Vectors"), 0))-354.91515826061539INDEX(INDIRECT("'"&II.a.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&II.a.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH([Vector], INDIRECT("'"&II.a.Inputs[#Headers]&"'!Year.Vectors"), 0))-366.33806231663755INDEX(INDIRECT("'"&II.a.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&II.a.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH([Vector], INDIRECT("'"&II.a.Inputs[#Headers]&"'!Year.Vectors"), 0))-397.94664348603783INDEX(INDIRECT("'"&II.a.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&II.a.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH([Vector], INDIRECT("'"&II.a.Inputs[#Headers]&"'!Year.Vectors"), 0))-449.38167849223646INDEX(INDIRECT("'"&II.a.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&II.a.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH([Vector], INDIRECT("'"&II.a.Inputs[#Headers]&"'!Year.Vectors"), 0))-501.94726834166431INDEX(INDIRECT("'"&II.a.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&II.a.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH([Vector], INDIRECT("'"&II.a.Inputs[#Headers]&"'!Year.Vectors"), 0))-547.61520198951655INDEX(INDIRECT("'"&II.a.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&II.a.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH([Vector], INDIRECT("'"&II.a.Inputs[#Headers]&"'!Year.Vectors"), 0))-608.78355692995581INDEX(INDIRECT("'"&II.a.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&II.a.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH([Vector], INDIRECT("'"&II.a.Inputs[#Headers]&"'!Year.Vectors"), 0))-679.53514658109339INDEX(INDIRECT("'"&II.a.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&II.a.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH([Vector], INDIRECT("'"&II.a.Inputs[#Headers]&"'!Year.Vectors"), 0))-757.4623580551859746INDEX(Vectors[Description], MATCH([Vector], Vectors[Code], 0))Electricity (supplied to grid)INDEX(INDIRECT("'"&II.a.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&II.a.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH([Vector], INDIRECT("'"&II.a.Inputs[#Headers]&"'!Year.Vectors"), 0))-17.749349778977443INDEX(INDIRECT("'"&II.a.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&II.a.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH([Vector], INDIRECT("'"&II.a.Inputs[#Headers]&"'!Year.Vectors"), 0))-6.8587003581504336INDEX(INDIRECT("'"&II.a.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&II.a.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH([Vector], INDIRECT("'"&II.a.Inputs[#Headers]&"'!Year.Vectors"), 0))24.016920893506391INDEX(INDIRECT("'"&II.a.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&II.a.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH([Vector], INDIRECT("'"&II.a.Inputs[#Headers]&"'!Year.Vectors"), 0))65.45961265841666INDEX(INDIRECT("'"&II.a.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&II.a.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH([Vector], INDIRECT("'"&II.a.Inputs[#Headers]&"'!Year.Vectors"), 0))129.48647034665544INDEX(INDIRECT("'"&II.a.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&II.a.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH([Vector], INDIRECT("'"&II.a.Inputs[#Headers]&"'!Year.Vectors"), 0))198.03640839450432INDEX(INDIRECT("'"&II.a.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&II.a.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH([Vector], INDIRECT("'"&II.a.Inputs[#Headers]&"'!Year.Vectors"), 0))245.91046086975172INDEX(INDIRECT("'"&II.a.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&II.a.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH([Vector], INDIRECT("'"&II.a.Inputs[#Headers]&"'!Year.Vectors"), 0))279.67903764266225INDEX(INDIRECT("'"&II.a.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&II.a.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH([Vector], INDIRECT("'"&II.a.Inputs[#Headers]&"'!Year.Vectors"), 0))298.45048824398577INDEX(INDIRECT("'"&II.a.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&II.a.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH([Vector], INDIRECT("'"&II.a.Inputs[#Headers]&"'!Year.Vectors"), 0))323.8494205699666413381571Preferences.PowerUnits & " per annum, for subsequent period"GW per annum, for subsequent period13367944220072010201520202025203020352040204520501(Unit.GW)*00000000002(Unit.GW)*000(Unit.GW)*0.640.64(Unit.GW)*1.21.21.21.21.21.21.2300(Unit.GW)*0.640.64(Unit.GW)*2.42.4(Unit.GW)*33(Unit.GW)*33(Unit.GW)*33(Unit.GW)*33(Unit.GW)*33400(Unit.GW)*1.241.24(Unit.GW)*33(Unit.GW)*55(Unit.GW)*55(Unit.GW)*55(Unit.GW)*55(Unit.GW)*551280(INDEX(F$24:F$27,ROUNDDOWN($E$7,0))*(1-MOD($E$7,1)))+(INDEX(F$24:F$27,ROUNDUP($E$7,0))*MOD($E$7,1))0(INDEX(G$24:G$27,ROUNDDOWN($E$7,0))*(1-MOD($E$7,1)))+(INDEX(G$24:G$27,ROUNDUP($E$7,0))*MOD($E$7,1))00.641.21.21.21.21.21.202252Preferences.PowerUnits & " per annum, for subsequent period"GW per annum, for subsequent period133679442200720102015202020252030203520402045205010000000002000000000300000000040000000001280(INDEX(F$33:F$36,ROUNDDOWN($E$7,0))*(1-MOD($E$7,1)))+(INDEX(F$33:F$36,ROUNDUP($E$7,0))*MOD($E$7,1))0(INDEX(G$33:G$36,ROUNDDOWN($E$7,0))*(1-MOD($E$7,1)))+(INDEX(G$33:G$36,ROUNDUP($E$7,0))*MOD($E$7,1))0000000007177847387157304426916927207217227237247257267277INDEX(Vectors[Description], MATCH($C49, Vectors[Code], 0))Nuclear fission'2007 (Actual, frozen)'!$AZ$94/'2007 (Actual, frozen)'!$U$940.100952999999999990.10.10.10.10.10.10.10.10.17287157304426916927207217227237247257267277INDEX(Vectors[Description], MATCH($C54, Vectors[Code], 0))Nuclear fission1090.386000000000000010.360.360.360.360.360.360.360.360.367717157304426916927207217227237247257267277INDEX(Vectors[Description], MATCH($C59, Vectors[Code], 0))Nuclear fission1090.595999999999999970.60.70.80.80.80.80.80.80.8880Preferences.PowerUnitsGW71573044220077INDEX(Vectors[Description], MATCH($C64, Vectors[Code], 0))Nuclear fission11711*Unit.GW111243Preferences.PowerUnits & " per annum, following period"GW per annum, following period715730442200720102015202020252030203520402045205071244118(-1/3)*Unit.GW-0.33333333333333331(-2.8/5)*Unit.GW-0.55999999999999994(-3.6/5)*Unit.GW-0.72-(Unit.GW)*(1.2+1.2)/5-0.48(Unit.GW)*00-(Unit.GW)*1.2/5-0.24(Unit.GW)*00(Unit.GW)*00(Unit.GW)*0027388528123*Unit.GW3Preferences.PowerUnits&"peak"GWpeak75510915628741171145118873'2007 (Actual, frozen)'!$U$88/'2007 (Actual, frozen)'!$U$900.8599271238174098816723170180117993774343337743433336137753361377538144418.8971702.3999999999999463191Preferences.moneyunits&"/ 3 GW capacity"£m/ 3 GW capacity180117993176D89*(GBP/Unit.kW)*plantsize.II.a13256.400000000001F89*(GBP/Unit.kW)*plantsize.II.a5107.23177E89*(GBP/Unit.kW)*plantsize.II.a291G89*(GBP/Unit.kW)*plantsize.II.a1383815334833470.105833333333333*(MGBP/Unit.TWh)*Price20000.137075605291333810.105833333333333*(MGBP/Unit.TWh)*Price20000.13707560529133381335333470.0375*(MGBP/Unit.TWh)3.7499999999999999E-20.0256944444444444*(MGBP/Unit.TWh)2.5694444444444402E-2335136531799180117991801334633522.3800000000000002E-20.222Preferences.moneyunits&"/"&Preferences.EnergyUnits£m/TWhF105/Unit.GJ*GBP*Price20000.11097295617034506G105/Unit.GJ*GBP*Price20001.03512589368977343837604421093192812716Preferences.PowerUnitsGW71573044220072010201520202025203020352040204520507INDEX(Vectors[Description], MATCH($C119, Vectors[Code], 0))Nuclear fission$F$6411F119+(G$118-F$118)*(F28+F37)+(G$118-F$118)*F$69107.26.800000000000000710.416.39999999999999921.227.233.20000000000000339.2000000000000037311768762Preferences.PowerUnitsGWF$11911G$119107.26.800000000000000710.416.39999999999999921.227.233.20000000000000339.200000000000003O12539.2000000000000031914802F$590.59599999999999997G$590.60.70.80.80.80.80.80.80.8763F125*F1266.556G125*G12665.045.44000000000000138.3213.1216.9621.7626.56000000000000231.360000000000003791Preferences.EnergyUnitsTWhF$127*Preferences.Unit.Power*Unit.year/Preferences.Unit.Energy57.46989599999999952.59599999999999744.18063999999999747.68704000000001772.933120000000002115.00991999999999148.67135999999999190.74816000000001232.82496000000003274.90176000000002O128274.90176000000002756Preferences.EnergyUnitsTWh-SUM(II.a.Inputs[2007])372.30447378950748-SUM(II.a.Inputs[2010])361.77385861876581-SUM(II.a.Inputs[2015])342.32114142313117-SUM(II.a.Inputs[2020])332.4870308276212-SUM(II.a.Inputs[2025])319.89520814558102-SUM(II.a.Inputs[2030])303.91085994716002-SUM(II.a.Inputs[2035])301.70474111976483-SUM(II.a.Inputs[2040])329.10451928729356-SUM(II.a.Inputs[2045])381.08465833710761-SUM(II.a.Inputs[2050])433.612937485219331767MAX(MIN(F$130,F$128),0)57.46989599999999952.59599999999999744.18063999999999747.68704000000001772.933120000000002115.00991999999999148.67135999999999190.74816000000001232.82496000000003274.901760000000021769F12857.469895999999999G12852.59599999999999744.18063999999999747.68704000000001772.933120000000002115.00991999999999148.67135999999999190.74816000000001232.82496000000003274.90176000000002O133274.90176000000002765F$49*F1335.8017584108879987G$49*G1335.25959999999999984.41806400000000024.76870400000000237.293312000000000211.50099214.86713619.07481600000000223.28249600000000527.490176000000005764F133+F13463.271654410887997G133+G13457.85559999999999548.59870399999999852.45574400000001780.226432000000003126.51091199999999163.53849599999998209.82297600000001256.10745600000001302.39193600000004O135302.39193600000004766F$540.38600000000000001G$540.360.360.360.360.360.360.360.360.36770F135/F136163.91620313701554G135/G136160.70999999999998134.99639999999999145.71040000000005222.85120000000001351.41919999999999454.27359999999999582.84160000000008711.40960000000007839.97760000000017O137839.97760000000017273938593445Preferences.PowerUnitsGWF280G2800.641.21.21.21.21.21.2O141/$D$1070.21777777777777779"Approximate total "&$F$74/Unit.GW&" GW locations"Approximate total 3 GW locations2740F125/$F$743.6666666666666665G125/$F$743.33333333333333352.42.26666666666666713.46666666666666685.46666666666666597.06666666666666649.066666666666666411.06666666666666813.066666666666668O14113.066666666666668"Approximate build rate of "&$F$74/Unit.GW&" GW locations"Approximate build rate of 3 GW locations2741F140/plantsize.Ib0000.533333333333333331111110.181481481481481493835318338593176Preferences.moneyunits£mF142*$G$940G142*$G$94002723.83999999999975107.25107.25107.25107.25107.2O142*$G$945107.2$Q$142*$G$94/'Global cost assumptions'!$P$530895.4074074074093177Preferences.moneyunits£m(F141*$G$95)+(-F176*($G$99+$G$100))532.68064853711189486.15877469303689353.17337074215101336.51728905502023514.67350090767786811.600520662107211049.1421364656511346.06915622008071642.9961759745104(O141*$G$95)+(O137*($G$99+$G$100))1939.9231957289398(($Q$141*$G$95)+($Q$137*($G$99+$G$100)))/'Global cost assumptions'!$P$564664.1065242979973349Preferences.moneyunits£m-(II.a!$J$105)*XVI.b!F1518.190265626333403-(II.a!$J$105)*XVI.b!G1517.834463786136151-(II.a!$J$105)*XVI.b!H1514.980949580354368-(II.a!$J$105)*XVI.b!I1516.169913832763452-(II.a!$J$105)*XVI.b!J1524.7304564501088-(II.a!$J$105)*XVI.b!K1538.998027479017722-(II.a!$J$105)*XVI.b!L1550.412084302144862-(II.a!$J$105)*XVI.b!M1564.679655331053794-(II.a!$J$105)*XVI.b!N1578.947226359962713-(II.a!$J$105)*XVI.b!O1593.214797388871645(-(II.a!$J$105)*XVI.b!$Q$15)/'Global cost assumptions'!$P$503184Preferences.moneyunits£mSUM(F145:F147)550.87091416344526SUM(G145:G147)503.99323847917304368.154320322505383076.52720288778355646.60395735778645957.79854814112516206.75422076779526517.94881155113496829.14340233447277140.3379931178115SUM(Q145:Q147)95559.51393170541331853176Preferences.moneyunits£mF142*$F$940G142*$F$94007070.080000000000813256.40000000000113256.40000000000113256.40000000000113256.40000000000113256.40000000000113256.400000000001$Q$142*$F$94/'Global cost assumptions'!$P$580193.0370370370513177Preferences.moneyunits£mF141*$F$95+(-F176*($F$99+$F$100))1095.6157703797016998.05604552637021721.96707824215105685.037481277242481047.70438312990021652.14921955099612135.70508868787332740.14992510896953344.59476153006613949.0395979511622(($Q$141*$F$95)+($Q$137*($F$99+$F$100)))/'Global cost assumptions'!$P$5131634.653265038743349Preferences.moneyunits£m-(II.a!$K$105)*XVI.b!F15169.67390626243764-(II.a!$K$105)*XVI.b!G15166.35508237488347-(II.a!$K$105)*XVI.b!H15139.7382691949021-(II.a!$K$105)*XVI.b!I15150.8286080198944-(II.a!$K$105)*XVI.b!J15230.67904755983844-(II.a!$K$105)*XVI.b!K15363.76311345974517-(II.a!$K$105)*XVI.b!L15470.23036617967063-(II.a!$K$105)*XVI.b!M15603.3144320795775-(II.a!$K$105)*XVI.b!N15736.39849797948432-(II.a!$K$105)*XVI.b!O15869.48256387939114(-(II.a!$K$105)*XVI.b!$Q$15)/'Global cost assumptions'!$P$503184Preferences.moneyunits£mSUM(F151:F153)1265.2896766421393SUM(G151:G153)1164.4111279012536861.705347437053217905.946089297137414534.7834306897415272.31233301074315862.33545486754516599.86435718854817337.3932595095518074.922161830556SUM(Q151:Q153)211827.69030207579383631833857Preferences.moneyunits£mI1452723.8399999999997J145+I1577831.0399999999991K145+J15712938.239999999998L145+K15718045.43999999999923152.63999999999928259.8433367.0400000000013176Preferences.moneyunits£mF145/$D$1070G145/$D$1070H145/$D$1070I157/$D$10745.397333333333329J157/$D$107130.51733333333331215.63733333333329300.75733333333329385.8773333333333470.99733333333336556.117333333333363177Preferences.moneyunits£mF146532.68064853711189486.15877469303689353.17337074215101336.51728905502023514.67350090767786811.600520662107211049.1421364656511346.06915622008071642.99617597451041939.92319572893983349Preferences.moneyunits£mF14718.19026562633340317.83446378613615114.98094958035436816.16991383276345224.730456450108838.99802747901772250.41208430214486264.67965533105379478.94722635996271393.2147973888716453184Preferences.moneyunits£mSUM(F158:F160)550.87091416344526SUM(G158:G160)503.99323847917304368.15432032250538398.08453622111699669.921290691120021066.23588147445821400.31155410112911796.62614488446772192.94073566780662589.255326451144831853176Preferences.moneyunits£mF151/$D$1070G151/$D$10700117.83466666666668220.94000000000003220.94000000000003220.94000000000003220.94000000000003220.94000000000003220.940000000000033177Preferences.moneyunits£mF1521095.6157703797016998.05604552637021721.96707824215105685.037481277242481047.70438312990021652.14921955099612135.70508868787332740.14992510896953344.59476153006613949.03959795116223349Preferences.moneyunits£mF153169.67390626243764166.35508237488347139.7382691949021150.8286080198944230.67904755983844363.76311345974517470.23036617967063603.3144320795775736.39849797948432869.482563879391143184Preferences.moneyunits£mSUM(F164:F166)1265.2896766421393SUM(G164:G166)1164.4111279012536861.70534743705321953.700755963803541499.32343068973862236.85233301074142826.87545486754383564.40435718854684301.93325950955025039.4621618305528683729Preferences.EnergyUnitsTWh7841844269169272072172272372472572672745INDEX(Vectors[Description], MATCH([Vector], Vectors[Code], 0))Electricity (delivered to end user)000000000046INDEX(Vectors[Description], MATCH([Vector], Vectors[Code], 0))Electricity (supplied to grid)F$13357.469895999999999G$13352.59599999999999744.18063999999999747.68704000000001772.933120000000002115.00991999999999148.67135999999999190.74816000000001232.82496000000003274.901760000000027INDEX(Vectors[Description], MATCH([Vector], Vectors[Code], 0))Nuclear fission-F$137-163.91620313701554-G$137-160.70999999999998-134.99639999999999-145.71040000000005-222.85120000000001-351.41919999999999-454.27359999999999-582.84160000000008-711.40960000000007-839.9776000000001734INDEX(Vectors[Description], MATCH([Vector], Vectors[Code], 0))Conversion losses(F$137-F$135)100.64454872612754(G$137-G$135)102.8543999999999886.39769599999999693.25465600000004142.62476800000002224.908288290.73510399999998373.01862400000005455.30214400000006537.5856640000001835INDEX(Vectors[Description], MATCH([Vector], Vectors[Code], 0))Distribution losses and own useF$1345.8017584108879987G$1345.25959999999999984.41806400000000024.76870400000000237.293312000000000211.50099214.86713619.07481600000000223.28249600000000527.490176000000005148SUBTOTAL(109,[2007])0SUBTOTAL(109,[2010])7.9936057773011271E-15SUBTOTAL(109,[2015])0SUBTOTAL(109,[2020])1.6875389974302379E-14SUBTOTAL(109,[2025])1.4210854715202004E-14SUBTOTAL(109,[2030])0SUBTOTAL(109,[2035])-1.5987211554602254E-14SUBTOTAL(109,[2040])-5.3290705182007514E-14SUBTOTAL(109,[2045])0SUBTOTAL(109,[2050])0261326187826144426916927207217227237247257267272620INDEX(Vectors[Description], MATCH([Vector], Vectors[Code], 0))Installed Capacity Preferences.PowerUnitsGWF11911G119107.26.800000000000000710.416.39999999999999921.227.233.20000000000000339.2000000000000033670INDEX(Vectors[Description], MATCH([Vector], Vectors[Code], 0))Load factor839F590.59599999999999997G590.60.70.80.80.80.80.80.80.82621$F$74&" GW nuclear power station complexes"3 GW nuclear power station complexes2740F187/$F$743.6666666666666665G187/$F$743.33333333333333352.42.26666666666666713.46666666666666685.46666666666666597.06666666666666649.066666666666666411.06666666666666813.06666666666666831893190Preferences.moneyunits£m78418442691692720721722723724725726727386138603131INDEX(CostVectors[Description], MATCH(C197, CostVectors[Code], 0))Low estimate of capital costsF1450G145002723.83999999999975107.25107.25107.25107.25107.25107.2Q14530895.4074074074093133INDEX(CostVectors[Description], MATCH(C198, CostVectors[Code], 0))Low estimate of operating costsF146532.68064853711189G146486.15877469303689353.17337074215101336.51728905502023514.67350090767786811.600520662107211049.1421364656511346.06915622008071642.99617597451041939.9231957289398Q14664664.1065242979973135INDEX(CostVectors[Description], MATCH(C199, CostVectors[Code], 0))Low estimate of fuel costsF14718.190265626333403G14717.83446378613615114.98094958035436816.16991383276345224.730456450108838.99802747901772250.41208430214486264.67965533105379478.94722635996271393.214797388871645Q14703140INDEX(CostVectors[Description], MATCH(C200, CostVectors[Code], 0))High estimate of capital costsF1510G151007070.080000000000813256.40000000000113256.40000000000113256.40000000000113256.40000000000113256.40000000000113256.400000000001Q15180193.0370370370513142INDEX(CostVectors[Description], MATCH(C201, CostVectors[Code], 0))High estimate of operating costsF1521095.6157703797016998.05604552637021721.96707824215105685.037481277242481047.70438312990021652.14921955099612135.70508868787332740.14992510896953344.59476153006613949.0395979511622Q152131634.653265038743144INDEX(CostVectors[Description], MATCH(C202, CostVectors[Code], 0))High estimate of fuel costsF153169.67390626243764G153166.35508237488347139.7382691949021150.8286080198944230.67904755983844363.76311345974517470.23036617967063603.3144320795775736.39849797948432869.48256387939114Q1530138323138C197C1.LowD197Low estimate of capital costs00002723.83999999999975107.25107.25107.25107.25107.25107.2(SUMPRODUCT(H214:O214,discount_factors)*5)+G214#VALUE!C198C2.LowLow estimate of operating costs0532.68064853711189486.15877469303689353.17337074215101336.51728905502023514.67350090767786811.600520662107211049.1421364656511346.06915622008071642.99617597451041939.9231957289398(SUMPRODUCT(H215:O215,discount_factors)*5)+G215#VALUE!C199C3.LowLow estimate of fuel costs018.19026562633340317.83446378613615114.98094958035436816.16991383276345224.730456450108838.99802747901772250.41208430214486264.67965533105379478.94722635996271393.214797388871645(SUMPRODUCT(H216:O216,discount_factors)*5)+G216#VALUE!SUM(Q214:Q216)#VALUE!383469169272072172272372472572672738333.53.53.53.53.53.53.53.53331313132F$221*F2140G$221*G214001682.73875162721292656.53914194335812236.73467422567591883.27057708006151585.66329183557971612.61651011598561391.057167468983631333134F$221*F215514.6672932725719G$221*G215423.65928563370841259.13424066612146207.89425329146306267.71035018841377355.44623789641042386.869227126542417.92223709474354518.78186862349719528.3803386900998531353136F$221*F21617.57513587085352915.54170485160000410.9919866999170029.989478316224145612.86368764838651817.07946434224715318.58936307477856120.08148402001673524.92786666978771525.38908051808407923838C222C1.LowD222Low estimate of capital costsF158*50G158*500226.98666666666665652.586666666666591078.18666666666651503.78666666666641929.38666666666652354.98666666666672780.586666666667(SUMPRODUCT(H228:O228,discount_factors)*5)+G228#VALUE!C223C2.LowLow estimate of operating costsF159532.68064853711189486.15877469303689353.17337074215101336.51728905502023514.67350090767786811.600520662107211049.1421364656511346.06915622008071642.99617597451041939.9231957289398(SUMPRODUCT(H229:O229,discount_factors)*5)+G229#VALUE!C224C3.LowLow estimate of fuel costsF16018.19026562633340317.83446378613615114.98094958035436816.16991383276345224.730456450108838.99802747901772250.41208430214486264.67965533105379478.94722635996271393.214797388871645(SUMPRODUCT(H230:O230,discount_factors)*5)+G230#VALUE!3834C228C1.LowD228Low estimate of capital costsF$221*F2280G$221*G22800140.22822930226775339.44666813720687472.19954233653152554.51855880690687599.0283546934412743.59539077570446757.35334673311343C229C2.LowLow estimate of operating costsF$221*F229514.6672932725719423.65928563370841259.13424066612146207.89425329146306267.71035018841377355.44623789641042386.869227126542417.92223709474354518.78186862349719528.38033869009985C230C3.LowLow estimate of fuel costsF$221*F23017.57513587085352915.54170485160000410.9919866999170029.989478316224145612.86368764838651817.07946434224715318.58936307477856120.08148402001673524.92786666978771525.3890805180840793839SUM(Q228:Q230)#VALUE!3844D24749997638.02743995233845D239+D240#VALUE!3840100038425000003841(G176*3)-(SUM(H176:O176)*5)16735.26838430.01NPV(D246,D250:D1250)49997638.027439952$D$244500000$D$244500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000$D$244500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000$D$244500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000$D$244500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000$D$244500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000$D$244500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000$D$244500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000$D$244500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000$D$244500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000$D$244500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000$D$244500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000$D$244500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000$D$244500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000$D$244500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000$D$244500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000$D$244500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000500000