D&D Main Beam Grids C To H
D&D Main Beam Grids C To H
D&D Main Beam Grids C To H
Spreadsheets to BS 8110
Client
Location
Advisory Group
D&D: Main beam Grids C to H
REINFORCED CONCRETE
COUNCIL
Made by
from grid 1 to 3
LOCATION
to grid
SPANS
SPAN 1
SPAN 2
SPAN 3
40 N/mm
460 N/mm
250 N/mm
h agg
gs
gc
R68
20 mm
1.05
1.50
L (m)
H (mm)
bw (mm)
hf (mm)
Type
bf (mm)
8.00
6.00
500
500
300
300
175
175
R
R
300
300
LOADING PATTERN
DEAD
IMPOSED
min
max
1
0
1.4
1.6
REBAR LAYERING
Support steel
in alt layer ? Y
Span 1
UDL
PL 1
PL 2
Part UDL
Span 2
UDL
PL 1
PL 2
Part UDL
Span 3
UDL
PL 1
PL 2
Part UDL
55
Job No
SPAN 4
SPAN 5
SPAN 6
LOADING
Revision
chg
MATERIALS
fcu
fyl
fyv
Sheet No
4-Jun-13
Checked
Date
rmw
UDLs (kN/m)
H (mm)
B (mm)
300
300
300
300
300
300
PLs (kN)
F
F
F
4.00
5.00
4.00
H (mm)
B (mm)
End Cond
300
300
300
300
300
300
P
P
P
Dead
Load
Imposed
Load
Position
from left
Loaded
Length
~~~~~
~~~~~
~~~~~
~~~~~
~~~~~
~~~~~
~~~~~
~~~~~
~~~~~
~~~~~
~~~~~
~~~~~
Position (m)
Dead
Load
Imposed
Load
Position
from left
Loaded
Length
25.8
20.0
~~~~~
~~~~~
~~~~~
~~~~~
25.8
20.0
~~~~~
~~~~~
~~~~~
~~~~~
~~~~~
~~~~~
~~~~~
~~~~~
Span 4
UDL
PL 1
PL 2
Part UDL
Span 5
UDL
PL 1
PL 2
Part UDL
Span 6
UDL
PL 1
PL 2
Part UDL
LOADING DIAGRAM
REACTIONS (kN)
SUPPORT
256.6
256.6
78.1
92.7
79.3
529.6
413.3
365.1
209.3
147.8
167.4
29.9
171.9
59.2
55.6
Project
Spreadsheets to BS 8110
Client
Location
Advisory Group
D&D: Main beam Grids C to H, from grid 1 to 3
Made by
Checked
rmw
Revision
chg
Page
4-Jun-13
56
Job No
R68
400
400
300
300
200
200
100
100
0
-100
-100
-200
-200
-300
-300
-400
-400
0
10
Elastic Moments
SUPPORT No
Elastic M
Redistributed M
b
Redistribution
SPAN No
Elastic M
Redistributed M
b
SHEARS (kN)
15
401.7
281.2
0.700
30.0%
86.2
86.2
1.000
0.0%
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
152.75
146.12
0.957
300
300
200
200
100
100
-100
-100
-200
-200
-300
-300
-400
12
Redistributed Envelope
193.1
154.5
0.800
20.0%
276.52
328.97
1.190
10
14
16
kNm/m
kNm/m
~
-400
0
10
15
Elastic Shears
1
SPAN No
Elastic V
Redistributed V
Redistributed Shears
10
252.9
256.6
300.3
288.3
252.4
241.3
180.4
171.9
~
~
~
~
Elastic V
Redistributed V
COLUMN MOMENTS
(kNm)
ALL SPANS Above
LOADED Below
ODD SPANS Above
LOADED Below
EVEN SPANS Above
LOADED Below
108.3
71.1
116.6
76.5
32.8
21.5
-35.2
-18.5
-65.1
-34.2
16.6
8.7
-36.0
-23.6
2.4
1.6
-52.0
-34.2
15
Project
Spreadsheets to BS 8110
Client
Advisory Group
Location
rmw
M
b
DESIGN
d
As
As'
TOP STEEL Layer 1
Layer 2
As prov
BTM STEEL Layer 1
Layer 2
As' prov
ACTIONS
mm
mm
20
942
T
20
mm
mm
kN
N/mm
N/mm
LINKS
legs
942
18.519
216.9
1.670
0.527
R12 @ 150 for 1950
2
No
% As
Cover
min S
max S
Links
Main bars
max V
Deflection
M
b
DESIGN
d
As
As'
TOP STEEL Layer 1
Layer 2
As prov
BTM STEEL Layer 1
Layer 2
As' prov
mm
mm
% As
Cover
min S
max S
Links
Main bars
max V
Deflection
As' prov
3
402
T
32
As prov
2
2413
T
As prov
Allowed
2413
24.149
As' prov
982
249.8
2.007
0.731
R12 @ 125 for 2125
2
Link
12
Nominal
R12 @ 300
2
ok
ok
ok
ok
ok
ok
ok
ok
ok
ok
ok
ok
ok
CENTRE
146.1
0.96
435.5
830
32
2413
T
25
mm
mm
kN
N/mm
N/mm
LINKS
CHECKS
25
RIGHT
61.2
1.00
439.0
335
mm
982
13.777
202.8
1.629
0.731
R12 @ 200 for 1400
2
L/d
legs
32
16
LEFT
262.8
0.81
415.0
1742
kNm
DEFLECTION
V
v
vc
R68
ok
SPAN 2
ACTIONS
57
Job No
RIGHT
250.2
0.70
415.0
1617
800
T
ok
ok
ok
ok
ok
ok
ok
CHECKS
SHEAR
CENTRE
329.0
1.19
432.0
2188
L/d
V
v
vc
mm
DEFLECTION
SHEAR
Revision
chg
LEFT
116.7
0.80
433.0
656
kNm
Page
4-Jun-13
Checked
SPAN 1
Date
No
ok
ok
ok
ok
ok
ok
ok
25
As' prov
2
982
T
25
As prov
Allowed
982
32.608
Link
12
Nominal
R12 @ 325
2
ok
ok
ok
ok
ok
ok
ok
16
As prov
2
402
T
16
As' prov
402
131.7
1.000
0.395
R12 @ 275 for 1100
2
ok
ok
ok
ok
ok
ok
ok
Project
Spreadsheets to BS 8110
Client
Location
Advisory Group
D&D: Main beam Grids C to H, from grid 1 to 3
Made by
Checked
rmw
Date
Page
4-Jun-13
Revision
58
Job No
chg
R68
Length
Unit wt
Weight
Location
No
Type
Dia
Support 1
3
T
0
0
2
T
0
0
3
T
0
0
2
T
0
0
2
T
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
3
T
0
0
3
T
0
0
2
T
0
0
2
T
0
0
2
T
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
43
R
0
0
22
R
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
spacers not included
20
0
16
0
32
0
25
0
16
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
20
0
32
0
25
0
25
0
16
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
12
0
12
0
0
0
0
0
0
0
0
0
Span 1
Support 2
Span 2
Support 3
0
0
0
0
0
0
0
0
BOTTOM STEEL
Support 1
Span 1
Support 2
Span 2
Support 3
0
0
0
0
0
0
0
0
LINKS
Span 1
Span 2
0
0
0
0
SUMMARY
2950
2.466
0
0.000
4775
1.578
0
0.000
4200
6.313
0
0.000
5650
3.853
0
0.000
2225
1.578
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
1100
2.466
0
0.000
7650
6.313
0
0.000
2800
3.853
0
0.000
5650
3.853
0
0.000
1525
1.578
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
1400
0.888
0
0.000
1400
0.888
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
Total reinforcement in bay (kg)
21.8
0.0
15.1
0.0
79.5
0.0
43.5
0.0
7.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
8.1
0.0
144.9
0.0
21.6
0.0
43.5
0.0
4.8
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
53.4
0.0
27.3
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
471
215.0
Project
Location
Spreadsheets to BS 8110
D&D: Main beam Grids C to H, from grid 1 to 3
ANALYSIS I
ANALYSIS
1.0
0.4
Min load
Live load
x dead load
x dead load +
1.6
x imposed load
(Table 2.1)
Distribution Factors
SUPT 1
Up col
SUPT 2
R
Lo col
Up col
SUPT 3
R
Lo col
Up col
Lo col
Aw
150000
150000
150000
150000
Af
250
3125000000
390625000
710044642.9
250
3125000000
390625000
1.E+09
675000000
192857142.9
675000000
101250000
250
3125000000
520833333.3
250
3125000000
520833333.3
8.E+08
675000000
192857142.9
#DIV/0!
#DIV/0!
0
0.3240
0.1600
0.0840
0.6199
0.2295
X bar
I
Stiffness
Sum
Factor
675000000
192857142.9
675000000
126562500
0.2716
0.1782
0.5501
SUPT 4
L
Aw
Up col
SUPT 5
Lo col
Af
0.4320
Up col
675000000
126562500
0.1506
0.0000
SUPT 6
R
Lo col
Up col
Lo col
X bar
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
Stiffness
Sum
0.E+00
Factor
1.0000
0.0000
0.0000
0.0000
1.0000
0.0000
0.0000
0.0000
1.0000
0.E+00
#DIV/0!
0.0000
0.0000
0.0000
0.E+00
SUPT 7
L
Up col
Aw
Af
X bar
#DIV/0!
#DIV/0!
Stiffness
Lo col
Sum
0.E+00
Factor
0.0000
0.0000
0.0000
0
0
0
0
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
SPAN 1
R
FEM
Live load
Cant
UDL
PL 1
PL 2
part UDL
FEM
SPAN 2
R
SPAN 3
R
SPAN 4
R
SPAN 5
R
SPAN 6
R
137.60
0.00
0.00
0.00
137.60
825.60
137.60
0.00
0.00
0.00
137.60
464.40
77.40
0.00
0.00
0.00
77.40
77.40
0.00
0.00
0.00
77.40
0.00
0.00
#DIV/0!
#DIV/0!
#DIV/0!
0.00
0.00
#DIV/0!
#DIV/0!
#DIV/0!
0.00
0.00
0.00
#DIV/0!
#DIV/0!
#DIV/0!
0.00
0.00
#DIV/0!
#DIV/0!
#DIV/0!
0.00
0.00
0.00
#DIV/0!
#DIV/0!
#DIV/0!
0.00
0.00
#DIV/0!
#DIV/0!
#DIV/0!
0.00
0.00
0.00
#DIV/0!
#DIV/0!
#DIV/0!
0.00
0.00
#DIV/0!
#DIV/0!
#DIV/0!
0.00
225.71
0.00
0.00
0.00
225.71
1354.24
225.71
0.00
0.00
0.00
225.71
761.76
126.96
0.00
0.00
0.00
126.96
126.96
0.00
0.00
0.00
126.96
0.00
0.00
#DIV/0!
#DIV/0!
#DIV/0!
0.00
0.00
#DIV/0!
#DIV/0!
#DIV/0!
0.00
0.00
0.00
#DIV/0!
#DIV/0!
#DIV/0!
0.00
0.00
#DIV/0!
#DIV/0!
#DIV/0!
0.00
0.00
0.00
#DIV/0!
#DIV/0!
#DIV/0!
0.00
0.00
#DIV/0!
#DIV/0!
#DIV/0!
0.00
0.00
0.00
#DIV/0!
#DIV/0!
#DIV/0!
0.00
0.00
#DIV/0!
#DIV/0!
#DIV/0!
0.00
Moment Distribution
HiCol
Min load
37.37
2.65
0.61
0.30
0.07
0.03
Sum
0.01
41.04
SUPT 1
-137.60
75.70
-9.75
5.37
-2.25
1.24
-1.09
0.60
-0.25
0.14
-0.12
0.07
-0.03
0.02
-67.97
LoCol
HiCol
24.53
-9.63
1.74
-2.22
0.40
-1.07
0.19
-0.25
0.04
-0.12
0.02
-0.03
0.00
26.93
-0.01
-13.33
SUPT 2
137.60
-19.51
37.85
-4.49
2.68
-2.18
0.62
-0.50
0.30
-0.24
0.07
-0.06
0.03
-0.03
152.15
-77.40
-26.01
-23.99
-5.99
4.03
-2.90
0.93
-0.67
0.45
-0.32
0.10
-0.07
0.05
-0.04
-131.83
LoCol
HiCol
-5.06
-17.77
-1.16
2.98
-0.56
0.69
-0.13
0.33
-0.06
0.08
-0.01
0.04
-0.01
-7.00
0.01
-13.64
SUPT 3
77.40
-47.98
-13.00
8.06
-2.99
1.86
-1.45
0.90
-0.33
0.21
-0.16
0.10
-0.04
0.02
22.59
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
LoCol
HiCol
-11.66
0.00
1.96
0.00
0.45
0.00
0.22
0.00
0.05
0.00
0.02
0.00
0.01
-8.95
0.00
0.00
SUPT 4
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
LoCol
HiCol
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
SUPT 5
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
LoCol
HiCol
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
SUPT 6
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
LoCol
HiCol
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
SUPT 7
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
LoCol
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
Spreadsheets to BS 8110
D&D: Main beam Grids C to H, from grid 1 to 3
Project
Location
ANALYSIS II
Live on
61.30
Odd Spans
9.93
2.73
1.11
0.30
0.12
0.03
75.54
Sum
-225.71
124.17
-36.57
20.12
-10.06
5.53
-4.08
2.24
-1.12
0.62
-0.45
0.25
-0.13
0.07
-125.11
40.23
-36.11
6.52
-9.93
1.79
-4.03
0.73
-1.11
0.20
-0.45
0.08
-0.12
0.02
49.57
-0.05
-51.80
225.71
-73.13
62.09
-20.12
10.06
-8.16
2.77
-2.24
1.12
-0.91
0.31
-0.25
0.13
-0.10
197.26
Live on
Even Spans
-5.5867112
-1.7314699
-0.6229842
-0.1930793
-0.0694701
-0.0215306
-8.23
Sum
0
20.568667
-11.31568
6.3747751
-3.507028
2.2936491
-1.261832
0.7108627
-0.391075
0.255769
-0.140709
0.0792696
-0.043609
13.62
0
-3.666279
-1.136277
-0.408833
-0.126708
-0.04559
-0.014129
-5.40
All spans
Odd Spans
Even Spans
Redistribution
0.00
-5.21
11.19
-2.11
3.08
-0.58
1.25
-0.24
0.34
-0.06
0.14
-0.03
-27.19
0.04
16.04
10.662797
-29.140204
3.3046834
-6.2946351
1.1890277
-1.9508742
0.3685112
-0.7019261
0.1325906
-0.2175455
0.0410933
-0.078273
0.0147854
15.71
-0.0242589
-38.41
0.00
-48.76
30.22
-13.41
8.31
-5.44
3.37
-1.50
0.93
-0.61
0.38
-0.17
0.10
-26.56
126.96
-78.696538
27.4248895
-16.9994
8.49970011
-5.2685647
3.05819886
-1.8956338
0.94781688
-0.5875071
0.34102527
-0.2113855
0.10569277
-0.065514
63.61
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
0
0
0
0
0
0
0
0
0
0
0
0
0.00
0.00
0.00
7.34
0.00
2.02
0.00
0.82
0.00
0.23
0.00
0.09
0.00
0.03
10.52
0.00
0.00
-19.12326
-4.130854
-1.280261
-0.460639
-0.142764
-0.051367
-0.01592
-25.21
0
0.00
Left
Right
Left
Right
Left
Right
Left
Right
Left
Right
401.73
349.42
204.47
348.06
250.10
229.78
59.64
-3.97
86.20
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
1
0.00
0.00
0.00
0.00
0.00
(3.2.2.1)
0.8
1.2
154.46
67.97
154.46
154.46
65.21
b b +
Max M
Dead only
All spans
Odd Spans
Even Spans
-18.96
(3.2.1.2.2)
179.45
193.08
54.34
20.3100896 41.1373343
0
6.29463505 12.7495502
-5.6578383
2.2648147
4.5872983
-1.7535141
0.7019261 1.42172532
-0.6309158
0.25255357 0.5115379
-0.1955375
0.07827304 0.15853915
-0.0703546
0.0281627 0.05704251
29.93
52.31
-97.51
0.00
-26.82
15.11
-10.87
4.16
-2.99
1.69
-1.21
0.46
-0.33
0.19
-0.14
-118.28
-126.96
54.849779
-39.34827
16.9994
-8.4997
6.1163977
-2.634282
1.8956338
-0.947817
0.6820505
-0.293754
0.2113855
-0.105693
0.0760567
-97.96
0.7
1.3
281.21
152.15
131.83
281.21
281.21
281.21
281.21
265.81
281.21
method 1
1
1
86.20
22.59
59.64
-3.97
86.20
1
1
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
1
1
0.00
1
1
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
Dead only
All spans
Odd Spans
Even Spans
PL1
PL2
ptUD
UDL
PL1
PL2
ptUD
UDL
PL1
PL2
ptUD
0
0
0
0
0
0
0
0
0
0
0
0
154.8
408.72
154.8
408.72
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
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
300.26
292.02
121.97
252.43
119.75
228.29
156.29
35.05
180.43
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
Span
Dead only
All spans
Odd Spans
Even Spans
UDL
206.4
544.96
544.96
206.4
Elastic Shears
Span
All spans
Odd Spans
Even Spans
244.70
252.94
84.43
Span
All spans
Odd Spans
Even Spans
0.00
0.00
0.00
0.00
0.00
0.00
6
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
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
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
0.00
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
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
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
0.00
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
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
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
0.00
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
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
0
0
0
0
0
0
0.00
Spreadsheets to BS 8110
D&D: Main beam Grids C to H, from grid 1 to 3
Project
Location
ANALYSIS III
Redistributed Shears
Span
Dead only
All spans
Odd Spans
Even Spans
92.68
256.64
256.64
78.13
Span
113.72
288.32
288.32
128.27
95.61
241.29
124.93
236.86
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
Dead only
All spans
Odd Spans
Even Spans
0.00
0.00
0.00
0.00
59.19
167.43
29.87
171.86
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
6
0.00
0.00
0.00
0.00
Imposed Reactions
Support
All spans
Odd Spans
Even Spans
79.31
79.31
-9.09
147.84
99.02
73.48
52.85
-18.33
55.62
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
Left
< >
PL1
< >
PL2
< >
Right
244.70
252.94
84.43
256.64
256.64
78.13
244.70
252.94
84.43
256.64
256.64
78.13
0.000
0.000
0.000
0.000
0.000
0.000
-179.45
-193.08
-54.34
-154.46
-154.46
-65.21
0
0
0
0
0
0
0.000
0.000
0.000
0.000
0.000
0.000
-179.45
-193.08
-54.34
-154.46
-154.46
-65.21
244.70
252.94
84.43
256.64
256.64
78.13
0.000
0.000
0.000
0.000
0.000
0.000
-179.45
-193.08
-54.34
-154.46
-154.46
-65.21
100
100
100
100
100
100
3.592
3.713
3.273
3.767
3.767
3.028
260.03
276.52
83.82
328.97
328.97
53.07
300.26
292.02
121.97
288.32
288.32
128.27
68.12
68.12
25.8
8
179.45
193.08
54.34
154.46
154.46
65.21
0
0
0
0
0
0
0.000
0.000
0.000
0.000
0.000
0.000
-179.45
-193.08
-54.34
-154.46
-154.46
-65.21
401.73
349.42
204.47
281.21
281.21
265.81
260.03
276.52
83.82
328.97
328.97
58.67
Left
< >
PL1
< >
PL2
< >
Right
252.43
119.75
228.29
241.29
124.93
236.86
252.43
119.75
228.29
241.29
124.93
236.86
0.000
0.000
0.000
0.000
0.000
0.000
-348.06
-250.10
-229.78
-281.21
-281.21
-281.21
0
0
0
0
0
0
0.000
0.000
0.000
0.000
0.000
0.000
-348.06
-250.10
-229.78
-281.21
-281.21
-281.21
252.43
119.75
228.29
241.29
124.93
236.86
0.000
0.000
0.000
0.000
0.000
0.000
-348.06
-250.10
-229.78
-281.21
-281.21
-281.21
100
100
100
100
100
100
3.706
4.641
3.351
3.542
4.842
3.477
119.65
27.79
152.75
146.12
21.26
130.59
156.29
35.05
180.43
167.43
29.87
171.86
68.12
25.8
68.12
6
348.06
250.10
229.78
281.21
281.21
281.21
0
0
0
0
0
0
0.000
0.000
0.000
0.000
0.000
0.000
-348.06
-250.10
-229.78
-281.21
-281.21
-281.21
59.64
-3.97
86.20
59.64
-3.97
86.20
119.65
27.79
152.75
146.12
21.26
130.59
Left
< >
PL1
< >
PL2
< >
Right
0.00
0.00
0.00
0.00
0.00
0.00
100
100
100
100
100
100
0.000
0.000
0.000
0.000
0.000
0.000
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.000
0.000
0.000
0.000
0.000
0.000
0.00
0.00
0.00
0.00
0.00
0.00
100
100
100
100
100
100
0.000
0.000
0.000
0.000
0.000
0.000
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.000
0.000
0.000
0.000
0.000
0.000
0.00
0.00
0.00
0.00
0.00
0.00
100
100
100
100
100
100
0.000
0.000
0.000
0.000
0.000
0.000
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
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
SPAN MOMENTS
SPAN 1
Elastic V All
Odd
Even
Redist V All
Odd
Even
Elastic X- All
Odd
Even
Redist X- All
Odd
Even
Elastic M All
Odd
Even
Redist M All
Odd
Even
SPAN 2
Elastic V All
Odd
Even
Redist V All
Odd
Even
Elastic X- All
Odd
Even
Redist X- All
Odd
Even
Elastic M All
Odd
Even
Redist M All
Odd
Even
SPAN 3
Elastic V All
Odd
Even
Redist V All
Odd
Even
Elastic X- All
Odd
Even
Redist X- All
Odd
Even
Elastic M All
Odd
Even
Redist M All
Odd
Even
Project
Location
0.00
0.00
0.00
0.00
0.00
0.00
Spreadsheets to BS 8110
D&D: Main beam Grids C to H, from grid 1 to 3
CONTINUOUS BEAM (Analysis & Design) to BS 8110:1997
Originated from RCC41.xls on CD
Loadings
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
(3.2.2.1b)
Max
1.265
1.190
0.700
Loadings
0
0
0
(3.2.2.1b)
Max
1.221
0.765
0.855
Loadings
0
0
0
(3.2.2.1b)
Max
0.000
0.000
0.000
ANALYSIS IV
Made by rmw Job No R68
Date
4-Jun-13
SPAN 4
Elastic V All
Odd
Even
Redist V All
Odd
Even
Elastic X- All
Odd
Even
Redist X- All
Odd
Even
Elastic M All
Odd
Even
Redist M All
Odd
Even
SPAN 5
Elastic V All
Odd
Even
Redist V All
Odd
Even
Elastic X- All
Odd
Even
Redist X- All
Odd
Even
Elastic M All
Odd
Even
Redist M All
Odd
Even
SPAN 6
Elastic V All
Odd
Even
Redist V All
Odd
Even
Elastic X- All
Odd
Even
Redist X- All
Odd
Even
Elastic M All
Odd
Even
Redist M All
Odd
Even
Left
< >
PL1
< >
PL2
< >
Right
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.000
0.000
0.000
0.000
0.000
0.000
0.00
0.00
0.00
0.00
0.00
0.00
100
100
100
100
100
100
0.000
0.000
0.000
0.000
0.000
0.000
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.000
0.000
0.000
0.000
0.000
0.000
0.00
0.00
0.00
0.00
0.00
0.00
100
100
100
100
100
100
0.000
0.000
0.000
0.000
0.000
0.000
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
0
0
0
0.00
0.00
0.00
0.00
0.00
0.00
100
100
100
100
100
100
0.000
0.000
0.000
0.000
0.000
0.000
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
Left
< >
PL1
< >
PL2
< >
Right
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.000
0.000
0.000
0.000
0.000
0.000
0.00
0.00
0.00
0.00
0.00
0.00
100
100
100
100
100
100
0.000
0.000
0.000
0.000
0.000
0.000
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.000
0.000
0.000
0.000
0.000
0.000
0.00
0.00
0.00
0.00
0.00
0.00
100
100
100
100
100
100
0.000
0.000
0.000
0.000
0.000
0.000
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
0
0
0
0.00
0.00
0.00
0.00
0.00
0.00
100
100
100
100
100
100
0.000
0.000
0.000
0.000
0.000
0.000
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
Left
< >
PL1
< >
PL2
< >
Right
0.00
0.00
0.00
0.00
0.00
0.00
100
100
100
100
100
100
0.000
0.000
0.000
0.000
0.000
0.000
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.000
0.000
0.000
0.000
0.000
0.000
0.00
0.00
0.00
0.00
0.00
0.00
100
100
100
100
100
100
0.000
0.000
0.000
0.000
0.000
0.000
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.000
0.000
0.000
0.000
0.000
0.000
0.00
0.00
0.00
0.00
0.00
0.00
100
100
100
100
100
100
0.000
0.000
0.000
0.000
0.000
0.000
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
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
Loadings
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
(3.2.2.1b)
Max
0.000
0.000
0.000
Loadings
0
0
0
(3.2.2.1b)
Max
0.000
0.000
0.000
Loadings
0
0
0
(3.2.2.1b)
Max
0.000
0.000
0.000
Span 8.00 m
R beam
h 500
bw 300
hf 175
MAIN STEEL
M CL
M face
b
d
bf
K'
Web Mres
Flange Mres
K
kNm
mm
v
vc
(v-vc)bv
Link
Legs
@
Adjust to
for (UDL only)
for (with PL)
Adjust to
As Dist
As' Dist
LEFT
154.5
116.7
0.800
433.0
300.0
0.132
297.0
~~~
0.052
406.4
59.1
94.0
0.0
0.0
0
438.1
656
~~~
0.13%
195
kNm
mm
mm
kNm
kNm
x
mm
d'
mm
net fsc
N/mm
Excess M
kNm
As' req
mm
fst
N/mm
As req
mm
bw/b
Min %
%
Min As
mm
DEFLECTION
fs
N/mm
Base ratio
Tens Mod
Comp Mod
Perm L/d
Actual L/d
TENSION STEEL
As
mm
1
mm
2
mm
Max No/layer
No 1
=
mm
No 2
As prov
mm
=%
%
Clear dist
mm
Min S
mm
Max S
mm
COMPRESSION STEEL
Required
mm
1
mm
2
mm
Max No/layer
No 1
=
No 2
As' prov
mm
=%
%
Clear dist
mm
Min S
mm
SHEAR
V at cl
kN
V at d
kN
ok
ok
ok
ok
ok
ok
ok
ok
60.9
0.7
455.0
300.0
0.104
259.4
~~~
0.024
432.3
50.6
68.0
0.0
0.0
0
438.1
321
~~~
0.13%
195
329.0
1.190
432.0
300.0
0.156
348.9
323.1
0.147
343.3
197.2
45.0
420.2
0.0
0
438.1
2188
1.0
0.13%
195
RIGHT
281.2
250.2
0.700
415.0
300.0
0.104
215.8
~~~
0.121
359.4
123.5
96.5
135.3
34.5
800
438.1
1617
~~~
0.13%
195
233.7
26.0
0.8
1.1
24.1
18.5
293.7
100.0
0.8
1.2
98.6
0.0
724
20
0
4
3
942
0
942
0.726
73.0
25.0
ok
ok
ok
ok
ok
ok
ok
ok
ok
2188
32
0
3
3
2413
0
2413
1.862
55.0
32.0
201.1
323
16
0
5
2
402
0
402
0.310
174.0
25.0
ok
ok
ok
ok
ok
ok
ok
ok
ok
ok
256.6
216.9
N/mm
N/mm
ok
ok
mm
mm
mm
mm
mm
mm
mm
656
20
0
4
3
942
0
942
0.726
73.0
25.0
176.2
mm to main steel
mm to main steel
mm to main steel
SPAN
ok
ok
37
52
47
.25L
266.7
N/mm
mm
Top cover
Btm cover
Side cover
SPAN 1
ok
ok
1.670
0.527
342.8
12
2
157
150
1999
1999
1950
93.0
73.0
1617
32
0
3
3
2413
0
2413
1.938
55.0
32.0
160.1
800
25
0
4
2
982
0
982
0.789
156.0
25.0
288.3
249.8
Nominal
ok
ok
ok
ok
120.0
12
2
324
300
~~~
~~~
~~~
87.0
0.0
ok
ok
ok
ok
2.007
0.731
382.6
12
2
141
125
2165
#N/A
2125
87.0
0.0
Job No R68
by
rmw
Date
4-Jun-13
BS8110 Ref
3.4.1.5
Fig 3.3
Fig 3.3
Fig 3.3
3.4.4.4
3.4.4.4
3.4.4.4
Fig 3.3
Fig 3.3
Table 3.25
Eqn 8
3.4.6.3/4
Table 3.10
Table 3.11
3.4.6.3
3.4.5.1
between bars
3.12.11.1
Table 3.28
Table 3.25
between bars
3.12.11.1
3.4.5.10
Eqn 3
Table 3.8
Table 3.7
3.12.7.1
3.12.7.1
from cl
-=from face
3.4.5.5
3.12.7.2
Span 6.000 m
R beam
h 500
bw 300
hf 175
MAIN STEEL
M CL
M face
b
d
bf
K'
Web Mres
Flange Mres
K
kNm
mm
v
vc
(v-vc)bv
Link
Legs
@
Adjust to
for (UDL only)
for (with PL)
Adjust to
As Dist
As' Dist
LEFT
281.2
262.8
0.808
415.0
300.0
0.134
277.0
~~~
0.127
344.3
157.0
89.5
283.1
0.0
0
438.1
1742
~~~
0.13%
195
kNm
mm
mm
kNm
kNm
x
mm
d'
mm
net fsc
N/mm
Excess M
kNm
As' req
mm
fst
N/mm
As req
mm
bw/b
Min %
%
Min As
mm
DEFLECTION
fs
N/mm
Base ratio
Tens Mod
Comp Mod
Perm L/d
Actual L/d
TENSION STEEL
As
mm
1
mm
2
mm
Max No/layer
No 1
=
mm
No 2
As prov
mm
=%
%
Clear dist
mm
Min S
mm
Max S
mm
COMPRESSION STEEL
Required
mm
1
mm
2
mm
Max No/layer
No 1
=
No 2
As' prov
mm
=%
%
Clear dist
mm
Min S
mm
SHEAR
V at cl
kN
V at d
kN
274.0
100.0
0.8
1.2
100.6
0.0
ok
ok
ok
ok
ok
ok
ok
ok
ok
N/mm
N/mm
ok
ok
mm
mm
mm
mm
mm
mm
mm
1742
32
0
3
3
2413
0
2413
1.938
55.0
32.0
171.5
295
25
0
4
2
982
0
982
0.789
156.0
25.0
37
52
47
.25L
SPAN
122.8
0.808
450.5
300.0
0.134
326.4
~~~
0.050
423.7
59.7
64.5
0.0
0.0
0
438.1
662
~~~
0.13%
195
146.1
0.957
435.5
300.0
0.156
354.5
326.4
0.064
401.8
74.8
49.5
219.1
0.0
0
438.1
830
1.0
0.13%
195
ok
ok
ok
ok
ok
ok
ok
ok
ok
ok
271.0
26.0
1.0
1.2
32.6
13.8
830
25
0
4
2
982
0
982
0.751
156.0
25.0
173.4
662
25
0
4
2
982
0
982
0.751
156.0
25.0
mm to main steel
mm to main steel
mm to main steel
RIGHT
86.2
61.2
1.000
439.0
300.0
0.156
360.3
~~~
0.026
417.1
48.8
85.0
0.0
0.0
0
438.1
335
~~~
0.13%
195
255.4
ok
ok
1.629
0.731
269.2
12
2
200
200
1474
1474
1400
87.0
0.0
ok
ok
BS8110 Ref
3.4.1.5
Fig 3.3
Fig 3.3
Fig 3.3
3.4.4.4
3.4.4.4
3.4.4.4
Fig 3.3
Fig 3.3
Table 3.25
Eqn 8
Table 3.11
3.4.6.3
ok
ok
ok
ok
ok
ok
ok
ok
ok
ok
Nominal
120.0
12
2
327
325
~~~
~~~
~~~
0.0
0.0
R68
rmw
4-Jun-13
Table 3.10
3.4.5.1
335
16
0
5
2
402
0
402
0.305
174.0
25.0
184.0
295
16
0
5
2
402
0
402
0.305
174.0
25.0
171.9
131.7
ok
ok
Job No
by
Date
3.4.6.3/4
241.3
202.8
N/mm
mm
Top cover
Btm cover
Side cover
SPAN 2
ok
ok
ok
ok
1.000
0.395
181.6
12
2
297
275
986
#N/A
1100
0.0
0.0
between bars
3.12.11.1
Table 3.28
Table 3.25
between bars
3.12.11.1
3.4.5.10
Eqn 3
Table 3.8
Table 3.7
3.12.7.1
3.12.7.1
from cl
-=from face
3.4.5.5
3.12.7.2
Span 0.00 m
0 beam
MAIN STEEL
M CL
M face
b
d
bf
K'
Web Mres
Flange Mres
K
kNm
mm
kNm
mm
mm
kNm
kNm
x
mm
d'
mm
net fsc
N/mm
Excess M
kNm
As' req
mm
fst
N/mm
As req
mm
bw/b
Min %
%
Min As
mm
DEFLECTION
fs
N/mm
Base ratio
Tens Mod
Comp Mod
Perm L/d
Actual L/d
TENSION STEEL
As
mm
1
mm
2
mm
Max No/layer
No 1
=
mm
No 2
As prov
mm
=%
%
Clear dist
mm
Min S
mm
Max S
mm
COMPRESSION STEEL
Required
mm
1
mm
2
mm
Max No/layer
No 1
=
No 2
As' prov
mm
=%
%
Clear dist
mm
Min S
mm
SHEAR
V at cl
kN
V at d
kN
v
vc
(v-vc)bv
Link
Legs
@
Adjust to
for (UDL only)
for (with PL)
Adjust to
As Dist
As' Dist
h 0
bw 0
hf 0
SPAN 3 IS NON-EXISTANT!
LEFT
0.0
0.0
1.000
-57.0
0.0
0.156
0.0
~~~
#DIV/0!
#DIV/0!
#DIV/0!
88.0
#DIV/0!
0.0
#DIV/0!
#DIV/0!
#DIV/0!
~~~
0.26%
0
#DIV/0!
100.0
#DIV/0!
#DIV/0!
#DIV/0!
0.0
ok
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
ok
#DIV/0!
#DIV/0!
#DIV/0!
N/mm
N/mm
#DIV/0!
#DIV/0!
mm
mm
mm
mm
mm
mm
mm
#DIV/0!
16
0
-3
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
25.0
33
48
43
.25L
SPAN
0.0
1
-41.0
0.0
0.156
0.0
~~~
#DIV/0!
#DIV/0!
#DIV/0!
64.0
#DIV/0!
0.0
#DIV/0!
#DIV/0!
#DIV/0!
~~~
0.00%
0
0.0
~
-64.0
0.0
0.156
0.0
0.0
#DIV/0!
#DIV/0!
#DIV/0!
41.0
#DIV/0!
0.0
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
ok
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
ok
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
0.0
#DIV/0!
32
0
-2
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
32.0
#DIV/0!
#DIV/0!
16
0
-3
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
25.0
mm to main steel
mm to main steel
mm to main steel
RIGHT
0.0
0.0
1.000
-48.0
0.0
0.156
0.0
~~~
#DIV/0!
#DIV/0!
#DIV/0!
92.5
#DIV/0!
0.0
#DIV/0!
#DIV/0!
#DIV/0!
~~~
0.26%
0
#DIV/0!
#DIV/0!
#DIV/0!
#VALUE!
#DIV/0!
#VALUE!
8
8
#VALUE!
#VALUE!
#VALUE!
#VALUE!
#VALUE!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
BS8110 Ref
3.4.1.5
Fig 3.3
Fig 3.3
Fig 3.3
3.4.4.4
3.4.4.4
3.4.4.4
Fig 3.3
Fig 3.3
Table 3.25
Eqn 8
Table 3.11
3.4.6.3
#DIV/0!
ok
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
ok
#DIV/0!
#DIV/0!
#DIV/0!
Nominal
0.0
8
8
#DIV/0!
#DIV/0!
~~~
~~~
~~~
#DIV/0!
#DIV/0!
R68
rmw
4-Jun-13
Table 3.10
3.4.5.1
#DIV/0!
10
0
-3
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
25.0
#DIV/0!
#DIV/0!
25
0
-2
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
25.0
~
#VALUE!
#DIV/0!
#DIV/0!
Job No
by
Date
3.4.6.3/4
~
#VALUE!
N/mm
mm
#DIV/0!
16
0
-3
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
25.0
#DIV/0!
Top cover
Btm cover
Side cover
SPAN 3
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#VALUE!
#DIV/0!
#VALUE!
8
10
#VALUE!
#VALUE!
#VALUE!
#N/A
#VALUE!
#DIV/0!
#DIV/0!
between bars
3.12.11.1
Table 3.28
Table 3.25
between bars
3.12.11.1
3.4.5.10
Eqn 3
Table 3.8
Table 3.7
3.12.7.1
3.12.7.1
from cl
-=from face
3.4.5.5
3.12.7.2
Span 0.000 m
0 beam
MAIN STEEL
M CL
M face
b
d
bf
K'
Web Mres
Flange Mres
K
kNm
mm
kNm
mm
mm
kNm
kNm
x
mm
d'
mm
net fsc
N/mm
Excess M
kNm
As' req
mm
fst
N/mm
As req
mm
bw/b
Min %
%
Min As
mm
DEFLECTION
fs
N/mm
Base ratio
Tens Mod
Comp Mod
Perm L/d
Actual L/d
TENSION STEEL
As
mm
1
mm
2
mm
Max No/layer
No 1
=
mm
No 2
As prov
mm
=%
%
Clear dist
mm
Min S
mm
Max S
mm
COMPRESSION STEEL
Required
mm
1
mm
2
mm
Max No/layer
No 1
=
No 2
As' prov
mm
=%
%
Clear dist
mm
Min S
mm
SHEAR
V at cl
kN
V at d
kN
v
vc
(v-vc)bv
Link
Legs
@
Adjust to
for (UDL only)
for (with PL)
Adjust to
As Dist
As' Dist
h 0
bw 0
hf 0
SPAN 4 IS NON-EXISTANT!
LEFT
0.0
0.0
1.000
-50.0
0.0
0.156
0.0
~~~
#DIV/0!
#DIV/0!
#DIV/0!
78.5
#DIV/0!
0.0
#DIV/0!
#DIV/0!
#DIV/0!
~~~
0.26%
0
#DIV/0!
100.0
#DIV/0!
#DIV/0!
#DIV/0!
0.0
ok
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
ok
#DIV/0!
#DIV/0!
#DIV/0!
N/mm
N/mm
#DIV/0!
#DIV/0!
mm
mm
mm
mm
mm
mm
mm
#DIV/0!
25
0
-2
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
25.0
35
50
45
.25L
SPAN
0.0
1
-43.0
0.0
0.156
0.0
~~~
#DIV/0!
#DIV/0!
#DIV/0!
58.0
#DIV/0!
0.0
#DIV/0!
#DIV/0!
#DIV/0!
~~~
0.00%
0
0.0
~
-58.0
0.0
0.156
0.0
0.0
#DIV/0!
#DIV/0!
#DIV/0!
43.0
#DIV/0!
0.0
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
ok
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
ok
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
0.0
#DIV/0!
16
0
-3
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
25.0
#DIV/0!
#DIV/0!
16
0
-3
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
25.0
mm to main steel
mm to main steel
mm to main steel
RIGHT
0.0
0.0
1.000
-59.0
0.0
0.156
0.0
~~~
#DIV/0!
#DIV/0!
#DIV/0!
74.0
#DIV/0!
0.0
#DIV/0!
#DIV/0!
#DIV/0!
~~~
0.26%
0
#DIV/0!
#DIV/0!
#DIV/0!
#VALUE!
#DIV/0!
#VALUE!
10
2
#VALUE!
#VALUE!
#VALUE!
#VALUE!
#VALUE!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
BS8110 Ref
3.4.1.5
Fig 3.3
Fig 3.3
Fig 3.3
3.4.4.4
3.4.4.4
3.4.4.4
Fig 3.3
Fig 3.3
Table 3.25
Eqn 8
Table 3.11
3.4.6.3
#DIV/0!
ok
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
ok
#DIV/0!
#DIV/0!
#DIV/0!
Nominal
0.0
10
2
#DIV/0!
#DIV/0!
~~~
~~~
~~~
#DIV/0!
#DIV/0!
R68
rmw
4-Jun-13
Table 3.10
3.4.5.1
#DIV/0!
16
0
-3
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
25.0
#DIV/0!
#DIV/0!
16
0
-3
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
25.0
~
#VALUE!
#DIV/0!
#DIV/0!
Job No
by
Date
3.4.6.3/4
~
#VALUE!
N/mm
mm
#DIV/0!
10
0
-3
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
25.0
#DIV/0!
Top cover
Btm cover
Side cover
SPAN 4
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#VALUE!
#DIV/0!
#VALUE!
10
2
#VALUE!
#VALUE!
#VALUE!
#N/A
#VALUE!
#DIV/0!
#DIV/0!
between bars
3.12.11.1
Table 3.28
Table 3.25
between bars
3.12.11.1
3.4.5.10
Eqn 3
Table 3.8
Table 3.7
3.12.7.1
3.12.7.1
from cl
-=from face
3.4.5.5
3.12.7.2
Span 0.00 m
0 beam
MAIN STEEL
M CL
M face
b
d
bf
K'
Web Mres
Flange Mres
K
kNm
mm
kNm
mm
mm
kNm
kNm
x
mm
d'
mm
net fsc
N/mm
Excess M
kNm
As' req
mm
fst
N/mm
As req
mm
bw/b
Min %
%
Min As
mm
DEFLECTION
fs
N/mm
Base ratio
Tens Mod
Comp Mod
Perm L/d
Actual L/d
TENSION STEEL
As
mm
1
mm
2
mm
Max No/layer
No 1
=
mm
No 2
As prov
mm
=%
%
Clear dist
mm
Min S
mm
Max S
mm
COMPRESSION STEEL
Required
mm
1
mm
2
mm
Max No/layer
No 1
=
No 2
As' prov
mm
=%
%
Clear dist
mm
Min S
mm
SHEAR
V at cl
kN
V at d
kN
v
vc
(v-vc)bv
Link
Legs
@
Adjust to
for (UDL only)
for (with PL)
Adjust to
As Dist
As' Dist
h 0
bw 0
hf 0
SPAN 5 IS NON-EXISTANT!
LEFT
0.0
0.0
1.000
-59.0
0.0
0.156
0.0
~~~
#DIV/0!
#DIV/0!
#DIV/0!
83.0
#DIV/0!
0.0
#DIV/0!
#DIV/0!
#DIV/0!
~~~
0.26%
0
#DIV/0!
100.0
#DIV/0!
#DIV/0!
#DIV/0!
0.0
ok
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
ok
#DIV/0!
#DIV/0!
#DIV/0!
N/mm
N/mm
#DIV/0!
#DIV/0!
mm
mm
mm
mm
mm
mm
mm
#DIV/0!
16
0
-3
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
25.0
35
50
45
.25L
SPAN
0.0
1
-43.0
0.0
0.156
0.0
~~~
#DIV/0!
#DIV/0!
#DIV/0!
62.5
#DIV/0!
0.0
#DIV/0!
#DIV/0!
#DIV/0!
~~~
0.00%
0
0.0
~
-62.5
0.0
0.156
0.0
0.0
#DIV/0!
#DIV/0!
#DIV/0!
43.0
#DIV/0!
0.0
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
ok
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
ok
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
0.0
#DIV/0!
25
0
-2
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
25.0
#DIV/0!
#DIV/0!
16
0
-3
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
25.0
mm to main steel
mm to main steel
mm to main steel
RIGHT
0.0
0.0
1.000
-72.5
0.0
0.156
0.0
~~~
#DIV/0!
#DIV/0!
#DIV/0!
83.0
#DIV/0!
0.0
#DIV/0!
#DIV/0!
#DIV/0!
~~~
0.26%
0
#DIV/0!
#DIV/0!
#DIV/0!
#VALUE!
#DIV/0!
#VALUE!
10
2
#VALUE!
#VALUE!
#VALUE!
#VALUE!
#VALUE!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
BS8110 Ref
3.4.1.5
Fig 3.3
Fig 3.3
Fig 3.3
3.4.4.4
3.4.4.4
3.4.4.4
Fig 3.3
Fig 3.3
Table 3.25
Eqn 8
Table 3.11
3.4.6.3
#DIV/0!
ok
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
ok
#DIV/0!
#DIV/0!
#DIV/0!
Nominal
0.0
10
2
#DIV/0!
#DIV/0!
~~~
~~~
~~~
#DIV/0!
#DIV/0!
R68
rmw
4-Jun-13
Table 3.10
3.4.5.1
#DIV/0!
25
0
-2
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
25.0
#DIV/0!
#DIV/0!
16
0
-3
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
25.0
~
#VALUE!
#DIV/0!
#DIV/0!
Job No
by
Date
3.4.6.3/4
~
#VALUE!
N/mm
mm
#DIV/0!
16
0
-3
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
25.0
#DIV/0!
Top cover
Btm cover
Side cover
SPAN 5
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#VALUE!
#DIV/0!
#VALUE!
10
2
#VALUE!
#VALUE!
#VALUE!
#N/A
#VALUE!
#DIV/0!
#DIV/0!
between bars
3.12.11.1
Table 3.28
Table 3.25
between bars
3.12.11.1
3.4.5.10
Eqn 3
Table 3.8
Table 3.7
3.12.7.1
3.12.7.1
from cl
-=from face
3.4.5.5
3.12.7.2
Span 0.000 m
0 beam
MAIN STEEL
M CL
M face
b
d
bf
K'
Web Mres
Flange Mres
K
kNm
mm
kNm
mm
mm
kNm
kNm
x
mm
d'
mm
net fsc
N/mm
Excess M
kNm
As' req
mm
fst
N/mm
As req
mm
bw/b
Min %
%
Min As
mm
DEFLECTION
fs
N/mm
Base ratio
Tens Mod
Comp Mod
Perm L/d
Actual L/d
TENSION STEEL
As
mm
1
mm
2
mm
Max No/layer
No 1
=
mm
No 2
As prov
mm
=%
%
Clear dist
mm
Min S
mm
Max S
mm
COMPRESSION STEEL
Required
mm
1
mm
2
mm
Max No/layer
No 1
=
No 2
As' prov
mm
=%
%
Clear dist
mm
Min S
mm
SHEAR
V at cl
kN
V at d
kN
v
vc
(v-vc)bv
Link
Legs
@
Adjust to
for (UDL only)
for (with PL)
Adjust to
As Dist
As' Dist
h 0
bw 0
hf 0
SPAN 6 IS NON-EXISTANT!
LEFT
0.0
0.0
1.000
-72.5
0.0
0.156
0.0
~~~
#DIV/0!
#DIV/0!
#DIV/0!
83.0
#DIV/0!
0.0
#DIV/0!
#DIV/0!
#DIV/0!
~~~
0.26%
0
#DIV/0!
100.0
#DIV/0!
#DIV/0!
#DIV/0!
0.0
ok
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
ok
#DIV/0!
#DIV/0!
#DIV/0!
N/mm
N/mm
#DIV/0!
#DIV/0!
mm
mm
mm
mm
mm
mm
mm
#DIV/0!
16
0
-3
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
25.0
35
50
45
.25L
SPAN
0.0
1
-43.0
0.0
0.156
0.0
~~~
#DIV/0!
#DIV/0!
#DIV/0!
62.5
#DIV/0!
0.0
#DIV/0!
#DIV/0!
#DIV/0!
~~~
0.00%
0
0.0
~
-62.5
0.0
0.156
0.0
0.0
#DIV/0!
#DIV/0!
#DIV/0!
43.0
#DIV/0!
0.0
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
ok
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
ok
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
0.0
#DIV/0!
25
0
-2
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
25.0
#DIV/0!
#DIV/0!
16
0
-3
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
25.0
mm to main steel
mm to main steel
mm to main steel
RIGHT
0.0
0.0
~
-59.0
0.0
0.156
0.0
~~~
#DIV/0!
#DIV/0!
#DIV/0!
83.0
#DIV/0!
0.0
#DIV/0!
#DIV/0!
#DIV/0!
~~~
0.26%
0
#DIV/0!
#DIV/0!
#DIV/0!
#VALUE!
#DIV/0!
#VALUE!
10
2
#VALUE!
#VALUE!
#VALUE!
#VALUE!
#VALUE!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
BS8110 Ref
3.4.1.5
Fig 3.3
Fig 3.3
Fig 3.3
3.4.4.4
3.4.4.4
3.4.4.4
Fig 3.3
Fig 3.3
Table 3.25
Eqn 8
Table 3.11
3.4.6.3
#DIV/0!
ok
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
ok
#DIV/0!
#DIV/0!
#DIV/0!
Nominal
0.0
10
2
#DIV/0!
#DIV/0!
~~~
~~~
~~~
#DIV/0!
#DIV/0!
R68
rmw
4-Jun-13
Table 3.10
3.4.5.1
#DIV/0!
16
0
-3
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
25.0
#DIV/0!
#DIV/0!
16
0
-3
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
25.0
~
#VALUE!
#DIV/0!
#DIV/0!
Job No
by
Date
3.4.6.3/4
~
#VALUE!
N/mm
mm
#DIV/0!
25
0
-2
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
25.0
#DIV/0!
Top cover
Btm cover
Side cover
SPAN 6
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#VALUE!
#DIV/0!
#VALUE!
10
2
#VALUE!
#VALUE!
#VALUE!
#N/A
#VALUE!
#DIV/0!
#DIV/0!
between bars
3.12.11.1
Table 3.28
Table 3.25
between bars
3.12.11.1
3.4.5.10
Eqn 3
Table 3.8
Table 3.7
3.12.7.1
3.12.7.1
from cl
-=from face
3.4.5.5
3.12.7.2
Spreadsheets to BS 8110
D&D: Main beam Grids C to H, from grid 1 to 3
Project
Location
GRAPH DATA I
LOADING DIAGRAM
BEAM
SUPPORTS
D UDL
L UDL
D PUDL
L PUDL
PL 1
PL 2
0
0
0
-57.58
0
0
25.8
0
45.8
45.8
0
45.8
45.8
0
45.8
45.8
Made by rmw
14.394
14
0
0
50.38
0
25.8
45.8
0
45.8
45.8
0
45.8
45.8
0
45.8
45.8
8
25.8
45.8
0
45.8
45.8
8
-71.97
8
0
25.8
0
45.8
45.8
8
45.8
45.8
8
45.8
45.8
8
50.38
8
25.8
45.8
0.8
5.4966
12.526
-4.947
0
-29.05
-29.05
10.969
8.7681
-3.463
-29.05
10.969
0
0.8
1.2
-65.13
-61.4
-28.4
0
-104.5
-104.5
-9.962
-19.88
-45.59
-104.5
0
0
4
14
25.8
45.8
8
45.8
45.8
8
45.8
45.8
8
45.8
45.8
14
-57.577
14
0
25.8
8
45.8
45.8
14
0
0
14
0
0
14
50.38
14
0
0
8
45.8
45.8
14
0
0
14
0
0
2
-173.7
-176.56
-62.925
0
-222.57
-222.57
-39.438
-44.047
-123.59
-222.57
0
0
4
2.4
-211.6
-217.8
-73.99
0
-265.3
-265.3
-47.98
-51.8
-152.5
-265.3
0
0
4
14
0
0
8
45.8
45.8
14
-14.39
14
0
0
14
0
0
14
0
0
14
0
14
0
0
14
0
0
14
0
0
14
0
0
3.2
-254.8
-267.5
-83.75
0
-318
-318
-52.69
-58.63
-187.3
-318
0
0
4
3.6
-260
-276.1
-82.44
0
-328
-328
-48.86
-57.71
-193.3
-328
0
0
4
14
0
0
14
0
0
14
-14.39
14
0
0
14
0
0
14
0
0
14
0
0
14
0
14
0
0
14
0
0
14
0
0
14
0
0
14
0
0
14
0
14
0
0
14
0
0
14
0
0
14
0
0
14
0
14
0
0
14
0
0
14
0
0
14
0
0
14
0
0
14
0
0
14
0
14
0
0
14
0
0
14
0
14
0
0
14
0
0
14
0
0
14
0
0
14
0
0
MOMENT DIAGRAMS
SPAN 1
X
M(e) all
M(e) odd
M(e) even
Beam
M(r) all
M(r) odd
M(r) even
70% max
70% min
Lower bound
Upper bound
Beam
L0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
179.45
193.08
54.344
0
154.46
154.46
65.213
135.15
38.041
0
154.46
0
4
0.4
87.026
97.352
22.634
0
57.257
57.257
36.027
68.147
15.844
0
68.147
0
4
1.6
-124.9
-124.4
-47.73
0
-169
-169
-26.76
-33.41
-87.41
-169
0
0
4
2.8
-238.7
-248.1
-80.94
0
-297.1
-297.1
-52.4
-56.66
-173.7
-297.1
0
0
4
4
-254.4
-273.7
-76.99
0
-327.1
-327.1
-40.89
-53.9
-191.6
-327.1
0
0
6
4.4
-237.8
-260.4
-67.42
0
-315.3
-315.3
-28.8
-47.2
-182.3
-315.3
0
0
8
4.8
-210.3
-236.3
-53.73
0
-292.6
-292.6
-12.57
-37.61
-165.4
-292.6
0
0
8
5.2
5.6
6
6.4
-172
-122.7 -62.56 8.5013
-201.2 -155.3 -98.39 -30.63
-35.9 -13.95 12.137 42.347
0
0
0
0
-259.1 -214.6 -159.2 -92.91
-259.1 -214.6 -159.2 -92.91
7.7759 32.254 60.859 93.593
-25.13 -9.762 8.4958 29.643
-140.9 -108.7 -68.87 -21.44
-259.1 -214.6 -159.2 -92.91
7.7759 32.254 60.859 93.593
0
0
0
0
8
8
8
8
6.8
90.46
48.036
76.685
0
-15.73
-15.73
130.45
63.322
33.625
-15.73
130.45
0
6.8
7.2
183.32
137.6
115.15
0
72.351
72.351
171.44
128.32
80.606
0
171.44
0
8
7.6
287.07
238.06
157.75
0
171.33
171.33
216.56
200.95
110.42
0
216.56
0
8
8
401.73
349.42
204.47
0
281.21
281.21
265.81
281.21
143.13
0
281.21
0
8
0
8
348.06
250.1
229.78
0
281.21
281.21
281.21
243.64
160.85
0
281.21
0
3
0.3
0.6
0.9
1.2
1.5
1.8
2.1
2.4
2.7
3
3.3
8.3
8.6
8.9
9.2
9.5
9.8
10.1
10.4
10.7
11
11.3
275.4 208.86 148.46 94.19 46.049 4.0398 -31.84 -61.59 -85.2 -102.7
-114
215.34 182.9 152.78 124.98 99.507 76.354 55.524 37.015 20.828 6.9635 -4.579
164.36 105.07 51.911 4.8818 -36.017 -70.78 -99.42 -121.9 -138.3 -148.5 -152.7
0
0
0
0
0
0
0
0
0
0
0
211.89 148.7 91.64 40.712 -4.0865 -42.75 -75.29 -101.7
-122
-136.1 -144.1
244.89 210.9 179.22 149.87 122.84 98.132 75.746 55.682 37.939 22.519 9.4207
213.22 151.36 95.625 46.024 2.5539 -34.79 -65.99 -91.07
-110
-122.8 -129.5
192.78 146.2 106.95 87.487 69.655 53.448 38.867 25.91 14.58 4.8745 -3.205
115.05 73.55 36.338 3.4173 -25.212 -49.55 -69.6 -85.35 -96.81
-104
-106.9
0
0
0
0
-25.212 -49.55 -75.29 -101.7
-122
-136.1 -144.1
244.89 210.9 179.22 149.87 122.84 98.132 75.746 55.682 37.939 22.519 9.4207
0
0
0
0
0
0
0
0
0
0
0
3
3
3
3
3
1.8
3
3
3
3.6
6
3.6
11.6
-119.3
-13.8
-150.6
0
-146
-1.356
-130.1
-9.66
-105.5
-146
0
0
6
3.9
11.9
-118.4
-20.7
-142.5
0
-141.8
-9.81
-124.5
-14.49
-99.75
-141.8
0
0
6
4.2
12.2
-111.3
-25.28
-128.2
0
-131.4
-15.94
-112.8
-17.69
-89.75
-131.4
0
0
6
4.5
12.5
-98.16
-27.53
-107.8
0
-114.9
-19.75
-94.95
-19.27
-75.47
-114.9
0
0
6
4.8
12.8
-78.86
-27.46
-81.27
0
-92.23
-21.24
-70.98
-19.22
-56.89
-92.23
0
0
6
5.1
13.1
-53.43
-25.07
-48.6
0
-63.46
-20.41
-40.88
-17.55
-37.4
-63.46
0
0
6
5.4
13.4
-21.87
-20.36
-9.795
0
-28.56
-17.25
-4.653
-6.857
-15.31
-28.56
0
0
5.4
5.7
13.7
15.818
-13.33
35.137
0
12.475
-11.77
37.709
24.596
-9.33
-11.77
37.709
0
6
6
14
59.639
-3.974
86.201
0
59.639
-3.974
86.201
60.34
-2.782
-3.974
86.201
0
6
0
14
0
0
0
0
0
0
0
0
0
0
0
0
0
0
14
0
0
0
0
0
0
0
0
0
0
0
0
0
0
14
0
0
0
0
0
0
0
0
0
0
0
0
0
0
14
0
0
0
0
0
0
0
0
0
0
0
0
0
0
14
0
0
0
0
0
0
0
0
0
0
0
0
0
0
14
0
0
0
0
0
0
0
0
0
0
0
0
0
0
14
0
0
0
0
0
0
0
0
0
0
0
0
0
0
14
0
0
0
0
0
0
0
0
0
0
0
0
0
0
14
0
0
0
0
0
0
0
0
0
0
0
0
0
at col face
0.15
7.85
143.52 357.46
155.9 306.38
41.969 186.46
0
0
116.73 238.73
116.73 238.73
53.784 246.86
109.13 250.22
29.378 130.52
29.378 130.52
116.73 250.22
0
0
SPAN 2
Local X
X
M(e) all
M(e) odd
M(e) even
Beam
M(r) all
M(r) odd
M(r) even
70% max
70% min
Lower bound
Upper bound
Beam
L0
0.15
5.85
310.96
232.43
196.31
0
245.78
262.76
246.45
217.67
137.41
137.41
262.76
0
36.962
-8.942
59.903
0
35.291
-8.164
61.188
41.932
-6.259
-8.164
61.188
0
0.15
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
SPAN 3
Local X
X
M(e) all
M(e) odd
M(e) even
Beam
M(r) all
M(r) odd
M(r) even
70% max
70% min
Lower bound
Upper bound
Beam
L0
0
14
0
0
0
0
0
0
0
0
0
0
0
0
0
0
14
0
0
0
0
0
0
0
0
0
0
0
0
0
0
14
0
0
0
0
0
0
0
0
0
0
0
0
0
0
14
0
0
0
0
0
0
0
0
0
0
0
0
0
0
14
0
0
0
0
0
0
0
0
0
0
0
0
0
0
14
0
0
0
0
0
0
0
0
0
0
0
0
0
0
14
0
0
0
0
0
0
0
0
0
0
0
0
0
0
14
0
0
0
0
0
0
0
0
0
0
0
0
0
0
14
0
0
0
0
0
0
0
0
0
0
0
0
0
0
14
0
0
0
0
0
0
0
0
0
0
0
0
0
0
14
0
0
0
0
0
0
0
0
0
0
0
0
0
0
14
0
0
0
0
0
0
0
0
0
0
0
0
0
14
0
0
14
0
0
14
0
0
Job No R68
Date
4-Jun-13
Spreadsheets to BS 8110
D&D: Main beam Grids C to H, from grid 1 to 3
Project
Location
GRAPH DATA II
Made by rmw
Job No R68
Date
4-Jun-13
SPAN 4
Local X
X
M(e) all
M(e) odd
M(e) even
Beam
M(r) all
M(r) odd
M(r) even
70% max
70% min
Lower bound
Upper bound
Beam
L0
0
14
0
0
0
0
0
0
0
0
0
0
0
0
0
0
14
0
0
0
0
0
0
0
0
0
0
0
0
0
0
14
0
0
0
0
0
0
0
0
0
0
0
0
0
0
14
0
0
0
0
0
0
0
0
0
0
0
0
0
0
14
0
0
0
0
0
0
0
0
0
0
0
0
0
0
14
0
0
0
0
0
0
0
0
0
0
0
0
0
0
14
0
0
0
0
0
0
0
0
0
0
0
0
0
0
14
0
0
0
0
0
0
0
0
0
0
0
0
0
0
14
0
0
0
0
0
0
0
0
0
0
0
0
0
0
14
0
0
0
0
0
0
0
0
0
0
0
0
0
0
14
0
0
0
0
0
0
0
0
0
0
0
0
0
0
14
0
0
0
0
0
0
0
0
0
0
0
0
0
0
14
0
0
0
0
0
0
0
0
0
0
0
0
0
0
14
0
0
0
0
0
0
0
0
0
0
0
0
0
0
14
0
0
0
0
0
0
0
0
0
0
0
0
0
0
14
0
0
0
0
0
0
0
0
0
0
0
0
0
0
14
0
0
0
0
0
0
0
0
0
0
0
0
0
0
14
0
0
0
0
0
0
0
0
0
0
0
0
0
0
14
0
0
0
0
0
0
0
0
0
0
0
0
0
0
14
0
0
0
0
0
0
0
0
0
0
0
0
0
0
14
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
14
0
0
0
0
0
0
0
0
0
0
0
0
0
0
14
0
0
0
0
0
0
0
0
0
0
0
0
0
0
14
0
0
0
0
0
0
0
0
0
0
0
0
0
0
14
0
0
0
0
0
0
0
0
0
0
0
0
0
0
14
0
0
0
0
0
0
0
0
0
0
0
0
0
0
14
0
0
0
0
0
0
0
0
0
0
0
0
0
0
14
0
0
0
0
0
0
0
0
0
0
0
0
0
0
14
0
0
0
0
0
0
0
0
0
0
0
0
0
0
14
0
0
0
0
0
0
0
0
0
0
0
0
0
0
14
0
0
0
0
0
0
0
0
0
0
0
0
0
0
14
0
0
0
0
0
0
0
0
0
0
0
0
0
0
14
0
0
0
0
0
0
0
0
0
0
0
0
0
0
14
0
0
0
0
0
0
0
0
0
0
0
0
0
0
14
0
0
0
0
0
0
0
0
0
0
0
0
0
0
14
0
0
0
0
0
0
0
0
0
0
0
0
0
0
14
0
0
0
0
0
0
0
0
0
0
0
0
0
0
14
0
0
0
0
0
0
0
0
0
0
0
0
0
0
14
0
0
0
0
0
0
0
0
0
0
0
0
0
0
14
0
0
0
0
0
0
0
0
0
0
0
0
0
0
14
0
0
0
0
0
0
0
0
0
0
0
0
0
0
14
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
14
0
0
0
0
0
0
0
0
0
0
0
0
0
0
14
0
0
0
0
0
0
0
0
0
0
0
0
0
0
14
0
0
0
0
0
0
0
0
0
0
0
0
0
0
14
0
0
0
0
0
0
0
0
0
0
0
0
0
0
14
0
0
0
0
0
0
0
0
0
0
0
0
0
0
14
0
0
0
0
0
0
0
0
0
0
0
0
0
0
14
0
0
0
0
0
0
0
0
0
0
0
0
0
0
14
0
0
0
0
0
0
0
0
0
0
0
0
0
0
14
0
0
0
0
0
0
0
0
0
0
0
0
0
0
14
0
0
0
0
0
0
0
0
0
0
0
0
0
0
14
0
0
0
0
0
0
0
0
0
0
0
0
0
0
14
0
0
0
0
0
0
0
0
0
0
0
0
0
0
14
0
0
0
0
0
0
0
0
0
0
0
0
0
0
14
0
0
0
0
0
0
0
0
0
0
0
0
0
0
14
0
0
0
0
0
0
0
0
0
0
0
0
0
0
14
0
0
0
0
0
0
0
0
0
0
0
0
0
0
14
0
0
0
0
0
0
0
0
0
0
0
0
0
0
14
0
0
0
0
0
0
0
0
0
0
0
0
0
0
14
0
0
0
0
0
0
0
0
0
0
0
0
0
0
14
0
0
0
0
0
0
0
0
0
0
0
0
0
0
14
0
0
0
0
0
0
0
0
0
0
0
0
0
0
14
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
244.7
252.94
84.435
256.64
256.64
78.126
0
0
0
244.7
252.94
84.435
256.64
256.64
78.126
0
0
0
244.7
252.94
84.435
256.64
256.64
78.126
0
0
0
244.7
252.9
84.435
256.64
256.64
78.126
0
8
8
-300.3
-292
-122
-288.3
-288.3
-128.3
0
0
8
252.43
119.75
228.29
241.29
124.93
236.86
0
0
8
252.43
119.75
228.29
241.29
124.93
236.86
0
0
8
252.43
119.75
228.29
241.29
124.93
236.86
0
0
8
252.43
119.75
228.29
241.29
124.93
236.86
0
6
14
-156.3
-35.05
-180.4
-167.4
-29.87
-171.9
0
0
14
0
0
0
0
0
0
0
0
14
0
0
0
0
0
0
0
0
14
0
0
0
0
0
0
0
0
14
0
0
0
0
0
0
0
0
14
0
0
0
0
0
0
0
0
14
0
0
0
0
0
0
0
0
14
0
0
0
0
0
0
0
0
14
0
0
0
0
0
0
0
0
14
0
0
0
0
0
0
0
0
14
0
0
0
0
0
0
0
8
-276.5
-329
8
421.82
295.27
14
-276.5
-329
14
421.82
295.27
14
-276.5
-329
14
421.82
295.27
14
-276.5
-329
14
421.82
295.27
14
-276.5
-329
14
421.82
295.27
SPAN 5
Local X
X
M(e) all
M(e) odd
M(e) even
Beam
M(r) all
M(r) odd
M(r) even
70% max
70% min
Lower bound
Upper bound
Beam
L0
SPAN 6
Local X
X
M(e) all
M(e) odd
M(e) even
Beam
M(r) all
M(r) odd
M(r) even
70% max
70% min
Lower bound
Upper bound
Beam
L0
0
0
0
0
0
0
0
0
0
Local X
X
V(e) all
V(e) odd
V(e) even
V(r) all
V(r) odd
V(r) even
Beam
GRIDS
0
-276.5
-329
0
421.82
295.27
0
0
244.7
252.94
84.435
256.64
256.64
78.126
0
SPAN 2
14
14
-276.52 421.82
-328.97 295.27
0
8
252.43
119.75
228.29
241.29
124.93
236.86
0
SPAN 3
0
14
0
0
0
0
0
0
0
SPAN 4
SPAN 5
0
14
0
0
0
0
0
0
0
0
14
0
0
0
0
0
0
0
0
14
0
0
0
0
0
0
0
0
14
0
0
0
0
0
0
0
0
14
0
0
0
0
0
0
0
SPAN 6
0
14
0
0
0
0
0
0
0
0
14
0
0
0
0
0
0
0
0
14
0
0
0
0
0
0
0
0
14
0
0
0
0
0
0
0
0
14
0
0
0
0
0
0
0
0
14
0
0
0
0
0
0
0
0
14
0
0
0
0
0
0
0
0
14
0
0
0
0
0
0
0
0
14
0
0
0
0
0
0
0
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 'Spreadsheets for
concrete design to BS 8110 & EC2' available from British Cement Association, Telford Avenue,
Crowthorne, Berkshire RG45 6YS.
Status of spreadsheet
Public release version.
Revision history RCC41 Continuous Beams (A & D)
Date
Version
Action
First public release.
Includes b version comments
UCL comments incorporated
Size (kB)
1029
1028