Bandwidth Place 2

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.

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"

either

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

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

lol

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

Yea Ill give that a shot