Sigma Online User Manual

Example Tag CSV File for Importing Meters into Budgets


Linking a Cost Definition to a Meter

If you are using Meter Data, you will need to link a create a Cost Definition under the Site and link the Meter to it.

Click on the links for more details:


Creating the Tag CSV File for Meters in one Site Group

If you want to set individually monthly figures, you can create the Budget, then use the Importing Activity to add the figures.

It is important to fill out the CSV correctly to avoid creating incorrect data.  Use the below guide to help you:

  • The Black writing indicates the Tags or default values  (Do NOT change)
  • The Red writing indicates data that you will need to add

Note:  The file can have as many rows as you need

Remember to save the File as a CSV in order to import it.

Meter Example Tag CSV File


                             


Example Import CSV File for importing Budgets for Meters V2.csv

Note:  Click on the link above, then click  and click on to download the CSV file.

Explaining the Tag CSV File

                              


ColumnRequirement
Column BOrganisation name, ie TRAINING ACADEMY
Column DSite Group Name, ie Local Authority
Column FSite Name, ie LA Dixon Control Centre
Column HMeter Name  (same as Column K), ie 1900037000698
Column JBudget Group Name, ie LA Group Metered Budget
Column KMeter Name  (same as Column h), ie 1900037000698
Column MTarget (leave blank if you want to use the same figure as the Budget), ie -5
Column NStart Date of the Budget, ie 01/04/2020
Column OEnd Date of the Budget, ie 01/04/2021
Columns P to AAThe monthly Budget figures, ie 6975.68


Importing the Tag CSV File

Return to the Budget Creation - Importing Individual Budget Figures page for details on how to import the CSV File.


@ Copyright TEAM - Energy Auditing Agency Limited Registered Number 1916768 Website: www.teamenergy.com Telephone: +44 (0)1908 690018