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. |