Aviation and Aerobatics: Tech Tips: Sequence Spreadsheets

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

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.

sequence.xls

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.

catalog.xls

Lists the catalog numbers in catalog order and the K factor for each.

catalogLex.xls

This index lists the catalog numbers in lexical order with the K factor for each.

catalogK.xls

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

• There are 720 separate figures in the Aresti catalog.
• There are 1000 catalog numbers, counting rolls, snaps, and spins.
• The highest K element is the sixteen of eight point roll going vertically up (9.8.1.8). This clocks-in at 33K.
• The highest K figures are 7.38.2 and 7.38.3. These are horizontal eights with outside loops. Their K value is 31.

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.