Sports Coach - Excel Calculators

This page provides links to all the available "Microsoft Excel" calculators located on the Sports Coach website. A link to the calculator's associated website page is also provided.

Calculators

Assessment Tests

Calculator	Function	Associated Page
400m Control	Assessment of 400m speed, endurance and strength - based on 150m, 300m and 600m times	Page
400m drop off	Assessment of sprint endurance - based on 100m & 400m times	Page
Combined Events	Assessment of the number of points achieved in the Combined Events - based on the 2001 IAAF scoring tables for senior athletes.	Page
Harvard Step	Assessment of an athlete's cardiovascular system - based Harvard step test	Page
Jumps Decathlon	Assessment of endurance and elastic strength - based on the jumps decathlon test	Page
McCloy	Assessment of physical fitness - based on the McCloy physical fitness test	Page
Orthostatic	Assessment of training status (over training) - based on resting heart rate before and after standing up	Page
Quadrathlon	Assessment of all round fitness - based on the Quadrathlon test	Page
RAST	Assessment of power and fatigue - based on the Running-based Anaerobic Sprint Test (RAST )	Page
Ruler Drop	Reaction Time test	Page
Ten Stride	Assessment of sprint acceleration phase - based on distance and time for the 1st 10 strides from a standing start	Page
WANT	Assessment of power and fatigue - based on the Wingate ANaerobic 30 cycle Test (WANT)	Page

Predictors

Calculator	Function	Associated page
60m, 100m & 200m times	Prediction of 60m, 100m and 200m times - based on a 30m time from a standing start	Page
60m, 100m & 200m times	Prediction of 60m, 100m and 200m times - based on a flying 30m time	Page
60m, 100m & 200m times	Prediction of 60m, 100m and 200m times - based on a 40 yard time	Page
100m, 200m, 400m & 800m times	Prediction of 100m, 200m, 400m and 800m times - based on a time for any of these distances	Page
400m time	Prediction of 400m time and 100m splits - based on 100m time	Page
100m times	Prediction of 100m time - based on 150m time	Page
150m times	Prediction of 150m time - based on target 100m time	Page
200m times	Prediction of 200m time - based on 250m time	Page
250m times	Prediction of 250m time - based on target 200m time	Page
800m & 1500m times	Prediction of 800m & 1500m time - based on the Kosmin test	Page
5k time	Prediction of 5k time - based on four 1600m runs	Page
Anaerobic Threshold	Prediction of Anaerobic Threshold - based on the Conconi Test	Page
Body Mass Indicator (BMI)	Prediction of BMI - based on height, weight and gender	Page
Calorie requirements	Prediction of daily calorie requirements - based on weight and hours of training	Page
Conconi AT Calculator	Prediction of your Anaerobic Threshold using conconi protocol	Page
Conconi test pace	Prediction of speed to run at when conducting the conconi test on the track or on a treadmill - based on 10km time	Page
Energy Expenditure	Calculation of energy expenditure (calories) based on exercise, duration and weight	Page
HRM Zones	Prediction of Heart Rate Monitor training zones - based on age and resting heart rate	Page
Hurdles Touchdown Times	Predicts each hurdle touchdown time for the ladies 100m Hurdles and mens 110m Hurdles based on a required target time for the event	Page
Ideal Weight	Prediction of ideal weight - based on height and gender	Page
Long Jump Analysis	Analysis of runway speed based on long jump distance	Page
Load to Reps	Prediction of the number of reps to failure in weight training - based on the % of maximum load	Page
Max Load	Prediction of maximum load in weight training - based on a weight and number of reps to failure (RM)	Page
%VO2 max to %MHR	Prediction of required %MHR in training - based on required %VO2 max	Page
PWC-170	Prediction of power output (watts) at a projected heart rate of 170 beats per minute (bpm) - based on two consecutive six minute bicycle ergometer rides	Page
Race Time	Prediction of the time for a distance - based on the known time for another distance	Page
RDEE	Prediction of your Resting Daily Energy Expenditure (RDEE)	Page
Sprint block settings	Prediction of front and rear block settings - based on specific body measurement	Page
Stride Length	Prediction of running stride length - based on height	Page
Talent Evaluation	To assist coaches recognise the potential of young athletes and predict their performance in selected track and field events	Page
VO2 max	Prediction of VO2 max - based on a race result	Page
VO2 max	Prediction of VO2 max - based on the Astrand treadmill test	Page
VO2 max	Prediction of VO2 max - based on the distance covered in a 15 minute run (Balke Test)	Page
VO2 max	Prediction of VO2 max - based on the Bruce incremental treadmill protocol	Page
VO2 max	Prediction of VO2 max - based on the distance covered in a 12 minute run (Cooper Test)	Page
VO2 max	Prediction of VO2 max - based on the MultiStage Fitness Test	Page
VO2 max	Prediction of VO2 max - based on the Queens College Step test	Page
VO2 max	Prediction of VO2 max - based on the Rockport Fitness Walking Test	Page
VO2 max	Prediction of VO2 max - based on a treadmill test	Page
VO2 max	Prediction of VO2 max - based on a race time	Page
vVO2 max	Prediction of vVO2 max - based on the distance covered in a 6 minute run	Page

Training Programs

Calculator	Function	Associated Page
40yrd Dash	Calculation of time a distance to be run in - based on target 40yrd target time, the training distance and the required training effort	Page
60yrd Dash	Calculation of time a distance to be run in - based on target 60yrd target time, the training distance and the required training effort	Page
5 kilometers	Calculation of time a distance to be run in - based on target 5k target time, the training distance and the required training effort	Page
10 kilometers	Calculation of time a distance to be run in - based on target 10k target time, the training distance and the required training effort	Page
vVO2 max training	Calculation of 30-30, 60-60 and vVO2max training sessions - based on the distance run in 6 minutes	Page
Training program - 20 miles	To build up to 20 miles/week in preparation to undertake a Half Marathon training program	Page
Training program - 40 miles	To build up to 40 miles/week in preparation to undertake a Marathon training program	Page
Training Program - aerobic test	To build up aerobic fitness to complete a running test	Page