ChatGPT and the Electric Bill Whisperer - How to Upload Your Bills and Watch Tariff Magic Happen
I will do a little experiment and let ChatGPT also write this blog post. I have made minor edits to ensure it aligns with the screenshots, but this is not me! A few essential items before we dive in: I am using GPT4 with Data Analysis through a paid account I work in the energy space, so I knew basically what I was trying to do with the prompts The Consumers website could have done this analysis in precisely 3 clicks through their portal, so I saved little time Yes, we use a ton of electricity! We have a large geothermal system, 22kw solar array, and 26kw of batteries in the basement. We also have 2 Electric Vehicles and a manufacutring shop on the land. ChatGPT Shortcomings: There is no confidence rating here. You ask the model; it gives answers. Are those answers correct? Sometimes. There is a fallacy that you upload and ask away. In another exercise, I needed to go back and validate the PDF breakout, and the table read needed to be corrected. Verify everything. For a site-by-site analysis, this works great, but scaling this would require API integration. Back to my first point here, you would trust that automation wholeheartedly. As technology advances, the ability to quickly ingest and distil complex tariff documents will be a net positive to the energy industry. We are close, but not there just yet. Steps I used to complete this exercise: I went to GreenButton Connect for Consumers and downloaded my interval and billing data. I tried using some lower-level interval data from my parallel metering, but it was too small of an interval to process correctly. Downloaded the latest tariff book for all Consumers Energy rates. Logged into ChatGPT, selected my GPT4 analysis mode and provided the prompt - How does my utility bill compare to other people in Michigan? before starting to have it evaluate the usage against the tariff specifically. Reviewed the Python code and processing You can see the entire chat minus the actual code here: ChatGPT Chat Prompts ...