Release 2 Completed

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, a positive.

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.

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.

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.

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.
The reporting facilities that the team developed in Release 2 are:

1. CT Rank and Handicap List
2. Performance of LISTED/ALL Players
3. Club Handicap List
4. Individual Player Report
5. Review List of Players (3 Reports)
6. Recently Entered Scores
7. Address/Phone Listing
8. Honours List of Players

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.

An authenticated user is able to generate a Performance of Listed Players Report.

An authenticated user is able to generate a Performance of Listed Players Report.

There are three reports under the Review List of Players. Their purpose is to help the administration with the Handicap calculations.

• 15 games in 24 months
  

  This report displays all the players who are not on National ranking and have played 15 games in the last 24 months on their present CT handicap.

  
  
• 10 to 14 games, 60% won in 24 months
  

  This report displays all the players who are not on National ranking and have played 10 to 14 games in the last 24 months on their present handicap.

  
  
• 6 to 9 games 80% won in 24 months
  

  This report displays all the players who are not on National ranking and have played 6 to 9 games in the last 24 months on their present handicap.

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.