Winner In Six Archives
 

Anyone got copies of the previous Winner in six ratings ?

I seem to have lost my CD that had all the ratings.

If so please email me a copy at psmiffy79@aim.com

Thank You

Considering no one has replied or sent me an email I expect that no one keeps a copy of these ratings.

Oh well....

I just started recording these from late Feb. You can have what I've got if you want.

Ask XPT directly..... sure he'd help....

Chinbok,

Could you email me through your copy of them ?
At least that gets me back one more month of archives.

Stix,

I've had a chat with xpt, unfortunately he doesn't keep a copy of his old ratings.

Thanks

Gday All

what I can say is that I have been fiddling with the formula a bit of late.. I was trying to get away from having 3 or 4 horses rated the same, it still happens but nowhere near as often as it used to... (but it has meant that the top rater win SR has fallen abit, the top 2 SR has risen tho) I am working along with a very good friend of mine who actaully writes the macros for me, on a way to present the ratings in a more "traditional way" . Ratings like DFS and Tech from always have a 100 point rater, one of them sometimes has 2 rating at 100 (not sure which).. I can do this manually, but as I have explained to people who have contactd me offlist, it is time consuming and I do have a day job :)

I hope to be able to present the ratings with a top rater of 100 in each race soon, but I am not sure when I will be able to do it..

Take R1 Devonport today

This how they are currently presented

5/04/2006 12:12 DEVONPORT 1 1 NUVOLARI 57
5/04/2006 12:12 DEVONPORT 1 4 AT ST GEORGES 49
5/04/2006 12:12 DEVONPORT 1 2 OCEANA FINE 32
5/04/2006 12:12 DEVONPORT 1 5 PERSONAL DRUM 27
5/04/2006 12:12 DEVONPORT 1 3 THUNDER LINE 25
5/04/2006 12:12 DEVONPORT 1 6 TUMBLEWEED JACK 17


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)

5/04/2006 12:12 DEVONPORT 1 1 $1.9 NUVOLARI 100
5/04/2006 12:12 DEVONPORT 1 4 $3.3 AT ST GEORGES 86
5/04/2006 12:12 DEVONPORT 1 2 $7.8 OCEANA FINE 56
5/04/2006 12:12 DEVONPORT 1 5 $10.4 PERSONAL DRUM 47
5/04/2006 12:12 DEVONPORT 1 3 $14.4 THUNDER LINE 44
5/04/2006 12:12 DEVONPORT 1 6 $18.7 TUMBLEWEED JACK 30

(you didnt think i would use a race that i didnt have the winner on top did ya)

cheeky... very cheeky!

Good Luck...

xpt,

Regardless of whether it is rated to 100 points or not I belive most people would find your ratings top notch. I know I do.

Thanks for your effort.

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.

Thanks for that ... much appreciated