World Cup Charts

Chat about anything and everything under the sun.
Forum rules
Please don't discuss puzzles in here! Thank you.
Post Reply
Message
Author
User avatar
Cenwulf
The Complete Fool
Posts: 1352
Joined: Thu Oct 02, 2008 8:17 pm
Currently reading: Schott's Miscellanies
Location: South Wessex

World Cup Charts

#1 Post by Cenwulf » Tue Jun 01, 2010 9:41 pm

For those who are going to be eagerly viewing the football action in 'Sith Efrica', I have produced these handy charts to print out and fill in.
The reason for there being two charts is straightforward - the 'a' chart is colour-coded, and the 'b' chart is black and white (to be coloured if you want to).
The 'a' chart also has an extra feature - filling in the tables puts the top two teams in the correct places on the 'Knockout' page.
Attachments
World Cup 2010 a.xls
(31 KiB) Downloaded 50 times
World Cup 2010 b.xls
(27.5 KiB) Downloaded 24 times
Unfortunately, the number of ways of doing something wrong far exceed the number of ways of doing it right. G. Kasparov

16000 - 30/03/2017

neves-ytnewt rebmun rebmem suomynona srelzzup

User avatar
Cenwulf
The Complete Fool
Posts: 1352
Joined: Thu Oct 02, 2008 8:17 pm
Currently reading: Schott's Miscellanies
Location: South Wessex

Re: World Cup Charts

#2 Post by Cenwulf » Tue Jun 01, 2010 9:43 pm

And I haven't forgotten those who have difficulty opening Excel sheets.
I've also got the same charts available in Word format: the Group Stage has had to be put in a separate file as it's landscape and the other two are portrait.
World Cup 2010 Group Stage.doc
(91.5 KiB) Downloaded 35 times
World Cup 2010 Tables and Knockout stages.doc
(159 KiB) Downloaded 33 times
Unfortunately, the number of ways of doing something wrong far exceed the number of ways of doing it right. G. Kasparov

16000 - 30/03/2017

neves-ytnewt rebmun rebmem suomynona srelzzup

User avatar
Bunnylump
Granny Boingybott
Posts: 25222
Joined: Tue Sep 30, 2008 9:10 pm
Currently reading: Go Set a Watchman
Location: Treacle Bumstead

Re: World Cup Charts

#3 Post by Bunnylump » Tue Jun 01, 2010 10:20 pm

:shock: Is there football on then? :mrgreen:
You're only given a little spark of madness. You mustn't lose it.

“Tomorrow is always fresh, with no mistakes in it yet.”

User avatar
MBH
King of the Swingers
Posts: 3346
Joined: Tue Sep 30, 2008 11:07 pm
Currently reading: 39 Clues series/Darksmith series/and....
Location: Gateshead

Re: World Cup Charts

#4 Post by MBH » Tue Jun 01, 2010 11:55 pm

No idea :? :roll:

User avatar
clvrlad
Posts: 1922
Joined: Wed Feb 11, 2009 12:33 pm
Currently reading: snuff

Re: World Cup Charts

#5 Post by clvrlad » Wed Jun 02, 2010 5:53 am

erm been explained to me by the little old lady in my local shop whats going on....
she was telling me about the selection for it....


yep i just nodded and "uh uh"-ed a lot ;-)
There are 10 kinds of people in the world
Those who understand binary, and those that don't.
DVP anon member........errr what was it again.....

User avatar
tricia
Posts: 1817
Joined: Sun Oct 12, 2008 11:05 am
Currently reading: The secret life of Bletchley Park Sincla
Location: CLYDEBANK SCOTLAND

Re: World Cup Charts

#6 Post by tricia » Wed Jun 02, 2010 7:13 am

Football free zone in my house - wrong shaped ball :lol: :mrgreen:

tricia
Curiosity killed the cat But satisfaction revived it!!

Those who ask can be helped

User avatar
eirian
Posts: 944
Joined: Wed Oct 01, 2008 8:19 am
Currently reading: Thomas the Tank Engine (and friends)
Location: wishing I was curled up in bed

Re: World Cup Charts

#7 Post by eirian » Wed Jun 02, 2010 9:15 am

well I'll thank you anyway! That'll save me hunting round the web to find something to use.
Since I'm the one my office will be expected to keep everyone up to date on what's happening, I'll thank you on behalf of them as well.

User avatar
strep98
One Hot Cherub
Posts: 2201
Joined: Wed Oct 01, 2008 8:27 pm
Currently reading: Moon Sister
Location: Sunny Devon

Re: World Cup Charts

#8 Post by strep98 » Thu Jun 03, 2010 8:52 pm

football? football? Oh the orange coloured ball and 22 children running up and down spitting!!!! :D
I don't have hot flushes. I have short holidays in the Tropics.
Women are Angels And when someone breaks our wings We simply continue to flyon a broomstick We are flexible like that.
A pesimist is only an optimist who knows more

User avatar
Bunnylump
Granny Boingybott
Posts: 25222
Joined: Tue Sep 30, 2008 9:10 pm
Currently reading: Go Set a Watchman
Location: Treacle Bumstead

Re: World Cup Charts

#9 Post by Bunnylump » Fri Jun 04, 2010 11:24 am

Actually, CW, this HAS proved useful. My daughter is using your list to design a lesson on data collection and is using the world cup countries' flags / matches to do it. Thanks. :D
You're only given a little spark of madness. You mustn't lose it.

“Tomorrow is always fresh, with no mistakes in it yet.”

User avatar
LAT
Nagging Nora
Posts: 13965
Joined: Tue Sep 30, 2008 11:11 pm
Currently reading: Piranesi

Re: World Cup Charts

#10 Post by LAT » Mon Jun 21, 2010 10:36 pm

Thanks for these Cenwulf. I have been filling in the details every evening. And now when my OH asks questions about the progress/likely outcome on the group stages, or even about what matches are on when, I have all the answers at my fingertips! :D

User avatar
clvrlad
Posts: 1922
Joined: Wed Feb 11, 2009 12:33 pm
Currently reading: snuff

Re: World Cup Charts

#11 Post by clvrlad » Tue Jun 22, 2010 5:46 am

LAT wrote:Thanks for these Cenwulf. I have been filling in the details every evening. And now when my OH asks questions about the progress/likely outcome on the group stages, or even about what matches are on when, I have all the answers at my fingertips! :D
im starting to think you like foot ball ;-)
There are 10 kinds of people in the world
Those who understand binary, and those that don't.
DVP anon member........errr what was it again.....

User avatar
Scurra
Alias the Jester
Posts: 16852
Joined: Mon Sep 22, 2008 5:50 pm
Location: Lost, as usual

Re: World Cup Charts

#12 Post by Scurra » Tue Jun 22, 2010 6:10 pm

clvrlad wrote:im starting to think you like foot ball ;-)
No, she likes puzzles. And the World Cup one is a real doozy... :lol:
Never put off till tomorrow what you can do the day after tomorrow.
All of my puzzles are simple and obvious. For certain values of "simple" and "obvious".

User avatar
Bunnylump
Granny Boingybott
Posts: 25222
Joined: Tue Sep 30, 2008 9:10 pm
Currently reading: Go Set a Watchman
Location: Treacle Bumstead

Re: World Cup Charts

#13 Post by Bunnylump » Tue Jun 22, 2010 6:59 pm

What's a DOOZY? :shock:
You're only given a little spark of madness. You mustn't lose it.

“Tomorrow is always fresh, with no mistakes in it yet.”

User avatar
Cenwulf
The Complete Fool
Posts: 1352
Joined: Thu Oct 02, 2008 8:17 pm
Currently reading: Schott's Miscellanies
Location: South Wessex

Re: World Cup Charts

#14 Post by Cenwulf » Tue Jun 22, 2010 8:23 pm

I've discovered an error. It's in the Knockout stages of version A.
The formula entered at D8 reads '=(Tables!B16)' where it should actually read '=(Tables!B15)'. If uncorrected it would result in the second team in Group E appearing twice and the Group winner not at all.

And as for the switch in the first two Group B games, that happened after I did the tables: I was working from a listing which appeared in January.
Unfortunately, the number of ways of doing something wrong far exceed the number of ways of doing it right. G. Kasparov

16000 - 30/03/2017

neves-ytnewt rebmun rebmem suomynona srelzzup

User avatar
LAT
Nagging Nora
Posts: 13965
Joined: Tue Sep 30, 2008 11:11 pm
Currently reading: Piranesi

Re: World Cup Charts

#15 Post by LAT » Tue Jun 22, 2010 9:13 pm

As long as no-one's saying I'm a doozy. :shock:

The trouble is that whether I like it or not almost all of all the matches will be watched in our house. And I will be in a minority next week when my son gets home from Uni so I might as well show some interest. Even at work today a colleague who was chatting to someone in our Basel office turned to the expert (me :!: ) when asked when the next England match was.

Au revoir la France! :D

Post Reply

Who is online

Users browsing this forum: No registered users and 19 guests