Cricket World Cup 2015 – Free Excel Dashboard

Posted on
2015 Cricket World Cup Excel Dashboard Cup View

Cricket World Cup 2015 Excel Dashboard is my attempt to capture the world cup in Excel. Though the team I support (India) came close but didn’t win, Australia deserved to win.

I have attempted to calculate all the stats based on raw match data (thanks to ESPNCricinfo). I have tried to keep it really simple and highlight only the most relevant stats. This is my first draft and I hope to enhance this dashboard as time goes by. Please share your suggestions and comments in the comments section below.

2015_Cricket_WorldCup_Excel_Dashboard_1

 

FREE DOWNLOAD

Download the Excel dashboard for free – WorldCup2015_Excel_Dashboard

 

VIDEO DEMO

 

There are three views (Cup, Team and Match).

CUP VIEW

In the Cup view, you can see the overview of the tournament and the top players and performances. You can also see the points table in the preliminary round.

2015_Cricket_WorldCup_Excel_Dashboard_CupView_1

2015_Cricket_WorldCup_Excel_Dashboard_CupView_2

2015_Cricket_WorldCup_Excel_Dashboard_CupView_3

 

TEAM VIEW

You can see the progress of the team and also their top players and performances.

2015_Cricket_WorldCup_Excel_Dashboard_TeamView_Australia

 

You can choose the team from the drop down menu.

2015_Cricket_WorldCup_Excel_Dashboard_TeamView_Choose
TeamView2_gif

 

2015_Cricket_WorldCup_Excel_Dashboard_TeamView_India

2015_Cricket_WorldCup_Excel_Dashboard_TeamView_India_Players

MATCH VIEW

You can choose any of the 49 matches from the drop down menu.

2015_Cricket_WorldCup_Excel_Dashboard_MatchView_Choose

MatchView_gif

You will see the compact match summary on the left, and more detailed scorecards on the right.

2015_Cricket_WorldCup_Excel_Dashboard_MatchView_Final

2015_Cricket_WorldCup_Excel_Dashboard_MatchView_Final_Bat

2015_Cricket_WorldCup_Excel_Dashboard_MatchView_Final_Bowl

 

On Excel,

  • I have used formulas and conditional formatting as usual, without any macros.
  • I have tried to show flags of countries dynamically, which I have not done in my other templates so far.
  • There are no pivot tables, but there are some tables.
  • The sheets are protected, only to prevent accidental formula edits. Please feel free to unlock the sheets using the password indzara.

Please let me know your feedback in the comments section. I look forward to hearing from you.

 

Related Templates

23 thoughts on “Cricket World Cup 2015 – Free Excel Dashboard

  1. Any plans for 2019 WC version?

    1. Hello

      It’s not planned yet. We might have it.

      Thanks

      1. any update on the 2019 cricket world cup excel template?

        1. We cannot comment about this template now. Keep watching this space.

          Best wishes

Leave a Reply

Your email address will not be published. Required fields are marked *