Sports Coach Logo Sports Coach Training Principles Fitness Components

            topics

Sports Coach - Excel Calculators

This page 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
Chester Step Assessment of an athlete's cardiovascular system - based on Chester step test 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 (overtraining) - 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
Rugby Wilf Paish Rugby Football Tests Page
Ruler Drop Reaction Time test Page
Ten Stride Assessment of sprint acceleration phase - based on distance and time for the 1st ten 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 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 men's 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 weight and number of reps to failure (RM) Page
%VO2 max to %HRmax Prediction of required %HRmax 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 the 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 in recognising the potential of young athletes and predicting 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 kilometres 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 kilometres 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 vVO2 max 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