Skip to content

Da House Kontrol, with Telldus

by Tore on October 14th, 2015

“Da House Kontrol”, made by Tore Aasli

This home control computer program is a beta version of what utilizes a set of Telldus components to control humidity, temperature and lights in my home from a Windows PC.

 

Da House control2

 

 

 

 

 

 

 

 

(Click on the images to enlarge)

While the program contains some more information than would be necessary in a production version, it’s still works as it should. It controls temperatures, humidity and lights in the main floor, and in the ground floor, temperature in the cold-storage chamber and humidity in the wash room.  The redundant information is for development purpose.

On top of the screen image is a database table that shows the status in these rooms. The database has columns to show the sensor’s ID (like 135, 183, 11 and 199 in my setup). These values are the same as those from the Telldus Center program which came with the Telldus Duo I bought. I also have a Telldus NET controller, connected to my in-house network infrastructure, but my own solution is more versatile.

Each of these rooms’ units have sensors connected. Sensors supply the computer program with temperature and humidity data. The sensor(s) for each controller has their own database which is shown in the middle and right in the window.  Units are on/off switches, or dimmers to control power.

This database table also has columns to control the Low Temperature, High temp, low and high humidity, time to switch on and off (for lights etc.). Here, “Stue Vest” (Living room West) which has the sensor ID of 183 has a temperature of 24.1 degrees and a relative humidity of 34 %. The date and time for the last update is also there.

Further down in my program window is an edit box where I can set the update interval. Here it’s set to 10 minutes.

On the right hand side (upper right corner) are two buttons for manually controlling the units (on or off). As of now, I don’t use light dimming (but soon to come! ).

This nifty program can also draw graphs

telldus graf-2

 

 

 

 

 

 

 

 

(again, some redundant development information (the table) which is to be removed in a production version)

This program is developed with Delphi, and use a SQLite database to store tables and data. SQLite is almost the same as MySQL and the program can easily be adjusted for a MySQL database.

If you like the program, you cannot have the source code. Otherwise I wouldn’t be a “wizard” 😉 .  But you could have my program (the EXE file). For a small fee, of course, to cover some of my expenses and outlays…  ;-)

Your comments are welcome. På et skandinavisk språk or in English.

 

Update (14.10.2015):

Added two new indicators:

  1.  The upper red arrow points to a timestamp for the next update, based on the update interval (ticking every second).
  2.  The lower red arrow points to the second update that shows how much electricy you are saving (Watts) when using this home control program, updated once every interval.

Here we can see that the next update is in 9 minutes and 23 seconds, and that the energy savings is 5400 Watts (5.4 kW).

(Planning to implement the energy cost, so you can see the savings in your own currency based on your electricity tariff: kroner, euros, etc.)

savings2

 

 

 

 

 

 

 

 

Update  15.10.2015

(Stardate 42293.0625810185)

Another update deals with coolers and cooling chambers.  These temperatures are logically opposite the temperatures in a living room.

Regarding a living room, temperature may be set to between 20 and 25 degrees C, for example.  If the temperature is below 20 degrees, the heater (panel oven etc.) must switch on.  And if the ambient temperature is above 25 degrees, heaters should be switched off to save on energy and your energy bills.

This normal living room situation is not the case for a cooler / cooling chamber.  Here you might set the temperature to the range of 2 and 5 degrees C for example.  Unlike the living room case, the cooler unit should be switched off when temperature is below 2 degrees, and the unit to be switched on (to cool down the temperature) if exceeding 5 degrees.

Hence, I have a new field in the database for these “inverted” circumstances, a boolean field which can and must be ticked for a cooler.

The situation is shown in the image below where the red arrow is. (This image shows just the area of interest from the above window dumps.

Cooler2

 

 

 

Your comments, questions or remarks are welcome (skadinaviask språk or in English).

(Oh, so you noticed the “star date”!  How do I compute a star date (and time) ?  Well, it’s accurate down to milliseconds.)

No comments yet

Leave a Reply

You must be logged in to post a comment.