T&FN Favourite Athletes THE RESULTS No1 Haile Gebrselassie

[Daisy]

Here is a list of our favorite favourites. To qualify the athlete needed 5 or more votes. Their points were then divided by the number of votes. The maximum score is 20.

edit: corrected version

Code: Select all

points/ position  name   votes  points
votes   
17.6   44th   Marita Koch   5   88
17     45th   Tommie Smith   5   85
15.7   22nd   Valeriy Brummel    7   110
15.4   23rd   Steve Prefontaine   7   108
15.4   23rd   Frank Shorter   7   108
14.5    5th   Jackie Joyner Kersee   13   189
14.5   34th   Abebe Bikila    6   87
14.3    6th   Carl Lewis    13   186
14     25th   Jesse Owens    7   98
13.4    8th   Cathy Freeman    11   148
13.3   20th   Ana Quirot   8   107
13.2    9th   Merlene Ottey    11   146
13     15th   Steve Ovett   9   117
12.6    1st   Haile Gebrselassie    17   214
12.5   10th   Paula Radcliffe   11   138
12.4   46th   Ron Clark   5   62
12.3   35th   Kip Keino    6   74
12.1   11th   Emil Zátopek   11   134
12     13th   Maria Mutola   10   120
12     16th   Seb Coe    9   108
12     36th   Renaldo Nehemiah   6   72
11.7   12th   Daley Thompson   11   129
11.7   17th   Jim Ryun    9   106
11.7  T26th   Kelly Holmes   7   82
11.7  T26th   Paavo Nurmi   7   82
11.6   37th   Carolina Kluft   6   70
11.6   47th   Brian Olfield   5   58
11.5   28th   Bernard Lagat   7   81
11.4    7th   Evelyn Ashford    13   149
11.2    2nd   Edwin Moses    17   191
11.2   14th   Al Oerter   10   112
11.2   29th   Irena Szewinska   7   79
11.1    3rd   Michael Johnson    14   156
11.1   30th   Florence Griffiths Joyner   7   78
10.5   38th   Roman Sebrle    6   63
10.3  T39th   Sergie Bubka   6   62
10.3  T39th   Dan O'Brien   6   62
10.2   31st   Herb Elliot   7   72
10.1   18th   Peter Snell    9   91
10     48th   Valerie Adams   5   50
9.5    32nd   Gail Devers   7   67
9.4    33rd   Wilson Kipketer    7   66
9.4    49th   Lui Xiang   5   47
9.3    41st   Jonathon Edwards   6   56
9.2    50th   Henry Rono   5   46
9.1    19th   Heike Drechsler   9   82
9      42nd   Allen Johnson   6   54
8.8     4th   Usain Bolt   14   124
8.8    21st   Jessica Ennis   8   71
8.2    51st   Alberto Juanterena   5   41
7.8    52nd   Lasse Viren   5   39
7.6    53rd   Mo Farah   5   38
7.5    43rd   Mary Slaney   6   45
6.4    54th   Greta Waitz   5   32

[mump boy]

Here is a list of our favorite favourites. To qualify the athlete needed 5 or more votes. Their points were then divided by the number of votes. The maximum score is 20.

Code: Select all

points/ position  name   votes  points
votes   
17.6   44th   Marita Koch   5   88
17     45th   Tommie Smith   5   85
15.7   22nd   Valeriy Brummel    7   110
15.4   23rd   Steve Prefontaine   7   108
15.4   23rd   Frank Shorter   7   108
14.5   5th    Jackie Joyner Kersee   13   189
14.3   6th    Carl Lewis    13   186
14     25th   Jesse Owens    7   98
14.5   34th   Abebe Bikila    6   87
13.4   8th    Cathy Freeman    11   148
13.2   9th    Merlene Ottey    11   146
13     15th   Steve Ovett   9   117
13.3   20th   Ana Quirot   8   107
12.5   10th   Paula Radcliffe   11   138
12.1   11th   Emil Zátopek   11   134
12     13th   Maria Mutola   10   120
12     16th   Seb Coe    9   108
12.3   35th   Kip Keino    6   74
12     36th   Renaldo Nehemiah   6   72
12.4   46th   Ron Clark   5   62
11.2   2nd    Edwin Moses    17   191
11.4   7th    Evelyn Ashford    13   149
11.7   12th   Daley Thompson   11   129
11.2   14th   Al Oerter   10   112
11.7   17th   Jim Ryun    9   106
11.7   T26th  Kelly Holmes   7   82
11.7   T26th  Paavo Nurmi   7   82
11.5   28th   Bernard Lagat   7   81
11.2   29th   Irena Szewinska   7   79
11.1   30th   Florence Griffiths Joyner   7   78
11.6   37th   Carolina Kluft   6   70
11.6   47th   Brian Olfield   5   58
10.1   18th   Peter Snell    9   91
10.2   31st   Herb Elliot   7   72
10.5   38th   Roman Sebrle    6   63
10.3   T39th  Sergie Bubka   6   62
10.3   T39th  Dan O'Brien   6   62
10     48th   Valerie Adams   5   50
9.1    19th   Heike Drechsler   9   82
9.5    32nd   Gail Devers   7   67
9.4    33rd   Wilson Kipketer    7   66
9.3    41st   Jonathon Edwards   6   56
9      42nd   Allen Johnson   6   54
9.4    49th   Lui Xiang   5   47
9.2    50th   Henry Rono   5   46
8.8    4th    Usain Bolt   14   124
8.8    21st   Jessica Ennis   8   71
8.2    51st   Alberto Juanterena   5   41
7.5    43rd   Mary Slaney   6   45
7.8    52nd   Lasse Viren   5   39
7.6    53rd   Mo Farah   5   38
6.4    54th   Greta Waitz   5   32
4      3rd    Michael Johnson    14   156

you're so in charge of counting next year

but Michael Johnson must be wrong, he's 11.1

Haile is 13.2

[mump boy]

mump - what happened to Glenn Hardin? You originally listed him as "Glen Stathardin" and then said he'd appear later with the right name and the right points but he never turned up...

Not sure where he went i'll check tomorrow

[mump boy]

I'll also work out lists by points instead of votes, of male/female, country, event etc, unless someone want to do it for me (please someone do it for me) also an average vote for people with more than 5 votes.

I can list them by event (or at least event group) but I don't promise to do anything else

Team effort, i like the sound of that

[Daisy]

you're so in charge of counting next year

Except my table was completely screwed up

[mump boy]

you're so in charge of counting next year

Except my table was completely screwed up

exactly, we don't want to change things too much next time, where's the fun in that

[EastBayprepoftheweek67]

Ode to Rafer Johnson:

How sad - not a single vote for Rafer Johnson.
But, wait, I voted for Rafer Johnson.
How sad - a single vote for Rafer Johnson not counted.
But, wait, even Santa checks twice.
The crowds cry out,
Give Rafer his due, a tie for 190th place.
He earned no less.

[dukehjsteve]

And I'm still embarrassed that I was the only voter egotistical enough to vote for him or herself, albeit in 20th place.

[Fortius19]

And I'm still embarrassed that I was the only voter egotistical enough to vote for him or herself, albeit in 20th place.

Don't be! It's good to like yourself!

Plus, 6' 5" back in '65 was a great jump!

[Daisy]

And I'm still embarrassed that I was the only voter egotistical enough to vote for him or herself, albeit in 20th place.

Don't be! It's good to like yourself!

Seriously, it's great you did it! What i want to know is why didn't mojo vote for her DH?

[Marlow]

So my Top 5 finished

1. 69th
2. 57th
3. 5th
4. 36th
5. 96th

so, y'know, I got that goin' for me . . .

[Pego]

Here is my top 5.

1. 11
2. 7
3. 185
4. 28
5. 202

The highest placement I got was with my #9 who placed 5th. My #3 was Shura Chudina, #5 Dana Zátopková.

Reason for not voting for some regulars on this board was that I somehow assumed you should have followed the athlete's career, in retrospect an invalid consideration.

[DrJay]

Alright, who were some of the greats that got no votes?

[Daisy]

Alright, who were some of the greats that got no votes?

Wes Santee
Rafer Johnson
Wyomia Tyus
Gerd Kanter
Maurice Greene
Johnny Gray
David Rudisha
Greg Foster
Harald Schmidt
Craig Virgin
Lynn Jennings
Raylene Boyle
Tiina Lillak
David Hemery
Eric Liddell
Filbert Bayi
Valeri Borzov
Viktor Saneyev

[Grasshopper]

Alright, who were some of the greats that got no votes?

I didn't participate (came into this late) but I was surprised to see that Kevin Young isn't on the list. I haven't looked very closely yet, but how many other world record holders didn't make the list?

[Daisy]

how many other world record holders didn't make the list?

Randy Barnes
Qu Yunxia
Gulnara Samitova-Galkina
Yuliya Pechonkina
Stefka Kostadinova
Galina Chistyakova
Inessa Kravets
Natalya Lisovskaya
Gabriele Reinsch
Betty Heidler

[El Toro]

It's been informative, educational and extremely stressful.

There will be another one of these next year with a little more organisation

No need to stress - collecting and counting this sort of data is pretty easy and no need for special software or skills.

Get people to submit structured data in something like a delimited text file, which anybody on any computer can easily produce. Then paste the data into a spreadsheet and convert text to columns. You now have data that a simple pivot table can use to count unique names (=votes) and sum the inividual rankings(=points) and sort in order.

Ten minutes, go to whoa! You might have to do some initial checking on misspellings, name changes, reversal of Asian names etc but all quite simple.

This is the lowest effort and lowest requirement for technical skills for both sender and receiver - anybody with spreadsheet skills can show you how.

You can then spend more time planning the teasing releases rather than trying to get the count right.

[nevetsllim]

Really pleased Mutola finished inside the top-15. I knew she's very respected but I didn't expect her to reach double figures in votes.

And a big thanks for organising the thread, Mump! It's been a great history lesson and I'll look forward to the next one.

[mump boy]

It's been informative, educational and extremely stressful.

There will be another one of these next year with a little more organisation

No need to stress - collecting and counting this sort of data is pretty easy and no need for special software or skills.

Get people to submit structured data in something like a delimited text file, which anybody on any computer can easily produce. Then paste the data into a spreadsheet and convert text to columns. You now have data that a simple pivot table can use to count unique names (=votes) and sum the inividual rankings(=points) and sort in order.

Ten minutes, go to whoa! You might have to do some initial checking on misspellings, name changes, reversal of Asian names etc but all quite simple.

This is the lowest effort and lowest requirement for technical skills for both sender and receiver - anybody with spreadsheet skills can show you how.

You can then spend more time planning the teasing releases rather than trying to get the count right.

you lost me at 'delimited text file'

[DecFan]

Alright, who were some of the greats that got no votes?

Tiina Lillak

Lillak had 1 vote, 13 points, but her name is misspelled: Tina Lilaak

[LopenUupunut]

OK, all athletes listed by event group (some of them are listed multiple times!) I apologise if I misclassified somebody, I'm not that familiar with all the athletes mentioned...

I also took the opportunity to meddle with the spellings - any remaining tyops are solely my fault and not to be blamed on mump, Daisy, Pego or any other compiler

Sprints - Athletes: 106 - Votes: 277 - Points: 3060 - Vpa: 2.61 - Ppa: 28.87 - Ppv: 11.05

3rd - Michael Johnson - 14/156
4th - Usain Bolt - 14/124
6th - Carl Lewis - 13/186
7th - Evelyn Ashford - 13/149
8th - Cathy Freeman - 11/148
9th - Merlene Ottey - 11/146
19th - Heike Drechsler - 9/82
25th - Jesse Owens - 7/98
29th - Irena Szewińska - 7/79
30th - Florence Griffith-Joyner - 7/78
32nd - Gail Devers - 7/67
44th - Marita Koch - 5/88
45th - Tommie Smith - 5/85
51st - Alberto Juantorena - 5/41
55th - Bobby Morrow - 4/67
56th - Marlies Göhr - 4/60
57th - Bob Hayes - 4/58
58th - Fanny Blankers-Koen - 4/56
66th - Allyson Felix - 4/44
68th - Irina Privalova - 4/40
=69th - Marie-José Pérec - 4/39
73rd - Wilma Rudolph - 4/16
74th - Glenn Davis - 3/55
76th - Frankie Fredericks - 3/47
=77th - Gwen Torrence - 3/44
80th - Kathy Cook - 3/40
86th - Jeremy Wariner - 3/35
=91st - Tyson Gay - 3/30
=98th - Calvin Smith - 3/25
105th - Linford Christie - 3/10
109th - Sonia Lannaman - 2/40
111th - Dave Sime - 2/31
=114th - Veronica Campbell-Brown - 2/28
=117th - Bert Cameron - 2/27
=117th - P. T. Usha - 2/27
=124th - Charlie Greene - 2/23
=128th - Harrison Dillard - 2/21
=128th - Jarmila Kratochvílová - 2/21
=128th - Larry James - 2/21
=133rd - Ato Boldon - 2/20
=144th - Christine Arron - 2/17
=152nd - Kim Collins - 2/13
154th - Jearl Miles - 2/12
=155th - Christophe Lemaitre - 2/11
=155th - Shelly-Ann Fraser-Pryce - 2/11
158th - Ulis Williams - 2/10
163rd - Livio Berruti - 2/4
=164th - Shirley Strickland - 1/20
=169th - Grit Breuer - 1/19
=169th - Mal Whitfield - 1/19
=176th - Lillian Board - 1/18
=176th - Olga Kotlyarova - 1/18
=176th - Steve Williams - 1/18
=190th - Christine Ohuruogu - 1/16
=190th - Falilat Ogunkoya - 1/16
=190th - Ollie Matson - 1/16
=190th - Sanya Richards-Ross - 1/16
=209th - Jeff Williams - 1/14
=209th - Lee Evans - 1/14
=209th - Maksim Dyldin - 1/14
=218th - Harry Jerome - 1/13
=223rd - Chandra Sturrup - 1/12
=223rd - Butch Reynolds - 1/12
=223rd - Henry Carr - 1/12
=223rd - Otis Davis - 1/12
=236th - Alvin Kraenzlein - 1/11
=251st - Mike Marsh - 1/10
=259th - Inger Miller - 1/9
=259th - Paul Drayton - 1/9
=259th - Katrin Krabbe - 1/9
=272nd - Adolph Plummer - 1/8
=272nd - Ann Packer - 1/8
=272nd - Asafa Powell - 1/8
=272nd - Betty Cuthbert - 1/8
=272nd - Eva Glesková - 1/8
=272nd - Dwain Chambers - 1/8
=272nd - Ionela Târlea - 1/8
=272nd - George Rhoden - 1/8
=272nd - Kriss Akabusi - 1/8
=272nd - Lon Myers - 1/8
=272nd - Natasha Kaiser-Brown - 1/8
=295th - Donovan Bailey - 1/7
=295th - Herb McKenley - 1/7
=295th - John Smith - 1/7
=295th - Justin Gatlin - 1/7
=295th - Heide Rosendahl - 1/7
=295th - Percy Williams - 1/7
=295th - Kevin Little - 1/7
=312th - Arthur Wint - 1/6
=312th - John Carlos - 1/6
=312th - Shawn Crawford - 1/6
=312th - Sunder Nix - 1/6
=332nd - Phil Brown - 1/5
=332nd - Lorraine Fenton - 1/5
=332nd - Jutta Heine - 1/5
=347th - Lauryn Williams - 1/4
=365th - Leamon King - 1/3
=365th - Armin Hary - 1/3
=365th - Francis Obikwelu - 1/3
=365th - Quincy Watts - 1/3
=365th - Walter Dix - 1/3
=379th - Bärbel Wöckel - 1/2
=379th - Chi Cheng - 1/2
=379th - Mark Richardson - 1/2
=393rd - Norwood Ewell - 1/1
=393rd - Larry Myricks - 1/1

Middle-distance - Athletes: 70 - Votes: 181 - Points: 1904 - Vpa: 2.59 - Ppa: 27.20 - Ppv: 10.52

13th - Maria Mutola - 10/120
15th - Steve Ovett - 9/117
16th - Seb Coe - 9/108
17th - Jim Ryun - 9/106
18th - Peter Snell - 9/91
20th - Ana Quirot - 8/107
=26th - Kelly Holmes - 7/82
=26th - Paavo Nurmi - 7/82
28th - Bernard Lagat - 7/81
31st - Herb Elliott - 7/72
33rd - Wilson Kipketer - 7/66
43rd - Mary Slaney - 6/45
51st - Alberto Juantorena - 5/41
60th - Don Quarrie - 4/51
67th - Saïd Aouita - 4/43
90th - Doina Melinte - 3/31
=96th - Hicham El Guerrouj - 3/26
112th - Svetlana Masterkova - 2/30
113th - Steve Scott - 2/29
=114th - Jim Beatty - 2/28
=124th - Joaquim Cruz - 2/23
=124th - John Walker - 2/23
=128th - Jarmila Kratochvílová - 2/21
=133rd - Marty Liquori - 2/20
=136th - Eamonn Coghlan - 2/19
=136th - Steve Cram - 2/19
=144th - Roger Bannister - 2/17
=147th - Caster Semenya - 2/16
154th - Jearl Miles - 2/12
=159th - Tatyana Samolenko - 2/9
162nd - Sonia O'Sullivan - 2/6
=164th - Gabriela Szabó - 1/20
=169th - Carla Sacramento - 1/19
=169th - Mal Whitfield - 1/19
=176th - Lillian Board - 1/18
=176th - Olga Kotlyarova - 1/18
=176th - Tina Paulino - 1/18
=185th - Letitia Vriesde - 1/17
=190th - Mehdi Baala - 1/16
=202nd - Audun Boysen - 1/15
=202nd - Wim Slijkhuis - 1/15
=209th - Jozef Plachý - 1/14
=223rd - Suzy Favor-Hamilton - 1/12
=223rd - Walter George - 1/12
=236th - Ellen van Langen - 1/11
=236th - Hasna Benhassi - 1/11
=251st - Carrie Tollefson - 1/10
=259th - Andrew Wheating - 1/9
=272nd - Ann Packer - 1/8
=272nd - Dave WOttle - 1/8
=272nd - Jenny Barringer - 1/8
=272nd - Lon Myers - 1/8
=272nd - Rick Wohlhuter - 1/8
=272nd - Quenton Cassidy - 1/8
=312th - Arthur Wint - 1/6
=312th - John Landy - 1/6
=312th - Jordan Hasay - 1/6
=312th - Rui Silva - 1/6
=332nd - Mike Boit - 1/5
=347th - Agnes Samaria - 1/4
=347th - Paul Ereng - 1/4
=347th - Tom Courtney - 1/4
=347th - Sydney Maree - 1/4
=347th - Browning Ross - 1/4
=365th - Lopez Lomong - 1/3
=365th - Marcus O'Sullivan - 1/3
=379th - Dennis Carr - 1/2
=379th - Thomas Wessinghage - 1/2
=393rd - Charles Kilpatrick - 1/1
=393rd - Fermin Cacho - 1/1

Distance - Athletes: 76 - Votes: 182 - Points: 1998 - Vpa: 2.39 - Ppa: 26.29 - Ppv: 10.98

1st - Haile Gebrselassie - 17/214
10th - Paula Radcliffe - 11/138
11th - Emil Zátopek - 11/134
=23rd - Frank Shorter - 7/108
=23rd - Steve Prefontaine -7/108
=26th - Paavo Nurmi - 7/82
28th - Bernard Lagat - 7/81
34th - Abebe Bikila - 6/87
35th - Kip Keino - 6/74
43rd - Mary Slaney - 6/45
46th - Ron Clark - 5/62
50th - Henry Rono - 5/46
52nd - Lasse Virén - 5/39
53rd - Mo Farah - 5/38
54th - Grete Waitz - 5/32
59th - Joan Benoit - 4/54
75th - Tirunesh Dibaba - 3/48
=84th - Paul Tergat - 3/36
=94th - Gerry Lindgren - 3/28
=96th - Hicham El Guerrouj - 3/26
=133rd - Marty Liquori - 2/20
=136th - Eamonn Coghlan - 2/19
=136th - Kenenisa Bekele - 2/19
=136th - Billy Mills - 2/19
=144th - Derartu Tulu - 2/17
=159th - Tatyana Samolenko - 2/9
162nd - Sonia O'Sullivan - 2/6
=164th - Gabriela Szabó - 1/20
=164th - Brian Diemer - 1/20
=169th - Carla Sacramento - 1/19
=169th - Dieter Baumann - 1/19
=176th - Kim Smith - 1/18
=176th - Pekka Päivärinta - 1/18
=190th - Nick Rose - 1/16
=190th - Moses Kiptanui - 1/16
=190th - Wang Junxia - 1/16
=202nd - Eliud Kipchoge - 1/15
=202nd - Wim Slijkhuis - 1/15
=202nd - Vladimir Kuts - 1/15
=218th - Saif Saaeed Shaheen - 1/13
=223rd - Fernanda Ribeiro - 1/12
=223rd - Walter George - 1/12
=236th - Chris Brasher - 1/11
=236th - Daniel Komen - 1/11
=236th - Gordon Pirie - 1/11
=251st - Carrie Tollefson - 1/10
=251st - Miruts Yifter - 1/10
=259th - Jen Rhines - 1/9
=272nd - Bob Schul - 1/8
=272nd - Jenny Barringer - 1/8
=272nd - Quenton Cassidy - 1/8
=295th - Alain Mimoun - 1/7
=295th - Lidia Simon - 1/7
=312th - Rui Silva - 1/6
=332nd - Bob Kennedy - 1/5
=332nd - Jerome Drayton - 1/5
=332nd - Sohn Kee-chung - 1/5
=347th - Alberto Salazar - 1/4
=347th - Sydney Maree - 1/4
=347th - Murray Halberg - 1/4
=347th - Chris Solinsky - 1/4
=347th - Browning Ross - 1/4
=365th - Skip Shaeffer - 1/3
=365th - Mark Plaatjes - 1/3
=365th - Ted Corbitt - 1/3
=379th - Bob Deines - 1/2
=379th - Jessica Augusto - 1/2
=379th - Kayoko Fukushi - 1/2
=379th - Thomas Wessinghage - 1/2
=393rd - Anthony Famiglietti - 1/1
=393rd - Craig Mottram - 1/1
=393rd - Ingrid Kristiansen - 1/1
=393rd - Meseret Defar - 1/1
=393rd - Reiko Tosa - 1/1
=393rd - Sammy Wanjiru - 1/1
=393rd - Shigeru So - 1/1

Hurdles - Athletes: 45 - Votes: 101 - Points: 982 - Vpa: 2.24 - Ppa: 21.82 - Ppv: 9.72

2nd - Edwin Moses - 17/191
32nd - Gail Devers - 7/67
36th - Renaldo Nehemiah - 6/72
42nd - Allen Johnson - 6/54
49th - Liu Xiang - 5/47
58th - Fanny Blankers-Koen - 4/56
68th - Irina Privalova - 4/40
74th - Glenn Davis - 3/55
=98th - Susanna Kallur - 3/25
106th - Sally Pearson - 3/5
122nd - Stanislavs Olijars - 2/24
127th - Stéphane Diagana - 2/22
=128th - Harrison Dillard - 2/21
=128th - Lee Calhoun - 2/21
=136th - Felix Sánchez - 2/19
=149th - Babe Didrikson - 2/14
=149th - Colin Jackson - 2/14
=159th - Sandra Farmer-Patrick - 2/9
=164th - Jim Bolding - 1/20
=164th - Shirley Strickland - 1/20
=164th - Yordanka Donkova - 1/20
=185th - Richard Attlesey - 1/17
=185th - Roger Kingdom - 1/17
=209th - Dawn Harper - 1/14
=223rd - Lolo Jones - 1/12
=236th - Alvin Kraenzlein - 1/11
=236th - Dayron Robles - 1/11
=259th - Alan Pascoe - 1/9
=272nd - Kriss Akabusi - 1/8
=272nd - Tony Jarrett - 1/8
=312th - Eddie Southern - 1/6
=312th - Hayes Jones - 1/6
=312th - Llewellyn Herbert - 1/6
=332nd - Milt Campbell - 1/5
=332nd - Willie Davenport - 1/5
=347th - Natalya Antyukh - 1/4
=347th - Rod Milburn - 1/4
=347th - Sally Gunnell - 1/4
=347th - Brigitte Foster-Hylton - 1/4
=347th - Kim Batten - 1/4
=347th - Deon Hemmings - 1/4
=365th - Perdita Felicien - 1/3
=379th - Chi Cheng - 1/2
=393rd - Kemel Thompson - 1/1
=393rd - LJ van Zyl - 1/1

Horizontal jumps - Athletes: 42 - Votes: 110 - Points: 1211 - Vpa: 2.62 - Ppa: 28.83 - Ppv: 11.01

5th - Jackie Joyner-Kersee - 13/189
6th - Carl Lewis - 13/186
19th - Heike Drechsler - 9/82
25th - Jesse Owens - 7/98
29th - Irena Szewińska - 7/79
41st - Jonathan Edwards - 6/56
58th - Fanny Blankers-Koen - 4/56
71st - Ralph Boston - 4/38
=82nd - Tatyana Lebedeva - 3/37
=82nd - Fiona May - 3/37
=87th - Mike Powell - 3/33
=91st - Ivan Pedroso - 3/30
101st - Willie Banks - 3/18
110th - Igor Ter-Ovanesyan - 2/32
=117th - Viktor Saneyev - 2/27
=122nd - Mary Rand - 2/24
=176th - Alexandra Chudina - 1/18
=202nd - Funmi Jimoh - 1/15
=209th - Brianna Glenn - 1/14
=218th - Russell Adams - 1/13
=223rd - Françoise Mbango Etone - 1/12
=236th - Alvin Kraenzlein - 1/11
=236th - Sheila Hudson - 1/11
=236th - Yargelis Savigne - 1/11
=259th - Mike Conley - 1/9
=259th - Irving Saladino - 1/9
=272nd - Iva Prandzheva - 1/8
=272nd - Bob Beamon - 1/8
=295th - Heide Rosendahl - 1/7
=295th - Dwight Phillips - 1/7
=312th - Anisoara Stanciu - 1/6
=312th - Lynn Davies - 1/6
=312th - Phillips Idowu - 1/6
=312th - Niki Xanthou - 1/6
=365th - Christian Taylor - 1/3
=379th - Brittney Reese - 1/2
=379th - Tatyana Kotova - 1/2
=393rd - Adhemar Ferreira da Silva - 1/1
=393rd - Ashia Hansen - 1/1
=393rd - Joe Greene - 1/1
=393rd - Larry Myricks - 1/1
=393rd - Monica Cabbler - 1/1

Vertical jumps - Athletes: 49 - Votes: 84 - Points: 834 - Vpa: 1.71 - Ppa: 17.02 - Ppv: 9.93

22nd - Valeriy Brumel - 7/110
=39th - Sergei Bubka - 6/62
58th - Fanny Blankers-Koen - 4/56
=64th - Charles Austin - 4/46
=69th - Stacy Dragila - 4/39
=84th - Stefan Holm - 3/36
=87th - Blanka Vlašić - 3/33
=93rd - Romain Mesnil - 3/29
=96th - Bob Seagren - 3/26
100th - Yelena Isinbayeva - 3/21
143rd - Jean Galfione - 2/18
=149th - Babe Didrikson - 2/14
=149th - Bob Richards - 2/14
=152nd - Dwight Stones - 2/13
161th - Heike Henkel - 2/8
=169th - Rodion Gataullin - 1/19
=176th - Alexandra Chudina - 1/18
=176th - Igor Potapovich - 1/18
=185th - Pat Matzdorf - 1/17
=190th - Thierry Vigneron - 1/16
=190th - Vladimir Yashchenko - 1/16
=209th - Ernie Shelton - 1/14
=209th - Gerry Moro - 1/14
=218th - Jim Brewer - 1/13
=223rd - Fabiana Murer - 1/12
=223rd - Joe Faust - 1/12
=236th - Doug Olmstead - 1/11
=236th - Steve Hooker - 1/11
=251st - Don Bragg - 1/10
=251st - Joe Dial - 1/10
=259th - Patrik Sjöberg - 1/9
=259th - Kylie Hutson - 1/9
=272nd - Chaunté Howard - 1/8
=272nd - Inga Babakova - 1/8
=272nd - Jenn Suhr - 1/8
=295th - Carlo Thränhardt - 1/7
=295th - Renaud Lavillenie - 1/7
=312th - Jan Johnson - 1/6
=312th - Lázaro Borges - 1/6
=312th - Rosie Ackermann - 1/6
=312th - Władysław Kozakiewicz - 1/6
=332nd - Mondo Duplantis - 1/5
=347th - Emma George - 1/4
=379th - Marian Kolasa - 1/2
=379th - Javier Sotomayor - 1/2
=379th - Paul Wilson - 1/2
=393rd - Dick Fosbury - 1/1
=393rd - John Pennel - 1/1
=393rd - Steve Barnes - 1/1

Standing jumps - Athletes: 1 - Votes: 1 - Points: 1

=393rd - Ray Ewry - 1/1

Throws - Athletes: 54 - Votes: 96 - Points: 920 - Vpa: 1.78 - Ppa: 17.04 - Ppv: 9.58

14th - Al Oerter - 10/112
47th - Brian Oldfield - 5/58
48th - Valerie Adams - 5/50
61st - Virgilijus Alekna - 4/50
72nd - Jan Železný - 4/33
=77th - Andreas Thorkildsen - 3/44
79th - Parry O'Brien - 3/42
=87th - Tessa Sanderson - 3/33
=94th - Mac Wilkins - 3/28
103rd - Jacko Gill - 3/14
104th - Koji Murofushi - 3/12
=114th - Seppo Räty - 2/28
=120th - Adam Nelson - 2/25
=128th - Lance Deal - 2/21
=136th - Al Feuerbach - 2/19
=147th - Uwe Hohn - 2/16
=149th - Babe Didrikson - 2/14
=155th - Connie Price-Smith - 2/11
=169th - Anatoly Bondarchuk - 1/19
=169th - Christina Obergföll - 1/19
=176th - Alexandra Chudina - 1/18
=176th - John Godina - 1/18
=190th - Dana Zátopková - 1/16
=190th - Wolfgang Schmidt - 1/16
=202nd - Jonni Myyrä - 1/15
=209th - Helena Fibingerová - 1/14
=218th - Tiina Lillak - 1/13
=223rd - Dylan Armstrong - 1/12
=236th - Janis Lusis - 1/11
=236th - Kate Schmidt - 1/11
=236th - Randy Matson - 1/11
=251st - Johnny Kuck - 1/10
=251st - Olga Fikotová-Connolly - 1/10
=259th - Astrid Kumbernuss - 1/9
=259th - Harold Connolly - 1/9
=272nd - Jürgen Schult - 1/8
=295th - Ilona Slupianek - 1/7
=295th - Jesse Stuart - 1/7
=295th - Werner Günthör - 1/7
=295th - Robert Harting - 1/7
=312th - Yuriy Sedykh - 1/6
=332nd - Jiří Skobla - 1/5
=332nd - Rutger Smith - 1/5
=332nd - Yarelis Barrios - 1/5
=332nd - Peter Blank - 1/5
=347th - Al Cantello - 1/4
=365th - Sergey Litvinov - 1/3
=365th - Mike Carter - 1/3
=379th - Tom Pukstys - 1/2
=393rd - Dallas Long - 1/1
=393rd - George Woods - 1/1
=393rd - Luis Delis - 1/1
=393rd - Trine Hattestad - 1/1
=393rd - Ricky Bruch - 1/1

Multis - Athletes: 25 - Votes: 86 - Points: 970 - Vpa: 3.44 - Ppa: 38.80 - Ppv: 11.28

5th - Jackie Joyner-Kersee - 13/189
12th - Daley Thompson - 11/129
21st - Jessica Ennis - 8/71
37th - Carolina Klüft - 6/70
38th - Roman Šebrle - 6/63
=39th - Dan O'Brien - 6/62
=62nd - Jim Thorpe - 4/47
=62nd - Mary Peters - 4/47
=64th - Dean Macey - 4/46
81st - Denise Lewis - 3/38
102nd - Bob Mathias - 3/16
=120th - Bryan Clay - 2/25
=122nd - Mary Rand - 2/24
=133rd - Ashton Eaton - 2/20
=136th - Erki Nool - 2/19
=176th - Alexandra Chudina - 1/18
=185th - Kelly Sotherton - 1/17
=202nd - Bruce Jenner - 1/15
=223rd - Drew Fucci - 1/12
=236th - Jürgen Hingsen - 1/11
=251st - Romain Barras - 1/10
=295th - Heide Rosendahl - 1/7
=332nd - Milt Campbell - 1/5
=332nd - Kip Janvrin - 1/5
=347th - Anke Behmer - 1/4

Walks - Athletes: 3 - Votes: 3 - Points: 22 - Vpa: 1.00 - Ppa: 7.33 - Ppv: 7.33

=259th - Robert Korzeniowski - 1/9
=295th - Olga Kaniskina - 1/7
=312th - Andrey Perlov - 1/6

Total athletes: 416
Total votes: 969**
Total points: 10192
Votes per athlete: 2.33
Points per athlete: 24.50

**I can think of several possible reasons why the total # of votes isn't be divisible by 20:

a) maybe not everybody submitted a full list
b) missing athletes like Glenn Hardin and Rafer Johnson
c) perhaps mump forgot to remove some votes from the deleted lists
d) or even some kind of screw-up on my part

[El Toro]

you lost me at 'delimited text file'

OK, so you haven't done much data collection/manipulation, so here's a simple guide to a delimited file and what you can do with it:

1) think of a delimiter as a separator between bits of text that can be used by spreadsheet software as an instruction to: "MAKE A NEW COLUMN HERE!" every time it comes across it.

2) So, a comma delimited text file (notice how it doesn't line up neatly) with the following content.....

Rank,FirstName,LastName,Country
1,mump boy,TFN News,ENG
2,El Toro,TFN News,AUS
3,Flumpy,BBC.co.uk,ENG

3) Can have the commas converted into columns by Excel(or other spreadsheet):

Code: Select all

ColumnA|ColumnB    |ColumnC   |ColumnD |
Rank   |FirstName  |LastName  |Country |
1      |mump boy   |TFN News  |ENG     |
2      |El Toro    |TFN News  |AUS     |
3      |Flumpy     |BBC.co.uk |ENG     |


4) Once you have the data in columns, you can do the ranking very easily (another tutorial ).

This is a simple copy and paste and a few new things to learn. I have taught far more complex work to rank beginners, so this should be easily achievable for you with 20 minutes of effort.

[gh]

far more elemental to making a DB work than any tab delimiting is to first be sure you have all the names spelled right (or equally wrong). (no offense mump)

[mump boy]

Rafer Johnson (2 votes 18 points)
http://en.wikipedia.org/wiki/Rafer_Johnson

Glen 'Slats' Hardin (1 vote 5 points)
http://en.wikipedia.org/wiki/Glenn_Hardin

[Daisy]

far more elemental to making a DB work than any tab delimiting is to first be sure you have all the names spelled right (or equally wrong). (no offense mump)

Imagine how he pronounces them!

[pakillo]

At the end of the year maybe we could vote for our favourite athletes of 2012.

[DecFan]

At the end of the year maybe we could vote for our favourite athletes of 2012.

Or possibly of this most recent Olympiad from 2009-2012 . . .

[slowjo]

Where is the fanfare for our number one fav athlete?

A worthy choice. Geb is truly a great representive of our great sport! Well done all.

(mojo)

[El Toro]

far more elemental to making a DB work than any tab delimiting is to first be sure you have all the names spelled right (or equally wrong). (no offense mump)

Yes, equivalency is critical which is why avoiding data reentry when consolidating is important.

The participants are best placed to spell correctly, especially for lesser known athletes, so flowing their typed entries straight into the consolidation as described in my earlier post give the best chance for success.

Of course, there still needs be double checking for stuff like Kirzenstein vs Szewinska but you can minimise this with naming conventions.

mump, here's a link to an Excel tutorial with screen images, which shows you how easy it is

Text to Columns tutorial

[Pego]

Thank you, El Toro. Mump is not the only one that could hone his Excel skills. I will certainly go over it.

[mump boy]

Thank you, El Toro. Mump is not the only one that could hone his Excel skills. I will certainly go over it.

My Excell skills need more than 'honing' they are non existant

[mump boy]

I forgot to vote for Faluja Singh

http://www.asianage.com/other-sports/lo ... runner-594

[bushop]

What's the countdown clock at to T&FN Favourite Athletes II ?

[aaronk]

I've already started making my list....and will PM you with it when done.....but not to worry.....I'm American, but 3 of the first names I thought of are "foreigners"!!!

And while I'm a HUGE fan of female T&F, my first few names have been all male!!
But that will change!!

Also, unlike some of you "elites" ( ), I've met some big names in the sport....but don't have any as friends, close or not, so that won't prejudice my thinking!!

(For "gh", that will probably be a HUGE problem!!!)

Anyway, you'll receive my PM shortly!!

[aaronk]

What the hell is this??

I looked at this thread's title...and just assumed (never assume!!!!!) it was a BRAND NEW thread!!!
Then...AFTER I PM'ed you my list....I saw this started in 2011...and that there were 39 pages of comments!!!

So what's the deal??
Is this just a continuation of the 2011 poll?
A new one for 2012?/

And what's the deal with taking names OFF the list...just because they've gotten only one vote??
Do new entries have to first check to see if it's okay to vote for somebody before putting their name on their list??

To hell with that!!
I gave you my list a few minutes ago...and it includes MARY CAIN....who is probably on NO ONE ELSE'S list!!!!!

If ALL of my names aren't included on the final list......of ALL the names....then please remove my entry from your game!!!

And make the rules easier to follow!!
And please make sure EVERYONE KNOWS this is NOT a brand new thread....but something started about a year ago!!!!