I started to create fixtures and scoresheet for Spanish La Liga, Italian Serie A, Germany Bundesliga and French Ligue 1 in 2008. There was England Premier League at that time before I got warning from England Premier League license holder to drop that spreadsheet unless I paid license fee. Each year, I added more features and started to create a dynamic template that can accommodate all of those leagues within one spreadsheet just by changing some parameters.
I revisited this original spreadsheet and I saw that this simple spreadsheet can be developed to record team match statistic. But, it won’t record all match stats but should be enough for important stats. You will need the Soccer Team Stats Tracker spreadsheet if you want to record more detail match statistic. You will get, at least, top scorer stats for one team. But, not all stats are available in free version.
This spreadsheet consists of four big parts.
Team Standing and Top Scorer Table
You can track rank progress of all teams after they completed their matches. Here, you can see their performances while they were playing at home or away. They are ranked with tie-breaker regulation as follows :
- Highest Point
- Better Goal Difference
- Better Goals Scored
- Manual Re-Rank
Since it uses simple tie breaker formula, you need to rerank them if their final positions are not similar with their official standing. You can use Change Position table at the right side of standing table to switch their position.
Why don’t I create the exact tie-breaker formulas? Because in this spreadsheet I tried to focus on other stats to be shown, i.e. Top Scorer and Individual Team Stats. It already consumes high computer resources when the calculation take place. You can use the other European Soccer League Fixtures if you want have exact standing.
Top scorer table will rank 50 players from all teams. The formula will sort their number of goals and then their number of assists. Here, you can see Lionel Messi vs Cristiano Ronaldo in Spanish La Liga. This feature only available in Paid version. There is no top scorer formula in free version. You must update it manually.
Type team names and their home stadium in this worksheet. There is a point reduction column to put point penalty if particular team is punished by their country league official. There is a column for counting the number of team occurrence in Fixtures and Results worksheet. You can use it to check whether you have typed team names correctly. It should be the same with the number of matches that particular teams played in respective leagues. For example, in La Liga, each teams have to play 38 times within one season.
Fixtures and Results
This is a one page fixtures worksheet. You can copy and paste all fixtures in this worksheet. This is the worksheet where you update score results weekly.
This is a worksheet where you cam update particular team stats. I will explain them as follows. I separate this worksheet into 8 parts to ease the explanation as you can see in image below.
The Excel formula will place team name automatically in each worksheet. But, in free version, since it only accommodate one team, you will have option to select one team to record its match stats.
A. Player Names and Stats
In this table, you can type until 30 player names, including their shirt numbers and positions. It doesn’t have to be based on shirt number order. You can find this squad internet site easily. At the right columns, next to each player name columns, you will see their stats. These numbers will be updated automatically based on stats you put in Team Match Stats box (part B).
It is possible that number of players you found in internet within one team exceed 30 players. In that case you must select players who contribute more in this squad list.
B. Team Match Stats
Update match results in this match stats boxes. There are 38 match boxes for La Liga, Serie A and Ligue 1. I used Real Madrid as a sample. This team is always on the left side. You can see them playing home or away by seeing Home/Away note at Home/Away column.
Remember, these match stats boxes are not designed to record all match statistics. You may need other spreadsheet for that purposes.
There are 20 lines to log players with goals, assists and cards. I put dummy data in the first match box to help you understanding how to fill it. To update it, select player name, time (in minute) and its category code. Filling the opponents box is optional since no data are collected from opponent side, except their goal’s code. Its goal code will be used in goal distribution chart.
Also, when there is an own goal, you can select OG and doesn’t have to put player name. You can put the player name, but you must select it from the opposite side.
Below that 20 lines, there are six lines to put other match stats. Those are Shots on target, Shots off target, Possession (%), Corner Kicks, Offsides and Fouls.
I grouped match 3 onward where you can expand to type match stats and collapse it to shorten the view. You still can see the score results, though.
C. Match Summary Stats Table
Here, you can see match statistics. There is one table to show you statistic for all 38 matches and one table to show you match statistic in average.
D. Top Scorer Table
The rank formula will sort all goal scorers by their goals and assists numbers. There are Spanish La Liga, Italian Serie A, Germany Bundesliga and French Ligue 1 spreadsheets you can download to track top goal scorers in those leagues. Like Lionel Messi from Barcelona in Spain, Gonzalo Higuain from Juventus in Italy, Lewandowski from Bayern Munich in Germany and Cavani from Paris SG from France.
E. Goal Distribution Chart
You can see goal distribution over 90 minutes period in this part. They are divided into 15 minutes period.
F. Top Assist Table
You can see your top players in assists.
H. Team Match Chart
This chart will show you team performance match by match. Top part will visualize win-Draw-Lose result. You can directly see whether their Home and Away matches affected their performance by seeing green and yellow color below it.
I add visualization of team possession to ease you seeing whether dominating the match will always give the team positive result. At the bottom of the chart, you can see their standing progress throughout entire season.
As informed, there are limitation in free version. As a result, you can’t maximize all of available features. You can upgrade it to paid version to fully maximize it. Since it is unprotected, you can use it every year by updating team names and their fixtures. You can also use it to emulate other leagues. There are features comparison between Free and Paid version that you can read in About worksheet. I wish I could publish England Premier League fixtures. It should be interesting to track Manchester United, Chelsea, Arsenal and other teams especially if the race is as tight as last year.
You can download European Soccer League Fixtures and Scoresheet if you do not need these Top Scorer and Team Stats Log features. Also, try Soccer Team Stats Tracker as well if you want to record complete statistic of particular team matches.
2017/2018 Ligue 1 Fixtures and Stats Tracker V2.1 (591.0 KiB, 322 hits)
2017/2018 Serie A Fixtures and Stats Tracker V2.1 (585.3 KiB, 338 hits)
2017/2018 La Liga Fixtures and Stats Tracker V2.1 (568.0 KiB, 346 hits)
2017/2018 Bundesliga Fixtures and Stats Tracker V2.1 (525.7 KiB, 288 hits)
2017/2018 European Football League Fixtures and Stats Tracker – Fully Unprotected
License : Single User/Personal use