671INDEX(Workstreams[Workstream], MATCH($A1, Workstreams[Code], 0))Bioenergy950INDEX(Modules[Module], MATCH($A2, Modules[Code], 0))Types of fuel from Biomass3448134182513361439V.a.Scenario26821516Preferences.EnergyUnitsTWh78418442691692720721722723724725726727753INDEX(Vectors[Description], MATCH([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([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([Vector], INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Vectors"), 0))20.990032169565559INDEX(INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH([Vector], INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Vectors"), 0))29.682592375723239INDEX(INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH([Vector], INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Vectors"), 0))58.762326635613924INDEX(INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH([Vector], INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Vectors"), 0))92.782505569121923INDEX(INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH([Vector], INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Vectors"), 0))103.53152234974949INDEX(INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH([Vector], INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Vectors"), 0))106.55219142233183INDEX(INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH([Vector], INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Vectors"), 0))111.16757333980894INDEX(INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH([Vector], INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Vectors"), 0))114.05887088418805INDEX(INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH([Vector], INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Vectors"), 0))114.95364928171313916INDEX(Vectors[Description], MATCH([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([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([Vector], INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Vectors"), 0))8.9246328887454354INDEX(INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH([Vector], INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Vectors"), 0))34.124558331528426INDEX(INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH([Vector], INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Vectors"), 0))60.837028789951731INDEX(INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH([Vector], INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Vectors"), 0))61.945785731915393INDEX(INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH([Vector], INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Vectors"), 0))63.154658909372259INDEX(INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH([Vector], INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Vectors"), 0))64.52412290604434INDEX(INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH([Vector], INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Vectors"), 0))66.389017344334917INDEX(INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH([Vector], INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Vectors"), 0))68.539926441748136INDEX(INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH([Vector], INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Vectors"), 0))72.1122175040127052219INDEX(Vectors[Description], MATCH([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([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([Vector], INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Vectors"), 0))19.271864501534527INDEX(INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH([Vector], INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Vectors"), 0))19.527515430592807INDEX(INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH([Vector], INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Vectors"), 0))19.347609819292995INDEX(INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH([Vector], INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Vectors"), 0))20.208856379497369INDEX(INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH([Vector], INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Vectors"), 0))20.857538354836219INDEX(INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH([Vector], INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Vectors"), 0))21.225221609207562INDEX(INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH([Vector], INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Vectors"), 0))21.222187705499536INDEX(INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH([Vector], INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Vectors"), 0))20.745719672795097INDEX(INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH([Vector], INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Vectors"), 0))19.8488093131226361772INDEX(Vectors[Description], MATCH([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([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([Vector], INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Vectors"), 0))4.9933084009547324INDEX(INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH([Vector], INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Vectors"), 0))19.754859734393573INDEX(INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH([Vector], INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Vectors"), 0))35.56818201828176INDEX(INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH([Vector], INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Vectors"), 0))52.498499674282371INDEX(INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH([Vector], INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Vectors"), 0))70.614924107248186INDEX(INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH([Vector], INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Vectors"), 0))95.083155888242274INDEX(INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH([Vector], INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Vectors"), 0))121.40783240207686INDEX(INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH([Vector], INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Vectors"), 0))149.71089047703489INDEX(INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH([Vector], INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Vectors"), 0))180.121844922253222216INDEX(Vectors[Description], MATCH([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([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([Vector], INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Vectors"), 0))1.2064985058080757INDEX(INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH([Vector], INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Vectors"), 0))1.2759298164604789INDEX(INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH([Vector], INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Vectors"), 0))1.3493567449074368INDEX(INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH([Vector], INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Vectors"), 0))1.427009230082986INDEX(INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH([Vector], INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Vectors"), 0))1.5091304433963655INDEX(INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH([Vector], INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Vectors"), 0))1.5959775502315894INDEX(INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH([Vector], INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Vectors"), 0))1.68782251526963INDEX(INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH([Vector], INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Vectors"), 0))1.7849529541551032INDEX(INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH([Vector], INDIRECT("'"&V.a.Inputs[#Headers]&"'!Year.Vectors"), 0))1.8876730341744831209Preferences.EnergyUnitsTWh7841844269169272072172272372472572672747INDEX(Vectors[Description], MATCH([Vector], Vectors[Code], 0))Solid hydrocarbonsINDEX(INDIRECT("'"&V.a.InputsRequested[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&V.a.InputsRequested[#Headers]&"'!Year.Modules"), 0), MATCH([Vector], INDIRECT("'"&V.a.InputsRequested[#Headers]&"'!Year.Vectors"), 0))-496.28220167438485INDEX(INDIRECT("'"&V.a.InputsRequested[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&V.a.InputsRequested[#Headers]&"'!Year.Modules"), 0), MATCH([Vector], INDIRECT("'"&V.a.InputsRequested[#Headers]&"'!Year.Vectors"), 0))-492.9338166504528INDEX(INDIRECT("'"&V.a.InputsRequested[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&V.a.InputsRequested[#Headers]&"'!Year.Modules"), 0), MATCH([Vector], INDIRECT("'"&V.a.InputsRequested[#Headers]&"'!Year.Vectors"), 0))-443.38836206194571INDEX(INDIRECT("'"&V.a.InputsRequested[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&V.a.InputsRequested[#Headers]&"'!Year.Modules"), 0), MATCH([Vector], INDIRECT("'"&V.a.InputsRequested[#Headers]&"'!Year.Vectors"), 0))-353.76972207519685INDEX(INDIRECT("'"&V.a.InputsRequested[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&V.a.InputsRequested[#Headers]&"'!Year.Modules"), 0), MATCH([Vector], INDIRECT("'"&V.a.InputsRequested[#Headers]&"'!Year.Vectors"), 0))-247.38915865341372INDEX(INDIRECT("'"&V.a.InputsRequested[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&V.a.InputsRequested[#Headers]&"'!Year.Modules"), 0), MATCH([Vector], INDIRECT("'"&V.a.InputsRequested[#Headers]&"'!Year.Vectors"), 0))-197.17405988023407INDEX(INDIRECT("'"&V.a.InputsRequested[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&V.a.InputsRequested[#Headers]&"'!Year.Modules"), 0), MATCH([Vector], INDIRECT("'"&V.a.InputsRequested[#Headers]&"'!Year.Vectors"), 0))-251.70982893180047INDEX(INDIRECT("'"&V.a.InputsRequested[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&V.a.InputsRequested[#Headers]&"'!Year.Modules"), 0), MATCH([Vector], INDIRECT("'"&V.a.InputsRequested[#Headers]&"'!Year.Vectors"), 0))-313.15730416419291INDEX(INDIRECT("'"&V.a.InputsRequested[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&V.a.InputsRequested[#Headers]&"'!Year.Modules"), 0), MATCH([Vector], INDIRECT("'"&V.a.InputsRequested[#Headers]&"'!Year.Vectors"), 0))-381.78722566269323INDEX(INDIRECT("'"&V.a.InputsRequested[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&V.a.InputsRequested[#Headers]&"'!Year.Modules"), 0), MATCH([Vector], INDIRECT("'"&V.a.InputsRequested[#Headers]&"'!Year.Vectors"), 0))-447.4795858544096649INDEX(Vectors[Description], MATCH([Vector], Vectors[Code], 0))Liquid hydrocarbonsINDEX(INDIRECT("'"&V.a.InputsRequested[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&V.a.InputsRequested[#Headers]&"'!Year.Modules"), 0), MATCH([Vector], INDIRECT("'"&V.a.InputsRequested[#Headers]&"'!Year.Vectors"), 0))-893.29280469570267INDEX(INDIRECT("'"&V.a.InputsRequested[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&V.a.InputsRequested[#Headers]&"'!Year.Modules"), 0), MATCH([Vector], INDIRECT("'"&V.a.InputsRequested[#Headers]&"'!Year.Vectors"), 0))-874.71045207199381INDEX(INDIRECT("'"&V.a.InputsRequested[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&V.a.InputsRequested[#Headers]&"'!Year.Modules"), 0), MATCH([Vector], INDIRECT("'"&V.a.InputsRequested[#Headers]&"'!Year.Vectors"), 0))-844.38393083689346INDEX(INDIRECT("'"&V.a.InputsRequested[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&V.a.InputsRequested[#Headers]&"'!Year.Modules"), 0), MATCH([Vector], INDIRECT("'"&V.a.InputsRequested[#Headers]&"'!Year.Vectors"), 0))-825.60672968848655INDEX(INDIRECT("'"&V.a.InputsRequested[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&V.a.InputsRequested[#Headers]&"'!Year.Modules"), 0), MATCH([Vector], INDIRECT("'"&V.a.InputsRequested[#Headers]&"'!Year.Vectors"), 0))-741.49992081300377INDEX(INDIRECT("'"&V.a.InputsRequested[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&V.a.InputsRequested[#Headers]&"'!Year.Modules"), 0), MATCH([Vector], INDIRECT("'"&V.a.InputsRequested[#Headers]&"'!Year.Vectors"), 0))-666.164733428575INDEX(INDIRECT("'"&V.a.InputsRequested[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&V.a.InputsRequested[#Headers]&"'!Year.Modules"), 0), MATCH([Vector], INDIRECT("'"&V.a.InputsRequested[#Headers]&"'!Year.Vectors"), 0))-667.23126155201805INDEX(INDIRECT("'"&V.a.InputsRequested[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&V.a.InputsRequested[#Headers]&"'!Year.Modules"), 0), MATCH([Vector], INDIRECT("'"&V.a.InputsRequested[#Headers]&"'!Year.Vectors"), 0))-665.62908889393543INDEX(INDIRECT("'"&V.a.InputsRequested[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&V.a.InputsRequested[#Headers]&"'!Year.Modules"), 0), MATCH([Vector], INDIRECT("'"&V.a.InputsRequested[#Headers]&"'!Year.Vectors"), 0))-654.78097837357473INDEX(INDIRECT("'"&V.a.InputsRequested[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&V.a.InputsRequested[#Headers]&"'!Year.Modules"), 0), MATCH([Vector], INDIRECT("'"&V.a.InputsRequested[#Headers]&"'!Year.Vectors"), 0))-647.5867506161670250INDEX(Vectors[Description], MATCH([Vector], Vectors[Code], 0))Gaseous hydrocarbonsINDEX(INDIRECT("'"&V.a.InputsRequested[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&V.a.InputsRequested[#Headers]&"'!Year.Modules"), 0), MATCH([Vector], INDIRECT("'"&V.a.InputsRequested[#Headers]&"'!Year.Vectors"), 0))-989.17127665018734INDEX(INDIRECT("'"&V.a.InputsRequested[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&V.a.InputsRequested[#Headers]&"'!Year.Modules"), 0), MATCH([Vector], INDIRECT("'"&V.a.InputsRequested[#Headers]&"'!Year.Vectors"), 0))-971.89981030534068INDEX(INDIRECT("'"&V.a.InputsRequested[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&V.a.InputsRequested[#Headers]&"'!Year.Modules"), 0), MATCH([Vector], INDIRECT("'"&V.a.InputsRequested[#Headers]&"'!Year.Vectors"), 0))-962.69854752423919INDEX(INDIRECT("'"&V.a.InputsRequested[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&V.a.InputsRequested[#Headers]&"'!Year.Modules"), 0), MATCH([Vector], INDIRECT("'"&V.a.InputsRequested[#Headers]&"'!Year.Vectors"), 0))-911.64967846602929INDEX(INDIRECT("'"&V.a.InputsRequested[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&V.a.InputsRequested[#Headers]&"'!Year.Modules"), 0), MATCH([Vector], INDIRECT("'"&V.a.InputsRequested[#Headers]&"'!Year.Vectors"), 0))-828.41525450663926INDEX(INDIRECT("'"&V.a.InputsRequested[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&V.a.InputsRequested[#Headers]&"'!Year.Modules"), 0), MATCH([Vector], INDIRECT("'"&V.a.InputsRequested[#Headers]&"'!Year.Vectors"), 0))-659.13153931643296INDEX(INDIRECT("'"&V.a.InputsRequested[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&V.a.InputsRequested[#Headers]&"'!Year.Modules"), 0), MATCH([Vector], INDIRECT("'"&V.a.InputsRequested[#Headers]&"'!Year.Vectors"), 0))-459.63161922981772INDEX(INDIRECT("'"&V.a.InputsRequested[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&V.a.InputsRequested[#Headers]&"'!Year.Modules"), 0), MATCH([Vector], INDIRECT("'"&V.a.InputsRequested[#Headers]&"'!Year.Vectors"), 0))-333.42520885709342INDEX(INDIRECT("'"&V.a.InputsRequested[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&V.a.InputsRequested[#Headers]&"'!Year.Modules"), 0), MATCH([Vector], INDIRECT("'"&V.a.InputsRequested[#Headers]&"'!Year.Vectors"), 0))-272.25184008543522INDEX(INDIRECT("'"&V.a.InputsRequested[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&V.a.InputsRequested[#Headers]&"'!Year.Modules"), 0), MATCH([Vector], INDIRECT("'"&V.a.InputsRequested[#Headers]&"'!Year.Vectors"), 0))-203.065595048894981338151714391441177417751234753INDEX(Vectors[Description], MATCH($C35, Vectors[Code], 0))Dry biomass and waste14371100753INDEX(Vectors[Description], MATCH($C36, Vectors[Code], 0))Dry biomass and waste2300010753INDEX(Vectors[Description], MATCH($C37, Vectors[Code], 0))Dry biomass and waste140001916INDEX(Vectors[Description], MATCH($C38, Vectors[Code], 0))Wet biomass and waste14370000916INDEX(Vectors[Description], MATCH($C39, Vectors[Code], 0))Wet biomass and waste2300010916INDEX(Vectors[Description], MATCH($C40, Vectors[Code], 0))Wet biomass and waste1411011772INDEX(Vectors[Description], MATCH($C41, Vectors[Code], 0))Energy crops (second generation)143701001772INDEX(Vectors[Description], MATCH($C42, Vectors[Code], 0))Energy crops (second generation)23010101772INDEX(Vectors[Description], MATCH($C43, Vectors[Code], 0))Energy crops (second generation)1400012216INDEX(Vectors[Description], MATCH($C44, Vectors[Code], 0))Energy crops (first generation)143700002216INDEX(Vectors[Description], MATCH($C45, Vectors[Code], 0))Energy crops (first generation)23011112216INDEX(Vectors[Description], MATCH($C46, Vectors[Code], 0))Energy crops (first generation)1400002219INDEX(Vectors[Description], MATCH($C47, Vectors[Code], 0))Gaseous waste143700002219INDEX(Vectors[Description], MATCH($C48, Vectors[Code], 0))Gaseous waste23000002219INDEX(Vectors[Description], MATCH($C49, Vectors[Code], 0))Gaseous waste14111171724402222168878425321519INDEX(Vectors[Description], MATCH(G$62, Vectors[Code], 0))Wet biomass and wasteINDEX(Vectors[Description], MATCH(H$62, Vectors[Code], 0))Dry biomass and wasteINDEX(Vectors[Description], MATCH(I$62, Vectors[Code], 0))Energy crops (second generation)INDEX(Vectors[Description], MATCH(J$62, Vectors[Code], 0))Energy crops (first generation)INDEX(Vectors[Description], MATCH(K$62, Vectors[Code], 0))Gaseous waste71579442151891675317722216221947INDEX(Vectors[Description], MATCH($C63, Vectors[Code], 0))Solid hydrocarbons4390.90.949INDEX(Vectors[Description], MATCH($C64, Vectors[Code], 0))Liquid hydrocarbons0.3180.370.370.3150INDEX(Vectors[Description], MATCH($C65, Vectors[Code], 0))Gaseous hydrocarbons14280.750.584999999999999960.584999999999999961717109152043915211428152225311519145514542215222113671579442151891675317722216221947624390.950.9549630.382000000000000010.450.450.3165062714280.850.662000000000000030.6620000000000000317174391521142815223170"Cost of a typical plant in "&Preferences.moneyunitsCost of a typical plant in £mPreferences.EnergyUnits&"/yr"TWh/yr3449330614411774177534501799180117991801442753INDEX(Vectors[Description], MATCH($C90, Vectors[Code], 0))Dry biomass and waste1437((100000/1000000)*VI.a!F179)0.41666666666666663((50%*(2*GBP/Unit.GJ))*$F90)*(Price2000)1.9428038545228474((150%*(2*GBP/Unit.GJ))*$F90)*(Price2000)5.82841156356854213451753INDEX(Vectors[Description], MATCH($C91, Vectors[Code], 0))Dry biomass and waste23016000000*Conversion.UKgallons.to.litres*Constants.Density.JetFuel*Constants.GCV.ATF0.75341230690526695((20.33*MGBP/Unit.PJ)*$F91)*(Price2000)71.41842803567333((32.44*MGBP/Unit.PJ)*$F91)*(Price2000)113.96034458815755((3.008*MGBP/Unit.PJ)*$F91)*(Price2000)10.566976464894511((3.898*MGBP/Unit.PJ)*$F91)*(Price2000)13.6935087301059883452753INDEX(Vectors[Description], MATCH($C92, Vectors[Code], 0))Dry biomass and waste14800*Unit.GWh0.8((11.44*MGBP/Unit.PJ)*$F92)*(Price2000)42.673298103823441((32.422*MGBP/Unit.PJ)*$F92)*(Price2000)120.94000621697234((0.705*MGBP/Unit.PJ)*$F92)*(Price2000)2.6297792974821261((3.008*MGBP/Unit.PJ)*$F92)*(Price2000)11.2203916692570723453916INDEX(Vectors[Description], MATCH($C93, Vectors[Code], 0))Wet biomass and waste1437916INDEX(Vectors[Description], MATCH($C94, Vectors[Code], 0))Wet biomass and waste230F980.8G98*285.346596207646883H98*2241.880012433944675.259558594964252322.440783338514144916INDEX(Vectors[Description], MATCH($C95, Vectors[Code], 0))Wet biomass and waste140.01($F$95*(50%*(12.56+18.01)*MGBP/Unit.PJ))*(Price2000)0.71269816599316127($F$95*(150%*(12.56+18.01)*MGBP/Unit.PJ))*(Price2000)2.138094497979484($F$95*(50%*(0+3.72)*MGBP/Unit.PJ))*(Price2000)8.6726764065899922E-2($F$95*(150%*(0+3.72)*MGBP/Unit.PJ))*(Price2000)0.260180292197699731772INDEX(Vectors[Description], MATCH($C96, Vectors[Code], 0))Energy crops (second generation)1437F900.41666666666666663G90001.94280385452284745.82841156356854211772INDEX(Vectors[Description], MATCH($C97, Vectors[Code], 0))Energy crops (second generation)23016000000*Conversion.UKgallons.to.litres*Constants.Density.JetFuel*Constants.GCV.ATF0.75341230690526695((20.33*MGBP/Unit.PJ)*$F97)*(Price2000)71.41842803567333((32.44*MGBP/Unit.PJ)*$F97)*(Price2000)113.96034458815755((3.008*MGBP/Unit.PJ)*$F97)*(Price2000)10.566976464894511((3.898*MGBP/Unit.PJ)*$F97)*(Price2000)13.69350873010598834521772INDEX(Vectors[Description], MATCH($C98, Vectors[Code], 0))Energy crops (second generation)14F920.8G9242.673298103823441120.940006216972342.629779297482126111.2203916692570722216INDEX(Vectors[Description], MATCH($C99, Vectors[Code], 0))Energy crops (first generation)14372216INDEX(Vectors[Description], MATCH($C100, Vectors[Code], 0))Energy crops (first generation)23016000000*Conversion.UKgallons.to.litres*Constants.Density.JetFuel*Constants.GCV.ATF0.75341230690526695(50%*(17.2*MGBP/Unit.PJ)*$F100)*(Price2000)30.211435371706383(150%*(17.2*MGBP/Unit.PJ)*$F100)*(Price2000)90.634306115119145(50%*((3.898+0.025)*MGBP/Unit.PJ)*$F100)*(Price2000)6.8906663350700086(150%*((3.898+0.025)*MGBP/Unit.PJ)*$F100)*(Price2000)20.67199900521002634522216INDEX(Vectors[Description], MATCH($C101, Vectors[Code], 0))Energy crops (first generation)142219INDEX(Vectors[Description], MATCH($C102, Vectors[Code], 0))Gaseous waste14372219INDEX(Vectors[Description], MATCH($C103, Vectors[Code], 0))Gaseous waste2302219INDEX(Vectors[Description], MATCH($C104, Vectors[Code], 0))Gaseous waste140.01((13.74*MGBP/Unit.PJ)*$F104)*(Price2000)0.64065899906745416((14.97*MGBP/Unit.PJ)*$F104)*(Price2000)0.69801056885296875((3.56*MGBP/Unit.PJ)*$F104)*(Price2000)0.16599316133043207((4.07*MGBP/Unit.PJ)*$F104)*(Price2000)0.189773080509791757173448731115232152431776422235164461526200720102015202020252030203520402045205011645753INDEX(Vectors[Description], MATCH($C118, Vectors[Code], 0))Dry biomass and wastePreferences.EnergyUnitsTWhF$1512.98977086136492320.99003216956555929.68259237572323958.76232663561392492.782505569121923103.53152234974949106.55219142233183111.16757333980894114.05887088418805114.9536492817131383317771437SUMIFS(INDEX($F$35:$I$49, , MATCH($E$7, $F$34:$I$34, 0)), $C$35:$C$49, $C$118, $E$35:$E$49, D119 )18331525INDEX($H$63:$H$65, MATCH($C121, $C$63:$C$65, 0))0.9INDEX($H$63:$H$65, MATCH($C121, $C$63:$C$65, 0))0.9INDEX($H$63:$H$65, MATCH($C121, $C$63:$C$65, 0))0.9INDEX($H$63:$H$65, MATCH($C121, $C$63:$C$65, 0))0.9INDEX($H$76:$H$78, MATCH($C121, $C$76:$C$78, 0))0.950.950.950.950.950.9583547INDEX(Vectors[Description], MATCH($C121, Vectors[Code], 0))Solid hydrocarbonsPreferences.EnergyUnitsTWhF$118*$F119*F$12011.69079377522843G$118*$F119*G$12018.89102895260900526.71433313815091652.88609397205253588.14338029066581798.354946232262009101.22458185121523105.60919467281849108.35592733997865O$118*$F119*O$120109.205966817627478331777230SUMIFS(INDEX($F$35:$I$49, , MATCH($E$7, $F$34:$I$34, 0)), $C$35:$C$49, $C$118, $E$35:$E$49, D123 )08331525INDEX($H$63:$H$65, MATCH($C125, $C$63:$C$65, 0))0.37INDEX($H$63:$H$65, MATCH($C125, $C$63:$C$65, 0))0.37INDEX($H$63:$H$65, MATCH($C125, $C$63:$C$65, 0))0.37INDEX($H$63:$H$65, MATCH($C125, $C$63:$C$65, 0))0.37INDEX($H$76:$H$78, MATCH($C125, $C$76:$C$78, 0))0.450.450.450.450.450.4583549INDEX(Vectors[Description], MATCH($C125, Vectors[Code], 0))Liquid hydrocarbonsPreferences.EnergyUnitsTWhF$118*$F123*F1240G$118*$F123*G124000000000833177714SUMIFS(INDEX($F$35:$I$49, , MATCH($E$7, $F$34:$I$34, 0)), $C$35:$C$49, $C$118, $E$35:$E$49, D127 )08331525INDEX($H$63:$H$65, MATCH($C129, $C$63:$C$65, 0))0.58499999999999996INDEX($H$63:$H$65, MATCH($C129, $C$63:$C$65, 0))0.58499999999999996INDEX($H$63:$H$65, MATCH($C129, $C$63:$C$65, 0))0.58499999999999996INDEX($H$63:$H$65, MATCH($C129, $C$63:$C$65, 0))0.58499999999999996INDEX($H$76:$H$78, MATCH($C129, $C$76:$C$78, 0))0.662000000000000030.662000000000000030.662000000000000030.662000000000000030.662000000000000030.6620000000000000383550INDEX(Vectors[Description], MATCH($C129, Vectors[Code], 0))Gaseous hydrocarbonsPreferences.EnergyUnitsTWhF$118*$F127*F128000000000021646916INDEX(Vectors[Description], MATCH($C132, Vectors[Code], 0))Wet biomass and wastePreferences.EnergyUnitsTWhF$164.96104770000000088.924632888745435434.12455833152842660.83702878995173161.94578573191539363.15465890937225964.5241229060443466.38901734433491768.53992644174813672.11221750401270583317771437SUMIFS(INDEX($F$35:$I$49, , MATCH($E$7, $F$34:$I$34, 0)), $C$35:$C$49, $C$132, $E$35:$E$49, D133 )08331525INDEX($G$63:$G$65, MATCH($C135, $C$63:$C$65, 0))0INDEX($G$63:$G$65, MATCH($C135, $C$63:$C$65, 0))0INDEX($G$63:$G$65, MATCH($C135, $C$63:$C$65, 0))0INDEX($G$63:$G$65, MATCH($C135, $C$63:$C$65, 0))0INDEX($G$76:$G$78, MATCH($C135, $C$76:$C$78, 0))00000083547INDEX(Vectors[Description], MATCH($C135, Vectors[Code], 0))Solid hydrocarbonsPreferences.EnergyUnitsTWhF$132*$F133*F1340G$132*$F133*G1340000000008331777230SUMIFS(INDEX($F$35:$I$49, , MATCH($E$7, $F$34:$I$34, 0)), $C$35:$C$49, $C$132, $E$35:$E$49, D137 )08331525INDEX($G$63:$G$65, MATCH($C139, $C$63:$C$65, 0))0.318INDEX($G$63:$G$65, MATCH($C139, $C$63:$C$65, 0))0.318INDEX($G$63:$G$65, MATCH($C139, $C$63:$C$65, 0))0.318INDEX($G$63:$G$65, MATCH($C139, $C$63:$C$65, 0))0.318INDEX($G$76:$G$78, MATCH($C139, $C$76:$C$78, 0))0.382000000000000010.382000000000000010.382000000000000010.382000000000000010.382000000000000010.3820000000000000183549INDEX(Vectors[Description], MATCH($C139, Vectors[Code], 0))Liquid hydrocarbonsPreferences.EnergyUnitsTWhF$132*$F137*F1380000000000833177714SUMIFS(INDEX($F$35:$I$49, , MATCH($E$7, $F$34:$I$34, 0)), $C$35:$C$49, $C$132, $E$35:$E$49, D141 )18331525INDEX($G$63:$G$65, MATCH($C143, $C$63:$C$65, 0))0.75INDEX($G$63:$G$65, MATCH($C143, $C$63:$C$65, 0))0.75INDEX($G$63:$G$65, MATCH($C143, $C$63:$C$65, 0))0.75INDEX($G$63:$G$65, MATCH($C143, $C$63:$C$65, 0))0.75INDEX($G$76:$G$78, MATCH($C143, $C$76:$C$78, 0))0.850.850.850.850.850.8583550INDEX(Vectors[Description], MATCH($C143, Vectors[Code], 0))Gaseous hydrocarbonsPreferences.EnergyUnitsTWhF$132*$F141*F1423.72078577500000046.693474666559076525.59341874864632245.62777159246380252.65391787212808353.68146007296641654.84550447013769156.43066474268467758.25893747548591561.2953848784108317781772INDEX(Vectors[Description], MATCH($C146, Vectors[Code], 0))Energy crops (second generation)Preferences.EnergyUnitsTWhF$180.82222222222222219G$184.9933084009547324H$1819.75485973439357335.5681820182817652.49849967428237170.61492410724818695.083155888242274121.40783240207686149.71089047703489180.1218449222532283317771437SUMIFS(INDEX($F$35:$I$49, , MATCH($E$7, $F$34:$I$34, 0)), $C$35:$C$49, $C$146, $E$35:$E$49, D147 )18331525INDEX($I$63:$I$65, MATCH($C149, $C$63:$C$65, 0))0.9INDEX($I$63:$I$65, MATCH($C149, $C$63:$C$65, 0))0.9INDEX($I$63:$I$65, MATCH($C149, $C$63:$C$65, 0))0.9INDEX($I$63:$I$65, MATCH($C149, $C$63:$C$65, 0))0.9INDEX($I$76:$I$78, MATCH($C149, $C$76:$C$78, 0))0.950.950.950.950.950.9583547INDEX(Vectors[Description], MATCH($C149, Vectors[Code], 0))Solid hydrocarbonsPreferences.EnergyUnitsTWhF$146*$F147*F1480.74G$146*$F147*G1484.493977560859259617.77937376095421532.01136381645358949.87357469056824867.08417790188576690.328998093830151115.33744078197302142.22534595318314171.115752676140548331777230SUMIFS(INDEX($F$35:$I$49, , MATCH($E$7, $F$34:$I$34, 0)), $C$35:$C$49, $C$146, $E$35:$E$49, D151 )08331525INDEX($I$63:$I$65, MATCH($C153, $C$63:$C$65, 0))0.37INDEX($I$63:$I$65, MATCH($C153, $C$63:$C$65, 0))0.37INDEX($I$63:$I$65, MATCH($C153, $C$63:$C$65, 0))0.37INDEX($I$63:$I$65, MATCH($C153, $C$63:$C$65, 0))0.37INDEX($I$76:$I$78, MATCH($C153, $C$76:$C$78, 0))0.450.450.450.450.450.4583549INDEX(Vectors[Description], MATCH($C153, Vectors[Code], 0))Liquid hydrocarbonsPreferences.EnergyUnitsTWhF$146*$F151*F1520000000000833177714SUMIFS(INDEX($F$35:$I$49, , MATCH($E$7, $F$34:$I$34, 0)), $C$35:$C$49, $C$146, $E$35:$E$49, D155 )08331525INDEX($I$63:$I$65, MATCH($C157, $C$63:$C$65, 0))0.58499999999999996INDEX($I$63:$I$65, MATCH($C157, $C$63:$C$65, 0))0.58499999999999996INDEX($I$63:$I$65, MATCH($C157, $C$63:$C$65, 0))0.58499999999999996INDEX($I$63:$I$65, MATCH($C157, $C$63:$C$65, 0))0.58499999999999996INDEX($I$76:$I$78, MATCH($C157, $C$76:$C$78, 0))0.662000000000000030.662000000000000030.662000000000000030.662000000000000030.662000000000000030.6620000000000000383550INDEX(Vectors[Description], MATCH($C157, Vectors[Code], 0))Gaseous hydrocarbonsPreferences.EnergyUnitsTWhF$146*$F155*F15600000000002216INDEX(Vectors[Description], MATCH($C159, Vectors[Code], 0))Energy crops (first generation)Preferences.EnergyUnitsTWhF$194.0592999999999995G$191.20649850580807571.27592981646047891.34935674490743681.4270092300829861.50913044339636551.59597755023158941.687822515269631.78495295415510321.88767303417448383317771437SUMIFS(INDEX($F$35:$I$49, , MATCH($E$7, $F$34:$I$34, 0)), $C$35:$C$49, $C$159, $E$35:$E$49, D160 )08331525INDEX($J$63:$J$65, MATCH($C162, $C$63:$C$65, 0))0INDEX($J$63:$J$65, MATCH($C162, $C$63:$C$65, 0))0INDEX($J$63:$J$65, MATCH($C162, $C$63:$C$65, 0))0INDEX($J$63:$J$65, MATCH($C162, $C$63:$C$65, 0))083547INDEX(Vectors[Description], MATCH($C162, Vectors[Code], 0))Solid hydrocarbonsPreferences.EnergyUnitsTWhF$159*$F160*$F1610G$159*$F160*$F1610000000008331777230SUMIFS(INDEX($F$35:$I$49, , MATCH($E$7, $F$34:$I$34, 0)), $C$35:$C$49, $C$159, $E$35:$E$49, D164 )18331525INDEX($J$63:$J$65, MATCH($C166, $C$63:$C$65, 0))0.31INDEX($J$63:$J$65, MATCH($C166, $C$63:$C$65, 0))0.31INDEX($J$63:$J$65, MATCH($C166, $C$63:$C$65, 0))0.31INDEX($J$63:$J$65, MATCH($C166, $C$63:$C$65, 0))0.31INDEX($J$76:$J$78, MATCH($C166, $C$76:$C$78, 0))0.3160.3160.3160.3160.3160.31683549INDEX(Vectors[Description], MATCH($C166, Vectors[Code], 0))Liquid hydrocarbonsPreferences.EnergyUnitsTWhF$159*$F164*F1651.2583829999999998G$159*$F164*G1650.374014536800503450.395538243102748430.418300590921305390.450934916706223540.476885220113251520.504328905873182240.533351914825203060.56404513351301266O$159*$F164*O1650.5965046787991366833177714SUMIFS(INDEX($F$35:$I$49, , MATCH($E$7, $F$34:$I$34, 0)), $C$35:$C$49, $C$159, $E$35:$E$49, D168 )08331525INDEX($J$63:$J$65, MATCH($C170, $C$63:$C$65, 0))083550INDEX(Vectors[Description], MATCH($C170, Vectors[Code], 0))Gaseous hydrocarbonsPreferences.EnergyUnitsTWhF$159*$F168*$F1690000000000422242219INDEX(Vectors[Description], MATCH($C173, Vectors[Code], 0))Gaseous wastePreferences.EnergyUnitsTWhF$1718.283196551267896G$1719.27186450153452719.52751543059280719.34760981929299520.20885637949736920.85753835483621921.22522160920756221.22218770549953620.74571967279509719.84880931312263683317771437SUMIFS(INDEX($F$35:$I$49, , MATCH($E$7, $F$34:$I$34, 0)), $C$35:$C$49, $C$173, $E$35:$E$49, D174 )08331525INDEX($K$63:$K$65, MATCH($C176, $C$63:$C$65, 0))0INDEX($K$63:$K$65, MATCH($C176, $C$63:$C$65, 0))0INDEX($K$63:$K$65, MATCH($C176, $C$63:$C$65, 0))0INDEX($K$63:$K$65, MATCH($C176, $C$63:$C$65, 0))0INDEX($K$76:$K$78, MATCH($C176, $C$76:$C$78, 0))00000083547INDEX(Vectors[Description], MATCH($C176, Vectors[Code], 0))Solid hydrocarbonsPreferences.EnergyUnitsTWhF$173*$F174*F1750G$173*$F174*G17500000000008331777230SUMIFS(INDEX($F$35:$I$49, , MATCH($E$7, $F$34:$I$34, 0)), $C$35:$C$49, $C$173, $E$35:$E$49, D178 )08331525INDEX($K$63:$K$65, MATCH($C180, $C$63:$C$65, 0))0INDEX($K$63:$K$65, MATCH($C180, $C$63:$C$65, 0))0INDEX($K$63:$K$65, MATCH($C180, $C$63:$C$65, 0))0INDEX($K$63:$K$65, MATCH($C180, $C$63:$C$65, 0))0INDEX($K$76:$K$78, MATCH($C180, $C$76:$C$78, 0))00000083549INDEX(Vectors[Description], MATCH($C180, Vectors[Code], 0))Liquid hydrocarbonsPreferences.EnergyUnitsTWhF$173*$F178*F1790000000000833177714SUMIFS(INDEX($F$35:$I$49, , MATCH($E$7, $F$34:$I$34, 0)), $C$35:$C$49, $C$173, $E$35:$E$49, D182 )18331525INDEX($K$63:$K$65, MATCH($C184, $C$63:$C$65, 0))1INDEX($K$63:$K$65, MATCH($C184, $C$63:$C$65, 0))1INDEX($K$63:$K$65, MATCH($C184, $C$63:$C$65, 0))1INDEX($K$63:$K$65, MATCH($C184, $C$63:$C$65, 0))1INDEX($K$76:$K$78, MATCH($C184, $C$76:$C$78, 0))11111183550INDEX(Vectors[Description], MATCH($C184, Vectors[Code], 0))Gaseous hydrocarbonsPreferences.EnergyUnitsTWhF$173*$F182*F18318.28319655126789619.27186450153452719.52751543059280719.34760981929299520.20885637949736920.85753835483621921.22522160920756221.22218770549953620.74571967279509719.84880931312263651647164847INDEX(Vectors[Description], MATCH($B190, Vectors[Code], 0))Solid hydrocarbonsPreferences.EnergyUnitsTWhF121+F135+F149+F162+F17612.43079377522843G121+G135+G149+G162+G17623.38500651346826644.49370689910513584.897457788506131138.01695498123405165.43912413414779191.55357994504539220.9466354547915250.58127329316179280.32171949376849INDEX(Vectors[Description], MATCH($B191, Vectors[Code], 0))Liquid hydrocarbonsPreferences.EnergyUnitsTWhF125+F139+F153+F166+F1781.2583829999999998G125+G139+G153+G166+G1780.374014536800503450.395538243102748430.418300590921305390.450934916706223540.476885220113251520.504328905873182240.533351914825203060.564045133513012660.596504678799136650INDEX(Vectors[Description], MATCH($B192, Vectors[Code], 0))Gaseous hydrocarbonsPreferences.EnergyUnitsTWhF129+F143+F157+F170+F18422.003982326267895G129+G143+G157+G170+G18425.96533916809360345.12093417923912964.975381411756872.86277425162545374.53899842780263976.07072607934524977.65285244818420679.00465714828101281.144194191533444165047INDEX(Vectors[Description], MATCH($B195, Vectors[Code], 0))Solid hydrocarbonsPreferences.EnergyUnitsTWhMAX(MIN(F190, -F24),0)12.4307937752284323.38500651346826644.49370689910513584.897457788506131138.01695498123405165.43912413414779191.55357994504539220.9466354547915250.58127329316179280.32171949376849INDEX(Vectors[Description], MATCH($B196, Vectors[Code], 0))Liquid hydrocarbonsPreferences.EnergyUnitsTWh1.25838299999999980.374014536800503450.395538243102748430.418300590921305390.450934916706223540.476885220113251520.504328905873182240.533351914825203060.564045133513012660.596504678799136650INDEX(Vectors[Description], MATCH($B197, Vectors[Code], 0))Gaseous hydrocarbonsPreferences.EnergyUnitsTWh22.00398232626789525.96533916809360345.12093417923912964.975381411756872.86277425162545374.53899842780263976.07072607934524977.65285244818420679.00465714828101281.1441941915334447825672571124969169272072172272372472572672747INDEX(Vectors[Description], MATCH($B200, Vectors[Code], 0))Solid hydrocarbonsPreferences.EnergyUnitsTWhF190-F1950G190-G19500000000O190-O195049INDEX(Vectors[Description], MATCH($B201, Vectors[Code], 0))Liquid hydrocarbonsPreferences.EnergyUnitsTWhF191-F196000000000050INDEX(Vectors[Description], MATCH($B202, Vectors[Code], 0))Gaseous hydrocarbonsPreferences.EnergyUnitsTWh00000000006165116521061SUM(F$195:F$197*SUMIFS(EF[CO2], EF[Vector], $B$195:$B$197))8.1920129808036481SUM(G$195:G$197*SUMIFS(EF[CO2], EF[Vector], $B$195:$B$197))12.073708047277572SUM(H$195:H$197*SUMIFS(EF[CO2], EF[Vector], $B$195:$B$197))22.105198174680066SUM(I$195:I$197*SUMIFS(EF[CO2], EF[Vector], $B$195:$B$197))38.208462326353455SUM(J$195:J$197*SUMIFS(EF[CO2], EF[Vector], $B$195:$B$197))56.028706325695715SUM(K$195:K$197*SUMIFS(EF[CO2], EF[Vector], $B$195:$B$197))64.789647249061503SUM(L$195:L$197*SUMIFS(EF[CO2], EF[Vector], $B$195:$B$197))73.121598448141782SUM(M$195:M$197*SUMIFS(EF[CO2], EF[Vector], $B$195:$B$197))82.473026549247962SUM(N$195:N$197*SUMIFS(EF[CO2], EF[Vector], $B$195:$B$197))91.856900372955764SUM(O$195:O$197*SUMIFS(EF[CO2], EF[Vector], $B$195:$B$197))101.4187475050224763454345514834561774177569169272072172272372472572672726861437IFERROR((F$118*$F$119)/$F90,0)31.175450067275818IFERROR((G$118*$F$119)/$F90,0)50.37607720695734871.238221701735782141.02958392547342222.67801336589264248.47565363939881255.7252594135964266.80217601554148273.74129012205134275.88875827611152686230IFERROR((F$118*$F$123)/$F91,0)0IFERROR((G$118*$F$123)/$F91,0)000000000268614IFERROR((F$118*$F$127)/$F92,0)0IFERROR((G$118*$F$127)/$F92,0)00000000026871437IFERROR((F$132*$F$133)/$F93,0)0IFERROR((G$132*$F$133)/$F93,0)0000000002687230IFERROR((F$132*$F$137)/$F94,0)0IFERROR((G$132*$F$137)/$F94,0)000000000268714IFERROR((F$132*$F$141)/$F95,0)496.10477000000009IFERROR((G$132*$F$141)/$F95,0)892.463288874543543412.45583315284246083.70287899517286194.57857319153946315.46589093722566452.4122906044346638.90173443349166853.99264417481397211.221750401270622151437IFERROR((F$146*$F$147)/$F96,0)1.9733333333333334IFERROR((G$146*$F$147)/$F96,0)11.98394016229135947.4116633625445885.363636843876236125.9963992182777169.47581785739567228.19957413178147291.37879776498448359.30613714488379432.292427813407762215230IFERROR((F$146*$F$151)/$F97,0)0IFERROR((G$146*$F$151)/$F97,0)000000000221514IFERROR((F$146*$F$155)/$F98,0)0IFERROR((G$146*$F$155)/$F98,0)00000000022211437IFERROR((F$159*$F$160)/$F$99,0)0IFERROR((G$159*$F$160)/$F$99,0)0000000002221230IFERROR((F$159*$F$164)/$F$99,0)0IFERROR((G$159*$F$164)/$F$99,0)000000000222114IFERROR((F$159*$F$168)/$F$99,0)0IFERROR((G$159*$F$168)/$F$99,0)00000000IFERROR((O$159*$F$168)/$F$99,0)01361437IFERROR((F$173*$F$174)/$F$102,0)0IFERROR((G$173*$F$174)/$F$102,0)000000000136230IFERROR((F$173*$F$178)/$F$102,0)0IFERROR((G$173*$F$178)/$F$102,0)00000000013614IFERROR((F$173*$F$182)/$F$102,0)0IFERROR((G$173*$F$182)/$F$102,0)0000000003457345834561774177569169272072172272372472572672726861437MAX((G212-F212)/(G$229-F$229),0)6.4002090465605095MAX((H212-G212)/(H$229-G$229),0)4.172428898955686813.95827244474752716.3296858880838445.15952805470123541.44992115483951812.21538332038901451.38782282130197250.429493630812032730.134579882085908042686230MAX((G213-F213)/(G$229-F$229),0)0000000000268614000000000026871437000000000026872300000000000268714132.11950629151448503.99850885565974534.2494091684660622.17513883927331324.17746354913724727.38927993344168537.29788876581151443.01818194826446371.4458212452913413.5176691465372052221514373.33686894298600887.08554464005064417.59039469626633168.12655247488029358.695883727823593611.74475125487716212.63584472664060213.58546787597986214.5972581337047930.21087435503093062215230000000000022151400000000002221143700000000002221230000000000022211400000000001361437000000000013623000000000001361400000000007332717996916927207217227237247257267273237Preferences.moneyunits&"/yr"£m/yrSUMPRODUCT(F$230:F$244,$G$90:$G$104)94.161329825884309SUMPRODUCT(G$230:G$244,$G$90:$G$104)359.19881292471672380.7585740972957615.80418078139380917.23123392983662319.52028957643718226.582136918810830.65897937888820150.9193057693943772.5070363493077953306Preferences.moneyunits&"/yr"£m/yrSUMPRODUCT(F$212:F$226,$I$90:$I$104)107.427145503204SUMPRODUCT(G$212:G$226,$I$90:$I$104)198.55373520478773526.46470596872723967.457486182184881214.64174714687741359.71765011701951499.76787029445131660.20661176102931824.31158475073612001.2630654092168148Preferences.moneyunits&"/yr"£m/yrSUM(F248:F249)201.58847532908831SUM(G248:G249)557.75254812950448907.22328006602299983.26166696357871231.8729810767141379.23793969345661526.35000721326221690.86559113991761875.23089052013052003.770101758524618016916927207217227237247257267273237Preferences.moneyunits&"/yr"£m/yrSUMPRODUCT(F$230:F$244,$H$90:$H$104)282.48398947765293SUMPRODUCT(G$230:G$244,$H$90:$H$104)1077.59643877415031142.275722291887447.41254234418143251.69370178950987358.56086872931155879.74641075643241191.976938136664614152.757917308183157.52110904792338623306Preferences.moneyunits&"/yr"£m/yrSUMPRODUCT(F$212:F$226,$J$90:$J$104)322.28143650961198SUMPRODUCT(G$212:G$226,$J$90:$J$104)595.66120561436311579.39411790618152902.37245854655483643.92524144063194079.15295035105784499.3036108833534980.61983528308795472.93475425220826003.7891962276499148Preferences.moneyunits&"/yr"£m/yrSUM(F253:F254)604.76542598726496SUM(G253:G254)1673.25764438851342721.66984019806892949.78500089073623695.61894323014174137.71381908036984579.05002163978595072.59677341975295625.69267156039136011.3103052755732683729Preferences.EnergyUnitsTWh7841844269169272072172272372472572672747INDEX(Vectors[Description], MATCH([Vector], Vectors[Code], 0))Solid hydrocarbonsF19012.4307937752284323.38500651346826644.49370689910513584.897457788506131138.01695498123405165.43912413414779191.55357994504539220.9466354547915250.58127329316179O190280.32171949376849INDEX(Vectors[Description], MATCH([Vector], Vectors[Code], 0))Liquid hydrocarbons1.25838299999999980.374014536800503450.395538243102748430.418300590921305390.450934916706223540.476885220113251520.504328905873182240.533351914825203060.564045133513012660.596504678799136650INDEX(Vectors[Description], MATCH([Vector], Vectors[Code], 0))Gaseous hydrocarbons22.00398232626789525.96533916809360345.12093417923912964.975381411756872.86277425162545374.53899842780263976.07072607934524977.65285244818420679.00465714828101281.144194191533444753INDEX(Vectors[Description], MATCH([Vector], Vectors[Code], 0))Dry biomass and waste-F$15-12.989770861364923-G$15-20.990032169565559-29.682592375723239-58.762326635613924-92.782505569121923-103.53152234974949-106.55219142233183-111.16757333980894-114.05887088418805-114.95364928171313916INDEX(Vectors[Description], MATCH([Vector], Vectors[Code], 0))Wet biomass and waste-F$16-4.9610477000000008-8.9246328887454354-34.124558331528426-60.837028789951731-61.945785731915393-63.154658909372259-64.52412290604434-66.389017344334917-68.539926441748136-72.1122175040127052219INDEX(Vectors[Description], MATCH([Vector], Vectors[Code], 0))Gaseous waste-F17-18.283196551267896-G17-19.271864501534527-19.527515430592807-19.347609819292995-20.208856379497369-20.857538354836219-21.225221609207562-21.222187705499536-20.745719672795097-19.8488093131226361772INDEX(Vectors[Description], MATCH([Vector], Vectors[Code], 0))Energy crops (second generation)-F$18-0.82222222222222219-G$18-4.9933084009547324-19.754859734393573-35.56818201828176-52.498499674282371-70.614924107248186-95.083155888242274-121.40783240207686-149.71089047703489-180.121844922253222216INDEX(Vectors[Description], MATCH([Vector], Vectors[Code], 0))Energy crops (first generation)-F$19-4.0592999999999995-G$19-1.2064985058080757-1.2759298164604789-1.3493567449074368-1.427009230082986-1.5091304433963655-1.5959775502315894-1.68782251526963-1.7849529541551032-1.88767303417448334INDEX(Vectors[Description], MATCH([Vector], Vectors[Code], 0))Conversion lossesSUM(V.a.Inputs[2007])-SUM(F$190:F$192)5.4223782333587138SUM(V.a.Inputs[2010])-SUM(G$190:G$192)5.6619762482459564SUM(V.a.Inputs[2015])-SUM(H$190:H$192)14.355276367251506SUM(V.a.Inputs[2020])-SUM(I$190:I$192)25.573364216863581SUM(V.a.Inputs[2025])-SUM(J$190:J$192)17.531992435334274SUM(V.a.Inputs[2030])-SUM(K$190:K$192)19.212766382538859SUM(V.a.Inputs[2035])-SUM(L$190:L$192)20.85203444579372SUM(V.a.Inputs[2040])-SUM(M$190:M$192)22.741593489188915SUM(V.a.Inputs[2045])-SUM(N$190:N$192)24.690384854965487SUM(V.a.Inputs[2050])-SUM(O$190:O$192)26.861775691175581148SUBTOTAL(109,[2007])0SUBTOTAL(109,[2010])0SUBTOTAL(109,[2015])0SUBTOTAL(109,[2020])-3.5527136788005009E-14SUBTOTAL(109,[2025])-3.5527136788005009E-14SUBTOTAL(109,[2030])0SUBTOTAL(109,[2035])0SUBTOTAL(109,[2040])-5.6843418860808015E-14SUBTOTAL(109,[2045])2.8421709430404007E-14SUBTOTAL(109,[2050])0889105810611057102744269169272072172272372472572672710401036INDEX(IPCC[Sector_description], MATCH([IPCC Sector], IPCC[Sector_code], 0))Bioenergy credit-F206-8.1920129808036481-G206-12.073708047277572-22.105198174680066-38.208462326353455-56.028706325695715-64.789647249061503-73.121598448141782-82.473026549247962-91.856900372955764-101.41874750502247148SUBTOTAL(109,[2007])-8.1920129808036481SUBTOTAL(109,[2010])-12.073708047277572SUBTOTAL(109,[2015])-22.105198174680066SUBTOTAL(109,[2020])-38.208462326353455SUBTOTAL(109,[2025])-56.028706325695715SUBTOTAL(109,[2030])-64.789647249061503SUBTOTAL(109,[2035])-73.121598448141782SUBTOTAL(109,[2040])-82.473026549247962SUBTOTAL(109,[2045])-91.856900372955764SUBTOTAL(109,[2050])-101.4187475050224726132618782614442691692720721722723724725726727318931903161784184426916927207217227237247257267273131INDEX(CostVectors[Description], MATCH(C297, CostVectors[Code], 0))Low estimate of capital costsF24894.161329825884309G248359.19881292471672380.7585740972957615.80418078139380917.23123392983662319.52028957643718226.582136918810830.65897937888820150.9193057693943772.5070363493077953133INDEX(CostVectors[Description], MATCH(C298, CostVectors[Code], 0))Low estimate of operating costsF249107.427145503204198.55373520478773526.46470596872723967.457486182184881214.64174714687741359.71765011701951499.76787029445131660.20661176102931824.31158475073612001.26306540921683140INDEX(CostVectors[Description], MATCH(C299, CostVectors[Code], 0))High estimate of capital costsF253282.48398947765293G2531077.59643877415031142.275722291887447.41254234418143251.69370178950987358.56086872931155879.74641075643241191.976938136664614152.757917308183157.52110904792338623142INDEX(CostVectors[Description], MATCH(C300, CostVectors[Code], 0))High estimate of operating costsF254322.28143650961198595.66120561436311579.39411790618152902.37245854655483643.92524144063194079.15295035105784499.3036108833534980.61983528308795472.93475425220826003.7891962276499