The flights that are circled in the picture were not flying.
B-6918 completed the SIN-PEK trip and was ready at 18:53, then it should depart at 19:30 to CSX, but no it didn't. This then caused the CSX-PEK flight at 22:44 to be skipped.
B-6822 completed the round trip PEK to CSX to PEK and was ready at 13:04, it should then depart to CSX at 13:40, but no it didn't. Same, maybe because the previous flight to CSX was skipped, the CSX-PEK at 17:00 was neglected.
Other flights worked fine. This implies that if I don't make multiple stops, an aircraft can have one round trip per day at most?
success timetable AE.xlsx (Size: 9.63 KB / Downloads: 6)
success timetable AE.xlsx (Size: 9.63 KB / Downloads: 6)
success timetable AE.xlsx (Size: 9.63 KB / Downloads: 6)
As I showed before, you are able to put data to excel from the route database. Now, I will attach two excel files to manage gates. Open success timetable AE.xlsx, you'll see column A to F have data. Overwrite the data there with yours, then press Sort in DATA tab. In the Sort window, you should set Sort by (Column F), Then by (Column D), so that all rows related to the same aircraft are packed together, and are arranged in order based on time.
Press I2 cell, change the formula: =IF(ISNUMBER(SEARCH("— PEK",$A2)),$D2,IF(AND(ISNUMBER(SEARCH("PEK —",$A2)),$F2<>$F1),2/24,"")),
Change PEK to the airport you want to take a look at. Apply the new formula to the whole column.
Copy the result of column I and J, you must copy them by value only. Sort them based on column I, and copy the result to column B and C of AirlineEnterprise_gantt_chart.xlsx, zoom out and you can see the whole day with red bars indicating there is an aircraft parking at the airport at that time.
Note that if an aircraft arrives at an airport at the airport and leaves the next day, it is split to two rows. For example, an aircraft lands at 22:00 and leaves at 7:00 on the next day, instead of 22:00-7:00, the system splits it to 22:00-2:00 and 2:00-7:00.
(this chart is the ideal case. In fact, my airline has pilots who always forgot to work , so aircraft stays in an airport in unexpected time. To get enough gates, you'd better lease more than what the excel chart shows.
I want to recreate BA1 the british airways that operates between London City and New York using a Airbus 318. On the outbound journey it stops at Shannon , ireland as it cannot take off on LCY's short runway with a full load of for JFK. However on the return it flies direct fro JFK to LCY. It seems that the route is just slightly too long for the a318 but if it is possible in real life surely i should be able to do this in game
I think the game is very easy to play and we should make it a bit more difficult. For example, large aircraft should not be leased to airlines that have just started operations. I mean the size and cost of leased aircraft should be proportional to the age of the airline's founding.
In addition, very old aircraft such as the DC-8-73 produce a lot of money and it is a junk plane.
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?
As you guys know right now there are two ways to fly your aircraft in-game: quick flights, and by scheduling routes. The problem with this in the back-end is that the two systems require separate processing systems as the way they work is inherently different, i.e. the code that is used for the route system cannot be used for quick flights and vice versa. This means whenever I make a change to anything, I have to change it in two places to ensure that both systems are updated and using the same formulas and logic. As more things get added to the game this gets increasingly difficult to maintain.
Once I get the new route creation system up and running, I will probably change the quick flight system into a simple aircraft transfer function, meaning in order to fly routes and generate income you will need to schedule routes. Quick flights could still be used to transfer your aircraft, for example after you purchase off the used market or if you need to re-position something for a route, but actual scheduled flights with passengers will only be possible through the route system.
Being born in the 80s has it's perks and that is one gets to experience hair metal, testosterone-loaded action flicks, and good ole' coin munching videogames.
What are your favorites?
Currently playing this rather obscure game known as Top Ranking Stars which is a Street Fighter 2 style boxing game, complete with special moves and fireworks.
"Unk, when are you going to implement used aircraft leasing?" "Leasing off the used market would be really nice..." "He said he'd do it 2 months ago... when is used aircraft leasing coming?"
Ah, yes. The long-awaited feature has finally arrived. BEHOLD! Used aircraft leasing. So ya'll can stop asking me now pls
Airlines are now able to lease aircraft from the used aircraft market. For now, this only works with aircraft generated by the system. Players cannot lease aircraft to another player at this time. Additionally, all used aircraft are leased for 1 year by default. Eventually you will be able to select lease terms when leasing used aircraft, but that functionality does not exist yet.
Used aircraft leases are delivered instantly, and there is no initial downpayment.
Instead of showing a list of airlines in the game, is it better to show the rankings calculated based on reputation AND % of income? I personally don't like to rank airlines based on amount of money they earn, as this is unfair to newcomers.
, so aircraft stays in an airport in unexpected time. To get enough gates, you'd better lease more than what the excel chart shows.
