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:
- Teams that qualified from the same group cannot play each other;
- Teams from the same country cannot play each other;
- 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.