Hi,
I'm trying to create a schedule for my 10 team League. Matches can be played on Fridays, Saturdays or Sundays between 18:00 and 21:00 on each hour. So far I have been able to create a grid that shows Match availability based on team availabilities, and then lists all available match times for each game based on the grid.
What I'm struggling with is giving priority to teams with less availability. I have been trying to use a sum of all available times to pseudo rank the matches based on this number, however it always ends up leading to a circular formula somehow. Anyone have an idea on how to do something like this?
Cheesy
Bookmarks