Interactive Premier League Table in Excel Download

1 Star2 Stars3 Stars4 Stars5 Stars (2 votes, average: 5.00 out of 5)
Loading...

Free Download Interactive Premier League Table in Excel

We now have Excel Tables covering six European football leagues for the 2020/21 Season:

  1. England Premier League.  
  2. England Championship League.  
  3. Germany Bundesliga.  
  4. France Ligue 1.  
  5. Spain La Liga.  
  6. Italy Serie A. 

10/18/2020 Update: Serie A Excel Chart is updated for 1 point deduction of Napoli. 

Link to Download page: http://www.tangfamily.me/interactive-soccer-league-table-in-excel-download/

The Interactive Premier League Excel spread sheet calculates the Win, Draw and Loss probabilities of each fixture.  Based on the calculated probabilities, the spread sheet will predict the score of each fixture.  Furthermore, it allows the user to run Monte Carlo simulations of the entire season and predict the outcome of the league table.

The spread sheet supports the following features.

1. Predict and generate the league table.

The league table can be generated in the following 3 ways.

  1. Generating the league table from manually entered scores. 
  2. Generating the league table from automatically “guessed” scores.  The “guessed scores” are generated based on the Win/Draw/Loss probabilities.
  3. Predicting the final league table by running Monte Carlo simulations.  The user can specify the number of Monte Carlo runs. 

The math behind predicting EPL games is documented in detail in the this post.  I use the SPI (Soccer Power Index) published by fivethirtyeight.com to predict the outcome of the games. 

The spread sheet also offers a couple of unique features that allow the user to make his or her own predictions.

  1. SPI Adjustment Factor (SAF).  “SAF” allows the user to tweak the SPI values from fivethiertyeight.com.  You can strengthen or weaken a club by using a positive or negative SAF value.  This comes in handy when the user happens to disagree with the fivethirtyeight.com SPI values.  It allows the user to analyze other possible scenarios and see how they play into the final league standings.
  2. The user can enter “guessed” scores for future games.  This allows the user see how the outcome of a future game changes the standings of the team. 

2. Printable list of the league fixtures.

The spreadsheet presents the league fixtures into two formats.

  1. Fixtures arranged by each club.  
  2. Fixtures arranged by match days.

The spread sheet works with MS Excel 2013 or later. You need to enable macro in Excel to run it. 

If you have questions or suggestions, please leave a comment at the bottom of this post. Enjoy!




2020/21 Season:   Verify Captcha first. Download will start automatically.




Follow this link to download Interactive League Tables in Excel for EFL Championship League, France Ligue 1, Bundesliga, La Liga and Serie A.

You may also like...

41 Responses

  1. Ramy Algendy says:

    Napoli got deducted a point today

    so the Serie A excel needs to be fixed with that

    Thanks very much

  2. Ramy Algendy says:

    Will there be a Champions League and Europa League Group Stage Excels?

  3. Ramy Algendy says:

    The Newest Version of the Championship Excel is not available

  4. Ramy Algendy says:

    Hi jtang

    Sorry if this is asking to much, but if u can Explain whats new in Every New Version Excel u release as if its only adding the results or something else u fixed or edited so we can know.

    Thanks again for your Hard work

    Much appreciated

    • jtang says:

      The new releases are most to keep up with fixture date/time changes.

      For instance, so far, Premier League has only released fixture time and date up to 10/3/2020. We will try to update the Excel sheet when new schedules are released.

      • Ramy Algendy says:

        I figured it is only Fixture changes

        Thanks

        if u find something wrong or fix anything and release a new Version please notify us.

  5. jtang says:

    Thanks for pointing out the problems! I just uploaded a new version (20200920) for 2020/21 Championship League with the following fixes.
    1. Sheffield Wed. starts the season with -12 pts.
    2. Game time for Central European Time Zone is now correct.
    3. Fixed Spelling for “Rotherham”.

  6. Ramy Algendy says:

    The Championship Excel has something wrong with it

    Sheffield Wednesday started the league with -12 points not 0

    • jtang says:

      Looks fine to me. Did you try the latest version (20200913)?

      • Ramy Algendy says:

        nope, didnt know there was a new version

        Will check it out, Thanks

      • Ramy Algendy says:

        Nope, check the newest Version still not fixed

        Sheffield Wednesday HAVE A -8 points after 2 games played

        Because they started the Season with a -12 deducted points

      • Ramy Algendy says:

        There is also something wrong with the Europe Central Time Zone in “Fixtures_by_date” page In the Championship Excel

        The Times are all wrong

      • Freddy Hudkin says:

        Hello J Tang,

        Thank you for this spreadsheet, its very impressive, sorry but i think that Ramy Algendy is correct.

        I have just opened the 20200913 version, filled in the results for Saturday 19th September and generated the league table. Sheffield Wednesday are in 3rd position, they should be in 24th position. They were deducted 12 points and so started the season at -12 points, they should now be on -8 points after two games played.

        There is a spelling error in the team names on the Dashboard tab. Cell B20 should be Rotherham United.

        On the SPI tab, if I click the Excel 2013 update SPI I get an error. Run time error 5; Invalid procedure call or argument. This may be due to me using Excel 2010 though.

        Your hard work in creating these spreadsheets is very much appreciated so please do not take these comments as a criticism.

        Regards Freddy

        • jtang says:

          Thanks for the feedback. I will publish a new Championship league shortly.

          • Ramy Algendy says:

            And i Second Freddy Hudkin on what he said

            Very Impressive work and alot of hard work done to create there amazing excel sheets

          • jtang says:

            Thank you!
            I just uploaded a new version (20200920) for Championship League with the following fixes.
            1. Sheffield Wed. starts the season with -12 pts.
            2. Game time for Central European Time Zone is now correct.
            3. Fixed Spelling for “Rotherham”.

  7. Rahul says:

    Hi JTANG,
    In the 2020/21 EPL workbook the Guessed score columns are locked. Can this please be unlocked. Also, can you please enable basic functions like hide/unhide columns?

    • jtang says:

      The two guessed score columns are used by the Excel Macro code and cannot be unlocked. You can type in your guessed scores in the home team goal and away team goal columns.

  8. Jordan says:

    Doesn’t work. I have downloaded the 2018/19 one which allows you to fill your own results in and then generates a table and works fine but the 2019/20 version just puts its own scores in when you click ‘no auto fill’. very frustrating.

    • jtang says:

      Sorry for the very late reply. Starting from the June 2020 update, the user can no longer change the scores of the games that are already completed. “No Auto Fill” will only “guess” the scores of the future games, not the games that have already completed. I think this is what you have observed.

  9. Daniel says:

    Are you still updating this as of 2020 fixtures?

  10. RS says:

    Hi, thanks for this, will you be updating this anytime soon?

  11. Craig Jones says:

    Hi, I really love your work, when is the next update?

  12. Dan says:

    Will you be updating this for the second half of the season and fixtures that have been rearranged?

    The games now all say 00:00 as kick off time.

  13. Daniel says:

    Are you updating this now that the December fixtures have changed for all clubs?

    • jtang says:

      Just uploaded a new version (3.1) for the Premier League with updated fixtures.

      • Daniel says:

        Thank you very much!

        Do you have one, or are considering implementing, where it includes all other domestic and European fixtures such as Carabao Cup, FA Cup, Champions League and Europa League etc?

  14. Darren says:

    HI, would it be possible to get the password to unlock the worksheet that has the premier league table on it i am happy to pay a modest amount for the password but i want to know how the table auto updates itself

    • jtang says:

      Thanks for your interest in the spread sheet. The tables are updated via Excel macro. We don’t provide password. Sorry!

  15. HVK says:

    Hi Tangfamily, will it be possible to share password to unprotect the sheet. Would be helpful to try out scenarios?

    Cheers

    • jtang says:

      Hi HVK,

      There are a few different ways to try various scenarios:
      1. You can enter the score of a particular fixture per your own prediction. You can then run the Monte Carlo simulation to see how the table changes.
      2. You can enter the “SAF” factors of a particular club. The “SAF” values basically overrides the SPI values.
      3. You still can manually enter the “SPI” values of each club, if you do not agree with “SPI” values.

      Thanks,
      Jie

  16. Johnny says:

    Hi Tang family
    I love you spreadsheets
    do you have one for the english league 1, league 2 and the national league
    just the fixtures will be good for those leagues pls
    Regards
    John

Leave a Reply

Your email address will not be published.