CRICKET SPREADSHEET.com
Welcome to
Home of the BEST Cricket Statistics Spreadsheets FOR CRICKETERS.
Are you a cricketer who wants to keep track of their batting average? Or maybe you want more batting statistics than a cricket telecast. If the only way for you to get accurate, up-to-date statistics for your cricket team is to work them out yourself, then you need a Cricket Spreadsheet.
Cricket Spreadsheets are designed to track individual players' statistics. They can be used to track player statistics for an entire team, and the new career spreadsheet enables you to paste each player's sheet into their own career spreadsheet which calculates their career statistics. See the example screenshots below for more information.
Cricket Spreadsheets are designed to track individual players' statistics. They can be used to track player statistics for an entire team, and the new career spreadsheet enables you to paste each player's sheet into their own career spreadsheet which calculates their career statistics. See the example screenshots below for more information.
MATCH FIGURES INPUT
This is the data entry side of a player's sheet. You enter each player's match figures into one of these sheets.
(The example below shows Michael Clarke's figures from the 2009 Ashes through to the 2010 series against New Zealand.)
This is the data entry side of a player's sheet. You enter each player's match figures into one of these sheets.
(The example below shows Michael Clarke's figures from the 2009 Ashes through to the 2010 series against New Zealand.)
STATISTICS OUTPUT
This is the statistics side of the player's sheet. You don't enter anything here.
All statistics are automatically calculated, and instantly update to reflect every change or addition to the above figures.
This is the statistics side of the player's sheet. You don't enter anything here.
All statistics are automatically calculated, and instantly update to reflect every change or addition to the above figures.
Statistics include: matches, innings, not outs, runs, high score, batting average, strike rate, total fours, total sixes, fifties, hundreds / Total overs, maidens, runs, wickets, best bowling, bowling average, strike rate, economy rate, five wickets-innings, ten wickets-match / Total catches, stumpings, run outs / Catches per match, average after x [value x can be altered, example shows 25], percentage of runs scored in boundaries, percentage of sixes in total boundaries, conversion rate (percentage of fifties converted into centuries), total ducks and golden ducks, total no balls, total wides / Manhattan batting graph with average line overlay, dismissal breakdown with percentages, batting position breakdown with averages.
TEAM SHEET
Statistics from each player's sheet are displayed on a team sheet.
You don't enter anything here. This information is gathered from each player's sheet.
Statistics from each player's sheet are displayed on a team sheet.
You don't enter anything here. This information is gathered from each player's sheet.
Last edited by Randy on May 20, 2010 at 8:15pm AEST.
*NEW* CAREER SPREADSHEET ADDED
*NEW* LIMITED OVERS NBF 40 PLAYER SPREADSHEET ADDED
*NEW* LIMITED OVERS NBF 40 PLAYER SPREADSHEET ADDED
User comments:
"I just want to thank you for creating this awesome spreadsheet! It is really great to be able to check all your stats, and it's easy to use as well."
Romano, United Cricket Club Brakpan, South Africa
"Thanks for the spreadsheet. It's fantastic. We've got it loaded up and all the kids will be using it to follow their progress over the season."
Paul, Bowral Cricket Club, Australia
"Just what I've been looking for - it fits our needs perfectly. It's saved me hours rejigging last year's homebrew scorebook, too, so thank you very much!"
Mish, Mana Junior Cricket Club, New Zealand
"I just want to thank you for creating this awesome spreadsheet! It is really great to be able to check all your stats, and it's easy to use as well."
Romano, United Cricket Club Brakpan, South Africa
"Thanks for the spreadsheet. It's fantastic. We've got it loaded up and all the kids will be using it to follow their progress over the season."
Paul, Bowral Cricket Club, Australia
"Just what I've been looking for - it fits our needs perfectly. It's saved me hours rejigging last year's homebrew scorebook, too, so thank you very much!"
Mish, Mana Junior Cricket Club, New Zealand
CAREER SHEET
The career spreadsheet is similar to the regular spreadsheet above. In the spreadsheet above, each sheet is a different player.
In a career spreadsheet, each sheet is a different season (or series) in a player's career. The statistics for each season are displayed and the overall statistics are calculated at the bottom.
The career spreadsheet is similar to the regular spreadsheet above. In the spreadsheet above, each sheet is a different player.
In a career spreadsheet, each sheet is a different season (or series) in a player's career. The statistics for each season are displayed and the overall statistics are calculated at the bottom.
 |
 |
 |
 |
The above is an example of an unlimited overs spreadsheet. There are also spreadsheets designed for limited overs matches.
The main difference is there is only one inning per match, but there are also subtle differences such as high score and best bowling display
(The example below shows Shane Watson's figures from the 2009 ICC Champions Trophy.)
The main difference is there is only one inning per match, but there are also subtle differences such as high score and best bowling display
(The example below shows Shane Watson's figures from the 2009 ICC Champions Trophy.)
 |
 |
 |
 |
Condensed image
Condensed image
