Calculo Del Icum En Excel.xlsx
This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA
Overview
Download & View Calculo Del Icum En Excel.xlsx as PDF for free.
More details
- Words: 860
- Pages: 7
Icum
Log To (X) Log Icum (Y)
0 1 2 3 4 5 6 7 10 13 16 21 26 31 41 51
Tiempo 0 1 2 3 4 5 6 7 10 13 16 21 26 31 41 51
tiempo 0 1 2 3 4 5
0 1 1.7 2.3 2.6 3.1 3.5 4 5 5.6 6.3 7.2 8.3 9.3 11.1 12.9
0.000 0.301 0.477 0.602 0.699 0.778 0.845 1.000 1.114 1.204 1.322 1.415 1.491 1.613 1.708 14.569
0.000 0.230 0.362 0.415 0.491 0.544 0.602 0.699 0.748 0.799 0.857 0.919 0.968 1.045 1.111 9.792
XY 0.000 0.069 0.173 0.250 0.343 0.423 0.509 0.699 0.833 0.963 1.134 1.300 1.444 1.686 1.896 11.723
Icum 0.00 1.07 1.67 2.16 2.60 3.00 3.37 3.72 4.67 5.52 6.31 7.51 8.61 9.64 11.52 13.25
Y2
0.000 0.091 0.228 0.362 0.489 0.606 0.714 1.000 1.241 1.450 1.748 2.002 2.224 2.601 2.916 17.671
0.000 0.053 0.131 0.172 0.241 0.296 0.362 0.489 0.560 0.639 0.735 0.845 0.938 1.093 1.233 7.787
100.00
10.00
1.00 1
10
Tiempo (min)
CACULO DE LA VELOCIDAD DE INFILTRACION vel. Inf. (I) Log To (X) Log (Y) XY 12 9 6 4.5 4.2
X2
Lámina Infltrada Acumulada
Tiempo
0.000 0.301 0.477 0.602 0.699
1.079 0.954 0.778 0.653 0.623
0.000 0.287 0.371 0.393 0.436
X2
Y2
0.000 0.091 0.228 0.362 0.489
1.165 0.911 0.606 0.427 0.388
3.5 3 2.625 2.33 2.4 1.85 1.5 1.42 1.125 1.03 0.9 0.74 0.61 0.52 0.46 0.4 0.33
tiempo 1 2 3 4 5 6 7 10 13 16 21 26 31 41 51
vel. Inf. (I) 20.0 18.7 18.0 17.4 17.1 16.8 16.5 15.9 15.5 15.2 14.8 14.5 14.2 13.8 13.5
0.778 0.845 0.903 0.954 1.000 1.114 1.204 1.279 1.380 1.462 1.531 1.643 1.732 1.806 1.924 2.017 2.127 25.781
0.544 0.477 0.419 0.367 0.380 0.267 0.176 0.152 0.051 0.013 -0.046 -0.131 -0.215 -0.284 -0.337 -0.398 -0.481 5.044
0.423 0.403 0.379 0.351 0.380 0.298 0.212 0.195 0.071 0.019 -0.070 -0.215 -0.372 -0.513 -0.649 -0.803 -1.024 0.571 0.571
0.606 0.714 0.816 0.911 1.000 1.241 1.450 1.635 1.905 2.139 2.345 2.701 3.001 3.262 3.703 4.068 4.525 37.190
0.296 0.228 0.176 0.135 0.145 0.071 0.031 0.023 0.003 0.000 0.002 0.017 0.046 0.081 0.114 0.158 0.232 5.253
100.0
Velocidad deInfltracióm (cm/h)
6 7 8 9 10 13 16 19 24 29 34 44 54 64 84 104 134
10.0
1.0 0
10
20
30
Tiempo (h)
40
50
tiempo 1 2 3 4 5 6 7 10 13 16 21 26 31 41 51
vel. Inf. (I) 16.6 16.5 16.4 16.4 16.3 16.3 16.3 16.2 16.2 16.1 16.1 16.1 16.0 16.0 16.0
tiempo 1 2 3 4 5 6 7 10 13 16 21 26 31 41 51
vel. Inf. (I) 20.0 18.7 18.0 17.4 17.1 16.8 16.5 15.9 15.5 15.2 14.8 14.5 14.2 13.8 13.5
Velocidad de Infltración Promedio (cm/h) Lámina Infltrada 100
10
Tiempo (min)
100
10
1
0.1 10
Icum
1 1
100 10
Tiempo
Icum 100
Velocidad de Infltraci Promedio (cm/h)
10
1
0.1 1
10
100
Tiempo (horas)
vel. Inf. (I)
20
30
Tiempo (h)
40
50
60
1000
tiempo 0 1 2 3 4 5 6 7 8 9 10 13 16 19 24 29 34 44 54 64 84 104 134
CACULO DE LA VELOCIDAD DE INFILTRACION vel. Inf. (I) Log To (X) Log (Y) XY 18 12 8 7.5 6 6 5.14 5.25 4.67 4.2 3.23 2.63 2.21 1.91 1.68 1.4 1.29 1.13 1 0.9 0.75 0.53
0.000 0.301 0.477 0.602 0.699 0.778 0.845 0.903 0.954 1.000 1.114 1.204 1.279 1.380 1.462 1.531 1.643 1.732 1.806 1.924 2.017 2.127 25.781
1.255 1.079 0.903 0.875 0.778 0.778 0.711 0.720 0.669 0.623 0.509 0.420 0.344 0.281 0.225 0.146 0.111 0.053 0.000 -0.046 -0.125 -0.276 10.036
0.000 0.325 0.431 0.527 0.544 0.606 0.601 0.650 0.639 0.623 0.567 0.506 0.440 0.388 0.329 0.224 0.182 0.092 0.000 -0.088 -0.252 -0.586 6.747
X2
Y2
0.000 0.091 0.228 0.362 0.489 0.606 0.714 0.816 0.911 1.000 1.241 1.450 1.635 1.905 2.139 2.345 2.701 3.001 3.262 3.703 4.068 4.525 37.190
1.576 1.165 0.816 0.766 0.606 0.606 0.505 0.519 0.448 0.388 0.259 0.176 0.119 0.079 0.051 0.021 0.012 0.003 0.000 0.002 0.016 0.076 8.207
Tiempo
Icum 0 1 2 3 4 5 6 7 8 9 10 13 16 19 22 25 30 35 40 45 50 60 90
Log To (X) Log Icum (Y) 0 0.3 0.4 0.4 0.5 0.5 0.6 0.6 0.7 0.7 0.7 0.7 0.7 0.7 0.7 0.7 0.7 0.75 0.75 0.75 0.75 0.75 0.8
0.000 0.301 0.477 0.602 0.699 0.778 0.845 0.903 0.954 1.000 1.114 1.204 1.279 1.342 1.398 1.477 1.544 1.602 1.653 1.699 1.778 1.954 24.605
-0.523 -0.398 -0.398 -0.301 -0.301 -0.222 -0.222 -0.155 -0.155 -0.155 -0.155 -0.155 -0.155 -0.155 -0.155 -0.155 -0.125 -0.125 -0.125 -0.125 -0.125 -0.097 -4.480
XY 0.000 -0.120 -0.190 -0.181 -0.210 -0.173 -0.187 -0.140 -0.148 -0.155 -0.173 -0.187 -0.198 -0.208 -0.217 -0.229 -0.193 -0.200 -0.207 -0.212 -0.222 -0.189 -3.938
X2 0.000 0.091 0.228 0.362 0.489 0.606 0.714 0.816 0.911 1.000 1.241 1.450 1.635 1.802 1.954 2.182 2.384 2.567 2.733 2.886 3.162 3.819 33.031
Y2 0.273 0.158 0.158 0.091 0.091 0.049 0.049 0.024 0.024 0.024 0.024 0.024 0.024 0.024 0.024 0.024 0.016 0.016 0.016 0.016 0.016 0.009 1.173
Log To (X) Log Icum (Y)
0 1 2 3 4 5 6 7 10 13 16 21 26 31 41 51
Tiempo 0 1 2 3 4 5 6 7 10 13 16 21 26 31 41 51
tiempo 0 1 2 3 4 5
0 1 1.7 2.3 2.6 3.1 3.5 4 5 5.6 6.3 7.2 8.3 9.3 11.1 12.9
0.000 0.301 0.477 0.602 0.699 0.778 0.845 1.000 1.114 1.204 1.322 1.415 1.491 1.613 1.708 14.569
0.000 0.230 0.362 0.415 0.491 0.544 0.602 0.699 0.748 0.799 0.857 0.919 0.968 1.045 1.111 9.792
XY 0.000 0.069 0.173 0.250 0.343 0.423 0.509 0.699 0.833 0.963 1.134 1.300 1.444 1.686 1.896 11.723
Icum 0.00 1.07 1.67 2.16 2.60 3.00 3.37 3.72 4.67 5.52 6.31 7.51 8.61 9.64 11.52 13.25
Y2
0.000 0.091 0.228 0.362 0.489 0.606 0.714 1.000 1.241 1.450 1.748 2.002 2.224 2.601 2.916 17.671
0.000 0.053 0.131 0.172 0.241 0.296 0.362 0.489 0.560 0.639 0.735 0.845 0.938 1.093 1.233 7.787
100.00
10.00
1.00 1
10
Tiempo (min)
CACULO DE LA VELOCIDAD DE INFILTRACION vel. Inf. (I) Log To (X) Log (Y) XY 12 9 6 4.5 4.2
X2
Lámina Infltrada Acumulada
Tiempo
0.000 0.301 0.477 0.602 0.699
1.079 0.954 0.778 0.653 0.623
0.000 0.287 0.371 0.393 0.436
X2
Y2
0.000 0.091 0.228 0.362 0.489
1.165 0.911 0.606 0.427 0.388
3.5 3 2.625 2.33 2.4 1.85 1.5 1.42 1.125 1.03 0.9 0.74 0.61 0.52 0.46 0.4 0.33
tiempo 1 2 3 4 5 6 7 10 13 16 21 26 31 41 51
vel. Inf. (I) 20.0 18.7 18.0 17.4 17.1 16.8 16.5 15.9 15.5 15.2 14.8 14.5 14.2 13.8 13.5
0.778 0.845 0.903 0.954 1.000 1.114 1.204 1.279 1.380 1.462 1.531 1.643 1.732 1.806 1.924 2.017 2.127 25.781
0.544 0.477 0.419 0.367 0.380 0.267 0.176 0.152 0.051 0.013 -0.046 -0.131 -0.215 -0.284 -0.337 -0.398 -0.481 5.044
0.423 0.403 0.379 0.351 0.380 0.298 0.212 0.195 0.071 0.019 -0.070 -0.215 -0.372 -0.513 -0.649 -0.803 -1.024 0.571 0.571
0.606 0.714 0.816 0.911 1.000 1.241 1.450 1.635 1.905 2.139 2.345 2.701 3.001 3.262 3.703 4.068 4.525 37.190
0.296 0.228 0.176 0.135 0.145 0.071 0.031 0.023 0.003 0.000 0.002 0.017 0.046 0.081 0.114 0.158 0.232 5.253
100.0
Velocidad deInfltracióm (cm/h)
6 7 8 9 10 13 16 19 24 29 34 44 54 64 84 104 134
10.0
1.0 0
10
20
30
Tiempo (h)
40
50
tiempo 1 2 3 4 5 6 7 10 13 16 21 26 31 41 51
vel. Inf. (I) 16.6 16.5 16.4 16.4 16.3 16.3 16.3 16.2 16.2 16.1 16.1 16.1 16.0 16.0 16.0
tiempo 1 2 3 4 5 6 7 10 13 16 21 26 31 41 51
vel. Inf. (I) 20.0 18.7 18.0 17.4 17.1 16.8 16.5 15.9 15.5 15.2 14.8 14.5 14.2 13.8 13.5
Velocidad de Infltración Promedio (cm/h) Lámina Infltrada 100
10
Tiempo (min)
100
10
1
0.1 10
Icum
1 1
100 10
Tiempo
Icum 100
Velocidad de Infltraci Promedio (cm/h)
10
1
0.1 1
10
100
Tiempo (horas)
vel. Inf. (I)
20
30
Tiempo (h)
40
50
60
1000
tiempo 0 1 2 3 4 5 6 7 8 9 10 13 16 19 24 29 34 44 54 64 84 104 134
CACULO DE LA VELOCIDAD DE INFILTRACION vel. Inf. (I) Log To (X) Log (Y) XY 18 12 8 7.5 6 6 5.14 5.25 4.67 4.2 3.23 2.63 2.21 1.91 1.68 1.4 1.29 1.13 1 0.9 0.75 0.53
0.000 0.301 0.477 0.602 0.699 0.778 0.845 0.903 0.954 1.000 1.114 1.204 1.279 1.380 1.462 1.531 1.643 1.732 1.806 1.924 2.017 2.127 25.781
1.255 1.079 0.903 0.875 0.778 0.778 0.711 0.720 0.669 0.623 0.509 0.420 0.344 0.281 0.225 0.146 0.111 0.053 0.000 -0.046 -0.125 -0.276 10.036
0.000 0.325 0.431 0.527 0.544 0.606 0.601 0.650 0.639 0.623 0.567 0.506 0.440 0.388 0.329 0.224 0.182 0.092 0.000 -0.088 -0.252 -0.586 6.747
X2
Y2
0.000 0.091 0.228 0.362 0.489 0.606 0.714 0.816 0.911 1.000 1.241 1.450 1.635 1.905 2.139 2.345 2.701 3.001 3.262 3.703 4.068 4.525 37.190
1.576 1.165 0.816 0.766 0.606 0.606 0.505 0.519 0.448 0.388 0.259 0.176 0.119 0.079 0.051 0.021 0.012 0.003 0.000 0.002 0.016 0.076 8.207
Tiempo
Icum 0 1 2 3 4 5 6 7 8 9 10 13 16 19 22 25 30 35 40 45 50 60 90
Log To (X) Log Icum (Y) 0 0.3 0.4 0.4 0.5 0.5 0.6 0.6 0.7 0.7 0.7 0.7 0.7 0.7 0.7 0.7 0.7 0.75 0.75 0.75 0.75 0.75 0.8
0.000 0.301 0.477 0.602 0.699 0.778 0.845 0.903 0.954 1.000 1.114 1.204 1.279 1.342 1.398 1.477 1.544 1.602 1.653 1.699 1.778 1.954 24.605
-0.523 -0.398 -0.398 -0.301 -0.301 -0.222 -0.222 -0.155 -0.155 -0.155 -0.155 -0.155 -0.155 -0.155 -0.155 -0.155 -0.125 -0.125 -0.125 -0.125 -0.125 -0.097 -4.480
XY 0.000 -0.120 -0.190 -0.181 -0.210 -0.173 -0.187 -0.140 -0.148 -0.155 -0.173 -0.187 -0.198 -0.208 -0.217 -0.229 -0.193 -0.200 -0.207 -0.212 -0.222 -0.189 -3.938
X2 0.000 0.091 0.228 0.362 0.489 0.606 0.714 0.816 0.911 1.000 1.241 1.450 1.635 1.802 1.954 2.182 2.384 2.567 2.733 2.886 3.162 3.819 33.031
Y2 0.273 0.158 0.158 0.091 0.091 0.049 0.049 0.024 0.024 0.024 0.024 0.024 0.024 0.024 0.024 0.024 0.016 0.016 0.016 0.016 0.016 0.009 1.173
Related Documents
Calculo Del Icum En Excel.xlsx
July 2020 3
Calculo Del Promedio En Un Cableado
November 2019 3
Calculo Del Peso Ideal
June 2020 9
Principios Del Calculo Infinitesimal
November 2019 18
Calculo Del Ptu.docx
June 2020 18
