Gear Combos.xlsx

	A	B	C	D	E	F	G	H	J
1	Gear Combos Made Easier
2
3
4	My Bike # 1								Questions: wwetzelberg@gmail.com
5
6			Chainrings - Triple			Wheel	Total	Lowest	This copy is read-only. It needs to be copied to your computer or workspace.
7	Cog #	Rear Cogs	28	40	53	27
8	1	12	63	90	119				Instructions to Copy:
9	2	13	58	83	110
10	3	14	54	77	102				To your computer:
11	4	15	50	72	95				Click File -> Download -> Microsft Excel (.xlsx)
12	5	16	47	68	89		15		Follow prompts
13	6	18	42	60	80		18
14	7	21	36	51	68		21		To your Google workspace:
15	8	24	32	45	60		24	<<<	Log into Google
16	9	28	27	39	51		27		Click File -> Make a Copy
17	10	36	21	30	40		30		Follow prompts
18	11	42	18	26	34		33
19	12	52	15	21	28		36
20									Notes:
21
22									Make changes only in the blue areas
23									Count teeth on cogs and chainrings (typically debossed on them)
24	My Bike # 2								Wheel is wheel diameter rounded to nearest inch (it's not rocket science)
25									Use 27 for 700C wheels, 26 for mountain bikes
26			Chainrings - Double		Wheel	Total	Lowest		Cogs are numbered from smallest to largest, which is highest to lowest
27	Cog #	Rear Cogs	39	53	27				Total column is the number of gear combinations (chainrings x cogs)
28	1	11	96	130					Cogs # 10, 11, 12 are maximum size cogs, use your numbers
29	2	12	88	119					Use the Lowest column to flag your lowest gears on each chainring
30	3	13	81	110					Ignore rows below your Lowest column flag
31	4	14	75	102					Note that I used the less-than sign for my Lowest column flag
32	5	15	70	95		10
33	6	17	62	84		12
34	7	19	55	75		14
35	8	21	50	68		16
36	9	23	46	62		18	<<<
37	10	36	29	40		20
38	11	42	25	34		22
39	12	52	20	28		24
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100