UPDATE from 4.7 to 4.7.2

Have made corrections to the workbook and the 'Get My Aircraft Titles' programs.

This excel 2003 workbook started out as a simple spreadsheet to quickly make AI traffic using Peter Van Der Veen's Traffic Compiler.

This program is based on his compiler and the three need text  files;

AIRPORTS (included with this download), AIRCRAFT (obtainded by using included programs), and

FLIGHTPLANS (created using the make flightplans workbook sheet)

It has been an on-going project, and has become a useful tool not only for creating AI traffic, but as a source for aircraft and airport data.

I have filled in missing information on airports, added the data from the airport dump list and created an aircraft type list for the needed

info in the aircraft.txt file.

The Make Flightplans page sheet can be used simply as an information tool such as, distance between airports,

airport name and location, flight times,  or to create your own aircraft traffic bgl files.

The whole concept of this workbook is to quickly create airport traffic. After entering defaults, the only data needed

is the aircraft number and a list of the airports the aircraft will fly to.

I have included the original (only minor changes) FSX traffic bgl file with the de-compiled text files.

What I have done to mine is to replace the original aircraft in the aircraft text file with similar AI aircraft I have downloaded.

I then compiled it to a bgl file and used it instead of the original file. ( Located in  \scenery\world\scenery folder)

I then use my excel AI flightplan maker to add aircraft traffic to the airports I fly to most often and /or airports

with a very small amount of traffic.

I've also included a program to extract YOUR Aircraft Speed, Titles and vertical default rates.

This then can be used to update the aircraft sheet in the workbook. The aircraft sheet has MY aircraft

titles. You'll need to update that data with YOUR titles. (see the 'Get_MY_Aircraft_Titles' folder)

I have not verified this workbook on any other versions of excel. I would appreciate any comments and

suggestions for improving or making corrections to this project.

Be sure and read ALL of the comments on the workbook pages. They will explain the process in more detail.

Email me at       gary@fsx4u.com

Video Tutorial at    http://www.fsx4u.com/downloads_main.htm

Thanks, and have a good flight !