Gears

L

Luciano

Hello people,
I have interest in using Excel in order to evaluate pairs and triads of gears according to their teeth and pitch contacts. Taking into account that some gears could be turning clockwise or counterclockwise my interest is listall possible pairs or triads (in the case of three gears) after 360 degrees rotation and several full cycles. For example if I have three wheels: A, B, and C; and they have 18, 20, and 7 tooth (or pitches) numbered from 1 tothe last one (1-18, 1-20, or 1-7). If they coordinate and A and C are rotating clockwise and B is rotating counterclockwise, I would have for the first triads:
A B C
1 20 1
2 19 2
3 18 3
4 17 4
5 16 5
6 15 6
7 14 7
8 13 1
9 12 2
10 11 3
11 10 4
12 9 5
13 8 6
14 7 7
15 6 1
16 5 2
17 4 3
18 3 4
1 2 5
2 1 6
3 20 7
4 19 1
5 18 2
6 17 3
7 16 4
8 15 5
9 14 6
10 13 7
11 12 1
12 11 2
13 10 3
14 9 4
15 8 5
16 7 6
17 6 7
18 5
4
3
2
1

Since I have to investigate hundreds and even thousand of pairs and triads of them rotaing clockwise or counterclockwise, somebody have any idea how could I develop a worksheet or a VBA code to perform such operations? I needspecify the number of tooth (or pitches) of each gear that can be always 2or three, number of degrees (e.g. 360 degree) or cycles, and the sense (clockwise or counterclockwise of each one), The results should be listed in sheet columns A, B, and C for example.
Thanks in advance,
Luciano
 
G

GS

This definitely sounds like homework to me. IIRC, this is straight out
of a Mech Eng 101 text book! It's probably already been done so take a
look in "Machinery's Handbook" or "Engineering Formulas" which are both
standard text books from Industrial Press Inc that are commonly used in
mech-tech programs.

In your scenario, gearA should always be the 'drive gear'. GearB should
always be 'driven' by gearA. GearC should always be 'driven' by gearB.
You should be able to switch them around at will and your formulas
adjust accordingly. If you set your worksheet up so the pitch (num
teeth) are in named cells then your formulas can ref those for any
combination. Design the formulas to calc number of turns for B[C] to 1
turn A.

Back in the day.., we would attach degree wheels to the gears and take
readings at the marker position for each at whatever degree of
revolution of the drive gear we chose/needed. Now, my CAD software
computes this automatically and so after using it for over 20 years
I've forgotten the formulas we used prior to using degree wheels. I
suppose I could look them up but, since you are going to do that now
anyway<g>...

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion
 
L

Luciano

Em sábado, 23 de março de 2013 19h36min52s UTC-3, Luciano escreveu:
Hello people,

I have interest in using Excel in order to evaluate pairs and triads of gears according to their teeth and pitch contacts. Taking into account that some gears could be turning clockwise or counterclockwise my interest is list all possible pairs or triads (in the case of three gears) after 360 degrees rotation and several full cycles. For example if I have three wheels: A, B, and C; and they have 18, 20, and 7 tooth (or pitches) numbered from 1 to the last one (1-18, 1-20, or 1-7). If they coordinate and A and C are rotating clockwise and B is rotating counterclockwise, I would have for the first triads:

A B C

1 20 1

2 19 2

3 18 3

4 17 4

5 16 5

6 15 6

7 14 7

8 13 1

9 12 2

10 11 3

11 10 4

12 9 5

13 8 6

14 7 7

15 6 1

16 5 2

17 4 3

18 3 4

1 2 5

2 1 6

3 20 7

4 19 1

5 18 2

6 17 3

7 16 4

8 15 5

9 14 6

10 13 7

11 12 1

12 11 2

13 10 3

14 9 4

15 8 5

16 7 6

17 6 7

18 5

4

3

2

1



Since I have to investigate hundreds and even thousand of pairs and triads of them rotaing clockwise or counterclockwise, somebody have any idea howcould I develop a worksheet or a VBA code to perform such operations? I need specify the number of tooth (or pitches) of each gear that can be always2 or three, number of degrees (e.g. 360 degree) or cycles, and the sense (clockwise or counterclockwise of each one), The results should be listed insheet columns A, B, and C for example.

Thanks in advance,

Luciano
Click to expand...

Hi Garry,
In fact it is not a homework, and engineer is not my professional area. I just would like to use such approach in order to investigate some aspects ofthe correlation between pairs and triads of numbers matching among them, something similar for example to Mayan and other ancient civilizations calendars. So, Excel would be a very nice solution.
Thank you for your suggetoons, anyway!
Luciano
 
L

Luciano

Em sábado, 23 de março de 2013 19h36min52s UTC-3, Luciano escreveu:
Hello people,

I have interest in using Excel in order to evaluate pairs and triads of gears according to their teeth and pitch contacts. Taking into account that some gears could be turning clockwise or counterclockwise my interest is list all possible pairs or triads (in the case of three gears) after 360 degrees rotation and several full cycles. For example if I have three wheels: A, B, and C; and they have 18, 20, and 7 tooth (or pitches) numbered from 1 to the last one (1-18, 1-20, or 1-7). If they coordinate and A and C are rotating clockwise and B is rotating counterclockwise, I would have for the first triads:

A B C

1 20 1

2 19 2

3 18 3

4 17 4

5 16 5

6 15 6

7 14 7

8 13 1

9 12 2

10 11 3

11 10 4

12 9 5

13 8 6

14 7 7

15 6 1

16 5 2

17 4 3

18 3 4

1 2 5

2 1 6

3 20 7

4 19 1

5 18 2

6 17 3

7 16 4

8 15 5

9 14 6

10 13 7

11 12 1

12 11 2

13 10 3

14 9 4

15 8 5

16 7 6

17 6 7

18 5

4

3

2

1



Since I have to investigate hundreds and even thousand of pairs and triads of them rotaing clockwise or counterclockwise, somebody have any idea howcould I develop a worksheet or a VBA code to perform such operations? I need specify the number of tooth (or pitches) of each gear that can be always2 or three, number of degrees (e.g. 360 degree) or cycles, and the sense (clockwise or counterclockwise of each one), The results should be listed insheet columns A, B, and C for example.

Thanks in advance,

Luciano
Click to expand...

I`m sorry Garry!
 
G

GS

No problem! You can probably search for this online, then use Excel to
do your evaluations.

Best wishes...

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion
 
L

Luciano

Em sábado, 23 de março de 2013 19h36min52s UTC-3, Luciano escreveu:
Hello people,

I have interest in using Excel in order to evaluate pairs and triads of gears according to their teeth and pitch contacts. Taking into account that some gears could be turning clockwise or counterclockwise my interest is list all possible pairs or triads (in the case of three gears) after 360 degrees rotation and several full cycles. For example if I have three wheels: A, B, and C; and they have 18, 20, and 7 tooth (or pitches) numbered from 1 to the last one (1-18, 1-20, or 1-7). If they coordinate and A and C are rotating clockwise and B is rotating counterclockwise, I would have for the first triads:

A B C

1 20 1

2 19 2

3 18 3

4 17 4

5 16 5

6 15 6

7 14 7

8 13 1

9 12 2

10 11 3

11 10 4

12 9 5

13 8 6

14 7 7

15 6 1

16 5 2

17 4 3

18 3 4

1 2 5

2 1 6

3 20 7

4 19 1

5 18 2

6 17 3

7 16 4

8 15 5

9 14 6

10 13 7

11 12 1

12 11 2

13 10 3

14 9 4

15 8 5

16 7 6

17 6 7

18 5

4

3

2

1



Since I have to investigate hundreds and even thousand of pairs and triads of them rotaing clockwise or counterclockwise, somebody have any idea howcould I develop a worksheet or a VBA code to perform such operations? I need specify the number of tooth (or pitches) of each gear that can be always2 or three, number of degrees (e.g. 360 degree) or cycles, and the sense (clockwise or counterclockwise of each one), The results should be listed insheet columns A, B, and C for example.

Thanks in advance,

Luciano
Click to expand...

I always look for some possible solution on line prior try use the group/forum.
Thank you!
Luciano
 
L

Luciano

Hello people,
I have interest in using Excel in order to evaluate pairs and triads of gears according to their teeth and pitch contacts. Taking into account that some gears could be turning clockwise or counterclockwise my interest is listall possible pairs or triads (in the case of three gears) after 360 degrees rotation and several full cycles. For example if I have three wheels: A, B, and C; and they have 18, 20, and 7 tooth (or pitches) numbered from 1 tothe last one (1-18, 1-20, or 1-7). If they coordinate and A and C are rotating clockwise and B is rotating counterclockwise, I would have for the first triads:
A B C
1 20 1
2 19 2
3 18 3
4 17 4
5 16 5
6 15 6
7 14 7
8 13 1
9 12 2
10 11 3
11 10 4
12 9 5
13 8 6
14 7 7
15 6 1
16 5 2
17 4 3
18 3 4
1 2 5
2 1 6
3 20 7
4 19 1
5 18 2
6 17 3
7 16 4
8 15 5
9 14 6
10 13 7
11 12 1
12 11 2
13 10 3
14 9 4
15 8 5
16 7 6
17 6 7
18 5
4
3
2
1

Since I have to investigate hundreds and even thousand of pairs and triads of them rotaing clockwise or counterclockwise, somebody have any idea how could I develop a worksheet or a VBA code to perform such operations? I needspecify the number of tooth (or pitches) of each gear that can be always 2or three, number of degrees (e.g. 360 degree) or cycles, and the sense (clockwise or counterclockwise of each one), The results should be listed in sheet columns A, B, and C for example.
Thanks in advance,
Luciano
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Function for combinations 15
For Loop 9
Using FIND to highlight text (with dashes) 4
Countdown macro - display settings 2
Arriving at totals 2
Problems with AutoFilter macro 2
Runtime error 13 : type mismatch 2
Ranking 3

Top