View Single Post
  #1   Report Post  
 
Posts: n/a
Default Excel spreadsheet for cutting gears using a rotary table

I just uploaded an Excel spreadsheet program to the dropbox
[http:\\www.metalworking.com ] that calculates the angular spacing for
any given number of gear teeth.

Gearcalc.xls is a M/S Excel spreadsheet program that calculates the
angular spacing for a given number of gear teeth from 1 to 200 in
decimal degrees calculates a running total and converts the running
total decimal degrees to degrees, minutes and seconds. This is
especially handy for cutting gears using a rotary table rather than a
dividing head.

Using the Excel filldown function, this can be extended to any number
of teeth (up to about 65,000).

To use just enter the number of teeth in the cell in the first line and
everything is calculated. The line for one more tooth than you entered
should be 360 degrees as you are back where you started. For example
tooth (actually space)66 for a 65 tooth gear should read 360 degrees, 0
minutes, and 0 seconds.

Enjoy

George McD