WELDGRP.xls

Rating:
13

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 Reference
AISC | Find on Amazon.com | Find on Amazon.co.uk | Find on Amazon.fr | Find on Amazon.de | Find on Amazon.ca |

Submitted On:
18 Sep 2009
File Size:
872.50 Kb
Downloads:
710
File Version:
2.3
File Author:
Alex Tomanovich
Rating:
13

 
This download is for Registered Users Only.
Perhaps you need to login or register.
Comments: 9
teckert11 5 months ago
alex- are you able to update the sheet to include LRFD?
ATomanovich 4 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 4 years ago
What is Torsion in your spreadsheet Mx or Mz
rahulmenon 9 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 9 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 9 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?
m4grem 10 years ago
Alex, great sheet! Plans to update to AISC 13th?
ATomanovich 11 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 11 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.