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!
Calculation Preview
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!