Step 1: Navigate to the KPI screen by clicking on Analysis icon on the top of the screen and select “Key Performance Metrics” from the drop down menu.
Step 2: Select ‘Multi-Site Upload’ as highlighted below
Step 3: From the Multi-Site Upload screen that appears below, click on the ‘Select’ button, locate the file you wish to upload from your computer and double click on this file. Once this has uploaded, click 'Next' on the bottom right of your screen as highlighted below.
Step 4: Using the drop down buttons highlighted below select which sheet on your file you wish to extract the data from and which column contains a unique reference (eg. Mapping ID, MPAN, Cost centre number etc) , click 'Next'.
Step 5: Within the Column Matching screen below, map the fields in which the system requires (e.g. Start Date, End Date, Quantity, Metric Type Unit ID, Comment) with the column headers of the upload sheet for which the system will find the relevant information. When complete, click on 'Finish' to upload the relevant data.