Uncle Barn's Excel Spread Sheet Gearing Calculator (Sample)
 this is not a working copy!
 Order your FREE working copy in our Free software section!

BIKE HIGHWAYIm just a small cog in a big chain
 

Rear Cogs in Yellow

Front

  

1st Cog

2nd Cog

3rd Cog

4th Cog

5th Cog

6th Cog

7th Cog

8th Cog

9th Cog

Chain Rings

  

32

24

21

18

16

14

13

12

11

1st Chain Ring

32

10.0

13.3

15.2

17.8

20.0

22.9

24.6

26.7

29.1

2nd Chain Ring

42

13.1

17.5

20.0

23.3

26.3

30.0

32.3

35.0

38.2

3rd Chain Ring

52

16.3

21.7

24.8

28.9

32.5

37.1

40.0

43.3

47.3

To test new combinations, just change the number of cog or chain ring teeth.