schedule generator 2 game per day (darts)

kerm007

Board Regular
Joined
Mar 16, 2019
Messages
248
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
 

Excel Facts

Round to nearest half hour?
Use =MROUND(A2,"0:30") to round to nearest half hour. Use =CEILING(A2,"0:30") to round to next half hour.
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
 
Upvote 0
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
 
Upvote 0
when i enter 13 i get to many game entered
do i have to change something in the code ?
Thanks
 
Upvote 0
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
 
Upvote 0

Forum statistics

Threads
1,213,543
Messages
6,114,236
Members
448,555
Latest member
RobertJones1986

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top