直墙半圆巷道材料使用计算表.xls

断面（m）顶弧（m）墙高（m）底弧（m）周长（m） 锚杆锚索 根/圈根/米率根/圈 2.03.1422.42.1457.68712.8121.350.133 2.13.2992.42.2527.95113.2522.090.133 2.23.4562.42.368.21613.6922.820.143 2.33.6132.42.4678.4814.1323.560.143 2.43.772.42.5748.74414.5724.290.153 2.53.9272.42.6188.94514.9124.850.153 2.64.0842.42.7899.27315.4625.760.153 2.74.2412.42.8969.53715.9026.490.163 2.84.3982.43.0039.80116.3427.230.163 2.94.5552.43.1110.06516.7827.960.173 3.04.7122.43.21810.3317.2228.690.173 3.14.8692.43.32410.59317.6629.430.185 3.25.0272.43.43210.85918.1030.160.185 3.35.1842.43.53911.12318.5430.900.195 3.45.3412.43.64711.38818.9831.630.195 3.55.4982.43.75411.65219.4232.370.195 3.65.6552.43.86111.91619.8633.100.205 3.75.8122.43.96812.1820.3033.830.205 3.85.9692.44.07612.44520.7434.570.215 3.96.1262.44.18312.70921.1835.300.215 4.06.2832.44.2912.97321.6236.040.225 4.16.442.44.39713.23722.0636.770.225 4.26.5972.44.50513.50222.5037.510.235 4.36.7542.44.61213.76622.9438.240.235 4.46.9122.44.71914.03123.3938.980.235 4.57.0692.44.82614.29523.8339.710.245 4.67.2262.44.93414.5624.2740.440.247 4.77.3832.45.04114.82424.7141.180.257 4.87.542.45.14815.08825.1541.910.257 4.97.6972.45.22515.32225.5442.560.267 5.07.8542.45.36215.61626.0343.380.267 5.18.0112.45.4715.88126.4744.110.267 5.28.1682.45.57816.14626.9144.850.277 5.38.3252.45.68416.40927.3545.580.277 5.48.4822.45.79216.67427.7946.320.287 5.58.6392.45.89916.93828.2347.050.287 5.68.7962.46.00617.20228.6747.780.297 5.78.9542.46.11317.46729.1148.520.297 5.89.112.46.2217.7329.5549.250.307 5.99.2682.46.32817.99629.9949.990.307 钢网锚固剂桁架 根/米率片/圈片/米率 锚杆锚索合计锚杆 根/米根/米根/米根/圈 2.56.416.410.0321.355.0026.353.29 2.56.636.630.0322.095.0027.093.40 2.56.856.850.0322.825.0027.823.51 2.57.077.070.0323.565.0028.563.62 2.57.297.290.0324.295.0029.293.73 2.57.457.450.0324.855.0029.853.81 2.57.737.730.0325.765.0030.763.95 2.57.957.950.0326.495.0031.494.06 2.58.178.170.0327.235.0032.234.17 2.58.398.390.0327.965.0032.964.28 2.58.618.610.0328.695.0033.694.39 4.178.838.830.0429.438.3337.764.50 4.179.059.050.0430.168.3338.504.61 4.179.279.270.0430.908.3339.234.72 4.179.499.490.0431.638.3339.974.83 4.179.719.710.0432.378.3340.704.94 4.179.939.930.0433.108.3341.435.05 4.1710.1510.150.0433.838.3342.175.16 4.1710.3710.370.0434.578.3342.905.27 4.1710.5910.590.0435.308.3343.645.38 4.1710.8110.810.0436.048.3344.375.49 4.1711.0311.030.0436.778.3345.105.60 4.1711.2511.250.0537.518.3345.845.71 4.1711.4711.470.0538.248.3346.575.82 4.1711.6911.690.0538.988.3347.315.93 4.1711.9111.910.0539.718.3348.046.04 5.8312.1312.130.0540.4411.6752.116.15 5.8312.3512.350.0541.1811.6752.846.26 5.8312.5712.570.0541.9111.6753.586.37 5.8312.7712.770.0542.5611.6754.236.47 5.8313.0113.010.0543.3811.6755.046.59 5.8313.2313.230.0544.1111.6755.786.70 5.8313.4613.460.0544.8511.6756.526.81 5.8313.6713.670.0545.5811.6757.256.92 5.8313.9013.900.0646.3211.6757.987.03 5.8314.1214.120.0647.0511.6758.727.14 5.8314.3414.340.0647.7811.6759.457.25 5.8314.5614.560.0648.5211.6760.197.36 5.8314.7814.780.0649.2511.6760.927.47 5.8315.0015.000.0649.9911.6761.667.58 锚索 U25型钢 锚索合计 公斤/架公斤/米率 根/米根/圈根/米根/米 5.4810.836.312122650.27 5.6610.836.492192730.27 5.8410.836.682252820.28 6.0310.836.862322900.29 6.2110.837.042392980.30 6.3510.837.182443050.30 6.5810.837.412523150.31 6.7610.837.602583230.32 6.9510.837.782653310.33 7.1310.837.962723400.34 7.3110.838.152783480.35 7.5021.679.162853560.36 7.6821.679.352913640.36 7.8621.679.532983730.37 8.0521.679.713053810.38 8.2321.679.903113890.39 8.4121.6710.083183970.40 8.6021.6710.263254060.41 8.7821.6710.453314140.41 8.9621.6710.633384220.42 9.1521.6710.813444300.43 9.3321.6711.003514390.44 9.5221.6711.183584470.45 9.7021.6711.373644550.46 9.8821.6711.553714630.46 10.0721.6711.733774720.47 10.2532.5012.753844800.48 10.4332.5012.933914880.49 10.6232.5013.123974970.50 10.7832.5013.284035040.50 10.9832.5013.484105130.51 11.1732.5013.674175210.52 11.3532.5013.854245300.53 11.5332.5014.034305380.54 11.7232.5014.224375460.55 11.9032.5014.404435540.55 12.0832.5014.584505630.56 12.2732.5014.774575710.57 12.4532.5014.954635790.58 12.6432.5015.144705870.59 桁架 锚杆 断面（m）顶弧（m）墙高（m）周长（m） 锚杆锚索 根/圈根/米率根/圈根/米 2.03.1422.45.5429.2415.390.0932.5 2.13.2992.45.6999.5015.830.0932.5 2.23.4562.45.8569.7616.270.1032.5 2.33.6132.46.01310.0216.700.1032.5 2.43.772.46.1710.2817.140.1032.5 2.53.9272.46.32710.5517.580.1132.5 2.64.0842.46.48410.8118.010.1132.5 2.74.2412.46.64111.0718.450.1132.5 2.84.3982.46.79811.3318.880.1132.5 2.94.5552.46.95511.5919.320.1232.5 3.04.7122.47.11211.8519.760.1232.5 3.14.8692.47.26912.1220.190.1254.17 3.25.0272.47.42712.3820.630.1254.17 3.35.1842.47.58412.6421.070.1354.17 3.45.3412.47.74112.9021.500.1354.17 3.55.4982.47.89813.1621.940.1354.17 3.65.6552.48.05513.4322.380.1354.17 3.75.8122.48.21213.6922.810.1454.17 3.85.9692.48.36913.9523.250.1454.17 3.96.1262.48.52614.2123.680.1454.17 4.06.2832.48.68314.4724.120.1454.17 4.16.442.48.8414.7324.560.1554.17 4.26.5972.48.99715.0024.990.1554.17 4.36.7542.49.15415.2625.430.1554.17 4.46.9122.49.31215.5225.870.1654.17 4.57.0692.49.46915.7826.300.1654.17 4.67.2262.49.62616.0426.740.1675.83 4.77.3832.49.78316.3127.180.1675.83 4.87.542.49.9416.5727.610.1775.83 4.97.6972.410.09716.8328.050.1775.83 5.07.8542.410.25417.0928.480.1775.83 5.18.0112.410.41117.3528.920.1775.83 5.28.1682.410.56817.6129.360.1875.83 5.38.3252.410.72517.8829.790.1875.83 5.48.4822.410.88218.1430.230.1875.83 5.58.6392.411.03918.4030.660.1875.83 5.68.7962.411.19618.6631.100.1975.83 5.78.9542.411.35418.9231.540.1975.83 5.89.112.411.5119.1831.970.1975.83 5.99.2682.411.66819.4532.410.1975.83 钢网锚固剂桁架 率片/圈片/米率 锚杆锚索合计锚杆 根/米根/米根/米根/圈根/米 4.624.620.0215.395.0020.392.393.99 4.754.750.0215.835.0020.832.464.10 4.884.880.0216.275.0021.272.524.21 5.015.010.0216.705.0021.702.594.31 5.145.140.0217.145.0022.142.654.42 5.275.270.0217.585.0022.582.724.53 5.405.400.0218.015.0023.012.794.64 5.535.530.0218.455.0023.452.854.75 5.675.670.0218.885.0023.882.924.86 5.805.800.0219.325.0024.322.984.97 5.935.930.0219.765.0024.763.055.08 6.066.060.0220.198.3328.533.115.19 6.196.190.0220.638.3328.963.185.30 6.326.320.0321.078.3329.403.245.41 6.456.450.0321.508.3329.843.315.51 6.586.580.0321.948.3330.273.375.62 6.716.710.0322.388.3330.713.445.73 6.846.840.0322.818.3331.143.515.84 6.976.970.0323.258.3331.583.575.95 7.117.110.0323.688.3332.023.646.06 7.247.240.0324.128.3332.453.706.17 7.377.370.0324.568.3332.893.776.28 7.507.500.0324.998.3333.333.836.39 7.637.630.0325.438.3333.763.906.50 7.767.760.0325.878.3334.203.966.61 7.897.890.0326.308.3334.644.036.71 8.028.020.0326.7411.6738.414.096.82 8.158.150.0327.1811.6738.844.166.93 8.288.280.0327.6111.6739.284.237.04 8.418.410.0328.0511.6739.714.297.15 8.558.550.0328.4811.6740.154.367.26 8.688.680.0328.9211.6740.594.427.37 8.818.810.0429.3611.6741.024.497.48 8.948.940.0429.7911.6741.464.557.59 9.079.070.0430.2311.6741.894.627.70 9.209.200.0430.6611.6742.334.687.80 9.339.330.0431.1011.6742.774.757.91 9.469.460.0431.5411.6743.214.818.02 9.599.590.0431.9711.6743.644.888.13 9.729.720.0432.4111.6744.084.958.24 锚索 U25型钢 锚索合计 公斤/架公斤/米率 根/圈根/米根/米 10.834.821591980.20 10.834.931622030.20 10.835.041662080.21 10.835.151702130.21 10.835.261742180.22 10.835.371782230.22 10.835.481822280.23 10.835.581862330.23 10.835.691902370.24 10.835.801942420.24 10.835.911982470.25 21.676.852022520.25 21.676.962062570.26 21.677.072102620.26 21.677.182142670.27 21.677.292172720.27 21.677.402212770.28 21.677.512252820.28 21.677.622292870.29 21.677.732332910.29 21.677.842372960.30 21.677.942413010.30 21.678.052453060.31 21.678.162493110.31 21.678.272533160.32 21.678.382573210.32 32.509.322613260.33 32.509.432653310.33 32.509.542693360.34 32.509.652723410.34 32.509.762763450.35 32.509.872803500.35 32.509.982843550.36 32.5010.092883600.36 32.5010.202923650.37 32.5010.302963700.37 32.5010.413003750.37 32.5010.523043800.38 32.5010.633083850.38 32.5010.743123900.39 桁架