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.
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
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.
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”
thank you so much,
this is the best thing ive come across for our sports club.
is there anyway you can add a tournament type option??
E.g.
four pools of 4 teams, and each team will play as per normal. then the top 2 teams qualify for a QF type match?
like a soccer or a rugby world cup,
teams start in pools and qualify for the Finals
thanks in advance
Witam!
Czy masz taki dla ligi 24 drużyn?
Hi, I love this spreadsheet but is there any chance of adjusting for the following scoring pattern:
Win – 5 points
Score draw – 3 points
No score draw – 2 points
Loss – 1 point
Love it, but 🙂
We could use this for out FIFA tournament next year, but we need to compress it a bit.
First, I would like if every group was on the first page ( we have 8 groups)
They only have to meet each other one time in each group
Second, the winners of each group will face each other tournament bracket (win og go home)
I tried to move the groups, but the score does not update
hi
Please can I get a template for 17 teams
Hi brilliant having some group templates but I was wondering if you could have round of 16, quarter finals, semi finals and finals. If not possible that is OK but please try and improve it even more than it is improved by right now thanks
Firstly, thank you for these draws- they really are a godsend…I use them all the time. That being said, I’m using the 4 team draw for the first time but it has an error where it has 1 team playing against 2 team at the same time. (See below). I’m utterly useless at spreadsheets…would you have time to have a look and rectify this?
Please let me know if you need any further information.
ROUND 1
Inner Sydney Leichhardt : Field 1
Leichhardt Marrickville : Field 2
Inner Sydney Strathfield : Field 1
Marrickville Inner Sydney : Field 2
Strathfield Marrickville : Field 1
Leichhardt Strathfield : Field 2
Do you have the password to unprotect the options as I would like o add count back and playoff options
Do you have one for a 20 team league?
What is the password to unprotect the “option” sheet? I want to add additional lines for “losing with 7pts or less” and scoring “4 tries”. Please assist.
Hi
I have a tournament with 19 teams. Is there a template that can accommodate
it is a pleasure having your assistance to complete my draws and table
hi
I need the password to unlock a data sheet
I need a top 16 knockout template
Good day
this is a great template but ia using it for Masters League how do i make 18 teams from 16 teams i had been trying but no Luck i need help
I don’t know if anyone will see this to be able to help me out. I created a main standing sheet that’s supposed to populate all the details from each group so as to seed automatically once the table populate the new standings after each game in group A and Group B. How do I set the formular for that?
Perfect, I edited everything for my hockey league but… if one team win after overtime, how to put in list?
Hello, I am looking to create a cross-league tournament where one team has 6 teams (i.e. teams A, B, C, D, E, F) while the other league has 4 teams (i.e. 1, 2, 3, 4). I would like to create two pools with teams A, B, C, 1, 2 in one pool and teams D, E, F, 3, 4 in the other pool. I would like A, B, and C to each play 1 and 2 while D, E, and F each play 3 and 4. However, I would like each team to get to play 3 games. So I require A, B, C, D, E, and F to all get one more game against another “lettered” team (within pool or cross pool does not matter). The format would be that each team has one game on a Friday night and their other two games on the Saturday (spaced out as evenly as possible). 12 of the 15 total games would be as follows: A1, A2, B1, B2, C1, C2, D3, D4, E3, E4, F3, F4. The other three games might be something like AB, CD, and EF. I am struggling with a way to space these games out as evenly as possible in order to maximize rest time between games on the Saturday. Any help you might be able to provide would be very much appreciated.
Duane
Is there a way to add more matches??
Figured it out. You simply copy – paste a round and insert it and the summary table automatically includes it in its lookup. Thank you again for this spreadsheet!
Hey Rob, im having some issues with copy and pasting in rounds where they do not carry over the new data into the table.
Could you show us how you achieved this?
Hello Sir,
Please i need 4 group 8 teams robin bound excel template.
thank you
How do you add teams? I.e 20 teams.
HI,HOPE YOU ALL WELL.TRYING TO CHANGE 3POINTS FOR WINN TO 2 POINTS FOR WINN.CAN YOU HELP ME WITH IT.THANK YOU
really need a 21 team template bracket. Not following how to add teams. I’ve used these templates numerous times for smaller team leagues.
Does anyone know how to add additional rounds? I’m playing an 8 round tournament but stuck at round 4
I love this spreadsheet and have used it for years in our soccer league! We have recently changed our scoring for a team that forfeits to receive -1 points. Is there a way that I modify the spreadsheet to reflect this automatically in the PTS column?
Just write “-1” in the bonus/penalty cell
Hi, this is a fantastic template and I’m using it for a tennis league, but was wondering about one issue and how to resolve it. When two (or more) players have the same number of points, how can the first option for ranking be the winner of their match.
I have been using these templates for a few years now.
On the scoring the points for a loss, I would like to have a >50% score point
Points would be
Points for a win = 4
Points for a draw = 2
Points for a loss = 1 (if the score of the lossing team is 50% or greater than 50% of the winning team
IE.
Score 10-5
Winner = 4
Loser = 1
Score 11-5
Winner = 4
Loser = 0
Score 3-2
Winner = 4
Loser = 1
Is it possible to make the options as below:
Win 3
score draw 2
no score draw 1
loss 0
Do you have a triangular round robin draw for three teams of 8 players for a darts tournament?
Hi , This template is great however how do i adjust it for 25 teams?
Hi.. We are a big group of friends who want to keep a data sheet of scores whenever we play against each other and not in a tournament format because the tournament gets stuck if a few players are not available. Please help me with this.
Hello,
Thank you very much for the spreadsheet. I have an issue and I need assistance.
My competition comprises 11 teams, but I can only play at 8 venues. Is there something that I could do to ease my pain?
Thanks in advance
hi I need template one groube 20 team ?
Ciao,
ho bisogno di un modello a formula Excel per una liga da Bowling per 8 squadre o di più. Ogni squagra ha 4 giocatori a disposizione. Ogni giocatore percepisce 3 partite. Calcolo dei birilli abbattuti, calcolo della serie, calcolo della media del giorno, calcolo di Handicap del 90% su 210 della media del giorno. Il giorno successivo, i giocatori giocheranno con l’handicap del giorno precedente e cosi via fino ad arrivare alla fine della liga. Infini vorrei il punteggio delle squadre e dei giocatori singolari con attuale classifica.
Hi, I need a template for an 18 team round robin draw over 17 rounds. All teams play together at the same venue each round. All derby matches must be played at home venues. My difficulty is that one club has 4 teams in the competition but we only play at their home club in 3 rounds.
Is there also a tutorial on how to set this up?
With your code no pig comes after.
I can not change the matrix… comes an error.
Hello how can i add round 5 & 6 to a 6 man tournament template to enable each team to play each other 3 times please?
I love these templates. Have been using for years with our Little League divisions. However, I ran into an issue this year with our minor league division which has 13 teams. Once I get to line 92 of the spreadsheet (which is game #70) the standings stop calculating wins/losses/ties. The games played is still working. I’ve tried entering scores below line 92 and they all have the same problem. The standings have worked flawlessly up until that line. Any ideas? Or can I send my spreadsheet to someone to look at?
Hi,
I s there anyway of having 2 league tables that automatically update from separate scoring lists?
Thanks for the amazing templates.
The 7 team schedule does not work. We have 7 teams playing 4 games on two baseball fields so one team needs to play twice per week. I have used your 6 and 8 team scheduler before and they worked great. 7 team does not work
The 7 team schedule does not work. We have 7 teams playing 4 games on two baseball fields so one team needs to play twice per week. I have used your 6 and 8 team scheduler before and they worked great. 7 team does not worh
thanks for this – much appreciated …
thanks for this – much appreciated
I’ve been using this template but i have to manually change all the teams around, is it possible to do alternate home and away games for the teams?
Hi
I want to use the template to create 10 rounds instead of groups and then have one total leauge table that adds up all the tables. how should i do that. i use te 4 teams one and have duplicated the groups to rounds.
And added one total table at page 1.
Hi
I use these for volleyball which we don’t have draws. if it is 1 set all the result goes to total number of points.
I can’t work out how to amend the formula. I have added points columns to the right of the score columns.
It would be really nice if I could add starting times and breaks for games (24h clock). And change these easily.
This template is amazing! Thank you for making this available. Would it be possible to add the percentage (the goals scored for divided by the goals scored against i think)
i need a 20 team template please assist
Can you change the random playing order to suit what I want it to run like
Good Day
When I copy to add more groups, the table scores don’t work.
Please help.
Andre
I would like to organize a volleyball tournament, is it possible to distribute the points for 3:0-3, 3:1-3, 3:2-2, 2:3-1, 1:3-0, 0:3-0?
Hey
Is their a way to add 20 teams? And possibly 24?
I’ve tried the video but I can’t seem to graspe the formulas
Hi Jason, did you get an answer to your question? I’m looking for an 18 team league.
Hi Gavin,
Were you able to get a template for 18 teams? I’m looking for a template for 19. I’ve been trying to follow the video for a week now and I can’t seem to get the formula correct. Any help would be greatly appreciated!
Melanie
I have tried your updating procedure after watching the video but keep getting an error value in the hidden table. Is it possible just to amend the formulae in the hidden table to include more rows/ rounds?
Hello can I get it for 2 divisions of 8 teams in each division.
Each team play each other once in their divisions. so only 7 games.
Great spreadsheet its been very hepful. I am using for a golf keague so i could do with it ranking thoses with a lower GF if it come to it. How would/where would i change that.
hi, brilliant template love it. Thanx.
However i need to use it for a darts league ,where points = legs won. Games are best of 21 legs. Therefore if result is 17-4 winner gets 11 points loser gets 4 points. can adjust the code in the points cell to reflect this ? ie so that points come from GF cell for each team.?
Kind regards
Thank you.
Ive sorted it..shoe hidden formula ,then change points column formula.as follows
remove all $options formula.change u3 to the cell you want your points from(in my case x3 the GF column) so this leaves….X3+LOOKUP(………………..). table now changes to reflect scores of match .
I have tied to copy and paste so i have 8 sheets therefore 8 groups but there are formula errors in the group table please can anybody help
Hi,
there is a hidden table that you have to also copy. It is between V – AE columns. See the video “How to update tournament template”. It might help you to understand how it is working.
Hi,
How do you enter a team forfeit win/loss?
Hi,
it depends on sport. In football (soccer) is usually score 3:0 against the team and all points goes to the second team.
How do you change it so that teams only play each other twice instead of four times?
I would suggest to leave empty the second half of rounds.
Hi, I would like to make excel table for ordinary tennis league, but if 2 teams are equal with points than it should take into account their mutual match, so who won the match is higher ranking.
So, I have 11 teams, namely:
Team 1
Team2
Team3
Team4
Team5
Team6
Team7
Team8
Team9
Team10
Team11
After entering the results for each round, let Excel itself sort the Teams in the following order:
a) Team with most points is highest ranking.
b) If 2 teams with the same nr. of points, the head-to-head is then watched and whoever won is higher ranking. If the teams have not yet played each other or have result for draw, then skip to c).
c) If the teams are still the same, then they are judged by goal difference – higher difference is higher ranking.
d) If the teams are still the same, then see who received fewer goals – who received less goals is higher ranking..
e If the teams are still the same, then see who scored more goals – who scored more goals is higher ranking.
f) If the teams are still the same, then they occupy the same ranking place.
Here is link for demo file:
https://docs.google.com/spreadsheets/d/1MvQz0USGOsceyaHEFGpgTNRPL9hxbGGR/edit?rtpof=true&sd=true
If you have any solution / formula, pls let me know
Regards
Could you Add aa 18, 19 and 20 Teams template!
Fantastic Templates.
Can I change the layout a little…
Team 1, score, v, team 2, score
Team 3, score, v, team 4, score
Hi,
thanks. Yes, you can change a layout. You need to change formulas in the hidden table to keep everything working. See the video in “How to update and create more teams template”.
I have two teams at the same venue, how do I make sure they don’t play at home at the same time?
John
Hi,
this template is not prepared for 2 teams in one venue.
Hello, is there any way you can get it where the following is the ranking.
-Win vs. Loss
-Head to Head
-Goals Against
-Goals Scored
Hi,
Yes, there is a way to change the ranking. There is a ranking formula in the hidden AE column that you can change to suit your needs.
How do I input as a default Win if a team does not show up, without inputting it as follows, 1-0, because if I do that it adds to the GF and GA totals, I do not want that to happen.
Hi Paul, did you figure out how to do this? I am needing to put in a forfeit column
I have created the rounds but I have a limit of 5 fields rather than the 6 that are allocated in the program. Any ideas?
I’ve used this template for many years on my previous PC but I changed to a Mac last year and these are incompatible. I can download a table but lose some of the functionality which isn’t ideal. Is there a Numbers version of this I could access?
Sorry meant to say a 13 team and 12 team
hi guys,
can you help me chnage 1 w to 1 point and a draw 0.5 point and of course a l 0 point please?
sorry i got it duhhh, but i added an extra group to the sheet 7 teams to a 6 team sheet and the formula didnt paste over.
Can you help me figure out how to add the round, after the 1st one -where the teams will play the #3 from GroupA and #3 from GroupB? Can’t figure out how to calculate that. Guessing I can do it manually, but that would defeat the process. Then #2 GroupA vs #2 from GroupB, etc? Have about 15 different groups.
Hi all,
Does anyone else have trouble with the 10 team tournament not changing the team names?
Hi
Could you please advise how to add more rounds to a template?
Great spreadsheet though!
Cheers Peta
Hi, love these templates – wondering if you had a template for top goal scorers as well?
Been trying to create one but having slight issues with it
Hi
Great work with this…
Maybe something to take in consideration with next version is to add Bonus points as well.
I need this to work with bonus point being added to both winning and losing teams if hey score 4 goals or more.
Hi, please can need some template for 19 team please
could you help me please,,i want a round robin(league) a schedule for indoor bowls i have 3 rinks and 9 teams,,and would like a even spread or as close to as possible for each rink,thanks ,Jezz
Thank you for an amazing sports template. I am looking to use this for our hockey league, 20 teams. Do you have this for 20 teams?
I would like to know how much it cost to make a sheet for 30 soccer teams
please let me know . thank you
Hi – firstly these are all awesome
a request; can you add 3 pitches to the tournaments?
i.e. 20 teams, 4 groups of 5, played over 3 pitches?
let me know please
Hi, I was wondering if I can get that template that includes forfeits rather than Draws in the Standings table?
Also, how would I record forfeits?
Thanks for help
Hi!
Have you got templates for:
17
18
19
20
teams?
Thank you
How can I find a template for 19 teams in a league
I would like to create round robins 7 rounds for 8, 12, 16, 20, 24, 28, 32 players that rotate (not same partner) where 1 is strongest and the last player is the weakest. Would someone be interested in doing this for me? It means it is graded and not random who you play.
I would like a tournament draw: 20 teams, 3 games on one day, 10 rinks so no team plays on the same rink twice. Expandable for 22 and 24 teams would be helpful too! Do you have something like that available? Thanks!
Hi your formula does not work on the 16 grid of teams to play home and away each week it shows say Team 1 home all the time, also all other home teams show home games each week
Please help. I am trying to organise a fishing tournament where we have 21 persons and they are to play every other person once but each contest is to be within a mini contest of 3 persons. I.e. A v B v C to get 3 points, 2 points and 1 point. Next week, A v D v G.
I have managed to get the first few weeks sorted but fail to make sure everyone plays everyone else but never more than once.
Can this be done?
is the any other templates like and draw for tennis?
HI
IM TRYING TO LOOK FOR A EXCEL FOR 6 POOLS OF 4 TEAMS IN 1 POOL
hi,
I am looking for an 18 team sports template please, how can I get one.
thanks
Richard
I’m trying to expand this to 42 but can’t figure out the coding. What needs to change so I can add the other teams I’d like to include?
Thanks
Hi
I need tables with 18 teams, please
christian.reif82@gmail.com
Great template! I was able to use this and turn it into an NHL format.
The one thing I need to note is: What would be the difference between using that long INDEX formula for the standings as opposed to a simple SORT formula?
Another note: In the hidden standings for each group, can’t GP just be a SUM command encompassing the W, L, and D columns?
Hi! Thanks for this amazing spreadsheet.
I have a couple of questions relating to the “Bonuses”. I am running Blood Bowl leagues with Bonus points awarded as thus:
1 Bonus Point for every TD (Touchdown) up to 3
1 Bonus Point for every Casualty Caused up to 3
3 Bonus Points for a Shutout
This is on top of
W=30pts
D=10pts
L=0pts
I love it if you could create a spreadsheet that tallies these bonus points automatically once inputted as you did with the GF and GA.
Much appreciated! Keep up the fantastic work for clueless souls like myself.
bonjour on peut avoir une table de 64 équipes s’il vous plait c’est pour organiser un concours de pétanque en quatre tour merci d’avance
disculpe tiene para mas de 17 equipos ?
Would it be possible to have x players, then randomly pair them with a different players each match to form a team?
Say 16 players that creates 8 teams. Each players partners with every other player once? All players play against each other at least once.
Hello it is possible to put a table with 18 or 20 clubs online for download
To anyone reading, the templates presented on this page are simple and easy to use.
However, if you are looking for templates supporting a higher number of teams and with a more professional look you can visit our site:
enterexcel_dot_com
or email us at:
support@enterexcel_dot_com
Best,
Joachim
EnterExcel
SHEDULE for Round-Robin is different.
SHEDULE need to be like this TABLES.
3 or 4 Players
Round
1 1:4 2:3
2 4:3 1:2
3 2:4 3:1
5 or 6 Players
Round
1 1:6 2:5 3:4
2 6:4 5:3 1:2
3 2:6 3:1 4:5
4 6:5 1:4 2:3
5 3:6 4:2 5:1
7 or 8 Players
Round
1 1:8 2:7 3:6 4:5
2 8:5 6:4 7:3 1:2
3 2:8 3:1 4:7 5:6
4 8:6 7:5 1:4 2:3
5 3:8 4:2 5:1 6:7
6 8:7 1:6 2:5 3:4
7 4:8 5:3 6:2 7:1
11 or 12 Players
Round
1 1:12 2:11 3:10 4:9 5:8 6:7
2 12:7 8:6 9:5 10:4 11:3 1:2
3 2:12 3:1 4:11 5:10 6:9 7:8
4 12:8 9:7 10:6 11:5 1:4 2:3
5 3:12 4:2 5:1 6:11 7:10 8:9
6 12:9 10:8 11:7 1:6 2:5 3:4
7 4:12 5:3 6:2 7:1 8:11 9:10
8 12:10 11:9 1:8 2:7 3:6 4:5
9 5:12 6:4 7:3 8:2 9:1 10:11
10 12:11 1:10 2:9 3:8 4:7 5:6
11 6:12 7:5 8:4 9:3 10:2 11:1
Why?
Ocigledno se radi o stonoteniskom turniru ili ligi . Tako mi bar izgleda . Mene interesuje organizovanje turnira : grupe pa kup sistem . Nesto smo pravili sami od 17 do preko 40 igraca ali nije idealno .
This will be great for our school tournament. Can you we also download tournament flowchart template?
Thanks.
This is a great design. Very useful! I’ve been trying to figure out how to add rounds and can’t do it. Can you help? Basically, if I want add multiple rounds so that the stats continue to track once teams play more than 4 total times.
Thanks!
Hi, did you ever work out how to add extra rounds?
Also i presume one can insert a date column without affecting it working?
Not downloaded yet, and have several ideas as to how to do what i want, but if somebody already know that would be great. In sports where the return game carries a bonus point based on the aggregate two game scores, can it be adjusted to 1. display total score from the two games and apply a bonus point to the higher points scoring team?
Hello and firstly I thank you all of this. Awesome work.
I have question or did i forgot to do something.
NHL template
Winner gets 2p
Draw winner gets 2p
Draw loser gets 1p
Loser gets 0
Is it possible to do with those templates?
Bg
And playoffs?
HI,THESE TEMPLATES AER EXCELLENT,I HAVE DONE ONE FOR A LEAGUE FIXTURE FOR 14 TEAMS,i needed them to play each other twice (once at home then once away),but it has worked out for them to olay each other 4 times,is there any way i can correct this please
Can I get excel tamplet for volleyball point table?
Good afternoon,
I have added three more 4 team groups (2,3,& 4) and whilst all the formulas work in group 2 they do not in groups 3 & 4.
Specifically the W, D, L, GF, GA, & Points data is not updated,only games played.
I have checked the formulas but I can’t see anything wrong.
what is the password so I can change the options spreed sheet?
hi .I love this but I need 1 for a 4 team 6 team 8 team and 12 team for a 3 game guarantee with a seedings column after the first 2 pool play games are over
Hi,
is there a way to have the points won set to whatever the players score?
i.e
score ends 10-4 so instead of 3 points for win the team would get 10 and the loser get 4
i changed the draw to 7 which works.
as its a dart leage and we play for 14 points each league game so teams could win 8-6 but i need the points to total points won and lost and not a specific amount like 3 points for a win if that makes sense.
any help would be appreciated
thanks
frankie
Good morning. Firstly, I think that these spreadsheets are fantastic and a time saver. i appreciate the hard work which has gone into each one. I would like to add two rounds into the 4 team sheet. I have managed to drag the games played coloumn by do not seem to be able to do the w,D,L column. Is it possible?
Just a round up. I need 4 groups each with 4 teams but they play 6 rounds in total (1 per half term)
Thank you in advance
16 team template does not automaticlly generate home and away?
I am trying to use the 9 team format for our league
We need 3 teams at a site and 3 different sites – and yet get the round robin completed so we all play each other – and we need to spread that over 6 rounds….
Is that a possibility to do?
Hello it is possible to put a table with 18 or 20 clubs online for download
How can I change if I would like award 3 points to the team with the lower score?
Hi,
you can use Bonus/penalty section for that.
How do you change what column the table is automatically sorted by ?
Currently the column is sorted by goal differential but I have added an additional percentage column that I would like it to sort by.
Hi,
there is hidden table in columns S:AB. You can modify there column AB (rank) which is responsible for final table sorting.
Any examples on how to do it? What formula should be applied?
Hi, I have the 9 team league but want to add more rounds. I have looked at the video but think it might be an older version of Excel as I cannot get it to ‘ Link ‘ Can you help please. Thanks. Mike.
How do I adjust the schedule maker part if I have two teams playing at the same location. If one is home the other must be away.
Hi!
Have you got templates for:
18
20
22
24
teams?
Thank you
Hi,
thanks for the work!
I’m also looking for a single sheet with 18 or 20 teams, like a normal league (Bundesliga or Premier League). Would be awesome if you could add these sheets.
Thanks a lot!
Sorry ! Posting again as I there was a typo in my email address .
I am trying to use the 8 team template for FIFA tournament where each team will play with every other player as best of 3 series. So 3 matches with every player . . if there is a result 2-1 then winner gets 3 points. If all 3 matches are drawn then both share 1 point each. At the end of the all the matches top 4 teams will proceed to next round and play knockouts for which the fixtures should be pretty easy.
Right now I can use the fixtures from Round 1-3 for my best of 3. But the challenge is to calculate the points at best of 3 level result and not at individual match level. I would want to keep the goal tally recorded though for every match.
TIA,
Bhavik
I am trying to use the 8 team template for FIFA tournament where each team will play with every other player as best of 3 series. So 3 matches with every player . . if there is a result 2-1 then winner gets 3 points. If all 3 matches are drawn then both share 1 point each. At the end of the all the matches top 4 teams will proceed to next round and play knockouts for which the fixtures should be pretty easy.
Right now I can use the fixtures from Round 1-3 for my best of 3. But the challenge is to calculate the points at best of 3 level result and not at individual match level. I would want to keep the goal tally recorded though for every match.
TIA,
Bhavik
Hi,
Do you have a 22 team template?
Thanks
Hi there,
Does anyone know how to edit the 3 team spreadsheet to allow for 10 rounds?
Thanks,
Hey there
great spread sheet. Do you have a 17 team template by any chance
Cheers Col
For the first time I need a 17 team template and points table. Any help would be appreciated. Very appreciative of these templates, they are excellent to work with
I would like it to automatically give the winning team an extra point for a shut out and I would like it to give both teams an extra point for every goal they score up to 3 for every game, win or lose.
Hello
Let me tell you first that this is phenomenal! I hope you can help me out with this:
I have 4 groups, with 4 teams in 3 groups: A, B, and C, and 5 teams in group D
only 1 game against each other in each group
Then I have :
Quarter-Finals A
Bracket A #1
vs
Bracket C #2
Quarter-Finals B
Bracket B #1
vs
Bracket D #2
Quarter-Finals C
Bracket C #1
vs
Bracket A #2
Quarter-Finals D
Bracket D #1
vs
Bracket B #2
After that I have :
Semi-Finals A
Quarter-Finals A Winner
vs
Quarter-Finals D Winner
Semi-Finals B
Quarter-Finals B Winner
vs
Quarter-Finals C Winner
And the final will be:
Final
Semi-Finals A Winner
vs
Semi-Finals B Winner
Is any way you can put this in an excel sheet to just put the scores and the team’s names can be reflected base on the results?
Thank you so much and keep up the good work!
can anybody help.
I am running a round robin tournament at our bowls club
We have 14 teams playing each other on 7 rinks
Each team can only play on each rink a maximum 2 times.
I have tried the existing templates but at some point some teams seem to be playing on 1 or 2 rinks three times.
Any ideas would be appreciated.
Hi
Great excel sheets for Sports.
I’m doing Netball League scores and need to update the points with adding, Loser >50% goals of winner =1 Point. Loser <10 (within 9 goals of winner) = 2 points.
so
Winner – 5
Draw – 4
50% – 1
loss – 0
I can’t amend it on the spread sheet,
Thanks
Cathie P
Hi Cathie,
Forgive me for intruding. I run dice netball leagues and firstly, I have always awarded 3 points for a draw which I have found more realistic. Secondly, simply use the bonus/penalty points column to input the 1 or 2 bonus points. Quite simple unless you are having a problem with the system.
Hi!
I see that the comment section is still active on this one. Good.
I’m also finding these superhelpful, but i too have a different kind of scenario.
We have a tournament with two groups. These groups play separately and they don’t play against each other. But we play 3 matches a day for a period of time. So i would need a table that combines the two groups so there can be games from both groups the same time, but no games mixing the two groups. What would be the easiest way to achieve a single sheet with this kind of situation….
I would love to know this too!
2 separate pools on one sheet – I think I just need to know how to change the definition of homescore and visitorscore – but I’m no spreadsheet whiz.
Thanks!
I figured mine out – I had imported the sheet into Google Sheets which doesn’t show defined names…
I’m not sure if we’re both after the same thing but I found it easy enough to copy and paste the formulas around in the latest Excel and drag fields around once selected in the formula line.
Hi,
you can have it separately in sheets GroupA and GroupB.
Then you can use split function to see 2 sheets in one screen. https://www.howtogeek.com/411797/how-to-use-excels-split-screen-function/
I know it is not the best solution but it can be start point:)
Hi Guys, we love really really love your table and find attractive, useful, practical and versatile. We have been trying to mix two zones with some success but met a small glitch in the second ranking table as it reflecting #VALUE! errors. Please can you help?
Can you please tell me the p/w to unlock the Options tab.
Points
points for a win 3
points for a draw 1
points for a loss 0
Want more? Visit:
http://excel-example.com/templates/sport-tournament-template
Hi,
you can still edit the numbers.
I use these for teaching PE lessons for different tournaments. These are amazing. Thank you so much for sharing – I wish I had your excel knowledge!
Please ..tell me ..do you have for 22 teams …becouse it is for biliiards tournament…i need that…whoud you be so candy to send me ..on my e mail ..thank you
Morning! I have been asked to organise the scoring for a week-long (lawn) bowls competition, taking over from a man who is very well-up on excel formulas etc., and has run it very efficiently for a few years. However due to unforeseen circumstances he’s not able to do it this year. I’m quite daunted by the challenge and trying to find a way to teach myself how to set it all up so that it runs efficiently. I will have to be able to provide team results at the end of every day and a team results sheet to enable the teams to see how they are placed every day. We are looking at over 90 teams of four players each.
Can you offer any suggestions?
Thank you
Rosemary
Is there any way to add more than 4 rounds?
Thanks!
John
Hi,
yes there is. See the video How to update..
You have to create new Rounds below current and extend the data source range in the hidden table.
It works also in LibreOffice Calc. Great!
The schedule is sorted by points from what I understand. What if points are tied? What is the next sorting mechanism?
Thanks!
John
Hi,
The next sorting criterium is number in column GD (goal difference). It is calculated as the number of goals scored (GF) minus the number of goals conceded (GA).
Hi. this looks great, i have a similar ask this might seem like a tough ask but bear with me.
I have created a spreadsheet that houses correct football scores for 5 or so people, what i want to do is place in their predictions and when i put in the correct result at the end of play i want the sheet to recognise that the score matches and accumulate the points below each person, i.e 3 points for a correct score, 1 point for a correct result, no value if they get both wrong, also if they bank it to double the points i.e
Team1 v Team11 2 – 1 1 – 1 2 – 1 4 – 1 5 – 1 6 – 1
0 3 1 1 1
Once this is completed i want in a separate table to update the points scored as they are inputted week on week.
In effect i want the input of the correct result to trigger all of these calculations, i understand that it might be too much of a multi faceted argument. but its worth a try.
Thanks
I would like to add to the points Forfeit loss= 0
Double Forfeit = 0
your points won is set at 3 but i need it to change to whatever points team gain on the night.
i changed the draw to 7 which works.
as its a dart leage and we play for 14 points each league game so teams could win 8-6 but i need the points to total points won and not a specific amount like 3 points for a win if that makes sense.
any help would be appreciated
thanks
frankie
I am look for some help please. We are getting ready to put on a special tournament for high school charity. Any I need a sheet to host 14 teams. 2 brackets will have 3 teams and 2 will have for teams. All teams will play 3 games which means there will be a some cross over games between teams. We will have a semi final and than a final. Any support or direction you can give me would be very much appreciate
Thanks so much for the sheet – a true life saver when it comes to the graft of writing sheets.
Do you have a sheet that only uses 2 groups of 5 teams?
Thanks
Mike
Thank you so much for lifting the heavy load!
I use your code on Google Sheets to easily keep score in two recreational volleyball competitions. From Google Sheets it publishes instantly on our web site (in an iframe). If you’re interested, take a look at www(dot)ardeahhw(dot)nl/?frontpagetab=4
Furthermore I use it in Excel for my yearly childrens volleyball tournament (20-30 teams in 4 groups). I have the templates ready, so I can easily organize a schedule. I keep track on a notebook during the tournament and show the result on a second monitor – children love that, you know how impatient they are.
Could not have done that without your core code for calculating the score (which is beyond my Excel skills), so thanks once again!
Dear Jos,
Was there an easy way to upload the excel to google sheets or did you transfer cell formulas manually?
Please disregard my request. I have successfully uploaded from excel to sheets the standard way and it works. Not sure what I did differently, but all formulas are there.
Is there anyway you would share this translated to google sheets i can not get it to work
Can you please send me one for 18 teams please, much appreciated
hello did they sent you the 18 teams sheet i really need one as well
Me too!
did you get an 18 team template? I tried to edit and get errors
hi there
i try to add a team in the excel and i following the video but it did not work for me how can i fix it is showing #/N/A and ###### on the row
did you figure this out? the weird thing is even if you don’t add anything, just edit a formula and change nothing it blows up. Not sure how any of it is working.
DO YOU HAVE A 18 TEAM TEMPLATE?
I NEED 18 SETS OF TEMPLATE I WILL BE VERY HAPPY IF YOU CAN SEND
Really nice job.
Is there any chance to make it for volleyball, where the winning team (with 3-0 and 3-1) gets 3 point, and the losing 0 points, but when the score is 3-2 in sets, the winning team gets 2 point and losing 1 point?
Thanks in advanced
I am looking to get an update for a 5 and 6 team Round Robin netball tournament – i need to different scoring options for a loss:
1. to score 1 point if the losing teams score is at least half of that of the winners
2. To score 0 points if the losing team scores less than half the score of the winners.
Can you provide that update option please?
Richard
Did you work out how to do this with the 50% point?
Hello,
firstly love this site and great templates.
I run an annual 1 day tournament so i only use 1 round and at the end of the 1st round I qualify teams to go through to the KO stages where I have a quarter, Semi and Finals.
To do the qualifications I need your table to include a Position column however this has to be based on the following criteria
1. Points scored
2. Goal Difference if points are the same
3. Goals for if the point And the Goal difference is the same
4. update position so I am able to ascertain the top 4 teams to go into the quarter finals.
currently I do this manually and i can often lose a lot of time because it is done onsite, manually, can you help me automate this process?
Hi,
The template for 4 teams means that the same team plays twice in every week.
Thanks,
Jake
many thanks!
Is the a way that you can change one you have the filter on for the tables. As would prefer it on the GF than PTS
Hi
Can you please share the password so i can edit the sheet
Thanks
Chris
Well done guys! For those who are interested, here is a fresh new one for 2019/20 season: https://www.someka.net/excel-template/premier-league-excel-template/
Is it possible to create an 18 team template?
Thanks
HI
You fixture generator is very user friendly especialy for me as I am voluntary football officical in Phoenix South African for an amateur Football association that deals with children from age 7 to 17.
however because we deal with a community we encourage as much team in a division as possible. You only have up to 16 team . Can this be increased to more than 16 team .
Hi would it be possible for you to create worksheets with 2 groups & tables next to one another which would then drop down into a senior semi & final with top 2 teams from both groups to create a Champions league final & then the next 2 best placed teams from both groups to create a Europa league final for groups of 4,5,6 teams.
I tried and failed by copying but data & dumping next to original. Our tournament is at end of June 2019. We would be really grateful for your help
Is there a possible suggestion for separating teams with exactly the same record, i.e. wins, losses, draws, pf, pa, pd or equal say on a head to head between the teams to be separated ?
Hello,
Could you please create a schedule for 20 teams?
Thanks
hi,
I noticed my file is password protected to add additional edits, can you provide the password to un protect the file for additional customizing..
thank you!
David
hi,
I noticed my file is password protected to add additional edits, can you provide the password to un protect the file for additional customizing..
thank you!
David
hi
how can we change to play only 2 time per round instead of 4 ?
Hi,
Thanks for the templates, it really helps a lot. I ‘m stuck on extending the rounds please any help would be appreciated.
cAN YOU PLESE TELL ME HOW I CAN INCREASE ROUNDS TO 25
Hello,
Could you please create a schedule for 17 teams? Thank you so much!
Hi,loved the templates, I have several indoor bowls leagues at my club that I run. I need a chart that reflects 20 matches all home not away. I tried copying the fixtures but results not updating, would I need 20 groups?
Hi,
Thanks for the current sheets, it really helps a lot. I need sheets for more teams please. 24 to 32 teams. Could you send me please?
Regards
Faried
Hi Faried,
Perhaps I could help you with this. Not sure if I have templates up to 32 teams for any sport though. Please send me an email: support_at_enterexcel_dot_com.
Br,
Joachim
I NEED 17 AND 18 SETS OF TEMPLATE I WILL BE VERY HAPPY IF YOU CAN SEND.
Dear Joachim,
First of all, I would like to thank you for such exceptional work on putting all these templates together.
I downloaded the 6 teams one and modified it a little for a baseball tournament (please send me an email in order to attach it).
This was modified for 6 teams, playing in 3 different fields at the same time, but sometimes we have more teams playing on 8 fields at different times, and not always have the same amount of weeks during each tournament.
I would like to know if you could walk me through on how to make any future templates without “round 1”, “round 2” etc. We also don’t use “points” in baseball, therefore don’t need the “Options” book. Also, we only use RF (Runs in Favor), RA (Runs Against) and RD (Runs Difference), but would like to know if there’s an easier way to modify it in regards to the number of teams there are in a certain tournament.
Best regards.
Tino.
P.S.: Had to modify the schedule according to an existing one already made.
Tino,
This is not my site, I have just helped a few guys in the comments section out 🙂
Jan Podlesak is the owner of this site and the templates provided here.
Br,
Joachim
Just wanna say thanks so much for making these
Most of us would probably admit that we are not completely computer literate and would require assistance. I have attempted to create my own template to facilitate 20 teams following the video instructions without success as no doubt others have tried. Is there any chance you could produce one to end my frustration? I am sure others would be equally as grateful. Thank you
Ray
Hi Ray,
I have a template like that I can send you.
Send me an email: support_at_enterexcel_dot_com
Br,
Joachim
Thanks Joachim
Ray
Hi I think thectemplates are great and I can make some adjustments, however I have a tournament coming up where they will do 2 points for a score draw. I know I could just add these as bonus points but it would be great to have the league update automatically.
Many thanks
Hi,
you can set this on sheet Options.
It is written in the article.
Absolute legend! I needed a quick spreadsheet of results for two different pools of tournaments and this was PERFECT! Absolute lifesaver. Thanks so much!
This is awesome!
Thanks so much and I’m so glad you are still keeping this going!
I have 3 groups x 5 teams and want to take the top 8 teams through to the knockout stage of the competition. Which is the fairest/most accurate way to do this. Do you have a schedule for this? Thanks
Hello
I’d like to set this up so that the ‘goal difference’ goes the other way as I would like to use this for golf. How would I do this?
Cheers 🙂
Hi,
Is there a way of adapting a 14 team league to suit teams which play in a 3 team venue per night.
e.g. 3 team grouped per night and play to games.
Hi I’d like an excel similar to your 4 team one but I’d like 2 groups wher the top 2 teams from each group go in to one set of Semi finals then Final (Main Cup) & the bottom 2 from each group go in to another set of semis & final (Sub Cup)
Hi
I need 52 round
We play each week which is in a year 52 weeks.
Please anyone can help me..
Thanks
Contact me via email please
Need bug help
Good morning! I love the brackets! However, I ran into some problems. In both the 8 and 9 team table that tracks wins, losses, points for/against, etc, there is a format issue I can’t figure out. It doesn’t track the points, and wins/losses for the first few when I input the scores. Basically they are getting credit for games played, but are not showing the right amount of wins/losses to equal the games played. Goals for/against also didn’t calculate. Again, I love the brackets and the hard work, so I am not complaining, at all. Thank you!
Hi
How do I set up a Tournement like round robin but it will be
8 Players B and 8 Players C , and play only B with C
Thanks
I like your spreadsheet but I did found error. Sorry, about that 🙂
I don’t know how to explain but it generates same pair twice .
team1 : team9 row 54
and again
team1 : team9 row 148
I don’t know how to solve this so can you help?
Hi. On which spreadsheet template did you find this error?
Hi There,
I have a league with 20 teams. Can I please have the template for this?
Thanks.
Thank you for the spreadsheets it helps a lot.
In our hockey league the points are different:
points for a win = 4
points for a draw with goals = 2
points for each team in the event of a goalless draw = 1
points for a loss = 0
The current spreadsheets only cater for 3 scenarios, can you assist it this case please. I’ve been trying for a year to do this myself but not successful.
Thank you
Very appreciated.
Hi Thanks for your great work.
Is there a way to add more round? I’m ready to learn.
I don’t want you to make it.
Thanks in advance.
Hi
I am a PE teacher this sheet is excellent!!
I have a need though for 8 Groups (A-H) not just A-D. If I create them myself (by creating new tabs and then copy/paste from Group A)groups E-H do not seem to update the table correctly.
Can you send me a sheet with 8 Groups please?
thanks so much
Jeremy
Hello,
in the article are instructions how to do that:
see Settings – how to add more groups
Hi
Great templates, I would like to adapt for table tennis where we play 10 games best of 5 sets and award 1 point per set so the maximum score is 30 points example final score could be 28 -2 and this would be the points I would like entered into the table which formula’s would I need to change and how please?
Regards Mike Gadd
Hi.
Do you know how to change the formulas so it will work in Google sheets? I would like to use your templates as a live document within a webpage and can only do this through Google sheets.. unless you know of another option?
I hope this can be done as your templates are perfect!
Please may you provide me with the password to see the hidden pages?
thank you
I would like to know if there is a template for 20 teams. Appreciate your help.
Is it possible to adapt the system to teams who share ground either within the division or with teams in higher leagues?
Hi There,
I have a league with 17 teams. Can I please have the template for this?
Thanks.
Hi There,
I have a league with 20 teams. Can I please have the template for this?
Thanks.
FUCK OFF!
Hi,
I am a high school pe teacher. I found your excel sheet very helpful and as close to something im looking for.
You may be able to assist with the next step.
I have a team generator sheet set up. What i would like to do is to link each player to a team (your worksheet) for each lesson, so when points are assigned to that team, it assigns it to that player(overall leaderboard). I generate different teams each lesson. Want to make it a year long competition of the most consistent student.
Hope that makes sense. I look forward to your response
Thanks
Hi John,
I know this is way late, but if you still need something like this send me an email and explain in further detail what you are looking for:
support_at_enterexcel_dot_com
Br,
Joachim
Any chance of a 20 team template being added to the site?
As Deena asked on 19 April, is it possible for 4 groups of say between 6 and 10 teams to appear on the same page with fixtures and tables? This would certainly enhance the features of this site.
Any way to add a shut out column? And how would i go about moving the GD column to go before GF and GA?
Need an 18 team schedule, can you please help out.
Thanks
Hello,
Great work !
Do you have a 20team template available?
can you please add a 20 team template
I am an avid cricket fan and would like to have database of cricket tournament leagues (twenty20). Any help for me?
Awesome! Just, how many matches are there?
Hi Can you send me a template for a 11 a side tournament, number of teams 6, they play each other once, the top 4 go through to Semi finals, then the winners of each semi final go through to the final, thanks.
Derek Davis
Hi can you send me 18 teams leauge shadule as two group with 8 teams for 10 months.Please send as soon as posible
This is amazing, thanks very much for sharing.
I want to add more groups and league tables to ONE sheet ?
This is instead of having individual sheets
This is fab! Is there a way to allocate countries to each team (eg ABC PLC are playing as England)? Also we’re only doing 1 group stage, then straight into semis and final……
thanks!
M-L
Hi,
These are great!
I have tried using the 6 tea tournament, but whenever I enter the results it doesn’t calculate the wins or points for each team but adds in the other statistics. Wondering if you could help me out/let me know if I am doing something wrong.
Thanks!
Do you have a 17 team bracket by any chance?
hello congratulations for his work could make the model free to 20 teams?
Hi Joachim
I’m running a soccer league in Cape Town, Khayelitsha and I have been using your excell sheet but this year we have 17 teams and the other division have 18 teams. Can you please send me your excel sheet with 18 and 17 teams.
My email mziyanda.pawuli01@gmail.com
Thanks
Kind Regards
mzi
Hi
is it possible to have 4 groups on a single page – with the fixtures and league tables for each group.
e.g. U7 division – 4 groups (A, B, C, D) with 6 teams in each group.
Hi
I am using the 5 team template but need 6 rounds instead of 4 but cannot seem to get the copied 2 rounds to link please can you help as need this for a junior netball league I am running?
Thanks
Andrea
Hi I run a pool league could you make a template for the following
for 8 teams
played
won
lost
frames for
frames against
3 points for a win
and 1 point for every frame won
i would be very greatful for your help as i am really struggling doing it manually
Many Thanks
James
Thank you for the template. It really help as a starting point. Did some adjustment to it for Rugby tournament, to include bye, try bonus point and losing bonus point. Wish can find a way to share it here.
Thanks again
Is there a way to do this with an NHL schedule. I see the options, just would like to add more teams and set up league standings different.
hi 😀
thank you very very much for this templates.
i finally found what am looking for.
it really helps me bit by bit on learning how to create one.
thanks a lot cheers
Fantastic…. Fantastic…
Quick question
Is there a way of changing the points awarded for games to include 2 points for a score draw.
So end up with
3 for a win
2 for a score draw
1 for a no score draw
0 for a loss
We also use fair play points but I think I can add these into the bonus points box..
I currently use paper to run a 2 day tournament with 60 plus teams across 12 age groups so using this would be…. well LIFE CHANGING FOR ME….
Hi,
you can change points on the Options sheet. For extra points there is the Bonus/penalty points section (see in article). This is only way to do what you want. There will be no updates in the future, sorry.
Jan
I can`t thank you enough. I can`t get tired of thanking you buddy. Thanks so so damn much. This is what I have been looking for years. (since today I tried to make it by myself) This is absolutely great stuff. Superb! Well done.
Spread sheet is just what I want but it there away you can just play each team once in a round robin tournemant
Thanks that’s wonderfull
i am using your 6 teams template. only one group.
can you add a sheet that pulls from your GroupA sheet and makes a Draw for the 6 Teams and 3 divisions?
Hi,
you can easily add more group. See Settings – how to add more groups in the article. If you want to create knockout tournament you have to use some other tool.
Jan
Oh my god I am so thankful to your excel sheet. Your excel sheet really help me as a student and as a Human.
Is there any way to create home and away games within the rounds?
Well there are home-and-away games
Great template…came in very handy for a tournament we were in! Quick question though. Is there a way to add in a point for head to head wins? Two tournaments we’ve attended use the head to head match up as the first determining tie break.
Thanks
Hi,
Great Templates.
Our league awards one bonus point for each GF. Have to add this manually. Is there a way to do it automatically from the league table?
I see all of your templates for the tournaments. Where do I find the templates for the leagues?
Hi,
tournament template can be used also for league.
I have some league files (20 teams and 22 teams) and automated cup files, which I don’t mind sharing for free.
Just email me at m.haigy@googlemail.com and I’ll send some attachments to anyone who wants one.
Cheers.
Matt
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.
ps…I’ve made a small Donation, is not much but every little help they say 😛
If it’s a cup competition you need, there’s a way to create one.
If you’re familiar with using the “=” in Excel, you can create 32 fixtures, then 16, then 8 and so on by simply “equalling” the list where you type your team names in, multiple times. It can be done all the way to the cup final.
Once you’ve built your fixtures list (32s, 16s, 8s etc) you need to create a mini league of the 2 teams who are playing in each fixture. There are youtube videos that explain “RANK” and “VLOOKUP”. If each fixture has an equalled winner, the next round can be drawn automatically. All you need to do is type team names in and stick the scores in! You can have 2-legged games, replays and penalty shoot outs. Difficult to explain in this reply but gimme a shout if you need an Excel file with this system already created. Or I can make a special one for you.
Cheers
Matt
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
Hi,
Could you please help me produce a table based for 18 teams?
Thanks in advance.
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.
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
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.
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
How do you do a forfeit match where two teams forfeit the match!??? Riko
How do you do a match where 2 teams forfit the match??
hi can you create a 17 teams in each group and 18 and 19 and 20 !??
please
Hi Dodo,
You can find a template like that on my webpage: http://www.enterexcel(dot).com =)
Br,
Joachim
Hi Dodo,
You can find a template like that on my webpage: www(dot)enterexcel(dot)com
Br,
Joachim
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?
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
This site is great.
I am looking for Cricket excel score sheet. Please any one who can help to find one I will appreciate
How do you enter a win by default and award the team that won its points?
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.
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.
Hi,
you can use Save as in File menu.
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??
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
Hi,
thank you 🙂
You can easily delete these rounds. For example: select cells >> right click >> delete >> shift cells up
This template is perfect for an upcoming tournament bu how can I add it for 18 teams – any help really appreciated
Thanks
Christian,
If you go to www(dot)enterexcel(dot)com you will find a template for 2 to 25 teams there.
Br,
Joachim
EnterExcel
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
Hi,
thank you 🙂
Why do you want password?
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
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
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.
Hi,
I had the same problem. I’m using Bonus/penalty points section. It is not the best solution but it works 🙂
Javier,
Contact me through support@enterexcel(dot)com and I can help you make this template against a small donation.
Br,
Joachim
EnterExcel
Hi Jan, is there by any chance a 20 team template?
Hi Ernesto,
I have a template for that (up to 25 teams for multiple sports and 35 players for football) that you can download for USD 5.00 at my web page.
http://www.enterexcel(dot)com
Br,
Joachim
EnterExcel
Hi
I Want Only Two Team And Rounds Seven So I did Try Create This But Not Rite !!! Can You Help Me Pls Thank
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 !!!
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
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.
Hello,
where do you want to add column? What kind of column will it be? Do you need any extra calculations?
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.
Hello,
in one sheet you can’t. In one file you can 🙂
Read part:
Settings – how to add more groups
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
Thank you. I’m glad to hear that it is useful.
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.
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
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
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 🙂
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?
Hi
Can You Create For Snooker Scoreboard ?
I Really Need This
So Please Let Me Know Thank
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
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
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.
Scott,
Contact me through: support@enterexcel_dot_com and I can see what I can do for you.
Br,
Joachim
EnterExcel
Hi,
Are you able to do up a 17 team tournament draw ?
Cheers
Zac
Hi Zac,
If you go to my web page: http://www.enterexcel_dot_com and go to templates, there you will find a template for 2-25 teams.
Br,
Joachim
EnterExcel
Hi Zac,
If you go to my web page: http://www.enterexcel(dot)com and go to templates, there you will find a template for 2-25 teams.
Br,
Joachim
EnterExcel
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
Thanks
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.
Hi Nigel,
Contact me through support@enterexcel.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
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
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”.
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.
Ahmad,
I have a template like that available on my web page:
enterexcel(.)com
Br,
Joachim
EnterExcel
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
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
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?
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
i need the templates for 20 teams, thanks
Hi Domenico!
Send me an email at support@enterexcel.com and I can send you one =)
Hi Domenico!
Send me an email at support@enterexcel(dot)com and I can send you one =)
Need format for 8 teams- Group A and Group B – 4 TEAMS IN EACH-
2 ADVANCE FROM EACH GROUP FOR SEMIS AND THAN FINAL
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
Hi if i drop you an email van you send me the template as well please
Sure Mike. Just send me an email at support@enterexcel(dot).com =)
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
Hi, how can I make a 2 teams template with endless number of rounds?
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
GOT IT THANKS
SORRY FOR NOT READING IT THOROUGHLY
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!
Hi
We are starting a 17 team pétanque league and wondered if there was a template for this?
Norrie
Sorry but I can’t see the 20 team table on the free templates site
Norrie
Norrie,
Send me an email at support_at_enterexcel_dot_com =)
Br,
Joachim
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
Stupid me misunderstood you message – email gone now.
Norrie
My rank doesn’t work, please help me?
I see this when tried to edit =AA3+AC3*10000+AD3*100000000
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.
please can you help ??
need a league table for 17. do you have a template or can a 16 one be modified easily.
Daz,
I have one on my webpage you can download, just go to
enterexcel_dot_com and go to “free templates”.
/Joachim
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
It is for 1 to 20 teams. You just delete the team names 18/19/20 🙂
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
🙂
Great job Jan! Tnx!
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?
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
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
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!!
Andrew,
Go to my site enterexcel_dot_com and send me a request there, I can help you 🙂
Br,
Joachim
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…
🙂
Hi, is there a template where I could go to know-out matches after group phase? Thanks
Rolando, I can help you with this. Contact me through http://www.enterexcel_dot_com 🙂
Br,
Joachim
EnterExcel
Rolando,
I can help you if you go to enterexcel_dot_com and send me a request there 🙂
Br,
Joachim
EnterExcel
Hi, great template. Just for the record, the formula for 16 team was not upadated. It still uses 15 team formula
Thank you.
I have checked it and 16 teams template is ok.
Fantastic resource, is there a 20 teams one available?
willie,
i have one on my webpage, 20 teams, up to 4x round robin.
go to enterexcel_dot_com
br,
joachim
Hi,
I just wanted to say these are very helpful. Thanks for sharing.
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.
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
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.
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
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
Hi Que,
Contact me through enterexcel_dot_com and I’ll help you there.
Br,
Joachim
EnterExcel
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
hello, is that possible for a template with 48 teams like UEFA europa league??
table/fixtures/goals etc.
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.
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
Yes, you can. There is sheet ‘Options’. There you can edit points for win, draw and loss.
But the sheet is pass protected and we can’t get in.
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
Yes, sheet is protected. You can edit only the cells containing points (B2, B3, B4).
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
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
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.
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
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
Matteo
Have you had any success with an excel spreadsheet making a conference. Very interested to try this.
Thanks
James
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
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
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
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
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
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
Hi Bek,
Ok, thanks.
So how many teams in this comp?
/Joachim
EnterExcel
Hi Joachim,
We have 10 ladies teams and 10 mens teams.
cheers,
Bek
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
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
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
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
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
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
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
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
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
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
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
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
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!
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
Exactly!
OK, I can fix that on Monday.
Br,
Joachim
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
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
Hi,
Do you by any chance have 1 with 17 teams and 1 with 18 teams? 2 rounds are also enough. Thanks
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
Hi,
Standard like your other Templates is fine. Points can easily be edited. It’s teams that is hard to add. Thanks in advance
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
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
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
I have uploaded it now to the same page, good luck =)
Br,
Joachim
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.
I could perhaps help you, but how does it work with only 10 weeks?
/Joachim
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
I can probably fix one you. Let me look into it tomorrow.
Br,
Joachim
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
Cheers mate
Thanks but I need a password. Do I need to make a donation to get this ?
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
Hi, great spreadsheet. I don’t suppose you have a template for 26 teams by any chance ?
Can you make a basketball one
What kind you looking for?
/Joachim
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?
Hey, do you mean like columns showing “home” and “away” stats?
Br,
Joachim
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
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
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)
Trying to fix it now 🙂
/Joachim
HI
YEH THATS IT JUST SEEN YOURS .. 😀
How many teams in the league and does each team play the other teams once or twice?
/Joachim
9 at present
4 times long season
Go check it at my website:
enterexcel_dot_com/spreadsheets
Let me know how it works out.
Br,
Joachim
enterexcel_dot_com/spreadsheets.html
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 😀
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
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
Does someone have a 24 team template they can share??
Hi Ben,
What kind of sheet do you need? Just a standard league with 24 teams, two matches vs each team?
Br,
Joachim
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
Please sand to me 20 teams I need it .
best regards
Yousef
Hand me a email then 🙂
/Joachim
could you please send me a 20 team format. please.!!!
HI JOACHIM.
COULD YOU SEND ME THE 20 TEAM YOU HAVE PLEASE !!
SEND ME 20 TEAM FORMAT PLEASE !!!
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
Hi,
Can you please add 5 locations ,3 time slots and Minor officials to the sheet.
Thanks,
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
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..
Steffen, you still looking for help with this?
Br,
Joachim
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
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
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
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?
Hi, Please send me a fixture format for 32 Draw for individual open tournament.
Thanks
Rhamanan
Singapore
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
Hi
is it possible to use this template so that teams play an equal amount of games on four rinks?
Thanks
Bri
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
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
Did you get any help doing this? 🙂
Br,
Joachim
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
Hey, I could easily fix this for you if you are still searching for this type of sheet.
Br,
Joachim
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????
hi,
did you get any answer for 24 teams template?
regards
if you still need it, I have one I can send you per email.
Br,
Joachim
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
Hi
Can you help me win 2 tables and then with knock out stage in same tournament table please
Thanks
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?
Hi, could you possibly create an 18 team template for download please.
This template helps us a lot in the tournament. Great Help!!!
good templates thanks
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.
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 ?
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
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 .
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
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
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
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
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.
Hi how do i remove the significance of goal difference and allow goals scored to take priority?
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 ?
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.
Hi, would you mind sharing it by email? I am looking for a 22 teams league template. Thank you.
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.
Hi, Can you please share your 22 teams template??
Thank you!
Does anybody know how to add extra rounds? I’m looking to add at least another 6 rounds.
Hi
I Want To Know How Do Automatic Draw Then Put In The Four Groups (A,B,C,D) ??
Thank You
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
Hi, any chance you can provide one of these for 20 teams? I am rubbish with excel. THANKS!
Thank you so much for doing this – this is awesome ! Saved me hours of work doing the kids football league tables.
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
it there a template for a two division league
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?
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!
hi, could you post a 18 team version, please
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.
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
Hi,
Is it possible to have the first tie breaker be the team with the least GA?
Thanks!
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.
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.
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
Hi,
read the “Bonus/penalty points” section. There is what you want.
Hi, can I please get the password to the protected options sheet. Thanks
Hi,
I’m sorry you can’t. Important cells are unlocked.
Thank you, so much for this, it really helped me make my tournaments successful.
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.
Brilliant and God bless!
This is amazing!! THanks.
What’s the password to unprotect the OPTIONS sheet?
I’m trying to create a 20 team league where each team plays 16 games. Can anyone help modify this file for that?
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
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
Hello,
can you please send me the 18 team tournament table to my email?
Thanks and best regards,
Leo
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.
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.
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
Hi , how do i adjust it for 9 teams?
Reply me soon.
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
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
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
Thank you very much for the table sample very useful just the right one for my local street tournament
Is there a template for 20 teams? I tried using the video but is too time consuming
Regards,
Mark
Will be using it for our tournament.
Thanks!
16 Teams error
$18,
Options should be $19
How would you do the template for 18, 20 & 24 teams IN A LEAGUE?
Hi,
I have just uploaded the video guide how to do that.
where I can’t find it?
Hi,
It’s above in this article. Section: How to update and create more teams template.
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
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
Looking for template with unbalanced groups.
Group A and B with 5 teams , Group C and D with 6 teams
Hi,
If it’s not necessary to have it in 1 file, you can use 5 teams and 6 teams template.
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???
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
Hi,
I checked the template and it is OK. It gives 7 games per ROUND for each team.
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
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
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
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.
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
Hi,
video guide is online :). I hope it helps you.
GRACIAS POR SU TIEMPO…
Good day
I am looking for 6 teams in one group playing each other twice?
Regards
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.
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
Thanks Jan for adding the 16 teams template.
You are a legend.
Regards
Dobrý den, máte prosím soubor pro 20 týmů? Děkuji 🙂
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 :/
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á.
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.
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.
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
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
Hi Wayne,
there it is. I have just added 16 teams template.
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.
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.
TY! And great work! Really awesome sheet!
Gav
can yu tell mi wich formulas use, , becasu I trying to create groups like you but doesn’t work.
Hi,
you don’t need any formula. Copy the whole worksheet like in this tutorial: http://easykey.uk/excel/a-quick-way-to-copy-an-excel-worksheet
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
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
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
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
Hi,
it’s easy. Just write the new formula next to the table. For example =M14/N14*100 for Pirates in the picture above.
Jan,
Sorry to ask again.
Any chance of a template for 13 teams?
Ray
Hi Ray,
there it is. Templates for 13 and 15 teams. Can I ask you, what sport are you scheduling?
Jan
Jan,
Not so much a sport but fantasy dice competitions
Ray
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.
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
hi! possible to include 15 teams? I’ll be happy to donate via paypal… thanks in advance!
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
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
Hi Ray,
I’m not busy, I’m lazy 🙂
Here it is.
Jan
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?
Hi John,
You can use 4-teams template and 3-teams template I have just created.
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
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?
Hi, it’s simple. Points from previous games write in the Bonus/penalty points section.
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?
nice sheet, but i can’t use it on galaxy tab. The table colum is all “value” Tell me how to use it, please
This template uses advanced formulas and it is designed for MS Excel only. It may not work correctly in other programs.
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
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.
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
Can you do up for 20 teams versing each other once
Can you do a template for 20 teams versing each other once?
Fantastic spreadsheet. Thank you very much.
Would you happen to have one for 9 teams?
Why not 🙂 here you are, enjoy it.
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
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!
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
Hello,
do you enter this as an array formula using CTRL+SHIFT+ENTER?
I’ve been racking my brains on this all day.
I’m in the same boat, having put a lot of hours into my own attempted version before eventually finding your wonderful resource.
But I’m unable to create the homescore, visitorscore options in a way that Excel recognises. I presume this is a shortcut to some kind of VLOOKUP formula (in formula builder?) but I’m getting a bit out of my depth with it now.
Any pointers to what makes the homescore and visitorscore tags work would be much appreciated.
Thanks
do you have a template for 14 teams
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.
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
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.
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.
Thanks for the spread sheets, daughter using for carnival, so thanks again.
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
Can you provide a template for 14 teams
Wondered if you could assist with a 14 team sports tournament?
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?
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
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.
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 🙂
How can adjust after 2nd round
Hi, now you can use up to 4 rounds.
I want to Calculative Chart huge data made a format which is provide me financial report
template is fantastic,
how can i adjust it from 10 teams single to home and away matches please
regards colin
Hi, I have done some updates. Now you can use up to 4 rounds (2x as home, 2x as visitor).
thank you jan your a star.
worth a donate thank you
Hi,
i need an excel spreadsheet for two day tournament for one group containing 5 Teams.
Do somebody has any?
thnx and regards.
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
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
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?
Hi, this template is amazing. How can i change it for 3 teams championship and make it a lot of rounds? Thanks
great worksheet just need to be able to schedule for 15 rounds for 4 teams. Any easy fix??!!
Cheers
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.
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.
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?
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
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
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.
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?
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.
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. 🙂
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
Hi the Sports template is great but I need one for 14 teams is this possible to do
Thanks
Mike
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.
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
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.
LIKE picture above for lions and kings
Like in picture above. The place of Lions and Kings must be changed as Kings GD is more than Lions
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,
want a draw 4 teams 3 grades 18 rounds suggestions
How do I get more fixtures/rounds in the schedule section ???
I want to have roughly 10-12 rounds, any help Please ???
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
Hi, I have added templates for 10 and 12 teams. I hope it will help you.
This template is perfect for an upcoming tournament bu need it for 7 teams – any help really
Appreciated
Thanks
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.
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
pls i need the template for the top goal scorer and i want it to auto update whenever i input a data.
Hi , This template is great however how do i adjust it for 7 or 8 teams please?