基于CAD和VBA地表移动观测站数据处理系统毕业论文.doc

毕业论文 PAGE PAGE II 本科毕业论文 基于CAD和VBA的地表移动观测站数据处理系统 DATA PROCESSING SYSTEM ON MINING AREA SURFACE MOVEMENT STATION BASED ON AUTOCAD VBA 基于CAD和VBA的地表移动观测站数据处理系统 摘 要 采用AutoCAD VBA二次开发技术，实现了地表移动观测数据处理、成图自动一体化。克服了传统方法成图只能查看、不易定量分析的缺点。在输出下沉、倾斜、曲率、水平移动、水平变形计算结果的同时，将其各曲线以一定比例在CAD中成图，可从曲线上量取任意点的对应值。且图中按原比例绘出对应地下煤层开采情况，可很方便地从图中直接量取各角量参数，距离参数。生成的曲线图更有利于直观现时地分析开采对地表的影响。 关键词：AutoCAD VBA；二次开发；地表移动变形；数据处理 DATA PROCESSING SYSTEM ON MINING AREA SURFACE MOVEMENT STATION BASED ON AUTOCAD VBA ABSTRACT AutoCAD VBA secondary development technique is used to realize the mining area surface movement observation data fast processing and automatic mapping in this paper. This way can overcome traditional methods’ shortcomings which only can make the map for watching, but not for quantitative analysis. The mining surface’s subside, lean, curvature, horizontal moving and horizontal deformation is calculated. And the all results are put out. At the same time each curve is drawn in AutoCAD with certain proportion. Any point’s value can be taken from the AutoCAD form. By the way, the underground coal mining condition is painted in the map with original proportion. So angle parameters and distance parameters can be easily measured and marked. All of the above can make the visual description on the surface deformation of the underground mining convenient and immediate. Key words: AutoCAD VBA; secondary development; surface movement and deformation; data processing 目录 TOC \o 1-3 \h \z \u 摘 要 h II ABSTRACT h III 绪论 h 1 1研究背景概述 h 1 1.1研究意义 h 1 1.2研究现状 h 2 1.2.1 国外研究现状 h 2 1.2.2 国内研究现状 h 3 1.3研究内容 h 4 1.4拟采用的研究思路与方法 h 4 1.4.1研究思路与方法 h 4 1.4.2技术路线图 h 5 2观测数据处理原理 h 6 2.1坐标规划 h 6 2.2移动和变形的计算 h 6 2.2.1 下沉 h 7 2.2.2倾斜 h 7 2.2.3曲率 h 7 2.2.4水平移动 h 7 2.2.5水平变形 h 8 3软件实现 h 9 3.1 AutoCAD VBA简介 h 9 3.2实现步骤 h 9 3.2.1 确定煤层采动信息 h 9 3.2.2 确定观测线基准点坐标 h 10 3.2.3读入观测数据进行坐标规划 h 11 3.2.4文件的打开，文件的导出与程序的退出 h 11 3.2.4 计算移动和变形 h 12 3