Print this page Industrial Spring Spreadsheet Calculations
John Andrew, P.E.
Course Outline
This 2-PDH course spreadsheet can be used to calculate the: deflection and shear stress in round and square wire compression and tension coil springs. The angular deflection, shear, and bending stress, in round and rectangular torsion bars are also calculated.
The calculations within this live spreadsheet will facilitate the initial design and engineering of coil springs and torsion bars. When various factors are typed into the Input cells, the spreadsheet will calculate results automatically. In addition, the powerful tool, "Goal Seek" can be used to optimize each Calculation.
Step-by-step illustrated examples show how to use the spread sheet tools to optimize spring and torsion bar designs. This course is divided into 4 sections.
1. Summary
2. Coil springs
3. Torsion Bars
4. Spring Materials
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 coil springs and torsion bars;
- used spread sheets to calculate spring deflections and stresses;
- analyzed the elastic forces and deflections in torsion bars;
- links to spring vendors and spring material properties data;
- understood some advantages of spreadsheet calculations; and
- used “Goal Seek” to optimize the design of springs and torsion bars.
Intended Audience
The information will be especially useful to: students, engineers, architects, and innovators who want to a spreadsheet for calculating spring and torsion bar parameters.
Benefit to Attendees
Attendee of this course will have live spread sheets for calculating spring and torsion bar deflections and stresses.
Course Introduction
This course adheres to the recommendations of the Spring Manufacturers Institute.
Course Content
You need to download and study the following spreadsheet:
Industrial Spring Spreadsheet 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 spreadsheets that will provide information that can be used to solve spring and torsion bar design problems and create new calculation methods.
Related Links
1. Spring Manufacturers Institute: http://www.smihq.com/
2. Fan Disc Corporation: www.asraymond.com
3. Ace Wire Spring Inc: www.acewirespring.com
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.
