Fitting Infiltration Models Data Using The Ms. Excel

Download as xlsx, pdf, or txt
Download as xlsx, pdf, or txt
You are on page 1of 12

Time since start (mins) Fp - Cumulative Infiltration depth (cm)

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

time start 1st line cumulative infiltration depth 1st line


2nd line - 1st line 2nd line - 1st line
Time Interval (mins) Incremental depth in interval (cm)
5 1.75
5 1.25
5 0.95
10 1.55
20 1.75
15 1.05
15 1
15 0.899999999999999
20 1.08
20 1.08

Infiltration rate - fp (cm/h) Fp - Cumulative Infiltration depth (cm)


21 1.75
15 3
11.4 3.95
9.3 5.5
5.25 7.25
4.2 8.3
4 9.3
3.59999999999999 10.2
3.24 11.28
3.24 12.36

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

Infiltration rate - fp (cm/h)


Fp - Cumulative Infiltration depth (cm)

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

Time since start (mins) Fp - Cumulative Infiltration depth (cm)


5 1
10 1.8
15 2.5
20 3.1
25 3.6
30 4
60 6.1
90 8.1
120 9.9
150 11.6

Infiltration rate - fp (cm/h)


3.46410161513776 12
2.44948974278318 9.6
2 8.4
1.73205080756888 7.2
1.54919333848297 6
1.4142135623731 4.8
1 4.2
0.816496580927726 4
0.707106781186548 3.6
0.632455532033676 3.4
Plot fp on y-axis and on x axis
slope s/2
intercept k
cumulative infiltration depth 1st line time start 1st line
2nd line - 1st line 2nd line - 1st line (incremental depth/ time interval)*60min
Incremental depth in interval (cm) Time Interval (mins) Infiltration rate - fp (cm/h)
1 5 12
0.8 5 9.6
0.7 5 8.4
0.6 5 7.2
0.5 5 6
0.4 5 4.8
2.1 30 4.2
2 30 4
1.8 30 3.6
1.7 30 3.4

Infiltration rate - fp (cm/h)


14

12 f(x) = 3.22867182155369 x + 1.22996401642018


R² = 0.971313074683215
10

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

time start/60 min time(hours)^(-0.5)


Time (hours)
0.0833333333333 3.4641016151378
0.1666666666667 2.4494897427832
0.25 2
0.3333333333333 1.7320508075689
0.4166666666667 1.549193338483
0.5 1.4142135623731
1 1
1.5 0.8164965809277
2 0.7071067811865
2.5 0.6324555320337
FOR THE FF. SOIL PROPERTIES, DEVELOP A PLOT OF INFILTRATION RATE F VS. THE INFILTRATION VOLUME F USING

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

use this to get the F (in/hr)


HE INFILTRATION VOLUME F USING THE GREEN AMPT EQ.

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

when f is equal to 0 until fs is the infiltr


use this to get the F (in/hr)
equal to 0 until fs is the infiltration rate will be equal to rainfal intensity

You might also like