You have downloaded this file 0 times in the last 24 hours, limit is 100.
Your file downloads total 0 in the last 24 hours, limit is 20.

SimpleBoltCalc.xls
 
This location is for Registered Users Only.
Perhaps you need to login or register.

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!

Submitted By:
Billy NoMates (BillyNoMates)
Submitted On:
29 Jan 2008
File Size:
45.00Kb
Downloads:
1227
File Version:
1.0
Rating:
Total Votes:13
Comments: 12
markusjbear 9 years ago
This does not seem to do much and has a few bugs in excel 2007
markusjbear 9 years ago
This does not seem to do much and has a few bugs in excel 2007
designer sara 10 years ago
nice
designer sara 10 years ago
nice
mpaca01 12 years ago
Good running check and nice to see in Metric!
mpaca01 12 years ago
Good running check and nice to see in Metric!
ericvarhos 12 years ago
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?
ericvarhos 12 years ago
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?
JohnDoyle[Admin] 12 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!
JohnDoyle[Admin] 12 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 12 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.
BillyNoMates 12 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.

We have 191 guests and 7 members online

Contact Us
post/emailEmail (preferred method of contact)
telephone US +1 617 5008224
telephone EU +44 113 8152220
Our Feeds
Repository RSS. News RSS.