⚡ Dad Complains About Electric Bill, So I Built Him an Energy Dashboard and Found the Panels Lied ⚡

Описание и применение

Создана панель мониторинга солнечной энергии, которая объединяет данные о производстве, счетах и потреблении, выявив неисправные инверторы и неверную ориентацию панелей, что объясняет высокий счёт за электроэнергию.

Задача

Dad’s electric bill was unexpectedly high, and the author needed a way to verify whether the solar panels were contributing to the cost.

Результат

The dashboard revealed that two microinverters were dead and several panels were underperforming due to incorrect orientation mapping, explaining a large portion of the high bill.

Рабочий процесс

• Collect per‑panel data from Enphase IQ Gateway every minute via local API
• Collect smart plug wattage from Home Assistant
• Fetch historical solar data from Enphase cloud API (free tier)
• Fetch bill data from ComEd Green Button export
• Fetch expected production from PVWatts
• Store data in Upstash Redis
• Generate AI briefing with Gemma 3 4B via Ollama every 6 h
• Publish dashboard on Vercel with password protection

Доказательства

Live data from our solar panels, straight from the Enphase gateway on our home network, every minute, down to each individual panel

Источник

Our actual electric bills from ComEd, combined with the solar data to work out how much power the house really uses

Источник

Gemma running locally on our home PC

Источник