Excel Templates | Excel Spreadsheets



German Bundesliga 2012/2013 Fixtures and Scoresheet

Posted on August 25, 2012
Filed Under Soccer, Sports | 10 Comments

This is a new fixtures and scoresheet template to be used for German Bundesliga season 2012/2013. There are two version you can download, the Excel 2007/2010 version and the Excel 97/2003 version. There are many improvement has been made in Excel 2007/2010 version comparing with the old one, as you can see in the screenshot.

Several improvement you can find in Excel 2007/2010 version are:
- Team fixtures is displayed with calendar style
- Team progress chart will display both position and Win/Loss/Draw results
- Standing table will display team’s previous matches
- Matches worksheet will show team last 5 matches, team previous head-to-head matches, and team current standings prior to the match
- The position of any teams in final standings will follow Bundesliga policy where their policy is as follows:
1 – All Matches – Highest Point
2 – All Matches – Better Goals Scored
3 – Team Concerned Matches – Highest Point
4 – Team Concerned Matches – Better Goals Scored
5 – Team Concerned Matches – Better Away Goals Scored
6 – All Matches – Better Away Goals Scored
7 – Manual Re-Rank

Read more

Spanish La Liga 2012/2013 Fixtures and Scoresheet

Posted on August 25, 2012
Filed Under Soccer, Sports | 22 Comments

Sorry for late update on new fixtures template. It took more time than I have predicted to modify and finish the tool to create this fixtures.

These templates, which based on excel 2007/2010 are totally different from previous templates. I created the general tool first, Soccer League Creator, so I can easily map all 5 European League templates just by typing the parameters in the Setup worksheet.

In this post, you can download Spanish La Liga fixtures and scoresheet for season 2012/2013. The new version is working well using Microsoft Excel 2007/2010. But, you can download the old version if you are still running Microsoft Excel 97/2003. Honestly, I suggest you to upgrade your Microsoft Excel because there are plenty of features you will get in Microsoft Excel 2007 and above. If you are running Excel 2007/2010, you can download and compare both version, so you will see the differences between those versions.

Read more

Soccer League Creator

Posted on August 25, 2012
Filed Under Soccer, Sports | 50 Comments

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

Read more

Page 5 of 50« First...34567...102030...Last »