Hi RP,

It’s a great idea however one that would be outside of the reach of those who do not have your Excel experience and data. If you don't mind me mentioning, there is a ready made alternative available.

Anyone who may wish to save time and effort, increase consistency and accuracy or may be just like to get some ideas of how one can put something like this together, please read on.

As a tool, this is already in existence in R2W Axis. It’s called Consensus panel! The user is able to assign an importance factor to the ranks of any/all of our predictive ratings, and also import up to 5 external ratings that they may have access to.

The method is simplified by only having to assign an importance factor to the rating. Once complete, Axis works out all the 1111 and 2222 and so on using percentage weightings based on each field size. Users can also over/under value or remove any of the ratings from the calculation.

Importantly clients can back test their combinations against the native ratings until they arrive at an optimal combination. This combination is then saved and used to automatically pre-calculate the rating for today's races when the days file is imported. The Consensus rating can also be used in systems which can be automatically run and provide the selections when a day is loaded into the Axis interface.

Finally, users can analyse all of the other filters and factors in reference to the ranks of the Consensus panel rank or rating to assist in finding profitable combinations based on this custom rating. They can also expand the consensus panel rating by also assigning values to some other pre-set form factors. This will eventually be expanded to allow any form factor to be valued for this purpose.

The tool is available in all subscriptions including Axis Historical (past data files only) which for the price tag of only $396 p.a. offers everyone the opportunity to test and build combinations with past data not only from the perspective of developing a Consensus rating, but also provides the opportunity to delve into other types of data, many of which aren’t available in other commercial software and databases.

__________________
Michal - Ratings2Win Pty Ltd
R2W Axis - Axis is Australia's leading horse racing software and database;
with sophisticated form analysis tools and accurate horse performance ratings for TAB meetings.
http://www.ratings2win.com.au/