excel做的建筑实用程序-单桩承载力计算.xls

《excel做的建筑实用程序-单桩承载力计算.xls》由会员分享，可在线阅读，更多相关《excel做的建筑实用程序-单桩承载力计算.xls（3页珍藏版）》请在淘文阁 - 分享文档赚钱的网站上搜索。

1、单桩承载力计算 3号楼C3号孔:已知:桩长34.5 m混凝土:C3015桩径0.55 m桩顶绝对标高1.62桩顶相对标高-3.33桩截面面积:0.237659桩周长1.727825土层分布:土层土层厚度(m)土层重度 压缩模量 fs(KPa)fp(KPa)桩摩阻力 桩端阻力100150.002.10.8118.84.131520.992.20.717.52.381518.1431.617.93.251541.4731.11910.85153.92032.81910.8535169.33031.817.73.042062.200.0049.2171.9520317.920.005.116.491

2、8.65404001139.6795.065.3018.97.5456000.00 142.6034.5单桩承载力摩阻力Rsk1773.65单桩承载力端阻力Rpk95.06端阻比0.051端阻比p0.050.10.051p1.021.051.021s1.641.71.641抗震时 Rsk rs rRe Rpk rp单桩承载力设计值单桩承载力设计值1773.651.6410.8 95.063411.021 1173.95桩身结构强度计算单桩竖向承载力设计值:预制桩:(0.60.75)FcAp=2138.93 KN灌注桩:0.6FcAp=2138.93 KN取单桩承载力设计值:1173.95 KN

3、取1100 KN3号楼C3号孔:自然断面:3.44土号土层土层厚度(m)土层重度 压缩模量 fs(KPa)fp(KPa)1 杂填土1.50152.1褐黄色粉质粘土1.118.84.13152.2褐黄色淤泥质粘土0.717.52.38153灰色淤泥质粘土1.617.93.25153灰色砂质粉质夹粘土3.91910.85153灰色淤泥质粘土1.817.73.04204灰色淤泥质粘土9.2171.95205.1 灰色粉质粘土19.318.65404005.3暗绿色粉质粘土12.618.97.5456008 黄色砂质粉土2018.36.50.050.10.150.20.250.30.350.40.451.021.051.081.121.181.241.31.411.51.641.71.751.791.821.831.81.761.69