Step 8: Determine if you have data for the waste categories and fill in the amounts

Where:

• “A. Data collection” sheet > 3. Waste > Column A and orange fields

How:

1. Determine if you have data for the different waste categories and waste materials. Note this down in row A, by selecting a green check mark or a red cross. You can do this as a general case, so doing this for one of your reference years is sufficient.
2. If you have the data, fill in the amounts per waste treatment, as tonnes, in the orange fields in the columns E to K, for your two reference years. (Some of the columns and rows have formulas for automatic summation of intermediate values and totals. They are protected cells and will give you a warning when trying to be edited, so that you do not accidentally change them. However, if you must, then you can edit those cells.)

Note:

• The amounts of waste materials collected are not the same as waste amounts subjected to waste treatment. Be sure to find the right values.
• There are six single values into which the waste categories have to be matched to. There is no distinction for recycling, composting, anaerobic digestion, as these are all grouped under RCV_O. You might find Eurostat waste codes from older years, before 2018. You need to be careful with those and their correct name, but can see the table in Step 7 for matching. You can also refer to the examples in this table, as can be seen in the blue part of “What goes where” to see how other cities allocated their waste treatment categories.
• If you do not have the data in the required waste categories and treatment options, there are correspondence tables that you can use to match your codes:
  • Nuss et al. (2017) matched MF codes with Eurostat “Generation of waste by waste category, hazardousness and NACE Rev. 2 activity” statistics (env_wasgen). https://doi.org/10.2760/362116
  • Jacobi et al. (2018) matched MF codes with waste (Austria) classified in NACE codes. https://doi.org/10.1016/j.resconrec.2018.05.022
  • Mayer et al. (2019) matched MF codes with Eurostat “Treatment of waste by waste category, hazardousness and waste management operations” data (env_wastrt). https://doi.org/10.1111/jiec.12809
• If you are not sure what even is included under certain waste material names, like “W11 Common sludges”, for example, then you can refer to the guide to the classification of waste according to the EWC-Stat categories (see screenshot below). Each waste category is defined here. (For the case of W11 - common sludges, this information can be found on pages 65 and 66.)