I am coaching a youth soccer team. We have 6 positions on the field: Goalkeeper, 2 fullbacks and 3 fwds. The game is split in to 4 quarters with a stopping point halfway between each quarter to substitute players. The Goalkeeper will play the entire quarter with the other positions rotating at each quarter and halfway point in the quarter.
I have 9 kids on the roster and am looking for a formula which will rotate the field players evenly on every rotation as well as the goalkeeper staying in for two consecutive rotations then getting back into normal rotation after they have played this position. SO it should always have 3 players on the bench and never sitting out more than one "half quarter" at a time.
Example:
1st quarter: player 1-GK, 2-LF, 3-RF, 4-RW, 5-C, 6-LW.
Midway of 1st: 1-GK, 7-LF, 8-RF, 9-RW, 3-C,4-LW
2nd quarter: 2-GK, 5-LF, 6-RF,.............
If possible, it would also be able to change each game, so that the same three players dont start out on bench every game.
Also, there will be games when all 9 players do not show up, so it will have to be based on players who show up for each game.
As a bonus, would it be possible to create a sheet as shown here soccer rotation | Flickr - Photo Sharing! (with 8 fields) and have it poplulated with the data created?
Any and all help is greatly appreciated. Thanks in advance.
I have 9 kids on the roster and am looking for a formula which will rotate the field players evenly on every rotation as well as the goalkeeper staying in for two consecutive rotations then getting back into normal rotation after they have played this position. SO it should always have 3 players on the bench and never sitting out more than one "half quarter" at a time.
Example:
1st quarter: player 1-GK, 2-LF, 3-RF, 4-RW, 5-C, 6-LW.
Midway of 1st: 1-GK, 7-LF, 8-RF, 9-RW, 3-C,4-LW
2nd quarter: 2-GK, 5-LF, 6-RF,.............
If possible, it would also be able to change each game, so that the same three players dont start out on bench every game.
Also, there will be games when all 9 players do not show up, so it will have to be based on players who show up for each game.
As a bonus, would it be possible to create a sheet as shown here soccer rotation | Flickr - Photo Sharing! (with 8 fields) and have it poplulated with the data created?
Any and all help is greatly appreciated. Thanks in advance.