.csv export data not correct
.csv export data not correct
I've tried several times now to export my activity log data to a .csv file for use in Excel and while the data exports, it does not appear to be correct. For example, a pace that shows in my activity log as 12:19 exports as 12.31. An extra column of data titled "elapsed seconds" also appears in the .csv file that does not appear in the activity log. How can I get the data into Excel properly? Thanks!
Re: .csv export data not correct
The data is correct. CSV files have some data that is not formatted. The "Elapsed seconds" column represents the total number of seconds for the activity. It is equivalent to the Elapsed Hours:Mins:Secs column only it is not formatted. The "Elapsed seconds" column was included to allow Map Pedometer users to easily perform calculations such as adding the elapsed time for all activities. It would be more difficult for some users to attempt to add up the times listed in the "Elapsed Hours:Mins:Secs" column since it is already formatted into a text string.
The Pace column is the total number of minutes including fractional minutes. In your case, 12.31 minutes is the same as the formatted string 12:19. The fractional .31 minutes is actually 19 seconds (.31*60=18.6).
You can create a formatted column by inserting a new column. The new column should contain the value of the Pace cell divided by 1440 (number of minutes in a day). Then, format the new column using the custom format: [m].ss
If users let us know that they would like a formatted Pace column added to the export, we can add the feature during a future update.
The Pace column is the total number of minutes including fractional minutes. In your case, 12.31 minutes is the same as the formatted string 12:19. The fractional .31 minutes is actually 19 seconds (.31*60=18.6).
You can create a formatted column by inserting a new column. The new column should contain the value of the Pace cell divided by 1440 (number of minutes in a day). Then, format the new column using the custom format: [m].ss
If users let us know that they would like a formatted Pace column added to the export, we can add the feature during a future update.
kgshepard wrote:I've tried several times now to export my activity log data to a .csv file for use in Excel and while the data exports, it does not appear to be correct. For example, a pace that shows in my activity log as 12:19 exports as 12.31. An extra column of data titled "elapsed seconds" also appears in the .csv file that does not appear in the activity log. How can I get the data into Excel properly? Thanks!
Re: .csv export data not correct
Oh, OK. That makes sense now. I'll try that. That also helps explain why I couldn't get the columns to reformat the way I wanted either. Thanks!