A macro-driven Excel template for determining the anaerobic capacity using an air-braked ergometer

This paper describes a microcomputer system for automating the process of data collection, calculation and display of anaerobic capacity tests on an air-braked ergometer. The use of the spreadsheet Excel and associated 'Dalog' program represents an advance on current software which estimates the anaerobic capacity from work performed alone. Numerous calculations are required when air-braked, rather than friction-braked ergometers are used. Each 1 s power output collected during an all-out sprint on the ergometer is corrected against the criterion of a dynamic calibration rig and adjusted for differences in barometric pressure, ambient temperature and humidity. The Excel template features a series of macros invoked by buttons imbedded in the spreadsheet. Their selection displays various dialogue boxes which request input related to the calculation of oxygen deficit and related variables. Selecting the final macro prints a summary table and charts which include: power output, fatigue index, mechanical work performed, % aerobic contribution to work, oxygen demand, oxygen consumption and anaerobic capacity as determined by the maximal accumulated oxygen deficit.