基于VBA的气象历史资料查询系统设计  

作　　者：房鹏 罗绍艳 郑自君 马献菊 王建嫱 

机构地区：[1]四川省凉山州气象局,四川西昌615000

出　　处：《科技创新与应用》2024年第11期119-122,126,共5页Technology Innovation and Application

基　　金：高原与盆地暴雨旱涝灾害四川省重点实验室科技发展基金项目(SCQXKJYJXMS202210)。

摘　　要：基于VBA编制气象历史资料查询系统,通过各控件的相应事件、调用公共程序、Excel函数,对用户提交的需求作出气象数据的统计、处理、结果显示,并可绘制等值线图。该系统可对某气象要素、任意时段历史资料进行统计和排序,对统计结果进行相对全面的展示,并对研究年份进行突出显示,利于气象业务人员更准确、全面地了解当年或历史气候状况,可为气象科研提供实用、便捷的气象资料统计工具,为相关部门或领导提供更准确、精细的气象参考。A meteorological historical data query system has been developed based on VBA.Through corresponding events,public programs and Excel functions of each control,we made statistics and processing of the meteorological data submitted by users.Based on these results,contour maps can be drawn.This system can perform statistics and sorting on a certain meteorological elements and historical data of any time period,display the statistical results relatively comprehensively,and highlight the research years.All this is beneficial for meteorological personnel to have a more accurate and comprehensive understanding of the current year or historical climate conditions,thereby can provide practical and convenient statistical tools of meteorological data for meteorological research and more accurate and detailed meteorological references for relevant departments or leaders.

关 键 词：VBA 程序设计 气象资料 查询系统 统计工具 

分 类 号：P409[天文地球—大气科学及气象学]