REINFORCED CONCRETE

Project Spreadsheets to BS 8110 COUNCIL

Client Made by Date Page
Location INTERNAL MSKR 25-Aug-2020
PUNCHING SHEAR to BS8110:1997 COLUMN Checked Revision Job No
Originated from RCC13.xls on CD © 1999 BCA for RCC MSKR -

MATERIALS fcu N/mm2 35 STATUS Legend

fyv N/mm2 460 VALID DESIGN
link Ø mm 10

DIMENSION A mm 200 E mm 0
B mm 500 F mm 0
G mm 0 H mm 0

LOADING Vt kN 408 0 0 700.0

ult UDL kN/m2 0.00

SLAB h mm 200 dx mm 165 Asx mm2/m 1771

dy mm 145 Asy mm2/m 1771
ave d mm 155 ave As % 1.147

RESULTS Veff = 469.2 kN vc = 0.9381 N/mm2 (Table 3.8)

At col. face, v max = 2.162 N/mm2 At 1.5d perimeter, v = 0.9286 N/mm2
At 0d perimeter, v = 0.7225 N/mm2

PROVIDE LINKS 0 Links not required

0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0 Plan
0 0 0
 REINFORCED CONCRETE
Project Spreadsheets to BS 8110 COUNCIL
Client 0 Made by Date Page
Location Column B2 EDGE MSKR 25-Aug-2020 1
PUNCHING SHEAR to BS8110:1997 COLUMN Checked Revision Job No
Originated from RCC13.xls on CD © 1999 BCA for RCC MSKR - 0

MATERIALS fcu N/mm2 40 STATUS Legend

fyv N/mm2 460 VALID DESIGN
link Ø mm 10

DIMENSIONS A mm 390 E mm 0
B mm 390 F mm 0
D mm 0 G mm 0
H mm 0

LOADING Vt kN 590 0 0 627.7

ult UDL kN/m2 0.00

SLAB h mm 240 dx mm 205 Asx mm2/m 3500

dy mm 185 Asy mm2/m 3500
ave d mm 195 ave As % 1.800

RESULTS Veff = 737.5 kN vc = 1.0760 N/mm2 (Table 3.8)

At col. face, v max = 3.233 N/mm2 At 1.5d perimeter, v = 1.6163 N/mm2
At 3.75d perimeter, v = 0.9236 N/mm2

PROVIDE LINKS (single leg) .

Perimeter 1 8 T10 @ 260 97 from col face

Perimeter 2 10 T10 @ 265 244 from col face
Perimeter 3 12 T10 @ 270 390 from col face
Perimeter 4 14 T10 @ 275 536 from col face
0 0 0
0 0 0
0 0 0
0 0 0 Plan
0 0 0
 REINFORCED CONCRETE
Project Spreadsheets to BS 8110 COUNCIL
Client 0 Made by Date Page
Location CORNER MSKR 25-Aug-2020 2
PUNCHING SHEAR to BS8110:1997 COLUMN Checked Revision Job No
Originated from RCC13.xls on CD © 1999 BCA for RCC MSKR - 0

MATERIALS fcu N/mm2 45 STATUS Legend

fyv N/mm2 460 VALID DESIGN
link Ø mm 8

DIMENSIONS A mm 400 E mm 0
B mm 400 F mm 0
C mm 0 G mm 0
D mm 0 H mm 0

LOADING Vt kN 3433.0 0 0 350

ult UDL kN/m2 16.10

SLAB h mm 1200 dx mm 1165 Asx mm2/m 54200

dy mm 1145 Asy mm2/m 54200
ave d mm 1155 ave As % 4.693

RESULTS Veff = 4291.3 kN vc = 1.2376 N/mm2 (Table 3.8)

At col. face, v max = 4.641 N/mm2 At 1.5d perimeter, v = 0.8526 N/mm2
At 0d perimeter, v = 0.5934 N/mm2

PROVIDE LINKS 0 Links not required

0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0 Plan
0 0 0
 REINFORCED CONCRETE
Project Spreadsheets to BS 8110 COUNCIL
Client 0 Made by Date Page
Location An example RE-ENTRANT MSKR 25-Aug-2020 3
PUNCHING SHEAR to BS8110:1997 CORNER Checked Revision Job No
Originated from RCC13.xls on CD © 1999 BCA for RCC MSKR - 0

MATERIALS fcu N/mm2 40 STATUS Legend

fyv N/mm2 460 VALID DESIGN
link Ø mm 8

DIMENSION A mm 400 E mm 200

B mm 400 F mm -50
C mm -100 G mm 100
D mm -100 H mm 100

LOADING Vt kN 478.0 Veff = kN 591.6

ult UDL kN/m2 16.10

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

dy mm 195 Asy mm2/m 1340
ave d mm 205 ave As % 0.655

RESULTS Veff = 591.6 kN vc = 0.7588 N/mm2 (Table 3.8)

At hole face, vmax = 2.213 N/mm2 At 1.5d perimeter, v = 1.0039 N/mm2
At 3d perimeter, v = 0.6319 N/mm2

PROVIDE LINKS (single leg) .

Perimeter 1 6 T8 @ 240 102 from col face

Perimeter 2 8 T8 @ 295 256 from col face
Perimeter 3 11 T8 @ 285 410 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

Location 0 INTERNAL COLUMN

PUNCHING SHEAR to BS8110:1997 Made by MSKR Job No
Originated from RCC13.xls on CD © 1999 BCA for RCC Date 25-Aug-20

DETAILED CALCULATIONS
Veff/Vt 1.1500 (enhancement factor) link leg area 78.5
Hole deduction ? NO
CRITICAL PERIMETERS ENCLOSED AREAS
Per No a Internal deduct Final m Per No Internal
1 232.5 3260 0 3260 1 0.642
2 348.75 4190 0 4190 2 1.075
3 465 5120 0 5120 3 1.616
4 581.25 6050 0 6050 4 2.265
5 697.5 6980 0 6980 5 3.023
6 813.75 7910 0 7910 6 3.888
7 930 8840 0 8840 7 4.862
8 1046.25 9770 0 9770 8 5.943
Hole face 0 1400 0 1400 Hole face 0.100
Col face 0 1400 0 1400 Col face 0.100

LINK REQUIREMENTS within

Per No v Asv Total No Location Band?
1 0.9286 461 0.00 0.00 d 0
2 0.7225 593 0.00 0.00 d 0
3 0.5912 725 0.00 0.00 d 0
4 0.5003 856 0.00 0.00 d 0
5 0.4337 988 0.00 0.00 d 0
6 0.3827 1119 0.00 0.00 d 0
7 0.3424 1251 0.00 0.00 d 0
8 0.3098 1383 0.00 0.00 d 0
Hole face 2.1622
Col face 2.1622

LINK PERIMETERS 0
Per No a Internal deduct Final m No Spacing
1 77.5 2020 0 2020 11 220
2 193.75 2950 0 2950 15 225
3 310 3880 0 3880 19 225
4 426.25 4810 0 4810 23 225
5 542.5 5740 0 5740 27 225
6 658.75 6670 0 6670 31 230
7 775 7600 0 7600 35 230
8 891.25 8530 0 8530 39 230
9 1007.5 9460 0 9460 43 230
Project Spreadsheets to BS 8110

Location Column B2 EDGE COLUMN

PUNCHING SHEAR to BS8110:1997 Made by MSKR Job No 0
Originated from RCC13.xls on CD © 1999 BCA for RCC Date 25-Aug-20

DETAILED CALCULATIONS
Veff/Vt 1.2500 (enhancement factor) link leg area 78.5
Hole deduction ? NO
CRITICAL PERIMETERS ENCLOSED AREAS
Per No a Internal Choose m deduct Final m Per No Edge D
1 292.5 3900 2340 0 2340 1 0.665
2 438.75 5070 2925 0 2925 2 1.050
3 585 6240 3510 0 3510 3 1.521
4 731.25 7410 4095 0 4095 4 2.077
5 877.5 8580 4680 0 4680 5 2.719
6 1023.75 9750 5265 0 5265 6 3.446
7 1170 10920 5850 0 5850 7 4.259
8 1316.25 12090 6435 0 6435 8 5.157
Hole face 0 1560 1170 0 1170 Hole face 0.152
Col face 0 1170 0 1170 Col face 0.152

LINK REQUIREMENTS within

Per No v Asv Total No Location Band?
1 1.6163 563 7.16 1.50 d 1
2 1.2930 521 6.63 2.25 d 1
3 1.0775 625 7.96 3.00 d 1
4 0.9236 729 0.00 3.75 d 0
5 0.8081 833 0.00 0.00 d 0
6 0.7183 937 0.00 0.00 d 0
7 0.6465 1042 0.00 0.00 d 0
8 0.5877 1146 0.00 0.00 d 0
Hole face 3.2325
Col face 3.2325

LINK PERIMETERS 0
Per No a Internal Choose m deduct Final m No Spacing
1 97.5 2340 1560 0 1560 8 260
2 243.75 3510 2145 0 2145 10 265
3 390 4680 2730 0 2730 12 270
4 536.25 5850 3315 0 3315 14 275
5 682.5 7020 3900 0 3900 16 275
6 828.75 8190 4485 0 4485 18 280
7 975 9360 5070 0 5070 20 280
8 1121.25 10530 5655 0 5655 22 280
9 1267.5 11700 6240 0 6240 24 280
Project Spreadsheets to BS 8110

Location 0 CORNER COLUMN

PUNCHING SHEAR to BS8110:1997 Made by MSKR Job No 0
Originated from RCC13.xls on CD © 1999 BCA for RCC Date 25-Aug-20

DETAILED CALCULATIONS
Veff/Vt 1.2500 (enhancement factor) link leg area 50.3
Hole deduction ? NO
CRITICAL PERIMETERS
Per No a Internal Edge C Edge D Corner Choose m deduct Final m
1 1732.5 15460 8130 8130 4265 4265 0 4265
2 2598.75 22390 11595 11595 5997.5 5997.5 0 5998
3 3465 29320 15060 15060 7730 7730 0 7730
4 4331.25 36250 18525 18525 9462.5 9462.5 0 9463
5 5197.5 43180 21990 21990 11195 11195 0 11195
6 6063.75 50110 25455 25455 12928 12927.5 0 12928
7 6930 57040 28920 28920 14660 14660 0 14660
8 7796.25 63970 32385 32385 16393 16392.5 0 16393
Hole face 0 1600 1200 1200 800 800 0 800
Col face 0 800 800 0 800

ENCLOSED AREAS LINK REQUIREMENTS within

Per No Corner Per No v Asv Total No LocationBand?
1 4.548 1 0.853 4498 0.0 0.00 d 0
2 8.993 2 0.593 6325 0.0 0.00 d 0
3 14.938 3 0.447 8152 0.0 0.00 d 0
4 22.385 4 0.351 9979 0.0 0.00 d 0
5 31.332 5 0.283 11806 0.0 0.00 d 0
6 41.780 6 0.231 13633 0.0 0.00 d 0
7 53.729 7 0.190 15460 0.0 0.00 d 0
8 67.179 8 0.155 17287 0.0 0.00 d 0
Hole face 0.160 Hole face 4.641
Col face 0.160 Col face 4.641

LINK PERIMETERS 0
Per No a Internal Edge C Edge D Corner Choose m deduct Final m No Spacing
1 577.5 6220 3510 3510 1955 1955 0 1955 3 975
2 1443.75 13150 6975 6975 3687.5 3687.5 0 3688 4 1225
3 2310 20080 10440 10440 5420 5420 0 5420 5 1355
4 3176.25 27010 13905 13905 7152.5 7152.5 0 7153 6 1430
5 4042.5 33940 17370 17370 8885 8885 0 8885 7 1480
6 4908.75 40870 20835 20835 10618 10617.5 0 10618 8 1515
7 5775 47800 24300 24300 12350 12350 0 12350 9 1540
8 6641.25 54730 27765 27765 14083 14082.5 0 14083 10 1560
9 7507.5 61660 31230 31230 15815 15815 0 15815 11 1580
Project Spreadsheets to BS 8110

Location An example RE-ENTRANT CORNER COLUMN

PUNCHING SHEAR to BS8110:1997 Made by MSKR Job No 0
Originated from RCC13.xls on CD © 1999 BCA for RCC Date 25-Aug-20

DETAILED CALCULATIONS
Veff/Vt 1.2377 (enhancement factor) link leg area 50.3
Hole deduction ? YES
CRITICAL PERIMETERS ENCLOSED AREAS
Per No a Internal Corner deduct Final m Per No Internal Corner
1 307.5 4060 3245 406 2839 1 1.030 0.369
2 461.25 5290 4167.5 529 3639 2 1.749 0.580
3 615 6520 5090 652 4438 3 2.657 0.837
4 768.75 7750 6012.5 775 5238 4 3.754 1.142
5 922.5 8980 6935 898 6037 5 5.040 1.495
6 1076.25 10210 7857.5 1021 6837 6 6.515 1.894
7 1230 11440 8780 1144 7636 7 8.180 2.341
8 1383.75 12670 9702.5 1267 8436 8 10.033 2.835
Hole face 0 1600 1400 100 1300 Hole face 0.160 0.090
Col face 0 1400 100 1300 Col face 0.160

LINK REQUIREMENTS within

Per No v Asv Total No Location Band?
1 1.0039 531 10.57 1.50 d 0
2 0.7777 681 13.55 2.25 d 0
3 0.6319 831 0.00 3.00 d 0
4 0.5298 980 0.00 0.00 d 0
5 0.4540 1130 0.00 0.00 d 0
6 0.3952 1280 0.00 0.00 d 0
7 0.3481 1429 0.00 0.00 d 0
8 0.3094 1579 0.00 0.00 d 0
Hole face 2.2132
Col face 2.2079

LINK PERIMETERS 242

Per No a Internal Corner deduct Final m No Spacing
1 102.5 2420 1215 242 973 6 240
2 256.25 3650 2137.5 365 1773 8 295
3 410 4880 3060 488 2572 11 285
4 563.75 6110 3982.5 611 3372 13 305
5 717.5 7340 4905 734 4171 16 295
6 871.25 8570 5827.5 857 4971 19 290
7 1025 9800 6750 980 5770 21 300
8 1178.75 11030 7672.5 1103 6570 24 295
9 1332.5 12260 8595 1226 7369 26 305
Disclaimer
All advice or information from the British Cement Association and/or Reinforced Concrete Council is intended fo
those who will evaluate the significance and limitations of its contents and take responsibility for its use an
application. No liability (including that for negligence) for any loss resulting from such advice or information i
accepted by the BCA, RCC or their subcontractors, suppliers or advisors. Users should note that all BCA softwar
and publications are subject to revision from time to time and should therefore ensure that they are in possession o
the latest version.

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

Status of spreadsheet
Public release version.

Revision history RCC13 Punching Shear

Date Version Action

First public release.
03-Aug-99 RCC13 v1.0
Includes b version comments
Concrete Council is intended for
e responsibility for its use and
m such advice or information is
hould note that all BCA software
ure that they are in possession of

Spreadsheets for concrete design

wthorne, Berkshire RG45 6YS.

Size (kB)
309