REINFORCED CONCRETE

Project Spreadsheets to BS 8110 COUNCIL

Client Advisory Group Made by Date Sheet No
Location D&D: Main beam Grids C to H from grid 1 to 3 rmw 24-Oct-20 55
CONTINUOUS BEAM (Analysis & Design) to BS 8110:1997 Checked Revision Job No
Originated from RCC41.xls on CD © 1999 BCA for RCC chg - R68

LOCATION Supports from grid 1 to grid 3

MATERIALS COVERS (to all steel)

fcu 30 N/mm² h agg 25 mm Top cover 30 mm
fyl 460 N/mm² gs 1.05 Btm cover 30 mm
fyv 250 N/mm² gc 1.50 Side cover 30 mm

SPANS L (m) H (mm) bw (mm) hf (mm) Type bf (mm) LOADING PATTERN

SPAN 1 3.50 500 300 150 R 300 min max
SPAN 2 4.00 500 300 150 R 300 DEAD 1 1.4
SPAN 3 3.50 500 300 150 R 300 IMPOSED 0 1.6
SPAN 4 REBAR LAYERING
SPAN 5 Support steel
SPAN 6 in alt layer ? Y

SUPPORTS ABOVE (m) H (mm) B (mm) End Cond BELOW (m) H (mm) B (mm) End Cond
Support 1 3.00 300 300 F 3.50 300 300 P
Support 2 3.00 300 300 F 3.50 300 300 P
Support 3 3.00 300 300 F 3.50 300 300 P
Support 4
Support 5
Support 6
Support 7

LOADING UDLs (kN/m) PLs (kN) Position (m)

Dead Imposed Position Loaded Dead Imposed Position Loaded
Span 1 Load Load from left Length Span 4 Load Load from left Length
UDL 15.0 10.0 ~~~~~ ~~~~~ UDL ~~~~~ ~~~~~
PL 1 5.0 2.00 ~~~~~ PL 1 ~~~~~
PL 2 ~~~~~ PL 2 ~~~~~
Part UDL Part UDL
Span 2 Span 5
UDL 20.0 10.0 ~~~~~ ~~~~~ UDL ~~~~~ ~~~~~
PL 1 5.0 2.00 ~~~~~ PL 1 ~~~~~
PL 2 ~~~~~ PL 2 ~~~~~
Part UDL Part UDL
Span 3 Span 6
UDL 15.0 10.0 ~~~~~ ~~~~~ UDL ~~~~~ ~~~~~
PL 1 ~~~~~ PL 1 ~~~~~
PL 2 ~~~~~ PL 2 ~~~~~
Part UDL Part UDL

LOADING DIAGRAM

1 3
REACTIONS (kN)
SUPPORT 1 2 3 4
ALL SPANS LOADED 59.3 165.6 178.4 47.8
ODD SPANS LOADED 59.3 120.1 115.1 52.5
EVEN SPANS LOADED 14.4 127.8 132.4 14.4
Characteristic Dead 20.7 71.6 73.6 19.1
Characteristic Imposed 19.0 40.9 47.1 16.1
Project Spreadsheets to BS 8110 REINFORCED CONCRETE COUNCIL

Client Advisory Group Made by Date Page

Location D&D: Main beam Grids C to H, from grid 1 to 3 rmw 24-Oct-20 56
CONTINUOUS BEAM (Analysis & Design) to BS 8110:1997 Checked Revision Job No
Originated from RCC41.xls on CD © 1999 BCA for RCC chg - R68

BENDING MOMENT DIAGRAMS (kNm)

80 80

60 60

40 40

20 20

0 0

-20 -20

-40 -40

-60 -60
0 2 4 6 8 10 12 0 2 4 6 8 10 12

1 Elastic Moments 3 1 Redistributed Envelope 3

SUPPORT No 1 2 3 4
Elastic M 14.5 60.9 61.1 0.0 ~ ~ kNm/m
Redistributed M 11.6 42.6 61.1 0.0 ~ ~ kNm/m
ßb 0.800 0.700 1.000 1.000 ~ ~ ~
Redistribution 20.0% 30.0% 0.0%

SPAN No 1 2 3
Elastic M 34.92 44.24 37.30 ~ ~ ~
Redistributed M 35.94 48.74 37.30 ~ ~ ~
ßb 1.029 1.102 1.000 ~ ~ ~
SHEARS (kN)

150 150

100 100

50 50

0 0

-50 -50

-100 -100

-150 -150
0 2 4 6 8 10 12 0 2 4 6 8 10 12

1 Elastic Shears 3 1 Redistributed Shears 3

SPAN No 1 2 3
Elastic V 60.5 83.0 92.0 92.1 81.7 52.5
Redistributed V 59.3 78.2 89.7 96.6 81.7 52.5

Elastic V ~ ~ ~ ~ ~ ~

Redistributed V ~ ~ ~ ~ ~ ~

COLUMN MOMENTS
(kNm) 1 2 3 4
ALL SPANS Above 6.9 1.0 -1.0
LOADED Below 4.4 0.6 -0.6
ODD SPANS Above 8.8 -4.5 4.6
LOADED Below 5.7 -2.9 3.0
EVEN SPANS Above 0.5 6.3 -6.2
LOADED Below 0.3 4.0 -4.0
Project Spreadsheets to BS 8110 REINFORCED CONCRETE COUNCIL
Client Advisory Group Made by Date Page
Location D&D: Main beam Grids C to H, from grid 1 to 3 rmw 24-Oct-20 57
CONTINUOUS BEAM (Analysis & Design) to BS 8110:1997 Checked Revision Job No
Originated from RCC41.xls on CD © 1999 BCA for RCC chg - R68

SPAN 1 LEFT CENTRE RIGHT

ACTIONS M kNm 4.1 35.9 37.1
ßb 0.80 1.03 0.72
DESIGN d mm 440.0 442.0 410.0
As mm² 22 195 217
As' mm² 0 0 0
TOP STEEL Layer 1 2 T 12 2 T 16 2 T 32
Layer 2 0 0 0
As prov mm² 226 As' prov 402 As prov 1608
BTM STEEL Layer 1 5 T 12 2 T 32 2 T 25
Layer 2 0 0 0
As' prov mm² 565 As prov 1608 As' prov 982
DEFLECTION L/d 7.919 Allowed 56.774
SHEAR V kN 37.5 Link Ø 57.5
v N/mm² 0.284 12 0.467
vc N/mm² 0.296 Nominal 0.583
LINKS R12 @ 325 for 650 R12 @ 325 R12 @ 300 for 1200
legs No 2 2 2

CHECKS % As ok ok ok
Cover ok ok ok
min S ok ok ok
max S ok ok ok
Links ok ok ok
Main bars ok ok ok
max V ok ok
Deflection ok

SPAN 2 LEFT CENTRE RIGHT

ACTIONS M kNm 36.6 48.7 47.1
ßb 0.70 1.10 1.00
DESIGN d mm 434.0 452.0 440.0
As mm² 203 259 257
As' mm² 0 0 0
TOP STEEL Layer 1 2 T 16 2 T 12 3 T 12
Layer 2 0 0 0
As prov mm² 402 As' prov 226 As prov 339
BTM STEEL Layer 1 2 T 16 3 T 12 2 T 12
Layer 2 0 0 0
As' prov mm² 402 As prov 339 As' prov 226
DEFLECTION L/d 8.850 Allowed 50.630
SHEAR V kN 64.0 Link Ø 70.6
v N/mm² 0.492 12 0.535
vc N/mm² 0.360 Nominal 0.339
LINKS R12 @ 325 for 650 R12 @ 325 R12 @ 325 for 650
legs No 2 2 2

CHECKS % As ok ok ok
Cover ok ok ok
min S ok ok ok
max S ok ok ok
Links ok ok ok
Main bars ok ok ok
max V ok ok
Deflection ok
Project Spreadsheets to BS 8110 REINFORCED CONCRETE COUNCIL
Client Advisory Group Made by Date Page
Location D&D: Main beam Grids C to H, from grid 1 to 3 rmw 24-Oct-20 59
CONTINUOUS BEAM (Analysis & Design) to BS 8110:1997 Checked Revision Job No
Originated from RCC41.xls on CD © 1999 BCA for RCC chg - R68

APPROXIMATE WEIGHT of REINFORCEMENT

Location No Type Dia Length Unit wt Weight
TOP STEEL Support 1 2 T 12 1400 0.888 2.5
0 0 0 0 0.000 0.0
Span 1 2 T 16 3150 1.578 9.9
0 0 0 0 0.000 0.0
Support 2 2 T 32 2250 6.313 28.4
0 0 0 0 0.000 0.0
Span 2 2 T 12 2950 0.888 5.2
0 0 0 0 0.000 0.0
Support 3 3 T 12 2250 0.888 6.0
0 0 0 0 0.000 0.0
Span 3 2 T 12 2750 0.888 4.9
0 0 0 0 0.000 0.0
Support 4 2 T 12 1550 0.888 2.8
0 0 0 0 0.000 0.0
0 0 0 0 0 0.000 0.0
0 0 0 0 0.000 0.0
0 0 0 0 0 0.000 0.0
0 0 0 0 0.000 0.0
0 0 0 0 0 0.000 0.0
0 0 0 0 0.000 0.0
0 0 0 0 0 0.000 0.0
0 0 0 0 0.000 0.0
0 0 0 0 0 0.000 0.0
0 0 0 0 0.000 0.0
0 0 0 0 0 0.000 0.0
0 0 0 0 0.000 0.0
BOTTOM STEEL Support 1 5 T 12 875 0.888 3.9
0 0 0 0 0.000 0.0
Span 1 2 T 32 3150 6.313 39.8
0 0 0 0 0.000 0.0
Support 2 2 T 25 3150 3.853 24.3
0 0 0 0 0.000 0.0
Span 2 3 T 12 3650 0.888 9.7
0 0 0 0 0.000 0.0
Support 3 2 T 12 1325 0.888 2.4
0 0 0 0 0.000 0.0
Span 3 2 T 12 3300 0.888 5.9
0 0 0 0 0.000 0.0
Support 4 2 T 12 1050 0.888 1.9
0 0 0 0 0.000 0.0
0 0 0 0 0 0.000 0.0
0 0 0 0 0.000 0.0
0 0 0 0 0 0.000 0.0
0 0 0 0 0.000 0.0
0 0 0 0 0 0.000 0.0
0 0 0 0 0.000 0.0
0 0 0 0 0 0.000 0.0
0 0 0 0 0.000 0.0
0 0 0 0 0 0.000 0.0
0 0 0 0 0.000 0.0
0 0 0 0 0 0.000 0.0
0 0 0 0 0.000 0.0
LINKS Span 1 12 R 12 1425 0.888 15.2
0 0 0 0 0.000 0.0
Span 2 13 R 12 1425 0.888 16.4
0 0 0 0 0.000 0.0
Span 3 12 R 12 1425 0.888 15.2
0 0 0 0 0.000 0.0
0 0 0 0 0 0.000 0.0
0 0 0 0 0.000 0.0
0 0 0 0 0 0.000 0.0
0 0 0 0 0.000 0.0
0 0 0 0 0 0.000 0.0
0 0 0 0 0.000 0.0
SUMMARY spacers not included Total reinforcement in bay (kg) 194

Reinforcement density (kg/m³) 110.2

Project Spreadsheets to BS 8110
Location D&D: Main beam Grids C to H, from grid 1 to 3 ANALYSIS I
CONTINUOUS BEAM (Analysis & Design) to BS 8110:1997 Made by rmw Job No R68
Originated from RCC41.xls on CD © 1999 BCA for RCC Date 24-Oct-20

ANALYSIS
Min load 1.0 x dead load
Live load 0.4 x dead load + 1.6 x imposed load (Table 2.1)

Distribution Factors
SUPT 1 SUPT 2 SUPT 3
Up col Lo col R L Up col Lo col R L Up col Lo col R
Aw 150000 150000 150000 150000 150000
Af 0 0 0 0 0
X bar 250 250 250 250 250
I 675000000 675000000 3125000000 3125000000 675000000 675000000 3125000000 3125000000 675000000 675000000 3125000000
Stiffness 225000000 144642857.143 892857142.8571 892857142.8571 225000000 144642857.143 781250000 781250000 225000000 144642857.143 892857142.857143
Sum 1262500000 2E+09 2E+09
Factor 0.1782 0.1146 0.7072 0.4369 0.1101 0.0708 0.3823 0.3823 0.1101 0.0708 0.4369
SUPT 4 SUPT 5 SUPT 6
L Up col Lo col R L Up col Lo col R L Up col Lo col R
Aw 150000 0 0 0 0 0
Af 0 0 0 0 0 0
X bar 250 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
I 3125000000 0 0 #DIV/0! #DIV/0! 0 0 #DIV/0! #DIV/0! 0 0 #DIV/0!
Stiffness 892857142.8571 0 0 0 0 0 0 0 0 0 0 0
Sum 9E+08 0E+00 0E+00
Factor 1.0000 0.0000 0.0000 0.0000 1.0000 0.0000 0.0000 0.0000 1.0000 0.0000 0.0000 0.0000
SUPT 7
L Up col Lo col
Aw 0 Partial UDL factors
Af 0 1 2 3 4 5 6
X bar #DIV/0! a 0 0 0 #DIV/0! #DIV/0! #DIV/0!
I #DIV/0! 0 0 b 0 0 0 #DIV/0! #DIV/0! #DIV/0!
Stiffness 0 0 0
Sum 0E+00
Factor 0.0000 0.0000 0.0000

Fixed End Moments

SPAN 1 SPAN 2 SPAN 3 SPAN 4 SPAN 5 SPAN 6
Min load L R L R L R L R L R L R
Cant 91.88 160.00 91.88 0.00 0.00 0.00
UDL 15.31 15.31 26.67 26.67 15.31 15.31 0.00 0.00 0.00 0.00 0.00 0.00
PL 1 0.00 0.00 0.00 0.00 0.00 0.00 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
PL 2 0.00 0.00 0.00 0.00 0.00 0.00 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
part UDL 0.00 0.00 0.00 0.00 0.00 0.00 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
FEM 15.31 15.31 26.67 26.67 15.31 15.31 0.00 0.00 0.00 0.00 0.00 0.00
Live load
Cant 146.75 208.00 134.75 0.00 0.00 0.00
UDL 22.46 22.46 32.00 32.00 22.46 22.46 0.00 0.00 0.00 0.00 0.00 0.00
PL 1 2.94 3.92 4.00 4.00 0.00 0.00 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
PL 2 0.00 0.00 0.00 0.00 0.00 0.00 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
part UDL 0.00 0.00 0.00 0.00 0.00 0.00 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
FEM 25.40 26.38 36.00 36.00 22.46 22.46 0.00 0.00 0.00 0.00 0.00 0.00

Moment Distribution
HiCol SUPT 1 LoCol HiCol SUPT 2 LoCol HiCol SUPT 3 LoCol HiCol SUPT 4 LoCol HiCol SUPT 5 LoCol HiCol SUPT 6 LoCol HiCol SUPT 7 LoCol
Min load -15.31 15.31 -26.67 26.67 -15.31 15.31 0.00 0.00 0.00 0.00 0.00 0.00
2.73 10.83 1.75 1.25 4.96 4.34 0.80 -1.25 -4.34 -4.96 -0.80 0.00 -15.31 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
2.48 5.41 -2.17 2.17 -7.66 -2.48 0.00 0.00 0.00 0.00 0.00 0.00
-0.44 -1.75 -0.28 -0.36 -1.42 -1.24 -0.23 0.60 2.10 2.40 0.39 0.00 2.48 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
-0.71 -0.88 1.05 -0.62 1.24 1.20 0.00 0.00 0.00 0.00 0.00 0.00
0.13 0.50 0.08 -0.02 -0.07 -0.07 -0.01 -0.07 -0.24 -0.27 -0.04 0.00 -1.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.04 0.25 -0.12 -0.03 -0.60 -0.14 0.00 0.00 0.00 0.00 0.00 0.00
0.01 0.03 0.00 -0.01 -0.06 -0.05 -0.01 0.07 0.24 0.28 0.04 0.00 0.14 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
-0.03 0.01 0.12 -0.03 0.07 0.14 0.00 0.00 0.00 0.00 0.00 0.00
0.01 0.02 0.00 -0.01 -0.06 -0.05 -0.01 0.00 -0.02 -0.02 0.00 0.00 -0.14 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
-0.03 0.01 -0.01 -0.03 -0.07 -0.01 0.00 0.00 0.00 0.00 0.00 0.00
0.01 0.02 0.00 0.00 0.00 0.00 0.00 0.01 0.04 0.04 0.01 0.00 0.01 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
0.00 0.01 0.02 0.00 0.00 0.02 0.00 0.00 0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00 -0.01 -0.01 0.00 0.00 0.00 0.00 0.00 0.00 -0.02 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Sum 2.43 -3.99 1.56 0.84 23.47 -24.85 0.54 -0.64 25.91 -24.86 -0.41 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Project Spreadsheets to BS 8110
Location D&D: Main beam Grids C to H, from grid 1 to 3 ANALYSIS II
CONTINUOUS BEAM (Analysis & Design) to BS 8110:1997 Made by rmw Job No R68
Originated from RCC41.xls on CD © 1999 BCA for RCC Date 24-Oct-20

Live on -25.40 26.38 -22.46 22.46 0.00 0.00

Odd Spans 4.53 17.96 2.91 -2.90 -11.52 -10.08 -1.87 2.47 8.58 9.81 1.59 0.00 -22.46 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
-5.76 8.98 4.29 -5.04 -11.23 4.91 0.00 0.00 0.00 0.00 0.00 0.00
1.03 4.07 0.66 -1.46 -5.80 -5.07 -0.94 1.79 6.22 7.11 1.15 0.00 -4.91 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
-2.90 2.04 3.11 -2.54 -2.45 3.55 0.00 0.00 0.00 0.00 0.00 0.00
0.52 2.05 0.33 -0.57 -2.25 -1.97 -0.36 0.55 1.91 2.18 0.35 0.00 -3.55 0.00 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.12 1.03 0.95 -0.98 -1.78 1.09 0.00 0.00 0.00 0.00 0.00 0.00
0.20 0.80 0.13 -0.22 -0.86 -0.76 -0.14 0.30 1.06 1.21 0.20 0.00 -1.09 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
-0.43 0.40 0.53 -0.38 -0.54 0.60 0.00 0.00 0.00 0.00 0.00 0.00
0.08 0.31 0.05 -0.10 -0.40 -0.35 -0.07 0.10 0.35 0.40 0.07 0.00 -0.60 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
-0.20 0.15 0.18 -0.18 -0.30 0.20 0.00 0.00 0.00 0.00 0.00 0.00
0.04 0.14 0.02 -0.04 -0.14 -0.13 -0.02 0.05 0.18 0.21 0.03 0.00 -0.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.07 0.07 0.09 -0.06 -0.10 0.10 0.00 0.00 0.00 0.00 0.00 0.00
0.01 0.05 0.01 -0.02 -0.07 -0.06 -0.01 0.02 0.06 0.07 0.01 0.00 -0.10 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Sum 6.40 -10.51 4.11 -5.31 17.99 -9.27 -3.41 5.29 9.19 -17.88 3.40 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Live on -36 36 0 0 0 0
Even Spans 0 0 0 3.9633027523 15.727391874 13.76146789 2.547837484 -3.963302752 -13.76146789 -15.727391874181 -2.54783748 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
7.863695937 0 -6.88073394 6.880733945 0 -7.86369593709043 0 0 0 0 0 0
-1.401450761 -5.56131254 -0.90093263 0.7575119939 3.005999976 2.630249979 0.486971996 -0.757511994 -2.630249979 -3.005999975952 -0.486972 0 7.86369593709043 0 0 0 0 0 0 0 0 0 0 0 0 0
1.502999988 -2.780656272 -1.31512499 1.3151249895 3.93184796854522 -1.502999987976 0 0 0 0 0 0
-0.267861384 -1.062942 -0.1721966 0.4509116985 1.7893321369 1.56566562 0.289871806 -0.577648399 -2.005723608 -2.2922555517799 -0.3713454 0 1.502999987976 0 0 0 0 0 0 0 0 0 0 0 0 0
0.894666068 -0.531471 -1.0028618 0.7828328099 0.751499993988 -1.14612777588996 0 0 0 0 0 0
-0.159445438 -0.63271999 -0.10250064 0.1689173729 0.6703070353 0.586518656 0.10858974 -0.168917373 -0.586518656 -0.6703070353409 -0.10858974 0 1.14612777588996 0 0 0 0 0 0 0 0 0 0 0 0 0
0.335153518 -0.316359996 -0.29325933 0.293259328 0.57306388794498 -0.33515351767043 0 0 0 0 0 0
-0.05973033 -0.23702512 -0.03839807 0.067114054 0.2663256111 0.23303491 0.043144749 -0.095375033 -0.331163309 -0.3784723529518 -0.06131252 0 0.33515351767043 0 0 0 0 0 0 0 0 0 0 0 0 0
0.133162806 -0.118512559 -0.16558165 0.1165174549 0.16757675883522 -0.18923617647589 0 0 0 0 0 0
-0.023731985 -0.09417454 -0.01525628 0.0312764272 0.1241128063 0.108598706 0.020106275 -0.031276427 -0.108598706 -0.1241128063372 -0.02010627 0 0.18923617647589 0 0 0 0 0 0 0 0 0 0 0 0 0
0.062056403 -0.047087272 -0.05429935 0.0542993528 0.09461808823794 -0.06205640316859 0 0 0 0 0 0
-0.011059557 -0.04388713 -0.00710972 0.0111618303 0.0442929772 0.038756355 0.007175462 -0.016394581 -0.056925627 -0.0650578597687 -0.01053937 0 0.06205640316859 0 0 0 0 0 0 0 0 0 0 0 0 0
Sum -1.92 3.16 -1.24 5.45 17.83 -26.79 3.50 -5.61 25.96 -16.74 -3.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

Elastic Support Moments (3.2.1.2.2)

Support 1 2 3 4 5 6 7
Left Right Left Right Left Right Left Right Left Right
All spans 11.34 59.29 60.91 61.06 59.48 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Odd Spans 14.50 41.46 34.13 35.10 42.74 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Even Spans 0.83 41.31 51.64 51.87 41.61 0.00 0.00 0.00 0.00 0.00 0.00 0.00

Redistribution (3.2.2.1) method 1

ßb - 0.8 0.7 1 1 1 1 1
ßb + 1.2 1.3 1 1 1 1 1
Max M 11.60 42.64 61.06 0.00 0.00 0.00 0.00
Dead only 3.99 23.47 24.85 25.91 24.86 0.00 0.00 0.00 0.00 0.00 0.00 0.00
All spans 11.60 42.64 42.64 61.06 59.48 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Odd Spans 11.60 42.64 42.64 35.10 42.74 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Even Spans 1.00 42.64 42.64 51.87 41.61 0.00 0.00 0.00 0.00 0.00 0.00 0.00

Total Ultimate Loads

Span 1 2 3
UDL PL1 PL2 ptUD UDL PL1 PL2 ptUD UDL PL1 PL2 ptUD
Dead only 52.5 0 0 0 80 0 0 0 52.5 0 0 0
All spans 129.5 8 0 0 176 8 0 0 129.5 0 0 0
Odd Spans 129.5 8 0 0 80 0 0 0 129.5 0 0 0
Even Spans 52.5 0 0 0 176 8 0 0 52.5 0 0 0
Span 4 5 6
Dead only 0 0 0 0 0 0 0 0 0 0 0 0
All spans 0 0 0 0 0 0 0 0 0 0 0 0
Odd Spans 0 0 0 0 0 0 0 0 0 0 0 0
Even Spans 0 0 0 0 0 0 0 0 0 0 0 0

Elastic Shears
Span 1 2 3
All spans 54.48 83.02 91.96 92.04 81.74 47.76
Odd Spans 60.48 77.02 39.76 40.24 76.96 52.54
Even Spans 14.69 37.81 91.94 92.06 38.14 14.36
Span 4 5 6
All spans 0.00 0.00 0.00 0.00 0.00 0.00
Odd Spans 0.00 0.00 0.00 0.00 0.00 0.00
Even Spans 0.00 0.00 0.00 0.00 0.00 0.00
Project Spreadsheets to BS 8110
Location D&D: Main beam Grids C to H, from grid 1 to 3 ANALYSIS III
CONTINUOUS BEAM (Analysis & Design) to BS 8110:1997 Made by rmw Job No R68
Originated from RCC41.xls on CD © 1999 BCA for RCC Date 24-Oct-20

Redistributed Shears
Span 1 2 3
Dead only 20.68 31.82 39.74 40.26 33.35 19.15
All spans 59.31 78.19 87.39 96.61 81.74 47.76
Odd Spans 59.31 78.19 41.89 38.11 76.96 52.54
Even Spans 14.35 38.15 89.69 94.31 38.14 14.36
Span 4 5 6
Dead only 0.00 0.00 0.00 0.00 0.00 0.00
All spans 0.00 0.00 0.00 0.00 0.00 0.00
Odd Spans 0.00 0.00 0.00 0.00 0.00 0.00
Even Spans 0.00 0.00 0.00 0.00 0.00 0.00

Imposed Reactions
Support 1 2 3 4 5 6 7
All spans 18.97 40.88 47.05 13.09 0.00 0.00 0.00
Odd Spans 18.97 22.37 17.57 16.08 0.00 0.00 0.00
Even Spans -3.96 25.25 26.70 -2.99 0.00 0.00 0.00

SPAN MOMENTS
SPAN 1 Left < > PL1 < > PL2 < > Right Loadings 0 0
Elastic V All 54.48 100 -19.52 0 -27.52 0 83.02 37 8 0 0
Odd 60.48 100 -13.52 0 -21.52 0 77.02 37 8 0 0
Even 14.69 100 -15.31 0 -15.31 0 37.81 15 0 0 0
Redist V All 59.31 100 -14.69 0 -22.69 0 78.19 3.5
Odd 59.31 100 -14.69 0 -22.69 0 78.19
Even 14.35 100 -15.65 0 -15.65 0 38.15
Elastic X- All 1.472 2.000 0.000 0.000 1.256
Odd 1.634 2.000 0.000 0.000 1.418
Even 0.979 2.000 0.000 0.000 0.979
Redist X- All 1.603 2.000 0.000 0.000 1.387
Odd 1.603 2.000 0.000 0.000 1.387 (3.2.2.1b)
Even 0.957 2.000 0.000 0.000 0.957 Max
Elastic M All 11.34 28.76 23.61 -11.34 -11.34 27.90 59.29 28.76
Odd 14.50 34.92 32.45 -14.50 -14.50 34.06 41.46 34.92
Even 0.83 6.36 -1.46 -0.83 -0.83 6.36 41.31 6.36 ßb
Redist M All 11.60 35.94 33.02 -11.60 -11.60 35.07 42.64 35.94 1.249
Odd 11.60 35.94 33.02 -11.60 -11.60 35.07 42.64 35.94 1.029
Even 1.00 5.87 -2.29 -1.00 -1.00 5.87 42.64 5.87 0.923

SPAN 2 Left < > PL1 < > PL2 < > Right Loadings 0 0
Elastic V All 91.96 0 3.96 0 -4.04 0 92.04 44 8 0 0
Odd 39.76 100 -0.24 0 -0.24 0 40.24 20 0 0 0
Even 91.94 0 3.94 0 -4.06 0 92.06 44 8 0 0
Redist V All 87.39 100 -0.61 0 -8.61 0 96.61 4
Odd 41.89 0 1.89 0 1.89 100 38.11
Even 89.69 0 1.69 0 -6.31 0 94.31
Elastic X- All 0.000 2.000 0.000 0.000 1.908
Odd 1.988 2.000 0.000 0.000 1.988
Even 0.000 2.000 0.000 0.000 1.908
Redist X- All 0.000 2.000 0.000 0.000 1.804
Odd 2.094 2.000 0.000 0.000 2.094 (3.2.2.1b)
Even 0.000 2.000 0.000 0.000 1.857 Max
Elastic M All 60.91 -60.91 35.01 -60.91 -60.91 34.46 61.06 35.01
Odd 34.13 5.39 5.39 -34.13 -34.13 5.39 35.10 5.39
Even 51.64 -51.64 44.24 -51.64 -51.64 43.69 51.87 44.24 ßb
Redist M All 42.64 -42.64 44.15 -42.64 -42.64 43.43 61.06 44.15 1.261
Odd 42.64 1.22 1.13 -42.64 -42.64 1.22 35.10 3.77 0.700
Even 42.64 -42.64 48.74 -42.64 -42.64 48.05 51.87 48.74 1.102

SPAN 3 Left < > PL1 < > PL2 < > Right Loadings 0 0
Elastic V All 81.74 0 81.74 0 81.74 100 47.76 37 0 0 0
Odd 76.96 0 76.96 0 76.96 100 52.54 37 0 0 0
Even 38.14 0 38.14 0 38.14 100 14.36 15 0 0 0
Redist V All 81.74 0 81.74 0 81.74 100 47.76 3.5
Odd 76.96 0 76.96 0 76.96 100 52.54
Even 38.14 0 38.14 0 38.14 100 14.36
Elastic X- All 0.000 0.000 0.000 0.000 2.209
Odd 0.000 0.000 0.000 0.000 2.080
Even 0.000 0.000 0.000 0.000 2.543
Redist X- All 0.000 0.000 0.000 0.000 2.209
Odd 0.000 0.000 0.000 0.000 2.080 (3.2.2.1b)
Even 0.000 0.000 0.000 0.000 2.543 Max
Elastic M All 59.48 -59.48 -59.48 -59.48 -59.48 30.82 0.00 30.82
Odd 42.74 -42.74 -42.74 -42.74 -42.74 37.30 0.00 37.30
Even 41.61 -41.61 -41.61 -41.61 -41.61 6.88 0.00 6.88 ßb
Redist M All 59.48 -59.48 -59.48 -59.48 -59.48 30.82 0.00 30.82 1.000
Odd 42.74 -42.74 -42.74 -42.74 -42.74 37.30 0.00 37.30 1.000
Even 41.61 -41.61 -41.61 -41.61 -41.61 6.88 0.00 6.88 1.000

Project Spreadsheets to BS 8110

Location D&D: Main beam Grids C to H, from grid 1 to 3 ANALYSIS IV
 CONTINUOUS BEAM (Analysis & Design) to BS 8110:1997 Made by rmw Job No R68
Originated from RCC41.xls on CD © 1999 BCA for RCC Date 24-Oct-20

SPAN 4 Left < > PL1 < > PL2 < > Right Loadings 0 0
Elastic V All 0.00 100 0.00 100 0.00 100 0.00 0 0 0 0
Odd 0.00 100 0.00 100 0.00 100 0.00 0 0 0 0
Even 0.00 100 0.00 100 0.00 100 0.00 0 0 0 0
Redist V All 0.00 100 0.00 100 0.00 100 0.00 0
Odd 0.00 100 0.00 100 0.00 100 0.00
Even 0.00 100 0.00 100 0.00 100 0.00
Elastic X- All 0.000 0.000 0.000 0.000 0.000
Odd 0.000 0.000 0.000 0.000 0.000
Even 0.000 0.000 0.000 0.000 0.000
Redist X- All 0.000 0.000 0.000 0.000 0.000
Odd 0.000 0.000 0.000 0.000 0.000 (3.2.2.1b)
Even 0.000 0.000 0.000 0.000 0.000 Max
Elastic M All 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Odd 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Even 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 ßb
Redist M All 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.000
Odd 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.000
Even 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.000

SPAN 5 Left < > PL1 < > PL2 < > Right Loadings 0 0
Elastic V All 0.00 100 0.00 100 0.00 100 0.00 0 0 0 0
Odd 0.00 100 0.00 100 0.00 100 0.00 0 0 0 0
Even 0.00 100 0.00 100 0.00 100 0.00 0 0 0 0
Redist V All 0.00 100 0.00 100 0.00 100 0.00 0
Odd 0.00 100 0.00 100 0.00 100 0.00
Even 0.00 100 0.00 100 0.00 100 0.00
Elastic X- All 0.000 0.000 0.000 0.000 0.000
Odd 0.000 0.000 0.000 0.000 0.000
Even 0.000 0.000 0.000 0.000 0.000
Redist X- All 0.000 0.000 0.000 0.000 0.000
Odd 0.000 0.000 0.000 0.000 0.000 (3.2.2.1b)
Even 0.000 0.000 0.000 0.000 0.000 Max
Elastic M All 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Odd 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Even 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 ßb
Redist M All 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.000
Odd 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.000
Even 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.000

SPAN 6 Left < > PL1 < > PL2 < > Right Loadings 0 0
Elastic V All 0.00 100 0.00 100 0.00 100 0.00 0 0 0 0
Odd 0.00 100 0.00 100 0.00 100 0.00 0 0 0 0
Even 0.00 100 0.00 100 0.00 100 0.00 0 0 0 0
Redist V All 0.00 100 0.00 100 0.00 100 0.00 0
Odd 0.00 100 0.00 100 0.00 100 0.00
Even 0.00 100 0.00 100 0.00 100 0.00
Elastic X- All 0.000 0.000 0.000 0.000 0.000
Odd 0.000 0.000 0.000 0.000 0.000
Even 0.000 0.000 0.000 0.000 0.000
Redist X- All 0.000 0.000 0.000 0.000 0.000
Odd 0.000 0.000 0.000 0.000 0.000 (3.2.2.1b)
Even 0.000 0.000 0.000 0.000 0.000 Max
Elastic M All 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Odd 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Even 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 ßb
Redist M All 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.000
Odd 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.000
Even 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.000
 Project & location Spreadsheets to BS 8110 : D&D: Main beam Grids C to H : from grid 1 to 3 SPAN 1
CONTINUOUS BEAM (Analysis & Design) to BS 8110:1997 Originated from RCC41.xls on CD © 1999 BCA for RCC

Span 3.50 m h 500 Top cover 42 mm to main steel Job No R68

R beam bw 300 Btm cover 42 mm to main steel by rmw
hf 150 Side cover 42 mm to main steel Date 24-Oct-20

MAIN STEEL LEFT .25L SPAN RIGHT BS8110 Ref

M CL kNm 11.6 42.6
M face kNm 4.1 15.0 35.9 37.1
ßb 0.800 0.719118882840011 1.029 0.719
d mm 440.0 450.0 442.0 410.0
bf mm 300.0 300.0 300.0 300.0 3.4.1.5
K' 0.132 0.110 0.156 0.110 Fig 3.3
Web Mres kNm 230.0 200.4 273.9 166.4 Fig 3.3
Flange Mres kNm ~~~ ~~~ 221.3 ~~~ Fig 3.3
K 0.002 0.008 0.020 0.025 3.4.4.4
z mm 418.0 427.5 419.9 389.5 3.4.4.4
x mm 48.9 50.0 49.1 45.6 3.4.4.4
d' mm 80.0 58.0 50.0 86.5
net fsc N/mm² 0.0 0.0 0.0 0.0 Fig 3.3
Excess M kNm 0.0 0.0 0.0 0.0
As' req mm² 0 0 0 0
fst N/mm² 438.1 438.1 438.1 438.1 Fig 3.3
As req mm² 22 80 195 217
bw/b ~~~ ~~~ 1.0 ~~~
Min % % 0.13% 0.13% 0.13% 0.13% Table 3.25
Min As mm² 195 195 195 195
DEFLECTION
fs N/mm² 37.9 36.2 57.6 Eqn 8
Base ratio 26.0 100.0 3.4.6.3/4
Tens Mod 2.0 2.0 Table 3.10
Comp Mod 1.1 1.2 Table 3.11
Perm L/d 56.8 242.0 3.4.6.3
Actual L/d ok 7.9 ok 0.0 3.4.5.1
TENSION STEEL
As mm² 195 195 217
Ø1 mm ok 12 ok 32 ok 32
Ø2 mm 0 0 0
Max No/layer 5 3 3
No 1 2 2 2
= mm² 226 1608 1608
No 2 ok 0 ok 0 ok 0
As prov mm² 226 1608 1608
=% % ok 0.171 ok 1.213 ok 1.308
Clear dist mm 192.0 152.0 152.0 between bars
Min S mm ok 30.0 ok 32.0 ok 32.0 3.12.11.1
Max S mm ok 300.0 ok 300.0 ok 300.0 Table 3.28
COMPRESSION STEEL
Required mm² 483 195 483 Table 3.25
Ø1 mm ok 12 ok 16 ok 25
Ø2 mm 0 0 0
Max No/layer 5 4 3
No 1 5 2 2
= 565 402 982
No 2 ok 0 ok 0 ok 0
As' prov mm² 565 402 982
=% % ok 0.428 ok 0.303 ok 0.798
Clear dist mm 39.0 184.0 166.0 between bars
Min S mm ok 30.0 ok 30.0 ok 30.0 3.12.11.1
SHEAR
V at cl kN 59.3 78.2
V at d kN 37.5 57.5 3.4.5.10

v N/mm² 0.284 0.467 Eqn 3

vc N/mm² 0.296 Nominal 0.583 Table 3.8
(v-vc)bv N/mm 120.0 120.0 120.0 Table 3.7
Link Ø mm ok 12 ok 12 ok 12 3.12.7.1
Legs ok 2 ok 2 ok 2
@ mm 330 332 308 3.12.7.1
Adjust to mm 325 325 300
for (UDL only) mm 0 ~~~ 0 from cl
for (with PL) mm 2000 ~~~ 1500 -=-
Adjust to mm 650 ~~~ 1200 from face
As Dist mm ok 0.0 ok 0.0 ok 0.0 3.4.5.5
As' Dist mm ok 90.0 ok 0.0 ok 0.0 3.12.7.2
 Project & location Spreadsheets to BS 8110 : D&D: Main beam Grids C to H : from grid 1 to 3 SPAN 2
CONTINUOUS BEAM (Analysis & Design) to BS 8110:1997 Originated from RCC41.xls on CD © 1999 BCA for RCC

Span 4.000 m h 500 Top cover 42 mm to main steel Job No R68

R beam bw 300 Btm cover 42 mm to main steel by rmw
hf 150 Side cover 42 mm to main steel Date 24-Oct-20

MAIN STEEL LEFT .25L SPAN RIGHT BS8110 Ref

M CL kNm 42.6 61.1
M face kNm 36.6 10.8 48.7 47.1
ßb 0.700 0.700 1.102 1.000
d mm 434.0 452.0 452.0 440.0
bf mm 300.0 300.0 300.0 300.0 3.4.1.5
K' 0.104 0.104 0.156 0.156 Fig 3.3
Web Mres kNm 177.0 192.0 286.4 271.4 Fig 3.3
Flange Mres kNm ~~~ ~~~ 227.3 ~~~ Fig 3.3
K 0.022 0.006 0.027 0.027 3.4.4.4
z mm 412.3 429.4 429.4 418.0 3.4.4.4
x mm 48.2 50.2 50.2 48.9 3.4.4.4
d' mm 62.0 48.0 48.0 60.0
net fsc N/mm² 0.0 31.0 31.0 0.0 Fig 3.3
Excess M kNm 0.0 0.0 0.0 0.0
As' req mm² 0 0 0 0
fst N/mm² 438.1 438.1 438.1 438.1 Fig 3.3
As req mm² 203 57 259 257
bw/b ~~~ ~~~ 1.0 ~~~
Min % % 0.13% 0.13% 0.13% 0.13% Table 3.25
Min As mm² 195 195 195 195
DEFLECTION
fs N/mm² 220.6 212.6 232.3 Eqn 8
Base ratio 100.0 26.0 3.4.6.3/4
Tens Mod 1.9 1.8 Table 3.10
Comp Mod 1.1 1.1 Table 3.11
Perm L/d 211.1 50.6 3.4.6.3
Actual L/d 0.0 ok 8.8 ok 3.4.5.1
TENSION STEEL
As mm² 203 259 257
Ø1 mm ok 16 ok 12 ok 12
Ø2 mm 0 0 0
Max No/layer 4 5 5
No 1 2 3 3
= mm² 402 339 339
No 2 ok 0 ok 0 ok 0
As prov mm² 402 339 339
=% % ok 0.309 ok 0.250 ok 0.257
Clear dist mm 184.0 90.0 90.0 between bars
Min S mm ok 30.0 ok 30.0 ok 30.0 3.12.11.1
Max S mm ok 213.0 ok 221.1 ok 202.3 Table 3.28
COMPRESSION STEEL
Required mm² 102 195 102 Table 3.25
Ø1 mm ok 16 ok 12 ok 12
Ø2 mm 0 0 0
Max No/layer 4 5 5
No 1 2 2 2
= 402 226 226
No 2 ok 0 ok 0 ok 0
As' prov mm² 402 226 226
=% % ok 0.309 ok 0.167 ok 0.171
Clear dist mm 184.0 192.0 192.0 between bars
Min S mm ok 30.0 ok 30.0 ok 30.0 3.12.11.1
SHEAR
V at cl kN 89.7 96.6
V at d kN 64.0 70.6 3.4.5.10

v N/mm² 0.492 0.535 Eqn 3

vc N/mm² 0.360 Nominal 0.339 Table 3.8
(v-vc)bv N/mm 120.0 120.0 120.0 Table 3.7
Link Ø mm ok 12 ok 12 ok 12 3.12.7.1
Legs ok 2 ok 2 ok 2
@ mm 326 339 330 3.12.7.1
Adjust to mm 325 325 325
for (UDL only) mm 0 ~~~ 0 from cl
for (with PL) mm 2000 ~~~ 2000 -=-
Adjust to mm 650 ~~~ 650 from face
As Dist mm ok 0.0 ok 102.0 ok 102.0 3.4.5.5
As' Dist mm ok 0.0 ok 0.0 ok 0.0 3.12.7.2
 Project & location Spreadsheets to BS 8110 : D&D: Main beam Grids C to H : from grid 1 to 3 SPAN 3
CONTINUOUS BEAM (Analysis & Design) to BS 8110:1997 Originated from RCC41.xls on CD © 1999 BCA for RCC

Span 3.50 m h 500 Top cover 42 mm to main steel Job No R68

R beam bw 300 Btm cover 42 mm to main steel by rmw
hf 150 Side cover 42 mm to main steel Date 24-Oct-20

MAIN STEEL LEFT .25L SPAN RIGHT BS8110 Ref

M CL kNm 59.5 0.0
M face kNm 47.6 14.0 37.3 0.0
ßb 1.000 1 1.000 1.000
d mm 440.0 452.0 452.0 440.0
bf mm 300.0 300.0 300.0 300.0 3.4.1.5
K' 0.156 0.156 0.156 0.156 Fig 3.3
Web Mres kNm 271.4 286.4 286.4 271.4 Fig 3.3
Flange Mres kNm ~~~ ~~~ 227.3 ~~~ Fig 3.3
K 0.027 0.008 0.020 0.000 3.4.4.4
z mm 418.0 429.4 429.4 418.0 3.4.4.4
x mm 48.9 50.2 50.2 48.9 3.4.4.4
d' mm 60.0 48.0 48.0 60.0
net fsc N/mm² 0.0 31.0 31.0 0.0 Fig 3.3
Excess M kNm 0.0 0.0 0.0 0.0
As' req mm² 0 0 0 0
fst N/mm² 438.1 438.1 438.1 438.1 Fig 3.3
As req mm² 260 74 198 0
bw/b ~~~ ~~~ 1.0 ~~~
Min % % 0.13% 0.13% 0.13% 0.13% Table 3.25
Min As mm² 195 195 195 195
DEFLECTION
fs N/mm² 235.1 268.8 0.0 Eqn 8
Base ratio 100.0 26.0 3.4.6.3/4
Tens Mod 1.7 1.7 Table 3.10
Comp Mod 1.1 1.1 Table 3.11
Perm L/d 181.5 46.5 3.4.6.3
Actual L/d 0.0 ok 7.7 ok 3.4.5.1
TENSION STEEL
As mm² 260 198 195
Ø1 mm ok 12 ok 12 ok 12
Ø2 mm 0 0 0
Max No/layer 5 5 5
No 1 3 2 2
= mm² 339 226 226
No 2 ok 0 ok 0 ok 0
As prov mm² 339 226 226
=% % ok 0.257 ok 0.167 ok 0.171
Clear dist mm 90.0 192.0 192.0 between bars
Min S mm ok 30.0 ok 30.0 ok 30.0 3.12.11.1
Max S mm ok 199.9 !!! 174.8 ok 300.0 Table 3.28
COMPRESSION STEEL
Required mm² 68 195 113 Table 3.25
Ø1 mm ok 12 ok 12 ok 12
Ø2 mm 0 0 0
Max No/layer 5 5 5
No 1 2 2 2
= 226 226 226
No 2 ok 0 ok 0 ok 0
As' prov mm² 226 226 226
=% % ok 0.171 ok 0.167 ok 0.171
Clear dist mm 192.0 192.0 192.0 between bars
Min S mm ok 30.0 ok 30.0 ok 30.0 3.12.11.1
SHEAR
V at cl kN 81.7 52.5
V at d kN 59.9 36.3 3.4.5.10

v N/mm² 0.454 0.275 Eqn 3

vc N/mm² 0.339 Nominal 0.296 Table 3.8
(v-vc)bv N/mm 120.0 120.0 120.0 Table 3.7
Link Ø mm ok 12 ok 12 ok 12 3.12.7.1
Legs ok 2 ok 2 ok 2
@ mm 330 339 330 3.12.7.1
Adjust to mm 325 325 325
for (UDL only) mm 0 ~~~ 0 from cl
for (with PL) mm 0 ~~~ #N/A -=-
Adjust to mm 650 ~~~ 650 from face
As Dist mm ok 102.0 ok 0.0 ok 0.0 3.4.5.5
As' Dist mm ok 0.0 ok 0.0 ok 0.0 3.12.7.2
 Project & location Spreadsheets to BS 8110 : D&D: Main beam Grids C to H : from grid 1 to 3 SPAN 4
CONTINUOUS BEAM (Analysis & Design) to BS 8110:1997 Originated from RCC41.xls on CD © 1999 BCA for RCC

Span 0.000 m h0 Top cover 40 mm to main steel Job No R68

0 beam bw 0 Btm cover 40 mm to main steel by rmw
hf 0 Side cover 40 mm to main steel Date 24-Oct-20
SPAN 4 IS NON-EXISTANT!
MAIN STEEL LEFT .25L SPAN RIGHT BS8110 Ref
M CL kNm 0.0 0.0
M face kNm 0.0 0.0 0.0 0.0
ßb 1.000 1 ~ 1.000
d mm -58.0 -48.0 -48.0 -64.0
bf mm 0.0 0.0 0.0 0.0 3.4.1.5
K' 0.156 0.156 0.156 0.156 Fig 3.3
Web Mres kNm 0.0 0.0 0.0 0.0 Fig 3.3
Flange Mres kNm ~~~ ~~~ 0.0 ~~~ Fig 3.3
K #DIV/0! #DIV/0! #DIV/0! #DIV/0! 3.4.4.4
z mm #DIV/0! #DIV/0! #DIV/0! #DIV/0! 3.4.4.4
x mm #DIV/0! #DIV/0! #DIV/0! #DIV/0! 3.4.4.4
d' mm 62.0 48.0 48.0 64.0
net fsc N/mm² #DIV/0! #DIV/0! #DIV/0! #DIV/0! Fig 3.3
Excess M kNm 0.0 0.0 0.0 0.0
As' req mm² #DIV/0! #DIV/0! #DIV/0! #DIV/0!
fst N/mm² #DIV/0! #DIV/0! #DIV/0! #DIV/0! Fig 3.3
As req mm² #DIV/0! #DIV/0! #DIV/0! #DIV/0!
bw/b ~~~ ~~~ #DIV/0! ~~~
Min % % 0.26% 0.00% #DIV/0! 0.26% Table 3.25
Min As mm² 0 0 #DIV/0! 0
DEFLECTION
fs N/mm² #DIV/0! #DIV/0! #DIV/0! Eqn 8
Base ratio 100.0 #DIV/0! 3.4.6.3/4
Tens Mod #DIV/0! #DIV/0! Table 3.10
Comp Mod #DIV/0! #DIV/0! Table 3.11
Perm L/d #DIV/0! #DIV/0! 3.4.6.3
Actual L/d 0.0 #DIV/0! 0.0 #DIV/0! 3.4.5.1
TENSION STEEL
As mm² #DIV/0! #DIV/0! #DIV/0!
Ø1 mm ok 12 ok 16 ok 16
Ø2 mm 0 0 0
Max No/layer -2 -2 -2
No 1 #DIV/0! #DIV/0! #DIV/0!
= mm² #DIV/0! #DIV/0! #DIV/0!
No 2 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
As prov mm² #DIV/0! #DIV/0! #DIV/0!
=% % #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
Clear dist mm #DIV/0! #DIV/0! #DIV/0! between bars
Min S mm #DIV/0! 30.0 #DIV/0! 30.0 #DIV/0! 30.0 3.12.11.1
Max S mm #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! Table 3.28
COMPRESSION STEEL
Required mm² #DIV/0! #DIV/0! #DIV/0! Table 3.25
Ø1 mm ok 12 ok 16 ok 16
Ø2 mm 0 0 0
Max No/layer -2 -2 -2
No 1 #DIV/0! #DIV/0! #DIV/0!
= #DIV/0! #DIV/0! #DIV/0!
No 2 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
As' prov mm² #DIV/0! #DIV/0! #DIV/0!
=% % #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
Clear dist mm #DIV/0! #DIV/0! #DIV/0! between bars
Min S mm #DIV/0! 30.0 #DIV/0! 30.0 #DIV/0! 30.0 3.12.11.1
SHEAR
V at cl kN ~ ~
V at d kN #VALUE! #VALUE! 3.4.5.10

v N/mm² #VALUE! #VALUE! Eqn 3

vc N/mm² #DIV/0! Nominal #DIV/0! Table 3.8
(v-vc)bv N/mm #VALUE! 0.0 #VALUE! Table 3.7
Link Ø mm #DIV/0! 10 #DIV/0! 10 #DIV/0! 10 3.12.7.1
Legs #DIV/0! 2 #DIV/0! 2 #DIV/0! 2
@ mm #VALUE! #DIV/0! #VALUE! 3.12.7.1
Adjust to mm #VALUE! #DIV/0! #VALUE!
for (UDL only) mm #DIV/0! ~~~ #DIV/0! from cl
for (with PL) mm #VALUE! ~~~ #N/A -=-
Adjust to mm #DIV/0! ~~~ #DIV/0! from face
As Dist mm #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! 3.4.5.5
As' Dist mm #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! 3.12.7.2
 Project & location Spreadsheets to BS 8110 : D&D: Main beam Grids C to H : from grid 1 to 3 SPAN 5
CONTINUOUS BEAM (Analysis & Design) to BS 8110:1997 Originated from RCC41.xls on CD © 1999 BCA for RCC

Span 0.00 m h0 Top cover 40 mm to main steel Job No R68

0 beam bw 0 Btm cover 40 mm to main steel by rmw
hf 0 Side cover 40 mm to main steel Date 24-Oct-20
SPAN 5 IS NON-EXISTANT!
MAIN STEEL LEFT .25L SPAN RIGHT BS8110 Ref
M CL kNm 0.0 0.0
M face kNm 0.0 0.0 0.0 0.0
ßb 1.000 1 ~ 1.000
d mm -64.0 -48.0 -52.5 -77.5
bf mm 0.0 0.0 0.0 0.0 3.4.1.5
K' 0.156 0.156 0.156 0.156 Fig 3.3
Web Mres kNm 0.0 0.0 0.0 0.0 Fig 3.3
Flange Mres kNm ~~~ ~~~ 0.0 ~~~ Fig 3.3
K #DIV/0! #DIV/0! #DIV/0! #DIV/0! 3.4.4.4
z mm #DIV/0! #DIV/0! #DIV/0! #DIV/0! 3.4.4.4
x mm #DIV/0! #DIV/0! #DIV/0! #DIV/0! 3.4.4.4
d' mm 73.0 52.5 48.0 73.0
net fsc N/mm² #DIV/0! #DIV/0! #DIV/0! #DIV/0! Fig 3.3
Excess M kNm 0.0 0.0 0.0 0.0
As' req mm² #DIV/0! #DIV/0! #DIV/0! #DIV/0!
fst N/mm² #DIV/0! #DIV/0! #DIV/0! #DIV/0! Fig 3.3
As req mm² #DIV/0! #DIV/0! #DIV/0! #DIV/0!
bw/b ~~~ ~~~ #DIV/0! ~~~
Min % % 0.26% 0.00% #DIV/0! 0.26% Table 3.25
Min As mm² 0 0 #DIV/0! 0
DEFLECTION
fs N/mm² #DIV/0! #DIV/0! #DIV/0! Eqn 8
Base ratio 100.0 #DIV/0! 3.4.6.3/4
Tens Mod #DIV/0! #DIV/0! Table 3.10
Comp Mod #DIV/0! #DIV/0! Table 3.11
Perm L/d #DIV/0! #DIV/0! 3.4.6.3
Actual L/d 0.0 #DIV/0! 0.0 #DIV/0! 3.4.5.1
TENSION STEEL
As mm² #DIV/0! #DIV/0! #DIV/0!
Ø1 mm ok 16 ok 25 ok 25
Ø2 mm 0 0 0
Max No/layer -2 -2 -2
No 1 #DIV/0! #DIV/0! #DIV/0!
= mm² #DIV/0! #DIV/0! #DIV/0!
No 2 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
As prov mm² #DIV/0! #DIV/0! #DIV/0!
=% % #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
Clear dist mm #DIV/0! #DIV/0! #DIV/0! between bars
Min S mm #DIV/0! 30.0 #DIV/0! 30.0 #DIV/0! 30.0 3.12.11.1
Max S mm #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! Table 3.28
COMPRESSION STEEL
Required mm² #DIV/0! #DIV/0! #DIV/0! Table 3.25
Ø1 mm ok 16 ok 16 ok 16
Ø2 mm 0 0 0
Max No/layer -2 -2 -2
No 1 #DIV/0! #DIV/0! #DIV/0!
= #DIV/0! #DIV/0! #DIV/0!
No 2 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
As' prov mm² #DIV/0! #DIV/0! #DIV/0!
=% % #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
Clear dist mm #DIV/0! #DIV/0! #DIV/0! between bars
Min S mm #DIV/0! 30.0 #DIV/0! 30.0 #DIV/0! 30.0 3.12.11.1
SHEAR
V at cl kN ~ ~
V at d kN #VALUE! #VALUE! 3.4.5.10

v N/mm² #VALUE! #VALUE! Eqn 3

vc N/mm² #DIV/0! Nominal #DIV/0! Table 3.8
(v-vc)bv N/mm #VALUE! 0.0 #VALUE! Table 3.7
Link Ø mm #DIV/0! 10 #DIV/0! 10 #DIV/0! 10 3.12.7.1
Legs #DIV/0! 2 #DIV/0! 2 #DIV/0! 2
@ mm #VALUE! #DIV/0! #VALUE! 3.12.7.1
Adjust to mm #VALUE! #DIV/0! #VALUE!
for (UDL only) mm #DIV/0! ~~~ #DIV/0! from cl
for (with PL) mm #VALUE! ~~~ #N/A -=-
Adjust to mm #DIV/0! ~~~ #DIV/0! from face
As Dist mm #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! 3.4.5.5
As' Dist mm #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! 3.12.7.2
 Project & location Spreadsheets to BS 8110 : D&D: Main beam Grids C to H : from grid 1 to 3 SPAN 6
CONTINUOUS BEAM (Analysis & Design) to BS 8110:1997 Originated from RCC41.xls on CD © 1999 BCA for RCC

Span 0.000 m h0 Top cover 40 mm to main steel Job No R68

0 beam bw 0 Btm cover 40 mm to main steel by rmw
hf 0 Side cover 40 mm to main steel Date 24-Oct-20
SPAN 6 IS NON-EXISTANT!
MAIN STEEL LEFT .25L SPAN RIGHT BS8110 Ref
M CL kNm 0.0 0.0
M face kNm 0.0 0.0 0.0 0.0
ßb 1.000 1 ~ ~
d mm -77.5 -48.0 -52.5 -64.0
bf mm 0.0 0.0 0.0 0.0 3.4.1.5
K' 0.156 0.156 0.156 0.156 Fig 3.3
Web Mres kNm 0.0 0.0 0.0 0.0 Fig 3.3
Flange Mres kNm ~~~ ~~~ 0.0 ~~~ Fig 3.3
K #DIV/0! #DIV/0! #DIV/0! #DIV/0! 3.4.4.4
z mm #DIV/0! #DIV/0! #DIV/0! #DIV/0! 3.4.4.4
x mm #DIV/0! #DIV/0! #DIV/0! #DIV/0! 3.4.4.4
d' mm 73.0 52.5 48.0 73.0
net fsc N/mm² #DIV/0! #DIV/0! #DIV/0! #DIV/0! Fig 3.3
Excess M kNm 0.0 0.0 0.0 0.0
As' req mm² #DIV/0! #DIV/0! #DIV/0! #DIV/0!
fst N/mm² #DIV/0! #DIV/0! #DIV/0! #DIV/0! Fig 3.3
As req mm² #DIV/0! #DIV/0! #DIV/0! #DIV/0!
bw/b ~~~ ~~~ #DIV/0! ~~~
Min % % 0.26% 0.00% #DIV/0! 0.26% Table 3.25
Min As mm² 0 0 #DIV/0! 0
DEFLECTION
fs N/mm² #DIV/0! #DIV/0! #DIV/0! Eqn 8
Base ratio 100.0 #DIV/0! 3.4.6.3/4
Tens Mod #DIV/0! #DIV/0! Table 3.10
Comp Mod #DIV/0! #DIV/0! Table 3.11
Perm L/d #DIV/0! #DIV/0! 3.4.6.3
Actual L/d 0.0 #DIV/0! 0.0 #DIV/0! 3.4.5.1
TENSION STEEL
As mm² #DIV/0! #DIV/0! #DIV/0!
Ø1 mm ok 25 ok 25 ok 16
Ø2 mm 0 0 0
Max No/layer -2 -2 -2
No 1 #DIV/0! #DIV/0! #DIV/0!
= mm² #DIV/0! #DIV/0! #DIV/0!
No 2 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
As prov mm² #DIV/0! #DIV/0! #DIV/0!
=% % #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
Clear dist mm #DIV/0! #DIV/0! #DIV/0! between bars
Min S mm #DIV/0! 30.0 #DIV/0! 30.0 #DIV/0! 30.0 3.12.11.1
Max S mm #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! Table 3.28
COMPRESSION STEEL
Required mm² #DIV/0! #DIV/0! #DIV/0! Table 3.25
Ø1 mm ok 16 ok 16 ok 16
Ø2 mm 0 0 0
Max No/layer -2 -2 -2
No 1 #DIV/0! #DIV/0! #DIV/0!
= #DIV/0! #DIV/0! #DIV/0!
No 2 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
As' prov mm² #DIV/0! #DIV/0! #DIV/0!
=% % #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
Clear dist mm #DIV/0! #DIV/0! #DIV/0! between bars
Min S mm #DIV/0! 30.0 #DIV/0! 30.0 #DIV/0! 30.0 3.12.11.1
SHEAR
V at cl kN ~ ~
V at d kN #VALUE! #VALUE! 3.4.5.10

v N/mm² #VALUE! #VALUE! Eqn 3

vc N/mm² #DIV/0! Nominal #DIV/0! Table 3.8
(v-vc)bv N/mm #VALUE! 0.0 #VALUE! Table 3.7
Link Ø mm #DIV/0! 10 #DIV/0! 10 #DIV/0! 10 3.12.7.1
Legs #DIV/0! 2 #DIV/0! 2 #DIV/0! 2
@ mm #VALUE! #DIV/0! #VALUE! 3.12.7.1
Adjust to mm #VALUE! #DIV/0! #VALUE!
for (UDL only) mm #DIV/0! ~~~ #DIV/0! from cl
for (with PL) mm #VALUE! ~~~ #N/A -=-
Adjust to mm #DIV/0! ~~~ #DIV/0! from face
As Dist mm #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! 3.4.5.5
As' Dist mm #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! 3.12.7.2
Project Spreadsheets to BS 8110
Location D&D: Main beam Grids C to H, from grid 1 to 3 GRAPH DATA I
CONTINUOUS BEAM (Analysis & Design) to BS 8110:1997 Made by rmw Job No R68
Originated from RCC41.xls on CD © 1999 BCA for RCC Date 24-Oct-20

LOADING DIAGRAM 12.8333

BEAM 0 11
0 0
SUPPORTS 0 0 3.5 3.5 7.5 7.5 11 11 11 11 11 11 11 11
-44.9167 38.5 -44.9167 38.5 -44.9167 38.5 -12.8333 0 -12.8333 0 -12.8333 0 -12.8333 0
D UDL 0 0 3.5 3.5 3.5 7.5 7.5 7.5 11 11 11 11 11 11 11 11 11 11 11
0 15 15 0 20 20 0 15 15 0 0 0 0 0 0 0 0 0 0
L UDL 15 25 25 15 30 30 20 25 25 15 0 0 0 0 0 0 0 0 0
D PUDL 0 0 0 0 3.5 3.5 3.5 3.5 7.5 7.5 7.5 7.5 11 11 11 11 11 11 11 11 11 11 11 11
25 25 25 25 30 30 30 30 25 25 25 25 0 0 0 0 0 0 0 0 0 0 0 0
L PUDL 25 25 25 25 30 30 30 30 25 25 25 25 0 0 0 0 0 0 0 0 0 0 0 0
PL 1 2 2 5.5 5.5 7.5 7.5 11 11 11 11 11 11
25 25 30 30 25 25 0 0 0 0 0 0
25 30 30 35 25 25 0 0 0 0 0 0
PL 2 0 0 3.5 3.5 7.5 7.5 11 11 11 11 11 11
25 25 30 30 25 25 0 0 0 0 0 0
25 25 30 30 25 25 0 0 0 0 0 0

MOMENT DIAGRAMS
SPAN 1 at col face
X 0 0 0.175 0.35 0.525 0.7 0.875 1.05 1.225 1.4 1.575 1.75 1.925 2.1 2.275 2.45 2.625 2.8 2.975 3.15 3.325 3.5 0.15 3.35
M(e) all 0 11.3408 2.37378 -5.46013 -12.1609 -17.7286 -22.1631 -25.4645 -27.6328 -28.6679 -28.57 -27.3389 -24.9746 -20.6773 -14.6468 -7.48324 0.81348 10.2433 20.8063 32.5024 45.3316 59.294 3.58541 47.2569
M(e) odd 0 14.5005 4.48379 -4.39979 -12.1502 -18.7676 -24.2518 -28.6028 -31.8208 -33.9056 -34.8573 -34.6759 -33.3613 -30.1136 -25.1328 -19.0189 -11.7719 -3.39168 6.12163 16.7681 28.5476 41.4603 5.84537 30.3229
M(e) even 0 0.83309 -1.5073 -3.38832 -4.80996 -5.77222 -6.27511 -6.31863 -5.90277 -5.02753 -3.69293 -1.89894 0.35442 3.06715 6.23926 9.87075 13.9616 18.5118 23.5214 28.9904 34.9188 41.3065 -1.20108 35.8032
Beam 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
M(r) all 0 11.6004 1.78765 -6.89196 -14.4384 -20.8518 -26.132 -30.2792 -33.2931 -35.174 -35.9217 -35.5364 -34.0178 -30.5662 -25.3814 -19.0636 -11.6125 -3.0284 6.68886 17.5393 29.5228 42.6394 3.12009 31.3272
M(r) odd 0 11.6004 1.78765 -6.89196 -14.4384 -20.8518 -26.132 -30.2792 -33.2931 -35.174 -35.9217 -35.5364 -34.0178 -30.5662 -25.3814 -19.0636 -11.6125 -3.0284 6.68886 17.5393 29.5228 42.6394 3.12009 31.3272
M(r) even 0 0.99971 -1.28237 -3.10507 -4.4684 -5.37235 -5.81693 -5.80213 -5.32796 -4.39441 -3.00149 -1.14919 1.16248 3.93353 7.16395 10.8537 15.0029 19.6115 24.6794 30.2067 36.1934 42.6394 -0.98448 37.0861
70% max 0 10.1503 3.13865 -2.37182 -3.36697 -4.04056 -4.39258 -4.42304 -4.13194 -3.51927 -2.58505 -1.32926 0.24809 2.14701 4.36748 6.90952 9.77312 12.9583 16.465 22.7517 31.7321 41.5058 4.09176 33.0798
70% min 0 0.58316 -1.05511 -3.82209 -8.51263 -13.1373 -16.9762 -20.022 -22.2745 -23.7339 -24.4001 -24.2731 -23.3529 -21.0795 -17.593 -13.3132 -8.2403 -2.37417 4.28514 11.7376 19.9833 28.9146 -0.84076 21.226
Lower bound 0 0 -1.28237 -6.89196 -14.4384 -20.8518 -26.132 -30.2792 -33.2931 -35.174 -35.9217 -35.5364 -34.0178 -30.5662 -25.3814 -19.0636 -11.6125 -3.0284 0 0 0 0 -0.98448 21.226
Upper bound 0 11.6004 3.13865 0 0 0 0 0 0 0 0 0 1.16248 3.93353 7.16395 10.8537 15.0029 19.6115 24.6794 30.2067 36.1934 42.6394 4.09176 37.0861
Beam 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
L0 1.75 1.75 0.35 1.75 1.75 1.75 1.75 1.75 1.75 1.75 2.45 3.5 3.5 3.5 3.5 3.5 2.8 3.5 3.5 3.5 3.5
SPAN 2
Local X 0 0.2 0.4 0.6 0.8 1 1.2 1.4 1.6 1.8 2 2.2 2.4 2.6 2.8 3 3.2 3.4 3.6 3.8 4 0.15 3.85
X 3.5 3.7 3.9 4.1 4.3 4.5 4.7 4.9 5.1 5.3 5.5 5.7 5.9 6.1 6.3 6.5 6.7 6.9 7.1 7.3 7.5
M(e) all 60.9134 43.4008 27.6481 13.6554 1.42278 -9.04988 -17.7625 -24.7152 -29.9079 -33.3405 -35.0132 -33.3259 -29.8785 -24.6712 -17.7039 -8.97652 1.51082 13.7582 27.7655 43.5328 61.0602 47.6139 47.7497
M(e) odd 34.1259 26.5745 19.8231 13.8717 8.7203 4.368912 0.81752 -1.93387 -3.88526 -5.03665 -5.38804 -4.93943 -3.69083 -1.64222 1.20639 4.855 9.30361 14.5522 20.6008 27.4494 35.098 28.3873 29.2866
M(e) even 51.6425 34.1341 18.3857 4.3973 -7.8311 -18.2995 -27.0079 -33.9563 -39.1447 -42.5731 -44.2415 -42.5499 -39.0983 -33.8867 -26.9151 -18.1835 -7.69188 4.55972 18.5713 34.3429 51.8745 38.3462 38.5608
Beam 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
M(r) all 42.6394 26.0404 11.2015 -1.87748 -13.1964 -22.7554 -30.5544 -36.5933 -40.8723 -43.3913 -44.1502 -41.5492 -37.1881 -31.0671 -23.1861 -13.545 -2.14399 11.0171 25.9381 42.6191 61.0602 30.0252 47.0644
M(r) odd 42.6394 34.6623 27.4853 21.1082 15.5311 10.75407 6.777 3.59993 1.22286 -0.35421 -1.13127 -1.10834 -0.28541 1.33752 3.76045 6.98339 11.0063 15.8293 21.4522 27.8751 35.098 36.5816 29.6058
M(r) even 42.6394 25.5812 10.2829 -3.25533 -15.0336 -25.0518 -33.3101 -39.8083 -44.5465 -47.5248 -48.743 -46.6013 -42.6995 -37.0378 -29.616 -20.4343 -9.4925 3.20926 17.671 33.8928 51.8745 29.6807 38.2232
70% max 42.6394 30.3805 19.3537 9.71019 6.10421 3.058238 0.57226 -1.35371 -2.71968 -3.52566 -3.77163 -3.4576 -2.58358 -1.14955 0.84448 3.3985 6.51253 10.1866 19.4358 30.473 42.7421 33.3298 33.4248
70% min 23.8881 18.6021 12.87 3.07811 -5.48177 -12.8096 -18.9055 -23.7694 -27.4013 -29.8012 -30.969 -29.7849 -27.3688 -23.7207 -18.8406 -12.7284 -5.38432 3.1918 12.9999 19.2146 24.5686 19.8711 20.5006
Lower bound 0 0 0 -3.25533 -15.0336 -25.0518 -33.3101 -39.8083 -44.5465 -47.5248 -48.743 -46.6013 -42.6995 -37.0378 -29.616 -20.4343 -9.4925 0 0 0 0 19.8711 20.5006
Upper bound 42.6394 34.6623 27.4853 21.1082 15.5311 10.75407 6.777 3.59993 1.22286 0 0 0 0 1.33752 3.76045 6.98339 11.0063 15.8293 25.9381 42.6191 61.0602 36.5816 47.0644
Beam 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
L0 2 2 2 0.6 2 2 2 2 2 2 2.6 4 4 4 4 4 3.2 4 4 4 4
SPAN 3
Local X 0 0.175 0.35 0.525 0.7 0.875 1.05 1.225 1.4 1.575 1.75 1.925 2.1 2.275 2.45 2.625 2.8 2.975 3.15 3.325 3.5 0.15 3.5
X 7.5 7.675 7.85 8.025 8.2 8.375 8.55 8.725 8.9 9.075 9.25 9.425 9.6 9.775 9.95 10.125 10.3 10.475 10.65 10.825 11
M(e) all 59.4822 45.7434 33.1377 21.6652 11.3258 2.119455 -5.95372 -12.8938 -18.7007 -23.3745 -26.9152 -29.3227 -30.5971 -30.7384 -29.7466 -27.6216 -24.3636 -19.9724 -14.448 -7.79058 0 47.6367 5.6E-13
M(e) odd 42.7372 29.8357 18.0672 7.43193 -2.07024 -10.4393 -17.6752 -23.778 -28.7477 -32.5842 -35.2877 -36.8579 -37.2951 -36.5992 -34.7701 -31.8079 -27.7126 -22.4841 -16.1225 -8.62783 0 31.6094 7E-13
M(e) even 41.6069 35.1625 29.1775 23.6518 18.5855 13.97862 9.83109 6.14293 2.91415 0.14474 -2.16529 -4.01595 -5.40723 -6.33914 -6.81168 -6.82483 -6.37862 -5.47303 -4.10806 -2.28372 0 36.055 1.6E-13
Beam 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
M(r) all 59.4822 45.7434 33.1377 21.6652 11.3258 2.119455 -5.95372 -12.8938 -18.7007 -23.3745 -26.9152 -29.3227 -30.5971 -30.7384 -29.7466 -27.6216 -24.3636 -19.9724 -14.448 -7.79058 0 47.6367 5.6E-13
M(r) odd 42.7372 29.8357 18.0672 7.43193 -2.07024 -10.4393 -17.6752 -23.778 -28.7477 -32.5842 -35.2877 -36.8579 -37.2951 -36.5992 -34.7701 -31.8079 -27.7126 -22.4841 -16.1225 -8.62783 0 31.6094 7E-13
M(r) even 41.6069 35.1625 29.1775 23.6518 18.5855 13.97862 9.83109 6.14293 2.91415 0.14474 -2.16529 -4.01595 -5.40723 -6.33914 -6.81168 -6.82483 -6.37862 -5.47303 -4.10806 -2.28372 0 36.055 1.6E-13
70% max 41.6375 32.0204 23.1964 16.5563 13.0099 9.785036 6.88176 4.30005 2.0399 0.10132 -1.51571 -2.81117 -3.78506 -4.4374 -4.76817 -4.77738 -4.46503 -3.83112 -2.87564 -1.5986 0 33.3457 4.9E-13
70% min 29.1248 20.885 12.6471 5.20235 -1.44917 -7.3075 -12.3726 -16.6446 -20.1234 -22.809 -24.7014 -25.8006 -26.1066 -25.6194 -24.3391 -22.2655 -19.3988 -15.7389 -11.2858 -6.03948 0 22.1265 1.1E-13
Lower bound 0 0 0 0 -2.07024 -10.4393 -17.6752 -23.778 -28.7477 -32.5842 -35.2877 -36.8579 -37.2951 -36.5992 -34.7701 -31.8079 -27.7126 -22.4841 -16.1225 -8.62783 0 22.1265 1.1E-13
Upper bound 59.4822 45.7434 33.1377 23.6518 18.5855 13.97862 9.83109 6.14293 2.91415 0.14474 0 0 0 0 0 0 0 0 0 0 0 47.6367 7E-13
Beam 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
L0 1.75 1.75 1.75 1.75 0.7 1.75 1.75 1.75 1.75 1.75 2.8 3.5 3.5 3.5 3.5 3.5 3.5 3.5 3.5 3.5 3.5
Project Spreadsheets to BS 8110
Location D&D: Main beam Grids C to H, from grid 1 to 3 GRAPH DATA II
CONTINUOUS BEAM (Analysis & Design) to BS 8110:1997 Made by rmw Job No R68
Originated from RCC41.xls on CD © 1999 BCA for RCC Date 24-Oct-20

SPAN 4
Local X 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
X 11 11 11 11 11 11 11 11 11 11 11 11 11 11 11 11 11 11 11 11 11
M(e) all 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
M(e) odd 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
M(e) even 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Beam 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
M(r) all 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
M(r) odd 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
M(r) even 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
70% max 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
70% min 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Lower bound 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Upper bound 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Beam 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
L0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
SPAN 5
Local X 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
X 11 11 11 11 11 11 11 11 11 11 11 11 11 11 11 11 11 11 11 11 11
M(e) all 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
M(e) odd 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
M(e) even 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Beam 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
M(r) all 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
M(r) odd 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
M(r) even 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
70% max 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
70% min 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Lower bound 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Upper bound 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Beam 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
L0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
SPAN 6
Local X 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
X 11 11 11 11 11 11 11 11 11 11 11 11 11 11 11 11 11 11 11 11 11 11
M(e) all 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
M(e) odd 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
M(e) even 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Beam 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
M(r) all 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
M(r) odd 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
M(r) even 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
70% max 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
70% min 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Lower bound 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Upper bound 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Beam 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
L0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
SHEAR FORCE DIAGRAMS
SPAN 1 SPAN 2 SPAN 3 SPAN 4 SPAN 5 SPAN 6
Local X 0 0 2 2 2 2 3.5 0 2 2 2 2 4 0 0 0 0 0 3.5 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
X 0 0 2 2 2 2 3.5 3.5 5.5 5.5 5.5 5.5 7.5 7.5 7.5 7.5 7.5 7.5 11 11 11 11 11 11 11 11 11 11 11 11 11 11 11 11 11 11 11 11
V(e) all 0 54.4777 -19.5223 -27.5223 -27.5223 -27.5223 -83.0223 91.9633 3.96332 -4.03668 -4.03668 -4.03668 -92.0367 81.7449 81.7449 81.7449 81.7449 81.7449 -47.7551 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
V(e) odd 0 60.4758 -13.5242 -21.5242 -21.5242 -21.5 -77.0242 39.757 -0.24305 -0.24305 -0.24305 -0.24305 -40.243 76.9606 76.9606 76.9606 76.9606 76.9606 -52.5394 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
V(e) even 0 14.6862 -15.3138 -15.3138 -15.3138 -15.3138 -37.8138 91.942 3.94199 -4.05801 -4.05801 -4.05801 -92.058 38.1377 38.1377 38.1377 38.1377 38.1377 -14.3623 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
V(r) all 0 59.3103 -14.6897 -22.6897 -22.6897 -22.6897 -78.1897 87.3948 -0.60519 -8.60519 -8.60519 -8.60519 -96.6052 81.7449 81.7449 81.7449 81.7449 81.7449 -47.7551 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
V(r) odd 0 59.3103 -14.6897 -22.6897 -22.6897 -22.6897 -78.1897 41.8853 1.88534 1.88534 1.88534 1.88534 -38.1147 76.9606 76.9606 76.9606 76.9606 76.9606 -52.5394 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
V(r) even 0 14.3529 -15.6471 -15.6471 -15.6471 -15.6471 -38.1471 89.6912 1.69122 -6.30878 -6.30878 -6.30878 -94.3088 38.1377 38.1377 38.1377 38.1377 38.1377 -14.3623 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Beam 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

GRIDS 0 0 3.5 3.5 7.5 7.5 11 11 11 11 11 11 11 11

-44.2415 64.1132 -44.2415 64.1132 -44.2415 64.1132 -44.2415 64.1132 -44.2415 64.1132 -44.2415 64.1132 -44.2415 64.1132
-48.743 64.1132 -48.743 64.1132 -48.743 64.1132 -48.743 64.1132 -48.743 64.1132 -48.743 64.1132 -48.743 64.1132
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 Size (kB)

First public release.
03-Aug-99 RCC41 v1.0 1029
Includes b version comments
28-Sep-99 RCC41 v1.1 UCL comments incorporated 1028