HI,
I use excel for a rotation plan for tennis groups, but it really is
just the table format that I use, beyond letting excel compute the
weekly dates. Your point 1, booking date, is selfevident. If you
want, you can start with the first booking date, a week before play
starts. The booking persons have to be defined after the rotation
plan is settled.
I have the dates running across, and the names of the players listed
in the first column. Maybe a real whiz at excel can tell you how to
let it compute what you want, but I expect that it will be faster to
do it by pencil. Pushing the cursor around is slower, so print the
table and start:
You have four teams: AA BB CC DD, and two players with byes. I would
start by crossing off the fields for the byes, say, the first and
fifth players, then the 2nd and 6th and so on, just for four weeks,
because those pairs will have to be changed to let them play with
everyone.
And then just go to work with your pencil, entering letters for the teams.
You'll soon learn why an eraser is faster than the cursor ...
When you think it is finished, enter the results in the excel table,
which makes it easier to check.
When it is correct, then you can easily define the persons to book,
maybe the persons playing after they have had a bye, but take care
that the task is evenly shared, but that should be easy. By now, you
may be happy to just circle the team letter and have a note that the
circle indicates who must book for the next week, but you can type
this in the field with the letter: " A book".
The result looks impressive. You can even underlay the rows of
alternate players in color to make it easier for players to identify
their row.
And when it's all perfect, the first guy you hand it to is going to
say: "Oh, but I can't play that day!" Tough luck. You have a
comment at the bottom of the page saying that every player is
responsible for finding his own substitute, (and, if necessary for the
booking, to advise the booker a week in advance).
An excel table with names and eleven columns will fit on a vertical
sheet, so you will have space at the top for a nice heading and at the
bottom for names and telephone no.s of the players, and your rule
about substitutes, or that the booker advises if play is canceled.
Oh, yes: check with the club about tournaments. Include the date in
your schedule with byes for all.
And now I hope someone can tell how to let excel handle the task. |
