DEVELOPMENT OF RIVER FLOOD ROUTING MODEL USING NON-LINEAR MUSKINGUM EQUATION AND EXCEL TOOL 'GANetXL'

Flood routing is of utmost importance to water resources engineers and hydrologist. Muskingum model is one of the popular methods for river flood routing which often require a huge computational work. To solve the routing parameters, most of the established methods require knowledge about different computer programmes and sophisticated models. So, it is beneficial to have a tool which is comfortable to users having more knowledge about everyday decision making problems rather than the development of computational models as the programmes. The use of micro-soft excel and its relevant tool like solver by the practicing engineers for normal modeling tasks has become common over the last few decades. In excel environment, tools are based on graphical user interface which are very comfortable for the users for handling database, modeling, data analysis and programming. GANetXL is an add-in for Microsoft Excel, a leading commercial spreadsheet application for Windows and MAC operating systems. GANetXL is a program that uses a Genetic Algorithm to solve a wide range of single and multi-objective problems. In this study, non-linear Muskingum routing parameters are solved using GANetXL. Statistical Model performances are compared with the earlier results and found satisfactory.

[1]  Duke Ophori,et al.  Groundwater resources management in the Afram Plains area, Ghana , 2008 .

[2]  David A. Chin,et al.  Water-Resources Engineering , 1999 .

[3]  David E. Goldberg,et al.  Genetic Algorithms in Search Optimization and Machine Learning , 1988 .

[4]  M. Tamer Ayvaz,et al.  Transient groundwater modeling using spreadsheets , 2005, Adv. Eng. Softw..

[5]  Jiancang Xie,et al.  Parameter Estimation for Nonlinear Muskingum Model Based on Immune Clonal Selection Algorithm , 2010 .

[6]  Jaewan Yoon,et al.  Parameter Estimation of Linear and Nonlinear Muskingum Models , 1993 .

[7]  Jong-Seok Lee.  Uncertainties in the predicted number of life loss due to the dam breach floods , 2003 .

[8]  Amlan Das,et al.  Parameter Estimation for Muskingum Models , 2004 .

[9]  Jong-Seok Lee,et al.  The impacts of uncertainty in the predicted dam breach floods on economic damage estimation , 2003 .

[10]  Reza Barati,et al.  Developing a model for analysis of uncertainties in prediction of floods , 2012 .

[11]  Vijay P. Singh,et al.  Hydrologic Systems: Rainfall-Runoff Modeling , 1988 .

[12]  Liang-Cheng Chang,et al.  Applying Particle Swarm Optimization to Parameter Estimation of the Nonlinear Muskingum Model , 2009 .

[13]  Z. Geem,et al.  PARAMETER ESTIMATION OF THE NONLINEAR MUSKINGUM MODEL USING HARMONY SEARCH 1 , 2001 .

[14]  Rajib Kumar Bhattacharjya.  Solving Groundwater Flow Inverse Problem Using Spreadsheet Solver , 2011 .

[15]  Hone-Jay Chu,et al.  The Muskingum flood routing model using a neuro-fuzzy approach , 2009 .

[16]  Wei Chen,et al.  Water Distribution Network Analysis Using Excel , 2004 .

[17]  S. Mohan,et al.  Parameter Estimation of Nonlinear Muskingum Models Using Genetic Algorithm , 1997 .

[18]  D. Papamichail,et al.  Parameter Estimation Of Linear AndNonlinear Muskingum Models ForRiver Flood Routing , 1970 .

[19]  E. Wilson.  Engineering Hydrology , 1974 .

[20]  Dragan A. Savic,et al.  A DSS generator for multiobjective optimisation of spreadsheet-based models , 2011, Environ. Model. Softw..

[21]  M. A. Gill.  Flood routing by the Muskingum method , 1978 .

[22]  Reza Barati,et al.  Application of excel solver for parameter estimation of the nonlinear Muskingum models , 2013 .

[23]  Ismail I. Esen,et al.  Approximate Methods for the Estimation of Muskingum Flood Routing Parameters , 2006 .

[24]  Amlan Das,et al.  Chance-Constrained Optimization-Based Parameter Estimation for Muskingum Models , 2007 .

[25]  Garry L. Grabow,et al.  Planning for Water Allocation and Water Quality Using a Spreadsheet-Based Model , 2007 .

[26]  Steve Page,et al.  Developing a Model , 2010 .

[27]  B. Martin.  PARAMETER ESTIMATION , 2012, Statistical Methods for Biomedical Research.

[28]  Tommy S. W. Wong,et al.  Determination of Critical and Normal Depths Using Excel , 2004 .

[29]  Y. Tung.  River flood routing by nonlinear muskingum method , 1985 .

[30]  T. Sturm,et al.  Open Channel Hydraulics , 2001 .

[31]  Halil Karahan.  Solution of weighted finite difference techniques with the advection–diffusion equation using spreadsheets , 2008, Comput. Appl. Eng. Educ..