WELDGRP.xls

(5/16)

Description

Weld Group Analysis per AISC 9th Ed. (ASD)

"WELDGRP.xls" is a MS-Excel spreadsheet workbook for analyzing weld groups. There are 8 worksheets which replicate the AISC 9th Edition Manual Tables XIX thru XXVI to be used for analysis. There is a worksheet for analysis by the elastic method, allowing the user to model up to 24 weld segments . This worksheet allows the user to input axial, shear, and moment loadings. The elastic method worksheet has user input for weld segment coordinates (start and end), and the weld group is plotted to aid in verifying the group configuration. There is also built-in capability to facilitate the user input of a circular weld group.

Also, there is a worksheet containing data and tables replicated from the AISC 9th Edition Manual.

All the worksheets are independent and self contained, so that you can move them from one workbook to another. All the worksheets are protected, but not with a password.

Please read the "DOC" worksheet for program details as well as assumptions and limitations.

A metric version of the 'elastic' method calculation is also available "WELDGRP Metric".

Calculation Preview

Submitted By: Alex Tomanovich (atomanovich)

Submitted On: 18 Sep 2009

File Size: 872.50 Kb

Downloads: 798

File Version: 2.3

File Author: Alex Tomanovich

File Rating

(5/16)

Full download access to any calculation is available to users with a paid or awarded subscription (XLC Pro).
Subscriptions are free to contributors to the site, alternatively they can be purchased.
Click here for information on subscriptions.

Comments: 8

teckert11 5 years ago

alex- are you able to update the sheet to include LRFD?

atomanovich 9 years ago

In the "Weld Group (elastic)" worksheet of the "WELDGRP.xls" workbook, a moment about the z-axis (+z direction out of the page or screen) would be a torsion or twist on the weld group. Mz, by right-hand-rule, would be positive counterclockwise about the z-axis. Mx and My moments would result in either tension or compression in the weld group, depending on the specific point in the weld group.

boobathi 9 years ago

What is Torsion in your spreadsheet Mx or Mz

rahulmenon 13 years ago

Alex if you could email me rm273611[at]gmail.com I would highly appreciate and i could send you a picture of the problem.
Thx
Rahul

atomanovich 13 years ago

rahulmenon,
I'm not totally clear on your exact situation and the welded connection configuration. However, if your fillet welds are "end-loaded", per AISC, for welds 100*w then there is a formula, L(eff) = beta*L that must be used, where beta = 1.2-0.002*(L/w) 300*w, then beta is taken as 0.60.
My WELDGRP.XLS workbook does not address effective weld lengths. The user must address and account for any adjustment on his/her own. Note that transversely loaded welds are not considered end-loaded, so there would be no potential reduction in length to be considered as the effective length.
Since you said had combined loadings you will have to exercise some engineering judgement in analyzing the welds. It really becomes a question of stiffness/rigidity of your connection, and how well the forces can or cannot be distributed to engage the total weld group. My advise is to stay on the conservative side in your analysis.
Alex

rahulmenon 13 years ago

Alex, I have a 50 ft long tower structure and has combined loading, I have double sided welds running all through 50 ft, do you know the effective length I should consider to size my welds? using 45 degree rule does not qualifies the welds..does your weld group spread sheet works for certain limited lengths?

atomanovich 15 years ago

In 3 of my spreadsheets the same "typo" error was discovered in the table for C-shaped weld coefficients, AISC 9th Edition ASD Table XXIII.
The "C" coefficient value for a=2.40 and k=1.6 should have been 0.874, but was inadvertently shown as 0.847.
This has been corrected as required in all three of the following workbooks:
"WELDGRP.xls" - now version 2.3
"CLIPCONN.xls" - now version 2.1
"ClipConnTable.xls" - now version 1.6
Hey, you can't fault me for not being consistent!!! (LOL)

atomanovich 16 years ago

In the "WELDGRP.xls" workbook and in the "Weld Group (elastic)" worksheet off of the main calculation page on the right, I already had a facility to automatically generate the input coordinates for 24 weld segments used to closely simulate a circular weld. Now, I have added similar facilities to automatically generate the input coordinates for weld segments for full wide-flange shape welds, full tee shape welds, full channel shape welds , full angle welds, and full square/rectangular tube shape welds. All the user needs to do is select the member size, copy and "Paste-Special" the coordinate values in the input data portion of the worksheet, and then input the appropriate total number of weld segments. Instructions for each of the weld group patterns are given.

WELDGRP.xls

Description

Calculation Preview

Welcome Back!