给水管网课程设计-管网平差excel程序

平差顺时针为正 管长管径流量1 623400 1~2 957400 1~5 624250 4~54~5 959500 2~42~4 624250 5~45~4 974350 5~7 974400 4~94~9 624150 9~79~7 624150 7~97~9 942200 7~13 942350 9~129~12 624300 12~1312~13 624300 13~1213~12 823400 13~15 823250 12~1612~16 624250 16~15 399700 2~2.5 959500 2~42~4 899600 2.5~3 575300 3~43~4 575300 4~34~3 974400 4~94~9 974600 3~10 575200 10~910~9 575200 9~109~10 942350 9~129~12 942500 10~11 水头损失1 51.540.29 47.310.38 27.950.92 95.710.47 #DIV/0! #DIV/0! #DIV/0! 27.950.92 66.751.40 83.831.11 26.7810.21 #DIV/0! #DIV/0! #DIV/0! #DIV/0! 26.7810.21 62.6718.34 72.411.57 88.643.20 #DIV/0! #DIV/0! #DIV/0! 88.643.20 16.650.05 37.992.14 49.442.64 #DIV/0! #DIV/0! #DIV/0! #DIV/0! 0.09 95.710.47 0.62 23.440.25 #DIV/0! #DIV/0! #DIV/0! 23.440.25 83.831.11 0.49 22.641.70 #DIV/0! #DIV/0! #DIV/0! 22.641.70 72.411.57 0.80 校正流量1 0.29 0.38 -0.92 -0.47 -0.724.90 0.92 1.40 -1.11 -10.21 -9.019.63 10.21 18.34 -1.57 -3.20 23.77-16.75 3.20 -0.05 -2.14 -2.64 -1.624.44 0.09 0.47 -0.62 -0.25 -0.314.78 0.25 1.11 -0.49 -1.70 -0.833.12 1.70 1.57 -0.80 151.86 185.61 156.89 128.27 575300 11~1211~1261.33 575 823 823 575 300 250 350 350 12~1112~11 12~1612~16 11~17 17~16 61.33 37.99 61.32 57.96 1.49 #DIV/0! #DIV/0! #DIV/0! 1.49 2.14 1.01 0.63 -1.49 0.98-3.06 1.49 2.14 -1.01 -0.63 1.99-7.15 顺时针为正 流量2水头损失2校正流量2流量3水头损失3 顺时针为正 校正流量3 56.440.34 52.210.45 32.691.23 95.600.47 32.691.23 76.381.79 77.320.96 0.400.00 0.400.00 45.9210.31 86.102.16 109.834.77 109.834.77 12.210.03 26.401.09 45.002.22 156.640.09 95.600.47 180.830.59 21.780.22 21.780.22 77.320.96 153.770.47 16.460.94 16.460.94 86.102.16 131.330.83 0.34 0.45 -1.23 -0.47 -0.905.58 1.23 1.79 -0.96 0.00 2.06-9.18 0.00 10.31 -2.16 -4.77 3.38-5.04 4.77 -0.03 -1.09 -2.22 1.43-4.23 0.09 0.47 -0.59 -0.22 -0.253.89 0.22 0.96 -0.47 -0.94 -0.241.08 0.94 2.16 -0.83 62.010.41 57.780.55 17.930.40 93.920.46 17.930.40 67.201.41 87.581.21 4.530.38 4.530.38 40.888.31 87.792.24 4.83 4.83 16.430.05 29.091.30 49.222.62 0.10 93.920.46 0.57 18.960.17 18.960.17 87.581.21 0.47 12.030.53 12.030.53 87.792.24 0.87 0.41 0.55 -0.40 -0.46 0.10-0.75 0.40 1.41 -1.21 -0.38 0.23-0.66 0.38 8.31 -2.24 -4.83 1.62-2.10 4.83 -0.05 -1.30 -2.62 0.86-2.42 0.10 0.46 -0.57 -0.17 -0.183.08 0.17 1.21 -0.47 -0.53 0.38-1.99 0.53 2.24 -0.87 110.65 110.65 160.54 176.93 152.69 134.68 57.241.31-1.31 0.96 59.06 -3.35 1.39-1.39 0.50-1.95 57.24 26.40 68.47 65.11 1.31 1.09 1.24 0.79 1.31 1.09 -1.24 -0.79 0.38 59.06 29.09 70.00 66.64 -1.53 1.39 1.30 1.29 0.82 1.39 1.30 -1.29 -0.82 0.59-2.27 顺时针为正 流量4水头损失4校正流量4流量5水头损失5 顺时针为正 61.260.40 57.030.54 18.010.41 97.740.49 18.010.41 66.541.39 86.251.17 3.100.19 3.100.19 38.787.54 87.942.25 110.334.81 110.334.81 18.850.06 29.241.32 51.642.86 163.620.10 97.740.49 173.850.55 13.890.10 13.890.10 86.251.17 154.680.48 12.070.53 12.070.53 87.942.25 136.630.90 0.40 0.54 -0.41 -0.49 0.04-0.27 0.41 1.39 -1.17 -0.19 0.44-1.46 0.19 7.54 -2.25 -4.81 0.67-0.94 4.81 -0.06 -1.32 -2.86 0.57-1.57 0.10 0.49 -0.55 -0.10 -0.050.96 0.10 1.17 -0.48 -0.53 0.26-1.38 0.53 2.2