T&FN Favourite Athletes THE RESULTS No1 Haile Gebrselassie

[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!!!!

[mump boy]

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!!!!

I have ABSOLUTELY no idea what you're on about

[Daisy]

What the hell is this??

Last winters entertainment

And what's the deal with taking names OFF the list...just because they've gotten only one vote??

As I recall every vote was sacred, all the one voters were counted, even those with no votes were mentioned. The final list is here: viewtopic.php?f=1&t=45258&start=1480#p749688

[mump boy]

THe only people who were removed where those that took umbrage at explaining their favourites and asked to be !!

I may do something similar this winter but it will have to be a different question, i think the last one was exhausted

[Flumpy]

I want to do LEAST favourite athlete

Would be a riot

[Daisy]

I want to do LEAST favourite athlete

Would anyone vote for themselves? Or should I just blame it on bad genes.

[Pego]

I want to do LEAST favourite athlete

Would be a riot

Thinking about it for 2 minutes, I am already up to 6. Not sure if I could come up with 20 .

[Daisy]

I wonder how many athletes could make the top ten in both lists?

[mump boy]

i wonder how long before the whole thread got pulled ?!!

[preston]

I want to do LEAST favourite athlete

Would be a riot

Thinking about it for 2 minutes, I am already up to 6. Not sure if I could come up with 20 .

20? I need only one: Paula Radcliffe.