梯形管道计算EXCEL表

序号名称长度（m）开挖方量(m³）基础方量（C10）混凝土回填级配夯填1电信老井-1#16.529.472 1.139 5.72721.963 21#-2#20.741.818 1.67711.33026.845 32#-3#98.1198.1827.94653.252127.222 43#-4#83.0167.677 6.72345.055107.640 54#-5#9.018.1820.729 4.88511.672 65#-6#93.0187.8797.53350.483120.608 76#-7#60.4122.020 4.89232.78778.330 82#-2-1#56.2103.672 3.87828.59667.461 92-1#-引上管道 2.5 2.7000.113 1.121 1.419 102#-引上管道 5.77.5240.393 2.164 4.750 117#-7-1#44.575.147 2.53721.08549.412 127#-引上管道 6.38.3160.435 2.392 5.185 137-1#-引上管道 3.7 4.8840.255 1.405 3.045 1413-1#-引上管道 5.1 6.7320.352 1.937 4.197 157#-8#88.8177.6627.19347.448114.585 168#-9#29.358.621 2.37315.65637.808 179#-10#65.5131.046 5.30634.99884.520 1810#-11#67.4134.847 5.45936.01486.971 1911#-12#90.9181.8647.36348.570117.295 2012#-13#47.595.033 3.84825.38061.293 2113#-13-1#44.286.535 3.58018.11463.368 2213#-引上管道7.68.2080.342 3.263 4.314 2313#-14#94.1188.2667.62250.280121.424 2414#-15#70.7141.449 5.72737.77791.230 2515#-16#93.8187.6667.59850.120121.037 2616#-17#11.022.0080.891 5.87814.194 2717#-18#93.5187.0657.57449.959120.650 2818#-19#97.0194.0687.85751.830125.166 2915#-引上管道 6.28.1840.428 2.354 5.103 3018#-引上管道 4.1 5.4120.283 1.557 3.374 3118-1#-引上管道7.810.2960.538 2.962 6.420 3218-1#-18-2#90.597.740 4.07338.85451.375 3318#-18-1#45.977.511 2.61621.31350.966 3419#-20#39.178.227 3.16720.89250.454 3520#-21#88.2176.4627.14447.127113.811 3621#-22#69.4138.849 5.62137.08289.552 3722#-23#70.3140.649 5.69437.56390.713 3823#-24#71.4142.850 5.78338.15192.133 3924#-25#59.6119.242 4.82831.84676.906 4021#-21-1#43.379.876 2.98816.44258.801 4125#-25-1#45.168.516 2.57115.76848.892 4221-1#-引上管道11.314.9160.780 4.2919.416 4325#-引上管道 3.5 4.6200.242 1.329 2.916 4421#-引上管道 4.0 4.3200.180 1.717 2.271

4525-1#-引上管道 4.0 4.8000.228 1.398 3.060 4625#-26#79.0158.055 6.39942.212101.940 4726#-27#60.2120.442 4.87632.16677.681 4827#-28#20.440.814 1.65210.90026.324 4928#-29#69.0138.048 5.58936.86889.036 5029#-30#39.679.228 3.20821.15951.099 5130#-31#26.853.619 2.17114.32034.582 5231#-32#80.5161.056 6.52143.013103.875 5332#-33#80.3160.656 6.50442.906103.617 5427#-27-1#46.049.680 2.07020.62326.113 5530#-30-1#43.567.860 4.04619.13642.199 5627#-引上管道 3.9 5.1480.269 1.481 3.250 5730#-引上管道 4.8 6.3360.331 1.823 4.000 5830-1#-引上管道 4.0 5.2800.276 1.595 3.333 5927-1#-引上管道 3.5 3.7800.158 1.569 1.987 33#-34#80.0160.056 6.48042.746103.230 34#-35#66.3132.646 5.37035.42685.552 35#-36#79.8147.207 5.50639.84695.790 36#-37#70.4129.867 4.85835.15284.506 37#-38#67.5124.517 4.65833.70481.025 35#-35-1#46.149.788 2.07519.79226.170 37#-37-1#46.979.200 2.67321.77752.077 35-1#-引上管道 2.0 2.6400.1380.780 1.646 37#-引上管道 3.0 3.9600.207 1.170 2.469 34#-引上管道 3.4 3.6720.153 1.460 1.930 39#-40#75.9151.853 5.23742.90897.939 40#-41#80.0160.056 5.52045.226103.230 41#-42#36.272.425 2.49820.46546.712 42#-43#57.1114.240 3.94032.28073.680 42#-42-1#63.2126.444 4.36135.72981.552 38#-39#50.791.260 5.93225.35656.119 42#-引上管道8.010.5600.552 3.008 6.696 42-1#-引上管道 5.0 6.6000.345 1.880 4.185合计3472.76558.0263.11786.64223.3人孔孔号挖方混凝土垫层砌砖抹灰备注

11#11.031 1.439 2.2407.8212向

22#11.031 1.439 1.797 5.3124向

32-1#11.031 1.439 2.4988.8982向

43#11.031 1.439 2.2407.8212向

54#11.031 1.439 2.2407.8212向

65#11.031 1.439 2.2407.8212向

76#11.031 1.439 2.2407.8212向

87#11.031 1.439 1.518 4.8124向

97-1#11.031 1.439 2.4038.5022向

108#11.031 1.439 2.2407.8212向

119#11.031 1.439 2.2407.8212向

1210#11.031 1.439 2.2407.8212向