Note: I have since created a new version of the spreadsheet, which you can find here.
Are you looking for a way to quantify your bowling game, or way to track your progress or regress? Do you want to know how often you pick up single pin spares or your strike percentage? Would you like to be able to quantify these stats for your whole bowling team from week to week? Well, you have found the right place. Our bowling spreadsheet is the Bowl Movements’s gift to the world. We use it to create our box scores (Here’s an example). You can have it free of charge. For absolutely nothing. Yes, we are nice people. In return, you should read our blog more often and tell your friends about it. That's all we ask.
How does it work?
The Bowl Movements bowling statistics spreadsheet is a remarkably simple thing. It is currently set up for teams with four bowlers who play a three game series. If you want to use it to track the stats of a single bowler, you can do this, too. All you have to do is enter bowler initials and frame by frame ball scores (and handicap if you have one), and the spreadsheet does the rest. It calculates the score for the game, and automatically provides a suite of statistics:
- Marks: The total number of strikes and spares received
- Strikes: The total number of strikes
- Strike Opps: Strike opportunities, or the number of chances you had to roll a strike. This varies between 10 and 12 depending what happened in the 10th frame. This stat is used to calculate Strike%.
- Strike%: This is the percent of strike balls you throw. It is calculated as strikes/(strike opps)x100
- Spares: The total number of spares
- Spare Opps: Spare opportunities, or the number of chances you had to convert a spare. This varies between 0 and 10 depending upon how many strikes you received. This stat is used to calculate Pickup%.
- Pickup%: The percent of spares you picked up. It is calculated as spares/(Spare Opps)x100
- Opens: The total number of open frames
- Single Pin: The number of single pin spares you picked up.
- Single Pin Opps: The number of opportunities you had to pick up single pin spares (i.e., you received a nine on the first ball).
- SP%:The percent of single pin spares you converted: (Single pin)/(Single Pin Opps)x100.
- 1st ball average: This is the average score you received on the first ball of each frame. For the significance of this stat, see here.
- Accuracy: This stat attempts to capture your overall accuracy. It varies from 0 to 100%. For a detailed explanation of its derivation and significance see here.
- Series: The sum of your scores for all three games.
- Average: Your average score for the three game series
- Handicapped pin total: If you bowl in a handicapped league, enter your handicap, and the spread sheet will calculate your handicapped pin total for the series.
To get the spreadsheet, just click here.
[Addendum: I have since updated the sheet to fix a bug. I also added a blank sheet for a three man and five man team due to requests. The link for the updated spreadsheet is the same.]
A FEW NOTES ON THE USE OF THE SPREADSHEET
1. This is an Excel spreadsheet, version Office 1997-2003.
2. Make sure you use a capital “X” for strikes. Depress Caps Lock when entering scores.
3. To record a spare, use backslash “\”.
4. To record a gutter ball or a throw in which no pins were recorded, just leave the cell blank. DO NOT ENTER A DASH “-“.
5. If you want to use it for multiple nights of bowling, just copy the worksheet as many times as you like.