I have an upcoming meeting where I will need to assign participants to
workshops in smaller groups. This appears to be nothing more than a
logic question involving a matrix...but I can't quite 'get' it. The
details are as follows:

1. Our meeting will have 100 participants
2. There will be 8 sessions, each 15 minutes long (the duration is irrevelant)
3. During each session, there will be 11 stations where the 100
participants will be divided as evenly as possible (most nine to a
group with one at ten)
4. Because there are only 8 sessions with 11 stations, every person
will not make it to every station (each person will not make it to
three stations...this is OK)
5. Each person cannot attend the same station more than once
6. Each person can attend only one station during the same session (of course)
7. TRICK - we don't simply want the same groups to move from station
to station (otherwise, we could solve this in five minutes). We want
the makeup of each group to change so that different people are
intermingled. The goal is to have as much intermingling as possible.

The complexity of this problem is to intermingle the groups (change
the makeup of the groups during each session) while not having any one
person attend the same station twice (or the same station during the
same sesion). Each group should have 9 people (one group may need to
have 10 people which is OK). Ideally, throughout all sessions, no two
groups (of nine or ten) would have the same makeup (if mathematically
possible).

I would like for the solution to be in an excel spreadsheet with
numbers 1-100 representing the attendees. Column "A" would show the
eight sessions, and columns B-L would represent the 11 stations. Also
acceptable would be a short executable program that would randomly
generate assignments based upon the criteria above (VBA? Other?). As
long as I can get the results to Excel (or text file) then it's fine.

Thanks in advance.