Bolted Connection Angle Brace Tension (www.theengineeringcommunity.org).xlsx

	B	C	D	E	F	G	H	I	J	K	L	M	O	P	Q	R	S	T	U	V	W
1
2			Project:						Doc. n.:
3
4			Decription:						Rev.:		date
5	Bolted connection fo an angle brace in tension to a gusset plate
6	ELEMENTO :	#VALUE!
7	Material			S275JR		Partial safety factor
8			ft	430	MPa		gM0 =	1,05
9			fy	275	MPa		gM1 =	1,05						t<40	fy	fu	β
10			fd	262	MPa		gM2 =	1,25						S235JR	235	360	0,8
11			E	206000	MPa									S275JR	275	430	0,85
12	Gusset plate and angle													S355JR	355	510	0,9
13	Depth of gusset		hS1-S1 =	185	mm	185								40<t<80
14	Thickness of gusset		s =	15	mm									S235JR	210	360
15	Eccentricity		e =	20	mm									S275JR	250	410
16	Profile			L 120 x 80 x 12										S355JR	315	470
17	Depth		h	120	mm
18	Width		b	80	mm
19	Thickness		t	12,0	mm								pl thk	15,0
20	Area		A	22,7	cm2								profilo thk	12,0
21	Centre of gravity		Zs	40,04	mm													most economic section		ratio	weight
22			Ys	20,28	mm													1	L 15 x 15 x 3		0,6
23	Bolt grade			8,8														2	L 20 x 20 x 4		1,1
24	Yield strength		fyb =	640	Mpa													3	L 25 x 25 x 5		1,8
25	Ultimate tensile strength		fub =	800	Mpa													4	L 40 x 40 x 5		3,0
26																		5	L 45 x 45 x 6		4,0
27	Bolts			M20
28	Tensile stress area		Ares =	245	mm²																1
29	Diameter of the shank		d =	20	mm						#REF!							1	1	L 15 x 15 x 3
30	Diameter of the holes		do=	22	mm													2	1	L 20 x 20 x 4
31	factor				0,6													3	1	L 25 x 25 x 5
32	Shear resistance		FVRd=avfubAs/gM2 =		94	kN												4	1	L 40 x 40 x 5
33	Bolt geometry																	5	1	L 45 x 45 x 6
34	Pitch between bolt rows		dx =	80	mm													6	1	L 50 x 50 x 6
35	Number of bolt rows		nbxy =	3														7	1	L 60 x 60 x 5
36	ULS design force																	8	1	L 60 x 60 x 6
37	Axial tensile force		Fxt =	250,0	kN													9	1	L 75 x 50 x 6
38																		10	1	L 70 x 70 x 6
39	Bolts in shear																	11	1	L 55 x 55 x 8
40	shear section		nT =		1													12	1	L 75 x 50 x 7
41	factor		f = 6(nb-1)/[nb(nb+1)] =		1,0													13	1	L 65 x 65 x 7
42	max vertical force		Ry = F·Fx·e/Sdxi		31	kN												14	1	L 60 x 60 x 8
43	max orizontal force		Rx = Fx/nb		83	kN												15	1	L 80 x 80 x 6
44	max shear		R = (Rx2+Ry2)1/2 =		89	kN												16	1	L 80 x 60 x 7
45	max shear on section		FvSd = R/nT =		89	kN				f.r.								17	1	L 70 x 70 x 7
46	check		FVSd < FVRd		89	kN	<	94,1	kN	0,95		OK						18	1	L 90 x 90 x 6
47	Bolts in bearing																	19	1	L 75 x 50 x 9
48	thk		s =		15	mm												20	1	L 80 x 60 x 8
49			tTa = s		15	mm												21	1	L 80 x 80 x 7
50	thk of angle		t =		12,0	mm												22	1	L 65 x 65 x 9
51	number of angle		n =		1													23	1	L 60 x 60 x 10
52	total thk		tTb = n*t		12	mm												24	1	L 100 x 65 x 7
53	angle edge to first orw		e1 =		50	mm	(min.)											25	1	L 100 x 50 x 8
54	pitch		p1 =		80	mm	(min.)											26	1	L 100 x 100 x 6
55	angle leg edge to bolt line		e2 =		60	mm	(ok)											27	1	L 70 x 70 x 9
56	pitch		p2 =			mm												28	1	L 90 x 90 x 7
57	diameter of holes		do =		22	mm												29	1	L 80 x 80 x 8
58	calculation factor k1a = min(2.8e2/d0-1.7;2.5) =				2,50													30	1	L 80 x 60 x 10
59	calculation factor k1b = min(1.4p2/d0-1.7;2.5) =				2,50													31	1	L 100 x 100 x 7
60	calculation factor k1 = min(k1a;k1b) =				2,50													32	1	L 120 x 60 x 8
61	calculation factor ada = e1/3d0 =				0,76													33	1	L 90 x 90 x 8
62	calculation factor adb =p1/3d0-1/4 =				0,96								CNR					34	1	L 100 x 50 x 10
63	calculation factor ab = min(ad;fub/fu;1)				0,76								2d=40mm	OK				35	1	L 100 x 65 x 9
64	bearing strength		FbRd.a = k1αbfudTa /gM2 =		195	kN							3d=60mm	OK				36	1	L 110 x 75 x 8	0,98
65	bearing strength		FbRd.b = k1αbfudTb /gM2 =		156	kN				f.r.			1.5d=30mm	OK				37	1	L 70 x 70 x 11
66	check		TbSd < FbRd		89	kN	<	156	kN	0,57		OK	3d=60mm					38	1	L 130 x 65 x 8	0,94
67	Resistance of gusset and angle																	39	1	L 80 x 80 x 10	0,95
68	Gusset check																	40	1	L 100 x 100 x 8	0,96
69	Gross area		A = h1 s		28	cm2												41	1	L 100 x 100 x 8	0,96
70	net area		An = (A - do s)		24	cm2												42	1	L 120 x 80 x 8	0,96
71	resistance		NuRd = 0.9 An fu/gM2 =		756	kN				f.r.								43	1	L 90 x 90 x 9	0,94
72	check				250	kN	<	755,8	kN	0,33		OK						44	1	L 100 x 65 x 11	0,92
73	Angle check																	45	1	L 120 x 60 x 10	0,93
74	Gross area		A =		22,7	cm2												46	1	L 110 x 75 x 10	0,94
75	net area		An = (A - do t)		20,1	cm2												47	1	L 80 x 80 x 12	0,92
76	Plastic resistance		NplRd = A fy/gM0 =		594	kN												48	1	L 130 x 65 x 10	0,94
77	tension resistance		NuRd = 0.9 An fu/gM2 =		621	kN				f.r.								49	1	L 120 x 120 x 8	1,00
78	check		Fxt < min(NplRd;NuRd)		250	kN	<	594	kN	0,42		OK						50	1	L 90 x 90 x 11	0,94
79	Verifica per block shear tearing																	51	1	L 100 x 100 x 10	0,96
80	traction boundary		pt =		49	mm												52	1	L 120 x 80 x 10	0,95
81	shear boundary		ps =		210	mm												53	1	L 120 x 120 x 9	1,00
82	traction area		At = (n s pt)		1176	mm2												54	1	L 110 x 110 x 10	0,97
83	shear area		As = (n s ps)		5040	mm2												55	1	L 90 x 90 x 13	0,94
84	Block Tearing resistance																	56	1	L 130 x 65 x 12	0,93
85	FteRd = 0.5 fu At/gM2+1/(31/2) fy As/gM1				964	KN				f.r.								57	1	L 100 x 100 x 12	0,95
86	check		FteSd = Fxt < FteRd		250		<	964	kN	0,26		OK						58	1	L 120 x 80 x 12	0,95
87	Angle in tension																	59	1	L 120 x 120 x 10	0,99
88	1 bolt		NuRd = 2(e2-0.5d0)t* fu/gM2 =		405	kN							reduction factor for bolted joints					60	1	L 150 x 90 x 10	0,98
89			β2		0,54								pitch p1 is:	£ 2.5 d0	≥ 5 d0	3,64		61	1	L 160 x 80 x 10	0,97
90	2 bolts		NuRd = β2Anet fu/gM2 =		370	kN							2 bolts	0,4	0,7	0,54		62	1	L 150 x 100 x 10	0,99
91			β3		0,59								3 bolts	0,5	0,7	0,59		63	1	L 90 x 90 x 15	0,93
92	3 or more bolts		NuRd = β3Anet fu/gM2 =		408	kN				f.r.								64	1	L 110 x 110 x 12	0,97
93	check		Fxt < NuRd		250,0	kN	<	408	kN	0,61		OK						65	1	L 120 x 120 x 11	0,99
94																		66	1	L 150 x 90 x 11	0,98
95										0,95								67	1	L 200 x 90 x 9
96																		68	1	L 120 x 80 x 14	0,94
97																		69	1	L 100 x 100 x 14	0,95
98																		70	1	L 140 x 140 x 10
99																		71	1	L 120 x 120 x 12	0,99
100																		72	1	L 160 x 80 x 12	0,96