Analysis & Design of Weld Groups

(4/13)

Description

Weld Group Analysis and Design: Shear, Bending, Torsion and Axial Load

An Excel template that checks a fillet weld group of any shape in one plane under simultaneous forces and moments in three directions. The weld is described as up to 30 straight lengths in up to 15 separate parts. Helper sheets generate coordinates for welds round I, L, channel, PFC and CHS sections, and a database stores 200 or more weld groups for recall or batch analysis.

Method

The elastic (vector) method. Weld group properties (area, centroid, Ixx, Iyy, Ixy, principal and polar moments) come from the weld lengths and throats; eccentric loads become moments at the centroid. Stresses fx, fy, fz are found at every node, including unsymmetrical bending, and the resultant (√(fx² + fy² + fz²) or a von Mises-type form) is compared with a design weld strength.

Inputs

  • Forces Fx, Fy, Fz with their positions; moments Mx, My, Mz
  • Node coordinates, part numbers and throat of each weld length
  • Design weld strength (e.g. to BS 5950 or BS 449) and resultant method

Outputs

  • Weld group properties about the centroid and principal axes
  • Stresses at each node and forces in each weld length
  • Maximum stress with an adequacy message, and a scaled sketch

The stored example, a 5.6 mm-throat weld all round a 686×254×125 UB with Fz = 718 kN, Fy = 89 kN and Mx = 75.3 kNm, gives Ixx = 8.76 × 108 mm4 and a maximum resultant of 0.151 kN/mm² against 0.215 kN/mm² (adequate).

Please note

  • Macros must be enabled: results come from VBA functions and show #NAME? without them. Supplied as an .xlt template; save the workbook to keep stored data. Sheets protected.
  • Elastic method only; welds in one plane only.
  • By Dr Shaiq Khan, Techno Consultants Ltd (WeldCalc, July 2009).

Calculation Preview

Shaiq Khan (technouk)
28 Apr 2023
File Size 507.00 Kb
Downloads: 781
File Version: 7.16
File Author: Shaiq Khan
File Rating (4/13)

 
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
technouk 16 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!
technouk 17 years ago
Shaiq emailed an updateThe updated calculation has an option to find stress resultant using SRSS OR EuroCode (Von Mises) formula.
technouk 17 years ago
Phil this is a useful resource it may be what you are looking for:[Biaxial Stress Assessment.xls](/404/)
technouk 17 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
technouk 17 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](http://mcgimpsey.com/excel/removepwords.html) solution - passwords hacked in the blink of an eye.
technouk 17 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](/calcs/repository/machines/welds/weldgrp.xls/) - One of [Alex Tomanovich's](/publicprofile/2056) 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](/calcs/repository/machines/welds/weldgrp-metric.xls/).2) [LineSec.xls](/404/) - 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](/publicprofile/62) and all the working is shown with XLC equations so it should be easy to modify.3) [ThinWallProp1.xls](/calcs/repository/geometry/areas/thinwallprop1.xls/) is a great calculation from [Yakov Polyakov](/publicprofile/201). 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 17 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?Phil
yosso 17 years ago
British standards, but an excellent resource.