You might be looking for excel templates that could accompany you while watching your team compete in 2018 FIFA World Cup. These are several useful excel templates to help you tracking your teams, analyze their statistics and play prediction game with your friends.
World Cup 2018 Schedule and Score Sheet
World Cup 2018 Schedule and Scoresheet is a spreadsheet that will act as a fixtures and a scoresheet. You can see schedule of all teams in this event and also put actual score results into respective score boxes.
There are formulas that will calculate their group standings after filling the scores. The standings will follow FIFA group tie-breaker regulation. With this formula, you can simulate scores and see how teams are ranked in group standings based on official tie-regulation.
Each groups has specific color background. This color background will follow teams from particular group in knock out rounds. Also, there are formulas that will automate flag placement next to those teams in knock out rounds.
Before using this World Cup 2018 Schedule and Scoresheet, you need to set language and timezone to meet your own local language and time. Default language is English and default match time is following Moscow timezone. There are more than 40 languages you can choose and more than 140 cities you can select to see schedule within your own timezone. If you found that the translation is incorrect, you can use Custom Language feature to correct it. It also applies to city selection for timezone.
Then, you can start typing scores in this spreadsheet from group stages until final match.
World Cup 2018 Schedule and Scoresheet for Excel (1.2 MiB, 1,070 hits)
World Cup 2018 Scoresheet with Goal Scorer Sheet
If you want to track goal scorer in World Cup 2018, you can use this World Cup 2018 Scoresheet with Goal Scorer input spreadsheet. It has different layout with above World Cup 2018 Schedule spreadsheet to accommodate goal scorers input. They are arranged in vertical arrangement where you can type scores and goal scorers to the right side of each teams.
Before using this spreadsheet, you need to update the squad with the official squad from each teams that will be announced in May 2018.
To use it, you need to type the score first and then type player names in blue boxes that will be shown based on filled scores. If scores are coming from own goal, you must select player with “og” bracket. It will exclude particular player from top scorer list.
You can track tournament top scorer from top scorer list at the bottom, next to group standing tables in group stage worksheet and at the top in knock out worksheet.
You don’t have to place teams that qualify to knock out round by yourself. The Excel formula has done it for you. All you need is typing the scores and select goal scorer’s names.
World Cup 2018 Goal Scorer Spreadsheet for Excel (1.1 MiB, 550 hits)
World Cup 2018 Team Statistic and Head to Head Records
Perhaps, this is the most useful spreadsheet if you want to observe your team performance during this World Cup 2018 tournament. Why? Because this spreadsheet contains useful data stats for all participants from all world cups as well as competitive tournament from 2006. Competitive tournaments are World Cup qualifications, Euro Cups final tournament and its qualification stage, Copa Americas and many more.
You can see their performance in the last 10 competitive matches and also in the last World Cup tournaments. Other stats are their records against other participants and against countries from particular continents. You may find background colors in each countries to represent the continent where they come from.
Also, goal distribution and common score results are arranged in tabular view that could help you observe their scoring behavior.
You can see important facts by using this stats spreadsheet, for example, say you pick Germany, you can see facts that they never lost in the first group matches in last 5 world cups and always scored at least 4 goals in previous 4 world cups. They also never lost against North American countries, the continent where Mexico resides that they will face in their first group match. They also never lost and got clean sheet against Asian countries where they will face one of them, South Korea, in their last group match. And you can see how superior this Germany team in their last 10 matches.
If you want to see records of Germany versus South Korea or Mexico in their meetings, you can go to Head-to-Head worksheet. Select the opponent and all related data will be revealed automatically.
There are World Cup facts table where you can evaluate several facts that never or always happen in every World Cup tournaments.
You can also see all match results from the previous 5 World Cups from 1998 to 2014. 1998 is the year where FIFA expanded World Cup participants from 24 to 32 teams. Regulation hasn’t been changed ever since. So, it is more relevant to view this statistics and compare it with this year tournament.
There are options to include this year match results into the stats where you can see it in Team Stats worksheet directly. You can go to 2018 WC Scoresheet worksheet and type the actual score.
This spreadsheet is not free. But, you can evaluate the demo version below.
World Cup 2018 Team Head-to-Head Records for Excel (1.3 MiB, 474 hits)
World Cup 2018 Office Pool and Predictor Game
This spreadsheet is an advanced version of similar spreadsheet that you might used in previous World Cup, Euro Cup and Copa America. It has many features that will help you pick the suitable one with your prediction game regulation. Either you want to set it as a one time entry score prediction game or as multiple entry score prediction game. One time entry score prediction game will require players to submit the score before the tournament is begun or before each stages is completed. Multiple entry score prediction game will allow players to fill the score before each matches is started.
Each players will get their own standings table. It will make each players might have different outcome in knock out rounds.
There are bonus points you can use to attract players to get more points, especially in knock out rounds, where they might have no chances to get points from different pairing brackets with actual ones.
These are short instructions on how to use this spreadsheet.
Set Predictor Game parameter
- Set points for group stages. There are three point levels in group stages. You can modify it to have two or one point levels.
- Set game scenario for knock out stages. You can select “Tournament’s Actual Result” if you prefer to predict scores only and “Player’s Prediction Matches” if you prefer to have knock teams based on your player’s prediction. Then, you can set either players can earn points from penalty kick prediction or not.
- Set points for knock out stages
- Set points for penalty kick (if penalty kick is included)
- Set points for bonus. There are up until 15 criteria that can earn bonus. They include predicting best player and top scorer. You can disable bonus points by typing zero in particular bonus criteria.
- Type player names in Player Scoreboard worksheet
- Type player score prediction in All Players Board worksheet.
- Type actual results in Tournament’s actual result table in All Players Board worksheet.
- Track progress of your players in Player Leaderboard worksheet
You can play with maximum 15 players in free version. Features are limited, though. You must use the paid version if you want to use all features with more players.
World Cup 2018 Office Pool for Excel (1.3 MiB, 578 hits)
World Cup 2018 Match Statistics Tracker
This is a spreadsheet to record and track statistics of all teams in this tournament. It should be useful to see performance of its team while competing in this tournament. There are statistics tables set for all matches within one single worksheet. This type layout should ease you to update the stats after every match is completed.
Below is a short instruction on how to use this spreadsheet.
- Update player database. Player database are not yet filled with official players since they are not announced yet
- Select 11 players in the line up and remaining players in substitution table in match tracker worksheet
- Type minute, player name and its event for every events in the match. For example, you can type minute 1, select “Harry Kane” in English column and select “G” for goal if the event is Harry Kane scores the goal. The demo version is filled with dummy information to help you understand how to fill it easier
- Go to summary worksheet and select the team that you want to see their stats. You can move between team and player stats to see stats for selected teams
Free spreadsheet below accommodates until 16 group matches only. You can purchase the complete version to accommodate all 64 matches.
World Cup 2018 Match Statistics Tracker (251.3 KiB, 396 hits)