I have now updated the BM Bowling Scoring Spreadsheet to give it a number of new features. Unlike the first version, v. 2.0 has built in code (or macros), which give it the ability to do a number of new things. Unfortunately, Microsoft Excel for Macintosh no longer supports Visual Basic macros, so if you are Mac user, you won't be able to use this version unless your Mac can run Windows. Sorry. The old version should still work. (This capability will be returning to Excel for Mac in the future.)
The basic spreadsheet is identical to the first version, but it can be configured for up to 225 bowlers and more than 100 games. For a description of the basic spreadsheet, click here. If you bowl in a league with a three man team and four game series, the spreadsheet can be built this way. If you only want to track your own stats, you can do this, too.
Updates to v. 2.0:
1) Increased flexibility- Can be configured for any number of bowlers and any number of games. 2) Spreadsheet unlocked- The spreadsheet has been unlocked, so formulas can be viewed, and all cells can be selected, copied, and pasted. 3) Marking of high scores- Do you want to know who got the most strikes or spares on your team for the week? Who picked up the greatest percentage of single pin spares? The spreadsheet will automatically highlight the bowler who got the high stat for the week for many statistical categories. 4) Data archiving- the spreadsheet will store your week to week data allowing you to generate reports showing cumulative and average number of strikes, spares, and other statistics for individuals and your team as a whole over the course of a season. 5) Language translation- Do you want to translate the spreadsheet from English into another language? You can do this, too.
Here are a few more screen shots:
Obviously, I have put a lot of work into this spreadsheet, and I have given it away for free. There are no strings attached whatsoever. When I created the first version, I got an overwhelmingly positive reaction, and I received many suggestions for improvement. I have tried to incorporate all of those suggestions in version 2.0. No doubt, I will get additional ideas for changes and improvements. If you have suggestions, just post them as comments below. To support continuing development of this spreadsheet, all I ask is a voluntary donation of $10. Alternatively, you can donate whatever you can afford or think it is worth to you. This is completely voluntary, and the spreadsheet will continue to work whether you donate or not.
To make a donation, use the Donate button on the upper right hand corner of this blog.
To download version 2.0 of the spreadsheet, right click here, select "save link as...", and save the spreadsheet to your computer.
This is the bowling blog for charismatic, astute, and discriminating bowlers. The BM Report began as a newsletter for a Laramie, Wyoming bowling team, the Bowl Movements. We are, by every measure, not particularly skilled at bowling. Mediocrity in bowling is not our goal, but sadly it is the state of our team. For three seasons, we found ourselves positioned in the lower half of the league standings. Last season, we barely crested the top half. Our Monday night venue is the Bernaski Memorial League at the Laramie Lanes. At this point, you might be asking yourself why a subpar bowling team in Laramie needs a blog. Like the great conundrums of philosophy (god, morality, epistemology, etc.), there is no good answer to this question.
Proud S.U.C.K. Member
For membership info: http://thumbhole.blogspot.com/2009/12/brotherhood-of-bad-bowling-is-now.html