Airline Mogul Forum

How to use Excel or Other Spreadsheet Programs

nwadeltaboy

  • Airline Senior Manager
  • ****
    • Posts: 2172
  • AM's official Spammer. Check my post counts.
    • View Profile
on: July 07, 2008, 02:53:30 am
1. Open Excel or Works Spreadsheet.
2. In A1, type 24.
3. In A2, copy and paste this: =A1-2*D2*(C2/E2+F2).
4. Fill that down several rows.
5. In E2, type in the aircrafts speed.
6. Fill that down several rows.
7. IN F2, type in the aircrafts turn time.
8. Fill that down several rows.
9. In B2, type in the airport codes for the route you want. (This isn't necessary, but it helps for organizing.)
10. Research that route in AirlineMogul under "Research Route".
11. In C2, type in the distance of that route.
12. In D2, type in a frequency you want for that route.
13. Voila, it calculated your route time!
14. Repeat steps 9-13 for as many routes as you want. Remember that you can't go negative in column A.

This was done hastily. If anybody sees any mistakes, shout at me and criticize me and do anything else you want to do to make me feel miserable. :P


Ome Henk

  • Airline Operative
  • *
    • Posts: 10
    • View Profile
Reply #1 on: July 07, 2008, 09:17:37 am
To add to previous:

If you want to calculate a route-setup with several new destinations and maximize your hours:

0. Follow nwadeltaboy's steps as read above
1. set row D2 (frequency) to value 1
2. In row A2 paste the formula =A1-2*D2*(C2/E2+F2)
3. In row A3 change A1 to A2 (i.e. tell the formula to look at the previous row)
4. Change subsequent rows accordingly (row A4, formula A3 or even row A99, formula A98)

To leave out a destination delete the value in row D2 for that destination.
Remaining hours will change immediately.

What does this do?
Instead of giving you the amount of time it takes your plane to fly one route this (small) adjustment will give you the remaining time after flying several routes.

Thanks to nwadeltaboy for the original formula and groundbreaking work! :D
URL=http://imageshack.us][/URL]


nwadeltaboy

  • Airline Senior Manager
  • ****
    • Posts: 2172
  • AM's official Spammer. Check my post counts.
    • View Profile
Reply #2 on: July 07, 2008, 10:18:09 am
Quote from: "Ome Henk"
To add to previous:

If you want to calculate a route-setup with several new destinations and maximize your hours:

0. Follow nwadeltaboy's steps as read above
1. set row D2 (frequency) to value 1
2. In row A2 paste the formula =A1-2*D2*(C2/E2+F2)
3. In row A3 change A1 to A2 (i.e. tell the formula to look at the previous row)
4. Change subsequent rows accordingly (row A4, formula A3 or even row A99, formula A98)

To leave out a destination delete the value in row D2 for that destination.
Remaining hours will change immediately.

What does this do?
Instead of giving you the amount of time it takes your plane to fly one route this (small) adjustment will give you the remaining time after flying several routes.

Thanks to nwadeltaboy for the original formula and groundbreaking work! :D

That's what Fill means.  It's basically doing that all in one click. ;)


Ome Henk

  • Airline Operative
  • *
    • Posts: 10
    • View Profile
Reply #3 on: July 07, 2008, 11:14:23 am
Quote from: "nwadeltaboy"

That's what Fill means.  It's basically doing that all in one click. ;)


Oops. :oops:
URL=http://imageshack.us][/URL]


nwadeltaboy

  • Airline Senior Manager
  • ****
    • Posts: 2172
  • AM's official Spammer. Check my post counts.
    • View Profile
Reply #4 on: July 07, 2008, 05:59:50 pm
Quote from: "Ome Henk"
Quote from: "nwadeltaboy"

That's what Fill means.  It's basically doing that all in one click. ;)


Oops. :oops:

Its OK.  There are few people that I have met that know about Fill. :lol:


Lord Voldemort

  • Airline Operative
  • *
    • Posts: 409
    • View Profile
Reply #5 on: July 07, 2008, 06:21:55 pm
Ehh... What exactly does this do?
Nate, you made the AM logo?


nwadeltaboy

  • Airline Senior Manager
  • ****
    • Posts: 2172
  • AM's official Spammer. Check my post counts.
    • View Profile
Reply #6 on: July 07, 2008, 07:16:52 pm
Quote from: "Lord Voldemort"
Ehh... What exactly does this do?
Nate, you made the AM logo?

It helps you plan your routes and use your planes a LOT better.

And no, I did not design the AM logo itself.  But those little yellow plane logos floating around everywhere were either done by me or sla31. :D


Lord Voldemort

  • Airline Operative
  • *
    • Posts: 409
    • View Profile
Reply #7 on: July 07, 2008, 10:11:11 pm
No, but my question was exactly what this does...
Maybe I should actually read the post.


 

SMF spam blocked by CleanTalk