Random Sports Schedule Creator with 2 Divisions

Hi Phily915,

I did a problem very similar to this a few months ago. Let's see if we can solve your problem with my old workbook.

My problem was this:
On Wednesday evening a bunch of guys would come to play golf in a match play event. The head guy didn't want any two guys to ever play against each other twice. There was a list of about 100 possible people who would show up but only about 50 would ever show up at a time. I wrote a workbook that did this problem for them. (they never used it because they really wanted to pick who played against whom). Anyhow (sour grapes) this workbook can be used to solve your problem.

If you make the players Teams A1 -> A7 and B1 - B7 and double click in Col A to show they are going to play this Wednesday. Then Click on the Pairings button and let the group size be 2 it will randomly select who plays against who. You will need to click on ALL A team players and a random selection of 3 B teams for the first round. Then POST the results to the results sheet where I use it to see if they have played against each other or not previously. For the second round, leave all 7 A teams and "x" 3 different B teams and make a new round. Post this round again. Do this 7 times and you will have a random drawing of all 7 A teams and 3 B teams. Now do this for all 7 B teams and a random selection of 3 A teams.

Note - there is no guarantee that your problem has a solution!! It might be impossible to give an answer down towards the last matches, but this workbook will minimize the number of duplicate pairs. Find the attached... Have fun with it...

BTW - If you choose a group size of 3 or 4 it is looking for a group of 3 or 4 people who have never played with each other before. In golf we call his threesomes or foursomes. In your case you should use the pairing size of 2.