|
|
Rank: Veteran
Joined: 5/11/2004
Posts: 125
Location: NKY
|
Bob Herbert asked me to create this spreadsheet. I am just the number cruncher on this one :user I took the Mt Airy results, sorted by the final score with each division in a separate column. If the divisions are lined up properly, then you get a sliding scale effect as you go from left-to-right and top-to-bottom. (Gee. That's confusing :banghead2 )
I left the original rank (inside divison). I also took the liberty of calculating approximate ratings.
|
|
|
| Approximate ratings |
|
|
|
|
|
|
| | | | Round 1 | 52 - 1016 | 57 - 960 | 62 - 927 | 67 - 881 | | | |
| | | | Round 2 | 52 - 1031 | 57 - 986 | 62 - 942 | 67 - 897 | | | |
| | | | | | | | | | | | | R1 | R2 | Final | Rank | Open - 16 | Open Master - 6 | Advance - 21 | Adv Master - 3 | Open Grand - 5 | Novice - 15 | Open Woman - 3 | Adv Women - 3 | | 52 | 53 | 105 | 1 | Cox, David |
|
|
|
|
|
|
| | 56 | 52 | 108 | 2 | Caldwell, Pete |
|
|
|
|
|
|
| | 55 | 56 | 111 | 3 | Blakely, Matt |
|
|
|
|
|
|
| | 55 | 56 | 111 | 3 | Vandemark, Jeff |
|
|
|
|
|
|
| | 55 | 59 | 114 | 1 |
| Ferrara, Jim |
|
|
|
|
|
| | 61 | 56 | 117 | 5 | Eilerman, P.J. |
|
|
|
|
|
|
| | 59 | 59 | 118 | 6 | Herbert, Bob |
|
|
|
|
|
|
| | 61 | 58 | 119 | 7 | Johansen, Allen |
|
|
|
|
|
|
| | 57 | 64 | 121 | 2 |
| Eades, Jeff |
|
|
|
|
|
| | 62 | 60 | 122 | 3 |
| Mahl, Steve |
|
|
|
|
|
| | 61 | 61 | 122 | 8 | Miller, Phil |
|
|
|
|
|
|
| | 58 | 64 | 122 | 8 | Jones, Adam |
|
|
|
|
|
|
| | 62 | 61 | 123 | 1 |
|
| Dailey, Keith |
|
|
|
|
| | 59 | 64 | 123 | 2 |
|
| Hollingshead, Dan |
|
|
|
|
| | 62 | 61 | 123 | 1 |
|
|
|
| Day, Mike |
|
|
| | 61 | 63 | 124 | 4 |
| Kohles, Hans |
|
|
|
|
|
| | 62 | 63 | 125 | 3 |
|
| Wingert, Matt |
|
|
|
|
| | 59 | 66 | 125 | 1 |
|
|
|
|
| Kinney, Rob |
|
| | 61 | 64 | 125 | 2 |
|
|
|
|
| Brown, Jason |
|
| | 58 | 67 | 125 | 10 | Wade, Kenny |
|
|
|
|
|
|
| | 63 | 63 | 126 | 4 |
|
| Vincent, Tony |
|
|
|
|
| | 65 | 62 | 127 | 5 |
|
| Trimmer, Aaron |
|
|
|
|
| | 63 | 64 | 127 | 1 |
|
|
| Copsy, Tim |
|
|
|
| | 59 | 68 | 127 | 11 | Hutchinson, Gaehl |
|
|
|
|
|
|
| | 62 | 65 | 127 | 11 | Wright, Dave |
|
|
|
|
|
|
| | 65 | 63 | 128 | 6 |
|
| Sierschula, Daniel |
|
|
|
|
| | 64 | 64 | 128 | 6 |
|
| Spencer, Steve |
|
|
|
|
| | 62 | 66 | 128 | 6 |
|
| Kemner, Mike |
|
|
|
|
| | 69 | 59 | 128 | 5 |
| Gambrell, Fishnet Dave |
|
|
|
|
|
| | 67 | 61 | 128 | 13 | Shooner, Ben |
|
|
|
|
|
|
| | 64 | 65 | 129 | 2 |
|
|
| Rucker, James |
|
|
|
| | 65 | 64 | 129 | 6 |
| Marlow, David A. |
|
|
|
|
|
| | 65 | 64 | 129 | 14 | Engle, Nick |
|
|
|
|
|
|
| | 65 | 65 | 130 | 9 |
|
| Barras, Patrick |
|
|
|
|
| | 66 | 64 | 130 | 9 |
|
| Fischer, Chris |
|
|
|
|
| | 60 | 70 | 130 | 1 |
|
|
|
|
|
| Shooner, Liz |
| | 62 | 69 | 131 | 11 |
|
| Smith, Cody |
|
|
|
|
| | 69 | 63 | 132 | 12 |
|
| Bradshaw, Brandon |
|
|
|
|
| | 65 | 67 | 132 | 12 |
|
| Rott, Joe |
|
|
|
|
| | 71 | 62 | 133 | 14 |
|
| Fischer, Joe |
|
|
|
|
| | 69 | 64 | 133 | 14 |
|
| Strange, Doug |
|
|
|
|
| | 67 | 66 | 133 | 14 |
|
| Thompson, Gary |
|
|
|
|
| | 62 | 71 | 133 | 14 |
|
| Hilgefort, Grant |
|
|
|
|
| | 65 | 68 | 133 | 15 | Finnegan, John |
|
|
|
|
|
|
| | 67 | 68 | 135 | 2 |
|
|
|
| Lohman, Don |
|
|
| | 68 | 69 | 137 | 18 |
|
| Multhopp, Hans |
|
|
|
|
| | 69 | 69 | 138 | 3 |
|
|
|
|
| Donathon, Ken |
|
| | 72 | 66 | 138 | 16 | Perica, Mark |
|
|
|
|
|
|
| | 73 | 66 | 139 | 4 |
|
|
|
|
| Helton, Josh |
|
| | 67 | 73 | 140 | 5 |
|
|
|
|
| Anderson, Brad |
|
| | 67 | 74 | 141 | 19 |
|
| Johnston, Matt |
|
|
|
|
| | 72 | 69 | 141 | 3 |
|
|
| Guy, Doug |
|
|
|
| | 69 | 72 | 141 | 6 |
|
|
|
|
| Sloan, Nate |
|
| | 76 | 68 | 144 | 7 |
|
|
|
|
| Javins, Joe |
|
| | 72 | 73 | 145 | 20 |
|
| Pettigrew, Gary |
|
|
|
|
| | 73 | 73 | 146 | 3 |
|
|
|
| Artist, Ken |
|
|
| | 73 | 74 | 147 | 21 |
|
| Hilgefort, Kurt |
|
|
|
|
| | 73 | 74 | 147 | 8 |
|
|
|
|
| Doench, Lou |
|
| | 71 | 77 | 148 | 2 |
|
|
|
|
|
| Farrell, Karen |
| | 76 | 74 | 150 | 4 |
|
|
|
| Clore, Alan |
|
|
| | 76 | 76 | 152 | 9 |
|
|
|
|
| Tscheiner, Dan |
|
| | 73 | 79 | 152 | 10 |
|
|
|
|
| Kling, Andrew |
|
| | 82 | 73 | 155 | 11 |
|
|
|
|
| Montgomery, Jeremy |
|
| | 76 | 80 | 156 | 12 |
|
|
|
|
| Stricker, Gerry |
|
| | 80 | 76 | 156 | 5 |
|
|
|
| Javins, James |
|
|
| | 82 | 78 | 160 | 1 |
|
|
|
|
|
|
| Kellicker, Amanda | | 84 | 80 | 164 | 2 |
|
|
|
|
|
|
| Hollingshead, Alex | | 77 | 87 | 164 | 13 |
|
|
|
|
| Wissel, Alex |
|
| | 85 | 85 | 170 | 14 |
|
|
|
|
| Stupak, Jonathon |
|
| | 86 | 85 | 171 | 3 |
|
|
|
|
|
| Francis, Patty |
| | 106 | 102 | 208 | 3 |
|
|
|
|
|
|
| Burress, Kendra | | 106 | 106 | 212 | 15 |
|
|
|
|
| Hoghn, Tony |
|
|
|
|
Rank: Elite Veteran
Joined: 5/22/2006
Posts: 691
Location: in the chains
|
|
Approximate ratings |
|
|
|
|
|
|
|
|
|
|
|
|
|
Round 1 |
52 - 1016 |
57 - 960 |
62 - 927 |
67 - 881 |
|
|
|
|
|
|
|
Round 2 |
52 - 1031 |
57 - 986 |
62 - 942 |
67 - 897 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| R1 |
R2 |
Final |
Rank |
Open - 16 |
Open Master - 6 |
Advance - 21 |
Adv Master - 3 |
Open Grand - 5 |
Novice - 15 |
Open Woman - 3 |
Adv Women - 3 |
| 52 |
53 |
105 |
1 |
Cox, David |
|
|
|
|
|
|
|
| 56 |
52 |
108 |
2 |
Caldwell, Pete |
|
|
|
|
|
|
|
| 55 |
56 |
111 |
3 |
Blakely, Matt |
|
|
|
|
|
|
|
| 55 |
56 |
111 |
3 |
Vandemark, Jeff |
|
|
|
|
|
|
|
| 55 |
59 |
114 |
1 |
|
Ferrara, Jim |
|
|
|
|
|
|
| 61 |
56 |
117 |
5 |
Eilerman, P.J. |
|
|
|
|
|
|
|
| 59 |
59 |
118 |
6 |
Herbert, Bob |
|
|
|
|
|
|
|
| 61 |
58 |
119 |
7 |
Johansen, Allen |
|
|
|
|
|
|
|
| 57 |
64 |
121 |
2 |
|
Eades, Jeff |
|
|
|
|
|
|
| 62 |
60 |
122 |
3 |
|
Mahl, Steve |
|
|
|
|
|
|
| 61 |
61 |
122 |
8 |
Miller, Phil |
|
|
|
|
|
|
|
| 58 |
64 |
122 |
8 |
Jones, Adam |
|
|
|
|
|
|
|
| 62 |
61 |
123 |
1 |
|
|
Dailey, Keith |
|
|
|
|
|
| 59 |
64 |
123 |
2 |
|
|
Hollingshead, Dan |
|
|
|
|
|
| 62 |
61 |
123 |
1 |
|
|
|
|
Day, Mike |
|
|
|
| 61 |
63 |
124 |
4 |
|
Kohles, Hans |
|
|
|
|
|
|
| 62 |
63 |
125 |
3 |
|
|
Wingert, Matt |
|
|
|
|
|
| 59 |
66 |
125 |
1 |
|
|
|
|
|
Kinney, Rob |
|
|
| 61 |
64 |
125 |
2 |
|
|
|
|
|
Brown, Jason |
|
|
| 58 |
67 |
125 |
10 |
Wade, Kenny |
|
|
|
|
|
|
|
| 63 |
63 |
126 |
4 |
|
|
Vincent, Tony |
|
|
|
|
|
| 65 |
62 |
127 |
5 |
|
|
Trimmer, Aaron |
|
|
|
|
|
| 63 |
64 |
127 |
1 |
|
|
|
Copsy, Tim |
|
|
|
|
| 59 |
68 |
127 |
11 |
Hutchinson, Gaehl |
|
|
|
|
|
|
|
| 62 |
65 |
127 |
11 |
Wright, Dave |
|
|
|
|
|
|
|
| 65 |
63 |
128 |
6 |
|
|
Sierschula, Daniel |
|
|
|
|
|
| 64 |
64 |
128 |
6 |
|
|
Spencer, Steve |
|
|
|
|
|
| 62 |
66 |
128 |
6 |
|
|
Kemner, Mike |
|
|
|
|
|
| 69 |
59 |
128 |
5 |
|
Gambrell, Fishnet Dave |
|
|
|
|
|
|
| 67 |
61 |
128 |
13 |
Shooner, Ben |
|
|
|
|
|
|
|
| 64 |
65 |
129 |
2 |
|
|
|
Rucker, James |
|
|
|
|
| 65 |
64 |
129 |
6 |
|
Marlow, David A. |
|
|
|
|
|
|
| 65 |
64 |
129 |
14 |
Engle, Nick |
|
|
|
|
|
|
|
| 65 |
65 |
130 |
9 |
|
|
Barras, Patrick |
|
|
|
|
|
| 66 |
64 |
130 |
9 |
|
|
Fischer, Chris |
|
|
|
|
|
| 60 |
70 |
130 |
1 |
|
|
|
|
|
|
Shooner, Liz |
|
| 62 |
69 |
131 |
11 |
|
|
Smith, Cody |
|
|
|
|
|
| 69 |
63 |
132 |
12 |
|
|
Bradshaw, Brandon |
|
|
|
|
|
| 65 |
67 |
132 |
12 |
|
|
Rott, Joe |
|
|
|
|
|
| 71 |
62 |
133 |
14 |
|
|
Fischer, Joe |
|
|
|
|
|
| 69 |
64 |
133 |
14 |
|
|
Strange, Doug |
|
|
|
|
|
| 67 |
66 |
133 |
14 |
|
|
Thompson, Gary |
|
|
|
|
|
| 62 |
71 |
133 |
14 |
|
|
Hilgefort, Grant |
|
|
|
|
|
| 65 |
68 |
133 |
15 |
Finnegan, John |
|
|
|
|
|
|
|
| 67 |
68 |
135 |
2 |
|
|
|
|
Lohman, Don |
|
|
|
| 68 |
69 |
137 |
18 |
|
|
Multhopp, Hans |
|
|
|
|
|
| 69 |
69 |
138 |
3 |
|
|
|
|
|
Donathon, Ken |
|
|
| 72 |
66 |
138 |
16 |
Perica, Mark |
|
|
|
|
|
|
|
| 73 |
66 |
139 |
4 |
|
|
|
|
|
Helton, Josh |
|
|
| 67 |
73 |
140 |
5 |
|
|
|
|
|
Anderson, Brad |
|
|
| 67 |
74 |
141 |
19 |
|
|
Johnston, Matt |
|
|
|
|
|
| 72 |
69 |
141 |
3 |
|
|
|
Guy, Doug |
|
|
|
|
| 69 |
72 |
141 |
6 |
|
|
|
|
|
Sloan, Nate |
|
|
| 76 |
68 |
144 |
7 |
|
|
|
|
|
Javins, Joe |
|
|
| 72 |
73 |
145 |
20 |
|
|
Pettigrew, Gary |
|
|
|
|
|
| 73 |
73 |
146 |
3 |
|
|
|
|
Artist, Ken |
|
|
|
| 73 |
74 |
147 |
21 |
|
|
Hilgefort, Kurt |
|
|
|
|
|
| 73 |
74 |
147 |
8 |
|
|
|
|
|
Doench, Lou |
|
|
| 71 |
77 |
148 |
2 |
|
|
|
|
|
|
Farrell, Karen |
|
| 76 |
74 |
150 |
4 |
|
|
|
|
Clore, Alan |
|
|
|
| 76 |
76 |
152 |
9 |
|
|
|
|
|
Tscheiner, Dan |
|
|
| 73 |
79 |
152 |
10 |
|
|
|
|
|
Kling, Andrew |
|
|
| 82 |
73 |
155 |
11 |
|
|
|
|
|
Montgomery, Jeremy |
|
|
| 76 |
80 |
156 |
12 |
|
|
|
|
|
Stricker, Gerry |
|
|
| 80 |
76 |
156 |
5 |
|
|
|
|
Javins, James |
|
|
|
| 82 |
78 |
160 |
1 |
|
|
|
|
|
|
|
Kellicker, Amanda |
| 84 |
80 |
164 |
2 |
|
|
|
|
|
|
|
Hollingshead, Alex |
| 77 |
87 |
164 |
13 |
|
|
|
|
|
Wissel, Alex |
|
|
| 85 |
85 |
170 |
14 |
|
|
|
|
|
Stupak, Jonathon |
|
|
| 86 |
85 |
171 |
3 |
|
|
|
|
|
|
Francis, Patty |
|
| 106 |
102 |
208 |
3 |
|
|
|
|
|
|
|
Burress, Kendra |
| 106 |
106 |
212 |
15 |
|
|
|
|
|
Hoghn, Tony |
|
|
|
|
Rank: Veteran
Joined: 5/11/2004
Posts: 125
Location: NKY
|
I think posting that spreadsheet out there messed with my pc. Brad's reply has a BIG blank space followed by my spreadsheet WITH grid lines  I couldn't get grid lines. Beware of posting spreadsheets :uhoh They may give your pc an upset stomach :uhoh
|
|
Rank: Elite Veteran
Joined: 8/10/2004
Posts: 442
|
Thanks guys.
I just wanted to see where each individual placed, based on nothing but score;
and at the same time, show which division each individual competed in.
There is, as the scores indicate, quite a bit of numeric overlap among the divisions.
There is also some great numeric distance within some of the divisions.
|
|
Rank: Tree Hukker
Joined: 11/7/2003
Posts: 5
|
That's a great spreadsheet. Very interesting to see where everyone stacks up between the divisions. thanks.
|
|
|
Guest |