Discover new ways to elevate your game with the updated DGCourseReview app! It's entirely free and enhanced with features shaped by user feedback to ensure your best experience on the course. (App Store or Google Play)
It doesn't fix the main problem with handicap leagues (the most consistent players don't win much). Instead, it's basically just a pure give-away to the players with lowest averages (granted, these are the people who complain most about not winning in handicap leagues).
Oops, there was a typo in the second formula. This should be betteR:
=ARRAYFORMULA(
IF(COUNT(Scores!$B4:D4)<3,"",
round(IF(COUNT(Scores!$B4:D4)<6,
(SUM(Scores!$B4:D4))/(COUNT(Scores!$B4:D4))-54...
Sadly, the operation "take average of the last five non-empty cells" is VERY hard to do in straight Excel. I spent a long time trying to find a straight forward way to do it but could only come up with convoluted solutions that look really ugly and are hard to modify.
It should not be...
I am not really sold on the "percent difference from average" rating method since it doesn't really capture the spread of the scores.
I reworked your worksheet using z-scores instead:
zscore Rating sheet.
Using raw z-scores a rating of of +2.0 means that you crushed everyone, and a -2.0...
Here is a list of a lot of the weeklies in SoCal: http://socaldiscgolfclub.wordpress.com/courses/monthly-tournament-info/ but none of those are really near you. However, the traffic is usually pretty good going west in the afternoon. :)
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.
But...
I am not sure that I...
The very best way to mark a mando is with a large net or section of tall chain link fence. ;)
More seriously, in addition to an arrow on the tree or post, it is really nice if you can mark the "perpendicular mando line" somehow (as per http://www.pdga.com/mandatories ) so that it is easy to...
I used to live in SW Ontario and most of my disc business went to Marshall Street. sub-$100 orders generally avoid customs fees, and shipping was always pretty reasonable and always quite fast. The Canadian company with the best selection online might be http://www.fullflightdiscgolf.com/ - I...
I had really negative feelings about the name of the new disc, but Steve's video has convince me not to hate on it. I might even buy one. His lo-fi video blog is the best.
Also, it's too bad the unLace wasn't project #420 because then they could have said that it was good for rolling.
I don't know if you intend this, but I think that this system to going to really punish players with higher averages. If your averages are based on enough (4+) rounds, then the chances that a player with a +13 average shoots +8 or better are generally going to be much lower than the chances...
When Axiom has a bigger line up or if Innova releases more overmolds, you could code for stability by rim colour and speed by flight plate colour (or vice-versa).