![]() |
Excel Help
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 |
1 Attachment(s)
Try this mad. see if it is what you are after.
|
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.
|
All times are GMT +10. The time now is 02:49 AM. |
Powered by: vBulletin Version 3.0.3
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.