This thesis applies classical optimization problems such as assignment or set-covering problem on logical puzzles or brainteasers. Listed in the first part are mathematical model, description and typical example of each optimization problem used in this thesis. The second part contains these models applied to the particular brainteasers for example Sudoku or Einstein's Puzzle. Exercises are divided into simpler and more complex ones. There is specification, source and a described method of solution stated for each of them. The calculation examples use Lingo or MS Excel or both. The aim is to show the possibility to address logical puzzles and brainteasers with the use of optimization problems, and thus confirm the wide possibilities of using these models. These examples can clarify and diversify the curriculum.

This diploma thesis deals with the possibility of presentation data in business intelligence (BI) applications. The aim is to develop a methodology for reporting and data visualization using Microsoft SQL Server 2008 Business Intelligence Development Studio and Microsoft Excel 2010. Evaluate and identify opportunities for data display using the perception of information at a subconscious level in the above mentioned tools. Identify market trends from the perspective of business intelligence data visualization. In the first part thesis focuses on the analysis of the current BI market with regard to trends in data visualization. In the following part options of perceptions on a subconscious level are examined, which are then reflected in the establishment of a methodology reporting. Similarly, it is investigated the human perception of color. Presented are appropriate and inappropriate data visualization forms, at the most commonly used graphic forms. The work describes a method to ensure that the data will not be displayed tendentiously or distorted. My contribution is creating a reporting methodology that respects the life cycle of the report, as well as a logical follow-up steps to project management.

Master Thesis deals with supplier rating with usage of fuzzy logic as an advanced decision-making method. There was made a model for selection of the optimal technologies supplier for a self-service vehicle wash. The main solution is realized with support of programs MS Excel and MATLAB.

This diploma thesis deals with the design of fuzzy models to support decision making for selecting the most suitable suppliers for PSL, a.s. Describes methods and procedures for modeling in MS Excel and MATLAB. The goal is to create a decision-making system that will evaluate suppliers to optimize the choice of the most suitable supplier based on the requirements of the selected company.

Diploma thesis describes the company and analyzes the company from financial view. Afterwards, the software program based on VBA language in MS Excel environment is designed and made. The program analyses accounts and calculates the results of financial analysis. User is able to display the results in the graph with the possibility to display the trend.

The diploma thesis presents basic concepts of measuring, physical quantities, units of measurement and Physics instruments. There are instructions how to realize the measuring in practice and an introduction of measuring deviation. There are examples showing processing of measured values including use of some Microsoft Excel functions.

The work is concerned with preparing exercises for the teaching of bulk data processing in the environment of a spreadsheet program. The exercises can be used in the lessons of ICT in the upper stage of the elementary school and in secondary schools. Presently a lot of exercises exist. These exercises are based on obsolete or uninteresting data or directly on artificial data. On the contrary there are few exercises which are based on up to date data or on data which the students entered. In the work there is an emphasis on the importance of creating exercises which are based on up to date data which is freely accessible on the Internet. For example geographical, economic or meteorological data. A software application which can download this data and transfer it into a suited format for further use in a spreadsheet program is a part of the work. We can note the benefit of using exercises, where data has been entered by the students of the class. A part of the work is a software solution which makes a survey possible for the teacher. The students answer the questions in the survey via a form. These answers are worked up into a table for further use in the lessons. An important part of the work is a set of methodical sheets. These sheets contain topics for exercises, which are specialized in bulk data processing. They show acceptable elaboration of downloaded or measured data and possible interpretation of the results. The main objective of the work is to show how and where to get up to date and attractive data for the teaching of bulk data processing and how to use it. The software and the methodical sheets should contribute to this.

This dissertation deals with selected areas within capital budgeting theory and practice. The first part is focused on possibilities how to improve traditional financial metrics as net present value and internal rate of return by using graphical tools for their interpretation. The main practical problem can be considered not the methodology itself, but the inability to predict future cash flows correctly. The special attention is paid to depreciation in connection with Czech accounting and tax legislation and its influence on capital decisions. The second part of the dissertation concentrates on real option analysis. The crucial difference between net present value and real options analysis is in how these methods deal with the risk. Mathematical approach is used to derive how the volatility and other parameters affect the theoretical value of an investment determined by real option. The more volatile the future cash flows are the higher theoretical value of the real option should be. Nevertheless, there are some exceptions that are analysed in this paper. In final chapter, total cost of ownership and real option analysis are used to evaluate option to switch from on-premise IT solution to cloud computing.

Cielom diplomovej prace je vytvorenie expertného systému založeného na modeloch fuzzy logiky v programoch Excel a MATLAB, pomocou ktorého je možné ohodnotiť rôzne dôchodkové fondy a ďalšie finančné produkty. Vzhľadom na prehlbujúcu sa demografickú krízu, práca ponúka návrhy optimálneho investičného mixu pre tri modelové situácie s cieľom dodatočného finančného zabezpečenia počas dôchodkového veku. Práca je spracovaná pre podmienky Slovenskej republiky, podľa súčasnej situácie a platnej legislatívy.

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.