These spreadsheets are designed to calculate individual players' statistics over the course of a season. They are designed for local teams and players who may not have access to accurate, up-to-date player statistics. The goal is maximum statistics for minimal input, in a easy-to-read format.


The basic concept is that you enter player match figures only and the spreadsheet calculates all relevant statistics, and displays them on both the player's sheet and a team sheet with all players' statistics. You could also delete all but one player sheet if you only wish to track your own statistics.


Each player's sheet has two sections: the left side is for entry of figures and the right side is for output of statistics. Click here to see an example page.


Recent Updates:

  • 30th March - Fixed rounding error. Thanks Jim.
  • 30th March - Unlimited overs spreadsheets now recognise all bowling figures.
  • 30th March - 'Other Stats' fixed.
You may have difficulty copying and pasting data from an old sheet to a new one. Be sure to save a copy of your original sheet. If you have problems, email me.
 
 
All calculations and outputs are correct to the nearest hundredth or ball.

 

Note: All figures are in normal Australian format, i.e. 2/10 = two wickets for ten runs, not two runs for ten wickets.