等级水准项目分析可视化程序的设计与应用
Design and Application of Visualization Program for Grade Leveling Project Analysis
王广海 1许言海 2徐红晶 1王博1
作者信息
- 1. 自然资源部第二大地测量队,黑龙江哈尔滨 150025
- 2. 黑龙江测绘地理信息局后勤管理中心,黑龙江哈尔滨 150081
- 折叠
摘要
国家基本网及区域性精密水准网复测项目中水准观测路线分布广、高差变化大,简单的作业工期计算与实际工作情况偏差较大,造成项目投入与生产实际不符,不是资源浪费就是投入不足延误工期.精确的路线分析、准确的工作计划是项目高效实施的保证,快速的修改、可视化的计划表格输出更适应现如今的生产需要.本文阐述了采用VBA开发Microsoft Office Excel制作一款等级水准项目分析可视化程序,主要用于等级水准项目的路线分析,生成各种生产计划类图表作为项目执行的数据参考.
Abstract
In the national basic network and regional precision leveling network releveling project,leveling observation routes are wide-ly distributed and the height difference changes greatly. There is a big deviation between the simple calculation of operation duration and the actual work situation,which causes the project investment to be inconsistent with the actual production,either wasting re-sources or delaying the construction period due to insufficient investment. Accurate route analysis and accurate work plan are the guar-antee for efficient implementation of the project. The rapid modification and visual output of planning table are more suitable for today' s production needs. This paper describes the use of Microsoft Office Excel with VBA to develop a visual project analysis program of grade leveling projects,which is mainly used to analyze the route of grade leveling projects and generate various production planning charts as data reference for project implementation.
关键词
国家基本网/区域性精密水准网/重站比/VBAKey words
national basic network/regional precision leveling network/repeated station ratio/VBA引用本文复制引用
出版年
2024
NETL
NSTL
万方数据