Why do we need to move the route database to excel?
1) You need to see all the flights of a particular route in a day
2) You need to see the flights that an aircraft flies in one day
3) You want to see how many aircraft is parked at a specific airport at a given time, so that you can adjust the number of gates you want to rent.
4) Your database is massive, you need to find something by a computer
Now, here is how:
1)Create a new .txt file in your computer, open it with notepad or whatever program that can read the file.
2)Highlight the first row till the last row of the route database, like what I did in New Bitmap Image(2).bmp.
3)Copy them and paste it in the .txt file. You'll see something like New Bitmap Image(3).bmp.
4)Open Excel(I used Excel 2013) and create a blank workbook.
5)Select Data tab and then From Text.(New Bitmap Image(4).bmp)
6)Select the .txt file storage location and then choose delimited in the text Import Wizard Step 1.(New Bitmap Image(5).bmp)
7)Select tab and type ( to the Other option , this can separate the aircraft registration number to a new column.(New Bitmap Image(6).bmp)
8)Click Next and then Finish
9)Click OK in the Import Data window, you'll then get something like this(New Bitmap Image(7).bmp).
10)Highlight the table from the top to the last row.(New Bitmap Image(8).bmp).
11)Click on the DATA tab and then Sort.
12)In the Sort window, select sort by column H, which is the column storing registration numbers.
13)After getting something like this(New Bitmap Image (10).bmp), highlight and clear the contents of the unwanted rows below.
14)If you want to split column A to departure airport and arrival airport, highlight column A, select DATA tab, and then Text to Columns.
15) Choose Delimited in the window Convert Text to Columns Wizard - Step 1 of 3.
16) Step 2 uncheck Tab and check Other, type — to the textbox.
17) Click finish and you should see column A changed. (Remember that column B must be empty if you split column A to two columns)
Enhancement:
Now, my problem is, I have this database in excel, but I want to know if I have enough gates to park the aircraft. To do so, I think I have to plot a graph with bars during the period when each aircraft is staying at a particular airport, but how to do that?
1) You need to see all the flights of a particular route in a day
2) You need to see the flights that an aircraft flies in one day
3) You want to see how many aircraft is parked at a specific airport at a given time, so that you can adjust the number of gates you want to rent.
4) Your database is massive, you need to find something by a computer
Now, here is how:
1)Create a new .txt file in your computer, open it with notepad or whatever program that can read the file.
2)Highlight the first row till the last row of the route database, like what I did in New Bitmap Image(2).bmp.
3)Copy them and paste it in the .txt file. You'll see something like New Bitmap Image(3).bmp.
4)Open Excel(I used Excel 2013) and create a blank workbook.
5)Select Data tab and then From Text.(New Bitmap Image(4).bmp)
6)Select the .txt file storage location and then choose delimited in the text Import Wizard Step 1.(New Bitmap Image(5).bmp)
7)Select tab and type ( to the Other option , this can separate the aircraft registration number to a new column.(New Bitmap Image(6).bmp)
8)Click Next and then Finish
9)Click OK in the Import Data window, you'll then get something like this(New Bitmap Image(7).bmp).
10)Highlight the table from the top to the last row.(New Bitmap Image(8).bmp).
11)Click on the DATA tab and then Sort.
12)In the Sort window, select sort by column H, which is the column storing registration numbers.
13)After getting something like this(New Bitmap Image (10).bmp), highlight and clear the contents of the unwanted rows below.
14)If you want to split column A to departure airport and arrival airport, highlight column A, select DATA tab, and then Text to Columns.
15) Choose Delimited in the window Convert Text to Columns Wizard - Step 1 of 3.
16) Step 2 uncheck Tab and check Other, type — to the textbox.
17) Click finish and you should see column A changed. (Remember that column B must be empty if you split column A to two columns)
Enhancement:
Now, my problem is, I have this database in excel, but I want to know if I have enough gates to park the aircraft. To do so, I think I have to plot a graph with bars during the period when each aircraft is staying at a particular airport, but how to do that?