Weldgrp - Weld Group Analysis Program
Weldgrp - Weld Group Analysis Program
Weldgrp - Weld Group Analysis Program
Program Description:
"WELDGRP" is a spreadsheet program written in MS-Excel for the purpose of analysis of weld groups using either the ultimate strength method (also known as "instantaneous center of rotation" method) or the "elastic" (vector) method ("Alternate Method 1" in AISC Manual). A separate worksheet contains data tables for welds. This program is a workbook consisting of eleven (11) worksheets, described as follows:
Worksheet Name
Doc Table XIX Table XX Table XXI Table XXII Table XXIII Table XXIV Table XXV Table XXVI Weld Group (elastic) Weld Data
Description
This documentation sheet Weld group instantaneous center analysis for vertical parallel welds Weld group instantaneous center analysis for horizontal parallel welds Weld group instantaneous center analysis for vertical rectangular welds Weld group instantaneous center analysis for horizontal rectangular welds Weld group instantaneous center analysis for C-shaped welds (case 1) Weld group instantaneous center analysis for C-shaped welds (case 2) Weld group instantaneous center analysis for L-shaped welds (case1) Weld group instantaneous center analysis for L-shaped welds (case 2) Weld group elastic analysis for up to 24 total weld lines and 4 load points Fillet Weld Data Tables
sequence with no "breaks" in the numerical order of input data. 9. The "Weld Group (elastic)" worksheet calculates the required weld size in terms of both fillet leg and effective throat dimensions, based on the assumption of using E70XX welding electrodes. The user should check AISC specification for limitations on minimum and maximum weld sizes. 10. This program contains numerous comment boxes which contain a wide variety of information including explanations of input or output items, equations used, data tables, etc. (Note: presence of a comment box is denoted by a red triangle in the upper right-hand corner of a cell. Merely move the mouse pointer to the desired cell to view the contents of that particular "comment box".) 11. Weld Data worksheet shows data tables for minimum size of fillet welds, allowable force on fillet welds, and intermittent fillet weld lengths and spacings.
Circular Weld Example (using elastic method): A circular weld of diameter, 'D', with its center located at 0.50*D from both the origin X and Y axes, may be modeled as 24-sided shape inscribed within the circle. The coordinates of the 24 connected segments can be described as follows: Weld Coordinates: Start Weld #1 Weld #2 Weld #3 Weld #4 Weld #5 Weld #6 Weld #7 Weld #8 Weld #9 Weld #10 Weld #11 Weld #12 Weld #13 Weld #14 Weld #15 Weld #16 Weld #17 Weld #18 Weld #19 Weld #20 Weld #21 Weld #22 Weld #23 Weld #24 X1 0 0.0170*D 0.0670*D 0.1464*D 0.2500*D 0.3706*D 0.50*D 0.6294*D 0.7500*D 0.8536*D 0.9330*D 0.9830*D 1.0*D 0.9830*D 0.9330*D 0.8536*D 0.7500*D 0.6294*D 0.50*D 0.3706*D 0.2500*D 0.1464*D 0.0670*D 0.0170*D Y1 0.50*D 0.3706*D 0.2500*D 0.1464*D 0.0670*D 0.0170*D 0 0.0170*D 0.0670*D 0.1464*D 0.2500*D 0.3706*D 0.50*D 0.6294*D 0.7500*D 0.8536*D 0.9330*D 0.9830*D 1.0*D 0.9830*D 0.9330*D 0.8536*D 0.7500*D 0.6294*D End X2 Y2 0.0170*D 0.3706*D 0.0670*D 0.2500*D 0.1464*D 0.1464*D 0.2500*D 0.0670*D 0.3706*D 0.0170*D 0.50*D 0 0.6294*D 0.0170*D 0.7500*D 0.0670*D 0.8536*D 0.1464*D 0.9330*D 0.2500*D 0.9830*D 0.3706*D 1.0*D 0.50*D 0.9830*D 0.6294*D 0.9330*D 0.7500*D 0.8536*D 0.8536*D 0.7500*D 0.9330*D 0.6294*D 0.9830*D 0.50*D 1.0*D 0.3706*D 0.9830*D 0.2500*D 0.9330*D 0.1464*D 0.8536*D 0.0670*D 0.7500*D 0.0170*D 0.6294*D 0 0.50*D
Input Data: Vertical Weld Length = Spacing of Welds = Weld Size, w = Vertical Load, Pv = Horizontal Load, Ph = Dist. from Pv to C.G. = Use Special Case? Nomenclature: 8.000 4.000 1/4 22.00 0.00 6.000 No
in. in. in. = 4 (1/16's) kips kips in.
aL=6
q =0
P=Pv
L= 8.000
C.G.
Ph=0
(kL)/2 kL= 4
(kL)/2
Pv
P = Pv = C*C1*D*L (for vertical load only) P = allowable load on eccentric weld group (kips) C = coefficient interpolated from Table XIX C1 = coefficient for electrode, use 1.0 for E70XX D = number of 1/16's of an inch (weld size) L = vertical weld length
q
aL P L Ph
eq. spaces
Results: L= kL = aL = a= k= C1 = C= P= Angle q = Co = C(max) = A= Ca/Co = Ca = D(req'd) = L(req'd) = 8.000 4.000 6.000 0.750 0.500 1.0 0.712 22.00 0.000 N.A. N.A. N.A. N.A. N.A. 3.862 7.725
in. in. in.
kips deg.
1/16's in.
(Note: AISC Alternate Method 2 is not used for P=Pv) L = vertical weld length kL = spacing of vertical welds aL = dist. from Pv to C.G. a = (aL)/L k = (kL)/L C1 = 1.0 for E70XX electrode (interpolated from Table XIX, page 4-75) P = SQRT(Pv^2+Ph^2) q = 90-(ATAN(Pv/Ph)) Co = C (from AISC Table XIX, page 4-75) C(max) = 0.928*(2) A = C(max)/Co >= 1.0 Ca/Co = A/(SINq+A*COSq) >= 1.0 Ca = (Ca/Co)*Co D(req'd) = P/(C*C1*L) L(req'd) = P/(C*C1*D) Weld is adequate! D(req'd) = 3.862 <= 4 (1/16's) L(req'd) = 7.725 <= 8 in.
3 of 16
3/12/2013 4:00 AM
Pv=27.4 k aL=10
q= 0
P=Pv
kL = 5.000
C.G.
Ph=0 L = 10
Results: L= kL = aL = a= k= C1 = C= P= Angle q = Co = C(max) = A= Ca/Co = Ca = D(req'd) = L(req'd) = 10.000 5.000 10.000 1.000 0.500 1.0 0.553 27.40 0.000 N.A. N.A. N.A. N.A. N.A. 4.955 8.258
in. in. in.
kips deg.
1/16's in.
(Note: AISC Alternate Method 2 is not used for P=Pv) L = horizontal weld length kL = spacing of horiz. welds aL = dist. from Pv to C.G. a = (aL)/L k = (kL)/L C1 = 1.0 for E70XX electrode (interpolated from Table XX, page 4-76) P = SQRT(Pv^2+Ph^2) q = 90-(ATAN(Pv/Ph)) Co = C (from AISC Table XX, page 4-76) C(max) = 0.928*(2) A = C(max)/Co >= 1.0 Ca/Co = A/(SINq+A*COSq) >= 1.0 Ca = (Ca/Co)*Co D(req'd) = P/(C*C1*L) L(req'd) = P/(C*C1*D) Weld is adequate! D(req'd) = 4.955 <= 6 (1/16's) L(req'd) = 8.258 <= 10 in.
4 of 16
3/12/2013 4:00 AM
Vertical Weld Length = Horiz. Weld Length = Weld Size, w = Vertical Load, Pv = Horizontal Load, Ph = Dist. from Pv to C.G. = Nomenclature:
Pv=76 k
q= 0
P=Pv L= 10.000
C.G.
Ph=0
P = Pv = C*C1*D*L (for vertical load only) P = allowable load on eccentric weld group (kips) C = coefficient interpolated from Table XXI C1 = coef. for electrode, use 1.0 for E70XX D = number of 1/16's of an inch (weld size) L = vertical weld length
kL= 5
Results: L= kL = aL = a= k= C1 = C= P= Angle q = Co = C(max) = A= Ca/Co = Ca = D(req'd) = L(req'd) = 10.000 5.000 10.000 1.000 0.500 1.0 0.951 76.00 0.000 N.A. N.A. N.A. N.A. N.A. 7.992 9.989
in. in. in.
kips deg.
1/16's in.
(Note: AISC Alternate Method 2 is not used for P=Pv) L = vertical weld length kL = horizontal weld length aL = dist. from Pv to C.G. a = (aL)/L k = (kL)/L C1 = 1.0 for E70XX electrode (interpolated from Table XXI) P = SQRT(Pv^2+Ph^2) q = 90-(ATAN(Pv/Ph)) Co = C (from AISC Table XXI) C(max) = 0.928*(2+2*k) A = C(max)/Co >= 1.0 Ca/Co = A/(SINq+A*COSq) >= 1.0 Ca = (Ca/Co)*Co D(req'd) = P/(C*C1*L) L(req'd) = P/(C*C1*D) Weld is adequate! D(req'd) = 7.992 <= 8 (1/16's) L(req'd) = 9.989 <= 10 in.
5 of 16
3/12/2013 4:00 AM
Ph=0 L = 10
Results: L= kL = aL = a= k= C1 = C= P= Angle q = Co = C(max) = A= Ca/Co = Ca = D(req'd) = L(req'd) = 10.000 5.000 11.000 1.100 0.500 1.0 0.802 68.00 0.000 N.A. N.A. N.A. N.A. N.A. 8.479 10.599
in. in. in.
kips deg.
1/16's in.
(Note: AISC Alternate Method 2 is not used for P=Pv) L = horizontal weld length kL = vertical weld length aL = dist. from Pv to C.G. a = (aL)/L k = (kL)/L C1 = 1.0 for E70XX electrode (interpolated from Table XXII) P = SQRT(Pv^2+Ph^2) q = 90-(ATAN(Pv/Ph)) Co = C (from AISC Table XXII) C(max) = 0.928*(2+2*k) A = C(max)/Co >= 1.0 Ca/Co = A/(SINq+A*COSq) >= 1.0 Ca = (Ca/Co)*Co D(req'd) = P/(C*C1*L) L(req'd) = P/(C*C1*D) Weld is overstressed! D(req'd) = 8.479 > 8 (1/16's) L(req'd) = 10.599 > 10 in.
6 of 16
3/12/2013 4:00 AM
q = 75
P=90 k
Ph=86.93 k (@ C.G.)
xL=1.25 kL=5
3.75
Results: L= kL = xL = aL = a= k= C1 = C= P= Angle q = Co = C(max) = A= Ca/Co = Ca = D(req'd) = L(req'd) = 10.000 5.000 1.250 8.750 0.875 0.500 1.0 0.704 90.000 75.002 0.704 1.856 2.636 1.600 1.126 7.993 9.991
in. in. in. in.
kips deg.
1/16's in.
(Note: AISC Alternate Method 2 is used for inclined load) L = vertical weld length kL = horizontal weld length xL = ((kL)^2/(2*kL+L)) aL = (Dist. to Pv)-(xL) a = (aL)/L k = (kL)/L C1 = 1.0 for E70XX electrode (interpolated from AISC Table XXIII, page 4-79) P = SQRT(Pv^2+Ph^2) q = 90-(ATAN(Pv/Ph)) Co = C (from AISC Table XXIII, page 4-79) C(max) = 0.928*(1+2*k) A = C(max)/Co >= 1.0 Ca/Co = A/(SINq+A*COSq) >= 1.0 Ca = (Ca/Co)*Co D(req'd) = P/(Ca*C1*L) L(req'd) = P/(Ca*C1*D) Weld is adequate! D(req'd) = 7.993 <= 8 (1/16's) L(req'd) = 9.991 <= 10 in.
7 of 16
3/12/2013 4:00 AM
Pv=23.29 k L=10
xL=1.25 kL=5
3.75
Results: L= kL = xL = aL = a= k= C1 = C= P= Angle q = Co = C(max) = A= Ca/Co = Ca = D(req'd) = L(req'd) = 10.000 5.000 1.250 8.750 0.875 0.500 1.0 0.722 90.000 75.002 0.722 1.856 2.571 1.576 1.138 7.909 9.886
in. in. in. in.
kips deg.
1/16's in.
(Note: AISC Alternate Method 2 is used for inclined load) L = vertical weld length kL = horizontal weld length xL = ((kL)^2/(2*kL+L)) aL = (Dist. to Pv)+(xL) a = (aL)/L k = (kL)/L C1 = 1.0 for E70XX electrode (interpolated from AISC Table XXIV, page 4-80) P = SQRT(Pv^2+Ph^2) q = 90-(ATAN(Pv/Ph)) Co = C (from AISC Table XXIV, page 4-80) C(max) = 0.928*(1+2*k) A = C(max)/Co >= 1.0 Ca/Co = A/(SINq+A*COSq) >= 1.0 Ca = (Ca/Co)*Co D(req'd) = P/(Ca*C1*L) L(req'd) = P/(Ca*C1*D) Weld is adequate! D(req'd) = 7.909 <= 8 (1/16's) L(req'd) = 9.886 <= 10 in.
8 of 16
3/12/2013 4:00 AM
Vertical Weld Length = Horiz. Weld Length = Weld Size, w = Vertical Load, Pv = Horizontal Load, Ph = Dist. from Pv to Weld = Nomenclature:
4.000 aL=3.69
q= 0
P=Pv
C.G.
L= 11.500
Ph=0 yL=4.56
P = Pv = C*C1*D*L (for vertical load only) P = allowable load on eccentric weld group (kips) C = coefficient interpolated from Table XXV C1 = coef. for electrode, use 1.0 for E70XX D = number of 1/16's of an inch (weld size) L = vertical weld length Results: L= kL = xL = yL = aL = a= k= C1 = C= P= Angle q = Co = C(max) = A= Ca/Co = Ca = D(req'd) = L(req'd) = 11.500 3.000 0.310 4.560 3.690 0.321 0.261 1.0 0.742 25.00 0.000 N.A. N.A. N.A. N.A. N.A. 2.930 11.231
in. in. in. in. in.
xL=0.31 kL= 3
2.69
kips deg.
1/16's in.
(Note: AISC Alternate Method 2 is not used for P=Pv) L = vertical weld length kL = horizontal weld length xL = (kL)^2/(2*(kL+L)) yL = L^2/(2*(kL+L)) aL = (Dist. to Pv)-(xL) a = (aL)/L k = (kL)/L C1 = 1.0 for E70XX electrode (interpolated from Table XXV) P = SQRT(Pv^2+Ph^2) q = 90-(ATAN(Pv/Ph)) Co = C (from AISC Table XXV) C(max) = 0.928*(1+k) A = C(max)/Co >= 1.0 Ca/Co = A/(SINq+A*COSq) >= 1.0 Ca = (Ca/Co)*Co D(req'd) = P/(C*C1*L) L(req'd) = P/(C*C1*D) Weld is adequate! D(req'd) = 2.93 <= 3 (1/16's) L(req'd) = 11.231 <= 11.5 in.
9 of 16
3/12/2013 4:00 AM
Vertical Weld Length = Horiz. Weld Length = Weld Size, w = Vertical Load, Pv = Horizontal Load, Ph = Dist. from Pv to Weld = Nomenclature:
aL=3.46 3.150
q
P=Pv
C.G.
yL=4.56
L= 11.500
Ph=0
P = Pv = C*C1*D*L (for vertical load only) P = allowable load on eccentric weld group (kips) C = coefficient interpolated from Table XXVI C1 = coef. for electrode, use 1.0 for E70XX D = number of 1/16's of an inch (weld size) L = vertical weld length Results: L= kL = xL = yL = aL = a= k= C1 = C= P= Angle q = Co = C(max) = A= Ca/Co = Ca = D(req'd) = L(req'd) = 11.500 3.000 0.310 4.560 3.460 0.301 0.261 1.0 0.768 26.00 0.000 N.A. N.A. N.A. N.A. N.A. 2.944 11.285
in. in. in. in. in.
xL=0.31 kL= 3
2.69
kips deg.
1/16's in.
(Note: AISC Alternate Method 2 is not used for P=Pv) L = vertical weld length kL = horizontal weld length xL = (kL)^2/(2*(kL+L)) yL = L^2/(2*(kL+L)) aL = (Dist. to Pv)-(xL) a = (aL)/L k = (kL)/L C1 = 1.0 for E70XX electrode (interpolated from Table XXVI) P = SQRT(Pv^2+Ph^2) q = 90-(ATAN(Pv/Ph)) Co = C (from AISC Table XXVI) C(max) = 0.928*(1+k) A = C(max)/Co >= 1.0 Ca/Co = A/(SINq+A*COSq) >= 1.0 Ca = (Ca/Co)*Co D(req'd) = P/(C*C1*L) L(req'd) = P/(C*C1*D) Weld is adequate! D(req'd) = 2.944 <= 3 (1/16's) L(req'd) = 11.285 <= 11.5 in.
10 of 16
3/12/2013 4:00 AM
Subject: Originator:
Checker:
12.0
Y - AXIS (in.)
10.0
8.0
6.0
4.0
2.0
X - AXIS (in.)
+Y
1 2 2
1=Start 2=End
1 Load Point Data: Point #1 3.000 5.000 0.000 0.00 86.93 -23.29 0.00 0.00 0.00
1 1
0
X-Coordinate (in.) = Y-Coordinate (in.) = Z-Coordinate (in.) = Axial Load, Pz (k) = Shear Load, Px (k) = Shear Load, Py (k) = Moment, Mx (in-k) = Moment, My (in-k) = Moment, Mz (in-k) =
+X
Origin
+Z NOMENCLATURE
(continued)
11 of 16
3/12/2013 4:00 AM
Results: Weld Group Properties: Lw = 20.000 in. Xc = 1.250 in. Yc = 5.000 in. Ix = 333.33 in^3 Iy = 52.08 in^3 J= 385.42 in^3 S Loads @ C.G. of Weld Group: S Pz = 0.00 kips S Px = 86.93 kips S Py = -23.29 kips S Mx = 0.00 in-k S My = 0.00 in-k S Mz = -40.76 in-k
Weld Forces (k/in.) Fw(1) Fw(2) 3.955 4.125 3.955 4.983 4.983 5.119
Required E70XX Weld Size: Fw(max) = 5.119 kips/in. Fillet (leg) = 0.345 in. Throat (eff) = 0.244 in.
12 of 16
3/12/2013 4:00 AM