Embed Size (px)
DESCRIPTION
Excel-Tp6.
Citation preview
H (m) = 20r1 (m) = 6r2 (m) = 8 K (m/s) = 2.457E-05Q (m3/s)= 6.80E-03 K (cm/s) = 2.46E-07 ®s1 (m)= 0.85s2 (m)= 0.2h1 (m) = 19.15h2 (m) = 19.8
Arcilla no meterorizadas, impermeables
Tiempo (dias) descenso (m) r^2/t W(u) 20.0045 0.03 88888.8889 u 0.10.0056 0.05 71428.57140.0064 0.06 62500 T = 875.3521870.0075 0.07 53333.3333 S= 0.03501409
0.01 0.09 40000 K= 159.1549430.0116 0.11 34482.7586
0.014 0.13 28571.42860.0187 0.17 21390.3743
0.025 0.21 160000.0282 0.23 14184.39720.0375 0.27 10666.66670.0643 0.36 6220.839810.1405 0.49 2846.97509
0.25 0.6 16000.33 0.65 1212.12121
0.5333 0.73 750.0468780.66 0.78 606.0606060.83 0.82 481.927711
1 0.85 4001.5 0.93 266.666667
r(m) 20Q (m3/dia) 1650m (m) 5.5
u w (u)1 0.2192 0.0493 0.0134 0.00385 0.001146 0.000367 0.000128 0.0000389 0.000012
1.00E-01 1.822.00E-01 1.223.00E-01 0.914.00E-01 0.75.00E-01 0.566.00E-01 0.457.00E-01 0.378.00E-01 0.319.00E-01 0.261.00E-02 4.042.00E-02 3.353.00E-02 2.96
1E-15 1E-12 0.000000001 0.000001 0.001 1 1000 1000000
0.00001
0.0001
0.001
0.01
0.1
1
10
100
Chart Title1E-15 1E-12 0.000000001 0.000001 0.001 1 1000 1000000
0.00001
0.0001
0.001
0.01
0.1
1
10
100
Chart Title
4.00E-02 2.685.00E-02 2.486.00E-02 2.27.00E-02 2.158.00E-02 2.039.00E-02 1.921.00E-03 6.332.00E-03 5.643.00E-03 5.234.00E-03 4.955.00E-03 4.736.00E-03 4.547.00E-03 4.398.00E-03 4.269.00E-03 4.141.00E-04 8.632.00E-04 7.943.00E-04 7.534.00E-04 7.255.00E-04 7.026.00E-04 6.847.00E-04 6.698.00E-04 6.559.00E-04 6.441.00E-05 10.952.00E-05 10.243.00E-05 9.844.00E-05 9.555.00E-05 9.336.00E-05 9.147.00E-05 8.998.00E-05 8.869.00E-05 8.741.00E-06 13.242.00E-06 12.553.00E-06 12.144.00E-06 11.855.00E-06 11.636.00E-06 11.457.00E-06 11.298.00E-06 11.169.00E-06 11.041.00E-07 15.542.00E-07 14.853.00E-07 14.444.00E-07 14.155.00E-07 13.936.00E-07 13.75
1E-15 1E-12 0.000000001 0.000001 0.001 1 1000 1000000
0.00001
0.0001
0.001
0.01
0.1
1
10
100
Chart Title1E-15 1E-12 0.000000001 0.000001 0.001 1 1000 1000000
0.00001
0.0001
0.001
0.01
0.1
1
10
100
Chart Title
7.00E-07 13.68.00E-07 13.469.00E-07 13.341.00E-08 17.842.00E-08 17.153.00E-08 16.744.00E-08 16.465.00E-08 16.236.00E-08 16.657.00E-08 15.98.00E-08 15.769.00E-08 15.651.00E-09 20.152.00E-09 19.453.00E-09 19.054.00E-09 18.765.00E-09 18.546.00E-09 18.257.00E-09 18.28.00E-09 18.079.00E-09 17.951.00E-10 22.452.00E-10 21.763.00E-10 21.254.00E-10 21.065.00E-10 20.846.00E-10 20.667.00E-10 20.58.00E-10 20.379.00E-10 20.251.00E-11 24.752.00E-11 24.653.00E-11 23.654.00E-11 23.365.00E-11 23.146.00E-11 22.967.00E-11 22.818.00E-11 22.679.00E-11 22.551.00E-12 27.052.00E-12 26.363.00E-12 25.954.00E-12 25.665.00E-12 25.446.00E-12 25.267.00E-12 25.118.00E-12 24.979.00E-12 24.86
1.00E-13 29.362.00E-13 28.663.00E-13 28.264.00E-13 27.975.00E-13 27.756.00E-13 27.567.00E-13 27.418.00E-13 27.289.00E-13 27.161.00E-14 31.662.00E-14 30.973.00E-14 30.564.00E-14 30.275.00E-14 30.056.00E-14 29.877.00E-14 29.718.00E-14 29.589.00E-14 29.461.00E-15 33.962.00E-15 33.273.00E-15 32.864.00E-15 32.585.00E-15 32.356.00E-15 32.177.00E-15 32.028.00E-15 31.889.00E-15 31.76
s 0.3r^2/t 10000
coincide con el suelo dato
1E-15 1E-12 0.000000001 0.000001 0.001 1 1000 1000000
0.00001
0.0001
0.001
0.01
0.1
1
10
100
Chart Title1E-15 1E-12 0.000000001 0.000001 0.001 1 1000 1000000
0.00001
0.0001
0.001
0.01
0.1
1
10
100
Chart Title
1E-15 1E-12 0.000000001 0.000001 0.001 1 1000 1000000
0.00001
0.0001
0.001
0.01
0.1
1
10
100
Chart Title1E-15 1E-12 0.000000001 0.000001 0.001 1 1000 1000000
0.00001
0.0001
0.001
0.01
0.1
1
10
100
Chart Title
1E-15 1E-12 0.000000001 0.000001 0.001 1 1000 1000000
0.00001
0.0001
0.001
0.01
0.1
1
10
100
Chart Title1E-15 1E-12 0.000000001 0.000001 0.001 1 1000 1000000
0.00001
0.0001
0.001
0.01
0.1
1
10
100
Chart Title
1E-15 1E-12 0.000000001 0.000001 0.001 1 1000 1000000
0.00001
0.0001
0.001
0.01
0.1
1
10
100
Chart Title1E-15 1E-12 0.000000001 0.000001 0.001 1 1000 1000000
0.00001
0.0001
0.001
0.01
0.1
1
10
100
Chart Title
Tiempo (dias) descenso (m)0.0045 0.030.0056 0.050.0064 0.060.0075 0.07
0.01 0.090.0116 0.11
0.014 0.130.0187 0.17
0.025 0.210.0282 0.230.0375 0.270.0643 0.360.1405 0.49
0.25 0.60.33 0.65
0.5333 0.730.66 0.780.83 0.82
1 0.851.5 0.93
Q (m3/dia) 1650 T 847.350875s=0 --> to= 0.09 S 0.43049661Δs 0.9tf 1.5ti 0.0045r (m) 20
0.001 0.01 0.1 1 10
0
0.1
0.2
0.3
0.4
0.5
0.6
0.7
0.8
0.9
1
s- log t
0.001 0.01 0.1 1 10
0
0.1
0.2
0.3
0.4
0.5
0.6
0.7
0.8
0.9
1
s- log t
