Not sure if this is possible, hopefully it has been done already. I want to (over a period for example a week) to be able to accumulate and extract a log of a persons movements in a house and their device usage for analysis in excel. There is a genuine reason to want to do this not for big brother reasons.
2 x Smart plugs (Zwave or Wifi) that include energy usage tracking:
- Plug permanently connected to an iron which may be plugged in anywhere in the house
- Table lamp permanently connected
4 x Inline Switches (Zwave) that include energy usage tracking connected in wall behind wall power sockets:
- Double inline switch - Microwave & Kettle
- Double inline switch - TV & Foxtel
- Double inline switch - Playstation and TV
- Single inline switch - Cooker and Oven
2 x Water sensors
- Bathroom floor
- Lounge floor (storm floods)
2 x ibeacon transmitters on the person(s) being tracked
8 x ibeacon receivers (Happy Bubbles)
- Ensuite Master
- Entertainment room
I want to track in a log date and time and persons movement between rooms using ibeacon technology for example happy bubble and MQTT.
I also want to track in the same log data and time of specified device states / usage, for example I want to monitor when devices are switched on and off or if left on like TV / Foxtel capture the power consumption at regular intervals to see usage.
When all this data is available in a log then analyse in excel to track presence movement and device usage. Assumptions can be made that for example the person is in the room and that the iron + plug was being used between 11:20am and 12:12pm so they must have been ironing.
Example data format:
Date | Time | Entity | Previous State Date & Time | Current State Date & Time | Rooms + Presence of Person in Room|