SimpleBoltCalc.xls
 
This Download is for Registered Users Only.
Please login or Register (free plans available).

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:

BillyNoMates

File Date:

19 Apr 2007

File Size:

45.00Kb

File Type:

xls

Downloads:

1030

Rating:

Total Votes:9

Comments:

BillyNoMates 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.

JohnDoyle 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!

ericvarhos 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?

mpaca01 2007-06-20 06:44:33 Good running check and nice to see in Metric!

designer sara 2009-02-22 03:23:04 nice

markusjbear 2010-01-22 23:10:12 This does not seem to do much and has a few bugs in excel 2007