细骨料自动计算

数据控制区（常数）,,,,,,,,,,,随机结果,,,,最终结果,,,,

"表观

密度",序号,试样质量,,瓶+水质量,,表观密度,,,,,表观密度,,瓶+水+试样,,表观密度,平均值,位数,,说明：各种底色所代表的含义：

,,质量(g),位数,质量(g),极值,最小值,最大值,位数,偏差,,数值,精度,质量,位数,,,,,1、浅绿色质量代表常量，是各种数据最基本的数值。

,1,300,0,1271,1267,2610,2680,-1,20,,2639.93,2,1458,0,2650,2650,-1,2615,2、深蓝色精度代表在偏差范围内所的最终结果的精度，精度越大，位数

,2,300,0,1272,1315,,,,,,2648.41,2,1459,0,2650,,-1,2620,越多，反应的结果偏差越小。

,,筒质量,,筒容积,,堆积密度,,,,,堆积密度,,筒+砂,,表观密度,平均值,精度,,3、深褐色数值代表预计结果，预计结果与实际结果的误差由精度控制

,,质量(g),位数,体积,位数,最小值,最大值,位数,偏差,,数值,精度,质量,位数,,,,,4、深橘色位数代表数据保留的小数点位数，如保留位数在小数点前，

"松散

堆积",1,380,0,1,0,1480,1520,-1,20,,1510.61,2,1891,0,1510,1520,-1,,则取负值。

,2,380,0,,0,,,,,,1515.83,2,1896,0,1520,,-1,,另：本表格应与相应的宏配套，否则无法显示数据。

"紧密

堆积",1,380,0,,0,1600,1700,-1,20,,1687.21,2,2067,0,1690,1690,-1,,随机取数按F9。

,2,380,0,,0,,,,,,1693.42,2,2073,0,1690,,-1,,筛分分为1区、2区和3区，选择时请在绿色背景的处更换选择的区间。

,,试验前质量,,松散孔隙率,,含泥量,,,,,含泥量,,试验后质量,,表观密度,平均值,精度,,使用方法

,,质量(g),位数,43,,最小值,最大值,位数,偏差,,数值,精度,质量,位数,,,,,1、打开一个Excel文档，点击“工具”-“宏”-“安全性”，选择“中”；

含泥量,1,400,0,,,1.3,1.8,1,0.2,,1.65,2,393.4,1,1.7,1.8,1,,2、点击“工具”-“加载宏”-“浏览”，按存放路径找到相应的宏“试验计算”

,2,400,0,,,,,,,,1.74,2,393,1,1.8,,1,,选择后确定。

"泥块

含量",1,200,0,,,0.2,0.4,1,0.2,,0.3,2,199.4,1,0.3,0.3,1,,3、关闭Excel文档，重新打开本文档。

,2,200,0,,,,,,,,0.37,2,199.3,1,0.3,,1,,

"云母

含量",,烘干试样质量,,,,,,,,,云母含量,,挑出云母量,,表观密度,平均值,精度,,

,,质量(g),位数,,,最小值,最大值,位数,偏差,,数值,精度,质量,位数,,,,,

,1,15,0,,,0,0.6,1,0,,0.1,1,0,1,0,0,1,,

,2,15,0,,,,,,,,0.1,1,0.0,1,0,,1,,

,区域选择,,2区,,筛分质量,,500,,,,,,,,,,,,

,"累计筛余

偏差值",,1,1,1,1,1,1,位数,,<0.15,位数,散失,细度模数,,,,,

筛分,筛余(g),,38,72,97,111,91,76,0,,3,1,0,2.9,2,2.9,1,,

,分计(%),,7.6,14.4,19.4,22.2,18.2,15.2,1,,,,,,,,,,

,累计(%),,7.6,22.0,41.4,63.6,81.8,97.0,2,,,,,,,,,,

,筛余(g),,34,75,95,110,93,79,0,,2.8,1,0,2.9,2,,,,

,分计(%),,6.8,15,19,22,18.6,15.8,1,,,,,,,,,,

,累计(%),,6.8,21.8,40.8,62.8,81.4,97.2,2,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,

样号,,,4.75,2.36,1.18,0.6,0.3,0.15,,,,,,细度模数Mx,,,,,

1区,范围值,,10~0,35~5,65~35,85~71,95~80,100~90,,,,,,,,,,,

,最小值,,3,18,44,72,86,95,,,,,,3.09,2,,,,

,最大值,,8,28,58,80,93,98,,,,,,3.45,2,,,,

2区,范围值,,10~0,25~0,50~10,70~41,92~70,100~90,,,,,,,,,,,

,最小值,,3,16,31,52,78,95,,,,,,2.65,2,,,,

,最大值,,8,22,43,64,86,98,,,,,,2.97,2,,,,

3区,范围值,,10~0,15~0,25~0,40~15,85~55,100~90,,,,,,,,,,,

,最小值,,3,7,15,24,60,92,,,,,,1.89,2,,,,

,最大值,,6,13,22,36,80,96,,,,,,2.31,2,,,,

,区域选择,,2区,,筛分质量,,500,,,,,,,,,,,,

随机取值,最小值,,3,16,31,52,78,95,,,,,,2.65,2,,,,

,最大值,,8,22,43,64,86,98,,,,,,2.97,2,,,,

,累计筛余1,,7.55,21.99,41.4,63.57,81.73,97.03,2,,,,,2.9,2,,,,

,累计筛余2,,6.75,21