excel计算大全-房建-桩基设计计算书10#

J16 层 号土层名称压缩模量Es(Mpa)重度(KN/m3)2-1重粉质粘土3.1017.802-2粉质粘土9.9819.403-1重粉质粘土3.117.803-2重粉质粘土2.2317.103-3粉质粘土夹砂3.4917.904残积土4.2718.005-1强风化泥质粉砂岩7.8420.20C17J20阻力土层厚度(m)2.008.003.100.000.000.000.00C21阻力土层厚度(m)1.908.603.200.000.000.000.00C15J18qsik(Kpa)qpk(Kpa)30.015.030.050.00.00.00.01500250015002000250025002500阻力土层厚度(m)阻力土层厚度(m)1.702.005.307.300.000.005.504.000.000.000.000.000.000.00阻力土层厚度(m)阻力土层厚度(m)1.501.706.007.600.003.404.770.000.000.000.000.000.000.00规范经验参数法Quk=Qsk+Qpk=u∑qsikLi+qpkAp Rd = Rsk/γs+Rpk/γp = UpΣfsiLi/γs+fpAp/γpqFpk(KN)Rd(KN)γsγp桩 长(m)桩 径(m)pk(Kpa)12.500.3773000334.88480.27815.15509.471.61.61.1840.111613.300.3773000334.88437.63772.51482.821.61.61.1840.111613.100.3773000334.88323.34658.22411.391.61.61.1840.111613.700.3773000334.88334.00668.88418.051.61.61.1840.111612.270.3773000334.88442.37777.25485.781.61.61.1840.111612.700.3773000334.88316.23651.11406.951.61.61.1840.1116Fsk=UpΣfsiLi(KN)Quk(KN)u(m)=Ap(㎡)=C19J22J12C29C13C11C30J14阻力土层厚度(m)阻力土层厚度(m)阻力土层厚度(m)阻力土层厚度(m)阻力土层厚度(m)阻力土层厚度(m)阻力土层厚度(m)阻力土层厚度(m)1.501.901.701.002.001.901.601.707.808.502.504.003.802.703.704.804.202.600.900.000.000.000.000.000.000.006.606.516.487.516.755.500.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.0013.500.3773000334.88341.10675.99422.491.61.61.1840.1116

13.000.3773000334.88310.90645.78403.621.61.61.1840.111611.700.3773000334.88527.64862.53539.081.61.61.1840.111611.510.3773000334.88492.11827.00516.871.61.61.1840.111612.280.3773000334.88522.31857.20535.751.61.61.1840.111612.110.3773000334.88560.21895.10559.441.61.61.1840.111612.050.3773000334.88522.31857.20535.751.61.61.1840.1116 12.000.3773000334.88477.38812.26507.671.61.61.1840.1116