Excel与MapGis结合绘制钻孔柱状图的初步应用

The Application of Excel and MapGis in the Drawing of Borehole Log

在Excel表中直接输入或运用函数计算显示出一定格式的、MapGis可识别的数据,实现施工现场编录数据与MapGis软件的数据对接,通过一次数据投影获得钻孔柱状图的数据标注,可极大提高成图过程中数据录入的效率,节省大量人力资源,特别是在一些全孔取样的工程中更具有现实意义.

Data with certain format,which can be recognized by MapGis software,can be done in Excel worksheets by entering data directly or by formulas provided by Excel,so the data in borehole logging is linked to or changed into another form of data which can be accessed to MapGis.In MapGis,This form of data is also used to label the borehole log.It becomes more easily and rapidly to input data into MapGis,especially,it is of great significance to whole core sampling boreholes.