How to find the relationship between a few sets of data

Copper Contributor

Bare with me, this is an Excel question...

 

My inverters are drawing power from the grid when they shouldn't.  I've got data for a few hours when PV was active.  I've noticed that the grid draw seems to have some sort of relationship between the load and PV power while the battery is being charged.

 

glowbeard_0-1684794249486.png

 

I have four sets of data:  Load, Grid, PV, Battery.  Best I could get done was sticking them in an Excel graph:

glowbeard_1-1684794366699.png

 

I can SEE a relationship where as the PV moves (and battery is charged) the draw from grid seems to match my load with some relation to PV.  If I can figure out the relationship I can better understand what exactly is causing this strange draw from the grid.  How this is done... I haven't a clue.  Any help would be appreciated.  Thanks!

0 Replies