压实度自动计算表格(1)

1、按F9自动计算数据联密码11（2）密码12注：1（2）表内更改盒质量，根据实际填写盒质量，其余数据无需修改1（3）密码123注：1（3）表内更改盒数量，根据表1(2)实际盒数量填写最大盒数量，其余数据无需修改注：1（3)为盒号不重复公式，如果不要增加盒号，请不要进行更改* 数据联内更改数据在右侧，请自已拖到右侧查看，然后根据实际需要进行更改修改密码步骤：点击工具、再点击保护，然后撤消工作表保护，修改原始参数后为保证工作表不变更，最好保护工作表注：1（2）表内更改盒质量，根据实际填写盒质量，其余数据无需修改注：1（3）表内更改盒数量，根据表1(2)实际盒数量填写最大盒数量，其余数据无需修改灌灌砂

2、砂法法压压实实度度检检测测记记录录表表施检表（21）编号：第页共页项目名称成安渝高速公路四川段施工单位中交第二航务工程局有限公司合 同 段III检测范围试验单位成安渝高速公路四川段第III合同段工地试验室检测日期最大干密度(g/cm3)2.09最佳含水率(%)8.9标准砂密度(g/cm3)1.35规定值(%)93层 次第1层试验桩号横向位置左14右3右3左5右16右14左4左4左5压实层厚度(cm)灌砂前筒+砂重(g)850085008500850085008500850085008500灌砂后筒+砂重(g)380537363738372538033707379636843761粗造面圆锥体内

3、砂重g）灌砂前筒+砂重(g)850085008500850085008500850085008500灌砂后筒+砂重(g)772577437734774877277711773877267721圆锥体砂重(g)775757766752773789762774779灌入试坑砂重(g)392040073996402339244004394240423960试坑内湿土重(g)614162996214644062346318626363596156湿密度(g/cm3)2.112.122.102.162.142.132.142.122.10盒号2622808733283578298927144884884

4、06413盒重(g)230.75 232.31 232.86 228.67 215.26 241.16 225.18 227.21 218.59 229.91 230.28 235.57 232.75 217.83 232.75 230.86 232.45 237.56盒+湿土重(g)751.41741.13749.02719.38718.73758.73766.67740.16720.94772.41772.89744.13742.24727.65744.85765.20755.76727.20盒+干土重(g)713.74704.75706.84682.61684.48721.28722.4

5、2697.81680.31729.45729.00702.57702.76692.08707.80727.00718.35693.89水重(g)37.6736.3842.1836.7734.2537.4544.2542.3540.6342.9643.8941.5639.4835.5737.0538.2037.4133.31干土重(g)482.99472.44473.98453.94469.22480.12497.24470.60461.72499.54498.72467.00470.01474.25475.05496.14485.90456.33含水率(%)7.87.78.98.17.37.8

6、8.99.08.88.68.88.98.47.57.87.77.77.3平均含水率(%)7.88.57.69.08.78.88.07.87.5干密度(g/cm3)1.961.951.951.981.971.961.981.971.95打印否压实度(%)93.893.393.394.794.393.894.794.393.3自检意见监理意见检 测复 核试验负责人日 期此行数据不大于1%-0.1-0.80.50.1-0.20.1-0.9-0.1-0.4灌灌砂砂法法压压实实度度检检测测记记录录表表施检表（21）编号：第页共页项目名称成安渝高速公路四川段施工单位中交第二航务工程局有限公司合 同 段II

7、I检测范围试验单位成安渝高速公路四川段第III合同段工地试验室检测日期最大干密度(g/cm3)2.09最佳含水率(%)8.9标准砂密度(g/cm3)1.35规定值(%)93层 次第1层试验桩号横向位置FALSEFALSEFALSEFALSEFALSEFALSEFALSEFALSEFALSE压实层厚度(cm)灌砂前筒+砂重(g)850085008500850085008500850085008500灌砂后筒+砂重(g)376437773776371237003784378537693728粗造面圆锥体内砂重g）灌砂前筒+砂重(g)850085008500850085008500850085008

8、500灌砂后筒+砂重(g)774277387725774277157711773177187710圆锥体砂重(g)758762775758785789769782790灌入试坑砂重(g)397839613949403040153927394639493983试坑内湿土重(g)628661246183628762676225615962286244湿密度(g/cm3)2.132.092.112.112.112.142.112.132.12盒号96621638101781125439730725865638636盒重(g)230.65 232.36 231.65 225.21 227.18 233

9、.75 227.34 225.76 219.21 228.25 233.75232.1228.52 225.85 226.21 228.61 235.62 226.76盒+湿土重(g)726.87756.35740.85738.38763.37772.28751.49737.79730.64751.26772.15731.90755.20748.29748.75744.84750.07733.10盒+干土重(g)687.15715.30707.98706.61723.19728.72716.29702.07691.88713.42731.35690.21716.64712.29708.2670

10、8.38716.41701.31水重(g)39.7241.0532.8731.7740.1843.5635.2035.7238.7637.8440.8041.6938.5636.0040.4936.4633.6631.79干土重(g)456.50482.94476.33481.40496.01494.97488.95476.31472.67485.17497.60458.11488.12486.44482.05479.77480.79474.55含水率(%)8.78.56.96.68.18.87.27.58.27.88.29.17.97.48.47.67.06.7平均含水率(%)8.66.88

11、.47.48.08.67.68.06.8干密度(g/cm3)1.961.961.951.961.951.971.961.971.99打印否压实度(%)93.893.893.393.893.394.393.894.395.2自检意见监理意见检 测复 核试验负责人日 期此行数据不大于1%-0.2-0.30.70.3-0.40.9-0.5-0.8-0.3灌灌砂砂法法压压实实度度检检测测记记录录表表施检表（21）编号：第页共页项目名称成安渝高速公路四川段施工单位中交第二航务工程局有限公司合 同 段III检测范围K171+416K171+664试验单位成安渝高速公路四川段第III合同段工地试验室检测日期

12、最大干密度(g/cm3)2.09最佳含水率(%)8.9标准砂密度(g/cm3)1.35规定值(%)93层 次第1层试验桩号横向位置FALSEFALSEFALSEFALSEFALSEFALSEFALSEFALSEFALSE压实层厚度(cm)灌砂前筒+砂重(g)850085008500850085008500850085008500灌砂后筒+砂重(g)373537023805378337983731381838013755粗造面圆锥体内砂重g）灌砂前筒+砂重(g)850085008500850085008500850085008500灌砂后筒+砂重(g)7746771377297747771677

13、13773877247725圆锥体砂重(g)754787771753784787762776775灌入试坑砂重(g)401140113924396439183983392039233970试坑内湿土重(g)639564066285631461796200616761426264湿密度(g/cm3)2.152.162.162.152.132.102.122.112.13盒号41698531738762192594566777570563920盒重(g)229.35 228.59 219.41 223.71 223.26 231.75 226.76231.2224.76 223.71 219.27

14、 229.75 222.82 225.98 232.19 232.65 231.81 228.19盒+湿土重(g)738.58719.79734.22731.07759.00771.88725.94719.54737.65733.03753.16742.83743.50719.58740.24719.93731.49752.10盒+干土重(g)696.96681.31693.45690.89716.12727.28687.68682.11697.91697.06715.91703.07703.60684.72701.74687.20698.36716.91水重(g)41.6238.4840.7

15、740.1842.8844.6038.2637.4339.7435.9737.2539.7639.9034.8638.5032.7333.1335.19干土重(g)467.61452.72474.04467.18492.86495.53460.92450.91473.15473.35496.64473.32480.78458.74469.55454.55466.55488.72含水率(%)8.98.58.68.68.79.08.38.38.47.67.58.48.37.68.27.27.17.2平均含水率(%)8.78.68.88.38.08.08.07.77.2干密度(g/cm3)1.981

16、.991.991.991.971.941.961.961.99打印否压实度(%)94.795.295.295.294.392.893.893.895.2自检意见监理意见检 测复 核试验负责人日 期此行数据不大于1%-0.40.00.30.0-0.80.9-0.7-1.00.1灌灌砂砂法法压压实实度度检检测测记记录录表表施检表（21）编号：第页共页项目名称成安渝高速公路四川段施工单位中交第二航务工程局有限公司合 同 段III检测范围试验单位成安渝高速公路四川段第III合同段工地试验室检测日期最大干密度(g/cm3)2.09最佳含水率(%)8.9标准砂密度(g/cm3)1.35规定值(%)93层

17、次第1层试验桩号横向位置FALSEFALSEFALSEFALSEFALSEFALSEFALSEFALSEFALSE压实层厚度(cm)灌砂前筒+砂重(g)850085008500850085008500850085008500灌砂后筒+砂重(g)382738103795372237833746374137463697粗造面圆锥体内砂重g）灌砂前筒+砂重(g)850085008500850085008500850085008500灌砂后筒+砂重(g)774277447718773377267743772377377719圆锥体砂重(g)758756782767774757777763781灌入试坑

18、砂重(g)391539343923401139433997398339914022试坑内湿土重(g)603361186173628761386273620762686245湿密度(g/cm3)2.082.102.122.122.102.122.102.122.10盒号5415372415047100235590836791332994盒重(g)235.67 230.28 221.82 242.45 229.34 227.38 227.67 228.89 229.61 230.68 227.28 228.88 228.28 227.55 228.28 227.22 219.91 235.47盒+

19、湿土重(g)738.86720.10733.99724.28746.67724.75761.18746.37752.34717.34760.61763.90744.84714.12722.03710.62744.41768.79盒+干土重(g)705.94688.48699.59694.45707.46683.26726.74711.16718.14689.36726.19727.97711.05686.15681.68677.73709.18733.43水重(g)32.9231.6234.4029.8339.2141.4934.4435.2134.2027.9834.4235.9333.79

20、27.9740.3532.8935.2335.36干土重(g)470.27458.20477.77452.00478.12455.88499.07482.27488.53458.68498.91499.09482.77458.60453.40450.51489.27497.96含水率(%)7.06.97.26.68.29.16.97.37.06.16.97.27.06.18.97.37.27.1平均含水率(%)7.06.98.67.16.67.06.68.17.2干密度(g/cm3)1.941.961.951.981.971.981.971.961.96打印否压实度(%)92.893.893.

21、394.794.394.794.393.893.8自检意见监理意见检 测复 核试验负责人日 期此行数据不大于1%-0.1-0.60.90.4-0.90.3-0.9-1.6-0.1灌灌砂砂法法压压实实度度检检测测记记录录表表施检表（21）编号：第页共页项目名称成安渝高速公路四川段施工单位中交第二航务工程局有限公司合 同 段III检测范围试验单位成安渝高速公路四川段第III合同段工地试验室检测日期最大干密度(g/cm3)2.09最佳含水率(%)8.9标准砂密度(g/cm3)1.35规定值(%)93层 次第1层试验桩号横向位置FALSEFALSEFALSEFALSEFALSEFALSEFALSEFA

22、LSEFALSE压实层厚度(cm)灌砂前筒+砂重(g)850085008500850085008500850085008500灌砂后筒+砂重(g)380137953783378237183808379237163798粗造面圆锥体内砂重g）灌砂前筒+砂重(g)850085008500850085008500850085008500灌砂后筒+砂重(g)773277227741772177347724774577207725圆锥体砂重(g)768778759779766776755780775灌入试坑砂重(g)393139273958393940163916395340043927试坑内湿土重(g

23、)623261416328623862446220618663286215湿密度(g/cm3)2.142.112.162.142.102.142.112.132.14盒号427119649614460257189974516825954盒重(g)229.2223.91 223.91 235.52 219.81 231.54 217.56 228.39 229.17 232.75 221.85 222.61 219.95 227.55 241.66 224.21 230.68217.5盒+湿土重(g)733.00734.71716.74733.41760.11759.03745.29755.69

24、744.54760.76750.72723.95704.84720.10734.29754.91769.56734.82盒+干土重(g)694.39697.31684.93701.71716.87715.92708.47714.83707.25726.68711.09685.96673.12690.04694.03718.80727.34698.73水重(g)38.6137.4031.8131.7043.2443.1136.8240.8637.2934.0839.6337.9931.7230.0640.2636.1142.2236.09干土重(g)465.19473.40461.02466.1

25、9497.06484.38490.91486.44478.08493.93489.24463.35453.17462.49452.37494.59496.66481.23含水率(%)8.37.96.96.88.78.97.58.47.86.98.18.27.06.58.97.38.57.5平均含水率(%)8.16.88.88.07.48.26.88.18.0干密度(g/cm3)1.981.981.991.981.961.981.981.971.98打印否压实度(%)94.794.795.294.793.894.794.794.394.7自检意见监理意见检 测复 核试验负责人日 期此行数据不大于

26、1%-0.4-0.10.20.9-0.90.1-0.5-1.6-1.0灌灌砂砂法法压压实实度度检检测测记记录录表表施检表（21）编号：第页共页项目名称成安渝高速公路四川段施工单位中交第二航务工程局有限公司合 同 段III检测范围试验单位成安渝高速公路四川段第III合同段工地试验室检测日期最大干密度(g/cm3)2.09最佳含水率(%)8.9标准砂密度(g/cm3)1.35规定值(%)93层 次第1层试验桩号横向位置FALSEFALSEFALSEFALSEFALSEFALSEFALSEFALSEFALSE压实层厚度(cm)灌砂前筒+砂重(g)850085008500850085008500850

27、085008500灌砂后筒+砂重(g)376437993718378437293730375737193761粗造面圆锥体内砂重g）灌砂前筒+砂重(g)850085008500850085008500850085008500灌砂后筒+砂重(g)771477487713773477097745773477127738圆锥体砂重(g)786752787766791755766788762灌入试坑砂重(g)395039493995395039804015397739933977试坑内湿土重(g)610361606275629462446245617862206311湿密度(g/cm3)2.092.1

28、12.122.152.122.102.102.102.14盒号9853118252463479793盒重(g)222.85 236.56 227.45 229.17 225.66 234.52 219.25 230.81 227.67 236.56 # # # # # # # #盒+湿土重(g)755.77723.63718.72756.51728.80722.74738.63745.11735.09727.45#VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE!盒+干土重(g)719.98693.90680.23719

29、.26691.10685.32697.94704.82701.01698.79#VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE!水重(g)35.7929.7338.4937.2537.7037.4240.6940.2934.0828.6631.1838.1734.8232.0131.8236.4642.7235.20干土重(g)497.13457.34452.78490.09465.44450.80478.69474.01473.34462.23451.92489.32464.25457.26454.58486.194

30、85.40495.81含水率(%)7.26.58.57.68.18.38.58.57.26.26.97.87.57.07.07.58.87.1平均含水率(%)6.88.08.28.56.77.47.27.28.0干密度(g/cm3)1.961.951.961.981.991.961.961.961.98打印否压实度(%)93.893.393.894.795.293.893.893.894.7自检意见监理意见检 测复 核试验负责人日 期此行数据不大于1%-0.7-0.90.20.0-1.00.9-0.50.5-1.7试坑半径设定圆锥体砂重751选定试坑体积2900试坑深度随机数2试坑体积随机数1

31、随机数1随机数2随机数2随机数1干土重450随机数2压实度调整范围（不宜少于）0.4随机数1随机数2随机数1随机数2随机数1随机数1随机数1随机数1随机数2随机数2随机数1随机数2随机数2随机数2注：TRUETRUE可以打印FALSE有错误注：TRUETRUE可以打印FALSE有错误注：FALSETRUE可以打印FALSE有错误注：FALSETRUE可以打印FALSE有错误注：TRUETRUE可以打印FALSE有错误注：TRUETRUE可以打印FALSE有错误7.53.141516.52916设路基宽33.5左143右3516144651013156141229.342229.173228.2

32、84217.55219.216235.527227.678231.759219.91123456789101112131415161710227.1811227.4569137214146100142384864337297892112225.7669137214156100152384864337297892113237.5669137214156100162384864337297892114235.5715230.2816231.6517233.7518221.8519223.9120228.1921231.222232.3123229.6124242.4525224.2126230.7

33、527230.2828241.1629218.5930232.131223.7132227.2233215.2634219.2535225.1836226.7637221.8238225.2139231.8140230.8641229.3542229.243228.2544217.5645219.2746234.5247227.6748232.7549219.8150227.3851227.5552225.6653236.5654235.6755230.6856232.6557232.7558225.8559223.7160228.3961231.5462232.3663228.6164232

34、.4565226.2166229.7567228.2868241.6669228.5970232.1971223.9172228.5273223.2674219.9575225.9876226.7677222.8278227.2179230.8180232.8681227.3482229.1783228.8884217.8385219.4186235.6287228.6788232.7589229.9190227.2891227.5592224.7693236.5694235.4795230.6896230.6597233.7598222.8599222.61100228.8918575757

35、最小盒号1总盒数量 100123456789101112131415161718192021222324252627282930310.8 0.870.250.140.75 0.8 0.7 0.280.790.12 0.8 0.910.610.180.130.650.390.920.030.420.910.660.94 0.9 0.230.930.970.630.030.770.3126228087332835782989271448848840641396621638101781125439730721234567891011121314151617181920212223242526272

36、829303112345678910111213141516171819202122232425262728293031盒号26228087332835782989271448848840641396621638101781125439730723233343536373839404142434445464748495051525354555657585960616263640.490.380.420.150.680.650.330.170.770.310.950.280.880.080.480.610.380.280.280.32 0.5 0.660.880.520.910.680.8410.570.610.010.85 0.55865638636416985317387621925945667775705639205415372415047100235532333435363738394041424344454647484950515253545556575859606162636432333435363738394041424344