Return to search

Optimalizační metody s využitím simulací v MS Excel / The Optimization Methods with Utilization of the Simulation in MS Exel

Thesis is based on original self-made application programmed at VBA in MS Excel 2007. The reason to build this application was integration of simulation Monte Carlo and chosen optimization methods. The application allows do simulation of the knapsack problem and of the assignment problem with uncertainty. The parameters of these models are possible to set up as changing values in dependence of chosen probability distribution. Output of the simulation is a probability recommendation which objects should be used. Choose of objects depend on optimized models. Results of both models are represented by statistical indexes, tables of parameters and graph.

Identiferoai:union.ndltd.org:nusl.cz/oai:invenio.nusl.cz:12193
Date January 2008
CreatorsŠkulavíková, Štěpánka
ContributorsKuncová, Martina, Fábry, Jan
PublisherVysoká škola ekonomická v Praze
Source SetsCzech ETDs
LanguageCzech
Detected LanguageEnglish
Typeinfo:eu-repo/semantics/masterThesis
Rightsinfo:eu-repo/semantics/restrictedAccess

Page generated in 0.0019 seconds