环刀法压实度自动计算程序2(1)

标准干密度1.814环刀号环刀质量土+环刀质量湿土样质量湿密度盒号1677102161983824198盒+湿土质量78.8990.3799.0781.0574.8399.0886.9388.0298.7784.9376.8793.36盒+干土质量73.1383.3491.0374.8669.0590.5680.1681.3091.0978.4371.3786.30盒质量20.9921.2821.2821.2621.0520.9921.1821.3522.3320.3721.1821.35水质量5.767.038.046.195.788.526.776.727.686.505.507.06干土质量52.1462.0669.7553.6048.0069.5758.9859.9568.7658.0650.1964.95含水量11.011.311.511.512.012.211.511.211.211.211.010.9平均含水量干密度压实度93.4正确94.2正确92.9正确93.5正确95.5正确95.5正确环刀号环刀质量土+环刀质量湿土样质量湿密度盒号167105142105216710盒+湿土质量95.0788.8887.3078.6675.0575.9773.0880.3276.0174.4574.9996.91盒+干土质量87.1981.5880.2472.5569.2469.9867.4573.9270.4869.1169.1688.64盒质量20.9921.2821.2620.8421.3221.0521.2620.8421.0520.9921.2821.26水质量7.887.307.066.115.815.995.636.405.535.345.838.27干土质量66.2060.3058.9851.7147.9248.9346.1953.0849.4348.1247.8867.38含水量11.912.112.011.812.112.212.212.111.211.112.212.3平均含水量干密度压实度93.1正确95.1正确95.6正确94.3正确93.9正确93.6正确381.293215.60596.89压实度自动计算电子表格1.7331.92411.02195.60580.37384.771.6881.7251.7351.7111.7031.89412.011.912.212.211.21.8911.931.9471.92619.02378.16386.09389.40383.98378.72618.46601.691240.30215.60215.60235.80240.301337605.00619.781.7091.6861.6961.73311.512.111.411.21.9061.891.8891.9273225.90381.27377.95377.80385.364198.70607.17593.55593.402195.60580.9663575.70377.00215.60215.6011.21.6951.8851.6971.90612.3起始终结92.295.810.5012.0045.0070.0021037218E-mail欢迎交流真的想念安徽大学交通分校的同寝室的朋友新增加了一点小功能如果不能使用宏,可以按F9键更新数据——2005年12月于淮南含水量范围如果只需要更新数据而不需要打印，则点击“从新生成数据”按纽或者按快捷键Ctrl+Z！总体设置区压实度设置标准干密度1.81本程序用于自动编写压实度资料（环刀法），快洁，简单！3干密度小数位数YSD-H-1.01正式版[e-mail]——2004年2月于安庆本程序作者QQ号码设置好以后，鼠标轻轻一点“开始”按纽，数据将自动更新并打印！[e-mail]测含水量时干土质量范围新增加了一点小功能如果不能使用宏,可以按F9键更新数据——2005年12月于淮南如果只需要更新数据而不需要打印，则点击“从新生成数据”按纽或者按快捷键Ctrl+Z！总体设置区本程序用于自动编写压实度资料（环刀法），快洁，简单！设置好以后，鼠标轻轻一点“开始”按纽，数据将自动更新并打印！编号环刀号环刀质量编号环刀号环刀质量编号环刀号11240.30152922195.60163033215.60173144198.70183255225.30193366225.90203477235.80213588229.70223692337102438112539122640132741142842环刀起始1结束于8环刀设置区彩色区域的环刀质量以及环刀号一定要填写！不然会出错。〈〈〈——设置需要使用的环刀！环刀质量环刀设置区彩色区域的环刀质量以及环刀号一定要填写！不然会出错。〈〈〈——设置需要使用的环刀！压实度试验记录津市政C6-3工程名称天津滨海旅游区玉砂道等五条道路及其附属设施建设工程2标段施工单位天津富凯建设集团有限公司工程部位彩辰路、道路工程路基填筑试验日期2013年3月25日土样种类取样位置取样深度K0+175-K0+616.692路基填筑6%灰土第四层取样桩号及部位10cm以下范围K0+265左4m6%灰土10cm以下范围200575.7K0+280右3m湿土质量（g）环刀质量（g）593.46%灰土607.2225.9381.319湿密度（g/cm3）3881.885湿密度环刀加湿土质量（g）环刀容积（cm3）198.7377.0盒+干土质量（g）73.1374.8669.058盒+湿土质量（g）78.8981.0574.8399.086.776.505.507.0690.5680.1678.4371.3791.09盒质量（g）20.9921.2621.0586.30水质量（g）5.766.195.788.5253.6048.0064.9520.9921.1820.3721.1869.5758.9858.06最大干密度（g/cm3）1.814干密度（g/cm3）含水量（％）1.695干土质量（g）52.14备注要求压实度≥92%记录：压实度（％）干密度盒号（#）16102167.03##########7##########8.0421.2869.75799.0791.0310cm以下范围K0+315右5m6%灰土5cm以下范围K0+330左6m81.3086.9384.9319247.6821.3522.332001.9272013年3月25日21.3550.1976.8793.361.814试验：监理工程师：报告日期：93.488.0298.7759.9568.766.722001.9065cm以下范围K0+300左6m6%灰土593.6215.6378.02001.8902001.8896%灰土581.0195.6385.4215.6377.8195.6384.82001.92410cm以下范围K0+350右7m6%灰土580.41.7331.81495.51.7091.81494.21.6861.81492.91.6961.7331.81495.511.211.512.111.411.211.093.57层7层16771021678.8990.3799.0781.0574.8399.0873.1383.3491.0374.8669.0590.565.767.038.046.195.788.5220.9921.2821.2821.2621.0520.9952.1462.0669.7553.6048.0069.571111.311.511.51212.2备注审核：试验：黑龙江省工程质量监督总站监制压实度（%）93.494.292.9最大干密度（g/cm³）1.811.811.81本试验经二次平行测定后，其平行差不得大于规定。取其算术平均值。计算：11.211.512.1干密度（g/cm³）1.6951.7091.686干密度盒号盒+湿土质量(g)盒+干土质量(g)水质量(g)盒质量(g)干土质量(g)含水量(%)平均含水量(%)土质量(g)377381378200湿密度（g/cm³）1.891.911.893环刀+土质量(g)576607594215.6湿密度环刀号46环刀质量(g)198.7225.9环刀容积(cm³)200200取样桩号及井号取样深度30cm(K3+560—K3+480)YSX3—YSX1第取样位置土样种类砂(K3+560—K3+480)YSX3—YSX1第代表部位沟槽回填管、沟断面尺寸b*h=1.9*2.37施工单位击实种类重型击实土壤压实度（管沟类）试验记录试验表34工程名称试验日期2009.10.68层8层198382419886.9388.0298.7784.9376.8793.3680.1681.3091.0978.4371.3786.306.776.727.686.505.507.0621.1821.3522.3320.3721.1821.3558.9859.9568.7658.0650.1964.9511.511.211.211.21110.9备注审核：试验：代表部位沟槽回填管、沟断面尺寸b*h=1.9*2.37土壤压实度（管沟类）试验记录试验表34工程名称试验日期2009.10.6取样桩号及井号取样深度30cm(K3+560—K3+480)YSX3—YSX1第施工单位击实种类重型击实215.6195.6环刀容积(cm³)200200取样位置土样种类砂(K3+560—K3+480)YSX3—YSX1第2环刀+土质量(g)593581580湿密度环刀号32环刀质量(g)200湿密度（g/cm³）1.891.931.92195.6土质量(g)3783853851.733干密度盒号盒+湿土质量(g)盒+干土质量(g)水质量(g)盒质量(g)干土质量(g)含水量(%)平均含水量(%)最大干密度（g/cm³）1.811.811.8111.411.211干密度（g/cm³）1.6961.733本试验经二次平行测定后，其平行差不得大于规定。取其算术平均值。计算：黑龙江省工程质量监督总站监制压实度（%）93.595.595.59层9层16710514295.0788.8887.3078.6675.0575.9787.1981.5880.2472.5569.2469.987.887.307.066.115.815.9920.9921.2821.2620.8421.3221.0566.2060.3058.9851.7147.9248.9311.912.11211.812.112.2备注审核：试验：土壤压实度（管沟类）试验记录代表部位沟槽回填管、沟断面尺寸b*h=1.9*2.37试验表34工程名称试验日期2009.10.6取样桩号及井号取样深度30cm(K3+560—K3+480)YSX3—YSX1第施工单位击实种类重型击实240.3215.6环刀容积(cm³)200200取样位置土样种类砂(K3+560—K3+480)YSX3—YSX1第3环刀+土质量(g)618602605湿密度环刀号13环刀质量(g)200湿密度（g/cm³）1.891.931.95215.6土质量(g)3783863891.735干密度盒号盒+湿土质量(g)盒+干土质量(g)水质量(g)盒质量(g)干土质量(g)含水量(%)平均含水量(%)最大干密度（g/cm³）1.811.811.811211.912.2干密度（g/cm³）1.6881.725本试验经二次平行测定后，其平行差不得大于规定。取其算术平均值。计算：黑龙江省工程质量监督总站监制压实度（%）93.195.195.610层10层10521671073.0880.3276.0174.4574.9996.9167.4573.9270.4869.1169.1688.645.636.405.535.345.838.2721.2620.8421.0520.9921