2482288246124621340236331132882257133629242925179488929177220029182991299231143115311631173118311931203121312231233124312531263127312831293130271712341419142014211422280029232463246424652694246324642465269412352914754INDEX(Modules[Module], MATCH($D5, Modules[Code], 0))Nuclear power1142222222122114111325804236524952496269629262927292829292228868INDEX(Modules[Module], MATCH($D6, Modules[Code], 0))Carbon Capture Storage (CCS)30281142222222222111424223003423112493249426952930293129322933200720202030205030291142222222222111343223014142230043005300630072934293529362937VII.c!D407Interconnector capacity839VII.c!F4072.5VII.c!I4076VII.c!K40710VII.c!O407101702INDEX(Modules[Module], MATCH($D9, Modules[Code], 0))Offshore wind114222222222234131122879428532499250028542940293929382941VII.c!D364Standby capacity requiredVII.c!E364GWcapacityVII.c!F3640VII.c!I3640.2677288659808359VII.c!K36420.693382832338038VII.c!O36434.7610818114421041701INDEX(Modules[Module], MATCH($D10, Modules[Code], 0))Onshore wind114222222222231111232878428592497249827002942294329442945VII.c!D375Probable annual emissionsVII.c!E375MtCO2eVII.c.Emissions[[#Totals],[2007]]0VII.c.Emissions[[#Totals],[2020]]1.4840118539961152E-2VII.c.Emissions[[#Totals],[2030]]1.1470270607528565VII.c.Emissions[[#Totals],[2050]]1.9267947547202986803INDEX(Modules[Module], MATCH($D11, Modules[Code], 0))Tidal and Wave1142222222111341111123010423662504250526972366250425052697740INDEX(Modules[Module], MATCH($D12, Modules[Code], 0))Biomass/Coal power stations11411111112111111111127834285528562857285829462947294829493054963INDEX(Modules[Module], MATCH($D13, Modules[Code], 0))Solar PV114222222211131111412279342368250825092698236825082509269830551313INDEX(Modules[Module], MATCH($D14, Modules[Code], 0))Solar thermal11423212221122222442227924251025112512271525102511251227153052804INDEX(Modules[Module], MATCH($D15, Modules[Code], 0))Geothermal electricity1142222222111311111122784423672506250727012367250629502951798INDEX(Modules[Module], MATCH($D16, Modules[Code], 0))Hydroelectric power stations11422222221113111111230154250125022503270229522953295429551574INDEX(Modules[Module], MATCH($D17, Modules[Code], 0))Small-scale wind114222222211131111412303342513251425152703251329562958295726842915772INDEX(Modules[Module], MATCH($D18, Modules[Code], 0))Electricity imports1141111444111441111115542370251725182699237025172959296026722905911INDEX(Modules[Module], MATCH($D19, Modules[Code], 0))Agriculture and land use715Preferences.EnergyUnits & " / year"TWh / year200720202030205025741143233344444134333333008428602861286230412860296129623042977INDEX(Vectors[Description], MATCH($BV20, Vectors[Code], 0))Coal oversupply (imports)SUMIFS(INDIRECT("'"&CA$19&"'!Year.NetBalance"), INDIRECT("'"&CA$19&"'!Year.Vectors"),$BV20)-329.05563918270377-75.332332769709041107.26999404459559-11.60576155207351725751143333142111133343333013427102863270827092710286327082709978INDEX(Vectors[Description], MATCH($BV21, Vectors[Code], 0))Oil and petroleum products oversupply (imports)86.784557973583674-313.09395809458334-346.71125414477581-504.28688593352877952INDEX(Modules[Module], MATCH($D22, Modules[Code], 0))Volume of Waste & Recycling1133233212223333323332785142125162369286429212516236928642864979INDEX(Vectors[Description], MATCH($BV22, Vectors[Code], 0))Gas oversupply (imports)-149.76767097151924-473.31187743652674-361.94169763623091-41.094047043885242205INDEX(Modules[Module], MATCH($D23, Modules[Code], 0))Marine algae114222214144412224212220442312286528662922231229632964296559INDEX(Vectors[Description], MATCH($BV23, Vectors[Code], 0))Biomass oversupply (imports)-4.0007200000000003-23.953990697674421-39.302660465116276-70950INDEX(Modules[Module], MATCH($D24, Modules[Code], 0))Types of fuel from Biomass112222222123412321222300914222705270627072704270527062707270460INDEX(Vectors[Description], MATCH($BV24, Vectors[Code], 0))Electricity oversupply (imports)-5.6843418860808015E-14-5.6843418860808015E-140103.2509366325048229061666INDEX(Modules[Module], MATCH($D25, Modules[Code], 0))Bioenergy imports11421221444442232332216674286730233024302528673023302430257317832602907890INDEX(Modules[Module], MATCH($D27, Modules[Code], 0))Domestic passenger transport2426187814124412221224422424228828828828827864286830163017286928683016301728691793Preferences.EnergyUnits & " / year"TWh / year200720202030205018841413441441223443343432787424362437243827112436243724382711903INDEX(Modules[Module], MATCH($D30, Modules[Code], 0))Domestic freight141241444131244224232134842393243925202712239324392520271218471844-(INDEX(INDIRECT(CA$28&"!Year.Matrix"),MATCH("Subtotal.Supply",INDIRECT(CA$28&"!Year.Modules"),0),MATCH("V.05",INDIRECT(CA$28&"!Year.Vectors"),0))+INDEX(INDIRECT(CA$28&"!Year.Matrix"),MATCH("Subtotal.Consumption",INDIRECT(CA$28&"!Year.Modules"),0),MATCH("V.05",INDIRECT(CA$28&"!Year.Vectors"),0)))989.17127665018734-(INDEX(INDIRECT(CB$28&"!Year.Matrix"),MATCH("Subtotal.Supply",INDIRECT(CB$28&"!Year.Modules"),0),MATCH("V.05",INDIRECT(CB$28&"!Year.Vectors"),0))+INDEX(INDIRECT(CB$28&"!Year.Matrix"),MATCH("Subtotal.Consumption",INDIRECT(CB$28&"!Year.Modules"),0),MATCH("V.05",INDIRECT(CB$28&"!Year.Vectors"),0)))911.64967846602929-(INDEX(INDIRECT(CC$28&"!Year.Matrix"),MATCH("Subtotal.Supply",INDIRECT(CC$28&"!Year.Modules"),0),MATCH("V.05",INDIRECT(CC$28&"!Year.Vectors"),0))+INDEX(INDIRECT(CC$28&"!Year.Matrix"),MATCH("Subtotal.Consumption",INDIRECT(CC$28&"!Year.Modules"),0),MATCH("V.05",INDIRECT(CC$28&"!Year.Vectors"),0)))659.13153931643296-(INDEX(INDIRECT(CD$28&"!Year.Matrix"),MATCH("Subtotal.Supply",INDIRECT(CD$28&"!Year.Modules"),0),MATCH("V.05",INDIRECT(CD$28&"!Year.Vectors"),0))+INDEX(INDIRECT(CD$28&"!Year.Matrix"),MATCH("Subtotal.Consumption",INDIRECT(CD$28&"!Year.Modules"),0),MATCH("V.05",INDIRECT(CD$28&"!Year.Vectors"),0)))203.065595048894982908906INDEX(Modules[Module], MATCH($D31, Modules[Code], 0))International aviation1411441111111441441419424287028712394287229662967296729686712227INDEX(INDIRECT(CA$28&"!Year.Matrix"),MATCH($BV31,INDIRECT(CA$28&"!Year.Modules"),0),MATCH("V.05",INDIRECT(CA$28&"!Year.Vectors"),0))/CA$302.2244865824232209E-2INDEX(INDIRECT(CB$28&"!Year.Matrix"),MATCH($BV31,INDIRECT(CB$28&"!Year.Modules"),0),MATCH("V.05",INDIRECT(CB$28&"!Year.Vectors"),0))/CB$307.1272313199393034E-2INDEX(INDIRECT(CC$28&"!Year.Matrix"),MATCH($BV31,INDIRECT(CC$28&"!Year.Modules"),0),MATCH("V.05",INDIRECT(CC$28&"!Year.Vectors"),0))/CC$300.11308668146134376INDEX(INDIRECT(CD$28&"!Year.Matrix"),MATCH($BV31,INDIRECT(CD$28&"!Year.Modules"),0),MATCH("V.05",INDIRECT(CD$28&"!Year.Vectors"),0))/CD$300.39959597376402045944INDEX(Modules[Module], MATCH($D32, Modules[Code], 0))International shipping1411414111111441141419551422304430433045304630443043304530462002007205022588241846-INDEX(INDIRECT(CA$28&"!Year.Matrix"),MATCH($BV32,INDIRECT(CA$28&"!Year.Modules"),0),MATCH("V.05",INDIRECT(CA$28&"!Year.Vectors"),0))/CA$300.328029952483868240.318952492516671020.295284982738680871.8256467692384557E-38152909824INDEX(Modules[Module], MATCH($D33, Modules[Code], 0))Domestic space heating and hot water74INDEX(Workstreams[Workstream], MATCH($BJ33, Workstreams[Code], 0))Hydrocarbon fuel power generationSUMIFS(INDIRECT("'"&BO$32&"'!Year.EmissionsBySector"), INDIRECT("'"&BO$32&"'!Year.Modules"),$BJ33)200.129341158949516.688490998952744BP33*'Intermediate output'!$H$153/'Intermediate output'!$F$2032.1538695768502956E-293218457.9119118876241179E-27.4044731448681456E-27.3339543672786958E-26.3434330448828473E-418031412441222222232242322788423752376237727132375237623772713671INDEX(Workstreams[Workstream], MATCH($BJ34, Workstreams[Code], 0))Bioenergy-9.5460241008036473-120.94874750502247BP34*'Intermediate output'!$H$153/'Intermediate output'!$F$203-0.1561002894902622867826810.151695644071973470.138024751599555070.17004492182099260.1951964468220445112621412441222222232242322789428732874287528762873287428752876675INDEX(Workstreams[Workstream], MATCH($BJ35, Workstreams[Code], 0))Geosequestration00BP35*'Intermediate output'!$H$153/'Intermediate output'!$F$203074026820.35440900196161740.40879450184749250.34914109306271018018311413443414333333344432790142225193047304830492519304730483049672INDEX(Workstreams[Workstream], MATCH($BJ36, Workstreams[Code], 0))Agriculture and waste65.90661263983685142.670605810430715BP36*'Intermediate output'!$H$153/'Intermediate output'!$F$2035.5072037182166807E-2868268306.2338006661109393E-36.0229506970851568E-20.7479885612469789918281413443333333323323432791142223782379238027142378237923802714676INDEX(Workstreams[Workstream], MATCH($BJ37, Workstreams[Code], 0))Heating84.4274608813869789.2297644914629023E-2BP37*'Intermediate output'!$H$153/'Intermediate output'!$F$2031.1912226780062139E-42910937INDEX(Modules[Module], MATCH($D38, Modules[Code], 0))Domestic lighting, appliances, and cooking677INDEX(Workstreams[Workstream], MATCH($BJ38, Workstreams[Code], 0))Lighting and appliances3.14118424566173720BP38*'Intermediate output'!$H$153/'Intermediate output'!$F$20301782-(INDEX(INDIRECT(CA$28&"!Year.Matrix"),MATCH("Subtotal.Supply",INDIRECT(CA$28&"!Year.Modules"),0),MATCH("V.04",INDIRECT(CA$28&"!Year.Vectors"),0))+INDEX(INDIRECT(CA$28&"!Year.Matrix"),MATCH("Subtotal.Consumption",INDIRECT(CA$28&"!Year.Modules"),0),MATCH("V.04",INDIRECT(CA$28&"!Year.Vectors"),0)))893.29280469570267-(INDEX(INDIRECT(CB$28&"!Year.Matrix"),MATCH("Subtotal.Supply",INDIRECT(CB$28&"!Year.Modules"),0),MATCH("V.04",INDIRECT(CB$28&"!Year.Vectors"),0))+INDEX(INDIRECT(CB$28&"!Year.Matrix"),MATCH("Subtotal.Consumption",INDIRECT(CB$28&"!Year.Modules"),0),MATCH("V.04",INDIRECT(CB$28&"!Year.Vectors"),0)))825.60672968848655-(INDEX(INDIRECT(CC$28&"!Year.Matrix"),MATCH("Subtotal.Supply",INDIRECT(CC$28&"!Year.Modules"),0),MATCH("V.04",INDIRECT(CC$28&"!Year.Vectors"),0))+INDEX(INDIRECT(CC$28&"!Year.Matrix"),MATCH("Subtotal.Consumption",INDIRECT(CC$28&"!Year.Modules"),0),MATCH("V.04",INDIRECT(CC$28&"!Year.Vectors"),0)))666.164733428575-(INDEX(INDIRECT(CD$28&"!Year.Matrix"),MATCH("Subtotal.Supply",INDIRECT(CD$28&"!Year.Modules"),0),MATCH("V.04",INDIRECT(CD$28&"!Year.Vectors"),0))+INDEX(INDIRECT(CD$28&"!Year.Matrix"),MATCH("Subtotal.Consumption",INDIRECT(CD$28&"!Year.Modules"),0),MATCH("V.04",INDIRECT(CD$28&"!Year.Vectors"),0)))647.5867506161670216411412441222222232242223012423882389239027162388238923902716678INDEX(Workstreams[Workstream], MATCH($BJ39, Workstreams[Code], 0))Industry93.41484291354765952.116904730965224BP39*'Intermediate output'!$H$153/'Intermediate output'!$F$2036.7263730163904856E-26711790INDEX(INDIRECT(CA$28&"!Year.Matrix"),MATCH($BV39,INDIRECT(CA$28&"!Year.Modules"),0),MATCH("V.04",INDIRECT(CA$28&"!Year.Vectors"),0))/CA$389.6604718571976567E-4INDEX(INDIRECT(CB$28&"!Year.Matrix"),MATCH($BV39,INDIRECT(CB$28&"!Year.Modules"),0),MATCH("V.04",INDIRECT(CB$28&"!Year.Vectors"),0))/CB$381.2989019027497654E-2INDEX(INDIRECT(CC$28&"!Year.Matrix"),MATCH($BV39,INDIRECT(CC$28&"!Year.Modules"),0),MATCH("V.04",INDIRECT(CC$28&"!Year.Vectors"),0))/CC$382.8542338282817943E-2INDEX(INDIRECT(CD$28&"!Year.Matrix"),MATCH($BV39,INDIRECT(CD$28&"!Year.Modules"),0),MATCH("V.04",INDIRECT(CD$28&"!Year.Vectors"),0))/CD$385.4967932319383787E-2188412122412222222222222227941420298029812919291929802981298129816791788-INDEX(INDIRECT(CA$28&"!Year.Matrix"),MATCH($BV40,INDIRECT(CA$28&"!Year.Modules"),0),MATCH("V.04",INDIRECT(CA$28&"!Year.Vectors"),0))/CA$380.806693785464157930.826042612343008690.795384209048690230.80742944387961546291143887INDEX(Modules[Module], MATCH($D41, Modules[Code], 0))Industrial processes679INDEX(Workstreams[Workstream], MATCH($BJ41, Workstreams[Code], 0))TransportSUMIFS(INDIRECT("'"&BO$32&"'!Year.EmissionsBySector"), INDIRECT("'"&BO$32&"'!Year.Modules"),$BJ41)183.61905836674865133.23482195276705BP41*'Intermediate output'!$H$153/'Intermediate output'!$F$2030.1719570868325597267817929.137321430337475E-29.417937153259387E-20.117906894766721070.1242397441797896725361421333121111331131313037142128772878287929212877287828792879956INDEX(Workstreams[Workstream], MATCH($BJ42, Workstreams[Code], 0))Fossil fuel production34.39920743834842713.911074045661776BP42*'Intermediate output'!$H$153/'Intermediate output'!$F$2031.7954073361182214E-295822266.2987952938183392E-25.7699333757329982E-26.6120188190758336E-26.2710498023594324E-225351313323333333333323333038328802881288229202969297029712971998INDEX(Workstreams[Workstream], MATCH($BJ43, Workstreams[Code], 0))Transfers4.37065136408846390.55096562931369675BP43*'Intermediate output'!$H$153/'Intermediate output'!$F$2037.110937153894972E-42912932INDEX(Modules[Module], MATCH($D44, Modules[Code], 0))Commercial heating and cooling148SUM(BO33:BO43)659.86233490776453SUM(BP33:BP43)138.31641330798337BP44*'Intermediate output'!$H$153/'Intermediate output'!$F$2030.178515549801244371781-(INDEX(INDIRECT(CA$28&"!Year.Matrix"),MATCH("Subtotal.Supply",INDIRECT(CA$28&"!Year.Modules"),0),MATCH("V.03",INDIRECT(CA$28&"!Year.Vectors"),0))+INDEX(INDIRECT(CA$28&"!Year.Matrix"),MATCH("Subtotal.Consumption",INDIRECT(CA$28&"!Year.Modules"),0),MATCH("V.03",INDIRECT(CA$28&"!Year.Vectors"),0)))496.28220167438485-(INDEX(INDIRECT(CB$28&"!Year.Matrix"),MATCH("Subtotal.Supply",INDIRECT(CB$28&"!Year.Modules"),0),MATCH("V.03",INDIRECT(CB$28&"!Year.Vectors"),0))+INDEX(INDIRECT(CB$28&"!Year.Matrix"),MATCH("Subtotal.Consumption",INDIRECT(CB$28&"!Year.Modules"),0),MATCH("V.03",INDIRECT(CB$28&"!Year.Vectors"),0)))353.76972207519685-(INDEX(INDIRECT(CC$28&"!Year.Matrix"),MATCH("Subtotal.Supply",INDIRECT(CC$28&"!Year.Modules"),0),MATCH("V.03",INDIRECT(CC$28&"!Year.Vectors"),0))+INDEX(INDIRECT(CC$28&"!Year.Matrix"),MATCH("Subtotal.Consumption",INDIRECT(CC$28&"!Year.Modules"),0),MATCH("V.03",INDIRECT(CC$28&"!Year.Vectors"),0)))197.17405988023407-(INDEX(INDIRECT(CD$28&"!Year.Matrix"),MATCH("Subtotal.Supply",INDIRECT(CD$28&"!Year.Modules"),0),MATCH("V.03",INDIRECT(CD$28&"!Year.Vectors"),0))+INDEX(INDIRECT(CD$28&"!Year.Matrix"),MATCH("Subtotal.Consumption",INDIRECT(CD$28&"!Year.Modules"),0),MATCH("V.03",INDIRECT(CD$28&"!Year.Vectors"),0)))447.47958585440966181114124142222222222222227954231523162381238229722973297429751685BO44/677.350.974182232092366546711791INDEX(INDIRECT(CA$28&"!Year.Matrix"),MATCH($BV45,INDIRECT(CA$28&"!Year.Modules"),0),MATCH("V.03",INDIRECT(CA$28&"!Year.Vectors"),0))/CA$443.3905978732375996E-2INDEX(INDIRECT(CB$28&"!Year.Matrix"),MATCH($BV45,INDIRECT(CB$28&"!Year.Modules"),0),MATCH("V.03",INDIRECT(CB$28&"!Year.Vectors"),0))/CB$440.27855953013130164INDEX(INDIRECT(CC$28&"!Year.Matrix"),MATCH($BV45,INDIRECT(CC$28&"!Year.Modules"),0),MATCH("V.03",INDIRECT(CC$28&"!Year.Vectors"),0))/CC$440.94436748301921025INDEX(INDIRECT(CD$28&"!Year.Matrix"),MATCH($BV45,INDIRECT(CD$28&"!Year.Modules"),0),MATCH("V.03",INDIRECT(CD$28&"!Year.Vectors"),0))/CD$440.704661686167645461832141331441433333333343279614222383238423852386238323842385238624248681789-INDEX(INDIRECT(CA$28&"!Year.Matrix"),MATCH($BV46,INDIRECT(CA$28&"!Year.Modules"),0),MATCH("V.03",INDIRECT(CA$28&"!Year.Vectors"),0))/CA$4405.8505572151820756E-20.550756683836909120.8941642651090271318331413414333333323323432797142223782313231423872378231323142387242774022300.859577205972224760.774065887814425980.1680519233621648702913938INDEX(Modules[Module], MATCH($D48, Modules[Code], 0))Commercial lighting, appliances, and catering242567817920.109923887913003370.141824257861557220.24905297722627670.103812584939941351641141241422222222224222301142318240823912392297629772978297967622252.8727209950603034E-22.3067971656543451E-22.7687241142682412E-20188412122122222222222222227981420231923172919291929822983298329832916453949INDEX(Modules[Module], MATCH($D52, Modules[Code], 0))Geosequestration1111111111111111111214534239523202521252223952984298529862673792INDEX(Modules[Module], MATCH($D53, Modules[Code], 0))Storage, demand shifting, interconnection111222241442244224242279942371237223732374299029892988298730534343