My diploma thesis is dedicated to the issue of data mining, its part of predictive analysis and then process that is used in HP for different prediction. The introductory part describes the concept of data mining, its role and benefits. To one of its tasks fall predictive analysis, where I discussed the principles of its use. Then follows framework HP, which uses one of the tasks of predictive analysis. In the practical part, I applied the use VBA to automate one part of the process of converting text to numerical data, assuming different rules. The result is a set of macros support, system sheet and the new ribbon for data transformation.

The Capacitated Arc Routing Problem has many applications in real life. The aim of this problem is to minimize the total cost at fulfilment of the requirements of arcs. The Capacitated Arc Routing Problem is an extension of the Chinese Postman Problem, which is a special type of the Vehicle Routing Problems. In this thesis is explained the issue of the Chinese Postman Problem and its extensions at first. Subsequently the applications of mathematical models are illustrated on a model example. However these mathematical models, which are searching the optimal solution, do not use so much in reality. Therefore the randomized heuristic algorithm for solving these problems is suggested and programmed in this thesis. Subsequently this heuristic was applied to case study of garbage collection in Podebrady city.

The diploma thesis focuses on tracing in layout by handlers between assembly lines in new plant for corporation Continental Automotive Czech Republic ltd, where boosters are produced. The theoretical part involves definitions of logistics, supply chain, material flow and handling equipment. Furthermore, methods of mathematic programming and software equipment are described, such as quadratic assignment problem, knapsack problem, travelling salesman problem from graph theory. In the practical part the situation in corporation has been analyzed and the data prepared for further examination. Then layout of plant and internal processes are evaluated and an appropriate model or concept of solution is selected. Subsequently, application in MS Excel is created with support of VBA scripts (3 kinds of layouts). The user manipulates with application followed by Solver for implementation of a new solution into practice. Finally, the models are interpreted and verified by Lingo. The focus of the thesis is the design of a layout change of a new plant including the description of tracing.

This thesis work’s purpose is to collect, analyze, and display data from a PV array located in Borlänge, Sweden. For the data analysis, MATLAB is used as an analysis tool, in order to have an idea of how the system is going in its entirety by drawing several different graphs such as daily irradiance or temperature but also to gather all the data that is available and regroup it in the same Excel sheet in order to simplify the usage of the program. For the display of the data, Excel Visual Basics for Applications (VBA) is used to establish a user-controlled interface which lets the choice to study a certain parameter over a certain period of time, and then display graphs and data automatically, all of this being chosen by the user, for example to create daily, monthly or yearly plots of the energy production as well as the efficiency of the system.

Master’s thesis deals with designing decision making system based on fuzzy logic principles which evaluates suppliers offers. In this Master’s thesis there were created two decision making systems based on the demands of the company. First decision making system was designed within the environment of MS Excel, the second one was designed in MATLAB software. In addition of creating the decision making system the thesis puts emphasis on the analysis of the current decision making model in the company and this section will serve as a springboard to designing a decision making system based on fuzzy logic. At the beginning of the work there are included all the necessary theoretical framework on which I based the writing of this thesis.

This master thesis deals with the use of fuzzy model to evaluate of construction companies. This model is used for easier and faster way to decide which of the contenders for the reconstruction of the block of flats is most suitable. The fuzzy model is created based on requirements of the community owners of the block of flats and is processed in Microsoft Excel and MathWorks MATLAB.

This diploma thesis descibes design, creation and implementation of a VBA application in Microsoft Excel. The main goal of this thesis is to design, create and implement a corporate VBA application for Apprise Software, s.r.o. that will optimize work process of Market research department which analyses segments of customers.

Master thesis deals with quality evaluation customers of Heineken Česká republika, a. s. using the theory of fuzzy logic as an advanced decision-making method, which will be further practically applied within the design of the solution. Based on the selected parameters, a model will be developed to optimize the value of the company's customers, on the basis of which the company may also decide whether to cooperate with the customer or it is more advantageous for them to terminate this cooperation. The work itself is supported by Microsoft Excel and MATLAB.

The diploma thesis focuses on the design of an application that will be used for the analysis of financial indicators. The application allows automatic calculation of financial indicators and regression analysis. It also allows a detailed analysis of calculated financial indicators using time series.

Master thesis deals with the evaluation of the quality of customers of the company ALVAO, s.r.o., using fuzzy logic. MS Excel and MATLAB programs were used for this evaluation, in which models will be created and programmed. The introductory part of the work is devoted to the theoretical background, which is necessary for understanding the whole issue. The second part of the work presents the company ALVAO, s. r. o.. In the design, main, part of the work are processed fuzzy models and a demonstration of the evaluation of real customers of the company.