League Table Spreadsheet
This spreadsheet creates a league table based on the scores that you enter.
It works for any size league up to 40 teams. (For leagues with fewer teams you merely get blank rows at the bottom).
It's very much a work in progress and I've not exhaustively dry run it so I would be very interested to hear of any bugs, or suggestions.
I should add that there are probably similar spreadsheets available that do far more that this one can but I'm not out to do a bells and whistles type thing - just create a league table!
It has the 2007/08 League Two sides entered already, but these can be replaced with any league you like. If you are looking for a spreadsheet for a Sunday league, schools league or similar then this should be perfectly sufficient.
It probably goes without saying that this is an Excel spreadsheet. See below for other spreadsheet packages.
It is a zip file which just needs to be unzipped. It is only 82KB and unzips to about 473KB. It should open in Excel 97 and later; see below for other spreadsheet packages. It does not use macros or VBA.
To download it just right-click on the link and choose "Save to Disk" or "Save Link As". Make a note of where you save it. (Firefox saves to the Desktop by default.)
It is obviously good practice to run it through an antivirus package first. Depending what antivirus you use you should be able to right-click on the file and scan it. AVG Free offers this.
If you have a utility to unzip it then this should come up on the context menu. (Windows XP comes with its own unzipping utility - if you haven't got one then do a Google, there's plenty to choose from: Winzip is the most popular, but I also found this recently, which is freeware: Zip Genius.)
This is where you enter the scores.
The table as it stands at the time of writing. "We are top of the league, we are top of the league!" (Note that teams tying on points etc are given the same position number.)
This is a screenshot of the table after games on 27 August 2005. This is a fine example of using different criteria to sort the table - and look who's top!!
This is the HTML code which can be pasted into Notepad to create a webpage of the table (instructions are provided).
This is an example of the table that is output using the HTML. Note that this has had some extra formatting added using a webpage editor.
That's it really! There's a full page of instructions to explain how it works.
If you come across any bugs, or have any suggestions, then please contact me on email@example.com
I have saved various result grids from Barnet's leagues' last few seasons. These can be downloaded and opened in Excel (or similar spreadsheet package). Simply copy and paste the results grid into the Scores Sheet. Some of the sheets also have Penalty Points for various teams so check these and enter in the appropriate place. Please email me on firstname.lastname@example.org if there are any problems.
(All are below 5KB.)
Other Result grids (Premier down to Conference, and some back to 1992/93) are available on the Soccerbase website. These can be copied and pasted into this Spreadsheet, but it's a bit of a fiddle (for various reasons). This spreadsheet makes this easier (92KB).
If you have any result grids that work in this spreadsheet then please feel free to email them to me, along with the name and year of the league and I can make them available for dowload.
Other Spreadsheet Packages
Version 9 is compatible with OpenOffice*. I do not know about any other packages; if you have successfully used it in another package please let me know so I can list it here.
* I used version 2.04 - there are newer versions.
Updates and Earlier Versions
If you find something wrong with the latest version it could be worth trying the previous version. Please let me know of any problems so I can fix it (contact details below).
Version 0.4: Fixed bug so league position shows properly; expanded width of away team colmns so that Chester doesn't get confused with Cheltenham; has League Two results up to 06 August. Download Zipfile v0.4 (38KB)
Version 0.5: Added functionality to sort by other criteria; added functionality to award different amounts of points for wins and draws (including different amounts for home or away); highlights columns on final table that have been used for sorting; added functionality to turn off individual columns when outputting to HTML; has League Two results up to 27 August. Download Zipfile v0.5 (44KB)
Version 0.6: Fixed bug so that goals against are sorted in ascending order instead of descending order; has League Two results up to 03 September. Download Zipfile v0.6 (46KB)
Version 0.7: Allows leagues where teams play each other four times; Protected cells that do not require user-updating; Fixed bug whereby leagues with fewer than 24 teams didn't display properly until each team had earned at least one point; Contains 2007/08 League Two teams but no results. Download Zipfile v0.7 (50KB)
Version 0.8: Fixed slight problem whereby #VALUE error messages were appearing (in cells that are normally hidden) when text values had been entered in the grey areas of the Scores Sheets (as these cells didn't have any dependants it wasn't actually causing a problem); Increased width of columns on scores sheets to allow for double digit scores to be visible; Created a Simple Table sheet. Download Zipfile v0.8 (54KB)
Version 0.8.1: OpenOffice only version, temporary fix as v0.8 isn't OpenOffice compatible. Download OpenOffice Zipfile v0.8.1 (40KB)
Version 0.9: Amended formula on Scores sheet that prevents zeros displaying when fewer than 24 teams: OpenOffice didn't like it (I think it's stricter than Excel, which is no bad thing); Corrected some of the HTML output; Ensured consistent shading used on rows/columns that are normally hidden; Increased number of teams it can cater for to 40 teams as I had a request to do 30; Deleted the Simple Table sheet (as I couldn't be bothered to update that one as well!) Download Zipfile v0.9 (82KB)
Version 0.9.1: Fixed bug whereby scores on the Scores2 sheet weren't being added correctly. Download Zipfile v0.9.1 (82KB)
John Snow, Website