Spreadsheets To BS 8110 Etc: The Concrete Centre
Spreadsheets To BS 8110 Etc: The Concrete Centre
Spreadsheets To BS 8110 Etc: The Concrete Centre
Client
Advisory Group
Location
Grid line 2
Date
rc
31-Jan-2017
Checked
Revision
chg
2006 TCC
B=
BI =
DESIGN STATUS :
2000
0
Tw =
Tb =
MATERIAL PROPERTIES
steel class
m =
fcu =
25
N/mm2
m =
fy =
416
N/mm2
Cover to tension reinforcement (co) =
Max. allowable design surface crack width (W) =
Concrete density =
SOIL PROPERTIES
Design angle of int'l friction of retained mat'l () =
Design cohesion of retained mat'l (C ) =
Density of retained mat'l (q ) =
Submerged Density of retained mat'l (qs ) =
Design angle of int'l friction of base mat'l (b) =
Design cohesion of base mat'l (Cb ) =
Density of base mat'l (qb ) =
Allowable gross ground bearing pressure (GBP) =
LOADINGS (unfactored)
Surcharge load -- live (SQK) =
Surcharge load -- dead (SGK) =
Line load -- live (LQK) =
Line load -- dead (LGK) =
Distance of line load from wall (X) =
Wall load -- live (WQK) =
Wall load -- Dead (WGK) =
LATERAL FORCES
Ko
Kac
Force (kN)
PE
PS(GK)
PS(QK)
PL(GK)
PL(QK)
PW
Total
=
=
=
=
=
=
36.55
0.00
7.12
0.00
0.00
0.00
43.68
=
=
A
1.50
1.15
40
0.2
24.0
LE
LS
LS
LL
LL
LW
=
=
=
=
=
=
concrete
steel
mm
mm
kN/m3
degree
kN/m2
kN/m3
kN/m3
degree
kN/m2
kN/m3
kN/m2
5
0
0
0
0
0
13.68
kN/m2
kN/m2
kN/m
kN/m
mm
kN/m
kN/m
0.950
1.43
1.43
2.85
2.85
0.00
R68
VALID
200
400
30
0
18
18.00
30
5
18
150
0.50
1.41
127
Job No
DIMENSIONS(mm)
H=
2850
Hw =
0
He =
2850
Page
(0.2 or 0.3
mm only)
default Ko = (1-SIN )
= 2Ko0.5
1.40
1.40
1.60
1.40
1.60
1.40
Wall Geometry
0.50
51.17
0.00
11.40
0.00
0.00
0.00
62.57
Project
Client
Advisory Group
Location
Grid line 2
Date
rc
Page
31-Jan-2017
Checked
Revision
chg
2006 TCC
EXTERNAL STABILITY
128
Job No
R68
STABILITY CHECK :
OK
Wall idealised as a propped cantilever ( i.e. pinned at top and fixed at base )
Wall is braced.
Maximum slenderness of wall is limited to 15, i.e [ 0.9*(He-Tb/2)/Tw < 15 ]
Maximum Ultimate axial load on wall is limited to 0.1fcu times the wall cross-sectional area
Design Span (Effective wall height) = He - (Tb/2)
-ve moment is hogging ( i.e. tension at external face of wall )
+ve moment is sagging ( i.e. tension at internal face of wall )
7) " Wall MT. " is maximum +ve moment on the wall.
8) Estimated lateral deflections are used for checking the P effect .
UNFACTORED LOADS AND FORCES
Force
Lever arm
(kN)
to base (m)
Base MT.
(kNm)
Wall MT.
(kNm)
=
=
=
=
=
=
31.60
0.00
6.62
0.00
0.00
0.00
0.88
1.33
1.33
2.65
2.65
0.00
-11.17
0.00
-2.19
0.00
0.00
0.00
4.99
#DIV/0!
1.23
0.00
0.00
0.00
25.28
0.00
4.14
0.00
0.00
0.00
6.32
0.00
2.48
0.00
0.00
0.00
0.4
0.0
0.1
0.0
0.0
0.0
Total
38.23
-13.36
#DIV/0!
29.42
8.80
0.5
Lateral Force
PE
PS(GK)
PS(QK)
PL(GK)
PL(QK)
PW
Reaction at Reaction at
Base (kN)
Top (kN)
Estimated Elastic
Deflection (mm)
Wall load
Wall (sw)
Base
Earth
Water
Surcharge
Line load
V
=
=
=
=
=
=
=
=
13.68
11.76
19.20
0.00
0.00
0.00
0.00
44.64
0.90
0.90
0.00
1.00
1.00
1.00
1.00
Moment (kNm)
0.000
-11.17
kNm
RESULTANT MOMENT, M = Mv + Mo =
11.73
kNm
39.92
SLIDING AT BASE
50.000
m
kN/m2
29.42
-35.77
1
0
12.3119998632
10.58
0.00
0.00
0.00
0.00
0.00
Mv =
22.90
0.26
MAX
MIN
< 150
F.O.S =
OK
1.50
kN
kN
Factor of Safety, Fb / P =
1.22
< 1.50
FAIL .. but
Project
Client
Advisory Group
Location
Grid line 2
rc
Checked
SHEAR RESISTANCE:
Min. As
centres
As
=
=
=
=
960
16
150
1340
mm2
mm
mm
mm2
d
Z
As'
Mres
=
=
=
=
352
330
0
160.15
mm
mm
mm2
kNm
100As/bd =
vc =
Vres =
0.88%
0.47
166.48
m = -0.00043
mm
mm
W=
kN
kNm
BOTTOM REINFORCEMENT :
MOMENT of RESISTANCE :
SHEAR RESISTANCE:
107.96
81.04
TOP
BOTTOM
TRANSVERSE
R68
reference
Table 3.25
< 766
> 960
OK
OK
3.4.4.4
> 0.00
OK
> 23.28
OK
Table 3.8
3.5.5.2
< 0.20
OK
App. B.2
centres
As
=
=
=
=
960
16
150
1340
mm2
mm
mm
mm2
< 766
> 960
OK
d
Z
As'
Mres
=
=
=
=
352
330
0
160.15
mm
mm
mm2
kNm
> 20.04
OK
100As/bd =
vc =
Vres =
0.38%
0.47
N/mm2
kN
> 13.20
OK
166.48
m = -0.00025
mm
mm
N/mm2
kN
-0.08
mm
NO CRACKING
X=
Acr =
130
Job No
BS8110
MOMENT of RESISTANCE :
107.96
81.04
31-Jan-2017
Revision
chg
2006 TCC
Page
(ASSUMED)
kN
(AT d from FACE of WALL)
kNm
TENSION - TOP FACE
BOTTOM REINFORCEMENT :
X=
Acr =
Date
W=
centres
As
R
R
R
mm
16
16
16
mm
150
150
150
mm
1340
1340
1340
OK
Table 3.8
3.5.5.2
BS8007
< 0.20
OK
Min. As
2
3.4.4.4
-0.05
mm
NO CRACKING
Type
Table 3.25
mm2
960
960
960
OK
OK
OK
App. B.2
Project
Client
Advisory Group
Location
Grid line 2
rc
Checked
Date
Page
31-Jan-2017
Revision
chg
2006 TCC
Job No
R68
Type
Dia
Length
Unit Wt
Weight
7
7
34
R
R
R
16
16
12
2578
2578
1000
1.578
1.578
0.888
28.48
28.48
30.19
7
7
28
7
7
R
R
R
R
R
16
2128
1.578
16
2128
1.578
16
1000
1.578
16(30+8)*G17+75+TB
1.578
16(30+8)*G17+75+TB
1.578
SUMMARY
131
23.51
23.51
44.19
#VALUE!
#VALUE!
Project
Location
Job No R68
Date
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/1000)*(1-(6*ECCY)/(B/1000)))))
IF(ABS(ECCY)>(B/1000)/6,IF((B-XX)>(B/1000/2-ABS(ECCY))*3,0,(((B/1000/2-ABS(ECCY))*3-(B-XX))/((B/1000/2-ABS(ECCY))*3))*BP),((VL/(B/1000)*(1(6*ABS(ECCY))/(B/1000)))) +(B/1000-(B-XX))/(B/1000)*(BP-(VL/(B/1000)*(1-(6*ABS(ECCY))/(B/1000)))))
0
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
0.00
0.04
0.08
0.12
0.16
0.20
0.24
0.28
0.32
0.36
0.40
0.44
0.48
0.52
0.56
0.60
0.64
0.68
0.72
0.76
0.80
0.84
0.88
0.92
0.96
1.00
1.04
1.08
1.12
1.16
1.20
1.24
1.28
1.32
1.36
1.40
1.44
1.48
1.52
1.56
1.60
1.64
1.68
1.72
1.76
1.80
1.84
1.88
1.92
1.96
2.00
39.91537
39.91537
39.915
39.212
38.508
37.804
37.100
36.396
35.692
34.989
34.285
33.581
32.877
32.173
31.470
30.766
30.062
29.358
28.654
27.951
27.247
26.543
25.839
25.135
24.431
23.728
23.024
22.320
21.616
20.912
20.209
19.505
18.801
18.097
17.393
16.689
15.986
15.282
14.578
13.874
13.170
12.467
11.763
11.059
10.355
9.651
8.948
8.244
7.540
6.836
6.132
5.428
4.724627
0.000
KN/M^2
XX=
Made by rc
2006 TCC
50.000
BPO
BPE
BPI
BPZ
0
1E-008
0.2
2
39.915
39.915
39.915
36.396
4.7246
0
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
39.92
39.21
38.51
37.80
37.10
36.40
35.69
34.99
34.28
33.58
32.88
32.17
31.47
30.77
30.06
29.36
28.65
27.95
27.25
26.54
25.84
25.14
24.43
23.73
23.02
22.32
21.62
20.91
20.21
19.50
18.80
18.10
17.39
16.69
15.99
15.28
14.58
13.87
13.17
12.47
11.76
11.06
10.36
9.65
8.95
8.24
7.54
6.84
6.13
5.43
4.72
0.0000
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.04
0.04
0.04
0.04
0.04
0.04
0.04
0.04
0.04
0.04
0.04
0.04
0.04
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
1.60
1.57
1.54
1.51
1.48
1.46
1.43
1.40
1.37
1.34
1.32
1.29
1.26
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
18.56
YY= 3.875
0
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
MOMENTS
MTE2= 0.00
MTE1= -62.79
MTLG= 0.00
MTLQ= 0.00
MTSG= 0.00
MTSQ= -9.14
MTW= -3.06
UTM= -106.82
-106.82
0
0.6737
1.3343
1.9799
2.6086
3.2187
3.808
4.3749
4.9175
5.4338
5.9219
6.3801
6.8064
7.199
7.5559
7.8753
8.1554
8.3942
8.5899
8.7406
8.8444
8.8995
8.9039
8.8558
8.7534
8.5946
8.3778
8.1009
7.7622
7.3597
6.8916
6.3559
5.7509
5.0746
4.3252
3.5007
2.5994
1.6193
0.5586
-0.5847
-1.8124
-3.1263
-4.5284
-6.0205
-7.6045
-9.2822
-11.056
-12.927
-14.897
-16.969
-19.143
0.00
0.05
0.11
0.16
0.21
0.27
0.32
0.37
0.42
0.48
0.53
0.58
0.64
0.69
0.74
0.80
0.85
0.90
0.95
1.01
1.06
1.11
1.17
1.22
1.27
1.33
1.38
1.43
1.48
1.54
1.59
1.64
1.70
1.75
1.80
1.86
1.91
1.96
2.01
2.07
2.12
2.17
2.23
2.28
2.33
2.39
2.44
2.49
2.54
2.60
2.65
0
400
400
3000
3000
2700
2700
3000
400
400
0
0
3000
sheet 2 of 2
Made by rc
2006 TCC
SHEARS
SE2=IF(YY>=(L-'ANALYSIS & STABILITY'!M28),Ka*(q-QS)*(YY-(L-'ANALYSIS & STABILITY'!M28))^(2)/2
-10.84
0.00
0.05
0.11
0.16
0.21
0.27
0.32
0.37
0.42
0.48
0.53
0.58
0.64
0.69
0.74
0.80
0.85
0.90
0.95
1.01
1.06
1.11
1.17
1.22
1.27
1.33
1.38
1.43
1.48
1.54
1.59
1.64
1.70
1.75
1.80
1.86
1.91
1.96
2.01
2.07
2.12
2.17
2.23
2.28
2.33
2.39
2.44
2.49
2.54
2.60
2.65
Geometry
0
0
1E-005
1E-005
2000
2000
200
200
200
2000
2000
0
2000
87.278
0.00
0.00
0
18.77
1.79
MOMENT DIAGRAM
-25
-20
-15
-10
-5
10
15
ULT. MT (KNM)
WALL (M)
Location
MOMENT DIAGRAM
-25
-20
-15
-10
-5
ULT. MT (KNM)
WALL (M)
Project
10
15
0.000
0.674
1.334
1.980
2.609
3.219
3.808
4.375
4.917
5.434
5.922
6.380
6.806
7.199
7.556
7.875
8.155
8.394
8.590
8.741
8.844
8.899
8.904
8.856
8.753
8.595
8.378
8.101
7.762
7.360
6.892
6.356
5.751
5.075
4.325
3.501
2.599
1.619
0.559
-0.585
-1.812
-3.126
-4.528
-6.020
-7.604
-9.282
-11.056
-12.927
-14.897
-16.969
-19.143
0.674
0.661
0.646
0.629
0.610
0.589
0.567
0.543
0.516
0.488
0.458
0.426
0.393
0.357
0.319
0.280
0.239
0.196
0.151
0.104
0.055
0.004
-0.048
-0.102
-0.159
-0.217
-0.277
-0.339
-0.402
-0.468
-0.536
-0.605
-0.676
-0.749
-0.824
-0.901
-0.980
-1.061
-1.143
-1.228
-1.314
-1.402
-1.492
-1.584
-1.678
-1.773
-1.871
-1.970
-2.072
-2.175
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
8.90
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
1.17
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
8.90
1.17
Job No R68
Date
Made by rc
Job No R68
31-Jan-17
000))))+(B/1000-XX)/(B/1000)*(BP-(VL/
*3))*BP),((VL/(B/1000)*(1-
), ((VL/(B/1000)* (1-6*ABS(ECCY))/
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
Made by rc
Job No R68
31-Jan-17
Project
Location
WALL
MR=
As/bd=
X=
Ic=
STS=
ST1=
ST2=
Acr=
W=
m=
MR=
AsBB/bd=
X=
Ic=
STS=
ST1=
ST2=
Acr=
W=
17.81
0.009
64.60
272266479
0.000382
0.000592
0.00026081
81.0449325
0.05
0.0003
17.81
0.0038
107.96
1841552107
0.0000
0.0000
0.00043455
81.0449325
-0.08
m= -0.0004
MS=
MSS=
MSBB=
MSBT=
MR=
AsBT/bd=
X=
Ic=
STS=
ST1=
ST2=
Acr=
W=
2006 TCC
356
356
766
766
17.81
0.0038
107.96
1841552107
0.0002
0.0002
0.00043455
81.0449325
-0.05
m= -0.0002
Asreq =
Assreq =
ASBBreq=
ASBTreq=
432
215
0
168
fs
fs
fs
fs
=
=
=
=
89.2929Asprov%=
44.3819Asprov%=
4E-015 Asprov%=
34.704 Asprov%=
0.8819
0.8819
0.3808
0.3808
Disclaimer
All advice or information from MPA-The Concrete Centre 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 MPA-The Concrete Centre or its subcontractors, suppliers or
advisors. Users should note that all MPA-The Concrete Centre software and publications are subject to revision from time to
time and they should therefore ensure that they are in possession of the latest version.
This spreadsheet should be used in compliance with the accompanying publication 'User Guide RC Spreadsheets: v4'
available from The Concrete Centre www.concretecentre.com/rcdesign Tel +44 (0)1276 606800
Status of spreadsheet
Public release version.
This spreadsheet is shareware but may not be used for commercial purposes until the user
has registered with The Concrete Centre using the licence validation form available on The
Concrete Centre website www.concretecentre.com/rcdesign
Date
Version
Action
1-Apr-10
RCC61 v4.0
21-May-09
RCC61 v3.4
1-Oct-08
RCC61 v3.3
25-Sep-08
RCC61 v3.2
28-Jun-06
RCC61 v3.1
12-Nov-05
RCC61 v3.0
22-Jan-03
RCC61 v2.1
11-Oct-02
RCC61 v2.0
Version 2 enhancements
29-May-02
RCC61 v1.4
15-Apr-01
RCC61 v1.3
20-Jun-00
RCC61 v1.2
24-Mar-00
RCC61 v1.1
6-Aug-99
RCC61 v1.0
Size (kB)
468
462
602
565
565
586
563
591
399
399
399
398
398