All we have to do is find the current through the controller by using power voltage x current.
Calculate size of solar panel battery bank and inverter excel.
Battery banks are typically wired for either 12 volts 24 volts or 48 volts depending on the size of the system.
I have seen the excel sheet you have prepared for design of solar panel inverter and battery bank and it is awesome.
Take the power produced by the solar panels and divide by the voltage of the batteries.
Think of this as the minimum battery bank size based on your typical usage.
Here my application is little different on solar water heater.
This requires an increase in current flow from the battery to run the inverter.
The solar battery calculator applies the best practices for using the depth of discharge dod of different types of solar batteries thus ensuring the optimal compromise between the size of the battery bank and the desired long life of the batteries while taking into account their type.
In reality however inverters consume some of the power that flows from the battery while inverting.
If inverters were 100 efficient all of the power flowing from the battery would be inverted for use by the load and the inverter would consume no power at all.
You may want to consider 600 800 amp hours of capacity based on this example depending on your budget and other factors.