schedule generator 2 game per day (darts)

[kerm007]

hello
im looking for a fixture creator for playing on the season 4 to 5 time each teams and we are playing against 2 teams each tuesday the number of team can also change from 12 to 14

can anyone help me ?

Regards

 

[NdNoviceHlp]

https://www.mrexcel.com/forum/excel-questions/1038895-round-robin.html
HTH. Dave

 

[kerm007]

ok i enter this in the macro side of excel

 

[kerm007]

hello i was able to run the formula but it doesn't do what i want it ask me the number of round robin i put 50 and it failed i wan to get a fixtures (shedule) for the season and we can play as much as 4 to 5 time against each teams and on every night we play twice once against a team and then after another team

 

[NdNoviceHlp]

A round robin has each team playing each other only once. If you have 14 teams that need to play each other 4 times then you could enter 13 games to create the 1st quarter schedule. Then repeat 3 more times for the remaining quarters (each team will play all other teams 4 times). HTH. Dave

 

[kerm007]

when i enter 13 i get to many game entered
do i have to change something in the code ?
Thanks

 

[NdNoviceHlp]

If U have 14 teams, place "list of names/teams in sheet1 A1 to A whatever" (A14 in this for instance) then run the macro and enter 13. Dave

 

[kerm007]

thanks