Aerospace Technic and Technology

The article describes an innovative approach to encoding and storing frequency information of the R-828 radio station, which is implemented on special equipment of the manned complex. The purpose of the article: to develop a methodology for encoding and storing frequency information according to the сascaded concept for reconfiguring the R-828 radio station to a new radio data. The technology is developed and the methodology for automatic evaluation of current and subsequent radio data according to the cascaded concept for the presence of given information content is revealed. The stages of conversion and encoding frequency radio data of the radio station's storage device using the technology of identifying key features of given information content in the system for entering new radio data are justified. A software implementation of automating the process of converting frequency radio data into a code sequence is proposed. Automation of the recalculation process, which is built in the program for working with Microsoft Office Excel spreadsheets, is justified. The implementation of the method of converting frequency radio data into a sequence code combination is proposed to be implemented using the functions IF, MOD, ROUND, AND. It is proved that to create calculations and document the information component, the Excel table processor is programmatically used, which allows, for further data analysis (if necessary), to automatically create and receive reports in the form of tables and graphs. A method for evaluating the effectiveness of the proposed technology of encoding and storing frequency information of the R-828 radio station on new radio channels is proposed, and the obtained expert results of this method are presented. An experimental assessment of the effectiveness of the developed technology is given, which allows us to assert a reduction in the labor costs for the personnel of the aviation engineering service in the aviation brigades Air Force of the Armed Forces of Ukraine to recalculate frequencies in the appropriate code combinations and to work out control sheets for changing the frequencies of radio station R-828 channels, as well as a reduction in errors of the first and second kind when performing work on changing frequency radio data, by reducing the influence of the human factor on the occurrence of errors when performing appropriate recalculations. The relevance of the problem under consideration is primarily related to the specifics of performing tasks of the aviation engineering service in the conditions of the Joint Forces Operation in the east of Ukraine, namely, an increase in the number of operations to change operating frequencies, which reduces the probability of listening to communication channels by the enemy, which in turn affects the provision an appropriate level of noise immunity and the noise immunity of radio data exchange channels.

radio station R-828; storage device; jamming resistance; MS Office Excel; aviation engineering service, noise im-munity

«Evkalypt M-24». YKh1.104.072 TO. Tekhnycheskoe opysanye [Technical description], 1976. 217 p.

Yaesu HF&V/UHF All Mode Transceivers product catalogs, 2017. 37 p.

TDFM-9300 Multiband P25 Airborne Trans-ceiver. Installation Instructions. TiL Document No. 13RE471, Rev. D, Issue 5, November 2015. Available at: http://www.til.ca/content/pdfs/13RE471D5-TDFM-9300-Installation-Instructions.pdf. (аccessed 20.12.2020).

Nakaz Ministerstva oborony Ukrayiny “Pro za-tverdzhennya Pravyl inzhenerno-aviatsiynoho zabezpechennya derzhavnoyi aviatsiyi Ukrayiny № 343 vid 05.07.2016” [The Order of the Ministry of Defense of Ukraine “On approval of the rules of aviation engineering support of the State Aviation of Ukraine № 343 from 05.07.2016”] Available at: www.zakon.rada.gov.ua/laws/show/z1101-16/. (аc-cessed 20.12.2020).

R-828 YKh1.104.072 TB1 Tablytsa nabora voln [R-828 ИХ1.104.072 ТB1, Wave set table], 1976. 8 p.

Konakhovych, H. F., Antonov, V. V., Kurushkin, V. Ye. Kontseptsiya pobudovy obladnannya zakhyshchenoho radiotelefonnoho zv"yazku dlya aviatsiynykh zastosuvan' [Concept of building secure radiotelephone communication equipment for aviation applications]. Bezpeka informatsiyi – Information security, 2014, no. 3(20), pp. 224-230.

Alexander, Michael. Excel 2019 Bible. Wiley, 2019. 1136 p.

Winston, Wayne. Microsoft Excel 2019 Data Analysis and Business Modeling (Business Skills). Pearson Education Publ., 2019. 800 p.

Russo, Marco. The Definitive Guide to DAX: Business Intelligence for Microsoft Power BI, SQL Server Analysis Services, and Excel (Business Skills). Microsoft Press Publ., 2019. 768 p.

Doc 9718. AN/957. Handbook on Radio Fre-quency Spectrum Requirements for Civil Aviation. 2018, Volume I, ICAO spectrum strategy, policy state-ments and related information. Available at: https://www.icao.int/safety/FSMP/Documents/Doc9718/Doc9718_Vol_I_2nd_ed_(2018)corr1.pdf. (аccessed 20.12.2020).