Hi
I'm trying to see what would be the best way of determining the possible combinations for picking the winner of each group (groups A to H) in the upcoming soccer world cup.
There are a total of 4^8 = 65,536 combinations if you don't exclude any team, but if you limit it to say 2 selections per group, then the total number of combinations are 2^8 = 256 (a bit more reasonable to deal with).
Is there a way to show all the possible combinations in excel?
The groups are as follows:
<colgroup><col><col><col></colgroup><tbody>
</tbody>
If you selected every team as a possible winner:
<colgroup><col><col span="4"><col span="3"></colgroup><tbody>
</tbody>
But if you selected the following teams there are only 12 combinations:
<colgroup><col><col span="4"></colgroup><tbody>
</tbody>
I'm trying to see what would be the best way of determining the possible combinations for picking the winner of each group (groups A to H) in the upcoming soccer world cup.
There are a total of 4^8 = 65,536 combinations if you don't exclude any team, but if you limit it to say 2 selections per group, then the total number of combinations are 2^8 = 256 (a bit more reasonable to deal with).
Is there a way to show all the possible combinations in excel?
The groups are as follows:
| Group | Team | Odds |
| A | Brazil | $ 1.22 |
| Mexico | $ 9.00 | |
| Croatia | $ 9.00 | |
| Cameroon | $ 21.00 | |
| B | Spain | $ 1.83 |
| Holland | $ 3.10 | |
| Chile | $ 6.00 | |
| Australia | $ 34.00 | |
| C | Colombia | $ 1.72 |
| Ivory Coast | $ 5.00 | |
| Japan | $ 6.00 | |
| Greece | $ 7.00 | |
| D | Italy | $ 2.75 |
| Uruguay | $ 2.88 | |
| England | $ 3.10 | |
| Costa Rica | $ 34.00 | |
| E | France | $ 1.83 |
| Switzerland | $ 3.50 | |
| Ecuador | $ 5.00 | |
| Honduras | $ 21.00 | |
| F | Argentina | $ 1.22 |
| Bosnia-Herzegovina | $ 8.00 | |
| Nigeria | $ 10.00 | |
| Iran | $ 34.00 | |
| G | Germany | $ 1.53 |
| Portugal | $ 3.75 | |
| USA | $ 12.00 | |
| Ghana | $ 13.00 | |
| H | Belgium | $ 1.67 |
| Russia | $ 3.20 | |
| South Korea | $ 9.00 | |
| Algeria | $ 23.00 |
<colgroup><col><col><col></colgroup><tbody>
</tbody>
If you selected every team as a possible winner:
| Select Potential Winners | |||||||
| 1st Pick | 2nd Pick | 3rd Pick | 4th Pick | Combination 1 | |||
| A | Brazil | Mexico | Croatia | Cameroon | Brazil | ||
| B | Spain | Holland | Chile | Australia | Spain | ||
| C | Colombia | Ivory Coast | Japan | Greece | Colombia | ||
| D | Italy | Uruguay | England | Costa Rica | Italy | ||
| E | France | Switzerland | Ecuador | Honduras | France | ||
| F | Argentina | Bosnia-Herzegovina | Nigeria | Iran | Argentina | ||
| G | Germany | Portugal | USA | Ghana | Germany | ||
| H | Belgium | Russia | South Korea | Algeria | Belgium | ||
| Number of combinations | 65536 | Multibet Odds | $ 60.24 |
<colgroup><col><col span="4"><col span="3"></colgroup><tbody>
</tbody>
But if you selected the following teams there are only 12 combinations:
| Select Potential Winners | ||||
| 1st Pick | 2nd Pick | 3rd Pick | 4th Pick | |
| A | Brazil | |||
| B | Spain | Holland | ||
| C | Colombia | |||
| D | Italy | Uruguay | England | |
| E | France | |||
| F | Argentina | |||
| G | Germany | Portugal | ||
| H | Belgium | |||
| Number of combinations | 12 |
<colgroup><col><col span="4"></colgroup><tbody>
</tbody>
. The only thing left is fill in the odds/names. This means that the first row (00000000) represents 8 poules, in each poule your first chosen team (who is "named" zero) wins and your second chosen team in that poule will end second. The second row has only one difference: in poule 8, your winner is the second team you picked ("named" one).
