Rotate squad for darts team excel generator

Problem: Have a squad of 8 players in my darts side. We have 12 games in our season and each game requires 4 players so each player will play 6 games. 6 of these games are at home and 6 are away.

I want to create an excel sheet whereby a team will be picked for each match. Each player will play at Home and Away 3 times each. And the same group of players will not play with the other players each time.

eg. Week 1- Team Players, 1, 2, 3, 4
Week 2 - Team Players 5,6,7,8
Week 3 - 1,3,5,7
Week 4 - 2, 4, 6, 8 etc.

Any ideas where to start. There are multiple variables.

I'd suggest just make a list that works for you and then assign the players to player numbers. For example:

Please Login or Register  to view this content.

Then randomise which player is number 1, 2, 3 etc.