Results 1 to 13 of 13

Thread: 2017 Masters Motivational Times

  1. #1
    Very Active Member Swimosaur's Avatar
    Join Date
    Jul 2009
    Location
    Knoxville, TN
    Posts
    654

    2017 Masters Motivational Times

    Here are the 2017 SCY motivational times. LCM & SCM will be posted later!

    Motivational times are presented in three formats: human-readable PDF, and two CSV spreadsheets. In the first spreadsheet (mm:ss), times are rendered in the usual minute:second notation. In the second (sec), times are converted to seconds, which facilitates stuff like this. Have fun!



    ------------------------------------------------

    Motivational times (MTs) are calculated from the base time given in Column X. The algorithm for calculating the base time is similar, but not identical to, the method USMS uses to calculate national qualifying times (NQTs) for the annual SCY national championships.

    Most of the time, Column X is
    (A) the average of the previous three year’s 10th place times.

    However, if there are fewer than three 10th place times over the previous three years, we use, in order,
    (B) average of two 10th place times over the previous three years. If there are fewer than two 10th place times,
    (C) average of three 5th place times + 4.45%. If there are fewer than three,
    (D) average of two 5th place times + 4.45%. If there are fewer than two,
    (E) No Time (NT).

    If one of the alternatives B-D is used, it’s indicated by a superscript.

    The rest of the columns are proportional to Column X as follows,

    AAAA = X + 5%
    A = X + 20%
    AAA = X + 10%
    BB = X + 30%
    AA = X + 15%
    B = X + 40%
    For MTs, the same algorithm is used for all three courses, SCY, LCM, and SCM.

    Relationship to NQTs. For SCY, as long as Column X is calculated using method A, B, or E, Columns AA and AAA should be, but are not guaranteed to be, exactly the NQTs for sprints and 200+ events respectively. However, there will be some small differences for methods C and D. For LCM, the MTs should be different from the NQTs in all cases. USMS does not publish NQTs for SCM or for age groups 85+.

    Column X. I like to think of Column X as “the moral equivalent of a Top Ten time”. Of course, in any given year, the 10th place time will be faster or slower by some amount than the average of the three previous years, so of course, Column X is not an actual Top Ten time. Too bad, huh? You can also think of it as “the time I need to hit to have about a 50/50 chance.”

  2. #2
    aka Elaine-iaK & Aqua Dog ElaineK's Avatar
    Join Date
    Feb 2010
    Location
    Georgia
    Posts
    4,012

    Re: 2017 Masters Motivational Times

    Thanks for all that you do, Swimosaur! You do a great job with this!
    http://ElaineiaKsTravels.wordpress.com

    ~ Believing in your dreams can be far more rewarding than living by your limitations ~Karla Peterson

  3. #3
    Very Active Member SwimDogs's Avatar
    Join Date
    Dec 2009
    Location
    Polson, MT
    Posts
    255
    Blog Entries
    18

    Re: 2017 Masters Motivational Times

    Nice work, Swimosaur!

    Any chance, with your spreadsheet expertise, that you could come up with a formula to update and improve this "age grading" calculation from 2006?

    http://www.usms.org/articles/articledisplay.php?aid=143

    Let me know if you might be able to do this easily...it's a bit beyond my capabilities.

    Thanks,

    Mark Johnston
    USMS Online Workouts

  4. #4
    Very Active Member Swimosaur's Avatar
    Join Date
    Jul 2009
    Location
    Knoxville, TN
    Posts
    654

    Re: 2017 Masters Motivational Times

    Quote Originally Posted by SwimDogs View Post
    Any chance, with your spreadsheet expertise, that you could come up with a formula to update and improve this "age grading" calculation from 2006?

    http://www.usms.org/articles/articledisplay.php?aid=143
    I did something very similar in this post. The main difference is, I used more aggressive averaging,

    • Nordstrom used 5th place times from 2004; I used the average of 10th place times from 2013-2015.
    • Nordstrom calculated age-grading ratios for both men and women, for all events. I wanted a smaller number of numbers in the final table, so I averaged over events, and combined men & women.

    In addition,

    • Nordstrom used data for all events; I threw out IMs and all events longer than 200 yards (simply because it made my job easier. I wasn't trying to be so thorough and meticulous).
    • Nordstrom's ratios are less than one, mine are the reciprocals (greater than one).

    Given that, I would not expect there to be too much difference between my factors and (the reciprocal of) Nordstrom's factors, for the bottom row of his table, which is the average over all events. See graph below.

    The relevant equations are (for my factors),

    If you're trying to convert a time from a younger age group to an older age group (from my 2015 post),
    Younger Time in sec * ( Older Factor / Younger Factor ) = Predicted Older Time in sec

    And if you're trying to convert a time from an older age group to a younger age group,
    Older Time in sec * ( Younger Factor / Older Factor ) = Predicted Younger Time in sec

    The factors are,

    AG Factor
    18-24 100.00
    25-29 100.81
    30-34 102.88
    35-39 104.38
    40-44 105.49
    45-49 107.05
    50-54 109.49
    55-59 114.81
    60-64 123.22
    65-69 135.87
    70-74 156.47
    75-79 190.36
    80-84 214.17

    For comparison, here's a graph of my factors vs. Nordstrom's averages,



    To my eye,

    • The factors Nordstrom vs. Swimosaur are not too different for age groups through 45-49 for both men and women. For men, they are nearly identical through 65-69.
    • For age groups 50+, Nordstrom's factors are higher for women than men. I also noticed this in the 2015 post ("The curves are almost parallel, but not quite."), but I averaged men & women anyway.

    Personally, if I were going to do this, I would use my factors and formulas. They are simpler. You don't have to wade through big tables of numbers. After all, this is an inexact science, close enough is good enough, and your time would probably be better spent doing a killer kick set

    For another, probably superior method, see Chris Stevenson's calculator.
    Attached Thumbnails Attached Thumbnails Click image for larger version. 

Name:	AgeFactors.jpg 
Views:	294 
Size:	25.3 KB 
ID:	10912  

  5. #5
    Participating Member scales's Avatar
    Join Date
    Aug 2016
    Location
    Kentucky
    Posts
    12

    Re: 2017 Masters Motivational Times

    Thank you! I've looked at your 2016 times so much ever since I started swimming. This is such a useful thing you provide.

  6. #6
    Very Active Member orca1946's Avatar
    Join Date
    Jan 2006
    Location
    schaumburg, il - U S A
    Posts
    6,962

    Re: 2017 Masters Motivational Times

    OK I can make or better 9 of those times. Good for 70 1/2 Others I need to work on. Thanx

  7. #7
    Very Active Member SwimDogs's Avatar
    Join Date
    Dec 2009
    Location
    Polson, MT
    Posts
    255
    Blog Entries
    18

    Re: 2017 Masters Motivational Times

    Very cool, Swimosaur!

    As you mentioned, "close is close enough."

    As the host of the USMS Postal Swimtathlon League, I was trying to find a way to compare all the age groups and have an age-graded CHAMPION.

    On a related note, do you have any thoughts on how to compare and adjust for gender as well? Certainly, if I used Stevenson's model, I could come up with a point system comparison, but there is too much data entry...I need something I can load into a spreadsheet.

    Thanks!

    Mark

  8. #8
    Very Active Member Swimosaur's Avatar
    Join Date
    Jul 2009
    Location
    Knoxville, TN
    Posts
    654

    Re: 2017 Masters Motivational Times

    Quote Originally Posted by SwimDogs View Post
    ... "close is close enough."
    ... trying to find a way to compare all the age groups ...
    ... do you have any thoughts on how to compare and adjust for gender as well?
    Yes, as long as you are happy with "close enough". When do you need it?

  9. #9
    Very Active Member SwimDogs's Avatar
    Join Date
    Dec 2009
    Location
    Polson, MT
    Posts
    255
    Blog Entries
    18

    Re: 2017 Masters Motivational Times

    No hurry at all. It would be great to have something by the end of the month when I would post the early results for the Swimtathlon League.

    Attached is last year's FINAL RESULTS....I have the individual times in a spreadsheet, so if there was a way to add a field with the age and gender "grading," that would be perfect.

    Thanks!
    Attached Files Attached Files

  10. #10
    Very Active Member Chris Stevenson's Avatar
    Join Date
    Jun 2007
    Location
    Richmond, VA
    Posts
    4,134
    Blog Entries
    1217

    Re: 2017 Masters Motivational Times

    Quote Originally Posted by SwimDogs View Post
    Very cool, Swimosaur!

    As you mentioned, "close is close enough."

    As the host of the USMS Postal Swimtathlon League, I was trying to find a way to compare all the age groups and have an age-graded CHAMPION.

    On a related note, do you have any thoughts on how to compare and adjust for gender as well? Certainly, if I used Stevenson's model, I could come up with a point system comparison, but there is too much data entry...I need something I can load into a spreadsheet.

    Thanks!

    Mark
    I have it in spreadsheet form, if you want to PM me with your email address I'll send it to you.
    These opinions are mine mine mine and not USMS'.

  11. #11
    Participating Member
    Join Date
    Aug 2016
    Location
    Duluth, Minnesota
    Posts
    2

    Re: 2017 Masters Motivational Times

    I am new to this. How does one use motivational times?

  12. #12
    Very Active Member arthur's Avatar
    Join Date
    Nov 2009
    Location
    Vancouver
    Posts
    354

    Re: 2017 Masters Motivational Times

    Quote Originally Posted by timothynt View Post
    I am new to this. How does one use motivational times?
    In age group swimming it is used to qualify for meets but for masters it is just for fun to see how you compare to others in you age group.

  13. #13
    Participating Member
    Join Date
    Aug 2016
    Location
    Duluth, Minnesota
    Posts
    2

    Re: 2017 Masters Motivational Times

    Can we add a few more letters then so I can actually get a motivational time level?

Similar Threads

  1. 2015 Masters Motivational Times
    By Swimosaur in forum General Swimming-Related Discussions
    Replies: 37
    Last Post: January 14th, 2017, 08:02 PM
  2. 2016 Masters Motivational Times
    By Swimosaur in forum General Swimming-Related Discussions
    Replies: 14
    Last Post: September 9th, 2016, 01:17 AM
  3. 2014 Masters Motivational Times
    By Swimosaur in forum General Swimming-Related Discussions
    Replies: 20
    Last Post: September 5th, 2014, 08:10 PM
  4. Masters Motivational Times
    By sjstuart in forum General Swimming-Related Discussions
    Replies: 172
    Last Post: April 10th, 2014, 12:10 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •