各种复合地基最新Excel沉降量计算

4工程名称:计算部位:序号土层厚度(m)压缩模量Esi(Mpa)5(m)11.28154.2(m)29.65255.3(m)311.548370(Kpa)416.4915.5120(Kpa)510(m)6分层号土层名称分层厚度(m)处理前压缩模量Esi(Mpa)处理后压缩模量Esi(Mpa)基础底至第i层底Zi(m)附加应力系数ai附加应力积分值Ai各层沉降量S(mm)最终累计沉降量S＇(mm)1粉砂0.6415.0046.250.640.99600.63753.643.642粉砂0.6415.0046.251.280.97350.60873.477.113粉砂0.9725.0077.082.250.90320.78172.689.794粉砂0.9725.0077.083.210.81500.58842.0211.815粉砂0.9725.0077.084.180.72960.42991.4713.286粉砂0.9725.0077.085.140.65440.31731.0914.367粉砂0.9725.0077.086.110.59020.23970.8215.198粉砂0.9725.0077.087.070.53590.18560.6415.829粉砂0.9725.0077.088.040.48980.14720.5016.3310粉砂0.9725.0077.089.000.45060.11910.4116.7311粉砂0.9725.0077.089.970.41680.09810.3417.07基础长度L复合地基沉降计算(规范法)基础底面处天然地基基底承载力fsk复合地基处理深度代表值H粉砂粉砂粉土土层参数(基底面开始)基本参数土层名称基础宽度B基础埋置深度d处理后复合地基承载力特征值fspk粉土iaia011()iiiiiEipSzazaSia1ia011()iiiiiEipSzazaS011()iiiiiEipSzazaS12粉砂0.0425.0077.0810.000.41560.00320.0117.08按《建筑地基基础设计规范》(GB50007-2011)中的表7.2.10由公式计算得复合地基沉降计算经验系数Ψ=.262修正后的复合地基最终累计沉降量为4.47mm夕阳红制作2.080.673.839.6511.5416.49