Journal of Applied Informatics

Editorial Board

Journal archive

For authors

For advertisers

Useful links

Contacts

Authors

< Back to the list of authors

Haritonov S.

Degree	Cand. Sci. (Econ.), Associate Professor, Head of Training Department at InfoWatch JSC, Associate Professor: HSE Tikhonov Moscow Institute of Electronics and Mathematics (MIEM HSE) / Joint Department with InfoWatch, Associate Professor: Plekhanov Russian University of Economics / Basic Department of Digital Economy of the Institute of the Information Society
E-mail	Sergey.Kharitonov@infowatch.com
Location	Moscow
Articles	MS Excel application to the cost evaluation tasks using the method of correlation and regression dependence Despite the existing software systems which allow making the financial calculations while providing assessment services, most practicing appraisers use mostly the MS Excel tools when determining market or other values. The reason for this is convenience and availability of formula editor. The paper considers an example of calculating the market value using the comparative approach to the assessment — a method of correlation-regression dependence in MS Excel environment. Read more... Application hierarchy analysis method to evaluation results harmonization The gradual application of hierarchy analysis method for the evaluation tasks is described. The characteristic and mathematical algorithm method is presented. All calculations and features of the assessment are considered using a through example illustrating each step. Read more... Application of the linear programming to company value management This article discusses the possibility of using MS Excel to solve linear programming problems. The problem is formulated as a problem of business entity value management. This reduces the problem to the maximization of the total cash flow of the company by providing control inputs to the partial cash flows which determine the need and possibility of using this tool. Read more... Allocation and justification of website cost factors using MS Excel This article discusses the possibility of MS Excel tools in conducting regression analysis. In particular, based on the previous article discussed the stages of this analysis, carried out the selection and justification of the cost factors of the website, which were attributed credibility index and age indicator. Read more... Concept of air ticets rates monitoring information system architecture It is shown in the article that the architecture of the information system is primarily determined by the specifics of the current state of the object of research. Practice development and functioning of information systems suggests that the transformation of the object change and methods of its study, therefore, the construction of the processing rules necessary to determine the most likely forecast the state of the object. It is shown that more objective data have the reservation system, so how can on-line to determine the number in the sale of tickets of each type of tariff. Therefore, the presentation layer information system can be based on the appeal to the reservation systems and established by government agencies bets ground service. Layer the business logic of the conceptual architecture of the information system should be data-handling procedures. Including them can make such indicators as the weighted average cost of the air ticket of economic class, the comparison of the weighted average price of air tickets for the flight with the same indicators in a comparable number of passengers and the distance of the internal and external transportation, mapping the dynamics of changes in the weighted average ticket prices, changes in the weighted average price of the air ticket for a flight before and after the arrival of new airlines or after exit from the market competitors. Thus the application architecture, allowing the use of a system based on collecting, storing and processing information simultaneously to multiple Federal agencies with the development of forms of representation data in accordance with the objectives of the authority, allows to significantly reduce the cost of their implementation. Read more... Automation of efficiency estimation of airport infrastructure development Analysis of models for the development of airport infrastructure and ground service of civil aviation of Russia suggests that the most significant indicators of the effectiveness of airport operations from the perspective of a choice of methods of industrial policy, are the levels of fees. Evaluation of the establishment of the cost of ground maintenance indicates that some charges may vary as every few years (for example, the towing fee for take-off and landing), and others several times a month (fees for aviation kerosene). Therefore, the evaluation of the effectiveness of regulation for the development of airport infrastructure must be conducted no less than once a month, if industrial policies should include the creation of a new business model and at least once per year in the case of improving the institutional environment for the implementation of airport activity. Thus, the algorithmic evaluation of the effectiveness of the model for the development of airport infrastructure should include the possibility of permanent (at least once per month) revaluation mapping of airports on the level of charges. Also it is shown that for a more precise definition of change is measured using a multi-dimensional classification is not only based on the totality of data on fees in the Federal airports, but also within individual clusters, while using a wider list of analyzed indicators. Read more... Design of distributed information systems management of air transport route network development The main goal of this article if analyze possibilities of implication of distributed information systems in government regulation multifaceted phenomena, the impact of which can only be done by indirect methods. This is an important field for further research the integration of monitoring systems, algorithmic computational problems in the individual subsystems and their integration. In particular, the necessity of using such systems for the analysis of the impact of instruments of state control development of the route network of regular air transport the analysis of civil aviation activities, the results of which indicated that the directions constituting more than 40% of passenger traffic route network 2007, currently not served. All of this suggests the need to evaluate specific directions from a position in accessibility to the population. Thus, when designing distributed systems, it is necessary not only to identify subtasks research, but also to determine the particular objects of study. As a result of the application of multivariate classification algorithm with training it was revealed that Russian airlines use 4 types of business models in the choice of the route network and only 3 of them can have a substantial impact on the state route network that must be taken into account in the selection of monitoring sites. Read more... System management formation in government regulation of airport network development The article analyzes the approaches to the formation of information system of knowledge management in public administration of this important branch of transport civil aviation. In particular, it is shown that the application of algorithmic elements of knowledge management, including lifecycle management of knowledge — use of existing concepts and the creation of new knowledge, allows to increase the objectivity and transparency when making decisions regarding the regulation of development of the airport network. For example, data analysis of the dynamics of passenger flows using the tools of analysis of principal components and discriminant analysis, and also applications in public administration such concepts as creating an airport network on the basis of a system of airports-hubs shown that existing approaches of choice has a significant limitation. Therefore, the information of a knowledge management system should include information about how theoretical modeling and algorithm data mining tools. Read more... Microsoft Excel application possibilities in modeling risks of investment projects In the planning of investment activity of the individual or company has to deal with the risks. Risk means the possibility of investing planned shortfall of income, because of the influence on the parameters involved in the formation of extraordinary income, accidental or undetermined factors. The uncertainty of these factors comes from the fact that many of them relate to the future and change randomly. An investor can not influence them, and should assess the investment return based on forecasted or expected future values of these parameters. In modeling the firm should take into account the impact on the operations or processes of random variables. In this case, the most efficient to use a kind of simulation — statistical modeling (or Monte Carlo method).It is suitable for practical use, as the system under study is replaced by simulation, with which and experimental studies are made. During the implementation of a simulation model of the decisive role played by the use of computers. You must first create a table calculation indices containing about revenue data, profits, taxes, coefficient of efficiency, payback period of the investment project. Next, you need to determine the predicted performance. In our example in the future price of the product may be subject to adjustment. In addition, if the volume of sales can be predicted as random variables that are independent of our strategy, their random change should be included in the simulation model. With the help of instrumental capabilities of Excel calculated data corresponding model. According to the results of statistical modeling can determine the probability assessment quality criteria characterizing features of the functioning and effectiveness of the business. You can draw conclusions and make decisions about investing based on descriptive statistics. Read more... Main drivers and trends of DLP systems development in the Russian Federation The rapid development of information technologies, the introduction of new cloud services, and the transfer of employees to remote work necessitate the adequate development of data leak Prevention (DLP) systems. The purpose of this article is to determine factors that affect this process and identify main trends in the development of DLP systems in the Russian Federation. To do this, we analyze statistics on information leaks, explore the prospects for implementing new features of DLP systems based on modern information technologies (BigData, IOT, artificial intelligence and machine learning), and consider ways and means of integrating DLP within complex information security systems (SSI) in accordance with the requirements of the main regulatory and methodological documents of the Russian Federation in the fi of information security. To solve these problems, methods of analysis, synthesis, system analysis, formalization, comparison and analogy are used. Import substitution, digitalization of the economy, ensuring the security of critical information infrastructure, as well as the need to control automated systems, communications and users in distributed work in the context of a pandemic that has caused requirements to restrict personal contacts are considered as the main drivers of development for both information security and information technologies. As a result of the analysis, the most priority areas for the development of automated systems for monitoring information flows were identified: analytics, data visualization, system integration, behavioral analysis of threats to information security. Read more...