等级水准项目分析可视化程序的设计与应用

Design and Application of Visualization Program for Grade Leveling Project Analysis

国家基本网及区域性精密水准网复测项目中水准观测路线分布广、高差变化大,简单的作业工期计算与实际工作情况偏差较大,造成项目投入与生产实际不符,不是资源浪费就是投入不足延误工期。精确的路线分析、准确的工作计划是项目高效实施的保证,快速的修改、可视化的计划表格输出更适应现如今的生产需要。本文阐述了采用VBA开发Microsoft Office Excel制作一款等级水准项目分析可视化程序,主要用于等级水准项目的路线分析,生成各种生产计划类图表作为项目执行的数据参考。

In the national basic network and regional precision leveling network releveling project,leveling observation routes are widely 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 resources or delaying the construction period due to insufficient investment.Accurate route analysis and accurate work plan are the guarantee 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.