Two Way Slab Design Excel Sheet
Two Way Slab Design Excel Sheet
Two Way Slab Design Excel Sheet
Input Data:
1
Material :
Concrete Grade M 25
Reinforcement Steel Grade Fe 500
Dimensions: 3
Short Span : Lx: 3.2 m
Long Span : Ly: 5.8 m
Load :
Floor Finish Load wf: 1 kN/m2
Live Load wL: 4 kN/m2
Load Factor for BM: 1.5 9
Load Factor for SF: 1.5
Calculations:
Aspect ratio=Ly/Lx= 1.8125
Slab designed as: Two Way Slab
Page 1
Minimum Ast req=0.12xD/1000= 180 mm2 per meter
Reinforcement Provided:
Short Span Support: 12 Dia at 150 c/c Ast= 753.6 OK
Short Span Span: Dia at
12 200 c/c Ast= 565.2 OK
Long Span Support: Dia at
12 200 c/c Ast= 565.2 OK
Long Span Span: Dia at
10 200 c/c Ast= 392.5 OK
xd2) P-16.
DALAL CONSULTANTS ENGINEERS LIMITED 12/29/2013
7 8 9
Page 7
Sheet3
x support = 0.0613
x span = 0.05
y support = 0.032
y span = 0.024
B D d Mu Mu/Bd2 pt Ast
1000 150 125 8.232 0.526848 0.124 155.32914
1000 150 125 6.1824 0.395674 0.093 115.90562
1000 150 125 4.3008 0.275251 0.064 80.162894
1000 150 125 3.2256 0.206438 0.048 59.925613
#N/A
5 7 9 10
Support 0.0833 0.1 0 0.5
Span 0.0625 0.083 0.125 0
1 2 3 4 5 6 7
0.06125 0.065 0.079 0.08575 0.066 0 0.0925
Page 8
0.046 0.049 0.0605 0.0645 0.04975 0.082 0.07
0.032 0.037 0.037 0.047 0 0.045 0
0.024 0.028 0.028 0.035 0.035 0.035 0.043
Types
Moments
Case no. of
considered
Panels Short Span
(V
1 1.1 1.2 1.3
Interior
1
Panels Negative moment at 0.032 0.037 0.043 0.047
conti. edge.
Positive moment at 0.024 0.028 0.032 0.036
Mid-span
One
Short
2 Edge
Disconti
nuous. Negative moment at 0.037 0.043 0.048 0.051
conti. edge.
Positive moment at 0.028 0.032 0.036 0.039
Mid-span
One
Long
3 Edge
Disconti
nuous. Negative moment at 0.037 0.044 0.052 0.057
conti. edge.
Positive moment at 0.028 0.033 0.039 0.044
Mid-span
Two
Adjacen
4 t Edges
Disconti
nuous.
Negative moment at 0.047 0.053 0.06 0.065
conti. edge.
Positive moment at 0.035 0.04 0.045 0.049
Mid-span
Two
Short
5 Edges
Disconti
nuous. Negative moment at 0.045 0.049 0.052 0.056
conti. edge.
Positive moment at 0.035 0.037 0.04 0.043
Mid-span
Two
Long
6 Edges
Disconti
nuous. Negative moment at 0 0 0 0
conti. edge.
Positive moment at 0.035 0.043 0.051 0.057
Mid-span
One
Long
7 Edge
continu
ous. Negative moment at 0.057 0.064 0.071 0.076
conti. edge.
Positive moment at 0.043 0.048 0.053 0.057
Mid-span
One
Short
8 Edge
continu
ous. Negative moment at 0 0 0 0
conti. edge.
Positive moment at 0.043 0.051 0.059 0.065
Mid-span
Four
Edges
9
Discont
i nuous. Negative moment at 0 0 0 0
conti. edge.
Positive moment at 0.056 0.064 0.072 0.079
Mid-span
1 2
4
3
6
5
8
7
Ast min
180
180
180
180
375
0.7 0.8 1
1.9 1.8 1.6
1.68 1.55 1.4
1.35 1.3 1.2
1.1 1.05 1
0.95 0.9 0.85
#N/A #N/A #N/A
1.75
2
0.25
8 9
0 0
0.08925 0.10175
0.057 0
0.043 0.056
Coefficient
s for all
oefficients values of
alues of ly/lx)
1.4 1.5 1.75 2 ly/lx
0 0 0 0 0.045
0.063 0.068 0.08 0.088 0.035
0 0 0 0 0.057
0 0 0 0 0