Often we need to calculate the power ratings of different components in a solar power systems. This may include the battery rating, solar charger rating, number of panels and their ratings. It all depends upon the output load, charging time and resources available. Attached is a very simple excel sheet which helps to calculate these parameters. Just change the parameters on left to see the reflected output calculations on right.