Bolt Group Eccentric Shear Connection Analysis Spreadsheet (www.theengineeringcommunity.org).xls

	A	B	C	D	E	G	H	I	J	K	L	O
1	COMPANY NAME			Project:	Project name			Engineer:		YP	Project #	BoltGroup
2	AND ADDRESS				Location			Date:		25-avr.		Copyright © 2007
3		BoltGroup		Subject:	description of problem			Checker:			Page:	www.yakpol.net
4		Copyright © 2007						Date:				Version 2007.1
5
6	BOLT GROUP ECCENTRIC SHEAR CONNECTION ANALYSIS											Licensed to:
7	The following calculations comply with AISC Manual 13th Edition											15-day Demo
8	Units:	US
9		Applied Forces				Force Resultant:		Total force Pu =	#NAME?	#NAME?
10	Start Location		Direction	Value				Px = SPcos(b) =	#NAME?	#NAME?
11	X	Y	b	P				Py = SPsin(b) =	#NAME?	#NAME?
12	#NAME?	#NAME?	deg	#NAME?				b =	#NAME?	deg
13	5	1	240	70				Moment about CG , MCG =	#NAME?	#NAME?
14	6	4	130	30				Eccentricity to CG, e = MCG/Pu =	#NAME?	#NAME?
15								Xp = Xc+ e*sin(b) =	#NAME?	#NAME?
16								Yp = Yc-e*cos(b) =	#NAME?	#NAME?
17						Bolt Group:		Nbolts =	6	( < 100)
18							Center Gravity (CG)		Instantaneous Center (IC)
19						XC =	#NAME?	#NAME?	XIC =	#NAME?	#NAME?
20						YC =	#NAME?	#NAME?	YIC =	#NAME?	#NAME?
21								Bolt group shear capacity:
22							LRFD method: fP =	#NAME?	#NAME?
23							Elastic method: fP =	#NAME?	#NAME?		#NAME?
24		Add torque =	0	#NAME?
25
26		Bolt type:	A325 SH, 3/4" Dia.
27		Bolt capacity fRn =	19,4	#NAME?
28
29		Bolt Location
30	Bolt No.	X	Y
31	(<= 100)	#NAME?	#NAME?
32	1	10	10
33	2	13	10
34	3	16	10
35	4	10	13
36	5	13	13
37	6	16	13
38
39
40
41
42
43
44
45
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