文章摘要
李 莉, 冷 艺, 黄 俊, 张 赛, 王子奇, 邹浩东, 洪毅怡晖, 符荣松.基于规划求解的暴雨强度公式推求方法研究Journal of Water Resources and Water Engineering[J].,2019,30(3):17-23
基于规划求解的暴雨强度公式推求方法研究
Study on the deducing method of rainstorm intensity formula based on excel solver add-in
  
DOI:10.11705/j.issn.1672-643X.2019.03.03
中文关键词: 海绵城市  暴雨强度公式  异常值  规划求解  高斯牛顿法
英文关键词: sponge city  rainstorm intensity formula  outlier  solver add-in  Gauss-Newton method
基金项目:科技部国家重点研发计划项目(2017YFC0404704)
Author NameAffiliation
LI Li1, LENG Yi2, HUANG Jun1, ZHANG Sai1, WANG Ziqi3, ZOU Haodong1, HONG Yiyihui1, FU Rongsong4 (1.重庆大学 三峡库区生态环境教育部重点实验室, 重庆 400045 2.中国交通建设股份有限公司 北京 100088 3.广东海洋大学 海洋与气象学院 广东 湛江 524088 4.重庆工业职业技术学院 重庆 401120) 
Hits: 1056
Download times: 667
中文摘要:
      在编制暴雨强度公式时,存在原始降雨资料中包含的异常值影响暴雨强度公式的准确度,皮尔逊-III型理论频率曲线拟合工作量大等问题。针对以上问题,阐述了异常值剔除的方法,分析了变异系数(Cv)、偏态系数(Cs)对皮尔逊-III型分布曲线拟合的影响规律。同时,基于重庆市酉阳县1993-2013年共计21 a的暴雨资料,采用Excel规划求解优化皮尔逊-III型分布曲线的拟合参数,分别利用基于规划求解的最小二乘法和高斯牛顿法,推求暴雨强度公式,并对其拟合精度和误差进行了对比分析。提出的规划求解法能有效避免拟合暴雨强度公式适线过程中目估适线法所导致的主观影响,通过对比分析解析了提高收敛速度和精度的暴雨强度总公式的推求方法。
英文摘要:
      The outliers in the original rainfall samples could affect the accuracy of the formula, and the Pearson -III theory frequency curve fitting required a large amount of work when deducing the rainstorm intensity formula. Therefore, several methods of removing outliers were introduced and the influence of the coefficient of variation (Cv) and the coefficient of skew (Cs) on the Pearson-III Distribution were evaluated. Meanwhile, formula of rainstorm intensity was calculated using Excel Solver Add-in to optimize the Pearson -III curve parameters by the least square method and Gauss-Newton method based on the rainstorm data of the total 21 years from 1993 to 2013 in Youyang County of Chongqing City, and the fitting accuracy and error were analyzed. This method could effectively avoid the subjectivity of empirical fitting by eye in the process of fitting Pearson-III Curve. Through comparison and analysis, the proposed method of calculating the general formula of rainstorm intensity can improve the convergence speed and the accuracy.
View Full Text   View/Add Comment  Download reader
Close
function PdfOpen(url){ var win="toolbar=no,location=no,directories=no,status=yes,menubar=yes,scrollbars=yes,resizable=yes"; window.open(url,"",win); } function openWin(url,w,h){ var win="toolbar=no,location=no,directories=no,status=no,menubar=no,scrollbars=yes,resizable=no,width=" + w + ",height=" + h; controlWindow=window.open(url,"",win); } &et=08EE5A5866ACE4401C867A8BD104D06C3034F4E0AF1E2115222289A0EFEEA381F9B7DB4B55624AC1E909DDF35AA08AECA47AD92089EB45F439DF31496338D9445E0FEA4B024EE594894D98EED42CA32485A1AEFAF09F68B552F594E29041B61B&pcid=5B3AB970F71A803DEACDC0559115BFCF0A068CD97DD29835&cid=3ECA06F115476E3F&jid=BC473CEDCB8CE70D7B12BDD8EA00FF44&yid=B6351343F4791CA3&aid=3843D31791085AFB419C1DCCF69AE96D&vid=&iid=38B194292C032A66&sid=BCA2697F357F2001&eid=EA389574707BDED3&fileno=20190303&flag=1&is_more=0">