Curva Granulométrica por lavado y secado
3
Tamiz Abertura (mm) Peso Retenido (gr % Retenido % Pasa 3'' 76.3 0 0 100 2'' 50 2750 18.65418532 81.3458147 1 1/2'' 38.1 1879 12.74589608 68.5999186 1'' 25.4 1991 13.50563017 55.0942884 3/4'' 19 827 5.609822276 49.4844662 1/2'' 12.5 943 6.39668973 43.0877764 3/8'' 9.5 833 5.650522317 37.4372541 1/4'' 6.3 863 5.854022521 31.5832316 N· 4 4.75 584 3.961470628 27.621761 N· 10 2 71.76 4.588 23.033761 N· 20 0.84 60.03 3.838 19.195761 N· 40 0.42 97.95 6.26 12.935761 N· 60 0.25 60.61 3.875 9.06076096 N· 100 0.15 67 4.28 4.78076096 N· 200 0.075 20.74 1.326 3.45476096 Fondo 10.91 0.697 2.75776096 Peso total seco 14742 Tamiz Abertura (mm) Peso Retenido (Gr % Retenido % Pasa 1/4'' 6.3 0 0 100 N· 4 4.75 0.87 0.514336388 99.4856636 N· 10 2 5.91 3.49394029 95.9917233 N· 20 0.84 10.5 6.207508129 89.7842152 N· 40 0.42 13.84 8.182086905 81.6021283 N· 60 0.25 11.81 6.981968667 74.6201596 N· 100 0.15 25.84 15.27638191 59.3437777 N· 200 0.075 15.8 9.340821756 50.002956 Fondo 3.11 1.838604789 48.1643512 Peso S. S 169.15
-
Upload
rafael-leiva -
Category
Documents
-
view
214 -
download
1
description
Elavoración de la Curva Granulométrica por lavado y secado en Excel.
Transcript of Curva Granulométrica por lavado y secado
Tamiz Abertura (mm) Peso Retenido (gr) % Retenido % Pasa3'' 76.3 0 0 1002'' 50 2750 18.65418532 81.34581471 1/2'' 38.1 1879 12.74589608 68.59991861'' 25.4 1991 13.50563017 55.09428843/4'' 19 827 5.609822276 49.48446621/2'' 12.5 943 6.39668973 43.08777643/8'' 9.5 833 5.650522317 37.43725411/4'' 6.3 863 5.854022521 31.5832316N· 4 4.75 584 3.961470628 27.621761N· 10 2 71.76 4.588 23.033761N· 20 0.84 60.03 3.838 19.195761N· 40 0.42 97.95 6.26 12.935761N· 60 0.25 60.61 3.875 9.06076096N· 100 0.15 67 4.28 4.78076096N· 200 0.075 20.74 1.326 3.45476096Fondo 10.91 0.697 2.75776096
Peso total seco 14742
Tamiz Abertura (mm) Peso Retenido (Grs) % Retenido % Pasa1/4'' 6.3 0 0 100N· 4 4.75 0.87 0.514336388 99.4856636N· 10 2 5.91 3.49394029 95.9917233N· 20 0.84 10.5 6.207508129 89.7842152N· 40 0.42 13.84 8.182086905 81.6021283N· 60 0.25 11.81 6.981968667 74.6201596N· 100 0.15 25.84 15.27638191 59.3437777N· 200 0.075 15.8 9.340821756 50.002956Fondo 3.11 1.838604789 48.1643512
Peso S. S 169.15
0.01 0.1 1 10 1000
20
40
60
80
100
120
Curva Granulometrica (Seco)
Diametro en mm
% P
asa
0.01 0.1 1 10 1000
20
40
60
80
100
120
Curva Granulometrica (Seco)
Diametro en mm
% P
asa
0.01 0.1 1 100
20
40
60
80
100
120
Curva Granulometria (Lavado)
DIAMETRO EN MM
% P
ASA
