Desenvolvimento de planilha automatizada para dimensionamento e seleção de bomba hidráulica em dois patamares

Abstract

The pumps were created due to the need to capture, transport and store water to population centers far from rivers, Claudino (2020). This work aims to create a spreadsheet for dimensioning and selecting a hydraulic pump in two levels and uses this in a practical application in order to better explain and handle the spreadsheet. At first, a bibliographic review was carried out, in which basic books on pumps, hydraulic installations and fluid mechanics were used. The practical application adopted is the cultivation of soybeans on a farm in Brazil that needs to supply two reservoirs, one needs a flow of 40 m³/h and the other 80 m³/h, at different heights in order to meet the necessary requirements. The pump chosen was a single-stage centrifugal motor pump, semi-open rotor, model MSA-21 R/F 2 1/2, with a power of 20 hp and WEG IP 55 motor, 2 poles, 60 Hz. Finally, the work reached its main objective, building a general worksheet for dimensioning and selecting a hydraulic pump for the case of two reservoirs at different heights.