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

It sounded like a fun spreadsheet to put together, I couldn't work out a way of doing it without using a macro though (all it does is generate a list of random numbers that don't repeat!)

I have attached an attempt at what you want.

The list of teams can be included by putting an 'x' next to the team name in the list (add any teams you want).

A number is randomly generated for each team included, this number defines a seating position at a table - so each team will be placed at a random position at a random table.

If you want to save it, just copy the positions and paste "As values" into the next sheet.


What it does not do is make sure the same teams don't play each other twice each week! you can just press "randomise" again though if you don't like the turnout.

Attached Files

TeamCalculator.xlsm (24.5 KB, 7 views)