Networking Seating Chart weekly rotation

[Roger Eastwood]

We are doing a 12 week event with 37 people and have 6 tables for the roation. So 5 tables of six people and 1 table of seven.
Wanted to do a weekly roation each week that gives the each person the best chance to sit with as many different people as possible.
Didnt know if there was a way excel to set this up. Thanks for any advice.

 

[iggydarsa]

Not sure if there is a way to do it with formulas but if you are familiar with VBA you can use this code.

First prepare your sheet like this:
Starting form B1 to M1 name the weeks side by side on the first row (Wk1 - Wk2 - Wk3 etc.)
Starting on A2 put the names of the people from A2 to A38

then run this code:

Sub TableAssignment()
    jump = 6
    For c = 2 To 13
        r = 2
        For tbl = 1 To 6
            For i = 1 To 6
                Cells(r, c).Value = tbl
                If (r + jump) < 39 Then r = (r + jump) Else: r = (r + jump) Mod 39 + 2
            Next i
        Next tbl
        jump = jump + 1
    Next c
    For Each cl In Range("B2:M38")
        If cl.Value = "" Then cl.Value = 6
    Next cl
End Sub

this will spit out numbers from 1 to 6 which indicates the table number.

Not saying it is the best combination but this is the best I could come up with.

Good luck