I am trying to correct the daily energy cost in $ when the battery is either charging or discharging. I have v2 - Gross Solar
v4 - Gross Consumption
If was fine before the battery was added as the net calculation combined the the tariff information correctly calculated the costs. A battery has been added which obviously charges with solar and discharges until it runs out overnight sometime. The grid then supplies the load until the sun comes up the next day. I have added the following in extended data.
v7 - Battery Charge
v8 - Battery Discharge
v9 - Net Export
v10 - Net Consumption
v9 and v10 are calculated with the following rules
v9 = v2 - v7; if((v4 - v8 - v2 - v7) < 0) v10 = 0; else v10 = v4 - v8 - v2 - v7
The bit I can’t work out is how do I get the net grid export and import back into the v2 - v4 calculation which determines the daily costs. I have looked at using the CR/DR function but that only provide a single tariff which does not work as I need net. I am thinking it is in the parent / child setup somehow but how do I get v7 deducted from v2 without impacting the v2 graphing, same for v8 and v4?