Route Profiles

big_h

Hi Guys<br /><br />With all the newfangled heart rate monitors and especially the Polar S710 can we not start a library that shows route profiles. It would be of great benefit for us intrepid cyclists. We would be able to compare routes and determine some sort of difficultness.<br /><br />Keep em spinning<br /><br />Big H

Vo2

Big_H, you mean route profiles downloaded from a HRM like the S710 or just images like this?<br /><br />

__________________
Pain is inevitable...suffering is optional

big_h

VO 2 <br /><br />Any profile will do. The one shown above was most likely created by using a S710. There are just too many bumps on the M2 that does not suit the geometry of a freeway. It will be quite a task generating a longsection like this form a 1:50 000 or similar. Even with a GIS it will be difficult. Most of the big races provide a route profile but the smaller ones like the Rooiwal, Bronkies, Queens, Wonderpark etc and other have nothing. When you have a good day it is difficult to determine whether you were a star or the route was good for you. <br /><br />Keep em spinning!!!<br /><br />Big H

rek

The only problem with using an S710 for a profile graph is that the PPP software graphs altitude over time, and not altitude over distance.<br /><br />You'd need to do a bit of extra fudging of the raw altitude/speed/time data in Excel or something to come up with a true profile curve.

__________________
Peter
Cannondale Synapse Carbon Scalpel Cyclocross Ultra

big_h

Yes that makes it a bit more complex. I will have to butter up my GIS contacts and find out what can be done. Any other suggestions out there. Somebody with a GPS perhaps?????<br /><br />Keep em spinning<br /><br />Big H

rek

big_h,<br /><br />it takes a little bit of effort, but it's definitely not difficult to convert altitude/time to altitude/distance when you have the speed information (as speed = distance over time).. it just requires a little bit of spreadsheet trickery, that's all.<br /><br />If I have a slow point at work next week I might have a play around in Excel and see what I can come up with ;D

__________________
Peter
Cannondale Synapse Carbon Scalpel Cyclocross Ultra

2LAP

I'd like a copy of that!

__________________
www.cyclingforums.com

rek

hmm, it's MUCH easier than I thought ;D<br /><br />Here's the profile of my ride to work:<br /><br /><br /><br />and the original altitude/time graph from the Polar software:<br /><br /><br /><br />I like the profile graph more, it makes the hills look bigger!

__________________
Peter
Cannondale Synapse Carbon Scalpel Cyclocross Ultra

rek

Oh yeah .. how to do it:<br /><br />

• <br />
• open your exercise chart in Polar Precision Performance and select the raw data listing view<br />
• select 'copy' from the Edit menu.<br />
• open Excel to a blank workbook and paste. you should have a heap of columns with your time/HR/speed/cadence/altitude<br />
• start a new column &amp;quot;Distance&amp;quot; or some such. the FIRST entry on this should be =&amp;lt;first speed data cell&amp;gt;/720<br />
• the second entry should be =&amp;lt;first distance data cell&amp;gt;+(&amp;lt;second speed data cell&amp;gt;/720)<br />
• use the fill-down tool to fill up the rest of the column's cells to the end of the data. the very last distance data item should match up with what the Polar software reports the cycling distance as being.<br />
• select the graph toolbar thingy and set up a smoothed X-Y scatter graph. The distance column should be your X axis, and the altitude column the Y axis.<br />
• mess about with the appearance to your liking and enjoy<br />

<br /><br />Here is the XLS spreadsheet I used to make the quick graph above: http://yallara.cs.rmit.edu.au/~tilm...emp/profile.xls<br /><br />BTW the '720' is assuming you are using the 5-second sample rate (the significance of the number is that 1 sample per 5 seconds is 720 samples per hour; what the calculation is doing is changing &amp;quot;kilometres per hour&amp;quot; to &amp;quot;kilometres per sample time&amp;quot;.)<br />

__________________
Peter
Cannondale Synapse Carbon Scalpel Cyclocross Ultra

Old Timer

Rek<br />Fascinating, well done. ;D<br />Now how do I save the exercise profile chart in Polar Precision Performance to a file that I can send to someone to display in the way that you have done? ???

__________________
&quot;How can I soar with the eagles when I'm surrounded by a bunch of turkeys?!.&quot;

big_h

Rek<br /><br />What you did is exactly what I had in mind when I wrote the email, one thing though.... we need to employ the help of VO2 or Steve oe somebody to create a space where these charts can be stored. Wonder if that is possible. Another thing, the scales (hor and Vert) will have to be constantly the same to enable one to compare apples with apples. Wonder if that is possible.<br /><br />Keep em spinning<br /><br />Big H

admin

[quote author=big_h link=board=6;threadid=2516;start=0#21748 date=1035142432]<br />Rek<br /><br />What you did is exactly what I had in mind when I wrote the email, one thing though.... we need to employ the help of VO2 or Steve oe somebody to create a space where these charts can be stored. Wonder if that is possible. Another thing, the scales (hor and Vert) will have to be constantly the same to enable one to compare apples with apples. Wonder if that is possible.<br /><br />Keep em spinning<br /><br />Big H<br />[/quote]<br /><br />You can just use the attach feature when you posting a message (it works now)<br /><br />cheers!

rek

[quote author=Old Timer link=board=6;threadid=2516;start=0#21747 date=1035133512]<br />Rek<br />Fascinating, well done. ;D<br />Now how do I save the exercise profile chart in Polar Precision Performance to a file that I can send to someone to display in the way that you have done? ???<br />[/quote]<br />Instead of pasting the raw data into Excel, paste into a text file in Notepad or something -- and send that off. It'll be a tab-delimited text file, which Excel can import quite easily.

__________________
Peter
Cannondale Synapse Carbon Scalpel Cyclocross Ultra

Old Timer

Rek<br />Sorry. I meant I wanted to save and send the actual Polar profile chart.

__________________
&quot;How can I soar with the eagles when I'm surrounded by a bunch of turkeys?!.&quot;