RCC31 One Way Slabs A and D Xls
RCC31 One Way Slabs A and D Xls
RCC31 One Way Slabs A and D Xls
MATERIALS COVERS
fcu 35 N/mm² h agg 20 mm Top cover 25 mm
fy 500 N/mm² gs 1.15 steel Btm cover 25 mm
fyv 500 N/mm² gc 1.50 concrete
steel class A
SPANS L (m) H (mm) SUPPORTS
SPAN 1 8.000 350 Support No Type
SPAN 2 7.200 250 1 K
SPAN 3 7.200 250 LOADING PATTERN 5 K
SPAN 4 4.500 250 min max K(nife), C(antilever) or E(ncastre)
SPAN 5 DEAD 1 1.4
SPAN 6 IMPOSED 0 1.6
LOADING DIAGRAM
A G
REACTIONS (kN/m)
SUPPORT 1 2 3 4 5
Characteristic Dead 63.76 72.94 48.78 58.14 11.62 0.00 0.00
Max Imposed 19.00 27.40 21.94 35.13 10.33 0.00 0.00
Min Imposed -0.76 6.69 4.61 12.43 -3.75 0.00 0.00
MAX ULTIMATE 120.07 142.57 106.32 134.68 34.46 0.00 0.00
Project Spreadsheets to BS 8110 The Concrete Centre
Client Advisory Group Made by Date Page
Location 8th Floor slab, from A to G rmw 25-Oct-24 40
ONE-WAY SOLID RC SLAB DESIGN to BS 8110:2005 c/w ANALYSIS Checked Revision Job No
Originated from RCC31.xls v4.0 on CD © 2006 TCC chg - R68
150 150
100 100
50 50
0 0
-50 -50
-100 -100
-150 -150
-200 -200
0 5 10 15 20 25 30 0 5 10 15 20 25 30
SUPPORT No 1 2 3 4 5
Elastic M 0.0 85.9 57.8 80.9 0.0 ~ ~
Redistributed M 0.0 73.0 57.8 72.8 0.0 ~ ~
ßb 1.000 0.850 1.000 0.900 1.000 ~ ~
Redistribution 15.0% 10.0%
SPAN No 1 2 3 4
Elastic M 168.6 20.6 68.4 31.5 ~ ~
Redistributed M 166.0 16.8 68.3 29.8 ~ ~
ßb 0.985 0.814 0.998 0.948 ~ ~
150 150
100 100
50 50
0 0
-50 -50
-100 -100
-150 -150
0 5 10 15 20 25 30 0 5 10 15 20 25 30
SPAN No 1 2 3
Elastic V 120.8 103.2 42.8 35.0 68.4 74.9
Redistributed V 120.1 101.6 44.0 36.8 69.6 74.9
SPAN No 4
Elastic V 62.8 35.4 ~ ~ ~ ~
Redistributed V 61.0 34.5 ~ ~ ~ ~
Project Spreadsheets to BS 8110 The Concrete Centre
Client Advisory Group Made by Date Page
Location 8th Floor slab, from A to G rmw Oct-2024 42
ONE-WAY SOLID RC SLAB DESIGN to BS 8110:2005 c/w ANALYSIS Checked Revision Job No
Originated from RCC31.xls v4.0 on CD © 2006 TCC 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 19 10400 0.617 121.8
SUMMARY Links not included. All figures approximate - see User Guide.
REINFORCEMENT DENSITY (kg/m³) 63.1 TOTAL REINFORCEMENT IN BAY, kg 4831
Project Spreadsheets to BS 8110
Location 8th Floor slab, from A to G ANALYSIS I
ONE-WAY SOLID RC SLAB DESIGN to BS 8110:2005 c/w ANALYSIS Made by rmw Job No R68
Originated from RCC31.xls v4.0 on CD © 2006 TCC Date 25-Oct-24
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 SUPT 7
R L R L R L R L R L R L
h3 42875000 15625000 15625000 15625000 15625000 15625000 15625000 0 0 0
Stiffness 5359375 2170139 2170139 2170139 2170139 3472222 3472222 #DIV/0! #DIV/0! #DIV/0!
Sum 7529514 4340278 5642361 #DIV/0! #DIV/0!
Factor 1 0.7118 0.2882 0.5 0.5 0.3846 0.6154 1 0 1 0 1
Elastic Shears
Span 1 2 3
All spans 118.46 103.18 42.79 34.97 68.43 74.85
Odd Spans 120.84 100.80 24.07 19.13 68.39 74.89
Even Spans 61.38 51.22 42.83 34.93 29.73 31.47
Imposed all 18.24 21.76 5.65 5.15 16.79 19.21
Imposed odd 19.00 21.00 -0.28 0.28 17.05 18.95
Imposed even -0.76 0.76 5.93 4.87 -0.26 0.26
Span 4 5 6
All spans 62.75 26.80 0.00 0.00 0.00 0.00
Odd Spans 35.23 3.02 0.00 0.00 0.00 0.00
Even Spans 54.15 35.40 0.00 0.00 0.00 0.00
Imposed all 15.92 6.58 0.00 0.00 0.00 0.00
Imposed odd 3.75 -3.75 0.00 0.00 0.00 0.00
Imposed even 12.17 10.33 0.00 0.00 0.00 0.00
0 Spreadsheets to BS 8110
Location 8th Floor slab, from A to G ANALYSIS III
ONE-WAY SOLID RC SLAB DESIGN to BS 8110:2005 c/w ANALYSIS Made by rmw Job No R68
Originated from RCC31.xls v4.0 on CD © 2006 TCC Date 25-Oct-24
Redistributed Shears
Span 1 2 3
Dead only 63.764 48.8356 24.1094 19.0906 29.69 31.51
All spans 120.07 101.571 40.9964 36.7636 69.552 73.728
Odd Spans 120.07 101.571 24.9235 18.2765 68.345 74.935
Even Spans 60.299 52.3013 44.0331 33.7269 29.143 32.057
Span 4 5 6
Dead only 26.629 11.6212 0 0 0 0
All spans 60.954 28.5961 0 0 0 0
Odd Spans 35.304 2.94607 0 0 0 0
Even Spans 55.086 34.4637 0 0 0 0
Imposed Reactions
Support 1 2 3 4 5 6 7
All spans 18.24 27.40 21.94 35.13 6.58 0.00 0.00
Odd Spans 19.00 20.71 17.33 22.70 -3.75 0.00 0.00
Even Spans -0.76 6.69 4.61 12.43 10.33 0.00 0.00
SPAN MOMENTS
SPAN 1 Left < > PL1 < > PL2 < > Right
Elastic V All 118.46 103.18
Odd 120.84 100.80
Even 61.38 Loadings 51.22
Redist V All 120.07 21.58 49 0 101.57
Odd 120.07 21.58 49 0 101.57
Even 60.30 9.7 35 0 52.30
Elastic X- All 5.489 1 3.219 0 3.219
Odd 5.600 1 3.329 0 3.329
Even 6.328 1 2.720 0 2.720
Redist X- All 5.564 1 3.293 0 3.293
Odd 5.564 1 3.293 0 3.293 (3.2.2.1b)
Even 6.216 1 2.608 0 2.608 Max
Elastic M All 0.00 0.00 107.67 160.78 0.00 160.78 85.89 160.78
Odd 0.00 0.00 110.05 168.57 0.00 168.57 66.86 168.57
Even 0.00 0.00 56.53 70.88 0.00 70.88 64.32 70.88 ßb
Redist M All 0.00 0.00 109.28 166.02 0.00 166.02 73.01 166.02 1.033
Odd 0.00 0.00 109.28 166.02 0.00 166.02 73.01 166.02 0.985
Even 0.00 0.00 55.45 67.99 0.00 67.99 73.01 67.99 0.959
SPAN 2 Left < > PL1 < > PL2 < > Right
Elastic V All 42.79 34.97
Odd 24.07 19.13
Even 42.83 Loadings 34.93
Redist V All 41.00 10.8 0 0 36.76
Odd 24.92 6 0 0 18.28
Even 44.03 10.8 0 0 33.73
Elastic X- All 3.962 0 3.962 0 3.962
Odd 4.012 0 4.012 0 4.012
Even 3.965 0 3.965 0 3.965
Redist X- All 3.796 0 3.796 0 3.796
Odd 4.154 0 4.154 0 4.154 (3.2.2.1b)
Even 4.077 0 4.077 0 4.077 Max
Elastic M All 85.89 0.00 -85.89 -1.14 0.00 -1.14 57.77 0.00
Odd 66.86 0.00 -66.86 -18.58 0.00 -18.58 49.08 0.00
Even 64.32 0.00 -64.32 20.59 0.00 20.59 35.91 20.59 ßb
Redist M All 73.01 0.00 -73.01 4.80 0.00 4.80 57.77 4.80 0.000
Odd 73.01 0.00 -73.01 -21.25 0.00 -21.25 49.08 0.00 0.000
Even 73.01 0.00 -73.01 16.75 0.00 16.75 35.91 16.75 0.814
0 Spreadsheets to BS 8110
Location 8th Floor slab, from A to G ANALYSIS IV
ONE-WAY SOLID RC SLAB DESIGN to BS 8110:2005 c/w ANALYSIS Made by rmw Job No R68
Originated from RCC31.xls v4.0 on CD © 2006 TCC Date 25-Oct-24
SPAN 3 Left < > PL1 < > PL2 < > Right
Elastic V All 68.43 74.85
Odd 68.39 74.89
Even 29.73 Loadings 31.47
Redist V All 69.55 19.9 0 0 73.73
Odd 68.35 19.9 0 0 74.93
Even 29.14 8.5 0 0 32.06
Elastic X- All 3.439 0 3.439 0 3.439
Odd 3.437 0 3.437 0 3.437
Even 3.497 0 3.497 0 3.497
Redist X- All 3.495 0 3.495 0 3.495
Odd 3.434 0 3.434 0 3.434 (3.2.2.1b)
Even 3.429 0 3.429 0 3.429 Max
Elastic M All 57.77 0.00 -57.77 59.88 0.00 59.88 80.89 59.88
Odd 49.08 0.00 -49.08 68.44 0.00 68.44 72.48 68.44
Even 35.91 0.00 -35.91 16.08 0.00 16.08 42.18 16.08 ßb
Redist M All 57.77 0.00 -57.77 63.77 0.00 63.77 72.81 63.77 1.065
Odd 49.08 0.00 -49.08 68.28 0.00 68.28 72.81 68.28 0.998
Even 35.91 0.00 -35.91 14.05 0.00 14.05 46.40 14.05 0.874
SPAN 4 Left < > PL1 < > PL2 < > Right
Elastic V All 62.75 26.80
Odd 35.23 3.02
Even 54.15 Loadings 35.40
Redist V All 60.95 19.9 0 0 28.60
Odd 35.30 8.5 0 0 2.95
Even 55.09 19.9 0 0 34.46
Elastic X- All 3.153 0 3.153 0 3.153
Odd 4.145 0 4.145 0 4.145
Even 2.721 0 2.721 0 2.721
Redist X- All 3.063 0 3.063 0 3.063
Odd 4.153 0 4.153 0 4.153 (3.2.2.1b)
Even 2.768 0 2.768 0 2.768 Max
Elastic M All 80.89 0.00 -80.89 18.04 0.00 18.04 0.00 18.04
Odd 72.48 0.00 -72.48 0.54 0.00 0.54 0.00 0.54
Even 42.18 0.00 -42.18 31.49 0.00 31.49 0.00 31.49 ßb
Redist M All 72.81 0.00 -72.81 20.55 0.00 20.55 0.00 20.55 1.139
Odd 72.81 0.00 -72.81 0.51 0.00 0.51 0.00 0.51 0.953
Even 46.40 0.00 -46.40 29.84 0.00 29.84 0.00 29.84 0.948
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 #DIV/0!
Odd #DIV/0! 0 #DIV/0! 0 #DIV/0!
Even #DIV/0! 0 #DIV/0! 0 #DIV/0!
Redist X- All #DIV/0! 0 #DIV/0! 0 #DIV/0!
Odd #DIV/0! 0 #DIV/0! 0 #DIV/0! (3.2.2.1b)
Even #DIV/0! 0 #DIV/0! 0 #DIV/0! Max
Elastic M All 0.00 #DIV/0! 0.00 #DIV/0! 0.00 #DIV/0! 0.00 #DIV/0!
Odd 0.00 #DIV/0! 0.00 #DIV/0! 0.00 #DIV/0! 0.00 #DIV/0!
Even 0.00 #DIV/0! 0.00 #DIV/0! 0.00 #DIV/0! 0.00 #DIV/0! ßb
Redist M All 0.00 #DIV/0! 0.00 #DIV/0! 0.00 #DIV/0! 0.00 #DIV/0! #DIV/0!
Odd 0.00 #DIV/0! 0.00 #DIV/0! 0.00 #DIV/0! 0.00 #DIV/0! #DIV/0!
Even 0.00 #DIV/0! 0.00 #DIV/0! 0.00 #DIV/0! 0.00 #DIV/0! #DIV/0!
Location Spreadsheets to BS 8110
Location 8th Floor slab, from A to G ANALYSIS IV
ONE-WAY SOLID RC SLAB DESIGN to BS 8110:2005 c/w ANALYSIS Made by rmw Job No R68
Originated from RCC31.xls v4.0 on CD © 2006 TCC Date 25-Oct-24
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 #DIV/0!
Odd #DIV/0! 0 #DIV/0! 0 #DIV/0!
Even #DIV/0! 0 #DIV/0! 0 #DIV/0!
Redist X- All #DIV/0! 0 #DIV/0! 0 #DIV/0!
Odd #DIV/0! 0 #DIV/0! 0 #DIV/0! (3.2.2.1b)
Even #DIV/0! 0 #DIV/0! 0 #DIV/0! Max
Elastic M All 0.00 #DIV/0! 0.00 #DIV/0! 0.00 #DIV/0! 0.00 #DIV/0!
Odd 0.00 #DIV/0! 0.00 #DIV/0! 0.00 #DIV/0! 0.00 #DIV/0!
Even 0.00 #DIV/0! 0.00 #DIV/0! 0.00 #DIV/0! 0.00 #DIV/0! ßb
Redist M All 0.00 #DIV/0! 0.00 #DIV/0! 0.00 #DIV/0! 0.00 #DIV/0! #DIV/0!
Odd 0.00 #DIV/0! 0.00 #DIV/0! 0.00 #DIV/0! 0.00 #DIV/0! #DIV/0!
Even 0.00 #DIV/0! 0.00 #DIV/0! 0.00 #DIV/0! 0.00 #DIV/0! #DIV/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:2005 c/w ANALYSIS Made by rmw Job No R68
Originated from RCC31.xls v4.0 on CD © 2006 TCC Date 25-Oct-24
SHEAR
Mod factor for fcu 1.12 Table 3.8
V kN/m 44.0 36.8
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.203 0.168 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² 358 201 329 Eqn 8
DEFLECTION
Base ratio 26 As'= 0.205 %
k tens 2.000 k comp 1.064
Final ratio 55.325 > 32.877 Actual
LOADING DIAGRAM
Beam 0 26.9 -12.43
0 0
Supports 0 0 8 8 15.2 15.2 22.4 22.4 26.9 26.9 26.9 26.9 26.9 26.9
-12.43 0 -12.43 0 -12.43 0 -12.43 0 -12.43 0 -12.43 0 -12.43 0
UDL's 0 0 8 8 8 15.2 15.2 15.2 22.4 22.4 22.4 26.9 26.9 26.9 26.9 26.9 26.9 26.9 26.9
Dead 0 9.7 9.7 0 6 6 0 8.5 8.5 0 8.5 8.5 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 13.5 13.5 8.5 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 26.9 26.9 26.9 26.9 26.9 26.9 26.9 26.9
Dead 14.7 49.7 14.7 14.7 7.5 7.5 7.5 7.5 13.5 13.5 13.5 13.5 13.5 13.5 13.5 13.5 0 0 0 0 0 0 0 0
Imposed 49.7 49.7 14.7 14.7 7.5 7.5 7.5 7.5 13.5 13.5 13.5 13.5 13.5 13.5 13.5 13.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 -45.66 -87.86 -116.8 -132.5 -144.8 -153.5 -158.9 -160.8 -159.2 -154.2 -145.7 -133.8 -118.4 -99.59 -77.31 -51.57 -22.39 10.255 46.348 85.894
M(e) odd 0 -46.61 -89.76 -119.7 -136.3 -149.5 -159.3 -165.6 -168.4 -167.8 -163.7 -156.2 -145.2 -130.8 -112.9 -91.59 -66.8 -38.57 -6.878 28.264 66.858
M(e) even 0 -23.78 -46 -59.68 -64.8 -68.37 -70.39 -70.85 -69.77 -67.13 -62.94 -57.2 -49.9 -41.06 -30.66 -18.71 -5.207 9.8466 26.453 44.611 64.321
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 -46.3 -89.15 -118.7 -135.1 -148 -157.4 -163.4 -165.9 -165 -160.6 -152.8 -141.5 -126.8 -108.6 -86.97 -61.88 -33.34 -1.341 34.108 73.01
M(r) odd 0 -46.3 -89.15 -118.7 -135.1 -148 -157.4 -163.4 -165.9 -165 -160.6 -152.8 -141.5 -126.8 -108.6 -86.97 -61.88 -33.34 -1.341 34.108 73.01
M(r) even 0 -23.34 -45.13 -58.37 -63.06 -66.2 -67.78 -67.81 -66.29 -63.22 -58.59 -52.42 -44.69 -35.41 -24.58 -12.19 1.7442 17.233 34.273 52.866 73.01
70% max 0 -16.64 -32.2 -41.77 -45.36 -47.86 -49.27 -49.6 -48.84 -46.99 -44.06 -40.04 -34.93 -28.74 -21.46 -13.1 -3.645 6.8926 18.517 32.444 60.126
70% min 0 -32.63 -62.84 -83.77 -95.42 -104.7 -111.5 -115.9 -117.9 -117.4 -114.6 -109.3 -101.7 -91.56 -79.04 -64.11 -46.76 -27 -4.815 19.785 45.024
Lower bound 0 -46.3 -89.15 -118.7 -135.1 -148 -157.4 -163.4 -165.9 -165 -160.6 -152.8 -141.5 -126.8 -108.6 -86.97 -61.88 -33.34 -4.815 0 0
Upper bound 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1.7442 17.233 34.273 52.866 73.01
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 85.894 71.191 57.888 45.984 35.48 26.376 18.671 12.366 7.4608 3.9552 1.8492 1.1429 1.8363 3.9294 7.4222 12.315 18.607 26.299 35.39 45.881 57.772
M(e) odd 66.858 58.582 51.084 44.363 38.42 33.254 28.866 25.256 22.423 20.367 19.09 18.59 18.867 19.922 21.755 24.366 27.754 31.919 36.862 42.583 49.081
M(e) even 64.321 49.603 36.285 24.367 13.848 4.7295 -2.99 -9.309 -14.23 -17.75 -19.87 -20.59 -19.91 -17.83 -14.35 -9.477 -3.199 4.4779 13.555 24.031 35.908
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 73.01 58.951 46.292 35.033 25.173 16.713 9.6522 3.9914 -0.27 -3.131 -4.593 -4.655 -3.317 -0.58 3.5569 9.0936 16.03 24.366 34.102 45.237 57.772
M(r) odd 73.01 64.427 56.621 49.592 43.341 37.868 33.172 29.254 26.114 23.751 22.166 21.358 21.328 22.076 23.601 25.904 28.984 32.842 37.477 42.891 49.081
M(r) even 73.01 57.858 44.106 31.753 20.8 11.247 3.0929 -3.661 -9.015 -12.97 -15.53 -16.68 -16.44 -14.79 -11.75 -7.305 -1.462 5.7813 14.424 24.466 35.908
70% max 60.126 49.834 40.522 32.189 26.894 23.278 20.206 17.679 15.696 14.257 13.363 13.013 13.207 13.946 15.229 17.056 19.427 22.343 25.804 32.117 40.44
70% min 45.024 34.722 25.4 17.057 9.6938 3.3106 -2.093 -6.516 -9.96 -12.42 -13.91 -14.41 -13.94 -12.48 -10.05 -6.634 -2.24 3.1345 9.4884 16.822 25.135
Lower bound 0 0 0 0 0 0 -2.093 -6.516 -9.96 -12.97 -15.53 -16.68 -16.44 -14.79 -11.75 -7.305 -2.24 0 0 0 0
Upper bound 73.01 64.427 56.621 49.592 43.341 37.868 33.172 29.254 26.114 23.751 22.166 21.358 21.328 22.076 23.601 25.904 28.984 32.842 37.477 45.237 57.772
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 57.772 34.427 13.662 -4.525 -20.13 -33.16 -43.61 -51.48 -56.77 -59.49 -59.62 -57.17 -52.15 -44.54 -34.36 -21.6 -6.259 11.661 32.16 55.238 80.895
M(e) odd 49.081 25.75 4.9984 -13.17 -28.77 -41.78 -52.22 -60.08 -65.35 -68.05 -68.17 -65.71 -60.67 -53.06 -42.86 -30.08 -14.73 3.2039 23.717 46.808 72.479
M(e) even 35.908 25.756 16.706 8.7582 1.9115 -3.834 -8.477 -12.02 -14.46 -15.8 -16.03 -15.17 -13.2 -10.14 -5.967 -0.696 5.6764 13.15 21.726 31.404 42.183
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 57.772 34.023 12.853 -5.739 -21.75 -35.18 -46.04 -54.31 -60.01 -63.13 -63.66 -61.62 -57 -49.8 -40.02 -27.67 -12.73 4.7847 24.879 47.553 72.805
M(r) odd 49.081 25.767 5.031 -13.13 -28.7 -41.7 -52.12 -59.96 -65.22 -67.91 -68.01 -65.53 -60.48 -52.84 -42.63 -29.84 -14.47 3.4811 24.01 47.118 72.805
M(r) even 35.908 25.967 17.128 9.3909 2.7552 -2.779 -7.212 -10.54 -12.77 -13.9 -13.93 -12.85 -10.67 -7.395 -3.014 2.4675 9.051 16.736 25.523 35.411 46.401
70% max 40.44 24.099 11.694 6.1307 1.3381 -2.683 -5.934 -8.413 -10.12 -11.06 -11.22 -10.62 -9.243 -7.096 -4.177 -0.487 3.9734 9.2053 22.512 38.666 56.626
70% min 25.135 18.025 3.4989 -9.222 -20.14 -29.25 -36.55 -42.05 -45.75 -47.64 -47.72 -46 -42.47 -37.14 -30 -21.06 -10.31 2.2427 15.208 21.982 29.528
Lower bound 0 0 0 -13.13 -28.7 -41.7 -52.12 -59.96 -65.22 -67.91 -68.01 -65.53 -60.48 -52.84 -42.63 -29.84 -14.47 0 0 0 0
Upper bound 57.772 34.023 17.128 9.3909 2.7552 0 0 0 0 0 0 0 0 0 0 2.4675 9.051 16.736 25.523 47.553 72.805
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.225 0.45 0.675 0.9 1.125 1.35 1.575 1.8 2.025 2.25 2.475 2.7 2.925 3.15 3.375 3.6 3.825 4.05 4.275 4.5
X 22.4 22.625 22.85 23.075 23.3 23.525 23.75 23.975 24.2 24.425 24.65 24.875 25.1 25.325 25.55 25.775 26 26.225 26.45 26.675 26.9
M(e) all 80.895 67.279 54.671 43.071 32.478 22.892 14.314 6.7431 0.1798 -5.376 -9.925 -13.47 -16 -17.53 -18.04 -17.56 -16.06 -13.56 -10.04 -5.526 0
M(e) odd 72.479 64.767 57.486 50.634 44.213 38.223 32.662 27.532 22.832 18.563 14.724 11.315 8.3366 5.7884 3.6706 1.983 0.7258 -0.101 -0.498 -0.464 0
M(e) even 42.183 30.503 19.83 10.165 1.508 -6.142 -12.78 -18.42 -23.05 -26.67 -29.28 -30.89 -31.48 -31.07 -29.66 -27.23 -23.8 -19.36 -13.92 -7.462 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 72.805 59.594 47.391 36.195 26.006 16.825 8.6512 1.485 -4.674 -9.825 -13.97 -17.11 -19.23 -20.36 -20.47 -19.58 -17.68 -14.77 -10.85 -5.93 0
M(r) odd 72.805 65.077 57.779 50.911 44.474 38.467 32.89 27.744 23.028 18.742 14.887 11.462 8.4671 5.9026 3.7684 2.0646 0.791 -0.052 -0.465 -0.448 0
M(r) even 46.401 34.51 23.627 13.751 4.8826 -2.978 -9.832 -15.68 -20.52 -24.35 -27.17 -28.99 -29.8 -29.6 -28.39 -26.18 -22.96 -18.73 -13.49 -7.251 0
70% max 56.626 47.095 40.24 35.444 30.949 26.756 22.864 19.273 15.983 12.994 10.307 7.9206 5.8356 4.0519 2.5694 1.3881 0.5081 -0.071 -0.348 -0.325 0
70% min 29.528 21.352 13.881 7.1158 1.0556 -4.299 -8.949 -12.89 -16.13 -18.67 -20.5 -21.62 -22.04 -21.75 -20.76 -19.06 -16.66 -13.55 -9.741 -5.223 0
Lower bound 0 0 0 0 0 -4.299 -9.832 -15.68 -20.52 -24.35 -27.17 -28.99 -29.8 -29.6 -28.39 -26.18 -22.96 -18.73 -13.49 -7.251 0
Upper bound 72.805 65.077 57.779 50.911 44.474 38.467 32.89 27.744 23.028 18.742 14.887 11.462 8.4671 5.9026 3.7684 2.0646 0.791 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
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:2005 c/w ANALYSIS Made by rmw Job No R68
Originated from RCC31.xls v4.0 on CD © 2006 TCC Date 25-Oct-24
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 26.9 26.9 26.9 26.9 26.9 26.9 26.9 26.9 26.9 26.9 26.9 26.9 26.9 26.9 26.9 26.9 26.9 26.9 26.9 26.9 26.9
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
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 26.9 26.9 26.9 26.9 26.9 26.9 26.9 26.9 26.9 26.9 26.9 26.9 26.9 26.9 26.9 26.9 26.9 26.9 26.9 26.9 26.9
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 26.9 26.9 26.9 26.9 26.9 26.9
### 85.894 -168.6 85.894 -168.6 85.894 -168.6 85.894 -168.6 85.894 -168.6 85.894
Disclaimer
All advice or information from MPA-The Concrete Centre is intended for those who will evaluate the significance and limitations of its
contents and take responsibility for its use and application. No liability (including that for negligence) for any loss resulting from such advice
or information is accepted by MPA-The Concrete Centre or its subcontractors, suppliers or advisors. Users should note that all MPA-The
Concrete Centre software and publications are subject to revision from time to time and they should therefore ensure that they are in
possession of the latest version.
This spreadsheet should be used in compliance with the accompanying publication 'User Guide RC Spreadsheets: v4' available from The
Concrete Centre www.concretecentre.com/rcdesign Tel +44 (0)1276 606800
Status of spreadsheet This spreadsheet is shareware but may not be used for commercial purposes until the
user has registered with The Concrete Centre using the licence validation form available
Public release version. on The Concrete Centre website www.concretecentre.com/rcdesign