<p>CML Data AB is a small IT-company that offers complete IT-solutions adjusted to the needs of the customers. It is hard for the employees to bring all necessary papers, files and software when visiting a customer. They also have difficulties planning their daily work and to keep track of each other, because of the lack of a shared calendar.</p><p>The purpose of this report is to answer the following questions:</p><p>- How do you develop a centralized information system for CML Data AB where it is possible for the employees to gain access to files, plan their days and where the customers can get access to relevant information?</p><p>- How do you develop an information system that is easy to manage?</p><p>- How do you make it easier for the employees at CML Data AB to update their homepage?</p><p>We discussed the problems and the future information system with the employees and were able to establish a set of needs and requirements which we then used as a foundation during the software development. We used user centered system design during the whole process and focused a lot on usability and interaction design.</p><p>The project resulted in a stylistically pure and user friendly portal. The portal can be used to access and upload files and plan the daily work. It can also be used for administration of the homepage and the portal users.</p> / <p>CML Data AB är ett teknikintensivt och renodlat IT-företag som skräddarsyr helhetslösningar anpassade efter kundens behov. CML Data AB kan sägas fungera som en extern IT-avdelning för företag. Mycket av arbetet sköts ute hos kunder och man får ofta åka ut på uppdrag med kort varsel. Det är då svårt att få med sig de nödvändiga filer, dokument och programvaror som krävs. Företaget saknar även en gemensam kalender där det dagliga arbetet kan planeras.</p><p>För att få en bättre inblick i företagets verksamhet och för att få fram de förändringsbehov som fanns gjordes en FA/SIMM-analys. Denna analys visade att CML Data AB var i behov av ett centraliserat informationssystem med möjlighet att ladda upp och hämta filer, samt en kalender för att underlätta planeringen av det dagliga arbetet.</p><p>Det kunde också konstateras att företagets hemsida behövde förnyas och göras lättare att uppdatera och förändra.</p><p>Examensarbetets frågeställningar fastställdes till följande:</p><p>- Hur utvecklar man ett centraliserat informationssystem åt CML Data AB där det går att planera sitt arbete, få åtkomst till filer och där kunder kan komma åt relevant information?</p><p>- Hur utvecklar man ett centraliserat informationssystem åt CML Data AB som är enkelt och smidigt att administrera?</p><p>- Hur gör man det lättare och mindre tidskrävande för de anställda på CML Data AB att uppdatera hemsidan?</p><p>Tillsammans med de anställda på företaget togs de krav och behov fram som fanns på informationssystemet. Utvecklingsarbetet skedde med stöd av användarcentrerad systemdesign och fokuserade mycket på användarvänlighet och interaktionsdesign. Innan programmeringen tog vid framställdes ett antal prototyper som de anställda fick ha synpunkter på. Ett par av dessa prototyper godkändes och låg som grund för det fortsatta utvecklingsarbetet.</p><p>En accessdatabas ligger till grunden för informationssystemet som utvecklats i Visual Studio .NET med hjälp av programmeringsspråket Visual Basic .NET och serverspråket ASP .NET.</p><p>Arbetet resulterade i en portal med ett stilrent och användarvänligt gränssnitt. Från portalen går det att hämta och ladda upp filer, det går även att planera arbetsveckan och få information om vart de anställda befinner sig genom den gemensamma kalendern. Portalen har även en enkel och lättnavigerad administrationsdel där det går att uppdatera, ta bort och förändra den information som finns i portalen. Från administrationsdelen kan man också uppdatera och förändra den nydesignade hemsidan. Genom ett enkelt WYSIWYG-gränssnitt kan man lätt uppdatera och lägga till bilder och texter på hemsidan. Det finns också funktioner för att lägga till helt nya sidor och för att lägga till nyheter på hemsidan.</p>

To be more competitive in the market, many companies are trying to speed up the quotation process and quote more attractive prices. Therefore, they have identified a need for support in the quotation process in order to reduce the quotation lead-time and ensure a higher level of accuracy in the cost estimations. The Quotation Calculator, an application program, has been developed as part of the degree thesis which was carried out at AB Norrahammars Mekaniska Verkstad, NMW 2006/07. This Quotation Calculator can be operated to calculate the material and manufacturing costs of a new product. NMW has recently acquired licenses for CATIA V5, Dassault Systems, for the purpose of making process planning and NC-programming more efficient. NMW wants to generate the data needed from the machining module for the cost calculations. Hence this project was initiated in order to extract data from CATIA V5 for further use in Quotation Calculator or other computer system in NMW. This work has resulted in a system developed with a common hosted programming language to extract and transfer information. The system retrieves model geometry from CAD and information on process planning from CAM, then matches the information in the application for the purpose of cost estimation. The system once developed, is supposed to be used for every new product. For this approach, the relationship of the data from CATIA V5 and the Quotation Calculator has been analyzed. Within this thesis, the focus is on production cost estimation. The method used here is programming in Visual Basic Editor to extract information from the machining module in CATIA V5 and then import them to Microsoft Excel. With standard operations, tables of data and several inputs, the cost calculation and hence the quotation process can be automatically implemented. This work has been generated with the Quotation Calculator. With the correct input data to process planning and this new quotation system, the machining time and the costs can be estimated more accurately and easier. The time and cost information is made available for decision making. As a result, the lead time for the quotation process will be shortened and a relatively more attractive price can be quoted to the customers.

Οι ηλεκτρομηχανικές συσκευές αποθήκευσης δεδομένων πολύ μικρής κλίμακας που βασίζονται στη χρήση ακίδων (probes) αποτελούν ανερχόμενες εναλλακτικές επιλογές για τη βελτίωση της πυκνότητας αποθήκευσης, του χρόνου πρόσβασης των δεδομένων και της απαιτούμενης ισχύος σε σχέση με τις συμβατικές συσκευές αποθήκευσης. Μία υλοποίηση μιας τέτοιας συσκευής χρησιμοποιεί θερμομηχανικές μεθόδους για την αποθήκευση πληροφορίας σε λεπτές μεμβράνες πολυμερών υλικών. Στην περίπτωση αυτή, η ψηφιακή πληροφορία αποθηκεύεται με τη μορφή κοιλωμάτων πάνω στο πολυμερές υλικό, τα οποία δημιουργούνται από τις ακίδες, διαμέτρου μερικών nm. Με στόχο την αύξηση του ρυθμού εγγραφής και ανάγνωσης χρησιμοποιούνται δισδιάστατες διατάξεις από ακίδες που λειτουργούν παράλληλα, με κάθε ακίδα να εκτελεί λειτουργίες εγγραφής /ανάγνωσης /διαγραφής σε ξεχωριστό αποθηκευτικό πεδίο. Η μετατόπιση του αποθηκευτικού μέσου σε σχέση με τη διάταξη των ακίδων επιτυγχάνεται με τη χρησιμοποίηση ηλεκτρομηχανικού συστήματος μικρής κλίμακας (MEMS). Η διάταξη MEMS αποτελείται από ένα μικρής κλίμακας σύστημα σάρωσης (microscanner) και από το τσιπ της δισδιάστατης διάταξης των ακίδων. Το σύστημα σάρωσης έχει δυνατότητα κίνησης σε δύο διευθύνσεις (x/y). Αντικείμενο της διπλωματικής εργασίας είναι η μοντελοποίηση του συστήματος σάρωσης μικρής κλίμακας. Η μοντελοποίηση του συστήματος έγινε με βάση το σύστημα του απλού αρμονικού ταλαντωτή με απόσβεση. Στα πλαίσια της εργασίας μελετάται η απόκριση του συστήματος σε διάφορους τύπους διεγέρσεων, ενώ για την προσομοίωση της συμπεριφοράς του microscanner αναπτύχθηκε εφαρμογή στην γλώσσα προγραμματισμού Visual Basic. Η εφαρμογή περιλαμβάνει γραφικό περιβάλλον με δυνατότητα ρύθμισης των παραμέτρων εξομοίωσης. / Micro-electro-mechanical-system (MEMS)-based scanning-probe storage devices are emerging as potential ultra-high-density, low-access-time, and low-power alternatives to conventional data storage. One implementation of probe-based storage uses thermomechanical means to store and retrieve information in thin polymer films. Digital information is stored by making indentations on the thin polymer film with the tips of atomic force microscope (AFM) cantilevers, which are a few nanometers in diameter. To increase the data rate, an array of probes is used, in which each probe performs read/ write/ erase operations over an individual storage field. Displacement of the storage medium relative to the array of cantilevers is achieved by using micro-electro-mechanical-system (MEMS). The MEMS assembly consists of the microscanner and the cantilever array chip. The microscanner with x and y motion range carries the storage medium. This diploma dissertation presents the modeling of the microscanner. The system models as a damped harmonic oscillator. The model response on different driven forces has been studied, whereas an application in Visual Basic has been generated to simulate the system motion. The application comprises graphic interface with simulation parameters modulation.

One of the methods for collecting data in psychology is a method of semantic differential. The using of semantic differential is very large, this method is widely used in personality research, clinical psychology, market psychology and marketing. In recent years, this method has begun to apply to the area of educational research, above all educational psychology. A basic problem with wide using is the huge volume of data obtained by this method. Some of the options of setting up of a questionnaire with light to the selection of bipolar adjectives are listed in the thesis. The options represent the evaluation dimension, the dimension of activity and potency in terms of both representativeness and relevance. A set of tools for automatized generation of various combinations of questionnaire groups was created. A technical support of data collection, their evaluation and visualization using semantic differential method was also created. These methods will be used in realization of the project of introducing teaching of mathematic in English language at primary schools. The primary goal of this level of analysis is to judge to what extent can two terms (or more terms), generally regarded as semantically similar or different.

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.

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.

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.

Vi har skapat ett hjälpmedel som dimensionerar träbalk och infästningarna balksko och spikningsplåt, enligt eurokoderna. Det är programmerat i Visual-Basic och har ett enkelt användargränssnitt.

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.

This thesis assesses the potential of using computer simulation to aid existing lean manufacturing training methods such as lecture and live simulation. An investigation of this possibility was carried out in conjunction with UMEP's Lean 101 class. In the study, two experimental computer simulation models demonstrating the push and pull production scenarios were constructed using ProModel software. Simulation models were equipped with a Visual Basic interface to aid trainees to manipulate the model via ActiveX. Constructed computer simulation was compared with live simulation to answer these research questions: 1. Was computer simulation able to teach additional lean concepts not covered in live simulations? 2. Was training time less for trainees going through a computer simulation than for those going through a live simulation? 3. Was a computer simulation quicker and easier to set up than a live simulation for trainers? 4. Did computer simulation achieve comparable educational objectives as live simulation? Objective measurements for first three questions were positive and conclusive. For the fourth one, a survey was conducted among trainees of a treatment group (computer simulation only) and a control group (live simulation only) to collect responses. Statistical analysis of the subjective responses indicated the computer simulation aided the trainees to learn and implement lean manufacturing, but was not as effective as live simulation. Holistically, these results did not warrant the complete changeover from live simulation to computer simulation. Yet, a combined implementation of computer simulation and live simulation was proposed to reap the benefits from the best of both approaches.