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

Log: The log(10) of the number is used in one of the skinfold equations

Abs: The absolute value of a number is its unsigned magnitude.

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

1 Comments

Fred

Hey there,
I am just wondering where you got the sum of 8 calculation from ?
and which researchers use/made it, because where I have studied we use this and its very hard to find others who do.
thanks a lot

Add your comment

E-Mail me when someone replies to this comment