Installation and Setup

Download

You can download the AeroWorkbook here:

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

Prerequisites

Since V1.5.5 the FIT files are loaded directly within the Microsoft Excel macros, so Java is no longer required. Similarly the script files which used to be required on mac are no longer needed!

Since there is no longer anything to check on your system the “Check system” button has also been removed.

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.

Installation and Setup

Download