Bi-directional table update for better meter matching:
ALTER TABLE `EnergyFlow` ADD `gridPcons` FLOAT NOT NULL AFTER `gridP`, ADD `gridPfeed` FLOAT NOT NULL AFTER `gridPcons`;
UPDATE EnergyFlow SET gridPcons = gridP WHERE gridP > 0 AND gridPcons = 0;
UPDATE EnergyFlow SET gridPfeed = -gridP WHERE gridP < 0 AND gridPfeed = 0;