#Energy over varying periods + dynamic cost calculation
obsidian sapphire
There is the derivative integration and the utility...
but both demand a fixed period for the delta (1hr along with the energy price update is fine).
But if I want to look at a bigger timespan I'd have to sum them up again?
grand ember
Have you seen what energy dashboard can do?
obsidian sapphire
Energy over varying periods + dynamic cost calculation
OH DAMN
But... is there any way to use those values and add another view for cost? Especially with dynamic price?
grand ember
not really, it is what it is and it can't really be extended or repurposed
you can't "get" any values out of it for anything else, other than just to view it
obsidian sapphire
I can download a csv with hourly data - per day... but that doesn't really help...
obsidian sapphire
Soooo... that means I'd have to create something myself...
I'm thinking about a price sensor (template) for each energy sensor that
- each hour (ideally at XX:59:59) calculates
- current energy minus energy 1hr ago
- multiplicates with the current energy price
Most obvious hindrance is: how to get to the energy value of 1 hr ago? Save it in a helper (again 1 helper for each sensor) ? or an SQL sensor (again 1 additional sensor per energy sensor) ?
With this many necessary entities, I feel like this should maybe become its own integration...
grand ember
If you have the power sensor, you can multiply the power times the dynamic cost/kWh. This gives you a live $/h sensor, and then if you riemann sum that sensor, that gives the total cost.
obsidian sapphire
But only the total... I'd like to be able to look at different time periods though...
I'd also need to create a template sensor for each power sensor, but I guess that can't be avoided.
The increasing cost is still a better sensor than power and price seperated.
Any idea though how I can fill in historic values? (If I create the sensor now, I can't check the last month...)