help with league schedule formulas

[jim]

I do all the league sheets for a racquetball league.

I have formulas and procedures to accommodate our leagues until now....

We lost a couple courts....

The facts are:
1. the league runs one day a week.
2. we now have 21 players (players without a match get a "BYE")
3. we now have just 8 courts. each week additional players will need to have
a "BYE" if a court is not available
4. all players must play each other player once.

My old formula and procedure follows.
***********here***********
If odd number of players
1st match (top left cell) is = number of players ( D6 on my sheets )
formula for all other cells in 1st row is:
=IF(+D6-1=$A6,"Bye",+D6-1)

formula for all other cells is:

=IF(D6="Bye",+D5-2,IF(IF(+D6-<1,$D$6,+D6-1)=$A7,"Bye",IF(+D6-1<1,$D$6,+D6-1)
))
except last match for player 2 cell = number of players
*********to here*****************
I have attached a copy of the excel spreadsheet for 21 players - unlimited
courts.

I need a formula or procedure that will provide multiple "BYE"s each week
due to shortage of courts and schedule those matches later....

Thanks for any help provided....