摘要
为解决大型岩土工程勘察工作中,按勘探点类别绘制"勘探点平面布置图"工作时,专用勘察软件有的操作繁琐、灵活度不够、适应性不强、有时容量不够;手工采用"复制""粘帖"操作效率低且易出错,不能满足如今快节奏生产的要求等问题,开发一种利用Excel表格在CAD中按类别快速展绘勘探点技术。将Excel强大的数据计算处理功能和CAD强大的绘图功能结合起来,省略了"SCR脚本文件"的生成和调用环节,方法简单,易于操作,灵活多变,适应性强,方便进行批量调整和修改,数据容量大,一次能展绘10000个以上勘探点。形成模板后可重复使用,在较大的工程中具有一定的使用价值。
For solving the problems that the special investigation software with the complicated operation,bad elasticity,bad adaptability,sometime not enough capacity,lower handwork operation efficiency and easy to make mistake when conducting ＂copy＂ and ＂paste＂,can not meet the requirement of fast production when carrying out to plot the ＂location of exploratory point＂ by category of exploratory point during the large geological investigation process,this paper develops the fast plotting exploratory point technology by category in CAD with Excel form,combines the strong data calculation and process functions of Excel and the strong plotting functions of CAD,omits the form and transfer sector of ＂SCR script document＂,it is of the simple method,easy to operate,good elasticity,strong adaptability,conduct adjusting and revising in batches conveniently,large data capacity,and can plot more than 10000 exploratory points once time.It can be used repeatedly after forming formwork,is of certain usage value in large engineering.
出处
《计算机与现代化》
2013年第2期163-168,172,共7页
Computer and Modernization
关键词
EXCEL
宏
CAD
勘察
勘探点
按类别
快速展绘
Excel
macro
CAD
investigation
exploratory points
by category
fast plotting
