挖孔桩自动计算模板（EXCEL）_xls.xls

《挖孔桩自动计算模板（EXCEL）_xls.xls》由会员分享，可在线阅读，更多相关《挖孔桩自动计算模板（EXCEL）_xls.xls（55页珍藏版）》请在沃文网上搜索。

1、k13挖挖孔孔桩桩基基础础结结算算数数据据记录号桩序号桩号设计桩顶标高挖孔桩上口标高挖孔桩底标高基 本 数 据土 石 方 量长宽半径桩断面积（M2）桩的周长（M）挖土石总高浇桩心砼总高挖土方高度（6m内）挖土方高度（8m内）挖土方高度（10m内）松次石（6m内)松次石（8m内)松次石（10m内)松次石12m内松次石14m内松次石16m内普坚石(6m内)普坚石(8m内)普坚石(10m内)普坚石(12m内)普坚石(14m内)普坚石(16m内)砼护壁高度护壁挖土方挖土方高度（6m内）挖土方高度（8m内）挖土方高度（10m内）松次石（6m内)pmna b r#VALUE!#VALUE!h1-1h1-2

2、h1-3h1-4h2-1h2-2h2-3h2-4 h3-1 h3-2 h3-3 h3-4h0-2#VALUE!#VALUE!#VALUE!16 ZJ1 乙楼梯269.7270.1266.30.61.13043.7683.83.43.800004.2955235 ZJ1 甲楼梯 269.7270.15266.090.61.13043.7684.063.610.33.760.339124.25030426 ZJ21269.7270.25260.650.50.7853.149.69.057.52.173.79305.8875026 ZJ32269.7270.4263.40.50.7853.1476.

3、34.82.24.32.333.7680026 ZJ43269.7270.3266.80.50.7853.143.52.91.12.400.863501.88419 ZJ14269.7270.2264.450.50.7853.145.755.250.75500.58875003.92519 ZJ15269.7270.2264.750.50.7853.145.454.950.74.7500.5495003.7287519 ZJ16269.7270.2265.050.50.7853.145.154.650.54.6500.3925003.6502519 ZJ17269.7270.2264.470.

4、50.7853.145.735.230.35.4300.2355004.2625526 ZJ18269.7270.15261.550.50.7853.148.68.156.52.15.953.22405.10250026 ZJ19269.7270.05264.350.50.7853.145.75.353.52.22.81.5172.7475001.72719 ZJ110269.7270.3265.830.50.7853.144.473.870.653.8200.51025002.998719 ZJ111269.7270.3265.750.50.7853.144.553.950.73.8500.

5、5495003.0222519 ZJ112269.7270.3265.970.50.7853.144.333.730.24.1300.157003.2420519 ZJ113269.7270.4266.060.50.7853.144.343.640.43.9400.314003.092919 ZJ114269.7270.2264.90.50.7853.145.34.80.44.900.314003.846535 ZJ115270.2270.2261.50.50.7853.148.78.76.725.93.1975.25950033 ZJ116270.2270.15264.60.50.7853.

6、145.555.63.651.93.651.9782.86525001.491519 ZJ117270.2270.35266.170.50.7853.144.184.031.452.730.950.5151.13825002.1430519 ZJ118270.2270.3265.10.50.7853.145.25.11.253.950.750.4060.98125003.1007519 ZJ119270.2270.2266.440.50.7853.143.763.760.553.2100.43175002.5198519 ZJ120269.7270.152660.50.7853.144.153

7、.70.43.7500.314002.9437520 ZJ121269.7270.3266.030.50.7853.144.273.670.553.7200.43175002.920239 ZJ122270.2270.1260.30.50.7853.149.89.97.827.23.9026.1230033 ZJ223270.2270262.820.50.7853.147.187.385.381.84.952.6834.223300020 ZJ224270.2270.15264.750.50.7853.145.45.452.482.922.351.2741.9468002.292220 ZJ2

8、25270.2270.2266.260.50.7853.143.943.941.42.540.90.4881.099001.993920 ZJ226270.2270.2266.10.50.7853.144.14.11.1300.8635002.35520 ZJ127269.7270.24266.290.50.7853.143.953.4112.9500.785002.3157527 ZJ128269.7270.35259.280.50.7853.1411.0710.428.872.28.364.53006.96295040 ZJ229269.7270.1260.250.50.7853.149.

9、859.458.11.7573.793006.3585038 ZJ130270.2270.1260.60.50.7853.149.59.67.81.76.63.57706.1230038 ZH231270.2270.1260.30.50.7853.149.89.981.87.23.90206.280041 ZH232270.2270.1260.70.50.7853.149.49.57.427.13.84805.8090040 ZJ133270.2270.1261.160.50.7853.148.949.047.141.86.63.57705.60490020 ZJ234270.2270.132

10、60.860.50.7853.149.279.347.072.263.25205.549950020 ZJ235270.2270.25262.880.50.7853.147.377.325.272.13.451.874.1369500020 ZJ236270.2270.2263.650.50.7853.146.556.553.852.72.91.5723.0222500020 ZJ237270.2270.32640.50.7853.146.36.22.93.42.91.5722.276500020 ZJ138270.2270.2265.20.50.7853.14552.62.41.851.00

11、32.041001.88420 ZJ139269.7270.2265.30.50.7853.144.94.41.83.101.413002.433538 ZJ140269.7270.3260.10.50.7853.1410.29.68.451.757.854.25406.63325038 ZJ141269.7270.4260.40.50.7853.14109.38.41.67.94.28106.594040 ZJ142269.7270.2260.70.50.7853.149.597.81.773.7936.123040 ZJ243269.7270.1260.80.50.7853.149.38.

12、97.51.873.7935.8875040 ZH244270.2270.1260.950.50.7853.149.159.257.451.773.7935.84825041 ZH245270.2270.1261.10.50.7853.1499.1726.63.5775.495035 ZJ146270.2270.05261.450.50.7853.148.68.756.81.86.83.6855.3380035 ZJ247270.2270.05260.550.50.7853.149.59.657.526.753.6585.88750020 ZJ248270.2270.05260.750.50.

13、7853.149.39.456.82.55.853.1705.3380020 ZJ249270.2270.15260.150.50.7853.141010.057.62.45.83.14305.9660021 ZJ250270.2270.1262.20.50.7853.147.985.52.43.92.1144.317500021 ZJ251270.2270.2263.40.50.7853.146.86.84.52.33.72.0053.532500021 ZJ152270.2270.2263.40.50.7853.146.86.83.353.452.91.5722.6297500038 ZJ

14、153269.7270.2260.80.50.7853.149.48.97.61.873.7935.9660027 ZJ154269.7270258.80.50.7853.1411.210.99.228.54.60607.222027 ZJ155269.7270259.10.50.7853.1410.910.68.82.18.34.49806.908041 ZH256270.2270.1260.30.50.7853.149.89.97.951.857.954.3086.24075038 ZH257270.2270.2260.920.50.7853.149.289.287.551.736.653

15、.6045.926750035 ZH258270.2270.05260.350.50.7853.149.79.857.52.27.353.9835.88750038 ZH259270.2270.05259.450.50.7853.1410.610.7591.67.954.3087.065021 ZJ260270.2270.1259.550.50.7853.1410.5510.658.352.284.335006.55475021 ZJ261270.2270.1259.020.50.7853.1411.0811.188.632.456.833.701006.77455021 ZJ262270.2

16、270.1259.950.50.7853.1410.1510.257.752.45.873.18106.083750021 ZJ263270.2270260.780.50.7853.149.229.426.622.65.12.76405.19670021 ZJ264270.2270.1262.150.50.7853.147.958.055.12.854.22.2764.003500038 ZJ165269.7270.2260.10.50.7853.1410.19.68.51.684.33506.6725038 ZJ266269.7270.2259.60.50.7853.1410.610.18.

17、6284.33506.751038 ZJ267269.7270.2260.30.50.7853.149.99.48.11.87.94.28106.3585038 ZJ268270.2270.1259.80.50.7853.1410.310.48.451.857.854.25406.63325040 ZH369270.2270.22600.50.7853.1410.210.28.451.757.74.17306.63325041 ZH370270.2270.25260.450.50.7853.149.89.7581.86.953.7666.28039 ZH271270.2270.05259.45

18、0.50.7853.1410.610.758.91.77.954.30806.9865021 ZJ272270.2270258.90.50.7853.1411.111.38.82.37.554.092006.908021 ZJ273270.2270.15258.750.50.7853.1411.411.4592.48.44.552007.065028 ZJ274270.2270.2259.10.50.7853.1411.111.192.18.94.823007.065021 ZJ275270.2270.2258.750.50.7853.1411.4511.459.22.257.654.1460

19、07.222021 ZJ176270.2270.2260.20.50.7853.1410107.72.36.13.30606.04450028 ZJ177270.2270.2261.60.50.7853.148.68.66.42.26.053.27905.0240022 ZJ178270.2270.2261.770.50.7853.148.438.435.832.64.982.6994.5765500012 ZJ179270.2270260.330.50.7853.149.679.877.871.852.7106.177950039 ZJ180269.7270.3262.050.50.7853

20、.148.257.656.41.8563.2525.0240039 ZJ281269.7270.1260.450.50.7853.149.659.258.051.67.54.06406.31925039 ZJ282269.7270.12600.50.7853.1410.19.78.31.87.64.11906.5155040 ZJ283270.2270.15260.150.50.7853.141010.058.31.77.64.11906.5155040 ZH284270.2270.1258.850.50.7853.1411.2511.359.521.738.44.55207.4732039

21、ZH285270.22702590.50.7853.141111.29.41.67.74.17307.379039 ZJ286270.2270259.60.50.7853.1410.410.68.61.87.74.17306.751039 ZJ287270.2270258.80.50.7853.1411.211.49.51.78.54.60607.4575027 ZJ288270.2270.1258.90.50.7853.1411.211.38.82.46.53.52306.908030 ZJ289270.2270.2259.10.50.7853.1411.111.18.92.27.54.06

22、406.9865027 ZH290270.2270.3259.40.50.7853.1410.910.891.98.954.8507.065027 ZH291270.2270.2258.70.50.7853.1411.511.59.32.28.74.71507.3005027 ZJ292270.2270.2258.50.50.7853.1411.711.79.62.19.35.0407.536012 ZJ293270.2270.2260.650.50.7853.149.559.557.851.773.79306.162250021 ZJ294270.2270.25264.880.50.7853

23、.145.375.323.352.022.81.5172.62975001.585727 ZJ195269.7270.1261.750.50.7853.148.357.9562.353.952.1414.7100039 ZJ296269.7270260.40.50.7853.149.69.37.6263.2525.9660039 ZJ297269.7270261.40.50.7853.148.68.36.81.86.33.4145.3380027 ZH298270.2270.2260.30.50.7853.149.99.98.051.858.054.362006.31925035 ZH2992

24、70.2270259.230.50.7853.1410.7710.978.7728.24.444006.88445035 ZH2 100270.2270258.960.50.7853.1411.0411.248.942.18.14.39007.0179040 ZJ1101270.2270258.50.50.7853.1411.511.79.22.394.87707.222028 ZJ1102269.7270258.70.50.7853.1411.3119.22.18.54.606007.222040 ZH2 103269.7270259.350.50.7853.1410.6510.358.55

25、2.18.34.4986.71175040 ZH2 104269.7270258.70.50.7853.1411.3119.12.28.34.4987.1435040 ZH2 105269.7270.1258.60.50.7853.1411.511.19.528.154.4177.4575041 ZH2 106269.7270.2258.850.50.7853.1411.3510.859.3528.94.8237.33975041 ZH1 107269.7270.1259.150.50.7853.1410.9510.558.752.27.74.1736.86875033 ZJ2108269.7

26、270258.420.50.7853.1411.5811.289.981.684.335007.8343027 ZJ2109269.7270.2261.450.50.7853.148.758.256.72.056.13.30605.25950028 ZJ1110269.7270.4263.950.50.7853.146.455.751.54.9510.5421.17750028 ZJ1111269.7270263.930.50.7853.146.075.7724.0710.5421.570040 ZH1 112269.7270259.750.50.7853.1410.259.958.351.9

27、7.54.0646.55475028 ZH1 113269.7270.05258.950.50.7853.1411.110.7592.18.774.75307.065027 ZH1 114269.7270.05258.750.50.7853.1411.310.959.51.88.74.71507.4575027 ZH1 115269.7270.2259.10.50.7853.1411.110.692.18.24.44407.065033 ZH1 116269.7270.15259.170.50.7853.1410.9810.539.181.88.24.44407.2063033 ZJ11172

28、69.7270.15259.020.50.7853.1411.1310.689.231.98.354.52507.24555027 ZJ1118269.7270.1259.70.50.7853.1410.4108.32.17.94.28106.5155016 ZJ14a119269.7270.1266.80.61.13043.7683.32.93.33.7303212 ZJ1146270.2270263.870.50.7853.146.136.3342.133.51.8973.1400012 ZJ1147270.2270.1261.430.50.7853.148.678.776.81.875.

29、52.98105.3380012 ZJ2156270.2270263.860.50.7853.146.146.344.441.742.1683.485400012 ZJ2157269.7270262.40.50.7853.147.67.35.81.84.952.6834.55300012 ZJ1158269.7270260.40.50.7853.149.69.37.81.86.953.76606.1230012 ZJ1167269.7270263.70.50.7853.146.364.51.83.932.133.532500012 ZJ1168269.7270260.620.50.7853.1

30、49.389.087.681.76.53.52306.02880012 ZJ1169269.7270261.050.50.7853.148.958.657.21.755.673.07305.6520023 ZJ1 车道1 269.7268.7262.550.50.7853.146.157.1533.152.251.2192.355002.4727523 ZJ1 车道2 269.7268.7263.40.50.7853.145.36.31.83.51.30.7051.413002.747523 ZJ1 车道3 269.7268.7265.150.50.7853.143.554.553.55000

31、2.78675383.686.92462207.342 340.705785.642244104.656松次石134.330.42361772.56972119.247土249.356.501003134.7723 221.4587砼 量钢 筋 量松次石（8m内)松次石（10m内)松次石12m内松次石14m内松次石16m内普坚石(6m内)普坚石(8m内)普坚石(10m内)普坚石(12m内)普坚石(14m内)普坚石(16m内)C20护壁C15砼垫层C30桩心主筋直径主筋数量 主筋重量箍筋直径 箍筋周长箍筋个数 箍筋重量加紧箍直径加紧箍重量钢筋网片直径钢筋网片重量（类型2）钢筋网片重量（类型1）护

32、壁钢筋直径#VALUE!#VALUE!#VALUE!#VALUE!d（mm）n#VALUE!d0#VALUE!#VALUE!d2#VALUE!d3#VALUE!d40000 0.120762823.9831528141459.9338992103.61682862.4838368128.6763270531024.035666900.120762824.2366262141463.4893103.61682964.7154024129.0137397721025.363953801.648503.65108044 0.084948677.70015921414 155.5911112102.9

33、88856103.26901761214.671576861051.528369461.727002.24280656 0.084948675.32625641414 109.0322912102.98884379.29585281211.020279451036.533341360000 0.084948672.3773568141451.4686592102.98882546.10224126.5059481091017.99403370000 0.084948674.3726384141491.2552872102.98883768.2313152129.6261477121030.80

34、796690000 0.084948674.1179216141486.1761432102.98883666.3872256129.2278243581029.17214560000 0.084948673.8632048141481.0969992102.98883462.6990464128.8295010051027.53632440000 0.084948674.3556573141490.9166776102.98883768.2313152129.5995928221030.698912101.648503.10341838 0.084948676.92084261414 140

35、.3536792102.98885295.89265921213.47660681046.620905660001.46043218 0.084948674.4979872141492.9483352102.98883870.0754048129.7589221631031.353240660000 0.084948673.2009411141467.8912248102.98883055.322688127.7938602851023.28318910000 0.084948673.2688656141469.2456632102.98883157.1667776127.9000798461

36、023.71940810000 0.084948673.0820733141465.5209576102.98883055.322688127.6079760541022.51980590000 0.084948673.0056582141463.9972144102.98882953.4785984127.4884790481022.02905950000 0.084948673.9905632141483.6365712102.98883564.543136129.0286626821028.35423501.5703.07733923 0.084948677.38710121414 14

37、9.6654432102.98885499.58083841214.206866281049.619911260001.90377766 0.084948674.7225286141497.1809552102.98883971.91949441210.090858291032.71642560000.49550377 0.084948673.3505119141470.6001016102.98883157.1667776128.0062994071024.155627160000.39118719 0.084948674.256113141488.7157152102.98883666.3

38、872256129.4269860351029.99005620000 0.084948673.107545141466.028872102.98883055.322688127.6478083891022.6833880000 0.084948673.0566016141465.0130432102.98882953.4785984127.5681437181022.35622370000 0.084948673.0311299141464.5051288102.98882953.4785984127.5283113831022.192641601.5703.75539703 0.08494

39、8678.42474561414 169.9820192102.988860110.6453761215.800159691056.163196261.413002.58183546 0.084948676.25262551414 127.3172096102.98884888.51630081212.454243521042.422297760001.22571986 0.084948674.576393141494.6413832102.98883870.0754048129.8916966141031.898514460000.46942463 0.084948673.273374614

40、1469.0763584102.98883157.1667776127.8868024011023.664880760000 0.084948673.396224141471.7852352102.98883157.1667776128.0992415231024.53731870000 0.084948672.8103754141460.103204102.98882851.6345088127.183097811020.7749299001.7274.36043321 0.084948678.88300981414 178.7858688102.988863116.17764481216.

41、490586841058.9986198601.3737503.65108044 0.084948678.03978161414 162.3633032102.988858106.95719681215.202674661053.7094644601.334503.44244727 0.084948678.16136241414 164.9028752102.988859108.80128641215.401836341054.527375601.41303.75539703 0.084948678.42474561414 169.9820192102.988860110.6453761215

42、.800159691056.1631962601.5703.70323873 0.084948678.08367881414 163.2098272102.988859108.80128641215.269061891053.9821012601.41303.44244727 0.084948677.6858911414 155.4218064102.988856103.26901761214.658299411051.473842601.72703.12949752 0.084948677.93194141414 160.5009504102.988858106.95719681215.05

43、6622771053.109663261.6485001.79946108 0.084948676.18001611414 126.3013808102.98884888.51630081212.374578851042.095133562.1195001.51259047 0.084948675.51829881414 113.2649112102.98884481.13994241211.352215581037.896525662.669001.51259047 0.084948675.22112921414 107.3392432102.98884277.45176321210.887

44、5051035.988067560000.9649284 0.084948674.1870958141487.0226672102.98883666.3872256129.2942115841029.444782560000 0.084948673.6509408141476.8643792102.98883360.8549568128.4975648771026.17314001.373754.09442592 0.084948678.17941741414 164.9028752102.988859108.80128641215.401836341054.527375601.25604.1

45、2050507 0.084948677.92542281414 159.8237312102.988858106.95719681215.003512991052.8915538601.334503.65108044 0.084948677.65770641414 154.7445872102.988856103.26901761214.605189631051.2557325601.41303.65108044 0.084948677.57280081414 153.0515392102.988855101.4249281214.472415181050.7104587601.334503.

46、65108044 0.084948677.86997041414 158.9772072102.988857105.11310721214.937125761052.61891696土 石 方 量01.5703.44244727 0.084948677.73683441414 156.4376352102.988856103.26901761214.737964081051.8010062601.41303.54676386 0.084948677.44255361414 150.5119672102.988855101.4249281214.27325351049.8925481601.57

47、03.52068471 0.084948678.20598181414 165.7493992102.988859108.80128641215.468223561054.8000119601.962503.05126008 0.084948678.0231711414 162.3633032102.988858106.95719681215.202674661053.7094644601.88403.02518094 0.084948678.53188241414 172.5215912102.988861112.48946561215.999321371056.981106961.8840

48、02.03417339 0.084948676.7638741414 137.8141072102.98885194.04856961213.277445121045.80299561.8055001.92985681 0.084948675.7421181414 117.4975312102.98884582.9840321211.684151711039.2597162.70825001.51259047 0.084948675.73056281414 117.4975312102.98884582.9840321211.684151711039.2597161.41303.6510804

49、4 0.084948677.57280081414 153.0515392102.988855101.4249281214.472415181050.7104587601.574.43345482 0.084948679.29257881414 186.9124992102.988865119.8658241217.12790421061.6159337601.64854.32913824 0.084948679.03497321414 181.8333552102.988864118.02173441216.729580851059.980112561.4522504.14658422 0.

50、084948678.43557861414 169.9820192102.988860110.6453761215.800159691056.163196261.3580503.46852642 0.084948677.89038671414 159.4851216102.988857105.11310721214.97695811052.78249961.72703.83363446 0.084948678.38445941414 169.1354952102.988860110.6453761215.733772471055.890559461.2564.14658422 0.084948