Hi all,
I'm running a small dart tournament for the local club soon and I've prepared a little excel sheet (with hard codes) to handle the scheduling and results. While this works fine, I was wondering if it would be possible to have some formulas/vba code to make the whole thing a little easier (and more exciting ).Basically the conditions are as follows:
I have a list of participants (probably from 40 to 60 in total) that I list in a single column and allocate a player number.
From that list I randomly draw groups of 4 people to play a doubles match e.g Sam + Mary vs John + Sue, and each match is best of 3 legs.
Once everyone has played their matches in that round (some people may have a bye, depending on the number), I create a second round, and then a 3rd, 4th and even 5th if we have enough time.
Now here's the tricky part - no player should play WITH or AGAINST another play twice; e.g Sam should neither play with nor against Mary, John or Sue again (for as long as possible)
Currently, I simply split the players into 16 groups and have them play each other as listed in the table below, and this works fine up to 5 rounds, but it does have its limitations.
Is there an easier/more automatic way to create the unique doubles pairs to fulfil the criteria above, with formulas or code? I do have some VBA experience, but I have no idea how I would tackle this.
Looking forward to your responses.
I'm running a small dart tournament for the local club soon and I've prepared a little excel sheet (with hard codes) to handle the scheduling and results. While this works fine, I was wondering if it would be possible to have some formulas/vba code to make the whole thing a little easier (and more exciting ).Basically the conditions are as follows:
I have a list of participants (probably from 40 to 60 in total) that I list in a single column and allocate a player number.
From that list I randomly draw groups of 4 people to play a doubles match e.g Sam + Mary vs John + Sue, and each match is best of 3 legs.
Once everyone has played their matches in that round (some people may have a bye, depending on the number), I create a second round, and then a 3rd, 4th and even 5th if we have enough time.
Now here's the tricky part - no player should play WITH or AGAINST another play twice; e.g Sam should neither play with nor against Mary, John or Sue again (for as long as possible)
Currently, I simply split the players into 16 groups and have them play each other as listed in the table below, and this works fine up to 5 rounds, but it does have its limitations.
Is there an easier/more automatic way to create the unique doubles pairs to fulfil the criteria above, with formulas or code? I do have some VBA experience, but I have no idea how I would tackle this.
Looking forward to your responses.