地基沉降计算表(excel自动计算表格)

地基沉降计算1.计算公式《建筑地基基础》(GBJ7-89)5.2.5s=ψs∑Po(ziαi-zi-1αi-1)/Esi土层的物理力学参数引自《珠海市晋益木业有限公司厂区岩土工程勘察报告》土层编号（ZK1）土层号土层名称土层厚度(m)ψs1填土层1PokPa2淤泥层3αi3粘土5zi4淤泥层2EsiMpa5粉质粘土3smm6粘土0.3地基沉降计算计算位b=1.4置ZK1土层号z/bψsPoαiziαi-1zi-1Esi△si10.7142861.4270.243313.22.87422.8571431.4270.178440.243311.214.81436.4285711.4270.117190.178443.523.654447.8571431.4270.1036110.117191.651.96335101.4270.088140.1036113.520.9923610.214291.4270.086814.30.088143.520.0992s=2∑△si46.612土层编号（ZK7）土层号土层名称土层厚度(m)ψs1填土层1PokPa2淤泥层6.4αi3砾砂1.2zi4粘土7.1EsiMpa5砾砂2.1smm6粘土0.3地基沉降计算计算位b=1.4表置ZK7土层号z/bψsPoαiziαi-1zi-1Esi△si10.7142861.4270.243313.22.87425.2857141.4270.1327.40.243311.223.10536.1428571.4270.12068.60.1327.470.3259411.214291.4270.081315.70.12068.63.522.5692512.714291.4270.075517.80.081315.770.3644612.928571.4270.073918.10.075517.83.52-0.068s=2∑△si57.749土层编号（ZK10）土层号土层名称土层厚度(m)ψs1填土层1.9PokPa2淤泥层2αi3粘土15zi4粘土0.3EsiMpa50smm60地基沉降计算计算位b=1.4表置ZK10土层号z/bψsPoαiziαi-1zi-1Esi△si11.3571431.4270.22211.93.24.984822.7857141.4270.17843.90.22211.91.28.6238313.51.4270.07118.90.17843.93.526.9387413.714291.4270.070519.20.07118.93.520.1256513.71429027019.20.070519.270613.71429027019.2019.23.520s=2∑△si41.346土层编号（ZK14）土层号土层名称土层厚度(m)ψs1填土层2.4PokPa2淤泥层3αi3粘土15zi4粘土0.3EsiMpa50smm60地基沉降计算计算位b=1.4表置ZK14土层号z/bψsPoαiziαi-1zi-1Esi△si11.7142861.4270.21082.43.25.976223.8571431.4270.15545.40.21082.41.210.497314.571431.4270.067720.40.15545.43.525.8195414.785711.4270.067320.70.067720.43.520.1292514.78571027020.70.067320.770614.78571027020.7020.73.520s=2∑△si44.844