《桩计算-自动计算表格.xls》由会员分享，可在线阅读，更多相关《桩计算-自动计算表格.xls（18页珍藏版）》请在taowenge.com淘文阁网|工程机械CAD图纸|机械工程制图|CAD装配图下载|SolidWorks_CaTia_CAD_UG_PROE_设计图分享下载上搜索。
1、*32d2b397f13b1a5da22232a0299d38a7.xls*2022/7/13土层qsk(kPa)qpk(kPa)i土层深度(m)土层顶标高(m)土层厚度li(m)qsk*li31#孔0.5Um*qsk*li A*qpki*Um*qsk*li-102.47-20.61.87-1621.31.17-2624.3-1.83桩顶0.7-2.50.13 8.0612.65428.85794440.75.1-2.631.879.2124.34487.0408600.76.9-4.431.166103.6272.534-17026000.58-5.532.7189296.73148.365
2、-28550000.510.7 -8.233.27 278.0436.3815981.25 218.19075桩端-11.5-14217.8 -15.33-242Um*qsk*li=973.7297kNR=Um*qsk*li+A*qpk=1954.9797 kNUk=Um*qsk*li+A*qpk=534.98849 kN土层qsk(kPa)qpk(kPa)i土层深度(m)土层顶标高(m)土层厚度li(m)qsk*li21#孔0.5Um*qsk*li A*qpki*Um*qsk*li-102.43-20.71.73-1621.60.83-2624.3-1.87桩顶0.7-2.50.07 4.3
3、46.81384.76966440.75-2.572.7118.8186.516130.5612600.77.7-5.270.63656.5239.564-17026000.58.3-5.872.4168263.76131.88-28550000.510.7 -8.273.23 274.6431.0435981.25 215.52175桩端-11.5-14217.7 -15.27-242Um*qsk*li=944.6533kNR=Um*qsk*li+A*qpk=1925.9033 kNUk=Um*qsk*li+A*qpk=522.29661 kN第 1 页，共 18页*32d2b397f13b
4、1a5da22232a0299d38a7.xls*2022/7/13土层qsk(kPa)qpk(kPa)i土层深度(m)土层顶标高(m)土层厚度li(m)qsk*li11#孔0.5Um*qsk*li A*qpki*Um*qsk*li-102.5-20.71.8-1621.60.9-2624.3-1.8桩顶0.7-2.50000440.75-2.52.7118.8186.516130.5612600.77.7-5.20.63656.5239.564-17026000.58.3-5.82.4168263.76131.88-28550000.510.7 -8.23.3280.5440.385981.
5、25 220.1925桩端-11.5-14217.7 -15.2-242Um*qsk*li=947.181kNR=Um*qsk*li+A*qpk=1928.431kNUk=Um*qsk*li+A*qpk=522.1977 kN土层qsk(kPa)qpk(kPa)i土层深度(m)土层顶标高(m)土层厚度li(m)qsk*li1#孔0.5Um*qsk*li A*qpki*Um*qsk*li-102.14-20.51.64-1621.30.84-2624-1.86桩顶0.7-2.50.36 22.3235.042424.52968440.75-2.861.566103.6272.534600.76.
6、5-4.362120188.4131.88-17026000.58.5-6.362140219.8109.9-28550000.510.5 -8.363.14 266.9419.033981.25 209.5165桩端-11.5-14217.8 -15.66-242Um*qsk*li=965.8954kNR=Um*qsk*li+A*qpk=1947.1454 kNUk=Um*qsk*li+A*qpk=548.36018 kN第 2 页，共 18页*32d2b397f13b1a5da22232a0299d38a7.xls*2022/7/13土层qsk(kPa)qpk(kPa)i土层深度(m)土层
7、顶标高(m)土层厚度li(m)qsk*li33#孔0.5Um*qsk*li A*qpki*Um*qsk*li-102.46-20.91.56-1621.50.96-2624.4-1.94桩顶0.7-2.50.24 14.8823.361616.35312440.75.2-2.742.7118.8186.516130.5612600.77.9-5.442.5150235.5164.85-17026000.510.4 -7.940.1710.995.495-28550000.510.5 -8.043.46 294.1461.737981.25 230.8685桩端-11.5-14217.8 -15
8、.34-242Um*qsk*li=918.1046kNR=Um*qsk*li+A*qpk=1899.3546 kNUk=Um*qsk*li+A*qpk=548.12782 kN土层qsk(kPa)qpk(kPa)i土层深度(m)土层顶标高(m)土层厚度li(m)qsk*li28#孔0.5Um*qsk*li A*qpki*Um*qsk*li-102.26-20.81.46-1621.30.96-2624-1.74桩顶0.7-2.50.44 27.2842.829629.98072440.75.2-2.942.3101.2158.884111.2188600.77.5-5.241.166103.6
9、272.534-17026000.58.6-6.341.9133208.81104.405-28550000.510.5 -8.243.26 277.1435.047981.25 217.5235桩端-11.5-14217.2 -14.94-242Um*qsk*li=949.1906kNR=Um*qsk*li+A*qpk=1930.4406 kNUk=Um*qsk*li+A*qpk=535.66202 kN第 3 页，共 18页*32d2b397f13b1a5da22232a0299d38a7.xls*2022/7/13土层qsk(kPa)qpk(kPa)i土层深度(m)土层顶标高(m)土层厚
10、度li(m)qsk*li23#孔0.5Um*qsk*li A*qpki*Um*qsk*li-102.28-211.28桩顶0.7-2.52.62 000-1620.77.4-5.120000-2620.77.4-5.120000440.77.4-5.120000600.77.4-5.121.166103.6272.534-17026000.58.5-6.222.1147230.79115.395-28550000.510.6 -8.323.18 270.3424.371981.25 212.1855桩端-11.5-14217.5 -15.22-242Um*qsk*li=759.281kNR=U
11、m*qsk*li+A*qpk=1740.531kNUk=Um*qsk*li+A*qpk=400.1145 kN土层qsk(kPa)qpk(kPa)i土层深度(m)土层顶标高(m)土层厚度li(m)qsk*li13#孔0.5Um*qsk*li A*qpki*Um*qsk*li-102.6-20.62-1622.10.5-2624.4-1.8桩顶0.7-2.50.212.419.46813.6276440.75.3-2.71.566103.6272.534600.76.8-4.21.378122.4685.722-17026000.58.1-5.51.9133208.81104.405-28550
12、000.510-7.44.1348.5547.145981.25 273.5725桩端-11.5-14218.3 -15.7-242Um*qsk*li=1001.503kNR=Um*qsk*li+A*qpk=1982.753kN第 4 页，共 18页*32d2b397f13b1a5da22232a0299d38a7.xls*2022/7/13Uk=Um*qsk*li+A*qpk=549.8611 kN土层qsk(kPa)qpk(kPa)i土层深度(m)土层顶标高(m)土层厚度li(m)qsk*li8#孔0.5Um*qsk*li A*qpki*Um*qsk*li-103.44-21.12.34-
13、1622.60.84-2625.2-1.76桩顶0.7-2.50.16 9.9215.574410.90208440.76.1-2.662.296.8151.976106.3832600.78.3-4.860000-17026000.58.3-4.863.9273428.61214.305-28550000.512.2 -8.762.74 232.9365.653981.25 182.8265桩端-11.5-14219.1 -15.66-242Um*qsk*li=961.8134kNR=Um*qsk*li+A*qpk=1943.0634 kNUk=Um*qsk*li+A*qpk=514.416
14、78 kN土层qsk(kPa)qpk(kPa)i土层深度(m)土层顶标高(m)土层厚度li(m)qsk*li3#孔0.5Um*qsk*li A*qpki*Um*qsk*li-103.45-21.22.25-1622.90.55-2625.1-1.65桩顶0.7-2.50.05 3.14.8673.4069440.76-2.552.9127.6200.332140.2324600.78.9-5.450000-17026000.58.9-5.452.4168263.76131.88-28550000.511.3 -7.853.65 310.3487.0925981.25 243.54625桩端-1
15、1.5-14219.5 -16.05-242Um*qsk*li=956.0515kNR=Um*qsk*li+A*qpk=1937.3015 kN第 5 页，共 18页*32d2b397f13b1a5da22232a0299d38a7.xls*2022/7/13Uk=Um*qsk*li+A*qpk=519.06555 kN土层qsk(kPa)qpk(kPa)i土层深度(m)土层顶标高(m)土层厚度li(m)qsk*li35#孔0.5Um*qsk*li A*qpki*Um*qsk*li-102.48-20.91.58-1621.70.78-2624.2-1.72桩顶0.7-2.50.22 13.6
16、421.414814.99036440.75.2-2.721.252.882.89658.0272600.76.4-3.921.7102160.14112.098-17026000.58.1-5.622.3161252.77126.385-28550000.510.4 -7.923.58 304.3477.751981.25 238.8755桩端-11.5-14217.6 -15.12-242Um*qsk*li=994.9718kNR=Um*qsk*li+A*qpk=1976.2218 kNUk=Um*qsk*li+A*qpk=550.37606 kN土层qsk(kPa)qpk(kPa)i土层
17、深度(m)土层顶标高(m)土层厚度li(m)qsk*li30#孔0.5Um*qsk*li A*qpki*Um*qsk*li-102.42-20.51.92-1621.80.62-2624.2-1.78桩顶0.7-2.50.28 17.3627.255219.07864440.75.2-2.781.879.2124.34487.0408600.77-4.581.272113.0479.128-17026000.58.2-5.782.3161252.77126.385-28550000.510.5 -8.083.42 290.7456.399981.25 228.1995桩端-11.5-14217
18、-14.58-242Um*qsk*li=973.8082kN第 6 页，共 18页*32d2b397f13b1a5da22232a0299d38a7.xls*2022/7/13R=Um*qsk*li+A*qpk=1955.0582 kNUk=Um*qsk*li+A*qpk=539.83194 kN土层qsk(kPa)qpk(kPa)i土层深度(m)土层顶标高(m)土层厚度li(m)qsk*li25#孔0.5Um*qsk*li A*qpki*Um*qsk*li-102.41-20.42.01-1622.30.11-2624.1-1.69桩顶0.7-2.50.39 24.1837.962626.5
19、7382440.75.3-2.89288138.1696.712600.77.3-4.890.53047.132.97-17026000.57.8-5.392.5175274.75137.375-28550000.510.3 -7.893.61 306.9481.7545981.25 240.87725桩端-11.5-14217.3 -14.89-242Um*qsk*li=979.7271kNR=Um*qsk*li+A*qpk=1960.9771 kNUk=Um*qsk*li+A*qpk=534.50807 kN土层qsk(kPa)qpk(kPa)i土层深度(m)土层顶标高(m)土层厚度li(
20、m)qsk*li15#孔0.5Um*qsk*li A*qpki*Um*qsk*li-102.43-20.71.73-1621.60.83-2624.2-1.77桩顶0.7-2.50.07 4.346.81384.76966440.75-2.572.192.4145.068101.5476600.77.1-4.671.484131.8892.316-17026000.58.5-6.072140219.8109.9-28550000.510.5 -8.073.43 291.6457.7335981.25 228.86675桩端-11.5-14218.4 -15.97-242第 7 页，共 18页*
21、32d2b397f13b1a5da22232a0299d38a7.xls*2022/7/13Um*qsk*li=961.2953kNR=Um*qsk*li+A*qpk=1942.5453 kNUk=Um*qsk*li+A*qpk=537.40001 kN土层qsk(kPa)qpk(kPa)i土层深度(m)土层顶标高(m)土层厚度li(m)qsk*li10#孔0.5Um*qsk*li A*qpki*Um*qsk*li-102.63-20.42.23-1621.61.03-2624.2-1.57桩顶0.7-2.50.07 4.346.81384.76966440.75.2-2.573.8167.2
22、262.504183.7528600.79-6.370000-17026000.59-6.371.9133208.81104.405-28550000.510.9 -8.273.23 274.6431.0435981.25 215.52175桩端-11.5-14218.6 -15.97-242Um*qsk*li=909.1713kNR=Um*qsk*li+A*qpk=1890.4213 kNUk=Um*qsk*li+A*qpk=508.44921 kN土层qsk(kPa)qpk(kPa)i土层深度(m)土层顶标高(m)土层厚度li(m)qsk*li5#孔0.5Um*qsk*li A*qpki*
23、Um*qsk*li-102.7-22.30.4-1622.30.4-2624.4-1.7440.75-2.3桩顶0.7-2.51.879.2124.34487.0408600.77-4.32120188.4131.88-17026000.59-6.31.5105164.8582.425-28550000.510.5 -7.83.7314.5493.765981.25 246.8825桩端-11.5-14218.8 -16.1第 8 页，共 18页*32d2b397f13b1a5da22232a0299d38a7.xls*2022/7/13-242Um*qsk*li=971.359kNR=Um*
24、qsk*li+A*qpk=1952.609kNUk=Um*qsk*li+A*qpk=548.2283 kN第 9 页，共 18页土层qsk(kPa)qpk(kPa)土层深度(m)土层顶标高(m)土层厚度li(m)qsk*li31#孔0.40.45Um*qsk*li A*qpkUm*qsk*li A*qpk-102.470.6-20.61.870.7-1621.31.173186-2624.3-1.830.849.6桩顶-20.63 39.0662.49670.308445.1-2.631.879.2126.72142.56606.9-4.431.166105.6118.8-17026008-5
25、.532.7189302.4340.2-285500010.7 -8.233.77 320.5512.72800576.811012.5桩端-12-14217.8 -15.33-24224.6Um*qsk*li=1109.936kN1248.678 kNP=Um*qsk*li+A*qpk=1909.936kN2261.178 kN土层qsk(kPa)qpk(kPa)土层深度(m)土层顶标高(m)土层厚度li(m)qsk*li21#孔0.40.45Um*qsk*li A*qpkUm*qsk*li A*qpk-102.430.7-20.71.730.9-1621.60.832.7167.4-262
26、4.3-1.870.743.4桩顶-20.57 35.3456.54463.612445-2.572.7118.8190.08213.84607.7-5.270.63657.664.8-17026008.3-5.872.4168268.8302.4-285500010.7 -8.273.73 317.1507.28800570.691012.5桩端-12-14217.7 -15.27-24224.6Um*qsk*li=1080.304kN1215.342 kNP=Um*qsk*li+A*qpk=1880.304kN2227.842 kN1-1剖土层qsk(kPa)qpk(kPa)土层深度(m)
27、土层顶标高(m)土层厚度li(m)qsk*li11#孔0.40.45Um*qsk*li A*qpkUm*qsk*li A*qpk-102.50.8-20.81.71.1-1621.90.62.2136.4-2624.1-1.6162桩顶-20.637.259.5266.96445.1-2.60000605.1-2.62120192216-17026007.1-4.63.8266425.6478.8-285500010.9 -8.43.6306.0489.6800550.81012.5桩端-12-14218.3 -15.8-24224.6Um*qsk*li=1166.72kN1312.56kNP
28、=Um*qsk*li+A*qpk=1966.72kN2325.06kN土层qsk(kPa)qpk(kPa)土层深度(m)土层顶标高(m)土层厚度li(m)qsk*li1#孔0.40.45Um*qsk*li A*qpkUm*qsk*li A*qpk-102.140.5-20.51.640.8-1621.30.842.7167.4-2624-1.86162桩顶-20.86 53.3285.31295.976445-2.861.566105.6118.8606.5-4.362120192216-17026008.5-6.362140224252-285500010.5 -8.363.64 309.4
29、495.04800556.921012.5桩端-12-14217.8 -15.66-24224.2Um*qsk*li=1101.952kN1239.696 kNP=Um*qsk*li+A*qpk=1901.952kN2252.196 kN1-1剖土层qsk(kPa)qpk(kPa)土层深度(m)土层顶标高(m)土层厚度li(m)qsk*li33#孔0.40.45Um*qsk*li A*qpkUm*qsk*li A*qpk-102.460.9-20.91.560.6-1621.50.962.9179.8-2624.4-1.940.849.6桩顶-20.74 45.8873.40882.58444
30、5.2-2.742.7118.8190.08213.84607.9-5.442.5150240270-170260010.4 -7.940.1711.212.6-285500010.5 -8.043.96 336.6538.56800605.881012.5桩端-12-14217.8 -15.34-24224.5Um*qsk*li=1053.248kN1184.904 kNP=Um*qsk*li+A*qpk=1853.248kN2197.404 kN土层qsk(kPa)qpk(kPa)土层深度(m)土层顶标高(m)土层厚度li(m)qsk*li28#孔0.40.45Um*qsk*li A*qp
31、kUm*qsk*li A*qpk-102.2617.6-20.81.460.5-1621.30.962.7167.4-2624-1.741.274.4桩顶-20.94 58.2893.248104.904445.2-2.942.3101.2161.92182.16607.5-5.241.166105.6118.8-17026008.6-6.341.9133212.8239.4-285500010.5 -8.243.76 319.6511.36800575.281012.5桩端-12-14217.2 -14.94-242Um*qsk*li=1084.928kN1220.544 kNP=Um*qs
32、k*li+A*qpk=1884.928kN2233.044 kN2-2剖土层qsk(kPa)qpk(kPa)土层深度(m)土层顶标高(m)土层厚度li(m)qsk*li23#孔0.40.45Um*qsk*li A*qpkUm*qsk*li A*qpk-102.281-211.286.4桩顶-23.12 000-1627.4-5.120000-2627.4-5.120000447.4-5.120000607.4-5.121.166105.6118.8-17026008.5-6.222.1147235.2264.6-285500010.6 -8.323.68 312.8500.48800563.0
33、41012.5桩端-12-14217.5 -15.22-242Um*qsk*li=841.28kN946.44kNP=Um*qsk*li+A*qpk=1641.28kN1958.94kN土层qsk(kPa)qpk(kPa)土层深度(m)土层顶标高(m)土层厚度li(m)qsk*li13#孔0.40.45Um*qsk*li A*qpkUm*qsk*li A*qpk-102.60.6-20.621.5-1622.10.52.3142.6-2624.4-1.80.955.8桩顶-20.743.469.4478.12445.3-2.71.566105.6118.8606.8-4.21.378124.8
34、140.4-17026008.1-5.51.9133212.8239.4-285500010-7.44.6391.0625.6800703.81012.5桩端-12-14218.3 -15.7-242Um*qsk*li=1138.24kN1280.52kNP=Um*qsk*li+A*qpk=1938.24kN2293.02kN2-2剖土层qsk(kPa)qpk(kPa)土层深度(m)土层顶标高(m)土层厚度li(m)qsk*li8#孔0.40.45Um*qsk*li A*qpkUm*qsk*li A*qpk-103.441.1-21.12.341.5-1622.60.842.6161.2-26
35、25.2-1.760.955.8桩顶-20.66 40.9265.47273.656446.1-2.662.296.8154.88174.24608.3-4.860000-17026008.3-4.863.9273436.8491.4-285500012.2 -8.763.24 275.4440.64800495.721012.5桩端-12-14219.1 -15.66-242Um*qsk*li=1097.792kN1235.016 kNP=Um*qsk*li+A*qpk=1897.792kN2247.516 kN土层qsk(kPa)qpk(kPa)土层深度(m)土层顶标高(m)土层厚度li(
36、m)qsk*li3#孔0.40.45Um*qsk*li A*qpkUm*qsk*li A*qpk-103.451.2-21.22.251.7-1622.90.552.2136.4-2625.1-1.650.955.8桩顶-20.55 34.154.5661.38446-2.552.9127.6204.16229.68608.9-5.450000-17026008.9-5.452.4168268.8302.4-285500011.3 -7.854.15 352.8564.4800634.951012.5桩端-12-14219.5 -16.05-242Um*qsk*li=1091.92kN1228
37、.41kNP=Um*qsk*li+A*qpk=1891.92kN2240.91kN2-2剖土层qsk(kPa)qpk(kPa)土层深度(m)土层顶标高(m)土层厚度li(m)qsk*li35#孔0.40.45Um*qsk*li A*qpkUm*qsk*li A*qpk-102.480.9-20.91.580.8-1621.70.782.5155-2624.2-1.72162桩顶-20.72 44.6471.42480.352445.2-2.721.252.884.4895.04606.4-3.921.7102163.2183.6-17026008.1-5.622.3161257.6289.8-
38、285500010.4 -7.924.08 346.8554.88800624.241012.5桩端-12-14217.6 -15.12-242Um*qsk*li=1131.584kN1273.032 kNP=Um*qsk*li+A*qpk=1931.584kN2285.532 kN土层qsk(kPa)qpk(kPa)土层深度(m)土层顶标高(m)土层厚度li(m)qsk*li30#孔0.40.45Um*qsk*li A*qpkUm*qsk*li A*qpk-102.420.5-20.51.921.3-1621.80.622.4148.8-2624.2-1.78162桩顶-20.78 48.3
39、677.37687.048445.2-2.781.879.2126.72142.56607-4.581.272115.2129.6-17026008.2-5.782.3161257.6289.8-285500010.5 -8.083.92 333.2533.12800599.761012.5桩端-12-14217-14.58-242Um*qsk*li=1110.016kN1248.768 kNP=Um*qsk*li+A*qpk=1910.016kN2261.268 kN3-3剖土层qsk(kPa)qpk(kPa)土层深度(m)土层顶标高(m)土层厚度li(m)qsk*li25#孔0.40.45
40、Um*qsk*li A*qpkUm*qsk*li A*qpk-102.410.4-20.42.011.9-1622.30.111.8111.6-2624.1-1.691.274.4桩顶-20.89 55.1888.28899.324445.3-2.89288140.8158.4607.3-4.890.5304854-17026007.8-5.392.5175280315-285500010.3 -7.894.11 349.4558.96800628.831012.5桩端-12-14217.3 -14.89-242Um*qsk*li=1116.048kN1255.554 kNP=Um*qsk*l
41、i+A*qpk=1916.048kN2268.054 kN土层qsk(kPa)qpk(kPa)土层深度(m)土层顶标高(m)土层厚度li(m)qsk*li15#孔0.40.45Um*qsk*li A*qpkUm*qsk*li A*qpk-102.430.7-20.71.730.9-1621.60.832.6161.2-2624.2-1.770.849.6桩顶-20.57 35.3456.54463.612445-2.572.192.4147.84166.32607.1-4.671.484134.4151.2-17026008.5-6.072140224252-285500010.5 -8.07
42、3.93 334.1534.48800601.291012.5桩端-12-14218.4 -15.97-242Um*qsk*li=1097.264kN1234.422 kNP=Um*qsk*li+A*qpk=1897.264kN2246.922 kN3-3剖土层qsk(kPa)qpk(kPa)土层深度(m)土层顶标高(m)土层厚度li(m)qsk*li10#孔0.40.45Um*qsk*li A*qpkUm*qsk*li A*qpk-102.630.4-20.42.231.2-1621.61.032.6161.2-2624.2-1.57162桩顶-20.57 35.3456.54463.612
43、445.2-2.573.8167.2267.52300.96609-6.370000-17026009-6.371.9133212.8239.4-285500010.9 -8.273.73 317.1507.28800570.691012.5桩端-12-14218.6 -15.97-242Um*qsk*li=1044.144kN1174.662 kNP=Um*qsk*li+A*qpk=1844.144kN2187.162 kN土层qsk(kPa)qpk(kPa)土层深度(m)土层顶标高(m)土层厚度li(m)qsk*li5#孔0.40.45Um*qsk*li A*qpkUm*qsk*li A*
44、qpk-102.72.3-22.30.40-1622.30.42.1130.2-2624.4-1.70.637.2桩顶-20.318.629.7633.48445-2.3288140.8158.4607-4.32120192216-17026009-6.31.5105168189-285500010.5 -7.84.2357.0571.2800642.61012.5桩端-12-14218.8 -16.1-242Um*qsk*li=1101.76 kN1239.48 kNP=Um*qsk*li+A*qpk=1901.76 kN2251.98 kN3-3剖*32d2b397f13b1a5da222
45、32a0299d38a7.xls*2022/7/13土层qsk(kPa)qpk(kPa)土层深度(m)土层顶标高(m)土层厚度li(m)qsk*li0.42-12Um*qsk*liA*qpk-102.420.5-20.51.921.3-1621.80.622.4148.8238.08-2624.2-1.7816299.2445.2-2.781.879.2126.72607-4.581.272115.2-17026008.2-5.782.3161257.6416-285500010.5-8.086.5552.5884800-14217-14.587.3306.6490.56-24224.3-21.88000-180250024.3-21.881.310452715.52 400-280250025.6-23.1821607372840065200027.6-25.183.5227.5234416320-185300031.1-28.68000480-285500031.1-28.686.5552.510841388004437.6-35.1800第 18 页，共 18 页