# Calculations: Some useful basic calculations

To give you additional information on common calculations see the steps below:

## Minimimum (min) Calculates the minimum value

e.g. min(Sprint 1, Sprint 2, Sprint 3)

min(1.2, Sprint 1)

## Maximum (max) Calculate the maximum value

max(Sprint 1, Sprint 2, Sprint 3)

max(1.2, Sprint 1)

## Sum sums the values

sum(Sprint 1, Sprint 2, Sprint 3)

sum(1.2, Sprint 1)

## If/Then equation: If takes a true/false value (non-zero or zero), and one or two other values. If the condition is true (non-zero), the first value is  returned, else the second value is (or zero if it doesn't exist).

For "Calculation" types:

if( 5 < 6, 100, 10) = 100

if( 5 > 6, 100, 10) = 10

For "Option Calculation" types:

if( mean(Sprint 1, Sprint 2, Sprint 3) < min(Sprint 1, Sprint 2, Sprint 3) / 0.95, 'Pass', 'Fail')

## Safe: Useful for when a calculation involves a number, but the number is not always entered. Since a calculation like max can only work on numbers, safe will provide either the number, or 0.

Examples: safe(45) = 45. safe(a) = 0 (assuming a is not a number).

## Mulitstage shuttle Test: Total Shuttles using Level and Shuttle

if (Level < 2, Shuttle, if (Level < 4,  7+(Level-2)*8+Shuttle, if (Level < 6,  23+(Level-4)*9+Shuttle, if (Level < 8,  41+(Level-6)*10+Shuttle, if (Level < 11, 61+(Level-8)*11+Shuttle, if (Level < 13, 94+(Level-11)*12+Shuttle, if (Level < 16, 118+(Level-13)*13+Shuttle, if (Level < 18, 157+(Level-16)*14+Shuttle, if (Level < 20, 185+(Level-18)*15+Shuttle, 215+(Level-20)*16+Shuttle)))))))))

## Mulitstage shuttle Test: Distance and VO2

Distance = Total Shuttles * 20

Vo2=0.0165 * Distance + 18.945

## YoYo Level 1R: Distance

if (Level <9, 40, if (Level <11, 80, if (Level = 11, 80 +(40 * Shuttle), if (Level = 12, 160 +(40* Shuttle), if (Level = 13, 280 +(40 * Shuttle), if (Level = 14, 440 +(40 * Shuttle), if (Level = 15, 760 +(40 * Shuttle), if (Level = 16, 1080 +(40 * Shuttle), if (Level = 17, 1400 +(40 * Shuttle), if (Level = 18, 1720 +(40 * Shuttle), if (Level = 19, 2040 +(40 * Shuttle), if (Level = 20, 2360 +(40 * Shuttle), if (Level = 21, 2680 +(40 * Shuttle), if (Level = 22, 3000 +(40 * Shuttle), if (Level = 23, 3320 +(40 * Shuttle))))))))))))))))

## YoYo Level 1R: Vo2

V02= (Distance * 0.0084 + 36.4)

## MOD Phosphase Decrement: Effort Rating

Most Recent 35m time /  (min(Trial 1 , Trial 2 , Trial 3 , Trial 4 ,Trial 5 , Trial 6, Trial 7 ,

Trial 8)) * 100

## MOD Phosphase Decrement: Fatigue

Most Recent 35m time /  (mean(Trial 1 , Trial 2 , Trial 3 , Trial 4 ,Trial 5 , Trial 6, Trial 7 ,

Trial 8) * 100

## MOD Phosphase Decrement: Fatigue as % Peak

100*((max(Trial 1 , Trial 2 , Trial 3 ,

Trial 4 ,Trial 5 , Trial 6, Trial 7 ,

Trial 8)-Peak)/max(Trial 1 , Trial 2 , Trial 3 ,

Trial 4 ,Trial 5 , Trial 6, Trial 7 ,

Trial 8))

## Injury Availability- using the fields Date Injury Resolved (Date Field), Did this injury render the player unfit to practice fully or to be unavailable to play? (Yes/No) Return Date (Date Field)

if(isempty (Date Injury Resolved), if(Did this injury render the player unfit to practice fully or to be unavailable to play?="Yes", if (isempty (Return Date),"Injured-Unavailable",

"Injured-Available"), "Injured-Available"),"Available")

## 1RM Prediction using the following fields in a table: Exercise ("database and Is a group") Reps, Weight

(100 * Weight)/(101.3-(2.7123 * Reps))

## Anthropometry 8 Sites: Tricep + Bicep + Subscapular + Iliac Crest + Abdominal + Supraspinale + Front Thigh + Medial Calf)

sum(Tricep + Bicep + Subscapular + Iliac Crest + Abdominal + Supraspinale + Front Thigh + Medial Calf)

## Anthro 8 sites: % body fat, FFM and

% Body Fat: If (Sum of 8 Skinfolds > 0, (495 /(1.0988-(0.0004 * (Sum of 8 Skinfolds - Suprailiac))))-450, 0)

Fat Free Mass:  Weight - ((Weight *Percentage Body Fat)/100)

Fat Mass: Weight - Fat Free Mass