Sport tournament template

I created Excel templates for saving sports results. There are many variants of tournament: 3 – 16 teams in each group. The number of groups is not limited.

Each group is on a separate sheet. It contains a list of teams, the schedule and it automatically generates the table.

sport tournament

Settings – team names

For changing the team names just edit the table “Team name”. The changes will be reflected in the Schedule and in the Table.

Settings – points for a win, a loss and a draw

File contains sheet named Options. There you can set the points. The changes will apply to the entire file.

Settings – how to add more groups

In each file are 4 groups. If you want to add another group, copy one of the sheets and rename it (For example copy sheet named GroupD and rename it to GroupE). If you want to remove some of the group, just delete the group sheet.

Automatically generated table

You have to fill the score of each match and the table will be automatically sorted by number of points. There are no Excel macros, just an array formula and lookup function. The table calculates:

GP – Games Played
W – wins
D – draws
L – loss
GF – Goals For
GA – Goals Against
GD – Goal Difference
PTS – points

automatically generated sport table

Bonus/penalty points

You can give a bonus or penalty points to the each team. For example: team2 has 9 bonus points and team4 has 10 penalty points. This will be automatically calculated to the final table.

bonus penalty points

League schedule template

Template for 9 – 16 teams can be used as the league schedule. Rounds are separated in different color.

How to update and create more teams template

Do you need some modifications? Try it yourself :) There is the video guide how to update 3 teams template to 4 teams template.

 

Free download MS Excel files

3 teams in each group: sport_tournament_3_teams.xlsx

4 teams in each group: sport_tournament_4_teams.xlsx

5 teams in each group: sport_tournament_5_teams.xlsx

6 teams in each group: sport_tournament_6_teams.xlsx

7 teams in each group: sport_tournament_7_teams.xlsx

8 teams in each group: sport_tournament_8_teams.xlsx

9 teams in each group: sport_tournament_9_teams.xlsx

10 teams in each group: sport_tournament_10_teams.xlsx

11 teams in each group: sport_tournament_11_teams.xlsx

12 teams in each group: sport_tournament_12_teams.xlsx

13 teams in each group: sport_tournament_13_teams.xlsx

14 teams in each group: sport_tournament_14_teams.xlsx

15 teams in each group: sport_tournament_15_teams.xlsx

16 teams in each group: sport_tournament_16_teams.xlsx

Edit. 04/20/2014

I improved the formula so that it took into account the goal difference. Thanks Bert for inspiration. In the next few days, I will add other versions with a different number of teams.

Edit. 06/11/2014

The schedule has now 4 rounds. Each team can play with others twice as home and twice as visitor. So you can use this template for some kind of sport league (basketball, football, ice hockey, volleyball, …)

Edit. 08/28/2014

- 14 teams template added
- bonus/penalty points feature
- ranking improved -  if points and goal difference are equal, then ranking is based on goals scored
- schedule in 10, 12 and 14 teams template is now prepared to be a league – each round is separated by a color

Edit. 10/14/2014

- 9 teams template added

Edit. 11/13/2014

- 3 teams template added
- 11 teams template added

Edit. 12/05/2014

- 13 teams template added
- 15 teams template added

Edit. 01/23/2015

- 16 teams template added

Edit. 03/29/2015

- video help “How to update this template”

Add a comment »418 comments to this article

  1. Hi There, i was wondering, is it possible to add to the tournament pages an automated Knock Out stage too, or that would be too hard?

    ps…thanks very much by the way, they are brill and very useful a donation is well deserved.

    Reply

    • ps…I’ve made a small Donation, is not much but every little help they say :P

      Reply

  2. I am running a tournament and found your template on the net – and I have to say it is brilliant, well done.
    You don’t happen to have a version that allows for score draws and a draw do you? Or could you advise on how to add? I am running a tournament with two groups of 6 teams.
    Thanks loads
    Regards
    Graham

    Reply

  3. Hi,

    Could you please help me produce a table based for 18 teams?

    Thanks in advance.

    Reply

  4. hi i downloaded 14-team sheet but number of games played is not accurate. is there a way to fix it?? i am at the beginning of round 2 but number of played games stopped refreshing at 10.

    Reply

    • i was able to find a walk around fix – i my panes frozen just below the table. after i unfroze them and added results from around 14 number of played games got updated.

      i would appreciate if you posted a fix for this issues. thanks

      Reply

  5. Good Template, I downloaded the 16 teams template.
    The only thing i would change is the fact that team one plays 15 games “home” and in round 2 15 “away” switching between home and way every time is better.

    Reply

  6. How can I create 10 teams point table in cricket
    Like total 18 matches per team
    Top 4 goes in semi final
    And final
    Thanks

    Reply

  7. How do you do a forfeit match where two teams forfeit the match!??? Riko

    Reply

  8. How do you do a match where 2 teams forfit the match??

    Reply

  9. hi can you create a 17 teams in each group and 18 and 19 and 20 !??

    please

    Reply

  10. Hi, Great format. Thanks so much. I am trying to use this for our softball competition, but our top grade only has 4 teams and needs to play 6 rounds to complete a season. How do I get the Table to keep adding points for rounds 5 & 6?

    Reply

  11. I’m looking for a spreadsheet to create fixtures in a swimming league with 6, 7 or ‘n’ number of teams entering.

    Each team has one home gala against 3 other teams and will play against the other teams an even number of times or as close as. For a 7 team league each club would play the others twice in a season at various venues, once at home and three times at away clubs.

    So for a 7 team league the grid would have 7 columns and 5 rows – the top row being the header for each home gala and the rows for the lane numbers – 1 to 4.

    Is there a formula that would create a fixture list such as this that can be adapted according to the number of teams who enter each year?

    Regards
    Lev Baddley

    Reply

  12. This site is great.
    I am looking for Cricket excel score sheet. Please any one who can help to find one I will appreciate

    Reply

  13. How do you enter a win by default and award the team that won its points?

    Reply

    • Hello,

      Write the result of the match in the table called schedule. Points for win, draw and loss can be edited on the Options sheet.

      Reply

  14. Hi there,

    I am just wondering if I can save these files into my own folders? I would like to use the for my sport lessons but it says I do not have permission to save.

    Reply

    • Hi,

      you can use Save as in File menu.

      Reply

  15. Hi, this website is great. Just a quick question… sorry if it’s already been addressed.

    So each sheet has 4 rounds, how do I edit to just have 1 round without affecting any of the formulas??

    Reply

    • Hi Hannah,

      Send me an email describing a bit further what you mean and perhaps I can help you.

      support@enterexcel(dot)com

      Br,
      Joachim
      EnterExcel

      Reply

    • Hi,

      thank you :)

      You can easily delete these rounds. For example: select cells >> right click >> delete >> shift cells up

      Reply

  16. This template is perfect for an upcoming tournament bu how can I add it for 18 teams – any help really appreciated

    Thanks

    Reply

    • Christian,

      If you go to www(dot)enterexcel(dot)com you will find a template for 2 to 25 teams there.

      Br,
      Joachim
      EnterExcel

      Reply

  17. Hello, ive downloaded one 6 and one 4 a side template . This is awesome I am using for a table tennis tournament in my office staff of 24 people. Is it possible to get the password . thanks

    Reply

    • Hi,

      thank you :)

      Why do you want password?

      Reply

  18. Hi Was wondering if you were able to help me with my table, everytime i try to edit it, it doesnt work.

    I have two different comps therefore two different draws that i would require help with

    Thank you in advance

    Regards
    Cindy

    Reply

    • Hi Cindy,

      Joachim from EnterExcel here, if you want help please send me an email: support@enterexcel(dot).com with a description of what you need help with.

      (replace (dot) with . )

      Br,
      Joachim
      EnterExcel

      Reply

  19. I love the template, but would like to know if there is an easy way to adapt to my league’s 10 point system:
    6 = win
    3 = tie
    0 = loss
    1 point per goal UP TO 3 goals per game.
    1 point for a shot out (opponent left at “0″)

    So for example, Team A plays Team B, the score is 5:0

    Team A gets 10 points (6 points for the win, 3 points for the goals, 1 point for the shot out). Team B gets 0 points.

    Another example, Team C plays Team D, the score is 2:1

    Team C gets 8 points (6 points for the win, 2 points for the goals). Team B gets 1 point (1 point for the goal).

    Example 3, Team E plays Team F, the score is 5:5

    Both teams get 6 points (3 points for the tie, 3 points for the goals).

    Is there a way to adapt the point system to meet this criteria? If so, would you be able to create it? Thank you.

    Reply

    • Hi,

      I had the same problem. I’m using Bonus/penalty points section. It is not the best solution but it works :)

      Reply

    • Javier,

      Contact me through support@enterexcel(dot)com and I can help you make this template against a small donation.

      Br,
      Joachim
      EnterExcel

      Reply

  20. Hi Jan, is there by any chance a 20 team template?

    Reply

  21. Hi
    I Want Only Two Team And Rounds Seven So I did Try Create This But Not Rite !!! Can You Help Me Pls Thank

    Reply

  22. hi
    I Just Want Create Make Snooker Results
    Like When Red Potting 1 Points Then Next Colour Say Blue Potting 5 Points Add Up Make 6 Points
    See on TV Snooker Pro See Screen Results
    Hope You Know What I Mean ?
    Thank
    Michael
    Also I Did Send Your Email But Is Fail !!!

    Reply

    • Hi Michael,

      It might be my email you are referring too? I am not part of this web site (which belongs to Jan), however I help people in the comment section.

      If you wanna email me and give me an example of a snooker score, then I’ll try to help you out.

      My email is: support @ enterexcel . com

      And my web page is: www(dot)enterexcel(dot)com
      Br,
      Joachim

      Reply

  23. I would like to expand on the sports template and finding when I do add a column it compromises the formula; can you let me know how to work this out safely.

    Reply

    • Hello,

      where do you want to add column? What kind of column will it be? Do you need any extra calculations?

      Reply

  24. Hi – how can you add extra groups onto the same sheet without compromising the formulas? i.e. if you just want one sheet with groups A to H with 4 teams in each group.

    Thanks a lot.

    Reply

    • Hello,

      in one sheet you can’t. In one file you can :)

      Read part:
      Settings – how to add more groups

      Reply

  25. Thank you for this template! I added in a column for game times and weeks of play.

    This template is fantastic!

    Many thanks,
    Puck Heads Captain

    Reply

    • Thank you. I’m glad to hear that it is useful.

      Reply

  26. Hi Jonachim.
    Many thanks for your round robin programme which I adapted for a lawn bowls tournament run by our club recently, I also run a weekly league using excel but I have unable to find a formula in my table to keep and add to a running total of shots obtained each week by the members, I was hoping that you could advise me if this is possible.
    Jim.

    Reply

    • Hi Jim,

      Just to clarify, it is not me who run this web site, I am just helping people out in the comment section.

      If you send me an email with further details I can probably help you out.

      email: support@enterexcel_dot_com

      Br,
      Joachim
      EnterExcel

      Reply

  27. Hello,

    First and foremost, I would like to take this opportunity to thank you for all your hard work and efforts… they are much appreciated and noticed!!!

    It would be really helpful if you could please send me template of 30 teams with two games (2 rounds) each others only (home / away).
    I need all team 1 games will be in a row, team 2 will be in a row etc…

    Best regards,

    Idan Machal

    Reply

    • Hello,

      I won’t add any new templates. I have left the Excel world and I have no time for this. Therefore I have created the video tutorial “How to update and create more teams template”. May be someone else can help you. Joachim seems to be very talented and active in this :)

      Reply

  28. I have a question in regards to running a tournament that I have never ran before. I want to run a Cornhole Round Robin Type Tournament. I have 3 Teams with 8 players each, I want each team’s players to play the other team’s players, But, NOT play their own team mate! Is there a possible bracket out there for this?

    Reply

  29. Hi
    Can You Create For Snooker Scoreboard ?
    I Really Need This
    So Please Let Me Know Thank

    Reply

    • Michael,

      Send me an email with an example of what you need and I’ll try to work something out for you :)

      email: support@enterexcel_dot_com

      Br,
      Joachim
      EnterExcel

      Reply

  30. Hi,

    Congrats for your site its very good.

    I wonder if you could help me.

    I have a Round Robin Tournament with 18 teams, but they play 2 times (not agaisnt each other) in the same day.

    Can you help me out?

    Thanks,
    Manel

    Reply

  31. What would be great is to be able to dynamically set the number of games for a season. I was playing with it a little but it really seems to be set by round of playing one team each time per round. What I am trying to do is something like schedule a 7 or 10 team group with an 8 game season.

    Reply

    • Scott,

      Contact me through: support@enterexcel_dot_com and I can see what I can do for you.

      Br,
      Joachim
      EnterExcel

      Reply

  32. Hi,

    Are you able to do up a 17 team tournament draw ?

    Cheers
    Zac

    Reply

    • Hi Zac,

      If you go to my web page: enterexcel(.)com and go to templates, there you will find a template for 2-25 teams.

      Br,
      Joachim
      EnterExcel

      Reply

      • Thanks

        Reply

  33. A neighbour of mine has just inherited management of a local darts league and the format is 16 teams in four divisions, each playing each other once, then the league splits into two with the top eight playing each other once for promotion and likewise the bottom eight for relegation. At seasons end each team will have played 22 games. The league season has to be this short so as to fit in no less than three cup tournaments. Is there such a template for a league that “does the splits” as I’ve described. We’ve managed to organise this in the past, albeit in a bit of a long winded way, but is there a simpler way of doing it. No great shakes if not. This is really a shot in the dark.

    Reply

    • Hi Nigel,

      Contact me through support@enterexcel_dot_com and give a few additional details and let me see what I can do for you. I am on holiday now, but can fix this in beginning of August.

      Br,
      Joachim
      EnterExcel

      Reply

      • No worries, have just found out they are re-organising, and dropping the split format.
        Just as well, it looked like one of Baldrick’s “Cunning Plans”.

        Reply

  34. AHMAD SAIFUL AZLI July 13, 2017 at 11:14 am

    Hi. I Need format for 16 teams- Group A, B, C, and D – 4 TEAMS IN EACH-
    2 ADVANCE FROM EACH GROUP FOR QUATER, SEMIS AND THAN FINAL.

    please help me.

    Reply

    • Ahmad,

      I have a template like that available on my web page:

      enterexcel(.)com

      Br,
      Joachim
      EnterExcel

      Reply

  35. I have a tournament of 18 and 20 teams, would you send me to my email a template for 18 en 20 teams.
    Great Thanks

    Reply

  36. Hi,

    First of all thank you for the template, I was wondering if I could alter it a bit. I would like to add a new column to the table showing cards being collected per team during the season, however when I add a new column, the GP value does not increase when a new match is played. Is there a way to work this around?

    Thanks

    Reply

  37. I have to run a singles dart league for my non profit Royal Canadian Legion this coming September

    I could have anywhere from 24-36 players needed to do a complete round robin

    Keep wins, losses, draws, plus minus(like a goal differential)

    Is there a way to do this?
    Like if there is a sheet where I enter team/player names and it populates through sheet and schedule as well as the final standings?

    Reply

    • Hi Mitchel,

      I have a league like that for up to 25 players (2 to 25).

      It would be rather time consuming to make one that would be flexible up to 35 teams…

      Send me an email to support@enterexcel(dot)com and let us discuss what can be done.

      Br,
      Joachim
      EnterExcel

      Reply

  38. i need the templates for 20 teams, thanks

    Reply

  39. Need format for 8 teams- Group A and Group B – 4 TEAMS IN EACH-
    2 ADVANCE FROM EACH GROUP FOR SEMIS AND THAN FINAL

    Reply

    • Raza,

      Contact me through my web page on www(dot)enterexcel(dot)com or just send me en email directly at support@enterexcel(dot)com and I have the sheet you need. :)

      Br,
      Joachim
      EnterExcel

      Reply

      • Hi if i drop you an email van you send me the template as well please

        Reply

        • Sure Mike. Just send me an email at support@enterexcel(dot).com =)

          Reply

  40. Found this great excel sheet just too late :-) (1 week after our tournament)

    Great sheets and first tests are good.
    Just 1 question. How can I change the way the ranking is calculated.

    What i need is ranking based on :
    1. Most points
    2. if equal then : most won matches
    3. if also equal then : most scored goals
    4. if also equal then : Goals differance

    thx,
    Hans

    Reply

  41. Hi, how can I make a 2 teams template with endless number of rounds?

    Reply

  42. I really happy to find out this kinda spreadsheet exist. I am running a 12 teams Futsal tournament, and your spreadsheet is a great help. only one thing, can I please ask a favor from you.

    In my tournament, winning is 2pt, is there a way to edit so winning point is 2pt instead of 3pt?

    really really thank you

    Reply

    • GOT IT THANKS
      SORRY FOR NOT READING IT THOROUGHLY

      Reply

  43. I am wondering if there is a way to snake seed pools in excel for a tournament. if I were to have a master list of teams entered and have all of the pools, is there a formula that I can use to snake seed them into their different pools? Any help you could give would be much appreciated!

    Reply

  44. Hi

    We are starting a 17 team pétanque league and wondered if there was a template for this?

    Norrie

    Reply

    • Sorry but I can’t see the 20 team table on the free templates site

      Norrie

      Reply

      • Norrie,

        Send me an email at support_at_enterexcel_dot_com =)

        Br,
        Joachim

        Reply

        • Hi Joachim

          Microsoft email tells me that it doesn’t recognise the support_at_enterexcel_dot_com address and won’t let me send it.

          Norri

          Reply

          • Stupid me misunderstood you message – email gone now.

            Norrie

  45. My rank doesn’t work, please help me?
    I see this when tried to edit =AA3+AC3*10000+AD3*100000000

    Reply

    • Hello,

      rank is not intended for editing. Just edit Team names in the first table and score in the table below (round1, round2,..). That’s all.

      Reply

  46. please can you help ??
    need a league table for 17. do you have a template or can a 16 one be modified easily.

    Reply

    • Daz,

      I have one on my webpage you can download, just go to

      enterexcel_dot_com and go to “free templates”.

      /Joachim

      Reply

      • thanks for the reply. I have looked at the website but shows a table with 20 am i looking in the correct place?
        enterexcel.com

        Reply

        • It is for 1 to 20 teams. You just delete the team names 18/19/20 :)

          Reply

          • Hi joachim.

            could you send me the 20 team template please?

            tanks a lot

          • Hi Daniel,

            Sure just contact me through www(dot)enterexcel(dot)com

            :)

  47. Great job Jan! Tnx!

    Reply

  48. Great spread sheet.
    I have 2 teams from the same venue. Clearly they cant both play at home on the same day. How can I tell the fixtures to keep them apart?

    Reply

  49. Hi!, thanks for your work, I really appreciate.

    I have a tournament of 18 teams, would you send me to my email a template for 18 and 20 teams please!!

    Thanks in advance.

    Regards,

    Erick
    Guatemala

    Reply

    • Eric,

      Go to my web page on enterexcel_dot_com and you find a league template there for up to 20 teams.

      Br,
      Joachim
      EnterExcel

      Reply

  50. Hi,
    These are great…I have a request though if at all possible! I will hold a junior rugby tournament. Four teams of four so for the round robin phase within the groups they will only play each other once. Then they will move on to the knockout stage – do you have a template including knockout through to the Final..?
    Many thanks!!

    Reply

    • Andrew,

      Go to my site enterexcel_dot_com and send me a request there, I can help you :)

      Br,
      Joachim

      Reply

  51. Many thanks, indeed, very helpful tool and smart approach, I was going to design one in excel similar to the sheet concept you designed, but found your ready-made one even much better than what I planned to design…

    Big Thanks for making our life easier, cheers…

    :-)

    Reply

  52. Hi, is there a template where I could go to know-out matches after group phase? Thanks

    Reply

    • Rolando,

      I can help you if you go to enterexcel_dot_com and send me a request there :)

      Br,
      Joachim
      EnterExcel

      Reply

  53. Hi, great template. Just for the record, the formula for 16 team was not upadated. It still uses 15 team formula

    Reply

    • Thank you.

      I have checked it and 16 teams template is ok.

      Reply

  54. Fantastic resource, is there a 20 teams one available?

    Reply

    • willie,

      i have one on my webpage, 20 teams, up to 4x round robin.

      go to enterexcel_dot_com

      br,
      joachim

      Reply

  55. Hi,
    I just wanted to say these are very helpful. Thanks for sharing.

    Reply

  56. Hi
    i want to use this template for a junior tournament but want 4 pools in each sheet – group A (pool 1, pool 2, pool 3 and pool 4). can this be done.

    Reply

    • Hi Deena,

      I could probably help you with this. Contact me through www_dot_enterexcel_dot_com and please add some further details to your request.

      Br,
      Joachim

      Reply

  57. Hi,

    I’m using your 5 team template for a football game with friends.

    Is there any chance you have a template which has two rounds of fixtures (Home and Away)? So there would then be 8 rounds altogether?

    Thank you.
    Jordan.

    Reply

    • Jordan,
      I have a sheet like that on my webpage for free.

      Go to enterexcel_dot_com and you’ll find it under “spreadsheets”

      Br,
      Joachim

      Reply

  58. HI, I am organising a dart league with 30 singles players.Games will be player 4 times a week for 3 months. Players will be split into groups of maybe 6 per day. Do you have template for 30? Can fixture be done for each session separately? Thanks for your help

    Reply

    • Hi Que,

      Contact me through enterexcel_dot_com and I’ll help you there.

      Br,
      Joachim
      EnterExcel

      Reply

      • hi i have tried contacting you via (www_dot_enterexcel_dot_com ) but its not going .
        thanks for sharing your excel football tournaments with us, i just need your help
        after the group stage how do i continue the tornament(round robin) pleas help

        thank you

        Reply

  59. hello, is that possible for a template with 48 teams like UEFA europa league??
    table/fixtures/goals etc.

    Reply

  60. I create a few spreadsheets myself and I’d like to know how you get the table to auto sort so the leaders are in correct order as scores are updated. I’ve looked at the formulae and cannot copy and paste or replicate them.

    Reply

  61. Can you edit the points ?
    For example
    i want to do this as a darts group. with 2 rounds.

    example we play 6 legs and every leg is worth 1 point.

    if you draw 3-3 each player gets 3 points. no bonus points

    if you win 4-2 the winner gets 4 points plus 1 bonus point for winning and the loser gets 2 points.

    any chance you could edit this for me please with a 5 player and 4 player version.
    if not i can input the points manually.
    thank you

    Reply

    • Yes, you can. There is sheet ‘Options’. There you can edit points for win, draw and loss.

      Reply

      • But the sheet is pass protected and we can’t get in.

        Reply

        • Joe/Bruce,

          Just contact me on enterexcel_dot_com and I will make the sheet as you want (with the flexibility for points per win, draw etc).

          Br,
          Joachim
          EnterExcel

          Reply

        • Yes, sheet is protected. You can edit only the cells containing points (B2, B3, B4).

          Reply

  62. Hi, I would like to continue adding matches. I tried changing the range for the GP in cell “V3″ “V4″ “V5″ and “V6″ but it came up with an error. Can you please help with this. Thanks

    Reply

    • Hi Marcus,

      Contact me through my web page: enterexcel_dot_com and tell me how many teams in your league and I’ll help you add that option to add matches.

      I do already have a sheet for up to 20 teams and a 4x round robin there, that you can download.

      Br,
      Joachim
      EnterExcel

      Reply

  63. I have a request.
    Il possible, like NBA, make a championship with 2 groups but same tournament.
    I try to explain better with my bad english…
    I have West Conference and East Conference: 2 group with 2 different ranking, but the teams play all together.
    West vs West 2 times. East vs East 2 times. West vs East 1 time.
    All in the same excel sheet.
    After that, of course, play-off.
    Is possible?
    Thank, I appreciate your work.

    Reply

    • Hi Matteo,

      I understand your request, I could probably make the sheet. However, how many teams in each division? And knock-out rounds start with round of 16, quarterfinals, semis?

      Please go to enterexcel_dot_com and send me a request there, so I get your email, more convenient way to communicate than through this page.

      Br,
      Joachim,
      EnterExcel

      Reply

      • Now, we have one group of 9 and one group of 8.
        Is possible that all 17 team play the same number of match?
        For the final stage can be quarter final or semifinal. I can make that manually, don’t worry.<
        now <i will make the same request at enterexcel_dot_com.
        Thanks

        Reply

  64. Hi

    Could you make a template for 32 people and 28 people and 24 people please.

    This is an excellent resource by the way!

    Thanks

    Kris

    Reply

    • Kris,

      Contact me through enterexcel_dot_com and go to “tailor-made sheet” and send me a request there with a bit more details (single vs double round robin, desired point system etc) and I’ll help you.

      Br,
      Joachim
      EnterExcel

      Reply

  65. IF YOU ARE LOOKING FOR A LEAGUE OR TOURNAMENT SHEET JUST CONTACT ME THROUGH MY WEB PAGE:

    ENTEREXCEL_dot_COM

    I PROBABLY ALREADY HAVE THE TYPE OF SHEET YOU NEED, OTHERWISE IT IS HIGHLY LIKELY THAT I CAN MAKE ONE FOR YOU.

    I HAVE ALREADY HELPED SEVERAL PEOPLE HERE.

    Cheers,

    Joachim
    EnterExcel

    Reply

  66. Is it possible to edit the score sheet to add a forfeit column? Local touch comp plays;
    Win: 3
    Draw: 2
    Loss: 1
    Forfeit: 0
    Many thanks for advice.
    Bek

    Reply

    • Bek,

      So you want to be able to set a match result as forfeit? Will both teams get 0 points then? Do you want to show number of forfeits in the League table as well? Does it add to matches played in the League table?

      Br,
      Joachim

      Reply

    • Hi Joachim,

      The team that forfeits gets 0 but the team that is forfeited against receives 1 point.
      The number of forfeits each team has declared would be good to have in the table. Forfeits do not need to be counted in the games played.

      cheers,

      Bek

      Reply

      • Hi Bek,

        Ok, thanks.

        So how many teams in this comp?

        /Joachim
        EnterExcel

        Reply

        • Hi Joachim,

          We have 10 ladies teams and 10 mens teams.

          cheers,

          Bek

          Reply

          • Ok, thanks.

            I will look into this at the beginning of next week. Is that ok or do you need it quicker? I haven’t made a sheet including a forfeit option before, but should be too much hassle.

            Br,
            Joachim

          • Bek,

            I have made a sheet for you that should work.

            You just insert “FF” for the team that forfeited and “0″ for the team that won on walk-over and it will give 1 point to the walk-over team.

            Contact me through enterexcel_dot_com -> tailormade sheets, so I can get your email and send you the sheet.

            Br,
            Joachim

          • Hi Joachim,
            I’m not sure whether the address you gave is an email address or web address in order to give you my email address….I’m not computer savvy at all…
            cheers,
            Bek

          • Hi Bek,

            No worries, it is my web page. It is not possible to link to other web pages here without the administrator approving it, therefor I wrote _dot_com

            On my web page there is a link in the top right corner where you can send me a request and then I will get your email and send you the excel spreadsheet.

            The web page is

            www.
            enterexcel.
            com

            Br,
            Joachim

  67. Good Morning.

    I am creating a online gaming football league. I would like to add to the templates but not sure how to.

    So where you have Team Name I would like to add “Player” and “PSN” content. So for example Team 1 would be

    Team = AC Milan Player = Jason Flint PSN = jaseflint17

    And I would like this info to be linked and also be displayed in the tables.

    Regards.

    Jason

    Reply

    • Jason,

      I’ll help you. Go to my web page and send me a bit more details for what you need: number of teams, rounds, standard points, ranking system etc.

      My web page is enterexcel_dot_com and go to “feedback” section there.

      Br,
      Joachim
      EnterExcel

      Reply

  68. Hi,
    i am busy organizing a cricket tournament, so that we can help kids find something to do instead of just wasting their time on the streets. I’m inviting 20 high schools, and it would be held over the space of a weekend. Now, the 20 high schools would be divided into 4 groups of 5. Each team plays each other once in the group with the top 2 qualifying for Gold Quarter Final Section. Teams 3 and 4 qualifies for the Silver Quarter Final Section, with team 5 being knocked out unfortunately. After the Quarter Finals there will be a Semi-Final for each section and likewise a final for each section. We will be having scouts at the tourney and hopefully they can spot a few sport stars of the future.

    i came across your templates about a year ago, and find them to be the best (imho) i have found on the web. If anyone can create this, i know you can…I wish you the greatest of success in your life and may only the best of doors open for you in the future.

    regards
    Khaled

    Reply

    • Hi Khaled,

      I can probably help you make this sheet and upload it to enterexcel_dot_com when I am done. However, I need you to answer a few questions first as I am not familiar with cricket.

      How do you rank teams that end up with equal points?

      What kind of league table format will you need: Is “Played Wins Draws Losses Points” enough?

      How do you select quarter-final opponents? Group A winner vs Group B runner-up, Group C winner vs Group D runner up etc. or do you have a more creative format in mind?

      Br,
      Joachim
      Enter Excel

      Reply

      • Hi

        If you are from the US, Cricket would be similar to Baseball with totally different rules lol.

        There generally aren’t Draws in Cricket. There are…but very rarely, win/lose/draw should be fine – 3-1-0 being the general standard, but we can add an extra dimension we can say…for every 10 runs scored, We can give a 1 point bonus. So if team A vs team B and team A wins the match, they would get say 3 point and because they scored 100 runs they would get an extra 10 point giving them 13 point in total, team B lost in a close encounter, scoring 98 runs, so they would get no points for the loss but still get 9 points because they score 98 runs.

        Group A winner vs Group B runner-up, Group C winner vs Group D runner up etc, would be fine to select the Knock Out Rounds.

        Regards
        Khaled

        Reply

        • OK, thanks I will make a sheet where the point system is based on 3 points for a win, 1 point for a draw and additional 1 point per 10 runs completed.

          Antything else I should take into consideration?

          Br,
          Joachim

          Reply

          • Hi

            Nothing i can think of at the moment. Thanks for all the help.

            Regards
            Khaled

          • I have made a sheet now, I will upload it to

            enterexcel_dot_com, under “Spreadsheets”.

            Should be available within an hour or so.

            Please contact me through the “Feedback” option on my webpage with errors you find or changes you wanna make.

            Br,
            Joachim
            EnterExcel

  69. Hi, making round 2 having problem link cells I’m using excel with office 365. I don’t find it how to link the cells. please help me
    Thank You

    Reply

    • What do you need? How many teams, how many rounds, is it for a football league?

      Go to my web page and send me a message there: enterexcel_dot_com

      Br,
      Joachim

      Reply

  70. Have you ever done a 19 team schedule. We wanted to do a 4 game guarantee but after the 3rd game they are seeded in a place to play their 4th game and go to semis from there. However every way we do it someone plays an extra game….. any help would be awesome

    Reply

    • Please send me a message on enterexcel_dot_com (links not allowed here) and explain further.

      I could most likely help you, but I don’t really get what kind of league/tournament you are looking for.

      Br,
      Joachim

      Reply

  71. Great templates! I was hoping you could create a schedule for 4 teams, playing twice per week, for 10 weeks. The games can be random over the 10 weeks as long as everyone plays everyone equally!

    Reply

    • Hi Christyne,

      So each week team 1 plays two matches against two (unique) opponents, i.e. team 1 vs team 2 and team 1 vs team 4, but never team 1 vs team 2 twice in the same week?

      Br,
      Joachim

      Reply

      • Exactly!

        Reply

        • OK, I can fix that on Monday.

          Br,
          Joachim

          Reply

        • Christyne,

          Maybe I am tired, but isn’t it impossible for a team to meet the 3 other teams equally when you play 10 rounds and each team playing two matches per round?

          That means 20 matches (10 rounds with 2 games) and the only solvable way is that a team plays two of the other opponents 7 times and the last opponent 6 times. So you either have to adjust the number of rounds (9 rounds and 12 rounds work) or make each round consist of 3 matches.

          Br,
          Joachim

          Reply

          • You’re right… let me get back to you! We may just have the teams play each other 6 times and do something else with the remaining slots.

          • Hey J, the rounds don’t matter, as long as each team gets the same amount of games. So it doesn’t matter if one team only plays 6 times against another team. Does that make sense?
            Christyne

          • Yes, it makes sense then. I can make one as I said. Is it 3 points for a win, 1 point for a draw, 0 points for a loss?

            In terms of ranking criteria, I will apply the following ranking order: I) Points II) Goal Difference III) Goals scored, IV) Internal matches points V) internal goal difference VI) internal goals scored and VII) pre-season rank/”lottery”

            Br,
            Joachim
            EnterExcel

          • I have made the template now, please go to enterexcel_dot_com and leave me a message under the feedback page, so I get your email and get send you the file.

            Br,
            Joachim

  72. Hi,

    Do you by any chance have 1 with 17 teams and 1 with 18 teams? 2 rounds are also enough. Thanks

    Reply

    • I am making one for you know. How is it with points, just standard 3 poitns for win, 1 point for a draw and 0 points for a loss?

      I will upload it to my website: enterexcel_dot_com

      Br,
      Joachim

      Reply

      • Hi,

        Standard like your other Templates is fine. Points can easily be edited. It’s teams that is hard to add. Thanks in advance

        Reply

        • On that site you have a superb 18 team double round! We usually do 1 round and I could remove the extra rounds. But on those sheets cells are protected. Can you upload either both 17 and 18 team sheets unprotected or with single round?

          If not the standard ones like the above are also fine thanks

          Regards

          Reply

    • Have uploaded the 18-teams double round robin now.

      I have randomized the matches. If you would like a defined setup like team1 vs team2, team3 vs team4 etc or just choose matches yourself, let me know.

      League table is ranked by the following order:
      1) points
      2) goal difference
      3) goals scored
      4) internal points/goal difference in matches between teams in question
      5) pre-season rank (which you can manually enter in column D)

      Let me know if it works ok.

      Cheers,
      Joachim

      Reply

      • Hi,

        I just seen this post. I had asked for double round just in case we decide to make 2 rounds. Like I said I usually delete the second round but the cells in your new sheet is protected. Can you please upload an unprotected version of 17 and 18 teams? or make them single round?

        Thanks

        Reply

        • I have uploaded it now to the same page, good luck =)

          Br,
          Joachim

          Reply

  73. Hi just came across you template and was wondering if you would be able to change to 20 teams 10 weeks.
    Thanks for your help I am trying to put this together for the American Legion cribbage league.

    Reply

    • I could perhaps help you, but how does it work with only 10 weeks?

      /Joachim

      Reply

  74. Sorry, meant also to add, I am organizing a Foosball tournament. Each team will play each other once, each match is best of 5 sets. I want the points to be awarded based on no. of sets won, so for example if Team A beats team B 3-2, Team A gets 3 points, Team B gets 2 points. Tied teams in the table will be ranked on Set difference

    Reply

    • I can probably fix one you. Let me look into it tomorrow.

      Br,
      Joachim

      Reply

    • OK, I have made one for you.

      26 teams
      Single round robin
      1 point per win in best of five
      Randomized order (let me know if you need a specific round order)

      Will upload it to enterexcel_dot_com, under “spreadsheets”

      Br,
      Joachim

      Reply

      • Cheers mate

        Reply

        • Thanks but I need a password. Do I need to make a donation to get this ?

          Reply

          • Complete the form on the webpage, so I get your email and can send you the password.

            Donate if you feel for it =)

            Cheers,
            Joachim

  75. Hi, great spreadsheet. I don’t suppose you have a template for 26 teams by any chance ?

    Reply

  76. Can you make a basketball one

    Reply

    • What kind you looking for?

      /Joachim

      Reply

  77. Hi

    Is it possible to get one with added data for leg scoring as well as goal scoring so 4 columns of inputs? If not is it easy to edit?

    Reply

    • Hey, do you mean like columns showing “home” and “away” stats?

      Br,
      Joachim

      Reply

      • hi

        my tables have 6 columns plus the usual pl won etc

        so P W L LF LA LD GF GA GD PTS

        Where you imputed the goals for each match i.e 3.2 and it caculates a win with 2 points i need to add data to LF LA and caculates LD as well.

        so a fixture for me would be

        team 1 v team 2 i would imput 4 values games for and against and legs for and against and table sorts by most points .

        its a pool league

        Reply

        • Hi again, I am not following you completely on your request. Is there anywhere on the web where I could see an example of what you are looking for or can you manually type in an example here?

          Br,
          Joachim

          Reply

          • this is from a dart league..basically what u have already done but two extra column in results to imput extra dada for legs scores

            http://www.trentvalleydartsleague.co.uk/downloads/stats/winter-2012/tables.pdf

          • I replied with link but didnt go said need moderation

            table would look like this

            P W L LF LA LD GF GA GD PTS

            on the fixtures where you input the result i looking for

            team 1 6 4:3 3 team2 the 6 and 3 are added to the LF LA columns and 4:3 are added to the GF GA column as tbey are now. and PTS as tbey are now. im assuming it knows the win buy the greater number.

          • So if match 1 ends like this:

            match1 team1 5 4 3 1 team2

            this would be the league standings?

            p w d l LF LA LD GF GA GD points
            team1 1 1 0 1 4 3 1 5 1 4 3
            team2 1 0 0 1 3 4 -1 1 5 -4 0

          • bit difficult to type here

            MATCH RESULT

            TEAM 1 10 5:3 6 TEAM 2

            TABLE WOULD BE

            P W L LF LA LD GF GA GD PTS
            TEAM1 1 1 0 10 5 +5 5 3 +2 2
            TEAM 2 1 0 1 5 10 -5 3 5 -2 0

          • Ok, then I get the structure, but what is the point of showing this LF LA LD score and will it be used for any calculations of league standings, i.e. after points, goal difference and goals scored?

            Sorry, I am not into the rules and point systems of pool leagues/tournaments.

            /J

        • Hi yes it will

          The table sorts in the following criteria

          MOST POINTS THEN IF TIED THE FOLLOWING IS APPLIED LD (GREATER NUMBER) THRN LF (GREATER NUMBER) GD (GREATER NUMBER) GF (GREATER NUMBER)

          Reply

          • Trying to fix it now :)

            /Joachim

    • HI

      YEH THATS IT JUST SEEN YOURS .. :D

      Reply

      • How many teams in the league and does each team play the other teams once or twice?

        /Joachim

        Reply

        • 9 at present

          Reply

        • 4 times long season

          Reply

      • Go check it at my website:

        enterexcel_dot_com/spreadsheets

        Let me know how it works out.

        Br,
        Joachim

        Reply

        • enterexcel_dot_com/spreadsheets.html

          Reply

          • Hi – Yes pretty good. Prob i got is i need to manually move the fixtures around so they in current order. On the blank one on here i managed to edit the fixtures copy and pasting to correct weeks.

            A lot of fixtures get moved from original weeks due to 2 teams at one venue etc and 1v2 3v4 etc i cant match up. Other than that its really good.

            I did forget one thing – The total points (pts) is 2 for a win plus the GF so for example a 5-4 win would give team 7 points in total.. its a sum of GF PLUS GW (2 POINTS)

            Is it possible i can manually move the fixtures and if so how do i dontate for your time.

            Its really good though.

          • Hmm let me think a bit on how to solve the customised fixtures issue.

            The point system is easy to fix.

            Can a match in some way end in a draw or should I remove it from the league table?

          • No there is no draws at all.

            I tried going down to the fixture further down to imput the result but it came up as points scored but no games played . maybe cos i didnt do it in order. If i was generating the fixtures its no problem but fixtures are already done and all over the place. I dont have these to hand atm but they chop and change weekly.

            great work many thanks.

          • Ok, so I fixed the point thing. And I will remove draws from the league table.

            Just to make sure, if someone in theory would win 100-99 then they would get 102 points, 100 in GF, 99 in GA and +1 in GD?

          • THATS ITS YES

            THE LOSING TEAM WOULD GET 99 POINTS AS WELL .. ITS A POINT PER GF AND TWO FOR OVERALL MATCH WIN

            SORRY CAP :D

          • Regarding the fixtures issue. I mean by the end of the season all players will have played each other 4 times. So the list of fixtures in my sheet is correct, right? Just not in correct order?

            I see two easy solutions and two a bit more tricky:
            1) If you have the fixtures you could send them to me and I could plot them in (of course that doesnt help if a game is postponed)

            2) I could add another “highlight player/team” option so it is easy for you to find a specific matchup and enter scores for that one and then you could enter the date/venue in the “notes” cell

            3) I could just make the “matches” section blank and then you select from a dropdown menu which players faced each other and plot in the score. And I could add summary section where you could see the total of games each player has played.

            4) I could expand the “matches” section and make you just cut/paste matches up and down in in

            Not sure if any of these alternatives solves your problem?

          • Hehe ok, so I made it harder than it was, cause you are saying that basically all GF = 1 point, no matter if you won or lost that match.

            So basically just sum up wins + GF to find total points over a season.

            If you won 3 matches and scored 25 GF during a season, you end the season with 3x2p + 25p = 31p, right?

            /Joachim

          • HI, yes i dont mind either way if i have to insert the matches played each week (drop down) or copy paste thats fine with me. they chop and change all the time. If possible rather have it in a nice neat line all the way down.

            Yes thats right 3 wins 6 points plus the 25 GF during those 3 games. Sorry im not good at explaining myself

            Heheh

          • Sorry i just tried that imputting a result on week 11 housten v new york and the stats went in the table but no win loss recorded? Is that cos i did it in wrong order?

          • Ok, I’m uploading a new version now. Check the same page again.

            Let me know if it is ok now. I made it so that the drop-down menu will be alphabetically sorted.

            I also removed draws from the league standings. And if you put a match as a draw now, it will just add the GF for each team that played that match.

            /Joachim

          • Ok, the newest version is uploaded :)

            /Joachim

          • Strange with your problems when inserting data in round 11. I seemed to have the same problem when I have the file locked, but when I unlock it, everything seems to be working correctly. I’ll check it out =)

          • that my friend is absolutely stunning. I cant thank you enough!

            I did make one mistake on table sorting :(

            Sorry Its PTS THEN LD (HIGHER NUMBER) THEN LA (LOWER NUMBER) I SAID IT WAS A GREATER NUMBER. THEN LF GREATER NUMBER.

            Its fine though ive taken up enough of your time.. I will donate through the main site? is that right.?

          • Please explain sorting/ranking once more, so I get it hehe. Was a bit unclear.

            If matched ended like this:

            Team1: 3 1 2 4 :Team2

            Would it be:
            Team2 6points 1W 0L 1LD 2LF 1LA 4GF 3GA 1GD
            Team1 3points 0W 1L -1LD 1LF 2LA 3GF 4GA -1GD

          • NO THE POINTS ETC ARE FINE THATS PERFECT…HEHHE – ITS THE TABLE CRITERIA IF POINTS ARE TIED.

            SO TABLE SORTS

            PTS IF TIED OF PTS FOR EXAMPLE 2 TEAMS ON 10 POINTS

            THEN WE GO

            LD (HIGHEST NUMBER)
            LA (LOWEST NUMBER)
            LF (HIGHEST NUMBER)

            TO DETERMED THE POSITION

            I MADE A MISTAKE ORIGINALLY I SAID LA WAS HIGHEST NUMBER IT SHOULD OF BEEN LOWEST NUMBER

          • Ok, I get it.

            But then lowest sum of LA overall (all games)

            or

            only lowest LA or sum of LA in the matches between the two players in question?

          • LOWEST NUMBER OF LA OVERALL.

            SO ITS

            PTS
            LD (HIGHEST)
            LA (LOWEST)
            LF (HIGHEST)

            tinyurlDOTcom/zfnn6zx

            TEAM 1 1 1 0 24 5 19 8 1 10
            TEAM 2 1 1 0 25 6 19 8 1 10

          • EVEN MADE A MISATAKE WITH THAT SCREEN SHOT LOL

            LA IS SMALLEST TO LARGEST

          • tinyurlDOTcom/gn6sbwj

            TRY AGAIN

          • Ok, it was a bit tricky actually to implement a min value to the overall scoring, but I think I found something that works now.

            I’ll upload a new version within 2min, so check the page and see if it works correctly.

            Luckily, since I had to double check now, I found an error in the scoring calculation, a minor one, but still, good to realise and now that error is corrected.

            /Joachim

        • oh yea thats super..thank you so much!!!

          amazing i only wish i could work excel in this way

          please send me your paypal email for donation

          my email is
          clockgifts9atgmail.com

          Reply

          • Glad to hear, let me know if you find any errors. First time I am making any pool related spreadsheet. If there are mistakes I will fix them and update the file on the webpage.

            If you would like to donate, then you’ll find a button on the enterexceldotcom home page. I would be happy to receive even a dollar, but that was not my motivation for helping you :)

            Have a nice evening and merry xmas.

            Br,
            Joachim

          • ive just found the button. I can’t thank you enough..I spend 2 hours a week doing these standings and i make mistakes with adding up etc.. ive just done a weeks worth of games in 2 mins..omg

            merry Christmas also. I will send something to you.

            fab

      • Hi

        Sent you an email

        Thx

        Reply

  78. Does someone have a 24 team template they can share??

    Reply

    • Hi Ben,

      What kind of sheet do you need? Just a standard league with 24 teams, two matches vs each team?

      Br,
      Joachim

      Reply

    • Anyways, Ben – let me know if you need one. I have made one with 24 teams with a double round robin.

      Options include team names, pre-season rating (to solve if two or more teams have equal points, goal difference, goals scored and internal results) and points given for win, draw and loss.

      I also have one with 20 teams if anyone needs.

      Br,
      Joachim

      Reply

      • Please sand to me 20 teams I need it .

        best regards

        Yousef

        Reply

        • Hand me a email then :)

          /Joachim

          Reply

          • could you please send me a 20 team format. please.!!!

      • HI JOACHIM.

        COULD YOU SEND ME THE 20 TEAM YOU HAVE PLEASE !!

        Reply

      • SEND ME 20 TEAM FORMAT PLEASE !!!

        Reply

        • Yes, Daniel. No need for caps lock ;)

          Go to enterexcel_dot_com and send me a message through the “Tailor-made sheet” form and I will get your email.

          Br,
          Joachim

          Reply

  79. Hi,
    Can you please add 5 locations ,3 time slots and Minor officials to the sheet.
    Thanks,

    Reply

  80. Hello there,

    Is there anyway we can change this to prevent teams playing at a certain time? For example team A cant play before 7pm and Team B cant play after 9pm?

    Any help would be great but this schedule is awesome!!

    -Scott S

    Reply

  81. Hi,

    Wondering if you could help I’m looking for a League for 4 teams to play each other 10 times.

    Win 3pts Draw 2Pts and lose 1pt

    Also Bonus points of the following
    Win by 5 goals or more with clean Sheet 2pt
    Win by 5 goals or more without clean sheet 1pt
    Lose by 5 goals or more without scoring -1pt

    Can anyone help..

    Reply

    • Steffen, you still looking for help with this?

      Br,
      Joachim

      Reply

  82. I AM TRYING TO ADAPT tournament_6_teams.xlsx SO that Group A and Group B are on the same page I only need 1 round for each group and I am trying to get the fixtures and 2 tables 2 show within the same view.
    Ive tried cutting and paste and special paste but I am missing something

    Reply

    • Hi, I have a different sheet that you could use for this purpose if you like? It is customised to have up to 8 groups of maximum 10 teams in each. Teams play each other once.

      Let me know if you like to check it out.

      Br,
      Joachim

      Reply

  83. Hi.

    Is there any really clever fixture schedulers out there as really struggling to get my head around the following:
    I have 7 teams and want them to play two other teams each week obviously one team having a free week etc I wish them all to share being the hosting team but also ensure they play each other twice.

    Is this as solveable problem Help would be greatly revived

    Reply

  84. Hi there, Really nice. Did it with a 5 team 1 round tournament. However looking for a knockout template now for when the top 4 teams go to the semis. Can you assist?

    Reply

  85. Hi, Please send me a fixture format for 32 Draw for individual open tournament.

    Thanks

    Rhamanan
    Singapore

    Reply

  86. Hi Jan
    I have a basketball champioship with 15 teams.
    Every week 1 team has time off.
    Also i know the special key number for each team.
    Please inform me how I can create a template?
    Many thanks in advance.
    Spiros

    Reply

    • Hi

      is it possible to use this template so that teams play an equal amount of games on four rinks?

      Thanks
      Bri

      Reply

  87. Hi, this article was very useful but if i want to create a graphic view of a flowchart depicting the scheduled tournament draws, how should i go about it?
    please suggest something

    Reply

  88. I am looking at format where we have 17 teams. 3 x group of 4 and 1 group of 5 with the best 8 teams qualifying for QF matches and all 3-4-5th group places playing a losers match based on their worst average points per match obtained

    Reply

    • Did you get any help doing this? :)

      Br,
      Joachim

      Reply

  89. Hi,

    I’m also looking for a 18 team template. Have tried several time to add to the 16 table but keep making mistakes.

    Thanks

    Reply

    • Hey, I could easily fix this for you if you are still searching for this type of sheet.

      Br,
      Joachim

      Reply

  90. Hi, this is really awesome but I’ve been having terrible time and time again to add more teams to a template, can you please add 18, 20 and 24 team sports tournament template please????

    Reply

    • hi,
      did you get any answer for 24 teams template?
      regards

      Reply

      • if you still need it, I have one I can send you per email.

        Br,
        Joachim

        Reply

  91. I have simple 50 team template scored on a stopwatch – I am ‘highlighting’ in the upper corner the fastest times – showing 1st 2nd & 3rd – any suggestions would be great

    Reply

  92. Hi

    Can you help me win 2 tables and then with knock out stage in same tournament table please

    Thanks

    Reply

  93. Hi

    I have a tournament coming up.
    12 teams in 2 groups – playing each other once
    Top 4 of each group (points then g/d) go to a quarter final knock out, then semi, then final etc.

    Can you help with that please?

    Reply

  94. Hi, could you possibly create an 18 team template for download please.

    Reply

  95. This template helps us a lot in the tournament. Great Help!!!

    Reply

  96. good templates thanks

    Reply

  97. Hi

    The template is very useful and thanks for this. I have a question -usually when one team doesnt arrive at the field they loose a game by 2-0. What happens if two didnt arrive of course they both will loose points but how can i put it into your excel sheet.

    Reply

    • Hi, using this for a football league , need to award match as a “home win” but no goals . Cannot seem to work out how to do this so that “Games Played” adds up correctly for all teams , can anyone help ?

      Reply

      • So David, you need a standard league with double round robin just with an option to set a game as home win w/o any goals? I assume it will still count as a regular win, awarding the home team 3 points?

        How many teams in your league?

        Br,
        Joachim

        Reply

      • Need to set for either H – W (home win) or A-W (away win) both no goals . League has 6 Divisions ranging between 8 to 10 clubs in each .

        Reply

        • Hi David,

          Could you just please try to show me an example here, for example one match and how the table would look after. Would it for instance look something like:

          Match 1:
          Team 1 vs Team 2 HOME_WIN

          League standings after match 1:
          1) Team 1 Played 1 Home_Wins 1 Home_draw 0 Home_losses 0 Away_wins 0 Away_draws 0 Away_Losses 0 Points 3
          2) Team 2 Played 2 Home_Wins 0 Home_draw 0 Home_losses 0 Away_wins 0 Away_draws 0 Away_Losses 1 Points 0

          Sorry for the broken formatting, but not so easy with this comment section.

          If it looks anything like above I could probably fix it tomorrow

          Br,
          Joachim

          Reply

          • I meant on the league standings:

            Team 2 Played 1*

          • Hi Joachim
            Sorry for length of time replying however ended up manually altering tables until end of season . My issue was that when a team defaults and does not play a game , I have to award the game (ie the 3 points , without awarding any goals. Problems are that if I have a match (Team A V Team B ) and Team B default , if I enter Home_Win in results columns it gives the points to TEAM B , should be Team A. I have discovered that if I enter Walk_Over in results columns then it awards Win,Loss &Points correctly , but does not show the game as PLAYED for either team. Please see example below after one game with Team B defaulting .

            Premier Division GP W D L GF GA GD PTS
            Team A 0 1 0 0 0 0 0 3
            Team B 0 0 0 1 0 0 0 0

            I use 5 separate templates for 5 Divisions , number of teams is either 10 or 12 in each Division
            Thanks
            David

  98. i know i am not lazy cos i have spent hours and hours trying to work it out but i am not very excel savvy i used this template last season for 13 teams but it has now grown to 18 teams can anyone work out this template as is for 18 teams for me it would be greatly appreciated

    Reply

  99. hi
    tks for this share as it helps
    i’d like to know how i can open it on numbers from mac .
    as the function not work apparently you got password .
    i’d like to work it on my number so i can show it on my tv for our tournament a numbers it’s better for the graphic
    tks
    pascal

    Reply

  100. Hi thank you very much this excel template is great. Please add the template which will go up to the final stage.it working well for us. God bless you.

    Reply

  101. Hi how do i remove the significance of goal difference and allow goals scored to take priority?

    Reply

  102. We have 14 teams that play each other once a week which means they play for thirteen weeks….our problem is we have played our first matchs starting with team one vs team two (1v2) and (3v4) (5v6) (7v8) (9v10) (11v12) (13v14)…but now we can’t figure out the next twelve weeks making sure each team meet the others only once…….can you figure this out for us ?

    Reply

  103. I have created a 22 team league with team by team records using the method in the video above. I would like to upload it to this site as a thank you so others can use a 22 team structure if they so desire. Thanks.

    Reply

    • Hi, would you mind sharing it by email? I am looking for a 22 teams league template. Thank you.

      Reply

      • Hello. Sorry about the late reply. You can email me at m.haigy@googlemail.com and I’ll attach a 22 team excel file if you like.

        Cheers.

        Reply

    • Hi, Can you please share your 22 teams template??

      Thank you!

      Reply

  104. Does anybody know how to add extra rounds? I’m looking to add at least another 6 rounds.

    Reply

  105. Hi
    I Want To Know How Do Automatic Draw Then Put In The Four Groups (A,B,C,D) ??

    Thank You

    Reply

  106. Hi,

    I see Mariana Yarnold requested for a 20 team template, I was hoping there would be a download link for the same as I am chasing the same too, would you be able to please forward this template to me?

    Kind Regards
    Macwin Fernandes

    Reply

  107. Hi, any chance you can provide one of these for 20 teams? I am rubbish with excel. THANKS!

    Reply

  108. Thank you so much for doing this – this is awesome ! Saved me hours of work doing the kids football league tables.

    Reply

  109. Odlično delo. Moti me edino, da ekipe niso razporejene po krogih takoimenovanih “Bergerjevih tablicah”. Ali je to mogoče spremeniti.
    za 9 ali 10 igralcev
    Kol Pari
    1 1:10 2:9 3:8 4:7 5:6
    2 10:6 7:5 8:4 9:3 1:2
    3 2:10 3:1 4:9 5:8 6:7
    4 10:7 8:6 9:5 1:4 2:3
    5 3:10 4:2 5:1 6:9 7:8
    6 10:8 9:7 1:6 2:5 3:4
    7 4:10 5:3 6:2 7:1 8:9
    8 10:9 1:8 2:7 3:6 4:5
    9 5:10 6:4 7:3 8:2 9:1

    Reply

    • it there a template for a two division league

      Reply

  110. Template is great – just found it
    Are there any that include a bye for an odd no of teams with potential for points for the bye?

    Reply

  111. can you add Cup and Plate knockout competitions for the 16 team version? Semi finals & Finals that reference 1st and 2nd place in each group would be great!

    Reply

  112. hi, could you post a 18 team version, please

    Reply

    • Second this. Great template and was using the 16 player. Bossman then added 2 more players. Tried tweaking the spreadsheet myself to deal with this but bit out of my depth. An 18 player sheet or an adaptable one for x number of players would be fantastic.

      Reply

  113. 8 ball pool comp goes 14 weeks 11 taem s names 4 players. 3 difrent venues. 1venue 4 tables 8 teams 2 venue 2tables4 teams next venue 2 table 4 teams is there sckedule avalable just new at this thanks for your help

    Reply

  114. Hi,
    Is it possible to have the first tie breaker be the team with the least GA?
    Thanks!

    Reply

  115. Is it possible to have the first tie breaker be Head to Head? i did a mock run up and it had team 3 ahead of team 2 in the standings even though team 2 beat them. i assume you have it set for goals for as the first tie breaker.

    Reply

  116. Thank you for building this, it saved me a huge amount of time. I had to modify things a little bit to make the schedule run horizontally instead of vertically (as preferred by league members), but you did all the heavy lifting. MAC, Songtan Si Dart Association President.

    Reply

  117. Lawn Bowls matches have three rinks and there are 2 points on offer in each rink. The Team that scores the most (shots) gains a further 4 points. Maximum of 10 per match. Win two = 4 points but gain the most (shots) on the day = 8 points ‘Losing team gets 2 points for the rink they did win.
    Problem: How can this be formatted to give points to each team in the points column.
    John

    Reply

    • Hi,

      read the “Bonus/penalty points” section. There is what you want.

      Reply

  118. Hi, can I please get the password to the protected options sheet. Thanks

    Reply

    • Hi,

      I’m sorry you can’t. Important cells are unlocked.

      Reply

  119. Thank you, so much for this, it really helped me make my tournaments successful.

    Reply

  120. Hi there.
    Fantastic sheets.
    I wanted to discuss how to add an elimination phase after the group phase: so when the winners & runners up of the groups then meet.

    Reply

  121. Brilliant and God bless!

    Reply

  122. This is amazing!! THanks.

    What’s the password to unprotect the OPTIONS sheet?

    Reply

  123. I’m trying to create a 20 team league where each team plays 16 games. Can anyone help modify this file for that?

    Reply

  124. Would it be possible to use scores for the points to generate the table as follows
    Team 1 scores 16 Pts playing team 2 who score 4pts.In a game we play for a total of 20 pts .therefore the table would be
    Team 1 16pts
    Team 2 4 pts

    Reply

  125. Hi Jan,
    I’m using the 14 and 16 team templates and recently upgraded the 16 team to 18 team with the help of your video.
    Great work and thanks for the effort.
    Wayne
    Torquay, Australia

    Reply

    • Hello,
      can you please send me the 18 team tournament table to my email?

      Thanks and best regards,

      Leo

      Reply

  126. 1.I want a competition of 16 teams divided in to two pools of 8 teams each
    2.Each pool will have games played on a home and away basis
    3.Each team will play a cross over match once against each other team in the opposite pool

    16 teams in two 8-team divisions, where each team plays the other 6 in its division exactly twice, and plays each team in the other division exactly once.

    Reply

  127. Hi Jan.
    Is it possible to create a fixture list with 13 teams, playing matches with 4 competitive teams in each match?
    Every team has to meet all the other teams once at home…

    Thank You in forward.

    Reply

  128. 1.I want a competition of 14 teams divided in to two pools of 7 teams each
    2.Each pool will have games played on a home and away basis
    3.Each team will play a cross over match once against each other team in the opposite pool

    14 teams in two 7-team divisions, where each team plays the other 6 in its division exactly twice, and plays each team in the other division exactly once.

    I searched the web and got the attached result but not helpful.,if you dont mind in assisting the teams are below

    Region A Region B
    1.KCB 1.Kabras
    2.Strathmore 2.Nakuru
    3.Mwamba 3.Impala
    4.Homeboyz 4.Nondies
    5.Western Bulls 5.Harlequins
    6.Mean Machine 6.Blakblad
    7.Thika 7.Sharks

    Reply

  129. Hi , how do i adjust it for 9 teams?
    Reply me soon.

    Reply

  130. Hello,

    I am trying to create a double header schedule with 14 teams,each team plays 2 games vs a different opponent and each team has the same number of early, middle and late games approximately.. The sport is basketball and we have 2 courts. The league only plays on 4 sundays and each team only gets 4 games, so they wont even play everyone once. It would be great to have the doubleheaders back to back or with only one game in between. Any suggestions. I really need help. Thanks

    Reply

    • i just sent a question about doubleheader schedule, i mistakenly put that teams will play 4 games, they will each play 8 games. thank u

      Reply

  131. Hi
    I Have an idea for tourneys. Say you Have 12 players Which you give a number. Lets Say there will be 4 players on each team. Lets Say in game one nr 1-4-6-10 is to play 2-3-8-9. In game 2 the rest (5-7-11-12) meets a random draw of the other numbers.
    What i mean here is that there are no teams, but just players. Players that are on winning teams the most will win the tourney.
    There are 2 tings to consider, a random draw of numbers, mening that there are new teammates for every game and that all players play the same amount of game. Is this possible to do in excel? Takk for any help

    Reply

  132. Thank you very much for the table sample very useful just the right one for my local street tournament

    Reply

  133. Is there a template for 20 teams? I tried using the video but is too time consuming

    Regards,

    Mark

    Reply

  134. Will be using it for our tournament.
    Thanks!

    Reply

  135. 16 Teams error
    $18,
    Options should be $19

    Reply

  136. How would you do the template for 18, 20 & 24 teams IN A LEAGUE?

    Reply

    • Hi,

      I have just uploaded the video guide how to do that.

      Reply

      • where I can’t find it?

        Reply

        • Hi,

          It’s above in this article. Section: How to update and create more teams template.

          Reply

  137. Jan.

    I’m in Prague ad have a need for excel for 61 teams that divide into wo groups later.

    Could you help me if I hireded you please.

    Mark

    Reply

    • Hi Mark,

      thank you for your offer. Many people want me to do some modifications in my templates. I’m sorry, but it’s not possible. I have some other projects and Excel-example.com is only for fun. However, there is a solution :). I created the video guide that explains a lot. So, anyone can update this template now.

      Regards

      Reply

  138. Looking for template with unbalanced groups.
    Group A and B with 5 teams , Group C and D with 6 teams

    Reply

    • Hi,

      If it’s not necessary to have it in 1 file, you can use 5 teams and 6 teams template.

      Reply

  139. What I was looking for but for 8 teams, there should be 14 games each (7 home + 7 away).

    Template gives 16 games with all teams duplicating two matches???

    Reply

    • Mystifier,

      Can you expand on your comment which requires clarification

      The 8 team template can be used for 2 rounds of 7 games each for teams giving them 14 matches (7 home and 7 away). How does the template offer 16 games? The other rounds are optional.

      Ray

      Reply

    • Hi,

      I checked the template and it is OK. It gives 7 games per ROUND for each team.

      Reply

  140. I’m looking to create a league table & fixture list for a nine team ice hockey league. Which will need home & away fixtures, goals for & against, two points for win & none for a loss & one point for an over time loss. Could you recommend a way of doing this, please?

    Thank you

    Reply

  141. is there a calculation to look at the row that see the gd is under 7points an awards the bonus points and also looks at a row that if i put in so i not how many goals are scored will award the bonus point on each round though

    Reply

  142. Hi,
    I love your template, but is there a way to make it for 6 rounds, not just four? I’m not good with Excell so I tried to copy/paste but it no longer caluculates.
    Thanks Kristal

    Reply

    • Hi,
      the formulas are complicated. Simple copy and paste is not enough :( Unfortunately, I’m not going to create more than 4 rounds templates, sorry. But I’m preparing the video instruction how to create/update my templates. So then, you or somebody will may be able to create what you want.

      Reply

      • Hi Jan,
        Do you know when you will put the video instructions on line, we love your template but need it to have 9 rounds.
        Kelly

        Reply

        • Hi,

          video guide is online :). I hope it helps you.

          Reply

  143. GRACIAS POR SU TIEMPO…

    Reply

  144. Good day

    I am looking for 6 teams in one group playing each other twice?

    Regards

    Reply

    • Hi,
      you can use the template: 6 teams in each group. There are 4 rounds but there is no need to fill all of them. You can use only the first 2 rounds.

      Reply

  145. Wow! Thank you so much for this, Jan. I am currently running a 33-team FIFA tournament at the boarding school I teach at, and I love the template, but am not sure how to alter it to make it 33 teams. Any tips or advice? We are trying to make it so each team plays 16 games, not every team once. Those 16 games will just be against random opponents. Thanks for taking the time to do all that you have done.

    Cheers,

    Carmine

    Reply

  146. Thanks Jan for adding the 16 teams template.
    You are a legend.

    Regards

    Reply

  147. Dobrý den, máte prosím soubor pro 20 týmů? Děkuji :)

    Reply

    • nebo alespon navod prosim, posilam Vám malý donate za to co už používám je to super díky! ;) Ale potreboval bych pro 20 mužstev :/

      Reply

      • Dobrý den,

        o šablonu pro 20 týmů si píše více lidí, takže se do ní asi pustím. Nedokážu ale říct, kdy to bude :) Nicméně chystám video, kde bych chtěl ukázat, jak podobnou šablonu vyrobit/upravit. Potom ji třeba vytvoří někdo dříve než já.

        Reply

  148. Hi,
    This is a great spreadsheet and saved me a lot of hassle to get to this stage.
    Are you intending to add a facility for semi finals and finals at all?
    I am organising a small squash tournament where there will be 2 groups of 6 with the top 2 of each group going to a semi final for the “cup” and the bottom 2 of each group going to a semi final of a “plate” and it would be good to show this progress too on the sheet…I will probably be able to put together something, but wondered if you had considered this? Thanks, Jeff.

    Reply

    • Hi,
      I was thinking about finals, semi finals, quarter finals, … when I was creating the first template. There is a lot of combination how to schedule play off, so I decided not to do it. I think there are a lot of templates for play off, just try use google :) If someone finds the nice one, I will be glad to place the link here.

      Reply

  149. Good day

    Anyone that can assist.

    We have a football league with 2 groups of 6 teams each. each group plays home and away. That’s the 1st round.

    In 2nd round the 1 group play the teams in the other group once only. It work out that teams will play 3 home and 3 away in 2nd round

    Is there a fixture example of this type of tournament

    Thanks

    Roy
    Roy.volkwyn@gmail.com

    Reply

  150. Hi Jan,
    Wondering if you can add a template for 16 teams as this is the number we have in a lawn bowls tournament we run in Torquay Australia. We also have 3 groups of 14 teams and your template is perfect for the draw and ladders for these groups.

    Regards Wayne

    Reply

    • Hi Wayne,

      there it is. I have just added 16 teams template.

      Reply

  151. Hi there, one thing i cant figure out and i hope you can help me, how did u setup the sheet so that the table (H3:P8) automatic sorts/rank/arrange? You did it without using the methods such as “auto filter” or “converting it to a table”, which i find ugly with the drop down links over the data. And i can’t seem to find a written “macro” ether, please share how u did it.

    Thank you.

    Reply

    • Hi Gavin,

      there is the hidden table in the S – AB columns. It contains auxiliary calculations for GP, W, D, L, … There is also the rank column that is important for final sorting. The visible table uses only lookup functions like INDEX and VLOOKUP to place data in the right order. I tried to do this as simple as possible so I decided to not use macros. However, there are some very complicated formulas that are made as an array formula.

      Reply

      • TY! And great work! Really awesome sheet!

        Gav

        Reply

  152. can yu tell mi wich formulas use, , becasu I trying to create groups like you but doesn’t work.

    Reply

  153. Have to say a massive thanks for creating this! it was a insanely helpful base for starting a score tracker for a primary school football tournament that I have run for 200 children!
    Thanks again – Chris

    Reply

  154. Hi Jan, this is great stuff.
    I can use this for a Lawn Bowls social tournament in Torquay, Australia.
    We have 4 groups. 3 with 14 teams and 1 with 16 teams.

    Are you likely to add more downloads for 16 and more teams in the future?
    Wayne

    Reply

  155. I am after a league table set up for a snooker league.

    Although it will show wins and loses the points will not be worked from them. The will be for Frames won and lost.

    Example Team A V Team B
    Team a win 5 frames to 3. Team A will get 5 points and Team B 3 points. Team A still get a win and Team be a loss.

    Also can it be done where putting players names in gives them a point for winning there game?

    Thanks

    Reply

  156. These are great thanks. I am wanting to use goal percentage (goals for divided by goals against, times 100) rather than goal difference but I’m not sure how to change it. Are you able to show a way to modify this? Cheers

    Reply

    • Hi,

      it’s easy. Just write the new formula next to the table. For example =M14/N14*100 for Pirates in the picture above.

      Reply

  157. Jan,

    Sorry to ask again.

    Any chance of a template for 13 teams?

    Ray

    Reply

    • Hi Ray,

      there it is. Templates for 13 and 15 teams. Can I ask you, what sport are you scheduling?

      Jan

      Reply

      • Jan,

        Not so much a sport but fantasy dice competitions

        Ray

        Reply

  158. hi
    I tried a 10 team template today with 4 pitches avaliable. That didn’t work out. Is it possible to make a template where you can adjust setup for x numbers of pitches? I could have made my tourney and split the teams into 2 groups. But, then, to make everyone meet each other I have to manually set up these games. So, a template where you could deside on number of pitches would be rally nice. Thanks.

    Reply

  159. Jan,

    In addition to Kevin’s request of 19 November for a template for 15 teams, would it be possible for fixtures for 13 teams aswell?

    When you have the time of course.

    Thanks

    Ray

    Reply

  160. hi! possible to include 15 teams? I’ll be happy to donate via paypal… thanks in advance!

    Reply

  161. Jan,
    These tables / leagues are fantastic. Please could you point me in the direction of the one that has 3 points for win, 2 for score draw, 1 for no score draw and 0 for a loss.
    Many many Thanks

    Reply

  162. Jan,

    Apologies for asking again.I imagine you are busy but would it be possible to add a further template for 11 teams when you have the time?

    Thank you

    Ray

    Reply

    • Hi Ray,

      I’m not busy, I’m lazy :)
      Here it is.

      Jan

      Reply

  163. I need a template for futsal. Only one pitch would be used and I need one for 3 teams and one for four teams. Would that be possible?

    Reply

    • Hi John,
      You can use 4-teams template and 3-teams template I have just created.

      Reply

  164. Jan,

    Just one more request from myself.

    Would you be able to include a template for 11 teams?

    Most grateful if you could.

    Your updates so far have been excellent and have greatly enhanced the site

    Ray

    Reply

  165. Hi would like to use these spreadsheets for a futsal comp. In my comp the first couple of games there could be some swapping of teams in divisions – how can I do this so the teams keep their points from previous games?

    Reply

    • Hi, it’s simple. Points from previous games write in the Bonus/penalty points section.

      Reply

  166. Is it possible to have a sheet depending on how many fields you are playing on? If you look at the sheet above with 4 teams, saying you only have one field then the second game should be the two teams not playing the first match, agree?

    Reply

  167. nice sheet, but i can’t use it on galaxy tab. The table colum is all “value” Tell me how to use it, please

    Reply

    • This template uses advanced formulas and it is designed for MS Excel only. It may not work correctly in other programs.

      Reply

  168. How can i add another round of fixtures for template with 4 teams. we play in a league of 4 teams and 5 rounds in which we play with each other once for each round. there are only 4 rounds in the template, can anyone help? thank you

    Reply

  169. Hi we do a soccer league in which we have 4 teams and each team plays each other so thats 3 games and we do this for 5 weeks so 5 rounds. How do i add another round? on the 4 team template there are only four rounds but id really appreciate if someone could help me figure out how to add another round.
    thanks.

    Reply

  170. Jan. Have adapted your programme for an indoor bowls club running various leagues of differing numbers of teams but we are desperate for a league for 16 teams. Can I adapt one of your existing league programmes or could you write one to accommodate 16 teams

    JohnHansford

    Reply

  171. Can you do up for 20 teams versing each other once

    Reply

  172. Can you do a template for 20 teams versing each other once?

    Reply

  173. Fantastic spreadsheet. Thank you very much.

    Would you happen to have one for 9 teams?

    Reply

  174. Jan,

    Thank you for the improvements which offer more scope for people running leagues.

    The bonus and penalty point facility is particularly important and welcome as it makes for unlimited points options

    Improved ranking of tables has enhanced accuracy.

    As templates go, it is ideally self-contained allowing for a league to be updated on one page as it were.

    I am sure others will echo my opinions of this excellent site.

    Ray

    Reply

  175. Is there anyway you could make a league that works on win percentage? Some of us would play more matches than others and we still want to know who is the best…by calculating win percentage it is fair but I have no idea how I would go about that?? Please help!

    Reply

  176. hi,

    I am trying to duplicate this but to my specification. I can’t seem to get the formula:

    =SUM((home=V3)*(homescore>visitorscore),(visitor=V3)*(visitorscore>homescore))

    to work. even if i try and manually enter home, homescore etc into the formula.

    any help will be appreciated.

    thanks

    Reply

    • Hello,
      do you enter this as an array formula using CTRL+SHIFT+ENTER?

      Reply

  177. do you have a template for 14 teams

    Reply

  178. Thank you so much for this wonderful spread sheet. I am using it at school for school tournaments and class matches

    SOMETHING TO IMPROVE:

    Can you re arrange the fixture to be in a way that NO ANY TEAM GOES INTO THE SECOND GAME UNTILL ALL TEAMS HAVE PLAYED THEIR FIRST GAMES.

    Reply

  179. Jan,

    Are you now in a postion to consider my upgrade suggestions of 30 June? These excellent and useful templates would be enhanced if you could:

    1-provide templates for 14 and 16 teams
    2-include a penalty point deduction facility and
    3-able to rank teams on goals scored if points and goal difference are equal

    These appear to be the main ideas put forward by those who have offered comments.

    Ray

    Reply

    • Hello Ray,

      I was busy in my other jobs and I needed a little break from Excel. Now I’m back and I will try to improve this template to be super fantastic :) I want to thank everyone for inspiring suggestions.

      Reply

  180. Hi,
    This template is almost perfect for a cribbage league I am running.
    In my league each cribbage match will play 3 legs so the score will be 1-2, 2-1, 0-3, or 3-0. Is there a way to give a bonus point to any player winning 3-0?
    e.g.
    0 points for loss,
    3 points for 2-1 win,
    4 points for a 3-0 win.
    Would be more than happy to donate if you could help me with this in any way.

    Regards, Pheobe.

    Reply

  181. Thanks for the spread sheets, daughter using for carnival, so thanks again.

    Reply

  182. Jan,
    From what people have suggested, it seems that the 3 major additions to this excellent template would be:

    1-template for 14 and 16 teams

    2-penalty point deduction

    3-ranking based on goals scored if points and goal difference are equal

    Ray

    Reply

  183. Can you provide a template for 14 teams

    Reply

  184. Wondered if you could assist with a 14 team sports tournament?

    Reply

  185. Great job!
    May I suggest to put a e.g. “Fair-Play” column in which fault are counted and used rank in case of equal points?

    Reply

  186. Hi,

    Many thanks for providing this template. Are you able to adapt this template so that if points are equal and goal difference are also equal, then the ranking will be adjusted based on goals scored?

    Many thanks

    Reply

  187. Hi, This is great for my son’s footy tournaments. I that saw you had a message on 12th May 2014 regards changing the formulae to take into account 2 points for score draw and 1 for 0-0 draw. I have seen other spreadsheets that enable amendments to be done to the points tally by adding or subtracting a point. The other sheets called them penalty points. Could that be incorporated, if you haven’t been able to amend as per the request yet? If you have amended, could you let me have please.

    Reply

    • Hi, thank you for your comments and suggestions. I have received many requests same as yours. So, it’s time to do some more upgrades. I think I’m able to improve the formula and settings as you requested. Stay tuned :)

      Reply

  188. How can adjust after 2nd round

    Reply

  189. I want to Calculative Chart huge data made a format which is provide me financial report

    Reply

  190. template is fantastic,
    how can i adjust it from 10 teams single to home and away matches please
    regards colin

    Reply

    • Hi, I have done some updates. Now you can use up to 4 rounds (2x as home, 2x as visitor).

      Reply

      • thank you jan your a star.
        worth a donate thank you

        Reply

  191. Hi,

    i need an excel spreadsheet for two day tournament for one group containing 5 Teams.
    Do somebody has any?

    thnx and regards.

    Reply

  192. great template. I am using the ten teams for a bowls league but the only problem is that they play each other both home and away. Any ideas how I can modify it to allow for this. I really appreciate your efforts.

    regards

    Allan

    Reply

  193. Thanks these are great.

    Is it possible to change the scoring system as we want it to calculate 2 points for score draw and 1 for a 0-0

    Reply

  194. Hi

    Great speed sheets this help with planning our fixtures and tables for our Football tournament. Only is want change the scoring so it two points for score draw and 1 for 0-0 how is this possible?

    Reply

  195. Hi, this template is amazing. How can i change it for 3 teams championship and make it a lot of rounds? Thanks

    Reply

  196. great worksheet just need to be able to schedule for 15 rounds for 4 teams. Any easy fix??!!
    Cheers

    Reply

    • Thanks :) 15 rounds for 4 teams is some kind of league. This worksheet is primary for tournament that contains groups and one team plays with other only once. However, I have plans to create template for a league. But it will take some time.

      Reply

  197. Hi, I have finally done the corrections in formulas. The table is now sorted by points and goal difference and I plan to create another versions with a different number of teams. I would like also create a template for the league. So stay tuned.

    Reply

  198. Can somebody upload excel with 4 teams in each group, home and away leg (6 matches for one team) or to show me how do i need to do that?

    Reply

  199. Dear sir, thank you very indeed for your sharing, it is really useful for our league which we don’t know how to record it easily.

    I wish you success all the time with your career!!!

    Best Regard

    Vatey

    Reply

  200. Hi,
    Could you do up a template for 13 teams please. I am hopeless with excel and tried to add an extra team on your 12 team but had no success.
    Kind regards,
    Jonn

    Reply

  201. Hi and big thank you for this template. I do have a problem, though.

    I need a schedule help. I have 4 teams in a group, but need to make Home and Away leg. So 2x 6 games. I don’t know how to modify table array to “add” and count the second leg.

    Any help is appreciated.

    Reply

    • My specific problem is that in your W cells you have:
      =SUM(($AG$3:$AG$8=V2)*(ISNUMBER($AH$3:$AH$8));($AK$3:$AK$8=V2)*(ISNUMBER($AJ$3:$AJ$8)))

      I tried to increase that array for 2nd leg and another 6 games. I widened array but I always get #VALUE! error and I don’t understand why.

      I basically need this:

      =SUM(($AG$3:$AG$14=V2)*(ISNUMBER($AH$3:$AH$14));($AK$3:$AK$14=V2)*(ISNUMBER($AJ$3:$AJ$14)))

      But changing 8 to 14 keeps giving me error. Even visually the array seems fine. What am I doing wrong?

      Reply

      • Ok, I managed to deal with that problem. I was stupid enough to press Enter when changing formula, instead of CTRL-SHIFT-Enter. Now that works. But…

        When I enter result in 2nd Leg now, main table recognizes it as a Played match, but other cells don’t. Home and Visitor scores are not calculated, points too. Not sure where can I edit Home and Visitor functions to increase their array on the expanded table.

        Reply

        • Ok, now I’m spamming. :)

          I figured it all out and modified the table. Everything is working now except sorting on goal difference…

          It will sort the teams on points but if two teams have same points, the table won’t compare goal difference so it can happen that -3 will be above +2.

          I believe it’s all sorted in formula:
          =X3*Options!$B$2+Y3*Options!$B$3+Z3*Options!$B$4

          I just don’t know how to include another function that would first sort by points and if points are equal then it would sort by GD (column AC in my table).

          Thanks. And sorry for spam, but this is the best sheet (out of 20 I tried) and I’m putting some efforts in it. :)

          Reply

        • Hi Zero,

          How did you manage to change the 2nd leg which is the win, draw, loss and points different. I can’t seem to change the Home and Visitor function? Can you show us how is done

          Reply

  202. Hi the Sports template is great but I need one for 14 teams is this possible to do
    Thanks
    Mike

    Reply

  203. Hello everyone,
    thank you for your comments. I will try to improve the template to reflect the goal difference. Then, I plan to create a new version that will be able to do more (thanks Ray for inspiration). Please be patient.

    Reply

    • An easy way to make a ranking on points and goal difference is the following:
      multiply points by 10000
      multiply gd by 100
      make a ranking by this results
      greetings

      Reply

  204. Jan,
    A good sporting template in that the league table appears on the same page as the results. However, Hassan Abazari is correct to state that the goal difference problem needs to be resolved as outlined in his post of October 13th.
    Are you able to:
    1-ensure teams/players with the same number of points are separated by goal difference and not alphabetically as appears to be the case?
    2-are you able to provide templates for 14,16,18 and 20 teams?
    3-are you able to provide a points deduction facility?
    4-are you able to program the fixtures in order that for example 1 is at first home to 2 then away to 3 in it’s next game then home to 4 etc?
    I have noticed that some teams are playing 3 consecutive away games especially in the 12 team template?

    Certain amendments would only improve what is a superb template. If additions or amendments cannot be made then so be it.

    Reply

  205. LIKE picture above for lions and kings

    Reply

  206. Like in picture above. The place of Lions and Kings must be changed as Kings GD is more than Lions

    Reply

  207. Hi,
    please how to copy line in 12 team file so that continue next (we will play more rounds). Link to the name starts with line 50.

    Thank you,

    Reply

  208. want a draw 4 teams 3 grades 18 rounds suggestions

    Reply

  209. How do I get more fixtures/rounds in the schedule section ???
    I want to have roughly 10-12 rounds, any help Please ???

    Reply

  210. Works perfect, but the same as above, I need it for more teams!! Could it go up to 10 teams per group? Would appreciate it!! Thanks

    Reply

    • Hi, I have added templates for 10 and 12 teams. I hope it will help you.

      Reply

  211. This template is perfect for an upcoming tournament bu need it for 7 teams – any help really
    Appreciated
    Thanks

    Reply

    • Hi, I have just added the templates for 7, 8, 10 and 12 teams. I just want to point out that the final table is sorted only by points not goal difference. If you find any error please leave a comment here. Thanks and enjoy it.

      Reply

      • Jan, the templates of sport tournamnet are great. Thanks
        But there is big mistake in that. As you may know positive goal difference is in a higher rank than negative one. In your template while a GD is 4 and the other is 50 then the latter should be in higher rank not lower in case the points are equal. I have translated your template it is great but need this problem be solved. Thanks again

        Reply

  212. Hi , This template is great however how do i adjust it for 7 or 8 teams please?

    Reply

  213. Hi Domenico!

    Send me an email at support@enterexcel(dot)com and I can send you one =)

    Reply

  214. Hi Dodo,

    You can find a template like that on my webpage: www(dot)enterexcel(dot)com

    Br,
    Joachim

    Reply

Leave a Reply to Ray Cancel reply



Copyright © All Rights Reserved · Green Hope Theme by Sivan & schiy · Proudly powered by WordPress