Desenvolvimento de uma ferramenta computacional em excel para automatizar o projeto estrutural de pórticos rolantes

Coordenação de Aperfeiçoamento de Pessoal de Nível Superior (CAPES)

Avaliação dos registros de profilaxia anti-rábica humana pós-exposição no Município de Jaboticabal, são Paulo, no período de 2000 a 2006

Coordenação de Aperfeiçoamento de Pessoal de Nível Superior (CAPES)

Uso de geotecnologias na análise temporal dos impactos da urbanização na sub-bacia do Córrego Sem Nome em Ilha Solteira/SP

Pós-graduação em Engenharia Civil - FEIS

Coeficiente de cultura e lâmina ótima de irrigação para a melancia, na microrregião de Teresina, Pi

Conselho Nacional de Desenvolvimento Científico e Tecnológico (CNPq)

Sazonalidade de ocorrência de mofo cinzento, oídio e manchas bacterianas foliares em dois viveiros de produção de mudas clonais de eucalipto

Pós-graduação em Ciência Florestal - FCA

Análise exergoeconômica de ciclo de refrigeração por compressão de vapor

Pós-graduação em Engenharia Mecânica - FEG

Análise de estruturas reticuladas utilizando o software excel pelo método dos elementos finitos

Pós-graduação em Engenharia Mecânica - FEG

Otimização do processo de MRP (Material Requirement Planning) de embalagens: uma aplicação da metodologia lean six sigma em uma indústria de agronegócios

There is a growing search for continuous improvement within the companies which creates an obligation of reducing and when it is possible eliminating waste. Production Planning and Control Department (PCP) is not out of this question, making necessary the application of methods and creation of tools that eliminate steps which do not add value to the planning process. This paper aims to develop a tool which concentrates in just one place all the necessary information to make the packaging material requirement planning (MRP) in a agribusiness company. Besides, it also aims, in a more visual way and using devices that prevent mistakes (Poka-Yoke), to reduce the number of reviews and mistakes made by analysts. As a result, an Excel spreadsheet was developed. This spreadsheet shows what happens with the status of planning and receiving of packaging, giving some advices when some critical situation happens. The use of Lean Manufacturing Method and the action research method helped to well define the problem and to reduce the number of steps, spreadsheets and time of process in 80%, 60% and 75%, respectively

Determinação do fator de rigidez de junta aparafusada em tração utilizando o software Excel

When a bolted joint is loaded in tension with dynamically, part of this load is absorbed by the bolt and rest is absorbed by the joint material. What determines the portion that is to absorbed by the bolt is the joint stiffness factor. This factor influences the tension which corresponds to pre-load and the safety factor for fatigue failure, thus being an important factor in the design of bolted joints. In this work, three methods of calculating the stiffness factor are compared through a spreadsheet in Excel software. The ratio of initial pre-load and the safety factor for fatigue failure depending on the stiffness factor graph is generated. The calculations for each method show results with a small difference. It is therefore recommended that each project case is analyzed, and depending on its conditions and the range of stiffness values, the more or less rigid method about the safety factor for fatigue failure is chosen. In general, the approximation method provides consistent results and can be easily calculated

Determinação da freqüência natural de eixos utilizando o software excel

This work aims to determine the first natural frequency of rotation shaft by using a basic software, Excel, and to compare it to the values obtained in laboratory. When an axle is submitted to a rotation, depending on the rotational frequency used, the axle can enter a state of resonance, in which the amplitude of vibration becomes rather high. The frequencies in which the resonance is observed depends on several parameters of the axle, including the number of concentrated masses associated to the axle. Thus, to obtain a computer program of easy use and access, which can preview the frequency of resonance of an axle in rotation with ‘n’ numbers of concentrated masses it has been studied how the frequency varies with each of these parameters. The computer program and the analyses have been made using the Rayleigh Method, which allowed the transformation of a continuous system to discrete through the theory of finite elements, which has proved that, the bigger the number of divisions of the shaft taken into consideration in the calculus of the natural frequency, the more this value gets close to the real value. The results obtained have been considered satisfactory once these have gotten close to the theoretical results expected

Análise estrutural de treliças espaciais no software Excel utilizando o médodo dos elementos finitos

The following paper means to develop a program to make structural analysis of space trusses. The program to be implemented was based on the concepts of the finite element method and used the programing resources of Visual Basic for Applications (VBA) for the Excel Software®. Being Excel® a software of easy access, low cost, capacity to make matrix calculations and with advanced resources of VBA programing, it is possible to develop an economic solution, efficient and precise for structural analysis of space trusses. Firstly is presented a finite elemento method and the space truss. Then is developed a few important algorithms to be used during the development of the program and also the use of a few resources of VBA. And to validate the quality, efficiency and precision of the results, these are compared with the established commercial software Ansys

Metodologia para otimização em subcontratação de serviço de usinagem

Operational Research (OR) is an eminent science to business competitiveness and the capacity of algorithms and spreadsheets that exist today allows people to apply them for a lower cost and with less complexity. However, spreadsheets linked to OR techniques, when directed to real problems, are still little explored in their full potential. In order to use them better, this article utilizes the Microsoft Office Excel to solve an optimization practical problem and decision-making of machining subcontracting. In general, although considered a frequent problem, is not of easy solution, optimize the mix of production versus outsourcing, because of the restrictions and resources available, it requests investments in specific software. In this way, this research aims to develop software to be called SOSU (Optimization Software for Machining Subcontracting). SOSU should introduce the best mix of internal and subcontracted machining for n types of parts that, over a certain period of time t, maximize capacity and meet all the demand at the lowest cost possible. The methodology adopted follows the bibliographic reference and it is assumed that the necessary data to prove from mathematical modeling of production areas and from a system of costs already structured. The nature of the problem justifies the application of Linear Programming (LP), Visual Basic for Applications (VBA) is used for computational implementation and interface with the user and the supplement Solver to find the solution. The analysis of the experiments show that the SOSU optimizes resources and improves the decision-making process, besides an easy operation, it can be implemented or quickly adapted and without the need of large investments.

Modelo bioeconômico para cálculo de custos e receitas em sistemas de produção de gado de corte visando à obtenção de valores econômicos de características produtivas e reprodutivas

Foi desenvolvido um modelo bioeconômico para o cálculo do desempenho, dos custos e das receitas para obtenção de valores econômicos de características de interesse econômico em sistemas de produção de gado de corte no Brasil. As informações de desempenho e de parâmetros biológicos e econômicos foram obtidas em uma propriedade de gado Nelore que realiza ciclo completo com venda de reprodutores. O modelo é determinístico e estático e foram usadas planilhas Excel para a realização dos cálculos. Com base nas informações originais, foram simulados dois sistemas de produção, um fazendo o ciclo completo com venda de reprodutores (CcoR) e o outro, de cria (Cc). Foram calculados os custos e as receitas para esses dois sistemas e, a partir disto, foram obtidos seus lucros anuais. Para o cálculo dos valores econômicos foram escolhidas as características peso à desmama (PD), peso adulto da vaca (PAV), taxa de prenhez (TP) e taxa de desmama (TD), que são de interesse nos dois sistemas de produção. Para avaliar o impacto das mudanças no desempenho das características sobre o lucro anual do sistema de produção, os valores iniciais das características foram aumentados em 1%. Esse aumento resultou em mudanças positivas no lucro, observando-se que a TD foi a característica que apresentou maior impacto nos dois sistemas. Para o CcoR, os valores econômicos para PD, PAV, TP e TD foram, respectivamente, R$ 0,40/kg, R$ 0,09/kg, R$ 3,20/1% e R$ 10,15/1%. Para Cc, estes valores foram, respectivamente, de R$ 1,31/kg, R$ 0,09/kg, R$ 2,41/1% e R$ 3,36/1%. O modelo foi capaz de reproduzir satisfatoriamente o sistema de produção de gado de corte estudado e pode ser adaptado para outras circunstâncias de produção.

Caracterização da produção em toros do cogumelo comestível Lentinula edodes (Berk.) Pegler na região oeste do Estado de São Paulo

This study was carried out in the towns of Dracena, Junquciropolis, Mirandopolis, Aliancas, Ilha Solteira, Castilho, Aracatuba, Birigui and Guararapes, São Paulo State, by surveying 17 Shiitake growers through a questionnaire. Data pertaining to the stages of log-Shiitake growing, recording and characterization of growers and growing systems were entered into Microsoft Excel for Windows. The results showed that Shiitake cultivation is recent and increasing in this region, and that growers have a high education level. Shiitake cultivation is mainly located in rural areas, with both Brazilians of Japanese descent and native Brazilians growing it. The most commonly used trees are eucalyptus and mango. The high level of log contamination is perhaps due to growing without temperature or moisture control and to the inappropriate growing system.. In 2004, there were 45,000 Shiitake-inoculated logs in this region, and the yield stood around 200 g of fresh mushroom/log. The mushrooms are picked in boxes of 200 g, and are sold mainly to Ceasa in open markets.

Análise do uso de SIG no roteamento dos veículos de coleta de resíduos sólidos domiciliares

Relata-se neste trabalho, a análise do uso de um Sistema de Informação Geográfica - SIG como ferramenta para roteirização de veículos de coleta de resíduos sólidos domiciliares. O software utilizado foi o TransCAD, versão 3.2, que permite desenvolver rotas utilizando algoritmos que incluem o procedimento de roteirização em arco. O objetivo é minimizar a extensão total a ser percorrida pelos veículos coletores. O estudo de caso foi realizado na cidade de Ilha Solteira - SP. Os dados coletados e os resultados obtidos pelo TransCAD foram processados no software Microsoft Excel. Os resultados obtidos demonstraram reduções percentuais de até 41% na distância total percorrida e de 68% no tempo total de percurso em relação ao serviço atual.