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

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

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