应用EXCEL VBA实现地震目录格式的转换  

CONVERSION OF EARTHQUAKE CATALOG FORMAT BY APPLICATION OF VBA EXCEL

作　　者：梁阿全[1] 梁跃[1] 马宝君[1] 李太岩 高双玲[1] 

机构地区：[1]黑龙江地震局牡丹江地震台,黑龙江牡丹江157009

出　　处：《高原地震》2016年第4期59-63,共5页Plateau Earthquake Research

基　　金：黑龙江省地震局一般性课题(项目编号:201601)资助

摘　　要：地震目录是地震学中基础资料。从相关网站下载的地震目录在进行地震分析预测研究之前,需要转换为相应的格式,以往这项工作都是人工完成,工作量大而且容易出错。以Excel VBA宏语言为工具,实现下载目录与地震分析预测目录之间自动转换,为进一步的科学研究提供详实可靠的基础资料。Earthquake catalogue is basic data in seismology. Before the analysis of earthquake prediction re- search,the earthquake catalog downloaded from relevant websites need to be converted to the corresponding format. This work is usually done manually, and this has heavy management working load and more mistakes. To Excel VBA macro language as the tool, download directory and automatic conversion between analysis and prediction of earthquake catalogue, in order to further scientific research to provide the basis of detailed and re- liable data.

关 键 词：EXCEL VBA 地震目录 格式转换 

分 类 号：P315[天文地球—地震学]