Seleção de materiais e design: um método com base nas redes neurais artificiais

Pós-graduação em Design - FAAC

Desenvolvimento de uma planilha eletrônica em VBA para o dimensionamento didático de instalações de recalque de água

This study aims to develop a computer program based on VBA programming language, using Microsoft Excel, for designing pumping systems of water. The program allows the user to determine the economical diameter, using the equation of Bresse, for a given installation, since the geometric elevation, the material of the tube, the accessories along the line and the volumetric flow are known. In addition, the program estimates the total annual cost of the installation for three different diameters, in order to compare which diameter is more advantageous from an economical perspective. The program interface is designed to be simple and intuitive with the intention of being didactic and offering to engineering students an advantageous tool to analyze this type of project. Microsoft Excel was chosen for this work because is present in virtually all personal computer, and is an indispensable tool for educational purposes

Utilização de trocadores de calor de placas em espiral em processos da indústria siderúrgica

Stricter environmental policies are shown necessary to ensure an effective pollutant emission control. It is expected for the present year of 2015, that Brazil will assume, at the 21th United Nation's Climate Change Conference (COP21), implementation of commitment to a low carbon economy. This positioning affects the industrial environment, so that is deemed necessary to search for new technologies, less aggressive to the environment, so the adequacies to the new emission policies do not cause a negative effect on production. Almost all of the processes performed in the steel industry demand burning fuel and, therefore, flue gases are sent to the atmosphere. In this present work is discussed the utilization of heat exchangers so, by recovering part of the available heat from the flue gases of certain industrial process, the combustion air is preheated. The combustion air preheat results in less energy requirement, i.e., less need of fuel consumption and, in addition, minor amount of pollutants to be emitted. Due to better fitting to the process, it is studied the utilization of spiral plate heat exchangers. The heat exchanger dimensioning is made by an iterative method implemented in the software Microsoft Excel. Subsequently are analyzed the gains in terms of process's thermal efficiency improvement and the percentage of fuel saving. The latter implies in reduction of the same percentage of greenhouse gases emission

Aplicação do valor presente ajustado (APV) para avaliação do fluxo de caixa de uma empresa do setor automotivo no sistema inovar auto

The automobile industry shows relevance inside the Brazilian industrial scenario since it contributes with the development of a significant chain of supply, distributors, workshops, publicity agencies and insurance companies in the internal market, aside from being one of the five biggest worldwide market. Thereby, the federal government decreed in Dec, 17th 2012 by Law nº 12.715 the Inovar-Auto Program. As the Adjusted Present Value (APV) is highly recommended, although not yet widespread to public politics of tax reduction, this work intends to apply the APV method on the cash flow analysis of an automobile sector's company, which has recently installed in national territory and wants to rely with governmental incentives proposed by Inovar-Auto Program. The developed work evaluates the company's current cash flow stochastically from mathematical modeling of variables such as price, demand and interest rate through probability distributions with the assist of Crystal Ball software, a Microsoft Excel Add-in, generating different scenarios from Monte Carlo Simulation. As results probabilities situations have been evaluated until the end of the Inovar-Auto's conducted period, in 2017. Beside APV others indicator such as Internal Rate of Return (IRR) and payback period were estimated for the investment project. For APV a sampling distribution with only 0.057% of risk, IRR of 29% were obtained and estimated project payback period was 4.13 years

Desenvolvimento de uma planilha eletrônica em VBA para o dimensionamento didático de instalações de recalque de água

This study aims to develop a computer program based on VBA programming language, using Microsoft Excel, for designing pumping systems of water. The program allows the user to determine the economical diameter, using the equation of Bresse, for a given installation, since the geometric elevation, the material of the tube, the accessories along the line and the volumetric flow are known. In addition, the program estimates the total annual cost of the installation for three different diameters, in order to compare which diameter is more advantageous from an economical perspective. The program interface is designed to be simple and intuitive with the intention of being didactic and offering to engineering students an advantageous tool to analyze this type of project. Microsoft Excel was chosen for this work because is present in virtually all personal computer, and is an indispensable tool for educational purposes

Utilização de trocadores de calor de placas em espiral em processos da indústria siderúrgica

Stricter environmental policies are shown necessary to ensure an effective pollutant emission control. It is expected for the present year of 2015, that Brazil will assume, at the 21th United Nation's Climate Change Conference (COP21), implementation of commitment to a low carbon economy. This positioning affects the industrial environment, so that is deemed necessary to search for new technologies, less aggressive to the environment, so the adequacies to the new emission policies do not cause a negative effect on production. Almost all of the processes performed in the steel industry demand burning fuel and, therefore, flue gases are sent to the atmosphere. In this present work is discussed the utilization of heat exchangers so, by recovering part of the available heat from the flue gases of certain industrial process, the combustion air is preheated. The combustion air preheat results in less energy requirement, i.e., less need of fuel consumption and, in addition, minor amount of pollutants to be emitted. Due to better fitting to the process, it is studied the utilization of spiral plate heat exchangers. The heat exchanger dimensioning is made by an iterative method implemented in the software Microsoft Excel. Subsequently are analyzed the gains in terms of process's thermal efficiency improvement and the percentage of fuel saving. The latter implies in reduction of the same percentage of greenhouse gases emission

Aplicação do valor presente ajustado (APV) para avaliação do fluxo de caixa de uma empresa do setor automotivo no sistema inovar auto

The automobile industry shows relevance inside the Brazilian industrial scenario since it contributes with the development of a significant chain of supply, distributors, workshops, publicity agencies and insurance companies in the internal market, aside from being one of the five biggest worldwide market. Thereby, the federal government decreed in Dec, 17th 2012 by Law nº 12.715 the Inovar-Auto Program. As the Adjusted Present Value (APV) is highly recommended, although not yet widespread to public politics of tax reduction, this work intends to apply the APV method on the cash flow analysis of an automobile sector's company, which has recently installed in national territory and wants to rely with governmental incentives proposed by Inovar-Auto Program. The developed work evaluates the company's current cash flow stochastically from mathematical modeling of variables such as price, demand and interest rate through probability distributions with the assist of Crystal Ball software, a Microsoft Excel Add-in, generating different scenarios from Monte Carlo Simulation. As results probabilities situations have been evaluated until the end of the Inovar-Auto's conducted period, in 2017. Beside APV others indicator such as Internal Rate of Return (IRR) and payback period were estimated for the investment project. For APV a sampling distribution with only 0.057% of risk, IRR of 29% were obtained and estimated project payback period was 4.13 years

Prevalência de anomalias congênitas associadas às fissuras labiopalatinas

Objetivo: Verificar a prevalência de anomalias congênitas associadas às fissuras labiopalatinas em crianças de 0 a 3 anos de idade. Métodos: Estudo transversal, observacional, aprovado pelo Comitê de Ética em Pesquisa (Ofício nº 412/2011). Participaram do estudo 325 mulheres, mães biológicas de crianças com fissuras labiopalatinas de 0 a 3 anos de idade, associadas ou não a anomalias congênitas, matriculados no HRAC-USP. A média de idade das mães foi de 29 anos e mediana de 28 anos. O tamanho amostral foi segundo a “Fórmula para cálculo de tamanho de amostra - Populações infinitas”. Os resultados foram tabulados em planilha do programa computacional Microsoft® Excel, apresentados em tabelas apontando a média, mediana, frequência absoluta (fi), frequência absoluta acumulada (Fi), frequência relativa acumulada (Fr). Para a comparação entre a porcentagem do agravo na população e amostra, utilizou-se o teste estatístico “Teste Exato de Fisher”, adotando-se nível de significância de 5%. Resultado: Quanto à prevalência de anomalias congênitas associadas às fissuras labiopalatinas, 209(64,30%) crianças na faixa etária de 0 a 3 anos, apresentaram fissura labiopalatina isolada e 116(35,69%) apresentaram algum tipo de anomalia congênita associada a essas fissuras. A fissura mais prevalente foi a fissura pós-forame, apresentando-se isolada em 63 casos e associadas à anomalias em 42 casos, seguida da fissura trans-forame incisivo unilateral esquerda, sendo 17 casos isolada e 59 casos associada à anomalias. A anomalia congênita associada às fissuras mais encontrada foi a Sequencia de Pierre Robin, seguida das cardiopatias diversas e malformações de pés e mãos. Conclusão: a prevalência de anomalias congênitas associadas às fissuras labiopalatinas foi de 35,69%.

Quantifizierung von Steinschlagrisiken an Straßen

Thema: Quantifizierung von Steinschlagrisiken an Straßen Die Einschätzung eines bestehenden Steinschlagrisikos an Verkehrswegen ist in Gebirgs- und Mittelgebirgsregionen seit jeher eine Aufgabe, die mit verschiedensten Methoden und unterschiedlichem Aufwand bearbeitet wird. In der vorliegenden Untersuchung werden die maßgebenden Parameter zur Beschreibung einer Böschung aufgenommen und bewertet. Es wurde ein Arbeitsblatt entwickelt, in dem festgelegte Parameter erfasst werden, die teils mit Ankreuztechnik, teils mit der Eingabe von Daten, im Computer notiert werden. Das Arbeitsblatt umfasst vier Themenbereiche: Allgemeine Daten, Angaben zur Geometrie der Böschung, Angaben zum Verkehr und Angaben zum Gestein und Gebirge. Ein Computerprogramm, das auf der Basis der Software Excel von Microsoft erstellt wurde, vergibt nach der Dateneingabe Bewertungspunkte (1. Bewertungsschritt). Es werden Summen gebildet und die Teilbereiche bewertet (2. Bewertungsschritt). Jeder Teilbereich besitzt drei Bewertungsklassen. Die Verknüpfung der Bewertung der Teilbereiche Geometrische Angaben und Angaben zum Gestein und Gebirge stellt die eigentliche Risikoeinschätzung dar (3. Bewertungsschritt). Es gibt drei Einstufungen zur Beschreibung des Risikos: ð Der Verkehr ist durch Steinschlag sehr gering gefährdet. ð Der Verkehr ist durch Steinschlag gering gefährdet. Eine Detailüberprüfung muss erfolgen, da eine Gefährdung nicht auszuschließen ist. ð Der Verkehr ist gefährdet. Es besteht ein hohes Steinschlagrisiko. Bewertungen und Hinweise zu den Teilbereichen Allgemeine Daten und Angaben zum Verkehr kann der Anwender nach eigenem Ermessen zusätzlich nutzen. Die abschließende Risikoeinschätzung erfolgt durch den Anwender bzw. einen Sachverständigen.

Studio e sviluppo di un'applicazione mobile per iOS nell'ambito della BI: un task manager per SAP Business Planning and Consolidation

La tesi riguarda lo sviluppo di un'applicazione che estende la possibilità di effettuare i caricamenti dei package di SAP BPC ai dispositivi mobile, fino ad ora questo era possibile solo attraverso l'interfaccia di Microsoft Excel.

Creazione e validazione di un modello per lo sfruttamento dell'idrogeno come vettore di accumulo dell'energia elettrica

Nell’ambito di un progetto di ricerca sui sistemi di accumulo dell’energia elettrica, in corso di avvio al “Laboratorio di microreti di generazione e accumulo” di Ravenna, è stato sviluppato un modello di calcolo in grado di simulare il comportamento di un elettrolizzatore.Il comportamento di un generico elettrolizzatore è stato modellato mediante una serie di istruzioni e relazioni matematiche, alcune delle quali ricavate tramite un’analisi dettagliata della fisica del processo di elettrolisi, altre ricavate empiricamente sulla base delle prove sperimentali e dei dati presenti nella bibliografia. Queste espressioni sono state implementate all’interno di un codice di calcolo appositamente sviluppato, realizzato in linguaggio Visual Basic, che sfrutta come base dati i fogli di calcolo del software Microsoft Excel per effettuare la simulazione. A partire dalle caratteristiche dell’elettrolizzatore (pressione e temperatura di esercizio, dimensione degli elettrodi, numero di celle e fattore di tuning, più una serie di coefficienti empirici) e dell’impianto generale (potenza elettrica disponibile e pressione di stoccaggio), il modello è in grado di calcolare l’idrogeno prodotto e l’efficienza globale di produzione e stoccaggio. Il modello sviluppato è stato testato sia su di un elettrolizzatore alcalino, quello del progetto PHOEBUS, basato su una tecnologia consolidata e commercialmente matura, sia su di un apparecchio sperimentale di tipo PEM in fase di sviluppo: in entrambi i casi i risultati forniti dal modello hanno trovato pieno riscontro coi dati sperimentali.

Confronto di dati volumetrici di neuroimaging RM, acquisiti con differenti sonde a radiofrequenza

Il lavoro di questa tesi si propone di esaminare i dati di immagini cerebrali ricevuti da due differentii bobine RF per l'imaging in risonanza magnetica. La strumentazione utilizzata é: un apparecchio di RMN che utilizza uno scanner a 1.5T (GE Medical System signa HDx 15) e due differenti bobine a radiofrequenza: 1) 8-channel brain phased array coil GE (1.5T HD 8 Channel High Resolution Head Array per il GE HDx MR System); 2) GE Quad HEAD Birdcage Coil. I software utilizzati invece sono stati quattro, due per la segmentazione e la parcellizzazione dei dati dalle acquisizioni di MRI (FSL e Freesurfer), e due per l'analisi dei dati (SPSS e Microsoft Excel). I tool utilizzati di FSL sono stati SIENA, per un'indagine sulla variazione percentile della totalitá del volume cerebrale; SIENAX invece permette una segmentazione di volumi di 6 sotto regioni: sostanza grigia (GREY), sostanza bianca (WHITE), totalitá del cervello (BRAIN), liquor cerebrospinale dei ventricoli (vcsf), scaling volumetrico (vscaling), sostanza grigia periferica (pgrey). Freesurfer invece parcellizza la corteccia cerebrale e segmenta le zone della sostanza grigia profonda cerebrale. Lo scopo ultimo era quello di analizzare come la differenza di segnale acquisito dalle due bobine variasse i risultati delle analisi volumetriche delle immagini e vedere se il t-test evidenziasse variazioni sistematiche. Questa analisi aveva come scopo quello di determinare la possibilità di confrontare i soggetti i cui dati sono stati ottenuti con due bobine differenti. I dati analizzati non hanno evidenziato particolari differenze tra le due bobine, se non per i valori del liquor dei ventricoli che sono risultati variare, verosimilmente, per i processi fisiologici di atrofia della sostanza grigia cerebrale che avvengono nel tempo intercorso tra un'acquisizione e l'altra.

Systematic interpretation of molecular beacon polymerase chain reaction for identifying rpoB mutations in Mycobacterium tuberculosis isolates with mixed resistant and susceptible bacteria

Detection of multidrug-resistant tuberculosis (MDR-TB), a frequent cause of treatment failure, takes 2 or more weeks to identify by culture. RIF-resistance is a hallmark of MDR-TB, and detection of mutations in the rpoB gene of Mycobacterium tuberculosis using molecular beacon probes with real-time quantitative polymerase chain reaction (qPCR) is a novel approach that takes ≤2 days. However, qPCR identification of resistant isolates, particularly for isolates with mixed RIF-susceptible and RIF-resistant bacteria, is reader dependent and limits its clinical use. The aim of this study was to develop an objective, reader-independent method to define rpoB mutants using beacon qPCR. This would facilitate the transition from a research protocol to the clinical setting, where high-throughput methods with objective interpretation are required. For this, DNAs from 107 M. tuberculosis clinical isolates with known susceptibility to RIF by culture-based methods were obtained from 2 regions where isolates have not previously been subjected to evaluation using molecular beacon qPCR: the Texas–Mexico border and Colombia. Using coded DNA specimens, mutations within an 81-bp hot spot region of rpoB were established by qPCR with 5 beacons spanning this region. Visual and mathematical approaches were used to establish whether the qPCR cycle threshold of the experimental isolate was significantly higher (mutant) compared to a reference wild-type isolate. Visual classification of the beacon qPCR required reader training for strains with a mixture of RIF-susceptible and RIF-resistant bacteria. Only then had the visual interpretation by an experienced reader had 100% sensitivity and 94.6% specificity versus RIF-resistance by culture phenotype and 98.1% sensitivity and 100% specificity versus mutations based on DNA sequence. The mathematical approach was 98% sensitive and 94.5% specific versus culture and 96.2% sensitive and 100% specific versus DNA sequence. Our findings indicate the mathematical approach has advantages over the visual reading, in that it uses a Microsoft Excel template to eliminate reader bias or inexperience, and allows objective interpretation from high-throughput analyses even in the presence of a mixture of RIF-resistant and RIF-susceptible isolates without the need for reader training.^

Geochemistry and mineralogy of variably altered dacite volcanic rocks from ODP Leg 193 sites, PACMANUS field

A geochemical, mineralogical, and isotopic database comprising 75 analyses of Ocean Drilling Program (ODP) Leg 193 samples has been prepared, representing the variable dacitic volcanic facies and alteration types observed in drill core from the subsurface of the PACMANUS hydrothermal system (Table T1. The data set comprises major elements, trace and rare earth elements (REE), various volatiles (S, F, Cl, S, SO4, CO2, and H2O), and analyses of 18O and 86Sr/87Sr for bulk rock and mineral separates (anhydrite). Furthermore, normative mineral proportions have been calculated based on the results of X-ray diffraction (XRD) analysis (Table T2) using the SOLVER function of the Microsoft Excel program. Several of the samples analyzed consist of mesoscopically distinctive domains, and separate powders were generated to investigate these hand specimen-scale heterogeneities. Images of all the samples are collated in Figure F1, illustrating the location of each powder analyzed and documenting which measurements were performed.

Gestión eficiente de la evaluación continua del alumnado. La integración del trabajo de escritorio con moodle.

Se presenta una aplicación desarrollada en Visual Basic para Microsoft Excel 2010 con el propósito de ofrecer una herramienta que ayude al profesorado en las labores de calificación de pruebas de evaluación continua a lo largo de un curso en conjunción con la plataforma Moodle. Se describe también su aplicación a una asignatura concreta.