Shelly 3EM 3-phases Energy sensor

Configuration
56

The is_number approach to availability is pretty neat!

And thanks for others as well in this topic. I was quite stuck with the false readings and couldn’t find out what was the problem with my calculated sensor.

Anyways, my code is as follows now:

  - platform: template
    sensors:
      total_main_energy:
        friendly_name: 'Total Main Energy'
        device_class: energy
        unit_of_measurement: "kWh"
        entity_id:
          - sensor.phase_1_energy
          - sensor.phase_2_energy
          - sensor.phase_3_energy
        value_template: "{{ (states('sensor.phase_1_energy')|float +
                             states('sensor.phase_2_energy')|float +
                             states('sensor.phase_3_energy')|float )|round(3) }}"
        availability_template: >-
          {{
            is_number(states('sensor.phase_1_energy')) and
            is_number(states('sensor.phase_2_energy')) and
            is_number(states('sensor.phase_2_energy'))
          }}


  - platform: template
    sensors:
      total_main_energy_returned:
        friendly_name: 'Total Main Energy Returned'
        device_class: energy
        unit_of_measurement: "kWh"
        entity_id:
          - sensor.phase_1_energy_returned
          - sensor.phase_2_energy_returned
          - sensor.phase_3_energy_returned
        value_template: "{{ (states('sensor.phase_1_energy_returned')|float +
                             states('sensor.phase_2_energy_returned')|float +
                             states('sensor.phase_3_energy_returned')|float)|round(3) }}"
        availability_template: >-
          {{
            is_number(states('sensor.phase_1_energy_returned')) and
            is_number(states('sensor.phase_2_energy_returned')) and
            is_number(states('sensor.phase_2_energy_returned'))
          }}

But now I have a question, how to correct the data on my energy dashboard?

Screenshot 2021-11-20 at 10.31.42
Screenshot 2021-11-20 at 10.31.421726×932 80.4 KB

I would be ok if i can just delete those few “bad” days or at least the peaks.

3 Likes
57

I would like to know that as well, how to delete just a few bad days/readings.

What the benefit with the “is_number”?
My sensor looks like this:

    hd_total_energy:
      friendly_name: 'HD total energy'
      unique_id: '47962c0d-e871-465f-ab89-b3810d399416'
      unit_of_measurement: 'kWh'
      device_class: energy
      value_template: "{{(
        (
          states('sensor.hd_energy1') | float + 
          states('sensor.hd_energy2') | float + 
          states('sensor.hd_energy3') | float 
        ) | round(2)
      )}}"
      availability_template: >
        {{ states('sensor.hd_energy1') not in ['unknown', 'unavailable', 'none'] and 
          states('sensor.hd_energy2') not in ['unknown', 'unavailable', 'none'] and 
          states('sensor.hd_energy3') not in ['unknown', 'unavailable', 'none'] }}
58

I found a way to reset/delete faulty values with success! Have a look here.
https://community.home-assistant.io/t/energy-management-in-home-assistant/326854/455?u=thelordvader

59

Just shorter code, nothig else. “not in [‘unknown’, ‘unavailable’, ‘none’]” vs is_number

1 Like
60

I have a docker installation of HA, so need to find out how to install SQLite Web…

EDIT: It was pretty easy. Just add sqliteweb to docker compose yaml and voila.

  sqliteweb:
    image: tomdesinto/sqliteweb
    ports:
      - 8089:8080
    volumes:
    - ${USERDIR}/docker/homeassistant/home-assistant_v2.db:/db/home-assistant_v2.db
    command: home-assistant_v2.db
1 Like
61

Thanks for the is_number recommendation!
I’ve updated the original post at the top of this thread to include it.
Here is how the sensor looks now (IMHO, quite clean):

template:
  - sensor:
      - name: "Energy Total"
        unique_id: energy_total
        state: >-
          {{ 
            [ states('sensor.phase_a_energy'), 
              states('sensor.phase_b_energy'),
              states('sensor.phase_c_energy'),
            ] | map('float') | sum
          }}
        availability: >-
          {{ 
            [ states('sensor.phase_a_energy'), 
              states('sensor.phase_b_energy'),
              states('sensor.phase_c_energy'),
            ] | map('is_number') | min
          }}
        unit_of_measurement: kWh
        device_class: energy
        state_class: total_increasing

(Note: the “min” filter returns False if one the elements in the list is False. If all elements are True, it returns True.)

3 Likes
62

Hi,
One quick doubt : If the Shelly 3EM allows to monitor 3 lines, I could buy and install 2 Shelly 3EM to monitor 6, and so on, right ?
I have the main line and 6 sub-lines I’d like to be able to monitor independently, that would mean 14 CTs to install, I’m not sure this module would be the best / most affordable way… But I am a newby in electricity monitoring so…

Thanks

63

Yes, you are correct.
I have currently 3 Shelly 3EM. They measure one heat pump, a two log houses independently. To measure the property’s total grid/import/export I use modbus via the my SolarEdge inverter and a meter connected that way.

1 Like
64

Ok so I guess I’d also need 3x 3EM for 9 circuits all in all (I have 1 phase at home). Main circuit from public network and 8 sub-circuits in house.
I would not know how to use the modbus but I guess I wouldn’t have to anyway as I would only be monitoring the circuits the simple way (one CT for each, 3 circuits on each 3EM, all of that going to HA and configuring HA to make sense of all the data).

Are there good tutorials on how to connect everything ? I’m no electrician but it does not seem so complicated (apart from knowing where to connect each cable on N, VA, VB, VC, I and O)

65

@amitfin You seem pretty familiar with the 3 phase version. Can you explain what it going on with mine?

Why is there ‘energy returned’? I have no solar or anything like that .
Why is power negative sometimes ?

Is my house wired wrong?

shelly 3phase

66

@ianadd, the wiring is probably wrong. My bet is that VA, VB, and VC are not synchronized with A, B, and C.
I’ve asked a question about 3EM wiring, and you can find in the comments the relevant explanation (here).

67

Thanks, I’ll try asking questions there.

68

A small amount of returned energy can be leaked, if you have (like me) a heat pump or something with an inverter connected to the Shelly 3EM. That’s inevitable. But in your case try to just turn the clamps the other way…?

69

If the clamps were the wrong way round then surely the reading would always be negative. But I can get negative and positive power values on the same channel depending on what I am using. Current and volts always show positive. The shelly app shows the same problem. The issue is not in HA.

70

@amitfin Having re-read your comment I am going to have to check if the wiring is mismatched between clamps and the device’s three supply lines.

71

Anyone have installation of 3EM with 4th clamp? I have installed one on neutral to detect possible leakage, but I do not see it anywhere in HA or even not in Shelly web interface. Any special process to ‘activate’ this feature?

72

OK, the alignment of the power feeds to the clamps sorted the negative numbers.

Still got energy returned sensors showing data. Can’t see that info in shelly app tho’.

Any ideas?

I am in an apartment block and each unit has a separate meter. So I will go read our meter a couple of times next week and see how well it agrees with shelly.

73

Great to hear! How much returned energy are we talking about?

74

Should’t that be Watt?

75

kWh is correct