quintel / etlocal

Regional data analysis tool for the Energy Transition Model
https://data.energytransitionmodel.com/
MIT License
3 stars 2 forks source link

Industry steel Blastfurnace - transformation demand has double count in Cokes In EB generated values. #538

Open kaskranenburgQ opened 2 months ago

kaskranenburgQ commented 2 months ago

In industry_steel.ymlthe values for industry steel are generated. Blastfurnace - transformation demand consists of Coal demand and Cokes demand. For Coal demand (key: input_energy_blastfurnace_transformation_coal_input_demand). The code that is used to extract data from the EB is: EB("Transformation input - blast furnaces - energy use", "Coal incl lignite and peat") In the entso.yml, this is then translated as the sum of the values of the intersection the row "Transformation input - blast furnaces - energy use" and the following columns that fall under "Coal incl lignite and peat":

For Cokes demand (key: input_energy_blastfurnace_transformation_cokes_input_demand). The code that is used to extract data from the EB is: EB("Transformation input - blast furnaces - energy use", "Coke oven coke") Meaning that the value on the intersection of the row "Transformation input - blast furnaces - energy use" & the column "Coke oven Coke" is returned.

Since Coke oven coke also falls under "Coal incl lignite and peat" A double count of Coke oven coke is appearing in the Blastfurnace - transformation input. For instance, the NL-dataset that is online on the Dataset manager at the moment counts 48 PJ of cokes double.

Since this data if als used to determine the losses of the transformation output, this section is affected as well.

A solution to this problem would be to change the extraction code/definition of input_energy_blastfurnace_transformation_coal_input_demand in industry_steel.yml to:

EB("Transformation input - blast furnaces - energy use", "Coal incl lignite and peat") - EB("Transformation input - blast furnaces - energy use", "Coke oven coke")

Notifying @mabijkerk

mabijkerk commented 2 months ago

Well-spotted! We might also update the product mappings in entso.yml to for example add coal exlc. cokes. When we fix this we also need to re-export the EU datasets to ETSource.