Excel复合地基沉降量计算书(规范法)

4工程名称:计算部位:序号土层厚度(m)压缩模量Esi(Mpa)30(m)121.517(m)22.51.81.5(m)32.92.2500(Kpa)44.4480(Kpa)510(m)6分层号土层名称分层厚度(m)处理前压缩模量Esi(Mpa)处理后压缩模量Esi(Mpa)基础底至第i层底Zi(m)附加应力系数ai附加应力积分值Ai各层沉降量S(mm)最终累计沉降量S＇(mm)1素填土1.001.509.381.000.95220.952247.7347.732素填土1.001.509.382.000.81460.677033.9481.673粘土0.831.8011.252.830.70100.356914.9196.594粘土0.831.8011.253.670.60710.239910.02106.615粘土0.831.8011.254.500.53210.16837.03113.646粉土0.972.2013.755.470.46350.13984.78118.427粉土0.972.2013.756.430.40970.10203.49121.908粉土0.972.2013.757.400.36670.07742.65124.559粉性粘土0.884.0025.008.280.33440.05571.05125.5910粉性粘土0.884.0025.009.160.30730.04550.86126.4511粉性粘土0.844.0025.0010.000.28510.03630.68127.13土层参数(基底面开始)基本参数基础长度L复合地基沉降计算(规范法)基础底面处天然地基基底承载力fsk复合地基处理深度代表值H素填土粘土粉土土层名称基础宽度B基础埋置深度d处理后复合地基承载力特征值fspk粉性粘土iaia011()iiiiiEipSzazaSia1ia011()iiiiiEipSzazaS011()iiiiiEipSzazaS按《建筑地基基础设计规范》(GB50007-2011)中的表7.2.10由公式计算得复合地基沉降计算经验系数Ψ=.567修正后的复合地基最终累计沉降量为72.12mm