Excel Help

[Mad Gambler]

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

[wesmip1]

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 ?

[Mad Gambler]

I need a spreadsheet to help with the calculations.


Mad Gambler

[DR RON]

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

[Mad Gambler]

Thanks. It's just what I need.


Mad Gambler

[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

[DR RON]

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.