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.
| Identifer | oai:union.ndltd.org:nusl.cz/oai:invenio.nusl.cz:113415 |
| Date | January 2012 |
| Creators | Lhoták, Petr |
| Contributors | Chýna, Vladislav, Šindelářová, Irena |
| Publisher | Vysoká škola ekonomická v Praze |
| Source Sets | Czech ETDs |
| Language | Czech |
| Detected Language | English |
| Type | info:eu-repo/semantics/masterThesis |
| Rights | info:eu-repo/semantics/restrictedAccess |
Page generated in 0.0013 seconds