schedule generator 2 game per day (darts)

kerm007

New Member
Joined
Mar 16, 2019
Messages
43
Office Version
  1. 365
Platform
  1. Windows
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
 

Some videos you may like

Excel Facts

Format cells as date
Select range and press Ctrl+Shift+3 to format cells as date. (Shift 3 is the # sign which sort of looks like a small calendar).

kerm007

New Member
Joined
Mar 16, 2019
Messages
43
Office Version
  1. 365
Platform
  1. Windows
ok i enter this in the macro side of excel
 

kerm007

New Member
Joined
Mar 16, 2019
Messages
43
Office Version
  1. 365
Platform
  1. Windows
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

Well-known Member
Joined
Nov 9, 2002
Messages
2,506

ADVERTISEMENT

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

New Member
Joined
Mar 16, 2019
Messages
43
Office Version
  1. 365
Platform
  1. Windows
when i enter 13 i get to many game entered
do i have to change something in the code ?
Thanks
 

NdNoviceHlp

Well-known Member
Joined
Nov 9, 2002
Messages
2,506
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
 

Watch MrExcel Video

Forum statistics

Threads
1,109,201
Messages
5,527,383
Members
409,759
Latest member
KCH

This Week's Hot Topics

Top