![Excel Analisa Saringan Kasar & Halus [PDF]](https://pdfs.asia/img/200x200/excel-analisa-saringan-kasar-amp-halus.jpg)
12 0 175 KB
Berat sampel
No. Saringan 3/4" 1/2" 3/8" 4 Pan
500
gram
Berat Tertahan (gram) I II 240 100 233 360 20 34 4 3 2 2
Komulatif Tertahan (gram) I II 240 100 473 460 493 494 497 497 499 499
Persen Total Tertahan I 48.10 94.79 98.80 99.60 100
sampel 1
100.00 90.00 80.00 70.00 60.00 50.00 Persen Lolos (%) 40.00 30.00 20.00 10.00 0.00 1
3/4"
1/2"
3/8"
4
8
30
50
pan Ukuran Saringan
100
2
ersen Total Tertahan II 20.04 92.18 99.00 99.60 100
Persen Lolos I 51.90 5.21 1.20 0.40 0
II 79.96 7.82 1.00 0.40 0
sampel 1
1 2 3/4" 3 1/2" 4 3/8" 5 6 7 8 9 10 11 Pan
kasar 100.00 97.17 45.88 14.09 4 1.17 8 0 30 0 50 0 100 0 200 0 0 1
100 90 80 70 60 Persen Lolos (%)
50 40 30 20 10 0
1 pan 8
30
50
uran Saringan
100
200
3/4"
1/2"
3/8"
sampel 2 halus 100 100 100 100 100 99 99.22 77.03 27.53 9.36 0.00
tengah 100.00 98.59 72.94 57.05 50.59 49.69 49.61 38.52 13.77 4.68 0.00
kasar
halus
100 93.82 31.91 13.34 0.94 0 0 0 0 0 0
100 90 80 70 60
en Lolos (%)
50 40 30 20 10 0
1 pan
3/4"
1/2"
3/8"
4
8
30
50
100
Ukuran Saringan
200
100 100 100 100 100 99.51 92.55 74.29 19.88 9.49 0
tengah 100 96.91 65.96 56.67 50.47 49.76 46.28 37.15 9.94 4.75 0
Berat sampel
No. Saringan 4 8 30 50 100 200 Pan
500 Berat Tertahan (gram) I II 0 0 6 2 58 53 133 387 236 1 6 3 55 44
gram Komulatif Tertahan (gram) I II 0 0 6 2 64 55 197 442 433 443 439 446 494 490
Persen Total Tertahan I 0 1.21 12.96 39.88 87.65 88.87 100
ersen Total Tertahan II 0 0.41 11.22 90.20 90.41 91.02 100
Persen Lolos I 100 98.79 87.04 60.12 12.35 11.13 0
II 100 99.59 88.78 9.80 9.59 8.98 0
1 25 25 2 19 19 3 12.5 12.5 4 9.5 9.5 5 4.75 4.75 6 2.38 2.38 7 0.6 0.6 8 0.3 0.3 9 0.15 0.15 10 0.075 0.075 11 pan pan 25 19 12.5 9.5 4.75 2.38 0.6 0.3 0.15 0.075 pan
kasar halus tengah 100.00 100 100.00 97.17 100 98.59 45.88 100 72.94 14.09 100 57.05 1.17 100 50.59 0 99.38 49.69 0 99.22 49.61 0 77.03 38.52 0 27.53 13.77 0 9.36 4.68 0 0 0
120.00 100.00 80.00 Axis Title
60.00
kas
halu
40.00
ten
20.00 0.00 0
5
10
15 Axis Title
PAN
pan
3/4"
1/2"
3/8"
4
8
30
50
100
200
20
25
30
kasar halus tengah
25
30
kasar 1 2 3/4" 3 1/2" 4 3/8" 5 6 7
1 pan
halus
tengah
4 8 30
0.075 0.15 0.3 0.6 2.38 4.75
0 0 0 0 0.75 20.43 51.89
0 9.36 27.53 77.03 93.22 99.38 100
0 4.68 13.77 38.52 49.61 49.69 50.59
8
50
9.5
14.09
100
57.05
9
100
12.5
72.56
100
72.94
10
200
19
99.12
100
98.59
25
100.00
100
100.00
11 pan
kasar 100.00
100
100.00
19 12.5 9.5
97.17 45.88 14.09
100 100 100
98.59 72.94 57.05
4.75
1.17
100
50.59
2.38
0
99.38
49.69
0.6
0
99.22
49.61
0.3
0
77.03
38.52
0.15
0
27.53
13.77
0.075
0
9.36
4.68
0
0
0
kasar 0.075 0.15 0.3 0.6
tengah
25
pan
pan
halus
halus 0 0 0 0 0
0 9.49 19.18 74.49 92.55
tengah 0 4.745 9.59 37.245 46.275
2.38 4.75 9.5 12.5 19 25
0 0.94 13.34 31.91 93.82 100.00
99.51 100 100 100 100 100
49.755 50.47 56.67 65.955 96.91 100
120
100
100 99.38 100.00100.0
93.22
77.03
80
72.
Persen lolos (%)
60
57.05
49.61
51.89 49.69 50.59
38.52 40 27.53 20.43
20
14.09
13.77 9.36 4.68 0 PAN
0.075
0.15
0
0 0.3
0.75 0 0.6
2.38
4.75
25 Ukuran Saringan (mm)
120
100
80
9.5
12.
100
80
60 Persen lolos (%)
40
20
0 PAN
0.075
0.15
0.3
0.6
2.38
4.75
25 Ukuran Saringan (mm)
9.5
12.5
2.38
100.00 100.00 100.00 100 99.38 100.00100.00 99.12 98.59
72.94 72.56
57.05
kasar
51.89 49.69 50.59
halus tengah
20.43 14.09
4.75
ringan (mm)
9.5
12.5
19
.38
kasar halus tengah
4.75
an (mm)
9.5
12.5
19
Agregat Kasar
Diameter Saringan (mm) No. Saringan 19 3/4" 12,5 1/2" 9,5 3/8" 4,75 4 Pan
Berat Tertahan (gram) I II 8,62 9,66 259 234,31 201,64 220,07 404 412 102 107,22
Komulatif Tertahan (gram) I II 8,62 9,66 267,62 243,97 469,26 464,04 873,26 876,04 975,26 983,26
Berat Tertahan (gram) I II 0 0,48 395,76 419,02 97,88 72,28 1,36 1,05 1,18 0,80 0,69 0,51 0,50 0,40
Komulatif Tertahan (gram) I II 0 0,48 395,76 419,05 493,64 491,78 495 492,83 496,18 493,63 496,87 494,14 497,37 494,54
Agregat Halus
Diameter Saringan (mm) No. Saringan 4,75 4 2,38 8 0,60 30 0,30 50 0,15 100 0,075 200 Pan
Persen Total Tertahan I II 0,88 0,98 27,44 24,81 48,11 47,19 89,54 89,09 100 100
Persen Lolos I II 99.12 99.02 72.56 75.19 51.89 52.81 10.46 10.91 1 0.6
Pan
99.07 73.875
0.075
52.35
0.15
10.685
0.3
0.8
0.6 2.38 4.75 9.5 12.5
Persen Total Tertahan I II 0 0,09 79,57 84,73 99,25 99,44 99,52 99,65 99,76 99,81 99,89 99,91 100 100
Persen Lolos I II 88.9 95 20.43 15.27 1.45 1.18 0.48 0.35 0.24 0.19 0.11 0.09 0 0
19 91.95 17.85 1.315
1.315
0.415 0.215 0.1 0
kasar
Pan 0.075 0.15 0.3 0.6
0 0 0 0 0
2.38 4.75 9.5 12.5 19
kasar
Pan 0.075 0.15 0.3 0.6 2.38 4.75 9.5 12.5 19
halus 0
0
0 0 0 0 0.8 10.685 52.35 73.875 99.07
6 19 52 84 98 100 100 100 100
0 0.48 17.215 40.505 93.23
120
100
kasar
halus
0
0
80
0
0.1
0
0.215
0
0.415
0
1.315
0.8
17.85
10.685 52.35 73.875
91.95 100 100
99.07
100
Persen Lolos (%)
60
40
20
0 0.01
0.1
Diameter S
12
10
8
halus 0 3.62 14.75 60.82 89.03
Persen Lolos (%)
6
4
2
4
99.965 100 100 100 100
19 12.5 9.5 4.75
4.75 2.38 0.6 0.3 0.15 0.075 0
2
93.18 37.82 17.08 0.79
19 12.5 9.5
0
4.75 2.38
0 0 0 0 0
0.6 0.3 0.15 0.075 0
100 100 100 100 100 85.89 47.87 18.55 4.77 0
0
100 0 99,965
0,48 17,215 40,505 93,23
14,75 3,62 60,82 89,03
kasar halus
0.1
1
10
100
Diameter Saringan (mm)
120
100
80
Persen Lolos (%)
60 Kasar Halus 40
20
0
Kasar Halus 40
20
0 0.1
1
10
Diameter Saringan (mm)
100
Kasar Halus
Kasar Halus
100
