Automatic Calibration of Tank Model Using Microsoft Excel Solver
Article Sidebar
Published:
Jul 26, 2018
Keywords:
Automatic calibration coefficient Rainfall-Runoff model Tank model Microsoft Excel Solver
Main Article Content
Abstract
The objective of research is to determine optimal parameters of tank model using Microsoft Excel Solver. The parameters can be optimized and compared by using trial and error method and Microsoft Excel Solver. It can be concluded that model parameters using Microsoft Excel Solver showed better correlations more than that of trial and error method by increasing accuracy and convenience. The results showed that Microsoft Excel Solver can be used to calibrated Tank model parameter in Upper Yom River Basin. Additionally, for the research at hand, it was found that the best of objective function from the group of IA, Nash, R2and RMSE is IA
Article Details
How to Cite
[1]
ศาสนนันทน์ เ., “Automatic Calibration of Tank Model Using Microsoft Excel Solver”, sej, vol. 12, no. 2, pp. 151–159, Jul. 2018.
Section
Research Articles
Copyright belongs to Srinakharinwirot University Engineering Journal
References
[1] สนิท วงษา, “การพยากรณ์และเตือนภัยโดยใช้ข้อมูลรายวัน : กรณีศึกษาลุ่มน้ำปิงตอนบนจังหวัดเชียงใหม่,” วารสารวิจัยและพัฒนา มจธ., ฉบับที่ 30(2), หน้าที่ 315-327, 2007.
[2] J. Nash and J. Sutcliffe, "River flow forecasting through conceptual models part I — A discussion of principles", Journal of Hydrology, vol. 10, no. 3, pp. 282-290, 1970.
[3] M. Sugawara, "Automatic calibration of the tank model / L'étalonnage automatique d'un modèle à cisterne", Hydrological Sciences Bulletin, vol. 24, no. 3, pp. 375-388, 1979.
[4] Y. Yokoo, S. Kazama, M. Sawamoto and H. Nishimura, "Regionalization of lumped water balance model parameters based on multiple regression", Journal of Hydrology, vol. 246, no. 1-4, pp. 209-222, 2001.
[2] J. Nash and J. Sutcliffe, "River flow forecasting through conceptual models part I — A discussion of principles", Journal of Hydrology, vol. 10, no. 3, pp. 282-290, 1970.
[3] M. Sugawara, "Automatic calibration of the tank model / L'étalonnage automatique d'un modèle à cisterne", Hydrological Sciences Bulletin, vol. 24, no. 3, pp. 375-388, 1979.
[4] Y. Yokoo, S. Kazama, M. Sawamoto and H. Nishimura, "Regionalization of lumped water balance model parameters based on multiple regression", Journal of Hydrology, vol. 246, no. 1-4, pp. 209-222, 2001.