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

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.

Thanks

(Structural Engineer)

## THINGS TO KEEP IN MIND FOR STRUCTURAL ANALYSIS & DESIGNING OF BUILDING

“Feel the structure” MSA

Hello! Structural Engineering Fraternity

I am a Structural Engineer. My main work frame is to analyse & design simple to complex structure. I encourage many young civil engineers who have just passed out  from college and want to make a career in Structural Engineering.Also, my blogs will work as a tonic to some civil engineers who are already in this field but feeling very low due to lack of knowledge and skills. My blogs are certainly going to bring not only their professional growth but also they will start loving this challenging field.It will indulge them to be more innovative.

I believe in 4’S&DE.

S= Stability, S= Strength, S=Stiffness, S=Sustainability, D= Durability & E= Economy

4’S&DE is my basic principle of analysing and designing any structure and same shall be followed by any Structural Engineers.I have seen many engineers who sometime think, if a structure is having sufficient strength against shear, moment and torsion instead of lacking in stiffness and durability, it looks fine to them. But i want to clarify one vital point, without having proper knowledge of deflection check(Based on Stiffness),Durability Check(Based on proper grade of material selection, life time exposure of structure to environment) and Economy (Based on client’s budget) no Structural Engineer is going to be very successful in their field.

My friends, if you want to make a career as a RCC Designer, then it is very important for you to understand deeply about concrete technology. Until & unless ,you are able to understand the chemical reaction tacking place in concrete and adherence it’s hydration product to different deleterious gases and chemicals in the environment,you will not be able to judge which materials like  PPC or OPC or sulphate resisting cement is most suitable as far as durability is concern.You will be astonished by knowing the fact,sulphate reacts with the C-H-S gel(hydration product of cement) and concrete gets expanded by 300% by volume. You can feel now to what extent it can damage concrete by developing cracks and it further give path to ingress other deleterious chemicals like chloride to reach reinforcement. Also we should have knowledge about high performance concrete like high flow concrete & self compacting concrete where there is a congestion of reinforcement to avoid honey combing.

And last one is economy. It requires rigorous analysis or you can say this is the most tedious part. In order to design building under the specified budget, we require lot of  reiteration process giving optimum member size fulfilling 4’SD.

My main area of blog writing is to cover  4’SDE. Time to time, i will share excel sheets that will help not only freshers but also practising engineers.Also, i will regularly update you with some hand calculation for the analysis and designing of  simple frame and structural elements to bring you all to the basic. Please keep in mind, in fast pace of working environment, we are forgetting our basics and it is becoming very disastrous for all of us.Above all,i believe in sharing of knowledge and skills.What is the use if somebody is having huge knowledge and skills & carrying all these  to grave. I think,noting at all. I have realised this now and understood the importance of sharing. So, hope somebody will get benefit from my sharing. Also believe, even if a single person is able to uplift his/her career,then my blog writing will be successful.

Most importantly, even a practising structural engineers will find something very new and innovative in my blog.

Last but not the least, i will request you all who reads my blog to give their valuable observations/suggestions to improve it’s content.

Thanks

(Structural Engineer)

## DIFFERENCE BETWEEN PRE-ENGINEERED STEEL BUILDING & CONVENTIONAL STEEL BUILDING

“Feel the structure” MSA

Hello friends!

Here i have tried to to provide you a key comparison between Pre -Engineered Steel Building(PEB) and Conventional Steel Building(CSB) and today’s dominance of using PEB over CSB and it can be more understood from the literature that i have explained with simple figures.

Now by reading this attached article showing difference between PEB & CSB, you will be easily understood, why people are more inclined to the structure which are to be built in PEB.

Thanks

(Structural Engineer)

## DOWNLOAD EXCEL SHEET FOR THE DESIGN OF COMBINED FOOTING WITH UN-EQUAL OVERHANG

” Feel the structure” MSA

Hello!

Dear friends, in continuation of previous blog in which i have shared one of the most valuable excel sheet for the design of isolated footing. Now i am going to share another most valuable excel sheet for the design of combined footing.It is verified.Just download it & enjoy.

In this excel sheet for the design of combined footing for equal over hang,analysis is shown in the same sheet & on the basis of analysis,design come automatically in the same sheet with BMD. As an input,you need to put reaction of two columns, centre to centre distance between two columns, Safe Bearing Capacity (SBC) and rest of the out put like +ve and -ve moment,base pressure and thickness checking for one way and two way will  come automatically. Also, reinforcement detailing with diameter and spacing at bottom and top of footing will come automatically. Dude, enjoy working with this sheet.

DOWNLOAD FREE EXCEL SHEET FOR THE DESIGN OF COMBINED FOOTING WITH UN-EQUAL OVER HANG.

I believe in the fact, a leader’s work is to create more leaders.In this world of mediocrity, victim hood and criticism, even if a single person is  benefited in this world with this share, it will give me immense pleasure.

Guys, in this series, i will also upload, verified design excel sheet for pile and pile cap, anchor bolt & base plate. After this, foundation part will be completed.

After completing uploading design excel sheet for foundation, i will share you manual analysis tricks for analysis of deflection for various structural elements, RCC design of structural elements, various literature on earthquake and wind.

Thanks

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

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.

Thanks

(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:

2. Moment Area Method

3. Conjugate Beam Method

Thanks

(Structural Engineer)

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

“Feel the structure” MSA

Hello friends!

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.

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.

Thanks

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

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.

Thanks

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

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

Thanks

(Structural Engineer)

## EXCEL SHEET FOR THE DESIGN OF ISOLATED FOOTING WITH ACTUAL SURCHARGE/EARTH FILLING LOAD

“Feel the structure” MSA

Dear Friend,

Here i am attaching a valuable excel sheet for the design of isolated footing with actual surcharge /earth filling weight calculated in the same sheet. Generally, as a designer, we take 10% of total axial load for self weight of footing and filling but when you will actually calculate surcharge/filling weight & self weight of footing, it will be 30% to 40% and in some cases it may even  be 50%.

Hence, it is better to calculate self wight of footing and filling weight instead of taking it 10% of total axial load (1.1xP).

From here, download this excel sheet which will automatically take filling and self weight of footing when you put size and thickness of footing.