There are available various professional applications for the solving of optimization problems. This thesis deals with comparison of these optimization systems and simplicity of their connection with MS Excel through VBA. Problem of designing model together with his calculation in MS Excel or other systems connected via VBA, like MPL for Windows or LINGO, is demonstrated on concrete examples. Application in Visual Basic for Applications was created for this purpose. This application is easy to use and it is solving Knapsack Problem, Distribution Problem and also Quadratic Assignment Problem. Finally, comparison of these systems is made using Multi-criteria evaluation.

The main thesis aim is to introduce possibilities of MS Excel in data analysis and to point out to some strengths and weaknesses of MS Excel in data processing. I pay attention to tools which MS Excel contains by default as well as to statistical products which are not normally part of MS Excel. These products can be run in MS Excel environment as statistical add-ins for MS Excel. In the first case I focus on MS Excel tools as statistical functions, graphic analysis and statistical methods, in the other case on statistical products as XLStatistics, Analyse it, WinSTAT. In connection with the first mentioned statistical product I show some examples how to analyze and work with real data samples in product XLStatistics. The aim of this part is to show other way how to analyze data then in the others products or MS Excel itself. At the end of my thesis I programmed my own product Regxcel with the help of VBA language as the main contribution of my entire work. Product Regxcel provides solution in regression analysis for the six most common types of regression function. The main aim of this part is to point out to other possibility how to analyze data and solve some problems which users can face in regression analysis in MS Excel. I also try to show VBA language as big help in data processing in MS Excel. At the very end I presented all possibilities of Regxcel on real data sample. The product itself is part of attached CD

Diploma thesis focus on the design of turbocharger in SW MS Excel. For required flow and pressure ratio, the thermodynamics parameters were calculated for the turbocharger. From these, geometry was designed and the condition of mediums was calculated for each part of the turbine and compressor. At last basic characteristics of the turbine and compressor on varying the regime of engine operation the rotation was made and offered an idea about the working point position.

This diploma thesis deals with the selection of suppliers operating memory for the company Hon Hai Precision Industry Co., Ltd. (registered in the Czech Republic under the trade name Foxconn) using fuzzy logic.

Práce se zabývá možností programování základních metod teorie grafů a řízení projektů v prostředí MS Excel 2003. Hlavním přínosem by měla být aplikace vytvořená ve VBA, která má sloužit jako pomůcka při výuce operačního výzkumu. Vytvořený program je určen k případnému rozšiřování a doplňování o další metody, aby pro studijní účely bylo zpracováno co nejvíce metod.

This Master’s thesis presents a design of models which are intended for evaluation of Braintrast’s suppliers. Based on the evaluation, there is selected the most optimal supplier according to parameters. The model uses fuzzy logic theory to support decision making. The solution is designed in programs MATLAB and MS Excel.

The aim of this work is to create an application in VBA to compare countries using multi-criteria decision making methods. The main methods, mentioned in the theoretical part are implemented in the application. In theoretical part there are also compared different multi-criteria decision making methods. This work also describes macroeconomic criteria, weigths and the selection of countries. The aim of the final part is the analysis of country comparison results.

<p>This master’s thesis was performed at PartnerTech AB in Åtvidaberg. It addresses the problem of managing test results obtained from testing electronics manufactured by PartnerTech. PartnerTech has developed a test system, called Tor, which performs tests on manufactured boards and stores the test results in files. The Tor system consists of both hardware and software part, where the software runs on an ordinary PC with MS DOS/Windows 2000. The effects on the existing Tor system that this thesis implies are minimal. </p><p>This work focuses on a way of storing the produced test files in a database. In this work a data model has been developed, implemented, and evaluated together with a system that imports test files into the database and a graphical user interface that allows a user to easily search and browse the stored test results. It is also possible to print test reports from the Tor system. For implementing the database system Microsoft SQL Server 2000 was chosen as database server and an XML based data format was chosen to import and export data to and from the database. Two alternative graphical user interface applications were developed and compared - one server based on Microsoft IIS and one client based in Microsoft Access. For advanced data manipulation certain parts of the system were developed in Microsoft Excel.</p>

The thesis deals with the practical use of interactive whiteboards in teaching the topics natural numbers to a million, dependence and relations. In the introduction, I compare the general principles of the mathematics teaching and I comment on the documents dealing with the given topic. The work includes a manual and the instructions to my interactive material. The thesis also describes the process of the course material verification. In conclusion, I subjectively evaluate the acquired knowledge in confrontation with reality.

The diploma thesis is focused on verifying the accuracy of web Analytics Adobe Analytics. Manual control is a time-consuming activity, therefore web analysts are looking for ways leading to its acceleration and automation. Selected problem was solved by writing VBA macro in MS Excel. Macro checks the reports that are uploaded into Excel from analytic database using Adobe Report Builder. The theoretical part is focused on explaining the role of web analytics in online marketing and related concepts. The practical part presents the requirements for macro in Excel and then interprets all functions and procedures created by the program. Thesis also includes the configuration of the ObservePoint system competitive environment, which will be the last part compared with created macro. Created solution in Excel allows to verify the accuracy of web analytics with clearly sorted results quickly, thereby replaces the previous manual control.