Support Center

HOWTO: Import historical degreedays from

Last Updated: Aug 27, 2013 05:00PM CEST
Sometimes it's usefull to analyse our energy consumption comparing with heating and cooling degree days in order to see if our systems reacts correctly with external conditions. 

Introducing historical degree days data into DEXCell Energy Manager it's pretty easy. Let's see how!

First of all we need to create degree day parameters into our account and the degree day virtual meter for our location. To do that, we need to sing up a virtual weather station  and to configure location reference temperatures. 

Then we need to wait until next morning, when DEXCell Energy Manager engine procedures will create our "virtual degree day meter" for our location. Now it's time to introduce historical data!

Now it's time to go to website and download historical data from the same weather station we selected from wunderground. allows you to download until 36 months of storical data for free. Sometimes your desired weather station doesn't has enought historical data, so we advise to take Airport Weather stations if this occurs.

We need to select our weather station by writting the city or the weather ID, then select if we want Heating or Cooling degree days, Celcius or Farenheit, the base temperature (16ºC) and the frecuency (daily). Then select the range of time we want and click on "Generate Degree Days".


Once the file is generated we can dowload it by pressing "download" button at the top of the page:

Now repeat the process to obtain "Cooling" degree days.

Once we have both Heating and Cooling degree days excels, it's time to put all this information into a DEXCell Energy Manager Excel template, with the correct parameters and device identificator. You can check the parameters here and the device ID editing the gateway that has the main load, on "Devices" tab:

The device ID it's usually "DD-XXXX" and parameters are:
  • 18026 - Cooling Degree Days
  • 18126 - Heating Degree Days
  • 18226 - Mixed Degree Days (sum of cooling and heating)
Now we simply need to copy and paste data to the template, save and upload it!

Here you can see an example of how the spread sheet looks like:

Se how to introduce data from EXCEL spreadsheet here.


Contact Us

  • Post a Public Question
  • Email Us
  • Tel : +34 931 810 195
    Hours: 9am - 6pm CEST, Mon to Fri

    Check Public holidays here

seconds ago
a minute ago
minutes ago
an hour ago
hours ago
a day ago
days ago
Invalid characters found