Advertisement

SimpleBoltCalc.xls download_trans.gif Download

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!

Forum Link

Comment upon or discuss this document in the Forum

Submitted On:
29 Jan 2008
Submitted By:
Billy NoMates (BillyNoMates)
File Date:
19 Apr 2007
File Size:
45.00Kb
File Type:
xls
Downloads:
584
Rating:
stars/4.gifTotal Votes:6
Comments:
Billy NoMates 2007-04-19 09:26:00 Bolt calculations can get very involved and complicated so this calculation offers a great quick check on allowable loads on a bolted steel joint.
John Doyle 2007-04-19 09:29:46 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!
Eric 2007-06-05 06:52:02 Simple and easy way to check the bolt calculations. Good job. Just a little curious where the bolt shear values come from, is there perhaps a reference?
Greg MacDougall 2007-06-20 06:44:33 Good running check and nice to see in Metric!