Spreadsheets To BS 8110: From Grids

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

REINFORCED CONCRETE

Project Spreadsheets to BS 8110 COUNCIL


Client Advisory Group Made by Date Page
Location ECBP Typical Floor from grids A to D rmw 25-Nov-20 49
FLAT SLAB ANALYSIS & DESIGN to BS 8110:1997 Checked Revision Job No

Originated from RCC33.xls on CD © 1999 BCA for RCC chg - R68

MATERIALS fcu 40 N/mm² h agg 20 mm COVERS mm TO LAYER


fyl 460 N/mm² gs 1.05 steel Top cover 25 1
fyv 460 N/mm² gc 1.50 concrete Btm cover 25 1

SPANS L (m) GEOMETRY PERIMETER LOADS characteristic


SPAN 1 7.500 Bay type INTERNAL 8.85 kN/m outside supports 1 & 4
SPAN 2 7.500 Slab depth, h 250 mm
SPAN 3 7.500 Panel width, b 7500 mm LOADING PATTERN
SPAN 4 0 0 min max
SPAN 5 End distance 125 from supt 1 DEAD 1.0 1.4
SPAN 6 End distance 125 from supt 4 IMPOSED 0 1.6
.
SUPPORTS ABOVE (m) H (mm) B (mm) End Cond BELOW (m) H (mm) B (mm) End Cond
Support 1 3.750 250 400 F 3.750 250 400 F
Support 2 3.750 400 400 F 3.750 400 400 F
Support 3 3.750 400 400 F 3.750 400 400 F
Support 4 3.750 250 400 F 3.750 250 400 F
Support 5
Support 6
Support 7

LOADING UDLs (kN/m²) PLs (kN/m) Position (m)


Dead Imposed Position Loaded Dead Imposed Position Loaded
Span 1 Load Load from left Length Span 4 Load Load from left Length
UDL 7.50 3.50 ~~~~~ ~~~~~ UDL ~~~~~ ~~~~~
PL 1 ~~~~~ PL 1 ~~~~~
PL 2 ~~~~~ PL 2 ~~~~~
Part UDL Part UDL
Span 2 Span 5
UDL 7.50 3.50 ~~~~~ ~~~~~ UDL ~~~~~ ~~~~~
PL 1 ~~~~~ PL 1 ~~~~~
PL 2 ~~~~~ PL 2 ~~~~~
Part UDL Part UDL
Span 3 Span 6
UDL 7.50 3.50 ~~~~~ ~~~~~ UDL 0.00 0.00 ~~~~~ ~~~~~
PL 1 ~~~~~ PL 1 ~~~~~
PL 2 ~~~~~ PL 2 ~~~~~
Part UDL Part UDL

LOADING DIAGRAM

A D
REINFORCED CONCRETE
Project Spreadsheets to BS 8110 COUNCIL
Client Advisory Group Made by Date Page
Location ECBP Typical Floor, from grids A to D rmw 25-Nov-20 50
FLAT SLAB ANALYSIS & DESIGN to BS 8110:1997 Checked Revision Job No
Originated from RCC33.xls on CD © 1999 BCA for RCC chg - R68
BENDING MOMENT DIAGRAMS (kNm)
1000 800

800 600
600
400
400
200
200
0
0
-200
-200

-400 -400

-600 -600
0 5 10 15 20 25 0 5 10 15 20 25

Elastic Moments Redistributed Envelope

SUPPORT No 1 2 3 4
Elastic M 128.2 710.4 710.4 128.2 ~ ~ ~
Redistributed M 128.2 568.4 568.4 128.2 ~ ~ ~
ßb 1.000 0.800 0.800 1.000 ~ ~ ~
Redistribution 20.0% 20.0%
End support reinf. Ø mm 16 16
* *
SPAN No 1 2 3
Elastic M 501.02 328.88 501.02 ~ ~ ~
Redistributed M 520.17 280.67 520.17 ~ ~ ~
ßb 1.038 0.853 1.038 ~ ~ ~
SHEARS FORCE DIAGRAMS (kN)
600 600

400 400

200 200

0 0

-200 -200

-400 -400

-600 -600
0 5 10 15 20 25 0 5 10 15 20 25

Elastic Shears Redistributed Shears


SPAN No 1 2 3
Elastic V 389.8 531.7 452.8 452.8 531.7 389.8
Redistributed V 394.1 512.7 452.8 452.8 512.7 394.1

SPAN No
Elastic V ~ ~ ~ ~ ~ ~
Redistributed V ~ ~ ~ ~ ~ ~

REACTIONS (kN)
SUPPORT 1 2 3 4
ALL SPANS LOADED 500.9 965.5 965.5 500.9 0.0 0.0 0.0
ODD SPANS LOADED 502.1 722.4 722.4 502.1 0.0 0.0 0.0
EVEN SPANS LOADED 220.4 727.7 727.7 220.4 0.0 0.0 0.0
Veff for punching 627.7 1059.3 1059.3 627.7 0.0 0.0 0.0
Characteristic Dead 248.0 458.2 458.2 248.0 0.0 0.0 0.0
Characteristic Imposed 96.8 202.5 202.5 96.8 0.0 0.0 0.0

COLUMN MOMENTS (kNm) 1 2 3 4


ALL SPANS Above 53.3 -45.9 45.9 -53.3 0.0 0.0 0.0
LOADED Below 53.3 -45.9 45.9 -53.3 0.0 0.0 0.0
ODD SPANS Above 59.7 -107.1 107.1 -59.7 0.0 0.0 0.0
LOADED Below 59.7 -107.1 107.1 -59.7 0.0 0.0 0.0
EVEN SPANS Above 18.0 40.1 -40.1 -18.0 0.0 0.0 0.0
LOADED Below 18.0 40.1 -40.1 -18.0 0.0 0.0 0.0
Project Spreadsheets to BS 8110 REINFORCED CONCRETE COUNCIL

Client Advisory Group Made by Date Page


Location ECBP Typical Floor, from grids A to D rmw Nov-2020 52
FLAT SLAB ANALYSIS & DESIGN to BS 8110:1997 Checked Revision Job No
Originated from RCC33.xls on CD © 1999 BCA for RCC chg - R68

SPAN 3 LEFT CENTRE RIGHT


ACTIONS ßb 0.800 1.038 1.000
Be 3750 650
Total M kNm 480.2 520.2 79.9
Mt max kNm 1059.5 183.6

MIDDLE STRIP Width mm 3750 3750 6850


M kNm 120.1 234.1 2.3
d mm 217.0 215.0 219.0
As mm²/m 354 698 4
As deflection mm²/m 354 851
Provide T16 @ 550 T1 Provide T20 @ 350 B1 Provide T12 @ 325 T1
As prov mm²/m 366 898 348
Top steel Provide T12 @ 325 T1
Deflection L/d = 7,500 /215.0 = 34.884 < 26.0 x 1.466 x 1.050 x 0.9 = 36.038 OK
(As increased by 21.9 % for deflection)
COLUMN STRIP Width mm 3750 3750 650
M kNm 360.2 286.1 79.9
d mm 217.0 215.0 217.0
As mm²/m 1075 853 1403
As deflection mm²/m 1075 1194
Provide T16 @ 125:250 T1 Provide T20 @ 250 B1 Provide T16 @ 125 T1
As prov mm²/m 1206 1257 1608
Top steel Provide T12 @ 325 T1
Deflection L/d = 7,500 /215.0 = 34.884 < 26.0 x 1.454 x 1.050 x 0.9 = 35.729 OK
(As increased by 40.0 % for deflection)
CHECKS % As ok ok ok
Singly reinforced ok ok ok
max S ok ok ok
Project Spreadsheets to BS 8110 REINFORCED CONCRETE COUNCIL
Client Advisory Group Made by Date Page
Location ECBP Typical Floor, from grids A to D rmw 25-Nov-20 53
FLAT SLAB ANALYSIS & DESIGN to BS 8110:1997 Checked Revision Job No
Originated from RCC33.xls on CD © 1999 BCA for RCC chg - R68

Legend for Input Data


Project Spreadsheets to BS 8110 REINFORCED CONCRETE COUNCIL
Client Advisory Group Made by Date Page
Location ECBP Typical Floor, from grids A to D rmw 25-Nov-20 54
FLAT SLAB ANALYSIS & DESIGN to BS 8110:1997 Checked Revision Job No
Originated from RCC33.xls on CD © 1999 BCA for RCC chg - R68
No
WEIGHT of REINFORCEMENT Mid Strip Col Strip Type Dia Length Unit wt Weight
TOP STEEL Support 1 22 T 12 2350 0.888 45.9
7 T 16 2550 1.578 28.2
Span 1 12 T 12 4950 0.888 52.7
12 T 12 4950 0.888 52.7
Support 2 7 T 16 3750 1.578 41.4
23 T 16 3750 1.578 136.1
Span 2 12 T 12 4950 0.888 52.7
12 T 12 4950 0.888 52.7
Support 3 7 T 16 3750 1.578 41.4
23 T 16 3750 1.578 136.1
Span 3 12 T 12 4950 0.888 52.7
12 T 12 4950 0.888 52.7
Support 4 24 T 12 2350 0.888 50.1
7 T 16 2550 1.578 28.2
0 0 0 0 0 0.000 0.0
0 0 0 0 0.000 0.0
0 0 0 0 0 0.000 0.0
0 0 0 0 0.000 0.0
0 0 0 0 0 0.000 0.0
0 0 0 0 0.000 0.0
0 0 0 0 0 0.000 0.0
0 0 0 0 0.000 0.0
0 0 0 0 0 0.000 0.0
0 0 0 0 0.000 0.0
0 0 0 0 0 0.000 0.0
0 0 0 0 0.000 0.0
BTM STEEL Span 1 11 T 20 6875 2.466 186.5
15 T 20 7750 2.466 286.7
Span 2 9 T 16 6825 1.578 96.9
7 T 20 7650 2.466 132.1
Span 3 11 T 20 6875 2.466 186.5
15 T 20 7750 2.466 286.7
0 0 0 0 0 0.000 0.0
0 0 0 0 0.000 0.0
0 0 0 0 0 0.000 0.0
0 0 0 0 0.000 0.0
0 0 0 0 0 0.000 0.0
0 0 0 0 0.000 0.0

SUMMARY Rebar for single direction only. All figures approximate - see User Guide.
TOTAL REINFORCEMENT IN BAY (kg) 1999 REINFORCEMENT DENSITY (kg/m3) 46.9
ANALYSIS
Min load 1.0 x dead load
Live load 0.4 x dead load + 1.6 x imposed load (Table 2.1)

Distribution Factors
SUPT 1 SUPT 2 SUPT 3
Up col Lo col R L Up col Lo col R L Up col
I 520833333.333 520833333.333 9765625000 9765625000 2133333333.33 2133333333.33 9765625000 9765625000 2133333333.33
Stiffness 138888888.889 138888888.889 1302083333.33 1302083333.33 568888888.889 568888888.889 1302083333.33333 1302083333.33 568888888.889
Sum 1579861111.11 4E+09 4E+09
Factor 0.087912088 0.087912088 0.824175824 0.347969713 0.152030287 0.152030287 0.347969712716 0.347969713 0.152030287
SUPT 4 SUPT 5 SUPT 6
L Up col Lo col R L Up col Lo col R L Up col

I 9765625000 520833333.333 520833333.333 0 0 0 0 0 0 0


Stiffness 1302083333.33 138888888.889 138888888.889 0 0 0 0 0 0 0
Sum 2E+09 0E+00 0E+00
Factor 0.824175824 0.087912088 0.087912088 0 1 0 0 0 1 0
SUPT 7
L Up col Lo col

I 0 0 0 Partial UDL factors


Stiffness 0 0 0 1 2 3 4
Sum 0 a 0 0 0 #DIV/0!
Factor 0 0 0 b 0 0 0 #DIV/0!

Fixed End Moments


LEFT SPAN 1 SPAN 2 SPAN 3 SPAN 4 SPAN 5
Min load EDGE L R L R L R L R L
Cant 210.9375 210.9375 210.9375 0 0
UDL 0.05859375 35.15625 35.15625 35.15625 35.15625 35.15625 35.15625 0 0 0
PL 1 1.10625 0 0 0 0 0 0 #DIV/0! #DIV/0! #DIV/0!
PL 2 0 0 0 0 0 0 #DIV/0! #DIV/0! #DIV/0!
part UDL 0 0 0 0 0 0 #DIV/0! #DIV/0! #DIV/0!
FEM 1.16 35.16 35.16 35.16 35.16 35.16 35.16 0.00 0.00 0.00
Live load
Cant 241.875 241.875 241.875 0 0
UDL 0.0671875 40.3125 40.3125 40.3125 40.3125 40.3125 40.3125 0 0 0
PL 1 0.4425 0 0 0 0 0 0 #DIV/0! #DIV/0! #DIV/0!
PL 2 0 0 0 0 0 0 #DIV/0! #DIV/0! #DIV/0!
part UDL 0 0 0 0 0 0 #DIV/0! #DIV/0! #DIV/0!
FEM 0.51 40.31 40.31 40.31 40.31 40.31 40.31 0.00 0.00 0.00

Moment Distribution
HiCol Edge SUPT 1 LoCol HiCol SUPT 2 LoCol HiCol SUPT 3
Min load 8.736328125 -263.671875 263.671875 -263.671875 263.671875
22.41191621 210.1117145 22.41191621 0 0 0 0 0 0
0 105.0558572 0 0
0 0 0 -15.9716722 -36.5562565 -36.5562565 -15.97167215533 15.97167216 36.55625646
-18.2781282 0 18.27812823 -18.2781282
1.606868416 15.0643914 1.606868416 -2.77882909 -6.36023503 -6.36023503 -2.778829085743 2.778829086 6.360235029
-3.18011751 7.532195699 3.180117515 -3.18011751
0.279570771 2.620975973 0.279570771 -1.62859606 -3.72756055 -3.72756055 -1.62859605532 1.628596055 3.727560551
-1.86378028 1.310487987 1.863780276 -1.86378028
0.163848815 1.536082645 0.163848815 -0.48258492 -1.10454922 -1.10454922 -0.482584915857 0.482584916 1.104549215
-0.55227461 0.768041322 0.552274608 -0.55227461
0.048551614 0.45517138 0.048551614 -0.20072801 -0.45942995 -0.45942995 -0.200728010158 0.20072801 0.459429955
-0.22971498 0.22758569 0.229714977 -0.22971498
0.020194723 0.189325531 0.020194723 -0.06952355 -0.15912678 -0.15912678 -0.069523551844 0.069523552 0.159126782
Sum 24.53 8.74 -57.80 24.53 -21.13 330.20 -287.94 -21.13 21.13 287.94
Live on -302.34375 302.34375
Odd Spans 26.57967033 249.1844093 26.57967033 -45.9654072 -105.206468 -105.206468 -45.96540717096 45.96540717 105.2064678
-52.6032339 124.5922047 52.60323391 -52.6032339
4.624460124 43.35431367 4.624460124 -26.9390734 -61.6586459 -61.6586459 -26.93907343343 26.93907343 61.65864586
-30.8293229 21.67715683 30.82932293 -30.8293229
2.710270148 25.40878263 2.710270148 -7.9825752 -18.2706647 -18.2706647 -7.982575202539 7.982575203 18.27066468
-9.13533234 12.70439132 9.135332339 -9.13533234
0.80310614 7.52912006 0.80310614 -3.32029946 -7.59956237 -7.59956237 -3.320299461686 3.320299462 7.599562367
-3.79978118 3.76456003 3.799781183 -3.79978118
0.334046697 3.131687788 0.334046697 -1.15000897 -2.63216164 -2.63216164 -1.150008967757 1.150008968 2.632161639
-1.31608082 1.565843894 1.316080819 -1.31608082
0.115699413 1.084681994 0.115699413 -0.43813984 -1.00282251 -1.00282251 -0.438139842143 0.438139842 1.002822515
-0.50141126 0.542340997 0.501411257 -0.50141126
0.044080111 0.413251036 0.044080111 -0.15868196 -0.36319417 -0.36319417 -0.158681955082 0.158681955 0.363194172
Sum 35.21 0.00 -70.42 35.21 -85.95 270.46 -98.55 -85.95 85.95 98.55
Project Spreadsheets to BS 8110
Location ECBP Typical Floor, from grids A to D
FLAT SLAB ANALYSIS & DESIGN to BS 8110:1997
Originated from RCC33.xls on CD © 1999 BCA for RCC
Moment Distribution (cont)
Live on 3.82265625 -302.34375 302.34375
Even Spans -0.33605769 -3.15054087 -0.33605769 45.96540717 105.2064678 105.2064678 45.96540717096 -45.9654072 -105.206468
52.60323391 -1.57527043 -52.6032339 52.60323391
-4.62446012 -43.3543137 -4.62446012 8.236773581 18.85247859 18.85247859 8.236773580513 -8.23677358 -18.8524786
9.426239297 -21.6771568 -9.4262393 9.426239297
-0.82868038 -7.76887854 -0.82868038 4.728658249 10.82303982 10.82303982 4.728658249062 -4.72865825 -10.8230398
5.411519908 -3.88443927 -5.41151991 5.411519908
-0.47573801 -4.46004388 -0.47573801 1.413267344 3.234712245 3.234712245 1.413267344469 -1.41326734 -3.23471224
1.617356122 -2.23002194 -1.61735612 1.617356122
-0.14218515 -1.33298582 -0.14218515 0.584917992 1.338771039 1.338771039 0.584917992117 -0.58491799 -1.33877104
0.66938552 -0.66649291 -0.66938552 0.66938552
-0.05884708 -0.55169136 -0.05884708 0.203093981 0.464845233 0.464845233 0.20309398105 -0.20309398 -0.46484523
0.232422616 -0.27584568 -0.23242262 0.232422616
-0.02043276 -0.1915571 -0.02043276 0.077272175 0.176861973 0.176861973 0.077272175268 -0.07727218 -0.17686197
Sum -6.49 3.82 9.15 -6.49 61.21 109.79 -232.21 61.21 -61.21 232.21

Elastic Support Moments (3.2.1.2.2)


Support 1 2 3 4 5
Left Right Left Right Left Right Left Right Left Right
All spans 12.56 119.07 710.44 618.69 618.69 710.44 119.07 12.56 0.00 0.00
Odd Spans 8.74 128.22 600.66 386.48 386.48 600.66 128.22 8.74 0.00 0.00
Even Spans 12.56 48.65 439.99 520.14 520.14 439.99 48.65 12.56 0.00 0.00

Redistribution (3.2.2.1) method 1 6E-06


ßb - 1 0.8 0.8 1 1
ßb + 1 1.2 1.2 1 1
Mt max 183.65 1000000.00 1000000.00 183.65 1000000.00
Max M 128.22 568.35 568.35 128.22 0.00
Dead only 8.74 57.80 330.20 287.94 287.94 330.20 57.80 8.74 0.00 0.00
All spans 12.56 119.07 568.35 568.35 568.35 568.35 119.07 12.56 0.00 0.00
Odd Spans 8.74 128.22 568.35 463.78 463.78 568.35 128.22 8.74 0.00 0.00
Even Spans 12.56 48.65 527.98 568.35 568.35 527.98 48.65 12.56 0.00 0.00

Total Ultimate Loads


Span 1 2 3
UDL PL1 PL2 ptUD UDL PL1 PL2 ptUD UDL PL1
Dead only 421.875 0 0 0 421.875 0 0 0 421.875 0
All spans 905.625 0 0 0 905.625 0 0 0 905.625 0
Odd Spans 905.625 0 0 0 421.875 0 0 0 905.625 0
Even Spans 421.875 0 0 0 905.625 0 0 0 421.875 0
Span 4 5 6
Dead only 0 0 0 0 0 0 0 0 0 0
All spans 0 0 0 0 0 0 0 0 0 0
Odd Spans 0 0 0 0 0 0 0 0 0 0
Even Spans 0 0 0 0 0 0 0 0 0 0

Elastic Shears
Span 1 2 3 LEFT
All spans 374.0 531.7 452.8 452.8 531.7 374.0 108.0
Odd Spans 389.8 515.8 210.9 210.9 515.8 389.8 108.0
Even Spans 158.8 263.1 452.8 452.8 263.1 158.8 73.4
Span 4 5 6 RIGHT
All spans 108.0 0.0 0.0 0.0 0.0 0.0 0.0
Odd Spans 108.0 0.0 0.0 0.0 0.0 0.0 0.0
Even Spans 73.4 0.0 0.0 0.0 0.0 0.0 0.0

Redistributed Shears
Span 1 2 3 LEFT
Dead only 174.6 247.3 210.9 210.9 247.3 174.6 73.4
All spans 392.9 512.7 452.8 452.8 512.7 392.9 108.0
Odd Spans 394.1 511.5 210.9 210.9 511.5 394.1 108.0
Even Spans 147.0 274.8 452.8 452.8 274.8 147.0 73.4
Span 4 5 6 RIGHT
Dead only 73.4 0.0 0.0 0.0 0.0 0.0 0.0
All spans 108.0 0.0 0.0 0.0 0.0 0.0 0.0
Odd Spans 108.0 0.0 0.0 0.0 0.0 0.0 0.0
Even Spans 73.4 0.0 0.0 0.0 0.0 0.0 0.0

Imposed Reactions
Support 1 2 3 4 5 6 7
All spans 96.1 202.5 202.5 96.1 0.0 0.0 0.0
Odd Spans 96.8 50.6 50.6 96.8 0.0 0.0 0.0
Even Spans -79.3 53.9 53.9 -79.3 0.0 0.0 0.0
Project Spreadsheets to BS 8110
Location ECBP Typical Floor, from grids A to D
FLAT SLAB ANALYSIS & DESIGN to BS 8110:1997
Originated from RCC33.xls on CD © 1999 BCA for RCC
SPAN MOMENTS
SPAN 1 Left < > PL1 < > PL2 < > Right Loadings
Elastic V All 374.0 0.0 374.0 0.0 374.0 100.0 531.7 120.75 0
Odd 389.8 0.0 389.8 0.0 389.8 100.0 515.8 120.75 0
Even 158.8 0.0 158.8 0.0 158.8 100.0 263.1 56.25 0
Redist V All 392.9 0.0 392.9 0.0 392.9 100.0 512.7 7.5
Odd 394.1 0.0 394.1 0.0 394.1 100.0 511.5
Even 147.0 0.0 147.0 0.0 147.0 100.0 274.8
Elastic X- All 0.000 0 0.000 0 3.097
Odd 0.000 0 0.000 0 3.228
Even 0.000 0 0.000 0 2.822
Redist X- All 0.000 0 0.000 0 3.254
Odd 0.000 0 0.000 0 3.264 (3.2.2.1b)
Even 0.000 0 0.000 0 2.614 Max
Elastic M All 119.1 -119.1 -119.1 -119.1 -119.1 460.0 710.4 460.0106977
Odd 128.2 -128.2 -128.2 -128.2 -128.2 501.0 600.7 501.0154247
Even 48.6 -48.6 -48.6 -48.6 -48.6 175.4 440.0 175.391206 ßb
Redist M All 119.1 -119.1 -119.1 -119.1 -119.1 520.2 568.4 520.1700776 1.130778219
Odd 128.2 -128.2 -128.2 -128.2 -128.2 515.0 568.4 514.9959114 1.027904304
Even 48.6 -48.6 -48.6 -48.6 -48.6 143.5 528.0 143.4999154 0.818170527

SPAN 2 Left < > PL1 < > PL2 < > Right Loadings
Elastic V All 452.8 0.0 452.8 0.0 452.8 100.0 452.8 120.75 0
Odd 210.9 0.0 210.9 0.0 210.9 100.0 210.9 56.25 0
Even 452.8 0.0 452.8 0.0 452.8 100.0 452.8 120.75 0
Redist V All 452.8 0.0 452.8 0.0 452.8 100.0 452.8 7.5
Odd 210.9 0.0 210.9 0.0 210.9 100.0 210.9
Even 452.8 0.0 452.8 0.0 452.8 100.0 452.8
Elastic X- All 0.000 0 0.000 0 3.750
Odd 0.000 0 0.000 0 3.750
Even 0.000 0 0.000 0 3.750
Redist X- All 0.000 0 0.000 0 3.750
Odd 0.000 0 0.000 0 3.750 (3.2.2.1b)
Even 0.000 0 0.000 0 3.750 Max
Elastic M All 618.7 -618.7 -618.7 -618.7 -618.7 230.3 618.7 230.3333328
Odd 386.5 -386.5 -386.5 -386.5 -386.5 9.0 386.5 9.024438498
Even 520.1 -520.1 -520.1 -520.1 -520.1 328.9 520.1 328.8816895 ßb
Redist M All 568.4 -568.4 -568.4 -568.4 -568.4 280.7 568.4 280.6685869 1.218532218
Odd 463.8 -463.8 -463.8 -463.8 -463.8 -68.3 463.8 6.317106948 0.7
Even 568.4 -568.4 -568.4 -568.4 -568.4 280.7 568.4 280.6685869 0.853402898

SPAN 3 Left < > PL1 < > PL2 < > Right Loadings
Elastic V All 531.7 0.0 531.7 0.0 531.7 100.0 374.0 120.75 0
Odd 515.8 0.0 515.8 0.0 515.8 100.0 389.8 120.75 0
Even 263.1 0.0 263.1 0.0 263.1 100.0 158.8 56.25 0
Redist V All 512.7 0.0 512.7 0.0 512.7 100.0 392.9 7.5
Odd 511.5 0.0 511.5 0.0 511.5 100.0 394.1
Even 274.8 0.0 274.8 0.0 274.8 100.0 147.0
Elastic X- All 0.000 0 0.000 0 4.403
Odd 0.000 0 0.000 0 4.272
Even 0.000 0 0.000 0 4.678
Redist X- All 0.000 0 0.000 0 4.246
Odd 0.000 0 0.000 0 4.236 (3.2.2.1b)
Even 0.000 0 0.000 0 4.886 Max
Elastic M All 710.4 -710.4 -710.4 -710.4 -710.4 460.0 119.1 460.0106977
Odd 600.7 -600.7 -600.7 -600.7 -600.7 501.0 128.2 501.0154247
Even 440.0 -440.0 -440.0 -440.0 -440.0 175.4 48.6 175.391206 ßb
Redist M All 568.4 -568.4 -568.4 -568.4 -568.4 520.2 119.1 520.1700776 1.130778219
Odd 568.4 -568.4 -568.4 -568.4 -568.4 515.0 128.2 514.9959114 1.027904304
Even 528.0 -528.0 -528.0 -528.0 -528.0 143.5 48.6 143.4999154 0.818170527
Project Spreadsheets to BS 8110
Location ECBP Typical Floor, from grids A to D
FLAT SLAB ANALYSIS & DESIGN to BS 8110:1997
Originated from RCC33.xls on CD © 1999 BCA for RCC
SPAN 4 Left < > PL1 < > PL2 < > Right Loadings
Elastic V All 108.0 0.0 108.0 0.0 108.0 100.0 0.0 0 0
Odd 108.0 0.0 108.0 0.0 108.0 100.0 0.0 0 0
Even 73.4 0.0 73.4 0.0 73.4 100.0 0.0 0 0
Redist V All 108.0 0.0 108.0 0.0 108.0 100.0 0.0 0
Odd 108.0 0.0 108.0 0.0 108.0 100.0 0.0
Even 73.4 0.0 73.4 0.0 73.4 100.0 0.0
Elastic X- All 0.000 0 0.000 0 0.000
Odd 0.000 0 0.000 0 0.000
Even 0.000 0 0.000 0 0.000
Redist X- All 0.000 0 0.000 0 0.000
Odd 0.000 0 0.000 0 0.000 (3.2.2.1b)
Even 0.000 0 0.000 0 0.000 Max
Elastic M All 12.6 -12.6 -12.6 -12.6 -12.6 -12.6 0.0 -12.5589844
Odd 8.7 -8.7 -8.7 -8.7 -8.7 -8.7 0.0 -8.73632813
Even 12.6 -12.6 -12.6 -12.6 -12.6 -12.6 0.0 -12.5589844 ßb
Redist M All 12.6 -12.6 -12.6 -12.6 -12.6 -12.6 0.0 -8.79128906 0.7
Odd 8.7 -8.7 -8.7 -8.7 -8.7 -8.7 0.0 -6.11542969 0.7
Even 12.6 -12.6 -12.6 -12.6 -12.6 -12.6 0.0 -8.79128906 0.7

SPAN 5 Left < > PL1 < > PL2 < > Right Loadings
Elastic V All 0.0 100.0 0.0 100.0 0.0 100.0 0.0 0 0
Odd 0.0 100.0 0.0 100.0 0.0 100.0 0.0 0 0
Even 0.0 100.0 0.0 100.0 0.0 100.0 0.0 0 0
Redist V All 0.0 100.0 0.0 100.0 0.0 100.0 0.0 0
Odd 0.0 100.0 0.0 100.0 0.0 100.0 0.0
Even 0.0 100.0 0.0 100.0 0.0 100.0 0.0
Elastic X- All 0.000 0 0.000 0 0.000
Odd 0.000 0 0.000 0 0.000
Even 0.000 0 0.000 0 0.000
Redist X- All 0.000 0 0.000 0 0.000
Odd 0.000 0 0.000 0 0.000 (3.2.2.1b)
Even 0.000 0 0.000 0 0.000 Max
Elastic M All 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0
Odd 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0
Even 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0 ßb
Redist M All 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0 0
Odd 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0 0
Even 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0 0

SPAN 6 Left < > PL1 < > PL2 < > Right Loadings
Elastic V All 0.0 100.0 0.0 100.0 0.0 100.0 0.0 0 0
Odd 0.0 100.0 0.0 100.0 0.0 100.0 0.0 0 0
REINFORCEMENT DESIGN SPAN 5 Span = 0.000 m BS8110
Top Steel Ref
LEFT SPAN RIGHT 0.25L
Total Design M kNm 12.6 ~ 0.0 0.0
ßb ~ ~ ~ 1.000 3.4.4.3
Be mm 0 0 Fig 3.13
Mt max kNm #DIV/0! #DIV/0! 3.7.4.2
MIDDLE STRIP
b mm 7500 7500 7500 7500 Fig 3.12
M kNm 3.1 #VALUE! 0.0 0.0 Table 3.18
Bar dia mm 12 #VALUE! 12 12
d mm 219.0 #VALUE! 219.0 219.0
K' 0.156 0.156 0.156 0.156 3.4.4.4
K 0.0002 #VALUE! #VALUE! 0.0000 0.0000 3.4.4.4
z mm 208.1 #VALUE! #VALUE! 208.1 208.1 3.4.4.4
As mm²/m 5 #VALUE! #VALUE! 0 0 3.4.4.4
As enhancement deflection control 0.00% #VALUE! #VALUE!
As final mm²/m 325 #VALUE! #VALUE! 325 325 3.12.5.3
S mm 325 #VALUE! #VALUE! 325 325
Clause b ? No #VALUE! #VALUE! No No No No 3.12.11.2.7
S max mm 657 ok #VALUE! ### 657 ok 657 ok 3.12.11.2.7
As prov mm²/m 348 #VALUE! 348 348
=% % 0.159 #VALUE! #VALUE! 0.159 0.159
fs N/mm² #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! 1.0 Eqn 8
Deflection Base ratio 26 k tens #VALUE! k comp 1.050 Allowed #VALUE! #VALUE! #VALUE!
COLUMN STRIP
b mm 0 0 0 0 Fig 3.12
M kNm 9.4 #VALUE! 0.0 0.0 Table 3.18
Bar dia mm #DIV/0! #VALUE! #DIV/0! #DIV/0!
d mm #DIV/0! #VALUE! #DIV/0! #DIV/0!
K' 0.156 0.156 0.156 0.156 3.4.4.4
K #DIV/0! #VALUE! #VALUE! #DIV/0! #DIV/0! #DIV/0! #DIV/0! 3.4.4.4
z mm #DIV/0! #VALUE! #VALUE! #DIV/0! #DIV/0! #DIV/0! #DIV/0! 3.4.4.4
As mm²/m #DIV/0! #VALUE! #VALUE! #DIV/0! #DIV/0! #DIV/0! #DIV/0! 3.4.4.4
As enhancement deflection control 0.00% #VALUE! #VALUE!
As final mm²/m #DIV/0! #VALUE! #VALUE! #DIV/0! #DIV/0! #DIV/0! #DIV/0! 3.12.5.3
S mm #DIV/0! #VALUE! #VALUE! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
Clause b ? #DIV/0! #VALUE! #VALUE! #DIV/0! #DIV/0! #DIV/0! #DIV/0! 3.12.11.2.7
S max mm #DIV/0! #DIV/0! #VALUE! ### #DIV/0! #DIV/0! #DIV/0! #DIV/0! 3.12.11.2.7
As prov mm²/m #DIV/0! #VALUE! #DIV/0! #DIV/0!
=% % #DIV/0! #VALUE! #VALUE! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
fs N/mm² #DIV/0! #VALUE! #VALUE! #DIV/0! #DIV/0! #DIV/0! #DIV/0! Eqn 8

Deflection Base ratio 26 k tens #VALUE! k comp #DIV/0! Allowed #VALUE! #VALUE! #VALUE!
Project Spreadsheets to BS 8110
Location ECBP Typical Floor, from grids A to D DATA FOR GRAPHS Made by rmw Job No R68
FLAT SLAB ANALYSIS & DESIGN to BS 8110:1997 Date 25-Nov-20
Originated from RCC33.xls on CD © 1999 BCA for RCC REINFORCED CONCRETE COUNCIL
LOADING DIAGRAM -11 SPAN 1 SPAN 2 SPAN 3 SPAN 4 SPAN 5
SUPT 1 UDL partial UDL PL1 PL2 SUPT 2 UDL partial UDL PL1 PL2 SUPT 3 UDL partial UDL PL1 PL2 SUPT 4 UDL partial UDL PL1 PL2 SUPT 5 UDL partial UDL PL1 PL2 SUPT 6 UDL
X 0 0 0 125 125 125 125 125 125 125 125 125 125 125 125 125 125 125 7625 7625 7625 7625 7625 7625 7625 7625 7625 7625 7625 7625 7625 7625 7625 15125 15125 15125 15125 15125 15125 15125 15125 15125 15125 15125 15125 15125 15125 15125 22625 22625 22625 22625 22625 22750 22750 22750 22750 22750 22750 22750 22750 22750 22750 22625 22625 22625 22625 22625 22625 22625 22625 22625 22625 22625 22625 22625 22625 22625 22625 22625 22625 22625 22625
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 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 0 0 0 0 0 0 0
UDL 0 11 11 11 11 11 11 11.00 11 11 11 11 11 11 11 11 11 11 11 0 0 0 11.00 11 11 11 11 11 11 11 11 11 11 11 0 0 0 11.00 11 11 11 11 11 11 11 11 11 11 11 0 0 0 11.00 11 0 0 0 11 11 11 11 11 11 11 0 0 0 0.00 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0.00
part UDL 0 11 11 11 11 11 11 11 11 11 11 11 11 11 11 11 11 11 11 0 0 0 11 11 11 11 11 11 11 11 11 11 11 11 0 0 0 11 11 11 11 11 11 11 11 11 11 11 11 0 0 0 11 11 11 11 11 11 11 11 11 11 11 11 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
PL 1 11 19.85 11 11 11 11 11 11 11 11 11 11 11 11 11 11 11 11 11 0 0 0 11 11 11 11 11 11 11 11 11 11 11 11 0 0 0 11 11 11 11 11 11 11 11 11 11 11 11 0 0 0 11 11 0 0 0 11 19.85 11 11 11 11 11 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
PL 2 11 11 11 11 11 11 11 11 11 11 11 11 11 11 11 11 11 11 11 0 0 0 11 11 11 11 11 11 11 11 11 11 11 11 0 0 0 11 11 11 11 11 11 11 11 11 11 11 11 0 0 0 11 11 0 0 0 11 11 11 11 11 11 11 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
SUPPORTS 0 0 0 0 -56.25 56.25 0 0 0 0 0 0 0 0 0 0 0 0 0 -56.25 56.25 0 0 0 0 0 0 0 0 0 0 0 0 0 -56.25 56.25 0 0 0 0 0 0 0 0 0 0 0 0 0 -56.25 56.25 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

MOMENT DIAGRAMS 0.5 0.7


LEFT RIGHT
Local X 0 0.025 0.05 0.075 0.1 0.125 0 0.025 0.05 0.075 0.1 0.125 1 7.50 3.50
X 0 0.025 0.05 0.075 0.1 0.125 22.625 22.65 22.675 22.7 22.725 22.75 2 7.50 3.50
M all 0 2.36086 4.79719 7.30898 9.89625 12.559 120.75 92.925 12.559 9.89625 7.30898 4.79719 2.36086 0 120.75 92.925 3 7.50 3.50
M odd 0 1.67695 3.38906 5.13633 6.91875 8.73633 56.25 66.375 8.73633 6.91875 5.13633 3.38906 1.67695 0 56.25 66.375 4 0.00 0.00
M even 0 2.36086 4.79719 7.30898 9.89625 12.559 12.559 9.89625 7.30898 4.79719 2.36086 0 120.75 92.925 5 0.00 0.00
Beam 0 0 0 0 0 0 0 0 0 0 0 0 6 0.00 0.00
Lower bound 0 0 0 0 0 0 0 0 0 0 0 0
Upper bound 0 2.36086 4.79719 7.30898 9.89625 12.559 12.559 9.89625 7.30898 4.79719 2.36086 0
SPAN 1 at col face
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 0.125 7.3
X 0.125 0.5 0.875 1.25 1.625 2 2.375 2.75 3.125 3.5 3.875 4.25 4.625 5 5.375 5.75 6.125 6.5 6.875 7.25 7.625
M(e) all 119.071 -12.6751 -127.44 -225.225 -306.03 -369.854 -416.697 -446.56 -459.443 -455.345 -434.266 -396.207 -341.168 -269.148 -180.148 -74.1672 48.794 188.736 345.658 519.56 710.444 73.2688 606.526
M(e) odd 128.221 -9.47182 -130.184 -233.916 -320.667 -390.438 -443.228 -479.038 -497.868 -499.717 -484.585 -452.473 -403.381 -337.308 -254.254 -154.221 -37.2063 96.7885 247.764 415.719 600.656 80.4366 499.91
M(e) even 48.6481 -6.93146 -54.6009 -94.3601 -126.209 -150.148 -166.177 -174.295 -174.504 -166.802 -151.19 -127.668 -96.2362 -56.8938 -9.64135 45.5213 108.594 179.577 258.47 345.273 439.987 29.2427 388.489
Beam 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) all 119.071 -19.7795 -141.649 -246.539 -334.447 -405.376 -459.324 -496.291 -516.278 -519.285 -505.311 -474.356 -426.421 -361.506 -279.61 -180.734 -64.877 67.9603 217.778 384.576 568.355 70.9006 468.226
M(r) odd 128.221 -11.0869 -133.414 -238.761 -327.127 -398.513 -452.919 -490.344 -510.788 -514.252 -500.736 -470.239 -422.761 -358.303 -276.865 -178.446 -63.0469 69.3328 218.693 385.034 568.355 79.8983 468.47
M(r) even 48.6481 -2.5316 -45.8011 -81.1605 -108.61 -128.149 -139.778 -143.496 -139.305 -127.203 -107.192 -79.2698 -43.4377 0.30445 51.9568 111.519 178.992 254.375 337.668 428.871 527.984 30.7093 474.139
70% max 89.7546 -4.85202 -38.2206 -66.0521 -88.3464 -105.104 -116.324 -122.007 -122.153 -116.762 -105.833 -89.3678 -67.3653 -39.8257 -6.74895 31.8649 76.0159 132.115 241.96 363.692 497.31 40.2183 424.568
70% min 34.0537 -8.87254 -91.1288 -163.741 -224.467 -273.307 -310.26 -335.327 -348.507 -349.802 -339.21 -316.731 -282.367 -236.116 -177.978 -107.954 -26.0444 67.7519 173.435 241.691 307.991 14.6213 271.942
Lower bound 0 -19.7795 -141.649 -246.539 -334.447 -405.376 -459.324 -496.291 -516.278 -519.285 -505.311 -474.356 -426.421 -361.506 -279.61 -180.734 -64.877 0 0 0 0 0 0
Upper bound 128.221 0 0 0 0 0 0 0 0 0 0 0 0 0.30445 51.9568 111.519 178.992 254.375 337.668 428.871 568.355 79.8983 474.139
Beam 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
SPAN 2 0.7
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 0.2 7.3
X 7.625 8 8.375 8.75 9.125 9.5 9.875 10.25 10.625 11 11.375 11.75 12.125 12.5 12.875 13.25 13.625 14 14.375 14.75 15.125
M(e) all 618.69 457.376 313.042 185.688 75.3151 -18.0775 -94.4896 -153.921 -196.372 -221.843 -230.333 -221.843 -196.372 -153.921 -94.4896 -18.0775 75.3151 185.688 313.042 457.376 618.69 530.543 530.543
M(e) odd 386.483 311.337 244.101 184.774 133.358 89.8525 54.2568 26.5713 6.79587 -5.06936 -9.02444 -5.06936 6.79587 26.5713 54.2568 89.8525 133.358 184.774 244.101 311.337 386.483 345.421 345.421
M(e) even 520.142 358.827 214.493 87.1398 -23.2333 -116.626 -193.038 -252.47 -294.921 -320.391 -328.882 -320.391 -294.921 -252.47 -193.038 -116.626 -23.2333 87.1398 214.493 358.827 520.142 431.994 431.994
Beam 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) all 568.355 407.04 262.706 135.353 24.9799 -68.4127 -144.825 -204.256 -246.708 -272.178 -280.669 -272.178 -246.708 -204.256 -144.825 -68.4127 24.9799 135.353 262.706 407.04 568.355 480.207 480.207
M(r) odd 463.78 388.634 321.397 262.071 210.655 167.149 131.553 103.868 84.0925 72.2273 68.2722 72.2273 84.0925 103.868 131.553 167.149 210.655 262.071 321.397 388.634 463.78 422.718 422.718
M(r) even 568.355 407.04 262.706 135.353 24.9799 -68.4127 -144.825 -204.256 -246.708 -272.178 -280.669 -272.178 -246.708 -204.256 -144.825 -68.4127 24.9799 135.353 262.706 407.04 568.355 480.207 480.207
70% max 433.083 320.163 219.129 129.982 93.3509 62.8968 37.9798 18.5999 4.75711 -3.54855 -6.31711 -3.54855 4.75711 18.5999 37.9798 62.8968 93.3509 129.982 219.129 320.163 433.083 371.38 371.38
70% min 270.538 217.936 150.145 60.9979 -16.2633 -81.6381 -135.127 -176.729 -206.445 -224.274 -230.217 -224.274 -206.445 -176.729 -135.127 -81.6381 -16.2633 60.9979 150.145 217.936 270.538 241.795 241.795
Lower bound 0 0 0 0 -16.2633 -81.6381 -144.825 -204.256 -246.708 -272.178 -280.669 -272.178 -246.708 -204.256 -144.825 -81.6381 -16.2633 0 0 0 0 0 0
Upper bound 568.355 407.04 321.397 262.071 210.655 167.149 131.553 103.868 84.0925 72.2273 68.2722 72.2273 84.0925 103.868 131.553 167.149 210.655 262.071 321.397 407.04 568.355 480.207 480.207
Beam 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
SPAN 3 0.5
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 0.2 7.375
X 15.125 15.5 15.875 16.25 16.625 17 17.375 17.75 18.125 18.5 18.875 19.25 19.625 20 20.375 20.75 21.125 21.5 21.875 22.25 22.625
M(e) all 710.444 519.56 345.658 188.736 48.794 -74.1672 -180.148 -269.148 -341.168 -396.207 -434.266 -455.345 -459.443 -446.56 -416.697 -369.854 -306.03 -225.225 -127.44 -12.6751 119.071 606.526 73.2688
M(e) odd 600.656 415.719 247.764 96.7885 -37.2063 -154.221 -254.254 -337.308 -403.381 -452.473 -484.585 -499.717 -497.868 -479.038 -443.228 -390.438 -320.667 -233.916 -130.184 -9.47182 128.221 499.91 80.4366
M(e) even 439.987 345.273 258.47 179.577 108.594 45.5213 -9.64135 -56.8938 -96.2362 -127.668 -151.19 -166.802 -174.504 -174.295 -166.177 -150.148 -126.209 -94.3601 -54.6009 -6.93146 48.6481 388.489 29.2427
Beam 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) all 568.355 384.576 217.778 67.9603 -64.877 -180.734 -279.61 -361.506 -426.421 -474.356 -505.311 -519.285 -516.278 -496.291 -459.324 -405.376 -334.447 -246.539 -141.649 -19.7795 119.071 468.226 70.9006
M(r) odd 568.355 385.034 218.693 69.3328 -63.0469 -178.446 -276.865 -358.303 -422.761 -470.239 -500.736 -514.252 -510.788 -490.344 -452.919 -398.513 -327.127 -238.761 -133.414 -11.0869 128.221 468.47 79.8983
M(r) even 527.984 428.871 337.668 254.375 178.992 111.519 51.9568 0.30445 -43.4377 -79.2698 -107.192 -127.203 -139.305 -143.496 -139.778 -128.149 -108.61 -81.1605 -45.8011 -2.5316 48.6481 474.139 30.7093
70% max 497.31 363.692 241.96 132.115 76.0159 31.8649 -6.74895 -39.8257 -67.3653 -89.3678 -105.833 -116.762 -122.153 -122.007 -116.324 -105.104 -88.3464 -66.0521 -38.2206 -4.85202 89.7546 424.568 40.2183
70% min 307.991 241.691 173.435 67.7519 -26.0444 -107.954 -177.978 -236.116 -282.367 -316.731 -339.21 -349.802 -348.507 -335.327 -310.26 -273.307 -224.467 -163.741 -91.1288 -8.87254 34.0537 271.942 14.6213
Lower bound 0 0 0 0 -64.877 -180.734 -279.61 -361.506 -426.421 -474.356 -505.311 -519.285 -516.278 -496.291 -459.324 -405.376 -334.447 -246.539 -141.649 -19.7795 0 0 0
Upper bound 568.355 428.871 337.668 254.375 178.992 111.519 51.9568 0.30445 0 0 0 0 0 0 0 0 0 0 0 0 128.221 474.139 79.8983
Beam 0 0 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 ECBP Typical Floor, from grids A to D DATA FOR GRAPHS II Made by rmw Job No R68
FLAT SLAB ANALYSIS & DESIGN to BS 8110:1997 Date 25-Nov-20
Originated from RCC33.xls on CD © 1999 BCA for RCC REINFORCED CONCRETE COUNCIL
SPAN 4 0.7
Local X 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0.125 0
X 22.625 22.625 22.625 22.625 22.625 22.625 22.625 22.625 22.625 22.625 22.625 22.625 22.625 22.625 22.625 22.625 22.625 22.625 22.625 22.625 22.625
M(e) all 12.559 12.559 12.559 12.559 12.559 12.559 12.559 12.559 12.559 12.559 12.559 12.559 12.559 12.559 12.559 12.559 12.559 12.559 12.559 12.559 0 -0.94336 12.559
M(e) odd 8.73633 8.73633 8.73633 8.73633 8.73633 8.73633 8.73633 8.73633 8.73633 8.73633 8.73633 8.73633 8.73633 8.73633 8.73633 8.73633 8.73633 8.73633 8.73633 8.73633 0 -4.76602 8.73633
M(e) even 12.559 12.559 12.559 12.559 12.559 12.559 12.559 12.559 12.559 12.559 12.559 12.559 12.559 12.559 12.559 12.559 12.559 12.559 12.559 12.559 0 3.3832 12.559
Beam 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) all 12.559 12.559 12.559 12.559 12.559 12.559 12.559 12.559 12.559 12.559 12.559 12.559 12.559 12.559 12.559 12.559 12.559 12.559 12.559 12.559 0 -0.94336 12.559
M(r) odd 8.73633 8.73633 8.73633 8.73633 8.73633 8.73633 8.73633 8.73633 8.73633 8.73633 8.73633 8.73633 8.73633 8.73633 8.73633 8.73633 8.73633 8.73633 8.73633 8.73633 0 -4.76602 8.73633
M(r) even 12.559 12.559 12.559 12.559 12.559 12.559 12.559 12.559 12.559 12.559 12.559 12.559 12.559 12.559 12.559 12.559 12.559 12.559 12.559 12.559 0 3.3832 12.559
70% max 8.79129 8.79129 8.79129 8.79129 8.79129 8.79129 8.79129 8.79129 8.79129 8.79129 8.79129 8.79129 8.79129 8.79129 8.79129 8.79129 8.79129 8.79129 8.79129 8.79129 0 2.36824 8.79129
70% min 6.11543 6.11543 6.11543 6.11543 6.11543 6.11543 6.11543 6.11543 6.11543 6.11543 6.11543 6.11543 6.11543 6.11543 6.11543 6.11543 6.11543 6.11543 6.11543 6.11543 0 -3.33621 6.11543
Lower bound 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 -4.76602 0
Upper bound 12.559 12.559 12.559 12.559 12.559 12.559 12.559 12.559 12.559 12.559 12.559 12.559 12.559 12.559 12.559 12.559 12.559 12.559 12.559 12.559 0 3.3832 12.559
Beam 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
SPAN 5 0.7
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 22.625 22.625 22.625 22.625 22.625 22.625 22.625 22.625 22.625 22.625 22.625 22.625 22.625 22.625 22.625 22.625 22.625 22.625 22.625 22.625 22.625
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 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 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 0 0
SPAN 6 0.7
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 0
X 22.625 22.625 22.625 22.625 22.625 22.625 22.625 22.625 22.625 22.625 22.625 22.625 22.625 22.625 22.625 22.625 22.625 22.625 22.625 22.625 22.625 22.625
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 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 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 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
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 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 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 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 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 0
Lower bound 0 0 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 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 7.5 0 0 0 0 0 7.5 0 0 0 0 0 7.5 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
X 0 0 0 0 0 0 7.5 7.5 7.5 7.5 7.5 7.5 15 15 15 15 15 15 22.5 22.5 22.5 22.5 22.5 22.5 22.5 22.5 22.5 22.5 22.5 22.5 22.5 22.5 22.5 22.5 22.5 22.5 22.5 22.5
V(e) all 0 373.963 373.963 373.963 373.963 373.963 -531.662 452.813 452.813 452.813 452.813 452.813 -452.813 531.662 531.662 531.662 531.662 531.662 -373.963 108.019 108.019 108.019 108.019 108.019 0 0 0 0 0 0 0 0 0 0 0 0 0 0
V(e) odd 0 389.821 389.821 389.821 389.821 389.821 -515.804 210.938 210.938 210.938 210.938 210.938 -210.938 515.804 515.804 515.804 515.804 515.804 -389.821 108.019 108.019 108.019 108.019 108.019 0 0 0 0 0 0 0 0 0 0 0 0 0 0
V(e) even 0 158.759 158.759 158.759 158.759 158.759 -263.116 452.813 452.813 452.813 452.813 452.813 -452.813 263.116 263.116 263.116 263.116 263.116 -158.759 73.4063 73.4063 73.4063 73.4063 73.4063 0 0 0 0 0 0 0 0 0 0 0 0 0 0
V(r) all 0 392.908 392.908 392.908 392.908 392.908 -512.717 452.813 452.813 452.813 452.813 452.813 -452.813 512.717 512.717 512.717 512.717 512.717 -392.908 108.019 108.019 108.019 108.019 108.019 0 0 0 0 0 0 0 0 0 0 0 0 0 0
V(r) odd 0 394.128 394.128 394.128 394.128 394.128 -511.497 210.938 210.938 210.938 210.938 210.938 -210.938 511.497 511.497 511.497 511.497 511.497 -394.128 108.019 108.019 108.019 108.019 108.019 0 0 0 0 0 0 0 0 0 0 0 0 0 0
V(r) even 0 147.026 147.026 147.026 147.026 147.026 -274.849 452.813 452.813 452.813 452.813 452.813 -452.813 274.849 274.849 274.849 274.849 274.849 -147.026 73.4063 73.4063 73.4063 73.4063 73.4063 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 0 0 0

GRIDS 0.125 0.125 7.625 7.625 15.125 15.125 22.625 22.625 22.625 22.625 22.625 22.625 22.625 22.625
-501.02 745.97 -501.02 745.966 -501.015 745.966 -501.015 745.966 -501.015 745.966 -501.015 745.966 -501.015 745.966
-520.17 596.77 -520.17 596.773 -520.17 596.773 -520.17 596.773 -520.17 596.773 -520.17 596.773 -520.17 596.773
SPAN 6
partial UDL PL1 PL2 SUPT 7
22625 22625 22625 22625 22625 22625 22625 22625 22625 22625 22625 22625 22625 22625 22625 22625 22625 22625
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 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 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
Disclaimer
All advice or information from the British Cement Association and/or Reinforced Concrete Council is intended for
those who will evaluate the significance and limitations of its contents and take responsibility for its use and
application. No liability (including that for negligence) for any loss resulting from such advice or information is
accepted by the BCA, RCC or their subcontractors, suppliers or advisors. Users should note that all BCA software
and publications are subject to revision from time to time and should therefore ensure that they are in possession of
the latest version.

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

Status of spreadsheet
Public release version.

Revision history RCC33 Flat Slabs (A & D)

Date Version Action Size (kB)


First public release.
04-Aug-99 RCC33 v1.0 1069
Includes b version comments

You might also like