粗集料筛分及级配合成曲线自动生成版.xls

表表1 15 531.531.5表表2 210102020筛上重分计筛余累计筛余平均通过率筛上重37.50.00.0000010037.50.00.031.50.00.0000010031.50.00.026.590.462.71.81.21.81.298.526.50.00.019607.8261.411.85.213.66.490190.00.016698.1569.813.511.327.117.777.61633.134.49.51947.21926.037.838.164.955.839.659.51608.61800.74.751732.12100.933.641.698.597.42.054.751359.51171.22.3668.2120.51.32.499.899.80.22.3619.49.30.0758.912.30.20.210010000.0757.34.5用于干筛的干燥集料总质量51525057用于干筛的干燥集料总质量3027各号筛上的分计筛余之和5152.75053.6各号筛上的分计筛余之和3027.9筛底 8.912.3筛底 7.3由于筛分造成的损耗-0.73.4由于筛分造成的损耗-0.9合合成成级级配配筛上重分计筛余累计筛余37.500000031.500000026.590.462.71.81.21.81.219607.8261.4125.213.86.416698.1569.813.811.327.617.79.51947.2192638.538.166.155.84.751732.12100.934.341.6100.497.42.3668.2120.51.32.4101.799.80.0758.912.30.20.2101.9100表表3 3161631.531.5分计筛余累计筛余平均通过率筛上重分计筛余累计筛余000010037.50.00.0000000010031.50.00.0000000010026.5103.00.02.102.10000100191849.91615.93732.539.11.11.11.11.198.916896.8869.317.917.55753.159.654.260.742.559.51613.21910.632.338.489.344.938.899.199.50.74.75518.7562.610.411.399.70.60.399.799.80.252.369.310.70.20.299.90.20.199.999.90.10.0758.69.30.20.2100.13030用于干筛的干燥集料总质量502350433020.1各号筛上的分计筛余之和4999.54978.44.5筛底 8.69.39.9由于筛分造成的损耗23.564.6平均累计筛余平均通过率0100掺配比例表1表2表3010010001.598.5掺配总量5152.75053.610.189.922.6577.3560.9539.0598.91.1100.8-0.75101-0.95510平均通过率51652001005250100531.5098.9554032.564.210205046.51631.588.411.15204099.70.331.56399.90.14080100.1-0.1损耗不得超过干燥集料总质量的0.5%累计筛余宏宏根根石石场场碎碎石石掺掺配配比比例例计计算算表表226筛上重分计筛余累计筛余平均分计筛余平均累计筛余平均通过率规范值5.114.72下限上限中值筛孔尺寸5.114.37531.5900 00 00000001000007.587.580750 00 0000000100-6.985.110630 00 0000000100-6.454.720530 00 0000000100-5.973.761537.50.00.00.00.00000001000005.112.757031.50.00.00.00.0000000100052.54.722.029026.590.490.462.762.71.81.21.81.21.51.598.5-4.371.479519607.8607.8261.4261.411.85.213.66.48.510901545303.760.3110016698.1698.1569.8569.813.511.327.117.712.422.477.6-3.4801009.51947.21947.21926.01926.037.838.164.955.83860.439.67090802.7501004.751732.11732.12100.92100.933.641.698.597.437.698290100952.0201002.3668.268.2120.5120.51.32.499.899.81.999.80.29510097.5 1.4701000.0758.98.912.312.30.20.21001000.21000-0.3101000.075 2.36 4.75 9.5 16 19 26.5 31.5 37.5 53 63 75 90 筛分曲线0102030405060708090100筛孔尺寸mm通过率0.075 2.36 4.75 9.5 16 19 26.5 31.5 37.5 53 63 75 90 筛分曲线0102030405060708090100筛孔尺寸mm通过率11891033124.373.763.482.752.016100254 1.471670.31173.763.482.752.021.47166988 0.31173000052.54530908010095用于干筛的干燥集料总质量 5300520010097.5各号筛上的分计筛余之和 5152.7 5053.6100100筛底 8.912.3100100由于筛分造成的损耗147.3146.4100100100100100100100100宏宏根根石石场场碎碎石石掺掺配配比比例例计计算算表表226筛上重分计筛余累计筛余平均分计筛余平均累计筛余平均通过率规范值5.114.72下限上限中值筛孔尺寸5.114.37531.5900 00000001000007.587.580750 00 0000000100-6.985.110630 00 0000000100-6.454.720530 00 0000000100-5.973.761537.50.00.00.00.00000001000005.112.757031.50.00.00.00.0000000100052.54.722.029026.590.490.462.762.71.81.21.81.21.51.598.5-4.371.479519607.8607.8261.4261.411.85.213.66.48.510901545303.760.3110016698.1698.1569.8569.813.511.327.117.712.422.477.6-3.4801009.51947.21947.21926.01926.037.838.164.955.83860.439.67090802.7501004.751732.11732.12100.92100.933.641.698.597.437.698290100952.0201002.3668.268.2120.5120.51.32.499.899.81.999.80.29510097.5 1.4701000.0758.98.912.312.30.20.21001000.21000-0.3101000.075 2.36 4.75 9.5 16 19 26.5 31.5 37.5 53 63 75 90 筛分曲线0102030405060708090100筛孔尺寸mm通过率0.075 2.36 4.75 9.5 16 19 26.5 31.5 37.5 53 63 75 90 筛分曲线0102030405060708090100筛孔尺寸mm通过率11891033124.373.763.482.752.016100254 1.471670.31173.763.482.752.021.47166988 0.31173000052.54530908010095用于干筛的干燥集料总质量 5300520010097.5各号筛上的分计筛余之和 5152.7 5053.6100100筛底 8.912.3100100由于筛分造成的损耗147.3146.4100100100100100100100100宏宏根根石石场场碎碎石石掺掺配配比比例例计计算算表表226筛上重分计筛余累计筛余平均分计筛余平均累计筛余平均通过率规范值5.114.72下限上限中值筛孔尺寸5.114.371020900 00 00000001000007.587.580750 00 0000000100-6.984.370630 00 0000000100-6.453.760530 00 0000000100-5.972.758537.50.00.00.00.0000000100-5.112.029531.50.00.00.00.0000000100-4.721.4710026.50.00.00.00.00000001000004.370100190.00.00.00.00000001000157.53.7601001633.133.134.434.41.11.11.11.11.11.198.9-3.4801009.51608.61608.61800.71800.753.159.654.260.756.457.542.58510092.5 2.7501004.751359.51359.51171.21171.244.938.899.199.541.999.30.79510097.5 2.0201002.3619.419.49.39.30.60.399.799.80.599.80.2-1.4701000.0757.37.34.54.50.20.199.999.90.299.90.1-0.3101000.075 2.36 4.75 9.5 16 19 26.5 31.5 37.5 53 63 75 90 筛分曲线0102030405060708090100筛孔尺寸mm通过率0.075 2.36 4.75 9.5 16 19 26.5 31.5 37.5 53 63 75 90 筛分曲线0102030405060708090100筛孔尺寸mm通过率11891033124.373.763.482.752.016100254 1.471670.31173.763.482.752.021.47166988 0.311730000157.510092.510097.5100100用于干筛的干燥集料总质量 53005200100100各号筛上的分计筛余之和 3027.9 3020.1100100筛底 7.34.5100100由于筛分造成的损耗2272.1 2179.9100100100100100100100100宏宏根根石石场场碎碎石石掺掺配配比比例例计计算算表表226筛上重分计筛余累计筛余平均分计筛余平均累计筛余平均通过率规范值5.114.72下限上限中值筛孔尺寸5.114.371631.5900 00 00000001000007.587.580750 00 0000000100-6.985.110630 00 0000000100-6.454.720530 00 0000000100-5.973.488537.50.00.00.00.00000001000005.112.029531.50.00.00.00.000000010001054.721.4710026.5103.0103.00.00.02.102.101.11.198.9-4.370100191849.91849.91615.91615.93732.539.132.534.835.864.2-3.76010016896.8896.8869.3869.317.917.5575017.753.546.58510092.5 3.4801009.51613.21613.21910.61910.632.338.489.388.435.488.911.1-2.7501004.75518.7518.7562.6562.610.411.399.799.710.999.70.39510097.5 2.0201002.369.39.310.710.70.20.299.999.90.299.90.1-1.4701000.0758.68.69.39.30.20.2100.1100.10.2100.1-0.1-0.3101000.075 2.36 4.75 9.5 16 19 26.5 31.5 37.5 53 63 75 90 筛分曲线0102030405060708090100筛孔尺寸mm通过率0.075 2.36 4.75 9.5 16 19 26.5 31.5 37.5 53 63 75 90 筛分曲线0102030405060708090100筛孔尺寸mm通过率11891033124.373.763.48 2.754072.016100254 1.471670.31173.763.482.752.01611.47166988 0.31173000010510092.510097.5100100用于干筛的干燥集料总质量 53005200100100各号筛上的分计筛余之和 4999.5 4978.4100100筛底 8.69.3100100由于筛分造成的损耗300.5221.6100100100100100100100100碎石或卵石的颗粒级配规格级级配配情情况况公公称称粒粒级级（mmmm）累累计计筛筛余余（按按质质量量百百分分率率计计）方方孔孔筛筛筛筛孔孔尺尺寸寸（mmmm）2.362.364.754.759.59.51616连连续续级级配配5 5101095#80#0 1505 5161695#85#30 600 105 5202095#90#40 805 5252595#90#30 705 531.531.595#90#70 905 5404095#70 90单单粒粒级级1010202095#85#161631.531.595#85#2020404095#31.531.5636395#40408080191926.526.531.531.537.537.5535363637575909000 1000 5015 450 5030 650 500 1500 10080#0 10075#45 750 10095#70#30 600 100碎石或卵石的颗粒级配规格累累计计筛筛余余（按按质质量量百百分分率率计计）方方孔孔筛筛筛筛孔孔尺尺寸寸（mmmm）0-51-21-3