人工挖孔桩桩基自动计算表格-建筑工程Excel计算工具

,,,,,,,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,,,,,,,

人工挖孔桩桩基计算书(JGJ94-2008)(G-05),,,,,,,,,,,,,,,,,,,,,,,,,,

桩基编号,桩身直径d(mm),扩底直径D(mm),嵌岩深径比hr/d,椭圆桩水平长度A(mm),岩石单轴抗压强度frk(Mpa),侧阻端阻综合系数ζr,侧阻端阻综合系数ζr修正系数,桩极限阻力,桩基承载力特征值(KN),回填土参数,,,负阻力下拉荷载,墙柱最大轴力标准值（KN),单桩竖向力标准值（KN),桩芯砼强度等级,成桩工艺系数,桩身承载力（KN),是否满足规范要求,,桩身配筋率(%),桩身纵筋直径,桩身纵筋根数,桩身纵筋间距(mm),手动桩身纵筋根数,手动桩身纵筋间距(mm)

,,,,,,,,ζrfrkAp(KN),,回填土厚（m）,极限侧阻力标准值（kpa）,负阻系数,(KN),,,,ψc,,,,,,,,,

ZH1,1000,1000,0.0,0,6.11,0.60,1.20,3455,1728,0.0,0,0.25,0,1605,1605,30,0.80,8985,是,,0.60,20,15.0,188,11,257

ZH2,1000,1300,0.0,0,6.11,0.60,1.20,5839,2920,0.0,0,0.25,0,2741,2741,30,0.80,8985,是,,0.60,20,15.0,188,11,257

ZH3,1000,1500,0.0,0,6.11,0.60,1.20,7774,3887,0.0,0,0.25,0,3837,3837,30,0.80,8985,是,,0.60,20,15.0,188,11,257

ZH4,1000,1700,0.0,0,6.11,0.60,1.20,9985,4993,0.0,0,0.25,0,4929,4929,30,0.80,8985,是,,0.60,20,15.0,188,11,257

ZH5,1000,1800,0.0,0,6.11,0.60,1.20,11195,5597,0.0,0,0.25,0,5447,5447,30,0.80,8985,是,,0.60,20,15.0,188,11,257

ZH6,1000,1900,0.0,0,6.11,0.60,1.20,12473,6236,0.0,0,0.25,0,5992,5992,30,0.80,8985,是,,0.60,20,15.0,188,11,257

ZH7,1000,2000,0.0,0,6.11,0.60,1.20,13820,6910,0.0,0,0.25,0,5992,6347,30,0.80,8985,是,,0.60,20,15.0,188,11,257

ZH8,1100,1700,0.0,0,6.11,0.60,1.20,9985,4993,0.0,0,0.25,0,4353,4353,30,0.80,10872,是,,0.60,22,15.0,209,11,286

ZH9,1100,2100,0.0,0,6.11,0.60,1.20,15237,7619,0.0,0,0.25,0,7356,7356,30,0.80,10872,是,,0.60,22,15.0,209,11,286

ZH10,1000,1600,0.0,350,6.11,0.60,1.20,11309,5654,0.0,0,0.25,0,4331,4331,30,0.80,12989,是,,0.60,22,17.9,197,11,321

ZH11,1000,1700,0.0,450,6.11,0.60,1.20,13351,6675,0.0,0,0.25,0,6525,6525,30,0.80,14133,是,,0.60,22,19.5,191,11,339

ZH12,1000,1800,0.0,450,6.11,0.60,1.20,14758,7379,0.0,0,0.25,0,6739,6739,30,0.80,14133,是,,0.60,22,19.5,191,11,339

ZH13,1000,1600,0.0,600,6.11,0.60,1.20,13068,6534,0.0,0,0.25,0,5697,5697,30,0.80,15849,是,,0.60,22,21.9,184,11,366

ZH14,1000,1600,0.0,1800,6.11,0.60,1.20,21515,10757,0.0,0,0.25,0,6101,6101,30,0.80,29577,是,,0.60,25,31.6,203,11,584

ZH8a,1100,1100,0.0,0,6.11,0.60,1.20,4181,2090,0.0,0,0.25,0,1800,1800,30,0.80,10872,是,,0.60,22,15.0,209,11,286

,,,,,,,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,,,,,,,

嵌岩段侧阻和端阻综合系数ζr,,,,,,,,,,,,,,,,,,,,,,,,,,

hr/d,0.0,0.5,1.0,1.5,2.0,2.5,3.0,3.5,4.0,4.5,5.0,6.0,7.0,8.0,,,,,,,,,,,,

30.00,0.45,0.65,0.81,0.86,0.90,0.95,1.00,1.02,1.04,1.04,1.04,1.04,1.04,1.04,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,,,,,,

15.00,0.60,0.80,0.95,1.07,1.18,1.27,1.35,1.42,1.48,1.53,1.57,1.63,1.66,1.70,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,,,,,,,

注：,1，本表根据桩基规范（JGJ94-2008)5.2.1、5.2.2、5.3.9、5.4.2、5.4.3条编制。,,,,,,,,,,,,,,,,,,,,,,,,,

,2，计算负阻力时回填土容重按18kN/m3取值。,,,,,,,,,,,,,,,,,,,,,,,,,

,"3,基桩成桩工艺系数ψc应按下列规定取值：",,,,,,,,,,,,,,,,,,,,,,,,,

,,1)混凝土预制桩、预应力混凝土空心桩：ψc=0.85；,,,,,,,,,,,,,,,,,,,,,,,,

,,2)干作业非挤土灌注桩：ψc=0.90；,,,,,,,,,,,,,,,,,,,,,,,,

,,3)泥浆护壁和套管护壁非挤土灌注桩、部分挤土灌注桩、挤土灌注桩：ψc=0.7~0.8,,,,,,,,,,,,,,,,,,,,,,,,

,,4)软土地区挤土灌注桩：ψc=0.6,,,,,,,,,,,,,,,,,,,,,,,,

,4，极限侧阻力标准值应根据地勘报告取值，若地勘报告没有，可按桩基规范表5.3.5－1取值,,,,,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,,,,,,,

,,,,,,