EXCEL SHEET FOR THE DESIGN OF RCC BEAM AS PER IS456-2000 WITH DEFLECTION CHECK

“Feel the structure” MSA

This treasure having an attachment of excel sheet for the design of RCC beam with defection check with modification factors in IS456:2000 with empirical formula (Mentioned in SP-24) instead taking result from fig-4 &5 of IS456:2000 which is tedious and lot of interpolation is required. 

Dear friends and junior civil engineers who are aspiring to be a structural engineer. This excel sheet is for the design of beam with deflection check.

From below link, download excel sheet for design of beam with deflection check.

DOWNLOAD EXCEL SHEET FOR THE DESIGN OF BEAM WITH DEFLECTION CHECK AS PER IS-456-2000

                               

 This excel sheet is going to help many civil engineers entered or trying to make a career  in the field of structural engineering. It is also very helpful to many practicing structural engineers as well. In this attached sheet, you will find beam designed with deflection check with modification factors for tension and compression reinforcement. Normally in STAAD, you can find out deflection for any beam but that is not appropriate. STAAd give deflection with respect to stiffness only without considering the role of tension and compression reinforcement. But, here in this sheet you will find complete beam design with different check like singly or doubly reinforced beam, under or over reinforced beam along with deflection check with appropriate modification factors as per fig. 4& 5 in IS-456-2000.

                                My main aim is to bring treasure that is hidden in this sheet is to evaluate modification factor for tension and compression steel directly from this sheet rather than from figure No-4 & figure No-5. Calculating modification factors from fig-4 & 5 is quite seditious and we can’t correctly take value from this.

                                You can ask what innovation I have done to convert all those difficultly to simplicity. Actually I have used SP-24, an explanatory handbook on Indian Standard code of practice for Plain and reinforced concrete. There is an empirical formula on this explanatory handbook on basis of which graph for fig -4 & 5 has been developed in  IS 456:2000. I have used this empirical formula directly in the excel sheet. There is no need to do any interpolation.

                                Please download this and enjoy working with this. You need to put your input in highlighted area with yellow color. Results will come automatically in the same sheet.

                               This treasure having an attachment of excel sheet for the design of RCC beam with defection check with modification factors in IS456:2000 with empirical formula (Mentioned in SP-24) instead taking result from fig-4 &5 of IS456:2000 which is tedious and lot of interpolation is required. 

          Please enjoy with this sheet and download here in the below link. 

DOWNLOAD EXCEL SHEET FOR THE DESIGN OF BEAM WITH DEFLECTION CHECK AS PER IS-456-2000

Thanks

Mohammad Sohel Akhtar(MSA)

(Structural Engineer)



EXAMPLE ON DEFLECTION CALCULATION FOR CANTILEVER BEAM SUBJECTED TO TRIANGULAR LOAD,SERIES-2

“Feel the structure” MSA

Dear friends!

In Continuation to Series-1 for the deflection calculation for Cantilever beams, now i am going to share you with an example of cantilever beam subjected to to triangular loading.This series is titled as “Series-II” .As a structural engineer, you are always going to evaluate deflection calculation for vertical cantilever (assembling of  walls and columns) for earth and water retaining purpose.In that case, triangular loading is common. It’s calculation is quite easy. In this section too, i am going to solve an example with three standard methods like:

            1. Unit Load Method

            2. Moment Area Method

            3. Conjugate Beam Method

Download PDF from download pdf tab

DOWNLOAD PDF

            Whichever method is most suitable to you, adopt it accordingly. Although, many Structural Engineer know much in depth about it but i am sure this section is going  to bring them all to the basic and certainly they will find something very new in this.Also,it will help them to refresh their basic knowledge. Apart from this,this example is going to be a very big boost to the beginner. Actually in college days,civil engineers solve deflection for different loading but without knowing reason and practical application & they generally do not not know why there is a different loading pattern for different circumstances.Now they will understand, why they were used to solve numerical on triangular loading. Genuinely, at that time of academic level, purpose was not clear but after coming to practical field, they will understand,why it is essential to know application of different load patterns like point loads, uniformly distributed load, triangular load, trapezoidal load,concentrated moment etc.at different circumstances.

            I hope you will understand through this example. Please download attached example sheet for the same from below from download pdf.

Download PDF

Thanks

Mohammad Sohel Akhtar(MSA)

(Structural Engineer)



EXAMPLE ON DEFLECTION CALCULATION FOR CANTILEVER BEAM SUBJECTED TO TRAPEZOIDAL LOAD,SERIES-3

“Feel the structure” MSA

Hello friends!

In continuation to Series-(I) & Series-(II) for the deflection calculation for uniformly distributed loading and triangular loading, now read this article here for the deflection calculation for a cantilever beam for trapezoidal loading.

 Here an example has been solved for a trapezoidal loading with an intensity of load “w” at the tip of beam and “2w” at the fixed end of the cantilever beam.

Download pdf from below link

Download PDF for deflection Calculation for beam subjected to trapezoidal loading

             Deflection has been calculated by Unit Load Method/Virtual Method by superposition principle. Please go through the example to understand better about the concept. As said in my previous blog,it is highly recommended to understand the fact ,why do we study trapezoidal loading and where is it’s application. Actually whenever you will design foundation for a column subjected to  axial load along with moment,base pressure diagram will not be uniform. Because base pressure at one end will be maximum ( P/A+M/Z )and at other end it will be minimum( P/A-M/Z).Where, P= Axial Force, A= Total Area, M=Bending Moment, Z= Section Modulus.Connecting with a line for maximum and minimum value of pressure will give a pressure diagram which is trapezoidal in shape. Same thing happens when you design a base plate  or anchor plate having column subjected with axial load & moment. Base  pressure is  generated from top of pedestal in the same way.

              So, it is essential to know, how to calculate bending moment and deflection at critical section for the design of footing or base plate which is subjected to axial load along with moment. In this blog, i have tried to explain same thing with an example.

Note: My blog is not for those who are addicted to software only like STAAD, ETABS, SAFE, SAP2000, ANSYS etc. and many more.People who believe in, put the value and get the result is suggested not to read my blog.It is not going to help them. Certainly, my blog is going to help a lot to those people who believe in manual calculation.To be a good structural engineer, it is better to be more focused & monomaniacal to manual calculation & check rather than software addiction.It will help you to feel the structure.

            So far, i have discussed very basic topics and step by step will gradually be moving to advanced one.Right now enjoy.

Please download attachment from the below mentioned link.

Download PDF for deflection Calculation for beam subjected to trapezoidal

Thanks

Mohammad Sohel Akhtar(MSA)

(Structural Engineer)