Authors: Kee An Hong¹٭, Jer Lang Hong²

¹Hong & Associates, Kuala Lumpur, Malaysia
²SNS Network, Kuala Lumpur, Malaysia

Corresponding author:Kee An Hong

Email: [email protected]

Abstract

The easy-to-use and accurate Excel Solver has been used in this paper for the estimation of Muskingum routing parameters for the Krian river in Malaysia with available flood hydrograph data. A simple way is to use the “nonlinear optimization with solver procedure” of the Excel spreadsheets that uses the nonlinear optimization code and the iterative calculation properties of the spreadsheets. The Excel Solver method when tested on the Krian river shows that accurate results are obtained when compared to observed flows based on evaluation statistics such as mean absolute error, root means square error, and Nash Sutcliffe efficiency coefficient. Results are also compared to those of HEC-HMS and it is noted that almost similar results are obtained from the two methods.

Keywords: Excel Solver, Muskingum-HMS, RMSE, MAE, NSE, GRG