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)

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

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

GALANT: a Cytoscape plugin for visualizing data as functional landscapes projected onto biological networks

Fundação de Amparo à Pesquisa do Estado de São Paulo (FAPESP)

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

Microfenestration using the CUSA Excel ultrasonic aspiration system in chondrodystrophic dogs with thoracolumbar disk extrusion: a descriptive cadaveric and clinical study

OBJECTIVE: To describe an ultrasonic surgical aspirator assisted disk fenestration technique in dogs. STUDY DESIGN: Descriptive cadaveric and prospective clinical study. ANIMALS: Fresh Beagle cadavers (n=5) and 10 chondrodystrophic dogs with thoracolumbar disk extrusion. METHODS: Cadaveric study: Intervertebral disks T12-L2 were fenestrated with the CUSA Excel in 5 Beagle cadavers, and fenestration efficacy assessed by morphologic examination of the completeness of fenestration and size of annulotomy. Clinical study: the affected intervertebral disk was fenestrated in 10 chondrodystrophic dogs treated by hemilaminectomy for thoracolumbar disk disease. Efficacy of fenestration was evaluated. RESULTS: Mean time necessary to perform CUSA assisted fenestration was 8 minutes (range, 5-10 minutes) for each disk in cadavers and patients. In cadaver spines, removal of the nucleus pulposus was complete in 11/15 disks. In 4 disks, remnants of nucleus pulposus material were observed on the contralateral side. Nuclear material was normal in 9/15 disks and showed evidence of chondroid degeneration on histopathologic examination in the 6 disks. Median annulotomy size was 3 mm. Clinically, no signs of early recurrence were observed and all dogs recovered uneventfully. CONCLUSIONS: CUSA assisted fenestration is a safe and efficient method of fenestration for removal of most of the nucleus pulposus through a limited annulotomy.

National nitrogen budget for Denmark (excel-file 125 kB)

The data describe the flows of nitrogen between different pools and economic sectors within Denmark. The data are stored in an Excel spreadsheet that is divided into a number of worksheets. The National worksheet contains the national flows of nitrogen for the years 1990 to 2010 (note that for some flows, the data series is not complete for all years). These data underlie the national nitrogen flow figures in the main text of the paper. The remaining worksheets contain the data that underlie the figures presented in the detailed description of nitrogen flows between pools/sectors, that is in the Supplementary Material associated with the paper.