Accumulated energy sensor per hour

Configuration
1

I’m trying to figure out how to create an Accumulated energy sensor per hour. I know about the utility meter, however the meter only updates once per hour. What I want is something similar, but the sensor should update constantly and then reset at every full hour. I think I might need an statistics sensor, but I’m out of depth on this one. So I was hoping for some ideas :slight_smile:

Background for the sensor is to use with new energy tariffs her in Norway where when we peak over thresholds (on a per hour basis) we get a more expensive tariff, and the idea with this sensor is to keep track of the current hour as it progresses to further utilize in some automations to cut of energy demanding components.

1 Like
2

Not sure where you got that idea. It updates whenever the source sensor updates.

1 Like
3

Sorry about that, came out wrong. My “upstream” sensor only updates hourly, so subsequently the utility meter also does that.

However I have an watt meter for the entire house (which updates every 10s), so I was thinking maybe I could base this of that?

4

Sure, feed the power meter to the Riemann Sum integration. Then feed the resultant energy sensor from that to the utility meter on an hourly cycle.

1 Like
5

Thanks! Thats it! :slight_smile:

For others finding this thread, solution is as follows:

# the sensor
- platform: integration
  name: energy_per_hour
  unit_time: h
  unit_prefix: k
  source: sensor.strommaler_power # this is my power meter for the entire house
  round: 3
...
# the utility
accumulated_energy_hourly:
  source: sensor.energy_per_hour
  cycle: hourly
2 Likes
6

So I let this sit for a few hours now and the results seems off? I’m comparing the energy dashboard towards the history of the accumulated_energy_hourly utility and as you can see its off by a few:

I completed the config’s and sensors/utility was online before 11:00 - so the measurements should be good hour to hour

Energy dashboard: 
11:00 -> 12:00 = 4,34 kWh
12:00 -> 13:00 = 4,12 kWh
13:00 -> 14:00 = 3,39 kWh
Utility sensor:
11:00 -> 12:00 = 4,13 kWh
12:00 -> 13:00 = 3,42 kWh
13:00 -> 14:00 = 6,11 kWh

Any idea as to why?

The sensor.strommaler_power is reporting every 10s, might there be an issue with timings?

7

Change the method of your Riemann Sum to left to reduce errors:

Screenshot 2021-12-04 at 00-05-50 Integration - Riemann sum integral
Screenshot 2021-12-04 at 00-05-50 Integration - Riemann sum integral730×175 6.48 KB

1 Like
8

Petro wrote a great post on the errors the Riemann Sum approximation of an integral can introduce and how to minimise them:

2 Likes
9

Thanks @tom_l, I’ll make sure to read it :slight_smile:

10

So I let this sit for a few days, however something odd. It seems the energy dashboard is one hour behind (in regards to the utility)? Eg for hours 00:00->01:00 this get accounted at 01:00->02:00 in the energy dashboard? See pictures:

image
image1579×625 48.6 KB

image
image617×546 5.13 KB

Otherwise the measurements seems to align pretty good (roughly the same between the utility and energy dashboard hour for hour, adjusting for the offset on the energy dashboard)

11

Feed the energy dashboard a daily utility meter. Let it count the hours.

12

Could you explain how to feed the energy to a daily utility meter? I am looking to have kwh consumption hourly, daily and monthly.

13

https://www.home-assistant.io/integrations/utility_meter/#configuration