To upload multiple meters and buildings you must prepare the spreadsheet before to ensure a successful upload.
The excel sheet needs to contain information on the Building you want to assign the meters to/or if you want to create new buildings alongside these meters and the meter information.
Building Information
Parent Org Node: This is the parent node and location/path for the Building/Meter. For example /Brendan's Bistro/UK Sites/Restaurants this means the parent node is Brendan's Bistro with UK Sites underneath and then the Restaurants.
Building Name: Name of Building.
Industry Sector: Select from the following options Energy, Manufacturing, Construction, Commercial, Institutional, Residential, Agriculture, Forestry and Fisheries.
Site Name: Same as building name.
Address 1: The Building address.
Address 2: The Building address.
City: The city the Building is in.
Region:The region the Building is in.
Country: The country the Building is in.
Zip Code: Post code
Reference ID: A unique reference number for the Building.
Description: Building description for example storage unit.
Meter Information
Name: Meter name for example Electricity Meter one.
Reference ID: A unique reference number for the Meter.
Serial Number: Meter Serial number
Utility Type: Gas/Electricity/Water
Meter Type: Options are Electricity Meter, Electricity - Half Hourly Meter, Electricity Mandatory Half Hourly Meter, Electricity - 5-8 Profile, Electricity - Other Core, Electricity Voluntary Half Hourly Meter, Electricity Dynamic Pseudo HHM, Electricity Passive Pseudo HHM, Electricity - Light Meter, Electricity - Other Residual, Profile 00, Profile 01, Profile 02 , Profile 03, Profile 04, Profile 05, Profile 06, Profile 07, Profile 08, Electricity HHM (non settled), Unknown.
Unit: Options include kWh, Cubic Metres, Litres, Kilolitres, etc...
UK CRC: Choose from options Yes/No
CRC Exemption Type: Options include Not Applicable, Unconsumed Supply, EU ETS, CCA, Domestic Accommodation, Transport, Self Supply. Unassigned Meters, Sold, Disaggregated, Other, Dynamic Psedometer, Passive Psedometer, Profile 01 – 02, Non Heating use, Electric Generation, Electricity Generated Credit, Size Exempt - Manually Set, Out of Scope etc.
Note:This information must be on one sheet of the excel document. You can choose a default option in the system if you are missing a section for example CRC Exclusion Type default options available in the system.