RCC-Retaing-Wall.xlsx

	B	C	D	E	F	H	I	J	K	L	M
1
2								0.2
3	Design of RCC Cantilever Retaining wall
4
5
6	Height of soil to be retained	H=	4.5	m
7	Depth of Foundation	DF	1	m			4.5
8	Soil pressure co-efficient(Angle of repose 30)		0.33
9	Density of soil		18000	N/m3
10	Concrete Grade - M20		20	N/mm2
11	Steel Grade - Fe415		415	N/mm2
12
13	Stem
14	Stem Top Width	Stw	0.2	m		1	1.3	0.45		2
15	Stem Bottom Width	Sbw	0.45	m			0.4	c	b
16	Stem Height		5.1	m
17	Toe										a
18	Toe width		1.3	m				3.75
19	Toe thk		0.4	m
20	Heel										54852
21	Heel Width		2	m		97648
22	Heel thk		0.4	m
23	Width of Base Slab		3.75	m				82812	77677
24
25	Maximum bending moment per m run of the wall
26		M=	Cp wh1^3/6 - Cp wh2^3/6
27			132435.00	Nm
28	Factored Moment = 1.5 * M		198652.50	Nm
29	0.138Fck bd^2	=187500 X 1000
30		d=	269	mm
31
32	STABILITY CALCULATONS
33
34	Load due to		Magnitue of load (N)	Distance from a (m)	Moment about a (Nm)
35	Stem - Rect portion-0.2x5.1 x25000		25500	2.35	59925
36	Stem - Tappered portion		15937.5	2.17	34531.25
37	Base Slab		37500	1.875	70312.5
38	Weight of soil on Heel		183600	1	183600
39	Weight of soil on Toe		23400	3.1	72540
40
41	Moment of Soil pressure on Heel side				166375
42	Moment of Soil pressure on Toe side				-1000
43
44	Total		285937.5		586283.75
45
46		Z=	2.05	m
47	e= Z-b/2		0.18	m
48		b/6=	0.63	m
49			Safe
50
51	Extreme pressure intensity at base		W/b (1+6e/b)
52
53	Max Pressure		97648	N/m2	9.77 T/m2
54	Min Pressure		54852	N/m2	5.49 T/m2
55
56	Design Of Stem
57	Factored Moment	Mu=	198652.50	Nm
58	Eff. Depth	d=	382.00	mm
59	Mu/bd^2	=	1.36
60	% of steel	Pt =	50[1-sqrt(1-(4.6Mco/20) / (415/20)]
61			0.41	%
62	Main Bar	Ast=	1575.97	mm2
63	Spacing of 16mm dia bar	=	128	mm
64
65	Distribution steel - 0.12%	=	540.00	mm2
66	Spacing of 12mm dia bar	=	209	mm
67
68	Design of Toe Slab
69	The BM calculations for 1m width of Heel slab
70	Upward pressure		Magnitue of load (N)	Distance from c (m)	Moment about a (Nm)
71	Rect Portion -		107656	0.65	69976
72	Triangular portion		9643	0.67	6429
73	Deduct for Self weight of Toe Slab		13000	0.65	-8450
74	Total		130299		67955
75
76	Ultimate Moment	=	101932.42	Nm
77	Eff. Depth	d=	332.00	mm
78	Mu/bd^2	=	0.92
79	% of steel	Pt =	50[1-sqrt(1-(4.6Mco/20) / (415/20)]
80			0.27	%
81	Main Bar	Ast=	901.60	mm2
82	Spacing of 16mm dia bar	=	223	mm
83
84	Distribution steel - 0.12%	=	480.00	mm2
85	Spacing of 12mm dia bar	=	235	mm
86
87	Design of Heel Slab
88	The BM calculations for 1m width of Heel slab
89	Load due to		Magnitue of load (N)	Distance from a (m)	Moment about a (Nm)
90	Backing of earth - 2x4.5x18000		198000	1	198000
91	Dl of Heel slab - 2x0.4x 25000		20000	0.2	4000
92	Deduct for Upward Pressure
93	Rect Portion -		109705	1	-109705
94	Triangular portion		22824	0.67	-15216
95	Total		350529		77079
96
97	Ultimate Moment	=	115618.95	Nm
98	Eff. Depth	d=	332.00	mm
99	Mu/bd^2	Mco=	1.05
100	% of steel	Pt =	50[1-sqrt(1-(4.6Mco/20) / (415/20)]