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

摘要

传统电量统计分析采用简单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.The report 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.