Monday, 7 October 2013

Create an Excel Soccer League Table Generator


Need a league table generator for a sports league you compete in or manage?

I love sport and Excel to merge the two is enjoyable for me. I have created a league table generator in Excel so that when results are entered for a fixture, the league table will calculate and rank each team accordingly.

Excel soccer league table generator


You don't need to do a thing. After setup just enter the results and let the league table take care of the rest.

Download the Excel league table generator

To use the spreadsheet;
  1. Enter the team names onto the Teams sheet
  2. Enter the fixtures onto the fixtures sheet (check out my Excel fixture list creator)
  3. Enter the results as they happen
Check out the Create sports league tables and tournament in Excel online course and learn how you can set up your own league tables now.
 

41 comments:

  1. Number of games played does not calculate correctly if a team scores zero goals

    ReplyDelete
    Replies
    1. This can been corrected. Thanks for bringing it to my attention.

      Delete
    2. Hi Alan, I was wondering why in the fixtures table the home side was sorted alphabetically and the other side was not.

      Delete
    3. I had a little problem and Alan sorted it in less than 24 hours.
      Very impressed

      Delete
  2. I am trying to further expand your model to be used with 16 teams but am unable to have the league table work. The reason for this is, I think, you have hidden a formula/defined name "Premier Calculations". It only works with 10 teams.

    Would you be prepared to share how this can be expanded?

    Thank you

    ReplyDelete
    Replies
    1. Yes "Premier Calculations" is a table which can be found on a hidden sheet called Calculations. You can unhide this sheets, they are only hidden to prevent accidents and confusion on them.

      Add the additional teams to the "Teams" sheet and then copy down the league table and calculations tables.

      Delete
  3. Doh-----why didn't I search for the hidden.

    Thank you---now works a treat :)

    ReplyDelete
  4. Hi great set up but one bit is not working for me. All teams and results have been put in for week 1 but the score from Line 3 (the second game) is missing from the league table - Just has 2 blank slots. Any advice? Thanks

    ReplyDelete
    Replies
    1. Hard to say without seeing the file. Could you send it to me.

      Delete
  5. is the download above the latest and greatest?

    ReplyDelete
  6. Hi is there a way this can be done for 30 teams?

    ReplyDelete
  7. Absolutely. Just add the teams and copy down the formulas.

    ReplyDelete
  8. hi there i need to remove 4 team form the list how to do that i just have 6 team playing pls help asap

    ReplyDelete
  9. hi there i need to remove 4 team form the list how to do that i just have 6 team playing pls help asap

    ReplyDelete
    Replies
    1. You will need to remove the team names from the Teams sheet and then reduce all the tables on Teams, Calculations and League Tables sheets so that the formulas are using the correct ranges.

      Delete
  10. thanks but i dont know how to do this

    ReplyDelete
  11. Hi is you excel fixture list generator still available as the above link is broken. If it is available how Can i get it?

    ReplyDelete
    Replies
    1. Thank you for bringing this to my attention. The link has now been fixed.

      Delete
  12. Hi. I have downloaded the fixture generator and when I open it is just a blank page and does not show any of the options as seen on your Youtube video. I am using EXCEL 2007.

    ReplyDelete
  13. Hi, I have been trying to use your league table generator with 16 teams but am unable to get it wo calculate correctly. it will only calculate the first 10 teams. I have expanded theCalculations, League, team & fixtures sheets correctly but to no avail. any Suggestions as to whats going wrong??

    ReplyDelete
  14. Won't calculate at all? Or just not correctly?

    If you expanded the lists as you say I cannot envisage a problem. However it is difficult to fully diagnose without seeing the workbook in question.

    ReplyDelete
  15. I can send you a copy of worksheet or screenshots, there are alot of formula errors stating inconsistant formula

    ReplyDelete
  16. not sure whether it makes a difference but I using Excel 2010

    ReplyDelete
  17. @Nahpah59 That won't be a problem. The issue will be with the Calculations or League Table sheet or both. If you are having inconsistent formulas I would guess at this being the first two columns on the Calculations sheet.

    Check how the formulas in the first few rows look. Then match the ones for >10 teams. Might need to modify the last row in the formula.

    ReplyDelete
  18. everything appears to be the same so i am at a loss as to why this is happening, also if you look on the league table the last two positions are blank even though i have imput data for games played. ie i have completly filled fixture results for a draw for all games throughout season

    ReplyDelete
    Replies
    1. I will need to see it to solve it Nahpah. Email the admin@computergaga.com account and I'll have a quick look.

      Delete
  19. This comment has been removed by the author.

    ReplyDelete
  20. Hi Alan, great workbook.
    I was looking at the fixture and league generator, and our small league play each other more than twice.
    How can I adjust it to calculate and plan the fixtures please?

    ReplyDelete
  21. Hi Alan, I have got 4 teams, which play twice, so should a fixture list of 12 Matches. But it only creates 10 Matches, not sure whats going wrong

    ReplyDelete
  22. Hi Saroop,

    I see that. I'm not sure whats wrong. It needs looking into.

    ReplyDelete
  23. Hi, I downloadted your template, but when I add 5 more teams, the scores for the teams show an error #NUM!

    ReplyDelete
  24. Hi, I downloadted your template, but when I add 5 more teams, the scores for the teams show an error #NUM!

    ReplyDelete
  25. Hi Alan, how can I modify the calculation for the team than loses a match scores 1 point and not 0? Thank you very much.

    ReplyDelete
    Replies
    1. Hi José, If you unhide the Calculations sheet (right mouse click a sheet tab and select Unhide). You should see the points column. Edit the formula to multiply the number of losses by 1 in the same way it has been done for draws.

      Alan

      Delete
  26. Thank you for the spreadsheet. Is there a way to embed the sheet into a webpage so that when you edit the sheet you can refresh the standings published online?

    ReplyDelete
  27. Thank you for the spreadsheet. Is there a way to embed the sheet into a webpage so that when you edit the sheet you can refresh the standings published online?

    ReplyDelete
  28. Hi Giovanni,

    Sure, check out the link below.
    http://smallbusiness.chron.com/embed-excel-spreadsheet-html-42699.html

    Alan

    ReplyDelete
  29. The spreadsheet works great for me, I just wondered if there's any way I can make the teams play each other four times (2 home and 2 away) instead of the standard?

    If not, thanks a whole lot for the spreadsheet anyway!

    ReplyDelete
    Replies
    1. Never mind, I figured out I can just add more fixtures at the bottom of the fixture list!

      Delete
  30. Thanks Rory. Yeah just copy and paste to repeat the current fixture set.

    ReplyDelete

.