⚡ 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

来源