Estimated reading: 4 minutes

aeroworkbook

Installation and Setup

Download

You can download the AeroWorkbook here:

https://info.aerosensor.tech/docs/start/downloads/excel-tools/

Prerequisites

Windows

Install Java (go to java.com)
Make sure the Fit2CSV.jar file is in same folder as this excel sheet.
You may need to set folder containing this excel as a trusted location:
1. Go to File->Options
2. Go to Trust Center-> Trust Center Settings
3. Go to Trusted Locations on left hand side menu.
4. Click on “Add new location”
5. Click on “Browse” and browse to location of this excel file.
6. Click OK on each window to close them all.
Use the “Check System” button to make sure everything is set up correctly.

Mac

Install Java (go to java.com)
Make sure the Fit2CSV.jar file is in same folder as this excel sheet.
Mac security is a lot different to Windows, so some functions require a script to be installed. The zip file, or folder, you downloaded from Aerosensor’s website has a file called “Aerosensor_Scripts”.

1. Open a new Finder window, and on the top menu click on “Go” then “Go to folder”
2. Type in the following path: ~/Library/Application Scripts/com.microsoft.Excel
3. Copy the “Aerosensor_Scripts.scpt” file into that folder.

Checking your system

After carrying out these steps, use the Check System button on the Control worksheet to check that everything is set up correctly on your computer. You should see something like the following. If there is a red x by any item you should check you have done everything correctly.

Setup

Before you load any data you will need to set the aerotool up depending on the testing you are doing. The settings are all on the Control worksheet.

Basic settings

Valid speed tolerance

All laps where the average speed are within this percentage of the fastest will be marked as valid.

Testing type

Either track or out-back.

Delete raw data

When a FIT file is loaded the raw FIT file data is loaded into worksheets named after each of the 3 data types (record, lap, session). If you want to check the raw data set this field to false. For most purposes you can leave it as true.

Auto calibrate

Aerotool calculates a calibration value for the run. If you want to use this calibration value to correct the final CdA then set to true. If you want to manually set aero calibration then set to false.

Speed units

Select an option from either kph or mph.

Use cloud

Set to true if you want to load data from aeroportal.
Set to false to import locally saved FIT files.

Advanced settings

Most users should not need to modify these values.

Laptime offset

Aerosensor sends lap information through roughly 3 seconds after the lap ended because of the way it has to average lap data. This allows us to align the data so we can for example calculate wind information for the lap.

Max calibration laps

Only used when track testing option selected under basic settings.
In an indoor velodrome you typically start to generate your own tailwind after a few laps. This progressively increases the more laps you do. Since the aero calibration is based on the assumption of zero wind, we only use the first 5 or so laps to calculate the aero calibration.

Show/Hide definitions

This shows or hides the worksheets where the data definitions are stored. For most users this can be ignored.

Show/Hide log

If aerotool crashes you can show the log and send that information to support@aerosensor.tech for technical support.

Operation

Here is just a quick description of these buttons

Load FIT files

Button opens a dialog to load in FIT files, either file based or aeroportal based, depending on Use cloud settings above.

Recalculate

Button recalculates data for all runs currently loaded.

Reset workbook

Deletes all currently loaded run data.

Check system

Checks the system is set up correctly to enable FIT files to be loaded.