Consumption Data is generally used for Scope 3 reporting. It is added into the Consumption Data Channel and then used in Energy Intelligence for reporting on.
If you want to add them in manually, move to the Entering Consumption Data Values in manually page.
This page shows how to enter Consumption Data Values in bulk:
You can have more than one Value and more than one Channel in the CSV File.
The CSV File will need to look like this:
This example has 12 Consumption Values for one Consumption Data Channel and the Columns are explained below.
You can have more than one Channel in a CSV File, add lines for your data for the first Channel, then your second, third etc
Column | Description |
---|---|
A | Consumption ID - this is the Data Load ID field in the Consumption Data Editor This number is unique to any other Consumption Data Channel. |
B | From Date - relating the Consumption Value. This needs to be in the following format: 01/01/2020 Note: Sigma uses the beginning of this date |
C | To Date - relating the Consumption Value. This needs to be in the following format: 31/01/2020 Note: Sigma uses either the beginning or end of this date, depending on the options chosen below - see Importing Options |
D | Consumption Value for the above period, for example: 200 |
Note: Before saving your data, remove the example line
The File is imported using the Consumption Data Importer CSV Importer, in the Importing Activity
Note: If the Consumption Data Importer CSV Importer is not in your favourites list, you need to add it using the green +
From the Importer Options section, tick or untick as necessary.
OR
Once you have clicked Finish, you can refresh the Activity to see if the File has imported successfully.
Once the File has imported and shows in the Run History, we recommend you check the Log File to see if there are any Validation issues.
Alternatively
Once the data has been imported it can be viewed in the Consumption Data Channel
If you create the CSV using the below formula and then UNTICK the Add day to date, the data will not import correctly: