rcc subframe analysis
TRANSCRIPT
Project Spreadsheets to BS 8110 & EC2REINFORCED CONCRETE
COUNCIL
Client Advisory Group Made by Date Sheet No
Location Spine Beam - SCHEME 4 rmw 30-Apr-2014 146
Checked Revision Job No
chg - R68
SPANS LOCATION from grid C to grid E
L (m) Segment (m) H (mm) bw (mm) hf (mm) Type bf (mm)
SPAN 1 6.000 3.200 600 400 R 400 on LHS of span
2.800 500 666 150 T 1506 on RHS of span
SPAN 2 7.200 5.400 600 400 R 400 on LHS of span
1.800 450 400 R 400 on RHS of span
SPAN 3 6.000 6.000 450 400 R 400
SPAN 4 7.200 7.200 600 400 R 400
SPAN 5
SPAN 6
SUPPORTS
Length (m) H (mm) B (mm) End Cond Length (m) H (mm) B (mm) End Cond
Support 1 K 300
Support 2 3.600 450 450 F 4.500 450 450 F
Support 3 3.600 400 400 F 4.500 400 400 F
Support 4 3.600 400 400 F 4.500 400 400 F
Support 5 3.600 400 400 F 4.500 400 400 F
Support 6
Support 7
LOADING DIAGRAM
LOADING PATTERN
min max
DEAD 1.0 1.35
IMPOSED 1.5
LOADING (characteristic)
Dead Imposed Position Loaded Dead Imposed Position Loaded
Span 1 Load Load from left Length Span 4 Load Load from left Length
UDL 97.27 36.00 ~~~~~ ~~~~~ UDL 97.27 36.00 ~~~~~ ~~~~~
PL 1 ~~~~~ PL 1 ~~~~~
PL 2 ~~~~~ PL 2 ~~~~~
Part UDL Part UDL
Span 2 Span 5
UDL 50.00 25.00 ~~~~~ ~~~~~ UDL ~~~~~ ~~~~~
PL 1 72 30 6.750 ~~~~~ PL 1 ~~~~~
PL 2 ~~~~~ PL 2 ~~~~~
Part UDL 47.27 11.00 0.750 4.800 Part UDL
Span 3 Span 6
UDL ~~~~~ ~~~~~ UDL ~~~~~ ~~~~~
PL 1 ~~~~~ PL 1 ~~~~~
PL 2 ~~~~~ PL 2 ~~~~~
Part UDL Part UDL
REACTIONS
SUPPORT 1 2 3 4 5
MAX ULTIMATE 413.7 1365.2 645.0 705.3 664.3
MIN ULTIMATE 172.9 741.9 240.3 341.9 339.1
Characteristic Dead 210.1 723.8 303.8 360.5 344.6
Char. Imposed 86.7 258.7 156.6 146.9 132.7
ABOVE BELOW
SUBFRAME ANALYSIS TO EC2 (DD ENV 1992-1-1 : 1992)
Originated from RCCe21.xls' on CD © 1999 BCA for RCC
Project Spreadsheets to BS 8110 & EC2REINFORCED CONCRETE
COUNCIL
Client Advisory Group Made by Date Page
Location Spine Beam - SCHEME 4, from C to E rmw 30-Apr-14 147
SUBFRAME ANALYSIS TO EC2 (DD ENV 1992-1-1 : 1992) Checked Revision Job No
Originated from RCCe21.xls' on CD © 1999 BCA for RCC chg - R68
BENDING MOMENTS (kNm ultimate)
C Elastic Moments E C Redistributed Envelope E
SUPPORT No 1 2 3 4 5
Elastic M 994.9 534.5 620.5 528.6 ~ ~ kNm
Redistributed M 895.4 534.5 496.4 475.7 ~ ~ kNm
Column face M -18.5 751.0 410.7 366.1 346.6 ~ ~
ßb 1.000 0.900 1.000 0.800 0.900 ~ ~
Redistribution 10.0% 10.0% 20.0% 10.0%
SPAN No 1 2 3 4
Elastic M 491.01 468.03 11.26 636.29 ~ ~ kNm
Redistributed M 461.68 481.84 11.26 714.81 ~ ~ kNm
ßb 0.940 1.030 1.000 1.123 ~ ~
SHEARS (kN ultimate)
C Elastic Shears E C Redistributed Shears E
SPAN No 1 2 3
Elastic V 426.6 711.4 673.9 631.6 16.2 29.7 kN
Redistributed V 413.7 705.2 660.1 629.8 15.2 35.3 kN
SPAN No 4
Elastic V 680.7 657.1 kN
Redistributed V 670.0 664.3 kN
COLUMN Ms (kNm ultimate) 1 2 3 4 5
ADJACENT SPANS Above 34.5 -225.4 253.7 -290.5
LOADED Below 27.6 -180.3 202.9 -232.4
ODD SPANS Above -78.1 -98.6 136.3 -153.5
LOADED Below -62.5 -78.9 109.0 -122.8
EVEN SPANS Above 132.4 -239.6 265.0 -139.8
LOADED Below 105.9 -191.7 212.0 -234.9
-1000
-800
-600
-400
-200
0
200
400
600
800
1000
1200
0 5 10 15 20 25 30
-1000
-800
-600
-400
-200
0
200
400
600
800
1000
1200
0 5 10 15 20 25 30
-800
-600
-400
-200
0
200
400
600
800
0 5 10 15 20 25 30
-800
-600
-400
-200
0
200
400
600
800
0 5 10 15 20 25 30
Project Spreadsheets to BS 8110 & EC2
Location Advisory Group ANALYSIS ISUBFRAME ANALYSIS TO EC2 (DD ENV 1992-1-1 : 1992) Made by rmw Job No R68
Originated from RCCe21.xls' on CD © 1999 BCA for RCC Date
ANALYSISMin load 1 x dead load
Live load 0.35 x dead load + 1.5 x imposed load (Table 3.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
I 0 0 6.42E+09 1.06E+10 3.42E+09 3.42E+09 8.5E+09 3.82E+09 2.13E+09 2.13E+09 3.04E+09
Stiffness 0 0 1.07E+09 1.76E+09 9.49E+08 7.59E+08 1.18E+09 5.3E+08 5.93E+08 4.74E+08 5.06E+08
Sum 1.07E+09 ######## ########
Factor 0 0 1 0.37866 0.20413 0.1633 0.2539 0.25213 0.28176 0.22541 0.24071
SUPT 4 SUPT 5 SUPT 6
L Up col Lo col R L Up col Lo col R L Up col Lo col R
I 3.04E+09 2.13E+09 2.13E+09 7.2E+09 7.2E+09 2.13E+09 2.13E+09 0 0 0 0 0
Stiffness 5.06E+08 5.93E+08 4.74E+08 1E+09 1E+09 5.93E+08 4.74E+08 0 0 0 0 0
Sum 2.6E+09 2.1E+09 0
Factor 0.19676 0.23032 0.18426 0.38866 0.48387 0.28674 0.22939 0 1 0 0 0
SUPT 7
L Up col Lo col
I #DIV/0! 0 0 Partial UDL factorsStiffness 0 0 0 1 2 3 4 5 6
Sum 0 a 0 0.66667 0 0 #DIV/0! #DIV/0!
Factor 0 0 0 b 0 0.4375 0 0 #DIV/0! #DIV/0!
Fixed End MomentsSPAN 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 1750.86 2496.72 0 2521.24 0 0
UDL 238.232 345.388 256.321 175.679 0 0 420.206 420.206 0 0 0 0
PL 1 0 0 7.60182 22.7732 0 0 0 0 0 0 0 0
PL 2 0 0 0 0 0 0 0 0 0 0 0 0
part UDL 0.0 0.0 230.3 141.8 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
FEM 238.2 345.4 494.2 340.3 0.0 0.0 420.2 420.2 0.0 0.0 0.0 0.0
Live load
Cant 1584.8 2399.1 0.0 2282.1 0.0 0.0
UDL 215.6 312.6 282.0 193.2 0.0 0.0 380.4 380.4 0.0 0.0 0.0 0.0
PL 1 0.0 0.0 7.4 22.2 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
PL 2 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
part UDL 0.0 0.0 161.0 99.2 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
FEM 215.6 312.6 450.4 314.6 0.0 0.0 380.4 380.4 0.0 0.0 0.0 0.0
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
Min load -238.232 345.388 -494.234 340.302 0 0 -420.206 420.2064 0 0 0 0
0 238.232 0 30.3839 56.3624 37.7923 24.3071 -95.883 -85.7996 -81.9126 -76.7064 96.7817 82.68029 163.3191 77.42534 -120.489 -203.3257 0 -96.3914 0 0 0 0 0 0
28.1812 119.116 -42.8998 18.8962 41.3401 -40.9563 -101.663 81.65954 0 0 0 0
0 -28.1812 0 -15.558 -28.8602 -19.3514 -12.4464 -16.9721 -15.1873 -14.4992 -13.5777 32.8479 28.0619 55.43091 26.27836 -23.4149 -39.51268 0 -18.7319 0 0 0 0 0 0
-14.4301 -14.0906 -7.59363 -9.67572 14.031 -7.24961 -19.7563 27.71546 0 0 0 0
0 14.4301 0 4.42641 8.21103 5.50568 3.54113 -1.22712 -1.09808 -1.04833 -0.9817 6.21999 5.313722 10.49624 4.975996 -7.94708 -13.41071 0 -6.35767 0 0 0 0 0 0
4.10551 7.21505 -0.54904 2.75284 2.65686 -0.52416 -6.70535 5.248121 0 0 0 0
0 -4.10551 0 -1.36073 -2.52417 -1.69252 -1.08859 -1.52423 -1.36394 -1.30215 -1.21939 1.6651 1.422488 2.809853 1.332078 -1.50484 -2.539413 0 -1.20387 0 0 0 0 0 0
-1.26209 -2.05276 -0.68197 -0.84626 0.71124 -0.65107 -1.26971 1.404926 0 0 0 0
0 1.26209 0 0.55824 1.03554 0.69435 0.44659 0.03804 0.03404 0.0325 0.03043 0.44239 0.377935 0.746538 0.353914 -0.40285 -0.679803 0 -0.32228 0 0 0 0 0 0
0.51777 0.63104 0.01702 0.34718 0.18897 0.016249 -0.3399 0.373269 0 0 0 0
0 -0.51777 0 -0.13229 -0.2454 -0.16455 -0.10583 -0.15106 -0.13518 -0.12905 -0.12085 0.07454 0.063682 0.125792 0.059635 -0.10703 -0.180614 0 -0.08562 0 0 0 0 0 0
-0.1227 -0.25889 -0.06759 -0.08227 0.03184 -0.06453 -0.09031 0.062896 0 0 0 0
0 0.1227 0 0.06664 0.12362 0.08289 0.05331 0.01421 0.01272 0.01214 0.01137 0.03566 0.030465 0.060178 0.028529 -0.01803 -0.030434 0 -0.01443 0 0 0 0 0 0
Sum 0.0 0.0 0.0 18.4 490.1 -523.1 14.7 -115.7 248.2 -39.9 -92.6 138.1 68.5 -317.0 110.5 -153.9 277.0 0.0 -123.1 0.0 0.0 0.0 0.0 0.0 0.0
30-Apr-14
Project Spreadsheets to BS 8110 & EC2
Location Advisory Group ANALYSIS IISUBFRAME ANALYSIS TO EC2 (DD ENV 1992-1-1 : 1992) Made by rmw Job No R68
Originated from RCCe21.xls' on CD © 1999 BCA for RCC Date
Moment Distribution contLive on -215.637 312.63 -450.366 314.612 0 0 0 0
1,2, 5 & 6 0 215.637 0 28.116 52.1555 34.9715 22.4928 -88.6447 -79.3225 -75.7289 -70.9157 0 0 0 0 0 0 0 0 0 0 0 0 0 0
26.0777 107.818 -39.6612 17.4857 0 -37.8644 0 0 0 0 0 0
0 -26.0777 0 -13.9129 -25.8086 -17.3053 -11.1303 -4.92676 -4.40865 -4.20892 -3.94141 8.72091 7.450249 14.71654 6.976731 0 0 0 0 0 0 0 0 0 0
-12.9043 -13.0389 -2.20432 -8.65264 3.72512 -2.10446 0 7.35827 0 0 0 0
0 12.9043 0 3.1116 5.77204 3.87029 2.48928 1.38837 1.24236 1.18608 1.1107 0.4847 0.414076 0.817927 0.387758 -2.1099 -3.560453 0 -1.68792 0 0 0 0 0 0
2.88602 6.45215 0.62118 1.93514 0.20704 0.59304 -1.78023 0.408964 0 0 0 0
0 -2.88602 0 -1.44388 -2.67841 -1.79594 -1.1551 -0.60358 -0.5401 -0.51564 -0.48286 0.27343 0.233592 0.461417 0.218746 -0.11727 -0.197886 0 -0.09381 0 0 0 0 0 0
-1.33921 -1.44301 -0.27005 -0.89797 0.1168 -0.25782 -0.09894 0.230708 0 0 0 0
0 1.33921 0 0.34969 0.64867 0.43495 0.27975 0.2201 0.19696 0.18803 0.17608 0.08217 0.070197 0.13866 0.065735 -0.06615 -0.111633 0 -0.05292 0 0 0 0 0 0
0.32434 0.6696 0.09848 0.21748 0.0351 0.094016 -0.05582 0.06933 0 0 0 0
0 -0.32434 0 -0.15679 -0.29084 -0.19502 -0.12543 -0.07116 -0.06368 -0.0608 -0.05693 -0.0088 -0.00752 -0.01485 -0.00704 -0.01988 -0.033547 0 -0.0159 0 0 0 0 0 0
-0.14542 -0.16217 -0.03184 -0.09751 -0.00376 -0.0304 -0.01677 -0.007423 0 0 0 0
0 0.14542 0 0.0396 0.07346 0.04926 0.03168 0.02853 0.02553 0.02438 0.02283 0.01086 0.009281 0.018334 0.008692 0.002129 0.003592 0 0.001703 0 0 0 0 0 0
Sum 0.0 0.0 0.0 16.1 442.8 -471.8 12.9 -92.6 241.7 -75.0 -74.1 9.6 -31.4 14.2 7.7 -2.3 4.2 0.0 -1.8 0.0 0.0 0.0 0.0 0.0 0.0
Live on 0 0 -380.352 380.3522
3 & 4 0 0 0 0 0 0 0 0 0 0 0 87.6025 74.83854 147.8292 70.082 -109.062 -184.0414 0 -87.2493 0 0 0 0 0 0
0 0 0 0 37.4193 0 -92.0207 73.91461 0 0 0 0
0 0 0 0 0 0 0 -10.5432 -9.43445 -9.00703 -8.43457 21.1942 18.1061 35.76513 16.95532 -21.1942 -35.76513 0 -16.9553 0 0 0 0 0 0
0 0 -4.71723 0 9.05305 -4.50352 -17.8826 17.88257 0 0 0 0
0 0 0 0.96293 1.78624 1.19772 0.77034 -2.55078 -2.28253 -2.17912 -2.04062 5.15595 4.404711 8.700664 4.124759 -5.12762 -8.652854 0 -4.10209 0 0 0 0 0 0
0.89312 0 -1.14126 0.59886 2.20236 -1.08956 -4.32643 4.350332 0 0 0 0
0 -0.89312 0 0.23297 0.43215 0.28977 0.18637 -0.78927 -0.70626 -0.67427 -0.63141 1.24741 1.065656 2.104999 0.997926 -1.24741 -2.104999 0 -0.99793 0 0 0 0 0 0
0.21608 -0.44656 -0.35313 0.14488 0.53283 -0.33713 -1.0525 1.0525 0 0 0 0
0 -0.21608 0 0.16324 0.30281 0.20304 0.13059 -0.19095 -0.17087 -0.16313 -0.15276 0.32006 0.273426 0.540101 0.256048 -0.30179 -0.509274 0 -0.24143 0 0 0 0 0 0
0.15141 -0.10804 -0.08544 0.10152 0.13671 -0.08156 -0.25464 0.27005 0 0 0 0
0 -0.15141 0 0.03949 0.07326 0.04912 0.0316 -0.06712 -0.06007 -0.05734 -0.0537 0.07743 0.066151 0.130669 0.061947 -0.07743 -0.130669 0 -0.06195 0 0 0 0 0 0
0.03663 -0.0757 -0.03003 0.02456 0.03308 -0.02867 -0.06533 0.065335 0 0 0 0
0 -0.03663 0 0.02158 0.04004 0.02685 0.01727 -0.01624 -0.01453 -0.01387 -0.01299 0.02165 0.018497 0.036537 0.017321 -0.01873 -0.031614 0 -0.01499 0 0 0 0 0 0
Sum 0.0 0.0 0.0 1.4 2.0 -4.6 1.1 -14.2 -11.8 37.3 -11.3 115.6 92.7 -300.8 92.5 -137.0 246.7 0.0 -109.6 0.0 0.0 0.0 0.0 0.0 0.0
Live on -450.366 314.612 0 0 0 0
2, 3 & 6 0 0 0 91.9333 170.537 114.349 73.5466 -88.6447 -79.3225 -75.7289 -70.9157 0 0 0 0 0 0 0 0 0 0 0 0 0 0
85.2685 0 -39.6612 57.1745 0 -37.8644 0 0 0 0 0 0
0 -85.2685 0 8.09605 15.0183 10.0701 6.47684 -16.1094 -14.4153 -13.7622 -12.8876 8.72091 7.450249 14.71654 6.976731 0 0 0 0 0 0 0 0 0 0
7.50913 -42.6343 -7.20766 5.03505 3.72512 -6.88112 0 7.35827 0 0 0 0
0 -7.50913 0 10.1742 18.8733 12.655 8.13939 -2.46826 -2.20869 -2.10862 -1.9746 1.58486 1.353937 2.674444 1.267885 -2.1099 -3.560453 0 -1.68792 0 0 0 0 0 0
9.43665 -3.75456 -1.10434 6.3275 0.67697 -1.05431 -1.78023 1.337222 0 0 0 0
0 -9.43665 0 0.99185 1.83989 1.23369 0.79348 -1.97357 -1.76602 -1.68602 -1.57886 0.65285 0.557727 1.101683 0.522279 -0.38343 -0.647043 0 -0.30675 0 0 0 0 0 0
0.91994 -4.71833 -0.88301 0.61684 0.27886 -0.84301 -0.32352 0.550841 0 0 0 0
0 -0.91994 0 1.1434 2.12102 1.42219 0.91472 -0.25237 -0.22583 -0.2156 -0.2019 0.26867 0.229528 0.453388 0.214939 -0.15795 -0.266536 0 -0.12636 0 0 0 0 0 0
1.06051 -0.45997 -0.11292 0.7111 0.11476 -0.1078 -0.13327 0.226694 0 0 0 0
0 -1.06051 0 0.11694 0.21693 0.14546 0.09356 -0.23269 -0.20822 -0.19879 -0.18615 0.05552 0.047433 0.093695 0.044418 -0.065 -0.109691 0 -0.052 0 0 0 0 0 0
0.10847 -0.53026 -0.10411 0.07273 0.02372 -0.09939 -0.05485 0.046847 0 0 0 0
0 -0.10847 0 0.12949 0.24021 0.16107 0.10359 -0.02717 -0.02432 -0.02321 -0.02174 0.03552 0.030348 0.059948 0.02842 -0.01343 -0.022668 0 -0.01075 0 0 0 0 0 0
Sum 0.0 0.0 0.0 112.6 156.7 -359.4 90.1 -109.7 286.4 -88.9 -87.8 11.3 -37.2 16.8 9.1 -2.7 4.9 0.0 -2.2 0.0 0.0 0.0 0.0 0.0 0.0
Live on -215.637 312.63 -380.352 380.3522 0 0
1,4 & 5 0 215.637 0 -63.8172 -118.382 -79.3776 -51.0538 0 0 0 0 87.6025 74.83854 147.8292 70.082 -109.062 -184.0414 0 -87.2493 0 0 0 0 0 0
-59.1908 107.818 0 -39.6888 37.4193 0 -92.0207 73.91461 0 0 0 0
0 59.1908 0 -22.009 -40.8269 -27.3754 -17.6072 0.63946 0.57221 0.54629 0.51157 21.1942 18.1061 35.76513 16.95532 -21.1942 -35.76513 0 -16.9553 0 0 0 0 0 0
-20.4134 29.5954 0.28611 -13.6877 9.05305 0.273146 -17.8826 17.88257 0 0 0 0
0 20.4134 0 -6.09971 -11.315 -7.58699 -4.87977 1.30585 1.16852 1.11558 1.04468 4.05579 3.464849 6.844147 3.244633 -5.12762 -8.652854 0 -4.10209 0 0 0 0 0 0
-5.65751 10.2067 0.58426 -3.7935 1.73242 0.557791 -4.32643 3.422074 0 0 0 0
0 5.65751 0 -2.20276 -4.08615 -2.73986 -1.76221 0.58073 0.51965 0.49611 0.46458 0.86799 0.741521 1.464733 0.694392 -0.98124 -1.655842 0 -0.78499 0 0 0 0 0 0
-2.04307 2.82876 0.25983 -1.36993 0.37076 0.248056 -0.82792 0.732366 0 0 0 0
0 2.04307 0 -0.63047 -1.16953 -0.7842 -0.50438 0.28152 0.25192 0.24051 0.22522 0.13355 0.114095 0.225373 0.106843 -0.21 -0.354371 0 -0.168 0 0 0 0 0 0
-0.58477 1.02154 0.12596 -0.3921 0.05705 0.120253 -0.17719 0.112686 0 0 0 0
0 0.58477 0 -0.23424 -0.43451 -0.29135 -0.18739 0.0944 0.08448 0.08065 0.07552 0.01311 0.011202 0.022128 0.01049 -0.03231 -0.054526 0 -0.02585 0 0 0 0 0 0
-0.21726 0.29238 0.04224 -0.14568 0.0056 0.040325 -0.02726 0.011064 0 0 0 0
0 0.21726 0 -0.06831 -0.12671 -0.08496 -0.05465 0.03947 0.03532 0.03372 0.03157 -0.00301 -0.00257 -0.00508 -0.00241 -0.00317 -0.005353 0 -0.00254 0 0 0 0 0 0
Sum 0.0 0.0 0.0 -95.1 288.1 -116.9 -76.0 2.9 -56.4 51.2 2.4 113.9 98.5 -303.5 91.1 -136.6 245.9 0.0 -109.3 0.0 0.0 0.0 0.0 0.0 0.0
Project Spreadsheets to BS 8110 & EC2
Location Advisory Group ANALYSIS IIISUBFRAME ANALYSIS TO EC2 (DD ENV 1992-1-1 : 1992) Made by rmw Job No R68
30-Apr-14
Originated from RCCe21.xls' on CD © 1999 BCA for RCC Date
Moment Distribution contLive on -215.637 312.63 0 0 0 0
Odd Spans 0 215.637 0 -63.8172 -118.382 -79.3776 -51.0538 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
-59.1908 107.818 0 -39.6888 0 0 0 0 0 0 0 0
0 59.1908 0 -22.009 -40.8269 -27.3754 -17.6072 11.1827 10.0067 9.55333 8.94614 0 0 0 0 0 0 0 0 0 0 0 0 0 0
-20.4134 29.5954 5.00333 -13.6877 0 4.776663 0 0 0 0 0 0
0 20.4134 0 -7.06264 -13.1013 -8.78471 -5.65011 3.85663 3.45105 3.2947 3.0853 -1.10016 -0.93986 -1.85652 -0.88013 0 0 0 0 0 0 0 0 0 0
-6.55063 10.2067 1.72552 -4.39235 -0.46993 1.647352 0 -0.928258 0 0 0 0
0 6.55063 0 -2.43573 -4.5183 -3.02963 -1.94858 1.36999 1.22592 1.17038 1.09599 -0.37942 -0.32413 -0.64027 -0.30353 0.266167 0.449157 0 0.212934 0 0 0 0 0 0
-2.25915 3.27532 0.61296 -1.51481 -0.16207 0.58519 0.224579 -0.320133 0 0 0 0
0 2.25915 0 -0.79371 -1.47235 -0.98724 -0.63497 0.47248 0.42279 0.40363 0.37798 -0.18651 -0.15933 -0.31473 -0.1492 0.091794 0.154903 0 0.073436 0 0 0 0 0 0
-0.73617 1.12958 0.21139 -0.49362 -0.07967 0.201817 0.077452 -0.157364 0 0 0 0
0 0.73617 0 -0.27373 -0.50778 -0.34048 -0.21899 0.16153 0.14454 0.13799 0.12922 -0.06432 -0.05495 -0.10854 -0.05146 0.045122 0.076144 0 0.036098 0 0 0 0 0 0
-0.25389 0.36809 0.07227 -0.17024 -0.02747 0.068997 0.038072 -0.054271 0 0 0 0
0 0.25389 0 -0.08989 -0.16675 -0.11181 -0.07191 0.05571 0.04985 0.04759 0.04457 -0.02466 -0.02107 -0.04161 -0.01973 0.015562 0.02626 0 0.012449 0 0 0 0 0 0
Sum 0.0 0.0 0.0 -96.5 286.0 -112.4 -77.2 17.1 -44.6 13.9 13.7 -1.8 5.8 -2.6 -1.4 0.4 -0.8 0.0 0.3 0.0 0.0 0.0 0.0 0.0 0.0
Live on -450.366 314.612 -380.352 380.3522 0 0
Even Spans 0 0 0 91.9333 170.537 114.349 73.5466 -88.6447 -79.3225 -75.7289 -70.9157 87.6025 74.83854 147.8292 70.082 -109.062 -184.0414 0 -87.2493 0 0 0 0 0 0
85.2685 0 -39.6612 57.1745 37.4193 -37.8644 -92.0207 73.91461 0 0 0 0
0 -85.2685 0 8.09605 15.0183 10.0701 6.47684 -26.6527 -23.8498 -22.7693 -21.3221 29.9151 25.55635 50.48167 23.93205 -21.1942 -35.76513 0 -16.9553 0 0 0 0 0 0
7.50913 -42.6343 -11.9249 5.03505 12.7782 -11.3846 -17.8826 25.24084 0 0 0 0
0 -7.50913 0 11.1372 20.6595 13.8527 8.90973 -5.01903 -4.49121 -4.28774 -4.01523 6.7408 5.758648 11.37511 5.392644 -7.23752 -12.21331 0 -5.79001 0 0 0 0 0 0
10.3298 -3.75456 -2.24561 6.92635 2.87932 -2.14387 -6.10665 5.687554 0 0 0 0
0 -10.3298 0 1.22482 2.27204 1.52346 0.97985 -2.76284 -2.47229 -2.36028 -2.21027 1.90026 1.623383 3.206682 1.520205 -1.63084 -2.752042 0 -1.30467 0 0 0 0 0 0
1.13602 -5.16489 -1.23614 0.76173 0.81169 -1.18014 -1.37602 1.603341 0 0 0 0
0 -1.13602 0 1.30664 2.42384 1.62524 1.04531 -0.44333 -0.3967 -0.37873 -0.35466 0.58873 0.502953 0.993488 0.470987 -0.45974 -0.77581 0 -0.36779 0 0 0 0 0 0
1.21192 -0.56801 -0.19835 0.81262 0.25148 -0.18937 -0.38791 0.496744 0 0 0 0
0 -1.21192 0 0.15644 0.29019 0.19458 0.12515 -0.29982 -0.26829 -0.25613 -0.23985 0.13296 0.113584 0.224364 0.106365 -0.14244 -0.24036 0 -0.11395 0 0 0 0 0 0
0.1451 -0.60596 -0.13414 0.09729 0.05679 -0.12807 -0.12018 0.112182 0 0 0 0
0 -0.1451 0 0.15108 0.28025 0.18791 0.12086 -0.04341 -0.03885 -0.03709 -0.03473 0.05718 0.048845 0.096485 0.045741 -0.03217 -0.054282 0 -0.02573 0 0 0 0 0 0
Sum 0.0 0.0 0.0 114.0 158.8 -364.0 91.2 -123.9 274.6 -51.6 -99.1 126.9 55.6 -284.0 101.5 -139.8 251.6 0.0 -111.8 0.0 0.0 0.0 0.0 0.0 0.0
Elastic Support Moments (3.3)
Support 1 2 3 4 5 6 7
Left Right Left Right Left Right Left Right Left Right
Spans 1256 0.0 932.8 994.9 489.9 114.9 37.1 302.9 281.2 0.0 0.0 0.0 0.0
Spans 34 0.0 492.1 527.7 236.4 2.6 161.3 617.9 523.6 0.0 0.0 0.0 0.0
Spans 236 0.0 646.8 882.5 534.5 128.8 31.3 300.2 281.9 0.0 0.0 0.0 0.0
Spans 145 0.0 778.1 640.1 191.7 -11.3 167.0 620.5 522.9 0.0 0.0 0.0 0.0
Odd Spans 0.0 776.1 635.5 203.5 26.0 74.3 319.7 276.2 0.0 0.0 0.0 0.0
Even Spans 0.0 648.8 887.1 522.7 91.5 124.1 601.1 528.6 0.0 0.0 0.0 0.0
Redistribution (3.5) method 1
ßb - 0.9 0.9 1 0.8 0.9 1 1
ßb + 1.1 1.1 1 1.2 1.1 1 1
Max M 0.0 895.4 534.5 496.4 475.7 0.0 0.0
Dead only 0.0 490.1 523.1 248.2 39.9 68.5 317.0 277.0 0.0 0.0 0.0 0.0
Spans 1256 0.0 895.4 895.4 489.9 114.9 44.5 363.4 309.3 0.0 0.0 0.0 0.0
Spans 34 0.0 541.3 580.5 236.4 2.6 193.5 496.4 475.7 0.0 0.0 0.0 0.0
Spans 236 0.0 711.5 895.4 534.5 128.8 37.6 360.3 310.1 0.0 0.0 0.0 0.0
Spans 145 0.0 855.9 704.1 191.7 -11.3 200.4 496.4 475.7 0.0 0.0 0.0 0.0
Odd Spans 0.0 853.7 699.1 203.5 26.0 89.2 383.6 303.9 0.0 0.0 0.0 0.0
Even Spans 0.0 713.7 895.4 522.7 91.5 148.9 496.4 475.7 0.0 0.0 0.0 0.0
30-Apr-14
Project Spreadsheets to BS 8110 & EC2
Location Advisory Group ANALYSIS IVSUBFRAME ANALYSIS TO EC2 (DD ENV 1992-1-1 : 1992) Made by rmw Job No R68
Originated from RCCe21.xls' on CD © 1999 BCA for RCC Date
Total Ultimate LoadsSpan 1 2 3
UDL PL1 PL2 ptUD UDL PL1 PL2 ptUD UDL PL1 PL2 ptUD
Dead only 583.62 0 0 0 360 72 0 226.896 0 0 0 0
Spans 1256 1111.89 0 0 0 756 142.2 0 385.51 0 0 0 0
Spans 34 583.62 0 0 0 360 72 0 226.896 0 0 0 0
Spans 236 583.62 0 0 0 756 142.2 0 385.51 0 0 0 0
Spans 145 1111.89 0 0 0 360 72 0 226.896 0 0 0 0
Odd Spans 1111.89 0 0 0 360 72 0 226.896 0 0 0 0
Even Spans 583.62 0 0 0 756 142.2 0 385.51 0 0 0 0
Span 4 5 6
Dead only 700.344 0 0 0 0 0 0 0 0 0 0 0
Spans 1256 700.344 0 0 0 0 0 0 0 0 0 0 0
Spans 34 1334.26 0 0 0 0 0 0 0 0 0 0 0
Spans 236 700.344 0 0 0 0 0 0 0 0 0 0 0
Spans 145 1334.26 0 0 0 0 0 0 0 0 0 0 0
Odd Spans 700.344 0 0 0 0 0 0 0 0 0 0 0
Even Spans 1334.26 0 0 0 0 0 0 0 0 0 0 0
Elastic Shears Redistributed ShearsSpan 1 2 3 Span 1 2 3
Spans 1256 400.469 711.418 673.881 609.829 12.9669 -12.9669 Dead only 210.13 373.49 350.32 308.57 -4.77 4.77
Spans 34 209.801 373.819 352.594 306.302 -26.4416 26.4416 Spans 1256 406.70 705.18 660.06 623.65 11.73 -11.73
Spans 236 184.01 399.61 652.071 631.638 16.2417 -16.2417 Spans 34 201.60 382.02 359.92 298.97 -31.82 31.82
Spans 145 426.26 685.627 374.403 284.493 -29.7164 29.7164 Spans 236 173.23 410.39 653.86 629.85 15.20 -15.20
Odd Spans 426.594 685.293 372.131 286.765 -8.04726 8.04726 Spans 145 413.29 698.60 383.29 275.60 -35.28 35.28
Even Spans 183.676 399.944 654.344 629.366 -5.42746 5.42746 Odd Spans 413.66 698.23 380.96 277.94 -10.52 10.52
Span 4 5 6 Even Spans 172.86 410.76 655.50 628.21 -9.56 9.56
Spans 1256 353.187 347.157 0 0 0 0 Span 4 5 6
Spans 34 680.222 654.042 0 0 0 0 Dead only 355.73 344.61 0 0 0 0
Spans 236 352.718 347.626 0 0 0 0 Spans 1256 357.69 342.65 0 0 0 0
Spans 145 680.691 653.574 0 0 0 0 Spans 34 670.01 664.26 0 0 0 0
Odd Spans 356.203 344.141 0 0 0 0 Spans 236 357.14 343.20 0 0 0 0
Even Spans 677.205 657.059 0 0 0 0 Spans 145 670.01 664.26 0 0 0 0
Odd Spans 361.25 339.10 0 0 0 0
Even Spans 670.01 664.26 0 0 0 0
Imposed Reactions Redistributed reactionsSupport 1 2 3 4 5 6 7 Support 1 2 3 4 5 6 7
Spans 1256 82.0 258.7 149.0 -9.7 -1.3 0.0 0.0 Dead only 210.1 723.8 303.8 360.5 344.6 0.0 0.0
Spans 34 -5.7 12.1 -23.3 143.4 132.7 0.0 0.0 Spans 1256 406.7 1365.2 635.4 346.0 342.6 0.0 0.0
Spans 236 -24.6 145.2 156.6 -13.5 -0.9 0.0 0.0 Spans 34 201.6 741.9 267.2 701.8 664.3 0.0 0.0
Spans 145 86.4 151.6 -42.3 146.9 132.7 0.0 0.0 Spans 236 173.2 1064.3 645.0 341.9 343.2 0.0 0.0
Odd Spans 86.7 149.8 -23.1 6.4 -3.7 0.0 0.0 Spans 145 413.3 1081.9 240.3 705.3 664.3 0.0 0.0
Even Spans -24.8 146.6 137.9 129.7 132.7 0.0 0.0 Odd Spans 413.7 1079.2 267.4 371.8 339.1 0.0 0.0
Even Spans 172.9 1066.3 618.6 679.6 664.3 0.0 0.0
30-Apr-14
Project Spreadsheets to BS 8110 & EC2
Location Advisory Group ANALYSIS VSUBFRAME ANALYSIS TO EC2 (DD ENV 1992-1-1 : 1992) Made by rmw Job No R68
Originated from RCCe21.xls' on CD © 1999 BCA for RCC Date
SPAN MOMENTS
SPAN 1 Left < > PL1 < > PL2 < > Right Loadings 0 0 SPAN 2 Left < > PL1 < > PL2 < > Right Loadings
Elastic V 1256 400.5 0 400.5 0 400.5 100 711.4 185.315 0 0 0 Elastic V 1256 673.9 100 -420.4 0 -562.6 0 609.8 105 142.2
34 209.8 0 209.8 0 209.8 100 373.8 97.27 0 0 0 34 352.6 100 -211.8 0 -283.8 0 306.3 50 72
236 184.0 0 184.0 0 184.0 100 399.6 97.27 0 0 0 236 652.1 100 -442.2 0 -584.4 0 631.6 105 142.2
145 426.3 0 426.3 0 426.3 100 685.6 185.315 0 0 0 145 374.4 100 -190.0 0 -262.0 0 284.5 50 72
Odd 426.6 0 426.6 0 426.6 100 685.3 185.315 0 0 0 Odd 372.1 100 -192.3 0 -264.3 0 286.8 50 72
Even 183.7 0 183.7 0 183.7 100 399.9 97.27 0 0 0 Even 654.3 100 -439.9 0 -582.1 0 629.4 105 142.2
Redist V 1256 406.7 0 406.7 0 406.7 100 705.2 6 Redist V 1256 660.1 100 -434.2 0 -576.4 0 623.6 7.2
34 201.6 0 201.6 0 201.6 100 382.0 34 359.9 100 -204.5 0 -276.5 0 299.0
236 173.2 0 173.2 0 173.2 100 410.4 236 653.9 100 -440.4 0 -582.6 0 629.8
145 413.3 0 413.3 0 413.3 100 698.6 145 383.3 100 -181.1 0 -253.1 0 275.6
Odd 413.7 0 413.7 0 413.7 100 698.2 Odd 381.0 100 -183.4 0 -255.4 0 277.9
Even 172.9 0 172.9 0 172.9 100 410.8 Even 655.5 100 -438.8 0 -581.0 0 628.2
Elastic X- 1256 0.000 0.000 0.000 0.000 2.161 Elastic X- 1256 3.961 6.750 0.000 0.000 3.194
34 0.000 0.000 0.000 0.000 2.157 34 3.989 6.750 0.000 0.000 3.249
236 0.000 0.000 0.000 0.000 1.892 236 3.844 6.750 0.000 0.000 3.076
145 0.000 0.000 0.000 0.000 2.300 145 4.214 6.750 0.000 0.000 3.473
Odd 0.000 0.000 0.000 0.000 2.302 Odd 4.190 6.750 0.000 0.000 3.450
Even 0.000 0.000 0.000 0.000 1.888 Even 3.856 6.750 0.000 0.000 3.089
Redist X- 1256 0.000 0.000 0.000 0.000 2.195 Redist X- 1256 3.887 6.750 0.000 0.000 3.120
34 0.000 0.000 0.000 0.000 2.073 34 4.065 6.750 0.000 0.000 3.325
236 0.000 0.000 0.000 0.000 1.781 236 3.853 6.750 0.000 0.000 3.086
145 0.000 0.000 0.000 0.000 2.230 145 4.305 6.750 0.000 0.000 3.565
Odd 0.000 0.000 0.000 0.000 2.232 (3.2.2.1b) Odd 4.281 6.750 0.000 0.000 3.541 (3.2.2.1b)
Even 0.000 0.000 0.000 0.000 1.777 Max Even 3.862 6.750 0.000 0.000 3.095 Max
Elastic M 1256 0.0 0.0 0.0 0.0 0.0 432.7 932.8 432.711 Elastic M 1256 994.9 436.6 -226.1 -994.9 -994.9 382.0 489.9 436.5736
34 0.0 0.0 0.0 0.0 0.0 226.3 492.1 226.259 34 527.7 233.0 -103.6 -527.7 -527.7 206.4 236.4 233.0325
236 0.0 0.0 0.0 0.0 0.0 174.0 646.8 174.05 236 882.5 463.8 -260.9 -882.5 -882.5 409.3 534.5 463.8409
145 0.0 0.0 0.0 0.0 0.0 490.2 778.1 490.24 145 640.1 210.1 -68.8 -640.1 -640.1 183.5 191.7 210.1022
Odd 0.0 0.0 0.0 0.0 0.0 491.0 776.1 491.009 Odd 635.5 205.1 -79.5 -635.5 -635.5 178.5 203.5 205.1154
Even 0.0 0.0 0.0 0.0 0.0 173.4 648.8 173.419 ßb Even 887.1 468.0 -250.2 -887.1 -887.1 413.5 522.7 468.0279 ßb
Redist M 1256 0.0 0.0 0.0 0.0 0.0 446.3 895.4 446.291 1.03139 Redist M 1256 895.4 481.8 -219.9 -895.4 -895.4 427.3 489.9 481.8402 1.103686
34 0.0 0.0 0.0 0.0 0.0 208.9 541.3 208.916 0.92335 34 580.5 209.8 -106.9 -580.5 -580.5 183.1 236.4 209.7773 0.900206
236 0.0 0.0 0.0 0.0 0.0 154.3 711.5 154.254 0.88626 236 895.4 457.8 -261.7 -895.4 -895.4 403.3 534.5 457.8416 0.987066
145 0.0 0.0 0.0 0.0 0.0 460.9 855.9 460.864 0.94008 145 704.1 184.0 -72.8 -704.1 -704.1 157.3 191.7 183.959 0.875569
Odd 0.0 0.0 0.0 0.0 0.0 461.7 853.7 461.684 0.94028 Odd 699.1 178.9 -83.5 -699.1 -699.1 152.3 203.5 178.9495 0.872433
Even 0.0 0.0 0.0 0.0 0.0 153.6 713.7 153.601 0.88572 Even 895.4 464.2 -250.7 -895.4 -895.4 409.6 522.7 464.1636 0.991743
SPAN 3 Left < > PL1 < > PL2 < > Right Loadings 0 0 SPAN 4 Left < > PL1 < > PL2 < > Right Loadings
Elastic V 1256 13.0 0 13.0 0 13.0 100 -13.0 0 0 0 0 Elastic V 1256 353.2 0 353.2 0 353.2 100 347.2 97.27 0
34 -26.4 100 -26.4 0 -26.4 0 26.4 0 0 0 0 34 680.2 0 680.2 0 680.2 100 654.0 185.3145 0
236 16.2 0 16.2 0 16.2 100 -16.2 0 0 0 0 236 352.7 0 352.7 0 352.7 100 347.6 97.27 0
145 -29.7 100 -29.7 0 -29.7 0 29.7 0 0 0 0 145 680.7 0 680.7 0 680.7 100 653.6 185.3145 0
Odd -8.0 100 -8.0 0 -8.0 0 8.0 0 0 0 0 Odd 356.2 0 356.2 0 356.2 100 344.1 97.27 0
Even -5.4 100 -5.4 0 -5.4 0 5.4 0 0 0 0 Even 677.2 0 677.2 0 677.2 100 657.1 185.3145 0
Redist V 1256 11.7 0 11.7 0 11.7 100 -11.7 6 Redist V 1256 357.7 0 357.7 0 357.7 100 342.6 7.2
34 -31.8 100 -31.8 0 -31.8 0 31.8 34 670.0 0 670.0 0 670.0 100 664.3
236 15.2 0 15.2 0 15.2 100 -15.2 236 357.1 0 357.1 0 357.1 100 343.2
145 -35.3 100 -35.3 0 -35.3 0 35.3 145 670.0 0 670.0 0 670.0 100 664.3
Odd -10.5 100 -10.5 0 -10.5 0 10.5 Odd 361.2 0 361.2 0 361.2 100 339.1
Even -9.6 100 -9.6 0 -9.6 0 9.6 Even 670.0 0 670.0 0 670.0 100 664.3
Elastic X- 1256 0.000 0.000 0.000 0.000 0.000 Elastic X- 1256 0.000 0.000 0.000 0.000 3.631
34 0.000 0.000 0.000 0.000 0.000 34 0.000 0.000 0.000 0.000 3.671
236 0.000 0.000 0.000 0.000 0.000 236 0.000 0.000 0.000 0.000 3.626
145 0.000 0.000 0.000 0.000 0.000 145 0.000 0.000 0.000 0.000 3.673
Odd 0.000 0.000 0.000 0.000 0.000 Odd 0.000 0.000 0.000 0.000 3.662
Even 0.000 0.000 0.000 0.000 0.000 Even 0.000 0.000 0.000 0.000 3.654
30-Apr-14
Project Spreadsheets to BS 8110 & EC2
Location Advisory Group ANALYSIS VSUBFRAME ANALYSIS TO EC2 (DD ENV 1992-1-1 : 1992) Made by rmw Job No R68
Originated from RCCe21.xls' on CD © 1999 BCA for RCC Date
SPAN MOMENTS cont
SPAN 3 cont SPAN 4 contRedist X- 1256 0.000 0.000 0.000 0.000 0.000 Redist X- 1256 0.000 0.000 0.000 0.000 3.677
34 0.000 0.000 0.000 0.000 0.000 34 0.000 0.000 0.000 0.000 3.616
236 0.000 0.000 0.000 0.000 0.000 236 0.000 0.000 0.000 0.000 3.672
145 0.000 0.000 0.000 0.000 0.000 145 0.000 0.000 0.000 0.000 3.616
Odd 0.000 0.000 0.000 0.000 0.000 (3.2.2.1b) Odd 0.000 0.000 0.000 0.000 3.714 (3.2.2.1b)
Even 0.000 0.000 0.000 0.000 0.000 Max Even 0.000 0.000 0.000 0.000 3.616 Max
Elastic M 1256 114.9 -114.9 -114.9 -114.9 -114.9 -114.9 37.1 -114.922 Elastic M 1256 302.9 -302.9 -302.9 -302.9 -302.9 338.4 281.2 338.3527
34 2.6 -2.6 -2.6 -2.6 -2.6 -2.6 161.3 -2.60416 34 617.9 -617.9 -617.9 -617.9 -617.9 630.5 523.6 630.5341
236 128.8 -128.8 -128.8 -128.8 -128.8 -128.8 31.3 -128.791 236 300.2 -300.2 -300.2 -300.2 -300.2 339.3 281.9 339.2733
145 -11.3 11.3 11.3 11.3 11.3 11.3 167.0 11.2643 145 620.5 -620.5 -620.5 -620.5 -620.5 629.6 522.9 629.6338
Odd 26.0 -26.0 -26.0 -26.0 -26.0 -26.0 74.3 -26.0182 Odd 319.7 -319.7 -319.7 -319.7 -319.7 332.5 276.2 332.5458
Even 91.5 -91.5 -91.5 -91.5 -91.5 -91.5 124.1 -91.5081 ßb Even 601.1 -601.1 -601.1 -601.1 -601.1 636.3 528.6 636.2927 ßb
Redist M 1256 114.9 -114.9 -114.9 -114.9 -114.9 -114.9 44.5 -114.922 1 Redist M 1256 363.4 -363.4 -363.4 -363.4 -363.4 294.3 309.3 294.2537 0.869666
34 2.6 -2.6 -2.6 -2.6 -2.6 -2.6 193.5 -2.60416 1 34 496.4 -496.4 -496.4 -496.4 -496.4 714.8 475.7 714.8055 1.133651
236 128.8 -128.8 -128.8 -128.8 -128.8 -128.8 37.6 -128.791 1 236 360.3 -360.3 -360.3 -360.3 -360.3 295.4 310.1 295.3711 0.870599
145 -11.3 11.3 11.3 11.3 11.3 11.3 200.4 11.2643 1 145 496.4 -496.4 -496.4 -496.4 -496.4 714.8 475.7 714.8055 1.135272
Odd 26.0 -26.0 -26.0 -26.0 -26.0 -26.0 89.2 -26.0182 1 Odd 383.6 -383.6 -383.6 -383.6 -383.6 287.2 303.9 287.211 0.863673
Even 91.5 -91.5 -91.5 -91.5 -91.5 -91.5 148.9 -91.5081 1 Even 496.4 -496.4 -496.4 -496.4 -496.4 714.8 475.7 714.8055 1.123391
::
SPAN 5 Left < > PL1 < > PL2 < > Right Loadings 0 0 SPAN 6 Left < > PL1 < > PL2 < > Right Loadings
Elastic V 1256 0.0 100 0.0 100 0.0 100 0.0 0 0 0 0 Elastic V 1256 0.0 100 0.0 100 0.0 100 0.0 0 0
34 0.0 100 0.0 100 0.0 100 0.0 0 0 0 0 34 0.0 100 0.0 100 0.0 100 0.0 0 0
236 0.0 100 0.0 100 0.0 100 0.0 0 0 0 0 236 0.0 100 0.0 100 0.0 100 0.0 0 0
145 0.0 100 0.0 100 0.0 100 0.0 0 0 0 0 145 0.0 100 0.0 100 0.0 100 0.0 0 0
Odd 0.0 100 0.0 100 0.0 100 0.0 0 0 0 0 Odd 0.0 100 0.0 100 0.0 100 0.0 0 0
Even 0.0 100 0.0 100 0.0 100 0.0 0 0 0 0 Even 0.0 100 0.0 100 0.0 100 0.0 0 0
Redist V 1256 0.0 100 0.0 100 0.0 100 0.0 0 Redist V 1256 0.0 100 0.0 100 0.0 100 0.0 0
34 0.0 100 0.0 100 0.0 100 0.0 34 0.0 100 0.0 100 0.0 100 0.0
236 0.0 100 0.0 100 0.0 100 0.0 236 0.0 100 0.0 100 0.0 100 0.0
145 0.0 100 0.0 100 0.0 100 0.0 145 0.0 100 0.0 100 0.0 100 0.0
Odd 0.0 100 0.0 100 0.0 100 0.0 Odd 0.0 100 0.0 100 0.0 100 0.0
Even 0.0 100 0.0 100 0.0 100 0.0 Even 0.0 100 0.0 100 0.0 100 0.0
Elastic X- 1256 0.000 0.000 0.000 0.000 0.000 Elastic X- 1256 0.000 0.000 0.000 0.000 0.000
34 0.000 0.000 0.000 0.000 0.000 34 0.000 0.000 0.000 0.000 0.000
236 0.000 0.000 0.000 0.000 0.000 236 0.000 0.000 0.000 0.000 0.000
145 0.000 0.000 0.000 0.000 0.000 145 0.000 0.000 0.000 0.000 0.000
Odd 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 Even 0.000 0.000 0.000 0.000 0.000
Redist X- 1256 0.000 0.000 0.000 0.000 0.000 Redist X- 1256 0.000 0.000 0.000 0.000 0.000
34 0.000 0.000 0.000 0.000 0.000 34 0.000 0.000 0.000 0.000 0.000
236 0.000 0.000 0.000 0.000 0.000 236 0.000 0.000 0.000 0.000 0.000
145 0.000 0.000 0.000 0.000 0.000 145 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) 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 Even 0.000 0.000 0.000 0.000 0.000 Max
Elastic M 1256 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0 Elastic M 1256 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0
34 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0 34 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0
236 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0 236 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0
145 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0 145 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0
Odd 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0 Odd 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0
Even 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0 ßb Even 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0 ßb
Redist M 1256 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0 0 Redist M 1256 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0 0
34 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0 0 34 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0 0
236 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0 0 236 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0 0
145 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0 0 145 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0 0
Odd 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0 0 Odd 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0 0
Even 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0 0 Even 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0 0
30-Apr-14
Made by rmw Job No R68
LoCol
0
0
0
0
0
0
0
0.0
Made by rmw Job No R68
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
Made by rmw Job No R68
0
0
0
0
0
0
0
0.0
0
0
0
0
0
0
0
0.0
Made by rmw Job No R68
Made by rmw Job No R68
0.75 4.8
0 80.3145
0 47.27
0 80.3145
0 47.27
0 47.27
0 80.3145
0 0
0 0
0 0
0 0
0 0
0 0
0 0
Made by rmw Job No R68
0 0
0 0
0 0
0 0
0 0
0 0
0 0
Project Spreadsheets to BS 8110 & EC2
Location Advisory Group GRAPH DATA ISUBFRAME ANALYSIS TO EC2 (DD ENV 1992-1-1 : 1992) Made by rmw Job No R68
Originated from RCCe21.xls' on CD © 1999 BCA for RCC Date
LOADING DIAGRAM 54.08
BEAM 0 26.4
0 0
SUPPORTS 0 0 6 6 13.2 13.2 19.2 19.2 26.4 26.4 26.4 26.4 26.4 26.4
-54.08 0 -243 194.7 -243 194.7 -243 194.7 -243 194.7 -54.1 0 -54.1 0
D UDL 0 0 6 6 6 13.2 13.2 13.2 19.2 19.2 19.2 26.4 26.4 26.4 26.4 26.4 26.4 26.4 26.4
0 97.27 97.27 0 50 50 0 0 0 0 97.27 97.27 0 0 0 0 0 0 0
L UDL 97.27 133.3 133.3 97.27 75 75 50 0 0 0 133.3 133.3 97.27 0 0 0 0 0 0
D PUDL 0 0 0 0 6.75 6.75 11.55 11.55 13.2 13.2 13.2 13.2 19.2 19.2 19.2 19.2 26.4 26.4 26.4 26.4 26.4 26.4 26.4 26.4
133.27 133.3 133.3 133.3 75 122.3 122.3 75 0 0 0 0 133.3 133.3 133.3 133.3 0 0 0 0 0 0 0 0
L PUDL 133.27 133.3 133.3 133.3 75 100 100 75 0 0 0 0 133.3 133.3 133.3 133.3 0 0 0 0 0 0 0 0
PL 1 0 0 12.75 12.75 13.2 13.2 19.2 19.2 26.4 26.4 26.4 26.4
133.27 133.3 75 147 0 0 133.3 133.3 0 0 0 0
133.27 133.3 147 177 0 0 133.3 133.3 0 0 0 0
PL 2 0 0 6 6 13.2 13.2 19.2 19.2 26.4 26.4 26.4 26.4
133.27 133.3 75 75 0 0 133.3 133.3 0 0 0 0
133.27 133.3 75 75 0 0 133.3 133.3 0 0 0 0
MOMENT DIAGRAMS
SPAN 1 at col face
X 0 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.15 5.775
M(e) all 0 0 -112 -207 -285 -347 -392 -421 -432 -427 -406 -367 -313 -241 -153 -47.5 74.2 212.6 367.6 539.4 727.8 932.8 -58 777.5
0 0 -58.6 -108 -149 -182 -205 -220 -226 -223 -212 -192 -163 -125 -78.5 -23.2 40.76 113.5 195 285.3 384.3 492.1 -30.4 410.4
0 0 -50.8 -92.9 -126 -151 -167 -174 -172 -161 -142 -114 -77.6 -32.1 22.1 85.08 156.8 237.3 326.5 424.5 531.3 646.8 -26.5 559.4
0 0 -120 -222 -309 -378 -431 -467 -487 -489 -475 -445 -398 -334 -253 -156 -41.9 88.78 236.1 400.1 580.8 778.1 -61.9 628.5
M(e) odd 0 0 -120 -223 -309 -378 -431 -468 -487 -490 -476 -446 -399 -335 -254 -157 -43.4 87.17 234.4 398.3 578.9 776.1 -61.9 626.6
M(e) even 0 0 -50.7 -92.7 -126 -150 -166 -173 -171 -161 -141 -113 -76.5 -30.9 23.4 86.48 158.3 238.9 328.2 426.3 533.2 648.8 -26.5 561.3
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 -114 -211 -291 -355 -402 -432 -445 -442 -423 -386 -333 -263 -177 -73.7 46.14 182.6 335.8 505.7 692.2 895.4 -58.9 741.5
0 0 -56.1 -103 -142 -172 -193 -205 -209 -204 -190 -167 -136 -95.5 -46.5 11.2 77.66 152.9 236.8 329.6 431 541.3 -29.1 457.8
0 0 -47.6 -86.4 -117 -138 -150 -154 -149 -136 -113 -82 -42 6.682 64.14 130.4 205.3 289 381.5 482.8 592.7 711.5 -24.9 621.6
0 0 -116 -215 -297 -363 -411 -444 -459 -458 -440 -406 -355 -287 -203 -101 16.5 151 302.2 470.1 654.7 855.9 -59.9 703.4
M(r) odd 0 0 -116 -215 -297 -363 -412 -444 -460 -459 -441 -407 -356 -288 -204 -103 14.85 149.3 300.4 468.1 652.6 853.7 -60 701.3
M(r) even 0 0 -47.5 -86.2 -116 -137 -150 -154 -149 -135 -112 -80.9 -40.8 8.004 65.57 131.9 207 290.8 383.4 484.7 594.8 713.7 -24.8 623.7
70% max 0 0 -35.5 -64.9 -88.1 -105 -116 -121 -120 -112 -99 -79.3 -53.5 -21.6 16.38 60.54 110.8 167.2 257.3 377.5 509.4 653 -18.5 544.2
70% min 0 0 -83.7 -156 -216 -265 -302 -327 -341 -343 -333 -312 -279 -234 -178 -110 -30.4 61.02 136.5 199.7 269 344.4 -43.3 287.3
Lower bound 0 0 -116 -215 -297 -363 -412 -444 -460 -459 -441 -407 -356 -288 -204 -110 -30.4 0 0 0 0 0 -60 287.3
Upper bound 0 0 0 0 0 0 0 0 0 0 0 0 0 8.004 65.57 131.9 207 290.8 383.4 505.7 692.2 895.4 -18.5 741.5
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 2Local X 0 0.36 0.72 1.08 1.44 1.8 2.16 2.52 2.88 3.24 3.6 3.96 4.32 4.68 5.04 5.4 5.76 6.12 6.48 6.84 7.2 0.225 7
X 6 6.36 6.72 7.08 7.44 7.8 8.16 8.52 8.88 9.24 9.6 9.96 10.32 10.68 11.04 11.4 11.76 12.12 12.48 12.84 13.2
M(e) all 994.9 759.1 536.9 332.7 152.5 -3.69 -136 -244 -328 -388 -424 -437 -425 -389 -329 -245 -139 -17.9 116.4 277.2 489.9 846 370
527.7 404 286.8 178.6 83.06 0.092 -70.3 -128 -173 -206 -226 -233 -228 -210 -179 -136 -81.6 -19.9 48.22 129.3 236.4 449.6 176.1
882.5 654.6 440.3 243.9 71.55 -76.8 -201 -301 -378 -430 -458 -463 -443 -399 -331 -239 -125 3.188 145.4 313.9 534.5 738.5 410.3
640.1 508.5 383.5 267.5 164 73.22 -5 -70.6 -124 -164 -192 -207 -210 -200 -177 -142 -94.8 -41 19.28 92.53 191.7 557.1 135.8
M(e) odd 635.5 504.8 380.5 265.4 162.7 72.75 -4.65 -69.4 -122 -161 -188 -203 -204 -193 -170 -134 -86.3 -31.7 29.44 103.5 203.5 553.1 147.2
M(e) even 887.1 658.3 443.2 246 72.83 -76.3 -201 -303 -380 -433 -462 -467 -448 -405 -338 -247 -134 -6.16 135.2 303 522.7 742.5 399
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 895.4 664.6 447.4 248.2 72.93 -78.3 -206 -309 -388 -443 -474 -481 -464 -424 -359 -270 -159 -32.8 106.5 272.2 489.9 749.6 367.3
580.5 454.1 334.3 223.5 125.3 39.67 -33.3 -93.7 -142 -177 -199 -209 -207 -191 -164 -123 -71 -12 53.5 132 236.4 500.8 177.6
895.4 666.8 451.9 254.9 81.86 -67.1 -192 -293 -370 -423 -452 -457 -438 -395 -327 -236 -123 5.121 146.7 314.6 534.5 751 410.7
704.1 569.3 441.1 321.9 215.2 121.2 39.81 -29 -85.2 -129 -160 -178 -184 -177 -158 -126 -82 -31.4 25.68 95.73 191.7 619.1 137.6
M(r) odd 699.1 565.2 437.7 319.4 213.6 120.4 39.84 -28.1 -83.5 -126 -156 -174 -179 -171 -151 -118 -73.6 -22.1 35.79 106.7 203.5 614.6 148.9
M(r) even 895.4 666.3 450.7 253.1 79.5 -70.1 -196 -297 -375 -428 -458 -463 -445 -402 -336 -245 -132 -4.91 136 303.4 522.7 750.6 399.2
70% max 696.4 531.4 375.9 232.9 114.8 51.25 -3.26 -48.6 -85.1 -113 -132 -142 -143 -135 -119 -93.8 -57.1 2.231 101.8 219.8 374.2 592.2 287.2
70% min 369.4 282.8 200.8 125 50.08 -53.8 -141 -212 -266 -303 -323 -327 -314 -284 -237 -173 -97 -28.7 13.49 64.77 134.2 314.7 95.07
Lower bound 0 0 0 0 0 -78.3 -206 -309 -388 -443 -474 -481 -464 -424 -359 -270 -159 -32.8 0 0 0 314.7 95.07
Upper bound 895.4 666.8 451.9 321.9 215.2 121.2 39.84 0 0 0 0 0 0 0 0 0 0 5.121 146.7 314.6 534.5 751 410.7
Beam 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
30-Apr-14
Project Spreadsheets to BS 8110 & EC2
Location Advisory Group GRAPH DATA IISUBFRAME ANALYSIS TO EC2 (DD ENV 1992-1-1 : 1992) Made by rmw Job No R68
Originated from RCCe21.xls' on CD © 1999 BCA for RCC Date
SPAN 3Local 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.2 5.8
X 13.2 13.5 13.8 14.1 14.4 14.7 15 15.3 15.6 15.9 16.2 16.5 16.8 17.1 17.4 17.7 18 18.3 18.6 18.9 19.2
M(e) all 114.9 111 107.1 103.3 99.36 95.47 91.58 87.69 83.8 79.91 76.02 72.13 68.24 64.35 60.46 56.57 52.68 48.79 44.9 41.01 37.12 112.3 39.71
2.604 10.54 18.47 26.4 34.33 42.27 50.2 58.13 66.06 74 81.93 89.86 97.79 105.7 113.7 121.6 129.5 137.5 145.4 153.3 161.3 7.892 156
128.8 123.9 119 114.2 109.3 104.4 99.56 94.68 89.81 84.94 80.07 75.19 70.32 65.45 60.58 55.7 50.83 45.96 41.09 36.21 31.34 125.5 34.59
-11.3 -2.35 6.566 15.48 24.4 33.31 42.23 51.14 60.06 68.97 77.89 86.8 95.71 104.6 113.5 122.5 131.4 140.3 149.2 158.1 167 -5.32 161.1
M(e) odd 26.02 28.43 30.85 33.26 35.67 38.09 40.5 42.92 45.33 47.75 50.16 52.57 54.99 57.4 59.82 62.23 64.65 67.06 69.47 71.89 74.3 27.63 72.69
M(e) even 91.51 93.14 94.76 96.39 98.02 99.65 101.3 102.9 104.5 106.2 107.8 109.4 111 112.7 114.3 115.9 117.6 119.2 120.8 122.4 124.1 92.59 123
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 114.9 111.4 107.9 104.4 100.8 97.33 93.81 90.29 86.77 83.25 79.73 76.21 72.7 69.18 65.66 62.14 58.62 55.1 51.58 48.06 44.55 112.6 46.89
2.604 12.15 21.69 31.24 40.78 50.33 59.87 69.42 78.96 88.51 98.05 107.6 117.1 126.7 136.2 145.8 155.3 164.9 174.4 184 193.5 8.968 187.1
128.8 124.2 119.7 115.1 110.6 106 101.4 96.88 92.32 87.76 83.2 78.64 74.08 69.52 64.96 60.4 55.84 51.29 46.73 42.17 37.61 125.8 40.65
-11.3 -0.68 9.906 20.49 31.08 41.66 52.25 62.83 73.42 84 94.59 105.2 115.8 126.3 136.9 147.5 158.1 168.7 179.3 189.9 200.4 -4.21 193.4
M(r) odd 26.02 29.18 32.33 35.49 38.65 41.8 44.96 48.12 51.28 54.43 57.59 60.75 63.9 67.06 70.22 73.38 76.53 79.69 82.85 86 89.16 28.12 87.06
M(r) even 91.51 94.38 97.25 100.1 103 105.9 108.7 111.6 114.5 117.3 120.2 123.1 125.9 128.8 131.7 134.5 137.4 140.3 143.1 146 148.9 93.42 147
70% max 90.15 86.74 83.33 79.92 76.51 73.1 70.89 72.03 73.17 74.31 75.45 76.59 77.73 78.87 80.01 85.72 91.96 98.2 104.4 110.7 116.9 87.88 112.8
70% min -7.89 -1.64 4.596 10.84 17.08 23.32 28.35 30.04 31.73 33.42 35.11 36.8 38.49 40.18 41.87 38.99 35.58 32.17 28.76 25.35 21.94 -3.72 24.21
Lower bound -11.3 -1.64 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 -4.21 24.21
Upper bound 128.8 124.2 119.7 115.1 110.6 106 108.7 111.6 114.5 117.3 120.2 123.1 125.9 128.8 136.9 147.5 158.1 168.7 179.3 189.9 200.4 125.8 193.4
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 4Local X 0 0.36 0.72 1.08 1.44 1.8 2.16 2.52 2.88 3.24 3.6 3.96 4.32 4.68 5.04 5.4 5.76 6.12 6.48 6.84 7.2 0.2 7
X 19.2 19.56 19.92 20.28 20.64 21 21.36 21.72 22.08 22.44 22.8 23.16 23.52 23.88 24.24 24.6 24.96 25.32 25.68 26.04 26.4
M(e) all 302.9 182 73.77 -21.9 -105 -175 -233 -278 -311 -331 -338 -333 -315 -285 -242 -186 -118 -37.1 56.41 162.5 281.2 234.2 213.7
617.9 385 176.2 -8.67 -169 -306 -419 -508 -573 -613 -630 -623 -591 -536 -457 -353 -226 -74.6 100.8 300.2 523.6 485.6 396.5
300.2 179.6 71.49 -24 -107 -177 -235 -280 -312 -332 -339 -334 -316 -285 -242 -186 -118 -36.8 56.83 163.1 281.9 231.6 214.3
620.5 387.5 178.4 -6.56 -168 -305 -417 -506 -571 -612 -629 -622 -591 -536 -457 -353 -226 -74.9 100.3 299.6 522.9 488.1 395.9
M(e) odd 319.7 197.7 88.41 -8.31 -92.4 -164 -223 -269 -303 -324 -332 -328 -311 -282 -240 -186 -118 -38.7 53.67 158.7 276.2 250.4 209.4
M(e) even 601.1 369.3 161.5 -22.2 -182 -318 -429 -517 -581 -620 -636 -628 -595 -539 -458 -354 -225 -73 103.5 304 528.6 469.3 400.9
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 363.4 241 131.1 33.85 -50.8 -123 -182 -229 -263 -285 -294 -290 -274 -245 -204 -150 -83.3 -4.07 87.77 192.2 309.3 293.8 242.7
496.4 267.2 62.04 -119 -276 -409 -519 -604 -665 -702 -715 -704 -669 -610 -527 -420 -289 -134 45.47 248.6 475.7 366.1 346.6
360.3 238 128.4 31.3 -53.2 -125 -184 -231 -265 -286 -295 -291 -275 -246 -204 -150 -83.3 -3.83 88.2 192.8 310.1 290.8 243.4
496.4 267.2 62.04 -119 -276 -409 -519 -604 -665 -702 -715 -704 -669 -610 -527 -420 -289 -134 45.47 248.6 475.7 366.1 346.6
M(r) odd 383.6 259.9 148.7 50.18 -35.7 -109 -170 -218 -253 -276 -287 -284 -269 -242 -202 -149 -83.6 -5.64 84.92 188.1 303.9 313.3 238
M(r) even 496.4 267.2 62.04 -119 -276 -409 -519 -604 -665 -702 -715 -704 -669 -610 -527 -420 -289 -134 45.47 248.6 475.7 366.1 346.6
70% max 434.4 271.2 124.9 -4.59 -64.7 -115 -156 -188 -212 -227 -233 -230 -218 -198 -168 -130 -82.5 -25.8 72.46 212.8 370 341.7 280.6
70% min 210.2 125.7 50.04 -16.8 -127 -222 -301 -362 -407 -434 -445 -439 -417 -377 -321 -248 -158 -52.4 37.57 111.1 193.4 162.1 146.5
Lower bound 0 0 0 -119 -276 -409 -519 -604 -665 -702 -715 -704 -669 -610 -527 -420 -289 -134 0 0 0 162.1 146.5
Upper bound 496.4 271.2 148.7 50.18 0 0 0 0 0 0 0 0 0 0 0 0 0 0 88.2 248.6 475.7 366.1 346.6
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 5Local X 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0.2 0
X 26.4 26.4 26.4 26.4 26.4 26.4 26.4 26.4 26.4 26.4 26.4 26.4 26.4 26.4 26.4 26.4 26.4 26.4 26.4 26.4 26.4
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 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
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
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
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
30-Apr-14
Project Spreadsheets to BS 8110 & EC2
Location Advisory Group GRAPH DATA IIISUBFRAME ANALYSIS TO EC2 (DD ENV 1992-1-1 : 1992) 0
Originated from RCCe21.xls' on CD © 1999 BCA for RCC Date
SPAN 6Local 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 26.4 26.4 26.4 26.4 26.4 26.4 26.4 26.4 26.4 26.4 26.4 26.4 26.4 26.4 26.4 26.4 26.4 26.4 26.4 26.4 26.4 26.4
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
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
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
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
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 DIAGRAMSSPAN 1 SPAN 2 SPAN 3 SPAN 4 SPAN 5 SPAN 6
Local X 0 0 0 0 0 0 6 0 6.75 6.75 6.75 6.75 7.2 0 0 0 0 0 6 0 0 0 0 0 7.2 0 0 0 0 0 0 0 0 0 0 0 0 0
X 0 0 0 0 0 0 6 6 12.75 12.75 12.75 12.75 13.2 13.2 13.2 13.2 13.2 13.2 19.2 19.2 19.2 19.2 19.2 19.2 26.4 26.4 26.4 26.4 26.4 26.4 26.4 26.4 26.4 26.4 26.4 26.4 26.4 26.4
V(e) all 0 400.5 400.5 400.5 400.5 400.5 -711 673.9 -420 -563 -563 -563 -610 12.97 12.97 12.97 12.97 12.97 12.97 353.2 353.2 353.2 353.2 353.2 -347 0 0 0 0 0 0 0 0 0 0 0 0 0
0 209.8 209.8 209.8 209.8 209.8 -374 352.6 -212 -284 -284 -284 -306 -26.4 -26.4 -26.4 -26.4 -26.4 -26.4 680.2 680.2 680.2 680.2 680.2 -654 0 0 0 0 0 0 0 0 0 0 0 0 0
0 184 184 184 184 184 -400 652.1 -442 -584 -584 -584 -632 16.24 16.24 16.24 16.24 16.24 16.24 352.7 352.7 352.7 352.7 352.7 -348 0 0 0 0 0 0 0 0 0 0 0 0 0
0 426.3 426.3 426.3 426.3 426.3 -686 374.4 -190 -262 -262 -262 -284 -29.7 -29.7 -29.7 -29.7 -29.7 -29.7 680.7 680.7 680.7 680.7 680.7 -654 0 0 0 0 0 0 0 0 0 0 0 0 0
V(e) odd 0 426.6 426.6 426.6 426.6 426.6 -685 372.1 -192 -264 -264 -264 -287 -8.05 -8.05 -8.05 -8.05 -8.05 -8.05 356.2 356.2 356.2 356.2 356.2 -344 0 0 0 0 0 0 0 0 0 0 0 0 0
V(e) even 0 183.7 183.7 183.7 183.7 183.7 -400 654.3 -440 -582 -582 -582 -629 -5.43 -5.43 -5.43 -5.43 -5.43 -5.43 677.2 677.2 677.2 677.2 677.2 -657 0 0 0 0 0 0 0 0 0 0 0 0 0
V(r) all 0 406.7 406.7 406.7 406.7 406.7 -705 660.1 -434 -576 -576 -576 -624 11.73 11.73 11.73 11.73 11.73 11.73 357.7 357.7 357.7 357.7 357.7 -343 0 0 0 0 0 0 0 0 0 0 0 0 0
0 201.6 201.6 201.6 201.6 201.6 -382 359.9 -204 -276 -276 -276 -299 -31.8 -31.8 -31.8 -31.8 -31.8 -31.8 670 670 670 670 670 -664 0 0 0 0 0 0 0 0 0 0 0 0 0
0 173.2 173.2 173.2 173.2 173.2 -410 653.9 -440 -583 -583 -583 -630 15.2 15.2 15.2 15.2 15.2 15.2 357.1 357.1 357.1 357.1 357.1 -343 0 0 0 0 0 0 0 0 0 0 0 0 0
0 413.3 413.3 413.3 413.3 413.3 -699 383.3 -181 -253 -253 -253 -276 -35.3 -35.3 -35.3 -35.3 -35.3 -35.3 670 670 670 670 670 -664 0 0 0 0 0 0 0 0 0 0 0 0 0
V(r) odd 0 413.7 413.7 413.7 413.7 413.7 -698 381 -183 -255 -255 -255 -278 -10.5 -10.5 -10.5 -10.5 -10.5 -10.5 361.2 361.2 361.2 361.2 361.2 -339 0 0 0 0 0 0 0 0 0 0 0 0 0
V(r) even 0 172.9 172.9 172.9 172.9 172.9 -411 655.5 -439 -581 -581 -581 -628 -9.56 -9.56 -9.56 -9.56 -9.56 -9.56 670 670 670 670 670 -664 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 6 6 13.2 13.2 19.2 19.2 26.4 26.4 26.4 26.4 26.4 26.4
-714.81 ##### ##### 994.9 -715 994.9 -715 994.9 -715 994.9 -715 994.9 -715 994.9
0-Jan-00
Project Spreadsheets to BS 8110 & EC2
Location Advisory Group SEGMENTS ISUBFRAME ANALYSIS TO EC2 (DD ENV 1992-1-1 : 1992) Made by rmw Job No R68
Originated from RCCe21.xls' on CD © 1999 BCA for RCC Date
NON-PRISMATIC FEM'Sdistance 0.0125 0.05 0.1 0.15 0.2 0.25 0.3 0.35 0.4 0.45 0.5 0.55 0.6 0.65 0.7 0.75 0.8 0.85 0.9 0.95
width 0.025 0.05 0.05 0.05 0.05 0.05 0.05 0.05 0.05 0.05 0.05 0.05 0.05 0.05 0.05 0.05 0.05 0.05 0.05 0.05
SPAN 1 Aw1 = 240000 Af1 = 0 Xbar1 = 300 I1 = 7.2E+09 Xbar = 3.24378 Ix left Ix right
Aw2 = 333000 Af2 = 126000 Xbar2 = 201.961 I2 = 1E+10 I0 = 8.5E+09 e = -0.2438 6.4E+09 1.1E+10
distance 0.075 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
width 0.15 0.3 0.3 0.3 0.3 0.3 0.3 0.3 0.3 0.3 0.3 0.3 0.3 0.3 0.3 0.3 0.3 0.3 0.3 0.3
Ixx 7.2E+09 7.2E+09 7.2E+09 7.2E+09 7.2E+09 7.2E+09 7.2E+09 7.2E+09 7.2E+09 7.2E+09 7.2E+09 1E+10 1E+10 1E+10 1E+10 1E+10 1E+10 1E+10 1E+10 1E+10
MOMENT
UDL 0.22219 0.855 1.62 2.295 2.88 3.375 3.78 4.095 4.32 4.455 4.5 4.455 4.32 4.095 3.78 3.375 2.88 2.295 1.62 0.855
PL1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
PL2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
pUDL 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
MOMENT AREA
UDL 0.02825 0.21742 0.41195 0.5836 0.73236 0.85824 0.96122 1.04133 1.09854 1.13287 1.14431 1.56922 1.52167 1.44241 1.33146 1.1888 1.01445 0.80839 0.57063 0.30116
PL1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
PL2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
pUDL 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
AREA x DISTANCE
UDL 0.00212 0.06523 0.24717 0.52524 0.87883 1.28735 1.7302 2.18678 2.6365 3.05875 3.43294 5.17842 5.478 5.62541 5.59213 5.34961 4.86934 4.12277 3.08138 1.71663
PL1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
PL2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
pUDL 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
FEM FACTORS SA Sad d L-d FEM L FEM R factorL factorR
UDL 18 57.2967 3.184 2.816 2.44918 3.55082 14.6988 10.1385
PL1 0 0 0.000 6.000 0 0 1000 1000
PL2 0 0 0.000 6.000 0 0 1000 1000
pUDL 0 0 0.000 6.000 0 0
SPAN 2 Aw1 = 240000 Af1 = 0 Xbar1 = 300 I1 = 7.2E+09 Xbar = 3.14384 Ix left Ix right
Aw2 = 180000 Af2 = 0 Xbar2 = 225 I2 = 3E+09 I0 = 6.2E+09 e = 0.45616 8.5E+09 3.8E+09
distance 0.09 0.36 0.72 1.08 1.44 1.8 2.16 2.52 2.88 3.24 3.6 3.96 4.32 4.68 5.04 5.4 5.76 6.12 6.48 6.84
width 0.18 0.36 0.36 0.36 0.36 0.36 0.36 0.36 0.36 0.36 0.36 0.36 0.36 0.36 0.36 0.36 0.36 0.36 0.36 0.36
Ixx 7.2E+09 7.2E+09 7.2E+09 7.2E+09 7.2E+09 7.2E+09 7.2E+09 7.2E+09 7.2E+09 7.2E+09 7.2E+09 7.2E+09 7.2E+09 7.2E+09 7.2E+09 6.2E+09 3E+09 3E+09 3E+09 3E+09
MOMENT
UDL 0.31995 1.2312 2.3328 3.3048 4.1472 4.86 5.4432 5.8968 6.2208 6.4152 6.48 6.4152 6.2208 5.8968 5.4432 4.86 4.1472 3.3048 2.3328 1.2312
PL1 0.00563 0.0225 0.045 0.0675 0.09 0.1125 0.135 0.1575 0.18 0.2025 0.225 0.2475 0.27 0.2925 0.315 0.3375 0.36 0.3825 0.405 0.3375
PL2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
pUDL 0.243 0.972 1.944 2.86155 3.64995 4.30875 4.83795 5.23755 5.50755 5.64795 5.65875 5.53995 5.29155 4.91355 4.40595 3.76875 3.024 2.268 1.512 0.756
MOMENT AREA
UDL 0.06732 0.51812 0.98169 1.39073 1.74523 2.04519 2.29062 2.4815 2.61785 2.69966 2.72693 2.69966 2.61785 2.4815 2.29062 1.7496 0.73627 0.58672 0.41415 0.21858
PL1 0.00118 0.00947 0.01894 0.02841 0.03787 0.04734 0.05681 0.06628 0.07575 0.08522 0.09468 0.10415 0.11362 0.12309 0.13256 0.1215 0.06391 0.06791 0.0719 0.05992
PL2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
pUDL 0.05113 0.40904 0.81808 1.2042 1.53598 1.81322 2.03592 2.20408 2.3177 2.37678 2.38133 2.33133 2.2268 2.06773 1.85412 1.35675 0.53686 0.40265 0.26843 0.13422
AREA x DISTANCE
UDL 0.00606 0.18652 0.70682 1.50199 2.51314 3.68135 4.94773 6.25339 7.53941 8.74689 9.81693 10.6906 11.3091 11.6134 11.5447 9.44784 4.24092 3.5907 2.6837 1.49509
PL1 0.00011 0.00341 0.01363 0.03068 0.05454 0.08522 0.12271 0.16702 0.21815 0.2761 0.34087 0.41245 0.49085 0.57606 0.6681 0.6561 0.36814 0.41559 0.46592 0.40984
PL2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
pUDL 0.0046 0.14725 0.58902 1.30054 2.21181 3.26379 4.39758 5.55427 6.67497 7.70077 8.57277 9.23208 9.61978 9.67697 9.34477 7.32645 3.09233 2.4642 1.73944 0.91804
FEM FACTORS SA Sad d L-d FEM L FEM R factorL factorR
UDL 31.104 112.718 3.376 3.824 5.12642 3.51358 10.1123 14.7542
PL1 1.51875 5.82873 4.199 3.001 0.10558 0.31629 68.1942 22.7636
PL2 0 0 0.000 7.200 0 0 1000 1000
pUDL 28.3431 93.9507 3.315 3.885 4.87225 3.00084
SPAN 3 Aw1 = 180000 Af1 = 0 Xbar1 = 225 I1 = 3E+09 Xbar = 3 Ix left Ix right
Aw2 = 0 Af2 = 0 Xbar2 = 0 I2 = 0 I0 = 3E+09 e = 0 3E+09 3E+09
distance 0.075 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
width 0.15 0.3 0.3 0.3 0.3 0.3 0.3 0.3 0.3 0.3 0.3 0.3 0.3 0.3 0.3 0.3 0.3 0.3 0.3 0.3
Ixx 3E+09 3E+09 3E+09 3E+09 3E+09 3E+09 3E+09 3E+09 3E+09 3E+09 3E+09 3E+09 3E+09 3E+09 3E+09 3E+09 3E+09 3E+09 3E+09 3E+09
MOMENT
UDL 0.22219 0.855 1.62 2.295 2.88 3.375 3.78 4.095 4.32 4.455 4.5 4.455 4.32 4.095 3.78 3.375 2.88 2.295 1.62 0.855
PL1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
PL2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
pUDL 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
MOMENT AREA
UDL 0.03333 0.2565 0.486 0.6885 0.864 1.0125 1.134 1.2285 1.296 1.3365 1.35 1.3365 1.296 1.2285 1.134 1.0125 0.864 0.6885 0.486 0.2565
PL1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
PL2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
pUDL 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
AREA x DISTANCE
UDL 0.0025 0.07695 0.2916 0.61965 1.0368 1.51875 2.0412 2.57985 3.1104 3.60855 4.05 4.41045 4.6656 4.79115 4.7628 4.55625 4.1472 3.51135 2.6244 1.46205
PL1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
PL2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
pUDL 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
FEM FACTORS SA Sad d L-d FEM L FEM R factorL factorR
UDL 18 54.065 3.000 3.000 3 3 12 12
PL1 0 0 0.000 6.000 0 0 1000 1000
PL2 0 0 0.000 6.000 0 0 1000 1000
pUDL 0 0 0.000 6.000 0 0
30-Apr-14
Project Spreadsheets to BS 8110 & EC2
Location Advisory Group SEGMENTS IISUBFRAME ANALYSIS TO EC2 (DD ENV 1992-1-1 : 1992) Made by rmw Job No R68
Originated from RCCe21.xls' on CD © 1999 BCA for RCC Date
SPAN 4 Aw1 = 240000 Af1 = 0 Xbar1 = 300 I1 = 7.2E+09 Xbar = 3.6 Ix left Ix right
Aw2 = 0 Af2 = 0 Xbar2 = 0 I2 = 0 I0 = 7.2E+09 e = 0 7.2E+09 7.2E+09
distance 0.09 0.36 0.72 1.08 1.44 1.8 2.16 2.52 2.88 3.24 3.6 3.96 4.32 4.68 5.04 5.4 5.76 6.12 6.48 6.84
width 0.18 0.36 0.36 0.36 0.36 0.36 0.36 0.36 0.36 0.36 0.36 0.36 0.36 0.36 0.36 0.36 0.36 0.36 0.36 0.36
Ixx 7.2E+09 7.2E+09 7.2E+09 7.2E+09 7.2E+09 7.2E+09 7.2E+09 7.2E+09 7.2E+09 7.2E+09 7.2E+09 7.2E+09 7.2E+09 7.2E+09 7.2E+09 7.2E+09 7.2E+09 7.2E+09 7.2E+09 7.2E+09
MOMENT
UDL 0.31995 1.2312 2.3328 3.3048 4.1472 4.86 5.4432 5.8968 6.2208 6.4152 6.48 6.4152 6.2208 5.8968 5.4432 4.86 4.1472 3.3048 2.3328 1.2312
PL1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
PL2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
pUDL 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
MOMENT AREA
UDL 0.05759 0.44323 0.83981 1.18973 1.49299 1.7496 1.95955 2.12285 2.23949 2.30947 2.3328 2.30947 2.23949 2.12285 1.95955 1.7496 1.49299 1.18973 0.83981 0.44323
PL1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
PL2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
pUDL 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
AREA x DISTANCE
UDL 0.00518 0.15956 0.60466 1.28491 2.14991 3.14928 4.23263 5.34958 6.44973 7.48269 8.39808 9.14551 9.67459 9.93493 9.87614 9.44784 8.59963 7.28114 5.44196 3.03171
PL1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
PL2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
pUDL 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
FEM FACTORS SA Sad d L-d FEM L FEM R factorL factorR
UDL 31.104 112.109 3.600 3.600 4.32 4.32 12 12
PL1 0 0 0.000 7.200 0 0 1000 1000
PL2 0 0 0.000 7.200 0 0 1000 1000
pUDL 0 0 0.000 7.200 0 0
SPAN 5 Aw1 = 0 Af1 = 0 Xbar1 = 0 I1 = 0 Xbar = #DIV/0! Ix left Ix right
Aw2 = 0 Af2 = 0 Xbar2 = 0 I2 = 0 I0 = 0 e = #DIV/0! 0 0
distance 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
width 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Ixx 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
MOMENT
UDL 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
PL1 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
PL2 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
pUDL #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
MOMENT AREA
UDL #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
PL1 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
PL2 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
pUDL #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
AREA x DISTANCE
UDL #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
PL1 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
PL2 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
pUDL #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
FEM FACTORS SA Sad d L-d FEM L FEM R factorL factorR
UDL 0 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! 1000 1000
PL1 0 #DIV/0! 0.000 0.000 0 0 1000 1000
PL2 0 #DIV/0! 0.000 0.000 0 0 1000 1000
pUDL #DIV/0! #DIV/0! #DIV/0! #DIV/0! 0 0
SPAN 6 Aw1 = 0 Af1 = 0 Xbar1 = 0 I1 = 0 Xbar = #DIV/0! Ix left Ix right
Aw2 = 0 Af2 = 0 Xbar2 = 0 I2 = 0 I0 = #DIV/0! e = #DIV/0! #DIV/0! #DIV/0!
distance 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
width 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Ixx #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
MOMENT
UDL 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
PL1 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
PL2 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
pUDL #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
MOMENT AREA
UDL #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
PL1 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
PL2 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
pUDL #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
AREA x DISTANCE
UDL #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
PL1 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
PL2 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
pUDL #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
FEM FACTORS SA Sad d L-d FEM L FEM R factorL factorR
UDL 0 0 #DIV/0! #DIV/0! 0 0 1000 1000
PL1 0 0 0.000 0.000 0 0 1000 1000
PL2 0 0 0.000 0.000 0 0 1000 1000
pUDL 0 0 0.000 0.000 0 0
30-Apr-14
Made by rmw Job No R68
0.9875
0.025
5.925
0.15
1E+10
0.22219 3
0 1
0 1
0 0
0.03913
0
0
0
0.23185
0
0
0
7.11
0.18
3E+09
0.31995 3.6
0.08437 0.0625
0 1
0.189 2.7
0.0284
0.00749
0
0.01678
0.20193
0.05325
0
0.11928
5.925
0.15
3E+09
0.22219 3
0 1
0 1
0 0
0.03333
0
0
0
0.19747
0
0
0
Made by rmw Job No R68
7.11
0.18
7.2E+09
0.31995 3.6
0 1
0 1
0 0
0.05759
0
0
0
0.40947
0
0
0
0
0
0
0 0
#DIV/0! #DIV/0!
#DIV/0! #DIV/0!
#DIV/0! #DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
0
0
#DIV/0!
0 0
#DIV/0! #DIV/0!
#DIV/0! #DIV/0!
#DIV/0! #DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
Disclaimer
Status of spreadsheet
Public release version.
Revision history RCCe21 Subframe Analysis
Date Version
09-Aug-99 RCCe21 v1.0
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 and EC2' available from British Cement Association, Telford Avenue, Crowthorne, Berkshire
RG45 6YS.
Revision history RCCe21 Subframe Analysis
Action Size (kB)
First public release.
Includes b version comments1306
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 and EC2' available from British Cement Association, Telford Avenue, Crowthorne, Berkshire
RG45 6YS.