Project Spreadsheets to BS 8110 The Concrete Centre

Client Advisory Group Made by Date Page

Location Level 2, Beam on line 6 from B to E RMW 31-May-2017 36
SUBFRAME ANALYSIS to BS8110:2005 Checked Revision Job No
Originated from RCC21.xls v4.2 on CD 2006 TCC chg - R68

LOCATION Supports from grid B to grid E

SPANS
L (m) H (mm) bw (mm) hf (mm) Type bf (mm) LOADING PATTERN
SPAN 1 7.000 600 375 150 T 1355 min max
SPAN 2 12.000 600 375 150 T 2055 DEAD 1 1.4
SPAN 3 12.000 600 375 150 T 2055 IMPOSED 0 1.6
SPAN 4 6.000 600 375 150 T 1215
SPAN 5 0
SPAN 6 0

SUPPORTS
ABOVE (m) H (mm) B (mm) End Cond BELOW (m) H (mm) B (mm) End Cond
Support 1 2.95 400 300 F 3.10 400 300 P
Support 2 3.00 400 300 P 3.10 300 300 P
Support 3 0.00 3.10 400 300 P
Support 4 K
Support 5 4.00 400 300 P 3.10 300 300 P
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 32.20 12.50 ~~~~~ ~~~~~ UDL 17.50 5.60 ~~~~~ ~~~~~
PL 1 ~~~~~ PL 1 24 6 2.000 ~~~~~
PL 2 ~~~~~ PL 2 5 18 4.500 ~~~~~
Part UDL Part UDL
Span 2 Span 5
UDL 32.20 12.50 ~~~~~ ~~~~~ UDL ~~~~~ ~~~~~
PL 1 ~~~~~ PL 1 ~~~~~
PL 2 25 25 5.000 ~~~~~ PL 2 ~~~~~
Part UDL Part UDL
Span 3 Span 6
UDL 24.42 8.65 ~~~~~ ~~~~~ UDL ~~~~~ ~~~~~
PL 1 ~~~~~ PL 1 ~~~~~
PL 2 ~~~~~ PL 2 ~~~~~
Part UDL 7.5 4.5 1.500 2.400 Part UDL

LOADING DIAGRAM

B E

REACTIONS (kN)
SUPPORT 1 2 3 4 5
ALL SPANS LOADED 153.5 724.8 778.3 478.4 75.0
ODD SPANS LOADED 177.7 465.9 568.4 415.9 -8.2
EVEN SPANS LOADED 27.2 621.0 636.4 271.0 116.7
Characteristic Dead 72.8 354.6 386.7 237.2 30.5
Characteristic Imposed 47.4 142.7 148.1 91.4 46.2
 Spreadsheets to BS 8110 The Concrete Centre
Project
Client Advisory Group Made by Date Page
Location Level 2, Beam on line 6, from B to E RMW 31-May-17 37
SUBFRAME ANALYSIS to BS8110:2005 Checked Revision Job No
Originated from RCC21.xls v4.2 on CD 2006 TCC chg - R68

BENDING MOMENT DIAGRAMS (kNm)

1000 1000
800 800

600 600
400
400
200
200
0
0
-200
-200
-400
-400 -600
-600 -800
-800 -1000
0 5 10 15 20 25 30 35 40 0 5 10 15 20 25 30 35 40

B Elastic Moments E B Redistributed Envelope E

SUPPORT No 1 2 3 4 5
Elastic M 95.3 743.3 868.6 427.6 34.3 ~ kNm
Redistributed M 90.5 557.5 694.9 406.2 32.6 ~ kNm
b 0.950 0.750 0.800 0.950 0.950 ~ ~
Redistribution 5.0% 25.0% 20.0% 5.0% 5.0%

SPAN No 1 2 3 4
Elastic M 185.0 633.1 400.1 121.4 ~ ~ Based on support
Redistributed M 152.1 746.8 373.5 118.8 ~ ~ moments of
b 0.822 1.180 0.934 0.979 ~ ~ min(bM, Malt/b)
SHEAR FORCE DIAGRAMS (kN)

500 500
400 400
300 300
200 200
100 100
0 0
-100 -100
-200 -200
-300 -300
-400 -400
-500 -500
0 5 10 15 20 25 30 35 40 0 5 10 15 20 25 30 35 40

B Elastic Shears E B Redistributed Shears E

SPAN No 1 2 3
Elastic V 191.0 312.6 435.6 432.2 356.9 282.0
Redistributed V 177.7 302.0 422.8 433.2 345.1 273.7

SPAN No 4
Elastic V 203.4 118.4 ~ ~ ~ ~

Redistributed V 204.7 116.7 ~ ~ ~ ~

COLUMN MOMENTS (kNm) 1 2 3 4 5

ALL SPANS Above 21.0 80.7 -4.1
LOADED Below 15.0 32.9 -40.2 -2.2
ODD SPANS Above 55.6 0.7 17.5
LOADED Below 39.7 0.3 51.6 9.5
EVEN SPANS Above -22.7 116.5 -22.2
LOADED Below -16.2 47.6 -108.0 -12.1
 Project Spreadsheets to BS 8110
Location Level 2, Beam on line 6 ANALYSIS I
SUBFRAME ANALYSIS to BS8110:2005 Made by RMW Job No R68
Originated from RCC21.xls v4.2 on CD 2006 TCC Date 31-May-17

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 225000 225000 225000 225000 225000
Af 147000 147000 252000 252000 252000
X bar 211.08870968 211.08870968 181.13207547 181.13207547 181.132
I 1600000000 1600000000 11526759073 11526759073 1600000000 675000000 13240188679 13240188679 0 1600000000 1E+010
Stiffness 542372881 387096774 1646679868 1646679868 400000000 163306452 1103349057 1103349057 0 387096774 1E+009
Sum 2576149523 3.E+09 3.E+09
Factor 0.2105 0.1503 0.6392 0.4970 0.1207 0.0493 0.3330 0.4254 0.0000 0.1492 0.4254
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 225000 225000 225000 0 0 0
Af 252000 126000 126000 0 0 0
X bar 181.13207547 219.23076923 219.23076923 #DIV/0! #DIV/0! #DIV/0!
I 13240188679 0 0 11075192308 11075192308 1600000000 675000000 #DIV/0! #DIV/0! 0 0 #DIV/0!
Stiffness 1103349057 0 0 1845865385 1845865385 300000000 163306452 0 0 0 0 0
Sum 3.E+09 2.E+09 0.E+00
Factor 0.3741 0.0000 0.0000 0.6259 0.7994 0.1299 0.0707 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.2 0 #DIV/0! ###
I #DIV/0! 0 0 b 0 0 0.225 0 #DIV/0! ###
Stiffness 0 0 0
Sum 0.E+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 788.90 2443.40 1806.84 385.50 0.00 0.00
UDL 131.48 131.48 386.40 386.40 293.04 293.04 52.50 52.50 0.00 0.00 0.00 0.00
PL 1 0.00 0.00 0.00 0.00 0.00 0.00 21.33 10.67 #DIV/0! #DIV/0! #DIV/0! ###
PL 2 0.00 0.00 42.53 30.38 0.00 0.00 1.41 4.22 #DIV/0! #DIV/0! #DIV/0! ###
part UDL 0.00 0.00 0.00 0.00 28.24 8.71 0.00 0.00 #DIV/0! #DIV/0! #DIV/0! ###
FEM 131.48 131.48 428.93 416.78 321.28 301.75 75.24 67.39 0.00 0.00 0.00 0.00
Live load
Cant 805.56 2617.36 1765.87 464.28 0.00 0.00
UDL 134.26 134.26 394.56 394.56 283.30 283.30 47.88 47.88 0.00 0.00 0.00 0.00
PL 1 0.00 0.00 0.00 0.00 0.00 0.00 17.07 8.53 #DIV/0! #DIV/0! #DIV/0! ###
PL 2 0.00 0.00 85.07 60.76 0.00 0.00 8.66 25.99 #DIV/0! #DIV/0! #DIV/0! ###
part UDL 0.00 0.00 0.00 0.00 38.40 11.84 0.00 0.00 #DIV/0! #DIV/0! #DIV/0! ###
FEM 134.26 134.26 479.63 455.32 321.70 295.14 73.61 82.40 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 -131.48 131.48 -428.93 416.78 -321.28 301.75 -75.24 67.39 0.00 0.00 0.00 0.00
27.68 84.04 19.76 35.91 147.83 99.05 14.66 0.00 -40.63 -40.63 -14.25 0.00 -84.74 -141.77 0.00 -8.75 -53.87 0.00 -4.77 0.00 0.00 0.00 0.00 0.00 0.00 0.00
73.91 42.02 -20.31 49.53 -42.37 -20.31 -26.93 -70.88
-15.56 -47.25 -11.11 -2.62 -10.79 -7.23 -1.07 -3.04 -3.04 -1.07 17.68 29.57 9.21 56.66 5.01
-5.39 -23.62 -1.52 -3.61 8.84 -1.52 28.33 14.79
1.14 3.45 0.81 3.04 12.50 8.37 1.24 -2.22 -2.22 -0.78 -10.03 -16.78 -1.92 -11.82 -1.05
6.25 1.72 -1.11 4.19 -5.01 -1.11 -5.91 -8.39
-1.32 -3.99 -0.94 -0.07 -0.30 -0.20 -0.03 0.35 0.35 0.12 2.63 4.39 1.09 6.71 0.59
-0.15 -2.00 0.18 -0.10 1.31 0.18 3.35 2.20
0.03 0.10 0.02 0.22 0.90 0.61 0.09 -0.52 -0.52 -0.18 -1.32 -2.21 -0.29 -1.76 -0.16
0.45 0.05 -0.26 0.30 -0.66 -0.26 -0.88 -1.10
-0.10 -0.29 -0.07 0.03 0.10 0.07 0.01 0.15 0.15 0.05 0.42 0.71 0.14 0.88 0.08
0.05 -0.14 0.08 0.03 0.21 0.08 0.44 0.36
-0.01 -0.03 -0.01 0.01 0.03 0.02 0.00 -0.11 -0.11 -0.04 -0.19 -0.32 -0.05 -0.28 -0.03
Sum 11.87 -20.34 8.47 36.50 299.79 -351.20 14.90 421.11 -404.97 -16.14 203.24 -203.24 -0.56 0.87 -0.31
Project Spreadsheets to BS 8110
Location Level 2, Beam on line 6 ANALYSIS II
SUBFRAME ANALYSIS to BS8110:2005 Made by RMW Job No R68
Originated from RCC21.xls v4.2 on CD 2006 TCC Date 31-May-17

Moment Distribution (cont)

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
Live on -134.26 134.26 -321.70 295.14 0.00 0.00
Odd Spans 28.27 85.82 20.17 -16.21 -66.73 -44.71 -6.62 0.00 136.84 136.84 48.01 0.00 -110.42 -184.72 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
-33.36 42.91 68.42 -22.35 -55.21 68.42 -92.36
7.02 21.33 5.01 -13.44 -55.33 -37.07 -5.49 32.99 32.99 11.58 -25.60 -42.82 12.00 73.83 6.53
-27.67 10.66 16.50 -18.54 -12.80 16.50 36.92 -21.41
5.82 17.68 4.16 -3.28 -13.50 -9.04 -1.34 13.33 13.33 4.68 -19.98 -33.43 2.78 17.12 1.51
-6.75 8.84 6.66 -4.52 -9.99 6.66 8.56 -16.71
1.42 4.31 1.01 -1.87 -7.71 -5.16 -0.76 6.17 6.17 2.17 -5.70 -9.53 2.17 13.36 1.18
-3.85 2.16 3.09 -2.58 -2.85 3.09 6.68 -4.76
0.81 2.46 0.58 -0.63 -2.61 -1.75 -0.26 2.31 2.31 0.81 -3.65 -6.11 0.62 3.81 0.34
-1.30 1.23 1.15 -0.87 -1.83 1.15 1.90 -3.06
0.27 0.83 0.20 -0.29 -1.19 -0.79 -0.12 1.15 1.15 0.40 -1.14 -1.91 0.40 2.44 0.22
-0.59 0.42 0.57 -0.40 -0.57 0.57 1.22 -0.96
0.12 0.38 0.09 -0.12 -0.49 -0.33 -0.05 0.41 0.41 0.14 -0.67 -1.12 0.12 0.77 0.07
Sum 43.75 -74.97 31.22 -35.84 52.93 -2.46 -14.63 143.95 -211.73 67.79 224.38 -224.38 18.09 -27.94 9.85
Live on -479.63 455.32 -73.61 82.40 0.00 0.00
Even Spans 0.00 0.00 0.00 57.90 238.37 159.72 23.64 0.00 -193.69 -193.69 -67.95 0.00 27.54 46.07 0.00 -10.71 -65.87 0.00 -5.83 0.00 0.00 0.00 0.00 0.00 0.00 0.00
119.18 -96.84 79.86 13.77 -96.84 -32.93 23.04
-25.09 -76.18 -17.91 11.69 48.13 32.25 4.77 -39.83 -39.83 -13.97 48.55 81.23 -2.99 -18.41 -1.63
24.06 -38.09 -19.91 16.12 24.28 -19.91 -9.21 40.61
-5.07 -15.38 -3.62 7.00 28.83 19.32 2.86 -17.19 -17.19 -6.03 10.89 18.23 -5.28 -32.46 -2.87
14.41 -7.69 -8.59 9.66 5.45 -8.59 -16.23 9.11
-3.03 -9.21 -2.17 1.97 8.09 5.42 0.80 -6.43 -6.43 -2.25 9.29 15.54 -1.18 -7.28 -0.64
4.05 -4.61 -3.21 2.71 4.64 -3.21 -3.64 7.77
-0.85 -2.59 -0.61 0.94 3.89 2.60 0.39 -3.13 -3.13 -1.10 2.56 4.29 -1.01 -6.21 -0.55
1.94 -1.29 -1.56 1.30 1.28 -1.56 -3.11 2.15
-0.41 -1.24 -0.29 0.34 1.42 0.95 0.14 -1.10 -1.10 -0.39 1.75 2.92 -0.28 -1.71 -0.15
0.71 -0.62 -0.55 0.48 0.87 -0.55 -0.86 1.46
-0.15 -0.45 -0.11 0.14 0.58 0.39 0.06 -0.57 -0.57 -0.20 0.53 0.88 -0.19 -1.17 -0.10
Sum -34.60 59.30 -24.70 79.99 277.00 -389.66 32.66 303.53 -211.63 -91.89 -29.57 29.57 -21.64 33.41 -11.78

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 36.00 629.73 743.31 868.58 828.33 398.05 398.05 6.34 0.00 0.00 0.00 0.00
Odd Spans 95.30 352.72 353.66 565.05 616.70 427.62 427.62 -27.07 0.00 0.00 0.00 0.00
Even Spans -38.97 576.79 740.85 724.64 616.60 173.67 173.67 34.29 0.00 0.00 0.00 0.00
Negatives 38.97 0.00 0.00 0.00 27.07 0.00 0.00
Redistribution (3.2.2.1) method 1
b - 0.95 0.75 0.8 0.95 0.95 1 1
b + 1.05 1.25 1.2 1.05 1.05 1 1
Max M 90.54 557.48 694.87 406.24 32.57 0.00 0.00
Dead only 20.34 299.79 351.20 421.11 404.97 203.24 203.24 0.87 0.00 0.00 0.00 0.00
All spans 37.80 557.48 557.48 694.87 694.87 406.24 406.24 6.66 0.00 0.00 0.00 0.00
Odd Spans 90.54 440.90 442.07 678.06 694.87 406.24 406.24 -28.42 0.00 0.00 0.00 0.00
Even Spans -40.91 557.48 557.48 694.87 694.87 182.36 182.36 32.57 0.00 0.00 0.00 0.00
Negatives 40.91 0.00 0.00 0.00 28.42 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 225.4 0 0 0 386.4 0 25 0 293.04 0 0 18
All spans 455.56 0 0 0 780.96 0 75 0 576.336 0 0 42.48
Odd Spans 455.56 0 0 0 386.4 0 25 0 576.336 0 0 42.48
Even Spans 225.4 0 0 0 780.96 0 75 0 293.04 0 0 18
Span 4 5 6
Dead only 105 24 5 0 0 0 0 0 0 0 0 0
All spans 200.76 43.2 35.8 0 0 0 0 0 0 0 0 0
Odd Spans 105 24 5 0 0 0 0 0 0 0 0 0
Even Spans 200.76 43.2 35.8 0 0 0 0 0 0 0 0 0

Elastic Shears
Span 1 2 3
All spans 142.96 312.60 423.79 432.17 356.95 261.87
Odd Spans 191.01 264.55 190.17 221.23 336.85 281.97
Even Spans 24.73 200.67 435.58 420.38 197.38 113.66
Span 4 5 6
All spans 203.41 76.35 0.00 0.00 0.00 0.00
Odd Spans 145.53 -11.53 0.00 0.00 0.00 0.00
Even Spans 161.36 118.40 0.00 0.00 0.00 0.00
Project Spreadsheets to BS 8110
Location Level 2, Beam on line 6 ANALYSIS III
SUBFRAME ANALYSIS to BS8110:2005 Made by RMW Job No R68
Originated from RCC21.xls v4.2 on CD 2006 TCC Date 31-May-17

Redistributed Shears
Span 1 2 3
Dead only 72.78 152.62 201.96 209.44 177.28 133.76
All spans 153.54 302.02 422.78 433.18 345.14 273.67
Odd Spans 177.73 277.83 188.12 223.28 345.14 273.67
Even Spans 27.21 198.19 422.78 433.18 203.18 107.86
Span 4 5 6
Dead only 103.48 30.52 0.00 0.00 0.00 0.00
All spans 204.73 75.03 0.00 0.00 0.00 0.00
Odd Spans 142.19 -8.19 0.00 0.00 0.00 0.00
Even Spans 163.09 116.67 0.00 0.00 0.00 0.00

Imposed Reactions
Support 1 2 3 4 5 6 7
All spans 32.28 142.74 148.07 91.42 20.19 0.00 0.00
Odd Spans 47.40 31.45 69.24 78.20 -24.20 0.00 0.00
Even Spans -28.48 116.00 103.66 -4.80 46.21 0.00 0.00

SPAN MOMENTS
SPAN 1 Left < > PL1 < > PL2 < > Right Loadings 0 0
Elastic V All 142.96 0 142.96 0 142.96 100 312.60 65.08 0 0 0
Odd 191.01 0 191.01 0 191.01 100 264.55 65.08 0 0 0
Even 24.73 0 24.73 0 24.73 100 200.67 32.2 0 0 0
Redist V All 153.54 0 153.54 0 153.54 100 302.02 7
Odd 177.73 0 177.73 0 177.73 100 277.83
Even 27.21 0 27.21 0 27.21 100 198.19
Elastic X- All 0.000 0.000 0.000 0.000 2.197 0.000 2.197 2.197 2.197
Odd 0.000 0.000 0.000 0.000 2.935
Even 0.000 0.000 0.000 0.000 0.768
Redist X- All 0.000 0.000 0.000 0.000 2.359 2.359 2.359 2.359
Odd 0.000 0.000 0.000 0.000 2.731 (3.2.2.1b) 2.731 2.731 2.731
Even 0.000 0.000 0.000 0.000 0.845 Max 0.845 0.845 0.845
Elastic M All 36.00 -36.00 -36.00 -36.00 -36.00 121.02 629.73 121.02
Odd 95.30 -95.30 -95.30 -95.30 -95.30 184.99 352.72 184.99
Even -38.97 38.97 38.97 38.97 38.97 48.47 576.79 48.47 b
Redist M All 37.80 -37.80 -37.80 -37.80 -37.80 143.32 557.48 143.32 1.184
Odd 90.54 -90.54 -90.54 -90.54 -90.54 152.14 440.90 152.14 0.822
Even -40.91 40.91 40.91 40.91 40.91 52.41 557.48 52.41 1.081

SPAN 2 Left < > PL1 < > PL2 < > Right Loadings 0 0
Elastic V All 423.79 0 423.79 0 98.39 100 432.17 65.08 0 75 0
Odd 190.17 0 190.17 0 29.17 100 221.23 32.2 0 25 0
Even 435.58 0 435.58 0 110.18 100 420.38 65.08 0 75 0
Redist V All 422.78 0 422.78 0 97.38 100 433.18 12
Odd 188.12 0 188.12 0 27.12 100 223.28
Even 422.78 0 422.78 0 97.38 100 433.18
Elastic X- All 0.000 0.000 0.000 5.000 5.359 5.359 5.359 5.359
Odd 0.000 0.000 0.000 5.000 5.129 5.129 5.129 5.129
Even 0.000 0.000 0.000 5.000 5.541 5.541 5.541 5.541
Redist X- All 0.000 0.000 0.000 5.000 5.344 5.344 5.344 5.344
Odd 0.000 0.000 0.000 5.000 5.066 (3.2.2.1b) 5.066 5.066 5.066
Even 0.000 0.000 0.000 5.000 5.344 Max 5.344 5.344 5.344
Elastic M All 743.31 -743.31 -743.31 -743.31 562.14 566.35 868.58 566.35
Odd 353.66 -353.66 -353.66 -353.66 194.68 194.95 565.05 194.95
Even 740.85 -740.85 -740.85 -740.85 623.56 633.06 724.64 633.06 b
Redist M All 557.48 -557.48 -557.48 -557.48 742.92 746.77 694.87 746.77 1.319
Odd 442.07 -442.07 -442.07 -442.07 96.01 96.08 678.06 136.46 0.700
Even 557.48 -557.48 -557.48 -557.48 742.92 746.77 694.87 746.77 1.180

SPAN 3 Left < > PL1 < > PL2 < > Right Loadings 1.5 2.4
Elastic V All 356.95 0 356.95 0 356.95 100 261.87 48.028 0 0 17.7
Odd 336.85 0 336.85 0 336.85 100 281.97 48.028 0 0 17.7
Even 197.38 0 197.38 0 197.38 100 113.66 24.42 0 0 7.5
Redist V All 345.14 0 345.14 0 345.14 100 273.67 12
Odd 345.14 0 345.14 0 345.14 100 273.67
Even 203.18 0 203.18 0 203.18 100 107.86
Elastic X- All 0.000 0.000 0.000 0.000 6.548 7.432 5.835 6.548
Odd 0.000 0.000 0.000 0.000 6.129 7.014 5.529 6.129
Even 0.000 0.000 0.000 0.000 7.346 8.083 6.536 7.346
Redist X- All 0.000 0.000 0.000 0.000 6.302 7.186 5.655 6.302
Odd 0.000 0.000 0.000 0.000 6.302 (3.2.2.1b) 7.186 5.655 6.302
Even 0.000 0.000 0.000 0.000 7.583 Max 8.320 6.718 7.583
Elastic M All 828.33 -828.33 -828.33 -828.33 -828.33 315.86 398.05 315.86
Odd 616.70 -616.70 -616.70 -616.70 -616.70 400.09 427.62 400.09
Even 616.60 -616.60 -616.60 -616.60 -616.60 90.83 173.67 90.83 b
Redist M All 694.87 -694.87 -694.87 -694.87 -694.87 373.49 406.24 373.49 1.182
Odd 694.87 -694.87 -694.87 -694.87 -694.87 373.49 406.24 373.49 0.934
Even 694.87 -694.87 -694.87 -694.87 -694.87 55.85 182.36 63.58 0.700
Project Spreadsheets to BS 8110
Location Level 2, Beam on line 6 ANALYSIS IV
SUBFRAME ANALYSIS to BS8110:2005 Made by RMW Job No R68
Originated from RCC21.xls v4.2 on CD 2006 TCC Date 31-May-17

SPAN 4 Left < > PL1 < > PL2 < > Right Loadings 0 0
Elastic V All 203.41 0 136.49 0 9.64 0 76.35 33.46 43.2 35.8 0
Odd 145.53 0 110.53 0 42.78 100 -11.53 17.5 24 5 0
Even 161.36 0 94.44 100 -32.41 0 118.40 33.46 43.2 35.8 0
Redist V All 204.73 0 137.81 0 10.96 0 75.03 6
Odd 142.19 0 107.19 0 39.44 100 -8.19
Even 163.09 0 96.17 100 -30.68 0 116.67
Elastic X- All 0.000 2.000 0.000 4.500 3.718 3.718 3.718 3.718
Odd 0.000 2.000 0.000 4.500 6.000 6.659 6.659 6.659
Even 0.000 2.000 3.531 4.500 2.461 2.461 2.461 2.461
Redist X- All 0.000 2.000 0.000 4.500 3.757 3.757 3.757 3.757
Odd 0.000 2.000 0.000 4.500 6.000 (3.2.2.1b) 6.468 6.468 6.468
Even 0.000 2.000 3.583 4.500 2.513 Max 2.513 2.513 2.513
Elastic M All 398.05 -398.05 -58.14 -398.05 70.53 52.77 6.34 70.53
Odd 427.62 -427.62 -171.55 -427.62 -9.91 27.07 -27.07 27.07
Even 173.67 -173.67 82.13 121.37 105.67 102.21 34.29 121.37 b
Redist M All 406.24 -406.24 -63.70 -406.24 68.25 50.89 6.66 68.25 0.968
Odd 406.24 -406.24 -156.85 -406.24 -3.55 28.42 -28.42 28.42 1.050
Even 182.36 -182.36 76.91 118.85 104.79 99.69 32.57 118.85 0.979

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 0.000 0.000 0.000
Odd 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000
Even 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000
Redist X- All 0.000 0.000 0.000 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) 0.000 0.000 0.000
Even 0.000 0.000 0.000 0.000 0.000 Max 0.000 0.000 0.000
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 0.000 0.000 0.000
Odd 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000
Even 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000
Redist X- All 0.000 0.000 0.000 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) 0.000 0.000 0.000
Even 0.000 0.000 0.000 0.000 0.000 Max 0.000 0.000 0.000
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 Spreadsheets to BS 8110
Location Level 2, Beam on line 6 GRAPH DATA I
SUBFRAME ANALYSIS to BS8110:2005 Made by RMW Job No R68
Originated from RCC21.xls v4.2 on CD 2006 TCC Date 31-May-17

LOADING DIAGRAM 26.043

BEAM 0 37
0 0
SUPPORTS 0 0 7 7 19 19 31 31 37 37 37 37 37 37
-80.73 76.825 -80.73 78.128 -80.73 0 -26 0 -80.73 104.17 -26 26.043 -26 26.043
D UDL 0 0 7 7 7 19 19 19 31 31 31 37 37 37 37 37 37 37 37
0 32.2 32.2 0 32.2 32.2 0 24.42 24.42 0 17.5 17.5 0 0 0 0 0 0 0
L UDL 32.2 44.7 44.7 32.2 44.7 44.7 32.2 33.07 33.07 24.42 23.1 23.1 17.5 0 0 0 0 0 0
D PUDL 0 0 0 0 7 7 7 7 20.5 20.5 22.9 22.9 31 31 31 31 37 37 37 37 37 37 37 37
44.7 44.7 44.7 44.7 44.7 44.7 44.7 44.7 33.07 40.57 40.57 33.07 23.1 23.1 23.1 23.1 0 0 0 0 0 0 0 0
L PUDL 44.7 44.7 44.7 44.7 44.7 44.7 44.7 44.7 33.07 37.57 37.57 33.07 23.1 23.1 23.1 23.1 0 0 0 0 0 0 0 0
PL 1 0 0 7 7 19 19 33 33 37 37 37 37
44.7 44.7 44.7 44.7 33.07 33.07 23.1 47.1 0 0 0 0
44.7 44.7 44.7 44.7 33.07 33.07 47.1 53.1 0 0 0 0
PL 2 0 0 12 12 19 19 35.5 35.5 37 37 37 37
44.7 44.7 44.7 69.7 33.07 33.07 23.1 28.1 0 0 0 0
44.7 44.7 69.7 94.7 33.07 33.07 28.1 46.1 0 0 0 0

MOMENT DIAGRAMS
SPAN 1 at col face
X 0 0 0.35 0.7 1.05 1.4 1.75 2.1 2.45 2.8 3.15 3.5 3.85 4.2 4.55 4.9 5.25 5.6 5.95 6.3 6.65 7 0.2 6.85
M(e) all 0 36 -10 -48.13 -78.23 -100 -115 -121 -119 -109 -91.45 -65.75 -32.08 9.5667 59.184 116.77 182.33 255.87 337.37 426.85 524.3 629.73 8.7118 583.57
M(e) odd 0 95.304 32.439 -22.46 -69.38 -108 -139 -162 -177 -184 -183 -175 -158 -133 -100 -59.34 -10.59 46.126 110.82 183.48 264.12 352.72 58.405 313.77
M(e) even 0 -39 -45.65 -48.39 -47.19 -42 -32.95 -19.91 -2.925 18 42.872 71.688 104.45 141.15 181.8 226.4 274.93 327.42 383.84 444.22 508.53 576.79 -43.27 547.05
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 37.803 -11.95 -53.73 -87.54 -113 -131 -141 -143 -137 -123 -101 -71 -33.06 12.856 66.743 128.6 198.43 276.24 362 455.76 557.48 8.3965 512.91
M(r) odd 0 90.539 32.321 -17.93 -60.2 -94.5 -121 -139 -150 -152 -146 -133 -111 -81.91 -44.46 0.9579 54.352 115.72 185.06 262.37 347.65 440.9 56.295 400
M(r) even 0 -40.91 -48.47 -52.08 -51.74 -47.46 -39.23 -27.06 -10.95 9.1091 33.112 61.06 92.952 128.79 168.57 212.3 260 311.58 367.14 426.64 490.09 557.48 -45.71 528.12
70% max 0 66.713 22.707 -15.72 -33 -29.43 -23.06 -13.94 -2.048 12.601 30.011 50.182 73.114 98.807 127.26 158.48 192.45 229.19 268.69 311 367 440.81 40.883 408.5
70% min 0 -27.28 -32 -33.87 -54.76 -75.83 -97.51 -114 -124 -129 -128 -122 -110 -93 -70.08 -41.54 -7.415 32.288 77.572 128.44 184.88 246.91 -30.29 219.64
Lower bound 0 -40.91 -48.47 -53.73 -87.54 -113 -131 -141 -150 -152 -146 -133 -111 -93 -70.08 -41.54 -7.415 0 0 0 0 0 -45.71 219.64
Upper bound 0 90.539 32.321 0 0 0 0 0 0 12.601 33.112 61.06 92.952 128.79 168.57 212.3 260 311.58 367.14 426.64 490.09 557.48 56.295 528.12
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
SPAN 2
Local X 0 0.6 1.2 1.8 2.4 3 3.6 4.2 4.8 5.4 6 6.6 7.2 7.8 8.4 9 9.6 10.2 10.8 11.4 12 0.15 11.8
X 7 7.6 8.2 8.8 9.4 10 10.6 11.2 11.8 12.4 13 13.6 14.2 14.8 15.4 16 16.6 17.2 17.8 18.4 19
M(e) all 743.31 500.75 281.62 85.918 -86.36 -235 -361 -463 -541 -566 -553 -516 -456 -373 -266 -135 18.806 196.11 396.84 621 868.58 680.48 783.45
M(e) odd 353.66 245.35 148.64 63.521 -10 -71.94 -122 -161 -188 -194 -183 -160 -126 -80.12 -22.73 46.254 126.83 219 322.76 438.11 565.05 325.49 521.45
M(e) even 740.85 491.22 265 62.234 -117 -273 -406 -515 -600 -632 -626 -597 -543 -467 -367 -244 -96.84 73.384 267 484.12 724.64 676.25 641.86
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 557.48 315.53 97 -98.09 -270 -418 -543 -644 -722 -747 -733 -695 -635 -550 -443 -312 -157 20.574 221.91 446.67 694.87 494.8 609.53
M(r) odd 442.07 335 239.51 155.62 83.326 22.62 -26.49 -64 -89.95 -94.29 -82 -58.19 -22.75 24.281 82.902 153.12 234.92 328.32 433.31 549.89 678.06 414.22 634.05
M(r) even 557.48 315.53 97 -98.09 -270 -418 -543 -644 -722 -747 -733 -695 -635 -550 -443 -312 -157 20.574 221.91 446.67 694.87 494.8 609.53
70% max 520.32 350.53 197.13 60.143 -7.005 -50.36 -85.6 -113 -132 -136 -128 -112 -88.14 -56.08 -15.91 32.378 88.781 153.3 277.79 434.7 608 476.33 548.41
70% min 247.56 171.75 104 43.564 -82 -191 -284 -360 -420 -443 -438 -418 -380 -327 -257 -171 -67.79 51.369 186.93 306.68 395.54 227.85 365
Lower bound 0 0 0 -98.09 -270 -418 -543 -644 -722 -747 -733 -695 -635 -550 -443 -312 -157 0 0 0 0 227.85 365
Upper bound 557.48 350.53 239.51 155.62 83.326 22.62 0 0 0 0 0 0 0 24.281 82.902 153.12 234.92 328.32 433.31 549.89 694.87 494.8 634.05
Beam 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 0 0.6 1.2 1.8 2.4 3 3.6 4.2 4.8 5.4 6 6.6 7.2 7.8 8.4 9 9.6 10.2 10.8 11.4 12 0.2 12
X 19 19.6 20.2 20.8 21.4 22 22.6 23.2 23.8 24.4 25 25.6 26.2 26.8 27.4 28 28.6 29.2 29.8 30.4 31
M(e) all 828.33 622.81 434.58 264.43 117.15 -6.47 -106 -184 -243 -284 -309 -316 -306 -278 -233 -171 -92.12 4.491 118.39 249.57 398.05 757.9 398.05
M(e) odd 616.7 423.23 247.06 88.976 -46.25 -158 -246 -311 -358 -387 -400 -395 -373 -333 -276 -202 -111 -2.123 123.83 267.08 427.62 550.29 427.62
M(e) even 616.6 502.57 397.33 301.21 216.25 142.79 80.81 29.987 -11.71 -44.61 -68.72 -84 -90.57 -88.31 -77.26 -57.41 -28.78 8.6467 54.864 109.87 173.67 577.61 173.67
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 694.87 496.42 315.27 152.21 12.012 -105 -197 -267 -319 -354 -371 -371 -354 -320 -268 -199 -112 -8.571 112.41 250.68 406.24 626.8 406.24
M(r) odd 694.87 496.42 315.27 152.21 12.012 -105 -197 -267 -319 -354 -371 -371 -354 -320 -268 -199 -112 -8.571 112.41 250.68 406.24 626.8 406.24
M(r) even 694.87 577.35 468.63 369 280.6 203.66 138.2 83.898 38.724 2.342 -25.25 -44 -54.06 -55.27 -47.7 -31.34 -6.18 27.767 70.506 122 182.36 654.72 182.36
70% max 579.83 436 304.2 210.85 151.38 99.951 56.567 20.991 -8.195 -31.23 -48.11 -58.83 -63.4 -61.82 -54.08 -40.19 -20.15 6.0527 86.684 187 299.33 530.53 299.33
70% min 431.62 296.26 172.94 62.283 -32.37 -110 -172 -218 -250 -271 -280 -276 -261 -233 -193 -142 -77.55 -1.486 38.405 76.911 121.57 385.2 121.57
Lower bound 0 0 0 0 -32.37 -110 -197 -267 -319 -354 -371 -371 -354 -320 -268 -199 -112 -8.571 0 0 0 385.2 121.57
Upper bound 694.87 577.35 468.63 369 280.6 203.66 138.2 83.898 38.724 2.342 0 0 0 0 0 0 0 27.767 112.41 250.68 406.24 654.72 406.24
Beam 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Project Spreadsheets to BS 8110
Location Level 2, Beam on line 6 GRAPH DATA II
SUBFRAME ANALYSIS to BS8110:2005 Made by RMW Job No R68
Originated from RCC21.xls v4.2 on CD 2006 TCC Date 31-May-17

SPAN 4
Local X 0 0.3 0.6 0.9 1.2 1.5 1.8 2.1 2.4 2.7 3 3.3 3.6 3.9 4.2 4.5 4.8 5.1 5.4 5.7 6 0 5.85
X 31 31.3 31.6 31.9 32.2 32.5 32.8 33.1 33.4 33.7 34 34.3 34.6 34.9 35.2 35.5 35.8 36.1 36.4 36.7 37
M(e) all 398.05 338.53 282 228.53 178 130.57 86.109 48.979 23.5 1.0328 -18.42 -34.87 -48.3 -58.72 -66.13 -70.53 -61.18 -48.82 -33.44 -15.05 6.3433 398.05 -4.732
M(e) odd 427.62 384.74 343.45 303.73 265.58 229 194 163 138.34 115.27 93.773 73.851 55.504 38.733 23.536 9.9139 -0.633 -9.605 -17 -22.82 -27.07 427.62 -25.14
M(e) even 173.67 126.77 82.879 42 4.1308 -30.73 -62.57 -87.09 -99.95 -110 -117 -120 -121 -119 -114 -106 -83.7 -58.72 -30.73 0.2714 34.285 173.67 16.902
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 406.24 346.32 289.42 235.53 184.66 136.79 91.934 54.411 28.538 5.6775 -14.17 -31 -44.84 -55.65 -63.46 -68.25 -59.29 -47.32 -32.34 -14.34 6.6604 406.24 -4.218
M(r) odd 406.24 364.37 324.07 285.35 248.2 212.63 178.64 148.62 125 102.9 82.406 63.485 46.14 30.369 16.174 3.5535 -5.992 -14 -20.36 -25.18 -28.42 406.24 -27
M(r) even 182.36 134.93 90.523 49.123 10.735 -24.64 -57 -82 -95.42 -106 -113 -118 -119 -117 -112 -105 -83.34 -58.88 -31.41 -0.923 32.571 182.36 15.448
70% max 299.33 269.32 240.41 212.61 185.91 160.31 135.81 114.09 96.839 80.689 65.641 51.696 38.853 27.113 16.475 6.9397 -0.443 -6.723 -11.9 0.19 24 299.33 11.831
70% min 121.57 88.739 58.015 29.399 2.8915 -21.51 -43.8 -61 -70 -76.86 -81.65 -84.33 -84.9 -83.36 -79.72 -74 -58.59 -41.11 -23.41 -16 -18.95 121.57 -17.6
Lower bound 0 0 0 0 0 -24.64 -57 -82 -95.42 -106 -113 -118 -119 -117 -112 -105 -83.34 -58.88 -32.34 -25.18 -28.42 121.57 -27
Upper bound 406.24 364.37 324.07 285.35 248.2 212.63 178.64 148.62 125 102.9 82.406 63.485 46.14 30.369 16.475 6.9397 0 0 0 0.19 32.571 406.24 15.448
Beam 0 0 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.15 0
X 37 37 37 37 37 37 37 37 37 37 37 37 37 37 37 37 37 37 37 37 37
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
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 37 37 37 37 37 37 37 37 37 37 37 37 37 37 37 37 37 37 37 37 37 37
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

SHEAR FORCE DIAGRAMS

SPAN 1 SPAN 2 SPAN 3 SPAN 4 SPAN 5 SPAN 6
Local X 0 0 0 0 0 0 7 0 0 0 5 5 12 0.00 0 0 0 0 12 0 2 2 4.5 4.5 6 0 0 0 0 0 0 0 0 0 0 0 0 0
X 0 0 0 0 0 0 7 7 7 7 12 12 19 19.00 19 19 19 19 31 31 33 33 35.5 35.5 37 37 37 37 37 37 37 37 37 37 37 37 37 37
V(e) all 0 143 143 143 143 143 -313 423.79 423.79 423.79 98.391 23.391 -432 356.95 356.95 356.95 356.95 356.95 -262 203.41 136.49 93.294 9.6445 -26.16 -76.35 0 0 0 0 0 0 0 0 0 0 0 0 0
V(e) odd 0 191 191 191 191 191 -265 190.17 190.17 190.17 29.167 4.167 -221 336.85 336.85 336.85 336.85 336.85 -282 145.53 110.53 86.531 42.781 37.781 11.531 0 0 0 0 0 0 0 0 0 0 0 0 0
V(e) even 0 24.735 24.735 24.735 24.735 24.735 -201 435.58 435.58 435.58 110.18 35.181 -420 197.38 197.38 197.38 197.38 197.38 -114 161.36 94.441 51.241 -32.41 -68.21 -118 0 0 0 0 0 0 0 0 0 0 0 0 0
V(r) all 0 153.54 153.54 153.54 153.54 153.54 -302 422.78 422.78 422.78 97.382 22.382 -433 345.14 345.14 345.14 345.14 345.14 -274 204.73 137.81 94.606 10.956 -24.84 -75 0 0 0 0 0 0 0 0 0 0 0 0 0
V(r) odd 0 177.73 177.73 177.73 177.73 177.73 -278 188.12 188.12 188.12 27.117 2.1173 -223 345.14 345.14 345.14 345.14 345.14 -274 142.19 107.19 83.193 39.443 34.443 8.1933 0 0 0 0 0 0 0 0 0 0 0 0 0
V(r) even 0 27.214 27.214 27.214 27.214 27.214 -198 422.78 422.78 422.78 97.382 22.382 -433 203.18 203.18 203.18 203.18 203.18 -108 163.09 96.174 52.974 -30.68 -66.48 -117 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.00 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 7 7 19 19 31 31 37 37 37 37 37 37
-633 912 -633 912 -633 912 -633 912 -633 912 -633 912 -633 912
-747 729.61 -747 729.61 -747 729.61 -747 729.61 -747 729.61 -747 729.61 -747 729.61
Disclaimer
All advice or information from MPA-The Concrete Centre is intended for those who will evaluate the significance and limitations of its
contents and take responsibility for its use and application. No liability (including that for negligence) for any loss resulting from such advice
or information is accepted by MPA-The Concrete Centre or its subcontractors, suppliers or advisors. Users should note that all MPA-The
Concrete Centre software and publications are subject to revision from time to time and they should therefore ensure that they are in
possession of the latest version.

This spreadsheet should be used in compliance with the accompanying publication 'User Guide RC Spreadsheets: v4' available from The
Concrete Centre www.concretecentre.com/rcdesign Tel +44 (0)1276 606800

Status of spreadsheet This spreadsheet is shareware but may not be used for commercial purposes until the
Public release version. user has registered with The Concrete Centre using the licence validation form available
on The Concrete Centre website www.concretecentre.com/rcdesign
Revision history RCC21 Subframe Analysis

Date Version Action Size (kB)

21-May-14 RCC21 v4.1 Correction to callup of redistributed support moments on ACTIONS. 973

10-Nov-10 RCC21 v4.1 Correction to elastic moment at support 7. Markers removed from loading diagram. 999

30-Mar-10 RCC21 v4.0 Re-badged as TCC/Mineral Products Association. 969

28-Jun-06 RCC21 v3.1 v3 release. Page nos, User Guide and registration details amended. 827
21-Oct-05 RCC21 v3.0 Updated to 2005 version of BS8110 852
3-Dec-04 RCC21 v2.2 Algorithms added for reverse support moments and shears. 829
21-Jan-03 RCC21 v2.1 DETR logo replaced by DTI. 843
11-Oct-02 RCC21 v2.0 Version 2 enhancements 848
6-Dec-01 RCC21 v1.3 kNm/m changed to kNm in ACTIONS!J23:J26. 756
5-May-01 RCC21 v1.2 Warning message corrected in MAIN:L39 etc 756
28-Sep-99 RCC21 v1.1 UCL comments incorporated 756
First public release
4-Aug-99 RCC21 v1.0 766
Incorporates beta version comments.