摘要
在分析采用系统理论方法建立降水量与泉流量关系的原理基础上,结合实例建立起一套采用Excel2002求解系统理论权函数的方法,该方法根据预先给定的权序列长度与权函数初值,采用电子表格计算各观测泉流量实测值与计算值之间的误差平方和,并以此构造目标函数,再通过规划求解软件包计算出使目标函数最小化的权函数值,经反复调整权序列长度等指标可最终确定合理权函数序列。结果表明,该方法通过其强大的可视化功能,在确定权函数的合理性、提高计算效率等方面,具有明显的优势。
Based on the analysis of system theory to build the relationship between precipitation and spring flow rate, this paper built up a set of method for solving weight function using Excel 2002. In this method, according the pre-assigning length and initial value of weight function, the error quadratic sum between the observed value and calculated value of spring flow rate can be calculated using spreadsheet, and the object function can be built. Then, the weight that can minimize the object function can be solved by programming package. Through the error and trail method to adjust the length of weight function etc, the reasonable weight function can be ascertained finally. The results indicate that this method has distinct advantage in ascertaining the reasonable weight function and increasing efficiency via its visualization.
出处
《地球科学与环境学报》
CAS
2005年第2期78-81,共4页
Journal of Earth Sciences and Environment
基金
中国地质调查局地质调查项目(1212010331302)
