论文部分内容阅读
Excel是微软公司的办公软件系统Microsoft office组件之一,Excel支持VBA脚本语言,有独立的编程环境。使用vba脚本语言创建Excel宏可以把手工处理数据的步骤自动化,有效提高数据处理速度和效率。本文针对水文勘测资料,在已知河道断面瞬时水位、流量、含沙量情况下,应用Excel宏对水文数据进行自动化处理,实现了断面水沙量数据的快速计算。
Excel is one of the components of the Microsoft office software system Microsoft Office. Excel supports the VBA scripting language and has a separate programming environment. The creation of Excel macros using the Visual Basic Language can automate the steps of manually processing data, effectively increasing data processing speed and efficiency. In this paper, according to hydrological survey data, under the condition of knowing the instantaneous water level, flow rate and sediment concentration of the river section, the Excel macro is used to automate the hydrological data, and the quick calculation of the cross-section water and sediment data is realized.