FIFA World Cup 2018 Schedule and Scoresheet


World Cup 2018 Schedule and Scoresheet - ExcelFIFA World Cup 2018 Schedule and Scoresheet is an excel spreadsheet to see fixtures of upcoming FIFA Soccer World Cup that will be held this June in Russia. There are 32 teams from 5 continents that will compete to become the best soccer team in the world. Germany, previous World Cup champion, is still a favorite team to defend their title.

You can personalize language and match time in this spreadsheet to meet your local language and time. All common terms are translated using general translator engine, but you can replace incorrect translation by using custom language table. Also, if you don’t find your city in timezone list, or you found it incorrect, you can adjust it using custom timezone feature in team setup worksheet. There are additional color marker feature you can use to colorize particular team, group or venue.

Beside using it to see World Cup 2018 fixtures, you can use it to track progress of your favorite team during this tournament. There is score sheet boxes where you can type actual score results and let the excel formulas calculated group standings and place qualified teams in knock out bracket. The formulas for group standings are based on tie-breaker regulation released by FIFA for this World Cup. There are 8 tie-breaker points as follows :

1. points obtained in all group matches;
2. goal difference in all group matches;
3. number of goals scored in all group matches;

If two or more teams are equal on the basis of the above three criteria, their rankings are determined as follows:
4. points obtained in the group matches between the teams concerned;
5. goal difference in the group matches between the teams concerned;
6. number of goals scored in the group matches between the teams concerned;
7. fair play points (accumulative points from yellow and red cards)
8. drawing of lots by the FIFA Organising Committee.

Excel formulas will rank teams based on regulation 1-6 after you typing scores in particular score boxes. Tie-breaker regulation no 7 requires you to input fair play points in Fair Play Points table in Custom Language worksheet if particular teams are still in tie after running through regulation no 6. If they are still tied, you just need to switch those teams inside group standing table directly.

You can continue to type scores in Knock Out rounds. There are Full Time boxes (Normal Time + Extra Time) and Penalty Kick boxes. Penalty Kick boxes will be revealed if particular matches are tied after Full Time period is completed.

There are conditional formatting formulas that will show group color as well as flag for particular team that advance to the next knock out rounds automatically. You might experience slow process on using the spreadsheet with automatic flag functions. Time delay should vary on different laptop and processor. You can switch to the spreadsheet without that automatic flag functions if you can’t tolerate the delay.

You can test this spreadsheet by typing your prediction points in this World Cup 2018 Fixtures and Scoresheet. If you are looking for particular spreadsheet to play prediction games with your friends or relatives, you might take a look at World Cup 2018 Office Pool spreadsheet.

  World Cup 2018 Schedule and Scoresheet (1.3 MiB, 4,064 hits)



Related Templates

Previous post:

Next post: