摘要
Excel是广大工程技术人员使用较多的软件,但多仅局限于简单的统计与公式计算。本文应用Excel丰富的公式、函数库和强大的图表制作功能,结合VBA可视化编程系统,研制开发的监测数据管理软件,集成了数据存储与处理、粗差探测、自动预警及图表制作等功能,减少了以往繁杂重复的人工操作,极大地提高了工作效率。
Excel is a software used by a vast engineering and technical personnel, but often confined to simple statistics and formulas computation functions. In this paper, a monitoring data management software is developed combined with VBA visual programming system using the rich formula, libraries and powerful charting capabilities functions of Excel. This software integrates data storage and processing, gross error detection, automatic warning and charting functions, reduces the previous complex repeating manual operation, and improves the work efficiency greatly.
出处
《测绘与空间地理信息》
2014年第7期169-171,共3页
Geomatics & Spatial Information Technology
