Spreadsheet modeling of thermal and daylighting performance

A series of linked spreadsheets has been developed for the analysis and modeling of thermal and daylighting effects on the flow of energy in buildings. Spreadsheet software is widely available, easily operated and readily adaptable to particular circumstances. Standard engineering formulas are used for heating, cooling, solar radiation and daylighting calculations. "What-if" relationships are established by varying assumptions and measuring their effect on the result.  This  technique  allows rapid iteration for evaluating different design scenarios, and gives both numerical and graphical output. The spreadsheets are well-suited for educational use.