Keith16900
New Member
- Joined
- Jun 9, 2015
- Messages
- 3
Hello,
I am an intermediate user with no VB coding experience.
I run a Tournament twice a year with a different number of players each time. The Format is simple, I List all players present in chronological order based on their ringer percent hi to low and asign a number ex (1-20). I then divide the number of players in half so 1-10 are good players and 11-20 are not as good.
I randomly generate numbers using randlotto 1-20 and seperateley randlotto 21-40 which i then write down on a chart from each list. The objective is to have only good players partnered with bad partners and not putting 2 good players together.
Example: 1,9,7,3,4,2,8,5,6,10 good players
Example: 12,14,18,20,15,19,11,16,13,17 bad players
Example:Then written 1&12 vs. 9&14 pit 1, 7&18 vs 3&20 pit 2 and so on.
I do this for 6 rounds of all players. Each player gets to play 6 games.
I have been trying for years to have excel populate all match-ups for all 6 rounds without duplicates in any round. I run into this duplicate pairings alot and duplicate players playing each other, I get many complaints from putting 2 guys together that have already been partnered and any given players playing each other in some way.
I would like to just enter the number of people who show up in a cell and have an array populate 6 -2 column groups with no duplicates. Each 2 column group would be randomly generated ,example: column 1 would be 1-10(randomized) and column 2 would be 11-20(randomized), column 3 would be 1-10 again and so on. so it reads like this;
I hope this is not confusing I appriciate any help,
Thanks,
Keith
I am an intermediate user with no VB coding experience.
I run a Tournament twice a year with a different number of players each time. The Format is simple, I List all players present in chronological order based on their ringer percent hi to low and asign a number ex (1-20). I then divide the number of players in half so 1-10 are good players and 11-20 are not as good.
I randomly generate numbers using randlotto 1-20 and seperateley randlotto 21-40 which i then write down on a chart from each list. The objective is to have only good players partnered with bad partners and not putting 2 good players together.
Example: 1,9,7,3,4,2,8,5,6,10 good players
Example: 12,14,18,20,15,19,11,16,13,17 bad players
Example:Then written 1&12 vs. 9&14 pit 1, 7&18 vs 3&20 pit 2 and so on.
I do this for 6 rounds of all players. Each player gets to play 6 games.
I have been trying for years to have excel populate all match-ups for all 6 rounds without duplicates in any round. I run into this duplicate pairings alot and duplicate players playing each other, I get many complaints from putting 2 guys together that have already been partnered and any given players playing each other in some way.
I would like to just enter the number of people who show up in a cell and have an array populate 6 -2 column groups with no duplicates. Each 2 column group would be randomly generated ,example: column 1 would be 1-10(randomized) and column 2 would be 11-20(randomized), column 3 would be 1-10 again and so on. so it reads like this;
I hope this is not confusing I appriciate any help,
Thanks,
Keith