672INDEX(Workstreams[Workstream], MATCH($A1, Workstreams[Code], 0))Agriculture and waste952INDEX(Modules[Module], MATCH($A2, Modules[Code], 0))Volume of Waste & Recycling3480134182513361439MIN(VI.b.Scenario,3)313382086118813367920072010201520202025203020352040204520501142534.78F15*1.015^336.36869388249999G15*1.015^539.17941216178474H15*1.015^542.207354003483616I15*1.01^544.36035324578974646.62317708731117749.00142768635608851.50099296760863954.12806119908609856.889136312667342142534.78F16*1.0075^335.56843379781251G16*1.0075^536.922407927119636H16*1.0075^538.327923430254302I16*1.005^539.29575152666701140.28801849532675341.30534144838279842.34835308083950943.41770206404296344.5140534491035923142534.7834.7834.7834.7834.7834.7834.7834.7834.7834.782087118813367920072010201520202025203020352040204520501143076.599999999999994F22*1.015^380.098963524999959G22*1.015^586.289332133200404H22*1.015^592.958117212962733I22*1.01^597.699915429197631102.68359301000676107.9214882338952113.42656875557275119.2124637104656125.293497456880872143076.599999999999994F23*1.0075^378.336458565625023G23*1.0075^581.318471742879936H23*1.0075^584.41400042430935I23*1.005^586.54555971658116788.73094355209974590.97151106803110693.26865572145790495.62380615600029998.0384270903201413143076.59999999999999476.59999999999999476.59999999999999476.59999999999999476.59999999999999476.59999999999999476.59999999999999476.59999999999999476.59999999999999476.599999999999994208811881336792007201020152020202520302035204020452050120942.3218999999999999F29*1.015^32.4279606189124991G29*1.015^52.6156031368156407H29*1.015^52.8177474198012824I29*1.01^52.96148085685449133.11254614373282973.2713172784632033.43818733673060623.61356944503041973.7978978034612503220942.3218999999999999F30*1.0075^32.3745355501765628G30*1.0075^52.4649263647492545H30*1.0075^52.5587580624700244I30*1.005^52.62336990999908352.68961328764517482.75752939358826942.82716046631400932.89854981088272992.9717418258618062320942.32189999999999992.32189999999999992.32189999999999992.32189999999999992.32189999999999992.32189999999999992.32189999999999992.32189999999999992.32189999999999992.3218999999999999209911881336792007201020152020202520302035204020452050114291.36763600000000011.3956603471915111.44325167098906081.49210027424978261.5397771243633741.58302562684427551.6212144615531471.65654252734666191.69025970172515731.7224027253405279214291.36763600000000011.3956603471915111.44325167098906081.49210027424978261.5397771243633741.58302562684427551.6212144615531471.65654252734666191.69025970172515731.7224027253405279314291.36763600000000011.3956603471915111.44325167098906081.49210027424978261.5397771243633741.58302562684427551.6212144615531471.65654252734666191.69025970172515731.722402725340527920982097133679200720102015202020252030203520402045205012273.96632462248365813.99104301822280763.92451556097435363.78055791540571033.6851893210263883.67699767822196753.72574092696985473.81280617437250553.93276565130803764.079828738101471522273.96632462248365813.9843275018434413.86444746328333193.64722068203025223.4505381991998723.29062920346913183.14205469864502172.97430018837597922.79819715614113432.616034144034585632273.96632462248365813.90814335115372653.57175282607606943.22287808183718653.02322985734105742.82252862227294042.61438621234355712.39220049763494822.15025803508250311.8996908433717392100188020922089792007201020152020202520302035204020452050141920910.370235589730690540.44557325779076690.473194907033215870.500120402561434750.500120402561434860.500120402561434750.500120402561434750.500120402561434750.500120402561434860.50012040256143486142020900.537924256322893420.441174457067120270.360665477006101080.304413382713921150.300329194147151420.296245005580381640.292160817013611910.288076628446842120.288076628446842120.28807662844684218142114369.1840153946416023E-20.113252285142112860.166139615960683160.195466214724644010.19955040329141380.203634591858183560.207718780424953340.21180296899172310.211802968991723130.21180296899172313SUM(F$54:F$56)1SUM(G$54:G$56)110.9999999999999998910.999999999999999891111.0000000000000002188120922089792007201020152020202520302035204020452050141920910.370235589730690540.440318464335248570.471443309214709780.500120402561434860.524833885801380680.549547369041326510.575270281323355230.599983764563300940.622069851075487730.64327939990448701142020900.537924256322893420.392197087295814650.283385853710448110.229969807012899540.195513126869471860.164155427481862630.129810566050347389.8452866662738295E-27.1246724988764512E-24.8598396332866951E-2142114369.1840153946416023E-20.167484448368936670.245170837074842160.269909790425665710.279652987329147620.286297203476810870.294919152626297420.301563368773960670.306683423935747770.30812220376264604SUM(F$54:F$56)1SUM(G$54:G$56)110.9999999999999998910.999999999999999891111.0000000000000002188220922089792007201020152020202520302035204020452050141920910.370235589730690540.448940061687623520.536133046149624540.610932974734811010.640622716067189570.676430209169767590.71223770227234540.748045195374923420.772618487465908550.80014678734480249142020900.537924256322893420.40466924475316590.285620398603717240.205550566877070680.171776636977922110.131884955308574419.1993273639226783E-25.2101591969879131E-22.7528299878893835E-20142114369.1840153946416023E-20.146390693559210530.178246555246658140.183516458388118420.187600646954888210.191684835521657960.195769024088427750.199853212655197510.199853212655197510.19985321265519751SUM(F$54:F$56)1SUM(G$54:G$56)110.9999999999999998910.999999999999999891111.0000000000000002211921181336792007201020152020202520302035204020452050121200000.250.80.80.80.80.80.8221200000.250.80.80.80.80.80.832120000.40.8$I81+($O81-$I81)/($O$78-$I$78)*(J$78-$I$78)0.81666666666666665$I81+($O81-$I81)/($O$78-$I$78)*(K$78-$I$78)0.83333333333333337$I81+($O81-$I81)/($O$78-$I$78)*(L$78-$I$78)0.85000000000000009$I81+($O81-$I81)/($O$78-$I$78)*(M$78-$I$78)0.8666666666666667$I81+($O81-$I81)/($O$78-$I$78)*(N$78-$I$78)0.88333333333333330.921132149133679200720102015202020252030203520402045205012114000.10.20.40.60.811122114000.10.20.40.60.811132114000.10.20.40.60.8111214621481336792007201020152020202520302035204020452050121470.750.750.750.750.750.750.750.750.750.75221470.750.750.750.750.760.770.780.780.790.8321470.750.750.750.750.770.780.80.820.830.85212821261336792007201020152020202520302035204020452050121250.750.750.750.750.750.750.750.750.750.75221250.750.750.750.750.75833333333333330.766666666666666720.775000000000000020.783333333333333330.791666666666666740.8321250.750.750.750.750.766666666666666610.783333333333333330.80.816666666666666650.833333333333333260.85213521261336792007201020152020202520302035204020452050121270.4$F107+($O107-F$107)/($O$106-$F$106)*(G$106-$F$106)0.4$F107+($O107-G$107)/($O$106-$F$106)*(H$106-$F$106)0.40.40.40.40.40.40.40.4221270.4$F108+($O108-F$107)/($O$106-$F$106)*(G$106-$F$106)0.413953488372093060.437209302325581420.460465116279069770.483720930232558130.506976744186046550.530232558139534850.553488372093023260.576744186046511680.6321270.40.42790697674418610.474418604651162810.520930232558139530.567441860465116350.613953488372093070.660465116279069790.70697674418604650.753488372093023220.8442109213678420951431142479442641142514302094210514320.280000000000000030.131210614330.330.10210714340.140000000000000010.380210820930.250.390SUM(G120:G123)1SUM(H120:H123)1SUM(I120:I123)12096Preferences.EnergyUnits & " / M odt"TWh / M odt14247944214362105143216*Unit.PJ4.4444444444444446210614335*Unit.PJ1.38888888888888882107143430*Unit.PJ8.33333333333333392108209302109143814*Unit.PJ3.8888888888888893211012302137214414794421442104114510.16165/F$36*GWP.CH42.482129747973875810421452 0.00403/$F$36*GWP.N2O0.913474053037503952138Preferences.EnergyUnits & " / M tonnes"TWh / M tonnes1479442144610411445(Constants.GCV.NaturalGasProduced/0.717)*100000000015.36535566422297127388530740.21530757171092139214021411171447317034813306Preferences.moneyunits&"/odt. Millions"£m/odt. Millions7917991801348232*Euro2002_*100000020.12578616352201280*Euro2002_*100000050.3144654088050343483348430*Euro2002_*100000018.867924528301888200*Euro2002_*1000000125.78616352201257348511*Euro2002_*10000006.918238993710691233*Euro2002_*100000020.7547169811320773486348734493306Preferences.moneyunits&"/landfill site"£m/landfill site793488348917991801179918014423490250000/10000000.251550%*23.5*MGBP*Price200812.267312571124311150%*23.5*MGBP*Price200836.80193771337293650%*((6+8)*GBP)*($E$171*1000000)*Price20081.8270465531461739150%*((6+8)*GBP)*($E$171*1000000)*Price20085.48113965943852223491348734493306Preferences.moneyunits&"/landfill site"£m/landfill site793492348917991801179918014423493F276/(F313*F277)2.2066764471178897E-21501*MGBP13494F279/(F313*F278)1.2412555015038129E-21501*MGBP13495348734493306Preferences.moneyunits&"/sewage works"£m/sewage works7934883489179918011799180144234961000/10000001E-31501*MGBP1717348081214401435144179442200720102015202020252030203520402045205014251426INDEX(F$15:F$17, MATCH($E$7, $C$15:$C$17, 0))34.78INDEX(G$15:G$17, MATCH($E$7, $C$15:$C$17, 0))34.7834.7834.7834.7834.7834.7834.7834.7834.7814301427INDEX(F$22:F$24, MATCH($E$7, $C$22:$C$24, 0))76.599999999999994INDEX(G$22:G$24, MATCH($E$7, $C$22:$C$24, 0))76.59999999999999476.59999999999999476.59999999999999476.59999999999999476.59999999999999476.59999999999999476.59999999999999476.59999999999999476.599999999999994209421032104INDEX(F$29:F$31, MATCH($E$7, $C$29:$C$31, 0))2.3218999999999999INDEX(G$29:G$31, MATCH($E$7, $C$29:$C$31, 0))2.32189999999999992.32189999999999992.32189999999999992.32189999999999992.32189999999999992.32189999999999992.32189999999999992.32189999999999992.32189999999999992261429INDEX(F$36:F$38, MATCH($E$7, $C$36:$C$38, 0))1.3676360000000001INDEX(G$36:G$38, MATCH($E$7, $C$36:$C$38, 0))1.3956603471915111.44325167098906081.49210027424978261.5397771243633741.58302562684427551.6212144615531471.65654252734666191.69025970172515731.7224027253405279142272102INDEX(F$43:F$45, MATCH($E$7, $C$43:$C$45, 0))3.9663246224836581INDEX(G$43:G$45, MATCH($E$7, $C$43:$C$45, 0))3.90814335115372653.57175282607606943.22287808183718653.02322985734105742.82252862227294042.61438621234355712.39220049763494822.15025803508250311.89969084337173921013497144179442200720102015202020252030203520402045205014251426CHOOSE($E$7, $F$56:$O$56, $F$64:$O$64, $F$72:$O$72)9.1840153946416023E-20.146390693559210530.178246555246658140.183516458388118420.187600646954888210.191684835521657960.195769024088427750.199853212655197510.199853212655197510.1998532126551975114301427CHOOSE($E$7, $F$56:$O$56, $F$64:$O$64, $F$72:$O$72)9.1840153946416023E-20.146390693559210530.178246555246658140.183516458388118420.187600646954888210.191684835521657960.195769024088427750.199853212655197510.199853212655197510.1998532126551975120942115INDEX(F$86:F$88, MATCH($E$7, $C$86:$C$88, 0))0INDEX(G$86:G$88, MATCH($E$7, $C$86:$C$88, 0))00.10.20.40.60.81112261429INDEX(F$93:F$95, MATCH($E$7, $C$93:$C$95, 0))0.75INDEX(G$93:G$95, MATCH($E$7, $C$93:$C$95, 0))0.750.750.750.770.780.80.820.830.8534983497144179442200720102015202020252030203520402045205014251426CHOOSE($E$7, $F$55:$O$55, $F$63:$O$63, $F$71:$O$71)0.537924256322893420.40466924475316590.285620398603717240.205550566877070680.171776636977922110.131884955308574419.1993273639226783E-25.2101591969879131E-22.7528299878893835E-2014301427CHOOSE($E$7, $F$55:$O$55, $F$63:$O$63, $F$71:$O$71)0.537924256322893420.40466924475316590.285620398603717240.205550566877070680.171776636977922110.131884955308574419.1993273639226783E-25.2101591969879131E-22.7528299878893835E-2021213497144179442200720102015202020252030203520402045205014251426CHOOSE($E$7, $F$54:$O$54, $F$62:$O$62, $F$70:$O$70)0.370235589730690540.448940061687623520.536133046149624540.610932974734811010.640622716067189570.676430209169767590.71223770227234540.748045195374923420.772618487465908550.8001467873448024914301427CHOOSE($E$7, $F$54:$O$54, $F$62:$O$62, $F$70:$O$70)0.370235589730690540.448940061687623520.536133046149624540.610932974734811010.640622716067189570.676430209169767590.71223770227234540.748045195374923420.772618487465908550.80014678734480249731121112211231449421425145812117200720102015202020252030203520402045205021592066F$194*F$2033.1942005542563492G$194*G$2035.09146832198934266.19941519147876986.38270242273875886.52475050109101236.6667985794432646.80884665779551766.95089473614776936.9508947361477693O$194*O$2036.950894736147769321562105F233*$G$120:$G$1230.89437615519177782G233*$G$120:$G$1231.425611130157016H233*$G$120:$G$1231.7358362536140557I233*$G$120:$G$1231.7871566783668527J233*$G$120:$G$1231.8269301403054836K233*$G$120:$G$1231.8667036022441141L233*$G$120:$G$1231.9064770641827451M233*$G$120:$G$1231.9462505261213756N233*$G$120:$G$1231.9462505261213756O233*$G$120:$G$1231.946250526121375621061.05408618290459531.68018454625648312.04580701318799422.10629179950379042.1531676653600342.20004353121627722.24691939707252082.29379526292876392.29379526292876392.293795262928763921070.447188077595888910.712805565078508010.867918126807027850.893578339183426330.913465070152741810.933351801122057070.953238532091372550.973125263060687810.973125263060687810.9731252630606878121080.79855013856408731.27286708049733571.54985379786969251.59567560568468971.63118762527275311.6666996448608161.70221166444887941.73772368403694231.73772368403694231.737723684036942321602066F$195*F$2047.0349557922954666G$195*G$20411.21352712663552613.65368613189401314.05736071252987114.37020955674443614.68305840095899814.99590724517356415.30875608938812815.30875608938812815.30875608938812821562105F239*$H$120:$H$1230.91454425299841069G239*$H$120:$H$1231.4577585264626185H239*$H$120:$H$1231.7749791971462217I239*$H$120:$H$1231.8274568926288832J239*$H$120:$H$1231.8681272423767767K239*$H$120:$H$1231.9087975921246698L239*$H$120:$H$1231.9494679418725633M239*$H$120:$H$1231.9901382916204566N239*$H$120:$H$1231.9901382916204566O239*$H$120:$H$1231.990138291620456621060.703495579229546751.12135271266355271.36536861318940141.40573607125298721.43702095567444381.46830584009589991.49959072451735651.53087560893881291.53087560893881291.530875608938812921072.67328320107227764.26114030812155.18840073011972525.34179707076135115.46067963156288635.57956219236441965.69844475316595485.8173273139674895.8173273139674895.81732731396748921082.74363275899523234.37327557938785555.32493759143866545.48237067788664945.60438172713033025.72639277637400925.848403825617695.97041487486136995.97041487486136995.970414874861369921142066F$196*F$2050G$196*G$20500.232190000000000010.464380000000000010.928760000000000031.39313999999999981.85752000000000012.32189999999999992.32189999999999992.321899999999999921562105F245*$I$120:$I$1230G245*$I$120:$I$1230H245*$I$120:$I$1230.23219000000000001I245*$I$120:$I$1230.46438000000000001J245*$I$120:$I$1230.92876000000000003K245*$I$120:$I$1231.3931399999999998L245*$I$120:$I$1231.8575200000000001M245*$I$120:$I$1232.3218999999999999N245*$I$120:$I$1232.3218999999999999O245*$I$120:$I$1232.3218999999999999210600000000002107000000000021080000000000212321562105Preferences.EnergyUnitsTWh(F234+F240+F246)*INDEX($F$128:$F$133, MATCH($D252, $C$128:$C$133, 0))8.0396462586230601(G234+G240+G246)*INDEX($F$128:$F$133, MATCH($D252, $C$128:$C$133, 0))12.8149762516428216.63557978115678918.12886031553660320.55029947858782422.97173864163903925.39317780469026127.81461696774147527.81461696774147527.8146169677414752106Preferences.EnergyUnitsTWh(F235+F241+F247)*INDEX($F$128:$F$133, MATCH($D253, $C$128:$C$133, 0))2.44108578074186383.8910239707222724.73774392552416054.87781648716219074.98637308477010785.09492968237802395.20348627998594095.31204287759385625.31204287759385625.31204287759385622107Preferences.EnergyUnitsTWh(F236+F242+F248)*INDEX($F$128:$F$133, MATCH($D254, $C$128:$C$133, 0))26.00392732223472341.44954894333340450.46932380772294451.96146174953981553.11787251429690654.27428327905397555.43069404381106656.58710480856814256.58710480856814256.5871048085681422337753INDEX(Vectors[Description], MATCH(C257, Vectors[Code], 0))Dry biomass and wastePreferences.EnergyUnitsTWhF252+F25310.48073203936492316.70600022236509121.37332370668094923.00667680269879225.53667256335793228.06666832401706230.59666408467620333.12665984533533233.12665984533533233.12665984533533247INDEX(Vectors[Description], MATCH(C258, Vectors[Code], 0))Solid hydrocarbonsPreferences.EnergyUnitsTWhF25426.00392732223472341.44954894333340450.46932380772294451.96146174953981553.11787251429690654.27428327905397555.43069404381106656.58710480856814256.58710480856814256.58710480856814222116200720102015202020252030203520402045205021572066F$194*F$21912.87679381083341715.61413534549554618.64670734508394321.24824886127672822.28085806481685423.52624267492451824.77162728503217426.01701189513983826.87167099406429927.82910526385223121562122F263*$G$121*INDEX(F$79:F$81,MATCH($E$7,$C$79:$C$81))0G263*$G$121*INDEX(G$79:G$81,MATCH($E$7,$C$79:$C$81))02.46136536955108075.60953769937705726.00469124846814236.46971673560424336.94844145345152517.44086540200999477.8330920947697429O263*$G$121*INDEX(O$79:O$81,MATCH($E$7,$C$79:$C$81))8.265244263364113721582066F$195*F$22028.360046173370893G$195*G$22034.38880872527195741.06779133506123746.79746586468652249.0717000507467251.81455402240419554.55740799406165657.3002619657191359.18257613988858961.29124391061186821562122F266*$H$121*INDEX(F$79:F$81,MATCH($E$7,$C$79:$C$81))0G266*$H$121*INDEX(G$79:G$81,MATCH($E$7,$C$79:$C$81))01.64271165340244973.74379726917492174.00752217081098214.31787950186701694.63737967949524154.96602270369565795.22779422569015935.51621195195506872124916INDEX(Vectors[Description], MATCH(C270, Vectors[Code], 0))Wet biomass and wastePreferences.EnergyUnitsTWh(F$264+F$267)*$F$129005.700106976324348412.99074301187774713.90585197122100614.98277255204341416.0914182402038417.23178903570229518.14011988952764319.1409114101655293164921301448F$1983.9663246224836581G$1983.90814335115372653.57175282607606943.22287808183718653.02322985734105742.82252862227294042.61438621234355712.39220049763494822.15025803508250311.8996908433717398332129INDEX(F$100:F$102, MATCH($E$7,$C$100:$C$102, 0))0.75INDEX(G$100:G$102, MATCH($E$7,$C$100:$C$102, 0))0.750.750.750.766666666666666610.783333333333333330.80.816666666666666650.833333333333333260.858332131INDEX(F$107:F$109, MATCH($E$7,$C$107:$C$109, 0))0.4INDEX(G$107:G$109, MATCH($E$7,$C$107:$C$109, 0))0.42790697674418610.474418604651162810.520930232558139530.567441860465116350.613953488372093070.660465116279069790.70697674418604650.753488372093023220.883521341448F276*F277*F2781.1898973867450975G276*G277*G2781.25424135455631251.27087949392939211.2591709715084821.31522216739519491.35743934671173051.38136871498710771.381171264060861.35016202202854841.29178977349278268332132(1-F277)0.25(1-G277)0.250.250.250.233333333333333390.216666666666666670.199999999999999960.183333333333333350.166666666666666740.1500000000000000283521331444F276*F281*GWP.CH420.82320426803920620.51775259355706318.75170233689936316.92010992964522814.81382630097118512.84250523134187810.9804220918429369.20997191589455267.52590312278876365.984026156620978521242219INDEX(Vectors[Description], MATCH(C285, Vectors[Code], 0))Gaseous wastePreferences.EnergyUnitsTWhF279*$F$14418.283196551267896G279*$F$14419.27186450153452719.52751543059280719.34760981929299520.20885637949736920.85753835483621921.22522160920756221.22218770549953620.74571967279509719.8488093131226364214314502066F$1971.3676360000000001G$1971.3956603471915111.44325167098906081.49210027424978261.5397771243633741.58302562684427551.6212144615531471.65654252734666191.69025970172515731.722402725340527983321502151$F$1390.9134740530375039583521521061F290*$F2921.2492999999999999G290*$F2921.27489951401275951.31837295345152761.36299488505732011.40654645056664411.44605283541567561.48093734503796771.51320861648434551.5440083804208421.57337019847965468332145F$2060.75G$2060.750.750.750.770.780.80.820.830.8583514432066F295*F$2901.0257270000000001G295*G$2901.04674526039363341.08243875324179561.1190752056873371.1856283857597981.2347599889385351.29697156924251771.35836487242426271.40291555243188041.464042316539448721532066F290-F2960.34190900000000002G290-G2960.348915086797877640.36081291774726520.373025068562445660.354148738603575990.34826563790574050.32424289231062930.298177654922399120.28734414929327690.258360408801079138332154$F$1382.482129747973875883521551061F298*$F2990.84866249999999999G298*$F2990.866052516457899050.895584476593738190.925896619418840940.879043119295360050.864440500042936710.804812928573302890.740115627463975860.713225460867089160.641284056383850112124916INDEX(Vectors[Description], MATCH(C303, Vectors[Code], 0))Wet biomass and wastePreferences.EnergyUnitsTWhF$296*$F$1323.98893833333333394.07067601264190774.20948404038476114.3519591332285334.6107770557325484.80184440142763695.04377832483201345.28253005942768895.45578270390175755.69349789765341195307634992066SUM(F194:F195)111.38SUM(G194:G195)111.38111.38111.38111.38111.38111.38111.38111.38111.3835002066SUMPRODUCT(F$194:F$195,F$203:F$204)10.229156346551816SUMPRODUCT(G$194:G$195,G$203:G$204)16.30499544862486919.85310132337278320.4400631352686320.89496005783544821.34985698040226221.80475390296908222.25965082553589622.25965082553589622.25965082553589635012066SUMPRODUCT(F$194:F$195,F$211:F$212)59.91400366924386845.07206048060761831.81239999648202122.89422213876813219.13248182660096214.68934632226901710.2462108179370795.80307531360513723.0661020405111952035022066SUMPRODUCT(F194:F195,F219:F220)41.23683998420430950.00294407076750559.71449868014518468.04571472596325171.35255811556356875.34079669732871379.3290352790938383.31727386085896186.05424713395288489.12034917446409635032066SUM(F264,F267)0SUM(G264,G267)04.10407702295353089.353334968551978410.01221341927912410.78759623747125911.58582113294676612.40688810570565313.06088632045990213.78145621531918235042740F308/$E$171239.65601467697547G308/$E$171180.28824192243047127.2495999859280991.57688855507252976.52992730640384958.75738528907606940.98484327174831823.21230125442054912.264408162044781035052740F$313/379.885338225658487MAX(G313-SUM(G315:G316),0)20.5175654711135MAX(H313-SUM(H315:H316),0)26.846696289156144.2126267948029295.47060422244481979.074154271828319926.44008477747517800035062740F$313/379.885338225658487F31479.885338225658487G31420.5175654711135H31426.846696289156144.2126267948029295.47060422244481979.074154271828319926.4400847774751780035072740F$313/379.885338225658487F31579.885338225658487G31579.88533822565848720.517565471113526.846696289156144.2126267948029295.47060422244481979.074154271828319926.440084777475178035082740F276/$E$176179.74201100773161G276/$E$176177.10540918937616161.86119314143619146.05122948797248137.00376696772457127.90858514665378118.47619145789005108.4073970499557897.44328571100335586.08832735097614435052740F$318/359.914003669243868MAX(G318-SUM(G320:G321),0)57.277401850888424MAX(H318-SUM(H320:H321),0)44.66978762130389744.10404001578015748.22993933064051935.57460580023310134.67164632701643338.16114492270624224.6104944612806823.31668796698922135062740F$318/359.914003669243868F31959.914003669243868G31957.277401850888424H31944.66978762130389744.10404001578015748.22993933064051935.57460580023310134.67164632701643338.16114492270624224.6104944612806835072740F$318/359.914003669243868F32059.914003669243868G32059.91400366924386857.27740185088842444.66978762130389744.10404001578015748.22993933064051935.57460580023310134.67164632701643338.16114492270624235092740F279/$E$17795.862405870790198G279/$E$177101.04618694835727102.38661519644336101.44333459009559105.95902018575302109.36018773468942111.28802356271888111.27211620714152108.77390032856188104.0712223976245135052740F$323/331.954135290263398MAX(G323-SUM(G325:G326),0)37.137916367830478MAX(H323-SUM(H325:H326),0)33.29456353834947931.01085468391562541.65360196348791536.69573108728587832.93869051194508341.63769460791056134.19751520870623628.23601258100771435062740F$323/331.954135290263398F32431.954135290263398G32437.137916367830478H32433.29456353834947931.01085468391562541.65360196348791536.69573108728587832.93869051194508341.63769460791056134.19751520870623635072740F$323/331.954135290263398F32531.954135290263398G32531.95413529026339837.13791636783047833.29456353834947931.01085468391562541.65360196348791536.69573108728587832.93869051194508341.63769460791056135102740F296/$E$1821025.7270000000001G296/$E$1821046.74526039363331082.43875324179571119.07520568733681185.6283857597981234.75998893853491296.97156924251771358.36487242426281402.91555243188031464.042316539448630772740SUM(F233,F239,F245)/$F$14947.577471379310772SUM(G233,G239,G245)/$F$14975.83718813313892393.41995964359433997.229968071016884101.50567468760674105.78138130419656110.05708792078643114.33279453737626114.33279453737626114.33279453737626633273511Preferences.moneyunits£m2007201020152020202520302035204020452050351214363490(G$314/5)*$G$17150.339077766531354(H$314/5)*$G$17165.8673629762242108.4740224964627113.42192238992861422.26309735422418364.8697568744627520003513(G$319/5)*$G$1760(H$319/5)*$G$176000000003514(G$324/5)*$G$1770(H$324/5)*$G$177000000003510((G$328-F$328)+(F$328/3))*$G$182/50((H$328-G$328)+(G$328/3))*$G$182/500000000351535161483517SUM(F334:F340)0SUM(G334:G340)50.33907776653135465.8673629762242108.4740224964627113.42192238992861422.26309735422418364.8697568744627520003518Preferences.moneyunits£m2007201020152020202520302035204020452050351214363490(G$314/5)*$H$171151.01723329959407(H$314/5)*$H$171197.6020889286726325.4220674893881640.26576716978584666.789292062672558194.609270623388280003513(G$319/5)*$H$17611.455480370177686(H$319/5)*$H$1768.933957524260788.82080800315603149.64598786612810427.11492116004662026.93432926540328697.63222898454124814.92209889225613574.6633375933978443514(G$324/5)*$H$1777.4275832735660954(H$324/5)*$H$1776.6589127076698966.20217093678312468.33072039269758247.33914621745717536.58773810238901628.32753892158211256.83950304174124755.64720251620154293510((G$328-F$328)+(F$328/3))*$H$182/572.585452078726661((H$328-G$328)+(G$328/3))*$H$182/576.92171592920803479.48987403856128387.91564972698134388.86821301973391594.75964865669888698.74343191918352199.467794163141022105.7530563169723335153516148SUM(F345:F352)0SUM(G345:G352)242.48574902206451290.11667508981134419.93492046788856146.15812515559287170.11157245991026302.89098664787946114.70319982530688111.22939609713841116.063596426571723519Preferences.moneyunits£m20072010201520202025203020352040204520503512G$306*$E1632241.6100628930817H$306*$E1632241.61006289308172241.61006289308172241.61006289308172241.61006289308172241.61006289308172241.61006289308172241.61006289308172241.61006289308171436G$307*$E1640H$307*$E164000000003490G$313*$I171329.39501097716015H$313*$I171232.49094304351934167.31523858239657139.82373989769241107.3524782642881474.88121663088392742.40995499747967322.40764465884171803513(G$318/5)*$I$1760(H$318/5)*$I$176000000003514(G$323/5)*$I$1770(H$323/5)*$I$177000000003510(G$328)*$I$1820(H$328)*$I$182000000003515G$309*$E165943.4517749201417H$309*$E1651126.6886543423621283.8814099238351346.27468142572771421.52446598733421496.77425054894021572.02403511054651623.6650402632621681.51602215973516G$311*$E1660H$311*$E16628.39298569338920364.70860670067405469.2668852906102974.631168938480480.153479536109785.83381708349821890.35833303462824595.3434077789377311483517SUM(F356:F363)0SUM(G356:G363)3514.45684879038393629.1826459723523757.51531809998693796.97536950711263845.11817608318423893.41900960901563941.87787008460653978.04108084981364018.46949283171943520Preferences.moneyunits£m20072010201520202025203020352040204520503512G$306*$F1635604.0251572327043H$306*$F1635604.02515723270435604.02515723270435604.02515723270435604.02515723270435604.02515723270435604.02515723270435604.02515723270435604.02515723270431436G$307*$F1640H$307*$F164000000002090G$313*$J171988.18503293148046H$313*$J171697.47282913055801501.94571574718975419.47121969307727322.05743479286446224.64364989265178127.2298649924390367.22293397652515503513(G$318/5)*$J$1760(H$318/5)*$J$176000000003514(G$323/5)*$J$1770(H$323/5)*$J$177000000003510(G$328)*$J$1820(H$328)*$J$182000000003515G$309*$F1656289.67849946761H$309*$F1657511.25769561574638559.20939949223258975.16454283818359476.82977324889369978.495003659600110480.16023407030810824.4336017550811210.1068143979993516G$311*$E1660H$311*$E16628.39298569338920364.70860670067405469.2668852906102974.631168938480480.153479536109785.83381708349821890.35833303462824595.343407778937731148SUM(F367:F374)0SUM(G367:G374)12881.88868963179413841.14866767239814729.88887917280215067.92780505457415477.54353421294215887.31729032106516297.24907337894916586.0400259989416909.475379409643683729Preferences.EnergyUnitsTWh7841844269169272072172272372472572672754INDEX(Vectors[Description], MATCH([Vector], Vectors[Code], 0))Waste-(F257+F258+F270+F285+F303)-58.756794246200883-(G257+G258+G270+G285+G303)-81.498089679874937-101.27975396170582-111.65845051663788-117.38003048410576-122.98310691137831-128.38777630273069-133.45027145453298-134.05538692012794-134.3969832748450464INDEX(Vectors[Description], MATCH([Vector], Vectors[Code], 0))Coal and fossil wasteF$25826.003927322234723G$25841.44954894333340450.46932380772294451.96146174953981553.11787251429690654.27428327905397555.43069404381106656.58710480856814256.58710480856814256.587104808568142753INDEX(Vectors[Description], MATCH([Vector], Vectors[Code], 0))Dry biomass and wasteF$25710.480732039364923G$25716.70600022236509121.37332370668094923.00667680269879225.53667256335793228.06666832401706230.59666408467620333.12665984533533233.12665984533533233.126659845335332916INDEX(Vectors[Description], MATCH([Vector], Vectors[Code], 0))Wet biomass and wasteF$270+F$3033.9889383333333339G$270+G$3034.07067601264190779.909591016709109517.3427021451062818.51662902695355219.78461695347105121.13519656503585522.51431909512998423.595902593429424.8344093078189412219INDEX(Vectors[Description], MATCH([Vector], Vectors[Code], 0))Gaseous wasteF$28518.283196551267896G$28519.27186450153452719.52751543059280719.34760981929299520.20885637949736920.85753835483621921.22522160920756221.22218770549953620.74571967279509719.848809313122636148SUBTOTAL(109,[2007])0SUBTOTAL(109,[2010])0SUBTOTAL(109,[2015])0SUBTOTAL(109,[2020])0SUBTOTAL(109,[2025])0SUBTOTAL(109,[2030])0SUBTOTAL(109,[2035])0SUBTOTAL(109,[2040])0SUBTOTAL(109,[2045])2.8421709430404007E-14SUBTOTAL(109,[2050])0889105810611057102744269169272072172272372472572672710406INDEX(IPCC[Sector_description], MATCH([IPCC Sector], IPCC[Sector_code], 0))Waste0000000000000000000010416INDEX(IPCC[Sector_description], MATCH([IPCC Sector], IPCC[Sector_code], 0))WasteF282+F30021.671866768039205G282+G30021.38380511001496119.64728681349310317.84600654906406815.69286942026654513.70694573138481511.7852350204162399.95008754335852798.23912858365585346.625310213004828710426INDEX(IPCC[Sector_description], MATCH([IPCC Sector], IPCC[Sector_code], 0))WasteF2931.2492999999999999G2931.27489951401275951.31837295345152761.36299488505732011.40654645056664411.44605283541567561.48093734503796771.51320861648434551.5440083804208421.5733701984796546148SUBTOTAL(109,[2007])22.921166768039207SUBTOTAL(109,[2010])22.65870462402772SUBTOTAL(109,[2015])20.965659766944633SUBTOTAL(109,[2020])19.209001434121387SUBTOTAL(109,[2025])17.099415870833191SUBTOTAL(109,[2030])15.152998566800491SUBTOTAL(109,[2035])13.266172365454207SUBTOTAL(109,[2040])11.463296159842873SUBTOTAL(109,[2045])9.7831369640766948SUBTOTAL(109,[2050])8.19868041148448332613261878261444269169272072172272372472572672726213077F33047.57747137931077275.83718813313892393.41995964359433997.229968071016884101.50567468760674105.78138130419656110.05708792078643114.33279453737626114.33279453737626114.3327945373762631893190784184426916927207217227237247257267273131INDEX(CostVectors[Description], MATCH(C415, CostVectors[Code], 0))Low estimate of capital costsF3420G34250.33907776653135465.8673629762242108.4740224964627113.42192238992861422.26309735422418364.8697568744627520003133INDEX(CostVectors[Description], MATCH(C416, CostVectors[Code], 0))Low estimate of operating costsF3640G3643514.45684879038393629.1826459723523757.51531809998693796.97536950711263845.11817608318423893.41900960901563941.87787008460653978.04108084981364018.46949283171943140INDEX(CostVectors[Description], MATCH(C417, CostVectors[Code], 0))High estimate of capital costsF3530G353242.48574902206451290.11667508981134419.93492046788856146.15812515559287170.11157245991026302.89098664787946114.70319982530688111.22939609713841116.063596426571723142INDEX(CostVectors[Description], MATCH(C418, CostVectors[Code], 0))High estimate of operating costsF3750G37512881.88868963179413841.14866767239814729.88887917280215067.92780505457415477.54353421294215887.31729032106516297.24907337894916586.0400259989416909.475379409643