Desenvolvimento de planilha de cálculo para definição de vigas metálicas de frigoríficos

Abstract

Within engineering, it is increasingly necessary to reduce project lead time, and also to reduce the number of hours spent carrying out tasks, these reductions are reflected in shorter deadlines and greater profitability. In the engineering of refrigeration projects it is no different, the food sector is constantly expanding and Brazil, in addition to being a large producer of food, is also a large manufacturer of equipment to process it. The production line of a refrigerator is basically made up of equipment resting on the floor and several overhead conveyors fixed to an independent metal structure. These conveyors carry the suspended product through different process areas to the shipping sector. The aim of this work was to simplify and anticipate the definition of the beam profiles of this independent structure that will support the conveyors, providing designers with a dynamic spreadsheet that anticipates the results that will be obtained by the calculator using specific software. The spreadsheet was developed so that designers inform two variables known to them during the design phase, which are the load of the transported product and the span of the beam, thus obtaining the appropriate structural profile as output data. The main results achieved with the project are the sizing spreadsheet based on the ABNT NBR8800:2008 standard, developed in Microsoft Office Excel software, and also a table of gauge results based on several span and loading simulations.