| 基于Excel VBA的监测数据管理软件的研制与开发 |
| |
| 引用本文： | 邬昱昆,葛妹,谢新宇.基于Excel VBA的监测数据管理软件的研制与开发[J].测绘与空间地理信息,2014(7):169-171. |
| |
| 作者姓名： | 邬昱昆 葛妹 谢新宇 |
| |
| 作者单位： | [1]中国水电顾问集团中南勘测设计研究院,湖南长沙410014 [2]长沙市规划勘测设计研究院,湖南长沙410007 |
| |
| 摘 要： | Excel是广大工程技术人员使用较多的软件,但多仅局限于简单的统计与公式计算。本文应用Excel丰富的公式、函数库和强大的图表制作功能,结合VBA可视化编程系统,研制开发的监测数据管理软件,集成了数据存储与处理、粗差探测、自动预警及图表制作等功能,减少了以往繁杂重复的人工操作,极大地提高了工作效率。
|
| 关 键 词： | Excel VBA 安全监测 数据处理 软件开发 |
Research and Development of Monitoring Data Management Software Based on Excel VBA |
| |
| Institution: | WU Yu - kun , GE Mei, XIE Xin - yu ( 1. Hydro - China Zhongnan Engineering Corporation, Changsha 410014, China; Changsha Urban Planning Design ＆ Survey Research Institute, Changsha 410007, China) |
| |
| Abstract: | 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. |
| |
| Keywords: | Excel VBA safety monitoring data processing software development |
| 本文献已被 CNKI 维普 等数据库收录！ |
|
