Euro 2016 Spreadsheets for Excel

Euro 2016 Schedule, Scoresheet and Pool Templates

These are excel spreadsheets you can use to help you see the schedule, track the matches, play game prediction of UEFA Euro 2016 Soccer Tournament that will be held in France this June. You can use all of them or just select one that you can update it every time respective matches are completed. Why does it need to be updated manually? Because this excel spreadsheets are not using macros or automatic data update function that can cause problems in some version of Excel. All spreadsheets are equipped with well created excel formulas that will automate all group standings adjustment as well as all team placement in knock out rounds based on new tournament regulation.

Euro 2016 Spreadsheets for Excel
Euro 2016 Spreadsheets for Excel

This year tournament has to apply a new rule because the number of teams have been expanded to 24 teams and the first round of knock out rounds have been expanded to 16 teams. It makes 4 brackets in the first round are available if group winners and runner ups are advanced from 6 available groups. And UEFA has decided to give this 4 available bracket places to 4 best 3rd-placed teams. The new regulation is a little bit complicated, but you don’t have to worry about it, because it is already handled by the excel formulas inside the spreadsheet.

Those 24 teams are :
Group A: France, Romania, Switzerland, Albania
Group B: England, Russia, Slovakia, Wales
Group C: Germany, Poland, Ukraine, Northern Ireland
Group D: Spain, Czech Republic, Croatia, Turkey
Group E: Italy, Belgium, Republic of Ireland, Sweden
Group F: Portugal, Portugal, Hungary, Austria

Euro 2016 Schedule and Scoresheet
This is the foundation of other Euro 2016 spreadsheets. You can read the schedule in your own language by selecting it from language drop down list and in your own timezone by selecting it from city drop down list. And if you couldn’t find a suitable language and timezone, you can customize it by yourself by typing it in available custom worksheet.

Euro 2016 Schedule and Scoresheet for Excel
Euro 2016 Schedule and Scoresheet for Excel

Beside the schedule that you can see, you can use it as your score sheet to track the progress of all teams in this tournament. Just type the score in respective score boxes and all group standings will be adjusted automatically. When all group matches are completed, you can see qualified teams put automatically in round of 16 based on new tournament rules.

There are 4 group winners that will face 4 best 3rd-placed teams where the order will vary based on their groups and ranks. It opens interesting matches up, because in previous tournaments, group winner will only face an opponent from one group, while in this new format, group winner will face an opponent from 3 possible groups.

In knock out rounds, you can continue typing the score in score boxes at the right side of each teams. You can type total goals until extra time, if the match has to go into extra time period, in the first boxes. Additional score boxes will be revealed if the scores are draw. You can type penalty scores in this additional boxes. Repeat this step until final match. Euro 2016 Champion, runner up and semifinalist will be shown in Champion box at the right-bottom side of this spreadsheet.

There are group color formulas which will make background in each brackets changed based on teams that are placed in it that should ease you to know from which groups the teams who advance in knock out rounds. There are automatic flag placement formulas as well. It will be shown next to each countries. Because these automatic flag formulas require big excel resources, you can download a plain version if your computer is running it slowly.

  Euro 2016 Schedule and Scoresheet (1.0 MiB, 14,207 hits)

  Euro 2016 Schedule and Scoresheet - without National Flag (409.2 KiB, 3,985 hits)

This spreadsheet is locked. But, the author offers the unlocked version that you can purchase.

Euro 2016 Schedule and Scoresheet with Top Scorer Tracker
If you want to track goal scorers in this tournament, you can use this spreadsheet. Because the main function is to track goal scorers, the scoresheet design is different with the first spreadsheet explained above, as you can see in the screenshot below.

Euro 2016 Scoresheet with Top Scorer Tracker
Euro 2016 Scoresheet with Top Scorer Tracker

There are 3 worksheets in this version of schedule.

The first worksheet is a group match worksheet which consists all of group matches with goal scorers boxes. There are 8 goal scorers boxes allocated for each teams. At the bottom of this worksheet, you can see group standings that will be adjusted automatically based on scores that you put in each matches and top scorer standings that will be adjusted automatically
based on goal scorers that you inputted.

The second worksheet is a knock out round worksheet. It has the same layout with the first one. You can do the same steps on typing the scores. Top scorer standings is on the top of the spreadsheet where you can see final standings of goal scorers by the end of the tournament. If more than 1 player are sharing the same goals, you can re rank them by typing the correct rank in shown boxes at the right side of player’s names.

The third worksheet is a team squad worksheet where you have to put 23  official player names from each teams. It is filled with dummy player names that might be not chosen as respective teams final squad.

  Euro 2016 Schedule and Scoresheet - with Top Scorer (Official Squads by 31st May) (540.3 KiB, 3,015 hits)

The same with above spreadsheet, it is locked with option to purchase the unlocked version.

Euro 2016 Office Pool/Sweepstake
This one is suitable for you who want to organize a prediction game among your friends, relatives and colleagues. It should be fun, isn’t it. Predict the outcome of each matches and race to become the best predictor. With variety of options, you can make an interesting game to be joined by many people.

Euro 2016 Office Pool for Excel
Euro 2016 Office Pool for Excel

To start the game, you must set this Euro 2016 Office Pool first. Learn its rule and description so you don’t give incorrect information to your players.

Item that you must set are :

  • Points for group and knock out rounds. There are 3 levels of points that you can personalize. You can change the points, and you can reduce it into 2 or 1 levels by zeroing the 2nd and 3rd level.
  • Teams in the knock out rounds. There are 2 options you can select. Based on real matches or based on player’s prediction matches. There are tradeoff between these two. If you select to be based on real matches, you can continue predicting the score and getting the points until final matches, which means all players will have same chances to win the game. But, they need to fill the score after the teams are revealed. If you select to be based on player’s prediction matches, you can ask your players to type the score from the first group until final matches. They can do that because knock out teams will be shown and placed automatically based on their group matches predictions. Choice is yours.
  • Penalty Kick Inclusion and Points. You can award points to players who predict correctly penalty shoot out results, if any.
  • Extra points for particular criteria. There are extra points that will be awarded to players if their prediction meet particular criteria. Those criteria are :
    o Group Winner correct prediction
    o Group Runner Up correct prediction
    o Group 3rd Place correct prediction
    o 16 qualified teams
    o 12 – 15 qualified teams
    o 8 – 11 qualified teams
    o Correct Knock Out Bracket Pairing Matches
    o Team Pick Winner

You can type your player’s names in Player Scoreboard worksheet if you finished your setup. Then you can continue to all players worksheet to start typing your player’s prediction scores. Type real results in tournament worksheet. This result will be shown automatically in all players worksheet to be compared with all players prediction. Points for each players will be shown at the right side of respective players.

You can check your player’s standings every time one match is completed in player leaderboard worksheet. They will be ranked based on higher total points, better correct prediction and entry order of each player.

  Euro 2016 Office Pool for 15 Players (3.4 MiB, 5,897 hits)

The free version can accommodate 15 players only. The paid version can accommodate until 100 players. There are 2 version of unlocked spreadsheets, unlocked on shown worksheets only and fully unlocked.

Euro 2016 Schedule in Microsoft Word Format
To accompany these excel spreadsheets, you can also download a Microsoft Word version below. This Microsoft Word version should be useful for you who want to have a document that you want to use as a schedule only. It is a two separate microsoft word files that have layout as you can see in the screenshot below.

Euro 2016 Schedule for Microsoft Word
Euro 2016 Schedule for Microsoft Word

You can adjust group matches column size, add new columns or modify current columns to put your own information, for example TV schedule information.

Initials at the left side of the first round of knock out bracket are group name and position allocated in those brackets. For 3rd places there are teams from 3 possible groups that can occupy them. Make sure that you put correct teams when the knock out round matches are started.

You can further customize it and print it in any size, for example Poster size, just in case you want to stick it on your wall. It is free.

  Euro 2016 Schedule - Group Stages - Word Template (413.9 KiB, 2,618 hits)

  Euro 2016 Schedule - Knock Out Stages - Word Template (103.1 KiB, 1,857 hits)