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 https://kassiesa.net/uefa/. 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.

Alex

9 thoughts on “Chart Soccer – How I rate teams in European Competitions”

  1. Hi Alex
    Just to say it looks like a tremendous amount of thought and work has gone into developing the process for the European competition’s side of things. Kudos to you and love the layout of the actual fixtures!

  2. Hi Alex

    You’ve obviously put in a tremendous amount of thought and work into the process for your European competitions. Kudos to you and love the layout for the fixtures. Thanks for sharing.

    1. Thanks very much. It started off as just a simple spreadsheet and has slowly been tweaked and formed into what it is now, with tweaking and adding colour etc

  3. Hi Alex,
    Very interested in what you’ve done with the European rankings, coefficients etc. Is this included within the spreadsheet you have available on ebay?

    1. Hi Dave

      No, the spreadsheet just has generic templates that you can use for European and domestic knockout cups. You enter names of teams of your own choice, and rank and rate them as you wish. I just use the Bert Kassies data to help me with that.

      The rankings mentioned in the post are done for my own competitions that I play myself, so aren’t appropriate for the ones in the spreadsheet. Also, the data is just copied and pasted from the site, so you can get more from there than anything I could provide.

      Alex

      1. Hi Alex
        Many thanks for clarifying. I have a similar project ongoing, although not using Logacta. I’ll keep following yours with interest.
        Dave

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.