Kudos to davetherocketguy for actually uploading a spreadsheet.
Have you tried this system in an actual league? I am all for trying to things other than the simple "strokes off your average" handicapping but I am never sure how open players will be to it.
Haven't tried it out yet but I will leave it up to them and if they don't like it they can help me come up with something better.
I am not sure that I find this obvious. One of the most consistent players in one of my leagues was a guy shooting about +14 worse than the best players. So 2 strokes better than average for him would be harder than 2 strokes below average for anyone else in that league - so he would have a hard time ever winning with percent based handicaps.
That's a good point.
Well, maybe this setup would push someone to try to get themselves to be better than average sometimes. I donno...we'll see.
My inner math nerd thinks you should track players' Average and Standard Deviation and then award the winners by their z-score rather than just a percent (these are all easy to calculate in a spreadsheet). But your average player is not likely to be as familiar with statistics as they are with percentages.
Oh good googly moogly. Yeah, I ain't doing that. Not because it isn't a good idea (sounds like it is) but I just have no idea how to and I am not exactly a math nerd...