Slab Design Excel Sheet

Design of one way Slab over Platfrom Here the aspect ratio Ly/Lx Ly/Lx is greater than 2 hence slab is designed as a one way slab OneShort OneShort or Both Both ShortEdgesD ShortEdgesDisCo isContinu ntinuous: ous: yes Basic diensions o! slab " Basic Ly/Lx ratio

"

Clear co+er to rein!orceent -ro+ided o+erall depth E!!ecti+e depth Diaeter o! bar 

d, D d φ

" " " "

Select .rade o! Concrete Select .rade o! Steel

! c !y

" "

Dead load o! the slab 0loor !inish1oo! !inish3 Li+e load

DL 00 LL

" " "

4otal load -artial Sa!ety !actor !or Load

4L

" "

Lx #$%& '$()* Hence desi

Load calculation :

Moment and Area of Steel calculations: 5u 9$ ;($%;

5u/bd6 9/2 )$<<';

-t  #)$(&

7st re8d 5in 7st 6 6 &)*$&& 2)(

Dia o! bar    )(

Check for Deflection 4he e!!ecti+e depth pro+ided basic +alues o! span to e!!ecti+e depth ratio as per =S>#;< 5odi!ication !actor1due to steel in tension3 e8uired depth under de!lection consideration ); 2( 2; '(

#

2;( #); ;((

'

= = = =

)&;$ )&;$(( ((  2($((( )$;( o )<;$ )<;$&* &*  S70E

Ly ); ?2 igned as an one way slab 2(  2(($((  )&;$((  )(  '( 9/6 ;(( 9/6

;$((( 9/6 ) 9/6 ; 9/6 ))$((( 9/6 )$;

Spacing  *(

7st pro 6 %*)$&;

!s 6 2)2$'2

sa!e

Design of two way Slab Here the aspect ratio Ly/Lx is less than 2 hen ce the slab is designed a s a two way slab Basic diensions o! slab

"

Basic Ly/Lx ratio

"

Clear co+er to rein!orceent -ro+ided o+erall depth E!!ecti+e depth Diaeter o! bar 

d, D d φ

" " " "

Select .rade o! Concrete Select .rade o! Steel

!c !y

" "

Dead load o! the slab 0loor !inish1oo! !inish3 Li+e load

DL 00 LL

" " "

4otal load -artial Sa!ety !actor !or Load

4L

" "

Lx #$2 )$)%( Hence d

Load calculation :

Moment and Area of Steel calculations: Span

5oent Coe!!icient

shorter  longer 

5u 9$

5u/bd6 9/2

-t 

7st re8d 5in 7st 6 6

Dia o! ba 

αx neg

($(;)<

)($;*

($&'#*

)&$#(

2(*$*<

)##

*

αx pos

($('*'

&$*;

($;#;#

)2$*2

);'$*(

)##

*

αy neg

($('&(

&$;%

($;2<%

)2$'&

)#*$#%

)##

*

αy pos

($(2*(

;$&#

($'%*&

%$'2

)))$&%

)##

*

Check for Deflection 4he e!!ecti+e depth pro+ided basic +alues o! span to e!!ecti+e depth ratio as per =S>#;< 5odi!ication !actor  e8uired depth under de!lection consideration

=

)2($(((  2($((( = )$%( o = ))($;;  S70E Euations used for the coeffients of moments as !er "S#$%& where '(ly)l': αx neg" 122'<&$%<#'*3@1>);#&(;$<(#';3Ax@1#&*<()$((;);3Ax2@1>*&22(#$%2''*3Ax'@1)('&(;#$*'% αx pos"

); 2( 2; '(

1>2)%%($%2*2%3@1);''*($''&2<3Ax@1>#&*#<#$'*%%23Ax2@1*&%);#$&)*;'3Ax'@1>)(;'*')$#') # 2;( ' =nterior -anels #); One ShortEdge Discontinuous ;(( One LongEdge Discontinuous 4wo7dacentEdgesDisContinuous: 4wo ShortEdge Discontinuous

4wo LongEdge Discontinuous 4hreeEdge Discontinuous1One LongEdge Continuous3 4hreeEdge Discontinuous1One ShortEdge Continuous3 0ourEdges Discontinuous "nterior Panels αx neg "122**<$&(<#<3 @ 1>);%(*2$'%<<#3Ax @ 1#%#;&'$#(22*3Ax2 @ 1>%(;&(2$#<;&;3Ax' @ 1)(*2() αx pos

"1><'$%'<%%3 @ 1';2$%)&'<3Ax @ 1>*#'$)*))<3Ax2 @ 1))'%$2)'(#3Ax' @ 1>%;2$22(')3Ax# @ 1;(

*ne ShortEdge Discontinuous αx neg "12&)')$<&%(%3 @ 1>)**;;)$(;'*)3Ax @ 1;*<(<&$&;##23Ax2 @ 1>)(&'(#($')%2%3Ax' @ 1)2*)& αx pos "1>22'#'$*')''3 @ 1);<2&($;*)&;3Ax @ 1>#***)%$2#*<<3Ax2 @ 1%((<2#$#<;(<3Ax' @ 1>)(*2# *ne LongEdge Discontinuous αx neg "122'<&$%<#'*3 @ 1>);#&(;$<(#';3Ax @ 1#&*<()$((;);3Ax2 @ 1>*&22(#$%2''*3Ax' @ 1)('&(; αx pos

"1>2)%%($%2*2%3 @ 1);''*($''&2<3Ax @ 1>#&*#<#$'*%%23Ax2 @ 1*&%);#$&)*;'3Ax' @ 1>)(;'*

+woAd,acentEdgesDisContinuous: αx neg "12(%2<$('*(%3 @ 1>)#;2(&$;;*<*3Ax @ 1#;(&<&$%'')#3Ax2 @ 1>*2##<($#%;()3Ax' @ 1%*#()& αx pos "1<<;;$*;;()3 @ 1>#;%**$*'#()3Ax @ 1)#2)))$#<#'*3Ax2 @ 1>2;*<;<$<))#'3Ax' @ 1'(&))'$'& +wo ShortEdge Discontinuous αx neg "1)&;'%$('#<23 @ 1>)2')*2$)&##%3Ax @ 1'*<*;*$2#(;3Ax2 @ 1>&);#;<$*%<'#3Ax' @ 1*<2%#&$ αx pos

"1>'''&$&;%;23 @ 122#<)$(;&##3Ax @ 1><&;)2$<''&*3Ax2 @ 1))%'*%$(;&;;3Ax' @ 1>)'&;%($#)

+wo LongEdge Discontinuous αx neg "( αx pos

"1<<<&$&&)('3 @ 1>#;<*($)#);23Ax @ 1)'%%'($%&<'#3Ax2 @ 1>2;2#2&$';*&;3Ax' @ 12%&((#$*

+hreeEdge Discontinuous-*ne LongEdge Continuous. αx neg "1>)22#%$%;;*)3 @ 1*<)2%$)*)'3Ax @ 1>2&(*)#$')%)%3Ax2 @ 1;()#%;$2'(#23Ax' @ 1><(;&2&$& αx pos "1>2&%''$;;#);3 @ 1)%;;&'$<%&<;3Ax @ 1><)2#''$(*2#&3Ax2 @ 1))2%<#'$'*&(23Ax' @ 1>)';% +hreeEdge Discontinuous-*ne ShortEdge Continuous. αx neg "( αx pos

"1#(%;$2(*<#3 @ 1>2&<&<$)<&;;3Ax @ 1*';*#$&*';%3Ax2 @ 1>)#*;&#$&(%*<3Ax' @ 1)&2)<2$2(

/ourEdges Discontinuous αx neg "( αx pos

"1)'***$&*&))3 @ 1>%<&%#$#'#(#3Ax @ 1'()<*)$('&##3Ax2 @ 1>;;'&<*$%%#%'3Ax' @ 1<<'('&$*

Ly ; signed as two way slab 2;  );($((  )2($((  )(  '( 9/6 ;(( 9/6

'$&;( 9/6 2$; 9/6 )$; 9/6 &$&;( 9/6 )$;

Spacing 

7st pro 6

!s 6

2((

2;)$''

2#)$((

sa!e

2((

2;)$''

)&&$#&

sa!e

2((

2;)$''

)&)$'#

sa!e

2((

2;)$''

)2*$%%

sa!e

#3Ax#@1>*#(&)($22%#&3Ax;@1#&(<#%$2(;*'3Ax<@1>)&%<*;$)))'23Ax&@1##&&*$#;(2*3Ax*@1><;&*$2(%#)3Ax%@ %*3Ax#@1*<))<2$)2;)*3Ax;@1>#*;*%%$&#&*'3Ax<@1)*<%#2$%#&**3Ax&@1>#<%#($'2)&%3Ax*@1<%#<$%2<'23Ax% ' ($(;)< ($(((( ($('*' ($(((( ($(&)#

%$%%''&3Ax# @ 1>**)2';$%;%(;3Ax;@ 1#%;;;#$*2&&%3Ax< @ 1>)%(()2$*&'&)3Ax& @ 1#&;#*$<22;;3Ax* @ 1>&()2$ #$###')3Ax;@ 1>)<;$#*<('3Ax< @ 1'($&;'%#3Ax& @ 1>2$#*();3Ax* @ 1(3Ax% @ 1(3Ax)(3

(<$''(('3Ax# @ 1>)(#'&)&$*<;&)3Ax;@ 1;*<*<&$#;&(23Ax< @ 1>22;();$;#'<)3Ax& @ 1;<'(*$&)(<23Ax* @ 1>*' '$*2;2<3Ax# @ 1**<*<($;#&2%3Ax;@ 1>;()<<<$;2<('3Ax< @ 1)%'#*($(';)%3Ax& @ 1>#*<%;$##&<#3Ax* @ 1&222$

$*'%2#3Ax# @ 1>*#(&)($22%#&3Ax;@ 1#&(<#%$2(;*'3Ax< @ 1>)&%<*;$)))'23Ax& @ 1##&&*$#;(2*3Ax* @ 1><;&*$ )$#')%*3Ax# @ 1*<))<2$)2;)*3Ax;@ 1>#*;*%%$&#&*'3Ax< @ 1)*<%#2$%#&**3Ax& @ 1>#<%#($'2)&%3Ax* @ 1<%#<$

$<#*)<3Ax# @ 1>*((*%*$((<2&3Ax;@ 1#;(2'#$*<%(&3Ax< @ 1>)&2<#2$()%#&3Ax& @ 1#'2)%$2;<')3Ax* @ 1><'&%$2 ;%*3Ax# @ 1>2#*;**$2)*')3Ax;@ 1)'*%'<$%<'<%3Ax< @ 1>;2%;($*(<23Ax& @ 1)')&)$2%%<'3Ax* @ 1>)%')$2)&#;3

#*)*3Ax# @ 1>&(%';'$';)('3Ax;@ 1#(2#*<$#;2#<3Ax< @ 1>);;<<*$((;%'3Ax& @ 1'%2*($&<2&&3Ax* @ 1>;*#($22 2)'3Ax# @ 1)(*((#$;*22&3Ax;@ 1>;*#%&$2<<<*3Ax< @ 12);%)$&**&3Ax& @ 1>;)%%$2#)(*3Ax* @ 1&'&$&(%<%3Ax%

#)'3Ax# @ 1>2'*)%)$;;;&;3Ax;@ 1)')*&%$%2<%&3Ax< @ 1>#%&*'$*#2(23Ax& @ 1)22<#$'**2&3Ax* @ 1>)&*($&;##

%*#<3Ax# @ 1#%*<<&$(%#;*3Ax;@ 1>2*''%*$#)2#;3Ax< @ 1)(%&%;$(%;<23Ax& @ 1>2&&;#$<';&23Ax* @ 1#)'#$)#% ;&$&*&2<3Ax# @ 1)))#%2%$<''#23Ax;@ 1><')#(<$;'%&23Ax< @ 12#'&%*$&<2#; 3Ax& @ 1><)#'($2'*&;3Ax* @ 1%)2

*<3Ax# @ 1>)';%(*$&%(#)3Ax;@ 1&#(';$';#*;3Ax< @ 1>2&#*#$&<'(&3Ax& @ 1<<;;$%2)'&3Ax* @ 1>%#%$<2;;#3Ax

2;'*3Ax# @ 1>;#)))'$);<#3Ax;@ 1'(#*<%$#*;&23Ax< @ 1>))&)(2$*(#(#3Ax& @ 12%';)$('2)23Ax* @ 1>#'';$')*

1#'2$<;(('3Ax)( 1>#<($2(&';3Ax)(

&**'*3Ax% @ 1#<2$%<'(*3Ax)(

;$;(2;<3Ax% @ 1;#*$'%(*3Ax)( &&;))3Ax% @ 1>#&%$#%&#&3Ax)(3

(%#)3Ax% @ 1#'2$<;(('3Ax)( %2<'23Ax% @ 1>#<($2(&';3Ax)(3

#;#'3Ax% @ 1#2)$<2&(%3Ax)( Ax% @ 1)2<$&<'&3Ax)(3

#(#3Ax% @ 1'**$;;*2%3Ax)(3  @ 1>#<$*#&#<3Ax)(3

%3Ax% @ 1));$&#(&&3Ax)(3

%*3Ax% @ 1>2&;$;&'2;3Ax)( 2$(2;%*3Ax% @ 1><(<$2<))&3Ax)(3

% @ 1<($<2<)23Ax)(3

;3Ax% @ 12*<$;%<)%3Ax)(3