FAI/IGC/CAI File Name Decoding - Automated!!

Hi John,
thank you for the decode spread sheet.
In case you are looking for improvements, I do have a suggestion.
You could re-implement the code as a Windows system patch that would
display the information while the mouse cursor hoovers over the an IGC
filename in file lister programs such as Windows Explorer.
Bela

For those without Excel installed, there is an Excel "viewer" available
at http://www.microsoft.com/office/000/viewers.asp.

This allows you to view and use an Excel spreadsheet without owning the
full version.

Please see some background information about this thread in the topic
"IGC File Name Decoding Made Easy".

Enjoy, John
johnatderosaweb.com

In the "IGC File Name Decoding Made Easy" it was mentioned about the EW
Avionics recorders (and other recorders) which take a long base10
serial number and convert it to base36 (0-9, a-z) to fit in the file
name format.

"Cambridge, Garrecht (Volkslogger), Zander all use the external serial.
Filser,LX,Colibri,PrintTechnik convert external serial directly to
base36" - Peter Wyld

Peter also comments that depending on the Model of EW recorder, they
take the serial number on the case and add 2000 (B models) or 9000(D
models). A models stay the same. Whew.

From a post by Martin Gregorie I see the following example for an EW
model D

The A line from a trace: AEWAD0430 99429850
The serial number on the case: D0430
The serial number in a filename: 79Y

Taking D0430 and adding 9000 per Peter Wyld's post, I get a base10
serial number of 9430.

Taking 79Y and converting it to Base10.

79Y = 7x36x36 + 9x36 + 34 = 9430. Hey, it works.

All I need now is to get Excel to do the math in reverse and deal with
the add 2000 or 9000 to the SN. I'll report back.

Enjoy, John
johnatderosaweb.com

I noticed in Peter Wyld's comments: "Cambridge, Garrecht (Volkslogger),
Zander all use the external serial.
Filser, LX, Colibri, PrintTechnik convert external serial directly to
base36"

Two models are not mentioned in the CAI document dealing with
manufacturer file name encoding.

Zander
PrintTechnik

Does anyone have one of these recorders and could share with me an
example filename so I can figure out what the missing information is?

Thanks, John

X-no-archive: yes
In article .com,
ContestID67 writes
In the "IGC File Name Decoding Made Easy" it was mentioned about the EW
Avionics recorders (and other recorders) which take a long base10
serial number and convert it to base36 (0-9, a-z) to fit in the file
name format.

"Cambridge, Garrecht (Volkslogger), Zander all use the external serial.
Filser,LX,Colibri,PrintTechnik convert external serial directly to
base36" - Peter Wyld

Peter also comments that depending on the Model of EW recorder, they
take the serial number on the case and add 2000 (B models) or 9000(D
models). A models stay the same. Whew.

What about the Model C? I don't think there were many of these, but I
believe there were some.


From a post by Martin Gregorie I see the following example for an EW
model D

The A line from a trace: AEWAD0430 99429850
The serial number on the case: D0430
The serial number in a filename: 79Y

Taking D0430 and adding 9000 per Peter Wyld's post, I get a base10
serial number of 9430.

Taking 79Y and converting it to Base10.

79Y = 7x36x36 + 9x36 + 34 = 9430. Hey, it works.

All I need now is to get Excel to do the math in reverse and deal with
the add 2000 or 9000 to the SN. I'll report back.

Enjoy, John
johnatderosaweb.com

The problem with deciding to decode Base-36 or Base-10 according to the
manufacturer code is that while a specific manufacturer may use Base-10
now, any future recorder models will not get approval for Base 10 serial
numbers, they will need to use Base-36.

For instance, Legacy Cambridge models use base-10, but 302 uses base-36.

I would therefore urge you to display both the Base-36 and the Base-10
serial numbers as it is not possible to determine the model from the
filename (if you ignore EW).

Tim Newport-Peace

"Indecision is the Key to Flexibility."