天然河道水面线推求自动计算1.2.xls

1、桩号相关参数0+0000+000 河河道道糙糙率率0.0250+5000+500 起起始始水水位位8.041+0001+000 设设计计流流量量5491+5001+5002+0002+0002+5002+5003+0003+0003+5003+5004+0004+0004+5004+5005+0005+0005+5005+5006+0006+0006+5006+5007+0007+0007+5007+5008+0008+0008+5008+5009+0009+0009+5009+50010+000 10+00010+500 10+50011+100 11+10011+600 11+60012+

2、100 12+10012+600 12+60013+100 13+10013+600 13+60014+000 14+00015+500 15+50016+000 16+00017+500 17+50018+000 18+00019+500 19+50020+000 20+00021+500 21+50022+000 22+00023+500 23+50024+000 24+00025+500 25+50026+000 26+00027+500 27+50028+000 28+00029+500 29+50030+000 30+000程程序序使使用用说说明明：第第一一步步：输输入入各各断断面面

3、的的桩桩号号，及及相相关关参参数数。第第二二步步：在在“原原始始数数据据”工工作作表表中中输输入入原原始始测测量量断断面面坐坐标标数数据据。第第三三步步：在在“断断面面数数据据”工工作作表表中中的的AFAF列列输输入入各各断断面面水水位位分分段段的的最最高高水水位位。第第四四步步：在在“断断面面参参数数”工工作作表表中中AHAH列列中中的的白白色色单单元元格格中中输输入入各各断断面面水水位位分分段段步步长长。修修正正说说明明：本本版版本本修修正正了了1.11.1版版本本的的数数据据处处理理存存在在的的问问题题，在在1.11.1版版本本中中，纵纵坐坐标标把把堤堤防防外外的的部部分分断断面面面面积

4、积也也计计算算成成了了行行洪洪面面积积，本本次次修修正正了了该该缺缺陷陷。31+500 31+50032+000 32+00033+500 33+50034+000 34+00035+500 35+50036+100 36+10037+600 37+60038+100 38+10039+600 39+60040+100 40+10041+600 41+600程程序序使使用用说说明明：第第一一步步：输输入入各各断断面面的的桩桩号号，及及相相关关参参数数。第第二二步步：在在“原原始始数数据据”工工作作表表中中输输入入原原始始测测量量断断面面坐坐标标数数据据。第第三三步步：在在“断断面面数数据据”工

5、工作作表表中中的的AFAF列列输输入入各各断断面面水水位位分分段段的的最最高高水水位位。第第四四步步：在在“断断面面参参数数”工工作作表表中中AHAH列列中中的的白白色色单单元元格格中中输输入入各各断断面面水水位位分分段段步步长长。修修正正说说明明：本本版版本本修修正正了了1.11.1版版本本的的数数据据处处理理存存在在的的问问题题，在在1.11.1版版本本中中，纵纵坐坐标标把把堤堤防防外外的的部部分分断断面面面面积积也也计计算算成成了了行行洪洪面面积积，本本次次修修正正了了该该缺缺陷陷。天然河道断面测量数据整理表 桩号序号0+0000+0000+5000+5001-2.386,13.3342

6、-5.332,12.687420,13.3680,12.79531.59,13.31858.419,9.508349.397,11.078415.35,8.4397512.874,10.530521.162,7.4443614.775,9.128721.891,6.9369722.574,8.634052.508,6.9131829.653,7.598775.708,6.9269970.624,678.48,6.66521074.907,5.580.872,61178.091,4.284.449,4.81280.959,2.789.974,3.31387.935,394.618,2.71496

7、.104,4.5102.732,2.715110.236,5.5111.636,3.716119.631,6.0435114.248,517120.424,6.7367117.441,5.518139.071,7.9549119.518,6.019153.406,9.4261125.282,6.927320168.465,13.1476140.794,7.742421186.904,13.4487167.631,7.739722172.708,7.253723173.481,6.744224173.59,6.449425202.181,6.218326202.841,6.955227213.7

8、71,6.848328293031323334351+0001+0001+5001+5002+0002+000-2.496,13.1711-2.216,13.1035-3.287,12.86030,13.1910,13.1430,12.9252.315,13.07903.072,12.94642.59,12.769810.071,9.87338.933,10.428115.733,7.619415.768,8.373219.308,7.289321.792,6.770018.762,8.213463.03,7.091960.764,6.897022.138,7.075377.274,7.198

9、779.6,6.848880.189,6.833580.685,681.835,681.711,683.302,4.984.289,584.455,586.465,487.15,4.288.794,4.290.759,3.291.575,2.897.43,2.598.384,1.796.634,2.5105.445,2.5103.365,2.6104.365,2.5108.63,3.2109.422,2.6113.655,4116.298,5.2116.081,3.2118.205,5.2118.567,5.5118.258,5.2121.1,5.5121.549,6121.196,6123.

10、236,6133.113,7.5067129.213,7.1005129.556,6.4221163.457,6.9895135.693,8.0069131.588,7.0344168.909,6.0862206.593,6.7684161.541,6.7404200.745,6.1252209.678,7.0234214.479,6.5300212.545,6.7707217.247,9.4994224.461,9.9733213.122,7.1883219.833,9.9246229.398,9.9181224.819,11.0722221.012,10.6231227.713,11.04

11、49223.831,10.5510227.917,8.97192+5002+5003+0003+0003+5003+500-1.81,12.5789-2.977,13.3066-2.974,12.99150,12.8420,13.4150,13.1333.34,12.74242.791,13.36022.54,13.052514.246,8.195016.211,7.728413.639,9.290316.908,7.790731.59,7.023720.67,7.922217.875,7.086432.044,6.695033.264,7.244544.595,5.800443.172,6.

12、472769.995,7.288448.771,646.622,6.072.246,651.258,5.449.802,5.574.346,5.254.703,5.052.052,4.979.11,3.260.677,3.356.252,2.581.41,2.565.008,2.964.322,2.587.389,2.571.53,2.570.557,2.594.745,2.577.31,2.576.878,2.5100.825,2.986.627,4.981.981,4.8106.462,5.289.762,5.586.113,5.5110.388,5.592.843,689.311,611

13、3.052,696.453,7.224292.107,6.5492117.878,7.0064127.661,6.961098.686,7.8637145.664,7.2818212.483,6.0493136.483,7.6772224.428,6.7147215.866,6.5038263.688,6.4132506.605,7.5773220.042,7.8338271.286,9.7612511.886,10.6543223.33,9.6118273.718,9.8300515.007,10.8900228.591,9.75784+0004+0004+5004+5005+0005+00

14、0-2.269,13.0174-3.143,13.2241-2.653,13.22320,13.1790,13.3740,13.4493.329,13.05682.865,13.26234.231,13.220215.666,7.810812.227,8.814821.067,7.044116.957,7.762718.756,7.461762.251,6.893517.561,7.377236.382,6.835863.039,658.229,7.155559.238,6.672764.739,5.160.83,6.062.893,6.467169.026,4.563.376,564.371

15、,6.072.352,3.166.414,4.366.201,5.175.269,2.670.429,2.977.446,486.012,2.573.298,2.880.943,3.889.098,2.877.602,2.783.606,392.809,2.881.36,2.690.658,396.615,4.185.46,2.594.451,3.899.868,589.176,497.106,4.2102.257,6.093.654,5100.527,5.2104.89,7.328497.049,5.5105.403,5.5157.546,7.0260101.738,6.0107.969,6

16、.0348.575,7.7167103.861,7.5789110.806,7.5106351.141,8.5205132.673,7.7123158.693,6.9363352.601,8.2318181.82,7.4544306.795,7.0431387.071,5.3055308.521,8.4409389.583,7.2498310.58,7.7791405.178,7.3491417.37,11.6740421.256,11.64665+5005+5006+0006+0006+5006+500-4.483,13.2703-2.391,12.9097-6.01,13.50270,13

17、.4540,13.0340,13.4432.326,13.32415.56,13.04538.986,13.049620.797,8.066320.805,7.199221.127,8.140861.038,7.540061.466,6.806029.536,6.571165.698,6.063.62,6.0047.083,6.381967.727,5.265.364,5.347.905,5.959470.586,4.768.734,558.442,5.759372.443,3.571.806,3.959.725,6.339775.978,2.876.3,364.357,6.387688.84

18、1,2.779.665,2.665.085,6.033398.088,2.992.159,2.668.092,5.599.634,4.798.827,4.575.458,4.3101.045,5.2101.947,5.377.829,3105.075,5.6104.061,6.081.417,2.8105.898,6104.139,6.057786.047,2.6109.477,7.6344105.447,6.531895.16,2.3136.872,7.5150107.015,6.5200103.382,3177.368,7.6294107.437,5.9700110.816,3.5179.

19、512,6.2942112,4.97117.146,3.2115,3.97135.061,3.2119,3.17137.277,6127,3.17156.221,7.7877129,3.77176.952,9.3166150.0,4.2201.283,12.0502155,4.8207.438,12.3352160.517,6.00163.537,6.4962181.459,7.2136196.097,12.4975206.682,12.56997+0007+0007+5007+5008+0008+000-4.564,13.2866-4.18,13.4055-4.202,12.85740,13

20、.3130,13.4730,12.92.463,13.3142.834,13.3655.706,12.900413.427,7.535513.087,8.621417.807,7.083516.908,7.039920.746,6.715524.205,6.114241.313,6.369526.402,6.673031.931,642.995,639.019,644.701,5.647.64,5.543.375,5.547.789,5.249.588,546.966,5.250.729,4.551.576,4.549.931,4.254.32,453.797,455.576,3.657.14

21、7,3.858.095,3.360.387,2.861.224,2.862.109,2.663.541,2.873.709,365.958,2.576.779,2.976.823,3.270.509,2.581.4,3.481.316,3.578.244,2.685.575,3.986.489,482.335,3.390.024,4.490.481,4.586.265,4.296.046,5.399.768,5.591.794,4.5100.024,5.7102.69,694.898,5.1110.266,6103.524,6.7530100.717,5.4111.529,6.1416139.

22、25,6.1920102.858,5.4140.396,6.6234192.563,6.1897105.861,6181.627,7.0152106.584,6.1602195.657,11.1840142.192,6.2353197.831,11.1622147.06,8.7043155.759,12.4600164.037,12.47718+5008+5009+0009+0009+5009+500-4.394,12.7592-4.554,13.1749-4.353,12.41510,12.7440,13.2390,12.422.587,12.75652.335,13.0166.621,12

23、.425514.487,7.486718.045,7.325413.398,7.317716.006,7.298124.739,6.446326.142,6.106820.483,625.014,6122.822,6.420426.771,5.731.697,5.6123.267,631.711,5.344.92,4.5126.259,5.539.221,552.124,3.8129.425,548.268,358.23,2.8135.745,4.554.006,2.565.139,2.5141.1,466.151,2.670.541,2.5144.989,3.872.986,375.682,

24、2.7150.644,3.280.467,3.679.416,3155.908,2.889.363,484.658,3.5161.635,2.5125.673,488.129,3.5168.735,3134.997,4.397.866,5.2174.638,3.9145.933,4.2107.45,5.5180.695,4.5152.717,4.4114.004,5.5186.3,5158.207,4.2155.789,6191.355,4.5163.846,4159.145,6.0334202.419,4.5170.587,4.5172.614,6.8180207.921,5174.88,6

25、185.612,12.3104213.814,5.5174.806,8.5206191.244,11.9302216.856,6175.216,8.4592227.489,6.1767175.247,8.8455234.689,7.6355228.221,9.2836245.907,12.2604274.172,9.7646285.04,9.7351286.309,10.253310+00010+00010+50010+50011+10011+100-4.195,12.2576-4.416,12.3922-4.422,13.12300,12.290,12.420,13.151.697,12.2

26、925.549,12.4308.581,13.156010.105,7.52285.625,9.94262.45,12.228212.499,6.729613.687,7.65714.579,11.581820.532,5.717121.207,6.95867.184,11.045751.673,5.764749.369,7.156410.722,8.839469.244,6.187662.688,6.647813.52,8.7409120.821,6.493186.67,5.798220.458,6.8323121.029,696.353,5.846.445,5.9440125.782,5.

27、5103.655,5.566.299,5.9851128.135,5.2106.058,5.592.481,6.2355131.617,4.7110.895,5.396.161,5.8134.742,3.5112.476,5.0104.901,5.4138.746,3114.104,3.3112.357,4.6143.245,2.9117.036,2.7114.798,3.0151.049,2.6119.703,2.6118.284,2.7156.278,2.6124.269,2.5123.15,2.6162.169,2.9131.589,2.5128.806,2.5169.483,3.913

28、7.356,2.6133.948,2.5174.037,4144.644,2.7136.696,2.6178.62,5.5150.947,2.8140.632,2.7182.002,5.5156.174,4.5155.031,3184.959,6159.93,5.5157.025,4.6185.1,6.3519192.065,5.5161.347,5.3194.612,6.3874200.084,5.8185.991,5.8194.797,6.0415213.01,10.6179186.533,5.7834217.37,10.6320211.948,5.6631217.899,5.821123

29、1.251,10.4872235.877,10.720011+60011+60012+10012+10012+60012+600-4.357,13.9981-4.334,15.5277-12.615,13.84100,13.9920,15.528-4.355,14.5978.613,13.9817.581,15.54080,14.6081.57,13.53072.36,14.9491.63,14.60106.81,12.968612.953,14.20211.554,14.234725.588,8.478231.392,9.61346.165,12.395531.117,7.310234.61

30、7,9.309723.403,11.217740.746,6.496540.465,7.537835.701,7.273991.278,6.375948.901,6.552649.303,6.202095.18,5.884.327,6.462365.89,6.1431104.429,5.490.313,5.873.297,5.8110.318,4.8101.148,5.589.593,5.5114.12,2.7112.451,5.394.042,5.3117.111,2.6116.716,5.1100.05,5.1119.488,2.5121.324,3.7107.315,3.8125.045

31、,2.4127.086,2.7113.454,2.7129.101,2.5151.572,2.7119.569,2.5133.001,2.5157.835,2.8122.188,2.6136.759,2.7161.096,5.3129.328,2.6141.007,3174.267,5.4134.76,2.7152.331,5.3187.716,5.8147.08,2.7162.062,5.4202.19,7.4806155.295,5.1168.595,5.4226.063,14.4577163.088,5.3181.827,5.6238.841,14.2350172.094,5.6194.

32、226,5.8178.208,5.8196.747,6.3448184.759,6.5649203.76,7.3890208.934,13.5217217.33,13.531013+10013+10013+60013+60014+00014+000 15+50015+500 16+00016+000-9.16,13.4890-4.365,12.7122-2.386,13.3342-5.332,12.6874-2.496,13.1711-4.338,13.92240,12.7050,13.3680,12.7950,13.1910,13.927.511,12.68501.59,13.31858.4

33、19,9.50832.315,13.0790.595,13.924217.994,7.60769.397,11.078415.35,8.439710.071,9.87332.811,13.041330.072,6.160412.874,10.530521.162,7.444315.768,8.373224.842,7.768986.608,6.238914.775,9.128721.891,6.936918.762,8.213432.154,6.648486.66,5.822.574,8.634052.508,6.913122.138,7.075359.571,6.024997.529,5.329.653,7.598775.708,6.926980.189,6.833561.675,5.8100.983,4.870.624,678.48,6.665281.711,682.921,5.310