Disclaimer: Not affiliated with the US Government or the Air Force
Calculates Air Force Fitness Assessment scores for ROTC. The fitness assessment consists of push-ups, sit-ups, and a 1.5 mile run. This program will read in a .csv file.
The format for the .csv file used for program input is below:
Cadet Name (Last, First), Gender, Age, Push-Up Rep, Sit-Up Rep, Run Time, Altitude
So an example would be:
"Smith, Joe", M, 20, 56, 60, 9:30, 4
The format for the .csv file used for program output is below:
Cadet Name (Last, First), Gender, Age, Push-Up Rep, Sit-Up Rep, Run Time, Altitude, Run Time Adjusted, Push-Up Score, Sit-Up Score, Run Score, Total Score
So an example would be:
"Smith, Joe", M, 20, 56, 60, 9:30, 4, 17.8, 20, 60, 97.8
The link here is a google sheet template!
- Make a copy of the template and fill it out
- After filling out the google sheet download it as a .csv file
The limitations (for now) are below:
- Only calculates males and females up to 34 years old.
- Only accounts for push-ups, sit-ups, and the 1.5 mile run.