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.

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

Description:

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

Submitted By:
John Doyle (JohnDoyle[Admin])
Submitted On:
29 Jan 2008
File Size:
199.00Kb
Downloads:
484
File Version:
01
Rating:
Total Votes:6
Comments: 9
Willempi 11 years ago
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.
Willempi 11 years ago
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.
allenjray 11 years ago
thank-you
allenjray 11 years ago
thank-you
JohnDoyle[Admin] 12 years ago
mstickma that's a useful link for many threadforms. The thread depth variable, t, in the calculation can be set to suit any particular threadform.
JohnDoyle[Admin] 12 years ago
John,
Thanks for creating this spreadsheet. It has saved me the time of recreating it from a similar Mathcad file I was using.
I was wondering if you could elaborate on what the thread depth variable is in the sheet. I took it as 0.600 X P for metric fine threads. I found this at: [url]http://www.colinusher.info/Livesteam/mewdata.html#data[/url]
Is this correct?
JohnDoyle[Admin] 12 years ago
There is a very useful tool on the Norbar website called the [url=http://www.norbar.com/torquetensioncalculator.php]Torque Tension Calculator[/url]. It provides a useful check and useful thread dimensions which can be inserted into the spreadsheet calculation.
ziggle 12 years ago
Thanks!
ziggle 12 years ago
Thanks!

We have 306 guests and 8 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.