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

Abstract

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,