RCC62 Retaining Wall_theengineeringcommunity.org.xls

	A	B	C	D	E	F	G	H	I	J	K	L	M	N
1	4.0											OPERATING INSTRUCTIONS
2		Project	Spreadsheets to BS 8110etc					The Concrete Centre				ENTER DATA IN BLUE CELLS ONLY.
3		Client	Advisory Group					Made by	Date		Page	RED MESSAGES INDICATE ENTRY ERRORS.
4		Location	Grid line 1					rc	01-oct.-2026		134
5			RETAINING WALL design to BS 8110:2005					Checked	Revision		Job No
6			Originated from 'RCC62.xls'	v4.0 © 2006 TCC				chg	-		R68
7		IDEALISED STRUCTURE and FORCE DIAGRAMS								DESIGN STATUS:	VALID
8
9		WARNING :
10		Passive pressure should
11		only be considered if it										�
12		can be guaranteed that										�
13		there will be no future
14		excavation in front of
15		the wall.
16
17
18
19
20													bh	2500
21													bh, min	1876,388375
22		DIMENSIONS (mm)										�
23		H =	3250	B =	4000	Tw =	300					�
24		Hw =	1500	BI =	1200	Tb =	300
25		Hp =	300	BN =	0	TN =	0
26		Hn =	0
27		MATERIAL PROPERTIES			steel class	A
28		fcu =	35	N/mm²	gm =	1,5	concrete					�
29		fy =	500	N/mm²	gm =	1,15	steel					�
30					cover to tension steel =	50	mm
31					Max allowable design surface crack width (W) =	0,3	mm	(0.2 or 0.3 mm only)				BS8007 specifies crack widths of 0.1 or 0.2 mm.
32					Concrete density =	24	kN/m³	(0.2 or 0.3 mm only)
33		SOIL PROPERTIES							Wall Geometry
34					Design angle of int'l friction of retained mat'l (Ø) =	30	degree
35					Design cohesion of retained mat'l (C ) =	0	kN/m²	(Only granular backfil considered, "C" = zero)
36					Density of retained mat'l (q ) =	20	kN/m³
37					Submerged Density of retained mat'l (qs ) =	5,00	kN/m³	[default=2/3*q (only apply when Hw >0) ] =			13,33
38					Design angle of int'l friction of base mat'l (Øb) =	20	degree	ASSUMPTIONS
39					Design cohesion of base material (Cb ) =	10	kN/m²	a) Wall friction is zero
40					Density of base material (qb ) =	10	kN/m³	b) Minimum active earth pressure = 0.25qH
41					Allowable gross ground bearing pressure (GBP) =	200	kN/m²	c) Granular backfill
42								d)Does not include check of rotational slide/slope failure
43		LOADINGS			Surcharge load -- live (SQK) =	10	kN/m²	e)Does not include effect of seepage of ground
44					Surcharge load -- dead (SGK) =	10		water beneath the wall.
45					Line load -- live (LQK) =	10,3	kN/m	f)Does not include deflection check of wall due to					300	= Hp
46					Line load -- dead (LGK) =	43	kN/m	lateral earth pressures
47					Distance of line load from wall (X) =	0	mm	h) Design not intended for walls over 3.0 m high
48								i) Does not include check for temp. or shrinkage effects					29,58	1,19
49		LATERAL FORCES (unfactored)			Ka =	0,33	[ default ka = (1-SIN Ø)/(1+SIN Ø) ] =			0,33
50					Kp =	2,04	[ default kp = (1+SIN Øb)/(1-SIN Øb) ] =			2,04
51					Kpc =	2,86	[ default kpc = 2kp0.5 ] =			2,86
52					Kac =	1,15	[ 2ka0.5 ]
53
54			Force	Lever arm		Moment about TOE		gf	Fult	Mult
55			(kN)	(m)		(kNm)			(kN)	(kNm)
56		PE =	29,58	LE =	1,194	35,33		1,40	41,42	49,46
57		PS(GK) =	10,83	LS =	1,63	17,60		1,40	15,17	24,65
58		PS(QK) =	10,83	LS =	1,63	17,60		1,60	17,33	28,17
59		PL(GK) =	0,00	LL =	3,25	0,00		1,40	0,00	0,00
60		PL(QK) =	0,00	LL =	3,25	0,00		1,60	0,00	0,00
61		PW =	11,25	LW =	0,50	5,63		1,40	15,75	7,88		REINFORCEMENT DENSITY
62		Total	62,50			76,16			89,67	110,15		274,4 kg/m
63		PP =	-9,49	(LP-HN) =	0,15	-1,38		1,00	-9,49	-1,38
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