tamices algoritmo

Upload: emmanuel-perez

Post on 25-Feb-2018

244 views

Category:

Documents


0 download

TRANSCRIPT

  • 7/25/2019 Tamices ALGORITMO

    1/25

    LUGAR NMERO DE MUESTRA TAMIZ 5 TAMIZ 412345 235

    6 31078 609

    101112131415

    1617181920 18021222324252627282930

    TECA

    JET

    E

  • 7/25/2019 Tamices ALGORITMO

    2/25

    TAMIZ 3 TAMIZ 2 TAMIZ 1 TAMIZ 0 PESO HORA50 250 250 640 1190

    0150 390 430 970

    012 50 40 450 787

    90 160 80 425 106510 700 710

    65 145 45 650 9650

    35 90 75 790 99015 385 250 145 79530 75 195 790 1090

    040 380 310 260 99015 50 100 810 975

    25 240 220 470 95510 150 260 410 830150 390 430 970

    030 120 50 430 810 11:2045 25 60 610 740 11:22

    30 45 740 815 11:2420 25 55 630 730 11:27

    25 45 930 1000 11:3110 50 620 680 11:33

    10 30 65 575 680 11:4250 50 530 630 11:44

    30 85 125 760 1000 11:4680 50 85 615 830 11:47

    40 115 845 1000 11:49

  • 7/25/2019 Tamices ALGORITMO

    3/25

    Porcentae Tota! De"ea#o Porcentae a $%&tar RESTA DE TAMIZ 525.2100840336 74.7899159664 0

    #DIV/0! #DIV/0! #DIV/0!30.9278350515 69.0721649485 0

    #DIV/0! #DIV/0! #DIV/0!38.1194409149 61.8805590851 0

    28.1690140845 71.8309859155 042.2535211268 57.7464788732 031.0880829016 68.9119170984 0

    #DIV/0! #DIV/0! #DIV/0!30.303030303 69.696969697 0

    37.7358490566 62.2641509434 027.5229357798 72.4770642202 0

    #DIV/0! #DIV/0! #DIV/0!30.303030303 69.696969697 0

    30.7692307692 69.2307692308 0

    31.4136125654 68.5863874346 036.1445783133 63.8554216867 030.9278350515 69.0721649485 0

    #DIV/0! #DIV/0! #DIV/0!37.037037037 62.962962963 0

    40.5405405405 59.4594594595 036.8098159509 63.1901840491 041.095890411 58.904109589 0

    30 70 044.1176470588 55.8823529412 044.1176470588 55.8823529412 047.619047619 52.380952381 0

    30 70 036.1445783133 63.8554216867 0

    30 70 0

  • 7/25/2019 Tamices ALGORITMO

    4/25

    RESTA DE TAMIZ 4 RESTA DE TAMIZ 3 RESTA DE TAMIZ 2 RESTA DE TAMIZ 10 37.3949579832 186.974789916 186.974789916

    #DIV/0! #DIV/0! #DIV/0! #DIV/0!0 0 103.6082474227 269.381443299

    #DIV/0! #DIV/0! #DIV/0! #DIV/0!145.4193138501 7.4256670902 30.9402795426 24.7522236341

    222.676056338 64.6478873239 114.9295774648 57.46478873240 0 0 5.7746478873

    41.3471502591 44.792746114 99.9222797927 31.0103626943#DIV/0! #DIV/0! #DIV/0! #DIV/0!

    0 24.3939393939 62.7272727273 52.27272727270 9.3396226415 239.7169811321 155.66037735850 21.7431192661 54.3577981651 141.3302752294

    #DIV/0! #DIV/0! #DIV/0! #DIV/0!0 27.8787878788 264.8484848485 216.06060606060 10.3846153846 34.6153846154 69.2307692308

    0 17.1465968586 164.6073298429 150.8900523560 6.3855421687 95.7831325301 166.02409638550 0 103.6082474227 269.381443299

    #DIV/0! #DIV/0! #DIV/0! #DIV/0!113.3333333333 18.8888888889 75.5555555556 31.4814814815

    0 26.7567567568 14.8648648649 35.67567567570 0 18.9570552147 28.43558282210 11.7808219178 14.7260273973 32.3972602740 0 17.5 31.50 0 5.5882352941 27.94117647060 5.5882352941 16.7647058824 36.32352941180 0 26.1904761905 26.19047619050 21 59.5 87.50 51.0843373494 31.9277108434 54.27710843370 0 28 80.5

  • 7/25/2019 Tamices ALGORITMO

    5/25

    RESTA DE TAMIZ 0 Pe"o $%&ta#o Tota! N%e'o Pe"o478.6554621849 890 300

    #DIV/0! #DIV/0! #DIV/0!297.0103092784 670 300

    #DIV/0! #DIV/0! #DIV/0!278.4625158831 487 300

    305.2816901408 765 300404.2253521127 410 300447.9274611399 665 300

    #DIV/0! #DIV/0! #DIV/0!550.6060606061 690 30090.2830188679 495 300

    572.5688073395 790 300#DIV/0! #DIV/0! #DIV/0!

    181.2121212121 690 300560.7692307692 675 300

    322.3560209424 655 300261.8072289157 530 300297.0103092784 670 300

    #DIV/0! #DIV/0! #DIV/0!270.7407407407 510 300362.7027027027 440 300467.6073619632 515 300371.095890411 430 300

    651 700 300346.4705882353 380 300321.3235294118 380 300277.619047619 330 300

    532 700 300392.7108433735 530 300

    591.5 700 300

  • 7/25/2019 Tamices ALGORITMO

    6/25

    Pe"o Re"tante en e! Ta(&) 5 Pe"o Re"tante en e! Ta(&) 40 0

    #DIV/0! #DIV/0!0 0

    #DIV/0! #DIV/0!0 89.5806861499

    0 87.3239436620 00 18.6528497409

    #DIV/0! #DIV/0!0 00 00 0

    #DIV/0! #DIV/0!0 00 0

    0 00 00 0

    #DIV/0! #DIV/0!0 66.66666666670 00 00 00 00 00 00 00 00 00 0

  • 7/25/2019 Tamices ALGORITMO

    7/25

    Pe"o Re"tante en e! Ta(&) 3 Pe"o Re"tante en e! Ta(&) 212.6050420168 63.025210084

    #DIV/0! #DIV/0!0 46.3917525773

    #DIV/0! #DIV/0!4.5743329098 19.0597204574

    25.3521126761 45.07042253520 0

    20.207253886 45.0777202073#DIV/0! #DIV/0!

    10.6060606061 27.27272727275.6603773585 145.28301886798.2568807339 20.6422018349

    #DIV/0! #DIV/0!12.1212121212 115.15151515154.6153846154 15.3846153846

    7.8534031414 75.39267015713.6144578313 54.21686746990 46.3917525773

    #DIV/0! #DIV/0!11.1111111111 44.444444444418.2432432432 10.1351351351

    0 11.04294478538.2191780822 10.2739726027

    0 7.50 4.4117647059

    4.4117647059 13.23529411760 23.80952380959 25.5

    28.9156626506 18.07228915660 12

  • 7/25/2019 Tamices ALGORITMO

    8/25

    Pe"o Re"tante en e! Ta(&) 1 Pe"o Re"tante en e! Ta(&) 0 N%(ero63.025210084 161.3445378151 1

    #DIV/0! #DIV/0! 2120.618556701 132.9896907217 3

    #DIV/0! #DIV/0! 415.2477763659 171.5374841169 5

    22.5352112676 119.7183098592 64.2253521127 295.7746478873 7

    13.9896373057 202.0725388601 8#DIV/0! #DIV/0! 9

    22.7272727273 239.3939393939 1094.3396226415 54.7169811321 1153.6697247706 217.4311926606 12

    #DIV/0! #DIV/0! 1393.9393939394 78.7878787879 1430.7692307692 249.2307692308 15

    69.109947644 147.6439790576 1693.9759036145 148.1927710843 17120.618556701 132.9896907217 18

    #DIV/0! #DIV/0! 1918.5185185185 159.2592592593 2024.3243243243 247.2972972973 2116.5644171779 272.3926380368 2222.602739726 258.904109589 23

    13.5 279 2422.0588235294 273.5294117647 2528.6764705882 253.6764705882 2623.8095238095 252.380952381 27

    37.5 228 2830.7228915663 222.2891566265 29

    34.5 253.5 30

  • 7/25/2019 Tamices ALGORITMO

    9/25

    300#DIV/0!

    300#DIV/0!

    300

    300300300

    #DIV/0!300300300

    #DIV/0!300300

    300300300

    #DIV/0!30030030030030030030030030030030031=30

  • 7/25/2019 Tamices ALGORITMO

    10/25

    LUGAR NMER DE MUE"TRA TAMI 5 TAMI 4 TAMI 31"N 0 0

    2 0 0345

    67

    8 $"%1&9$"%2&

    10 $"% 3&11

    12$"%5& '( '(13$"%6& '(

    1415

    '(=')*+,-)

    T

    ETN

  • 7/25/2019 Tamices ALGORITMO

    11/25

    TAMI 2 TAMI 1 TAMI 0 E" TTAL Porcentae Tota! De"ea#o80 170 800 1050 28.5714285714

    120 100 740 960 31.2565 115 790 970 30.927835051545 80 740 865 34.682080924970 90 825 985 30.4568527919

    85 100 720 905 33.1491712707190 110 675 975 30.7692307692195 135 720 1050 28.5714285714165 200 660 1025 29.268292682950 70 870 990 30.303030303

    0 #DIV/0!100 105 780 985 30.456852791975 70 800 945 31.746031746

    0 #DIV/0!0 #DIV/0!

    (,)-)

  • 7/25/2019 Tamices ALGORITMO

    12/25

    Porcentae a $%&tar RESTA DE TAMIZ 5 RESTA DE TAMIZ 471.4285714286 0 0

    68.75 0 069.0721649485 0 065.3179190751 0 069.5431472081 0 0

    66.8508287293 0 069.2307692308 0 071.4285714286 0 070.7317073171 0 069.696969697 0 0

    #DIV/0! #DIV/0! #DIV/0!69.5431472081 0 #VALUE!68.253968254 0 0

    #DIV/0! #DIV/0! #DIV/0!#DIV/0! #DIV/0! #DIV/0!

  • 7/25/2019 Tamices ALGORITMO

    13/25

    RESTA DE TAMIZ 3 RESTA DE TAMIZ 2 RESTA DE TAMIZ 1 RESTA DE TAMIZ 00 57.1428571429 121.4285714286 571.42857142860 82.5 68.75 508.750 44.8969072165 79.4329896907 545.67010309280 29.3930635838 52.2543352601 483.35260115610 48.6802030457 62.5888324873 573.730964467

    0 56.8232044199 66.8508287293 481.32596685080 131.5384615385 76.1538461538 467.30769230770 139.2857142857 96.4285714286 514.28571428570 116.7073170732 141.4634146341 466.82926829270 34.8484848485 48.7878787879 606.3636363636

    #DIV/0! #DIV/0! #DIV/0! #DIV/0!#VALUE! 69.5431472081 73.0203045685 542.4365482234#VALUE! 51.1904761905 47.7777777778 546.0317460317#DIV/0! #DIV/0! #DIV/0! #DIV/0!#DIV/0! #DIV/0! #DIV/0! #DIV/0!

  • 7/25/2019 Tamices ALGORITMO

    14/25

    Pe"o $%&ta#o Tota! N%e'o Pe"o Pe"o Re"tante en e! Ta(&) 5750 300 0660 300 0670 300 0565 300 0685 300 0

    605 300 0675 300 0750 300 0725 300 0690 300 0

    #DIV/0! #DIV/0! #DIV/0!#VALUE! #VALUE! 0#VALUE! #VALUE! 0#DIV/0! #DIV/0! #DIV/0!#DIV/0! #DIV/0! #DIV/0!

  • 7/25/2019 Tamices ALGORITMO

    15/25

    Pe"o Re"tante en e! Ta(&) 4 Pe"o Re"tante en e! Ta(&) 30 00 00 00 00 0

    0 00 00 00 00 0

    #DIV/0! #DIV/0!#VALUE! #VALUE!

    0 #VALUE!#DIV/0! #DIV/0!#DIV/0! #DIV/0!

  • 7/25/2019 Tamices ALGORITMO

    16/25

    Pe"o Re"tante en e! Ta(&) 2 Pe"o Re"tante en e! Ta(&) 122.8571428571 48.5714285714

    37.5 31.2520.1030927835 35.567010309315.6069364162 27.745664739921.3197969543 27.4111675127

    28.1767955801 33.149171270758.4615384615 33.846153846255.7142857143 38.571428571448.2926829268 58.536585365915.1515151515 21.2121212121

    #DIV/0! #DIV/0!30.4568527919 31.979695431523.8095238095 22.2222222222

    #DIV/0! #DIV/0!#DIV/0! #DIV/0!

  • 7/25/2019 Tamices ALGORITMO

    17/25

    Pe"o Re"tante en e! Ta(&) 0 N%(ero228.5714285714 1"N 300

    231.25 2 300244.3298969072 3 300256.6473988439 4 300251.269035533 5 300

    238.6740331492 6 300207.6923076923 7 300205.7142857143 8 $"%1& 300193.1707317073 9$"%2& 300263.6363636364 10 $"% 3& 300

    #DIV/0! 11 #DIV/0!237.5634517767 12$"%5& #VALUE!253.9682539683 13$"%6& #VALUE!

    #DIV/0! 14 #DIV/0!#DIV/0! 15 #DIV/0!

  • 7/25/2019 Tamices ALGORITMO

    18/25

    LUGAR NMER DE MUE"TRA TAMI 5 TAMI 4 TAMI 3123 304 535 255 90

    6 407 440 2258 500 09 170 0

    10 0 12011 0 012 0 01314 0 12015 170 70

    16 200 139 017 0 25

    CERRATECA"

  • 7/25/2019 Tamices ALGORITMO

    19/25

    TAMI 2 TAMI 1 TAMI 0 E" TTAL Porcentae Tota! De"ea#o215 155 505 875 34.285714285775 90 510 675 44.4444444444

    175 140 670 1015 29.556650246325 25 190 800 37.5

    115 65 760 1030 29.1262135922

    225 180 620 1065 28.169014084550 50 250 1015 29.556650246360 100 400 1060 28.3018867925

    195 230 490 1085 27.6497695853140 110 610 980 30.61224489870 110 675 855 35.087719298285 90 650 825 36.363636363640 50 400 490 61.2244897959

    290 115 570 1095 27.397260274125 70 680 1115 26.9058295964

    65 40 140 584 51.3698630137130 90 660 905 33.1491712707

  • 7/25/2019 Tamices ALGORITMO

    20/25

    Porcentae a $%&tar RESTA DE TAMIZ 5 RESTA DE TAMIZ 4 RESTA DE TAMIZ 365.7142857143 0 0 055.5555555556 0 0 070.4433497537 0 0 21.1330049261

    62.5 0 334.375 15.62570.8737864078 0 0 63.786407767

    71.8309859155 0 0 28.732394366270.4433497537 0 309.9507389163 158.497536945871.6981132075 0 358.4905660377 072.3502304147 0 122.9953917051 069.387755102 0 0 83.2653061224

    64.9122807018 0 0 063.6363636364 0 0 038.7755102041 0 0 072.602739726 0 0 87.1232876712

    73.0941704036 0 124.2600896861 51.1659192825

    48.6301369863 97.2602739726 67.595890411 066.8508287293 0 0 16.7127071823

  • 7/25/2019 Tamices ALGORITMO

    21/25

    RESTA DE TAMIZ 2 RESTA DE TAMIZ 1 RESTA DE TAMIZ 0141.2857142857 101.8571428571 331.857142857141.6666666667 50 283.3333333333123.275862069 98.6206896552 471.9704433498

    15.625 15.625 118.7581.5048543689 46.067961165 538.640776699

    161.6197183099 129.2957746479 445.352112676135.2216748768 35.2216748768 176.108374384243.0188679245 71.6981132075 286.7924528302

    141.0829493088 166.4055299539 354.516129032397.1428571429 76.3265306122 423.265306122445.4385964912 71.4035087719 438.157894736854.0909090909 57.2727272727 413.636363636415.5102040816 19.387755102 155.1020408163

    210.5479452055 83.4931506849 413.835616438491.3677130045 51.1659192825 497.0403587444

    31.6095890411 19.4520547945 68.082191780886.9060773481 60.1657458564 441.2154696133

  • 7/25/2019 Tamices ALGORITMO

    22/25

    Pe"o $%&ta#o Tota! N%e'o Pe"o Pe"o Re"tante en e! Ta(&) 5575 300 0375 300 0715 300 0500 300 0730 300 0

    765 300 0715 300 0760 300 0785 300 0680 300 0555 300 0525 300 0190 300 0795 300 0815 300 0

    284 300 85605 300 0

  • 7/25/2019 Tamices ALGORITMO

    23/25

    Pe"o Re"tante en e! Ta(&) 4 Pe"o Re"tante en e! Ta(&) 30 00 00 8.8669950739

    200.625 9.3750 26.213592233

    0 11.2676056338130.0492610837 66.5024630542141.5094339623 047.0046082949 0

    0 36.73469387760 00 00 00 32.8767123288

    45.7399103139 18.8340807175

    120 00 8.2872928177

  • 7/25/2019 Tamices ALGORITMO

    24/25

    Pe"o Re"tante en e! Ta(&) 2 Pe"o Re"tante en e! Ta(&) 173.7142857143 53.142857142933.3333333333 40

    51.724137931 41.37931034489.375 9.375

    33.4951456311 18.932038835

    63.3802816901 50.704225352114.7783251232 14.778325123216.9811320755 28.301886792553.9170506912 63.594470046142.8571428571 33.673469387824.5614035088 38.596491228130.9090909091 32.727272727324.4897959184 30.61224489879.4520547945 31.506849315133.6322869955 18.8340807175

    29 2043.0939226519 29.8342541436

  • 7/25/2019 Tamices ALGORITMO

    25/25

    Pe"o Re"tante en e! Ta(&) 0 N%(ero173.1428571429 1 300226.6666666667 2 300198.0295566502 3 300

    71.25 4 300 R('+, %))*( T4221.359223301 5 300

    174.6478873239 6 30073.8916256158 7 300

    113.2075471698 8 300135.4838709677 9 300186.7346938776 10 300236.8421052632 11 300236.3636363636 12 300244.8979591837 13 300156.1643835616 14 300182.9596412556 15 300

    39 16 293218.7845303867 17 300