土壌の物理性
Online ISSN : 2435-2497
Print ISSN : 0387-6012
エクセルを使った逆解析法による土壌水理特性の推定
登尾 浩助
著者情報
ジャーナル フリー

2004 年 96 巻 p. 57-63

詳細
抄録

There is a big demand to predict water movement and solute transport in soil not only in agricultural but also in environmental fields. To predict water distribution in soil, soil hydraulic properties, i.e. a water characteristic curve and hydraulic conductivity, should be known in priori. Measurement of soil hydraulic properties, however, is usually time consuming and laborious work. Recent improvements of computing power on PC enabled us to inversely estimate hydraulic properties using a numerical simulation model along with experimental data. Spreadsheet-type software, which has a macro language and a solver, is also popular. In this study Excel was used to numerically simulate soil water movement using the finite difference method written in Visual BASIC as a macro function. The solver function of Excel successfully worked with the numerical model to estimate best-fitted values for soil hydraulic properties by comparing simulated results with temporal changes in soil water content measured. The tempo-ral changes in water content were measured with time domain reflectometry (TDR) at 20 cm below the soil surface during water infiltration into loamy sand. A water characteristic curve with parameters inversely estimated reasonably agreed with that with parameters experimentally determined. Saturated hydraulic conductivity inversely estimated also agreed well with that determined by an experiment. Excel would be alternative software to estimate soil hydraulic properties with an inverse procedure.

著者関連情報
© 2004 土壌物理学会
前の記事 次の記事
feedback
Top