I'm a USBC League Bowler, and I'm tracking my own stats, and I want to know my Strike Rate Percentage.
Theoretically, you would take and divide the number of frames bowled by the number of strikes bowled, but how do you account for the tenth frame? If I bowl a perfect game, that's 100%. But let's take this scenario where I bowled a 232.
As you can see here I have 8 strikes in the game and 2 of them in the tenth frame. 8 strikes / 10 frames is 80% strike rate, but not when 2 of the strikes are in the tenth frame. 8 strikes / 12 first throw chances for 75%.
How do I figure this out in Excel?