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

Area of Science:

• Exercise Physiology
• Sports Science
• Biomedical Engineering

Background:

• Current methods for estimating anaerobic capacity from ergometer data have limitations, especially with air-braked systems.
• Air-braked ergometers require complex calculations for accurate power output assessment.
• Existing software often estimates anaerobic capacity based solely on work performed, neglecting crucial physiological variables.

Purpose of the Study:

• To develop and describe an automated microcomputer system for anaerobic capacity testing.
• To enhance the accuracy of anaerobic capacity measurements using air-braked ergometers.
• To provide a comprehensive analysis of physiological variables during maximal exertion.

Main Methods:

• Development of a microcomputer system utilizing Microsoft Excel and a 'Dalog' program.
• Implementation of macros within Excel for automated data processing and user input.
• Correction of 1-second power output data against a dynamic calibration rig.
• Adjustment of power output for barometric pressure, ambient temperature, and humidity.

Main Results:

• The system automates data collection, calculation, and display for anaerobic capacity tests.
• It provides a more accurate estimation of anaerobic capacity compared to methods relying solely on work performed.
• The system generates detailed summary tables and charts, including power output, fatigue index, and oxygen deficit calculations.

Conclusions:

• The described microcomputer system offers an advanced and automated approach to anaerobic capacity testing.
• This system improves the precision of measurements obtained from air-braked ergometers.
• The comprehensive output facilitates a deeper understanding of physiological responses during maximal exercise.