In Progress

Sports Player roster

I want a dynamic spread sheet for kids sports. Users of the spreadsheet should be able to input:

The name of the team

The coaches name email and phone number

The assistant coaches name, email and phone number (if applicable)

The managers name email and phone number (if applicable)

Number to call for cancellations (if applicable)

The number of players on the team

The names of the players

The positions being played

The number of games being played

The time units being played: quarters-four units, halves two-units, periods 3 units, innings 5, 6,7, 8, 9 units)

The dates, time and location of games.

If they are delegating snack responsibility to the players for each game, whether they want to select who is responsible or just have the (this) spreadsheet select who is responsible.

The end result is a spreadsheet (aka duty roster) displaying what position each kid is playing and when, with time played and positions played equally divided between the players. If there are more players than positions then these players will be "on the bench" as alternates (Alternate 1 is the first kid to be put in if another is absent, alternate 2 is the next kid in...) Each game should show who is responsible for the snack.

The product of all this data should display similar to attached spread sheet. Note how the names cascade diagonally for the rotation of positions and how that rotation caries over to the next game. The B1, B2, and B3 is "the bench" and I would have preferred that they be to the far right of the matrix, but I could not figure out how to do it without screwing up the rotation. If you can figure out a way to do that, that would be great, I just don't want a kid sitting on the bench two time "units" in a row. If not, maybe just shade those cells...

Skills: Excel

See more: want excel spread sheet, sports it, team player, absent , two managers, snack, kids games, kids first, kid, duty roster, data matrix, b3, b2, aka, cascade select, coaches, bench, excel input sheet, able player, duty, select matrix, sports player, data sports, games player, kids product

About the Employer:
( 6 reviews ) hastings, United States

Project ID: #1109442