AthleteMonitoring use a powerful mathematical library that includes many functions that you can use to calculate test results. To add a function in a formula, simply type it's name in the Formula box. For example, to create a ratio that always returns an absolute number, you can use the 'abs' function like this : abs(((abdr/addr)-1)*100)
abdr= symbol associated with first measure
addr= symbol associated with second measure
Function | Explanation |
abs | Absolute value |
acos | Arc cosine -- output in radians. |
acosh | Inverse hyperbolic cosine -- output in radians. |
asin | Arc sine -- output in radians. |
asinh | Inverse hyperbolic sine.-- output in radians. |
atan2 | Arc tangent of two variables -- pass in two values like (y, x), and you'll get the atan(y/x), adjusted to the proper quadrant. (Note: The variables are in the reverse order to atan2(x,y) in Excel) Output is radians. |
atan | Arc tangent -- output in radians. |
atanh | Inverse hyperbolic tangent-- output in radians. |
bindec | Binary to decimal |
ceil | Round fractions up |
cos | Cosine -- in radians!!! Convert your degree measurement to radians before you take the cos of it. |
cosh | Hyperbolic cosine -- in radians!!! Convert your degree measurement to radians before you take the cosh of it. |
decbin | Decimal to binary |
decoct | Decimal to octal |
deg2rad | Converts the number in degrees to the radian equivalent |
exp | Calculates the exponent of e |
expm1 | Returns exp(number) - 1, computed in a way that is accurate even when the value of number is close to zero |
floor | Round fractions down |
fmod | Returns the floating-point modulus of two numbers - i.e. the remainder when the first is divided by the second. |
is_finite | Finds whether a value is a legal finite number |
log10 | Base-10 logarithm |
log1p | Returns log(1 + number), computed in a way that is accurate even when the value of number is close to zero |
log | |
Natural logarithm (ln) | |
max | Find highest value |
min | Find lowest value |
octdec | Octal to decimal |
pi() | Get value of pi - the function does not take an argument, like in Excel. |
pow (numberToRaise, NumberRaisedTo) | |
power (numberToRaise, NumberRaisedTo) | Exponential expression |
rad2deg | Converts the radian number to the equivalent number in degrees |
rand | Generate a random integer |
rand_int | Generate a random integer |
rand_float | Generate a random float |
round | Rounds a float |
sin | Sine -- in radians!!! Convert your degree measurement to radians before you take the sin of it. |
sinh | Hyperbolic sine -- in radians!!! Convert your degree measurement to radians before you take the sinh of it. |
sqrt | Square root |
tan | Tangent -- in radians!!! Convert your degree measurement to radians before you take the tan of it. |
tanh | Hyperbolic tangent -- in radians!!! Convert your degree measurement to radians before you take the tanh of it. |