DubFore:I think Cobalt is right. One of my members is master and he has a lower handicap than me, -a legend- based just on the required scores he submitted..
The perfect scenario would workout if all tiers played in all the club credit t's they are graded to, but that's unlikely to happen.
Doin the spreadsheet seems like a lot of work for one person. I'm putting my trust in my members to do the maths based on the GHIN system and provide me with their handicaps. Fingers crossed.
Since it seems you're being monitored, Dub, I'm quoting you from the e-mail I received.
I sure wish there was a way to "SQL Query" all of the players' scoring history. Then the handicapping would take about 3 minutes for a 250 member CC. It will take some work, but the spreadsheet does contain hyperlinks to the member's profile. If you click on the player's name, their profile page will load automatically.
While I admit it's not perfect, it beats the heck out of manual. Maybe you can share the routine with your members? Have them send you the detail when they send you their revised handicap? Like I said, sure beats doing it manually!
Also, to insure you get the member's handicap, maybe you can put a post on your forum and let all the members know what they need to do to participate. Players that don't send you their handicap prior to the beginning of the tourney can play, it's just they will be DQ'ed from the final standings, since you didn't receive their handicap in time.
(I'm sure your post will show up eventually ... then this reply won't look so out of place!)