POSSIBILITIES OF USING MICROSOFT EXCEL FOR DEVELOPMENT OF SOFTWARE TOOLS FOR SOLVING DYNAMIC PROGRAMMING PROBLEMS

摘要

The article describes the process of creating and developing an electronic textbook for studying the method of dynamic programming. This method is used to solve some optimization problems and is studied in such disciplines as "Theory of decision-making" and "Methods of optimal solutions". The article highlights the possibility of using the developed manual to solve the practical problem of the optimal allocation of resources between the four companies, determining the maximum income and the amount of funds invested in each company. The article shows how to ensure the uniqueness of job options on each computer. The implementation of automatic verification of the answer entered by the user and display of calculations obtained at different stages of solving the problem in multimedia mode is demonstrated. At problem definition about distribution of resources and carrying out calculations by method of dynamic programming data register in the form of tables. For this reason, a widely used table editor Microsoft Excel was chosen as a software product for the development of the manual. Programming in the environment of VBA Excel is applied to work of the textbook. The formation of the task condition is carried out using the program code that is executed when the manual file is opened. If the user has difficulty in solving the problem, he can see the solution process. The organization of the solution display occurs when you click the buttons located on the Excel sheet. The electronic manual is a complete software product that is successfully used in practical classes. The manual can be used for self-study and distance learning.