League Generator for Odd Number Team

mknothing

New Member
Joined
Mar 29, 2025
Messages
3
Office Version
  1. 365
Platform
  1. Windows
Hello all, I am trying to create a volleyball schedule with the following parameters. but not sure if this is even possible. ChatGPT was stumped and couldn't solve this. any help would be greatly appreciated!

There are 17 teams
Games will be played once a week on wednesdays at 530 and 630 pm
4 available courts
Every night there will be two games played on each court but feel free to adjust to accommodate any adjustments given the odd number of teams, less priority to play on the outer court if we dont have enough games that night.
every team has one bye week throughout the season. can adjust if necessary
teams can only play once against each other during the 15 week season.

make sure court assignments and times of games played are balanced by team

arrange the schedule by times and by court, showing which teams are playing each other

if this is mathematically impossible, open to ideas to a more sensible format for the schedule. thank you!!!!!

 
First, ChatGPT is a large language model. It is not good at solving problems. Calling it AI is generous.

I don't understand what this means
less priority to play on the outer court if we dont have enough games that night.

You didn't say but I infer that each team plays 1 game per week, except their bye week.

Based on your setup, your courts can accommodate a total of 120 games in the season.
If each team plays 14 games (15 minus the bye week), that's 14 x 17 / 2 = 119 games. So all courts will be fully utilized except for one court will be empty for one time slot.

I don't have an automated solution yet but it certainly seems mathematically possibly to write a schedule where no team plays any other team more than once. I'm looking at a couple of possibilities.
 
Upvote 0
First, ChatGPT is a large language model. It is not good at solving problems. Calling it AI is generous.

I don't understand what this means


You didn't say but I infer that each team plays 1 game per week, except their bye week.

Based on your setup, your courts can accommodate a total of 120 games in the season.
If each team plays 14 games (15 minus the bye week), that's 14 x 17 / 2 = 119 games. So all courts will be fully utilized except for one court will be empty for one time slot.

I don't have an automated solution yet but it certainly seems mathematically possibly to write a schedule where no team plays any other team more than once. I'm looking at a couple of possibilities.
Hi there. Thank you for the help. The outer court is a court that is less favorable to play on given sunset can be blinding throughout the summer time. The comment was meant to assist with prioritizing courts.
 
Upvote 0
So it sound like it is important not only to schedule the games, but to distribute the teams around the courts in the schedule so that, for example, teams all have an equal (or close to it) number of each on the outer court. That does complicate matters.
 
Upvote 0
Rich (BB code):
So it sound like it is important not only to schedule the games, but to distribute the teams around the courts in the schedule so that, for example, teams all have an equal (or close to it) number of each on the outer court. That does complicate matters.
Yes it does but not a major priority. Any help appreciated. Thanks!
 
Upvote 0

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