If you are a football lover that want to track your team performance in this year world cup, you might consider this template. World Cup 2018 Match Stats Tracker is an excel template to record and track all 64 world cup matches that will be held in Russia in June. It should suit you who want to keep your favorite team stats in this tournament. There are excel functions in the background that will summarize all written stats into summary tables. All you have to do just typing stats in each matches and select particular stats parameter that you want to see. It should be useful if you want to analyze your team before competing with other team in knock out rounds.
There is a separate player database that you must fill correctly since they will be used as dropdown list reference. Official player names will be released by respective countries by the end of this month.
To use this excel template, you need to go to respective matches and type the stats below its match rows. You can start by distributing players to line up and reserve tables. Then, you can go to minute column to start typing minute where particular events take place. You can select G for goal, FG for goal from freekick, PG for goal from penalty spot, YC for first yellow card and so on. There are tables with each description that you can read at the left side in Match Tracker worksheet. Select respective player names for those events. There are samples inside the spreadsheet that you can see to ease you understanding it.
After matches are completed, you can continue to fill stats summary at the bottom of each match stats table. There are plenty of soccer sites that provide that summary directly, like livescore.com, where you can copy stats information from their site. [click to continue…]
If you are looking 2018 World Cup Head-to-Head Records and Stats in Microsoft Excel, you can use this specific template. It is not free but it is worth it. It could inform you stats of each 2018 World Cup participants during their campaigns in all World Cups. Also, you can observe their head-to-head against their group or knock out opponents. There are World Cup facts that you might get updated on important facts that have happened throughout World Cup events.
There are 5 main worksheets in this spreadsheet.
1. Team Stats
Select your team to see their match statistics for past World Cups and other competitive tournaments. Those stats are :
- Appearances and results summary from past World Cups
- Match score results and their progress in the past 5 World Cups against opponents from different continents. This part should be important one since you can see pattern and records of your teams against countries from all continents. They will have continents color markers to ease you identify your team opponents.
- Last 6 world cup matches records
- Last 10 all tournament matches records. Mostly are from World Cup qualifications around the world. But, it is a collection of competitive matches from UEFA Euro Cups, Copa Americas, African Nations Cups etc.
- Summary of head-to-head records against any countries, grouped by continents, in all world cups, last 5 world cups and other tournaments since 2006
- Summary of head-to-head records against another participants in World Cup 2018. You can easily see a brief summary on team head-to-head records against group opponents in this table as well as other participants if the team advance to the knock out rounds.
- Goals distribution summary. You can see goal distribution during team full time matches (90 + 30 minutes) in the past world cups.
- Common scores summary. What is the most common score results for particular team? 0 – 0 ? 1 – 0 ? You can get the answers in this part
- Current squad (needs update due to each countries haven’t released their official squad)
All countries will get particular background colors that represent their continents. It should help you to observe particular team records when they meet countries from particular continents. [click to continue…]
If you are a football lover that want to track your team performance in this year world cup, you might consider this template. World Cup 2018 Match Stats Tracker is an excel template to record and track all 64 world cup matches that will be held in Russia in June. It should suit you who want to keep your favorite team stats in this tournament. There are excel functions in the background that will summarize all written stats into summary tables. All you have to do just typing stats in each matches and select particular stats parameter that you want to see. It should be useful if you want to analyze your team before competing with other team in knock out rounds.