The Golfchick

That chick blabbing about anything golf related.

Progress and handicap calculator

I have mentioned my calculator/spreadsheet a few times now. Here is its latest entry:

18 Holes Date Tees Course Rating Slope
Par Score Over Par Adj Score Index CH Net Target PTH?

It’s a record I keep of all my rounds since I started. I enter in the course information (rating, slope and par), my handicap index that day (it changes almost daily), and my score. The rest of the columns have formulas and calculate for me how many strokes over par I was, what my actual course handicap was, my net score, my target score for the course handicap and how many strokes I played over or under my handicap. It rounds the number off for the display, but my “PTH” (played to handicap) number for the example shown above is actually 0.196460176991152. It would show it in red and with a – sign if it was under my handicap.

To me, this is an indicator of the progress I’m making over time. Of course, statistics are so malleable. If I could measure my competitive spirit that day or my level of focus during tournament rounds, or have it factor in columns for stress levels, distractions or even number of drinks consumed, I might have a more accurate and helpful tool. It might not be a good indicator of anything, but at least I find it interesting.

I’d like to post the actual calculator template so people could copy it if they wanted but I haven’t figured out a way to do that on blogger. I doubt the excerpt above will view correctly on all systems, either, but you get the idea.

Next post.

7 Comments

  1. Eat golf: Ah yes, malleable – discovered by the Germans in 1904, it means *a whale’s .. *

    Golf Chick: No, That. Can’t. Be. It.

    Eat golf: Actually, no one really knows what it means anymore, I was just trying to impress you..

    Golf Chick: Doesn’t it mean, capable of being shaped or formed, easily controlled or influenced, like – adaptable?

    Eat Golf: Historians maintain that the translation was lost hundreds of years ago.

    Golf Chick: No, that is what it means.

    Eat Golf: Well, agree to disagree..

  2. “Let me explain… no, there is too much. Let me sum up.” (Inigo Montoya, 1987) You always impress me, Eat.

  3. sweet so I’m not the only one that tracks my stats as depressing reading as they make sometimes

  4. No, no, Eat, everyone knows “malleable” means “Saint Diego.”

  5. Hey, you know you’ve made it as a blogger when you start getting spam comments, which is what that was. We get those all the time on TG, you just have to delete them. They always start with “love your site” and end with crap links. Very annoying.

  6. Thanks, Jen. Deleted!

  7. Jen –

    They say that 60 percent of the time, quotes like that work all the time!

    You are awesome, I knew someone out there would get that reference!

    😉

    PS – it has bits of real panther in it so you know it’s good..

Leave a Reply

Your email address will not be published.

*

© 2024 The Golfchick

Theme by Anders NorenUp ↑