one way slab and two way slab.xlsx

	B	C	D	E	F	G	H	I	J	N	O	P	Q	R	S	T	U	V	W
1
2	Slab Design
3
4
5		Slab thickness	t	150 mm			Sunken Depth		325 mm
6		Concrete	fck	20 MPa
7		Steel	fy	415 MPa
8
9		Loading								Design Calculations
10		Slab Load					Sunken Slab Load
11		Dead Load	DL	3.750 KN/m			Dead Load	DL	3.750 KN/m	ONE WAY					TWO WAY
12		Live Load	LL	2.000 KN/m			Filler Load	FL	5 KN/m	a	0.75	.=(0.87435/100) * (fy/fck)2			a	0.75	.=(0.87435/100) * (fy/fck)2
13		Finishes Load	WL	1.000 KN/m			Live Load	LL	3.0 KN/m	b	-3.611	.=(0.87/100) * (fy)			b	-3.611	.=(0.87/100) * (fy)
14		Total Load	Ws	6.750 KN/m			Finishes Load	WL	1.0 KN/m	cx	1.654	.=Mu/bd2			cy	0.000	.=Mu/bd2
15		Factored Load	Wsu	10 KN/m			Total Load	Wsk	12.37 KN/m	-px	0.513	.=-(b±√(b2-4ac))/2a			-py	0.000	.=-(b±√(b2-4ac))/2a
16							Factored Load	Wsku	19 KN/m	Ast	667	.=(pbd)/100			Ast	0	.=(pbd)/100
17
18
19		Slab Data								Min Ast	%	mm2
20		Slab Type	Regular								0.12	180
21		Load	10 KN/m
22		Longer Span (ly)	9.50 m				ly/lx ratio	2.02		Interpolation							Table 26 IS 456 pg 91	1	0.056
23		Shorter Span (lx)	4.70 m				Slab type	-		ly/lx			αx			αy		1.1	0.064
24										lower value	upper value	exact value	lower value	upper value	interptn. value			1.2	0.072
25										FALSE	FALSE	2.02	#N/A	#N/A	#N/A	0.056		1.3	0.079
26		Loading on edges		one way	two way													1.4	0.085
27		Wlonger	24 KN/m	.=w*lx/2	.=(wlx/2) + (1-(1/3)(lx/ly)2)													1.5	0.089
28		Wshorter			.=w*lx/3													2	0.107
29
30		Moments		one way	two way					xumax	62	.= (700/(1100 * (0.87 * fy)) * d
31		Mx	28 KN-m	.=w*lx2/ 8	.=αx * w*lx2					Mulim	47 KN-m	.= 0.36fckbxumax(d-(0.42*xumax))
32					.=αy * w*lx2					Mulim/bd2	2.76
33										Mux/bd2	1.65
34		Thickness Check	OK	.=Mulim > Mux or Muy						Muy/bd2	0.00
35		Deflection	10 mm	.= 5Wl4/(384EI)
36										E	2.24E+07
37		Area of Steel	Astx		Refer Chart 4 SP 16 pg 21			or		I	2.81E-04	.= bd3/12
38		Area of Steel	667 sqmm		Refer Table 5-44 SP 16 pg 51-80					Defln	10.23	.= 5Wl4/(384EI)
39
40		Spacing required in mm
41		8#		10#		12#		16#
42		x	y	x	y	x	y	x	x
43		75 c/c		118 c/c		170 c/c		301 c/c
44		.=ast of bar*1000/ast req
45
46		Final Ast provided	x		y
47		Final Ast provided
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100