Google ad

Join our group Email:

Friday, March 30, 2007

ICC Cricket World Cup 2007 Stats Master

The ICC Cricket World Cup 2007 Stats Master

The top run scorer, the best hitter, the top wicket taker, bowler with the most miserly run rate, bowler with the best strike rate. Who has hit the most sixes, who has hit the most tons, who has taken wickets against whom? Who is the best. Answer to your queries in a click. Just download the stats master.

Download the ICC Cricket World Cup Stats Master
Updated as on 10th April 2007 with one click results. Now just select your stat below the for box for quick stats


Get all stats about the ICC Cricket World Cup 2007 in this comprehensive excel spreadsheet. This is one of the most comprehensive, yet informative spreadsheet available in the Internet. What's more? It's updated daily and it's free of cost. So just download it now. The zipped version is less that 100 KB so you need to have to wait to know the statistics.


Download the ICC Cricket World Cup Stats Master
Download the zipped version of the ICC Cricket World Cup Stats Master
HOW TO USE?
Stats Master has two sheets

  1. FULL
  2. PLAYER
The FULL worksheet shows the list of all players with the respective details. By default, Stats Master sorts the records by the ascending order of player names.

To change the views, just follow the following steps:
  • Double click on the PLAYER NAME button.
  • Click the ADVANCED button in the PIVOT NAME FIELD BOX
  • drop down box below the USING FIELD box.
  • Select the criteria for which you want to sort from the drop down box
  • Select the ASCENDING or DESCENDING option to sort the data. For Runs scored, Wickets taken, Batting Strike Rate, Average, Highest score and for almost all batting records, click the ASCENDING option. For the Bowling Strike Rate, Economy Rate and other such bowling records, click the DESCENDING option. Bear with us with this adjustment as we would soon sort out a way to display records in one click.
  • Now click OK and the records of your choice would be displayed.
  • If you want to analyze the data of particular team, then select your team from the TEAM drop down box on the top of the page.
Thus to view the top run scorers in this cricket world cup, double click on the PLAYER NAME button. Click the ADVANCED button and select RUNS from the drop down box. Select the DESCENDING option and click OK.

Do report your views and any improvements to this spreadsheet through comments

Thursday, March 22, 2007

Auto victory monitor

Auto Victory Monitor

So who's won the match and who have lost it. What's the victory margin? No need for you to calculate these silly things. Our Excel cricket spreadsheet takes care. Just enter the scores in the cells and our Auto Victory Monitor would calculate the winner and the margin.

How it works
The Auto Victory Monitor checks the scores of both the teams ,the overs and the wickets. Since the winning team must score more runs than the losing team, it ascertains the team with the more runs as the winner. If the scores are level, then it assumes the match as tied. As regards the victory margin, it uses a simple algorithm to calculate it. Since the formulas are not hidden, you can find it for yourself. The algorithm is based on the fact that if the victory margin is more than 6 runs, then the team must have batted first and defended the score. In case the victory margin is less than 6 runs and the overs taken up the team is less than 50, then the team must have chased and won the match. If the victory margin is less than 6 and both the teams have played out their entire overs or have run out of wickets, then the winning team must have batted first and won.

Flaws in Auto Victory Monitor

There are two flaws in this monitor

  • If a match is curtailed then the score of the chasing team would be revised and in many cases must be much less than the original score of the team that batted first. Auto Victory Monitor would still show the team that batted first as the winner. We are sorting this out and for the time being you may enter the winning team and the victory margin manually
  • When a team chases a target and wins of the last ball of the stipulated over, then Auto Victory Monitor shows the winner correctly but faults in victory margin. For example, if Team A bats first and scores 250 runs in 50 overs and Team B chases down the target in 50 overs getting 252 runs losing 8 wickets (assuming the last ball is hit for four) then the victory margin is calculated as Team B winning by 2 runs instead of 2 wickets. This is a genuine problem. Any idea on this issue is appreciated without providing an additional column for the team batting first.

Saturday, March 17, 2007

Live worldwide poll

Live worldwide poll data

This facility requires an active internet connection

Get the ICC Cricket World Cup spreadsheet.
Go to the ICC Cricket World Cup spreadsheet.

As you would have known, we are running a worldwide poll on who would win the world cup and which four teams would reach the semifinals. You could find this poll on the bottom of every page. We have embedded the poll results as a chart in the spreadsheet. To know the poll results, Select the Cricket World Cup Poll 2007 cell, RIGHT CLICK and click REFRESH DATA.

The opinion of the poll in nor final neither reflect our views. It entirely represents the choice of the audience and may be biased on the viewer ship from a particular country. We would be making changes to the poll at every stage. You can also provide comments by clicking the comments section in the poll




Cricket World Cup 2007
Who would win the ICC World Cup 2007?
Australia
England
India
New Zealand
Pakistan
South Africa
Sri Lanka
West Indies
Other


What could reach the semi-finals of the ICC Cricket World Cup 2007?
Australia
England
India
New Zealand
Pakistan
South Africa
Sri Lanka
West Indies
Other



View Results

Live rankings and ratings

Live cricket rankings and ratings

This facility requires an active internet connection.
Catch the latest ICC rankings and ratings on our spreadsheet.

Get the ICC Cricket World Cup spreadsheet
Go to ICC Cricket World Cup Spreadsheet

The ICC has been maintaining a system of rankings for all the teams and players. The ICC maintains rank for teams, top batsmen, top bowlers and top all rounders. To see who is where and who's in the top spot, click the LIVE RANKINGS AND RATINGS link in the spreadsheet,.
You could see the list of teams, top batsmen, bowlers and all rounders. Right click any table and give REFRESH DATA for the data to update from internet. If you want to refresh all rankings, click CLICK TO REFRESH DATA button on the left. This updates all the rankings and ratings. Whenever you download, the spreadsheet from our site, the ratings are updated. These ratings are official as displayed by ICC. We gather data from CRICINFO website




Cricket World Cup 2007
Who would win the ICC World Cup 2007?
Australia
England
India
New Zealand
Pakistan
South Africa
Sri Lanka
West Indies
Other


What could reach the semi-finals of the ICC Cricket World Cup 2007?
Australia
England
India
New Zealand
Pakistan
South Africa
Sri Lanka
West Indies
Other



View Results

Points table explained

Points system for the ICC Cricket World Cup 2007

Download the ICC Cricket World Cup 2007 spreadsheet
Go back to ICC Cricket world cup spreadsheet

You might be slightly confused the way in which points are calculated for the ICC Cricket World Cup 2007. This would give you a clear picture.

  • If a team wins then it will be awarded 2 points. If the match ends in a tie or the match is abandoned, then each team would get 1 point each. As always, the losing team doesn't make any gain. There is no bonus point system in this ICC Cricket world cup.
  • In case two teams have the same points, then the teams would be decided on the basis of NRR (Net Run Rate).
  • Two teams from each of the four groups would qualify for the Super Eight Stage. In the Super Eight Stage, each team would play the other except the team that they faced in the league stage. For example, if Australia and South Africa qualify for the Super Eight from Group A(they would qualify) then Australia would play against the teams qualified from Group B, Group C and Group D. They would not face South Africa as they have already faced them in the league stage. Hence, they would play six matches in the Super Eight Stage. The same is true in case of South Africa also.
  • Teams would carry forward the points they have earned in the league matches. For example, if Australia and South Africa qualify for the Super Eight Stage, and Australia beats South Africa in the league stage, then Australia would enter the Super Eight with 2 points and if South Africa beats Australia, then South Africa would enter the Super Eight with 2 points and if the league match between Australia and South Africa ends in a tie or is abandoned, then both the teams would enter the Super Eight with one point each. So it is important for a team to win all its league matches as it may turn decisive in the run up to semi finals
  • The top four teams from the Super Eight would qualify for the Semi finals. The points system in the Super Eight Stage is same as in the league stage. In case the points are tied, then the team with the higher NRR would move to the semi finals. Thus if two teams have three wins each in the Super Eight Stage, then the points carried from the league stage would be decisive. For example, lets assume India beats Sri Lanka in the league stage and both of them move to the Super Eight. Assuming both the teams win three matches each in Super Eight, then India would move into the semifinals since India would have 8 points (3 wins in Super Eight + 1 win in league match against Sri Lanka) while Sri Lanka would have only 6 points(3 wins in Super Eight).
The Cricket World Cup spreadsheet calculates all of the above. It automatically generates the Super Eight Schedule and calculates the Net Run Rate. Provision for carry forward points to the Super Eight Stage is under progress and the same would be incorporated in quick time.




Cricket World Cup 2007
Who would win the ICC World Cup 2007?
Australia
England
India
New Zealand
Pakistan
South Africa
Sri Lanka
West Indies
Other


What could reach the semi-finals of the ICC Cricket World Cup 2007?
Australia
England
India
New Zealand
Pakistan
South Africa
Sri Lanka
West Indies
Other



View Results

Thursday, March 15, 2007

Live scorecards

Live scorecards

So want to watch the scores just on work. Check out our live scorecards sheet.
Go to the live scorecards sheet
RIGHT CLICK->REFRESH DATA
This refreshes the scorecard. This scorecard changes for every match and no need to do anything special. You can also make the refresh data at regular intervals.
RIGHT CLICK->DATA RANGE PROPERTIES and under the
REFRESH EVERY box select the time interval for which you want to refresh data

Go back to ICC Cricket world cup spreadsheet
Get the ICC Cricket world cup spreadsheet



Cricket World Cup 2007
Who would win the ICC World Cup 2007?
Australia
England
India
New Zealand
Pakistan
South Africa
Sri Lanka
West Indies
Other


What could reach the semi-finals of the ICC Cricket World Cup 2007?
Australia
England
India
New Zealand
Pakistan
South Africa
Sri Lanka
West Indies
Other



View Results

Thursday, March 8, 2007

ICC Cricket World Cup 2007 Excel spreadsheet

The Cricket World Cup is on and so the excitement and enthusiasm levels. With cricket fever at the peak, we are presenting a tool which you may find exciting as well as easy to use.


Download the ICC Cricket World Cup 2007 spreadsheet
Download the ICC Cricket World Cup 2007 stats master

Updated as on 10th April 2007 with detailed points table and standings

For this spreadsheet to work, you must keep your MACROS ON. It is simple.Before downloading, go to Tools->Macro->Security and select the Medium option. Now download the workbook and when open it, click ENABLE MACROS when prompted with a dialog box. You must do this step for the proper functioning of the spreadsheet.

The ICC Cricket World Cup 2007 spreadsheet is a fully featured utility developed in Microsoft Excel (compatible with almost all Excel versions) that would help you keep track of the events, matches ,your favorite players, squads, scorecards and more. This is absolutely free and you can download it at zero cost. The size is also small and the zipped version of this cricket spreadsheet just takes five seconds even on a phone line. Further, the ICC Cricket World Cup 2007 spreadsheet provides you with almost all the information you may find at the official site. You just got to enter the scores after every match and the spreadsheet would take care of the rest. Further more, this file is updated after every match so that you can download it after every match if you don't want to enter the scores manually. Just scroll below Read more on the features of this fully functional spreadsheet and the instructions to use it. Check out this space for updates and improvements to this spreadsheet. Do report any errors and also comment on any improvements to this spreadsheet.

Download the ICC Cricket World Cup 2007 spreadsheet
Download the ICC Cricket World Cup 2007 stats master

Its just easy to use the spreadsheet. It has a user friendly interface. The spreadsheet has three important worksheets:

  1. WELCOME
  2. SCHEDULE
  3. POINTS TABLE
Select your favorite team in the WELCOME sheet. This would display the list of matches and the results for the team you have selected along with the players. This would refresh every time you open the workbook. In the SCHEDULE worksheet, type the runs, overs and wickets fallen for the teams after the end of every match. This would generate the super eight schedule and points table. If you have forgotten to key in the details, no problem. We do update the spreadsheet after every match. If you see this too much time consuming, then just select the winner from the drop down box.
Remember to turn your MACROS off before opening this spreadsheet.

Features of the ICC Cricket world cup Spreadsheet:

Download the ICC Cricket World Cup 2007 spreadsheet
Download the ICC Cricket World Cup 2007 stats master

Feeds, Bookmarks

Subscribe
Subscribe to Excel solutions by Email

Join our group

Google Groups
Subscribe to Free excel spreadsheets
Email:
Visit this group

Relevant pages

Google ad