Friday, 17 March 2017

Design of Two Way Slab using Excel 

Two Way Slab:
The slab is to be designed as two way slab when the main steel is spanning in both the directions( that is long span (Ly) & short span (Lx)). This is done to transfer the load on to the beams on all the sides.
Theoretically, the slab is to be designed as the two way slab only, when the ly /lx ratio (aspect ratio)is less than 2.But again, practically the things go different. Due to certain limitations, such as economy and certain construction limitations.The slab may be designed as one way having aspect ratio less than one. This also depends upon the support positions and the boundary conditions (such as simply supported, restrained , continuous etc briefly explained in IS 456:2000) mentioned also in the first post, it may depend upon the conditions But as far as the Academics is considered, the slab is always designed as per the aspect ratio.This involves a series of tedious calculations which are can be simplified by the using software.

As already stated, excel is of great importance to we students. Both speed and accuracy are guaranteed when the lengthy calculations are done by excel.Keeping the same in mind, I have came up with one more new Excel Template (Design of Two Way Slab).Surely check that once.

Click here to download the template : Two Way Slab Design Template

In case, anyone wish to download the template.
  • Please take a note this template has been designed for only Fe-415 & Fe-500 grade steel.
  • The sheet has designed with suitable color code, to avoid any further confusion.
  • The worksheet has been programmed considering a little higher safety factor,due to which the values may not be exactly equal to the manual calculations.However it may give an appropriate idea of the steel required with their specifications.
  • Some of the checks are not included in the template and had to be done manually.
  • This file is only for the academics use and should not be used professional design.
  • Reference IS 456:2000.

Hope you like the post.

Any suggestions & comments are most welcome.

Thank you,

Monday, 13 March 2017



     Civil is a branch where Analysis and Design, are the key aspects. Every structure needs to be analyzed and design, before it is truly constructed on site. There are numerous factors to be considered for the stability of the structure as we approach towards design. Hence, accurate design is of extreme importance which significantly affects the safety and serviceability of the structure.
The R.C.C structure(Building) comprises of various structural elements , such as Slab, beam,column,footing lintels etc. All of these elements can further be classified according to these use, construction,size etc.

In this post, I would like to begin with slab,as designing always starts form top to bottom.

The slabs can of many types.One very common type is , slab is One Way Slab.

The slab is usually said to as an one way when the main steel is spanning in only one direction.
Theoretically, it depends up on the aspect ratio (Ly/Lx), But practically the design is based on the experience and the position of the beam and columns supporting the slab so as to achieve economy in the construction.As per the Pune University, the design of One way slab has also been included in the curriculum.
There are many software's available in market for the design and analysis, but as far as academics is concerned EXCEL is the best tool to get your values checked. Furthermore, you can also do your slight modification as per the situation mentioned in the questions.One such template of one way slab  is attached in this post and many are on the way.

Click Here to download: One Way Slab Excel Template

Hope you like the post.

In Case if one wishes to download the file:
Please note,

    • The design strictly follows the procedure of the IS 456:2000,and the conditions have been considered as moderate.
    • The Sheet 1 demands the given data & also shows the the conclusion (The Main Steel Requirement for the given conditions)However the MODIFICATION factor should be entered manually by use of graph provided in the sheet.
    • The Sheet 2 Shows the detailed calculations so that one can relate them to the manually done.
    • The file is only for the sake of assistance. There might be difference between the actual design and the design using this excel file