This is a UEFA Euro 2016 Schedule and Scoresheet you can use to see the schedule and track all matches of the upcoming European soccer tournament. It took some time to map all new tournament regulations to this spreadsheet, but finally it is finished. This year tournament will have major changes in its tournament format compared with previous tournaments. This year, it will be participated by 24 countries, divided into 6 groups. They will fight for 16 places in knock out rounds. It consists of 6 group winners, 6 group runners up and 4 best third-placed teams.
With this major tournament format change, I can’t use any of my previous Euro and World Cup spreadsheets without any major modification. As you can see in screenshot below, I used my World Cup 2014 layout because I think it has a nice looking layout so far. I removed all extra time score boxes in knock out brackets, and add a separate third-place standing table to help you see which best third-placed teams advance to knock out rounds.
I added a worksheet to customize its language if you feel that the translation is not fit with your language well (I used Google Translator tool for all language translations) and to customize its timezone if you can find your city in timezone list.
Based on UEFA drawing on 18 December 2015, 24 Euro 2016 participants will be divided as follows :
Republic of Ireland
All group matches will start on 10 June 2016 and finish on 22 June 2016. And below is UEFA policy to rank all teams after all group matches are completed.
The standing of each team in each groups will be determined according to
1. Higher number of points obtained in all group matches
After this regulation is applied and if two or more teams are equal on points on completion of the group matches, the following tie-breaking criteria will be applied:
1. Higher number of points obtained in the matches played between the teams in question;
2. Superior goal difference resulting from the matches played between the teams in question;
3. Higher number of goals scored in the matches played between the teams in question;
4. If, after having applied criteria 1 to 3, teams still have an equal ranking, criteria 1 to 3 are reapplied exclusively to the matches between the teams in question to determine their final rankings. If this procedure does not lead to a decision, criteria 5 to 9 apply;
5. Higher goal difference in all group matches;
6. Higher number of goals scored in all group matches;
7. If only two teams have the same number of points, and they are tied according to criteria 1–6 after having met in the last round of the group stage, their ranking is determined by a penalty shoot-out. (This criterion is not used if more than two teams have the same number of points.)
8. Fair play conduct (1 point for a single yellow card, 3 points for a red card as a consequence of two yellow cards, 3 points for a direct red card, 4 points for a yellow card followed by a direct red card);
9. Position in the UEFA national team coefficient ranking system.
Tie breakers above will determine group winners and runner ups that will advance to knock out round. Third places in all groups will be ranked together with the following criteria to determine the four best third-placed teams.
1. Higher number of points obtained;
2. Superior goal difference;
3. Higher number of goals scored;
4. Fair play conduct;
5. Position in the UEFA national team coefficient ranking system.
Pairing matches between all advanced teams in round of 16 will be arranged as follows
Match 1: Runner-up Group A v Runner-up Group C
Match 2: Winner Group D v 3rd Place Group B/E/F
Match 3: Winner Group B v 3rd Place Group A/C/D
Match 4: Winner Group F v Runner-up Group E
Match 5: Winner Group C v 3rd Place Group A/B/F
Match 6: Winner Group E v Runner-up Group D
Match 7: Winner Group A v 3rd Place Group C/D/E
Match 8: Runner-up Group B v Runner-up Group F
As you can see above, there will be dynamic match ups between winners from group A-D and third-placed teams which could produce big matches in round of 16, where those winners will have chances to face teams from 3 groups instead of just one in previous tournament format. Below is the arrangement of pairing matches based on third-placed team rank.
I have created new algorithms to map those rules into excel formulas where you can see them reflected in my Euro 2016 Schedule and Scoresheet. You can see Winners from group A, B, C, D will face teams from different group based on final 3rd places standings. With group color markers, you can see from which groups that finally those group winners are faced.
To use this spreadsheet is simple, you can start by typing the score results in score boxes in group matches. Group standings will be adjusted accordingly. And after all group matches are finished and all advanced teams are placed in respective knock out brackets, you can start typing scores in respective knock out score boxes. I put an automatic group color function that should inform you from which groups the teams who advance in knock out stages. You can type the full time score (normal + extra time) result in white boxes at the right side of team names. And if the score is draw, there will be a box with light red color background shown where you can filled the penalty shoot out results. You can repeat it until the final where the Champion, runner up and semifinalists will be shown on the box at bottom left of this worksheet.
This one is a schedule with automatic country flag arrangement function. I made a short guide on how to use it on youtube as you can watch it below.
If you want to learn how the excel code works, or put your business logo, or you want to support me to continue creating soccer spreadsheets, you can purchase the fully editable one for USD 8.99 through paypal button below. But, remember that you are not allowed to sell (either as it is or as other forms) or use it for any commercial purposes. All codes are originally created and designed by me. I would be pleased if you can appreciate my creation.
Euro 2016 Schedule and Scoresheet – Fully Editable
This one has a top scorer feature where you can type goal scorer names in every matches if you want to track them. It has a totally different format than the previous two, as you can see in screenshot below.
How to use the 3rd one is the same with previous 2 models, but you have to type official player names who make it on respective national teams before using it. It is filled with random players now. And to select the goal scorers, you need to type the score results to reveal player name boxes and then select the player from dropdown list in respective boxes. All group standings, knock out team placements and top scorer standings will be adjusted accordingly.
This third model has the unprotected version as well that you can purchase for USD 11.99 through paypal button below.
Euro 2016 Schedule and Scoresheet with Top Scorer – Fully Editable
Let me know if you found any errors in these spreadsheets so I can fix it before the tournament is begun. Have fun guys.