MechMate CNC Router Forum

Go Back   MechMate CNC Router Forum > Archives
Register Options Profile Last 1 | 3 | 7 Days Search Today's Posts Mark Forums Read

Closed Thread
 
Thread Tools
  #1  
Old Wed 29 July 2009, 05:34
turnerseng
Just call me: andy
 
PMB
South Africa
Help with Excel

I want to be able to calculate change gears for a gear hobber and was hoping to use excel `to do this.
I need to solve
a/b*c/d=known ratio
a,b,c,d
are the available change gears from 20 to 120 (number of teeth on the gear)
can someone please help?
cheers andrew
  #2  
Old Wed 29 July 2009, 05:41
Gerald D
Just call me: Gerald (retired)
 
Cape Town
South Africa
How is this related to building a MechMate?
  #3  
Old Wed 29 July 2009, 05:46
MetalHead
Just call me: Mike
 
Columbiana AL
United States of America
a/b*c/d=known ratio

Formula for your cell will be

=sum(a/b)*(c/d)

but I do not know how to make is pretty where you can just plug in the numbers
Closed Thread

Register Options Profile Last 1 | 3 | 7 Days Search Today's Posts Mark Forums Read

Thread Tools

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

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -6. The time now is 03:38.


Powered by vBulletin® Version 3.8.3
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.