Slab Punching (www.theengineeringcommunity.org).xls

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC	AD	AE	AF	AG	AH	AI	AJ
1	4.0														USE 6.4.3(6) ß FACTORS		B	B8 @		At col. face, vEd =	3,214		14/2/2026	CRITICAL PERIMETERS						LOADED AREAS			0,0	8	Auto	Radial only
2		Project	Spreadsheets to EC2						The Concrete Centre						CALCULATE ß					At hole face, vEd =	3,214			Per No	a	Internal	deduct	Final μ1		a	Internal		28,3	8	8	Automatic
3		Client	Advisory Group						Made by	Date		Page			CALCULATE ß									1	410	4176	435	3741		0	0,160		50,3	10	10	Automatic
4		Location	ECBP Typical Floor Column B3						rmw	14-févr.-2026		197		n =	0,516	fywd,ef =	301,25	MAX a =	1676					2	564	5142	534	4608		154	0,480		78,5	12	12
5			PUNCHING SHEAR to BS EN 1992-1: 2004				INTERNAL		Checked	Revision		Job No		fcd =	23,33			Max side	400					Hole face	0	1600	171	1429		0	0,160		113,1	16	16
6				Originated from TCC13.xls	v4.0 on CD © 2003-26 TCC			COLUMN	chg	-		FB625		k =	1,988	Hole deduct ?	YES	Min side	400	o/s hole =	403,1128874			Col face	0	1600	171	1429		0	0,160		201,1	20	20
7																																	314,2	25	25
8		MATERIALS	fck	N/mm2	35	STATUS			LEGEND					Solution 6.22 (B)				Solution 6.22 (A) Spurs =	8		Solution 6.22 (A) Spurs =	12					touch	overlap							32
9			fyk	N/mm2	500	VALID DESIGN							Shear Enhancement	outside face by	40	mm	St =	300,0	mm	St =	175,7	mm		Per No	vEd,red	Side B	Y	150	0						Auto
10				Steel class	B	.								Asw/Sr req =	5,690	mm	Asw/Sr min =	0,1893145531	mm	Asw/Sr min =	0,111	mm		1	1,2272	Side A	N	0	-150						#VALUE!
11														try X spurs =	3	No	Required Ø =	10	mm	Required Ø =	8	mm
12		DIMENSIONS	A	mm	400	E	mm	200					Link diameter on all pages	try Y spurs =	3	No	link Ø =	10	mm	link Ø =	8	mm		HOLE REDUCTION
13			B	mm	400	F	mm	50						Required Ø =	8	mm	Asw/Sr req =	5,690	mm	Asw/Sr req =	5,690	mm			BL	BR	TL	TR	Centre	EW
14			G	mm	150	H	mm	150					Spur layout	link Ø =	8	mm	Sr =	110	mm	Sr =	105	mm		X =	200,0	350,0	200,0	350,0	275,0	0
15														Asw/Sr min =	0,151	mm	Asw/Sr prov =	5,712	mm	Asw/Sr prov =	5,745	mm		Y =	50,0	50,0	200,0	200,0	125,0	0
16		LOADING	VEd	kN	883	Mty =	kNm	32,1					√				C req =	745	mm	C req =	730	mm		tan a =	0,1429		tan b =	1,0000
17			ult UDL	kN/m2	15,69	Mtz =	kNm	8,5					√	Sr =	105	mm	Last link @	440	mm	Last link @	420	mm		b/2	c/2	T Tan	R Tan	D/d
18			ß =	1,069	to expression (6.43)								√	X spurs =	3	No	C actual =	773	mm	C actual =	738	mm		610,0	610,0	0,3279	0,3279	434,9
19														Y spurs =	3	No	St, last links	624,6	mm	St, last links	389,8	mm		763,8	763,8	0,2619	0,2619	533,7	10,4%	Reduction	89,6%
20		SLAB			dx	mm	215	Asx	mm2/m	1608	in B + 6d	ρx = 0,748	Mty and Mtz are moments transferred to the column under the same loading arrangement that produces VEd.	Asw/Sr prov =	5,745	mm	Stmax<= 2d ?	INVALID		Stmax<= 2d ?	VALID			200,0	200,0	1,0000	1,0000	171,4
21		h	mm	250	dy	mm	195	Asy	mm2/m	1608	in A + 6d	ρy = 0,825		St,x =	240	mm	e split =	665	mm	e split =	575	mm		200,0	200,0	1,0000	1,0000	171,4
22					d	mm	205				100ρL % =	0,786		St,y =	240	mm	C req =	444,3	mm	C req =	758,9	mm
23																	Last link @	220	mm	Last link @	525	mm		W	¬¬	¬	N	®	®®	E	®¯®	¯¯®	S	¬¯¯	¬¯¬
24		RESULTS	βVEd =	943,9	kN			vRd,c =	0,7199	N/mm2		Equation (6.47)	√				Uout =	5318	mm	Uout =	6897	mm		0	0	0	0	0	1	1	0	0	0	0	0
25			At col. face, vEd =	3,214	N/mm2			At 2d perimeter, vEd,red =	1,2272	N/mm2	0,8522938593		√	2nd link =	205	from col face	2nd link =	210	from col face	2nd link =	205	from col face		0	0	0	0	0	1	1	0	0	0	0	0
26								Uout required =	6395	(≈ 832 from col face)		Equation (6.54)		Last link at	415	mm from face	Last link at	320	mm from face	Last link at	520	mm from face		0	0	0	0	1	1	1	0	0	0	0	0
27														Uout =	5492	mm	Uout =	5318	mm	Uout =	6646	mm		0	0	0	0	1	1	1	0	0	0	0	0
28		SOLUTION	Fig 6.22 (A)											No solution	0		No solution	0	379,2	ok	1	228,7		0,0	0,0	0,0	0,0	0,0	322,0	112,9	0,0	0,0	0,0	0,0	0,0
29			12 link spurs of 5B8 @ 105				60	links						Legs	4	per spur	Legs	3	per spur	Legs	5	per spur		0,0	0,0	0,0	0,0	0,0	442,8	90,9	0,0	0,0	0,0	0,0	0,0
30			.										√	Links per spur =	5	No								0,0	0,0	0,0	0,0	0,0	0,0	171,4	0,0	0,0	0,0	0,0	0,0
31			St =	175,7	mm	Sr =	105	mm						Spur length =	420	mm	C req	745		C req	730			0,0	0,0	0,0	0,0	0,0	0,0	171,4	0,0	0,0	0,0	0,0	0,0
32			Asw/Sr req =	5,690		(6.52) & (9.11)								Spurs =	12	No	C req (hole)	865		C req (hole)	849
33			Asw/Sr prov =	5,745	mm									Sr =	105	mm	Uout 1	8104		Uout 1	6646
34			First link perimeter	100	mm from column face									C + a	See Fig 6.22B		C + a	547		C + a	832
35			Outer links at	520	mm from column face									CHECKS						Extra 12 spurs of	0	legs
36			Uout =	6646	mm > 6 395 mm			SPUR						0
37		See GEOMETRY page for link locations.						PLAN						0
38		Some links shown may need to be re-located to avoid holes.												0
39														0
40
41		ß factors	U1 =	4176										Rows	Side	OK?
42			W1y =	1755621	C1/C2 =	1	Ky =	0,6	ßy =	1,052				4	983,9	N
43			W1z =	1755621	C1/C2 =	1	Kz =	0,6	ßz =	1,014				8	184,4
44									combined ß =	1,069				12	-82,0
45														16	-215,3
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100