Thursday, June 05, 2008

Gradients/Average speeds from Memory Map GPX


Necessity being the mother of invention, in the absence of Powertap from TT last night I knocked up an Excel file that would take GPX output from Memory Map and give some info on ride.
Quite pleased with result as gives some info that both Powertap and Memorymap lack.
Top plot is elevation, second is gradient (something that frustratingly the Etrex does not display while 305s etc do).
Last plot is average speed over time which for last nights ride clearly shows my fast start, decline as head to turn then speeding up on way back.


2 comments:

Marco Meulenbroeks said...

Cool! I am looking for ways to get gradient information from my files created by my treacking software. Could you share some more information of perhaps the excel sheet?

Bahzob said...

Example file is here (its a bit large 3mb, since it records long ride)

http://www.mediafire.com/?sharekey=92d06a3794ffa93a312dbd5f2bdc50623d621b5cb792f51af85d402b9fc3640c

First sheet explains what to do, bit clunky but it works