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

"表觀

密度",序號,試樣質(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、深藍色精度代表在偏差范圍內(nèi)所的最終結果的精度，精度越大，位數(shù)

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

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

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

"松散

堆積",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,,另：本表格應與相應的宏配套，否則無法顯示數(shù)據(jù)。

"緊密

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

,2,380,0,,0,,,,,,1693.42,2,2073,0,1690,,-1,,篩分分為1區(qū)、2區(qū)和3區(qū)，選擇時請在綠色背景的處更換選擇的區(qū)間。

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

,,質(zhì)量(g),位數(shù),43,,最小值,最大值,位數(shù),偏差,,數(shù)值,精度,質(zhì)量,位數(shù),,,,,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,,

"云母

含量",,烘干試樣質(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,,,,,,,,,,,,

,"累計篩余

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

篩分,篩余(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,,,,,,細度模數(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,,,,,,,,,,,,

隨機取值,最小值,,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