Automatic Calibration of Tank Model Using Microsoft Excel Solver

Main Article Content

เสฎฐา ศาสนนันทน์


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
ศาสนนันทน์ เ., “Automatic Calibration of Tank Model Using Microsoft Excel Solver”, sej, vol. 12, no. 2, pp. 151–159, Jul. 2018.
Research Articles


[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.