利用Excel VBA实现区域气象观测站故障统计

Implementation of Regional Meteorological Observation Station Fault Statistics by Using Excel VBA

本文简要介绍了在Excel中VBA程序设计的有关知识,详细分析了如何运用ExcelVBA程序设计功能对区域站传输情况进行故障显示、形成报警信息、到报率统计、清理历史数据以及生成故障统计界面的功能实现方法,最后提出该软件可方便市县业务技术及管理人员快捷、准确、直观地对区域站进行故障统计,在基层气象部门有较广泛的应用推广价值。

This paper briefly introduces the knowledge about the design of VBA program in Excel, and also has a detailed analysis of how to use Excel VBA programming functions of fault display, alarm inforlnation, to form at the rate of statistics, to clean up history data and function of generating fault statistics interface implementa- tion method of regional station transmission. Finally, the article puts forward the software can facilitate the city or county technical or management personnel can quickly, accurately and intuitively to regional fault statistics stand, and this software has more extensive application and popularization value in meteorological departments at the grass-roots level.