应用EXCEL和MAPCAD快速生成地质钻孔柱状图

THE RAPID DRAWING OF DRILL COLUMN WITH EXCEL AND MAPCAD

传统手工绘制地质钻孔柱状图,不仅效率低且易出错。开发独立的地质钻孔柱状图处理软件有相当难度,而且需要投资。本文探讨运用MicroSoftOfficeEXCEL输入、检查地质钻孔柱状图原始编录数据,并用VB编制程序将EXCEL与图形处理软件MAPCAD有机结合,快速生成地质钻孔柱状图方法。充分利用现有资源,无需额外投资,具有较好实用性。

The drill column drawing with traditional manual method is not only low officency but (also) easy mistake-making.In this paper,we have a discussion about the rapid drawing method of drill column using Microsoft-Office EXCEL to input and check the original log of drill hole and using VB program for combining the EXCEL and MAPCAD.This method can fully use the present resources without extra invesiment and has good application value in production.