Helical Spring Design Guide.xls

This Excel calculation can be downloaded by ExcelCalcs subscribers.Please login or Subscribe.


Outline Calculation Procedure

1) Purpose of calculation
The design of a helical spring using mechanical design formula and material lookup tables.
Check dimensional limits, strength limits and buckling limits against the operational requirements.

2) Calculation Reference

3) Calculation Validation
Formulas checked using the XLC add-in

4) Calculation Units

5) Sketch

6) Main Input Parameters
Wire diameter
Spring mean diameter
Free length
Number of turns
% length on installation and operational max compression

7) Spring Ends
Number of inactive turns due to closed and ground ends
Effective number of turns
Length modifier
Inactive Length
Active Length
Pitch (unloaded).
Solid Length

8) Material Properties
Material Constant
Material index
Ultimate Tensile Stress
Torsional yield to tensile ultimate strength factor
Torsional yield stress
Conversion Factor from Mpa to selected system of units
Torsional yield stress converted to select system of units
Young's Modulus
Modulus of rigidity assuming a Poisson's ratio of 0.3

9) Spring Deflection Characteristics
Spring Index
Spring Rate
Force to close the spring

10) Spring Strength Characteristics

Wahl factor
Torsional Stress Rate
Force to yield spring
Spring extension to yield spring

11) Spring Buckling

Buckling critical compression length
Buckling force

12) Operational Limits
Installed Length
Installed force
Operating Length
Maximum working load

Calculation Reference
Machine Design
| Find on Amazon.com | Find on Amazon.co.uk | Find on Amazon.fr | Find on Amazon.de | Find on Amazon.ca |
Elements of Mechanical Design
| Find on Amazon.com | Find on Amazon.co.uk | Find on Amazon.fr | Find on Amazon.de | Find on Amazon.ca |
Design of Springs
| Find on Amazon.com | Find on Amazon.co.uk | Find on Amazon.fr | Find on Amazon.de | Find on Amazon.ca |

Version History
Subscribe to this topic and get notified by mail about new posts Favorite to this topic Discuss this item in the forum. Check the version history to see how this calculation has changed over time. Use the Subscribe button to receive an automatic email should this calculation be updated to a higher version. Use the Favourite button so you can easily find this calculation in the future.

Submitted On:
25 Nov 2011
Submitted By:
File Date:
11 Feb 2011
File Version:
File Size:
569.00 Kb
File Type:
This download requires the XLC Add-in for Excel to be installed.
stars/5.gifTotal Votes:3
HTML Link:
Copy code below to your web page to create link to this page:
HTML Window:
Copy code below to your web page to create a dynamic window to this download:
Like This?:
View the profile of the person who submitted this calculation and see all their other calculations hosted at ExcelCalcs.
Need Help?:
Use the comment feature below to raise any questions relating to this download. The question will be automatically emailed the author and all users subscribing to this comment thread.


#1 trophy 2013-01-19 18:27
ty 4 help

Please sign in or register to add a comment.

We have 7 guests and 39 members online
Contact Us
post/emailEmail (preferred method of contact)
telephone US +1 617 5008224
telephone EU +44 113 8152220
Our Feeds
Repository RSS. Forum RSS. User Comment RSS. News RSS.



Real Time Analytics