Spreadsheet for European Cups - Feedback & Suggestions
@eye, another question. Why do you have England and Portugal as Top 2 countries in EPS ranking in your spreadsheet? According to current seasonal coefficients, shouldn't it be England and Italy?
This is because clubs and countries are not awarded secured bonus points during LP but get all the bonus at the end of each LP. Exception to this are the 6 bonus points for taking part at CL-LP.nogomet wrote: Mon Dec 30, 2024 15:08 @eye, another question. Why do you have England and Portugal as Top 2 countries in EPS ranking in your spreadsheet? According to current seasonal coefficients, shouldn't it be England and Italy?
I believe this is a better approach than awarding minimum secured points. It is easier for someone who watches club or country ranking table to do calculations for clubs and countries without needing to search if part of bonus points is already awarded.
It's changed (;eye wrote: Fri Dec 13, 2024 17:01Yes I know it but I am using the same names for clubs as @bert.kassies at this site in order to people to search for clubs with same name at my spreadsheet and at this site. So if the name will change here I will also change it.ekze wrote: Fri Dec 13, 2024 03:07 @eye hey, thanks for this! Just letting you know that Georgian champion has changed the name to Iberia (from Saburtalo) this season.
I changed it alsoekze wrote: Wed Jan 22, 2025 23:30It's changed (;eye wrote: Fri Dec 13, 2024 17:01Yes I know it but I am using the same names for clubs as @bert.kassies at this site in order to people to search for clubs with same name at my spreadsheet and at this site. So if the name will change here I will also change it.ekze wrote: Fri Dec 13, 2024 03:07 @eye hey, thanks for this! Just letting you know that Georgian champion has changed the name to Iberia (from Saburtalo) this season.
In few hours the first league that will award spots for the european competitions of 2026-2027 (league of Republic of Ireland) will start. So it is time for the first very version of new spreadsheet to come online. You can find it at the link below.
https://docs.google.com/spreadsheets/d/ ... sp=sharing
The tables you see are based on the current situation and again the main principle is when a spot is unknown the club with highest coefficient will take it. This means that league standings of leagues that have not started are based on coefficients, domestic and european cup winners are the clubs with the highest coefficient amongst the clubs that are still at each competition and the club with highest coefficient in a tie will always qualify to next round of a european competition.
Note that clubs that appear to take part at european competitions are not the ones that are currently taking part but the ones that are currently qualifying at next season's competitions. Another thing you also need to note is that remaining league matches might be different in case there will be different league format in some leagues and some clubs that might be relegated may appear in the standings for a while (till the draw for next season).
The league standings normally will be updated within 10 mins after the end of each match and coefficients will be updated almost live during european matches. Usually there is a delay of 1-2 mins at the spreadsheet for current season for live coefficients but at the new spreadsheet will be 1-2 mins more since it is retrieving data from the spreadsheet for current season.
https://docs.google.com/spreadsheets/d/ ... sp=sharing
The tables you see are based on the current situation and again the main principle is when a spot is unknown the club with highest coefficient will take it. This means that league standings of leagues that have not started are based on coefficients, domestic and european cup winners are the clubs with the highest coefficient amongst the clubs that are still at each competition and the club with highest coefficient in a tie will always qualify to next round of a european competition.
Note that clubs that appear to take part at european competitions are not the ones that are currently taking part but the ones that are currently qualifying at next season's competitions. Another thing you also need to note is that remaining league matches might be different in case there will be different league format in some leagues and some clubs that might be relegated may appear in the standings for a while (till the draw for next season).
The league standings normally will be updated within 10 mins after the end of each match and coefficients will be updated almost live during european matches. Usually there is a delay of 1-2 mins at the spreadsheet for current season for live coefficients but at the new spreadsheet will be 1-2 mins more since it is retrieving data from the spreadsheet for current season.