基于自然语言处理和Office COM组件的电量智能统计分析系统  

SMART STATISTICAL ANALYSIS SYSTEM OF ELECTRICITY BASED ON NATURAL LANGUAGE PROCESSING AND OFFICE COM COMPONENTS

作　　者：李新利[1] 李昕其 马凯 李卫东 于磊[1] 

机构地区：[1]华北电力大学控制与计算机工程学院,北京102206 [2]国网辽宁省电力有限公司盘锦供电公司,辽宁盘锦124010 [3]国网河南省电力公司济源供电公司,河南济源459000

出　　处：《计算机应用与软件》2017年第12期107-110,共4页Computer Applications and Software

基　　金：中央高校基本科研业务费专项资助(2016MS48)

摘　　要：传统电量统计分析采用简单Excel功能,凭经验进行,不仅影响所分析的数据和分析质量,而且使供电企业难以进行正确决策。基于自然语言处理和Office COM组件,提出并设计研制一种电量智能统计分析系统。系统基于自然语言处理技术,分析定位各项重要指标数据,建立大用户生产系统和电量消耗模型。同时采用COM组件技术,快速提取指定Excel报表中的大量数据。对月度统计数据进行分析比对,生成相应表格、图像及分析文字,自动输出符合电力公司要求的报告文档。实际应用表明,该系统提高了电力公司对社会用电量分析的速度和质量,为电力生产经营提供了有力的数据支撑。The simple Excel function is usually used in the traditional statistical analysis of electricity, with manual experience. It not only affects the quality of data and analysis, but also makes it difficult for power supply enterprises to make the right decisions. Based on the natural language processing and Office COM components, a smart statistical analysis .system of electricity system is proposed and designed. The important indicators of data are analysed and located based on natural language processing technology. The model is established between large-user production systems and power consumption. At the same time, the COM component technology is used to extract quickly a large amount of data in the specified Excel report. The monthly statistical data are analysed and comprised, and appropriate forms, images and analysis of the text are generated. Thereport documents are automatically generated, which meet power company requirements. The practical application shows that the system improves the speed and quality of electricity consumption analysis, and provides powerful data support for power production and operation.

关 键 词：自然语言 OFFICE COM组件 电量统计 智能 数据处理 

分 类 号：TP3[自动化与计算机技术—计算机科学与技术]