DTE Insight Home Assistant configuration

configuration.yaml

sensor:
    # Read in DTE Insight via MQTT. You can add an MQTT integration in Home Assistant with the DTE Insight's IP address on port 2883
  - platform: mqtt # this is my DTE Insight, if you have multiple MQTT servers this might be different
    name: Instant Energy Usage
    state_topic: "event/metering/instantaneous_demand"
    unit_of_measurement: W
    value_template: "{{ value_json.demand }}"
    state_class: measurement
    device_class: energy

    # These convert the template sensors below from Watts to Kilowatt-hours using the power of calculus
  - platform: integration
    source: sensor.grid_electric_usage
    name: DTE Energy Usage
    unit_prefix: k

  - platform: integration
    source: sensor.grid_electric_return
    name: DTE Energy Return
    unit_prefix: k
    
template:
  - sensor:
    # Calculate the household electric usage by adding the DTE Insight measurement with the solar measurement
    - name: "Grid Electric Usage"
      unit_of_measurement: W
      state_class: measurement
      device_class: power
      state: >
        {% set dte_watts = states('sensor.instant_energy_usage' ) | int %}
        {% set solar_watts = states('sensor.envoy_202119015431_current_power_production' ) | int %}
        {{ dte_watts + solar_watts }}
    
    # Calculate the electricity that is returned to the grid by only using the DTE Insight value when it is negative
    - name: "Grid Electric Return"
      unit_of_measurement: W
      state_class: measurement
      device_class: power
      state: >
        {% set dte_watts = states('sensor.instant_energy_usage' ) | int %}
        {% if dte_watts < 0 %}
          {{ 0 - dte_watts }}
        {% else %}
          0
        {% endif %}

mine looks like this, i got it from https://www.reddit.com/r/homeassistant/comments/pwa3nv/energy_tab_with_dte_energy_energy_bridge/

any idea if it's better to use the instantaneous one vs. minute resolution?

sensor:
    - platform: mqtt
      name: "Household Electricity Usage"
      icon: mdi:transmission-tower
      state_topic: "event/metering/summation/minute"
      unit_of_measurement: 'kWh'
      # the Energy Bridge returns "Watt-minutes" every minute in the "value"; convert it to kilowatt-hours
      value_template: "{{ value_json.value | float / 60000 }}"
      # the "time" in the message is a Unix-like timestamp (in milliseconds) of the start of the last reading
      last_reset_value_template:  "{{ now().fromtimestamp(value_json.time / 1000).replace(tzinfo=now().tzinfo) }}"
      device_class: energy
      state_class: total

@bdimcheff Try that out and let me know how it goes. I'm starting to doubt my numbers after comparing them to my bill

@georgeh have you made entities that return the current rate for DTE import/export for the energy dashboard to do pricing stuff?

No, I'm on a fixed plan right now. If I move to D1.2 I'll probably just use an Automation to switch the value at 11am and 7pm.

well I have this if you need it at some point:

  - sensor:
    - name: "DTE Rate"
      state: >
        {% set season = "summer" if now().month >= 6 or now().month <= 1 else "winter" %}
        {% set weekday = now().weekday() < 5 %}
        {% set rate = "peak" if now().hour >= 11 and now().hour < 19 and weekday else "offpeak" %}
        
        {{ season }}_{{rate}}