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:

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

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.

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.

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.

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

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.

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?

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

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…

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?

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.

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.

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?

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,
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!!

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…

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

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.

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.

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

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?

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.

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.

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.

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

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.

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?

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?

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

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.

Joachim December 22, 2016 at 4:10 pm

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?

Mrkky December 22, 2016 at 4:16 pm

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.

Joachim December 22, 2016 at 4:24 pm

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?

Mrkky December 22, 2016 at 4:27 pm

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

Joachim December 22, 2016 at 4:34 pm

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?

Joachim December 22, 2016 at 4:36 pm

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

Mrkky December 22, 2016 at 4:45 pm

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

Mrkky December 22, 2016 at 4:55 pm

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?

Joachim December 22, 2016 at 5:02 pm

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

Joachim December 22, 2016 at 5:09 pm

Ok, the newest version is uploaded

/Joachim

Joachim December 22, 2016 at 5:17 pm

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 =)

Mrkky December 22, 2016 at 5:18 pm

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

Joachim December 22, 2016 at 5:26 pm

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

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

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.

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

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

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?

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 .

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

scott June 16, 2016 at 6:09 pm

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

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.

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.

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

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

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.

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

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

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

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?

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

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.

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.

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.

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.

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.

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

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

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?

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?

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

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

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

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.

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.

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.

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.

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.

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