地下水监测井综合柱状图自动绘图工具软件的开发

Software Development of Automatic Drawing Tool for Groundwater Monitoring Well Comprehensive Histogram

为了提高地下水监测井综合柱状图的绘图效率,基于Excel软件和AutoCAD软件开发了一种绘图工具软件。绘图工具软件以Excel软件为数据存储模块和二次开发平台,以AutoCAD软件为图形绘制模块,以VBA语言编写的绘图程序作为数据处理模块。Excel绘图工作簿采用数据分类录入设计,有助于数据录入的结构化,便于数据的查验和修改;AutoCAD绘图模板采用分区绘制设计,使得成图规范化。运用绘图工具软件可实现地下水监测井综合柱状图绘制的自动化和标准化。

In order to improve the efficiency of drawing groundwater monitoring well comprehensive histogram,a drawing tool is developed based on Excel and AutoCAD.This drawing tool is composed of three parts,namely data storage module,drawing module and drawing program.Excel is the secondary development platform and data storage module.AutoCAD is the graphics drawing module.Drawing program written by VBA language is the data processing module.Data classification input design of monitoring wells in Excel drawing workbook is helpful for structured data entry and data checking.The partition design of AutoCAD drawing template makes drawing normalization.By using this drawing tool,automatic and standardized drawing of groundwater monitoring well comprehensive histogram could be realized.