为了正常的体验网站,请在浏览器设置里面开启Javascript功能!
首页 > 水闸结构自动计算表格Excel

水闸结构自动计算表格Excel

2021-01-17 3页 xls 179KB 169阅读

用户头像 个人认证

超级海贼王路飞

保险理财规划师

举报
水闸结构自动计算表格Excel宽顶堰堰流泄流能力计算(P=1)闸门孔数n6中间闸墩侧收缩系数ξz0.9550845188单孔净宽b010边闸孔侧收缩系数ξb0.9088728959总净宽B060侧收缩系数ξ0.9473825816闸墩厚度dz4断面面积2321.5436bb30.95原河道底高程169.5坎顶高程170河道流速2.2786563216闸墩顶高程190.05189.180.87堰上水深H020.3146419282下游水位189.140.91自由过流流量系数m堰流淹没出流系数σ坎高P0.5下游水位hs19.140.9421775716υ00....
水闸结构自动计算表格Excel
宽顶堰堰流泄流能力计算(P=1)闸门孔数n6中间闸墩侧收缩系数ξz0.9550845188单孔净宽b010边闸孔侧收缩系数ξb0.9088728959总净宽B060侧收缩系数ξ0.9473825816闸墩厚度dz4断面面积2321.5436bb30.95原河道底高程169.5坎顶高程170河道流速2.2786563216闸墩顶高程190.05189.180.87堰上水深H020.3146419282下游水位189.140.91自由过流流量系数m堰流淹没出流系数σ坎高P0.5下游水位hs19.140.9421775716υ00.9623677333闸墩高H20.55淹没系数σ0.6959583862Q5302.9193508963m(直角)0.3822201872m(圆角)0.3840653286自由过流流量Q淹没过流流量QQ(直角)8811.5746737045Q(直角)6132.4892897839Q(圆角)8854.1119380626Q(圆角)6162.09345563985290宽顶堰堰流泄流能力计算(P=2)闸门孔数n6中间闸墩侧收缩系数ξz0.9550845188单孔净宽b010边闸孔侧收缩系数ξb0.9088728959总净宽B060侧收缩系数ξ0.9473825816闸墩厚度dz4断面面积2321.5436bb30.95原河道底高程169.5坎顶高程170河道流速2.0159001106闸墩顶高程188.94188.160.78堰上水深H019.1471280966下游水位188.12自由过流流量系数m堰流淹没出流系数σ坎高P0.5下游水位hs18.120.9463560231υ00.9648268924闸墩高H19.44淹没系数σ0.678382939Q4706.5121485698m(直角)0.3820559384m(圆角)0.3840136224自由过流流量Q淹没过流流量QQ(直角)8059.5086561445Q(直角)5467.4331687561Q(圆角)8100.8061989871Q(圆角)5495.44871724174680宽顶堰堰流泄流能力计算(P=5)闸门孔数n6中间闸墩侧收缩系数ξz0.9550845188单孔净宽b010边闸孔侧收缩系数ξb0.9097803161总净宽B060侧收缩系数ξ0.9475338183闸墩厚度dz4断面面积1715.1756bb25.9原河道底高程169.5坎顶高程170河道流速2.2504984329闸墩顶高程186.97186.430.54堰上水深H017.2281418551下游水位186.39自由过流流量系数m堰流淹没出流系数σ坎高P0.5下游水位hs16.390.9513504206υ00.967812076闸墩高H17.47淹没系数σ0.655819205Q3857.5187073528m(直角)0.3817153319m(圆角)0.3839062356自由过流流量Q淹没过流流量QQ(直角)6873.7341914423Q(直角)4507.9268926861Q(圆角)6913.1868625995Q(圆角)4533.80071211873860宽顶堰堰流泄流能力计算(P=10)闸门孔数n6中间闸墩侧收缩系数ξz0.9550845188单孔净宽b010边闸孔侧收缩系数ξb0.9107000813总净宽B060侧收缩系数ξ0.9476871125闸墩厚度dz4断面面积1468.0005bb23原河道底高程169.5坎顶高程170河道流速2.2070837169闸墩顶高程185.35184.890.46堰上水深H015.5982782127下游水位184.85自由过流流量系数m堰流淹没出流系数σ坎高P0.5下游水位hs14.850.9520281532υ00.9682210053闸墩高H15.85淹没系数σ0.6526139406Q3303.7850998305m(直角)0.3813749022m(圆角)0.3837986849自由过流流量Q淹没过流流量QQ(直角)5917.4259128552Q(直角)3861.7946429476Q(圆角)5955.0334075744Q(圆角)3886.33781827093240宽顶堰堰流泄流能力计算(P=20)闸门孔数n6中间闸墩侧收缩系数ξz0.9550845188单孔净宽b010边闸孔侧收缩系数ξb0.9107000813总净宽B060侧收缩系数ξ0.9476871125闸墩厚度dz4断面面积1468.0005bb23原河道底高程169.5坎顶高程170河道流速1.8119884837闸墩顶高程183.76183.350.41堰上水深H013.9273446618下游水位183.32自由过流流量系数m堰流淹没出流系数σ坎高P0.5下游水位hs13.320.9563919271υ00.970876013闸墩高H14.26淹没系数σ0.6310657927Q2677.1018335726m(直角)0.3809696305m(圆角)0.3836703617自由过流流量Q淹没过流流量QQ(直角)4987.2204793361Q(直角)3147.264245126Q(圆角)5022.5753749438Q(圆角)3169.57551034832660宽顶堰堰流泄流能力计算(P=50)闸门孔数n6中间闸墩侧收缩系数ξz0.9550845188单孔净宽b010边闸孔侧收缩系数ξb0.9107000813总净宽B060侧收缩系数ξ0.9476871125闸墩厚度dz4断面面积1468.0005bb23原河道底高程169.5坎顶高程170河道流速1.1444137792闸墩顶高程180.43180.120.31堰上水深H010.4967524413下游水位180.08自由过流流量系数m堰流淹没出流系数σ坎高P0.5下游水位hs10.080.9602970115υ00.9732842354闸墩高H10.93淹没系数σ0.6103048712Q1682.3586421936m(直角)0.3797653069m(圆角)0.3832871773自由过流流量Q淹没过流流量QQ(直角)3252.8455772831Q(直角)1985.2275010411Q(圆角)3283.0118413286Q(圆角)2003.63811893371680宽顶堰堰流泄流能力计算(P=1)闸门孔数n4中间闸墩侧收缩系数ξz0.9550845188单孔净宽b010边闸孔侧收缩系数ξb0.9088728959总净宽B040侧收缩系数ξ0.9435316131闸墩厚度dz4断面面积2321.5436bb30.95原河道底高程169.5坎顶高程170河道流速2.2786563216闸墩顶高程191.1189.181.92堰上水深H021.3646419282下游水位189.141.96自由过流流量系数m堰流淹没出流系数σ坎高P0.5下游水位hs19.140.8958727258υ00.9374533973闸墩高H21.6淹没系数σ0.8373057908Q4739.2509610057m(直角)0.3823605858m(圆角)0.3841094863自由过流流量Q淹没过流流量QQ(直角)6312.2253432726Q(直角)5285.2628328741Q(圆角)6341.097184858Q(圆角)5309.43739302515290宽顶堰堰流泄流能力计算(P=2)闸门孔数n4中间闸墩侧收缩系数ξz0.9550845188单孔净宽b010边闸孔侧收缩系数ξb0.9088728959总净宽B040侧收缩系数ξ0.9435316131闸墩厚度dz4断面面积2321.5436bb30.95原河道底高程169.5坎顶高程170河道流速2.0159001106闸墩顶高程189.93188.161.77堰上水深H020.1371280966下游水位188.12自由过流流量系数m堰流淹没出流系数σ坎高P0.5下游水位hs18.120.8998303985υ00.939415228闸墩高H20.43淹没系数σ0.8280699389Q4281.2496720876m(直角)0.382203258m(圆角)0.3840600016自由过流流量Q淹没过流流量QQ(直角)5773.7321489516Q(直角)4781.0540279769Q(圆角)5801.7809417466Q(圆角)4804.28039011384680宽顶堰堰流泄流能力计算(P=5)闸门孔数n4中间闸墩侧收缩系数ξz0.9550845188单孔净宽b010边闸孔侧收缩系数ξb0.9097803161总净宽B040侧收缩系数ξ0.9437584681闸墩厚度dz4断面面积1715.1756bb25.9原河道底高程169.5坎顶高程170河道流速2.2504984329闸墩顶高程188.05186.431.62堰上水深H018.3081418551下游水位186.39自由过流流量系数m堰流淹没出流系数σ坎高P0.5下游水位hs16.390.8952301184υ00.937137811闸墩高H18.55淹没系数σ0.8387668272Q3767.1316903686m(直角)0.3819106421m(圆角)0.3839678401自由过流流量Q淹没过流流量QQ(直角)5002.6315510715Q(直角)4196.0413936377Q(圆角)5029.5787011033Q(圆角)4218.64376917143860宽顶堰堰流泄流能力计算(P=10)闸门孔数n4中间闸墩侧收缩系数ξz0.9550845188单孔净宽b010边闸孔侧收缩系数ξb0.9107000813总净宽B040侧收缩系数ξ0.9439884094闸墩厚度dz4断面面积1468.0005bb23原河道底高程169.5坎顶高程170河道流速2.2070837169闸墩顶高程186.26184.891.37堰上水深H016.5082782127下游水位184.85自由过流流量系数m堰流淹没出流系数σ坎高P0.5下游水位hs14.850.8995486876υ00.9392745475闸墩高H16.76淹没系数σ0.8287411436Q3180.7953806361m(直角)0.3815738565m(圆角)0.3838615665自由过流流量Q淹没过流流量QQ(直角)4280.6274806581Q(直角)3547.5321135504Q(圆角)4306.2918027785Q(圆角)3568.80119321363240宽顶堰堰流泄流能力计算(P=20)闸门孔数n4中间闸墩侧收缩系数ξz0.9550845188单孔净宽b010边闸孔侧收缩系数ξb0.9107000813总净宽B040侧收缩系数ξ0.9439884094闸墩厚度dz4断面面积1468.0005bb23原河道底高程169.5坎顶高程170河道流速1.8119884837闸墩顶高程184.65183.351.3堰上水深H014.8173446618下游水位183.32自由过流流量系数m堰流淹没出流系数σ坎高P0.5下游水位hs13.320.8989464917υ00.9389743557闸墩高H15.15淹没系数σ0.8301687476Q2710.2345202868m(直角)0.381206427m(圆角)0.3837453777自由过流流量Q淹没过流流量QQ(直角)3636.5699302136Q(直角)3018.966704662Q(圆角)3660.7905914796Q(圆角)3039.07394069222660宽顶堰堰流泄流能力计算(P=50)闸门孔数n4中间闸墩侧收缩系数ξz0.9550845188单孔净宽b010边闸孔侧收缩系数ξb0.9107000813总净宽B040侧收缩系数ξ0.9439884094闸墩厚度dz4断面面积1468.0005bb23原河道底高程169.5坎顶高程170河道流速1.1444137792闸墩顶高程181.02180.120.9堰上水深H011.0867524413下游水位180.08自由过流流量系数m堰流淹没出流系数σ坎高P0.5下游水位hs10.080.9091932063υ00.9441811182闸墩高H11.52淹没系数σ0.8044804569Q1691.0841379339m(直角)0.380026083m(圆角)0.3833703856自由过流流量Q淹没过流流量QQ(直角)2346.3677745582Q(直角)1887.6070193175Q(圆角)2367.0162624093Q(圆角)1904.21832425811680宽顶堰堰流泄流能力计算(P=1)闸门孔数n5中间闸墩侧收缩系数ξz0.9550845188单孔净宽b010边闸孔侧收缩系数ξb0.9088728959总净宽B050侧收缩系数ξ0.9458421942闸墩厚度dz4断面面积2321.5436bb30.95原河道底高程169.5坎顶高程170河道流速2.2786563216闸墩顶高程190.62189.181.44堰上水深H020.8846419282下游水位189.141.48自由过流流量系数m堰流淹没出流系数σ坎高P0.5下游水位hs19.140.9164629236υ00.9480024897闸墩高H21.12淹没系数σ0.7842934508Q5305.2102994158m(直角)0.3822980714m(圆角)0.3840898291自由过流流量Q淹没过流流量QQ(直角)7643.298969044Q(直角)5994.5893242685Q(圆角)7679.1216442798Q(圆角)6022.68481384765290宽顶堰堰流泄流能力计算(P=2)闸门孔数n5中间闸墩侧收缩系数ξz0.9550845188单孔净宽b010边闸孔侧收缩系数ξb0.9088728959总净宽B050侧收缩系数ξ0.9458421942闸墩厚度dz4断面面积2321.5436bb30.95原河道底高程169.5坎顶高程170河道流速2.0159001106闸墩顶高程189.42188.161.26堰上水深H019.6271280966下游水位188.12自由过流流量系数m堰流淹没出流系数σ坎高P0.5下游水位hs18.120.9232119906υ00.9516447918闸墩高H19.92淹没系数σ0.7638899214Q4686.0421600821m(直角)0.3821291229m(圆角)0.3840366675自由过流流量Q淹没过流流量QQ(直角)6960.3882110319Q(直角)5316.970403225Q(圆角)6995.1336675521Q(圆角)5343.51210727414680宽顶堰堰流泄流能力计算(P=5)闸门孔数n5中间闸墩侧收缩系数ξz0.9550845188单孔净宽b010边闸孔侧收缩系数ξb0.9097803161总净宽B050侧收缩系数ξ0.9460236782闸墩厚度dz4断面面积1715.1756bb25.9原河道底高程169.5坎顶高程170河道流速2.2504984329闸墩顶高程187.38186.430.95堰上水深H017.6381418551下游水位186.39自由过流流量系数m堰流淹没出流系数σ坎高P0.5下游水位hs16.390.929236205υ00.9549728582闸墩高H17.88淹没系数σ0.7441535343Q3870.7934325147m(直角)0.3817921347m(圆角)0.3839304692自由过流流量Q淹没过流流量QQ(直角)5925.537301247Q(直角)4409.5095251948Q(圆角)5958.7249443072Q(圆角)4434.20622707223860宽顶堰堰流泄流能力计算(P=10)闸门孔数n5中间闸墩侧收缩系数ξz0.9550845188单孔净宽b010边闸孔侧收缩系数ξb0.9107000813总净宽B050侧收缩系数ξ0.9462076313闸墩厚度dz4断面面积1468.0005bb23原河道底高程169.5坎顶高程170河道流速2.2070837169闸墩顶高程185.67184.890.78堰上水深H015.9182782127下游水位184.85自由过流流量系数m堰流淹没出流系数σ坎高P0.5下游水位hs14.850.9328898391υ00.957026661闸墩高H16.17淹没系数σ0.7314045451Q3251.5520902813m(直角)0.3814472943m(圆角)0.3838215739自由过流流量Q淹没过流流量QQ(直角)5076.7365534368Q(直角)3713.148189637Q(圆角)5108.3361793958Q(圆角)3736.2602996883240宽顶堰堰流泄流能力计算(P=20)闸门孔数n5中间闸墩侧收缩系数ξz0.9550845188单孔净宽b010边闸孔侧收缩系数ξb0.9107000813总净宽B050侧收缩系数ξ0.9462076313闸墩厚度dz4断面面积1468.0005bb23原河道底高程169.5坎顶高程170河道流速1.8119884837闸墩顶高程184.05183.350.7堰上水深H014.2173446618下游水位183.32自由过流流量系数m堰流淹没出流系数σ坎高P0.5下游水位hs13.320.9368838075υ00.959302319闸墩高H14.55淹没系数σ0.7167274363Q2679.3990619458m(直角)0.3810498019m(圆角)0.3836957716自由过流流量Q淹没过流流量QQ(直角)4280.7062841134Q(直角)3068.0996404967Q(圆角)4310.4310570045Q(圆角)3089.40420076512660宽顶堰堰流泄流能力计算(P=50)闸门孔数n5中间闸墩侧收缩系数ξz0.9550845188单孔净宽b010边闸孔侧收缩系数ξb0.9107000813总净宽B050侧收缩系数ξ0.9462076313闸墩厚度dz4断面面积1468.0005bb23原河道底高程169.5坎顶高程170河道流速1.1444137792闸墩顶高程180.63180.120.51堰上水深H010.6967524413下游水位180.08自由过流流量系数m堰流淹没出流系数σ坎高P0.5下游水位hs10.080.9423420852υ00.9624638948闸墩高H11.13淹没系数σ0.6952870492Q1686.5470347508m(直角)0.3798565917m(圆角)0.3833163193自由过流流量Q淹没过流流量QQ(直角)2784.8610864497Q(直角)1936.2778472Q(圆角)2810.2255555727Q(圆角)1953.91343409081680驼峰堰堰流泄流能力计算(P=1)闸门孔数n5中间闸墩侧收缩系数ξz0.9550845188单孔净宽b010边闸孔侧收缩系数ξb0.9088728959总净宽B050侧收缩系数ξ0.9458421942闸墩厚度dz4断面面积2321.5436bb30.95原河道底高程169.5坎顶高程173河道流速2闸墩顶高程190.338189.181.158堰上水深H017.5418735984下游水位189.141.198自由过流流量系数m堰流淹没出流系数σ坎高P3.5下游水位hs16.140.920084158υ00.9499454524闸墩高H17.838淹没系数σ0.7735576489Q4018.4138942123m(a型)0.4443049438自由过流流量Q淹没过流流量QQ(a型)6838.0662090658Q(a型)5289.63841967665290驼峰堰堰流泄流能力计算(P=2)闸门孔数n5中间闸墩侧收缩系数ξz0.9550845188单孔净宽b010边闸孔侧收缩系数ξb0.9088728959总净宽B050侧收缩系数ξ0.9458421942闸墩厚度dz4断面面积2321.5436bb30.95原河道底高程169.5坎顶高程173河道流速2闸墩顶高程189.134188.160.974堰上水深H016.3378735984下游水位188.12自由过流流量系数m堰流淹没出流系数σ坎高P3.5下游水位hs15.120.9254570314υ00.9528765762闸墩高H16.634淹没系数σ0.7567125085Q3519.5536538527m(a型)0.4471411593自由过流流量Q淹没过流流量QQ(a型)6185.5188679786Q(a型)4680.65949901644680驼峰堰堰流泄流能力计算(P=5)闸门孔数n5中间闸墩侧收缩系数ξz0.9550845188单孔净宽b010边闸孔侧收缩系数ξb0.9097803161总净宽B050侧收缩系数ξ0.9460236782闸墩厚度dz4断面面积1715.1756bb25.9原河道底高程169.5坎顶高程173河道流速2闸墩顶高程187.206186.430.776堰上水深H014.4098735984下游水位186.39自由过流流量系数m堰流淹没出流系数σ坎高P3.5下游水位hs13.390.9292239733υ00.9549660273闸墩高H14.706淹没系数σ0.7441951869Q2858.5099850408m(a型)0.4524852845自由过流流量Q淹没过流流量QQ(a型)5185.8055619408Q(a型)3859.25153918773860驼峰堰堰流泄流能力计算(P=10)闸门孔数n5中间闸墩侧收缩系数ξz0.9550845188单孔净宽b010边闸孔侧收缩系数ξb0.9107000813总净宽B050侧收缩系数ξ0.9462076313闸墩厚度dz4断面面积1468.0005bb23原河道底高程169.5坎顶高程173河道流速2闸墩顶高程185.539184.890.649堰上水深H012.7428735984下游水位184.85自由过流流量系数m堰流淹没出流系数σ坎高P3.5下游水位hs11.850.9299315346υ00.955361664闸墩高H13.039淹没系数σ0.7417746674Q2367.9863321331m(a型)0.4581624348自由过流流量Q淹没过流流量QQ(a型)4367.4354315253Q(a型)3239.65296475363240驼峰堰堰流泄流能力计算(P=20)闸门孔数n5中间闸墩侧收缩系数ξz0.9550845188单孔净宽b010边闸孔侧收缩系数ξb0.9107000813总净宽B050侧收缩系数ξ0.9462076313闸墩厚度dz4断面面积1468.0005bb23原河道底高程169.5坎顶高程173河道流速2闸墩顶高程183.885183.350.535堰上水深H011.0888735984下游水位183.32自由过流流量系数m堰流淹没出流系数σ坎高P3.5下游水位hs10.320.9306626059υ00.9557714984闸墩高H11.385淹没系数σ0.7392498589Q1914.5172641482m()0.4463276223自由过流流量Q淹没过流流量QQ()3453.7497538697Q()2553.18401830692660驼峰堰堰流泄流能力计算(P=50)闸门孔数n5中间闸墩侧收缩系数ξz0.9550845188单孔净宽b010边闸孔侧收缩系数ξb0.9107000813总净宽B050侧收缩系数ξ0.9462076313闸墩厚度dz4断面面积1468.0005bb23原河道底高程169.5坎顶高程173河道流速2闸墩顶高程180.78180.120.66堰上水深H07.9838735984下游水位180.08自由过流流量系数m堰流淹没出流系数σ坎高P3.5下游水位hs7.080.8867875866υ00.9330683612闸墩高H8.28淹没系数σ0.8570165416Q1390.2682722467m()0.42自由过流流量Q淹没过流流量QQ()1985.5266537398Q()1701.62918598341680宽顶堰堰流泄流能力计算(P=50)闸门孔数n5中间闸墩侧收缩系数ξz0.9550845188单孔净宽b010边闸孔侧收缩系数ξb0.9088728959总净宽B050侧收缩系数ξ0.9458421942闸墩厚度dz4断面面积1200bb30.95原河道底高程170坎顶高程180河道流速1.4闸墩顶高程187.75180.127.63堰上水深H07.8498980632下游水位180.087.67自由过流流量系数m堰流淹没出流系数σ坎高P10下游水位hs0.080.0101912151υ01.2863552812闸墩高H8.25淹没系数σ0.0234454445Q63.4974992238m(直角)0.3330588756m(圆角)0.3659236948自由过流流量Q淹没过流流量QQ(直角)1534.4587824177Q(直角)35.9760682568Q(圆角)1685.8725837058Q(圆角)39.5260321351680宽顶堰堰流泄流能力计算(P=20)闸门孔数n5中间闸墩侧收缩系数ξz0.9550845188单孔净宽b010边闸孔侧收缩系数ξb0.9088728959总净宽B050侧收缩系数ξ0.9458421942闸墩厚度dz4断面面积1200bb30.95原河道底高程170坎顶高程180河道流速2闸墩顶高程190.4183.357.05堰上水深H010.6038735984下游水位183.327.08自由过流流量系数m堰流淹没出流系数σ坎高P10下游水位hs3.320.3130931324υ00.9905062375闸墩高H10.9淹没系数σ0.6223642886Q1964.6018051853m(直角)0.3381396836m(圆角)0.3680840456自由过流流量Q淹没过流流量QQ(直角)2445.8574684036Q(直角)1522.2143434451Q(圆角)2662.4532868443Q(圆角)1657.0158459122660宽顶堰堰流泄流能力计算(P=10)闸门孔数n5中间闸墩侧收缩系数ξz0.9550845188单孔净宽b010边闸孔侧收缩系数ξb0.9088728959总净宽B050侧收缩系数ξ0.9458421942闸墩厚度dz4断面面积1200bb30.95原河道底高程170坎顶高程180河道流速2闸墩顶高程191.88184.896.99堰上水深H012.0838735984下游水位184.857.03自由过流流量系数m堰流淹没出流系数σ坎高P10下游水位hs4.850.4013613648υ00.9388211709闸墩高H12.38淹没系数σ0.7551155984Q2710.8663775819m(直角)0.3405687089m(圆角)0.3690903001自由过流流量Q淹没过流流量QQ(直角)2996.7615887998Q(直角)2262.9014203998Q(圆角)3247.7312369066Q(圆角)2452.41251641113240宽顶堰堰流泄流能力计算(P=5)闸门孔数n5中间闸墩侧收缩系数ξz0.9550845188单孔净宽b010边闸孔侧收缩系数ξb0.9088728959总净宽B050侧收缩系数ξ0.9458421942闸墩厚度dz4断面面积1200bb30.95原河道底高程170坎顶高程180河道流速2闸墩顶高程193.35186.436.92堰上水深H013.5538735984下游水位186.396.96自由过流流量系数m堰流淹没出流系数σ坎高P10下游水位hs6.390.4714519398υ00.9088794098闸墩高H13.85淹没系数σ0.8438848694Q3440.956007308m(直角)0.3427452959m(圆角)0.3699778621自由过流流量Q淹没过流流量QQ(直角)3582.6537693827Q(直角)3023.3473084267Q(圆角)3867.3107931241Q(圆角)3263.56506374213860宽顶堰堰流泄流能力计算(P=2)闸门孔数n5中间闸墩侧收缩系数ξz0.9550845188单孔净宽b010边闸孔侧收缩系数ξb0.9088728959总净宽B050侧收缩系数ξ0.9458421942闸墩厚度dz4断面面积1200bb30.95原河道底高程170坎顶高程180河道流速2闸墩顶高程195.17188.167.01堰上水深H015.3738735984下游水位188.127.05自由过流流量系数m堰流淹没出流系数σ坎高P10下游水位hs8.120.5281687759υ00.8918428472闸墩高H15.67淹没系数σ0.9034401227Q4317.4507732805m(直角)0.3451628343m(圆角)0.3709484085自由过流流量Q淹没过流流量QQ(直角)4358.5012570554Q(直角)3937.6449102498Q(圆角)4684.1054244256Q(圆角)4231.80877915464680宽顶堰堰流泄流能力计算(P=1)闸门孔数n5中间闸墩侧收缩系数ξz0.9550845188单孔净宽b010边闸孔侧收缩系数ξb0.9088728959总净宽B050侧收缩系数ξ0.9458421942闸墩厚度dz4断面面积1200bb30.95原河道底高程170坎顶高程180河道流速2闸墩顶高程196.46189.187.28堰上水深H016.6638735984下游水位189.147.32自由过流流量系数m堰流淹没出流系数σ坎高P10下游水位hs9.140.5484919185υ00.8873038906闸墩高H16.96淹没系数σ0.9218248772Q4924.2190838718m(直角)0.3467161604m(圆角)0.3715637022自由过流流量Q淹没过流流量QQ(直角)4940.5604616396Q(直角)4554.3315406838Q(圆角)5294.6275533261Q(圆角)4880.71939398645290宽顶堰堰流泄流能力计算(P=1)闸门孔数n5中间闸墩侧收缩系数ξz0.9550845188单孔净宽b010边闸孔侧收缩系数ξb0.9088728959总净宽B050侧收缩系数ξ0.9458421942闸墩厚度dz4断面面积2321.5436bb30.95原河道底高程169.5坎顶高程171.5河道流速2.2上游水位192.364428189.2堰上水深H021.111115054下游水位190.5自由过流流量系数m堰流淹没出流系数σ坎高P2下游水位hs190.8999998319υ00.939499916闸墩高H21.364428淹没系数σ0.8276652095Q5741.22196697m(直角)0.3748157437m(圆角)0.3816826497自由过流流量Q淹没过流流量QQ(直角)7615.9270158048Q(直角)6303.4378290366Q(圆角)7755.4565206032Q(圆角)6418.921545856460925孔单宽:10m堰上水位下泄流量5孔单宽:10m1801660180.6291660180.6291660堰上水位下泄流量180.51790181.161790181.161790191.6358471811910181.6771910181.6771910190.4552061822210182.7642210182.7642210189.346201832550183.8772550183.8772550188.241001842900184.9842900184.9842900187.653885184.53108185.5633108185.5633108186.5534981853297186.123297186.123297185.483100185.53481186.673481186.673481184.9629951863681187.2313681187.2313681183.682610186.53882187.793882187.793882182.5522501874101188.3624101188.3624101181.461962187.54330188.9384330188.9384330180.9318271884614189.5594614189.5594614180.391667188.54899190.1435428.656190.1434899179.3314131895206190.6985670.576190.6985206178.141200189.55513191.2545917.21191.2545513177.059621905842191.8096166.097191.8095842175.99747190.56092192.3644286418.922192.3644286092174.94556174.58502173.89380172.9242172.32171171.81124171.2867170.7734170.26111700宽顶堰堰流泄流能力计算(P=3.33%)孔口高度he1闸门孔数n1单孔净宽b010总净宽B010闸墩厚度dz4断面面积870.2059坎顶高程170闸前水位180堰上水深H10he/H0.1孔流流速系数ψ0.9行近流速v2H010.2038735984孔流垂直收缩系数ξ0.615孔流流量系数υ0.5535Q78.315849258下游水位171.638.37过闸单宽流量q7.8315849258流速v2闸前水位H10水流动能校正系数α1流速系数Ф0.95重力加速度g9.81水跃淹没系数σ01.05下游水位hs1.63引水角δ0总势能T010.2038735984αq2/2gФ23.4638024092T0hc2-hc33.4573944954收缩水深hc0.6弗罗德数Fr228.9452006881跃后水深hc''4.27499120171.63先取一个d值2.3势能T12.5038735984消力池出口宽度B114αq2/2gФ23.4638024092Thc2-hc33.4634503178收缩水深hc0.538弗罗德数Fr240.149809517跃后水深hc''4.55951984894.0215198489行近流速v100.1168458296出池水流的水面降落值Δz1.1533303959验算淹没安全系数σ01.11488283071.05~1.1水跃长度校正系数0.8自由水跃长度Lj27.7484869577消力池斜坡段水平投影长度Ls12.5消力池长度Lsj34.6987895662假定坎高c5hn-3.37假定H100.663hn/H10-5.0829562594查表σs1计算H102.60715737165.0223147299-0.2348188885宽顶堰堰流泄流能力计算(P=1)闸门孔数n1中间闸墩侧收缩系数ξz0.9550845188单孔净宽b010边闸孔侧收缩系数ξb0.9088728959总净宽B010侧收缩系数ξ0.9088728959闸墩厚度dz4断面面积2321.5436bb30.95原河道底高程169.5坎顶高程170河道流速2.2786563216闸墩顶高程180189.18-9.18堰上水深H010.2646419282下游水位174.655.35自由过流流量系数m堰流淹没出流系数σ0.72坎高P0.5下游水位hs4.650.4530114185υ00.9158045013闸墩高H10.5淹没系数σ0.8220768773Q446.7296669929m(直角)0.3795581172m(圆角)0.3832209738自由过流流量Q淹没过流流量QQ(直角)502.5122386913Q(直角)413.1036920125Q(圆角)507.3616416695Q(圆角)417.09027406985290宽顶堰堰流泄流能力计算(P=3.33%)宽顶堰堰流泄流能力计算(P=3.33%)宽顶堰堰流泄流能力计算(P=3.33%)宽顶堰堰流泄流能力计算(P=3.33%)宽顶堰堰流泄流能力计算(P=3.33%)宽顶堰堰流泄流能力计算(P=3.33%)宽顶堰堰流泄流能力计算(P=3.33%)宽顶堰堰流泄流能力计算(P=3.33%)孔口高度he1孔口高度he2孔口高度he3孔口高度he4孔口高度he5孔口高度he6孔口高度he6.5孔口高度he4闸门孔数n1闸门孔数n1闸门孔数n1闸门孔数n1闸门孔数n1闸门孔数n1闸门孔数n1闸门孔数n5单孔净宽b010单孔净宽b010单孔净宽b010单孔净宽b010单孔净宽b010单孔净宽b010单孔净宽b010单孔净宽b010总净宽B010总净宽B010总净宽B010总净宽B010总净宽B010总净宽B010总净宽B010总净宽B050闸墩厚度dz4闸墩厚度dz4闸墩厚度dz4闸墩厚度dz4闸墩厚度dz4闸墩厚度dz4闸墩厚度dz4闸墩厚度dz4断面面积870.2059断面面积870.2059断面面积870.2059断面面积870.2059断面面积870.2059断面面积870.2059断面面积870.2059断面面积870.2059坎顶高程170坎顶高程170坎顶高程170坎顶高程170坎顶高程170坎顶高程170坎顶高程170坎顶高程170闸前水位180闸前水位180闸前水位180闸前水位180闸前水位180闸前水位180闸前水位180闸前水位180堰上水深H10堰上水深H10堰上水深H10堰上水深H10堰上水深H10堰上水深H10堰上水深H10堰上水深H10he/H0.1he/H0.2he/H0.3he/H0.4he/H0.5he/H0.6he/H0.65he/H0.4孔流流速系数ψ0.9孔流流速系数ψ0.9孔流流速系数ψ0.9孔流流速系数ψ0.9孔流流速系数ψ0.9孔流流速系数ψ0.9孔流流速系数ψ0.9孔流流速系数ψ0.9行近流速v2行近流速v2行近流速v2行近流速v2行近流速v2行近流速v2行近流速v2行近流速v2H010.2038735984H010.2038735984H010.2038735984H010.2038735984H010.2038735984H010.2038735984H010.2038735984H010.2038735984孔流垂直收缩系数ξ0.615孔流垂直收缩系数ξ0.62孔流垂直收缩系数ξ0.625孔流垂直收缩系数ξ0.63孔流垂直收缩系数ξ0.645孔流垂直收缩系数ξ0.645孔流垂直收缩系数ξ0.645孔流垂直收缩系数ξ0.645孔流流量系数υ0.5535孔流流量系数υ0.558孔流流量系数υ0.5625孔流流量系数υ0.567孔流流量系数υ0.5805孔流流量系数υ0.5805孔流流量系数υ0.5805孔流流量系数υ0.5805Q78.315849258Q157.9051269592Q238.7678331036Q320.9039676913Q410.6806729382Q492.8168075259Q533.8848748197Q1642.7226917529下游水位171.638.37下游水位172.397.61下游水位173.086.92下游水位173.666.34下游水位174.235.77下游水位174.655.35下游水位174.935.07下游水位179.930.07过闸单宽流量q7.8315849258过闸单宽流量q15.7905126959过闸单宽流量q23.8767833104过闸单宽流量q32.0903967691过闸单宽流量q41.0680672938过闸单宽流量q35.2012005376过闸单宽流量q53.388487482过闸单宽流量q25.2726567962流速v2流速v2流速v2流速v2流速v2流速v2流速v2流速v2闸前水位H10闸前水位H10闸前水位H10闸前水位H10闸前水位H10闸前水位H10闸前水位H10闸前水位H10水流动能校正系数α1水流动能校正系数α1水流动能校正系数α1水流动能校正系数α1水流动能校正系数α1水流动能校正系数α1水流动能校正系数α1水流动能校正系数α1流速系数Ф0.95流速系数Ф0.95流速系数Ф0.95流速系数Ф0.95流速系数Ф0.95流速系数Ф0.95流速系数Ф0.95流速系数Ф0.95重力加速度g9.81重力加速度g9.81重力加速度g9.81重力加速度g9.81重力加速度g9.81重力加速度g9.81重力加速度g9.81重力加速度g9.81水跃淹没系数σ01.05水跃淹没系数σ01.05水跃淹没系数σ01.05水跃淹没系数σ01.05水跃淹没系数σ01.05水跃淹没系数σ01.05水跃淹没系数σ01.05水跃淹没系数σ01.05下游水面超过堰顶的高度hs1.63下游水面超过堰顶的高度hs2.39下游水面超过堰顶的高度hs3.08下游水面超过堰顶的高度hs3.66下游水面超过堰顶的高度hs4.23下游水面超过堰顶的高度hs4.65下游水面超过堰顶的高度hs4.93下游水面超过堰顶的高度hs9.93引水角δ0引水角δ0引水角δ0引水角δ0引水角δ0引水角δ0引水角δ0引水角δ0总势能T010.2038735984总势能T010.2038735984总势能T010.2038735984总势能T010.2038735984总势能T010.2038735984总势能T010.2038735984总势能T010.2038735984总势能T010.2038735984αq2/2gФ23.4638024092αq2/2gФ214.0814134031αq2/2gФ232.1962597525αq2/2gФ258.1572630562αq2/2gФ295.2494148517αq2/2gФ269.9791619319αq2/2gФ2160.9715110994αq2/2gФ236.0707843225T0hc2-hc33.4573944954T0hc2-hc314.0946996393T0hc2-hc332.1835988396T0hc2-hc358.1472502955T0hc2-hc395.2361401213T0hc2-hc369.9920607798T0hc2-hc3157.3920823568T0hc2-hc336.0347346473收缩水深hc0.6收缩水深hc1.255收缩水深hc1.978收缩水深hc2.803收缩水深hc3.881收缩水深hc3.15收缩水深hc6.82收缩水深hc2.11弗罗德数Fr228.9452006881弗罗德数Fr212.8585582776弗罗德数Fr27.5093745591弗罗德数Fr24.7666347296弗罗德数Fr22.9410918952弗罗德数Fr24.0412366407弗罗德数Fr20.9159528182弗罗德数Fr26.9308328646跃后水深hc''4.27499120171.63跃后水深hc''5.7677214782.39跃后水深hc''6.74008381543.08跃后水深hc''7.36578461593.66跃后水深hc''7.67011598094.23跃后水深hc''7.51779748674.65跃后水深hc''6.43044855294.93跃后水深hc''6.87131988969.93先取一个d值d2.3先取一个d值d2.3先取一个d值d2.2先取一个d值d2先取一个d值d0.5先取一个d值d2.5先取一个d值d2.5先取一个d值d2.5势能T12.5038735984势能T12.5038735984势能T12.4038735984势能T12.2038735984势能T10.7038735984势能T12.7038735984势能T12.7038735984势能T12.7038735984消力池出口宽度B114消力池出口宽度B114消力池出口宽度B114消力池出口宽度B114消力池出口宽度B114消力池出口宽度B114消力池出口宽度B114消力池出口宽度B114αq2/2gФ23.4638024092αq2/2gФ214.0814134031αq2/2gФ232.1962597525αq2/2gФ258.1572630562αq2/2gФ295.2494148517αq2/2gФ269.9791619319αq2/2gФ2160.9715110994αq2/2gФ236.0707843225Thc2-hc33.4634503178Thc2-hc314.0865529468Thc2-hc332.2178070897Thc2-hc358.1301978552Thc2-hc395.2345626955Thc2-hc369.6799762926Thc2-hc3161.8370681672Thc2-hc336.0517429072收缩水深hc0.538收缩水深hc1.112收缩水深hc1.738收缩水深hc2.44收缩水深hc3.683收缩水深hc2.63收缩水深hc4.42收缩水深hc1.82弗罗德数Fr240.149809517弗罗德数Fr218.4845589781弗罗德数Fr211.0696352892弗罗德数Fr27.2262284492弗罗德数Fr23.441393753弗罗德数Fr26.9435041252弗罗德数Fr23.3648012691弗罗德数Fr210.7998724908跃后水深hc''4.55951984894.0215198489跃后水深hc''6.22803102845.1160310284跃后水深hc''7.35474706795.6167470679跃后水深hc''8.13588303645.6958830364跃后水深hc''7.9947908494.311790849跃后水深hc''8.5735930428跃后水深hc''9.4671703349跃后水深hc''7.5973553633行近流速v100.1168458296行近流速v100.1724757844行近流速v100.2208466122行近流速v100.2683200064行近流速v100.3494457988行近流速v100.2793040771行近流速v100.3836278178行近流速v100.2262930021出池水流的水面降落值Δz1.1533303959出池水流的水面降落值Δz2.1375540477出池水流的水面降落值Δz2.8567619866出池水流的水面降落值Δz3.5485771819出池水流的水面降落值Δz3.9783913654出池水流的水面降落值Δz2.3772127753出池水流的水面降落值Δz5.0021079089出池水流的水面降落值Δz-0.1981871791验算淹没安全系数σ01.11488283071.05~1.1验算淹没安全系数σ01.09626204761.05~1.1验算淹没安全系数σ01.1063279147验算淹没安全系数σ01.1318472919验算淹没安全系数σ01.0892581845验算淹没安全系数σ01.1112
/
本文档为【水闸结构自动计算表格Excel】,请使用软件OFFICE或WPS软件打开。作品中的文字与图均可以修改和编辑, 图片更改请在作品中右键图片并更换,文字修改请直接点击文字进行修改,也可以新增和删除文档中的内容。
[版权声明] 本站所有资料为用户分享产生,若发现您的权利被侵害,请联系客服邮件isharekefu@iask.cn,我们尽快处理。 本作品所展示的图片、画像、字体、音乐的版权可能需版权方额外授权,请谨慎使用。 网站提供的党政主题相关内容(国旗、国徽、党徽..)目的在于配合国家政策宣传,仅限个人学习分享使用,禁止用于任何广告和商用目的。

历史搜索

    清空历史搜索