GE Consumption Data vs Home Assistant Data. Help

I've had a GE system now for 16 months and in March this year I had 3 extra panels fitted to a west facing roof, these have Enphase micro-inverters and all appears to be working fine.

However the extra Enphase generation has messed up the GE dashboard home consumption data.

I noticed that Tim & Kat have the same issue and I was hoping that he would come up with a solution but he is being a little coy about it at the moment. I did notice in the comments of the video that @geoffreycoan ignores GE load sensors and calculates his own in Home Assistant using the formula import-export+generation+battery discharge-battery charge.
I would like to do that but I'm not sure how to go about it in Home Assistant.

I do have HA running but only using pre-configured cards via HACS and some very basic cards from the large number of entities that appeared after I installed GivTCP.
I've kinda muddled my way around without really understanding the current version of HA.
Please forgive if I'm using the wrong terminology but so much of 'home assistant' is like an aeroplane - it goes straight over my head.

What do you do in HA to create the formula:
'import' - 'export' + 'generation' + 'battery discharge' - 'battery charge'
In other words which Entities should I be using to calculate the home load without using the GivEnergy data?
How can you tell which GE data is metered and which if any is calculated (apart my now obviously wrong zero home consumption)?

Robgy Hi, sorry I missed this message and request for help.

Before I dive in and start answering what is now an old question, can I check you still have this problem?

geoffreycoan thank you for the reply, I did try a number of different ways in home assistant and got close to what I thought home consumption should be, it got quite complicated, not helped by my nomenclature for helpers etc...
Eventually I ditched the idea of calculating the house consumption and had a couple of Shelly em pro 50s' installed in the consumer units so now I can see exactly what the house is using as a bonus I can see what the Daikin heat pump is actually using rather than it's calculated usage.

Adding the Shelly meters to home assistant was simple and a couple of ha virtual meters means I don't need to use the Shelly app. It does also mean I don't need the Givenergy app either or the Daikin app or aqara app or the enphase app ect...

Thank you once again for the reply and all the other support you offer on here, I've certainly learnt a lot but still have a long way to go.