计算罗盘仪测绘平面图面积的ExcelVBA算法与程序实现  

ExcelVBA Algorithm and Program Implementation Calculating the Area of Planar Graph Measured and Mapped by Compass

作　　者：赵浩彦[1] 张洁[1] 张民侠[1] 姚树人[1] 闫德民[1] 陈戈萍[1] 周涧青 ZHAO Haoyan;ZHANG Jie;ZHANG Minxia;YAO Shuren;YAN Demin;CHEN Geping;ZHOU Jianqing(Forest Fire Department, Nanjing Forest Police College, Nanjing 210023, China)

机构地区：[1]南京森林警察学院森林消防学院,江苏南京210023

出　　处：《林业调查规划》2018年第5期19-24,共6页Forest Inventory and Planning

基　　金：江苏省教育信息化研究课题"江苏省林地面积和林木材积计算分析辅助工具的设计和开发(20172036)";南京森林警察学院教研项目"我院创新人才培养模式下的生态学类课程教学改革研究"(YB15110);江苏省自然科学基金项目"我国南方典型火烧迹地植被恢复动态研究"(BK20141501)

摘　　要：为快速完成罗盘仪测绘法的内业工作,提出各角点的坐标系转换、坐标平移,并采用三角形法计算平面图面积的数学方法,从而实现了平面图展绘、平差和面积计算过程。在此基础上,提出了计算平面图面积的ExcelVBA算法并编写了相应的程序代码。结果显示,编写的计算平面图面积ExcelVBA程序不仅计算精度较高,且快速高效。In order to quickly complete interior work of compass traverse survey, some mathematical methods that coordinate system of all angular points was changed, coordinates of all angular points were horizontally moved and the area of planar graph was calculated with triangle method, were proposed in this paper, which implemented the process of plotting, adjustment and calculating area of planar graph. Then the ExcelVBA algorithm calculating area of planar graphs was proposed and corresponding codes were edited. The result showed that the ExcelVBA program calculating area of planar graph was higher in precision and faster in speed.

关 键 词：罗盘仪测绘法 三角形法 坐标系转换 平面图面积 展绘 平差 ExcelVBA算法 程序代码 

分 类 号：S711[农业科学—林学] P22[天文地球—大地测量学与测量工程]