What To Do

Categories

Social Bookmarks

Feeds

  1.  
    squidworthy
    Is it possible to calculate the distance and grade (%) for significant climbs on a ride?
    • CommentAuthorHero!!jeff@mmf
    • CommentTimeJul 27th 2007 edited
     
    jeff@mmf

    Hi Squid-

    Climbing grade is a feature that we certainly have on our radar. The distance for a climb is a good suggestion too. We have a lot of ideas centered around enhancing our elevation features, and I'll be starting a thread on that topic soon. Fundamentally, there are some caveats around elevation data with regards to accuracy, etc., and we'll be talking about this in a bit of detail soon.


    We would like to get the community to help develop these features as well. You may have noticed that in the elevation panel there's a link for downloading a CSV version of your elevation data. This is a file that can be imported into Excel (or any other spreadsheet software).  From there, you can calculate stats however you choose. If you come up with some nifty algorithms we encourage you to share them here with the group, and for possible future integration into the site. We could even do fun things in the future like allowing for user-generated data filters, but that's probably a ways off.

  2.  
    SteveRides

    I cannot imagine the problem here. The spreadsheet calculation is less than fifty characters total for accumulating climb and descent.

    A column: Distance from start(miles) = [provided by route]

    B column:  elevation = [provided by route]

    C column: Increase in elevation = C4 is defined as B4-B3

    D column: accumulated ascent = D4 is defined as =IF(C4>0;C4;0)

    E column: accumulated descent = E4 is defined as =IF(C4<0;-C4;0)

    then add up D and E.

    By the way, I'm entering this note in the middle of this ride from a coffee shop with wireless access as I'm on my way to work ...

    http://www.mapmyride.com/ride/united-states/ma/carlisle/692057930

    Am I missing something?

    Thanks,

    Steve 

  3.  
    SteveRides

    D and E above should have been called incremental ascent/descent. To get the accumulated ones and not need to do the total, you can do this: 

    A column: Distance from start(miles) = [provided by route]

    B column:  elevation = [provided by route]

    C column: Increase in elevation = C4 is defined as B4-B3

    D column: accumulated ascent = D4 is defined as =IF(C4>0;D3+C4;D3)

    E column: accumulated descent = E4 is defined as =IF(C4<0;E3-C4;E3)

    Of course, there are obvious programatic ways to do all this. Also, the total ascent/descent can be updated directly when a point is added, deleted, or moved without needing to recalculate for the whole route.

    Are we having fun yet?  :-) 

    Steve