APPLICATION OF MICROSOFT EXCEL FOR BASIC REINFORCED CONCRETE STRUCTURAL CALCULATIONS USING WORKING STRESS DESIGN METHOD

Abstract

     This study aimed to develop Microsoft Excel spreadsheets to support basic reinforced concrete structural calculations using the working stress design (WSD) method and to organize the calculation procedures into a verifiable and reusable format. The methodology involved reviewing the principles of reinforced concrete analysis and design using the WSD method, identifying the required variables and equations, and developing spreadsheets covering four calculation tasks: load transfer from slabs to beams, beam calculations, column calculations, and stair calculations. The formulas, cell references, and calculation sequences were checked against standard calculation procedures. The resulting spreadsheets incorporated clearly structured input, calculation, and output sections, allowing users to modify input values and systematically review the corresponding results. Verification confirmed that the spreadsheets followed the specified WSD procedures and could serve as a supporting tool for learning and checking basic reinforced concrete structural calculations. However, their scope is limited to basic calculations, and they should not replace review by a qualified engineer or the use of specialized structural analysis software.