473,322 Members | 1,421 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,322 software developers and data experts.

League Scheduling Algorithm or Function

Does anyone have any information related to a scheduling algorithm that
can be written in VBA and used in an access database to create balanced
team schedules for a league?

Jul 28 '06 #1
2 3880
Depends on the league. It should be fairly easy to write a function if
you have a proper weighting schedule in place.

ed********@yahoo.com wrote:
Does anyone have any information related to a scheduling algorithm that
can be written in VBA and used in an access database to create balanced
team schedules for a league?
Jul 28 '06 #2
ed********@yahoo.com wrote:
Does anyone have any information related to a scheduling algorithm that
can be written in VBA and used in an access database to create balanced
team schedules for a league?
I will be writing such an algorithm in the near future. The problem is
tougher than it looks, especially if by balancing you mean keeping the
strength of schedule fairly uniform so that teams that play stronger
teams at the beginning of the season don't have an advantage due to
handicaps. I will be doing this for pool leagues. Another factor is
that the establishments (venues) may have M tables and N teams. The
purpose of the league is to bring business into the establishment so
the schedules have to have half :-) of the scheduled matches (within
about one match) at home.

My idea is to be able to specify several kinds of constraints and
determine how many, if any, schedules meet those constraints. If
several schedules are possible, which ones are the most fair regarding
handicapping and, in the case where not all of the teams play all the
other teams, regarding the total strength of schedule? Keeping the
strength of schedule uniform usually means that teams playing tougher
matches at a particular point in the season will have some weaker
matches punctuating the schedule there also. Obviously, if the league
is just starting, there is no reference on which to base schedule
strength.

Once a schedule is chosen, Access can generate tables to store the
results. This may involve displaying K Tuesdays from a multiselect
listbox where the league operator selects the league nights for the
entire season. Pool leagues also have position rounds where the first
place team plays the second place team, etc. You also want the
database to allow the league operator to input the results on a form
similar to the form filled out by the teams. The league operators also
need to be able to enter league results out of order because of a match
being rescheduled or due to a delay in getting results. Software
developers making proposals to leagues often throw in the possibility
of putting schedules and league results on the internet. Perhaps team
captains will be able to log in and post league results through a
browser. I think this problem is going to require a fair bit of
planning.

James A. Fortune
CD********@FortuneJames.com

Jul 28 '06 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

6
by: Tony Proctor | last post by:
Hi everyone We're experiencing some serious anomalies with the scheduling of ASP threads. I'd be interested to hear if anyone knows what algorithm is used (e.g. simple round-robin, or something...
2
by: Jerry Khoo | last post by:
My problem is this: i am currently in taking OS course, and my lecturer would like us to find ways to construct a CPU algorithm such as SJF(shortest Job First), SRTF (Shortest Remaining Time...
0
by: Ahmed | last post by:
Hello everyone, I am currently in the process of building a staff scheduling program in VB .NET. I wonder if there is any good article about the approach I need to take. I have searched google...
4
by: Dinsdale | last post by:
I'm looking at adding scheduling features to an application and I wanted to ask the community about any experience with scheduling components, either open source like from code project or from a...
2
Ritchie
by: Ritchie | last post by:
Please can anyone help me with d programs in C for CPU scheduling: WAP to show FCFS scheduling algorithm. WAP to show SJF scheduling algorithm. WAP to show Priority scheduling algorithm. WAP...
1
by: rajvipinkyraja | last post by:
program in c for LOOK disk scheduling algorithm pls reply as soon as possible b'coz practical of level B DOEACC exam on 28 and 29 febuary
4
by: IanWright | last post by:
I'm just wondering if anyone could give me any starters here.... I have a need to create a simple scheduling application, that will choose from a pool of avaliable people and assign them to a...
2
by: minus | last post by:
public class Test { public static void main (String arg) { // "012345678910" alignment guide String results = {"AR 4 BR 5", "CR 0 DR 1",...
4
by: minus | last post by:
import java.util.Arrays; import java.util.Collections; public class Test { public static void main (String arg) { // "012345678910" alignment guide String ...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.