Structural Analysis Using Only Excel Spreadsheets

This paper outlines the methodology used to construct, first, the stiffness matrix needed for a static distribution analysis of a road over rail bridge and second, the dynamic stiffness matrix and procedure required for the calculation of the lowest natural frequency for a single span footbridge using only a Microsoft Excel spreadsheet.