|IGC Filename Decoding|
Maybe you have wondered about the file names of the IGC log files that are generated by your flight recorder. For example, "15KC3WK1.IGC". It looks like a strange random combination of letters and numbers, but each character does have a meaning. In the example above it means, "1st Flight on May 20th, 2011* using a Cambridge flight recorder serial number 3WK". Simple? Not so much.
Here is what each digit means in the IGC filename;
To ease the decoding of the convoluted IGC file name, I created a "simple" spreadsheet to decode these file names and as a teaching aid so that after a while you can figure the dates yourself just by looking at them. You might find this useful if you are sorting through a bunch of old log files.
WARNING: I suggest that you do not rename your IGC files. There have been reports of renamed IGC files causing scoring problems at contests and for badges. If you want to keep a renamed file, only rename a copy of the original, and keep the original "pristine".
*NOTE: Due to limitations of the IGC file naming standard (DOS 8.3) and the IGC standard only one character is available to represent the year**). Therefore, flights during years ending in the same digit will be listed in the spreadsheet as occurring in the closest year within the current decade.
For example, the years 1994, 2004 and 2014 all have the same trailing digit ("4"). Therefore, flights during those years will all have the same first "Y" digit in the IGC filename ("4"). Because the spreadsheet cannot tell the difference, all flights will indicate a flight year of 2014.
The actual date and time of the flight is shown within the text of the IGC log file (so you can't cheat!). Sorry folks, but there is no way around this in my spreadsheet without reading the contents of the file, which Excel cannot directly do (if you know how, let me know).
See the table below for date examples to help illustrate this issue;
Please see this spreadsheet for IGC file decoding and more details.
Other information can be found at the International Air Sports Federation (FAI) Gliding (IGC) web site.
Free tools to view IGC files:
** Due to the limitations of the old DOS 8.3 file naming convention, the IGC filename uses only one character to represent the day, month and flight number. Values below 10 are easy and are represented by the logical characters 1 to 9. However, values of 10 to 35 are represented by the characters A to Z.
For example, if the day of the month is the "5th", this is represented by a "5". Easy. But the "11th" is above 9 so it is represented by the letter "B". Say the month is December (12th month). This is represented by the letter "C". More than 9 flights in a day? Got you covered but only up to 35 flights ("Z"). Let me know if you had 35 flights in one day - that has to be a record of some sort!
The alignment of the single IGC filename characters to their true meanings are shown in the table below and in the spreadsheet.