Release 2 CompletedCalculating Merit Points and handicap
After each game is entered into the database (manually or from a
text file of game results), the software calculates the merit points of each
player for each game and stores them in the database.
For levels games it does this by retrieving both players’ handicaps
and scores and then working out the expected score for the higher handicapped
player (the lower handicapped player is expected to win with the maximum
score of 26 points). The expected score is compared to the actual score of
the higher handicapped player and merit points are assigned to each player
from the formulae developed by our client.
Merit points for handicap games are half the difference between
the two scores with the loser having a negative figure recorded, the winner,
The program will also automatically calculate the suggested handicap according to the mathematical formula and store it separately from the current handicap in the database. The calculation will only use the average merit points of a players most recent 15 games.
Changing a Players Handicap
Every six months a player’s handicap is evaluated. If the evaluation produces a new handicap, the administrator can use the interface to manually type the new handicap in the text box provided. The software will store this new handicap in the database.
Correcting Game Scores
The administrator has facilities to edit previously entered game data. These changes are then be updated in the database, and any handicaps and merit points recalculated.
The data out of the existing Croquet system (written in Visual dBASE) has been transferred into the new system. Visual dBASE’s export facility was used to create series of delimited text files containing the data from the existing system. These text files were then be imported into the database using SQL statements.
Entering Game Data
There is an option to enter Game Data into the system manually as well as the ability to automatically insert Game Data into the system from a text file, including previewing the contents of the text file first. The system automatically allocates a Game ID number to each new game.
Selecting the Game Data manual entry option from the system menu
brings up a data entry form with fields for all the required information.
The text files will be located in a specific directory. After
choosing the Loading Game Data Text File menu option, a screen allowing you
to choose a text file will appear.
Once a text file is chosen the contents will be displayed allowing the user to check the validity of the Game Data. The contents can then be saved to the database or rejected and not saved. There will be options to choose another text file or return to the Main Menu.
The interface was implemented. The administrator can use it to add a new Club. The administrator has the option to delete or rename existing Clubs.
The interface was implemented. The administrator can use it to add new Honours. The administrator has the option to rename existing Honours.
The system contains a facility for an administrator to add or modify the types of events stored in the database.
An authenticated user is able to export each of the Database tables as a comma separated text file. The user is also able to choose which directory the files will be saved to.
All the reports from the existing system were replicated in the
new system. The administrator can choose the required report from the menu
system The report will be generated from the database and displayed on-screen.
The report can then be printed or emailed using the web browser.
CT Rank and Handicap List Report
The CT Rank and Handicap List Report is generated from the results of approved competition single games, both levels and handicap. Players are listed when a minimum of 15 games have been played the last 24 months. The operator has the option of adjusting these numbers.
Performance of Listed Players Report
An authenticated user is able to generate a Performance of Listed Players Report.
Performance of All Players Report
An authenticated user is able to generate a Performance of Listed
An authenticated user is able to generate a list of players belonging to a particular club.
Individual Player List
An authenticated user is able to generate an Individual Player List report.
Review List of Players Reports
There are three reports under the Review List of Players. Their purpose is to help the administration with the Handicap calculations.
Recently Entered Scores Report
An authenticated user is able to generate a Recently Entered Scores Report.
Address / Phone Listing Report
An authenticated user is able to generate an Address / Phone Listing Report with a choice of players grouped by club, suburb and state and type of players including competition, non-competition, active or inactive player types.
Honours List of Players Report
The Honours List of Players Report is generated from the Honours entry data stored in the database. The operator has the option to select the type of event and the period of time during which the honours were awarded.
image courtesy www.croquet.com