Sunday, December 6, 2009

BM Bowling Spreadsheet v.2.1


The BM Bowling spreadsheet was created as a tool for bowlers and bowling teams to track performance statistics. It is available free of charge, but voluntary donations are accepted. To donate, click on the Paypal link on the top right of this page. This is the third iteration of the spreadsheet. It can accommodate virtually any number of bowlers and games.

I try to accommodate requests made by commenters to this blog. The revisions made in v. 2.1 are largely due to such requests, and I am open to making more changes, so feel free to chime in. In this post, I only describe updates made in the new version. For basic information on the spreadsheet and its capabilities, see these two posts:

Bowling Scoring and Statistics Spreadsheet
Bowling Scoring and Statistics Spreadsheet, v. 2.0

Split Marking and Statistics- The spreadsheet can now mark and count splits for each bowler and for the team as a whole. Split statistics are kept by series. In the screen shot below, splits are marked by frames highlighted in green.

Individual and Team Handicapped Game Scores- In prior versions, handicapped scores were only calculated for series. I have now added handicapped scores to individual games. In the screen shot below, the blue arrows indicate where handicapped game scores are now shown. Beneath each game, the spreadsheet also calculates the total team scratch and handicapped scores for that game.


To get version 2.1, just right click on the link that follows, and choose "Save Link as". Then, download the spreadsheet to your computer. Download link: BM Bowling spreadsheet v.2.1

21 comments:

  1. Todd,
    It looks great. Thanks for doing that.

    ReplyDelete
  2. Todd,
    Did you have any luck figuring out why it would not create a new sheet when the workbook is opened on a computer running Excel 2003?

    ReplyDelete
  3. No, but I will look into that now. I assume it is something with the VBA that is not compatible. Whatever it is, it should be fixable.

    ReplyDelete
  4. Ok. this is a lot more complicated than I thought it was going to be. Essentially, it has to do with new VBA codes that Excel 2003 does not recognize. It seems to hang in formatting routines, such as the adding of borders, and the drawing of the graph.

    For the time being, if you can run it on 2007, I would create a blank spreadsheet which can be copied. You should be able to use those on 2003, and I think the archiving and marking routines should work as well.

    I will continue to work on this.

    ReplyDelete
  5. I will continue to run it on my laptop with MS Excel 2007. Just wanted to know if I could work with it at work or on desktop with computers that still run XP and Office 2003.

    ReplyDelete
  6. Todd,
    I have another suggestion that you may want to consider adding. I seem to always roll a crappy ball after either a strike or spare. So I was wondering if you could add first ball average after strikes and first ball average after spares.

    Anthony

    ReplyDelete
  7. Interesting that you bring it up. You are actually the 2nd person to suggest it. I have thought of calling this "mark capitalization" meaning did you capitalize on your marks or choke on them?

    I have considered including it for many months, but I have hesitated to do so because it would be difficult to calculate it using a simple formula. I could easily build another macro to do the calculation. Maybe I'll do that because I have always wondered how I fare as well.

    There is the related issue of how it should be calculated. You suggest 1st ball average after a mark, but I was thinking that it could be the actual versus total possible score for all frames with marks expressed as a percentage. In other words, the maximum possible score for a spare frame is a 20. If you got an 18, this would be 18/20 or 90%. For a strike, it's 30, so 18/30= 60%. If you summed all these up by game and series, you'd have a percentage ranging from 0 - 100%.

    that's how I have imagined it anyway.

    ReplyDelete
  8. That sounds good to me. The macro approach may be easier for you if you can modify the code that determines the first ball average to give the first ball after mark average.

    ReplyDelete
  9. Todd,
    I was reading some of your old blogs and found the BM Simulator from January 09. Is it it available to the rest of us like the scoring spreadsheet?

    Anthony

    ReplyDelete
  10. No, it is isn't, but there is no reason why it can't be. It is not as user friendly as the spreadsheet, and it requires a lot of number crunching to make it work. But I find it a useful tool.

    ReplyDelete
  11. Could you email it to me or provide a link for me to download it? I don't mind the number crunching as I am left-brain dominant usually. Anyway, I appreciate it.

    ReplyDelete
  12. Check your inbox. It should be there.

    ReplyDelete
  13. if you bowl a split in the 10th frame on the third ball, do you bother marking that as a split?

    ReplyDelete
  14. I do not, and the spreadsheet currently cannot record this. Since it cannot be picked up by definition, I don't worry about it.

    ReplyDelete
  15. First off...Thank you for this amazing tool.

    Now for my question: Maybe I'm not seeing something so simple because of the number of features, but is there a way to record a team handicap? I have joined a league that only uses team handicap based on the opposing team for the current week. A team average is calculated from previous games, then matched to the current week opposing team. Handicap is 90% of the difference in average. Is there a way to enter this as a total per game for the team and not per individual?

    ReplyDelete
  16. This spreadsheet is awesome!! I wonder though, can it be modified for candlepin bowling? In candlepin you get a third ball, and if you get all pins on the third ball its scored as a "10".

    Thanks!
    Frank

    ReplyDelete
  17. Hi Frank,

    Thank you for your kind words. Yes, it could be modified for candlepins or duckpins, but I have pretty much retired from the bowling spreadsheet business.

    Todd

    ReplyDelete
  18. Hey Todd. Thanks for your response. I appreciate that you've moved on. Is the modification something simple that a novice could figure out? Or is it extremely complicated? I'm dying to make this work out for candlepin because I was just drafted to a pro league and it would make keeping my stats MUCH easier. Thanks for all of your awesome work on this!!!

    PS I noticed you have a paypal donation option. If you were willing to make the modification, I'm more than happy to contribute something like $25-30 bucks.

    Thanks Todd!

    ReplyDelete
  19. Frank, Is it simple for a novice? Hmm. I don't think so. I really appreciate your offer of a donation. Why don't we move this conversation to email. My email address is: surovell@uwyo.edu. I'm really busy this week, but I might be able find some time to work on it starting next week. -Todd

    ReplyDelete
  20. This is awesome. I was in the middle of thinking of creating something very similar when I came across your spreadsheet. It works perfectly and you should be receiving a donation from me very soon.

    Thanks a lot!!

    ReplyDelete
  21. Hi Todd, was there ever a fix for running the sheet on 2003?

    ReplyDelete

Note: Only a member of this blog may post a comment.