Basecamp gpxx:Subclass

Hi

I use Basecamp to collate data and plan hiking & off road trips. The final planning is done in Excel which

requires that I transfer the times and distances from the Basecamp route properties window to the Excel model.

As you can imagine - it's a pita. I've created a utility to read and summarize Basecamp exported gpx files and

extract the required data (Route, From, To, Distance). The information values can mostly be extracted from the gpxx:Subclass.

I'm having difficulty with the Time. I'm currently doing a generic calculation based upon the RoadType, PointCount, 

AvePointDist & Node Action which is pretty accurate but I'd prefer the model to mirror the result of the Basecamp calculation.

I think part of the Speed is stored in byte 13 (offset 12) - Ideally the total time can also be extracted from the SubClass.

Any ideas ?