Jump to content

Daytona Mylaps questions

Recommended Posts

This was the first race that we have ran with our own transponder, so this is the first race I could login to Mylaps and see all the results.

And I am not sure about somethings.

First thing I have a question about is, why do positions 94 thru 121 not have any times? Were they entered and didn't show up to race? Didn't care, so they didn't rent a transponder?

Second, is there a way I can download my laptimes into excel, with out just cutting and pasting them off the web page?

Link to comment
Share on other sites

Cut & paste from webpage works great.

Yep, that's always how I do it. Make sure you do "Paste Special..." and then choose either text or unicode text. That's how you get Excel to divide it up into cells for you instead of putting everything in one cell at the beginning of each line.

(Another issue is, if you're trying to do any sort of data analysis on lap times, the actual lap time gets turned into a date/time by Excel, but as hours:minutes rather than minutes:seconds. There's a trick you can use to address this: the "average speed" that MyLaps reports is obtained by dividing the recorded lap length by the lap time. Hence, you can recover the lap time by dividing the recorded lap length [the x.x miles in parentheses after the track name on either the results page or the laptime page on MyLaps] by the average speed and then multiplying by 3600 to convert from hours to seconds.)

Link to comment
Share on other sites

Guest posnova

Also, you can choose "format cell" and "custom" and in the box you can type in, you can put m:ss.000 to turn those weird numbers back into lap times formatted.


Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...