利用VBA和Excel实现快速处理国产甚低频电磁仪DDS-1测量数据

本文在介绍甚低频数据计算原理和VBA编程技术的基础上，结合实际工作需要，利用电子表格软件Excel和VBA编程模型编制VLF数据处理程序，实现甚低频电磁仪测量数据的自动处理，并对程序实现细节作了必要说明.实践表明，应用该处理程序可大大缩短数据处理时间、提高工作效率、降低劳动强度.

Quickly processing VLF-EM data from DDS 1 instrument using VBA and Excel

The VLF methods was first used for mineral prospecting around 1960, and can be used to find steeply dipping structures that differ from their surroundings with regard to electrical resistance. It is a powerful tool for regional geology investigation, especially in finding local tectonics. The DDS—1 instrument is portable, sensitive, easily\|operated geophysical instruments designed according to VLF methods, but these is not a special software to process the data collected in using this instrument which lead to the data processing is laborious, easy-error, time consuming. So it is necessary to develop computer software to quickly, accurately process the data and display the processing results graphically. In this paper, some procedures are implemented to dispose the data from DDS—1 instrument based on the theory of VLF(Very low frequency) and the technology of VBA(Visual basic for application). And they are compiled, stored in Excel. By these procedures and Excel software the processing of the data from this instrument is quiet easy, exact and efficient.