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.

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old December 14th 04, 03:58 PM
[email protected]
 
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


  #2   Report Post  
Old December 14th 04, 07:26 PM
Ted Edwards
 
Posts: n/a
Default

wrote:

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.


No you didn't. First, http:\\www.metalworking.com doesn't work. It
needs to be http://www.metalworking.com . Second, even after making the
correction, there is no file called Gearcalc.xls there. In fact,
searching on .xls finds nothing and searching on Gear finds lots but no
Gearcalc.xls.

BTW, I was just curious to see just how big that file is since that
problem takes on line of 28 characters in APL. :-)

Ted

  #3   Report Post  
Old December 14th 04, 07:49 PM
Grant Erwin
 
Posts: n/a
Default

Ted Edwards wrote:

BTW, I was just curious to see just how big that file is since that
problem takes on line of 28 characters in APL. :-)


What's APL, Ted?

GWE
  #4   Report Post  
Old December 14th 04, 08:18 PM
Keith Marshall
 
Posts: n/a
Default

No you didn't. First, http:\\www.metalworking.com doesn't work. It
needs to be http://www.metalworking.com . Second, even after making the
correction, there is no file called Gearcalc.xls there. In fact,


It was probably rejected because the dropbox doesn't accept xls files unless
they're inside a zip.

From the "Using the dropbox" page:
"NOTE: This facility does nothing to protect you from viruses and malicious
or simply badly-written programs. Exercise considerable caution if you
download anything other than text, JPGs, or GIF files. Because of the
increasing threat of viruses, files with .exe , .com , .cmd , .bat , .xls ,
or .doc extension types will no longer post to the dropbox directly. The
..xls and .doc file types are excluded because of the recent trend to macro
viruses. Documents should be sent as plain text and have a .txt file
extension. Other prohibited file types should be packaged into 'zip' or some
other similar compressed file along with instructions for their use. This
will make sure the the user at least has the chance to decide if they want
to take the risk of opening the file, instead of having their browser try to
automatically open it for them."

Best Regards,
Keith Marshall


"I'm not grown up enough to be so old!"


"Ted Edwards" wrote in message
...
wrote:

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.


No you didn't. First, http:\\www.metalworking.com doesn't work. It
needs to be http://www.metalworking.com . Second, even after making the
correction, there is no file called Gearcalc.xls there. In fact,
searching on .xls finds nothing and searching on Gear finds lots but no
Gearcalc.xls.

BTW, I was just curious to see just how big that file is since that
problem takes on line of 28 characters in APL. :-)

Ted



  #5   Report Post  
Old December 15th 04, 04:23 AM
Ted Edwards
 
Posts: n/a
Default

Grant Erwin wrote:

BTW, I was just curious to see just how big that file is since that
problem takes on line of 28 characters in APL. :-)


What's APL, Ted?


A Programming Language. Originally developed by Ken Iverson. I use
IBM's APL2 implementation. If interested, there's some good stuff on
IBM's site including a free demo version. It's extremely powerful, very
interactive and handles arrays as easily as scalars.

http://www-306.ibm.com/software/awdtools/apl/

Ted




Reply
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 02:50 PM.

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

About Us

"It's about DIY & home improvement"

 

Copyright © 2017