andyson: Is copying the scoring history the only way to load the data or will you have the option to manually load individual round scores? That way the hcp can be based only on a particular set of tournaments if the CC desires.
gk21al: I am wondering about this as well.
This is a great idea professor. What I'll do is have 2 different routines: (1) upload scores and (2) Calculate Handicap.
Currently, when the scores are uploaded, I place them on a temporary spreadsheet, gather the 20 last scores, then sort these scores in lowest-to-highest score. I then pick the top 10. The change I'll make is when gathering scores, I'll put all the "Front 9", "Back 9" and "Full 18" scores on the temp spreadsheet. At this point, the user can go through the spreadsheet and put any character into a column I'll label as "Exclude". If you put any valid character (ASCII 0 - ASCII 255) in this field, the score will not be used. If you don't put anything in the cell, the score will be used.
This will allow the CC owner or Handicap Chairperson the ability to exclude uneven lies tourneys from the handicap, along with par 3 and par 5 scores. Currently, I'm scanning the tourney description for "Par 3" and "Par 5". If the description contains this in the tourney description, it's not used. I do not, nor can I exclude "Uneven Lie" tournaments from the handicap, since these are not distinguished in the player's scoring history. (By the way, I don't really see a par 5 score getting placed in the top 10 scores, unless the player has been playing nothing but par 5 scores for their last 20 rounds).
Now, if this is changed to a two-phase routine from it's current one-phase routine, the CC Owner/Handicap Chairman can exclude selected tournaments.
I love it! Thanks!
Kat ♥
PS: Cheap-azzed Baggs has yet to slip me a sleeve of balls ... he keeps telling me he bought me an unlimited supply of Starters, but I was getting those long before we were friends. My CC owner got those for me when I first started playing WGT! ;-D