Sounds like an interesting experiment.
A quick snapshot of my setup.
A few ideas:
- I’m going try the same for all my TP-Link smartplugs. I only have one KP115 and my usage of it today is a little non traditional.
- I’m going to work backwards instead - look for Sense outages over past history, then try to see if I can diagnose.
- Unless Kasa/TP-Link has some hidden logging or one diddles deeply with IFFFT, I’m not sure there is a good way to get good info on when Kasa sees dropouts… Sense on the other hand is very good at showing dropouts that last more than an hour via export. Plus one can actually spot shorter dropouts in the Device Power Meter. Here’s how to find dropouts from an hourly export file using Excel - oddly, I discovered several devices/smartplugs that have gone offline this very morning.
- Read the Sense exported data into Excel and select the the column names and data below. Create a Pivot Table from that data.
-
Configure the Pivot Table as shown on the far right - DateTime for rows, Name for column and Sum of kWh for entries.
-
Select just the devices on smartplugs from Column Labels menu. I’m only going select one of the 5-6 devices on each of my 3 HS300s.
-
Look for any empty cells in the Pivot Table. Those are the entries where Sense missed an entire hour worth of smartplug data. I can see 3 issues and one normal “error” from this data. 1) Two of my HS300s look like they haven’t reported in the last hours, the one in Family Room, and the one feeding the media for our Master Bedroom. 2) My Washing Machine HS110 appears to be fairly intermittent. 3) My Roamer KP115 looks intermittent, but that’s a smartplug that I turn on and off via the switch and Sense “button” - it’s actually still when I look at the Sense Devices list (‘off’, not ‘n/a’). So blanks can stem from either disconnects or intentionally off smartplugs.
