Weldment Strength Excel Calculations

John Andrew, P.E.

Course Outline

This 2 PDH course can be used to calculate the: shear, bending, and torsion strength of many types of welds.

The calculations within this live spreadsheet will facilitate the initial design and engineering of many types of welds. When various factors are typed into the Input cells, Excel will calculate results automatically. In addition, the powerful tool, "Goal Seek" can be used to optimize each Calculation.

AutoCAD 3-D is divided into 12 sections. Step-by-step illustrated examples show how to use tools to create all types of three dimensional engineering three dimensional solid models.

1. Welds in Tension and Shear
2. Welds subjected to Bending and Torque
3. Long Welds

The course includes a multiple-choice quiz at the end, which is designed to enhance the understanding of the course materials.

Learning Objective

At the conclusion of this course the student will:

• have seen examples of typical welded connections;
• calculate the shear and tension strength of V-groove welds;
• calculate the shear and tension strength of fillet welds;
• calculate the strength of plug welds;
• calculate the strength of intermittent welds; and
• use Excel's "Goal Seek" to optimize the design of welds.
  
  

Intended Audience

The information will be especially useful to: students, entrepreneurs, engineers, architects, and innovators who want to be able to calculate the strength of welded connections.

Benefit to Attendees

Attendee of this course will know how to calculate the strength of the most common types of welds.


Course Introduction

This course adheres to the recommendations of the American Welding Society. The AWS has established standards including weld: types, symbols, dimensions, strength, endurance, test procedures, and welder classifications.

Course Content

You need to download and study the following spreadsheet:

Weldment Strength Excel Calculations

DISCLAMER: "This spreadsheet is provided for illustrative teaching purpose only, and is not intended for use in any specific project. Anyone making use of theinformation contained in this spreadsheet does so at his/her own risk and assumes any and all resulting liability arising therefrom."

Course Summary

A brief and to the point summary is provided in these lesson notes and Excel spreadsheets that will provide information that can be used to solve welded connection design problems and create new calculation methods.

Related Links

The AutoCAD home page at: http://www.lincolnelectric.com.

The United States Patent and Trademark Office Home Page at http://www.uspto.gov Provides links to information about all aspects pertaining to invention patents

Quiz

Once you finish studying the above course content, you need to take a quiz to obtain the PDH credits.

---

DISCLAIMER: The materials contained in the online course are not intended as a representation or warranty on the part of PDH Center or any other person/organization named herein. The materials are for general information only. They are not a substitute for competent professional advice. Application of this information to a specific project should be reviewed by a registered architect and/or professional engineer/surveyor. Anyone making use of the information set forth herein does so at their own risk and assumes any and all resulting liability arising therefrom.

---