|
|
Possibilities of using VBA in business practice
Urban, Pavel ; Benáčanová, Helena (advisor) ; Rybka, Čestmír (referee)
This bachelor thesis describes the possibilities of Visual Basic for Applications programing language in real business cases. The goal of the thesis is to develop an application in VBA, that will save the users time and it will awake their interest into automation tools. The application is used to demonstrate the possibilities of VBA. The first part of the thesis analyses the situation and how much the automation tools are used in the HR department of the company the application was developed for. The second part describes the application and its components. There the functionality is explained, the process of development and the users point of view for each component. The last part describes the launch of the application and users feedback.
|
|
|
Optimization in MS Excel using VBA
Lhoták, Petr ; Chýna, Vladislav (advisor) ; Šindelářová, Irena (referee)
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.
|
|
| |
|
| |
|
|
Application for work simplification of the study officer in entrance exams
Marek, Lukáš ; Benáčanová, Helena (advisor) ; Sedláčková, Jana (referee)
This bachelor thesis describes the realization of development of application, which extends the functionality of Integrated study information system on the University of economics in Prague. First part of this thesis is mainly focused on the analytical part of the application. Main topic is the work, practice and experience of a study officer in entrance exams. This part is also focused on the specification of input and output data. And these specifications are used to describe the new functionality requirements of the application. Second part is mainly about the development of the application. The development is seen and described from it experts point of view and also from users point of view. Each algorithm, procedure and function is explained and the solution of problems is well covered. In the users point of view part there is a simple user guide about how to use this application.
|
|
|
Designing a user interface for creating applications in VBA
Nagrant, Richard ; Benáčanová, Helena (advisor) ; Lorenc, Miroslav (referee)
My bachelor thesis is dedicated to the issue through the use of controls using VBA language and macros in Excel. The goal is to bring users a detailed look at creating user interface followed by application of controls. The introductory part shows differences between versions of MS Excel 2003 and 2007, to which are attached survey results. The theoretical part describes the most common controls, its most important features and also is given clear example. In practical part I applied the use of controls in user interface, I also put emphasis on the interaction of controls and worksheets in workbook. The result is an application for dynamic records management, which can be used to make outputs in the form of either pivot tables or text file exports. This thesis may be used as a guide for users, who don't have experiences with creating of user interfaces using VBA
|
|
|
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
|
guest ::
