[RESOLVED] Data Distribution issue
 CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com

# Thread: [RESOLVED] Data Distribution issue

1. Junior Member
Join Date
Jan 2011
Posts
4

## [RESOLVED] Data Distribution issue

I'm running a tournament and I need help evenly distributing the players. I have 9 players, 3 courts, and 5 time periods. There will be 3 players per court per time period. So, the data should/can look something like this:

Time period||Court1||Court2||Court3
9am||1,2,3||4,5,6||7,8,9
9:30am||1,3,6||2,5,8||4,7,9
10am||1,4,9||2,5,7||3,6,8
10:30am||...||...||...
11am||...||...||...

A number can only be listed once per time period. No one can play in the same group of three more than once (ie group 1,2,3 can only play together in this threesome once during the tourney).

You would think that randomizing programs would make this an easy task, but it's not. Well, it's not to me at least.

Let me know if you have any questions!

Thanks!

2. ## Re: Data Distribution issue

Originally Posted by wendt80
Let me know if you have any questions!
Could it be that you have some questions? Or why else did you write this post?

Ah, and, anyway... Welcome to CodeGuru!

3. Junior Member
Join Date
Jan 2011
Posts
4

## Re: Data Distribution issue

I definitely have questions. Or rather one BIG question that I would LOVE to get answered!

4. Elite Member Power Poster
Join Date
Jan 2006
Location
Singapore
Posts
6,731

## Re: Data Distribution issue

So, what is the question? You should make an attempt first, describe what you tried, and then ask a specific question.

5. Junior Member
Join Date
Jan 2011
Posts
4

## Re: Data Distribution issue

The question is this: How can I evenly distribute these 9 players between three courts for each of the 5 time periods listed?

All 9 players must be listed for each time period.
Each threesome can only play together once during the tournament ( ie. if group 1,2,3 plays, then group 3,1,2 cannot be listed since they've already played together).
Each player must play in a group with each of the other players at least once (ex: group 1,2,3, group 1,4,5, group 1,6,7, and group 1,8,9 satisfies this criteria for player 1)

I'm not sure if the last criteria can be met with only 5 time periods available. If not, then I'll be happy with getting the closest to satifying the criteria.

I used SAS to create a dataset listing all possible 3 player combinations for the 9 players (84 different combinations total), and then I tried randomly assigning these groups to the time period/courts grid, but I could never quite satisfy the last part of my criteria.

Let me know if you need additional info.

Thanks!

6. Junior Member
Join Date
Jan 2011
Posts
4

## Re: [RESOLVED] Data Distribution issue

I found the answer in another forum.

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•

Click Here to Expand Forum to Full Width