利用Excel VBA录入爆炸物品编号的方法

Method of mangement of the explosives code with Excel VBA

地震勘探中,常常需要将炸药(84#)、雷管(85#)的编号录入电脑,传统的手工录入方法效率低、出错率高。利用Microsoft Office Excel VBA开发工具,编制录入模板,可大大提高数据录入效率,提高录入数据的准确性。本文分析了传统录入方法的弊端及新方法的详细操作方法。

In seismic prospecting, we need to input the explosives coder and number to the computer, such as explosives （84 # ）, detonators （85 # ）. The traditional manual method proved to be of low efficiency and high error rate. Using Microsoft Excel VBA development tools, the preparation of input template, can greatly improve the efficiency and ensure the data quality.