RCC13 Punching Shear

Spreadsheets to BS 8110

Project Client

Advisory Group

Location

ECBP Typical Floor Column B3

The Concrete Centre

M Ma ad e b y

rmw

PUNCHING SHEAR to BS8110:2005 Originated from

RCC13.xls

v4.2 on CD

© 2006 TCC

INTERNAL Checked COLUMN chg

fcu N/mm2 fyv N/mm2 link Ø mm steel class A DI DIMENSION A mm B mm G mm

40 500 10 300 500 125

E F H

mm

LO LOADING

2954 16.10

0

0

3397.1

mm

484 455.5 469.75

M MA ATERIALS

SL SLAB

Vt ult UDL

kN/m

h

mm

kN 2

STATUS VALID DESIGN

525

dx dy ave d

RE RESULTS Veff = 3397.1 kN 2 At col. face, v max = 4.899 N/mm

PROVID PROVIDE E LINKS (singl (single e leg) Perimeter 1 Perimeter 2 Perimeter 3 0 0 0 0 0 0

16 H10 @ 195 20 H10 @ 280 30 H10 @ 270 0 0 0 0 0 0

mm mm

mm mm

Date

Page

11-Nov-2013 Revision

29 Job No

-

R68

Legend

150 -50 100

vc = At 1.5d perimeter, v = At 3d perimeter, v = .

234 from col face 587 from col face 940 from col face 0 0 0 0 0 0

Plan

Asx mm /m 5362 Asy mm2/m 3908 ave As 0.983 % 0.7349 1.0886 0.5896

N/mm² 2 N/mm N/mm

(Table 3.8)

Project


Client

Advisory Group

Location

Column B2

The Concrete Centre

Made by

rmw EDGE Checked

PUNCHING SHEAR to BS8110:2005 Originated from RCC13.xls v4.2 on CD

fcu N/mm2 fyv N/mm2 mm link Ø steel class A DIMENSIONS A mm B mm D mm MATERIALS

LOADING

SLAB

Vt ult UDL

kN/m

h

mm

kN 2

40 500 8

STATUS VALID DESIGN

200 200 50

223 14.40 250

Perimeter 1 Perimeter 2 0 0 0 0 0 0 0

6 H8 @ 195 8 H8 @ 210 0 0 0 0 0 0 0

E F G H

mm

0

0

dx dy ave d

RESULTS Veff = 312.2 kN 2 At col. face, v max = 2.459 N/mm

PROVIDE LINKS (single leg)

COLUMN

© 2006 TCC

mm mm mm

mm mm mm

Date

Page


chg

30 Job No

-

R68

Legend

175 -50 100 100 1399

207 187 197

Asx mm /m 2010 Asy mm2/m 1005 ave As 0.754 %

vc = At 1.5d perimeter, v = At 2.25d perimeter, v = .

98 from col face 246 from col face 0 0 0 0 0 0 0

Plan

0.8032 0.9303 0.6955

N/mm² 2 N/mm 2

N/mm

(Table 3.8)

Project


Client

Advisory Group

Location

Columns A1, D1, A5 & D5

The Concrete Centre

Made by

rmw

PUNCHING SHEAR to BS8110:2005

CORNER Checked

Originated from RCC13.xls v4.2 on CD

COLUMN

© 2006 TCC

fcu N/mm2 fyv N/mm2 link Ø mm steel class A DIMENSIONS A mm B mm C mm D mm

40 500 8 400 250 0 0

E F G H

mm

mm

-50 -250 100 100

LOADING

272.0 16.10

0

0

350

mm

215 195 205

MATERIALS

SLAB

Vt ult UDL

kN/m

h

mm

kN 2

STATUS VALID DESIGN

250

dx dy ave d

RESULTS Veff = 340.0 kN At col. face, v max = 2.910 N/mm

PROVIDE LINKS (single leg) Perimeter 1 Perimeter 2 Perimeter 3 Perimeter 4 Perimeter 5 0 0 0 0

6 H8 @ 140 8 H8 @ 125 5 H8 @ 275 6 H8 @ 265 7 H8 @ 265 0 0 0 0

mm mm

mm mm

Date

Page


chg

31 Job No

-

R68

Legend


102 from col face 256 from col face 410 from col face 564 from col face 717.5 from col face 0 0 0 Plan 0

Asx mm2/m 2010 Asy mm2/m 2010 % ave As 0.983 0.8686 1.6585 0.7741

N/mm² N/mm N/mm

(Table 3.8)

Project


Client

Advisory Group

Location

An example

The Concrete Centre

Made by

rmw

PUNCHING SHEAR to BS8110:2005 Origin ated from RCC13.xls v4.2 on CD

fcu N/mm2 2 fyv N/mm link Ø mm steel class A DIMENSIONS A mm B mm C mm D mm MATERIALS

LOADING

SLAB

40 500 10

mm

STATUS VALID DESIGN

350 350 0 0

250

Perimeter 1 Perimeter 2 0 0 0 0 0 0 0

6 H10 @ 175 8 H10 @ 220 0 0 0 0 0 0 0

E F G H

mm

0

0

dx dy ave d

RESULTS Veff = 558.8 kN At col. face, v max = 2.534 N/mm

PROVIDE LINKS (single leg)

CORNER

© 2006 TCC

kN Vt 447.0 2 ult UDL kN/m 14.40

h

RE-ENTRANT Checked

mm mm mm

mm mm mm

Date

Page


chg

32 Job No

-

R68

Legend

-125 -425 250 250 591.6

Asx mm2/m 2580 2 Asy mm /m 2580 % ave As 1.355

202 180 191


95 from col face 239 from col face 0 0 0 0 0 0 0

Plan

0.9841 1.1738 0.9209

N/mm² N/mm N/mm

(Table 3.8)

Project


Location

ECBP Typical Floor Column B3

INTERNAL COLUMN

PUNCHING SHEAR to BS8110:2005

Made by rmw

Originated from RCC13.xls v4.2 on CD

© 2006 TCC

Date

Job No R68 11-Nov-13

DETAILED CALCULATIONS Veff/Vt

1.1500

(enhancement factor)

CRITICAL PERIMETERS Per No a Internal 1 704.625 7237 2 1056.938 10055.5 3 1409.25 12874 4 1761.563 15692.5 5 2113.875 18511 6 2466.188 21329.5 7 2818.5 24148 8 3170.813 26966.5 Hole face 0 1600 Col face 0 1600 LINK REQUIREMENTS Per No v 1 2 3 4 5 6 7 8 Hole face Col face

1.0886 0.7716 0.5896 0.4699 0.3843 0.3191 0.2674 0.2248 4.8989 4.8989

LINK PERIMETERS Per No a 1 234.875 2 587.1875 3 939.5 4 1291.813 5 1644.125 6 1996.438 7 2348.75 8 2701.063 9 3053.375

deduct 712 1006 1299 1593 1887 2180 2474 2767 125 125

Internal 3479 6297.5 9116 11934.5 14753 17571.5 20390 23208.5 26027

Total No

Location

within Band?

35.90

49.80

0.00

0.00

0.00

0.00

0.00

0.00

1.50 d 2.25 d 3.00 d 0.00 d 0.00 d 0.00 d 0.00 d 0.00 d

0 0 0 0 0 0 0 0

Asv 2820 3911 5002 6093 7185 8276 9367 10458

link leg area 78.5 Hole deduction ? YES ENCLOSED AREAS Final Per No Internal 1 6525 3.263 2 9050 6.310 3 11575 10.349 4 14100 15.381 5 16624 21.406 6 19149 28.424 7 21674 36.435 8 24199 45.440 Hole face 0.150 1475 Col face 0.150 1475

deduct 321 614 908 1202 1495 1789 2082 2376 2669

Final

No

3158

16

5683

20

8208

30

10733

18

13258

22

15783

26

18308

28

20833

32

23358

36

Vc0 = 0.7060

Spacing 195 280 270 595 600 605 650 650 645

Project


Location

Column B2

EDGE COLUMN


Made by rmw © 2006 TCC

Date



1.4000


CRITICAL PERIMETERS Per No a Internal 1 295.5 3164 2 443.25 4346 3 591 5528 4 738.75 6710 5 886.5 7892 6 1034.25 9074 7 1182 10256 8 1329.75 11438 Hole face 75 1400 Col face 0 800

Choose 1882 2473 3064 3655 4246 4837 5428 6019 1000 700

LINK REQUIREMENTS Per No v Asv

link leg area 50.3 Hole deduction ? YES deduct 226 305 347 390 432 474 516 559 100 57

ENCLOSED AREAS Per No Edge D 0.431 1 0.753 2 1.162 3 1.659 4 2.242 5 2.913 6 3.672 7 8 4.517 Hole face 0.114 Col face 0.040

Final

1656

2168

2717

3265

3814

4363

4912

5461 900 643

Total No

Location

within Band? Vc0 = 0.8032

1

0.9303

300

5.97

1.50 d

1

2 3 4 5 6 7 8 Hole face Col face

0.6955 0.5396 0.4333 0.3553 0.2949 0.2462 0.2056 1.7479 2.4588

393 492 592 691 791 890 990

0.00

0.00

0.00

0.00

0.00

0.00

0.00

2.25 d 0.00 d 0.00 d 0.00 d 0.00 d 0.00 d 0.00 d

0 0 0 0 0 0 0

deduct 113 198 282 333 376 418 460 502 544

na

No

981

6

1487

8

1994

9

2534

11

3082

13

3631

15

4180

17

4729

19

5278

20

LINK PERIMETERS Per No a 1 98.5 2 246.25 3 394 4 541.75 5 689.5 6 837.25 7 985 8 1132.75 9 1280.5

Internal 1588 2770 3952 5134 6316 7498 8680 9862 11044

oose 1094 1685 2276 2867 3458 4049 4640 5231 5822

Spacing 195 210 245 250 255 255 260 260 275

Project


Location

Columns A1, D1, A5 & D5

CORNER COLUMN Made by rmw


Date

© 2006 TCC


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 1 307.5 3760 2280 2130 1265 1265 2 461.25 4990 2895 2745 1572.5 1572.5 3 615 6220 3510 3360 1880 1880 4 768.75 7450 4125 3975 2187.5 2187.5 5 922.5 8680 4740 4590 2495 2495 6 1076.3 9910 5355 5205 2802.5 2802.5 7 1230 11140 5970 5820 3110 3110 8 1383.8 12370 6585 6435 3417.5 3417.5 Hole face 25 1500 1150 1000 700 700 Col face 0 1300 1050 900 650 650 ENCLOSED AREAS Per No Corner 1 0.394 2 0.613 3 0.878 4 1.191 5 1.551 6 1.958 7 2.412 8 2.914 Hole face 0.117 Col face 0.100

LINK REQUIREMENTS Per No v Asv 1 1.659 673 2 1.353 270 3 1.097 270 4 0.912 319 5 0.774 367 6 0.666 415 7 0.578 464 8 0.506 512 Hole face 2.745 Col face 2.910

LINK PERIMETERS Per No a Internal Edge C Edge D 1 102.5 2120 1460 1310 2 256.25 3350 2075 1925 3 410 4580 2690 2540 4 563.75 5810 3305 3155 5 717.5 7040 3920 3770 6 871.25 8270 4535 4385 7 1025 9500 5150 5000 8 1178.8 10730 5765 5615 9 1332.5 11960 6380 6230

Corner Choose 855 855 1162.5 1162.5 1470 1470 1777.5 1777.5 2085 2085 2392.5 2392.5 2700 2700 3007.5 3007.5 3315 3315

deduct 288 391 447 498 549 600 652 703 100 83

Final 977

1182

1433

1690

1946

2202

2458

2715 600 567

within Total No Location and? 13.4 1 1.50 d 5.4 1 2.25 d 5.4 1 3.00 d 6.3 1 3.75 d 0.0 4.50 d 0 0.0 0.00 d 0 0.0 0.00 d 0 0.0 0.00 d 0 Vc0 = 0.8686

deduct 152 254 357 430 481 532 583 635 686

Final 703 908

1113

1348

1604

1860

2117

2373

2629

No Spacing 6 140 8 125 5 275 6 265 7 265 8 265 8 300 9 295 10 290

Project Location

Spreadsheets to BS 8110 An example

RE-ENTRANT COLUMN


Made by rmw © 2006 TCC

Date



1.2500


CRITICAL PERIMETERS Per No a Internal 1 286.5 3692 2 429.75 4838 3 573 5984 4 716.25 7130 5 859.5 8276 6 1002.75 9422 7 1146 10568 8 1289.25 11714 Hole face 0 1400 Col face 0 1400

Corner 3119 3978.5 4838 5697.5 6557 7416.5 8276 9135.5 1400 1400

LINK REQUIREMENTS Per No v Asv

link leg area 78.5 Hole deduction ? YES ENCLOSED AREAS Final deduct Per No Internal Corner 659 2460 1 0.852 0.405 864 3115 2 1.463 0.608 1069 3769 3 2.238 0.852 1273 4424 4 3.177 1.137 1478 5079 5 4.281 1.463 1683 5734 6 5.548 1.830 1887 6389 7 6.980 2.238 2092 7044 8 8.576 2.687 250 1150 Hole face 0.123 0.123 0.123 250 1150 Col face within Band?

Total No Location

Vc0 = 0.9841

1

1.1738

432

5.50

1.50 d

0

2 3 4 5 6 7 8 Hole face Col face

0.9209 0.7548 0.6370 0.5488 0.4801 0.4249 0.3794 2.5338 2.5338

547 662 777 893 1008 1123 1238

0.00

0.00

0.00

0.00

0.00

0.00

0.00

2.25 d 0.00 d 0.00 d 0.00 d 0.00 d 0.00 d 0.00 d

0 0 0 0 0 0 0

Corner 1273 2132.5 2992 3851.5 4711 5570.5 6430 7289.5 8149

deduct 386 591 796 1000 1205 1410 1614 1819 2024

na

No

887

6

1541

8

2196

10

2851

12

3506

15

4161

17

4816

19

5471

22

6125

24

LINK PERIMETERS Per No a 1 95.5 2 238.75 3 382 4 525.25 5 668.5 6 811.75 7 955 8 1098.25 9 1241.5

Internal 2164 3310 4456 5602 6748 7894 9040 10186 11332

Spacing 175 220 240 255 250 260 265 260 265

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 Public release version.

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

Revision history RCC13 Punching Shear

Date

Version

Action

Size (kB)

23-Jun-10

RCC13 v4.2

Improvement to numbers of links at perimeters more than3d from column face.

428

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

8-Jan-10

RCC13 v3.12

Adjustment to link spacing on INTERNAL and EDGE pages (number of links required unchanged).

460

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 l inks 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

¼

414

28-Jun-06

(400/d) limited to 0.67 outside link area. 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

3-Aug-99

RCC13 v1.0

First public release. Includes b version comments

309

RCC13 Punching Shear

Recommend Documents