Best Crash-B competitors from '03 thru '10 (50-64)

[mikvan52]

Ever wonder who is the "winningest" at Crash-B, the World Indoor Rowing Championship ?

As by own focus is those over 50 and less than 65, I created a table for such an age range.
I leave it to others to review different age/sex sampling.

I looked at the crash-b.org site results. Historical records are now posted there from 2003-2010 (8 years).
If we assigned:
5 points for a win
3 points for silver
1 point for bronze

who would come out on top witht he most total points for these last eight years?

The results might surprise some. (this is only a partial compilation):

1st place: James Castellan...............29
2nd place: Frede Norskov-Nielsen...18
3rd place: Robert Spousta................15
3rd place: Steve Krum....................15
3rd place: Stan Vegar.....................15
6th place: Roy Brook .....................13
7th place: Dennis Hastings.............11

Naturally, there are those like Paul Siebach who have only had a short time in this age group who are gaining fast!
Paul has a perfect record so far with two 1st's (10 points).

I hope the crash-b people will finish reposting earlier years than 2003 so the table can be completed.
(So far there are 55 people with at least 1 point)

EDIT: I'm now in the process of adding the the missing years of this millennium, using the provided in a reply (thanks!)

[jliddil]

http://www.crash-b.org/web/wp-content/u ... ults/2000/

Just change the /YYYY/ to what ever year you need

[Bob S.]

http://www.crash-b.org/web/wp-content/u ... ults/2000/

Just change the /YYYY/ to what ever year you need

But it doesn't give the ages. Everyone is in one long list, with only one first place, the fastest time of the event.

Bob S.

Well, O.K. that was for 1995. I see that for later year reports there are more details.

[jliddil]

I'm extracting all the data now to a PDF so it is all nice and bookmarked etc. Anyone wanting it can PM me and I'll send it when it is done. I need to clean it up though and I have no idea how large it will be since it is up to 1000 pages now but much of the material is unnecessary.

[mikvan52]

I should point out that a little interpretation of some results is necessary.

example: some years ago awards were not given for 5-year age groups.
My table (1st post of thread reference) treats a 55-59 year old guy form years ago as a point winner for continuity's sake.

IOW: In the 50-59 men there are 4 divisions each and every year:
50-54 lwt
50-54 hwt
55-59 lwt
55-59 hwt

Reading old files can be difficult at first!

[mikvan52]

So far the table looks something like this (unsorted)(poor IT skills)

.................00 01 02 03 04 05 06 07 08 09 10 11 12 tot
Cashin,Dick 5 5 10
Brinsfield,Jim 3 3
McGoldrick,Jim 1 1 2
Castellan,James 5 3 5 5 5 3 3 29
Hinsby,Tom 3 3
Dreissigacker,Dick 3 1 1 5
Hastings,Dennis 5 1 5 11
Ylonen,Taisto 3 3
Mangin,Alain 5 5
Christiansen,Aage 1 1
Bayko,Rick 3 5 8
Lakin,Robert 1 1
SCHUSTER,RAIMUND 5 5
KRUM,STEVE 3 3 1 3 5 15
WATT,GRAHAM 5 5
NORSKOV NIELSEN,FREDE 3 5 5 5 18
Spousta,Robert 5 5 5 10
LOW,MARTYN 1 3 1 5
Rodday,Willie 3 3
Street,Randy 1 1
Bone,Jon 5 1 1 7
Foss,Tore 5 1 3 1 10
Hislop,David 3 3
Buckley,Rob 1 1
OToole,Larry 1 5 6
Harvey,John 3 3
Baker,Henry 1 1
Vegar, Stan 5 5 5 15
Bainbridge, Steve 3 3
Nelson, Steve 1 1
Brook, Roy 5 3 5 13
Plitzner, Franz 3 3
Willis, Robert 1 1
Glover, Nigel 3 3
Romoli, Emanuele 3 3
Passler, Gary 1 1
Schuster, Raimund 5 5
Cooper, Chris 3 3 6
Updegrave, Walter 1 3 1 5
van Beuren, Michael 5 1 5 11
.................00 01 02 03 04 05 06 07 08 09 10 11 12 tot
Simonsen, Tor Arne 1 1
Siebach,Paul 5 5 10
Kohler, Bernhard 3 3 6
Mare, Frederik 1 1
Busk, John 1 1
Marullo, Michele 5 5
Gray, David 3 3
Ives, Chris 1 1
Slavin, Michael 1 1
LaForme, Mel 3 3
Rich, Jonathan 3 3
Passler, Gary 1 1
Dreisigacker,Peter 3 3
Hendershott,Paul 5 5
Ajello,Bob 1 1

Note: the number on the right is the total.
Eg: Dick Cashin 5+5 = 10

[Bob S.]

So far the table looks something like this (unsorted)(poor IT skills)

.................00 01 02 03 04 05 06 07 08 09 10 11 12 tot
Cashin,Dick 5 5 10
Brinsfield,Jim 3 3
McGoldrick,Jim 1 1 2
Castellan,James 5 3 5 5 5 3 3 29
Hinsby,Tom 3 3
Dreissigacker,Dick 3 1 1 5
Hastings,Dennis 5 1 5 11
Ylonen,Taisto 3 3
Mangin,Alain 5 5
Christiansen,Aage 1 1
Bayko,Rick 3 5 8
Lakin,Robert 1 1
SCHUSTER,RAIMUND 5 5
KRUM,STEVE 3 3 1 3 5 15
WATT,GRAHAM 5 5
NORSKOV NIELSEN,FREDE 3 5 5 5 18
Spousta,Robert 5 5 5 10
LOW,MARTYN 1 3 1 5
Rodday,Willie 3 3
Street,Randy 1 1
Bone,Jon 5 1 1 7
Foss,Tore 5 1 3 1 10
Hislop,David 3 3
Buckley,Rob 1 1
OToole,Larry 1 5 6
Harvey,John 3 3
Baker,Henry 1 1
Vegar, Stan 5 5 5 15
Bainbridge, Steve 3 3
Nelson, Steve 1 1
Brook, Roy 5 3 5 13
Plitzner, Franz 3 3
Willis, Robert 1 1
Glover, Nigel 3 3
Romoli, Emanuele 3 3
Passler, Gary 1 1
Schuster, Raimund 5 5
Cooper, Chris 3 3 6
Updegrave, Walter 1 3 1 5
van Beuren, Michael 5 1 5 11
.................00 01 02 03 04 05 06 07 08 09 10 11 12 tot
Simonsen, Tor Arne 1 1
Siebach,Paul 5 5 10
Kohler, Bernhard 3 3 6
Mare, Frederik 1 1
Busk, John 1 1
Marullo, Michele 5 5
Gray, David 3 3
Ives, Chris 1 1
Slavin, Michael 1 1
LaForme, Mel 3 3
Rich, Jonathan 3 3
Passler, Gary 1 1
Dreisigacker,Peter 3 3
Hendershott,Paul 5 5
Ajello,Bob 1 1

Note: the number on the right is the total.
Eg: Dick Cashin 5+5 = 10

Questions: What does 00 ...... 12 signify? If years, why the 11 and 12?
Note, when I clicked on reply, it showed up in a different format, with the numbers spread out so that it looks like they are lined up under the years, but this put some entries under 11 and 12.

Why are there two lines of the 00 ...... 12?

Can you get them in order, either alphabetical or by decreasing total?

No Cureton entries?

Do the names with capital letters have any significance?

Not criticisms, just idle curiosity.

Bob S.

[Nomugie]

And why only men?

[Bob S.]

And why only men?

Well, yes, but in selecting 50-65, Mike is looking mainly at his own bracket (I think that the 65 was a slip - the appropriate set of three half decades would be 50-64), although he does include both HWt and LWt.

If the women 50-64 were included, Joan and Anna would be way up on top.

Bob S.

[mikvan52]

EDIT: I'm now in the process of adding the the missing years of this millennium, using the provided in a reply (thanks!)

As I'm not particularly computer savvy, I'm still in the process of compiling this table by hand.... tedious work!

Here's the raw data for the year 2000

2000 C.R.A.S.H.-B. Sprints World Indoor Rowing Championships
Results of Event: Veteran Men (Overall -
1st 55-59 hwt 3 Hendershott,Paul Elkhart Regatta 56 6:06.80 0:18.0 6:24.80



2nd 55-59 hwt 11 Jones,Daniel Squamscott Scullers 55 6:24.60 0:15.0 6:39.60



1st 50-54 hwt 16 Slocum,Rob Norwalk River Rowing Club 50 6:28.90 0:00.0 6:28.90

2nd 50-54 hwt 17 Dreissigacker,Dick Motley Rowing Club 52 6:30.30 0:06.0 6:36.30

3rd 50-54 hwt 18 Fenner,Graham Unattached 51 6:33.00 0:03.0 6:36.00

1st 50-54 lwt 19 Tardieau,Jean Paul Unattached 50 6:33.00 0:00.0 6:33.00 Lightweight

3rd 55-59 hwt 20 Jacobowitz,David Ralph's Basement 57 6:34.20 0:21.0 6:55.20

2nd 50-54 lwt21 Blumberg,Kurt Rocky Mountain Rowing Club 54 6:34.50 0:12.0 6:46.50 Lightweight

3rd 50-54 lwt26 Meredith,George Unattached 51 6:39.20 0:03.0 6:42.20 Lightweight

1st 55-59 lwt 33 Sykes,Jeff Jeff Sykes & Ass. 56 6:43.70 0:18.0 7:01.70 Lightweight







2nd 55-59 lwt 58 Stubley,Philip Unattached 60 6:55.70 0:30.0 7:25.70 Lightweight



3rd 55-59 lwt 78 Shaper,Larry Dresden Rowing Club 56 7:14.40

[jliddil]

EDIT: I'm now in the process of adding the the missing years of this millennium, using the provided in a reply (thanks!)

As I'm not particularly computer savvy, I'm still in the process of compiling this table by hand.... tedious work!

Ugh. You could extract all this into excel. Copy and paste the html or create a text file and import in excel as space delimited.

[mikvan52]

EDIT: I'm now in the process of adding the the missing years of this millennium, using the provided in a reply (thanks!)

As I'm not particularly computer savvy, I'm still in the process of compiling this table by hand.... tedious work!

Ugh. You could extract all this into excel. Copy and paste the html or create a text file and import in excel as space delimited.

But how would you analyse the ages and the fact that the times should not be handicapped?

[jliddil]

EDIT: I'm now in the process of adding the the missing years of this millennium, using the provided in a reply (thanks!)

As I'm not particularly computer savvy, I'm still in the process of compiling this table by hand.... tedious work!

Ugh. You could extract all this into excel. Copy and paste the html or create a text file and import in excel as space delimited.

But how would you analyse the ages and the fact that the times should not be handicapped?

I'd analyze it differently. The key is to get the data in a table, then manipulate it. So for example using a little tool I have to extract from the PDF of all results I created:

Place Rower Organization Age Final Points
1 Hendershott,Paul Elkhart Regatta 56 6:24.80 100.00
2 Slocum,Rob Norwalk River Rowing Club 50 6:28.90 98.77
3 Tardieau,Jean Paul Unattached 50 6:33.00 97.53 Lightweight
4 Fenner,Graham Unattached 51 6:36.00 96.30
5 Dreissigacker,Dick Motley Rowing Club 52 6:36.30 95.06
6 Cody,Michael Saugatuck Rowing Club 50 6:37.20 93.83
7 Wetmore,Robert New Haven Rowing Club 51 6:37.90 92.59
8 Jones,Daniel Squamscott Scullers 55 6:39.60 91.36
9 Meredith,George Unattached 51 6:42.20 90.12 Lightweight
10 Simitis,Dick Quinsigamond Rowing Assc. 53 6:44.50 88.89

I can dump this into excel and my data are in cells and I have a header row. I add a header to the column that has Lightweight. I then use excel to autofill all the cells the don't say lightweight with heavy weight.

Then you can begin to do value assignments. IF Place=1 THEN put Value 5 in cell X, etc. You can easily add a year column as well then you can really slice and dice the data. I can't row for sh!t but I am a scientist by training/data geek by day. What rowing club has won the most? Who has improved the most (percentage wise) over time if the participated in multiple crash-bs. In essence a way to show someone that there are data that show his one man show is not supported by a large N.

Make sense?

[Tinus]

Comparing results of different times and ages, it will always be material for a lot discussion.

Statistics are fun but I wonder what use these types of statistics have given the difficulties with the underlying principles of defining a proper ranking. (e.g. problems with ambiguity of the ranking. Do the statistics mean to indicate how often someone has competed or how well someone has competed?). It may be interesting to extend this list with some sort of application (like gapminder.org or the suggestion in the previous post) in which a much wider range of information and conditions could be extracted and presented.

[jliddil]

gapminder is cool. Looks like the code is now google's and is available as Motion Chart and Google recently released their Chart Tools. So in theory with google docs we could have a collaborative thing