Power Screw.xls

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


Purpose of calculation
: For an applied load on a screw thread calculate the axial thrust of a nut. Calculate bolt pretension from screw parameters (thread pitch, thread coefficient of friction, head coefficient of friction etc.).

Calculation Reference
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 |

Version History

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

Submitted On:
29 Jan 2008
Submitted By:
File Date:
22 Jun 2007
File Version:
File Size:
File Type:
This download requires the XLC Add-in for Excel to be installed.
stars/5.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.


#3 Willempi 2008-12-15 09:38
Comment 1: Instead of using the long conversion of angle (in radians) to degrees, you can use the built-in conversion function =DEGREES(XX), where XX is the cell reference (radians), then you can add the cell formatting as per comment 2 below.
Comment 2: You can format the degrees as follows. Use Custom number formatting of the cell in which you display the degree equivalent of the angle (in radians) by typing 0.00_;"" , which would display the unit "" in the cell.
#2 allenjray 2008-07-11 10:08
#1 ziggle 2007-07-09 07:59

Please sign in or register to add a comment.

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