Generación de herramientas computacional (macros) para automatizar el diseño de escaleras de peces tipo artesa : generación de herramientas para automatizar el diseño de escaleras de peces tipo r3elentizadora, esclusa y artesa

Abstract

"Hydraulic constructions obstruct the life cycle of aquatic beings, altering their habitat and generating abiotic modifications in the water; therefore, fish ladders are designed in order to guarantee the ecological flow and contribute to the conservation of the species. The information is obtained from different bibliographic research sources, in the thesis ""Design and optimization of tools (macros) for fish ladder sizing"" by Edwin Barrera and Daysi Sanunga [1]. A computational tool was developed to help in the sizing of fish ladders with successive pools and fish ladders with vertical slit. In this paper we continue with the development of computational tools for the trough type fish ladder, as well as in Excel macros. For each fish ladder model, there are different design parameters, recommendations for use, location and design criteria that facilitate the sizing of the fish ladder. With this information, the fish ladder that best suits the design characteristics should be chosen, considering the adaptation of the ichthyofauna in each of the structures, where velocities, slopes and flow rates intervene. The trough type ladder is subdivided into several models: with orifice, spillway and mixed. This type of fish ladder is chosen for flow rates of 0.25 to 0.7 m3/s, with maximum slopes of 10% and for inlet velocities not exceeding 2 m/s. In addition, there are abacuses of the morphological capacities of fish passing through this type of ladder. The trough type fish ladder has inlet and outlet pools, fish resting ponds, dikes, dividing walls that form the ponds and structures such as the weir and orifice. A computational tool was generated in Excel macros, whose function is to facilitate the dimensioning of trough type fish ladder, also to know how to use the tool, a user manual and a didactic video were elaborated to facilitate and familiarize the user with the use of this tool."