The aim of the thesis is to create a set of examples from mathematics using MS Excel spreadsheet, which could be used for teaching mathematics in primary schools. Pupils practice their work from this spreadsheet calculator and also enrich their knowledge of mathematics for its practical use. This set will be used to practice graphs, functions, financial mathematics, patterns, probability, and another. All these examples will be tested in educational practice.

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. 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.

The aim of the thesis is the mathematical model, which is capable to divide participants of large summer camps into groups, according to specific limitations. The first part describes the economics model and all valid conditions. The second part is devoted to theoretical description. There are mentioned the basics of mathematical programming and the basic of working with Excel and VBA. The thesis describes only actually used methods. The following third part shows the final form of the model. So the reader doesn´t have to go through the whole process, described in the fourth part. There is a model testing in the fourth part, especially with the help of the Excel Solver. The problems are sold immediately. That is the reason why the fifth part can be used for implementation of working environment, which allows the end user to run the model without any significant knowledge of the issue. The app uses the wide possibilities of VBA. The sixth part briefly describes other add-ins, that are able to solve mathematical problem. The conclusion summarizes all the previous parts and offeres solution, that would be used in real application of the thesis.

Tato práce se zabývá vícekriteriálním lineárním programováním v prostředí Microsoft Excel. V rámci diplomové práce byla vytvořena aplikace SYMCLIP, která funguje jako doplněk MS Excel. Aplikace je určena pro řešení úloh vícekriteriálního lineárního programování pomocí metod s informací a priori a interaktivních metod. Dále jsou v aplikaci k dispozici tři metody pro odhad váhového vektoru. Aplikace by měla sloužit mimo jiné studentům Vysoké školy ekonomické při výuce předmětů zabývajících se teorií rozhodování.

The aim of this thesis is to create an application in MS Excel, which would have been able to count on basic stock models, and Markov decision processes with alternatives. This issue is devoted to the first part of the work. This is the theory needed to understand the basic principles and method of calculation tasks. The second part describes the developed application that can be solved one-product and multiproduct deterministic stock models, stochastic stock models and Markov decision processes with alternatives, and changing valuation of the transition. The description is supplemented with graphic images directly from the application, which makes using applications easier to understand. The part of work is also CD with created application.

Diploma thesis deals with the evaluation of the efficiency using DEA models focusing on the use of dedicated software tools. There are four chapters in the thesis where different approaches to efficiency are briefly presented. The method of data envelopment analysis (DEA) with its modifications is described in detail -- basic models, CCR, BCC and additive model. The main part of the work is presented in the second part of this thesis where I describe how to work with each program and summarize its advantages and disadvantages. The last chapter applies prior knowledge on real situation -- the evaluation of the efficiency of the regional police stations in the Czech Republic.

This diploma thesis is focused on the evaluation of suppliers the selection of the best one for company Fast & Healthy food services, s.r.o. This work describes methods and the process of model creation using fuzzy logic. The aim is to establish two decision models, a model created in MS Excel and a model created in MATLAB which simplify the selection of the supplier.

Creating a decision-making system for evaluating cooperation between companies based on the fuzzy model in MS Excel and MATLAB programming environment. Subsequent evaluation of possible risks for the selected company.

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 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.