Greg, maybe I'm defeating the purpose with the method in my last post. This is an intriguing topic. I'm not an Excel guru, and it would probably take me all day to write one that actually works, but I think I could do an IF..THEN..ELSE statement that would revert to a % of horses beaten if it were mathematically impossible for a horse to have a specific number of horses beaten in his last 3. Of course, in that case you'd still have to set an arbitrary % to trigger a harder look.
|