A DIY & home improvement forum. DIYbanter

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » DIYbanter forum » Do - it - Yourself » Metalworking
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

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.

Excel spreadsheet for cutting gears using a rotary table



 
 
LinkBack Thread Tools Display Modes
  #1  
Old December 14th 04, 04:58 PM
[email protected]
external usenet poster
 
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

Ads
  #2  
Old December 14th 04, 08:26 PM
Ted Edwards
external usenet poster
 
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  
Old December 14th 04, 08:49 PM
Grant Erwin
external usenet poster
 
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  
Old December 14th 04, 09:18 PM
Keith Marshall
external usenet poster
 
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  
Old December 15th 04, 05:23 AM
Ted Edwards
external usenet poster
 
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


 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
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 03:52 PM
Heavy Duty rotary table Wild Bill Metalworking 0 September 22nd 03 05:53 AM
Cutting pullies on a rotary table on a mill frank Metalworking 8 July 18th 03 07:42 PM
Question about Vetex 6" Rotary Table keith Metalworking 0 July 11th 03 08:24 PM


All times are GMT +1. The time now is 07:58 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.SEO by vBSEO ©2010, Crawlability, Inc.
Copyright 2004-2014 DIYbanter.
The comments are property of their posters.