Estimating: To Design Various Structures by using Excel Sheet

Authors:

Ms. Shruti Ramkrushna Sankaram ¹, Ms. Sanchita Raju Rathod ², Ms. Sanjana Santosh Gogi^{3 ,}

Ms. Krutika Mallinath Padwale⁴ Ms. Swati Pradeep Maniyal⁵

*1, 2, 3, 4, Students, Civil Engineering Department, Shri Siddheshwar Women’s Polytechnic, Solapur, Maharashtra, India.

*5 HOD OF Civil Engineering Department, Shri Siddheshwar Women’s Polytechnic, Solapur, Maharashtra, India.

ABSTRACT

The determination of dimensions of structural components is one of the basic areas in civil engineering. In this respect, the current research aims to calculate the dimensions of important structural members such as beams, slabs, columns, and footings considering the load, type of material used and codal provision. Adequate and efficient dimensioning plays a vital role in attaining sufficient strength and proper performance while conserving materials. Calculation of steel reinforcement to resist tensile stresses and increase load carrying capacity is another key area considered in the current investigation. The volume, amount, and layout of steel bars are determined by following certain procedures and using appropriate formulae. The calculations ensure safety of the structure against different types of loads including dead load and live load. All the procedures considered in the research are focused on accurate analysis, proper designing methodologies, and following codal provisions, resulting in safer and economical structural system. Microsoft Excel as a spreadsheet tool has gained popularity among structural engineers in recent times for performing calculations efficiently. Excel can be employed for calculating the dimensions of various structural elements like beams, slabs, columns, and footings in addition to determining necessary steel reinforcement. Through the application of formulas that have been defined previously, it becomes easy to perform complicated calculations such as load calculation, moment of bending, depth calculations, and steel area among others with ease and minimum error margin. In addition, it is very easy to change data inputs easily; hence it is very suitable for design work that requires iterations. Moreover, Excel offers an organized presentation of data in tabular form which makes it easier to understand and present.