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

i need the templates for 20 teams, thanks

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

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?

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

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

Hi Domenico!

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