Dissertação (mestrado)—Universidade de Brasília, Instituto de Geociências, Pós-Graduação em Geologia, 2015. / Submitted by Fernanda Percia França (fernandafranca@bce.unb.br) on 2016-02-25T11:38:58Z No. of bitstreams: 1 2015_FelipeValençadeOliveira.pdf: 5245176 bytes, checksum: 5a982ddd156db28d4bed918c900158db (MD5) / Approved for entry into archive by Guimaraes Jacqueline(jacqueline.guimaraes@bce.unb.br) on 2016-02-25T11:51:36Z (GMT) No. of bitstreams: 1 2015_FelipeValençadeOliveira.pdf: 5245176 bytes, checksum: 5a982ddd156db28d4bed918c900158db (MD5) / Made available in DSpace on 2016-02-25T11:51:36Z (GMT). No. of bitstreams: 1 2015_FelipeValençadeOliveira.pdf: 5245176 bytes, checksum: 5a982ddd156db28d4bed918c900158db (MD5) / A análise de isótopos de U-Pb por Laser Ablation Inductively Coupled Plasma Mass Spectrometry (LA-ICPMS) se popularizou nas geociências em função do seu custo relativamente baixo, da razoável precisão obtida e da velocidade com que os dados podem ser gerados. Para estudos que requerem grande quantidade de idades, como na análise de proveniência de bacias sedimentares, esse método mostra-se muito vantajoso. Entretanto, essa mesma velocidade de análise é acompanhada por um grande volume de dados a serem reduzidos. O projeto aqui descrito teve como objetivo o emprego de métodos computacionais na automação do processo de redução de dados. Utilizando a linguagem Visual Basic for Applications (VBA), intrinsecamente relacionada ao Microsoft Excel, todo as etapas de redução foram incluídas em único programa: Chronus. Por meio desse programa é possível escolher os parâmetros pertinentes à redução (tipo de detectores, padrões analisados, método de propagação de incertezas, etc.), importar os dados brutos automaticamente, corrigir o branco do método, corrigir as razões das amostras usando os padrões e finalmente calcular as incertezas. O Chronus cria um arquivo no formato excel com diferentes planilhas, nas quais são guardadas as confingurações escolhidas, as informações de cada etapa da redução e os resultados. A capacidade do Chronus para redução de dados U-Pb por LA-ICPMS foi testada usando análises dos padrões de zircão 91500 (1065 Ma, Wiedenbeck et al., 1995) e Plešovice (337 Ma, Sláma et al., 2008), tomando o zircão GJ-1 (608 Ma, Jackson et al., 2004) como padrão primário. A propagação das incertezas do GJ-1 nas análises foi feita de duas maneiras: considerando as incertezas das análises antes e depois das amostras ou usando o Mean Square of the Weighted Deviates (MSWD) das razões de interesse do padrão. A redução de um grande número de amostras permitiu a observação de intensidades não esperadas da massa 202. Esse fenômeno foi observado também especificamente nas análises dos padrões citados anteriormente. Há uma aparente relação entre o conteúdo de Elementos Terras Raras (ETR) dos zircões com as intensidades da massa 202, talvez devido à formação de óxidos de ETR durante o carreamento do material proveniente da câmara de ablação para os detectores. / The U-Pb analysis by Laser Ablation Inductively Coupled Plasma Mass Spectrometry (LA-ICPMS) became popular in geosciences due to its low cost, reasonable precision and rapid analysis. For studies that require a large number of ages, like in sediment provenance studies, this method is advantageous. Although, the high analysis speed is also followed by a big volume of data to be reduced. The project described in this dissertation had the objective to use computational methods to automatize the data reduction process. Using the Visual Basic for Applications programming language, which is intrinsically related to Microsoft Excel, all data reducing steps were included in a single program: Chronus. By using this program it is possible to choose the analyses’ settings (the type of collectors, the analyzed standards, the error propagation method, etc.), automatically import the raw data, subtract the signal of the blank from the samples, correct the samples’ ratios based on the standards’ analyses and calculate the uncertainties. Chronus creates a Excel spreadsheet with many sheets where the settings, the information of each step of data reduction and the results are stored. The capacity of Chronus to reduce U-Pb data obtained by LA-ICPMS was tested using analyses of the 91500 (1065 Ma, Wiedenbeck et al., 1995) and Plešovice (337 Ma, Sláma et al., 2008) zircon standards, using the GJ-1 standard (608 Ma, Jackson et al., 2004) as primary standard. Propagation of the GJ-1’s uncertainties into analyses was done by two different ways: taking into account the uncertainties of GJ-1’s analyses before and after the sample or using the Mean Square of the Weighted Deviates (MSWD) of the standard’s ratios. Reducing a large number of samples allowed the observation of unexpected 202 mass signal. This phenomenon was observed also in the zircon standards discussed previously. It seems to have a relationship between the zircon grains’ Rare Earth Elements (REE) contents and the 200 mass intensity. It might be due to the REE oxide formation during the material transport from the ablation chamber to the detectors.

This diploma thesis describes the design and creation of an application used to track Project Manager allocation in the company IBM Global Services Delivery Center Czech Republic. The first chapter contains theoretical information needed to understand the content of the thesis, while the second chapter focuses on analyzing the current status of this area. The third chapter then explores the options on how to solve the identified problem, and the best alternative is then chosen and created.

Apesar da complexidade envolvendo a compreensão dos processos hidrossedimentológicos, o conhecimento da quantidade de sedimentos transportados pelos rios é importante para o planejamento e aproveitamento dos recursos hídricos e não deve ser ignorado. Além disso, a quantidade de dados obtidos em monitoramentos é significativa, e o entendimento dessas variáveis requer obrigatoriamente análises estatísticas. Com base na dificuldade em relacionar hidrossedimentologia com estatística, buscou-se com esse trabalho desenvolver uma ferramenta computacional gratuita e de código aberto em Visual Basic for Applications (VBA) integrando métodos de cálculos hidrossedimentológicos e estatísticos. Ela permite que o usuário calcule descarga sólida em suspensão, descarga sólida total, e realize testes estatísticos como, teste Kolmogorov-Smirnov de normalidade dos dados, testes paramétricos F de Fisher-Snedecor e T de Student, além do teste não-paramétrico Wilcoxon. A ferramenta computacional (NH Sediment and Statistic) foi aplicada em dados obtidos em medições de características hidráulicas, da concentração de sedimentos em suspensão, turbidez e temperatura do reservatório da Pequena Central Hidrelétrica de Mogi-Guaçu (SP). Desse modo, a ferramenta utilizada para o suporte às análises hidrossedimentológicas alcançou resultados equivalentes a outros softwares para cada um dos módulos desenvolvidos, se mostrando confiável e de fácil aplicação. Destaca-se, por fim, que a ferramenta pode ser aplicada em outras áreas de estudo permitindo planejamento e gerenciamento completo de recursos hídricos, assim como outras áreas do conhecimento. / Despite the complexity that involves the understanding of hydrosedimentological processes, the knowledge of the amount of sediment transported by rivers is fundamental for the planning and utilization of water resources. The amount of data obtained from the monitoring is significant, and the understanding of such variables requires statistical analyses. This paper addresses the development of a free and open-source computational tool in Visual Basic for Applications (VBA) that integrates methods of hydrosedimentological and statistical calculations and relates hydrosedimentology to statistics. Users can calculate solid suspended discharge and total solid discharge and perform important statistical tests, such as Kolmogorov- Smirnov normality test, Fisher-Snedecor and Student T parametric tests, and Wilcoxon non- parametric test. The computational tool (NH Sediment and Statistic) was applied to data obtained from measurements of hydraulic characteristics, suspended sediment concentration, turbidity and reservoir temperature of the Mogi-Guaçu Small Hydroelectric Power Plant. It supports hydrosedimentological analyses and yielded results equivalent to those of other software for each module developed. It also proved reliable and of easy application and provides a friendly interface. It can be applied to other areas of study for a complete planning and management of water resources, as well as other areas of knowledge.

In this study, data on vibration measurements from Forsmark - Vattenfall AB's database has been studied, the goal has been to see how it can be reworked so that it becomes easier to interpret and more transparent for more people in maintenance.The idea has been to use all the data available to create graphs or graphs over a longer period to look for trends in systems that are similar to each other. Which is because there is redundancy in the systems and blocks 1 & 2 are sibling blocks with identical components, so it is possible to compare them.Furthermore, it is intended to implement the results from this work in balanced scorecards that are already used at Forsmark at present. This is done to obtain data on how the maintenance is going and how many machines need to be maintained compared to previous periods.The work has consisted of retrieving data files from Forsmark's database and via an Excel script that reworks all data so that graphs can be created of the various measurements performed regularly by the Maintenance Group NMM 1-3 (Mechanical Maintenance) at Forsmark.The results of the work have been verified through the special software that NMM 1–3 uses but in which other groups have no experience. In this special software all graphs and data are already available, something that is not as easy, however, is the ability to compare different machines at the same time, something that this thesis work tries to create.As others in maintenance do not have experience in the specialized software, Excel is used instead, as it is a program all groups have access to and good knowledge in. What emerges from the work is that the amount of data is very large but the possibility to get to the goal is good, the data files need some reworking to be easily used for graph creation and some things are unfortunately not included in the data files but must be downloaded from the special software NMM 1- 3 have. / I denna studie har data över vibrationsmätningar från Forsmark – Vattenfall AB:s databas studerats, målet har varit att se hur den ska kunna omarbetas så att den blir lättare att tolka och mer överskådlig för flera inom underhåll.Idén har varit att använda all den data som finns tillgänglig för att skapa graf eller grafer över längre tid för att leta efter trender inom system som är snarlika varandra, vilket finns eftersom det finns redundans i systemen och block 1 & 2 är syskonblock, så det går att jämföra mellan dem.Vidare är det tänkt att implementera resultatet från detta arbete i balanserade styrkort (Scorecard) som redan används på Forsmark i dagsläget, detta görs för att få in data över hur underhållet går och hur många maskiner som behöver underhållas jämfört med tidigare perioder.Arbetet har gått ut på att hämta datafiler från Forsmarks databas och via ett Excel script som omarbetar all data så att grafer kan skapas över de olika mätningar som utförs regelbundet av Underhållsgruppen NMM 1–3 (Mekaniskt underhåll) på Forsmark.Arbetets resultat har verifierats genom den speciella programvara som NMM 1–3 använder men som övriga grupper inte har erfarenhet av. Där finns alla grafer och all data redan att tillgå, något som inte finns lika enkelt är dock möjligheten att jämföra olika maskiner samtidigt, något som detta arbete försöker skapa.Då övriga inom underhåll inte har erfarenhet inom den programvaran så används Excel i stället, då det är ett program alla har tillgång till och god kunskap inom. Det som framkommer av arbetet är att mängden data är väldigt stor men möjligheten att komma till målet är goda, datafilerna behöver viss omarbetning för att enkelt kunna användas för graf skapande och vissa saker finns tyvärr inte med i datafilerna utan måste hämtas från specialprogramvaran NMM 1–3 har.

Supply planning is one of the key steps in an apartment building constructionproject, due to the repetitive nature of these projects where the constructionpace therefore has a crucial importance. However, if the working forceplanning and the materials planning are often acknowledged as important,the equipment supply planning can happen to be considered as secondary.Therefore less effort has been put in the tools used to make this planning.This master thesis is the result of a work in collaboration with the methodsdepartment at Eiffage Construction Habitat, one of the most important Frenchconstruction companies. It presents the implementation of a tool that automatesan important part of the equipment supply planning in order to gain efficiencyduring this planning process and to be able to focus deeper on the keyissues of the project. This tool allows to drastically reduce the time spentduring the supply planning for the equipment of the structural phase, bothregarding vertical works (walls and columns) and horizontal works (floors,beams and balconies). Along with making the planning more efficient, itallows to standardize the output documents and facilitate the work of theother departments with whom the methods department collaborates. Resultingfrom a case study and an internal survey, the implemented tool relies onthe Microsoft Visual Basic for Applications technology, allowing to staywithin the users’ range of mastered software, therefore improving the adoptionpotential of the tool. The results analysis showed a great satisfaction from theusers, both regarding the abilities of the tool and its form. / Resursplaneringen är ett av de viktigaste stegen i ett projekt för byggandeav flerbostadshus på grund av den repetitiva karaktären hos dessa projektdär bygghastigheten därför har en avgörande betydelse. Men om arbetskraftsplaneringenoch materialplaneringen ofta ses som viktiga kan planeringenav utrustningsförsörjningen råka betraktas som sekundär. Därför har mindreansträngningar lagts på de verktyg som används för att göra denna planering.Detta examensarbete är resultatet av ett arbete i samarbete med metodavdelningenvid Eiffage Construction Habitat, ett av de viktigaste franska byggföretagen.Arbetet presenterar implementeringen av ett verktyg som automatiseraren viktig del av planeringen av utrustningsförsörjningen för att få effektivitetunder denna planeringsprocess och för att kunna fokusera djupare på deviktigaste frågorna i projektet. Detta verktyg gör det möjligt att drastisktminska den tid som spenderas under leveransplaneringen för konstruktionsfasensutrustning, både när det gäller vertikala arbeten (väggar och pelare)och horisontella arbeten (golv, balkar och balkonger). Tillsammans med atteffektivisera planeringen möjliggör det att standardisera utdata och underlättaarbetet för de andra avdelningar som metodavdelningen samarbetar med.Till följd av ett studiefall och en intern undersökning är det implementeradeverktyget beroende av Microsoft Visual Basic for Applications-tekniken,vilket gör det möjligt att hålla sig till denprogramvara som användarnashar tillgång till och kan behärska, , vilket förbättrar möjligheter för attverktyget ska accepteras och använda verktyget. Resultatanalysen visade enstor tillfredsställelse från användarna, både vad gäller kan leverera och hurgränssnittet till användaren är utformat.

Tese de mestrado integrado. Engenharia Electrotécnica e de Computadores. Faculdade de Engenharia. Universidade do Porto. 2010

This thesis investigates problems in hierarchical games. Mathematical models are used in tennis to determine when players should alter their effort in a game, set or match to optimize their available energy resources. By representing warfare, as a hierarchical scoring system, the results obtained in tennis are used to solve defence strategy problems. Forecasting in tennis is also considered in this thesis. A computer program is written in Visual Basic for Applications (VBA), to estimate the probabilities of players winning for a match in progress. A Bayesian updating rule is formulated to update the initial estimates with the actual match statistics as the match is progressing. It is shown how the whole process can be implemented in real-time. The estimates would provide commentators and spectators with an objective view on who is likely to win the match. Forecasting in tennis has applications to gambling and it is demonstrated how mathematical models can assist both punters and bookmakers. Investigation is carried out on how the court surface affects a player�s performance. Results indicate that each player is best suited to a particular surface, and how a player performs on a surface is directly related to the court speed of the surfaces. Recursion formulas and generating functions are used for the modelling techniques. Backward recursion formulas are used to calculate conditional probabilities and mean lengths remaining with the associated variance for points within a game, games within a set and sets within a match. Forward recursion formulas are used to calculate the probabilities of reaching score lines for points within a game, games within a set and sets within a match. Generating functions are used to calculate the parameters of distributions of the number of points, games and sets in a match.

This Diploma thesis describes the design & development of a VBA application in Microsoft Excel. The goal of this thesis is to design & create a corporate VBA application for IBM that will help with the tracking of data from financial documents from suppliers. The application will generate summaries and insights, which will enable filtering, and will have the option to prepare reports for project managers and leadership.

Employees today have necessary daily tasks that do not require human handling. The objective is to investigate two processes if they are suitable for automation as well as to create and evaluate a prototype. The goals are to analyze the process, examine appropriate tools for automation, compare the tools, create and evaluate prototype, and perform an acceptance test. Robotic Process Automation is about automating tasks that humans have to do. Good candidates for automation are time-consuming, repetitive, rule-based tasks, prone to human er- rors with clear goals and expectations. The preliminary study was conducted in the form of a literature study of web-based sources, and the analysis was done by breaking down the process in different parts. The comparison was carried out by investigating the features of these tools. The prototype was created on Windows in UiPath tools and the robot will work on Internet Explorer and Excel, which will have a macro written in Visual Basic for Applications. The client will look at the criteria given and also on the prototype output and provide a subjective response. UiPath, Workfusion, and Selenium test programs were created. The prototype automatically logs on to Visma PX by entering username and password. Then it navigates, searches for an assignment and retrieves the data available. Indata is filtered and typed into Excel for each activity and employee. Finally, a macro creates graphs. Time tests show that UiPath is significantly more optimized and faster at completing the test programs. UiPath has strong benefits with its tools. / Anställda idag har nödvändiga vardagsuppgifter som inte kräver mänsklig inverkan och tanken är att frigöra dessa uppgifter. Projektets övergripande syfte är att undersöka två processer om de är lämpliga för automation samt att skapa och utvärdera en prototyp. Målen är att analysera processen, undersöka lämpliga verktyg för automatisering, jämföra verktygen, skapa en prototyp, utvärdera prototypen och utföra ett acceptanstest. Robotic Process Automation handlar om att automatisera uppgifter som människor gör. Bra kandidater för automatisering är tidskrävande, repetitiva, regelbaserade uppgifter, benägna till mänskliga fel med klara mål och förväntningar. Förstudien genomfördes i form av en litteraturstudie av webbaserade källor och analysen gjordes genom att bryta ner processen i olika delar. Jämförelsen genomfördes genom att undersöka de funk- tioner som verktygen har. Prototypen skapas på Windows i verktygen UiPath och roboten kommer att arbeta på Internet Explorer och mot Excel som kommer ha ett makro skrivet i Visual Basic for Applications. Beställaren kommer att titta på de kriterier som gavs och även på prototypens utdata och ge en subjektiv respons. Testprogrammen i UiPath, Workfusion och Selenium skapades med sina respektive funktioner. Prototypen loggar automatiskt in på Visma PX genom att skriva in användarnamn och lösenord. Sedan navigerar den i verktyget, söker på ett uppdrag och hämtar den data som finns. Indata filtreras och skrivs in i Excel för varje aktivitet och anställd. Slutligen körs ett makro som skapar grafer. Tidstesterna visar att UiPath är betydligt mer optimerad och snabbare på att slutföra testprogrammen. Jämförelserna visar att UiPath har starka fördelar med sitt verktyg.

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.