Calculated Fields

by camel

Downloads: 23,628 (9) • Reviews: 4

Version:

1.2.9.4

Updated:

Apr 11, 2011

2016-09 Do you want to know your final sprint measurements?

2016-09 Do you want to know your final sprint measurements?

Postby AlexMTB » Fri Sep 09, 2016 4:29 am

Do you sprint with your last energy at the end of races? Do you want to know your measurements as speed and heart rate average at the final sprint in your races?

I think this is interesting, especially in Running activities. Here is my way:

1 - Create a Virtual Field called LastSegmentRaceStart. Use this expression in this Virtual Field:

Math.Round({DISTANCE}-200.0)

Note: You can change the size of the segment what you want, in this example the segment is 200 meters.

2 - Create two new Custom Fields:

'Speed Final Sprint' numeric field with one decimal.
'BPM Final Sprint' numeric field with zero decimals.

3 - Use the next expressions over the previous Custom Fields created:

'Speed Final Sprint'
Expression: {RANGESPEED(Distance,{LastSegmentRaceStart},{DISTANCE})}

'BPM Final Sprint'
Expression: {RANGEHR(Distance,{LastSegmentRaceStart},{DISTANCE})}

Enjoy!
Last edited by AlexMTB on Fri Sep 16, 2016 4:34 am, edited 1 time in total.
AlexMTB
 
Posts: 32
Joined: Mon Sep 07, 2015 6:22 am

Re: 2016-09 Do you want to know your final sprint measuremen

Postby Keeby » Thu Sep 15, 2016 6:06 pm

Thanks for the formula, it works great, most of the time. I am encountering the following error message on some runs though. Any ideas what the problem may be?
This screenshot was from a treadmill run, but other treadmill runs have calculated correctly.

screenshot.jpg
screenshot.jpg (31.94 KiB) Viewed 2399 times
Keeby
Donated!
Donated!
 
Posts: 26
Joined: Thu Apr 29, 2010 6:55 am
Location: Nottinghamshire, UK

Re: 2016-09 Do you want to know your final sprint measuremen

Postby AlexMTB » Fri Sep 16, 2016 4:38 am

Your right, there was an error in the Virtual Field, I have updated it. The problem was in:

Math.Round({DISTANCE}-200,0)

the desired size of the last segment must be with a dot and not a coma:

Math.Round({DISTANCE}-200.0)

Try and tell me.
AlexMTB
 
Posts: 32
Joined: Mon Sep 07, 2015 6:22 am

Re: 2016-09 Do you want to know your final sprint measuremen

Postby Keeby » Fri Sep 16, 2016 7:10 am

It only affected about 5% of my runs over the past 2 years, but that seems to have resolved the problem.
Thanks for the formula and the speedy reply.

Keith
Keeby
Donated!
Donated!
 
Posts: 26
Joined: Thu Apr 29, 2010 6:55 am
Location: Nottinghamshire, UK


Return to Calculated Fields

Who is online

Users browsing this forum: No registered users and 1 guest