Airline Mogul Forum

Excel question

iranair777

  • Brokers
  • Airline Senior Manager
  • ****
    • Posts: 2859
    • View Profile
on: May 15, 2008, 09:41:31 pm
I've heard some people use MS Excel to balance their airline. I have a question, How??


Chavaquiah

  • Airline Supervisor
  • **
    • Posts: 698
  • E outra vez conquistaremos a Distância
    • View Profile
    • SkyPact-Concept Alliance
Reply #1 on: May 15, 2008, 09:44:34 pm
What do you mean "balance?"

I use Excel to plan my routes. At the start of the game it's a great way to determine what routes to open without having to hit the Gate Search function all the time.


herrgoda

  • Airline Operative
  • *
    • Posts: 196
    • View Profile
Reply #2 on: May 15, 2008, 09:45:27 pm
I use it to keep track of my network. Hubs in columns, airports served in rows, and fill the fields with the equipment used. But that's about all Excel can do for me...
img]http://www.herrgoda.de/shack/logo.jpg[/img]
W4 - 11377


Steeler83

  • Airline Operative
  • *
    • Posts: 415
    • View Profile
Reply #3 on: May 15, 2008, 09:47:04 pm
Hmm, that's a heck of a way to sharpen my skills with excell and perhaps MS Access at that... :idea:
teeler83
Founder and CEO of Buon Giorno! Airlines


iranair777

  • Brokers
  • Airline Senior Manager
  • ****
    • Posts: 2859
    • View Profile
Reply #4 on: May 15, 2008, 09:47:17 pm
Quote from: "mg35pt"
What do you mean "balance?"



Everything really, from aircraft deliveries to routes


Chavaquiah

  • Airline Supervisor
  • **
    • Posts: 698
  • E outra vez conquistaremos a Distância
    • View Profile
    • SkyPact-Concept Alliance
Reply #5 on: May 15, 2008, 10:06:49 pm
For routes I have one sheet for each hub with all possible routes (as copied from GateSearch). Then I take note of the aircraft ID on each route. Since I have another sheet with my fleet (and info on range, speed and turn time of each plane), a couple of formulas are enough to know exactly how much time each plane flies and, more importantly, how far it can still go.

By using filters I can locate very rapidly suitable routes.

One simple trick is to use colour coding (with conditional formatting) to have adequate destinations stand out from the croud.

For deliveries and such I have a very simple planner (yet another spreadsheet) where, for each (game) day, I have the indication of the real time, projected cash and, of course, where I make note of planned deliveries.


Pacific

  • Airline Supervisor
  • **
    • Posts: 598
    • View Profile
Reply #6 on: May 15, 2008, 11:07:58 pm
I'm absolutely useless at programming so don't use Excel.  I used to use it to sort the aircraft list which is 100% copy/paste compatible with Excel until the developers added the sort function to find the best aircraft(s) for my network.

Gate search results are not compatible to be pasted into Excel (unless you have brains but I don't :D ).  I use the rather mundane method of invading country by country, with the aid of google maps.

I simply guesstimate how many more of a certain aircraft I need as I reach the limit of the aircraft's capability.


db07mufan

  • Airline Operative
  • *
    • Posts: 27
    • View Profile
Reply #7 on: May 16, 2008, 04:56:44 am
How do you guys copy paste the airports from GATESEARCH and put it into EXCEL in an orderly manner. It will be useful imagine putting that and sorting according to pax, distance to your liking!

Any help?


Shawa

  • Airline Operative
  • *
    • Posts: 421
  • Worldair Alliance
    • View Profile
    • Worldair Alliance
Reply #8 on: May 16, 2008, 02:24:51 pm
highlight the list, type ctrl-c, go to your spreadsheet type ctrl-v

here you are...

Alouette Aviation - Österreichische Wetterstrecken - Blå Løve Luftveje - Imperskiye Nebesa


db07mufan

  • Airline Operative
  • *
    • Posts: 27
    • View Profile
Reply #9 on: May 17, 2008, 03:53:28 am
for me mine all crams into one cell!

Any idea how to make it into seperate cells?


Cheung Airlines

  • Brokers
  • Airline Supervisor
  • **
    • Posts: 932
    • View Profile
Reply #10 on: May 17, 2008, 05:43:32 am
Highlight some of the cells before pasting it.

My ID: |||||||||  - ||||||||||||||||
             A M ID:  1  02 5   2    (0)


 

SMF spam blocked by CleanTalk