CAJ | 학술논문

Excel是广大工程技术人员使用较多的软件，但多仅局限于简单的统计与公式计算。本文应用Excel丰富的公式、函数库和强大的图表制作功能，结合VBA可视化编程系统，研制开发的监测数据管理软件，集成了数据存储与处理、粗差探测、自动预警及图表制作等功能，减少了以往繁杂重复的人工操作，极大地提高了工作效率。
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 .