Detta examensarbete utfördes på ABB Power Technologies i Ludvika med syfte att förenkla tillverkningen av märkskyltar till mättransformatorer.Tidigare utformades alla skyltar för hand i Excel utifrån data från ett beräkningsprogram. Det gjorde att det behövdes en mall för varje variant i varje språk vilket ledde till väldigt många mallar. På ABB ville man både komma ifrån mängden olika mallar och det tidskrävande handarbetet som dessutom kunde resultera i att skyltarna inte fick enhetligt utseende. Genom att göra ett program som automatiskt genererar skyltarna utifrån en standardmall med hjälp av en fil från beräkningsprogrammet sparas mycket tid och arbete. Den som utformar skylten behöver då bara lägga till några få data själv och kan välja språk direkt i programmet istället för att behöva skriva allt för hand.Resultatet av detta examensarbete blev ett program som används av ABB för att göra skyltar till nästan alla mättransformatorer.

No description available.

There are available various professional applications for the solving of optimization problems. This thesis deals with comparison of these optimization systems and simplicity of their connection with MS Excel through VBA. Problem of designing model together with his calculation in MS Excel or other systems connected via VBA, like MPL for Windows or LINGO, is demonstrated on concrete examples. Application in Visual Basic for Applications was created for this purpose. This application is easy to use and it is solving Knapsack Problem, Distribution Problem and also Quadratic Assignment Problem. Finally, comparison of these systems is made using Multi-criteria evaluation.

Cílem této práce je vytvoření komplexního pohledu na tvorbu aplikací v Microsoft Office s využitím VBA. Především potom najít způsob jak jednoduše a především levně a rychle vytvářet tento typ aplikací. V úvodní části práce jsou stručně popsány aplikace sady MSO, které jsou při tvorbě MSO řešení nejvíce používány. Dále je zde popsán postup vývoje v jazyce VBA současně s ním i způsob vývoje aplikací ve Visual Studiu. Jsou zde stručně popsány některé základní metodiky a vůbec historie softwarového inženýrství. V kapitole Guideline pro tvorbu aplikací v MSO, která vytváří největší přínos této práce je popsán vývojový cyklus tvorby aplikací v MSO, který jsem během své praxe vytvořil. Praktická úloha potom popisuje postup tvorby jednoduché aplikace v Ms Access. Práce je určena dvěma základním skupinám osob. Jsou to především ti, kteří jsou v roli analytiku a manažerů pracovišť, kde mají pocit, že neustále mechanicky opakují věci, které by bylo možné zautomatizovat. Dále jsou to potom programátoři, analytici a konzultanti, kteří by chtěli začít vyvíjet řešení postavená na MSO. Hlavním přínosem práce je poskytnutí obecného náhledu na tvorbu tohoto typu aplikací, společně s návodem, jak to činit co nejefektivněji.

The main thesis aim is to introduce possibilities of MS Excel in data analysis and to point out to some strengths and weaknesses of MS Excel in data processing. I pay attention to tools which MS Excel contains by default as well as to statistical products which are not normally part of MS Excel. These products can be run in MS Excel environment as statistical add-ins for MS Excel. In the first case I focus on MS Excel tools as statistical functions, graphic analysis and statistical methods, in the other case on statistical products as XLStatistics, Analyse it, WinSTAT. In connection with the first mentioned statistical product I show some examples how to analyze and work with real data samples in product XLStatistics. The aim of this part is to show other way how to analyze data then in the others products or MS Excel itself. At the end of my thesis I programmed my own product Regxcel with the help of VBA language as the main contribution of my entire work. Product Regxcel provides solution in regression analysis for the six most common types of regression function. The main aim of this part is to point out to other possibility how to analyze data and solve some problems which users can face in regression analysis in MS Excel. I also try to show VBA language as big help in data processing in MS Excel. At the very end I presented all possibilities of Regxcel on real data sample. The product itself is part of attached CD

In this Master's thesis scripting interface of two programs CST Microwave studio and Ansoft HFSS for the purpose of analysis of electromagnetic structures is described. The work is focuses control of these programs with help of scripting languages and system's interface of MS Windows XP. Next the process of connecting programs with MATLAB is shown on commented scripts together with an example of complete analysis of a chosen problem, and the import and export of results results in MATLAB. Further the functions which form programming interface between MATLAB and simulation programs are designed and implemented. The interconnection layer makes the complete control of simulating programs possible using the function description published in the official documentation of used simulation programs. The layer is described in reference manual in detail and it is used for optimization with use of Particle swarm optimalization (PSO) of planar antenna model. Then there is presented another usage of the layer for an implementation of global optimization methods - SOMA and DE including suggestion of process for comparison efficiency of optimization algorithms on simple electromagnetic models.

Estágio realizado na Colep - e orientado pelo Eng. Rui Castro / Tese de mestrado integrado. Engenharia Industrial e Gestão. Faculdade de Engenharia. Universidade do Porto. 2013

Företaget GUTAB använder idag en frågeanalysmodul som är utvecklat i Visual Basic for Applications i Microsoft Excel. GUTAB fann det intressant att veta om modulen kunde konverteras till webbläsaren Internet Explorer samt vilken teknologi som var lämplig för detta. GUTAB var även intresserade av att veta vilken teknologi som kunde användas för att skapa grafiska manipulerbara objekt.En skrivbordsundersökning genomfördes som omfattade teknologierna ASP, ASP.NET, JSP, PHP, ActiveX samt Java applets. Skrivbordsundersökningen utgjordes av två delar där den första delen redogjorde för de två klientbaserade teknologierna ActiveX och Java applets med vilka grafiska manipulerbara objekt kunde realiseras. GUTAB ansåg att ActiveX program var mest lämpliga för detta ändamål.Baserat på skrivbordsundersökningens andra del bestämde GUTAB att ASP och ASP.NET skulle användas för att testa teknologiernas kapacitet att konvertera programlogik samt grafiska objekt från VBA-applikationen i en webbapplikation då dessa två teknologier ansågs som mest lämpliga för en konvertering.Testet som genomfördes visade att det var fullt möjligt att konvertera utvald funktionalitet med båda teknologierna. Dock kunde inte grafiska objekt skapas i asp varför befintliga objekt användes för det ändamålet. Många fördelar identifierades med ASP.NET varför GUTAB beslutade att ASP.net var den mest lämpliga teknologin att använda vid en eventuell konvertering.

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.

Práce se zabývá možností programování základních metod teorie grafů a řízení projektů v prostředí MS Excel 2003. Hlavním přínosem by měla být aplikace vytvořená ve VBA, která má sloužit jako pomůcka při výuce operačního výzkumu. Vytvořený program je určen k případnému rozšiřování a doplňování o další metody, aby pro studijní účely bylo zpracováno co nejvíce metod.