[GeeTwo]

The better you can bound the problem, the better you can decide which problems aren't really problems and which ones you need to address. As a first break point -- how many teams do you anticipate, and how many matches per team in your tournament? In particular, how does the number of teams in the tournament compare to the number of matches each team should play in? The pivot point is each team playing one fewer match than there are teams in the tournament. In the case that they are equal, each team should be able to play on alliance once with each team, and against each team twice. Whether the field is larger or smaller will determine which problems your process will have to deal with. If that point is in the middle of your possibilities, you may wind up making two different programs. In any case, I'm not sure that excel is the right tool for the software (though it would be great for verifying the list as generated as meeting the criteria, and for doing the tracking after the matchups are done).