FIFA World Cup Spreadsheet (free)

[parry]

For those interested in football [that's soccer to you Americans ] I have created a free spreadsheet which you can download here.

Enjoy

regards,
Graham

 

[Richard Schollar]

Hey Graham

Why do you need a spreadsheet? England are going to win. Period.

If it's as good as your Rugby World Cup one, it will be great

 

[parry]

Hey Graham

Why do you need a spreadsheet? England are going to win. Period.

If it's as good as your Rugby World Cup one, it will be great

Hi Richard, would be cool to see England do it. Let's hope you never have to face a penalty shootout!

 

[NBVC]

Thanks again Parry... I used you 2006 one also...

I like the improvements and the added information, etc.

 

[Domski]

I filled one in a month or so ago and came up with this:

Book3
	A	B	C	D	E	F	G	H	I	J
1	Last 16
2	Date	Match	Venue	Time	Teams	Team A				Team B
3	Sat 26.06.10	49	Nelson Mandela Bay / PLZ	16:00	1A - 2B (1)	France	2	-	1	Greece
4		50	Rustenburg	20:30	1C - 2D (3)	England	2	-	0	Serbia
5	Sun 27.06.10	51	Mangaung / BFN	16:00	1D - 2C (4)	Germany	1	-	0	USA
6		52	Johannesburg	20:30	1B - 2A (2)	Argentina	2	-	1	Mexico
7	Mon 28.06.10	53	Durban	16:00	1E - 2F (5)	Netherlands	1	-	0	Slovakia
8		54	Johannesburg	20:30	1G - 2H (7)	Brazil	3	-	0	Switzerland
9	Tue 29.06.10	55	Tshwane / Pretoria	16:00	1F - 2E (6)	Italy	2	-	1	Cameroon
10		56	Cape Town	20:30	1H - 2G (8)	Spain	3	-	2	Portugal
11
12	Quarter-finals
13	Date	Match	Venue	Time	Teams	Team A				Team B
14	Fri 02.07.10	57	Nelson Mandela Bay / PLZ	16:00	5 - 7 (C)	Netherlands	1	-	3	Brazil
15		58	Johannesburg	20:30	1 - 3 (A)	France	0	-	2	England
16	Sat 03.07.10	59	Cape Town	16:00	2 - 4 (B)	Argentina	1	-	0	Germany
17		60	Johannesburg	20:30	6 - 8 (D)	Italy	2	-	3	Spain
18
19	Semi-finals
20	Date	Match	Venue	Time	Teams	Team A				Team B
21	Tue 06.07.10	61	Cape Town	20:30	A - C (I)	England	3	-	2	Brazil
22	Wed 07.07.10	62	Durban	20:30	B - D (II)	Argentina	1	-	3	Spain
23
24	Play-off for third place					Team A				Team B
25	Date	Match	Venue	Time	Teams	Brazil	2	-	1	Argentina
26	Sat 10.07.10	63	Nelson Mandela Bay / PLZ	20:30	Loser I - LoserII
27	Final
28	Date	Match	Venue	Time	Teams	Team A				Team B
29	Sun 11.07.10	64	Johannesburg	20:30	Winner I - Winner II	England	4	-	2	Spain
Sheet1

I wasn't biased at all, honest!!!

Dom

 

[Sura]

Mr. Parry,

Thank you very much for this spreadsheet, it's simply awesome.

 

[xld]

Hey Graham

Why do you need a spreadsheet? England are going to win. Period.

If it's as good as your Rugby World Cup one, it will be great

I hope that you know more about Excel than you know about football Mr Schollar, England have no chance, period. If Rooney doesn't recover they might not even get out of the group.

 

[xld]

I filled one in a month or so ago and came up with this:

Book3
	A	B	C	D	E	F	G	H	I	J
1	Last 16
2	Date	Match	Venue	Time	Teams	Team A				Team B
3	Sat 26.06.10	49	Nelson Mandela Bay / PLZ	16:00	1A - 2B (1)	France	2	-	1	Greece
4		50	Rustenburg	20:30	1C - 2D (3)	England	2	-	0	Serbia
5	Sun 27.06.10	51	Mangaung / BFN	16:00	1D - 2C (4)	Germany	1	-	0	USA
6		52	Johannesburg	20:30	1B - 2A (2)	Argentina	2	-	1	Mexico
7	Mon 28.06.10	53	Durban	16:00	1E - 2F (5)	Netherlands	1	-	0	Slovakia
8		54	Johannesburg	20:30	1G - 2H (7)	Brazil	3	-	0	Switzerland
9	Tue 29.06.10	55	Tshwane / Pretoria	16:00	1F - 2E (6)	Italy	2	-	1	Cameroon
10		56	Cape Town	20:30	1H - 2G (8)	Spain	3	-	2	Portugal
11
12	Quarter-finals
13	Date	Match	Venue	Time	Teams	Team A				Team B
14	Fri 02.07.10	57	Nelson Mandela Bay / PLZ	16:00	5 - 7 (C)	Netherlands	1	-	3	Brazil
15		58	Johannesburg	20:30	1 - 3 (A)	France	0	-	2	England
16	Sat 03.07.10	59	Cape Town	16:00	2 - 4 (B)	Argentina	1	-	0	Germany
17		60	Johannesburg	20:30	6 - 8 (D)	Italy	2	-	3	Spain
18
19	Semi-finals
20	Date	Match	Venue	Time	Teams	Team A				Team B
21	Tue 06.07.10	61	Cape Town	20:30	A - C (I)	England	3	-	2	Brazil
22	Wed 07.07.10	62	Durban	20:30	B - D (II)	Argentina	1	-	3	Spain
23
24	Play-off for third place					Team A				Team B
25	Date	Match	Venue	Time	Teams	Brazil	2	-	1	Argentina
26	Sat 10.07.10	63	Nelson Mandela Bay / PLZ	20:30	Loser I - LoserII
27	Final
28	Date	Match	Venue	Time	Teams	Team A				Team B
29	Sun 11.07.10	64	Johannesburg	20:30	Winner I - Winner II	England	4	-	2	Spain
Sheet1

I wasn't biased at all, honest!!!

Dom

You do have a good SoH, England scoring 3 against Brazil, then 4 against Spain. That is funny!

 

[barry houdini]

I put this formula in for the home team in the first game

=RANDBETWEEN(0,4)

then copied to the away team and all the way down

Switzerland won the final 3-2 against Denmark - you read it here first

[plucky England lost 4-3 to the mighty Socceroos in the first knockout round]

 

[xld]

I put this formula in for the home team in the first game

=RANDBETWEEN(0,4)

then copied to the away team and all the way down

Switzerland won the final 3-2 against Denmark - you read it here first

[plucky England lost 4-3 to the mighty Socceroos in the first knockout round]

That sound more realistic to me than Domskis!