Application of excel solver for parameter estimation of the nonlinear Muskingum models
- 1.2k Downloads
The Muskingum model continues to be a popular procedure for river flood routing. An important aspect in nonlinear Muskingum models is the calibration of the model parameters. The current study presents the application of commonly available spreadsheet software, Microsoft Excel 2010, for the purpose of estimating the parameters of nonlinear Muskingum routing models. Main advantage of this approach is that it can calibrate the parameters using two different ways without knowing the exact details of optimization techniques. These procedures consist of (1) Generalized Reduced Gradient (GRG) solver and (2) evolutionary solver. The first one needs the initial values assumption for the parameter estimation while the latter requires the determination of the algorithm parameters. The results of the simulation of an example that is a benchmark problem for parameter estimation of the nonlinear Muskingum models indicate that Excel solver is a promising way to reduce problems of the parameter estimation of the nonlinear Muskingum routing models. Furthermore, the results indicate that the efficiency of Excel solver for the parameter estimation of the models can be increased, if both GRG and evolutionary solvers are used together.
Keywordsflood routing hydrologic model spreadsheets parameter estimation
Unable to display preview. Download preview PDF.
- Akbari, G. H. and Barati, R. (2012). “Comprehensive analysis of flooding in unmanaged catchments.” Proceedings of the Institution of Civil Engineers-Water Management, p. 165.Google Scholar
- ASCE Task Committee on Definition of Criteria for Evaluation of Watershed Models of the Watershed Management Committee, Irrigation and Drainage Division. (1993). “Criteria for evaluation of watershed models.” Journal of Irrigation and Drainage Engineering, ASCE, Vol. 119, No. 3, pp. 429–442.CrossRefGoogle Scholar
- Chow, V. T. (1959). “Open channel hydraulics.” McGraw-Hill, New York, p. 680.Google Scholar
- Fontane, D. (2001). “Multi-objective simulation and optimization of reservoir operation using Excel.” Proceeding of the Second Federal Interagency Hydrologic Modeling Conference, Las Vegas, NV, USA.Google Scholar
- Wilson, E. M. (1974). Engineering hydrology, MacMillan, Hampshire, UK.Google Scholar
- Wong, T. S. W. and Zhou, M. C. (2004). “Determination of critical and normal depths using excel.” Proceedings of World Water and Environmental Resources Congress, Saltlake City Utah, USA.Google Scholar