Wednesday, August 17, 2005

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
Elkins Ranch (Fillmore, CA) 08/14/05 Red 72.7 123

Par Score Over Par Adj Score Index CH Net Target PTH?
72 100 28 99 24.9 27 73 100 0

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.


Eat Golf said...

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..

Golfchick said...

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

kiwihacker said...

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

Jen Mario said...

No, no, Eat, everyone knows "malleable" means "Saint Diego."

Golfchick said...
This comment has been removed by a blog administrator.
Jen Mario said...

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.

Golfchick said...

Thanks, Jen. Deleted!

Eat Golf said...

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..