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.

European Season 184

The European competitions for Season 184 have been completed and the details can be viewed at https://midlifegeek.co.uk/efu/euro_league_184.html and https://midlifegeek.co.uk/efu/euro_cup_184.html.

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 spreadsheet coming soon

Just a heads up, if you are interested in the Chart Soccer pages, in particular the A.F.L. Chart Soccer, I plan to make a spreadsheet available in Excel format that can be used to play a version of Chart Soccer. The spreadsheet will have a 20-Team Super League, a Challenge Cup (like the F.A. Cup) starting at the 64-team stage and a European Cup also starting at the 64-team stage.

What the spreadsheet will do

The spreadsheet will be able to create a fixture list into which results can be entered, and automatically create a league table, points recorder (to help determine “form” teams) and a results table. The cup competitions will allow for teams to be allocated to draw numbers, and the matches to be auto-populated based on the draw numbers entered. As results are entered, the qualifiers for the next round will be automatically generated, and will take account of replays, penalties and, for the European Cup, aggregate scores and the away goals rule.

What the spreadsheet won’t do

The spreadsheet will not be able to

  • Generate the results – Separate dice or a dice roller spreadsheet would have to be used;
  • Make draws – These would have to be done using cards, counters or some other method (there will be an explanation of how to create a random draw generator in Excel in the user guide);
  • Create data exports – This is something I may add later, but for now I’m keeping it simple. In the meantime, screen prints will of course be possible.
When will it be available

Watch this space, I will post here soon when this becomes be available and how to obtain it.