|
|
|
| Fitting relation curve between water level and flow by Excel programming solution |
| Chen Xiaobo1,Gao Feng2,Wang Yongwei2,Wang Mingrui3 |
1. Anhui Hundred Years Refrigeration and Air Conditional System Co.,Ltd.,Hefei 230031;
2.Changchun Air Force Military Representative Office,Changchun 130012;
3.Changchun Meteorological Instrument Research Institute,Changchun 130012 |
|
|
|
|
Abstract According to actual measuring data of water level and flow, this paper focuses on methods and specific steps for fitting relation curve between water level and flow by Excel programming solution, which indicate that this method mentioned above is accurate,practical and valuable.
|
|
Received: 20 December 2012
|
|
|
|
|
|
| [1] |
马志云,郭彦双.Excel规划求解在水库管理中的应用[J].黑龙江水利科技,2010,38(6):74-75.
|
| [2] |
段文秀,刘长武,王丽丽.Excel在防汛工作中的应用[J].山东水利,2004(6):16.
|
| [3] |
唐阳春,张先哲.Excel在暴雨洪水查算中的应用[J].湖南水利水电,2006(3):70-71.
|
| [4] |
张云辉.三参数幂函数在水位～流量关系曲线拟合中的应用[J].东北水利水电,2012,30(6):45-46.
|
| [5] |
门宝辉,王学军,林运东.Excel在绘制复杂水力学函数曲线中的应用[J].东北水利水电,2001,19(7):34-35.
|
| [6] |
Excel Home.Excel应用大全[M].北京:人民邮电出版社,2008.
|
| [7] |
李智.电子表格Excel在水文工作中的应用[J].水资源研究,2003,24(3):13-17.
|
| [8] |
邓乃洋.无约束最优化方法[M].北京:科学出版社,1982.
|
| [9] |
张治文,何磊.中文Excel 7.0 for Windows 95教程[M].北京:科学出版社,1997.
|
| [10] |
张宏.Excel数据处理与分析[M].北京:电子工业出版社,2005.
|
| [11] |
何丽,周从直,谢有奎,等.Excel规划求解水—岩作用模型[J].地下空间与工程学报,2008(2):265-268.
|
| [12] |
陈生萍,田宏秀,黄天强.Excel规划求解在决策分析中的应用[J].吉首大学学报(自然科学版),2006,27(2):38.
|
|
|
|
2013, Vol. 30 
