I like your spreadsheet for rotating teams on multiple courts. We have a situations where we can have one to four courts available with four to forty players. We would like a spreadsheet to produce what I call a Run Sheet. We could produce a variety of sheets that we can print out and take with us when we play. Based on the number of courts and people wanting to play we could pick out the appropriate Run Sheet. Our key criteria is that no one plays a game with the same partner with a equitable distribution of sitout time when we do not have enough courts or and odd number of players.
