Soccer League Creator
- Version
- 70'775 Downloads
- 14.9 Mb File Size
- January 4, 2022 Updated
- 59 Number of comments
- Rating
After 13 years of creating some major European league competition template for excel with the same layout, I thought about making new ones with more features, for example, add information about any teams previous matches, display any team matches in calendar form, etc. And, while thinking of re-designing the layout, there was an idea to make a tool which can be used to generate any soccer league tournament or to be used to map any of league competition around the world. And this Soccer League Creator Template for excel is a result of those thoughts. With this tool, I can easily create those Italian Serie A, Spanish La Liga, German Bundesliga, French Ligue 1 and Dutch Eredivisie without touching the codes inside excel. And if you run your own soccer league, either real soccer competition or just playstation soccer competition, this tool will simplify your matches arrangement process. You can speed up the process by entering your custom parameters, for example, points value for win, lose and draw, season start date, matches cycle (from daily until biweekly), team names, etc, and this tool will do the rest.
This tool also suitable for you who want to map your country or local league competition. Use the Soccer League Creator without fixtures generator version, and you can easily map your competition manually. There are some European League competition samples that you can download in this site to see how this tool works. But remember, you are not allowed to map any league competition under England FA, such as Premier League, or within Great Britain territory since you have to pay for a license to map those fixtures.
There are several features that you can find in this tool:
Ξ Standings Information with Dashboard Style
This tool is equipped with a dashboard which will ease you to :
– Monitor current standings
– Monitor progress rank of the top 4 in standings
– See the next and previous matches based on today’s date
– See the home and away team biggest win
> League Competition Dashboard <
– Monitor current standings
– Monitor progress rank of the top 4 teams in standings
– See the next and previous matches based on today’s date
– See the home and away team biggest win
Ξ Accommodate up to 36 Teams
It can accommodate up to 36 teams.
Ξ Flexible Competition Type
There are full and half competition options available to be selected
Ξ Feature-Rich Individual Team Information
This Individual Team Worksheet will allow you to:
- See all team matches and results in table view
- See the standings weekly progress in chart view
- Add non league competition where each team participated
- See all team matches in one year calendar in calendar view
And with its default one-page layout, you can easily see, print and distribute this information among teams who participate in this competition.
Ξ Custom Season Calendar
Visualize all team matches in one year calendar, and add holidays consideration to re-arrange any matches to suit your available time.
Ξ 8 Tie-Breaker Combination
There are 8 tie-breaker combination derived from 9 tie-breaker options
9 Tie-breaker options are:
- All Matches – Highest Point
- All Matches – Better Goal Difference
- All Matches – Better Goals Scored
- All Matches – Better Away Goals Scored
- Team Concerned Matches – Highest Point
- Team Concerned Matches – Better Goal Difference
- Team Concerned Matches – Better Goals Scored
- Team Concerned Matches – Better Away Goals Scored
- Manual Re-Rank Based On Fair Play Calculation, Head-to-Head Matches, Drawing of Lots
Those 9 tie-breakers options will be combined into 8 choices as follows :
- 1,2,3 (team position will follow rule number 1, then 2, then 3)
- 1,2,3,9
- 1,2,3,5,6,7
- 1,2,3,5,6,7,9
- 1,3,5,7,8,4
- 1,3,5,7,8,4,9
- 1,5,6,2,3,4,7
- 1,5,6,2,3,4,7,9
Ξ Automatic Fixtures/Matches Generator
There is a built-in fixtures generator which will generate all team fixtures/matches.
Ξ Flexible Match Dates Cycle
There are 5 match dates cycle you can select. You can set time between matches from daily, twice a week, three times a week, weekly until biweekly.
Ξ 6 Different Group Position Colors
You can easily mark and group team which qualify for certain tournaments or relegated to lower division
Ξ Custom Earning Points
You can set different points value for home and away win, draw and lose.
Ξ Feature-Rich Matches Worksheet
There are useful information available in matches worksheet, besides dates, team names and score boxes, that you can use to evaluate your team performance. Those are last 5 matches, current standings, and previous head-to-head meetings.
Ξ Rescheduled Matches Worksheet
There is a reschedule matches worksheet that you can use to monitor any rescheduled matches.
Summary
This Soccer League Creator Template for excel is a template which suitable for you who run your own soccer league, either real soccer competition or just xbox or playstation soccer competition, and need a tool to simplify all matches arrangement. This tool will save your time on managing and monitoring your team matches. You can easily specify points value for win, lose and draw, arrange team matches, and set its cycle (daily, twice a week, three times a week, weekly and biweekly). Just type your league parameters and team names and this tool will do the rest.
This tool also suitable for you who want to map your country or local league competition. Use the Soccer League Creator without fixtures generator version, and you can easily map your competition manually. You can download and see some samples of European League competition below to see how this tool works. But remember, you are not allowed to map any league competition under England FA, such as Premier League, or within Great Britain territory since you have to pay for a license to map those fixtures.
- Spanish La Liga Fixtures and Scoresheet
- Italian Serie A Fixtures and Scoresheet
- German Bundesliga Fixtures and Scoresheet
- French Ligue 1 Fixtures and Scoresheet
R. Musadya ( )
Hi Richard,
I am sorry, current tie-breaker combination are the only available option you can select. Adding new combination set is possible but requires hours to tweak its main excel function. Due to limited time, I don’t think it is possible to create it in this point of time.
Best regards,
Marco ( )
Remember to change the filename in this cell if you have renamed the file
After changing the file name, queue dialing stops working
RichardD ( )
Hi Musadya,
I have just purchased the pro edition and it is excellent. Thank you for creating the file.
I have looked at various other European Leagues and many use slightly different Tie-breaker options than the 8 you have programmed. How easy would it be for me to add other conditions in? (for example Matches won, away matches won and head-to-head matches won). Would it also be possible to select my own order in which the rules apply? (for example 1, 5, 6, 7, 8, 2, 3, 9)
Many thanks in advance for any help you can offer.
Shaun Daniels ( )
Where can I buy the PRO Edition?
I need to schedule our league for Saturday and Sunday matches e.g. Saturday 6 May 2023 Team A vs Team B, and on Sunday 7 May 2023 Team C v Team D. I want to do this in the Auto League Generator.
R. Musadya ( )
@Obede : Sorry, it is protected. You will get error message from google when you uploading it to google drive.
Obede ( )
Can I upload to google drive and share the information with my friends?
Fred King ( )
Hi,
Can I add a worksheet and be able to transfer
data from the results page.
SHAUN ( )
Im looking for the premier league one pleASE 2013/2014
Chris Horner ( )
I’ve discovered another small flaw, if you choose a half competition when you go to the ‘Team Info’ sheet only the first half the teams show up at the top. Though you can use the arrows underneath to scroll across to the remaining teams info.
Though it’s a very small flaw in an otherwise brilliant league table generator spreadsheet.
Ramses ( )
Hello Im currently in charge of keeping the standings for a league that has 4 divisions. I dont need the fixture generator. What program would you best recommend?
R. Musadya ( )
@Charis :
Re-rank cells will be shown in standings worksheet only when the score is typed in matches worksheet and there is more than one team are sharing the same points, goals difference and goals scored.
Regards
Charis ( )
hello,
on the setup table i have put 1,2,3,9 for tie breaker regulation but i dont have the re-rank column on the standings table. Please answer me as soon as possible because is emergency
Kind regards
Ash ( )
Hi,
I’m reading many good things about the pro version but want to check a few things first.
I see above somebody said that some team get a bunch of home games in a row and they wanted a more even draw.
– It seems you have answered that and have fixed the problem but in the light version which I am trailing some of my teams are scheduled to play nine home games in a row. Is this because the lite version is not the latest version
– as per another user, am I covered for updates after I buy
– I am trying to transpose this to Australian football. Is there any chance you could write an option for set where the user can choose between GD or % for the standings table (% is For / Against * 100)
– can it set up to play a season culminating in a “final series” ? This is what we do here in Australia (even for soccer)
– finally and most importantly, when using the trial version (lite) when I go to save, excel displays “a significant amount of functional errors” there is a lengthy scroll bar with about 50 errors and will not allow me to save as is. If I choose to save then nothing works next time I open. I have tried saving as over 10 file extensions. I have windows XP on one computer and Windows 7 on another and both have Excel 2007.
Charis ( )
hello,
on the setup table i have put 1,2,3,9 for tie breaker regulation but i dont have the re-rank column on the standings table. Please answer me as soon as possible because is emergency
Kind regards
Mads Gottler ( )
Hi,
I’ve just bought the sheet, and I have filled in my data and team names etc. Now I am not allowed to jump between the weeks – I’m getting a message that the file cannot be opened. Can you help me?
Best regards
Stephen Morgan ( )
Hi Musadya
I am the Match secretary for an association is South Africa. We have about 20 Leagues.
Is there a facility whereby the system detects a clash of fixtures for teams that use the same stadium?
Thanks
Steve
Bill ( )
How do I create a schedule (Fixtures)
Dave ( )
I have bought the password and would like to ask if it is possible to:
1 Change the “last 5 results” that show up in the weekly fixture list to allow times (and/or scorers) of goals – I have a system to replay a whole set of fixtures all at once – instead of a game at a time – and this would record all the details.
2 Can the team league standings – as shown in the weekly fixture list be altered to put in half times instead?
This is a brilliant spreadsheet and well worth paying for the full set up, believe me. I have had great fun downloading the various Leagues (and sometimes changing them to suit local amateur and junior associations) and playing matches with my system.
Dave ( )
Musadya has explained earlier that the miserable bunch at the EPL (the “Greed is Good League”) won’t allow the fixture list to be used in any game/setup without a fee being paid.
Steve ( )
Hi,
Can I please ask what the upgrade policy on this? If I buy the full version (and the password) am I entitled to any upgrades?
Many thanks
ukijo ( )
what about barclays premier league ?
Charis ( )
Hello,
Is there any way to change the dates? for example i want to have weekly basis games but every three weeks i want to have off…is it possible?
i have the lite version but i am planning to buy the pro version. thanks
Honeybees ( )
Musadya, I find another minor error.
In the weekly progress chart, sometimes the annotation for the result in round 24 goes wrong. (e.g. a W for a loss or a L for a win)
Dave ( )
Musadya, Silly me – you have probably mentioned this before to others. Have done what you say and it is working fine. Many thanks – it is a brilliant programme.
I have bought the password and just need to work out where to use it – but I will perservere as I don’t intend changing much, if anything.
R. Musadya ( )
@Dave: If you have renamed the file, try also to replace the filename in setup worksheet, including its extension. It should fixed your problem :). Let me know if you still have a problem. Regards
Dave ( )
Aaagh! I have put in all the detail for a 24 team league and have played a match. However when I want to click on a team (to see their full fixtures)or to advance a week or a date to view a set of games I get: Microsoft has identified a potential Security Concern (Hyperlinks may be unsafe). It asks if “I want to continue” and even though I say yes it says it “can not open specified file”.
Any ideas please – I have a password.
R. Musadya ( )
@Honeybees: Thanks. That is a very sharp observation. I missed to modify week chart reference for odd number of teams. I will update it and inform you soon. About the tie-breaker regulation, modify the current regulation is easier than add more regulation. Because I have to reconstruct all table formulas to accommodate one more regulation. And I need more spare time to do it. I will think about it. Regards.
Honeybees ( )
I found some minor errors in v2.26 when creating a league with 11 teams, which means there’s always a team going for a bye in each week. There should be 22 rounds for the whole season and each team should play 20 matches.
Now for the team having a bye in the 1st round, the calendar view shows nothing but “###”s. Also the weekly chart views of every team consist only 20 weeks, which means the standing curve in week 21 and 22 cannot be shown.
For the tie breaker regulation, is it possible to add one option – 1 5 6 7 2 3, as used in Spain La Liga?
Dave ( )
Musadya, many thanks for the response and the updated programme – the fixture query has been sorted and I have now downloaded the password – let’s have some fun now.
Can’t wait to experiment with different leagues (including some fantasy ones) and the ever changing league table on the same page is immense. Cheers.
R. Musadya ( )
@Honeybees: Try to reply the update email that I’ve sent to all SLC Pro buyers, so I can activate it again. Thanks.
R. Musadya ( )
Hi Honeybees,
I have updated it again. The chart is fixed now. You can download it from the same link and try it again. Let me know if you still found some errors.
Thanks
Honeybees ( )
Dear Musadya,
Your feedback is super fast! Yet the chart-view issue looks unresolved. Now every team (expect team 1) has a fixed 70-week chart regardless the length of the season.
R. Musadya ( )
@Honeybees: Thank you for your correction. It is fixed now. I will send a new download link in one day.
@Dave: I have updated the new version to have more balance home and away matches.
Honeybees ( )
Thank you for your quick reply!
Here’s an example for the incorrect marker, please check it out:
Week 1, match#1, date 3/12/2012, team5 (H) 3-2 team1(A)
When switching to calendar view, you’ll see both teams have a red “12” with a green frame.
R. Musadya ( )
Dear Honeybees,
Thank you for your feedback. Please find my answers as follows:
1. Noted. I’ve checked the chart and I found an incorrect reference in the chart. I will correct it and send an update email so you can download the new version.
2. Could you give me an example? If the markers automatically adjusted, it could be caused by a slow process in Excel which made the updating process not done as soon as you update the value.
3. You are correct. The weekly standing table won’t follow the tie breaker method, since the tie-breaker method only applied in the last matches, and displayed in Dashboard and Full standing table only. I will put a notification in the file guidance worksheet.
4. Basically, that is a Microsoft Excel 2007/2010 bug :). You can google about this chart topic since many Excel users are having the same issues while working with Charts. But, you don’t have to close and open the file to reveal the chart, just scroll down or right to make the chart out of your screen display and scroll it back again and you will see your chart is appeared again.
Regards
R. Musadya ( )
@Jerome: I am sorry that this template doesn’t have 2003 version due to its conditional formatting limitation on that version
@Chris: The fixtures generator doesn’t support more than two matches at this time, but you can do it manually. Could you send me an email about your specific needs, so I can assist you to make that customization. Thanks.
@Dave: The Pro version still have the same fixtures arrangement, but I plan to make a balanced round matches in the next update. And about dashboard or week matches customization, you can do it by yourself if you bought the password :). Thanks.
Honeybees ( )
Hello,
I downloaded the pro version and I found some bugs in it:
1, The chart view in Team info tab: only the first team can show a full chart, the other teams only show a 12-week chart
2, The calendar view in Team info tab: sometimes it shows incorrect marks in the calendar
3. The weekly standing table always ranks by point > overall GD > overall GS, no matter what tie breaker regulations I choose.
4. The chart in dashboard always disappears when I save my inputs! (although it’ll be back next time I open the file)
Dave ( )
I have tried the Lite programme and it is excellent, except the fixtures are a little strange. Some teams play 5 or more consecutive away games (or home games) – does the Pro programme space out the fixtures to be more even? Can a tie break option be a head to head one? Also on the Dashboard can the bottom right space be used to record say cup ties?
I assume the pro password programme only needs to be bought if you intend changing the current set system?
Chris ( )
I downloaded Soccer League Creator Pro 2.11 however I’m having trouble doing leagues which are 10 or 12 teams for example where the teams play each other more than twice – in your spreadsheet the formula is just for playing one another at home and away so therefor would be far shorter than I need.
Can you help?
Jerome ( )
sorry but can you please put a link to download on exel 2003 ? would highly appreciate if you do so. Thanks
R. Musadya ( )
Hi Joshua,
Noted. I will find another formula which will eliminate the problem if it is used with different language version of Excel. The “ddd” is the custom format which use the first letter of “day” in English version. In Italy it should be “ggg” where g is the first letter of “giorno”. I will post the newest one within a week.
All European League templates are built upon Soccer League Creator version 1.96. The features in that version is enough for building the European League competition. The newest version for the Soccer League Creator Pro is 2.11.
Thanks
Francesco ( )
Can I insert pairs of predetermined games instead of following pairs already provided in every week?
CAB-Power ( )
I would like to know if is possible that at the end of the tournament will create brackets for the first 8 or 4 teams to do single or double elimination and the option to play a championship match?
ukijo ( )
barclays premier league ???
Andy Stewart ( )
Hi Is it possible to add in the Match schedule period for each team to play 3 times twice a week? This is a fantastic piece of work.
David ( )
Hello, the file isn’t opening for me? It’s stuck loading forever, I’m using Windows 10 so it opens with OpenOffice Calc, do I need to use the old Excel?
David Mawi ( )
The file is working well for me, but at the end it keep saying I need password, so what is the password?
Tzso ( )
It looks so professional, proper job, thank you very much!
Daniel-George ( )
Where can I buy the “Excelindo Soccer League Creator Pro without Fixtures Generator – V2.27”?
The Spreadsheet Page ( )
everything that is availabe can be found on this website, for free.
Daniel-George ( )
I have 5 tournaments that I want to organize and use this formula.
How can I do that?
Every time I change the name to save it I can not use it after, it turns off to choose the weeks.
Ian Smalley ( )
I am loving your workbook but have a simple practical question regarding rescheduled matches.
Once the rescheduled match has been played, where should the result be entered; on the original match day tab, or on the Rescheduled Matches tab?
Thanks so much
Alec ( )
Hello,
Thank you for an excellent football spreadsheet. I do have a couple of questions.
Is it possible to get the sheet “unlocked”
I follow the Scottish Football league which is quite a unique set up and I’ve tried to modify the sheet but can’t do it.
In the Scottish Premier, there are 12 teams and they play each other 3 times for a total of 33 games. After the 33 games are played, the league splits into the top 6 and bottom 6 for 5 more games and a total of 38.
The top 6 play each other once, and the same for the bottom 6. Can the Sheet be edited to allow for a format like this?
I’m not too worried about the “split” after 33 games but can it be changed so we can have the teams play each other 3times.
Last point is that I’m currently entering the EPL season 2021/22 and teams are playing more than one game per week.
If this happens, the League Standings do not update correctly. Is something that can be fixed? Right now, If a team plays two times in the week, I’m having to put them into the following week.
thank you so much
Alec
Thommas Bonnesen ( )
Can you make one, to make a all-time table?
Renzo ( )
Musadya
How can I purchase the file and the password so I can edit the league reference and dummy sheets to adjust for my use.
Thanks
Renzo
AndyF ( )
Hi, I am looking at the Standings sheet and that references ‘Dummy’ to get the points, but I dont seem to be able to track that sheet down with the associated data. Would you mind explaining how I find it? I am looking to adjust this for another sport and need additional scoring which I think I can accommodate IF I can locate Dummy…
AndyF ( )
How would i go about getting the password to unlock the sheet i would like to change to accomodate a different scoring scheme?Happy to share the version back after if of benefit to others
Omar ( )
Hi….when I access the TEAM INFO tab I get this error message: “Cannot open the specified file”
Please help
Joe ( )
Hi,
So in my current league, we allow each team to verse each other three times, making it the best way to decide head to head. Obviously the excel only allows for home and away. Is there a way I can change it to allow me to schedule 21 games, or 3 games against a team.