|
|
The Simulation Model of the Development of Pension Insurance
Zárubová, Radka ; Dlouhý, Martin (advisor) ; Kuncová, Martina (referee)
First, this thesis introduces the system of pension insurance with state contribution including its proposed amendment made in 2009. Its aim is to forecast and to analyse expected development in pension insurance with state contribution. The main part of the thesis is focused on the simulation model of this insurance product. Within this model, annual interest on contributions is randomly generated and the amount of money a client of a hypothetical pension fund would receive is calculated. To facilitate this simulation, I programmed and attached (as a part of the thesis) an application in VBA language which enables to run this simulation in the preset number of replications. The thesis gives four examples of simulation experiments -- a simulation of pension insurance, and a simulation of pension saving, both versions both with and without contributions made by client's employer. The comparison of the expected efficiency of the both systems from the point of view of the government and a client is drawn at the end of the thesis.
|
|
|
Task automation in spreadsheet program with the assistance of VBA
MACHÁČEK, Jan
My thesis primarily deals with a part of spreadsheet program - their macro language - Visual Basic for Application {--} VBA. The work describes the structure, features and characteristics of the language. It also brings a procedure enabeling to create macro without the knowledge of programming, as well as the procedure how to create one´s own functions and procedures or their part. The work also includes a source code of my own application that is used in practice. At present there are more instruments on the market, not just one. However, all my thesis (except the final evaluation) concentrates on one particular variation of this particular spreadsheet program {--} Excel, which is a part of Microsoft Office Professional Version 2002 (XP). The reason I chose this product simply comes from the fact that it is my daily work tool in my job. In the final part of my thesis I compare the chosen software with another alternative software.
|
|
|
Stochastické modely a jejich řešení v MS Excel
Müller, Jan ; Kořenář, Václav (advisor) ; Pelikán, Jan (referee)
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.
|
|
|
Using of VBA language in statistical analysis
Trávníček, Lukáš ; Řezanková, Hana (advisor) ; Vrabec, Michal (referee)
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
|
|
|
Stock models and their solution in MS Excel
Olejár, Filip ; Kořenář, Václav (advisor) ; Flusserová, Lenka (referee)
The goal of my thesis was to analize special stock models and to create a small aplication in MS Excel. Introduction is devoted to common description of stocks. The main part is focused on special stock models especialy on quantity rabate and model Q system. Application in MS excel is created for this models. In conclusion I verified application on fictive datas.
|
|
|
The Solving of Distribution Problems in MS Excel / LINGO
Bisová, Sára ; Jablonský, Josef (advisor) ; Skočdopolová, Veronika (referee)
The goal of this work is to explain the topic of distribution problems, special kind of linear programming problems, and also to show possibilities for solving them in some programming systems. For solving several types of distribution problems - transportation problem, container transportation problem, assignment problem, allocation problem and travelling salesman problem - I have created an application which connects MS Excel with programming language LINGO. This connection is realized by means of VBA - Visual Basic for Applications. There are described the main procedures and functions of LINGO and VBA including minute description of interconnection of these systems. Created application is illustrated on several small problems in the last part of work.
|
|
|
The Comparison of Efficiency of Approximate Methods for Solving Transportation Problem
Zárubová, Radka ; Jablonský, Josef (advisor) ; Skočdopolová, Veronika (referee)
The goal of my work is to analyze difference between optimal solution and solution we get when using approximate methods (i.e. NWCM, LCM, VAM). To get necessary data, I have created an application in VBA (both for generating and solving). The application interacts with LINGO. However, its most important parts are procedures for these approximation methods which can be run separately. Therefore, after explaining necessary theory, I focus on approximation methods and explain every single code for them. The last part of my work is the mentioned comparison. In this part, I analyze difference between optimum and approximate solution for five chosen dimensions of transportation tableau. Last but not least, I study whether there is any dependence of difference on number of constrains.
|
|
| |
|
| |
|
|
Application development in Ms Office
Večerník, František ; Buchalcevová, Alena (advisor) ; Benáčanová, Helena (referee)
Cílem této práce je vytvoření komplexního pohledu na tvorbu aplikací v Microsoft Office s využitím VBA. Především potom najít způsob jak jednoduše a především levně a rychle vytvářet tento typ aplikací. V úvodní části práce jsou stručně popsány aplikace sady MSO, které jsou při tvorbě MSO řešení nejvíce používány. Dále je zde popsán postup vývoje v jazyce VBA současně s ním i způsob vývoje aplikací ve Visual Studiu. Jsou zde stručně popsány některé základní metodiky a vůbec historie softwarového inženýrství. V kapitole Guideline pro tvorbu aplikací v MSO, která vytváří největší přínos této práce je popsán vývojový cyklus tvorby aplikací v MSO, který jsem během své praxe vytvořil. Praktická úloha potom popisuje postup tvorby jednoduché aplikace v Ms Access. Práce je určena dvěma základním skupinám osob. Jsou to především ti, kteří jsou v roli analytiku a manažerů pracovišť, kde mají pocit, že neustále mechanicky opakují věci, které by bylo možné zautomatizovat. Dále jsou to potom programátoři, analytici a konzultanti, kteří by chtěli začít vyvíjet řešení postavená na MSO. Hlavním přínosem práce je poskytnutí obecného náhledu na tvorbu tohoto typu aplikací, společně s návodem, jak to činit co nejefektivněji.
|
guest ::
