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 |
Version History
Check the version history to see how this calculation has changed over time.
Total Votes:11I have been chasing up feedback from new users signing up to XLC Pro accounts in the last month. I am delighted with their positive feedback. “I started using XLC but I am now insisting that my whole team use the add-in .“ “It is a great tool for validation and pres...
Engineering training - “I run a team of engineers and whilst there are plenty of soft options for training expounding the latest management techniques there is precious little to develop the engineering skills of my team”. This is a familiar story we hear from clients of our trai...
You are probably familiar with our tools of mass knowledge distribution on our website but ExcelCalcs also works more closely with corporate partners providing engineering training and engineering consultancy services. What’s more these services and ExcelCalcs subscriptions are availa...
ExcelCalcs eFormulas aims to replace traditional engineering formula books providing innovative functionality to copy from our webpages and paste directly into Excel. Once in Excel it is easily edited to suit your own problems this functionality is far more flexible than 'stuck on the web'&n...
At some time or other you will have been given someone else’s spreadsheet only to be left scratching your head not having a clue as to what the calculation is doing. If you are wise you will not use it because you can’t understand it. If you are wiser still you’ll use our...
In our good calculation guide we emphasise the importance of sketches in calculations but you can produce interactive 3D wireframe sketches by incorporating Turan Babacan’s latest upload. Turan uses 3D charts to great effect in his Excel FEM programs. Andy Pope also has a 3D chart spr...
A new version of XLC is in the final stages of development which will be compatible with the 64 bit version of Excel 2010 (currently it works with the 32 bit version of Excel 2010, 2007 2003 and 2000). We’ll keep you posted with progress. Please send us details of any features you ...
Most ExcelCalcs users charge subscription fees back to their employers as a business expense. The cost is easily justified as membership of the site have been shown to yield a 23% productivity benefit. Many people do not realise that you don't even need a PayPal account to pay - you can pay...
Document control is a key issue for engineers but it can become an administrative nightmare. Here at ExcelCalcs we have developed many tools to control the calculations we distribute and as a member you have access to all these tools. Problem ExcelCalcs Document Control...
| Membership |
© 2007 - 2012 MoreVision Ltd. All Rights Reserved. |
Conditions of use . |
US +1 617 5008224
Toll Free:
Comments
Thx
Rahul
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
RSS feed for comments to this post