Projeto estrutural de molas helicoidais de extensão utilizando o Microsoft Excel e programação VBA

• Autor(a) principal: Silva, Pedro Nunes da
• Data de Publicação: 2020
• Tipo de documento: Trabalho de conclusão de curso
• Idioma: por
• Título da fonte: Repositório Institucional da UNESP
• Texto Completo: http://hdl.handle.net/11449/216307
• topic: Extension Coil Spring; Mola Helicoidal de Extensão; Excel; VBA; Excel – Programa de computador; Molas (Mecanismo); Linguagem de programação (Computadores)

This undergraduated thesis aims to perform the steps of calculation of an extension coil spring with cyclic loading actuation, in order to facilitate it’s project and specification. Through Excel software and the VBA programming language, the user will input some informations and, from them, the involved parameters will be calculated and the main factors of the approved springs will be displayed, such as the lentgh, the avarage diameter of the coil, safety coefficients and C-index variation charts. In order not to have specifications outside the manufacture standard, some data that the user will fill in, as the material and corresponding diameter of wire, are conditioned to norms, with the program preventing entering parameters other than those established. Because springs project of this nature is extensive, this computational tool is a great use to any company thay buys it, manufectures it or designs springs for any porpouse, as it significantly reduces the time taken to complete all the steps, plus to prevent miscalculations.