Identifying firms with the highest relative emission intensity

[AnneSchoenauer]

Dear @kalashsinghal

could you please provide a bar chart for the relative emission intensity indicator:

only for GER firms
for benchmark tilt subsector unit
for equal weight, best case and worst case
could you please provide a table that shows the average relative emission intensity for all tilt subsectors, please use

• only GER firms
• for grouping tilt subsector unit
• for equal weight, best case and worst case
  Can you then choose the tilt subsector for each equal weight, best case and worst case scenario that has the highest relative emission intensity average. Can you then for this tilt subsector identify

20 firms in the 10% highest relative emission intensity percentile
20 firms in the 10% lowest relative emission intensity percentile
Please provide a csv with these firms. Please provide for each firm their

• products and
• the relative emission intensity for the products.
• Please also provide the COV on firm level.

As we have three scenarios: equal weight, best case and worst case we will have three csv with 40 firms each.
Thanks!
All the best
Anne

[kalashsinghal]

Hi @AnneSchoenauer, Here are the bar charts for best case, worst case and equal weight for benchmark unit_tilt_subsector for Germany:

The table for tilt subsectors:

Please let me know which subsectors you are interested in for creating the csv files! Thanks!

[AnneSchoenauer]

Dear @kalashsinghal,

Thanks a lot: Please use the following subsectors:

• other industry
• other metals
• chemicals
• iron & steel
• agriculture and landuse
• machinery and equipment

[kalashsinghal]

Please use the following subsectors:
other industry
other metals
chemicals
iron & steel
agriculture and landuse
machinery and equipment

Hi @AnneSchoenauer,

PFA the csv files!

emission_company_unit_tilt_subsector.xlsx
emission_product_unit_tilt_subsector.xlsx

[AnneSchoenauer]

Perfect @kalashsinghal

could you please provide a table with

the products, activity name of the firms, co2 value of the products, the input products name and input_activity_name as well as the co2 value of the inputs for the following firms:

• 1vitalfleisch-gmbh_00000004677434-478368001
• adelmann-nutzund-schlachtviehhandlung-gmbh_00000004883563-001
• agrome-gmbh_00000005046781-001
• neoxum-gmbh_00000005286166-001
• ak-steel-international-bv_00000005362573-001
• assfalg-gmbh_deu096820-00101
• adoba-gmbh_00000005040645-001
• 123repair-deutschland_00000005109249-001
• aaa-pest-control-gmbh_00000005083492-001
• agraprodukt-handelsgesellschaft-mbh-co-kg_00000004872494-001

Thanks!

After this, this is done!

[kalashsinghal]

Hi @AnneSchoenauer,

PFA the requested file!

relative_emission_analysis_10_firms.xlsx

Please review the file! Thanks!

[AnneSchoenauer]

Dear @kalashsinghal,

Could you please help again. I had a look at these files here.

I am a bit confused but maybe my ticket was also confusing. What I need is a XLS on company level with:

• only GER firms
• only for the reference group "tilt_subsector_unit"
• the 20 firms with the highest relative emission intensity rank on average (emission_rank_avg_equal_weight)
• the 20 firm with the lowest lowest relative emission intensity rank on average (emission_rank_avg_equal_weight)

Please do this for firms that have at least one product in the following subsectors.

• automotive hdv
• agriculture and livestook
• food related product
• other industry
• other metals

This will be a XLS with only 200 firms.

Please provide a second XLS on product level for these 200 firms. Please provide for each firm at least their

• products
• activity name
• the emission rank
• the CO2 values for the products

Can you then provide a third XLS for the 200 firms and their products

• with activity name of the firms,
• co2 value of the products,
• the input products name and
• input_activity_name as well as the
• co2 value of the inputs

[kalashsinghal]

Hi @AnneSchoenauer,

PFA the requested files! Let me know if any change is required!

emission_company_unit_tilt_subsector.xlsx
emission_product_unit_tilt_subsector.xlsx
input_relative_emission_analysis_200_firms.xlsx