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 how could 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 always 2 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 in sheet columns A, B, and C for example.
Thanks in advance,
Luciano

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

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 how could 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 always 2 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 in sheet columns A, B, and C for example.

Thanks in advance,

Luciano

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 of the 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

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 how could 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 always 2 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 in sheet columns A, B, and C for example.

Thanks in advance,

Luciano

I`m sorry Garry!

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

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 how could 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 always 2 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 in sheet columns A, B, and C for example.

Thanks in advance,

Luciano

I always look for some possible solution on line prior try use the group/forum.
Thank you!
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 how could 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 always 2 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 in sheet columns A, B, and C for example.

Thanks in advance,

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 how could 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 always 2 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 in sheet columns A, B, and C for example.

Thanks in advance,

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 how could 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 always 2 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 in sheet columns A, B, and C for example.

Thanks in advance,

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 how could 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 always 2 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 in sheet columns A, B, and C for example.

Thanks in advance,

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 how could 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 always 2 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 in sheet columns A, B, and C for example.

Thanks in advance,

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 how could 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 always 2 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 in sheet columns A, B, and C for example.

Thanks in advance,

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 how could 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 always 2 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 in sheet columns A, B, and C for example.

Thanks in advance,

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 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 how could 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 always 2 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 in sheet columns A, B, and C for example.
Thanks in advance,
Luciano

Em quinta-feira, 18 de julho de 2013 16h47min27s 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 how could 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 always 2 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 in sheet columns A, B, and C for example.

Thanks in advance,

Luciano