View Single Post
Old 10-01-23 | 09:35 PM
  #77  
mschwett
Senior Member
Titanium Club Membership
Community Builder
 
Joined: May 2021
Posts: 3,135
Likes: 2,342
From: San Francisco

Bikes: addict, aethos, creo, vanmoof, sirrus, public ...

Originally Posted by Koyote
…I think that would be virtually impossible to calculate for a ride of any reasonable length, unless there is some software out there with which I'm not familiar. (And no, a spreadsheet would be of no help.)
nah, given the nature of the XML schema for bike rides, you could pretty easily do this. break the tags onto columns, one row per trackpoint, a simple if statement referencing the elevation and distance of the prior and current row gives you the grade between those two points. then another statement discarding that point if the grade is less than some selected percentage. weight the remaining grades by the distance they represent, and there you go. you could make a histogram or averages or whatever you want.
__________________
mschwett is offline  
Reply