基于Excel的半图解法在水库调洪计算中的应用  

Application of Semi-Graphic Method Based on Excel in Reservoir Flood Regulation Calculation

作　　者：王新华 张慧颖 黄辉曦 郭美华 WANG Xinhua;ZHANG Huiying;HUANG Huixi;GUO Meihua(College of Water Conservancy,Yunnan Agricultural University,Kunming 650201,China;Kunming Branch of Yunnan Provincial Hydrology and Water Resources Bureau,Kunming 650051,China)

机构地区：[1]云南农业大学水利学院,云南昆明650201 [2]云南省水文水资源局昆明分局,云南昆明650051

出　　处：《人民黄河》2021年第11期76-80,158,共6页Yellow River

基　　金：国家自然科学基金资助项目(51669035)。

摘　　要：相对于列表试算法而言,半图解法避免了大量的试算工作量,在人工调洪计算中广泛应用。使用该方法时要事先绘制水位—库容曲线、泄流量—库容曲线、单辅助曲线,并反复查算曲线,工作量仍然较大,效率不高。在分析半图解法基本原理和调洪计算步骤基础上,提出实现曲线查算的关键步骤是将平面坐标系下各种曲线进行分段,根据x值所处的横坐标区间段,利用线性内插法查出分段曲线上的纵坐标y值。利用Excel中内置的函数trend、offset、match嵌套使用,将曲线查算转化为求分段线性内插值,从而在Excel中实现半图解法调洪计算,大大提高了计算效率。Compared to the list-try algorithm,the semi-graphic method,avoiding a lot of trial calculating work,is widely used in artificial flood regulation calculation.The water level storage curve,discharge and storage curve,auxiliary curve should be drawn in advance when using this method.Curve drawing and repeated search,the workload is still large and the efficiency is not high.Based on the analysis of the basic principle of semi-graphic method and the calculation steps of flood regulation,this paper put forward that the key step to realize the curve calculation and search was to segment all kinds of curves in the plane coordinate system and find out the y-coordinate on the segmented curve according to the x-coordinate interval and x value by linear interpolation method.By using the embedded three functions commands of trend,offset and match,the semi-graphic flood regulation calculation could be realized in Excel by transforming the curves search into finding the linear interpolation of segmented line segments,which greatly improved the calculation efficiency of the method.

关 键 词：半图解法 调洪计算 trend函数 offset函数 match函数 EXCEL 

分 类 号：TV214[水利工程—水文学及水资源] TV697