Gordo
Footballguy
Any thoughts on how to do this?
This is a company "Team Building" thinng where people are supposed to get to know people from different departments.
Bean Bag (Cornhole) League
12 people per league
Want each person to play with every other person as a team once (so 11 games per person) - that's the easy part
so 3 matches per week:
My difficulty is in making the actual schedule when the teams are different each week.
Week 1
AB vs CD
EF vs GH
IJ vs KL
Week 2
AL vs BK
CJ vs DI
EH vs FG and so on...
I tried just working it out with paper and pencil, but only made it to week 8 before i got conflicts.
Any help? Any Excel formulas for this?
This is a company "Team Building" thinng where people are supposed to get to know people from different departments.
Bean Bag (Cornhole) League
12 people per league
Want each person to play with every other person as a team once (so 11 games per person) - that's the easy part
so 3 matches per week:
My difficulty is in making the actual schedule when the teams are different each week.
Week 1
AB vs CD
EF vs GH
IJ vs KL
Week 2
AL vs BK
CJ vs DI
EH vs FG and so on...
I tried just working it out with paper and pencil, but only made it to week 8 before i got conflicts.
Any help? Any Excel formulas for this?
Last edited by a moderator:
