Projeto estrutural de molas helicoidais de compressão utilizando o programa Microsoft Excel

• Autor(a) principal: Sousa, Nathan Major de [UNESP]
• Data de Publicação: 2017
• 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/156994; http://www.athena.biblioteca.unesp.br/exlibris/bd/capelo/2018-08-28/000906386.pdf
• topic: Molas (Mecanismo); Máquinas; Excel for Windows (Programa de computador); Springs (Mechanism)

The purpose of the work is to design a compression spring that will work on fatigue and its main purpose is to serve as a support material for undergraduates. The project will use the Excel \ VBA programming language, where after inserting some input data the user will receive important data from approved springs such as weight, fatigue safety coefficient and main geometric factors, as well as graphs for better understanding and analysis. The program respects some limitations imposed by the technical literature and the user will be warned when to make some mistake, guaranteeing the fidelity of the results. Often more than one spring will be approved, then suggestions will be given for the choice of the ideal spring, however the user should be aware of the needs of your project. Because it is similar to the exercises done in the classroom and use a tool already known to the students, the material is of great interest to them. As a secondary objective the program can be improved for use by spring manufacturers and vendors