Tag Archives: Excel

Straight Pool & Equal Offense Scoresheet/Spreadsheet Update

Posted on by

I’ve made some updates to the score sheets.

I’ve uploaded all of them now to GoogleDocs for one. That’s the big change.

Other small changes, currently exclusive to the GoogleDocs versions, are minor formatting changes, formulaic changes to rid the sheets of #DIV/0 errors, and the removal of some extraneous columns to help with formula drag filling.

Furthermore, I’ve shared all the GoogleDocs versions so they’re public for the finding, though I’ve retained exclusive editing rights.

As always, suggestions and tweaks, especially those that stem from trial-by-fire experience, are always welcome.

Straight Pool & Equal Offense Scores and Stats Sheets

Bike to Work Week, Slow Cycling Weekend, and Chilly

Posted on by

A cool 40°F kicked off the 2008 Bike to Work Week work week this morning. There are various activities set aside for the week, but my schedule is going to keep my from doing… well, any of them, really.

The Commuter Convoy that others are having great success with was a bust for me (and others) this morning. I arrived at the Walmart parking lot at about 06:05 this morning and hung out until 06:15. No one showed, so I took off. On Quivira at around Monrovia, I passed the news crew that interviewed Noah. They didn’t even raise their heads for a lone cyclist not part of a convoy. I guess that’s not news.

This weekend was similarly news unworthy. With the rain on Saturday and the wind on Sunday, I stayed indoors and watched much of the television with the GF. I did get on the rollers for an hour or so on Sunday, pulling the equivalent of about 20 miles. It’s a shame really, the rollers marked the first time the new Edge 705 met the Torelli, and the maiden voyage of the new Triple cranks. They work, at least on the rollers, like a champ. I love the fact that I lost nothing on the high end, but gained a lot of wiggle room on the low. I am so not worried about the Triple Bypass now.

While watching the Buffy, and since I couldn’t/wouldn’t get my newly transformed Torelli out into potentially nasty, bottom bracket chewing weather, I, instead, revamped a process that had, up until this point, been somewhat cumbersome. Previously, to update my mileage and expenses pages, here and here, I updated an Excel spreadsheet, and then copied and pasted the results of the formulas and calculations into my site. I’d built an elaborate and complicated set of concatenate functions to distill the many numbers into an easily copy/paste format. While such an endeavor did teach me much in the ways of Excel Love, it was a process much less than streamlined.

So, I converted that locally bound Excel spreadsheet to a Google Docs spreadsheet, and then took advantage of the publishing options, and embedded choice bits and pieces straight into my site. While this does offer the disadvantage of being reliant on the availability and accessibility of Google Docs any time one visits my site, as well as being somewhat limited in formatting options, it offers the advantage of merely having to update the spreadsheet online once, and simply being done. My updates show up here automagickally.

Score Sheets

Here Be Screenshots

Overall statistics across matches.

The Stats Sheet… no input required, simply play and watch the numbers gather.

Match score sheet

The Match Sheet… plug in the match points and table size, and then for each inning, the balls pocketed in the “Balls” column, and why the inning ended in the “Finish” column. It’s that easy!

They’re provided as is, though I do tweak them a bit every now and again. If you have any questions or comments, please feel free to comment below. I’m always open for suggestions and ideas.

All are in both Excel 2003 and GoogleDocs format.

  • Straight Pool (14:1 Continuous) Scoresheet (~220KB Excel 2003 .zip / GoogleDocs)

    A handy (at least for me) spreadsheet I built that takes most of the work out of playing Straight Pool. All the players need do, aside from actually bringing a laptop with them to make the recording of the match easier and the statistics real-time, is in the shaded columns place the number of balls potted, and then place a letter in the adjacent column indicating why the inning ended, be it a miss (m), a safety (s) or, Heaven forbid, a foul (f).

    What you get…

    • 1 worksheet for stats across 10 games
    • 10 worksheets, one for each game, on which match points, table size and scores are entered.

    What it does…

    • displays the total balls potted
    • tracks the current rack
    • tallies the balls potted in the current rack
    • figures the balls remaining in the current rack
    • determines the foul the player is on (with appropriate penalties for consecutive fouls)
    • knows the number of successful safeties
    • tells of the number of unsuccessful safeties
    • calculates the player’s current score
    • reveals the player’s high run
    • computes the number of runs 5 and over
    • enumerates the number of runs 10 and over
    • reckons the number of runs 20 and over

    As you can see, it’s chock full of geekish goodness. Enjoy!

  • Straight Pool (14:1 Continuous) Three Player Scoresheet (~313KB Excel 2003 .zip / GoogleDocs)

    This spreadsheet is pretty much the same as the other, keeping track of all the same things, except it does so for three players, rather than two. Sometimes it’s fun to play a game of Round Robin Straight. It keeps everyone involved and feeling good.

  • Equal Offense Scoresheet (~18KB Excel 2003 .zip / GoogleDocs)

    This one is pretty simple.

    1. For each frame in a game, put your run in the first column, and the reason the run ended in the second, be it a miss (m), a safety (s) or, Heaven forbid, a foul (f).
    2. Watch the pretty graphs draw themselves!


Straight Pool Scoresheet/Spreadsheet Update

Posted on by

After playing with the spreadsheets last Sunday, some weaknesses became apparent. I’ve updated the spreadsheets to address those weaknesses.

To wit:

I now track the total number of balls potted, the current rack number, the balls potted in the current rack and the balls remaining in the current rack. This will help with score keeping if you’re anything like us and sometimes forget how many balls a player potted in their last inning. Without a dedicated score keeping lackey, it’s sometimes tough to keep track.

An interesting, if not entirely useful statistic would be the percentage of racks finished by each player. The formulas for keeping track of the current rack and ball count was tough enough, I’m really not sure how I’d go about that.

I also fixed some miscalculations in the 3 person score sheet. The stats for the third player were not being calculated correctly. They are now.

So, without further ado…

Straight Pool & Equal Offense Scores and Stats Sheets

Equal Offense Geekery

Posted on by

While not nearly as complex as my Straight Pool Scoresheet, my Equal Offense scoresheet might still come in handy. I’ve used it (in one of it’s many incarnations) for years as a way to gauge my progress (always in the positive, btw – I’m doing something right).

You can download it on this page if you’re of the mind.

On the Scoresheet worksheet, each inning is split into two columns, the 1st for your score, and the 2nd for the “Frame Conclusion.” I’ve used drop down menus for the 2nd column… you have the options of “f” for Foul and “m” for Miss. The rest of the columns are self explanatory.

The Trends tab is there to show progress over time.

EO, in case you didn’t know, is basically one person Straight Pool. It’s structured so you can get a real sense of improvement and progress.

From the Pool & Billiards FAQ:

Same rules as straight pool (14.1) except as noted. (You must be familiar with those rules, or EO won’t make much sense, especially the break shot with the 15th ball.) Each player gets ten turns alone at the table; a turn begins with an open break of a full rack, and ends on a miss, foul, or run of twenty. Respot any balls that go in on the open break, and start with ball in hand in the kitchen. There is no penalty for scratching on the break. A foul does not subtract points, it just ends the turn, but balls made on a foul do not count. There is no head-to-head play, so there are no safeties.

There are variations you can apply, such as allowing three misses before you close the frame, or limiting yourself to 15 ball runs (preventing having to think about the break shot for the next rack). If you start one way, though, do yourself a favor and be consistent.

14:1 Continuous Spreadsheet Geekery Oh My!

Posted on by

I’ve been toiling away for the last few days on a way to keep score during 14:1 Continuous (Straight Pool) matches in the most geekish way possible – with a spreadsheet. I hate trying to do the math while I’m playing a game of 14:1 on those little score pads built into the table, or worse yet, on an abacus style score string hung above the table. It’s distracting from my world beating runs of 6, or even 14 balls at a time! Using a handwritten scoresheet just means more math, and not much in the way of decent analysis.

Hence, the spreadsheet solution.

The rules are pretty involved, especially around fouls and the penalties therein, so it took a while to get it right. Frankly, I’m not convinced I have gotten it entirely right. So, while I’m making this spreadsheet available, use at your own risk, and if there’s money on the game, don’t come running to me if the score keeping isn’t entirely accurate. This is pre-alpha type stuff here, people.

That said, try out my Straight Pool Scores and Stats Sheet [~220KB .zip file] if you’re of the mind. There’s also a three person version [~320KB .zip file] available if you like to play three person Straight Pool.

All the cells are locked and the workbook and all included sheets are protected, but there is no password. I did that simply to ease the transition between cells, and to prevent any errant fiddling in the middle of a heated match.

The first sheet, “Stats” is where the matches are summarized. You shouldn’t have to do anything here but gaze in wonder at your prowess.

The rest of the sheets, named “1″ through “10″ are the matches. You can edit the colored cells, and they are:

  • Match Point is the number of points to win the match.
  • Table Size is there in case you want to know the table size you played the match on. I know… it’s only ever legitimate on a 9′ table, but sometimes it’s fun to mess around on 7′s and 8′s.
  • The column under the heading “Balls” is where you record the number of balls you made that inning. The next column under “Finish” is where you record why you quit shooting, be it a foul (f), a safety (s), or a miss (m). It’s important that you use the letters f, s and m in order for the stats and scores to be accurate.

I would like to work in a way to highlight when a rack is done. It might be nice to know how many racks it took to get to a certain score over time as a way of gauging progress.

Let me know what you think of it. I look forward to hearing what all three of you think!