Excel Templates | Excel Spreadsheets | Soccer Tournament Creator



Soccer Tournament Creator

Posted on January 25, 2013
Filed Under Soccer, Sports | 9 Comments


There are several requests within the last 4 months, since I released the Soccer League Creator template, about making the same kind of excel template but with tournament format. And I promised to those people that I will make it and try to release it by the beginning of this year. Up until the first ten days of this month, I haven’t started to make it, since I have been fully occupied with other projects. I have just started to create this Soccer Tournament Creator template on 11th January 2013 with the thought that it will take only a couple of days since I don’t have to create it from the scratch. What I have in mind, I just tried to make the Soccer League Creator template as the basic template, multiply and modify the worksheets to be used as group worksheets, add knock out phase worksheets from my Champions League and World Cup template and then finished.

Soccer Tournament Creator ExceltemplateNet 1024x736 Soccer Tournament Creator

But, it wasn’t that simple icon smile Soccer Tournament Creator . It took more than 10 days to finish it, it took only 3 days to complete all the formula integration but it needed more than 7 days to finish the lay out and some more days to solve minor errors that came up when simulating the tournament.

Creating the template is not the same with creating the spreadsheet for myself. If I tried to make a spreadsheet for my own purposes, I will make it as simple as I could to ease my work, or as complex as I can so probably only me who understand the spreadsheet. But, in this case, I have try to understand what majority people want to do with the template and of course I have to see what Microsoft Excel can provide to make it happened. And, I have to make it as simple as possible so most of the people who download this template can use it without sending me tons of questions and finally just keep it as an unused file because the difficulties on using it.

But, I believe that most of you have already used and familiar with my previous templates, and I think you won’t have any difficulties on using this new Soccer Tournament Creator template. There are still plenty of features that I would like to add in this spreadsheet (I make many versions, try to accommodate those features), but it just made the processing time became slower. So, I drop those nice-to-have features and I also stripped some features from Soccer League Creator off, like last 5 matches and team chart function.

So, here it is the Soccer Tournament Creator template. It can accommodate until 256 teams and 16 groups per tournament, and 16 teams per group. And you will have a flexibility to select the knock out round from round of 32 or select only final match as the only knock out round. With this flexibility, you can create a maximum 16 groups where each group can have 16 teams to fight for the place in round of 32 in knock out phase. And there is option to select whether the knock out round will be played in home/away format (like Champions League tournament) or just single match format (Like in World Cup or Euro Cup tournament). But, there is no automatic match function in knock out phases. You have to pairing the match by yourself, but you can set it up from the beginning, so when all group matches are finished, the qualified teams will be placed automatically in knock out brackets based on your own pre-knock out pairing setup.

There is a lite and free version that you can download below to test the template before you decide to buy it. It can accommodate 32 teams and 4 groups for one tournament where each group can have a maximum 8 teams. And, you will have 3 options to start knock out phase, those are quarterfinals (round of 8), semifinals and final.

The lite version is password protected while the Pro version can be unlocked without password. So, you can easily personalize it to meet your tournament of your organization styles.

You can follow the guidance below to use the Soccer Tournament Creator template :


Go to Setup worksheet

1. Set your starting tournament date (Cell K11)
2. Specify number of teams (Cell K13) – max 32 teams for Lite and max 256 groups for Pro version
3. Specify number of groups (Cell K14) – max 4 groups for Lite and max 16 groups for Pro version
4. Set Date of the First Matches on each Group (Cell K16 – Z16)
5. Set Number of Teams per Group (Cell K17 – Z17) – Watch Cell N13 to see remaining teams which has not been allocated (it should give “0″ value when you succesfully divided all teams in the groups) – max 8 teams for Lite and max 16 teams for Pro version
6. Set number of teams that will qualify automatically from each group (Cell K19) – It has to be lower than the number of teams needed for the first round of knock out phase – Watch Cell K20 for the total number of qualified teams and Cell K21 for teams that you have to pick manually after all group matches are finished
7. Specify your group matches competition style (Cell K22) – Home/Away Competition or Single Match Competition
8. Set your group matches schedule period (Cell K23)
9. Set your group matches points earned (Cell K25 – K30)
10. Specify your group matches tie breaker regulation (Cell K31) – Only available in Pro version
11. Specifiy the first round of the knock out phase (Cell K43) – It will related with the maximum number of teams that will qualify from group matches
12. Specify whether there is a 3rd place match is contested (Cell K44)
13. Specify your knock out matches regulation from the first round until final (Cell K45)
You are finished in setup worksheet, now you can start to add and divided your teams, and also arrange knock out matches
14. Write down all Teams name (Cell L13 – edit team name)

Step no 14 will bring you to other worksheet – Team Setup Worksheet

15. Write down all of your teams and their home stadium (Cell C8 – D264). There will be a guidance number at the left side of the table that will guide on writing the whole teams
16. Divide teams into the group. Start with group A. (Cell H8)

Step no 16 step will bring you to other worksheet – Group Setup Worksheet

17. Select the team in group A. Start from Cell C10 until all table filled with the team. There will be group allocation table guidance (Column L – N) to help you selecting teams which have not been allocated yet. Complete filling all groups by scrolling the bar to the right to move between groups(Cell G6)

Go to Setup worksheet again

18. Arrange the knock out matches by clicking on “Edit pairing” link (Cell K48)

Step no 18 will bring you to other worksheet – Knock Out Regulation Worksheet

You can change your preference in this worksheet when during group matches or after all the group matches is finished.
19. Start pairing knock out matches by selecting the teams in the table, from the first round until semifinal. There is the summary of group rank table at the left side of the worksheet that you can use for your reference on arranging the matches
20. Put the date, time and venue of knock out matches. The cell number will be vary based on your Knock Out phase selection in Setup worksheet.

Setting up the preferences for your tournament is finished.

You can start filling the group matches score boxes in Group Matches worksheet. And when all group matches are finished, you can start to put the knock out match results in Knock Out Matches worksheet .

There is one worksheet where you can see the the whole group schedule sorted in date (not time) where you can also highlight particular group or team in that worksheet. And there is also an individual team information worksheet where you can see particular team schedule.

Eventhough I have thoroughly verified these templates, It could be you will find some minor errors which could affect the basic function of the template. You can send me feedback if you found one. All lite and Pro versions are needed Microsoft Excel 2007/2010 with Windows system, or Microsoft Excel 2011 for Mac system to make it running well.

zip Soccer Tournament Creator  Soccer Tournament Creator Lite with Fixtures Generator (2.8 MiB, 6,353 hits)

zip Soccer Tournament Creator  Soccer Tournament Creator Lite without Fixtures Generator (2.1 MiB, 2,717 hits)

As mention above, there are some limitation in the lite version of the template, so if you are want to extend the capability of the lite version, you can purchase the Pro edition which can accommodate until 256 teams and 16 groups per tournament, where each group can have a maximum 16 teams. And you can start the first round of Knock Out phase with 32 teams.

Excelindo Soccer Tournament Creator Template Pro Edition
Single User License (1 single user only)
(All shown worksheets can be unlocked without password)

US$ 20.99 x click butcc Soccer Tournament Creator



Comments

9 Responses to “Soccer Tournament Creator”

  1. Dave on January 26th, 2013 4:11 pm

    The new version seems to tick all the boxes. The last 5 matches was not needed and now I can see the league tables on the same page – great for printing out and filing on a weekly basis.
    One thing I would have liked – even if others find it unnecessary – was to have a space for half time scores and/pr spacesfor recording goal times. But I expect too much. I will certainly be buying the full programme as I can operate 16 different world leagues of 16 teams at the same time and have a world KO competition as well. Heaven!!! Thanks for this!!

  2. Ian on January 30th, 2013 1:20 pm

    Hi, Your templates are excellent & I see getting even better. My Question is do you plan to do one for “Green Bowling”? It would be very similar to your soccer league creator. There are thousands of clubs that could use it?

  3. Chris Horner on February 1st, 2013 9:48 am

    The only thing I would change is the ability to have 8 groups so you can have 8 groups of 4 teams like you do in the World Cup.

  4. Jay on February 7th, 2013 7:07 pm

    Hiya,

    This looks good. Can you add Score Draw to the Points Regulation so I can give say 2pts for a score draw?

    Many Thanks

  5. Chris Horner on March 4th, 2013 4:04 pm

    How can I amend the knock-out phase so that the extra time option is removed and the qualifier is determined by a normal time score first and if necessary the penalty shoot-out score without adding the totals?

  6. Neo Underscore on April 12th, 2013 10:25 am

    Can you add the ability to work with 64 teams in Knock Out (this means 4 teams qualified not 2)

  7. Ciko on August 8th, 2013 2:32 pm

    Perché non funzionano i punti di penalizzazione? Why don’t work the points deduction?

  8. Ciko on August 8th, 2013 9:30 pm

    Solved! In the file entries are reversed “Point deduction” and “Country”, but the removal of penalty points works perfectly!

  9. ayzee on September 2nd, 2013 10:37 pm

    Amazing! So well produced, this is perfect for my needs.

Leave a Reply