Dissertations / Theses on the topic 'Visual Basic for Applications (VBA)'

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.

The task of the diploma thesis named VBA and Maple Application on Process Engineering Problems is to show the possibilities of using these programming languages for various engineering tasks. Particularly the programming language Visual Basic for Application (VBA), which is a part of MS Office package, is very little used in practise. That´s why this thesis solves the complex task of a furnaces design process; the topic was reccomended by the supervisor prof. Ing. Josef Kohoutek, CSc. Specifically, the thesis deals with calculations of heat transfer and optimization of the height of extended surfaces of tubes in the convection section of process furnaces. The entire task is elaborated in VBA and runs in Excel. After entering the input information, the created program first calculates the size and heat output of the convection section, but it can also optimize the height of extended surfaces in different parts of the convection section and thus minimize investment costs.

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.

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 graduation thesis deals with evaluation of power and coolant flow in reactor core. The first part is a description of nuclear power plant VVER 440. It is focused on parts important for transfer and utilize energy in regular operating of generating block. In the second part, the equations for calculation of power and coolant flow in reactor core are deduced. The last part is about designing the program for calculation of published values. There are specified requirements for the program and on the basis of this the source code is written. The parts of code are described. In conclusion of this part, the user's manual is work out. The program is on CD in the annexe.

The master’s thesis deals with the use of fuzzy logic for evaluating the quality of suppliers of IT goods and other material for a selected company. The fuzzy model should facilitate decisions when selecting individual suppliers who should deliver goods for the implementation of IT projects. The model created in Microsoft Excel and MathWorks MATLAB should be helpful to the company's management and sales representatives.

Theme of this master’s thesis is design of software support for business intelligence. Design is realized in cooperation with corporation ZZN Pelhřimov a.s. Introduction is focused on theoretical description of business intelligence and datamining and also on development environment in which is project designed. Corporation is characterised also in introduction. Main part contains data collecting and definition of individual modules. In conclusion of this thesis will be several types of analysis from collected data and then according to these analysis, we can draw measures to improve current state of corporation.

UCTOLD, IAWPRC and UCTPHO are activated sludge system diurnal simulation software programs written and compiled in TurboPascal 3.1 by the Water Research Group at the University of Cape Town in the late 1980s and early 1990s. IAWPRC is identical to International Water Association (IWA) Activated sludge Model No 1 (ASM1, Henze et al., 1987) and UCTOLD is an earlier variation of ASM1 that makes no material difference to simulation results when each are run with their default parameters – the difference is explained by Dold and Marais (1985). Details on the use of UCTOLD and IAWPRC was published by Dold et al. (1991) and this guide remains essential reading for the responsible use of the recoded UCTOLD and UCTPHO presented in this thesis. In the early 1990s, when the kinetics of phosphorus accumulating organisms (PAO) were sufficiently well understood, biological excess P removal (BEPR) was added to UCTOLD to yield UCTPHO. This software has the same look and feel as UCTOLD/IAWPRC and so a guide for it was never published. Details of the BEPR research that was codified into it are given by Wentzel et al. (1991) and Clayton et al. (1991). Later, much of the Wentzel BEPR model was integrated into ASM1 to form ASM2 (Henze et al., 1995). So UCTPHO and ASM2 differ in the same way as UCTOLD and ASM1/IAWPRC differ, essentially only in the fate of the product of the hydrolysis of slowly biodegradable particulate organics (BPO) – in ASM1/2, this product enters the bulk liquid as readily biodegradable soluble organics (BSO) with the ordinary heterotrophic organisms (OHO) utilizing only BSO, whereas in UCTOLD/UCTPHO the BPO product is utilized directly by the OHO and so does not enter the bulk liquid (Dold and Marais, 1985). One aspect is very important to note about the models embedded in these codes – UCTOLD and ASM1 are only for biological N removal systems and UCTPHO and ASM2 are only for biological N and P removal systems. One cannot simulate a N and P removal system with UCTOLD (or ASM1) and one cannot simulate a N removal system only with UCTPHO (or ASM2). The kinetics of denitrification in UCTOLD/ASM1 and UCTPHO/ASM2 are not the same - the details of the differences are explained by Clayton et al. (1991). For two decades up to around 2010, UCTOLD and UCTPHO provided free activated sludge system simulation tools to consultants, municipalities and operators to predict the performance of the activated sludge systems of wastewater treatment plants. Therefore smaller consultancies had the software available for use without requiring expensive commercial software for the modelling of household/municipal wastewater. With the advancement of computer hardware and Windows operating systems over two decades, the UCTOLD and UCTPHO software (not the models coded within them) grew outdated and gradually lost functionality. Then when 64 bit processor personal computers (PC) became available, the old compiled TurboPascal 3.1 software could no longer be run – they can still run on 32 bit processor WinXP PCs. Re-coding the software was therefore required if the continued use of the software were to be ensured. This recoding into Excel/VBA was undertaken in this thesis. Some considerable effort also went into the improvement of the user interface. The new interface allows quick input and configuration of the biological reactors of the activated sludge system, and the recycle streams. Several challenges presented themselves during the recoding stage of the project, most notable of which were the data management structures and the calculation time minimisation. Also, significant time was also spent on simulations to determine the effects of the integration parameters on calculation time, and to determine how to minimise the calculation time. After struggling with these challenges for some months, the recoded programs started to present results similar to the original TurboPascal compiled code, about a year after commencement with the project. This Beta version has the same functionality that the original Turbo Pascal versions had including Adjustment of the Wastage Pattern and Graphical Display of Diurnal Results. The calculation of activated sludge ISS concentration was added as an option by including the influent OHO and PAO ISS to determine reactor TSS concentration for N and N&P removal systems using results from Ekama and Wentzel (2004). So, instead of having to enter an activated sludge VSS/TSS ratio, the option to calculate it from entered influent VSS and TSS data can now be selected to calculate the reactor TSS concentration.

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.

Railways are one of the largest transportation networks in the world that play an important role in the mass transportation of both the passengers and freight. The speed of trains and as well as the axial load carrying capacity have been increasing significantly during the past few decades to keep in pace with the population and economy growth and to compete with other modes of transportation such as the road, air and water transportation system. Billions of dollars are spent annually for maintenance of rail tracks in the world. The efficient and optimum use of these funds is a challenging task that demands innovative and cutting edge technologies in railway engineering. The railway subgrade is an important part of railway foundation and should be capable of providing a suitable base supporting the ballast and subballast to accommodate the stresses due to traffic loads without failure or excessive deformation. The progressive shear failure is a well-known and age old challenging problem for railways over the world for centuries. The subgrade of railway track which typically constitutes of fine-grained material tends to fail through the accumulation of soil movements up- and sideward developing a path for the least resistance along which progressive shear failure occurs under repeated train-induced loads and due to the effects of climate factors. To-date, limited number of studies have addressed failure mechanism associated with the progressive shear failure, especially using the mechanics of unsaturated soils. In this thesis, a novel and first of its kind, Visual Basic program developed in AutoCAD environment based on Mohr-Coulomb failure criteria and unsaturated soil mechanics theory. This program is capable of taking account of the influence of matric suction and simulate progressive shear failure in the subgrade under moving train. Simulation results suggest several parameters that include stress distribution, matric suction, cohesion, coefficient of lateral earth pressure at rest, and coefficient of residual friction as well as the angle of internal friction have a significant effect on the progressive shear failure and the shape of failure planes in the subgrade. The progressive shear failure in subgrade can be reduced by increasing matric suction, cohesion, coefficient of lateral earth pressure at rest, and coefficient of residual friction as well as the angle of internal friction, and optimizing combination of these parameters. The simulation results suggest the progressive shear failure can be well simulated with the Mohr-Coulomb failure criteria. Several suggestions are made for railway subgrade construction and maintenance based on the results of this study.

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.

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.

Thesis submitted in fulfilment of the requirements for the degree Doctor of Technology: Design in the Faculty of Informatics and Design at the Cape Peninsula University of Technology 2013
Digital drawing and animation, using basic computer software, opens up new possibilities in creative practice-­‐led research. The digital medium, with its relative ease of reproduction and storage of images, facilitates a reflective method of thinking-­‐while-­‐ drawing, thereby stimulating the creative process and providing a unique means of reflection-­‐in-­‐action. The computer’s ability to record images allows for temporal disruption, providing possibilities for exploring alternative creative solutions as well as retrospective, reflection-­‐on-­‐action. This thesis presents an interrogation of the researcher’s creative practice, as well as the findings and creative artefacts of other relevant practitioners in the field of digital drawing, animation, and related creative activities. A reflexive methodology was used to investigate the relationship between making, doing, and knowing in creative practice. The findings are supported by creative outputs (making), reflection on the creative process in relation to supporting literature (doing), and knowledge resulting from this reflection together with related theoretical research (knowing). The research revealed that digital drawing and animation supports new modes of making resulting in the production of original creative artefacts. It was further revealed that in relation to “doing”, the digital medium supports reflective practice by enabling the creative practitioner to document and reflect on these outputs both during and after making. The resulting reflexive actions combined with theoretical research lead to revelations concerning the relationship between thinking and drawing when using digital media as well as in a broader sense. The study thus contributes insights concerning art and design thinking, and makes a contribution to new developments in visual arts and design research. Practice-­‐led research introduces a theoretical paradigm that has methodological implications particularly in the context of the current re-­‐structuring and transformation of art and design education at South African Universities of Technology. The findings indicate that digital drawing and animation can encourage a critical and reflective approach not only in the work of creative practitioners by supporting new modes of making, but that it also has positive implications for visual arts research and teaching. In this regard the research highlights the need for promoting the integration of theory and practice in visual arts and design education curricula.

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.

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.

The diploma thesis is focused on the creation of a program enabling calculation of selected economic indicators of Arbela s.r.o. The thesis is divided into a theoretical and practical part. The content of the theoretical part is a description of individual methods and procedures of financial analysis, description of principles of time series, and regression analysis. In the practical part, the program created to calculate the selected economic indicators of the company Arbela s.r.o. is presented. These indicators are subsequently evaluated and foreseeable development of the company is determined for the future. At the end of the thesis, solutions for possible improvement of the economic situation of the company can be found.

Pour répondre aux attentes de clients de plus en plus exigeants, les entreprises d'aujourd'hui doivent accroître leur compétitivité, leur productivité et leur réactivité. Pour répondre à ces exigences, la fonction ordonnancement se doit d'être plus réactive, plus performante et plus adaptée aux spécificités des compagnies. Parmi les différentes possibilités d'évolution de l'ordonnancement, la voie de l'ordonnancement interactif semble répondre à ces besoins, et parmi les approches possibles de l'interactivité, l'utilisation d'indicateurs permet au gestionnaire d'atelier de connaître toutes les données nécessaires à la mise au point d'un ordonnancement performant. Quatre types d'indicateurs ont été définis : - des indicateurs de contexte décrivant l'état général de l'atelier, - des indicateurs de diagnostic aidant à identifier les causes de problèmes courants, - des indicateurs d'action renseignant sur la pertinence et l'efficacité de l'utilisation des degrés de liberté, - des indicateurs de performance, évaluant les performances de l'ordonnancement par rapport aux objectifs de l'entreprise. Cette approche de l'ordonnancement interactif a été appliquée à deux problématiques actuelles. Des indicateurs spécifiques à ces deux problèmes ont été définis. La première application concerne la prise en compte dans l'ordonnancement de commandes incertaines, encore en cours de négociation. La deuxième application concerne la gestion des opérateurs de production à court terme, au niveau de l'ordonnancement. Un outil de construction de tableaux de bord mettant en oeuvre ces différents indicateurs a été réalisé dans le cadre d'un projet européen (le projet ASPIRE).

Il lavoro di questa tesi di laurea è incentrato sullo studio di un modello che permette di valutare numericamente la similarità dei prodotti che vengono processati in un sistema riconfigurabile. Tra i modelli esistenti in letteratura, è stato scelto il modello di Galan. Tale modello permette di definire il livello di similarità tra prodotti diversi e, infine, tramite l’uso di un algoritmo gerarchico agglomerativo, definisce le diverse famiglie di prodotti. L’obiettivo di questo modello è pertanto quello di fornire un supporto alla formazione di famiglie di prodotti in sistemi produttivi riconfigurabili. In particolare, è essenziale minimizzare il numero di famiglie e, di conseguenza, ridurre il numero di riconfigurazioni. In questo elaborato è stato implementato un tool applicativo in Excel tramite il linguaggio Visual Basic for Applications, consentendo di automatizzare il modello scelto con un interfaccia grafica guidata per l’utente. Il tool consente di visualizzare le famiglie che si formano e che potranno essere lavorate nella stessa configurazione dai RMS. Una volta ottenute le diverse famiglie di prodotti, si valuta il costo legato a questo paradigma produttivo ed è confrontato con le altre due modalità produttive, ovvero la produzione tramite DML, che presuppone la presenza di una linea per ogni tipologia di prodotto, e la produzione tramite FMS, che prevede l’utilizzo di una macchina flessibile per ogni famiglia di prodotto differente. Il tool consente di effettuare una considerazione economica tramite il calcolo del costo totale annuo equivalente (CTAE), che permette di definire come KPI il costo di realizzazione di un singolo prodotto. In questo modello, si tiene conto anche della capacità produttiva necessaria: infatti, aumentando il volume produttivo, sarà necessario aumentare le risorse dedicate ai tre diversi paradigmi e quindi, a fronte di elevati investimenti, la convenienza economica dei RMS verrà meno, favorendo un uso di linee dedicate.

L’obiettivo di questa tesi è quello di implementare un tool applicativo, nel linguaggio Excel VBA, che consenta di analizzare un modello applicabile per i Reconfigurable Manufacturing System (RMS). Tra i modelli trattati in letteratura,si è scelto quello sviluppato da Galan si pone l'obiettivo di definire le famiglie di prodotti in RMS. Per studiare la validità del modello, si è preso in esame lo stato attuale delle industrie produttivo-manifatturiere, il quale si compone di linee dedicate, denominate DML, e/o flessibili, chiamati FMS. I sistemi RMS, invece, rappresentano una nuova frontiera produttiva. Tramite Visual Basic for Application (VBA) si è strutturato l’ambiente di lavoro, automatizzando il modello di Galan e ottenendo le famiglie di prodotti in base alla similarità degli stessi. Successivamente si è voluto dare la possibilità all’utente di valutare la convenienza economica nella scelta di un tipo di sistema produttivo piuttosto che un altro. In particolare si è deciso di definire un criterio omogeneo di valutazione finale, utilizzando lo stesso KPI per tutte e tre le tipologie di sistemi, ossia il costo totale annuo equivalente (

Goal programming is an approach for solving decision problems. The aim of this doctoral thesis is to show the practical use of this approach for solving real problems. The first chapter brings a brief introduction to multicriteria decision making. The second chapter is devoted to goal programming, its history, theory, criticism and also to its practical applications. The third chapter deals with description of a model for optimisation of white mass production. This model utilises the goal programming principle to deal with measuring deviations of raw materials' composition. A part of this chapter is a presentation of OPTIPROT, an application that implements the mentioned model. In the fourth chapter there are described three mathematical models for timetabling at a department level; two multistage models and one complex model. All three models are formulated utilising goal programming. In this chapter there is also described an application that implements the complex model for timetabling.

This diploma thesis disserts mainly on the software application development created through language Visual Basic for Application, which serves to creation of macros and automation of work in Microsoft Excel. The Application is made specially for company PENTACO, spol. s.r.o. The software allows to calculate complete financial analysis of company for last 8 years. Statistical methods are used for prediction of future indicators. The financial analysis will reveal the weaknesses and strengths of the company and on their basis will be suggested solutions for fixing of problems and company situation.

Clean and safe water is important for the well being of all organisms on earth. Therefore, it is important to reduce harmful emissions from industrial processes that use water in different ways. In vehicle washing processes, water is used in high-pressure processes, as a medium for detergents, and for rinsing of vehicles. The wastewater produced by these functions passes through a water reclamation system. A water reclamation system has two main functions, to produce reusable water to be used in future washing cycles, and to separate contaminants and purify the wastewater so it can be released back into the commercial grid. The reclamation system achieves this by using a combination of different water handling processes, these include: sludge tanks, an oil-water separator, a water reclamation unit, buffer tanks, and a water purification unit. The two components that stand for the more advanced cleaning processes are the water reclamation unit and the water purification unit. In this thesis, in collaboration with the company Westmatic, the water reclamation unit consists of cyclone separators that use centrifugal forces to separate heavy particles and ozone treatment to break up organic substances and combat bad odors. The Purification unit of choice is an electrocoagulation unit that, by a direct current, creates flocculants of impurities that rises to the surface and can be mechanically removed in a water volume inside the unit. This purification process is completely chemical-free thus making the process more environmentally friendly than other purification processes used in other circumstances. This master thesis aimed to develop a dynamic design tool for a modular solution of the different parts in the water reclamation system. This design tool uses specific user input to produce construction information for each instance. As an additional sub-aim, this design tool was linked with a computer-aided design program to produce parametric 3D models with underlying blueprints. This to produce a light solution, that has a short manufacturing time and that are highly customer adjusted. The first course of action was to mathematically define the complete water reclamation system and its components. These sections were described in a flowchart that shows how the different parts interact and operate. From the wash station, wastewater runs trough a course- and fine-sludge tank. From the fine sludge tank, the wastewater is directed in two different directions. Firstly, the water is pumped to the water reclamation unit and to one or multiple buffer tanks to finally be used in the wash station as reclaimed water. Secondly, the water travels to an oil separator, pump chamber, and water purification unit. In the purification unit, 99% of the inlet mass is directed out of the system as purified water. The remaining 1% is directed to a depot that acts like the end stage of the whole system. After all equations were defined and the design was related to the user-defined input flow the design tool was structured. The program of choice to house the design tool is Microsoft Excel. In this Excel document, a user interface with navigation was constructed and the intended user is directed through a series of input pages where input data is defined. This data is used in a normally hidden page where constructional dimensions are calculated. The constructional dimensions are displayed to the user on the second last page. At this stage the Excel document can be connected to a CAD program and 3D models with blueprints can be opened that depend on the output from the Excel file. Additionally, a pipe calculator is provided on the last page of the Excel document where pipe dimensions for different cases can be found. With this solution, glass fiber tanks are molded according to the resulting blueprints that are customer specific. In this way the solution is more adaptive and easier to handle. Additionally, the provided design tool enables an easier and more well-defined methodology when deriving the different needed volume and accompanied constructional dimensions for an arbitrary water reclamation system.

Mestrado em Métodos Quantitativos para a Decisão Económica e Empresarial
O presente trabalho final de mestrado tem como objetivo descrever o estágio realizado na Dancake Portugal S.A., no departamento de Planeamento e Controlo de Gestão. O tema centra-se na automatização dos processos da empresa. É explicado o processo de decisão e desenvolvimento dos produtos do estágio, nomeadamente de estruturas de dados elaboradas para a pós-implementação de um novo Enterprise Resource Planning, do processo de automatização do reporting mensal da empresa e do desenvolvimento de um painel para controlo de preços de matérias primas e materiais de embalagem adquiridos. Adicionalmente, são delineadas as principais contribuições e aumentos de produtividade que os produtos do estágio referidos anteriormente produziram na Dancake Portugal S.A., bem como os principais desafios ultrapassados no processo. Por fim, oferece-se uma perspectiva para a continuação do desenvolvimento dos produtos do estágio no futuro, através do início da automatização dos processos de gestão do departamento de Planeamento e Controlo da Dancake Portugal S.A.
This report aims to describe the internship fulfilled at Dancake Portugal S.A.'s department of Planning and Management Control, with its central theme revolving around the automation of the company's reporting of monthly results. The development of the internship's by-products is explained, namely the elaboration of data structures for the post-implementation of the company's new Enterprise Resource Planning, the process of automation of monthly reporting of results and the development of a panel designed to track acquired raw and packaging material prices. Moreover, the main contributions and productivity increases of the internship's by-products are analysed, as well as the main challenges that were overcome in the process. Finally, a future prospect is offered for continuing the development of automation of business processes at the department of Planning and Management Control, as well as other departments in Dancake Portugal, S.A.
info:eu-repo/semantics/publishedVersion

Les effets dominos ou cascade d’événements dans les industries et particulièrement dans les industries chimiques et de transformation, sont reconnus comme des scénarios d’accidents possibles depuis environ trois décennies. Ils représentent une préoccupation croissante, car ils ont le potentiel de provoquer des conséquences dévastatrices. L’effet domino, comme phénomène, est un sujet controversé lorsque son évaluation est nécessaire. L’examen de la bibliographie a démontré l’absence d’une définition commune et d’une procédure simple d’utilisation et précise pour son appréciation. C’est pourquoi l’un des objectifs de cette recherche est de formaliser les connaissances relatives aux effets dominos afin de comprendre les mécanismes de leurs occurrences. Pour ce faire nous avons étudié les paramètres à examiner pour déterminer la possibilité de cascade et être en mesure d’identifier les scénarios dominos. L’enjeu étant de permettre l’amélioration de la prévention du risque d’effet domino. L’autre objectif est donc de produire une méthode pour l’identification et l’analyse des effets dominos. Nous avons développé une méthodologie globale pour l’étude des effets dominos en chaîne initiés par des pertes de confinement. Elle permet l’identification et la hiérarchisation des chemins de propagation des accidents. Cette méthode facilite la prise de décision pour la prévention des effets dominos, tout en proposant un outil efficace et simple d’utilisation. Les résultats de l’étude sont fournis sous forme d’une hiérarchisation quantitative des équipements impliqués dans les scénarios dominos, en tenant compte des effets des conditions météorologiques et des mesures de maîtrise des risques existantes ou proposées.Cette hiérarchisation donne une idée claire des dangers que représentent les équipements par rapport aux accidents en cascade, en précisant si la dangerosité de l’équipement provient de sa capacité à initier ou à propager un effet de cascade.La méthode est basée sur une description topographique de la zone étudiée, incluant les caractéristiques de chaque équipement, et prend en compte les mesures de maîtrise des risques mises en œuvre par l’industriel. Elle repose sur deux phases principales : La première, est l’identification des chemins de propagation des accidents. Pour ce faire, la méthode d’analyse par arbre d’événements est utilisée. Les cibles potentielles sont déterminées en combinant les valeurs seuils d’escalade et les modèles de vulnérabilité (pour l’estimation de la probabilité d’endommagement). Cette première phase est implémentée sous MATLAB® et Visual Basic for Applications (VBA) afin de faciliter l’entrée des données, et l’analyse des résultats dans Microsoft Excel®. La deuxième phase est l’identification des équipements les plus dangereux vis-à-vis des effets dominos. Elle consiste à hiérarchiser les équipements impliqués dans les chemins de propagation, en fonction de leur vraisemblance à causer ou à propager un effet domino. L’algorithme qui effectue cette phase est codé sous VBA. La méthode a été conçue de façon à ce qu’elle puisse être utilisée sans qu’il soit nécessaire de s’appuyer sur les résultats des études de dangers. Néanmoins, si ces résultats sont disponibles, il est alors possible d’alléger certaines étapes de la méthode. Elle s’est révélée facile à utiliser, cela a été constaté lors de son application dans le cadre de projets et stages d’étudiants
Domino effects or cascading events in the chemical and process industries are recognized as credible accident scenarios since three decades. They are raising a growing concern, as they have the potential to cause catastrophic consequences. Domino effect, as phenomenon, is still a controversial topic when coming to its assessment. There is still a poor agreement on the definition of domino effect and its assessment procedures. A number of different definitions and approaches are proposed in technical standards and in the scientific literature. Therefore, one of this research objectives is to formalize domino effects knowledges in order to comprehend their occurrence mechanisms. Thus, the parameters that should be looked at so as to understand the escalation possibility and in order to identify domino scenarios, were analyzed. The aim is to improve domino effect hazards prevention, through the development of a methodology for the identification and the analysis of domino effects.We developed a method for the analysis of domino accident chain caused by loss of containments. It allow the identification and prioritization of accident propagation paths. The method is user-friendly and help decision making regarding the prevention of cascading events. The final outcomes of the model are given in form of quantitative rankings of equipment involved in domino scenarios, taking into account the effect of meteorological conditions and safety barriers. The rankings give a clear idea of equipment hazard for initiating or continuing cascading events.The methodology is based on a topography of the industrial area of concern, including the characteristics of each unit and accounting for protection and mitigation barriers. It is based on two main stages. The first is the identification of accident propagation paths. For this, the event tree method is used. The possible targets are identified combining the escalation thresholds and vulnerability models (to estimate damage probability). This first stage was implemented using the MATLAB® software and Visual Basic for Applications (VBA) to enable an easy input procedure and output analysis in Microsoft Excel®.The second stage is the identification of the most dangerous equipment. It consists in prioritizing equipment involved in the propagation paths according to their likelihood to cause/propagate domino effect. The algorithm that performs this phase was coded in VBA.The method was designed so as it can be used without the need to rely on the results of safety reports. However, if such results are available, it is possible to lighten some steps of the method. It revealed easy to apply, this was confirmed through projects and student internships
Gli effetti domino, in cui un primo incidente causa in cascata altri scenari incidentali, sono tragli scenari incidentali più severi che avvengono nell’industria chimica. Nonostante l’attenzioneche anche la normativa dedica a tali scenari, la valutazione dell’effetto domino è un soggettocontroverso. L’analisi della letteratura tecnica e scientifica ha mostrato l’assenza di unadefinizione comune di « effetto domino » e di una semplice procedura per l’identificazione ditali scenari. È per tale motivo che uno degli obiettivi di questo lavoro di ricerca è diformalizzare le conoscenze relative agli effetti domino al fine di meglio comprendere imeccanismi che possono provocarli. A tal proposito sono stati studiati i parametri necessariper determinare la possibilità dell’insorgere di cascate di eventi e per essere in grado diidentificare i possibili scenari incidentali dovuti ad effetto domino. L’obiettivo finale del lavoroè stato di sviluppare un metodo per l’identificazione e l’analisi quantitativa della propagazionedi incidenti primari nell’ambito di scenari dovuti ad effetto domino.E’ stata sviluppata una metodologia generale per l’analisi degli effetti domino causati daperdite di confinamento. Tale metodologia permette l’identificazione e la classificazione deipercorsi di propagazione degli incidenti. Tale metodo facilita inoltre la prevenzione deglieffetti domino, proponendo uno strumento efficace e semplice da utilizzare.I risultati di questo studio sono forniti in forma di una classificazione delle apparecchiaturecoinvolte in scenari dovuti ad effetto domino, tenendo conto degli effetti delle condizionimeteorologiche e delle misure esistenti per la gestione del rischio. Tale classificazione fornisceanche un chiara idea dei pericoli rappresentati dalle singole apparecchiature nel caso diincidenti in cascata, in quanto precisando se la pericolosità delle attrezzature proviene dallaloro capacità di innescare o propagare un reazione a catena.Il metodo è basato su una descrizione topografica del sito studiato, che comprende anche lecaratteristiche di ogni attrezzatura, che tiene conto delle misure di gestione dei rischi e dellebarriere di sicurezza presenti, basato su due fasi principali. La prima è l’identificazione deipercorsi di propagazione degli incidenti. A tale scopo è stato utilizzato un metodo basatoVIsull’albero degli eventi. I potenziali bersagli vengono determinati combinando i valori di sogliaper la propagazione degli eventi ed i modelli di vulnerabilità delle apparecchiature. Questaprima fase è implementata in MATLAB® e Visual Basic for Applications (VBA) in modo dafacilitare la gestione dei dati e l’analisi dei risultati in Microsoft Excel®.La seconda fase è l’identificazione delle apparecchiature più pericolose per gli effetti domino.Tale fase consiste nel classificare le apparecchiature coinvolte nei percorsi di propagazione infunzione della loro capacità di causare o propagare un effetto domino. L’algoritmo dedicato inquesta fase è eseguito su VBA.I risultati ottenuti anche nell’applicazione ad un caso di studio hanno evidenziato le potenzialitàdel metodo, che rappresenta un significativo progresso nell’analisi quantitativa dell’effetto domino

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.

This projects aims to develop design automation in product development. Design automation causes increase in producibility and decrease in product cost and manufacturing lead time. The study at hand is proposed to provide a new method and to introduce procedure to the design of wiring pattern for a car seat heater for Kongsberg Automotive, KA. KA is a Norwegian company and a global provider of engineering, design, and manufacture for seat comfort, driver and motion control systems, fluid assemblies, and industrial driver interface products. The method that currently is used in the company to create a wiring pattern is neither sufficient enough nor automated. In order to design the wiring pattern, at first procedure is handled by the designer. Secondly, car seat heater 2D layout is imported and then, the dimensions of the elements are defined as constraints. Then VBA codes are opened and the program is run. The result will be a wiring pattern in different 2D layouts. To make the design process easier, we have modeled five different layouts; wiring pattern of one element, two elements, three elements, five elements (with two back sides) and one element trapezoidal 2D layout. The algorithm written in VBA (Visual basic for application) creates the pattern according to the dimensions of the elements which are used as inputs to define constrained parameters. The created macros are simple to use and easy to modify, independent from the programming knowledge. The user is only responsible with parameter input and running the program. The solution gives wiring pattern for a car seat heater.

This thesis deals with technical analysis, which is used to predict future development of stocks. The first part describes the theoretical background needed for the next section. This is followed by analysis of the current state, which assesses the current situation. The main part is devoted to the creation of a program to support technical analysis for the novice investor and the demonstration of its use in trading.

The master's thesis focuses on supporting the development of applications using mathematical and statistical methods. This is used in the thesis to effective management of inventory for the store and e-shop. For this purpose, an application in VBA programming language has been developed to help the company to keep track of the inventory and find the optimum insurance stock level for ordering new goods.

This thesis focuses on the support of software applications development using mathematical and statistical methods. One of the topics related to this issue is inventory management. The thesis deals with inventory management in the pizzeria, which I have thoroughly analyzed and based on the data and methods needed to design a software application to simplify and accelerate the supply of raw materials.

La connaissance des vitesses des ondes ultrasonores traversant un matériau monolithique composite permet de déterminer ses rigidités et constantes élastiques associées. Un logiciel, celmaus, développé en visual basic, permet l'obtention de l'ensemble des composantes élastiques d'un matériau sain ou endommagé (par impact poids tombant et fatigue post-impact). Cet outil se base sur la transformation par le tenseur de Christoffel des vitesses des ondes ultrasonores en rigidités. Le concept des surfaces de rigidités a été développé pour rendre compte de l'évolution de la rigidité du matériau selon les plans d'investigation choisis. Le calcul s'effectue par la résolution numérique en minimisation d'une fonction seuil liée aux valeurs propres du tenseur de Christoffel définies expérimentalement. Une comparaison avec les essais mécaniques, la littérature et des valeurs obtenues par modélisation tridimensionnelle ont permis de valider ce logiciel. Les matériaux de l'étude présentent des taux d'anisotropie plus ou moins élevés pouvant exprimer des termes de couplage hors plan. Afin de suivre l'endommagement, une étude basée sur l'analyse de cartographies c-scan est également engagée. Différents logiciels développés sous la configuration matlab et visual basic permettent de caractériser les mécanismes d'endommagement présents. Certains paramètres sont en premier lieu définis sur matériaux sains (delimfft) afin d'établir un état de référence. Une visualisation 3d (vis3d) des surfaces impactée et non impactée permet de localiser et de déterminer les dimensions de l'endommagement dans sa forme globale (double cône d'endommagement, cratère, bombement. . . ). Une visualisation dans l'épaisseur (visendo) pour un état donné d'endommagement ou d'un état endommagé à un autre permet d'associer des codes couleur à des mécanismes d'endommagement spécifique. Des observations directes du matériau et a partir de cliches obtenus au meb ainsi que le traitement en amplitude des signaux d'émission acoustique ont permis de corroborer ces associations.

La nappe de la craie du Nord de la France est actuellement confrontée à des concentrations en nitrates qui dépassent les limites fixées par la directive européenne sur les nitrates. Dans le secteur de Lens (Pas-de-Calais), l’alimentation en eau potable se fait principalement dans cette nappe, où les concentrations en nitrates peuvent atteindre 100 mg/l. A quelques kilomètres au Nord (17 km de Lens), la nappe de la craie devient captive et il se produit une dénitrification naturelle qui assure une bonne qualité de l'eau. La gestion de la ressource en eau dans le secteur de Béthune, nécessite la réalisation d’une modélisation numérique qui s’est avérée comme un outil très performant pour comprendre le fonctionnement hydrodynamique des aquifères.L’utilisation de Systèmes d'Information Géographique (SIG) offre une plate-forme intégrée de gestion, d’analyse, de modélisation, d'affichage et d’aide à la décision. Une méthodologie basée sur la combinaison des SIG, la modélisation hydrogéologique, la modélisation hydrodispersive et les réseaux de neurones artificiels (RNA), a été adoptée pour orienter la gestion des eaux souterraines. Un modèle hydrodynamique a été créé par le code Modflow à l’aide d’un SIG. Un modèle conceptuel de données MCD préparé selon la méthode HBDS a permis de visualiser les liens qui existent entre les différents phénomènes étudiés. Le modèle physique de données MPD représenté par les geodatabases, a été réalisé pour structurer l'information spatiale (géographique) et/ou aspatiale (thématique). Le traitement, la manipulation et la création des données d’entrée ont été réalisés à l’aide d’un modèle conçu dans ArcGIS. Deux simulations ont été faites, en régime permanent pour caler le modèle, puis en régime transitoire pour étudier l’impact de prélèvements dans deux puits situés à Béthune. Le but recherché était de définir les débits optimums de prélèvements d'eau dans ces puits de manière à fournir une alimentation en eau potable dans secteur de Lens tout en préservant la capacité de dénitrification de l'aquifère exploité. Des scénarios de prélèvements, simulés par Modflow et à l’aide du RNA, ont été définis et testés pour des années sèches et humides au cours de la période 1972-2008. Un modèle de transport de nitrates a été créé par le code MT3D, et comparé avec un autre modèle basé sur un couplage entre le (RNA) et le (SIG) pour la prédiction spatiale de pollution par les nitrates des eaux souterraines. Ce modèle couplé permet la création de cartes de distribution spatiale des concentrations en nitrates à différentes échelles de temps, sans création de modèles de transport qui s'appuient sur des équations mathématiques complexes et nécessitent beaucoup de données d'entrée. Afin de mettre à profit les résultats des modèles créés dans cette étude, un outil de consultation et de gestion des données (GWMV) a été créé dans ArcGIS en VBA (Visual Basic for Applications). Cet outil contient des interfaces qui sont crées dans le cadre de la gestion de l’aquifère de Béthune. L’utilisateur peut consulter les bases de données en entrées et en sorties de manière simple et efficace.Ces travaux, bien qu'appliqués à l’aquifère de Béthune, sont génériques. La méthodologie suivie peut être appliquée à plusieurs types d’aquifères. De même, les travaux de modélisation, d'analyses, de simulation, et de création des interfaces sont adaptables à des problématiques différentes
The chalk aquifer of northern France is currently facing nitrate concentrations above the levels specified in the European Nitrates Directive. In the urban area of Lens, the drinking water resource occurs mainly in this chalk aquifer, but its nitrate concentrations can reach 100mg/l. This modeling study focuses on the chalk aquifer located in Béthune (17 km from Lens), which provides natural denitrification and ensures a good drinking water quality The management of Béthune’s aquifer requires the implementation of a numerical modeling that has proven to be a powerful tool for understanding the hydrodynamic behaviour of this chalk aquifer. Geographic Information Systems (GIS) offers an integrated platform of management, analysis, modeling, display and decision support. In this research, a methodology, based on the combination of GIS, hydrogeological modeling by Modflow, transport modeling by MT3D and Artificial Neural Networks model (ANN), was adopted to support groundwater management. A numerical flow model was created by the code “Modflow” using a Geographic Information System. A conceptual data model CDM has been prepared according to HBDS method and this is to visualize the relationships between the different studied phenomena. The physical data model PDM presenting by geodatabases has been made mainly in order to structure spatial (geographic) and/or no spatial (thematic) information, treatment, handling and creating input data were performed with a model designed in ArcGIS 9.3.1 software. Two simulations were done, steady state simulation in order to calibrate the model and transient simulation to define an optimum level of water use from two wells located in Béthune’s aquifer so as to supply Lens with drinking water without reducing the aquifer’s denitrification capacity. Water usage scenarios are defined and tested (in Modflow and using RNA) for dry and for wet years over the period 1972-2008. A nitrate transport model has been created by the code MT3D, and compared with another model based on a coupling between ANN and Geographic Information Systems (GIS) which build for spatial nitrate prediction of groundwater. This coupled model allows to create spatial distribution maps of nitrates at different time scales without creating transport models that rely on complex mathematical equations and that require a lot of input data. To get better the results of models created in this study, a tool of consulting and data management (GWMV) was created in ArcGIS using the VBA. This tool provides interfaces that are created for Bethune‘s aquifer management. The user can view and consult the inputs and outputs data in a more simple and effective way

Dans cette thèse, sous étudions qualitativement et quantitativement le concept de l’agilité dans les supply chains. Notre travail est réalisé avec des professionnels de la chaire supply chain de CentraleSupélec, qui regroupe quatre groupes industriels (Sanofi, Safran LVMH et Carrefour). L'agilité est modélisée en fonction de deux éléments fondamentaux, la stimulation qui affecte l'activité de la supply chain et qui doit être traitée rapidement (c'est-à-dire les situations qui nécessitent agilité SNA), et les outils et méthodes permettant de répondre à ces stimulations (c'est-à-dire les leviers d'agilité). À partir d'une étude bibliographique et d'une enquête auprès de responsables en supply chain venant de divers secteurs industriels, nous proposons deux listes de situations qui nécessitent l'agilité et des leviers d'agilité. En utilisant les deux listes, nous construisons une matrice d'agilité qui permet d'évaluer qualitativement l'agilité de la supply chain.Par ailleurs, dans le but d'évaluer quantitativement l'agilité des supply chain, nous définissons deux nouveaux indicateurs permettant d'évaluer l'agilité d'une supply chain face à une situation nécessitant l’agilité. Pour calculer ces indicateurs, nous proposons une modélisation des flux physiques et d'information de la supply chain. Ensuite, nous implémentons le modèle en utilisant le langage VBA pour simuler le mouvement des flux informationnels et physiques de la supply chain lors de l'occurrence d'une situation de besoin d'agilité. De plus, nous développons un modèle d'optimisation, implémenté à l'aide de CPLEX, qui permet d’identifier les améliorations possibles de l'agilité, en tenant compte des contraintes financières. En conclusion, nous présentons un processus d'évaluation et d'amélioration de l'agilité de la supply chain qui utilise différents outils développés
This thesis addresses the topic of supply chain agility. Our work is carried out with professionals of the Supply Chain Management Chair of Centralesupelec that includes four industrial groups (Sanofi, Safran LVMH And Carrefour). We propose qualitative and quantitative approaches allowing to evaluate and improve agility, in the context of an end-to-end supply chain. First, we identify different situations that may affect the supply chain activity and that need to be treated rapidly (i.e. situations needing agility: SNA) as well as tools and methods allowing to respond to such situations (i.e. agility levers). We end up with two lists of situations needing agility and agility levers. Using the two lists, we build an agility matrix that allows to evaluate qualitatively the agility of a supply chain. Secondly, aiming to evaluate quantitatively supply chain agility, we define two new metrics that allow to assess the agility of a supply chain facing an SNA.To calculate these metrics, we propose a supply chain model that integrates parameters related to the physical and information flows such as production and transportation capacities and lead times, frozen planning horizons, safety stocks, etc. As another contribution, we develop an optimization model, implemented using CPLEX, that optimizes supply chain agility, taking into account financial constraints. Finally, we present a process for the evaluation and improvement of supply chain agility that is based on the different tools developed. The process includes eight steps going from the identification of a critical situation needing agility, to the validation of the actions to put in place to improve the agility of the supply chain facing it. Various theoretical and real cases studies are presented in the manuscript allowing to illustrate models and tools developed in this work

碩士
國立聯合大學
環境與安全衛生工程學系碩士班
95
This research built by using basic of NIDP, using coding to motivate and extended forming new calculate excellently. Using this research of calculate, after using the analysis sewer water pollution, conclude 11 basic parameter and 3 limited parameter, building 4 calculation mechanism, be the sewer water pollution system design mode.The research is using VBA programming, the surface of excel, combine the design mode and excel to build the program. Compare with the same limit condition cases, smaller vary of slope degree which in terrain can save up to 16.3% building cost, and save up to 33% buiding cost in bigger vary. From the cases to search up, more difficult on design terrain might get the better reseach result. It's also match in water with limit condition and reach the target of saving construction cost.

Com o crescimento e a competitividade das organizações, as suas atividades são de uma complexidade cada vez maior, com necessidade de serem executadas num espaço de tempo mais curto e requerendo um aumento de recursos humanos e funcionais. A otimização destes recursos pode ser considerada uma boa estratégia para dar resposta a um determinado problema existente numa organização. Tendo como base duas áreas de estudo de Engenharia e Gestão Industrial, a Gestão de Stocks e a Otimização de Processos, a presente dissertação baseia-se no desenvolvimento de dois casos de estudo, um para a Direção de Administração de Recursos Humanos e outro para a Direção Marketing Particulares, na Organização CTT. Os casos consistem no desenvolvimento de duas interfaces, uma para conceber o Mapa de Horários de Trabalho (MHT) e outra para implementar um plano de apoio à tomada de decisão e definição da quantidade ideal de produtos de terceiros a aprovisionar nas lojas CTT. Ambos os casos foram desenvolvidos com recurso a um software já existente na empresa, o Microsoft® Excel e o Visual Basic for Applications (VBA). Deste modo, o objetivo desta dissertação consiste em demonstrar a aplicação e consolidação dos conhecimentos académicos adquiridos e, por outro lado, o potencial e o benefício das interfaces desenvolvidas para o Grupo CTT. Com o primeiro caso de estudo, automatizou-se o processo de criação e validação do MHT através do desenvolvimento de um novo template, por forma a poupar tempo e diminuir a probabilidade de erros. Para atingir o objetivo do segundo caso, foi utilizada a metodologia análise ABC baseada na média simples e na média ponderada sustentada pelo alisamento exponencial. Dada a complexidade de ambas as interfaces, as funções básicas do Microsoft® Excel não foram suficientes para as desenvolver, pelo que as respetivas funcionalidades tiveram de ser programadas em código escrito na linguagem VBA, nível avançado. Para além dos resultados e benefícios alcançados para a organização com o desenvolvimento dos casos de estudo, este trabalho confirma, ainda, o potencial do Microsoft® Excel e do VBA, software existente na maioria das empresas, como uma alternativa para dar resposta a determinado problema.