Desarrollo de una hoja de cálculo del impedimento auditivo usando Microsoft EXCEL

Resumen en inglés

Avalia????o dos cursos de gradua????o a dist??ncia no contexto brasileiro: a excel??ncia como garantia de padr??o de qualidade

Resumen basado en el de la publicaci??n

A note on the use of spreadsheet optimisers in real estate analysis

Modern Portfolio Theory (MPT) has been advocated as a more rational approach to the construction of real estate portfolios. The application of MPT can now be achieved with relative ease using the powerful facilities of modern spreadsheet, and does not necessarily need specialist software. This capability is to be found in the use of an add-in Tool now found in several spreadsheets, called an Optimiser or Solver. The value in using this kind of more sophisticated analysis feature of spreadsheets is increasingly difficult to ignore. This paper examines the use of the spreadsheet Optimiser in handling asset allocation problems. Using the Markowitz Mean-Variance approach, the paper introduces the necessary calculations, and shows, by means of an elementary example implemented in Microsoft's Excel, how the Optimiser may be used. Emphasis is placed on understanding the inputs and outputs from the portfolio optimisation process, and the danger of treating the Optimiser as a Black Box is discussed.

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.

Scaling a Dataflow Testing Methodology to the MultiparadigmWorld of Commercial Spreadsheets

Spreadsheets are widely used but often contain faults. Thus, in prior work we presented a data-flow testing methodology for use with spreadsheets, which studies have shown can be used cost-effectively by end-user programmers. To date, however, the methodology has been investigated across a limited set of spreadsheet language features. Commercial spreadsheet environments are multiparadigm languages, utilizing features not accommodated by our prior approaches. In addition, most spreadsheets contain large numbers of replicated formulas that severely limit the efficiency of data-flow testing approaches. We show how to handle these two issues with a new data-flow adequacy criterion and automated detection of areas of replicated formulas, and report results of a controlled experiment investigating the feasibility of our approach.

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.