ATTENTION! If you downloaded the World Cup spreadsheet before June 21, 2014 then you have a copy that has errors. A fixed version is now available for download here with scores filled out up to June 21 or for a blank version download this one.
I apologize for the calculation error. Technically, it's not my fault. I originally built this spreadsheet in Microsoft Excel 2003. Since the first round is a point system that breaks ties in points by goal difference and ties in goal difference by total goals scored, the formulas to determine the ranking for each group are surprisingly difficult to write. I wrote formulas with multiple nested formulas within them. Microsoft reduced the number of formulas for which you can nest within other formulas in Microsoft Excel 2010. So, the formulas were logically correct but disallowed by the newer version of Excel that I am using. As a result, the ranking of teams within Group play were not calculated and no teams were pulled over into Round 2. Thanks, Microsoft, for that "improvement" (eye roll).UPDATE: For a free downloadable and printable poster of the brackets, go to my newest post and click on the link for the download.
FIFA World Cup 2014 is coming up and this guy is getting excited. The weekend before last was the draw and so the official schedule has been filled and is ready to go.
So, without hesitation, I built my Microsoft Excel spreadsheet to keep up with all the games. It's in the same user-friendly interface as it's been when I originally designed it for World Cup 2006. I updated it a little bit, but I was afraid to get into the formulas too much because I keep getting a warning about too many arguments being nested within single cells. Apparently, I was able to do more within a single cell in Microsoft Excel 2003 than in the 2010 version I have now.
Anyway, it works like a charm with no more interaction from the user than entering the final scores of each game. In Round 1, it does all the math for you on the fly in regards to team points, total goals scored, total goals scored against, and total goal difference. Basically, every scenario that might possibly be used to determine final ranking in Round 1 to see who makes it into Round 2 and who doesn't.
In Round 2, in the event of a tied game going into penalty shots for a tie breaker, a box pops up to allow the user to enter the penalty shots results.
It's a fun way to follow along with all the games. Otherwise, with 64 games being played in roughly a month, it's easy to just miss a good portion of the action.
I considered marketing this sheet of mine, selling it online for download for something like a dollar. But, after some investigation, I found out that FIFA holds exclusive rights for a lot more than I thought. I would have been infringing on the intellectual property rights of FIFA had I done something like that. Perhaps, on Microsoft, as well.
So, here it is for free. Also, it will be available in the 'Downloads' drop-down menu at the top of this blog. FIFA can't sue me for distributing it this way. Well, they can, I guess, but they won't win since I am adhering to their legal requirements.
- I'm receiving no monetary benefits in the distribution of this file, nor any other form of compensation.
- I'm not using this distribution as a means to advertise any product or company.
- The file contains no copy-written or otherwise protected images belonging to FIFA or any of its affiliates.
- The file does not contain excessive words or phrases registered as intellectual property of FIFA or any of its affiliates.
- The purpose of distribution of this file is to excite a fan base and increase the number of individuals watching the World Cup in 2014, which is FIFA's own product.
0 comments:
Post a Comment