摘要
在对周界入侵告警系统指标评判需求和告警记录特点进行深入分析的基础上,利用Excel VBA设计并实现了告警记录聚类、入侵事件关联、干扰事件关联等功能。通过对已知信息数据的综合分析处理,成功实现了对周界入侵告警系统漏报率、误报率、响应时间、定位精度等指标参数的快速计算。研究结果表明,基于Excel VBA的数据处理方法能够准确且迅速地完成告警记录信息的分析处理,满足周界入侵系统指标评判的需求,极大地提升了工作效率。
Based on the in-depth analysis of the index evaluation requirements and alarm record characteristics of the perimeter intrusion alarm system,Excel VBA design is used to realize the functions of alarm record clustering,intrusion event correlation,interference event correlation,etc.,and through the comprehensive analysis and processing of known information data,the rapid calculation of the false negative rate,false alarm rate,response time,positioning accuracy and other index parameters of the perimeter intrusion alarm system is realized.The results show that the data processing based on Excel VBA can accurately and quickly complete the analysis and processing of alarm record information,meet the requirements of perimeter intrusion system index evaluation,and greatly improve work efficiency.
作者
贾领柱
刘广建
苗振坤
JIA Lingzhu;LIU Guangjian;MIAO Zhenkun(63677 Troops,Urumqi,841700,China)
出处
《计算机应用文摘》
2024年第1期89-93,共5页
Chinese Journal of Computer Application
