HRM software?

[plank]

I have a garmin forerunner 50 with the cycle computer attachment but fine the training software a bit lacking. EG I cant split up sections of data and find averages from that.

Anyone got ideas of better software to use that could help?

 

[Jim_Noir]

Excel

 

[plank]

great idea!!

 

[plank]

hmm actually its quite confusing and reads speed as some kind of pace I dont understand

 

[Jim_Noir]

if you enter the data into excel, then get it to work them out. Can you export from the device to a csv file?

 

[plank]

no it only exports as TCX file which excel reads as a XML table.

I could probably make a macro which refomats it to be read as a CSV :S

example formatting of two track points but still not sure what speed its reading. I think the actual value is around 18mph

<Trackpoint>
<Time>2009-05-25T14:47:45Z</Time>
<DistanceMeters>1085.0000000</DistanceMeters>
<HeartRateBpm xsi:type="HeartRateInBeatsPerMinute_t">
<Value>183</Value>
</HeartRateBpm>
<Cadence>121</Cadence>
<SensorState>Present</SensorState>
<Extensions>
<TPX xmlns="http://www.garmin.com/xmlschemas/ActivityExtension/v2" CadenceSensor="Bike">
<Speed>10.6250000</Speed>
</TPX>
</Extensions>
</Trackpoint>
<Trackpoint>
<Time>2009-05-25T14:47:50Z</Time>
<DistanceMeters>1137.0000000</DistanceMeters>
<HeartRateBpm xsi:type="HeartRateInBeatsPerMinute_t">
<Value>184</Value>
</HeartRateBpm>
<Cadence>121</Cadence>
<SensorState>Present</SensorState>
<Extensions>
<TPX xmlns="http://www.garmin.com/xmlschemas/ActivityExtension/v2" CadenceSensor="Bike">
<Speed>10.9375000</Speed>
</TPX>
</Extensions>
</Trackpoint>

 

[Jim_Noir]

Is this any good?
www.raincitystory.com/wp/2008/01/02/cycling-training-log-spreadsheet/

Can you email me an example file? PM me for email address

 

[bobbyp]

Try sporttracks from Zone Five software. I'm not sure if it does exactly what you want to do but I know it manages everything I want to do. very cheap as well, free.