US Bolt Calculator

This Excel calculation can be downloaded by ExcelCalcs subscribers.Please login or Subscribe.

Calculation Preview

I literally use this every day at work for sizing bolts. User inputs the bolt size and thread from a dropdown list filled with McMaster Carr's hex head bolt and thread sizes. Next choose the bolt material type from a dropdown box with several steel and titanium grade choices. The strength of the bolt is autofilled from the material type. Last, the internal thread material is chosen from a dropdown with a list of steel, titanium, auqamet and garolite choices. The strength is once again filled in automatically and the joint failure strength is calculated.

Calculation Reference
Bolted Connections
| Find on | Find on | Find on | Find on | Find on |
Thread Mechanics
| Find on | Find on | Find on | Find on | Find on |
Torque Tension Mechanics
| Find on | Find on | Find on | Find on | Find on |

Version History
Subscribe to this topic and get notified by mail about new posts Favorite to this topic Discuss this item in the forum. Check the version history to see how this calculation has changed over time. Use the Subscribe button to receive an automatic email should this calculation be updated to a higher version. Use the Favourite button so you can easily find this calculation in the future.

Submitted On:
08 Sep 2014
Submitted By:
File Date:
08 Sep 2014
File Author:
Roland Cranford
File Version:
File Size:
331.96 Kb
File Type:
stars/0.gifTotal Votes:0
HTML Link:
Copy code below to your web page to create link to this page:
HTML Window:
Copy code below to your web page to create a dynamic window to this download:
Like This?:
View the profile of the person who submitted this calculation and see all their other calculations hosted at ExcelCalcs.
Need Help?:
Use the comment feature below to raise any questions relating to this download. The question will be automatically emailed the author and all users subscribing to this comment thread.


#2 yosso 2018-03-23 13:32
Very helpful workbook. All equations laid out nicely.
#1 JohnDoyle[Admin] 2014-07-12 10:47
Thanks for your contribution I have awarded a 3 month extension to your XLC Pro subscription by way of thanks. [Admin]

Please sign in or register to add a comment.

We have 7 guests and 37 members online
Contact Us
post/emailEmail (preferred method of contact)
telephone US +1 617 5008224
telephone EU +44 113 8152220
Our Feeds
Repository RSS. Forum RSS. User Comment RSS. News RSS.



Real Time Analytics