Ligue 1 Interactive Table in Excel for 2022/23 Season.
The Excel tables are now available in two versions.
The first version includes Monte Carlo Predictions of the teams standings. The Monte Carlo simulations and the league table are implemented with Excel VBA macros. It includes the following features:
- League Fixtures sorted by Match Day.
- Printable Match Calendar of every team in the league.
- Interactive League Table. The scores can be filled manually by the user or generated by the computer. At the click of a button, the League Table will automatically update.
- Monte Carlo simulations of the league table. The simulations use Soccer Power Index (SPI) from fivethirtyeight.com to predict the outcome of every league game. The simulations run through the season multiple times. As a result, the simulations predict the standing of every team in the league.
- As the season progresses, we will publish updated Excel tables periodically with new scores and new game schedules.
The second version does not include Monte Carlo Predictions of the teams standings. This is a macro free Excel spreadsheet. It includes the same Interactive League Table, printable match schedules, list of all fixtures with results. The user just type in the game scores, the league table and the remaining spread sheets will update automatically without VBA macro.
Both versions are free to download.
2022/23 Ligue 1 Interactive Table with VBA macro enabled Monte Carlo Predictions:
2022/23 Ligue 1 Interactive Macro Free Table:
2022/23 Ligue 1 Interactive Table in Excel Screen shots:
Ligue 1 Interactive Table from previous seasons:
Download 2021/22 Ligue 1 Interactive Table:
Download 2020/21 Ligue 1 Interactive Table: