All articles with 'fifa world-cup' Tag

Play spreadsheet soccer with Excel Penalty Game [VBA]

Published on Jul 4, 2018 in Charts and Graphs, VBA Macros
Play spreadsheet soccer with Excel Penalty Game [VBA]

We love spreadsheets. And of course, once every four years, we also get mad about soccer. So why not merge both of them in to one awesome, frivolous and fun thing: Introducing….

Excel soccer game

The best part is you don’t have to run up to play this. Set your aim and let RANDBETWEEN() decide your fate.

Continue »

Which two teams qualify to next stage? [Excel Homework]

Published on Jun 15, 2018 in Excel Challenges
Which two teams qualify to next stage? [Excel Homework]

Time for some soccer fun in spreadsheets. Given a team points table like above,

How would you figure out in Excel, which teams qualify for next stage. The rules for this exercise are,

  • Pick the top two teams by points
  • If there is a tie, use Goal Difference (GD) to break ties (more GD is good)
  • If there is a tie, use Goals For (GF) to break ties
Continue »

FIFA Worldcup 2018 Excel Tracker – FREE Download

Published on Jun 7, 2018 in Power Query, Templates
FIFA Worldcup 2018 Excel Tracker – FREE Download

FIFA world cup 2018 is around the corner. I love soccer, I love Excel, Let’s marry them. Here is an awesome, free FIFA world cup Excel Tracker to help you follow this year’s games in Russia.

Click here to download the FIFA worldcup 2018 tracker.

What you can do with this FIFA world cup Tracker Excel?

You can use this tracker to,

  • View schedules in your local time for group and knockout stages
  • View summary and detailed points table
  • Refresh live points table. When you refresh, the tracker show updated points based on latest results (You need Excel 2016, Office 365 or older versions of Excel with Power Query)
  • View knockout stage matches as a bracket
  • See timeline of the matches
Continue »

A dashboard to visualize this FIFA worldcup [guest post]

This is a guest post by Krishna, a football lover & one of our readers.

The wait for lifting the most valued priced in football for Germans was finally over. For a football fan, world cup is best time that is scheduled every four years and that if your favorite team lifting the trophy is like your crush is going on a date with you. 🙂

A sneak-peek at the final dashboard

Here is the final dashboard (it has more functionality than depicted). Click on it to enlarge.

FIFA 2014 Worldcup Excel dashboard

Continue »

Is this a FIFA worldcup of late goals? Lets ask Excel

Published on Jun 25, 2014 in Charts and Graphs
Is this a FIFA worldcup of late goals? Lets ask Excel

Just like millions of viewers around the world, I too have been spending hours watching FIFA world cup football matches on TV. I don’t like spending hours watching TV. But when its FIFA world-cup time (which is once every 4 years), I am glued to the idiot box. Blame it on PaWaRa, my school teacher in 8th grade who instilled this passion.

So while watching the match day before yesterday (it was Holland vs. Chile), the commentator said, “This has been a world-cup of late goals” as both teams maintained 0-0 until 77 minute mark when Leroy Fer scored a goal for Holland.

That got me thinking,

Is this really a world-cup of late goals?

But I quickly brushed away the thought to focus on the match.

Later yesterday, I went looking and downloaded all the goal data for 2006, 2010 & 2014 FIFA world-cup matches (2014 data for first 36 matches).

Lets examine the hypothesis “2014 has been a world-cup of late goals”.

Continue »

Football anyone? [off-topic]

Published on Jul 2, 2010 in Off-topic
Football anyone? [off-topic]

This is rare folks. We have an off-topic thread!!! Since, the next football world-cup is not until next version of Excel and since, I find myself watching a lot of it these days, I thought why not fool around on a Friday with an offtopic discussion?!? So here it goes, what are your favorite teams […]

Continue »

FIFA Worldcup Excel Spreadsheets [Roundup]

Published on Jun 11, 2010 in Charts and Graphs, excel links
FIFA Worldcup Excel Spreadsheets [Roundup]

Looking for FIFA World cup 2018 Tracker? Click here. Today FIFA World-cup 2010 is beginning. For the next 30 days or so, no matter where you go, you are bound to hear about soccer, world cup, teams, points, goals and what not. As a tribute to this beautiful and lovely sport, I want to showcase […]

Continue »

Football Betting Sheet Template

Published on Jun 9, 2010 in excel apps, Learn Excel
Football Betting Sheet Template

While I was working Denmark, there is one thing I noticed. Danes are one hell of football lovers. The football (soccer) enthusiasm is over the top when there is a match between Denmark and Sweden. A common practice in many offices is a football pool. This is how it works: When there is a match […]

Continue »

Official FIFA World-cup Soccer Balls since 1930 in an Excel Chart [Excel Fun]

Published on May 28, 2010 in Charts and Graphs
Official FIFA World-cup Soccer Balls since 1930 in an Excel Chart [Excel Fun]

The FIFA World-cup 2010 edition is around the corner. Like millions of people around the world, I too am an ardent fan of football. (although, I have played only one game of soccer in which I waited near opponents goal post as I was too lazy to run around. And when my team mates kicked […]

Continue »