市政管道沟槽土方计算表(EXCEL表格)

井号 Y1 Y2 Y3 Y4 Y4 Y5 Y6 Y6 Y7 Y9 Y10 Y11 Y12 Y12 Y13 Y14 Y15 Y15 出水口一 出水口二 Y16-2 Y16-2 Y16-1

管道沟槽开挖土方计算 路面标高 管内底标高 管径 增量H 挖土深 基槽底宽 边坡 断面积 平均断面积 管长 5.618 5.524 5.633 5.747 5.747 5.654 5.438 5.438 5.313 5.582 5.565 5.437 5.325 5.325 5.483 5.748 6.082 6.082 5.2 5.2 6.228 6.228 6.302 2.573 2.603 2.643 2.683 2.883 2.928 2.973 3.373 3.453 3.145 3.041 2.941 2.841 2.441 2.378 2.315 2.257 1.557 1.544 1.31 1.316 2.216 2.237 1000 0.362 1000 0.362 1000 0.362 1000 0.362 800 800 800 400 400 600 600 600 600 0.342 0.342 0.342 0.165 0.165 0.325 0.325 0.325 0.325 2.707 2.583 2.652 2.726 2.506 2.368 2.107 1.53 1.325 2.062 2.149 2.121 2.109 2.546 2.767 3.095 3.487 4.187 3.318 3.588 4.61 3.71 3.763 2.375 2.375 2.375 2.375 2.125 2.125 2.125 1 1 1.9 1.9 1.9 1.9 2.375 2.375 2.375 2.375 2.375 2.375 2.65 2.65 2.65 2.65 0.33 0.33 0.33 0.33 0.33 0.33 0.33 0.33 0.33 0.33 0.33 0.33 0.33 0.33 0.33 0.33 0.33 0.33 0.33 0.33 0.33 0.33 0.33 8.85 8.59 8.34 8.48 8.62 8.77 8.93 8.16 7.40 7.14 6.88 6.41 5.94 4.12 2.30 2.10 1.90 3.61 5.32 5.46 5.61 5.56 5.51 5.49 5.47 6.83 1000 0.362 1000 0.362 1000 0.362 1000 0.362 1000 0.362 1000 0.362 1200 0.398 1200 0.398 1200 0.398 1200 0.398 8.19 8.64 9.10 9.80 10.51 11.40 12.29 14.01 15.73 13.62 11.51 12.63 13.76 16.49 19.23 16.80 14.37 14.51 14.64 21.3 0 12 0 12 0 42 45 45 0 40 40 41.5 0 40 0 45 45 0 40 40 30

挖土方

257.75 339.12 350.92 0.00 321.30 288.56 0.00 84.14 0.00 226.76 222.43 219.79 0.00 388.89 441.22 478.92 0.00 163.46 0.00 197.92 0.00 309.05

Y16-1 Y16-1 Y16 Y17 Y18 Y19 Y20 Y20 Y21 Y22 Y22 Y23 Y23 Y24 Y25 Y26 Y26 Y27 Y28 Y29 Y30 Y30-1 Y30-1 Y30-2

6.302 6.302 6.191 5.965 5.652 5.374 5.379 5.379 5.509 5.445 5.445 5.271 5.271 5.165 5.448 5.432 5.432 5.287 5.171 5.458 5.841 5.964 5.964 6.296

2.237 2.437 2.482 2.539 2.599 2.639 2.67 2.87 2.914 2.959 3.359 3.429 3.529 3.619 4.121 4.031 3.231 3.185 3.135 3.045 2.957 2.897 2.697 2.649

1200 0.398 1000 0.362 1000 0.362 1000 0.362 1000 0.362 1000 0.362 1000 0.362 800 800 800 400 400 300 300 300 800 800 800 800 800 800 800 0.342 0.342 0.342 0.165 0.165 0.158 0.158 0.158 0.342 0.342 0.342 0.342 0.342 0.342 0.342

3.763 3.527 3.371 3.088 2.715 2.397 2.371 2.151 2.237 2.128 1.551 1.307 1.2 1.004 0.785 1.043 1.843 1.744 1.678 2.055 2.526 2.709 2.929 3.309

2.65 2.375 2.375 2.375 2.375 2.375 2.375 2.125 2.125 2.125 1 1 0.9 0.9 0.9 2.125 2.125 2.125 2.125 2.125 2.125 2.125 2.375 2.375

0.33 0.33 0.33 0.33 0.33 0.33 0.33 0.33 0.33 0.33 0.33 0.33 0.33 0.33 0.33 0.33 0.33 0.33 0.33 0.33 0.33 0.33 0.33 0.33

14.64 13.56 12.48 12.12 11.76 11.12 10.48 9.68 8.88 8.23 7.59 7.54 7.49 6.79 6.10 6.25 6.41 6.21 6.02 4.18 2.34 2.11 1.87 1.71 1.56 1.40 1.24 1.07 0.91 1.74 2.58 3.81 5.04 4.87 4.71 4.60 4.49 5.13 5.76 6.62 7.47 7.83 8.18 8.98 0 40 0 0.00 425.19 0.00 9.79 10.63 11.47 14.18 29.8 233.21 44.2 292.47 45 230.75 50 230.12 45.65 222.47 0 0.00 30 52.28 0 0.00 30 41.87 0 0.00 35 73.77 0 0.00 45 279

.48 43.7 273.18 0 0.00 31.3 235.93 40 329.39 40 387.23 38 422.50 30 363.57 0 0.00

1000 0.362 1000 0.362

14.18 Y30-2 出水口三 出水口四 Y31 Y31 Y32 Y33 Y33 Y34 Y35 Y35 Y36 合计 6.296 5.2 5.2 6.271 6.271 5.819 5.385 5.385 5.092 5.198 5.198 5.288 1.549 1.538 1.5 1.517 2.117 2.182 2.256 2.456 2.542 3.623 3.523 3.583 1000 0.362 1000 0.362 1000 0.362 1000 0.362 1000 0.362 1000 0.362 1000 0.362 800 800 800 400 400 0.342 0.342 0.342 0.165 0.165 4.409 3.324 3.362 4.416 3.816 3.299 2.791 2.571 2.192 1.217 1.14 1.17 2.375 2.375 2.375 2.375 2.375 2.375 2.375 2.125 2.125 2.125 1 0.33 0.33 0.33 0.33 0.33 0.33 0.33 0.33 0.33 0.33 0.33 16.89 14.21 11.54 11.63 11.71 14.32 16.92 15.40 13.87 12.65 11.43 10.31 9.20 8.42 7.64 6.94 6.24 4.66 3.07 2.32 1.57 1.60

0 9 0 11 0 43 50 0 48 45 0 30

0.00 127.92 0.00 157.51 0.00 543.84 515.65 0.00 333.32 209.67 0.00 47.86

1 0.33 1.62 10319.40 支管沟槽土方量另计，F列中的0.7值表示为路面结构层厚度。不同的路面结构需进行调整。

本文来源：https://www.bwwdw.com/article/mrh4.html