Automatic league tables...
...and cross-tables with rich functionality
Simple yet flexible results entry
This system permits league secretaries to set up leagues on-line. Team managers can log in and submit match results as soon as a match is over; the league table and cross-table of results are updated and displayed instantly. No more submitting results and waiting for days or weeks (or even longer) for the secretary to update the website!
The leagues displayed here are for chess matches, with up to 20 players per side playing individual games that can be either won, drawn or lost. However, the concept is simply extended to other sports.
The following chess organisations currently use this site to list their results:
This document provides some quick pointers to the functions that are available to the different classes of users:
On the home page are two lists of leagues: one for those that are currently 'in play', and one for leagues that have been completed. Click on the name of any league and you will see a page containing tables like those shown above:
There's a similar list of knock-out ('cup') competitions.
Click on any score in the cross-table and the detailed board-by-board result will be displayed, including gradings that are fetched automatically from the ECF grading database.
Click on the name of a player to display all of the stored results for that player, grouped by year and division.
A few pages of compiled data are available to logged-in users who aren't team managers. Requiring a log-in means that these pages, which take a lot of server time to generate, aren't triggered by web-crawling robots.
Below the league table (as shown in the image above) there is a link to display results summaries for a given league: number of games and points scored for each player in each team. The same listing is available by clicking the icon on the list of competitions.
On the right of a cross-table, click the icon displays summary results for all players in a particular team, Click to show a team's fixtures, if the competition secretary has uploaded them. Below the cross-table there is a link to display all fixtures for the given league.
Click on the list of competitions to list all the results in a particular competition, match by match, on a single page. This list shows the players and the result of each individual game, as well as the match result.
Click to generate CSV files containing player lists and results lists for a given legaue or cup, in the format required for 'spreadsheet' submission to the ECF. This provides a useful way to access the underlying data, for analysis or for back-up.
In addition to the above, designated team managers can use the 'log in' link to log into the site. This opens up some extra functions.
Click the 'add' link in the cross-table to add results for your own team.
A results form is displayed:
Fill in the form and click the 'submit' button. Pick player names from the drop-down lists; if a player (for either team) is missing then use one of the 'add player' buttons to add him/her to the list. If you do not manage one of the teams you will get an error message; if you do, the submitted result will be displayed for confirmation, followed by the updated league table and cross-table. The results form includes facilities to impose penalties, e.g. for playing an ineligible player, and to adjust the match result, typically to award any points scored by ineligible players to the opposing team. The actual (unadjusted) result of the game as played will appear in the playing records of the two players and in the grading output files.
The following people can submit results for a match:
Any of the team captains for a club, along with the people who are nominated contacts in the entry on the 'clubs' page, may manage that club's list of players. You can declare new players, and use the edit icon () to insert ECF grading codes or ECF membership numbers, correct spellings, delete erroneous entries and inactivate players so that they don't appear on the drop-down lists used for result entry. Reactivating an inactive player takes just one click.
The site downloads the membership ECF database and updates the member data every night. The large number of players in the database means that this is done in two parts: names beginning A-L one night, then M-Z the following night. Therefore after a membership number is input, it can take two days to pick up the status and the expiry date; before then, the player's membership will be shown as 'expired'.
You can also delete players (e.g. duplicates) using the icon. If you try to delete a player who's got results in the system you'll get a message saying that this isn't permitted. In that case,
Click on the score in the cross-table and the detailed board-by-board result will be displayed. For any result submitted by the opposing team, you will get a 'confirm' link. Confirmed results are displayed in bold type in the cross-table. Unconfirmed results are included in the points tables, but should be regarded as provisional.
Upon viewing any result that you submitted, you will get a 'delete' link. Click it to remove the result from the cross-table and from the points calculation in the league table.
Upon viewing any result submitted by the opposing team, you will get a 'confirm' link. Click this to confirm; the date confirmed and the username of the confirmer will be recorded, and the result will be displayed in bold type in the cross-table. (Unconfirmed results are included in the points tables, but should be regarded as provisional.)
There is a trial league set up to enable new users to experiment. It's in the 'Test' area and contains a team called 'Visitors'. The team manager for 'Visitors' is user 'guest'. If you log on as 'guest' with password 'welcome', you will be able to submit and delete results for the Visitors team.
If you are designated as the owner of a club's entry, you will see an 'edit' icon and a 'delete' icon in the title bar of your club's entry in the club list.
As a club owner, you can amend the stored details (name, grade code) for one of your players. You may also delete a player from your list, provided that he has not played any matches for you. You may flag as 'inactive' a player leaving your club: he or she would still be in the database, so old results would not break, but would no longer appear in your club's drop-down lists for submitting new results. Using the icon you can transfer games from one player to another, e.g. to consolidate two instances of the same player and enable the duplicate to be deleted.
As shown below, league secretaries see some extra links for competitions that they run. A set of icons alongside the name of each competition permits the secretary to:
Each league has a designated league secretary. In addition to defining the teams and their managers (see below) the secretary may also:
Alongside the league name, league secretaries see an extra link to add teams. Clicking the link displays a list of the teams that are part of that league to date, with a box to input the name of a new team.
First, create a fixtures crosstable, e.g. in Excel, and save it as Comma-Separated Variable (CSV). The teams must be in alphabetical order. Insert a dummy date or 'n/a' (which will be ignored) for the date when a team is scheduled to play against itself. In the example below, the dummy dates are shown in green but this is for clarity only: the simple CSV format ignores colours.
CSV version of above table
Athenaeum2,01-Jan-00,10-May-18,05-Oct-17,15-Feb-18,30-Nov-17,07-Dec-17,01-Feb-18 DHSS,10-Jan-18,01-Jan-00,01-Nov-17,29-Nov-17,20-Sep-17,15-Nov-17,04-Oct-17 HMC3,05-Apr-18,26-Apr-18,01-Jan-00,15-Mar-18,10-May-18,04-Jan-18,07-Dec-17 KCL2,19-Apr-18,18-Oct-17,31-Jan-18,01-Jan-00,24-Jan-18,11-Oct-17,25-Oct-17 Kings Head2,17-May-18,07-Dec-17,12-Oct-17,22-Mar-18,01-Jan-00,28-Sep-17,26-Apr-18 Pimlico4,15-Mar-18,19-Apr-18,17-May-18,09-Nov-17,18-Jan-18,01-Jan-00,10-May-18 Railsport2,20-Nov-17,14-May-18,11-Sep-17,26-Feb-18,12-Feb-18,26-Mar-18,01-Jan-00
From the list of leagues, use the 'upload fixtures' icon (highlighted yellow below) and follow instructions to upload the CSV file.
You'll get feedback to help you confirm that the team names are in the correct order and that the dates have been uploaded correctly.
If anything is wrong, or if some of the dates change mid-season, just re-upload a suitably amended file. It doesn't matter if some of the matches have already been played.
As a league secretary you may set up new usernames and passwords for team managers. It is helpful to define the team managers before adding the teams because then the manager may be picked from the existing list; otherwise you will have to go back to the team details once the manager's username has been set up, and define the manager.
League secretaries may also add and confirm results. Hence it is possible to use the WebLeagues system even if not all the team managers have web access: send the results to the secretary in the 'traditional' manner, and he can add them.
League secretaries may manage the player lists for any clubs that are affiliated to the league secretary's organisation, in the same way as team managers and club officials can.
Clicking the icon allows league secretaries to set up and send an email to the captain of each team playing in a given competition. The email can optionally be copied to the nominated contact (usually the club secretary) for the club associated with the given team. There's also an option, which can be useful when setting up a brand new competition with a new set of team captains, to include the username and password for each captain.
Generating grading files and web-pages compiling all the results for a league are now available to all logged-in users.