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.

Human disturbance as the main factor influencing the habitat of brown bear (Ursus arctos) has occurred frequently with the development of human society. How to reduce and prevent the conflict between human and brown bears is considered as an important question for brown bear conservation, management and public safety. Sånfjället National Park has one of the densest bear populations in Sweden. Many tourists are attracted to visit bears each year. Through this study, the most possibility brown bear denning habitat in Sånfjället National Park was determined by using Multi-Criteria Analysis. A customized habitat distribution map generator was programmed within the Microsoft Visual Basic® for Applications (VBA) in ArcGIS. Three themes were designed in the map generator, i.e., the human impact emphasis weighted, neutral weighted themes and customized weighted theme. Customized weighted theme was produced for user discovering denning habitat results with user-defined weights. Comparing the final maps generated from the human impact emphasis weighted and neutral weighted themes, human influence concentrated in the south area of the National Park. The trails near Sveduterget should be changed to avoid human disturbance in the bear denning period.

Master ’s thesis deals with evaluation of investment using advanced methods of analysis and modeling with regards to the best offer. The content of the thesis consists of creating two decision making systems based on fuzzy logic. The thesis also contains a theoretical basics which are necessary for the creation of both systems and evaluating the benefits of the solution.

This thesis deals with the use of basic means of artificial intelligence, respectively fuzzy logic to evaluate the benefits of company's potential suppliers. There are mainly used principles of fuzzy logic in MATLAB, expert systems and analysis in MS Excel respectively. VBA development environment.

The diploma thesis deals with the application of the theory of fuzzy logic in the evaluation of client translation commissions for a foreign language text. This fuzzy model is used for better selection of orders and faster allocation of human resources for specific orders. The fuzzy model is composed of multi-valued decision-making criteria that are essential for the company. The model is processed in MS Excel using VBA and MathWorks MATLAB.

Master's thesis deals with design and development of two decision-making systems, which can be supportive during suppliers rating and selection the most suitable one from them. Both of the models, that one, which was made in the MS Excel, and also that one, which was made in the MATLAB, use principle of fuzzy logic and are designed according to the requirements of the selected company. Diploma thesis contains also all of theoretical bases, which are necessary for a design of both systems, and evaluation of benefits of the solution.

Programming industrial robots for welding or part manipulation tasks is a time-consuming and complicated process, resulting in companies not able to implement robot systems and exploit their advantages. To reduce the time needed for programming, research is looking into ways to automate this process and reduce manual labour.In this thesis a concept for automating the programming process of industrial robots was investigated using EXCEL VBA and CATIA/DELMIA. It was done for an industrial grating model of varying sizes and configurations, resulting in a time reduction of 99% compared to manual creation. For this, the model was first automatically created from scratch for the required configuration and afterwards a robot motion was created fully automatically. The concept and modelling approach is described, and the automation approach detailed. Finally, the results are analysed and discussed.

Submitted by Automa??o e Estat?stica (sst@bczm.ufrn.br) on 2016-03-02T22:55:04Z No. of bitstreams: 1 HerbertSenzanoLopes_DISSERT.pdf: 1964831 bytes, checksum: a1f3b710808bf3ed42490612f2700bca (MD5) / Approved for entry into archive by Arlan Eloi Leite Silva (eloihistoriador@yahoo.com.br) on 2016-03-04T00:31:31Z (GMT) No. of bitstreams: 1 HerbertSenzanoLopes_DISSERT.pdf: 1964831 bytes, checksum: a1f3b710808bf3ed42490612f2700bca (MD5) / Made available in DSpace on 2016-03-04T00:31:31Z (GMT). No. of bitstreams: 1 HerbertSenzanoLopes_DISSERT.pdf: 1964831 bytes, checksum: a1f3b710808bf3ed42490612f2700bca (MD5) Previous issue date: 2014-12-23 / A parte pesada do petr?leo pode ser utilizada para in?meras finalidades, uma delas ? a obten??o de ?leos lubrificantes. Com base nesse contexto, muitos pesquisadores v?m estudando alternativas de separa??o desses constituintes de petr?leo bruto, entre elas pode ser citada a destila??o molecular, uma t?cnica de evapora??o for?ada diferente dos outros processos convencionais presentes na literatura. Este processo pode ser classificado como um caso especial de destila??o a alto v?cuo com press?es que chegam a atingir faixas extremamente baixas da ordem de 0,1 Pascal. As superf?cies de evapora??o e de condensa??o devem apresentar uma dist?ncia entre si da ordem de grandeza do percurso livre m?dio das mol?culas evaporadas, isto ?, as mol?culas evaporadas facilmente atingir?o o condensador, pois as mesmas encontrar?o um percurso sem obst?culos, o que ? desej?vel. Logo, a principal contribui??o deste trabalho consiste na simula??o do processo de destila??o molecular de filme descendente do petr?leo. O petr?leo bruto foi caracterizado utilizando o UniSim? Design R430 e o Aspen HYSYS? V8.5. Com os resultados desta caracteriza??o foram efetuados, em planilhas de c?lculo no Microsoft? Excel?, os c?lculos das propriedades f?sico-qu?micas dos res?duos de uma amostra de petr?leo, i.e., termodin?micas e de transporte. De posse dessas propriedades estimadas e das condi??es de contorno sugeridas pela literatura, foram resolvidas as equa??es dos perfis de temperatura e concentra??o atrav?s do m?todo de diferen?as finitas impl?cito utilizando a linguagem de programa??o Visual Basic? (VBA) for Excel?. O resultado do perfil de temperatura apresentou-se coerente com os reproduzidos pela literatura, havendo em seus valores iniciais uma leve distor??o em consequ?ncia da natureza do ?leo estudado ser mais leve que o da literatura. Os resultados dos perfis de concentra??o mostraram-se eficientes permitindo perceber que as concentra??es dos mais vol?teis diminuem e as dos menos vol?teis aumentam em fun??o do comprimento do evaporador. De acordo com os fen?menos de transporte presentes no processo, o perfil de velocidade tende a aumentar at? um ponto m?ximo e em seguida diminui e a espessura do filme diminui, ambos em fun??o do comprimento do evaporador. Conclui-se que o c?digo de simula??o em linguagem Visual Basic? (VBA) ? um produto final do trabalho que permite aplica??o para a destila??o molecular do petr?leo e de outras misturas similares. / The heavy part of the oil can be used for numerous purposes, e.g. to obtain lubricating oils. In this context, many researchers have been studying alternatives such separation of crude oil components, among which may be mentioned molecular distillation. Molecular distillation is a forced evaporation technique different from other conventional processes in the literature. This process can be classified as a special distillation case under high vacuum with pressures that reach extremely low ranges of the order of 0.1 Pascal. The evaporation and condensation surfaces must have a distance from each other of the magnitude order of mean free path of the evaporated molecules, that is, molecules evaporated easily reach the condenser, because they find a route without obstacles, what is desirable. Thus, the main contribution of this work is the simulation of the falling-film molecular distillation for crude oil mixtures. The crude oil was characterized using UniSim? Design and R430 Aspen HYSYS? V8.5. The results of this characterization were performed in spreadsheets of Microsoft? Excel?, calculations of the physicochemical properties of the waste of an oil sample, i.e., thermodynamic and transport. Based on this estimated properties and boundary conditions suggested by the literature, equations of temperature and concentration profiles were resolved through the implicit finite difference method using the programming language Visual Basic? (VBA) for Excel?. The result of the temperature profile showed consistent with the reproduced by literature, having in their initial values a slight distortion as a result of the nature of the studied oil is lighter than the literature, since the results of the concentration profiles were effective allowing realize that the concentration of the more volatile decreases and of the less volatile increases due to the length of the evaporator. According to the transport phenomena present in the process, the velocity profile tends to increase to a peak and then decreases, and the film thickness decreases, both as a function of the evaporator length. It is concluded that the simulation code in Visual Basic? language (VBA) is a final product of the work that allows application to molecular distillation of petroleum and other similar mixtures.

This thesis presents an application that performs positioning of modules automatically based on given data for every module, and the development of it. The basis of the application is from a previous thesis code. On top of that code, more features and error handling has been added, as well as fixes for various bugs. A stress test has been performed and further development possibilities are being presented. The thesis work was carried out at Toyota Material Handling Mjölby (TMH) and was made in parallel with another thesis by Fredrik Holden who was generating data for the application. For a complete understanding of the theory and background, please also read Holden’s thesis report “Development of method for automated positioning of 3D-representations of a modularized product”, as well as the former thesis  ”Analysis for Automated Positioning of 3D-representation of a Modularized product””. / Detta examensarbete presenterar en applikation som positionerar moduler automatiskt med hjälp av given data för varje modul, samt utvecklingen av applikationen. Applikationen bygger på kod från ett tidigare examensarbete. Ovanpå den koden har flera egenskaper och felhanteringar lagts till, samt har olika buggar fixats. Ett stresstest har också utförts och framtida utvecklingsmöjligheter presenteras. Examensarbetet genomfördes på Toyota Material Handling Mjölby (TMH) och gjordes parallellt med ett annat examensarbete av Fredrik Holden som genererade data för applikationen. För en fullständig förståelse angående teorin bakom samt bakgrunden till examensarbetet, vänligen läs också Holdens rapport ”Developmentof method  for automated positioning of 3D-representations of a modularized product”, samt rapporten från föregeånde examensarbetet ”Analysis for Automated Positioning of 3D-representation of a Modularized product”.

This thesis follows up two views on the data migration project. First of all there is a basic description of data migration within MBI model. This model is created by information technology department on the University of Economy in Prague. The thesis fills in this model data migration task and related objects as task roles or documents. In the next part the thesis focus on concrete project of implementation of core banking system. More detail is dedicated to the data migration part of this project. First there are described principles of work in data migration and next the thesis aims on data model of data migration which is used as a documentary tool. This model is evaluated from the benefits and risks view for data migration and next there are described creation and updating of it. These activities are provided mostly by macros in VBA script language, which are created here for these purposes. In the end some options of model extension are designed and evaluated.