某住宅钻孔桩自动计算表格.xlsVIP

Sheet3 Sheet2 Sheet1 R=Qa=Qu/K 规范经验参数法 Quk=Qsk+Qpk=u∑qsikLi+qpkAp 土 层 桩 径 D= qpk(Kpa) qsik(Kpa) u(m)= Ap(㎡)= u∑qsikL= qpkAp= Quk= KN m ㎡ 该土层桩长 桩端土层 γs=γp= R=Quk/γsp= 预制桩、钢管桩 沉管灌注桩 γs=γp 桩 型 桩 基 设 计 1 层 号 土层名称 压缩模量Es(Mpa) 阻力土层厚度(m) 桩 径(m) Rd = Rsk/γs+Rpk/γp = UpΣfsiLi/γs+fpAp/γp 重度(KN/m3) γs 桩 长(m) qpk(Kpa) Fsk=UpΣfsiLi(KN) Quk(KN) Rd(KN) γp u(m)= Ap(㎡)= 2-1 重粉质粘土 粉质粘土 2-2 3-1 3-2 3-3 粉质粘土夹砂 4 残积土 5-1 强风化泥质粉砂岩 Fpk(KN) C52 J88 C53 J94 C59 J95 C15 J18 C19 J22 J12 C29 C13 C11 C30 J14 耕表土 粉质粘土 中粗砂 淤泥质土 细粉砂 全风化 强风化 ZJ1 ZJ2-1000 ZJ2-800 ZJ2-1200 3.10 17.80 40.00 1500.00 .30 1.20 .80 1.00 1.00 .70 9.98 19.40 22.00 2500.00 11.40 11.30 13.60 10.20 12.40 13.40 3.10 17.80 55.00 1500.00 .00 .30 .20 .80 .00 .00 2.23 17.10 82.00 2000.00 .00 .00 .00 .00 .00 .00 3.49 17.90 85.00 2500.00 .00 .00 .00 .80 1.00 .20 4.27 18.00 84.00 2500.00 .40 .40 .00 .00 .00 .00 7.84 20.20 85.00 2500.00 1.00 .50 .50 .50 .50 .50 13.10 13.70 15.10 13.30 14.90 14.80 .40 .40 .40 .40 .40 .40 2900.00 2900.00 3000.00 2850.00 2950.00 2950.00 364.43 364.43 376.99 358.14 370.71 370.71 479.28 489.08 483.43 526.41 553.30 480.41 843.71 853.51 860.42 884.55 924.01 851.12 527.32 533.44 537.76 552.84 577.50 531.95 1.60 1.60 1.60 1.60 1.60 1.60 1.60 1.60 1.60 1.60 1.60 1.60 1.26 1.26 1.26 1.26 1.26 1.26 .13 .13 .13 .13 .13 .13 3.10 17.80 20.00 100.00 .30 .30 .30 .30 1.50 1.70 1.50 1.90 1.70 1.00 2.00 1.90 1.60 1.70 9.98 19.40 25.00 100.00 9.10 10.00 10.00 10.00 6.00 7.60 7.80 8.50 2.50 4.00 3.80 2.70 3.70 4.80 3.10 17.80 25.00 100.00 9.50 .00 .00 .00 .00 3.40 4.20 2.60 .90 .00 .00 .00 .00 .00 2.23 17.10 10.00 100.00 1.30 .00 .00 .00 4.77 .00 .00 .00 6.60 6.51 6.48 7.51 6.75 5.50 3.49 17.90 10.00 100.00 1.70 10.90 10.90 10.90 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 4.27 18.00 40.00 200.00 .50 .50 .50 .50 .00 .00 7.84 20.20 60.00 800.00 2.00 2.00 2.00 2.