Search
|
|
#31 | |
|
PDGA Member
Join Date: Nov 2005
Location: northwest of Indianapolis
Posts: 2,504
|
Quote:
![]() how do i make the formulas that are in place show up on your excel spreadsheet? |
|
|
|
|
|
|
#32 |
|
Community Member
Join Date: Nov 2003
Location: in appropriate
Posts: 8,426
|
almost.
u have 21 rated rounds; calculate the average of 21 rated rounds; calculate the SD from the 21 rated rounds; calculate your range - multiply SD by 2.5 (use 100 if result > 100); subract the range from the average to get your lower boundary; remove any rounds rated below your average; divide 21 by 4 ( = 5); weight the last 5 rounds double; your rating is the average of the rounds with doubling |
|
|
|
|
|
#33 |
|
PDGA Member
Join Date: Nov 2005
Location: northwest of Indianapolis
Posts: 2,504
|
thanks for showing your math. i thought i subtract the range from the rating i get after using the doubled rounds in the calculation to arrive at my rating and then drop any rounds out below that number. i think i like my way better
do you think we could convince Rodney and Chuck to change it?
|
|
|
|
|
|
#34 |
|
PDGA Member
Join Date: Nov 2004
Location: UK
Posts: 374
|
I thought that if an event has 3+ rounds, your best round gets doubled also? Not sure how you'd incorporate this into the spreadsheet though...
Not that it's any good to me anyway. Chuck, is there a particular reason that no European events get provisional ratings? Some of us are stats geeks too you know
|
|
|
|
|
|
#35 |
|
PDGA Member
Join Date: Nov 2003
Location: Twin Cities, MN
Posts: 9,529
|
The ROUNDUP function takes care of calculating the correct number of doubled rounds. D=ROUNDUP(R/4,0) determine how many rounds (D) to double weight where R is your total number of rated rounds. One round will get rouble weighted if R=1 thru 4, 2 will get double weighted if R=5 thru 8, etc.
Bruce, the International events will produce unofficial ratings just like US events. It's up to the TDs to post them. |
|
|
|
|
|
#36 |
|
PDGA Member
Join Date: Nov 2005
Location: northwest of Indianapolis
Posts: 2,504
|
pat, i re-looked at my calculation and i think it was the same method as yours. the only thing is it looks to me like your calculator does not drop out the round i have that is lower than 2.5 times my std deviation... do i need to do that manually? (i want those 3 extra points
)
|
|
|
|
|
|
#37 |
|
Community Member
Join Date: Nov 2003
Location: in appropriate
Posts: 8,426
|
the spreadsheet should apply a weighting of 0 to any dropped rounds. if you send me your rounds and ratings i will run it here and see if i can figure anything out.
|
|
|
|
|
|
#38 |
|
PDGA Member
Join Date: Nov 2005
Location: northwest of Indianapolis
Posts: 2,504
|
Ok, i sent you an email Pat. my only question now is when taking my 5 (n=21) most recent rounds to double-weight them, does it know to pick the best round from rounds 5 thru 8 or does it take the 5th round regardless?
i am down to trying to salvage one point and at least get (unofficially) to 964...
|
|
|
|
|
|
#39 |
|
PDGA Member
Join Date: Nov 2003
Location: Twin Cities, MN
Posts: 9,529
|
If N=21, then 6 are doubled...
|
|
|
|
|
|
#40 | |
|
PDGA Member
Join Date: Nov 2005
Location: northwest of Indianapolis
Posts: 2,504
|
Quote:
a 964.1154 to 964.1111 by my unoffical calculations my round of 883 missed being dropped by 3 points surprisingly, if that 883 round had dropped, my rating would have been slated to only go up an additional 3 points ... |
|
|
|
|
|
|
#41 |
|
Community Member
Join Date: Nov 2003
Location: in appropriate
Posts: 8,426
|
the spreadsheet does not know how to choose which round to double if not all rounds from an event are to be doubled. it simply doubles the last N rounds. if you want to double a particular round, just change the 1 to a 2. dont forget to change a 2 to a 1 somewhere, or you will be doubling too many rounds.
|
|
|
|
|
|
#42 |
|
PDGA Member
Join Date: Nov 2003
Location: Twin Cities, MN
Posts: 9,529
|
Would it work if players are just instructed to always put their best rounds on each date of an event first?
|
|
|
|
|
|
#43 |
|
Community Member
Join Date: Nov 2003
Location: in appropriate
Posts: 8,426
|
yes, that would be one way of making it work automatically.
|
|
|
|
|
|
#44 |
|
Community Member
Join Date: Jan 2006
Location: tyler - the enchanted forest
Posts: 607
|
Chuck, if there's a cut at a tournament after three rounds, and you play in the final round (full 18 holes, not a final 9), does that round count like any other round and you get a rating? or does that count as finals and no rating is given? Thanks.
|
|
|
|
|
|
#45 |
|
PDGA Member
Join Date: Nov 2003
Location: Livingston(Hicksville),Tx
Posts: 7,285
|
Chuck, is the Psycho-Fish Bayou Bogey going to make the update? The event was a month ago but the ratings are still up on the tour page? I Played really well here and i hope they make it.
__________________
Southern Nationals - best events for players who like a true "Non-profit" and a real Finale www.Discraft.com |
|
|
|
|
|
#46 | |
|
PDGA Member
Join Date: Nov 2003
Location: Twin Cities, MN
Posts: 9,529
|
Quote:
|
|
|
|
|
|
|
#47 |
|
PDGA Member
Join Date: Nov 2003
Location: east coast
Posts: 2,592
|
ok chuck...
a hypothecical one for you since my virginia open ratings did NOT make the update which was before the augusta classic(which DID make the update) if the virginia open rated rounds of 996-902(yes i said 902),986,and 978 were before the augusta open rounds...what would my theoretical rating be?? thanks in advance.... keith
__________________
VERY sad to see you go mom / 11/28/42---6/6/2006 14 months after saying...so long my brother 8-29-1983....3-24-2005 and now Nancy - gone on 3/9/12 you all will be missed !! |
|
|
|
|
|
#48 |
|
PDGA Member
Join Date: Nov 2003
Location: east coast
Posts: 2,592
|
assuming you have time of course
__________________
VERY sad to see you go mom / 11/28/42---6/6/2006 14 months after saying...so long my brother 8-29-1983....3-24-2005 and now Nancy - gone on 3/9/12 you all will be missed !! |
|
|
|
|
|
#49 | ||
|
Community Member
Join Date: Jan 2006
Location: tyler - the enchanted forest
Posts: 607
|
Quote:
(Also, for some reason they have me listed as a DNF, and that had better get fixed before they turn in the TD report.) |
||
|
|
|
|
|
#50 |
|
PDGA Member
Join Date: Nov 2003
Location: Twin Cities, MN
Posts: 9,529
|
The order the events get unofficially posted online doesn't matter. The dates for the rounds will be placed in order for the doubling for all events officially processed during an update period.
|
|
|
|
|
|
#51 | |
|
PDGA Member
Join Date: Nov 2003
Location: Twin Cities, MN
Posts: 9,529
|
Quote:
|
|
|
|
|
|
|
#52 |
|
PDGA Member
Join Date: Nov 2003
Location: Livingston(Hicksville),Tx
Posts: 7,285
|
I guess they got the results but not al the $$$ to the PDGA. Well there goes a 1023 rated event.
__________________
Southern Nationals - best events for players who like a true "Non-profit" and a real Finale www.Discraft.com |
|
|
|
|
|
#53 |
|
Community Member
Join Date: Jan 2006
Location: tyler - the enchanted forest
Posts: 607
|
Chuck,
The oldest tournament in my ratings is from June 18th of last year. I have more than 8 rounds and my last played tournament was this past weekend, a year from that date. However, that tourney won't be in the ratings because of the June 7th deadline. Will my tournament from June 2005 still be included in this next rating update? Basically, is the year cutoff a year from your last played tourney, or your last rated tourney? |
|
|
|
|
|
#54 |
|
PDGA Member
Join Date: Nov 2003
Location: Twin Cities, MN
Posts: 9,529
|
It's 365 days back from the date of your most recently rated round. If your total number of rounds in that period is fewer than 8, then we go back farther to get 8 or whatever you have in 24 months if still less than 8.
|
|
|
|
|
|
#55 | |
|
Community Member
Join Date: Jan 2006
Location: tyler - the enchanted forest
Posts: 607
|
Quote:
|
|
|
|
|
|
|
#56 |
|
PDGA Member
Join Date: Nov 2003
Location: Twin Cities, MN
Posts: 9,529
|
Yes
|
|
|
|
|
|
#57 |
|
Community Member
Join Date: Nov 2003
Location: in appropriate
Posts: 8,426
|
&*%*$*$*%*$@#*#$%*%^* !
looks like CAPITOL OF TEXAS and WATERLOO choked on getting the results in on time
|
|
|
|
|
|
#58 | |
|
PDGA Member
Join Date: Nov 2003
Location: east coast
Posts: 2,592
|
Quote:
i knew how it works ,hence my question about theorectical rating....as the augusta classic is making THIS update and the virginia open is NOT making this update... i was just asking IF they both had made it what my theorectial rating would be... that's why i listed them in round order for doubling purposes ![]() again if you have time please ![]() thanks,keith
__________________
VERY sad to see you go mom / 11/28/42---6/6/2006 14 months after saying...so long my brother 8-29-1983....3-24-2005 and now Nancy - gone on 3/9/12 you all will be missed !! |
|
|
|
|
|
|
#59 |
|
PDGA Member
Join Date: Nov 2003
Location: Twin Cities, MN
Posts: 9,529
|
Plug your ratings into the personal ratings calculator that Sandalman posted on the Ask CK thread. You can try a variety of "what ifs" with that.
www.pdga.com/msgboard/showflat.php?Cat=&Number=556248&page=0&view=collapsed&sb=5&o=2&fpart=2&vc=1 |
|
|
|
|
|
#60 |
|
PDGA Member
Join Date: Nov 2003
Location: Augusta, GA
Posts: 608
|
Keith,
The reason the Augusta Classic results got posted and submitted so fast is because the tournament director was PDGA Tour Manager, Dave Gentry. Dave completed and submitted the official results (to himself ) the very next day.Good to see you again and I look forward to meeting future World Champion and sponsor of hole 6 at Lake Olmstead, Lorelei Johnson, in Augusta next month. Regards, Brian Graham
__________________
Regards, Brian Graham, #5861 PDGA Executive Director International Disc Golf Center Endowment Fund |
|
|
|
![]() |
| Bookmarks |
| Thread Tools | |
| Display Modes | |
|
|