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 the 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 measurements. | 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 the time a distance to be run in - based on 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 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 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 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 for undertaking 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 |