Back

Processing Flows (Module 2) - Online course Sector-Wide Circularity Assessment

Outline of the video

  • Let’s look at flow data processing first. Go to the processing tab and choose the flow data queue. Assign it to yourself and start the work.
  • This category is where you will have most of your data on.
  • First show you how you can start to work on a file and then discuss in which format the data needs to be.
  • The flow data processing template has 10 columns.
  • Period, this is the time reference
    • whole year if start date to end date really cover the entire year
    • Q1, for quarters is also possible. But actually we won’t need data that detailed.

  • Start date and end date, the format that we need is YYYY-MM-DD
  • Material/product name
    Ideally in English. (The original name can be in the comments column)
    You can choose the same one of the EMP code or one that is quite close. If you have several detailed materials, you can use the segment column for that.
  • Material/product name, EMP
  • Quantity, just the number
  • Unit
    • Unit should match the “unit symbol” from the List of units. Be sure to use “kg” instead of Kilogram or “t” for tonnes.
    • Capitalisation matters, so be sure to use correct spelling.

  • Reference space
    • Here is where you add the location name that this data is about. For example, your city name “Porto” or your NUTS3 name. Remember that we made an overview of those for you.
    • (Although it will be unlikely in your case, it is possible to add a file with several reference spaces. For example with data on your city AND NUTS3 or country. This only works if you have a shapefile that also has both of them in one file, to attribute the correct spaces.)

  • Comments
    • Optional field and can remain empty.
    • You could add a URL to more info, the original language name of the material, or simply a comment that you changed the unit.

  • Segments: Here you can become more specific about the material, see examples in the template spreadsheet.
  • Finally, please add “_processed” or “_final” to the previously used file name, save it and add it during the processing.
  • M11:50, uploading a processed file and going through the rest of the processing
  • M14:25, how to fill in the data quality information

Associated spaces


Something wrong with this information? Report errors here.