Metalworking (rec.crafts.metalworking) Discuss various aspects of working with metal, such as machining, welding, metal joining, screwing, casting, hardening/tempering, blacksmithing/forging, spinning and hammer work, sheet metal work.

 
 
LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Rotary table help. Todd Rich Metalworking 1 October 6th 03 02:52 PM
Heavy Duty rotary table Wild Bill Metalworking 0 September 22nd 03 04:53 AM
Cutting pullies on a rotary table on a mill frank Metalworking 8 July 18th 03 06:42 PM
Question about Vetex 6" Rotary Table keith Metalworking 0 July 11th 03 07:24 PM


All times are GMT +1. The time now is 11:14 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 DIYbanter.
The comments are property of their posters.
 

About Us

"It's about DIY & home improvement"