I'm wondering if someone could me speed my rating of past races with the use of a speadsheet.

The formula is:

CR=Class Rating of the race
BM=Beatem Margin
WT=Weight Carried
LW=Limit Weight

CR-BM*1.5+WT-LW

An example follows 65-(3.5*1.5)+56.5-53=63.25 rounded to 63.5

Mad Gambler

I can help you out but I am not exaclty sure what you want done ?

Do you want someone to create an excel spreadsheet to do the calculations for you ? Or do you already have an excel sheet and just want to know how to put in the forumlaes ?

I need a spreadsheet to help with the calculations.


Mad Gambler

Try this mad. see if it is what you are after.

Attached Files

spreadsheet 1.xls (13.5 KB, 1540 views)

Thanks. It's just what I need.


Mad Gambler

Insead of the TAB number I need to be able to type in the horses name to allow me to check it's previous rating.


Mad Gambler

If the previous ratings are in another spreadsheet, then it is fairly straight forward to type in a formula that will lookup any previous ratings. This of course depends on where they are located.