guysqr / node-red-ha-solar-management

A Node-RED flow to manage a Sungrow solar inverter and battery. Requires Node-RED and https://github.com/mkaiser/Sungrow-SHx-Inverter-Modbus-Home-Assistant
5 stars 1 forks source link

Baseline consumption, CSV format #1

Open Polypod opened 5 months ago

Polypod commented 5 months ago

Nice work. Trying this myself and was mainly wondering on the baseline consumption format (or how you generated it)? (This is not really an error/issue report)

Then I was planning to try to use/Integrate the below. I.e. to find the sweet-spot at which time to force charge your battery (given a threshold import price). any ideas?

https://powersaver.no/examples/example-nordpool-events-state.html

saltpool commented 1 month ago

Not sure if you got any answer to your question, but I appear to have managed to get the baseline consumption working. If you are still after an answer, the flow is set up as tab delimited from the csv file - so what I did was change the "Get baseline consumption" csv node to be comma separated, rather than tab, and save content as follows:

0,1000 1,1500 2,1200 ... 22,900 23,900

With the first column being the hour, and the second the Watts that are expected to be consumed during that time period.

I know you asked this months ago, but perhaps you never got an answer.

speegs commented 2 days ago

I did the same thing, I should have read this earlier as took me a while to figure it out.

As for how I got my numbers to put into it, I just looked at historical usage in iSolarCloud hour by hour for a typical week. Tried to avoid anomalies and came up with what most days look like in watts.