Applications of Excel VBA in Data Processing of Magnetic Survey

Author

Du Ruiqing ; Sun Sanjian ; Ouyang Longbin ; Du Ruiqing

fYear

2012

fDate

11-13 Aug. 2012

Firstpage

2157

Lastpage

2160

Abstract

Magnetic survey is a geophysical method widely used in the mining industry. Its measuring data are often transferred to computers in the form of Excel files. In order to do further data processing conveniently, the data usually are preprocessed with VBA programs in Excel files. Excel VBA and data preprocessing of magnetic survey are introduced. Using VBA programs in Excel files to highlight anomalous measuring points and to insert information of missing points are illustrated. Excel VBA is useful for geophysicists to do some helpful works in magnetic survey..

Keywords

Visual BASIC; data handling; geophysics computing; mining industry; spreadsheet programs; Excel VBA programs; Excel files; Microsoft event-driven programming language Visual Basic 6; Visual Basic-for-Applications; anomalous measuring points; associated integrated development environment; data measurement; data processing; geophysical method; magnetic survey; mining industry; missing points; Data processing; Geologic measurements; Geophysical measurements; Magnetic field measurement; Magnetometers; Transmission line measurements; Visual BASIC; Excel VBA; data processing; magnetic anomaly; magnetic survey; program;

fLanguage

English

Publisher

ieee

Conference_Titel

Computer Science & Service System (CSSS), 2012 International Conference on

Conference_Location

Nanjing

Print_ISBN

978-1-4673-0721-5

Type

conf

DOI

10.1109/CSSS.2012.536

Filename

6394854