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

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

《天然河道水面线推求自动计算1.2.xls》由会员分享，可在线阅读，更多相关《天然河道水面线推求自动计算1.2.xls（161页珍藏版）》请在冰点文库上搜索。

桩号相关参数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+00010+00010+50010+50011+10011+10011+60011+60012+10012+10012+60012+60013+10013+10013+60013+60014+00014+00015+50015+50016+00016+00017+50017+50018+00018+00019+50019+50020+00020+00021+50021+50022+00022+00023+50023+50024+00024+00025+50025+50026+00026+00027+50027+50028+00028+00029+50029+50030+00030+000程程序序使使用用说说明明：

第第一一步步：

输输入入各各断断面面的的桩桩号号，及及相相关关参参数数。

第第二二步步：

在在“原原始始数数据据”工工作作表表中中输输入入原原始始测测量量断断面面坐坐标标数数据据。

第第三三步步：

在在“断断面面数数据据”工工作作表表中中的的AFAF列列输输入入各各断断面面水水位位分分段段的的最最高高水水位位。

第第四四步步：

在在“断断面面参参数数”工工作作表表中中AHAH列列中中的的白白色色单单元元格格中中输输入入各各断断面面水水位位分分段段步步长长。

修修正正说说明明：

本本版版本本修修正正了了1.11.1版版本本的的数数据据处处理理存存在在的的问问题题，在在1.11.1版版本本中中，纵纵坐坐标标把把堤堤防防外外的的部部分分断断面面面面积积也也计计算算成成了了行行洪洪面面积积，本本次次修修正正了了该该缺缺陷陷。

31+50031+50032+00032+00033+50033+50034+00034+00035+50035+50036+10036+10037+60037+60038+10038+10039+60039+60040+10040+10041+60041+600程程序序使使用用说说明明：

第第一一步步：

输输入入各各断断面面的的桩桩号号，及及相相关关参参数数。

第第二二步步：

在在“原原始始数数据据”工工作作表表中中输输入入原原始始测测量量断断面面坐坐标标数数据据。

第第三三步步：

在在“断断面面数数据据”工工作作表表中中的的AFAF列列输输入入各各断断面面水水位位分分段段的的最最高高水水位位。

第第四四步步：

在在“断断面面参参数数”工工作作表表中中AHAH列列中中的的白白色色单单元元格格中中输输入入各各断断面面水水位位分分段段步步长长。

修修正正说说明明：

本本版版本本修修正正了了1.11.1版版本本的的数数据据处处理理存存在在的的问问题题，在在1.11.1版版本本中中，纵纵坐坐标标把把堤堤防防外外的的部部分分断断面面面面积积也也计计算算成成了了行行洪洪面面积积，本本次次修修正正了了该该缺缺陷陷。

天然河道断面测量数据整理表桩号序号0+0000+0000+5000+5001-2.386,13.3342-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.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.771,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.198779.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.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.0449223.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.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,6113.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+000-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,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.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.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.841,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.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.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.147,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.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.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,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,6185.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.2925.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.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.9137.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.8211231.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.617,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,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.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+00015+50015+50016+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.419,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