Related Resources: Design Engineering

Bolt Joint Analysis S-N Diagram Excel Spreadsheet Calculator

NOTE:

  • Refunds are not awarded after excel files have been downloaded - review your membership agreement for details.
  • This excel spreadsheet may contain macros which will need to be enabled in your excel application, see web page: Enable macros in Downloaded excel files
  • Units utilized within calculators are either SI or Imperial (some enable both SI and Imperial) and member (you) are responsible for conversions. Ensure that you verify units utilized in excel application meet your requirements before downloading.

Engineering Excel Spreadsheet Downloads
Structural Design Engineering Resources

Bolt Joint Analysis S-N Diagram for Loading Excel Spreadsheet Calculator

Note: Accessing this resource requires an active Premium Membership with Engineers Edge

Download: Bolt Joint Analysis S-N Diagram for Loading Excel Spreadsheet Calculator

Preview (Very Partial): Bolt Joint Analysis S-N Diagram for Loading Excel Spreadsheet Calculator

Bolt Joint Analysis S-N Diagram for Loading Excel Spreadsheet Calculator

Force on Bolt and Members versus Deflection Curve
Goodman Diagram
Ultimate Strength of the Bolt
Yield Strength of bolt
Maximum Strength for Infinite Life
Mean Stress on Bolt
Alternating Stress on Bolt
Preload stress on Bolt Modulus of Elasticity of the Bolt
Diameter of the Bolt
Length of threaded portion of grip
Tensile-stress area of the bolt
Grip of bolt (sum of member thicknesses)
Length of unthreaded portion of gripMajor-diameter area of the bolt
Stiffness of the bolt
Solve for the Stiffness of Members using cone method
Angle of the cone to be used
Diameter of the hole through the members

 

Related: