Spreadsheets To BS 8110: Advisory Group Columns at A1, A2 Etc RMW

REINFORCED CONCRETE
Project Spreadsheets to BS 8110 COUNCIL

Client Advisory Group Made by Date
Location Columns at A1, A2 etc RMW 15-May-19
COLUMN CHART FOR SYMMETRICALLY REINFORCED RECTANGULAR
COLUMNS BENT ABOUT THE X-X AXIS TO BS 8110:1997 Checked Revision
Originated from 'RCC52.xls' on CD © 1999 BCA for RCC chg -
MATERIALS
fcu 35 N/mm² gm 1.05 steel Cover 30 mm
fy 460 N/mm² gm 1.5 concrete h agg 20 mm
SECTION
h 300 mm
b 300 mm X X SINGLE AXIS
with 3 bars per face BENDING
All bars in 300 wide faces
BAR ARRANGEMENTS
Type Bar Ø Asc % Link Ø Bar c/c Nbal (kN) Nuz (kN) Checks
T 40 8.38 10 90.0 0.0 0.0 Asc > 6 %
T 32 5.36 8 96.0 715.0 3445.6 ok
T 25 3.27 8 99.5 703.3 2651.3 ok
T 20 2.09 6 104.0 703.4 2203.3 ok
T 16 1.34 6 106.0 701.2 1916.6 ok
T 12 0.75 6 108.0 700.6 1693.7 ok
N:M INTERACTION CHART for 300 x 300 column, grade C35, 30 mm cover and 3 bars
on 300 mm faces
4000
3500 M min
AXIAL COMPRESSION, N, kN
3000 3000
2500
2000
1850
1500 1500
1000 1000 1000
500 500
0.1fcuAc
0
0 50 100 150 200 250 300
MOMENT Mx
kNm
LOADCASES Load case N (kN) Mx' (kNm) Load case N (kN) Mx' (kNm)
A1 top 500 200 6 T32 4 1500 150
A1 bot 1850 100 6 T32 5 1000 150
A2 bot 3000 50 No Fit 6 1000 50
REINFORCED CONCRETE
COUNCIL
Page
89
Job No
R68
SINGLE AXIS
Checks
Asc > 6 %
ok
ok
ok
ok
ok
KEY
6T32
6T25
6T20
6T16
6T12
6 T32
6 T25
6 T12
Project Spreadsheets to BS 8110
Location Columns at A1, A2 etc CALCULATIONS I
COLUMN CHART FOR SYMMETRICALLY REINFORCED RECTANGULAR COLUMNS BENT ABOUT THE X-X AXIS TO BS 8110:1997 Made by RMW Job No R68
Originated from 'RCC52.xls' on CD © 1999 BCA for RCC Date 15-May-19
CALCULATIONS
.67fcu/gm = 15.63 N/mm² ALL CALCULATIONS DERIVED FROM 0.00 #DIV/0!

fy/gm = 438.10 N/mm² FIGURE 3.3 AND CLAUSE 3.4.4.1 315.00 315.00
net fy/gm = 422.46 N/mm²
40 Bar diameter
d' = 60 mm d= 0 mm Asc = 0.0 mm²
N=0 quadratic a = 4221.000 b= 0.00 c = 0.E+00
n max = 0.0 Interval = 0.000 (24 intervals between N=0 and Nbal)
N=0 (solve for zero N)
n Neutral axis 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Fc Conc comp force 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
c strain Steel comp strain #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!
t strain Steel tens strain #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!
fsc Steel comp stress #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!
fst Steel tens stress #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!
Fsc Steel comp force #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!
Fst Steel tens force #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!
z Conc lever arm 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
N Fc + Fsc - Fst 0.00 #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!
M MOR #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!
Labels for chart
N diff #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!
M diff #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!
32 Bar diameter
d' = 54 mm d= 246 mm Asc = 4825.5 mm²
N=0 quadratic a = 4221.000 b = 594189.70 c = -9.E+07
n Neutral axis 92.59 95.25 97.92 100.58 103.25 105.91 108.58 111.24 113.91 116.57 119.24 121.90 124.57 127.23 129.90 132.56 135.23 137.89 140.56
c strain Steel comp strain 0.00146 0.00152 0.00157 0.00162 0.00167 0.00172 0.00176 0.00180 0.00184 0.00188 0.00191 0.00195 0.00198 0.00201 0.00205 0.00207 0.00210 0.00213 0.00216
t strain Steel tens strain 0.00580 0.00554 0.00529 0.00506 0.00484 0.00463 0.00443 0.00424 0.00406 0.00389 0.00372 0.00356 0.00341 0.00327 0.00313 0.00300 0.00287 0.00274 0.00263
fsc Steel comp stress 276.11 287.53 298.33 308.56 318.26 327.47 336.23 344.57 352.52 360.11 367.35 374.28 380.92 387.27 393.37 399.22 404.84 410.24 415.44
fst Steel tens stress 438.1 438.1 438.1 438.1 438.1 438.1 438.1 438.1 438.1 438.1 438.1 438.1 438.1 438.1 438.1 438.1 438.1 438.1 438.1
Fsc Steel comp force 666191 693747 719804 744480 767882 790107 811240 831362 850541 868844 886329 903049 919054 934389 949094 963208 976766 989800 1002339
Fst Steel tens force 1057011 1057011 1057011 1057011 1057011 1057011 1057011 1057011 1057011 1057011 1057011 1057011 1057011 1057011 1057011 1057011 1057011 1057011 1057011
z Conc lever arm 204.33 203.14 201.94 200.74 199.54 198.34 197.14 195.94 194.74 193.54 192.34 191.14 189.94 188.75 187.55 186.35 185.15 183.95 182.75
N Fc + Fsc - Fst 0.00 38.80 76.11 112.03 146.68 180.16 212.54 243.91 274.34 303.89 332.62 360.59 387.84 414.43 440.38 465.74 490.55 514.83 538.62
M MOR 207.77 211.15 214.36 217.41 220.31 223.08 225.71 228.21 230.60 232.88 235.05 237.12 239.10 240.98 242.78 244.49 246.13 247.68 249.17
Labels for chart
N diff 38.80 37.30 35.92 34.65 33.47 32.38 31.37 30.43 29.55 28.73 27.97 27.25 26.58 25.95 25.36 24.81 24.28 23.79 23.32
M diff 3.38 3.21 3.05 2.90 2.76 2.63 2.51 2.39 2.28 2.17 2.07 1.98 1.88 1.80 1.71 1.63 1.56 1.48 1.41
25 Bar diameter
d' = 50.5 mm d= 249.5 mm Asc = 2945.2 mm²
N=0 quadratic a = 4221.000 b = 3.63E+05 c = -5.E+07
n Neutral axis 76.11 79.56 83.00 86.45 89.89 93.33 96.78 100.22 103.67 107.11 110.55 114.00 117.44 120.89 124.33 127.78 131.22 134.66 138.11
z Conc lever arm 215.25 213.70 212.15 210.60 209.05 207.50 205.95 204.40 202.85 201.30 199.75 198.20 196.65 195.10 193.55 192.00 190.45 188.90 187.35
N Fc + Fsc - Fst 0.00 44.15 85.83 125.36 162.97 198.88 233.27 266.29 298.08 328.77 358.45 387.21 415.14 442.30 468.77 494.59 519.83 544.51 559.93
M MOR 133.60 137.71 141.53 145.09 148.41 151.52 154.43 157.16 159.73 162.14 164.40 166.53 168.53 170.40 172.17 173.82 175.37 176.82 177.31
Labels for chart
N diff 44.15 41.69 39.53 37.61 35.91 34.39 33.02 31.79 30.68 29.68 28.76 27.93 27.17 26.47 25.82 25.23 24.68 15.42 14.54
M diff 4.11 3.82 3.56 3.32 3.11 2.91 2.73 2.56 2.41 2.26 2.13 2.00 1.88 1.76 1.65 1.55 1.45 0.48 0.35
20 Bar diameter
d' = 46 d= 254 mm Asc 1885.0 mm²
n Neutral axis 61.64 65.81 69.98 74.14 78.31 82.48 86.64 90.81 94.97 99.14 103.31 107.47 111.64 115.81 119.97 124.14 128.31 132.47 136.64
z Conc lever arm 226.26 224.39 222.51 220.64 218.76 216.89 215.01 213.14 211.26 209.39 207.51 205.64 203.76 201.89 200.01 198.14 196.26 194.39 192.51
N Fc + Fsc - Fst 0.00 48.75 93.79 135.75 175.11 212.28 247.56 281.21 313.46 344.47 374.41 403.38 431.50 458.87 485.56 509.26 526.84 544.43 562.02
M MOR 90.63 95.50 99.92 103.95 107.65 111.05 114.19 117.10 119.79 122.29 124.61 126.76 128.76 130.62 132.33 133.68 134.32 134.89 135.40
Labels for chart
N diff 48.75 45.04 41.96 39.36 37.16 35.28 33.66 32.25 31.01 29.93 28.97 28.12 27.37 26.69 23.70 17.59 17.59 17.59 17.59
M diff 4.87 4.42 4.03 3.70 3.40 3.14 2.90 2.69 2.50 2.32 2.15 2.00 1.86 1.72 1.34 0.64 0.57 0.51 0.44
16 Bar diameter
d' = 44 d= 256 mm Asc 1206.4 mm²
n Neutral axis 51.04 55.70 60.36 65.02 69.69 74.35 79.01 83.67 88.33 92.99 97.65 102.31 106.97 111.64 116.30 120.96 125.62 130.28 134.94
z Conc lever arm 233.03 230.93 228.84 226.74 224.64 222.54 220.45 218.35 216.25 214.15 212.06 209.96 207.86 205.76 203.67 201.57 199.47 197.37 195.28
N Fc + Fsc - Fst 0.00 50.13 95.56 137.30 176.09 212.48 246.89 279.67 311.06 341.28 370.49 398.83 426.42 453.35 479.69 501.14 520.81 540.49 560.16
M MOR 60.55 65.79 70.44 74.62 78.41 81.85 85.01 87.91 90.58 93.04 95.32 97.42 99.35 101.14 102.78 103.82 104.58 105.27 105.87
Labels for chart
N diff 50.13 45.43 41.74 38.79 36.39 34.42 32.77 31.39 30.22 29.21 28.34 27.59 26.93 26.34 21.44 19.67 19.67 19.67 19.67
M diff 5.23 4.65 4.18 3.78 3.45 3.16 2.90 2.67 2.46 2.27 2.10 1.94 1.78 1.64 1.04 0.77 0.69 0.60 0.52
12 Bar diameter
d' = 42 d= 258 mm Asc 678.6 mm²
N=0 quadratic a= 4221.000 b = 8.36E+04 c = -9.98E+06
n Neutral axis 39.71 44.90 50.08 55.27 60.46 65.64 70.83 76.02 81.20 86.39 91.57 96.76 101.95 107.13 112.32 117.51 122.69 127.88 133.06
c strain Steel comp strain -0.00020 0.00023 0.00056 0.00084 0.00107 0.00126 0.00142 0.00157 0.00169 0.00180 0.00189 0.00198 0.00206 0.00213 0.00219 0.00225 0.00230 0.00235 0.00240
fsc Steel comp stress -55.95 29.56 97.36 152.44 198.07 236.49 269.29 297.61 322.31 344.04 363.32 380.53 395.98 409.94 422.46 422.46 422.46 422.46 422.46
Fsc Steel comp force -18985 10030 33035 51723 67205 80241 91367 100975 109357 116731 123271 129109 134354 139090 143338 143338 143338 143338 143338
z Conc lever arm 240.13 237.80 235.46 233.13 230.79 228.46 226.13 223.79 221.46 219.13 216.79 214.46 212.12 209.79 207.46 205.12 202.79 200.45 198.12
N Fc + Fsc - Fst 0.00 50.91 95.80 136.38 173.75 208.68 241.70 273.20 303.47 332.74 361.17 388.89 416.03 442.66 468.80 490.69 512.58 534.47 556.36
M MOR 36.15 41.74 46.57 50.83 54.65 58.10 61.24 64.11 66.75 69.18 71.42 73.48 75.37 77.11 78.69 79.71 80.62 81.44 82.15
Labels for chart
N diff 50.91 44.90 40.58 37.37 34.93 33.02 31.50 30.27 29.27 28.43 27.73 27.14 26.63 26.14 21.89 21.89 21.89 21.89 21.89
M diff 5.58 4.83 4.26 3.82 3.45 3.14 2.87 2.64 2.43 2.24 2.06 1.89 1.74 1.58 1.02 0.92 0.82 0.71 0.61
0 0 0 0 0 0
LOADCASES 200 100 50 150 150 50
500 1850 3000 1500 1000 1000

1 2 3 4 5 6
Column Chart generation BS 8110.xls 5/15/2019

Location Columns at A1, A2 etc CALCULATIONS II
Interval = 0.000 (27 intervals between Nbal and Nuz)

N bal (solve for Nbal)
0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 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! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
6T40

143.22 145.89 148.55 151.22 153.88 156.55 175.10 193.65 212.21 230.76 249.31 267.87 286.42 304.97 323.53 342.08 360.63 379.19 397.74 416.29 434.85
604537 615785 627034 638282 649530 660778 739093 817407 895722 974036 1052351 1130665 1208980 1287294 1365609 1407000 1407000 1407000 1407000 1407000 1407000
0.00218 0.00220 0.00223 0.00225 0.00227 0.00229 0.00242 0.00252 0.00261 0.00268 0.00274 0.00279 0.00284 0.00288 0.00292 0.00295 0.00298 0.00300 0.00302 0.00305 0.00307
0.00251 0.00240 0.00230 0.00219 0.00210 0.00200 0.00142 0.00095 0.00056 0.00023 -0.00005 -0.00029 -0.00049 -0.00068 -0.00084 -0.00098 -0.00111 -0.00123 -0.00134 -0.00143 -0.00152
420.44 422.46 422.46 422.46 422.46 422.46 422.46 422.46 422.46 422.46 422.46 422.46 422.46 422.46 422.46 422.46 422.46 422.46 422.46 422.46 422.46
438.1 438.1 438.1 438.1 419.0 400.0 283.4 189.2 111.5 46.2 -9.3 -57.1 -83.2 -119.7 -152.1 -181.0 -206.9 -230.2 -251.4 -270.7 -288.4
1014412 1019292 1019292 1019292 1019292 1019292 1019292 1019292 1019292 1019292 1019292 1019292 1019292 1019292 1019292 1019292 1019292 1019292 1019292 1019292 1019292
1057011 1057011 1057011 1057011 1011058 965097 683877 456543 268962 111544 -22444 -137871 -200625 -288873 -366999 -436651 -499136 -555506 -606617 -653172 -695755
181.55 180.35 179.15 177.95 176.75 175.55 167.21 158.86 150.51 142.16 133.81 125.46 117.11 108.76 100.41 96.00 96.00 96.00 96.00 96.00 96.00
561.94 578.07 589.31 600.56 657.76 714.97 1074.51 1380.16 1646.05 1881.78 2094.09 2287.83 2428.90 2595.46 2751.90 2862.94 2925.43 2981.80 3032.91 3079.46 3122.05
250.58 251.27 251.46 251.63 247.37 243.07 216.13 193.06 172.50 153.52 135.49 117.93 104.11 86.55 68.65 55.93 49.94 44.52 39.62 35.15 31.06
6T32
16.13 11.25 11.25 57.20 57.21 359.53 305.65 265.90 235.73 212.30 193.74 141.07 166.56 156.44 111.04 62.48 56.37 51.11 46.56 42.58 39.10
0.69 0.20 0.17 -4.27 -4.30 -26.94 -23.07 -20.56 -18.98 -18.03 -17.56 -13.81 -17.57 -17.90 -12.71 -6.00 -5.41 -4.91 -4.47 -4.09 -3.75

141.55 145.00 148.44 151.88 155.33 158.77 177.59 196.41 215.23 234.04 252.86 271.68 290.50 309.31 328.13 346.95 365.77 384.58 403.40 422.22 441.04
597491 612029 626567 641104 655642 670180 749608 829037 908466 987894 1067323 1146752 1226181 1305609 1385038 1407000 1407000 1407000 1407000 1407000 1407000
0.00225 0.00228 0.00231 0.00234 0.00236 0.00239 0.00250 0.00260 0.00268 0.00274 0.00280 0.00285 0.00289 0.00293 0.00296 0.00299 0.00302 0.00304 0.00306 0.00308 0.00310
0.00267 0.00252 0.00238 0.00225 0.00212 0.00200 0.00142 0.00095 0.00056 0.00023 -0.00005 -0.00029 -0.00049 -0.00068 -0.00084 -0.00098 -0.00111 -0.00123 -0.00134 -0.00143 -0.00152
422.46 422.46 422.46 422.46 422.46 422.46 422.46 422.46 422.46 422.46 422.46 422.46 422.46 422.46 422.46 422.46 422.46 422.46 422.46 422.46 422.46
438.1 438.1 438.1 438.1 424.4 400.0 283.4 189.2 111.5 46.2 -9.3 -57.1 -83.2 -119.7 -152.1 -181.0 -206.9 -230.2 -251.4 -270.7 -288.4
622127 622127 622127 622127 622127 622127 622127 622127 622127 622127 622127 622127 622127 622127 622127 622127 622127 622127 622127 622127 622127
645148 645148 645148 645148 624967 589049 417405 278652 164161 68081 -13699 -84150 -122452 -176314 -223998 -266510 -304648 -339054 -370250 -398665 -424655
185.80 184.25 182.70 181.15 179.60 178.05 169.58 161.12 152.65 144.18 135.71 127.25 118.78 110.31 101.84 99.50 99.50 99.50 99.50 99.50 99.50
574.47 589.01 603.54 618.08 652.80 703.26 954.33 1172.51 1366.43 1541.94 1703.15 1853.03 1970.76 2104.05 2231.16 2295.64 2333.77 2368.18 2399.38 2427.79 2453.78
177.66 177.96 178.23 178.44 176.60 173.16 155.97 140.71 126.52 112.82 99.19 85.35 73.35 58.47 42.86 35.38 31.59 28.17 25.06 22.23 19.65
6T25
14.54 14.54 14.54 34.72 50.46 251.07 218.18 193.92 175.51 161.21 149.88 117.73 133.29 127.11 64.47 38.14 34.41 31.20 28.42 25.99 23.86
0.31 0.26 0.22 -1.84 -3.45 -17.19 -15.26 -14.19 -13.70 -13.63 -13.84 -11.99 -14.88 -15.61 -7.47 -3.79 -3.42 -3.10 -2.83 -2.59 -2.37

140.80 144.97 149.14 153.30 157.47 161.64 180.79 199.95 219.11 238.26 257.42 276.58 295.73 314.89 334.05 353.21 372.36 391.52 410.68 429.83 448.99
594336 611923 629509 647095 664681 682267 763128 843990 924851 1005712 1086574 1167435 1248296 1329157 1407000 1407000 1407000 1407000 1407000 1407000 1407000
0.00236 0.00239 0.00242 0.00245 0.00248 0.00250 0.00261 0.00269 0.00277 0.00282 0.00287 0.00292 0.00296 0.00299 0.00302 0.00304 0.00307 0.00309 0.00311 0.00313 0.00314
0.00281 0.00263 0.00246 0.00230 0.00215 0.00200 0.00142 0.00095 0.00056 0.00023 -0.00005 -0.00029 -0.00049 -0.00068 -0.00084 -0.00098 -0.00111 -0.00123 -0.00134 -0.00143 -0.00152
422.46 422.46 422.46 422.46 422.46 422.46 422.46 422.46 422.46 422.46 422.46 422.46 422.46 422.46 422.46 422.46 422.46 422.46 422.46 422.46 422.46
438.1 438.1 438.1 438.1 429.1 400.0 283.4 189.2 111.5 46.2 -9.3 -57.1 -83.2 -119.7 -152.1 -181.0 -206.9 -230.2 -251.4 -270.7 -288.4
398161 398161 398161 398161 398161 398161 398161 398161 398161 398161 398161 398161 398161 398161 398161 398161 398161 398161 398161 398161 398161
412895 412895 412895 412895 404421 376991 267139 178337 105063 43572 -8767 -53856 -78369 -112841 -143359 -170567 -194975 -216994 -236960 -255145 -271779
190.64 188.76 186.89 185.01 183.14 181.26 172.64 164.02 155.40 146.78 138.16 129.54 120.92 112.30 104.00 104.00 104.00 104.00 104.00 104.00 104.00
579.60 597.19 614.77 632.36 658.42 703.44 894.15 1063.81 1217.95 1360.30 1493.50 1619.45 1724.83 1840.16 1948.52 1975.73 2000.14 2022.16 2042.12 2060.31 2076.94
135.84 136.22 136.53 136.77 136.07 133.33 121.57 110.61 99.87 88.97 77.61 65.62 54.38 40.70 26.50 23.67 21.13 18.84 16.76 14.87 13.14
6T20
17.59 17.59 17.59 26.06 45.02 190.71 169.66 154.14 142.35 133.20 125.95 105.37 115.33 108.36 27.21 24.41 22.02 19.97 18.19 16.63 15.27
0.38 0.31 0.24 -0.70 -2.74 -11.76 -10.96 -10.74 -10.91 -11.35 -11.99 -11.25 -13.68 -14.20 -2.83 -2.54 -2.29 -2.08 -1.89 -1.73 -1.59

139.60 144.26 148.93 153.59 158.25 162.91 182.22 201.52 220.83 240.14 259.45 278.76 298.06 317.37 336.68 355.99 375.29 394.60 413.91 433.22 452.53
589265 608940 628615 648289 667964 687639 769137 850635 932133 1013631 1095129 1176627 1258125 1339623 1407000 1407000 1407000 1407000 1407000 1407000 1407000
0.00240 0.00243 0.00247 0.00250 0.00253 0.00255 0.00265 0.00274 0.00280 0.00286 0.00291 0.00295 0.00298 0.00301 0.00304 0.00307 0.00309 0.00311 0.00313 0.00314 0.00316
0.00292 0.00271 0.00252 0.00233 0.00216 0.00200 0.00142 0.00095 0.00056 0.00023 -0.00005 -0.00029 -0.00049 -0.00068 -0.00084 -0.00098 -0.00111 -0.00123 -0.00134 -0.00143 -0.00152
422.46 422.46 422.46 422.46 422.46 422.46 422.46 422.46 422.46 422.46 422.46 422.46 422.46 422.46 422.46 422.46 422.46 422.46 422.46 422.46 422.46
438.1 438.1 438.1 438.1 432.4 400.0 283.4 189.2 111.5 46.2 -9.3 -57.1 -83.2 -119.7 -152.1 -181.0 -206.9 -230.2 -251.4 -270.7 -288.4
254823 254823 254823 254823 254823 254823 254823 254823 254823 254823 254823 254823 254823 254823 254823 254823 254823 254823 254823 254823 254823
264253 264253 264253 264253 260818 241274 170969 114136 67240 27886 -5611 -34468 -50156 -72218 -91750 -109163 -124784 -138876 -151654 -163293 -173939
193.18 191.08 188.98 186.89 184.79 182.69 174.00 165.31 156.63 147.94 139.25 130.56 121.87 113.18 106.00 106.00 106.00 106.00 106.00 106.00 106.00
579.83 599.51 619.18 638.86 661.97 701.19 852.99 991.32 1119.72 1240.57 1355.56 1465.92 1563.10 1666.66 1753.57 1770.99 1786.61 1800.70 1813.48 1825.12 1835.76
106.39 106.83 107.19 107.46 107.29 105.32 97.44 89.56 81.33 72.48 62.83 52.26 41.66 28.98 17.29 15.44 13.78 12.29 10.94 9.70 8.57
6T16
19.67 19.67 19.67 23.11 39.22 151.80 138.33 128.39 120.85 114.99 110.35 97.19 103.56 86.91 17.41 15.62 14.09 12.78 11.64 10.65 9.77
0.44 0.36 0.27 -0.17 -1.96 -7.88 -7.87 -8.24 -8.85 -9.65 -10.57 -10.59 -12.68 -11.69 -1.85 -1.66 -1.49 -1.35 -1.23 -1.13 -1.04

138.25 143.44 148.62 153.81 159.00 164.18 183.64 203.10 222.56 242.02 261.47 280.93 300.39 319.85 339.31 358.77 378.23 397.68 417.14 436.60 456.06
583556 605447 627338 649229 671120 693011 775146 857281 939416 1021550 1103685 1185820 1267954 1350089 1407000 1407000 1407000 1407000 1407000 1407000 1407000
0.00244 0.00248 0.00251 0.00254 0.00258 0.00260 0.00270 0.00278 0.00284 0.00289 0.00294 0.00298 0.00301 0.00304 0.00307 0.00309 0.00311 0.00313 0.00315 0.00316 0.00318
0.00303 0.00280 0.00258 0.00237 0.00218 0.00200 0.00142 0.00095 0.00056 0.00023 -0.00005 -0.00029 -0.00049 -0.00068 -0.00084 -0.00098 -0.00111 -0.00123 -0.00134 -0.00143 -0.00152
422.46 422.46 422.46 422.46 422.46 422.46 422.46 422.46 422.46 422.46 422.46 422.46 422.46 422.46 422.46 422.46 422.46 422.46 422.46 422.46 422.46
438.1 438.1 438.1 438.1 435.9 400.0 283.4 189.2 111.5 46.2 -9.3 -57.1 -83.2 -119.7 -152.1 -181.0 -206.9 -230.2 -251.4 -270.7 -288.4
143338 143338 143338 143338 143338 143338 143338 143338 143338 143338 143338 143338 143338 143338 143338 143338 143338 143338 143338 143338 143338
148642 148642 148642 148642 147891 135717 96170 64201 37823 15686 -3156 -19388 -28213 -40623 -51609 -61404 -70191 -78118 -85305 -91852 -97841
195.79 193.45 191.12 188.79 186.45 184.12 175.36 166.61 157.85 149.09 140.34 131.58 122.82 114.07 108.00 108.00 108.00 108.00 108.00 108.00 108.00
578.25 600.14 622.03 643.93 666.57 700.63 822.31 936.42 1044.93 1149.20 1250.18 1348.55 1439.51 1534.05 1601.95 1611.74 1620.53 1628.46 1635.64 1642.19 1648.18
82.76 83.27 83.68 83.98 84.10 82.89 78.08 72.66 66.39 59.15 50.83 41.35 31.23 19.28 9.91 8.85 7.90 7.04 6.27 5.56 4.91
6T12
21.89 21.89 21.89 22.64 34.06 121.68 114.10 108.51 104.27 100.98 98.37 90.96 94.54 67.90 9.79 8.79 7.93 7.19 6.55 5.99 5.50
0.51 0.41 0.30 0.12 -1.21 -4.81 -5.43 -6.26 -7.24 -8.32 -9.48 -10.12 -11.94 -9.38 -1.06 -0.95 -0.86 -0.78 -0.71 -0.65 -0.59

Location Columns at A1, A2 etc CALCULATIONS III
solve for Nuz Nuz

0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
0 0 0 0 0 0 0 0 0 0 0 0
#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.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! 0
#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! 0
solve for Nuz Nuz

453.40 471.96 490.51 509.06 527.62 546.17 564.72 583.28 601.83 620.38 638.94 657.49
1407000 1407000 1407000 1407000 1407000 1407000 1407000 1407000 1407000 1407000 1407000 1407000
0.00308 0.00310 0.00311 0.00313 0.00314 0.00315 0.00317 0.00318 0.00319 0.00320 0.00320 0.00321
-0.00160 -0.00168 -0.00174 -0.00181 -0.00187 -0.00192 -0.00198 -0.00202 -0.00207 -0.00211 -0.00215 -0.00219
422.46 422.46 422.46 422.46 422.46 422.46 422.46 422.46 422.46 422.46 422.46 422.46
-304.6 -319.5 -333.3 -346.1 -358.0 -369.1 -379.4 -389.1 -398.2 -406.8 -414.9 -422.5
1019292 1019292 1019292 1019292 1019292 1019292 1019292 1019292 1019292 1019292 1019292 1019292
-734852 -770876 -804174 -835045 -863745 -890495 -915488 -938890 -960850 -981496 -1000943 -1019292
96.00 96.00 96.00 96.00 96.00 96.00 96.00 96.00 96.00 96.00 96.00 96.00
3161.14 3197.17 3230.47 3261.34 3290.04 3316.79 3341.78 3365.18 3387.14 3407.79 3427.23 3445.58
27.31 23.85 20.65 17.69 14.93 12.36 9.97 7.72 5.61 3.63 1.76 0.00
36.02 33.30 30.87 28.70 26.75 24.99 23.40 21.96 20.65 19.45 18.35 0
-3.46 -3.20 -2.96 -2.76 -2.57 -2.40 -2.25 -2.11 -1.98 -1.87 -1.76 0
solve for Nuz Nuz

459.85 478.67 497.49 516.31 535.12 553.94 572.76 591.58 610.39 629.21 648.03 666.85
1407000 1407000 1407000 1407000 1407000 1407000 1407000 1407000 1407000 1407000 1407000 1407000
0.00312 0.00313 0.00314 0.00316 0.00317 0.00318 0.00319 0.00320 0.00321 0.00322 0.00323 0.00323
-0.00160 -0.00168 -0.00174 -0.00181 -0.00187 -0.00192 -0.00198 -0.00202 -0.00207 -0.00211 -0.00215 -0.00219
422.46 422.46 422.46 422.46 422.46 422.46 422.46 422.46 422.46 422.46 422.46 422.46
-304.6 -319.5 -333.3 -346.1 -358.0 -369.1 -379.4 -389.1 -398.2 -406.8 -414.9 -422.5
622127 622127 622127 622127 622127 622127 622127 622127 622127 622127 622127 622127
-448518 -470505 -490829 -509671 -527188 -543515 -558769 -573053 -586456 -599057 -610927 -622127
99.50 99.50 99.50 99.50 99.50 99.50 99.50 99.50 99.50 99.50 99.50 99.50
2477.64 2499.63 2519.96 2538.80 2556.31 2572.64 2587.90 2602.18 2615.58 2628.18 2640.05 2651.25
17.27 15.09 13.06 11.19 9.45 7.82 6.30 4.88 3.55 2.30 1.11 0.00
21.99 20.32 18.84 17.52 16.33 15.25 14.28 13.40 12.60 11.87 11.20 0
-2.19 -2.02 -1.87 -1.74 -1.62 -1.52 -1.42 -1.33 -1.25 -1.18 -1.11 0
solve for Nuz Nuz

468.15 487.30 506.46 525.62 544.77 563.93 583.09 602.25 621.40 640.56 659.72 678.87
1407000 1407000 1407000 1407000 1407000 1407000 1407000 1407000 1407000 1407000 1407000 1407000
0.00316 0.00317 0.00318 0.00319 0.00320 0.00321 0.00322 0.00323 0.00324 0.00325 0.00326 0.00326
-0.00160 -0.00168 -0.00174 -0.00181 -0.00187 -0.00192 -0.00198 -0.00202 -0.00207 -0.00211 -0.00215 -0.00219
422.46 422.46 422.46 422.46 422.46 422.46 422.46 422.46 422.46 422.46 422.46 422.46
-304.6 -319.5 -333.3 -346.1 -358.0 -369.1 -379.4 -389.1 -398.2 -406.8 -414.9 -422.5
398161 398161 398161 398161 398161 398161 398161 398161 398161 398161 398161 398161
-287052 -301123 -314131 -326190 -337400 -347850 -357612 -366754 -375332 -383397 -390993 -398161
104.00 104.00 104.00 104.00 104.00 104.00 104.00 104.00 104.00 104.00 104.00 104.00
2092.21 2106.28 2119.29 2131.35 2142.56 2153.01 2162.77 2171.91 2180.49 2188.56 2196.15 2203.32
11.56 10.09 8.74 7.49 6.32 5.23 4.22 3.27 2.37 1.54 0.75 0.00
14.07 13.01 12.06 11.21 10.45 9.76 9.14 8.58 8.06 7.60 7.17 0
-1.46 -1.35 -1.25 -1.17 -1.09 -1.02 -0.95 -0.89 -0.84 -0.79 -0.75 0
solve for Nuz Nuz

471.83 491.14 510.45 529.76 549.06 568.37 587.68 606.99 626.29 645.60 664.91 684.22
1407000 1407000 1407000 1407000 1407000 1407000 1407000 1407000 1407000 1407000 1407000 1407000
0.00317 0.00319 0.00320 0.00321 0.00322 0.00323 0.00324 0.00325 0.00325 0.00326 0.00327 0.00327
-0.00160 -0.00168 -0.00174 -0.00181 -0.00187 -0.00192 -0.00198 -0.00202 -0.00207 -0.00211 -0.00215 -0.00219
422.46 422.46 422.46 422.46 422.46 422.46 422.46 422.46 422.46 422.46 422.46 422.46
-304.6 -319.5 -333.3 -346.1 -358.0 -369.1 -379.4 -389.1 -398.2 -406.8 -414.9 -422.5
254823 254823 254823 254823 254823 254823 254823 254823 254823 254823 254823 254823
-183713 -192719 -201044 -208761 -215936 -222624 -228872 -234723 -240212 -245374 -250236 -254823
106.00 106.00 106.00 106.00 106.00 106.00 106.00 106.00 106.00 106.00 106.00 106.00
1845.54 1854.54 1862.87 1870.58 1877.76 1884.45 1890.69 1896.55 1902.04 1907.20 1912.06 1916.65
7.54 6.58 5.70 4.88 4.12 3.41 2.75 2.13 1.55 1.00 0.49 0.00
9.01 8.32 7.72 7.17 6.69 6.25 5.85 5.49 5.16 4.86 4.59 0
-0.95 -0.88 -0.82 -0.76 -0.71 -0.66 -0.62 -0.58 -0.55 -0.52 -0.49 0
solve for Nuz Nuz

475.52 494.98 514.44 533.89 553.35 572.81 592.27 611.73 631.19 650.65 670.11 689.56
1407000 1407000 1407000 1407000 1407000 1407000 1407000 1407000 1407000 1407000 1407000 1407000
0.00319 0.00320 0.00321 0.00322 0.00323 0.00324 0.00325 0.00326 0.00327 0.00327 0.00328 0.00329
-0.00160 -0.00168 -0.00174 -0.00181 -0.00187 -0.00192 -0.00198 -0.00202 -0.00207 -0.00211 -0.00215 -0.00219
422.46 422.46 422.46 422.46 422.46 422.46 422.46 422.46 422.46 422.46 422.46 422.46
-304.6 -319.5 -333.3 -346.1 -358.0 -369.1 -379.4 -389.1 -398.2 -406.8 -414.9 -422.5
143338 143338 143338 143338 143338 143338 143338 143338 143338 143338 143338 143338
-103339 -108404 -113087 -117428 -121464 -125226 -128740 -132031 -135119 -138023 -140758 -143338
108.00 108.00 108.00 108.00 108.00 108.00 108.00 108.00 108.00 108.00 108.00 108.00
1653.68 1658.74 1663.42 1667.77 1671.80 1675.56 1679.08 1682.37 1685.46 1688.36 1691.10 1693.68
4.32 3.77 3.27 2.80 2.36 1.96 1.58 1.22 0.89 0.57 0.28 0.00
5.07 4.68 4.34 4.04 3.76 3.51 3.29 3.09 2.90 2.73 2.58 0
-0.55 -0.51 -0.47 -0.44 -0.41 -0.38 -0.36 -0.33 -0.31 -0.30 -0.28 0

Project Spreadsheets to BS 8110 LOADCASES
Location Columns at A1, A2 etc
LOADCASE 1
N = 500 M = 200
Nuz Mmax Status Nuz Mmax lu M lu N lu Mdif lu Ndif
40 0 0.0 0 0 #DIV/0! #DIV/0! #DIV/0! 0 #DIV/0! #DIV/0!
32 3445.6 246.7 ok 32 3445.6 246.73 246.13 490.55 1.556 24.282
25 2651.3 174.2 Fails 0 2651.3 174.15 173.82 494.59 1.5503 25.231
20 2203.3 133.2 Fails 0 2203.3 133.15 132.33 485.56 1.3421 23.702
16 1916.6 103.8 Fails 0 1916.6 103.76 102.78 479.69 1.0382 21.445
12 1693.7 80.1 Fails 0 1693.7 80.096 79.71 490.69 0.9175 21.891
32
LOADCASE 2
N = 1850 M = 100
Nuz Mmax Status Mmax lu M lu N lu Mdif lu Ndif
40 0 0.0 Fails 0 #DIV/0! #DIV/0! 0 #DIV/0! #DIV/0!
32 3445.6 156.1 ok 32 156.08 172.50 1646.1 -18.976 235.73
25 2651.3 85.6 Fails 0 85.625 99.19 1703.1 -13.844 149.88
20 2203.3 39.4 Fails 0 39.414 40.70 1840.2 -14.204 108.36
16 1916.6 7.1 Fails 0 7.0645 7.54 1845.5 -0.9546 9.0059
12 1693.7 0.0 Fails 0 #DIV/0! 0.00 1693.7 0 0
32
LOADCASE 3
N = 3000 M= 50
32 3445.6 42.8 Fails 0 42.776 44.52 2981.8 -4.9067 51.111
25 2651.3 0.0 Fails 0 #DIV/0! 0.00 2651.3 0 0
20 2203.3 0.0 Fails 0 #DIV/0! 0.00 2203.3 0 0
16 1916.6 0.0 Fails 0 #DIV/0! 0.00 1916.6 0 0
12 1693.7 0.0 Fails 0 #DIV/0! 0.00 1693.7 0 0
0
LOADCASE 4
N = 1500 M = 150
32 3445.6 183.8 ok 32 183.79 193.06 1380.2 -20.564 265.9
25 2651.3 116.1 Fails 0 116.09 126.52 1366.4 -13.704 175.51
20 2203.3 77.0 Fails 0 76.996 77.61 1493.5 -11.991 125.95
16 1916.6 48.5 Fails 0 48.541 52.26 1465.9 -10.593 97.186
12 1693.7 23.6 Fails 0 23.586 31.23 1439.5 -11.945 94.545
32
LOADCASE 5
N = 1000 M = 150
32 3445.6 221.7 ok 0 221.71 243.07 714.97 -26.938 359.53
25 2651.3 152.8 ok 25 152.78 155.97 954.33 -15.259 218.18
20 2203.3 114.7 Fails 0 114.74 121.57 894.15 -10.961 169.66
16 1916.6 89.0 Fails 0 89.008 89.56 991.32 -8.2358 128.39
12 1693.7 69.0 Fails 0 68.987 72.66 936.42 -6.2612 108.51
25
LOADCASE 6
N = 1000 M= 50
32 3445.6 221.7 ok 0 221.71 243.07 714.97 -26.938 359.53
25 2651.3 152.8 ok 0 152.78 155.97 954.33 -15.259 218.18
20 2203.3 114.7 ok 0 114.74 121.57 894.15 -10.961 169.66
16 1916.6 89.0 ok 0 89.008 89.56 991.32 -8.2358 128.39
12 1693.7 69.0 ok 12 68.987 72.66 936.42 -6.2612 108.51
12

Spreadsheets To BS 8110: Advisory Group Columns at A1, A2 Etc RMW

Uploaded by

Copyright:

Available Formats

Spreadsheets To BS 8110: Advisory Group Columns at A1, A2 Etc RMW

Uploaded by

Document Information

Original Title

Copyright

Available Formats

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Available Formats

Spreadsheets To BS 8110: Advisory Group Columns at A1, A2 Etc RMW

Uploaded by

Copyright:

Available Formats

REINFORCED CONCRETE

Project Spreadsheets to BS 8110 COUNCIL

1000 1000 1000

.67fcu/gm = 15.63 N/mm² ALL CALCULATIONS DERIVED FROM 0.00 #DIV/0!

500 1850 3000 1500 1000 1000

Column Chart generation BS 8110.xls 5/15/2019

Interval = 0.000 (27 intervals between Nbal and Nuz)

Interval = 18.554 (27 intervals between Nbal and Nuz)

Interval = 18.818 (27 intervals between Nbal and Nuz)

Interval = 19.157 (27 intervals between Nbal and Nuz)

Interval = 19.308 (27 intervals between Nbal and Nuz)

Interval = 19.459 (27 intervals between Nbal and Nuz)

Column Chart generation BS 8110.xls 5/15/2019

solve for Nuz Nuz

solve for Nuz Nuz

solve for Nuz Nuz

solve for Nuz Nuz

solve for Nuz Nuz

solve for Nuz Nuz

Column Chart generation BS 8110.xls 5/15/2019

Originated from 'RCC52.xls' on CD © 1999 BCA for RCC Date 15-May-19

You might also like