Re: Thread calculations using Excel


"Dan Nix" <tuffynix2004@xxxxxxxxxxx> wrote in message
news:ki3t22h9g0va3l3q3umlpkgaqvc8irabp5@xxxxxxxxxx
Does anyone have an Excell file or spreadsheet that can
calculate/generate thread data using a few data inputs. For example,
if I needed to find the major diameter (min and max) and the pitch
diameter (min and max) for a 9-3/4-12 UN-2A thread, I would just enter
the following:
Nominal diameter = 9.75
# of threads per inch = 12
Class of thread = 2

The spreadsheet would then calculate those values and possibly even
more. It could even calculate thread gauge data, ideal pin diamater
for measurement over wire, etc...

Check out this website for an example of what I'm looking for.
http://www.threadcheck.com/threadtech_software.htm

Thanks,
Dan


I have a program which lists the type of information you want for 1100+
thread sizes, but doesn't handle calculations based on user input. It sells
for $15.

You can see a screenshot and get a demo at
http://mrainey.freeservers.com/METhreads.html


Within a couple weeks, I expect to have a new version ready which will
output the same level of detail, based on user input of major diameter and
pitch, for thread types UN/UNS, ISO, BUTTRESS,ACME, and STUB ACME. In
addition, I'll be adding hard-coded output for more thread types, including
Metric STI, BSP, Metric Trapezoidal, and perhaps others.

This program will sell for $50.

Shoot me an email if you'd like to be notified when it's ready.



.

Relevant Pages

  • Re: Thread calculations using Excel
    ... calculate/generate thread data using a few data inputs. ... if I needed to find the major diameter and the pitch ...
    (alt.machines.cnc)
  • Re: Thread calculations using Excel
    ... calculate/generate thread data using a few data inputs. ... if I needed to find the major diameter and the pitch ...
    (alt.machines.cnc)
  • Re: Gratuitous swarf photos
    ... But you start the cutting at the outside (major diameter), ... To handle this, the blank can be "gashed" at the correct OD pitch and the hob will follow the gashes, even though they are further apart than the hob teeth. ... When I tried to hob a 32 tooth straight gear without gashing, I got 33 teeth because of the pitch discrepancy. ...
    (rec.crafts.metalworking)
  • Re: Thread calculations using Excel
    ... Dan Nix wrote: ... calculate/generate thread data using a few data inputs. ... if I needed to find the major diameter and the pitch ...
    (alt.machines.cnc)
  • Re: Thread calculations using Excel
    ... The attached link only provide programming data ... calculate/generate thread data using a few data inputs. ... if I needed to find the major diameter and the pitch ...
    (alt.machines.cnc)