|
|
Use VBA as a Tool for the Creation of Supporting Business Applications
Märtzová, Alexandra ; Neuwirth, Bernard (referee) ; Dydowicz, Petr (advisor)
The bachelor thesis focuses its goal on description and implementation of the information system application of the organisation financed by the state budget. After analysing the existing information system, change recommendations were proposed, that meet the norms, standards, and organisation requirements. Subsequently, the recommendations were implemented into application suggestion. The solution aim to automate data storage and search processes, transform related data into visual presentation, and thus reduce the length time of customer service.
|
|
| |
|
| |
|
|
Technical Analysis
Kotásek, Lukáš ; Šustrová, Tereza (referee) ; Novotná, Veronika (advisor)
Thesis is focused on CAPM model. Characteristics of five chosen stocks of NASDAQ capital market are calculated using linear regression. Market index S&P 500 is used to represent the market. Calculated values are verbally interpreted. As a presented solution, a program is created in VBA language, that will help the user to convert historical stock data from Yahoo! Finance to form, that can be used for calculations. The program will then use the data to calculate said characteristics. Program is also tested on function and performance using larger amounts of historical data.
|
|
|
Mathematical and Statistical Methods as Support of the Development of Software Applications
Kolář, Jan ; Doubravský, Karel (referee) ; Novotná, Veronika (advisor)
The subject of the thesis is design of an application for calculation of financial situation in the firm INKAREA s.r.o, which I have chosen. The software will be programmed in the intuitive environment of MS Excel with the help of VBA. I will use the reports from the accountancy during the years 2013–2017, which are going to be more analysed in the practical part. The theoretical part will be dedicated to description of statistical methods and indicators as well as introducing the chosen firm. In the end I would like to evaluate the firm´s condition and some possible suggestions for improvement of the strategy on the market.
|
|
|
Design and Creation of Software Application for the Company Obicentrum spol. s r.o.
Kremláček, Jan ; Štepník, Štefan (referee) ; Dydowicz, Petr (advisor)
The thesis is focused on analysing the current situation of OBI Centrum, spol. s r.o., company engaged in manufacturing and assembling of chimneys and chimney parts and on analysing the information system of the company. The thesis is divided into three parts. The first part addresses the theoretical bases. The second part analyses the current situation of the company, evaluating the quality of informational system and the company in general. The last part presents a proposed solution to the problem revealed by the analysis.
|
|
|
Electronic Support for Renting Small Freetime Facilities
Řezáč, Michal ; Smrž,, Pavel (referee) ; Dydowicz, Petr (advisor)
This work deals with the analysis of commercial applications available for support accounting agendas, their attributes, and projecting a data and process model for the most simple but sufficient application. In the proposed solution is preferred simplicity and maximum availability solutions for the ordinary national sole trader or for a company which needs effectively use housing fund and it is not its main activity. For this reason, the application is made for normal software for PC and specifically for MS Office which was tested in real environment.
|
|
| |
|
| |
|
| |
guest ::
