Analysis & Design of Weld Groups



Excel Template for the Analysis & Design of Weld Groups Subjected to Simultaneous Shear, Bending, Torsion & Axial Loading. Weld configuration can be any shape of multi-linear weld lengths in a plane. If present, unsymmetrical bending is taken into account in the analysis.
Dr Shaiq Khan is a Chartered Structural Engineer working freelance in the building trade. In his day to day work, he develops and uses computer software for the design and maintenance of buildings. This enables him to enhance the quality of work for his clients. It also shares and enhances technical expertise with fellow professionals in this country and abroad. More details at his website.

Calculation Reference
Weld Strength Analysis

Calculation Preview

Submitted On:
25 Jan 2010
File Size:
507.00 Kb
File Version:
File Author:
Shaiq Khan

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: 9
technouk 13 years ago
Just to close off; the recent submission of an updated file by the Shaiq Khan has resolved the issue. The spreadsheet is now fully functional and does just what I need. Thanks!
shahrokh 13 years ago
technouk 13 years ago
Shaiq emailed an update
The updated calculation has an option to find stress resultant using SRSS OR EuroCode (Von Mises) formula.
technouk 13 years ago
Phil this is a useful resource it may be what you are looking for:
Biaxial Stress Assessment.xls
technouk 13 years ago
Thanks for the reply John. The cell I need to change is actually provided as an option for the user (as a drop-down box), but (perhaps inadvertently) has been locked so that the drop-down selection cannot be changed.
Perhaps I'll try the "back door" as suggested by AFingle. I'll also check the other suggested resources, but I'm looking for a tool (SI units) that uses the von Mises approach for combining shear and direct stress, as that is what the design rules (Australia, AS3990) use to establish stress limits.
technouk 13 years ago
Excel protection is so easy to break it is barley worth setting. A google search will show 1000's of pages outlining how to break them. See Gimpsey and Associates solution - passwords hacked in the blink of an eye.
technouk 13 years ago
technouk spreadsheets are generally password locked which keeps them safe from modification but difficult to modify for your own needs. There are a couple of other repository items which I think you will find both useful and easy to modify:
1) WELDGRP.xls - One of Alex Tomanovich's great spreadsheets. They are protected but not with a password. Just download and unprotect worksheet. There are elastic and ultimate strength methods. A metric version can also found here WELDGRP Metric.xls.
2) LineSec.xls - This is good for any section made up of lines, welds lines included. I find it useful because the weld line does not have to be the same thickness each line can have its own thickness property. Analysis is elastic. This calculation is mine and all the working is shown with XLC equations so it should be easy to modify.
3) ThinWallProp1.xls is a great calculation from Yakov Polyakov. This will give the ultimate strength of a weld line. From memory I think all lines have the same thickness.
One or other of these methods has got me out of all the weld static strength problems I have encountered.
technouk 13 years ago
This spreadsheet looks to be an excellent resource. I can't seem to change the Equivalent Stress Calculation Method from SRSS to Von Mises (cell is protected and sheet has password protection).
Any ideas anyone?
yosso 13 years ago
British standards, but an excellent resource.