Skip to main content

The Collection Table

Updated over 2 weeks ago

Data collection in table format

So, this is where you will need to enter the data that will allow the calculation of your carbon footprint.

The table gathers several pieces of information so that you can have an overall view of your data.

Each data point is represented by a row and each column represents specific information about the data.
By default, 10 columns are present but you can display more with this button and select those that interest you.

The advantage of this format is the ability to directly fill in the table:

  1. The value of a data point

  2. The percentage of uncertainty of a data point

You can also enter the data by clicking on

then "edit".
A sidebar appears to provide all the information about the data, which is also accessible by clicking on the name of the data.

Filters


It is important to know that you can filter your data using the "Filter" button located at the top right of the table.
You can filter by:

  • Post > Sub-post

  • Entities

  • Tag

  • Data status (To complete, To correct, In collection, etc.)


When a filter is selected it appears at the top of the table as a tag. It can be easily removed via a click on the tag's cross.


A search bar is also available at the top of the table so that you can directly enter the name of your data or a keyword.

​The columns


Let’s now look at what the different columns of the table correspond to.

  • Status: There are 5 data statuses


    In collection

    To be collected

    Pending verification

    To be corrected

    Validated

  • Category > Subcategory: Each data point must be classified into a Category and then a Subcategory (also referred to as Category and Subcategory). This classification is done at the collection template level in the Admin section.
    The pictogram corresponds to the Post and the name that follows to the Sub-post (you will find all the Posts in the filters).

  • Name of the data: As its name indicates, this is the name of the data. By clicking on it, you open the data pane that groups all the information. From this pane, you will be able to make modifications (adding attachments, explaining the entry, etc.)

  • Entity: This is the name of the entity to which the data is associated. You can have multiple rows with the same data because it is associated with multiple entities

  • Value N-1: As its name indicates, this is the value of the data collected in the previous year. This column does not exist in the year of your first collection.

  • Value: This is where you will enter the value of your data to be collected
    It can be in different formats depending on the unit of your EF.

    • Number

    • Yes/No

    • Text (by entering the data form, you can format your text)

  • Unit: This is the unit of the emission factor associated with your data. If the unit does not correspond, it means the emission factor needs to be modified.
    To learn more about units, you can consult this article.

  • Data uncertainty (%): This corresponds to the percentage of uncertainty that you wish to indicate for the value of your data.
    Example: If I am certain about the value of my data, I indicate 100%.
    0% = completely uncertain

    This uncertainty is then used to calculate the total uncertainty.

    Here is the article that details the calculation -> How is the data uncertainty calculated?

  • Variation: Corresponds to the variation of the values collected between N and N-1.

  • Emissions (tCO2e): These are the emissions produced by the concerned data. The sum of these emissions represents the overall emissions of your carbon footprint.

Here are the default columns.

Below is the detail of the columns you can add to your table ⬇️

  • Emission factor: The name of the emission factor associated with your data

  • EF Uncertainty (%): Each emission factor has its own uncertainty. This uncertainty is also used in the calculation of the total uncertainty.

  • Total uncertainty (tCO2e): This is the uncertainty of the emissions of the data expressed in tCO2e.

    The calculation is as follows: Emission (tCO2e) x Data uncertainty (%)

    Example: Emissions (tCO2e)= 100 and Data Uncertainty (%)= 10%

    Then Total Uncertainty (tCO2e) = 10

  • Data and Entity Tags: You can assign a list of Tags to each data item. These Tags allow you to filter your data more quickly and to have a more detailed analysis of your footprint. To learn more about tags, it happens here:

  • Attachment: Indicates whether an attachment has been added to the data

In video, here is the presentation of the collection table

Did this answer your question?