Reading a CSV Export File
From MB Wiki
Also known as an MS Excel file, reading one of these files can make one cross eyed if you don't know for what it is you're looking. It's viewed best when downloaded from a Digest in Firefox (browser). Whether you're looking at an exported file from Firefox or Internet Explorer, the most confusing piece of data will be the figure for "Total Time".
In the example above, Total Time is exported to Excel the way it was originally collected - in seconds. The easiest way to convert to hours:minutes is to divide the time in seconds by 3600 (60 x 60 (seconds in a minute) x (minutes in an hour)). Focusing at the Activity labeled "GGP 6" (below) 2894/3600 = .80389 of an hour, which equates to approximately 48 minutes. (.25 = 15 minutes, .50 = 30 minutes, .75 = 45 minutes.)
The rest of the fields read exactly as they are in the Dashboard:
- Activity
- Start Date (day/month/year)
- Activity Type
- Location
- Event Type
- Total Time(hours:minutes:seconds)
- Total Distance
- Total Elev Gain(feet)
- Total Elev Loss(feet)
- Average Speed(miles per hour)
- Average Pace(minute:second)
