SimpleBoltCalc.xls
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
Submitted By:
Last Modified
29 Jan 2008
File Size:
45.00Kb
Downloads:
1282
File Version:
1.0
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
×
![avatar JohnDoyle[Admin]](/media/com_osmembership/avatars/62_56e81868b9b33.png){kind=small}
JohnDoyle[Admin]
16 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
16 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.