Power Screw.xls



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 On:
29 Jan 2008
File Size:
File Version:

This download is for Registered Users Only.
Perhaps you need to login or register.
Comments: 4
carloslermont 2 months ago
Hi, how can I be paert of group in order to downoad this sheet?
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
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.