樁計算-建筑工程Excel計算工具

上傳人：大*** IP屬地：廣東上傳時間：2023-06-25 格式：XLS 頁數(shù)：18 大?。?75.50KB 積分：13 舉報 版權申訴

已閱讀5頁，還剩13頁未讀，繼續(xù)免費閱讀

版權說明：本文檔由用戶提供并上傳，收益歸屬內(nèi)容提供方，若內(nèi)容存在侵權，請進行舉報或認領

文檔簡介

土層,qsk(kPa),qpk(kPa),λi,土層深度(m),土層頂標高(m),土層厚度li(m),qsk*li,31#孔,,

,,,,,,,,0.5,,

,,,,,,,,Um*qsk*li,A*qpk,λi*Um*qsk*li

①-1,,,,0,2.47,,,,,

①-2,,,,0.6,1.87,,,,,

②-1,62,,,1.3,1.17,,,,,

②-2,62,,,4.3,-1.83,,,,,

樁頂,,,0.7,,-2.5,0.13,8.06,12.6542,,8.85794

③,44,,0.7,5.1,-2.63,1.8,79.2,124.344,,87.0408

④,60,,0.7,6.9,-4.43,1.1,66,103.62,,72.534

⑤-1,70,2600,0.5,8,-5.53,2.7,189,296.73,,148.365

⑤-2,85,5000,0.5,10.7,-8.23,3.27,278.0,436.3815,981.25,218.19075

樁端,,,,,-11.5,,,,,

⑥-1,42,,,17.8,-15.33,,,,,

⑥-2,42,,,,,,,,,

∑Um*qsk*li=,,,,,,,,973.7297,kN,

R=∑Um*qsk*li+A*qpk=,,,,,,,,1954.9797,kN,

Uk=∑Um*qsk*li+A*qpk=,,,,,,,,534.98849,kN,

,,,,,,,,,,,

土層,qsk(kPa),qpk(kPa),λi,土層深度(m),土層頂標高(m),土層厚度li(m),qsk*li,21#孔,,

,,,,,,,,0.5,,

,,,,,,,,Um*qsk*li,A*qpk,λi*Um*qsk*li

①-1,,,,0,2.43,,,,,

①-2,,,,0.7,1.73,,,,,

②-1,62,,,1.6,0.83,,,,,

②-2,62,,,4.3,-1.87,,,,,

樁頂,,,0.7,,-2.5,0.07,4.34,6.8138,,4.76966

③,44,,0.7,5,-2.57,2.7,118.8,186.516,,130.5612

④,60,,0.7,7.7,-5.27,0.6,36,56.52,,39.564

⑤-1,70,2600,0.5,8.3,-5.87,2.4,168,263.76,,131.88

⑤-2,85,5000,0.5,10.7,-8.27,3.23,274.6,431.0435,981.25,215.52175

樁端,,,,,-11.5,,,,,

⑥-1,42,,,17.7,-15.27,,,,,

⑥-2,42,,,,,,,,,

∑Um*qsk*li=,,,,,,,,944.6533,kN,

R=∑Um*qsk*li+A*qpk=,,,,,,,,1925.9033,kN,

Uk=∑Um*qsk*li+A*qpk=,,,,,,,,522.29661,kN,

,,,,,,,,,,,

土層,qsk(kPa),qpk(kPa),λi,土層深度(m),土層頂標高(m),土層厚度li(m),qsk*li,11#孔,,

,,,,,,,,0.5,,

,,,,,,,,Um*qsk*li,A*qpk,λi*Um*qsk*li

①-1,,,,0,2.5,,,,,

①-2,,,,0.7,1.8,,,,,

②-1,62,,,1.6,0.9,,,,,

②-2,62,,,4.3,-1.8,,,,,

樁頂,,,0.7,,-2.5,0,0,0,,0

③,44,,0.7,5,-2.5,2.7,118.8,186.516,,130.5612

④,60,,0.7,7.7,-5.2,0.6,36,56.52,,39.564

⑤-1,70,2600,0.5,8.3,-5.8,2.4,168,263.76,,131.88

⑤-2,85,5000,0.5,10.7,-8.2,3.3,280.5,440.385,981.25,220.1925

樁端,,,,,-11.5,,,,,

⑥-1,42,,,17.7,-15.2,,,,,

⑥-2,42,,,,,,,,,

∑Um*qsk*li=,,,,,,,,947.181,kN,

R=∑Um*qsk*li+A*qpk=,,,,,,,,1928.431,kN,

Uk=∑Um*qsk*li+A*qpk=,,,,,,,,522.1977,kN,

,,,,,,,,,,,

土層,qsk(kPa),qpk(kPa),λi,土層深度(m),土層頂標高(m),土層厚度li(m),qsk*li,1#孔,,

,,,,,,,,0.5,,

,,,,,,,,Um*qsk*li,A*qpk,λi*Um*qsk*li

①-1,,,,0,2.14,,,,,

①-2,,,,0.5,1.64,,,,,

②-1,62,,,1.3,0.84,,,,,

②-2,62,,,4,-1.86,,,,,

樁頂,,,0.7,,-2.5,0.36,22.32,35.0424,,24.52968

③,44,,0.7,5,-2.86,1.5,66,103.62,,72.534

④,60,,0.7,6.5,-4.36,2,120,188.4,,131.88

⑤-1,70,2600,0.5,8.5,-6.36,2,140,219.8,,109.9

⑤-2,85,5000,0.5,10.5,-8.36,3.14,266.9,419.033,981.25,209.5165

樁端,,,,,-11.5,,,,,

⑥-1,42,,,17.8,-15.66,,,,,

⑥-2,42,,,,,,,,,

∑Um*qsk*li=,,,,,,,,965.8954,kN,

R=∑Um*qsk*li+A*qpk=,,,,,,,,1947.1454,kN,

Uk=∑Um*qsk*li+A*qpk=,,,,,,,,548.36018,kN,

,,,,,,,,,,,

土層,qsk(kPa),qpk(kPa),λi,土層深度(m),土層頂標高(m),土層厚度li(m),qsk*li,33#孔,,

,,,,,,,,0.5,,

,,,,,,,,Um*qsk*li,A*qpk,λi*Um*qsk*li

①-1,,,,0,2.46,,,,,

①-2,,,,0.9,1.56,,,,,

②-1,62,,,1.5,0.96,,,,,

②-2,62,,,4.4,-1.94,,,,,

樁頂,,,0.7,,-2.5,0.24,14.88,23.3616,,16.35312

③,44,,0.7,5.2,-2.74,2.7,118.8,186.516,,130.5612

④,60,,0.7,7.9,-5.44,2.5,150,235.5,,164.85

⑤-1,70,2600,0.5,10.4,-7.94,0.1,7,10.99,,5.495

⑤-2,85,5000,0.5,10.5,-8.04,3.46,294.1,461.737,981.25,230.8685

樁端,,,,,-11.5,,,,,

⑥-1,42,,,17.8,-15.34,,,,,

⑥-2,42,,,,,,,,,

∑Um*qsk*li=,,,,,,,,918.1046,kN,

R=∑Um*qsk*li+A*qpk=,,,,,,,,1899.3546,kN,

Uk=∑Um*qsk*li+A*qpk=,,,,,,,,548.12782,kN,

,,,,,,,,,,,

土層,qsk(kPa),qpk(kPa),λi,土層深度(m),土層頂標高(m),土層厚度li(m),qsk*li,28#孔,,

,,,,,,,,0.5,,

,,,,,,,,Um*qsk*li,A*qpk,λi*Um*qsk*li

①-1,,,,0,2.26,,,,,

①-2,,,,0.8,1.46,,,,,

②-1,62,,,1.3,0.96,,,,,

②-2,62,,,4,-1.74,,,,,

樁頂,,,0.7,,-2.5,0.44,27.28,42.8296,,29.98072

③,44,,0.7,5.2,-2.94,2.3,101.2,158.884,,111.2188

④,60,,0.7,7.5,-5.24,1.1,66,103.62,,72.534

⑤-1,70,2600,0.5,8.6,-6.34,1.9,133,208.81,,104.405

⑤-2,85,5000,0.5,10.5,-8.24,3.26,277.1,435.047,981.25,217.5235

樁端,,,,,-11.5,,,,,

⑥-1,42,,,17.2,-14.94,,,,,

⑥-2,42,,,,,,,,,

∑Um*qsk*li=,,,,,,,,949.1906,kN,

R=∑Um*qsk*li+A*qpk=,,,,,,,,1930.4406,kN,

Uk=∑Um*qsk*li+A*qpk=,,,,,,,,535.66202,kN,

,,,,,,,,,,,

土層,qsk(kPa),qpk(kPa),λi,土層深度(m),土層頂標高(m),土層厚度li(m),qsk*li,23#孔,,

,,,,,,,,0.5,,

,,,,,,,,Um*qsk*li,A*qpk,λi*Um*qsk*li

①-1,,,,0,2.28,,,,,

①-2,,,,1,1.28,,,,,

樁頂,,,0.7,,-2.5,2.62,0,0,,0

②-1,62,,0.7,7.4,-5.12,0,0,0,,0

②-2,62,,0.7,7.4,-5.12,0,0,0,,0

③,44,,0.7,7.4,-5.12,0,0,0,,0

④,60,,0.7,7.4,-5.12,1.1,66,103.62,,72.534

⑤-1,70,2600,0.5,8.5,-6.22,2.1,147,230.79,,115.395

⑤-2,85,5000,0.5,10.6,-8.32,3.18,270.3,424.371,981.25,212.1855

樁端,,,,,-11.5,,,,,

⑥-1,42,,,17.5,-15.22,,,,,

⑥-2,42,,,,,,,,,

∑Um*qsk*li=,,,,,,,,759.281,kN,

R=∑Um*qsk*li+A*qpk=,,,,,,,,1740.531,kN,

Uk=∑Um*qsk*li+A*qpk=,,,,,,,,400.1145,kN,

,,,,,,,,,,,

土層,qsk(kPa),qpk(kPa),λi,土層深度(m),土層頂標高(m),土層厚度li(m),qsk*li,13#孔,,

,,,,,,,,0.5,,

,,,,,,,,Um*qsk*li,A*qpk,λi*Um*qsk*li

①-1,,,,0,2.6,,,,,

①-2,,,,0.6,2,,,,,

②-1,62,,,2.1,0.5,,,,,

②-2,62,,,4.4,-1.8,,,,,

樁頂,,,0.7,,-2.5,0.2,12.4,19.468,,13.6276

③,44,,0.7,5.3,-2.7,1.5,66,103.62,,72.534

④,60,,0.7,6.8,-4.2,1.3,78,122.46,,85.722

⑤-1,70,2600,0.5,8.1,-5.5,1.9,133,208.81,,104.405

⑤-2,85,5000,0.5,10,-7.4,4.1,348.5,547.145,981.25,273.5725

樁端,,,,,-11.5,,,,,

⑥-1,42,,,18.3,-15.7,,,,,

⑥-2,42,,,,,,,,,

∑Um*qsk*li=,,,,,,,,1001.503,kN,

R=∑Um*qsk*li+A*qpk=,,,,,,,,1982.753,kN,

Uk=∑Um*qsk*li+A*qpk=,,,,,,,,549.8611,kN,

,,,,,,,,,,,

土層,qsk(kPa),qpk(kPa),λi,土層深度(m),土層頂標高(m),土層厚度li(m),qsk*li,8#孔,,

,,,,,,,,0.5,,

,,,,,,,,Um*qsk*li,A*qpk,λi*Um*qsk*li

①-1,,,,0,3.44,,,,,

①-2,,,,1.1,2.34,,,,,

②-1,62,,,2.6,0.84,,,,,

②-2,62,,,5.2,-1.76,,,,,

樁頂,,,0.7,,-2.5,0.16,9.92,15.5744,,10.90208

③,44,,0.7,6.1,-2.66,2.2,96.8,151.976,,106.3832

④,60,,0.7,8.3,-4.86,0,0,0,,0

⑤-1,70,2600,0.5,8.3,-4.86,3.9,273,428.61,,214.305

⑤-2,85,5000,0.5,12.2,-8.76,2.74,232.9,365.653,981.25,182.8265

樁端,,,,,-11.5,,,,,

⑥-1,42,,,19.1,-15.66,,,,,

⑥-2,42,,,,,,,,,

∑Um*qsk*li=,,,,,,,,961.8134,kN,

R=∑Um*qsk*li+A*qpk=,,,,,,,,1943.0634,kN,

Uk=∑Um*qsk*li+A*qpk=,,,,,,,,514.41678,kN,

,,,,,,,,,,,

土層,qsk(kPa),qpk(kPa),λi,土層深度(m),土層頂標高(m),土層厚度li(m),qsk*li,3#孔,,

,,,,,,,,0.5,,

,,,,,,,,Um*qsk*li,A*qpk,λi*Um*qsk*li

①-1,,,,0,3.45,,,,,

①-2,,,,1.2,2.25,,,,,

②-1,62,,,2.9,0.55,,,,,

②-2,62,,,5.1,-1.65,,,,,

樁頂,,,0.7,,-2.5,0.05,3.1,4.867,,3.4069

③,44,,0.7,6,-2.55,2.9,127.6,200.332,,140.2324

④,60,,0.7,8.9,-5.45,0,0,0,,0

⑤-1,70,2600,0.5,8.9,-5.45,2.4,168,263.76,,131.88

⑤-2,85,5000,0.5,11.3,-7.85,3.65,310.3,487.0925,981.25,243.54625

樁端,,,,,-11.5,,,,,

⑥-1,42,,,19.5,-16.05,,,,,

⑥-2,42,,,,,,,,,

∑Um*qsk*li=,,,,,,,,956.0515,kN,

R=∑Um*qsk*li+A*qpk=,,,,,,,,1937.3015,kN,

Uk=∑Um*qsk*li+A*qpk=,,,,,,,,519.06555,kN,

,,,,,,,,,,,

土層,qsk(kPa),qpk(kPa),λi,土層深度(m),土層頂標高(m),土層厚度li(m),qsk*li,35#孔,,

,,,,,,,,0.5,,

,,,,,,,,Um*qsk*li,A*qpk,λi*Um*qsk*li

①-1,,,,0,2.48,,,,,

①-2,,,,0.9,1.58,,,,,

②-1,62,,,1.7,0.78,,,,,

②-2,62,,,4.2,-1.72,,,,,

樁頂,,,0.7,,-2.5,0.22,13.64,21.4148,,14.99036

③,44,,0.7,5.2,-2.72,1.2,52.8,82.896,,58.0272

④,60,,0.7,6.4,-3.92,1.7,102,160.14,,112.098

⑤-1,70,2600,0.5,8.1,-5.62,2.3,161,252.77,,126.385

⑤-2,85,5000,0.5,10.4,-7.92,3.58,304.3,477.751,981.25,238.8755

樁端,,,,,-11.5,,,,,

⑥-1,42,,,17.6,-15.12,,,,,

⑥-2,42,,,,,,,,,

∑Um*qsk*li=,,,,,,,,994.9718,kN,

R=∑Um*qsk*li+A*qpk=,,,,,,,,1976.2218,kN,

Uk=∑Um*qsk*li+A*qpk=,,,,,,,,550.37606,kN,

,,,,,,,,,,,

土層,qsk(kPa),qpk(kPa),λi,土層深度(m),土層頂標高(m),土層厚度li(m),qsk*li,30#孔,,

,,,,,,,,0.5,,

,,,,,,,,Um*qsk*li,A*qpk,λi*Um*qsk*li

①-1,,,,0,2.42,,,,,

①-2,,,,0.5,1.92,,,,,

②-1,62,,,1.8,0.62,,,,,

②-2,62,,,4.2,-1.78,,,,,

樁頂,,,0.7,,-2.5,0.28,17.36,27.2552,,19.07864

③,44,,0.7,5.2,-2.78,1.8,79.2,124.344,,87.0408

④,60,,0.7,7,-4.58,1.2,72,113.04,,79.128

⑤-1,70,2600,0.5,8.2,-5.78,2.3,161,252.77,,126.385

⑤-2,85,5000,0.5,10.5,-8.08,3.42,290.7,456.399,981.25,228.1995

樁端,,,,,-11.5,,,,,

⑥-1,42,,,17,-14.58,,,,,

⑥-2,42,,,,,,,,,

∑Um*qsk*li=,,,,,,,,973.8082,kN,

R=∑Um*qsk*li+A*qpk=,,,,,,,,1955.0582,kN,

Uk=∑Um*qsk*li+A*qpk=,,,,,,,,539.83194,kN,

,,,,,,,,,,,

土層,qsk(kPa),qpk(kPa),λi,土層深度(m),土層頂標高(m),土層厚度li(m),qsk*li,25#孔,,

,,,,,,,,0.5,,

,,,,,,,,Um*qsk*li,A*qpk,λi*Um*qsk*li

①-1,,,,0,2.41,,,,,

①-2,,,,0.4,2.01,,,,,

②-1,62,,,2.3,0.11,,,,,

②-2,62,,,4.1,-1.69,,,,,

樁頂,,,0.7,,-2.5,0.39,24.18,37.9626,,26.57382

③,44,,0.7,5.3,-2.89,2,88,138.16,,96.712

④,60,,0.7,7.3,-4.89,0.5,30,47.1,,32.97

⑤-1,70,2600,0.5,7.8,-5.39,2.5,175,274.75,,137.375

⑤-2,85,5000,0.5,10.3,-7.89,3.61,306.9,481.7545,981.25,240.87725

樁端,,,,,-11.5,,,,,

⑥-1,42,,,17.3,-14.89,,,,,

⑥-2,42,,,,,,,,,

∑Um*qsk*li=,,,,,,,,979.7271,kN,

R=∑Um*qsk*li+A*qpk=,,,,,,,,1960.9771,kN,

Uk=∑Um*qsk*li+A*qpk=,,,,,,,,534.50807,kN,

,,,,,,,,,,,

土層,qsk(kPa),qpk(kPa),λi,土層深度(m),土層頂標高(m),土層厚度li(m),qsk*li,15#孔,,

,,,,,,,,0.5,,

,,,,,,,,Um*qsk*li,A*qpk,λi*Um*qsk*li

①-1,,,,0,2.43,,,,,

①-2,,,,0.7,1.73,,,,,

②-1,62,,,1.6,0.83,,,,,

②-2,62,,,4.2,-1.77,,,,,

樁頂,,,0.7,,-2.5,0.07,4.34,6.8138,,4.76966

③,44,,0.7,5,-2.57,2.1,92.4,145.068,,101.5476

④,60,,0.7,7.1,-4.67,1.4,84,131.88,,92.316

⑤-1,70,2600,0.5,8.5,-6.07,2,140,219.8,,109.9

⑤-2,85,5000,0.5,10.5,-8.07,3.43,291.6,457.7335,981.25,228.86675

樁端,,,,,-11.5,,,,,

⑥-1,42,,,18.4,-15.97,,,,,

⑥-2,42,,,,,,,,,

∑Um*qsk*li=,,,,,,,,961.2953,kN,

R=∑Um*qsk*li+A*qpk=,,,,,,,,1942.5453,kN,

Uk=∑Um*qsk*li+A*qpk=,,,,,,,,537.40001,kN,

,,,,,,,,,,,

土層,qsk(kPa),qpk(kPa),λi,土層深度(m),土層頂標高(m),土層厚度li(m),qsk*li,10#孔,,

,,,,,,,,0.5,,

,,,,,,,,Um*qsk*li,A*qpk,λi*Um*qsk*li

①-1,,,,0,2.63,,,,,

①-2,,,,0.4,2.23,,,,,

②-1,62,,,1.6,1.03,,,,,

②-2,62,,,4.2,-1.57,,,,,

樁頂,,,0.7,,-2.5,0.07,4.34,6.8138,,4.76966

③,44,,0.7,5.2,-2.57,3.8,167.2,262.504,,183.7528

④,60,,0.7,9,-6.37,0,0,0,,0

⑤-1,70,2600,0.5,9,-6.37,1.9,133,208.81,,104.405

⑤-2,85,5000,0.5,10.9,-8.27,3.23,274.6,431.0435,981.25,215.52175

樁端,,,,,-11.5,,,,,

⑥-1,42,,,18.6,-15.97,,,,,

⑥-2,42,,,,,,,,,

∑Um*qsk*li=,,,,,,,,909.1713,kN,

R=∑Um*qsk*li+A*qpk=,,,,,,,,1890.4213,kN,

Uk=∑Um*qsk*li+A*qpk=,,,,,,,,508.44921,kN,

,,,,,,,,,,,

土層,qsk(kPa),qpk(kPa),λi,土層深度(m),土層頂標高(m),土層厚度li(m),qsk*li,5#孔,,

,,,,,,,,0.5,,

,,,,,,,,Um*qsk*li,A*qpk,λi*Um*qsk*li

①-1,,,,0,2.7,,,,,

①-2,,,,2.3,0.4,,,,,

②-1,62,,,2.3,0.4,,,,,

②-2,62,,,4.4,-1.7,,,,,

③,44,,0.7,5,-2.3,,,,,

樁頂,,,0.7,,-2.5,1.8,79.2,124.344,,87.0408

④,60,,0.7,7,-4.3,2,120,188.4,,131.88

⑤-1,70,2600,0.5,9,-6.3,1.5,105,164.85,,82.425

⑤-2,85,5000,0.5,10.5,-7.8,3.7,314.5,493.765,981.25,246.8825

樁端,,,,,-11.5,,,,,

⑥-1,42,,,18.8,-16.1,,,,,

⑥-2,42,,,,,,,,,

∑Um*qsk*li=,,,,,,,,971.359,kN,

R=∑Um*qsk*li+A*qpk=,,,,,,,,1952.609,kN,

Uk=∑Um*qsk*li+A*qpk=,,,,,,,,548.2283,kN,

,,,,,,,,,,,

,,,,,,,,,,

人人文庫> 全部分類> 圖紙下載 > 其他類型

溫馨提示

1. 本站所有資源如無特殊說明，都需要本地電腦安裝OFFICE2007和PDF閱讀器。圖紙軟件為CAD,CAXA,PROE,UG,SolidWorks等.壓縮文件請下載最新的WinRAR軟件解壓。
2. 本站的文檔不包含任何第三方提供的附件圖紙等，如果需要附件，請聯(lián)系上傳者。文件的所有權益歸上傳用戶所有。
3. 本站RAR壓縮包中若帶圖紙，網(wǎng)頁內(nèi)容里面會有圖紙預覽，若沒有圖紙預覽就沒有圖紙。
4. 未經(jīng)權益所有人同意不得將文件中的內(nèi)容挪作商業(yè)或盈利用途。
5. 人人文庫網(wǎng)僅提供信息存儲空間，僅對用戶上傳內(nèi)容的表現(xiàn)方式做保護處理，對用戶上傳分享的文檔內(nèi)容本身不做任何修改或編輯，并不能對任何下載內(nèi)容負責。
6. 下載文件中如有侵權或不適當內(nèi)容，請與我們聯(lián)系，我們立即糾正。
7. 本站不保證下載資源的準確性、安全性和完整性, 同時也不承擔用戶因使用這些下載資源對自己和他人造成任何形式的傷害或損失。

樁計算-建筑工程Excel計算工具

文檔簡介

溫馨提示

最新文檔

評論

樁計算-建筑工程Excel計算工具

文檔簡介

溫馨提示

最新文檔

評論

相關文檔