Application of Excel optimisation tool in solving and teaching water resource problems
by Mohammad Zakwan
International Journal of Hydrology Science and Technology (IJHST), Vol. 14, No. 1, 2022

Abstract: Many realistic problems in water resource engineering are too complex to solve manually. Teaching such complex problems becomes a real challenge especially at undergraduate level, but, civil engineering graduates need to be competent enough to provide practical solution to these water resource problems. Most of the undergraduate civil engineering students are well versed with the knowledge of Microsoft Excel. In the present paper, several water resource engineering problems have been solved using Excel solver. Students may evolve a relevant mathematical algorithm to delineate pragmatic structure of the problem and utilise solver to work out that model for any group of input data. In the present paper, Excel solver has been applied to model channel routing, hysteresis affected stage-discharge curves, infiltration depth, scour depth, determination of optimal channel dimension and critical depth in open channel flow. Apart from simplicity, the other advantage of using Excel (spreadsheet) solver is that the solver does not conceal conceptual formulation of the problem. In this way Excel solver may prove to be a useful tool for teaching water resource engineering at undergraduate level.

Online publication date: Thu, 30-Jun-2022

The full text of this article is only available to individual subscribers or to users at subscribing institutions.

 
Existing subscribers:
Go to Inderscience Online Journals to access the Full Text of this article.

Pay per view:
If you are not a subscriber and you just want to read the full contents of this article, buy online access here.

Complimentary Subscribers, Editors or Members of the Editorial Board of the International Journal of Hydrology Science and Technology (IJHST):
Login with your Inderscience username and password:

Username:        Password:          Forgotten your password?

Want to subscribe?
A subscription gives you complete access to all articles in the current issue, as well as to all articles in the previous three years (where applicable). See our Orders page to subscribe.

If you still need assistance, please email subs@inderscience.com