|
|
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.
|
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
|
Optimalization of distribution process in trading company
Scigel, Pavel ; Jablonský, Josef (advisor) ; Kořenář, Václav (referee)
The thesis deals with distribution problems and their methods for their solution. They belong to one of the most often used optimization models in practice. The thesis describes background for using modelling support systems LINGO and MPL for Windows. The modelling languages allow solving all problems described in the theoretical part including the travelling salesman problem and the vehicle routing problem. There are described basic heuristic methods for problems with higher number of variables in this work as well. The thesis includes the description of a real situation for which it is possible to apply travelling salesman problem or vehicle routing problem models. It is a complex problem which cannot be solved by exact methods but heuristic methods must be used. The problem is going to be solved by means of MS Excel together with Visual Basic for Applications using the heuristic method of nearest neighbour.
|
|
|
Collection of Solved Linear Programming Problems
Ďuricová, Alexandra ; Šindelářová, Irena (advisor) ; Kořenář, Václav (referee)
The target of this bachelor thesis is to build new examples of linear programming. The examples in this work include all the formalities which are necessary for the correct interpretation. The entering tasks designed are based on real problems and consist of as much real values as possible. The work is divided into nine chapters and eight of them represent one area of linear programming. The first chapter is a short introduction into the theory of linear programming. The second chapter consists of two parts representing integer and non-integer programming. This chapter is the largest and contains 9 examples. The following four chapters consist of examples of non-integer programming and the last three chapters contain examples of integer programming.
|
guest ::
