An Excel Application for Analysis and Design of RC Low-Rise Structural Elements using British Standards and European Codes

Abstract

There is an increasing demand for tools that can simplify the design process and improve the accuracy and efficiency of the design calculations in structural engineering. This paper presents an Excel application for the design and analysis of reinforced concrete low-rise structures using British standards and European codes. The application aims to assist structural engineers in the design process as it provides a set of pre-programmed calculations for the analysis of slabs, beams, columns, footings and stairs. The application incorporates the relevant design equations and guidelines from both standards and allows the user to input the required parameters and generate concise design outputs such as load capacity, stress analysis results and design recommendations. In developing the application, a combination of VBA programming and yield line method was used. The application has been tested using different design scenarios and the output compared to manual calculations. The application offers significant time savings, increased accuracy, and improved efficiency over manual methods