With the draw being completed we now know what the groups are. All the permutations now need to be considered. In light of this we have developed a free excel spreadsheet to try and predict what will happen in South Africa during June.

This is an initial version so please tell us if you find any problems or have suggestions. At the moment it should handle every situation except if we get down to FIFA drawing lots to see who will progress!!

To get a version visit http://www.auditexcel.co.za/world_cup_spreadsheet.html and download the file.

Our initial predictions suggest the following last 16 line up. Run your scenario and tell us what you think the last 16 will look like