Spreadsheet: 103277d1301043064-if-formula-for-corresponding-tables-auto-adjust
Sheet: Sheet1

TABLE ONE |  |  |  |  |  |  |  |  | TABLE TWO
# | TH age | Distance | Lengths | Before | 100% Adjusted |  |  |  | distance | barrier | % before barrier | 100% adj number
1 | 2 yrs | 1000 m | 9.65 | 0.89 |  |  |  |  | 1000 m | 1 | 0.5
2 | 2 yrs | 1000 m | 9.45 | 0.86 |  |  |  |  | 1200 m | 1 | 0.5
3 | 2 yrs | 1000 m | 9.25 | 0.81 |  |  |  |  | 1400 m | 1 | 0.5
4 | 2 yrs | 1000 m | 9.1 | 0.75 |  |  |  |  | 1600 m | 1 | 0.5
5 | 2 yrs | 1000 m | 8.95 | 0.77 |  |  |  |  | 1800 m | 1 | 0.5
6 | 2 yrs | 1000 m | 8.85 | 0.78 |  |  |  |  | 2200 m | 1 | 0.5
7 | 2 yrs | 1000 m | 8.75 | 0.84 |  |  |  |  | 2400 m | 1 | 0.5
8 | 2 yrs | 1000 m | 8.55 | 0.63 |  |  |  |  | 2850 m | 1 | 0.5
9 | 2 yrs | 1000 m | 8.3 | 0.55 |  |  |  |  | 3200 m | 1 | 0.5
10 | 2 yrs | 1000 m | 8.25 | 0.7
11 | 2 yrs | 1000 m | 8.25 | 0.54
12 | 2 yrs | 1000 m | 8.05 | 0.61
13 | 2 yrs | 1000 m | 8.05 | 0.5
14 | 2 yrs | 1000 m | 6.25 | 0.5
15 | 2 yrs | 1200 m | 11.57 | 0.96
16 | 2 yrs | 1200 m | 11.52 | 0.91
17 | 2 yrs | 1200 m | 11.48 | 0.96
18 | 2 yrs | 1200 m | 11.43 | 0.92
19 | 2 yrs | 1200 m | 11.38 | 0.94
20 | 2 yrs | 1200 m | 11.29 | 0.89
21 | 2 yrs | 1200 m | 11.1 | 0.84
22 | 2 yrs | 1200 m | 11.1 | 0.86
23 | 2 yrs | 1200 m | 11.05 | 0.84
24 | 2 yrs | 1200 m | 11 | 0.89
25 | 2 yrs | 1200 m | 10.95 | 0.82
26 | 2 yrs | 1200 m | 10.9 | 0.96
27 | 2 yrs | 1200 m | 10.81 | 0.84
28 | 2 yrs | 1200 m | 10.76 | 0.79
29 | 2 yrs | 1200 m | 10.67 | 0.81
30 | 2 yrs | 1200 m | 10.67 | 0.76
31 | 2 yrs | 1200 m | 10.62 | 0.73
32 | 2 yrs | 1200 m | 10.48 | 0.73
33 | 2 yrs | 1200 m | 10.48 | 0.86
34 | 2 yrs | 1200 m | 10.43 | 0.79
35 | 2 yrs | 1200 m | 10.43 | 0.7
36 | 2 yrs | 1200 m | 10.29 | 0.68
37 | 2 yrs | 1200 m | 10.24 | 0.79
38 | 2 yrs | 1200 m | 10.24 | 0.66
39 | 2 yrs | 1200 m | 10.19 | 0.65
40 | 2 yrs | 1200 m | 10.14 | 0.64
41 | 2 yrs | 1200 m | 10 | 0.58
42 | 2 yrs | 1200 m | 9.95 | 0.57
43 | 2 yrs | 1200 m | 9.95 | 0.73
44 | 2 yrs | 1200 m | 9.81 | 0.56
45 | 2 yrs | 1200 m | 9.71 | 0.66
46 | 2 yrs | 1200 m | 9.71 | 0.64
47 | 2 yrs | 1200 m | 9.71 | 0.53
48 | 2 yrs | 1200 m | 9.67 | 0.52
49 | 2 yrs | 1200 m | 9.57 | 0.62
50 | 2 yrs | 1200 m | 9.57 | 0.5
51 | 2 yrs | 1200 m | 9.43 | 0.59
52 | 2 yrs | 1200 m | 7.62 | 0.52
53 | 2 yrs | 1400 m | 12.91 | 1
54 | 2 yrs | 1400 m | 12.5 | 0.92
55 | 2 yrs | 1400 m | 12.45 | 0.95
56 | 2 yrs | 1400 m | 12.45 | 0.94
57 | 2 yrs | 1400 m | 12.41 | 0.93
58 | 2 yrs | 1400 m | 12.36 | 0.89
59 | 2 yrs | 1400 m | 12.27 | 0.92
60 | 2 yrs | 1400 m | 12.27 | 0.91
61 | 2 yrs | 1400 m | 12.18 | 0.85
62 | 2 yrs | 1400 m | 12.09 | 0.86
63 | 2 yrs | 1400 m | 12 | 0.86
64 | 2 yrs | 1400 m | 12 | 0.81
65 | 2 yrs | 1400 m | 11.95 | 0.83
66 | 2 yrs | 1400 m | 11.77 | 0.79
67 | 2 yrs | 1400 m | 11.77 | 0.78
68 | 2 yrs | 1400 m | 11.73 | 0.91
69 | 2 yrs | 1400 m | 11.68 | 0.88
70 | 2 yrs | 1400 m | 11.68 | 0.75
71 | 2 yrs | 1400 m | 11.64 | 0.75
72 | 2 yrs | 1400 m | 11.64 | 0.89
73 | 2 yrs | 1400 m | 11.64 | 0.76
74 | 2 yrs | 1400 m | 11.64 | 0.74
75 | 2 yrs | 1400 m | 11.55 | 0.74
76 | 2 yrs | 1400 m | 11.5 | 0.81
77 | 2 yrs | 1400 m | 11.45 | 0.72
78 | 2 yrs | 1400 m | 11.45 | 0.66
79 | 2 yrs | 1400 m | 11.41 | 0.69
80 | 2 yrs | 1400 m | 11.27 | 0.66
81 | 2 yrs | 1400 m | 10.95 | 0.62
82 | 2 yrs | 1400 m | 10.91 | 0.6
83 | 2 yrs | 1400 m | 10.86 | 0.72
84 | 2 yrs | 1400 m | 10.82 | 0.68
85 | 2 yrs | 1400 m | 10.82 | 0.56
86 | 2 yrs | 1400 m | 10.73 | 0.68
87 | 2 yrs | 1400 m | 10.73 | 0.68
88 | 2 yrs | 1400 m | 10.64 | 0.63
89 | 2 yrs | 1400 m | 10.64 | 0.52
90 | 2 yrs | 1400 m | 10.55 | 0.59
91 | 2 yrs | 1400 m | 10.55 | 0.5
92 | 2 yrs | 1400 m | 10.27 | 0.58
93 | 2 yrs | 1400 m | 10.14 | 0.54
94 | 2 yrs | 1400 m | 10.09 | 0.5
95 | 2 yrs | 1400 m | 9.95 | 0.5
96 | 2 yrs | 1400 m | 8.45 | 0.54
97 | 2 yrs | 1600 m | 13.17 | 0.99
98 | 2 yrs | 1600 m | 11.83 | 0.81
99 | 2 yrs | 1600 m | 8.96 | 0.57