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

按F9自动计算数据联密码11（2）密码12注：1（2）表内更改盒质量，根据实际填写盒质量，其余数据无需修改1（3）密码123注：1（3）表内更改盒数量，根据表1(2)实际盒数量填写最大盒数量，其余数据无需修改注：1（3)为盒号不重复公式，如果不要增加盒号，请不要进行更改* 数据联内更改数据在右侧，请自已拖到右侧查看，然后根据实际需要进行更改修改密码步骤：点击工具、再点击保护，然后撤消工作表保护，修改原始参数后为保证工作表不变更，最好保护工作表注：1（2）表内更改盒质量，根据实际填写盒质量，其余数据无需修改注：1（3）表内更改盒数量，根据表1(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粗造面 圆锥体 内砂重 g）灌砂前筒+砂重(g)850085008500850085008500850085008500灌砂后筒+砂重(g)772577437734774877277711773877267721圆锥体砂重(g)775757766752773789762774779灌入试坑砂重(g)392040073996402339244004394240423960试坑内湿土重(g)614162996214644062346318626363596156湿密度(g/cm3)2.112.122.102.162.142.132.142.122.10盒号262280873328357829892714488488406413盒重(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.42697.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.88.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）编号：第页共页项目名称成安渝高速公路四川段施工单位中交第二航务工程局有限公司合 同 段III检测范围试验单位成安渝高速公路四川段第III合同段工地试验室检测日期最大干密度(g/cm3)2.09最佳含水率(%)8.9标准砂密度(g/cm3)1.35规定值(%)93层 次第1层试验桩号横向位置FALSEFALSEFALSEFALSEFALSEFALSEFALSEFALSEFALSE压实层厚度(cm)灌砂前筒+砂重(g)850085008500850085008500850085008500灌砂后筒+砂重(g)376437773776371237003784378537693728粗造面 圆锥体 内砂重 g）灌砂前筒+砂重(g)850085008500850085008500850085008500灌砂后筒+砂重(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.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.26708.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.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合同段工地试验室检测日期最大干密度(g/cm3)2.09最佳含水率(%)8.9标准砂密度(g/cm3)1.35规定值(%)93层 次第1层试验桩号横向位置FALSEFALSEFALSEFALSEFALSEFALSEFALSEFALSEFALSE压实层厚度(cm)灌砂前筒+砂重(g)850085008500850085008500850085008500灌砂后筒+砂重(g)373537023805378337983731381838013755粗造面 圆锥体 内砂重 g）灌砂前筒+砂重(g)850085008500850085008500850085008500灌砂后筒+砂重(g)774677137729774777167713773877247725圆锥体砂重(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 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.7740.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.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层 次第1层试验桩号横向位置FALSEFALSEFALSEFALSEFALSEFALSEFALSEFALSEFALSE压实层厚度(cm)灌砂前筒+砂重(g)850085008500850085008500850085008500灌砂后筒+砂重(g)382738103795372237833746374137463697粗造面 圆锥体 内砂重 g）灌砂前筒+砂重(g)850085008500850085008500850085008500灌砂后筒+砂重(g)774277447718773377267743772377377719圆锥体砂重(g)758756782767774757777763781灌入试坑砂重(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盒+湿土重(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.7927.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.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层试验桩号横向位置FALSEFALSEFALSEFALSEFALSEFALSEFALSEFALSEFALSE压实层厚度(cm)灌砂前筒+砂重(g)850085008500850085008500850085008500灌砂后筒+砂重(g)380137953783378237183808379237163798粗造面 圆锥体 内砂重 g）灌砂前筒+砂重(g)850085008500850085008500850085008500灌砂后筒+砂重(g)773277227741772177347724774577207725圆锥体砂重(g)768778759779766776755780775灌入试坑砂重(g)393139273958393940163916395340043927试坑内湿土重(g)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.69744.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.19497.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自检意见监理意见检 测复 核试验负责人日 期此行数据不大于±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)850085008500850085008500850085008500灌砂后筒+砂重(g)376437993718378437293730375737193761粗造面 圆锥体 内砂重 g）灌砂前筒+砂重(g)850085008500850085008500850085008500灌砂后筒+砂重(g)771477487713773477097745773477127738圆锥体砂重(g)786752787766791755766788762灌入试坑砂重(g)395039493995395039804015397739933977试坑内湿土重(g)610361606275629462446245617862206311湿密度(g/cm3)2.092.112.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.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.19485.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随机数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.5 3.1415 16.5 2916设路基宽33.5左143右3516144651013156141229.342229.173228.284217.55219.216235.527227.678231.759219.91123456789101112131415161710227.1811227.4569137214146100142384864337297892112225.7669137214156100152384864337297892113237.5669137214156100162384864337297892114235.5715230.2816231.6517233.7518221.8519223.9120228.1921231.222232.3123229.6124242.4525224.2126230.7527230.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.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.891857 57 57最小盒号1总盒数量 10012345678910111213141516171819202122232425262728293031 0.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.31 2622808733283578298927144884884064139662163810178112543973072 12345678910111213141516171819202122232425262728293031 12345678910111213141516171819202122232425262728293031盒号2622808733283578298927144884884064139662163810178112543973072323334353637383940414243444546474849505152535455565758596061626364 0.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.5 58656386364169853173876219259456677757056392054153724150471002355 323334353637383940414243444546474849505152535455565758596061626364 32333435363738394041424344454647484950515253545556575859606162636458656386364169853173876219259456677757056392054153724150471002355656667686970717273747576777879808182838485868788899091929394959697 0.09 0.2 0.380.080.980.760.940.040.630.310.890.960.590.430.620.480.98 0.5 0.9 0.02 0.3 0.560.340.810.030.980.020.540.940.220.540.61 0.7 9083679133299442711964961446025718997451682595498531182524634 656667686970717273747576777879808182838485868788899091929394959697 65666768697071727374757677787980818283848586878889909192939495969790836791332994427119649614460257189974516825954985311825246349899100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 0.280.950.05 79793 9899100 989910079793131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196197 198 199 200 201 202 203 204 205 206 207 208 209 210 211 212 213 214 215 216 217 218 219 220 221 222 223 224 225 226 227 228 229230 231 232 233 234 235 236 237 238 239 240 241 242 243 244 245 246 247 248 249 250 251 252 253 254 255