Power consumption in house. Use Labels

Details
Hits: 2248

I recently changed my home power connection from 3x230V (32A) to 3x230V+n (25A).  This had more impact than I originally anticipated on.

First of all, I have to change some of my breakers from 32A to 25A.  

Secondly, I had to rebalance the different phases in my breaker board.

As I need to make some changes, I would also update my breaker box to the newest AREI rules, stating that all internal devices needs to be protected by a 30mA differential breaker.

As I had almost all my devices monitored by a shelly device. I was able to see the power consumption per device.

Now, to rebalance the load, I needed to know what device belongs to what breaker.  On top, I wanted to know what breakers belong to what phase so we can balance evenly.

To solve this, I used Labels.

I created 2 type of  labels:

- 'Automaat X' (one for each breaker)

- 'Lijn Y' (one for each phase)

I attached these labels to the Shelly sensors in bulk by using homeassistant.add_label_to_entity service

Once combined I created a sensor for each "Automaat X" and "Lijn Y".

    - name: "Huidig verbruik in huis - Lijn 3"
      unique_id: 8d374087-28ea-479d-9da1-4803fe14b2e5
      device_class: power
      state_class: measurement
      state: "{{ expand(label_entities('Lijn 3')) | selectattr('attributes.device_class','defined') | selectattr('attributes.device_class','==','power')| selectattr('attributes.state_class','defined') | selectattr('attributes.state_class','==','measurement') | selectattr('state', '!=', 'unavailable')  | map(attribute='state') | map('float')  | list  | sum | round(0)}}"
      unit_of_measurement: "W"
    - name: "Huidig verbruik in huis - Automaat A"
      unique_id: 7a43a116-4e5a-4901-99f6-ded8063ba4c6
      device_class: power
      state_class: measurement
      state: "{{ expand(label_entities('Automaat A')) | selectattr('attributes.device_class','defined') | selectattr('attributes.device_class','==','power')| selectattr('attributes.state_class','defined') | selectattr('attributes.state_class','==','measurement') | selectattr('state', '!=', 'unavailable')  | map(attribute='state') | map('float')  | list  | sum | round(0)}}"
      unit_of_measurement: "W"
This would give me the the Power consumption per breaker and phase.
 
I left this running for a few weeks so I could see average an peak usage.   By changing the label assignment on "Lijn Y" I could simulate the re-distributed power consumption per phase and plan my the change on my breaker box.
 
Last week, I rebalanced all the loads and I make a visual representation of the current per breaker
 
I used a mushroom card to display the breaker name and info and calculated the current based on the power use.
      - type: custom:mushroom-template-card
        secondary: 'J - 20A - Buiten'
        primary: >-
          {{ ((states('sensor.huidig_verbruik_in_huis_automaat_j') | float() /
          230 )| round (2))   }} A
        icon: mdi:fuse
 
Next steps:
- Eliminate duplicate measurements:  I have some shelly devices behind other shelly devices.  This results in duplicate measurement of power.  I will create a label "Primary Use" to assign to the sensors to only count the usage of the primary device.
- As I have different breaker boxes, I have some breakers that have an aggregated use or are breakers in the source and destination box.  I need to change the labels to match the sources to calculate correct (Breaker H and I for example)
- Add color coding to the breakers.  Example 20A breaker, set green to 18A, orange 19A and red 20A.  
- Add solar installation and calculate "Rem Automaat" current
 
update 2024-05-30:
I added the label "Primary Use" and changed my templates:
    - name: "Huidig verbruik in huis - Lijn 3"
      unique_id: 8d374087-28ea-479d-9da1-4803fe14b2e5
      device_class: power
      state_class: measurement
      state: "{{ expand(label_entities('Lijn 3')) | select('in',expand(label_entities('Primary Use'))) | selectattr('attributes.device_class','defined') | selectattr('attributes.device_class','==','power')| selectattr('attributes.state_class','defined') | selectattr('attributes.state_class','==','measurement') | selectattr('state', '!=', 'unavailable')  | map(attribute='state') | map('float')  | list  | sum | round(0)}}"
      unit_of_measurement: "W"
    - name: "Huidig verbruik in huis - Automaat A"
      unique_id: 7a43a116-4e5a-4901-99f6-ded8063ba4c6
      device_class: power
      state_class: measurement
      state: "{{ expand(label_entities('Automaat A')) | select('in',expand(label_entities('Primary Use'))) | selectattr('attributes.device_class','defined') | selectattr('attributes.device_class','==','power')| selectattr('attributes.state_class','defined') | selectattr('attributes.state_class','==','measurement') | selectattr('state', '!=', 'unavailable')  | map(attribute='state') | map('float')  | list  | sum | round(0)}}"
      unit_of_measurement: "W"
I also assigned the labels of the duplicate breakers to match the source breakers total.

Comments powered by CComment

Main Menu

Login Form