I am happy to introduce the 2022/23 Premier League Table In Excel with Predictions.

The Excel table supports the following functions:

- A List of all 2022/23 Premier League Fixtures with results.
- Printable match schedules of all teams in the league.
- Interactive 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

Download the 2022/23 Premier League Interactive Table In Excel with Predictions from link below.

### 2022-23 Premier League Excel Table (09-18-22)

1 file(s) 1.26 MB

Enjoy and good luck to your favorite teams!

**Return to the Download page to download other score tables.**

#### Previous Season Premier League Interactive Table In Excel with Predictions:

### 2021-22 Premier League Excel Table (05-26-22)

1 file(s) 1.26 MB

### 2020/21 Premier League Excel Table (05-29-21)

1 file(s) 11.12 MB

### 2019/20 Premier League Excel Table (08-20-20)

1 file(s) 5.16 MB

Can you please provide the data for older premier league seasons?

So far, I have complied Premier League data from last season (2021-22) and the current season (2022-23). We can gradually add data for older seasons, if there’re enough interests.

Hi there, amazing work as usual

can you please tho cancel the Filter in the excel sheet as the arrows on top is very annoying?

Thank You

yes, I will remove the filter in the next update.

Hi there,

I always seem to get a runtime error ‘5’, invalid procedure call or argument whenever I clicked on the button “Download and Update SPI from fivethirtyeight.com”.

May i understand why might be behind this issue? As far as i understand, the end result when i click on this button should be seeing only values under the column “Updated Off_SPI” and “Updated Def_SPI” be updated right?

Can you let me know the version of Excel you are using? Are you using Windows or MAC? You are correct that you should only see values in “Updated Off_SPI” and “Updated Def_SPI” change after you click the button. The “Updated On:” date should also change.

I’m using windows 365, so it should the most updated version of microsoft office (2021 version). I’m using a windows laptop.

I’ve just tried today and it’s still giving me the same error (i tried on 3 spreadsheets like la liga, epl and serie a)

Can you send a screen shot of the error to excel4soccer@gmail.com? I will see if there’s fix for it. Thanks!

Hey, great work btw!!

Why is it not possible to change the scores in the ‘Likely Home/Away Goals’ columns?

Thanks

The likely goals are calculated from formulas. Why do you want to change them? You can enter the Home/Away goals in the nearby columns.

I dont really want to change them but it s just that from the Man Utd Villa game downwards there are no likely goals inputted goals for either side nor a result percentage?

Thanks

I don’t see that on my Excel chart. Can you download the latest version and try again?

Plus the sheet is protected and so i cant input any of them manually to complete the sheet.

Thanks

To be honest i think you may want to consider to allow the user to change the likely goals columns because he/she may not agree with those outcomes and therefore the result percentages to?

I should explain the prediction process. The prediction starts with the SPI values which are downloaded from 538.com. The SAF (SPI adjustment Factor) is them used to adjust the SPI values. Based on the SPI values, the spreadsheet computers the likely scores of each game and the win/draw/loss probability percentage.

If you do not agree with the likely scores, you can use the SAF to adjustment a team’s strength. You can even type in the SPI values, if you want to. The likely score and win/draw/loss percentages will change accordingly.

Cant open file says its corrupt, tried on Excel 2007 and 2019

It should work on 2019 version of Excel.

Just posted an updated version (version 20210812). You should be able to input scores in the fixtures tab. Thanks!

Thank You so much

When I input results into fixtures then press the update all without autofill the fixtures I put in are erased and the table does not update. Can you please fix this error in your code?

Working on a fix now. Will upload an updated version shortly.

Thanks!

Can i see xG? You can give me a price! I am really need it. Thank you!

Sorry, I don’t have access to xG data.