Apple just fell on my head!
 

Since my last post I did some work on the random races sequence. It won't work!
Take this sequence of races: W W L L L W L W L L L L W
To avoid the cluster of 4 losses let's bet every second race with two bots. You'd get: W L L L L L W and W L W W L L
Now you've got a cluster of 5 losses with one bot!
The only time it might work is with a selection system with a 9 -11% chance of a win, like horses with odds around $10. Mathematically they rarely exceed 3 consecutive wins, so splitting races might work but then you might strike a race sequence like: L L L W L W L W L L L L L L and you'd still get three wins in a row.
Back to the drawing board, RP

Hi Rinconpaul, just saw your post, assume from your last post that you don't need assistance?

Thanks for your reply Stugots. Yes I've been able to source some codes from the net to speed things up. About the only one I'm still having to manually every race is when I've applied a conditional format (colour font red) to identify the winner in a range. But when I go to transpose the range the formatting doesn't come with it. So I have to manually click on the winner and format it red in every race. can you help?
Cheers RP