Lab Notes

Top Rated Underscores, 2006-2009

Menu: <Introduction>, <Downloads>, <Screenshots>, <Examples>

Introduction

This lab report takes the form of a massive Excel 2007 document which lists at 154,000 entries, one per horse/underscore, since 2006. All prices are to Holme's pseudo BFSP.

Downloads

Item One. (Top Rated Underscore, Excel 2007)
The Top Rated Underscores document can be downloaded from here (9.5MB). Please note that Excel 2007 is required.

Item Two. (Top Rated Underscore, Excel 2007)
Bayesian has kindly offered a second spreadsheet showing the same information but this time to one race per row which may be prefereable for some. Please download this file from here. Again, this is in Excel 2007 format.

Item Three. (Top Rated Underscore, CSV)
Holmes has reworked the data and this is available as a CSV file. This means that any text editor and any spreadsheet can open it. If the number of rows are too large for your particular CSV client then chop it into two, or more, parts with a text editor and view each part seperately. This version has the same data as the first download (above) but also has the Forecast SP, Trainer Name and Trainer Form. This CSV can be downloaded from here.

Item Four. (Second Rated Underscore, CSV)
Holmes has kindly done something similar as the previous item, but for the second rated underscored horses. This CSV can be downloaded from here.

Item Five. (Second Rated Underscore, Excel 2007)
The second rated underscored horses but in Excel 2007 format and with pivot tables (the same format as item one) from here.

Screenshots

Here are a couple of screenshots which shows what sort of information one can dig out from this spreadsheet.

Irish Racing, non-handicap, value, race class less than 100.

 

GB racing, handicap, value, race class more than 100.

 

Changing the filters in one of the cross tab sheets.

Examples