Excel Sheet For Sieve

Download as xls, pdf, or txt
Download as xls, pdf, or txt
You are on page 1of 4

Excel Sheet For Sieve Analysis Of Aggregate And To Calcu

SIEVE ANALYSIS OF FINE AGG

IS SIEVE SIZE WEIGHT RETAINED (gm) CUMULATIVE WEIGHT RETAINED (gm)


10MM 0 0
4.75MM 0 0
2.36MM 0 0
1.18MM 540 540
600μ 320 860
300μ 70 930
150μ 30 960
LOWER THAN150μ 40 1000

TOTAL 1000

HENCE FINENESS MODULUS (F.M.)=


gregate And To Calculate Fineness Modulus
Uploaded on www.engineeringcivil.com

CUMULATIVE % WT.RETAINED CUMULATIVE % WT. PASSING


0 100
0 100
0 100
54 46
86 14
93 7
96 4
---------------------------------- --------------------------------------

329

3.29
Excel Sheet For Sieve Analysis Of Aggregate And To Calcu
SIEVE ANALYSIS OF COARSE AGGREGATE

IS SIEVE SIZE WEIGHT RETAINED (Kg) CUMULATIVE WEIGHT RETAINED (Kg)


40MM 0 0
20MM 0.428 0.428
16MM 1.393 1.821
12.5MM 2.19 4.011
10MM 0.997 5.008
4.75MM 0.063 5.071
2.36MM ----------------- -----------------
1.18MM ----------------- -----------------
600μ ----------------- -----------------
300μ ----------------- -----------------
150μ ----------------- -----------------
LOWER THAN 150μ ----------------- -----------------

TOTAL 5.071

HENCE FINENESS MODULUS (F.M.)=


gate And To Calculate Fineness Modulus
Uploaded on www.engineeringcivil.com

CUMULATIVE % WT.RETAINED CUMULATIVE % WT. PASSING


0 100
8.4401498718 91.5598501282
35.9100769079 64.0899230921
79.0968250838 20.9031749162
98.7576414908 1.2423585092
100 0
100 0
100 0
100 0
100 0
100 0
0

822.2046933544

8.2220469335

You might also like