I have a number of Tuya bi-directional energy monitors, along with CT clamps, these measure total home import and export as well as the solar production (very old dumb inverter).
In the coming weeks I will also be adding an additional 8 CT clamps to monitor lighting circuits, ring mains, cooker etc etc. Plus, a number of my smart plugs monitor power consumption (or production).
The data looks relatively ok in the Energyu dashboard, but I’d like to see more.
What options are there to get data out of HA and into Excel, or some other graphing tool? As a minimum I’d want data every 30 mins, ideally more frequently.
As I install more solar (and some batteries) and then have to start limiting export, it would be good to see when I’m hitting my export limit, what the maximum is that I ever pull from the grid etc.
My wife is about to get a full EV (we have 2x plug in hybrids currently), so I would also like to report more data on what that uses too.
