Data Analysis · Smart Home · Southern Ontario

Home Energy
Dashboard

Live monitoring of a residential heat pump system and whole-home energy consumption. Data updates hourly from a local SQLite database fed by Sense, Daikin Skyport, Open-Meteo weather reanalysis, and Alectra Utilities billing records.

Utility Alectra Updated
Total HVAC kWh
heat pump + air handler, all time
Air Handler Share
of combined HP+AH consumption
Pearson r (AH vs Temp)
target: −0.65 to −0.80
Whole-Home kWh
Alectra metered, all time
Grid Carbon Intensity
gCO2eq/kWh · Ontario grid · live
Fossil Fuel %
Ontario grid generation mix · live
Air Handler ↔ Outdoor Temperature Correlation
Pearson r — last 60 days of hourly data
−1.0−0.65−0.150
Well staged −1.0 to −0.65
Marginal −0.65 to −0.30
Misconfigured −0.30 to 0
A properly staged system fires resistance strips only in extreme cold, producing a strong negative correlation (r = −0.65 to −0.80) between air handler wattage and outdoor temperature. The pre-fix reading was r = −0.145 (R² = 0.02), indicating the aux heat lockout was set to +10°C instead of −5°C. Post-fix values above −0.50 confirm correct staging.
Aux Heat Runtime — Full Heating Season
Hourly air handler wattage vs outdoor temperature · Nov 2025 – present · fix date: Apr 23, 2026
Pre/Post Fix
Pre-Fix AH Firing Rate
% of hours aux heat active
Post-Fix AH Firing Rate
% of hours aux heat active
Pre-Fix Avg Temp When Firing
°C · should be below −5°C
Pre-Fix Aux Heat kWh
resistance strip consumption
Vertical line marks fix date (Apr 23, 2026). Air handler wattage should trend toward zero post-fix except in extreme cold.
Pre-Fix: AH Wattage vs Outdoor Temp
Post-Fix: AH Wattage vs Outdoor Temp
HP vs Air Handler — Monthly kWh
Daikin Skyport data — heat pump and resistance strips
Daikin
Air Handler Share %
Resistance strip use as % of total HVAC — should drop post-fix
Post-fix trend
Whole-Home Daily Consumption
Alectra metered kWh — last 30 days
Alectra
Outdoor Temperature
Open-Meteo hourly reanalysis — Southern Ontario
Weather
Alectra Billing History
Electricity billing history
Alectra
Period Days Adj kWh Total Bill Rate Plan
Loading billing data…
Ontario Grid Carbon Intensity
gCO2eq/kWh — 10-day history · Electricity Maps via Home Assistant
CA-ON · Live
Fossil Fuel Percentage
% of Ontario grid generation from fossil sources — 10-day history
CA-ON · Live
TOU vs Ultra-Low Overnight — Rate Comparison
Supply charges only · OEB rates effective Nov 1 2025 · based on actual Sense consumption pattern
Computing…
TOU Total (supply)
your current plan
ULO Total (supply)
if you switched
Estimated Difference
supply charges over period analysed
Your TOU Consumption Breakdown
How ULO Would Classify Same Hours
Recommendations
OEB Rate Reference (supply charges only)
Period Hours (weekdays) TOU ¢/kWh ULO ¢/kWh
Overnight11pm – 7am9.8 (off-peak)3.9
Morning off-peak / ULO off-peak7am – period start9.811.5
Mid-peak (winter) / On-peak (summer)11am – 5pm (summer)14.4 / 20.311.5
On-peak (winter) morning7 – 11am20.311.5
ULO On-peak / TOU On-peak evening4 – 9pm (ULO) · 5 – 7pm (TOU)20.339.1
Weekends and statutory holidays = off-peak all day (TOU) or overnight/off-peak (ULO). Delivery, regulatory charges, and HST are identical on all plans.
Data Sources
Sense Energy Monitor (hourly device-level power draw) · Daikin Skyport cloud API (monthly HP + AH kWh) · Open-Meteo historical reanalysis (hourly temperature, Southern Ontario) · Alectra Utilities PDF bills (18 months, manually parsed + loaded) · Electricity Maps via Home Assistant (carbon intensity + fossil fuel %, zone CA-ON, 15-min polling)
Key Finding
Pre-fix Pearson r between air handler wattage and outdoor temperature was −0.145 (R² = 0.02), indicating the aux heat lockout was set to +10°C (Daikin default) instead of −5°C. Resistance strips were firing at mild temperatures, costing an estimated $730–$1,200/year in unnecessary electricity consumption. Issue resolved by Shipton's Heating & Cooling, May 2026.
Stack
SQLite database · Python (pandas, sqlite3, requests) · Windows Task Scheduler (hourly export) · Chart.js · Vanilla JS · Statistical analysis: Pearson correlation, regression, time-series decomposition