Shackle Calculations (www.theengineeringcommunity.org).xlsm

	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W
1
2		G-4163
3	PARTNUMBER	WORKING	DIAMETER	DIAMETER	DIAMETER	WIDTH	WIDTH	LENGTH	WIDTH	LENGTH	LENGTH	WIDTH	THICKNESS	WEIGHT
4		LOAD	BOW	PIN	EYE	EYE	INSIDE	INSIDE	BOW		BOLT	BOW	NUT	EACH
5		LIMIT
6		SWL		dpin	Fld		JW	Length
7			a	b	c	d	e	f	g	h	i	j	k
8		tons	mm	mm	mm	mm	mm	mm	mm	mm	mm	mm	mm	kg
9	GPGHMB06	0,5	7	8	17	7	12	29	20	54	43	37	4	0,06
10	GPGHMB08	0,75	9	10	21	9	13,5	32	22	61	51	42	5	0,11
11	GPGHMB10	1	10	11	23	10	17	36,5	26	71	61	49	8	0,16
12	GPGHMB11	1,5	11	13	26	11	19	43	29	80	68	54	11	0,22
13	GPGHMB13	2	13,5	16	34	13,5	22	51	32	91	83	63	13	0,42
14	GPGHMB16	3,25	16	19	40	16	27	64	43	114	99	79	17	0,74
15	GPGHMB19	4,75	19	22	47	19	31	76	51	136	115	94	20	1,18					Calculation details
16	GPGHMB22	6,5	22	25	53	22	36	83	58	157	131	107	23	1,77			1	85	1	1500	1	1500
17	GPGHMB25	8,5	25	28	60	25	43	95	68	176	151	124	25	2,58			2	55	2	1250	2	1250
18	GPGHMB28	9,5	28	32	67	28	47	108	75	197	167	137	28	3,66			3	42,5	3	1000	3	1000
19	GPGHMB32	12	32	35	74	32	51	115	83	218	179	154	31	4,91			4	35	4	900	4	900
20	GPGHMB35	13,5	35	38	80	35	57	133	92	240	198	170	34	6,54			5	25	5	800	5	800
21	GPGHMB38	17	38	42	89	38	60	146	99	262	202	183	19	8,19			6	17	6	700	6	700
22	GPGHMB45	25	45	50	104	45	74	178	126	314	244	226	24	14,22			7	13,5	7	600	7	600
23	GPGHMB50	35	50	57	111	50	83	197	138	358	270	250	27	19,85			8	12	8	500	8	500
24	GPGHMB57	42,5	57	65	134	57	95	222	160	414	302	287	30	28,33			9	9,5	9	400	9	400
25	GPGHMB65	55	65	70	145	65	105	260	180	463	330	329	33	39,59			10	8,5	10	300	10	300
26	GPGHMB75	85	75	83	163	75	127	329	190	556	376	355	40	62			11	6,5	11	250	11	250
27																	12	4,75	12	200	12	200
28																	13	3,25	13	150	13	150
29		P-6036															14	2	14	120	14	125
30	PARTNUMBER	WORKING	DIAMETER	DIAMETER	DIAMETER	WIDTH	WIDTH	LENGTH	WIDTH	LENGTH	LENGTH	WIDTH	THICKNESS	WEIGHT			15	1,5			15	75
31		LOAD	BOW	PIN	EYE	EYE	INSIDE	INSIDE	BOW		BOLT		NUT	EACH			16	1			16	55
32		LIMIT															17	0,75			17	40
33			a	b	c	d	e	f	g	h	i	j	k				18	0,5
34		tons	mm	mm	mm	mm	mm	mm	mm	mm	mm	mm	mm	kg
35	HDGPHM0120	120	95	95	215	89	144	381	238	667	440	416	50	110								See the Comment
36	HDGPHM0150	150	105	108	245	100	165	400	275	702	490	485	60	160								#REF!
37	HDGPHM0200	200	120	130	288	110	175	500	290	854	520	530	60	235
38	HDGPHM0250	250	130	140	308	115	200	540	305	921	560	565	65	285
39	HDGPHM0300	300	140	150	335	120	200	600	305	1018	575	585	70	340
40	HDGPHM0400	400	170	175	387	160	225	650	325	1137	690	665	70	560
41	HDGPHM0500	500	180	185	410	160	250	700	350	1213	710	710	70	685
42	HDGPHM0600	600	200	205	458	185	275	700	375	1267	810	775	70	880
43	HDGPHM0700	700	210	215	468	200	300	700	400	1287	850	820	70	980
44	HDGPHM0800	800	210	220	478	200	300	700	400	1294	870	820	70	1100
45	HDGPHM0900	900	220	230	500	210	320	700	420	1320	920	860	70	1280
46	HDGPHM1000	1000	240	240	530	210	340	700	420	1360	940	900	70	1460
47	HDGPHM1250	1250	260	270	600	225	360	700	450	1430	1020	970	70	1990
48	HDGPHM1500	1500	280	290	640	225	360	700	450	1480	1060	1010	70	2400
49
50
51		P-6033
52	PARTNUMBER	WORKING	DIAMETER	DIAMETER	DIAMETER	WIDTH	WIDTH	LENGTH	WIDTH	LENGTH	WIDTH	WIDTH	THICKNESS	WEIGHT
53		LOAD	BODY	PIN	EYE	EYE	INSIDE	INSIDE	BOW				NUT	EACH
54		LIMIT
55			a	b	c	d	e	f	g	h	i	j	k
56		tons	mm	mm	mm	mm	mm	mm	mm	mm	mm	mm	mm	kg
57	SLGPF0040	40	55	51	109	45	80	200	140	331	252	235	38	22
58	SLGPF0050	55	60	57	115	55	95	250	160	396	304	270	45	50
59	SLGPF0075	75	70	70	140	70	105	290	186	467	359	345	54	67
60	SLGPF0125	125	85	80	155	85	130	365	220	569	428	410	64	103
61	SLGPF0150	150	94	95	180	89	140	390	250	627	441	455	50	160
62	SLGPF0200	200	110	105	200	100	150	480	276	744	474	508	50	220
63	SLGPF0250	250	126	120	228	110	170	540	300	842	528	600	60	320
64	SLGPF0300	300	135	134	245	122	185	600	350	926	594	620	70	350
65	SLGPF0400	400	160	160	295	145	220	575	370	964	686	715	80	635
66	SLGPF0500	500	170	180	330	160	250	680	450	1107	763	810	90	803
67	SLGPF0600	600	190	200	350	170	275	740	490	1207	828	913	100	980
68	SLGPF0700	700	200	215	392	190	300	750	540	1257	878	993	100	1260
69	SLGPF0800	800	218	230	420	200	325	850	554	1395	959	986	110	1430
70	SLGPF0900	900	242	255	466	220	350	850	584	1454	1040	1050	120	1650
71	SLGPF1000	1000	260	270	490	240	380	855	614	1497	1116	1176	120	2120
72	SLGPF1250	1250	285	300	510	260	430	930	650	1620	1193	1275	150	2400
73	SLGPF1500	1500	295	320	550	280	460	950	680	1710	1278	1350	160	3600
74
75					a=	20											a	70
76					b=	0,45											b	0,45
77	Shackle Type	SWL	Fld	x	xestm	Difference	%age			SWL	dpin	dhole	JW	Tm	a	B	Est. B	Difference	%age
78	G-4163	0,5	17	12,75	14,64085696	1,890856959	1,148302507			0,5	8	11	12	13	27	65	51	-14	-27%
79	G-4163	0,75	21	15,75	17,57144851	1,821448509	1,115647524			0,75	10	13	13,5	13	27	70	62	-8	-14%
80	G-4163	1	23	17,25	20	2,75	1,15942029			1	11	14	17	13	27	70	70	0	0%
81	G-4163	1,5	26	19,5	24,00330603	4,503306032	1,230938771			1,5	13	16	19	14,25	29,5	75	84	9	11%
82	G-4163	2	34	25,5	27,32080514	1,820805135	1,071404123			2	16	19	22	16,5	34	90	96	6	6%
83	G-4163	3,25	40	30	33,99206183	3,992061835	1,133068728			3,25	19	22	27	20,25	41,5	105	119	14	12%
84	G-4163	4,75	47	35,25	40,32200508	5,072005079	1,143886669			4,75	22	25	31	23,25	47,5	120	141	21	15%
85	G-4163	6,5	53	39,75	46,43452488	6,684524876	1,168164148			6,5	25	28	36	27	55	140	163	23	14%
86	G-4163	8,5	60	45	52,39242643	7,392426431	1,164276143			8,5	28	31	43	32,25	65,5	165	183	18	10%
87	G-4163	9,5	67	50,25	55,08148217	4,831482171	1,096148899			9,5	32	35	47	35,25	71,5	180	193	13	7%
88	G-4163	12	74	55,5	61,18733759	5,687337588	1,102474551			12	35	38	51	38,25	77,5	195	214	19	9%
89	G-4163	13,5	80	60	64,51789531	4,517895311	1,075298255			13,5	38	41	57	42,75	86,5	215	226	11	5%
90	G-4163	17	89	66,75	71,57016365	4,820163654	1,07221219			17	42	45	60	45	91	230	250	20	8%
91	G-4163	25	104	78	85,13399225	7,133992252	1,091461439			25	50	53	74	55,5	112	280	298	18	6%
92	G-4163	35	111	83,25	99,0513994	15,8013994	1,189806599			35	57	60	83	62,25	125,5	315	347	32	9%
93	P-6033	40	109	81,75	105,1857703	23,43577031	1,286676089			40	51	54	80	60	121	300	368	68	19%
94	G-4163	42,5	134	100,5	108,0948527	7,594852733	1,075570674			42,5	65	68	95	71,25	143,5	355	378	23	6%
95	G-4163	55	145	108,75	121,3928775	12,64287746	1,116256344			55	70	73	105	78,75	158,5	390	425	35	8%
96	P-6033	55	115	86,25	121,3928775	35,14287746	1,407453652			55	57	60	95	71,25	143,5	350	425	75	18%
97	P-6033	75	140	105	139,5749768	34,57497675	1,329285493			75	70	73	105	78,75	158,5	390	489	99	20%
98	G-4163	85	163	122,25	147,6619204	25,41192038	1,207868469			85	83	86	127	95,25	191,5	470	517	47	9%
99	P-6036	120	215	161,25	172,4493479	11,19934787	1,06945332			120	95	98	144	108	217	535	604	69	11%
100	P-6033	125	155	116,25	175,6465005	59,39650049	1,510937639			125	80	83	130	97,5	196	475	615	140	23%