Airline Mogul Forum

Airline Mogul => General Chat => Topic started by: Ekta Airlines on June 23, 2008, 01:37:26 am

Title: Routes with Excel
Post by: Ekta Airlines on June 23, 2008, 01:37:26 am

can some one explain how to make a route sheet with excel.....

Title: Re: Routes with Excel
Post by: Zero-G on June 23, 2008, 03:17:58 am

LOL, I was trying to do that the other day, but with hundreds of data entrys in the us alone I gave up... I didnt feel like looking up all the distinces from my hubs...  I decided it would be easier to learn my geography!

Quote from: "Ekta Airlines"

can some one explain how to make a route sheet with excel.....

Title: Routes with Excel
Post by: karnc on June 23, 2008, 03:50:44 am

I thought just copy and paste is enough.
Anyway, when paste, use paste special instead of just paste.... select unicode then.



for Distance wise, make some extra column and use =value(substitute(xxx,"NM","")) . Voila!, it is now distance in number variable type. Otherwise, sorting a text string cell would return order of 9xx nm after 8xxx nm.

Title: Routes with Excel
Post by: zkvac on June 23, 2008, 08:21:20 am

I think this is one area you have to figure out yourself, as the way to be the best at AM (apart from having stupid amounts of spare time) is to make these route planners.

Title: Routes with Excel
Post by: SkinnyRabbit on June 23, 2008, 02:40:42 pm

View this topic http://stephenm.org/forum/viewtopic.php?t=6810

Especially bottom of page 1 and all of pages 2 and 3.

Title: Routes with Excel
Post by: TDA on June 23, 2008, 03:15:40 pm

you can also make a circle around your departure with the maximum range your aircraft can handle, make a whole list of airports just in range, and inside that you can buy.

Title: Routes with Excel
Post by: iranair777 on June 24, 2008, 02:44:31 pm

only way to do this properly is to start at the beginning when you join a world

Title: Routes with Excel
Post by: SkinnyRabbit on June 24, 2008, 02:46:13 pm

I hear ya to that Iran.