Application of Basic Excel Programming to Linear Muskingum Model for Open Channel Routing

Martins Olalekan Oyekanmi, Kamar Taiwo Oladepo


Flood routing as the process of determining the reservoir stage, storage volume of the outflow hydrograph corresponding to a known hydrograph of inflow.  It is viable technique for determining the flood hydrograph at a section of a river by utilizing the flow data at one or more upstream sections. It can be hydraulic and hydrologic. Some hydrological routing techniques include Muskingum method, Muskingum-Cunge method, Lag method and Kalinin-Milyukov method while many sophisticated computer programs like Matlab had been deployed for river routing.Muskingum Method for stream routing was considered by using spreadsheet for. Coefficients were determine using various hydrologic data and formula for the Muskingum method. A popular data with other three data sets were considered in a linear model. The value of k and x was calculated using the basics of Microsoft Excel cell programming. Analysis of variance (One- way) was performed to detect any significant difference in the methods compared with other study without basics of excel.The result shows no significant difference with the values computed in this present study, limitations of Muskingum method were highlighted and further research the subject is recommended.

Keywords: Flood routing, hydrograph, Muskingum method, hydraulic, hydrologic,

Full Text: PDF
Download the IISTE publication guideline!

To list your conference here. Please contact the administrator of this platform.

Paper submission email:

ISSN (Paper)2224-5790 ISSN (Online)2225-0514

Please add our address "" into your email contact list.

This journal follows ISO 9001 management standard and licensed under a Creative Commons Attribution 3.0 License.

Copyright ©