| |
| |
|
VBA and Maple application in process engineering problematics.
Farkač, Daniel ; Jegla, Zdeněk (referee) ; Kohoutek, Josef (advisor)
The task of the diploma thesis named VBA and Maple Application on Process Engineering Problems is to show the possibilities of using these programming languages for various engineering tasks. Particularly the programming language Visual Basic for Application (VBA), which is a part of MS Office package, is very little used in practise. That´s why this thesis solves the complex task of a furnaces design process; the topic was reccomended by the supervisor prof. Ing. Josef Kohoutek, CSc. Specifically, the thesis deals with calculations of heat transfer and optimization of the height of extended surfaces of tubes in the convection section of process furnaces. The entire task is elaborated in VBA and runs in Excel. After entering the input information, the created program first calculates the size and heat output of the convection section, but it can also optimize the height of extended surfaces in different parts of the convection section and thus minimize investment costs.
|
|
Optimization Models for Strategical Decision Making
Ulverová, Michaela ; Škapa, Stanislav (referee) ; Popela, Pavel (advisor)
The thesis deals with possibilities of mathematical modeling for public university budgets. Firstly, external conditions of public university financial inflows are discussed and~illustrated by using particular data. The related basic legislature is introduced. In~the~next part, internal financial flows are described the help of a general scheme. Step-by-step, a mathematical model of the university budget was built with using analysis of existing data, rules and formulas. The proposed model represents nonlinear multi–stage scenario-based stochastic programme, involving linear and network-flow like constraints. It allows to take into account more objective functions and related parametric analysis. The model was implemented in the algebraic modeling system GAMS with~interface to MS Excel. The aim of the presented mathematical model was not to offer a tool that would be used for automatic distribution of financial resources of the university, but to give flexible possibilities to its user to realize computational experiments and in this way to achieve a deeper insight into the modeled problem.
|
| |
| |
| |
|
Business Intelligence as Data Analysis Tool for Controlling the Company
Novák, Ondřej ; Hajn, Pavel (referee) ; Kříž, Jiří (advisor)
Designing and creating the finished OLAP solutions within Business Intelligence for an undertaking by the customer's requirements using standard technologies and practices that are designed for this purpose. This work describes the work of the design, creation and deployment of the finished project Business Intelligence solution that allows the customer to perform more accurate analysis of their own data in the context of controlling.
|
| |
| |