Monday, November 4, 2013

Track Your Times

If you're one of those Microsoft Excel gurus, you probably have all your swimmer's times neatly row'd and column'd, sorted and formatted, with the top times highlighted. The rest of us will just have to look them up, old school.  Here's one way ...

After logging on to the DART website, click My Account, then My Meet Results, and all your swimmer's times will appear, most recent on top.  If you have multiple swimmers, use the Member drop down box to select which one to display.


After just a few meets, the list can start getting long and cumbersome ... time to use the Search feature to slice and dice results.  For example: Specify a date range and get times from only that period ... or see only times for a single event by specifying a stroke and distance ... or see your swimmer's top times by setting the Top Times option to "Top 1".

To see how far your swimmers is from qualifying for JOs, use the Time Standards feature and select "[UT] 2013: 2013 AG State".  Doing so, will compare your swimmer's times to the State qualifying times, then display the deltas.  The delta will be highlighted green if your swimmer qualified or orange if they haven't.  Like this ...


Another useful Time Standard is the Motivational time standards option "2013: 2013-16 AG MOT SCY".  It's the first item in the list.  It calculates two deltas, one in green for the highest standard attained, and a second in orange for the next standard not yet attained.  See below ... Tina has an "A" time in her 50 yard freestyle and she needs to drop 0.78 seconds to get an "AA" time.


 Let's see your Excel spreadsheet do that!

No comments:

Post a Comment