CFG桩计算(excel编写)

BK31孔口高程31.31桩径桩底面积桩身强度折减系数Ra2标高(m)(mm)（mm)标高(m)(m)d(mm)Ap(mm2)Fcu(Mpa)N(kN)-1.5100300-1.9-1.114000.126200.33829Qsi（侧摩）Qp（端阻）各土层底部高程土的厚度桩长计算桩径桩周长桩底面积侧摩(kN)端阻(kN)侧摩+端阻(kPa)(kPa)(m)(m)Li(m)d(mm)Up(mm)Ap(m2)UP*Li*QsiAp*QpRa1(kN)0024.217.15.995.994001.2570.126016021.512.72.72.74001.2570.126540021.510004001.2570.12600021.510004001.2570.12600021.510004001.2570.12600021.510004001.2570.12600021.510004001.2570.12600021.510004001.2570.12600021.510004001.2570.12600021.510004001.2570.12600021.510004001.2570.12600021.510004001.2570.126013持力层22400201.511.511.514001.2570.126425014610.2m96mbfakRa=min(Ra1,Ra2)置换率0.75~0.95天然承载力特征值单桩承载力特征值Ap(m2)S1(mm)S2(mm)1.13(S1*S2)d2/de2折减系数(kPa)(kN)(kPa)(kPa)(kPa)（kPa)0.1261400140015820.0640.800501467437112459mbfakRa=min(Ra1,Ra2)置换率0.75~0.95天然承载力特征值单桩承载力特征值Ap(m2)S(mm)1.05Sd2/de2折减系数(kPa)(kN)(kPa)(kPa)(kPa)（kPa)0.126140014700.0740.800501468637123526d(mm)400工程项目关南村村级经济发展项目2#楼101112桩间距2.当承载力以桩身强度控制时，不能进行深度修正。修正后的复合地基承载力特征值fspk不得大于“按桩身强度计算的最大复合地基承载力特征值MAX(fspk)”桩底面积d(mm)40032.1m*Ra/Ap单桩承载力特征值(kN)（摩阻力计算）de桩径m*Ra/Ap1.第9.2.5条:b取0.75-0.95复合地基特征值fspk复合地基承载力特征值（矩形布桩)b*(1-m)*fsk桩底面积复合地基特征值fspk按桩身强度计算的最大复合地基承载力特征值按桩身强度计算的最大复合地基承载力特征值MAX(fspk)de桩径桩间距桩间距8b*(1-m)*fsk单桩承载力特征值(kN)（桩身强度计算）素混凝土垫层厚度砂石垫层厚度桩顶距自然地面高度123(m)复合地基承载力特征值(等边三角形布桩)基础底标高（负数）土层号3.桩顶距自然地面高度：负值：桩顶在自然地面以下深度；正值：桩顶在自然地面以上高度有效桩长=4567桩穿越土层厚度(m)9CFG桩复合地基计算书备注：1.持力层土层底部高程应按桩端进入的深度输入。4.当某层无用时，可将该土层底部高程按应上一层的输入（不得输入错误）。2.当桩顶高出自然地面时，上部回填土不再考虑，也不需输入桩顶标高钻孔编号0.00高程(建筑）BK7孔口高程32.22桩径桩底面积桩身强度折减系数Ra2标高(m)(mm)（mm)标高(m)(m)d(mm)Ap(mm2)Fcu(Mpa)N(kN)-7.5100300-7.9-7.224000.126250.331037Qsi（侧摩）Qp（端阻）各土层底部高程土的厚度桩长计算桩径桩周长桩底面积侧摩(kN)端阻(kN)侧摩+端阻(kPa)(kPa)(m)(m)Li(m)d(mm)Up(mm)Ap(m2)UP*Li*QsiAp*QpRa1(kN)0027.225-2.2204001.2570.126024025.022.2-0.0204001.2570.126038019.525.55.485.484001.2570.1262620019.520004001.2570.12600019.520004001.2570.12600019.520004001.2570.12600019.520004001.2570.12600019.520004001.2570.12600019.520004001.2570.12600019.520004001.2570.12600019.520004001.2570.12600019.520004001.2570.126013持力层25240109.529.529.524001.2570.1262993059115m561mbfakRa=min(Ra1,Ra2)置换率0.75~0.95天然承载力特征值单桩承载力特征值Ap(m2)S1(mm)S2(mm)1.13(S1*S2)d2/de2折减系数(kPa)(kN)(kPa)(kPa)(kPa)（kPa)0.1261400140015820.0640.800140591301105405632mbfakRa=min(Ra1,Ra2)置换率0.75~0.95天然承载力特征值单桩承载力特征值Ap(m2)S(mm)1.05Sd2/de2折减系数(kPa)(kN)(kPa)(kPa)(kPa)（kPa)0.126140014700.0740.800140591348104452715CFG桩复合地基计算书备注：1.持力层土层底部高程应按桩端进入的深度输入。4.当某层无用时，可将该土层底部高程按应上一层的输入（不得输入错误）。2.当桩顶高出自然地面时，上部回填土不再考虑，也不需输入桩顶标高钻孔编号0.00高程(建筑）(m)桩穿越土层厚度(m)3.桩顶距自然地面高度：负值：桩顶在自然地面以下深度；正值：桩顶在自然地面以上高度有效桩长=456789单桩承载力特征值(kN)（桩身强度计算）素混凝土垫层厚度砂石垫层厚度桩顶距自然地面高度基础底标高（负数）土层号单桩承载力特征值(kN)（摩阻力计算）桩底面积复合地基特征值fspk按桩身强度计算的最大复合地基承载力特征值复合地基承载力特征值(等边三角形布桩)de123桩径桩间距桩间距deb*(1-m)*fskm*Ra/Ap复合地基特征值fspk复合地基承载力特征值（矩形布桩)桩间距2.当承载力以桩身强度控制时，不能进行深度修正。修正后的复合地基承载力特征值fspk不得大于“按桩身强度计算的最大复合地基承载力特征值MAX(fspk)”桩底面积d(mm)400按桩身强度计算的最大复合地基承载力特征值MAX(fspk)m*Ra/Apb*(1-m)*fskd(mm)400工程项目关南村村级经济发展项目2#楼101112桩径32.91.第9.2.5条:b取0.75-0.95BK33孔口高程32.25桩径桩底面积桩身强度折减系数Ra2标高(m)(mm)（mm)标高(m)(m)d(mm)Ap(mm2)Fcu(Mpa)N(kN)-7.5100300-7.9-7.254000.126250.331037Qsi（侧摩）Qp（端阻）各土层底部高程土的厚度桩长计算桩径桩周长桩底面积侧摩(kN)端阻(kN)侧摩+端阻(kPa)(kPa)(m)(m)Li(m)d(mm)Up(mm)Ap(m2)UP*Li*QsiAp*QpRa1(kN)0026.555.7-1.5504001.2570.126033021.854.73.153.154001.2570.12613138011.6510.210.210.24001.2570.1264870011.650004001.2570.12600011.650004001.2570.12600011.650004001.2570.12600011.650004001.2570.12600011.650004001.2570.12600011.650004001.2570.12600011.650004001.2570.12600011.650004001.2570.12600011.650004001.2570.126013持力层35450101.651.651.654001.2570.126735774715m690mbfakRa=min(Ra1,Ra2)置换率0.75~0.95天然承载力特征值单桩承载力特征值Ap(m2)S1(mm)S2(mm)1.13(S1*S2)d2/de2折减系数(kPa)(kN)(kPa)(kPa)(kPa)（kPa)0.1261400140015820.0640.800140747380105485632mbfakRa=min(Ra1,Ra2)置换率0.75~0.95天然承载力特征值单桩承载力特征值Ap(m2)S(mm)1.05Sd2/de2折减系数(kPa)(kN)(kPa)(kPa)(kPa)（kPa)0.126140014700.0740.800140747440104544715d(mm)400工程项目关南村村级经济发展项目2#楼101112桩间距2.当承载力以桩身强度控制时，不能进行深度修正。修正后的复合地基承载力特征值fspk不得大于“按桩身强度计算的最大复合地基承载力特征值MAX(fspk)”桩底面积d(mm)40032.9m*Ra/Ap单桩承载力特征值(kN)（摩阻力计算）de桩径m*Ra/Ap1.第9.2.5条:b取0.75-0.95复合地基特征值fspk复合地基承载力特征值（矩形布桩)b*(1-m)*fsk桩底面积复合地基特征值fspk按桩身强度计算的最大复合地基承载力特征值按桩身强度计算的最大复合地基承载力特征值MAX(fspk)de桩径桩间距桩间距8b*(1-m)*fsk单桩承载力特征值(kN)（桩身强度计算）素混凝土垫层厚度砂石垫层厚度桩顶距自然地面高度123(m)复合地基承载力特征值(等边三角形布桩)基础底标高（负数）土层号3.桩顶距自然地面高度：负值：桩顶在自然地面以下深度；正值：桩顶在自然地面以上高度有效桩长=4567桩穿越土层厚度(m)9CFG桩复合地基计算书备注：1.持力层土层底部高程应按桩端进入的深度输入。4.当某层无用时，可将该土层底部高程按应上一层的输入（不得输入错误）。2.当桩顶高出自然地面时，上部回填土不再考虑，也不需输入桩顶标高钻孔编号0.00高程(建筑）BK8孔口高程32.2桩径桩底面积桩身强度折减系数Ra2标高(m)(mm)（mm)标高(m)(m)d(mm)Ap(mm2)Fcu(Mpa)N(kN)-7.5100300-7.9-7.24000.126250.331037Qsi（侧摩）Qp（端阻）各土层底部高程土的厚度桩长计算桩径桩周长桩底面积侧摩(kN)端阻(kN)侧摩+端阻(kPa)(kPa)(m)(m)Li(m)d(mm)Up(mm)Ap(m2)UP*Li*QsiAp*QpRa1(kN)0027.15.1-2.104001.2570.126033025.71.4-0.704001.2570.126038016.59.28.58.54001.2570.1264060016.50004001.2570.12600016.50004001.2570.12600016.50004001.2570.12600016.50004001.2570.12600016.50004001.2570.12600016.50004001.2570.12600016.50004001.2570.12600016.50004001.2570.12600016.50004001.2570.126013持力层35450106.56.56.54001.2570.1262865774815m692mbfakRa=min(Ra1,Ra2)置换率0.75~0.95天然承载力特征值单桩承载力特征值Ap(m2)S1(m