桩基沉降计算EXCEL表格

沉降计算表,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,

4号楼,,110孔,,桩端高程,,,-27.6,,孔口标高,,4.63,,,,,,,,,

土层,层底高程,Zi,L,B,Zi/B,L/B,,,Z/b,l/b,,,ai,aiZi,Ai,Esi,P0,Ai*P0/Esi,Ai/Esi,备注

32.2,(27.60),0,40.00,7.56,0.000,5.29,5.00,0.291005291,,5.0,10.0,5.29,0.2500,0.00,0.00,15.02,90.4,0.00,0.000,

33.8,(29.17),1.57,40.00,7.56,0.208,5.29,5.00,0.291005291,0.0,0.2500,0.2500,0.2500,0.2498,0.39,0.39,16.56,90.4,2.14,0.024,

35.8,(31.17),3.57,40.00,7.56,0.472,5.29,5.00,0.291005291,0.2,0.2498,0.2498,0.2498,0.2474,0.88,0.49,15.10,90.4,2.94,0.033,

36.2,(31.57),3.97,40.00,7.56,0.525,5.29,5.00,0.291005291,0.4,0.2485,0.2485,0.2485,0.2466,0.98,0.10,15.75,90.4,0.55,0.006,

37.8,(33.17),5.57,40.00,7.56,0.737,5.29,5.00,0.291005291,0.6,0.2455,0.2456,0.2455,0.2424,1.35,0.37,13.35,90.4,2.51,0.028,

39.8,(35.17),7.57,40.00,7.56,1.001,5.29,5.00,0.291005291,0.8,0.2410,0.2410,0.2410,0.2353,1.78,0.43,14.16,90.4,2.75,0.030,

41.8,(37.17),9.57,40.00,7.56,1.266,5.29,5.00,0.291005291,1.0,0.2353,0.2353,0.2353,0.2266,2.17,0.39,13.48,90.4,2.60,0.029,

43.8,(39.17),11.57,40.00,7.56,1.530,5.29,5.00,0.291005291,1.2,0.2288,0.2289,0.2288,0.2174,2.52,0.35,15.97,90.4,1.97,0.022,

44.5,(39.87),12.27,40.00,7.56,1.623,5.29,5.00,0.291005291,1.4,0.2220,0.2221,0.2220,0.2142,2.63,0.11,15.39,90.4,0.66,0.007,

45.8,(41.17),13.57,40.00,7.56,1.795,5.29,5.00,0.291005291,1.6,0.2150,0.2152,0.2150,0.2084,2.83,0.20,18.87,90.4,0.95,0.011,

47.8,(43.17),15.57,40.00,7.56,2.060,5.29,5.00,0.291005291,1.8,0.2082,0.2084,0.2082,0.1996,3.11,0.28,16.96,90.4,1.50,0.017,

49.8,(45.17),17.57,40.00,7.56,2.324,5.29,5.00,0.291005291,2.0,0.2015,0.2018,0.2015,0.1912,3.36,0.25,17.22,90.4,1.32,0.015,

51.8,(47.17),19.57,40.00,7.56,2.589,5.29,5.00,0.291005291,2.2,0.1952,0.1955,0.1952,0.1835,3.59,0.23,20.98,90.4,1.00,0.011,

52.5,(47.87),20.27,40.00,7.56,2.681,5.29,5.00,0.291005291,2.4,0.1890,0.1895,0.1890,0.1810,3.67,0.08,16.43,90.4,0.42,0.005,

52.5,(47.87),20.27,40.00,7.56,2.681,5.29,5.00,0.291005291,2.6,0.1832,0.1838,0.1832,0.1810,3.67,0.00,18.97,90.4,0.00,0.000,

倒算1米,(46.87),19.27,40.00,7.56,2.549,5.29,5.00,0.291005291,2.8,0.1777,0.1784,0.1777,0.1846,3.56,(0.11),18.21,90.4,(0.55),(0.006),

,,,40.00,7.56,,5.29,5.00,0.291005291,3.0,0.1725,0.1733,0.1725,,,,,,,,

,,,40.00,7.56,,5.29,5.00,0.291005291,3.2,0.1675,0.1685,0.1676,,,,,,,,

,,,40.00,7.56,,5.29,5.00,0.291005291,3.4,0.1628,0.1639,0.1629,,,,,,,,

,,,40.00,7.56,,5.29,5.00,0.291005291,3.6,0.1583,0.1595,0.1584,,,,,,,,

,,,40.00,7.56,,5.29,5.00,0.291005291,3.8,0.1541,0.1554,0.1542,,,,,,,,

s'=,21.31,,δs'=,0.0258,S=,34.10,,mm,,,,,,压缩层厚,20.27,m,,,,

,,,,,,,,,,,,,,,,,,当量值,,

,,,,,,,,,,,,,,,,,,15.56,,

,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,

沉降计算表,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,

4号楼,,112孔,,桩端高程,,,-27.6,,孔口标高,,5.79,,,,,,,,,

土层,层底高程,Zi,L,B,Zi/B,L/B,,,Z/b,l/b,,,ai,aiZi,Ai,Esi,P0,Ai*P0/Esi,Ai/Esi,备注

33.4,(27.60),0,44.0,7.25,0.000,6.07,5.00,1.068965517,,5.0,10.0,6.07,0.2500,0.00,0.00,14.08,114.6,0.00,0.000,

34.3,(28.51),0.91,44.0,7.25,0.126,6.07,5.00,1.068965517,0.0,0.2500,0.2500,0.2500,0.2499,0.23,0.23,15.79,114.6,1.65,0.014,

36.3,(30.51),2.91,44.0,7.25,0.401,6.07,5.00,1.068965517,0.2,0.2498,0.2498,0.2498,0.2485,0.72,0.50,16.83,114.6,3.38,0.029,

37.9,(32.11),4.51,44.0,7.25,0.622,6.07,5.00,1.068965517,0.4,0.2485,0.2485,0.2485,0.2450,1.11,0.38,16.02,114.6,2.73,0.024,

38.3,(32.51),4.91,44.0,7.25,0.677,6.07,5.00,1.068965517,0.6,0.2455,0.2456,0.2455,0.2438,1.20,0.09,15.80,114.6,0.67,0.006,

40,(34.21),6.61,44.0,7.25,0.912,6.07,5.00,1.068965517,0.8,0.2410,0.2410,0.2410,0.2378,1.57,0.38,16.03,114.6,2.68,0.023,

42,(36.21),8.61,44.0,7.25,1.188,6.07,5.00,1.068965517,1.0,0.2353,0.2353,0.2353,0.2292,1.97,0.40,16.01,114.6,2.88,0.025,

44,(38.21),10.61,44.0,7.25,1.463,6.07,5.00,1.068965517,1.2,0.2288,0.2289,0.2288,0.2198,2.33,0.36,16.06,114.6,2.56,0.022,

45,(39.21),11.61,44.0,7.25,1.601,6.07,5.00,1.068965517,1.4,0.2220,0.2221,0.2220,0.2150,2.50,0.16,12.75,114.6,1.47,0.013,

46,(40.21),12.61,44.0,7.25,1.739,6.07,5.00,1.068965517,1.6,0.2150,0.2152,0.2150,0.2103,2.65,0.16,21.78,114.6,0.82,0.007,

48,(42.21),14.61,44.0,7.25,2.015,6.07,5.00,1.068965517,1.8,0.2082,0.2084,0.2082,0.2011,2.94,0.29,25.42,114.6,1.29,0.011,

50,(44.21),16.61,44.0,7.25,2.291,6.07,5.00,1.068965517,2.0,0.2015,0.2018,0.2016,0.1925,3.20,0.26,18.33,114.6,1.62,0.014,

52,(46.21),18.61,44.0,7.25,2.567,6.07,5.00,1.068965517,2.2,0.1952,0.1955,0.1953,0.1843,3.43,0.23,20.83,114.6,1.28,0.011,

54.5,(48.71),21.11,44.0,7.25,2.912,6.07,5.00,1.068965517,2.4,0.1890,0.1895,0.1891,0.1750,3.69,0.26,19.08,114.6,1.58,0.014,

倒算1米,(47.71),20.11,44.0,7.25,2.774,6.07,5.00,1.068965517,2.6,0.1832,0.1838,0.1833,0.1786,3.59,(0.10),19.08,114.6,(0.61),(0.005),

,,,44.0,7.25,,6.07,5.00,1.068965517,2.8,0.1777,0.1784,0.1778,,,,,,,,

,,,44.0,7.25,,6.07,5.00,1.068965517,3.0,0.1725,0.1733,0.1727,,,,,,,,

,,,44.0,7.25,,6.07,5.00,1.068965517,3.2,0.1675,0.1685,0.1677,,,,,,,,

,,,44.0,7.25,,6.07,5.00,1.068965517,3.4,0.1628,0.1639,0.1630,,,,,,,,

,,,44.0,7.25,,6.07,5.00,1.068965517,3.6,0.1583,0.1595,0.1586,,,,,,,,

,,,44.0,7.25,,6.07,5.00,1.068965517,3.8,0.1541,0.1554,0.1544,,,,,,,,

,,,44.0,7.25,,6.07,5.00,1.068965517,4.0,0.1500,0.1516,0.1503,,,,,,,,

,,,44.0,7.25,,6.07,5.00,1.068965517,4.2,0.1462,0.1479,0.1466,,,,,,,,

s'=,24.61,,δs'=,0.0250,S=,39.38,,mm,,,,,,压缩层厚,21.11,m,,,,

,,,,,,,,,,,,,,,,,,当量值,,

,,,,,,,,,,,,,,,,,,17.20,,

,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,

沉降计算表,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,

4号楼,,114孔,,桩端高程,,,-27.6,,孔口标高,,4.68,,,,,,,,,

土层,层底高程,Zi,L,B,Zi/B,L/B,,,Z/b,l/b,,,ai,aiZi,Ai,Esi,P0,Ai*P0/Esi,Ai/Esi,备注

32.3,(27.60),0,44.0,7.25,0.000,6.07,5.00,1.068965517,,5.0,10.0,6.07,0.2500,0.00,0.00,15.69,141.8,0.00,0.000,

33.3,(28.62),1.02,44.0,7.25,0.141,6.07,5.00,1.068965517,0.0,0.2500,0.2500,0.2500,0.2499,0.25,0.25,15.64,141.8,2.31,0.016,

35.3,(30.62),3.02,44.0,7.25,0.417,6.07,5.00,1.068965517,0.2,0.2498,0.2498,0.2498,0.2483,0.75,0.49,16.32,141.8,4.30,0.030,

36.7,(32.02),4.42,44.0,7.25,0.610,6.07,5.00,1.068965517,0.4,0.2485,0.2485,0.2485,0.2453,1.08,0.33,16.85,141.8,2.82,0.020,

37.3,(32.62),5.02,44.0,7.25,0.692,6.07,5.00,1.068965517,0.6,0.2455,0.2456,0.2455,0.2434,1.22,0.14,14.30,141.8,1.37,0.010,

39.3,(34.62),7.02,44.0,7.25,0.968,6.07,5.00,1.068965517,0.8,0.2410,0.2410,0.2410,0.2362,1.66,0.44,14.95,141.8,4.14,0.029,

41.3,(36.62),9.02,44.0,7.25,1.244,6.07,5.00,1.068965517,1.0,0.2353,0.2353,0.2353,0.2273,2.05,0.39,15.87,141.8,3.51,0.025,

42.2,(37.52),9.92,44.0,7.25,1.368,6.07,5.00,1.068965517,1.2,0.2288,0.2289,0.2288,0.2231,2.21,0.16,18.40,141.8,1.25,0.009,

43.3,(38.62),11.02,44.0,7.25,1.520,6.07,5.00,1.068965517,1.4,0.2220,0.2221,0.2220,0.2178,2.40,0.19,18.04,141.8,1.47,0.010,

45.3,(40.62),13.02,44.0,7.25,1.796,6.07,5.00,1.068965517,1.6,0.2150,0.2152,0.2150,0.2084,2.71,0.31,19.58,141.8,2.26,0.016,

47.3,(42.62),15.02,44.0,7.25,2.072,6.07,5.00,1.068965517,1.8,0.2082,0.2084,0.2082,0.1993,2.99,0.28,17.61,141.8,2.26,0.016,

49.3,(44.62),17.02,44.0,7.25,2.348,6.07,5.00,1.068965517,2.0,0.2015,0.2018,0.2016,0.1907,3.25,0.25,18.52,141.8,1.93,0.014,

51.3,(46.62),19.02,44.0,7.25,2.623,6.07,5.00,1.068965517,2.2,0.1952,0.1955,0.1953,0.1827,3.47,0.23,22.51,141.8,1.44,0.010,

53.7,(49.02),21.42,44.0,7.25,2.954,6.07,5.00,1.068965517,2.4,0.1890,0.1895,0.1891,0.1738,3.72,0.25,18.54,141.8,1.91,0.013,

倒算1米,(48.02),20.42,44.0,7.25,2.817,6.07,5.00,1.068965517,2.6,0.1832,0.1838,0.1833,0.1774,3.62,(0.10),18.54,141.8,(0.77),(0.005),

,,,44.0,7.25,,6.07,5.00,1.068965517,2.8,0.1777,0.1784,0.1778,,,,,,,,

,,,44.0,7.25,,6.07,5.00,1.068965517,3.0,0.1725,0.1733,0.1727,,,,,,,,

,,,44.0,7.25,,6.07,5.00,1.068965517,3.2,0.1675,0.1685,0.1677,,,,,,,,

,,,44.0,7.25,,6.07,5.00,1.068965517,3.4,0.1628,0.1639,0.1630,,,,,,,,

,,,44.0,7.25,,6.07,5.00,1.068965517,3.6,0.1583,0.1595,0.1586,,,,,,,,

,,,44.0,7.25,,6.07,5.00,1.068965517,3.8,0.1541,0.1554,0.1544,,,,,,,,

,,,44.0,7.25,,6.07,5.00,1.068965517,4.0,0.1500,0.1516,0.1503,,,,,,,,

,,,44.0,7.25,,6.07,5.00,1.068965517,4.2,0.1462,0.1479,0.1466,,,,,,,,

,,,44.0,7.25,,6.07,5.00,1.068965517,,,,,,,,,,,,

s'=,30.97,,δs'=,0.0249,S=,49.55,,mm,,,,,,压缩层厚,21.42,m,,,,

,,,,,,,,,,,,,,,,,,当量值,,

,,,,,,,,,,,,,,,,,,17.06,,

,,,,,,,,,,,,,,,,,,,,,

沉降计算表,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,

4号楼,,117孔,,桩端高程,,,-27.6,,孔口标高,,5.75,,,,,,,,,

土层,层底高程,Zi,L,B,Zi/B,L/B,,,Z/b,l/b,,,ai,aiZi,Ai,Esi,P0,Ai*P0/Esi,Ai/Esi,备注

33.4,(27.60),0,44.0,7.25,0.000,6.07,5.00,1.068965517,,5.0,10.0,6.07,0.2500,0.00,0.00,16.90,112.1,0.00,0.000,

34.3,(28.55),0.95,44.0,7.25,0.131,6.07,5.00,1.068965517,0.0,0.2500,0.2500,0.2500,0.2499,0.24,0.24,15.44,112.1,1.72,0.015,

36.3,(30.55),2.95,44.0,7.25,0.407,6.07,5.00,1.068965517,0.2,0.2498,0.2498,0.2498,0.2484,0.73,0.50,17.22,112.1,3.22,0.029,

38,(32.25),4.65,44.0,7.25,0.641,6.07,5.00,1.068965517,0.4,0.2485,0.2485,0.2485,0.2446,1.14,0.40,16.32,112.1,2.78,0.025,

38.3,(32.55),4.95,44.0,7.25,0.683,6.07,5.00,1.068965517,0.6,0.2455,0.2456,0.2455,0.2437,1.21,0.07,15.43,112.1,0.50,0.004,

40.3,(34.55),6.95,44.0,7.25,0.959,6.07,5.00,1.068965517,0.8,0.2410,0.2410,0.2410,0.2365,1.64,0.44,15.40,112.1,3.18,0.028,

42.3,(36.55),8.95,44.0,7.25,1.234,6.07,5.00,1.068965517,1.0,0.2353,0.2353,0.2353,0.2276,2.04,0.39,15.37,112.1,2.87,0.026,

44.3,(38.55),10.95,44.0,7.25,1.510,6.07,5.00,1.068965517,1.2,0.2288,0.2289,0.2288,0.2182,2.39,0.35,16.43,112.1,2.40,0.021,

44.9,(39.15),11.55,44.0,7.25,1.593,6.07,5.00,1.068965517,1.4,0.2220,0.2221,0.2220,0.2153,2.49,0.10,16.98,112.1,0.64,0.006,

46.3,(40.55),12.95,44.0,7.25,1.786,6.07,5.00,1.068965517,1.6,0.2150,0.2152,0.2150,0.2087,2.70,0.22,21.74,112.1,1.12,0.010,

48.3,(42.55),14.95,44.0,7.25,2.062,6.07,5.00,1.068965517,1.8,0.2082,0.2084,0.2082,0.1996,2.98,0.28,16.29,112.1,1.94,0.017,

50.3,(44.55),16.95,44.0,7.25,2.338,6.07,5.00,1.068965517,2.0,0.2015,0.2018,0.2016,0.1910,3.24,0.25,19.57,112.1,1.45,0.013,

52.3,(46.55),18.95,44.0,7.25,2.614,6.07,5.00,1.068965517,2.2,0.1952,0.1955,0.1953,0.1830,3.47,0.23,19.98,112.1,1.29,0.011,

53.5,(47.75),20.15,44.0,7.25,2.779,6.07,5.00,1.068965517,2.4,0.1890,0.1895,0.1891,0.1784,3.60,0.13,20.96,112.1,0.69,0.006,

53.5,(47.75),20.15,44.0,7.25,2.779,6.07,5.00,1.068965517,2.6,0.1832,0.1838,0.1833,0.1784,3.60,0.00,20.01,112.1,0.00,0.000,

倒算1米,(46.75),19.15,44.0,7.25,2.641,6.07,5.00,1.068965517,2.8,0.1777,0.1784,0.1778,0.1822,3.49,(0.11),20.01,112.1,(0.59),(0.005),

,,,44.0,7.25,,6.07,5.00,1.068965517,3.0,0.1725,0.1733,0.1727,,,,,,,,

,,,44.0,7.25,,6.07,5.00,1.068965517,3.2,0.1675,0.1685,0.1677,,,,,,,,

,,,44.0,7.25,,6.07,5.00,1.068965517,3.4,0.1628,0.1639,0.1630,,,,,,,,

,,,44.0,7.25,,6.07,5.00,1.068965517,3.6,0.1583,0.1595,0.1586,,,,,,,,

,,,44.0,7.25,,6.07,5.00,1.068965517,3.8,0.1541,0.1554,0.1544,,,,,,,,

,,,44.0,7.25,,6.07,5.00,1.068965517,4.0,0.1500,0.1516,0.1503,,,,,,,,

,,,44.0,7.25,,6.07,5.00,1.068965517,4.2,0.1462,0.1479,0.1466,,,,,,,,

s'=,23.80,,δs'=,0.0250,S=,38.08,,mm,,,,,,压缩层厚,20.15,m,,当量值,,

,,,,,,,,,,,,,,,,,,16.93,,

,,,,,,,,,,,,,,,,,,,,,

沉降计算表,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,

4号楼,,119孔,,桩端高程,,,-27.6,,孔口标高,,4.88,,,,,,,,,

土层,层底高程,Zi,L,B,Zi/B,L/B,,,Z/b,l/b,,,ai,aiZi,Ai,Esi,P0,Ai*P0/Esi,Ai/Esi,备注

32.5,(27.60),0,44.0,7.25,0.000,6.07,5.00,1.068965517,,5.0,10.0,6.07,0.2500,0.00,0.00,15.65,146.0,0.00,0.000,

33.8,(28.92),1.32,44.0,7.25,0.182,6.07,5.00,1.068965517,0.0,0.2500,0.2500,0.2500,0.2498,0.33,0.33,15.58,146.0,3.09,0.021,

35.8,(30.92),3.32,44.0,7.25,0.458,6.07,5.00,1.068965517,0.2,0.2498,0.2498,0.2498,0.2476,0.82,0.49,16.10,146.0,4.47,0.031,

36.7,(31.82),4.22,44.0,7.25,0.582,6.07,5.00,1.068965517,0.4,0.2485,0.2485,0.2485,0.2458,1.04,0.22,15.67,146.0,2.00,0.014,

37.8,(32.92),5.32,44.0,7.25,0.734,6.07,5.00,1.068965517,0.6,0.2455,0.2456,0.2455,0.2425,1.29,0.25,14.54,146.0,2.54,0.017,

39.8,(34.92),7.32,44.0,7.25,1.010,6.07,5.00,1.068965517,0.8,0.2410,0.2410,0.2410,0.2350,1.72,0.43,15.76,146.0,3.98,0.027,

41.8,(36.92),9.32,44.0,7.25,1.286,6.07,5.00,1.068965517,1.0,0.2353,0.2353,0.2353,0.2259,2.11,0.39,16.06,146.0,3.50,0.024,

42,(37.12),9.52,44.0,7.25,1.313,6.07,5.00,1.068965517,1.2,0.2288,0.2289,0.2288,0.2250,2.14,0.04,16.63,146.0,0.32,0.002,

43.8,(38.92),11.32,44.0,7.25,1.561,6.07,5.00,1.068965517,1.4,0.2220,0.2221,0.2220,0.2164,2.45,0.31,17.24,146.0,2.61,0.018,

45.8,(40.92),13.32,44.0,7.25,1.837,6.07,5.00,1.068965517,1.6,0.2150,0.2152,0.2150,0.2070,2.76,0.31,17.38,146.0,2.58,0.018,

47.8,(42.92),15.32,44.0,7.25,2.113,6.07,5.00,1.068965517,1.8,0.2082,0.2084,0.2082,0.1980,3.03,0.28,19.22,146.0,2.10,0.014,

49.8,(44.92),17.32,44.0,7.25,2.389,6.07,5.00,1.068965517,2.0,0.2015,0.2018,0.2016,0.1894,3.28,0.25,20.47,146.0,1.77,0.012,

51.8,(46.92),19.32,44.0,7.25,2.665,6.07,5.00,1.068965517,2.2,0.1952,0.1955,0.1953,0.1816,3.51,0.23,25.67,146.0,1.29,0.009,

52.6,(47.72),20.12,44.0,7.25,2.775,6.07,5.00,1.068965517,2.4,0.1890,0.1895,0.1891,0.1785,3.59,0.08,18.80,146.0,0.66,0.004,

52.6,(47.72),20.12,44.0,7.25,2.775,6.07,5.00,1.068965517,2.6,0.1832,0.1838,0.1833,0.1785,3.59,0.00,20.68,146.0,0.00,0.000,

倒算1米,(46.72),19.12,44.0,7.25,2.637,6.07,5.00,1.068965517,2.8,0.1777,0.1784,0.1778,0.1823,3.49,(0.11),20.30,146.0,(0.76),(0.005),

,,,44.0,7.25,,6.07,5.00,1.068965517,3.0,0.1725,0.1733,0.1727,,,,,,,,

,,,44.0,7.25,,6.07,5.00,1.068965517,3.2,0.1675,0.1685,0.1677,,,,,,,,

,,,44.0,7.25,,6.07,5.00,1.068965517,3.4,0.1628,0.1639,0.1630,,,,,,,,

,,,44.0,7.25,,6.07,5.00,1.068965517,3.6,0.1583,0.1595,0.1586,,,,,,,,

,,,44.0,7.25,,6.07,5.00,1.068965517,3.8,0.1541,0.1554,0.1544,,,,,,,,

,,,44.0,7.25,,6.07,5.00,1.068965517,4.0,0.1500,0.1516,0.1503,,,,,,,,

,,,44.0,7.25,,6.07,5.00,1.068965517,4.2,0.1462,0.1479,0.1466,,,,,,,,

s'=,30.90,,δs'=,0.0247,S=,49.44,,mm,,,,,,压缩层厚,20.12,m,,当量值,,

,,,,,,,,,,,,,,,,,,16.97,,

,,,,,,,,,,,,,,,,,,,,,

沉降计算表,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,

4号楼,,115孔,,桩端高程,,,-27.6,,孔口标高,,4.51,,,,,,,,,

土层,层底高程,Zi,L,B,Zi/B,L/B,,,Z/b,l/b,,,ai,aiZi,Ai,Esi,P0,Ai*P0/Esi,Ai/Esi,备注

32.1,(27.60),0,44.0,7.25,0.000,6.07,5.00,1.068965517,,5.0,10.0,6.07,0.2500,0.00,0.00,13.44,72.5,0.00,0.000,

33.4,(28.89),1.29,44.0,7.25,0.178,6.07,5.00,1.068965517,0.0,0.2500,0.2500,0.2500,0.2498,0.32,0.32,15.04,72.5,1.55,0.021,

35,(30.49),2.89,44.0,7.25,0.399,6.07,5.00,1.068965517,0.2,0.2498,0.2498,0.2498,0.2485,0.72,0.40,15.63,72.5,1.84,0.025,

37.4,(32.89),5.29,44.0,7.25,0.730,6.07,5.00,1.068965517,0.4,0.2485,0.2485,0.2485,0.2426,1.28,0.57,15.41,72.5,2.66,0.037,

38,(33.49),5.89,44.0,7.25,0.812,6.07,5.00,1.068965517,0.6,0.2455,0.2456,0.2455,0.2406,1.42,0.13,21.96,72.5,0.44,0.006,

40,(35.49),7.89,44.0,7.25,1.088,6.07,5.00,1.068965517,0.8,0.2410,0.2410,0.2410,0.2324,1.83,0.42,15.81,72.5,1.91,0.026,

42,(37.49),9.89,44.0,7.25,1.364,6.07,5.00,1.068965517,1.0,0.2353,0.2353,0.2353,0.2232,2.21,0.37,14.13,72.5,1.92,0.026,

44,(39.49),11.89,44.0,7.25,1.640,6.07,5.00,1.068965517,1.2,0.2288,0.2289,0.2288,0.2137,2.54,0.33,18.88,72.5,1.28,0.018,

45.1,(40.59),12.99,44.0,7.25,1.792,6.07,5.00,1.068965517,1.4,0.2220,0.2221,0.2220,0.2085,2.71,0.17,17.77,72.5,0.69,0.009,

46,(41.49),13.89,44.0,7.25,1.916,6.07,5.00,1.068965517,1.6,0.2150,0.2152,0.2150,0.2044,2.84,0.13,16.73,72.5,0.56,0.008,

48,(43.49),15.89,44.0,7.25,2.192,6.07,5.00,1.068965517,1.8,0.2082,0.2084,0.2082,0.1955,3.11,0.27,20.04,72.5,0.97,0.013,

50,(45.49),17.89,44.0,7.25,2.468,6.07,5.00,1.068965517,2.0,0.2015,0.2018,0.2016,0.1872,3.35,0.24,21.75,72.5,0.80,0.011,

52,(47.49),19.89,44.0,7.25,2.743,6.07,5.00,1.068965517,2.2,0.1952,0.1955,0.1953,0.1794,3.57,0.22,19.92,72.5,0.80,0.011,

53.7,(49.19),21.59,44.0,7.25,2.978,6.07,5.00,1.068965517,2.4,0.1890,0.1895,0.1891,0.1732,3.74,0.17,18.17,72.5,0.69,0.009,

53.7,(49.19),21.59,44.0,7.25,2.978,6.07,5.00,1.068965517,2.6,0.1832,0.1838,0.1833,0.1732,3.74,0.00,18.17,72.5,0.00,0.000,

倒算1米,(48.19),20.59,44.0,7.25,2.840,6.07,5.00,1.068965517,2.8,0.1777,0.1784,0.1778,0.1768,3.64,(0.10),18.17,72.5,(0.40),(0.005),

,,,44.0,7.25,,6.07,5.00,1.068965517,3.0,0.1725,0.1733,0.1727,,,,,,,,

,,,44.0,7.25,,6.07,5.00,1.068965517,3.2,0.1675,0.1685,0.1677,,,,,,,,

,,,44.0,7.25,,6.07,5.00,1.068965517,3.4,0.1628,0.1639,0.1630,,,,,,,,

,,,44.0,7.25,,6.07,5.00,1.068965517,3.6,0.1583,0.1595,0.1586,,,,,,,,

,,,44.0,7.25,,6.07,5.00,1.068965517,3.8,0.1541,0.1554,0.1544,,,,,,,,

,,,44.0,7.25,,6.07,5.00,1.068965517,4.0,0.1500,0.1516,0.1503,,,,,,,,

,,,44.0,7.25,,6.07,5.00,1.068965517,4.2,0.1462,0.1479,0.1466,,,,,,,,

s'=,16.11,,δs'=,0.0247,S=,25.78,,mm,,,,,,压缩层厚,21.59,m,,当量值,,

,,,,,,,,,,,,,,,,,,16.83,,

,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,