MK7 Trans ratios.xlsx

	A	B	C	D	E	F	G	H	I
1	MK7 Gear Ratio Calculator/Comparison Tool by Derhase
2	Instructions: Click FILE > MAKE A COPY to edit on your own Drive. Enter your redline and tire size, and choose transmissions from the drop down menus to compare max speeds in each gear. Complete this page before any others!
3
4		Enter max RPM:	6600	24.72		Enter max RPM:	6,600	24.72
5	Tire size:	245	40	17	Tire size:	245	40	17	Right side will mirror the left UNLESS MANUALLY OVERWRITTEN
6
7			Select trans:	GTI DQ381	Compare:	GTI DQ250
8		FD per gear	Ratio	Total ratio	Gear	Total ratio	Ratio	FD per gear
9		4.17	3.40	14.18	1	13.98	2.93	4.77
10		3.13	2.75	8.61	2	8.54	1.79	4.77
11		3.13	1.77	5.54	3	5.39	1.13	4.77
12		4.17	0.93	3.88	4	3.67	0.77	4.77
13		4.17	0.71	2.96	5	2.79	0.81	3.44
14		3.13	0.76	2.38	6	2.20	0.64	3.44
15		3.13	0.64	2.00	7
16
17				GTI DQ381	Comparison	GTI DQ250
18			MPH/KPH -->	MPH	Speed per gear	MPH
19				34.23	1	34.73
20				56.38	2	56.84
21				87.60	3	90.04
22				125.14	4	132.14
23				163.92	5	174.18
24				204.02	6	220.44
25				242.27	7
26
27
28
29
30
31
32
33
34
35
36
37
38
39
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