CRICKET SPREADSHEET.com
Home of the BEST Cricket Statistics Spreadsheets FOR CRICKETERS.
Last edited by Randy on April 2, 2010 at 1:30pm AEDT.
 |
 |
 |
 |
 |
 |
 |
 |
FAQ
Which spreadsheet should I use?
1. If your team plays one day matches, you should use the limited overs spreadsheet. If your team plays multiple day, two-inning matches, you should use the unlimited overs spreadsheet.
2. You should check in the scorebook and see if your scorers record dot balls against the batsmen. (If they do, you'll see 1 . . 2 . 4 . . 2 etc in the batsman score summary; if not, you'll only see 1 2 4 2) If your scorers record only scoring shots and no dot balls, you cannot calculate the number of balls a batsman faces in an innings, and therefore the spreadsheet cannot calculate the batsman's strike rate. The No Balls Faced spreadsheets have these features removed.
3. If you play with the same eleven or twelve players every week, the regular spreadsheet will be fine. But, if you have a large player squad or regularly use fill-in players, you might need an extra player spreadsheet. The regular spreadsheets have 20-22 player sheets, these have 40.
4. If you want to keep track of each player's career statistics over different seasons, you can also download a career spreadsheet which totals and calculates career statistics from each season's figures.
5. If you're only keeping track of your own statistics, you can download a career spreadsheet and enter your figures into each season sheet directly.
The spreadsheet won't recognise 'not out' scores.
You need to put an asterisk next to a not out score. There is a thin column after the runs column for the asterisk, although there is no border so it appears to be one column. The not out asterisk has its own column to keep the scores aligned. (See the example on the main page.) These asterisks are how the spreadsheet recognises not out scores, regardless of what is selected in the dismissal column. If you select not out or retired hurt from the dismissal column, you should have an asterisk next to the score.
How do I use the new career spreadsheet?
First of all, you should create a career spreadsheet for each player. Do this by opening a blank career spreadsheet then selecting 'save as' and typing a player's name. Then click 'save as' again and type another player's name. Do this until each player has their own career spreadsheet. Now you need to copy their match figures from the team spreadsheet to their career spreadsheet. To do this, you should highlight everything from the cell containing the first match (A4) to the bottom-right corner of the figures input (run outs in the last match.) Right-click the selection, select 'copy', then right click the first match on the first season sheet and click 'paste'. That's it. At the end of the next season, simply repeat the process into the second season sheet. (You should always use identical spreadsheets; i.e. if you used a Limited Overs NBF spreadsheet, you should use the Limited Overs NBF - Career spreadsheet.) Note that if you're only keeping track of your own statistics, not a whole team's, you can enter your match figures directly to a career spreadsheet; you don't need a team spreadsheet.
Are the spreadsheets accurate?
Yes. Each calculation is correct to the nearest hundredth. Each percentage is correct to the nearest whole number. Each over total is correct to the ball. All rules of cricketing statistics are followed.
I'm having trouble...
If you're a computer or Excel novice and you're struggling, send an email describing the problems you're facing. You should get a prompt response explaining what to do.
I have an idea but I can't implement it myself.
Email your suggestions, comments or queries to or use the comments page. The spreadsheets are constantly evolving, with different features and statistics added, so feedback from users is welcomed and appreciated.
What's the catch?
There isn't one. There are no viruses, spyware, adware or malware of any kind. There is no advertising or pop-ups. You won't be charged or asked for money. These spreadsheets are freely distributed. This site was created because, a few years ago, I searched for a cricket statistics spreadsheet to use for my own team, and was shocked by the small number and atrocious quality of the available options. I later realised why; it is deceptively difficult to make a spreadsheet understand cricket. Once I'd created my own working spreadsheet, I put it online for my fellow cricketers around the world because there are no adequate alternatives anywhere. That's why you're here, right?
1. If your team plays one day matches, you should use the limited overs spreadsheet. If your team plays multiple day, two-inning matches, you should use the unlimited overs spreadsheet.
2. You should check in the scorebook and see if your scorers record dot balls against the batsmen. (If they do, you'll see 1 . . 2 . 4 . . 2 etc in the batsman score summary; if not, you'll only see 1 2 4 2) If your scorers record only scoring shots and no dot balls, you cannot calculate the number of balls a batsman faces in an innings, and therefore the spreadsheet cannot calculate the batsman's strike rate. The No Balls Faced spreadsheets have these features removed.
3. If you play with the same eleven or twelve players every week, the regular spreadsheet will be fine. But, if you have a large player squad or regularly use fill-in players, you might need an extra player spreadsheet. The regular spreadsheets have 20-22 player sheets, these have 40.
4. If you want to keep track of each player's career statistics over different seasons, you can also download a career spreadsheet which totals and calculates career statistics from each season's figures.
5. If you're only keeping track of your own statistics, you can download a career spreadsheet and enter your figures into each season sheet directly.
The spreadsheet won't recognise 'not out' scores.
You need to put an asterisk next to a not out score. There is a thin column after the runs column for the asterisk, although there is no border so it appears to be one column. The not out asterisk has its own column to keep the scores aligned. (See the example on the main page.) These asterisks are how the spreadsheet recognises not out scores, regardless of what is selected in the dismissal column. If you select not out or retired hurt from the dismissal column, you should have an asterisk next to the score.
How do I use the new career spreadsheet?
First of all, you should create a career spreadsheet for each player. Do this by opening a blank career spreadsheet then selecting 'save as' and typing a player's name. Then click 'save as' again and type another player's name. Do this until each player has their own career spreadsheet. Now you need to copy their match figures from the team spreadsheet to their career spreadsheet. To do this, you should highlight everything from the cell containing the first match (A4) to the bottom-right corner of the figures input (run outs in the last match.) Right-click the selection, select 'copy', then right click the first match on the first season sheet and click 'paste'. That's it. At the end of the next season, simply repeat the process into the second season sheet. (You should always use identical spreadsheets; i.e. if you used a Limited Overs NBF spreadsheet, you should use the Limited Overs NBF - Career spreadsheet.) Note that if you're only keeping track of your own statistics, not a whole team's, you can enter your match figures directly to a career spreadsheet; you don't need a team spreadsheet.
Are the spreadsheets accurate?
Yes. Each calculation is correct to the nearest hundredth. Each percentage is correct to the nearest whole number. Each over total is correct to the ball. All rules of cricketing statistics are followed.
I'm having trouble...
If you're a computer or Excel novice and you're struggling, send an email describing the problems you're facing. You should get a prompt response explaining what to do.
I have an idea but I can't implement it myself.
Email your suggestions, comments or queries to or use the comments page. The spreadsheets are constantly evolving, with different features and statistics added, so feedback from users is welcomed and appreciated.
What's the catch?
There isn't one. There are no viruses, spyware, adware or malware of any kind. There is no advertising or pop-ups. You won't be charged or asked for money. These spreadsheets are freely distributed. This site was created because, a few years ago, I searched for a cricket statistics spreadsheet to use for my own team, and was shocked by the small number and atrocious quality of the available options. I later realised why; it is deceptively difficult to make a spreadsheet understand cricket. Once I'd created my own working spreadsheet, I put it online for my fellow cricketers around the world because there are no adequate alternatives anywhere. That's why you're here, right?