|
|
Two table views perform the main role in various analyses of past and planned flight operations: the Evaluation view and the Calculation Results view.
The Evaluation view gathers several items in rows representing legs as single flight operations. The attributes of legs are represented by a large number of columns. These columns offer information on various physical (flight number, aircraft type, registration, date and time, airports, block time, passengers, cargo, distance, fuel consumption) or evaluated aspects of operation (airport service costs, fuel costs, navigation costs, income by passengers, cargo, etc).
While physical quantities are already present in the system, the evaluated values can be derived only on the basis of appropriate price lists that have to be constantly maintained to reflect an up-to-date situation. These price lists can be entered in several currencies, therefore a constantly updated exchange list is extremely important, too. Fortunately, the system integrates automated connection and downloading of current exchange lists on a daily basis.
The evaluated items in the table can be sorted by a single or a combination of columns, deleted or grouped into new selections. These selections will later represent the input for the calculations.
Calculation Results
The results of calculations are inserted into the Calculation Results table where they can be analyzed and compared.
The content of both tables can be saved into text files to be reloaded when necessary. Selected items can be copied to other applications, most often spreadsheets, where data can be processed further.
Filter Wizard
The calculations are generated on the basis of selections that are carried out by a special Wizard tool. This tool offers the user the possibility to describe the characteristics of the required selections in a series of consecutive dialogs.
The dialogs have been carefully designed to make this process easier. The user has to confirm certain options, choose among offered items or select them from the lists and indicate the logical relations between various conditions.
After the user defines target period of the selection, type of data (planned or actual) and target fleet, the main filter can be created. In this process the user will, for instance, decide whether to include all departure countries or narrow them to a selection from the list. The same goes for arrival countries and the user then repeats the procedure for departure and arrival airports that will further refine the selection. In the next step the user will perhaps limit his selection to certain aircraft types or registrations, flight numbers, markets or scheduled flights only. He or she can even specify a day-of-the-week mask and use it as a filter.
Filter Rules
In this manner the user creates his own rules that will act like filters when applied to the selection process.
These rules can either act as 'ad-hoc' filters and be used one time only or they can be saved under a meaningful name to be used again later after being simply selected from a list.
Saved filters can also be used in combinations which gives the user a valuable opportunity to perform several comprehensive analyses with very little effort.
Some standard combinations have already been built into the system, for instance Batch Evaluation by Market, which performs several evaluations for operations that were operated on certain markets and adds the corresponding subtotals together with final total into the Results table.
Other standard combinations can be prepared according to customer’s specifications.
All these selections and calculations can be used on actual data as well as on planned operations. With this option it is possible to create several variations of planned schedules using different types of fleet while operating on various routes and performing estimated evaluations of costs and revenues. Such comparisons of several alternative strategies can represent important contributions to optimal decisions.
Calculator
Having all data regarding the price lists of various services at different airports in its database it is easy for the application to offer a quick and handy calculation of costs for any route or configuration. The user is thus able to respond to customer's inquiries with qualified tenders and well considered answers.

|
|