Championship League Table in Excel with Monte-Carlo Predictions

Fixture Calendar

We are happy to announce the release of English Championship League Table in Excel with Monte-Carlo Predictions 2022/23!

Just like our other Excel league tables, this Excel chart supports the following functions:

  1. League Fixtures sorted by Match Day.
  2. Printable Match Calendar of every team in the league.
  3. 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.
  4. 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.
  5. As the season progresses, we will publish updated Excel tables periodically with new scores and new game schedules.

Download Championship League Table in Excel with Monte-Carlo Predictions 2022/23. Enjoy and good luck to your favorite teams!

Championship League Table in Excel with Monte-Carlo Predictions Screen Shot:

Return to the Download page to download other score tables.

Previous Season Championship League Table in Excel with Monte-Carlo Predictions

18 comments

  1. Hello JTang,

    Thank you for these spreadsheets and all the hard work that has gone into creating them, they are very much appreciated by me.

    I hope you do not mind me making a few suggestions/comments.

    I am using Excel version 2010 14.0.7268.5000 (64 bit) and I am unable to get the SPI data to update after pressing the macro button on the SPI tab. The spi_global_rankings tab updates to the latest values but then I get a VBA error as follows.
    Run-time error ‘5’ Invalid procedure call or argument
    I suspect this is down to the old version of Excel that I am using. I am unable to use the Debug button to help you with tracing the error as it is protected.
    I am using the latest download 2022-23_20220817 and I tried to update the SPI from the date 24th August 2022.

    Is there a way to remove the decimal places on Tab Predicted_Table Columns G, H, I, and K? It doesn’t look correct to see 79.4 points, I would rather see 79.

    Another comment Norwich City has changed their club badge pre-season.

    Thank you, kind regards

    Freddy.

    1. Hi,
      The spreadsheets are not tested in Excel version 2010. I will look into remove the decimal places in the Predicted Table tab. Thanks for the suggestion. I will change the club badge for Norwich City before the next update.

      Thanks!

  2. Thank you very much!!!

    I was able to download all of the files without any problems.

    Have a good day!!!

  3. Good Day!!!

    I just want to put in detail what the issue is with all the soccer league spreadsheets:

    I changed the Time Zone to US Eastern. When I hit Update All Without Auto Fill, the update ran fine until the Team Fixture List where the following error message appeared:

    Run-time error ‘1004’:
    The specified file wasn’t found.

    I then clicked “End” and the Fixtures by Club tab came up and there was no data. Also, the scores would not update for the Championship and League One spreadsheets.

    Please let me know if you need any more information.

    Thank you.

          1. Good Day!!!

            Unfortunately, with the exception of the League One spreadsheet, the same issue happened when downloading the updated league spreadsheets.

            When I hit Update All Without Auto Fill, the update ran fine until the Team Fixture List where the following error message
            appeared:

            Run-time error ‘1004’:
            The specified file wasn’t found.

            I then clicked “End” and the Fixtures by Club tab came up and there was no data.

            There was a different issue with the League One spreadsheet and I left a comment.

            Thank you.

  4. Good Day!!!

    I don’t know if this has happened to anyone else, but when I downloaded the new spreadsheets for all the soccer leagues, they all have an issue when I update without auto fill after choosing US Eastern for the correct time zone in my location.

    The issue comes when updating the team fixture list and after I press end to stop the update, the team fixture list disappears. Also, it did not update today’s results in the Championship and League One spreadsheets when I tried to do that today.

    Please advise when you have the opportunity and please let me know if you have any questions.

    Thank you in advance for your assistance.

  5. Good Day!!!

    FYI, Derby County received an additional 9-point deduction after admitting to breaches of the EFL’s Profitability and Sustainability rules. Derby County now has 0 points (see attached link – please note, the story was before Derby County’s victory today).

    https://www.skysports.com/football/news/11696/12469898/derby-county-hit-with-further-nine-point-deduction-for-breaching-efl-rules

    Also, Reading received a 6-point deduction after admitting to breach of EFL’s profit and sustainability rules. Reading now has 17 points (see attached link).

    https://www.skysports.com/football/news/11673/12471018/reading-hit-with-six-point-penalty-after-admitting-to-breaches-of-efls-profit-and-sustainability-rules

    Thanks.

Leave a comment

Your email address will not be published.