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:

FieldSuggested 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)

TimezoneDefaults to GMT
Data type

Choose the Degree Days (this will pre-fill the Channel Name

Unit of MeasurementChoose DD 
Conversion FactorDefaults to 1
Asset TypeChoose from the dropdown or leave blank
Meter ReadingsDo 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