SSA Excel Template

Schoen-hopper · Post by **Schoen-hopper** » Tue Mar 21, 2006 10:46 pm

http://pdga.com/competition/ratings/CalcWCPtemp200.xls

Chuck Kennedy made up an excel spreadsheet quite a while ago that is still posted in the PDGA Information section (under player and course ratings). The spreadsheet is very simple to use. With it you can...

1...Calculate the Scratch Scoring Average (or World Class Par) of any given course layout. Only one round and a couple of rated players is necessary. The accuracy gets better if you have more players and include more rounds. Great thing is that you don't have to sanction a PDGA tournament to find out your course's SSA. Just use the spreadsheet!

2...Calculate individual hole scoring averages and the scratch scoring average for that hole. For people who say that hole par has no real definition, this one number (in tenths) is the answer.

3...Calculate local player ratings. You only need a couple of rated players at your local league to do this. Again, more rated players and more rounds make for increased accuracy, but aren't absolutely necessary to get a close figure. Every player for whom you enter round scores will get a "local" player rating, which functions just like a PDGA rating. No PDGA membership required!

Schoen-hopper · Post by **Schoen-hopper** » Tue Mar 21, 2006 11:02 pm

I plan on using this spreadsheet for figuring World Class Par out at Ted's Dread and later for local league play. Yes, this would be interesting for some of our KDGA events. Maybe a few course evaluations on tour too.

Something else I want to work on is a spreadsheet that includes all 18 holes of a course and what each division shoots in terms of score on each. Not only the score average, but what % of players get 2, 3, 4, 5 etc.

I'd also like to include the coefficient of variation. That is a holes standard deviation divided by the scoring average. The higher the coefficient of variation, the better the hole design (unless the hole has unfairly dense vegetation or OB right next to buckets).

This is basically just saying that holes that regularly get scores from 3 to 4 to 5 or more are better than holes that give 3's 90% of the time. These more diverse holes give more opportunities for the better players to show their skills.

This is interesting stuff. I'm surprised more courses aren't posting their course SSA, scratch hole scoring averages and deviations. I did see, however, the score %'s per hole were posted for the USDGC in DGWN.

Nivek9 · Post by **Nivek9** » Wed Mar 22, 2006 7:11 am

I still plan to get hole-by-hole scoring from the Kan-U-WyCo done. I'll check this out. Thanks.

TanK · Post by **TanK** » Wed Mar 22, 2006 3:50 pm

Who was the Kansan that came up to Treasure Cove in Council Bluffs and did an eval.?

Schoen-hopper · Post by **Schoen-hopper** » Wed Mar 22, 2006 10:38 pm

Nivek9 wrote:I still plan to get hole-by-hole scoring from the Kan-U-WyCo done. I'll check this out. Thanks.

You should do this Kevin. I bet Wyco has a lot of holes with decent scoring spread. It'd be interesting to see if the holes with the better scoring spreads are also some of the course favorites.

One question I asked myself is how should the hole score %'s be listed? You can't throw everyone together or you can't tell what youve got. You don't really want to do it by division as their are both 870 and 970 players playing advanced. I was thinking to do it by ratings for 975+, 925-975, 875-925, & below 875.

What you thinking about the hole score percentages or more about the hole scratch scoring averages?