Sense vs. Ecobee: Round II

Two final steps now that I have completed the month of July.

  1. I’m going to calculate the closest device correlations to both upstairs and downstairs Ecobee runtimes, by month.
  2. I’m going to look at the mix between good correlations, bad correlations and missing data for the Ecobee/device pairs that appear to be connected.

First the month by month correlations. NAs represent months where there was no valid data that the same time between the Ecobee and the device detections (one or both for that time period were NAs)

Upstairs
Initially AC and FurnaceUp devices correlate most closely with my Ecobee turning the AC on, but that’s based on very little air conditioning usage in April. AC2 shows up in May and begins to take over. Things are very mixed in in June, but that might be due to us putting more freon into the unit around June 11th. AC2 rises to top in July, perhaps because it is closer to the profile of my new more efficient compressor. I’m hoping that the signal / correlation gets stronger in August.

FurnaceUp stays closely aligned with Up_Cool through all the time because it’s using a smartplug. There’s bound to be a little mismatch because my fan/furnace is set to come on at least 5 minutes per hour, even when my Ecobee isn’t calling for AC.

$`2019-04`
               Up_Cool
AC           0.9848766
FurnaceUp    0.9769824
FurnaceDown -0.1541840
AC2                 NA
AC3                 NA

$`2019-05`
              Up_Cool
AC          0.9851462
FurnaceUp   0.9772373
AC2         0.1661719
FurnaceDown 0.1412279
AC3                NA

$`2019-06`
              Up_Cool
FurnaceUp   0.9892451
AC          0.7441818
AC2         0.7314602
FurnaceDown 0.5909811
AC3                NA

$`2019-07`
              Up_Cool
FurnaceUp   0.9850746
AC2         0.6176325
FurnaceDown 0.5118411
AC3         0.4237348
AC          0.3627760

Downstairs
Downstairs is easier to figure out than upstairs. All correlation with AC devices in Sense-land was pretty much coincidental until Sense “detected” AC3, which correlates very strongly with my Ecobee’s Down_Cool command.

$`2019-04`
            Down_Cool
AC                 NA
AC2                NA
AC3                NA
FurnaceUp          NA
FurnaceDown        NA

$`2019-05`
            Down_Cool
FurnaceDown 0.9645780
FurnaceUp   0.3849021
AC          0.2430033
AC2                NA
AC3                NA

$`2019-06`
            Down_Cool
FurnaceDown 0.9923947
AC2         0.7628676
FurnaceUp   0.6044697
AC          0.1213893
AC3                NA

$`2019-07`
              Down_Cool
FurnaceDown  0.98625399
AC3          0.97380936
FurnaceUp    0.51139072
AC2          0.42605800
AC          -0.08355149

NA Statistics for Downstairs
Here’s a table of Down_Cool and AC3 hourly values for the two different states of the Downstairs Furnace Fan running (IDLE and ACTIVE), after AC3 was first detected. Looking at the number or hours of detected vs. missed by Sense, I need to look for the places where the Furnace Fan is ACTIVE and the Ecobee runtime is POSITIVE. 207 hours of good detections, 31 hours missed. There might also be 7 false detections where Ecobee didn’t call for cooling but Sense saw some usage. I label this detection as “Pretty Good”. Let’s hope it continues into August !

11%20AM