679INDEX(Workstreams[Workstream], MATCH($A1, Workstreams[Code], 0))Transport906INDEX(Modules[Module], MATCH($A2, Modules[Code], 0))International aviation133782513361339XII.c.Scenario1133813831384133680442200720102015202020252030203520402045205019081091.3906301889727857E-32.5237878218254517E-22.2208666809577338E-27.2786179923405303E-36.6033165637391367E-33.7428983709044683E-33.3489826243737753E-5-2.7616914488856059E-3-2.8003607097931704E-32908109-1.0672076375201067E-32.2829099387620788E-21.81818305814343E-26.8958242599823638E-36.1507626371619661E-3-1.1001248402140451E-3-6.6299147006565473E-3-2.8780071185396938E-3-2.9200271210491069E-33908109-1.0672076375201067E-32.2829099387620788E-21.81818305814343E-26.8958242599823638E-36.1507626371619661E-3-1.1001248402140451E-3-6.6299147006565473E-3-2.8780071185396938E-3-2.9200271210491069E-34908109-4.0568342130253843E-32.0094879004418198E-21.4576863689122366E-25.3750971011798931E-33.513816953377713E-4-5.9930489601390802E-3-8.164153448232736E-3-1.2596674666792373E-2-1.3443694494282177E-2717109139113903532353313368044220072010201520202025203020352040204520501908109344801.13489624381398831.1450525932468278.02000194672501462.58709453314542449.89900166413565671.8957486907599609.53462301055630315.53983773722661021.545052463542908109344136.48062142357397567.53449624334466125.21407029894498299.46595911338537968.14943959028559935.27201896836592914.60260052094622185.49899982742651456.395399133913908109344136.48062142357397567.53449624334466125.21407029894498299.46595911338537968.14943959028559935.27201896836592914.60260052094622185.49899982742651456.395399133914908109342057.07735492958395026.8007977315459608.92333978938488739.62144826114525051.98474094225547595.23035719094577135.01433649519603127.18041238782629119.346488280573534329513368044220072010201520202025203020352040204520501908G29/64.8/10005.3210051681519106H29/64.8/10006.15480162118199387.22651265435102997.73862017121193188.37114041669234698.72950456402300479.25323355899707789.727091664162612610.200949769328142908G30/64.8/10005.31074815773801846.135301458275367.19329034059103387.6898065734431088.30197761480849298.64097642004580819.14991670679816429.601628070984990210.0533394351718239085.31074815773801846.135301458275367.19329034059103387.6898065734431088.30197761480849298.64097642004580819.14991670679816429.601628070984990210.0533394351718249085.27865860115632126.0960926049032647.09273029845353967.54227810876946248.10265408550836778.45054367835171238.90640454222986489.30751821624055259.70863189025124383535329713368044220072010201520202025203020352040204520501908G37*1000000000/XII.a!$J$233/10003.1300030400893593H37*1000000000/XII.a!$J$233/10003.620471541871761I37*1000000000/XII.a!$J$233/10004.2508897966770762J37*1000000000/XII.a!$J$233/10004.5521295124776069K37*1000000000/XII.a!$J$233/10004.9242002451131448L37*1000000000/XII.a!$J$233/10005.1350026847194137M37*1000000000/XII.a!$J$233/10005.4430785641159281N37*1000000000/XII.a!$J$233/10005.7218186259780079O37*1000000000/XII.a!$J$233/10006.00055868784008252908G38*1000000000/XII.a!$J$233/10003.1239695045517752H38*1000000000/XII.a!$J$233/10003.6090008578090353I38*1000000000/XII.a!$J$233/10004.231347259171196J38*1000000000/XII.a!$J$233/10004.5234156314371221K38*1000000000/XII.a!$J$233/10004.8835162440049951L38*1000000000/XII.a!$J$233/10005.0829273059092994M38*1000000000/XII.a!$J$233/10005.3823039451753916N38*1000000000/XII.a!$J$233/10005.6480165123441122O38*1000000000/XII.a!$J$233/10005.91372907951283463908G39*1000000000/XII.a!$J$233/10003.1239695045517752H39*1000000000/XII.a!$J$233/10003.6090008578090353I39*1000000000/XII.a!$J$233/10004.231347259171196J39*1000000000/XII.a!$J$233/10004.5234156314371221K39*1000000000/XII.a!$J$233/10004.8835162440049951L39*1000000000/XII.a!$J$233/10005.0829273059092994M39*1000000000/XII.a!$J$233/10005.3823039451753916N39*1000000000/XII.a!$J$233/10005.6480165123441122O39*1000000000/XII.a!$J$233/10005.91372907951283464908G40*1000000000/XII.a!$J$233/10003.1050932947978365H40*1000000000/XII.a!$J$233/10003.5859368264136848I40*1000000000/XII.a!$J$233/10004.1721942932079648J40*1000000000/XII.a!$J$233/10004.4366341816290964K40*1000000000/XII.a!$J$233/10004.7662671091225697L40*1000000000/XII.a!$J$233/10004.9709080460892432M40*1000000000/XII.a!$J$233/10005.2390614954293317N40*1000000000/XII.a!$J$233/10005.4750107154356193O40*1000000000/XII.a!$J$233/10005.71095993544190783536784907Preferences.EnergyUnitsTWh7880442200749908109-'2007 (Actual, frozen)'!$W$59152.991675414791337171091382317032223274317231732641703.55799999999741703.557999999997327526897.26611.78520000000003"Cost per Vehicle/Unit"Cost per Vehicle/UnitPreferences.moneyunits&" per veh/unit"£m per veh/unit33102632763318180117993176((E69/1000000000)*XII.a!$J$233*1000)*(kGBP)*Price200091.824744327012752((F69/1000000000)*XII.a!$J$233*1000)*(kGBP)*Price200091.824744327012752303177((E72/1000000000)*XII.a!$J$233*1000)*(kGBP)*Price20001.9756268780437261((F72/1000000000)*XII.a!$J$233*1000)*(kGBP)*Price20001.347055797326701944210932238127311909211532007201020152020202520302035204020452050136713851386INDEX(F$16:F$19, MATCH($E$8, $C$16:$C$19, 0))1.3906301889727857E-3INDEX(G$16:G$19, MATCH($E$8, $C$16:$C$19, 0))2.5237878218254517E-22.2208666809577338E-27.2786179923405303E-36.6033165637391367E-33.7428983709044683E-33.3489826243737753E-5-2.7616914488856059E-3-2.8003607097931704E-3835902Preferences.EnergyUnitsTWhF$58152.99167541479133F97*(1+F96)^(G$94-F$94)153.63082794362825G97*(1+G96)^(H$94-G$94)174.02097069883129194.2224288429754201.39443053847114208.13218382871563212.05653906435825212.09205012603269209.1795176408344206.26698515563612136810401061F$97*INDEX(EF[CO2], MATCH("V.04", EF[Vector], 0))38.247918853697833G$97*INDEX(EF[CO2], MATCH("V.04", EF[Vector], 0))38.407706985907062H$97*INDEX(EF[CO2], MATCH("V.04", EF[Vector], 0))43.505242674707823I$97*INDEX(EF[CO2], MATCH("V.04", EF[Vector], 0))48.555607210743851J$97*INDEX(EF[CO2], MATCH("V.04", EF[Vector], 0))50.348607634617785K$97*INDEX(EF[CO2], MATCH("V.04", EF[Vector], 0))52.033045957178906L$97*INDEX(EF[CO2], MATCH("V.04", EF[Vector], 0))53.014134766089562M$97*INDEX(EF[CO2], MATCH("V.04", EF[Vector], 0))53.023012531508172N$97*INDEX(EF[CO2], MATCH("V.04", EF[Vector], 0))52.294879410208601O$97*INDEX(EF[CO2], MATCH("V.04", EF[Vector], 0))51.5667462889090310411061F$97*INDEX(EF[CH4], MATCH("V.04", EF[Vector], 0))4.7618507979587513E-2G$97*INDEX(EF[CH4], MATCH("V.04", EF[Vector], 0))4.7817443573384216E-2H$97*INDEX(EF[CH4], MATCH("V.04", EF[Vector], 0))5.4163855382138699E-2I$97*INDEX(EF[CH4], MATCH("V.04", EF[Vector], 0))6.0451539291921062E-2J$97*INDEX(EF[CH4], MATCH("V.04", EF[Vector], 0))6.2683817741324602E-2K$97*INDEX(EF[CH4], MATCH("V.04", EF[Vector], 0))6.4780936803169833E-2L$97*INDEX(EF[CH4], MATCH("V.04", EF[Vector], 0))6.600238849716912E-2M$97*INDEX(EF[CH4], MATCH("V.04", EF[Vector], 0))6.6013441280068072E-2N$97*INDEX(EF[CH4], MATCH("V.04", EF[Vector], 0))6.5106918418538495E-2O$97*INDEX(EF[CH4], MATCH("V.04", EF[Vector], 0))6.4200395557008905E-210421061F$97*INDEX(EF[N2O], MATCH("V.04", EF[Vector], 0))0.68815843363024276G$97*INDEX(EF[N2O], MATCH("V.04", EF[Vector], 0))0.6910333495490516H$97*INDEX(EF[N2O], MATCH("V.04", EF[Vector], 0))0.7827484619032038I$97*INDEX(EF[N2O], MATCH("V.04", EF[Vector], 0))0.87361486856115123J$97*INDEX(EF[N2O], MATCH("V.04", EF[Vector], 0))0.90587462020701515K$97*INDEX(EF[N2O], MATCH("V.04", EF[Vector], 0))0.93618111719667674L$97*INDEX(EF[N2O], MATCH("V.04", EF[Vector], 0))0.95383291520886704M$97*INDEX(EF[N2O], MATCH("V.04", EF[Vector], 0))0.95399264440009379N$97*INDEX(EF[N2O], MATCH("V.04", EF[Vector], 0))0.94089203753715678O$97*INDEX(EF[N2O], MATCH("V.04", EF[Vector], 0))0.9277914306742197633296329713338262632763IF($E$8=1,G46,IF($E$8=2,G47,IF($E$8=3,G48,IF($E$8=4,G49))))3.1300030400893593IF($E$8=1,H46,IF($E$8=2,H47,IF($E$8=3,H48,IF($E$8=4,H49))))3.6204715418717614.25088979667707624.55212951247760694.92420024511314485.13500268471941375.44307856411592815.72181862597800796.0005586878400825438621410Preferences.moneyunits&"/yr, preceeding 5 years"£m/yr, preceeding 5 years1333826263276IF(G107>F107,((G107-F107)/5+F107/$I78)*$F78*1000,((G107-F107)*$F78*1000/5))11569.973616289235IF(H107>G107,((H107-G107)/5+G107/$I78)*$F78*1000,((H107-G107)*$F78*1000/5))18587.81991862367822659.22813583593618543.48093497779720766.33093338803218943.49030815550221375.14139321038621779.35689956253222632.531396701812538521410Preferences.moneyunits&"/yr, preceeding 5 years"£m/yr, preceeding 5 years1333826263276IF(G107>F107,((G107-F107)/5+F107/$I78)*$G78*1000,((G107-F107)*$G78*1000/5))11569.973616289235IF(H107>G107,((H107-G107)/5+G107/$I78)*$G78*1000,((H107-G107)*$G78*1000/5))18587.81991862367822659.22813583593618543.48093497779720766.33093338803218943.49030815550221375.14139321038621779.35689956253222632.531396701812638701410Preferences.moneyunits&"/yr, preceeding 5 years"£m/yr, preceeding 5 years1333826263276G107*1000*$F$78/XII.a!J2629580.3909632992672AVERAGE(G107:H107)*1000*$F$78/XII.a!$J$26210331.010042909636AVERAGE(H107:I107)*1000*$F$78/XII.a!$J$26212046.429040296331AVERAGE(I107:J107)*1000*$F$78/XII.a!$J$26213472.249956148087AVERAGE(J107:K107)*1000*$F$78/XII.a!$J$26214502.69261915389AVERAGE(K107:L107)*1000*$F$78/XII.a!$J$26215394.72895275687AVERAGE(L107:M107)*1000*$F$78/XII.a!$J$26216188.826769077885AVERAGE(M107:N107)*1000*$F$78/XII.a!$J$26217086.897165295977AVERAGE(N107:O107)*1000*$F$78/XII.a!$J$26217940.071662435344738711410Preferences.moneyunits&"/yr, preceeding 5 years"£m/yr, preceeding 5 years1333826263276G107*1000*$G$78/XII.a!J2629580.3909632992672AVERAGE(G107:H107)*1000*$G$78/XII.a!$J$26210331.010042909636AVERAGE(H107:I107)*1000*$G$78/XII.a!$J$26212046.429040296331AVERAGE(I107:J107)*1000*$G$78/XII.a!$J$26213472.249956148087AVERAGE(J107:K107)*1000*$G$78/XII.a!$J$26214502.69261915389AVERAGE(K107:L107)*1000*$G$78/XII.a!$J$26215394.72895275687AVERAGE(L107:M107)*1000*$G$78/XII.a!$J$26216188.826769077885AVERAGE(M107:N107)*1000*$G$78/XII.a!$J$26217086.897165295977AVERAGE(N107:O107)*1000*$G$78/XII.a!$J$26217940.071662435344833001410Preferences.moneyunits&"/yr, preceeding 5 years"£m/yr, preceeding 5 years1333826263276G107*1000*$F$796183.7181343591128AVERAGE(G107:H107)*1000*$F$796668.2095118366869AVERAGE(H107:I107)*1000*$F$797775.43651361566218695.74077755195149360.84588715093749936.615839936699610449.17081666472211028.83548967222711579.521847874516933031410Preferences.moneyunits&"/yr, preceeding 5 years"£m/yr, preceeding 5 years1333826263276G107*1000*$G$794216.2887408025726AVERAGE(G107:H107)*1000*$G$794546.6329601686357AVERAGE(H107:I107)*1000*$G$795301.58146197273985929.07909718785696382.57246867108016775.15381155834627124.63283541826337519.86974323632067895.34815951483423858387231833176Preferences.moneyunits&"/yr, preceeding 5 years"£m/yr, preceeding 5 yearsIF($F$145="C",(F119),(IF($F$145="A",(F131),0)))0IF($F$145="C",(G119),(IF($F$145="A",(G131),0)))11569.97361628923518587.81991862367822659.22813583593618543.48093497779720766.33093338803218943.49030815550221375.14139321038621779.35689956253222632.5313967018123177Preferences.moneyunits&"/yr, preceeding 5 years"£m/yr, preceeding 5 yearsF1430G1434216.28874080257264546.63296016863575301.58146197273985929.07909718785696382.57246867108016775.15381155834627124.63283541826337519.86974323632067895.34815951483423184Preferences.moneyunits&"/yr, preceeding 5 years"£m/yr, preceeding 5 yearsSUM(F148:F149)0SUM(G148:G149)15786.26235709180823134.45287879231227960.80959780867524472.56003216565327148.90340205911325718.64411971384828499.77422862864829299.22664279885130527.87955621664531853176Preferences.moneyunits&"/yr, preceeding 5 years"£m/yr, preceeding 5 yearsIF($F$145="C",(F113),(IF($F$145="A",(F125),0)))0IF($F$145="C",(G113),(IF($F$145="A",(G125),0)))11569.97361628923518587.81991862367822659.22813583593618543.48093497779720766.33093338803218943.49030815550221375.14139321038621779.35689956253222632.5313967018123177Preferences.moneyunits&"/yr, preceeding 5 years"£m/yr, preceeding 5 yearsF1370G1376183.71813435911286668.20951183668697775.43651361566218695.74077755195149360.84588715093749936.615839936699610449.17081666472211028.83548967222711579.5218478745163184Preferences.moneyunits&"/yr, preceeding 5 years"£m/yr, preceeding 5 yearsSUM(F153:F154)0SUM(G153:G154)17753.69175064834825256.02943046036730434.66464945159927239.22171252974730127.17682053896728880.106148092231824.31220987510832808.19238923475534212.053244576324683729Preferences.EnergyUnitsTWh78418442691692720721722723724725726727953INDEX(Vectors[Description], MATCH([Vector], Vectors[Code], 0))International aviationF$97152.99167541479133G$97153.63082794362825174.02097069883129194.2224288429754201.39443053847114208.13218382871563212.05653906435825212.09205012603269209.1795176408344206.2669851556361249INDEX(Vectors[Description], MATCH([Vector], Vectors[Code], 0))Liquid hydrocarbons-F$97-152.99167541479133-G$97-153.63082794362825-174.02097069883129-194.2224288429754-201.39443053847114-208.13218382871563-212.05653906435825-212.09205012603269-209.1795176408344-206.26698515563612148SUBTOTAL(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])0SUBTOTAL(109,[2050])0889105810611057102744269169272072172272372472572672710401035INDEX(IPCC[Sector_description], MATCH([IPCC Sector], IPCC[Sector_code], 0))International Aviation and ShippingF$10038.247918853697833G$10038.40770698590706243.50524267470782348.55560721074385150.34860763461778552.03304595717890653.01413476608956253.02301253150817252.29487941020860151.5667462889090310411035INDEX(IPCC[Sector_description], MATCH([IPCC Sector], IPCC[Sector_code], 0))International Aviation and ShippingF$1014.7618507979587513E-2G$1014.7817443573384216E-25.4163855382138699E-26.0451539291921062E-26.2683817741324602E-26.4780936803169833E-26.600238849716912E-26.6013441280068072E-26.5106918418538495E-26.4200395557008905E-210421035INDEX(IPCC[Sector_description], MATCH([IPCC Sector], IPCC[Sector_code], 0))International Aviation and ShippingF$1020.68815843363024276G$1020.69103334954905160.78274846190320380.873614868561151230.905874620207015150.936181117196676740.953832915208867040.953992644400093790.940892037537156780.92779143067421976148SUBTOTAL(109,[2007])38.983695795307661SUBTOTAL(109,[2010])39.1465577790295SUBTOTAL(109,[2015])44.342154991993162SUBTOTAL(109,[2020])49.489673618596917SUBTOTAL(109,[2025])51.317166072566124SUBTOTAL(109,[2030])53.034008011178749SUBTOTAL(109,[2035])54.033970069795593SUBTOTAL(109,[2040])54.043018617188338SUBTOTAL(109,[2045])53.300878366164291SUBTOTAL(109,[2050])52.558738115140258261326187826144426916927207217227237247257267272615INDEX(Vectors[Description], MATCH([Vector], Vectors[Code], 0))UK Land areaINDEX(Vectors[Comment], MATCH([Information type], Vectors[Description], 0))02621INDEX(Vectors[Description], MATCH([Vector], Vectors[Code], 0))Number of units31893190784184426916927207217227237247257267273131INDEX(CostVectors[Description], MATCH(C194,CostVectors[Code], 0))Low estimate of capital costsF1500G14811569.97361628923518587.81991862367822659.22813583593618543.48093497779720766.33093338803218943.49030815550221375.14139321038621779.35689956253222632.5313967018123133INDEX(CostVectors[Description], MATCH(C195, CostVectors[Code], 0))Low estimate of operating costs04216.28874080257264546.63296016863575301.58146197273985929.07909718785696382.57246867108016775.15381155834627124.63283541826337519.86974323632067895.34815951483423135INDEX(CostVectors[Description], MATCH(C196, CostVectors[Code], 0))Low estimate of fuel costs03140INDEX(CostVectors[Description], MATCH(C197, CostVectors[Code], 0))High estimate of capital costs011569.97361628923518587.81991862367822659.22813583593618543.48093497779720766.33093338803218943.49030815550221375.14139321038621779.35689956253222632.5313967018123142INDEX(CostVectors[Description], MATCH(C198, CostVectors[Code], 0))High estimate of operating costs06183.71813435911286668.20951183668697775.43651361566218695.74077755195149360.84588715093749936.615839936699610449.17081666472211028.83548967222711579.5218478745163144INDEX(CostVectors[Description], MATCH(C199, CostVectors[Code], 0))High estimate of fuel costs0