项目名称监理单位层次25锥体内砂重(g)1.99佛开高速公路改扩建工程施工单位单项工程名称718最佳含水量(%)合同段路基工程检测范围1.38≥90锥体砂密度Ps(g/cm3)9.7要求压实度(%)最大干密度(g/cm3)试验位置（桩号）序号123456789101112131415161718含水量测定试验项目公式灌砂前筒+砂重(g)灌砂后筒+砂重(g)灌入试坑砂重(g)试坑体积(cm3)湿样质量(g)湿容重(g/cm3)盒号盒重(g)盒+湿土重(g)盒+干土重(g)干土重(g)水重(g)含水量(%)平均含水量(%)干容重(g/cm)最大干密度(g/cm3)压实度(%)压实层厚度31250080953687267253171.991472.64672.451250079573825277255722.011074.62373.2241250080303752271954111.991571.951250082133569258651982.011871.80973.5171250079993783274154551.99573.58121250079743808275954631.981174.4671.8269.62316.18294.62225.0021.569.69.91.811.9991.072.68339.82309.07315.71314.59308.64303.38315.64295.35316.85287.18294.01292.43286.66280.88293.56274.01244.21214.73219.39219.21214.84208.93221.76200.5022.979.49.81.811.9991.021.8910.221.709.922.1610.110.01.831.9992.021.9810.222.5010.822.0810.021.3410.6310.46331.54304.91288.50308.56283.47214.92235.88209.0121.9610.222.989.721.4410.310.01.801.9990.510.51.801.9990.510.31.821.9991.5注：下载下来后打开启用编辑，红色字是要自己根据情况填写，工作表盒重里的数据根据自己情况设定，如果盒号多余20个那么请修改宏，右边的参数也是要根据自己的情况设定。一切都设定好后右边的可以隐藏。按Ctrl+M所有结果自动生成盒号不会有重复。保证不会后悔下载。$O$6=$U$5,FIXED((RAND()*($U$6-($U$5+0.4))+$U$5),1
要求压实度
最小值最大值
9094
9396
最小值
灌砂后筒+砂重
水重
780021
平均含水量9.81.8392.1
1.8191.2
9598
9699
98100
最大值830023
2426
11.21.8090.5
1.821.811.8091.491.190.5
因篇幅问题不能全部显示，请点此查看更多更全内容