Take the power produced by the solar panels and divide by the voltage of the batteries.
Calculate size of solar panel battery bank and inverter excel.
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.
Battery banks are typically wired for either 12 volts 24 volts or 48 volts depending on the size of the system.
Here my application is little different on solar water heater.
I want to maintain the 70 c temperature of 50 liters approx water using 500 w dc heater for 24 7.
The next step involved in sizing your system and also in determining how to calculate solar panel battery and inverter is to size your charge controller but before then we have to understand some components which you probably have not encountered and so do not understand this will give you a better understanding of the calculation.
Once you have sized your battery bank and solar panel array determining which charge controller to use is comparatively straight forward.
You may want to consider 600 800 amp hours of capacity based on this example depending on your budget and other factors.
Think of this as the minimum battery bank size based on your typical usage.
I have seen the excel sheet you have prepared for design of solar panel inverter and battery bank and it is awesome.