Need help makeing spreadsheet

Message

2005 · #1 Post by **2005** » Mon Jun 12, 2006 11:58 pm

I need to make an excel spreadsheet to this extent

I have a list of 14 (15 really but you'll see why im doing this with 14 first) people.

Each person is going to be playing in an in house pool league sponsored by the amusement business I work for (my uncle owns it).

Each person will play 2 matches every week. Each match will be 1 on 1. In a 9 week period everyone has to play everyone, and their cant be extreme repeated matchups like player 1 and 4 having played each other 4 times more then the next most common matchup.

The 15th (and odd player... it would be easy if it were an even number of players playing an even number of matches) player makes it hard. Now 2 other people from the 1st 14 have to play this guy makeing 2 of the 15 play 3 matches per week instead of 2. Which is okay as long as everyone plays him atleast once, and no extreme repeated matchups here as well.

Randomness is a good thing, and would be very nice if people dont end up playing the same people too often.

Names arnt important, once I get the general idea I can assign names to the numbers from 1-15.

mannyace · #2 Post by **mannyace** » Tue Jun 13, 2006 12:18 am

r u lookin for an explanation (math or words) to how the match ups work each week

or r u lookin for the excel commands or whatev that takes the cells for 1-15 and matches them up "automatically"

2005 · #3 Post by **2005** » Tue Jun 13, 2006 10:07 am

either

#4 Post by **palmboy5** » Tue Jun 13, 2006 4:03 pm

do you NEED two games a week, in exactly 9 weeks? well regardless, from what i interpretted, you can use this:

http://www.mylilsite.net/15people.xls

there are many ways to use this, one way that could allow randomness, is that you number each avaliable box (all below, or all above the X diagonal, or both) with a number (game number) and just keep numbering randomly and there you go, your line up

EDIT:
no wait that wont work.. XD i guess you have to purposely number diagonally from bottom left to top right first, or something like that

EDIT2:
wait! thats not enough either XD... ill give it more thought later

EDIT3:
wait.. i think the original idea works o-o

Directive · #5 Post by **Directive** » Tue Jun 13, 2006 7:08 pm

LMAO, Maybe you can try and prove your responce BEFORE posting the message LMAO

I7Iz490N · #6 Post by **I7Iz490N** » Tue Jun 13, 2006 7:31 pm

#7 Post by **palmboy5** » Tue Jun 13, 2006 8:30 pm

nah i think it works from how i got the question but lesse how off i am from what 2005 wanted

2005 · #8 Post by **2005** » Tue Jun 13, 2006 11:33 pm

Yea Ill give that a shot