Tesis sobre el tema "Microsoft Visual Basic for Windows"

Main goal of this thesis is to create disassembler for Visual Basic 6 binary .exe files. There is description of Portable Executable files, description of disassembler, as well as functions of Windows API calls. Visual Basic disassembler should provide as much information about Visual Basic 6 file as possible. There is detailed structure specification of Visual Basic 6 binary files.

A windows based computer program to compute fish back-calculated lengths at age was created using Visual Basic 6.0© programming language. The objective of this project was to develop a computer program that is user-friendly and requires minimal user input to produce back-calculations. This program incorporates the familiar windows based graphical user interface and can compute up to 10,000 fish with a maximum age of 50 years. The input data can be imported from an Excel spreadsheet or manually entered directly to the program. Back-calculated lengths were computed using the traditional Lee method [ (L; = a + [ (L, - a) ( S; / Sc ) ]. Additional related statistical outputs are also included. The output data can be viewed using Excel where it can also be formatted for individual use. The program was compared with DisBcal using yellow perch age and length data. Results of the comparison were nearly identical with differences due to a rounding function of the output data.
Department of Biology

El presente informe muestra el diseño del programa “Riesgos Eléctricos”, cuyo objetivo es analizar los riesgos eléctricos en oficinas y centros cómputo, mediante la identificación de peligros y la propuesta de acciones correctivas. La lista de peligros que se muestra no es exhaustiva, en cada caso un Ingeniero Electricista tendrá que elaborar una lista propia, teniendo en cuenta el carácter de las actividades de trabajo y los lugares en los que se desarrollan. El Programador procederá a personalizar el software usando el código del programa que se muestra en el Anexo2 y la lista específica de peligros. El programa puede ser ejecutado por el administrador o el empresario, quien deberá contar con la colaboración del Ingeniero Electricista que se encargará de efectuar las mediciones e inspecciones que se requieran en cada caso. De esta manera el programa se convierte en una herramienta que le facilita a la empresa evitar los accidentes eléctricos. Este programa comprende los menús: Riesgos, Accidentes y Ayuda. Con el menú Riesgos permite identificar los peligros más frecuentes en: Tableros eléctricos, tomacorrientes, luminarias y conductores, y pozo a tierra; además señala las causas de los accidentes eléctricos y las sugerencias para evitarlas. Este prototipo muestra también, los equipos de seguridad más importantes, los efectos de la corriente en el organismo y la resistencia propia del cuerpo, las acciones a tomarse en caso de un accidente y la probable ubicación de las fallas dependiendo del equipo que se trate.
Tesis

Multi-tier enterprise systems consist of more than two distributed tiers. The design of multi-tier systems is considerably more involved than two tier systems. Not all systems should be designed as multi-tier, but if the decision to build a multi-tier system is made, there are benefits to this type of system design. CSCources is a system that tracks computer science course information. The requirements of this system indicate that it should be a multi-tier system. This system has three tiers, client, business and data. Microsoft tools are used such as Visual Basic (VB) that was used to build the client tier that physically resides on the client machine. VB is also used to create the business tier. This tier consists of the business layer and the data layer. The business layer contains most of the business logic for the system. The data layer communicates with the data tier. Microsoft SQL Server (MS SQL) is used for the data store. The database containsseveral tables and stored procedures. The stored procedures are used to add, edit, update and delete records in the database. Microsoft Transaction Server (MTS) is used to control modifications to the database. The transaction and security features available in the MTS environment are used. The business tier and data tier may or may not reside on the same physical computer or server. Active Server Pages (ASP) was built that accesses the business tier to retrieve the needed information for display on a web page. The cost of designing a distributed system, building a distributed system, upgrades to the system and error handling are examined.Ball State UniversityMuncie, IN 47306
Department of Computer Science

International Telemetering Conference Proceedings / October 28-31, 1996 / Town and Country Hotel and Convention Center, San Diego, California
In the last few years there has been a proliferation of GPS receivers and receiver manufacturers. Couple this with a growing number of DoD test programs requiring high accuracy Time-Space-Position-Information (TSPI) with diminishing test support funds and/or needing a wide area, low altitude or surface tracking capability. The Air Force Development Test Center (AFDTC) recognized the growing requirements for using GPS in test programs and the need for a low cost, portable TSPI processing capability which sparked the development of the Desktop GPS Analyst. The Desktop GPS Analyst is a personal computer (PC) based software application for the generation of GPS-based TSPI.

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.

The subject of this thesis is communication process between a mobile device and a server. The work is concerned with development of application in Windows Mobile in the light of technical limitation. The thesis also deals with the development of application for universal mobile database connector which then enables transparent working with information, obtained from database placed on server, on the mobile device.

Programmeringsspråken Visual C++, C# och VB.NET (Visual Basic.NET) jämförs, med tyngdpunkt på en praktisk jämförelse av fyra exempelapplikationer.

Exempelapplikationen WordCount visar att Visual C++ har förutsättningar förbäst prestanda, men att även C# och VB.NET ger helt godtagbar prestanda. Valet av färdiga klasser är viktigare än språket. Ett olämpligt val kan göra prestandan mycket sämre än förväntat, medan den allra bästa prestandan ofta erhålls med en egen implementering.

Applikationen FFT visar att flyttalsprestandan är bättre i C# än i VB.NET. Applikationen Clock visar att Visual C++ har en viss fördel i sitt färdiga ramverk för traditionella dokumentbaserade Windowsapplikationer.

C# och VB.NET vinner över Visual C++ i nästan alla övriga avseenden. De ger mindre mängd kod och tillhandahåller ny funktionalitet — som egenskaper, händelser, attribut och ett mycket omfattande klassbibliotek — som gör programmeringen enklare och mindre känslig för buggar och säkerhetshål. Valet mellan C# och VB.NET bör avgöras av projekttyp, företagskultur och utvecklarens individuella preferenser.

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).

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

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.

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.

The presented diploma thesis deals with the improvement of system support at the department Sales Planning and Reporting in Skoda Auto a.s. Its major objective is proposal, creation and implementation of the main analytical tool for sales and production planning in this department with regard to the economic efficiency of this solution. The main task of this tool is to make the process of planning in the company more effective and support management’s decision making process. The entire project is implemented in Microsoft Excel using Visual Basic.

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 Engenharia do ambiente
A degradação da qualidade do ar deve-se principalmente à poluição causada pela emissão, transporte e transformação dos poluentes para a atmosfera, emitidos maioritariamente por tráfego automóvel e o setor industrial. De forma a avaliar o cumprimento dos requisitos legais impostos na legislação portuguesa, é necessário proceder à realização de amostragens nas fontes fixas, recorrendo a técnicas, equipamentos e controlo de qualidade cujos procedimentos requerem requisitos técnicos específicos e posterior reporte de dados, com o tratamento e enquadramento legal adequado. O objetivo deste estágio, decorrido no Instituto do Ambiente e Desenvolvimento – IDAD, foi a avaliação dos referenciais normativos ativos no Laboratório do IDAD referentes à área das emissões gasosas, desenvolver competências em amostragens de efluentes gasosos, otimizar o sistema de aquisição, tratamento de dados, e cálculo de incertezas para realização do relatório final de ensaios de emissões gasosas e por último, analisar e interpretar os resultados do projeto de caracterização de efluentes gasosos das caldeiras de centros de saúde, adjudicado pela Administração Regional da Saúde do Centro, IP (ARS-C). O trabalho desenvolvido no estágio envolveu uma análise bibliográfica para enquadramento teórico e avaliação dos referenciais normativos; qualificação técnica para tratamento de dados e emissão de relatórios de ensaios de emissões gasosas; aprendizagem e programação do sistema de aquisição, tratamento de dados e cálculo de incertezas; e análise estatística dos resultados obtidos do projeto da ARS-C. Analisando os referenciais normativos aplicados às emissões gasosas, constatou-se que o IDAD acompanha a evolução e desenvolvimento dos métodos de referência, com o pedido de extensão de acreditação para 5 ensaios e pedido de acreditação para 3 novos ensaios. A análise dos dados do projeto da ARS-C permitiu verificar que as caldeiras a gasóleo são mais críticas quanto à emissão de poluentes, justificando assim terem sido mudadas caldeiras em diversos centros de saúde com o intuito de utilizarem um combustível mais limpo. Com a realização deste estágio, foi possível obter um sistema de tratamento de dados e de emissão de relatórios de ensaios, associados às emissões gasosas. Com este sistema reúne-se num único documento toda a informação existente sobre o cliente, informação legal, tratamento de dados e apresentação de resultados. Desta forma, a probabilidade de erros diminui, o tempo despendido para emissão de relatório torna-se mais curto e torna mais fácil a verificação do cumprimento das condições legais impostas. Assim sendo, conclui-se que os objetivos do estágio foram cumpridos contribuindo para uma melhoria no fluxo de trabalho da instituição e por conseguinte uma melhoria nos serviços prestados.
Air quality degradation is mainly due to pollution caused by the emission, transport and transformation of pollutants to the atmosphere, emitted in most part by traffic and the industrial sector. As a way to assess the fulfillment of legal requirements imposed in the Portuguese legislation it is necessary to conduct sampling on fixed sources, using techniques, equipments and air quality control which procedures require specific technical requisites and posteriorly data report, with the suitable legal framework. The goal of this internship, at Instituto do Ambiente e Desenvolvimento – IDAD, was to asses all the normative frameworks (gas emissions) active in the IDAD laboratory; develop skills in gaseous effluents sampling, optimization of the acquisition system, data processing and calculation of uncertainties; in order to issue the final report of gaseous emission tests; lastly, analyze and interpret the results of the project Characterization of gaseous effluents from the boilers of health centers, granted by Administração Regional da Saúde do Centro, IP (ARS-C). The work performed during the internship encompassed the bibliographic analysis for the theoretical framing and normative frameworks assessment; technical qualification for issuing test and gaseous emissions reports; learning and programming the acquisition system, data processing and calculation of uncertainties; and statistical analysis of the acquired results for the ARS-C project. From the assessment to the applied normative referential, it was shown that IDAD keeps up with the evolution and development of the reference methods, with the accreditation extension request for 5 tests and accreditation request for 3 new tests. The data analysis of ARS-C project enabled the verification that diesel boilers are the most critical in terms of pollutants emission, justifying in this way having been changed in several medical facilities with the objective of using a cleaner fuel. With this internship, it was possible to obtain a system of data treatment and emission reporting of gaseous emissions. With this system, all existing information about the customer, legal information, data processing and presentation of results are gathered in a single document. In this way, the probability of errors decreases, the time spent issuing reports becomes shorter and makes it easier to verify compliance with the legal conditions imposed. Thus, it is concluded that the objectives of the internship were fulfilled contributing to an improvement in the workflow of the institution and therefore an improvement in the services provided.

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.

Mestrado em Engenharia de Automação Industrial
A presente dissertação propõe o desenvolvimento de um sistema de Irrigação de baixo custo para campos de Golfe. Este sistema é capaz de recolher a previsão meteorológica e ainda medir um conjunto de valores (temperatura, humidade, velocidade do vento) que determina quando e quanto regar. Os campos de Golfe consumem diariamente elevadas quantidades de água, sendo esta a principal crítica feita pelas organizações ambientais. Esta dissertação incorpora uma comunicação sem fios de baixo custo, que dispensa a cablagem que é necessária para haver comunicação entre os diversos equipamentos, que estão distribuídos pelo campo de Golfe. O sistema desenvolvido pretende reduzir os desperdícios dos recursos hídricos na rega, pois é um sistema inteligente que poderá ser adquirido não só por gestores de campos de Golfe, mas também por jardins residenciais e municipais. Com o objetivo de criar um sistema de baixo custo foi elaborado um algoritmo de reencaminhamento de mensagens, que permite utilizar equipamentos de comunicação sem fios de baixo custo. Todo o sistema de Irrigação é controlado e monitorizado através de uma interface, desenvolvida em Microsoft Visual Basic.
The present dissertation proposes the development of a low-cost Irrigation system for golf courses. This system is able to acquire weather forecast and also measure a set of values (temperature, humidity, wind speed) that defines when and how much to water. The golf courses consume high amounts of water daily, being this the main review made by environmental organizations. This dissertation incorporates a wireless low-cost communication, which eliminates the electric wires needed to communicate between the several devices distributed on the golf course. The developed system aims to reduce the waste of water resources in the irrigation, as it is an intelligent system that can be acquired not only by managers of golf courses, but also by residential and municipal gardens. With the objective of creating a low-cost system it was developed a message forwarding algorithm that allows the use of low-cost wireless communication equipment. The entire Irrigation system is controlled and monitored via an interface developed in Microsoft Visual Basic.

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.

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

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

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.

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

This dissertation deals with processes how to work with applications of office package by Microsoft Office from the ambience of NET Framework through the programming language Visual Basic.NET. These processes are used to develop the application for calibration of balance. The result of this application is a calibration sheet as a document of Microsoft Word text editor and a workbook of spreadsheet Microsoft Excel comparing calculations in the application with formulas of spreadsheet Excel.