fbpx
Search
Close this search box.

Thank you Sachin [a small tribute]

Share

Facebook
Twitter
LinkedIn

Lets talk about people who inspire us. People who show us that anything is possible. People who prove that commitment, hard work and perseverance are true ingredients of a genius.

I am talking about Sachin Tendulkar. Those of you who never heard his name, he is the most prolific cricketer in the world. He is the leading scorer in both tests (15,921 runs) and one day matches (18,426 runs). Read more about him here.

Tendulkar has been an inspiration for me (and millions of others around the world) since I was a kid. The amount of dedication & excellence he has shown constantly motivates me. It is a pity that the great man is retiring from test cricket. He is playing his last test match (200th, most by any person) as I am writing this.

So as a small tribute, I have decided do something for him. Of course, I have never been a cricketer in my life. Once in college I was reluctantly asked to be a stand-by player in a game with seniors. I did not get a chance to pad up though. That is the closest I have been to a cricketer. So I did what I do best. I made an Excel dashboard celebrating Sachin’s test career.

Thank you Sachin – his test career in a dashboard

Here is a dashboard I made visualizing his test cricket statistics. It is dynamic, fun & awesome (just like Sachin).

(click on the image to enlarge)

Sachin Tendulkar 200 Tests - Visualized in an Excel Dashboard

Download the workbook

Click here to download the file and play with it.

How is this made?

Data:

The data for this dashboard is downloaded from espncricinfo.com and the trivia details are downloaded from in.msn.com

Data from Cricinfo website came in multiple tables. So it took a fair bit of massaging to get everything flow in to dashboard.

Formulas used:

This dashboard uses generous amounts of SUMIFS, COUNTIFS, INDEX, MATCH and VLOOKUP with an occasional LARGE.

For some of the calculations, I have also used Pivot tables.

PS: All the calculations & pivot tables are hidden. Unhide them to go Indian Jones on the dashboard.

Output:

The output dashboard is generated by using various ideas.

  • Thermo-meter chart for % charts in the report
  • Conditional formatting to show run heat map & India vs. Abroad bars.
  • Area charts to show cumulative runs over the years.
  • Form controls to capture user choices.
  • Sortable country list using pre-sorted pivot tables.
  • Picture links to show country flags.
  • Text areas & shapes to make the layout of the dashboard.

I have used similar concepts in earlier dashboards. So I am not explaining everything in detail. Instead, let me point you to few detailed tutorials so you get the idea.

Thank you Sachin

Thanks for inspiring me Sachin. For 24 years, if there is a cricket match on TV, I would invariably ask, “Is Sachin playing?”. It would be hard to watch the sport knowing that you will not grace it with your presence. But you have given me and lots of people in my generation something even more valuable. You motivated us to excel in our life. For that I thank you.

 

Dig sports & Excel? Then you will love these dashboards

If you dig sports & work with Excel, then you are going to immensely enjoy below dashboards too.

 

Facebook
Twitter
LinkedIn

Share this tip with your colleagues

Excel and Power BI tips - Chandoo.org Newsletter

Get FREE Excel + Power BI Tips

Simple, fun and useful emails, once per week.

Learn & be awesome.

Welcome to Chandoo.org

Thank you so much for visiting. My aim is to make you awesome in Excel & Power BI. I do this by sharing videos, tips, examples and downloads on this website. There are more than 1,000 pages with all things Excel, Power BI, Dashboards & VBA here. Go ahead and spend few minutes to be AWESOME.

Read my storyFREE Excel tips book

Excel School made me great at work.
5/5

– Brenda

Excel formula list - 100+ examples and howto guide for you

From simple to complex, there is a formula for every occasion. Check out the list now.

Calendars, invoices, trackers and much more. All free, fun and fantastic.

Advanced Pivot Table tricks

Power Query, Data model, DAX, Filters, Slicers, Conditional formats and beautiful charts. It's all here.

Still on fence about Power BI? In this getting started guide, learn what is Power BI, how to get it and how to create your first report from scratch.

Weighted Average in Excel with Percentage Weights

Weighted Average in Excel [Formulas]

Learn how to calculate weighted averages in excel using formulas. In this article we will learn what a weighted average is and how to Excel’s SUMPRODUCT formula to calculate weighted average / weighted mean.

What is weighted average?

Wikipedia defines weighted average as, “The weighted mean is similar to an arithmetic mean …, where instead of each of the data points contributing equally to the final average, some data points contribute more than others.”

Calculating weighted averages in excel is not straight forward as there is no built-in formula. But we can use SUMPRODUCT formula to easily calculate them. Read on to find out how.

18 Responses to “Thank you Sachin [a small tribute]”

  1. Domnic says:

    awesome excel file!

  2. Nice looking excel we have there Chandoo 🙂

    Good that you have put the excel on a CDN :-))

  3. chand dora says:

    nice way to say adieu

  4. Sajan says:

    Thanks Chandoo! But I thought Sunil Gavaskar was the best Indian cricket player ever! 🙂

  5. Nath says:

    This is fantastic mate. Well done!

  6. Krishnasamy Mohan says:

    Hello Chandoo Ji!!
    Really an Excellent Tribute to an Excelling Legend by an Excel Legend! Wow! great!

  7. Rahim says:

    Excellent Tribute to an Excelling Legend

  8. Kalyan Verma says:

    Amazing Visualization!!!

  9. Jacob Barnett says:

    I was lucky enough to see the little master make a century against England in the tied game during the last world cup. The reaction from the crowd was like nothing I have ever seen!

    Great visualisation.

  10. Jordan G says:

    Like most Americans, I know next to nothing about cricket. But the dashboard is great.

  11. ranjith says:

    Dear sir,
    I admire u because of your skills in excel and I want a detailed explanation regarding the following
    1.macro and. Vba
    2.offset and index match conditional formatting

  12. Val says:

    im left as spell bound as one is when Sachin bats!

  13. Kiev says:

    Chandoo, nice post & great instruction, at least i get to know this person through Excel even i have no idea of cricket at all. Excel is cultural tool now...

  14. Suresh Burde says:

    Brilliant work my friend !!
    It's a small and loverly tribute to the great master. Least we can do is to appreciate the stats and cherish the fact that we got to witness most of it, as it happened in our generation. Really lucky to be part of this era. 🙂

    Cheerss... thanks, for the stats. THere are many pages on Wikipedia, that spawn from sachin's home page, and they contain a lot of stats and details, including that for ODI etc. Some of you may want to take a look at that too. It's amazing how people contribute and keep the wiki pages updaded.

    • Suresh Burde says:

      Excel of course is great tool. I have used a lot of excel features, that I can see have been used for this sheet as well, it takes a lot of efforts and skill to make use of excel the way you did, I really appreciate your efforts. You have done a wonderful job. 🙂

  15. martin hakansson says:

    Awesome dashboard!
    Though what I can't figure out is how the linked texboxes with a reference works?

  16. Sidhesh Mangle says:

    Created a Visualization of Sachin Tendulkar? - Test cricket records using Tableau Public

    http://public.tableausoftware.com/views/SachinTendulkar_TestCricketRecords/Sachin-TestCricketRecords?:embed=y

  17. Vishal Singh says:

    Such a humble tribute to the 'God of Cricket'. Well done!

Leave a Reply