|
|
Application of Fuzzy Logic for Evaluating Investments in Stock Markets
Šmerda, Patrik ; Janková, Zuzana (referee) ; Dostál, Petr (advisor)
The diploma thesis focuses on the application of fuzzy logic in constructing a decisionmaking model for evaluating investment opportunities in stock markets, with a specific emphasis on the selection of exchange-traded funds. The model is based on essential criteria that play a crucial role in the efficient selection of funds. These criteria are implemented in two decision-making models that have been developed using Microsoft Excel and MATLAB tools. The results obtained from these models provide a solid foundation for further steps in the investment decision-making process.
|
|
|
Application of Fuzzy Logic for Evaluating Investments in Stock Markets
Jovič, Marko ; Janková, Zuzana (referee) ; Dostál, Petr (advisor)
The diploma thesis deals with the application of fuzzy logic in supplementary models that serve as a support tool for solving decision-making questions in the field of stock market investments. The models encompass evaluative criteria and their attributes, which are used to evaluate various types of investment assets. The models are implemented in MS Excel using the VBA programming language and MATLAB from MathWorks.
|
|
|
Use VBA as a Tool for the Creation of Supporting Business Applications
Kadlec, Aleš ; Bernát, Michal (referee) ; Dydowicz, Petr (advisor)
This bachelor thesis focuses on the design and implementation of an application for a spare parts warehouse. The main goal of the application is to create names of spare parts. This application also allows to export the stock statuses, to get the list of created photo documentation and to upload data from the source file of the spare parts finder application. The application is implemented in Microsoft Excel environment in VBA language. The application will be used in the spare parts warehouse, where it aims to streamline work and unify the names of individual parts of a particular category.
|
|
|
Mathematical Methods in Economics
Fábryová, Alžbeta ; Glovňa, Juraj (referee) ; Novotná, Veronika (advisor)
The bachelor's thesis deals with the design of a software solution for optimizing the ordered quantity using the MS Excel program. The first part of the thesis explains all the necessary theoretical foundations that will be later used for processing the analytical part. The second part contains information about the company and its suppliers, as well as an analysis of the problem. The last part focuses on solving the given problem. The resulting program will serve as a tool for more efficient order creation.
|
|
|
Proposal of a Part of the Information System for a Selected Company
Krábek, Kamil ; Neuwirth, Bernard (referee) ; Luhan, Jan (advisor)
The bachelor thesis focuses on the design of a part of the information system for a selected company. Based on the analysis, a part of the information system will be designed, which will be used to record and manage the work performed by employees. The main part of the thesis will be the design of the data model. The final tool will enable the recording of data about the work performed and their analysis through an external tool.
|
|
| |
|
|
Optimization of air conditioning in the office building
Hrbáček, Tomáš ; Uher, Pavel (referee) ; Blasinski, Petr (advisor)
The diploma thesis titled "Optimization of air conditioning in the office building" deals with the issue of heat load. Its understanding and correct determination is the primary step towards the correct design of air conditioning systems. The work is divided into three parts. The first part of the work, the theoretical part, serves to bring closer the theory of heat gains and heat load. Specifically, it is the external part of the thermal load, its division, description and calculation procedure of the individual parts. The second part of the work, the calculation part, focuses on the application of theoretical knowledge to a specific building. Specifically, on the proposal of two alternative solutions for the current state of the air-conditioning equipment in the 3rd floor of the administrative building serving the meeting ro-om. These are more economical variants, which, compared to the original design, carry with them certain limitations in the form of reduced comfort of use. The object for which alternative proposals were prepared is an administrative building in the town of Náchod in the Hradec Králové region. It is a four-story building with a flat single-skin roof. Inside the building, there are mainly office, communication and hygiene spaces. The third part of the thesis deals with the application and partial automation of the thermal load calculation procedure from the theoretical part and examines the influence of the glazing area of facades on the solar gains of various buildings. It describes the method of calculation, the data obtained and finally summarizes and evaluates the results. Excel software and the VBA programming language, whose development environment (IDE) is integrated in Excel, were used for the calculations.
|
|
|
Use VBA as a Tool for the Creation of Supporting Business Applications
Holec, Matej ; Neuwirth, Bernard (referee) ; Dydowicz, Petr (advisor)
This bachelor thesis is focused on the design and development of an application that is used to create quotations, invoices, function sheets, invoice records, records of wholesale customers and stock records. In addition to the theoretical part, this work also contains the current state of the company and its solution proposal. The application uses the Microsoft Excel environment and the Visual Basic for Applications programming language. The resulting solution is intended for a small company, which will bring simplification and streamlining of work.
|
|
|
Use VBA as a Tool for the Creation of Supporting Business Applications
Märtzová, Alexandra ; Neuwirth, Bernard (referee) ; Dydowicz, Petr (advisor)
The bachelor thesis focuses its goal on description and implementation of the information system application of the organisation financed by the state budget. After analysing the existing information system, change recommendations were proposed, that meet the norms, standards, and organisation requirements. Subsequently, the recommendations were implemented into application suggestion. The solution aim to automate data storage and search processes, transform related data into visual presentation, and thus reduce the length time of customer service.
|
|
| |
guest ::
