677INDEX(Workstreams[Workstream], MATCH($A1, Workstreams[Code], 0))Lighting and appliances3637938INDEX(Modules[Module], MATCH($A2, Modules[Code], 0))Commercial lighting, appliances, and catering133782513361335X.b.Scenario.Demand21617MIN(X.b.Scenario.Technology,2)213382195Preferences.EnergyUnitsTWh13368044220072010201520202025203020352040204520501(Unit.PJ)*212.96431394476759.156753873546393(Unit.PJ)*214.44175638244259.567154550678339(Unit.PJ)*221.99503963542961.665288787619168(Unit.PJ)*229.83329281375763.842581337154726(Unit.PJ)*237.96806167631666.10223935453223(Unit.PJ)*246.41139113881868.447608649671665(Unit.PJ)*255.17584801612670.882180004479451(Unit.PJ)*264.27454484145373.40959578929251(Unit.PJ)*273.72116481476676.03365689299055(Unit.PJ)*283.52998793533578.7583299820374952(Unit.PJ)*212.96431394476759.156753873546393(Unit.PJ)*213.57372630874259.326035085761674(Unit.PJ)*216.71139405154860.197609458763338(Unit.PJ)*220.00486599229661.112462775637781(Unit.PJ)*223.46096260777662.072489613271109(Unit.PJ)*227.34437980955563.151216613765278(Unit.PJ)*232.18425566728764.495626574246387(Unit.PJ)*237.50095937668865.972488715746664(Unit.PJ)*243.04791580980867.513309947168892(Unit.PJ)*248.83661322026169.1212814500725023(Unit.PJ)*212.96431394476759.156753873546393(Unit.PJ)*212.0569727977958.904714666052776(Unit.PJ)*207.86050644544957.739029568180278(Unit.PJ)*204.20940334713556.724834263093058(Unit.PJ)*201.07732393825555.854812205070836(Unit.PJ)*198.83862056443455.232950156787226(Unit.PJ)*198.16760243537855.046556232049447(Unit.PJ)*198.23492122122355.065255894784173(Unit.PJ)*198.64888957251455.180247103476113(Unit.PJ)*199.41545876124455.3931829892344474(Unit.PJ)*212.96431394476759.156753873546393(Unit.PJ)*210.21883190555758.394119973765839(Unit.PJ)*197.56906225587854.880295071077228(Unit.PJ)*186.5940138177851.831670504938891(Unit.PJ)*177.14319330379549.206442584387496(Unit.PJ)*169.08314181485546.967539393015279(Unit.PJ)*162.29562572875445.082118257987226(Unit.PJ)*156.67603638949143.521121219303055(Unit.PJ)*152.13197412945642.258881702626674(Unit.PJ)*148.58199514764941.2727764299025773430.834471146231633Preferences.EnergyUnitsTWh13368044220072010201520202025203020352040204520501(Unit.PJ)*80.868751236919322.46354201025536(Unit.PJ)*80.883518032319222.467643897866445(Unit.PJ)*80.957392465862522.488164573850696(Unit.PJ)*81.031334372137822.508703992260504(Unit.PJ)*81.105343812770722.529262170214086(Unit.PJ)*81.179420849443522.54983912484542(Unit.PJ)*81.253565543894422.570434873303999(Unit.PJ)*81.327777957918422.591049432755113(Unit.PJ)*81.402058153366522.611682820379585(Unit.PJ)*81.476406192146622.6323350533740572(Unit.PJ)*80.868751236919322.46354201025536(Unit.PJ)*80.725325580367822.423701550102166(Unit.PJ)*80.012003898726122.225556638535032(Unit.PJ)*79.304985416456322.029162615682306(Unit.PJ)*78.604214435935221.834504009982002(Unit.PJ)*77.909635751706321.641565486585087(Unit.PJ)*77.221194646130621.450331846147389(Unit.PJ)*76.538836885076821.260788023632447(Unit.PJ)*75.862508713648121.072919087124472(Unit.PJ)*75.192156851947620.8867102366521143(Unit.PJ)*80.868751236919322.46354201025536(Unit.PJ)*79.868500957915822.185694710532168(Unit.PJ)*75.049795894485420.847165526245945(Unit.PJ)*70.521817690953919.58939380304275(Unit.PJ)*66.267025928068818.407507202241334(Unit.PJ)*63.048776840694517.513549122415139(Unit.PJ)*63.048776840694517.513549122415139(Unit.PJ)*63.048776840694517.513549122415139(Unit.PJ)*63.048776840694517.513549122415139(Unit.PJ)*63.048776840694517.5135491224151394(Unit.PJ)*80.868751236919322.46354201025536(Unit.PJ)*80.303310717708522.306475199363472(Unit.PJ)*77.534862187913821.537461718864947(Unit.PJ)*74.861855641688920.794959900469141(Unit.PJ)*72.281000726285920.078055757301637(Unit.PJ)*69.789120523535419.38586681209317(Unit.PJ)*67.383147639201518.717541010889306(Unit.PJ)*65.060120427154718.072255674209639(Unit.PJ)*62.817179343716917.449216484365806(Unit.PJ)*60.651563427689516.8476565076915291634INDEX(Vectors[Description], MATCH(G32, Vectors[Code], 0))Electricity (delivered to end user)INDEX(Vectors[Description], MATCH(H32, Vectors[Code], 0))Gaseous hydrocarbons1336794421622455011621$F$450.6$F$460.42905107178867841635926781312442200745INDEX(Vectors[Description], MATCH($C45, Vectors[Code], 0))Electricity (delivered to end user)0.650INDEX(Vectors[Description], MATCH($C46, Vectors[Code], 0))Gaseous hydrocarbons1-F450.4717163731703594359518011799359654.9353*MGBP*Price200071.1523417262459798.887*MGBP*Price200011.51046523676303359750*MGBP*Price200064.76012848409492150*MGBP*Price200064.760128484094921359818011799359600359700442109359981216389267879442200720102015202020252030203520402045205045INDEX(Vectors[Description], MATCH($C74, Vectors[Code], 0))Electricity (delivered to end user)F450.6$F74+($O74-$F74)/($O$73-$F$73)*(G$73-$F$73)0.62790697674418605$F74+($O74-$F74)/($O$73-$F$73)*(H$73-$F$73)0.674418604651162770.720930232558139480.767441860465116310.813953488372093030.860465116279069740.906976744186046460.95348837209302317INDEX($G$33:$H$34, MATCH($E$9, $C$33:$C$34, 0), MATCH($C74, $G$32:$H$32, 0))150INDEX(Vectors[Description], MATCH($C75, Vectors[Code], 0))Gaseous hydrocarbonsF460.4$F75+($O75-$F75)/($O$73-$F$73)*(G$73-$F$73)0.372093023255813950.325581395348837230.279069767441860520.232558139534883750.1860465116279070.139534883720930269.3023255813953543E-24.6511627906976771E-2INDEX($G$33:$H$34, MATCH($E$9, $C$33:$C$34, 0), MATCH($C75, $G$32:$H$32, 0))07311164020072010201520202025203020352040204520501627Preferences.EnergyUnitsTWhINDEX(F$25:F$28, MATCH($E$8, $C$25:$C$28, 0))22.46354201025536INDEX(G$25:G$28, MATCH($E$8, $C$25:$C$28, 0))22.42370155010216622.22555663853503222.02916261568230621.83450400998200221.64156548658508721.45033184614738921.26078802363244721.07291908712447220.88671023665211445INDEX(Vectors[Description], MATCH($B82, Vectors[Code], 0))Electricity (delivered to end user)F$81*F7413.478125206153216G$81*G7414.0799986477385714.98932889575618415.88148932758491816.7567123797536317.61522772163902318.45726228621984419.28304030050384620.0927833156303120.88671023665211450INDEX(Vectors[Description], MATCH($B83, Vectors[Code], 0))Gaseous hydrocarbonsF$81*F758.9854168041021438G$81*G758.34370290236359587.23622774277884776.14767328809738885.0777916302283734.02633776494606282.99306955992754321.97774772312860090.9801357714941620902163920072010201520202025203020352040204520501629Preferences.EnergyUnitsTWhINDEX(F$17:F$20, MATCH($E$8, $C$17:$C$20, 0))59.156753873546393INDEX(G$17:G$20, MATCH($E$8, $C$17:$C$20, 0))59.32603508576167460.19760945876333861.11246277563778162.07248961327110963.15121661376527864.49562657424638765.97248871574666467.51330994716889269.12128145007250245INDEX(Vectors[Description], MATCH($B89, Vectors[Code], 0))Electricity (delivered to end user)F8859.156753873546393G8859.32603508576167460.19760945876333861.11246277563778162.07248961327110963.15121661376527864.49562657424638765.97248871574666467.51330994716889269.12128145007250231632200720102015202020252030203520402045205045INDEX(Vectors[Description], MATCH($B93, Vectors[Code], 0))Electricity (delivered to end user)Preferences.EnergyUnitsTWhF82+F8972.634879079699601G82+G8973.40603373350023775.18693835451952676.99395210322269678.82920199302473980.76644433540430282.95288886046623185.25552901625050687.60609326279920690.00799168672460850INDEX(Vectors[Description], MATCH($B94, Vectors[Code], 0))Gaseous hydrocarbonsPreferences.EnergyUnitsTWhF838.9854168041021438G838.34370290236359587.23622774277884776.14767328809738885.0777916302283734.02633776494606282.99306955992754321.97774772312860090.9801357714941620904116010401060SUM(F$93:F$94*SUMIFS(EF[CO2], EF[Vector], $B$93:$B$94))1.6533166919547941SUM(G$93:G$94*SUMIFS(EF[CO2], EF[Vector], $B$93:$B$94))1.5352413340349014SUM(H$93:H$94*SUMIFS(EF[CO2], EF[Vector], $B$93:$B$94))1.3314659046713078SUM(I$93:I$94*SUMIFS(EF[CO2], EF[Vector], $B$93:$B$94))1.1311718850099193SUM(J$93:J$94*SUMIFS(EF[CO2], EF[Vector], $B$93:$B$94))0.93431365996202043SUM(K$93:K$94*SUMIFS(EF[CO2], EF[Vector], $B$93:$B$94))0.74084614875007537SUM(L$93:L$94*SUMIFS(EF[CO2], EF[Vector], $B$93:$B$94))0.55072479902666782SUM(M$93:M$94*SUMIFS(EF[CO2], EF[Vector], $B$93:$B$94))0.36390558105566251SUM(N$93:N$94*SUMIFS(EF[CO2], EF[Vector], $B$93:$B$94))0.18034498195492579SUM(O$93:O$94*SUMIFS(EF[CO2], EF[Vector], $B$93:$B$94))01041SUM(F$93:F$94*SUMIFS(EF[CH4], EF[Vector], $B$93:$B$94))3.3140496803579565E-3SUM(G$93:G$94*SUMIFS(EF[CH4], EF[Vector], $B$93:$B$94))3.0773693129022149E-3SUM(H$93:H$94*SUMIFS(EF[CH4], EF[Vector], $B$93:$B$94))2.6689043770351741E-3SUM(I$93:I$94*SUMIFS(EF[CH4], EF[Vector], $B$93:$B$94))2.2674178771610268E-3SUM(J$93:J$94*SUMIFS(EF[CH4], EF[Vector], $B$93:$B$94))1.8728183784863575E-3SUM(K$93:K$94*SUMIFS(EF[CH4], EF[Vector], $B$93:$B$94))1.4850155172368767E-3SUM(L$93:L$94*SUMIFS(EF[CH4], EF[Vector], $B$93:$B$94))1.1039199888689154E-3SUM(M$93:M$94*SUMIFS(EF[CH4], EF[Vector], $B$93:$B$94))7.2944353640564947E-4SUM(N$93:N$94*SUMIFS(EF[CH4], EF[Vector], $B$93:$B$94))3.6149893889671388E-4SUM(O$93:O$94*SUMIFS(EF[CH4], EF[Vector], $B$93:$B$94))01042SUM(F$93:F$94*SUMIFS(EF[N2O], EF[Vector], $B$93:$B$94))3.5644215488280567E-3SUM(G$93:G$94*SUMIFS(EF[N2O], EF[Vector], $B$93:$B$94))3.3098603070506956E-3SUM(H$93:H$94*SUMIFS(EF[N2O], EF[Vector], $B$93:$B$94))2.8705364103769767E-3SUM(I$93:I$94*SUMIFS(EF[N2O], EF[Vector], $B$93:$B$94))2.4387181608809725E-3SUM(J$93:J$94*SUMIFS(EF[N2O], EF[Vector], $B$93:$B$94))2.0143072159971237E-3SUM(K$93:K$94*SUMIFS(EF[N2O], EF[Vector], $B$93:$B$94))1.5972063850930066E-3SUM(L$93:L$94*SUMIFS(EF[N2O], EF[Vector], $B$93:$B$94))1.1873196167902292E-3SUM(M$93:M$94*SUMIFS(EF[N2O], EF[Vector], $B$93:$B$94))7.8455198641946865E-4SUM(N$93:N$94*SUMIFS(EF[N2O], EF[Vector], $B$93:$B$94))3.8880968360822731E-4SUM(O$93:O$94*SUMIFS(EF[N2O], EF[Vector], $B$93:$B$94))027392007201020152020202520302035204020452050360036010.90.90.90.90.90.90.90.90.90.9360236010.50.50.50.50.50.50.50.50.50.5360387 (F88 * 0.9)53.241078486191753 (F88 * 0.9) + (G88-F88)53.410359698407035 (G88 * 0.9) + (H88-G88)54.265005950187174 (H88 * 0.9) + (I88-H88)55.09270182976144555.9612433357073356.94396765243816858.18050491286985759.52292605832202860.91606107559422962.369950455355614360487 (F81 * F105)11.23177100512768 (G81 * G105) + (G81 - F81)11.172010314897889 (H81 * H105) + (H81 - G81)10.91463340770038210.81818728498842810.72259339929069610.62784421989562810.53393228263599610.44085018930128210.34859060705426110.257146267853699318320072010201520202025203020352040204520503176Preferences.moneyunits£m ((F107 * 0.27778) * $F$56) + ((F108 * 0.27778) * $F$57)372.28089946755961 ((G107 * 0.27778) * $F$56) + ((G108 * 0.27778) * $F$57)371.74711617812238369.84977166390314370.76125155285968371.81866125951325373.25635194252027375.52063950863067378.13840589612147380.93311986093852383.936753892060443177Preferences.moneyunits£m (F88 * $F$60) + (F81 * $F$61)0 (G88 * $F$60) + (G81 * $F$61)0000000003184Preferences.moneyunits£m F112 + F113372.28089946755961 G112 + G113371.74711617812238369.84977166390314370.76125155285968371.81866125951325373.25635194252027375.52063950863067378.13840589612147380.93311986093852383.9367538920604431853176Preferences.moneyunits£m ((F107 * 0.27778) * $E$56) + ((F108 * 0.27778) * $E$57)1254.342907918375 ((G107 * 0.27778) * $E$56) + ((G108 * 0.27778) * $E$57)1256.6136607180841268.87551452956471283.49969729160631298.94651245247521316.66531180599651339.41570841558771364.27379610031681390.1490243281381417.23970961443373177Preferences.moneyunits£m (F88 * $E$60) + (F81 * $EF$61)0 (G88 * $E$60) + (G81 * $EF$61)0000000003184Preferences.moneyunits£m F117 + F1181254.342907918375 G117 + G1181256.6136607180841268.87551452956471283.49969729160631298.94651245247521316.66531180599651339.41570841558771364.27379610031681390.1490243281381417.2397096144337683729Preferences.EnergyUnitsTWh7841844269169272072172272372472572672757INDEX(Vectors[Description], MATCH([Vector], Vectors[Code], 0))Lighting & appliancesF93+F9481.620295883801745G93+G9481.74973663586382682.42316609729837883.1416253913200983.90699362325311584.79278210035036585.94595842039377987.23327673937910788.58622903429336890.00799168672460845INDEX(Vectors[Description], MATCH([Vector], Vectors[Code], 0))Electricity (delivered to end user)-F93-72.634879079699601-G93-73.406033733500237-75.186938354519526-76.993952103222696-78.829201993024739-80.766444335404302-82.952888860466231-85.255529016250506-87.606093262799206-90.00799168672460850INDEX(Vectors[Description], MATCH([Vector], Vectors[Code], 0))Gaseous hydrocarbons-F94-8.9854168041021438-G94-8.3437029023635958-7.2362277427788477-6.1476732880973888-5.077791630228373-4.0263377649460628-2.9930695599275432-1.9777477231286009-0.980135771494162090148SUBTOTAL(109,[2007])0SUBTOTAL(109,[2010])0SUBTOTAL(109,[2015])0SUBTOTAL(109,[2020])0SUBTOTAL(109,[2025])0SUBTOTAL(109,[2030])0SUBTOTAL(109,[2035])4.8849813083506888E-15SUBTOTAL(109,[2040])0SUBTOTAL(109,[2045])0SUBTOTAL(109,[2050])0889105810611057102744269169272072172272372472572672710401050INDEX(IPCC[Sector_description], MATCH([IPCC Sector], IPCC[Sector_code], 0))Fuel CombustionF981.6533166919547941G981.53524133403490141.33146590467130781.13117188500991930.934313659962020430.740846148750075370.550724799026667820.363905581055662510.18034498195492579010411050INDEX(IPCC[Sector_description], MATCH([IPCC Sector], IPCC[Sector_code], 0))Fuel CombustionF993.3140496803579565E-3G993.0773693129022149E-32.6689043770351741E-32.2674178771610268E-31.8728183784863575E-31.4850155172368767E-31.1039199888689154E-37.2944353640564947E-43.6149893889671388E-4010421050INDEX(IPCC[Sector_description], MATCH([IPCC Sector], IPCC[Sector_code], 0))Fuel CombustionF1003.5644215488280567E-3G1003.3098603070506956E-32.8705364103769767E-32.4387181608809725E-32.0143072159971237E-31.5972063850930066E-31.1873196167902292E-37.8455198641946865E-43.8880968360822731E-40148SUBTOTAL(109,[2007])1.66019516318398SUBTOTAL(109,[2010])1.5416285636548543SUBTOTAL(109,[2015])1.3370053454587199SUBTOTAL(109,[2020])1.1358780210479613SUBTOTAL(109,[2025])0.93820078555650399SUBTOTAL(109,[2030])0.74392837065240525SUBTOTAL(109,[2035])0.55301603863232696SUBTOTAL(109,[2040])0.36541957657848761SUBTOTAL(109,[2045])0.18109529057743073SUBTOTAL(109,[2050])0261326187826144426916927207217227237247257267272615INDEX(Vectors[Description], MATCH([Vector], Vectors[Code], 0))UK Land areaINDEX(Vectors[Comment], MATCH([Information type], Vectors[Description], 0))0F9102621INDEX(Vectors[Description], MATCH([Vector], Vectors[Code], 0))Number of unitsF9372.6348790796996013189319078418442691692720721722723724725726727313131320G112371.74711617812238369.84977166390314370.76125155285968371.81866125951325373.25635194252027375.52063950863067378.13840589612147380.93311986093852383.936753892060443133313431353136314031410G1171256.6136607180841268.87551452956471283.49969729160631298.94651245247521316.66531180599651339.41570841558771364.27379610031681390.1490243281381417.23970961443373142314331443145