AirwaySim
Online Airline Management Simulation
Login
Username
Password
 
or login using:
 
My Account
Username:
E-mail:
Edit account
» Achievements
» Logout
Game Credits
Credit balance: 0 Cr
Buy credits
» Credit history
» Credits FAQ

Author Topic: [-] export to csv/xls  (Read 994 times)

Offline jewiden

  • Members
  • Posts: 93
[-] export to csv/xls
« on: February 17, 2009, 08:54:44 AM »
In order to help with scheduling, pricing and maintenance, it would be very handy if both route details (i.e. details of all routes) and aircraft details with maintenance dates could be exported as CSV or XLS files.
As it is now, both of these are unfortunately not the best to keep track of within the game.
« Last Edit: January 04, 2011, 05:05:06 PM by sami »

espen-o

  • Former member
Re: export to csv/xls
« Reply #1 on: February 17, 2009, 08:58:12 AM »
That would be an extremely nice function.

elleana

  • Former member
Re: export to csv/xls
« Reply #2 on: February 18, 2009, 03:29:32 AM »
That would be a fantastic idea. I just spent 2 hours last night exporting (i.e. cut and paste :)) flight information into excel for reference. Life would be a lot simpler if I could just export the data into XLS.

espen-o

  • Former member
Re: export to csv/xls
« Reply #3 on: February 24, 2009, 08:27:53 PM »
Bump! Bump!

urubu

  • Former member
Re: export to csv/xls
« Reply #4 on: February 26, 2009, 01:41:42 AM »
Please, do it if possible!
I spend hours printing and re-entering data to a .xlsx ...

Offline Sundaypilot

  • Members
  • Posts: 498
Re: export to csv/xls
« Reply #5 on: February 26, 2009, 10:05:47 PM »
I would like this export-feature. I already do some fleet management in excel, but it's really too laborous at the moment.

As a quick fix at least all dates should be in same format.
Now there is at least two different formats used in "My Aircraft" view.
In maintenance view: Prev: 15-Jun-96  Next: 15-Jun-97
In financial view: Exp: 9th Jul 97

The first one can be converted to excel-date with datevalue-function.
Second format doesn't work ("th" has to be removed).

It should also keep all the maintenance dates visible, even if the plane is in B- or C-check.
So even if there is a plane in B-check, you could see when the next C-check is.

Offline Sami

  • Administrator
  • Members
  • Posts: 16780
    • AirwaySim - Are you the next Richard Branson?
Re: export to csv/xls
« Reply #6 on: February 28, 2009, 04:03:30 PM »
Instead of making export thingy, I'd concentrate on improving the system so that you do not need to fiddle with Excel ... But for that I need some details and what you are actually using Excel for?

Offline Sundaypilot

  • Members
  • Posts: 498
Re: export to csv/xls
« Reply #7 on: February 28, 2009, 05:45:54 PM »
I think that's wise thing to do. If someone still wants to play with excel, he can copy paste necessary info from developed views in AWS.

I use excel to various fleet management tasks.
If "My aircraft" -table was one long list (without aircraft type groups), it would make some things easier to manage in AWS.

- to find out which planes leasing time is going to end first
  > ordering my aircraft -table by leasing period end date would solve this

- to find out what planes are going to have D-checks in near future
  > similar as above, ordering all planes by their next D-check date.

I also plan long-range schedules in excel. Under 24 hour routes are easy to plan in AWS, but when flights get longer than that, it's easier to do in excel.
Having filtering by aircraft type in "Routes not being flown" would again make this easier in AWS.

Offline jewiden

  • Members
  • Posts: 93
Re: export to csv/xls
« Reply #8 on: February 28, 2009, 10:11:25 PM »
I'm doing pretty much the same as Sundaypilot, with the addition of keeping track of C.

urubu

  • Former member
Re: export to csv/xls
« Reply #9 on: March 02, 2009, 03:06:06 AM »
I use Excel to easily check duplicated routes to be changed to a single route with larger aircraft, the same legs of different routes and their distribution, the prices overview.
I also use Excel to calculate % of demand on route versus % of my offered seats on total seats, and compare with % showed in your pie-charts and the difference shows me if I have to be more or less agressive to compete, route by route individually.


Offline Sundaypilot

  • Members
  • Posts: 498
Re: export to csv/xls
« Reply #10 on: March 02, 2009, 09:48:30 PM »
I'm doing pretty much the same as Sundaypilot, with the addition of keeping track of C.

Well, I do that as well. And also plan how to replace my aging planes with new ones (before D-check, C-check or lease end)
I also use excel to find out when in real time these events happen, so I know when I need to be around.

 

WARNING! This website is not compatible with the old version of Internet Explorer you are using.

If you are using the latest version please turn OFF the compatibility mode.