|Table of Contents|

To solve weight function of system theory with Excel(PDF)

《地球科学与环境学报》[ISSN:1672-6561/CN:61-1423/P]

Issue:
2005年第02期
Page:
78-81
Research Field:
Publishing date:

Info

Title:
To solve weight function of system theory with Excel
Author(s):
WANG Wei1; QIAN Hui1; MA Si-jin2
1.School of Environmental Sciences and Engineering,Chang’ an University, Xi’ an 710054,China; 2.Shaanxi Institute of Geological Survey,Xi’ an 710600,China
Keywords:
system theory;  sequence of weight function;  Excel 2002;  mathematic programming;  spring flow rate
PACS:
P641.8
DOI:
-
Abstract:
Based on the analysis of system theory to build the relationship between precipitation and spring flow rate, this pa- per 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.

References:

[1] 陈志新 , 李云 峰. 大同 市万泉 河流 域玄 武岩地 下水 开发 研究 [J] . 西安工程学院学报 , 2002 , 24(3):23 ～ 27.
[2] 房佩贤 , 卫中鼎 , 廖资 生. 专门水 文地质学[M] . 北京 :地 质出 版社 , 1987.
[3] 陈杰 , 朱国荣 , 王彩会. Excel 软件 优化 基坑降 水的 井群 设计 80 地球科学与环境学报 第 27 卷 [J] . 水文地质工程地质 , 2003 , 30(1):88 ～ 90.
[4] 王玮. 黑河水库单 薄山梁排 水洞方案 优选研究[J] . 西安工程 学院学报 , 2002 , 24(4):30 ～ 34.
[5] 徐恒力. 地下水系统 外部描 述方 法与结 构辨识[A] . 见 :中国 地质大学(武汉)水文系. 水文地质及 工程地质 论文集[C] . 武 汉 :中国地质出版社 , 1992.
[6] 袁亚湘 , 孙文瑜. 最优化理 论与方法[M] . 北 京 :科学 出版社 , 1999.
[7] 汪兴旺 , 党荣. 复杂工程系统优化设计 ———以某泥 石流防治工 程系统的优化设计为例[J] . 西安工程学院学报 , 2000 , 22(2): 44 ～ 49.
[8] 成伟 , 赵超英. 特殊条件下滑坡监测网的优 化设计[J] . 长安大 学学报(地球科学版), 2003 , 25(3):84 ～ 87.

Memo

Memo:
-
Last Update: 1900-01-01