| 利用EXCEL工具率定典型流量数学模型方法探讨 |
| |
| 引用本文： | 黄清涛,;王光义,;王建兴. 利用EXCEL工具率定典型流量数学模型方法探讨[J]. 水利水文自动化, 2014, 0(4): 28-31 |
| |
| 作者姓名： | 黄清涛, 王光义, 王建兴 |
| |
| 作者单位： | [1]湖北省随州市水文水资源勘测局,湖北随州441300; [2]湖北省襄阳市水文水资源勘测局,湖北襄阳441003; [3]湖北省黄石市水文水资源勘测局,湖北黄石435002 |
| |
| 摘 要： | 介绍EXCEL【规划求解】功能拟合流量数学模型的操作方法和步骤，并与EXCEL内置图形函数拟合的流量数学模型进行对比分析，说明该功能拟合流量数学模型的优越性。分别以天然河道、水库堰闸、水电站实测流量系列资料为实例，应用该功能拟合不同类型的流量数学模型，结果表明【规划求解】功能拟合流量数学模型均能满足水文资料整编规范要求。
|
| 关 键 词： | 流量模型 规划求解 曲线拟合 EXCEL |
Research on Method of Calibrating Typic DischargeMathematic Model Using Excel Solver |
| |
| Affiliation: | HUANG Qingtao , WANG Guangyi , WANG Jianxing (1. Suizhou Hydrology and Water Resources Survey Bureau of Hubei Province, Suizhou 441300, China; 2. Xiangyang Hydrology and Water Resources Survey Bureau of Hubei Province, Xiangyang 441003, Chinan 3. Huangshi Hydrology and Water Resources Survey Bureau of Hubei Province, Huangshi 435002, China) |
| |
| Abstract: | The article introduces the operating methods and steps of excel solver fit discharge mathematic model, compares it with the inner graphics function in excel, and proves 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, it applies excel solver to fit different kinds of discharge mathematic model, and the results prove that it can meet that it can meet the code requirement of hydrologic data processing. |
| |
| Keywords: | discharge model solver curve fitting excel |
| 本文献已被 维普 等数据库收录！ |
|
