Questions? Comments? Please leave a comment below.
e-mail: excel4soccer@gmail.com
36 comments
Can I have the password to allow me to manually put in scores for the Premier League, please? Is it the same for all leagues as I like the French and German set ups too.
Thanks
David
You can manually type in scores. You do it on the “fixtures” tab. Once the scores are entered on the “fixtures” tab, the scores in the tabs will update automatically.
Hi, do you have the 20/21 Premier league stats for download. Looking at what’s available on your site, the match stats are for 21/22 and 22/23. Thanking you in advance
Hi, i would like to ask if you can provide excel tables (like the big5 ones) for other leagues such as Eredivisie, Jupiler Pro League, Austria Bundesliga, Denmark Superligaen, Primeira Liga, Switzerland – Syper league.
Hi, why cant the ‘likey home/away goals’ columns not be manually inputted for the remaining fixtures and also the result percentage not correct itself?
Hi my friend would you make it for me Monte Carlo simulation Prediction excel which is not VBA excel if no otherwise for example slover . I pay for it if you do $36,00 i pay you please write back and don’t and don’t delete it comment.
Thank you for sharing the simulation tool and the forecasts for the 2022 Qatar world cup!
I have a question for you. Are the FPI’s for all teams updated as for july, 2022? If not, what is the last update you’ve worked with?
Many thanks again!
As far as I can tell, the SPI numbers change from time to time. It’s hard to tell how frequently they update the SPI values for the international teams. I don’t they are updated in July 2022.
On the other hand, the SPI values of the club teams are updated daily by fivethirtyeight.com.
This is superb. I done something similar (nowhere as near as fantastic as this) for my local lcub (Sunderland, Lg 1), and our nearest 6 rivials. Hopefully, we’ll get promoted. Any idea when you will release 2022-23 Fixtures – I will need to make some additions like this year. Cant wait to see it.. WONDERFUL WONDERFUL work!
Hello! I really appreciated your job! I’m writing to ask if you have the spreadsheet for others European Leagues such as Eredivisie, Belgian Pro League and Austrian Bundesliga…thanks in advance 🙂
Thanks! If there are enough interest from the community, I can expand the spreadsheets to cover more European Leagues. Please check back in a few months.
Hi, thank you for posting UCL and UEL monte carlo sims! I had a question on the UCL MC sim, particularly with Group B. The model seems to dislike Atletico Madrid disproportionately than it should even after I adjust their SPI ratings higher and their opponents lower. Usually they are one of two teams in the group to finish w/ a positive goal differential but they still don’t finish in the top 2. Is there a calculation error going on with them? Thank you
I assume you are referring to the interactive league tables.
The past scores are stored in a hidden tab “fixtures_tmp”. “fixtures_tmp” is not password protected. You can either delete or change the “home goal” and “away goal” columns to change the results of past games.
Hello, I am interested in your file from the other website “Premier League Soccer Data In Excel”, but the download is no longer available, would you be so kind as to send me the file to my e-mail address? If any payment is required, just let me know.
At this point, the plan is to support the same leagues as last season: Bundesliga, Serie A, French Ligue 1 and La Liga. The league tables will be published after Euro2020.
Do you have the Free Download Interactive Premier League Table in Excel for 21-22 league period? if I have the files from last season , how can I change the 3 new teams in this season (Watford, Brenford, Norwich City)
Can I have the password to allow me to manually put in scores for the Premier League, please? Is it the same for all leagues as I like the French and German set ups too.
Thanks
David
You can manually type in scores. You do it on the “fixtures” tab. Once the scores are entered on the “fixtures” tab, the scores in the tabs will update automatically.
Hi, do you have the 20/21 Premier league stats for download. Looking at what’s available on your site, the match stats are for 21/22 and 22/23. Thanking you in advance
Hi, i would like to ask if you can provide excel tables (like the big5 ones) for other leagues such as Eredivisie, Jupiler Pro League, Austria Bundesliga, Denmark Superligaen, Primeira Liga, Switzerland – Syper league.
Is there a spreadsheet available for the 2022-23 UEFA Champions League
Yes! We just published the 22-23 Champions League score chart on a few days ago!
https://www.excel4soccer.com/2022/09/05/uefa-champions-league-score-chart-in-excel/
Hi, are you publishing an updated UCL and UEL model? Thanks as always!
Yes, the UCL and UEL score charts are published today!
Hi, why cant the ‘likey home/away goals’ columns not be manually inputted for the remaining fixtures and also the result percentage not correct itself?
Thanks
I have the same question?
Hi my friend would you make it for me Monte Carlo simulation Prediction excel which is not VBA excel if no otherwise for example slover . I pay for it if you do $36,00 i pay you please write back and don’t and don’t delete it comment.
Thank you for sharing the simulation tool and the forecasts for the 2022 Qatar world cup!
I have a question for you. Are the FPI’s for all teams updated as for july, 2022? If not, what is the last update you’ve worked with?
Many thanks again!
The SPI values of the international teams are maintained by fivethirtyeight.com.
https://projects.fivethirtyeight.com/soccer-api/international/spi_global_rankings_intl.csv
As far as I can tell, the SPI numbers change from time to time. It’s hard to tell how frequently they update the SPI values for the international teams. I don’t they are updated in July 2022.
On the other hand, the SPI values of the club teams are updated daily by fivethirtyeight.com.
Hi my friend
Congrats on another amazing and successful season, thoroughly enjoyed it.
Amazing work done as always, and very much looking forward to next season.
Ramy
This is superb. I done something similar (nowhere as near as fantastic as this) for my local lcub (Sunderland, Lg 1), and our nearest 6 rivials. Hopefully, we’ll get promoted. Any idea when you will release 2022-23 Fixtures – I will need to make some additions like this year. Cant wait to see it.. WONDERFUL WONDERFUL work!
Thanks! I release the Excel Tables after the leagues announce the fixture calendar. This is usually in June. Good luck to Sunderland!
Do you have an interactive table for Pages? I have recently switched to Mac and used to love this.
I meant Numbers, which is the Apple version of Excel. Sorry.
I don’t think the macros will run in Numbers. I have tried to run the Interactive Score Tables in Microsoft Excel 365 for Mac. They work fine.
Hello! I really appreciated your job! I’m writing to ask if you have the spreadsheet for others European Leagues such as Eredivisie, Belgian Pro League and Austrian Bundesliga…thanks in advance 🙂
Thanks! If there are enough interest from the community, I can expand the spreadsheets to cover more European Leagues. Please check back in a few months.
Hi, thank you for posting UCL and UEL monte carlo sims! I had a question on the UCL MC sim, particularly with Group B. The model seems to dislike Atletico Madrid disproportionately than it should even after I adjust their SPI ratings higher and their opponents lower. Usually they are one of two teams in the group to finish w/ a positive goal differential but they still don’t finish in the top 2. Is there a calculation error going on with them? Thank you
Looks like it’s due the random number generator in Excel. Please try the new version (09-14-2021).
Thanks!
How can i get the password to change some result? Or no chance to do that?
I assume you are referring to the interactive league tables.
The past scores are stored in a hidden tab “fixtures_tmp”. “fixtures_tmp” is not password protected. You can either delete or change the “home goal” and “away goal” columns to change the results of past games.
Hello, I am interested in your file from the other website “Premier League Soccer Data In Excel”, but the download is no longer available, would you be so kind as to send me the file to my e-mail address? If any payment is required, just let me know.
Thank you and best regards.
Hi
Soccer Data in Excel for 2021-22 Premier League has been added to the site.
https://www.excel4soccer.com/2021/08/25/soccer-data-in-excel/
Thank you very much.
Love your work. Keep it up. How do I donate?
Thanks! To donate, you can go to the Download page or the About page and click the “Donate” button.
Any chance for a UCL interactive table? Thank you for your hard work!
Hola soy GERARDO de Peru, me gusto su trabajo y los felicito pero no logro entender como usar la tabla de la euro. me ayudan ?
Are there going to be more interactive tables of european leagues?
If yes, which ones?
At this point, the plan is to support the same leagues as last season: Bundesliga, Serie A, French Ligue 1 and La Liga. The league tables will be published after Euro2020.
Good afternoon
Do you have the Free Download Interactive Premier League Table in Excel for 21-22 league period? if I have the files from last season , how can I change the 3 new teams in this season (Watford, Brenford, Norwich City)
Not yet. Will have one before the 21 season starts.