Cricket World Cup 2015 – Free Excel Dashboard
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.
FREE DOWNLOAD
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.
TEAM VIEW
You can see the progress of the team and also their top players and performances.
You can choose the team from the drop down menu.
MATCH VIEW
You can choose any of the 49 matches from the drop down menu.
You will see the compact match summary on the left, and more detailed scorecards on the right.
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.
37 Comments
Dear Team,
You have done a fantastic job by creating this template. I am thinking if you could able to create template for World Test Championship as well.
But there is one catch:
1) Test matches have multiple innings
2) Combined runs scored in one match (i.e. both innings) by Batsman
3) Combined wickets taken in one match (i.e. both innings) by Bowler
Your current template shows best bowling figures in a match, which is obviously single inning. But if bowler takes 5 wickets in 1st Inning & 7 wickets in 2nd innings then combined he took 12. So on this basis will it be possible to create statistics based on “Best Bowling Figures in a Match” and “Most Runs Scored by Batsman in a Match”
Thank you for your understanding in advance
Thank you for sharing your valuable feedback.
We have added your requirement to our future development. We also take customization projects for a fee. You can reach out to us at support@indzara.com for estimation.
Best wishes.
We have internal company matches, I want that sheet for simple presentation. How can i get that.
Thank you for showing interest in our template.
You can download the template from the below link and unhide the data sheets to delete the existing data and input your match data.
Note: The password to unprotect the sheet is indzara. Some columns in the input sheet will have formulas and the same should not be modified or deleted.
Best wishes.
Hi How We can create match Review Template i.e. like head to head compare, which batsman score highest runs against other team, which bowler took the highest wicket and player to watch,team sheet
Thank you for reaching out to us.
We take customization projects for a fee. Please share a sample sheet with sample input and sample output required for estimation.
Best wishes.
Please upload Cricket Partnership Template
Thank you for reaching out to us.
You can use our Single List combination generator template to create partnership between list of players provided. Following is the link to the template:
https://indzara.com/product/combinations-generator-toolkit-excel-template/
Best wishes.
could make one video at this template that how to create this.
Thank you for showing interest in our template and sharing your suggestion.
We will update you when we create the tutorial session on creating this template.
Best wishes.
Hi, I had a look at your file and it is very thorough
I have played around with calculating NRR (recently in the 100 from England). As I understand it the calculation is Team A runs scored divided by overs minus Team B runs scored divided by overs. An example Team A scores 147 100 balls; Team B 148 95 balls.
NRR Team A 147/(100/6) – 148/(95/6) = -0.527368 and Team B 0.527368.
I must be making a mistake as my calculation never agrees with 100 table.
Can you tell me please where I am wrong? Thanks. Dennis
Thank you for showing interest in our template.
The NRR formula used in our template is ((runs scored/balls faced) – (runs conceded/balls bowled))*6 till Quarter-finals
Best wishes.
How to download raw data. Can you please share complete url.
The data is taken from the following link:
https://stats.espncricinfo.com/ci/engine/records/index.html
Best wishes.
Any plans for 2019 WC version?
Hello
It’s not planned yet. We might have it.
Thanks
any update on the 2019 cricket world cup excel template?
We cannot comment about this template now. Keep watching this space.
Best wishes