Simple Visualization of Sun,facade, Window and Shade
The raison d'etre of using Excel for designing/ decision making is that the solution is not a black box and professionals besides relating to basic principles can play with it through and create scenarios. Transparency of formulas and correlations when supported with basic visualizations however can authenticate decision making. Seeing is believing. Optimal solar passive design requires varying requirements.