Sigma Online User Manual

Example Tag CSV File for Importing Monitoring Points into Budgets

Creating Monitoring Points

If the Monitoring Points do not already exist, they will need to be created.

Click on the link below for more information:

Creating Monitoring Points

Creating the Tag CSV File for Monitoring Points 

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.


Monitoring Point Example Tag CSV File

                                                                


Example Import CSV File for importing Budgets using Monitoring Points (v2).csv

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


Explaining the Tag CSV File

                                                                 


ColumnRequirement
Column BOrganisation name
Column DSite Group Name
Column FSite Name
Column HMonitoring Point Name (same as Column K
Column JBudget Group Name
Column KMonitoring Point Name (same as Column H)
Column MTarget (leave blank if you want to use the same figure as the Budget
Column NStart Date of the Budget
Column OEnd Date of the Budget
Columns P to AAThe monthly Budget figures


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