{"text_format":"3","workbook":"xls","n_sheets":3,"sheets":["纯桩基承载力计算","地质剖面","桩基分项系数"],"not_rendered":{"images":1,"external_links":1},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"纯桩基承载力计算","index":0,"n_rows":35,"n_cols":8,"rows_kept":35,"flags":["formulas_cached_only"]}
["单桩承载力计算",null,"~~~~~~~~","3号楼C3号孔:"]
["已知:","桩长",34.5,"m","混凝土:","C30",15]
[null,"桩径",0.55,"m","桩顶绝对标高",null,1.62]
[{"$nulls":4},"桩顶相对标高",null,-3.33]
["桩截面面积:",null,0.23765852000000004]
["桩周长",null,1.7278250000000002]
["土层分布:"]
["土层","土层厚度(m)","土层重度","压缩模量","fs(KPa)","fp(KPa)","桩摩阻力","桩端阻力"]
[1,0,null,0,15,null,{"v":0,"d":"0.00"}]
[2.1,0.81,18.8,4.13,15,null,{"v":20.993073750000004,"d":"20.99"}]
[2.2,0.7,17.5,2.38,15,null,{"v":18.1421625,"d":"18.14"}]
[3,1.6,17.9,3.25,15,null,{"v":41.467800000000004,"d":"41.47"}]
[3,1.1,19,10.85,15,null,{"v":3.9213655800000007,"d":"3.92"},0]
[3,2.8,19,10.85,35,null,{"v":169.32685,"d":"169.33"},0]
[3,1.8,17.7,3.04,20,null,{"v":62.2017,"d":"62.20"},{"v":0,"d":"0.00"}]
[4,9.2,17,1.95,20,null,{"v":317.9198,"d":"317.92"},{"v":0,"d":"0.00"}]
[5.1,16.49,18.6,5,40,400,{"v":1139.67337,"d":"1139.67"},{"v":95.06340800000001,"d":"95.06"}]
[5.3,0,18.9,7.5,45,600,{"v":0,"d":"0.00"},{"v":142.59511200000003,"d":"142.60"}]
[null,34.5]
["单桩承载力摩阻力Rsk",{"$nulls":5},{"v":1773.64612183,"d":"1773.65"}]
["单桩承载力端阻力Rpk",{"$nulls":5},{"v":95.06340800000001,"d":"95.06"}]
["端阻比",{"$nulls":5},{"v":0.050871152783519065,"d":"0.051"}]
[null,"端阻比p",0.05,0.1,{"v":0.050871152783519065,"d":"0.051"}]
[null,"гp",1.02,1.05,{"v":1.0205226916701116,"d":"1.021"}]
[null,"гs",1.64,1.7,{"v":1.641045383340223,"d":"1.641"}]
[{"$nulls":6},"抗震时"]
["        Rsk","               rs","           rRe","          Rpk","            rp","单桩承载力设计值","单桩承载力设计值"]
[1773.64612183,{"v":1.641045383340223,"d":"1.641"},0.8,95.06340800000001,{"v":1.0205226916701116,"d":"1.021"},{"v":1173.9542876201033,"d":"1173.95"}]
[]
["桩身结构强度计算单桩竖向承载力设计值:"]
[null,"预制桩:",null,"(0.6~0.75)FcAp=",null,2138.9266800000005,"KN"]
[null,"灌注桩:",null,null,"0.6FcAp=",2138.9266800000005,"KN"]
[]
["取单桩承载力设计值:",{"$nulls":3},{"v":1173.9542876201033,"d":"1173.95"},"KN"]
[{"$nulls":3},"取",1100,"KN"]

{"sheet":"地质剖面","index":1,"n_rows":12,"n_cols":7,"rows_kept":12,"flags":["formulas_cached_only"]}
["3号楼C3号孔:",null,"自然断面:",3.44]
["土号","土层","土层厚度(m)","土层重度","压缩模量","fs(KPa)","fp(KPa)"]
[1,"杂填土",1.5,null,0,15]
[2.1,"褐黄色粉质粘土",1.1,18.8,4.13,15]
[2.2,"褐黄色淤泥质粘土",0.7,17.5,2.38,15]
[3,"灰色淤泥质粘土",1.6,17.9,3.25,15]
[3,"灰色砂质粉质夹粘土",3.9,19,10.85,15]
[3,"灰色淤泥质粘土",1.8,17.7,3.04,20]
[4,"灰色淤泥质粘土",9.2,17,1.95,20]
[5.1,"灰色粉质粘土",19.3,18.6,5,40,400]
[5.3,"暗绿色粉质粘土",12.6,18.9,7.5,45,600]
[8,"黄色砂质粉土",20,18.3,6.5]

{"sheet":"桩基分项系数","index":2,"n_rows":3,"n_cols":9,"rows_kept":3,"flags":["formulas_cached_only"]}
[0.05,0.1,0.15,0.2,0.25,0.3,0.35,0.4,0.45]
[1.02,1.05,1.08,1.12,1.18,1.24,1.3,1.41,1.5]
[1.64,1.7,1.75,1.79,1.82,1.83,1.8,1.76,1.69]