Excel Templates | Excel Spreadsheets | Create Your Own Soccer League Fixtures and Table



Create Your Own Soccer League Fixtures and Table

Posted on October 26, 2008
Filed Under Soccer, Sports |



It has been more than 2 months since I wrote the last template. I have been stuck in my job so I couldn’t do anything to pay more attention to this site. And within that time, I got a reminder email from English Football Association Agency, where they reminded me not to distribute anything regarding their English Premier League Fixtures and all related material except I paid a license for that. That is the reason why I dropped my English Premier League Fixtures excel spreadsheet from my site.

And in my pending comments boxes, I received a lot of request about the passwords or making other excel spreadsheet for other league.

Before, I decided to make a tutorial on this, but I my time is very limited to write. So, I decided to make a general soccer league table spreadsheet, where you can modify by yourself according to your needs. And there is no password on the excel sheet and the formula, so you can learn all the logic and the formula inside. I just protected the link to my website, and I will be very happy if you don’t remove that link. 

Comparing with my previous league sheets, I removed the graph and individual team fixtures due to complicated function that have to be managed to make it general. I am still try to make general and hopefully I can release it in next version.

This soccer spreadsheet consists of 5 sheets, i.e :
1. Initial Setup
2. League Table
3. Fixtures and Results
4. Deduction
5. Setting

I hide ’setting’ sheet, to avoid some misstyping while you are working with this sheet. You will easily unhide the sheet from the sheet menu.

Initial Setup

Initial Setup Sheet.
This is basically the first sheet where you have to put a number of team to participate in the league. I limited the maximum number of team to 24 teams. If you need more than 24 teams, try to learn the logic and formula inside and you can have your own excel league table spreadsheet. In this sheet, I put 20 teams and write all 20 sample teams in the corresponding cells. You can just change the sample teams with your teams.

League Table

League Table Sheet.
The league table will change automatically based on the name and number of teams you put in the ‘initial setup’ sheet and also the results from ‘fixtures and results’ sheet.

Matches

Fixtures and Results Sheet.
You can copy or change the sample teams in this worksheet. Fill the match result in the corresponding boxes.

Deduction

Deduction Sheet.
Perhaps this is just a redundant sheet, because it is needed when there is some team get a point deduction from their corresponding league association.

I made a little survey about some league fixtures that can be created using this templates, some of them are Portugal, Greece, Holland, Belgium, Finland, Sweden, Norway, Turkey, Switzerland League Fixtures. But probably it won’t fit Argentine or Brazil League because of different league format, I don’t know much about African or Asian league but as long as the league is in full competition format, you can use this spreadsheet.  

That’s all guys. If you need some support you can leave a comments, but I apologized that probably I cannot answer it in the short time because of my time limitation.

You can download the spreadsheet here.

You can download the spreadsheet for openoffice version here. 

Finally, I finished soccer league fixtures and table with automatic fixtures list generator. So, if you want to create competition matches from the scratch where you also have to design the matches schedule, you can use this spreadsheet. You can download it here.

Have fun.


You can read and download my other templates below :

Tags: , , , , , , , , , , , , , , ,

Comments

111 Responses to “Create Your Own Soccer League Fixtures and Table”

  1. bassey on October 28th, 2008 9:08 am

    How come u dont have one for the EPL

  2. Rahim on October 28th, 2008 10:37 am

    I have been crying out loud for such a template where i can modify and create leagues on my own. You have made my day!

  3. NH on October 29th, 2008 10:56 am

    Awesome job..

    Thanks..

  4. AMADOU MAKHTAR GUEYE on October 29th, 2008 1:35 pm

    Hi guy
    i would like to translate the template in french and spanish, for own use. Can i do it?
    Thanks for nice job you did!

  5. Vincent on October 31st, 2008 4:18 pm

    I have a question, does the template fit the La Liga, because in the rule of La Liga said “Teams are ranked by total points, with the highest-ranked club at the end of the season crowned champion. If points are equal between two or more clubs, head-to-head results usually determine their placement.” So I want to know is this template is fit or not?

  6. MASTA RASTA on November 5th, 2008 10:37 am

    Hey, You had done a wonderful job. I would like to get the functionality of the Team Fixtures so I can added to my custom league table

  7. James on November 7th, 2008 1:21 pm

    I don’t suppose you have anything like this with player statistics too.

    i.e. adding the scorers name and assists for each game and then having those stats on a top scorer top assist table.

    Many Thanks,

    PS This is a very good spreadsheet.

  8. aink on November 7th, 2008 5:00 pm

    njrit kenapa gg ada EPL..?
    woi bales..
    gg pake lama…

    “How come u dont have one for the EPL..”
    EPL gg laku?

  9. NH on November 7th, 2008 7:30 pm

    bassey, there was one available for the EPL & I have it. Don’t know why it has been removed though!!

  10. brucew on November 7th, 2008 9:36 pm

    Your template is great…thanks.
    Can you define the header abbreviations used in the League Table sheet?
    I think I know most but not sure.

  11. Admin on November 9th, 2008 2:03 pm

    For Bassey, NH, Aink and others who are looking for the EPL fixtures sheet, basically the first fixtures I made is the EPL, but I got a warning from the FA to drop the EPL fixtures except I paid for the license. I hope you can understand the situation.

    Regards - RM

  12. Admin on November 9th, 2008 2:04 pm

    Amadou,

    You can translate my sheet into your language.

    Regards - RM

  13. Admin on November 9th, 2008 2:29 pm

    Brucew,

    The abbreviations are as follows : P-Played, W-Win, D-Draw, L-Lose, F-Goals Scored For, A-Goals Scored Against, GD-Goal Difference, Pts-Points

    Regards - RM

  14. Sven on November 13th, 2008 11:56 am

    Really nice spread man, thanks a lot! I only had to search about 10 seconds to find this and become a satisfied, happy man :)

  15. Tony on November 27th, 2008 10:06 pm

    I have tried General football lite v1.5 and it is brilliant. It has only a small fault.
    If you use below 20 teams (e.g. 18) a team must get at least a point before it is shown on the table. Otherwise in its place a zero shows up and no stats are kept.

    Thanks.

  16. Jeff Coffman on December 4th, 2008 5:35 pm

    I’m trying to transpose this for Rugby Union. Would love to speak with you about some slight modifications.

    Beautiful footy table!

  17. indra on December 5th, 2008 4:29 am

    hi this spreadsheet is V1.5, would you give V1.7 ?
    Please…

  18. Jules on December 5th, 2008 9:09 pm

    A M A Z I N G!

    Was just looking for this, thanks!

  19. Andrea on December 6th, 2008 10:21 pm

    come mai con 22 squadre le ultime due non me le prende nella classifica??

  20. Jake on December 14th, 2008 5:35 pm

    Why dont the fixtures update very nice btw

  21. Dan walker on December 14th, 2008 8:41 pm

    Hi,

    Brilliant excel sheet.

    Thanks very much very useful for my sons football team and league.

    Just wondering is it possible to have a positive deduction?

    Because a couple of games have been abandoned and the points have been given to the away team as the home team have thrown the game. So scores have been put in as 0-0, so one team needs point deducting which is ok. But the other team requires 2 point added.

    Thanks again

    Dan.

  22. Swarup on January 18th, 2009 8:59 am

    Brilliant sir,Bt Plz Help Me To Know How U Hve Done Those Graphs Related to A Teams Performance…………………..

  23. Matti on January 19th, 2009 10:45 am

    Hi !
    How do I change winning points from 3 to 2 ?. I would like to use this template for junior icehockey, but then winners should get only 2 points to League Table Sheet.
    Regards
    Matti

  24. Admin on January 31st, 2009 5:20 am

    Hi Matti,

    You can change the points by going to sheet ‘Setting’ and go to column AC, you will find number 3 and 1 inside the formula. Change 3 into 2 for all used rows, and you will have the winning team get 2 points when they win.

    Regards

  25. pano on February 2nd, 2009 10:31 pm

    icant find the hide seting sheet please help

  26. pano on February 3rd, 2009 3:32 pm

    why you hide the settings icant find it

  27. pano on February 6th, 2009 3:26 pm

    i want to ask this sheet is only for 20 teams or for 16 teams too because whith 16 teams i have a problem
    is this true?

  28. Admin on February 10th, 2009 4:52 am

    Hi Pano,

    You can modify the formula by unprotect the sheet first. There is no password protection there. If you want to modify the setting sheet, you should unhide it first by going to menu > format > sheet > unhide.

    Regards

  29. Hi Suchat on February 13th, 2009 7:54 am

    I wants can like you ?
    greatly help teach me has please
    I wants way hole makes to are data graph like your
    I has begged for to take with
    thank you very much

  30. Paul Upfield on February 13th, 2009 12:30 pm

    Hi,

    I looked at your soccer sheet with interest and was very impressed if not staggered at how well a spreadsheet can be used.

    I play and coach tennis at a small inner city community tennis club. Our local leagues are a mess and an embarassement. The people who run them do so in their own time voluntarily mean well but just don’t do the job properly and so they are poorly supported and have little significance.

    I was looking for a spreadsheet to help run these leagues. I have tried to dabble with your sheet for many hours but I’m simply not skilled enough to create what I am looking for!

    I don’t know if you have time to help but I am willing to make a donation as gratitude.

    It is difficult to explain here but if you get in touch via e-mail I can submit my ideas on a blank spreadsheet to give you an idea of what im looking for.

    Thanks in anticipation.

    Paul

    paulupfield@msn.com

  31. Roon3y on February 15th, 2009 9:33 am

    Hey, Awesome sheet thanks alot but i have one problem.

    I have changed it to 10 teams but the fixtures part is still showing fixtures for 20 teams?

    Please help

    Roon3y

  32. karim on February 15th, 2009 2:02 pm

    Nice work..but why don’t the team names in fixtures and results sheet change when i change the names in the initial setup sheet ?

  33. Sam on February 16th, 2009 4:01 pm

    Hi, great site!!!

    Can I create a small league with just 4 teams??

    Thanks

  34. faldo on February 18th, 2009 11:46 pm

    I want to ask how to only have 4 teams, i want to use it fore an indoor tournament.

  35. Mac on February 25th, 2009 4:59 pm

    Isn’t there anyway for you to just remove the password so one can edit away that annoying link at the league table?.
    I’m going to use it just for my own and i already got you in my favorites on IE so i don’t need that if you know what i mean.

    You did a great job though and a big thanks

    Best regards
    Mac

  36. Admin on March 7th, 2009 2:43 am

    Hi Roon3y,

    You have to change the teams in fixtures sheet manually, because when you change the number of teams in initial setup sheet, it just limit the number of team which can play and show those teams in the standing table.

    Regards

  37. Admin on March 7th, 2009 2:45 am

    Hi Karim,

    You could read my explanation to Roon3y.

    Regards

  38. Admin on March 7th, 2009 2:49 am

    Hi Paul,

    I am in progress on making short tutorial on creating this league spreadsheet. I will publish it in a few days. You can learn it and if you have problem you can leave me comments.

    Regards

  39. Admin on March 7th, 2009 2:55 am

    Hi Sam and Faldo,

    To make it works for 4 teams, in initial setup worksheet, you can change the ‘data validation’ rule from menu or if you are looking the simple way, you can just copy a blank cell and paste it in cell B2, the cell where you have to put the number of teams to clear the data validation rule. After that you can put any number on that cell.

    Regards

  40. mark rooker on March 11th, 2009 7:16 pm

    I would i change to the following points system:

    Win=3
    Score Draw=2
    No Score Draw=1

    By the way, excellent template

    Mark

  41. Scott on March 20th, 2009 9:48 pm

    This spreadsheet is superb, I’ve used it for a couple of things, however, I have a major issue in terms of adding 2 extra teams, it’s fine with 20, but when I change the setting to 22 and add the 2 extra team names, I get #N/A in the team column and ### in all of the P/W/D/L columns, I’ve tried adding in 42 sets of fixtures but it does nothing with the data for the last 2 teams. Any Ideas/Similar Occurences.

    I’m using Excel 2007 if that holds any relevance whatsoever, thanks in advance.

  42. Tony on March 22nd, 2009 10:50 am

    I would like to change the conditional formatting,i need to unprotect the League Table worksheet as it is password protected
    Thanks.

  43. Bill on March 22nd, 2009 11:39 pm

    Great site, I love the Create Your Own Soccer League Fixture & Table… I’m actually looking for 1, a fixture program where you can select the number of teams, put in team names and select the number of rounds or weeks to be played. 2, I run a fantasy cricket league and would love something similar to the Create Your Own Soccer League Fixture & Table… for cricket, there are 6 teams in our comp and we play 5 day matches and 1 day matches. I have made something pretty basic in excel to add up scores and work out points and a ladder, but it would be awesome to have like your soccer one.

    Cheers

    Bill

  44. admin on March 29th, 2009 2:54 pm

    Dear Tony,

    There is no password protection in this sheet. You just go to menu protection and click unprotect. That’s all.

    Regards

  45. admin on March 29th, 2009 2:56 pm

    Dear Mark, Scott and Bill,

    I have just finished my tutorial on creating standing league table. You could read that tutorial to create your own or finding your mistakes on using this spreadsheet.

    Regards

  46. Andy on April 2nd, 2009 10:04 am

    Hi Great table.
    I admin a quiz league with 11 teams in each division.
    All works fine except the teams that don’t have any points do not show in the league table and I need them to.
    How do I get around this.

    Many thanks and a great job.

    Andy

  47. Dave Jackson on April 9th, 2009 1:12 pm

    You can get blank entries in the league table if the ranking formula returns > 20 in column B in the Settings sheet. This can happen when lower ranking teams have negative GD, or similar. To get round it, re-rank column B! In column A I put

    =RANK(B4,OFFSET($C$4,0,-1,$D$4),1)

    I used $D$4 to dynamically pick up the number of teams. Then change the formula in the League table sheet, column C to

    =IF(B6″”,VLOOKUP(B6,Setting!A$4:AC$27,3,FALSE),”")

    Nice spreadsheet BTW.

    HTH

    Dave J

    To get round the blank entries in the league table, alter as follows

  48. Ian Vella on April 23rd, 2009 4:33 pm

    Hi there … Excellent Template been searching for one like this for a long time ….

    Is there any way to link the fixtures directly to the names given in the Initial Setup?

    Because the first round and second round do not match (ex if first match in first round is juve vs Milan, 1st match in second round is not Milan vs Juve). And is there any way to make the league with one round on a neutral venue?

    regards Ian

  49. bora on April 29th, 2009 4:16 pm

    awesome! wish i could figure out how to use all the formulas.

  50. chasaaa on April 29th, 2009 4:54 pm

    is there any way to make the fixtures update

  51. Glenn on April 30th, 2009 2:12 pm

    Nice work but cant you create it that way so you the teams name in “Fictures and results” changes to the ones you entered?

  52. Mark Adams on May 6th, 2009 9:59 am

    I’m having the same problem with the teams dropping out of the League Table when entering the results. Dave, I have re-ranked the ranking in column B in Settings to Column A using

    =RANK(B4,OFFSET($C$4,0,-1,$D$4),1)

    but if I then change the formula in column C in the leagues tabel sheet as you describe above I just get an error :(

  53. YK on May 6th, 2009 12:54 pm

    Thank you so much. This saved me a lot of time.

  54. BOBBY1 on May 7th, 2009 8:29 pm

    Excellent work on this mate, very impressed.

    Thanks for the help, I will use this for a long time to come.

    Any chance of telling the password for the league table page. the sponsor at the top can stay, you deserve the credit for it, but I only need it to display the league standings, dont need all the home/away columns.

    Thanks again

  55. Fixtures List Creator | Excel Templates on May 9th, 2009 1:54 pm

    [...] I also completed my soccer standing table template with this fixture list creator function. So, if you need more complete excel standing table, you can download it here. [...]

  56. admin on May 9th, 2009 2:11 pm

    @Ian Vella : You can download the template version with automatic fixtures generator now.

    Cheers

  57. admin on May 9th, 2009 2:30 pm

    @ Chasaa and Glen : Fixtures list generator is available now to suit your needs.

    Regards

  58. admin on May 9th, 2009 2:34 pm

    @ Bobby : There is no password in that spreadsheet. You can modify it to suit your needs.

    Regards

  59. Andy on May 9th, 2009 6:45 pm

    Hi Dunno what all the fuss is about I did similar football tables back in the 1980’s using the old Microsoft Multiplan spreadsheet, seemed pretty easy to me at the time, certainly nothing difficult about it at all.

  60. Paul on May 11th, 2009 1:46 pm

    Hi,

    Great template. I have a question. If a team loses by 20 points or less they gain 1 point. What is the formula for this and where do I copy it?

    Thanks,

  61. jason on May 13th, 2009 3:14 pm

    A brilliant excel sheet, just the job, well thought out, thanks.

  62. joey on May 17th, 2009 2:37 pm

    i wanna make table.

  63. RoSKo on May 19th, 2009 12:04 am

    Man … on v1.1 when i add my teams … fixtures show only the program for one team :(
    In second i understand that you have to do manually fixtures … so ok.
    Can you help me with v1.1 … why there apears fixtures only for first team :X

  64. Mohamed Khattab on May 20th, 2009 3:16 pm

    thanks a lot for the fixture list generator you have made, but actually when i change the no. of teams to be 10 for example, all the fixture list goes away and only fixture list for one team (always the 1st team) is shown only. do u have any suggession.
    thanks again

  65. Allan on May 22nd, 2009 9:39 am

    Really awsome files, but a problem with the fixture list generator….

    As soon as you change the number of teams in competition, team 1 is allocated a complete fixture list but the rest only play against that team.

    Eg. If you switch the league to 10 teams then Inter Milan play all 9 of their games but the remaining teams only play Inter Milan.

    Can this be resolved?

  66. admin on May 22nd, 2009 3:06 pm

    Hi Rosko, Khatab and Allan

    May I know what Excel version do you use ? It looks normal from my Excel 2003 version. It could be the excel setting, but I am still looking for what cause that. If there are some people now how to solve the problem feel free to comments here. I will appreciate that.

    Regards

  67. Dave K. on June 5th, 2009 8:09 pm

    I’m having the same problem with the fixtures creator v1.1. As soon as I change anything in the setup team one has a complete fixture but all of the other teams have only two games against the 1st team listed. I’m using Excel 2002.

  68. Dave K. on June 8th, 2009 11:41 pm

    Just updated to excel 2003 and i’m still having the same problem

  69. Admin on June 10th, 2009 4:57 pm

    Hi all,

    Thank you for using my template, and I think I found what’s your problem on having just one team shown up. You should activate the analysis toolpak add-ins. Go to excel menu > tools > add-ins and tick the analysis toolpak.

    And all the function will work as expected.

    Regards

  70. Paul S on June 18th, 2009 8:18 am

    Gday Buddy,

    I have last seasons Premier League excel program and was hoping to just put in all the fixtures and venues BUT when I go to do so it says it is password protected. What is the password please. It was great for last season and I am very disappointed that the FA have told you not to do one this season, why what is it doing to them? They do not do anything like it. Thumbs down for the English FA. But the password would make my days at the office much better lol.

    You have my email address so I look forward to hearing from you.

  71. Cyclops on June 20th, 2009 10:35 am

    Great spreadsheet. This saves me a lot of late nights.
    I run a fantasy football league and have a workbook that you paste the weekly results (copied from the website) to the same location and using a cell to match the gameweek, this updates a league of historical info.
    For next season, using your spreadsheet and to make it more interesting, I would like to set up a head to head league for the fantasy managers.
    Via another additional worksheet that re-arrange my weekly pasted in data, I used Vlookup in the Fixture and Results to try and automate the score update. However, Excel does not match the cells for the name of the team using the formula in the cells but does when I copy over this formula with the actual cell value.
    Do you know why this is?
    Are you by any chance working on an automated score update of your own?

  72. Paul Butler on July 2nd, 2009 10:16 am

    Hi can i condense this workbook into 1 sheet i need to save this as a template to use on my website

  73. richard on July 7th, 2009 12:40 pm

    Hi Admin and Scott

    Did you solve the problem on using 22 teams? everythings ok for 20 teams but when i put an extra 2 in there the fixture list does not update. Can anyone help please. This template could save hours of work!

  74. Suzzy Mcallen on July 13th, 2009 9:26 am

    I also found 2 good templates:
    -League Table (soccer)
    -Champions’ League Fixture

    free-to download from http://www.spreadsheetzone.com

    enjoy,

    SSM

  75. Tayseer on July 18th, 2009 9:48 am

    Thanks a lot for this huge job

  76. Keng on July 22nd, 2009 8:51 pm

    I,m Want Excel Templates premier league fixtures v1.8 .Thank You

  77. Scunnered on July 26th, 2009 11:30 am

    I downloaded the OOo template and would like to know how I may add names to the sheet. I am attempting to register individual players names and scores.

    Where you show fixtures and results I would like to have the individual with his for and against score. I would only need to show Date Name Score and in the league Table Played Win Draw Loss for againts & points once.

    Is it permitted to alter your template anf is so how can I do it?

    Thanking you in anticipation

  78. Dionne Westwood on July 28th, 2009 11:50 am

    What is the most up to date version no please?
    This is awesome = thankyou for being such a genius and so cool to share it with us all
    Dee

  79. Greg Jacobsen on August 11th, 2009 11:01 am

    Hi,

    please could you give me the password to unprotect the template for the EPL league season for 08/09 season? I downloaded your new “open” one but its just not the same.

    please if possible, could you send it to me?

    Thanks and regards

    Greg

  80. john on August 13th, 2009 9:41 am

    Hi Mate ,

    please could you give me the password to unprotect the template for the EPL league season for 08/09 season? I downloaded your new “open” one but its just not the same.

    please if possible, could you send it to me?

    Thanks and regards

  81. Mohamed on August 15th, 2009 7:20 am

    Hi,

    Is there a general fixture the same for CUP/Groups league . Example 4 Groups of 5 teams

    Regards

    Mohamed

  82. Bernie on August 16th, 2009 5:14 am

    These are great spreadsheets, Thank you. I will be using the La Liga spreadsheet this season and I have modified a copy of it for the EPL and it works great.

    I saw you did a Euro 2008 in the past and I was wondering if you have ever considered doing a UEFA Champions League & Europa League from the Group Stage forward? I think it would be swell.

    Here hoping you do it.

  83. Tim Spark on August 20th, 2009 8:57 am

    hey mate how do i work the fixture list? It only shows one team when i put in all the teams…

  84. Tim Spark on August 20th, 2009 9:00 am

    thanks a lot for the fixture list generator you have made, but actually when i change the no. of teams to be 10 for example, all the fixture list goes away and only fixture list for one team (always the 1st team) is shown only. do u have any suggession.
    thanks again

  85. Keng on August 21st, 2009 7:57 pm

    I,m Want Excel Templates premier league fixtures v1.8 .Or password Unprotectsheet Thank You.
    kop22aal2003@hotmail.com

  86. admin on August 23rd, 2009 4:58 pm

    @Bernie: Champions League fixtures is coming
    @Tim Spark : You should activate the analysis toolpak add-ins. Go to excel menu > tools > add-ins and tick the analysis toolpak.

    Regards

  87. Aly Soberh on August 29th, 2009 9:01 pm

    Thimarafushi (Who has pretended that he did a auto league fixture generator{but he Downloaded a soft cpy frm thiz site} I have been searching for ur OLD tricks, hahahaha u got busted

  88. Paul on August 30th, 2009 8:28 pm

    Have been working through your formulas in order to work with 24 teams . . . have everything working except for the fact that the league table does not sort by rank. The rank is okay on the Setting sheet. Can you help?

  89. Jeff on September 2nd, 2009 3:30 am

    How can I use this template to create schedules? We have 24 teams in our league. Our season is 10 weeks long and there is more or less an “A” league and “B” league. Each team only plays once a week for a total of 10 games. Can I use this template to also create the schedules for all the teams?

  90. Chris Reid on September 2nd, 2009 11:39 pm

    Just come across your site when was looking for something of the SPL (Scottish Premier League) will there be anything available for this?

  91. Mac Mckernan on September 10th, 2009 3:29 pm

    Have just saved myself in the region of a weeks work developing my local 8-ball pool league for this year, by using your format.
    More power to your arm - and very many thanks indeed!

  92. rugbyhead on September 18th, 2009 2:36 pm

    Do you have on for rugby which could incorporate bonus points for scoring 4 tries as well as for loosing by 7 points or less? need one for league of 8 teams playing each other twice

  93. Claudio on September 20th, 2009 4:49 pm

    We organize a soccer league for 500 children in Muscat (Oman, Middle East). Your spreadsheet has been used last year and it will be use again this year, many thanks.

    Claudio
    MCFL Organizer

  94. KLUNZ on September 24th, 2009 6:07 pm

    Please, I want to password

    I want to design one to Libyan League

    xklunzx@gmail.com

  95. Neal on September 29th, 2009 4:43 am

    Hi,

    I am using your spreadsheet reguarly and really like it. I wonder if you might have any ideas of which excel function I could use to create a form table, i.e. a team that has WWWWW for thier last five games would be at the top compared with a team that has a WWWWL record etc. Any ideas how I might go about doing this, or can you help? I figured I should use the game week column and then for each team derive if it lost, won or drew. From there I can give it a score W=2, D=1 and L=0 and then added them add for the last five games to creat a ranking. The problem I have though is which Excel function to use to search within a game week for a team.

  96. alban on October 13th, 2009 8:44 am

    euroleague

  97. Chas on October 27th, 2009 11:00 am

    Great generator

    Is it possible to move fixtures about

    ie move a fixture from week one to week four etc

    Thanks

  98. Narvin Charles on November 23rd, 2009 5:29 pm

    I’ve been trying to get the performance graphs in the “League Table” tab however, I am not able to do so. Can you tell me how to.

    Thanks,
    Narvin

  99. Matt Davies on December 1st, 2009 9:31 am

    Hi there, cracking speadsheet.

    I am trying to add more than 24 teams, and have altered a few things, but can;t seem to get it to work properly!

    How do i do it please?

    cheers

    Matt

  100. Kev on December 12th, 2009 9:48 pm

    Hi,
    I wonder if you could help me with a small issue?
    Ive been using your template with great success over the last 2 months on a football project i help to run with the youth service. I found that it has helped the organisation of the night run sweet as a nut and we actually get to engage the youths instead of constantly working out the next round of matches so thank you.
    with 13 teams playing most weeks i have a slight issue with keeping track of a fuller league i.e your full competion is 1 night of footy. is there a way of collating the scores over 4, 8, or even 10 nights?

  101. RAY on December 19th, 2009 12:43 pm

    Hello,

    How do you change points for win to 4 and points for a draw to 2 on spreadsheet?

  102. Faisal on December 21st, 2009 2:05 pm

    Dear

    I’m waiting for the world cup 2010

  103. Volkan on February 2nd, 2010 2:02 pm

    I was expecting it to create a fixture after the teams are entered. That is where the difficulty is in creating your own league.
    Am I wrong or do I have to calculate it and enter one by one?

  104. Amit on February 12th, 2010 8:09 pm

    hello,

    i cant figure out how to increase the number of team.. sorry i am not good in excel, and cant find the logic inside as you mentioned above.. please help.. and yes its a great piece of work. ;)

    regards

  105. Mike on February 13th, 2010 11:58 am

    Hello.

    I am probably being stupid, but when I change the number of teams (I am trying to do a round robin with only 5 teams) the fixtures and results page only shows the fixtures for the first team and none of the other teams matches (eg Juventus v ac milan).

    Am I doing something wrong?

    Mike

  106. Carlos on February 15th, 2010 11:34 am

    Awesome job!!

    Are you able to create a tournament spreadsheet?

    In a champions league format?

    Cheers

    Carl

  107. Simon on February 22nd, 2010 4:53 pm

    One new feature you may wish to include is from a potential situation in the English Premier League. It is possible that Portsmouth United will go out of business during the season. If this happens, all games that Portsmouth have played so far this season will be void. I assume that if that happens, just deleting Portsmouth will work. What I want though is a way of temporarily deleting Portsmouth to see what happens to the table. Of course I can just make a new copy and delete Portsmouth if that works but it would be nice to have a neater solution. But fortunately this does not happen often.

  108. jacob on February 22nd, 2010 9:24 pm

    i need help getting on to making my football leauge set up. can you help me please

  109. jacob on February 22nd, 2010 9:30 pm

    i give up. do you know how to get it up for me

  110. jacob on February 22nd, 2010 9:32 pm

    do you know how to get it up.

  111. boosra on March 3rd, 2010 7:14 pm

    Hi, well done on the chart in most respects.

    Also though, you have infuriated a million people by the fact that until a team gets points they do not show up on the table at all.

    Need to fix that.

Leave a Reply