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. |
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article