Scoring system - Football based. World Cup 2018

[Kongen123456]

Hi!
I'm having difficulties completing my scoringsheet for NeXT year's World Cup.

The system is listen on this Picture: https://imgur.com/a/vbehT.

1. My problem is that I want the result in the matches to decide where each team ends up in the Group. For example, if Russia and Egypt win their first match, they will recieve 3 Points, go on top in the group, with goal difference separating them. 3 matches for each team. My target is that each one who fills out this form only needs to plot the results, then the rest will take care of itself.

2. The teams who end up as winners of their Group and the runner-up is qualified for the quarterfinals and so on. How to copy Russia (if the win) in the correct cell of the quarterfinals..?

 

[footoo]

You can download a complete table that updates as results are entered from here:
http://www.mallservers.com/2018-fifa-world-cup-russia-excel-table.html

There are other sites with tables available.

 

[Kongen123456]

Thanks for the advice!

Challenge: is it possible to edit these sheets? All of the are protected. Let's say that I would like to add something, is it possible or do I have to have the creators password?

 

[Fluff]

You'll need to contact the person who created the file & ask them for the password.