After setting up the Multi-Site upload, you are ready to upload a spreadsheet filled with data for many activities which is attached to many different assets/buildings.
Step 1: Click on the "Multi-Site Upload" button in the drop down menu under the Data Management icon at the top of the screen as shown below.
Step 2: Select the activity category for which the spreadsheet contains data. Note, you can have one activity category (Business Travel, or Stationary Combustion etc.) only by spreadsheet upload, but you can have multiple activity types (flights, rail, car or Natural Gas, Oil, Kerosene etc.) per spreadsheet.
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 3: In order to enable the system to process the data in the most efficient means possible, you must select between three options.
A – Select Other Meter Reading Data from the drop down 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.
B - High Frequency Meter Data is used when dealing with energy data of multiple intervals of data per day, for example half hourly data.
C - 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.
Step 4: The next screen provides a checklist for the user to set up there spreadsheet, once the spreadsheet is complete, click continue.
Step 5: The user can now upload there file by clicking Select to browse for your file, click continue when finished.
Step 6: On the next screen select the correct sheet from the uploaded excel file using the “Select Sheet” drop down menu at the top of the screen, and unique Reference ID as shown below. Click continue when finished.
Note: If you have not already assigned the unique mapping ID (MPAN/MPRN number) in your spreadsheet to an activity, the system will prompt you, allowing you to drag the unique ID number to the correct activity as shown below. The system will state “Your data file has some unique mappings which are unrecognised by the system. Either update you data file with recognised Activity ID Mappings, or assign the unrecognised mappings on the right to the activities below by clicking and dragging”.
Step 7: The software will then take a moment to identify all the column headers in the spread sheet, 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 data base field as shown below. This list will vary depending on the type of activity, the jurisdiction and the regional emissions factors requirements.
Follow Steps A and B as shown below:
A: Map each of the database fields to the appropriate spread sheet column headings above.
B: Supply a default value if the required data is unavailable.
C - If this format spread sheet has been used before, you can use the "Apply Historical Mapping" link at the top of the screen to select from previous mappings to expedite the process. Click the Finish button when all columns have been mapped. When the Finish button is clicked any mandatory fields that are missing data will be highlighted.
Step 8: After clicking on the Finish button the uploads progress screen is displayed. As the file is uploaded, the software validates the data within it, checks for inconsistencies and will stop with an error if any erroneous data is detected.
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.
Note 1: Once the progress indicator goes to 100% you will see your data in all of the relevant activities.
Note 2: If an error occurs, regardless of the type of error, zero of the data is applied to the database.
Hint: You can have multiple uploads running simultaneously in the background. You can continue with other tasks as the software processes your uploaded files.