PDA

View Full Version : Help with Excel


turnerseng
Wed 29 July 2009, 05:34
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

Gerald D
Wed 29 July 2009, 05:41
How is this related to building a MechMate?

MetalHead
Wed 29 July 2009, 05:46
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