I recently created a simple spreadsheet to better organize my handicapping process. I use a ranking system based on points similar to
this one by Derek Johnson at US Racing, but I use a few more factors, some of which are different than what he uses.
Problem is what to do when horses are tied in their points total. Derek suggests a formula for when this occurs, but I don't understand it. So far I've just been taking a closer look at how each one scored in each factor to see if one shines a little more in the factors I consider most important. But this sort of defeats one of my main objectives in using a spreadsheet, which is to save time.
Any suggestions for breaking ties would be most appreciated!