Issues in Chart Soccer v2.3

If you have v2.3 of the Chart Soccer spreadsheet bought from eBay, there were some issues with that version. The main issue was that the file size was around 17MB, which caused the file to take a long time to load and save and it would sometimes freeze as well. These issues have now been resolved in v2.4.

I have also created a new version of the League Position Chart, which covers two sides of an A4 sheet instead of one. This allows for larger boxes to fit the teams in than before, and is available with the new version.

If anyone would like a copy of this new version, please let me know via messaging on eBay, and I will send you the new download link. If that doesn’t work, leave me a message here and I will try and sort something out.

Alex (Midlife Geek)

E.F.U. Nations’ Cup Season 188

The E.F.U.Nations’ Cup for Season 188 has begun with the qualification rounds. These comprised ten groups of five teams, after the bottom ten countries (nos. 46-55 in the rankings) played off for a place in the competition.

The tables in the qualification rounds finished as follows, the teams in bold qualifying in 1st or 2nd place (points shown in brackets):

Group A: England (15), Denmark (15), Albania (12), Hungary (6), Cyprus (5)
Group B: Croatia (13), Scotland (13), Ukraine (13), Latvia (12), Bulgaria (7)
Group C: Finland (19), Spain (15), Northern Ireland (12), Armenia (9), Serbia (4)
Group D: France (22), Slovakia (14), Russia (12), North Macedonia (8), Faroe Islands (1)
Group E: Portugal (14), Slovenia (14), Sweden (12), Norway (9), Lithuania (5)
Group F: Netherlands (20), Kazakhstan (9), Romania (8), Luxembourg (8), Republic of Ireland (7)
Group G: Germany (16), Belarus (13), Azerbaijan (11), Austria (9), Bosnia & Herzegovina (7)
Group H: Belgium (17), Georgia (16), Turkey (12), Czechia (11), Andorra (1)
Group I: Switzerland (18), Iceland (15), Wales (14), Montenegro (7), Kosovo (4)
Group J: Italy (22), Poland (13), Greece (13), Israel (7), Estonia (3)

The eight third-placed teams with the best records played-off against each other to find the four remaining finalists:

Ukraine 1:0 – 0:2 Greece (1-2)
Turkey 1:2 – 1:4 Russia (3-5)
Albania 1:1 – 1:4 Wales (2-5)
N. Ireland 3:0 – 2:2 Sweden (3-4)

The finals will be hosted by England and the draw for the finals threw up some interesting ties, in particular England v. Scotland in the tournament opener in Group A:

Group A: England, Scotland, Germany, Belarus
Group B: Netherlands, Portugal, Greece, Slovakia
Group C: Iceland, Sweden, Slovenia, France
Group D: Georgia, Russia, Italy, Spain
Group E: Croatia, Switzerland, Finland, Wales
Group F: Poland, Belgium, Denmark, Kazakhstan

The finals will be played during the coming week, so check back here for the results.

Retro League Season 07

A new season has begun for the Retro League. This time we are covering the 1961-62 season, which was notable because newly promoted Ipswich Town, a small town club managed by the later England World Cup winning manager, Sir Alf Ramsay, won the First Division title. Can they win in the Retro League also, or will Spurs retain their title from last season?

Keep tabs on this new season here.

Update for Chart Soccer Spreadsheet

Hi all

A small bug has been identified in the Chart Soccer spreadsheet relating to penalties, specifically in the Challenge Cup First Round. This is causing the wrong team to be advanced to the next round if the original away team (i.e. the home team in the replay) wins on penalties.

I have resolved the bug and there is a new version (v2.2) available. If you want to download the new version please contact me via eBay message and I will send you the link to the new version.


European Season 184

The European competitions for Season 184 have been completed and the details can be viewed at and

This season I have added a group stage to the Euro-Cup along with transfers for certain teams from the Euro-League to the Euro-Cup as a consolation route. The eight losers in the Euro-League Play-off Round go into the Euro-Cup group stage, and the third-placed teams in the Euro-League groups go into the Euro-Cup, where they play the second-placed teams from the Euro-Cup in a preliminary knockout round. This latter setup emulates the proposed Europa League setup from 2021, with the extra round inserted between the group stage and the Round of 16.

In the Euro-League, the three English clubs were Manchester City, Chelsea and Liverpool. The latter club finished third in their group and transferred to the Euro-Cup. The other two, Manchester City and Chelsea, progressed to the knockout stages of the Euro-League and both reached the final, where City won 3—1.

The two Scottish sides, Aberdeen and Rangers, did well to finish third in their groups and therefore also moved into the Euro-Cup knockout stages. Rangers reached the Round of 16, where they were soundly beaten by Tottenham Hotspur, but Aberdeen went one better and reached the Quarter-Final, where they were narrowly beaten by West Ham United.

The Scottish clubs in the Euro-Cup were Livingston and Motherwell, who were both eliminated before the group stage. The English clubs were Brighton & Hove Albion, Tottenham Hotspur and West Ham United. Brighton were eliminated in the group stage, but the other two progressed to the knockout rounds where they were joined, as previously mentioned, by Liverpool from the Euro-League.

Liverpool were eliminated by Ajax in the Quarter-Final but the other two clubs reached the semis and another all-English final looked on the cards. Both clubs won their away matches against Ajax and Roma, but Tottenham lost by two goals at home to Roma and lost on aggregate. West Ham also lost by the same score that they had beaten Ajax with in the first leg, so the game went to extra time, where each club scored once more, and thus West Ham were knocked out on away goals, a rather cruel outcome for the East London club.

The final was contested by Ajax and Roma, and despite a valiant effort by Ajax, Roma won the match 3—2.

Chart Soccer – How I rate teams in European Competitions

I have had a few questions about how I organise my Chart Soccer competitions, so I have decided I will do some posts to explain how I do things, in the hope that others may find this interesting and useful. First, as I have been asked about this quite a lot lately, I will explain how I do my European club competitions.

So, it’s all done in a spreadsheet (of course) and in this spreadsheet I start off with a “paste sheet”, which is where I paste the raw data that will be used on the other tabs. This means that I can pull the data off of that sheet without changing it in any way. (This sheet is called “Rankings” in my spreadsheet.)

Firstly, I grab the country rankings from Bert Kassies’ excellent web site at I usually use the latest data, but as I often do more than one season every year, sometimes I go back into previous years’ data.

The important pages are the “Country Coef”, “Country Ranking” and “Club Ranking” pages. These have lists of countries by coefficient, clubs by coefficient, and the points gained by each club in each country in Europe that season. The latter is a good way of choosing your teams for your own competitions as you can pick a selection from each country – see the screenshot below.

I grab the data from the “Country Rankings” and “Club Rankings” pages, and paste them into the paste sheet.

Next I have a “Qualification” sheet. On this sheet I rank the countries according to their coefficients and allocate places in each competition based on those positions. I only allocate to the top 32 countries, to keep it manageable, although I do tweak some of the lower countries so as to include the likes of Wales and Northern Ireland, for example.

In the screenshots above, the key shows the qualification for the Champions’ League (Euro-League). For the Euro-Cup (equivalent to the Europa League but knockout only), each of the 32 countries gets two qualifiers.

Next, I have a “Ratings” sheet. This just grabs the teams I have entered onto the “Qualification” sheet and their coefficient from the “Rankings” sheet, and then sorts them into order of merit, and suitable ratings applied, usually on a scale from 1 to 8.

I can then use these rankings to do the draws, as many of these are seeded to keep the top teams apart in the earlier rounds. In the screenshot below, you can see the seedings and draw for the Preliminary Round of the Euro-League. This involves the teams highlighted in pink on the “Qualification” sheet, and as you can see I keep this colour-coding all the way through.

After each round a new seedings list is created from the winners of the previous round and any new teams joining the competition at this stage.

These seedings are applied at most stages of both competitions, apart from the knockout stages of the Euro-League. In the last 16 of the Euro-League, the teams are seeded as group winners against group runners-up, with the proviso that:

  1. Teams that qualified from the same group cannot play each other;
  2. Teams from the same country cannot play each other;
  3. The group winners are always the home team in the second leg.

From the quarter-finals onwards in the Euro-League there are no seedings and it is an open draw.

Hopefully this is of some help to those interested in how I do this. If you have any questions, please do not hesitate to ask in the comments.