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.
 
at

41 comments:

  1. PUPPPU4 April 2014 at 15:11

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

    ReplyDelete
    Replies
    1. Unknown13 April 2014 at 01:44

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

      Delete
    2. Unknown10 November 2015 at 12:36

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

      Delete
    3. Unknown25 May 2016 at 13:18

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

      Delete
  2. PUPPPU23 April 2014 at 14:13

    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. Unknown23 April 2014 at 21:39

      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. PUPPPU24 April 2014 at 12:35

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

    Thank you---now works a treat :)

    ReplyDelete
  4. Unknown25 April 2014 at 06:00

    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. Unknown28 April 2014 at 21:38

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

      Delete
  5. Unknown16 June 2014 at 20:28

    is the download above the latest and greatest?

    ReplyDelete
  6. Unknown21 July 2014 at 14:04

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

    ReplyDelete
  7. Unknown24 July 2014 at 22:40

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

    ReplyDelete
  8. price aki8 August 2014 at 12:03

    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. price aki8 August 2014 at 12:04

    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. Unknown11 August 2014 at 01:17

      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. price aki11 August 2014 at 07:47

    thanks but i dont know how to do this

    ReplyDelete
  11. Nahpah5927 November 2014 at 14:43

    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. Alan Murray2 December 2014 at 23:52

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

      Delete
  12. Unknown21 December 2014 at 04:39

    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. Nahpah5921 January 2015 at 05:14

    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. Alan Murray21 January 2015 at 05:49

    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. Nahpah5921 January 2015 at 06:07

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

    ReplyDelete
  16. Nahpah5921 January 2015 at 06:10

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

    ReplyDelete
  17. Unknown21 January 2015 at 06:37

    @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. Nahpah5921 January 2015 at 08:06

    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. Unknown21 January 2015 at 08:55

      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. Unknown19 March 2015 at 00:34

    This comment has been removed by the author.

    ReplyDelete
  20. Unknown19 March 2015 at 00:36

    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. Unknown24 May 2015 at 15:04

    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. Unknown25 May 2015 at 02:26

    Hi Saroop,

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

    ReplyDelete
  23. Anonymous28 April 2016 at 04:00

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

    ReplyDelete
  24. Anonymous28 April 2016 at 04:06

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

    ReplyDelete
    Replies
    1. Unknown28 April 2016 at 23:27

      Hi Jimmy, I have replied via your email.

      Delete
  25. Unknown6 June 2016 at 12:27

    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. Unknown9 June 2016 at 01:38

      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. Unknown31 August 2016 at 11:01

    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. Unknown31 August 2016 at 11:03

    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. Unknown1 September 2016 at 02:19

    Hi Giovanni,

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

    Alan

    ReplyDelete
  29. Unknown20 September 2016 at 04:02

    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. Unknown20 September 2016 at 05:20

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

      Delete
  30. Unknown20 September 2016 at 21:20

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

    ReplyDelete