Results 1 to 4 of 4

Thread: combinations

  1. #1
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    La Jolla, CA
    Posts
    1,470
    Thanks
    30
    Thanked 62 Times in 58 Posts
    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. #2
    Silver Lounger
    Join Date
    Jul 2001
    Location
    Ottawa, Ontario, Canada
    Posts
    1,609
    Thanks
    0
    Thanked 1 Time in 1 Post
    [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).
    Attached Files Attached Files
    Regards
    Don

  3. #3
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    La Jolla, CA
    Posts
    1,470
    Thanks
    30
    Thanked 62 Times in 58 Posts
    [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. #4
    Silver Lounger
    Join Date
    Jul 2001
    Location
    Ottawa, Ontario, Canada
    Posts
    1,609
    Thanks
    0
    Thanked 1 Time in 1 Post
    [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.
    Attached Files Attached Files
    Regards
    Don

Posting Permissions

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