How do I write formulas for calculated tests?

  • Updated

You can write any formula with these signs:

  • + for Plus
  • - for Minus
  • * for Multiplication
  • / for Division
  • ( or ) for Parenthesis
  • Math.pow(variable/number, power)
    For example: Math.pow(b; 0.67) when your want b^0,67
  • Math.Log(variable/number) for natural logarithm (base e)
    For logarithms of base 10 you just need to divide a natural logarithm by logarithm base 10 like this: Math.Log(x) / Math.Log(10)
  • as well as the variables you get from adding other tests. Variables will be letters going from "a", "b" and so forth.
  • and one special variable YY or yy which represents "age"

If you're in need of more complex formulas, such as logarithmic calculations, square roots or something similar, please contact us at support@sidelinesports.com  


This is how we would setup a calculated test showing BMI using two other tests (weight and height):

BMI.png


This is how we would setup a calculated test showing a a 100m sprint result in km/h instead of seconds:

Speed_in_100m_sprint__km_h_.png

 

Here's an example using both Math.pow and Math.Log(x). Let's say we want to be able to calculate the Sinclair score for an athlete in Olympic Weightlifting. Here's the formula (for men) to calculate the Sinclair coefficient: 10^(0.722762521 * (LOG10(Bodyweight / 193.609))^2)

So we need to use both Math.pow for the power (^) and also Math.Log(bw) / Math.Log(10) for the LOG10(bw)

Notice we're dividing here the natural logarithm Math.Log(x) by Math.Log(10) to get the logarithm of base 10.

Then we use this coefficient to multiply with the actual weight lifted. So our formula would be something like this:

Sinclair for men

[TOTAL]*Math.pow(10;0.722762521*(Math.pow(Math.Log([BODYWEIGHT]/193.609)/Math.Log(10);2)))

Like this (where we use variable "a" for the weight)

sinclair-for-men-xps.png

which gives the result we wish for when compared to the web:
sinclair-for-men-web.png