Data from home – setup and preliminary results (Part 1)

Being environmentally friendly and economical are easy reasons for this story. Of course the motto of this blog applies – “Just Because I can”! And even further – “Engineers view to the world”. Most of the people won’t see any value for this but hopefully you will find it as interesting as I do. I am planning to write a series of posts around this topic. This first post is about the setup and some preliminary results.

In our last house I started playing around with the home automation a couple of years ago. We had remotely controlled heatpumps, sophisticated energy metering and temperature meters. I used Azute IoT Hub, PowerBI and a couple of other components to achieve a near real-time dashboard like shown in the picture.

PowerBI: Daily values for heatpump avg. input power (kW), electricity cost (€) based on hourly spot electricity price, inside temperature for two floors (C) and outside temperature (C) from Finnish Meteorological Institute API

After moving to our current house I wanted to do something more. In my mind I had the following requirements:

  • Data: Energy (electricity and heat), temperature and water meters, leak detectors
  • Functionality: Meter data collection and reporting, protection against water leakage
  • Non-functional: Opensource software running locally

After getting nowhere for the two first years I have finally made some progress. I’m running all this on Intel NUC based WMware Free Hypervisor. OS for this case is Ubuntu. I have been playing around with this for roughly a month now. I’m pretty happy with where I am now, considering that almost every component was totally new to me. Current setup consist of the following:

All of the above software has quite good documentation available, so setting it up was doable, although not that easy for me. After recording the data for a couple of days my data looks now like this. I am going to go deeper in to the details in the upcoming posts. Feel free to leave me comments, questions or ideas!

Cost dashboard: Today’s cumulative cost, 24 hours costs stacked and usage on each domain separately
Water dashboard: Meter reading with flow representation, hourly usage for past 24 hours and daily usage for past month
Electricity dashboard: Current load per phase as percentage of fuse size, stacked power per phase, separated power for heat pump combined with room temperature, per phase voltage and system frequency

You can find the next part of this series here:

Data from home – wireless water meter (Part 2)