[公路] 路基压实度自动生成表（解决盒号重复出现问题）希望对大家有帮助... [复制链接]

压实度检测记录表（灌砂法）„vÍc'¬§bbs.3c3t.comj”U6ˌ´#¼í
                                                    编号：S1—004—□□□—□□□□„vÍc'¬§bbs.3c3t.comj”U6ˌ´#¼í
试验单位        合 同 号    „vÍc'¬§bbs.3c3t.comj”U6ˌ´#¼í
土场位置        最大干密度(g/cm3)     „vÍc'¬§bbs.3c3t.comj”U6ˌ´#¼í
检测范围        最佳含水量(%)    „vÍc'¬§bbs.3c3t.comj”U6ˌ´#¼í
层    次        检测日期    „vÍc'¬§bbs.3c3t.comj”U6ˌ´#¼í
试   验        复     核    „vÍc'¬§bbs.3c3t.comj”U6ˌ´#¼í
„vÍc'¬§bbs.3c3t.comj”U6ˌ´#¼í
        桩号„vÍc'¬§bbs.3c3t.comj”U6ˌ´#¼í
   位„vÍc'¬§bbs.3c3t.comj”U6ˌ´#¼í
  项    目    置                    „vÍc'¬§bbs.3c3t.comj”U6ˌ´#¼í
                    „vÍc'¬§bbs.3c3t.comj”U6ˌ´#¼í
检测深度\层厚(cm)                    „vÍc'¬§bbs.3c3t.comj”U6ˌ´#¼í
试样总重（g）    1                „vÍc'¬§bbs.3c3t.comj”U6ˌ´#¼í
灌前（筒+砂）重(g)    2                „vÍc'¬§bbs.3c3t.comj”U6ˌ´#¼í
灌后（筒+砂）重(g)    3                „vÍc'¬§bbs.3c3t.comj”U6ˌ´#¼í
圆锥体内用砂标定    灌前（筒+砂）重(g)    4                „vÍc'¬§bbs.3c3t.comj”U6ˌ´#¼í
    灌后（筒+砂）重(g)    5                „vÍc'¬§bbs.3c3t.comj”U6ˌ´#¼í
    圆锥体内„vÍc'¬§bbs.3c3t.comj”U6ˌ´#¼í
用砂质量(g)    6                „vÍc'¬§bbs.3c3t.comj”U6ˌ´#¼í
坑体砂重（g）    7                „vÍc'¬§bbs.3c3t.comj”U6ˌ´#¼í
标准砂密度(g/cm3)    8                „vÍc'¬§bbs.3c3t.comj”U6ˌ´#¼í
坑体体积（cm3）    9                „vÍc'¬§bbs.3c3t.comj”U6ˌ´#¼í
湿密度（g/cm3）    10                „vÍc'¬§bbs.3c3t.comj”U6ˌ´#¼í
盒  号    11                                    „vÍc'¬§bbs.3c3t.comj”U6ˌ´#¼í
盒+湿料重（g）    12                                    „vÍc'¬§bbs.3c3t.comj”U6ˌ´#¼í
盒+干料重（g）    13                                    „vÍc'¬§bbs.3c3t.comj”U6ˌ´#¼í
水重（g）    14                                    „vÍc'¬§bbs.3c3t.comj”U6ˌ´#¼í
盒重（g）    15                                    „vÍc'¬§bbs.3c3t.comj”U6ˌ´#¼í
干料重（g）    16                                    „vÍc'¬§bbs.3c3t.comj”U6ˌ´#¼í
含水率（%）    17    18                                „vÍc'¬§bbs.3c3t.comj”U6ˌ´#¼í
平均含水率（%）    19                „vÍc'¬§bbs.3c3t.comj”U6ˌ´#¼í
干密度（g/cm3）    20                „vÍc'¬§bbs.3c3t.comj”U6ˌ´#¼í
压实度（%）    21                „vÍc'¬§bbs.3c3t.comj”U6ˌ´#¼í
结„vÍc'¬§bbs.3c3t.comj”U6ˌ´#¼í
论    „vÍc'¬§bbs.3c3t.comj”U6ˌ´#¼í
1.2.3.4.5.11.12.13.15 是现场实测数量    „vÍc'¬§bbs.3c3t.comj”U6ˌ´#¼í
6=4-5„vÍc'¬§bbs.3c3t.comj”U6ˌ´#¼í
7=2-3-6„vÍc'¬§bbs.3c3t.comj”U6ˌ´#¼í
8.最大干密度、最佳含水率是实验室做出来的„vÍc'¬§bbs.3c3t.comj”U6ˌ´#¼í
9=7/8„vÍc'¬§bbs.3c3t.comj”U6ˌ´#¼í
10=1/9„vÍc'¬§bbs.3c3t.comj”U6ˌ´#¼í
14=12-13„vÍc'¬§bbs.3c3t.comj”U6ˌ´#¼í
16=13-15„vÍc'¬§bbs.3c3t.comj”U6ˌ´#¼í
17=（12-13）/（13-15）*100„vÍc'¬§bbs.3c3t.comj”U6ˌ´#¼í
18是含水率侧两次„vÍc'¬§bbs.3c3t.comj”U6ˌ´#¼í
20=10/（1.00+19）„vÍc'¬§bbs.3c3t.comj”U6ˌ´#¼í
21=20/最大干密度*100„vÍc'¬§bbs.3c3t.comj”U6ˌ´#¼í