水面线计算excel表.xls

1、九九牧牧溪溪九九牧牧镇镇段段水水面面线线计计算算(2015.3.10)(2015.3.10)序号断面桩号间距L(m)流量Q(m3/s)试算水位Z(m)面积A(m2)湿周X(m)水力半径R河道糙率n谢才系数C10+865.46218.00371.3059.5024.002.4790.02546.534820+825.7439.72218.00371.6167.9325.082.7080.0339.353430+791.7034.04218.00371.7870.2925.742.7310.0339.409840+711.0080.70218.00372.0774.6527.632.7020.03

2、39.339550+589.15121.85218.00372.4867.4926.572.5400.0338.935960+551.8937.26218.00372.6469.9927.442.5500.0338.962170+518.7233.17218.00372.8561.8124.752.4970.0338.825980+435.0083.72218.00373.4385.2131.902.6710.0339.264590+393.0641.94218.00373.5672.3227.372.6420.0339.1920100+307.9885.08218.00373.8270.61

3、27.642.5550.0338.973811373.830+295.5512.43218.00373.9764.2825.772.4950.02546.5837373.98120+239.9155.64218.00374.5076.2527.962.7280.0339.4011130+166.6873.23218.00374.6572.7427.672.6290.0339.1598140+084.3782.31218.00374.8546.0625.331.8190.0336.8270150+000.0084.37218.00376.78110.9236.953.0020.0340.0364

4、0.000.000.000.000.000.000.00711677.0034.00流速V(m/s)动能修正系数平均流速V(m/s)平均水力半径R末断面机械能E平均水力坡降J沿程损失hf局部损失系数局部损失hj3.661.16372.093.211.213.442.593372.240.00300.120.0500.033.101.213.162.720372.370.00240.080.1000.052.921.213.012.717372.590.00220.170.1000.053.231.213.082.621373.120.00240.290.5000.243.111.213.172

5、.545373.240.00260.100.0500.033.531.213.322.524373.620.00290.100.5000.282.561.213.042.611373.840.00230.190.0500.023.011.212.792.570374.120.00200.080.5000.203.091.213.052.613374.410.00230.200.2000.093.391.161.702.525374.652.861.213.131.364375.000.00580.320.0500.023.001.212.932.562375.210.00220.160.100

6、0.044.731.233.872.224376.260.00460.380.001.971.203.352.410377.020.00310.260.00大张旗鼓新浪秀房间号密码495235369金股齐赢呱呱财经教室密码4765191818九九牧牧溪溪九九牧牧镇镇段段水水面面线线计计算算(2015.3.10)(2015.3.10)花票费用点数总计94009400930093008600860095009500合计（元）736000.025184022共计（元）1862首断面机械能E判别式备注设计底高程(m)水深(m)流速V(m/s)起始断面367.83.503.66372.090.00003

7、683.613.21372.240.0000368.173.613.10372.370.0000368.573.502.92372.590.0000369.183.303.23373.120.0000369.373.273.11373.240.0000369.533.323.53373.620.0000369.953.482.56373.840.0000370.163.403.01374.120.0000370.593.233.09半边月桥下游断面半边月桥370.653.323.39半边月桥上游断面374.650.0000370.933.572.86375.000.00002#跌水371.29

8、#REF!3.00375.88-0.67051#跌水372.21#REF!4.73376.75-0.4942起始断面373.133.651.970.000.000.000.000.000.000.000.001656（顺风快递费）JM0+825.70JM0+825.70;水位m面积m2湿周mks/zkX/z试算水位Zks/z368.010.1717.05368.020.3417.07172368.030.5117.09172371.607421368.040.6817.11172368.050.8517.14173368.061.0217.16172368.071.1917.18172368.

9、081.3717.2182368.091.5417.23173368.11.7117.25172368.111.8817.27172368.122.0517.29172368.132.2217.32173368.142.3917.34172368.152.5717.36182368.162.7417.38172368.172.9117.41173368.183.0817.43172368.193.2517.45172368.23.4317.47182368.213.617.49172368.223.7717.52173368.233.9417.54172368.244.1117.5617236

10、8.254.2917.58182368.264.4617.61173368.274.6317.63172368.284.8117.65182368.294.9817.67172368.35.1517.7173368.315.3317.72182368.325.517.74172368.335.6717.76172368.345.8517.79183368.356.0217.81172368.366.1917.83172368.376.3717.85182368.386.5417.87172368.396.7217.9183368.46.8917.92172368.417.0617.941723

11、68.427.2417.96182368.437.4117.99173368.447.5918.01182368.457.7618.03172368.467.9418.05182368.478.1118.08173368.488.2918.1182368.498.4618.12172368.58.6418.14182368.518.8118.17173368.528.9918.19182368.539.1618.21172368.549.3418.23182368.559.5218.25182368.569.6918.28173368.579.8718.3182368.5810.0418.32

12、172368.5910.2218.34182368.610.418.37183368.6110.5718.39172368.6210.7518.41182368.6310.9218.43172368.6411.118.46183368.6511.2818.48182368.6611.4518.5172368.6711.6318.52182368.6811.8118.55183368.6911.9918.57182368.712.1618.59172368.7112.3418.61182368.7212.5218.63182368.7312.6918.66173368.7412.8718.681

13、82368.7513.0518.7182368.7613.2318.72182368.7713.4118.75183368.7813.5818.77172368.7913.7618.79182368.813.9418.81182368.8114.1218.84183368.8214.318.86182368.8314.4818.88182368.8414.6518.9172368.8514.8318.93183368.8615.0118.95182368.8715.1918.97182368.8815.3718.99182368.8915.5519.02183368.915.7319.0418

14、2368.9115.9119.06182368.9216.0919.08182368.9316.2719.1182368.9416.4519.13183368.9516.6319.15182368.9616.819.17172368.9716.9819.19182368.9817.1619.22183368.9917.3419.2418236917.5319.26192369.0117.7119.28182369.0217.8919.31183369.0318.0719.33182369.0418.2519.35182369.0518.4319.37182369.0618.6119.41833

15、69.0718.7919.42182369.0818.9719.44182369.0919.1519.46182369.119.3319.48182369.1119.5119.51183369.1219.719.53192369.1319.8819.55182369.1420.0619.57182369.1520.2419.6183369.1620.4219.62182369.1720.619.64182369.1820.7919.66192369.1920.9719.69183369.221.1519.71182369.2121.3319.73182369.2221.5119.7518236

16、9.2321.719.78193369.2421.8819.8182369.2522.0619.82182369.2622.2519.84192369.2722.4319.86182369.2822.6119.89183369.2922.7919.91182369.322.9819.93192369.3123.1619.95182369.3223.3419.98183369.3323.5320192369.3423.7120.02182369.3523.920.04192369.3624.0820.07183369.3724.2620.09182369.3824.4520.11192369.3

17、924.6320.13182369.424.8220.16193369.412520.18182369.4225.1820.2182369.4325.3720.22192369.4425.5520.24182369.4525.7420.27193369.4625.9220.29182369.4726.1120.31192369.4826.2920.33182369.4926.4820.36193369.526.6620.38182369.5126.8520.4192369.5227.0320.42182369.5327.2220.45193369.5427.420.47182369.5527.

18、5920.49192369.5627.7820.51192369.5727.9620.54183369.5828.1520.56192369.5928.3320.58182369.628.5220.6192369.6128.7120.63193369.6228.8920.65182369.6329.0820.67192369.6429.2720.69192369.6529.4520.71182369.6629.6420.74193369.6729.8320.76192369.6830.0120.78182369.6930.220.8192369.730.3920.83193369.7130.5

19、720.85182369.7230.7620.87192369.7330.9520.89192369.7431.1420.92193369.7531.3320.94192369.7631.5120.96182369.7731.720.98192369.7831.8921.01193369.7932.0821.03192369.832.2721.05192369.8132.4521.07182369.8232.6421.09192369.8332.8321.12193369.8433.0221.14192369.8533.2121.16192369.8633.421.18192369.8733.

20、5921.21193369.8833.7721.23182369.8933.9621.25192369.934.1521.27192369.9134.3421.3193369.9234.5321.32192369.9334.7221.34192369.9434.9121.36192369.9535.121.39193369.9635.2921.41192369.9735.4821.43192369.9835.6721.45192369.9935.8621.4719237036.0521.5193370.0136.2421.52192370.0236.4321.54192370.0336.622

21、1.56192370.0436.8121.59193370.053721.61192370.0637.1921.63192370.0737.3821.65192370.0837.5821.68203370.0937.7721.7192370.137.9621.72192370.1138.1521.74192370.1238.3421.77193370.1338.5321.79192370.1438.7221.81192370.1538.9221.83202370.1639.1121.85192370.1739.321.88193370.1839.4921.9192370.1939.6821.9

22、2192370.239.8821.94202370.2140.0721.97193370.2240.2621.99192370.2340.4522.01192370.2440.6422.03192370.2540.8422.06203370.2641.0322.08192370.2741.2222.1192370.2841.4222.12202370.2941.6122.15193370.341.822.17192370.314222.19202370.3242.1922.21192370.3342.3822.24193370.3442.5822.26202370.3542.7722.2819

23、2370.3642.9622.3192370.3743.1622.32202370.3843.3522.35193370.3943.5522.37202370.443.7422.39192370.4143.9322.41192370.4244.1322.44203370.4344.3222.46192370.4444.5222.48202370.4544.7122.5192370.4644.9122.53203370.4745.122.55192370.4845.322.57202370.4945.4922.59192370.545.6922.62203370.5145.8822.641923

24、70.5246.0822.66202370.5346.2722.68192370.5446.4722.7202370.5546.6722.73203370.5646.8622.75192370.5747.0622.77202370.5847.2522.79192370.5947.4522.82203370.647.6522.84202370.6147.8422.86192370.6248.0422.88202370.6348.2322.91193370.6448.4322.93202370.6548.6322.95202370.6648.8222.97192370.6749.022320337

25、0.6849.2223.02202370.6949.4223.04202370.749.6123.06192370.7149.8123.08202370.7250.0123.11203370.7350.223.13192370.7450.423.15202370.7550.623.17202370.7650.823.2203370.775123.22202370.7851.1923.24192370.7951.3923.26202370.851.5923.29203370.8151.7923.31202370.8251.9923.33202370.8352.1923.35202370.8452

26、.3823.38193370.8552.5823.4202370.8652.7823.42202370.8752.9823.44202370.8853.1823.46202370.8953.3823.49203370.953.5823.51202370.9153.7823.53202370.9253.9823.55202370.9354.1823.58203370.9454.3823.6202370.9554.5823.62202370.9654.7723.64192370.9754.9723.67203370.9855.1723.69202370.9955.3723.7120237155.5

27、823.73212371.0155.7823.76203371.0255.9823.78202371.0356.1823.8202371.0456.3823.82202371.0556.5823.85203371.0656.7823.87202371.0756.9823.89202371.0857.1823.91202371.0957.3823.93202371.157.5823.96203371.1157.7823.98202371.1257.9924212371.1358.1924.02202371.1458.3924.05203371.1558.5924.07202371.1658.79

28、24.09202371.1758.9924.11202371.1859.224.14213371.1959.424.16202371.259.624.18202371.2159.824.2202371.226024.23203371.2360.2124.25212371.2460.4124.27202371.2560.6124.29202371.2660.8224.31212371.2761.0224.34203371.2861.2224.36202371.2961.4224.38202371.361.6324.4212371.3161.8324.43203371.3262.0324.4520

29、2371.3362.2424.47212371.3462.4424.49202371.3562.6524.52213371.3662.8524.54202371.3763.0524.56202371.3863.2624.58212371.3963.4624.61203371.463.6724.63212371.4163.8724.65202371.4264.0724.67202371.4364.2824.69212371.4464.4824.72203371.4564.6924.74212371.4664.8924.76202371.4765.124.78212371.4865.324.812

30、03371.4965.5124.83212371.565.7124.85202371.5165.9224.87212371.5266.1224.9203371.5366.3324.92212371.5466.5324.94202371.5566.7424.96212371.5666.9524.99213371.5767.1525.01202371.5867.3625.03212371.5967.5625.05202371.667.7725.07212371.6167.9825.1213371.6268.1825.12202371.6368.3925.14212371.6468.625.1621

31、2371.6568.825.19203371.6669.0125.21212371.6769.2225.23212371.6869.4225.25202371.6969.6325.28213371.769.8425.3212371.7170.0425.32202371.7270.2525.34212371.7370.4625.37213371.7470.6725.39212371.7570.8825.41212371.7671.0825.43202371.7771.2925.45212371.7871.525.48213371.7971.7125.5212371.871.9225.522123

32、71.8172.1225.54202371.8272.3325.57213371.8372.5425.59212371.8472.7525.61212371.8572.9625.63212371.8673.1725.66213371.8773.3825.68212371.8873.5825.7202371.8973.7925.72212371.97425.75213371.9174.2125.77212371.9274.4225.79212371.9374.6325.81212371.9474.8425.84213371.9575.0525.86212371.9675.2625.8821237

33、1.9775.4725.9212371.9875.6825.92212371.9975.8925.9521337276.125.97212372.0176.3125.99212372.0276.5226.01212372.0376.7326.03212372.0476.9426.05212372.0577.1526.08213372.0677.3626.1212372.0777.5726.12212372.0877.7826.14212372.0977.9926.16212372.178.2126.18222372.1178.4226.2212372.1278.6326.22212372.13

34、78.8426.24212372.1479.0526.27213372.1579.2626.29212372.1679.4726.31212372.1779.6826.33212372.1879.8926.35212372.1980.126.37212372.280.3226.39222372.2180.5326.41212372.2280.7426.44213372.2380.9526.46212372.2481.1626.48212372.2581.3726.5212372.2681.5826.52212372.2781.7926.54212372.2882.0126.56222372.2

35、982.2226.58212372.382.4326.6212372.3182.6426.63213372.3282.8526.65212372.3383.0726.67222372.3483.2826.69212372.3583.4926.71212372.3683.726.73212372.3783.9126.75212372.3884.1326.77222372.3984.3426.8213372.484.5526.82212372.4184.7626.84212372.4284.9726.86212372.4385.1926.88222372.4485.426.9212372.4585

36、.6126.92212372.4685.8226.94212372.4786.0426.96222372.4886.2526.99213372.4986.4627.01212372.586.6827.03222372.5186.8927.05212372.5287.127.07212372.5387.3127.09212372.5487.5327.11222372.5587.7427.13212372.5687.9527.16213372.5788.1727.18222372.5888.3827.2212372.5988.5927.22212372.688.8127.24222372.6189

37、.0227.26212372.6289.2327.28212372.6389.4427.3212372.6489.6627.32222372.6589.8727.35213372.6690.0927.37222372.6790.327.39212372.6890.5127.41212372.6990.7327.43222372.790.9427.45212372.7191.1527.47212372.7291.3727.49222372.7391.5827.52213372.7491.827.54222372.7592.0127.56212372.7692.2227.58212372.7792

38、.4427.6222372.7892.6527.62212372.7992.8727.64222372.893.0827.66212372.8193.2927.68212372.8293.5127.71223372.8393.7227.73212372.8493.9427.75222372.8594.1527.77212372.8694.3727.79222372.8794.5827.81212372.8894.827.83222372.8995.0127.85212372.995.2327.88223372.9195.4427.9212372.9295.6527.92212372.9395.

39、8727.94222372.9496.0827.96212372.9596.327.98222372.9696.5128212372.9796.7328.02222372.9896.9428.04212372.9997.1628.0722337397.3828.092220.261072386 0.075308311#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#

40、DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!

41、#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0

42、!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/

43、0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV

44、/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!kX/z面积Am2湿周m267.9325.08JM0+711.000JM0+711.000;水位m面积m2湿周mks/zkX/z试算水位Zks/z368.20.5317.73368.32.3117.9617.82.3368.44.0918.1817.82.2371.780821.1368.55.8818.417.92.2368.67.6918.6318.12.3368

45、.79.518.8518.12.2368.811.3319.0818.32.3368.913.1619.318.32.236915.0119.5218.52.2369.116.8619.7518.52.3369.218.7319.9718.72.2369.320.620.1918.72.2369.422.4920.4218.92.3369.524.3820.6418.92.2369.626.2920.8619.12.2369.728.221.0919.12.3369.830.1321.3119.32.2369.932.0621.5419.32.337034.0121.7619.52.2370.

46、135.9621.9819.52.2370.237.9222.2119.62.3370.339.922.4319.82.2370.441.8822.6519.82.2370.543.8822.88202.3370.645.8823.1202.2370.747.923.3220.22.2370.849.9223.5520.22.3370.951.9623.7720.42.2371542420.42.3371.156.0624.2220.62.2371.258.1224.4420.62.2371.360.224.6720.82.3371.462.2824.8920.82.2371.564.3825

47、.11212.2371.666.4825.34212.3371.768.5925.5621.12.2371.870.7225.7821.32.2371.972.8526.0121.32.33727526.2321.52.2372.177.1526.4521.52.2372.279.3226.6721.72.2372.381.4826.8721.62372.483.6527.0721.72372.585.8227.2721.72372.687.9827.4721.62372.790.1527.6721.72372.892.3227.8721.72372.994.4828.0721.6237396

48、.6528.2721.720.259115282 0.075790885#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/

49、0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV

50、/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DI