One Way Slab 1
One Way Slab 1
One Way Slab 1
MATERIALS COVERS
fcu 35 N/mm h agg 20 mm Top cover 25 mm
fy 460 N/mm gs 1.05 steel Btm cover 25 mm
fyv 460 N/mm gc 1.50 concrete
LOADING DIAGRAM
A G
REACTIONS (kN/m)
SUPPORT 1 2 3 4 5
Characteristic Dead 97.97 79.89 47.15 55.54 19.65 0.00 0.00
Max Imposed 19.76 24.16 24.87 25.00 7.37 0.00 0.00
Min Imposed -26.35 -6.12 -2.22 -4.53 -9.44 0.00 0.00
MAX ULTIMATE 168.77 150.51 105.80 117.75 39.30 0.00 0.00
REINFORCED CONCRETE
Project Spreadsheets to BS 8110 COUNCIL
Client Advisory Group Made by Date Page
Location 8th Floor slab, from A to G rmw 30-Aug-17 39
ONE-WAY SOLID RC SLAB DESIGN to BS 8110:1997 c/w ANChecked Revision Job No
Originated from RCC31.xls v1.1 2000 BCA for RCC chg - R68
150 150
100 100
50 50
0 0
-50 -50
-100 -100
-150 -150
-200 -200
-250 -250
0 5 10 15 20 25 30 35 0 5 10 15 20 25 30 35
SUPPORT No 1 2 3 4 5
Elastic M 0.0 94.2 56.6 77.3 49.2 ~ ~
Redistributed M 0.0 75.4 55.5 69.6 48.7 ~ ~
b 1.000 0.800 0.980 0.900 0.990 ~ ~
Redistribution 20.0% 2.0% 10.0% 1.0%
SPAN No 1 2 3 4
Elastic M 199.2 18.6 70.0 24.7 ~ ~
Redistributed M 199.2 16.1 70.2 22.8 ~ ~
b 1.000 0.865 1.003 0.924 ~ ~
200 200
150 150
100 100
50 50
0 0
-50 -50
-100 -100
-150 -150
0 5 10 15 20 25 30 35 0 5 10 15 20 25 30 35
SPAN No 1 2 3
Elastic V 168.8 111.2 44.1 33.9 68.8 74.9
Redistributed V 168.8 108.9 44.5 36.1 69.7 74.6
SPAN No 4
Elastic V 45.3 39.9 ~ ~ ~ ~
Redistributed V 44.1 39.3 ~ ~ ~ ~
Project Spreadsheets to BS 8110 REINFORCED CONCRETE COUNCIL
Client Advisory Group Made by Date Page
Location 8th Floor slab, from A to G rmw Aug-2017 41
ONE-WAY SOLID RC SLAB DESIGN to BS 8110:1997 c/w ANALYSIS Checked Revision Job No
Originated from RCC31.xls v1.1 2000 BCA for RCC chg - R68
DISTRIBUTION STEEL
Bottom Span 1 T 10 @ 150 52 10400 0.617 333.4
Span 2 T 10 @ 225 31 10400 0.617 198.8
Span 3 T 10 @ 225 31 10400 0.617 198.8
Span 4 T 10 @ 225 31 10400 0.617 198.8
SUMMARY Links not included. All figures approximate - see User Guide.
REINFORCEMENT DENSITY (kg/m) 67.8 TOTAL REINFORCEMENT IN BAY, kg 5646
Project Spreadsheets to BS 8110
Location 8th Floor slab, from A to G ANALYSIS I
ONE-WAY SOLID RC SLAB DESIGN to BS 8110:1997 c/w ANALYSIS Made by rmw Job No R68
Originated from RCC31.xls v1.1 2000 BCA for RCC Date 30-Aug-17
ANALYSIS
Min load 1.0 x dead load
Max load 0.4 x dead load + 1.6 x imposed load (Table 2.1)
Distribution Factors
SUPT 1 SUPT 2 SUPT 3 SUPT 4 SUPT 5 SUPT 6
R L R L R L R L R L R
h3 42875000 15625000 15625000 15625000 15625000 1.6E+07 1.6E+07 0 0 0
Stiffness 5359375 2170139 2170139 2170139 2170139 2170139 2170139 #DIV/0! #DIV/0! #DIV/0!
Sum 7529514 4340278 4340278 #DIV/0! #DIV/0!
Factor 1 0.7118 0.2882 0.5 0.5 0.5 0.5 0 0 1 0
Moment Distribution
SUPT 1 SUPT 2 SUPT 3 SUPT 4 SUPT 5 SUPT 6
Min load -109.16 59.9365 -25.92 25.92 -36.72 36.72 -25.92 25.92 0 0 0
109.16 -24.212 -9.8041 5.4 5.4 -5.4 -5.4 0 0 0 0
-12.106 54.5776 2.7 -4.9021 -2.7 2.7 0 -2.7 0 0 0
12.106 -40.769 -16.508 3.80104 3.80104 -1.35 -1.35 0 0 0 0
-20.385 6.05308 1.90052 -8.2542 -0.675 1.90052 0 -0.675 0 0 0
20.385 -5.6612 -2.2924 4.4646 4.4646 -0.9503 -0.9503 0 0 0 0
-2.8306 10.1923 2.2323 -1.1462 -0.4751 2.2323 0 -0.4751 0 0 0
2.8306 -8.8436 -3.581 0.81066 0.81066 -1.1162 -1.1162 0 0 0 0
-4.4218 1.41531 0.40533 -1.7905 -0.5581 0.40533 0 -0.5581 0 0 0
4.4218 -1.2959 -0.5247 1.17428 1.17428 -0.2027 -0.2027 0 0 0 0
-0.6479 2.2109 0.58714 -0.2624 -0.1013 0.58714 0 -0.1013 0 0 0
0.6479 -1.9916 -0.8064 0.18185 0.18185 -0.2936 -0.2936 0 0 0 0
-0.9958 0.32397 0.09093 -0.4032 -0.1468 0.09093 0 -0.1468 0 0 0
0.9958 -0.2953 -0.1196 0.275 0.275 -0.0455 -0.0455 0 0 0 0
Sum 0 51.64 -51.64 25.269 -25.269 35.278 -35.28 21.264 0 0 0
Live on -86.329 66.6413 -49.248 49.248 0 0
Odd Spans 86.329 -47.434 -19.207 24.624 24.624 -24.624 -24.624 0 0 0 0
-23.717 43.1644 12.312 -9.6036 -12.312 12.312 0 -12.312 0 0 0
23.717 -39.487 -15.989 10.9578 10.9578 -6.156 -6.156 0 0 0 0
-19.744 11.8585 5.4789 -7.9946 -3.078 5.4789 0 -3.078 0 0 0
19.744 -12.34 -4.9969 5.53632 5.53632 -2.7394 -2.7394 0 0 0 0
-6.1702 9.87178 2.76816 -2.4985 -1.3697 2.76816 0 -1.3697 0 0 0
6.1702 -8.9969 -3.6431 1.9341 1.9341 -1.3841 -1.3841 0 0 0 0
-4.4984 3.08512 0.96705 -1.8215 -0.692 0.96705 0 -0.692 0 0 0
4.4984 -2.8843 -1.1679 1.25678 1.25678 -0.4835 -0.4835 0 0 0 0
-1.4421 2.24922 0.62839 -0.584 -0.2418 0.62839 0 -0.2418 0 0 0
1.4421 -2.0482 -0.8294 0.41286 0.41286 -0.3142 -0.3142 0 0 0 0
-1.0241 0.72107 0.20643 -0.4147 -0.1571 0.20643 0 -0.1571 0 0 0
1.0241 -0.6602 -0.2673 0.28589 0.28589 -0.1032 -0.1032 0 0 0 0
Sum 0 23.74 -23.74 22.091 -22.091 35.804 -35.8 -17.85 0 0 0
Project Spreadsheets to BS 8110
Location 8th Floor slab, from A to G ANALYSIS II
ONE-WAY SOLID RC SLAB DESIGN to BS 8110:1997 c/w ANALYSIS Made by rmw Job No R68
Originated from RCC31.xls v1.1 2000 BCA for RCC Date 30-Aug-17
Elastic Shears
Span 1 2 3
All spans 166.42 111.224 44.1031 33.6569 68.763 74.517
Odd Spans 168.77 108.868 25.4918 17.7082 68.345 74.935
Even Spans 95.614 56.986 43.874 33.886 29.627 31.573
Span 4 5 6
All spans 45.264 32.4958 0 0 0 0
Odd Spans 30.999 12.2015 0 0 0 0
Even Spans 37.812 39.9479 0 0 0 0
0 Spreadsheets to BS 8110
Location 8th Floor slab, from A to G ANALYSIS III
ONE-WAY SOLID RC SLAB DESIGN to BS 8110:1997 c/w ANALYSIS Made by rmw Job No R68
Originated from RCC31.xls v1.1 2000 BCA for RCC Date 30-Aug-17
Redistributed Shears
Span 1 2 3
Dead only 97.97 54.6301 25.2627 17.9373 29.21 31.99
All spans 168.77 108.868 41.6429 36.1171 69.68 73.6
Odd Spans 168.77 108.868 25.3605 17.8395 68.682 74.598
Even Spans 95.002 57.5978 44.4579 33.3021 29.147 32.053
Span 4 5 6
Dead only 23.546 19.6536 0 0 0 0
All spans 44.146 33.6135 0 0 0 0
Odd Spans 30.788 12.4115 0 0 0 0
Even Spans 38.457 39.3027 0 0 0 0
Imposed Reactions
Support 1 2 3 4 5 6 7
All spans 19.759 24.163 24.8693 24.9972 3.81161 0 0
Odd Spans 19.759 13.9865 12.8222 17.272 -9.4396 0 0
Even Spans -26.347 -6.1214 -2.2233 -4.5253 7.36734 0 0
SPAN MOMENTS
SPAN 1 Left < > PL1 < > PL2 < > Right
Elastic V All 166.42 111.22
Odd 168.77 108.87
Even 95.61 Loadings 56.99
Redist V All 168.77 21.58 105 0 108.87
Odd 168.77 21.58 105 0 108.87
Even 95.00 9.7 75 0 57.60
Elastic X- All 7.712 1 2.846 0 2.846
Odd 7.821 1 2.955 0 2.955
Even 9.857 1 2.125 0 2.125
Redist X- All 7.821 1 2.955 0 2.955
Odd 7.821 1 2.955 0 2.955 (3.2.2.1b)
Even 9.794 1 2.062 0 2.062 Max
Elastic M All 0.00 0.00 155.63 192.40 0.00 192.40 94.23 192.40
Odd 0.00 0.00 157.98 199.23 0.00 199.23 75.38 199.23
Even 0.00 0.00 90.76 96.90 0.00 96.90 70.49 96.90 b
Redist M All 0.00 0.00 157.98 199.23 0.00 199.23 75.38 199.23 1.036
Odd 0.00 0.00 157.98 199.23 0.00 199.23 75.38 199.23 1.000
Even 0.00 0.00 90.15 95.62 0.00 95.62 75.38 95.62 0.987
SPAN 2 Left < > PL1 < > PL2 < > Right
Elastic V All 44.10 33.66
Odd 25.49 17.71
Even 43.87 Loadings 33.89
Redist V All 41.64 10.8 0 0 36.12
Odd 25.36 6 0 0 17.84
Even 44.46 10.8 0 0 33.30
Elastic X- All 4.084 0 4.084 0 4.084
Odd 4.249 0 4.249 0 4.249
Even 4.062 0 4.062 0 4.062
Redist X- All 3.856 0 3.856 0 3.856
Odd 4.227 0 4.227 0 4.227 (3.2.2.1b)
Even 4.116 0 4.116 0 4.116 Max
Elastic M All 94.23 0.00 -94.23 -4.18 0.00 -4.18 56.62 0.00
Odd 75.38 0.00 -75.38 -21.23 0.00 -21.23 47.36 0.00
Even 70.49 0.00 -70.49 18.63 0.00 18.63 34.53 18.63 b
Redist M All 75.38 0.00 -75.38 4.90 0.00 4.90 55.49 4.90 0.000
Odd 75.38 0.00 -75.38 -21.79 0.00 -21.79 48.31 0.00 0.000
Even 75.38 0.00 -75.38 16.12 0.00 16.12 35.22 16.12 0.865
0 Spreadsheets to BS 8110
Location 8th Floor slab, from A to G ANALYSIS IV
ONE-WAY SOLID RC SLAB DESIGN to BS 8110:1997 c/w ANALYSIS Made by rmw Job No R68
Originated from RCC31.xls v1.1 2000 BCA for RCC Date 30-Aug-17
SPAN 3 Left < > PL1 < > PL2 < > Right
Elastic V All 68.76 74.52
Odd 68.35 74.93
Even 29.63 Loadings 31.57
Redist V All 69.68 19.9 0 0 73.60
Odd 68.68 19.9 0 0 74.60
Even 29.15 8.5 0 0 32.05
Elastic X- All 3.455 0 3.455 0 3.455
Odd 3.434 0 3.434 0 3.434
Even 3.486 0 3.486 0 3.486
Redist X- All 3.501 0 3.501 0 3.501
Odd 3.451 0 3.451 0 3.451 (3.2.2.1b)
Even 3.429 0 3.429 0 3.429 Max
Elastic M All 56.62 0.00 -56.62 62.18 0.00 62.18 77.34 62.18
Odd 47.36 0.00 -47.36 70.00 0.00 70.00 71.08 70.00
Even 34.53 0.00 -34.53 17.10 0.00 17.10 41.53 17.10 b
Redist M All 55.49 0.00 -55.49 66.50 0.00 66.50 69.60 66.50 1.070
Odd 48.31 0.00 -48.31 70.22 0.00 70.22 69.60 70.22 1.003
Even 35.22 0.00 -35.22 14.75 0.00 14.75 45.69 14.75 0.862
SPAN 4 Left < > PL1 < > PL2 < > Right
Elastic V All 45.26 32.50
Odd 31.00 12.20
Even 37.81 Loadings 39.95
Redist V All 44.15 10.8 0 0 33.61
Odd 30.79 6 0 0 12.41
Even 38.46 10.8 0 0 39.30
Elastic X- All 4.191 0 4.191 0 4.191
Odd 5.166 0 5.166 0 5.166
Even 3.501 0 3.501 0 3.501
Redist X- All 4.088 0 4.088 0 4.088
Odd 5.131 0 5.131 0 5.131 (3.2.2.1b)
Even 3.561 0 3.561 0 3.561 Max
Elastic M All 77.34 0.00 -77.34 17.52 0.00 17.52 31.37 17.52
Odd 71.08 0.00 -71.08 8.99 0.00 8.99 3.41 8.99
Even 41.53 0.00 -41.53 24.66 0.00 24.66 49.22 24.66 b
Redist M All 69.60 0.00 -69.60 20.62 0.00 20.62 31.69 20.62 1.177
Odd 69.60 0.00 -69.60 9.39 0.00 9.39 3.45 9.39 1.044
Even 45.69 0.00 -45.69 22.78 0.00 22.78 48.73 22.78 0.924
SPAN 5 Left < > PL1 < > PL2 < > Right
Elastic V All 0.00 0.00
Odd 0.00 0.00
Even 0.00 Loadings 0.00
Redist V All 0.00 0 0 0 0.00
Odd 0.00 0 0 0 0.00
Even 0.00 0 0 0 0.00
Elastic X- All #DIV/0! 0 #DIV/0! 0 ###
Odd #DIV/0! 0 #DIV/0! 0 ###
Even #DIV/0! 0 #DIV/0! 0 ###
Redist X- All #DIV/0! 0 #DIV/0! 0 ###
Odd #DIV/0! 0 #DIV/0! 0 ### (3.2.2.1b)
Even #DIV/0! 0 #DIV/0! 0 ### Max
Elastic M All 31.37 #DIV/0! -31.37 #DIV/0! 0.00 ### 0.00 ###
Odd 3.41 #DIV/0! -3.41 #DIV/0! 0.00 ### 0.00 ###
Even 49.22 #DIV/0! -49.22 #DIV/0! 0.00 ### 0.00 ### b
Redist M All 31.69 #DIV/0! -31.69 #DIV/0! 0.00 ### 0.00 ### ###
Odd 3.45 #DIV/0! -3.45 #DIV/0! 0.00 ### 0.00 ### ###
Even 48.73 #DIV/0! -48.73 #DIV/0! 0.00 ### 0.00 ### ###
Location Spreadsheets to BS 8110
Location 8th Floor slab, from A to G ANALYSIS IV
ONE-WAY SOLID RC SLAB DESIGN to BS 8110:1997 c/w ANALYSIS Made by rmw Job No R68
Originated from RCC31.xls v1.1 2000 BCA for RCC Date 30-Aug-17
SPAN 6 Left < > PL1 < > PL2 < > Right
Elastic V All 0.00 0.00
Odd 0.00 0.00
Even 0.00 Loadings 0.00
Redist V All 0.00 0 0 0 0.00
Odd 0.00 0 0 0 0.00
Even 0.00 0 0 0 0.00
Elastic X- All #DIV/0! 0 #DIV/0! 0 ###
Odd #DIV/0! 0 #DIV/0! 0 ###
Even #DIV/0! 0 #DIV/0! 0 ###
Redist X- All #DIV/0! 0 #DIV/0! 0 ###
Odd #DIV/0! 0 #DIV/0! 0 ### (3.2.2.1b)
Even #DIV/0! 0 #DIV/0! 0 ### Max
Elastic M All 0.00 #DIV/0! 0.00 #DIV/0! 0.00 ### 0.00 ###
Odd 0.00 #DIV/0! 0.00 #DIV/0! 0.00 ### 0.00 ###
Even 0.00 #DIV/0! 0.00 #DIV/0! 0.00 ### 0.00 ### b
Redist M All 0.00 #DIV/0! 0.00 #DIV/0! 0.00 ### 0.00 ### ###
Odd 0.00 #DIV/0! 0.00 #DIV/0! 0.00 ### 0.00 ### ###
Even 0.00 #DIV/0! 0.00 #DIV/0! 0.00 ### 0.00 ### ###
30-Aug-17
SUPT 7
L
SPAN 6
R
0
###
###
0
0
###
###
0
SUPT 7
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
30-Aug-17
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
Project Spreadsheets to BS 8110
Location 8th Floor slab, from A to G CALCS II
ONE-WAY SOLID RC SLAB DESIGN to BS 8110:1997 c/w ANALYSIS Made by rmw Job No R68
Originated from RCC31.xls v1.1 2000 BCA for RCC Date 30-Aug-17
SHEAR
Mod factor for fcu 1.12 Table 3.8
V kN/m 44.5 36.1
As prov % 0.412 0.172 0.295
Av 0 7200 3.4.5.8
vc N/mm 0.613 0.547 Table 3.8
v N/mm 0.205 0.165 3.4.5.2
v - vc N/mm 0.000 0.000
S reqd mm #N/A #N/A Table 3.7
S max mm 163 164 3.4.5.5
No /m No #N/A #N/A
fs N/mm 359 166 295 Eqn 8
DEFLECTION
Base ratio 26 As'= 0.205 %
k tens 2.000 k comp 1.064
Final ratio 55.325 > 32.877 Actual
Originated from RCC31.xls v1.1 2000 BCA for RCC Date 30-Aug-17
LOADING DIAGRAM
Beam 0 29.6 -22.43
0 0
Supports 0 0 8 8 15.2 15.2 22.4 22.4 29.6 29.6 29.6 29.6 29.6 29.6
-22.43 0 -22.43 0 -22.43 0 -22.43 0 -22.43 0 -22.43 0 -22.43 0
UDL's 0 0 8 8 8 15.2 15.2 15.2 22.4 22.4 22.4 29.6 29.6 29.6 29.6 29.6 29.6 29.6 29.6
Dead 0 9.7 9.7 0 6 6 0 8.5 8.5 0 6 6 0 0 0 0 0 0 0
Imposed 9.7 14.7 14.7 9.7 7.5 7.5 6 13.5 13.5 8.5 7.5 7.5 6 0 0 0 0 0 0
PL's 1 1 0 0 8 8 8 8 15.2 15.2 15.2 15.2 22.4 22.4 22.4 22.4 29.6 29.6 29.6 29.6 29.6 29.6 29.6 29.6
Dead 14.7 89.7 14.7 14.7 7.5 7.5 7.5 7.5 13.5 13.5 13.5 13.5 7.5 7.5 7.5 7.5 0 0 0 0 0 0 0 0
Imposed 89.7 89.7 14.7 14.7 7.5 7.5 7.5 7.5 13.5 13.5 13.5 13.5 7.5 7.5 7.5 7.5 0 0 0 0 0 0 0 0
MOMENT DIAGRAMS
SPAN 1
X 0 0.4 0.8 1.2 1.6 2 2.4 2.8 3.2 3.6 4 4.4 4.8 5.2 5.6 6 6.4 6.8 7.2 7.6 8
M(e) all 0 -64.84 -126.2 -163.2 -175.6 -184.7 -190.2 -192.4 -191 -186.3 -178 -166.3 -151.2 -132.6 -110.6 -85.06 -56.11 -23.7 12.155 51.465 94.228
M(e) odd 0 -65.78 -128.1 -166 -179.4 -189.4 -195.9 -199 -198.6 -194.7 -187.4 -176.7 -162.5 -144.9 -123.8 -99.19 -71.19 -39.72 -4.808 33.56 75.381
M(e) even 0 -37.47 -73.39 -92.75 -95.57 -96.83 -96.54 -94.7 -91.3 -86.35 -79.86 -71.81 -62.2 -51.05 -38.34 -24.08 -8.273 9.089 28.003 48.47 70.488
Beam 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 -65.78 -128.1 -166 -179.4 -189.4 -195.9 -199 -198.6 -194.7 -187.4 -176.7 -162.5 -144.9 -123.7 -99.19 -71.18 -39.72 -4.806 33.562 75.383
M(r) odd 0 -65.78 -128.1 -166 -179.4 -189.4 -195.9 -199 -198.6 -194.7 -187.4 -176.7 -162.5 -144.9 -123.7 -99.19 -71.18 -39.72 -4.806 33.562 75.383
M(r) even 0 -37.22 -72.9 -92.02 -94.59 -95.6 -95.07 -92.98 -89.34 -84.15 -77.41 -69.11 -59.27 -47.87 -34.92 -20.41 -4.358 13.249 32.408 53.12 75.383
70% max 0 -26.23 -51.37 -64.93 -66.9 -67.78 -67.58 -66.29 -63.91 -60.45 -55.9 -50.26 -43.54 -35.73 -26.84 -16.86 -5.791 6.3623 19.602 36.026 65.96
70% min 0 -46.05 -89.68 -116.2 -125.6 -132.6 -137.1 -139.3 -139 -136.3 -131.2 -123.7 -113.8 -101.4 -86.63 -69.44 -49.83 -27.81 -3.366 23.492 49.342
Lower bound 0 -65.78 -128.1 -166 -179.4 -189.4 -195.9 -199 -198.6 -194.7 -187.4 -176.7 -162.5 -144.9 -123.7 -99.19 -71.18 -39.72 -4.806 0 0
Upper bound 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 13.249 32.408 53.12 75.383
Beam 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
SPAN 2
Local X 0 0.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
X 8 8.36 8.72 9.08 9.44 9.8 10.16 10.52 10.88 11.24 11.6 11.96 12.32 12.68 13.04 13.4 13.76 14.12 14.48 14.84 15.2
M(e) all 94.228 79.051 65.274 52.896 41.917 32.339 24.16 17.381 12.001 8.0215 5.4413 4.2609 4.4801 6.099 9.1176 13.536 19.354 26.571 35.189 45.206 56.622
M(e) odd 75.381 66.592 58.582 51.349 44.893 39.215 34.315 30.193 26.847 24.28 22.49 21.478 21.243 21.786 23.107 25.205 28.081 31.734 36.165 41.374 47.36
M(e) even 70.488 55.393 41.698 29.403 18.507 9.011 0.9146 -5.782 -11.08 -14.98 -17.47 -18.57 -18.27 -16.57 -13.47 -8.967 -3.067 4.2331 12.933 23.032 34.531
Beam 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
M(r) all 75.383 61.091 48.199 36.707 26.614 17.921 10.628 4.7348 0.2409 -2.853 -4.548 -4.843 -3.738 -1.233 2.6712 7.9751 14.679 22.782 32.285 43.188 55.49
M(r) odd 75.383 66.642 58.678 51.493 45.084 39.454 34.601 30.525 27.228 24.707 22.965 22 21.812 22.403 23.77 25.916 28.839 32.54 37.018 42.274 48.307
M(r) even 75.383 60.078 46.172 33.667 22.561 12.855 4.548 -2.359 -7.866 -11.97 -14.68 -15.99 -15.9 -14.41 -11.52 -7.226 -1.536 5.5543 14.044 23.933 35.222
70% max 65.96 55.336 45.691 37.027 31.425 27.451 24.021 21.135 18.793 16.996 15.743 15.035 14.87 15.25 16.175 17.643 19.657 22.214 25.316 31.644 39.636
70% min 49.342 38.775 29.189 20.582 12.955 6.3077 0.6403 -4.047 -7.755 -10.48 -12.23 -13 -12.79 -11.6 -9.428 -6.277 -2.147 2.9632 9.053 16.123 24.172
Lower bound 0 0 0 0 0 0 0 -4.047 -7.866 -11.97 -14.68 -15.99 -15.9 -14.41 -11.52 -7.226 -2.147 0 0 0 0
Upper bound 75.383 66.642 58.678 51.493 45.084 39.454 34.601 30.525 27.228 24.707 22.965 22 21.812 22.403 23.77 25.916 28.839 32.54 37.018 43.188 55.49
Beam 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
SPAN 3
Local X 0 0.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
X 15.2 15.56 15.92 16.28 16.64 17 17.36 17.72 18.08 18.44 18.8 19.16 19.52 19.88 20.24 20.6 20.96 21.32 21.68 22.04 22.4
M(e) all 56.622 33.157 12.271 -6.036 -21.76 -34.91 -45.48 -53.47 -58.89 -61.72 -61.97 -59.65 -54.74 -47.26 -37.2 -24.55 -9.334 8.4651 28.844 51.801 77.338
M(e) odd 47.36 24.045 3.3093 -14.85 -30.42 -43.42 -53.84 -61.68 -66.95 -69.63 -69.73 -67.26 -62.2 -54.57 -44.35 -31.56 -16.19 1.7586 22.288 45.396 71.083
M(e) even 34.531 24.416 15.403 7.4909 0.6806 -5.028 -9.635 -13.14 -15.54 -16.85 -17.05 -16.15 -14.14 -11.04 -6.834 -1.527 4.8819 12.392 21.004 30.718 41.533
Beam 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
M(r) all 55.49 31.695 10.479 -8.159 -24.22 -37.7 -48.6 -56.92 -62.66 -65.82 -66.41 -64.41 -59.84 -52.68 -42.95 -30.64 -15.75 1.7215 21.77 44.398 69.604
M(r) odd 48.307 24.871 4.014 -14.26 -29.96 -43.08 -53.62 -61.59 -66.97 -69.77 -70 -67.64 -62.71 -55.2 -45.1 -32.43 -17.18 0.644 21.052 44.038 69.604
M(r) even 35.222 25.28 16.44 8.701 2.0638 -3.472 -7.906 -11.24 -13.47 -14.6 -14.63 -13.55 -11.38 -8.099 -3.72 1.7606 8.3427 16.026 24.812 34.698 45.687
70% max 39.636 23.21 10.782 5.2437 0.4764 -3.52 -6.745 -9.198 -10.88 -11.79 -11.93 -11.3 -9.901 -7.728 -4.784 -1.069 3.4173 8.6746 20.191 36.261 54.137
70% min 24.172 16.832 2.3165 -10.39 -21.3 -30.4 -37.69 -43.18 -46.86 -48.74 -48.81 -47.08 -43.54 -38.2 -31.05 -22.09 -11.33 1.231 14.703 21.503 29.073
Lower bound 0 0 0 -14.26 -29.96 -43.08 -53.62 -61.59 -66.97 -69.77 -70 -67.64 -62.71 -55.2 -45.1 -32.43 -17.18 0 0 0 0
Upper bound 55.49 31.695 16.44 8.701 2.0638 0 0 0 0 0 0 0 0 0 0 1.7606 8.3427 16.026 24.812 44.398 69.604
Beam 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
SPAN 4
Local 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
X 22.4 22.76 23.12 23.48 23.84 24.2 24.56 24.92 25.28 25.64 26 26.36 26.72 27.08 27.44 27.8 28.16 28.52 28.88 29.24 29.6
M(e) all 77.338 61.743 47.547 34.751 23.355 13.358 4.7616 -2.436 -8.233 -12.63 -15.63 -17.23 -17.43 -16.23 -13.62 -9.625 -4.225 2.575 10.774 20.373 31.372
M(e) odd 71.083 60.312 50.319 41.103 32.665 25.005 18.123 12.017 6.69 2.1401 -1.632 -4.627 -6.844 -8.283 -8.945 -8.83 -7.936 -6.265 -3.817 -0.591 3.4131
M(e) even 41.533 28.621 17.108 6.995 -1.718 -9.032 -14.95 -19.46 -22.58 -24.29 -24.61 -23.52 -21.04 -17.15 -11.87 -5.188 2.895 12.377 23.259 35.541 49.223
Beam 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
M(r) all 69.604 54.411 40.618 28.225 17.231 7.6365 -0.558 -7.353 -12.75 -16.74 -19.34 -20.54 -20.33 -18.73 -15.73 -11.32 -5.52 1.6816 10.283 20.285 31.686
M(r) odd 69.604 58.909 48.992 39.852 31.49 23.905 17.098 11.068 5.8166 1.3423 -2.354 -5.273 -7.415 -8.779 -9.365 -9.174 -8.205 -6.458 -3.934 -0.632 3.4472
M(r) even 45.687 32.542 20.797 10.451 1.5058 -6.04 -12.19 -16.93 -20.28 -22.23 -22.78 -21.92 -19.67 -16.02 -10.97 -4.519 3.3319 12.582 23.232 35.281 48.73
70% max 54.137 43.22 35.223 28.772 22.866 17.504 12.686 8.4122 4.683 1.4981 -1.143 -3.239 -4.791 -5.798 -6.262 -3.631 2.0265 8.6642 16.282 24.879 34.456
70% min 29.073 20.035 11.976 4.8965 -1.203 -6.323 -10.46 -13.62 -15.8 -17 -17.22 -16.47 -14.73 -12.01 -9.537 -6.737 -5.555 -4.386 -2.672 -0.413 2.3891
Lower bound 0 0 0 0 -1.203 -6.323 -12.19 -16.93 -20.28 -22.23 -22.78 -21.92 -20.33 -18.73 -15.73 -11.32 -8.205 -6.458 -3.934 -0.632 0
Upper bound 69.604 58.909 48.992 39.852 31.49 23.905 17.098 11.068 5.8166 1.4981 0 0 0 0 0 0 3.3319 12.582 23.232 35.281 48.73
Beam 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Project Spreadsheets to BS 8110
Location 8th Floor slab, from A to G GRAPH DATA II
ONE-WAY SOLID RC SLAB DESIGN to BS 8110:1997 c/w ANALYSIS Made by rmw Job No R68
Originated from RCC31.xls v1.1 2000 BCA for RCC Date 30-Aug-17
SPAN 5
Local X 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
X 29.6 29.6 29.6 29.6 29.6 29.6 29.6 29.6 29.6 29.6 29.6 29.6 29.6 29.6 29.6 29.6 29.6 29.6 29.6 29.6 29.6
M(e) all 31.372 31.372 31.372 31.372 31.372 31.372 31.372 31.372 31.372 31.372 31.372 31.372 31.372 31.372 31.372 31.372 31.372 31.372 31.372 31.372 0
M(e) odd 3.4131 3.4131 3.4131 3.4131 3.4131 3.4131 3.4131 3.4131 3.4131 3.4131 3.4131 3.4131 3.4131 3.4131 3.4131 3.4131 3.4131 3.4131 3.4131 3.4131 0
M(e) even 49.223 49.223 49.223 49.223 49.223 49.223 49.223 49.223 49.223 49.223 49.223 49.223 49.223 49.223 49.223 49.223 49.223 49.223 49.223 49.223 0
Beam 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
M(r) all 31.686 31.686 31.686 31.686 31.686 31.686 31.686 31.686 31.686 31.686 31.686 31.686 31.686 31.686 31.686 31.686 31.686 31.686 31.686 31.686 0
M(r) odd 3.4472 3.4472 3.4472 3.4472 3.4472 3.4472 3.4472 3.4472 3.4472 3.4472 3.4472 3.4472 3.4472 3.4472 3.4472 3.4472 3.4472 3.4472 3.4472 3.4472 0
M(r) even 48.73 48.73 48.73 48.73 48.73 48.73 48.73 48.73 48.73 48.73 48.73 48.73 48.73 48.73 48.73 48.73 48.73 48.73 48.73 48.73 0
70% max 34.456 34.456 34.456 34.456 34.456 34.456 34.456 34.456 34.456 34.456 34.456 34.456 34.456 34.456 34.456 34.456 34.456 34.456 34.456 34.456 0
70% min 2.3891 2.3891 2.3891 2.3891 2.3891 2.3891 2.3891 2.3891 2.3891 2.3891 2.3891 2.3891 2.3891 2.3891 2.3891 2.3891 2.3891 2.3891 2.3891 2.3891 0
Lower bound 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Upper bound 48.73 48.73 48.73 48.73 48.73 48.73 48.73 48.73 48.73 48.73 48.73 48.73 48.73 48.73 48.73 48.73 48.73 48.73 48.73 48.73 0
Beam 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
SPAN 6
Local X 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
X 29.6 29.6 29.6 29.6 29.6 29.6 29.6 29.6 29.6 29.6 29.6 29.6 29.6 29.6 29.6 29.6 29.6 29.6 29.6 29.6 29.6
M(e) all 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
M(e) even 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
M(r) all 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
M(r) even 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
70% min 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
Upper bound 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
GRIDS 8 8 15.2 15.2 22.4 22.4 29.6 29.6 29.6 29.6 29.6 29.6
### 94.228 -199.2 94.228 -199.2 94.228 -199.2 94.228 -199.2 94.228 -199.2 94.228
Disclaimer
All advice or information from the British Cement Association and/or Reinforced
Concrete Council is intended for those who will evaluate the significance and
limitations of its contents and take responsibility for its use and application. No
liability (including that for negligence) for any loss resulting from such advice or
information is accepted by the BCA, RCC or their subcontractors, suppliers or
advisors. Users should note that all BCA software and publications are subject to
revision from time to time and should therefore ensure that they are in possession of
the latest version.
Status of spreadsheet
Public release version.