win a ball from Bowling.com

Author Topic: 7 man rotation / 5 man team  (Read 4179 times)

BeerLeague

  • Sr. Member
  • ****
  • Posts: 426
7 man rotation / 5 man team
« 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 !!!

 

Bowler19525

  • Hero Member
  • *****
  • Posts: 882
Re: 7 man rotation / 5 man team
« Reply #1 on: August 12, 2020, 02:19:42 PM »
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                                                                                                

BeerLeague

  • Sr. Member
  • ****
  • Posts: 426
Re: 7 man rotation / 5 man team
« Reply #2 on: August 12, 2020, 02:45:19 PM »
This is PERFECT .... thank you so much