Hello!
I am attaching a different tracker here, which you may find interesting and easy to use.
You can change settings on the 'Settings' tab.
Best wishes.
Regards, Manohar
On Mon, 11 Jun 2018 at 19:32, Manohar Ramtri <ramtri@gmail.com> wrote:
----- Forwarded Message -----
If forwarding further, please delete my id, and use the BCC field for addressees, to reduce spam, viruses and identity theft. Thanks!
Sent: Thursday, June 7, 2018 23:14To: ...Subject: FIFA Worldcup 2018 Excel Tracker – FREE Download (chandoo.org)
FIFA Worldcup 2018 Excel Tracker – FREE Download (chandoo.org)
Click here to download the FIFA world cup 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
How to use the world cup 2018 tracker?
Start page – set up the tracker
When you open the workbook, use "Home" page to set up your local timezone and favorite teams.
Group Stage – Schedule & summary points table
The group stage view shows all teams. It highlights your team(s) in different color to see when their games will be on.
On this page, you can also see group-wise points table. This is a live table. So as the matches happen, just press CTRL+ALT+F5 to update this table. The data comes from Wikipedia FIFA 2018 page thru Power Query. So you need Excel 2016 / Excel 365 or an older version of Excel with Power Query to get the refresh work.
Bracket View – Knockout Schedule
The knockout stage shows last 16, quarter-final, semi final and final matches in bracket view. This page is not dynamic. So as group stage finishes, go ahead and list the team names in the gray cells.
Timeline View
This shows all matches in a Gantt chart like view. From this you can track all your favorite team matches. It will also highlight current date so you know which matches are coming up next.
Download FREE FIFA world cup tracker
Click here to download the FIFA world cup 2018 tracker.
Which teams are you rooting for?
As usual, I am cheering for Germany and Brazil. I will also watch out how Denmark & Sweden (my former homes) are going to play.
What about you?
The post FIFA Worldcup 2018 Excel Tracker – FREE Download appeared first on Chandoo.org - Learn Excel, Power BI & Charting Online.
You are subscribed to email updates from Chandoo.org – Learn Excel, Power BI & Charting Online.
To stop receiving these emails, you may unsubscribe now.Email delivery powered by Google Google, 1600 Amphitheatre Parkway, Mountain View, CA 94043, United States
No comments:
Post a Comment