Panel-Centric Energy Modeling: SPAN + HA + Utility Data Convergence

[cayossarian]

Vision

The SPAN panel sits at the physical center of every home's electrical system. When three complementary data sources converge on that foundation, the panel becomes the centerpiece of a comprehensive energy modeling platform — one that transforms raw data into actionable financial decisions for homeowners, installers, and utilities alike.

Three sources. One model. The panel at the center.

The Three Data Sources

1. SPAN Warehouse — The Panel's Own Record

The SPAN cloud warehouse holds what no other source can: deep, long-lived, per-circuit historical energy data recorded by the panel itself. This is the panel's memory — how energy has flowed through every circuit over months and years.

• Per-circuit consumption at high resolution (hourly or sub-hourly)
• Seasonal patterns spanning full annual cycles
• The ground truth for how this specific home uses electricity, circuit by circuit

This data uniquely enables direct derivation of usage profiles — diurnal load shapes, seasonal factors, duty cycles — from the panel's own historical record, with no intermediary required.

2. Home Energy Ecosystem (Home Assistant) — The Whole-Home View

The broader home energy context extends beyond the panel. Through HA's integration ecosystem, the model gains access to:

• Utility meters and solar inverters from any manufacturer
• EV chargers, heat pump monitors, weather stations
• Cross-device correlations the panel alone cannot observe
• Appliance-level data from smart plugs and energy monitors

HA provides the breadth — the full picture of how the home's energy ecosystem operates as a system, not just as a collection of circuits.

3. Utility Rate Structures — The Cost Lens

Energy data becomes financial data when paired with rate structures:

• Time-of-use tariffs and tiered pricing
• Demand charges and ratchet clauses
• Net metering policies and solar compensation rates
• Rate escalation trends and planned tariff changes

Without the cost lens, energy modeling is academic. With it, every watt-hour becomes a dollar decision.

What Convergence Makes Possible

No single source is sufficient. SPAN warehouse data alone misses the broader home context. HA alone has limited historical depth. Utility rates alone are meaningless without usage data. But when all three converge on the panel as the modeling hub, the result is greater than the sum of its parts:

• BESS Sizing — Evaluate battery storage against real per-circuit load shapes, TOU arbitrage potential, and demand charge reduction. Model payback periods using actual rate structures, not generic assumptions.

• PV + Storage Optimization — Overlay solar generation on actual consumption patterns, sized to this home's specific usage. Calculate self-consumption ratios, export value under current net metering rules, and sensitivity to rate changes.

• EVSE Impact Assessment — Model Level 2 EV charging against existing panel capacity and real load patterns. Identify circuits requiring load management. Quantify the incremental cost of charging under the homeowner's actual rate plan.

• Monte Carlo Simulation — Model scenarios across observed usage variability to build a forward-looking cost-benefit picture, producing ROI distributions rather than single-point estimates. Defensible numbers, not best-case projections.

• Whole-Home Electrification Planning — Model the cumulative impact of heat pumps, induction cooktops, EVSE, and storage on panel capacity, utility costs, and grid interaction — all grounded in how this home actually uses energy.

The Virtuous Cycle

Installers

Walk into a customer meeting with a data-backed proposal showing ROI for adding storage, PV, or EVSE to this specific panel. The model draws on the panel's own history, the home's full energy context, and the customer's actual rate plan. Close deals with confidence and precision, not rules of thumb.

Homeowners

See the financial impact of upgrades modeled against actual usage, actual rate plans, and actual home characteristics. Make informed investment decisions with quantified confidence intervals. Understand what an upgrade means for their home, not a generic one.

Utilities

Better-planned electrification means right-sized systems, managed demand peaks, and smoother grid integration. When homeowners and installers model before they build, the grid benefits from more predictable load growth — aligning with managed electrification goals.

The Platform Effect

Every modeling session reinforces the value of the panel as the foundation of the home energy system. The panel is not just hardware that distributes power — it becomes the anchor point for financial planning, system optimization, and expansion decisions. The richer the data flowing through the model, the more indispensable the panel becomes.

Current State and What Completes the Model

What exists today:

• The HA integration path is operational — recorder/statistics_during_period delivers 30-day hourly and 12-month monthly profiles to the simulator via Socket.IO. The HA ecosystem's breadth makes this path valuable in its own right.
• Utility rate structure modeling is in active development, with TOU tariffs and demand charges being integrated into the cost analysis engine.
• The simulator already clones panel topology and real-time state via eBus (Homie/MQTT), capturing circuit layout, breaker sizing, and live energy counters.

What elevates the model from good to comprehensive:

When SPAN warehouse data becomes accessible via API, the model gains the depth dimension — long-lived, high-resolution per-circuit history from the panel's own record. The combination of HA breadth, warehouse depth, and utility cost modeling produces a platform that no single data source could support alone.

A warehouse API with the following characteristics would complete the picture:

Attribute	Detail
Scope	Per-panel, per-circuit historical energy data
Resolution	Hourly or sub-hourly (15-minute ideal)
Retention	12+ months for seasonal accuracy
Data fields	Energy consumed (Wh), power (W) min/max/mean per interval
Authentication	Existing panel registration flow or OAuth
Format	JSON, paginated for large date ranges

This does not need to be a real-time streaming endpoint. Batch retrieval of historical data is sufficient — the modeling workflow is analytical, not operational.