BoltedJoint.xls

Purpose of calculation: Determine force distribution in a preloaded bolted joint.

Calculation Reference: http://en.wikipedia.org/wiki/Bolted_joint

OR Schaum's Outline - Machine Design

The mechanics of a bolted joint is explained in the example shown in the diagram below.

Calculation Validation: The calculation is a reworking of a calculation found at:

http://ocw.mit.edu/OcwWeb/Mechanical-Engineering/2-007Spring-2005/Tools/detail/spreadsheet.htm

Useful Data:

https://roymech.org/Useful_Tables/Screws/Screw_loads.html

https://roymech.org/Useful_Tables/Screws/Preloading.html#Initial_Bolt_Tensio