An open-source optimization tool for solar home systems (SHSs) design is developed.
The optimization tool is written in MS Excel-VBA.
The optimization tool is validated with a commercial and open-source software.
The optimization tool has the potential of improving future SHS installations.