There are two ways to do data collection:
Collecting data through CO2 Form
Form data upload through .csv
Collecting data through co2 form
CO2 Form can be opened by clicking "Start"
Complete the following fields, and use the information pop-up if more clarification is needed.
The form is automatically saved so do not worry about losing any of your submitted data!
Form data upload through .csv
A way to populate the form via just a few clicks is to use the csv upload function. Be aware however that this functionality will overwrite all existing inputs in the form.
Start by clicking on the 3 dots in the right-top corner of the form. Click on Export CSV
You will be informed about the limitations of this function. For example it does not support some input types like:
nights spent in hotels
waste
tables
file upload
Once you confirm a CVS file will be downloaded to your device.
You can open the file and fill in the values and save it back to CSV format. Now you can go back to the right-top corner and press on import CSV.
You will be once again informed about the possible data loss via overwrite and the limitations.
Once you confirm you will see the new values in the form. You can now go ahead and fill in any of the inputs that were not part of the import.
Tracking data collection status
Open CO2 Hub and select Data collection status to see how far each entity has got with the form. Choose the form in the Form selector at the top.
Three tiles summarise the form: Entities, Submitted and Values approved.
Entity overview lists every entity in your company tree. Next to the completion columns Organization, Scope 1, Scope 2, Scope 3 and Other, it shows the review state of the entity's answered values:
Approved — the value has been reviewed and accepted.
Not reviewed — the value has been answered but nobody has reviewed it yet.
Rejected — the value has been reviewed and sent back.
Approved, Not reviewed and Rejected together add up to the answered values.
Completion counts visible questions only. Questions left out by question assignment or hidden by form conditions do not count, and neither do empty fields.
Select Export status (Excel) to download the table.
Comparing answers across entities
Select View answers to open the answer matrix. Questions run down the page grouped by section, entities run across it.
The counters above the matrix show Answered, Approved, Not reviewed and Rejected. Narrow the matrix with the Entities and Items filters, or select Expand all to open every section.
Each cell shows the state of one entity's answer to one question:
A dash means the question applies but has no value yet.
Not visible means the question is not part of that entity's form.
A green tick means approved, a red cross means rejected.
A dot means the answer has a note.
Focus or hover a cell to see the details.
