摘要
为快速完成罗盘仪测绘法的内业工作,提出各角点的坐标系转换、坐标平移,并采用三角形法计算平面图面积的数学方法,从而实现了平面图展绘、平差和面积计算过程。在此基础上,提出了计算平面图面积的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.
作者
赵浩彦
张洁
张民侠
姚树人
闫德民
陈戈萍
周涧青
ZHAO Haoyan;ZHANG Jie;ZHANG Minxia;YAO Shuren;YAN Demin;CHEN Geping;ZHOU Jianqing(Forest Fire Department, Nanjing Forest Police College, Nanjing 210023, China)
出处
《林业调查规划》
2018年第5期19-24,共6页
Forest Inventory and Planning
基金
江苏省教育信息化研究课题"江苏省林地面积和林木材积计算分析辅助工具的设计和开发(20172036)"
南京森林警察学院教研项目"我院创新人才培养模式下的生态学类课程教学改革研究"(YB15110)
江苏省自然科学基金项目"我国南方典型火烧迹地植被恢复动态研究"(BK20141501)
关键词
罗盘仪测绘法
三角形法
坐标系转换
平面图面积
展绘
平差
ExcelVBA算法
程序代码
compass traverse survey
triangle method
coordinate system transformation
area of planar graph
plotting
adjustment
ExcelVBA algorithm
procedure code
作者简介
赵浩彦(1982一),男,山西人,博士,讲师.主要研究方向:森林可持续经营.Email:469640903@qq.com;责任作者:张洁(1970一),女,副教授,博士.主要研究方向:森林可持续经营.
