Home teams clash

[angus1964]

Years ago I had a formula for our darts league which ensured when two teams shared a board, they were both not drawn at home.
I used to write out the numbers like this.
1 2 3 4 5
6 7 8 9 10
Then rotate round to form the schedule. 
But now I cant remember how I did it, and all attempts are no where near.

Any pointers would be greatly appreciated.

[Ian Wakeling]

My Excel spreadsheet can help you do this.  Note that it does not work on an apple mac.  There are some more details in this thread, but basically if you view the single or double round robin in home/away format and "do not randomize" then you should find it relatively easy to pair up the teams who share a venue, by looking for the sequences of back-ground color that are out of step with each other.