Welcome Guest Search | Active Topics | Members

CCS Analysis Options
rangel
Posted: Monday, April 23, 2007 1:01:36 PM

Rank: Veteran

Joined: 5/11/2004
Posts: 136
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

 

andersab
Posted: Monday, April 23, 2007 5:05:24 PM

Rank: Elite Veteran

Joined: 5/22/2006
Posts: 692
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

rangel
Posted: Tuesday, April 24, 2007 5:46:40 AM

Rank: Veteran

Joined: 5/11/2004
Posts: 136
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 laugh I couldn't get grid lines.

Beware of posting spreadsheets :uhoh They may give your pc an upset stomach :uhoh
bobherb
Posted: Tuesday, April 24, 2007 8:04:10 AM

Rank: Elite Veteran

Joined: 8/10/2004
Posts: 449
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.
Hans
Posted: Thursday, April 26, 2007 3:39:57 PM
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.
Users browsing this topic
Guest


Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

Main Forum RSS : RSS

YAFPro Theme Created by Jaben Cargman (Tiny Gecko)
Yet Another Forum.net version 1.9.1.7 running under DotNetNuke.
Copyright © 2003-2006 Yet Another Forum.net. All rights reserved.