Project

SMK2 REINFORCED CONCRETE COUNCIL

Client UEMC Made by Date Page
Location - NMN 07-Feb-2017 101
RETAINING WALL design to BS 8110:1997, BS 8002:1994. BS 8004:1986 etcChecked Revision Job No
Originated from 'RCC62.xls' v2.3 1999-2002 BCA for RCC - R68

IDEALISED STRUCTURE and FORCE DIAGRAMS DESIGN STATUS: NOT VALID

WARNING :
Passive pressure should
only be considered if it
can be guaranteed that
there will be no future
excavation in front of
the wall.

DIMENSIONS (mm)
H= 4000 B= 8400 Tw = 250
Hw = 3000 BI = 1200 Tb = 200
Hp = 0 BN = 0 TN = 0
Hn = 0
MATERIAL PROPERTIES
fcu = 35 N/mm m = 1.5 concrete
fy = 460 N/mm m = 1.05 steel
cover to tension steel = 50 mm
Max allowable design surface crack width (W) = 0.3 mm (0.2 or 0.3
mm only)
Concrete density = 24 kN/m
SOIL PROPERTIES Wall Geometry
Design angle of int'l friction of retained mat'l () = 25 degree
Design cohesion of retained mat'l (C ) = 0 kN/m (Only granular backfil considered, "C" = zero)
Density of retained mat'l (q ) = 0.0001 kN/m
Submerged Density of retained mat'l (qs ) = 0.00 kN/m [default=2/3*q (only apply when 0.00
Design angle of int'l friction of base mat'l (b) = 25 degree ASSUMPTIONS
Design cohesion of base material (Cb ) = 0 kN/m a) Wall friction is zero
Density of base material (qb ) = 18 kN/m b) Minimum active earth pressure = 0.25qH
Allowable gross ground bearing pressure (GBP) = 300 kN/m c) Granular backfill
d)Does not include check of rotational slide/slope failure
LOADINGS Surcharge load -- live (SQK) = 0.0001 kN/m e)Does not include effect of seepage of ground
Surcharge load -- dead (SGK) = 0.001 water beneath the wall.
Line load -- live (LQK) = 0.001 kN/m f)Does not include deflection check of wall due to
Line load -- dead (LGK) = 0 kN/m lateral earth pressures
Distance of line load from wall (X) = 0 mm h) Design not intended for walls over 3.0 m high
i) Does not include check for temp. or shrinkage effects
LATERAL FORCES (unfactored) Ka = 0.41 [ default ka = (1-SIN )/(1+SIN )0.41
Kp = 2.46 [ default kp = (1+SIN b)/(1-SIN 2.46
Kpc = 3.14 [ default kpc = 2kp0.5 ] = 3.14
Kac = 1.27 [ 2ka0.5 ]

Force Lever arm Moment about TOE f Fult Mult

(kN) (m) (kNm) (kN) (kNm)
PE = 0.00 LE = 1.410 0.00 1.40 0.00 0.00
PS(GK) = 0.00 LS = 2.00 0.00 1.40 0.00 0.00
PS(QK) = 0.00 LS = 2.00 0.00 1.60 0.00 0.00
PL(GK) = 0.00 LL = 4.00 0.00 1.40 0.00 0.00
PL(QK) = 0.00 LL = 4.00 0.00 1.60 0.00 0.00
PW = 45.00 LW = 1.00 45.00 1.40 63.00 63.00
Total 45.00 45.00 63.00 63.01
PP = 0.00 (LP-HN) = 0.00 0.00 1.00 0.00 0.00
Project SMK2 REINFORCED CONCRETE COUNCIL
Client UEMC Made by Date Page

Location - NMN 07-Feb-2017 102

RETAINING WALL design to BS 8110:1997, BS 8002:1994. BS 8004: Checked Revision Job No

Originated from 'RCC62.xls' v2.3 1999-2002 BCA for RCC 0 - R68

EXTERNAL STABILITY STABILITY CHECKS : OK

OVERTURNING about TOE F.O.S = 1.50

(using overall factor of safety instead of partial safety factor) LOADING OPTION
Overturning Lateral FORCE (kN) Lever arm (m) Moment (kNm) (select critical load combination)
Moments PE = 0.00 LE = 1.33 0.00 EARTH
PS(GK) = 0.00 LS = 2.00 0.00 PS(GK) Warning:
PS(QK) = 0.00 LS = 2.00 0.00 PS(QK)
PL(GK) = 0.00 LL = 4.00 0.00 PL(GK)
PL(QK) = 0.00 LL = 4.00 0.00 PL(QK)
PW = 45.00 LW = 1.00 45.00 PW
P = 45.00
Pp = 0.00 (LP-HN) = 0.00 0.00
Mo = 45.00

Restoring Vertical FORCE (kN) Lever arm (m) Moment (kNm)

Moments Wall = 15.80 1.33 20.94
Base = 23.52 4.20 98.78 Warning:
Nib = 0.00 0.00 0.00
Earth = 0.00 4.93 0.01 ALLOW BUOYANCY OF BASE
Water = 194.60 4.93 958.41
Surcharge = 0.01 4.93 0.04
Line load = 0.00 1.45 0.00
V = 233.93 Mr = 1078.17

Factor of Safety, Mr / Mo = 23.96 > 1.50 OK

SLIDING (using overall factor of safety instead of partial safety factor) F.O.S = 1.50

Sum of LATERAL FORCES, P = 45.00 kN

PASSIVE FORCE, Pp x Reduction factor (1) = 0.00 kN Red'n factor for passive force = 1.00
BASE FRICTION ( V TANb + B Cb ) = -109.08 kN
Sum of FORCES RESISTING SLIDING, Pr = -109.08 kN

Factor of Safety, Pr / P = 2.42 > 1.50 OK

GROUND BEARING FAI Taking moments about centre of base (anticlockwise "+") :

Vertical FORCES (kN) Lever arm (m) Moment (kNm) BEARING PRESSURE (KN/m)
Wall = 22.80 2.88 65.55
Base = 40.32 0.00 0.00 0.000

Nib = 0.00 4.20 0.00

Earth = 0.00 -0.73 0.00
Water = 194.60 -0.73 -141.09
Surcharge= 0.01 -0.73 -0.01
Line load = 0.00 2.75 0.00
V = 257.73 Mv = -75.54

Moment due to LATERAL FORCES, Mo = 45.00 kNm

50.000

Resultant Moment, M = Mv + Mo = -30.54 kNm

Eccentricity from base centre, M / V = -0.13 m

Therefore, MAXIMUM Gross Bearing Pressure (GRP) = 30 kN/m < 300 OK
Project SMK2 REINFORCED CONCRETE COUNCIL
Client UEMC Made by Date Page

Location - NMN 07-Feb-2017 104

RETAINING WALL design to BS 8110:1997, BS 8002:1994. BS 8004:Checked Revision Job No

Originated from 'RCC62.xls' v2.3 1999-2002 BCA for RCC 0 - R68

BASE - unloaded side ( per metre length ) BS8110

f = 1.40 (default = ult mt / non-factored m1.40 reference
V ult = 34.02 kN
M ult = 25.01 kNm ( '+' TENSION AT BOTTOM FACE)

BOTTOM REINFORCEMENT : Min. As = 260 mm2 Table 3.25

= 12 mm
centres = 250 mm < 444 OK 3.12.11.2.7(b)
Asprov = 452 mm2 > 260 OK

MOMENT of RESISTANCE : d= 144 mm

z= 136.80 mm 3.4.4.4
As' = 0 mm2
Mres = 27.11 kNm > 25.01 OK

SHEAR RESISTANCE: 100 As/bd = 0.31%

vc = 0.62 N/mm2 Table 3.8
Vres = 89.35 kN > 34.02 OK 3.5.5.2

CHECK CRACK WIDTH TO BS8110/BS8007 (:Temperature and shrinkage effects not included)
X= 38.00 mm m = 0.000929 BS8007
Acr = 130.97 mm W= 0.18 mm < 0.30 OK App. B.2

BASE - loaded side ( per metre length )

V ult = 6.53 kN
M ult = 26.22 kNm (TENSION - TOP FACE)

TOP REINFORCEMENT : Min. As = 260 mm2 Table 3.25

= 12 mm
centres = 200 mm < 444 OK 3.12.11.2.7(b)
Asprov = 565 mm2 > 260 OK

MOMENT RESISTANCE : d= 144 mm

z= 136.08 mm 3.4.4.4
As' = 0 mm2
Mres = 33.71 kNm > 26.22 OK

SHEAR RESISTANCE: 100 As/bd = 0.39%

vc = 0.67 N/mm2 Table 3.8
Vres = 96.25 kN > 6.53 OK 3.5.5.2

CHECK CRACK WIDTH to BS8100/ BS8007 (: Temperature and shrinkage effects not included)
X= 41.73 mm m = 0.000887 BS8007
Acr = 108.61 mm W= 0.17 mm < 0.30 OK App. B.2

REINFORCEMENT SUMMARY for BASE

Type Centers As Min. As

mm mm mm2 mm2
TOP (DESIGN) T 12 200 565 260 OK
BOTTOM (DESIGN) T 12 250 452 260 OK
TRANSVERSE T 10 200 393 260 OK
 SMK2 REINFORCED CONCRETE COUNCIL
Project
Client UEMC Made by Date Page

Location - NMN 07-Feb-2017 105

RETAINING WALL design to BS 8110:1997, BS 8002:1994. BS 8004: Checked Revision Job No

Originated from 'RCC62.xls' v2.3 1999-2002 BCA for RCC 0 - R68

APPROXIMATE WEIGHT OF REINFORCEMENT

No. Type Dia Length Unit Wt Weight

WALL VERTICAL - External face 7 T 10 3880 0.617 16.75

VERTICAL - Internal face 7 T 16 3928 1.578 43.40
TRANSVERSE (Ext.& Int.) 52 T 10 1000 0.617 32.06

BASE TOP (MAIN) 6 T 12 8496 0.888 45.26

BOTTOM (MAIN) 5 T 12 8496 0.888 37.71
TRANSVERSE ( T & B ) 86 T 10 1000 0.617 53.02
WALL STARTERS (Ext.) 7 T 10 925 0.617 3.99
WALL STARTERS (Int.) 7 T 16 1165 1.578 12.87

NIB (assume same reinforcement as wall)

INTERNAL FACE (MAIN) 7 T 10 80 0.617 0.35
EXTERNAL FACE (MAIN) 7 T 16 128 1.578 1.41
TRANSVERSE (EXT.+ INT.) 2 T 10 1000 0.617 1.23

SUMMARY Approx total reinforcement per metre length of wall (kg) 248.1
 Diagrams

Project SMK2
Location - DATA FOR DIAGRAMS I
RETAINING WALL design to BS 8110:1997, BS 8002:1994. BS 8004:1986 etc. sheet 1 of 2 Made by NMN Job N
Originated from 'RCC62.xls' v2.3 1999-2002 BCA for RCC

DESIGN STATUS: NOT VALID

IF(ABS(ECCY)>B/1000/2,"BEARING FAIL",IF(ABS(ECCY)>(B/1000)/6,(2*VL)/(3*((B/1000)/2-ABS(ECCY))),(VL/(B/1000)*(1+(6*ABS(ECCY))/(B/1000)))))

IF(ECCY>(B/1000)/6,IF(XX>(B/1000/2-ECCY)*3,0,(((B/1000/2-ECCY)*3-XX)/((B/1000/2-ECCY)*3))*BP),((VL/(B/1000)*(1-(6*ECCY)/(B/1000))))+(B/1000-XX)/(B/1000)*(BP-(VL/(B/10
(6*ECCY)/(B/1000)))))
8.4

1 30.45
0 30.45 3
0.84 30.45 3 BEARING PRESSURE DIAGRAM
1.68 30.45 3 M
2.52 30.45 3
3.36 30.45 3 0 1 2 3 4 5 6 7 8 9
KN/M^2

0
4.2 30.45 3
5.04 30.45 3
5.88 30.45 3
6.72 30.45 3
7.56 30.45 3 50
8.4 30.45 3
8.4 0.00 0
IF(ECCY<0,B/1000-B/1000/50*B24,B/1000/50*B24)
29.83
0 8.40 25.252 0 25.252 0.168 4.242 5.265 0.168 4.242
1 8.23 25.356 BEARING PRESSURE DIAGRAM 1 25.356 0.168 4.260 4.571 0.168 4.260
2 8.06 25.460 2 25.460 0.168 4.277 3.871 0.168 4.277
M
3 7.90 25.564 3 25.564 0.168 4.295 3.165 0.168 4.295
4 7.73 25.668 4 25.668 0.168 4.312 2.454 0.168 4.312
5 7.56 25.772 5 25.772 0.168 4.330 1.736 0.168 4.330
KN/M^2

6 7.39 25.876 0.000 6 25.876 0.168 4.347 1.013 0.168 4.347

7 7.22 25.979 7 25.979 0.000 0.000 0.000 0.000 0.000
8 7.06 26.083 8 26.083 0.000 0.000 0.000 0.000 0.000
9 6.89 26.187 9 26.187 0.000 0.000 0.000 0.000 0.000
10 6.72 26.291 10 26.291 0.000 0.000 0.000 0.000 0.000
11 6.55 26.395 11 26.395 0.000 0.000 0.000 0.000 0.000
12 6.38 26.499 50.000 12 26.499 0.000 0.000 0.000 0.000 0.000
13 6.22 26.603 13 26.603 0.000 0.000 0.000 0.000 0.000
14 6.05 26.706 14 26.706 0.000 0.000 0.000 0.000 0.000
15 5.88 26.810 15 26.810 0.000 0.000 0.000 0.000 0.000
16 5.71 26.914 30.45 16 26.914 0.000 0.000 0.000 0.000 0.000
17 5.54 27.018 BP 0 30.445 17 27.018 0.000 0.000 0.000 0.000 0.000
18 5.38 27.122 BPE 1.2 30.445 18 27.122 0.000 0.000 0.000 0.000 0.000
19 5.21 27.226 BPI 1.45 30.445 19 27.226 0.000 0.000 0.000 0.000 0.000
20 5.04 27.330 BPZ 8.4 30.445 20 27.330 0.000 0.000 0.000 0.000 0.000
21 4.87 27.433 21 27.433 0.000 0.000 0.000 0.000 0.000
22 4.70 27.537 22 27.537 0.000 0.000 0.000 0.000 0.000
23 4.54 27.641 23 27.641 0.000 0.000 0.000 0.000 0.000
24 4.37 27.745 24 27.745 0.000 0.000 0.000 0.000 0.000
25 4.20 27.849 25 27.849 0.000 0.000 0.000 0.000 0.000
26 4.03 27.953 26 27.953 0.000 0.000 0.000 0.000 0.000
27 3.86 28.057 27 28.057 0.000 0.000 0.000 0.000 0.000
28 3.70 28.160 28 28.160 0.000 0.000 0.000 0.000 0.000
29 3.53 28.264 29 28.264 0.000 0.000 0.000 0.000 0.000
30 3.36 28.368 30 28.368 0.000 0.000 0.000 0.000 0.000
31 3.19 28.472 31 28.472 0.000 0.000 0.000 0.000 0.000
32 3.02 28.576 32 28.576 0.000 0.000 0.000 0.000 0.000
33 2.86 28.680 33 28.680 0.000 0.000 0.000 0.000 0.000
34 2.69 28.784 34 28.784 0.000 0.000 0.000 0.000 0.000
35 2.52 28.888 35 28.888 0.000 0.000 0.000 0.000 0.000
36 2.35 28.991 36 28.991 0.000 0.000 0.000 0.000 0.000
37 2.18 29.095 37 29.095 0.000 0.000 0.000 0.000 0.000
38 2.02 29.199 38 29.199 0.000 0.000 0.000 0.000 0.000
39 1.85 29.303 39 29.303 0.000 0.000 0.000 0.000 0.000
40 1.68 29.407 40 29.407 0.000 0.000 0.000 0.000 0.000
41 1.51 29.511 41 29.511 0.000 0.000 0.000 0.000 0.000
42 1.34 29.615 42 29.615 0.000 0.000 0.000 0.000 0.000
43 1.18 29.718 43 29.718 0.000 0.000 0.000 0.000 0.000
44 1.01 29.822 44 29.822 0.000 0.000 0.000 0.000 0.000
45 0.84 29.926 45 29.926 0.000 0.000 0.000 0.000 0.000
46 0.67 30.030 46 30.030 0.000 0.000 0.000 0.000 0.000
47 0.50 30.134 47 30.134 0.000 0.000 0.000 0.000 0.000
48 0.34 30.238 48 30.238 0.000 0.000 0.000 0.000 0.000
49 0.17 30.342 49 30.342 0.000 0.000 0.000 0.000 0.000
50 0.00 30.4454 50 30.445 0.000 0.000 0.000 0.000 0.000
30.063 22.074 30.063

Page 5
 Diagrams

Project SMK2
Location - DATA FOR DIAGRAMS II
RETAINING WALL design to BS 8110:1997, BS 8002:1994. BS 8004:1986 etc. sheet 1 of 2 Made by NMN Job N
Originated from 'RCC62.xls' v2.3 1999-2002 BCA for RCC

YY= 3.8 MTE= 0.00

MTLG= 0.00
MTLQ= 0.00
MTSG= 0.0029
MTSQ= 0.00
MTW= 36.59

UTM= 51.23
51.23
0 0.00 0 0.00
1 0.08 2E-006 0.08 0 MOMENT
10 20 DIAGRAM
30 40 50 60
2 0.15 8E-006 0.15
3 0.23 2E-005 0.23
ULT. M T (KNM )
4 0.30 3E-005 0.30
5 0.38 5E-005 0.38
6 0.46 7E-005 0.46
7 0.53 9E-005 0.53
8 0.61 0.0001 0.61
9 0.68 0.0002 0.68 WALL (M)

10 0.76 0.0002 0.76

11 0.84 0.0002 0.84
12 0.91 0.0003 0.91
13 0.99 0.0003 0.99
14 1.06 0.001 1.06
15 1.14 0.0068 1.14
16 1.22 0.024 1.22
17 1.29 0.0586 1.29
18 1.37 0.1169 1.37
19 1.44 0.2049 1.44
20 1.52 0.3288 1.52
21 1.60 0.4948 1.60
22 1.67 0.709 1.67
23 1.75 0.9775 1.75
24 1.82 1.3066 1.82
25 1.90 1.7022 1.90
26 1.98 2.1706 1.98
27 2.05 2.718 2.05
28 2.13 3.3504 2.13
29 2.20 4.0741 2.20
30 2.28 4.8951 2.28
31 2.36 5.8196 2.36
32 2.43 6.8538 2.43
33 2.51 8.0038 2.51
34 2.58 9.2757 2.58
35 2.66 10.676 2.66
36 2.74 12.21 2.74
37 2.81 13.885 2.81
38 2.89 15.706 2.89
39 2.96 17.68 2.96
40 3.04 19.812 3.04
41 3.12 22.11 3.12
42 3.19 24.579 3.19
43 3.27 27.225 3.27
44 3.34 30.054 3.34
45 3.42 33.073 3.42
46 3.50 36.288 3.50
47 3.57 39.704 3.57
48 3.65 43.329 3.65
49 3.72 47.167 3.72
50 3.80 51.226 3.80

0 0
0 200 WALL GEOMETRY
1200 200
WALL (m m )

4000
1200 4000
3500
1450 4000
3000
1450 200
8400 200 2500

8400 0 2000
0 0 1500
0 0
1000
0 0
500
0 0
0 0 0
0

1000

2000

3000

4000

4000 8400 BASE ( m m )

Page 6
 Diagrams

e by NMN Job No R68

Date 7-Feb-17

000)*(BP-(VL/(B/1000)*(1-

0.168 4.242
0.168 4.260
0.168 4.277
0.168 4.295
0.168 4.312
0.168 4.330
0.168 4.347
0.168 4.365
0 0.000
0 0.000
0 0.000
0 0.000
0 0.000
0 0.000
0 0.000
0 0.000
0 0.000
0 0.000
0 0.000
0 0.000
0 0.000
0 0.000
0 0.000
0 0.000
0 0.000
0 0.000
0 0.000
0 0.000
0 0.000
0 0.000
0 0.000
0 0.000
0 0.000
0 0.000
0 0.000
0 0.000
0 0.000
0 0.000
0 0.000
0 0.000
0 0.000
0 0.000
0 0.000
0 0.000
0 0.000
0 0.000
0 0.000
0 0.000
0 0.000
0 0.000
0 0.000
34.428

Page 7
 Diagrams

e by NMN Job No R68

Date 7-Feb-17

Page 8
 Project SMK2
Location - CRACK WIDTH CALCULATIONS
Made
RETAINING WALL design to BS 8110:1997, BS 8002:1994. BS 8004:1986 etc. by NMN Job No R68
Originated from 'RCC62.xls' v2.3 1999-2002 BCA for RCC Date 7-Feb-17

WALL
MR= 15.06 MIN SPACING= 446 ASreq = 675.04 fs = 154.44Asprov%= 0.6981
As/bd= 0.007 MSBB= 444 ASBBreq 0.01 fs = 0.0068Asprov%= 0.3142
X= 70.13 MSBT= 444 ASBTreq 439.84 fs = 238.53Asprov%= 0.3927
Ic= 414709743
STS= 0.0008
ST1= 0.0012
ST2= 0.0004951
Acr= 86.810337
W= 0.13
m= 0.0007

MR= 15.06 MR= 15.06

AsBB/bd= 0.0031 AsBB/bd= 0.0039
X= 38.00 X= 41.73
Ic= 94821073 Ic= 113271728
STS= 0.0015 STS= 0.0013
ST1= 0.0023 ST1= 0.0020
ST2= 0.0013682 ST2= 0.0010828
Acr= 130.9708 Acr= 108.61239
W= 0.18 W= 0.1661
m= 0.0009 m= 0.0009

Page 9
 Notes

Disclaimer
All advice or information from the British Cement Association and/or Reinforced Concrete
Council is intended for those who will evaluate the significance and limitations of its contents
and take responsibility for its use and application. No liability (including that for negligence)
for any loss resulting from such advice or information is accepted by the BCA, RCC or their
subcontractors, suppliers or advisors. Users should note that all BCA software and
publications are subject to revision from time to time and should therefore ensure that they
are in possession of the latest version.

This spreadsheet should be used in compliance with the accompanying publication

Status of spreadsh This spreadsheet is shareware. It may be distributed freely, but may not
Public release version be used for commercial purposes until the user has registered with the
RCC.
Revision history RCC62 Retaining Wall.xls

Date Version Action

Names of sides of base on DESIGN sheet changed from
21-Oct-04RCC62 v2.3
"outside" and " inside" to "unloaded" and "loaded".
### RCC62 v2.2 Correction when distance X to line load 0.
22-Jan-03 RCC62 v2.1 DETR logo replaced by DTI.
11-Oct-02RCC62 v2.0 Version 2 enhancements
### RCC62 v1.4 Data! Main graphic changed to jpeg
16-Jun-01 RCC62 v1.3 Crack width calculation to outer base amended
Buoyance option + notes added. Passive pressure reduction
15-Apr-01 RCC62 v1.2
factor rectified
Crack width w for top of inner base amended. Notes re crack
24-Mar-00RCC62 v1.1
widths and cracking added in DATA!
First public release.
6-Aug-99 RCC62 v1.0
Includes version comments

Page 10
Notes

Page 11
 Notes

einforced Concrete
tions of its contents
hat for negligence)
e BCA, RCC or their
BCA software and
re ensure that they

anying publication

freely, but may not

registered with the

Size (kB)
580

565
563
583
365
365
398

398

398

Page 12
Notes

Page 13
Notes

Page 14
Notes

Page 15