Calculated Fields

by camel

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

Version:

1.2.9.4

Updated:

Apr 11, 2011

Formulas / tags wiki?

Formulas / tags wiki?

Postby blazko » Wed Sep 30, 2015 3:36 am

Hi there,
code.google site looks abandoned and im looking for a wiki where all the features are listed (or at least the basics).
Ive been trying to compute (should be simple) an average hr for a given pace field but cant find any hints on appropriate formula tags.
Sorry if its been already discussed - couldnt find it.
blazko
 
Posts: 20
Joined: Wed Oct 09, 2013 8:02 am

Re: Formulas / tags wiki?

Postby texmurphy » Wed Sep 30, 2015 9:13 am

Some relevant threads are far down the forum.
See perhaps:
Calculated Fields plugin: Gathering features requests
Calculated Fields
texmurphy
Donated!
Donated!
 
Posts: 2125
Joined: Wed Jul 05, 2006 7:38 pm
Location: Maryland, USA

Re: Formulas / tags wiki?

Postby blazko » Wed Sep 30, 2015 9:59 am

Thanks for the links - I already looked into them and couldnt find what I was looking for.

From what I discovered a formula calculating avarage pace at given HR could look like this:

Code: Select all
{RANGEHR(PACE,5:00)}


Thing is, this gives me errors, as (im blind guessing here) a range of paces is needed. Changing the formula to

Code: Select all
{RANGEHR(PACE,"5:00", "5:01")}
wont help as (and im blind guessing again) 5:00 is not a valid argument.

I found out that an alternative

Code: Select all
{RANGEHR(SPEED,12,13)}


works OK, but... I dont want RANGEHR for the whole 1km/h range but only for 12km/h (5:00km/min).

Anyone could help me please?

How do I insert pace to the formula or speed fractions?
blazko
 
Posts: 20
Joined: Wed Oct 09, 2013 8:02 am

Re: Formulas / tags wiki?

Postby dirk66 » Wed Sep 30, 2015 5:07 pm

Hi,

You need something like this: {DATATRACK}.Where(o => o.Pace >= 5 && o.Pace <= 5.5).Average(o => o.HR) which gives you the avg hr when the pace is between 5 and 5,5 minutes /km.

Rightclick on the expression field, go to datatrack and there you see some examples. Just like this one.

fyi This plugin uses c# + linq to achieve the calculations.

Regards,
Dirk
dirk66
Donated!
Donated!
 
Posts: 534
Joined: Thu Feb 26, 2009 6:40 am
Location: Oss, Netherlands

Re: Formulas / tags wiki?

Postby blazko » Thu Oct 01, 2015 1:46 am

No way I would have guessed this expression by myself. THANKS A LOT :D

Should I assume, that 5.5 is actually 5:30 in min/km pace?
blazko
 
Posts: 20
Joined: Wed Oct 09, 2013 8:02 am

Re: Formulas / tags wiki?

Postby dirk66 » Fri Oct 02, 2015 3:44 pm

blazko wrote:Should I assume, that 5.5 is actually 5:30 in min/km pace?

Yes, The search/formula works with numbers not with time.
dirk66
Donated!
Donated!
 
Posts: 534
Joined: Thu Feb 26, 2009 6:40 am
Location: Oss, Netherlands


Return to Calculated Fields

Who is online

Users browsing this forum: No registered users and 1 guest