Quote:
|
Originally Posted by xptdriver
Gday All, This is how I see them being in future.. BUT I need to be able to do it automatically... it takes forever doing it manually,and that is proving to be problematical (the market is set about 118% to reflect TABS takeout and state taxes)
|
xpt, iIf your are using Excel then to convert the base rating figures to 100 point figures, you need to do the following -
If the base ratings are located in Column B (assuming Column A contains the horses names) then enter the following formula in cell B25 (or some other suitable cell):
=MAX(B1:B24)
where B1 to B24 contain the base ratings, then in cells C1 to C24 enter the following formula:
=IF(B1="","",IF(B1=B$25,100,(B1/B$21)*100))
=IF(B2="","",IF(B2=B$25,100,(B2/B$21)*100)) etc, etc
Firstly the above formula will test to see if there is any base rating & if not will leave the cell blank, but if there is a base rating it will then test to see if if it is the highest (max) & if so allot a score of 100, but if not will then calcuate an adjusted rating.
Hope this helps.