
31st March 2011, 10:02 PM
|
Member
|
|
Join Date: Oct 2005
Posts: 245
|
|
Hi Wes, and thanks for your reply. The 80% that I obtained was from that other site on the net where you pay for ratings and or buy books etc.
And to answer your question, yep, I've spent countless hours attempting to create a speed ratings spreadsheet. Using the best times for all going at each distance at a heap of tracks (started just with sydney and provincials, then it got out of hand, well over a thousand times in there now).
Then using beaten margins, times, weight variation etc I've converted everything to kilograms and end up with a rating for each horse's last two runs.
I've fumbled about with formulas and got it as automated as I can, with a bit of copying and pasting.
I had hoped I would use this more for trifectas, hence my question as at this point I am not sure which horses in the top order I should be eliminating. Also in this spreadsheet it gives me a rating as to the horses class derived from APM, Win% and Place%. This gives me something to compare my speed ratings to.
Your probably thinking this isn't the way to go, but I've got nothing else to do with my time except playing lawn bowls, building timber furniture and leadlighting,....!
Fingers crossed anyway, shall see how it all goes,
Thanks again, Paul
|