基于EXCEL的水文频率计算软件开发

Development of calculation software on hydrologic frequency based on EXCEL

以W indow s XP,M icrosoft EXCEL和VBA为开发环境,研制了一套集绘图与计算于一体的水文频率分析软件,其中包含了常用的Γ分布、极值分布、正态分布和对数正态分布4种频率分布线型。该软件采用矩法初估水文系列的均值和变差系数(CV),采用权函数法初估偏态系数(CS),既可进行单水文要素的频率分析,也可进行多水文要素的频率曲线合成。

Taking WindowsXP,Microsoft EXCEL and VBA as tools ,a series of software system on hydrologic frequency analysis which integrated the ability of graph and calculation was developed. And it contained four kinds of frequency distributions .Г-distribution ,extreme value distribution,normal distribution and logarithmic normal distribution. In its operation,one can get mean value and coefficient of variation of hydrologic series from the square methods ,and coefficient of skewness from weight function method. The software can be used to analyse either single factor frequency or multi-factors frequency.