analysis
How can I export my diary
24/08/08 12:04 Filed in: Diary
Problem: While Trailrunner already has some statistical graphs built in, you sometimes still want to create your own graphs like e.g "calories burnt per kilometer".
Solution: Select the diary entries in TrailRunner and use Edit > Copy to paste the data into an external spreadsheet application like NeoOffice or Excel. To select all etries in TrailRunner, use Command-A.
Tip: If you import your data into NeoOffice, follow these step to make NeoOffice use one column for each diary column.
Copy the diary entries
Open NeoOffice and select a new spreadsheet.
Press Command-P to paste the history in.
In the popup that appears, verify the Separator options - the settings should be “separated by tab".
Solution: Select the diary entries in TrailRunner and use Edit > Copy to paste the data into an external spreadsheet application like NeoOffice or Excel. To select all etries in TrailRunner, use Command-A.
Tip: If you import your data into NeoOffice, follow these step to make NeoOffice use one column for each diary column.
Copy the diary entries
Open NeoOffice and select a new spreadsheet.
Press Command-P to paste the history in.
In the popup that appears, verify the Separator options - the settings should be “separated by tab".
|
What's the resolution of the workout data graph?
10/08/08 10:20 Filed in: Import
Problem: When I view my workout data in other applications like garmin training center, the data points for heart-rate and speed are much more noisy detailed than in TrailRunner. Additionally the TrailRunner graph seems not to start at the left edge of the chart but appears to be indented. Furthernore a TrailRunner graph line sometimes is being drawn as a straight line without any intermediate data points, although there should be some.
Background: Other applications display the raw data of a device. This makes the graph unreadable. The philosophy of TrailRunner instead is to display the overall trend and development of your workout session.
Approach: TrailRunner has an auto split feature where the workout is being sliced into fixed distance intervals. For each interval the statistical median value is being calculated and one data point reflecting this value is then being used as a representative. As the location of the representative can be somewhere in-between the first interval, the graph might appear to be indented. Furthermore if representatives in adjacent intervals fall onto a straight line, only the edges representatives are being drawn and the connection line depicts the trend development.
Details: The auto split feature uses the following distance intervals. By the time of this writing it’s 250 m for workouts shorter than 10 km, then 500m up to 20 km, 1000 m up to 50 km and 10000 m from there on. A route with 42 km would then have 5 intervals.
Background: Other applications display the raw data of a device. This makes the graph unreadable. The philosophy of TrailRunner instead is to display the overall trend and development of your workout session.
Approach: TrailRunner has an auto split feature where the workout is being sliced into fixed distance intervals. For each interval the statistical median value is being calculated and one data point reflecting this value is then being used as a representative. As the location of the representative can be somewhere in-between the first interval, the graph might appear to be indented. Furthermore if representatives in adjacent intervals fall onto a straight line, only the edges representatives are being drawn and the connection line depicts the trend development.
Details: The auto split feature uses the following distance intervals. By the time of this writing it’s 250 m for workouts shorter than 10 km, then 500m up to 20 km, 1000 m up to 50 km and 10000 m from there on. A route with 42 km would then have 5 intervals.