Spreadsheet tools for developing surface water supplies for freshwater fish production in developing countries

• Published in: Aquacultural engineering 2004-08, Vol.31 (1), p.31-49
• Main Authors: Tollner, E.W., Meyer, Dan, Triminio-Meyer, Suyapa, Verma, Brahm P., Pilz, George, Molnar, Joseph J.
• Format: Article
• Language: English
• Subjects: Animal aquaculture; Animal productions; Biological and medical sciences; computer software; data analysis; developing countries; equations; fish production; Freshwater; freshwater fish; Fundamental and applied biological sciences. Psychology; hydrologic models; Hydrology; levee pond model; Pisciculture; Pond; ponds; rain; Runoff; Spreadsheet model; surface water; Vertebrate aquaculture; water flow; water harvest evaluation model; water management; water supply; Watershed; watersheds
• ISSN: 0144-8609; 1873-5614
• DOI: 10.1016/j.aquaeng.2004.01.001

Variable rainfall distribution and terrain make surface water harvesting and storage a challenge in many developing countries. The overall goal of this study is to collect and develop information required to equip extension, non-governmental organization (NGO) agents, contractors and engineers for surface water development and aquaculture enterprise development in Honduras and Latin America. A pond water balance for the levee production pond enabling determination of water flow required to balance seepage, evaporation and direct rainfall was developed in English and Spanish on the Microsoft Excel ® platform. The pump-in flow rate can also be determined for reaching a volume change per month target. A second model was formulated for evaluating surface water capture by watershed and/or hillside ponds for meeting the levee pond demand. Using hillside ponds that fill by impounding a fraction of total runoff (e.g., diverting water upstream) from streams appears to have promise for meeting water needs. A systematic approach using both models to reach a sustainable water supply target emerged from this work. Both the levee pond model and the water harvest model are based on balancing inputs and outputs given monthly rainfall patterns. A simple approach to mechanical spillways preliminary design was developed. The models are adaptable to any location if key input data is available, particularly average monthly rainfall and storm frequency–duration data. The models do not address water quality issues. The software is intended for watershed sizes not larger than 500 ha and storage ponds of less than 5 ha surface area—4 m depth due to relationship limitations and safety concerns. Coupling with other cooperative development concerns such as marketing association provides a platform for helping groups of people in a watershed to realize further the potential of enlightened self-interest in developing common solutions to water problems.