地基沉降量计算-地基沉降自动计算表格

地基沉降量计算,,,,,,,,,

1.计算公式,,,,,,,,,

《建筑地基基础设计规范》(GBJ7-89)5.2.5,,,,,,,,,

s=ψs∑Po(ziαi-zi-1αi-1)/Esi,,,,,,,,,

,,,,,,,,,,

,土层编号（ZK1）,,,,,,,,

土层号,土层名称,土层厚度(m),,,ψs,,,,

1,填土层,1,,,Po,kPa,,,

2,淤泥层,3,,,αi,,,,

3,粘土,5,,,zi,,,,

4,淤泥层,2,,,Esi,Mpa,,,

5,粉质粘土,3,,,s,mm,,,

6,粘土,0.3,,,,,,,

b=,1.4,,,地基沉降计算表,,,,计算位置,ZK1

土层号,z/b,ψs,Po,αi,zi,αi-1,zi-1,Esi,△si

1,0.714285714,1.4,27,0.2433,1,,,3.2,2.87398125

2,2.857142857,1.4,27,0.1784,4,0.2433,1,1.2,14.81445

3,6.428571429,1.4,27,0.1171,9,0.1784,4,3.52,3.654357955

4,7.857142857,1.4,27,0.1036,11,0.1171,9,1.65,1.963309091

5,10,1.4,27,0.088,14,0.1036,11,3.52,0.99225

6,10.21428571,1.4,27,0.0868,14.3,0.088,14,3.52,0.099225

s=2∑△si,,,,,,,,,46.61219659

,,,,,,,,,,

,土层编号（ZK7）,,,,,,,,

土层号,土层名称,土层厚度(m),,,ψs,,,,

1,填土层,1,,,Po,kPa,,,

2,淤泥层,6.4,,,αi,,,,

3,砾砂,1.2,,,zi,,,,

4,粘土,7.1,,,Esi,Mpa,,,

5,砾砂,2.1,,,s,mm,,,

6,粘土,0.3,,,,,,,

b=,1.4,,,地基沉降计算表,,,,计算位置,ZK7

土层号,z/b,ψs,Po,αi,zi,αi-1,zi-1,Esi,△si

1,0.714285714,1.4,27,0.2433,1,,,3.2,2.87398125

2,5.285714286,1.4,27,0.132,7.4,0.2433,1,1.2,23.10525

3,6.142857143,1.4,27,0.1206,8.6,0.132,7.4,7,0.325944

4,11.21428571,1.4,27,0.0813,15.7,0.1206,8.6,3.52,2.56921875

5,12.71428571,1.4,27,0.0755,17.8,0.0813,15.7,7,0.364446

6,12.92857143,1.4,27,0.0739,18.1,0.0755,17.8,3.52,-0.067760795

s=2∑△si,,,,,,,,,57.748788

,,,,,,,,,,

,,,,,,,,,,

,土层编号（ZK10）,,,,,,,,

土层号,土层名称,土层厚度(m),,,ψs,,,,

1,填土层,1.9,,,Po,kPa,,,

2,淤泥层,2,,,αi,,,,

3,粘土,15,,,zi,,,,

4,粘土,0.3,,,Esi,Mpa,,,

5,,0,,,s,mm,,,

6,,0,,,,,,,

b=,1.4,,,地基沉降计算表,,,,计算位置,ZK10

土层号,z/b,ψs,Po,αi,zi,αi-1,zi-1,Esi,△si

1,1.357142857,1.4,27,0.2221,1.9,,,3.2,4.984756875

2,2.785714286,1.4,27,0.1784,3.9,0.2221,1.9,1.2,8.623755

3,13.5,1.4,27,0.071,18.9,0.1784,3.9,3.52,6.9386625

4,13.71428571,1.4,27,0.0705,19.2,0.071,18.9,3.52,0.125642045

5,13.71428571,0,27,0,19.2,0.0705,19.2,7,0

6,13.71428571,0,27,0,19.2,0,19.2,3.52,0

s=2∑△si,,,,,,,,,41.34563284

,土层编号（ZK14）,,,,,,,,

土层号,土层名称,土层厚度(m),,,ψs,,,,

1,填土层,2.4,,,Po,kPa,,,

2,淤泥层,3,,,αi,,,,

3,粘土,15,,,zi,,,,

4,粘土,0.3,,,Esi,Mpa,,,

5,,0,,,s,mm,,,

6,,0,,,,,,,

b=,1.4,,,地基沉降计算表,,,,计算位置,ZK14

土层号,z/b,ψs,Po,αi,zi,αi-1,zi-1,Esi,△si

1,1.714285714,1.4,27,0.2108,2.4,,,3.2,5.97618

2,3.857142857,1.4,27,0.1554,5.4,0.2108,2.4,1.2,10.49706

3,14.57142857,1.4,27,0.0677,20.4,0.1554,5.4,3.52,5.819481818

4,14.78571429,1.4,27,0.0673,20.7,0.0677,20.4,3.52,0