Scribd Logo
Upload

Welcome to Scribd!

  • 16 views

    Practica - Excel - XLSX Filename - UTF-8''Practica Excel-1

    Uploaded by

    Henry Arias Soliz
    The document contains granulometric curve data for a soil sample analyzed using various sieve sizes. It lists the mass retained and percentage retained for each sieve size, as well as cumulative percentages. Calculated parameters include the uniformity coefficient (Cu), curvature coefficient (Cc), and D10, D30, and D60 grain sizes. A graph of the granulometric curve shows percentage passing versus grain size on a logarithmic scale.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd

    Practica - Excel - XLSX Filename - UTF-8''Practica Excel-1

    Uploaded by

    Henry Arias Soliz
    16 views9 pages
    The document contains granulometric curve data for a soil sample analyzed using various sieve sizes. It lists the mass retained and percentage retained for each sieve size, as well as cumulative percentages. Calculated parameters include the uniformity coefficient (Cu), curvature coefficient (Cc), and D10, D30, and D60 grain sizes. A graph of the granulometric curve shows percentage passing versus grain size on a logarithmic scale.

    Original Description:

    practica

    Original Title

    Practica_excel.xlsx;filename_= UTF-8''Practica%20excel-1

    Copyright

    © © All Rights Reserved

    Available Formats

    XLSX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    The document contains granulometric curve data for a soil sample analyzed using various sieve sizes. It lists the mass retained and percentage retained for each sieve size, as well as cumulative percentages. Calculated parameters include the uniformity coefficient (Cu), curvature coefficient (Cc), and D10, D30, and D60 grain sizes. A graph of the granulometric curve shows percentage passing versus grain size on a logarithmic scale.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    16 views9 pages

    Practica - Excel - XLSX Filename - UTF-8''Practica Excel-1

    Uploaded by

    Henry Arias Soliz
    The document contains granulometric curve data for a soil sample analyzed using various sieve sizes. It lists the mass retained and percentage retained for each sieve size, as well as cumulative percentages. Calculated parameters include the uniformity coefficient (Cu), curvature coefficient (Cc), and D10, D30, and D60 grain sizes. A graph of the granulometric curve shows percentage passing versus grain size on a logarithmic scale.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    of 9

    Malla

    Curva Granulometrica 1
    3∕4
    100.00%
    1∕2
    90.00%
    3∕8
    80.00%
    1∕4
    70.00%
    4
    60.00% %pasa
    10
    50.00%
    20
    40.00%
    40
    30.00%
    20.00%
    60
    10.00%
    80
    0.00% 100
    100 10 1 0.1 0.01 200
    Tara

    SISTEMA UNIFICADO DE CLASIFICACIÓN DE SU


    Coeficiente de uniformida
    Coeficiente de curvatura

    Cu 0.783
    0.049
    Abertura Masa ret. %Ret. %Ret acum %pasa
    25.4 0 0.00% 0.00% 100.00%
    19.1 0 0.00% 0.00% 100.00%
    12.7 0 0.00% 0.00% 100.00%
    9.52 13.43 0.54% 0.54% 99.46%
    6.35 53.75 2.14% 2.68% 97.32%
    4.75 67.78 2.70% 5.38% 94.62%
    1.9 409.3 16.31% 21.68% 78.32%
    0.84 391.04 15.58% 37.26% 62.74%
    0.42 506.68 20.19% 57.45% 42.55%
    0.25 258.67 10.31% 67.75% 32.25%
    0.177 104 4.14% 71.90% 28.10%
    0.149 151.87 6.05% 77.95% 22.05%
    0.074 226.42 9.02% 86.97% 13.03%
    327.11 13.03% 100.00% 0.00%
    2510.05
    ICADO DE CLASIFICACIÓN DE SUELOS
    Cu mayor 6
    1 Cc 3

    D10 0.049
    15.98 Cc (0,783 )^2 1.15 D30 0.21
    0,049*0,783 D60 0.783
    MALLA Abertura mmRet. Gr. % Ret % Ret acum % pasa
    4 101.6 0 0% 0% 100%
    3 76.2 0 0% 0.00% 100%
    2 1/2 63.5 0 0% 0.00% 100%
    2 50.8 362 9% 8.88% 91%
    1 1∕2 38.1 199 5% 13.77% 86%
    1 25.4 359 9% 22.58% 77%
    3∕4 19.05 377 9% 31.83% 68%
    1∕2 12.7 439 11% 42.60% 57%
    3∕8 9.525 263 6% 49.06% 51%
    1∕4 6.35 402 10% 58.92% 41%
    4 4.75 102 3% 61.42% 39%
    8 2.38 415 10% 71.61% 28%
    10 1.9 83 2% 73.64% 26%
    16 1.19 203 5% 78.63% 21%
    30 0.59 390 10% 88.20% 12%
    40 0.42 129 3% 91.36% 9%
    50 0.297 79 2% 93.30% 7%
    100 0.149 118 3% 96.20% 4%
    200 0.074 31 1% 96.96% 3%
    menos de 200 124 3% 100.00% 0%
    Total 4075

    Cu 14.432 30.256 Cc (2,811 )^2 1.148


    0.477 0,477*14,432

    D10 0.477
    D30 2.811
    D60 14.432
    Curva Granulometrica
    100%
    90%
    80%
    70%
    60% % pasa
    50%
    40%
    30%
    20%
    10%
    0%
    1000 100 10 1 0.1 0.01
    3.434
    MALLA Diametro Retenidod gr. % Ret % Ret acum % pasa
    4 4.75 0 0% 0% 100%
    10 2 21.6 5% 5% 95%
    20 0.85 49.5 12% 17% 83%
    40 0.425 102.6 24% 41% 59%
    60 0.25 89.1 21% 63% 37%
    100 0.15 95.6 23% 86% 14%
    200 0.075 60.4 14% 100% 0%
    Tara 418.8

    Cu 0.443 3.434 Cc (0,22 )^2 0.847


    0.129 0,129*0,129

    D10 0.129
    D30 0.22
    D60 0.443
    Curva Granulometrica
    100%
    90%
    80%
    70%
    60% % pasa
    50%
    40%
    30%
    20%
    10%
    0%
    10 1 0.1 0.01
    GRANULOMETRÍA DE SUELOS
    MALLA ABERTURA mm Retenidod gr. % Ret. % Ret. Acum.% Pasa
    4 4.75 0 0.00% 0.00% 100.00%
    10 1.9 20.2 10.11% 10.11% 89.89%
    20 0.85 25.7 12.86% 22.97% 77.03%
    40 0.425 40.4 20.22% 43.19% 56.81%
    100 0.15 18.1 9.06% 52.25% 47.75%
    200 0.075 27.2 13.61% 65.87% 34.13%
    Tara 68.2 34.13% 100.00% 0.00%
    TOTAL 199.8

    Cu D10 Cc (D30 )^2


    D60 D60D10

    D10 0
    D30 INDETER
    D60 INDETER
    Curva Granulometrica
    100.00%
    90.00%
    80.00%
    70.00%
    60.00% % Pasa
    50.00%
    40.00%
    30.00%
    20.00%
    10.00%
    0.00%
    10 1 0.1 0.01

    You might also like