1. If there are N people at a meeting, and each person at the meeting will have M one-on-one meetings, then I need a meeting list that tells each attendee which table they will sit at for each of their M successive meetings. Two people are assigned to meet at each table for each meeting. So, as an example, with N=124 people, M=8 meetings, there are 62 tables, and 2 people are assigned to each of the 62 tables for each of the 8 rounds of meetings.

Is there a way to generate the combinations if, for example, rows 1 to N contained names of people attending?

Playing w/it a little, it's either a set of OFFSETS or some indexing of the name column...still puzzled.

2. [quote name='kweaver' post='761151' date='24-Feb-09 17:11']If there are N people at a meeting, and each person at the meeting will have M one-on-one meetings, then I need a meeting list that tells each attendee which table they will sit at for each of their M successive meetings. Two people are assigned to meet at each table for each meeting. So, as an example, with N=124 people, M=8 meetings, there are 62 tables, and 2 people are assigned to each of the 62 tables for each of the 8 rounds of meetings.

Is there a way to generate the combinations if, for example, rows 1 to N contained names of people attending?

Playing w/it a little, it's either a set of OFFSETS or some indexing of the name column...still puzzled.[/quote]
The attached workbook provides one solution. Although there is a lack of randomness in the table, randomness can be achieved by having the participants assigned unique random numbers (1 - 124).

3. [quote name='wdwells' post='761301' date='25-Feb-09 00:45']The attached workbook provides one solution. Although there is a lack of randomness in the table, randomness can be achieved by having the participants assigned unique random numbers (1 - 124).[/quote]

This doesn't quite do it, I'm afraid. If you look at session 2, for example, table 62 has person 123 & 1 while person 1 is supposedly at table 1 with person 3. As the sessions progress, the problem increases. Can't have person 1 at two different tables at the same time.

I had a similar formula as you have, but had the same type of problem.

4. [quote name='kweaver' post='761347' date='25-Feb-09 03:46']This doesn't quite do it, I'm afraid.[/quote]
How right you are. The attached uses VBA to build the seating plan. It's a bit of brute force, but I think that it gets the job done eventually. It took about three and a half minutes on my machine.

H.T.H.

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•