Random dinner party assignments

DICKAMES

New Member
Joined
Oct 1, 2011
Messages
4
I have a dinner party assignment problem similar to RandyMartin's problem (Random Group (?) Generator tonight!), posted May 2 2009 with reply by Gardnertoo posted July 2009.

Problem:
40 people
5 hosts per month
8 guests per host
4 parties per year
Goal: minimize tripple pairings.

What exactly is the formula I need?

Than you
**** Ames
 

Excel Facts

Format cells as time
Select range and press Ctrl+Shift+2 to format cells as time. (Shift 2 is the @ sign).
I am not familiar with Pivot Tables, but I have seen something very similar to your problem resolved in a Pivot Table. Explore along that avenue and consider renaming your thread to include Pivot Table help.

Hope you come right!
 
Upvote 0
Thank you Mr Scottylad2,

Sure. Our community dinner group is designed to be a mixer. Four times a year 40 people meet for dinner, eight at a house, with five houses having dinner at the same evening.

We would like a procedure for assigning people to the dinner parties such that each person has a maximum of new dinner partners over the four times per year that dinners are scheduled. There will be times when a person has dinner with someone he had dinner with at a prior party. We would like to minimize the times when one person would be at the same table with any other person three or four times over the four dinner sessions in a year.

I think there is an Excel routine that addresses this question.

Thanks

**** Ames
dickames@starstream.net
 
Upvote 0
Thank you Mr. Sezuh,

I have downloaded and unzipped the Round Robin file and will try it out.

I am very pleased with the responses to my question. Thank you.

**** Ames
Lincoln, California USA
 
Upvote 0

Forum statistics

Threads
1,213,527
Messages
6,114,144
Members
448,552
Latest member
WORKINGWITHNOLEADER

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