水位流量关系、断面回水计算及库容面积曲线图绘制.xls

水位流量关系、断面回水计算及库容面积曲线图绘制.xls

《水位流量关系、断面回水计算及库容面积曲线图绘制.xls》由会员分享，可在线阅读，更多相关《水位流量关系、断面回水计算及库容面积曲线图绘制.xls（911页珍藏版）》请在冰豆网上搜索。

计算公式：

Q=AR2/3J1/2/n水水位位流流量量关关系系曲曲线线计计算算过过程程表表水位（m）Z10981098.51099流量（m3/s）Q107.122.7断面面积A01.5146.052湿周X06.36512.724水力半径R00.2380.476比降（0.0214-0.0254）J0.02140.02140.0214河道糙率（0.045-0.05）n0.050.050.05水水位位流流量量关关系系曲曲线线表表水位（m）Z10981098.51099流量（m3/s）Q107.122.71099.511001100.511011101.5110244.672.0104.4141.5183.0228.613.61924.20237.82054.45974.12496.81219.08825.44131.80438.16444.52450.8830.7130.9511.1891.4271.6651.9030.02140.02140.02140.02140.02140.02140.050.050.050.050.050.051099.511001100.511011101.5110244.672.0104.4141.5183.0228.6水水位位流流量量关关系系曲曲线线计计算算过过程程表表水水位位流流量量关关系系曲曲线线表表1102.51103Q=AR2/3J1/2/n曼曼宁宁公公式式该填充颜色为非输入数据该填充颜色为引用数据注:

令F（X）=A，则nQ/J0.5=F（X）*（F（X）/X）0.6667该填充颜色为输入数据知知Q推推A:

先先假假定定湿湿周周X的的值值，然然后后把把计计算算出出的的面面积积值值A与与实实际际地地形形图图剖剖面面的的面面积积值值比比较较，重重复复选选择择X的的值值，使使计计算算的的面面积积与与实实际际面面积积尽尽量量相相近近即即可可。

多多年年平平均均Q断面D1（坝址）D2D3D4D5Q0.1140.1140.1140.1140.114由假定计算出的A0.1815770.1576190.1803270.2777470.310436R假定值X2.922.052.878.4511.16假定下的面积A0.190.160.190.30.28起始水边点1098.131099.161102.431104.571119.96面积差值-0.00842-0.00238-0.00967-0.022250.030436水面比降J0.040.040.040.040.04河道糙率n0.050.050.050.050.05p=5%的的Q断面D1（坝址）D2D3D4D5Q0.16490.16490.16490.16490.1649A0.2399650.2059620.2382470.3656680.416686R假定值X3.372.33.319.6613.39假定下的面积A0.250.20.250.390.4起始水边点1098.151099.181102.451104.581119.97面积差值-0.010030.005962-0.01175-0.024330.016686水面比降J0.040.040.040.040.04河道糙率n0.050.050.050.050.05p=20%的的Q断面D1（坝址）D2D3D4D5Q0.13650.13650.13650.13650.1365A0.2082650.1799810.2069320.3094470.372011R假定值X3.142.183.098.4513.39假定下的面积A0.220.180.210.30.4起始水边点1098.141099.171102.441104.571119.97面积差值-0.01174-1.9E-05-0.003070.009447-0.02799水面比降J0.040.040.040.040.04河道糙率n0.050.050.050.050.05D6D7D8D9D10D11D120.1140.1140.1140.1140.1140.1140.1140.18157670.1621350.1777870.1427430.1585380.150950.2179652.922.22.771.62.081.844.610.170.160.180.140.150.150.231124.121129.151134.131136.681139.151141.171159.50.01157670.002135-0.002210.0027430.0085380.00095-0.012030.040.040.040.040.040.040.040.050.050.050.050.050.050.05D6D7D8D9D10D11D120.16490.16490.16490.16490.16490.16490.16490.24081750.2129470.2347540.1895980.2129470.1966970.2825533.42.53.191.872.52.055.070.240.210.240.190.220.190.281124.141129.171134.151136.711139.181141.191159.510.00081750.002947-0.00525-0.0004-0.007050.0066970.0025530.040.040.040.040.040.040.040.050.050.050.050.050.050.05D6D7D8D9D10D11D120.13650.13650.13650.13650.13650.13650.13650.20879420.1854690.2039530.1625540.1812950.1717770.2428423.162.352.981.692.221.944.610.20.180.210.160.180.170.231124.131129.161134.141136.691139.161141.181159.5该填充颜色为非输入数据该填充颜色为引用数据该填充颜色为输入数据知知Q推推A:

先先假假定定湿湿周周X的的值值，然然后后把把计计算算出出的的面面积积值值A与与实实际际地地形形图图剖剖面面的的面面积积值值比比较较，重重复复选选择择X的的值值，使使计计算算的的面面积积与与实实际际面面积积尽尽量量相相近近即即可可。

多多年年平平均均Qp=5%的的Qp=20%的的Q0.00879420.005469-0.006050.0025540.0012950.0017770.0128420.040.040.040.040.040.040.040.050.050.050.050.050.050.05k1，k2上、下游流量模数L断面间距（m）；A1、A2上、下断面面积（m2）；表表示示需需要要比比较较后后，两两者者接接近近才才能能取取值值注注：

只只计计算算离离频频率率PP对对应应水水位位相相近近及及超超过过的的断断面面，小小于于频频率率PP水水位位的的直直接接采采用用频频率率PP水水位位设设计计频频率率P=5%P=5%的的流流量量水水面面线线计计算算断断面面编编号号距距离离坝坝址址距距离离（m）深深泓泓线线（m）河河道道多多年年平平均均流流量量水水面面线线（m）断断面面对对应应的的水水位位（m）断断面面面面积积（m2）湿湿周周XX2gA2值值D121549.98460.591159.41159.51161.0038.7633.6829445.81696D111089.3941.7311411141.171143.1925.4223.6512665.05744D101047.6644.1411391139.151141.1424.6518.2711909.401D91003.5251.621136.51136.681138.8223.320.6810640.644D8951.9101.311341134.131136.3544.5229.8138847.79584D7850.6121.711291129.151135.53128.9234.05325759.1814D6728.9121.411241124.121135.53D5607.5332.21119.91119.961135.53D4275.383.21104.51104.571135.53D3192.1116.91102.31102.431135.53D275.275.210991099.161135.53D10010981098.131135.53设设计计频频率率P=20%P=20%的的流流量量水水面面线线计计算算断断面面编编号号距距离离坝坝址址距距离离（m）深深泓泓线线（m）河河道道多多年年平平均均流流量量水水面面线线（m）断断面面对对应应的的水水位位（mm）断断面面面面积积（m2）湿湿周周XX2gA2值值D121549.98460.591159.41159.51160.73530.1432.0917805.02416D111089.3941.7311411141.171142.9119.5420.737483.50736D101047.6644.1411391139.151140.8219.2217.037240.40464D91003.5251.621136.51136.681138.5117.4917.915995.641962222222121211（）（）2222QQZQLkkgAgALLD8951.9101.311341134.131135.9533.3427.2821786.48976D7850.6121.711291129.151135.1116.6232.7266564.3982D6728.9121.411241124.121135.1D5607.5332.21119.91119.961135.1D4275.383.21104.51104.571135.1D3192.1116.91102.31102.431135.1D275.275.210991099.161135.1D10010981098.131135.1水水库库回回水水计计算算成成果果表表断断面面编编号号距距离离坝坝址址距距离离（mm）深深泓泓线线（mm）河河道道多多年年平平均均流流量量水水面面线线（mm）河河道道水水面面线线高高程程（m）P=5%天天然然D121549.981159.41159.51159.51D111089.3911411141.171141.19D101047.6611391139.151139.18D91003.521136.51136.681136.71D8951.911341134.131134.15D7850.611291129.151129.17D6728.911241124.121124.14D5607.51119.91119.961119.97D4275.31104.51104.571104.58D3192.11102.31102.431102.45D275.210991099.161099.18D1010981098.131098.15Q设计频率下的流量（m3/s）；n糙率；R水力半径。

项目天然建库后设计频率为5%的流量Q=0.164989.8水水力力半半径径R糙糙率率nnk2值值1/2k2值值0.273860291-0.3628553371.1508313540.05724730.341.38E-0618.176557130.636715628-0.0403998711.0748414380.05284579.53.514E-062.1111769370.677115499-0.0807371271.3492063490.05362352.842.76E-062.3804242650.7578526260.5502722521.1266924560.05254592.543.928E-061.9425964040.2075803740.1828257691.4934585710.051353405.37.389E-070.6244012420.0247546050.0247546053.7861967690.05392317932.549E-08项目天然建库后设计频率为20%的流量Q=0.136562.5水水力力半半径径R糙糙率率nnk2值值1/2k2值值0.219390323-0.3025908570.9392334060.05334229.312.992E-0618.129789020.52198118-0.017525960.9425952730.05141148.457.085E-062.0937044770.53950714-0.1120077481.1285965940.05173627.465.759E-062.447489730.6515148880.4722179910.9765494140.05118549.198.435E-062.047979161222212（）22QQgAgA2222111（）22QLkk222QgA14222226321*,.AkcARcRkRnn222212（）22QQgAgA2222111（）22QLkk222QgAA1、A2上、下断面面积（m2）；注注：

只只计计算算离离频频率率PP对对应应水水位位相相近近及及超超过过的的断断面面，小小于于频频率率PP水水位位的的直直接接采采用用频频率率PP水水位位设设计计频频率率P=5%P=5%的的流流量量水水面面线线计计算算设设计计频频率率P=20%P=20%的的流流量量水水面面线线计计算算2222222121211（）（）2222QQZQLkkgAgA0.1792968970.1646428391.2221407620.05580968.821.721E-060.6944585010.0146540570.0146540573.5663608560.05296419283.374E-080.0500.0500.0500.0500.050备备注注P=20%建建库库后后天天然然建建库库后后5%差值20%差值1161.011159.501160.721.501.221143.201141.181142.892.011.711141.131139.161140.811.951.651138.831136.691138.482.121.791136.341134.141135.962.191.821135.531129.161135.101135.531124.131135.101135.531119.971135.101135.531104.571135.101135.531102.441135.101135.531099.171135.101135.531098.141135.10坝址水水库库回回水水计计算算成成果果表表河河道道水水面面线线高高程程（m）P=5%河河道道水水面面线线高高程程（m）备备注注P=5%天天然然建建库库后后差差值值#1159.511161.01-0.01#1141.191143.20-0.01#1139.181141.130.01#1136.711138.83-0.01#1134.151136.340.011129.171135.530.001124.141135.530.001119.971135.530.001104.581135.530.001102.451135.530.001099.181135.530.001098.151135.530.00坝址河河道道水水面面线线高高程程（m）备备注注P=20%天天然然建建库库后后#1159.501160.720.02#1141.181142.890.02#1139.161140.810.005#1136.691138.480.031ZZ2222111（）22QLkk2222111（）22QLkk#1134.141135.96-0.0091129.161135.10.0001124.131135.10.001119.971135.10.001104.571135.10.001102.441135.10.001099.171135.10.001098.141135.10.00坝址求和0.06;断面编号桩号m断面间距m河底高程m水位10+000.00001098实际流量1098.13;水位m断面宽m面积m2湿周m选用的数据5%的流量Q1098.151098.010.2200.2220%的流量Q1098.141098.020.4500.45主河道糙率n水面比降J水力半径R1098.030.670.010.670.050.040.0149253731098.040.890.020.90.050.040.0222222221098.051.120.031.120.050.040.0267857141098.061.340.041.350.050.040.029629631098.071.560.051.570.050.040.0318471341098.081.790.071.80.050.040.0388888891098.092.010.092.020.050.040.0445544551098.12.230.112.240.050.040.0491071431098.112.460.142.470.050.040.0566801621098.122.680.162.690.050.040.0594795541098.132.90.192.920.050.040.0650684931098.143.130.223.140.050.040.0700636941098.153.350.253.370.050.040.0741839761098.163.570.293.590.050.040.0807799441098.173.80.323.820.050.040.0837696341098.184.020.364.040.050.040.0891089111098.194.240.44.260.050.040.0938967141098.24.470.454.490.050.040.1002227171098.214.690.494.710.050.040.104033971098.224.910.544.940.050.040.1093117411098.235.140.595.160.050.040.1143410851098.245.360.645.390.050.040.1187384041098.255.580.75.610.050.040.1247771841098.265.810.755.840.050.040.1284246581098.276.030.816.060.050.040.1336633661098.286.250.886.281098.296.480.946.511098.36.71.016.731098.316.921.076.961098.327.151.147.181098.337.371.227.411098.347.591.297.631098.357.821.377.861098.368.041.458.081098.378.261.538.31098.388.491.618.531098.398.711.78.751098.48.931.798.981098.419.161.889.21098.429.381.979.431098.439.62.069.651098.449.832.169.881098.4510.052.2610.11098.4610.272.3610.321098.4710.52.4710.551098.4810.722.5710.771098.4910.942.68111098.511.172.7911.221098.5111.392.911.451098.5211.613.0211.671098.5311.843.1411.91098.5412.063.2612.121098.5512.283.3812.341098.5612.513.512.571098.5712.733.6312.791098.5812.953.7613.021098.5913.183.8913.241098.613.44.0213.471098.6113.624.1613.691098.6213.854.2913.921098.6314.074.4314.141098.6414.294.5714.361098.6514.524.7214.591098.6614.744.8614.811098.6714.965.0115.041098.6815.195.1615.261098.6915.415.3215.491098.715.635.4715.711098.7115.865.6315.941098.7216.085.7916.161098.7316.35.9516.381098.7416.536.1216.611098.7516.756.2816.831098.7616.976.4517.061098.7717.26.6217.281098.7817.426.7917.511098.7917.646.9717.731098.817.877.1517.961098.8118.097.3318.181098.8218.317.5118.41098.8318.547.6918.631098.8418.767.8818.851098.8518.988.0719.081098.8619.218.2619.31098.8719.438.4519.531098.8819.658.6519.751098.8919.888.8519.981098.920.19.0520.21098.9120.339.2520.421098.9220.559.4520.651098.9320.779.6620.871098.94219.8721.11098.9521.2210.0821.321098.9621.4410.2921.551098.9721.6710.5121.771098.9821.8910.73221098.9922.1110.9522.22109922.3411.1722.441099.0122.5611.3922.671099.0222.7811.6222.891099.0323.0111.8523.121099.0423.2312.0823.341099.0523.4512.3123.571099.0623.6812.5523.791099.0723.912.7924.021099.0824.1213.0324.241099.0924.3513.2724.461099.124.5713.5124.691099.1124.7913.7624.911099.1225.0214.0125.141099.1325.2414.2625.361099.1425.4614.5125.591099.1525.6914.7725.811099.1625.9115.0326.041099.1726.1315.2926.261099.1826.3615.5526.481099.1926.5815.8126.711099.226.816.0826.931099.2127.0316.3527.161099.2227.2516.6227.381099.2327.4716.927.611099.2427.717.1727.831099.2527.9217.4528.051099.2628.1417.7