Developing Excel-VBA Spreadsheet for Truss Element Analysis and Design

Abstract

In this paper EXCEL Visual Basic application spreadsheet has used in analyzing and designing truss elements. EXCEL spreadsheet was developed to draw and analyzes different type of truss elements for tension and compression forces. The truss members were tested under dead, imposed, and wind load. Members capacity was provided according to BS 5950. Different type of joints connection was designed and recommended for support and internal joints.