The platform QUAL-UFMG on Excel is a tool simple to use with wide applicability to modeling the water quality of rivers. To better integrate the model with the management of water resources, the aim of this study was to incorporate in the simulation spreadsheets some equations for determination of dilution and recovery by the effluent discharge. Hypothetical water quality scenarios were simulated to estimate the capacity of self-depuration and dilution of effluent in a case study in Taquarizinho River. The model was able to estimate the flows required by dilution effluents and account for costs in varying the reference flows, class of water and organic load released into the river. It was concluded that Rio Taquarizinho has a high capacity for self-depuration, and that its waters are capable of supporting the installation of large-scale enterprises such as slaughterhouses and tanneries
water quality; mathematical modeling; water resources management
