Design of two way slab as per IS 456 excel sheet

[RAJATSHANU64]

Hey guys i have made a excel sheet for design of two way slab i was wondering if you guys could check it out a feedback from your end would be appreciated a lot. use this excel sheet in pc and also enable macro. thanks

 

[sumit_Civil79]

gd v helpful this sheet

Hey guys i have made a excel sheet for design of two way slab i was wondering if you guys could check it out a feedback from your end would be appreciated a lot. use this excel sheet in pc and also enable macro. thanks

 

[Bandya]

A good job you have done. I haven't gone in to details of design but would like to know if you have considered effective depth for longer span = D-Dc-d-d/2 since reinforcement is laid in two layers @ 90 degrees..
Please confirm

 

[RAJATSHANU64]

A good job you have done. I haven't gone in to details of design but would like to know if you have considered effective depth for longer span = D-Dc-d-d/2 since reinforcement is laid in two layers @ 90 degrees..
Please confirm

yes i have considered the effective depth for longer span = effective depth for shorter span - dia of bar
however i assure you that this don't make much different

 

[Aakash Dudhat]

Design Two Way Slab


The most difficult and tedious design of building construction is Design Two way slab because of the various condition of the design step and also repeated and long step

But But But
This problem is no more because you come to my blog so that you will find an Excel Design Sheet

No one gives a personal design sheet because of

1) Monopoly
2) Hesitated to share the personal skill
3) they try to filter their position

But my goal is very different which shown top of my site CIVIL EXPERIENCE

Only one Step for Design Two Way Slab
just add a few information Which shown in Image like
Grade of concrete ƒck,
Grade of Steel ƒy,
Concrete cover,
Clear long spam,
Clear short spam,
With of supporting beam,
live load,
Floor finish load,
Diameter of main and distribution bar, and
assume thickness of the slab

and what YOU WILL SHOWN RESULT OF DESIGN TWO WAY SLAB IN JUST a FEW SECOND

Design Two Way Slab

The calculation step which I cover in excel sheet is listed below

1. Effective Depth
2. Load calculation
3. Support condition
4. B.M. Consideration
5. Check for deflection
6. Check for Shear

So you can easily design the best structural and economical design of Two Way Slab Reinforcement Details Design


DOWNLOAD Excel file


If You have any query about this excel file or need any other help or information please don't hesitate to contact us


Also Read:-


how to calculate quantity of cement mortar in brickwork and plaster excel

How To Calculate Concrete Volume For Trapezoidal Footing/Sloped Footing By Excel

Bar Bending Schedule for estimation of Column Reinforcement by Excel Sheet

One Way Slab Reinforcement Details Design by Excel - civil Experience

how to calculate cement sand and aggregate quantity in concrete Automatically

Cutting Length of Rectangular Stirrups with Excel sheet || Stirrups Length Calculation

 

[Bandya]

Excellent job. I think the front page should give instructions on how to utilize the design sheets. Explanation is necessary to identify slab panels rather than directly going to S1 S2 etc.

 

[Aakash Dudhat]

Excellent job. I think the front page should give instructions on how to utilize the design sheets. Explanation is necessary to identify slab panels rather than directly going to S1 S2 etc.

You only field the nominal data which in yellow and blue colors

also i write list which you enter data
Grade of concrete ƒck =
Grade of Steel ƒy =
Concrete cover =
Clear Short Span Lx=
Clear Long Span Ly =
Width of Supporting Beam =
Assume Thickness of Slab =
Dia. of Reinforcement Bar=
Super Imposed Load =
Floor Finish Load =

then carefully
Area of Steel along Short Span = ( which you want to provide )
Minimum Area of Steel = ( which you want to provide )
Provide Area of Steel = ( after see the result Area of Steel along Short Span & Minimum Area of Steel carefully select the Provide area of steel which we follow for design )
Width of Middle Strip =

 

[Bandya]

Thanks you akash Dudhat. I am still confused about how and when I am supposed to enter the slab type or Number S1 S2 etc.

 

[Aakash Dudhat]

Excellent job. I think the front page should give instructions on how to utilize the design sheets. Explanation is necessary to identify slab panels rather than directly going to S1 S2 etc.

How To Calculate Concrete Volume For Trapezoidal Footing/Sloped Footing By Excel

I prefer to watch this video to guide how to use
This video is about footing but you absolutely get idea about how to use

 

[Simranto09]

I am supposed to enter the slab type or Number S1 S2 etc.

 

[bondarder]

sir it is restricted only at 3.50 & if span size 4.77x4.20 m it is not good..