利用 EXCEL 工具率定典型流量数学模型方法探讨

摘要

The article introduces the operating methods and steps of excellsolver fit discharge mathematic model, compares it with the inner graphics function in excel, and proves the superiority of excellsolver in fitting discharge mathematic model. Respectively based on the observed discharge data from natural river, reservoir and weir, and hydropower station, it applies excellsolver to fit different kinds of discharge mathematic model, and the results prove that it can meet the code requirement of hydrologic data processing.%介绍EXCEL【规划求解】功能拟合流量数学模型的操作方法和步骤，并与EXCEL内置图形函数拟合的流量数学模型进行对比分析，说明该功能拟合流量数学模型的优越性。分别以天然河道、水库堰闸、水电站实测流量系列资料为实例，应用该功能拟合不同类型的流量数学模型，结果表明【规划求解】功能拟合流量数学模型均能满足水文资料整编规范要求。