| |
| |
| |
| |
|
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.
|
|
Financial analysis of a company Severočeská energetika, a.s.
Urban, Pavel ; Klečka, Jiří (advisor) ; Králíček, Vladimír (referee)
The aim of the thesis is to generally approach the financial analysis with focus on the models of summary assessment of a company (i.e. bankruptcy models and creditworthy models). In the practical part the financial analysis of the company Severočeská energetika, a.s., was performed for the period 2001 - 2006 by means of horizontal and vertical analysis of accounting statements, by means of ratio indicators and bankruptcy and creditworthy models including comparison of the results of the individual methods used.
|
|
Experimental study of high rayleigh number convection using cryogenic gaseous 4He
Urban, Pavel ; Musilová, Věra ; Skrbek, L.
Several laboratories worldwide try to elucidate the underlying mechanisms of turbulent thermal convection using cryogenic He gas, a working fluid with truly remarkable and widely tuneable properties. The focus is on the efficiency of the heat transfer, experimentally studied via the Nusselt (Nu) versus Rayleigh number (Ra) dependence, especially at very high Ra. In order to resolve existing controversies among published results, we designed and built a cryogenic apparatus capable of reaching Ra up to 2 × 10e15, thus covering the range of interest where various transitions such as that into the theoretically predicted ultimate Kraichnan regime have been claimed. The cylindrical convection cell of 300 mm both in diameter and height is designed to withstand pressures up to 250 kPa at working temperatures between 4.2 K and 12 K. The main advantage of this apparatus is minimized influence of its cell design and materials used on the studied convection. The first experimental results are resented.
|
| |
|
Návrh a testování kryostatu s experimentální celou pro turbulentní tepelnou konvekci
Urban, Pavel ; Hanzelka, Pavel ; Musilová, Věra ; Srnka, Aleš ; Skrbek, Ladislav
We have designed an experimental cell of He cryostat for the study of the turbulent natural convection at very high Rayleigh numbers (1e6 < Ra < 2e15) with cryogenic 4He gas as a working fluid. The main goal of our study is to resolve the question about the transition to an ultimate Kraichnan regime within a range of available Ra, as similar experiments with cryogenic 4He gas performed in Chicago, Grenoble, Oregon and Trieste gave controversial results. The Grenoble group claimed to observe the Kraichnan regime above Ra = 1e11 in their experiments. This phenomenon has not been observed in other laboratories. Using our newly developed cylindrical convection cell of variable aspect ratio G with very thin stainless steel wall is well suited to resolve this issue as well as remaining controversy about the Nu(Ra,Pr,G) dependence.
|
|
Návrh héliového kryostatu pro studium turbulentní tepelné konvekce při kryogenních teplotách
Srnka, Aleš ; Hanzelka, Pavel ; Musilová, Věra ; Urban, Pavel ; Skrbek, Ladislav
We present the design of a cryostat with an experimental cell for turbulent thermal convection using cryogenic helium gas. It is based on our long-term experience in cryostat design, especially low-loss cryostats for NMR magnets. The top and bottom of the convection cell are made of thick Cu plates. The cylindrical stainless steel wall consists of three parts; the middle one is exchangeable and allows for varying the cell aspect ratio. Another goal of our cell design is reduction of the parasitic heat flux from the copper plates via the cylindrical wall to its interior. As the cell operates up to 3.5 bar, we have paid significant attention to the safety of the cryostat and simulated critical situations such as a sudden vacuum loss.
|