水面线计算excel表.xls
- 文档编号:15490728
- 上传时间:2023-07-05
- 格式:XLS
- 页数:173
- 大小:856KB
水面线计算excel表.xls
《水面线计算excel表.xls》由会员分享,可在线阅读,更多相关《水面线计算excel表.xls(173页珍藏版)》请在冰点文库上搜索。
九九牧牧溪溪九九牧牧镇镇段段水水面面线线计计算算(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.0339.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.6127.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.03640.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.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.1000.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.00003683.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#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.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.56172368.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.94172368.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.32172368.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.68182368.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.04182368.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.4183369.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.75182369.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.3924.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.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.5720.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.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.6221.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.92192370.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.28192370.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.64192370.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.0223203370.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.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.5823.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.7924.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.45202371.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.81203371.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.16212371.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.52212371.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.88212371.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.1378.8426.24212372.1479.0526.27213372.1579.2626.29212372.1679.4726.31212372.1779.6826.33212372.1879.89
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- 水面 计算 excel