Modified Round Robin Tennis Tournament

smckenzie04

New Member
Joined
Apr 30, 2015
Messages
6
I am taking over a doubles tennis tournament with a group of 12 guys we have each year and in the past they would assign everyone a card and the order picked seeds the session. The problem becomes when partners and matches repeat more than whats required, which would be playing with everyone twice and two people 3 times (11+11+2=24).
We play 3 sessions of 8 matches each, totaling 24 matches per person. I would like a way to randomly pick who each person plays with and also who you play against as much as possible.

The following picture is what I have set up so far but its simply a modified round robin schedule and the order you play with your partners doesn't vary. I would appreciate any help to make it truly random.
Screen%20Shot%202015-05-03%20at%209.33.18%20PM_zpst9ddhwhg.png
 
I'm going to revive this in an attempt to make it work now that I have more than two weeks the event.

For simplicity sake I want everyone to play WITH each person twice. I would LIKE to evenly distribute the number of times you play AGAINST each person as much as possible but that's a secondary concern at this point.
 
Upvote 0

Excel Facts

Which came first: VisiCalc or Lotus 1-2-3?
Dan Bricklin and Bob Frankston debuted VisiCalc in 1979 as a Visible Calculator. Lotus 1-2-3 debuted in the early 1980's, from Mitch Kapor.

Forum statistics

Threads
1,226,312
Messages
6,190,218
Members
453,598
Latest member
Excelnewbieneedtolearn

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top