基于VBA对城市水文年鉴雨量前期数据处理的研究  

Research on Early-stage Data Processing of Rainfall in Urban Hydrological Yearbook Based on VBA

作　　者：仇东山 赵涛 岳潇静 Qiu Dongshan;Zhao Tao;Yue Xiaojing(Jinan Hydrology Bureau,Jinan 250002,Shandong)

机构地区：[1]济南市水文局,山东济南250002

出　　处：《陕西水利》2020年第5期45-47,52,共4页Shaanxi Water Resources

摘　　要：济南市城市水文年鉴的处理主要使用北方片区资料整编软件(BFZLZB),整编后的降水资料主要包括:逐日降水量表、降水量摘录表、各时段最大降水量表等数据表格,但在数据处理过程中,由于存在一些非标准化的原始数据文件,不能正确的进行雨量整编。主要研究基于VBA编程对来自不同建设管理单位的雨量原始数据进行前期处理,处理目标主要是对跨时段雨量进行插值处理,使之能进行合理的雨量整编,程序运行效果较好,提高了城市水文年鉴中雨量整编效率和数据的准确性。Jinan City Hydrological Yearbook is mainly processed by the northern area data compilation software(BFZLZB).The compiled precipitation data mainly includes:daily precipitation scale,precipitation excerpt table,maximum precipitation scale for each period of time and other data tables.However,in the data processing process,due to the existence of some non-standardized original data files,the rainfall cannot be correctly carried out reorganization.This paper studies the method of pre-processing the raw rainfall data from different construction management units based on VBA programming.The main goal of the treatment is to interpolate the inter-period rainfall,so that it can make reasonable rainfall adjustment.The program runs well and improves the efficiency of rainfall compilation and the accuracy of data in the urban hydrological yearbook.

关 键 词：VBA编程 雨量前期数据处理 降雨汇编 

分 类 号：TP391.1[自动化与计算机技术—计算机应用技术]