Garmin Edge 705 question

[Sittingduck]

I try not to go North of the river unless I really have to - it's like the Wild West up there

 

[Aperitif]

Do you lads from the Smoke ever meet at The Ace cafe on the N Circ'?

My friend Mick the plumber has a Deuce, and goes to the Ace now and again. It's free for five or more...

Brighton run

 

[dodgy]

Now change the .tcx extension to .xml

Accept the warning.

On a MS Excell spreadsheet, import the .xml file.

Now you can play with it till dawn.

You will have to delete all columns of junk up to AltitudeMeters.
Insert a column after DistanceMeters and do a little subtraction to get the Delta Distances.
Insert a column after Time and do the same subtraction to get Delta Time.
Then in a free column, write a little equation to calculate Velocity m/s.

Do the translation into kmh or mph.
Insert another column for Delta ElevationMeters.
Using Delta DistanceMeters, calculate the gradient.

Now you can plot a chart of speed vs gradient


There are other routines you can do to analyse your performance that Garmin Training Center sadly lacks.

Set your alarm for midnight and get some rest for tomorrow

I've seen you post this on other threads on here, the thread usually quickly dies as I suspect other people aren't as skilled with Excel as you appear to be

As for the steps:

1. Rename the .tcx file to .xml Done
2. Import to Excel done!
3. Calculate delta distances done!
4. Calculate delta time nope, no idea
5. write a little equation to calculate Velocity m/s huh!
6. Do the translation into kmh or mph (probably easy)
7. Delta elevation meters (probably easy)
8. Haven't got this far....

Can you provide muppet instructions as I think this might be worth me understanding it. Though the high score plugin for sporttracks makes all this a bit easier, it doesn't claim to work out your crusing average, just your best 1, 5, 10 (whatever) miles speed in a given ride(s).

Cheers!

 

[jimboalee]

"Delta" is the increment ( or decrement ) between adjoining datapoints.

Delta time is latest time minus the previous time, in the same way Delta distance is calced.

You have Delta distance (m) and Delta time (s). m/s

kmh = m/s x 3.6.

mph = kmh / 1.609

Delta elevation is the minus thing on the Elevation column of datapoints.


When you've got a column of Delta mph, in the next column, enter

=IF('delta mph'<8," ",'delta mph')
where 'delta mph' is the cell address for the datapoint.

This filters out all the speed datapoints that are less that 8 mph.
At the top of that column, enter

=AVERAGE( n:nx )
Where n is the first datapoint and nx is row 64000.

This gives you an average of riding speeds over 8 mph. ie Cruising.

 

[dodgy]

Thanks Jumbo, I'm familiar with 'delta', I couldn't work out how to calculate the delta of time, a simple sum function doesn't work on my version of Excel (2007).