Right now I have a sports league with 12 teams that will play for 13 weeks. I'd like to set up league schedule where each team plays each other at least once. Is there something that can help me?
Right now I have a sports league with 12 teams that will play for 13 weeks. I'd like to set up league schedule where each team plays each other at least once. Is there something that can help me?
Over 11 weeks it would be as below. Don't know what you would want to do for the extra 2 weeks
.
ROUND 1 FIXTURES
TEAM 2 v TEAM 1
TEAM 8 v TEAM 6
TEAM 9 v TEAM 5
TEAM 10 v TEAM 4
TEAM 11 v TEAM 3
TEAM 12 v TEAM 7
ROUND 2 FIXTURES
TEAM 3 v TEAM 1
TEAM 8 v TEAM 7
TEAM 9 v TEAM 6
TEAM 10 v TEAM 5
TEAM 11 v TEAM 4
TEAM 12 v TEAM 2
ROUND 3 FIXTURES
TEAM 3 v TEAM 2
TEAM 4 v TEAM 1
TEAM 9 v TEAM 7
TEAM 10 v TEAM 6
TEAM 11 v TEAM 5
TEAM 12 v TEAM 8
ROUND 4 FIXTURES
TEAM 4 v TEAM 2
TEAM 5 v TEAM 1
TEAM 9 v TEAM 8
TEAM 10 v TEAM 7
TEAM 11 v TEAM 6
TEAM 12 v TEAM 3
ROUND 5 FIXTURES
TEAM 4 v TEAM 3
TEAM 5 v TEAM 2
TEAM 6 v TEAM 1
TEAM 10 v TEAM 8
TEAM 11 v TEAM 7
TEAM 12 v TEAM 9
ROUND 6 FIXTURES
TEAM 5 v TEAM 3
TEAM 6 v TEAM 2
TEAM 7 v TEAM 1
TEAM 10 v TEAM 9
TEAM 11 v TEAM 8
TEAM 12 v TEAM 4
ROUND 7 FIXTURES
TEAM 5 v TEAM 4
TEAM 6 v TEAM 3
TEAM 7 v TEAM 2
TEAM 8 v TEAM 1
TEAM 11 v TEAM 9
TEAM 12 v TEAM 10
ROUND 8 FIXTURES
TEAM 6 v TEAM 4
TEAM 7 v TEAM 3
TEAM 8 v TEAM 2
TEAM 9 v TEAM 1
TEAM 11 v TEAM 10
TEAM 12 v TEAM 5
ROUND 9 FIXTURES
TEAM 6 v TEAM 5
TEAM 7 v TEAM 4
TEAM 8 v TEAM 3
TEAM 9 v TEAM 2
TEAM 10 v TEAM 1
TEAM 12 v TEAM 11
ROUND 10 FIXTURES
TEAM 7 v TEAM 5
TEAM 8 v TEAM 4
TEAM 9 v TEAM 3
TEAM 10 v TEAM 2
TEAM 11 v TEAM 1
TEAM 12 v TEAM 6
ROUND 11 FIXTURES
TEAM 7 v TEAM 6
TEAM 8 v TEAM 5
TEAM 9 v TEAM 4
TEAM 10 v TEAM 3
TEAM 11 v TEAM 2
TEAM 12 v TEAM 1
If my solution worked (or not) please let me know. If your question is answered then please remember to mark it solved
Computers are like air conditioners. They work fine until you start opening windows. ~Author Unknown
There's a workbook that does round-robin scheduling at https://www.box.com/s/z41sn0yrp5lo1cuozke3
As WasWodge says, you can repeat any of the first 11 rounds for the last two.
Entia non sunt multiplicanda sine necessitate
I use Cad Delworth's fixture list generator for a few leagues at work. The advantage is you can type the names straight in.
Hey Thanks a lot for the schedule generator. I needed a something for our Bar Pool League, works great. THANKS!
hello
im runing a darts league and wondering how to do a schedule
we use 7 boards and we play twice each tuesday and we will play 4 to 6 times each teams
can any one help me create a schedule with random board also
thanks
@kerm007
Administrative Note:
Welcome to the forum.
We are happy to help, however whilst you feel your request is similar to this thread, experience has shown that things soon get confusing when answers refer to particular cells/ranges/sheets which are unique to your post and not relevant to the original. Please start a new thread - See Forum rule #4
If you are not familiar with how to start a new thread see the FAQ: How to start a new thread
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks