Desarrollo de hojas de cálculo mediante Excel para la selección de ventiladores industriales de tipo extractores centrífugos de tejado

Abstract

At present, the selection of centrifugal extractors is made conventionally. That is, the calculations are done manually, with the possibility of making errors in appreciating the numerical values. It is for this reason that this titling work had as its primary objective to automate the selection procedure of centrifugal roof fans by programming Excel sheets based on the practical ventilation manual of the Soler & Palau company. For this process, the calculation of the absorption flow rate was used as a starting point, for which the air velocity in the duct was established with the help of the respective table provided by the aforementioned practical manual, where values are recommended for this process speed type. The dynamic pressure was calculated in the next step, defined by the equation that relates pressure to air velocity. Continuing with the process, a solution was given to the dimensions of the rectangular section for the duct required in this application. Finally, to finish, the total pressure losses were determined to then select the extractor according to the flow calculated at the beginning so that the minimum conditions of the ventilation system and the work points of each extractor were related in this way. In the selection process of centrifugal fans, it was obtained as a result that the most appropriate fan for this adaptation is: CRVL-D-16-10, so it is concluded that to define a centrifugal extractor better, it is crucial to analyze the contribution of the point of work as well as the updated retail cost of the equipment.