Project Spreadsheets to BS 8110 The Concrete Centre

Client Advisory Group Made by Date Page

Location ECBP Typical Floor Column B3 rmw 31-May-2017 29
PUNCHING SHEAR to BS8110:2005 INTERNAL Checked Revision Job No

Originated from RCC13.xls v4.9 on CD 2006-10 TCC COLUMN chg - R68

MATERIALS fcu N/mm2 40 STATUS Legend

fyv N/mm2 500 VALID DESIGN
link mm 10
steel class B
DIMENSIONS A mm 300 E mm 150
B mm 500 F mm -50
G mm 125 H mm 100

LOADING Vt kN 2954 0 0 3397.1

ult UDL kN/m 2 16.10

SLAB h mm 525 dx mm 484 Asx mm2/m 5362

dy mm 455.5 Asy mm2/m 3908
ave d mm 469.75 ave As % 0.983

RESULTS Veff = 3397.1 kN vc = 0.7349 N/mm (Table 3.8)

At col. face, v max = 4.899 N/mm2 At 1.5d perimeter, v = 1.0886 N/mm2
At 3d perimeter, v = 0.5896 N/mm2

PROVIDE LINKS (single leg) .

Perimeter 1 16 B10 @ 195 234 from col face

Perimeter 2 20 B10 @ 280 587 from col face
Perimeter 3 30 B10 @ 270 940 from col face
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0 Plan
0 0 0
Project Spreadsheets to BS 8110 The Concrete Centre

Client Advisory Group Made by Date Page

Location Column B2 rmw 31-May-2017 30
PUNCHING SHEAR to BS8110:2005 EDGE Checked Revision Job No

Originated from RCC13.xls v4.9 on CD 2006-10 TCC COLUMN chg - R68

MATERIALS fcu N/mm2 40 STATUS Legend

fyv N/mm2 500 VALID DESIGN
link mm 8
steel class A
DIMENSIONS A mm 200 E mm 175
B mm 200 F mm -50
D mm 50 G mm 100
H mm 100

LOADING Vt kN 223 0 0 1399

ult UDL kN/m 2 14.40

SLAB h mm 250 dx mm 207 Asx mm2/m 2010

dy mm 187 Asy mm2/m 1005
ave d mm 197 ave As % 0.754

RESULTS Veff = 312.2 kN vc = 0.8032 N/mm (Table 3.8)

At col. face, v max = 2.459 N/mm2 At 1.5d perimeter, v = 0.9303 N/mm 2

At 2.25d perimeter, v = 0.6955 N/mm2

PROVIDE LINKS (single leg) .

Perimeter 1 6 H8 @ 195 98 from col face

Perimeter 2 8 H8 @ 210 246 from col face
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0 Plan
0 0 0
Project Spreadsheets to BS 8110 The Concrete Centre
Client Advisory Group Made by Date Page
Location Columns A1, D1, A5 & D5 rmw 31-May-2017 31
PUNCHING SHEAR to BS8110:2005 CORNER Checked Revision Job No

Originated from RCC13.xls v4.9 on CD 2006-10 TCC COLUMN chg - R68

MATERIALS fcu N/mm2 40 STATUS Legend

fyv N/mm2 500 VALID DESIGN
link mm 8
steel class A
DIMENSIONS A mm 400 E mm -50
B mm 250 F mm -250
C mm 0 G mm 100
D mm 0 H mm 100

LOADING Vt kN 272.0 0 0 350

ult UDL kN/m2 16.10

SLAB h mm 250 dx mm 215 Asx mm2/m 2010

dy mm 195 Asy mm2/m 2010
ave d mm 205 ave As % 0.983

RESULTS Veff = 340.0 kN vc = 0.8686 N/mm (Table 3.8)

At col. face, v max = 2.910 N/mm2 At 1.5d perimeter, v = 1.6585 N/mm2
At 4.5d perimeter, v = 0.7741 N/mm2

PROVIDE LINKS (single leg) .

Perimeter 1 6 H8 @ 140 102 from col face

Perimeter 2 8 H8 @ 125 256 from col face
Perimeter 3 5 H8 @ 275 410 from col face
Perimeter 4 6 H8 @ 265 564 from col face
Perimeter 5 7 H8 @ 265 717.5 from col face
0 0 0
0 0 0
0 0 0 Plan
0 0 0
Project Spreadsheets to BS 8110 The Concrete Centre
Client Advisory Group Made by Date Page
Location An example rmw 31-May-2017 32
PUNCHING SHEAR to BS8110:2005 RE-ENTRANT Checked Revision Job No

Originated from RCC13.xls v4.9 on CD 2006-10 TCC CORNER chg - R68

MATERIALS fcu N/mm2 40 STATUS Legend

fyv N/mm2 500 VALID DESIGN
link mm 10
steel class A
DIMENSIONS A mm 350 E mm -125
B mm 350 F mm -425
C mm 0 G mm 250
D mm 0 H mm 250

LOADING Vt kN 447.0 0 0 591.6

ult UDL kN/m2 14.40

SLAB h mm 250 dx mm 202 Asx mm2/m 2580

dy mm 180 Asy mm2/m 2580
ave d mm 191 ave As % 1.355

RESULTS Veff = 558.8 kN vc = 0.9841 N/mm (Table 3.8)

At col. face, v max = 2.534 N/mm2 At 1.5d perimeter, v = 1.1738 N/mm2
At 2.25d perimeter, v = 0.9209 N/mm2

PROVIDE LINKS (single leg) .

Perimeter 1 8 H10 @ 225 95 from col face

Perimeter 2 10 H10 @ 245 239 from col face
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0 Plan
0 0 0
Project Spreadsheets to BS 8110

Location ECBP Typical Floor Column B3 INTERNAL COLUMN

PUNCHING SHEAR to BS8110:2005 Made by rmw Job No R68
Originated from RCC13.xls v4.9 on CD 2006-10 TCC Date 31-May-17

DETAILED CALCULATIONS
Veff/Vt 1.1500 (enhancement factor) link leg area 78.5
Hole deduction ? YES
CRITICAL PERIMETERS ENCLOSED AREAS
Per No a Internal deduct Final Per No Internal
1 704.625 7237 712 6525 1 3.263
2 1056.9375 10055.5 1006 9050 2 6.310
3 1409.25 12874 1299 11575 3 10.349
4 1761.5625 15692.5 1593 14100 4 15.381
5 2113.875 18511 1887 16624 5 21.406
6 2466.1875 21329.5 2180 19149 6 28.424
7 2818.5 24148 2474 21674 7 36.435
8 3170.8125 26966.5 2767 24199 8 45.440
Hole face 0 1600 125 1475 Hole face 0.150
Col face 0 1600 125 1475 Col face 0.150

LINK REQUIREMENTS within

Per No v Asv Total No Location Band?
1 1.0886 2820 35.90 1.50 d 0 Vc0 = 0.7060
2 0.7716 3911 49.80 2.25 d 0
3 0.5896 5002 0.00 3.00 d 0
4 0.4699 6093 0.00 0.00 d 0
5 0.3843 7185 0.00 0.00 d 0
6 0.3191 8276 0.00 0.00 d 0
7 0.2674 9367 0.00 0.00 d 0
8 0.2248 10458 0.00 0.00 d 0
Hole face 4.8989
Col face 4.8989

LINK PERIMETERS
Per No a Internal deduct Final No Spacing
1 234.875 3479 321 3158 16 195
2 587.1875 6297.5 614 5683 20 280
3 939.5 9116 908 8208 30 270
4 1291.8125 11934.5 1202 10733 18 595
5 1644.125 14753 1495 13258 22 600
6 1996.4375 17571.5 1789 15783 26 605
7 2348.75 20390 2082 18308 28 650
8 2701.0625 23208.5 2376 20833 32 650
9 3053.375 26027 2669 23358 36 645
Project Spreadsheets to BS 8110

Location Column B2 EDGE COLUMN

PUNCHING SHEAR to BS8110:2005 Made by rmw Job No R68
Originated from RCC13.xls v4.9 on CD 2006-10 TCC Date 31-May-17

DETAILED CALCULATIONS
Veff/Vt 1.4000 (enhancement factor) link leg area 50.3
Hole deduction ? YES
CRITICAL PERIMETERS ENCLOSED AREAS
Per No a Internal Choose deduct Final Per No Edge D
1 295.5 3164 1882 226 1656 1 0.431
2 443.25 4346 2473 305 2168 2 0.753
3 591 5528 3064 347 2717 3 1.162
4 738.75 6710 3655 390 3265 4 1.659
5 886.5 7892 4246 432 3814 5 2.242
6 1034.25 9074 4837 474 4363 6 2.913
7 1182 10256 5428 516 4912 7 3.672
8 1329.75 11438 6019 559 5461 8 4.517
Hole face 75 1400 1000 100 900 Hole face 0.114
Col face 0 800 700 57 643 Col face 0.040

LINK REQUIREMENTS within

Per No v Asv Total No Location Band?
1 0.9303 300 5.97 1.50 d 1 Vc0 = 0.8032
2 0.6955 393 0.00 2.25 d 0
3 0.5396 492 0.00 0.00 d 0
4 0.4333 592 0.00 0.00 d 0
5 0.3553 691 0.00 0.00 d 0
6 0.2949 791 0.00 0.00 d 0
7 0.2462 890 0.00 0.00 d 0
8 0.2056 990 0.00 0.00 d 0
Hole face 1.7479
Col face 2.4588

LINK PERIMETERS
Per No a Internal Choose deduct Final No Spacing
1 98.5 1588 1094 113 981 6 195
2 246.25 2770 1685 198 1487 8 210
3 394 3952 2276 282 1994 9 245
4 541.75 5134 2867 333 2534 11 250
5 689.5 6316 3458 376 3082 13 255
6 837.25 7498 4049 418 3631 15 255
7 985 8680 4640 460 4180 17 260
8 1132.75 9862 5231 502 4729 19 260
9 1280.5 11044 5822 544 5278 20 275
Project Spreadsheets to BS 8110

Location Columns A1, D1, A5 & D5 CORNER COLUMN

PUNCHING SHEAR to BS8110:2005 Made by rmw Job No R68
Originated from RCC13.xls v4.9 on CD 2006-10 TCC Date 31-May-17

DETAILED CALCULATIONS
Veff/Vt 1.2500 (enhancement factor) link leg area 50.3
Hole deduction ? YES
CRITICAL PERIMETERS
Per No a Internal Edge C Edge D Corner Choose deduct Final
1 307.5 3760 2280 2130 1265 1265 288 977
2 461.25 4990 2895 2745 1572.5 1572.5 391 1182
3 615 6220 3510 3360 1880 1880 447 1433
4 768.75 7450 4125 3975 2187.5 2187.5 498 1690
5 922.5 8680 4740 4590 2495 2495 549 1946
6 1076.25 9910 5355 5205 2802.5 2802.5 600 2202
7 1230 11140 5970 5820 3110 3110 652 2458
8 1383.75 12370 6585 6435 3417.5 3417.5 703 2715
Hole face 25 1500 1150 1000 700 700 100 600
Col face 0 1300 1050 900 650 650 83 567

ENCLOSED AREAS LINK REQUIREMENTS within

Per No Corner Per No v Asv Total No LocationBand?
1 0.394 1 1.659 673 13.4 1.50 d 1
2 0.613 2 1.353 270 5.4 2.25 d 1
3 0.878 3 1.097 270 5.4 3.00 d 1
4 1.191 4 0.912 319 6.3 3.75 d 1
5 1.551 5 0.774 367 0.0 4.50 d 0
6 1.958 6 0.666 415 0.0 0.00 d 0
7 2.412 7 0.578 464 0.0 0.00 d 0
8 2.914 8 0.506 512 0.0 0.00 d 0
Hole face 0.117 Hole face 2.745
Col face 0.100 Col face 2.910 Vc0 = 0.8686

LINK PERIMETERS
Per No a Internal Edge C Edge D Corner Choose deduct Final No Spacing
1 102.5 2120 1460 1310 855 855 152 703 6 140
2 256.25 3350 2075 1925 1162.5 1162.5 254 908 8 125
3 410 4580 2690 2540 1470 1470 357 1113 5 275
4 563.75 5810 3305 3155 1777.5 1777.5 430 1348 6 265
5 717.5 7040 3920 3770 2085 2085 481 1604 7 265
6 871.25 8270 4535 4385 2392.5 2392.5 532 1860 8 265
7 1025 9500 5150 5000 2700 2700 583 2117 8 300
8 1178.75 10730 5765 5615 3007.5 3007.5 635 2373 9 295
9 1332.5 11960 6380 6230 3315 3315 686 2629 10 290
Project Spreadsheets to BS 8110

Location An example RE-ENTRANT COLUMN

PUNCHING SHEAR to BS8110:2005 Made by rmw Job No R68
Originated from RCC13.xls v4.9 on CD 2006-10 TCC Date 31-May-17

DETAILED CALCULATIONS
Veff/Vt 1.2500 (enhancement factor) link leg area 78.5
Hole deduction ? YES
CRITICAL PERIMETERS ENCLOSED AREAS
Per No a Internal Corner deduct Final Per No Internal Corner
1 286.5 3692 3119 659 2460 1 0.852 0.405
2 429.75 4838 3978.5 864 3115 2 1.463 0.608
3 573 5984 4838 1069 3769 3 2.238 0.852
4 716.25 7130 5697.5 1273 4424 4 3.177 1.137
5 859.5 8276 6557 1478 5079 5 4.281 1.463
6 1002.75 9422 7416.5 1683 5734 6 5.548 1.830
7 1146 10568 8276 1887 6389 7 6.980 2.238
8 1289.25 11714 9135.5 2092 7044 8 8.576 2.687
Hole face 0 1400 1400 250 1150 Hole face 0.123 0.123
Col face 0 1400 1400 250 1150 Col face 0.123

LINK REQUIREMENTS within

Per No v Asv Total No Location Band?
1 1.1738 432 5.50 1.50 d 0 Vc0 = 0.9841
2 0.9209 547 0.00 2.25 d 0
3 0.7548 662 0.00 0.00 d 0
4 0.6370 777 0.00 0.00 d 0
5 0.5488 893 0.00 0.00 d 0
6 0.4801 1008 0.00 0.00 d 0
7 0.4249 1123 0.00 0.00 d 0
8 0.3794 1238 0.00 0.00 d 0
Hole face 2.5338
Col face 2.5338

LINK PERIMETERS
Per No a Internal Corner deduct Final No Spacing
1 95.5 2164 1973 386 1587 8 225
2 238.75 3310 2832.5 591 2241 10 245
3 382 4456 3692 796 2896 13 240
4 525.25 5602 4551.5 1000 3551 15 250
5 668.5 6748 5411 1205 4206 17 260
6 811.75 7894 6270.5 1410 4861 19 270
7 955 9040 7130 1614 5516 22 260
8 1098.25 10186 7989.5 1819 6171 24 265
9 1241.5 11332 8849 2024 6825 26 270
Disclaimer
All advice or information from MPA-The Concrete Centre is intended for those who will evaluate the significance and limitations
of its contents and take responsibility for its use and application. No liability (including that for negligence) for any loss resulting
from such advice or information is accepted by MPA-The Concrete Centre or its subcontractors, suppliers or advisors. Users
should note that all MPA-The Concrete Centre software and publications are subject to revision from time to time and they
should therefore ensure that they are in possession of the latest version.

This spreadsheet should be used in compliance with the accompanying publication 'User Guide RC Spreadsheets: v4' available
from The Concrete Centre www.concretecentre.com/rcdesign Tel +44 (0)1276 606800

Status of spreadsheet This spreadsheet is shareware but may not be used for commercial purposes until the user has
registered with The Concrete Centre using the licence validation form available on The
Public release version. Concrete Centre website www.concretecentre.com/rcdesign

Revision history RCC13 Punching Shear

Date Version Action Size (kB)
10-May-12 RCC13 v4.9 Correction to "no links required" statement when V between V c and Vc0. 404
13-Jul-11 RCC13 v4.8 Slab thickness < 200mm allowed when no links required. 438
20-Jun-11 RCC13 v4.7 Failure messages added for slab thickness < 200mm. 438
28-May-11 RCC13 v4.6 Warnings added when certain entry cells left blank (rather than zero). 433
Correction to hole deuction on EDGE. Geometry errors now invalidate results
21-Feb-11 RCC13 v4.5 433
on INTERNAL and EDGE pages.
18-Oct-10 RCC13 v4.4 Correction to link lateral spacing for re-entrant columns. 448
21-Sep-10 RCC13 v4.3 Correction to display of "No links required". 435
Improvement to numbers of links at perimeters more than3d from column
23-Jun-10 RCC13 v4.2 428
face.
27-May-10 RCC13 v4.1 Correction to reduction of perimeters for holes at certain locations. 467
30-Mar-10 RCC13 v4.0 Re-badged as TCC/Mineral Products Association. 469
Adjustment to link spacing on INTERNAL and EDGE pages (number of links
8-Jan-10 RCC13 v3.12 460
required unchanged).
22-Apr-09 RCC13 v3.11 No link solutions given when design invalid. 461
27-Aug-08 RCC13 v3.10 Enhanced warnings (red formatting) added when v > 2vc. 455
5-Aug-08 RCC13 v3.9 Column face shears corrected on EDGE sheet. 435
1-Jun-08 RCC13 v3.8 Difference between vc with and without links highlighted. 431
26-May-08 RCC13 v3.7 Change to derivation of vmax at column face. 430
21-May-08 RCC13 v3.6 Main steel percentage limited to 3%. 415
11-Feb-08 RCC13 v3.5 Correction to vmax at "Edge Dets" E21. 415
6-Jan-08 RCC13 v3.4 Display of vc corrected when no links required. 415
11-Sep-07 RCC13 v3.3 Correction to column face shear on EDGE page. 414
21-Aug-06 RCC13 v3.2 (400/d) limited to 0.67 outside link area. 414
28-Jun-06 RCC13 v3.1 v3 release. Page nos, User Guide and registration details amended. 417
21-Oct-05 RCC13 v3.0 Updated to 2005 versions of BS8110 & BS8666 444
28-Apr-04 RCC13 v2.6 Correction to perimeter deduction for large holes. 412
8-Aug-03 RCC13 v2.5 Updated to May 2002 amendment to BS 8110 formulae for vc. 409
14-Mar-03 RCC13 v2.4 Correction to hole deductions on REENTRANT sheet. 406
18-Feb-03 RCC13 v2.3 Correction to hole deductions on EDGE sheet. 417
21-Jan-03 RCC13 v2.2 DETR logo replaced by DTI. 402
3-Dec-02 RCC13 v2.1 Fix for error when no holes. 421
11-Oct-02 RCC13 v2.0 Version 2 enhancements 421
27-Feb-02 RCC13 V1.3 Column face perimeter changed on "detail" sheets. 404
15-Feb-02 RCC13 V1.2 Improved routine for perimeter reduction due to adjacent holes. 407
17-Aug-00 RCC13 v1.1 Red warning if INTERNAL:M14 negative. 310
First public release.
3-Aug-99 RCC13 v1.0 309
Includes b version comments