Moving average spee...
 

Moving average speed over just a portion of a ride?

22 Posts
10 Users
1 Reactions
858 Views
Posts: 41510
Free Member
Topic starter
 

Is there any easy way to find this? 

For example:

I ride to the start of the ride, this involves riding through town, traffic, shared paths, traffic lights, etc.  

Then there's the actual group ride, with punctures.

A stop at the pub

The ride home, with about 5k back in the group on open roads, then back through town.

Other than trimming the ride in strava down to the start of the group ride and returning to town which would shorten it by ~15miles and bruise my ego.  Is there a way to retrospectively interrogate the .gpx and see the average moving speed between two points.  Distance/time doesn't work because there's an unknown amount of puncture repairing and drinking time included in that.  I could use the lap timer function on the garmin, but that has to be done at the time.  Ditto logging it at 3 rides.

I want to track it because otherwise apart form individual segments I can't really track my fitness on rides as once the urban section is included my average speed is far lower than other people on the same ride who live on the other side of town.    

 

 

 
Posted : 14/02/2025 12:33 pm
Posts: 4607
Free Member
 

I want to track it because otherwise apart form individual segments I can't really track my fitness on rides

 

This is a group road ride? Isn't the average speed determined by the fitness (and competence) of the group, rather than your own personal fitness? unless you are also logging time spent taking your pull at the front.

 
Posted : 14/02/2025 12:47 pm
Posts: 12847
Free Member
 

just duplicate, trim then delete it once written down?

 
Posted : 14/02/2025 12:51 pm
Posts: 19970
Full Member
 

Copy / duplicate the ride. Upload to Strava, crop it down to the "actual ride" part of it. Strava will tell you the moving time and total time so if you use the former and manually calculate that average speed then just delete that ride and upload the original. 

You can add a private (or public) comment to the ride if you want to remind yourself that the "actual ride" part was done at x mph average.

The other option is to start the GPS, ride through town to the meeting point, stop and save. Start the "actual ride" part, finish ride, stop and save. Start again for the ride home, stop and save. Then combine the three rides in a program like GPSies to give one overall file which you can upload once you've looked at the average speed for the moving part of the "actual ride". But that requires more effort and remembering to start/stop the GPS... 😉

 
Posted : 14/02/2025 12:59 pm
 PJay
Posts: 4693
Free Member
 

I've never really delved that deeply into what my Edge Explore will do, but for rides you'll have in the future can't you do something like that with Laps?

I think that you either press the Lap button or set one to auto-trigger after a set distance.

I could be completely wrong of course.

I'm not sure what you'd need to do for rides you already have recorded.

 
Posted : 14/02/2025 1:00 pm
Posts: 41510
Free Member
Topic starter
 

This is a group road ride? Isn't the average speed determined by the fitness (and competence) of the group, rather than your own personal fitness? unless you are also logging time spent taking your pull at the front.

Yea, kinda. 

Although without a quantifiable number to start with I can't say "that was 15mph with minimal drafting".  Plus the route includes at least one long hill and a couple of smaller ones so if you take into account the stopping to regroup the average speed of the group can be across a 1.5-2.0mph range.  And that's what I'd like to be able to track.  

So if on the same ride I could in theory be doing 13.5mph and hanging on in the group.  Or 15mph and spending the whole ride on the front.

And then when I know I can do the whole ride off the front at >15mph I can probably jump to a different ride that averages ~17 and go back to sitting in the group clinging on for grim death before repeating the process to 19mph, 21mph groups.

 

 

 
Posted : 14/02/2025 1:05 pm
Posts: 12847
Free Member
 

can't you do something like that with Laps?

pretty sure this will work. But (a quick google reveals) the resulting data will only be visible on Strava via the web, not via mobile (unless, bizarrely, you also have a power meter!) https://communityhub.strava.com/strava-features-chat-5/display-laps-for-cycling-in-the-android-app-7618#:~:text=Laps%20are%20displayed%20on%20the,to%20generate%20a%20Workout%20Analysis.

 
Posted : 14/02/2025 1:09 pm
Posts: 23244
Free Member
 

in the analysis section on strava you can select a section of the activity and it'll zoom in and give you the stats for just that. 

 
Posted : 14/02/2025 1:13 pm
Posts: 12847
Free Member
 

in the analysis section on strava you can select a section of the activity and it'll zoom in and give you the stats for just that. 

 
is that a Premium feature tho or can anyone do it?
 
Posted : 14/02/2025 1:25 pm
Posts: 41510
Free Member
Topic starter
 

in the analysis section on strava you can select a section of the activity and it'll zoom in and give you the stats for just that. 

Hmmmm, sort of, it'll tell me time and distance but doesn't re-calculate the moving average.  So I could do it by subtracting each of the puncture stops at least.

Although looking at the graphs maybe just focusing on times up that one hill is the better option. It's the only notable section of the ride that's clear of junctions, gravel, potholes, hairpins, dips etc to give a meaningful baseline.  And at least it's a regular enough feature on routes that the times for each group are fairly easy to estimate.

[img] [/img]

 

 

 

 
Posted : 14/02/2025 1:33 pm
 PJay
Posts: 4693
Free Member
 

Report
can't you do something like that with Laps?

pretty sure this will work. But (a quick google reveals) the resulting data will only be visible on Strava via the web, not via mobile (unless, bizarrely, you also have a power meter!)

I've no idea I'm afraid, but assuming that the OP is using a Garmin it'll also be up on Connect, presumably that'll offer access to Lap data?

 
Posted : 14/02/2025 1:44 pm
Posts: 8945
Free Member
 

You used to be able to split one recorded activity on Strava into two or three sections.

The default Strava average speed speed in the summary is average moving speed.

 
Posted : 14/02/2025 2:02 pm
Posts: 8449
Full Member
 

For desktop computers there's Golden Cheetah which will do this. You can just select sections of the ride (which can be trimmed etc, and it well remember the selections, and can compare them etc) and see the stats for them. 

 
Posted : 14/02/2025 5:25 pm
Posts: 8449
Full Member
 

Screenshot-from-2025-02-14-16-28-32

 
Posted : 14/02/2025 5:30 pm
Posts: 23244
Free Member
 

It’s almost like you are inventing strava segments….

 
Posted : 14/02/2025 10:26 pm
milan b. reacted
 PJay
Posts: 4693
Free Member
 

Just going back to Laps with a Garmin device, details are viewable in Connect, although unfortunately I've only got rides with a single lap, so they're not a great example.

 

https://1drv.ms/i/c/6adcda47576a022a/IQShVfBBKnQKS5Kyi5Qhp74AAdI6GkcMUi1wBqzgtcqazUo?width=1024

 
Posted : 15/02/2025 11:04 am
Posts: 15116
Free Member
 

If this is just to generally track personal fitness, I'd go for a regular solo ride along a familiar route, the more variables (traffic/weather/elevation/kit/viruses/etc) and riding with groups you lob in the less reliable as an indicator of your general fitness AVG speed really is. That and/or use the lap button for familiar sections of a ride. 

I'd be looking at Avg HR/AVG HR zone alongside average speed, is the trend towards more "bang per beat" or are you just killing yourself over successively harder efforts chasing that one simple metric. 

Also do you do any other forms of training OP? How would you track changing performance in those?

 
Posted : 15/02/2025 12:34 pm
Posts: 41510
Free Member
Topic starter
 

Also do you do any other forms of training OP? How would you track changing performance in those?

I track plenty of other stuff, this is more to keep me honest and riding in the right group. If my average speed nudges up a bit more and I know I'm doing work on the front or working at a low RPE back in the group then it's time to move on.

I use that one hill as my absolute metric for fitness as it's ~30min so hard to do it at anything other than threshold pace, and the group tends to splinter so it's largely solo or riding side by side.

And for gym work I track my deadlift, front squat and power clean+press.

Velodrome is closed this summer for resurfacing the track so that means it'll be evening TT's as well this year.

I don't really have the time (or TBH the self discipline) to go out for a 4 hour solo ride and work hard the whole way. Group riding is just easier mentally this time of year.

It’s almost like you are inventing strava segments….

Doesn't work as the clock then doesn't stop whilst waiting for the group to fix puncture or catch up at the top. I just did an experiment with the lap function on the Garmin and that seems to be the same (but maybe there's a deeper setting to include auto pause I've not found).

For desktop computers there's Golden Cheetah which will do this.

That looks like the solution, thanks!

 
Posted : 15/02/2025 1:27 pm
Posts: 41510
Free Member
Topic starter
 

Also do you do any other forms of training OP? How would you track changing performance in those?

I track plenty of other stuff, this is more to keep me honest and riding in the right group. If my average speed nudges up a bit more and I know I'm doing work on the front or working at a low RPE back in the group then it's time to move on.

I use that one hill as my absolute metric for fitness as it's ~30min so hard to do it at anything other than threshold pace, and the group tends to splinter so it's largely solo or riding side by side.

And for gym work I track my deadlift, front squat and power clean+press.

Velodrome is closed this summer for resurfacing the track so that means it'll be evening TT's as well this year.

I don't really have the time (or TBH the self discipline) to go out for a 4 hour solo ride and work hard the whole way. Group riding is just easier mentally this time of year.

It’s almost like you are inventing strava segments….

Doesn't work as the clock then doesn't stop whilst waiting for the group to fix puncture or catch up at the top. I just did an experiment with the lap function on the Garmin and that seems to be the same (but maybe there's a deeper setting to include auto pause I've not found).

For desktop computers there's Golden Cheetah which will do this.

That looks like the solution, thanks!

 
Posted : 15/02/2025 1:28 pm
Posts: 41510
Free Member
Topic starter
 

Also do you do any other forms of training OP? How would you track changing performance in those?

I track plenty of other stuff, this is more to keep me honest and riding in the right group. If my average speed nudges up a bit more and I know I'm doing work on the front or working at a low RPE back in the group then it's time to move on.

I use that one hill as my absolute metric for fitness as it's ~30min so hard to do it at anything other than threshold pace, and the group tends to splinter so it's largely solo or riding side by side.

And for gym work I track my deadlift, front squat and power clean+press.

Velodrome is closed this summer for resurfacing the track so that means it'll be evening TT's as well this year.

I don't really have the time (or TBH the self discipline) to go out for a 4 hour solo ride and work hard the whole way. Group riding is just easier mentally this time of year.

It’s almost like you are inventing strava segments….

Doesn't work as the clock then doesn't stop whilst waiting for the group to fix puncture or catch up at the top. I just did an experiment with the lap function on the Garmin and that seems to be the same (but maybe there's a deeper setting to include auto pause I've not found).

For desktop computers there's Golden Cheetah which will do this.

That looks like the solution, thanks!

 
Posted : 15/02/2025 3:57 pm
Posts: 320
Free Member
 

If this is a regular ride. Just get a cheap gps watch to record the whole ride and start the bike computer when you get to the start point.

 
Posted : 15/02/2025 9:06 pm
Posts: 15116
Free Member
 

Doesn't work as the clock then doesn't stop whilst waiting for the group to fix puncture or catch up at the top. I just did an experiment with the lap function on the Garmin and that seems to be the same (but maybe there's a deeper setting to include auto pause I've not found).

Pretty sure auto pause is a standard feature across the board and typically fou can set a threshold speed (i.e. pause if below 3 mph for example) specifically for people who want the AVG speed to be 'optimal' and free from junctions and cafe stops.

You could also enable autolap which basically just hits the lap button for you at preset increments, so if for example you were going for a 50 mile ride and had autolap set to 5 miles you'd get 10 laps at the end, that might enable you to sift out the start and end where you're dancing with traffic and maybe focus on a nice flat section in the middle or a part where a big climb has an impact to the metrics. 

Basically it's just rest and measurement, you can chose how you capture the data and you can choose how you later analyse it. I'm still a fan of veloviewer. 

 

 
Posted : 16/02/2025 12:44 pm