National Repository of Grey Literature 11 records found  1 - 10next  jump to record: Search took 0.01 seconds. 
Mathematical Modeling of Problems of Production Planning
Poláchová, Zuzana ; Machala, Ondřej (referee) ; Bobalová, Martina (advisor)
Bachelor thesis is focused on the optimization of production planning using MS Excel. It includes a proposal for extension of the Solver add-in user friendly features that facilitate the optimization of business processes.
Cross_section and reinforcement optimization of roof truss
Odvárka, Miroslav ; Šimůnek, Petr (referee) ; Laníková, Ivana (advisor)
The thesis is focused on optimization of cross-section shape of reinforced concrete truss. An optimization algorithm was created in Microsoft Office Excel which optimizes the shape and reinforcement of the reinforced concrete truss. The truss is as cheap as possible while complying with the ultimate limit state and serviceability limit state - deflection. The algorithm uses the Solver tool which is a supplement program Microsoft Office Excel. Two truss variants were created. One has a cross-sectional shape of a truss designed according to empirical relationships and the second comprises an optimized cross-sectional shape using the algorithm formed. The internal truss forces were detected using Scia Engineer. Both options were statically assessed. When comparing the variants, that a considerable part of the material cost can be saved when optimizing the cross-sectional shape.
A Comparison of Optimization Programmes
Kovářík, Dušan ; Dvořák, Jiří (referee) ; Šeda, Miloš (advisor)
The thesis is focused on various free available software, designed for mathematical optimization. In the first section, the current offerings on the optimization software market are introduced. Further on, the thesis is dealing in details with selected pieces of software products – specifically GAMS, LINGO, QMS web service (Quantitative Methods Software) and Investigator tool, embedded in MS Office Excel application. The closing part, then, is concerned with testing and comparison of above presented software products, employing the performance tests with pre-selected optimization tasks.
Cross_section and reinforcement optimization of roof truss
Odvárka, Miroslav ; Šimůnek, Petr (referee) ; Laníková, Ivana (advisor)
The thesis is focused on optimization of cross-section shape of reinforced concrete truss. An optimization algorithm was created in Microsoft Office Excel which optimizes the shape and reinforcement of the reinforced concrete truss. The truss is as cheap as possible while complying with the ultimate limit state and serviceability limit state - deflection. The algorithm uses the Solver tool which is a supplement program Microsoft Office Excel. Two truss variants were created. One has a cross-sectional shape of a truss designed according to empirical relationships and the second comprises an optimized cross-sectional shape using the algorithm formed. The internal truss forces were detected using Scia Engineer. Both options were statically assessed. When comparing the variants, that a considerable part of the material cost can be saved when optimizing the cross-sectional shape.
Mathematical Modeling of Problems of Production Planning
Poláchová, Zuzana ; Machala, Ondřej (referee) ; Bobalová, Martina (advisor)
Bachelor thesis is focused on the optimization of production planning using MS Excel. It includes a proposal for extension of the Solver add-in user friendly features that facilitate the optimization of business processes.
Kakuro Puzzle
Hodáň, Ján ; Šuška, Boris (referee) ; Zámečníková, Eva (advisor)
This thesis deals with history of logic and logic games. In details deals with rules and options of solving logic game Kakuro. It analyze the problem of implementation of this game to the computer algorithm. In the last chapter is explained how is logic game implemented and tested.
A Comparison of Optimization Programmes
Kovářík, Dušan ; Dvořák, Jiří (referee) ; Šeda, Miloš (advisor)
The thesis is focused on various free available software, designed for mathematical optimization. In the first section, the current offerings on the optimization software market are introduced. Further on, the thesis is dealing in details with selected pieces of software products – specifically GAMS, LINGO, QMS web service (Quantitative Methods Software) and Investigator tool, embedded in MS Office Excel application. The closing part, then, is concerned with testing and comparison of above presented software products, employing the performance tests with pre-selected optimization tasks.
Řešitel příkladů pro předmět Teoretické základy informatiky
Šimonová, Adriana
Šimonová A., A researcher of examples for a subject of Theoretical basics of informatics. Mendel Univerity in Brno, 2013. Bachelor thesis is focused on the subject - Theoretical basics of informatics, specifically on propositional calculus. In the theoretical part is described a theory of propositional calculus to be understood this issue by readers. In the second part the bachelor thesis is described by the researcher of examples.
System for solving distribution problems of LP – LINGO/Excel interface
Krčál, Adam ; Jablonský, Josef (advisor) ; Zouharová, Martina (referee)
Discrete problems of linear programming, i. e. problems with integer or binary variables, have a great amount of real-life applications. Among distribution problems, belong many different kinds of problems with discrete character -- transportation problem, container transportation problem, allocation problem, assignment problem, plant location problem, traveling salesman problem etc. In this work the theoretical aspects of chosen types of problems are explained and then an application in Microsoft Excel 2010 environment is created. For that purpose programming language VBA is the key instrument. The application cooperates with two different optimization systems -- the Solver add-in in Excel and professional optimization system Lingo. Functionality of the application is thereafter tested on some examples.
Optimization over the internet
Šálek, Pavel ; Jablonský, Josef (advisor) ; Rada, Miroslav (referee)
The goal of this thesis is to analyse and evaluate the efficiency of systems used for solving problems of mathematical programming, which are available within the frame of project NEOS (Network Enabled Optimization Server). The most frequent algorithms for solving linear programming and mixed integer programming are described in the beginning of the work -- simplex algorithms, the interior point method, cutting plane method and branch and bound method. These algorithms are used in solvers, which are supported by NEOS server. The efficiency of the algorithms and solvers are tested on collection of chosen problems contained in libraries of NETLIB and MIPLIB.

National Repository of Grey Literature : 11 records found   1 - 10next  jump to record:
Interested in being notified about new results for this query?
Subscribe to the RSS feed.