I would like to introduce a beta version of the Premier League Interactive table with automated calendar and score updates and xG Tables.
One of the inconvenience of the club soccer interactive tables is that whenever the match calendar changes, I need to publish a new league table with updated calendar. I have been looking for a way to add automated calendar and score update capability in the interactive spreadsheet.
I am happy to announce the beta version of the Premier League Interactive Table with Automated Calendar and Score Updates.
In the same Interactive Table, I also added Expected Goal (xG) tables.
The new Excel table supports the following functions:
- A List of all 2021/22 Premier League Fixtures with results.
- Printable match schedules of all teams in the league.
- Interactive League Table.
- Interactive xG League Table.
- Monte-Carlo simulations of every game in the season. The Monte-Carlo simulations run through the season multiple times. As a result, the simulations will predict each team’s position on the league table.
Detailed descriptions of the Excel chart can be found here.
The Monte-Carlo simulations are based on Soccer Power Index (SPI) values from fivethirtyeight.com
The xG data is also obtained from fivethirtyeight.com.
There is a new “Update Calendar and Scores” button on the Dashboard tab. At the click of this button, the spreadsheet will download the latest match calendar and score from
The spreadsheet compares the match calendar to the new calendar. If a change is detected, the spreadsheet will reset the “Fixtures_by_Clubs” and “Fixtures_by_Date” tabs. The old match calendars, including the team logos, will be deleted and the new match calendar, including the team logos, will be re-inserted. New match scores are inserted at the same time.
The new Interactive Table is distributed in a zip file. The zip file contains the Interactive Table spreadsheet and the club logos. Unzip the files to a folder and open the spreadsheet from Excel. The club logos must reside in the same folder as the Interactive Table spreadsheet.
The new spreadsheet was tested on Excel 365. It may not work with earlier versions of Microsoft Excel.
Download 2021-22 Premier League Interactive table with automated calendar and score updates and xG Tables from the link below.
Feedback on the beta release is welcome. For the 2021-22 season, I the non-automated league tables will still be updated as calendar changes. Plan is to transition to the automated tables in the 2022-23 season.
Enjoy and good luck to your favorite teams!