Application of a spreadsheet hydrological model for computing the long-term water balance of Lake Awassa,Ethiopia

Abstract

The water balance of the closed freshwater Lake Awassa was estimated using a spreadsheet hydrological model based on long-term monthly hydrometeorological data. The model uses monthly evaporation, river discharge and precipitation data as input. The net groundwater flux is obtained from model simulation as a residual of other water balance components. The result revealed that evaporation, precipitation, and runoff constitute 131, 106 and 83 × 10⁶ m³ of the annual water balance of the lake, respectively. The annual net groundwater outflow from the lake to adjacent basins is 58 × 10⁶ m³. The simulated and recorded lake levels fit well for much of the simulation period (1981–1999). However, for recent years, the simulated and recorded levels do not fit well. This may be explained in terms of the combined effects of land-use change and neotectonism, which have affected the long-term average water balance. With detailed long-term hydrogeological and meteorological data, investigation of the subsurface hydrodynamics, and including the effect of land-use change and tectonism on surface water and groundwater fluxes, the water balance model can be used efficiently for water management practice. The result of this study is expected to play a positive role in future sustainable use of water resources in the catchment.