管线压力线计算.xls

压力钢管水头损失计算 θ ζ 局部水头损失 沿程水头损失 序号 桩号 → 流量模数K 面积A 谢才系数C 水力半径R 间距序号 间距L 局部水损 流速V 水头损失和 总水头损失和 hj=(Q*Q/K*K)*L 各点测压水位 流量Q 糙率n 圆管直径D 末端测压水位 输入计算参数 2.01 3.14 2.00 4.00 2.80 .40 4.00 .01 71.53 1.00 1.00 6.00 1.60 90.96 .50 26.20 1.39 1.00 379.27 34.23 2.00 518.92 - 1-2 139.65 .13 30.00 .07 7.18E-03 2.00 19.60 .14 34.09 3.00 533.67 2-3 14.75 .01 30.00 .07 7.18E-03 .02 34.07 4.00 542.17 3-4 8.50 8.05E-03 30.00 .07 7.18E-03 .02 34.05 5.00 562.08 4-5 19.92 .02 30.00 .07 7.18E-03 .03 34.02 6.00 574.14 5-6 12.06 .01 30.00 .07 7.18E-03 .02 34.01 7.00 631.50 6-7 57.36 .05 30.00 .07 7.18E-03 .06 33.94 8.00 670.71 7-8 39.21 .04 10.00 7.30E-03 7.23E-04 .04 33.91 9.00 682.66 8-9 11.95 .01 60.00 .36 .04 .05 33.86 10.00 735.65 9-10 52.99 .05 60.00 .36 .04 .09 33.77 11.00 743.16 10-11 7.50 7.11E-03 30.00 .07 7.18E-03 .01 33.76 12.00 788.40 11-12 45.24 .04 30.00 .07 7.18E-03 .05 33.71 13.00 846.28 12-13 57.88 .05 60.00 .36 .04 .09 33.62 14.00 994.70 13-14 148.42 .14 10.00 7.30E-03 7.23E-04 .14 33.48 15.00 1076.32 14-15 81.62 .08 10.00 7.30E-03 7.23E-04 .08 33.40 16.00 1424.32 15-16 348.00 .33 30.00 .07 7.18E-03 .34 33.06 17.00 1448.23 16-17 23.91 .02 30.00 .07 7.18E-03 .03 33.03 18.00 1527.38 17-18 79.15 .08 30.00 .07 7.18E-03 .08 32.95 19.00 1624.38 18-19 97.00 .09 30.00 .07 7.18E-03 .10 32.85 20.00 1968.73 19-20 344.34 .33 10.00 7.30E-03 7.23E-04 .33 32.52 21.00 2715.66 20-21 746.93 .71 10.00 7.30E-03 7.23E-04 .71 31.81 22.00 2798.93 21-22 83.27 .08 30.00 .07 7.18E-03 .09 31.73 23.00 2970.23 22-23 171.29 .16 30.00 .07 7.18E-03 .17 31.56 24.00 3050.69 23-24 80.47 .08 30.00 .07 7.18E-03 .08 31.47 25.00 3076.09 24-25 25.39 .02 10.00 7.30E-03 7.23E-04 .02 31.45 26.00 3130.42 25-26 54.33 .05 30.00 .07 7.18E-03 .06 31.39 27.00 3165.08 26-27 34.66 .03 10.00 7.30E-03 7.23E-04 .03 31.36 28.00 3274.10 27-28 109.02 .10 30.00 .07 7.18E-03 .11 31.25 29.00 3422.30 28-29 148.20 .14 30.00 .07 7.18E-03 .15 31.10 30.00 3498.31 29-30 76.01 .07 30.00 .07 7.18E-03 .08 31.02 31.00 3567.98 30-31 69.67 .07 10.00