Hello, I am recreating a new instance of Home Assistant and wanted to revamp the energy consumption and cost system. I have a meter on the electrical panel and several smart sockets connected to various appliances (washing machine, oven, tumble dryer, etc.). Are there any packages on HACS or GitHub that allow me to create automations and keep everything under control? Or is it better to create a YAML file locally? Thank you.
#Energy monitoring and cost control
gusty spear
quiet root
for monitoring you can use the energy dashboard
what kind of control are you talking about?
gusty spear
In the previous instance, I had this package for meter consumption and a file for each appliance. I wanted to upgrade it with something better. I am not satisfied with the default dashboard, or rather, I don't think I can make full use of it.
quiet root
you're going to have to be more concrete about what you want to get help. Then we can forward you to templates or automations or dashboards.
in your YAML I see mainly threshold / notifications, not much about control
gusty spear
Yes, I think the term “control” is wrong in this context. What I would like to achieve is monitoring of both overall consumption and consumption for each individual device. I'm not interested in notifications on Alexa, Google or my phone. (I can do that later). I would like to create a system that allows me to compare it with the utility bill, so I can understand how many kWh I consume and the relative cost.
quiet root
the energy dashboard can do monitoring
including cost
I would set that up first and then see what's missing
gusty spear
I'll try, but which of these entities should I include?
quiet root
the best is lifetime increasing sensors. So that's probably the 6985.08 kWh one
they are poorly named
I can only guess what they do
gusty spear
Is there anything that can be done to see instantaneous consumption? And what is the format for uploading it to an Excel file? I mean the daily cost and daily consumption.
quiet root
energy dashboard doesnt show instantaneous consumption
you can press download data in top right corner
gusty spear
data:
config_entry: 01J9SBFY59VS22314S84291YQ1
data:
Giorno: "{{states('sensor.data_italiana')}}"
Consumo Giornaliero: "{{states('sensor.energia_oggi_consumo')}} kWh"
Costo Giornaliero: "{{states('sensor.costo_consumo_giornaliero_casa')}} €"
I would like to create a configuration like this to put on Google Sheets.
quiet root
you can do that, just need to put that in an automation. The energy dashboard creates cost entities for grid sensors. Not for device sensors though
gusty spear
OK, and what about adding appliances?
quiet root
just add them
gusty spear
However, this adds to the meter reading, so I should include it. This is because the 6.89 kWh on the meter also includes the microwave.
gusty spear
How can I calculate daily consumption and cost? So that I can put it in Google Sheets.
like {{ state_attr('sensor.meter_energy_produced_a', 'last_period') }}
@quiet root
quiet root
you can use a utility meter
gusty spear
Are there no other methods? Because I don't really know how to obtain the previous day's value to perform the subtraction in the template.
quiet root
what do you need a template for?
gusty spear
I wouldn't know how to do that. Could you show me how?
quiet root
I mean what do you need the template for?
gusty spear
yes