Progressive British All-Time Top Tens
These compilations are based on the simple but ingenious formula devised by the respected New Zealand statistician, the late Peter Heidenstrom. This recognised the fact that any all-time ranking list, however lengthy, inevitably favoured the most recent performers, and therefore many significant marks from earlier years were eliminated. Mr Heidenstrom's solution was to choose an appropriate starting date for his list, compile the Top Ten current at that date, and then add every new performer and improved performance which qualified for the Top Ten, while retaining all previous performances even as the 10th best performer becomes faster with the passing years. It is thus possible to construct from this progression the Top Ten at any chosen intermediary date, and also by this means the historic achievements of, for example, such British milers as Walter George, Albert Hill, Sydney Wooderson, Roger Bannister and Derek Ibbotson are retained. Furthermore, the standards reached by others much less well known and deserving of lasting recognition are recorded for posterity. How else to remember Peter Robinson, Victor Milligan, Frank Wyatt, Brian Kent-Smith?
The spreasheets given here complement the articles in Track Stats and give more information than can be fitted into the printed format. The full spreadsheets contain many calculations that would take time to run on a slow PC. Therefore a cut down-version is also provided which just re-calculates columns K to O when required.
Columns A to E are the same as in Track Stats.
All versions of the spreadhseets contain macros, so you will need to let Excel activate them - your virus checking software will pass them as OK.
These are in the members-only area - contact for access to these pages
Discus - Additional Version (333 KB) - contains checks on the metric conversions
The longest serving members of the top-10 up to 31/12/1971 can be determined precisely. Those in italics were Irish, those with an asterisk were "not out" as at 31/12/1971:
Further spreadsheets are likely to be provided in the members-only pages. The Discus is given as a taster.