Fitting Infiltration Models Data Using The Ms. Excel
Fitting Infiltration Models Data Using The Ms. Excel
Fitting Infiltration Models Data Using The Ms. Excel
5 1.75
10 3
15 3.95
25 5.5
45 7.25
60 8.3
75 9.3
90 10.2
110 11.28
130 12.36
Time (hour)
0.0833333333333333
0.166666666666667
0.25
0.416666666666667
0.75
1
1.25
1.5
1.83333333333333
2.16666666666667
Time (hour)
0.0833333333333333
0.166666666666667
0.25
0.416666666666667
0.75
1
1.25
1.5
1.83333333333333
2.16666666666667
fp-infiltration capacity at any time fc-final steady state infiltration capacity
fo-inititial infiltration capacity k-horton's decay coefficient which depends upon soil characteristics and vegetation cover
ln(fp-fc)
ln(fp-fc)
2.87694873756402 3.5
3
2.46470394247048
2.5 f(x) = − 2.67512772793246 x + 2.88676330954702
2.09924416897602
2 R² = 0.985920444266846
1.80170980008122 1.5
0.698134722070984 1
-0.0408219945202524 0.5
-0.274436845701761 0
0 0.5 1 1.5 2 2.5
-1.021651247532 -0.5
-1
-1.5
hich depends upon soil characteristics and vegetation cover
(incremental depth/ time interval)*60min ln(infiltation rate - final steady state infiltration rate(3.24))
Infiltration rate - fp (cm/h) ln(fp-fc)
21 2.87694873756402
15 2.46470394247048
11.4 2.09924416897602
9.3 1.80170980008122
5.25 0.698134722070984
4.2 -0.0408219945202524
4 -0.274436845701761
3.59999999999999 -1.021651247532
3.24
3.24
Chart Title
25 14
12
20
10
15 8
10 6
4
5
2
0 0
0 0.5 1 1.5 2 2.5
ln(fp-fc)
93246 x + 2.88676330954702
6846
1 1.5 2 2.5
slope (k) 2.6751
ln(f0-fc) 2.8868
f0-fc 17.9304553673457
f0 21.1704553673457
time start/60 min
Time (hour)
0.0833333333333
0.1666666666667
0.25
0.4166666666667
0.75
1
1.25
1.5
1.8333333333333
2.1666666666667
this is obtain by subtituting the value of x as zero which obtatin intercept
anti log= 2.718 2.718^ln(fo-fc)
(f0-fc)+final steady state infiltration rate(3.24)
DET. THE PARAMETER OF PHILIP'S EQUATION
0
0 0.5 1 1.5 2 2.5 3 3.5 4
3.2287 s 6.4574 2*the s/2(3.2287)
1.23
F (in.)
ks-max. hydraulc conductivity 1.97 in./hr 0
Os-saturated moisture content 0.518 0.24
Oi-initial moisture content 0.318 0.625
sunction head 𝜓 -9.317 1
i-rainfall intesity 7.88 in./hr 2
3
4
5
F(in/hr) F(in/hr)
7.88
9
7.88
8
7.88 7
5.66178 6
3.81589 5
3.20059333 4
2.892945 3
2.708356 2
1
0
0 1 2 3 4 5 6