|
Mathematical and Statistical Methods as Support of the Development of Software Applications
Sysel, Filip ; Doubravský, Karel (referee) ; Novotná, Veronika (advisor)
The bachelor thesis deals with the creation of a software application in Visual Basic for Application (programming language) in version 7.1, which facilitates the financial analysis ofa selected company by using selected mathematical and statistical methods. In thetheoretical part, the theoretical framework is defined based on a literature search. The practical part consists of a problem analysis (financial analysis of the enterprise) and a proposed solution to the problem, which includes a proposal for the developed software application and recommendations for the enterprise based on the financial analysis. The software application should then make the enterprise more efficient and faster in creating the financial analysis.
|
| |
| |
|
Mathematical and Statistical Methods as Support of the Development of Software Applications
Bohuslav, Radek ; Doubravský, Karel (referee) ; Novotná, Veronika (advisor)
The diploma thesis is focused on the creation of a program enabling calculation of selected economic indicators of Arbela s.r.o. The thesis is divided into a theoretical and practical part. The content of the theoretical part is a description of individual methods and procedures of financial analysis, description of principles of time series, and regression analysis. In the practical part, the program created to calculate the selected economic indicators of the company Arbela s.r.o. is presented. These indicators are subsequently evaluated and foreseeable development of the company is determined for the future. At the end of the thesis, solutions for possible improvement of the economic situation of the company can be found.
|
|
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.
|
| |
|
The Application of Fuzzy Logic for Rating of Suppliers for the Firm
Ondruch, Lukáš ; Šebestová, Monika (referee) ; Dostál, Petr (advisor)
The master’s thesis deals with the use of fuzzy logic for evaluating the quality of suppliers of IT goods and other material for a selected company. The fuzzy model should facilitate decisions when selecting individual suppliers who should deliver goods for the implementation of IT projects. The model created in Microsoft Excel and MathWorks MATLAB should be helpful to the company's management and sales representatives.
|
|
Use VBA as a Tool for the Creation of Index of Marks
Steklý, Tomáš ; Mikešová, Štěpánka (referee) ; Dydowicz, Petr (advisor)
The content of this work is processising e-index for elementary schools and high schools. The main purpose of this work is to create a programme, which will make marking the students easier and clearer. Work itself is devided into theoretical and practical part. In theoretical part, there will be discussed issue of index in education field. Practical part is focused on processing this issue in the processing programming language Visual Basic for Application in Microsoft Excel environment.
|
|
Automated Processing of Acoustic Measurements
Kaláb, Vojtěch ; Kurc, David (referee) ; Schimmel, Jiří (advisor)
The goal of the Semestral thesis is to develop and describe application for automatized processing of the outputs from sound level meter NTi XL2. Application is developed in Integrated Development Enviroment Visual Basic for Application and realized in Microsoft Excel. It evaluates various types of outputs, processes its results and display the measurement protocol, including graphs of selected variables and measurement uncertainty. Theoretical part is focused on electroacustics required for understanding and processing measurement.
|
| |