Abstract
Streamflow data is required for planning and design of various hydraulic structures and water resource projects such as bridges, culverts, flood plain zoning, flood protection works, flood warning systems, and assessment of water resources potential. A reliable and continuous record of streamflow data is, therefore, of utmost importance. However, it is very difficult to maintain a continuous record of discharge and sometimes even impractical during floods. A continuous record of elevation of water surface in a stream above some arbitrary datum or the stage of river is rather easy and accurate as compared to discharge. A functional relationship between stage and discharge at a site in a river is called the rating curve. The accuracy of discharge estimated from the rating curve depends on the accuracy of stage measurement and development of the rating curve. The conventional method of regression analysis for the development of the rating curve often fails to give stage–discharge relationship accurately. In the present study, a simple and quick Excel solver technique has been used for the development of the rating curve accurately. The results of the solver in Excel are compared with conventional method of regression analysis. The statistical parameters such as root mean square error, correlation coefficient, and Nash criteria were computed for assessment of the performance of these methods for the rating curve development. It has been found that the performance of the Excel solver is better than that of the conventional method.
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
References
Braca G (2008) Stage-discharge relationships in open channels: practices and problems. FORALPS Technical Report, 11. Università degli Studi di Trento, Dipartimento di Ingegneria Civile e Ambientale. Trento, Italy
Bisht DCS, Raju MM, Joshi MC (2010) ANN based river stage-discharge modelling for Godavari river, India. Comput Modell New Technol 14(3):48–62
Bhattacharya B, Solomatine DP (2005) Neural networks and M5 model trees in modelling water level-discharge relationship. Neurocomputing 63(2005):381–396
Fenton JD, Keller RJ (2001) The calculation of streamflow from measurements of stage. CRC for Catchment Hydrology
Ghimire BNS, Reddy MJ (2010) Development of stage-discharge rating curve in river using genetic algorithms and model tree. In: International workshop advances in statistical hydrology. Taormina, Italy
Guven A, Ayetak A (2009) New approach for stage-discharge relationship: Gene expression programming. J Hydrol Eng, 14(8):482–492
Habib EH, Meselhe EA (2006) Stage-discharge relations for low-gradient tidal streams using data-driven models. J Hydraul Eng 132(5):482–492
Herschy RW (1995) Streamflow measurement, 3rd edn. E & FN Spon, London
Jain SK (2008) Development of integrated discharge and sediment rating relation using a compound neural network. J Hydrologic Eng 13(3):124–131
Jain SK, Chalisgaonkar D (2000) Setting up stage-discharge relations using ANN. J Hydrologic Eng 5(4):428–433
Lasdon LS, Smith S (1992) Solving sparse nonlinear programs using GRG. ORSA J Comput 4(1):2–15
McGinn R, Chubak N (2002) A rating curve based on lake levels: evaluating outlet flow for clear creek, riding mountain national park, Manitoba. Prairie Perspect: Geogr Essays 5:17–29
Mir Y, Dubeau F (2014) Least square fitting of the stage-discharge relationship using smooth models with curvilinear asymptotes. J Hydrol Sci. doi:10.1080/02626667.2014.935779
Moyeed RA, Clarke RT (2005) The use of Bayesian methods for fitting rating curves, with case studies. Adv Water Resour. 28:807–818
Petersen-Øverleir A (2004) Modelling stage-discharge relationships affected by hysteresis using the Jones formula and nonlinear regression. J Hydrol Sci, 51(3):365–388
Premium Solver Platform, User Guide (2010) Frontline Systems, Inc
Reddy PJR (2011) A textbook of hydrology, 3rd edn. Laxmi publication, New Delhi, pp 154–200
Sivapragasam C, Muttil N (2005) Discharge rating curve extension—A new approach. Water Resour Manage, 19:505–520
Subramanya K (2008) Engineering Hydrology, 3rd edn. Tata McGraw-Hill, New Delhi, pp 101–133
Sudheer KP, Jain SK (2003) Radial basis function neural network for modelling rating curves. J Hydrol Eng 8(3):161–164
Tawfik M, Ibrahim A, Fahmy H (1997) Hysteresis sensitive Neural Network for modelling rating curves. J Computing Civ Eng, 11(3):206–211
Author information
Authors and Affiliations
Corresponding author
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2018 Springer Nature Singapore Pte Ltd.
About this paper
Cite this paper
Muzzammil, M., Alam, J., Zakwan, M. (2018). A Spreadsheet Approach for Prediction of Rating Curve Parameters. In: Singh, V., Yadav, S., Yadava, R. (eds) Hydrologic Modeling. Water Science and Technology Library, vol 81. Springer, Singapore. https://doi.org/10.1007/978-981-10-5801-1_36
Download citation
DOI: https://doi.org/10.1007/978-981-10-5801-1_36
Published:
Publisher Name: Springer, Singapore
Print ISBN: 978-981-10-5800-4
Online ISBN: 978-981-10-5801-1
eBook Packages: Earth and Environmental ScienceEarth and Environmental Science (R0)