REINFORCED CONCRETE

Project Spreadsheets to BS 8110 COUNCIL

Client Advisory Group Made by Date Page
Location 8th Floor slab from A to G rmw 6-Nov-20 38
ONE-WAY SOLID RC SLAB DESIGN to BS 8110:1997 c/w ANALYSIS Checked Revision Job No
Originated from RCC31.xls v2.7 on CD © 1999-2003 BCA for RCC chg - R68
0
LOCATION Supports from grid A to grid G

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

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 UDLs (kN/m²) PLs (kN/m) Position (m) LOADING

Dead Imposed Position Dead Imposed Position
Span 1 Load Load from left Span 4 Load Load from left
UDL 9.70 5.00 ~~~~ UDL 6.00 1.50 ~~~~
PL 1 35.00 1.000 PL 1
PL 2 PL 2
Span 2 Span 5
UDL 6.00 1.50 ~~~~ UDL ~~~~
PL 1 PL 1
PL 2 PL 2
Span 3 Span 6
UDL 8.50 5.00 UDL ~~~~
PL 1 PL 1
PL 2 PL 2

LOADING DIAGRAM

A G
REACTIONS (kN/m)
SUPPORT 1 2 3 4 5
Characteristic Dead 63.80 72.78 49.39 51.45 6.59 0.00 0.00
Max Imposed 19.00 27.17 22.79 25.77 3.28 0.00 0.00
Min Imposed -0.72 6.45 5.46 3.07 -3.75 0.00 0.00
MAX ULTIMATE 120.17 141.99 108.37 110.70 16.35 0.00 0.00
Project Spreadsheets to BS 8110 REINFORCED CONCRETE COUNCIL
Client Advisory Group Made by Date Page
Location 8th Floor slab, from A to G rmw 6-Nov-20 39
ONE-WAY SOLID RC SLAB DESIGN to BS 8110:1997 c/w ANALYSChecked Revision Job No
Originated from RCC31.xls v2.7 on CD © 1999-2003 BCA for RCC chg - R68

BENDING MOMENT DIAGRAMS (kNm/m)

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

A Elastic Moments G A Redistributed Envelope G

SUPPORT No 1 2 3 4 5
Elastic M 0.0 85.0 60.4 71.2 0.0 ~ ~
Redistributed M 0.0 72.2 60.4 64.1 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.7 19.6 69.3 13.5 ~ ~
Redistributed M 166.4 15.6 72.1 12.4 ~ ~
ßb 0.986 0.798 1.040 0.917 ~ ~

SHEAR FORCE DIAGRAMS (kN/m)

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

A Elastic Shears G A Redistributed Shears G

SPAN No 1 2 3
Elastic V 120.9 103.1 42.3 35.5 70.1 74.4
Redistributed V 120.2 101.5 43.6 37.2 71.1 73.6

SPAN No 4
Elastic V 40.1 17.1 ~ ~ ~ ~
Redistributed V 38.5 16.4 ~ ~ ~ ~
Project Spreadsheets to BS 8110 REINFORCED CONCRETE COUNCIL
Client Advisory Group Made by Date Page
Location 8th Floor slab, from A to G rmw Nov-2020 41
ONE-WAY SOLID RC SLAB DESIGN to BS 8110:1997 c/w ANALYSIS Checked Revision Job No
Originated from RCC31.xls v2.7 on CD © 1999-2003 BCA for RCC chg - R68

SPAN 3 LEFT CENTRE RIGHT

Av 0 7200
ACTIONS M 60.4 72.1 64.1
ßb 1.00 1.04 0.90
V 71.13 73.63
DESIGN d 219.0 219.0 219.0
As 663 791 703
As' 0 As' 0 As' 0
TOP STEEL T 12 @ 150 10 @0 T 12 @ 150
As prov 754 0 As prov 754
BTM STEEL T 12 @ 250 T 12 @ 125 T 10 @ 225
As' prov 452 As prov 905 As' prov 349
SHEAR v 0.325 0.336
vc 0.576 0.576
Links not required
DEFLECTION L/d 32.877 Allowed 34.055 ok (As increased by 8.8%)
& CHECKS % As ok ok ok
d'/x ok ok ok
max S ok ok ok

SPAN 4 LEFT CENTRE RIGHT

Av 0 4500
ACTIONS M 64.1 12.4 0.0
ßb 0.90 0.92 1.00
V 38.55 16.35
DESIGN d 219.0 220.0 219.0
As 703 325 325
As' 0 As top 403 As' 0
TOP STEEL T 12 @ 150 T 12 @ 275 T 12 @ 300
As prov 754 As' prov 411 As prov 377
BTM STEEL T 10 @ 225 T 10 @ 225 T 12 @ 300
As' prov 349 As prov 349 As' prov 377
SHEAR v 0.176 0.075
vc 0.576 0.457
Links not required
DEFLECTION L/d 20.455 Allowed 55.050 ok
& CHECKS % As ok ok ok
d'/x ok ok ok
max S ok ok ok
Project Spreadsheets to BS 8110
Location 8th Floor slab, from A to G
ONE-WAY SOLID RC SLAB DESIGN to BS 8110:1997 c/w ANALYSIS Made by rmw Job No R68 Page 42
Originated from RCC31.xls v2.7 on CD © 1999-2003 BCA for RCC Date 6-Nov-20

WEIGHT of REINFORCEMENT SUPPORT WIDTH SUPPORT WIDTH Bay width 10000 mm

SUPPORT WIDTHS 1 300 4 300
(mm) 2 300 5 300 DISTRIBUTION STEEL
3 300 f 10 mm

TOP STEEL Type Dia Spacing No Length Unit wt Weight

Support 1 T 12 @ 225 45 2225 0.888 88.9
Span 1 T @
Support 2 T 16 @ 250 40 3800 1.578 239.9
Span 2 T 10 @ 175 58 4375 0.617 156.4
Support 3 T 12 @ 150 67 3600 0.888 214.1
Span 3 T 10 @ 0.617
Support 4 T 12 @ 150 67 2925 0.888 174.0
Span 4 T 12 @ 275 37 3175 0.888 104.3
Support 5 T 12 @ 300 34 1350 0.888 40.8

BOTTOM STEEL Support 1 T 12 @ 200 50 850 0.888 37.7

Span 1 T 20 @ 200 50 7650 2.466 943.3
Support 2 T 16 @ 350 29 1575 1.578 72.1
Span 2 T 12 @ 300 34 6850 0.888 206.8
Support 3 T 12 @ 250 40 1275 0.888 45.3
Span 3 T 12 @ 125 80 6850 0.888 486.5
Support 4 T 10 @ 225 45 1125 0.617 31.2
Span 4 T 10 @ 225 45 4150 0.617 115.1
Support 5 T 12 @ 300 34 875 0.888 26.4

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

Top Span 1 T 10 @ 150 25 10400 0.617 160.3

Span 2 T 10 @ 225 31 10400 0.617 198.8
Span 3 T 10 @ 225 15 10400 0.617 96.2
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³) 57.7 TOTAL REINFORCEMENT IN BAY, kg 4413
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 v2.7 on CD © 1999-2003 BCA for RCC Date 6-Nov-20

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 2170138.89 2170138.89 2170138.89 2170138.89 3472222.2 3472222.2 #DIV/0! #DIV/0! #DIV/0!
Sum 7529514 4340278 5642361 #DIV/0! #DIV/0!
Factor 1 0.7117823 0.2882177 0.5 0.5 0.3846154 0.615385 1 0 1 0 1

Fixed End Moments

Min load SPAN 1 SPAN 2 SPAN 3 SPAN 4 SPAN 5 SPAN 6
L R L R L R L R L R L R
Cant 555.4 155.52 220.32 60.75 0 0
UDL 51.73333 51.733333 25.92 25.92 36.72 36.72 10.125 10.125 0 0 0 0
PL 1 26.79688 3.828125 0 0 0 0 0 0 #DIV/0! #DIV/0! #DIV/0! #DIV/0!
PL 2 0 0 0 0 0 0 0 0 #DIV/0! #DIV/0! #DIV/0! #DIV/0!
FEM 78.53021 55.561458 25.92 25.92 36.72 36.72 10.125 10.125 0 0 0 0
Imposed load
Cant 160 38.88 129.6 15.1875 0 0
UDL 26.66667 26.666667 6.48 6.48 21.6 21.6 2.53125 2.53125 0 0 0 0
PL 1 0 0 0 0 0 0 0 0 #DIV/0! #DIV/0! #DIV/0! #DIV/0!
PL 2 0 0 0 0 0 0 0 0 #DIV/0! #DIV/0! #DIV/0! #DIV/0!
FEM 26.66667 26.666667 6.48 6.48 21.6 21.6 2.53125 2.53125 0 0 0 0
Live load
Cant 478.16 124.416 295.488 48.6 0 0
UDL 63.36 63.36 20.736 20.736 49.248 49.248 8.1 8.1 0 0 0 0
PL 1 10.71875 1.53125 0 0 0 0 0 0 #DIV/0! #DIV/0! #DIV/0! #DIV/0!
PL 2 0 0 0 0 0 0 0 0 #DIV/0! #DIV/0! #DIV/0! #DIV/0!
FEM 74.07875 64.89125 20.736 20.736 49.248 49.248 8.1 8.1 0 0 0 0

Moment Distribution
SUPT 1 SUPT 2 SUPT 3 SUPT 4 SUPT 5 SUPT 6 SUPT 7
Min load -78.5302 55.561458 -25.92 25.92 -36.72 36.72 -10.125 10.125 0 0 0 0
78.53021 -21.09827 -8.543192 5.4 5.4 -10.22885 -16.3662 -10.125 0 0 0 0
-10.5491 39.265104 2.7 -4.271596 -5.114423 2.7 -5.0625 -8.18308 0 0 0 0
10.54913 -29.87002 -12.09508 4.6930095 4.6930095 0.9086538 1.453846 8.183077 0 0 0 0
-14.935 5.2745666 2.3465047 -6.047542 0.4543269 2.3465047 4.091538 0.726923 0 0 0 0
14.93501 -5.424544 -2.196527 2.7966076 2.7966076 -2.47617 -3.96187 -0.72692 0 0 0 0
-2.71227 7.467505 1.3983038 -1.098264 -1.238085 1.3983038 -0.36346 -1.98094 0 0 0 0
2.712272 -6.310526 -2.555283 1.1681745 1.1681745 -0.398016 -0.63683 1.980936 0 0 0 0
-3.15526 1.356136 0.5840872 -1.277641 -0.199008 0.5840872 0.990468 -0.31841 0 0 0 0
3.155263 -1.381017 -0.559207 0.7383247 0.7383247 -0.605598 -0.96896 0.318413 0 0 0 0
-0.69051 1.5776315 0.3691624 -0.279603 -0.302799 0.3691624 0.159207 -0.48448 0 0 0 0
0.690508 -1.385694 -0.5611 0.2912012 0.2912012 -0.203219 -0.32515 0.484479 0 0 0 0
-0.69285 0.3452542 0.1456006 -0.28055 -0.101609 0.1456006 0.242239 -0.16258 0 0 0 0
0.692847 -0.349382 -0.141473 0.1910798 0.1910798 -0.149169 -0.23867 0.162575 0 0 0 0
Sum 0 45.028207 -45.02821 27.943201 -27.9432 31.111293 -31.1113 0 0 0 0 0
Imposed on -6.48 6.48 -2.53125 2.53125 0 0
Even Spans 0 4.6123496 1.8676504 -3.24 -3.24 0.9735577 1.557692 -2.53125 0 0 0 0
2.306175 0 -1.62 0.9338252 0.4867788 -1.62 -1.26563 0.778846 0 0 0 0
-2.30617 1.1530874 0.4669126 -0.710302 -0.710302 1.1098558 1.775769 -0.77885 0 0 0 0
0.576544 -1.153087 -0.355151 0.2334563 0.5549279 -0.355151 -0.38942 0.887885 0 0 0 0
-0.57654 1.0735375 0.4347009 -0.394192 -0.394192 0.2863747 0.458199 -0.88788 0 0 0 0
0.536769 -0.288272 -0.197096 0.2173505 0.1431873 -0.197096 -0.44394 0.2291 0 0 0 0
-0.53677 0.3454763 0.1398916 -0.180269 -0.180269 0.2465532 0.394485 -0.2291 0 0 0 0
0.172738 -0.268384 -0.090134 0.0699458 0.1232766 -0.090134 -0.11455 0.197243 0 0 0 0
-0.17274 0.2551874 0.1033315 -0.096611 -0.096611 0.0787247 0.12596 -0.19724 0 0 0 0
 0.127594 -0.086369 -0.048306 0.0516657 0.0393624 -0.048306 -0.09862 0.06298 0 0 0 0
-0.12759 0.0958591 0.0388156 -0.045514 -0.045514 0.0565103 0.090417 -0.06298 0 0 0 0
0.04793 -0.063797 -0.022757 0.0194078 0.0282552 -0.022757 -0.03149 0.045208 0 0 0 0
-0.04793 0.0616075 0.0249464 -0.023831 -0.023831 0.0208642 0.033383 -0.04521 0 0 0 0
Sum 0 5.7371951 -5.737195 3.3149316 -3.314932 0.4389965 -0.439 0 0 0 0 0
Imposed on -26.6667 26.666667 -21.6 21.6 0 0
Odd Spans 26.66667 -18.98086 -7.685804 10.8 10.8 -8.307692 -13.2923 0 0 0 0 0
-9.49043 13.333333 5.4 -3.842902 -4.153846 5.4 0 -6.64615 0 0 0 0
9.490431 -13.33406 -5.399278 3.9983742 3.9983742 -2.076923 -3.32308 6.646154 0 0 0 0
-6.66703 4.7452156 1.9991871 -2.699639 -1.038462 1.9991871 3.323077 -1.66154 0 0 0 0
6.667028 -4.800547 -1.943856 1.8690502 1.8690502 -2.047025 -3.27524 1.661538 0 0 0 0
-2.40027 3.3335139 0.9345251 -0.971928 -1.023512 0.9345251 0.830769 -1.63762 0 0 0 0
2.400273 -3.037915 -1.230124 0.9977201 0.9977201 -0.678959 -1.08633 1.63762 0 0 0 0
-1.51896 1.2001367 0.4988601 -0.615062 -0.33948 0.4988601 0.81881 -0.54317 0 0 0 0
1.518957 -1.209316 -0.489681 0.4772709 0.4772709 -0.506796 -0.81087 0.543167 0 0 0 0
-0.60466 0.7594787 0.2386354 -0.24484 -0.253398 0.2386354 0.271584 -0.40544 0 0 0 0
0.604658 -0.71044 -0.287674 0.2491192 0.2491192 -0.196238 -0.31398 0.405437 0 0 0 0
-0.35522 0.302329 0.1245596 -0.143837 -0.098119 0.1245596 0.202718 -0.15699 0 0 0 0
0.35522 -0.303852 -0.123037 0.1209781 0.1209781 -0.125876 -0.2014 0.156991 0 0 0 0
Sum 0 7.9636866 -7.963687 9.9943041 -9.994304 16.856257 -16.8563 0 0 0 0 0
Live on -74.0788 64.89125 -49.248 49.248 0 0
Odd Spans 74.07875 -46.18845 -18.7028 24.624 24.624 -18.94154 -30.3065 0 0 0 0 0
-23.0942 37.039375 12.312 -9.351402 -9.470769 12.312 0 -15.1532 0 0 0 0
23.09422 -35.12744 -14.22394 9.4110857 9.4110857 -4.735385 -7.57662 15.15323 0 0 0 0
-17.5637 11.547111 4.7055429 -7.111969 -2.367692 4.7055429 7.576615 -3.78831 0 0 0 0
17.56372 -11.56835 -4.684302 4.7398306 4.7398306 -4.723907 -7.55825 3.788308 0 0 0 0
-5.78418 8.7818593 2.3699153 -2.342151 -2.361954 2.3699153 1.894154 -3.77913 0 0 0 0
5.784176 -7.937636 -3.214138 2.3520523 2.3520523 -1.640027 -2.62404 3.779126 0 0 0 0
-3.96882 2.8920881 1.1760261 -1.607069 -0.820013 1.1760261 1.889563 -1.31202 0 0 0 0
3.968818 -2.895612 -1.172502 1.2135412 1.2135412 -1.179073 -1.88652 1.312021 0 0 0 0
-1.44781 1.984409 0.6067706 -0.586251 -0.589536 0.6067706 0.656011 -0.94326 0 0 0 0
1.447806 -1.844356 -0.746824 0.5878938 0.5878938 -0.485685 -0.7771 0.943258 0 0 0 0
-0.92218 0.723903 0.2939469 -0.373412 -0.242843 0.2939469 0.471629 -0.38855 0 0 0 0
0.922178 -0.724488 -0.293362 0.3081272 0.3081272 -0.294452 -0.47112 0.388548 0 0 0 0
Sum 0 21.573669 -21.57367 21.864276 -21.86428 38.712135 -38.7121 0 0 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 v2.7 on CD © 1999-2003 BCA for RCC Date 6-Nov-20

Live on -20.736 20.736 -8.1 8.1 0 0

Even Spans 0 14.759519 5.9764814 -10.368 -10.368 3.1153846 4.984615 -8.1 0 0 0 0
7.379759 0 -5.184 2.9882407 1.5576923 -5.184 -4.05 2.492308 0 0 0 0
-7.37976 3.6898796 1.4941204 -2.272967 -2.272967 3.5515385 5.682462 -2.49231 0 0 0 0
1.84494 -3.68988 -1.136483 0.7470602 1.7757692 -1.136483 -1.24615 2.841231 0 0 0 0
-1.84494 3.4353199 1.391043 -1.261415 -1.261415 0.9163989 1.466238 -2.84123 0 0 0 0
1.71766 -0.92247 -0.630707 0.6955215 0.4581994 -0.630707 -1.42062 0.733119 0 0 0 0
-1.71766 1.1055241 0.4476531 -0.57686 -0.57686 0.7889703 1.262352 -0.73312 0 0 0 0
0.552762 -0.85883 -0.28843 0.2238266 0.3944851 -0.28843 -0.36656 0.631176 0 0 0 0
-0.55276 0.8165996 0.3306607 -0.309156 -0.309156 0.2519192 0.403071 -0.63118 0 0 0 0
0.4083 -0.276381 -0.154578 0.1653303 0.1259596 -0.154578 -0.31559 0.201535 0 0 0 0
-0.4083 0.306749 0.12421 -0.145645 -0.145645 0.1808331 0.289333 -0.20154 0 0 0 0
0.153374 -0.20415 -0.072822 0.062105 0.0904165 -0.072822 -0.10077 0.144666 0 0 0 0
-0.15337 0.197144 0.0798283 -0.076261 -0.076261 0.0667654 0.106825 -0.14467 0 0 0 0
Sum 0 18.359024 -18.35902 10.607781 -10.60778 1.4047887 -1.40479 0 0 0 0 0

Elastic Support Moments (3.2.1.2.2)

Support 1 2 3 4 5 6 7
All spans 0 84.960901 60.415258 71.228217 0 0 0
Odd Spans 0 66.601877 49.807477 69.823429 0 0 0
Even Spans 0 63.387232 38.550982 32.516082 0 0 0
Reverse 0 0 0 0 0 0 0
Redistribution (3.2.2.1) method 1
ßb - 1 0.85 1 0.9 1 1 1
ßb + 1 1.15 1 1.1 1 1 1
Max M 0 72.216766 60.415258 64.105396 0 0 0
Dead only 0 45.028207 27.943201 31.111293 0 0 0
All spans 0 72.216766 60.415258 64.105396 0 0 0
Odd Spans 0 72.216766 49.807477 64.105396 0 0 0
Even Spans 0 72.216766 38.550982 35.76769 0 0 0
Reverse 0 0 0 0 0 0 0
Total Ultimate Loads
Span 1 2 3
UDL PL1 PL2 UDL PL1 PL2 UDL PL1 PL2
Dead only 77.6 35 0 43.2 0 0 61.2 0 0
All spans 172.64 49 0 77.76 0 0 143.28 0 0
Odd Spans 172.64 49 0 43.2 0 0 143.28 0 0
Even Spans 77.6 35 0 77.76 0 0 61.2 0 0
Imposed 40 0 0 10.8 0 0 36 0 0
Span 4 5 6
Dead only 27 0 0 0 0 0 0 0 0
All spans 48.6 0 0 0 0 0 0 0 0
Odd Spans 27 0 0 0 0 0 0 0 0
Even Spans 48.6 0 0 0 0 0 0 0 0
Imposed 6.75 0 0 0 0 0 0 0 0

Elastic Shears
Span 1 2 3
All spans 118.57 103.07 42.29 35.47 70.14 73.14
Odd Spans 120.87 100.77 23.93 19.27 68.86 74.42
Even Spans 61.50 51.10 42.33 35.43 31.44 29.76
Imposed all 18.29 21.71 5.45 5.35 17.45 18.55
Imposed odd 19.00 21.00 -0.28 0.28 17.05 18.95
Imposed even -0.72 0.72 5.74 5.06 0.40 -0.40
Span 4 5 6
All spans 40.13 8.47 0.00 0.00 0.00 0.00
Odd Spans 29.02 -2.02 0.00 0.00 0.00 0.00
Even Spans 31.53 17.07 0.00 0.00 0.00 0.00
Imposed all 7.22 -0.47 0.00 0.00 0.00 0.00
 Imposed odd 3.75 -3.75 0.00 0.00 0.00 0.00
Imposed even 3.47 3.28 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:1997 c/w ANALYSIS Made by rmw Job No R68
Originated from RCC31.xls v2.7 on CD © 1999-2003 BCA for RCC Date 6-Nov-20

Redistributed Shears
Span 1 2 3
Dead only 63.79647 48.803526 23.972918 19.227082 30.15999 31.04001
All spans 120.1679 101.4721 40.519098 37.240902 71.12748 72.15252
Odd Spans 120.1679 101.4721 24.712401 18.487599 69.65418 73.62582
Even Spans 60.3979 52.202096 43.555803 34.204197 30.98657 30.21343
Span 4 5 6
Dead only 20.41362 6.5863792 0 0 0 0
All spans 38.54564 10.054357 0 0 0 0
Odd Spans 27.74564 -0.745643 0 0 0 0
Even Spans 32.24838 16.351624 0 0 0 0

Imposed Reactions
Support 1 2 3 4 5 6 7
All spans 18.29 27.17 22.79 25.77 -0.47 0.00 0.00
Odd Spans 19.00 20.71 17.33 22.70 -3.75 0.00 0.00
Even Spans -0.72 6.45 5.46 3.07 3.28 0.00 0.00

SPAN MOMENTS
SPAN 1 Left < > PL1 < > PL2 < > Right
Elastic V All 118.57 103.07
Odd 120.87 100.77
Even 61.50 Loadings 51.10
Redist V All 120.17 21.58 49 0 101.47
Odd 120.17 21.58 49 0 101.47
Even 60.40 9.7 35 0 52.20
Elastic X- All 5.495 1 3.224 0 3.224
Odd 5.601 1 3.330 0 3.330
Even 6.340 1 2.732 0 2.732
Redist X- All 5.568 1 3.298 0 3.298
Odd 5.568 1 3.298 0 3.298 (3.2.2.1b)
Even 6.227 1 2.618 0 2.618 Max
Elastic M All 0.00 0.00 107.78 161.16 0.00 161.16 84.96 161.16
Odd 0.00 0.00 110.08 168.68 0.00 168.68 66.60 168.68
Even 0.00 0.00 56.65 71.20 0.00 71.20 63.39 71.20 ßb
Redist M All 0.00 0.00 109.38 166.35 0.00 166.35 72.22 166.35 1.032
Odd 0.00 0.00 109.38 166.35 0.00 166.35 72.22 166.35 0.986
Even 0.00 0.00 55.55 68.25 0.00 68.25 72.22 68.25 0.959

SPAN 2 Left < > PL1 < > PL2 < > Right
Elastic V All 42.29 35.47
Odd 23.93 19.27
Even 42.33 Loadings 35.43
Redist V All 40.52 10.8 0 0 37.24
Odd 24.71 6 0 0 18.49
Even 43.56 10.8 0 0 34.20
Elastic X- All 3.916 0 3.916 0 3.916
Odd 3.989 0 3.989 0 3.989
Even 3.919 0 3.919 0 3.919
Redist X- All 3.752 0 3.752 0 3.752
Odd 4.119 0 4.119 0 4.119 (3.2.2.1b)
Even 4.033 0 4.033 0 4.033 Max
Elastic M All 84.96 0.00 -84.96 -2.17 0.00 -2.17 60.42 0.00
Odd 66.60 0.00 -66.60 -18.87 0.00 -18.87 49.81 0.00
Even 63.39 0.00 -63.39 19.57 0.00 19.57 38.55 19.57 ßb
Redist M All 72.22 0.00 -72.22 3.79 0.00 3.79 60.42 3.79 0.000
Odd 72.22 0.00 -72.22 -21.32 0.00 -21.32 49.81 0.00 0.000
Even 72.22 0.00 -72.22 15.61 0.00 15.61 38.55 15.61 0.798
 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 v2.7 on CD © 1999-2003 BCA for RCC Date 6-Nov-20

SPAN 3 Left < > PL1 < > PL2 < > Right
Elastic V All 70.14 73.14
Odd 68.86 74.42
Even 31.44 Loadings 29.76
Redist V All 71.13 19.9 0 0 72.15
Odd 69.65 19.9 0 0 73.63
Even 30.99 8.5 0 0 30.21
Elastic X- All 3.525 0 3.525 0 3.525
Odd 3.460 0 3.460 0 3.460
Even 3.699 0 3.699 0 3.699
Redist X- All 3.574 0 3.574 0 3.574
Odd 3.500 0 3.500 0 3.500 (3.2.2.1b)
Even 3.645 0 3.645 0 3.645 Max
Elastic M All 60.42 0.00 -60.42 63.19 0.00 63.19 71.23 63.19
Odd 49.81 0.00 -49.81 69.33 0.00 69.33 69.82 69.33
Even 38.55 0.00 -38.55 19.59 0.00 19.59 32.52 19.59 ßb
Redist M All 60.42 0.00 -60.42 66.70 0.00 66.70 64.11 66.70 1.056
Odd 49.81 0.00 -49.81 72.09 0.00 72.09 64.11 72.09 1.040
Even 38.55 0.00 -38.55 17.93 0.00 17.93 35.77 17.93 0.915

SPAN 4 Left < > PL1 < > PL2 < > Right
Elastic V All 40.13 8.47
Odd 29.02 -2.02
Even 31.53 Loadings 17.07
Redist V All 38.55 10.8 0 0 10.05
Odd 27.75 6 0 0 -0.75
Even 32.25 10.8 0 0 16.35
Elastic X- All 3.716 0 3.716 0 3.716
Odd 4.836 0 4.500 0 4.500
Even 2.919 0 2.919 0 2.919
Redist X- All 3.569 0 3.569 0 3.569
Odd 4.624 0 4.500 0 4.500 (3.2.2.1b)
Even 2.986 0 2.986 0 2.986 Max
Elastic M All 71.23 0.00 -71.23 3.32 0.00 3.32 0.00 3.32
Odd 69.82 0.00 -69.82 0.00 0.00 0.00 0.00 0.00
Even 32.52 0.00 -32.52 13.50 0.00 13.50 0.00 13.50 ßb
Redist M All 64.11 0.00 -64.11 4.68 0.00 4.68 0.00 4.68 1.409
Odd 64.11 0.00 -64.11 0.00 0.00 0.00 0.00 0.00 0.000
Even 35.77 0.00 -35.77 12.38 0.00 12.38 0.00 12.38 0.917

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:1997 c/w ANALYSIS Made by rmw Job No R68
Originated from RCC31.xls v2.7 on CD © 1999-2003 BCA for RCC Date 6-Nov-20

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:1997 c/w ANALYSIS Made by rmw Job No R68
Originated from RCC31.xls v2.7 on CD © 1999-2003 BCA for RCC Date 6-Nov-20

REINFORCEMENT DESIG SPAN 2

Top cover 25 to main steel Span = 7.2 BS 8110 ref
Btm cover 25 to main steel h= 250
Min As = 0.13% 325 mm²/m b= 1000 3.12.5.3

BENDING LEFT SPAN RIGHT

M kNm/m 72.2 15.6 60.4
ßb 0.850 0.798 1.000
d mm 217.0 219.0 219.0
K' 0.144 0.131 0.157 3.4.4.4
K 0.0438 0.0093 0.0360 3.4.4.4
z mm 205.9 208.1 208.1 3.4.4.4
As basic mm²/m 801 171 663 3.4.4.4
Residual M kNm/m 0.0 0.0 0.0 3.4.4.4
d - d' mm 184 189 188 3.4.4.4
As' basic mm²/m 0 0 0 3.4.4.4
As final mm²/m 801 325 663 3.12.5.3
S tens mm 251 348 171
Round to mm 250 300 150
As prov mm²/m 804 377 754
Enhanced by (deflection) 0.00% 0.00%
hogging M kNm/m 37.5
at 0.25L k = 0.0221 z = 209.00 As = 409 3.4.4.4
0 0
As' final mm²/m 325 409 325 3.12.5.3
S comp mm 619 192 348
Round to mm 600 175 300
As' prov mm²/m 335 449 377

SHEAR
Mod factor for fcu 1.12 Table 3.8
V kN/m 43.6 37.2
As prov % 0.371 0.172 0.344
Av 0 7200 3.4.5.8
vc N/mm² 0.592 0.576 Table 3.8
v N/mm² 0.201 0.170 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 175 270 Eqn 8

DEFLECTION
Base ratio 26 As'= 0.205 %
k tens 2.000 k comp 1.064
Final ratio 55.325 > 32.877 Actual

CHECKS LEFT SPAN RIGHT

4% steel mm²/m 8680 8760 8760 3.12.6.1
d'/x 0.000 0.000 0.000 3.4.4.4
v max N/mm² 0.201 Err:520 4.733 Err:520 0.170 3.4.5.2
Clause (b)? Yes No Yes 3.12.11.2.7
Max S mm 353 657 506 3.12.11.2.7
Actual S mm 234 288 138
Project Spreadsheets to BS 8110
Location 8th Floor slab, from A to G GRAPH DATA I
ONE-WAY SOLID RC SLAB DESIGN to BS 8110:1997 c/w ANALYSIS Made by rmw Job No R68

Originated from RCC31.xls v2.7 on CD © 1999-2003 BCA for RCC Date 6-Nov-20

LOADING DIAGRAM
Beam 0 26.9 -12.425
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.425 0 -12.425 0 -12.425 0 -12.425 0 -12.425 0 -12.425 0 -12.425 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 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 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 7.5 7.5 7.5 7.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 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 -45.7036 -87.9543 -116.952 -132.697 -144.99 -153.829 -159.216 -161.15 -159.631 -154.66 -146.235 -134.358 -119.028 -100.245 -78.0093 -52.3209 -23.1796 9.414411 45.46126 84.9609
M(e) odd 0 -46.6215 -89.7902 -119.706 -136.369 -149.58 -159.337 -165.642 -168.494 -167.893 -163.839 -156.333 -145.373 -130.961 -113.096 -91.7786 -67.0081 -38.7848 -7.10871 28.02018 66.60188
M(e) even 0 -23.8246 -46.0973 -59.8179 -64.9866 -68.6032 -70.6678 -71.1805 -70.1411 -67.5497 -63.4064 -57.711 -50.4637 -41.6643 -31.3129 -19.4096 -5.95421 9.053147 25.61251 43.72387 63.38723
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.3408 -89.2287 -118.864 -135.246 -148.176 -157.653 -163.677 -166.248 -165.366 -161.032 -153.244 -142 -127.312 -109.166 -87.5674 -62.5162 -34.0121 -2.05531 33.35433 72.21677
M(r) odd 0 -46.3408 -89.2287 -118.864 -135.246 -148.176 -157.653 -163.677 -166.248 -165.366 -161.032 -153.244 -142 -127.312 -109.166 -87.5674 -62.5162 -34.0121 -2.05531 33.35433 72.21677
M(r) even 0 -23.3832 -45.2143 -58.4935 -63.2206 -66.3958 -68.019 -68.0901 -66.6093 -63.5765 -58.9916 -52.8548 -45.1659 -35.9251 -25.1323 -12.7874 1.109413 16.55825 33.55909 52.11193 72.21677
70% max 0 -16.6772 -32.2681 -41.8725 -45.4906 -48.0222 -49.4675 -49.8263 -49.0988 -47.2848 -44.3845 -40.3977 -35.3246 -29.165 -21.9191 -13.5867 -4.16795 6.337203 17.92876 31.82288 59.47263
70% min 0 -32.6351 -62.8531 -83.7943 -95.4585 -104.706 -111.536 -115.949 -117.946 -117.525 -114.687 -109.433 -101.761 -91.6728 -79.1674 -64.245 -46.9057 -27.1494 -4.9761 19.61413 44.37106
Lower bound 0 -46.3408 -89.2287 -118.864 -135.246 -148.176 -157.653 -163.677 -166.248 -165.366 -161.032 -153.244 -142 -127.312 -109.166 -87.5674 -62.5162 -34.0121 -4.9761 0 0
Upper bound 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1.109413 16.55825 33.55909 52.11193 72.21677
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 84.9609 70.43666 57.3121 45.58721 35.26201 26.33649 18.81065 12.68449 7.958004 4.631202 2.70408 2.176637 3.048875 5.320793 8.992391 14.06367 20.53463 28.40526 37.67558 48.34558 60.41526
M(e) odd 66.60188 58.37496 50.92564 44.25392 38.3598 33.24328 28.90436 25.34304 22.55932 20.5532 19.32468 18.87376 19.20044 20.30472 22.1866 24.84608 28.28316 32.49784 37.49012 43.26 49.80748
M(e) even 63.38723 48.84846 35.70937 23.96995 13.63022 4.690169 -2.8502 -8.9909 -13.7319 -17.0732 -19.0149 -19.5569 -18.6992 -16.4418 -12.7847 -7.72796 -1.27153 6.584579 15.84037 26.49583 38.55098
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.21677 58.32973 45.84238 34.7547 25.0667 16.77839 9.889754 4.400798 0.311523 -2.37807 -3.66799 -3.55822 -2.04878 0.860346 5.16915 10.87764 17.9858 26.49364 36.40117 47.70837 60.41526
M(r) odd 72.21677 63.7091 55.97904 49.02657 42.85171 37.45444 32.83478 28.99271 25.92825 23.64139 22.13212 21.40046 21.44639 22.26993 23.87106 26.2498 29.40613 33.34007 38.05161 43.54074 49.80748
M(r) even 72.21677 57.23652 43.65595 31.47506 20.69385 11.31232 3.330471 -3.2517 -8.43419 -12.217 -14.6001 -15.5836 -15.1673 -13.3514 -10.1358 -5.52057 0.494379 7.909009 16.72332 26.93731 38.55098
70% max 59.47263 49.30566 40.11847 31.91105 26.85186 23.27029 20.23305 17.74013 15.79152 14.38724 13.52727 13.21163 13.44031 14.2133 15.53062 17.39225 19.79821 22.74849 26.37291 33.84191 42.29068
70% min 44.37106 34.19392 24.99656 16.77897 9.541155 3.283118 -1.99514 -6.29363 -9.61234 -11.9513 -13.3104 -13.6898 -13.0894 -11.5092 -8.94929 -5.40957 -0.89007 4.609205 11.08826 18.54708 26.98569
Lower bound 0 0 0 0 0 0 -1.99514 -6.29363 -9.61234 -12.217 -14.6001 -15.5836 -15.1673 -13.3514 -10.1358 -5.52057 -0.89007 0 0 0 0
Upper bound 72.21677 63.7091 55.97904 49.02657 42.85171 37.45444 32.83478 28.99271 25.92825 23.64139 22.13212 21.40046 21.44639 22.26993 23.87106 26.2498 29.40613 33.34007 38.05161 47.70837 60.41526
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 60.41526 36.45503 15.07383 -3.72832 -19.9514 -33.5955 -44.6605 -53.1465 -59.0535 -62.3814 -63.1303 -61.3001 -56.8909 -49.9026 -40.3354 -28.189 -13.4637 3.840753 23.7242 46.18669 71.22822
M(e) odd 49.80748 26.30739 5.386352 -12.9557 -28.7186 -41.9025 -52.5074 -60.5333 -65.9801 -68.8478 -69.1365 -66.8462 -61.9769 -54.5285 -44.501 -31.8946 -16.709 1.055516 21.39911 44.32175 69.82343
M(e) even 38.55098 27.78404 18.11869 9.554947 2.092802 -4.26774 -9.52669 -13.684 -16.7398 -18.6939 -19.5465 -19.2974 -17.9468 -15.4945 -11.9406 -7.28519 -1.52814 5.330517 13.29077 22.35263 32.51608
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 60.41526 36.09889 14.36155 -4.79674 -21.376 -35.3762 -46.7974 -55.6395 -61.9026 -65.5867 -66.6917 -65.2176 -61.1646 -54.5325 -45.3213 -33.5311 -19.1619 -2.21365 17.31366 39.42001 64.1054
M(r) odd 49.80748 26.02149 4.814549 -13.8134 -29.8622 -43.332 -54.2228 -62.5346 -68.2673 -71.4209 -71.9956 -69.9911 -65.4077 -58.2452 -48.5037 -36.1831 -21.2835 -3.80481 16.25288 38.88962 64.1054
M(r) even 38.55098 27.94662 18.44385 10.04269 2.743123 -3.45484 -8.55121 -12.546 -15.4391 -17.2307 -17.9207 -17.509 -15.9958 -13.381 -9.66452 -4.84649 1.073149 8.094384 16.21722 25.44165 35.76769
70% max 42.29068 25.51852 12.68308 6.688463 1.464961 -2.98742 -6.66868 -9.57882 -11.7178 -13.0857 -13.6825 -13.5082 -12.5627 -10.8462 -8.35845 -5.09964 -1.0697 3.731362 16.60694 32.33068 49.85975
70% min 26.98569 18.41518 3.770447 -9.06896 -20.103 -29.3318 -36.7552 -42.3733 -46.186 -48.1935 -48.3956 -46.7924 -43.3838 -38.1699 -31.1507 -22.3262 -11.6963 0.738861 9.30354 15.64684 22.76126
Lower bound 0 0 0 -13.8134 -29.8622 -43.332 -54.2228 -62.5346 -68.2673 -71.4209 -71.9956 -69.9911 -65.4077 -58.2452 -48.5037 -36.1831 -21.2835 -3.80481 0 0 0
Upper bound 60.41526 36.09889 18.44385 10.04269 2.743123 0 0 0 0 0 0 0 0 0 0 0 1.073149 8.094384 17.31366 39.42001 64.1054
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 71.22822 62.47268 54.2639 46.60186 39.48657 32.91804 26.89625 21.42122 16.49293 12.11139 8.276609 4.988573 2.247287 0.052751 -1.59503 -2.69607 -3.25036 -3.25789 -2.71868 -1.63271 0
M(e) odd 69.82343 63.44663 57.37359 51.60429 46.13874 40.97695 36.1189 31.5646 27.31406 23.36726 19.72421 16.38492 13.34937 10.61757 8.189529 6.065232 4.244686 2.727889 1.514843 0.605546 0
M(e) even 32.51608 25.69615 19.42297 13.69654 8.516866 3.883937 -0.20224 -3.74167 -6.73435 -9.18028 -11.0795 -12.4319 -13.2376 -13.4965 -13.2087 -12.3741 -10.9928 -9.06471 -6.58989 -3.56832 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 64.1054 55.706 47.85336 40.54746 33.78832 27.57592 21.91028 16.79138 12.21924 8.193843 4.715198 1.783303 -0.60184 -2.44024 -3.73188 -4.47678 -4.67492 -4.32632 -3.43096 -1.98886 0
M(r) odd 64.1054 58.0145 52.22736 46.74396 41.56432 36.68842 32.11628 27.84788 23.88324 20.22234 16.8652 13.8118 11.06216 8.616263 6.474119 4.635724 3.101079 1.870184 0.94304 0.319645 0
M(r) even 35.76769 28.78518 22.34942 16.46041 11.11815 6.322643 2.073883 -1.62813 -4.78339 -7.3919 -9.45365 -10.9687 -11.9369 -12.3584 -12.2332 -11.5612 -10.3425 -8.57697 -6.26473 -3.40574 0
70% max 49.85975 44.41264 40.16151 36.123 32.29712 28.68386 25.28323 22.09522 19.11984 16.35708 13.80695 11.46944 9.34456 7.432302 5.73267 4.245662 2.97128 1.909522 1.06039 0.423882 0
70% min 22.76126 17.98731 13.59608 9.587581 5.961806 2.718756 -0.14157 -2.61917 -4.71405 -6.4262 -7.75562 -8.70232 -9.2663 -9.44755 -9.24607 -8.66187 -7.69495 -6.3453 -4.61292 -2.49782 0
Lower bound 0 0 0 0 0 0 -0.14157 -2.61917 -4.78339 -7.3919 -9.45365 -10.9687 -11.9369 -12.3584 -12.2332 -11.5612 -10.3425 -8.57697 -6.26473 -3.40574 0
Upper bound 64.1054 58.0145 52.22736 46.74396 41.56432 36.68842 32.11628 27.84788 23.88324 20.22234 16.8652 13.8118 11.06216 8.616263 6.474119 4.635724 3.101079 1.909522 1.06039 0.423882 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:1997 c/w ANALYSIS Made by rmw Job No R68
Originated from RCC31.xls v2.7 on CD © 1999-2003 BCA for RCC Date 6-Nov-20

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

SHEAR FORCE DIAGRAMS

SPAN 1 SPAN 2 SPAN 3 SPAN 4 SPAN 5 SPAN 6
Local X 0 0 1 1 1 1 8 0 0 0 0 0 7.2 0 0 0 0 0 7.2 0 0 0 0 0 4.5 0 0 0 0 0 0 0 0 0 0 0 0 0
X 0 0 1 1 1 1 8 8 8 8 8 8 15.2 15.2 15.2 15.2 15.2 15.2 22.4 22.4 22.4 22.4 22.4 22.4 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
V(e) all 0 118.5749 96.99489 47.99489 47.99489 47.99489 -103.065 42.28912 42.28912 42.28912 42.28912 42.28912 -35.4709 70.1382 70.1382 70.1382 70.1382 70.1382 -73.1418 40.12849 40.12849 40.12849 40.12849 40.12849 -8.47151 0 0 0 0 0 0 0 0 0 0 0 0 0
V(e) odd 0 120.8698 99.28977 50.28977 50.28977 50.28977 -100.77 23.93256 23.93256 23.93256 23.93256 23.93256 -19.2674 68.86001 68.86001 68.86001 68.86001 68.86001 -74.42 29.01632 29.01632 29.01632 29.01632 29.01632 2.016317 0 0 0 0 0 0 0 0 0 0 0 0 0
V(e) even 0 61.5016 51.8016 16.8016 16.8016 16.8016 -51.0984 42.32948 42.32948 42.32948 42.32948 42.32948 -35.4305 31.43818 31.43818 31.43818 31.43818 31.43818 -29.7618 31.5258 31.5258 31.5258 31.5258 31.5258 -17.0742 0 0 0 0 0 0 0 0 0 0 0 0 0
V(r) all 0 120.1679 98.5879 49.5879 49.5879 49.5879 -101.472 40.5191 40.5191 40.5191 40.5191 40.5191 -37.2409 71.12748 71.12748 71.12748 71.12748 71.12748 -72.1525 38.54564 38.54564 38.54564 38.54564 38.54564 -10.0544 0 0 0 0 0 0 0 0 0 0 0 0 0
V(r) odd 0 120.1679 98.5879 49.5879 49.5879 49.5879 -101.472 24.7124 24.7124 24.7124 24.7124 24.7124 -18.4876 69.65418 69.65418 69.65418 69.65418 69.65418 -73.6258 27.74564 27.74564 27.74564 27.74564 27.74564 0.745643 0 0 0 0 0 0 0 0 0 0 0 0 0
V(r) even 0 60.3979 50.6979 15.6979 15.6979 15.6979 -52.2021 43.5558 43.5558 43.5558 43.5558 43.5558 -34.2042 30.98657 30.98657 30.98657 30.98657 30.98657 -30.2134 32.24838 32.24838 32.24838 32.24838 32.24838 -16.3516 0 0 0 0 0 0 0 0 0 0 0 0 0
Lower bound 0 60.3979 50.6979 15.6979 15.6979 15.6979 -101.472 24.7124 24.7124 24.7124 24.7124 24.7124 -37.2409 30.98657 30.98657 30.98657 30.98657 30.98657 -73.6258 27.74564 27.74564 27.74564 27.74564 27.74564 -16.3516 0 0 0 0 0 0 0 0 0 0 0 0 0
Upper bound 0 120.1679 98.5879 49.5879 49.5879 49.5879 -52.2021 43.5558 43.5558 43.5558 43.5558 43.5558 -18.4876 71.12748 71.12748 71.12748 71.12748 71.12748 -30.2134 38.54564 38.54564 38.54564 38.54564 38.54564 0.745643 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 8 8 15.2 15.2 22.4 22.4 26.9 26.9 26.9 26.9 26.9 26.9
-168.68 84.9609 -168.677 84.9609 -168.677 84.9609 -168.677 84.9609 -168.677 84.9609 -168.677 84.9609
Disclaimer
All advice or information from the British Cement Association and/or Reinforced Concrete Council is intended for those
will evaluate the significance and limitations of its contents and take responsibility for its use and application. No liab
(including that for negligence) for any loss resulting from such advice or information is accepted by the BCA, RCC or
subcontractors, suppliers or advisors. Users should note that all BCA software and publications are subject to revision f
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 t
8110 and EC2' available from British Cement Association, Telford Avenue, Crowthorne, Berkshire RG45 6YS.

Status of spreadsheet
Public release version.

Revision history RCC31 One-way Solid Slabs (A & D)

Date Version
4-Dec-04 RCC31 v2.7
10-Nov-04 RCC31 v2.6
18-Aug-03 RCC31 v2.5
11-Aug-03 RCC31 v2.4
8-Aug-03 RCC31 v2.3
26-Jun-03 RCC31 v2.2
21-Jan-03 RCC31 v2.1
11-Oct-02 RCC31 v2.0
12-Jul-02 RCC31 v1.5
17-May-01 RCC31 v1.4
5-May-01 RCC31 v1.3
30-Mar-01 RCC31 v1.2
4-Apr-00 RCC31 v1.1

4-Aug-99 RCC31 v1.0

mation from the British Cement Association and/or Reinforced Concrete Council is intended for those who
gnificance and limitations of its contents and take responsibility for its use and application. No liability
negligence) for any loss resulting from such advice or information is accepted by the BCA, RCC or their
pliers or advisors. Users should note that all BCA software and publications are subject to revision from
ould therefore ensure that they are in possession of the latest version.

hould be used in compliance with the accompanying publication 'Spreadsheets for concrete design to BS
lable from British Cement Association, Telford Avenue, Crowthorne, Berkshire RG45 6YS.

This spreadsheet is shareware. It may be distributed freely, but may not be used
for commercial purposes until the user has registered with the RCC.
RCC31 One-way Solid Slabs (A & D)

Action Size (kB)

Display and use of reverse support moments and shears. 758
Proportion of bottom steel at span ends corrected. 752
Minor correction to imposed reactions routine. 751
Routine for calculating imposed reactions upgraded. 751
Updated to May 2002 amendment to BS 8110 formulae for vc. 725
Correction to x-bar between point loads 724
DETR logo replaced by DTI. 723
Version 2 enhancements 746
Correction to enhancement of span steel for deflection. 654
BAR:D110 etc handed & BAR:F247 corrected (N Thomas) 654
Warning message corrected in MAIN:L28 etc 654
Min spacing at midspan in cantilevers (Arup) 654
Twopoint loads at same location (C Buczkowski) 654
First public release.
651
Includes b version comments