|
|
Capacity Planning Tool for Project Management Support
Zatloukal, Tomáš ; Dvořák, Karel (referee) ; Luhan, Jan (advisor)
This master’s thesis deals with the design and realization of support software tool for production capacity planning in selected company. Functionality of the application will be designed according to theoretical findings (from the area of process management and business informatics) and analysis of business processes and user requirements. Final support tool should facilitate all management decisions regarding long-term planning of production and will be implemented in Microsoft Excel and Visual Basic for Applications.
|
|
|
System Support Improvement of Sales and Production Planning
Kamenský, Michal ; Pokorný, Peter (referee) ; Dydowicz, Petr (advisor)
The presented diploma thesis deals with the improvement of system support at the department Sales Planning and Reporting in Skoda Auto a.s. Its major objective is proposal, creation and implementation of the main analytical tool for sales and production planning in this department with regard to the economic efficiency of this solution. The main task of this tool is to make the process of planning in the company more effective and support management’s decision making process. The entire project is implemented in Microsoft Excel using Visual Basic.
|
|
| |
|
| |
|
|
Comparison of Utility Programs MS Excel and SAS
Strnadová, Lenka ; Bartošová, Jitka (advisor) ; Krejčová, Iva (referee)
The final thesis deals with the comparing of the usability of Microsoft Excel programs and Statistical Analysis Software and exposing their advantages and disadvantages in data processing. The work attempts to evaluate using programs in employment and at universities. The using of these programs will be studied in detail at The University of Economics, Faculty of Management in Jindřichův Hradec.
|
|
|
Possibilities of using VBA in business practice
Bukovský, Josef ; Benáčanová, Helena (advisor) ; Rybka, Čestmír (referee)
This bachelor thesis describes the use of advanced techniques while working in MS Excel and VBA environment in Hewlett Packard. The purpose of this thesis is to give high level advices in the area of collecting and analyzing of data and to discuss advanced options of MS Excel. All above is being described on practical tasks in the Hewlett Packard project "P2014" and so with the possibility to transfer all got knowledge to everyday' s life of employees not only in Hewlett Packard.
|
|
|
Decision support systems design in the Microsoft Office environment
Kukač, Martin ; Mildeová, Stanislava (advisor) ; Brixí, Radim (referee)
The main topic of this thesis is design and implementation of decision support systems in the environment of Microsoft Excel and Microsoft Access by a programmer or advanced user. The thesis provides basic theory regarding principles and the history of decision support systems. The thesis explains technologies that are the backbone of Microsoft Office suite and applies these technologies to create set of "best practices" for designing and programming decision support systems and demonstrates this set with two sample implementatios. Both implementations are compared, advantages and disadvantages of each are shown.
|
|
|
Controlling in KAEFER Isoliertechnik
Kuderjavá, Nina ; Kubálková, Markéta (advisor) ; Känner, Oliver (referee)
This bachelor thesis describes development of controlling tool in the programming language VBA in MS Excel for internal needs of KAEFER Isoliertechnik GmbH & Co. KG. The main objective of this work is to analyze the process of its development, considering system originally used by the company. It also defines the role of a tool in companies controlling system and its potential benefits. The theoretical part deals with the objectives, functions and responsibilities of controlling and its position in the organizational structure. It defines controlling in relation to the accounting, costs structure and methods of their calculation. It describes the company itself, structure of controlling in it, original reporting system to the headquarters and newly created solution in MS Excel.
|
|
|
New teaching methods using the Information Technology
Drudík, Jakub ; Šedivá, Zuzana (advisor) ; Benáčanová, Helena (referee)
The diploma thesis describes selected new teaching methods using the Information Technology. In consideration of supporting the Informatics course at University of Economics, the options of future teaching methodology development are outlined. The creation of educational tutorials in form of screencasting is considered as the first development step, for which the methodology has been drawn up. It covers preparation, implementation and publishing of the tutorials. To test the methodology, supporting learning materials were worked out accordingly for the part of the course explaining Microsoft Excel 2007 application -- in form of the illustration of the problem solving process. The created tutorials were published on the special website and presented (not only) to students. Within 14-day testing period a large dataset was acquired to provide feedback both from tracking visitors' movements on the website and from e-questionnaires. The feedback was thoroughly analysed and the conclusions were used for the optimalization of the methodology which was finalized by this step and is disposable for authors of future educational tutorials.
|
|
|
Visual Basic for Application - usage in security systems
FOJT, Michal
This paper deals with application programming environment ?Visual Basic for Applications? in security systems, particularly in applications for access control, or attendance. The finished program is for quick reference in the records of these safety systems in Microsoft Excel, set by user search filter.
|
guest ::
