SimpleBoltCalc.xls

Rating:
18

Description

This is a pretty simple bolt calculation from first principles. For a given bolt size it looks up the characteristics of a bolt from a 'Bolt Lookup Table'. A bolt preload (or clamping load) is estimated from the bolt torque and a joint slip load for the specified coefficient of friction. A fatigue endurance limit is also calculated for axial loads on the bolt. It is not rocket science but I have used it a lot for a quick check on bolted joints. Enjoy!

Uploaded
19 Apr 2007
Last Modified
29 Jan 2008
File Size:
45.00Kb
Downloads:
1290
File Version:
1.0
Rating:
18

 
Full download access to any calculation is available to users with a paid or awarded subscription (XLC Pro).
Subscriptions are free to contributors to the site, alternatively they can be purchased.
Click here for information on subscriptions.
Comments: 2
JohnDoyle[Admin] 17 years ago
Yes it a great quick check on a bolted joint. Not sure where all the tightening torques come from they seem a little on the high side to me. Well Done Billy!
BillyNoMates 17 years ago
Bolt calculations can get very involved and complicated so this calculation offers a great quick check on allowable loads on a bolted steel joint.