30 couples - dine out group

lister1231

New Member
Joined
Aug 21, 2017
Messages
1
I have 30 couples meeting each month for 7 months in groups of 3 couples(10 groups).

How can they be arranged so they are always with different couples each month - no duplication?
 

Excel Facts

Excel Can Read to You
Customize Quick Access Toolbar. From All Commands, add Speak Cells or Speak Cells on Enter to QAT. Select cells. Press Speak Cells.
Welcome to the forum.

I've worked on this before, and to cut to the chase, it's a really HARD problem! :) There's no generalized way to solve problems like this, but there are iterative methods that will come up with something "close" given enough time.

Here's a link to a golfing pairing generator:

Free round robin tournament schedule / pairings generator – GolfSoftware.com

Go there, say you have 30 golfers, in 3-somes, for 7 events. It'll crank for a while, and eventually should give you the "best" pairings it can find, and show you how often the couples play each other (dine with each other).

On this particular site, it will look at up to 9999 combinations before quitting. If it finds an ideal solution, it will quit sooner. If it doesn't it'll go until it hits 9999. A quick checks shows that could be up to an hour of time. Just let it run.

Good luck!
 
Last edited:
Upvote 0

Forum statistics

Threads
1,223,891
Messages
6,175,229
Members
452,621
Latest member
Laura_PinksBTHFT

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