If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Impossible Matrix
Hi, I think I have been asked to do the impossible.
I need to write a macro that will give me a matrix of 20 names over 6 days. There will be 2 groups of 10. Each person has to be with a different person each day (in there own group) and they have to be against a different group each day with the other group also having to be with a different person each day. Not sure if anyone can help or even if Excl is the best application for it but any help would be appreciated. Regards Steve |
#2
|
|||
|
|||
Impossible Matrix
"Steve" wrote...
.... I need to write a macro that will give me a matrix of 20 names over 6 days. 20 names each day? I'll assume so. There will be 2 groups of 10. Each person has to be with a different person each day (in there own group) and they have to be against a different group each day with the other group also having to be with a different person each day. .... Excel may not be the ideal tool for this, but I can't think of anything better. It's not impossible, but it's not easy. I got as far as coming up with 9 sets of 5 pairs of letters (A-J and K-T) representing different people from each group. You'd draw 6 of the sets from the first group, then match them up with pairs from sets in the other group to get foursomes. I don't know of any way to do this other than educated trial & error. My work so far may be found in the linked workbook. ftp://members.aol.com/hrlngrv/yuck.xls |
Thread Tools | |
Display Modes | |
|
|