人工挖孔桩计算excel表格

1、单单桩桩竖竖向向承承载载力力特特征征值值计计算算：根据建筑桩基技术规范（JGJ94-2008）5.3.6条：大直径桩单桩极限承载力标准值Quk=Qsk+Qpk=Usi*qsia*li+p*qpk*Ap单单桩桩承承载载力力特特征征值值Ra=Quk/2Ra=Quk/2( (注注：对对于于扩扩底底桩桩变变截截面面以以上上2d2d长长度度范范围围不不计计侧侧阻阻力力) ) 桩号桩身直径（mm）桩断面周长 U(m)桩断面A(m2)扩大头直径 (mm)扩大头断面Ap(m2)极限端阻力标准值qpk(kPa)大直径桩桩侧阻尺寸效应系数si大直径桩桩端阻尺寸效应系数p极限侧阻力标准值qsia(kPa)桩长Li（

2、m）qsia*li极限侧摩阻力标准值Qsk极限桩端承载力标准值Qpk承承载载力力特特征征值值RaRa桩号ZH126012003.7681.130422003.7994400040000.8740.714160348015801084862146214ZH1260ZH126012003.7681.130421003.46185400040000.8740.725160464021071003860726072ZH1260ZH126012003.7681.1304200038740.73716058002633925459445944ZH1260ZH126012003.7

3、681.1304200038740.73716069603160925462076207ZH1260ZH126012003.7681.130419002.83385400040000.8740.750160711203687849660916091ZH1260ZH126012003.7681.130419002.83385400040000.8740.750160812804213849663556355ZH1260ZH126012003.7681.130418002.5434400040000.8740.763160914404740776462526252ZH12

4、60ZH126012003.7681.130417002.26865400040000.8740.7781601016005267705861636163ZH1260ZH126012003.7681.130416002.0096400040000.8740.7941601117605793638060876087ZH1260ZH126012003.7681.130415001.76625400040000.8740.8111601219206320572960256025ZH1260ZH126012003.7681.130426005.3066160016000.8740.6751601219

5、206320573260266026ZH1260单单桩桩竖竖向向承承载载力力特特征征值值计计算算：根据建筑桩基技术规范（JGJ94-2008）5.3.6条：大直径桩单桩极限承载力标准值Quk=Qsk+Qpk=Usi*qsia*li+p*qpk*Ap单单桩桩承承载载力力特特征征值值Ra=Quk/2Ra=Quk/2 ( (注注：对对于于扩扩底底桩桩变变截截面面以以上上2d2d长长度度范范围围不不计计侧侧阻阻力力) ) 桩号桩身直径（mm）桩断面周长 U(m)桩断面A(m2)扩大头直径 (mm)扩大头断面Ap(m2)极限端阻力标准值qpk(kPa)大直径桩桩侧阻尺寸效应系数si大直径桩桩端阻尺寸效应

6、系数p极限侧阻力标准值qsia(kPa)桩长Li（m）qsia*li极限侧摩阻力标准值Qsk极限桩端承载力标准值Qpk承承载载力力特特征征值值RaRa桩号ZH08308002.5120.502414001.5386400040001.0000.83016034801206510731563156ZH0830ZH08308002.5120.502413001.32665400040001.0000.85116046401608451430613061ZH0830ZH08308002.5120.502413001.32665400040001.0000.8511605800201045143262

7、3262ZH0830ZH08308002.5120.502412001.1304400040001.0000.87416069602412395031813181ZH0830ZH08308002.5120.502412001.1304400040001.0000.874160711202813395033823382ZH0830ZH08308002.5120.502412001.1304400040001.0000.874160812803215395035833583ZH0830ZH08308002.5120.502412001.1304400040001.0000.874160914403

8、617395037843784ZH0830ZH08308002.5120.502412001.1304400040001.0000.8741601016004019395039853985ZH0830ZH08308002.5120.502412001.1304400040001.0000.8741601117604421395041864186ZH0830ZH08308002.5120.502412001.1304400040001.0000.8741601219204823395043874387ZH0830ZH08308002.5120.502412001.1304160016001.00

9、00.8741601219204823158032023202ZH0830单单桩桩竖竖向向承承载载力力特特征征值值计计算算：根据建筑桩基技术规范（JGJ94-2008）5.3.6条：大直径桩单桩极限承载力标准值Quk=Qsk+Qpk=Usi*qsia*li+p*qpk*Ap单单桩桩承承载载力力特特征征值值Ra=Quk/2Ra=Quk/2( (注注：对对于于扩扩底底桩桩变变截截面面以以上上2d2d长长度度范范围围不不计计侧侧阻阻力力) ) 桩号桩身直径（mm）桩断面周长 U(m)桩断面A(m2)扩大头直径 (mm)扩大头断面Ap(m2)极限端阻力标准值qpk(kPa)大直径桩桩侧阻尺寸效应系数s

10、i大直径桩桩端阻尺寸效应系数p极限侧阻力标准值qsia(kPa)桩长Li（m）qsia*li极限侧摩阻力标准值Qsk极限桩端承载力标准值Qpk承承载载力力特特征征值值RaRa桩号ZH08428002.5120.502418002.5434400040001.0000.76316034801206776444854485ZH0842ZH08428002.5120.502417002.26865400040001.0000.77816046401608705843334333ZH0842ZH08428002.5120.502417002.26865400040001.0000.7781605800

11、2010705845344534ZH0842ZH08428002.5120.502416002.0096400040001.0000.79416069602412638043964396ZH0842ZH08428002.5120.502415001.76625400040001.0000.811160711202813572942714271ZH0842ZH08428002.5120.502415001.76625400040001.0000.811160812803215572944724472ZH0842ZH08428002.5120.502414001.5386400040001.000

12、0.830160914403617510743624362ZH0842ZH08428002.5120.502413001.32665400040001.0000.8511601016004019451442664266ZH0842ZH08428002.5120.502412001.1304400040001.0000.8741601117604421395041864186ZH0842ZH08428002.5120.502412001.1304400040001.0000.8741601219204823395043874387ZH0842ZH08428002.5120.502420003.1

13、4160016001.0000.7371601219204823370242624262ZH0842单单桩桩竖竖向向承承载载力力特特征征值值计计算算：根据建筑桩基技术规范（JGJ94-2008）5.3.6条：大直径桩单桩极限承载力标准值Quk=Qsk+Qpk=Usi*qsia*li+p*qpk*Ap单单桩桩承承载载力力特特征征值值Ra=Quk/2Ra=Quk/2( (注注：对对于于扩扩底底桩桩变变截截面面以以上上2d2d长长度度范范围围不不计计侧侧阻阻力力) ) 桩号桩身直径（mm）桩断面周长 U(m)桩断面A(m2)扩大头直径 (mm)扩大头断面Ap(m2)极限端阻力标准值qpk(kPa)大

14、直径桩桩侧阻尺寸效应系数si大直径桩桩端阻尺寸效应系数p极限侧阻力标准值qsia(kPa)桩长Li（m）qsia*li极限侧摩阻力标准值Qsk极限桩端承载力标准值Qpk承承载载力力特特征征值值RaRa桩号ZH105410003.140.78521003.46185400040000.9280.725160348013991003857195719ZH1054ZH105410003.140.785200039280.73716046401866925455605560ZH1054ZH105410003.140.78519002.83385400040000.9280.7

15、5016058002332849654145414ZH1054ZH105410003.140.78519002.83385400040000.9280.75016069602798849656475647ZH1054ZH105410003.140.78518002.5434400040000.9280.763160711203265776455145514ZH1054ZH105410003.140.78517002.26865400040000.9280.778160812803731705853955395ZH1054ZH105410003.140.78517002.268654000400

16、00.9280.778160914404197705856285628ZH1054ZH105410003.140.78516002.0096400040000.9280.7941601016004664638055225522ZH1054ZH105410003.140.78515001.76625400040000.9280.8111601117605130572954305430ZH1054ZH105410003.140.78515001.76625400040000.9280.8111601219205597572956635663ZH1054ZH105410003.140.7852500

17、4.90625160016000.9280.6841601219205597536954835483ZH1054单单桩桩竖竖向向承承载载力力特特征征值值计计算算：根据建筑桩基技术规范（JGJ94-2008）5.3.6条：大直径桩单桩极限承载力标准值Quk=Qsk+Qpk=Usi*qsia*li+p*qpk*Ap单单桩桩承承载载力力特特征征值值Ra=Quk/2Ra=Quk/2( (注注：对对于于扩扩底底桩桩变变截截面面以以上上2d2d长长度度范范围围不不计计侧侧阻阻力力) ) 桩号桩身直径（mm）桩断面周长 U(m)桩断面A(m2)扩大头直径 (mm)扩大头断面Ap(m2)极限端阻力标准值qpk

18、(kPa)大直径桩桩侧阻尺寸效应系数si大直径桩桩端阻尺寸效应系数p极限侧阻力标准值qsia(kPa)桩长Li（m）qsia*li极限侧摩阻力标准值Qsk极限桩端承载力标准值Qpk承承载载力力特特征征值值RaRa桩号ZH105910003.140.78522003.7994400040000.9280.714160348013991084861236123ZH1059ZH105910003.140.78521003.46185400040000.9280.725160464018661003859525952ZH1059ZH105910003.140.78521003.461854000400

19、00.9280.725160580023321003861856185ZH1059ZH105910003.140.785200039280.73716069602798925460266026ZH1059ZH105910003.140.78519002.83385400040000.9280.750160711203265849658805880ZH1059ZH105910003.140.78519002.83385400040000.9280.750160812803731849661146114ZH1059ZH105910003.140.78518002.5434

20、400040000.9280.763160914404197776459815981ZH1059ZH105910003.140.78518002.5434400040000.9280.7631601016004664776462146214ZH1059ZH105910003.140.78517002.26865400040000.9280.7781601117605130705860946094ZH1059ZH105910003.140.78516002.0096400040000.9280.7941601219205597638059885988ZH1059ZH105910003.140.7

21、8528006.1544160016000.9280.6591601219205597648660416041ZH1059单单桩桩竖竖向向承承载载力力特特征征值值计计算算：根据建筑桩基技术规范（JGJ94-2008）5.3.6条：大直径桩单桩极限承载力标准值Quk=Qsk+Qpk=Usi*qsia*li+p*qpk*Ap单单桩桩承承载载力力特特征征值值Ra=Quk/2Ra=Quk/2( (注注：对对于于扩扩底底桩桩变变截截面面以以上上2d2d长长度度范范围围不不计计侧侧阻阻力力) ) 桩号桩身直径（mm）桩断面周长 U(m)桩断面A(m2)扩大头直径 (mm)扩大头断面Ap(m2)极限端阻力标

22、准值qpk(kPa)大直径桩桩侧阻尺寸效应系数si大直径桩桩端阻尺寸效应系数p极限侧阻力标准值qsia(kPa)桩长Li（m）qsia*li极限侧摩阻力标准值Qsk极限桩端承载力标准值Qpk承承载载力力特特征征值值RaRa桩号ZH127012003.7681.130424004.5216400040000.8740.693160348015801254070607060ZH1270ZH127012003.7681.130424004.5216400040000.8740.693160464021071254073247324ZH1270ZH127012003.7681.130423004.15

23、265400040000.8740.703160580026331168271587158ZH1270ZH127012003.7681.130422003.7994400040000.8740.714160696031601084870047004ZH1270ZH127012003.7681.130422003.7994400040000.8740.7141607112036871084872677267ZH1270ZH127012003.7681.130421003.46185400040000.8740.7251608128042131003871267126ZH1270ZH1270120

24、03.7681.1304200038740.737160914404740925469976997ZH1270ZH127012003.7681.1304200038740.7371601016005267925472607260ZH1270ZH127012003.7681.130419002.83385400040000.8740.7501601117605793849671457145ZH1270ZH127012003.7681.130418002.5434400040000.8740.763160121920632077647042704

25、2ZH1270ZH127012003.7681.130431007.54385160016000.8740.6371601219206320768570027002ZH1270单单桩桩竖竖向向承承载载力力特特征征值值计计算算：根据建筑桩基技术规范（JGJ94-2008）5.3.6条：大直径桩单桩极限承载力标准值Quk=Qsk+Qpk=Usi*qsia*li+p*qpk*Ap单单桩桩承承载载力力特特征征值值Ra=Quk/2Ra=Quk/2( (注注：对对于于扩扩底底桩桩变变截截面面以以上上2d2d长长度度范范围围不不计计侧侧阻阻力力) ) 桩号桩身直径（mm）桩断面周长 U(m)桩断面A(m2)

26、扩大头直径 (mm)扩大头断面Ap(m2)极限端阻力标准值qpk(kPa)大直径桩桩侧阻尺寸效应系数si大直径桩桩端阻尺寸效应系数p极限侧阻力标准值qsia(kPa)桩长Li（m）qsia*li极限侧摩阻力标准值Qsk极限桩端承载力标准值Qpk承承载载力力特特征征值值RaRa桩号ZH127712003.7681.130426005.3066400040000.8740.675160348015801433079557955ZH1277ZH127712003.7681.130425004.90625400040000.8740.684160464021071342377657765ZH1277Z

27、H127712003.7681.130425004.90625400040000.8740.684160580026331342380288028ZH1277ZH127712003.7681.130424004.5216400040000.8740.693160696031601254078507850ZH1277ZH127712003.7681.130423004.15265400040000.8740.7031607112036871168276847684ZH1277ZH127712003.7681.130423004.15265400040000.8740.70316081280421

28、31168279487948ZH1277ZH127712003.7681.130422003.7994400040000.8740.7141609144047401084877947794ZH1277ZH127712003.7681.130422003.7994400040000.8740.71416010160052671084880578057ZH1277ZH127712003.7681.130421003.46185400040000.8740.72516011176057931003879167916ZH1277ZH127712003.7681.130420003.1440004000

29、0.8740.7371601219206320925477877787ZH1277ZH127712003.7681.130435009.61625160016000.8740.6111601219206320940778647864ZH1277单单桩桩竖竖向向承承载载力力特特征征值值计计算算：根据建筑桩基技术规范（JGJ94-2008）5.3.6条：大直径桩单桩极限承载力标准值Quk=Qsk+Qpk=Usi*qsia*li+p*qpk*Ap单单桩桩承承载载力力特特征征值值Ra=Quk/2Ra=Quk/2( (注注：对对于于扩扩底底桩桩变变截截面面以以上上2d2d长长度度范范围围不不计计侧侧阻阻

30、力力) ) 桩号桩身直径（mm）桩断面周长 U(m)桩断面A(m2)扩大头直径 (mm)扩大头断面Ap(m2)极限端阻力标准值qpk(kPa)大直径桩桩侧阻尺寸效应系数si大直径桩桩端阻尺寸效应系数p极限侧阻力标准值qsia(kPa)桩长Li（m）qsia*li极限侧摩阻力标准值Qsk极限桩端承载力标准值Qpk承承载载力力特特征征值值RaRa桩号ZH104210003.140.78517002.26865400040000.9280.77816034801399705842294229ZH1042ZH104210003.140.78517002.26865400040000.9280.7781

31、6046401866705844624462ZH1042ZH104210003.140.78516002.0096400040000.9280.79416058002332638043564356ZH1042ZH104210003.140.78515001.76625400040000.9280.81116069602798572942644264ZH1042ZH104210003.140.78515001.76625400040000.9280.811160711203265572944974497ZH1042ZH104210003.140.78514001.5386400040000.92

32、80.830160812803731510744194419ZH1042ZH104210003.140.78513001.32665400040000.9280.851160914404197451443564356ZH1042ZH104210003.140.78512001.1304400040000.9280.8741601016004664395043074307ZH1042ZH104210003.140.78512001.1304400040000.9280.8741601117605130395045404540ZH1042ZH104210003.140.78512001.13044

33、00040000.9280.8741601219205597395047734773ZH1042ZH104210003.140.78517002.26865160016000.9280.7781601219205597282342104210ZH1042单单桩桩竖竖向向承承载载力力特特征征值值计计算算：根据建筑桩基技术规范（JGJ94-2008）5.3.6条：大直径桩单桩极限承载力标准值Quk=Qsk+Qpk=Usi*qsia*li+p*qpk*Ap单单桩桩承承载载力力特特征征值值Ra=Quk/2Ra=Quk/2( (注注：对对于于扩扩底底桩桩变变截截面面以以上上2d2d长长度度范范围围不不计

34、计侧侧阻阻力力) ) 桩号桩身直径（mm）桩断面周长 U(m)桩断面A(m2)扩大头直径 (mm)扩大头断面Ap(m2)极限端阻力标准值qpk(kPa)大直径桩桩侧阻尺寸效应系数si大直径桩桩端阻尺寸效应系数p极限侧阻力标准值qsia(kPa)桩长Li（m）qsia*li极限侧摩阻力标准值Qsk极限桩端承载力标准值Qpk承承载载力力特特征征值值RaRa桩号ZH125412003.7681.1304200038740.73716034801580925454175417ZH1254ZH125412003.7681.1304200038740.7

35、3716046402107925456805680ZH1254ZH125412003.7681.130419002.83385400040000.8740.75016058002633849655655565ZH1254ZH125412003.7681.130418002.5434400040000.8740.76316069603160776454625462ZH1254ZH125412003.7681.130418002.5434400040000.8740.763160711203687776457255725ZH1254ZH125412003.7681.130417002.26865400040000.8740.778160812804213705856365636ZH1254ZH125412003.7681.130416002.0096400040000.8740.794160914404740638055605560ZH1254ZH125412003.7681.130415001.76625400040000.8740.8111601016005267572954985498ZH1254ZH125412003.7681.130414001.53