基于半图解法的MATLAB程序和Excel在水库调洪演算中的联合运用  

Joint Application of MATLAB Program and Excel Based on Semi-graphic Method in Reservoir Flood Control Calculation

作　　者：安航永 赵文龙 张雅萍 An Hangyong;Zhao Wenlong;Zhang Yaping(Guangzhou Yushan Water Survey and Design Co., Ltd. Guangzhou 511400, Guangdong;Huanghe Water Resources and Hydropower Development Corporation Zhengzhou 450000,Henan;Huanghe Construction Engineering Group Co.,Ltd. Zhengzhou 450000,Henan)

机构地区：[1]广州禺山水务勘测设计股份有限公司,广东广州511400 [2]黄河水利水电开发总公司,河南郑州450000 [3]黄河建工集团有限公司,河南郑州450000

出　　处：《陕西水利》2019年第4期69-71,76,共4页Shaanxi Water Resources

摘　　要：半图解法是水库调洪演算中较为常见的计算方法。在半图解法的基础上,提出借助MATLAB强大的数据处理能力和Excel的普遍适用性,联合运用MATLAB和Excel进行水库调洪演算。以官涌水库调洪演算为例,联合运用MATLAB程序和Excel进行调洪演算工作。结果表明,该方法即能节省大量的计算时间,又具有方便实用的人机交互性能。The semi-graphic method is a relatively common calculation method in reservoir flood control calculation.On the basis of the semi-graphic method, with the powerful data processing capability of MATLAB and the universal applicability of Excel, the joint use of MATLAB and Excel for reservoir flood control calculation. Taking the flood control calculation of Guanyong Reservoir as an example, the MATLAB program and Excel were used together to carry out the flood control calculation work. The results show that the method can save a lot of computing time and has convenient in practical human-computer interaction performance.

关 键 词：半图解法 MATLAB EXCEL 调洪演算 

分 类 号：TV697.11[水利工程—水利水电工程]