BallReviews
General Category => Miscellaneous => Topic started by: BeerLeague on August 12, 2020, 12:19:13 PM
-
does anyone out there have a spreadsheet or something that they would be willing to share to generate a schedule for a 7 man roster on a 5 man team?
THANKS IN ADVANCE !!!
-
If a 33 week league and you want everyone to have as equal a time as possible to participate, you could do something like this I suppose:
Bowler 1 6 4 2 7 5 3 1 6 4 2 7 5 3 1 6 4 2 7 5 3 1 6 4 2 7 5 3 1 6 4 2 7
Bowler 2 7 5 3 1 6 4 2 7 5 3 1 6 4 2 7 5 3 1 6 4 2 7 5 3 1 6 4 2 7 5 3 1
Bowler 3 1 6 4 2 7 5 3 1 6 4 2 7 5 3 1 6 4 2 7 5 3 1 6 4 2 7 5 3 1 6 4 2
Bowler 4 2 7 5 3 1 6 4 2 7 5 3 1 6 4 2 7 5 3 1 6 4 2 7 5 3 1 6 4 2 7 5 3
Bowler 5 3 1 6 4 2 7 5 3 1 6 4 2 7 5 3 1 6 4 2 7 5 3 1 6 4 2 7 5 3 1 6 4
Sits Out 6 4 2 7 5 3 1 6 4 2 7 5 3 1 6 4 2 7 5 3 1 6 4 2 7 5 3 1 6 4 2 7 5
Sits Out 7 5 3 1 6 4 2 7 5 3 1 6 4 2 7 5 3 1 6 4 2 7 5 3 1 6 4 2 7 5 3 1 6
How many times do they bowl
Bowler 1 24
Bowler 2 24
Bowler 3 24
Bowler 4 24
Bowler 5 23
Bowler 6 23
Bowler 7 23
How many times do they sit out
Bowler 1 9
Bowler 2 9
Bowler 3 9
Bowler 4 9
Bowler 5 10
Bowler 6 10
Bowler 7 10
-
This is PERFECT .... thank you so much