細(xì)骨料自動計(jì)算

數(shù)據(jù)控制區(qū)（常數(shù)）,,,,,,,,,,,隨機(jī)結(jié)果,,,,最終結(jié)果,,,,

"表觀

密度",序號,試樣質(zhì)量,,瓶+水質(zhì)量,,表觀密度,,,,,表觀密度,,瓶+水+試樣,,表觀密度,平均值,位數(shù),,說明：各種底色所代表的含義：

,,質(zhì)量(g),位數(shù),質(zhì)量(g),極值,最小值,最大值,位數(shù),偏差,,數(shù)值,精度,質(zhì)量,位數(shù),,,,,1、淺綠色質(zhì)量代表常量，是各種數(shù)據(jù)最基本的數(shù)值。

,1,300,0,1271,1267,2610,2680,-1,20,,2639.93,2,1458,0,2650,2650,-1,2615,2、深藍(lán)色精度代表在偏差范圍內(nèi)所的最終結(jié)果的精度，精度越大，位數(shù)

,2,300,0,1272,1315,,,,,,2648.41,2,1459,0,2650,,-1,2620,越多，反應(yīng)的結(jié)果偏差越小。

,,筒質(zhì)量,,筒容積,,堆積密度,,,,,堆積密度,,筒+砂,,表觀密度,平均值,精度,,3、深褐色數(shù)值代表預(yù)計(jì)結(jié)果，預(yù)計(jì)結(jié)果與實(shí)際結(jié)果的誤差由精度控制

,,質(zhì)量(g),位數(shù),體積,位數(shù),最小值,最大值,位數(shù),偏差,,數(shù)值,精度,質(zhì)量,位數(shù),,,,,4、深橘色位數(shù)代表數(shù)據(jù)保留的小數(shù)點(diǎn)位數(shù)，如保留位數(shù)在小數(shù)點(diǎn)前，

"松散

堆積",1,380,0,1,0,1480,1520,-1,20,,1510.61,2,1891,0,1510,1520,-1,,則取負(fù)值。

,2,380,0,,0,,,,,,1515.83,2,1896,0,1520,,-1,,另：本表格應(yīng)與相應(yīng)的宏配套，否則無法顯示數(shù)據(jù)。

"緊密

堆積",1,380,0,,0,1600,1700,-1,20,,1687.21,2,2067,0,1690,1690,-1,,隨機(jī)取數(shù)按F9。

,2,380,0,,0,,,,,,1693.42,2,2073,0,1690,,-1,,篩分分為1區(qū)、2區(qū)和3區(qū)，選擇時(shí)請?jiān)诰G色背景的處更換選擇的區(qū)間。

,,試驗(yàn)前質(zhì)量,,松散孔隙率,,含泥量,,,,,含泥量,,試驗(yàn)后質(zhì)量,,表觀密度,平均值,精度,,使用方法

,,質(zhì)量(g),位數(shù),43,,最小值,最大值,位數(shù),偏差,,數(shù)值,精度,質(zhì)量,位數(shù),,,,,1、打開一個(gè)Excel文檔，點(diǎn)擊“工具”-“宏”-“安全性”，選擇“中”；

含泥量,1,400,0,,,1.3,1.8,1,0.2,,1.65,2,393.4,1,1.7,1.8,1,,2、點(diǎn)擊“工具”-“加載宏”-“瀏覽”，按存放路徑找到相應(yīng)的宏“試驗(yàn)計(jì)算”

,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、關(guān)閉Excel文檔，重新打開本文檔。

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

"云母

含量",,烘干試樣質(zhì)量,,,,,,,,,云母含量,,挑出云母量,,表觀密度,平均值,精度,,

,,質(zhì)量(g),位數(shù),,,最小值,最大值,位數(shù),偏差,,數(shù)值,精度,質(zhì)量,位數(shù),,,,,

,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,,

,區(qū)域選擇,,2區(qū),,篩分質(zhì)量,,500,,,,,,,,,,,,

,"累計(jì)篩余

偏差值",,1,1,1,1,1,1,位數(shù),,<0.15,位數(shù),散失,細(xì)度模數(shù),,,,,

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

,分計(jì)(%),,7.6,14.4,19.4,22.2,18.2,15.2,1,,,,,,,,,,

,累計(jì)(%),,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,,,,

,分計(jì)(%),,6.8,15,19,22,18.6,15.8,1,,,,,,,,,,

,累計(jì)(%),,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,,,,,,細(xì)度模數(shù)Mx,,,,,

1區(qū),范圍值,,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區(qū),范圍值,,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區(qū),范圍值,,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,,,,

,區(qū)域選擇,,2區(qū),,篩分質(zhì)量,,500,,,,,,,,,,,,

隨機(jī)取值,最小值,,3,16,31,52,78,95,,,,,,2.65,2,,,,

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

,累計(jì)篩余1,,7.55,21.99,41.4,63.57,81.73,97.03,2,,,,,2.9,2,,,,

,累計(jì)篩余2,,6.75,21