Radomised Seater Chart

[tassietiger]

Hi everyone,

looking for a radomised seating chart where everyone moves tables - 20 people - 5 tables - 5 rotations
No one sits together more than once. But everyone gets to see each other once.
Is this possible?

Thanks

 

[Macropod]

It seems you've asked about this before and received a reply: https://www.mrexcel.com/forum/excel...ed-seating-chart-post5153358.html#post5153358
As you were advised there:

This problem is sufficiently interesting and difficult that it has its own name: the Social Golfer Problem.

There are no general solutions, but there's plenty of material out there, including on this site, if you care to google the term.

Did you do the suggested search?

 

[AhoyNC]

Here is a link to a web site that will break down a seating chart for you. Just think of golf pairings as tables and events.
http://golfsoftware.com/tools/schedule/golf-pairings-generator.html