Post World Cup 2006
That is, A win in a Euro 2008 or World Cup 2010 knock-out match, add 1 point if they qualified from the group stage of said tournaments, add 1 point for winning a match in the group stage of said tournaments, add 1 point for qualifying four said tournaments, and Euro 2012.
Then, in qualification, the number of matches not won over the last 6 years and finally how many matches have been won in Euro 08 and World Cup 2010 at any point by the team.
Data: wc data.xlsx
Picture Format:
* Only European Teams included, minus the 4 teams to have hosted a tournament or will have hosted a tournament because of variables in data.
Code:
Name KO Win +GS Q +GS Win +Tourn Qual Qual Not Won Tour Win
Spain 6 8 13 16 3 11
Netherlands 3 5 11 14 5 9
Germany 4 6 10 13 6 8
Italy 0 1 2 5 8 1
England 0 1 2 4 9 1
Greece 0 0 1 4 9 1
Croatia 0 1 4 6 10 3
Russia 1 2 4 6 11 3
Sweden 0 0 2 4 11 2
Denmark 0 0 1 3 12 1
France 0 0 0 3 12 0
Czech 0 0 0 2 13 0
Portugal 0 2 5 8 15 3
Slovakia 0 0 1 2 16 1
Turkey 0 1 3 4 16 2
Romania 0 0 0 1 17 0
Serbia 0 0 0 1 17 0
Republic 0 0 0 1 18 0
Slovenia 0 0 1 2 19 1
Then, in qualification, the number of matches not won over the last 6 years and finally how many matches have been won in Euro 08 and World Cup 2010 at any point by the team.
Data: wc data.xlsx
Picture Format:
+ Tournament Qualified
Not Won in Qualifying
Won at Tournament
Not Won in Qualifying
Won at Tournament
* Only European Teams included, minus the 4 teams to have hosted a tournament or will have hosted a tournament because of variables in data.