Our AeroWorkbook is a macro-enabled Microsoft Excel workbook that enables easy analysis of FIT files generated with the Aerosensor ACS Garmin Connect IQ app.
Its main features are as follows:
Download FIT files from the our AeroPortal cloud server.
Import FIT file data.
Correct parameters.
Add descriptions and notes to each run.
Select valid laps.
Calculate out-back, lap and run averaged data.
Display histograms showing wind variation.
Quick start
For those in a rush, here is a brief overview of how to use AeroWorkbook:
Make sure you have java installed and the FIT2CSV.jar file installed in the same folder as the AeroWorkbook.
Click on Load FIT files on the Control This loads either from a local directory or the cloud, depending on whether or not you have Use cloud set to True or not. You can load more than one fit file at once.
Files are each loaded into separate tabs in the AeroWorkbook.
On each run tab, select Valid laps by adding or removing an X in the appropriate column. Laps with an X next to them are the laps that will be used for the run calculation.
If required, you can change the values of the parameters used for calculation.
Either click Recalculate Sheet on that sheet, or click Recalculate on the Control worksheet to recalculate all runs.