Automate a competition draw

S

sjholmes

Is it possible to generate a random draw for a competition? Th
competion ideally would be run using multipe venues, no competitor ca
be drawn at a venue where he is a home player and some players are hom
players at more than one venue. The number of competitors varie
between 100 to 250 and there must be 8, 16 or 32 qualifiers to g
forward to final day. The number of venues used is dependant on th
number of entries received, but is never more than 16. There are 50
possible venues and each venue that is used ideally would host betwee
8 and 32 competitors. Any and all help and suggestions will b
gratefully accepted. I can usually get by using formulas but I have n
programing Knowledge at all
 
Top