Forums

Help › Forums

Saturated @ Tour Master: 50 ranked rounds

rated by 0 users
Wed, Jul 29 2015 9:47 PM (21 replies)
  • BigInigoMontoya
    208 Posts
    Sun, Nov 9 2014 5:52 PM

    This isn't exactly a game tips thread, but it seemed so out of place in any other category so here we are. I may bump it every now and then down the road to ask the community for tips, but lets not put the cart before the horse on that one. 

    10 different courses. 50 ranked rounds. Stroke play average of 66.84. Clearly I still have a long ways - a long, loooooooooooooooooong ways to go if I am going to improve my average and advance my tier. Some courses were featured more than others, but overall I feel like I have a fairly decent distribution included in the sample size. Now comes the fun part, trying to trick Excel into using only the fifty lowest scores to compute my average going forward LOL.

    1. Merion................................69.00........01 Sept 2014
    2. Kiawah Island......................68.00........02 Sept 2014
    3. Bethpage Black...................67.00........03 Sept 2014
    4. Oakmont.............................66.00........03 Sept 2014
    5. Royal Saint Andrews............66.00........04 Sept 2014
    6. Royal Saint George's............67.00........05 Sept 2014
    7. Kiawah Island.......................65.00........06 Sept 2014
    8. Merion.................................68.00........07 Sept 2014
    9. Royal Saint George's............65.00........07 Sept 2014
    10. Royal Saint Andrews............63.00........09 Sept 2014
    11. Kiawah Island......................69.00........10 Sept 2014
    12. The Olympic Club................67.00........10 Sept 2014
    13. Merion................................69.00........11 Sept 2014
    14. Pinehurst #2........................71.00........11 Sept 2014
    15. Congressional Country Club..66.00........11 Sept 2014
    16. Oakmont.............................68.00........11 Sept 2014
    17. Cabo del Sol........................70.00........13 Sept 2014
    18. Royal Saint Andrews............66.00........14 Sept 2014
    19. Congressional Country Club..69.00........15 Sept 2014
    20. Oakmont.............................65.00........16 Sept 2014
    21. Kiawah Island......................71.00........17 Sept 2014
    22. Congressional Country Club..65.00........17 Sept 2014
    23. Royal Saint Andrews............66.00........18 Sept 2014
    24. Oakmont.............................68.00........19 Sept 2014
    25. Merion................................69.00........20 Sept 2014 
    26. The Olympic Club................64.00........20 Sept 2014
    27. Kiawah Island......................68.00........21 Sept 2014
    28. Royal Saint Andrews............62.00........21 Sept 2014
    29. Congressional Country Club..68.00........23 Sept 2014
    30. Royal Saint George's............69.00........23 Sept 2014
    31. The Olympic Club.................66.00........24 Sept 2014
    32. The Olympic Club.................69.00........25 Sept 2014
    33. Royal Saint George's............67.00........25 Sept 2014
    34. Royal Saint Andrews............68.00........26 Sept 2014
    35. Kiawah Island......................64.00........26 Sept 2014
    36. Pinehurst #2........................68.00........28 Sept 2014
    37. Royal Saint Andrews............63.00........28 Sept 2014
    38. Pinehurst #2........................66.00........29 Sept 2014
    39. Royal Saint Andrews............63.00........01 Oct 2014
    40. Kiawah Island......................66.00........02 Oct 2014
    41. Bethpage Black...................67.00........03 Oct 2014
    42. Cabo del Sol........................63.00........04 Oct 2014
    43. Bethpage Black...................66.00........04 Oct 2014
    44. Bethpage Black*..................66.00........09 Oct 2014
    45. Kiawah Island......................65.00........31 Oct 2014
    46. Royal Saint Andrews............67.00........01 Nov 2014
    47. Pinehurst #2........................66.00........02 Nov 2014
    48. Bethpage Black...................67.00........04 Nov 2014
    49. Oakmont.............................69.00........05 Nov 2014
    50. Royal Saint George's............72.00........05 Nov 2014

     *This round was played on the Back 9 only as part of the inaugural Country Club Clash event. Master tees on Very Fast(10) greens, IIRC.

    Overall, I'd have to say that I'm mostly satisfied with these results. If my count is correct, greater than 90% of these rounds were shot at even par or better. Not too shabby since IIRC, only two of these rounds were played outside my normal setup of RocketBladez and the World Gnome Tour™ starter ball. Its highly unlikely that set up will take me to Legend, but for now I'm just going to Grip It and Rip It and hopefully enjoy the ride. 

  • SweetiePie
    4,925 Posts
    Sun, Nov 9 2014 7:05 PM

    BigInigoMontoya:
    Overall, I'd have to say that I'm mostly satisfied with these results.

     

    Absolutely ! And you should be...fine play by any standard..really fine.

  • alosso
    21,067 Posts
    Sun, Nov 9 2014 10:26 PM

    Well done B!

    BigInigoMontoya:
    Now comes the fun part, trying to trick Excel into using only the fifty lowest scores to compute my average going forward LOL.

    There may be a function to pick the 50 lowest numbers but I didn't find it yet. I take the four columns that you show and exclude the Par3s and Par5s and sort them by score before manually selecting the top 50. (It becomes more difficult as a Legend with 500 to count.)

    The counter in front is important to restore the sequence of play (reverse, BTW).

  • ScottHope
    10,409 Posts
    Mon, Nov 10 2014 1:48 AM

    This might work for you in Excel Big

    {=AVERAGE(SMALL(*your scores array goes here*,ROW(INDIRECT("1:50"))))}

    You'll notice the formula has curly brackets at either end, you don't type these in, the formula is entered using the key combo CTRL + SHIFT + ENTER because it is an array formula, the curly brackets will then appear automatically & there's no need to do any sorting beforehand.

    (The highlighted number can be altered to suit the quantity of values you wish to average, so you could change it to 500 if you were a legend or 40 if you were a master etc).

    Hope that helps.  : )

  • PaulTon
    10,731 Posts
    Mon, Nov 10 2014 2:00 AM

    Royal St. Andrews?  Not a course I've ever heard of, is it new?

  • BigInigoMontoya
    208 Posts
    Mon, Nov 10 2014 11:12 AM

    ScottHope:

    This might work for you in Excel Big

    {=AVERAGE(SMALL(*your scores array goes here*,ROW(INDIRECT("1:50"))))}

    You'll notice the formula has curly brackets at either end, you don't type these in, the formula is entered using the key combo CTRL + SHIFT + ENTER because it is an array formula, the curly brackets will then appear automatically & there's no need to do any sorting beforehand.

    (The highlighted number can be altered to suit the quantity of values you wish to average, so you could change it to 500 if you were a legend or 40 if you were a master etc).

    Hope that helps.  : )

    What I ended up doing is creating two dedicated pages in my wgt_tour workbook. Page 1 is Stroke Play Avg. It contains scores for ALL ranked rounds on regulation par 70, 71, or 72 courses. In column A is the course name, column B is the score, and column C is the date played. In cell G1 I have the following formula: =AVERAGE(IF(B1:B500<>0, B1:B500,"")). B500 is just a placeholder; I used that cell so I could enter many scores and not have to keep updating the formula constantly.

    The second page of the workbook is Saturated Avg. I copied the 50 entries from page 1, and each time I shoot a round lower than the highest score on the Saturated Avg. page, I manually replace the high score with the lower one. I also have an x in column D on the Stroke Play Avg page, so I know which scores are currently being used to calculate my saturated avg. This is a much simpler calculation, I just use =AVERAGE(B1:B50). It does require a little bit more work on my end, but it does have the benefit of showing me which rounds are included in the saturated average, as well as letting me know what score I need to beat to lower my average.

    PaulTon:
    Royal St. Andrews?  Not a course I've ever heard of, is it new?

    I could be wrong about this one, since I'm not from the area, but I understood Saint Andrews to be just the common name. The 'official' name being The Royal and Ancient Golf Club of Saint Andrews. Even though I disagreed with their now repealed policy of no female members, given their history and importance to the sport I felt like Royal was a title that they have earned, so I personally commonly refer to the course as Royal Saint Andrews. It may be a bit unusual to list it this way, but as far as I know it isn't totally wrong.

  • PaulTon
    10,731 Posts
    Mon, Nov 10 2014 12:07 PM

    The course is St. Andrews Golf Links, you may be getting confused with The Royal and Ancient Golf Club, which is the private club based at the public links.

  • ScottHope
    10,409 Posts
    Mon, Nov 10 2014 12:44 PM

    BigInigoMontoya:
    In column A is the course name, column B is the score, and column C is the date played. In cell G1 I have the following formula: =AVERAGE(IF(B1:B500<>0, B1:B500,"")). B500 is just a placeholder; I used that cell so I could enter many scores and not have to keep updating the formula constantly.
    One way of getting your scores range to grow automatically (dynamic range) is to convert it to a table. Two of the features of tables is that you can filter & sort the data and also have a totals row at the bottom which can contain an average formula that updates automatically as you enter new data.

    This pic shows a table (ignore the numbered indicators as this was originally posted in another thread).

  • drmoose
    3,540 Posts
    Mon, Nov 10 2014 1:41 PM

    Not for nuthin', but, I usually don't get  "saturated " until I'm well into cocktail hour, just ask those who've had the misfortune of watching me try to play under those conditions.

    Doc :)

  • CanineSupervisor
    1,882 Posts
    Mon, Nov 10 2014 1:43 PM

    drmoose:

    Not for nuthin', but, I usually don't get  "saturated " until I'm well into cocktail hour, just ask those who've had the misfortune of watching me try to play under those conditions.

    Doc :)

    PMSL!! Doc

     

     

RSS