Solar Power

- name: "Total Solar Generation"
  unique_id: "total_solar_generation"
  icon: mdi:solar-power-variant
  unit_of_measurement: "W"
  device_class: power
  state_class: measurement
  state: >
    {% set inverter_1_power = states('sensor.inverter_1_active_power') | float %}
    {% set inverter_2_power = states('sensor.inverter_2_active_power') | float %}
    {{ (inverter_1_power + inverter_2_power) | float(0) }}

- name: "Home Power Consumption"
  unique_id: "home_power_consumption"
  icon: mdi:lightning-bolt
  unit_of_measurement: "W"
  device_class: power
  state_class: measurement
  state: >
    {% set meter_power = states('sensor.power_meter_active_power') | float %}
    {% set inverter_1_power = states('sensor.inverter_1_active_power') | float %}
    {% set inverter_2_power = states('sensor.inverter_2_active_power') | float %}
    {{ ((inverter_1_power + inverter_2_power) - meter_power )  | float(0) }}

- name: "Grid Power Consumption"
  unique_id: "grid_power_consumption"
  icon: mdi:transmission-tower-export
  unit_of_measurement: "W"
  device_class: power
  state_class: measurement
  state: >
    {% set meter_power = states('sensor.power_meter_active_power') | float %}
    {% if meter_power < 0 %}
    {{ (meter_power * -1) | float(0) }}
    {% else %}
    {{ 0.0 | float(0) }}
    {% endif %}

- name: "Grid Power Export"
  unique_id: "grid_power_export"
  icon: mdi:transmission-tower-import
  unit_of_measurement: "W"
  device_class: power
  state_class: measurement
  state: >
    {% set meter_power = states('sensor.power_meter_active_power') | float %}
    {% if meter_power > 0 %}
    {{ meter_power | float(0) }}
    {% else %}
    {{ 0.0 | float(0) }}
    {% endif %}

- name: "Solar Self Consumption"
  unique_id: "solar_self_consumption"
  icon: mdi:lightning-bolt-circle
  unit_of_measurement: "W"
  device_class: power
  state_class: measurement
  state: >
    {% set yield = states('sensor.total_solar_generation') | float %}
    {% set export = states('sensor.grid_power_export') | float %}
    {% if yield > export %}
    {{ (yield - export) | float(0) }}
    {% else %}
    {{ 0.0 | float(0) }}
    {% endif %}

sensor:
  - platform: integration
    name: Grid Power Import
    unique_id: grid_power_import_kwh
    source: sensor.grid_power_consumption
    method: left
    unit_prefix: k
    unit_time: h
  - platform: integration
    name: Grid Power Export
    unique_id: grid_power_export_kwh
    source: sensor.grid_power_export
    method: left
    unit_prefix: k
    unit_time: h
  - platform: integration
    name: Solar Self Consumption
    unique_id: solar_self_consumption_kwh
    source: sensor.solar_self_consumption
    method: left
    unit_prefix: k
    unit_time: h

sensor:
  - platform: sun2
    monitored_conditions:
      - sunrise
      - sunset

type: 'custom:config-template-card'
entities:
  - sensor.sunrise
  - sensor.sunset
variables:
  getTime: |
    sensor => {
      const today = new Date();

      var event_time = new Date(states[sensor].state);

      if (event_time.getDate() == today.getDate()) {
        return event_time.getTime();
      }

      return 0;
    }
  getTimeString: |
    sensor => {
      const today = new Date();

      var event_time = new Date(states[sensor].state);

      if (event_time.getDate() == today.getDate()) {
        return event_time.toLocaleTimeString('en-AU', {hour: '2-digit', minute: '2-digit'});
      }

      return "";
    }
card:
  type: custom:apexcharts-card
  update_interval: 30sec

  graph_span: 24h
  span:
    start: day

  show:
    loading: true
    last_updated: false

  hours_12: true

  cache: true

  stacked: false

  header:
    show: false

  yaxis:
    - min: 0
      max: 10
      decimals: 0
      apex_config:
        tickAmount: 5

  apex_config:
    chart:
      type: area
      zoom:
        enabled: true
        type: x
      toolbar:
        show: true
        tools:
          reset: false
          pan: false
          download: false
          selection: false
          zoom: false
          zoomin: true
          zoomout: true
    stroke:
      show: true
    dataLabels:
      enabled: true
    legend:
      show: false
    fill:
      type: gradient
      gradient:
        inverseColors: true
        type: vertical
        shadeIntensity: 0
        opacityFrom: 0.7
        opacityTo: 0.7
    grid:
      show: true
    annotations:
      xaxis:
        -
          x: "${getTime('sensor.sunrise')}"
          strokeDashArray: 2
          label:
            text: "${'☀️ Sunrise - ' + getTimeString('sensor.sunrise')}"
            borderWidth: 0
            style:
              background: '#0000'
        -
          x: "${getTime('sensor.sunset')}"
          strokeDashArray: 2
          label:
            text: "${'🌙 Sunset - ' + getTimeString('sensor.sunset')}"
            borderWidth: 0
            style:
              background: '#0000'

  locale: en

  all_series_config:
    stroke_width: 2
    curve: smooth
    opacity: 1
    unit: kW
  series:
    -
      name: Solar
      entity: sensor.total_solar_generation
      color: '#18cf87' # green
      transform: return x / 1000;
      type: area
      float_precision: 3
      extend_to: now
      group_by:
        func: avg
        duration: 5m
    -
      name: Grid Consumption
      entity: sensor.home_power_consumption
      color: '#f76354' # red
      transform: return x / 1000;
      type: area
      float_precision: 3
      extend_to: now
      group_by:
        func: avg
        duration: 5m
    -
      name: Forecast
      entity: sensor.solcast_forecast_today
      type: line
      color: '#3798fe' # blue
      curve: stepline
      data_generator: |
        return entity.attributes.forecast.map((entry) => {
          var date_period = new Date(entry.period_start);

          return [date_period, Math.min(entry.pv_estimate, 10)];
        });

input_datetime:
  solar_installation_date:
    name: Solar Installation Date
    has_date: true
    has_time: false
    initial: "2022-07-27"

template:
  - sensor:
    - name: Solar Initial Cost
      unit_of_measurement: AUD
      state: "13010"

input_number:
  solar_net_cost:
    name: Solar Net Cost
    min: -13010.00
    max: 99999999.00 # A max is required for all input_number resources
    mode: box
    unit_of_measurement: AUD
    icon: mdi:currency-usd

-
# Create a sensor to know the current time of use pricing by Ausgrid NSW
#
# https://www.ausgrid.com.au/Your-energy-use/Meters/Time-of-use-pricing
# Peak:
#   - From 2pm to 8pm on working weekdays during 1 November and 31 March (inclusive) – the “summer months”
#   - From 5pm to 9pm on working weekdays during 1 June to 31 August (inclusive) – the “winter months”
#
# Shoulder:
#   In simple terms, the shoulder period applies from 7am to 10pm every day, except where a peak period applies during that period.
#
#   Specifically, it applies:
#   - from 7am to 10pm on all weekends and public holidays
#
#   on working weekdays in the summer months:
#     - from 7am to 2pm; and from 8pm to 10pm
#
#   on working weekdays in the winter months:
#     - from 7am to 5pm; and from 9pm to 10pm
#     - on working weekdays in spring and autumn, from 7am to 10pm.
#
# Off-peak: All other times, 10pm to 7am
-
  name: TOU Period
  icon: mdi:clock-time-three-outline
  state: >
    {% set tou_period = 'shoulder' %}

    {% set n_month = now().month %}
    {% set n_hour = now().hour %}

    {% set is_summer = (n_month <= 3 or n_month >= 11) %}
    {% set is_winter = (6 <= n_month <= 8 ) %}

    {% if n_hour >= 22 or n_hour < 7 %}
      {% set tou_period = 'offpeak' %}
    {% elif ((is_summer and (14 <= n_hour < 20)) or (is_winter and (17 <= n_hour < 21))) and (is_state("binary_sensor.workday_sensor", "on")) %}
      {% set tou_period = 'peak' %}
    {% endif %}

    {{tou_period}}

# Current electricity plan
-
  # Peak
  name: Electricity Peak Cost
  icon: mdi:currency-usd
  unit_of_measurement: AUD
  state: "0.5442"
-
  # Offpeak
  name: Electricity Offpeak Cost
  icon: mdi:currency-usd
  unit_of_measurement: AUD
  state: "0.3521"
-
  # Shoulder
  name: Electricity Shoulder Cost
  icon: mdi:currency-usd
  unit_of_measurement: AUD
  state: "0.3521"
-
  # Supply
  name: Electricity Supply Cost
  icon: mdi:currency-usd
  unit_of_measurement: AUD
  state: "1.0137"
-
  # A sensor to calculate the current cost of electricity based on the TOU and price
  name: Electricity Cost
  icon: mdi:currency-usd
  unit_of_measurement: AUD/kWh
  state: >
    {% if is_state('sensor.tou_period', 'peak') %}
      {{ states('sensor.electricity_peak_cost') }}
    {% elif is_state('sensor.tou_period', 'offpeak') %}
      {{ states('sensor.electricity_offpeak_cost') }}
    {% else %}
      {{ states('sensor.electricity_shoulder_cost') }}
    {% endif %}
-
  # Feed in
  name: Solar Feed In
  icon: mdi:currency-usd
  unit_of_measurement: AUD/kWh
  state: "0.2000"

# The price of the plan if there was no solar
# Non-solar plans may be cheaper than Solar plans, which is the case with us
# We want to compare how much we would've paid if we didn't have Solar
# This way we can calculate the difference in price/savings to come to a breakeven date
-
  # Peak
  name: Alternative Electricity Peak Cost
  icon: mdi:currency-usd
  unit_of_measurement: AUD
  state: "0.3465"
-
  # Offpeak
  name: Alternative Electricity Offpeak Cost
  icon: mdi:currency-usd
  unit_of_measurement: AUD
  state: "0.1397"
-
  # Shoulder
  name: Alternative Electricity Shoulder Cost
  icon: mdi:currency-usd
  unit_of_measurement: AUD
  state: "0.1727"
-
  # Supply
  name: Alternative Electricity Supply Cost
  icon: mdi:currency-usd
  unit_of_measurement: AUD
  state: "0.8800"
-
  # A sensor to calculate the alternative cost of electricity based on the TOU and price
  name: Alternative Electricity Cost
  icon: mdi:currency-usd
  unit_of_measurement: AUD/kWh
  state: >
    {% if is_state('sensor.tou_period', 'peak') %}
      {{ states('sensor.alternative_electricity_peak_cost') }}
    {% elif is_state('sensor.tou_period', 'offpeak') %}
      {{ states('sensor.alternative_electricity_offpeak_cost') }}
    {% else %}
      {{ states('sensor.alternative_electricity_shoulder_cost') }}
    {% endif %}

# Use the kWh sensors
utility_meter:
  ## Daily Import
  grid_power_import_daily:
    unique_id: utility_meter_daily_grid_power_import
    source: sensor.grid_power_import_kwh
    name: Electricity Meter - Daily Import
    cycle: daily
    tariffs:
      - offpeak
      - shoulder
      - peak

  ## Daily Export
  grid_power_export_daily:
    unique_id: utility_meter_daily_grid_power_export
    source: sensor.grid_power_export_kwh
    name: Electricity Meter - Daily Export
    cycle: daily
    tariffs:
      - anytime

  # Daily self consumption
  solar_self_consumption_daily:
    unique_id: utility_meter_daily_solar_self_consumption
    source: sensor.solar_self_consumption_kwh
    name: Electricity Meter - Daily Solar Self-Consumption
    cycle: daily
    tariffs:
      - offpeak
      - shoulder
      - peak

-
  name: Electricity Usage Yesterday - Solar
  state_class: measurement
  unit_of_measurement: kWh
  device_class: energy
  state: >
    {{
      state_attr('sensor.solar_self_consumption_daily_offpeak', 'last_period') | float(0) +
      state_attr('sensor.solar_self_consumption_daily_peak', 'last_period') | float(0) +
      state_attr('sensor.solar_self_consumption_daily_shoulder', 'last_period') | float(0)
    }}

-
  name: Electricity Usage Yesterday - Grid
  state_class: measurement
  unit_of_measurement: kWh
  device_class: energy
  state: >
    {{
      state_attr('sensor.grid_power_import_daily_peak', 'last_period') | float(0) +
      state_attr('sensor.grid_power_import_daily_offpeak', 'last_period') | float(0) +
      state_attr('sensor.grid_power_import_daily_shoulder', 'last_period') | float(0)
    }}

-
  name: Electricity Usage Yesterday - Total
  state_class: measurement
  unit_of_measurement: kWh
  device_class: energy
  state: >
    {{
      states('sensor.electricity_usage_yesterday_solar') | float(0) +
      states('sensor.electricity_usage_yesterday_grid') | float(0)
    }}

name: Electricity Costs Alternative Plan
state_class: measurement
unit_of_measurement: AUD
device_class: monetary
state: >
  {{
    (
      (states('sensor.alternative_electricity_offpeak_cost')|float(0)) * (
        (state_attr('sensor.solar_self_consumption_daily_offpeak', 'last_period')|float(0))
        +
        (state_attr('sensor.grid_power_import_daily_offpeak', 'last_period')|float(0))
      )
    )

    +

    (
      (states('sensor.alternative_electricity_peak_cost')|float(0)) * (
        (state_attr('sensor.solar_self_consumption_daily_peak', 'last_period')|float(0))
        +
        (state_attr('sensor.grid_power_import_daily_peak', 'last_period')|float(0))
      )
    )

    +

    (
      (states('sensor.alternative_electricity_shoulder_cost')|float(0)) * (
        (state_attr('sensor.solar_self_consumption_daily_shoulder', 'last_period')|float(0))
        +
        (state_attr('sensor.grid_power_import_daily_shoulder', 'last_period')|float(0))
      )
    )

    +

    (states('sensor.alternative_electricity_supply_cost')|float(0))
  }}

# Updates the net cost of the solar system each night.
# This is to stop it updating constantly and wasting CPU
# Takes the input_number value and minuses the difference between the yesterdays electricity costs (usage minus feed-in+self-consumption) and the alternative plan
- id: electricity_update_solar_net_cost
  alias: Electricity - Update Solar Net Cost
  description: ""
  trigger:
    - platform: time
      at: "00:05:00"
  condition: []
  action:
    - service: input_number.set_value
      data:
        value: |
          {{
            states('input_number.solar_net_cost')|float(0)
            +
            (
              states('sensor.electricity_costs_alternative_plan')|float(0)
              -
              states('sensor.electricity_costs_yesterday_total')|float(0)
            )
          }}
      target:
        entity_id: input_number.solar_net_cost
  mode: single

# Time until solar breakeven
-
  # solar_days = How many days since installation
  # paid_off = initial cost minus input_number
  # average = paid_off / solar_days
  # remaining_days = input_number / average
  name: Solar Days Until Breakeven
  state: >
    {% set solar_days = (as_timestamp(today_at()) - as_timestamp(states('input_datetime.solar_installation_date'))) / 86400 %}
    {% set paid_off = (states('sensor.solar_initial_cost')|float(0) - (states('input_number.solar_net_cost')|float(0) * -1)) %}
    {% set average = paid_off / solar_days %}
    {% set remaining_days = (states('input_number.solar_net_cost')|float(0) * -1) / average %}
    {{ remaining_days }}
-
  # today + remaining_days
  name: Solar Breakeven Date
  state: >
    {% set days = states('sensor.solar_days_until_breakeven') | float(0) %}
    {% set nice_remaining_days = today_at() + timedelta(days=days) %}
    {{ nice_remaining_days.strftime('%d %b %Y') }}