ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
F.O.S
2
Bearing on Plate @ Pin@ Pinbelow Pin
3
#DIV/0!Shear, 0,05Shear, 0,04F.O.S
4
Welds for Lug LayoutTension, 0,13Tension, 0,19F.O.S
5
0,18Comb, 0,13Comb, 0,17#DIV/0!
6
7
The User is to Please note this Lifting Lug Design Spreadsheet uses and references the DESIGN FACTORS given inRev 1.5Grade0.33Fu
weld size
8
ENGINEERING REFERENCE DOCUMENT, Manual: Guidelines for Lifting Points and Heavy Lift Criteria, (Doc â„–: EM/039 Rev 3)User Input33161/4
9
by Shell UK Exploration and Production Dated 1991.36 5/16
10
the user is directed to read this document for anything other than for LIGHT Packages.503/8
11
FRAME LIFTING LUG (ASSUMES 4 LIFT LUGS)YES 7/16
12
NO1/2
13
JOB/ITEM NO. :1234
14
CLIENT :Siemens
15
PLANT LOCATION :PUK 3
16
ENGINEER :prCIChecked :1. STRESSES BASED ON AISC-ASD
17
Date :06/22/09aRevision :A2. DESIGN LOADS HAVE BEEN
18
INPUT IN SHADED GREEN & RED AREAS INCREASED BY DESIGN FACTOR.
19
TOTAL LIFTED LOAD20kips
Considered a LIGHT Package!
20
PLATE THICK t=1,500inches
21
PLATE WIDTH b=6,000inches
22
HOLE DIAM DIA=1,700inches
Warning, Confirm Dia size for propsed Shackle, see tab below
1
23
PLATE RADIUS4,000inchesDESIGN FACTOR made up from
24
BOTTOM OF PLATE TO TOP OF FRAME d=2,50inches1,25Dynamic Impact factor (Fh)
25
TOP OF FRAME TO CENTER OF RADIUS h=2,75inches1,05Consequence factor
26
FY36,00ksi1,03Weight factor 19,1
27
SLING ANGLE W/ HORIZONTAL60deg1,03Tilt & Yaw factor1
28
FILLET WELD SIZE0,438
of an inch
1,00Skew Load factor (Heavy lifts only!)factor for welds
29
DESIGN FACTOR1,401,40Generally Accepted Min Design Factor1,43
30
ASSUME OUT OF PLANE LOADING5%1
31
DO YOU INTEND TO USE A SPREADER BAR?YES
Loads Proportioned for 0.6 x Total Lift Load per pair of lugs
1,2
32
DESIGN LOAD PER LIFTING LUG Pvert =8,40kips
33
DESIGN LOAD PER LIFTING LUG Ph =4,85kips
these are factored SWL
34
Sling Load = Shackle SWL =9,70kipsLUG LAYOUT
35
CHECK STRESS IN HORZ. PLANE AT PINASD cl ref
36
NET AREA An=(b-DIA)*t6,45in2
37
NET SECTION Sxn=t*b2/6-t*DIA2/68,28in3
38
Syn=(b-DIA)*(t2)/61,61in3
39
SHEAR fv = Ph/An0,75ksi
40
SHEAR RESULTANT fvr =(fv2+(PER/100*fv)2)0.50,75ksi
41
SHEAR ALLOWABLE Fv = 0.4Fy14,40ksi(EQU, F4-1)
42
SHEAR STRESS RATIO0,051
43
44
TENSION ft = Pvert/An1,30ksi
45
IN PLANE BENDING STRESS = 0
46
OUT OF PLANE fbo = PER/100*b*Pvert/Syn1,56ksi
47
RESULTANT AXIAL STRESS far = ft + fbo2,87ksi
48
TENSION ALLOWABLE Ft = 0.6Fy21,60ksi(EQU, D1)
49
TENSION STRESS RATIO0,131
50
COMBINED STRESS f = (far2+3*fvr2)0.53,15ksi #
51
COMBINED STRESS ALLOW Fa = 0.66Fy23,76ksiNOTE : this is for a welded side plate, for top welded
52
COMBINED STRESS RATIO @ PIN0,13lugs d = the plate thickness!!1
53
CHECK BEARING ON PLATE AT PIN
54
SHACKLE PIN DIAMETER from Crosby Tab below1,5inchesPIN SWL = 34,00kips, Shackle Pin Dia OK!
55
SHACKLE PIN DIAMETER = DIA1, User Input4inchesWarning! Ch'k & confirm Pin size for adequacy!
56
BEARING AREA Ap = DIA1*t0,000in2Note: In General FPBW are required
57
BEARING STRESS fp = SL/Ap#DIV/0!ksi
for all but light lifts!! & recommended
58
BEARING STRESS ALLOW = 0.9FY32,40ksi(EQU, J8-1)min safety factor of 2.0 applied.
59
BEARING STRESS RATIO#DIV/0!
DESIGN WELD SIZE BASED ON 0.33Fu = 19,1 ksi
min FW#DIV/0!
60
AND ELASTIC METHOD
size for
61
CHECK STRESS IN PLANE BELOW PINe =4,196e=((d/2)*2*d+2*b+d*b)/(2*d+3*b)+hplate thk.
Rev 1.5, min weld size fixed!
62
AREA A=b*t9,00in2Lw =23,00Lw=2*(b+d)+b0,3125
63
SECTION Sx=t*b2/69,00in3Ix =34,35Ix=2*b*(e-h)2+b*(d-(e-h))2+2*d3/12
64
Sy=b*(t2)/62,25in3Iy =99,00Iy=2*d*(b/2)2+3*b3/12
65
SHEAR fv = Ph/A0,54ksiIp =133,35Ip=Ix+Iy
66
SHEAR RESULTANT fvr =(fv2+(PER/100*fv)2)0.50,54ksi fx =,09fx=Pvert*PER/100*e*d/2/Ix, (see ##)
67
SHEAR ALLOWABLE Fv = 0.4Fy14,40ksif'x =0,30f'x=Ph/Lw, (see ##)
68
SHEAR STRESS RATIO0,04f"x =0,16f"x=(Ph*e*(d-(e-h)))/Ip, (see ##)1
69
f'y =0,52f'x=Pvert/Lw, (see ##)
70
TENSION ft = Pvert/A0,93ksif"y =0,65f"y=(Ph*e*b/2)/Ip, (see ##)
71
IN PLANE BENDING STRESS = Ph*h/Sx1,48ksif =1,27f=SQRT((f'x+f"x)2+(f'y+f"y)2+fx2)
72
OUT OF PLANE fbo = PER/100*b*Pvert/Sy1,63ksi0,077Weld Size=f/(19,1*SIN(60*PI()/180))
73
RESULTANT AXIAL STRESS far = ft + fbo4,05ksi0,438
74
TENSION ALLOWABLE Ft = 0.6Fy21,60ksiWeld Size =7/16INCHES1
75
TENSION STRESS RATIO0,19S.R. =0,18## (design factor of 2 used)2,001
76
COMBINED STRESS f = (far2+3*fvr2)0.54,15ksi #Weld f.o.s =11,78
77
COMBINED STRESS ALLOW Fa = 0.66Fy23,76ksi#DIV/0!#DIV/0!
78
COMBINED STRESS RATIO BELOW PIN0,171
79
The min Factor of Safety for the design as notedF.O.S =#DIV/0!Must Comply with the requirements of ASME#DIV/0!
80
BTH-1-2005 Chapter 3-1.2#DIV/0!#DIV/0!
81
NOTE: for Category A lifts, Min F.O.S is 2.0 - 2.5 for lug and for Category B lifts, Min F.O.S is 3.0 - 3.6 for the lug.
82
Additional Notes # - the formula used to combine these stresses is equ (3-37) from ASME BTH-1-2005 with fy =0
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100