Developing an Individual Excel Sheet for Design and Analysis of Beam and Slab

Abstract

Analysis and design of RC structures using FEM based software package needs basic knowledge of that software. This project focuses on developing a excel sheet with simple user interface to analyze and design RC structures without any prior knowledge of software. This excel sheet considers only the gravity loads. Grids in X and Y directions are defined in the sheet. User can enter distance between grids. This sheet provides design of footing and column.

Introduction

I. INTRODUCTION

Analysis and design of multi-story structure is a tedious task. FEM based software are used to carry out the same. However, use of these software needs lot of experience and expertise. Lack of exposure and expertise in these software leads to inaccurate designs. To ease the design of structures, a excel sheet with simple user interface is developed which can be used by almost anyone for building design. The excel is designed to take minimum input and provide maximum output. Building structures are usually divided by grid systems depending on their column location, which denotes centre to centre distance. This excel sheet takes centre to centre distance as input. Load on the column is calculated using the tributary area defined by the centre-to-centre distance. This load includes live load, floor finish, dead load of slab, beam, column and wall load. Depending on number of floors the total load is calculated and the same is used to design footings. Similarly, columns are designed for axial load and moments using SP16. Design of beam is carried out using bending moment and shear force factors for continuous beams as specified in the IS456:2000. Slab panels are designed using the centre-to-centre distance provided as per the support condition. All the footings,columns, beams and slabs can be independently designed. To validate the results, the same structure was analysed and designed in ETABS, which gave results with accuracy up to 95%. The accuracy decreases as the size of the structure increases.

This excel sheet is very useful in designing regular structures till G+3 and up to span 7m under gravity loading. Lateral loads are not considered for design.

II. LITERATURE REVIEW

A. “Development of Design Spreadsheet Tool for R.C.C. Beam Design using V.B.A.”

Author – Vijay Srivastav

The outline manages a complicated and repeated task because the design technique in light of the Limit State Method includes different mathematical statements and parameters. In addition, outlining is a time-consuming and extremely repeated trailing technique. Therefore, using spreadsheets can significantly cut down on a planner's or builder's time and effort. Despite the availability of numerous standard configuration programming packages, spreadsheets have emerged as one of the best options for designers due to their minimization and compliance. The main goal of this project is to create an MS Excel Spreadsheet with VBA Programming that will enable users to

1. Analyse a beam for Shear Force, Bending Moment, Slope, and Deflection for a variety of end Conditions and for a variety of load patterns.
2. To determine the safe load carrying capacity of a beam
3. To Create RCC Beams An outline equipment that can be usefully used by a professional to analyse and design an RCC beam will be the project's output.

B.  “Automated Excel Sheets for Various RC Elements.”

Author – Nitin Tiwari, Rashmi Sakalle

In this work, the rebars of various RC elements, such as beams, columns, and slabs, have been calculated and analysed using the EXCEL spreadsheet programme. This project work has calculated five different types of EXCEL spreadsheets, including one-way and two-way slabs, short columns and long columns, cantilever beams, simply supported beams, and short columns and long columns.

Effective span, nominal cover, and effective length of compression members were only a few of the distinctive factors that were considered in our analysis. The RC elements have been assigned several checks in addition to having a variety of distinguishing attributes. RCC code IS 456:2000 has been used as a source of inspiration.

C. “Structural Analysis and Design of Multistorey Reinforced Concrete Building using STAAD. Pro”

Author – Sushant Gupta

Structural design is the primary aspect of the civil engineering. The foremost basic in structural engineering is the design of simple basic components and members of a building viz., Slabs, Beams, Columns and Footings. The principle objective of this project is to analyse and design a multi-storied reinforced concrete building [G + 3 (3-dimensional frame)] using STAAD Pro. The design involves manual load calculations, analysis and design of the whole structure using STAAD Pro. The design methods used in STAAD-Pro analysis are Limit State Design conforming to Indian Standard Code of Practice. Structure considered for analysis and design is 14.90 m high hospital building located in the seismic zone IV. In this project, we study the effect of various load combinations on the structure by analysing the bending moment diagrams in post processing mode.

D. “Analysis and design of G+5 residential building by using E-Tabs”

Author – Lingeshwaran Navaratnam

We are living in the 21st century number of complex and irregular structure and designed to resists the Earthquake, Wind and needs to analyse , design the structure by the various software like ETABS, STAAD.Pro, TEKLA and to design the structure in this project we used the ETABS software due to company suggestion and to find stress analysis in slab, shear force for the beam and area reinforcement for the column and design the foundation depends upon the reaction and height of the foundation level depends upon site and safe bearing capacity of the soil due to stability purpose designed the retaining wall in this project.

II. OBJECTIVE

1. Design and Analysis of RC structure by developing an independent Excel sheet and validating the result using ETABS software
2. To include structural engineering principles into design documents.
3. To improve the idea behind structural analysis and design as well as its effectiveness when a design sheet is employed.

III. METHODOLOGY

A.  Problem Definition

Developing an Excel sheet to Design and Analyse the RC structure and comparing using

E-tab Software

B. Flow Chart

V. RESULTS AND DISCUSSIONS

A.  General

This project focuses on developing a excel sheet with simple user interface to analyze and design RC structures without any prior knowledge of software. The forces on every member were calculated. After that we began with the design of Beam using relevant code books, and then Slab was designed manually. Various checks were performed on the members. As a result, we gained a foundational understanding of analysis and design as well as ideas like load transfer mechanisms and moment distribution.

This Excel sheet considers only the gravity loads. Grids in X and Y directions are defined in the sheet. User can enter distance between grids. Loads on various elements of the buildings such as Beam and Slab are calculated manually.The same building was modelled and analysed using E-tab also.

Conclusion

1) It can be concluded that, the results obtained by Excel after comparison with E-tabs gives 90 - 95% accuracy. 2) MS Excel sheet is a very useful tool for calculating the rebars of various RC elements such as footing, columns, beams, and slabs. 3) These aid in the speedy design of buildings and other structures for a variety of applications and are effective. 4) For the design of reinforced concrete elements, these excel sheets can be used in conjunction with analytical software such as STAAD and ETABS.

References

[1] Development of educational software for beam loading analysis using pen-based user interfaces Yong S. Suh, Journal of Computational Design and Engineering, Vol. 1, No. 1 (2014) 67~77 [2] Reinforced Concrete Structure Design Assistant Tool for Beginners, Kang Kyu Choi, 2002. [3] Development of IOS Application for Design of Flat Slabs, Shree Lakshmi MJ1, Mr. Manjunath L2, Miss. Spandana B3, Ritesh L4, International Research Journal of Engineering and Technology (IRJET) [4] Developing Civil Engineering Design Software using MS Excel. Varsha S Danavandi1, Shaik Kabeer Ahmed2, INTERNATIONAL JOURNAL OF CURRENT ENGINEERING AND SCIENTIFIC RESEARCH 2017 [5] Using Spreadsheets a APPLICATIONS Nd VBA for Teaching Civil Engineering Concepts, Essam Zaneldi [6] DESIGN OF POST-TENSIONED PRESTRESSED CONCRETE BEAM USING EXCEL SPREADSHEET WITH VISUAL BASIC, RIMMON S. LABADAN, International Journal of Advances in Mechanical and Civil Engineering,2016 [7] Toward Reverse Engineering of VBA Based Excel Spreadsheets Applications, Domenico Amalfitano, Nicola Amatucci, Vincenzo De Simone, Anna Rita Fasolino, Porfirio Tramontana, 2015 [8] Santosh Kumar P.T. (2014) “Trends and recent advances in civil engineering (TRACE-24th-25th January 2014), International Journal of Engineering Research and Applications (IJERA) ISSN:2248-9622 [9] Varsha S Damavand, Shaik Kabeer Ahmed (2017) “Developing civil engineering design software using MS EXCEL” ISSN:2349-0697, VOLUME-4, ISSUE5,2017 [10] Mahesh Kumar (2015) “quick design of buildings and other projects on MS EXCEL” [11] Suryam Tiwari, Vijay Srivastav (2018) “Microsoft Excel Spreadsheet using VBA programming packages”-IJIRST-International Journal for Innovative Research in Science and Technology, Volume 4, Issue 11,April 2018, ISSN-(2349-6010). [12] Ima Rahmanian, Yves Lucet, Solomon Tesfamariam(2014)”Optimal design of reinforced concrete beams”, Computers and concrete, Volume 13, No.4(457- 482). [13] Fernandes R. J, Javeli F. M, Patil S. B (2017) “Analysis and Design of Reinforced Concrete Beams and Columns using open STAAD”, International Journal of Soft Computing and Engineering (IJSCE) ISSN:2231-2307, Volume-7 Issue-3. [14] RichardLawreneEmberley(2013)” behaviour of RC columns under fire exposures using a spreadsheet-based numerical model” Worcester Polytechnic Institute, may 2013 [15] Poonam Gare, Dr. S.S. Angalekar(2016) “Design of Structural Element Employing Optimization Approach” International Journal of Innovative Research in Science, Engineering and Technology, Volume-5, Issue-7 July 2016

Copyright

Copyright © 2022 Sachin Tattimani, Sri. P. I. Cholappanavar. This is an open access article distributed under the Creative Commons Attribution License, which permits unrestricted use, distribution, and reproduction in any medium, provided the original work is properly cited.