Help to Create Matrix table.?
Good afternoon,
would you please help me to create 21 persons matrix showing 10 weeks for pocker game,each table will consist of 3 player,each player need to play each other player
only onceand ech player to play one game a week.
I would appreciate any help,thank you.
Hi sem,
I'm confused (not abnormal). You say each player against each other player but each table has 3 players. How does that work exactly. Does the thrid player watch as the other two play against each other? So there are 3 head on head games at each table?
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
thanks for help Marvin,
yes each table will consist of 3 player thatmean there are 7 table all together
each other player out 21 people for ex; in week1, if first 3 people sit in table1HTML Code:
they should not sit in any other table again together ,and this is valid for all 21 people.
appreciate your help thank you.
1 week Table1 table 2 Table3 Table4 Table5 Table6 Table7 1 4 7 10 13 16 19 2 5 8 11 14 17 20 3 6 9 12 15 18 21 2 Week 1 2 3
Re: Help to Create Matrix table.?
Good evening,
may i ask for your help again,please?
Thank you
Not much of a gamester but does this help? Maybe some one else can dress it up for you.
Ben Van Johnson
Ok sem,
After I read this question a few more times I think I have a possible answer. You want to minimize the number of times two players sit together in a game. There is no guarentee that you can construct a 10 week scheme where there will not be the same players. Find the attached where I do random selections of players at tables. Then look at the table to the right and see how many times each player plays with other players. If you can get no 3 times you will have a perfect sorting.
Hope this helps.
Re: Help to Create Matrix table.?
good evening,thanks to Marvin and ProtonLeah for your effort and suggestions
unfortunately not correct result,because you can not keep randomising maybe at the begining but after that any two of three in that table should not sit together again.
here is an example with 9 players i have done for illustration.
please accept my apologies for all this trouble.
sem
I found this published result for 7 groups of 3 players for 9 weeks:
That's 189 of 210 pairings with no repeats.-G- -H- -I- -J- -K- 4 Rnd Grp P1 P2 P3 5 1 1 0 1 2 6 1 2 3 4 5 7 1 3 6 7 8 8 1 4 9 10 11 9 1 5 12 13 14 10 1 6 15 16 17 11 1 7 18 19 20 12 2 1 0 3 6 13 2 2 1 9 12 14 2 3 2 15 18 15 2 4 4 7 10 16 2 5 5 13 16 17 2 6 8 11 19 18 2 7 14 17 20 19 3 1 0 4 8 20 3 2 1 13 15 21 3 3 2 9 20 22 3 4 3 7 11 23 3 5 5 10 18 24 3 6 6 14 16 25 3 7 12 17 19 26 4 1 0 7 13 27 4 2 1 4 17 28 4 3 2 8 16 29 4 4 3 12 20 30 4 5 5 9 19 31 4 6 6 11 18 32 4 7 10 14 15 33 5 1 0 5 11 34 5 2 1 8 14 35 5 3 2 7 12 36 5 4 3 13 18 37 5 5 4 15 20 38 5 6 6 9 17 39 5 7 10 16 19 40 6 1 0 10 12 41 6 2 1 5 6 42 6 3 2 11 17 43 6 4 3 14 19 44 6 5 4 16 18 45 6 6 7 9 15 46 6 7 8 13 20 47 7 1 0 15 19 48 7 2 1 11 20 49 7 3 2 4 6 50 7 4 3 9 16 51 7 5 5 8 12 52 7 6 7 14 18 53 7 7 10 13 17 54 8 1 0 16 20 55 8 2 1 3 10 56 8 3 2 13 19 57 8 4 4 11 14 58 8 5 5 7 17 59 8 6 6 12 15 60 8 7 8 9 18 61 9 1 0 17 18 62 9 2 1 7 19 63 9 3 2 5 14 64 9 4 3 8 15 65 9 5 4 9 13 66 9 6 6 10 20 67 9 7 11 12 16
Last edited by shg; 07-18-2011 at 07:31 PM.
Entia non sunt multiplicanda sine necessitate
Re: Help to Create Matrix table.?
Good evening,
Shg thanks very much for your solution i also found the full solution but with letters instead of numbers.Without your help i do not think i would have found it,i'm very greatful
See attachment for result
sem
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks