| 利用EXCEL工具率定典型流量数学模型方法探讨 |
| |
| 引用本文： | 黄清涛. 利用EXCEL工具率定典型流量数学模型方法探讨[J]. 水利信息化, 2014, 0(4) |
| |
| 作者姓名： | 黄清涛 |
| |
| 作者单位： | 湖北省水文水资源勘测局 |
| |
| 摘 要： | 介绍EXCEL【规划求解】功能拟合流量数学模型的操作方法和步骤,并与EXCEL内置图形函数拟合的流量数学模型进行对比分析,说明该功能拟合流量数学模型的优越性。分别以天然河道、水库堰闸、水电站实测流量系列资料为实例,应用该功能拟合不同类型的流量数学模型,结果表明【规划求解】功能拟合流量数学模型均能满足水文资料整编规范要求。
|
| 关 键 词： | 流量模型；规划求解；曲线拟合；EXCEL |
| 收稿时间： | 2014-03-07 |
| 修稿时间： | 2014-05-29 |
Research on the Method of Calibrating Typic Discharge Mathematic Model Using Excel Solver |
| |
| Abstract: | In this paper, we introduce how does excel solver fit discharge mathematic model, and compare it with the inner graphics function in excel, and prove the superiority of excel solver in fitting discharge mathematic model. Respectively based on the observed discharge data from natural river, reservoir and weir, and hydropower station, we apply excel solver to fit different kinds of discharge mathematic model, and the results prove that it can meet the code requirement of hydrologic data processing |
| |
| Keywords: | discharge model solver curve fitting excel |
| 本文献已被 CNKI 等数据库收录！ |
| 点击此处可从《水利信息化》浏览原始摘要信息 |
|
点击此处可从《水利信息化》下载免费的PDF全文 |
|
