A program for translating transport schedules into a machine-readable format for constructing and analyzing mathematical models

The article considers the problems associated with the different perception of information by humans and computers, in particular, due to the variety of possible ways of presenting data on route schedules for various types of transport. In the context of digitalization of transport processes, when working with a large amount of initial information, a tool is needed that allows you to become a link between a person and a machine.
The purpose of the study is to develop a program for translating transport schedules from a format convenient for a person to a format convenient for machine processing when studying regional transport networks. The problems of analyzing various forms of presenting schedules and determining a common format for preparing initial data, developing an algorithm for the program and studying its possible applicability are solved.
An analysis of various web services and other sources providing information on transport schedules was carried out. The criteria that the initial data must satisfy, on the basis of which a template convenient for human perception was developed, are determined. The algorithm of the program and the features of its construction are described. The developed software product is an addition to the existing digital model of regional passenger communication in Crimea, which makes it possible to reduce the labor intensity of the process of filling the model with information, reduce the number of errors and increase the accuracy of modeling when creating multimodal regional routes and their further analysis.

1. Makisha E.V. Analysis of methods for translating the requirements of regulatory and technical documentation into a machine-readable format for checking information models of construction objects. Modeling, optimization and information technologies. Vol. 7, No. 2(25). Pp. 339-350. 2019. DOI: 10.26102/2310-6018/2019.25.2.028. (In Russia).

2. Savelyev B.I., Skoryukina N.S., Arlazarov V.V. A Method for Machine-Readable Zones Location Based on a Combination of the Hough Transform and the Search for Feature Points. Bulletin of the South Ural State University. Series: Mathematical Modelling, Programming and Computer Software. Vol. 15. No. 2. Pp. 100-110. 2022. DOI: 10.14529/mmp220208.

3. Lakhtin S.E., Tsimbal V.A., Malenkov A.A. Classification of data formats of electronic documents for serialization of legal acts in machine-readable form. Legal Informatics. No. 3. pp. 75-88. 2023. (In Russia).

4. Voloshchuk V.A., Nekrasevich O.V., Hanko A.O., Methods of a highly efficient human-machine interface. Automation of technological and business processes, Vol. 12, No. 4, Pp. 12-21. 2020. DOI: 10.15673/atbp.v12i4.1930. (In Ukrainian).

5. Akifyeva I.A., Voitenkov S.S. Coordination of bus route schedules in regional passenger transportation. T-Comm: Telecommunications and transport. Vol. 14, No. 9. pp. 31-37. 2020. DOI: 10.36724/2072-8735-2020-14-9-31-37. (In Russia).

6. Vakulenko S.P., Gaisina L.R., Shmal V.N., Nasybullin A.M. Train schedules taking into account the convenience of transfer for passengers. Economics of railways. No. 4. pp. 67-74. 2022. (In Russia).

7. Andronov S. A., Ulvacheva O.V. Synchronization of schedules at the transfer hub in the PTV Visum environment. System analysis and logistics. No. 2(32). pp. 73-87. 2022. DOI: 10.31799/2077-5687-2022-2-73-87. (In Russia).

8. Goryaev N.K., Myachkov K.Yu., Penkovskaya T.V., Bandurko S.O. Automation of scheduling for intermunicipal passenger transportation. Bulletin of the South Ural State University. Series: Economics and Management. Vol. 14, No. 3. pp. 188-192. 2020. DOI: 10.14529/em200320. (In Russia).

9. Kostenko V. V., Golubtsov V.A. A model of a regional transport network for building rational multimodal passenger transportation routes. Bulletin of scientific research results. No. 4. pp. 158-172. 2023. DOI: 10.20295/2223-9987-2023-4-158-172. (In Russia).

10. Kostenko V.V., Golubtsov V.A., Pank R.V., Shmidt A.O. Optimization of regional transport networks based on a mathematical model of passenger preferences. Journal of Physics Conference Series 2131(3):032101. December 2021. DOI:10.1088/1742-6596/2131/3/032101

11. Kudryavtsev N.G., Kudin D.V., Belikova M.V. Programming in VBA MS Excel: textbook. [Internet]. Gorno-Altaysk: RIO GAGU. 116 p. 2015. [cited 7 August 2024] URL: http://www.robionika.ru/uploads/files/book_vba.pdf. (In Russia).

12. The forum of programmers and sysadmins Cyberforum. [Internet] 2024. [cited 7 August 2024]. URL: https://www.cyberforum.ru/ (In Russia).

13. Planet Excel. [Internet]. 2024. [cited 7 August 2024]. URL: https://www.planetaexcel.ru/ (In Russia).