671INDEX(Workstreams[Workstream], MATCH($A1, Workstreams[Code], 0))Bioenergy
951INDEX(Modules[Module], MATCH($A2, Modules[Code], 0))Biomass to fuel conversion
1345
|
8261340
1445V.a.Scenario1
|
682
|
1523Preferences.EnergyUnitsTWh
|
78418442691692720721722723724725726727
753INDEX(Vectors[Description], MATCH(V.a.Inputs[Vector], Vectors[Code], 0))Dry biomass and wasteINDEX(INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH(V.a.Inputs[Vector], INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Vectors"), 0))12.989770861364923INDEX(INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH(V.a.Inputs[Vector], INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Vectors"), 0))17.830409171827863INDEX(INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH(V.a.Inputs[Vector], INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Vectors"), 0))26.833763472338909INDEX(INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH(V.a.Inputs[Vector], INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Vectors"), 0))33.885495872527606INDEX(INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH(V.a.Inputs[Vector], INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Vectors"), 0))38.618495962392657INDEX(INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH(V.a.Inputs[Vector], INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Vectors"), 0))43.757658675884699INDEX(INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH(V.a.Inputs[Vector], INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Vectors"), 0))49.33209885822594INDEX(INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH(V.a.Inputs[Vector], INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Vectors"), 0))55.372844808678927INDEX(INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH(V.a.Inputs[Vector], INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Vectors"), 0))57.975529172332465INDEX(INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH(V.a.Inputs[Vector], INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Vectors"), 0))60.711104428996428
917INDEX(Vectors[Description], MATCH(V.a.Inputs[Vector], Vectors[Code], 0))Wet biomass and wasteINDEX(INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH(V.a.Inputs[Vector], INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Vectors"), 0))4.9610477000000008INDEX(INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH(V.a.Inputs[Vector], INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Vectors"), 0))9.0374131886335825INDEX(INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH(V.a.Inputs[Vector], INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Vectors"), 0))14.507287208653445INDEX(INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH(V.a.Inputs[Vector], INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Vectors"), 0))35.073651983418543INDEX(INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH(V.a.Inputs[Vector], INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Vectors"), 0))45.722382116955998INDEX(INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH(V.a.Inputs[Vector], INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Vectors"), 0))47.555173164237623INDEX(INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH(V.a.Inputs[Vector], INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Vectors"), 0))49.44571838275067INDEX(INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH(V.a.Inputs[Vector], INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Vectors"), 0))51.40359658872984INDEX(INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH(V.a.Inputs[Vector], INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Vectors"), 0))53.435760519195469INDEX(INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH(V.a.Inputs[Vector], INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Vectors"), 0))55.54577301581314
2241INDEX(Vectors[Description], MATCH(V.a.Inputs[Vector], Vectors[Code], 0))Gaseous wasteINDEX(INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH(V.a.Inputs[Vector], INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Vectors"), 0))18.283196551267896INDEX(INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH(V.a.Inputs[Vector], INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Vectors"), 0))18.397138633862209INDEX(INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH(V.a.Inputs[Vector], INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Vectors"), 0))18.090473221244544INDEX(INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH(V.a.Inputs[Vector], INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Vectors"), 0))17.426885093820637INDEX(INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH(V.a.Inputs[Vector], INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Vectors"), 0))16.987273382270043INDEX(INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH(V.a.Inputs[Vector], INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Vectors"), 0))16.949513130720788INDEX(INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH(V.a.Inputs[Vector], INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Vectors"), 0))17.17420033669308INDEX(INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH(V.a.Inputs[Vector], INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Vectors"), 0))17.575536884393671INDEX(INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH(V.a.Inputs[Vector], INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Vectors"), 0))18.128502892916249INDEX(INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH(V.a.Inputs[Vector], INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Vectors"), 0))18.806405883014129
1780INDEX(Vectors[Description], MATCH(V.a.Inputs[Vector], Vectors[Code], 0))Energy crops (second generation)INDEX(INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH(V.a.Inputs[Vector], INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Vectors"), 0))0.82222222222222219INDEX(INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH(V.a.Inputs[Vector], INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Vectors"), 0))2.1745613358072911INDEX(INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH(V.a.Inputs[Vector], INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Vectors"), 0))3.7746507476374456INDEX(INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH(V.a.Inputs[Vector], INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Vectors"), 0))5.4145997165903523INDEX(INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH(V.a.Inputs[Vector], INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Vectors"), 0))7.0951571998602567INDEX(INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH(V.a.Inputs[Vector], INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Vectors"), 0))8.8170846817765227INDEX(INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH(V.a.Inputs[Vector], INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Vectors"), 0))10.581156370351131INDEX(INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH(V.a.Inputs[Vector], INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Vectors"), 0))12.388159396787486INDEX(INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH(V.a.Inputs[Vector], INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Vectors"), 0))14.238894017993857INDEX(INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH(V.a.Inputs[Vector], INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Vectors"), 0))16.134173822145531
2238INDEX(Vectors[Description], MATCH(V.a.Inputs[Vector], Vectors[Code], 0))Energy crops (first generation)INDEX(INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH(V.a.Inputs[Vector], INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Vectors"), 0))4.0592999999999995INDEX(INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH(V.a.Inputs[Vector], INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Vectors"), 0))0.85335261669041207INDEX(INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH(V.a.Inputs[Vector], INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Vectors"), 0))0.91819449083958382INDEX(INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH(V.a.Inputs[Vector], INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Vectors"), 0))0.98796336534118079INDEX(INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH(V.a.Inputs[Vector], INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Vectors"), 0))1.0630336175985615INDEX(INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH(V.a.Inputs[Vector], INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Vectors"), 0))1.1438080720274875INDEX(INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH(V.a.Inputs[Vector], INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Vectors"), 0))1.2307201615982166INDEX(INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH(V.a.Inputs[Vector], INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Vectors"), 0))1.3242362536220502INDEX(INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH(V.a.Inputs[Vector], INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Vectors"), 0))1.4248581522624368INDEX(INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH(V.a.Inputs[Vector], INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Vectors"), 0))1.5331257911990155
|
1212Preferences.EnergyUnitsTWh
|
78418442691692720721722723724725726727
47INDEX(Vectors[Description], MATCH(V.a.Inputs2[Vector], Vectors[Code], 0))Solid hydrocarbonsINDEX(INDIRECT("'"&V.a.Inputs2[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&V.a.Inputs2[#Headers]&"'!Year.Modules"), 0), MATCH(V.a.Inputs2[Vector], INDIRECT("'"&V.a.Inputs2[#Headers]&"'!Year.Vectors"), 0))-489.16767952103856INDEX(INDIRECT("'"&V.a.Inputs2[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&V.a.Inputs2[#Headers]&"'!Year.Modules"), 0), MATCH(V.a.Inputs2[Vector], INDIRECT("'"&V.a.Inputs2[#Headers]&"'!Year.Vectors"), 0))-505.46833220752944INDEX(INDIRECT("'"&V.a.Inputs2[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&V.a.Inputs2[#Headers]&"'!Year.Modules"), 0), MATCH(V.a.Inputs2[Vector], INDIRECT("'"&V.a.Inputs2[#Headers]&"'!Year.Vectors"), 0))-448.25143932751371INDEX(INDIRECT("'"&V.a.Inputs2[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&V.a.Inputs2[#Headers]&"'!Year.Modules"), 0), MATCH(V.a.Inputs2[Vector], INDIRECT("'"&V.a.Inputs2[#Headers]&"'!Year.Vectors"), 0))-360.50948091227883INDEX(INDIRECT("'"&V.a.Inputs2[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&V.a.Inputs2[#Headers]&"'!Year.Modules"), 0), MATCH(V.a.Inputs2[Vector], INDIRECT("'"&V.a.Inputs2[#Headers]&"'!Year.Vectors"), 0))-225.99380884648835INDEX(INDIRECT("'"&V.a.Inputs2[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&V.a.Inputs2[#Headers]&"'!Year.Modules"), 0), MATCH(V.a.Inputs2[Vector], INDIRECT("'"&V.a.Inputs2[#Headers]&"'!Year.Vectors"), 0))-117.56086729355422INDEX(INDIRECT("'"&V.a.Inputs2[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&V.a.Inputs2[#Headers]&"'!Year.Modules"), 0), MATCH(V.a.Inputs2[Vector], INDIRECT("'"&V.a.Inputs2[#Headers]&"'!Year.Vectors"), 0))-97.918106676416102INDEX(INDIRECT("'"&V.a.Inputs2[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&V.a.Inputs2[#Headers]&"'!Year.Modules"), 0), MATCH(V.a.Inputs2[Vector], INDIRECT("'"&V.a.Inputs2[#Headers]&"'!Year.Vectors"), 0))-97.956040254330162INDEX(INDIRECT("'"&V.a.Inputs2[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&V.a.Inputs2[#Headers]&"'!Year.Modules"), 0), MATCH(V.a.Inputs2[Vector], INDIRECT("'"&V.a.Inputs2[#Headers]&"'!Year.Vectors"), 0))-97.876850389669329INDEX(INDIRECT("'"&V.a.Inputs2[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&V.a.Inputs2[#Headers]&"'!Year.Modules"), 0), MATCH(V.a.Inputs2[Vector], INDIRECT("'"&V.a.Inputs2[#Headers]&"'!Year.Vectors"), 0))-98.048601468970205
49INDEX(Vectors[Description], MATCH(V.a.Inputs2[Vector], Vectors[Code], 0))Liquid hydrocarbonsINDEX(INDIRECT("'"&V.a.Inputs2[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&V.a.Inputs2[#Headers]&"'!Year.Modules"), 0), MATCH(V.a.Inputs2[Vector], INDIRECT("'"&V.a.Inputs2[#Headers]&"'!Year.Vectors"), 0))-880.75509612393364INDEX(INDIRECT("'"&V.a.Inputs2[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&V.a.Inputs2[#Headers]&"'!Year.Modules"), 0), MATCH(V.a.Inputs2[Vector], INDIRECT("'"&V.a.Inputs2[#Headers]&"'!Year.Vectors"), 0))-871.48134106524276INDEX(INDIRECT("'"&V.a.Inputs2[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&V.a.Inputs2[#Headers]&"'!Year.Modules"), 0), MATCH(V.a.Inputs2[Vector], INDIRECT("'"&V.a.Inputs2[#Headers]&"'!Year.Vectors"), 0))-861.56932977985548INDEX(INDIRECT("'"&V.a.Inputs2[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&V.a.Inputs2[#Headers]&"'!Year.Modules"), 0), MATCH(V.a.Inputs2[Vector], INDIRECT("'"&V.a.Inputs2[#Headers]&"'!Year.Vectors"), 0))-865.16771942191258INDEX(INDIRECT("'"&V.a.Inputs2[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&V.a.Inputs2[#Headers]&"'!Year.Modules"), 0), MATCH(V.a.Inputs2[Vector], INDIRECT("'"&V.a.Inputs2[#Headers]&"'!Year.Vectors"), 0))-841.5569686649676INDEX(INDIRECT("'"&V.a.Inputs2[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&V.a.Inputs2[#Headers]&"'!Year.Modules"), 0), MATCH(V.a.Inputs2[Vector], INDIRECT("'"&V.a.Inputs2[#Headers]&"'!Year.Vectors"), 0))-816.69421935495359INDEX(INDIRECT("'"&V.a.Inputs2[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&V.a.Inputs2[#Headers]&"'!Year.Modules"), 0), MATCH(V.a.Inputs2[Vector], INDIRECT("'"&V.a.Inputs2[#Headers]&"'!Year.Vectors"), 0))-822.68715594918547INDEX(INDIRECT("'"&V.a.Inputs2[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&V.a.Inputs2[#Headers]&"'!Year.Modules"), 0), MATCH(V.a.Inputs2[Vector], INDIRECT("'"&V.a.Inputs2[#Headers]&"'!Year.Vectors"), 0))-825.15156499689749INDEX(INDIRECT("'"&V.a.Inputs2[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&V.a.Inputs2[#Headers]&"'!Year.Modules"), 0), MATCH(V.a.Inputs2[Vector], INDIRECT("'"&V.a.Inputs2[#Headers]&"'!Year.Vectors"), 0))-832.03402930661468INDEX(INDIRECT("'"&V.a.Inputs2[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&V.a.Inputs2[#Headers]&"'!Year.Modules"), 0), MATCH(V.a.Inputs2[Vector], INDIRECT("'"&V.a.Inputs2[#Headers]&"'!Year.Vectors"), 0))-841.7779403654838
50INDEX(Vectors[Description], MATCH(V.a.Inputs2[Vector], Vectors[Code], 0))Gaseous hydrocarbonsINDEX(INDIRECT("'"&V.a.Inputs2[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&V.a.Inputs2[#Headers]&"'!Year.Modules"), 0), MATCH(V.a.Inputs2[Vector], INDIRECT("'"&V.a.Inputs2[#Headers]&"'!Year.Vectors"), 0))-983.32460927907118INDEX(INDIRECT("'"&V.a.Inputs2[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&V.a.Inputs2[#Headers]&"'!Year.Modules"), 0), MATCH(V.a.Inputs2[Vector], INDIRECT("'"&V.a.Inputs2[#Headers]&"'!Year.Vectors"), 0))-999.14982950000808INDEX(INDIRECT("'"&V.a.Inputs2[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&V.a.Inputs2[#Headers]&"'!Year.Modules"), 0), MATCH(V.a.Inputs2[Vector], INDIRECT("'"&V.a.Inputs2[#Headers]&"'!Year.Vectors"), 0))-1070.3857558228669INDEX(INDIRECT("'"&V.a.Inputs2[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&V.a.Inputs2[#Headers]&"'!Year.Modules"), 0), MATCH(V.a.Inputs2[Vector], INDIRECT("'"&V.a.Inputs2[#Headers]&"'!Year.Vectors"), 0))-1177.360541712306INDEX(INDIRECT("'"&V.a.Inputs2[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&V.a.Inputs2[#Headers]&"'!Year.Modules"), 0), MATCH(V.a.Inputs2[Vector], INDIRECT("'"&V.a.Inputs2[#Headers]&"'!Year.Vectors"), 0))-1321.5969086005739INDEX(INDIRECT("'"&V.a.Inputs2[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&V.a.Inputs2[#Headers]&"'!Year.Modules"), 0), MATCH(V.a.Inputs2[Vector], INDIRECT("'"&V.a.Inputs2[#Headers]&"'!Year.Vectors"), 0))-1464.2402240204631INDEX(INDIRECT("'"&V.a.Inputs2[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&V.a.Inputs2[#Headers]&"'!Year.Modules"), 0), MATCH(V.a.Inputs2[Vector], INDIRECT("'"&V.a.Inputs2[#Headers]&"'!Year.Vectors"), 0))-1572.8394229016217INDEX(INDIRECT("'"&V.a.Inputs2[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&V.a.Inputs2[#Headers]&"'!Year.Modules"), 0), MATCH(V.a.Inputs2[Vector], INDIRECT("'"&V.a.Inputs2[#Headers]&"'!Year.Vectors"), 0))-1659.5883784426323INDEX(INDIRECT("'"&V.a.Inputs2[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&V.a.Inputs2[#Headers]&"'!Year.Modules"), 0), MATCH(V.a.Inputs2[Vector], INDIRECT("'"&V.a.Inputs2[#Headers]&"'!Year.Vectors"), 0))-1748.7086516484785INDEX(INDIRECT("'"&V.a.Inputs2[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&V.a.Inputs2[#Headers]&"'!Year.Modules"), 0), MATCH(V.a.Inputs2[Vector], INDIRECT("'"&V.a.Inputs2[#Headers]&"'!Year.Vectors"), 0))-1814.5418124379926
|
|
|
1342
|
15241445
|
1447178217831234
753INDEX(Vectors[Description], MATCH($C35, Vectors[Code], 0))Dry biomass and waste14431100
753INDEX(Vectors[Description], MATCH($C36, Vectors[Code], 0))Dry biomass and waste2300010
753INDEX(Vectors[Description], MATCH($C37, Vectors[Code], 0))Dry biomass and waste140001
917INDEX(Vectors[Description], MATCH($C38, Vectors[Code], 0))Wet biomass and waste14430000
917INDEX(Vectors[Description], MATCH($C39, Vectors[Code], 0))Wet biomass and waste2300010
917INDEX(Vectors[Description], MATCH($C40, Vectors[Code], 0))Wet biomass and waste141101
1780INDEX(Vectors[Description], MATCH($C41, Vectors[Code], 0))Energy crops (second generation)14430100
1780INDEX(Vectors[Description], MATCH($C42, Vectors[Code], 0))Energy crops (second generation)2301010
1780INDEX(Vectors[Description], MATCH($C43, Vectors[Code], 0))Energy crops (second generation)140001
2238INDEX(Vectors[Description], MATCH($C44, Vectors[Code], 0))Energy crops (first generation)14430000
2238INDEX(Vectors[Description], MATCH($C45, Vectors[Code], 0))Energy crops (first generation)2301111
2238INDEX(Vectors[Description], MATCH($C46, Vectors[Code], 0))Energy crops (first generation)140000
2241INDEX(Vectors[Description], MATCH($C47, Vectors[Code], 0))Gaseous waste14430000
2241INDEX(Vectors[Description], MATCH($C48, Vectors[Code], 0))Gaseous waste2300000
2241INDEX(Vectors[Description], MATCH($C49, Vectors[Code], 0))Gaseous waste141111
|
|
|
717
2467
2244
1696
|
|
784
|
25601526
|
INDEX(Vectors[Description], MATCH(G$64, Vectors[Code], 0))Wet biomass and wasteINDEX(Vectors[Description], MATCH(H$64, Vectors[Code], 0))Dry biomass and wasteINDEX(Vectors[Description], MATCH(I$64, Vectors[Code], 0))Energy crops (second generation)INDEX(Vectors[Description], MATCH(J$64, Vectors[Code], 0))Energy crops (first generation)INDEX(Vectors[Description], MATCH(K$64, Vectors[Code], 0))Gaseous waste
715794421525917753178022382241
47INDEX(Vectors[Description], MATCH($C65, Vectors[Code], 0))Solid hydrocarbons4390.90.9
49INDEX(Vectors[Description], MATCH($C66, Vectors[Code], 0))Liquid hydrocarbons0.3180.370.370.31
50INDEX(Vectors[Description], MATCH($C67, Vectors[Code], 0))Gaseous hydrocarbons14340.750.584999999999999960.584999999999999961
|
717
1091527
4391528
14341529
|
25591526
|
1462146122372243136
715794421525917753178022382241
47624390.950.95
49630.382000000000000010.450.450.316
5062714340.850.662000000000000030.662000000000000031
|
717
4391528
14341529
|
|
813
|
|
|
|
731
11530
21531
31784
42245
51652
61533
2007201020152020202520302035204020452050
|
11653
753INDEX(Vectors[Description], MATCH($C102, Vectors[Code], 0))Dry biomass and wastePreferences.EnergyUnitsTWhF$1512.98977086136492317.83040917182786326.83376347233890933.88549587252760638.61849596239265743.75765867588469949.3320988582259455.37284480867892757.97552917233246560.711104428996428
83417851443SUMIFS(INDEX($F$35:$I$49, , MATCH($E$7, $F$34:$I$34, 0)), $C$35:$C$49, $C$102, $E$35:$E$49, D103 )1
8341532INDEX($H$65:$H$67, MATCH($C105, $C$65:$C$67, 0))0.9INDEX($H$65:$H$67, MATCH($C105, $C$65:$C$67, 0))0.9INDEX($H$65:$H$67, MATCH($C105, $C$65:$C$67, 0))0.9INDEX($H$65:$H$67, MATCH($C105, $C$65:$C$67, 0))0.9INDEX($H$78:$H$80, MATCH($C105, $C$78:$C$80, 0))0.950.950.950.950.950.95
83647INDEX(Vectors[Description], MATCH($C105, Vectors[Code], 0))Solid hydrocarbonsPreferences.EnergyUnitsTWhF$102*$F103*F$10411.69079377522843G$102*$F103*G$10416.04736825464507924.1503871251050230.49694628527484536.68757116427302441.56977574209046446.86549391531464452.60420256824497955.076752713715841O$102*$F103*O$10457.675549207546602
|
8341785230SUMIFS(INDEX($F$35:$I$49, , MATCH($E$7, $F$34:$I$34, 0)), $C$35:$C$49, $C$102, $E$35:$E$49, D107 )0
8341532INDEX($H$65:$H$67, MATCH($C109, $C$65:$C$67, 0))0.37INDEX($H$65:$H$67, MATCH($C109, $C$65:$C$67, 0))0.37INDEX($H$65:$H$67, MATCH($C109, $C$65:$C$67, 0))0.37INDEX($H$65:$H$67, MATCH($C109, $C$65:$C$67, 0))0.37INDEX($H$78:$H$80, MATCH($C109, $C$78:$C$80, 0))0.450.450.450.450.450.45
83649INDEX(Vectors[Description], MATCH($C109, Vectors[Code], 0))Liquid hydrocarbonsPreferences.EnergyUnitsTWhF$102*$F107*F1080G$102*$F107*G108000000000
|
834178514SUMIFS(INDEX($F$35:$I$49, , MATCH($E$7, $F$34:$I$34, 0)), $C$35:$C$49, $C$102, $E$35:$E$49, D111 )0
8341532INDEX($H$65:$H$67, MATCH($C113, $C$65:$C$67, 0))0.58499999999999996INDEX($H$65:$H$67, MATCH($C113, $C$65:$C$67, 0))0.58499999999999996INDEX($H$65:$H$67, MATCH($C113, $C$65:$C$67, 0))0.58499999999999996INDEX($H$65:$H$67, MATCH($C113, $C$65:$C$67, 0))0.58499999999999996INDEX($H$78:$H$80, MATCH($C113, $C$78:$C$80, 0))0.662000000000000030.662000000000000030.662000000000000030.662000000000000030.662000000000000030.66200000000000003
83650INDEX(Vectors[Description], MATCH($C113, Vectors[Code], 0))Gaseous hydrocarbonsPreferences.EnergyUnitsTWhF$102*$F111*F1120000000000
|
21654
917INDEX(Vectors[Description], MATCH($C116, Vectors[Code], 0))Wet biomass and wastePreferences.EnergyUnitsTWhF$164.96104770000000089.037413188633582514.50728720865344535.07365198341854345.72238211695599847.55517316423762349.4457183827506751.4035965887298453.43576051919546955.54577301581314
83417851443SUMIFS(INDEX($F$35:$I$49, , MATCH($E$7, $F$34:$I$34, 0)), $C$35:$C$49, $C$116, $E$35:$E$49, D117 )0
8341532INDEX($G$65:$G$67, MATCH($C119, $C$65:$C$67, 0))0INDEX($G$65:$G$67, MATCH($C119, $C$65:$C$67, 0))0INDEX($G$65:$G$67, MATCH($C119, $C$65:$C$67, 0))0INDEX($G$65:$G$67, MATCH($C119, $C$65:$C$67, 0))0INDEX($G$78:$G$80, MATCH($C119, $C$78:$C$80, 0))000000
83647INDEX(Vectors[Description], MATCH($C119, Vectors[Code], 0))Solid hydrocarbonsPreferences.EnergyUnitsTWhF$116*$F117*F1180G$116*$F117*G118000000000
|
8341785230SUMIFS(INDEX($F$35:$I$49, , MATCH($E$7, $F$34:$I$34, 0)), $C$35:$C$49, $C$116, $E$35:$E$49, D121 )0
8341532INDEX($G$65:$G$67, MATCH($C123, $C$65:$C$67, 0))0.318INDEX($G$65:$G$67, MATCH($C123, $C$65:$C$67, 0))0.318INDEX($G$65:$G$67, MATCH($C123, $C$65:$C$67, 0))0.318INDEX($G$65:$G$67, MATCH($C123, $C$65:$C$67, 0))0.318INDEX($G$78:$G$80, MATCH($C123, $C$78:$C$80, 0))0.382000000000000010.382000000000000010.382000000000000010.382000000000000010.382000000000000010.38200000000000001
83649INDEX(Vectors[Description], MATCH($C123, Vectors[Code], 0))Liquid hydrocarbonsPreferences.EnergyUnitsTWhF$116*$F121*F1220000000000
|
834178514SUMIFS(INDEX($F$35:$I$49, , MATCH($E$7, $F$34:$I$34, 0)), $C$35:$C$49, $C$116, $E$35:$E$49, D125 )1
8341532INDEX($G$65:$G$67, MATCH($C127, $C$65:$C$67, 0))0.75INDEX($G$65:$G$67, MATCH($C127, $C$65:$C$67, 0))0.75INDEX($G$65:$G$67, MATCH($C127, $C$65:$C$67, 0))0.75INDEX($G$65:$G$67, MATCH($C127, $C$65:$C$67, 0))0.75INDEX($G$78:$G$80, MATCH($C127, $C$78:$C$80, 0))0.850.850.850.850.850.85
83650INDEX(Vectors[Description], MATCH($C127, Vectors[Code], 0))Gaseous hydrocarbonsPreferences.EnergyUnitsTWhF$116*$F125*F1263.72078577500000046.778059891475186810.88046540649008326.30523898756390738.86402479941259740.42189718960197842.02886062533806943.69305710042036145.4203964413161547.213907063441169
|
31786
1780INDEX(Vectors[Description], MATCH($C130, Vectors[Code], 0))Energy crops (second generation)Preferences.EnergyUnitsTWhF$180.82222222222222219G$182.1745613358072911H$183.77465074763744565.41459971659035237.09515719986025678.817084681776522710.58115637035113112.38815939678748614.23889401799385716.134173822145531
83417851443SUMIFS(INDEX($F$35:$I$49, , MATCH($E$7, $F$34:$I$34, 0)), $C$35:$C$49, $C$130, $E$35:$E$49, D131 )0
8341532INDEX($I$65:$I$67, MATCH($C133, $C$65:$C$67, 0))0.9INDEX($I$65:$I$67, MATCH($C133, $C$65:$C$67, 0))0.9INDEX($I$65:$I$67, MATCH($C133, $C$65:$C$67, 0))0.9INDEX($I$65:$I$67, MATCH($C133, $C$65:$C$67, 0))0.9INDEX($I$78:$I$80, MATCH($C133, $C$78:$C$80, 0))0.950.950.950.950.950.95
83647INDEX(Vectors[Description], MATCH($C133, Vectors[Code], 0))Solid hydrocarbonsPreferences.EnergyUnitsTWhF$130*$F131*F1320G$130*$F131*G132000000000
|
8341785230SUMIFS(INDEX($F$35:$I$49, , MATCH($E$7, $F$34:$I$34, 0)), $C$35:$C$49, $C$130, $E$35:$E$49, D135 )1
8341532INDEX($I$65:$I$67, MATCH($C137, $C$65:$C$67, 0))0.37INDEX($I$65:$I$67, MATCH($C137, $C$65:$C$67, 0))0.37INDEX($I$65:$I$67, MATCH($C137, $C$65:$C$67, 0))0.37INDEX($I$65:$I$67, MATCH($C137, $C$65:$C$67, 0))0.37INDEX($I$78:$I$80, MATCH($C137, $C$78:$C$80, 0))0.450.450.450.450.450.45
83649INDEX(Vectors[Description], MATCH($C137, Vectors[Code], 0))Liquid hydrocarbonsPreferences.EnergyUnitsTWhF$130*$F135*F1360.304222222222222230.804587694248697691.39662077662585492.00340189513843033.19282073993711583.96768810679943544.76152036665800885.57467172855436926.40750230809723587.2603782199654887
|
834178514SUMIFS(INDEX($F$35:$I$49, , MATCH($E$7, $F$34:$I$34, 0)), $C$35:$C$49, $C$130, $E$35:$E$49, D139 )0
8341532INDEX($I$65:$I$67, MATCH($C141, $C$65:$C$67, 0))0.58499999999999996INDEX($I$65:$I$67, MATCH($C141, $C$65:$C$67, 0))0.58499999999999996INDEX($I$65:$I$67, MATCH($C141, $C$65:$C$67, 0))0.58499999999999996INDEX($I$65:$I$67, MATCH($C141, $C$65:$C$67, 0))0.58499999999999996INDEX($I$78:$I$80, MATCH($C141, $C$78:$C$80, 0))0.662000000000000030.662000000000000030.662000000000000030.662000000000000030.662000000000000030.66200000000000003
83650INDEX(Vectors[Description], MATCH($C141, Vectors[Code], 0))Gaseous hydrocarbonsPreferences.EnergyUnitsTWhF$130*$F139*F1400000000000
|
2238INDEX(Vectors[Description], MATCH($C143, Vectors[Code], 0))Energy crops (first generation)Preferences.EnergyUnitsTWhF$194.0592999999999995G$190.853352616690412070.918194490839583820.987963365341180791.06303361759856151.14380807202748751.23072016159821661.32423625362205021.42485815226243681.5331257911990155
83417851443SUMIFS(INDEX($F$35:$I$49, , MATCH($E$7, $F$34:$I$34, 0)), $C$35:$C$49, $C$143, $E$35:$E$49, D144 )0
8341532INDEX($J$65:$J$67, MATCH($C146, $C$65:$C$67, 0))0INDEX($J$65:$J$67, MATCH($C146, $C$65:$C$67, 0))0INDEX($J$65:$J$67, MATCH($C146, $C$65:$C$67, 0))0INDEX($J$65:$J$67, MATCH($C146, $C$65:$C$67, 0))0
83647INDEX(Vectors[Description], MATCH($C146, Vectors[Code], 0))Solid hydrocarbonsPreferences.EnergyUnitsTWhF$143*$F144*$F1450G$143*$F144*$F145000000000
|
8341785230SUMIFS(INDEX($F$35:$I$49, , MATCH($E$7, $F$34:$I$34, 0)), $C$35:$C$49, $C$143, $E$35:$E$49, D148 )1
8341532INDEX($J$65:$J$67, MATCH($C150, $C$65:$C$67, 0))0.31INDEX($J$65:$J$67, MATCH($C150, $C$65:$C$67, 0))0.31INDEX($J$65:$J$67, MATCH($C150, $C$65:$C$67, 0))0.31INDEX($J$65:$J$67, MATCH($C150, $C$65:$C$67, 0))0.31INDEX($J$78:$J$80, MATCH($C150, $C$78:$C$80, 0))0.3160.3160.3160.3160.3160.316
83649INDEX(Vectors[Description], MATCH($C150, Vectors[Code], 0))Liquid hydrocarbonsPreferences.EnergyUnitsTWhF$143*$F148*F1491.2583829999999998G$143*$F148*G1490.264539311174027740.284640292160270980.306268643255766030.335918623161145460.361443350760686070.388907571065036480.41845865614456790.45025517611493004O$143*$F148*O1490.48446775001888892
|
834178514SUMIFS(INDEX($F$35:$I$49, , MATCH($E$7, $F$34:$I$34, 0)), $C$35:$C$49, $C$143, $E$35:$E$49, D152 )0
8341532INDEX($J$65:$J$67, MATCH($C154, $C$65:$C$67, 0))0
83650INDEX(Vectors[Description], MATCH($C154, Vectors[Code], 0))Gaseous hydrocarbonsPreferences.EnergyUnitsTWhF$143*$F152*$F1530000000000
|
42246
2241INDEX(Vectors[Description], MATCH($C157, Vectors[Code], 0))Gaseous wastePreferences.EnergyUnitsTWhF$1718.283196551267896G$1718.39713863386220918.09047322124454417.42688509382063716.98727338227004316.94951313072078817.1742003366930817.57553688439367118.12850289291624918.806405883014129
83417851443SUMIFS(INDEX($F$35:$I$49, , MATCH($E$7, $F$34:$I$34, 0)), $C$35:$C$49, $C$157, $E$35:$E$49, D158 )0
8341532INDEX($K$65:$K$67, MATCH($C160, $C$65:$C$67, 0))0INDEX($K$65:$K$67, MATCH($C160, $C$65:$C$67, 0))0INDEX($K$65:$K$67, MATCH($C160, $C$65:$C$67, 0))0INDEX($K$65:$K$67, MATCH($C160, $C$65:$C$67, 0))0INDEX($K$78:$K$80, MATCH($C160, $C$78:$C$80, 0))000000
83647INDEX(Vectors[Description], MATCH($C160, Vectors[Code], 0))Solid hydrocarbonsPreferences.EnergyUnitsTWhF$157*$F158*F1590G$157*$F158*G1590000000000
|
8341785230SUMIFS(INDEX($F$35:$I$49, , MATCH($E$7, $F$34:$I$34, 0)), $C$35:$C$49, $C$157, $E$35:$E$49, D162 )0
8341532INDEX($K$65:$K$67, MATCH($C164, $C$65:$C$67, 0))0INDEX($K$65:$K$67, MATCH($C164, $C$65:$C$67, 0))0INDEX($K$65:$K$67, MATCH($C164, $C$65:$C$67, 0))0INDEX($K$65:$K$67, MATCH($C164, $C$65:$C$67, 0))0INDEX($K$78:$K$80, MATCH($C164, $C$78:$C$80, 0))000000
83649INDEX(Vectors[Description], MATCH($C164, Vectors[Code], 0))Liquid hydrocarbonsPreferences.EnergyUnitsTWhF$157*$F162*F1630000000000
|
834178514SUMIFS(INDEX($F$35:$I$49, , MATCH($E$7, $F$34:$I$34, 0)), $C$35:$C$49, $C$157, $E$35:$E$49, D166 )1
8341532INDEX($K$65:$K$67, MATCH($C168, $C$65:$C$67, 0))1INDEX($K$65:$K$67, MATCH($C168, $C$65:$C$67, 0))1INDEX($K$65:$K$67, MATCH($C168, $C$65:$C$67, 0))1INDEX($K$65:$K$67, MATCH($C168, $C$65:$C$67, 0))1INDEX($K$78:$K$80, MATCH($C168, $C$78:$C$80, 0))111111
83650INDEX(Vectors[Description], MATCH($C168, Vectors[Code], 0))Gaseous hydrocarbonsPreferences.EnergyUnitsTWhF$157*$F166*F16718.28319655126789618.39713863386220918.09047322124454417.42688509382063716.98727338227004316.94951313072078817.1742003366930817.57553688439367118.12850289291624918.806405883014129
|
|
51655
|
1656
47INDEX(Vectors[Description], MATCH($B174, Vectors[Code], 0))Solid hydrocarbonsPreferences.EnergyUnitsTWhF105+F119+F133+F146+F16011.69079377522843G105+G119+G133+G146+G16016.04736825464507924.1503871251050230.49694628527484536.68757116427302441.56977574209046446.86549391531464452.60420256824497955.07675271371584157.675549207546602
49INDEX(Vectors[Description], MATCH($B175, Vectors[Code], 0))Liquid hydrocarbonsPreferences.EnergyUnitsTWhF109+F123+F137+F150+F1621.562605222222222G109+G123+G137+G150+G1621.06912700542272531.68126106878612582.30967053839419643.52873936309826114.32913145756012165.15042793772304555.99313038469893746.85775748421216587.7448459699843779
50INDEX(Vectors[Description], MATCH($B176, Vectors[Code], 0))Gaseous hydrocarbonsPreferences.EnergyUnitsTWhF113+F127+F141+F154+F16822.003982326267895G113+G127+G141+G154+G16825.17519852533739728.97093862773462543.73212408138454155.85129818168263757.37141032032276759.20306096203114561.26859398481403263.54889933423240266.020312946455306
|
1658
47INDEX(Vectors[Description], MATCH($B179, Vectors[Code], 0))Solid hydrocarbonsPreferences.EnergyUnitsTWhMAX(MIN(F174, -F24),0)11.6907937752284316.04736825464507924.1503871251050230.49694628527484536.68757116427302441.56977574209046446.86549391531464452.60420256824497955.07675271371584157.675549207546602
49INDEX(Vectors[Description], MATCH($B180, Vectors[Code], 0))Liquid hydrocarbonsPreferences.EnergyUnitsTWhMAX(MIN(F175, -F25),0)1.5626052222222221.06912700542272531.68126106878612582.30967053839419643.52873936309826114.32913145756012165.15042793772304555.99313038469893746.85775748421216587.7448459699843779
50INDEX(Vectors[Description], MATCH($B181, Vectors[Code], 0))Gaseous hydrocarbonsPreferences.EnergyUnitsTWhMAX(MIN(F176, -F26),0)22.00398232626789525.17519852533739728.97093862773462543.73212408138454155.85129818168263757.37141032032276759.20306096203114561.26859398481403263.54889933423240266.020312946455306
|
78264726511252691692720721722723724725726727
47INDEX(Vectors[Description], MATCH($B184, Vectors[Code], 0))Solid hydrocarbonsPreferences.EnergyUnitsTWhF174-F1790G174-G17900000000O174-O1790
49INDEX(Vectors[Description], MATCH($B185, Vectors[Code], 0))Liquid hydrocarbonsPreferences.EnergyUnitsTWhF175-F1800000000000
50INDEX(Vectors[Description], MATCH($B186, Vectors[Code], 0))Gaseous hydrocarbonsPreferences.EnergyUnitsTWh0000000000
|
61659
|
16601064SUM(F$179:F$181*SUMIFS(EF[CO2], EF[Vector], $B$179:$B$181))8.0401485363592045SUM(G$179:G$181*SUMIFS(EF[CO2], EF[Vector], $B$179:$B$181))9.8421077024484447SUM(H$179:H$181*SUMIFS(EF[CO2], EF[Vector], $B$179:$B$181))13.189287209232045SUM(I$179:I$181*SUMIFS(EF[CO2], EF[Vector], $B$179:$B$181))18.017187921437952SUM(J$179:J$181*SUMIFS(EF[CO2], EF[Vector], $B$179:$B$181))22.45859562480026SUM(K$179:K$181*SUMIFS(EF[CO2], EF[Vector], $B$179:$B$181))24.442113291893278SUM(L$179:L$181*SUMIFS(EF[CO2], EF[Vector], $B$179:$B$181))26.615542327361396SUM(M$179:M$181*SUMIFS(EF[CO2], EF[Vector], $B$179:$B$181))28.973798280399969SUM(N$179:N$181*SUMIFS(EF[CO2], EF[Vector], $B$179:$B$181))30.37107668437628SUM(O$179:O$181*SUMIFS(EF[CO2], EF[Vector], $B$179:$B$181))31.848018230568222
|
683
|
729Preferences.EnergyUnitsTWh
|
78418442691692720721722723724725726727
47INDEX(Vectors[Description], MATCH(V.a.Outputs[Vector], Vectors[Code], 0))Solid hydrocarbonsF17411.6907937752284316.04736825464507924.1503871251050230.49694628527484536.68757116427302441.56977574209046446.86549391531464452.60420256824497955.076752713715841O17457.675549207546602
49INDEX(Vectors[Description], MATCH(V.a.Outputs[Vector], Vectors[Code], 0))Liquid hydrocarbonsF1751.5626052222222221.06912700542272531.68126106878612582.30967053839419643.52873936309826114.32913145756012165.15042793772304555.99313038469893746.85775748421216587.7448459699843779
50INDEX(Vectors[Description], MATCH(V.a.Outputs[Vector], Vectors[Code], 0))Gaseous hydrocarbonsF17622.00398232626789525.17519852533739728.97093862773462543.73212408138454155.85129818168263757.37141032032276759.20306096203114561.26859398481403263.54889933423240266.020312946455306
753INDEX(Vectors[Description], MATCH(V.a.Outputs[Vector], Vectors[Code], 0))Dry biomass and waste-F$15-12.989770861364923-G$15-17.830409171827863-26.833763472338909-33.885495872527606-38.618495962392657-43.757658675884699-49.33209885822594-55.372844808678927-57.975529172332465-60.711104428996428
917INDEX(Vectors[Description], MATCH(V.a.Outputs[Vector], Vectors[Code], 0))Wet biomass and waste-F$16-4.9610477000000008-9.0374131886335825-14.507287208653445-35.073651983418543-45.722382116955998-47.555173164237623-49.44571838275067-51.40359658872984-53.435760519195469-55.54577301581314
2241INDEX(Vectors[Description], MATCH(V.a.Outputs[Vector], Vectors[Code], 0))Gaseous waste-F17-18.283196551267896-G17-18.397138633862209-18.090473221244544-17.426885093820637-16.987273382270043-16.949513130720788-17.17420033669308-17.575536884393671-18.128502892916249-18.806405883014129
1780INDEX(Vectors[Description], MATCH(V.a.Outputs[Vector], Vectors[Code], 0))Energy crops (second generation)-F$18-0.82222222222222219-G$18-2.1745613358072911-3.7746507476374456-5.4145997165903523-7.0951571998602567-8.8170846817765227-10.581156370351131-12.388159396787486-14.238894017993857-16.134173822145531
2238INDEX(Vectors[Description], MATCH(V.a.Outputs[Vector], Vectors[Code], 0))Energy crops (first generation)-F$19-4.0592999999999995-G$19-0.85335261669041207-0.91819449083958382-0.98796336534118079-1.0630336175985615-1.1438080720274875-1.2307201615982166-1.3242362536220502-1.4248581522624368-1.5331257911990155
34INDEX(Vectors[Description], MATCH(V.a.Outputs[Vector], Vectors[Code], 0))Conversion lossesSUM(V.a.Inputs[2007])-SUM(F$174:F$176)5.8581560111364936SUM(V.a.Inputs[2010])-SUM(G$174:G$176)6.001181161416163SUM(V.a.Inputs[2015])-SUM(H$174:H$176)9.3217823190881575SUM(V.a.Inputs[2020])-SUM(I$174:I$176)16.249855126644746SUM(V.a.Inputs[2025])-SUM(J$174:J$176)13.418733570023591SUM(V.a.Inputs[2030])-SUM(K$174:K$176)14.952920204673759SUM(V.a.Inputs[2035])-SUM(L$174:L$176)16.544911294550189SUM(V.a.Inputs[2040])-SUM(M$174:M$176)18.198446994454017SUM(V.a.Inputs[2045])-SUM(N$174:N$176)19.72013522254008SUM(V.a.Inputs[2050])-SUM(O$174:O$176)21.289874817181953
148SUBTOTAL(109,V.a.Outputs[2007])0SUBTOTAL(109,V.a.Outputs[2010])0SUBTOTAL(109,V.a.Outputs[2015])0SUBTOTAL(109,V.a.Outputs[2020])0SUBTOTAL(109,V.a.Outputs[2025])0SUBTOTAL(109,V.a.Outputs[2030])0SUBTOTAL(109,V.a.Outputs[2035])0SUBTOTAL(109,V.a.Outputs[2040])0SUBTOTAL(109,V.a.Outputs[2045])0SUBTOTAL(109,V.a.Outputs[2050])-2.8421709430404007E-14
|
890
|
10611064
|
10601030442691692720721722723724725726727
10431039INDEX(IPCC[Sector_description], MATCH(V.a.Emissions[IPCC Sector], IPCC[Sector_code], 0))Bioenergy credit-SUM(F$190:F$191)-8.0401485363592045-9.8421077024484447-13.189287209232045-18.017187921437952-22.45859562480026-24.442113291893278-26.615542327361396-28.973798280399969-30.37107668437628-31.848018230568222
148SUBTOTAL(109,V.a.Emissions[2007])-8.0401485363592045SUBTOTAL(109,V.a.Emissions[2010])-9.8421077024484447SUBTOTAL(109,V.a.Emissions[2015])-13.189287209232045SUBTOTAL(109,V.a.Emissions[2020])-18.017187921437952SUBTOTAL(109,V.a.Emissions[2025])-22.45859562480026SUBTOTAL(109,V.a.Emissions[2030])-24.442113291893278SUBTOTAL(109,V.a.Emissions[2035])-26.615542327361396SUBTOTAL(109,V.a.Emissions[2040])-28.973798280399969SUBTOTAL(109,V.a.Emissions[2045])-30.37107668437628SUBTOTAL(109,V.a.Emissions[2050])-31.848018230568222
|
|
2702
|
2708
|
782703442691692720721722723724725726727
|
|
|