HVAC control using database with previous records

Hi all, I rent an apartment that is really bad isolated. This means that the wind strength/direction and temperature outside has a lot of effect on the duration to heat up my house. Last year I installed a smart thermostat so i could heat up my house before I woke up and before I got home. Everytime it got colder extending the time between arriving back home and starting the heater. But not thinking about the days that weren't so cold. Resulting in heating up my house way to early most of the time.

What i want to achieve is for my heater to be smarter using a database. First write in a database the wind strength and direction, temperature outside, temperature inside. heat up the house to 20 degrees and save in the database how long it took to heat the house. Next time the heater wants to heat the house. Look for the same values as for the current condition. If it can't find it. Take the closest to the current condition, write a new line with the values of the current condition and the time it took to heat the house. If it finds the same values as current condition use those. resulting in a full database on when the heater should start heating.

if someone can point me in the right direction in how to set this up would be really appreciated. i really don't know where to start.

This post timed out.

i figured it out. using a csv file so i can easily read the values. everytime when my heater turns on or the room temperature falls below the set temperature i write the temperatures and the time it took the heater to heat the room to a csv file. i then read the csv file and check for the best match for how long it needs to heat. over time this will get way more accurate as it collects data.

1 Like