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
|
|||
|
|||
How do I set up a Doubles Tennis roster for 12 players?
The Idea is that all players play once with each other & the scores are
tabled showing which the best partnership/ players are - I'm stuffed ! |
#2
|
|||
|
|||
After you setup your 13 rows and 13 columns....I would use just initials for
column headings because of printing issues. You black out the ones that play against themselves which should be a diagonal across the screen. Then you will have to come up with a rating system. "AliJax" wrote: The Idea is that all players play once with each other & the scores are tabled showing which the best partnership/ players are - I'm stuffed ! |
#3
|
|||
|
|||
Colums "Player1", "Player2"," Player3 " Rows "Player1", "Player2"," Player3 " now in the cross referrence cell in the middle you put what the result or preformance grade like a x and y connection -- MDOTJR IT ------------------------------------------------------------------------ MDOTJR's Profile: http://www.excelforum.com/member.php...o&userid=27332 View this thread: http://www.excelforum.com/showthread...hreadid=468067 |
#4
|
|||
|
|||
Thanks but I may not have explained it properly.
The idea is that I have 12 players, each player is to play with each other and against another pairing. ie each week there will be 3 matches of doubles over 11 weeks therefore all players would have played as a pariring with each other & then the scores can be tablulated. But the hard thing is to get each player paired up with each other into such a way that all 11 weeks of matches are unique & no repetitions of parirings. "MDOTJR" wrote: Colums "Player1", "Player2"," Player3 " Rows "Player1", "Player2"," Player3 " now in the cross referrence cell in the middle you put what the result or preformance grade like a x and y connection -- MDOTJR IT ------------------------------------------------------------------------ MDOTJR's Profile: http://www.excelforum.com/member.php...o&userid=27332 View this thread: http://www.excelforum.com/showthread...hreadid=468067 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
set up a continuing roster? | petemack | General Discussion | 7 | August 7th, 2005 08:14 PM |
Outlook 2002 is creating doubles of all emails, how do I solve? | kfrank | General Discussion | 1 | July 8th, 2005 06:19 PM |
How can I find if there are doubles in my list of words? | Rhen | General Discussion | 3 | June 9th, 2005 05:12 AM |
OT- Need to create an 11 & 12 man Duty Roster | Gunjani | Worksheet Functions | 0 | May 20th, 2005 05:24 PM |
childrens weekly chores roster template | shanelle | General Discussion | 1 | February 21st, 2005 10:18 PM |