管长 管段编号 环号 16-15 16-17 17-14 15-14 17-14 17-18 18-13 14-13 18-13 18-19 19-12 13-12 19-12 19-20 20-11 12-11 5-16 5-4 4-21 21-17 16-17 21-3 3-2 2-19 管径m DN(m 770 855 791 807 731 650 691 639 691 683 4 754 4 478 619 523 515 607 229 452 855 400 850 1000 初分配流量 m) 500 600 250 450 250 500 250 400 250 350 200 350 200 300 200 250 700 800 700 400 600 700 500 300 q(L/s) -194.00 154.75 20.00 -158.29 -20.00 135.58 -20.00 -125.56 -20.00 60.71 20.00 -75.29 -20.00 51.19 15.00 -22.47 -394.86 793.06 607.88 -200.00 140.20 386.09 266.17 80.00 v(m/s) 0.9880 0.5473 0.4107 0.9953 0.4107 0.6905 0.4107 0.9992 0.4107 0.6310 0.30 0.7825 0.30 0.7242 0.4823 0.4614 1.0260 1.5777 1.5795 1.5915 0.4959 1.0032 1.3556 1.1318 1000i 2.82 0.7056 1.3179 3.0784 ∑ △q 1.3179 1.3666 1.3179 3.6140 ∑ △q 1.3179 1.8425 3.9736 2.7345 ∑ △q 3.9736 2.74 2.3557 1.6253 ∑ △q 1.8343 3.5599 4.2444 8.9196 0.5900 ∑ △q 1.7592 4.8415 6.6276 h(m) Ⅰ环 Ⅱ环 Ⅲ环 IV环 V环 VI环
-2.03910.60331.0425-2.4843-2.877617-0.96340.8883-0.9107-2.3094-3.295113-0.91071.25852.5590-2.06180.8449-1-2.55901.38491.4582-0.8500-0.56590.-0.94472.16090.9720-4.03170.5044-1.3391210.70374.11536.6276
VII环 VIII环 IX环 X环 18-19 21-17 17-18 5-6 6-7 7-4 5-4 7-4 4-21 21-3 8-3 7-8 8-3 3-2 9-2 8-9 9-2 2-1 1-10 9-10 419 452 650 883 424 900 607 900 229 539 928 718 928 773 981 796 981 795 998 841 350 400 500 600 600 400 800 400 700 700 200 500 200 500 150 400 150 350 200 300 -60.71 -200.00 -135.58 229.53 192.42 -30.00 -793.06 30.00 -607.88 -386.09 -30.00 174.73 30.00 -266.17 -20.00 119.38 20.00 -65.92 -15.00 37.20 0.6310 1.5915 0.6905 0.8118 0.6805 0.2387 1.5777 0.2387 1.5795 1.0032 0.96 0. 0.96 1.3556 1.1470 0.9500 1.1470 0.6852 0.4823 0.5263 1.8425 8.9196 1.3666 ∑ △q 1.4520 1.0499 0.2709 3.5599 ∑ △q 0.2709 4.2444 1.7592 8.3885 2.1809 ∑ △q 8.3885 4.8415 16.8786 3.2904 ∑ △q 16.8786 2.1421 2.3557 1.6181 ∑ △q -0.7720-4.0317-0.88835.7545-201.28210.4452-0.2438-2.1609-0.6775180.2438-0.9720-0.9482-7.78451.5659-7.50147.7845-3.7425-16.5572.6192-9.674.16.5579-1.7029-2.35101.360813.88-6使用说明 使用前请解除宏禁用,将宏安全性调低，重启Excel（工具-宏-宏安全性输入管长，管径和初分配流量，面查表面积算自动平差 注意单位，管径为公称直径，单位毫米；流量为升每秒 流量输入请确定正负号，在环内以顺时针为正，逆时针为负
