Spreadsheets To BS 8110: Advisory Group 3rd Floor Slab RMW 43 CHG - R68 1 5a

Download as xls, pdf, or txt
Download as xls, pdf, or txt
You are on page 1of 26

REINFORCED CONCRETE

Project Spreadsheets to BS 8110 COUNCIL


Client Advisory Group Made by Date Page
Location 3rd Floor slab from 1 to 5a rmw 6-Nov-20 43
RIBBED SLABS to BS 8110:1997 (Analysis & Design) Checked Revision Job No
Originated from RCC32.xls v2.6 on CD © 2000-2003 BCA for RCC chg - R68

LOCATION Supports from grid 1 to grid 5a 

MATERIALS COVERS (to links, or if no links, to reinf)


fcu 35 N/mm² h agg 20 mm Top cover 20 mm
fy 460 N/mm² gm 1.05 steel Btm cover 20 mm
fyv 460 N/mm² gm 1.50 concrete Side cover 20 mm
Density 23.6 kN/m³ (Normal weight concrete) RIBS
slab depth, hf 100 mm
SPANS Solid (mm) Rib width 150 mm
L (m) H (mm) Left Right Centres 900 mm
SPAN 1 2.000 275 450 1100 1 in 10 taper
SPAN 2 7.000 275 1100 1100 SUPPORTS
SPAN 3 7.500 275 1100 450 Support No Type
SPAN 4 1 C
SPAN 5 4 K
SPAN 6 K(nife), C(antilever) or E(ncastre)

LOADINGUDLs (kN/m²) PLs (kN/m) Position (m)


Self Add Dead Imposed Position Self Add Dead Imposed Position
Span 1 Weight Load Load from left Span 4 Weight Load Load from left
UDL 5.73 2.50 4.00 ~~~~ UDL ~~~~
PL 1 ~~~~ PL 1 ~~~
PL 2 ~~~~ PL 2 ~~~
Span 2 ~ ~ ~ ~ Span 5 ~ ~ ~ ~
UDL 4.19 2.50 4.00 ~~~~ UDL
PL 1 ~~~~ 8.50 1.00 1.450 PL 1 ~~~
PL 2 ~~~~ PL 2 ~~~
Span 3 ~ ~ ~ ~ Span 6 ~ ~ ~ ~
UDL 3.82 2.50 4.00 ~~~~ UDL ~~~~
PL 1 ~~~~ PL 1 ~~~~
PL 2 ~~~~ PL 2 ~~~~

LOADING PATTERN min max


DEAD 1 1.4
IMPOSED 0 1.6
LOADING DIAGRAM

1 5a
REACTIONS (kN/m)
SUPPORT 1 2 3 4
Characteristic Dead 43.0 58.0 18.2 ~ ~ ~
Max Imposed 20.4 34.9 13.3 ~ ~ ~
Min Imposed 7.3 17.3 -1.6 ~ ~ ~
MAX ULTIMATE 94.9 133.0 46.6 ~ ~ ~
REINFORCED CONCRETE
Project Spreadsheets to BS 8110 COUNCIL
Client Advisory Group Made by Date Page
Location 3rd Floor slab, from 1 to 5a rmw Nov-2020 44
RIBBED SLABS to BS 8110:1997 (Analysis & Design) Checked Revision Job No
Originated from RCC32.xls v2.6 on CD © 2000-2003 BCA for RCC chg - R68

BENDING MOMENT DIAGRAMS (kNm/m)

150 150

100 100

50 50

0 0

-50 -50

-100 -100
0 2 4 6 8 10 12 14 16 18 0 2 4 6 8 10 12 14 16 18

1 Elastic Moments 5a 1 Redistributed Envelope 5a

SUPPORT No 1 2 3 4
Elastic M 0.0 35.9 97.9 0.0 ~ ~ kNm/m
Redistributed M 0.0 35.9 83.2 0.0 ~ ~ kNm/m
ßb 1.000 1.000 0.850 1.000 ~ ~ ~
Redistribution 0.0% 15.0%

SPAN No 1 2 3
Elastic M 0.00 66.48 75.34 ~ ~ ~
Redistributed M 0.00 62.29 71.04 ~ ~ ~
ßb 1.000 0.937 0.943 #VALUE! #VALUE! #VALUE!
SHEAR FORCE DIAGRAMS (kN/m)

80 80

60 60

40 40

20 20

0 0

-20 -20

-40 -40
-60 -60
-80 -80
0 2 4 6 8 10 12 14 16 18 0 2 4 6 8 10 12 14 16 18

1 Elastic Shears 5a 1 Redistributed Shears 5a

SPAN No 1 2 3
Elastic V 0.0 35.9 58.2 66.8 70.3 47.9
Redistributed V 0.0 35.9 59.1 67.1 68.3 46.6

SPAN No
Elastic V ~ ~ ~ ~ ~ ~
Redistributed V ~ ~ ~ ~ ~ ~
Project Spreadsheets to BS 8110 REINFORCED CONCRETE COUNCIL
Client Advisory Group Made by Date Page
Location 3rd Floor slab, from 1 to 5a rmw Nov-2020 /46
RIBBED SLABS to BS 8110:1997 (Analysis & Design) Checked Revision Job No
Originated from RCC32.xls v2.6 on CD © 2000-2003 BCA for RCC chg - R68

SPAN 3 LEFT CENTRE RIGHT


ACTIONS M kNm/m 83.2 @col face 71.0 0.0
ßb 0.85 0.94 1.00
DESIGN d mm 239.0 236.5 (x=26.3<hf/0.9) 239.0
As mm² 753 650 (872 mm² for defln) 0
As' mm² 0 As T 263 As' 0
TOP STEEL 2T 20 /rib 3T 12 /rib 2T 20 /rib
+ 4 T8 between + 4 T8 between
As prov mm² 829 As T prov 339 As prov 829
BTM STEEL 2T 16 /rib 2T 25 /rib 3T 16 /rib
As' prov mm² 402 As prov 982 As' prov 603
SHEAR V kN/m 68.30 V 46.55
v N/mm² 1.152 v 0.890
vc N/mm² 0.935 Link Ø 6 vc 0.935
LINKS 2T6 @ 175 for 700 2T6 @ 1,200 .
DEFLECTION L/d 31.712 Allowed 33.985 ok (As increased by 34.2%)
& CHECKS % As ok ok ok
Bar Ø & cover ok ok ok
Bar spacing ok ok ok

Dist to link ok ok ok
Project Spreadsheets to BS 8110 REINFORCED CONCRETE COUNCIL
Client Advisory Group Made by Date Page
Location 3rd Floor slab, from 1 to 5a rmw Nov-2020 /47
RIBBED SLABS to BS 8110:1997 (Analysis & Design) Checked Revision Job No
Originated from RCC32.xls v2.6 on CD © 2000-2003 BCA for RCC chg - R68

APPROXIMATE WEIGHT of REINFORCEMENT

TOP STEEL No Type Dia Length Unit Wt Weight


Support 1 2 T 12 1025 0.888 1.8
4 T 8 1025 0.395 1.6
Span 1 1 T 16 2225 1.578 3.5
Support 2 2 T 20 2250 2.466 11.1
4 T 8 2250 0.395 3.6
Span 2 4 T 12 4425 0.888 15.7
Support 3 2 T 20 3625 2.466 17.9
4 T 8 3625 0.395 5.7
Span 3 3 T 12 4675 0.888 12.5
Support 4 2 T 20 2400 2.466 11.8
4 T 8 2400 0.395 3.8

BOTTOM STEEL Support 1 1 T 16 1150 1.578 1.8


Span 1 1 T 20 400 2.466 1.0
Support 2 1 T 16 3475 1.578 5.5
Span 2 2 T 25 4750 3.853 36.6
Support 3 2 T 16 3475 1.578 11.0
Span 3 2 T 25 5900 3.853 45.5
Support 4 3 T 16 1725 1.578 8.2

LINKS Span 1 1 T 6 800 0.222 0.2


Span 2 9 T 6 800 0.222 1.6
Span 3 9 T 6 800 0.222 1.6

SUMMARY All figures approximate - see User Guide.


Reinforcement density (kg/m²) 12.89 Total rebar per rib, excluding mesh (kg) 201.9
Project Spreadsheets to BS 8110
Location 3rd Floor slab, from 1 to 5a ANALYSIS I
RIBBED SLABS to BS 8110:1997 (Analysis & Design) Made by rmw Job No R68
Originated from RCC32.xls v2.6 on CD © 2000-2003 BCA for RCC Date 6-Nov-20

SELF WEIGHT 1 2 3 4 5 6
ave bw 167.5 167.5 167.5 140.0 140.0 140.0 mm
rib area 0.119 0.119 0.119 0.076 0.076 0.076 mm²
net self wt 3.129 3.129 3.129 1.993 1.993 1.993 kN/m²
E/O solid 3.361 3.361 3.361 -1.993 -1.993 -1.993 kN/m²
cross rib 0 0 0 0 0 0 kN/m²
addn. solid 2.60505486 1.05642778 0.6946813 #DIV/0! #DIV/0! #DIV/0! kN/m²
total SW 5.734 4.185 3.823 0.000 0.000 0.000 kN/m²
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
Af 90000 90000 90000 90000 90000 90000
h -hf 175 175 175 -100 -100 -100
Aw1 26250 26250 26250 -15000 -15000 -15000
Aw2 6125 6125 6125 2000 2000 2000
A sum 122375 122375 122375 77000 77000 77000
sum Ax 10391666.667 10391666.667 10391666.667 3883333.3333 3883333.3333 3883333.3333
x bar 84.916581546 84.916581546 84.916581546 50.432900433 50.432900433 50.432900433
sum Ad² 539513578 539513578 539513578 8902944.0977 8902944.0977 8902944.0977
Ix 686716268.93 686716268.93 686716268.93 0 0 0
Stiffness 0 98102324.133 98102324.1 91562169.191 91562169.191 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
Sum 98102324 189664493 #DIV/0! #DIV/0! #DIV/0!
Factor 1 0 1 0.5172414 0.48275862 1 0 1 0 1 0 1

Fixed End Moments


SPAN 1 SPAN 2 SPAN 3 SPAN 4 SPAN 5 SPAN 6
Min load L R L R L R L R L R L R
Cant 16.4673875 176.109133 177.84338 0 0 0
UDL 2.744565 2.74456458 27.2973556 27.297356 29.6405634 29.6405634 0 0 0 0 0 0
PL 1 0 0 7.74777168 2.0241926 0 0 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
PL 2 0 0 0 0 0 0 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
FEM 0.00 16.47 35.05 29.32 29.64 29.64 0.00 0.00 0.00 0.00 0.00 0.00
Imposed load
Cant 8 99.45 112.5 0 0 0
UDL 1.333333 1.33333333 16.3333333 16.333333 18.75 18.75 0 0 0 0 0 0
PL 1 0 0 0.91150255 0.2381403 0 0 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
PL 2 0 0 0 0 0 0 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
FEM 0.00 8.00 17.24 16.57 18.75 18.75 0.00 0.00 0.00 0.00 0.00 0.00
Live load
Cant 19.386955 229.563653 251.137352 0 0 0
UDL 3.231159 3.23115917 37.0522756 37.052276 41.8562253 41.8562253 0 0 0 0 0 0
PL 1 0 0 4.55751276 1.1907015 0 0 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
PL 2 0 0 0 0 0 0 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
FEM 0.00 19.39 41.61 38.24 41.86 41.86 0.00 0.00 0.00 0.00 0.00 0.00

Moment Distribution
SUPT 1 SUPT 2 SUPT 3 SUPT 4 SUPT 5 SUPT 6 SUPT 7
Min load 0 16.4673875 -35.045127 29.321548 -29.640563 29.6405634 0 0 0 0 0 0
0 0 18.5777397 0.1650079 0.15400734 -29.640563 0 0 0 0 0 0
0 0 0.08250393 9.2888699 -14.820282 0.07700367 0 0 0 0 0 0
0 0 -0.0825039 2.8610751 2.67033674 -0.0770037 0 0 0 0 0 0
0 0 1.43053754 -0.041252 -0.0385018 1.33516837 0 0 0 0 0 0
0 0 -1.4305375 0.041252 0.03850184 -1.3351684 0 0 0 0 0 0
0 0 0.02062598 -0.715269 -0.6675842 0.01925092 0 0 0 0 0 0
0 0 -0.020626 0.7152688 0.66758418 -0.0192509 0 0 0 0 0 0
0 0 0.35763438 -0.010313 -0.0096255 0.33379209 0 0 0 0 0 0
0 0 -0.3576344 0.010313 0.00962546 -0.3337921 0 0 0 0 0 0
0 0 0.0051565 -0.178817 -0.166896 0.00481273 0 0 0 0 0 0
0 0 -0.0051565 0.1788172 0.16689605 -0.0048127 0 0 0 0 0 0
0 0 0.0894086 -0.002578 -0.0024064 0.08344802 0 0 0 0 0 0
0 0 -0.0894086 0.0025782 0.00240636 -0.083448 0 0 0 0 0 0
Sum 0.00 16.47 -16.47 41.64 -41.64 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Project Spreadsheets to BS 8110
Location 3rd Floor slab, from 1 to 5a ANALYSIS II
RIBBED SLABS to BS 8110:1997 (Analysis & Design) Made by rmw Job No R68
Originated from RCC32.xls v2.6 on CD © 2000-2003 BCA for RCC Date 6-Nov-20
Imposed on -17.24 16.57 0.00 0.00 0.00 0.00
Even Spans 0 0 17.2448359 -8.571452 -8.0000218 0 0 0 0 0 0 0
0 0 -4.2857259 8.6224179 0 -4.0000109 0 0 0 0 0 0
0 0 4.28572594 -4.459871 -4.1625466 4.00001088 0 0 0 0 0 0
0 0 -2.2299357 2.142863 2.00000544 -2.0812733 0 0 0 0 0 0
0 0 2.22993567 -2.142863 -2.0000054 2.0812733 0 0 0 0 0 0
0 0 -1.0714315 1.1149678 1.04063665 -1.0000027 0 0 0 0 0 0
0 0 1.07143149 -1.114968 -1.0406366 1.00000272 0 0 0 0 0 0
0 0 -0.5574839 0.5357157 0.50000136 -0.5203183 0 0 0 0 0 0
0 0 0.55748392 -0.535716 -0.5000014 0.52031832 0 0 0 0 0 0
0 0 -0.2678579 0.278742 0.26015916 -0.2500007 0 0 0 0 0 0
0 0 0.26785787 -0.278742 -0.2601592 0.25000068 0 0 0 0 0 0
0 0 -0.139371 0.1339289 0.12500034 -0.1300796 0 0 0 0 0 0
0 0 0.13937098 -0.133929 -0.1250003 0.13007958 0 0 0 0 0 0
Sum 0.00 0.00 0.00 12.16 -12.16 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Imposed on 0.00 8.00 -18.75 18.75 0.00 0.00
Odd Spans 0 0 -8 9.6982759 9.05172414 -18.75 0 0 0 0 0 0
0 0 4.84913793 -4 -9.375 4.52586207 0 0 0 0 0 0
0 0 -4.8491379 6.9181034 6.45689655 -4.5258621 0 0 0 0 0 0
0 0 3.45905172 -2.424569 -2.262931 3.22844828 0 0 0 0 0 0
0 0 -3.4590517 2.424569 2.26293103 -3.2284483 0 0 0 0 0 0
0 0 1.21228448 -1.729526 -1.6142241 1.13146552 0 0 0 0 0 0
0 0 -1.2122845 1.7295259 1.61422414 -1.1314655 0 0 0 0 0 0
0 0 0.86476293 -0.606142 -0.5657328 0.80711207 0 0 0 0 0 0
0 0 -0.8647629 0.6061422 0.56573276 -0.8071121 0 0 0 0 0 0
0 0 0.30307112 -0.432381 -0.403556 0.28286638 0 0 0 0 0 0
0 0 -0.3030711 0.4323815 0.40355603 -0.2828664 0 0 0 0 0 0
0 0 0.21619073 -0.151536 -0.1414332 0.20177802 0 0 0 0 0 0
0 0 -0.2161907 0.1515356 0.14143319 -0.201778 0 0 0 0 0 0
Sum 0.00 8.00 -8.00 12.62 -12.62 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Live on 0 19.386955 -41.856225 41.8562253 0 0
Odd Spans 0 0 -19.386955 21.649772 20.2064536 -41.856225 0 0 0 0 0 0
0 0 10.8248859 -9.693478 -20.928113 10.1032268 0 0 0 0 0 0
0 0 -10.824886 15.838754 14.7828366 -10.103227 0 0 0 0 0 0
0 0 7.91937677 -5.412443 -5.0516134 7.39141832 0 0 0 0 0 0
0 0 -7.9193768 5.4124429 5.0516134 -7.3914183 0 0 0 0 0 0
0 0 2.70622147 -3.959688 -3.6957092 2.5258067 0 0 0 0 0 0
0 0 -2.7062215 3.9596884 3.69570916 -2.5258067 0 0 0 0 0 0
0 0 1.97984419 -1.353111 -1.2629034 1.84785458 0 0 0 0 0 0
0 0 -1.9798442 1.3531107 1.26290335 -1.8478546 0 0 0 0 0 0
0 0 0.67655537 -0.989922 -0.9239273 0.63145168 0 0 0 0 0 0
0 0 -0.6765554 0.9899221 0.92392729 -0.6314517 0 0 0 0 0 0
0 0 0.49496105 -0.338278 -0.3157258 0.46196364 0 0 0 0 0 0
0 0 -0.494961 0.3382777 0.31572584 -0.4619636 0 0 0 0 0 0
Sum 0.00 19.39 -19.39 27.80 -27.80 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Live on -41.609788 38.242977 0 0 0 0
Even Spans 0 0 41.6097883 -19.78085 -18.462127 0 0 0 0 0 0 0
0 0 -9.8904251 20.804894 0 -9.2310634 0 0 0 0 0 0
0 0 9.89042511 -10.76115 -10.043742 9.23106343 0 0 0 0 0 0
0 0 -5.3805761 4.9452126 4.61553172 -5.021871 0 0 0 0 0 0
0 0 5.38057607 -4.945213 -4.6155317 5.021871 0 0 0 0 0 0
0 0 -2.4726063 2.690288 2.5109355 -2.3077659 0 0 0 0 0 0
0 0 2.47260628 -2.690288 -2.5109355 2.30776586 0 0 0 0 0 0
0 0 -1.345144 1.2363031 1.15388293 -1.2554678 0 0 0 0 0 0
0 0 1.34514402 -1.236303 -1.1538829 1.25546775 0 0 0 0 0 0
0 0 -0.6181516 0.672572 0.62773388 -0.5769415 0 0 0 0 0 0
0 0 0.61815157 -0.672572 -0.6277339 0.57694146 0 0 0 0 0 0
0 0 -0.336286 0.3090758 0.28847073 -0.3138669 0 0 0 0 0 0
0 0 0.336286 -0.309076 -0.2884707 0.31386694 0 0 0 0 0 0
Sum 0.00 0.00 0.00 28.51 -28.51 0.00 0.00 0.00 0.00 0.00 0.00 0.00

Elastic Support Moments (3.2.1.2.2)


Support 1 2 3 4 5 6 7
All spans 0 35.8543425 97.9374176 0 0 0 0
Odd Spans 0 35.8543425 69.4315487 0 0 0 0
Even Spans 0 16.4673875 70.1423698 0 0 0 0
Reverse 0 0 0 0 0 0 0
Redistribution (3.2.2.1) method 1
ßb - 1 1 0.85 1 1 1 1
ßb + 1 1 1.15 1 1 1 1
Max M 0 35.8543425 83.246805 0 0 0 0
Dead only 0 16.4673875 41.636501 0 0 0 0
All spans 0 35.8543425 83.246805 0 0 0 0
Odd Spans 0 35.8543425 79.8462811 0 0 0 0
Even Spans 0 16.4673875 80.6637253 0 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 16.46739 0 0 46.795467 8.5 0 47.4249014 0 0
All spans 35.85434 0 0 110.31365 13.5 0 114.394862 0 0
Odd Spans 35.85434 0 0 46.795467 8.5 0 114.394862 0 0
Even Spans 16.46739 0 0 110.31365 13.5 0 47.4249014 0 0
Imposed 8 0 0 28 1 0 30 0 0
Span 4 5 6
Dead only 0 0 0 0 0 0 0 0 0
All spans 0 0 0 0 0 0 0 0 0
Odd Spans 0 0 0 0 0 0 0 0 0
Even Spans 0 0 0 0 0 0 0 0 0
Imposed 0 0 0 0 0 0 0 0 0
Elastic Shears
Span 1 2 3
All spans 0 35.8543425 56.991387 66.822266 70.2557533 44.1391086
Odd Spans 0 35.8543425 25.340275 29.9551914 66.4549708 47.9398911
Even Spans 0 16.4673875 58.192543 65.6211099 33.0647667 14.3601347
Imposed all 0.00 8.00 12.40 16.60 18.30 11.70
Imposed odd 0.00 8.00 -0.66 0.66 16.68 13.32
Imposed even 0.00 0.00 13.06 15.94 1.62 -1.62
Span 4 5 6
All spans 0 0 0 0 0 0
Odd Spans 0 0 0 0 0 0
Even Spans 0 0 0 0 0 0
Imposed all 0.00 0.00 0.00 0.00 0.00 0.00
Imposed odd 0.00 0.00 0.00 0.00 0.00 0.00
Imposed even 0.00 0.00 0.00 0.00 0.00 0.00
Project Spreadsheets to BS 8110
Location 3rd Floor slab, from 1 to 5a ANALYSIS III
RIBBED SLABS to BS 8110:1997 (Analysis & Design) Made by rmw Job No R68
Originated from RCC32.xls v2.6 on CD © 2000-2003 BCA for RCC Date 6-Nov-20
Redistributed Shears
Span 1 2 3
Dead only 0 16.4673875 26.541431 28.7540353 29.2639842 18.1609172
All spans 0 35.8543425 59.090046 64.723607 68.297005 46.097857
Odd Spans 0 35.8543425 23.852456 31.4430103 67.8436018 46.5512602
Even Spans 0 16.4673875 56.689493 67.1241606 34.4676141 12.9572873
Span 4 5 6
Dead only 0 0 0 0 0 0
All spans 0 0 0 0 0 0
Odd Spans 0 0 0 0 0 0
Even Spans 0 0 0 0 0 0

Imposed Reactions
Support 1 2 3 4 5 6 7
All spans 0.00 20.40 34.91 11.70 0.00 0.00 0.00
Odd Spans 0.00 7.34 17.34 13.32 0.00 0.00 0.00
Even Spans 0.00 13.06 17.57 -1.62 0.00 0.00 0.00

SPAN MOMENTS
SPAN 1 Left < > PL1 < > PL2 < > Right
Elastic V All 0 35.8543425
Odd 0 35.8543425
Even 0 Loadings 16.4673875
Redist V All 0 17.927171 0 0 35.8543425
Odd 0 17.927171 0 0 35.8543425
Even 0 8.2336938 0 0 16.4673875
Elastic X- All 0 0 0 0 0
Odd 0 0 0 0 0
Even 0 0 0 0 0
Redist X- All 0 0 0 0 0
Odd 0 0 0 0 0 (3.2.2.1b)
Even 0 0 0 0 0 Max
Elastic M All 0 0 0 0 0.00 0.00 35.8543425 0
Odd 0 0 0 0 0.00 0.00 35.8543425 0
Even 0 0 0 0 0.00 0.00 16.4673875 0 ßb
Redist M All 0 0 0 0 0.00 0.00 35.8543425 0 0
Odd 0 0 0 0 0.00 0.00 35.8543425 0 0
Even 0 0 0 0 0.00 0.00 16.4673875 0 0

SPAN 2 Left < > PL1 < > PL2 < > Right
Elastic V All 56.9913874 66.822266
Odd 25.3402753 29.9551914
Even 58.1925435 Loadings 65.6211099
Redist V All 59.0900463 15.759093 13.5 0 64.723607
Odd 23.8524564 6.6850667 8.5 0 31.4430103
Even 56.6894927 15.759093 13.5 0 67.1241606
Elastic X- All 3.61641283 1.45 2.75976457 0 2.75976457
Odd 3.7905793 1.45 2.51908861 0 2.51908861
Even 3.69263271 1.45 2.83598444 0 2.83598444
Redist X- All 3.74958413 1.45 2.89293587 0 2.89293587
Odd 3.56802072 1.45 2.29653004 0 2.29653004 (3.2.2.1b)
Even 3.59725598 1.45 2.74060771 0 2.74060771 Max
Elastic M All 35.8543425 0 30.216422 43.7336524 0.00 43.73 97.9374176 43.7336524
Odd 35.8543425 0 -6.13862 -2.3182697 0.00 -2.32 69.4315487 0
Even 16.4673875 0 51.345054 66.4812914 0.00 66.48 70.1423698 66.4812914 ßb
Redist M All 35.8543425 0 33.259478 49.6651975 0.00 49.67 83.246805 49.6651975 1.13562885
Odd 35.8543425 0 -8.295957 -5.9006539 0.00 -5.90 79.8462811 0 0
Even 16.4673875 0 49.16563 62.2903408 0.00 62.29 80.6637253 62.2903408 0.93696045
Project Spreadsheets to BS 8110
Location 3rd Floor slab, from 1 to 5a ANALYSIS IV
RIBBED SLABS to BS 8110:1997 (Analysis & Design) Made by rmw Job No R68
Originated from RCC32.xls v2.6 on CD © 2000-2003 BCA for RCC Date 6-Nov-20

SPAN 3 Left < > PL1 < > PL2 < > Right
Elastic V All 70.2557533 44.1391086
Odd 66.4549708 47.9398911
Even 33.0647667 Loadings 14.3601347
Redist V All 68.297005 15.252648 0 0 46.097857
Odd 67.8436018 15.252648 0 0 46.5512602
Even 34.4676141 6.3233202 0 0 12.9572873
Elastic X- All 4.60613476 0 4.60613476 0 4.60613476
Odd 4.35694639 0 4.35694639 0 4.35694639
Even 5.22901984 0 5.22901984 0 5.22901984
Redist X- All 4.47771455 0 4.47771455 0 4.47771455
Odd 4.44798835 0 4.44798835 0 4.44798835 (3.2.2.1b)
Even 5.45087281 0 5.45087281 0 5.45087281 Max
Elastic M All 97.9374176 0 -97.93742 63.8663161 0.00 63.87 0 63.8663161
Odd 69.4315487 0 -69.43155 75.3388239 0.00 75.34 0 75.3388239
Even 70.1423698 0 -70.14237 16.3057905 0.00 16.31 0 16.3057905 ßb
Redist M All 83.246805 0 -83.2468 69.6604413 0.00 69.66 0 69.6604413 1.09072271
Odd 79.8462811 0 -79.84628 71.0374942 0.00 71.04 0 71.0374942 0.94290686
Even 80.6637253 0 -80.66373 13.2755649 0.00 13.28 0 13.2755649 0.8141626

SPAN 4 Left < > PL1 < > PL2 < > Right
Elastic V All 0 0
Odd 0 0
Even 0 Loadings 0
Redist V All 0 0 0 0 0
Odd 0 0 0 0 0
Even 0 0 0 0 0
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 #DIV/0! 0 #DIV/0! 0.00 #DIV/0! 0 #DIV/0!
Odd 0 #DIV/0! 0 #DIV/0! 0.00 #DIV/0! 0 #DIV/0!
Even 0 #DIV/0! 0 #DIV/0! 0.00 #DIV/0! 0 #DIV/0! ßb
Redist M All 0 #DIV/0! 0 #DIV/0! 0.00 #DIV/0! 0 #DIV/0! #DIV/0!
Odd 0 #DIV/0! 0 #DIV/0! 0.00 #DIV/0! 0 #DIV/0! #DIV/0!
Even 0 #DIV/0! 0 #DIV/0! 0.00 #DIV/0! 0 #DIV/0! #DIV/0!

SPAN 5 Left < > PL1 < > PL2 < > Right
Elastic V All 0 0
Odd 0 0
Even 0 Loadings 0
Redist V All 0 0 0 0 0
Odd 0 0 0 0 0
Even 0 0 0 0 0
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 #DIV/0! 0 #DIV/0! 0.00 #DIV/0! 0 #DIV/0!
Odd 0 #DIV/0! 0 #DIV/0! 0.00 #DIV/0! 0 #DIV/0!
Even 0 #DIV/0! 0 #DIV/0! 0.00 #DIV/0! 0 #DIV/0! ßb
Redist M All 0 #DIV/0! 0 #DIV/0! 0.00 #DIV/0! 0 #DIV/0! #DIV/0!
Odd 0 #DIV/0! 0 #DIV/0! 0.00 #DIV/0! 0 #DIV/0! #DIV/0!
Even 0 #DIV/0! 0 #DIV/0! 0.00 #DIV/0! 0 #DIV/0! #DIV/0!
Project Spreadsheets to BS 8110
Location 3rd Floor slab, from 1 to 5a ANALYSIS V
RIBBED SLABS to BS 8110:1997 (Analysis & Design) Made by rmw Job No R68
Originated from RCC32.xls v2.6 on CD © 2000-2003 BCA for RCC Date 6-Nov-20

SPAN 6 Left < > PL1 < > PL2 < > Right
Elastic V All 0 0
Odd 0 0
Even 0 Loadings 0
Redist V All 0 0 0 0 0
Odd 0 0 0 0 0
Even 0 0 0 0 0
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 #DIV/0! 0 #DIV/0! 0.00 #DIV/0! 0 #DIV/0!
Odd 0 #DIV/0! 0 #DIV/0! 0.00 #DIV/0! 0 #DIV/0!
Even 0 #DIV/0! 0 #DIV/0! 0.00 #DIV/0! 0 #DIV/0! ßb
Redist M All 0 #DIV/0! 0 #DIV/0! 0.00 #DIV/0! 0 #DIV/0! #DIV/0!
Odd 0 #DIV/0! 0 #DIV/0! 0.00 #DIV/0! 0 #DIV/0! #DIV/0!
Even 0 #DIV/0! 0 #DIV/0! 0.00 #DIV/0! 0 #DIV/0! #DIV/0!
UDLs at solid (for shear)
1 2 3 4 5 6
UDL 15.486 15.486 15.486 0 0 0
PL left 0 0 0 0 0 0
PL right 0 0 0 0 0 0
Project Spreadsheets to BS 8110
Location 3rd Floor slab, from 1 to 5a CALCS I
RIBBED SLABS to BS 8110:1997 (Analysis & Design) Made by rmw Job No R68
Originated from RCC32.xls v2.6 on CD © 2000-2003 BCA for RCC Date 6-Nov-20

REINFORCEMENT DESIGN SPAN 1 L= 2.000 h = 275


bw = 167.5 BS8110
MAIN STEEL LEFT SPAN RIGHT Ref
ßb 1.000 1.000 1.000
M/m kNm/m 0.00 0.00 35.85
M/rib kNm 0.00 0.00 32.27 -=-
d mm 243.0 239.0 239.0
bf mm 900 900 900
K' 0.1558 0.1558 0.1558 3.4.4.4
Web Mres kNm 48.29 46.71 46.71 Fig 3.3
Flange Mres kNm 289.75 265.92 280.29 -=-
K 0.0000 0.0000 0.0179 3.4.4.4
z mm 230.85 227.05 227.05 -=-
x mm 27.00 26.56 26.56 -=-
d' mm 34.0 34.0 34.0
net fsc N/mm² 0.0 0.0 0.0 Fig 3.3
Excess M kNm 0.00 0.00 0.00
As' req mm² 0 0 0
fst N/mm² 438.1 438.1 438.1 Fig 3.3
As req mm² 0 0 324
bw/b 0.19
Min % % 0.13% 0.18% 0.13% Table 3.25
Min As mm² 322 83 322
At Edge of Solid dmid = 239.0 d'mid = 36.0
M/m kNm/m 1.82 20.17 7.26
M/rib kNm 1.63 18.15 6.53
bf mm 150 150 150
K 0.0053 0.0605 0.0218 3.4.4.4
z mm 230.85 221.67 227.05 -=-
x mm 27.00 38.51 26.56 -=-
net fsc N/mm² 0.0 45.6 0.0 Fig 3.3
Excess M kNm 0.00 0.00 0.00
As' req mm² 0 0 0
fst N/mm² 438.1 438.1 438.1 Fig 3.3
As req mm² 16 187 66
TENSION STEEL
As deflection mm² 0 0 324
As to provide mm² 120 187 120
Ø in rib mm ok 12 ok 20 ok 20
No 2 1 2
As prov mm² 226 314 628
=% % ok 0.556 ok 0.785 ok 1.570
Clear dist mm 122.6 25.0 105.8 between bars
Min S mm ok 25.0 ok 25.0 ok 25.0 3.12.11.1
Max S mm ok 152.2 ok 300.0 ok 152.2 3.12.11.2.4
Residual
Min % 0.26% 0.26%
As resid mm² 96 0
Ø extra mm 8 8
No 4 4
As prov mm² 201 201
COMPRESSION STEEL 0.00 0.00
Required mm² 157 187 126 Table 3.25
Ø mm ok 16 ok 16 ok 16
No 1 1 1
As' prov mm² 201 201 201
=% % ok 0.494 ok 0.502 ok 0.502 3.12.6.1
Clear dist mm 0.0 0.0 0.0 between bars
Min S mm ok 0.0 ok 0.0 ok 0.0 3.12.11.1
Project Spreadsheets to BS 8110
Location 3rd Floor slab, from 1 to 5a CALCS II
RIBBED SLABS to BS 8110:1997 (Analysis & Design) Made by rmw Job No R68
Originated from RCC32.xls v2.6 on CD © 2000-2003 BCA for RCC Date 6-Nov-20
SPAN 1 cont

DEFLECTION
fs N/mm² 0.0 0.0 120.0 Eqn 8
Base ratio 20.80 7.00 3.4.6.3/4
Tens Mod 2.00 2.00 Table 3.10
Comp Mod 1.03 1.00 Table 3.11
Perm L/d 0.00 14.00 3.4.6.3
Actual L/d ok 0.00 ok 8.37 3.4.5.1
As req increased by % 0.00 0.00

RIB SHEAR
V cl kN/m 0.00 35.85
distance from cl m 0.450 1.100 3.4.5.10
V rib kN 0.00 16.94
v N/mm² 0.0000 0.4231 Eqn 3
vc (no links) N/mm² 0.6584 0.9345
vc N/mm² 0.6584 NOMINAL 0.9345 Table 3.8
(v-vc)bv N/mm 67.0 0.0 67.0 Table 3.7
Link Ø mm 6 6 6 3.12.7.1
@ mm 175 1200 175 Spacing
for mm 0 0 0 from solid
As Dist mm ok 0 3.4.5.5
As' Dist mm ok 0.0 ok 0.0 ok 0.0 3.12.7.2

REINFORCEMENT DESIGN SPAN 2 L= 7.000 h = 275


- bw = 167.5
MAIN STEEL LEFT SPAN RIGHT
ßb 1.000 0.937 0.850
M/m kNm/m 35.85 62.29 83.25
M/rib kNm 32.27 56.06 74.92 -=-
d mm 239.0 236.5 239.0
bf mm 900 900 900
K' 0.1558 0.1558 0.1445 3.4.4.4
Web Mres kNm 46.71 42.42 43.32 Fig 3.3
Flange Mres kNm 280.29 262.41 259.91 -=-
K 0.0179 0.0318 0.0416 3.4.4.4
z mm 227.05 224.68 227.05 -=-
x mm 26.56 26.28 26.56 -=-
d' mm 34.0 32.0 34.0
net fsc N/mm² 0.0 0.0 0.0 Fig 3.3
Excess M kNm 0.00 0.00 0.00
As' req mm² 0 0 0
fst N/mm² 438.1 438.1 438.1 Fig 3.3
As req mm² 324 570 753
bw/b 0.19
Min % % 0.13% 0.18% 0.13% Table 3.25
Min As mm² 322 83 322
At Edge of Solid dmid = 236.5 d'mid = 38.5
M/m kNm/m 13.66 35.06 49.30
M/rib kNm 12.29 31.55 44.37
bf mm 150 150 150
K 0.0410 0.1074 0.1480 3.4.4.4
z mm 227.05 203.72 191.00 -=-
x mm 26.56 72.84 106.67 -=-
net fsc N/mm² 0.0 314.4 422.5 Fig 3.3
Excess M kNm 0.00 0.00 1.05
As' req mm² 0 0 12
fst N/mm² 438.1 438.1 438.1 Fig 3.3
As req mm² 124 354 494
Project Spreadsheets to BS 8110
Location 3rd Floor slab, from 1 to 5a CALCS III
RIBBED SLABS to BS 8110:1997 (Analysis & Design) Made by rmw Job No R68
Originated from RCC32.xls v2.6 on CD © 2000-2003 BCA for RCC Date 6-Nov-20
SPAN 2 cont

TENSION STEEL
As deflection mm² 324 649 753
As to provide mm² 124 649 494
Ø in rib mm ok 20 ok 25 ok 20
No 2 2 2
As prov mm² 628 982 628
=% % ok 1.570 ok 2.478 ok 1.570
Clear dist mm 105.8 55.7 105.8 between bars
Min S mm ok 25.0 ok 25.0 ok 25.0 3.12.11.1
Max S mm ok 152.2 ok 247.5 ok 152.2 3.12.11.2.4
Residual
Min % 0.26% 0.26%
As resid mm² 0 125
Ø extra mm 8 8
No 4 4
As prov mm² 201 201
COMPRESSION STEEL 0.00 0.00
Required mm² 393 354 393 Table 3.25
Ø mm ok 16 ok 12 ok 16
No 2 4 2
As' prov mm² 402 452 402
=% % ok 1.004 ok 1.142 ok 1.004 3.12.6.1
Clear dist mm 72.8 32.9 72.8 between bars
Min S mm ok 25.0 ok 25.0 ok 25.0 3.12.11.1
DEFLECTION
fs N/mm² 120.0 189.9 327.7 Eqn 8
Base ratio 7.00 20.80 3.4.6.3/4
Tens Mod 2.00 1.74 Table 3.10
Comp Mod 1.00 1.07 Table 3.11
Perm L/d - 0.00 38.55 3.4.6.3
Actual L/d ok 0.00 ok 29.60 3.4.5.1
As req increased by % 0.00 0.14

RIB SHEAR
V cl kN/m 59.09 67.12
distance from c/L m 1.100 1.100 3.4.5.10
V rib kN 37.85 45.08
v N/mm² 0.9455 1.1261 Eqn 3
vc (no links) N/mm² 0.9345 0.9345
vc N/mm² 0.9345 NOMINAL 0.9345 Table 3.8
(v-vc)bv N/mm 67.0 0.0 67.0 Table 3.7
Link Ø mm 6 6 6 3.12.7.1
@ mm 175 1200 175 Spacing
for mm 175 2400 525 from solid
As Dist mm ok 0 3.4.5.5
As' Dist mm ok 0.0 ok 44.9 ok 0.0 3.12.7.2
Project Spreadsheets to BS 8110
Location 3rd Floor slab, from 1 to 5a CALCS IV
RIBBED SLABS to BS 8110:1997 (Analysis & Design) Made by rmw Job No R68
Originated from RCC32.xls v2.6 on CD © 2000-2003 BCA for RCC Date 6-Nov-20

REINFORCEMENT DESIGN SPAN 3 L= 7.500 h = 275


- bw = 167.5 BS8110
MAIN STEEL LEFT SPAN RIGHT Ref
ßb 0.850 0.943 1.000
M/m kNm/m 83.25 71.04 0.00
M/rib kNm 74.92 63.93 0.00 -=-
d mm 239.0 236.5 239.0
bf mm 900 900 900
K' 0.1445 0.1558 0.1558 3.4.4.4
Web Mres kNm 43.32 42.42 46.71 Fig 3.3
Flange Mres kNm 259.91 262.41 280.29 -=-
K 0.0416 0.0363 0.0000 3.4.4.4
z mm 227.05 224.68 227.05 -=-
x mm 26.56 26.28 26.56 -=-
d' mm 34.0 32.0 34.0
net fsc N/mm² 0.0 0.0 0.0 Fig 3.3
Excess M kNm 0.00 0.00 0.00
As' req mm² 0 0 0
fst N/mm² 438.1 438.1 438.1 Fig 3.3
As req mm² 753 650 0
bw/b 0.19
Min % % 0.13% 0.18% 0.13% Table 3.25
Min As mm² 322 83 322
At Edge of Solid dmid = 236.5 d'mid = 38.5
M/m kNm/m 46.57 27.15 0.00
M/rib kNm 41.92 24.44 0.00
bf mm 150 150 150
K 0.1398 0.0832 0.0000 3.4.4.4
z mm 193.04 212.12 227.05 -=-
x mm 102.12 54.18 26.56 -=-
net fsc N/mm² 422.5 187.0 0.0 Fig 3.3
Excess M kNm 0.00 0.00 0.00
As' req mm² 0 0 0
fst N/mm² 438.1 438.1 438.1 Fig 3.3
As req mm² 467 263 0
TENSION STEEL
As deflection mm² 753 872 0
As to provide mm² 467 872 120
Ø in rib mm ok 20 ok 25 ok 20
No 2 2 2
As prov mm² 628 982 628
=% % ok 1.570 ok 2.478 ok 1.570
Clear dist mm 105.8 55.7 105.8 between bars
Min S mm ok 25.0 ok 25.0 ok 25.0 3.12.11.1
Max S mm ok 152.2 ok 218.4 ok 152.2 3.12.11.2.4
Residual
Min % 0.26% 0.26%
As resid mm² 125 0
Ø extra mm 8 8
No 4 4
As prov mm² 201 201
COMPRESSION STEEL 0.00 0.00
Required mm² 393 263 491 Table 3.25
Ø mm ok 16 ok 12 ok 16
No 2 3 3
As' prov mm² 402 339 603
=% % ok 1.004 ok 0.857 ok 1.507 3.12.6.1
Clear dist mm 72.8 55.3 28.4 between bars
Min S mm ok 25.0 ok 25.0 ok 25.0 3.12.11.1
Project Spreadsheets to BS 8110
Location 3rd Floor slab, from 1 to 5a CALCS V
RIBBED SLABS to BS 8110:1997 (Analysis & Design) Made by rmw Job No R68
Originated from RCC32.xls v2.6 on CD © 2000-2003 BCA for RCC Date 6-Nov-20
SPAN 3 cont

DEFLECTION
fs N/mm² 327.7 215.2 1.0 Eqn 8
Base ratio 7.00 20.80 3.4.6.3/4
Tens Mod 1.08 1.56 Table 3.10
Comp Mod 1.00 1.05 Table 3.11
Perm L/d - 0.00 33.99 3.4.6.3
Actual L/d ok 0.00 ok 31.71 3.4.5.1
As req increased by % 0.00 0.34

RIB SHEAR
V cl kN/m 68.30 46.55
distance from c/L m 1.100 0.450 3.4.5.10
V rib kN 46.14 35.62
v N/mm² 1.1525 0.8899 Eqn 3
vc (no links) N/mm² 0.9345 0.9345
vc N/mm² 0.9345 NOMINAL 0.9345 Table 3.8
(v-vc)bv N/mm 67.0 0.0 67.0 Table 3.7
Link Ø mm 6 6 6 3.12.7.1
@ mm 175 1200 175 Spacing
for mm 700 3600 0 from solid
As Dist mm ok 0 3.4.5.5
As' Dist mm ok 0.0 ok 67.3 ok 44.4 3.12.7.2

REINFORCEMENT DESIGN SPAN 4 L= 0.000 h=0


- No Span 4 - bw = 140
MAIN STEEL LEFT SPAN RIGHT
ßb 1.000 #VALUE! ~
M/m kNm/m 0.00 ~ ~
M/rib kNm 0.00 #VALUE! #VALUE! -=-
d mm -36.0 -36.0 -36.0
bf mm 900 900 900
K' 0.1558 #VALUE! 0.1558 3.4.4.4
Web Mres kNm 1.06 1.06 1.06 Fig 3.3
Flange Mres kNm 6.36 #VALUE! 6.36 -=-
K 0.0000 #VALUE! #VALUE! 3.4.4.4
z mm -34.20 #VALUE! #VALUE! -=-
x mm -4.00 #VALUE! #VALUE! -=-
d' mm 34.0 34.0 34.0
net fsc N/mm² 438.1 #VALUE! #VALUE! Fig 3.3
Excess M kNm 0.00 #VALUE! #VALUE!
As' req mm² 0 #VALUE! #VALUE!
fst N/mm² 438.1 #VALUE! #VALUE! Fig 3.3
As req mm² 0 #VALUE! #VALUE!
bw/b 0.16
Min % % 0.13% 0.18% 0.13% Table 3.25
Min As mm² 0 0 0
At Edge of Solid dmid = -36.0 d'mid = 36.0
M/m kNm/m 0.00 0.00 0.00
M/rib kNm 0.00 0.00 0.00
bf mm 150 150 150
K 0.0000 0.0000 0.0000 3.4.4.4
z mm -34.20 #VALUE! -34.20 -=-
x mm -4.00 #VALUE! -4.00 -=-
net fsc N/mm² 438.1 #VALUE! 438.1 Fig 3.3
Excess M kNm 0.00 0.00 0.00
As' req mm² 0 #VALUE! 0
fst N/mm² 438.1 #VALUE! 438.1 Fig 3.3
As req mm² 0 #VALUE! 0
Project Spreadsheets to BS 8110
Location 3rd Floor slab, from 1 to 5a CALCS VI
RIBBED SLABS to BS 8110:1997 (Analysis & Design) Made by rmw Job No R68
Originated from RCC32.xls v2.6 on CD © 2000-2003 BCA for RCC Date 6-Nov-20
SPAN 4 cont

TENSION STEEL
As deflection mm² 0 #VALUE! #VALUE!
As to provide mm² 0 #VALUE! 0
Ø in rib mm ok 20 ok 20 ok 20
No 2 #VALUE! 2
As prov mm² 628 #VALUE! 628 #DIV/0!
=% % ok -12.467 #VALUE! #VALUE! ok -12.467
Clear dist mm 50.8 #VALUE! 50.8 between bars
Min S mm ok 25.0 #VALUE! 25.0 ok 25.0 3.12.11.1
Max S mm ok 152.2 #VALUE! #VALUE! ok 152.2 3.12.11.2.4
Residual
Min % 0.26% 0.26%
As resid mm² 0 #VALUE!
Ø extra mm 8 #VALUE!
No 4 #VALUE!
As prov mm² 0 #VALUE!
COMPRESSION STEEL 0.00 0.00
Required mm² #VALUE! #VALUE! #VALUE! Table 3.25
Ø mm ok 16 ok 16 ok 16
No #VALUE! #VALUE! #VALUE!
As' prov mm² #VALUE! #VALUE! #VALUE!
=% % #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! 3.12.6.1
Clear dist mm #VALUE! #VALUE! #VALUE! between bars
Min S mm #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! 3.12.11.1
DEFLECTION
fs N/mm² 0.0 #VALUE! #VALUE! Eqn 8
Base ratio 7.00 20.80 3.4.6.3/4
Tens Mod 2.00 #VALUE! Table 3.10
Comp Mod 1.00 #VALUE! Table 3.11
Perm L/d - 0.00 #VALUE! 3.4.6.3
Actual L/d ok 0.00 #VALUE! 0.00 3.4.5.1
As req increased by % 0.00 #VALUE!

RIB SHEAR
V cl kN/m 0.00 0.00
distance from c/L m -0.036 -0.036 3.4.5.10
V rib kN 0.00 0.00
v N/mm² 0.0000 0.0000 Eqn 3
vc (no links) N/mm² #VALUE! #VALUE!
vc N/mm² #VALUE! NOMINAL #VALUE! Table 3.8
(v-vc)bv N/mm #VALUE! 0.0 #VALUE! Table 3.7
Link Ø mm 6 6 6 3.12.7.1
@ mm #VALUE! 1200 #VALUE! Spacing
for mm #VALUE! #VALUE! #VALUE! from solid
As Dist mm #VALUE! #VALUE! 3.4.5.5
As' Dist mm #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! 3.12.7.2
Project Spreadsheets to BS 8110
Location 3rd Floor slab, from 1 to 5a CALCS VII
RIBBED SLABS to BS 8110:1997 (Analysis & Design) Made by rmw Job No R68
Originated from RCC32.xls v2.6 on CD © 2000-2003 BCA for RCC Date 6-Nov-20

REINFORCEMENT DESIGN SPAN 5 L= 0.000 h=0


- No Span 5 - bw = 140 BS8110
MAIN STEEL LEFT SPAN RIGHT Ref
ßb ~ #VALUE! ~
M/m kNm/m ~ ~ ~
M/rib kNm #VALUE! #VALUE! #VALUE! -=-
d mm -36.0 -38.5 -34.0
bf mm 900 900 900
K' 0.1558 #VALUE! 0.1558 3.4.4.4
Web Mres kNm 1.06 1.21 0.95 Fig 3.3
Flange Mres kNm 6.36 #VALUE! 5.67 -=-
K #VALUE! #VALUE! #VALUE! 3.4.4.4
z mm #VALUE! #VALUE! #VALUE! -=-
x mm #VALUE! #VALUE! #VALUE! -=-
d' mm 34.0 32.0 36.0
net fsc N/mm² #VALUE! #VALUE! #VALUE! Fig 3.3
Excess M kNm #VALUE! #VALUE! #VALUE!
As' req mm² #VALUE! #VALUE! #VALUE!
fst N/mm² #VALUE! #VALUE! #VALUE! Fig 3.3
As req mm² #VALUE! #VALUE! #VALUE!
bw/b 0.16
Min % % 0.13% 0.18% 0.13% Table 3.25
Min As mm² 0 0 0
At Edge of Solid dmid = -38.5 d'mid = 38.5
M/m kNm/m 0.00 0.00 0.00
M/rib kNm 0.00 0.00 0.00
bf mm 150 150 150
K 0.0000 0.0000 0.0000 3.4.4.4
z mm -34.20 #VALUE! -32.30 -=-
x mm -4.00 #VALUE! -3.78 -=-
net fsc N/mm² 438.1 #VALUE! 438.1 Fig 3.3
Excess M kNm 0.00 0.00 0.00
As' req mm² 0 #VALUE! 0
fst N/mm² 438.1 #VALUE! 438.1 Fig 3.3
As req mm² 0 #VALUE! 0
TENSION STEEL
As deflection mm² #VALUE! #VALUE! #VALUE!
As to provide mm² 0 #VALUE! 0
Ø in rib mm ok 20 ok 25 ok 16
No 2 #VALUE! 2
As prov mm² 628 #VALUE! 402
=% % ok -12.467 #VALUE! #VALUE! ok -8.448
Clear dist mm 50.8 #VALUE! 59.2 between bars
Min S mm ok 25.0 #VALUE! 25.0 ok 25.0 3.12.11.1
Max S mm ok 152.2 #VALUE! #VALUE! ok 152.2 3.12.11.2.4
Residual
Min % 0.26% 0.26%
As resid mm² #VALUE! #VALUE!
Ø extra mm #VALUE! #VALUE!
No #VALUE! #VALUE!
As prov mm² 0 #VALUE!
COMPRESSION STEEL 0.00 0.00
Required mm² #VALUE! #VALUE! #VALUE! Table 3.25
Ø mm ok 16 ok 12 ok 20
No #VALUE! #VALUE! #VALUE!
As' prov mm² #VALUE! #VALUE! #VALUE!
=% % #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! 3.12.6.1
Clear dist mm #VALUE! #VALUE! #VALUE! between bars
Min S mm #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! 3.12.11.1
Project Spreadsheets to BS 8110
Location 3rd Floor slab, from 1 to 5a CALCS VII
RIBBED SLABS to BS 8110:1997 (Analysis & Design) Made by rmw Job No R68
Originated from RCC32.xls v2.6 on CD © 2000-2003 BCA for RCC Date 6-Nov-20
SPAN 5 cont

DEFLECTION
fs N/mm² #VALUE! #VALUE! #VALUE! Eqn 8
Base ratio 7.00 20.80 3.4.6.3/4
Tens Mod #VALUE! #VALUE! Table 3.10
Comp Mod 1.00 #VALUE! Table 3.11
Perm L/d - 0.00 #VALUE! 3.4.6.3
Actual L/d ok 0.00 #VALUE! 0.00 3.4.5.1
As req increased by % 0.00 #VALUE!

RIB SHEAR
V cl kN/m 0.00 0.00
distance from c/L m -0.036 -0.034 3.4.5.10
V rib kN 0.00 0.00
v N/mm² 0.0000 0.0000 Eqn 3
vc (no links) N/mm² #VALUE! #VALUE!
vc N/mm² #VALUE! NOMINAL #VALUE! Table 3.8
(v-vc)bv N/mm #VALUE! 0.0 #VALUE! Table 3.7
Link Ø mm 6 6 6 3.12.7.1
@ mm #VALUE! 1200 #VALUE! Spacing
for mm #VALUE! #VALUE! #VALUE! from solid
As Dist mm #VALUE! #VALUE! 3.4.5.5
As' Dist mm #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! 3.12.7.2

REINFORCEMENT DESIGN SPAN 6 L= 0.000 h=0


- No Span 6 - bw = 140 BS8110
MAIN STEEL LEFT SPAN RIGHT Ref
ßb ~ #VALUE! ~
M/m kNm/m ~ ~ kNm/m
M/rib kNm #VALUE! #VALUE! #VALUE! -=-
d mm -34.0 -34.0 -32.0
bf mm 900 900 900
K' 0.1558 #VALUE! 0.1558 3.4.4.4
Web Mres kNm 0.95 0.95 0.84 Fig 3.3
Flange Mres kNm 5.67 #VALUE! 5.02 -=-
K #VALUE! #VALUE! #VALUE! 3.4.4.4
z mm #VALUE! #VALUE! #VALUE! -=-
x mm #VALUE! #VALUE! #VALUE! -=-
d' mm 36.0 32.0 34.0
net fsc N/mm² #VALUE! #VALUE! #VALUE! Fig 3.3
Excess M kNm #VALUE! #VALUE! #VALUE!
As' req mm² #VALUE! #VALUE! #VALUE!
fst N/mm² #VALUE! #VALUE! #VALUE! Fig 3.3
As req mm² #VALUE! #VALUE! #VALUE!
bw/b 0.16
Min % % 0.13% 0.18% 0.13% Table 3.25
Min As mm² 0 0 0
At Edge of Solid dmid = -34.0 d'mid = 34.0
M/m kNm/m 0.00 0.00 0.00
M/rib kNm 0.00 0.00 0.00
bf mm 150 150 150
K 0.0000 0.0000 0.0000 3.4.4.4
z mm -32.30 #VALUE! -30.40 -=-
x mm -3.78 #VALUE! -3.56 -=-
net fsc N/mm² 438.1 #VALUE! 438.1 Fig 3.3
Excess M kNm 0.00 0.00 0.00
As' req mm² 0 #VALUE! 0
fst N/mm² 438.1 #VALUE! 438.1 Fig 3.3
As req mm² 0 #VALUE! 0
Project Spreadsheets to BS 8110
Location 3rd Floor slab, from 1 to 5a CALCS IX
RIBBED SLABS to BS 8110:1997 (Analysis & Design) Made by rmw Job No R68
Originated from RCC32.xls v2.6 on CD © 2000-2003 BCA for RCC Date 6-Nov-20
SPAN 6 cont

TENSION STEEL
As deflection mm² #VALUE! #VALUE! #VALUE!
As to provide mm² 0 #VALUE! 0
Ø in rib mm ok 16 ok 16 ok 12
No 2 #VALUE! 2
As prov mm² 402 #VALUE! 226
=% % ok -8.448 #VALUE! #VALUE! ok -5.049
Clear dist mm 59.2 #VALUE! 67.6 between bars
Min S mm ok 25.0 #VALUE! 25.0 ok 25.0 3.12.11.1
Max S mm ok 152.2 #VALUE! #VALUE! ok 152.2 3.12.11.2.4
Residual
Min % 0.26% 0.26%
As resid mm² #VALUE! #VALUE!
Ø extra mm #VALUE! #VALUE!
No #VALUE! #VALUE!
As prov mm² 0 #VALUE!
COMPRESSION STEEL 0.00 0.00
Required mm² #VALUE! #VALUE! #VALUE! Table 3.25
Ø mm ok 20 ok 12 ok 16
No #VALUE! #VALUE! #VALUE!
As' prov mm² #VALUE! #VALUE! #VALUE!
=% % #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! 3.12.6.1
Clear dist mm #VALUE! #VALUE! #VALUE! between bars
Min S mm #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! 3.12.11.1
DEFLECTION
fs N/mm² #VALUE! #VALUE! #VALUE! Eqn 8
Base ratio 7.00 20.80 3.4.6.3/4
Tens Mod #VALUE! #VALUE! Table 3.10
Comp Mod 1.00 #VALUE! Table 3.11
Perm L/d - 0.00 #VALUE! 3.4.6.3
Actual L/d ok 0.00 #VALUE! 0.00 3.4.5.1
As req increased by % 0.00 #VALUE!

RIB SHEAR
V cl kN/m 0.00 0.00
distance from c/L m -0.034 -0.032 3.4.5.10
V rib kN 0.00 0.00
v N/mm² 0.0000 0.0000 Eqn 3
vc (no links) N/mm² #VALUE! #VALUE!
vc N/mm² #VALUE! NOMINAL #VALUE! Table 3.8
(v-vc)bv N/mm #VALUE! 0.0 #VALUE! Table 3.7
Link Ø mm 6 6 6 3.12.7.1
@ mm #VALUE! 1200 #VALUE! Spacing
for mm #VALUE! #VALUE! #VALUE! from solid
As Dist mm #VALUE! #VALUE! 3.4.5.5
As' Dist mm #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! 3.12.7.2
Project Spreadsheets to BS 8110
Location 3rd Floor slab, from 1 to 5a GRAPH DATA I
RIBBED SLABS to BS 8110:1997 (Analysis & Design) Made by rmw Job No R68
Originated from RCC32.xls v2.6 on CD © 2000-2003 BCA for RCC Date 6-Nov-20

LOADING DIAGRAM
Beam 0 16.5 -5.04627
0 0
Supports 0 0 2 2 9 9 16.5 16.5 16.5 16.5 16.5 16.5 16.5 16.5
0 0 -5.04627 0 -5.04627 0 -5.04627 0 -5.04627 0 -5.04627 0 -5.04627 0
UDL's 0 0 2 2 2 9 9 9 16.5 16.5 16.5 16.5 16.5 16.5 16.5 16.5 16.5 16.5 16.5
Dead 0 8.23 8.233694 0 6.69 6.685067 0 6.32 6.32332 0 0.00 0 0 0.00 0 0 0.00 0 0
Imposed 8.233694 12.23 12.23369 8.233694 10.69 10.68507 6.685067 10.32 10.32332 6.32332 0.00 0 0 0.00 0 0 0.00 0 0
PL's 0 0 0 0 3.45 3.45 2 2 9 9 9 9 16.5 16.5 16.5 16.5 16.5 16.5 16.5 16.5 16.5 16.5 16.5 16.5
Dead 12.23369 12.23 12.23369 12.23 10.68507 19.19 10.68507 10.69 10.32332 10.32 10.32332 10.32 0 0.00 0 0.00 0 0.00 0 0.00 0 0.00 0 0.00
Imposed 12.23369 12.23 12.23369 12.23 19.18507 20.19 10.68507 10.69 10.32332 10.32 10.32332 10.32 0 0.00 0 0.00 0 0.00 0 0.00 0 0.00 0 0.00
MOMENT DIAGRAMS
SPAN 1 Edge of solid
X 0 0.1 0.2 0.3 0.4 0.5 0.6 0.7 0.8 0.9 1 1.1 1.2 1.3 1.4 1.5 1.6 1.7 1.8 1.9 2 0.45 0.9
M(e) all 0 0.089636 0.358543 0.806723 1.434174 2.240896 3.226891 4.392157 5.736695 7.260504 8.963586 10.84594 12.90756 15.14846 17.56863 20.16807 22.94678 25.90476 29.04202 32.35854 35.85434 1.815126 7.260504
M(e) odd 0 0.089636 0.358543 0.806723 1.434174 2.240896 3.226891 4.392157 5.736695 7.260504 8.963586 10.84594 12.90756 15.14846 17.56863 20.16807 22.94678 25.90476 29.04202 32.35854 35.85434 1.815126 7.260504
M(e) even 0 0.041168 0.164674 0.370516 0.658696 1.029212 1.482065 2.017255 2.634782 3.334646 4.116847 4.981385 5.92826 6.957471 8.06902 9.262905 10.53913 11.89769 13.33858 14.86182 16.46739 0.833661 3.334646
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.089636 0.358543 0.806723 1.434174 2.240896 3.226891 4.392157 5.736695 7.260504 8.963586 10.84594 12.90756 15.14846 17.56863 20.16807 22.94678 25.90476 29.04202 32.35854 35.85434 1.815126 7.260504
M(r) odd 0 0.089636 0.358543 0.806723 1.434174 2.240896 3.226891 4.392157 5.736695 7.260504 8.963586 10.84594 12.90756 15.14846 17.56863 20.16807 22.94678 25.90476 29.04202 32.35854 35.85434 1.815126 7.260504
M(r) even 0 0.041168 0.164674 0.370516 0.658696 1.029212 1.482065 2.017255 2.634782 3.334646 4.116847 4.981385 5.92826 6.957471 8.06902 9.262905 10.53913 11.89769 13.33858 14.86182 16.46739 0.833661 3.334646
70% max 0 0.062745 0.25098 0.564706 1.003922 1.568627 2.258824 3.07451 4.015686 5.082353 6.27451 7.592157 9.035294 10.60392 12.29804 14.11765 16.06275 18.13333 20.32941 22.65098 25.09804 1.270588 5.082353
70% min 0 0.028818 0.115272 0.259361 0.461087 0.720448 1.037445 1.412078 1.844347 2.334252 2.881793 3.486969 4.149782 4.87023 5.648314 6.484034 7.37739 8.328381 9.337009 10.40327 11.52717 0.583563 2.334252
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.089636 0.358543 0.806723 1.434174 2.240896 3.226891 4.392157 5.736695 7.260504 8.963586 10.84594 12.90756 15.14846 17.56863 20.16807 22.94678 25.90476 29.04202 32.35854 35.85434 1.815126 7.260504
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.35 0.7 1.05 1.4 1.75 2.1 2.45 2.8 3.15 3.5 3.85 4.2 4.55 4.9 5.25 5.6 5.95 6.3 6.65 7 1.1 5.9
X 2 2.35 2.7 3.05 3.4 3.75 4.1 4.45 4.8 5.15 5.5 5.85 6.2 6.55 6.9 7.25 7.6 7.95 8.3 8.65 9
M(e) all 35.85434 16.8726 -0.17865 -15.2994 -28.4897 -35.6995 -40.3038 -42.9776 -43.7209 -42.5337 -39.4161 -34.3679 -27.3893 -18.4802 -7.64054 5.129564 19.83016 36.46124 55.02281 75.51487 97.93742 -17.3019 33.96718
M(e) odd 35.85434 27.39471 19.75399 12.9322 6.929322 4.295369 2.905336 2.334224 2.582033 3.648762 5.534412 8.238983 11.76247 16.10489 21.26622 27.24647 34.04565 41.66374 50.10076 59.35669 69.43155 12.02451 40.5253
M(e) even 16.46739 -2.93476 -20.4064 -35.9476 -49.5583 -57.1885 -62.2132 -65.3074 -66.4711 -65.7043 -63.0071 -58.3793 -51.8211 -43.3324 -32.9132 -20.5635 -6.28327 9.927405 28.06857 48.14023 70.14237 -38.0102 7.4934
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 35.85434 16.13807 -1.64771 -17.503 -31.4278 -39.3721 -44.711 -48.1193 -49.5971 -49.1445 -46.7614 -42.4478 -36.2036 -28.0291 -17.924 -5.8884 8.077667 23.97422 41.80126 61.55879 83.2468 -19.6105 21.58509
M(r) odd 35.85434 27.91544 20.79546 14.49441 9.012269 6.899052 6.029756 5.979381 6.747926 8.335392 10.74178 13.96709 18.01131 22.87446 28.55653 35.05752 42.37743 50.51626 59.47402 69.25069 79.84628 13.66111 49.30344
M(r) even 16.46739 -2.40869 -19.3543 -34.3694 -47.454 -54.5581 -59.0567 -61.6249 -62.2625 -60.9697 -57.7464 -52.5926 -45.5083 -36.4935 -25.5482 -12.6724 2.133812 18.87056 37.53779 58.13551 80.66373 -36.3568 16.3614
70% max 25.09804 19.17629 13.82779 9.052538 4.850526 3.006758 2.033735 1.633957 1.807423 2.554134 3.874089 5.767288 8.233732 11.27342 14.88635 19.07253 23.83195 29.16462 38.51597 52.86041 68.55619 8.417154 28.36771
70% min 11.52717 -2.05433 -14.2845 -25.1633 -34.6908 -40.0319 -43.5492 -45.7152 -46.5298 -45.993 -44.1049 -40.8655 -36.2748 -30.3327 -23.0392 -14.3944 -4.39829 6.949183 19.648 33.69816 48.60208 -26.6071 5.24538
Lower bound 0 -2.40869 -19.3543 -34.3694 -47.454 -54.5581 -59.0567 -61.6249 -62.2625 -60.9697 -57.7464 -52.5926 -45.5083 -36.4935 -25.5482 -14.3944 -4.39829 0 0 0 0
Upper bound 35.85434 27.91544 20.79546 14.49441 9.012269 6.899052 6.029756 5.979381 6.747926 8.335392 10.74178 13.96709 18.01131 22.87446 28.55653 35.05752 42.37743 50.51626 59.47402 69.25069 83.2468 13.66111 49.30344
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.375 0.75 1.125 1.5 1.875 2.25 2.625 3 3.375 3.75 4.125 4.5 4.875 5.25 5.625 6 6.375 6.75 7.125 7.5 1.1 7.05
X 9 9.375 9.75 10.125 10.5 10.875 11.25 11.625 12 12.375 12.75 13.125 13.5 13.875 14.25 14.625 15 15.375 15.75 16.125 16.5
M(e) all 97.93742 72.66396 49.53541 28.55176 9.713017 -6.98082 -21.5298 -33.9338 -44.1929 -52.3072 -58.2765 -62.1009 -63.7804 -63.315 -60.7047 -55.9495 -49.0494 -40.0044 -28.8145 -15.4797 0 29.88394 -18.3183
M(e) odd 69.43155 45.58339 23.88013 4.321773 -13.0917 -28.3602 -41.4839 -52.4626 -61.2964 -67.9854 -72.5294 -74.9285 -75.1828 -73.2921 -69.2565 -63.076 -54.7506 -44.2803 -31.6651 -16.905 0 5.558933 -20.0286
M(e) even 70.14237 58.18769 47.12223 36.94598 27.65896 19.26114 11.75255 5.133171 -0.59699 -5.43793 -9.38966 -12.4522 -14.6255 -15.9095 -16.3044 -15.81 -14.4265 -12.1537 -8.99167 -4.94044 0 37.59674 -5.82182
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 83.2468 58.70788 36.31386 16.06474 -2.03947 -17.9988 -31.8132 -43.4827 -53.0073 -60.387 -65.6218 -68.7117 -69.6567 -68.4567 -65.1119 -59.6222 -51.9876 -42.208 -30.2836 -16.2142 0 17.34795 -19.1997
M(r) odd 79.84628 55.47738 33.25339 13.1743 -4.75989 -20.5492 -34.1936 -45.693 -55.0476 -62.2573 -67.322 -70.2419 -71.0169 -69.6469 -66.1321 -60.4723 -52.6677 -42.7181 -30.6236 -16.3843 0 14.44617 -19.4037
M(r) even 80.66373 68.18298 56.59145 45.88914 36.07604 27.15216 19.1175 11.97205 5.715824 0.348812 -4.12898 -7.71756 -10.4169 -12.2271 -13.148 -13.1797 -12.3222 -10.5755 -7.93953 -4.41437 0 46.57496 -5.19054
70% max 68.55619 50.86477 34.67479 25.86219 19.36127 13.4828 8.226784 3.59322 -0.41789 -3.80655 -6.57276 -8.71652 -10.2378 -11.1367 -11.4131 -11.067 -10.0985 -8.50757 -6.29417 -3.45831 0 26.31771 -4.07528
70% min 48.60208 31.90837 16.71609 3.025241 -9.16417 -19.8522 -29.0387 -36.7238 -42.9075 -47.5898 -50.7706 -52.45 -52.6279 -51.3045 -48.4795 -44.1532 -38.3254 -30.9962 -22.1656 -11.8335 0 3.891253 -14.02
Lower bound 0 0 0 0 -9.16417 -20.5492 -34.1936 -45.693 -55.0476 -62.2573 -67.322 -70.2419 -71.0169 -69.6469 -66.1321 -60.4723 -52.6677 -42.7181 -30.6236 -16.3843 0
Upper bound 83.2468 68.18298 56.59145 45.88914 36.07604 27.15216 19.1175 11.97205 5.715824 0.348812 0 0 0 0 0 0 0 0 0 0 0 46.57496 0
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 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
X 16.5 16.5 16.5 16.5 16.5 16.5 16.5 16.5 16.5 16.5 16.5 16.5 16.5 16.5 16.5 16.5 16.5 16.5 16.5 16.5 16.5
M(e) all 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
M(e) odd 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
M(e) even 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Beam 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
M(r) all 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
M(r) odd 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
M(r) even 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
70% max 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
70% min 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Lower bound 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Upper bound 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Beam 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

498059534.xls 17:03:03 11/06/2020


Project Spreadsheets to BS 8110
Location 3rd Floor slab, from 1 to 5a GRAPH DATA II
RIBBED SLABS to BS 8110:1997 (Analysis & Design) Made by rmw Job No R68
Originated from RCC32.xls v2.6 on CD © 2000-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 0 0
X 16.5 16.5 16.5 16.5 16.5 16.5 16.5 16.5 16.5 16.5 16.5 16.5 16.5 16.5 16.5 16.5 16.5 16.5 16.5 16.5 16.5
M(e) all 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
M(e) odd 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
M(e) even 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Beam 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
M(r) all 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
M(r) odd 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
M(r) even 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
70% max 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
70% min 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Lower bound 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Upper bound 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Beam 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
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 0 0
X 16.5 16.5 16.5 16.5 16.5 16.5 16.5 16.5 16.5 16.5 16.5 16.5 16.5 16.5 16.5 16.5 16.5 16.5 16.5 16.5 16.5
M(e) all 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
M(e) odd 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
M(e) even 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Beam 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
M(r) all 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
M(r) odd 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
M(r) even 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
70% max 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
70% min 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Lower bound 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Upper bound 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Beam 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

SHEAR FORCE DIAGRAMS


SPAN 1 SPAN 2 SPAN 3 SPAN 4 SPAN 5 SPAN 6
Local X 0 0 0 0 0 0 2 0 1.45 1.45 1.45 1.45 7 0 0 0 0 0 7.5 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
X 0 0 0 0 0 0 2 2 3.45 3.45 3.45 3.45 9 9 9 9 9 9 16.5 16.5 16.5 16.5 16.5 16.5 16.5 16.5 16.5 16.5 16.5 16.5 16.5 16.5 16.5 16.5 16.5
V(e) all 0 0 0 0 0 0 -35.8543 56.99139 34.1407 20.6407 20.6407 20.6407 -66.8223 70.25575 70.25575 70.25575 70.25575 70.25575 -44.1391 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
V(e) odd 0 0 0 0 0 0 -35.8543 25.34028 15.64693 7.146929 7.146929 7.146929 -29.9552 66.45497 66.45497 66.45497 66.45497 66.45497 -47.9399 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
V(e) even 0 0 0 0 0 0 -16.4674 58.19254 35.34186 21.84186 21.84186 21.84186 -65.6211 33.06477 33.06477 33.06477 33.06477 33.06477 -14.3601 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
V(r) all 0 0 0 0 0 0 -35.8543 59.09005 36.23936 22.73936 22.73936 22.73936 -64.7236 68.297 68.297 68.297 68.297 68.297 -46.0979 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
V(r) odd 0 0 0 0 0 0 -35.8543 23.85246 14.15911 5.65911 5.65911 5.65911 -31.443 67.8436 67.8436 67.8436 67.8436 67.8436 -46.5513 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
V(r) even 0 0 0 0 0 0 -16.4674 56.68949 33.83881 20.33881 20.33881 20.33881 -67.1242 34.46761 34.46761 34.46761 34.46761 34.46761 -12.9573 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Lower bound 0 0 0 0 0 0 -35.8543 23.85246 14.15911 5.65911 5.65911 5.65911 -67.1242 34.46761 34.46761 34.46761 34.46761 34.46761 -46.5513 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Upper bound 0 0 0 0 0 0 -16.4674 59.09005 36.23936 22.73936 22.73936 22.73936 -31.443 68.297 68.297 68.297 68.297 68.297 -12.9573 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Beam 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

GRIDS 2 2 9 9 16.5 16.5 16.5 16.5 16.5 16.5 16.5 16.5


-75.34 97.93742 -75.3388 97.93742 -75.3388 97.93742 -75.3388 97.93742 -75.3388 97.93742 -75.3388 97.93742

498059534.xls 17:03:04 11/06/2020


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 RCC32 Ribbed Slabs (A & D)

Date Version
6-Dec-04 RCC32 v2.6

3-Nov-03 RCC32 v2.5

18-Aug-03 RCC32 v2.4

26-Jun-03 RCC32 v2.3

21-Jan-03 RCC32 v2.2


1-Dec-02 RCC32 v2.1
11-Oct-02 RCC32 v2.0
8-Apr-02 RCC32 v1.6

5-Apr-02 RCC32 v1.5

5-May-01 RCC32 v1.4

1-Jun-00 RCC32 v1.3

15-Feb-00 RCC32 v1.2

2-Feb-00 RCC32 v1.1

4-Aug-99 RCC32 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.
RCC32 Ribbed Slabs (A & D)

Action Size (kB)


Display and use of reverse support moments and shears. 864

Correction to deflection enhancement for cantilevers in span 3 (Robert Povey). 863

Routine for calculating imposed reactions upgraded. 863

Correction to ANALYSIS cells H179:184 etc (negative values of Xp2 - Xp1) 835

DETR logo replaced by DTI. 834


Correction for cantilever at span 1. 852
Version 2 enhancements 856
Similar correction at BAR!G563. 833
Deflection base ratio bug for spans >10m fixed at Bar!G74, E164 etc (v1.2 fix
833
had reverted).
Warning message corrected in MAIN:L30 etc 762
Compresion steel mod factor now based on bf, and in spans, x limit of hf/0.9
762
checked.

Deflection base ratio bug for spans >10m fixed at Bar!G74, G164 etc. 758

Single span deflection base ratio added 758


First public release.
761
Includes b version comments

You might also like