|
Design of Steam Turbine Inquiry Tool
Suský, Martin ; Cimrák, Miroslav (referee) ; Dydowicz, Petr (advisor)
The bachelor's thesis focuses on the design of a demand tool for steam turbines manufactured in the company Siemens Energy, s.r.o., branch plant Industrial Turbomachinery in Brno. The tool is designed in Microsoft Excel using the Visual Basic for Applications programming language. In the theoretical part I deal with the explanation of basic information and principles about the programming language VBA and Microsoft Excel. The output of this bachelor thesis is a calculation tool.
|
| |
|
Design of Software Support for Evaluation of Financial Situation in the PoS a.s.
Šikula, Pavel ; Dobiáš, Jaroslav (referee) ; Luhan, Jan (advisor)
The bachelor thesis deals with design of an application in MS Excel 2007 using macros and Visual Basic for Applications programming language for the Poličské strojírny a.s. financial analysis. Emphasis is placed on the import of data from main financial statements (balance sheet, profit and loss statement) and subsequent calculation of relevant financial indicators, their interpretation and graphic representation of their development in time. The proposed application will be used for strategic planning and its outcomes will be a part of the medium-term company conception.
|
|
Optimization of NC program using CAD/CAM software
Paseka, Jan ; Kaderka, Jaroslav (referee) ; Osička, Karel (advisor)
Tendency of this master thesis is a proposal of savings in the process of technological production’s preparation in a manufacturing company. In the first part is elaborated general theoretical study of current components and NC programs. Based on this, and finished analysis was defined optimization’s proposals described in second part. Thanks this complete proposals comes to time and money savings, which are needed for implementation of prototype project into serial production.
|
|
Optimizing coaxial filters by Tuning-Space Mapping in CST
Wolanský, David ; Tkadlec, Roman (referee) ; Raida, Zbyněk (advisor)
This thesis deals with optimization of coaxial cavity filters. It thoroughly describes optimization method Tuning – Space Mapping (TSM) in CST Studio. It focuses on the explanation of the fine and the coarse model and their mutual link. The whole algorithm is illustrated and tested on the third-order coaxial cavity filter working in the band of 880 – 960MHz. In order to check the function of TSM, the algorithm is applied on fourth-order filter, triplet filter and quadruplet filter. Another part of the thesis focuses on the automatization of the whole optimization procedure. Macros for automatic determination of calibration constants and automatic calibration process between the coarse and the fine model are proposed and programmed in CST. The complete optimization procedure is applied on optimization of seventh-order filter with two cross couplings.
|
| |
|
Correspondence analysis application in MS Excel program
Ganajová, Michaela ; Řezanková, Hana (advisor) ; Pecáková, Iva (referee)
The aim of the diploma thesis was to create independently an application, automating a correspondence analysis calculation using MS Excel and taking advantage of VBA programming language. The application was then used to analyse Slovak banking sector. The created application is based on macro sets which can be split up to two parts. The first part produces a contingency table and converts it into a format usable in the second part. Then there is executed the Correspondence Analysis calculation itself. Supplement Matrix is being used, that allows to discharge functions from matrix and linear algebra. The application allows to process any matrix dimension. Dialog window offers four normalization types, shortened and also full output and it is possible to display row or column variable categories, eventually both. The analysis subject was to find out which of the products are typical for considered banks and for which clients, divided into age categories, is attractive particular bank and/or product. A starting point is a product usage data matrix at a particular bank. There was made a conclusion, that it is possible to divide banks into more traditional or modern type institutions and also that each bank has a typical product.
|