## 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.

Thanks

Mohammad Sohel Akhtar(MSA)

(Structural Engineer)

## EXAMPLE ON DEFLECTION CALCULATION FOR CANTILEVER BEAM SUBJECTED TO UDL & POINT LOAD,SERIES-1

“Feel the structure” MSA

Dear friends!

In this series-1, i have come up with very simple example with a cantilever beam with point load and distributed load and calculated maximum deflection at tip of beam with different methods. Well known method that i have used to calculate deflection  are:

1.   Unit load method /Virtual Method

2.   Moment Area Method

3.   Strain energy Method(Based on Castigliano’s Method)

4.   Conjugate beam method

In this attached sheet, i have solved very simple two examples with above four method. Whatever method is best suited to you, you can adopt it and all of these will give same result. I have give name, Series-1 because i will upload many examples for calculation for deflection of beams  which will come in another Series like Series-2, Series-3 etc.

Download pdf from download pdf tab

DOWNLOAD PDF

In order to create interest to readers, i have come with very simple examples. Definitely you are going to learn few new things.Please read the whole attachment.

Structural engineers are more concerned about to check deflection for cantilever beams and lateral drifting of whole structure due to wind or earthquake. All buildings are vertical cantilevers. As a structural engineers, our main assignment is to check maximum drifting at the top floor. This calculation could be carried out with simple calculation. By taking shear walls as a single entity and attracting definite portion of earthquake load, having flexural rigidity  “EI”, and height “h” , we can calculate deflection at the top floor to check whether deflection at the top floor is under permissible limit or not.

We will go in deep to earthquake and wind loading topic in my later blogs.

Here, please download attached examples on deflection calculation for cantilever beams with various method explained above.

DOWNLOAD PDF

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.

Thanks

Mohammad Sohel Akhtar(MSA)

(Structural Engineer)

## BEST & SELECTED EXAMPLES FOR CALCULATION DEFLECTION OF BEAM,EXAMPLE-SERIES-4

“Feel the structure” MSA

Dear friends,

Here i have attached very selected and important examples for finding out deflection for determinate beams.You will find all examples very interesting. Actually in this series, i have calculated deflection for beams subjected to couple/concentrated moment.You will understand later why these examples are important.Furthermore, i am trying to lay a foundation for you to move to the next level.For this, you need to understand how to evaluate deflection for determinate beams subjected to couple  and other loading. Solving easily deflection for determinate beams for different kinds of loading will help you to form stiffness matrix.And as you know, how formation of stiffness matrix helps to evaluate eigen value in matrix analysis and it further helps up us to evaluate different mode shape in dynamic analysis.Please go through these examples and will bring some more examples in Series-V to complete the deflection topic covering all kind of loading at different location over the beam.

Download PDF from below link

DOWNLOAD PDF FOR DEFLECTION CALCULATION FOR SELECTED & IMPORTANT EXAMPLES

I have tried my best to solve these examples in a simplest way and if there is any further improvement is required, please write in comment box.Now, just go through these valuable examples and enjoy.

Please download attachment from here.

Thanks

Mohammad Sohel Akhtar(MSA)

(Structural Engineer)

## EXAMPLE ON DEFLECTION CALCULATION FOR BEAM SUBJECTED TO UDL AT PARTICULAR SPAN OF BEAM,SERIES-5

“Feel the structure”MSA

Dear friends,

As Explained in Series-IV, i am here by uploading deflection  calculation for cantilever beams for a load for a particular regions instead of whole region of beams. I will recommend all structural engineers not to remember general formula. Please go through easy steps which will help you to derive easily for calculation for deflection for  any kind of loads in a beams (either point load, udl,concentrated moments).To grasp whole concept, please go through Series-I to V.

Download pdf from the below mentioned link.

Download PDF for deflection of beam for load at particular region of beam

Now Enjoy this Series and will be back with very interesting examples on analysis of continuous  beams , frames etc. with Moment Distribution Method (MDM)  and will also upload examples on analysis of beams for rolling load based on Influence Line Diagram(ILD).

Please download from here for deflection calculation for beams.

Download pdf for deflection Calculation for Beams, Series

Thanks

Mohammad Sohel Akhtar(MSA)

(Structural Engineer)