Airline Mogul Forum

Routes with Excel

Ekta Airlines

  • Airline Operative
  • *
    • Posts: 20
    • View Profile
on: June 23, 2008, 01:37:26 am
can some one explain how to make a route sheet with excel.....
kta Airlines
"A united step above the rest"
Id:14005 - W8 W9


Zero-G

  • Airline Mogul Staff
  • Airline Operative
  • *****
    • Posts: 214
    • View Profile
Reply #1 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.....


karnc

  • Airline Operative
  • *
    • Posts: 13
    • View Profile
Reply #2 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.


zkvac

  • Airline Supervisor
  • **
    • Posts: 900
    • View Profile
    • granturismoworld.piczo.com
Reply #3 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.
Public World #2119 - VincentAir (Australasia)


SkinnyRabbit

  • Airline Operative
  • *
    • Posts: 475
    • View Profile
Reply #4 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.


TDA

  • Airline Operative
  • *
    • Posts: 48
    • View Profile
Reply #5 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.


iranair777

  • Brokers
  • Airline Senior Manager
  • ****
    • Posts: 2859
    • View Profile
Reply #6 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


SkinnyRabbit

  • Airline Operative
  • *
    • Posts: 475
    • View Profile
Reply #7 on: June 24, 2008, 02:46:13 pm
I hear ya to that Iran.


 

SMF spam blocked by CleanTalk