Cross Table Dinner

Lakini

New Member
Joined
Sep 18, 2017
Messages
2
Hi guys,

maybe one of you can help me. And please apologize, I am german living in SouthAmerica, so my english is limited and I might not be able to express myself as good as I would like to ... patience please ...

I am organizing a Cross Table Dinner, you might have heard about this.

In a Cross Table Dinner, you have a 3-course dinner, you sit with 3 others and after every plate you switch the tables, in order to continue eating with other 3 people. However, the idea is, that these are always different persons and that you do not repeat anyone.

So the ideal form is:
10 tables (every table gets a number 1-10)
40 persons (every person gets a number from 1-40)
3 rounds

And every person should get a card with the tables, he is going to sit at, before the event starts.
it is more or less easy to construct this when there are really 40 people coming, especially the first two rounds. works fine, i did this a lot of times.

However, it is getting complicated now for me in my next event, because the number of participants is uncertain. It can be 32, 36, 40 or even 44. (I would always try to fill up the tables, if needed I would participate myself).

Does anyone have an idea, how I can calculate this as soon as I know the exact number of people participating? Avoiding that anyone repeats another person(number). Is there any magic formula, table, that could do the trick?
 

Some videos you may like

Excel Facts

Move date out one month or year
Use =EDATE(A2,1) for one month later. Use EDATE(A2,12) for one year later.

Eric W

MrExcel MVP
Joined
Aug 18, 2015
Messages
9,922
Welcome to the board. Or maybe, Bienvenidos! or even, Willkommen!

The problem you mention comes up now and again. It's often called the Sociable Golfer problem, because one way of stating it is setting up groups of golfers. In general there is no definite method of creating the groups, but there are techniques to come up with groups in special circumstances.

There is a web site that creates such pairings for you:

http://golfsoftware.com/tools/schedule/golf-pairings-generator.html

This is specific to golf, but I think you can probably get it to work for your situation. When you get to the generator, say that the golfers are in 5-somes. When it asks for the number of golfers, pick the number of people, or the next highest number if it's not exact. Then pick 3 events. It'll take a few minutes to run. When it's done, combine tees. Tee 1 and tee 2 = table 1, tee 3 and 4 = table 2, and so on. If the number wasn't exact, then player 45 out of a group of 44 will be an empty seat at a table.

If the number of diners is small enough, you can try using the 8-some option.

Hope this helps!
 

Watch MrExcel Video

Forum statistics

Threads
1,102,859
Messages
5,489,309
Members
407,686
Latest member
Chuck1960

This Week's Hot Topics

  • Timer in VBA - Stop, Start, Pause and Reset
    [CODE=vba][/CODE] Option Explicit Dim CmdStop As Boolean Dim Paused As Boolean Dim Start Dim TimerValue As Date Dim pausedTime As Date Sub...
  • how to updates multiple rows in muliselect listbox
    Hello everyone. I need help with below code. code is only chaning 1st row in mulitiselect list box. i know issue with code...
  • Delete Row from Table
    I am trying to delete a row from a table using VBA using a named range to find what I need to delete. My Range is finding the right cell. In the...
  • Assigning to a variable
    I have a for each block where I want to assign the value in column 5 of the found row to the variable Serv. [CODE=vba] For Each ws In...
  • Way to verify information
    Hi All, I don't know what to call this formula, and therefore can't search. I have a spreadsheet with information I want to reference...
  • Active Cell Address – Inactive Sheet
    How to use VBA to get the cell address of the active cell in an inactive worksheet and then place that cell address in a location on the current...
Top