Dear forum users
I'm currently working on some kind of energy management tool.
I've several columns containing day, hour, generated power, load power. The final goal is to determine how reliant a company is on the grid.
Therefore I have to check several if cases; if is the wind power alone sufficient, if not, then is solar alone sufficient, if not is the combination of both usable to feed the load. If one of these formulas gives a go, the battery's state of charge has to be checked and if not 100%, the difference generated>load can be stored in the battery, if it is full, the goes to the grid.
These are just a few options to be checked. Because of time issues, i'm not capable of learning some programming language.
What would be the easiest way to execute this in excel, any ideas?
Thanks in advance!