O.A.G. timetable

[777jafo]

could someone please give their time to help me..i have a north american 1991 oag timetable....i'd love to make a usair flightplans....how do i tansfer that info in flightplans that you experts make for us to use in fs9...example a flight in the oag is usa/kphl to katl...is that flightplan??...am i suppose to make that flight go back to phl..and sit for the rest of the day and night until the next flight to katl??...any help i would be very grateful..thank you

[peterliddell]

If converting OAG you pretty much have to use the MRAI compiler to figure out for you what planes should route where.

The for example you would build a file structured something like this:

US;1091;PHL;ATL;08:44;11:14;123456;734
US;1092;ATL;PHL;12:20;15:50;123456;734
US;1093;CLT;PHL;08:10;10:20;1234567;D9S
US;1094;CLT;LGA...

And so on, the above is just randomly created... but when you are done MRAI's compiler will figure it all out for you to build the plans.

[fitch]

Apologies, but whats OAG?

[joel21]

If you want to make a ai flightplan of early 90's USair i found a complete timetable on departedflights.com

www.departedflights.com/US120292intro.html

Check that out!

PS: I think it's easier to make a flightplan using Excel and then you save it as a CSV file.

Joel.

[777jafo]

thanks joel, i might have more questions if ya don't mind in the near future.....o..a.g. stands for official airline guide

[777jafo]

joel, do i do the windows excel first or use the mrai compiler first to get started

[klm617]

Yes you put everything in an exel spread sheet then copy and paste into notepad. After that replace the open spaces with semi colons.

[777jafo]

thanks for the reply klm,i'll give that a shot

[777jafo]

klm, joel, or whoever can have some patience with me,..i just do not understand this ..i used joel's example in the early text...for the usair i copied and paste it to notepad and then opened up the mrai and it said bad time...would that aifp installer be more easier to use???

[klm617]

I find this is the best way to do this here is a line of data after you convert it into notepad. It is best to use the 24 hour clock no colon.

RJ;268;DTW;AMM;1745:0500;24;340

Airline,Departure City,Arrival City,Departure time,Arrival time,Days of operation,Aircraft

Send me the data you are trying to convert and I will be able to tell you where the error is. Also I sugest practicing with only a line or 2 of data until you get it down pat. My first plan was Royal Air Inter with only 2 planes until I got a grasp of what was going on as I kept doing larger and larger airlines as my understanding got better. On other thing is there is errors in some of the time zone data for Indian airports which will give you errors up the wazoo.

Keep the questions coming I will help as much as I can

[klm617]

Send me a couple lines of data from the time table you are using and I will type it up how it should look in notepad and you can compare. Remember the total number of flights must match excatley.

[777jafo]

thanks for your time klm,. what i did was use peter's example in the previous post i took that top line us;1091 etc... and put it through this program called microsoft excel starter..which has a graph with letters going across the top and numbers going down...i enter each entry in the individual boxes across,hopefully that's a spreadsheet...then ..i go to the mrai compiler and try to find the what i just did..and it won't let me...listen i don't have a knack for this ..and i'm not embarressed to say that...i am grateful for your time...iv'e used your website for a long time and would love to be able to help out....scott

[klm617]

You have to move everything from the excel spreadsheet and put it in notepad before it will work.