副本副本压实度自动计算表2.xls

1909075.0417 2919174.878 3929272.8210 4939369.1114 5949472.4518 6959572.262 7969675.063 8979772.2516 9989873.186 10999971.881 1110010070.6719 1210110171.0214 1310 1410310375.9414 1510410474.0317 1610510569.7111 1710610671.886 1810710773.177 1910810871.820 2010910969.7610 11011075.29 11111171.0411311370.78 11411472.95 11511567.18 11611673.9 11711771.61 11811874.43 11911974.38 12012072.88 12112196.47 12212273.12 12312370.67 12412471.31 12512571.01 12612673.55 12712769.0612912971.61 13013070.55 13113171.66 13213270.64 13313370.76 13413471.72 13513572.83 13613668.64 13713770.0713813870.39 13913971.36 14014072.2 14114167.05 14214272.14 14314371.714514572.42 14614669.25 14714772.4314914976.25 15015070.6 15115168.2615315371.33 15415471.36 15515567.83690.3041 3544.0418 2953.9559 1465.9064 501.9353 8854.1908 5845.9890 1281.3182 4805.0418 9371.5807 379.5360 1528.0700 4360.8186 2165.3568 1350.2343 2906.1271 5797.1573 5208.4606 86.9924 3002.7556 7748.3733 9200.0399 7857.0021 7848.4680 2618.9462 2084.8735 2355.1736 1622.1978 808.1080 6890.3205 7912.4803 5681.3960 4339.8576 8633.3061 4603.8245 1805.2899 6453.6904 9697.8550 7304.4560 176.7288 6257.9130 7297.4243 6887.2778 5768.1289 2483.9872 8008.9702 4666.0144 5425.15808281.7504 9578.7792 5102.7300 193.5256 2876.9192 7315.2483 9490.0054 6805.0929 7178.3176 9679.8324 628.5858 3321.2324 7331.7867 5300.0467 4789.8754 5036.9287 3442.1139 1062.0571 7865.8740 4678.8062 9152.6187 1460.5929 4448.6350 3932.8152 57.6226 9280.6185 8750.2543 4364.3115 8597.3320 8703.3059 3469.8097 9587.1501 4942.3073 9711.5404 2215.2602 6405.0769 8739.3989 1356.0468 7305.8350 9718.5149 9982.5421 3522.3945 1380.9644 1079.6152 5669.2911 9918.0748 2439.6810 293.81895908.0098 9088.6787 9692.8884 3589.0882 5830.9002 1926.6502 7186.6312 5912.1501 5438.1055 1539.9468 5399.5455 3174.1381 3227.7654 8949.5770 1307.3524 7487.8440 9781.1737 8094.0005 3468.7536 9891.0831 7933.0112 835.4062 7952.1055 4378.8025 3860.0306 2655.4657 9402.4982 9597.9949 5824.3714 773.6178 1502.5835 6138.6942 3101.6823 9145.1089 4142.6056 8615.2054 9696.2441 864.3355 2080.1716 4521.6474 4596.4245 6661.0254 7833.9879 166.2483 6585.5957 552.4409 8650.8295 2805.89223045.8659 7485.1979 5747.4125 9252.5322 7515.8148 2505.6017 4324.0089 9528.1726 4805.9269 7903.4169 4253.7014 4481.2865 3192.8999 8990.2699 2206.8724 7952.6126击实编号最大干密度 (g/cm3)1.85最佳含水率12.8结构层次砂容重编 号锥体内砂重(g)2081标准砂密度 (g/cm3)1.39要求压实度(%)96取样桩号取样 位置层厚 （cm ）灌砂前筒 砂重 (g)灌砂后 筒砂 重(g)锥体 及粗 糙面 耗砂 (g)灌入试 坑砂重 (g)试坑体 积(cm3)湿试样 重(g)湿密度 (g/cm3 )盒号 盒重(g)盒湿土 重(g)盒干重 土(g)干土重 (g)水重(g)含水率 (%)平均含 水率 (%)干密度 (g/cm3 )压实度 (%)119.72200011354209885486149.8126072.0510671.88436.49394.43322.5542.0613.0413.41.8197.69772.25406.69366.40294.1540.2913.70219.32200011533212583426001.2121822.039971.88487.68438.39366.5149.2913.4513.71.7996.810375.94451.88406.06330.1245.8213.88319.62200011459210984326066.0125572.0710773.17479.94432.89359.7247.0513.0813.41.8398.79174.87474.43426.13351.2648.3013.75419.52200011434212784396071.1122642.029272.82487.04438.48365.6648.5613.2813.31.7896.310569.71417.17376.19306.4840.9813.37519.52200011372212585036117.0124182.039572.26444.16401.43329.1742.7312.9813.41.8097.59075.04435.30391.78316.7443.5213.74619.42200011439212984326066.2124362.0510871.80395.20356.15284.3539.0513.7314.21.8097.310375.94397.83356.70280.7641.1314.65719.82200011378212584976113.0125932.069971.88390.00351.43279.5538.5713.8014.21.8197.610375.94398.67357.39281.4541.2814.67819.92200011207212286716238.4129132.07# #REF!460.02#REF!#REF!#REF!12.9513.11.8399.010671.88433.71391.20319.3242.5113.31919.72200011421210784726094.7127382.0910070.67484.72433.68363.0151.0414.0614.41.8398.99572.26471.26420.09347.8351.1714.711019.92200011296211585896178.8126052.049675.06428.82385.33310.2743.4914.0214.31.7997.010969.76432.60386.70316.9445.9014.48试坑体积减小值160压实度最大值99.1压实度最小值96含水率最大值14.2含水率最小值12.8压实层厚最大值19.9压实层厚最小值19.1粗糙面砂重最大值50粗糙面砂重最小值15灌砂前筒砂22000盒湿土重(g)最大值489盒湿土重(g)最小值389灌砂筒直径（CM）20说明：红色字体需根据实际手动设置 ，设置好后，数据会自动关联计算到 “压实度正算”表！“200压实度反算 ”表只是用来设置的！击实编 号最大干密度 (g/cm3)1.85最佳含水率(%)12.8结构层次砂容重 编号锥体内砂重(g)2081标准砂密度 (g/cm3)1.39要求压实度(%)96.2取样桩 号取样位 置层厚（ cm）灌砂前 筒砂 重(g)灌砂后 筒砂 重(g)锥体及 粗糙面 耗砂 (g)灌入试 坑砂重 (g)试坑体 积(cm3)湿试样 重(g)湿密度 (g/cm3 )盒号盒重 (g)盒湿 土重 (g)盒干 重土 (g)干土重 (g)水重 (g)含水率 (%)平均含 水率 (%)干密度 (g/cm3 )压实度 (%)119.72200011354209885486149.6126072.0510671.88436.49394.43322.5542.0613.0413.41.8197.89772.25406.69366.40294.1540.2913.70219.32200011533212583426001.4121822.039971.88487.68438.39366.5149.2913.4513.71.7996.810375.94451.88406.06330.1245.8213.88319.62200011459210984326066.2125572.0710773.17479.94432.89359.7247.0513.0813.41.8398.99174.87474.43426.13351.2648.3013.75419.52200011434212784396071.2122642.029272.82487.04438.48365.6648.5613.2813.31.7896.210569.71417.17376.19306.4840.9813.37519.52200011372212585036117.3124182.039572.26444.16401.43329.1742.7312.9813.41.7996.89075.04435.30391.78316.7443.5213.74619.42200011439212984326066.2124362.0510871.80395.20356.15284.3539.0513.7314.21.8097.310375.94397.83356.70280.7641.1314.65719.82200011378212584976112.9125932.069971.88390.00351.43279.5538.5713.8014.21.8097.310375.94398.67357.39281.4541.2814.67819.92200011207212286716238.1129132.07#REF!#REF!460.02#REF!#REF!#REF!#REF!#REF!#REF!#REF!10671.88433.71391.20319.3242.5113.31919.72200011421210784726095.0127382.0910070.67484.72433.68363.0151.0414.0614.41.8398.99572.26471.26420.09347.8351.1714.711019.92200011296211585896179.1126052.049675.06428.82385.33310.2743.4914.0214.31.7896.210969.76432.60386.70316.9445.9014.48