Aviation and Aerobatics: Tech Tips: Sequence Spreadsheets

This tip provides several Microsoft ExcelTM spreadsheets to assist with checking and designing aerobatic sequences.

screen shot of sequence.xls

The core spreadsheet, sequence.xls automatically enters K value given a catalog number, tracks per figure and overall total K, and highlights duplicate catalog numbers. It has three columns, enabling development of up to three sequences side-by-side for comparison and experimentation.

The screen shot shows a corner of the spreadsheet with some catalog numbers in place. This is the first part of the 2006 Intermediate Known. Row 10 introduces a duplicate catalog number in the sequence. The "dup" column shows the row of the duplicated number.

Only the catalog numbers in the white cells were typed manually. The spreadsheet computes all of the figures in the blue cells. Leave one or more blank cells to delimit figures.

There are three other spreadsheets here that contain indexes of K factors. Following is a list of all four spreadsheets with links to open or download them.

allows you to enter Aresti catalog numbers. It automatically fills-in the K-factor, keeps total K for the figure, and total K for the sequence.
Lists the catalog numbers in catalog order and the K factor for each.
This index lists the catalog numbers in lexical order with the K factor for each.
You may find this useful if you're looking for a figure with a particular K value. It lists the catalog numbers in order of increasing K value.

Some Aresti Factoids

Send any suggestions or corrections to the address listed at wbreeze.com.

Note: These spreadsheets were updated on July 23, 2006. The versions posted prior to that were missing figures 8.65.x to 8.72.x.