Excel规划求解在柱蚕水库库容曲线拟合中的应用

Application of Excel programming solution tool in storage capacity curve fitting of Zhucan Reservoir

精准的库容曲线关系是科学合理实施水库调度的技术支撑,关系着水库的防洪安全和综合利用效益的充分发挥。本文介绍一种应用Excel软件中的图形处理和规划求解功能拟合柱蚕水库库容曲线,简化了手工绘制库容曲线的工作量,提高了定线效率及库容曲线精度。经过拟合后的曲线和函数表达式可直接用于计算机进行库容曲线的分析和应用处理。

Accurate storage curve relationship is the technical support for the scientific and reasonable implementation of reservoir regulation,and is related to flood control safety and comprehensive utilization benefits of reservoir.The author presents how to use the graphic processing and programming solution functions of Excel software to fit the storage capacity curve of Zhucan Reservoir,so as to simplify the workload of manually drawing storage capacity curve,improve the alignment efficiency and the accuracy of storage capacity curve.The fitted curves and function expressions can be directly used for computer analysis and application processing of storage capacity curve.