基桩抗压抗拔及配筋自动计算表格Excel

桩桩身身抗抗压压序号项目单位数值备注1NekmaxKN843.40轴力2RaKN990.673QukKN1981.344QskKN1117.841.838715QpkKN863.506PskKpa1466.67手动判断7Psk1Kpa1033.338Psk2Kpa1900.009/0.7510/1.0011dm1.00桩径12Lm5.50桩长结果满足5.2.1-4QsQs与与QpQp序号土层li（m）qsik（Kpa）uiPsik（Kpa）1杂填0.40.03.10.02粉粘0.450.03.1800.03粘2.390.03.11800.04强泥2.4140.03.12300.050.003.11900.0桩桩身身配配筋筋序号项目单位数量备注1混凝土抗压强度设计值Mpa14.30C302钢筋抗压强度设计值Mpa360.00HRB4003计算配筋面积mm2603.14最小配筋面积mm5102.5min0.65%结果最终配筋面积mm5102.5max（C20，C21）1.83871桩桩抗抗拔拔序号项目单位数值备注地下水位1NKkN790.2拔力3.702TukkN990.0抗拔力557.503GpkN88.8桩重力4dm0.8桩径583.745开挖深度Lm5.5桩长标准组合结果不满足5.4.5-2满足桩桩身身抗抗拔拔序号项目单位数量备注 1计算配筋面积mm2195.02最小配筋面积mm3265.6min0.65%结果最终配筋面积mm3265.6max（C20，C21）TukTuk序号土层li（m）qsik（Kpa）iuiTuki(KN)1杂填0.40.00.72.510.02粉粘0.450.00.72.5135.23粘2.390.00.72.51364.04强泥2.4140.00.72.51590.850.00.00.72.510.060.00.00.72.510.011480.6022.0025.0028.00s380.13490.87615.75n30.2023.3918.64n12164.1613744.363768.00121.55139.56序号项目单位规格数量3根序号一一分分部部分分项项工工程程量量11挖方m软岩8.031324.0942余方弃置m软岩8.03124.09423护壁mC302.5827.74534桩芯mC305.37616.12745钢筋t0.3951.18655.1纵筋t18*200.2620.78765.2螺旋箍筋t81000.0730.22075.3加强筋t160.0350.10585.4局部受压筋t160.0120.03795.5穿管加强t160.0120.037106预埋件安装t厂家供货0.2200.6607包封混凝土mC30膨细石0.2930.879118预埋管m110pvc15.20045.600二二措措施施工工程程量量1护壁模板m木模板15.38646.1582发电台班30kw15.00045.0003抽水台班100mm15.00045.0001.01.0米米桩桩基基算算量量表表桩桩长长（m m）5.7基基础础算算量量要要素素表表开开挖挖深深度度（m m）5.5地下水位（m）3.7以上长度（m）3.9以下长度（m）1.8Gp（KN）97.73253.9093桩径（m）1.01.61.8护壁（m）锁口（m）/桩0.3030.4420.488直段（m）/m0.4650.7030.782桩芯直段砼（m）/m0.7852.0112.545扩大头（挖方）砼（m）/桩1.5293.2063.904挖方直段（m）/m1.3272.8353.4648螺旋箍（kg）/m12.42019.86022.34010螺旋箍（kg）/m19.39031.02034.90016加强筋（kg）/桩9.07014.51016.32016局部受压筋（kg）/桩12.42034.92041.21016C穿管加强钢筋（kg）/桩12.48012.48012.4808护壁钢筋锁口（kg）/桩15.31724.50727.571直段（kg）/m25.71241.13946.282包封（m）/塔3GT/ZGJ0.2380.2570.257DGT0.3110.4120.429基基础础算算量量要要素素表表