Spreadsheet: 328873d1404123936-world-cup-or-formula-shows-true-and-false-to-same-result-wcforforum
Sheet: Sheet1

 |  |  |  |  | enter name when group winners selected these names are ones for use  on ALL sheets |  |  |  | [NAME] |  |  |  | Spare 01
 |  |  |  |  |  | Group A |  | W | Brazil |  |  |  | Brazil
Group A | } | Winner | Brazil |  |  |  |  | R/U | Mexico |  |  |  | Italy
 |  |  |  |  |  | Group B |  | W | Spain |  |  |  | Argentina
 |  |  |  |  |  |  |  | R/U | Chile |  |  |  | Bosnia
 |  | [NAME] Up | Mexico |  |  | Group C |  | W | Colombia |  |  |  | Ivory Coast
 |  |  |  |  |  |  |  | R/U | Ivory Coast |  |  |  | Belgium
----------------------------------------------------------------------------------------------------------------------------------------------------- |  |  |  |  |  | Group D |  | W | Italy |  |  |  | England
Group B | } | Winner | Holland |  |  |  |  | R/U | England |  |  |  | Colombia
 |  |  |  |  |  | Group E |  | W | France |  |  |  | Germany
 |  |  |  |  |  |  |  | R/U | Ecuador |  |  |  | Russia
 |  | [NAME] Up | Chile |  |  | Group F |  | W | Argentina |  |  |  | Spain
 |  |  |  |  |  |  |  | R/U | Nigeria |  |  |  | Portugal
----------------------------------------------------------------------------------------------------------------------------------------------------- |  |  |  |  |  | Group G |  | W | Portugal |  |  |  | Switzerland
Group C | } | Winner | Colombia |  |  |  |  | R/U | Germany |  |  |  | Holland
 |  |  |  |  |  | Group H |  | W | Russia |  |  |  | Chile
 |  |  |  |  |  |  |  | R/U | Belgium |  |  |  | Uruguay
 |  | [NAME] Up | Greece |  |  |  |  |  | x | x | x | x | x | x | x | x
 |  |  |  |  | Round of last 16 |  |  | [NAME] | Brazil |  |  |  | Brazil
----------------------------------------------------------------------------------------------------------------------------------------------------- |  |  |  |  |  |  |  | W50 | England |  |  |  | Italy
Group D | } | Winner | Costa Rica |  |  |  |  | W51 | Mexico |  |  |  | England
 |  |  |  |  |  |  |  | W52 | Italy |  |  |  | Colombia
 |  |  |  |  |  |  |  | W53 | France |  |  |  | Portugal
 |  | [NAME] Up | Uruguay |  |  |  |  | W54 | Belgium |  |  |  | Spain
 |  |  |  |  |  |  |  | W55 | Argentina |  |  |  | Uruguay
Group E | } | Winner | France |  |  |  |  | W56 | Germany |  |  |  | Holland
 |  |  |  |  | Quarter finalists |  |  | W57 | Brazil |  |  |  | Brazil
 |  |  |  |  |  |  |  | W58 | Belgium |  |  |  | Spain
 |  | [NAME] Up | Switzerland |  |  |  |  | W59 | Italy |  |  |  | England
 |  |  |  |  |  |  |  | W60 | Argentina |  |  |  | Holland
----------------------------------------------------------------------------------------------------------------------------------------------------- |  |  |  |  |  |  |  |  | x | x | x | x | x | x | x | x
Group F | } | Winner | Argentina |  | Semi finalists |  |  | W61 | Brazil |  |  |  | Brazil
 |  |  |  |  |  |  |  | W62 | Argentina |  |  |  | England
 |  |  |  |  |  |  |  |  | x | x | x | x | x | x | x | x
 |  | [NAME] Up | Nigeria |  | 3rd place winner |  |  | W63 | Belgium |  |  |  | Spain
 |  |  |  |  |  |  |  |  | x | x | x | x | x | x | x | x
----------------------------------------------------------------------------------------------------------------------------------------------------- |  |  |  |  | WORLD CUP Winner |  |  | W64 | Brazil |  |  |  | England
Group G | } | Winner | Germany |  |  |  |  |  | x | x | x | x | x | x | x | x
 |  |  |  |  |  |  |  |  | x | x | x | x | x | x | x | x
 |  |  |  |  |  |  | Total Points
 |  | [NAME] Up | U S A |  |  |  |  |  | 1 | x | x | x
----------------------------------------------------------------------------------------------------------------------------------------------------- |  |  |  |  |  |  |  |  | Paid
Group H | } | Winner | Belgium
 |  | [NAME] Up | Algeria
3 points for each group winner and 2 points for each group runner up plus bonus of one point for getting both correct in same group. 3 points for both teams right but in wrong order
Round of Last 16 |  |  | Winner | Match
 | v |  | Brazil | 49
 | v |  | Colombia | 50
 | v |  | Holland | 51
 | v |  | Costa Rica | 52
 | v |  |  | 53
 | v |  |  | 54
 | v |  |  | 55
 | v |  |  | 56
 |  | 6 pts | for each last 16 correct
 |  |  | x
Quarter Finals |  |  | Winner
 | v |  |  | 57
 | v |  |  | 58
 | v |  |  | 59
 | v |  |  | 60
 |  |  | x
 |  | 24 pts | for all 4 QF correct
 |  | 18 pts | for any 3 QF correct
 |  | 12 pts | for any 2 QF correct
 |  | 6 pts | for any 1 QF correct
----------------------------------------------------------------------------------------------------------------------------------------------------- |  |  | x
Semi Finals |  |  | Winner
 | v |  |  | 61
 | v |  |  | 62
 |  |  | x
 |  | 12 pts | for both SF correct
 |  | 6 pts | for any SF correct
----------------------------------------------------------------------------------------------------------------------------------------------------- |  |  | x
3rd place |  |  | Winner
 | v |  |  | 63
 |  | 8 pts | for correct winner
World Cup Final 2014 |  |  | Winner
 | v
 |  |  | x
 |  | 10 pts | for final winner correct