|
Optimization in MS Excel using VBA
Lhoták, Petr ; Chýna, Vladislav (advisor) ; Šindelářová, Irena (referee)
There are available various professional applications for the solving of optimization problems. This thesis deals with comparison of these optimization systems and simplicity of their connection with MS Excel through VBA. Problem of designing model together with his calculation in MS Excel or other systems connected via VBA, like MPL for Windows or LINGO, is demonstrated on concrete examples. Application in Visual Basic for Applications was created for this purpose. This application is easy to use and it is solving Knapsack Problem, Distribution Problem and also Quadratic Assignment Problem. Finally, comparison of these systems is made using Multi-criteria evaluation.
|
| |
| |
| |
| |
|
System for computing distribution problems LP – Lingo/Excel interface
Lhoták, Petr ; Jablonský, Josef (advisor) ; Mynařík, Petr (referee)
This thesis deals with description of several distribution problems and their solutions. Distribution problems are the most typical problems of linear programming, which solves the optimalization of transportation of materials, people or goods. For this purpose I created an application, which combines two computer systems and makes computing of these problems easier. Concretely by combining of the systems LINGO and MS Excel through Visual Basic for Applications. Further in this work you will find solved examples of transportation problem, allocation problem, assignment problem and travelling salesman problem. You will also find the description of the main procedures of LINGO system and its connection to MS Excel through VBA. Last but not least there is brought up the programming solution of the application and its visual construction.
|