摘要
针对劳雷公司randan不同版本所生成的层厚度数据(.LAY,.CSV)文件在数据处理过程中操作重复性高,过程单调、乏味、效率低的问题,设计并编制探地雷达层厚度值提取应用程序(以后简称"厚度提取宏").分析传统探地雷达层厚度数据(.LAY,.CSV)文件处理的中间过程,确定厚度提取宏具有文件自由选取功能、外部数据导入功能、数据中间处理功能、数据文件批处理功能等共四大功能,设计对应的功能程序模块,编制厚度提取宏.厚度提取宏能一键化批处理一个文件夹下的所有探地雷达层厚度数据(.LAY,.CSV)文件,大幅度提高探地雷达数据文件处理效率.厚度提取宏简单易用,实用性强;将数据处理的中间过程后台化,避免数据文件处理过程中的误操作;相对于传统的层厚度数据处理方法,效率大幅度提高,有三十倍以上的效率优势;厚度提取宏具有拓展功能,如有需要,可拓展到其他探地雷达厂家数据文件的数据处理过程中.
According to the problems of high repeatability,monotonous,boring and low efficiency in the process of the data processing from the Rauray randan thickness of different versions of the generated（. LAY,. CSV） file. Design and compile GPR thickness value extraction application（ hereafter referred to as＂the thickness extraction macro ＂）. Analysis the process of data processing of the traditional GPR thickness data（. LAY,. CSV）.Determine the macro function with free file selection,external data input function,data intermediate processing function,batching data file function. Design corresponding function module and compile＂the thickness extraction macro＂with Excel VBA. The thickness extraction macro can be used to process once all ground penetrating radar（. LAY,. CSV） files in a folder,which improve greatly the efficiency of GPR data processing. The thickness extraction macro is simple and easy to use with strong practicability; The thickness extraction macro backstage the intermediating data processing and avoid human errors in the process of data file by one-key; Compared with the traditional layer thickness data processing method,the efficiency is greatly improved,and has more than thirty times the efficiency advantage; The thickness extraction macro has the function of expanding,and if necessary,it can be extended to the data processing of other manufacturers of GPR data files.
出处
《地球物理学进展》
CSCD
北大核心
2018年第1期441-444,共4页
Progress in Geophysics
基金
中铁科研院科研项目(2015-KJ027-Z027-03)资助
