674INDEX(Workstreams[Workstream], MATCH($A1, Workstreams[Code], 0))H2 Production968INDEX(Modules[Module], MATCH($A2, Modules[Code], 0))H2 Production for Transport682777Preferences.EnergyUnitsTWh784184426916927207217227237247257267271457INDEX(Vectors[Description], MATCH([Vector], Vectors[Code], 0))H2INDEX(INDIRECT("'"&VIII.a.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&VIII.a.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH([Vector], INDIRECT("'"&VIII.a.Inputs[#Headers]&"'!Year.Vectors"), 0))0INDEX(INDIRECT("'"&VIII.a.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&VIII.a.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH([Vector], INDIRECT("'"&VIII.a.Inputs[#Headers]&"'!Year.Vectors"), 0))0INDEX(INDIRECT("'"&VIII.a.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&VIII.a.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH([Vector], INDIRECT("'"&VIII.a.Inputs[#Headers]&"'!Year.Vectors"), 0))-0.16131283426835108INDEX(INDIRECT("'"&VIII.a.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&VIII.a.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH([Vector], INDIRECT("'"&VIII.a.Inputs[#Headers]&"'!Year.Vectors"), 0))-0.35937528416372705INDEX(INDIRECT("'"&VIII.a.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&VIII.a.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH([Vector], INDIRECT("'"&VIII.a.Inputs[#Headers]&"'!Year.Vectors"), 0))-1.9832324247017195INDEX(INDIRECT("'"&VIII.a.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&VIII.a.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH([Vector], INDIRECT("'"&VIII.a.Inputs[#Headers]&"'!Year.Vectors"), 0))-3.7315936175901641INDEX(INDIRECT("'"&VIII.a.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&VIII.a.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH([Vector], INDIRECT("'"&VIII.a.Inputs[#Headers]&"'!Year.Vectors"), 0))-6.9939702150812497INDEX(INDIRECT("'"&VIII.a.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&VIII.a.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH([Vector], INDIRECT("'"&VIII.a.Inputs[#Headers]&"'!Year.Vectors"), 0))-10.381356641959174INDEX(INDIRECT("'"&VIII.a.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&VIII.a.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH([Vector], INDIRECT("'"&VIII.a.Inputs[#Headers]&"'!Year.Vectors"), 0))-15.527031789573648INDEX(INDIRECT("'"&VIII.a.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&VIII.a.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH([Vector], INDIRECT("'"&VIII.a.Inputs[#Headers]&"'!Year.Vectors"), 0))-20.897463642457637784189579442200720102015202020252030203520402045205025780.720.720.720.720.720.720.720.720.7225790.680.680.680.692999999999999950.706299999999999930.720.720.720.7225760.650.650.650.668700000000000070.687999999999999940.707799999999999980.728299999999999950.749199999999999980.77257779442200720102015202020252030203520402045205025780.619800000000000020.619800000000000020.40.33570.276000000000000020.22630.16569.1400000000000009E-2025790.27070.27070.30.297700000000000020.276000000000000020.22630.16569.1400000000000009E-2025760.109499999999999990.109499999999999990.30.366599999999999980.447899999999999960.547300000000000010.668799999999999950.8172000000000000413170"Cost of a typical plant in "&Preferences.moneyunitsCost of a typical plant in £m344933063553"Typical size "&Preferences.EnergyUnitsTypical size TWh35553556179918011799180144225781*Unit.GW*Conversion.to.annual.energy8.766(5/30)0.166666666666666661((19.23*MGBP/Unit.PJ)*$F33)*(Price2000)14.94404724898974((23.37*MGBP/Unit.PJ)*$F33)*(Price2000)18.161330432079577(((0.705)*MGBP/Unit.PJ)*$F33)*(Price2000)0.54787068697544283(((3.506+2.5)*MGBP/Unit.PJ)*$F33)*(Price2000)4.667391980105688525794*Unit.MW*Conversion.to.annual.energy3.5063999999999998E-25/(22.5)0.222222222222222210((32.03*MGBP/Unit.PJ)*$F34)*(Price2000)33.188270645528952((46.07*MGBP/Unit.PJ)*$F34)*(Price2000)47.735985908196042(((0.705)*MGBP/Unit.PJ)*$F34)*(Price2000)0.73049424930059059(((1.37+2.5)*MGBP/Unit.PJ)*$F34)*(Price2000)4.00994715573515762576E343.5063999999999998E-25/(20)0.250.5((15.87*MGBP/Unit.PJ)*$F35)*(Price2000)18.499378302766551((70.98*MGBP/Unit.PJ)*$F35)*(Price2000)82.7401305564190180*(Price2000)00*(Price2000)03552E343.5063999999999998E-25/300.16666666666666666651((19.23*MGBP/Unit.PJ)*$F36)*(Price2000)14.94404724898974((23.37*MGBP/Unit.PJ)*$F36)*(Price2000)18.161330432079577(((0.705)*MGBP/Unit.PJ)*$F36)*(Price2000)0.54787068697544283(((3.506+2.5)*MGBP/Unit.PJ)*$F36)*(Price2000)4.66739198010568853554E353.5063999999999998E-25/500.1651((19.23*MGBP/Unit.PJ)*$F37)*(Price2000)8.9664283493938441((23.37*MGBP/Unit.PJ)*$F37)*(Price2000)10.896798259247749(((0.705)*MGBP/Unit.PJ)*$F37)*(Price2000)0.32872241218526577(((3.506+2.5)*MGBP/Unit.PJ)*$F37)*(Price2000)2.80043518806341357173551731118962261620072010201520202025203020352040204520501897Preferences.EnergyUnitsTWh-VIII.a.Inputs[2007]0-VIII.a.Inputs[2010]0-VIII.a.Inputs[2015]0.16131283426835108-VIII.a.Inputs[2020]0.35937528416372705-VIII.a.Inputs[2025]1.9832324247017195-VIII.a.Inputs[2030]3.7315936175901641-VIII.a.Inputs[2035]6.9939702150812497-VIII.a.Inputs[2040]10.381356641959174-VIII.a.Inputs[2045]15.527031789573648-VIII.a.Inputs[2050]20.8974636424576372582G$46*G2309.9981694679524002E-20.143750113665490810.665771124972367231.02991983845488531.58273545967288691.71915265990843921.419170705567031502583G$46*G2404.366738423644264E-20.107812585249118120.590408292833701891.02991983845488531.58273545967288691.71915265990843921.419170705567031502580G46*G2501.7663755352384441E-20.107812585249118120.727053006895650331.67138078131863433.82779989871396796.943051322142294712.68869037843958720.897463642457637202582(G47/G17)-G4703.8881770153148226E-25.5902821981024226E-20.258910993044809470.400524381621344410.615508234317233780.668559367742171060.5518997188316234802583(G48/G18)-G4802.0549357287737706E-25.0735334234879095E-20.261551725685348570.42827050340393580.615508234317233780.668559367742171060.5518997188316234802580G58-G4909.511252882053161E-35.8052930518755916E-20.360210350208656990.757951749667753031.58022482396753542.59017855859681764.24762886667465096.24209952956526592584258150(G47/G17)+(G48/G18)00.203080206356852590.358200855130512251.7766421365362272.88863456193505114.39648738798024134.77542405530122063.94214084879731078645G49/G1902.7175008234437602E-20.165865515767874031.08726335710430732.42933253098638745.40802472268150329.533229880739112316.93631924511423727.139563172022903255310401060(G$57)*INDEX(EF[CO2], MATCH("V.05", EF[Vector], 0))0(H$57)*INDEX(EF[CO2], MATCH("V.05", EF[Vector], 0))3.7366757969660873E-2(I$57)*INDEX(EF[CO2], MATCH("V.05", EF[Vector], 0))6.5908957344014238E-2(J$57)*INDEX(EF[CO2], MATCH("V.05", EF[Vector], 0))0.32690215312266574(K$57)*INDEX(EF[CO2], MATCH("V.05", EF[Vector], 0))0.53150875939604936(L$57)*INDEX(EF[CO2], MATCH("V.05", EF[Vector], 0))0.80895367938836427(M$57)*INDEX(EF[CO2], MATCH("V.05", EF[Vector], 0))0.87867802617542445(N$57)*INDEX(EF[CO2], MATCH("V.05", EF[Vector], 0))0.72535391617870493(O$57)*INDEX(EF[CO2], MATCH("V.05", EF[Vector], 0))0(P$228)*INDEX(EF[CO2], MATCH("V.05", EF[Vector], 0))010411060G$57*INDEX(EF[CH4], MATCH("V.05", EF[Vector], 0))0H$57*INDEX(EF[CH4], MATCH("V.05", EF[Vector], 0))7.4901132316611057E-5I$57*INDEX(EF[CH4], MATCH("V.05", EF[Vector], 0))1.321135630466549E-4J$57*INDEX(EF[CH4], MATCH("V.05", EF[Vector], 0))6.552706939549366E-4K$57*INDEX(EF[CH4], MATCH("V.05", EF[Vector], 0))1.0654017120587406E-3L$57*INDEX(EF[CH4], MATCH("V.05", EF[Vector], 0))1.6215360890306093E-3M$57*INDEX(EF[CH4], MATCH("V.05", EF[Vector], 0))1.7612975456875425E-3N$57*INDEX(EF[CH4], MATCH("V.05", EF[Vector], 0))1.453961558457523E-3O$57*INDEX(EF[CH4], MATCH("V.05", EF[Vector], 0))0P$228*INDEX(EF[CH4], MATCH("V.03", EF[Vector], 0))010421060G$57*INDEX(EF[N2O], MATCH("V.05", EF[Vector], 0))0H$57*INDEX(EF[N2O], MATCH("V.05", EF[Vector], 0))8.055980923982802E-5I$57*INDEX(EF[N2O], MATCH("V.05", EF[Vector], 0))1.4209455995997232E-4J$57*INDEX(EF[N2O], MATCH("V.05", EF[Vector], 0))7.0477548833734185E-4K$57*INDEX(EF[N2O], MATCH("V.05", EF[Vector], 0))1.1458913374558406E-3L$57*INDEX(EF[N2O], MATCH("V.05", EF[Vector], 0))1.7440408972139436E-3M$57*INDEX(EF[N2O], MATCH("V.05", EF[Vector], 0))1.8943611385658365E-3N$57*INDEX(EF[N2O], MATCH("V.05", EF[Vector], 0))1.563806342690024E-3O$57*INDEX(EF[N2O], MATCH("V.05", EF[Vector], 0))0P$228*INDEX(EF[N2O], MATCH("V.03", EF[Vector], 0))0235592582698(G47/G17)/((1/Unit.W)*Unit.year*Unit.J)01.5841143604000938E-22.2775831125543582E-20.105485069360846080.16318095141184460.25076930116245960.272383302264500360.2248540297055275902583698(G48/G18)/((1/Unit.W)*Unit.year*Unit.J)07.3256606803764942E-31.8086689423225784E-29.7189141971144241E-20.166346148968608390.25076930116245960.272383302264500360.2248540297055275902580698(G49/G19)/((1/Unit.W)*Unit.year*Unit.J)03.1000465702073466E-31.8921459704297747E-20.124031868252829950.277131249256945880.616931864325975691.08752337220386861.93204645734819043.09600309970601243558274020072010201520202025203020352040204520502578F47/$E$330G47/$E$3301.1405623394880675E-21.6398598410391377E-27.5949249939809171E-20.11749028501652810.18055389683697090.196115977630440250.1618949013879798802579F48/$E$340G48/$E$3401.24536231566400413.074737201948383616.83801884650073829.37257125413202645.13847420924272349.02899440761006440.47372534699496802576F49/$E$350G49/$E$3500.503757567658693843.074737201948383620.7350275751668547.666574872194687109.16609339248141198.01081799401936361.87230146131611595.980596693407393552F46/$E$360G46/$E$3604.600525732042867410.24912400649461156.560358906619882106.42235961642038199.46298810977783296.0688068092395442.81975215530599595.980596693407393554SUMPRODUCT(F47:F49,$G$33:$G$35)/$E$370SUMPRODUCT(G47:G49,$G$33:$G$35)/$E$3703.10328463254951585.637018203572036929.35482627253572153.2058586902293799.72152090548343148.03440340461972221.40987607765302297.99029834670373557274120072010201520202025203020352040204520502578MAX(((G72-F72)+(F72*$F33))/3,0)0MAX(((H72-G72)+(G72*$F33))/5,0)2.2811246789761351E-3MAX(((I72-H72)+(H72*$F33))/5,0)1.378782449598163E-31.2456750252896606E-21.083984868000409E-21.6529065197972832E-29.1308793865928998E-3002579MAX(((G73-F73)+(F73*$F34))/3,0)0MAX(((H73-G73)+(G73*$F34))/5,0)0.249072463132800820.421224413508609452.88931131566373223.25526687470406854.45862820231689662.78425844897314480.46801260599298367025760MAX(((H74-G74)+(G74*$F35))/5,0)0.100751513531738770.539383805240872593.68579493474111216.423060838163910314.68323244766708123.2272495899316642.67283759316031764.91527411948405335520MAX(((H75-G75)+(G75*$F36))/5,0)0.920105146408573441.28307051262511129.603884446908207211.85774543884742722.15553768588550225.96993001021826339.2191492961879545.39282731279714535540MAX(((H76-G76)+(G76*$F37))/5,0)0.620656926509903120.56881240685549454.85630197786417745.357303008989444710.367249616855411.65700691793692717.63578260269905619.744281975363197333273511Preferences.moneyunits£m20072010201520202025203020352040204520502578F$79*$H330G$79*$H3303.4089234983455917E-22.0604590072872762E-20.186154264348151770.16199121084588020.247011131300137940.13645229297807074002579F$80*$H340G$80*$H3408.266284316799925613.97970983802793395.891245923437282108.03667806110381147.9741594862813992.40472295162139515.53252903321444702576F$81*$H350G$81*$H3501.86384036339993879.978265063536657268.184914844196584118.82263230687899271.63067175685018429.68967709692504789.420965888390811200.89221356412653552F$82*$H360G$82*$H36013.75009478196834319.17426636445515143.52090294843396177.20270810462853331.09340200464572388.09586112565836586.09282014741541678.352556127672533554F$83*$H370G$83*$H3705.56507586110604715.100215690316050943.54368372753875648.03587357609590292.957200869814727104.52171729806983158.12998109258757177.03568964232247148SUM(F88:F92)0SUM(G88:G92)029.47938455825771348.253061546408659351.32690170795473452.25988325955313843.902445248892151014.84843076525261549.17629616160822056.28045933412113545Preferences.moneyunits£m20072010201520202025203020352040204520502578F$79*$I330G$79*$I3304.1428259051657042E-22.5040523661104343E-20.226231157452746080.196866073711295910.300189814793771440.16582891767537772002579F$80*$I340G$80*$I34011.88971959022705820.107562667435122137.92412424891529155.39337365829078212.83701303568483132.9093220849578122.34104316453917602576F$81*$I350G$81*$I3508.336193383372883444.628686465647888304.96315410466752531.444892321504081214.89256971022221921.82566353747553530.756153670955371.09825575183913552F$82*$I360G$82*$I36016.71033359618305923.302267547442376174.41931887180976215.35243309439258402.37404081375831471.64848021355363712.27192963313053824.394136074035833554F$83*$I370G$83*$I3706.76317331638317046.198234044861474852.91814293877176658.377450102618909112.96982757813682127.02405269141408192.17356516556282215.14945745923438148SUM(F96:F100)0SUM(G96:G100)0SUM(H96:H100)43.740848145217825SUM(I96:I100)94.26179124904796SUM(J96:J100)670.45097132161709SUM(K96:K100)960.76501525051776SUM(L96:L100)1943.3736409525959SUM(M96:M100)2653.5733474450763SUM(N96:N100)4457.5426916341821SUM(O96:O100)6410.64184928510893519Preferences.moneyunits£m20072010201520202025203020352040204520502578F72*$J330G72*$J3306.2488067247364583E-38.9843113765355285E-34.1610367739792861E-26.4369483164945826E-29.8920187496164477E-20.107446195391249878.8697470841254109E-202579F73*$J34000.909730009888221842.246077844133882912.30007593698375221.45649438831528132.97339583205483435.81539846374996529.56582361375137302576F74*$J3500000000003552F75*$J36002.52049319326252795.615194610334705230.98776268974744158.305691272595858109.27992432187857162.20742057857771242.60796181962283326.520298934451433554F76*$J37001.0201192101091431.85301422141045359.649589301587356617.48995821104058432.78069889883391948.66222617357331672.78238854588687497.956089680335452148SUM(F104:F108)0SUM(G104:G108)0SUM(H104:H108)4.4565912199846291SUM(I104:I108)9.723270987255578SUM(J104:J108)52.979038296058341SUM(K104:K108)97.316513355116669SUM(L104:L108)175.13293924026348SUM(M104:M108)246.79249141129225SUM(N104:N108)345.04487145010233SUM(O104:O108)424.476388614786863546Preferences.moneyunits£m20072010201520202025203020352040204520502578F72*$K330G72*$K3305.3234515161371877E-27.6538686705634601E-20.354484920064107760.548373214026474760.842715810073707770.915350141162903470.755626964358258602579F73*$K34004.993837075556623312.32953369758599767.51956578174061117.78245855713497181.00289626957763196.60367667335092162.2974998371884102576F74*$K3500000000003552F75*$K360021.4724569060067347.836679191021631263.98936555265698496.71486777760396930.971951031493291381.8691744609052066.81335984206362781.67505730541233554F76*$K37008.690547483568105115.78610413303714282.206288433097399148.9995588872479279.26365615091709414.56075233827147620.04400795261938834.50251719162384148SUM(F112:F116)0SUM(G112:G116)0SUM(H112:H116)35.210075980292828SUM(I112:I116)76.028855708350406SUM(J112:J116)414.06970468755912SUM(K112:K116)764.04525843601323SUM(L112:L116)1392.0812192620617SUM(M112:M116)1993.9489536136903SUM(N112:N116)2849.9104945962295SUM(O112:O116)3616.1775744970364683778Preferences.EnergyUnitsTWh7841844269169272072172272372472572672745INDEX(Vectors[Description], MATCH([Vector], Vectors[Code], 0))Electricity (delivered to end user)-F5800-2.7175008234437602E-2-0.16586551576787403-1.0872633571043073-2.4293325309863874-5.4080247226815032-9.5332298807391123-16.936319245114237-27.13956317202290350INDEX(Vectors[Description], MATCH([Vector], Vectors[Code], 0))Gaseous hydrocarbons-F570-G570-0.20308020635685259-0.35820085513051225-1.776642136536227-2.8886345619350511-4.3964873879802413-4.7754240553012206-3.9421408487973101457INDEX(Vectors[Description], MATCH([Vector], Vectors[Code], 0))H2F46000.161312834268351080.359375284163727051.98323242470171953.73159361759016416.993970215081249710.38135664195917415.52703178957364820.89746364245763734INDEX(Vectors[Description], MATCH([Vector], Vectors[Code], 0))Conversion lossesSUM(F52:F54)006.894238032293909E-20.164691086734659240.880673068938815031.58674663469303322.8112412926020033.92729729408115975.3514283043378974SUM(O52:O54)6.2420995295652659148SUBTOTAL(109,[2007])0SUBTOTAL(109,[2010])0SUBTOTAL(109,[2015])0SUBTOTAL(109,[2020])0SUBTOTAL(109,[2025])0SUBTOTAL(109,[2030])3.731593617584128E-4SUBTOTAL(109,[2035])6.9939702150900729E-4SUBTOTAL(109,[2040])0SUBTOTAL(109,[2045])0SUBTOTAL(109,[2050])0889105810611057102744269169272072172272372472572672710401050INDEX(IPCC[Sector_description], MATCH([IPCC Sector], IPCC[Sector_code], 0))Fuel CombustionF61Mt CO2e03.7366757969660873E-26.5908957344014238E-20.326902153122665740.531508759396049360.808953679388364270.878678026175424450.72535391617870493O61010411050INDEX(IPCC[Sector_description], MATCH([IPCC Sector], IPCC[Sector_code], 0))Fuel CombustionMt CO2e07.4901132316611057E-51.321135630466549E-46.552706939549366E-41.0654017120587406E-31.6215360890306093E-31.7612975456875425E-31.453961558457523E-3O62010421050INDEX(IPCC[Sector_description], MATCH([IPCC Sector], IPCC[Sector_code], 0))Fuel CombustionMt CO2e08.055980923982802E-51.4209455995997232E-47.0477548833734185E-41.1458913374558406E-31.7440408972139436E-31.8943611385658365E-31.563806342690024E-3O630148SUBTOTAL(109,[2007])0SUBTOTAL(109,[2010])0SUBTOTAL(109,[2015])3.7522218911217313E-2SUBTOTAL(109,[2020])6.6183165467020869E-2SUBTOTAL(109,[2025])0.32826219930495804SUBTOTAL(109,[2030])0.53372005244556386SUBTOTAL(109,[2035])0.81231925637460878SUBTOTAL(109,[2040])0.88233368485967789SUBTOTAL(109,[2045])0.72837168407985253SUBTOTAL(109,[2050])0261326187826144426916927207217227237247257267272615INDEX(Vectors[Description], MATCH([Vector], Vectors[Code], 0))UK Land areaINDEX(Vectors[Comment], MATCH([Information type], Vectors[Description], 0))02620INDEX(Vectors[Description], MATCH([Vector], Vectors[Code], 0))Installed Capacity INDEX(Vectors[Comment], MATCH([Information type], Vectors[Description], 0))0SUM(F67:F69)002.6266850854584776E-25.9783980253067109E-20.326706079584820290.606658349637398841.11847046665089491.63228997673286942.38175451675924553.09600309970601242621INDEX(Vectors[Description], MATCH([Vector], Vectors[Code], 0))Number of units31893190Preferences.moneyunits£m784184426916927207217227237247257267273131INDEX(CostVectors[Description], MATCH(C157, CostVectors[Code], 0))Low estimate of capital costsF930G93029.47938455825771348.253061546408659351.32690170795473452.25988325955313843.902445248892151014.84843076525261549.17629616160822056.28045933412113133INDEX(CostVectors[Description], MATCH(C158, CostVectors[Code], 0))Low estimate of operating costsF1090G10904.45659121998462919.72327098725557852.97903829605834197.316513355116669175.13293924026348246.79249141129225345.04487145010233424.476388614786863140INDEX(CostVectors[Description], MATCH(C159, CostVectors[Code], 0))High estimate of capital costsF1010G101043.74084814521782594.26179124904796670.45097132161709960.765015250517761943.37364095259592653.57334744507634457.54269163418216410.64184928510893142INDEX(CostVectors[Description], MATCH(C160, CostVectors[Code], 0))High estimate of operating costsF1170G117035.21007598029282876.028855708350406414.06970468755912764.045258436013231392.08121926206171993.94895361369032849.91049459622953616.1775744970364