Enphase Envoy with Energy Dashboard

[del13r]

ok, what about Dev tools.

[username11384]

Here’s my export

and import

[del13r]

Looks perfect to me.

Tried restarting HA?
Thats all I can really suggest sorry.

[username11384]

All good, thanks for your help!

Maybe I’ll try to collect some more data and try again, or make another HA VM and redo it

[del13r]

@username11384

try again, or make another HA VM and redo it

Yeah, My HA did some weird stuff with calculating price since upgrade.

[username11384]

I can try to rollback to the previous version that I had

[del13r]

@sjhosier1

  - platform: integration
    name: Grid Import Energy
    source: sensor.grid_import_power
    unit_prefix: k
    unit_time: h

This looks good.

@sjhosier1

  - sensor:
        name: Grid Import Power
        state_class: measurement
        icon: mdi:transmission-tower
        unit_of_measurement: W
        device_class: power
        state: >
            {{ [0, states('sensor.envoy_current_power_consumption') | int - states('sensor.envoy_current_power_production') | int ] | max }}
        

This also looks good.

I have no idea.

[mistrovly (Marc-Edouard Louis)]

Probably the reason why you can’t read power/energy consumption from your system, it’s because net metering is not enabled when your system was installed. I’m on the same boat too, when mine was installed they didn’t enable that feature for me. A couple weeks ago i called them up and asked about that feature; the asked me $500.00 to make it happen. Now if you know or have the installer username/password, you can enable it by yourself. Me, i don’t know or have the installer username/password for mine.

[del13r]

If anyone is interested in why my costs stopped working as soon as 2021.9 upgrade completed, I made a guide on why it happened and how I fixed it.

Energy Dashboard cost/compensation calculation stopped working when I upgraded to 2021.9

Hi, I noticed my cost calculation in Energy Dashboard stopped working as soon as I upgraded to 2021.9 as shown in the image below: [image] This feature was previously working fine in 2021.8. I did some troubleshooting and found out why. This is a post mortem of how the issue was caused and how I fixed the issue. How the issue was caused: When Energy dashboard launched in 2021.8, I had not yet changed my currency from the default EUR under Configuration / General / Currency. My local curr…

[dgaust]

@mistrovly

Me, i don’t know or have the installer username/password for mine.

Create one using the tool from here

GitHub - vk2him/Enphase-Envoy-mqtt-json: Takes real time stream from Enphase...

[sjhosier1 (Hosier)]

Thank you for posting this! I used this to go update the sensor that I couldn’t see in the Energy config directly in the database to kWh. It showed correctly everywhere but in the database it was still NULL. As soon as I did that it showed up in Energy configuration. I had tried everything else and if I hadn’t seen your post I don’t think I would have ever gotten it fixed!

[del13r]

Hi @sjhosier1,

Wow, that is amazing. Yeah I was stumped with your issue. Perhaps that is what @username11384 is suffering from too.

[del13r]

Hi @username11384

Please have a look at the content of the table statistics_meta in the SQLite Web add on and look for any unit_of_measurement that is either NULL or otherwise does not match what it should be.

[username11384]

mine does, indeed show NULL under sensor.grid_import_energy

[del13r]

You need a hand fixing it?
Execute this query.

update "statistics_meta" 
set unit_of_measurement = 'kWh’
where id = '25'

[username11384]

I just got a syntax error when executing that

[username11384]

UPDATE
Thanks, I got it working in the end by updating the SQLite DB!

[del13r]

what was the issue with the syntax?
was it 25 instead of ‘25’

[username11384]

I just restarted HA, did the query again and then it worked

[del13r]

I’ve just added another sensor to show me the total inclusive of daily service charge for the quarter based on when utility meter was last reset

  - sensor:
      - name: Quarterly Energy Total Cost
        device_class: monetary
        state_class: measurement
        unit_of_measurement: AUD
        state: >
          {{ (states('sensor.quarterly_energy_peak') | float * (0.541145 * 0.75) +
              states('sensor.quarterly_energy_shoulder') | float * (0.277145 * 0.75) +
              states('sensor.quarterly_energy_offpeak') | float * (0.177045 * 0.75) +
              states('sensor.quarterly_energy_export_buyback') | float * -0.095 +
              ((1.0439 * 0.75) * ((now() | as_timestamp | int - state_attr('sensor.quarterly_energy_offpeak','last_reset') | as_timestamp | int) / 86400 ) | int )) | round(2) }}

I then made another 2 sensors for bill forecast and average cost per day

  - sensor:
        name: Average Cost Per Day
        state_class: measurement
        unit_of_measurement: AUD
        device_class: monetary
        state: >
            {{ (states('sensor.quarterly_energy_total_cost') | float / ((now() | as_timestamp - state_attr('sensor.quarterly_energy_shoulder','last_reset') | as_timestamp) / 86400)) | round(2) }}
  - sensor:
        name: Bill Forecast
        state_class: measurement
        unit_of_measurement: AUD
        device_class: monetary
        state: >
            {{ states('sensor.average_cost_per_day') | float * ((state_attr('input_datetime.summer','timestamp') | int - state_attr('sensor.quarterly_energy_shoulder','last_reset') | as_timestamp | int) / 86400) | round(0) }}