BoltedJoint.xls
 

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

Description:

Purpose of calculation: Determine force distribution in a preloaded bolted joint.

Calculation Reference: http://en.wikipedia.org/wiki/Bolted_joint

OR Schaum's Outline - Machine Design
| Find on Amazon.com | Find on Amazon.co.uk | Find on Amazon.fr | Find on Amazon.de | Find on Amazon.ca |

The mechanics of a bolted joint is explained in the example shown in the diagram below.

Calculation Validation: The calculation is a reworking of a calculation found at:

http://ocw.mit.edu/OcwWeb/Mechanical-Engineering/2-007Spring-2005/Tools/detail/spreadsheet.htm

Useful Data:

http://www.roymech.co.uk/Useful_Tables/Screws/Screw_loads.html

http://www.roymech.co.uk/Useful_Tables/Screws/Preloading.html#Initial_Bolt_Tensio

Version History

Check the version history to see how this calculation has changed over time.

Submitted On:
29 Jan 2008
Submitted By:
JohnDoyle[Admin]
File Date:
05 Jul 2007
File Version:
02
File Size:
170.50Kb
File Type:
xls
XLC:
This download requires the XLC Add-in for Excel to be installed.
Downloads:
788
Rating:
stars/4.gifTotal Votes:5
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.

Comments  

 
#3 danap01 2008-01-22 14:17
Very nicely done, other than that I don't know.
 
 
#2 ziggle 2007-07-09 07:52
Just what I have been looking for.
 
 
#1 Bala 2007-06-25 06:13
It is a very helpfull staff to understand the total behavior of the joint in theory.
 

Please sign in or register to add a comment.

We have 7 guests and 39 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