|
| |
|
|
Process values datalogger
Bráblík, Radim ; Hynčica, Ondřej (referee) ; Bradáč, Zdeněk (advisor)
This bachelor’s work covers with already realized program of datalogger. On its beginning is shortly described what datalogger is, followed by description of used OPC protocol, its formation, basic specifications, principle of function and communication. Next is shortly described control system of ABB Company. Then follow short mention about application MS Excel and in the end is description of program of datalogger from view of visual aspect, function, ability and verify of its functionality.
|
|
|
Automation of static solution of some wood structures problems
Hetver, Jan ; Vlk, Zbyněk (referee) ; Zídek, Rostislav (advisor)
The object of this work is to create a program with automatic design and assessment of joints with pin connections. The program uses procedures ČSN 73 1702 and the Johansen relations to calculate capacity. The program is particularly appropriate for saving time during a lengthy draft of these connections. It helps to easily assess connections to the ultimate limit state and serviceability.
|
|
|
Implementation of MS EXCEL and VBA in business field
Zeman, Michal ; Benáčanová, Helena (advisor) ; Hirko, Michal (referee)
Bachelor thesis describes the use of MS Excel and VBA to improve processes in a small carpentry firm KendyDoor. The objective of this thesis is to analyze processes of the firm, its deficiencies and to use gained information to improve them. The objectives are realized by advising implementation of MS Excel and VBA in firm processes and by realization of practical project -- creation of pricing document for KendyDoor.
|
|
|
Possibilities of Deepening the Theory and Practice of Investment Decisions with an Emphasis on Real Options
Oceláková, Petra ; Valach, Josef (advisor) ; Hrdý, Milan (referee) ; Choulík, Petr (referee)
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.
|
|
|
MS Excel spreadsheet in mathematics education at primary schools
SVOBODOVÁ, Denisa
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.
|
|
| |
|
|
Comparison of systems for evaluating the efficiency of using DEA models
Murinová, Michaela ; Šindelářová, Irena (advisor) ; Chýna, Vladislav (referee)
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.
|
|
|
Possibilities of data presentation in business intelligence applications
Tůma, Martin ; Pour, Jan (advisor) ; Zajíc, Ján (referee)
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.
|
|
|
Basic Physical Practice Coursebook
MITTASCH, Marek
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.
|
guest ::
