Hi,
I have energy meter in my installation (3 phases) that gives me values for L1, L2 and L3. The numbers are positive when I buy energy and negative when I sell energy. I have therefore made new sensors based on these so I have L1_From_Grid, L2_From_Grid and L3_From_Grid also I made 3 similar sensor for the negative values , L1_To_Grid, L2_To_Grid and L3_To_Grid. I have added these 6 sensors to the energy dashboard, all good so far.
The issue is that my Utility meter from the utility company sums things up meaning that if i deliver 1kWh on L1 and consume 1kWh (at the same time) on L2 the sum consumed from the grid is 0kWh therefore it’s important to sum things at the same time to get the overall picture. What I see now on energy dash board is for example how much I exported and how much i imported separately where this is misleading and is not correct in my case. How can I fix this ?
I’d suggest to create 2 template sensors, 1 for import and 1 for export, which each only show a value when the sum of the 3 is positive (import) and negative (export) respectvely.
Where ‘sensor.L1’ to L3 stand for the sensors which you get from your meter directly. In this case you would end up with 2 sensors which you could use in the energy dashboard directly. The result should be the same as your energy company then.
Thank you for your reply. I was thinking to do that but why would that solve the problem? The important part is that when the sum is done its done on instantaneous data for example the sum is not 0kwh if i use 1kwh now and then 5min later export 1kwh. The sum in this case is that i exported 1kwh and imported one 1kwh so i have to pay for that 1kwh and get payed for the 1kwh I exported and this is what i want to see, obviously the import is at one price and export is at another price (something that can’t be specified in hass). Right now hass looks at totals so if i exported during today 5kwh in the morning but in the afternoon i imported 5kwh it thinks i dont have to pay but thats wrong.
The important thing actually is to understand what sensors upper meter gives you in Homeassistant. I assumed the L1 through L3 sensors would be the current values in W, not kWh. If this is not the case I need to rethink.
What integration are you using to get the sensors in Homeassistant? Let’s start there, and maybe you can list the sensors with their unit of measurement.
@Remko yes i think you are right this would work. I tried and made the new sensors and they have values in them however very small 0.03kwh (import) and -0.03kwh export but i cant choose them in the energy dashboard. Any idea why ?
I find the values from the 3 sensors akward. This looks like the net value is always 0. Grid L2 hardly does anything and the other 2 are almost each others inverted values.
This would mean you are not using any grid consumption or export…So I am not sure what to make of that. Looks like either the integration is wrong, or I am completely misunderstanding it.
Been reading a tiny about about the Victron integration and maybe…you are using the wrong L1 to L3 sensors? There are 2 in the Modbus adress list which maybe could work. You are currently using these:
wow i didn’t expect you to dig in into the Victron but great you did, yes i do use those sensors, i am not sure the other ones are different but first let me explain what you see.
I try to keep the grid as close to 0W as possible since i have battery therefore you see postitive values on one phase and negative on another. That’s why you see the inverted values because the inverter produces same energy used on one phase on it’s own phase so in the end the net sum is 0W and i don’t pay for the electricity. All this because the installation is 3 phase but the inverter (actually i have two, one on L1 and one on L3) are single phase.
Ok i think i found the issue why it didn’t show up in Energy dashboard, i was missing device_class: power on the template sensors. Now it shows up but i spent more than one hour to try figuring out how to remove the negative value, i deleted the sensor → i went to statistics → clicked fix issue → clicked remove still when i added the sensor again in the config file the negative value was there again. I removed from database entries regarding the sensor but still it was showing up so i renamed the sensor completely but i hate the fact beeing required to do that…hmmm
@Remko got another quesiton relared to this which you may know, i would like to have a sensor that shows to me the consumed energy i have used from the grid today taking into account the facts we discussed earlier that i export energy and buy energy during the day so it’s only the energy that i buy when i am not also exporting that i want to know. Can i somehow use utility meter integration or does the energy dashboard already have a sensor for me that has this calculated ?
If you used the above templates, the “power_imported_daily” should be exactly this value. Since this utility meter only counts the net imported value. So this should be the amount of power which you actually import from the grid and where you need to pay money for. The same is valid for the exported_power_daily sensor…
Here is the output from Victron system which i know is correct since i know from the utility company that the consumption from Grid and return are indeed also what they see.
any ideas what’s going on ? I have a feeling it’s the issue that it’s not summing correctly when i export 1kwh and use 1kwh at the same time that give 0kwh export and 0kwh import if it happens at the same time.