Sigma Online User Manual
Creating Degree Day Associated Data
Introduction
Degree Day data can be added at the Root level, and then copy and pasted (using Paste Link) to individual Sites.
There are 18 Degree Day areas, some customers will need all of them (if they are nationwide), others will only need 1 or 2, depending on where their Sites are located.
The Standard Degree Day is 15.5'C (which we provide monthly figures on), but can also be:
5.5 Cooling
18.5 (Hospitals)
Degree days are a specialist kind of weather data, calculated from readings of outside air temperature. Heating degree days give an indication of the energy consumption required for heating (in cold weather); cooling degree days give an indication of the energy consumption required for cooling (in hot weather).
Once created, it can be viewed and updated in the Estate Management Activity.
In this section:
Creating the Degree Day Channel
The Channel is created at the Root level and then copied to each relevant Site.
Set up a Degree Day Channel for each of the areas your business covers.
- Open the Estate Management Activity
- Change the Data Selector from Item Finder to Tree Selector
- Right click on My Database
- Click Add
- Click Associated Data
The Associated Data Editor pop up appears:
Complete as follows:
Field | Suggested Value |
---|---|
Channel Name | Note: Complete this after you have chosen the Data type as it will default to whichever Data Type you have chosen Best Practice: Enter the Degree Day area, followed by 'Degree Day', for example Thames Valley 15.5 Degree Days |
Data Load ID 1 | Automatically generated. but if you are updating monthly with the figures produced by Team, change to, for example 1:Thames Valley (see below for more details) |
Timezone | Defaults to GMT |
Data type | Choose the Degree Days (this will pre-fill the Channel Name |
Unit of Measurement | Choose DD |
Conversion Factor | Defaults to 1 |
Asset Type | Choose from the dropdown or leave blank |
Meter Readings | Do not tick |
- Click OK to create the Degree Day
Repeat the above for all the areas you need Degree Day data for.
Data Load ID
Below are the Data Load IDs if you want to import the data monthly, using the data we publish monthly.
Enter the appropriate area code in the Data Load ID field on each Channel you are creating. (exactly as written below)
- 1:Thames Valley
- 2:South Eastern
- 3:Southern
- 4:South Western
- 5:Severn Valley
- 6:Midland
- 7:West Pennines
- 8:North Western
- 9:Borders
- 10:North Eastern
- 11:East Pennines
- 12:East Anglia
- 13:West Scotland
- 14:East Scotland
- 15:North East Scotland
- 16:Wales
- 17:Northern Ireland
- 18:North West Scotland
Copying to Sites
Once you have the Channel at Root level, copy it to the relevant Sites.
- From the Tree Selector, right click on the Degree Day Channel
- Click Copy
- Scroll down to the Site
- Right Click
- Click Paste Link (NOT Paste)
Manually adding the value to the Degree Day Channel
Generally, this would be updated monthly.
If you have multiple Degree Day areas, it maybe easier to use the download to update (see below).
However, if you only have 1 or 2 you may want to manually add the value each month. You do not need to add a value to each Site if you use the Copy and Paste Link option. Updating at the Root level will update all Sites with the same Data Load ID.
- Highlight the Degree Day Channel in the Tree Selector
- Right click > Edit to open the Associated Data Editor
- Click Edit Data to enter the value
- Click Edit Data to open the HFD Data Viewer popup
- Click Actions
- Click Add reading
- Click At end
The Add Readings pop up appears
- Amend the Start date to the date you want to start using the Degree Day data
- Ignore HFD Period (not required)
- Ignore Readings to add
- Click OK to return to the HFD Data Viewer popup
- Double click into the Value field and enter the Degree Day value
- Click OK to return to the Associated Data Editor pop up
- Click OK to finish
Importing Automatically
The Data Load ID in the Channel must be correct for the data to be uploaded successfully. (see above)
TEAM publish the 15.5 Degree Day data monthly on the Support webpage: Team Support
The file contains the last 10 years of data. It does not matter that you are uploading data that may already exist in the Channel, the file will overwrite what is already there.
Downloading the values
Once in the Support portal:
- Scroll down to Team Information
- Click on Announcements
- Click on the latest DD announcement
- Once in the announcement, download the text file and save
- The file contains all 18 Degree Day areas, but will only download the ones that you have set up on your database
Importing the file
Once you have downloaded the file, use Importing Activity to import the data.
As you have used the copy and Paste Link method, all Degree Day Channels with the same Data Load ID will be updated, ie all those Sites in the Thames Valley area that have a Data Load ID of 1:Thames Valley will be updated with the last ten years of 15.5 Degree Day data.
- Open Importing Activity
- Following the instructions in the Importing help files to import the file, using the Non-Periodic Importer
Viewing the Data
The data will be imported into all the Degree Day Channels.
To view at Root Level
- Open the Estate Management Activity
- Change the Data Selector from Item Finder to Tree Selector
- Expand Associated Data
- Right click on the Channel you want to view
- Click Edit
To view at Site Level
- Open the Estate Management Activity
- From the Data Selector, click on the Site
- Click Actions
- Click Manage Associated Data
The Associated Data pop up appears, showing the Degree Day is at Root Level (but has been copied and paste linked to this Site)
Click here for more information on the Estate Management Associated Data option
@ Copyright TEAM - Energy Auditing Agency Limited Registered Number 1916768 Website: www.teamenergy.com Telephone: +44 (0)1908 690018