壓實(shí)度自動(dòng)計(jì)算表格(1)

1、按F9自動(dòng)計(jì)算數(shù)據(jù)聯(lián)密碼11（2）密碼12注：1（2）表內(nèi)更改盒質(zhì)量，根據(jù)實(shí)際填寫(xiě)盒質(zhì)量，其余數(shù)據(jù)無(wú)需修改1（3）密碼123注：1（3）表內(nèi)更改盒數(shù)量，根據(jù)表1(2)實(shí)際盒數(shù)量填寫(xiě)最大盒數(shù)量，其余數(shù)據(jù)無(wú)需修改注：1（3)為盒號(hào)不重復(fù)公式，如果不要增加盒號(hào)，請(qǐng)不要進(jìn)行更改* 數(shù)據(jù)聯(lián)內(nèi)更改數(shù)據(jù)在右側(cè)，請(qǐng)自已拖到右側(cè)查看，然后根據(jù)實(shí)際需要進(jìn)行更改修改密碼步驟：點(diǎn)擊工具、再點(diǎn)擊保護(hù)，然后撤消工作表保護(hù)，修改原始參數(shù)后為保證工作表不變更，最好保護(hù)工作表注：1（2）表內(nèi)更改盒質(zhì)量，根據(jù)實(shí)際填寫(xiě)盒質(zhì)量，其余數(shù)據(jù)無(wú)需修改注：1（3）表內(nèi)更改盒數(shù)量，根據(jù)表1(2)實(shí)際盒數(shù)量填寫(xiě)最大盒數(shù)量，其余數(shù)據(jù)無(wú)需修改灌灌砂

2、砂法法壓壓實(shí)實(shí)度度檢檢測(cè)測(cè)記記錄錄表表施檢表（21）編號(hào)：第頁(yè)共頁(yè)項(xiàng)目名稱成安渝高速公路四川段施工單位中交第二航務(wù)工程局有限公司合 同 段III檢測(cè)范圍試驗(yàn)單位成安渝高速公路四川段第III合同段工地試驗(yàn)室檢測(cè)日期最大干密度(g/cm3)2.09最佳含水率(%)8.9標(biāo)準(zhǔn)砂密度(g/cm3)1.35規(guī)定值(%)93層 次第1層試驗(yàn)樁號(hào)橫向位置左14右3右3左5右16右14左4左4左5壓實(shí)層厚度(cm)灌砂前筒+砂重(g)850085008500850085008500850085008500灌砂后筒+砂重(g)380537363738372538033707379636843761粗造面圓錐體內(nèi)

3、砂重g）灌砂前筒+砂重(g)850085008500850085008500850085008500灌砂后筒+砂重(g)772577437734774877277711773877267721圓錐體砂重(g)775757766752773789762774779灌入試坑砂重(g)392040073996402339244004394240423960試坑內(nèi)濕土重(g)614162996214644062346318626363596156濕密度(g/cm3)2.112.122.102.162.142.132.142.122.10盒號(hào)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打印否壓實(shí)度(%)93.893.393.394.794.393.894.794.393.3自檢意見(jiàn)監(jiān)理意見(jiàn)檢 測(cè)復(fù) 核試驗(yàn)負(fù)責(zé)人日 期此行數(shù)據(jù)不大于1%-0.1-0.80.50.1-0.20.1-0.9-0.1-0.4灌灌砂砂法法壓壓實(shí)實(shí)度度檢檢測(cè)測(cè)記記錄錄表表施檢表（21）編號(hào)：第頁(yè)共頁(yè)項(xiàng)目名稱成安渝高速公路四川段施工單位中交第二航務(wù)工程局有限公司合 同 段II

7、I檢測(cè)范圍試驗(yàn)單位成安渝高速公路四川段第III合同段工地試驗(yàn)室檢測(cè)日期最大干密度(g/cm3)2.09最佳含水率(%)8.9標(biāo)準(zhǔn)砂密度(g/cm3)1.35規(guī)定值(%)93層 次第1層試驗(yàn)樁號(hào)橫向位置FALSEFALSEFALSEFALSEFALSEFALSEFALSEFALSEFALSE壓實(shí)層厚度(cm)灌砂前筒+砂重(g)850085008500850085008500850085008500灌砂后筒+砂重(g)376437773776371237003784378537693728粗造面圓錐體內(nèi)砂重g）灌砂前筒+砂重(g)850085008500850085008500850085008

8、500灌砂后筒+砂重(g)774277387725774277157711773177187710圓錐體砂重(g)758762775758785789769782790灌入試坑砂重(g)397839613949403040153927394639493983試坑內(nèi)濕土重(g)628661246183628762676225615962286244濕密度(g/cm3)2.132.092.112.112.112.142.112.132.12盒號(hào)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打印否壓實(shí)度(%)93.893.893.393.893.394.393.894.395.2自檢意見(jiàn)監(jiān)理意見(jiàn)檢 測(cè)復(fù) 核試驗(yàn)負(fù)責(zé)人日 期此行數(shù)據(jù)不大于1%-0.2-0.30.70.3-0.40.9-0.5-0.8-0.3灌灌砂砂法法壓壓實(shí)實(shí)度度檢檢測(cè)測(cè)記記錄錄表表施檢表（21）編號(hào)：第頁(yè)共頁(yè)項(xiàng)目名稱成安渝高速公路四川段施工單位中交第二航務(wù)工程局有限公司合 同 段III檢測(cè)范圍K171+416K171+664試驗(yàn)單位成安渝高速公路四川段第III合同段工地試驗(yàn)室檢測(cè)日期

12、最大干密度(g/cm3)2.09最佳含水率(%)8.9標(biāo)準(zhǔn)砂密度(g/cm3)1.35規(guī)定值(%)93層 次第1層試驗(yàn)樁號(hào)橫向位置FALSEFALSEFALSEFALSEFALSEFALSEFALSEFALSEFALSE壓實(shí)層厚度(cm)灌砂前筒+砂重(g)850085008500850085008500850085008500灌砂后筒+砂重(g)373537023805378337983731381838013755粗造面圓錐體內(nèi)砂重g）灌砂前筒+砂重(g)850085008500850085008500850085008500灌砂后筒+砂重(g)7746771377297747771677

13、13773877247725圓錐體砂重(g)754787771753784787762776775灌入試坑砂重(g)401140113924396439183983392039233970試坑內(nèi)濕土重(g)639564066285631461796200616761426264濕密度(g/cm3)2.152.162.162.152.132.102.122.112.13盒號(hào)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打印否壓實(shí)度(%)94.795.295.295.294.392.893.893.895.2自檢意見(jiàn)監(jiān)理意見(jiàn)檢 測(cè)復(fù) 核試驗(yàn)負(fù)責(zé)人日 期此行數(shù)據(jù)不大于1%-0.40.00.30.0-0.80.9-0.7-1.00.1灌灌砂砂法法壓壓實(shí)實(shí)度度檢檢測(cè)測(cè)記記錄錄表表施檢表（21）編號(hào)：第頁(yè)共頁(yè)項(xiàng)目名稱成安渝高速公路四川段施工單位中交第二航務(wù)工程局有限公司合 同 段III檢測(cè)范圍試驗(yàn)單位成安渝高速公路四川段第III合同段工地試驗(yàn)室檢測(cè)日期最大干密度(g/cm3)2.09最佳含水率(%)8.9標(biāo)準(zhǔn)砂密度(g/cm3)1.35規(guī)定值(%)93層

17、次第1層試驗(yàn)樁號(hào)橫向位置FALSEFALSEFALSEFALSEFALSEFALSEFALSEFALSEFALSE壓實(shí)層厚度(cm)灌砂前筒+砂重(g)850085008500850085008500850085008500灌砂后筒+砂重(g)382738103795372237833746374137463697粗造面圓錐體內(nèi)砂重g）灌砂前筒+砂重(g)850085008500850085008500850085008500灌砂后筒+砂重(g)774277447718773377267743772377377719圓錐體砂重(g)758756782767774757777763781灌入試坑

18、砂重(g)391539343923401139433997398339914022試坑內(nèi)濕土重(g)603361186173628761386273620762686245濕密度(g/cm3)2.082.102.122.122.102.122.102.122.10盒號(hào)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打印否壓實(shí)度(%)92.893.893.

21、394.794.394.794.393.893.8自檢意見(jiàn)監(jiān)理意見(jiàn)檢 測(cè)復(fù) 核試驗(yàn)負(fù)責(zé)人日 期此行數(shù)據(jù)不大于1%-0.1-0.60.90.4-0.90.3-0.9-1.6-0.1灌灌砂砂法法壓壓實(shí)實(shí)度度檢檢測(cè)測(cè)記記錄錄表表施檢表（21）編號(hào)：第頁(yè)共頁(yè)項(xiàng)目名稱成安渝高速公路四川段施工單位中交第二航務(wù)工程局有限公司合 同 段III檢測(cè)范圍試驗(yàn)單位成安渝高速公路四川段第III合同段工地試驗(yàn)室檢測(cè)日期最大干密度(g/cm3)2.09最佳含水率(%)8.9標(biāo)準(zhǔn)砂密度(g/cm3)1.35規(guī)定值(%)93層 次第1層試驗(yàn)樁號(hào)橫向位置FALSEFALSEFALSEFALSEFALSEFALSEFALSEFA

22、LSEFALSE壓實(shí)層厚度(cm)灌砂前筒+砂重(g)850085008500850085008500850085008500灌砂后筒+砂重(g)380137953783378237183808379237163798粗造面圓錐體內(nèi)砂重g）灌砂前筒+砂重(g)850085008500850085008500850085008500灌砂后筒+砂重(g)773277227741772177347724774577207725圓錐體砂重(g)768778759779766776755780775灌入試坑砂重(g)393139273958393940163916395340043927試坑內(nèi)濕土重(g

23、)623261416328623862446220618663286215濕密度(g/cm3)2.142.112.162.142.102.142.112.132.14盒號(hào)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打印否壓實(shí)度(%)94.794.795.294.793.894.794.794.394.7自檢意見(jiàn)監(jiān)理意見(jiàn)檢 測(cè)復(fù) 核試驗(yàn)負(fù)責(zé)人日 期此行數(shù)據(jù)不大于

26、1%-0.4-0.10.20.9-0.90.1-0.5-1.6-1.0灌灌砂砂法法壓壓實(shí)實(shí)度度檢檢測(cè)測(cè)記記錄錄表表施檢表（21）編號(hào)：第頁(yè)共頁(yè)項(xiàng)目名稱成安渝高速公路四川段施工單位中交第二航務(wù)工程局有限公司合 同 段III檢測(cè)范圍試驗(yàn)單位成安渝高速公路四川段第III合同段工地試驗(yàn)室檢測(cè)日期最大干密度(g/cm3)2.09最佳含水率(%)8.9標(biāo)準(zhǔn)砂密度(g/cm3)1.35規(guī)定值(%)93層 次第1層試驗(yàn)樁號(hào)橫向位置FALSEFALSEFALSEFALSEFALSEFALSEFALSEFALSEFALSE壓實(shí)層厚度(cm)灌砂前筒+砂重(g)850085008500850085008500850

27、085008500灌砂后筒+砂重(g)376437993718378437293730375737193761粗造面圓錐體內(nèi)砂重g）灌砂前筒+砂重(g)850085008500850085008500850085008500灌砂后筒+砂重(g)771477487713773477097745773477127738圓錐體砂重(g)786752787766791755766788762灌入試坑砂重(g)395039493995395039804015397739933977試坑內(nèi)濕土重(g)610361606275629462446245617862206311濕密度(g/cm3)2.092.1

28、12.122.152.122.102.102.102.14盒號(hào)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打印否壓實(shí)度(%)93.893.393.894.795.293.893.893.894.7自檢意見(jiàn)監(jiān)理意見(jiàn)檢 測(cè)復(fù) 核試驗(yàn)負(fù)責(zé)人日 期此行數(shù)據(jù)不大于1%-0.7-0.90.20.0-1.00.9-0.50.5-1.7試坑半徑設(shè)定圓錐體砂重751選定試坑體積2900試坑深度隨機(jī)數(shù)2試坑體積隨機(jī)數(shù)1

31、隨機(jī)數(shù)1隨機(jī)數(shù)2隨機(jī)數(shù)2隨機(jī)數(shù)1干土重450隨機(jī)數(shù)2壓實(shí)度調(diào)整范圍（不宜少于）0.4隨機(jī)數(shù)1隨機(jī)數(shù)2隨機(jī)數(shù)1隨機(jī)數(shù)2隨機(jī)數(shù)1隨機(jī)數(shù)1隨機(jī)數(shù)1隨機(jī)數(shù)1隨機(jī)數(shù)2隨機(jī)數(shù)2隨機(jī)數(shù)1隨機(jī)數(shù)2隨機(jī)數(shù)2隨機(jī)數(shù)2注：TRUETRUE可以打印FALSE有錯(cuò)誤注：TRUETRUE可以打印FALSE有錯(cuò)誤注：FALSETRUE可以打印FALSE有錯(cuò)誤注：FALSETRUE可以打印FALSE有錯(cuò)誤注：TRUETRUE可以打印FALSE有錯(cuò)誤注：TRUETRUE可以打印FALSE有錯(cuò)誤7.53.141516.52916設(shè)路基寬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、最小盒號(hào)1總盒數(shù)量 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盒號(hào)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