Hello,
I'm looking for some vba-code that generates a schedule of dartmatches to be played.
I have a vba-code that creates all possible matches to play each other:
The code is working well, but what I want is that the matches will be generated like this:Please Login or Register to view this content.
As you can see are the first two games player 1 - player 2 and player 8 - player 9. Player 6 and player 7 are the markers and so on. Within 1 match there are 3 players involved.Please Login or Register to view this content.
I'm looking for a vba-code that generates the matches and the players that has to mark. The matches needs to played on two courts, so a player cannot play two matches at the same time.
I've to to this manually, but maybe there is some code that generates this.
There are 9 players. Totally there needs 72 matches to be played. Each player plays two games against each other and has to mark 8 matches.
Bookmarks