壓實(shí)度(灌砂法)自動計(jì)算表格

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

2、砂法法壓壓實(shí)實(shí)度度檢檢測測記記錄錄表表施檢表（21）編號：第頁共頁項(xiàng)目名稱施工單位合 同 段檢測范圍試驗(yàn)單位檢測日期最大干密度(g/cm3)2.2最佳含水率(%)6.1標(biāo)準(zhǔn)砂密度(g/cm3)1.432規(guī)定值(%)93層 次第1層試驗(yàn)樁號橫向位置右12左17左11右4左2左9左2右2左14壓實(shí)層厚度(cm)灌砂前筒+砂重(g)850085008500850085008500850085008500灌砂后筒+砂重(g)350335813520342435003480350034773531粗造面圓錐體內(nèi)砂重g）灌砂前筒+砂重(g)850085008500850085008500850085008

3、500灌砂后筒+砂重(g)774577377734770977207722774777407734圓錐體砂重(g)755763766791780778753760766灌入試坑砂重(g)424241564214428542204242424742634203試坑內(nèi)濕土重(g)661863536408661165016686661065986449濕密度(g/cm3)2.232.192.182.212.212.262.232.222.20盒號38074274368559602445534697467699盒重(g)228.28 232.86 219.95 230.28 228.25 241.66

4、 219.21 223.71 228.39 242.45217.5230.68 219.25 235.52 233.75 234.52 226.76 222.61盒+濕土重(g)745.71759.27704.65725.19708.56758.36732.90714.39711.98740.82711.39744.71699.16752.00745.88739.45745.35742.77盒+干土重(g)707.83723.91674.64691.52680.52732.35698.40684.44681.61713.50675.65705.75671.14718.21713.27705.1

5、0710.07711.48水重(g)37.8835.3630.0133.6728.0426.0134.5029.9530.3727.3235.7438.9628.0233.7932.6134.3535.2831.29干土重(g)479.55491.05454.69461.24452.27490.69479.19460.73453.22471.05458.15475.07451.89482.69479.52470.58483.31488.87含水率(%)7.97.26.67.36.25.37.26.56.75.87.88.26.27.06.87.37.36.4平均含水率(%)7.67.05.86

6、.86.28.06.67.06.8干密度(g/cm3)2.072.052.062.072.082.092.092.072.06打印否壓實(shí)度(%)94.193.293.694.194.595.095.094.193.6自檢意見監(jiān)理意見檢 測復(fù) 核試驗(yàn)負(fù)責(zé)人日 期此行數(shù)據(jù)不大于1%-0.70.7-0.9-0.7-0.90.40.80.5-0.9灌灌砂砂法法壓壓實(shí)實(shí)度度檢檢測測記記錄錄表表施檢表（21）編號：第頁共頁項(xiàng)目名稱施工單位合 同 段檢測范圍試驗(yàn)單位檢測日期最大干密度(g/cm3)2.2最佳含水率(%)6.1標(biāo)準(zhǔn)砂密度(g/cm3)1.432規(guī)定值(%)93層 次第1層試驗(yàn)樁號橫向位置FAL

7、SEFALSEFALSEFALSEFALSEFALSEFALSEFALSEFALSE壓實(shí)層厚度(cm)灌砂前筒+砂重(g)850085008500850085008500850085008500灌砂后筒+砂重(g)355934803467357535003483351534673452粗造面圓錐體內(nèi)砂重g）灌砂前筒+砂重(g)850085008500850085008500850085008500灌砂后筒+砂重(g)771977137739774277147743773177437721圓錐體砂重(g)781787761758786757769757779灌入試坑砂重(g)4160423342

8、72416742144260421642764269試坑內(nèi)濕土重(g)645165256517633364836658647265886659濕密度(g/cm3)2.222.212.182.182.202.242.202.212.23盒號917133522817891275848115571116372614盒重(g)227.55 223.91 215.26 225.66 241.16 233.75 229.91 225.76 225.98 217.83 227.34 230.28 232.75 227.45 231.65 221.82 230.75 235.57盒+濕土重(g)724.477

9、00.86741.32749.19751.43730.26724.95707.17762.44699.04736.11719.32733.20742.73750.36707.25766.74727.39盒+干土重(g)693.27674.29703.71711.31719.84701.27695.61680.35725.94669.67699.74681.01703.54710.83711.94673.80728.42696.94水重(g)31.2026.5737.6137.8831.5928.9929.3426.8236.5029.3736.3738.3129.6631.9038.4233.

10、4538.3230.45干土重(g)465.72450.38488.45485.65478.68467.52465.70454.59499.96451.84472.40450.73470.79483.38480.29451.98497.67461.37含水率(%)6.75.97.77.86.66.26.35.97.36.57.78.56.36.68.07.47.76.6平均含水率(%)6.37.86.46.16.98.16.47.77.2干密度(g/cm3)2.092.052.052.052.062.072.072.052.08打印否壓實(shí)度(%)95.093.293.293.293.694.1

11、94.193.294.5自檢意見監(jiān)理意見檢 測復(fù) 核試驗(yàn)負(fù)責(zé)人日 期此行數(shù)據(jù)不大于1%-0.80.1-0.4-0.4-0.80.80.3-0.6-1.1灌灌砂砂法法壓壓實(shí)實(shí)度度檢檢測測記記錄錄表表施檢表（21）編號：第頁共頁項(xiàng)目名稱施工單位合 同 段III檢測范圍試驗(yàn)單位檢測日期最大干密度(g/cm3)2.2最佳含水率(%)6.1標(biāo)準(zhǔn)砂密度(g/cm3)1.432規(guī)定值(%)93層 次第1層試驗(yàn)樁號橫向位置FALSEFALSEFALSEFALSEFALSEFALSEFALSEFALSEFALSE壓實(shí)層厚度(cm)灌砂前筒+砂重(g)8500850085008500850085008500850

12、08500灌砂后筒+砂重(g)350935253572352334303545352834733489粗造面圓錐體內(nèi)砂重g）灌砂前筒+砂重(g)850085008500850085008500850085008500灌砂后筒+砂重(g)771377397731772677157742772177297741圓錐體砂重(g)787761769774785758779771759灌入試坑砂重(g)420442144159420342854197419342564252試坑內(nèi)濕土重(g)640365466495655265286604655966156502濕密度(g/cm3)2.182.222.2

13、42.232.182.252.242.232.19盒號732209322399630101986931764425458盒重(g)223.26 229.17 228.19 236.56 232.31 231.81 230.65232.1227.18 223.91 231.75 228.59 223.71 227.67 232.45229.2235.67 225.85盒+濕土重(g)707.25756.13716.51751.12751.12739.36727.44734.36758.53709.36756.77741.73759.31730.19753.15753.33759.48746.30

14、盒+干土重(g)676.43725.83681.60710.81715.37706.60694.07703.26724.70682.31718.78704.16723.34695.13717.27719.04726.59714.08水重(g)30.8230.3034.9140.3135.7532.7633.3731.1033.8327.0537.9937.5735.9735.0635.8834.2932.8932.22干土重(g)453.17496.66453.41474.25483.06474.79463.42471.16497.52458.40487.03475.57499.63467.4

15、6484.82489.84490.92488.23含水率(%)6.86.17.78.57.46.97.26.66.85.97.87.97.27.57.47.06.76.6平均含水率(%)6.48.17.26.96.47.87.47.26.6干密度(g/cm3)2.052.052.092.092.052.092.092.082.05打印否壓實(shí)度(%)93.293.295.095.093.295.095.094.593.2自檢意見監(jiān)理意見檢 測復(fù) 核試驗(yàn)負(fù)責(zé)人日 期此行數(shù)據(jù)不大于1%-0.70.8-0.5-0.6-0.90.10.3-0.4-0.1灌灌砂砂法法壓壓實(shí)實(shí)度度檢檢測測記記錄錄表表施檢表

16、（21）編號：第頁共頁項(xiàng)目名稱施工單位合 同 段檢測范圍試驗(yàn)單位檢測日期最大干密度(g/cm3)2.2最佳含水率(%)6.1標(biāo)準(zhǔn)砂密度(g/cm3)1.432規(guī)定值(%)93層 次第1層試驗(yàn)樁號橫向位置FALSEFALSEFALSEFALSEFALSEFALSEFALSEFALSEFALSE壓實(shí)層厚度(cm)灌砂前筒+砂重(g)850085008500850085008500850085008500灌砂后筒+砂重(g)347435513564349934993547351135253567粗造面圓錐體內(nèi)砂重g）灌砂前筒+砂重(g)85008500850085008500850085008500

17、8500灌砂后筒+砂重(g)773177417728772277357717772377147744圓錐體砂重(g)769759772778765783777786756灌入試坑砂重(g)425741904164422342364170421241894177試坑內(nèi)濕土重(g)650065176396649365526509654764836407濕密度(g/cm3)2.192.232.202.202.222.242.232.222.20盒號833647407845829892672994417948621851盒重(g)228.88 226.76 227.67 230.86 227.21 2

18、19.27 229.17 222.85 224.76 228.28 218.59 235.47 229.35 230.81 232.75 232.36 221.85 227.55盒+濕土重(g)708.20715.40714.43749.55763.22706.23718.95747.24756.15758.96751.25743.30719.01713.15755.89718.42741.70726.51盒+干土重(g)679.79689.49679.21710.24725.36675.65684.36710.65718.16723.32711.34702.23687.83682.02719

19、.39686.62709.06693.43水重(g)28.4125.9135.2239.3137.8630.5834.5936.5937.9935.6439.9141.0731.1831.1336.5031.8032.6433.08干土重(g)450.91462.73451.54479.38498.15456.38455.19487.80493.40495.04492.75466.76458.48451.21486.64454.26487.21465.88含水率(%)6.35.67.88.27.66.77.67.57.77.28.18.86.86.97.57.06.77.1平均含水率(%)6.

20、08.07.27.67.48.46.87.26.9干密度(g/cm3)2.072.062.052.042.072.072.092.072.06打印否壓實(shí)度(%)94.193.693.292.794.194.195.094.193.6自檢意見監(jiān)理意見檢 測復(fù) 核試驗(yàn)負(fù)責(zé)人日 期此行數(shù)據(jù)不大于1%-0.70.4-0.9-0.1-0.50.70.1-0.50.4灌灌砂砂法法壓壓實(shí)實(shí)度度檢檢測測記記錄錄表表施檢表（21）編號：第頁共頁項(xiàng)目名稱施工單位合 同 段檢測范圍試驗(yàn)單位檢測日期最大干密度(g/cm3)2.2最佳含水率(%)6.1標(biāo)準(zhǔn)砂密度(g/cm3)1.432規(guī)定值(%)93層 次第1層試驗(yàn)樁

21、號橫向位置FALSEFALSEFALSEFALSEFALSEFALSEFALSEFALSEFALSE壓實(shí)層厚度(cm)灌砂前筒+砂重(g)850085008500850085008500850085008500灌砂后筒+砂重(g)342734993524351835583483345535433589粗造面圓錐體內(nèi)砂重g）灌砂前筒+砂重(g)850085008500850085008500850085008500灌砂后筒+砂重(g)772077157737771577147732773277147743圓錐體砂重(g)780785763785786768768786757灌入試坑砂重(g)42

22、9342164213419741564249427741714154試坑內(nèi)濕土重(g)663465476424646063956573661464856368濕密度(g/cm3)2.212.222.182.202.202.222.212.232.20盒號879586563238531002521136170903563150盒重(g)228.67 230.68 235.62 232.65 227.22 225.21 236.56 228.89 224.21231.2237.56 231.54 232.19 227.28 225.18 228.61 229.34 227.38盒+濕土重(g)72

23、8.85753.55761.29750.72712.84745.49725.30757.66752.07754.46752.68760.25765.45726.92719.47741.39754.96740.26盒+干土重(g)693.09720.26722.35708.82682.35712.82692.90724.92716.62722.99715.85721.54728.25690.34684.98708.29721.03708.96水重(g)35.7633.2938.9441.9030.4932.6732.4032.7435.4531.4736.8338.7137.2036.5834.

24、4933.1033.9331.30干土重(g)464.42489.58486.73476.17455.13487.61456.34496.03492.41491.79478.29490.00496.06463.06459.80479.68491.69481.58含水率(%)7.76.88.08.86.76.77.16.67.26.47.77.97.57.97.56.96.96.5平均含水率(%)7.28.46.76.86.87.87.77.26.7干密度(g/cm3)2.062.052.042.062.062.062.052.082.06打印否壓實(shí)度(%)93.693.292.793.693.

25、693.693.294.593.6自檢意見監(jiān)理意見檢 測復(fù) 核試驗(yàn)負(fù)責(zé)人日 期此行數(shù)據(jù)不大于1%-0.90.80.0-0.5-0.80.20.4-0.6-0.4灌灌砂砂法法壓壓實(shí)實(shí)度度檢檢測測記記錄錄表表施檢表（21）編號：第頁共頁項(xiàng)目名稱施工單位合 同 段檢測范圍試驗(yàn)單位檢測日期最大干密度(g/cm3)2.2最佳含水率(%)6.1標(biāo)準(zhǔn)砂密度(g/cm3)1.432規(guī)定值(%)93層 次第1層試驗(yàn)樁號橫向位置FALSEFALSEFALSEFALSEFALSEFALSEFALSEFALSEFALSE壓實(shí)層厚度(cm)灌砂前筒+砂重(g)850085008500850085008500850085

26、008500灌砂后筒+砂重(g)352434513467344034453420352135493545粗造面圓錐體內(nèi)砂重g）灌砂前筒+砂重(g)850085008500850085008500850085008500灌砂后筒+砂重(g)771577367710772377147713773577227711圓錐體砂重(g)785764790777786787765778789灌入試坑砂重(g)419142854243428342694293421441734166試坑內(nèi)濕土重(g)644665906588667866946666649965296428濕密度(g/cm3)2.202.202.

27、222.232.252.222.212.242.21盒號2385669778844724965盒重(g)229.61 219.41 229.75 219.91 222.82 232.75 217.56 228.52 219.81 226.21 # # # # # # # #盒+濕土重(g)754.52720.95720.15715.14710.62727.66726.12754.39751.70733.66#VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE!盒+干土重(g)716.99688.58687.21678.46

28、677.43694.42691.52722.29712.30696.94#VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE!水重(g)37.5332.3732.9436.6833.1933.2434.6032.1039.4036.7237.9036.5835.5137.9534.5735.4234.6530.44干土重(g)487.38469.17457.46458.55454.61461.67473.96493.77492.49470.73498.63451.62473.42457.20454.87478.59474.

29、66454.26含水率(%)7.76.97.28.07.37.27.36.58.07.87.68.17.58.37.67.47.36.7平均含水率(%)7.37.67.26.97.97.87.97.57.0干密度(g/cm3)2.052.042.072.092.092.062.052.082.07打印否壓實(shí)度(%)93.292.794.195.095.093.693.294.594.1自檢意見監(jiān)理意見檢 測復(fù) 核試驗(yàn)負(fù)責(zé)人日 期此行數(shù)據(jù)不大于1%-0.80.8-0.1-0.8-0.20.50.8-0.2-0.6試坑半徑設(shè)定圓錐體砂重751選定試坑體積2900試坑深度隨機(jī)數(shù)1試坑體積隨機(jī)數(shù)1隨機(jī)

30、數(shù)2隨機(jī)數(shù)1隨機(jī)數(shù)1隨機(jī)數(shù)2干土重450隨機(jī)數(shù)1壓實(shí)度調(diào)整范圍（不宜少于）0.4隨機(jī)數(shù)1隨機(jī)數(shù)2隨機(jī)數(shù)2隨機(jī)數(shù)1隨機(jī)數(shù)1隨機(jī)數(shù)2隨機(jī)數(shù)1隨機(jī)數(shù)2隨機(jī)數(shù)1隨機(jī)數(shù)2隨機(jī)數(shù)1隨機(jī)數(shù)1隨機(jī)數(shù)1隨機(jī)數(shù)2注：TRUETRUE可以打印FALSE有錯誤注：TRUETRUE可以打印FALSE有錯誤注：TRUETRUE可以打印FALSE有錯誤注：FALSETRUE可以打印FALSE有錯誤注：FALSETRUE可以打印FALSE有錯誤注：FALSETRUE可以打印FALSE有錯誤7.53.141516.52916設(shè)路基寬33.5左1211右174292101415177171229.342229.173228.28

31、4217.55219.216235.527227.678231.759219.91123456789101112131415161710227.1811227.454363397582043711558136298892286912225.764363397582044711558136298892286913237.564363397582044711558136298892286914235.5715230.2816231.6517233.7518221.8519223.9120228.1921231.222232.3123229.6124242.4525224.2126230.75272

32、30.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.456

33、5226.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.8918333最小盒號1總盒

34、數(shù)量 100123456789101112131415161718192021222324252627282930310.990.210.27 0.7 0.580.340.940.420.420.730.960.450.640.930.050.560.260.03 0.1 0.3 0.650.49 0.7 0.790.110.860.260.180.210.810.44380742743685596024455346974676999171335228178912758481155712345678910111213141516171819202122232425262728293031123

35、45678910111213141516171819202122232425262728293031盒號38074274368559602445534697467699917133522817891275848115573233343536373839404142434445464748495051525354555657585960616263640.89 0.8 0.630.710.820.280.990.780.090.760.610.060.670.910.780.920.340.660.920.370.590.470.430.190.630.550.610.240.560.190.04 0.1 0.351116372614732209322399630101986931764425458833647407845829892673233343536373839404142434445464748495051525354555657585960616263643233343536373839404142434445464748495051525354555657585960616