Hello all

I have a spreadsheet I am trying to build for use with my Bridge club (Excel 2007).

The spreadsheet is required to randomly select teams each week to sit in four locations around the card tables using compass references as designations, ie: North/South & East/West. There is one exception. Team 1 for North/South must remain the same each week.

There are in total 27 teams. The maximum amount of tables allowed is 11. Not all teams play each week. The minimum requirement for a game to occur is 6 teams/3 tables.

I would like to keep a record of which teams played and which positions. Shifting teams around to different compass directions is an important aspect.


Is this possible or should I simply put names on paper and pull them out of a hat...

Thanks

David