I'm looking into getting a battery system for my house, and want to size the battery to handle the usual usage between 4pm and 9pm, which is the peak price hours. Can anyone think of a way to get the average daily usage during just those hours from all the data I've been recording from my meter over the past year?
I'm interested in average kwh usage maybe month by month over the year, as well as peak kw pull so I make sure the battery can deliver enough watts and also last me past those hours.
I have all the data in home assistant, but don't really know a good way to analyze it.
#Getting average energy use during peak hours
terse summit
smoky void
I can't think of an easy way to do that with home assistant
but if you go to history and select your sensor, you can export all the hourly statistics
you can import that data into excel for example and do with it whatever you want
terse summit
Thanks, I ended up getting the entire database and opened it in a sqlite client app. Then gave up, downloaded the by-the-hour data from my electricity provider as CSV and just did a bit of excel gymnastics and got the data and graphs I needed to size my system.