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:
483
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] 11 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] 11 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 224 guests and one member 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.