利用规划求解拟合水位流量关系曲线探讨  

Discussion on Fitting the Relation Curve of Water level and Flow by Programming Solver

作　　者：郭毅轩 李培侠 刘莉 Guo Yixuan;Li Peixia;Liu Li(Baoji Hydrology and Water Resources Survey Center,Baoji 721000,Shaanxi)

机构地区：[1]宝鸡市水文水资源勘测中心,陕西宝鸡721000

出　　处：《陕西水利》2023年第1期45-47,共3页Shaanxi Water Resources

摘　　要：控制条件稳定的测站水位流量关系也保持稳定,通常采用单一曲线法推求流量。利用Excel规划求解功能,建立指数函数模型,拟合水位流量关系曲线,通过检验分析,拟合结果满足水文资料整编规范要求。此方法易操作上手,能够提高工作效率和拟合精度,具有推广应用价值。The relationship between water level and flow in the stations with stable control conditions is also stable, and the flow is usually calculated by the single curve method. By using the Excel programming solving function, an exponential function model is established to fit the water level-discharge relation curve. Through inspection and analysis, the fitting results meet the requirements of the hydrological data compilation specification. This method is easy to operate, can improve the work efficiency and fitting accuracy, and has the value of popularization and application.

关 键 词：规划求解 水位流量关系 曲线检验 

分 类 号：P333[天文地球—水文科学]