Investigate a high power bill with interval data and a dashboard
At a glance
A household gave Claude utility usage data, appliance habits, and tariff information to build a Streamlit analysis dashboard. This workflow is listed under Money & Bills, Energy Usage, Personal Data.
- Agents / tools
- Claude, Streamlit, Duke Energy usage export
SourceBuilding a tool for these workflows? See weekly rates.
What they did
1) Download the granular usage export from the utility account. This household used Duke Energy data in XML with 15-minute intervals; running the resulting dashboard also requires a Python environment with Streamlit. 2) Give Claude the export and explain which major devices the home has, such as EVs and a washer/dryer, and when they are normally used. 3) Supply the household's energy-plan details and ask for a Streamlit dashboard to investigate the unusual bill and project usage over coming months. 4) Have Claude work with the XML structure and provide the generated app's launch instructions. Run it and open the dashboard in a browser. 5) Use its controls to explore usage assumptions and inspect the high-bill pattern, keeping the utility export and tariff as the reference inputs.
How it went
The commenter reported a useful dashboard after about twenty minutes of prompting.
Worth knowing
The comment reports diagnostic usefulness, without quantifying later bill savings.
