Formulation of rigid diaphragm analysis spreadsheet by stiffness method

This report is the documentation for a stiffness formulation to perform rigid diaphragm analysis for wood structures subjected to wind loads. Traditionally, rigid diaphragm analysis has been performed using a vaguely-defined superposition approach; however, this report details a more rational stiffness approach to solving for forces placed on walls resulting from a rigid diaphragm, and its implementation is via a simple spreadsheet application. In addition to the formulation of the spreadsheet, the report contains a User’s Guide and examples of the spreadsheet’s use. The purpose of the spreadsheet is not as a replacement to more sophisticated and comprehensive finite element analysis software, but as a tool to aid designers who practice engineering and may not have access to such software. In general, the application is developed for wood diaphragms as will be noted by references to wood-related codes. However, much of the approach may be used for diaphragms constructed with other materials as well.