基于VBA编程技术实现水文遥测数据的整编预处理

水文遥测系统是水文自动化的基础,通过遥测数据代替人工自记数据进行资料整编也是势在必行。然而,由于资料整编的数据要求高,目前的遥测数据还不能完全满足资料整编的需求,需要人工干预。如何简单快捷地对水文遥测数据进行预处理是本文研究的课题。文章提出了一套水位雨量的插补计算流程,以及折线逼近法挑潮值的计算流程,并通过VBA方式进行了实现,经过实际测试,效果良好。

Realization of pre-processing on compilation of hydrologic telemetry data based on VBA programming

Hydrological telemetry system is the basis of the hydrological automatization，and then replacing the manual recording data with the telemetry data for the data compilation is urgent to be done. However，because of the high requirement on the data compilation，the telemetry data cannot fully meet the demand of the compilation at present and the artificial intervention is necessary. How to make a simple and quick pre-processing of the hydrologic telemetry data is just the subject to be studied herein. A set of interpolation calculation processes for water level and rainfall and the process for calculating the tidewater level with the broken line approximation method are put forward and realized through the VBA（Visual Basic for Applications）programming，of which the effect is better through the actual test concerned.