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.

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

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:

• Bolt Pattern Group Pullout Excel Spreadsheet Calculator
• Fastener, Bolt and Screw Design Torque and Force Calculation
• Design Bolted and Riveted Joints
• Eccentric Loading On Bolt Group One Vertical Row Calculator
• Structural Eccentric Loading on Bolt Group For Two Vertical Rows Calculator
• Fastener Size Thread Table
• ANSI Engineering Design Hardware Data
• ISO Metric Hardware Design Data