EXCEL SHEET FOR THE DESIGN OF REINFORCED CEMENT CONCRETE (RCC) SLAB

“Feel the structure” MSA

Attached here is ultimate excel sheet for the design of slab as per IS-456-2000. Here, you will find input as well as output data in the same sheet and same has been clearly stated inside the this incredible sheet.

Thanks

(Structural Engineer)

EXAMPLE ON ANALYSIS OF 2-SPAN CONTINUOUS BEAM BY MOMENT DISTRIBUTION METHOD(MDM) – EXAMPLE, SERIES(II)

Feel the structure” MSA

Download here an attached example solved for two span continuous beam by moment distribution method. In this example, a two span continuous beam in which one span is with uniformly distributed load and another span is loaded by a point load at center. In this example, far end is fixed.

DOWNLOAD PDF FOR EXAMPLE SOLVED BY MOMENT DISTRIBUTION FOR CONTINUOUS BEAM WITH FAR END FIXED, EXAMPLE,SERIES-II

In this example, i have tried to detailed out analysis of a continuous beam with moment distribution calculating BMD and SFD and i have cleared concept on carry over moment and balancing moment with giving some special notes.

Thanks

(Structural Engineer)

HOW TO MAKE CAREER IN STRUCTURAL ENGINEERING

“Feel the structure” MSA

Note: This Blog is for those civil engineers who want to make career in Structural Designing of buildings

This is a high time to share with you a very vital information for a beautiful career in structural engineering. Essentially you need to be civil engineer. If you are M.Tech in structural engineering, then it is more preferable.However, it’s not a strict criteria to enter in the field of structural engineering and designing. You can Enter in this field with bachelor degree as well.

If you are very keen to work in this challenging field, then you need to know the inside story of structural engineer working in this field. Here i am going to tell you the entire procedure involved in the analysis, designing , co-ordination and issuing drawing to sites. If you know all these steps in advance, the it will be very easy for you to establish in this field.

Before writing steps involved from conceptual level to construction stage, you need to understand the team involved for the finalization good for construction drawings.

Following teams involved in the finalization of drawings at office & issuing it to site:

1. Architects
2. Structural Engineers
3. Structural draughtsman
4. MEP (Mechanical, Electrical & Plumbing Engineers)

STEPS INVOLVED:

STEP: 1Surveying

After receiving work order from a client, architect co-ordinate with a surveying agency to make contour plan for deciding buildings plinth level and site development and this contour plan is very essential to know the site condition whether it is above the existing road level or below the road level. Structural engineers substantially use reduced level mentioned in the contour plan to filling load if filling is required to achieve desired plinth level. Also, ramp and road are made based on this contour plan.

STEP: 2Geo technical Investigation

Architect after receiving contour plan,they start planning building on it. They show road development and fit all building on this survey with orientation & based on this, master plan is made.

After putting all building desired by client, architect pass on this site plan having all blocks to the structural team to locate bore hole for soil investigation for foundation design. Structural engineer mar bore hole as BH-1, BH-2, Bh-3 & so on the site plan and issue it the Geo- technical investigation agency with certain specification to find out safe bearing capacity(for open foundation),pile load capacity if there is recommendation of pile & modulous of sub grade reaction if there is a recommendation of raft.

Note: No Geo technical report is assumed to be final until & unless it is approved by a structural engineer. A structural engineer thoroughly review the soil report. Structural engineer guides Geo technical engineer to provided additional data if needed giving a concrete reason. For example, if there is recommendation for pile foundation of 600 mm diameter, then it is our responsibility to ask Geo technical engineer to provide recommendation for 450 mm & 300 mm diameter pile as well for the small buildings. Also, in report, Geo technical engineer shall be reminded to provide recommendation sheet for isolated footing because for extremely small structures like guard room, porta cabins & boundary walls,this data will be useful. Also,in some Geo technical report,there may be only one recommendation of isolated footing but we should ask for the recommendation for sub grade reaction as in the same site , there may a provision of under ground tank or in some places most of individual footings for separate column may over lap each others, hence recommendation for sub grade modulus is essential for designing raft.

STEP: 3Preliminary Framing & Column Placement

Once site plan is finalized, column is placed with different orientation in each building blocks and based on column placement, tentative framing is made. This framing with column is shared to the architectural team to get their approval as per the functionality of building. Also, tentative beam depth is shown in the drawing. Based on this, architect may change floor to floor height of the building if excessive depth of beam is required for the desired span. Apart from this,Architect coordinate with MEP team for the cut outs for plumbing & fire fighting work. Also, there may AC duct running inside the false ceiling. Based on these criteria, Architect finalize the floor to floor height.Once tentative framing is approved, architect again issue separate drawings to structural engineer of each building blocks with column matching with structural framing and all sections and elevation & after that preparation of tender or DPR(Detail Project Report) starts.

STEP: 4- PREPARATION OF TENDER DRAWINGS & SPECIFICATIONS

After approval of preliminary /conceptual drawings, tender drawings are made. For that,a structural engineer needs to start modeling & analyzing building in softwares like STAAD Pro, Etabs etc. Once analysis & designing is over,structural engineer gives final column sizes & beams to the structural draughtsman.Also,whatever type of foundation is mentioned in the approved soil report, structural engineer provide foundation and that is drafted by draughtsman.

Complete set of drawings having column marking plan, column schedule, foundation plans & sections,floor wise all framing plans having beams sizes and slab thickness, desired section in sunken,cantilever in framing along with staircase sections having waist slab thickness, landing beam sizes and if there is over & under ground tank , its detail shall be provided with section sizes.

Ins short, section sizes of all structural elements are required for quantity take off in making BOQ.

Also, specification for grade of concrete(Like M20,M25,M30…etc), grade of reinforcement(Like Fe500, Fe550 …etc.),grade of cement,type of cement(Like OPC, PPC or sulphate resisting cement) , type of sand, type water proofing materials & type of bricks /blocks shall be provided by structural engineer to the estimator to consider these specs in bill of quantity(BOQ).

STEP: 5-PREPARATION OF GOOD FOR CONSTRUCTION DRAWINGS(GFC)

After getting approval of tender drawings from department/client, department/client call contractor for bidding & this process take considerable time. Meanwhile, as a structural engineer, our main focus is to work on good for construction drawings. If there are some minor correction like missing dimensions, missing sections then these shall be resolved in the GFC drawings. Also, detailed reinforcement in beam as beam elevations and slab as reinforcement layout is made for construction. Also, if there is any instructions from department/client for drawing to be vetted from government institute or individual consultancy firm, then detail calculation report termed as DBR(design basis report) shall be made along with STAAD/ETABS file. These consolidated DBR & STAAD/ETABS file shall be submitted to vetting authority and time to time they shall be chase to get all submitted drawings approved so that there will not be any delay in construction.

Thanks

(Structural Engineer)

“Feel the structure” MSA

Hello Friends!

Here is the attachment of verified excel sheet based on IS 456-2000 for the design of isolated footing.

This is easiest way to work. Only you should put your inputs in the highlighted areas for  reactive forces, external moments and results for checking of footing for one way shear and punching will come in the same excel sheet. Also, reinforcement with diameter and spacing will be highlighted in the same sheet.

You can see all calculation in the same excel sheet.

Thanks

(Structural Engineer)

DOWNLOAD FREE EXCEL SHEET FOR THE DESIGN OF COMBINED FOOTING WITH 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.

Download Excel sheet for the design of Combined Footing for equal overhang

In this 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, 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.

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.

Download Excel sheet for the design of Combined Footing for equal overhang

Thanks

(Structural Engineer)

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.