基于VBA技术的航道流速流向成图的实现

Implementation of ChannelSurface Current Velocity Chart Based on VBA Programming Technology

本文提出了山区河段流速、流向数据处理的系统框架,基于Excel强大的函数计算及数据统计功能,实现数据处理算法与系统集成。生成的成果数据进入CASS软件,最终生成了航道流速流向图。最后,以嘉陵江重庆段航道滩险流速流向项目实例,验证了该数据处理方法的可靠性。

This paper presented a system framework for data processing of flow velocity and flow direction in mountainous rivers.Based on Excel's powerful functions of function calculation and data statistics,data processing algorithm and system integration were realized.The result data was entered into CASS software,and the flow chart of the channel was finally generated.Finally,the reliability of the data processing method was validated by an example of the current velocity and direction of the Jialing River in Chongqing section.