Predicting Muskingum flood routing parameters using spreadsheets

Abstract

In this study, two easy to use and high precision solution methods that can be used for educational and engineering purposes are proposed. The first of these methods is the "Trial-Error with Spreadsheet" procedure combining basic properties of spreadsheets and the other method is the "Nonlinear optimization with Solver" procedure that uses the nonlinear optimization code and the "Iterative calculation" which is one of the most effective properties of spreadsheets. Both of the proposed methods are tested on three samples given in literature and the comparisons of the model results, observation results, and the results of other solution techniques in literature are made. © 2009 Wiley Periodicals, Inc.