Click to Enlarge
(full version of image is hosted on Google Drive. Also be warned, it's big)
Thank you also to Lord Cobrio, who you may know as 'Osarius' but should be henceforth referred to as 'Lord Cobrio', for he is a spreadsheet wizard whose wizardry helped me do this all painlessly.
The percentages on the left hand side of the chart show each team's average win percentage against all other WC87 entrants in World Cup qualifiers and finals matches, plus a few random 'official' friendlies from around 2007-12, back when we did that.
Find a team along the left hand side and find their win percentage against each other team by following the horizontal line and matching with the teams along the top.
Black, numberless squares occur when the two teams have not played against one another.
Black squares with a number indicate that the record between the two teams is about equal.
The greener the square, the more the leftmost team has beaten the other. The redder the square, the more often it has lost.
Draws are counted as half. So a team with a W1, D2, L1 record against another would have a 'win percentage' of 50%. I could have called it 'point percentage' but 'win percentage' is the more widely known term.
“One day” said Jeremy, looking opening the third drawer under his desk for the fourth time that minute, “I might start actually writing about football that’s happening now”.
“Why bother. Data journalism seems to be doing okay for you. Have you tried the kitchen drawer?”
“What kitchen drawer?” said Jeremy, looking underneath his laptop for the third time. “And it turns out this data journalism knackers your computer. And costs you thousands at the printers”
"The kitchen drawer with the stuff. And anyway, when your team gets smashed up by Mytanija, it's probably nicer to dive into the past. When you were good."
"No really, what kitchen drawer?"
“Whenever I have blu-tac, it’s always in a little drawer in the kitchen which also contains a rolling pin, some teatowels, a broken bottle opener and the screwdriver I forgot to put back in the toolbox the previous year” said Rubio.
“Oh, that drawer” said Jeremy. “Huh. Yeah come to think of it”
“I maintain, however, that however much blu-tac you have in that drawer, it’s not going to be enough to hang this massive fucking thing on the wall”
“I’m not even sure the wall would hold it. Did I tell you the original was over 16,000 by somethingorotherthousand”
“I remember you double-clicking the file and then making a cup of tea, yeah”
“Yeah” said Jeremy. “If I’d put that into google maps my laptop would have literally shat itself”
“Literally?”
“It would have found a way”
“Anyway” said Rubio, as Jeremy departed towards the kitchen. “…while you’re there...”
“Coffee’s going on”
“Cheers. Anyway…” Rubio called in the general direction of the door. “When’s this Christmas Special of yours coming out then? We’re approaching February”
There was the sound of a dropped coaster.
“Oh.. oh… shit”
“Just do it next week” shouted Rubio, hearing the sound of coffee granules being swept up off the floor.
“This coffee might be a bit… spicy” said the disembodied Jeremy voice.
“You’re not sweeping it back into the pot…”
“Waste not, want not, Rubie old boy”