In just another 3 hours, the FIFA World Cup 2014 would be underway with Brazil taking on Croatia. As the tournament progresses, it would be difficult to keep track of where the teams stand. It is always easy to see how the teams are progressing, visually, rather than read about in newspapers(!), or on digital media. The best way to visualise such data is, of course, a spreadsheet.
For those of us in India, the real problem is getting our minds around the timing of the matches. Once again, a spreadsheet - in Excel for most of us - is the most convenient option.
As everything seems to be getting ready just-in-time for the FIFA World Cup 2014 in Brazil, here is my attempt to track the tournament in an Excel spreadsheet.
For today, I have typed out the schedule for the next couple of days, in a spreadsheet. But merely creating a schedule is what my 10 year old nephew would do. What I want to do is track, or update, the Excel spreadsheet as the tournament progresses. Which means making the spreadsheet automatically update when we enter the scores as the matches finish, and the tournament progress.
Then, I thought, what if I can make a how-to out of it? Put out a schedule first, and then explain how to make up formulas to make use of the spreadsheet!
With that in mind, let us set out on an exercise, day-by-day, to make up formulas so that we can track the FIFA World Cup 2014. For today, it is just a heads-up. This is the schedule for the next 2 days, as an image.
Tomorrow we will see how the results can be entered in one cell in the spreadsheet, and enter formulas so that the Group standings reflect the latest.
Here is the image.
The first match starts at 01:30 IST on 13th June 2014. Keep in touch to see the Excel spreadsheet (and the formulas) are hatched up, and learn to work with a spreadsheet.
For those of us in India, the real problem is getting our minds around the timing of the matches. Once again, a spreadsheet - in Excel for most of us - is the most convenient option.
As everything seems to be getting ready just-in-time for the FIFA World Cup 2014 in Brazil, here is my attempt to track the tournament in an Excel spreadsheet.
For today, I have typed out the schedule for the next couple of days, in a spreadsheet. But merely creating a schedule is what my 10 year old nephew would do. What I want to do is track, or update, the Excel spreadsheet as the tournament progresses. Which means making the spreadsheet automatically update when we enter the scores as the matches finish, and the tournament progress.
Then, I thought, what if I can make a how-to out of it? Put out a schedule first, and then explain how to make up formulas to make use of the spreadsheet!
With that in mind, let us set out on an exercise, day-by-day, to make up formulas so that we can track the FIFA World Cup 2014. For today, it is just a heads-up. This is the schedule for the next 2 days, as an image.
Tomorrow we will see how the results can be entered in one cell in the spreadsheet, and enter formulas so that the Group standings reflect the latest.
Here is the image.
The first match starts at 01:30 IST on 13th June 2014. Keep in touch to see the Excel spreadsheet (and the formulas) are hatched up, and learn to work with a spreadsheet.
No comments:
Post a Comment