Multiple Team Game Tournament Schedule (Excel Help)

[DannyDresdan]

I'm trying to run a laser tag tournament. In this tournament, multiple teams play one another in the same game. Therefore, the tradition excel sports scheduling formats that are available (i.e. – “1v1”) aren't that useful to me. In a perfect world, here's what I want to accomplish:

1) Have the teams play each other a fair amount of times to where thetop teams (“Team 1” – “Team 5”) and the middle teams (“Team 6” – “Team 10”). I know it won’t be perfect but I, at least, don’t want each team to play each other more than twice. <o></o>
2) Each team play 6 games each.<o></o>
Here is my schedule:<o></o>
[TABLE="class: MsoNormalTable, width: 4"]
<tbody>[TR]
[TD="width: 64, bgcolor: transparent"][/TD]
[TD="width: 320, bgcolor: transparent, colspan: 5"]

Tournament Schedule<o></o>​

[/TD]
[/TR]
[TR]
[TD="width: 64, bgcolor: transparent"][/TD]
[TD="width: 320, bgcolor: transparent, colspan: 5"]

Pack Sets<o></o>​

[/TD]
[/TR]
[TR]
[TD="width: 64, bgcolor: transparent"][/TD]
[TD="width: 64, bgcolor: transparent"]

Red<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

Blue<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

Green<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

Yellow<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

Purple<o></o>​

[/TD]
[/TR]
[TR]
[TD="width: 64, bgcolor: transparent"]

Round 1<o></o>​

[/TD]
[TD="width: 64"]

Team 1<o></o>​

[/TD]
[TD="width: 64"]

Team 7<o></o>​

[/TD]
[TD="width: 64"]

Team 15<o></o>​

[/TD]
[TD="width: 64"]

Team 8<o></o>​

[/TD]
[TD="width: 64"]

Team 9<o></o>​

[/TD]
[/TR]
[TR]
[TD="width: 64, bgcolor: transparent"]

Round 2<o></o>​

[/TD]
[TD="width: 64"]

Team 11<o></o>​

[/TD]
[TD="width: 64"]

Team 2<o></o>​

[/TD]
[TD="width: 64"]

Team 10<o></o>​

[/TD]
[TD="width: 64"]

Team 4<o></o>​

[/TD]
[TD="width: 64"]

Team 14<o></o>​

[/TD]
[/TR]
[TR]
[TD="width: 64, bgcolor: transparent"]

Round 3<o></o>​

[/TD]
[TD="width: 64"]

Team 3<o></o>​

[/TD]
[TD="width: 64"]

Team 5<o></o>​

[/TD]
[TD="width: 64"]

Team 6<o></o>​

[/TD]
[TD="width: 64"]

Team 13<o></o>​

[/TD]
[TD="width: 64"]

Team 12<o></o>​

[/TD]
[/TR]
[TR]
[TD="width: 64, bgcolor: transparent"]

Round 4<o></o>​

[/TD]
[TD="width: 64"]

Team 12<o></o>​

[/TD]
[TD="width: 64"]

Team 1<o></o>​

[/TD]
[TD="width: 64"]

Team 2<o></o>​

[/TD]
[TD="width: 64"]

Team 14<o></o>​

[/TD]
[TD="width: 64"]

Team 13<o></o>​

[/TD]
[/TR]
[TR]
[TD="width: 64, bgcolor: transparent"]

Round 5<o></o>​

[/TD]
[TD="width: 64"]

Team 3<o></o>​

[/TD]
[TD="width: 64"]

Team 6<o></o>​

[/TD]
[TD="width: 64"]

Team 11<o></o>​

[/TD]
[TD="width: 64"]

Team 10<o></o>​

[/TD]
[TD="width: 64"]

Team 8<o></o>​

[/TD]
[/TR]
[TR]
[TD="width: 64, bgcolor: transparent"]

Round 6<o></o>​

[/TD]
[TD="width: 64"]

Team 4<o></o>​

[/TD]
[TD="width: 64"]

Team 9<o></o>​

[/TD]
[TD="width: 64"]

Team 7<o></o>​

[/TD]
[TD="width: 64"]

Team 5<o></o>​

[/TD]
[TD="width: 64"]

Team 15<o></o>​

[/TD]
[/TR]
[TR]
[TD="width: 64, bgcolor: transparent"]

Round 7<o></o>​

[/TD]
[TD="width: 64"]

Team 9<o></o>​

[/TD]
[TD="width: 64"]

Team 10<o></o>​

[/TD]
[TD="width: 64"]

Team 1<o></o>​

[/TD]
[TD="width: 64"]

Team 6<o></o>​

[/TD]
[TD="width: 64"]

Team 11<o></o>​

[/TD]
[/TR]
[TR]
[TD="width: 64, bgcolor: transparent"]

Round 8<o></o>​

[/TD]
[TD="width: 64"]

Team 8<o></o>​

[/TD]
[TD="width: 64"]

Team 15<o></o>​

[/TD]
[TD="width: 64"]

Team 14<o></o>​

[/TD]
[TD="width: 64"]

Team 2<o></o>​

[/TD]
[TD="width: 64"]

Team 3<o></o>​

[/TD]
[/TR]
[TR]
[TD="width: 64, bgcolor: transparent"]

Round 9<o></o>​

[/TD]
[TD="width: 64"]

Team 5<o></o>​

[/TD]
[TD="width: 64"]

Team 13<o></o>​

[/TD]
[TD="width: 64"]

Team 4<o></o>​

[/TD]
[TD="width: 64"]

Team 12<o></o>​

[/TD]
[TD="width: 64"]

Team 7<o></o>​

[/TD]
[/TR]
[TR]
[TD="width: 64, bgcolor: transparent"]

Round 10<o></o>​

[/TD]
[TD="width: 64"]

Team 10<o></o>​

[/TD]
[TD="width: 64"]

Team 3<o></o>​

[/TD]
[TD="width: 64"]

Team 14<o></o>​

[/TD]
[TD="width: 64"]

Team 1<o></o>​

[/TD]
[TD="width: 64"]

Team 11<o></o>​

[/TD]
[/TR]
[TR]
[TD="width: 64, bgcolor: transparent"]

Round 11<o></o>​

[/TD]
[TD="width: 64"]

Team 15<o></o>​

[/TD]
[TD="width: 64"]

Team 4<o></o>​

[/TD]
[TD="width: 64"]

Team 5<o></o>​

[/TD]
[TD="width: 64"]

Team 13<o></o>​

[/TD]
[TD="width: 64"]

Team 2<o></o>​

[/TD]
[/TR]
[TR]
[TD="width: 64, bgcolor: transparent"]

Round 12<o></o>​

[/TD]
[TD="width: 64"]

Team 7<o></o>​

[/TD]
[TD="width: 64"]

Team 8<o></o>​

[/TD]
[TD="width: 64"]

Team 12<o></o>​

[/TD]
[TD="width: 64"]

Team 9<o></o>​

[/TD]
[TD="width: 64"]

Team 6<o></o>​

[/TD]
[/TR]
[TR]
[TD="width: 64, bgcolor: transparent"]

Round 13<o></o>​

[/TD]
[TD="width: 64"]

Team 12<o></o>​

[/TD]
[TD="width: 64"]

Team 4<o></o>​

[/TD]
[TD="width: 64"]

Team 13<o></o>​

[/TD]
[TD="width: 64"]

Team 11<o></o>​

[/TD]
[TD="width: 64"]

Team 1<o></o>​

[/TD]
[/TR]
[TR]
[TD="width: 64, bgcolor: transparent"]

Round 14<o></o>​

[/TD]
[TD="width: 64"]

Team 2<o></o>​

[/TD]
[TD="width: 64"]

Team 6<o></o>​

[/TD]
[TD="width: 64"]

Team 8<o></o>​

[/TD]
[TD="width: 64"]

Team 9<o></o>​

[/TD]
[TD="width: 64"]

Team 10<o></o>​

[/TD]
[/TR]
[TR]
[TD="width: 64, bgcolor: transparent"]

Round 15<o></o>​

[/TD]
[TD="width: 64"]

Team 14<o></o>​

[/TD]
[TD="width: 64"]

Team 15<o></o>​

[/TD]
[TD="width: 64"]

Team 7<o></o>​

[/TD]
[TD="width: 64"]

Team 3<o></o>​

[/TD]
[TD="width: 64"]

Team 5<o></o>​

[/TD]
[/TR]
[TR]
[TD="width: 64, bgcolor: transparent"]

Round 16<o></o>​

[/TD]
[TD="width: 64"]

Team 6<o></o>​

[/TD]
[TD="width: 64"]

Team 14<o></o>​

[/TD]
[TD="width: 64"]

Team 1<o></o>​

[/TD]
[TD="width: 64"]

Team 10<o></o>​

[/TD]
[TD="width: 64"]

Team 5<o></o>​

[/TD]
[/TR]
[TR]
[TD="width: 64, bgcolor: transparent"]

Round 17<o></o>​

[/TD]
[TD="width: 64"]

Team 13<o></o>​

[/TD]
[TD="width: 64"]

Team 11<o></o>​

[/TD]
[TD="width: 64"]

Team 3<o></o>​

[/TD]
[TD="width: 64"]

Team 15<o></o>​

[/TD]
[TD="width: 64"]

Team 2<o></o>​

[/TD]
[/TR]
[TR]
[TD="width: 64, bgcolor: transparent"]

Round 18<o></o>​

[/TD]
[TD="width: 64"]

Team 8<o></o>​

[/TD]
[TD="width: 64"]

Team 12<o></o>​

[/TD]
[TD="width: 64"]

Team 9<o></o>​

[/TD]
[TD="width: 64"]

Team 7<o></o>​

[/TD]
[TD="width: 64"]

Team 4<o></o>​

[/TD]
[/TR]
</tbody>[/TABLE]
<o></o>
<o></o>
I, then, want to tally how many times each team plays each other. I use the following base model to assist:<o></o>
<o></o>
[TABLE="class: MsoNormalTable, width: 768"]
<tbody>[TR]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

Team 1<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

Team 2<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

Team 3<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

Team 4<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

Team 5<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

Team 6<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

Team 7<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

Team 8<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

Team 9<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

Team 10<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

Team 11<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

Team 12<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

Team 13<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

Team 14<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

Team 15<o></o>​

[/TD]
[/TR]
[TR]
[TD="width: 64, bgcolor: transparent"]

Team 1<o></o>​

[/TD]
[TD="width: 64"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[/TR]
[TR]
[TD="width: 64, bgcolor: transparent"]

Team 2<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[/TR]
[TR]
[TD="width: 64, bgcolor: transparent"]

Team 3<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[/TR]
[TR]
[TD="width: 64, bgcolor: transparent"]

Team 4<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[/TR]
[TR]
[TD="width: 64, bgcolor: transparent"]

Team 5<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[/TR]
[TR]
[TD="width: 64, bgcolor: transparent"]

Team 6<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[/TR]
[TR]
[TD="width: 64, bgcolor: transparent"]

Team 7<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[/TR]
[TR]
[TD="width: 64, bgcolor: transparent"]

Team 8<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[/TR]
[TR]
[TD="width: 64, bgcolor: transparent"]

Team 9<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[/TR]
[TR]
[TD="width: 64, bgcolor: transparent"]

Team 10<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[/TR]
[TR]
[TD="width: 64, bgcolor: transparent"]

Team 11<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[/TR]
[TR]
[TD="width: 64, bgcolor: transparent"]

Team 12<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[/TR]
[TR]
[TD="width: 64, bgcolor: transparent"]

Team 13<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[/TR]
[TR]
[TD="width: 64, bgcolor: transparent"]

Team 14<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[/TR]
[TR]
[TD="width: 64, bgcolor: transparent"]

Team 15<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

<o></o>​

[/TD]
[TD="width: 64"]

<o></o>​

[/TD]
[/TR]
</tbody>[/TABLE]
<o></o>
My initial solution to avoid having to manually count everything (thereby increasing the chance of human error) was to use a COUNTIFS formula. Here is an example of that formula:<o></o>
<o></o>
=COUNTIFS(B4:F4,"Team 1",B4:F4,"Team 7")<o></o>
<o></o>
I want this formula to read the 5 teams playing in Round 1. Then I want it to read “Team 1” and then “Team 7” and count it as 1. However, when I plug this formula in, I get 0 instead. Why? This result doesn’t make sense to me at all. <o></o>

 

[DannyDresdan]

@ Marcelo Branco...Would you be able to help me tweek this?

 

[Marcelo Branco]

I took some vacation days.

I'm afraid that I do not know how to help you with this problem.

On my previous post I had suggested a formula that, given an existing schedule, might count how many times each team plays against other teams.

On this new scenario, I do not understand well what you want to achieve (what exactly do you want in White column?). It seems a complex problem involving combinatorial analysis.

M.

 

[DannyDresdan]

I took some vacation days.

I'm afraid that I do not know how to help you with this problem.

On my previous post I had suggested a formula that, given an existing schedule, might count how many times each team plays against other teams.

On this new scenario, I do not understand well what you want to achieve (what exactly do you want in White column?). It seems a complex problem involving combinatorial analysis.

M.

I'm sorry. I didn't mean for this to be confusing. Instead of 5 teams playing at the same time, I'd like to adjust it to where 6 teams play at the same time. I thought I could reverse engineer it to have your original formula account for that but I failed.

(NOTE: The colors in the columns are just the colors of the "Bases" that each team has to defend. It's a mute point in this formula, so long as it's understood that 6 teams will play per game instead of 5 teams per game.)

 

[JackBean]

DannyDresdan:

This problem has come up before in this forum.
It may have also come up other times,
but it was first posted as far as I know on Feb 8 2011 in Post 7 of:
http://www.mrexcel.com/forum/excel-questions/526153-find-match-formula.html

Where for 16 players (or 16 teams) where 6 play 16 times,
and each team plays each of the others twice.

I later solved this also on Nov 19, 2011 in post #9 same thread.

Later a symmetrical solution by me (across diagonal) was posted (post 55 May 27, 2012):

http://www.mrexcel.com/forum/excel-questions/556229-find-complete-series-numbers.html

These may be called coverings, and there is a collection of these at:
La Jolla Covering Repository

There are more solved sets in the same thread.
Some of these do not appear on the repository site above.

Quote from DannyDresdan this thread Nov 5th, 2013, 08:21 AM:
"How can I adjust this graph to account for a change in total teams attending?"

A change in total number of teams means finding a different solution to the new situation.

Other possible changes, for 32 instead of 16 games, stack two different solutions for the same situation.

Hobbyists or mathematicians or computer scientists who specialize in combinatorial problems work on such problems, which are NP hard or NP complete, meaning the difficulty or computing time goes up rapidly with larger numbers.

 

[DannyDresdan]

DannyDresdan:

This problem has come up before in this forum.
It may have also come up other times,
but it was first posted as far as I know on Feb 8 2011 in Post 7 of:
http://www.mrexcel.com/forum/excel-questions/526153-find-match-formula.html

Where for 16 players (or 16 teams) where 6 play 16 times,
and each team plays each of the others twice.

I later solved this also on Nov 19, 2011 in post #9 same thread.

Later a symmetrical solution by me (across diagonal) was posted (post 55 May 27, 2012):

http://www.mrexcel.com/forum/excel-questions/556229-find-complete-series-numbers.html

These may be called coverings, and there is a collection of these at:
La Jolla Covering Repository

There are more solved sets in the same thread.
Some of these do not appear on the repository site above.

Quote from DannyDresdan this thread Nov 5th, 2013, 08:21 AM:
"How can I adjust this graph to account for a change in total teams attending?"

A change in total number of teams means finding a different solution to the new situation.

Other possible changes, for 32 instead of 16 games, stack two different solutions for the same situation.

Hobbyists or mathematicians or computer scientists who specialize in combinatorial problems work on such problems, which are NP hard or NP complete, meaning the difficulty or computing time goes up rapidly with larger numbers.

JackBean,

I appreciate the effort and the links. I'll do my best to review them but I must be honest that a lot of this is WAAAAAAAAAAAAAAY beyond me at the present moment in time. Would it be possible to somehow amend the original formula to account for 6 teams playing per game, as opposed to 5 teams? I'm probably missing something obvious cause I don't believe it should be that difficult based on what Marcelo Branco has been kind enough to provide.

=SUMPRODUCT(--(MMULT(--((($B$4:$F$21=$A25)+($B$4:$F$21=B$24))>0),ROW($A$1:$A$5)^0)>1))

Perhaps I'm not explaining my intentions well enough...? Am I effectively communicating to everybody here what I'm look for? I admit fully that this is a bit unorthodox.

I'll do my best to study up on these terms and reverse engineer in an effort to understand this better. However, I really could use a solution to this with 6 teams playing per game in the event that I don't reach my 15 team goal for the tournament.

Kind Regards,
Danny Dresdan

 

[JackBean]

DannyDresdan:

You want solutions for 12 to 15 teams,
where 6 play at a time?
Is the number of rounds set or variable?
The number of rounds may be required to come up with a solution.
There may be and probably is not any ideal solution for these numbers.
It may be possible to come up with a solution that is better than most others,
but may not be the best possible.
The best possible would mean each player plays the most other players total.

For each of the non-ideal cases,
you would have to try to find a good or best solution for each case,
of number of teams, number of rounds, and how many play each time,
and there is no standard way to do this.

There is an ideal solution for:

6 7 5
6 11 3
6 16 2
6 31 1

Where 6 from 16 play each 2 times for 16 rounds.

The 6 11 3 ideal solution was posted in Post 15,
where 6 from 11 play 6 times in 11 rounds and each of the others is on each person's team 3 times,
and the 6 31 1 solution is Post27:
http://www.mrexcel.com/forum/excel-questions/526153-find-match-formula-2.html

And there is a list of possible ideal solutions in Post 16.

Here is a 6 11 3 'diagonal' solution:
[TABLE="width: 299"]
<tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD]A
[/TD]
[TD]B
[/TD]
[TD]C
[/TD]
[TD]D
[/TD]
[TD]E
[/TD]
[TD]F
[/TD]
[TD]G
[/TD]
[TD]H
[/TD]
[TD]I
[/TD]
[TD]J
[/TD]
[TD]K
[/TD]
[/TR]
[TR]
[TD]AEGHJK
[/TD]
[TD][/TD]
[TD="align: right"]1
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1
[/TD]
[TD][/TD]
[TD="align: right"]1
[/TD]
[TD="align: right"]1
[/TD]
[TD][/TD]
[TD="align: right"]1
[/TD]
[TD="align: right"]1
[/TD]
[/TR]
[TR]
[TD]ABFHIK
[/TD]
[TD][/TD]
[TD="align: right"]1
[/TD]
[TD="align: right"]1
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1
[/TD]
[TD][/TD]
[TD="align: right"]1
[/TD]
[TD="align: right"]1
[/TD]
[TD][/TD]
[TD="align: right"]1
[/TD]
[/TR]
[TR]
[TD]ABCGIJ
[/TD]
[TD][/TD]
[TD="align: right"]1
[/TD]
[TD="align: right"]1
[/TD]
[TD="align: right"]1
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1
[/TD]
[TD][/TD]
[TD="align: right"]1
[/TD]
[TD="align: right"]1
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]BCDHJK
[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1
[/TD]
[TD="align: right"]1
[/TD]
[TD="align: right"]1
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1
[/TD]
[TD][/TD]
[TD="align: right"]1
[/TD]
[TD="align: right"]1
[/TD]
[/TR]
[TR]
[TD]ACDEIK
[/TD]
[TD][/TD]
[TD="align: right"]1
[/TD]
[TD][/TD]
[TD="align: right"]1
[/TD]
[TD="align: right"]1
[/TD]
[TD="align: right"]1
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1
[/TD]
[TD][/TD]
[TD="align: right"]1
[/TD]
[/TR]
[TR]
[TD]ABDEFJ
[/TD]
[TD][/TD]
[TD="align: right"]1
[/TD]
[TD="align: right"]1
[/TD]
[TD][/TD]
[TD="align: right"]1
[/TD]
[TD="align: right"]1
[/TD]
[TD="align: right"]1
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]BCEFGK
[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1
[/TD]
[TD="align: right"]1
[/TD]
[TD][/TD]
[TD="align: right"]1
[/TD]
[TD="align: right"]1
[/TD]
[TD="align: right"]1
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1
[/TD]
[/TR]
[TR]
[TD]ACDFGH
[/TD]
[TD][/TD]
[TD="align: right"]1
[/TD]
[TD][/TD]
[TD="align: right"]1
[/TD]
[TD="align: right"]1
[/TD]
[TD][/TD]
[TD="align: right"]1
[/TD]
[TD="align: right"]1
[/TD]
[TD="align: right"]1
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]BDEGHI
[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1
[/TD]
[TD][/TD]
[TD="align: right"]1
[/TD]
[TD="align: right"]1
[/TD]
[TD][/TD]
[TD="align: right"]1
[/TD]
[TD="align: right"]1
[/TD]
[TD="align: right"]1
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]CEFHIJ
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1
[/TD]
[TD][/TD]
[TD="align: right"]1
[/TD]
[TD="align: right"]1
[/TD]
[TD][/TD]
[TD="align: right"]1
[/TD]
[TD="align: right"]1
[/TD]
[TD="align: right"]1
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]DFGIJK
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1
[/TD]
[TD][/TD]
[TD="align: right"]1
[/TD]
[TD="align: right"]1
[/TD]
[TD][/TD]
[TD="align: right"]1
[/TD]
[TD="align: right"]1
[/TD]
[TD="align: right"]1
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1
[/TD]
[TD="align: right"]2
[/TD]
[TD="align: right"]3
[/TD]
[TD="align: right"]4
[/TD]
[TD="align: right"]5
[/TD]
[TD="align: right"]6
[/TD]
[TD="align: right"]7
[/TD]
[TD="align: right"]8
[/TD]
[TD="align: right"]9
[/TD]
[TD="align: right"]10
[/TD]
[TD="align: right"]11
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD="align: right"]6
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD="align: right"]3
[/TD]
[TD="align: right"]6
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD="align: right"]3
[/TD]
[TD="align: right"]3
[/TD]
[TD="align: right"]6
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD="align: right"]3
[/TD]
[TD="align: right"]3
[/TD]
[TD="align: right"]3
[/TD]
[TD="align: right"]6
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD="align: right"]3
[/TD]
[TD="align: right"]3
[/TD]
[TD="align: right"]3
[/TD]
[TD="align: right"]3
[/TD]
[TD="align: right"]6
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD="align: right"]3
[/TD]
[TD="align: right"]3
[/TD]
[TD="align: right"]3
[/TD]
[TD="align: right"]3
[/TD]
[TD="align: right"]3
[/TD]
[TD="align: right"]6
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD="align: right"]3
[/TD]
[TD="align: right"]3
[/TD]
[TD="align: right"]3
[/TD]
[TD="align: right"]3
[/TD]
[TD="align: right"]3
[/TD]
[TD="align: right"]3
[/TD]
[TD="align: right"]6
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD="align: right"]3
[/TD]
[TD="align: right"]3
[/TD]
[TD="align: right"]3
[/TD]
[TD="align: right"]3
[/TD]
[TD="align: right"]3
[/TD]
[TD="align: right"]3
[/TD]
[TD="align: right"]3
[/TD]
[TD="align: right"]6
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD="align: right"]3
[/TD]
[TD="align: right"]3
[/TD]
[TD="align: right"]3
[/TD]
[TD="align: right"]3
[/TD]
[TD="align: right"]3
[/TD]
[TD="align: right"]3
[/TD]
[TD="align: right"]3
[/TD]
[TD="align: right"]3
[/TD]
[TD="align: right"]6
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD="align: right"]3
[/TD]
[TD="align: right"]3
[/TD]
[TD="align: right"]3
[/TD]
[TD="align: right"]3
[/TD]
[TD="align: right"]3
[/TD]
[TD="align: right"]3
[/TD]
[TD="align: right"]3
[/TD]
[TD="align: right"]3
[/TD]
[TD="align: right"]3
[/TD]
[TD="align: right"]6
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD="align: right"]3
[/TD]
[TD="align: right"]3
[/TD]
[TD="align: right"]3
[/TD]
[TD="align: right"]3
[/TD]
[TD="align: right"]3
[/TD]
[TD="align: right"]3
[/TD]
[TD="align: right"]3
[/TD]
[TD="align: right"]3
[/TD]
[TD="align: right"]3
[/TD]
[TD="align: right"]3
[/TD]
[TD="align: right"]6
[/TD]
[/TR]
</tbody>[/TABLE]

 

[DannyDresdan]

I understand the 1st half of your statement. I don't understand the 2nd half. Let me try and break it down better.

These are the constants...

* Each team plays 6 rounds
* There will be anywhere from 12-15 teams attending
* I'd like to have visibility of how many times each team plays one another per Marcelo's formula...but I'd like it to account for 6 teams now, instead of 5 teams. (It's such a chore to try and do this manually!)

And that's it!

***

Upon review of how I displayed my information, let me send a re-vamped version of my tournament schedule as it stands right now.

[TABLE="width: 549"]
<tbody>[TR]
[TD][/TD]
[TD]Base 1
[/TD]
[TD]Base 2
[/TD]
[TD]Base 3
[/TD]
[TD]Base 4
[/TD]
[TD]Base 5
[/TD]
[TD]Base 6
[/TD]
[/TR]
[TR]
[TD]Round 1
[/TD]
[TD]Team 1
[/TD]
[TD]Team 13
[/TD]
[TD]Team 15
[/TD]
[TD]Team 8
[/TD]
[TD]Team 10
[/TD]
[TD]???
[/TD]
[/TR]
[TR]
[TD]Round 2
[/TD]
[TD]Team 3
[/TD]
[TD]Team 2
[/TD]
[TD]Team 7
[/TD]
[TD]Team 4
[/TD]
[TD]Team 6
[/TD]
[TD]???
[/TD]
[/TR]
[TR]
[TD]Round 3
[/TD]
[TD]Team 14
[/TD]
[TD]Team 5
[/TD]
[TD]Team 12
[/TD]
[TD]Team 11
[/TD]
[TD]Team 9
[/TD]
[TD]???
[/TD]
[/TR]
[TR]
[TD]Round 4
[/TD]
[TD]Team 13
[/TD]
[TD]Team 1
[/TD]
[TD]Team 2
[/TD]
[TD]Team 14
[/TD]
[TD]Team 12
[/TD]
[TD]???
[/TD]
[/TR]
[TR]
[TD]Round 5
[/TD]
[TD]Team 3
[/TD]
[TD]Team 6
[/TD]
[TD]Team 11
[/TD]
[TD]Team 10
[/TD]
[TD]Team 4
[/TD]
[TD]???
[/TD]
[/TR]
[TR]
[TD]Round 6
[/TD]
[TD]Team 15
[/TD]
[TD]Team 7
[/TD]
[TD]Team 9
[/TD]
[TD]Team 5
[/TD]
[TD]Team 8
[/TD]
[TD]???
[/TD]
[/TR]
[TR]
[TD]Round 7
[/TD]
[TD]Team 9
[/TD]
[TD]Team 10
[/TD]
[TD]Team 1
[/TD]
[TD]Team 6
[/TD]
[TD]Team 11
[/TD]
[TD]???
[/TD]
[/TR]
[TR]
[TD]Round 8
[/TD]
[TD]Team 8
[/TD]
[TD]Team 14
[/TD]
[TD]Team 15
[/TD]
[TD]Team 2
[/TD]
[TD]Team 3
[/TD]
[TD]???
[/TD]
[/TR]
[TR]
[TD]Round 9
[/TD]
[TD]Team 5
[/TD]
[TD]Team 13
[/TD]
[TD]Team 4
[/TD]
[TD]Team 12
[/TD]
[TD]Team 7
[/TD]
[TD]???
[/TD]
[/TR]
[TR]
[TD]Round 10
[/TD]
[TD]Team 4
[/TD]
[TD]Team 3
[/TD]
[TD]Team 10
[/TD]
[TD]Team 1
[/TD]
[TD]Team 5
[/TD]
[TD]???
[/TD]
[/TR]
[TR]
[TD]Round 11
[/TD]
[TD]Team 2
[/TD]
[TD]Team 11
[/TD]
[TD]Team 14
[/TD]
[TD]Team 13
[/TD]
[TD]Team 15
[/TD]
[TD]???
[/TD]
[/TR]
[TR]
[TD]Round 12
[/TD]
[TD]Team 7
[/TD]
[TD]Team 8
[/TD]
[TD]Team 6
[/TD]
[TD]Team 9
[/TD]
[TD]Team 12
[/TD]
[TD]???
[/TD]
[/TR]
[TR]
[TD]Round 13
[/TD]
[TD]Team 12
[/TD]
[TD]Team 4
[/TD]
[TD]Team 1
[/TD]
[TD]Team 11
[/TD]
[TD]Team 13
[/TD]
[TD]???
[/TD]
[/TR]
[TR]
[TD]Round 14
[/TD]
[TD]Team 2
[/TD]
[TD]Team 6
[/TD]
[TD]Team 8
[/TD]
[TD]Team 9
[/TD]
[TD]Team 10
[/TD]
[TD]???
[/TD]
[/TR]
[TR]
[TD]Round 15
[/TD]
[TD]Team 7
[/TD]
[TD]Team 15
[/TD]
[TD]Team 5
[/TD]
[TD]Team 3
[/TD]
[TD]Team 14
[/TD]
[TD]???
[/TD]
[/TR]
[TR]
[TD]Round 16
[/TD]
[TD]Team 6
[/TD]
[TD]Team 12
[/TD]
[TD]Team 4
[/TD]
[TD]Team 14
[/TD]
[TD]Team 5
[/TD]
[TD]???
[/TD]
[/TR]
[TR]
[TD]Round 17
[/TD]
[TD]Team 11
[/TD]
[TD]Team 9
[/TD]
[TD]Team 13
[/TD]
[TD]Team 15
[/TD]
[TD]Team 2
[/TD]
[TD]???
[/TD]
[/TR]
[TR]
[TD]Round 18
[/TD]
[TD]Team 10
[/TD]
[TD]Team 8
[/TD]
[TD]Team 3
[/TD]
[TD]Team 7
[/TD]
[TD]Team 1
[/TD]
[TD]???
[/TD]
[/TR]
</tbody>[/TABLE]


[TABLE="width: 960"]
<tbody>[TR]
[TD][/TD]
[TD]Team 1
[/TD]
[TD]Team 2
[/TD]
[TD]Team 3
[/TD]
[TD]Team 4
[/TD]
[TD]Team 5
[/TD]
[TD]Team 6
[/TD]
[TD]Team 7
[/TD]
[TD]Team 8
[/TD]
[TD]Team 9
[/TD]
[TD]Team 10
[/TD]
[TD]Team 11
[/TD]
[TD]Team 12
[/TD]
[TD]Team 13
[/TD]
[TD]Team 14
[/TD]
[/TR]
[TR]
[TD]Team 1
[/TD]
[TD]0
[/TD]
[TD]1
[/TD]
[TD]2
[/TD]
[TD]2
[/TD]
[TD]1
[/TD]
[TD]1
[/TD]
[TD]1
[/TD]
[TD]2
[/TD]
[TD]1
[/TD]
[TD]4
[/TD]
[TD]2
[/TD]
[TD]2
[/TD]
[TD]3
[/TD]
[TD]1
[/TD]
[/TR]
[TR]
[TD]Team 2
[/TD]
[TD]1
[/TD]
[TD]0
[/TD]
[TD]2
[/TD]
[TD]1
[/TD]
[TD]0
[/TD]
[TD]2
[/TD]
[TD]1
[/TD]
[TD]2
[/TD]
[TD]2
[/TD]
[TD]1
[/TD]
[TD]2
[/TD]
[TD]1
[/TD]
[TD]3
[/TD]
[TD]3
[/TD]
[/TR]
[TR]
[TD]Team 3
[/TD]
[TD]2
[/TD]
[TD]2
[/TD]
[TD]0
[/TD]
[TD]3
[/TD]
[TD]2
[/TD]
[TD]2
[/TD]
[TD]3
[/TD]
[TD]2
[/TD]
[TD]0
[/TD]
[TD]3
[/TD]
[TD]1
[/TD]
[TD]0
[/TD]
[TD]0
[/TD]
[TD]2
[/TD]
[/TR]
[TR]
[TD]Team 4
[/TD]
[TD]2
[/TD]
[TD]1
[/TD]
[TD]3
[/TD]
[TD]0
[/TD]
[TD]3
[/TD]
[TD]3
[/TD]
[TD]2
[/TD]
[TD]0
[/TD]
[TD]0
[/TD]
[TD]2
[/TD]
[TD]2
[/TD]
[TD]3
[/TD]
[TD]2
[/TD]
[TD]1
[/TD]
[/TR]
[TR]
[TD]Team 5
[/TD]
[TD]1
[/TD]
[TD]0
[/TD]
[TD]2
[/TD]
[TD]3
[/TD]
[TD]0
[/TD]
[TD]1
[/TD]
[TD]3
[/TD]
[TD]1
[/TD]
[TD]2
[/TD]
[TD]1
[/TD]
[TD]1
[/TD]
[TD]3
[/TD]
[TD]1
[/TD]
[TD]3
[/TD]
[/TR]
[TR]
[TD]Team 6
[/TD]
[TD]1
[/TD]
[TD]2
[/TD]
[TD]2
[/TD]
[TD]3
[/TD]
[TD]1
[/TD]
[TD]0
[/TD]
[TD]2
[/TD]
[TD]2
[/TD]
[TD]3
[/TD]
[TD]3
[/TD]
[TD]2
[/TD]
[TD]2
[/TD]
[TD]0
[/TD]
[TD]1
[/TD]
[/TR]
[TR]
[TD]Team 7
[/TD]
[TD]1
[/TD]
[TD]1
[/TD]
[TD]3
[/TD]
[TD]2
[/TD]
[TD]3
[/TD]
[TD]2
[/TD]
[TD]0
[/TD]
[TD]3
[/TD]
[TD]2
[/TD]
[TD]1
[/TD]
[TD]0
[/TD]
[TD]2
[/TD]
[TD]1
[/TD]
[TD]1
[/TD]
[/TR]
[TR]
[TD]Team 8
[/TD]
[TD]2
[/TD]
[TD]2
[/TD]
[TD]2
[/TD]
[TD]0
[/TD]
[TD]1
[/TD]
[TD]2
[/TD]
[TD]3
[/TD]
[TD]0
[/TD]
[TD]3
[/TD]
[TD]3
[/TD]
[TD]0
[/TD]
[TD]1
[/TD]
[TD]1
[/TD]
[TD]1
[/TD]
[/TR]
[TR]
[TD]Team 9
[/TD]
[TD]1
[/TD]
[TD]2
[/TD]
[TD]0
[/TD]
[TD]0
[/TD]
[TD]2
[/TD]
[TD]3
[/TD]
[TD]2
[/TD]
[TD]3
[/TD]
[TD]0
[/TD]
[TD]2
[/TD]
[TD]3
[/TD]
[TD]2
[/TD]
[TD]1
[/TD]
[TD]1
[/TD]
[/TR]
[TR]
[TD]Team 10
[/TD]
[TD]4
[/TD]
[TD]1
[/TD]
[TD]3
[/TD]
[TD]2
[/TD]
[TD]1
[/TD]
[TD]3
[/TD]
[TD]1
[/TD]
[TD]3
[/TD]
[TD]2
[/TD]
[TD]0
[/TD]
[TD]2
[/TD]
[TD]0
[/TD]
[TD]1
[/TD]
[TD]0
[/TD]
[/TR]
[TR]
[TD]Team 11
[/TD]
[TD]2
[/TD]
[TD]2
[/TD]
[TD]1
[/TD]
[TD]2
[/TD]
[TD]1
[/TD]
[TD]2
[/TD]
[TD]0
[/TD]
[TD]0
[/TD]
[TD]3
[/TD]
[TD]2
[/TD]
[TD]0
[/TD]
[TD]2
[/TD]
[TD]3
[/TD]
[TD]2
[/TD]
[/TR]
[TR]
[TD]Team 12
[/TD]
[TD]2
[/TD]
[TD]1
[/TD]
[TD]0
[/TD]
[TD]3
[/TD]
[TD]3
[/TD]
[TD]2
[/TD]
[TD]2
[/TD]
[TD]1
[/TD]
[TD]2
[/TD]
[TD]0
[/TD]
[TD]2
[/TD]
[TD]0
[/TD]
[TD]3
[/TD]
[TD]3
[/TD]
[/TR]
[TR]
[TD]Team 13
[/TD]
[TD]3
[/TD]
[TD]3
[/TD]
[TD]0
[/TD]
[TD]2
[/TD]
[TD]1
[/TD]
[TD]0
[/TD]
[TD]1
[/TD]
[TD]1
[/TD]
[TD]1
[/TD]
[TD]1
[/TD]
[TD]3
[/TD]
[TD]3
[/TD]
[TD]0
[/TD]
[TD]2
[/TD]
[/TR]
[TR]
[TD]Team 14
[/TD]
[TD]1
[/TD]
[TD]3
[/TD]
[TD]2
[/TD]
[TD]1
[/TD]
[TD]3
[/TD]
[TD]1
[/TD]
[TD]1
[/TD]
[TD]1
[/TD]
[TD]1
[/TD]
[TD]0
[/TD]
[TD]2
[/TD]
[TD]3
[/TD]
[TD]2
[/TD]
[TD]0
[/TD]
[/TR]
</tbody>[/TABLE]


***


Just an FYI, when I say "BASE" I mean only a starting location in the laser tag arena for the teams to begin the game. I don't know what teams will start from "Base 6", I can figure that out once I have a means to get the above graph to work for 6 team, as it did when it accounted for 5 teams playing.

Does this provide scope to all people assisting me on what I'm trying to accomplish here?

 

[JackBean]

DannyDresdan:

The two parts of the example in the last post do not match up.
There are 14 teams in one and 15 in the other.

What is it that you do not understand about the last part of my last post?

The 6 11 3 'diagonal' solution is for 6 'teams' picked from 11 to play at a time where teams are A to K. There are 11 rounds and each plays 6 times and 'meets' with each of the other players 3 times total.

The ideal solutions are listed.
The one closest to your situation is the 6 16 2.

It appears it may be easiest to modify this solution to solve your problem.

Start with the ideal solution:
[TABLE="width: 410"]
<tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[TD]F[/TD]
[TD]G[/TD]
[TD]H[/TD]
[TD]I[/TD]
[TD]J[/TD]
[TD]K[/TD]
[TD]L[/TD]
[TD]M[/TD]
[TD]N[/TD]
[TD]O[/TD]
[TD]P[/TD]
[/TR]
[TR]
[TD]ABDFHM[/TD]
[TD]A[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]EFHIJN[/TD]
[TD]B[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]AGIJKM[/TD]
[TD]C[/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]BCGHJO[/TD]
[TD]D[/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]ABCILN[/TD]
[TD]E[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]CDEGMN[/TD]
[TD]F[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]HKLMNO[/TD]
[TD]G[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]DFGILO[/TD]
[TD]H[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]AEGHLP[/TD]
[TD]I[/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]ADJNOP[/TD]
[TD]J[/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]CFJLMP[/TD]
[TD]K[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]BEIMOP[/TD]
[TD]L[/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]BFGKNP[/TD]
[TD]M[/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]BDEJKL[/TD]
[TD]N[/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]CDHIKP[/TD]
[TD]O[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]ACEFKO[/TD]
[TD]P[/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]9[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]11[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]13[/TD]
[TD="align: right"]14[/TD]
[TD="align: right"]15[/TD]
[TD="align: right"]16[/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]6[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]6[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]6[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]6[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]6[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]6[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]6[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]6[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]9[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]6[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]6[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]11[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]6[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]6[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]13[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]6[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]14[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]6[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]15[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]6[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]16[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]6[/TD]
[/TR]
</tbody>[/TABLE]
Then modify by deleting all the P's, so there are now 15 teams.
[TABLE="width: 410"]
<tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[TD]F[/TD]
[TD]G[/TD]
[TD]H[/TD]
[TD]I[/TD]
[TD]J[/TD]
[TD]K[/TD]
[TD]L[/TD]
[TD]M[/TD]
[TD]N[/TD]
[TD]O[/TD]
[TD]P[/TD]
[/TR]
[TR]
[TD]ABDFHM[/TD]
[TD]A[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]EFHIJN[/TD]
[TD]B[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]AGIJKM[/TD]
[TD]C[/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]BCGHJO[/TD]
[TD]D[/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]ABCILN[/TD]
[TD]E[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]CDEGMN[/TD]
[TD]F[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]HKLMNO[/TD]
[TD]G[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]DFGILO[/TD]
[TD]H[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]ABEGHL[/TD]
[TD]I[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]ACDJNO[/TD]
[TD]J[/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]CDFJLM[/TD]
[TD]K[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]BEFIMO[/TD]
[TD]L[/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]BFGHKN[/TD]
[TD]M[/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]BDEJKL[/TD]
[TD]N[/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]CDHIJK[/TD]
[TD]O[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]ACEFKO[/TD]
[TD]P[/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]9[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]11[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]13[/TD]
[TD="align: right"]14[/TD]
[TD="align: right"]15[/TD]
[TD="align: right"]16[/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]6[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]6[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]6[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]6[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]6[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]6[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]6[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]6[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]9[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]6[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]6[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]11[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]6[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]6[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]13[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]6[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]14[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]6[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]15[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]6[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]16[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]6[/TD]
[/TR]
</tbody>[/TABLE]
This was done in such a way as to prevent any 4's.
All pair 1 to 3 times, and this may be the best possible.

Then delete all the O's, so there are 14 teams.
[TABLE="width: 410"]
<tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[TD]F[/TD]
[TD]G[/TD]
[TD]H[/TD]
[TD]I[/TD]
[TD]J[/TD]
[TD]K[/TD]
[TD]L[/TD]
[TD]M[/TD]
[TD]N[/TD]
[TD]O[/TD]
[TD]P[/TD]
[/TR]
[TR]
[TD]ABDFHM[/TD]
[TD]A[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]EFHIJN[/TD]
[TD]B[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]AGIJKM[/TD]
[TD]C[/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]BCGHJM[/TD]
[TD]D[/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]ABCILN[/TD]
[TD]E[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]CDEGMN[/TD]
[TD]F[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]HJKLMN[/TD]
[TD]G[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]DFGIKL[/TD]
[TD]H[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]ABEGHL[/TD]
[TD]I[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]ACDEJN[/TD]
[TD]J[/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]CDFJLM[/TD]
[TD]K[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]BEFGIM[/TD]
[TD]L[/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]BFGHKN[/TD]
[TD]M[/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]BDEJKL[/TD]
[TD]N[/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]CDHIJK[/TD]
[TD]O[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]ACEFKL[/TD]
[TD]P[/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]9[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]11[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]13[/TD]
[TD="align: right"]14[/TD]
[TD="align: right"]15[/TD]
[TD="align: right"]16[/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]6[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]6[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]6[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]6[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]6[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]6[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]6[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]6[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]9[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]6[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]6[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]11[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]6[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]6[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]13[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]6[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]14[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]6[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]15[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]6[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]16[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]6[/TD]
[/TR]
</tbody>[/TABLE]
This time there is one 4.
If a row is to be deleted, then if it is Row 10, the 4 is gone also.

To go to 13 or 12 teams, 4's will appear.

 

[DannyDresdan]

JackBean

I've screwed this up royally. You, and everybody else, have been very patient and I hope that everybody continues to be because (frankly) I don't understand a single thing you guys are saying!

There's discussion of this "6-11-3" diagonal thing. I'm confused. What is it, an American Football defensive formation (e.g. - "Bears 46", "Lebeau 3-4")?

You use the following chart...


[TABLE="class: cms_table, width: 410"]
<tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD]A
[/TD]
[TD]B
[/TD]
[TD]C
[/TD]
[TD]D
[/TD]
[TD]E
[/TD]
[TD]F
[/TD]
[TD]G
[/TD]
[TD]H
[/TD]
[TD]I
[/TD]
[TD]J
[/TD]
[TD]K
[/TD]
[TD]L
[/TD]
[TD]M
[/TD]
[TD]N
[/TD]
[TD]O
[/TD]
[TD]P
[/TD]
[/TR]
[TR]
[TD]ABDFHM
[/TD]
[TD]A
[/TD]
[TD="align: right"]1
[/TD]
[TD="align: right"]1
[/TD]
[TD][/TD]
[TD="align: right"]1
[/TD]
[TD][/TD]
[TD="align: right"]1
[/TD]
[TD][/TD]
[TD="align: right"]1
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]EFHIJN
[/TD]
[TD]B
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1
[/TD]
[TD="align: right"]1
[/TD]
[TD][/TD]
[TD="align: right"]1
[/TD]
[TD="align: right"]1
[/TD]
[TD="align: right"]1
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]AGIJKM
[/TD]
[TD]C
[/TD]
[TD="align: right"]1
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1
[/TD]
[TD][/TD]
[TD="align: right"]1
[/TD]
[TD="align: right"]1
[/TD]
[TD="align: right"]1
[/TD]
[TD][/TD]
[TD="align: right"]1
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]BCGHJO
[/TD]
[TD]D
[/TD]
[TD][/TD]
[TD="align: right"]1
[/TD]
[TD="align: right"]1
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1
[/TD]
[TD="align: right"]1
[/TD]
[TD][/TD]
[TD="align: right"]1
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]ABCILN
[/TD]
[TD]E
[/TD]
[TD="align: right"]1
[/TD]
[TD="align: right"]1
[/TD]
[TD="align: right"]1
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1
[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1
[/TD]
[TD][/TD]
[TD="align: right"]1
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]CDEGMN
[/TD]
[TD]F
[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1
[/TD]
[TD="align: right"]1
[/TD]
[TD="align: right"]1
[/TD]
[TD][/TD]
[TD="align: right"]1
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1
[/TD]
[TD="align: right"]1
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]HKLMNO
[/TD]
[TD]G
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1
[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1
[/TD]
[TD="align: right"]1
[/TD]
[TD="align: right"]1
[/TD]
[TD="align: right"]1
[/TD]
[TD="align: right"]1
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]DFGILO
[/TD]
[TD]H
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1
[/TD]
[TD][/TD]
[TD="align: right"]1
[/TD]
[TD="align: right"]1
[/TD]
[TD][/TD]
[TD="align: right"]1
[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1
[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]AEGHLP
[/TD]
[TD]I
[/TD]
[TD="align: right"]1
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1
[/TD]
[TD][/TD]
[TD="align: right"]1
[/TD]
[TD="align: right"]1
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1
[/TD]
[/TR]
[TR]
[TD]ADJNOP
[/TD]
[TD]J
[/TD]
[TD="align: right"]1
[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1
[/TD]
[TD="align: right"]1
[/TD]
[TD="align: right"]1
[/TD]
[/TR]
[TR]
[TD]CFJLMP
[/TD]
[TD]K
[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1
[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1
[/TD]
[TD][/TD]
[TD="align: right"]1
[/TD]
[TD="align: right"]1
[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1
[/TD]
[/TR]
[TR]
[TD]BEIMOP
[/TD]
[TD]L
[/TD]
[TD][/TD]
[TD="align: right"]1
[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1
[/TD]
[TD][/TD]
[TD="align: right"]1
[/TD]
[TD="align: right"]1
[/TD]
[/TR]
[TR]
[TD]BFGKNP
[/TD]
[TD]M
[/TD]
[TD][/TD]
[TD="align: right"]1
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1
[/TD]
[TD="align: right"]1
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1
[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1
[/TD]
[TD][/TD]
[TD="align: right"]1
[/TD]
[/TR]
[TR]
[TD]BDEJKL
[/TD]
[TD]N
[/TD]
[TD][/TD]
[TD="align: right"]1
[/TD]
[TD][/TD]
[TD="align: right"]1
[/TD]
[TD="align: right"]1
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1
[/TD]
[TD="align: right"]1
[/TD]
[TD="align: right"]1
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]CDHIKP
[/TD]
[TD]O
[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1
[/TD]
[TD="align: right"]1
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1
[/TD]
[TD="align: right"]1
[/TD]
[TD][/TD]
[TD="align: right"]1
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1
[/TD]
[/TR]
[TR]
[TD]ACEFKO
[/TD]
[TD]P
[/TD]
[TD="align: right"]1
[/TD]
[TD][/TD]
[TD="align: right"]1
[/TD]
[TD][/TD]
[TD="align: right"]1
[/TD]
[TD="align: right"]1
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1
[/TD]
[/TR]
</tbody>[/TABLE]


I don't know how to read this. What does ABDFHM mean? Does A mean "Team 1"? B = "Team 2"?

I'm not trying to disrespect for the time and effort taken to present possible solutions. But, to be frank, none of this is salient to me!

Plus, it doesn't help the root problem I'm having of trying to adjust the formula, provided by Marcelo, to account for 6 teams playing per game instead of 5.

I admit that my initial posts may have been confusing. Therefore, let me just press the reset button on this whole thing and amend my request to make this salient for all observing...

***

I had originally requested a formula I could use to easily tell how many times each team plays one another assuming the following...

* Each team plays 6 games
* There are 5 teams playing one another per game

Marcelo provided me with the following formula and it works PERFECT...

=SUMPRODUCT(--(MMULT(--((($B$4:$F$21=$A25)+($B$4:$F$21=B$24))>0),ROW($A$1:$A$5)^0)>1))

Marcelo had suggested using this formula on each empty cell in the following graph...


[TABLE="width: 768"]
<tbody>[TR]
[TD="class: xl65, width: 64, bgcolor: white"][/TD]
[TD="class: xl66, width: 64, bgcolor: white"]Team 1
[/TD]
[TD="class: xl66, width: 64, bgcolor: white"]Team 2
[/TD]
[TD="class: xl66, width: 64, bgcolor: white"]Team 3
[/TD]
[TD="class: xl66, width: 64, bgcolor: white"]Team 4
[/TD]
[TD="class: xl66, width: 64, bgcolor: white"]Team 5
[/TD]
[TD="class: xl66, width: 64, bgcolor: white"]Team 6
[/TD]
[TD="class: xl66, width: 64, bgcolor: white"]Team 7
[/TD]
[TD="class: xl66, width: 64, bgcolor: white"]Team 8
[/TD]
[TD="class: xl66, width: 64, bgcolor: white"]Team 9
[/TD]
[TD="class: xl66, width: 64, bgcolor: white"]Team 10
[/TD]
[TD="class: xl66, width: 64, bgcolor: white"]Team 11
[/TD]
[TD="class: xl66, width: 64, bgcolor: white"]Team 12
[/TD]
[TD="class: xl66, width: 64, bgcolor: white"]Team 13
[/TD]
[TD="class: xl66, width: 64, bgcolor: white"]Team 14
[/TD]
[TD="class: xl66, width: 64, bgcolor: white"]Team 15
[/TD]
[/TR]
[TR]
[TD="class: xl66, width: 64, bgcolor: white"]Team 1
[/TD]
[TD="class: xl70, width: 64, bgcolor: white"][/TD]
[TD="class: xl70, width: 64, bgcolor: white"][/TD]
[TD="class: xl70, width: 64, bgcolor: white"][/TD]
[TD="class: xl70, width: 64, bgcolor: white"][/TD]
[TD="class: xl70, width: 64, bgcolor: white"][/TD]
[TD="class: xl70, width: 64, bgcolor: white"][/TD]
[TD="class: xl70, width: 64, bgcolor: white"][/TD]
[TD="class: xl70, width: 64, bgcolor: white"][/TD]
[TD="class: xl70, width: 64, bgcolor: white"][/TD]
[TD="class: xl70, width: 64, bgcolor: white"][/TD]
[TD="class: xl70, width: 64, bgcolor: white"][/TD]
[TD="class: xl67, width: 64, bgcolor: white"][/TD]
[TD="class: xl67, width: 64, bgcolor: white"][/TD]
[TD="class: xl67, width: 64, bgcolor: white"][/TD]
[TD="class: xl67, width: 64, bgcolor: white"][/TD]
[/TR]
[TR]
[TD="class: xl66, width: 64, bgcolor: white"]Team 2
[/TD]
[TD="class: xl70, width: 64, bgcolor: white"][/TD]
[TD="class: xl70, width: 64, bgcolor: white"][/TD]
[TD="class: xl70, width: 64, bgcolor: white"][/TD]
[TD="class: xl70, width: 64, bgcolor: white"][/TD]
[TD="class: xl70, width: 64, bgcolor: white"][/TD]
[TD="class: xl70, width: 64, bgcolor: white"][/TD]
[TD="class: xl70, width: 64, bgcolor: white"][/TD]
[TD="class: xl70, width: 64, bgcolor: white"][/TD]
[TD="class: xl70, width: 64, bgcolor: white"][/TD]
[TD="class: xl70, width: 64, bgcolor: white"][/TD]
[TD="class: xl70, width: 64, bgcolor: white"][/TD]
[TD="class: xl67, width: 64, bgcolor: white"][/TD]
[TD="class: xl69, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl67, width: 64, bgcolor: white"][/TD]
[TD="class: xl67, width: 64, bgcolor: white"][/TD]
[/TR]
[TR]
[TD="class: xl66, width: 64, bgcolor: white"]Team 3
[/TD]
[TD="class: xl70, width: 64, bgcolor: white"][/TD]
[TD="class: xl70, width: 64, bgcolor: white"][/TD]
[TD="class: xl70, width: 64, bgcolor: white"][/TD]
[TD="class: xl70, width: 64, bgcolor: white"][/TD]
[TD="class: xl70, width: 64, bgcolor: white"][/TD]
[TD="class: xl70, width: 64, bgcolor: white"][/TD]
[TD="class: xl70, width: 64, bgcolor: white"][/TD]
[TD="class: xl70, width: 64, bgcolor: white"][/TD]
[TD="class: xl70, width: 64, bgcolor: white"][/TD]
[TD="class: xl70, width: 64, bgcolor: white"][/TD]
[TD="class: xl70, width: 64, bgcolor: white"][/TD]
[TD="class: xl67, width: 64, bgcolor: white"][/TD]
[TD="class: xl67, width: 64, bgcolor: white"][/TD]
[TD="class: xl69, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl67, width: 64, bgcolor: white"][/TD]
[/TR]
[TR]
[TD="class: xl68, width: 64, bgcolor: transparent"]Team 4
[/TD]
[TD="class: xl70, width: 64, bgcolor: white"][/TD]
[TD="class: xl70, width: 64, bgcolor: white"][/TD]
[TD="class: xl70, width: 64, bgcolor: white"][/TD]
[TD="class: xl70, width: 64, bgcolor: white"][/TD]
[TD="class: xl70, width: 64, bgcolor: white"][/TD]
[TD="class: xl70, width: 64, bgcolor: white"][/TD]
[TD="class: xl70, width: 64, bgcolor: white"][/TD]
[TD="class: xl70, width: 64, bgcolor: white"][/TD]
[TD="class: xl70, width: 64, bgcolor: white"][/TD]
[TD="class: xl70, width: 64, bgcolor: white"][/TD]
[TD="class: xl70, width: 64, bgcolor: white"][/TD]
[TD="class: xl69, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl69, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl69, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl67, width: 64, bgcolor: white"][/TD]
[/TR]
[TR]
[TD="class: xl66, width: 64, bgcolor: white"]Team 5
[/TD]
[TD="class: xl70, width: 64, bgcolor: white"][/TD]
[TD="class: xl70, width: 64, bgcolor: white"][/TD]
[TD="class: xl70, width: 64, bgcolor: white"][/TD]
[TD="class: xl70, width: 64, bgcolor: white"][/TD]
[TD="class: xl70, width: 64, bgcolor: white"][/TD]
[TD="class: xl70, width: 64, bgcolor: white"][/TD]
[TD="class: xl70, width: 64, bgcolor: white"][/TD]
[TD="class: xl70, width: 64, bgcolor: white"][/TD]
[TD="class: xl70, width: 64, bgcolor: white"][/TD]
[TD="class: xl70, width: 64, bgcolor: white"][/TD]
[TD="class: xl70, width: 64, bgcolor: white"][/TD]
[TD="class: xl69, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl69, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl69, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl67, width: 64, bgcolor: white"][/TD]
[/TR]
[TR]
[TD="class: xl66, width: 64, bgcolor: white"]Team 6
[/TD]
[TD="class: xl70, width: 64, bgcolor: white"][/TD]
[TD="class: xl70, width: 64, bgcolor: white"][/TD]
[TD="class: xl70, width: 64, bgcolor: white"][/TD]
[TD="class: xl70, width: 64, bgcolor: white"][/TD]
[TD="class: xl70, width: 64, bgcolor: white"][/TD]
[TD="class: xl70, width: 64, bgcolor: white"][/TD]
[TD="class: xl70, width: 64, bgcolor: white"][/TD]
[TD="class: xl70, width: 64, bgcolor: white"][/TD]
[TD="class: xl70, width: 64, bgcolor: white"][/TD]
[TD="class: xl70, width: 64, bgcolor: white"][/TD]
[TD="class: xl70, width: 64, bgcolor: white"][/TD]
[TD="class: xl69, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl69, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl69, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl67, width: 64, bgcolor: white"][/TD]
[/TR]
[TR]
[TD="class: xl66, width: 64, bgcolor: white"]Team 7
[/TD]
[TD="class: xl70, width: 64, bgcolor: white"][/TD]
[TD="class: xl70, width: 64, bgcolor: white"][/TD]
[TD="class: xl70, width: 64, bgcolor: white"][/TD]
[TD="class: xl70, width: 64, bgcolor: white"][/TD]
[TD="class: xl70, width: 64, bgcolor: white"][/TD]
[TD="class: xl70, width: 64, bgcolor: white"][/TD]
[TD="class: xl70, width: 64, bgcolor: white"][/TD]
[TD="class: xl70, width: 64, bgcolor: white"][/TD]
[TD="class: xl70, width: 64, bgcolor: white"][/TD]
[TD="class: xl70, width: 64, bgcolor: white"][/TD]
[TD="class: xl70, width: 64, bgcolor: white"][/TD]
[TD="class: xl69, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl69, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl69, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl67, width: 64, bgcolor: white"][/TD]
[/TR]
[TR]
[TD="class: xl66, width: 64, bgcolor: white"]Team 8
[/TD]
[TD="class: xl70, width: 64, bgcolor: white"][/TD]
[TD="class: xl70, width: 64, bgcolor: white"][/TD]
[TD="class: xl70, width: 64, bgcolor: white"][/TD]
[TD="class: xl70, width: 64, bgcolor: white"][/TD]
[TD="class: xl70, width: 64, bgcolor: white"][/TD]
[TD="class: xl70, width: 64, bgcolor: white"][/TD]
[TD="class: xl70, width: 64, bgcolor: white"][/TD]
[TD="class: xl70, width: 64, bgcolor: white"][/TD]
[TD="class: xl70, width: 64, bgcolor: white"][/TD]
[TD="class: xl70, width: 64, bgcolor: white"][/TD]
[TD="class: xl70, width: 64, bgcolor: white"][/TD]
[TD="class: xl69, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl69, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl69, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl67, width: 64, bgcolor: white"][/TD]
[/TR]
[TR]
[TD="class: xl66, width: 64, bgcolor: white"]Team 9
[/TD]
[TD="class: xl70, width: 64, bgcolor: white"][/TD]
[TD="class: xl70, width: 64, bgcolor: white"][/TD]
[TD="class: xl70, width: 64, bgcolor: white"][/TD]
[TD="class: xl70, width: 64, bgcolor: white"][/TD]
[TD="class: xl70, width: 64, bgcolor: white"][/TD]
[TD="class: xl70, width: 64, bgcolor: white"][/TD]
[TD="class: xl70, width: 64, bgcolor: white"][/TD]
[TD="class: xl70, width: 64, bgcolor: white"][/TD]
[TD="class: xl70, width: 64, bgcolor: white"][/TD]
[TD="class: xl70, width: 64, bgcolor: white"][/TD]
[TD="class: xl70, width: 64, bgcolor: white"][/TD]
[TD="class: xl69, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl69, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl69, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl67, width: 64, bgcolor: white"][/TD]
[/TR]
[TR]
[TD="class: xl66, width: 64, bgcolor: white"]Team 10
[/TD]
[TD="class: xl70, width: 64, bgcolor: white"][/TD]
[TD="class: xl70, width: 64, bgcolor: white"][/TD]
[TD="class: xl70, width: 64, bgcolor: white"][/TD]
[TD="class: xl70, width: 64, bgcolor: white"][/TD]
[TD="class: xl70, width: 64, bgcolor: white"][/TD]
[TD="class: xl70, width: 64, bgcolor: white"][/TD]
[TD="class: xl70, width: 64, bgcolor: white"][/TD]
[TD="class: xl70, width: 64, bgcolor: white"][/TD]
[TD="class: xl70, width: 64, bgcolor: white"][/TD]
[TD="class: xl70, width: 64, bgcolor: white"][/TD]
[TD="class: xl70, width: 64, bgcolor: white"][/TD]
[TD="class: xl69, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl69, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl69, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl67, width: 64, bgcolor: white"][/TD]
[/TR]
[TR]
[TD="class: xl66, width: 64, bgcolor: white"]Team 11
[/TD]
[TD="class: xl67, width: 64, bgcolor: white"][/TD]
[TD="class: xl69, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl69, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl69, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl69, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl69, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl69, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl69, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl69, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl69, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl69, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl69, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl69, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl69, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl67, width: 64, bgcolor: white"][/TD]
[/TR]
[TR]
[TD="class: xl66, width: 64, bgcolor: white"]Team 12
[/TD]
[TD="class: xl67, width: 64, bgcolor: white"][/TD]
[TD="class: xl69, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl69, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl69, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl69, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl69, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl69, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl69, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl69, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl69, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl69, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl69, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl69, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl69, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl67, width: 64, bgcolor: white"][/TD]
[/TR]
[TR]
[TD="class: xl66, width: 64, bgcolor: white"]Team 13
[/TD]
[TD="class: xl67, width: 64, bgcolor: white"][/TD]
[TD="class: xl69, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl69, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl69, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl69, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl69, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl69, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl69, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl69, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl69, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl69, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl69, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl69, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl69, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl67, width: 64, bgcolor: white"][/TD]
[/TR]
[TR]
[TD="class: xl66, width: 64, bgcolor: white"]Team 14
[/TD]
[TD="class: xl67, width: 64, bgcolor: white"][/TD]
[TD="class: xl67, width: 64, bgcolor: white"][/TD]
[TD="class: xl69, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl67, width: 64, bgcolor: white"][/TD]
[TD="class: xl69, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl69, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl69, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl69, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl69, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl69, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl69, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl69, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl69, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl69, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl67, width: 64, bgcolor: white"][/TD]
[/TR]
[TR]
[TD="class: xl66, width: 64, bgcolor: white"]Team 15
[/TD]
[TD="class: xl67, width: 64, bgcolor: white"][/TD]
[TD="class: xl67, width: 64, bgcolor: white"][/TD]
[TD="class: xl67, width: 64, bgcolor: white"][/TD]
[TD="class: xl67, width: 64, bgcolor: white"][/TD]
[TD="class: xl67, width: 64, bgcolor: white"][/TD]
[TD="class: xl67, width: 64, bgcolor: white"][/TD]
[TD="class: xl67, width: 64, bgcolor: white"][/TD]
[TD="class: xl67, width: 64, bgcolor: white"][/TD]
[TD="class: xl67, width: 64, bgcolor: white"][/TD]
[TD="class: xl69, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl69, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl69, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl69, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl69, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl67, width: 64, bgcolor: white"][/TD]
[/TR]
</tbody>[/TABLE]

The MMULT part of the formula reads this information...

[TABLE="width: 288"]
<tbody>[TR]
[TD="class: xl66, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl66, width: 64, bgcolor: transparent"]Base 1
[/TD]
[TD="class: xl66, width: 64, bgcolor: transparent"]Base 2
[/TD]
[TD="class: xl66, width: 64, bgcolor: transparent"]Base 3
[/TD]
[TD="class: xl66, width: 64, bgcolor: transparent"]Base 4
[/TD]
[TD="class: xl66, width: 64, bgcolor: transparent"]Base 5
[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"]Round 1
[/TD]
[TD="class: xl63, bgcolor: #A6A6A6"]Team 1
[/TD]
[TD="class: xl63, bgcolor: #A6A6A6"]Team 13
[/TD]
[TD="class: xl63, bgcolor: #A6A6A6"]Team 15
[/TD]
[TD="class: xl63, bgcolor: #A6A6A6"]Team 8
[/TD]
[TD="class: xl63, bgcolor: #A6A6A6"]Team 10
[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"]Round 2
[/TD]
[TD="class: xl63, bgcolor: #A6A6A6"]Team 3
[/TD]
[TD="class: xl63, bgcolor: #A6A6A6"]Team 2
[/TD]
[TD="class: xl63, bgcolor: #A6A6A6"]Team 7
[/TD]
[TD="class: xl63, bgcolor: #A6A6A6"]Team 4
[/TD]
[TD="class: xl63, bgcolor: #A6A6A6"]Team 6
[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"]Round 3
[/TD]
[TD="class: xl63, bgcolor: #A6A6A6"]Team 11
[/TD]
[TD="class: xl63, bgcolor: #A6A6A6"]Team 5
[/TD]
[TD="class: xl63, bgcolor: #A6A6A6"]Team 14
[/TD]
[TD="class: xl63, bgcolor: #A6A6A6"]Team 9
[/TD]
[TD="class: xl63, bgcolor: #A6A6A6"]Team 12
[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"]Round 4
[/TD]
[TD="class: xl64, bgcolor: #D9D9D9"]Team 12
[/TD]
[TD="class: xl64, bgcolor: #D9D9D9"]Team 1
[/TD]
[TD="class: xl64, bgcolor: #D9D9D9"]Team 2
[/TD]
[TD="class: xl64, bgcolor: #D9D9D9"]Team 14
[/TD]
[TD="class: xl64, bgcolor: #D9D9D9"]Team 13
[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"]Round 5
[/TD]
[TD="class: xl64, bgcolor: #D9D9D9"]Team 3
[/TD]
[TD="class: xl64, bgcolor: #D9D9D9"]Team 6
[/TD]
[TD="class: xl64, bgcolor: #D9D9D9"]Team 11
[/TD]
[TD="class: xl64, bgcolor: #D9D9D9"]Team 10
[/TD]
[TD="class: xl64, bgcolor: #D9D9D9"]Team 4
[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"]Round 6
[/TD]
[TD="class: xl64, bgcolor: #D9D9D9"]Team 8
[/TD]
[TD="class: xl64, bgcolor: #D9D9D9"]Team 9
[/TD]
[TD="class: xl64, bgcolor: #D9D9D9"]Team 7
[/TD]
[TD="class: xl64, bgcolor: #D9D9D9"]Team 5
[/TD]
[TD="class: xl64, bgcolor: #D9D9D9"]Team 15
[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"]Round 7
[/TD]
[TD="class: xl63, bgcolor: #A6A6A6"]Team 9
[/TD]
[TD="class: xl63, bgcolor: #A6A6A6"]Team 10
[/TD]
[TD="class: xl63, bgcolor: #A6A6A6"]Team 1
[/TD]
[TD="class: xl63, bgcolor: #A6A6A6"]Team 6
[/TD]
[TD="class: xl63, bgcolor: #A6A6A6"]Team 11
[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"]Round 8
[/TD]
[TD="class: xl63, bgcolor: #A6A6A6"]Team 8
[/TD]
[TD="class: xl63, bgcolor: #A6A6A6"]Team 15
[/TD]
[TD="class: xl63, bgcolor: #A6A6A6"]Team 14
[/TD]
[TD="class: xl63, bgcolor: #A6A6A6"]Team 2
[/TD]
[TD="class: xl63, bgcolor: #A6A6A6"]Team 3
[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"]Round 9
[/TD]
[TD="class: xl63, bgcolor: #A6A6A6"]Team 5
[/TD]
[TD="class: xl63, bgcolor: #A6A6A6"]Team 13
[/TD]
[TD="class: xl63, bgcolor: #A6A6A6"]Team 4
[/TD]
[TD="class: xl63, bgcolor: #A6A6A6"]Team 12
[/TD]
[TD="class: xl63, bgcolor: #A6A6A6"]Team 7
[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"]Round 10
[/TD]
[TD="class: xl64, bgcolor: #D9D9D9"]Team 5
[/TD]
[TD="class: xl64, bgcolor: #D9D9D9"]Team 3
[/TD]
[TD="class: xl64, bgcolor: #D9D9D9"]Team 10
[/TD]
[TD="class: xl64, bgcolor: #D9D9D9"]Team 1
[/TD]
[TD="class: xl64, bgcolor: #D9D9D9"]Team 4
[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"]Round 11
[/TD]
[TD="class: xl64, bgcolor: #D9D9D9"]Team 15
[/TD]
[TD="class: xl64, bgcolor: #D9D9D9"]Team 11
[/TD]
[TD="class: xl64, bgcolor: #D9D9D9"]Team 14
[/TD]
[TD="class: xl64, bgcolor: #D9D9D9"]Team 13
[/TD]
[TD="class: xl64, bgcolor: #D9D9D9"]Team 2
[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"]Round 12
[/TD]
[TD="class: xl64, bgcolor: #D9D9D9"]Team 7
[/TD]
[TD="class: xl64, bgcolor: #D9D9D9"]Team 8
[/TD]
[TD="class: xl64, bgcolor: #D9D9D9"]Team 12
[/TD]
[TD="class: xl64, bgcolor: #D9D9D9"]Team 9
[/TD]
[TD="class: xl64, bgcolor: #D9D9D9"]Team 6
[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"]Round 13
[/TD]
[TD="class: xl63, bgcolor: #A6A6A6"]Team 12
[/TD]
[TD="class: xl63, bgcolor: #A6A6A6"]Team 4
[/TD]
[TD="class: xl63, bgcolor: #A6A6A6"]Team 13
[/TD]
[TD="class: xl63, bgcolor: #A6A6A6"]Team 11
[/TD]
[TD="class: xl63, bgcolor: #A6A6A6"]Team 1
[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"]Round 14
[/TD]
[TD="class: xl63, bgcolor: #A6A6A6"]Team 2
[/TD]
[TD="class: xl63, bgcolor: #A6A6A6"]Team 6
[/TD]
[TD="class: xl63, bgcolor: #A6A6A6"]Team 8
[/TD]
[TD="class: xl63, bgcolor: #A6A6A6"]Team 9
[/TD]
[TD="class: xl63, bgcolor: #A6A6A6"]Team 10
[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"]Round 15
[/TD]
[TD="class: xl63, bgcolor: #A6A6A6"]Team 14
[/TD]
[TD="class: xl63, bgcolor: #A6A6A6"]Team 15
[/TD]
[TD="class: xl63, bgcolor: #A6A6A6"]Team 7
[/TD]
[TD="class: xl63, bgcolor: #A6A6A6"]Team 3
[/TD]
[TD="class: xl63, bgcolor: #A6A6A6"]Team 5
[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"]Round 16
[/TD]
[TD="class: xl65, bgcolor: #D9D9D9"]Team 6
[/TD]
[TD="class: xl65, bgcolor: #D9D9D9"]Team 14
[/TD]
[TD="class: xl65, bgcolor: #D9D9D9"]Team 4
[/TD]
[TD="class: xl65, bgcolor: #D9D9D9"]Team 12
[/TD]
[TD="class: xl65, bgcolor: #D9D9D9"]Team 5
[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"]Round 17
[/TD]
[TD="class: xl65, bgcolor: #D9D9D9"]Team 13
[/TD]
[TD="class: xl65, bgcolor: #D9D9D9"]Team 11
[/TD]
[TD="class: xl65, bgcolor: #D9D9D9"]Team 9
[/TD]
[TD="class: xl65, bgcolor: #D9D9D9"]Team 15
[/TD]
[TD="class: xl65, bgcolor: #D9D9D9"]Team 2
[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"]Round 18
[/TD]
[TD="class: xl65, bgcolor: #D9D9D9"]Team 8
[/TD]
[TD="class: xl65, bgcolor: #D9D9D9"]Team 10
[/TD]
[TD="class: xl65, bgcolor: #D9D9D9"]Team 3
[/TD]
[TD="class: xl65, bgcolor: #D9D9D9"]Team 7
[/TD]
[TD="class: xl65, bgcolor: #D9D9D9"]Team 1
[/TD]
[/TR]
</tbody>[/TABLE]


After putting in Marcelo's formula to each empty cell, this was the result...


[TABLE="width: 768"]
<tbody>[TR]
[TD="class: xl65, width: 64, bgcolor: white"][/TD]
[TD="class: xl66, width: 64, bgcolor: white"]Team 1
[/TD]
[TD="class: xl66, width: 64, bgcolor: white"]Team 2
[/TD]
[TD="class: xl66, width: 64, bgcolor: white"]Team 3
[/TD]
[TD="class: xl66, width: 64, bgcolor: white"]Team 4
[/TD]
[TD="class: xl66, width: 64, bgcolor: white"]Team 5
[/TD]
[TD="class: xl66, width: 64, bgcolor: white"]Team 6
[/TD]
[TD="class: xl66, width: 64, bgcolor: white"]Team 7
[/TD]
[TD="class: xl66, width: 64, bgcolor: white"]Team 8
[/TD]
[TD="class: xl66, width: 64, bgcolor: white"]Team 9
[/TD]
[TD="class: xl66, width: 64, bgcolor: white"]Team 10
[/TD]
[TD="class: xl66, width: 64, bgcolor: white"]Team 11
[/TD]
[TD="class: xl66, width: 64, bgcolor: white"]Team 12
[/TD]
[TD="class: xl66, width: 64, bgcolor: white"]Team 13
[/TD]
[TD="class: xl66, width: 64, bgcolor: white"]Team 14
[/TD]
[TD="class: xl66, width: 64, bgcolor: white"]Team 15
[/TD]
[/TR]
[TR]
[TD="class: xl66, width: 64, bgcolor: white"]Team 1
[/TD]
[TD="class: xl67, width: 64, bgcolor: white"]0
[/TD]
[TD="class: xl67, width: 64, bgcolor: white"]1
[/TD]
[TD="class: xl67, width: 64, bgcolor: white"]2
[/TD]
[TD="class: xl67, width: 64, bgcolor: white"]2
[/TD]
[TD="class: xl67, width: 64, bgcolor: white"]1
[/TD]
[TD="class: xl67, width: 64, bgcolor: white"]1
[/TD]
[TD="class: xl67, width: 64, bgcolor: white"]1
[/TD]
[TD="class: xl67, width: 64, bgcolor: white"]2
[/TD]
[TD="class: xl67, width: 64, bgcolor: white"]1
[/TD]
[TD="class: xl68, width: 64, bgcolor: red"]4
[/TD]
[TD="class: xl67, width: 64, bgcolor: white"]2
[/TD]
[TD="class: xl67, width: 64, bgcolor: white"]2
[/TD]
[TD="class: xl67, width: 64, bgcolor: white"]3
[/TD]
[TD="class: xl67, width: 64, bgcolor: white"]1
[/TD]
[TD="class: xl67, width: 64, bgcolor: white"]1
[/TD]
[/TR]
[TR]
[TD="class: xl66, width: 64, bgcolor: white"]Team 2
[/TD]
[TD="class: xl67, width: 64, bgcolor: white"]1
[/TD]
[TD="class: xl67, width: 64, bgcolor: white"]0
[/TD]
[TD="class: xl67, width: 64, bgcolor: white"]2
[/TD]
[TD="class: xl67, width: 64, bgcolor: white"]1
[/TD]
[TD="class: xl67, width: 64, bgcolor: white"]0
[/TD]
[TD="class: xl67, width: 64, bgcolor: white"]2
[/TD]
[TD="class: xl67, width: 64, bgcolor: white"]1
[/TD]
[TD="class: xl67, width: 64, bgcolor: white"]2
[/TD]
[TD="class: xl67, width: 64, bgcolor: white"]2
[/TD]
[TD="class: xl67, width: 64, bgcolor: white"]1
[/TD]
[TD="class: xl67, width: 64, bgcolor: white"]2
[/TD]
[TD="class: xl67, width: 64, bgcolor: white"]1
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]3
[/TD]
[TD="class: xl67, width: 64, bgcolor: white"]3
[/TD]
[TD="class: xl67, width: 64, bgcolor: white"]3
[/TD]
[/TR]
[TR]
[TD="class: xl66, width: 64, bgcolor: white"]Team 3
[/TD]
[TD="class: xl67, width: 64, bgcolor: white"]2
[/TD]
[TD="class: xl67, width: 64, bgcolor: white"]2
[/TD]
[TD="class: xl67, width: 64, bgcolor: white"]0
[/TD]
[TD="class: xl67, width: 64, bgcolor: white"]3
[/TD]
[TD="class: xl67, width: 64, bgcolor: white"]2
[/TD]
[TD="class: xl67, width: 64, bgcolor: white"]2
[/TD]
[TD="class: xl67, width: 64, bgcolor: white"]3
[/TD]
[TD="class: xl67, width: 64, bgcolor: white"]2
[/TD]
[TD="class: xl67, width: 64, bgcolor: white"]0
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]3
[/TD]
[TD="class: xl67, width: 64, bgcolor: white"]1
[/TD]
[TD="class: xl67, width: 64, bgcolor: white"]0
[/TD]
[TD="class: xl67, width: 64, bgcolor: white"]0
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]2
[/TD]
[TD="class: xl67, width: 64, bgcolor: white"]2
[/TD]
[/TR]
[TR]
[TD="class: xl69, width: 64, bgcolor: transparent"]Team 4
[/TD]
[TD="class: xl67, width: 64, bgcolor: white"]2
[/TD]
[TD="class: xl67, width: 64, bgcolor: white"]1
[/TD]
[TD="class: xl67, width: 64, bgcolor: white"]3
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]0
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]3
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]3
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]2
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]0
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]0
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]2
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]2
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]3
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]2
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]1
[/TD]
[TD="class: xl67, width: 64, bgcolor: white"]0
[/TD]
[/TR]
[TR]
[TD="class: xl66, width: 64, bgcolor: white"]Team 5
[/TD]
[TD="class: xl67, width: 64, bgcolor: white"]1
[/TD]
[TD="class: xl67, width: 64, bgcolor: white"]0
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]2
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]3
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]0
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]1
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]3
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]1
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]2
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]1
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]1
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]3
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]1
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]3
[/TD]
[TD="class: xl67, width: 64, bgcolor: white"]2
[/TD]
[/TR]
[TR]
[TD="class: xl66, width: 64, bgcolor: white"]Team 6
[/TD]
[TD="class: xl67, width: 64, bgcolor: white"]1
[/TD]
[TD="class: xl67, width: 64, bgcolor: white"]2
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]2
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]3
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]1
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]0
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]2
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]2
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]3
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]3
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]2
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]2
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]0
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]1
[/TD]
[TD="class: xl67, width: 64, bgcolor: white"]0
[/TD]
[/TR]
[TR]
[TD="class: xl66, width: 64, bgcolor: white"]Team 7
[/TD]
[TD="class: xl67, width: 64, bgcolor: white"]1
[/TD]
[TD="class: xl67, width: 64, bgcolor: white"]1
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]3
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]2
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]3
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]2
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]0
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]3
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]2
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]1
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]0
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]2
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]1
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]1
[/TD]
[TD="class: xl67, width: 64, bgcolor: white"]2
[/TD]
[/TR]
[TR]
[TD="class: xl66, width: 64, bgcolor: white"]Team 8
[/TD]
[TD="class: xl67, width: 64, bgcolor: white"]2
[/TD]
[TD="class: xl67, width: 64, bgcolor: white"]2
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]2
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]0
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]1
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]2
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]3
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]0
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]3
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]3
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]0
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]1
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]1
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]1
[/TD]
[TD="class: xl67, width: 64, bgcolor: white"]3
[/TD]
[/TR]
[TR]
[TD="class: xl66, width: 64, bgcolor: white"]Team 9
[/TD]
[TD="class: xl67, width: 64, bgcolor: white"]1
[/TD]
[TD="class: xl67, width: 64, bgcolor: white"]2
[/TD]
[TD="class: xl67, width: 64, bgcolor: white"]0
[/TD]
[TD="class: xl67, width: 64, bgcolor: white"]0
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]2
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]3
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]2
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]3
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]0
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]2
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]3
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]2
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]1
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]1
[/TD]
[TD="class: xl67, width: 64, bgcolor: white"]2
[/TD]
[/TR]
[TR]
[TD="class: xl66, width: 64, bgcolor: white"]Team 10
[/TD]
[TD="class: xl68, width: 64, bgcolor: red"]4
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]1
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]3
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]2
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]1
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]3
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]1
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]3
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]2
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]0
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]2
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]0
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]1
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]0
[/TD]
[TD="class: xl67, width: 64, bgcolor: white"]1
[/TD]
[/TR]
[TR]
[TD="class: xl66, width: 64, bgcolor: white"]Team 11
[/TD]
[TD="class: xl67, width: 64, bgcolor: white"]2
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]2
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]1
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]2
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]1
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]2
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]0
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]0
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]3
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]2
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]0
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]2
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]3
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]2
[/TD]
[TD="class: xl67, width: 64, bgcolor: white"]2
[/TD]
[/TR]
[TR]
[TD="class: xl66, width: 64, bgcolor: white"]Team 12
[/TD]
[TD="class: xl67, width: 64, bgcolor: white"]2
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]1
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]0
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]3
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]3
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]2
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]2
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]1
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]2
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]0
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]2
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]0
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]3
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]3
[/TD]
[TD="class: xl67, width: 64, bgcolor: white"]0
[/TD]
[/TR]
[TR]
[TD="class: xl66, width: 64, bgcolor: white"]Team 13
[/TD]
[TD="class: xl67, width: 64, bgcolor: white"]3
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]3
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]0
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]2
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]1
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]0
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]1
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]1
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]1
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]1
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]3
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]3
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]0
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]2
[/TD]
[TD="class: xl67, width: 64, bgcolor: white"]3
[/TD]
[/TR]
[TR]
[TD="class: xl66, width: 64, bgcolor: white"]Team 14
[/TD]
[TD="class: xl67, width: 64, bgcolor: white"]1
[/TD]
[TD="class: xl67, width: 64, bgcolor: white"]3
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]2
[/TD]
[TD="class: xl67, width: 64, bgcolor: white"]1
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]3
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]1
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]1
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]1
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]1
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]0
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]2
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]3
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]2
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]0
[/TD]
[TD="class: xl67, width: 64, bgcolor: white"]3
[/TD]
[/TR]
[TR]
[TD="class: xl66, width: 64, bgcolor: white"]Team 15
[/TD]
[TD="class: xl67, width: 64, bgcolor: white"]1
[/TD]
[TD="class: xl67, width: 64, bgcolor: white"]3
[/TD]
[TD="class: xl67, width: 64, bgcolor: white"]2
[/TD]
[TD="class: xl67, width: 64, bgcolor: white"]0
[/TD]
[TD="class: xl67, width: 64, bgcolor: white"]2
[/TD]
[TD="class: xl67, width: 64, bgcolor: white"]0
[/TD]
[TD="class: xl67, width: 64, bgcolor: white"]2
[/TD]
[TD="class: xl67, width: 64, bgcolor: white"]3
[/TD]
[TD="class: xl67, width: 64, bgcolor: white"]2
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]1
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]2
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]0
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]3
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]3
[/TD]
[TD="class: xl67, width: 64, bgcolor: white"]0
[/TD]
[/TR]
</tbody>[/TABLE]



***

Now I'd like to do the same thing but account for 6 teams playing per game instead of 5 teams per game (In retrospect, this is probably what I should have asked for in the 1st place).

Each team plays 6 games. Here's a rough draft example of my schedule for this tournament if 14 Teams show up...


[TABLE="width: 336"]
<tbody>[TR]
[TD="class: xl64, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl64, width: 64, bgcolor: transparent"]Base 1
[/TD]
[TD="class: xl64, width: 64, bgcolor: transparent"]Base 2
[/TD]
[TD="class: xl64, width: 64, bgcolor: transparent"]Base 3
[/TD]
[TD="class: xl64, width: 64, bgcolor: transparent"]Base 4
[/TD]
[TD="class: xl64, width: 64, bgcolor: transparent"]Base 5
[/TD]
[TD="class: xl64, width: 64, bgcolor: transparent"]Base 6
[/TD]
[/TR]
[TR]
[TD="class: xl64, bgcolor: transparent"]Round 1
[/TD]
[TD="class: xl63, bgcolor: #A6A6A6"]Team 1
[/TD]
[TD="class: xl63, bgcolor: #A6A6A6"]Team 2
[/TD]
[TD="class: xl63, bgcolor: #A6A6A6"]Team 3
[/TD]
[TD="class: xl63, bgcolor: #A6A6A6"]Team 4
[/TD]
[TD="class: xl63, bgcolor: #A6A6A6"]Team 5
[/TD]
[TD="class: xl63, bgcolor: #A6A6A6"]Team 6
[/TD]
[/TR]
[TR]
[TD="class: xl64, bgcolor: transparent"]Round 2
[/TD]
[TD="class: xl63, bgcolor: #A6A6A6"]Team 7
[/TD]
[TD="class: xl63, bgcolor: #A6A6A6"]Team 8
[/TD]
[TD="class: xl63, bgcolor: #A6A6A6"]Team 9
[/TD]
[TD="class: xl63, bgcolor: #A6A6A6"]Team 10
[/TD]
[TD="class: xl63, bgcolor: #A6A6A6"]Team 11
[/TD]
[TD="class: xl63, bgcolor: #A6A6A6"]Team 12
[/TD]
[/TR]
[TR]
[TD="class: xl64, bgcolor: transparent"]Round 3
[/TD]
[TD="class: xl65, bgcolor: white"]Team 13
[/TD]
[TD="class: xl65, bgcolor: white"]Team 14
[/TD]
[TD="class: xl65, bgcolor: white"]Team 1
[/TD]
[TD="class: xl65, bgcolor: white"]Team 2
[/TD]
[TD="class: xl65, bgcolor: white"]Team 3
[/TD]
[TD="class: xl65, bgcolor: white"]Team 4
[/TD]
[/TR]
[TR]
[TD="class: xl64, bgcolor: transparent"]Round 4
[/TD]
[TD="class: xl64, bgcolor: transparent"]Team 5
[/TD]
[TD="class: xl64, bgcolor: transparent"]Team 6
[/TD]
[TD="class: xl64, bgcolor: transparent"]Team 7
[/TD]
[TD="class: xl64, bgcolor: transparent"]Team 8
[/TD]
[TD="class: xl64, bgcolor: transparent"]Team 9
[/TD]
[TD="class: xl64, bgcolor: transparent"]Team 10
[/TD]
[/TR]
[TR]
[TD="class: xl64, bgcolor: transparent"]Round 5
[/TD]
[TD="class: xl63, bgcolor: #A6A6A6"]Team 11
[/TD]
[TD="class: xl63, bgcolor: #A6A6A6"]Team 12
[/TD]
[TD="class: xl63, bgcolor: #A6A6A6"]Team 13
[/TD]
[TD="class: xl63, bgcolor: #A6A6A6"]Team 14
[/TD]
[TD="class: xl63, bgcolor: #A6A6A6"]Team 1
[/TD]
[TD="class: xl63, bgcolor: #A6A6A6"]Team 2
[/TD]
[/TR]
[TR]
[TD="class: xl64, bgcolor: transparent"]Round 6
[/TD]
[TD="class: xl63, bgcolor: #A6A6A6"]Team 3
[/TD]
[TD="class: xl63, bgcolor: #A6A6A6"]Team 4
[/TD]
[TD="class: xl63, bgcolor: #A6A6A6"]Team 5
[/TD]
[TD="class: xl63, bgcolor: #A6A6A6"]Team 6
[/TD]
[TD="class: xl63, bgcolor: #A6A6A6"]Team 7
[/TD]
[TD="class: xl63, bgcolor: #A6A6A6"]Team 8
[/TD]
[/TR]
[TR]
[TD="class: xl64, bgcolor: transparent"]Round 7
[/TD]
[TD="class: xl65, bgcolor: white"]Team 9
[/TD]
[TD="class: xl65, bgcolor: white"]Team 10
[/TD]
[TD="class: xl65, bgcolor: white"]Team 11
[/TD]
[TD="class: xl65, bgcolor: white"]Team 12
[/TD]
[TD="class: xl65, bgcolor: white"]Team 13
[/TD]
[TD="class: xl65, bgcolor: white"]Team 14
[/TD]
[/TR]
[TR]
[TD="class: xl64, bgcolor: transparent"]Round 8
[/TD]
[TD="class: xl65, bgcolor: white"]Team 1
[/TD]
[TD="class: xl65, bgcolor: white"]Team 2
[/TD]
[TD="class: xl65, bgcolor: white"]Team 3
[/TD]
[TD="class: xl65, bgcolor: white"]Team 4
[/TD]
[TD="class: xl65, bgcolor: white"]Team 5
[/TD]
[TD="class: xl65, bgcolor: white"]Team 6
[/TD]
[/TR]
[TR]
[TD="class: xl64, bgcolor: transparent"]Round 9
[/TD]
[TD="class: xl63, bgcolor: #A6A6A6"]Team 7
[/TD]
[TD="class: xl63, bgcolor: #A6A6A6"]Team 8
[/TD]
[TD="class: xl63, bgcolor: #A6A6A6"]Team 9
[/TD]
[TD="class: xl63, bgcolor: #A6A6A6"]Team 10
[/TD]
[TD="class: xl63, bgcolor: #A6A6A6"]Team 11
[/TD]
[TD="class: xl63, bgcolor: #A6A6A6"]Team 12
[/TD]
[/TR]
[TR]
[TD="class: xl64, bgcolor: transparent"]Round 10
[/TD]
[TD="class: xl63, bgcolor: #A6A6A6"]Team 13
[/TD]
[TD="class: xl63, bgcolor: #A6A6A6"]Team 14
[/TD]
[TD="class: xl63, bgcolor: #A6A6A6"]Team 1
[/TD]
[TD="class: xl63, bgcolor: #A6A6A6"]Team 2
[/TD]
[TD="class: xl63, bgcolor: #A6A6A6"]Team 3
[/TD]
[TD="class: xl63, bgcolor: #A6A6A6"]Team 4
[/TD]
[/TR]
[TR]
[TD="class: xl64, bgcolor: transparent"]Round 11
[/TD]
[TD="class: xl64, bgcolor: transparent"]Team 5
[/TD]
[TD="class: xl64, bgcolor: transparent"]Team 6
[/TD]
[TD="class: xl64, bgcolor: transparent"]Team 7
[/TD]
[TD="class: xl64, bgcolor: transparent"]Team 8
[/TD]
[TD="class: xl64, bgcolor: transparent"]Team 9
[/TD]
[TD="class: xl64, bgcolor: transparent"]Team 10
[/TD]
[/TR]
[TR]
[TD="class: xl64, bgcolor: transparent"]Round 12
[/TD]
[TD="class: xl64, bgcolor: transparent"]Team 11
[/TD]
[TD="class: xl65, bgcolor: white"]Team 12
[/TD]
[TD="class: xl65, bgcolor: white"]Team 13
[/TD]
[TD="class: xl65, bgcolor: white"]Team 14
[/TD]
[TD="class: xl65, bgcolor: white"]Team 1
[/TD]
[TD="class: xl65, bgcolor: white"]Team 2
[/TD]
[/TR]
[TR]
[TD="class: xl64, bgcolor: transparent"]Round 13
[/TD]
[TD="class: xl63, bgcolor: #A6A6A6"]Team 3
[/TD]
[TD="class: xl63, bgcolor: #A6A6A6"]Team 4
[/TD]
[TD="class: xl63, bgcolor: #A6A6A6"]Team 5
[/TD]
[TD="class: xl63, bgcolor: #A6A6A6"]Team 6
[/TD]
[TD="class: xl63, bgcolor: #A6A6A6"]Team 7
[/TD]
[TD="class: xl63, bgcolor: #A6A6A6"]Team 8
[/TD]
[/TR]
[TR]
[TD="class: xl64, bgcolor: transparent"]Round 14
[/TD]
[TD="class: xl63, bgcolor: #A6A6A6"]Team 9
[/TD]
[TD="class: xl63, bgcolor: #A6A6A6"]Team 10
[/TD]
[TD="class: xl63, bgcolor: #A6A6A6"]Team 11
[/TD]
[TD="class: xl63, bgcolor: #A6A6A6"]Team 12
[/TD]
[TD="class: xl63, bgcolor: #A6A6A6"]Team 13
[/TD]
[TD="class: xl63, bgcolor: #A6A6A6"]Team 14
[/TD]
[/TR]
</tbody>[/TABLE]


Now, obviously, this schedule sucks. Too many of the same teams play each other too many times. So I, first, adjust the chart to show only Teams 1-14...


[TABLE="width: 720"]
<tbody>[TR]
[TD="class: xl65, width: 64, bgcolor: white"][/TD]
[TD="class: xl66, width: 64, bgcolor: white"]Team 1
[/TD]
[TD="class: xl66, width: 64, bgcolor: white"]Team 2
[/TD]
[TD="class: xl66, width: 64, bgcolor: white"]Team 3
[/TD]
[TD="class: xl66, width: 64, bgcolor: white"]Team 4
[/TD]
[TD="class: xl66, width: 64, bgcolor: white"]Team 5
[/TD]
[TD="class: xl66, width: 64, bgcolor: white"]Team 6
[/TD]
[TD="class: xl66, width: 64, bgcolor: white"]Team 7
[/TD]
[TD="class: xl66, width: 64, bgcolor: white"]Team 8
[/TD]
[TD="class: xl66, width: 64, bgcolor: white"]Team 9
[/TD]
[TD="class: xl66, width: 64, bgcolor: white"]Team 10
[/TD]
[TD="class: xl66, width: 64, bgcolor: white"]Team 11
[/TD]
[TD="class: xl66, width: 64, bgcolor: white"]Team 12
[/TD]
[TD="class: xl66, width: 64, bgcolor: white"]Team 13
[/TD]
[TD="class: xl66, width: 64, bgcolor: white"]Team 14
[/TD]
[/TR]
[TR]
[TD="class: xl66, width: 64, bgcolor: white"]Team 1
[/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl66, width: 64, bgcolor: white"]Team 2
[/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl66, width: 64, bgcolor: white"]Team 3
[/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl67, width: 64, bgcolor: transparent"]Team 4
[/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl66, width: 64, bgcolor: white"]Team 5
[/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl66, width: 64, bgcolor: white"]Team 6
[/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl66, width: 64, bgcolor: white"]Team 7
[/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl66, width: 64, bgcolor: white"]Team 8
[/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl66, width: 64, bgcolor: white"]Team 9
[/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl66, width: 64, bgcolor: white"]Team 10
[/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl66, width: 64, bgcolor: white"]Team 11
[/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl66, width: 64, bgcolor: white"]Team 12
[/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl66, width: 64, bgcolor: white"]Team 13
[/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl66, width: 64, bgcolor: white"]Team
14
[/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[/TR]
</tbody>[/TABLE]


I use Marcelo formula again, and I get these results...

[TABLE="width: 720"]
<tbody>[TR]
[TD="class: xl65, width: 64, bgcolor: white"][/TD]
[TD="class: xl66, width: 64, bgcolor: white"]Team 1
[/TD]
[TD="class: xl66, width: 64, bgcolor: white"]Team 2
[/TD]
[TD="class: xl66, width: 64, bgcolor: white"]Team 3
[/TD]
[TD="class: xl66, width: 64, bgcolor: white"]Team 4
[/TD]
[TD="class: xl66, width: 64, bgcolor: white"]Team 5
[/TD]
[TD="class: xl66, width: 64, bgcolor: white"]Team 6
[/TD]
[TD="class: xl66, width: 64, bgcolor: white"]Team 7
[/TD]
[TD="class: xl66, width: 64, bgcolor: white"]Team 8
[/TD]
[TD="class: xl66, width: 64, bgcolor: white"]Team 9
[/TD]
[TD="class: xl66, width: 64, bgcolor: white"]Team 10
[/TD]
[TD="class: xl66, width: 64, bgcolor: white"]Team 11
[/TD]
[TD="class: xl66, width: 64, bgcolor: white"]Team 12
[/TD]
[TD="class: xl66, width: 64, bgcolor: white"]Team 13
[/TD]
[TD="class: xl66, width: 64, bgcolor: white"]Team 14
[/TD]
[/TR]
[TR]
[TD="class: xl66, width: 64, bgcolor: white"]Team 1
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]0
[/TD]
[TD="class: xl68, width: 64, bgcolor: red"]4
[/TD]
[TD="class: xl68, width: 64, bgcolor: red"]4
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]2
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]2
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]0
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]0
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]0
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]0
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]0
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]2
[/TD]
[TD="class: xl67, width: 64, bgcolor: white"]2
[/TD]
[TD="class: xl68, width: 64, bgcolor: red"]4
[/TD]
[TD="class: xl68, width: 64, bgcolor: red"]4
[/TD]
[/TR]
[TR]
[TD="class: xl66, width: 64, bgcolor: white"]Team 2
[/TD]
[TD="class: xl68, width: 64, bgcolor: red"]4
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]0
[/TD]
[TD="class: xl68, width: 64, bgcolor: red"]4
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]2
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]2
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]0
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]0
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]0
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]0
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]0
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]0
[/TD]
[TD="class: xl67, width: 64, bgcolor: white"]0
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]2
[/TD]
[TD="class: xl67, width: 64, bgcolor: white"]2
[/TD]
[/TR]
[TR]
[TD="class: xl66, width: 64, bgcolor: white"]Team 3
[/TD]
[TD="class: xl68, width: 64, bgcolor: red"]4
[/TD]
[TD="class: xl68, width: 64, bgcolor: red"]4
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]0
[/TD]
[TD="class: xl68, width: 64, bgcolor: red"]4
[/TD]
[TD="class: xl68, width: 64, bgcolor: red"]4
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]2
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]2
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]0
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]0
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]0
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]0
[/TD]
[TD="class: xl67, width: 64, bgcolor: white"]0
[/TD]
[TD="class: xl67, width: 64, bgcolor: white"]2
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]2
[/TD]
[/TR]
[TR]
[TD="class: xl69, width: 64, bgcolor: transparent"]Team 4
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]2
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]2
[/TD]
[TD="class: xl68, width: 64, bgcolor: red"]4
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]0
[/TD]
[TD="class: xl68, width: 64, bgcolor: red"]4
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]2
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]2
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]0
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]0
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]0
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]0
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]0
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]0
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]0
[/TD]
[/TR]
[TR]
[TD="class: xl66, width: 64, bgcolor: white"]Team 5
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]2
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]2
[/TD]
[TD="class: xl68, width: 64, bgcolor: red"]4
[/TD]
[TD="class: xl68, width: 64, bgcolor: red"]4
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]0
[/TD]
[TD="class: xl68, width: 64, bgcolor: red"]4
[/TD]
[TD="class: xl68, width: 64, bgcolor: red"]4
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]2
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]2
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]0
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]0
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]0
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]0
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]0
[/TD]
[/TR]
[TR]
[TD="class: xl66, width: 64, bgcolor: white"]Team 6
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]0
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]0
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]2
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]2
[/TD]
[TD="class: xl68, width: 64, bgcolor: red"]4
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]0
[/TD]
[TD="class: xl68, width: 64, bgcolor: red"]4
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]2
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]2
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]0
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]0
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]0
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]0
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]0
[/TD]
[/TR]
[TR]
[TD="class: xl66, width: 64, bgcolor: white"]Team 7
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]0
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]0
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]2
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]2
[/TD]
[TD="class: xl68, width: 64, bgcolor: red"]4
[/TD]
[TD="class: xl68, width: 64, bgcolor: red"]4
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]0
[/TD]
[TD="class: xl68, width: 64, bgcolor: red"]4
[/TD]
[TD="class: xl68, width: 64, bgcolor: red"]4
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]2
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]2
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]0
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]0
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]0
[/TD]
[/TR]
[TR]
[TD="class: xl66, width: 64, bgcolor: white"]Team 8
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]0
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]0
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]0
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]0
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]2
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]2
[/TD]
[TD="class: xl68, width: 64, bgcolor: red"]4
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]0
[/TD]
[TD="class: xl68, width: 64, bgcolor: red"]4
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]2
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]2
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]0
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]0
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]0
[/TD]
[/TR]
[TR]
[TD="class: xl66, width: 64, bgcolor: white"]Team 9
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]0
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]0
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]0
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]0
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]2
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]2
[/TD]
[TD="class: xl68, width: 64, bgcolor: red"]4
[/TD]
[TD="class: xl68, width: 64, bgcolor: red"]4
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]0
[/TD]
[TD="class: xl68, width: 64, bgcolor: red"]4
[/TD]
[TD="class: xl68, width: 64, bgcolor: red"]4
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]2
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]2
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]0
[/TD]
[/TR]
[TR]
[TD="class: xl66, width: 64, bgcolor: white"]Team 10
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]0
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]0
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]0
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]0
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]0
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]0
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]2
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]2
[/TD]
[TD="class: xl68, width: 64, bgcolor: red"]4
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]0
[/TD]
[TD="class: xl68, width: 64, bgcolor: red"]4
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]2
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]2
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]0
[/TD]
[/TR]
[TR]
[TD="class: xl66, width: 64, bgcolor: white"]Team 11
[/TD]
[TD="class: xl67, width: 64, bgcolor: white"]2
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]0
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]0
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]0
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]0
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]0
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]2
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]2
[/TD]
[TD="class: xl68, width: 64, bgcolor: red"]4
[/TD]
[TD="class: xl68, width: 64, bgcolor: red"]4
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]0
[/TD]
[TD="class: xl68, width: 64, bgcolor: red"]4
[/TD]
[TD="class: xl68, width: 64, bgcolor: red"]4
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]2
[/TD]
[/TR]
[TR]
[TD="class: xl66, width: 64, bgcolor: white"]Team 12
[/TD]
[TD="class: xl67, width: 64, bgcolor: white"]2
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]0
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]0
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]0
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]0
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]0
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]0
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]0
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]2
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]2
[/TD]
[TD="class: xl68, width: 64, bgcolor: red"]4
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]0
[/TD]
[TD="class: xl68, width: 64, bgcolor: red"]4
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]2
[/TD]
[/TR]
[TR]
[TD="class: xl66, width: 64, bgcolor: white"]Team 13
[/TD]
[TD="class: xl68, width: 64, bgcolor: red"]4
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]2
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]2
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]0
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]0
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]0
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]0
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]0
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]2
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]2
[/TD]
[TD="class: xl68, width: 64, bgcolor: red"]4
[/TD]
[TD="class: xl68, width: 64, bgcolor: red"]4
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]0
[/TD]
[TD="class: xl68, width: 64, bgcolor: red"]4
[/TD]
[/TR]
[TR]
[TD="class: xl66, width: 64, bgcolor: white"]Team 14
[/TD]
[TD="class: xl68, width: 64, bgcolor: red"]4
[/TD]
[TD="class: xl67, width: 64, bgcolor: white"]2
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]2
[/TD]
[TD="class: xl67, width: 64, bgcolor: white"]0
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]0
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]0
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]0
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]0
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]0
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]0
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]2
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]2
[/TD]
[TD="class: xl68, width: 64, bgcolor: red"]4
[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]0
[/TD]
[/TR]
</tbody>[/TABLE]


Now, I have a problem. Marcelo's original formula isn't accounting for the teams playing in "BASE 6". In example, according to this above example, Team 1 and Team 6 don't play each other. That's not true!

So far, I've tried everything within my specific expertise to try and reverse engineer Marcelo's formula to account for this change but it's been a complete failure. I've tried to seek assistance from this community and it would appear as if I failed to effectively communicate my EXACT intentions. I'm not looking for the perfect schedule. I'm looking for a means to make the original formula work to where this graph...

[TABLE="width: 720"]
<tbody>[TR]
[TD="class: xl65, width: 64, bgcolor: white"][/TD]
[TD="class: xl66, width: 64, bgcolor: white"]Team 1
[/TD]
[TD="class: xl66, width: 64, bgcolor: white"]Team 2
[/TD]
[TD="class: xl66, width: 64, bgcolor: white"]Team 3
[/TD]
[TD="class: xl66, width: 64, bgcolor: white"]Team 4
[/TD]
[TD="class: xl66, width: 64, bgcolor: white"]Team 5
[/TD]
[TD="class: xl66, width: 64, bgcolor: white"]Team 6
[/TD]
[TD="class: xl66, width: 64, bgcolor: white"]Team 7
[/TD]
[TD="class: xl66, width: 64, bgcolor: white"]Team 8
[/TD]
[TD="class: xl66, width: 64, bgcolor: white"]Team 9
[/TD]
[TD="class: xl66, width: 64, bgcolor: white"]Team 10
[/TD]
[TD="class: xl66, width: 64, bgcolor: white"]Team 11
[/TD]
[TD="class: xl66, width: 64, bgcolor: white"]Team 12
[/TD]
[TD="class: xl66, width: 64, bgcolor: white"]Team 13
[/TD]
[TD="class: xl66, width: 64, bgcolor: white"]Team 14
[/TD]
[/TR]
[TR]
[TD="class: xl66, width: 64, bgcolor: white"]Team 1
[/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl66, width: 64, bgcolor: white"]Team 2
[/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl66, width: 64, bgcolor: white"]Team 3
[/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl67, width: 64, bgcolor: transparent"]Team 4
[/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl66, width: 64, bgcolor: white"]Team 5
[/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl66, width: 64, bgcolor: white"]Team 6
[/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl66, width: 64, bgcolor: white"]Team 7
[/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl66, width: 64, bgcolor: white"]Team 8
[/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl66, width: 64, bgcolor: white"]Team 9
[/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl66, width: 64, bgcolor: white"]Team 10
[/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl66, width: 64, bgcolor: white"]Team 11
[/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl66, width: 64, bgcolor: white"]Team 12
[/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl66, width: 64, bgcolor: white"]Team 13
[/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl66, width: 64, bgcolor: white"]Team 14
[/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"][/TD]
[/TR]
</tbody>[/TABLE]


Accurately provides me quick visibility of how many times that each team plays another another based on this schedule...

[TABLE="width: 336"]
<tbody>[TR]
[TD="class: xl66, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl66, width: 64, bgcolor: transparent"]Base 1
[/TD]
[TD="class: xl66, width: 64, bgcolor: transparent"]Base 2
[/TD]
[TD="class: xl66, width: 64, bgcolor: transparent"]Base 3
[/TD]
[TD="class: xl66, width: 64, bgcolor: transparent"]Base 4
[/TD]
[TD="class: xl66, width: 64, bgcolor: transparent"]Base 5
[/TD]
[TD="class: xl66, width: 64, bgcolor: transparent"]Base 6
[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"]Round 1
[/TD]
[TD="class: xl65, bgcolor: #A6A6A6"]Team 1
[/TD]
[TD="class: xl65, bgcolor: #A6A6A6"]Team 2
[/TD]
[TD="class: xl65, bgcolor: #A6A6A6"]Team 3
[/TD]
[TD="class: xl65, bgcolor: #A6A6A6"]Team 4
[/TD]
[TD="class: xl65, bgcolor: #A6A6A6"]Team 5
[/TD]
[TD="class: xl65, bgcolor: #A6A6A6"]Team 6
[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"]Round 2
[/TD]
[TD="class: xl65, bgcolor: #A6A6A6"]Team 7
[/TD]
[TD="class: xl65, bgcolor: #A6A6A6"]Team 8
[/TD]
[TD="class: xl65, bgcolor: #A6A6A6"]Team 9
[/TD]
[TD="class: xl65, bgcolor: #A6A6A6"]Team 10
[/TD]
[TD="class: xl65, bgcolor: #A6A6A6"]Team 11
[/TD]
[TD="class: xl65, bgcolor: #A6A6A6"]Team 12
[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"]Round 3
[/TD]
[TD="class: xl67, bgcolor: white"]Team 13
[/TD]
[TD="class: xl67, bgcolor: white"]Team 14
[/TD]
[TD="class: xl67, bgcolor: white"]Team 1
[/TD]
[TD="class: xl67, bgcolor: white"]Team 2
[/TD]
[TD="class: xl67, bgcolor: white"]Team 3
[/TD]
[TD="class: xl67, bgcolor: white"]Team 4
[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"]Round 4
[/TD]
[TD="class: xl66, bgcolor: transparent"]Team 5
[/TD]
[TD="class: xl66, bgcolor: transparent"]Team 6
[/TD]
[TD="class: xl66, bgcolor: transparent"]Team 7
[/TD]
[TD="class: xl66, bgcolor: transparent"]Team 8
[/TD]
[TD="class: xl66, bgcolor: transparent"]Team 9
[/TD]
[TD="class: xl66, bgcolor: transparent"]Team 10
[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"]Round 5
[/TD]
[TD="class: xl65, bgcolor: #A6A6A6"]Team 11
[/TD]
[TD="class: xl65, bgcolor: #A6A6A6"]Team 12
[/TD]
[TD="class: xl65, bgcolor: #A6A6A6"]Team 13
[/TD]
[TD="class: xl65, bgcolor: #A6A6A6"]Team 14
[/TD]
[TD="class: xl65, bgcolor: #A6A6A6"]Team 1
[/TD]
[TD="class: xl65, bgcolor: #A6A6A6"]Team 2
[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"]Round 6
[/TD]
[TD="class: xl65, bgcolor: #A6A6A6"]Team 3
[/TD]
[TD="class: xl65, bgcolor: #A6A6A6"]Team 4
[/TD]
[TD="class: xl65, bgcolor: #A6A6A6"]Team 5
[/TD]
[TD="class: xl65, bgcolor: #A6A6A6"]Team 6
[/TD]
[TD="class: xl65, bgcolor: #A6A6A6"]Team 7
[/TD]
[TD="class: xl65, bgcolor: #A6A6A6"]Team 8
[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"]Round 7
[/TD]
[TD="class: xl67, bgcolor: white"]Team 9
[/TD]
[TD="class: xl67, bgcolor: white"]Team 10
[/TD]
[TD="class: xl67, bgcolor: white"]Team 11
[/TD]
[TD="class: xl67, bgcolor: white"]Team 12
[/TD]
[TD="class: xl67, bgcolor: white"]Team 13
[/TD]
[TD="class: xl67, bgcolor: white"]Team 14
[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"]Round 8
[/TD]
[TD="class: xl67, bgcolor: white"]Team 1
[/TD]
[TD="class: xl67, bgcolor: white"]Team 2
[/TD]
[TD="class: xl67, bgcolor: white"]Team 3
[/TD]
[TD="class: xl67, bgcolor: white"]Team 4
[/TD]
[TD="class: xl67, bgcolor: white"]Team 5
[/TD]
[TD="class: xl67, bgcolor: white"]Team 6
[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"]Round 9
[/TD]
[TD="class: xl65, bgcolor: #A6A6A6"]Team 7
[/TD]
[TD="class: xl65, bgcolor: #A6A6A6"]Team 8
[/TD]
[TD="class: xl65, bgcolor: #A6A6A6"]Team 9
[/TD]
[TD="class: xl65, bgcolor: #A6A6A6"]Team 10
[/TD]
[TD="class: xl65, bgcolor: #A6A6A6"]Team 11
[/TD]
[TD="class: xl65, bgcolor: #A6A6A6"]Team 12
[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"]Round 10
[/TD]
[TD="class: xl65, bgcolor: #A6A6A6"]Team 13
[/TD]
[TD="class: xl65, bgcolor: #A6A6A6"]Team 14
[/TD]
[TD="class: xl65, bgcolor: #A6A6A6"]Team 1
[/TD]
[TD="class: xl65, bgcolor: #A6A6A6"]Team 2
[/TD]
[TD="class: xl65, bgcolor: #A6A6A6"]Team 3
[/TD]
[TD="class: xl65, bgcolor: #A6A6A6"]Team 4
[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"]Round 11
[/TD]
[TD="class: xl66, bgcolor: transparent"]Team 5
[/TD]
[TD="class: xl66, bgcolor: transparent"]Team 6
[/TD]
[TD="class: xl66, bgcolor: transparent"]Team 7
[/TD]
[TD="class: xl66, bgcolor: transparent"]Team 8
[/TD]
[TD="class: xl66, bgcolor: transparent"]Team 9
[/TD]
[TD="class: xl66, bgcolor: transparent"]Team 10
[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"]Round 12
[/TD]
[TD="class: xl66, bgcolor: transparent"]Team 11
[/TD]
[TD="class: xl67, bgcolor: white"]Team 12
[/TD]
[TD="class: xl67, bgcolor: white"]Team 13
[/TD]
[TD="class: xl67, bgcolor: white"]Team 14
[/TD]
[TD="class: xl67, bgcolor: white"]Team 1
[/TD]
[TD="class: xl67, bgcolor: white"]Team 2
[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"]Round 13
[/TD]
[TD="class: xl65, bgcolor: #A6A6A6"]Team 3
[/TD]
[TD="class: xl65, bgcolor: #A6A6A6"]Team 4
[/TD]
[TD="class: xl65, bgcolor: #A6A6A6"]Team 5
[/TD]
[TD="class: xl65, bgcolor: #A6A6A6"]Team 6
[/TD]
[TD="class: xl65, bgcolor: #A6A6A6"]Team 7
[/TD]
[TD="class: xl65, bgcolor: #A6A6A6"]Team 8
[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"]Round 14
[/TD]
[TD="class: xl65, bgcolor: #A6A6A6"]Team 9
[/TD]
[TD="class: xl65, bgcolor: #A6A6A6"]Team 10
[/TD]
[TD="class: xl65, bgcolor: #A6A6A6"]Team 11
[/TD]
[TD="class: xl65, bgcolor: #A6A6A6"]Team 12
[/TD]
[TD="class: xl65, bgcolor: #A6A6A6"]Team 13
[/TD]
[TD="class: xl65, bgcolor: #A6A6A6"]Team 14
[/TD]
[/TR]
</tbody>[/TABLE]


Can this possibly be done?

 

[markmzz]

Maybe this:

Layout

[TABLE="width: 528"]
<colgroup><col width="51" style="width: 38pt; mso-width-source: userset; mso-width-alt: 1865;"> <col width="47" style="width: 35pt; mso-width-source: userset; mso-width-alt: 1718;" span="14"> <tbody>[TR]
[TD="class: xl65, width: 51, bgcolor: transparent"] [/TD]
[TD="class: xl65, width: 47, bgcolor: transparent"]Base 1[/TD]
[TD="class: xl65, width: 47, bgcolor: transparent"]Base 2[/TD]
[TD="class: xl65, width: 47, bgcolor: transparent"]Base 3[/TD]
[TD="class: xl65, width: 47, bgcolor: transparent"]Base 4[/TD]
[TD="class: xl65, width: 47, bgcolor: transparent"]Base 5[/TD]
[TD="class: xl65, width: 47, bgcolor: transparent"]Base 6[/TD]
[TD="class: xl65, width: 47, bgcolor: transparent"] [/TD]
[TD="class: xl65, width: 47, bgcolor: transparent"] [/TD]
[TD="class: xl65, width: 47, bgcolor: transparent"] [/TD]
[TD="class: xl65, width: 47, bgcolor: transparent"] [/TD]
[TD="class: xl65, width: 47, bgcolor: transparent"] [/TD]
[TD="class: xl65, width: 47, bgcolor: transparent"] [/TD]
[TD="class: xl65, width: 47, bgcolor: transparent"] [/TD]
[TD="class: xl65, width: 47, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"]Round 1[/TD]
[TD="class: xl66, bgcolor: #92D050"]Team 1[/TD]
[TD="class: xl65, bgcolor: transparent"]Team 2[/TD]
[TD="class: xl65, bgcolor: transparent"]Team 3[/TD]
[TD="class: xl65, bgcolor: transparent"]Team 4[/TD]
[TD="class: xl65, bgcolor: transparent"]Team 5[/TD]
[TD="class: xl65, bgcolor: transparent"]Team 6[/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"]Round 2[/TD]
[TD="class: xl65, bgcolor: transparent"]Team 7[/TD]
[TD="class: xl65, bgcolor: transparent"]Team 8[/TD]
[TD="class: xl65, bgcolor: transparent"]Team 9[/TD]
[TD="class: xl65, bgcolor: transparent"]Team 10[/TD]
[TD="class: xl65, bgcolor: transparent"]Team 11[/TD]
[TD="class: xl65, bgcolor: transparent"]Team 12[/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"]Round 3[/TD]
[TD="class: xl65, bgcolor: transparent"]Team 13[/TD]
[TD="class: xl65, bgcolor: transparent"]Team 14[/TD]
[TD="class: xl66, bgcolor: #92D050"]Team 1[/TD]
[TD="class: xl65, bgcolor: transparent"]Team 2[/TD]
[TD="class: xl65, bgcolor: transparent"]Team 3[/TD]
[TD="class: xl65, bgcolor: transparent"]Team 4[/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"]Round 4[/TD]
[TD="class: xl65, bgcolor: transparent"]Team 5[/TD]
[TD="class: xl65, bgcolor: transparent"]Team 6[/TD]
[TD="class: xl65, bgcolor: transparent"]Team 7[/TD]
[TD="class: xl65, bgcolor: transparent"]Team 8[/TD]
[TD="class: xl65, bgcolor: transparent"]Team 9[/TD]
[TD="class: xl65, bgcolor: transparent"]Team 10[/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"]Round 5[/TD]
[TD="class: xl65, bgcolor: transparent"]Team 11[/TD]
[TD="class: xl65, bgcolor: transparent"]Team 12[/TD]
[TD="class: xl65, bgcolor: transparent"]Team 13[/TD]
[TD="class: xl65, bgcolor: transparent"]Team 14[/TD]
[TD="class: xl66, bgcolor: #92D050"]Team 1[/TD]
[TD="class: xl65, bgcolor: transparent"]Team 2[/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"]Round 6[/TD]
[TD="class: xl65, bgcolor: transparent"]Team 3[/TD]
[TD="class: xl65, bgcolor: transparent"]Team 4[/TD]
[TD="class: xl65, bgcolor: transparent"]Team 5[/TD]
[TD="class: xl65, bgcolor: transparent"]Team 6[/TD]
[TD="class: xl65, bgcolor: transparent"]Team 7[/TD]
[TD="class: xl65, bgcolor: transparent"]Team 8[/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"]Round 7[/TD]
[TD="class: xl65, bgcolor: transparent"]Team 9[/TD]
[TD="class: xl65, bgcolor: transparent"]Team 10[/TD]
[TD="class: xl65, bgcolor: transparent"]Team 11[/TD]
[TD="class: xl65, bgcolor: transparent"]Team 12[/TD]
[TD="class: xl65, bgcolor: transparent"]Team 13[/TD]
[TD="class: xl65, bgcolor: transparent"]Team 14[/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"]Round 8[/TD]
[TD="class: xl66, bgcolor: #92D050"]Team 1[/TD]
[TD="class: xl65, bgcolor: transparent"]Team 2[/TD]
[TD="class: xl65, bgcolor: transparent"]Team 3[/TD]
[TD="class: xl65, bgcolor: transparent"]Team 4[/TD]
[TD="class: xl65, bgcolor: transparent"]Team 5[/TD]
[TD="class: xl65, bgcolor: transparent"]Team 6[/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"]Round 9[/TD]
[TD="class: xl65, bgcolor: transparent"]Team 7[/TD]
[TD="class: xl65, bgcolor: transparent"]Team 8[/TD]
[TD="class: xl65, bgcolor: transparent"]Team 9[/TD]
[TD="class: xl65, bgcolor: transparent"]Team 10[/TD]
[TD="class: xl65, bgcolor: transparent"]Team 11[/TD]
[TD="class: xl65, bgcolor: transparent"]Team 12[/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"]Round 10[/TD]
[TD="class: xl65, bgcolor: transparent"]Team 13[/TD]
[TD="class: xl65, bgcolor: transparent"]Team 14[/TD]
[TD="class: xl66, bgcolor: #92D050"]Team 1[/TD]
[TD="class: xl65, bgcolor: transparent"]Team 2[/TD]
[TD="class: xl65, bgcolor: transparent"]Team 3[/TD]
[TD="class: xl65, bgcolor: transparent"]Team 4[/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"]Round 11[/TD]
[TD="class: xl65, bgcolor: transparent"]Team 5[/TD]
[TD="class: xl65, bgcolor: transparent"]Team 6[/TD]
[TD="class: xl65, bgcolor: transparent"]Team 7[/TD]
[TD="class: xl65, bgcolor: transparent"]Team 8[/TD]
[TD="class: xl65, bgcolor: transparent"]Team 9[/TD]
[TD="class: xl65, bgcolor: transparent"]Team 10[/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"]Round 12[/TD]
[TD="class: xl65, bgcolor: transparent"]Team 11[/TD]
[TD="class: xl65, bgcolor: transparent"]Team 12[/TD]
[TD="class: xl65, bgcolor: transparent"]Team 13[/TD]
[TD="class: xl65, bgcolor: transparent"]Team 14[/TD]
[TD="class: xl66, bgcolor: #92D050"]Team 1[/TD]
[TD="class: xl65, bgcolor: transparent"]Team 2[/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"]Round 13[/TD]
[TD="class: xl65, bgcolor: transparent"]Team 3[/TD]
[TD="class: xl65, bgcolor: transparent"]Team 4[/TD]
[TD="class: xl65, bgcolor: transparent"]Team 5[/TD]
[TD="class: xl65, bgcolor: transparent"]Team 6[/TD]
[TD="class: xl65, bgcolor: transparent"]Team 7[/TD]
[TD="class: xl65, bgcolor: transparent"]Team 8[/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"]Round 14[/TD]
[TD="class: xl65, bgcolor: transparent"]Team 9[/TD]
[TD="class: xl65, bgcolor: transparent"]Team 10[/TD]
[TD="class: xl65, bgcolor: transparent"]Team 11[/TD]
[TD="class: xl65, bgcolor: transparent"]Team 12[/TD]
[TD="class: xl65, bgcolor: transparent"]Team 13[/TD]
[TD="class: xl65, bgcolor: transparent"]Team 14[/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"]**[/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl66, bgcolor: #92D050"]Team 1[/TD]
[TD="class: xl65, bgcolor: transparent"]Team 2[/TD]
[TD="class: xl65, bgcolor: transparent"]Team 3[/TD]
[TD="class: xl65, bgcolor: transparent"]Team 4[/TD]
[TD="class: xl65, bgcolor: transparent"]Team 5[/TD]
[TD="class: xl65, bgcolor: transparent"]Team 6[/TD]
[TD="class: xl65, bgcolor: transparent"]Team 7[/TD]
[TD="class: xl65, bgcolor: transparent"]Team 8[/TD]
[TD="class: xl65, bgcolor: transparent"]Team 9[/TD]
[TD="class: xl65, bgcolor: transparent"]Team 10[/TD]
[TD="class: xl65, bgcolor: transparent"]Team 11[/TD]
[TD="class: xl65, bgcolor: transparent"]Team 12[/TD]
[TD="class: xl65, bgcolor: transparent"]Team 13[/TD]
[TD="class: xl65, bgcolor: transparent"]Team 14[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: #92D050"]Team 1[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]0[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]6[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]4[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]4[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]2[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]2[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]0[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]0[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]0[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]0[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]2[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]2[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]4[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]4[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"]Team 2[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]6[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]0[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]4[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]4[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]2[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]2[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]0[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]0[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]0[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]0[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]2[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]2[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]4[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]4[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"]Team 3[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]4[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]4[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]0[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]6[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]4[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]4[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]2[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]2[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]0[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]0[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]0[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]0[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]2[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]2[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"]Team 4[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]4[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]4[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]6[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]0[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]4[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]4[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]2[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]2[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]0[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]0[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]0[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]0[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]2[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]2[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"]Team 5[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]2[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]2[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]4[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]4[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]0[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]6[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]4[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]4[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]2[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]2[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]0[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]0[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]0[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]0[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"]Team 6[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]2[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]2[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]4[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]4[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]6[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]0[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]4[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]4[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]2[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]2[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]0[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]0[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]0[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]0[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"]Team 7[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]0[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]0[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]2[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]2[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]4[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]4[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]0[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]6[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]4[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]4[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]2[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]2[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]0[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]0[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"]Team 8[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]0[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]0[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]2[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]2[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]4[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]4[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]6[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]0[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]4[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]4[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]2[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]2[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]0[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]0[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"]Team 9[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]0[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]0[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]0[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]0[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]2[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]2[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]4[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]4[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]0[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]6[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]4[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]4[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]2[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]2[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"]Team 10[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]0[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]0[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]0[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]0[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]2[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]2[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]4[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]4[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]6[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]0[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]4[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]4[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]2[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]2[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"]Team 11[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]2[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]2[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]0[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]0[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]0[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]0[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]2[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]2[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]4[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]4[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]0[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]6[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]4[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]4[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"]Team 12[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]2[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]2[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]0[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]0[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]0[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]0[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]2[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]2[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]4[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]4[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]6[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]0[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]4[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]4[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"]Team 13[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]4[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]4[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]2[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]2[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]0[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]0[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]0[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]0[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]2[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]2[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]4[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]4[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]0[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]6[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"]Team 14[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]4[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]4[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]2[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]2[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]0[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]0[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]0[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]0[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]2[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]2[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]4[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]4[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]6[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]0[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"]********[/TD]
[TD="class: xl65, bgcolor: transparent"]********[/TD]
[TD="class: xl65, bgcolor: transparent"]********[/TD]
[TD="class: xl65, bgcolor: transparent"]********[/TD]
[TD="class: xl65, bgcolor: transparent"]********[/TD]
[TD="class: xl65, bgcolor: transparent"]********[/TD]
[TD="class: xl65, bgcolor: transparent"]********[/TD]
[TD="class: xl65, bgcolor: transparent"]********[/TD]
[TD="class: xl65, bgcolor: transparent"]********[/TD]
[TD="class: xl65, bgcolor: transparent"]********[/TD]
[TD="class: xl65, bgcolor: transparent"]********[/TD]
[TD="class: xl65, bgcolor: transparent"]********[/TD]
[TD="class: xl65, bgcolor: transparent"]********[/TD]
[TD="class: xl65, bgcolor: transparent"]********[/TD]
[TD="class: xl65, bgcolor: transparent"]********[/TD]
[/TR]
</tbody>[/TABLE]


Formula

In B18

=IF($A18=B$17,0,SUM(--(MMULT(($A18=$B$2:$G$15)+(B$17=$B$2:$G$15),{1;1;1;1;1;1})=2)))

Markmzz