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.

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;

- Enter the team names onto the Teams sheet
- Enter the fixtures onto the fixtures sheet (check out my Excel fixture list creator)
- Enter the results as they happen

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

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

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

DeleteI had a little problem and Alan sorted it in less than 24 hours.

DeleteVery impressed

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.

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

Thank you

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.

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

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

ReplyDeleteThank you---now works a treat :)

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

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

Deleteis the download above the latest and greatest?

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

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

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

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

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

Deletethanks but i dont know how to do this

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

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

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

ReplyDeleteHi, 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??

ReplyDeleteWon't calculate at all? Or just not correctly?

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

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

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

ReplyDelete@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.

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

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

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

DeleteThis comment has been removed by the author.

ReplyDeleteHi Alan, great workbook.

ReplyDeleteI 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?

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

ReplyDeleteHi Saroop,

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

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

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

ReplyDeleteHi Jimmy, I have replied via your email.

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

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

DeleteAlan

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?

ReplyDeleteThank 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?

ReplyDeleteHi Giovanni,

ReplyDeleteSure, check out the link below.

http://smallbusiness.chron.com/embed-excel-spreadsheet-html-42699.html

Alan

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?

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

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

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

ReplyDelete