Weld Group in Direct Shear, Bending and Torsion (Excel Calculator )

Features of WeldCalc for
The Analysis and Design of Weld Groups
Subjected to Simultaneous Shear, Bending, Torsion and Axial Loading
Dr Shaiq U.R. Khan
BEng (Civil), MEng, PhD, PE, CEng, FIStructE
24 April 2001
Techno Consultants Ltd , 117 Portland Street, Manchester M1 6ED, England.

WeldCalc is an Excel 97/2000 Template for the design of weld groups having any configuration of multi-linear weld lengths in an x-y plane. It uses the elastic method to analyse weld groups subjected to simultaneous tension, compression, shear, bending and or torsion in x, y and z directions. If present, the influence of unsymmetrical bending is taken into account in the analysis.


WeldCalc analyses any configuration of multi-linear weld lengths in an X-Y plane. The loading can be shear, bending, torsion and axial loads applied simultaneously.

WeldCalc calculates the stress induced at each node and identifies the node most highly stressed. It also calculates the magnitude of load resisted by each weld length in the x, y and z direction.

A weld group can have up to 30 Nodes or 29 weld lengths. The line of weld lengths can be continuous or discontinuous. Each continuous series of weld lengths is termed as a Part and it is given a reference number starting from 1 onwards. A weld group can have up to 15 parts connecting 30 nodes in any pattern.


  1. The file size is under 450 KB. At 3 KB/second, your download time would be about 3 minutes.
  2. Comprehensive documentation and sketches included within the template file to describe the analysis method and to serve as reference during interactive use.
  3. Sign convention for applied loads illustrated via 3D-Sketch on the screen and in the printed output for ease of use and ready reference.
  4. All calculation components shown on the screen and in the printed output. The user and the checker both can verify results by hand calculations.
  5. On the spot screen display of background information via comments, when moving the mouse pointer over cells.
  6. At each weld node, calculation and display of induced stresses.
  7. At each weld length, calculation and display of the load carried in x, y and z direction.
  8. The influence of unsymmetrical bending is taken into account, when present.
  9. Applied Loading: Point loads Fx, Fy and Fz and Moments Mx, My and Mz
  10. Design weld strength can be any value to suit your design standard e.g. BS 5950 or BS449.
  11. A weld group can have up to 30 linear lengths forming any weld configuration in the x-y plane.
  12. Lines of weld can be continuous or discontinuous. Each continuous series of weld lengths being termed as a PART, a weld group can have up to 15 separate PARTS connecting 30 nodes.
  13. Live display of weld group configuration via sketch makes errors in input data obvious at a glance.
  14. The position of user origin can be any convenient point for ease in describing complex weld configurations.
  15. The origin and centroid is shown in the weld group sketch for ease in comprehending input data and analysis results.
  16. Database facility within the WeldCalc file keeps information for up to 500 Weld Groups in a project via worksheet STORE. Using a reference number in the range 1001 to 1500, each Weld Group can be retrieved, changed and re-designed with ease at a later time.
  17. The Database in worksheet STORE is visible to the user. Using spreadsheet features of Excel, new data can be generated and the existing one examined and or modified.
  18. Auto Analysis facility made available via two columns in the Worksheet STORE. One column allows selection for analysis and the other selection for printing. All SELECTED Weld Groups can therefore be analysed and or their results printed by a mouse click.
  19. Auto Analysis facility also embeds analysis results in the worksheet STORE. The spreadsheet cells showing inadequate strength becomes red in colour. After Auto Analysis, the adequacy of each Weld Group therefore becomes obvious at a glance.
  20. The template has virtually no user interface. The A4 size Printed Output matches the Screen Display. Knowing the use of Excel 97 and the ability to verify the output as a designer is sufficient for using WeldCalc.
  21. Shaded cells in the spreadsheet mean User-Input and un-shaded cells Spreadsheet-Results. This permits easy checking at a glance both by the user and the checker of WeldCalc output.

Post a Comment