Every activity/meter has the option to upload a mass amount of data from excel spreadsheets to it.
The Excel upload is intelligent as it can accept any format of spreadsheet. The user is simply asked to identify which columns contain data for the appropriate data fields. If the spreadsheet is missing some required data, the user can select an appropriate option from the default value list on the right. This mapping is then stored to make the process more efficient, next time around.
Step 1: Navigate to GHG Activity screen and select the Activity that you want to upload data to (C below), using the (A) treeview, selectors and (B) search filter.
Step 2: Once the activity is selected, in the activity or meter screen click on the “New Upload” button.
Step 3: In order to enable the system to process the data in the most efficient means possible, you must select between three options.
1 – Not meter Reading Data/Other Meter Reading Data/Gas Meter Reading Data - If users select Other Meter Reading Data or Gas Meter Reading Data this allows a user to input meter readings into the system. The system will automatically calculate the quantity consumed based on the previous and current meter reading. To bulk upload the meter readings tick select Other Meter Reading Data
2 - High Frequency Meter Data is used when dealing with energy data of multiple items of data per day, for example half hourly data.
3 - Low frequency data option is for data of a maximum one data point per week, for example monthly electricity bill.
Click Continue when the selection is made.
To see upload history click the Upload history button beside New Upload the next screen will display a list of all the previous uploads on the system. To view details of previous uploads including error messages click on that row. To view the previously uploaded file, click on the file name.
Step 4: The next step is the Checklist, this screen shows guidance on how to prepare your spreadsheet which you will be asked to upload in the next step. In particular, it gives information on each of the spreadsheet columns. Click continue when spreadsheet is prepared.
Step 5: The user can now upload their file by clicking Select, click continue once the file is attached.
Step 6: On the next screen select the correct sheet/tab from the uploaded excel file using the “Select Sheet” drop down menu at the top of the screen, as shown below.
Step 7: The software will then take a moment to identify all the column headers in the spreadsheet (see item A below), and put them in to a dropdown menu beside each of the database fields. The appropriate column header must be chosen from the dropdown to match the database field as shown below. This list will vary depending on the type of activity, the jurisdiction and the regional emissions factors requirements.
Step 8: If one of the mandatory database field does not match any column in the spread sheet, a default values can be set. This will set all rows to the value selected or entered in the default value field. As in the example above item B.
Once all of the mandatory fields are mapped and any mandatory “missing data” is given a default value, simply click on the finish button. Historical Mapping (C) saves previous uploads settings so users do not have to map the columns of the spreadsheet to the system each time.
Step 9: After clicking on the Finish button, the uploads progress screen is displayed. Here all uploads are monitored as they are uploaded, processed, validated, aggregated, and added to the database. If there is a problem, an error message will show up. To find out more about the error, simply click on the row. The status of each is represented in the progress column with % complete and a progress bar. Once the file is uploaded it is listed as complete.
Hint: In the Software you can have multiple uploads running simultaneously in the background. You can continue with other tasks as the software processes your uploaded files.