Excel VBA技术在水域工程地震勘探中的应用
|
摘要
Excel VBA(Visual Basic for Application)是一种面向对象程序设计语言,具有简单易用,开发功能强大等优点,可实现从"定型软件应用程序"到"软件构造模块"的转变,进而可为广大工程技术人员提供极大的方便。这里在学习Excel VBA技术的基础上,初步研究了该技术在工程地震勘探领域中的应用。通过研究水域走航式浅层反射地震勘探资料的预整理过程中存在的效率问题,采用Excel VBA技术编制了"水域走航式浅层反射地震勘探预整理系统"。目前,该系统已成功应用于福建省建筑设计研究院勘察分院的实际水域工程地震勘探项目当中,极大地提高了资料整理的效率,并降低了出错的概率。
Excel VBA(Visual Basic for Application)is an Object-oriented programming language,and has the characteristics of simplicity and powerful development function.It also makes converting of the "setting type of software application" to "the module of software building".So,It provides great conveniences for vast engineers.In this paper,we study the application of the technology in engineering seismic exploration on the basis of learning Excel VBA Technology.After studying the efficiency problem of the datum pre-process in shallow seismic reflection exploration of walk-navigation pattern in watered areas,we develop the software by means of Excel VBA technology,named "Pre-processing System of Water Area Shallow Seismic Reflection Exploration of Walk-Navigation Pattern ".At present,we successfully apply the system to the actual projects of marine engineering seismic exploration to improve efficiency and to decrease the probability of errors.
Excel VBA(Visual Basic for Application)is an Object-oriented programming language,and has the characteristics of simplicity and powerful development function.It also makes converting of the "setting type of software application" to "the module of software building".So,It provides great conveniences for vast engineers.In this paper,we study the application of the technology in engineering seismic exploration on the basis of learning Excel VBA Technology.After studying the efficiency problem of the datum pre-process in shallow seismic reflection exploration of walk-navigation pattern in watered areas,we develop the software by means of Excel VBA technology,named "Pre-processing System of Water Area Shallow Seismic Reflection Exploration of Walk-Navigation Pattern ".At present,we successfully apply the system to the actual projects of marine engineering seismic exploration to improve efficiency and to decrease the probability of errors.
引文
[1]石海荣.用VBA在EXCEL中进行土层物理力学指标统计[J].工程地质计算机应用,2000,19(4):23.
[2]杜茂康.Excel与数据处理[M].北京:电子工业出版社,2002.
[3]黄文斌,马容山.EXCEL加VBA用于边坡稳定计算之探索与实践[J].工程地质计算机应用,2003,32(4):19.
[4]孙敬杰.Excel VBA入门与实例演练[M].北京:中国青年出版社,2005.
[5]韩小良,韩舒婷.Excel VBA从入门到精通[M].北京:中国铁道出版社,2006.
[6]北京博彦科技发展有限责任公司.Office VBA编程高手[M].北京:北京大学出版社,2000.
[7]刘宏岳.水域浅层地震反射波勘探数据处理及工程实例[J].福建建设科技,2008,(2):28.
[8]李哲生.水域地震法工程物探的震源、数据处理及工程应用[J].福建建筑,2000,70(S2):101.
[9]南方测绘仪器有限公司.水上工程-自由行操作手册[DB/CD].2006.
[2]杜茂康.Excel与数据处理[M].北京:电子工业出版社,2002.
[3]黄文斌,马容山.EXCEL加VBA用于边坡稳定计算之探索与实践[J].工程地质计算机应用,2003,32(4):19.
[4]孙敬杰.Excel VBA入门与实例演练[M].北京:中国青年出版社,2005.
[5]韩小良,韩舒婷.Excel VBA从入门到精通[M].北京:中国铁道出版社,2006.
[6]北京博彦科技发展有限责任公司.Office VBA编程高手[M].北京:北京大学出版社,2000.
[7]刘宏岳.水域浅层地震反射波勘探数据处理及工程实例[J].福建建设科技,2008,(2):28.
[8]李哲生.水域地震法工程物探的震源、数据处理及工程应用[J].福建建筑,2000,70(S2):101.
[9]南方测绘仪器有限公司.水上工程-自由行操作手册[DB/CD].2006.
版权所有：© 2023 中国地质图书馆 中国地质调查局地学文献中心